Issue parsing and reading a JSON file in Python

Question

I am trying to parse two items from a JSON file list, but getting an error TypeError: list indices must be integers or slices, not str

My current script is:

with open("match.json",'r') as f:
    data = json.load(f)
    f.close()

print(type(data['h']))
data['h']

data['h']['X']

And below is the JSON i am working with:

{'h': [{'id': '310295',
   'minute': '6',
   'result': 'SavedShot',
   'X': '0.8280000305175781',
   'Y': '0.639000015258789',
   'xG': '0.04247729107737541',
   'player': 'Anthony Martial',
   'h_a': 'h',
   'player_id': '553',
   'situation': 'OpenPlay',
   'season': '2019',
   'shotType': 'RightFoot',
   'match_id': '11652',
   'h_team': 'Manchester United',
   'a_team': 'Chelsea',
   'h_goals': '4',
   'a_goals': '0',
   'date': '2019-08-11 16:30:00',
   'player_assisted': None,
   'lastAction': 'None'},
  {'id': '310297',
   'minute': '17',
   'result': 'Goal',
   'X': '0.885',
   'Y': '0.5',
   'xG': '0.7611688375473022',
   'player': 'Marcus Rashford',
   'h_a': 'h',
   'player_id': '556',
   'situation': 'Penalty',
   'season': '2019',
   'shotType': 'RightFoot',
   'match_id': '11652',
   'h_team': 'Manchester United',
   'a_team': 'Chelsea',
   'h_goals': '4',
   'a_goals': '0',
   'date': '2019-08-11 16:30:00',
   'player_assisted': None,
   'lastAction': 'Standard'},
  {'id': '310298',
   'minute': '21',
   'result': 'BlockedShot',
   'X': '0.865999984741211',
   'Y': '0.6409999847412109',
   'xG': '0.08496686071157455',
   'player': 'Anthony Martial',
   'h_a': 'h',
   'player_id': '553',
   'situation': 'OpenPlay',
   'season': '2019',
   'shotType': 'RightFoot',
   'match_id': '11652',
   'h_team': 'Manchester United',
   'a_team': 'Chelsea',
   'h_goals': '4',
   'a_goals': '0',
   'date': '2019-08-11 16:30:00',
   'player_assisted': 'Paul Pogba',
   'lastAction': 'HeadPass'},
  {'id': '310299',
   'minute': '29',
   'result': 'MissedShots',
   'X': '0.7719999694824219',
   'Y': '0.63',
   'xG': '0.031568706035614014',
   'player': 'Anthony Martial',
   'h_a': 'h',
   'player_id': '553',
   'situation': 'OpenPlay',
   'season': '2019',
   'shotType': 'RightFoot',
   'match_id': '11652',
   'h_team': 'Manchester United',
   'a_team': 'Chelsea',
   'h_goals': '4',
   'a_goals': '0',
   'date': '2019-08-11 16:30:00',
   'player_assisted': 'Jesse Lingard',
   'lastAction': 'Pass'},
  {'id': '310300',
   'minute': '31',
   'result': 'MissedShots',
   'X': '0.92',
   'Y': '0.435',
   'xG': '0.05561231076717377',
   'player': 'Paul Pogba',
   'h_a': 'h',
   'player_id': '1740',
   'situation': 'OpenPlay',
   'season': '2019',
   'shotType': 'Head',
   'match_id': '11652',
   'h_team': 'Manchester United',
   'a_team': 'Chelsea',
   'h_goals': '4',
   'a_goals': '0',
   'date': '2019-08-11 16:30:00',
   'player_assisted': 'Anthony Martial',
   'lastAction': 'Aerial'},
  {'id': '310309',
   'minute': '53',
   'result': 'BlockedShot',
   'X': '0.815',
   'Y': '0.519000015258789',
   'xG': '0.057843536138534546',
   'player': 'Marcus Rashford',
   'h_a': 'h',
   'player_id': '556',
   'situation': 'OpenPlay',
   'season': '2019',
   'shotType': 'RightFoot',
   'match_id': '11652',
   'h_team': 'Manchester United',
   'a_team': 'Chelsea',
   'h_goals': '4',
   'a_goals': '0',
   'date': '2019-08-11 16:30:00',
   'player_assisted': 'Harry Maguire',
   'lastAction': 'Pass'},
  {'id': '310311',
   'minute': '64',
   'result': 'Goal',
   'X': '0.9619999694824218',
   'Y': '0.5329999923706055',
   'xG': '0.6098462343215942',
   'player': 'Anthony Martial',
   'h_a': 'h',
   'player_id': '553',
   'situation': 'OpenPlay',
   'season': '2019',
   'shotType': 'RightFoot',
   'match_id': '11652',
   'h_team': 'Manchester United',
   'a_team': 'Chelsea',
   'h_goals': '4',
   'a_goals': '0',
   'date': '2019-08-11 16:30:00',
   'player_assisted': 'Andreas Pereira',
   'lastAction': 'Cross'},
  {'id': '310312',
   'minute': '66',
   'result': 'Goal',
   'X': '0.8219999694824218',
   'Y': '0.4759999847412109',
   'xG': '0.37157538533210754',
   'player': 'Marcus Rashford',
   'h_a': 'h',
   'player_id': '556',
   'situation': 'OpenPlay',
   'season': '2019',
   'shotType': 'RightFoot',
   'match_id': '11652',
   'h_team': 'Manchester United',
   'a_team': 'Chelsea',
   'h_goals': '4',
   'a_goals': '0',
   'date': '2019-08-11 16:30:00',
   'player_assisted': 'Paul Pogba',
   'lastAction': 'Throughball'},
  {'id': '310315',
   'minute': '79',
   'result': 'BlockedShot',
   'X': '0.84',
   'Y': '0.6020000076293945',
   'xG': '0.11250953376293182',
   'player': 'Marcus Rashford',
   'h_a': 'h',
   'player_id': '556',
   'situation': 'OpenPlay',
   'season': '2019',
   'shotType': 'RightFoot',
   'match_id': '11652',
   'h_team': 'Manchester United',
   'a_team': 'Chelsea',
   'h_goals': '4',
   'a_goals': '0',
   'date': '2019-08-11 16:30:00',
   'player_assisted': 'Paul Pogba',
   'lastAction': 'Pass'},
  {'id': '310316',
   'minute': '80',
   'result': 'Goal',
   'X': '0.88',
   'Y': '0.41200000762939454',
   'xG': '0.13182462751865387',
   'player': 'Daniel James',
   'h_a': 'h',
   'player_id': '5595',
   'situation': 'OpenPlay',
   'season': '2019',
   'shotType': 'RightFoot',
   'match_id': '11652',
   'h_team': 'Manchester United',
   'a_team': 'Chelsea',
   'h_goals': '4',
   'a_goals': '0',
   'date': '2019-08-11 16:30:00',
   'player_assisted': 'Paul Pogba',
   'lastAction': 'Pass'},
  {'id': '310318',
   'minute': '86',
   'result': 'BlockedShot',
   'X': '0.8669999694824219',
   'Y': '0.47299999237060547',
   'xG': '0.11503136157989502',
   'player': 'Mason Greenwood',
   'h_a': 'h',
   'player_id': '7490',
   'situation': 'OpenPlay',
   'season': '2019',
   'shotType': 'RightFoot',
   'match_id': '11652',
   'h_team': 'Manchester United',
   'a_team': 'Chelsea',
   'h_goals': '4',
   'a_goals': '0',
   'date': '2019-08-11 16:30:00',
   'player_assisted': 'Aaron Wan-Bissaka',
   'lastAction': 'Cross'}],
 'a': [{'id': '310293',
   'minute': '3',
   'result': 'ShotOnPost',
   'X': '0.835999984741211',
   'Y': '0.38599998474121094',
   'xG': '0.03392893448472023',
   'player': 'Tammy Abraham',
   'h_a': 'a',
   'player_id': '702',
   'situation': 'FromCorner',
   'season': '2019',
   'shotType': 'RightFoot',
   'match_id': '11652',
   'h_team': 'Manchester United',
   'a_team': 'Chelsea',
   'h_goals': '4',
   'a_goals': '0',
   'date': '2019-08-11 16:30:00',
   'player_assisted': 'Mateo Kovacic',
   'lastAction': 'BallTouch'},
  {'id': '310294',
   'minute': '3',
   'result': 'MissedShots',
   'X': '0.7630000305175781',
   'Y': '0.64',
   'xG': '0.022202739492058754',
   'player': 'Pedro',
   'h_a': 'a',
   'player_id': '687',
   'situation': 'OpenPlay',
   'season': '2019',
   'shotType': 'RightFoot',
   'match_id': '11652',
   'h_team': 'Manchester United',
   'a_team': 'Chelsea',
   'h_goals': '4',
   'a_goals': '0',
   'date': '2019-08-11 16:30:00',
   'player_assisted': 'Mateo Kovacic',
   'lastAction': 'Pass'},
  {'id': '310296',
   'minute': '11',
   'result': 'SavedShot',
   'X': '0.7390000152587891',
   'Y': '0.44299999237060544',
   'xG': '0.021734273061156273',
   'player': 'Mason Mount',
   'h_a': 'a',
   'player_id': '7768',
   'situation': 'OpenPlay',
   'season': '2019',
   'shotType': 'RightFoot',
   'match_id': '11652',
   'h_team': 'Manchester United',
   'a_team': 'Chelsea',
   'h_goals': '4',
   'a_goals': '0',
   'date': '2019-08-11 16:30:00',
   'player_assisted': 'Pedro',
   'lastAction': 'Pass'},
  {'id': '310301',
   'minute': '34',
   'result': 'MissedShots',
   'X': '0.7269999694824218',
   'Y': '0.46599998474121096',
   'xG': '0.01919102855026722',
   'player': 'Ross Barkley',
   'h_a': 'a',
   'player_id': '592',
   'situation': 'OpenPlay',
   'season': '2019',
   'shotType': 'RightFoot',
   'match_id': '11652',
   'h_team': 'Manchester United',
   'a_team': 'Chelsea',
   'h_goals': '4',
   'a_goals': '0',
   'date': '2019-08-11 16:30:00',
   'player_assisted': 'Pedro',
   'lastAction': 'Pass'},
  {'id': '310302',
   'minute': '35',
   'result': 'SavedShot',
   'X': '0.7559999847412109',
   'Y': '0.355',
   'xG': '0.0167279914021492',
   'player': 'Pedro',
   'h_a': 'a',
   'player_id': '687',
   'situation': 'OpenPlay',
   'season': '2019',
   'shotType': 'LeftFoot',
   'match_id': '11652',
   'h_team': 'Manchester United',
   'a_team': 'Chelsea',
   'h_goals': '4',
   'a_goals': '0',
   'date': '2019-08-11 16:30:00',
   'player_assisted': 'César Azpilicueta',
   'lastAction': 'BallRecovery'},
  {'id': '310303',
   'minute': '38',
   'result': 'SavedShot',
   'X': '0.9119999694824219',
   'Y': '0.6659999847412109',
   'xG': '0.06690332293510437',
   'player': 'Ross Barkley',
   'h_a': 'a',
   'player_id': '592',
   'situation': 'OpenPlay',
   'season': '2019',
   'shotType': 'LeftFoot',
   'match_id': '11652',
   'h_team': 'Manchester United',
   'a_team': 'Chelsea',
   'h_goals': '4',
   'a_goals': '0',
   'date': '2019-08-11 16:30:00',
   'player_assisted': 'Pedro',
   'lastAction': 'Pass'},
  {'id': '310304',
   'minute': '38',
   'result': 'BlockedShot',
   'X': '0.799000015258789',
   'Y': '0.4759999847412109',
   'xG': '0.039041295647621155',
   'player': 'Jorginho',
   'h_a': 'a',
   'player_id': '1389',
   'situation': 'OpenPlay',
   'season': '2019',
   'shotType': 'RightFoot',
   'match_id': '11652',
   'h_team': 'Manchester United',
   'a_team': 'Chelsea',
   'h_goals': '4',
   'a_goals': '0',
   'date': '2019-08-11 16:30:00',
   'player_assisted': None,
   'lastAction': 'Rebound'},
  {'id': '310305',
   'minute': '39',
   'result': 'ShotOnPost',
   'X': '0.9390000152587891',
   'Y': '0.6759999847412109',
   'xG': '0.05201100930571556',
   'player': 'Emerson',
   'h_a': 'a',
   'player_id': '1245',
   'situation': 'OpenPlay',
   'season': '2019',
   'shotType': 'LeftFoot',
   'match_id': '11652',
   'h_team': 'Manchester United',
   'a_team': 'Chelsea',
   'h_goals': '4',
   'a_goals': '0',
   'date': '2019-08-11 16:30:00',
   'player_assisted': None,
   'lastAction': 'None'},
  {'id': '310306',
   'minute': '45',
   'result': 'MissedShots',
   'X': '0.92',
   'Y': '0.524000015258789',
   'xG': '0.043574485927820206',
   'player': 'Kurt Zouma',
   'h_a': 'a',
   'player_id': '935',
   'situation': 'FromCorner',
   'season': '2019',
   'shotType': 'Head',
   'match_id': '11652',
   'h_team': 'Manchester United',
   'a_team': 'Chelsea',
   'h_goals': '4',
   'a_goals': '0',
   'date': '2019-08-11 16:30:00',
   'player_assisted': 'Mason Mount',
   'lastAction': 'Aerial'},
  {'id': '310307',
   'minute': '50',
   'result': 'BlockedShot',
   'X': '0.7730000305175782',
   'Y': '0.37099998474121093',
   'xG': '0.024473881348967552',
   'player': 'Pedro',
   'h_a': 'a',
   'player_id': '687',
   'situation': 'OpenPlay',
   'season': '2019',
   'shotType': 'LeftFoot',
   'match_id': '11652',
   'h_team': 'Manchester United',
   'a_team': 'Chelsea',
   'h_goals': '4',
   'a_goals': '0',
   'date': '2019-08-11 16:30:00',
   'player_assisted': 'Ross Barkley',
   'lastAction': 'Pass'},
  {'id': '310308',
   'minute': '51',
   'result': 'BlockedShot',
   'X': '0.9330000305175781',
   'Y': '0.48700000762939455',
   'xG': '0.0619838684797287',
   'player': 'Tammy Abraham',
   'h_a': 'a',
   'player_id': '702',
   'situation': 'FromCorner',
   'season': '2019',
   'shotType': 'Head',
   'match_id': '11652',
   'h_team': 'Manchester United',
   'a_team': 'Chelsea',
   'h_goals': '4',
   'a_goals': '0',
   'date': '2019-08-11 16:30:00',
   'player_assisted': 'Mason Mount',
   'lastAction': 'Aerial'},
  {'id': '310310',
   'minute': '55',
   'result': 'SavedShot',
   'X': '0.84',
   'Y': '0.715',
   'xG': '0.24400267004966736',
   'player': 'Emerson',
   'h_a': 'a',
   'player_id': '1245',
   'situation': 'OpenPlay',
   'season': '2019',
   'shotType': 'LeftFoot',
   'match_id': '11652',
   'h_team': 'Manchester United',
   'a_team': 'Chelsea',
   'h_goals': '4',
   'a_goals': '0',
   'date': '2019-08-11 16:30:00',
   'player_assisted': None,
   'lastAction': 'Aerial'},
  {'id': '310313',
   'minute': '69',
   'result': 'MissedShots',
   'X': '0.9119999694824219',
   'Y': '0.42900001525878906',
   'xG': '0.029906723648309708',
   'player': 'Kurt Zouma',
   'h_a': 'a',
   'player_id': '935',
   'situation': 'SetPiece',
   'season': '2019',
   'shotType': 'Head',
   'match_id': '11652',
   'h_team': 'Manchester United',
   'a_team': 'Chelsea',
   'h_goals': '4',
   'a_goals': '0',
   'date': '2019-08-11 16:30:00',
   'player_assisted': 'Mason Mount',
   'lastAction': 'Aerial'},
  {'id': '310314',
   'minute': '70',
   'result': 'SavedShot',
   'X': '0.8290000152587891',
   'Y': '0.28299999237060547',
   'xG': '0.02788177877664566',
   'player': 'Emerson',
   'h_a': 'a',
   'player_id': '1245',
   'situation': 'OpenPlay',
   'season': '2019',
   'shotType': 'LeftFoot',
   'match_id': '11652',
   'h_team': 'Manchester United',
   'a_team': 'Chelsea',
   'h_goals': '4',
   'a_goals': '0',
   'date': '2019-08-11 16:30:00',
   'player_assisted': 'Pedro',
   'lastAction': 'Pass'},
  {'id': '310317',
   'minute': '84',
   'result': 'SavedShot',
   'X': '0.7819999694824219',
   'Y': '0.6480000305175782',
   'xG': '0.02486059069633484',
   'player': 'Mason Mount',
   'h_a': 'a',
   'player_id': '7768',
   'situation': 'OpenPlay',
   'season': '2019',
   'shotType': 'RightFoot',
   'match_id': '11652',
   'h_team': 'Manchester United',
   'a_team': 'Chelsea',
   'h_goals': '4',
   'a_goals': '0',
   'date': '2019-08-11 16:30:00',
   'player_assisted': 'Pedro',
   'lastAction': 'Pass'},
  {'id': '310319',
   'minute': '87',
   'result': 'BlockedShot',
   'X': '0.8209999847412109',
   'Y': '0.6430000305175781',
   'xG': '0.04654185473918915',
   'player': 'Christian Pulisic',
   'h_a': 'a',
   'player_id': '2662',
   'situation': 'OpenPlay',
   'season': '2019',
   'shotType': 'RightFoot',
   'match_id': '11652',
   'h_team': 'Manchester United',
   'a_team': 'Chelsea',
   'h_goals': '4',
   'a_goals': '0',
   'date': '2019-08-11 16:30:00',
   'player_assisted': 'Mason Mount',
   'lastAction': 'Pass'},
  {'id': '310320',
   'minute': '88',
   'result': 'MissedShots',
   'X': '0.9569999694824218',
   'Y': '0.5570000076293945',
   'xG': '0.27949726581573486',
   'player': 'Pedro',
   'h_a': 'a',
   'player_id': '687',
   'situation': 'OpenPlay',
   'season': '2019',
   'shotType': 'OtherBodyPart',
   'match_id': '11652',
   'h_team': 'Manchester United',
   'a_team': 'Chelsea',
   'h_goals': '4',
   'a_goals': '0',
   'date': '2019-08-11 16:30:00',
   'player_assisted': 'Emerson',
   'lastAction': 'Cross'},
  {'id': '310321',
   'minute': '93',
   'result': 'SavedShot',
   'X': '0.850999984741211',
   'Y': '0.7',
   'xG': '0.043492574244737625',
   'player': 'Emerson',
   'h_a': 'a',
   'player_id': '1245',
   'situation': 'OpenPlay',
   'season': '2019',
   'shotType': 'LeftFoot',
   'match_id': '11652',
   'h_team': 'Manchester United',
   'a_team': 'Chelsea',
   'h_goals': '4',
   'a_goals': '0',
   'date': '2019-08-11 16:30:00',
   'player_assisted': 'Christian Pulisic',
   'lastAction': 'Pass'}]}

