2 Replies Latest reply on Oct 4, 2017 3:06 PM by Alexander Mou

    Market Basket?

    hellen hu

       

      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:

      Market Basket.jpg