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 vote126 views1 answer
Pytho ntoday as string
Python
5 votes132 views2 answers
Convert response to json python
Python
0 vote123 views1 answer
Python computer guesses your number
Python
0 vote175 views1 answer
Hostname python
Python
11 votes134 views6 answers
Python list
Python
3 votes130 views2 answers
Python append row to 2d array
Python
1 vote115 views1 answer
Convert rgb to a single value
Python
0 vote132 views1 answer
No module named 'fastai'
Python
0 vote172 views1 answer
Statsmodels fitted values
Python
5 votes135 views4 answers
Python requests post
Python