Skip to main content
 首页 » 编程设计

python之在日期时间范围列表之间选择 Pandas 行

2025年01月19日8zhwl

我有一个数据框,df:

                     event 
time 
2013-10-09 06:27:00   breakfast 
2013-10-09 07:25:00      school 
2013-10-09 10:25:00        exam 
2013-10-09 12:00:00       lunch 
2013-10-09 12:00:00    homework 
2013-10-09 19:20:00      dinner 
2013-10-09 23:25:00       sleep 

我还有两个相同大小的时间列表:

lower = array(['2013-10-09T06:15:00.000000000',  
               '2013-10-09T07:00:00.000000000', 
               '2013-10-19T13:00:00.000000000',  dtype='datetime64[ns]') 
 
upper = array(['2013-10-09T11:15:00.000000000',  
               '2013-10-09T12:00:00.000000000', 
               '2013-10-09T17:00:00.000000000', dtype='datetime64[ns]') 

是否有一种非迭代的 Pandas 式方式可以让我获得 df 中的行 [upper[0],lower[0]], [upper[1],lower[1]], [upper[2],lower[2]], ... 这样我们得到

                     event 
time 
2013-10-09 06:27:00   breakfast 
2013-10-09 07:25:00      school 
2013-10-09 10:25:00        exam 
2013-10-09 07:25:00      school 
2013-10-09 10:25:00        exam 
2013-10-09 12:00:00       lunch 

作为输出?

请您参考如下方法:

一个非常 Pandas 式的(但可能不是内存效率高的):

( 
    events.assign(key=1) 
    .merge(pd.DataFrame({"lower": lower, "upper": upper, "key": 1}), on="key") 
    [lambda df: df.time.between(d.lower, d.upper)] 
    [["time", "event"]] 
    .drop_duplicates() 
)