DWOPT - Datawarehouse Operator
Getting summary stats out of databases can often be unstreamlined. 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.