Pandas DataFrame truncate() Method

Example

Remove the rows before position 3 and after position 5 of the DataFrame:

import pandas as pd

data = {
"age": [50, 40, 30, 40, 20, 10, 30],
"qualified": [True, False, False, False, False, True, True]
}
df = pd.DataFrame(data)

newdf = df.truncate(before=3, after=5)

print(newdf)

Try it Yourself »

Definition and Usage

The truncate() method removes elements before and after the specified indexes or labels.

Use the axis='columns' parameter to remove specified columns.

Syntax

dataframe.truncate(before, after, axis, copy)

Parameters

The index, columns, axis, copy, inplace parameters are keyword arguments.

Parameter	Value	Description
before	Number Label Date	Optional. Remove everything before this value
after	Number Label Date	Optional. Remove everything after this value
axis	`0 1 'index' 'columns'`	Optional, default 0. The axis to truncate
copy	`True False`	Optional, default True. Specifies whether to return a copy of the DataFrame or not

Return Value

A DataFrame with the result.

❮ DataFrame Reference