If you’re an avid Reddit user and football fan, you’ve probably come across the live game threads in r/nfl. This is a place where Redditors can post comments during the game and they can choose whether to represent their team using team logo flairs.
Here are the two threads for the Denver vs. Pittsburgh game that combined for over 25,000 comments from Redditors of all 32 NFL fanbases (and some users that choose not to represent any team).
We thought it would be fun to scrape the threads during the game for comments that included a few choice 4-letter words and display that information in real-time by fanbase. Here’s what the final product looked like: Click here to view the Shiny Dashboard
Here’s how we did it:
There were approximately 1,870 comments that included a few choice words and these were dominated by Broncos, Steelers and Patriots fans. If you’d like to play around with the raw comments data you can access the file here.
What other live stats would you like to see updated during the Super Bowl? Tweet at us and maybe we will build it!
Tweet to @sportsdataviz
For more information on building real-time interactive dashboards, please visit TCB Analytics and send us a message.