What groupby() Actually Does in Memory (You Already Learned This Trick)

Databases have a classic trick for finding matching rows fast: build a hash table once, then look things up in it instead of scanning everything from scratch every time you need an answer. It's one of