我有这个数据框架:
forecasts
Out[15]:
timestamp 1 2
0 2022-11-08 12:12:15 5679.658691 5400.217773
1 2022-11-08 12:38:49 5679.658691 5400.217773
2 2022-11-09 11:05:53 5863.616699 5619.101562
3 2022-11-10 10:46:27 6047.025391 5714.026367
4 2022-11-11 11:59:29 6147.197754 5750.312988
5 2022-11-12 11:56:45 6008.574707 5775.820312
我正在试着获得特定日期的天气预报,而不包括小时:
forecasts = forecasts[forecasts['timestamp'] == pd.Timestamp(str(2022) + '-' + str(11) + '-' + str(11))]
读取日期:
2022-11-11 11:59:29
但是我收到一个空的dataframe
。我怎样才能解决这个问题呢?
可以使用:
forecasts = forecasts[forecasts['timestamp'].dt.strftime('%Y-%m-%d') == '2022-11-11']
#or
forecasts = forecasts[forecasts['timestamp'].dt.strftime('%Y-%m-%d') == (str(2022) + '-' + str(11) + '-' + str(11))]