各位大神,实际支行能执行所有主营类别数据,但是, to_excel后,表格数据就只能显示两个,其它无法写出,不知道怎么回事了,请大神指点。
#创建文件
writer_1 = pd.ExcelWriter(销售同比-品牌排名.xlsx')
#商场类别品牌排序
sc = ['XXXX', ]
pl = ['婴幼儿童用品', '童装', '男装', '女装', '护肤美妆用品', '运动休闲', '鞋包皮件']
for scs in sc:
if scs:
for pls in pl:
df12 = (df.loc[(df['商场'] == scs) & (df['主营品类'] == pls), ['商场', '主营品类', '品牌名', '当期销额']])
df13 = df12.sort_values(by='当期销额', ascending=[False])
# 删除当期销售空值
df14 = df13.dropna(subset=['当期销额'])
print(df14)
print(df14.to_excel(writer_1= scs, index=False))
writer_1.save()