Skip to contents

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_nba_pbp(
  seasons = most_recent_nba_season(),
  ...,
  dbConnection = NULL,
  tablename = NULL
)

Arguments

seasons

A vector of 4-digit years associated with given NBA seasons. (Min: 2002)

...

Additional arguments passed to an underlying function that writes the season data into a database (used by update_nba_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_nametypes
idnumeric
sequence_numbercharacter
type_idinteger
type_textcharacter
textcharacter
away_scoreinteger
home_scoreinteger
period_numberinteger
period_display_valuecharacter
clock_display_valuecharacter
scoring_playlogical
score_valueinteger
team_idinteger
athlete_id_1integer
athlete_id_2integer
athlete_id_3integer
wallclockcharacter
shooting_playlogical
coordinate_x_rawnumeric
coordinate_y_rawnumeric
seasoninteger
season_typeinteger
away_team_idinteger
away_team_namecharacter
away_team_mascotcharacter
away_team_abbrevcharacter
away_team_name_altcharacter
home_team_idinteger
home_team_namecharacter
home_team_mascotcharacter
home_team_abbrevcharacter
home_team_name_altcharacter
home_team_spreadnumeric
game_spreadnumeric
home_favoritelogical
game_spread_availablelogical
game_idinteger
qtrinteger
timecharacter
clock_minutesinteger
clock_secondsnumeric
halfcharacter
game_halfcharacter
lead_qtrinteger
lead_game_halfcharacter
start_quarter_seconds_remaininginteger
start_half_seconds_remaininginteger
start_game_seconds_remaininginteger
game_play_numberinteger
end_quarter_seconds_remaininginteger
end_half_seconds_remaininginteger
end_game_seconds_remaininginteger
periodinteger
lag_qtrinteger
lag_game_halfcharacter
coordinate_xnumeric
coordinate_ynumeric
game_dateDate
game_date_timePOSIXct
type_abbreviationcharacter

Examples

# \donttest{
  load_nba_pbp(seasons = most_recent_nba_season())
#> ── ESPN NBA Play-by-Play from hoopR data repository ───────────── hoopR 2.0.0 ──
#>  Data updated: 2023-04-30 14:26:22 UTC
#> # A tibble: 599,579 × 60
#>             id sequence_number type_id type_text     text  away_score home_score
#>          <dbl> <chr>             <int> <chr>         <chr>      <int>      <int>
#>  1  4015443344 4                   615 "Jumpball"    Dean…          0          0
#>  2  4015443348 8                    62 "Bad Pass\nT… Jama…          0          0
#>  3 40154433410 10                  128 "Driving Fin… Devi…          2          0
#>  4 40154433411 11                    9 "Defensive G… Mich…          2          0
#>  5 40154433412 12                  144 "Driving Flo… Jama…          2          2
#>  6 40154433413 13                  130 "Floating Ju… Dean…          4          2
#>  7 40154433415 15                  131 "Pullup Jump… Jama…          4          5
#>  8 40154433416 16                   12 "Kicked Ball" Niko…          4          5
#>  9 40154433417 17                  137 "Turnaround … Kevi…          6          5
#> 10 40154433419 19                   92 "Jump Shot"   Kent…          6          8
#> # ℹ 599,569 more rows
#> # ℹ 53 more variables: period_number <int>, period_display_value <chr>,
#> #   clock_display_value <chr>, scoring_play <lgl>, score_value <int>,
#> #   team_id <int>, athlete_id_1 <int>, athlete_id_2 <int>, athlete_id_3 <int>,
#> #   wallclock <chr>, shooting_play <lgl>, coordinate_x_raw <dbl>,
#> #   coordinate_y_raw <dbl>, season <int>, season_type <int>,
#> #   away_team_id <int>, away_team_name <chr>, away_team_mascot <chr>, …
# }