这篇博客介绍了如何在Pandas DataFrame中快速找出所有列都包含NaN值的行。通过使用`df.isnull().all(1)`，可以获取一个布尔系列，其中True表示该行所有列都是NaN。然后，利用这个布尔系列作为索引，可以提取出满足条件的行。代码示例中展示了如何创建一个含有随机NaN值的数据框，以及如何找到并显示所有列都为NaN的行。
So I have a dataframe with 5 columns. I would like to pull the indices where all of the columns are NaN. I was using this code:
nan = pd.isnull(df.all)
but that is just returning false because it is logically saying no not all values in the dataframe are null. There are thousands of entries so I would prefer to not have to loop through and check each entry. Thanks!
解决方案
It should just be:
df.isnull().all(1)
The index can be accessed like:
df.index[df.isnull().all(1)]
Demonstration
np.random.seed([3,1415])
df = pd.DataFrame(np.random.choice((1, np.nan), (10, 2)))
df
idx = df.index[df.isnull().all(1)]
nans = df.ix[idx]
nans
Timing
code
np.random.seed([3,1415])
df = pd.DataFrame(np.random.choice((1, np.nan), (10000, 5)))
1276
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
