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

11 votes126 views3 answers
How to get the length of a string in python
Python
0 vote134 views1 answer
Pandas column filter
Python
37 votes115 views1 answer
Get current date datetime
Python
0 vote120 views1 answer
\u00a0
Python
2 votes126 views1 answer
Cos in python in degrees
Python
3 votes159 views2 answers
Remove duplicates function python
Python
0 vote129 views1 answer
Programe to find contagious sum of sequence
Python
0 vote115 views1 answer
Set up splinter
Python
1 vote132 views1 answer
Selenium api
Python
0 vote146 views2 answers
Logarithmic 2d histogram
Python