1、首先导入包import pandas as pd
2、获取源文件，文件名，拆分条件file_name 屏顿幂垂= '拆分.xlsx'aa = "分组"颊俄岿髭data = pd.read_excel("./{}".format(file_name))rows = data.shape[0]department_list = []
3、按拆分条件分别保存数据到列表for i in range(rows): temp = data[aa][i] if temp not in department_list: department_list.append(temp)
4、用循环将数据分布保存成文件，按分组条件命名for department in department_list: new_df = pd.DataFrame() for i in range (0, rows): if data[aa][i] == department: new_df = pd.concat([new_df, data.iloc[[i],:]], axis = 0, ignore_index = True) new_df.to_excel(file_name.split(".")[0] + "-" + str(department)+".xlsx", sheet_name=department, index = False)
