Pandas将多个目录中的Excel文件合并到第三个目录中

import pandas as pd
import os

input_dir1 = '目录1的路径'
input_dir2 = '目录2的路径'
output_dir = '目标目录的路径'

files1 = [f for f in os.listdir(input_dir1) if f.endswith('.xlsx') or f.endswith('.xls')]
files2 = [f for f in os.listdir(input_dir2) if f.endswith('.xlsx') or f.endswith('.xls')]

df_list = []
for file in files1:
    file_path = os.path.join(input_dir1, file)
    df = pd.read_excel(file_path)
    df_list.append(df)

df_merged = pd.concat(df_list)

for file in files2:
    file_path = os.path.join(input_dir2, file)
    df = pd.read_excel(file_path)
    df_merged = pd.concat([df_merged, df])

output_file = os.path.join(output_dir, 'merged.xlsx')
df_merged.to_excel(output_file, index=False)