|
|||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| Database Tools Do you need to take a dump? SQL gurus welcome |
![]() |
|
|
LinkBack | Thread Tools | Search this Thread | Display Modes |
|
|
#1 (permalink) |
|
Hall Of Famer
Join Date: Aug 2003
Posts: 4,460
|
What is this field
I'm playing with a csv dump... I'm looking at players career batting stats (or career pitching stats) there's a field split id. Makes sense that this might be left/right/total for number 1/2/3 but I have a lot of number 21s. What is 21?
Also the position field, what is 0? Is that DH? Thanks. |
|
|
|
|
|
#3 (permalink) |
|
Major Leagues
Join Date: Sep 2005
Location: Chicago, IL
Posts: 329
|
no one is going to help you here, as i havent gotten any myself...
the split_id from what i have gathered is: 1 = total stats for the year 2 = vs L 3 = vs R 21 = postseason stats for league leaders in regards to sub_league_id: 0 = AL 1 = NL we should try to help each other ![]()
__________________
Phil Zuber Beyond the Ivy - Commish, Twins GM Stars and Stripes Baseball League - Cubs GM Bricks and Ivy - Orioles GM Last edited by Zubes : 08-30-2006 at 05:29 PM. |
|
|
|
|
|
#4 (permalink) |
|
Hall Of Famer
Join Date: Aug 2003
Posts: 4,460
|
Thank ya Zubes, I didn't even think of postseason.
I'm an idiot on the 0... every one shows 0 there. There is position 10 in the fielding stats that's obviously the DH. I'm happy to help with anything I can, but I rarely come into this section. Just trying to come up with a HOF stat I can look at right now and ran into those questions. |
|
|
|
|
|
#5 (permalink) |
|
Hall Of Famer
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,396
|
0,1 is not really AL/NL, but instead you have to look up in the sub_leagues file and see what it is.
__________________
Visit www.planetootp.com for my MODS. Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF!
|
|
|
|
|
|
#6 (permalink) |
|
Major Leagues
Join Date: Sep 2005
Location: Chicago, IL
Posts: 329
|
in a basic ML setup though, it is, and i assumed that is what he had.
__________________
Phil Zuber Beyond the Ivy - Commish, Twins GM Stars and Stripes Baseball League - Cubs GM Bricks and Ivy - Orioles GM |
|
|
|
![]() |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|