https://keroseneheaterreview.blogspot.com/2024/08/groupby-with-sub-ranges-in-pandas.html