Career stats v teams

Tony M · 08-12-2007, 03:57 PM

On a current season basis you can see players stats against other teams, but not for previous seasons or in total.

What I plan to do is write a utility that you run at the end of the playoffs (or anytime before the new preseason) that calculates the player vs team stats and stores them in a new .dat file so that each years values are stored.

There will then also be an export to csv function so that this data can be looked at in Excel.

Batting and fielding will have splits down to the position the player plays in the field, and pitching will be split into starting and relieving.

I plan to keep the structure of the .dat true to the current structure that Markus uses.

Tony M · 08-13-2007, 12:55 PM

I've just realised that there isn't a game fielding breakdown in the player record, so it'll just be pitching and batting breakdowns saved by player against each team.

pstrickert · 08-13-2007, 01:19 PM

I like this idea. Too bad the game doesn't include it already. Did you add it to the list of suggestions for 2008?

Tony M · 08-13-2007, 01:30 PM

Quote:

Originally Posted by pstrickert

I like this idea. Too bad the game doesn't include it already. Did you add it to the list of suggestions for 2008?

Yes, both the fielding per game and the ability to hold game summaries in the history of a player have been added as suggestions at various points.

I'm thinking I might add the relevant stats to a players' history text file, so that maybe say 4 years into a sim, the following lines might get added when you run my mod

01-12-2011 - Has a lifetime 17-4 record with a 2.10ERA against the Baltimore Orioles in 25 starts
01-12-2001 - Has a lifetime 10-10 record with a 4.75ERA against the New York Yankees in 30 starts

etc

(obviously hitters would get hitting stats)

pstrickert · 08-13-2007, 02:06 PM

I'd love to see the PbP include stats like that!

Tony M · 08-13-2007, 02:28 PM

Quote:

Originally Posted by pstrickert

I'd love to see the PbP include stats like that!

Beyond my abilities unfortunately...

Tony M · 08-14-2007, 12:39 PM

Well, it's getting there.

I've got the program to update my .dat file every year (manual starting it of course) and it creates a csv file for players_teams_batting_stats.csv and players_teams_pitching_stats.csv

Sample data from 1902-1906 at http://www.bourtonville.f2s.com/players_teams.zip

The data in pitching looks fine (I can by doing some sums in Excel that Cy Young went 6-7 in 15 starts against Baltimore Orioles/New York Highlanders giving up 31 ER whilst striking out 71 of the 472 batters he faced over 117.2 innings)

However in batting it appears that some batters have been given records batting against their own team. I'm trying to work out why this is happening because if the players team for a particular game is the home team then the opponent is the away team and vice versa, but somewhere along the line this must be getting muddled.

After solving that issue, I'll set around outputting the results to the player history pages.

Tony M · 08-14-2007, 12:48 PM

Other useless facts you can glean from the data

Rube Waddell liked striking out the Cardinals. He did it 257 times in that 5 year period...

Joe McGinnity gave up a homerun on average every 45 Boston Americans batter that he faced... (but only 1 of those was in spring training out of 52 batters faced)

Deacon Phillippe was 3-1 in 4 postseason starts for Pittsburgh against the Highlanders...

Tony M · 08-14-2007, 12:51 PM

If anyone is looking at this

Game Type

0 = Regular
2 = Spring Training
3 = Postseason

Position

1-9 are regular position numbers in the Batting stats
I'm guessing 0 is like Pinch Hitter (and 10 is probably DH)

1 in the pitching stats is as a starter
0 in the pitching stats is as a reliever

No Pepper · 08-14-2007, 03:53 PM

redsoxford, I'm glad to see you working on this. Can any information like this be gleaned from exhibition games? Thanks again for the good work!

Tony M · 08-14-2007, 04:55 PM

Quote:

Originally Posted by No Pepper

redsoxford, I'm glad to see you working on this. Can any information like this be gleaned from exhibition games? Thanks again for the good work!

I believe exhibition games can be picked up, as there seems to be a gap in the game type field...

DerekT · 06-07-2008, 03:14 PM

Haven't noticed anything new in a while, thought I bump it to ask how is this going.

For me this was the only addition I would be really looking forward to for OOTP2009.

Anyway good luck on the program hope its going well.

