This content has been marked as final. Show 2 replies
Create a heat map showing which sub-categories are purchased together by customers. For example: how many customers have purchased the combination of appliances and bookcases? Count the number of times each sub-category combination occurs for all customers. Notice that the matrix repeats each combination of sub-categories twice, and the split betweent hese duplications is accross the diagonal in the matrix. Remove one half of the matrix so that there are no repeat sub-category combinations.
The result viz like following picture: