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

1 vote262 views1 answer
Python dividing strings by amount of letters
Python
3 votes218 views5 answers
Calc
Python
1 vote262 views2 answers
Django queryset exists
Python Django
0 vote259 views1 answer
Re_path(r'^logout/$',views.logout, {"next_page":'/'},name="logout"), AttributeError: module 'django.contrib.auth.views' has no attribute 'logout'
Python Django
0 vote232 views1 answer
Undef variable
Python
36 votes211 views2 answers
Python3 iterate through indexes
Python
0 vote246 views1 answer
Returns the cartesian product with another DataFrame
Python
3 votes251 views3 answers
Python json check if key exists
Python
0 vote216 views1 answer
Ta-lib python install
Python
3 votes217 views2 answers
How to create a label in python
Python