Excel Challenge: Python GroupBy and Aggregate скачать в хорошем качестве

Excel Challenge: Python GroupBy and Aggregate

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: https://docs.google.com/spreadsheets/...