Tutorials References Exercises Sign Up Menu
Create Website Get Certified Pro

Pandas DataFrame filter() Method

❮ DataFrame Reference


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.


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


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
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