Python Pandas: string to datetime

Question

I have a Pandas dataframe with a datetime column in string format. The format is like this:

06 Feb 2014 12:09:42:000

I need to convert this to datetime. Right now I have:

df['date'] = pd.to_datetime(df['STARTDATE'],format='')

My issue is, I do not know what to put in the format argument to parse the string correctly. Can this be done, or is there a better function to use?

see this strftime.org

piRSquared
– piRSquared

2017-07-10 17:26:10 +00:00
Commented Jul 10, 2017 at 17:26 — piRSquared
– piRSquared, Commented Jul 10, 2017 at 17:26

jezrael · Accepted Answer · 2017-07-10 17:25:25Z

7

You can check http://strftime.org/ and use:

df['date'] = pd.to_datetime(df['STARTDATE'],format='%d %b %Y %H:%M:%S:%f')

Sample:

df = pd.DataFrame({'STARTDATE':['06 Feb 2014 12:09:42:000','06 Mar 2014 12:09:42:000']})
print (df)
                  STARTDATE
0  06 Feb 2014 12:09:42:000
1  06 Mar 2014 12:09:42:000

df['date'] = pd.to_datetime(df['STARTDATE'],format='%d %b %Y %H:%M:%S:%f')
print (df)
                  STARTDATE                date
0  06 Feb 2014 12:09:42:000 2014-02-06 12:09:42
1  06 Mar 2014 12:09:42:000 2014-03-06 12:09:42

answered Jul 10, 2017 at 17:25

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Collectives™ on Stack Overflow

Python Pandas: string 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