Sons of Sam Horn: Back-to-back bunts for hits - Sons of Sam Horn

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • This topic is locked

Back-to-back bunts for hits

#1 User is offline   OttoC 

  • Mr. Excel
  • Group: SoSH Unsubscribed Member
  • Posts: 3,899
  • Joined: 02-December 03

Posted 22 April 2007 - 05:40 AM

Going back though the 1967 season using Retrosheet data, I only found six instances of Red Sox batters having back-to-back bunt hits before last night's occurrence.
_____________________________________________________________________
Not everything that counts is counted; not everything that is counted is worth counting.
---Albert Einstein

#2 User is offline   reggiecleveland 

  • SoSH Member
  • Group: SoSH Lifetime Supporter
  • Posts: 6,406
  • Joined: 05-March 04

Posted 22 April 2007 - 10:11 AM

Have two players ever bunted for consecutive hits against two different pitchers?
I was wrong, spectacularly wrong about Lugo.
Eric Vann

No shit Sherlock.
Ma Browndog

#3 User is offline   OttoC 

  • Mr. Excel
  • Group: SoSH Unsubscribed Member
  • Posts: 3,899
  • Joined: 02-December 03

Posted 22 April 2007 - 10:24 AM

View Postreggiecleveland, on Apr 22 2007, 11:11 AM, said:

Have two players ever bunted for consecutive hits against two different pitchers?
I don't know, but I'd be surprised if it had not happened.
_____________________________________________________________________
Not everything that counts is counted; not everything that is counted is worth counting.
---Albert Einstein

#4 User is offline   reggiecleveland 

  • SoSH Member
  • Group: SoSH Lifetime Supporter
  • Posts: 6,406
  • Joined: 05-March 04

Posted 22 April 2007 - 10:58 AM

View PostOttoC, on Apr 22 2007, 09:24 AM, said:

I don't know, but I'd be surprised if it had not happened.


Did you manually go throught the score sheets to find the Red Sox bunt hits or is there a way to search.
I was wrong, spectacularly wrong about Lugo.
Eric Vann

No shit Sherlock.
Ma Browndog

#5 User is offline   DLew On Roids 

  • King of the one-liner
  • Group: SoSH Lifetime
  • Posts: 7,877
  • Joined: 30-August 01

Posted 22 April 2007 - 11:06 AM

I don't know how Otto did it, but if you download play-by-play data into a spreadsheet, it's pretty easy to write an Excel macro that will scroll down the list of plays until it finds two consecutive bunt singles.
RADIATION WILL TASTE LIKE VANILLA ICE CREAM

I think you have me confused with Corsi which makes you a &*#@ing idiot. - SeanBerry

#6 User is offline   BenRS 

  • Group: NEW Unsubscribed User
  • Posts: 228
  • Joined: 26-January 06

Posted 22 April 2007 - 11:35 AM

Reggie: He probably wrote a program that did it (fortran?).

edit: or not

This post has been edited by BenRS: 22 April 2007 - 02:07 PM


#7 User is offline   OttoC 

  • Mr. Excel
  • Group: SoSH Unsubscribed Member
  • Posts: 3,899
  • Joined: 02-December 03

Posted 22 April 2007 - 02:04 PM

I have Retrosheet event files (play-by-play) in an Access database and I simply did a query for Boston batting at home and on the road for HitValue>0 and BuntFlag="T". Then, I copied the result of that query to Excel, sorted it by date, game, inning and event number. That allowed me use a formula like if a2=a1 then t else "". Since there were so few instances, I visually inspected each t and the record immediately preceding to see if the inning was the same and the event numbers were approximately proximate. There were a few more bells and whistles, but that is the gist of what I did.

Note: I currenty only have Red Sox games going back through 1967 and all teams from 2000 through 2006. I haven't gotten around to building a database with all Retrosheet's data because of the sheer amount of data. For example, the database for all teams from 2000 through 2006 has 1,355,268 records, each with 97 fields.
_____________________________________________________________________
Not everything that counts is counted; not everything that is counted is worth counting.
---Albert Einstein

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • This topic is locked

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users