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

23 votes400 views3 answers
Install django rest_framework
Python Django
0 vote180 views1 answer
Relative text size put text cv2
Python
1 vote174 views1 answer
Use incognito mode in selenium
Python
1 vote215 views1 answer
Deleting all rows in pandas
Python
2 votes185 views1 answer
What does % do in python
Python
10 votes191 views3 answers
Python dataframe find no of true
Python
0 vote216 views1 answer
Sending email in django
Python Django
12 votes179 views2 answers
Is python object oriented language
Python
0 vote178 views1 answer
Download video to from pytube with a special name
Python
2 votes218 views2 answers
Wolfram alpha python
Python