Using Datetime to convert a pandas dataframe column (string)

Question

I am trying to convert the following string in datetime format

"14DEC2014"

Does anyone have an advice on how to do this, I have been stuck on this one for a day or two now

Does this answer your question? Parsing date/time strings in Pandas DataFrame — assylias
– assylias, Commented Nov 1, 2019 at 15:13

Hoekieee · Accepted Answer · 2019-11-01 15:20:02Z

0

import pandas as pd

test = '14DEC2014'
test = pd.to_datetime(test)
print(test)

output:

2014-12-14 00:00:00

If you would like to only have the date:

test = pd.to_datetime(test).date()

output:

2014-12-14

answered Nov 1, 2019 at 15:20

Hoekieee

4012 silver badges16 bronze badges

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

1 Answer 1