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 vote269 views1 answer
Python get colorscale
Python
9 votes293 views4 answers
Python run server
Python
0 vote304 views2 answers
Concatenate the squares of numbers in python
Python
-1 vote296 views1 answer
Pandas numpy multiplicar dos columnas segun una condicion
Python
0 vote288 views1 answer
Python convert xml to dictionary
Python
7 votes277 views5 answers
Install discord python
Python
23 votes278 views1 answer
Python get minute from datetime
Python
0 vote341 views1 answer
Auth proxy python
Python
1 vote267 views1 answer
Run code with different verions of python
Python
0 vote295 views2 answers
Convert time series to transition matrix
Python