给定一个包含多个日期和每个日期多次的panda数据帧，我如何选择每个日期的时间

Question

我尝试过：

start_date = '2019-12-02'
end_date = '2019-12-02'
day_df = df[(df['timestamp'] >= start_date) & (df['timestamp'] <= end_date)]

返回一个空的数据帧

我也试过：

start_date = '2019-12-02' + ' 00:00:00'
end_date = '2019-12-02' + ' 23:59:59'

它还返回一个空的数据帧。

编辑：示例数据

2019-12-02 06:41:54
2019-12-02 06:41:54
2019-12-03 00:38:56
2019-12-03 06:37:13
2019-12-03 06:52:09

感谢

Answer 1

根据您的评论，这可能有效：

df['timestamp'] = pd.to_datetime(df.timestamp)
df.set_index('timestamp', inplace=True)  # a DateTimeIndex is necessary to use between_time
start_time = '00:00:00'
end_time = '23:59:59'
df.between_time(start_time, end_time).resample('D').mean()