Pandas DataFrame: filter() function

DataFrame - filter() function

The filter() function is used to subset rows or columns of dataframe according to labels in the specified index.

Note that this routine does not filter a dataframe on its contents. The filter is applied to the labels of the index.


DataFrame.filter(self, items=None, like=None, regex=None, axis=None)


Name Description Type/Default Value Required / Optional

Keep labels from axis which are in items.

list-like Required
like  Keep labels from axis for which “like in label == True”. string Required
regex  Keep labels from axis for which re.search(regex, label) == True. string (regular expression) Required
axis  The axis to filter on. By default this is the info axis, ‘index’ for Series, ‘columns’ for DataFrame. int or string axis name Required

Returns: same type as input object


Download the Pandas DataFrame Notebooks from here.

Previous: DataFrame - equals() function
Next: DataFrame - first() function

Follow us on Facebook and Twitter for latest update.