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 vote334 views1 answer
How to specify port while running django project
Python
0 vote337 views1 answer
Pandas create a calculated column
Python
0 vote357 views1 answer
Django date grater
Python Django
2 votes355 views1 answer
Set index in datarame
Python
4 votes306 views1 answer
Falsy python
Python
0 vote320 views1 answer
Python readlines end of file
Python
4 votes319 views2 answers
Python code to open windows command prompt
Python
7 votes308 views2 answers
What is the django orm
Python
3 votes352 views2 answers
Venv upgrade python
Python
0 vote398 views1 answer
Set environment variable flask app
Python Flask