To keep it brief, I am exporting data to excel and I would like to format two columns to short date format. Column 1 is in the format mm/dd while column two is already in mm/dd/yyyy (my ideal format). I believe Xlsx writer or pandas might work here but I cannot figure the Syntax out. Anyone help here is greatly appreciated.
This is the origin of the data I am scraping. This is the format I scrape the date
This is the code I use to scrape the date as well as split, and then append the two columns
Last, I insert the Stay Start and Stay End columns into excel using pandas