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.0.1 ──
#> ℹ Data updated: 2023-04-12 09:39:29 UTC
#> # A tibble: 196,564 × 55
#> game_id season season_type game_date game_date_time athlete_id
#> <int> <int> <int> <date> <dttm> <int>
#> 1 401522202 2023 3 2023-04-03 2023-04-03 21:20:00 4431786
#> 2 401522202 2023 3 2023-04-03 2023-04-03 21:20:00 4397371
#> 3 401522202 2023 3 2023-04-03 2023-04-03 21:20:00 4702011
#> 4 401522202 2023 3 2023-04-03 2023-04-03 21:20:00 4433183
#> 5 401522202 2023 3 2023-04-03 2023-04-03 21:20:00 4397049
#> 6 401522202 2023 3 2023-04-03 2023-04-03 21:20:00 4897531
#> 7 401522202 2023 3 2023-04-03 2023-04-03 21:20:00 4870565
#> 8 401522202 2023 3 2023-04-03 2023-04-03 21:20:00 4431879
#> 9 401522202 2023 3 2023-04-03 2023-04-03 21:20:00 4397368
#> 10 401522202 2023 3 2023-04-03 2023-04-03 21:20:00 4397237
#> # ℹ 196,554 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>, …
# }