Association Rules

Spark22

Hi there,

First of all let me apologize for my poor english. I´m from germany and english isn´t one of my best skills.
I´m totally new to RapidMiner and I have to do a little homework for my university. I have to analyse 100k datasets for association rules. Those datasets aren´t really complex, but I have zero experience in working with RapidMiner. One dataset consists of one custommer ID, one article ID and an integer variable between 0 and 2 with the translation: 0 = article was watched, 1 = article was placed in the shopping basket and 2 = article was puchased. Here are some examples:
ID  article  action
1      23        0
1      92        0
1      40        2
2      92        1
2      12        0

In this example customer 1 watched articles 23 and 92 and then bought article 40. Customer 2 put article 92 in his basket und watched article 12. So one customer can only choose one of the three actions for one article. There are no datasets with equal ID´s and equal article ID´s but different action. There will always be just one action for any article a customer looked at. I hope you get the idea of those datasets.
Now I have to find some rules like: If article 23 and article 92 were watched, article 40 was bought. But I have no clou how to find those rules with my RapidMiner community edition 5.3. My datasets are located in an excel file, so I read them and since the FP-Growth algorithm needs binomial attributes, I converted every attribut into binomial. At the end I connected the FP-Growth operator withe the Create Association Rules Operator. But the result I get are totally wrong. They ary like: If Article_ID Then Action or If Acticle_ID and customer_ID Then action. Instead I would like to get rules like: If article_ID = 23 and action = 0, article_ID = 92 and action = 0 then article_ID = 40, action = 2.
Can anybody explain to me how association rules in RapidMiner work? Do I have to transform my datasets or are there any operator configurations I have to do. Please halp me.
Btw. Again, sorry for my bad english.

Rene

I'd first think of concatenating "article" and "action" (23_0, 92_0, 40_2, ...). Then e.g. use the template from your samples repository (samples/processes/01_learner/25_fpgrowth) plus a final "Item Sets to Data" and export the result to excel, where you can filter easily without java coding etc.