def read_xml(cls, url, markup, game, players):
"""
read xml object
:param url: contents url
:param markup: markup provider
:param game: MLBAM Game object
:param players: MLBAM Players object
:return: pitchpx.game.game.Game object
"""
innings = Inning(game, players)
base_url = "".join([url, cls.DIRECTORY])
# hit location data
hit_location = cls._read_hit_chart_data(
MlbamUtil.find_xml('/'.join([base_url, cls.FILENAME_INNING_HIT]),
markup))
# create for atbat & pitch data
for inning in MlbamUtil.find_xml_all(base_url, markup, cls.TAG,
cls.FILENAME_PATTERN):
soup = MlbamUtil.find_xml(
"/".join([base_url, inning.get_text().strip()]), markup)
inning_number = int(soup.inning['num'])
for inning_type in cls.INNINGS.keys():
inning_soup = soup.inning.find(inning_type)
if inning_soup is None:
break
innings._inning_events(inning_soup, inning_number,
cls.INNINGS[inning_type], hit_location)
innings._inning_actions(inning_soup, inning_number,
cls.INNINGS[inning_type])
return innings
def read_xml(cls, url, markup, game, players):
"""
read xml object
:param url: contents url
:param markup: markup provider
:param game: MLBAM Game object
:param players: MLBAM Players object
:return: pitchpx.game.game.Game object
"""
innings = Inning(game, players)
base_url = "".join([url, cls.DIRECTORY])
# hit location data
hit_location = cls._read_hit_chart_data(
MlbamUtil.find_xml('/'.join([base_url, cls.FILENAME_INNING_HIT]), markup)
)
# create for atbat & pitch data
for inning in MlbamUtil.find_xml_all(base_url, markup, cls.TAG, cls.FILENAME_PATTERN):
soup = MlbamUtil.find_xml("/".join([base_url, inning.get_text().strip()]), markup)
inning_number = int(soup.inning['num'])
for inning_type in cls.INNINGS.keys():
inning_soup = soup.inning.find(inning_type)
if inning_soup is None:
break
innings._inning_events(inning_soup, inning_number, cls.INNINGS[inning_type], hit_location)
return innings
def result(cls, ab, pa, pitch_list):
"""
At Bat Result
:param ab: at bat object(type:Beautifulsoup)
:param pa: atbat data for plate appearance
:param pitch_list: Pitching data
:return: pa result value(dict)
"""
atbat = OrderedDict()
atbat['ball_ct'] = MlbamUtil.get_attribute_stats(ab, 'b', int, None)
atbat['strike_ct'] = MlbamUtil.get_attribute_stats(ab, 's', int, None)
atbat['pitch_seq'] = ''.join([pitch['pitch_res'] for pitch in pitch_list])
atbat['pitch_type_seq'] = '|'.join([pitch['pitch_type'] for pitch in pitch_list])
atbat['battedball_cd'] = RetroSheet.battedball_cd(pa['event_cd'], pa['event_tx'], pa['ab_des'])
return atbat
def test_find_xml_200(self):
"""
Get xml content(status:200, head:default)
"""
req = MlbamUtil.find_xml(
'http://gd2.mlb.com/components/game/mlb/year_2016/month_04/day_06/gid_2016_04_06_lanmlb_sdnmlb_1/game.xml',
'lxml',
)
self.assertIsNotNone(req)
def read_xml(cls, url, markup, game):
"""
read xml object
:param url: contents url
:param markup: markup provider
:param game: MLBAM Game object
:return: pitchpx.game.players.Players object
"""
return Players._read_objects(MlbamUtil.find_xml("/".join([url, cls.FILENAME]), markup), game)
def result(cls, ab, pa, pitch_list):
"""
At Bat Result
:param ab: at bat object(type:Beautifulsoup)
:param pa: atbat data for plate appearance
:param pitch_list: Pitching data
:return: pa result value(dict)
"""
atbat = OrderedDict()
atbat['ball_ct'] = MlbamUtil.get_attribute_stats(ab, 'b', int, None)
atbat['strike_ct'] = MlbamUtil.get_attribute_stats(ab, 's', int, None)
atbat['pitch_seq'] = ''.join(
[pitch['pitch_res'] for pitch in pitch_list])
atbat['pitch_type_seq'] = '|'.join(
[pitch['pitch_type'] for pitch in pitch_list])
atbat['battedball_cd'] = RetroSheet.battedball_cd(
pa['event_cd'], pa['event_tx'], pa['ab_des'])
return atbat
def test_find_xml_200(self):
"""
Get xml content(status:200, head:default)
"""
req = MlbamUtil.find_xml(
'http://gd2.mlb.com/components/game/mlb/year_2016/month_04/day_06/gid_2016_04_06_lanmlb_sdnmlb_1/game.xml',
'lxml',
)
self.assertIsNotNone(req)
def read_xml(cls, url, markup, game):
"""
read xml object
:param url: contents url
:param markup: markup provider
:param game: MLBAM Game object
:return: pitchpx.game.players.Players object
"""
return Players._read_objects(
MlbamUtil.find_xml("".join([url, cls.FILENAME]), markup), game)
def read_xml(cls, url, features, timestamp, game_number):
"""
read xml object
:param url: contents url
:param features: markup provider
:param timestamp: game day
:param game_number: game number
:return: pitchpx.game.game.Game object
"""
soup = MlbamUtil.find_xml("".join([url, cls.FILENAME]), features)
return cls._generate_game_object(soup, timestamp, game_number)
def test_get_content_404_setting_header(self):
"""
Get html content(status:404, head:original)
"""
req = MlbamUtil._get_content(
'http://gd2.mlb.com/components/game/mlb/year_2016/month_04/day_06/gid_2016_04_06_chnmlb_anamlb_1/game.xml',
headers={'Accept': 'text/html', 'User-Agent': 'Python-urllib/3.5'}
)
self.assertEqual(req.status_code, 404)
self.assertEqual(req.request.headers['Accept'], 'text/html')
self.assertEqual(req.request.headers['User-Agent'], 'Python-urllib/3.5')
def read_xml(cls, url, features, game, players):
"""
read xml object
:param url: contents url
:param features: markup provider
:param game: MLBAM Game object
:param players: MLBAM Players object
:return: pitchpx.box_score.box_score.BoxScore object
"""
soup = MlbamUtil.find_xml("".join([url, cls.FILENAME]), features)
return cls._generate_object(soup, game, players)
def read_xml(cls, url, features, timestamp, game_number):
"""
read xml object
:param url: contents url
:param features: markup provider
:param timestamp: game day
:param game_number: game number
:return: pitchpx.game.game.Game object
"""
soup = MlbamUtil.find_xml("".join([url, cls.FILENAME]), features)
return cls._generate_game_object(soup, timestamp, game_number)
def _download(self, timestamp):
"""
download MLBAM Game Day
:param timestamp: day
"""
games, atbats, pitches = [], [], []
rosters, coaches, umpires = [], [], []
timestamp_params = {
'year': str(timestamp.year),
'month': str(timestamp.month).zfill(2),
'day': str(timestamp.day).zfill(2)
}
logging.info('->- Game data download start({year}/{month}/{day})'.format(**timestamp_params))
base_url = self.DELIMITER.join([self.url, self.PAGE_URL_GAME_DAY.format(**timestamp_params)])
html = MlbamUtil.find_xml(base_url, self.parser)
href = self.PAGE_URL_GAME_PREFIX.format(**timestamp_params)
for gid in html.find_all('a', href=re.compile(href)):
gid_path = gid.get_text().strip()
gid_url = self.DELIMITER.join([base_url, gid_path])
# Read XML & create dataset
try:
game = Game.read_xml(gid_url, self.parser, timestamp, MlbAm._get_game_number(gid_path))
players = Players.read_xml(gid_url, self.parser, game)
innings = Inning.read_xml(gid_url, self.parser, game, players)
except MlbAmHttpNotFound as e:
logging.warning(e.msg)
continue
# append a dataset
games.append(game.row())
rosters.extend([roseter.row() for roseter in players.rosters.values()])
coaches.extend([coach.row() for coach in players.coaches.values()])
umpires.extend([umpire.row() for umpire in players.umpires.values()])
atbats.extend(innings.atbats)
pitches.extend(innings.pitches)
# writing csv
day = "".join([timestamp_params['year'], timestamp_params['month'], timestamp_params['day']])
for params in (
{'datasets': games, 'filename': Game.DOWNLOAD_FILE_NAME},
{'datasets': rosters, 'filename': Players.Player.DOWNLOAD_FILE_NAME},
{'datasets': coaches, 'filename': Players.Coach.DOWNLOAD_FILE_NAME},
{'datasets': umpires, 'filename': Players.Umpire.DOWNLOAD_FILE_NAME},
{'datasets': atbats, 'filename': AtBat.DOWNLOAD_FILE_NAME},
{'datasets': pitches, 'filename': Pitch.DOWNLOAD_FILE_NAME},
):
self._write_csv(params['datasets'], params['filename'].format(day=day, extension=self.extension))
time.sleep(2)
logging.info('-<- Game data download end({year}/{month}/{day})'.format(**timestamp_params))
def _generate_game_object(cls, soup, timestamp, game_number):
"""
get game data
:param soup: Beautifulsoup object
:param timestamp: game day
:param game_number: game number
:return: pitchpx.game.game.Game object
"""
game = Game(timestamp)
# Base Game Data(Spring Training, Regular Season, Play Off, etc...)
game.game_type = MlbamUtil.get_attribute(soup.game, 'type', unknown=MlbamConst.UNKNOWN_SHORT)
game.game_type_des = cls._get_game_type_des(game.game_type)
game.st_fl = cls._get_st_fl(game.game_type)
game.regseason_fl = cls._get_regseason_fl(game.game_type)
game.playoff_fl = cls._get_playoff_fl(game.game_type)
game.local_game_time = MlbamUtil.get_attribute(soup.game, 'local_game_time', unknown=MlbamConst.UNKNOWN_FULL)
game.game_id = MlbamUtil.get_attribute(soup.game, 'game_pk', unknown=MlbamConst.UNKNOWN_FULL)
# Team Data
game.home_team_id = cls._get_team_attribute(soup, cls.TEAM_TYPE_HOME, 'code')
game.home_team_lg = cls._get_team_attribute(soup, cls.TEAM_TYPE_HOME, 'league')
game.away_team_id = cls._get_team_attribute(soup, cls.TEAM_TYPE_AWAY, 'code')
game.away_team_lg = cls._get_team_attribute(soup, cls.TEAM_TYPE_AWAY, 'league')
game.home_team_name = cls._get_team_attribute(soup, cls.TEAM_TYPE_HOME, 'name')
game.away_team_name = cls._get_team_attribute(soup, cls.TEAM_TYPE_AWAY, 'name')
game.home_team_name_full = cls._get_team_attribute(soup, cls.TEAM_TYPE_HOME, 'name_full')
game.away_team_name_full = cls._get_team_attribute(soup, cls.TEAM_TYPE_AWAY, 'name_full')
game.interleague_fl = cls._get_interleague_fl(game.home_team_lg, game.away_team_lg)
# Stadium Data
game.park_id = cls._get_stadium_attribute(soup, 'id')
game.park_name = cls._get_stadium_attribute(soup, 'name')
game.park_loc = cls._get_stadium_attribute(soup, 'location')
# Retro ID
game.retro_game_id = cls._get_retro_id(game.home_team_id, timestamp, game_number)
return game
def _generate_game_object(cls, soup, timestamp, game_number):
"""
get game data
:param soup: Beautifulsoup object
:param timestamp: game day
:param game_number: game number
:return: pitchpx.game.game.Game object
"""
game = Game(timestamp)
# Base Game Data(Spring Training, Regular Season, Play Off, etc...)
game.game_type = MlbamUtil.get_attribute(soup.game, 'type', unknown=MlbamConst.UNKNOWN_SHORT)
game.game_type_des = cls._get_game_type_des(game.game_type)
game.st_fl = cls._get_st_fl(game.game_type)
game.regseason_fl = cls._get_regseason_fl(game.game_type)
game.playoff_fl = cls._get_playoff_fl(game.game_type)
game.local_game_time = MlbamUtil.get_attribute(soup.game, 'local_game_time', unknown=MlbamConst.UNKNOWN_FULL)
game.game_id = MlbamUtil.get_attribute(soup.game, 'game_pk', unknown=MlbamConst.UNKNOWN_FULL)
# Team Data
game.home_team_id = cls._get_team_attribute(soup, cls.TEAM_TYPE_HOME, 'code')
game.home_team_lg = cls._get_team_attribute(soup, cls.TEAM_TYPE_HOME, 'league')
game.away_team_id = cls._get_team_attribute(soup, cls.TEAM_TYPE_AWAY, 'code')
game.away_team_lg = cls._get_team_attribute(soup, cls.TEAM_TYPE_AWAY, 'league')
game.home_team_name = cls._get_team_attribute(soup, cls.TEAM_TYPE_HOME, 'name')
game.away_team_name = cls._get_team_attribute(soup, cls.TEAM_TYPE_AWAY, 'name')
game.home_team_name_full = cls._get_team_attribute(soup, cls.TEAM_TYPE_HOME, 'name_full')
game.away_team_name_full = cls._get_team_attribute(soup, cls.TEAM_TYPE_AWAY, 'name_full')
game.interleague_fl = cls._get_interleague_fl(game.home_team_lg, game.away_team_lg)
# Stadium Data
game.park_id = cls._get_stadium_attribute(soup, 'id')
game.park_name = cls._get_stadium_attribute(soup, 'name')
game.park_loc = cls._get_stadium_attribute(soup, 'location')
# Retro ID
game.retro_game_id = cls._get_retro_id(game.home_team_id, timestamp, game_number)
return game
def test_get_content_200(self):
"""
Get html content(status:200, head:default)
"""
req = MlbamUtil._get_content(
'http://gd2.mlb.com/components/game/mlb/year_2016/month_04/day_06/gid_2016_04_06_lanmlb_sdnmlb_1/game.xml'
)
self.assertEqual(req.status_code, 200)
self.assertEqual(req.request.headers['Accept'],
'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8')
self.assertEqual(req.request.headers['User-Agent'],
('Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_4) '
'AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.86 Safari/537.36'))
def test_find_xml_404(self):
"""
Get xml content(status:404, head:default)
"""
try:
_ = MlbamUtil.find_xml(
'http://gd2.mlb.com/components/game/mlb/year_2016/month_04/day_06/gid_2016_04_06_chnmlb_anamlb_1/game.xml',
'lxml',
)
except MlbAmHttpNotFound as e:
self.assertEqual(e.msg, (
'HTTP Error '
'url: http://gd2.mlb.com/components/game/mlb/year_2016/month_04/day_06/gid_2016_04_06_chnmlb_anamlb_1/game.xml '
'status: 404'))
def test_get_content_404_setting_header(self):
"""
Get html content(status:404, head:original)
"""
req = MlbamUtil._get_content(
'http://gd2.mlb.com/components/game/mlb/year_2016/month_04/day_06/gid_2016_04_06_chnmlb_anamlb_1/game.xml',
headers={
'Accept': 'text/html',
'User-Agent': 'Python-urllib/3.5'
})
self.assertEqual(req.status_code, 404)
self.assertEqual(req.request.headers['Accept'], 'text/html')
self.assertEqual(req.request.headers['User-Agent'],
'Python-urllib/3.5')
def test_get_content_200(self):
"""
Get html content(status:200, head:default)
"""
req = MlbamUtil._get_content(
'http://gd2.mlb.com/components/game/mlb/year_2016/month_04/day_06/gid_2016_04_06_lanmlb_sdnmlb_1/game.xml'
)
self.assertEqual(req.status_code, 200)
self.assertEqual(
req.request.headers['Accept'],
'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8'
)
self.assertEqual(req.request.headers['User-Agent'], (
'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_4) '
'AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.86 Safari/537.36'
))
def test_find_xml_404(self):
"""
Get xml content(status:404, head:default)
"""
try:
_ = MlbamUtil.find_xml(
'http://gd2.mlb.com/components/game/mlb/year_2016/month_04/day_06/gid_2016_04_06_chnmlb_anamlb_1/game.xml',
'lxml',
)
except MlbAmHttpNotFound as e:
self.assertEqual(
e.msg,
('HTTP Error '
'url: http://gd2.mlb.com/components/game/mlb/year_2016/month_04/day_06/gid_2016_04_06_chnmlb_anamlb_1/game.xml '
'status: 404'
)
)
def _read_hit_chart_data(cls, soup):
"""
:param soup: Beautifulsoup object
:return: dictionary data
"""
hit_chart = {}
for hip in soup.find_all('hip'):
key = cls.HITLOCATION_KEY_FORMAT.format(
inning=MlbamUtil.get_attribute_stats(hip, 'inning', int),
des=MlbamUtil.get_attribute_stats(hip, 'des', str),
pitcher=MlbamUtil.get_attribute_stats(hip, 'pitcher', str),
batter=MlbamUtil.get_attribute_stats(hip, 'batter', str),
)
hit_chart[key] = {
'hit_x': MlbamUtil.get_attribute_stats(hip, 'x', float, None),
'hit_y': MlbamUtil.get_attribute_stats(hip, 'y', float, None),
}
return hit_chart
def _read_hit_chart_data(cls, soup):
"""
:param soup: Beautifulsoup object
:return: dictionary data
"""
hit_chart = {}
for hip in soup.find_all('hip'):
key = cls.HITLOCATION_KEY_FORMAT.format(
inning=MlbamUtil.get_attribute_stats(hip, 'inning', int),
des=MlbamUtil.get_attribute_stats(hip, 'des', str),
pitcher=MlbamUtil.get_attribute_stats(hip, 'pitcher', str),
batter=MlbamUtil.get_attribute_stats(hip, 'batter', str),
)
hit_chart[key] = {
'hit_x': MlbamUtil.get_attribute_stats(hip, 'x', float, None),
'hit_y': MlbamUtil.get_attribute_stats(hip, 'y', float, None),
}
return hit_chart
def _download(self, timestamp):
"""
download MLBAM Game Day
:param timestamp: day
"""
games, atbats, pitches = [], [], []
rosters, coaches, umpires = [], [], []
boxscores, actions = [], []
timestamp_params = {
'year': str(timestamp.year),
'month': str(timestamp.month).zfill(2),
'day': str(timestamp.day).zfill(2)
}
logging.info(
'->- Game data download start({year}/{month}/{day})'.format(
**timestamp_params))
base_url = self.DELIMITER.join(
[self.url,
self.PAGE_URL_GAME_DAY.format(**timestamp_params)])
html = MlbamUtil.find_xml(base_url, self.parser)
href = self.PAGE_URL_GAME_PREFIX.format(**timestamp_params)
for gid in html.find_all('a', href=re.compile(href)):
gid_path = gid.get_text().strip()
gid_url = self.DELIMITER.join([base_url, gid_path])
# Read XML & create dataset
try:
game = Game.read_xml(gid_url, self.parser, timestamp,
MlbAm._get_game_number(gid_path))
players = Players.read_xml(gid_url, self.parser, game)
innings = Inning.read_xml(gid_url, self.parser, game, players)
boxscore = BoxScore.read_xml(gid_url, self.parser, game,
players)
except MlbAmHttpNotFound as e:
logging.warning(e.msg)
continue
# append a dataset
games.append(game.row())
rosters.extend(
[roseter.row() for roseter in players.rosters.values()])
coaches.extend([coach.row() for coach in players.coaches.values()])
umpires.extend(
[umpire.row() for umpire in players.umpires.values()])
atbats.extend(innings.atbats)
pitches.extend(innings.pitches)
actions.extend(innings.actions)
boxscores.append(boxscore.row())
# writing csv
day = "".join([
timestamp_params['year'], timestamp_params['month'],
timestamp_params['day']
])
for params in (
{
'datasets': games,
'filename': Game.DOWNLOAD_FILE_NAME
},
{
'datasets': rosters,
'filename': Players.Player.DOWNLOAD_FILE_NAME
},
{
'datasets': coaches,
'filename': Players.Coach.DOWNLOAD_FILE_NAME
},
{
'datasets': umpires,
'filename': Players.Umpire.DOWNLOAD_FILE_NAME
},
{
'datasets': atbats,
'filename': AtBat.DOWNLOAD_FILE_NAME
},
{
'datasets': pitches,
'filename': Pitch.DOWNLOAD_FILE_NAME
},
{
'datasets': boxscores,
'filename': BoxScore.DOWNLOAD_FILE_NAME
},
{
'datasets': actions,
'filename': InningAction.DOWNLOAD_FILE_NAME
},
):
self._write_csv(
params['datasets'],
params['filename'].format(day=day, extension=self.extension))
time.sleep(2)
logging.info('-<- Game data download end({year}/{month}/{day})'.format(
**timestamp_params))
def row(cls, pitch, pa, pitch_list, ball_tally, strike_tally):
"""
Pitching Result
:param pitch: pitch object(type:Beautifulsoup)
:param pa: At bat data for pa(dict)
:param pitch_list: Pitching
:param ball_tally: Ball telly
:param strike_tally: Strike telly
:return: row value(dict)
"""
pitch_res = MlbamUtil.get_attribute_stats(pitch, 'type', str, MlbamConst.UNKNOWN_FULL)
pitch_seq = [pitch['pitch_res'] for pitch in pitch_list]
pitch_seq.extend([pitch_res])
pitch_type = MlbamUtil.get_attribute_stats(pitch, 'pitch_type', str, MlbamConst.UNKNOWN_SHORT)
pitch_type_seq = [pitch['pitch_type'] for pitch in pitch_list]
pitch_type_seq.extend([pitch_type])
pitching = OrderedDict()
pitching['retro_game_id'] = pa['retro_game_id']
pitching['year'] = pa['year']
pitching['month'] = pa['month']
pitching['day'] = pa['day']
pitching['st_fl'] = pa['st_fl']
pitching['regseason_fl'] = pa['regseason_fl']
pitching['playoff_fl'] = pa['playoff_fl']
pitching['game_type'] = pa['game_type']
pitching['game_type_des'] = pa['game_type_des']
pitching['local_game_time'] = pa['local_game_time']
pitching['game_id'] = pa['game_id']
pitching['home_team_id'] = pa['home_team_id']
pitching['away_team_id'] = pa['away_team_id']
pitching['home_team_lg'] = pa['home_team_lg']
pitching['away_team_lg'] = pa['away_team_lg']
pitching['interleague_fl'] = pa['interleague_fl']
pitching['park_id'] = pa['park_id']
pitching['park_name'] = pa['park_name']
pitching['park_location'] = pa['park_location']
pitching['inning_number'] = pa['inning_number']
pitching['bat_home_id'] = pa['bat_home_id']
pitching['outs_ct'] = pa['outs_ct']
pitching['pit_mlbid'] = pa['pit_mlbid']
pitching['pit_first_name'] = pa['pit_first_name']
pitching['pit_last_name'] = pa['pit_last_name']
pitching['pit_box_name'] = pa['pit_box_name']
pitching['pit_hand_cd'] = pa['pit_hand_cd']
pitching['bat_mlbid'] = pa['bat_mlbid']
pitching['bat_first_name'] = pa['bat_first_name']
pitching['bat_last_name'] = pa['bat_last_name']
pitching['bat_box_name'] = pa['bat_box_name']
pitching['bat_hand_cd'] = pa['bat_hand_cd']
pitching['ab_number'] = pa['ab_number']
pitching['start_bases'] = pa['start_bases']
pitching['end_bases'] = pa['end_bases']
pitching['event_outs_ct'] = pa['event_outs_ct']
pitching['pa_ball_ct'] = ball_tally
pitching['pa_strike_ct'] = strike_tally
pitching['pitch_seq'] = ''.join(pitch_seq)
pitching['pa_terminal_fl'] = cls.is_pa_terminal(ball_tally, strike_tally, pitch_res, pa['event_cd'])
pitching['pa_event_cd'] = pa['event_cd']
pitching['pitch_res'] = pitch_res
pitching['pitch_des'] = MlbamUtil.get_attribute_stats(pitch, 'des', str, MlbamConst.UNKNOWN_FULL)
pitching['pitch_id'] = MlbamUtil.get_attribute_stats(pitch, 'id', int, None)
pitching['x'] = MlbamUtil.get_attribute_stats(pitch, 'x', float, None)
pitching['y'] = MlbamUtil.get_attribute_stats(pitch, 'y', float, None)
pitching['start_speed'] = MlbamUtil.get_attribute_stats(pitch, 'start_speed', float, None)
pitching['end_speed'] = MlbamUtil.get_attribute_stats(pitch, 'end_speed', float, None)
pitching['sz_top'] = MlbamUtil.get_attribute_stats(pitch, 'sz_top', float, None)
pitching['sz_bot'] = MlbamUtil.get_attribute_stats(pitch, 'sz_bot', float, None)
pitching['pfx_x'] = MlbamUtil.get_attribute_stats(pitch, 'pfx_x', float, None)
pitching['pfx_z'] = MlbamUtil.get_attribute_stats(pitch, 'pfx_z', float, None)
pitching['px'] = MlbamUtil.get_attribute_stats(pitch, 'px', float, None)
pitching['pz'] = MlbamUtil.get_attribute_stats(pitch, 'pz', float, None)
pitching['x0'] = MlbamUtil.get_attribute_stats(pitch, 'x0', float, None)
pitching['y0'] = MlbamUtil.get_attribute_stats(pitch, 'y0', float, None)
pitching['z0'] = MlbamUtil.get_attribute_stats(pitch, 'z0', float, None)
pitching['vx0'] = MlbamUtil.get_attribute_stats(pitch, 'vx0', float, None)
pitching['vy0'] = MlbamUtil.get_attribute_stats(pitch, 'vy0', float, None)
pitching['vz0'] = MlbamUtil.get_attribute_stats(pitch, 'vz0', float, None)
pitching['ax'] = MlbamUtil.get_attribute_stats(pitch, 'ax', float, None)
pitching['ay'] = MlbamUtil.get_attribute_stats(pitch, 'ay', float, None)
pitching['az'] = MlbamUtil.get_attribute_stats(pitch, 'az', float, None)
pitching['break_y'] = MlbamUtil.get_attribute_stats(pitch, 'break_y', float, None)
pitching['break_angle'] = MlbamUtil.get_attribute_stats(pitch, 'break_angle', float, None)
pitching['break_length'] = MlbamUtil.get_attribute_stats(pitch, 'break_length', float, None)
pitching['pitch_type'] = pitch_type
pitching['pitch_type_seq'] = '|'.join(pitch_type_seq)
pitching['type_confidence'] = MlbamUtil.get_attribute_stats(pitch, 'type_confidence', float, None)
pitching['zone'] = MlbamUtil.get_attribute_stats(pitch, 'zone', float, None)
pitching['spin_dir'] = MlbamUtil.get_attribute_stats(pitch, 'spin_dir', float, None)
pitching['spin_rate'] = MlbamUtil.get_attribute_stats(pitch, 'spin_rate', float, None)
pitching['sv_id'] = MlbamUtil.get_attribute_stats(pitch, 'sv_id', str, None)
return pitching
def row(cls, pitch, pa, pitch_list, ball_tally, strike_tally):
"""
Pitching Result
Pitch f/x fields: https://fastballs.wordpress.com/category/pitchfx-glossary/
:param pitch: pitch object(type:Beautifulsoup)
:param pa: At bat data for pa(dict)
:param pitch_list: Pitching
:param ball_tally: Ball telly
:param strike_tally: Strike telly
:return: {
'retro_game_id': Retrosheet Game id
'game_type': Game Type(S/R/F/D/L/W)
'game_type_des': Game Type Description
(Spring Training or Regular Season or Wild-card Game or Divisional Series or LCS or World Series)
'st_fl': Spring Training FLAG(T or F)
'regseason_fl': Regular Season FLAG(T or F)
'playoff_fl': Play Off Flag(T or F)
'local_game_time': Game Time(UTC -5)
'game_id': Game Id
'home_team_id': Home Team Id
'home_team_lg': Home Team league(AL or NL)
'away_team_id': Away Team Id
'away_team_lg': Away Team league(AL or NL)
'home_team_name': Home Team Name
'away_team_name': Away Team Name
'home_team_name_full': Home Team Name(Full Name)
'away_team_name_full': Away Team Name(Full Name)
'interleague_fl': Inter League Flag(T or F)
'park_id': Park Id
'park_name': Park Name
'park_loc': Park Location
'inning_number': Inning Number
'bat_home_id': Batter Id
'outs_ct': Out count
'pit_mlbid': Pitcher Id
'pit_first_name': Pitcher First Name
'pit_last_name': Pitcher Last Name
'pit_box_name': Pitcher Box name
'pit_hand_cd': Pitcher Throw Hand(R or L)
'bat_first_name': Batter First Name
'bat_last_name': Batter Last Name
'bat_box_name': Batter Box name
'ab_number': At Bat Sequence Number in Game
'start_bases': Bases(Before At Bat)
(___, 1__, 12_, 123, etc...)
'end_bases': Bases(After At Bat)
(___, 1__, 12_, 123, etc...)
'event_outs_ct': Event Out Count
'pa_ball_ct': Plate appearance Ball count
'pa_strike_ct': Plate appearance Strike count
'pitch_seq': Pitch Sequence(Strike or Ball) ex: B, SSB, BBSBS etc...
'pa_terminal_fl': Plate appearance Terminate Flag(T or F)
'pa_event_cd': Event Code for Retrosheet http://www.retrosheet.org/datause.txt
'pitch_res': Pitch Response(S or B or X) X = In Play
'pitch_des': Pitch Description
'pitch_id': Pitch Id
'x': Point for X(inches)
'y': Point for Y(inches)
'start_speed': The pitch speed(MPH) at the initial point
'end_speed': The pitch speed(MPH) at the current batters
'sz_top': The distance in feet from the ground to the top of the current batter’s
'sz_bot': The distance in feet from the ground to the bottom of the current batter’s
'pfx_x': The horizontal movement, in inches, of the pitch between the release point and home plate
'pfx_z': The vertical movement, in inches, of the pitch between the release point and home plate
'px': The left/right distance, in feet, of the pitch from the middle of the plate as it crossed home plate
'pz': The height of the pitch in feet as it crossed the front of home plate
'x0': The left/right distance, in feet, of the pitch, measured at the initial point
'y0': The distance in feet from home plate where the PITCHf/x system is set to measure the initial parameters
'z0': The height, in feet, of the pitch, measured at the initial point
'vx0': The velocity of the pitch, in feet per second, in three dimensions, measured at the initial point
'vy0': The velocity of the pitch, in feet per second, in three dimensions, measured at the initial point
'vz0': The velocity of the pitch, in feet per second, in three dimensions, measured at the initial point
'ax': The acceleration of the pitch, in feet per second per second, in three dimensions, measured at the initial point
'ay': The acceleration of the pitch, in feet per second per second, in three dimensions, measured at the initial point
'az': The acceleration of the pitch, in feet per second per second, in three dimensions, measured at the initial point
'break_y': The distance in feet from the ground to the top of the current batter’s
'break_angle': The angle, in degrees, from vertical to the straight line path from the release point to where the pitch crossed the front of home plate, as seen from the catcher’s/umpire’s perspective
'break_length': The measurement of the greatest distance, in inches, between the trajectory of the pitch at any point between the release point and the front of home plate
'pitch_type': Pitch Type
'pitch_type_seq': Pitch type Sequence, ex:FF|CU|FF
'type_confidence': Pitch type confidence
'zone': Pitch Zone
'spin_dir': Pitch Spin Dir
'spin_rate': Pitch Spin Rate
'sv_id': Pitch in the air(From Datetime_To Datetime)
'event_num': Event Sequence Number(atbat, pitch, action)
}
"""
pitch_res = MlbamUtil.get_attribute_stats(pitch, 'type', str,
MlbamConst.UNKNOWN_FULL)
pitch_seq = [pitch['pitch_res'] for pitch in pitch_list]
pitch_seq.extend([pitch_res])
pitch_type = MlbamUtil.get_attribute_stats(pitch, 'pitch_type', str,
MlbamConst.UNKNOWN_SHORT)
pitch_type_seq = [pitch['pitch_type'] for pitch in pitch_list]
pitch_type_seq.extend([pitch_type])
pitching = OrderedDict()
pitching['retro_game_id'] = pa['retro_game_id']
pitching['year'] = pa['year']
pitching['month'] = pa['month']
pitching['day'] = pa['day']
pitching['st_fl'] = pa['st_fl']
pitching['regseason_fl'] = pa['regseason_fl']
pitching['playoff_fl'] = pa['playoff_fl']
pitching['game_type'] = pa['game_type']
pitching['game_type_des'] = pa['game_type_des']
pitching['local_game_time'] = pa['local_game_time']
pitching['game_id'] = pa['game_id']
pitching['home_team_id'] = pa['home_team_id']
pitching['away_team_id'] = pa['away_team_id']
pitching['home_team_lg'] = pa['home_team_lg']
pitching['away_team_lg'] = pa['away_team_lg']
pitching['interleague_fl'] = pa['interleague_fl']
pitching['park_id'] = pa['park_id']
pitching['park_name'] = pa['park_name']
pitching['park_location'] = pa['park_location']
pitching['inning_number'] = pa['inning_number']
pitching['bat_home_id'] = pa['bat_home_id']
pitching['outs_ct'] = pa['outs_ct']
pitching['pit_mlbid'] = pa['pit_mlbid']
pitching['pit_first_name'] = pa['pit_first_name']
pitching['pit_last_name'] = pa['pit_last_name']
pitching['pit_box_name'] = pa['pit_box_name']
pitching['pit_hand_cd'] = pa['pit_hand_cd']
pitching['bat_mlbid'] = pa['bat_mlbid']
pitching['bat_first_name'] = pa['bat_first_name']
pitching['bat_last_name'] = pa['bat_last_name']
pitching['bat_box_name'] = pa['bat_box_name']
pitching['bat_hand_cd'] = pa['bat_hand_cd']
pitching['ab_number'] = pa['ab_number']
pitching['start_bases'] = pa['start_bases']
pitching['end_bases'] = pa['end_bases']
pitching['event_outs_ct'] = pa['event_outs_ct']
pitching['pa_ball_ct'] = ball_tally
pitching['pa_strike_ct'] = strike_tally
pitching['pitch_seq'] = ''.join(pitch_seq)
pitching['pa_terminal_fl'] = cls.is_pa_terminal(
ball_tally, strike_tally, pitch_res, pa['event_cd'])
pitching['pa_event_cd'] = pa['event_cd']
pitching['pitch_res'] = pitch_res
pitching['pitch_des'] = MlbamUtil.get_attribute_stats(
pitch, 'des', str, MlbamConst.UNKNOWN_FULL)
pitching['pitch_id'] = MlbamUtil.get_attribute_stats(
pitch, 'id', int, None)
pitching['x'] = MlbamUtil.get_attribute_stats(pitch, 'x', float, None)
pitching['y'] = MlbamUtil.get_attribute_stats(pitch, 'y', float, None)
pitching['start_speed'] = MlbamUtil.get_attribute_stats(
pitch, 'start_speed', float, None)
pitching['end_speed'] = MlbamUtil.get_attribute_stats(
pitch, 'end_speed', float, None)
pitching['sz_top'] = MlbamUtil.get_attribute_stats(
pitch, 'sz_top', float, None)
pitching['sz_bot'] = MlbamUtil.get_attribute_stats(
pitch, 'sz_bot', float, None)
pitching['pfx_x'] = MlbamUtil.get_attribute_stats(
pitch, 'pfx_x', float, None)
pitching['pfx_z'] = MlbamUtil.get_attribute_stats(
pitch, 'pfx_z', float, None)
pitching['px'] = MlbamUtil.get_attribute_stats(pitch, 'px', float,
None)
pitching['pz'] = MlbamUtil.get_attribute_stats(pitch, 'pz', float,
None)
pitching['x0'] = MlbamUtil.get_attribute_stats(pitch, 'x0', float,
None)
pitching['y0'] = MlbamUtil.get_attribute_stats(pitch, 'y0', float,
None)
pitching['z0'] = MlbamUtil.get_attribute_stats(pitch, 'z0', float,
None)
pitching['vx0'] = MlbamUtil.get_attribute_stats(
pitch, 'vx0', float, None)
pitching['vy0'] = MlbamUtil.get_attribute_stats(
pitch, 'vy0', float, None)
pitching['vz0'] = MlbamUtil.get_attribute_stats(
pitch, 'vz0', float, None)
pitching['ax'] = MlbamUtil.get_attribute_stats(pitch, 'ax', float,
None)
pitching['ay'] = MlbamUtil.get_attribute_stats(pitch, 'ay', float,
None)
pitching['az'] = MlbamUtil.get_attribute_stats(pitch, 'az', float,
None)
pitching['break_y'] = MlbamUtil.get_attribute_stats(
pitch, 'break_y', float, None)
pitching['break_angle'] = MlbamUtil.get_attribute_stats(
pitch, 'break_angle', float, None)
pitching['break_length'] = MlbamUtil.get_attribute_stats(
pitch, 'break_length', float, None)
pitching['pitch_type'] = pitch_type
pitching['pitch_type_seq'] = '|'.join(pitch_type_seq)
pitching['type_confidence'] = MlbamUtil.get_attribute_stats(
pitch, 'type_confidence', float, None)
pitching['zone'] = MlbamUtil.get_attribute_stats(
pitch, 'zone', float, None)
pitching['spin_dir'] = MlbamUtil.get_attribute_stats(
pitch, 'spin_dir', float, None)
pitching['spin_rate'] = MlbamUtil.get_attribute_stats(
pitch, 'spin_rate', float, None)
pitching['sv_id'] = MlbamUtil.get_attribute_stats(
pitch, 'sv_id', str, None)
pitching['event_num'] = MlbamUtil.get_attribute_stats(
pitch, 'event_num', int, -1)
return pitching
def action(cls, action, game, rosters, inning_number, inning_id):
"""
action data
:param action: action object(type:Beautifulsoup)
:param game: MLBAM Game object
:param rosters: Game Rosters
:param inning_number: Inning Number
:param inning_id: Inning Id(0:home 1:away)
:return: {
'retro_game_id': Retrosheet Game id
'game_type': Game Type(S/R/F/D/L/W)
'game_type_des': Game Type Description
(Spring Training or Regular Season or Wild-card Game or Divisional Series or LCS or World Series)
'st_fl': Spring Training FLAG(T or F)
'regseason_fl': Regular Season FLAG(T or F)
'playoff_fl': Play Off Flag(T or F)
'local_game_time': Game Time(UTC -5)
'game_id': Game Id
'home_team_id': Home Team Id
'home_team_lg': Home Team league(AL or NL)
'away_team_id': Away Team Id
'away_team_lg': Away Team league(AL or NL)
'home_team_name': Home Team Name
'away_team_name': Away Team Name
'home_team_name_full': Home Team Name(Full Name)
'away_team_name_full': Away Team Name(Full Name)
'interleague_fl': Inter League Flag(T or F)
'park_id': Park Id
'park_name': Park Name
'park_loc': Park Location
'b': Ball Count
's': Strike count
'o': Out count
'des': Description
'event': Event Action
'player_mlbid': Player Id
'player_first_name': Player First Name
'player_last_name': Player Last Name
'player_box_name': Player Box Name
'pitch': Pitch count
'event_num': Event Sequence Number(atbat, pitch, action)
'home_team_runs': Score(Home)
'away_team_runs': Score(Away)
}
"""
player_mlbid = MlbamUtil.get_attribute_stats(action, 'player', str,
MlbamConst.UNKNOWN_FULL)
player = rosters.get(player_mlbid)
act = OrderedDict()
act['retro_game_id'] = game.retro_game_id
act['year'] = game.timestamp.year
act['month'] = game.timestamp.month
act['day'] = game.timestamp.day
act['st_fl'] = game.st_fl
act['regseason_fl'] = game.regseason_fl
act['playoff_fl'] = game.playoff_fl
act['game_type'] = game.game_type
act['game_type_des'] = game.game_type_des
act['local_game_time'] = game.local_game_time
act['game_id'] = game.game_id
act['home_team_id'] = game.home_team_id
act['away_team_id'] = game.away_team_id
act['home_team_lg'] = game.home_team_lg
act['away_team_lg'] = game.away_team_lg
act['interleague_fl'] = game.interleague_fl
act['park_id'] = game.park_id
act['park_name'] = game.park_name
act['inning_number'] = inning_number
act['home_id'] = inning_id
act['park_location'] = game.park_loc
act['b'] = MlbamUtil.get_attribute_stats(action, 'b', int, 0)
act['s'] = MlbamUtil.get_attribute_stats(action, 's', int, 0)
act['o'] = MlbamUtil.get_attribute_stats(action, 'o', int, 0)
act['des'] = MlbamUtil.get_attribute_stats(action, 'des', str,
MlbamConst.UNKNOWN_FULL)
act['event'] = MlbamUtil.get_attribute_stats(action, 'event', str,
MlbamConst.UNKNOWN_FULL)
act['player_mlbid'] = player_mlbid
try:
act['player_first_name'] = player.first
act['player_last_name'] = player.last
act['player_box_name'] = player.box_name
except AttributeError as e:
logging.error(
'Attribute Error(retro_game_id:{retro_game_id} player_mlbid:{player_mlbid})'
.format(
**{
'retro_game_id': game.retro_game_id,
'player_mlbid': player_mlbid
}))
act['player_first_name'] = MlbamConst.UNKNOWN_FULL
act['player_last_name'] = MlbamConst.UNKNOWN_FULL
act['player_box_name'] = MlbamConst.UNKNOWN_FULL
act['pitch'] = MlbamUtil.get_attribute_stats(action, 'pitch', int, 0)
act['event_num'] = MlbamUtil.get_attribute_stats(
action, 'event_num', int, -1)
act['home_team_runs'] = MlbamUtil.get_attribute_stats(
action, 'home_team_runs', int, 0)
act['away_team_runs'] = MlbamUtil.get_attribute_stats(
action, 'away_team_runs', int, 0)
return act
def pa(cls, ab, game, rosters, inning_number, inning_id, out_ct, hit_location):
"""
plate appearance data
:param ab: at bat object(type:Beautifulsoup)
:param game: MLBAM Game object
:param rosters: Game Rosters
:param inning_number: Inning Number
:param inning_id: Inning Id(0:home 1:away)
:param pitch_list: Pitching
:param out_ct: out count
:param hit_location: Hitlocation data(dict)
:return: pa value(dict)
"""
ab_des = MlbamUtil.get_attribute_stats(ab, 'des', str, MlbamConst.UNKNOWN_FULL)
event_tx = MlbamUtil.get_attribute_stats(ab, 'event', str, MlbamConst.UNKNOWN_FULL)
event_cd = RetroSheet.event_cd(event_tx, ab_des)
event_outs_ct = MlbamUtil.get_attribute_stats(ab, 'o', int, 0)
start_bases, end_bases = cls._get_bases(ab)
pit_mlbid = MlbamUtil.get_attribute_stats(ab, 'pitcher', str, MlbamConst.UNKNOWN_FULL)
bat_mlbid = MlbamUtil.get_attribute_stats(ab, 'batter', str, MlbamConst.UNKNOWN_FULL)
pit_player = rosters.get(pit_mlbid)
bat_player = rosters.get(bat_mlbid)
location_key = Inning.HITLOCATION_KEY_FORMAT.format(
inning=inning_number,
des=event_tx,
pitcher=pit_mlbid,
batter=bat_mlbid,
)
location = hit_location.get(location_key, {})
atbat = OrderedDict()
atbat['retro_game_id'] = game.retro_game_id
atbat['year'] = game.timestamp.year
atbat['month'] = game.timestamp.month
atbat['day'] = game.timestamp.day
atbat['st_fl'] = game.st_fl
atbat['regseason_fl'] = game.regseason_fl
atbat['playoff_fl'] = game.playoff_fl
atbat['game_type'] = game.game_type
atbat['game_type_des'] = game.game_type_des
atbat['local_game_time'] = game.local_game_time
atbat['game_id'] = game.game_id
atbat['home_team_id'] = game.home_team_id
atbat['away_team_id'] = game.away_team_id
atbat['home_team_lg'] = game.home_team_lg
atbat['away_team_lg'] = game.away_team_lg
atbat['interleague_fl'] = game.interleague_fl
atbat['park_id'] = game.park_id
atbat['park_name'] = game.park_name
atbat['park_location'] = game.park_loc
atbat['inning_number'] = inning_number
atbat['bat_home_id'] = inning_id
atbat['outs_ct'] = out_ct
atbat['pit_mlbid'] = pit_mlbid
atbat['pit_first_name'] = pit_player.first
atbat['pit_last_name'] = pit_player.last
atbat['pit_box_name'] = pit_player.box_name
atbat['pit_hand_cd'] = MlbamUtil.get_attribute_stats(ab, 'p_throws', str, MlbamConst.UNKNOWN_FULL)
atbat['bat_mlbid'] = bat_mlbid
atbat['bat_first_name'] = bat_player.first
atbat['bat_last_name'] = bat_player.last
atbat['bat_box_name'] = bat_player.box_name
atbat['bat_hand_cd'] = MlbamUtil.get_attribute_stats(ab, 'stand', str, MlbamConst.UNKNOWN_FULL)
atbat['ab_number'] = MlbamUtil.get_attribute_stats(ab, 'num', int, None)
atbat['start_bases'] = start_bases
atbat['end_bases'] = end_bases
atbat['event_outs_ct'] = event_outs_ct
atbat['ab_des'] = ab_des
atbat['event_tx'] = event_tx
atbat['event_cd'] = event_cd
atbat['hit_x'] = location.get('hit_x', None)
atbat['hit_y'] = location.get('hit_y', None)
return atbat
def pa(cls, ab, game, rosters, inning_number, inning_id, out_ct,
hit_location):
"""
plate appearance data
:param ab: at bat object(type:Beautifulsoup)
:param game: MLBAM Game object
:param rosters: Game Rosters
:param inning_number: Inning Number
:param inning_id: Inning Id(0:home 1:away)
:param pitch_list: Pitching
:param out_ct: out count
:param hit_location: Hitlocation data(dict)
:return: {
'retro_game_id': Retrosheet Game id
'game_type': Game Type(S/R/F/D/L/W)
'game_type_des': Game Type Description
(Spring Training or Regular Season or Wild-card Game or Divisional Series or LCS or World Series)
'st_fl': Spring Training FLAG(T or F)
'regseason_fl': Regular Season FLAG(T or F)
'playoff_fl': Play Off Flag(T or F)
'local_game_time': Game Time(UTC -5)
'game_id': Game Id
'home_team_id': Home Team Id
'home_team_lg': Home Team league(AL or NL)
'away_team_id': Away Team Id
'away_team_lg': Away Team league(AL or NL)
'home_team_name': Home Team Name
'away_team_name': Away Team Name
'home_team_name_full': Home Team Name(Full Name)
'away_team_name_full': Away Team Name(Full Name)
'interleague_fl': Inter League Flag(T or F)
'park_id': Park Id
'park_name': Park Name
'park_loc': Park Location
'inning_number': Inning Number
'bat_home_id': Batter Id
'outs_ct': Out count
'pit_mlbid': Pitcher Id
'pit_first_name': Pitcher First Name
'pit_last_name': Pitcher Last Name
'pit_box_name': Pitcher Box name
'pit_hand_cd': Pitcher Throw Hand(R or L)
'bat_first_name': Batter First Name
'bat_last_name': Batter Last Name
'bat_box_name': Batter Box name
'ab_number': At Bat Sequence Number in Game
'start_bases': Bases(Before At Bat)
(___, 1__, 12_, 123, etc...)
'end_bases': Bases(After At Bat)
(___, 1__, 12_, 123, etc...)
'event_outs_ct': Event Out Count
'ab_des': At Bat Description
'event_tx': Event Text
'event_cd': Event Code for Retrosheet http://www.retrosheet.org/datause.txt
'hit_x': Hit Location(x)
'hit_y': Hit Location(y)
'event_num': Event Sequence Number(atbat, pitch, action)
'home_team_runs': Score(Home)
'away_team_runs': Score(Away)
}
"""
ab_des = MlbamUtil.get_attribute_stats(ab, 'des', str,
MlbamConst.UNKNOWN_FULL)
event_tx = MlbamUtil.get_attribute_stats(ab, 'event', str,
MlbamConst.UNKNOWN_FULL)
event_cd = RetroSheet.event_cd(event_tx, ab_des)
event_outs_ct = MlbamUtil.get_attribute_stats(ab, 'o', int, 0)
start_bases, end_bases = cls._get_bases(ab)
pit_mlbid = MlbamUtil.get_attribute_stats(ab, 'pitcher', str,
MlbamConst.UNKNOWN_FULL)
bat_mlbid = MlbamUtil.get_attribute_stats(ab, 'batter', str,
MlbamConst.UNKNOWN_FULL)
pit_player = rosters.get(pit_mlbid)
bat_player = rosters.get(bat_mlbid)
location_key = Inning.HITLOCATION_KEY_FORMAT.format(
inning=inning_number,
des=event_tx,
pitcher=pit_mlbid,
batter=bat_mlbid,
)
location = hit_location.get(location_key, {})
atbat = OrderedDict()
atbat['retro_game_id'] = game.retro_game_id
atbat['year'] = game.timestamp.year
atbat['month'] = game.timestamp.month
atbat['day'] = game.timestamp.day
atbat['st_fl'] = game.st_fl
atbat['regseason_fl'] = game.regseason_fl
atbat['playoff_fl'] = game.playoff_fl
atbat['game_type'] = game.game_type
atbat['game_type_des'] = game.game_type_des
atbat['local_game_time'] = game.local_game_time
atbat['game_id'] = game.game_id
atbat['home_team_id'] = game.home_team_id
atbat['away_team_id'] = game.away_team_id
atbat['home_team_lg'] = game.home_team_lg
atbat['away_team_lg'] = game.away_team_lg
atbat['interleague_fl'] = game.interleague_fl
atbat['park_id'] = game.park_id
atbat['park_name'] = game.park_name
atbat['park_location'] = game.park_loc
atbat['inning_number'] = inning_number
atbat['bat_home_id'] = inning_id
atbat['outs_ct'] = out_ct
atbat['pit_mlbid'] = pit_mlbid
atbat['pit_first_name'] = pit_player.first
atbat['pit_last_name'] = pit_player.last
atbat['pit_box_name'] = pit_player.box_name
atbat['pit_hand_cd'] = MlbamUtil.get_attribute_stats(
ab, 'p_throws', str, MlbamConst.UNKNOWN_FULL)
atbat['bat_mlbid'] = bat_mlbid
atbat['bat_first_name'] = bat_player.first
atbat['bat_last_name'] = bat_player.last
atbat['bat_box_name'] = bat_player.box_name
atbat['bat_hand_cd'] = MlbamUtil.get_attribute_stats(
ab, 'stand', str, MlbamConst.UNKNOWN_FULL)
atbat['ab_number'] = MlbamUtil.get_attribute_stats(
ab, 'num', int, None)
atbat['start_bases'] = start_bases
atbat['end_bases'] = end_bases
atbat['event_outs_ct'] = event_outs_ct
atbat['ab_des'] = ab_des
atbat['event_tx'] = event_tx
atbat['event_cd'] = event_cd
atbat['hit_x'] = location.get('hit_x', None)
atbat['hit_y'] = location.get('hit_y', None)
atbat['event_num'] = MlbamUtil.get_attribute_stats(
ab, 'event_num', int, -1)
atbat['home_team_runs'] = MlbamUtil.get_attribute_stats(
ab, 'home_team_runs', int, 0)
atbat['away_team_runs'] = MlbamUtil.get_attribute_stats(
ab, 'away_team_runs', int, 0)
return atbat
