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 vote236 views1 answer
Flask request file upload to dropbox
Python Flask
0 vote133 views1 answer
Create_user() missing 1 required positional argument: 'username'
Python
1 vote145 views1 answer
Py how to deactivate venv
Python
0 vote129 views1 answer
Equivalent of spread in R in python
Python
2 votes131 views3 answers
Convert series to datetime
Python
0 vote188 views1 answer
Iterate over classes in module python
Python
1 vote153 views1 answer
Merged all dictionaries in a list python
Python
7 votes161 views2 answers
Python cd to script directory
Python
1 vote130 views1 answer
Django datetimefield default
Python
0 vote138 views1 answer
Minio python make an object
Python