"newbie question regarding market basket analysis"

apon
apon New Altair Community Member
edited November 5 in Community Q&A
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

  • IngoRM
    IngoRM New Altair Community Member
    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
  • apon
    apon New Altair Community Member
    thanks for the answer, helped me a lot :)
  • apon
    apon New Altair Community Member
    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?

Categories