Python - Comparing multiple columns

Question

I am trying to deactivate certain products from inventory if all their sizes have zero stock, from a csv using pandas. Psuedo - group all the products by "desc" and if all "instock" equals zero then return true to "inactive"

I have tried using groupby function with pandas, but can't get my head around how it works.

Here is the csv, and me trying to explain what I mean ...

BENY · Accepted Answer · 2019-08-12 01:09:52Z

2

You can check with groupby transform

df['instack']=df['instack'].eq(0).groupby(df['desc']).transform('all')

answered Aug 12, 2019 at 1:09

BENY

324k22 gold badges176 silver badges250 bronze badges

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

2 Comments

user3170725 Over a year ago

What can I say, thankyou very much! Will have to lookup how that transform works, looks very handy. -e- Is there a way to put the transform output into the "inactive" column?

BENY Over a year ago

@user3170725 you can just assign it back like what i did

manwithfewneeds · Accepted Answer · 2019-08-12 03:12:18Z

1

df.loc[df.groupby('desc')['instock'].transform(sum).eq(0), 'inactive'] = 'T'

The groupby/transform returns a Boolean mask where the sum of the instock series per group equals zero. This get's wrapped in a dataframe loc statement to choose only those rows where the mask is True, and sets the inactive column to 'T'.

answered Aug 12, 2019 at 3:12

manwithfewneeds

1,1671 gold badge8 silver badges10 bronze badges

Collectives™ on Stack Overflow

Python - Comparing multiple columns

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related