🥳 RAPIDMINER 9.9 IS OUT!!! 🥳

The updates in 9.9 power advanced use cases and offer productivity enhancements for users who prefer to code.

CLICK HERE TO DOWNLOAD

How to get a toplist of frequencies of a simple set

User2170User2170 Member Posts: 2 Contributor I
edited November 2018 in Help
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?

Answers

  • awchisholmawchisholm RapidMiner Certified Expert, Member Posts: 458   Unicorn
    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
Sign In or Register to comment.