如何从CSV文件中获取所有日期Informati＆＃x131; n使用循环？

发布于 2025-02-03 16:28:53 字数 505 浏览 3 评论 0原文

我想通过for循环获得每天的信息。因为我将每周响应数据作为另一个代码中的表格。但是当我这样做时，我得到了空框架。

 df = pd.read_csv('yogun_bakim_yatak.csv', encoding="utf-8")  
    df['created_at'] = pd.to_datetime(df['created_at'], format='%Y-%m-%d')
    time = pd.date_range(start="2020-12-25 00:00:00+00:00", end="2021-12-25 00:00:00+00:00", freq="D")
    # Filter data between two dates
    n = len(time)
    for i in range(0, n, 1):
     filtered_df = df.loc[(df['created_at'] == time[i]]
      print(filtered_df.to_string())

原文

I want to get each day information with the for loop. Because I will show responding weekly data as a table in another code. But when I did this I got Empty Dataframe.

 df = pd.read_csv('yogun_bakim_yatak.csv', encoding="utf-8")  
    df['created_at'] = pd.to_datetime(df['created_at'], format='%Y-%m-%d')
    time = pd.date_range(start="2020-12-25 00:00:00+00:00", end="2021-12-25 00:00:00+00:00", freq="D")
    # Filter data between two dates
    n = len(time)
    for i in range(0, n, 1):
     filtered_df = df.loc[(df['created_at'] == time[i]]
      print(filtered_df.to_string())

分享到QQ

分享到微博

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

发布评论

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

千仐 2025-02-10 16:28:53

您可以简单地使用以下代码段，而不是“ for”循环，我相信它更有效地

start_date = pd.to_datetime('2020-12-25 00:00:00+00:00')
end_date = pd.to_datetime('2021-12-25 00:00:00+00:00')

df[df['date'].dt.date.between(start_date, end_date, inclusive=True)]

设置包含，因为false等同于＆gt; 和＆lt; 而，true等效于＆gt; =和＆lt; =

You can simply use the below code snippet instead of 'for' loop, I believe it is much more efficient

start_date = pd.to_datetime('2020-12-25 00:00:00+00:00')
end_date = pd.to_datetime('2021-12-25 00:00:00+00:00')

df[df['date'].dt.date.between(start_date, end_date, inclusive=True)]

setting inclusive as False is equivalent of > and <
While, True is equivalent of >= and <=

回复收藏 0 原文

~没有更多了~