Tackling multi row headers in excel using pandas

Hiya good people,

I am trying to solve for a multi row header problem in reading an excel file. Can pandas unpivot the columns so that we can generate an excel file finally which will have a uniform data structure, with one column header for one type of data?

Hi there have you checked this out… I see the melt method can help you unpivot…
unpivot excel data with melt