Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.
Market Basket Analysis. I have one product in each row with their ticket number.
Learner II
Hello! I hope you can help me please!!
I tried several ways and I cant figure out how to do the market basket analysis.
I have a database of 30,000 examples.
My database looks like this:
Ticket # Product#
1 3456
2 3457
2 3458
2 3456
3 3457
3 3458
Please note that in each row I have a ticket number and for example in the ticket number 2 (in bold in the table) That was one transaction where the customer buyed 3 different products.
How may I transform this huge table to a binomial table to do the market basket analysis. I have near 6600 different products and 15000 transactions.
I tried to concatenate the products in one column and use fp-grow with the option of "item list in a column" but it does not works because I think that its comparing the frecuency of the exactly same combination of products in the same order.
Any help please! Thank you!!!
I will try to respond quickly!
I tried several ways and I cant figure out how to do the market basket analysis.
I have a database of 30,000 examples.
My database looks like this:
Ticket # Product#
1 3456
2 3457
2 3458
2 3456
3 3457
3 3458
Please note that in each row I have a ticket number and for example in the ticket number 2 (in bold in the table) That was one transaction where the customer buyed 3 different products.
How may I transform this huge table to a binomial table to do the market basket analysis. I have near 6600 different products and 15000 transactions.
I tried to concatenate the products in one column and use fp-grow with the option of "item list in a column" but it does not works because I think that its comparing the frecuency of the exactly same combination of products in the same order.
Any help please! Thank you!!!
I will try to respond quickly!
0
Answers