Options

Operator for grouping values

mbiclarmbiclar Member Posts: 6 Contributor I
edited November 2018 in Help

Hi guys!

 

Just wondering what operator can I use to do an aggregation.

In one of my colums I have values from 1-100 and I would like them in to 4 groups; Values 1-25 would be named as "very poor", 26-50 would be "poor", 51-75 would be "average" and 76-100 would be "great", and I would like these labels to be in a new column.

 

Do you have any suggestions on how to do this?

Best Answer

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

    Hi,

     

    have a look at the discretize operators. I think you want to take Discritize by User Specification and maybe a Map afterwards.


    You could also do this with Generate Attributes.

     

    Best,

    Martin

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

Answers

  • Options
    mbiclarmbiclar Member Posts: 6 Contributor I

    Hey Martin,

     

    Thanks for that. I used the Generate attributes instead as that works much better for my data.

     

    Thanks!

     

     

    Regards,

    Conn

Sign In or Register to comment.