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 vote400 views1 answer
Backend not found Request Method: GET Request URL: http://127.0.0.1:8000/oauth/login/google-oauth2/ Raised by: social_django.views.au
Python Django
1 vote372 views1 answer
Slack send message python
Python
0 vote349 views1 answer
Python tar a directory
Python
3 votes356 views2 answers
Python initialize a 2d array
Python
0 vote361 views1 answer
Python redirect with button click
Python
0 vote390 views1 answer
Message handler python telegram bot example
Python
6 votes372 views1 answer
Select closest number in array python
Python
1 vote358 views1 answer
Plt normalized histogram
Python
0 vote337 views1 answer
Python elementtree load from string
Python
1 vote334 views2 answers
Java Array objects
Python