"Pivot/table - association rules"
I have a table like this
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