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
DBIConnection
object, 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>, …
# }