Python拆分Excel到sheet页

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

2、获取需拆分的文件，地址aa = "分组争犸禀淫" #拆分条件列名file_name = '拆分.xlsx' #拆分文件名foldname=刻八圄俏9;./'data_name = os.path.join(foldname,file_name)data =pd.read_excel(data_name,)

3、新建表，获取源表保存到总表#获得需要拆分的字段列表caifen_list = list(set(data[aa]))#创建需要存放的狠海柏隘拆分数据的表格，并写入总表writer = pd.ExcelWriter('./{}-拆分好的表.xlsx'.format(file_name.split(".")[0]),engine = 'xlsxwriter')data.to_excel(writer,sheet_name = '总表',index = False)

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