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 vote99 views1 answer
Extract first word from string in column into a list in python
Python
0 vote104 views1 answer
Redirect stdout to variable python
Python
19 votes108 views1 answer
Python left string
Python
-1 vote99 views1 answer
Histogram image processing python
Python
0 vote98 views1 answer
Python default function value
Python
9 votes116 views2 answers
Read video with opencv
Python
1 vote96 views1 answer
Classification report scikit
Python
68 votes113 views6 answers
Python clear console
Python
0 vote101 views1 answer
Find highest value in array python
Python
0 vote90 views2 answers
Install log21 python
Python