import numpy as np import pandas as pd df = pd.read_excel("D:\盘点结果.xlsx") result =df.pivot_table(index=['仓库','编码'],columns='类型',values='数量',fill_value=0) result['盘点差异']=result['账存']-result['盘点'] result.loc[(result.盘点差异==0),'结论']='账实相符' result.loc[(result.盘点差异>0),'结论']='盘亏' result.loc[(result.盘点差异<0),'结论']='盘盈' result.loc[(result.盘点差异>=0),'盘盈数']=0 result.loc[(result.盘点差异<0),'盘盈数']=abs(result.盘点差异) result.loc[(result.盘点差异<=0),'盘亏数']=0 result.loc[(result.盘点差异>0),'盘亏数']=abs(result.盘点差异) filepath=('D:\盘点数据透析.xlsx') result.to_excel(filepath)
【python数据透析】盘点
最新推荐文章于 2024-07-10 19:27:42 发布