Illini Football Dataset (1892-2020)
The "Football Dataset" contains every game played by the University of Illinois' football team from 1892 through the end of the 2020 season.
- Dataset Format: Well-formatted CSV with column headers as the first row
- Dataset Size: 1,259 rows × 9 columns
- CSV File Location: https://waf.cs.illinois.edu/discovery/football.csv
- Dataset Variables:
Season
: number ➜ The season when the game was played. Usually the same asYear
, except for some rate January games (ex: bowl games)Date
: string ➜ The date when the game was playedLocation
: string ➜vs.
for home games;@
for away games; the city, state for games at neutral sites (ex:Chicago, IL
)Opponent
: string ➜ The name of the opponent (ex:Purdue
)OpponentRank
: number ➜ The NCAA rank of the opponent (only available for very recent seasons) or blankResult
: string ➜W
for an Illini win;L
for an Illini loss;T
for a tied gameIlliniScore
: number ➜ The final score for the University of IllinoisOpponentScore
: number ➜ The final score for the opponentNote
: string ➜ Notes for bowl games (ex:Rose Bowl
), homecoming (Homecoming
), or cancelled games (ex:Canceled (COVID-19)
)
Using the Football Dataset in Python
The dataset can be loaded using the pandas
library in Python:
import pandas as pd
df = pd.read_csv("https://waf.cs.illinois.edu/discovery/football.csv")
df
Season | Date | Location | Opponent | OpponentRank | Result | IlliniScore | OpponentScore | Note | |
---|---|---|---|---|---|---|---|---|---|
0 | 2020 | 10/23/2020 | @ | Wisconsin | 14.0 | L | 7.0 | 45.0 | NaN |
1 | 2020 | 10/31/2020 | vs. | Purdue | NaN | L | 24.0 | 31.0 | NaN |
2 | 2020 | 11/7/2020 | vs. | Minnesota | NaN | L | 14.0 | 41.0 | NaN |
3 | 2020 | 11/14/2020 | @ | Rutgers | NaN | W | 23.0 | 20.0 | NaN |
4 | 2020 | 11/21/2020 | @ | Nebraska | NaN | W | 41.0 | 23.0 | NaN |
... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
1254 | 1892 | 1892-10-29 | @ | Kansas City A.C. | NaN | W | 42.0 | 0.0 | NaN |
1255 | 1892 | 1892-11-05 | vs. | Englewood High | NaN | W | 38.0 | 0.0 | NaN |
1256 | 1892 | 1892-11-16 | @ | Chicago | NaN | L | 4.0 | 10.0 | NaN |
1257 | 1892 | 1892-11-18 | vs. | DePauw | NaN | W | 34.0 | 0.0 | NaN |
1258 | 1892 | 1892-11-24 | vs. | Chicago | NaN | W | 28.0 | 12.0 | NaN |
The full Football Dataset stored in a DataFrame (1,259 rows).
Pages Using the Football Dataset
- Learn Page: Grouping Data in Python
- Learn Page: Grouping Data in Python
- Learn Page: Basic Data Visualization in Python
- Learn Page: Basic Data Visualization in Python
- Video Walk-Through & Worksheet: Learn Page: Reading Histograms (Part 2)