使用查询将多个excel文件摄取到MySQL

import pandas as pd
import mysql.connector

# 读取Excel文件并转换为DataFrame对象
df1 = pd.read_excel('file1.xlsx', sheet_name='Sheet1')
df2 = pd.read_excel('file2.xlsx', sheet_name='Sheet1')

# 连接到MySQL数据库
cnx = mysql.connector.connect(
    host='localhost',
    user='your_username',
    password='your_password',
    database='your_database'
)

# 将DataFrame对象写入MySQL数据库中的新表
df1.to_sql(name='table1', con=cnx, if_exists='replace', index=False)
df2.to_sql(name='table2', con=cnx, if_exists='replace', index=False)

# 执行查询操作
cursor = cnx.cursor()
query = '''
    SELECT * FROM table1
    JOIN table2 ON table1.id = table2.id
'''
cursor.execute(query)
results = cursor.fetchall()

# 打印查询结果
for row in results:
    print(row)

# 关闭数据库连接
cursor.close()
cnx.close()