Added various xg related features (as well as others like goals_per60) to f_player_season to close out issue59 and the xg v1.0.0 milestone
Since we have introduced 2022-23 season recently, there was a bug that required a fix. Specifically, there was a preseason game (game_id = 2022010048) that showed that the canucks and kraken both had a shot in the first period labeled as a "home player", when it was only the canucks that were truly home... likely a preseason junk data thing, but to correct it we added a filter to to the rink_shooting query to only look at shots that come from the home team as decided by the schedule dataset
Checks
[ ] All models ran successfully
[ ] All tests passed
[ ] Changes to models are reflected in the schema.yml
Overview
f_player_season
to close out issue59 and the xg v1.0.0 milestonegame_id = 2022010048
) that showed that the canucks and kraken both had a shot in the first period labeled as a "home player", when it was only the canucks that were truly home... likely a preseason junk data thing, but to correct it we added a filter to to therink_shooting
query to only look at shots that come from the home team as decided by the schedule datasetChecks