Changing date format in python

Question

I have a pandas dataframe with a column containing a date; the format of the original string is YYYY/DD/MM HH:MM:SS. I am trying to convert the string into a datetime format, by using

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

but plotting it I can see it doesn't recognize the correct format. Can you help me to understand whether there is an option to give python the correct format to read the column? I have seen the format tag for to_datetime function, but I can't use it correctly.

Thanks a lot for your help!

can you post the output of print(df.dtypes) __after __ the call of pd.to_datetime(...)? — MaxU - stand with Ukraine
– MaxU - stand with Ukraine, Commented Jul 15, 2016 at 15:41

MaxU - stand with Ukraine · Accepted Answer · 2016-07-15 18:48:54Z

1

Try this:

df['Date'] = pd.to_datetime(df['Data'], format='%Y/%d/%m %H:%M:%S')

answered Jul 15, 2016 at 18:48

MaxU - stand with Ukraine

212k37 gold badges402 silver badges436 bronze badges

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

Comments

Jason Callahan · Accepted Answer · 2016-07-15 15:59:49Z

0

It looks like you're using a non-standard date format. It should be YYYY-MM-DD. Try formating with the strptime() method.

time.strptime('2016/15/07', '%Y/%d/%m')

If you need to get it to a string after that use time.strftime().

answered Jul 15, 2016 at 15:59

Jason Callahan

5255 silver badges7 bronze badges

1 Comment

lapally Over a year ago

Thanks a lot! Can I also deal with time with this method?

Collectives™ on Stack Overflow

Changing date format in python

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related