https://lowcostwallchargeripod.blogspot.com/2024/02/groupby-with-sub-ranges-in-pandas.html