筛选出每行缺失值个数大于特定值的行并删除方法

>>> import pandas as pd
>>> df = pd.DataFrame({'age':[10,20,None],'height':[None,180,None],'weight':[50,100,None]})
>>> df
    age  height  weight
0  10.0     NaN    50.0
1  20.0   180.0   100.0
2   NaN     NaN     NaN
>>> df.isnull().sum(axis=1)
0    1
1    0
2    3
dtype: int64
>>> s = df.isnull().sum(axis=1)
>>> s[s==3]
2    3
dtype: int64
>>> df.drop(index=s[s==3].index)
    age  height  weight
0  10.0     NaN    50.0
1  20.0   180.0   100.0

 

返回每行缺失值的总数

df.isnull().sum(axis=1)

返回每列缺失值的总数

df.isnull().sum(axis=0)