import pandas as pd import numpy as np import xlrd import xlwt # 读取xlsx文件中的第一张工作表,并以第12行作为列索引(课本第59页) df = pd.read_excel(r"C:\Users\滕玉龙\Desktop\价格纠错 模板.xlsx",sheet_name = 0,header = 14) # print(df.replace("单据号码","个数")) # 打印预览并导出文档,给工作表、工作表命名,把默认索引去掉 # print(df.to_excel(excel_writer = r"C:\Users\滕玉龙\Desktop\导出文档.xlsx",sheet_name = "入库价汇总",index = 0,)) # 1.统计各部门验收价在WMS系统中做修改的单品个数 # print(df.groupby(["部门汇总"]).count().to_excel(excel_writer = r"C:\Users\滕玉龙\Desktop\导出文档.xlsx")) print(df.groupby(["部门汇总"]).count().to_excel(excel_writer = r"C:\Users\滕玉龙\Desktop\导出文档.xlsx", sheet_name = "汇总", index = 1, columns = ["单据号码"])) # 2.统计各仓别验收价在WMS系统中作修改的单品个数 # print(df.groupby("仓别").count()) # 3.按仓别统计各部门验收价在WMS系统中作修改的单品个数 # print(df.groupby(["仓别","部门汇总"]).count()) # 4.按部门统计各仓别验收价在WMS系统中作修改的单品个数 # print(df.groupby(["部门汇总","仓别"]).count())
转载于:https://my.oschina.net/u/3750423/blog/3067402