Add SVG diagrams of core pandas operations (merge/join, groupby, reshape) to pandas.md

[mmcky]

This is a nice reference point for when we review the pandas lecture

https://betterprogramming.pub/pandas-illustrated-the-definitive-visual-guide-to-pandas-c31fa921a43

It contains many useful visualisations of various pandas operations that make learning pandas really simple.

Our own datascience series has some of these features (but they are cumbersome to build, @sglyon and @blkboxeconomist are geniuses when it comes to writing raw svg animations 😄). The link includes a lot of really interesting visualisations of pandas operations.

Ideas:

1. see if there is a pandas visualisation app that builds these based on an operation?
2. use AI to build visualisations to show how they work in our lectures
3. Link to resources like this?

[jstac]

@mmcky Please make this issue a bit more specific, so we can action it.

I can't remember what we wanted to review. Just an update to make sure that we're using the most modern syntax? If so, perhaps Claude can do this quickly?

Or were you thinking of adding more content?

[mmcky]

thanks @jstac I have updated the top level comment box.

[mmcky]

This is a stale library for pandas visualisations

https://github.com/axil/pandas-illustrated

that may be a useful reference for a visualisation approach to pandas.

[jstac]

Thanks @mmcky , that does look useful (although there's a firewall on the article).

[mmcky]

Scoped 2026-08-04 (tracker-audit follow-up). The open-ended "find and/or build a tool" framing is retired; the deliverable is now:

Add 3–5 static SVG diagrams to pandas.md illustrating the core operations visually — merge/join (left/inner/outer), groupby–aggregate, and reshape (pivot/stack) — in the spirit of pandas-illustrated, but as committed assets under _static/lecture_specific/pandas/ with no runtime dependency.

Acceptance: diagrams render in the built lecture, are sourced as editable SVG, and each carries one short paragraph of connecting prose.