Extracting Classification from Auto Model

Hi there

I used the auto model feature for the first time for a cluster analysis.
Now, I'd like to add a column to my data set indicating the cluster the specific company belongs to.

How do I extract the classification and add it to my data set?

Thank you in advance

Best regards
GL

Find more posts tagged with

AI Studio

Classification

Auto Model

Accepted answers

IngoRM

Ah, got it. Well, the order of the rows is the same. So you simply build a simple process to merge it back to the original data. Alternatively, and even simpler if you are not familiar with process design in RapidMiner, you can

export the clustered data to Turbo Prep,
add the original data set as a second data set to Turbo Prep as well,
click on Merge and select an Inner Join and activate the checkbox for Use Row Number as Key.
Update, Commit, Done.

Hope this helps,
Ingo

All comments

IngoRM

Hi @gianluca_scheid

Well, this clustering column actually has already been added to your table (see screenshot below). You will find it under the Clustered Data item.

Or do you want to build a new model on top of this data which assigns new data points to the found clusters? In this case, you need to export the data (store it in a repository) and run Auto Model again on that exported data set, but this time with Prediction on the new cluster column. The output will be a model which can assign new data points to the found clusters.

Little trick: you can also "export" to Turbo Prep and click on Model there again to get back into Auto Model on the same data without actually writing the data yourself into a repo.

Hope that helps,
Ingo

Image: https://us.v-cdn.net/6030995/uploads/editor/sk/22filbnw9ir2.png

gianluca_scheid

Dear Ingo

Thank you for your reply!

Maybe I have to be more specific about my problem:

I have a data set with the name of retailers and two different KPIs. Now, I would like to cluster those retailers based on the two KPIs into four different groups. After that, I would like to add the cluster information (cluster 1, cluster 2...) to my original data set. Unfortunately, the "Clustered Data" table does not contain any retailer information anymore. How can I "merge" the "Clustered Data" table with my original data set?

Best regards
Gianluca

IngoRM

export the clustered data to Turbo Prep,
add the original data set as a second data set to Turbo Prep as well,
click on Merge and select an Inner Join and activate the checkbox for Use Row Number as Key.
Update, Commit, Done.

Hope this helps,
Ingo

gianluca_scheid

Great! I wasn't sure if the row number remains the same for the clustered data

Thank you!