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?
Best Answer
Use PowerShell.
You put \Large.csv as the Path to your Csv.
You put Output.txt as where you want the output to go say C:/Usere/Documents/Output.txt