How to filter column by date in Python?

Question

Attempting to filter df to only include rows with date before 2018-11-06.

Column is in datetime format. Running this code returns only rows with exact date of 2018-11-06 instead of values less than. Also, when running code with less than symbol '<', only dates later than 2018-11-06 are returned. It appears that I am doing something very incorrectly.

db4=db3[~(db3['registration_dt']>'2018-11-06')]

Make sure you are using the correct types. Could you give the output of db3['registration_dt'].dtype? — Erik
– Erik, Commented Dec 4, 2021 at 21:52
Another possible duplicate: stackoverflow.com/questions/43344656/pandas-filter-csv-by-date — Alan
– Alan, Commented Dec 4, 2021 at 21:55

Erik · Accepted Answer · 2021-12-04 22:00:03Z

1

It seems like you are comparing the string '2018-11-06' with a datetime.

import datetime as dt

# Selects all rows where registration date is after 6 november 2018
df = db3[db3['registration_dt']>dt.datetime(2018,11,6)]


# Selects all rows where registration_dt is before 6 november 2018
df = db3[db3['registration_dt']>dt.datetime(2018,11,6)]

# The ~ symbol can be read as not
# This selects all rows before or equal to 6 november 2018
df = db3[~(db3['registration_dt']>dt.datetime(2018,11,6))]

answered Dec 4, 2021 at 22:00

Erik

9391 gold badge7 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

How to filter column by date in Python?

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