Correlation between products and creation of a heatmap using the correlation matrix

[mboroto_89]

using the field name "Category Name" i want to establish if there is a correlation between the various products.

This is to help come up with a pearson correlation matrix and then product a heatmap analysis, the heatmap analysis is to help depict closely related products to help with product recommendation.

Closely related products(with a high correlation e.g 0.7) are to be recommended.

Attached is the data extract with the dump, main focus is on "Category name"

[gabrielvilella · Accepted solution]

Is this what you are looking for? You also might want to look at the Market Basket tools.

[mboroto_89]

Thanks @gabrielvilella this works well, much appreciated!