How to identify values with min-function?

eldenosoeldenoso Member Posts: 65 Contributor I
edited November 2018 in Help

Hello altogether,

 

currently I am facing a problem concerning the finding of specific numbers if my examples. What I am trying to achieve is to find the minimum of eight different columns for each row of the example set. Unfortunately it is possible that there is no distinct value for a minimun, e.g. that there are two min's of the same value, thus the generate attribute operator shows a question mark. Is there any work-around for that?

I attached a picture of the data.

 

 

P.S. the function used for the generate attribute operator is the following:

if(min([Ge Akr],[Ge Dpl],[Ge Kar],[Ge Pal],[Ge Rol],[Ge St],[Ge TTE])=="",1,min([Ge Akr],[Ge Dpl],[Ge Kar],[Ge Pal],[Ge Rol],[Ge St],[Ge TTE]))

Thank you for your help.

Philipp :-)

Best Answer

  • MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,503 RM Data Scientist
    Solution Accepted

    Hi,

     

    Generate Aggregation shoud be able to get you the minimum and then you check which attribute it is?

     

    Best,

    Martin

    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany

Answers

  • eldenosoeldenoso Member Posts: 65 Contributor I

    Thank you Martin,

    that workend perfectly! :-)

     

    Best,

    Philipp

Sign In or Register to comment.