PyData London - 106th Meetup

Venue: Riverbank House, 2 Swan Ln, London EC4R 3AD
Please note:
1. 🚨🚨🚨 A valid photo ID is required by building security. 🚨🚨🚨
2. This event follows the NumFOCUS Code of Conduct. Please familiarise yourself with it before attending.

If your RSVP status says "You're going" you will be able to get in. No need to show your RSVP confirmation when signing in.
If you can no longer make it, please unRSVP as soon as possible.

Code of Conduct:
This event follows the NumFOCUS Code of Conduct. Please get in touch with the organisers with any questions or concerns.

As always, there will be free food and drinks, generously provided by our host, Man Group.

Main Talks

1. Nicoleta Lazar Query federation in modern OLAP databases
   As analytics ecosystems grow more diverse, organisations increasingly need to query data across warehouses, data lakes, and operational systems without excessive data movement or duplication. Query federation has become essential by enabling unified SQL access and intelligent predicate pushdown into heterogeneous sources. This talk introduces the core principles of federation and why it matters for modern OLAP workloads. Using StarRocks as a model system, we highlight its vectorised execution engine, native connectors, and deep Apache Iceberg integration that together deliver high-performance lakehouse querying.
2. Ben Guerin How I Learned to Stop Worrying and Let Claude Code Write the Python [the story of ismypubfucked.com]
   43,000 pubs. Official VOA data. One question. ismypubfucked.com got 400k visits in two weeks and wall-to-wall media coverage: from the Mirror to the Telegraph to City AM.
   I'm not a Python developer. I used Claude Code to wrangle government spreadsheets, match them to OpenStreetMap, and ship a working site. All in less than 6 hours from initial idea to a live website. The AI wrote the Python, I just knew what story the data could tell.
   This talk covers what happens when tools like Claude Code unlock Python for people who think in narratives rather than syntax, and what a decade of building viral campaigns has taught me about making people actually give a shit about spreadsheets.

Lightning Talks

1. TBC
2. TBC
   --------------------------------
   Logistics
   Doors open at 6.30 pm (get there early as you'll need to sign in with building security).
   Talks start at 7:00 pm, with drinks afterwards from 9:00 pm at The Banker (EC4).

We have reduced capacity for this event, but there will be plenty of people to discuss data science questions with.
Please unRSVP in good time if you realise you can't make it. We're limited by building security on the number of attendees, so please free up your place for your fellow community members.
If you want me to trim lightning talks down to two or shorten any abstracts, say which ones.