"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

 

Marcel

 

Sign In or Register to comment.