I have a multi column/row spreadsheet.
The first column level is = date1, date2, date3.
The second column level is sex: male, female.
Hence the total is equal to 6 columns
date1, date2, date3
M, F M, F M, F
now, the table has also has multi level rows. I have countries and and cities within each country.
How can I import this pre-made excel table into a pandas dataframe? Many thanks for your help!