Jeffrey Tratner: Pandas Under The Hood: Peeking behind the scenes of a high performance data analys
Why Stack Overflow recommends it
Stack Overflow users link it when answering questions about why pandas behaves or performs the way it does, since it explains the BlockManager and other internals.
Recommended by 2 people across 2 different months, 2017 to 2023.
What it is
A PyData Seattle 2015 talk by Jeffrey Tratner on how pandas works internally. It covers the libraries pandas builds on, its core data structures (NDFrame, BlockManager, Index) and how they combine into the public API, with advice on using that knowledge to write better pandas code.
What people said
Recommends user2285236 · 2017-12 · Stack Overflow · on “Why are numpy functions so slow on pandas series / dataframes?”
Jeffrey Tratner [this video] 's talk is really good. Here [LINK] are slides. He starts talking about block manager in slide 35. Let me try to step into both versions to see if I can come up with a complete answer.
Recommends xicocaio · 2021-03 · Stack Overflow · on “loc method to update the values in an existing column consistency?”
I must admit I do not have enough knowledge of how it works under the hood if that is what you are asking for. Anyhow, this explanation [this video] could be a good starting point. The instants 14:55 and 32:04 might be the ones you are looking for.
Cites user19077881 · 2023-02 · Stack Overflow · on “Is it possible to form groups in a dataframe with rows having a value in a column in addition to grouping columns in Pandas?”
As for you second request, you might find this interesting link [this video] and this link [LINK] . I find the Wes McKinney book Python for Data Analysis is informative.