Tutorials References Exercises Videos Menu
Free Website Get Certified Upgrade

Pandas DataFrame stack() Method

❮ DataFrame Reference


Stack the DataFrame from a table where each index had 4 columns, into a table where each index has their own level, with one row for each column:

In this example we use a .csv file called data.csv

import pandas as pd

df = pd.read_csv('data.csv')

newdf = df.stack()
Try it Yourself »

Definition and Usage

The stack() method reshapes the DataFrame into a table with a new inner-most level of rows for each column.


dataframe.stack(level, dropna)


The dropna parameter is a keyword argument.

Parameter Value Description
level   Required, a Number, String or List, specifying the levels to stack from the column- to the row-axis.
dropna True
Optional, default True. Specifies whether to drop NULL values or not.

Return Value

A reshaped DataFrame object.

This method does not change the original DataFrame.

❮ DataFrame Reference