Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.

Define more rows as one Transaction (Market Basket Analysis)

monika_schnegelmonika_schnegel Member Posts: 4 Learner III
edited June 2019 in Help

hello,

 

i want to do a market basket analysis with an MS SQL Database.

My Problem, the table looks like this:
Date                receipt      receipt_position             article

2008-06-5           1                    1                             apple

2008-06-5           1                    2                            cheese

2008-06-5           2                    1                             Bread

 

How can i define more rows as one market basket in Rapidminer?

Best Answer

  • earmijoearmijo Member Posts: 271 Unicorn
    Solution Accepted

    @monika_schnegel wrote:

    hello,

     

    i want to do a market basket analysis with an MS SQL Database.

    My Problem, the table looks like this:
    Date                receipt      receipt_position             article

    2008-06-5           1                    1                             apple

    2008-06-5           1                    2                            cheese

    2008-06-5           2                    1                             Bread

     

    How can i define more rows as one market basket in Rapidminer?


    Monica:

    Take a look at the Tutorial Processes that acompany the operator FPGrowth (in particular the one about input formats). They all start with data in the format you show above and then they transform them into various formats that RM can process. 

     

    Screen Shot 2018-08-08 at 8.04.23 AM.pngScreen Shot 2018-08-08 at 8.08.07 AM.png

     

     

Answers

Sign In or Register to comment.