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

26 votes276 views5 answers
Is_integer Python
Python
0 vote248 views2 answers
Python manual elif
Python
0 vote245 views3 answers
Pandas check if column type is list
Python
0 vote230 views1 answer
All classification algorithim compare
Python
0 vote271 views1 answer
Python function guts
Python
0 vote230 views1 answer
Pytest loop
Python
30 votes255 views6 answers
How to create a superuser in django
Python
0 vote321 views1 answer
Gevent with flask
Python Flask
0 vote271 views1 answer
Aiml python install
Python
0 vote219 views2 answers
Initialize boolean list of size python
Python