helper that loads multiple seasons from the data repo either into memory or writes it into a db using some forwarded arguments in the dots
Usage
load_mbb_player_box(
seasons = most_recent_mbb_season(),
...,
dbConnection = NULL,
tablename = NULL
)Arguments
- seasons
A vector of 4-digit years associated with given men's college basketball seasons. (Min: 2003)
- ...
Additional arguments passed to an underlying function that writes the season data into a database (used by
update_mbb_db()).- dbConnection
A
DBIConnectionobject, as returned by- tablename
The name of the play by play data table within the database
Value
Returns a tibble
| col_name | types |
| game_id | integer |
| season | integer |
| season_type | integer |
| game_date | Date |
| game_date_time | POSIXct |
| athlete_id | integer |
| athlete_display_name | character |
| team_id | integer |
| team_name | character |
| team_location | character |
| team_short_display_name | character |
| minutes | numeric |
| field_goals_made | integer |
| field_goals_attempted | integer |
| three_point_field_goals_made | integer |
| three_point_field_goals_attempted | integer |
| free_throws_made | integer |
| free_throws_attempted | integer |
| offensive_rebounds | integer |
| defensive_rebounds | integer |
| rebounds | integer |
| assists | integer |
| steals | integer |
| blocks | integer |
| turnovers | integer |
| fouls | integer |
| points | integer |
| starter | logical |
| ejected | logical |
| did_not_play | logical |
| active | logical |
| athlete_jersey | character |
| athlete_short_name | character |
| athlete_headshot_href | character |
| athlete_position_name | character |
| athlete_position_abbreviation | character |
| team_display_name | character |
| team_uid | character |
| team_slug | character |
| team_logo | character |
| team_abbreviation | character |
| team_color | character |
| team_alternate_color | character |
| home_away | character |
| team_winner | logical |
| team_score | integer |
| opponent_team_id | integer |
| opponent_team_name | character |
| opponent_team_location | character |
| opponent_team_display_name | character |
| opponent_team_abbreviation | character |
| opponent_team_logo | character |
| opponent_team_color | character |
| opponent_team_alternate_color | character |
| opponent_team_score | integer |
See also
Other hoopR Loader Functions:
load_mbb_pbp(),
load_mbb_schedule(),
load_mbb_team_box(),
load_nba_pbp(),
load_nba_player_box(),
load_nba_schedule(),
load_nba_team_box()
Examples
# \donttest{
load_mbb_player_box(seasons = most_recent_mbb_season())
#> ── ESPN MBB Player Boxscores from hoopR data repository ───────── hoopR 2.1.0 ──
#> ℹ Data updated: 2023-11-28 11:12:54 UTC
#> # A tibble: 40,789 × 55
#> game_id season season_type game_date game_date_time athlete_id
#> <int> <int> <int> <date> <dttm> <int>
#> 1 401598040 2024 2 2023-11-27 2023-11-27 23:00:00 4596528
#> 2 401598040 2024 2 2023-11-27 2023-11-27 23:00:00 4592435
#> 3 401598040 2024 2 2023-11-27 2023-11-27 23:00:00 4701995
#> 4 401598040 2024 2 2023-11-27 2023-11-27 23:00:00 4432753
#> 5 401598040 2024 2 2023-11-27 2023-11-27 23:00:00 4431757
#> 6 401598040 2024 2 2023-11-27 2023-11-27 23:00:00 4433166
#> 7 401598040 2024 2 2023-11-27 2023-11-27 23:00:00 5105647
#> 8 401598040 2024 2 2023-11-27 2023-11-27 23:00:00 5105648
#> 9 401598040 2024 2 2023-11-27 2023-11-27 23:00:00 4701217
#> 10 401598040 2024 2 2023-11-27 2023-11-27 23:00:00 5174978
#> # ℹ 40,779 more rows
#> # ℹ 49 more variables: athlete_display_name <chr>, team_id <int>,
#> # team_name <chr>, team_location <chr>, team_short_display_name <chr>,
#> # minutes <dbl>, field_goals_made <int>, field_goals_attempted <int>,
#> # three_point_field_goals_made <int>,
#> # three_point_field_goals_attempted <int>, free_throws_made <int>,
#> # free_throws_attempted <int>, offensive_rebounds <int>, …
# }