how can I upload a 4 multi index level row hierarchy from excel into a pandas dataframe?

user_8363516 0
Viewed 79

I spend hours trying to find a solution but nothing so far. I have the following table (see screenshot). can anybody please shed some light and explain me how to upload it into a dataframe? Many thanks, Andrea

enter image description here

enter image description here

multi-index pandas dataframe python
1 Answers

Try this:

pd.read_excel('data.xlsx', header=[0,1], index_col=[0,1,2,3])
user_63615310
Related