Pandas DataFrame stack() Method
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 |
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.
