Numerical Computing with Python

There's more...

The function wide_to_long works when all groupings of variables have the same numeric ending as they did in this recipe. When your variables do not have the same ending or don't end in a digit, you can still use wide_to_long to do simultaneous column stacking. For instance, let's take a look at the following dataset:

>>> df = pd.read_csv('data/stackme.csv')>>> df

Let's say we wanted columns a1 and b1 stacked together, as well as columns d and e. Additionally, we wanted to use a1 and b1 as labels for the rows. To accomplish this task, we would need to rename the columns so that they ended in the label we desired:

>>> df2 = df.rename(columns ...