The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

"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! :)
Tagged:

Answers

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

    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).

    Cheers,
    Ingo
  • aponapon Member Posts: 3 Contributor I
    thanks for the answer, helped me a lot :)
  • 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.