如何使用Python将Dataframe放入SQL where子句？

pip install pandas
pip install sqlalchemy

import pandas as pd
from sqlalchemy import create_engine

# 创建数据库连接
engine = create_engine('mysql://username:password@localhost/database_name')

# 创建一个示例Dataframe
df = pd.DataFrame({'name': ['Alice', 'Bob', 'Charlie'],
                   'age': [25, 30, 35]})

# 将Dataframe写入数据库表中
df.to_sql('table_name', con=engine, if_exists='replace', index=False)

from sqlalchemy.sql import select

# 创建一个查询对象
query = select([column1, column2, ...]).where(condition)

# 执行查询并获取结果
result = engine.execute(query)

# 遍历结果
for row in result:
    print(row)