Customer basket analysis (Data preparation)

sara20

Hello 
I work on customer basket analysis. I have a dataset like this for each customer basket:

Name               Number                 price           customer
pen                       2                            10                  1
bread                   10                           20                  1
fish                       2                             30                  1
...................................................................................................
bread                      3                          15                   2
salt                          1                            2                   2
...................................................................................................
pen                          3                           15                  3
bag                          1                            50                 3

Now I want to make columns for each Name and delete duplicate Names so I should change each row to the column then analyse them but I don't know how it is possible with RM? Also I should separate each customer basket from each other in to new rows. So it must be like this: ( for each Name which is in the basket of customer I should have "True" and which is not "False" in the row of that customer.)

Customer        pen           bread          fish          salt            bag  
1                      True            True            True         False         False
2                       False         True            False         True          False
3                      True            False          False          False        True

Can any body guide me? Also it is big data

Thank you in advance
Sara

Pavithra_Rao

Hi @sara20,

Here's a good tutorial on how to prepare the data and implement market basket analysis in RapidMiner.

https://academy.rapidminer.com/learn/article/cross-selling-do-you-want-fries-with-that

Cheers,
Pavithra