首先导入包

import pandas as pd

获取源文件，文件名，拆分条件

file_name = 拆分.xlsx

aa = 分组

data = pd.read_excel(./{}.format(file_name))

rows = data.shape

department_list =

按拆分条件分别保存数据到列表

for i in range(rows):

temp = data

if temp not in department_list:

department_list.append(temp)

用循环将数据分布保存成文件，按分组条件命名

for department in department_list:

new_df = pd.DataFrame()

for i in range (0, rows):

if data == department:

new_df = pd.concat(,:]], axis = 0, ignore_index = True)

new_df.to_excel(file_name.split(.) + - + str(department)+.xlsx, sheet_name=department, index = False)

搜索instructions.py，右键文件-属性-常规-更改，选择python，确定，保存