Where to find grand slams in data dump?

lnpgaceta · 02-13-2021, 10:03 AM

Hi all,

I admit I haven't looked very hard in the forums for the answer here, but I've seen a couple people post grand slam totals for players in their leagues and I simply can't find them in the CSV files I've got.

My data dump options have pretty much everything checked, so I think I should be catching them, but it's just not happening. Am I using the wrong format? Is there a separate tool that would catch them? Any help would be extremely appreciated. Thank you!

scott1964 · 02-14-2021, 01:13 AM

It is located under History , Game Achievements. I don't this there is a file to download though .

lnpgaceta · 02-17-2021, 09:08 PM

Thanks! Unfortunately, I know about that one—I was hoping to find somewhere that was more centralized, so I didn't have to go through each player's profile.

I could've sworn I saw someone post a list; I'll see if I can find it.

Dark Horse · 02-17-2021, 09:41 PM

You can use your splits for bases loaded and that would give you everyone that hit grand slams and how many.

fredbeene · 02-17-2021, 10:42 PM

how can you do no hitters?

scott1964 · 02-18-2021, 08:17 AM

League History under Accomplishments

lnpgaceta · 02-19-2021, 10:43 AM

Quote:

Originally Posted by Dark Horse

You can use your splits for bases loaded and that would give you everyone that hit grand slams and how many.

Thanks! One question, though: that shows it for the current season. Is there a way to show them for a career?

(N.B. I did find the post I was thinking of and asked the person, but they haven't posted in a while, so I'm not expecting to hear back any time soon.)

Bluenoser · 02-19-2021, 11:30 AM

Quote:

Originally Posted by lnpgaceta

Thanks! One question, though: that shows it for the current season. Is there a way to show them for a career?

(N.B. I did find the post I was thinking of and asked the person, but they haven't posted in a while, so I'm not expecting to hear back any time soon.)

On the same split dropdown, click on "timeframe" - there's option for "career".

lnpgaceta · 02-20-2021, 09:22 AM

Quote:

Originally Posted by Bluenoser

On the same split dropdown, click on "timeframe" - there's option for "career".

Yes, but at least in OOTP21, it looks like you can't do both simultaneously (and the "Double Split" only works for reg. season/postseason, vsL/vsR).

Assuming they show up in the order I uploaded them, that first screenshot shows the grand slam output for the season; the second one shows career home runs, not just ones with the bases loaded. Is there a keystroke or order or something that lets me check both?

Bluenoser · 02-20-2021, 11:15 AM

Hmmmm, have you tried using the dbl split?

Can you select career and then the bases loaded option in the 2nd split? Not sure if that will work.

lnpgaceta · 02-20-2021, 07:38 PM

Quote:

Originally Posted by Bluenoser

Hmmmm, have you tried using the dbl split?

Can you select career and then the bases loaded option in the 2nd split? Not sure if that will work.

Not unless there's something I'm missing for what the double split allows. I only get "Regular Season," "Postseason," "Versus Left" and "Versus Right."

BradG223 · 02-21-2021, 08:05 AM

Considering you say you have dumped everything possible, this might help you out a bit.

The file "players_at_bat_batting_stats.csv" will detail every single at-bat over the course of the season. First picture attached is what that CSV file looks like in an Excel table, and note the bolded columns.

Result corresponds to the at-bat outcome. A value of '9' means the batter hit a home run.
base1, base2, and base3 tells whether there is a runner on first, second, or third respectively. 1 means there is, 0 means there is not.

If I want to look at career grand slam totals, I stitch all of these yearly files together (I use Python), filter those 4 fields such that all remaining at-bats are grand slams, and do a group by on the Player ID. Picture two shows a result of the group by, and picture three shows the profile of the player with the ID 1682. Pouring through his game achievements I can confirm he hit 20 grand dingdongs during his career.

lnpgaceta · 02-22-2021, 05:04 PM

Quote:

Originally Posted by BradG223

Considering you say you have dumped everything possible, this might help you out a bit.

The file "players_at_bat_batting_stats.csv" will detail every single at-bat over the course of the season. First picture attached is what that CSV file looks like in an Excel table, and note the bolded columns.

Result corresponds to the at-bat outcome. A value of '9' means the batter hit a home run.
base1, base2, and base3 tells whether there is a runner on first, second, or third respectively. 1 means there is, 0 means there is not.

If I want to look at career grand slam totals, I stitch all of these yearly files together (I use Python), filter those 4 fields such that all remaining at-bats are grand slams, and do a group by on the Player ID. Picture two shows a result of the group by, and picture three shows the profile of the player with the ID 1682. Pouring through his game achievements I can confirm he hit 20 grand dingdongs during his career.

Amazing. I do in fact have that file and just tried out the filtering operation you mention.

(Incidentally, while I've got you: is there a centralized place with the interpretations of the data in each file? I will continue hunting it down in the forums, but I figured I'd ask.)

Unfortunately I didn't start data-dumping until this year, but it gives me a way to figure things out going forward. Thank you!

