title: Data Manipulation in R for Apriori
body: <p>I have a part of the data-set as shown below in the form of csv,the number of rows and columns are more than what is shown.I want to implement apriori on this data-set,Say I have this:-</p>
  
  <pre><code>    Maths Science C++ Java DC
  [1]    75   44      55  56  88
  [2]    56   88      54  78  44
  </code></pre>
  
  <p>the original dataset has total columns(representing subjects)=30 and serial number(representing students)=24,</p>
  
  <p>DATASET:<a href="https://drive.google.com/open?id=0B3kdblyHw4qLR0dpT24xWUZGcGs" rel="nofollow noreferrer">link</a></p>
  
  <p>I want to covert this dataset in the form shown below:-</p>
  
  <pre><code>[1] {Maths,DC}
  [2] {Science,Java}
  </code></pre>
  
  <p>i.e A list of list(I think this is what it is called) containing the colnames.A list for a student shows in which subject he/she scored more than or equal to 75 marks,rest of the subjects are dropped(The only condition of the problem)</p>
  
  <p>eq:- first student scored 75+ marks in Dc and Maths and so his list includes only dc and maths.</p>
  
  <p>I am sorry for posting this,but I searched a lot on stack,and found a few of the working suggestions ,but couldn't reach the final goal.
  My goal is to get a form like this:-</p>
  
  <pre><code>[9834] {semi-finished bread,      
          bottled water,            
          soda,                     
          bottled beer}             
  [9835] {chicken,                  
          tropical fruit,           
          other vegetables,         
          vinegar,                  
          shopping bags}  
  </code></pre>
  
  <p>As given in :-</p>
  
  <pre><code>library(arules)
  inspect(Groceries)
  </code></pre>
  
  <p>OR I WILL APPRECIATE IF ANYONE CAN SUGGEST A WAY TO REPRESENT THE DATA IN OTHER FORM WHICH APRIORI CAN UNDERSTAND,BUT IT SHOULD FOLLOW THE NECESSARY CONDITIONS AS STATED. </p>
  
  <p>*(sorry for the long post,I hope this conversion of my dataset in this format may help me study the pattern in student-subject dataset,thnx a ton for all the help)</p>