Difference between revisions of "NHL"
imported>WillC |
imported>WillC |
||
Line 9: | Line 9: | ||
For all skaters we need: | For all skaters we need: | ||
− | + | ID (int) - NHLIDDetails.txt | |
− | + | Current Team (string) - NHLHistoric_Player_summary.txt | |
− | + | position (F, D) - NHLHistoric_Player_summary.txt (F vs C vs LW vs RW)?? | |
− | + | salary (int) - Capgeek_10_processed-notepad.txt | |
− | + | game type (overtime or no overtime) - NHLPlayer_bios.txt | |
− | + | contract start date (MM/DD/YYYY) - Capgeek_10_processed-notepad.txt | |
− | + | season (YYYY) - NHLHistoric_Player_summary.txt | |
− | + | DOB (MM/DD/YYYY) - NHLIDDetails.txt | |
− | + | age (int) - calculated from DOB | |
− | + | goals (int) - NHLHistoric_Player_summary.txt | |
− | + | face-off wins (int) - NHLPlayer_faceOffPercentageAll.txt | |
− | PPG ( | + | weights (int) - NHLPlayer_bios.txt |
+ | |||
+ | contract type (EL, RFA, UFA, TFP) - Capgeek_10_processed-notepad.txt | ||
+ | |||
+ | PPG (float) - NHLHistoric_Player_summary.txt (calculated) | ||
+ | |||
+ | In a separate Table: | ||
+ | Year and CPI (2010 Base Year) |
Revision as of 18:26, 10 February 2016
Downloading Postgresql on Mac
instructions to follow
Variables
List of necessary variables and where to find them in the dropbox.
For all skaters we need:
ID (int) - NHLIDDetails.txt
Current Team (string) - NHLHistoric_Player_summary.txt
position (F, D) - NHLHistoric_Player_summary.txt (F vs C vs LW vs RW)??
salary (int) - Capgeek_10_processed-notepad.txt
game type (overtime or no overtime) - NHLPlayer_bios.txt
contract start date (MM/DD/YYYY) - Capgeek_10_processed-notepad.txt
season (YYYY) - NHLHistoric_Player_summary.txt
DOB (MM/DD/YYYY) - NHLIDDetails.txt
age (int) - calculated from DOB
goals (int) - NHLHistoric_Player_summary.txt
face-off wins (int) - NHLPlayer_faceOffPercentageAll.txt
weights (int) - NHLPlayer_bios.txt
contract type (EL, RFA, UFA, TFP) - Capgeek_10_processed-notepad.txt
PPG (float) - NHLHistoric_Player_summary.txt (calculated)
In a separate Table: Year and CPI (2010 Base Year)