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

1 vote311 views1 answer
How to add an active class to current element in navbar in django
Python
15 votes325 views3 answers
Python list.pop()
Python
12 votes327 views5 answers
Python UUID
Python
1 vote350 views1 answer
[Solved] TypeError: can’t multiply sequence by non-int of type str
Python
-3 votes305 views2 answers
Mean
Python
0 vote348 views1 answer
Python chatbot speech recognition
Python
6 votes334 views2 answers
Sleep your computer python
Python
10 votes336 views5 answers
Opencv Webcam
Python
3 votes364 views5 answers
Swap in python
Python
13 votes322 views6 answers
Python if elif else
Python