Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

Text mining excel using clustering to obtain confusion matrix

hi,
I'm new to rapidminer, I need to get the confusion matrix to validate clusters obtained from a text. Did you know how to do this?

Find more posts tagged with

AI Studio

Clustering

Excel

Text Mining + NLP

Accepted answers

brunonbrasil

Hello

I think the solution is this:

Image: https://us.v-cdn.net/6030995/uploads/editor/uv/062zk2zn8pb9.png

All comments

Telcontar120

Clusters are a form of unsupervised machine learning so it is not possible to generate a confusion matrix directly from clustering. You would first need to turn the clusters into a label and then have another process to assign the clusters to compare the two outputs. Or if you already have another existing label with the same number of categories as clusters, then you can use the Map Clusters on Labels operator to do this automatically and then use a normal Performance operator to generate the confusion matrix.

brunonbrasil

I built this model to classify the confusion matrix. I managed to get the confusion matrix but I don't know if it is the correct form. Does it make sense to you?

Image: https://us.v-cdn.net/6030995/uploads/editor/yu/qigsjz57ufjk.png

Image: https://us.v-cdn.net/6030995/uploads/editor/hz/rr4xkj96uoi6.png

sgenzer

hi @brunonbrasil so based on that screenshot you are using a very old version of RapidMiner Studio. I would highly recommend updating to the most recent version (9.5.1).

Scott

brunonbrasil

The context I consider as a label, means the clusters that I obtain manually and compare with the clusters that I intend to obtain. The Receiver represents the data in sentences.

Image: https://us.v-cdn.net/6030995/uploads/editor/xl/m8injivs93nt.png

brunonbrasil

Hello

I think the solution is this: