excel数据分组存到一个excel的多个sheet中

最新推荐文章于 2022-04-26 23:05:52 发布

A873054267

最新推荐文章于 2022-04-26 23:05:52 发布

阅读量862

点赞数

分类专栏： python

本文链接：https://blog.csdn.net/A873054267/article/details/92835806

版权

python 专栏收录该内容

32 篇文章 1 订阅

订阅专栏

import pandas as pd
from openpyxl import load_workbook
#excel路径
excelpath=r'C:\Users\h\Desktop\cs.xlsx'
df=pd.read_excel(excelpath)
groupByNew = df.groupby('name', sort=False)
#输出的excel路径，需预见建好
writer = pd.ExcelWriter('cs.xlsx', engin='openpyxl')
for name, groupData in groupByNew:
    print(name)
    book = load_workbook(writer.path)
    writer.book = book
    yy = pd.DataFrame(groupData)
    groupData.to_excel(excel_writer=writer, sheet_name=name)
    writer.save()
writer.close()