"newbie question regarding market basket analysis"

aponapon Member Posts: 3 Contributor I
edited May 2019 in Help
i have a table with two columns
1. column: transaction id
2. column: product name

and i want to know which products are often bought together
with which algorithm can i do that?

thanks for any help! :)


  • Options
    IngoRMIngoRM Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, Community Manager, RMResearcher, Member, University Professor Posts: 1,751 RM Founder

    the solution is the operator "Pivot". Search here in the forum for "Pivot" and you will many threads about this operator. There are also some examples on myExperiment.org which are available with our Community Extension (search for that as well).

  • Options
    aponapon Member Posts: 3 Contributor I
    thanks for the answer, helped me a lot :)
  • Options
    aponapon Member Posts: 3 Contributor I
    sorry for the doublepost but i have a new question regarding this topic
    i used "FPGrowth" and "Create Association Rules" to find out which items are bought together 
    the problem is as the result i get rules only for the firts 3 columns of the exampleset but i want rules for all items

    what did i wrong?
Sign In or Register to comment.