Loading ...
Sorry, an error occurred while loading the content.

4498Re: Batting tbl - g_batting missing

Expand Messages
  • daddio1949too
    Mar 30 7:47 AM

      In the Lahman database (as of Feb. 14, 2014) this anomaly for the field G_batting still exists.  In 2012 the field G_batting shows missing values for numerous players that should have values.  The missing values appear only in 2012 and not for other years.



      How to identify these  rows in batting?  

      I created a SQLite database from the CSV file, but the values also show in the Access file.  A list of these players can be obtained using the SQL query:

       

      SELECT playerID, teamID, yearID, G, G_batting, AB  from batting WHERE yearID=2012 and G_batting='' and (AB>0 AND AB <>'');

      Here are the first 7 instances.

      playerID

      teamID

      yearID

      G

      G_batting

      stint

      AB

      abadfe01

      HOU

      2012

      37

      1

      7

      abreubo01

      LAA

      2012

      8

      1

      24

      abreubo01

      LAN

      2012

      92

      2

      195

      abreuto01

      KCA

      2012

      22

      1

      70

      ackledu01

      SEA

      2012

      153

      1

      607

      adamsma01

      SLN

      2012

      27

      1

      86

      adcocna01

      KCA

      2012

      12

      1

      1



    • Show all 2 messages in this topic