Difference between revisions of "NHL"
Jump to navigation
Jump to search
imported>WillC |
imported>Ed (play) |
||
| Line 13: | Line 13: | ||
For all skaters we need: | For all skaters we need: | ||
| − | ID (int) | + | NHLIDDetails.txt |
| + | ID (int) | ||
| + | Playername? | ||
| + | DOB (MM/DD/YYYY) | ||
| + | |||
| + | NHLHistoric_Player_summary.txt | ||
| + | Current Team (string) | ||
| + | Position (F, D) (F vs C vs LW vs RW)?? | ||
| + | season (YYYY) | ||
| + | goals (int) | ||
| + | PPG (float)(calculated) | ||
| − | + | Capgeek_10_processed-notepad.txt | |
| + | salary (int) | ||
| + | contract start date (MM/DD/YYYY) | ||
| + | contract type (EL, RFA, UFA, TFP) | ||
| − | + | NHLPlayer_bios.txt | |
| + | game type (overtime or no overtime) | ||
| + | weights (int) | ||
| + | age (int) - calculated from DOB | ||
| − | + | NHLPlayer_faceOffPercentageAll.txt | |
| + | face-off wins (int) | ||
| − | + | In a separate Table: | |
| − | + | Year and CPI (2010 Base Year) | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | In a separate Table: | ||
| − | Year and CPI (2010 Base Year) | ||
Revision as of 17:06, 11 February 2016
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? DOB (MM/DD/YYYY) NHLHistoric_Player_summary.txt Current Team (string) Position (F, D) (F vs C vs LW vs RW)?? season (YYYY) goals (int) PPG (float)(calculated)
Capgeek_10_processed-notepad.txt salary (int) contract start date (MM/DD/YYYY) contract type (EL, RFA, UFA, TFP)
NHLPlayer_bios.txt game type (overtime or no overtime) weights (int) age (int) - calculated from DOB
NHLPlayer_faceOffPercentageAll.txt face-off wins (int)
In a separate Table: Year and CPI (2010 Base Year)
