Streaky The Supercat

by elcroata on May 6, 2010 12:16 PM PDT

1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75.

Tweet Comment 20 comments | 29 recs |

Do you like this story?

Comments

Wow.

Thorough, awesome, and entertaining too. Your third Excel bar graph (with the identical post hot/post cold bars) rocks.

How did you possibly sort through that much data? I haven’t yet cracked open the Retrosheet vault yet, though I’d like to be able to.

The selfish, they're all standing in line, faithing and hoping to buy themselves time.
Me, I figure as each breath goes by, I only own my mind.

by danmerqury on May 6, 2010 12:44 PM PDT reply actions

Thanks

I ran the scripts over the retrosheet data and stored results in a DB and then made SQL queries on it. I only involved Excel in the end, to get the charts and formatted tables.

For now, my program can only “understand” the hitting part. When I catch some more time, I will expand it to include base-running, counts, match-ups and similar. I will probably have to restructure the DB somewhat to allow for more complex queries.

by elcroata on May 6, 2010 12:57 PM PDT up reply actions

I've created the Retrosheet DB but haven't done any queries with it yet

Hopefully, I can get to it over this summer. Maybe I could even create a tutorial with it. But it’s so much work. And I can tell the amount of time that went into this fanpost. Thank you so much and a million recs.

"Loyal? I'm the most loyal player money can buy." - Don Sutton

by vignette17 on May 6, 2010 2:27 PM PDT up reply actions

There is a DB that can be downloaded from their site, right?

Probably should have looked at that, too. But being able to “understand” and parse play by play data and create my own DB accordingly seemed very inviting to me. As I have rather clear ideas what I am looking for, I can extract exactly the data I need.

Further down the road I would love to link it with something like Pitch F/X data. There are so many interesting researches that can be done and so little time :) Perhaps some of AN people could get together on certain projects.

by elcroata on May 7, 2010 4:33 AM PDT up reply actions

That would be awesome, actually.

We have so much expertise in so many different fields.

The selfish, they're all standing in line, faithing and hoping to buy themselves time.
Me, I figure as each breath goes by, I only own my mind.

by danmerqury on May 7, 2010 10:48 AM PDT up reply actions

I followed a Colin Wyers article about downloading Retrosheet

As of now I have the PitchFx, Retrosheet, and Baseball Almanac databases in MySQL. I went through a series of FPs at BtBS about the PitchFx database. I’ve made a few queries with it. I’ve done a lot with the BA one (I did a FP here with it a while back). Retrosheet I’m yet to touch.

I also bought the book Baseball Hacks by Joe Adler and I’ve heard it’s really a great resource. I tried a bit of it but it’s a ton of material.

"Loyal? I'm the most loyal player money can buy." - Don Sutton

by vignette17 on May 9, 2010 7:41 PM PDT up reply actions

Also, you got your wife to draw Johnny Five holding a four-leaf clover hitting dingers over the fence

but you couldn’t produce the promised cat with superpowers? For shame.

The selfish, they're all standing in line, faithing and hoping to buy themselves time.
Me, I figure as each breath goes by, I only own my mind.

by danmerqury on May 6, 2010 12:50 PM PDT reply actions

I wanted to,

but being illustrator herself, she is pretty adamant about not copying anybody’s work. Something with moral values, I didn’t quite get it…

by elcroata on May 6, 2010 12:53 PM PDT up reply actions

why not post this then?

"The ego, the super-ego, and the Ed" - danmerqury

by Future Ed on May 6, 2010 1:02 PM PDT up reply actions

Yeah, perhaps I should start having it in my signature

One of the ways I keep getting the drawings is by telling her that one never knows where potential customers are :)

by elcroata on May 7, 2010 4:21 AM PDT up reply actions

This looks great

but have work to do, I will check it out later

"The ego, the super-ego, and the Ed" - danmerqury

by Future Ed on May 6, 2010 1:05 PM PDT reply actions

I'm creating a few more accounts so I can rec this again.

by LoneStranger on May 6, 2010 1:23 PM PDT reply actions

You should have done it last time you said that.

Then the post would be green already.

"We support your economy. We make your food and tend your fields. All we want are the same rights and responsiblities as you. Please... Vote YES on Proposition 801- Equal rights for sock puppets!"

by Gaijin_Suketto on May 6, 2010 2:55 PM PDT up reply actions

Awesome work

Particularly the bit about teammates hitting during a player’s hot streak, which is not data I’ve seen before (though the result is exactly what I’d have anticipated).

Arthur Dent: You know, it's at times like this, when I'm trapped in a Vogon airlock with a man from Betelgeuse and about to die of asphyxiation in deep space, that I really wish I'd listened to what my mother told me when I was young.
Ford Prefect: Why, what did she tell you?
Arthur Dent: I don't know, I didn't listen!

by PaulThomas on May 6, 2010 2:16 PM PDT reply actions