show which columns in dataframe have NA 1

show which columns in dataframe have NA

In [71]: df
Out[71]:
     a    b  c
0  NaN  7.0  0
1  0.0  NaN  4
2  2.0  NaN  4
3  1.0  7.0  0
4  1.0  3.0  9
5  7.0  4.0  9
6  2.0  6.0  9
7  9.0  6.0  4
8  3.0  0.0  9
9  9.0  0.0  1

In [72]: df.isna().any()
Out[72]:
a     True
b     True
c    False
dtype: bool

Here is what the above code is Doing:
1. df.isna() returns a dataframe of booleans, where True indicates a missing value.
2. .any() returns True if any value is True. Since we have an entire dataframe of booleans, this gives us a series of booleans indicating whether any value in each column is True.

Similar Posts