Compute value: transform observations

[tbijl@anwb.nl]

 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?

[calamari · Accepted solution]

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:

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

Hope that helps!

Calamari