"Pivot/table - association rules"

MBM

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