Converting column in Dataframe to datetime

Question

I've been trying to use the to_datetime function to convert values in my column to datetime:

df['date'] = pd.to_datetime(df['date'],errors='coerce',format='%Y-%m-%d %H:%M:%S %z %Z')

After that, I received only NaT values.

Example: Value Format in Column: '1979-01-01 00:00:00 +0000 UTC'

After that, I get an error: Unknown string format: 1979-01-01 00:00:00 +0000 UTC — Katarzyna
– Katarzyna, Commented Mar 9, 2020 at 13:48

mjspier · Accepted Answer · 2020-03-09 14:02:40Z

3

I think you can't parse utc offset (+0000) and timeszone information at the sime time.

You might want to remove the UTC at the end and only parse the offset.

df['date'] = df.date.str[:-4]
df['date'] = pd.to_datetime(df['date'], format='%Y-%m-%d %H:%M:%S %z')

answered Mar 9, 2020 at 14:02

mjspier

6,5565 gold badges35 silver badges47 bronze badges

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

1 Comment

Katarzyna Over a year ago

It worked, I changed it to: df.date = df.date.astype(str) df['date'] = df.date.str[:-3] and then df['date'] = pd.to_datetime(df['date'], utc=True) Thank you

Josh Friedlander · Accepted Answer · 2020-03-09 14:03:31Z

1

Pandas can't manage both %z and %Z as you can see here. Note that Python's strptime can handle this, but doesn't deal with %Z.

In your case you might want to just peel off the last bit with ser.str and consider opening a feature request.

answered Mar 9, 2020 at 14:03

Josh Friedlander

11.8k7 gold badges42 silver badges89 bronze badges

Collectives™ on Stack Overflow

Converting column in Dataframe to datetime

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related