Tutorials References Exercises Videos Menu
Free Website Get Certified Upgrade

Pandas DataFrame truncate() Method

❮ DataFrame Reference


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