Lookup Functions
Player
- lookup.lookup_player(player_name, school):
A function to find a player’s id from their name and school
- Player_name (str)
name of player to lookup
- School
the name of the player’s school (str) or school_id (int)
- Returns (int)
player_id
- Examples
lookup_player(“Jake Gelof”, “Virginia”) >>> 2486499
- lookup.lookup_player_reverse(player_id):
A function to find a player’s name and school from their player_id
- Player_id (str)
name of player to lookup
- Season (int)
YYYY
- Returns (tuple)
of player_name (str), school_name (str), school_id (int)
- lookup_seasons_played(stats_player_seq):
A function to find the final and debut seasons of a given player
- Stats_player_seq (int)
NCAA player_id
- Returns (tuple(int))
of debut season, most recent season
School
- lookup.lookup_school(school_name):
A function to find a school’s id from it’s name
- School (str)
the name of the school
- Returns (int)
school_id
- Examples
lookup_school(“cornell”) >>> 167
- lookup.lookup_school_reverse(school_id):
A function to find a school’s name from a school_id
- School_id (int)
- Returns (str)
the name of the school
- Examples
lookup_school_reverse(167) >>> “Cornell”
Season
- lookup_season_id(season):
A function that finds the year_stat_category_ids for a given season
- Season (int)
YYYY
- Returns (int)
season_id
- lookup.lookup_season_ids(season):
A function that finds the year_stat_category_ids of a given season
- Season (int)
YYYY
- Returns
tuple of season_id, batting_id, pitching_id
- lookup_season_reverse(season_id):
A function that finds the year_stat_category_ids and season of a season_id
- Season_id (int)
NCAA season_id
- Returns (tuple)
of season_id, batting_id, pitching_id