How do I unpivot this multiple header and variable data table?

Question

I have a lab report in excel which contain multiple level of header and multiple variables as well,

enter image description here

I'd like to unpivot it to a flat table with pandas into the format shown as in the picture below, can someone help?

Don't use images, instead add code that creates a sample of your input dataframe. [See this post](https://stackoverflow.com/questions/20109391/how-to-make-good-reproducible-pandas-examples?answertab=oldest#tab-top) — Scott Boston, Oct 08 '19 at 15:01

score 0 · Accepted Answer · answered Oct 08 '19 at 15:05

0

And then stack your dataframe with df.stack().

answered Oct 08 '19 at 15:05

Hadas Arik

1 Answers1