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 vote286 views1 answer
Add metadata png PIL
Python
1 vote273 views2 answers
Phi
Python
0 vote268 views1 answer
Matplotlib display axis in scientific notation
Python
6 votes263 views1 answer
Python merge two list
Python
0 vote292 views2 answers
Python def example
Python
0 vote258 views1 answer
Python list pop equivalent
Python
0 vote284 views1 answer
Add title to relplot seaborn
Python
4 votes273 views1 answer
How to calculate rmse in linear regression python
Python
13 votes275 views1 answer
Change background color of tkinter
Python
0 vote269 views1 answer
Ecrire un code permettant de changer les valeurs de la colonne avec ces deux labels python.
Python