Tutorials References Exercises Videos Menu
Create Website Get Certified Upgrade

Pandas DataFrame stack() Method

❮ DataFrame Reference


Example

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.


Syntax

dataframe.stack(level, dropna)

Parameters

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
False
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