SOLVED

# Analysis of Product Customer Combinations

Copper Contributor

# Analysis of Product Customer Combinations

Hi Community,

I have to analyze data for univeristy. The dataset contains line items of a company with the single products all customers bought.

How can I analyze wich combination of e.g. two or three products are most popular among the customers?

I would be grateful if someone can assist me here :)

4 Replies

# Re: Analysis of Product Customer Combinations

Hello, I found your task very interesting, so I tried to implement it. Unfortunately, you didn't tell me in detail what form your data is in, so I made something up myself. It probably doesn't fit exactly. But maybe it will give you some inspiration.

I made a table with customers and entered the products purchased in the same row.

I have prepared 11 product columns. However, columns can also be added if necessary. If a product is purchased twice by a customer, this is not taken into account in the analysis. Each customer only appears once in my list. If customers have multiple purchases, this is currently not taken into account.

The 2-purchase combinations are analysed in the Analysis worksheet. The sheet is prepared for 99 different products. If there are more, this must be extended manually. Until then, it is dynamic and does not need to be edited.

I did not dare to analyse the combination of 3 products. Depending on how many products are analysed, there are a lot of combinations to analyse. In my opinion, this is no longer a task for a spreadsheet but for a Python script.

The most frequent product combinations are then displayed in the TOP x table. At least the best 10 results are displayed. If there are other TOP results that are just as frequent as those in row 11, these are also displayed. That was quite tricky.

# Re: Analysis of Product Customer Combinations

Just what I needed!
best response confirmed by Felpf2002 (Copper Contributor)
Solution

# Re: Analysis of Product Customer Combinations

I have now tried to implement the 3-piece combinations.

# Re: Analysis of Product Customer Combinations

that looks quite promising - thank‘s a lot! will try it on monday! hope it will work with my dataset (hundreds of different products) :)
1 best response

Accepted Solutions
best response confirmed by Felpf2002 (Copper Contributor)
Solution

# Re: Analysis of Product Customer Combinations

I have now tried to implement the 3-piece combinations.