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)