Convert datetime64[ns] Index to date pandas for comparison

Question

I have the following python code:

current_ts = datetime.datetime.now()
current_date = current_ts.date()

new_df = df[df.index >= current_date]

The df.index is a datetime64[ns] and when I run the code I get Invalid comparison between dtype=datetime64[ns] and date.

How can I convert the index into a date so that the comparison works?

Quang Hoang · Accepted Answer · 2020-11-11 20:37:57Z

1

Pandas datetime64[ns] doesn't compare directly to datetime.date. You need to convert:

df[df.index >= pd.Timestamp(current_date)]

answered Nov 11, 2020 at 20:37

Quang Hoang

151k11 gold badges64 silver badges86 bronze badges

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

1 Answer 1