title: Very large .csv file,
body: <p>I have large amount of Data, about 20 million rows and 6 columns. I am trying to extract data from this large .csv file.
  I tried R, but i get error msg, I am using macbook with 4 GB Ram, i5 processor.
  Is there any way I can extract information, 
  I tried excel, it can take only 1 million rows.
  any advise or help will be useful</p>
  
  <p>file is more than 1.3 GB, i want to divide this data base into set of about 2000-3000 based on a parameter. I tried R and when I used read.csv.. i tries for a moment but but after 10 mints or so i get R not responding –</p>
  
  <p>I want to separate these data based on 3rd column.</p>
  
  <p>SHA    PCT PRACTICE    BNF CODE    BNF NAME                                        </p>