Aug-20-2017, 11:08 PM
Objective
The objective of this paper is to delineate step by step approach that is easy and quick to develop complex pivot table like reports using Python. It also lists down the areas where Python scores over the limitations/constraints associated with manual creation of these reports in Microsoft excel. Pandas, Numpy, Openpyxl are the Python modules/packages (open source) considered in this approach
Target audience
• Any technology specialist who manually and frequently creates large # of reports that extensively uses pivot tables
• Any technology specialist interested to understand the nitty-gritties of the pivot table reporting features available in Python programming language.
Please find attached documentation for approach and assumptions.