How To Change The Format Of Date In A Dataframe?

I have a date column in a dataframe in the format yyyy/mm/dd like this: Date 2016/08/22 2016/08/10 2016/08/08 ... How do I convert it into dd/mm/yyyyformat??

Solution 1:

I assume the column is in string.

import pandas as pd

df = (pd.DataFrame([['2016/08/22']*10]*10))

df[0] = pd.to_datetime(df[0]).apply(lambda x:x.strftime('%d/%m/%Y'))

output:

Solution 2:

Use a vectorized approached with the dt accessor in combination with strftime

df = pd.DataFrame(dict(date=['2011/11/30', '2012/03/15']))
df['date'] = pd.to_datetime(df.date).dt.strftime('%d/%m/%Y')

print(df)

         date
0  30/11/2011
1  15/03/2012

Solution 3:

Suppose your dataframe df has date column 'date', then you can use this method, to change your date format.

df['date'] = df['date'].dt.strftime('%m/%d/%Y')