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 votes193 views1 answer
Python substitute multiple letters
Python
1 vote239 views2 answers
Tensor get value
Python
0 vote192 views1 answer
Open dicom images python
Python
2 votes191 views1 answer
Python USD to Euro Converter
Python
4 votes148 views1 answer
Declaring a numpy array with certain size
Python
17 votes182 views5 answers
ModuleNotFoundError: No module named 'tkinter'
Python
6 votes195 views2 answers
Flask form options
Python
5 votes242 views6 answers
Plt.xticks
Python
0 vote185 views1 answer
Isosceles triangle code in python
Python
1 vote188 views1 answer
Multipl excel sheets in pandas
Python