Cross Merchandising Application

a_rajia_raji Member Posts: 1 Contributor I
edited December 2018 in Help

Hello everyone,

I need to extract association rules from a database that it organized in this way : 

Article_Code           Ticket ID

xxxxxxxxx1             yyyyyyyy1

xxxxxxxxx2             yyyyyyyy1

 

But the thing is, most of solutions that exist for that kind of need use the FP-growth then a Create Asssociation (Which is an Apriori algorithm). And these kind of algorithms only work on databases organized like this :

Ticket ID         Article1         Article2        Article3          Article4

yyyyyyy1         0                   1                 1                    0

yyyyyyy2         1                   1                 0                    0

 

Do you have any idea of how can i do to make my database treatable by the FP-Growth ?

 

Answers

  • MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,503 RM Data Scientist

    The key operator for this is called "Pivot".

     

    Best,

    Martin

     

    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
Sign In or Register to comment.