albertlyu / nflrushdb Goto Github PK

• Game
• Play get positionals
• Play get positions, play IDs
• Play get distance between players
• Positional set adjusted fields

Create a util to handle different team abbreviations across different fields. FieldPosition and PossessionTeam have the same team abbreviations, while VisitorTeamAbbr and HomeTeamAbbr have different team abbreviations from the first two.

Four teams have different abbreviations across the train.csv columns.

FieldPosition and PossessionTeam use:

ARZ, BLT, CLV, HST

VisitorTeamAbbr and HomeTeamAbbr use:

ARI, BAL, CLE, HOU

Source: https://twitter.com/LeeSharpeNFL/status/1182306903558279169

This is mostly to normalize the player fields, so as to remove them from the positional fields, such as DisplayName, JerseyNumber, PlayerHeight, PlayerWeight, etc. Position is decidedly a positional-level field (presumably). May require additional exploration, because JerseyNumber could change from game to game as well.

Noted by Michael Lopez:

2. The field coordinates are fixed at each NFL stadia. Often, the first step in any analysis of tracking data is to ensure offensive teams are moving in the same direction. This requires flipping roughly half of a game’s offensive plays from one direction to the other (use the PlayDirection variable, while creating new x and y coordinates, as well as new player orientations and directions. Additionally, standardizing by the play’s line-of-scrimmage may be warranted (particularly when thinking about player space).

Source: https://www.kaggle.com/c/nfl-big-data-bowl-2020/discussion/111918

To store game-level metrics and plays for that game

• snap to handoff time
• number of defenders in direction of running back angle

etc.

After #2, use the PlayDirection variable to change the orientation of the player.

Intraplayer:

• distance from the line of scrimmage
• horizontal distance from the line of scrimmage (in the X direction, along the long axis of the field)

Interplayer:

• distance between each player (particularly the running back)
• closest defender (for each offensive player)