I need to separate a very large csv file (90000 rows, 100columns) into multiple files based on the columns. Following constrains must be applied:
- Each new file should have 3 columns: A, B and C
- Column A and B remains in all files the same and are the same as in original csv
- Column C is changing (taking values from each column in original csv)
- Name of the new file is exactly the same as header in separated column (header is in row 1)
eg. after separation file A100SS.csv has following column: A,B,A100SS
file A200SS.csv has following column: A,B,A200SS
Please Help!
Bookmarks