Re: [baseball-databank] zeros better than NULLs in pre-classification SF, SH columns?
They are zero because those players had zero AB's and therefore had to have zero SF. In cases where AB > 0 we don't know how many SF they had.
sean
On Mon, Apr 21, 2008 at 11:42 AM, mmc_cann <mmc_cann@...> wrote:
Hi,
Working mostly with MySQL type baseball-databank files, I haven't been
able to figure why sometimes SF's are zero and sometimes NULL in the
pre-1954 entries of the Batting table of the database.
Was about that time, 1954, that scoring rules changed? Sacrifice
Flys, and Sacrifice Hits, SF and SH, (since '54,) are excepted from
At-Bats, AB's... Prior they were included... Trans boundary counts
require different handling... I think it might be better to make the
"no entry default" a "0" i.e. a "zero" rather than a "NULL."
Hi, Working mostly with MySQL type baseball-databank files, I haven't been able to figure why sometimes SF's are zero and sometimes NULL in the pre-1954...
I looked through these. The majority of the cases are times where the player's AB=0, so they had no SF's. The other 25 cases were cases where a player was...
... The basic rule is that if something is unknown or a measure wasn't tracked at that time, then you should see NULL. If something simply didn't happen but...
Tangotiger
tom@...
Apr 21, 2008 6:35 pm
Hi, Working mostly with MySQL type baseball-databank files, I haven't been able to figure why sometimes SF's are zero and sometimes NULL in the pre-1954...
They are zero because those players had zero AB's and therefore had to have zero SF. In cases where AB > 0 we don't know how many SF they had. sean ... -- ...
Sean, excuse me but SF's aren't counted as AB's - at least by today's standards. Don Parke... ... From: Sean Forman To: baseball-databank@yahoogroups.com Sent:...
Sean, never mind - I didn't read all your mail correctly, Sorry, don... ... From: Sean Forman To: baseball-databank@yahoogroups.com Sent: 5/2/2008 7:30:16 AM ...
Having problems with message search?
Offline 
Send Email