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

2 votes131 views1 answer
How to add headers in csv file using python
Python
0 vote128 views1 answer
Python quiet future warning
Python
0 vote135 views1 answer
K and M to int in pandas
Python
0 vote151 views1 answer
Subtract constant from list
Python
2 votes119 views1 answer
Python type of column
Python
1 vote168 views3 answers
Python venv flask
Python Flask
0 vote150 views2 answers
PHP echo multiple lines example
Python
0 vote139 views1 answer
<type 'file'> python3
Python
0 vote137 views2 answers
Pycryptodome rsa encrypt
Python
-1 vote125 views1 answer
Python convert b string to dict
Python