python - 选择两个给定日期之间的 pandas 数据框，其中两列的值相等

Question

我可以通过首先将日期时间 created 列设置为索引并切片数据帧来选择两个日期之间的 pandas 数据帧。但现在我想做一个涉及附加日期时间列“modifieddate”的新查询，即:

df = df.set_index(['created'])
print (df)
                        name      modifieddate
created                                                        
2014-01-01 16:07:07     john      2014-01-01 16:07:07
2014-01-04 16:07:07     harold    2014-01-04 16:07:07
2014-01-04 16:07:07     clara     2014-01-04 18:07:07
2014-01-05 16:07:07     emily     2014-01-06 16:07:07
2014-01-08 16:07:07     smiths    2014-01-08 16:07:07
2014-01-09 20:07:07     clara     2014-01-09 20:07:07
2014-01-10 18:07:07     clara     2014-01-10 18:07:07
2014-01-10 16:07:07     john      2014-01-11 16:07:07

选择created和modifieddate相等且介于给定日期时间2014-01-04 16:07:07和之间的行>2014-01-10 16:07:07:

                        name      modifieddate
created                                                        
2014-01-04 16:07:07     harold    2014-01-04 16:07:07 
2014-01-08 16:07:07     smiths    2014-01-08 16:07:07
2014-01-09 20:07:07     clara     2014-01-09 20:07:07

Answer 1

您可以使用between与 boolean indexing :

s = '2014-01-04 16:07:07'
e = '2014-01-10 16:07:07'
df = df[(df.index.to_series().between(s,e)) & 
        (df.modifieddate.between(s,e)) & 
        (df.index == df.modifieddate)]
print (df)
                       name        modifieddate
created                                        
2014-01-04 16:07:07  harold 2014-01-04 16:07:07
2014-01-08 16:07:07  smiths 2014-01-08 16:07:07
2014-01-09 20:07:07   clara 2014-01-09 20:07:07