Correspondence Analysis with Excel data

Question

Good day.

I am trying to do correspondence analysis with data on elemental composition linked to qualitative categories. The ideal outcome here would be the production of a correspondence analysis chart showing the relationship between the elemental composition and the different categories. Could anyone explain to me the way to achieve this within the Alteryx designer program?

KGT · Answer

This might get more eyes in the machine learning forum, just because of the people who might know the answer.

In general, out of the box in Alteryx, continuous variables are compared using PCA from the Predictive Grouping category, and possibly K-Centroids, and categorical are using Market Basket. However, you may be looking for something more specific, and may need to build something in the R tool, or Python tool. You can do all the pre-processing etc in Alteryx, and then just call a package for the analysis and graph that you're after. If you want to see an example of this with the R Tool, then right click on one of the Predictive tools and open it (most should work to open).