Python Dataframe Filtering with Conditions

Question

My input dataframe;

Stock  PO      Order_test  Order
50     50      10          0
50     20      10          7
10     5       3           3
100    80      5           4

I want to filter the with this code;

a= df[(df['Stock'] - df['PO'])>(df['Order_Test']) & (df['Order_Test'])>(df['Order'])]

But i got this;

ValueError: The truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all().

Desired output is;

   Stock  PO      Order_test  Order
   50     20      10          7
   100    80      5           4

Could you please help me about this?

jezrael · Accepted Answer · 2019-10-24 13:03:29Z

1

You are close, only remove some () for enclose both conditions:

df = df[(df['Stock'] - df['PO']>df['Order_test']) & (df['Order_test']>df['Order'])]
        ^                                       ^   ^                            ^
      start                                    end start                        end   

print (df)
   Stock  PO  Order_test  Order
1     50  20          10      7
3    100  80           5      4

answered Oct 24, 2019 at 13:03

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Collectives™ on Stack Overflow

Python Dataframe Filtering with Conditions

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