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

4 votes220 views2 answers
Number length python
Python
0 vote281 views2 answers
Fibbonachi python
Python
10 votes198 views3 answers
Matplotlib axis labels
Python
8 votes257 views1 answer
Creating dynamic variable in python
Python
1 vote207 views1 answer
How to say hello world
Python
16 votes195 views6 answers
Python print statement
Python
6 votes323 views3 answers
Pandas remove rows with null in column
Python
9 votes201 views3 answers
Python datetime get weekday name
Python
1 vote247 views1 answer
Np where nan
Python
2 votes193 views2 answers
Flask hello world get
Python Flask