|
Hockles posted:I've been told to ask in here how to make football stats parse easily for 1000 Yards or Bust. Can a magician make this happen for me? Making sure this doesn't get lost
|
# ? Sep 9, 2015 05:23 |
|
|
# ? May 25, 2024 14:00 |
|
Hockles posted:I've been told to ask in here how to make football stats parse easily for 1000 Yards or Bust. Can a magician make this happen for me? I could probably help you out with that. Could you be more specific about what you have and what you want? Forever_Peace fucked around with this message at 13:11 on Sep 9, 2015 |
# ? Sep 9, 2015 13:08 |
|
On the dvoa error rate, how much does their St ranking affect the overall? The bears have the worst prediction and I'm wondering if that's due to them often having a top expected st dvoa.
|
# ? Sep 9, 2015 13:14 |
|
mastershakeman posted:On the dvoa error rate, how much does their St ranking affect the overall? The bears have the worst prediction and I'm wondering if that's due to them often having a top expected st dvoa. They haven't always been clear about it, but the way they have usually weighted the elements is (3*OFFDVOA + -3*DEFDVOA + 1*STDVOA) / 7, so ST gets weighted as 1/7 or about 14% of the overall score. This also reminds me that they (and moreso commenters on their site) are bizarrely smug sometimes about the arbitrary decision to have negative be better of defensive DVOA that arose more as an artifact of how the spreadsheet they originally set up to calculate DVOA (they actually still do all their poo poo in excel lol) was formatted than as a conscious choice.
|
# ? Sep 9, 2015 13:41 |
|
I have a new post up on FART! This one looks at how much QBs and defenses should win based on how they perform and compares that to how much they actually win and the performance of a QB and defense from the same team. Again, I had a lot of fun making this one, and there are some surprising results in here (to me at least).Forever_Peace posted:I could probably help you out with that. Will you be doing it in python? The nflgame API posted on the last page seems like it could do this pretty easily. You could do something like: import nflgame thisWeekGames = nflgame.games(2014, week=17) Then parse a file, and use thisWeekGames.players.passing(), .players.rushing(), etc as lists you can search for each user's desired stats. If I had even an hour free before Monday I'd take a look at it.
|
# ? Sep 9, 2015 14:17 |
|
Forever_Peace posted:I could probably help you out with that. I assume you are familiar with 1KYOB Have: a spreadsheet where I type in numbers manually, websites (ESPN / NFL) that display the stats -- basically nothing Want: a way to pull stats from games that have gone final into that spreadsheet/database based on the lists people submit I know there was a 1KYOB site a few years ago, but from what I understand whatever site the data was parsed from changed code and broke it. Right now my plan is to go list by list and manually enter and add numbers, anything that helps make that easier is appreciated.
|
# ? Sep 10, 2015 02:16 |
|
CzarStark posted:Will you be doing it in python? The nflgame API posted on the last page seems like it could do this pretty easily. You could do something like: Alright, made a first pass this morning. I assumed an input file such as this. Can you double-check my code to make sure there aren't any obvious errors? Apologies in advance for the tablebreaking, everyone. code:
|
# ? Sep 10, 2015 16:23 |
|
Oh btw I'm kind of upset you didn't work a "brain fart" joke in the thread title
|
# ? Sep 10, 2015 18:17 |
|
1. Is this where we put MOON POLLS now? 2. Does anyone have a *good* list of bowl tie-ins for this year? I keep running into a lot of things that are clearly not right/for 2014 and not updated.
|
# ? Sep 13, 2015 14:57 |
|
Mukaikubo posted:1. Is this where we put MOON POLLS now? 1. YES 2. Not sure, wouldn't the tie-ins be the same from last year?
|
# ? Sep 13, 2015 15:23 |
|
axeil posted:1. YES As far as I can tell a few conferences renewed their contracts differently and things got a little scrambled... also, I'll post the first edition of my yards-per-play based simple moon poll today to get people kicked off.
|
# ? Sep 13, 2015 15:32 |
|
Mukaikubo posted:1. Is this where we put MOON POLLS now? I'm looking forward to the beatpaths again
|
# ? Sep 13, 2015 15:36 |
|
Hockles posted:I'm looking forward to the beatpaths again Beatpaths were laughable as a predictive stat but I will admit the chart looked really nice. Also it was usually hilarious.
|
# ? Sep 13, 2015 15:58 |
|
Alright then! That was darkly hilarious. Mukai Moon Poll, Week 2- Nobody Knows Nothing Edition It's that time again; I jump first off the gun with insufficient data to make any conclusions! This year, I'm returning to the first moon poll I ever did in TFF: Net Yards/Play. See, I wanted to make a rating system that only really used one stat, and I picked net yards/play (offensive yards/play - defensive yards/play) as my stat. Get that for every team, subtract the number of losses they've had, and subtract 0.5 if they're a midmajor- the "Boise State Rule", learned the hard way the first year I did this- and boom! You have my rating. Calculate a Z score for that rating (rating - average of all ratings)/(standard deviation of all ratings); the number of standard deviations over the mean each rating is. It's still too early for me to do a schedule adjustment, but god I need to; in lieu of that, I'm using the 2014 Simple Rating System ranks for all teams, also normalized into a z-score, and weighted with 1/(#weeks+1). That is, this week, the raw calculation above is weighted 2/3 and the 2014 SRS is weighted 1/3. Next week it'll be 3/4 vs. 1/4, then 4/5 vs. 1/5, and then I'll cut the 2014 stuff entirely and put back in a real schedule adjustment. So! What does this tell us now? pre:Rank Team Final Rating 1 Mississippi 1.975 2 Georgia Tech 1.974 3 USC 1.776 4 Baylor 1.759 5 Boston College 1.688 6 Ohio State 1.514 7 Alabama 1.494 8 Georgia 1.392 9 Florida State 1.366 10 TCU 1.337 ... 124 NM State -1.668 125 Tulane -1.717 126 Akron -1.764 127 UTEP -1.997 128 Idaho -2.500 Look for your Ole Miss-Baylor and Southern California-Georgia Tech playoffs! Feel the excitement! (In advance: No, this isn't very good yet. It's a start with sparse data, and it'll get better with time.)
|
# ? Sep 13, 2015 16:58 |
|
Aaron Schatz, yesterday posted:I finally switched from Microsoft Frontpage (from Office 2000, very old) to Microsoft Expression Web late last season, and I'm still getting used to some of the changes in how it sets up webpages. That must have left me deleting spaces by accident. Oops! I've fixed it now. Innovative Statistics. Intelligent Analysis. Powered by Excel and FrontPage 2000 lmao
|
# ? Sep 24, 2015 21:26 |
|
Frontpage in the year 2015. Are you loving kidding me.
|
# ? Sep 24, 2015 21:30 |
|
NC-17 posted:Frontpage in the year 2015. Are you loving kidding me. No, it was 2014, get it right.
|
# ? Sep 24, 2015 21:40 |
|
Frontpage was awesome. My friend made a Sonic the Hedgehog fan site, but the teacher marked him down for using the word "cocky."
|
# ? Sep 25, 2015 00:40 |
|
Crossposting this from the analysis thread: So, a while back in the N/V thread (I think) people were complaining about the ineffectiveness of QB rating, PFF, and QBR. I kinda miss the old threads were people had crazy formulas for power rankings and poo poo. I was bored, so I toyed around with a QB rating formula. Enjoy. QB SUP Rating Carson Palmer 0.769 Marcus Mariota 0.709 Tyrod Taylor 0.665 Ben Roethlisberger 0.647 Aaron Rodgers 0.619 Andy Dalton 0.586 Tom Brady 0.576 Johnny Manziel 0.506 Jameis Winston 0.497 Derek Carr 0.485 Ryan Fitzpatrick 0.482 Philip Rivers 0.480 Teddy Bridgewater 0.459 Nick Foles 0.454 Jay Cutler 0.448 Cam Newton 0.434 Eli Manning 0.429 Ryan Tannehill 0.426 Russell Wilson 0.418 Matt Ryan 0.407 Alex Smith 0.405 Colin Kaepernick 0.400 Blake Bortles 0.399 Tony Romo 0.394 Matthew Stafford 0.377 Ryan Mallett 0.368 Drew Brees 0.325 Matt McGloin 0.312 Kirk Cousins 0.298 Peyton Manning 0.292 Joe Flacco 0.282 Brian Hoyer 0.278 Andrew Luck 0.257 Sam Bradford 0.234 Jimmy Clausen 0.094 QB SUP rewards dynamic, big play QBs and penalizes dump off, dink and dunk style QBs. The value represents how potentially explosive a player was on any given play. How likely they were to take a risk and have that risk pay off. Peyton Manning and Andrew Luck are a good example of how SUP works. Peyton takes almost no risk and is penalized heavily for it. Luck has to take tons of risks, but they pretty much never pay off. There is some fine tuning I want to do, so I'll use my finalized formula Tuesday. I disqualified some QBs based on limited playing time: Brandon Weeden, Josh McCown, Michael Vick, and Zach Mettenberger. Most of them were in the negatives so I was going to leave them in as a joke but Weeden's performance earned him a 0.762, good for second, and I absolutely refuse to put Brandon loving Weeden that high in a QB list. SlipUp fucked around with this message at 22:32 on Sep 26, 2015 |
# ? Sep 26, 2015 20:47 |
|
Whoops I didn't find this thread until after making the moon poll thread. Well whatever it's not like it hurts anything to have that thread and this one. Some super late responses to things because I just found the thread: axeil posted:Over time you'd expect the team that blows people out to be the better one than the one constantly winning close games, which is why the NCAA computers used to use margin of victory back in the BCS era. Unfortunately this caused coaches to run up the score against Podunk State while the metric was actually just trying to measure the difference between an Ohio State team that constantly wins by 14 and an Auburn team that keeps winning games by 3 or 4 points. Grittybeard posted:I always liked the idea of capping the margin of victory used in the calculation for things like this. I think the general idea was to cap it at 24 points (three TDs + 2 point conversions). Sure you'd get some assholes trying to score a TD with 2 seconds left instead of kneeling the clock out against their conference rival to win by 10 instead of 3, but Juggernaut U has no reason to beat up on Podunk State anymore than they already are.
|
# ? Sep 27, 2015 19:14 |
|
SlipUp posted:rating system for QB I like this system you've devised. It seems to me that there is some type of correlation between good line play and a quarterback's ability to make a risky throw. I wonder if this stat could be further refined to create something similar to OPS+ or ERA+ in baseball. Appreciate the work!
|
# ? Sep 28, 2015 00:31 |
|
Basil Hayden posted:Whoops I didn't find this thread until after making the moon poll thread. Please tell us your rant about SoS and quality wins. I wanna hear it.
|
# ? Sep 28, 2015 01:24 |
|
axeil posted:Please tell us your rant about SoS and quality wins. I wanna hear it. Basil Hayden posted:Now remember what I said about that unclever "strength of schedule" ranking? In 2003, it became a bit of a problem. That season, the polls obviously split on whether USC or LSU was the #1 team after Oklahoma lost their conference championship game, while the computer rankings favored Oklahoma because most of them didn't consider game date. Had the polls been weighted in the 2/3-1/3 way they currently are, or even 1/2-1/2 against the computer rankings, the BCS would have narrowly selected USC and LSU to have played each other in that year's title game. Basil Hayden posted:Billingsley's ratings are not very good and I don't know why they're in the BCS. He starts teams where they were the previous season, and the way teams accumulate rating points means that if a team beats the preseason #5 they get credit for a win over a #5 team even if that team goes 3-9 over the rest of the season. (I need only point at Arkansas this year to show why this is a bad idea -- and of course they started at #6 in the Billingsley ratings this year, meaning they're still in his top 50.) Additionally, from what I can tell, teams that lose early in the season wind up being penalized way more than teams that lose late, even if the team they lost to is significantly better. He adjusts for home-field advantage, and tries to compensate for different venues being harder or easier to play at -- but of course which venue is easier or harder to play at is a subjective call. He also has some sort of weird stipulation that the winner of a game has to be ranked above the loser in the next poll unless they're quite far apart. It's been suggested by those who analyze computer systems that he might also throw in arbitrary adjustments to make his ratings still look like the polls, but I don't know if that's true or not.
|
# ? Sep 28, 2015 02:23 |
|
Basil Hayden posted:I actually found my post from 2012 where I wrote it up originally so here goes: Holy poo poo those Billingsley ratings sound like the dumbest thing ever. How the gently caress did he get away with that?
|
# ? Sep 28, 2015 02:36 |
|
Holy poo poo those Billingsley ratings sound like the dumbest thing ever. How the gently caress did he get away with that? [/quote] The computers that the BCS used were selected by them and were essentially black boxes I believe. They weren't required to release how they ranked teams, though most of the other ones did. Also I think if you look at it Billingsley's ranking was the most often dropped computer ranking in the BCS.
|
# ? Sep 28, 2015 02:45 |
|
axeil posted:Holy poo poo those Billingsley ratings sound like the dumbest thing ever. How the gently caress did he get away with that? I guess to his credit he did make an effort to dig up the past records of every single major school going all the way back to 1869 at a time when this would have been extraordinarily difficult, but it doesn't really help how much of a mess his rating system is. In that same interview he's talking about how the BCS was wrong to have dropped the SOS component after 2003. drunk leprechaun posted:Also I think if you look at it Billingsley's ranking was the most often dropped computer ranking in the BCS. Basil Hayden fucked around with this message at 02:50 on Sep 28, 2015 |
# ? Sep 28, 2015 02:46 |
|
I made the corrections to the formula I wanted. (Most of them, if somebody knows where to find drops by QB that would be awesome.) Here's SUP ratings through week 3. Bengals fans, consider this my apology for doubtin Dalton. QB SUP Aaron Rodgers 0.934 Carson Palmer 0.825 Andy Dalton 0.733 Ben Roethlisberger 0.598 Tom Brady 0.581 Tyrod Taylor 0.564 Marcus Mariota 0.527 Cam Newton 0.523 Derek Carr 0.509 Matt Ryan 0.479 Blake Bortles 0.393 Ryan Fitzpatrick 0.393 Eli Manning 0.387 Jameis Winston 0.382 Ryan Mallett 0.373 Russell Wilson 0.369 Peyton Manning 0.357 Tony Romo 0.330 Ryan Tannehill 0.330 Josh McCown 0.317 Jay Cutler 0.291 Joe Flacco 0.285 Alex Smith 0.283 Philip Rivers 0.269 Andrew Luck 0.264 Kirk Cousins 0.251 Teddy Bridgewater 0.234 Colin Kaepernick 0.222 Matthew Stafford 0.220 Nick Foles 0.212 Sam Bradford 0.136 Drew Brees 0.104 Average 0.396. Interesting but not really relevant because of how much highly rated the top ten are, more just puts them into context. Aaron Rodgers is having an amazing year. Median 0.363 Range 0.830 Min: -3.00 Max: 12.600 Elite tier QBs this year: Aaron Rodgers, Carson Palmer, Andy Dalton. One thing that jumps out at me is that SUP tends to favour younger QBs. SUP gauges calculated risk taking so I'm not surprised to see younger guys take more risks. SUP does penalize for backfired risks, so we see guys like Luck and Kaep near the bottom. Here's a side by side comparison with some other common ratings. Like many of these, SUP attempts to isolate the QBs performance from the team around him. SUP specifically rewards QBs who are good at taking calculated risk. It penalizes dink and dunk, game manager QBs and fail-slinger QBs in favour of dynamic, big play QBs. NFL QB rating is much more favourable to those dink and dunk style QBs with it's heavy reliance on completion %, therefore you see guys like Rivers and Romo who disproportionately benefit from their safe, conservative decisions due to the talent around them. (Lots of YAC yards.) QB rating also has a low ceiling. As long as you have the right comp % and TD amount, it will just spit out the highest possible rating. It's the statistic analysis equivalent of throwing your hands up in the air. In SUP, the highest rated QB has a 0.934, the rating maxes out at 12.600, and frankly it's impossible for a mortal man to achieve that score, so it's always possible to compare two QBs, regardless of how good they both are. QBR is trash as long as they incorporate "clutch", which is the only reason I could see Ben at the top of this list considering his TD:INT ratio. (Or Josh loving McCown for that matter, who isn't even the best QB on his own team.) SUP and QBR supposedly factor in QB rushing stats, but QBR differentiates between a rush and a scramble and I say a play is a play. (And thus, Cam Newton is a top 10 QB) DVOA is just garbage imho. Enjoy! e: fixed e2: mixed up DVOA and DYAR in my head SlipUp fucked around with this message at 23:43 on Sep 29, 2015 |
# ? Sep 29, 2015 22:26 |
|
You can tell DVOA is the worst of the 4 stats because it's the only one without Tyrod in the top 10
|
# ? Sep 29, 2015 22:37 |
|
DVOA hasn't been updated for week 3 yet.
|
# ? Sep 29, 2015 22:38 |
|
SlipUp posted:QB SUP A top 8 list I can get behind
|
# ? Sep 29, 2015 22:42 |
|
Ozu posted:DVOA hasn't been updated for week 3 yet. I guess I jumped the gun on that one. I will edit that post when DVOA is update to reflect through week 3.
|
# ? Sep 29, 2015 22:48 |
|
SlipUp posted:I made the corrections to the formula I wanted. (Most of them, if somebody knows where to find drops by QB that would be awesome.) Here's SUP ratings through week 3. Four of your top five are over 30...
|
# ? Sep 29, 2015 22:49 |
|
SlipUp posted:DVOA is just garbage imho, totally subjective to the whims of the grader. As far as I can tell, there is no statistical basis for Rodgers to have been rated so low against KC, even counting air yards or bad passes, so I assume it's a prejudice or a narrative. QB SUP is totally independent from any outside evaluation and is totally dependant on stats alone. DVOA certainly has flaws but this isn't one of them - there isn't a grader. It's basically a per-play metric that programmatically considers the down and distance and some other circumstances to calculate how "successful" a play was, with their definition of success being something close to "the play made it more likely for the team to gain a first down in this series" with actually getting a first down or scoring being a total success; there is also some accounting for gaining field position, with the boost from long gains capped because the FO people consider them non-predictive past some extent (a better way to do this would have been to use a logarithmic function). The way subjectivity creeps into DVOA is that all the constants that have been revealed are round numbers suggesting that they are rear end-pulls that Aaron Schatz plugged into his spreadsheet twelve years ago rather than numbers reached through some reasoned analysis. So in short, the problems with DVOA are that it tries to accomplish indirectly what WPA and EPA accomplish directly and that there are a bunch of fudge factors involved in its calculation, not that human graders have leeway in assigning scores. Also, is there a missing decimal point in your chart showing DVOA for selected quarterbacks or did you sum ratings or something?
|
# ? Sep 29, 2015 23:01 |
|
Fenrir posted:Four of your top five are over 30... That's mostly based on 7 of 17-25 being over 30, rating Blake Bortles, Jameis Winston, and Ryan Mallet over Peyton Manning. I guess it's misleading to say it favours younger QBs, it favours risk taking QBs, and the younger guys are generally willing to make riskier throws. e: Taking a second look at the comparison chart, SUP is split 5-5 over/under 30, NFL is 6-4, then QBR and DVOA are 7-3. Maybe it's the other guys discriminating against younger QBs! SlipUp fucked around with this message at 02:30 on Sep 30, 2015 |
# ? Sep 29, 2015 23:14 |
|
SlipUp posted:I guess I jumped the gun on that one. I will edit that post when DVOA is update to reflect through week 3. You also didn't use DVOA, you used DYAR, a counting stat. Blotto Skorzany posted:. The way subjectivity creeps into DVOA is that all the constants that have been revealed are round numbers suggesting that they are rear end-pulls that Aaron Schatz plugged into his spreadsheet twelve years ago rather than numbers reached through some reasoned analysis. Hmm? They constants they came up with were from analysis of the play by play data they have access to (I think they're back to the late 80's now?) to figure out what the odds of converting first downs have been. Constants were rounded to specific yardage #'s because play by play reports only whole increments of yardage
|
# ? Sep 29, 2015 23:20 |
|
Kalli posted:You also didn't use DVOA, you used DYAR, a counting stat. fixed and updated through week 3
|
# ? Sep 29, 2015 23:22 |
|
Kalli posted:Constants were rounded to specific yardage #'s because play by play reports only whole increments of yardage It's not that 6 rather than 6.1 or whatever yards on 2nd-and-10 is the threshold of success, it's that the 'big play' cutoff is an integer multiple of ten yards and so on (and The Hidden Game of Football, from whence they 'borrowed' all the actual math behind all their initial work, isn't the source of that number either). It's harder to see with DVOA and DYAR proper because they tend to reveal less about their premier stats (and when they do it's generally in a piecemeal fashion where they'll talk about bumping some constant from 20% to 30% this year in the introductory text of a random Quick Reads or weekly DVOA column), but the numbers they give for Adjusted Line Yards are illuminating: FO Adjusted Line Yards explanation page posted:Losses: 120% value The boundary numbers for classifying gains are 0, 5 and 10 yards gained and the values assigned to each bucked are all really round numbers - there's no way that poo poo is the result of regression analysis or some other statistical method.
|
# ? Sep 29, 2015 23:51 |
|
What's the skinny on the Fanduel / Draft Kings scandal? Was the notion that, knowing how everyone else is playing, an insider could place bets in the gaps and up his chances for the bigger payouts?
|
# ? Oct 8, 2015 16:53 |
|
Yep, that's the gist of it.
|
# ? Oct 8, 2015 17:39 |
|
|
# ? May 25, 2024 14:00 |
|
Hi guys, remember this thread? Anyway, if any of you still are bookmarked on this, or happen to follow this, I am in need of help with the script Forever_Peace made for me for 1KYOB using nfldb and python. I want to know how to pull stats for the playoffs coming up. The script starts off like this: code:
|
# ? Dec 30, 2015 08:26 |