Survey banner
The Dataiku Community is moving to a new home! Some short term disruption starting next week: LEARN MORE

Feature handing for many unique variables

Level 5
Feature handing for many unique variables

Hi everyone,

I have a feature in a model I am working on which has many unique values, DSS autoML solution initially toggled the feature off for this reason, but I am keen to see if it it could be a useful feature, as from a business perspective it's content is interesting.


What I would like to do is categorise only the most common values in the list, I looked in Feature Handling and came across the clipping options. My questions are:

  • Max nb. categories - will this keep the top x categories which appear most frequently, or just the first x identified?
  • Cumulative proportion - could I use this to retain features that appear in at least 10% of the data? I am not totally clear if this would give me the most frequent values, or if it's for other use cases?

Thanks for your help,


0 Kudos
1 Reply
Level 5

As a followup question to the above, I tried some experiments with the settings and got very different results.

For example when using the following settings:


I would expect here to only end up with 5 categories, but when I view a partial dependence plot in the model results I see:


Why am I seeing many more than 5 categories here?

I also tested the cumulative proportions setting, to see what this showed in the results:


in the partial dependence plot I again see more categories than I was expecting, but the results are also very different:


In this example we see "Jackets" scored negatively with the first settings, but it is positive here.

How can making such an apparently small change have such an impact of the results? 

0 Kudos