I have a excel file with some data and the column of dates is what i think a mess.
I want to format this column to UTC standard, but some records have the month swapped with the day. If it was some records i would fix it manually, but there are too many.
Example:
| id | creation_date |
|---|---|
| 0 | 01/01/2007 |
| 1 | 02/01/2007 |
| 2 | 03/01/2007 |
| 3 | 04/01/2007 |
| 4 | 01/05/2007 |
| 5 | 01/06/2007 |
| 6 | 01/07/2007 |
I trying achive this with python and pandas, but i'm having some hard time.
I appreciate any help.