String to Datetime onject in DataFrame while ignore empty strings

Question

I have a column date in a DataFrame, it is either empty or have a string in this format '2021-06-04T15:14:30.512Z' I want to convert this to Datetime object but not sure how to handle the empty columns. I want to keep them empty or null but convert the rest. I tried to use this to convert string to datetime

from dateutil import parser
a = '2021-06-04T15:14:30.512Z'
datetime.fromisoformat(a)

But unable to use this across dataframe column while ignoring the empty string. Can someone please help me? Thanks

Anurag Dabas · Accepted Answer · 2021-06-10 02:37:14Z

2

import pandas as pd

try with errors='coerce' parameter in to_datetime() method:

df['date']=pd.to_datetime(df['date'],errors='coerce')

If you want only date part:

df['date']=pd.to_datetime(df['date'],errors='coerce').dt.date

edited Jun 10, 2021 at 2:37

answered Jun 10, 2021 at 2:26

Anurag Dabas

24.3k9 gold badges25 silver badges41 bronze badges

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

Collectives™ on Stack Overflow

String to Datetime onject in DataFrame while ignore empty strings

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related