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 vote139 views1 answer
Python playsound stop
Python
5 votes152 views3 answers
Correlation matrix python
Python
25 votes150 views5 answers
Create an env in python
Python
81 votes153 views4 answers
Python wait for x seconds
Python
1 vote138 views1 answer
Run 2 loops simultaneously python
Python
0 vote138 views1 answer
Django queryset to instance
Python
0 vote138 views1 answer
Heroku run python manage.py migrate
Python
0 vote144 views1 answer
Pyqt5 open tab
Python
0 vote143 views1 answer
Get most recurring element in a list python
Python
-1 vote168 views1 answer
Python serial port
Python