Remove specific rows that contain dates Python

Question

I have a dataset that has datetime values in it. I would like to remove all rows within a specific column that contain a certain year. All rows that contain 2027 should be removed.

Data

ID  Date                Type
AA  2027-04-03 00:00:00 ok
AA  2027-05-06 00:00:00 no
BB  2027-07-05 00:00:00 yes
BB  2026-06-05 00:00:00 yes

Desired

ID  Date                Type
BB  2026-06-05 00:00:00 yes

Doing

df1 = df[df["Date"].str.contains("-2027") == False]

Any suggestion is appreciated. Error: AttributeError: Can only use .str accessor with string values!

I believe I need to do some type of conversion here.

Naveed · Accepted Answer · 2022-08-04 00:16:45Z

1

since the data is already a datetime type, str accessor fails. Following should resolve it

df1=df[df["Date"].dt.year != 2027]

    ID  Date    Type
3   BB  2026-06-05  yes

answered Aug 4, 2022 at 0:16

Naveed

11.7k2 gold badges16 silver badges21 bronze badges

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

Comments

Luis Alejandro Vargas Ramos · Accepted Answer · 2022-08-04 00:08:36Z

1

You can convert the column date to a string and apply your code:

df['Date'] = df['Date'].astype(str)
df1 = df[df["Date"].str.contains("2027") == False]

answered Aug 4, 2022 at 0:08

Luis Alejandro Vargas Ramos

1,0082 gold badges10 silver badges20 bronze badges

Comments

wwnde · Accepted Answer · 2022-08-04 00:10:03Z

1

Corse date to datetime, extract year and check if equal to 2027

df[pd.to_datetime(df['Date']).dt.year==2027]

answered Aug 4, 2022 at 0:10

wwnde

26.7k6 gold badges22 silver badges38 bronze badges

Collectives™ on Stack Overflow

Remove specific rows that contain dates Python

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related