Using another timestamp dataframe to filter a timestamp dataframe on pandas

Question

My primary dataframe df

Id  timestamp
265 2017-05-22 02:57:29
267 2017-05-22 04:35:18
279 2017-05-22 11:08:14
281 2017-05-22 11:39:39
282 2017-05-22 11:40:42
285 2017-05-22 11:52:48
288 2017-05-22 12:00:29

My filter dataframe df2

Id  timestamp
283 2017-05-22 11:46:55
284 2017-05-22 11:51:41
286 2017-05-22 11:58:20

Normally I did

df[(df['timestamp'] >= '2017-05-22 11:46:55') & (df['dt'] =< '2017-05-22 11:58:20')]

But, this is not production friendly, and less reproducible

jezrael · Accepted Answer · 2018-04-03 05:40:47Z

1

Use between by min and max datetimes of df2:

df3 = df[df['timestamp'].between(df2['timestamp'].min(), df2['timestamp'].max())]
print (df3)
    Id           timestamp
5  285 2017-05-22 11:52:48

edited Apr 3, 2018 at 5:40

answered Apr 3, 2018 at 5:32

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Nabih Bawazir Over a year ago

is between means (>= and <=) or (> and <)

jezrael Over a year ago

It is inclusive=True by default, so >= and <=.

jezrael Over a year ago

But if add inclucive=False then get > and <

jezrael Over a year ago

@NabihBawazir - Super, nice day!

Collectives™ on Stack Overflow

Using another timestamp dataframe to filter a timestamp dataframe on pandas

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related