I essentially want to get all the X and Y values from each list ('h' and 'a') so I can use them as coordinates to plot with ax.annotate in matplotlib.

Any help would be appreciated!

Thanks.

Please edit the full error message into our question.

DisappointedByUnaccountableMod
– DisappointedByUnaccountableMod

2020-04-18 19:31:27 +00:00
Commented Apr 18, 2020 at 19:31 — DisappointedByUnaccountableMod
– DisappointedByUnaccountableMod, Commented Apr 18, 2020 at 19:31
' is not valid JSON syntax, it should be " : )

Torxed
– Torxed

2020-04-18 19:32:00 +00:00
Commented Apr 18, 2020 at 19:32 — Torxed
– Torxed, Commented Apr 18, 2020 at 19:32
print([(k['X'], k['Y']) for k in data['h']])

Cavin Dsouza
– Cavin Dsouza

2020-04-18 19:33:17 +00:00
Commented Apr 18, 2020 at 19:33 — Cavin Dsouza
– Cavin Dsouza, Commented Apr 18, 2020 at 19:33
@CavinDsouza That worked! Thanks so much! :-)

JackNesbitt
– JackNesbitt

2020-04-18 19:41:40 +00:00
Commented Apr 18, 2020 at 19:41 — JackNesbitt
– JackNesbitt, Commented Apr 18, 2020 at 19:41

NomadMonad · Accepted Answer · 2020-04-18 19:32:49Z

2

data['h'] is a list of dicts

Try something like this

x_y = [(d['X'], d['Y']) for d in data['h']]

answered Apr 18, 2020 at 19:32

NomadMonad

6496 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Kaif Khan · Accepted Answer · 2020-04-18 20:10:01Z

0

Above answer is perfectly fine. I am just answering this to tell that you don't need to do f.close() when opening a file with with open() construct!

answered Apr 18, 2020 at 20:10

Kaif Khan

1661 silver badge6 bronze badges

Collectives™ on Stack Overflow

Issue parsing and reading a JSON file in Python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related