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