我有一個(TimeSeries 數據)數據框,它看起來像這樣: A1 A2 ... Z1 Z22019-06-17 00:00:01 NaN NaN ... NaN NaN2019-06-17 00:01:59 NaN NaN ... NaN NaN2019-06-17 00:02:29 NaN NaN ... NaN NaN ... ... ... ... ...2020-06-17 23:55:01 NaN NaN ... NaN NaN 2020-06-17 23:58:45 NaN NaN ... NaN NaN2020-06-17 23:59:59 NaN NaN ... NaN NaN問題:人們需要按白天(00:00:00)進行選擇,因為秒數也可以達到 59,因此需要保持靈活性。我如何提取給定兩個時間值之間的索引(例如 15:00:00、24:00:00)但是:僅在特定的日期范圍內(例如星期一至星期四)?(這就是我提取范圍值的方式:)timeRangesString = "Mon,Thur,15:00,24:00" #<== the inputrangeIndices = pd.Index()# time ranges:start_time = time.strptime( timeRangesString.split(",")[0], "%H:%M:%S")#.dt.strftime("%H:%M", '%H:%M:%S')if timeRangesString.split(",")[1]=="24:00": end_time = pd.to_datetime("23:59:59", format="%H:%M:%S")else: end_time = time.strptime( timeRangesString.split(",")[1], "%H:%M")#.dt.strftime("%H:%M",' %H:%M:%S')# day ranges:start_dayint = time.strptime( timeRangesString.split(",")[2], "%a").tm_wdayend_dayint = time.strptime( timeRangesString.split(",")[3], "%a").tm_wday# ==> start_time == 15:00:00# ==> end_time == 23:59:59# ==> start_dayint == 0# ==> end_dayint == 3如何將范圍內的索引提取到“rangeIndices”中?
如何有效地按日內時間過濾時間序列的時間索引?
慕的地6264312
2023-03-16 15:52:52