title: Weka Apriori Algorithm
body: <p>I would like to use Apriori to carry out affinity analysis on transaction data. I have a table with a list of orders and their information. I mainly need to use the OrderID and ProductID attributes which are in the following format</p>
  
  <p>OrderID ProductID <br>
  1       A <br>
  1       B <br>
  1       C <br>
  2       A <br>
  2       C <br>
  3       A <br></p>
  
  <p>Weka requires you to create a nominal attribute for every product ID and to specify whether the item is present in the order using a true or false value like like this:</p>
  
  <p>1, TRUE, TRUE, TRUE <br>
  2, TRUE, FALSE, TRUE <br>
  3, TRUE, FALSE, FALSE <br></p>
  
  <p>My dataset contains about 10k records... about 3k different products. Can anyone suggest a way to create the dataset in this format? (Besides a manually time consuming way...)</p>