No mention of H3! The hexagonal spatial index https://eng.uber.com/h3/ . This library has been a game changer for my work. Before I had to create hexagonal grids using shapely and then use spatial joins to aggregate the data. With H3 you can go from a point to a hex really quickly.
Here’s the python wrapper for the library- https://github.com/uber/h3-py