selecting nan values in a pandas dataframe using loc

Asked Nov 23 '20 at 15:02

Active Nov 23 '20 at 15:02

Viewed 25 times

I'm using pandas and trying to select all the rows with a nan in it from a column. I've tried the following, but no joy, where am I going wrong?

aa.loc[((aa['_merge'] == 'right_only') & (aa['Context Interpretation'] == np.nan))]

aa.loc[((aa['_merge'] == 'right_only') & (aa['Context Interpretation'] == 'nan'))]

asked Nov 23 '20 at 15:02

Spatial Digger

1,883
1
19
37

4

`.isna()` or `.isnull()`? [how-to-filter-in-nan-pandas](https://stackoverflow.com/questions/25050141/how-to-filter-in-nan-pandas) – Michael Szczesny Nov 23 '20 at 15:09
Give answer `aa.loc[((aa['_merge'] == 'right_only') & (aa['Context Interpretation']).isnull())]` and I'll accept. – Spatial Digger Nov 23 '20 at 15:11
@SpatialDigger - much to likely to be closed. – Michael Szczesny Nov 23 '20 at 15:19

selecting nan values in a pandas dataframe using loc

0 Answers0