Error handling when converting to datetime Python

Question

I want to convert a column to type date time. Some of the date are invalid, and I want to get rid of them. Here's what I have right now

df_event['event_date'] = try: pd.to_datetime(df_event['event_date']) except ValueError as e: pass

It says this is invalid syntax. What would be the correct syntax here? Moreover, for this piece of code, I'm trying to convert first, then I'll drop the rows where the value is not date time. Is there a way to drop the invalid rows direcrly in one step?

stunner.agk · Accepted Answer · 2020-10-24 23:02:44Z

2

You should move the assignment operation inside your try block and the syntax error should go away. Also, I'm not sure if writing the whole code in single line would work for an indentation strict language like Python.

try: 
    df_event['event_date'] = pd.to_datetime(df_event['event_date']) 
except ValueError as e: 
    pass

answered Oct 24, 2020 at 23:02

stunner.agk

363 bronze badges

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

2 Comments

Tianhe Xie Over a year ago

Any idea how to drop the invalid values as I convert them?

stunner.agk Over a year ago

You could put the try block in a loop that iterates over each of the dates. In the try block, you could use the date after a successful conversion. If the conversion fails, the value won't be used and you could move on to the next iteration. Adding a similar question for reference stackoverflow.com/questions/19522990/…

Collectives™ on Stack Overflow

Error handling when converting to datetime Python

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related