|
My poll produces spurious results before all teams are connected via actual games, but as a quirk on top of that it does produce a technically meaningful Week 1 result: 1-T. Every Division 1 team that won against a Division 1 opponent in week 1. 2-T. Every Division 1 team that lost against a Division 1 opponent in week 1.
|
# ¿ Sep 2, 2013 22:17 |
|
|
# ¿ Apr 25, 2024 00:09 |
|
For those whose polls only need team names, scores, dates, and home/away, they're available in CSV here: http://www.ncaa.org/wps/wcm/connect/public/NCAA/Resources/Stats/Football/schedules.html
|
# ¿ Sep 5, 2013 20:04 |
|
Huh, you're right, they don't contain the score. I hope that just means they don't contain the score yet. I used these files last year and assumed that "Download 2013 Schedule and results listing as CSV file" meant that I could download the 2013 schedule and results listing as a CSV file. NCAA
|
# ¿ Sep 5, 2013 20:15 |
|
That is friggin' infuriating. I need some kind of machine-readable data for the poll to work, and I'm sure everyone else does too. I've googled around to see if anyone else has a spreadsheet, but so far there's nothing very good. I'd assume some website somewhere will have some data - the betting sites maybe - but you'd expect that the NCAA wouldn't go out of their way to kill a useful resource. Here's some score data at least, but it mixes NAIA data in and it'll be irritating to disentangle: http://prwolfe.bol.ucla.edu/cfootball/scores.htm
|
# ¿ Sep 7, 2013 02:00 |
|
Tad SG posted:Here's the closest I can find to the old format for the NCAA stats pages. Ok, this is usable. It's formatted in a kind of screwball way, so I'll actually have to read in three separate files: the one that associates team names with team numbers, the one that associates team numbers with game codes, and the one that associates game codes with game scores. But it's CSV, which is at least vastly easier to do than trying to write some website scraper. If there's interest, I can try to whip up some code to convert the cfbstats.com file to the old NCAA CSV format.
|
# ¿ Sep 7, 2013 17:25 |
|
Uncle Jam posted:I found most of the stats I want in team-game-statistics, but where are the W-L records or game scores? It'd be nice to not have to compile them from the game statistics or however you could retrieve them. team-game-statistics.cvs has a "points" stat buried somewhere in the middle (in column AJ if you open it in Excel). So you can extract data along the lines of "Team #21 played in Game #52 and scored 14 points". It's awkward, but usable.
|
# ¿ Sep 7, 2013 18:42 |
|
After a really embarrassingly long time of coding, I wrote a Python script to convert the cfbstats.com files to the NCAA csv format. Please spot-check it to make sure I haven't borked the coding somewhere. Sadly it's just FBS. If someone finds this kind of data for FCS let me know and I'll include it as well. This is the result from cfbstats.com's data on their website now, which does not yet include this weekend's games. When it does I'll post that as well.code:
|
# ¿ Sep 8, 2013 22:25 |
|
Frolic posted:Thanks for this! The only difference I can find is that the ncaa csv didn't list FBS vs FCS twice. It would have an entry with FBS VS FCS but there wouldn't be a reverse entry FCS vs FBS like there is for FBS vs FBS. Hopefully that makes sense! Ok, cool. I'll probably try to implement that double-listing thing on next week's iteration so it exactly reproduces the old DIVISIONB.CSV. I'm still holding out hope I can find some machine-readable data source for FCS games, which would make this a lot easier and additionally reproduce the old DIVISIONC.CSV which would help some of us (including me) rank FCS teams. Please everyone keep an eye out for FCS data. cfbstats.com just updated their stats file through this weekend, so here's my parsing of it. As pointed out, it's not quite identical to DIVISIONB.CSV yet because it lists all games including FBS/FCS games twice. Apologies for the wall of text - next week I'll find a host. code:
|
# ¿ Sep 9, 2013 01:00 |
|
Here's my quasi-clone of the old DIVISIONB.CSV file, this time in convenient Pastebin format: http://pastebin.com/A3SqYttG Unfortunately I've been swamped so I haven't yet implemented the non-duplication of the FBS vs FCS games. With some luck I'll have that soon. When that happens I'll probably post both versions just in case someone's poll relies on this current format of mine. As usual, please everybody keep an eye out for machine readable FCS data. We still don't have a good source for that.
|
# ¿ Sep 16, 2013 04:41 |
|
Pastebin link for this week's DIVISIONB.CSV clone: http://pastebin.com/TU2WjEV1 Standard caveats apply: all games are listed twice - a line for A vs B and a line for B vs A. This is true for games involving FCS teams as well. I will fix this eventually.
|
# ¿ Sep 22, 2013 19:22 |
|
Frolic posted:Here is the data without duplicates for FCS if anyone needs it: http://pastebin.com/HvNN2sfN Python. Sure, I'd be interested in the code to remove the duplicates. I'll be happy to post my reader code too, but be warned I've managed to write basically unreadable Python which is quite the accomplishment.
|
# ¿ Sep 23, 2013 02:17 |
|
DIVISIONB.CSV (FCS duplications included) pastebin: http://pastebin.com/iW9m7Qbm This is the first week of my poll. I'm only including the top 25 as I haven't worked out FCS handling yet. As every week, I implore somebody to find a CSV file for FCS. code:
|
# ¿ Sep 29, 2013 20:39 |
|
DIVISIONB.CSV pastebin: http://pastebin.com/veQCcVM5 As always, someone find me some friggin' FCS data. At this point I'll post the entire output of my program. There is an idiosyncrasy in that it's essentially a ranking based on games played involving FBS teams. If you're an FCS team who has played FBS teams, you're on the list but your ranking is only determined by the FBS games. I don't like this, but as I haven't had time to revise it from last year when we had CSVs for both FBS and FCS, it is what it is. We're still pretty early in the season, so there's some bad undefeated teams who're highly ranked. This will shake itself out. In the meantime enjoy the comedy of #6 Missouri, etc. code:
|
# ¿ Oct 6, 2013 18:32 |
|
They're definitely not the world-beaters they were last season. I don't know if our #1 and #2 teams are right, but having Bama at three... it's not that implausible.
|
# ¿ Oct 6, 2013 22:00 |
|
Duplicates-included DIVISIONB.CSV pastebin: http://pastebin.com/436iWbss Here's my rankings as of 10/12/2013. All games involving FBS teams are included, which means those FCS teams which play FBS teams are included, but ranked only on those games. This is... screwy, but I haven't got around to fixing it yet. For interpretation purposes I'd say to ignore FCS teams on this list. Oregon is way out front. Alabama stands at #3. I thought my poll was nuts for thinking Mizzou was as good as it did, but this weekend proved me wrong. Of course the poll immediately tests my resolve again with their ranking this week. code:
|
# ¿ Oct 13, 2013 17:32 |
|
DIVISIONB.CSV pastebin: http://pastebin.com/5C3MBiMm Upsets either mean the favored team wasn't as good as you thought, the underdog was better than you thought, or some combination. After it all comes out in the wash: code:
|
# ¿ Oct 20, 2013 19:56 |
|
DIVISIONB.CSV pastebin: http://pastebin.com/nb7mDvPk Week 9. My algorithm doesn't much penalize a team for a close loss to another good team, so Mizzou is still somehow #5. LSU/TAMU is now a wash - that'll be an interesting game. Unfortunately, Bama has now pretty much inched out of near-equal to prohibitive favorite with respect to LSU. code:
|
# ¿ Oct 27, 2013 21:17 |
|
DIVISIONB.CSV: http://pastebin.com/MPCLXXX7 Bama and Ohio State can take a long walk on a short pier. Week 10: code:
|
# ¿ Nov 4, 2013 01:47 |
|
Man, quiet thread this year. DIVISIONB.CSV This poll tends toward late-season stability, because it doesn't care about the order in which games are played. A late loss is no worse than an early loss. Thus Oregon just fell to #4. Don't take any of the FCS rankings seriously, as they're based purely on games vs FBS teams and thus aren't very fair. code:
|
# ¿ Nov 11, 2013 19:18 |
|
Fortunately mine is still pretty easy to run. It's about a 5-minute process to finagle the CFBStats.com data into last year's format, but one way or another, here's this week's poll & DIVISIONB pastebin.code:
|
# ¿ Nov 18, 2013 01:26 |
|
|
# ¿ Apr 25, 2024 00:09 |
|
Haven't done this in a few weeks, but since it's the end of the pre-bowl season I'll go ahead and post the latest result. FBS only, though the ratings are derived from games against FCS teams also, provided the FCS teams have played more than 1 FBS team.code:
|
# ¿ Dec 9, 2013 07:32 |