DWOPT - Datawarehouse Operator
Getting summary statistics out of database tables is often an unstreamlined process. Does one read in millions of rows before doing any work on Python, or run sql elsewhere and use intermediate CSVs, or write sql strings in python scripts?
The Python package dwopt provides Excel-pivot-table-like and dataframe-summary-methods-like API, driven by sql templates, under a flexible summary query building framework.
See the Features and the Walk Through section for examples.