I have a very large CSV file which I should analyze. It's too big so I can't even open it in Excel or Stata. So I want to take first few rows of it and explore the data, and then select necessary columns.
What I need it a software which take specific rows or columns of a csv file and output it as a separate file. (e.g. I want to take Row 1~2500 or Column A,B,C and E) Which can do this?