Profit model correlation

Hi everyone,
currently i am running a store. all the transaction data in excel files. I have a list of products and another list of customers' numbers. So 1 list is like this:
product A, product B, product C...;
the other is like this:
Customer1: product A, product C
Customer2: product B, product K, product X
Customer3: product F

So I want to combine the 2 lists into a binominal matrix:
Product A, Product B, Product C,....
C1: true, false, true,....
C2: false, true, false,....
....

Is there anyway to achieve this? I am using rapid miner too!
Thanks a million!
 
You must log in or register to reply here.
Back
Top