Pandas DataFrame stack() Method
ExampleGet your own Python Server
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.