CODEWITHSUNDEEP
pandas
Zaynul Abadin Tuhin
Zaynul Abadin Tuhin

Reputation: 31993

pandas string to date type conversion in proper format

I am getting date data in string format in pandas like 10-Oct,11-Oct but i want to make it date data type like this format 2019-10-10,2019-10-11 is there any easy way available in pandas?

Upvotes: 3

Views: 48

Answers (1)

jezrael
jezrael

Reputation: 862611

Use to_datetime with added year and parameter format:

df = pd.DataFrame({'date':['10-Oct', '11-Oct']})

df['date'] = pd.to_datetime(df['date'] + '-2019', format='%d-%b-%Y')
print (df)
        date
0 2019-10-10
1 2019-10-11

Upvotes: 3

Related Questions