jcs's People
jcs's Issues
Backfill penalty data
Add historical stadium attendance
Or capacity if attendance can't be found. I guess if we have both attendance and capacity, or if I'll need to mix and match, we could have a column for both. You said ESPN may have attendance for the last few years. I'll try to find a good source for capacity/older info.
Add Game Type column to Games
I know you said bowl games aren't flagged in Sports Reference, but I would like to have this included in our data set even if I have to do it manually.
Rather than a flag I think it should actually be an Int for Game Type, e.g.:
1 = regular season
2 = bowl (non playoff/championship)
3 = playoffs (non championship)
4 = championship
...
Backfill data prior to 2000
My other source I mentioned actually doesn't have box scores either so it's not any more useful than Sport Reference. If you still want to fill in data back to 18-whenever that's cool, and we can just leave the missing info Null (or 0 or something if you don't allow Null values and don't want to change that).
Duplicate Games (home/away)
Some neutral site games seem to have two entries with the home/away teams flipped. It should be pretty easy to write as script to identify these and manually clean them up.
Add current conference/division to Teams table
My only idea is if there's an easy way to have this updated based on our historical conference table. Like once per year this checks for the most recent record for each team from that table, then updates the Teams table where needed. Otherwise I'm also fine doing this manually - there are very few changes each year.
Add Vegas Money Line
So far I've only really used the JCS to predict winners and losers. I've started trying to predict game spreads, but that's difficult.
If I ever want to use this in Vegas it might be easier to bet based on the money line instead of the spread. Would it be difficult to add that as another 2 fields (one for home team, one for away team)? Hopefully this won't be too different from what you already have for the spread (which I also still want to keep btw).
Add Vegas Lines
I'll find the best source I can for you. If you want to share your aliasing file with me I can maybe update it for the new source if need be.
Mark OT games
And # of OTs if possible
Fill in missing 2000/2001 bowl game stats
Install pandas
Install the pandas library for python
Neutral Site flag not used/working
Sports-references does not have location data for games, so neutral site games are still listed as Home/Away. This data could possibly be pulled from ESPN (want to avoid because of how often the UI changes), or I could make a tool (think gamelog with checkboxes) to manually update this quickly.
Add table for preseason data
I still need to put this together, just wanted to float the idea. It would be a few years of data (maybe 5-10, then adding new years going forward).
Add table for historical conference affiliation
Needs to be a separate table, that indicates the year that each team joined/left a conference/division.
Re-run script for games with missing stats
There are various days that have games with missing stats:
- 2017-11-25
- 2017-11-18
- 2017-11-03
- 2017-09-09
- 2017-09-02
- 2016-10-29
- 2016-10-08
- 2016-09-10
- 2014-09-25
- 2014-09-06
- 2014-08-30
- 2013-11-16
- 2013-11-09
- 2013-10-26
- 2013-10-19
- 2012-09-15
I created a separate issue for 2017-18 bowl games, since those are all missing stats as a group.
Find new source and backfill Vegas lines
things broke so I need a new source for this.
Missing Stats 10/27 - 10/28/17
We're missing all of the stats besides team IDs and scores for 10/27 and 10/28/17.
When filtering results by team, show the chosen team all in the same column
Currently the visitor is always in the left column and the home team in the right. This is annoying when filtering by team and trying to view stats for one team.
Add school/stadium locations
Should include:
- City
- State
- Zip
- Longitude
- Latitude
I think it makes more sense to list schools instead of stadiums since those are less likely to move (and the difference shouldn't matter). But ideally neutral site stadium locations would be included as well.
Re-run script for 2017-18 bowl games
Looks like the data is up now, just need to delete those rows and rerun.
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. ๐๐๐
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google โค๏ธ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.