How to filter dates within a range in Pandas DataFrame?

Question

I have a df where I'd like to filter the table by a single date column, specifically dates that are within 1 year of today.

I've tried the following with no luck:

df[df['latest start date'] > (date.today() + timedelta(weeks=-52))]

The error message I get is:

TypeError: '>' not supported between instances of 'str' and 'datetime.date'

Any help would be greatly appreciated.

Transform your date to datetime: df['latest start date'] = pd.to_datetime(df['latest start date'] ) before that line. — Quang Hoang
– Quang Hoang, Commented Apr 23, 2020 at 13:06

Nathan Mathews · Accepted Answer · 2020-04-23 13:09:18Z

2

Your date column is not of type date.

df['latest start date'] = pd.to_datetime(df['latest start date'])

Now you can compare the two because they are both of type datetime

answered Apr 23, 2020 at 13:09

Nathan Mathews

1511 silver badge5 bronze badges

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

3 Comments

Phil Collins Over a year ago

One step closer, thank you. However I now get this TypeError: Invalid comparison between dtype=datetime64[ns] and date

Phil Collins Over a year ago

Actually, I solved it. Just amended the formula to this df[df['latest start date'] > (datetime.datetime.now() + timedelta(weeks=-52))] after your suggestion.

Nathan Mathews Over a year ago

Glad I could help, yep datetime and date are different I should have caught that

Collectives™ on Stack Overflow

How to filter dates within a range in Pandas DataFrame?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related