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 vote156 views1 answer
Mathtext to regular python
Python
-1 vote185 views1 answer
Cannot import name 'SGD' from 'keras.optimizers'
Python
0 vote180 views3 answers
Python thread exception
Python
11 votes181 views3 answers
Python random choice int
Python
0 vote180 views1 answer
Django model make the field caseinsensitive
Python
-1 vote170 views3 answers
Download pdf file python
Python
0 vote247 views1 answer
Django populate database in view
Python Django
0 vote176 views1 answer
Brew install pip python3
Python
0 vote172 views1 answer
How to get location using python
Python
0 vote174 views1 answer
Get the value of qpushbutton pyqt5 with argument
Python