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

6 votes182 views4 answers
Python commenting
Python
4 votes202 views2 answers
Python get index of substring in liast
Python
0 vote322 views1 answer
Real hour in python
Python
-1 vote213 views3 answers
Open csv from url python
Python
0 vote230 views1 answer
Spooling in os
Python
0 vote185 views1 answer
Abrir notebooks jupyter administrador de archivos
Python
0 vote196 views1 answer
Newick string python
Python
0 vote215 views2 answers
Mechanize python #6
Python
0 vote210 views1 answer
How to change speed in ursina
Python
0 vote202 views3 answers
How to use css in php example
Python