这能满足您的需求吗?
import pandas as pdyour_column = pd.Series([1,2,3,4,5,6,7,8,9])query = "SELECt ValueDate, Value" "FROM Table " "WHERe [ID] in {}".format(tuple(your_column))print(query)# 'SELECt ValueDate, ValueFROM Table WHERe [ID] in (1, 2, 3, 4, 5, 6, 7, 8, 9)'
然后,您应该能够查询而无需更多参数。
df = pd.read_sql_query(query, conn)
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)