Convert a date format with month name into proper date with pandas

Question

I have a date column having values like 'November 4, 2016'

Can we convert it into proper date using pandas like this format '4/11/16'

using pandas to_datetime or any other funtion.

question from:https://stackoverflow.com/questions/66058307/convert-a-date-format-with-month-name-into-proper-date-with-pandas

Answer 1

Consider df:

In [463]: df = pd.DataFrame({'date': ['November 4, 2016', 'December 1, 2017']})

In [464]: df
Out[464]: 
               date
0  November 4, 2016
1  December 1, 2017

Use pd.to_datetime with Series.dt.strftime:

In [469]: df['date'] = pd.to_datetime(df['date'], format='%B %d, %Y').dt.strftime('%d/%m/%y')

In [479]: df
Out[479]: 
       date
0  04/11/16
1  01/12/17