Difference between revisions of "NHL"

From edegan.com
Jump to navigation Jump to search
imported>WillC
imported>WillC
Line 9: Line 9:
 
For all skaters we need:
 
For all skaters we need:
  
position (F, D)
+
ID (int) - NHLIDDetails.txt
  
salary (int)
+
Current Team (string) - NHLHistoric_Player_summary.txt
  
game type (overtime or no overtime)
+
position (F, D) - NHLHistoric_Player_summary.txt (F vs C vs LW vs RW)??
  
contract start date (MM/DD/YYYY)
+
salary (int) - Capgeek_10_processed-notepad.txt
  
season (YYYY)
+
game type (overtime or no overtime) - NHLPlayer_bios.txt
  
DOB (MM/DD/YYYY)
+
contract start date (MM/DD/YYYY) - Capgeek_10_processed-notepad.txt
  
age (int)
+
season (YYYY) - NHLHistoric_Player_summary.txt
  
goals (int)
+
DOB (MM/DD/YYYY) - NHLIDDetails.txt
  
face-off wins (int)
+
age (int) - calculated from DOB
  
weights (int)
+
goals (int) - NHLHistoric_Player_summary.txt
  
contract type (EL, RFA, UFA, TFP)
+
face-off wins (int) - NHLPlayer_faceOffPercentageAll.txt
  
PPG (int)
+
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 19: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)