High Cardinality regardless of Data Type

[ctaulbee]

I have a table with 5 columns and 1m rows of data.

My "Values" column has a high range of values from -196m to 189m and no matter what data type I assign it, the cardinality doesn't change. I have tried changing it to fixed decimal, decimal, whole number, splitting out the decimals, etc but in every single case the cardinality has not changed.

Am I missing something? How do i get the cardinality of this column down? It's encoded as Hash and takes up 19% of my total model right now.

[lbendlin]

The only way to reduce the cardinality is to remove information. In your case this would mean rounding your values to the nearest thousand, or even million. Likely not something you want to do?