Python拆分Excel到sheet页

1、导入包import pandas as pdimport osimport warningswarnings.filterwarnings("ignore")

4、创建循环将拆分的子表保存#创建循环把拆分的子表写入for j in caifen_list: df = data[data[aa] == j] df.to_excel(writer, sheet_name = j , index = False)writer.save()writer.close()