The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

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.