How to sumarize data from a csv

• • Reply

  15 years ago

  by acornejo

  Alvaro Cornejo

  , Mexico

  Joined 15 years ago

      Hi
  
  I need to extract data from a csv file. The file contains 8 csv columns. I'm interested in getting info from only 3 columns: the one that has a name the one that has the product ID and the third that has the quantities sold.
  
  I'll need get a summary of it, for each sales guy how much does he sold for each product.
  
  I've messing around an script but being unable to have something that work. I've been able to filter the 3 columns but have been unable to have the sum of quantities of each product per salesguy.
  
  Any ideas?
  
  
  
  
  
  
  
  
  
  

  Report abuse