Change dd-mm-yyyy date format of dataframe date column to yyyy-mm-dd [duplicate]

Question

I have this panda dataframe df.

Name      Date      Score  Score2
Joe     26-12-2007  53.45  53.4500
Joe     27-12-2007  52.38  52.7399
Joe     28-12-2007  51.71  51.8500

I would like to convert the date format in the Date column from dd-mm-yyyy to yyyy-mm-dd. The converted dataframe will look like this;

Name      Date      Score  Score2
Joe     2007-12-26  53.45  53.4500
Joe     2007-12-27  52.38  52.7399
Joe     2007-12-28  51.71  51.8500

I am using python v3.6

A question marked as duplicate assumes that the original date format is yyyy-mm-dd. However, the original date format in this question is dd-mm-yyyy. If I were to apply the answer in that question, the converted dates is wrong. How to change the datetime format in pandas

Answer 1

Use '%Y-%m-%d'

Ex:

import pandas as pd

df = pd.DataFrame({"Date": ["26-12-2007", "27-12-2007", "28-12-2007"]})
df["Date"] = pd.to_datetime(df["Date"]).dt.strftime('%Y-%m-%d')
print(df)

Output:

         Date
0  2007-12-26
1  2007-12-27
2  2007-12-28