https://keroseneheaterreview.blogspot.com/2024/05/sql-to-pandas-aggregation-over.html