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 vote210 views1 answer
Python code variable declaration
Python
0 vote169 views1 answer
Python capitalize first letter of string without changing the rest
Python
0 vote185 views1 answer
Python launch ipython from script
Python
3 votes142 views2 answers
Python 3.7.9 download
Python
1 vote190 views1 answer
Squared sum of all elements in list python
Python
0 vote207 views1 answer
Django refresh form db
Python Django
0 vote164 views1 answer
Prints out the schema in the tree format
Python
5 votes172 views3 answers
Sys python
Python
0 vote161 views1 answer
Python find multiple matches in string
Python
0 vote154 views1 answer
Choice without replacement python
Python