利用python合并多个Excel文件

import os
import re
import pandas as pd
path_excel = os.path.dirname(os.path.abspath(__file__))

#获取Excel的文件名
f_list = os.listdir(path_excel)
excel_name = []
for i in f_list:
    if re.findall("xlsx",i):
        excel_name.append(i)
print(excel_name)

#开始合并
result = pd.DataFrame()
for i in excel_name:
    data_excel = pd.read_excel(i)
    result = result.append(data_excel)

#为了防止超出限制，我们转存为CSV格式
result.to_csv("合并.csv")