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

[@TheAlwaysGoel]

You are the best bro love from india

[@ExcelMoments]

Thank you so much. I appreciate the love

[@IvanCortinas_ES]

Thank you for telling these details about lists, dictionaries... (this detailed explanation is greatly appreciated). Veryyyyy good video, Victor!

[@ExcelMoments]

Thanks, Ivan. I take it that you are familiar with Python data types from the way your comment was phrased

[@IvanCortinas_ES]

@@ExcelMoments I have little knowledge. There's something good about that, my learning curve is huge.

[@IvanCortinas_ES]

@@ExcelMoments It catches my attention in general...To solve the same problem, Excel uses a large formula and Python uses little code, so I deduce that it is a very powerful language.

[@KevinPGA]

Another great video! I struggle to learn complex formulas in Excel, so I probably won't add python to my toolkit just yet, but it's really fun to see what it can do. I also enjoyed your video accomplishing this in native Excel, and I would default to that first. Thank you as always for sharing your mastery of Excel!

[@ExcelMoments]

Absolutely, moving at your pace is important. When the time is right, you can transit gradually

[@markpodesta4605]

Thank you Victor. Python looks difficult so hopefully AI will help me.

[@ExcelMoments]

Hahahah, it only is before you master it. Once you master it, you will be fine

[@charlesmurtaugh3771]

Great video, as always. I’m only a casual Python user, so I didn’t even know about the lambda function - who knew that I would learn Python tricks as well as Excel from you! Looking in your crystal ball, do you think Excel will ever incorporate R code as well?

[@davidakomolafe3609]

Not the easiest 😂😅

[@ExcelMoments]

You beg to differ? 😁