1.引入相关包
import pandas as pd
import xlrd
2.读取表格文件:
data = pd.read_excel(r"D:\xxx\xxx\xxx\等待拆分的表.xlsx")
3.创建分类字段列表:
area_list = list(set(data['分类字段名称']))
4.更改相关信息即可:
for i in area_list:
# 创建一个表格
writer = pd.ExcelWriter(r"D:\xxx\xxx\xxx\{}分类拆分完成.xlsx".format(i), engine='xlsxwriter')
# 分类拆分原表格数据
df = data[data['分类'] == i]
# 储存excel
df.to_excel(writer, sheet_name="{}分类拆分完成".format(i), index=False)
writer.save()
快来试试吧~