BradG223 · 02-25-2021, 11:58 AM

Unfortunately I don't think that is captured anywhere. This from Matt has helped me out in the past tho.

Quote:

Originally Posted by Matt Arnold

I don't know if we directly enumerate them anywhere.

Result are the following:
K
BB
OUT (generic, likely shouldn't appear in csv outputs since it usually gets translated to GO/FO)
GROUND_OUT
FLY_OU
SINGLE
DOUBLE
TRIPLE
HOMERUN
HP
CI

Hit Location should basically map to the ballpark locations you can set in 3D: https://manuals.ootpdevelopments.com...park_locations It may end up being +/- 1 depending exactly on indexing, and there may be a few special case elements near the end of the list that don't mark to those park locations, but are stuff like home plate/1B/etc.., although I don't know off-hand which may or may not be used in the csv outputs.

hit_xy is a little complicated, but it's basically an index into the above zone for where the ball lands (or for infield plays, where the fielder supposedly picks up the ball).

Stinks that you're gonna be out some years where you don't have the dumps saved, but going forward you're going to be in for a treat. My favorite part of this game might be querying these files looking for interesting tid-bits in my league's history (shameless plug for my pretty inactive thread here, which I see you have actually looked at haha).

02-13-2021, 10:03 AM	#1
lnpgaceta Minors (Double A) Join Date: Mar 2020 Location: San Juan, PR Posts: 129	Where to find grand slams in data dump? Hi all, I admit I haven't looked very hard in the forums for the answer here, but I've seen a couple people post grand slam totals for players in their leagues and I simply can't find them in the CSV files I've got. My data dump options have pretty much everything checked, so I think I should be catching them, but it's just not happening. Am I using the wrong format? Is there a separate tool that would catch them? Any help would be extremely appreciated. Thank you! __________________ Blog: Gaceta de la LNP Twitch: LNP En Vivo \| watch old games BlueSky: @LNPGaceta Mastodon: @LNPGaceta on allpro.social Merch: Tiendita de la LNP

02-14-2021, 01:13 AM	#2
scott1964 Hall Of Famer Join Date: Oct 2005 Location: Denver Posts: 5,626	It is located under History , Game Achievements. I don't this there is a file to download though . __________________ This just feels more like waiting in line at the Department of Motor Vehicles. PETA.....People Eating Tasty Animals.

02-17-2021, 09:08 PM	#3
lnpgaceta Minors (Double A) Join Date: Mar 2020 Location: San Juan, PR Posts: 129	Thanks! Unfortunately, I know about that one—I was hoping to find somewhere that was more centralized, so I didn't have to go through each player's profile. I could've sworn I saw someone post a list; I'll see if I can find it. __________________ Blog: Gaceta de la LNP Twitch: LNP En Vivo \| watch old games BlueSky: @LNPGaceta Mastodon: @LNPGaceta on allpro.social Merch: Tiendita de la LNP

02-17-2021, 09:41 PM	#4
Dark Horse Hall Of Famer Join Date: May 2002 Location: Texas! Posts: 2,633	You can use your splits for bases loaded and that would give you everyone that hit grand slams and how many. Attached Images __________________ A Justafan Fan LBA Geo Bahn Rock Hounds fan of the ISLANDIAN PRO ALLIANCE

02-18-2021, 08:17 AM	#6
scott1964 Hall Of Famer Join Date: Oct 2005 Location: Denver Posts: 5,626	League History under Accomplishments __________________ This just feels more like waiting in line at the Department of Motor Vehicles. PETA.....People Eating Tasty Animals.

02-17-2021, 10:42 PM	#5
fredbeene All Star Starter Join Date: Aug 2016 Posts: 1,667	how can you do no hitters?

02-20-2021, 11:15 AM	#10
Bluenoser Hall Of Famer Join Date: Mar 2002 Location: In The Moment Posts: 14,474	Hmmmm, have you tried using the dbl split? Can you select career and then the bases loaded option in the 2nd split? Not sure if that will work.

02-21-2021, 08:05 AM	#12
BradG223 Minors (Double A) Join Date: Jan 2014 Posts: 173	Considering you say you have dumped everything possible, this might help you out a bit. The file "players_at_bat_batting_stats.csv" will detail every single at-bat over the course of the season. First picture attached is what that CSV file looks like in an Excel table, and note the bolded columns. Result corresponds to the at-bat outcome. A value of '9' means the batter hit a home run. base1, base2, and base3 tells whether there is a runner on first, second, or third respectively. 1 means there is, 0 means there is not. If I want to look at career grand slam totals, I stitch all of these yearly files together (I use Python), filter those 4 fields such that all remaining at-bats are grand slams, and do a group by on the Player ID. Picture two shows a result of the group by, and picture three shows the profile of the player with the ID 1682. Pouring through his game achievements I can confirm he hit 20 grand dingdongs during his career. Attached Images Last edited by BradG223; 02-21-2021 at 08:13 AM.