要统计整理每个月的销售信息,把他们汇总在一起。
代码如下
'''
import pandas as pd
import openpyxl
f=pd.DataFrame(pd.read_csv('201901.csv',header=0))
r=pd.pivot_table(f,index=["型号","颜色","工厂","实体店"],values=["条码"],aggfunc='count')
r.rename(columns={'条码':'1月'}, inplace = True)
f2=pd.DataFrame(pd.read_csv('201902.csv',header=0))
r2=pd.pivot_table(f2,index=["型号","颜色","工厂","实体店"],values=["条码"],aggfunc='count')
r2.rename(columns={'条码':'2月'}, inplace = True)
f3=pd.DataFrame(pd.read_csv('201902.csv',header=0))
r3=pd.pivot_table(f,index=["型号","颜色","工厂","实体店"],values=["条码"],aggfunc='count')
r3.rename(columns={'条码':'3月'}, inplace = True)
res=pd.concat([r,r2,r3], axis=1)'''
writer =pd.ExcelWriter('结果.xlsx')
r.to_excel(writer,'1')
writer.save()
因为数据文件太大,运行时提示
MemoryError: Unable to allocate array with shape (1408618,) and data type object
请问大佬如何优化我的垃圾代码