Unpivoting with Multi-Header Columns Using Python

[Anonymous]

Hello,

I had posted about this topic earlier but I realized that while the Power Query solution works, it's not ideal for large data sets. My .pbix file keeps crashing so I am hoping I can solve this with Python. Here is the link to the earlier post with screenshots of my data and how it should look: https://community.powerbi.com/t5/Desktop/Unpivoting-with-Multi-Header-Columns/m-p/886699#M425018

I'm hoping to get my data set to transpose/pivot/unpivot with Python. Alternatively, what could be the best way to address this problem.

Thank you in advance for your help!

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

You could try melt() function in Python.

Here is the link for your reference.

https://dfrieds.com/data-analysis/melt-unpivot-python-pandas