condition check in pandas dataframe - python

Asked Oct 10 '21 at 05:52

Active Oct 10 '21 at 05:52

Viewed 25 times

Below is my dataframe:

	date	open	high	low	close	volume	sma	sr
0	2021-07-29	22.5	22.5	22.5	22.5	5	NaN	1

Now I want to print the value of sma on if it's not NaN.

Code:

if (df.loc[df['sr'] == 1]['sma'].values[0] != 'NaN') or (df.loc[df['sr'] == 1]['sma'].values[0] != "nan"):
    print(df.loc[df['sr'] == 1]['sma'].values[0])

There should be no output, but it is printing nan

asked Oct 10 '21 at 05:52

selet

The `NaN` object is not the same as the `"nan"` string – mozway Oct 10 '21 at 05:56
Post the output of `df.to_dict()` in your question – The Singularity Oct 10 '21 at 05:56
you have an 'OR' in your if statement. So it will get into the loop. I don't think this is a good way to check. You are checking for a string. Are you sure you want to check for a string `NaN` ? – Joe Ferndz Oct 10 '21 at 05:56
`if df.loc[df['sr'] == 1]['sma'].notna().values[0]: ...` – mozway Oct 10 '21 at 05:58

condition check in pandas dataframe - python

0 Answers0