Loading ...
Sorry, an error occurred while loading the content.

Messages List

603

Weird error in gameday data

On the Marlins game on 6/21/2011 the MLB gameday data includes Chuck Smith at 44 years old. He played his last game in 2001. Anyone have any idea how the
Michael Thain
Jan 30
#603
 
602

Re: Game-specific wOBA calculations

Tom, thanks. I wonder if you could speak to something--Since there are so many ways to correct for ballpark contribution, if I plan to use the "basic" park
dumathecheetah
Jan 18
#602
 
601

Re: Game-specific wOBA calculations

... Giving a cursory look at the link and what you said, it's sounds like you've got everything down. Tom
Tangotiger
Jan 15
#601
 
600

Re: Game-specific wOBA calculations

Tom, thank you for that link to your rationale for how to arrive at the particular weights for the different components of wOBA and for the discussion in
dumathecheetah
Jan 15
#600
 
599

Re: Game-specific wOBA calculations

It all starts with Linear Weights. So, figure out Linear Weights for a particular run environment. I show it here:
Tangotiger
Jan 12
#599
 
598

Game-specific wOBA calculations

I set up a column for "wOBA-against" for each starting pitcher using the season-specific coefficients in GUTS! Now I'm wondering if those coefficients can be
dumathecheetah
Jan 12
#598
 
597

Re: Problems logging into CBS with Python

Thanks Matt but that didn't solve it. Look at this code... *import requests* *myurl = 'http://www.cbssports.com '* *loginurl =
Michael Thain
Dec 28, 2015
#597
 
596

Re: Problems logging into CBS with Python

hey, posted a response to the stackoverflow - http://stackoverflow.com/a/34497584/57665. hope this helps On Mon, Dec 28, 2015 at 10:01 AM, Michael Thain
Matt Dennewitz
Dec 28, 2015
#596
 
595

Problems logging into CBS with Python

Does anyone else use Python/Beautiful Soup to extract data from cbssports? I use it to extract all the fantasy league transactions for my league, so I can put
Michael Thain
Dec 28, 2015
#595
 
594

Re: Create separate variables ERA and WHIP from Retrosheet database

If you’re going to spend significant time using MySQL and do not want to have to remember quite so much syntax, I suggest getting a front end like the free
Dvd Avins
Nov 15, 2015
#594
 
593

Re: Create separate variables ERA and WHIP from Retrosheet database

1) "Update" specifically updates records--"Alter" is how you modify table structure, e.g. add new columns. 2) "Insert" specifically adds a new row--it
Ian Orr
Nov 15, 2015
#593
 
592

Re: Create separate variables ERA and WHIP from Retrosheet database

ALTER TABLE retrosheet.starting_pitcher_game_log ADD COLUMN game_day DATE read up on MySQL basic functions. I’ve found their official site hard to
Brian L Cartwright
Nov 15, 2015
#592
 
591

Re: Create separate variables ERA and WHIP from Retrosheet database

again, day is a reserved keyword as it’s a function get in the habit of ending column names with _cd or _ct or tx etc to avoid these issues I like have a
Brian L Cartwright
Nov 15, 2015
#591
 
590

Re: Create separate variables ERA and WHIP from Retrosheet database

Thanks Brian! I will use your code ASAP. So, I tried to use what seemed intuitively to be the easiest of the tasks, I tried to simply copy the GAME_DAY column
dumathecheetah
Nov 15, 2015
#590
 
589

Re: Create separate variables ERA and WHIP from Retrosheet database

I reckon that YEAR is a MySQL reserved function name. Retrosheet’s games table already has a YEAR_ID column, along with GAME_DT. However, I don’t like the
Brian L Cartwright
Nov 14, 2015
#589
 
View First Topic Go to View Last Topic
Loading 1 - 15 of total 603 messages