我如何使用f-strings使用sqlalchemy填充数据框

发布于 2025-01-19 20:03:39 字数 573 浏览 0 评论 0原文

我正在尝试使用F-strings使用平均名为_COUNT的数据框。我在哪里挣扎的是，我的脚本只会在列表中的最后一项中填充数据框架8112输出

var = ["8113","8114","8112"]

id_list_string = "','".join(var)
for var in id_list_string:
    sql_query = f"SELECT list_id, avg(called_count) FROM list WHERE list_id IN ('{id_list_string}');"


    df = pd.read_sql(sql=sql_query,con=cnx)
df

产生列表中的最后一个ID：

    list_id avg(called_count)
0   8112    1.408

我想生产的是：

list_id avg(called_count)
0   8113    1.7268
1   8114    0.3802
2   8112    1.408

我缺少什么？

原文

I am trying to populate a dataframe with the average called_count using f-strings. Where I am struggling is that my script will only populate the dataframe with last item in the list the being 8112

var = ["8113","8114","8112"]

id_list_string = "','".join(var)
for var in id_list_string:
    sql_query = f"SELECT list_id, avg(called_count) FROM list WHERE list_id IN ('{id_list_string}');"


    df = pd.read_sql(sql=sql_query,con=cnx)
df

the output produces the last id in the list as such:

    list_id avg(called_count)
0   8112    1.408

What I am trying to produce is:

list_id avg(called_count)
0   8113    1.7268
1   8114    0.3802
2   8112    1.408

What am I missing?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

第几種人 2025-01-26 20:03:39

您不需要 for 循环，因为您将 list_id 加入元组中。

var = ["8113","8114","8112"]

id_list_string = "','".join(var)
sql_query = f"SELECT list_id, avg(called_count) FROM list WHERE list_id IN ('{id_list_string}') groupby list_id;"
df = pd.read_sql(sql=sql_query,con=cnx)
df

You don't need the for loop since you're joining list_id in a tuple.

var = ["8113","8114","8112"]

id_list_string = "','".join(var)
sql_query = f"SELECT list_id, avg(called_count) FROM list WHERE list_id IN ('{id_list_string}') groupby list_id;"
df = pd.read_sql(sql=sql_query,con=cnx)
df

回复收藏 0 原文

~没有更多了~