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

tried this How to change the datetime format in pandas
but it is storing as string. i need in date format

Youyoun · Answer

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.

Chris · Answer

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')

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

2 Answers

Add your own answers!

Ask a Question