How can I convert string to datetime?

Question

How can I convert string column to datetime in pandas?

My columns is as follows

Date

01Jan2019
01Feb2019
01Mar2019

How can I convert this to a pandas date time?

Does this answer your question? Convert Pandas Column to DateTime — busybear
– busybear, Commented Feb 17, 2020 at 3:07
Does this answer your question? Converting string into datetime — Grismar
– Grismar, Commented Feb 17, 2020 at 3:27
What’s the problem? Have you tried anything, done any research? Stack Overflow is not a free code writing service. See: tour, How to Ask, help center, meta.stackoverflow.com/questions/261592/…. — AMC
– AMC, Commented Feb 17, 2020 at 4:02
Does this answer your question? How to convert string to datetime format in pandas python? — AMC
– AMC, Commented Feb 17, 2020 at 4:02

kavish-p · Accepted Answer · 2020-02-17 03:45:45Z

1

The following code will convert your String column to datetime64

df['Date'] = pd.to_datetime(df['Date'], infer_datetime_format=True)

answered Feb 17, 2020 at 3:45

kavish-p

826 bronze badges

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

Comments

puhuk · Accepted Answer · 2020-02-17 03:40:41Z

0

Could you try with below code

from datetime import datetime
datetime_object =datetime.strptime('01Jan2019', '%d%b%Y')

answered Feb 17, 2020 at 3:40

puhuk

4847 silver badges18 bronze badges

The question is about Pandas, no?