The Real Table
Most Premier League broadcasts sort the league table by raw points. This is the same logical error as comparing wages across decades without adjusting for inflation. When Arsenal play on Saturday and Manchester City play on Monday, Arsenal sit "top" for 48 hours despite having an identical points-per-game record. A team that has played two more games than its rival appears to lead by six points when they are actually level.The Real Table is the analytics engine that fixes this. It's the toolkit behind a viral piece of football analysis on the 2025/26 Premier League title race — built from scratch, using only public data, fully documented and reproducible.What it does Sorts any league table by Points, PPG, or Schedule-Adjusted PPG (SAPPG) at any point in any season since 1993/94 Calculates the "Real Days at the Top" — how many days a team genuinely led on a games-adjusted basis, not the inflated nominal figure broadcasters cite Computes the historical Bottling Index across thirty Premier League seasons — the metric that ranks Arsenal 2013/14 as the biggest squander of the era Tracks April performance by manager across full tenures (the chart that proves Arteta's 40.7% April win rate vs Guardiola's 80%) Works for the top five European leagues — Premier League, La Liga, Serie A, Bundesliga, Ligue 1 — the data pipeline is league-agnostic Try the live dashboard for free here: https://real-table.onrender.com/Read the companion analysis article here: https://sargamw.medium.com/did-arsenal-bottle-it-50b31d4a3088?source=friends_link&sk=13c09d91b78d602c2d61b7b84a8cb7c8Who it's for Fantasy Premier League managers who want to find underlying form before their captain pick Tactical writers and analysts who need clean, reproducible data for blog posts Data science students building a portfolio in sports analytics Football podcasters who want to back claims with numbers, not vibes What you get The notebook (V1): Fully documented Jupyter notebook with every chart and metric from the article. Plug in any season, any league. Runs in Google Colab — no local setup needed. The dashboard (V2): A Streamlit web app that lets non-coders explore the same data with one click. Sort the live table by any metric, generate charts, export CSVs. Pricing V1 (notebook only): £10 / $13 V2 (notebook + Streamlit dashboard): £15 / $19 Buy V1 and you can upgrade to V2 for the difference, anytime. Lifetime access. All future updates included.Honest limitationsThis is V1.0 of a personal toolkit, not enterprise software. The dashboard is built on Streamlit, not a custom React frontend. The data pipeline depends on football-data.co.uk being available. SAPPG uses opponent ranking from the previous match snapshot — it's a fairness lens, not a predictive engine.If you want a polished consumer product with mobile apps and live notifications, this isn't it. If you want the actual analytical engine that produced a 4,000-word data piece on the title race, in a form you can run yourself and adapt to any league or any season, this is exactly that.FAQDo I need to know Python? For V1, yes — basic Python and Jupyter familiarity is enough. For V2, no — the Streamlit dashboard runs in your browser and requires no code.Does it work for La Liga / Serie A / Bundesliga / Ligue 1? Yes. Change one variable in the notebook to switch leagues. Data comes from the same source for all five.How often is data updated? The notebook pulls fresh data from football-data.co.uk each time you run it. Their CSVs are typically updated within 24-48 hours of each matchday.Can I republish charts I generate? Yes, for personal blog posts and social media. Please credit "The Real Table toolkit" with a link back. For commercial use (paid newsletters, books, broadcaster integrations), email me.Refund policy? 14-day refund, no questions asked. If you don't like the toolkit, just ask for a refund.
Get it → sargamw.gumroad.com