import pandas as pd
df = pd.read_excel('10.18 HPC.xlsx',index_col=None,usecols=['供商编码','门店','商品','当前库存'])
# print(df)
df1 = df[df['当前库存'] < 1]
# print(df1)
# df1.to_excel('1.xlsx',index=None)
gongshang = df1.value_counts('供商编码')
print(gongshang)
pandas 筛选和统计功能
最新推荐文章于 2023-10-05 00:21:08 发布