08-12-2007, 03:57 PM	#1 (permalink)
Tony M Moderator* Join Date: Feb 2006 Location: Buckingham, England Posts: 2,897	Career stats v teams On a current season basis you can see players stats against other teams, but not for previous seasons or in total. What I plan to do is write a utility that you run at the end of the playoffs (or anytime before the new preseason) that calculates the player vs team stats and stores them in a new .dat file so that each years values are stored. There will then also be an export to csv function so that this data can be looked at in Excel. Batting and fielding will have splits down to the position the player plays in the field, and pitching will be split into starting and relieving. I plan to keep the structure of the .dat true to the current structure that Markus uses. __________________ Tony M Technical Support Moderator

08-13-2007, 12:55 PM	#2 (permalink)
Tony M Moderator* Join Date: Feb 2006 Location: Buckingham, England Posts: 2,897	I've just realised that there isn't a game fielding breakdown in the player record, so it'll just be pitching and batting breakdowns saved by player against each team. __________________ Tony M Technical Support Moderator

08-14-2007, 12:39 PM	#7 (permalink)
Tony M Moderator* Join Date: Feb 2006 Location: Buckingham, England Posts: 2,897	Well, it's getting there. I've got the program to update my .dat file every year (manual starting it of course) and it creates a csv file for players_teams_batting_stats.csv and players_teams_pitching_stats.csv Sample data from 1902-1906 at http://www.bourtonville.f2s.com/players_teams.zip The data in pitching looks fine (I can by doing some sums in Excel that Cy Young went 6-7 in 15 starts against Baltimore Orioles/New York Highlanders giving up 31 ER whilst striking out 71 of the 472 batters he faced over 117.2 innings) However in batting it appears that some batters have been given records batting against their own team. I'm trying to work out why this is happening because if the players team for a particular game is the home team then the opponent is the away team and vice versa, but somewhere along the line this must be getting muddled. After solving that issue, I'll set around outputting the results to the player history pages. __________________ Tony M Technical Support Moderator

08-14-2007, 12:48 PM	#8 (permalink)
Tony M Moderator* Join Date: Feb 2006 Location: Buckingham, England Posts: 2,897	Other useless facts you can glean from the data Rube Waddell liked striking out the Cardinals. He did it 257 times in that 5 year period... Joe McGinnity gave up a homerun on average every 45 Boston Americans batter that he faced... (but only 1 of those was in spring training out of 52 batters faced) Deacon Phillippe was 3-1 in 4 postseason starts for Pittsburgh against the Highlanders... __________________ Tony M Technical Support Moderator

08-14-2007, 12:51 PM	#9 (permalink)
Tony M Moderator* Join Date: Feb 2006 Location: Buckingham, England Posts: 2,897	If anyone is looking at this Game Type 0 = Regular 2 = Spring Training 3 = Postseason Position 1-9 are regular position numbers in the Batting stats I'm guessing 0 is like Pinch Hitter (and 10 is probably DH) 1 in the pitching stats is as a starter 0 in the pitching stats is as a reliever __________________ Tony M Technical Support Moderator

08-13-2007, 01:19 PM	#3 (permalink)
pstrickert Hall Of Famer Join Date: Dec 2005 Posts: 2,655	I like this idea. Too bad the game doesn't include it already. Did you add it to the list of suggestions for 2008?

08-13-2007, 02:06 PM	#5 (permalink)
pstrickert Hall Of Famer Join Date: Dec 2005 Posts: 2,655	I'd love to see the PbP include stats like that!

08-14-2007, 03:53 PM	#10 (permalink)
No Pepper All Star Reserve Join Date: Jan 2003 Location: Milwaukee, WI Posts: 746	redsoxford, I'm glad to see you working on this. Can any information like this be gleaned from exhibition games? Thanks again for the good work! __________________ Current Dynasty: The Slippery Elm Boys Historical Uniforms: Major, Minor, Latin and Negro Leagues 19th century uniforms and templates. Logo Collection

06-07-2008, 03:14 PM	#12 (permalink)
DerekT Minors (Triple A) Join Date: Apr 2004 Posts: 221	Haven't noticed anything new in a while, thought I bump it to ask how is this going. For me this was the only addition I would be really looking forward to for OOTP2009. Anyway good luck on the program hope its going well.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode