Converting an object to datetime with Pandas to_datetime not working

Question

So I try to convert an object to pandas datetime with the to_datetime option. However it is not working.

My code:

ship_date = pd.to_datetime(d['shipmentDate'])

print(ship_date.head())

Output:

0    2019-11-08 18:57:31+01:00
1    2019-11-08 16:30:02+01:00
2    2019-11-08 15:28:32+01:00
3    2019-11-08 11:56:32+01:00
4    2019-11-08 11:56:02+01:00
Name: shipmentDate, dtype: object

Even when trying to use format like so: ship_date = pd.to_datetime(d['shipmentDate'], format='%Y-%m-%d %H:%M:%S%z')

I still get an object and not a datetime. What am I doing wrong?

Your code is working fine for me with and without specifying the format option. Can you provide more details such as the original type of 'shipmentDate' column in the DataFrame? — Gautham Pughazhendhi
– Gautham Pughazhendhi, Commented Nov 9, 2019 at 13:02

Quang Hoang · Accepted Answer · 2019-11-09 13:05:17Z

4

Your datetime has different time zones. You can pass utc=True to to_datetime.

answered Nov 9, 2019 at 13:05

Quang Hoang

151k11 gold badges64 silver badges86 bronze badges

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

Collectives™ on Stack Overflow

Converting an object to datetime with Pandas to_datetime not working

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