Python将Excel拆分成单独文件

1、首先导入包import pandas as pd

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)