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_name | types |
id | numeric |
sequence_number | character |
type_id | integer |
type_text | character |
text | character |
away_score | integer |
home_score | integer |
period_number | integer |
period_display_value | character |
clock_display_value | character |
scoring_play | logical |
score_value | integer |
team_id | integer |
athlete_id_1 | integer |
athlete_id_2 | integer |
athlete_id_3 | integer |
wallclock | character |
shooting_play | logical |
coordinate_x_raw | numeric |
coordinate_y_raw | numeric |
season | integer |
season_type | integer |
away_team_id | integer |
away_team_name | character |
away_team_mascot | character |
away_team_abbrev | character |
away_team_name_alt | character |
home_team_id | integer |
home_team_name | character |
home_team_mascot | character |
home_team_abbrev | character |
home_team_name_alt | character |
home_team_spread | numeric |
game_spread | numeric |
home_favorite | logical |
game_spread_available | logical |
game_id | integer |
qtr | integer |
time | character |
clock_minutes | integer |
clock_seconds | numeric |
half | character |
game_half | character |
lead_qtr | integer |
lead_game_half | character |
start_quarter_seconds_remaining | integer |
start_half_seconds_remaining | integer |
start_game_seconds_remaining | integer |
game_play_number | integer |
end_quarter_seconds_remaining | integer |
end_half_seconds_remaining | integer |
end_game_seconds_remaining | integer |
period | integer |
lag_qtr | integer |
lag_game_half | character |
coordinate_x | numeric |
coordinate_y | numeric |
game_date | Date |
game_date_time | POSIXct |
type_abbreviation | character |
See also
Other hoopR Loader Functions:
load_mbb_pbp()
,
load_mbb_player_box()
,
load_mbb_schedule()
,
load_mbb_team_box()
,
load_nba_player_box()
,
load_nba_schedule()
,
load_nba_team_box()
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>, …
# }