... Thanks guys. I'm not too great with SQL yet but this at least points me in the right direction. So basically create another table with run value...
407
Brian L. Cartwright
brianlcartwr...
May 2, 2010 6:37 am
They added names and season stats to boxscore.xml on Friday, at all levels. I put in avg & era as decimals, so far I've downloaded a couple days worth of MLB...
408
shanemeredith
May 12, 2010 2:57 pm
Has anyone written a program that can parse the event field of the play record to produce an english description of the play? If so, would you be willing to...
409
Theodore Turocy
arb1ter
May 25, 2010 11:13 am
Hello, We are pleased to announce the formation of BaseballID-WG, a working group organized around these objectives: (1) To define and make available a...
410
weskelton@...
weskelton
Dec 25, 2010 11:51 am
http://craigj.thesuperbchtristmas.in...
411
William Skelton
weskelton
Dec 25, 2010 5:41 pm
I've become aware that a number of individuals on my contact list received 1 or more emails from me with various 1 word titles starting with O or P. They ...
412
tangotiger
Feb 26, 2011 6:04 am
(Cross-posted to two groups.) FYI. Below is for 1999. Notice how virtually all the extra innings is missing the pitch sequences. Seems odd that the data...
413
nsmiceli
Mar 3, 2011 3:58 pm
** Please excuse cross posting here from RetroList. If this is an old question, please excuse my asking, but has anyone tried using imputation to replace...
414
Richard Bain
rfbain
Dec 13, 2011 10:34 pm
Follow these steps to load Retrosheet box score data into a database. I've done this for SQL Server Express and believe it should work for MySQL. The box...
415
tangotiger
Dec 14, 2011 5:39 pm
Richard, Your attachments did not come through for me. You may find it more helpful to login directly to Yahoo Groups, and upload files through their "Files"...
416
willkoky
Dec 15, 2011 3:47 am
Richard, Can you elaborate a little on the different parts of these command line options? I take it one is supposed to run the .exe twice, once with each...
417
rfbain
Dec 15, 2011 5:40 am
As I'm sure you have guessed, I'm new to the procedures of Yahoo groups and the culture of this group in particular. I read elsewhere that the way to upload...
418
rfbain
Dec 15, 2011 5:57 am
No, the program only needs to be run once. The command line argument represents the syntax required by the database for its version of the Bulk Load command....
419
KJOK
kjokbaseball
Jan 12, 2012 6:10 am
If anyone has already loaded the Retrosheet 2011 event files AND the latest boxscore files to their database, and is willing to run a few simple queries by...
420
Kyle W. Willkomm
willkoky
Jan 16, 2012 4:01 am
This post is to announce version 5.0 of BBOS. 5.0 adds Retrosheet support thanks almost entirely to the Python scripts written by Wells Oliver. If you wish...
421
KJOK
kjokbaseball
Jan 26, 2012 3:27 am
OK, then does anyone have instructions for loading both event and boxscore files to either MySQL or MS Access? THANKS, Kevin...
422
Kyle W. Willkomm
willkoky
Jan 26, 2012 3:53 am
Someone posted this loader for the box scores a few months ago but I have not successfully run it against MySQL yet. I believe it will work I just have not...
423
tangotiger
Jan 26, 2012 4:06 am
Kevin, Which data from the Boxscore files do you need, that wouldn't exist in the event or gameloges files? Tom...
424
KJOK
kjokbaseball
Jan 26, 2012 6:12 pm
For games not in the Event files (basically pre-1950), looking for summary at team/Park level for each batting component for both the team and it's opponents,...
425
tangotiger
Jan 26, 2012 6:20 pm
Ah, ok. When I first read your note, I seem to remember you asking for Event AND Boxscore files for 2011. That's why I didn't reply, because I never load the...
426
tangotiger
Jan 26, 2012 6:23 pm
Ah, ok. When I first read your note, I seem to remember you asking for Event AND Boxscore files for 2011. That's why I didn't reply, because I never load the...
427
Nicholas Miceli
nsmiceli
Apr 5, 2012 6:20 pm
Dear Group Members, Please excuse the cross-posting. A while back (2009) I wrote an article on baseball that was published in the Journal of Quantitative...
428
Nicholas Miceli
nsmiceli
Apr 6, 2012 7:20 pm
Dear Members, Thank you to all who responded to my request for help for readers. As I get into the planning process for research, I'm sure that list members ...
429
N. S. Miceli, Ph.D.
nsmiceli
Apr 19, 2012 2:52 pm
Dear group members, Please excuse the cross posting. When examining more than one season's worth of data, do you think that there is a need to examine the data...
430
tangotiger
Apr 19, 2012 3:48 pm
Can you elaborate by what you mean when you say "time series"? Do you intend to mean to weight recent data more? To "seasonally adjust" data? To... ?? I...
431
nsmiceli
Apr 19, 2012 6:14 pm
Tangotiger, Thank you for your response, and your suggestion. I'll take it seriously. To me, time series means a set of data where you have a series of...
432
tangotiger
Apr 19, 2012 6:22 pm
If I understand you correctly, then would weight=.999 ^ daysAgo be an example of autocorrelation? The further back in time you go, the less relevant the data...
433
nsmiceli
Apr 20, 2012 8:42 pm
Tom, This is exactly right. The software written to handle time series data takes that autocorrelation into account. I'd suspect that performance is strongly...
434
Theodore Turocy
arb1ter
Apr 20, 2012 8:49 pm
... *blinks* It's trivial that player performance is massively autocorrelated over time, whether at the annual, monthly, daily, per-PA levels; after all, the...
435
tangotiger
Apr 20, 2012 8:52 pm
Then to answer your original question: ALL forecasting systems use a scheme like the one below, to some extent or other. Therefore, when you say that you...
