cancel
Showing results for 
Search instead for 
Did you mean: 

Compute value: transform observations

tbijl@anwb.nl
Blue LED

 I would like to use an existing categorical feature and label the observations that don't occur more than 50 times as 'other'. Is that something I can do using Compute, or do I need a different functionality?

Labels (1)
1 Reply
calamari
DataRobot Employee
DataRobot Employee

Hi tbijl@anwb.nl ,

You will need to use a compute column, but you will also need to use Window -> Aggregate (Count) before this (to create a column that will contain the count).

Step 1) - Use Window -> Aggregate (Count) - screenshots below:

calamari_1-1619481192664.png

calamari_2-1619481213588.png

Step 2) Create the compute column based on that new column:

calamari_0-1619481145854.png

Hope that helps!

Calamari