How to check if pandas DateTimeIndex dates belong to a list?

Question

I have a pandas datetime index idx with with minute frequency, I also have a list(or set) of dates list_of_dates. I would like to return a boolean array of the same size of idx with the condition that the dates of datetime index belong is in the list_of_dates. Is it possible to do it in a vectorized way (i.e. not using a for loop)?

Does this answer your question? Use a list of values to select rows from a Pandas dataframe — Anurag Dabas
– Anurag Dabas, Commented Jul 22, 2021 at 12:56

not_speshal · Accepted Answer · 2021-07-22 13:02:16Z

1

Since you're trying to compare only the dates, you could remove the times and compare like so:

>>> df.index.normalize().isin(list_of_dates)

Or:

>>> df.index.floor('D').isin(list_of_dates)

answered Jul 22, 2021 at 13:02

not_speshal

23.2k2 gold badges18 silver badges33 bronze badges

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

Collectives™ on Stack Overflow

How to check if pandas DateTimeIndex dates belong to a list?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related