Issue with converting string to a datetime in Python

Question

I've a datetime (int64) column in my pandas dataframe. I'm trying to convert its value of 201903250428 to a datetime value.

The value i have for the datetime (int64) column is only till minute level with 24 hours format.

I tried various methods like striptime, to_datetime methods but no luck.

pd.datetime.strptime('201903250428','%y%m%d%H%M')

I get this error when i use the above code.

ValueError: unconverted data remains: 0428

I wanted this value to be converted to like '25-03-2019 04:28:00'

Daniel Roseman · Accepted Answer · 2019-04-10 15:46:11Z

1

Lower-case y means two-digit years only, so this is trying to parse "20" as the year, 1 as the month, 9 the day, and 03:25 as the time, leaving "0428" unconverted.

You need to use %Y which will work fine:

pd.datetime.strptime('201903250428','%Y%m%d%H%M')

http://strftime.org/ is a handy reference for time formatting/parsing parameters.

answered Apr 10, 2019 at 15:46

Daniel Roseman

602k68 gold badges910 silver badges923 bronze badges

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

1 Comment

Simbu Over a year ago

Thanks Daniel. Your answer helped me for this calculation. pd.to_datetime('201903250428',format='%Y%m%d%H%M',errors='coerce')

Collectives™ on Stack Overflow

Issue with converting string to a datetime in Python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related