UNPIVOT - PYTHON PANDAS

Last week’s post was about how to Unpivot with power query this week I want to do the same thing with python and pandas using the melt method, to see what is the most practical and witch one is faster. I will star by importing the file as I explain it in My Pandas Cheat sheet 

What do I need to do ? 

Get the report with an updated version of the same file. The main problem with that document is its format 

The final format is the other way around with a column by month and a column for the amount

How to do it with python ? 

1.Import file into a pandas data frame and remove extra rows 

2.I use dtype on the data frame to get the list of columns 

3.The code for the unpivot 

3.1 The resulting code 

4. export file 

Conclusion 

• Python and pandas is faster when I know what I’m looking for 

• Excel is better to go threw the data an find strange thing or filter it faster

• So I will use Excel to explore the data and python for the final output