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

11 votes156 views2 answers
Find character in python
Python
1 vote160 views1 answer
Install serial python
Python
0 vote145 views1 answer
Iterate over meta tag python
Python
0 vote208 views1 answer
Flask put request example
Python Flask
2 votes193 views1 answer
No module named social_django
Python Django
14 votes203 views1 answer
Pandas cheat sheet pdf
Python
-2 votes159 views2 answers
Python list ascii
Python
2 votes216 views1 answer
Flask session timeout
Python Flask
0 vote165 views1 answer
Python observer pattern
Python
0 vote154 views1 answer
Cvhaardetectobjects
Python