Fantasy Football Stats GPT
TLDR: Here is a GPT for question answering about NFL data https://chat.openai.com/g/g-vxtiCaEDN-fantasy-football-stats-cruncher.
Simon Willison and the open source project datasette are building one of the coolest ways to share data. I have an instance deployed at https://nfl-datasette.altonji.com/ with weekly offensive NFL player data, which allows me to run SQL queries over fantasy football data.
This datasette instance is deployed daily via a github action.
Running SQL on Fantasy Football data is great, but what’s even more powerful is that datasette provides an API for querying your database. Following OpenAI’s release of “GPTS”, Simon Willison posted about how to build a GPT which talks to a datasette instance.
Directly copying Simon’s work, I built a GPT which talks to NFL data: https://chat.openai.com/g/g-vxtiCaEDN-fantasy-football-stats-cruncher.
This thing feels like the perfect tool for generating those ridiculous sideline statistics you here in games. “Mahomes just passed the alltime record for completed passes to a TE in the second quarter of a regular season game!”
Thoughts on GPTs
This is not the thing. I’m psyched to be able to quickly build and release this project but it has tons of faults:
- I am required to deploy this with GPT4 even though that model is overpowered for my use case. I’m hitting my own usage limits just trying to test the damn thing and it’s slow to generate answers.
- It can’t just display raw data responses from the API. It needs to pass it through the generation step. This slows everything down.
- It doesn’t work for everyone on every device. You need a pro license and it doesn’t work on mobile.
I don’t yet find myself going to this tool instead of Yahoo’s Fantasy Football players research tab. Until I do, I think I know this tool is not yet THE tool.
All code and prompts here: https://github.com/caltonji/nfl-datasette
