Python : How to reorder date column in dataframe with pandas dataframe

Question

have a df with values :

name      age 
 
mark    2002-12-19    
tom     2003-11-30

how to reorder the date format with dd mm yyyy

name      age 
 
mark    19-12-2002    
tom     30-11-2003

but it is storing as string. i need in date format

Chris · Accepted Answer · 2020-07-22 13:18:05Z

1

Assuming your date stamps are valid, which your second one appears to not be.

df['age'] = pd.to_datetime(df['age']).dt.strftime('%d-%m-%Y')

answered Jul 22, 2020 at 13:18

Chris

16.3k3 gold badges26 silver badges41 bronze badges

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

1 Comment

ValueError: invalid literal for int() with base 10: '30-07-2018'

Youyoun · Accepted Answer · 2020-07-22 13:18:35Z

0

df.loc[:, "age"] = pd.to_datetime(df["age"], format="%Y-%m-%d").dt.strftime("%d-%m-%Y")

you can then use .sort_values() to sort the dates as you wish.

answered Jul 22, 2020 at 13:18

Youyoun

3381 silver badge5 bronze badges