Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

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?

Find more posts tagged with

AI Studio

Accepted answers

MartinLiebig

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

All comments

MartinLiebig

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

mbiclar

Hey Martin,

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

Thanks!

Regards,

Conn