pandas批量拆分Excel与合并Excel

work_dir = 'D:\\python39\\pandas\\data'
splits_dir = f"{work_dir}/splits"
import pandas as pd 
import os

if not os.path.exists(splits_dir): #若splits_dir不存在时，
    os.mkdir(splits_dir)#创建splits_dir

#1.数据读取
fn ='D:\\python39\\pandas\\data\\first1.xlsx'
e1 =pd.read_excel(fn)
e1_row_count = e1.shape[0]
#print(e1_row_count)
##1.将一个大Excel等份拆成多个Excel
'''
1.使用df.iloc方法，将一个大的dataframe，拆分成多个小dataframe
2.将使用dataframe.to_excel保存每个小Excel'''
# 这个大Excel，会拆分给这几个人
user_names =['xiao_lu','xiao_huang','xiao_shuai','xiao_wang','xiao_zhang','xiao_fang','xiao_ming']
# 每个人的任务数目
split_size = e1_row_count//len(user_names)
if e1_row_count % len(user_names) != 0:
    split_size +=  1
#print(split_size)

##拆分成多个dataframe
df_subs = []
for idx,user_name in enumerate(user_names):
    begin = idx * split_