Forward fills Column names
Thu Aug 06 2020 08:57:00 GMT+0000 (UTC)
When reading excel files of government data, often it's structured in a way where they use the merge columns in excel so a column name is spread across multiple cells. reading this into pandas, only the cell with the column name retains the name and the others are renamed as 'Unnamed:<number>'. This code helps forward fill the Unnamed cells to have the same as the named cell.