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 vote221 views1 answer
Change between two python 3 version in raspberrry pi
Python
3 votes218 views1 answer
Pandas loc for list
Python
0 vote227 views1 answer
Ladnha;
Python
0 vote226 views1 answer
Visitor IP address django
Python
-1 vote223 views1 answer
Randoomforest sklearn
Python
1 vote282 views1 answer
Import numpy illegal instruction (core dumped) jetson nano
Python
0 vote226 views1 answer
Python post np.array object
Python
0 vote239 views1 answer
Django retrieveupdatedestroyapiview
Python Django
0 vote236 views3 answers
Split credit card number python
Python
0 vote235 views1 answer
Popup flutter
Python