Difference between revisions of "NHL"
Jump to navigation
Jump to search
imported>Ed (play) |
imported>Ed |
||
| Line 15: | Line 15: | ||
NHLIDDetails.txt | NHLIDDetails.txt | ||
ID (int) | ID (int) | ||
| − | Playername | + | Playername from NHL, Playername from CapGeek, Playername from GeneralFanager |
| − | DOB ( | + | DOB (transform to ISO8601) |
| − | NHLHistoric_Player_summary.txt | + | NHLHistoric_Player_summary.txt & NHLPlayerSummary (check date ranges) |
| + | Playername | ||
Current Team (string) | Current Team (string) | ||
Position (F, D) (F vs C vs LW vs RW)?? | Position (F, D) (F vs C vs LW vs RW)?? | ||
| Line 24: | Line 25: | ||
goals (int) | goals (int) | ||
PPG (float)(calculated) | PPG (float)(calculated) | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
NHLPlayer_bios.txt | NHLPlayer_bios.txt | ||
| + | playername | ||
| + | dob | ||
game type (overtime or no overtime) | game type (overtime or no overtime) | ||
weights (int) | weights (int) | ||
| Line 36: | Line 34: | ||
NHLPlayer_faceOffPercentageAll.txt | NHLPlayer_faceOffPercentageAll.txt | ||
| + | playername | ||
face-off wins (int) | 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: | In a separate Table: | ||
| − | + | Year and CPI (2010 Base Year) | |
| + | |||
| + | ==Next Tasks== | ||
| + | |||
| + | Spec General Fanager! | ||
Revision as of 16:15, 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 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!
