python合并excel

python合并excel

import pandas as pd
from sqlalchemy import create_engine
import os
folder_path = r'D:\相关路径'
conn = create_engine(
    'mysql+pymysql://root:password@localhost:3306/cooperation?charset=utf8mb4')
file_paths = []
for root, dirs, files in os.walk(folder_path):
    for file in files:
        if '公司信息' in file:
            file_paths.append(os.path.join(root, file))


def read_excel(file_path):
    df = pd.read_excel(file_path)
    return df

# 循环读取目标路径下的Excel,使用pd.concat方法拼接
df = pd.concat([read_excel(i) for i in file_paths])
# 使用append方法追加到数据库
df.to_sql(name='数据库表名', con=conn, if_exists='append', index=False)