Pandas DataFrame filter() Method

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