pandas批量拆分、合并Excel文件
一、将大的Excel文件拆分成多个小的Excel
- 使用df.iloc方法,将一个大的dataframe拆分成多个小的dataframe
- 再用dtaframe.to_excel保存成小的excel
work_dir = "./datasets/excel_split_merge" #操作目录
split_dir = f"{work_dir}/splits"
impot os
import pandas as pd
if not os.path.exists(split_dir):
os.mkdir(split_dir)
#读取数据
import pandas as pd
df_source = pd.read.excel(f"{work_dir}/crazyant_blog_articles_source.xlsx")
total_roe_count = df_source.shape[0