pandas - pandas string to date type conversion in proper format

Question

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?

标签： pandas

Answer 1

to_datetime与添加的年份和参数一起使用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