Issue converting python dataframe datatype from object to datetime

Question

An example of a value in the Date column:

19/08/2017

Previously, I tried:

dividends['Date'] = pd.to_datetime(dividends['Date'])

to convert my column to have a datetime date type. However, when I then created charts out of this dataset (with 'Date' having a datetime date type), it always looked odd:

Having done a bit of trouble shooting online, I think the reason is because of the formatting of my datetime conversion. However, when I try to use this:

dividends['Date'] = pd.to_datetime(dividends['Date'],format='%d-%m-%y')

I get the error message

ValueError: time data '19/08/2017' does not match format '%d-%m-%y' (match)

Why is this, and how do I fix it? Cheers.

Change format to '%d/%m/%Y'. Does it work now?

Sebastian
– Sebastian

2020-05-25 23:40:53 +00:00
Commented May 25, 2020 at 23:40 — Sebastian
– Sebastian, Commented May 25, 2020 at 23:40

oreopot · Accepted Answer · 2020-05-29 01:26:03Z

1

Use the following code:(note that I used Y in format):

dividends['Date'] = pd.to_datetime(dividends['Date'],format='%d-%m-%Y')

You could also use the following format:

'%d/%m/%Y'

edited May 29, 2020 at 1:26

answered May 25, 2020 at 23:41

oreopot

3,4592 gold badges23 silver badges31 bronze badges

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

Collectives™ on Stack Overflow

Issue converting python dataframe datatype from object to datetime

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