Hi All
Hoping someone can help me with the "transactions" object. I am
struggling
to get my data in. I know the answer is in the help somewhere I'm sure, I
just cannot find it. Essentially, I have data in this format (though I can
change it if it particularly unsuitable)
Transaction_id, store , salesman, date_time , items
1 , waterfront, john , 2008-01-01 12:00:00, hardware games
audio_visual photo
2 , sandton , lisa , 2008-01-02 12:00:00, photo
3 , waterfront, peter , 2008-01-01 12:00:00, hardware photo
How do I get this into a transactions data type? I wish to get all the
apriori() stats for each salesman, and see who's good at selling add-ons and
up-selling (and how salespeople react when certain items are discounted).
For this analysis, I need to filter on salesman and date_time.
I realise that the EPubs dataset in the arules package has a few extra
fields apart from the transaction_ids and the actual items, but I can't
figure out how to get the additional fields (in my case store, salesman,
date_time) in.
(PS: it would not be too hard for me to binary-ise the items fields if this
would help.)
[[alternative HTML version deleted]]
