Numerical Computing with Python

How it works...

The stack method is powerful and it takes time to understand and appreciate fully. It takes all the column names and transposes them, so they become the new innermost index level. Notice how each old column name still labels its original value by being paired with each state. There were nine original values in a 3 x 3 DataFrame, which got transformed into a single Series with the same number of values. The original first row of data became the first three values in the resulting Series.

After resetting the index in step 2, pandas defaults our DataFrame columns to level_0, level_1, and 0. This is because the Series calling this method has two index levels that were formally unnamed. Pandas also refers to indexes by integer ...