How to custom parse dates in pandas

Question

I know this seems like a duplicated question (and it kinda is), but previous answers didn't let me achieve what I'm looking for. I have a date Series with the following format:

     date
 Jun 13 14:46
 Jun 13 17:11

And so, I wanted to turn it into a datetime object. I did the following:

pd.to_datetime(df.date, format='%b %d %I:%M')

Which based on this question should be enough: Convert custom date formats in pandas

But, I'm still getting ValueError: time data 'Jun 13 14:46' does not match format '%b %d %I:%M' (match)

What am I missing?

Thanks

Adam.Er8 · Accepted Answer · 2019-06-18 16:04:53Z

4

try pd.to_datetime(df.date, format='%b %d %H:%M')

%I is for a 12-hour clock.

%H is for a 24-hour clock.

answered Jun 18, 2019 at 16:04

Adam.Er8

13.5k3 gold badges32 silver badges43 bronze badges

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

2 Comments

Juan C Over a year ago

Damn. Thanks, that solves the issue! Do you know where can I find the meaning of all the date FormatString? I wasn't able to find them

Adam.Er8 Over a year ago

in the docs for the datetime.strptime function: docs.python.org/3/library/…

Collectives™ on Stack Overflow

How to custom parse dates in pandas

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related