RapidMiner

Operator for grouping values

SOLVED
Contributor II

Operator for grouping values

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
RMStaff
Solution
Accepted by topic author mbiclar
9 hours ago

Re: Operator for grouping values

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

--------------------------------------------------------------------------
Head of Data Science Services at RapidMiner
2 REPLIES
Highlighted
RMStaff
Solution
Accepted by topic author mbiclar
9 hours ago

Re: Operator for grouping values

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

--------------------------------------------------------------------------
Head of Data Science Services at RapidMiner
Contributor II

Re: Operator for grouping values

Hey Martin,

 

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

 

Thanks!

 

 

Regards,

Conn