nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Cluster a mixture of continuous and catergorical variables

Peter_Hersh

I have a customer that wants to cluster a mixture of numeric and catergorical variables. I suggested binning the continous data and using latent class analysis. Does anyone else have other suggestions or techniques for this type of clustering.

Thanks,

Peter Hersh

Accepted answers

Laura_Higgins

Hierarchical Clustering takes both categorial and continous data for clustering. Turn on 2-way clustering for the best view for interpreation across variables.

All comments

Peter_Bartell

Pete:

How many levels for the categorical factor? If it's just a few and the levels might make practical sense...to remain differentiated, perhaps using a 'By' statement for each level could work too? I'm thinking something like residents of states? Where a mixing together people in various states might not make sense from a practical point of view depending on the problem at hand?

Peter_Hersh

Hey Peter,

Good suggestion.

It sounded like multiple catergorical factors mixed with a couple continous.

Laura_Higgins

Hierarchical Clustering takes both categorial and continous data for clustering. Turn on 2-way clustering for the best view for interpreation across variables.

Laura_Higgins

Here's a journal with a quick example - lots of great visualizations. You have to practice with the magnifier to read the lables, just fyi. Pivot on selected clusters is helpful too for moving things around.

Hierarchical Clustering.jrn