Category: Tutorials
Joins and merges in plain English
Learn how pandas merges map to SQL joins, when row counts explode, and how to check keys with validate and indicator. A customers-and-orders walkthrough keeps grain honest before…
Models chooser: Haiku, Sonnet, Opus, and Fable (no hype)
Part 5 of the Claude product map: pick Haiku, Sonnet, Opus, or Fable without FOMO. Start on the default, upgrade only when a clear prompt still fails, and…
API and builders’ tools (light)
Part 4 closes the ChatGPT product map: ChatGPT Plus or Pro is not free unlimited API. Open platform.openai.com only if you build software that calls models. Most AMS…
Claude Design and Claude Science (where they fit)
Claude Design handles visual work (decks, mockups, prototypes, brand systems, exports). Claude Science is a research workbench with tools, compute, and auditable artifacts, not peer review. Part 4…
Aggregations and groupby
Learn pandas groupby as split-apply-combine, the same idea as SQL GROUP BY. Build sum, mean, count, and multi-metric aggregations, with a clear sales-by-region before and after table example.
