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

110 votes201 views6 answers
Python while
Python
5 votes226 views2 answers
Python Text Recognition
Python
1 vote181 views1 answer
Delete and start fresh with db django
Python
10 votes180 views2 answers
Select an element of a list by random
Python
0 vote209 views1 answer
How to incorportate a different language in python code
Python
28 votes217 views4 answers
Pygame scale image
Python
0 vote190 views1 answer
What is a rare earth
Python
0 vote215 views1 answer
How to create random tensor with tensorflow
Python
0 vote203 views1 answer
Pygame boilerplate
Python
0 vote186 views1 answer
@action(detail=true) meaning
Python