I have a dataframe made from pulling in different excel sheets.
I am trying to normalise the date_time column to just a standard DD/MM/YYY format. Is that possible?
1 | DATE | Column 3 | Column 4 | Column 5 | Column 6 |
---|---|---|---|---|---|
2 | 01/03/2021 00:00 | ||||
3 | 01/03/2021 00:00 | ||||
4 | 01/03/2021 00:00 | ||||
5 | 01/03/2021 00:00 | ||||
6 | 01/03/2021 00:00 | ||||
… | … | ||||
122350 | 11/24/2022 | ||||
122351 | 11/24/2022 | ||||
122352 | 11/24/2022 | ||||
122353 | 11/24/2022 | ||||
122354 | 11/24/2022 | ||||
Advertisement
Answer
JavaScript
x
5
1
# example df
2
df = pd.DataFrame({'DATE': ['01/03/2021 00:00', '01/03/2021 00:00', '01/03/2021 00:00', '01/03/2021 00:00', '01/03/2021 00:00', '11/24/2022', '11/24/2022', '11/24/2022', '11/24/2022', '11/24/2022']})
3
df['DATE'] = pd.to_datetime(df['DATE'])
4
df['DATE'] = df['DATE'].dt.strftime('%d/%m/%Y')
5
output:
JavaScript
1
14
14
1
> df
2
3
DATE
4
0 03/01/2021
5
1 03/01/2021
6
2 03/01/2021
7
3 03/01/2021
8
4 03/01/2021
9
5 24/11/2022
10
6 24/11/2022
11
7 24/11/2022
12
8 24/11/2022
13
9 24/11/2022
14