How to get a toplist of frequencies of a simple set

User2170User2170 Member Posts: 2 Contributor I
edited November 2018 in Help

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?


  • Options
    awchisholmawchisholm RapidMiner Certified Expert, Member Posts: 458 Unicorn

    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.


Sign In or Register to comment.