Load fastRhockey PWHL penalty summaries — load_pwhl_penalty

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

Source release tag: pwhl_penalty_summary. File naming convention: penalty_summary_{end_year}.rds.

Usage

load_pwhl_penalty_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 penalty 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
`time`	character	game clock at infraction (`MM:SS`)
`team_id`	integer	penalized team id
`team`	character	penalized team name
`minutes`	numeric	penalty length in minutes
`description`	character	infraction description
`is_power_play`	integer	power-play flag
`is_bench`	integer	bench-minor flag
`taken_by_id`	integer	player who took the penalty
`taken_by_first`	character	offender first name
`taken_by_last`	character	offender last name
`served_by_id`	integer	player serving the penalty

Examples

# \donttest{
  try(load_pwhl_penalty_summary(2024))
#> ─────────────────────────────────────────────────────────── fastRhockey 1.0.0 ──
#> # A tibble: 518 × 20
#>    game_id period_id period time  team_id team         team_abbr game_penalty_id
#>      <int>     <int> <chr>  <chr>   <int> <chr>        <chr>               <int>
#>  1       2         1 1st    13:23       6 PWHL Toronto TOR                    73
#>  2       2         1 1st    15:21       4 PWHL New Yo… NY                     74
#>  3       2         1 1st    19:59       4 PWHL New Yo… NY                     75
#>  4       2         3 3rd    08:49       6 PWHL Toronto TOR                    76
#>  5       2         3 3rd    11:54       4 PWHL New Yo… NY                     77
#>  6       2         3 3rd    12:39       4 PWHL New Yo… NY                     78
#>  7       3         1 1st    03:22       3 PWHL Montre… MTL                    79
#>  8       3         1 1st    08:37       3 PWHL Montre… MTL                    81
#>  9       3         1 1st    10:20       3 PWHL Montre… MTL                    80
#> 10       3         2 2nd    07:28       3 PWHL Montre… MTL                    84
#> # ℹ 508 more rows
#> # ℹ 12 more variables: minutes <int>, description <chr>, rule_number <chr>,
#> #   is_power_play <int>, is_bench <int>, taken_by_id <int>,
#> #   taken_by_first <chr>, taken_by_last <chr>, taken_by_position <chr>,
#> #   served_by_id <int>, served_by_first <chr>, served_by_last <chr>
# }