如何在SQL的IN运算符中插入pandas数据帧

import pandas as pd
import pyodbc

# 1. 将pandas数据帧保存为CSV文件
data_frame = pd.DataFrame({'column_name': [1, 2, 3, 4, 5]})
data_frame.to_csv('data.csv', index=False)

# 2. 连接到SQL Server数据库
conn = pyodbc.connect('DRIVER={SQL Server};SERVER=server_name;DATABASE=database_name;UID=username;PWD=password')

# 3. 导入CSV文件到SQL Server的临时表
cursor = conn.cursor()
cursor.execute('CREATE TABLE #temp_table (column_name INT)')
cursor.execute('BULK INSERT #temp_table FROM \'data.csv\' WITH (FORMAT=\'CSV\')')

# 4. 执行SQL查询并获取结果
query = 'SELECT * FROM table_name WHERE column_name IN (SELECT column_name FROM #temp_table)'
result = pd.read_sql(query, conn)

# 5. 关闭连接和清理临时表
cursor.execute('DROP TABLE #temp_table')
cursor.close()
conn.close()

# 打印查询结果
print(result)