import pandas as pd
import xlrd
data = pd.read_excel(r"F:\ljwdata\数学建模\2022第七届湖南省研究生数学建模比赛\C题相关文件\C提交数据\问题2\excel_test.xlsx", encoding='gbk')
area_list = list(set(data['年份']))
writer = pd.ExcelWriter(r"F:\ljwdata\数学建模\2022第七届湖南省研究生数学建模比赛\C题相关文件\C提交数据\问题2\excel_test\拆好的表.xlsx", engine='xlsxwriter')
data.to_excel(writer, sheet_name='总表', index=False)
for j in area_list:
df = data[data['年份'] == j]
df.to_excel(writer, sheet_name=str(j), index=False)
writer.save()
按照年份将总表拆分