Apr-04-2022, 06:14 AM
Big data needs Pandas, I believe. I never had anything more than 200 rows.
I believe Excel is limited to 4000+ columns, but rows are unlimited.
Anyway, this will give you 3 csv files, 1 for each column. You can then just concatenate them if you wiish
I believe Excel is limited to 4000+ columns, but rows are unlimited.
Anyway, this will give you 3 csv files, 1 for each column. You can then just concatenate them if you wiish
import pandas as pd csv_file = '/home/pedro/myPython/pandas/testme.csv' savepath = '/home/pedro/myPython/pandas/' df = pd.read_csv(csv_file) # get each column columns = ['col1', 'col2', 'col3'] # put your column headers for colnr in columns: mydf = df[colnr] mydf.to_csv(savepath + colnr + '.csv', index=False)