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 vote268 views1 answer
How to find most repeated word in a string in python
Python
4 votes248 views3 answers
How to input n space separated integers in python
Python
0 vote283 views2 answers
Problems on loops and if else statements
Python
0 vote278 views1 answer
Return more than one value python
Python
0 vote261 views1 answer
Python tableau a 2 dimensions
Python
0 vote365 views3 answers
Pysftp get-r
Python
0 vote308 views1 answer
Wie printe ich in python
Python
0 vote270 views1 answer
Cannot import name 'counter' from 'collections'
Python
-2 votes280 views6 answers
List comprehension in python
Python
0 vote285 views1 answer
Discord command addrole python
Python