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 vote277 views3 answers
Python multiplication table while loop
Python
1 vote272 views1 answer
How to print list without for loop python
Python
2 votes298 views2 answers
Print the number of times that the substring occurs in the given string
Python
5 votes298 views1 answer
How to round to 2 decimals with Python?
Python
0 vote327 views1 answer
Huggingface transformers change download path
Python
0 vote270 views1 answer
Django filter queryset by date
Python
80 votes300 views4 answers
Python append to file
Python
1 vote286 views1 answer
How to Convert Strings to Datetime in Pandas DataFrame
Python
0 vote287 views1 answer
Librosa from array to audio
Python
1 vote282 views2 answers
Datetime to epoch
Python