the cells are merged because, if you open in Excel directly (double click on the file and Excel the default program for .csv), it asks what delimiter to use, and pushes everything as it is convenient.
- or Google "How to import CSV to Excel" (Tab "data" ->>"from text") and there will be a CLEAR choice of the delimiter, choose a space in Your case-and everything will be OK.
- either use Libre Office ,which when opened , asked "what is the delimiter we will use the" - choose a space and you will be OK.
delimiter=' ' here in Your case, you specify the separator
- "Day of the week" - better: "Weekday" - well, still space to share, you never know.
- well, Pandas are certainly not necessary, for this task, too.