Define more rows as one Transaction (Market Basket Analysis)

monika_schnegel

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?

earmijo

---

@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.png

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