Creating non-numeric pivot tables with Python Pandas (recipe two)
Viva Enrico Bergamini
If you ever tried to pivot a table containing non-numeric values, you have surely been struggling with any spreadsheet app to do it easily.
He has proposed a recipe to do it, using Python pandas and pivot_table function.
In my recipe I will use pandas unstack. It “pivot a level of the (necessarily hierarchical) index labels, returning a DataFrame having a new level of column labels whose inner-most level consists of the pivoted index labels”.
The goal of Enrico is to change the original table as the image below:
The code to do all is the one below:
from pandas import *
And yon can see all in action in the below gist.
It’s only a reshape matter!