python argument on value

Question

I have a results_table as below:

               sum_sq         df           F            PR(>F)
    ABC         4.13          4.0        337.2           2.53
    Residual    4.45         110.0       NaN             NaN

What I am trying to do to print out 'test positive' only if PR(>F) is greater than 1. I tried the below:

if results_table.loc[[1],'PR(>F)'] > 1:
    print('test positive')

But I get the below error:

KeyError: "None of [Int64Index([1], dtype='int64')] are in the [index]"

Could someone please help me with how to do this?

Timus · Accepted Answer · 2022-04-23 13:55:15Z

1

If you are actually trying to access a single value then this

if results_table.loc['ABC', 'PR(>F)'] > 1:
    print('test positive')

or better this (.at[] is optimised for this kind of access)

if results_table.at['ABC', 'PR(>F)'] > 1:
    print('test positive')

should work.

The brackets here .loc[[1], 'PR(>F)'] or here .loc[['ABC'], 'PR(>F)'] make the result a series.

edited Apr 23, 2022 at 13:55

answered Apr 23, 2022 at 13:00

Timus

11.4k5 gold badges20 silver badges33 bronze badges

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

Comments

Akash garg · Accepted Answer · 2022-04-23 06:35:24Z

0

With loc use should row/col names

if results_table.loc[['ABC'],'PR(>F)'] > 1:
    print('test positive')

answered Apr 23, 2022 at 6:35

Akash garg

1356 bronze badges

1 Comment

user18334254 Over a year ago

this gives me the below error: ValueError: The truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all().

Collectives™ on Stack Overflow

python argument on value

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related