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 vote154 views1 answer
Create new dataframe from columns pandas
Python
0 vote157 views1 answer
Install open3d jetson nano aarch64
Python
0 vote151 views1 answer
Def areEquallyStrong(yourLeft, yourRight, friendsLeft, friendsRight):python execution
Python
4 votes204 views4 answers
Filter django or
Python Django
1 vote177 views2 answers
Openfiledialog python
Python
0 vote173 views1 answer
Mouse module python
Python
-1 vote140 views1 answer
Python : search file for string
Python
-1 vote147 views2 answers
Information of environment variables in python
Python
0 vote177 views1 answer
Find pdf encrypted password with python
Python
0 vote148 views1 answer
Randomforestregressor in sklearn
Python