Skip to content
Advertisement

How to normalise a date columnin pandas dataframe to the same format

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

output:

JavaScript
User contributions licensed under: CC BY-SA
1 People found this is helpful
Advertisement