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

51 votes199 views6 answers
Print colored text python
Python
4 votes208 views1 answer
Re python3
Python
21 votes140 views9 answers
Dictionary comprehension python
Python
0 vote198 views1 answer
Python webdriver open with chrome extension
Python
7 votes233 views1 answer
Python if else short version
Python
21 votes195 views6 answers
Concatenate python
Python
0 vote212 views1 answer
Read list stored as a string with pandas read csv
Python
0 vote187 views1 answer
Change heading treeview tkinter
Python
3 votes220 views1 answer
How set dely in python
Python
8 votes198 views1 answer
Convert pandas series from str to int
Python