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 vote310 views1 answer
Print convert hex as string ascii
Python
1 vote344 views1 answer
TypeError: ‘builtin_function_or_method’ object is not subscriptable
Python
0 vote416 views1 answer
Sort values within groups pandas dataframe
Python
-1 vote312 views1 answer
What does filename = path(file).stem python
Python
8 votes330 views2 answers
How to check if a word is in a dictionary
Python
0 vote472 views1 answer
ImportError: cannot import name 'MigrateCommand' from 'flask_migrate'
Python Flask
1 vote297 views1 answer
Python script to sort file content
Python
2 votes321 views1 answer
Flask make static directory
Python
-1 vote321 views2 answers
Information of environment variables in python
Python
0 vote310 views1 answer
Renpy quickstart
Python