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

0 vote338 views1 answer
Python is not set from command line or npm configuration node-gyp
Python
0 vote317 views1 answer
Python turtle draw 3 concentric circles
Python
0 vote341 views1 answer
Cv2 assertion failed
Python
0 vote380 views1 answer
Autofield in django
Python Django
0 vote354 views1 answer
Python tabulate without index
Python
1 vote334 views1 answer
Passing Functions Around python
Python
76 votes326 views6 answers
Python main
Python
7 votes319 views2 answers
Make pandas df from np array
Python
9 votes350 views2 answers
Qrcode.make python
Python
7 votes329 views2 answers
Numpy create a matrix of certain value
Python