What's the difference between query() and loc()? Do they evaluate to the same thing under the hood? Is one better than the other? In what cases?
These are questions that don't have obvious answers at first sight.
The problem is that there is no simple logically coherent API to use when you haven't memorized all the shortcuts. And the author only allows "tax form" APIs (what he calls "Pythobic/Pandonic" where every parameter is a single atomic step, so it's laborious to express things like tree-structured queries that are more complex than parameter dictionaries.