import pandas as pd
from pandasql import sqldf
# 读取employee.xlsx和department.xlsx到Pandas数据框
employee_df = pd.read_excel("employee.xlsx")
department_df = pd.read_excel("department.xlsx")
# 在Pandasql中使用JOIN操作
query = """
SELECT e.*, d.name as department_name
FROM employee_df e
JOIN department_df d ON e.department_id = d.id
"""
result = sqldf(query, locals())
# 结果写到一个新的表
result.to_excel("result.xlsx", index=False)
如果直接pip下不下来的话
pip install -i https://pypi.tuna.tsinghua.edu.cn/simple pandasql
pip install -i https://pypi.tuna.tsinghua.edu.cn/simple pandas
pip install -i https://pypi.tuna.tsinghua.edu.cn/simple openpyxl