Career Fielding Averages file for Lahman DB 5.0 now available. - Page 2

Ankit · 03-13-2003, 06:29 AM

Quote:

Originally posted by hamonrye
i'm using the evaluation version of winzip wizard. after i unzipped the ankit download, i now have a careeravgfielding file, a fielding file and a fieldingof file within my stats folder. i haven't tried it yet to see if it works, but it doesn't appear to have overwritten anything, just created a new listing within the folder. does the file need to have the same name as what it's overwriting, or does it recognize the data? i don't know much about this kind of thing, as you may be able to tell.

i would appreciate any feedback as to how exactly this is supposed to be done. i would love to use the database ankit created to get accurate historical fielding.

Rename your fielding.csv file to "original fielding.csv". Then rename the careeravgfielding.csv file to "fielding.csv".

Ankit

Dargone · 03-13-2003, 07:46 AM

Ankit, how goes your work on the revised database? Do you have a tenative ETA yet? I anxiously await the finished database. Thanks for taking the time to create it

hamonrye · 03-13-2003, 11:46 AM

ankit-thanks a lot for your help. i really appreciate it.

Ankit · 03-13-2003, 05:40 PM

Quote:

Originally posted by Dargone
Ankit, how goes your work on the revised database? Do you have a tenative ETA yet? I anxiously await the finished database. Thanks for taking the time to create it

Sorry Dargone, but no ETA yet. Will let you and others know as soon as I know...

rwd59 · 03-18-2003, 10:27 PM

Ankit,

While importing 1974, I noticed Lee May and Milt May had improper positions and fielding ratings. I checked the DB and they are not in it. I also noticed that Mike Easler imported for them with an assigned position and FAvg of .930 on that team. It is possible that he just pinch hit that season as he has no DB info for 1974. I have noticed a few others that are assigned FAvg's and positions. Do you think we could go into the DB and find people who did not have a fielding position for a year and give them the career avg for that season? Is there any realatively easy way to do that?

Ankit · 03-18-2003, 11:38 PM

Quote:

Originally posted by rwd59
Ankit,

While importing 1974, I noticed Lee May and Milt May had improper positions and fielding ratings. I checked the DB and they are not in it. I also noticed that Mike Easler imported for them with an assigned position and FAvg of .930 on that team. It is possible that he just pinch hit that season as he has no DB info for 1974. I have noticed a few others that are assigned FAvg's and positions. Do you think we could go into the DB and find people who did not have a fielding position for a year and give them the career avg for that season? Is there any realatively easy way to do that?

I have checked what you are saying and I agree. Milt May and Lee May are not in the Fielding file and I will work on it to fix it. Expect an update soon. As for Mike Easler, he did not have any fielding entries for 1974 or 1975 and that's the reason why he imports with made up positions and FAvgs. I don't think there is a an easy way to find all players affected by this and fix it though someone here might know of a way...

woody5254 · 03-19-2003, 09:18 AM

Great work Ankit. This is a great step forward from the original. Great for all us historical simmers.

Thanks again.

rwd59 · 03-19-2003, 07:12 PM

Ankit,
I found a few others missing from the DB. PM or e-mail me for more info. I'll be glad to help out in any way I can because this DB puts the fun in historical replays.

rwd59 · 03-19-2003, 10:31 PM

bump

Ankit · 03-19-2003, 11:29 PM

I have created the AnkitDB for OOTP 5.0. You can download it here:

http://www.ap4e.com/AnkitDB5.zip

About 3.5 megs and all the needed files are there. Just unzip to a folder and use.

rwd59, use this DB and see if you still get a lot of errors.

Here are the changes:

Here it is, the AnkitDB using Lahman DB 5.0 for OOTP 5.0! I have listed what I did to the original database.

If you have any comments or suggestions or criticims, I can be reached at ankitpayal@hotmail.com

This is what I did to the original Lahman 5.0 database.

1. Added debut dates for players missing them (812 players).

2. Deleted all those that never played baseball; were commissioners, umpires, etc (149 guys).

3. Deleted all players who did not play a position, just had a few pinch hit appearances (186 players).

4. Created duplicates of certain players (21) who excelled as both pitchers and batters while doing both for a minimum of 4 seasons. A list of those 21 players is at the bottom.

5. Removed all pitching related entries for hitters from both pitching and fielding files.

6. Removed all non-pitcher fielding entries for pitchers.

7. The fielding information for all players is now based on career averages, provided that he played at a position for at least 10% of his total Games. For those positions where he played less, that position is no longer listed.

8. If a batter had at least 4,500 ABs in his career, his debut year is now the first season in which he had more than 238 ABs.

9. If a batter had at least 1,350 ABs in his career, his debut year is now the first season in which he had more than 130 ABs.

