So this thing is 3500 pages. Either pandas is overly complex and over engineered or it's a meticulously planned library that thoughtfully provides tools and use case coverage for most data analysis jobs.
Spoiler alert: it's the former.
Spoiler alert: it's the former.
Does some stuff get complicated? Sure. Sometimes there are edge cases that get messy. The other day I was surprised to see my categorical labels implicitly converted to strings if they were used in a multi-level index. But for me, at least, that’s a fairly esoteric use-case. It stands out to me now precisely because pandas so rarely does something I didn’t expect.