Load fastRhockey PWHL skater box scores — load_pwhl_skater

Helper that loads multiple seasons of pre-scraped PWHL skater-only box score data from the sportsdataverse-data releases either into memory or writes it into a database.

Source release tag: pwhl_skater_boxscores. File naming convention: skater_box_{end_year}.rds.

Usage

load_pwhl_skater_box(
  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 skater box data table within the database

Value

A data frame of class fastRhockey_data with one row per skater per game. Common columns include:

column	type	description
`game_id`	integer	PWHL game id
`team_id`	integer	HockeyTech team id
`player_id`	integer	HockeyTech player id
`first_name`	character	player first name
`last_name`	character	player last name
`jersey_number`	integer	jersey number
`position`	character	position code (C, LW, RW, LD, RD)
`goals`	integer	goals
`assists`	integer	assists
`points`	integer	total points
`penalty_minutes`	integer	PIM
`plus_minus`	integer	plus/minus
`shots`	integer	shots on goal
`faceoff_attempts`	integer	faceoff attempts
`faceoff_wins`	integer	faceoff wins
`time_on_ice`	character	total TOI (`MM:SS`)
`starting`	character	started the game (`0`/`1`)
`player_type`	character	always `"skater"`

Examples

# \donttest{
  try(load_pwhl_skater_box(2024))
#> ─────────────────────────────────────────────────────────── fastRhockey 1.0.0 ──
#> # A tibble: 3,205 × 23
#>    player_id first_name last_name position team_id game_id league toi  
#>    <chr>     <chr>      <chr>     <chr>      <int>   <int> <chr>  <chr>
#>  1 71        Jocelyne   Larocque  LD             6       2 pwhl   26:41
#>  2 133       Lauriane   Rougeau   LD             6       2 pwhl   12:03
#>  3 68        Kali       Flanagan  RD             6       2 pwhl   21:39
#>  4 131       Olivia     Knowles   RD             6       2 pwhl   9:41 
#>  5 101       Alexa      Vasko     C              6       2 pwhl   10:30
#>  6 74        Allie      Munroe    LD             6       2 pwhl   12:31
#>  7 67        Renata     Fast      RD             6       2 pwhl   24:49
#>  8 126       Samantha   Cogan     RW             6       2 pwhl   14:21
#>  9 65        Jesse      Compher   C              6       2 pwhl   14:55
#> 10 72        Rebecca    Leslie    RW             6       2 pwhl   10:48
#> # ℹ 3,195 more rows
#> # ℹ 15 more variables: time_on_ice <dbl>, goals <int>, assists <int>,
#> #   points <int>, shots <int>, hits <int>, blocked_shots <int>,
#> #   penalty_minutes <int>, plus_minus <int>, faceoff_attempts <int>,
#> #   faceoff_wins <int>, faceoff_losses <int>, faceoff_pct <dbl>,
#> #   starting <chr>, player_type <chr>
# }