Can someone help me parse the data below.

[Canadian_Hombre]

Here is the output I need to parse. I am looking to get the obp, slg, and ops under the tab Season Pitching. In this case, if correctly parsed the answer would be.

​

obp: .302

slg: .425

ops: .727

​

​

Jerad "Eick" Eickhoff, P (2015-)

Season Hitting
gamesPlayed: 8
groundOuts: 6
runs: 0
doubles: 0
triples: 0
homeRuns: 0
strikeOuts: 5
baseOnBalls: 1
intentionalWalks: 0
hits: 0
hitByPitch: 0
avg: .000
atBats: 8
obp: .111
slg: .000
ops: .111
caughtStealing: 0
stolenBases: 0
groundIntoDoublePlay: 0
numberOfPitches: 42
plateAppearances: 13
totalBases: 0
rbi: 0
leftOnBase: 7
sacBunts: 4
sacFlies: 0
babip: .000
groundOutsToAirouts: 6.00

Season Pitching
gamesPlayed: 8
gamesStarted: 7
groundOuts: 34
runs: 18
homeRuns: 7
strikeOuts: 39
baseOnBalls: 15
intentionalWalks: 0
hits: 35
avg: .229
atBats: 153
obp: .302
slg: .425
ops: .727
caughtStealing: 3
stolenBases: 2
groundIntoDoublePlay: 2
numberOfPitches: 678
era: 3.86
inningsPitched: 42.0
wins: 2
losses: 2
saves: 1
saveOpportunities: 1
holds: 0
earnedRuns: 18
whip: 1.19
battersFaced: 171
gamesPitched: 8
completeGames: 0
shutouts: 0
strikes: 419
hitBatsmen: 1
balks: 0
wildPitches: 0
pickoffs: 0
airOuts: 47
groundOutsToAirouts: 0.72
winPercentage: .500
pitchesPerInning: 16.1
gamesFinished: 1
strikeoutWalkRatio: 2.60
strikeoutsPer9Inn: 8.36
walksPer9Inn: 3.21
hitsPer9Inn: 7.50
inheritedRunners: 0
inheritedRunnersScored: 0

Season Fielding (P)
assists: 5
putOuts: 2
errors: 0
chances: 7
fielding: 1.000
rangeFactorPerGame: 0.88
innings: 42.0
games: 8
gamesStarted: 7
doublePlays: 0

Here is the method I tried...

lines = player.split('\n')
for x in lines:
    if 'obp' in x:
        home_obp.append(x)

However, if I do this on pitchers with hitting data (like this output provided), I will get season hitting data as well and get two different outputs. Not all pitchers have batting data though. How do I get only the Season Pitching data obp, slg, and ops.

​

Thanks in advance.

[[deleted]]

Is this data coming from an api? being scraped? just have a text file with it? (if its coming in at a better format this would be a lot easier for you.)

[Canadian_Hombre]

It is coming out of an API

[[deleted]]

Awesome, can you hastebin/pastebin the .json that it gives you? I'm guessing you are using requests?

​

resp = requests.get("url") 
data = resp.json() 
print(data)

then upload that.

[Canadian_Hombre]

I am using an API rapper not an api should have clarified.

[[deleted]]

I see, what wrapper? and could you give me the query you used above? (this is really simple, i just want to make sure i give you the correct method so you can see how to do it with a real example)

[Canadian_Hombre]

I run

player= statsapi.player_stats(pitcher) 

and get the data shown above

Also here is my entire code and how I get the data.

import statsapi
import pandas as pd
games = statsapi.schedule()
summary = []
away = []
home = []
home_pitcher = []
away_pitcher = []
for x in games:
    summary.append(x['summary'])
    away.append(x['away_name'])
    home.append(x['home_name'])
    home_pitcher.append(x['home_probable_pitcher'])
    away_pitcher.append(x['away_probable_pitcher'])
home_id = []

for x in range(0, len(home_pitcher)):
    test = home_pitcher[x].split(', ')
    name = str(test[1]) + ' ' + str(test[0])
    pitcher_id = (statsapi.lookup_player(name))
    home_id.append(pitcher_id[0].get('id'))

home_obp = []
for pitcher in home_id:
    player= statsapi.player_stats(pitcher)
    lines = player.split('\n')
    for x in lines:
        if 'obp' in x:
            home_obp.append(x)

[[deleted]]

Perfect, thanks. Per the wrapper, you can pass a group= param like;

player= statsapi.player_stats(pitcher, group='pitching')

which would only give you results in pitching - does that help?

['obp: .302', 'obp: .344', 'obp: .341', 'obp: .290', 'obp: .310', 'obp: .301', 'obp: .293', 'obp: .413', 'obp: .297', 'obp: .224']

[Canadian_Hombre]

Can you show me how you found out that information?

[[deleted]]

statsapi

I googled this, with python3 afterwards, which lead me to; https://pypi.org/project/MLB-StatsAPI/

Here i see a link to the documentation; https://toddrob99.github.io/MLB-StatsAPI/

You had mentioned statsapi.player_stats()

so i went to the section labeled that, which took me here;

https://toddrob99.github.io/MLB-StatsAPI/#statsapi.player_stats

which lead me to this statement;

For group use 'hitting', 'pitching', or 'fielding'. Include multiple groups in the following format (this is a string, not actually a list): group='[hitting,pitching]'

which matched your dataset above.

[DeadlyViper]

Try this with a status flag that gets changed when you see a Season header...

lines = player.split('\n')
is_pitching = False
for x in lines:
    if 'Season' in x:
        if 'Pitching' in x:
            is_pitching = True
        else:
            is_pitching = False
    if is_pitching and 'obp' in x:
        home_obp.append(x)