Numerical Computing with Python

How it works...

In step 1, we notice that there are five variables placed vertically in the Info column with their corresponding value in the Value column. Because we need to pivot each of these five variables as horizontal column names, it would seem that the pivot method would work. Unfortunately, pandas developers have yet to implement this special case when there is more than one non-pivoted column. We are forced to use a different method.

The unstack method also pivots vertical data, but only for data in the index. Step 3 begins this process by moving both the columns that will and will not be pivoted into the index with the set_index method. Once these columns are in the index, unstack can be put to work as done in step 3.

Notice that ...