10. If a pitcher had at least 1,450 IPs in his career, his debut year is now the first season in which he had more than 92 2/3 IPs.

11. If a pitcher had more than 434 IPs in his career, his debut year is now the first season in which he had more than 48 2/3 IPs.

12. Deleted all batters who debuted prior to 1996 and had less than 62 career at-bats. (2,296 batters affected)

13. Deleted all pitchers who debuted prior to 1996 and had less than 20 career IP. (1,477 pitchers affected)

14. If a batter made his debut prior to 1996 and had fewer than 1350 ABs and averaged less than 100 at-bats per season, the maximum talent ratings will not be higher than Fair nor will the actual ratings be higher than 4 for any season, and thus by extension, their careers. This makes sure scrubs will be scrubs. This affected 3,945 players but only 204 had 500 or more career at-bats.

15. If a pitcher made his debut prior to 1996 and had fewer than 434 IP and averaged less than 27 IP per season, the maximum talent ratings will not be higher than Fair nor will the actual ratings be higher than 4 for any season, and thus by extension, their careers. This makes sure scrubs will be scrubs. This affected 2,338 players but only 90 had 100 or more career innings pitched.

====

The duplicate players:

playerID Pos SumOfG First Last Career LahmanID
bressru01 OF Rube Bressler 1919,1921-1932 1527
bressra01 P 107 Raymond Bressler 1914-1920 15639

callani01 OF Nixey Callahan 1897,1903-1913 1983
callaja01 P 195 James Callahan 1897-1902 15637

carutbo01 OF Bob Caruthers 1886-1893 2172
carutro01 P 340 Robert Caruthers 1884-1892 15631

coonejo01 OF Johnny Cooney 1935-1944 2807
coonejo02 P 159 John Cooney 1921-1930 15640

dailyed01 OF Ed Daily 1886-1891 3182
dailyed02 P 151 Edward Daily 1885-1888,90,91 15641

dunnja01 3B Jack Dunn 1901-1904 3865
dunnjo02 P 142 John Dunn 1897-1901 15642

foutzda01 1B Dave Foutz 1886-1896 4546
foutzda02 P 251 David Foutz 1884-1893 15634

gleaski01 2B Kid Gleason 1895-1912 5078
gleaswi01 P 299 William Gleason 1888-1895 15632

jeffcha01 OF Hal Jeffcoat 1948-1953 6777
jeffcha02 P 245 Harold Jeffcoat 1954-1959 15635

ruthba01 OF Babe Ruth 1918-1935 12094
ruthge01 P 163 George Ruth 1914-1919 15638

seymocy01 OF Cy Seymour 1901-1913 12744
seymoja02 P 140 James Seymour 1896-1900 15643

smithel01 OF Elmer Smith 1892-1901 13115
smithel03 P 149 El Smith 1886-1892 15644

vanhage01 OF George Van Haltren 1888-1903 14431
vanhari01 P 93 Rip Van Haltren 1887-1888,90,91 15645

wardjo01 SS John Ward 1881-1894 14519
wardmo01 P 292 Monte Ward 1878-1884 15633

woodjo02 OF Joe Wood 1918-1922 15154
woodsm01 P 225 Smokey Wood 1908-1917 15636

yeagejo01 3B Joe Yeager 1903-1908 15491
yeagejo02 P 94 Joseph Yeager 1898-1902 15646

playerID PriPos G Name
craneed01 P Ed Crane 1886-1893
craneed02 OF 145 Edward Crane 1884-1886 15647

maulal01 P Al Maul 1890-1901 8928
maulal02 OF 185 Albert Maul 1888-1891 15648

russere01 P Reb Russell 1913-1919 12251
russeew01 OF 138 Ewell Russell 1922-1923 15649

stiveja01 P Jack Stivetts 1889-1897 13560
stivejo01 OF 141 John Stivetts 1891-1894,96-99 15650

whitnji01 P Jim Whitney 1881-1890 15029
whitnja01 OF 130 James Whitney 1883-1886 15651

=========

Still to do:

16. 3,874 pitchers who were relievers but had a few games started have had their records changed to have 0 GS, so they will import will proper pitching roles. 14 pitchers had over 1,450 IPs.

17. Adjusted pitching records for pitchers from 1901 - 1920 to be normalized for the years 1921 to 1979. The following entries were changed: Hits, Earned Runs, Walks and Strikeouts. This will give players more accurate talents and ratings. Now, not everybody imports with a 9 or 10 for ERA. There are visible differences and pitchers who were dominant will be dominant and get to pitch as well.

18. Career Averages for data in the FieldingOF.csv file.

Nukester · 03-20-2003, 12:04 AM

YAHOOOOO !!!!!

Thanks a million Ankit !

Dargone · 03-20-2003, 12:10 AM

YES!!! Thanks a bunch

hamonrye · 03-20-2003, 03:21 AM

