正文
pandas filter数据筛选
小程序:扫一扫查出行
【扫一扫了解最新限行尾号】
复制小程序
【扫一扫了解最新限行尾号】
复制小程序
https://study.163.com/course/courseMain.htm?courseId=1006383008&share=2&shareId=400000000398149(博主录制)
https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.filter.html(官网介绍)
DataFrame.
filter
(self, items=None, like=None, regex=None, axis=None)[source]
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 | like : string | regex : string (regular expression) | axis : int or string axis name | |
---|
python脚本
# -*- coding: utf-8 -*-
"""
Created on Sun Sep 8 11:32:40 2019@author: QQ231469242
"""
import pandas as pd
import 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 expression
df.filter(regex='e$', axis=1)# select rows containing 'bbi'
df.filter(like='bbi', axis=0)
https://study.163.com/provider/400000000398149/index.htm?share=2&shareId=400000000398149(博主视频教学主页)