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 |
Optional, default 'column'. The axis to filter on |
Return Value
A DataFrame with the filtered result.
This method does not change the original DataFrame.
