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 vote128 views1 answer
Get element tag name beautfulsoup
Python
0 vote134 views1 answer
Index in for loop
Python
1 vote155 views1 answer
Python get methods of object
Python
0 vote128 views1 answer
Limit of list in python
Python
3 votes134 views2 answers
How to fill a list in python
Python
4 votes167 views2 answers
Chrome driver download for selenium python
Python
1 vote143 views1 answer
Pandas has no attribute scatter_matrix
Python
7 votes143 views4 answers
Python tkinter button multiple commands
Python
0 vote166 views1 answer
Setting python2 in the path for npm install
Python
0 vote103 views1 answer
Replace hour , minute, seconds in timestamp pandas
Python