Converting string to datetime object in pandas

Question

I have a column called 'SubmitTime' which is a string per observation. An example would be: 'Wed Apr 12 14:42:23 PDT 2017'

I need to sort this dataframe based on submission time (the ones that submitted first, are on top). How can I convert this column into datetime and sort the dataframe in Pandas?

Possible duplicate of Convert Pandas Column to DateTime

tmrlvi
– tmrlvi

2017-04-14 08:09:48 +00:00
Commented Apr 14, 2017 at 8:09 — tmrlvi
– tmrlvi, Commented Apr 14, 2017 at 8:09

piRSquared · Accepted Answer · 2017-04-12 22:11:12Z

1

Assuming you dataframe is df

df.iloc[pd.to_datetime(df.SubmitTime).argsort()]

This leaves your dataframe intact, 'SubmitTime' remains strings

Otherwise, I'd convert 'SubmitTime' to datetime and sort

df.assign(SubmitTime=pd.to_datetime(df.SubmitTime)).sort_values('SubmitTime')

answered Apr 12, 2017 at 22:11

piRSquared

296k68 gold badges509 silver badges654 bronze badges

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

Collectives™ on Stack Overflow

Converting string to datetime object in pandas

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related