sprx97 / jcs Goto Github PK

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.

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
...

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).

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.

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.

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).

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.

And # of OTs if possible

Install the pandas library for python

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.

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).

Needs to be a separate table, that indicates the year that each team joined/left a conference/division.

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.

things broke so I need a new source for this.

We're missing all of the stats besides team IDs and scores for 10/27 and 10/28/17.

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.

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.

Looks like the data is up now, just need to delete those rows and rerun.