This Excel challenge uses a Groupby concept to Group by a parameter and subtotal by another. This python in Excel solution uses the groupby and agg(aggregate) method
00:00 Introduction
00:21 Problem Description
01:00 Victor's thoughts on a solution
01:22 Starting the Python solution
02:31 Including the Year of the dates
03:15 Add a column for Half of the year
04:00 Using a LAMBDA to add the half of the year
05:40 Pandas Groupby
06:46 Using the Agg function for multiple aggregation
07:46 Removing multicolumn indexing
08:37 Final Thoughts
Link to Workbook:
docs.google.com/spreadsheets/...
Негізгі бет Excel Challenge: Python GroupBy and Aggregate
Пікірлер: 13