This question is for using clustering for EDA in a structured dataset. My understanding is that k-means does not do well with categorical data because it cannot interpret means of non-numerical data. I've heard k-modes is a good alternative.
But can it be used for both categorical and numerical columns? Or is it just for categorical? Or, is there a more effective way to cluster mixed-type data?