How to get a toplist of frequencies of a simple set

User2170

hi,

the excel table looks like this:

p1 p2 p3
a  b    c
a  a    b
a  b    c
a  a
a  a    b
a a  b


now it want to get a toplist of frequencies, in this case it would be sthing like:

1) aab (3 times)
2) abc (2 times)
3) aa (1 time)

p1,2,3 are touchpoints or whatever, doenst matter.

thanks for ur help, im a real beginner to be honest
is this solveable with rapidminer?

Andrew2

Hello,

This could be done something like this.

Use "generate attributes" to create a new attribute - p4 = concat(p1,p2,p3).

Then use "aggregate" to count the number of p4s.

Regards

Andrew