Difference between revisions of "NHL"
Jump to navigation
Jump to search
imported>Ed |
imported>Ed |
||
| Line 17: | Line 17: | ||
For all skaters we need: | For all skaters we need: | ||
| − | NHLIDDetails.txt | + | NHLIDDetails.txt (likely a file we generate) |
ID (int) | ID (int) | ||
Playername from NHL, Playername from CapGeek, Playername from GeneralFanager | Playername from NHL, Playername from CapGeek, Playername from GeneralFanager | ||
DOB (transform to ISO8601) | DOB (transform to ISO8601) | ||
| − | + | ||
NHLHistoric_Player_summary.txt & NHLPlayerSummary (check date ranges) | NHLHistoric_Player_summary.txt & NHLPlayerSummary (check date ranges) | ||
Playername | Playername | ||
Revision as of 17:22, 11 February 2016
Old Material
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 (likely a file we generate) 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!
