使用已定义的名称列表从查询列表中创建数据框架

Question

我正在尝试运行一个查询，它改变了从SQL数据库中提取的不同数据框架的名称。我已经开发了一个简单的定义来运行给定SQL文件名的查询。for循环正常运行，但是它会重写Query到报告函数中最后一个观察到的数据帧。

def report(query_name):
df = []
filename = query_name +'.sql'
# read the sql file 
with open(filename, 'r') as query:

connection = sql_server_connection(server = "server", database = "database")
with connection:
df = pd.read_sql_query(query.read(), connection)

return df
queries = ['name1','name2','name3']
for query in queries:
query = report(query)

我希望看到的是

name1 = data from report(name)

name2 = data from report(name2)

name3 = data from report(name3)

如有任何帮助，不胜感激。

Answer 1

试试这个

queries = ['name1','name2','name3']
querie_data = {}
for query in queries:
querie_data[query] = report(query)

访问数据

querie_data['name1']