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 — Scott Boston
– Scott Boston, Commented Oct 8, 2019 at 15:01

Hadas Arik · Accepted Answer · 2019-10-08 15:05:01Z

0

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

answered Oct 8, 2019 at 15:05

Hadas Arik

584 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1