sounds great...can't wait to use it...thanks!!!!

03-13-2003, 07:46 AM	#22
Dargone Hall Of Famer Join Date: Feb 2002 Location: Interwebs Posts: 2,862	Ankit, how goes your work on the revised database? Do you have a tenative ETA yet? I anxiously await the finished database. Thanks for taking the time to create it __________________ I was never one to patiently pick up broken fragments and glue them together again and tell myself that the mended whole was as good as new. What is broken is broken -- and I'd rather remember it as it was at its best than mend it and see the broken places as long as I lived.-Margaret Mitchell

03-19-2003, 09:18 AM	#27
woody5254 Hall Of Famer Join Date: Jan 2002 Location: Hector, NY Posts: 6,130	Great work Ankit. This is a great step forward from the original. Great for all us historical simmers. Thanks again. __________________ Check out: You Pick Tourney Version 2.0 Standings Thread You Pick The Teams Tourney: Main Thread The Colossal 20th Century Tourney:Main Thread Chicago White Sox(Original Owner:2001-) Baseball Maelstrom -2001,2011,2013 World Series Champions -2002,2010 Maelstrom Tourney Champs Arizona Diamondbacks(2003-) NAHHBL Indianapolis Racers(Expansion Team:1993-)ABC

03-19-2003, 11:29 PM	#30
Ankit All Star Reserve Join Date: Feb 2002 Location: Singapore Posts: 603	I have created the AnkitDB for OOTP 5.0. You can download it here: http://www.ap4e.com/AnkitDB5.zip About 3.5 megs and all the needed files are there. Just unzip to a folder and use. rwd59, use this DB and see if you still get a lot of errors. Here are the changes: Here it is, the AnkitDB using Lahman DB 5.0 for OOTP 5.0! I have listed what I did to the original database. If you have any comments or suggestions or criticims, I can be reached at ankitpayal@hotmail.com This is what I did to the original Lahman 5.0 database. 1. Added debut dates for players missing them (812 players). 2. Deleted all those that never played baseball; were commissioners, umpires, etc (149 guys). 3. Deleted all players who did not play a position, just had a few pinch hit appearances (186 players). 4. Created duplicates of certain players (21) who excelled as both pitchers and batters while doing both for a minimum of 4 seasons. A list of those 21 players is at the bottom. 5. Removed all pitching related entries for hitters from both pitching and fielding files. 6. Removed all non-pitcher fielding entries for pitchers. 7. The fielding information for all players is now based on career averages, provided that he played at a position for at least 10% of his total Games. For those positions where he played less, that position is no longer listed. 8. If a batter had at least 4,500 ABs in his career, his debut year is now the first season in which he had more than 238 ABs. 9. If a batter had at least 1,350 ABs in his career, his debut year is now the first season in which he had more than 130 ABs. 10. If a pitcher had at least 1,450 IPs in his career, his debut year is now the first season in which he had more than 92 2/3 IPs. 11. If a pitcher had more than 434 IPs in his career, his debut year is now the first season in which he had more than 48 2/3 IPs. 12. Deleted all batters who debuted prior to 1996 and had less than 62 career at-bats. (2,296 batters affected) 13. Deleted all pitchers who debuted prior to 1996 and had less than 20 career IP. (1,477 pitchers affected) 14. If a batter made his debut prior to 1996 and had fewer than 1350 ABs and averaged less than 100 at-bats per season, the maximum talent ratings will not be higher than Fair nor will the actual ratings be higher than 4 for any season, and thus by extension, their careers. This makes sure scrubs will be scrubs. This affected 3,945 players but only 204 had 500 or more career at-bats. 15. If a pitcher made his debut prior to 1996 and had fewer than 434 IP and averaged less than 27 IP per season, the maximum talent ratings will not be higher than Fair nor will the actual ratings be higher than 4 for any season, and thus by extension, their careers. This makes sure scrubs will be scrubs. This affected 2,338 players but only 90 had 100 or more career innings pitched. ==== The duplicate players: playerID Pos SumOfG First Last Career LahmanID bressru01 OF Rube Bressler 1919,1921-1932 1527 bressra01 P 107 Raymond Bressler 1914-1920 15639 callani01 OF Nixey Callahan 1897,1903-1913 1983 callaja01 P 195 James Callahan 1897-1902 15637 carutbo01 OF Bob Caruthers 1886-1893 2172 carutro01 P 340 Robert Caruthers 1884-1892 15631 coonejo01 OF Johnny Cooney 1935-1944 2807 coonejo02 P 159 John Cooney 1921-1930 15640 dailyed01 OF Ed Daily 1886-1891 3182 dailyed02 P 151 Edward Daily 1885-1888,90,91 15641 dunnja01 3B Jack Dunn 1901-1904 3865 dunnjo02 P 142 John Dunn 1897-1901 15642 foutzda01 1B Dave Foutz 1886-1896 4546 foutzda02 P 251 David Foutz 1884-1893 15634 gleaski01 2B Kid Gleason 1895-1912 5078 gleaswi01 P 299 William Gleason 1888-1895 15632 jeffcha01 OF Hal Jeffcoat 1948-1953 6777 jeffcha02 P 245 Harold Jeffcoat 1954-1959 15635 ruthba01 OF Babe Ruth 1918-1935 12094 ruthge01 P 163 George Ruth 1914-1919 15638 seymocy01 OF Cy Seymour 1901-1913 12744 seymoja02 P 140 James Seymour 1896-1900 15643 smithel01 OF Elmer Smith 1892-1901 13115 smithel03 P 149 El Smith 1886-1892 15644 vanhage01 OF George Van Haltren 1888-1903 14431 vanhari01 P 93 Rip Van Haltren 1887-1888,90,91 15645 wardjo01 SS John Ward 1881-1894 14519 wardmo01 P 292 Monte Ward 1878-1884 15633 woodjo02 OF Joe Wood 1918-1922 15154 woodsm01 P 225 Smokey Wood 1908-1917 15636 yeagejo01 3B Joe Yeager 1903-1908 15491 yeagejo02 P 94 Joseph Yeager 1898-1902 15646 playerID PriPos G Name craneed01 P Ed Crane 1886-1893 craneed02 OF 145 Edward Crane 1884-1886 15647 maulal01 P Al Maul 1890-1901 8928 maulal02 OF 185 Albert Maul 1888-1891 15648 russere01 P Reb Russell 1913-1919 12251 russeew01 OF 138 Ewell Russell 1922-1923 15649 stiveja01 P Jack Stivetts 1889-1897 13560 stivejo01 OF 141 John Stivetts 1891-1894,96-99 15650 whitnji01 P Jim Whitney 1881-1890 15029 whitnja01 OF 130 James Whitney 1883-1886 15651 ========= Still to do: 16. 3,874 pitchers who were relievers but had a few games started have had their records changed to have 0 GS, so they will import will proper pitching roles. 14 pitchers had over 1,450 IPs. 17. Adjusted pitching records for pitchers from 1901 - 1920 to be normalized for the years 1921 to 1979. The following entries were changed: Hits, Earned Runs, Walks and Strikeouts. This will give players more accurate talents and ratings. Now, not everybody imports with a 9 or 10 for ERA. There are visible differences and pitchers who were dominant will be dominant and get to pitch as well. 18. Career Averages for data in the FieldingOF.csv file. __________________ Last edited by Ankit; 03-20-2003 at 06:59 AM.

