将多个文件夹和子文件夹中的多个excel文件合并为一个pandas数据帧。

import os
import pandas as pd

def get_excel_files(folder_path):
    excel_files = []
    for root, dirs, files in os.walk(folder_path):
        for file in files:
            if file.endswith(".xlsx") or file.endswith(".xls"):
                excel_files.append(os.path.join(root, file))
    return excel_files

def merge_excel_files(excel_files):
    dfs = []
    for file in excel_files:
        df = pd.read_excel(file)
        dfs.append(df)
    merged_df = pd.concat(dfs, ignore_index=True)
    return merged_df

folder_path = "文件夹路径"
excel_files = get_excel_files(folder_path)
merged_df = merge_excel_files(excel_files)