Difference between revisions of "NHL"
Jump to navigation
Jump to search
imported>WillC |
imported>WillC |
||
| Line 22: | Line 22: | ||
DOB (transform to ISO8601) | DOB (transform to ISO8601) | ||
| − | NHLHistoric_Player_summary.txt & | + | NHLHistoric_Player_summary.txt & NHLPlayer_summary.txt (historic data set includes NHL Player summary except for two games of 2013-2014 season) |
Playername | Playername | ||
Current Team (string) | Current Team (string) | ||
| Line 28: | Line 28: | ||
season (YYYY) | season (YYYY) | ||
goals (int) | goals (int) | ||
| − | + | TOI (float) | |
| + | |||
| + | NHLPlayer_points.txt | ||
| + | Playername | ||
| + | DOB | ||
| + | PPG (float) | ||
NHLPlayer_bios.txt | NHLPlayer_bios.txt | ||
playername | playername | ||
| − | dob | + | dob |
game type (overtime or no overtime) | game type (overtime or no overtime) | ||
weights (int) | weights (int) | ||
| + | height (int) | ||
age (int) - calculated from DOB | age (int) - calculated from DOB | ||
NHLPlayer_faceOffPercentageAll.txt | NHLPlayer_faceOffPercentageAll.txt | ||
playername | playername | ||
| + | DOB?? | ||
face-off wins (int) | face-off wins (int) | ||
| Line 47: | Line 54: | ||
contract start date (MM/DD/YYYY) | contract start date (MM/DD/YYYY) | ||
contract type (EL, RFA, UFA, TFP) | contract type (EL, RFA, UFA, TFP) | ||
| − | |||
In a separate Table: | In a separate Table: | ||
Revision as of 18:36, 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 & NHLPlayer_summary.txt (historic data set includes NHL Player summary except for two games of 2013-2014 season) Playername Current Team (string) Position (F, D) season (YYYY) goals (int) TOI (float)
NHLPlayer_points.txt Playername DOB PPG (float)
NHLPlayer_bios.txt playername dob game type (overtime or no overtime) weights (int) height (int) age (int) - calculated from DOB
NHLPlayer_faceOffPercentageAll.txt playername DOB?? 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!
