I have a date and time column which I set using pd.to_datetime but panda reads the date wrong when the first value is not a 0. Example is 5/08/2021 when it needs to be 05/08/2021. If the date is 10/08/2021 it reads it fine.
Can you please help with a python loop style code which looks at each date per row and if there is a / as the second value then add a 0 at the front of the date. If the second value is not a / then skip to the next row.
I want to use this code when the column is in object format. Then when the column is edited I will do the pd.to_datetime.
Thanks if you can help.
Aucun commentaire:
Enregistrer un commentaire