用pandas读取数据文件:
import pandas as pd
df = pd.read_csv('data.csv')
df.to_excel('data.xls')
提示:
This sheet is too large! Your sheet size is: 1495811, 2 Max sheet size is: 1048576, 16384
处理方法:
分块读取:
import pandas as pd
chunksize = 10 ** 6
for chunk in pd.read_csv('data.csv', chunksize=chunksize):
chunk.to_excel('data_'+str(chunk)+'.xls')