"- The most helpful way to figure out the proper Excel methods to use, is record a step-by-step Macro in Excel, while creating a pivot table in the form you want.\n", "- This code is most useful for ...

A pivot table with intermediate and final results both by rows and by columns is already in Python. Pivot tables are an undeniably cool thing for analyzing (summarizing, aggregating) multi-category ...