I wrote a tool for our fantasy football league that checks the rosters twice a week and sends out emails if you having anyone starting a game who is injured, on a bye week, or just questionable. That, along with lots of effort from each coach, has made our league pretty good in terms of starting full rosters every week.
I started playing around more with the Yahoo API and realized that I could download stats for every game. Not just that, I could download stats for all nine seasons that we’ve had this league! Give a data scientist a fun data set like this and see what happens. None of the stuff I did is very complicated in terms of real “data science”, but it sure was fun!
First of all, I have some corrections to make to the table of records. One of these is due to a stat correction from Yahoo and the other is because Yahoo’s online interface didn’t let me go back far enough to see the old record. Here is the updated table with changes in bold. It turns out that Tim didn’t break the record for highest score in a game or the highest player score in a game.
|
This Week |
Season |
All-Time |
Highest Team Score |
Ben had 151.18 |
Tim 200.51 (Week 3) |
Tim had 206.94 in 2008 |
Lowest Team Score |
Andy had 75.31 |
Andy had 41.29 (Week 14) |
Andy had 41.29 (2015) |
Biggest Blowout |
Luke beat Andy by 42.02 |
Ben beat Dad by 111.43 (Week 8) |
Luke beat Andy by 113.02 (2010) |
Closest Win |
Austin beat Logan by 16.44 |
Ben beat Andy by 2.46 (Week 7) |
Jim beat Ben by 0.12 (2012) |
Highest Scoring Player |
Kirk Cousins had 40.20 as a free agent. |
Drew Brees had 58.30 on Tim’s bench (Week 8) |
Peyton Manning had 60.28 for Andy (2013) |
Longest Active Winning Streak |
Austin has a 4 game winning streak. |
Ben had an 8 game winning streak (Week 8) |
Micah (2011) and Ben (2015) had an 8 game winning streak |
Longest Active Losing Streak |
Jim has a 4 game losing streak. |
Andy had a 8 game losing streak (Week 14) |
Kyle had a 14 game losing streak (2011) |
Ok, but that’s pretty boring. What else can we answer? How about who had the most points on their bench? Instead of just counting the total, let’s look at the percentage of the total team’s points that sat on the bench. This stat is mostly just a curiosity. You could have a lot of points on the bench because you started the wrong people or because your team was really strong.
Tim Scherschel |
36.0% |
Dallon Martens |
32.4% |
Ben Martens |
32.3% |
Logan Brandt |
32.1% |
League Total |
31.7% |
Luke |
31.2% |
Jim |
30.9% |
Austin |
30.0% |
Andy Daniels |
27.6% |
Which positions produce the most average points in a game?
QB |
22.3 |
WR |
13.2 |
RB |
11.4 |
DEF |
10.7 |
TE |
10.1 |
K |
8.3 |
I broke the all time record for most points in a season. But how does it compare to everyone else over the past seasons?
How does the average number of points per team vary by year? Does it all average out or is there more scoring in some years?
Which players have generated the most points since 2007 in our league?
Drew Brees |
3089.66 |
Tom Brady |
2940.34 |
Aaron Rodgers |
2825.2 |
Peyton Manning |
2602.78 |
Philip Rivers |
2300.68 |
Tony Romo |
2106.5 |
Ben Roethlisberger |
2061.72 |
Adrian Peterson |
2026.62 |
Eli Manning |
1969.96 |
Matt Ryan |
1900.98 |
Who were the top 3 players at each position in our league this year?
Tom Brady |
Ben Martens |
QB |
410.94 |
Russell Wilson |
Luke |
QB |
377.18 |
Cam Newton |
Austin |
QB |
376.46 |
Antonio Brown |
Austin |
WR |
296.93 |
Julio Jones |
Logan Brandt |
WR |
287.70 |
Odell Beckham Jr. |
Ben Martens |
WR |
264.00 |
Adrian Peterson |
Jim |
RB |
232.40 |
Devonta Freeman |
Ben Martens |
RB |
205.60 |
Doug Martin |
Dallon Martens |
RB |
201.50 |
Rob Gronkowski |
Austin |
TE |
216.94 |
Greg Olsen |
Tim Scherschel |
TE |
186.30 |
Tyler Eifert |
Logan Brandt |
TE |
152.40 |
Stephen Gostkowski |
Dallon Martens |
K |
167.00 |
Steven Hauschka |
Tim Scherschel |
K |
127.00 |
Mason Crosby |
Logan Brandt |
K |
116.00 |
Arizona |
Dallon Martens |
DEF |
200.86 |
Denver |
Ben Martens |
DEF |
196.94 |
Seattle |
Tim Scherschel |
DEF |
180.70 |
Who has had the easiest schedule for the history of our league?
Tim. Dad has had the hardest schedule. But really, they are all very similar. Nobody deviated more than 2% from the mean.
Who had the most close wins in the last four years? This is a count of the number of times that each person won by less than 10 points.
Jim |
8 |
Andy Daniels |
8 |
Logan Brandt |
7 |
Tim Scherschel |
7 |
Dallon Martens |
7 |
Austin |
5 |
Ben Martens |
5 |
Luke |
5 |
There are so many more questions on my list to answer, but frankly I’ve been spending a lot of late nights digging through this. Hopefully if I get this post out, I’ll stop for a while and go to sleep!
If you’re interested in this dataset, let me know. I can either ship it to you in Excel or I can give you access to the SQL database and you can run your own queries. I hope to keep it running next year as the season progresses. I think I’ll also be able to use it to generate the Weekly Awards table each week which will make my blog posts easier.
Thanks to everyone for a great season! Go Seahawks!
The Future Of TV
This one is easy. The future of TV is no TV. Or rather, the TV is a display device for content that doesn’t come from traditional sources like NBC or HBO. Don’t believe me? Go into your local high school and take a poll about what kids are watching. There you will learn that most of them are watching more YouTube than anything else.
Next, fire up this video. It’s a highlight of the top YouTube stars from 2015. Recognize any of them? If you’re over 20, congratulations if you get more than one or two.
Put those two things together and you can see that the kids growing up today don’t care about the sitcoms or reality shows on TV. They don’t care about traditional television studios and actors. They are gobbling up content from YouTube stars.
At 35, I’m an old fart in this discussion and my opinion is hardly relevant, but I’ll tell you how my viewing habits have changed. I used to consume a LOT of TV. My scheduled recording list was 40-50 shows long (granted not all of them were actively producing episodes at the same time.) Now it’s down to about half a dozen. On the other side, my YouTube subscription count has gone from 2 or 3 to 39. I love YouTube content because there is a video for every niche. For a while I was watching a bunch of RC plane channels and now I’m watching a lot of woodworking channels. The people in these videos are more “reality” than any reality show on TV. I’ve interacted on social media and even snail mail with a bunch of them. It’s way more engaging than drooling on a couch chuckling at a joke written to appease the lowest common denominator.
So no, TV isn’t dead today or even in five years. If I knew how old-fashioned television studios were going to survive this, I’d probably be a wealthy man. But just keep this in mind the next time you hear about some kid watching YouTube. It’s not just a bunch of people getting kicked in the balls anymore. There are billions of hours of legitimate content out there and all those eyeballs are creating some impressive business opportunities.