Operator for grouping values

mbiclar
mbiclar New Altair Community Member
edited November 2024 in Community Q&A

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?

Tagged:

Best Answer

  • MartinLiebig
    MartinLiebig
    Altair Employee
    Answer ✓

    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

Answers

  • MartinLiebig
    MartinLiebig
    Altair Employee
    Answer ✓

    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
    mbiclar New Altair Community Member

    Hey Martin,

     

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

     

    Thanks!

     

     

    Regards,

    Conn

Categories