（博主录制）

 

（官网介绍）

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

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.

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

python脚本

# -*- coding: utf-8 -*-"""Created on Sun Sep  8 11:32:40 2019@author: QQ231469242"""import pandas as pdimport numpy as npdf = pd.DataFrame(np.array(([1, 2, 3], [4, 5, 6])),                  index=['mouse', 'rabbit'],                  columns=['one', 'two', 'three'])df.filter(items=['one', 'three'])#select columns by regular expressiondf.filter(regex='e$', axis=1)# select rows containing 'bbi'df.filter(like='bbi', axis=0)

　　

 

（博主视频教学主页）