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 vote172 views1 answer
How to call the tkinter insert command from another class
Python
0 vote172 views1 answer
Travis ci .yml for python
Python
0 vote162 views1 answer
Python default function value
Python
139 votes179 views6 answers
Anaconda create new environment
Python
2 votes176 views2 answers
Add hours to date time in python
Python
32 votes288 views6 answers
Python Map function
Python
10 votes168 views4 answers
Opencv resize image
Python
1 vote153 views2 answers
Get index of element in numpy array python
Python
0 vote201 views1 answer
Python get last cell value
Python
0 vote164 views6 answers
C to python code converter
Python