edX Sabermetrics 101 Discussion

trotsplits · May 29, 2014

I just registered. Auditing.

StupendousMan · May 29, 2014

Moi aussi.

Laser Show · May 29, 2014

I registered to audit.

StupendousMan · May 29, 2014

One of the first assignments involves playing with SQL queries into a database. The version of the MLB stats database we're using can be downloaded (for free) from the course site, or from Sean Lahman's site directly:

http://www.seanlahman.com/baseball-archive/statistics/

Learning about this has already paid back the cost of registering to audit ... heh.

RIFan · May 29, 2014

I'm in.

CallYaz · May 29, 2014

Registered to Audit and looking forward to it....

Ferm Sheller · May 29, 2014

absintheofmalaise said:
I was planning on going over the coursework this weekend and I wanted to see if others were planning on doing the same. It's tough for me during the week and I'd guess it is probably the same for many of us.

I'm probably doing the same because, as you said, it's too hard to find time during the week. One of the nice things about on line courses are that you participate at times that are good for you.

Also, we can see how it goes, but we may wish to break this out into sub-topics, especially as the weeks go by. Just a thought.

weeba · May 29, 2014

I registered, but I have no idea when I'll get to it

Scott Cooper's Grand Slam · May 29, 2014

absintheofmalaise said:
I was planning on going over the coursework this weekend and I wanted to see if others were planning on doing the same. It's tough for me during the week and I'd guess it is probably the same for many of us.

Ferm Sheller said:
I'm probably doing the same because, as you said, it's too hard to find time during the week. One of the nice things about on line courses are that you participate at times that are good for you.

Also, we can see how it goes, but we may wish to break this out into sub-topics, especially as the weeks go by. Just a thought.

My laptop's been at the Genius Bar all week (broken microphone housing on a 2012 MacBook Air), but I just got the call to come pick it up. I'll attempt to get everything loaded and start working this weekend.

richgedman'sghost · May 29, 2014

absintheofmalaise said:
Thought I'd go ahead and start this over here for the course, which started today.
Here are the people who indicated they have signed up for the course in the thread on the main board. Please let me know if I missed anyone.
me
Supermanny
Ferm Sheller + son
JGray38
Just a bit outside
rundugrun
dbn
wibi
Stitch01
dylanmarsh
JMOH
gtg807y
terrisus
uncannymanny
norm from cheers
mascho
PaulinMyrBch + son
adam42381
Rice4HOF
inJacobyWetrust
metaprosthesis
GeorgeThomas
OttoC
cjdmadcow
Don Bradman
fuzzy_one + son
HurstSoGood
brs3
MyDaughterLovesTomGordon
tbrown_01923
Scott Cooper's Grand Slam
MuzzyField
mpx42
trotsplits
StupendousMan
Laser Show
RIFan
CallYaz
weeba

I registered for the course and will attempt to audit it. Hopefully the math does not overwhelm me.

pokey_reese · May 29, 2014

You missed me, pokey_reese.

Comfortably Lomb · May 29, 2014

I'm auditing it.

TheGoldenGreek33 · May 29, 2014

Auditing.

hikeeba · May 29, 2014

Signed up to audit. After going through this week's stuff, what else is there to do?

SoxLegacy · May 29, 2014

I signed up when it was announced here and am looking forward to it. Like many of you mentioned, I will be looking over the course materials this weekend.

NoLastCall125 · May 30, 2014

I also signed up for it when it was announced. I'm going to try to hit the materials on Sunday.

MuzzyField · Jun 2, 2014

I'm up to the history segment in module 1. So far, very interesting. I did waste some time trying to use mySQL directly on my mac with the downloadable Lahman database. For now, I'll just stay in the sandbox and revisit this when I'm more comfortable with the formatting.

Laser Show · Jun 4, 2014

Also up to the history segment (though I skipped ahead and watched the Keri and Cameron interviews). Really cool stuff so far, I see myself wasting a lot of time in the sandbox.

PAB1353 · Jun 4, 2014

auditing

ivanvamp · Jun 4, 2014

For the record, I am auditing it as well.

Zoidberg · Jun 4, 2014

also FTR, I'm in this thing. Just starting to get through the first material.

NWsoxophile · Jun 4, 2014

auditing.

BusRaker · Jun 5, 2014

I'm so happy I can finally put my 15 years of SQL programming to a good use!

hikeeba · Jun 15, 2014

Up to Week 3 Problem Set 5-2 and they start using w.yearID and then a w at the end of a from. Someone asked the question of what was going on and the response was it was an 'alias for a sub-select' that made things clearer.
Did I miss that somewhere? It's still not clear.

wibi · Jun 17, 2014

hikeeba said:
Up to Week 3 Problem Set 5-2 and they start using w.yearID and then a w at the end of a from. Someone asked the question of what was going on and the response was it was an 'alias for a sub-select' that made things clearer.
Did I miss that somewhere? It's still not clear.

It wasnt explained in the video but essentially Andy is naming his table created by the nested select w

If he had named it Fenway {ie ") Fenway" or ") AS Fenway" }then your would be calling SELECT Fenway.yearID at the start

wibi · Jun 17, 2014

Im running into an SQL query on the same problem set that I could use some help on.

I can create what he wants with AVG, MAX, MIN and STD but I cant get it to group by the STD.

My code and the rest of my comment is spoilered

EDIT: Got it solved ... Solution is in the spoiler text too

This returns the proper columns but sorted by year. I cant get it to sort by the STD as the problem requests and if I move the STD calculations inside the nested SELECT then I end up with a single line turn that is the yearID. Any suggestions as to what I'm doing wrong?

SELECT w.yearID,
AVG(w.Error) AS AverageError,
MAX(w.Error) AS MAXError,
MIN(w.Error) AS MINError,
STD(w.Error) AS STDError
FROM (
      SELECT teamID, yearID, W,
      G*(R^2)/(R^2+ RA^2) AS predictedW,
      (G*(R^2)/(R^2+ RA^2)-W) AS Error
      FROM Teams
      WHERE yearID >= 1955
      ) w
GROUP BY w.yearID

Add an
ORDER BY STDError DESC
at the end of the query

hikeeba · Jun 18, 2014

Thanks wibi. I did see it in the following videos, just wish it had been covered beforehand. Times like that I miss a textbook.

RIFan · Jun 2, 2015

Thought I'd bump this to let everyone know a new class is starting up July 7th.
https://www.edx.org/course/sabermetrics-101-introduction-baseball-bux-sabr101x-0

Rwillh11 · Jun 2, 2015

registered; looking forward to it/hoping I have enough time to do it.

edX Sabermetrics 101 Discussion

too many flowers

Member

Member

Member

too many flowers

Member

Member

Member

Member

too many flowers

Member

Member

too many flowers

Well-Known Member

Member

Koko the Monkey

Member

Member

New Member

Member

too many flowers

Well-Known Member

Member

Member

captain obvious

Member

Member

Member

too many flowers

Member

Member

Member

Member

Member

Member