Groupby in Pandas

 Volume_Agent = union.groupby(['YM','AgentID','Channel Name','Invoice Type','Province',

                               'SR_Territory','SR_Name'

                              ,'Brand_y','Brand Segment','Brand Variants'

                              ,'Pack Type','CH'], as_index=False)[['Total HL','Quantity']].sum()

Comments

Post a Comment

Most searched

WHERE or IF function in Numpy

Script union['CH'] = np.where(union['Invoice Type'] == 'Normal Sales', union['Channel Name'],'Wedding & Function') Explanation IF "Invoice Type" = "Normal Sales" then union['CH'] = union['Channel Name'] Else union['CH'] = "Wedding & Function"
Read more