import pandas as pd #excel路径 excelpath=r'C:\Users\h\Desktop\cs.xlsx' df=pd.read_excel(excelpath) groupByNew = df.groupby('name', sort=False) for name, groupData in groupByNew: print(name) excelname=name+".xlsx" yy = pd.DataFrame(groupData) writer = pd.ExcelWriter(excelname) yy.to_excel(writer, 'Sheet1') writer.save()
Excel分组存为多个文件
最新推荐文章于 2024-08-01 14:52:57 发布