The Altair Community is migrating to a new platform to provide a better experience for you. The RapidMiner Community will merge with the Altair Community at the same time. In preparation for the migration, both communities are on read-only mode from July 15th - July 24th, 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.

"Pivot/table - association rules"

MBMMBM Member Posts: 23 Contributor I
edited June 2019 in Help

Hello all,


I have a table like this 

name      cluster     
frank cluster_0
frank cluster_0
frank cluster_4
thomas cluster_0
thomas cluster_3
betty cluster_8
betty cluster_10

And for association rules and sequential patterns I would like (and I think I need) that table look like this

name      cluster_0     cluster_3     cluster_4     cluster_8     cluster_10
frank 2 0 1 0 0
thomas 1 1 0 0 0
betty 0 0 0 1 1

I was able to get something like the second table by checking the tutorial about pivot and use it for my case. Do you think this is the right way for association rules?

And for sequential patterns I also have an attribute time but I don't know how to use that attribute in the second table - again, I am not even sure that this is the right way.


Thanks in advance




Sign In or Register to comment.