且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何计算pandas DataFrame中列中的NaN值

更新时间:2022-12-10 09:15:09

您可以使用 isna() 方法(或者它的别名 isnull(),它也与较旧的 Pandas 版本

You can use the isna() method (or it's alias isnull() which is also compatible with older pandas versions < 0.21.0) and then sum to count the NaN values. For one column:

In [1]: s = pd.Series([1,2,3, np.nan, np.nan])

In [4]: s.isna().sum()   # or s.isnull().sum() for older pandas versions
Out[4]: 2

对于多列,它也有效:

In [5]: df = pd.DataFrame({'a':[1,2,np.nan], 'b':[np.nan,1,np.nan]})

In [6]: df.isna().sum()
Out[6]:
a    1
b    2
dtype: int64