Python将Excel拆分成单独文件

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)