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

3 votes260 views2 answers
Add sheet to existing workbook openpyxl
Python
0 vote287 views1 answer
Remove a columns in pandas
Python
9 votes260 views2 answers
Run linux command using python
Python
1 vote251 views1 answer
Get csrf_token value in django template
Python
0 vote288 views1 answer
How to separate string in python by blank line
Python
0 vote276 views3 answers
Remove string from list in python
Python
1 vote262 views1 answer
Python how to copy a 2d array leaving out last column
Python
-1 vote281 views1 answer
Converting multipage tiff to pdf python
Python
0 vote253 views1 answer
How to send image to template thats not in static flask
Python
48 votes265 views6 answers
Python to exe
Python