how to iterate over pandas dataframe over multiple column groupBy in python

Question

I have a dataset given below:

product_name    serial_number     date           sum
"A"             "12"              "2020-01-01"   150         
"B"             "10"              "2020-01-01"   250 
"A"             "12"              "2020-01-02"   350 
"B"             "10"              "2020-01-02"   450 
"A"             "12"              "2020-01-03"   1500 
"B"             "10"              "2020-01-03"   2050

I am trying to get subset of pandas dataframe with group of (product_name, serial_number). Here, I have two groups, is there any efficient ways to iterate over groups similar to pseudo code given below in Python:

for group_product_name, group_serial_number in data.groupBy():
    //get subset of data with group_product_name, group_serial_number

BENY · Accepted Answer · 2021-01-13 04:47:20Z

1

Try with

for x , y in df.groupby(['product_name','serial_number']):

     # y is the subset 
     # x is the group name

answered Jan 13, 2021 at 4:47

BENY

324k22 gold badges176 silver badges250 bronze badges

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

Collectives™ on Stack Overflow

how to iterate over pandas dataframe over multiple column groupBy in python

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