"How to create an association matrix instead of the rules?"
the example set which I have contains the transition of customers between different hotels for four years. I already did the basket analysis but am not satisfied with the result due to it's lack of visualization.
What I want to achieve is kind of an association matrix for example:
Product A was bought again 80 times.
Product B was bought again 100 times.
20 Customers who bought Product B also bought Product A.
The Matrix (in percentage) would look like this:
A 1 0,2
B 0,25 1
So an unsymmetrical matrix is created, which then could be visualised by xy-scatter with different circle sizes.
The problem is I don't know how to get to this matrix. My starting point would be to pivot and aggregate the data so that I get to the matrix-format.