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:

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)