Options
How to get a toplist of frequencies of a simple set
Contributor I
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?
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?
0
Answers
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