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

12 votes211 views1 answer
Append a line to a text file python
Python
0 vote203 views1 answer
Latex maths to python parser
Python
0 vote209 views1 answer
How to test that an exception was raise using pytest
Python
2 votes198 views1 answer
Sqlalchemy query bilter by current month
Python
1 vote200 views3 answers
Solve linear system python
Python
0 vote189 views1 answer
Batch a list python
Python
0 vote255 views1 answer
Setting python2 in the path for npm install
Python
1 vote226 views1 answer
How to add string to all values of column in pandas
Python
27 votes197 views3 answers
Splitting a string and appending each character to a list python
Python
1 vote200 views1 answer
Get_or_create in django
Python