NHL

Downloading Postgresql on Mac

Download package from:

http://www.enterprisedb.com/products-services-training/pgdownload#osx

Follow instructions given on the website. Macs already come with Perl, using the stackbuilder application which was also downloaded through the same link, download the PL/Perl package.

Variables

List of necessary variables and where to find them in the dropbox.

For all skaters we need:

NHLIDDetails.txt
 ID (int) 
 Playername from NHL, Playername from CapGeek, Playername from GeneralFanager
 DOB (transform to ISO8601)

NHLHistoric_Player_summary.txt & NHLPlayerSummary (check date ranges)
 Playername
 Current Team (string)
 Position (F, D) (F vs C vs LW vs RW)?? 
 season (YYYY) 
 goals (int) 
 PPG (float)(calculated)

NHLPlayer_bios.txt
 playername
 dob
 game type (overtime or no overtime)
 weights (int)
 age (int) - calculated from DOB

NHLPlayer_faceOffPercentageAll.txt
 playername
 face-off wins (int) 

Capgeek_10_processed-notepad.txt
 playername
 dob
 salary (int)
 contract start date (MM/DD/YYYY)
 contract type (EL, RFA, UFA, TFP)

In a separate Table:
 Year and CPI (2010 Base Year)

Next Tasks

Spec General Fanager!