Load fastRhockey PWHL scoring summaries — load_pwhl_scoring

Helper that loads multiple seasons of per-goal PWHL scoring summaries (one row per goal) from the sportsdataverse-data releases either into memory or writes it into a database.

Source release tag: pwhl_scoring_summary. File naming convention: scoring_summary_{end_year}.rds.

Usage

load_pwhl_scoring_summary(
  seasons = most_recent_pwhl_season(),
  ...,
  dbConnection = NULL,
  tablename = NULL
)

Arguments

seasons: A vector of 4-digit years associated with given PWHL seasons. (Min: 2024)
...: Additional arguments (currently unused; kept for API symmetry).
dbConnection: A DBIConnection object, as returned by DBI::dbConnect()
tablename: The name of the scoring summary data table within the database

Value

A data frame of class fastRhockey_data. Common columns include:

column	type	description
`game_id`	integer	PWHL game id
`period_id`	integer	period id
`period`	character	period long name (e.g. `1st`, `1st OT`)
`time`	character	game clock at goal (`MM:SS`)
`team_id`	integer	scoring team id
`team`	character	scoring team name
`scorer_id`	integer	goal scorer id
`scorer_first`	character	scorer first name
`scorer_last`	character	scorer last name
`assist_1_id`	integer	primary assist id
`assist_2_id`	integer	secondary assist id
`is_power_play`	integer	power-play flag
`is_short_handed`	integer	short-handed flag
`is_empty_net`	integer	empty-net flag
`is_penalty_shot`	integer	penalty-shot flag
`is_game_winning`	integer	game-winning-goal flag

Examples

# \donttest{
  try(load_pwhl_scoring_summary(2024))
#> ─────────────────────────────────────────────────────────── fastRhockey 1.0.0 ──
#> # A tibble: 385 × 27
#>    game_id period_id period time  team_id team           team_abbr game_goal_id
#>      <int>     <int> <chr>  <chr>   <int> <chr>          <chr>            <int>
#>  1       2         1 1st    10:43       4 PWHL New York  NY                  64
#>  2       2         3 3rd    2:53        4 PWHL New York  NY                  65
#>  3       2         3 3rd    4:57        4 PWHL New York  NY                  66
#>  4       2         3 3rd    7:42        4 PWHL New York  NY                  67
#>  5       3         2 2nd    16:24       5 PWHL Ottawa    OTT                 68
#>  6       3         2 2nd    17:45       3 PWHL Montreal  MTL                 69
#>  7       3         3 3rd    5:18        5 PWHL Ottawa    OTT                 70
#>  8       3         3 3rd    14:23       3 PWHL Montreal  MTL                 71
#>  9       3         4 1st OT 1:04        3 PWHL Montreal  MTL                 72
#> 10       4         1 1st    3:58        2 PWHL Minnesota MIN                 73
#> # ℹ 375 more rows
#> # ℹ 19 more variables: scorer_goal_number <int>, scorer_id <int>,
#> #   scorer_first <chr>, scorer_last <chr>, scorer_position <chr>,
#> #   assist_1_id <int>, assist_1_first <chr>, assist_1_last <chr>,
#> #   assist_2_id <int>, assist_2_first <chr>, assist_2_last <chr>,
#> #   is_power_play <int>, is_short_handed <int>, is_empty_net <int>,
#> #   is_penalty_shot <int>, is_insurance <int>, is_game_winning <int>, …
# }