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

18 votes197 views3 answers
Change specific column name pandas
Python
4 votes172 views1 answer
Python comma separated string to list
Python
0 vote202 views1 answer
Panda Python - Calculating what percentage of values are true and false out of total in boolean column
Python
0 vote248 views1 answer
Create fixtures django
Python
0 vote197 views1 answer
Find rows in dataframe from another dataframe python
Python
0 vote217 views1 answer
Herencia python
Python
0 vote225 views1 answer
Affinity propagation python
Python
2 votes197 views1 answer
Get all occurrence indices in list python
Python
1 vote205 views1 answer
Discord python bot require one of two roles for command
Python
7 votes234 views3 answers
How to exit venv in python
Python