[Basic] Easy and quick approach to develop complex pivot table reports using Python - Printable Version +- Python Forum (https://python-forum.io) +-- Forum: General (https://python-forum.io/forum-1.html) +--- Forum: Tutorials (https://python-forum.io/forum-4.html) +---- Forum: Tutorial Requests and Submissions (https://python-forum.io/forum-21.html) +---- Thread: [Basic] Easy and quick approach to develop complex pivot table reports using Python (/thread-4488.html) |
Easy and quick approach to develop complex pivot table reports using Python - sarakuma - Aug-20-2017 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. RE: Easy and quick approach to develop complex pivot table reports using Python - nilamo - Aug-21-2017 24 pages counts as "quick and easy"? |