Python find cells with na

In [152]: import numpy as np
In [153]: import pandas as pd
# to return the row and column indices where the value in NaN
In [154]: np.where(pd.isnull(df))
Out[154]: (array([2, 5, 6, 6, 7, 7]), array([7, 7, 6, 7, 6, 7]))

In [155]: df.iloc[2,7]
Out[155]: nan

In [160]: [df.iloc[i,j] for i,j in zip(*np.where(pd.isnull(df)))]
Out[160]: [nan, nan, nan, nan, nan, nan]

Source: stackoverflow.com

Similar codes

75 votes287 views2 answers
Httpie on windows
Python
8 votes320 views4 answers
Check cuda version python
Python
78 votes292 views4 answers
Read json
Python
145 votes331 views5 answers
How to generate a random number python
Python
5 votes312 views1 answer
Trimming spaces in string python
Python
0 vote309 views2 answers
Selenium delete cookies python
Python
0 vote327 views1 answer
Query a PSQL Database From Python
Python
0 vote308 views1 answer
Exercise of python loops
Python
1 vote301 views1 answer
How to change the values of a column in numpy array
Python
57 votes293 views6 answers
Int to string python
Python