Checking for values in the dataframe

Question

I have dataframes in the form of:

            price       percentage
Date        
2021-10-11  298.075989  NaN
2021-10-18  308.570007  0.035206
2021-10-25  308.130005  -0.001426

I would like to check whether all the percentages (except NaN) are above 2 percent and then I would like to print a certain statement. How do I do that? Thanks in advance

Maybe something like print('All Above 2%' if df['percentage'].dropna().gt(0.02).all() else 'Not All Above 2%') — Henry Ecker
– Henry Ecker ♦, Commented Oct 25, 2021 at 22:02
did it answer your question? If so, please accept or comment otherwise — mnist
– mnist, Commented Nov 24, 2021 at 8:13

mnist · Accepted Answer · 2021-10-25 22:03:04Z

1

Your example seems a bit off, but does this satisfy your needs?

if all(df.percentage.dropna() > 2):
    print('All are above 2 percent!')

answered Oct 25, 2021 at 22:03

mnist

7,0242 gold badges20 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Checking for values in the dataframe

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related