03-20-2003, 12:10 AM	#32
Dargone Hall Of Famer Join Date: Feb 2002 Location: Interwebs Posts: 2,862	YES!!! Thanks a bunch __________________ I was never one to patiently pick up broken fragments and glue them together again and tell myself that the mended whole was as good as new. What is broken is broken -- and I'd rather remember it as it was at its best than mend it and see the broken places as long as I lived.-Margaret Mitchell

03-13-2003, 11:46 AM	#23
hamonrye Major Leagues Join Date: Sep 2002 Posts: 335	ankit-thanks a lot for your help. i really appreciate it.

03-18-2003, 10:27 PM	#25
rwd59 All Star Reserve Join Date: Dec 2001 Location: LA (Lower Alabama) Posts: 964	Ankit, While importing 1974, I noticed Lee May and Milt May had improper positions and fielding ratings. I checked the DB and they are not in it. I also noticed that Mike Easler imported for them with an assigned position and FAvg of .930 on that team. It is possible that he just pinch hit that season as he has no DB info for 1974. I have noticed a few others that are assigned FAvg's and positions. Do you think we could go into the DB and find people who did not have a fielding position for a year and give them the career avg for that season? Is there any realatively easy way to do that?

03-19-2003, 07:12 PM	#28
rwd59 All Star Reserve Join Date: Dec 2001 Location: LA (Lower Alabama) Posts: 964	Ankit, I found a few others missing from the DB. PM or e-mail me for more info. I'll be glad to help out in any way I can because this DB puts the fun in historical replays.

03-19-2003, 10:31 PM	#29
rwd59 All Star Reserve Join Date: Dec 2001 Location: LA (Lower Alabama) Posts: 964	bump

03-20-2003, 12:04 AM	#31
Nukester All Star Starter Join Date: Dec 2001 Location: Newburgh, NY Posts: 1,923	YAHOOOOO !!!!! Thanks a million Ankit !

03-20-2003, 03:21 AM	#33
hamonrye Major Leagues Join Date: Sep 2002 Posts: 335	sounds great...can't wait to use it...thanks!!!!