"newbie question regarding market basket analysis"

aponapon MemberPosts:3Contributor I
edited May 2019 inHelp
i have a table with two columns
1. column: transaction id
2.专栏:产品名称

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 Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, Community Manager, RMResearcher, Member, University ProfessorPosts:1,751RM 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 MemberPosts:3Contributor I
    thanks for the answer, helped me a lot:)
  • aponapon MemberPosts:3Contributor 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 InorRegisterto comment.