Tutorials References Exercises Videos Menu
Free Website Get Certified Upgrade

Pandas DataFrame filter() Method

❮ DataFrame Reference


Example

Return a DataFrame with only the "name" and "age" columns:

import pandas as pd

data = {
  "name": ["Sally", "Mary", "John"],
  "age": [50, 40, 30],
  "qualified": [True, False, False]
}
df = pd.DataFrame(data)

newdf = df.filter(items=["name", "age"])
Try it Yourself »

Definition and Usage

The filter() method filters the DataFrame, and returns only the rows or columns that are specified in the filter.


Syntax

dataframe.filter(items, like, regex, axis)

Parameters

The item like, regex, axis parameters are keyword arguments.

Parameter Value Description
items List Optional. A list of labels or indexes of the rows or columns to keep
like String Optional. A string that specifies what the indexes or column labels should contain.
regex Regular Expression Optional. A regular expression of what the indexes or column labels should contain.
axis 0
1
'index'
'column'
None
Optional, default 'column'. The axis to filter on

Return Value

A DataFrame with the filtered result.

This method does not change the original DataFrame.


❮ DataFrame Reference