Define more rows as one Transaction (Market Basket Analysis)

monika_schnegelmonika_schnegel Member Posts: 4 Contributor I
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: 270 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.