I am trying to do some data analytics on a set of e-sports game data. The data is formatted as follows (converted from json):
game_data = [{"match_id":1, "players":[{"player_name":"Tom", "won":True},
{"player_name":"Anna", "won":False}]},
{"match_id":2, "players":[{"player_name":"Tom", "won":False},
{"player_name":"Fred", "won":True}]}]
I would like to get a list for player "Tom" containing his wins and losses. Like this:
tom_won = [True, False]
What I've tried so far (see below) isn't working so I hope that one of you will be able to show me a better approach.
index = 0
tom_won = []
while index < len(game_data)
for game_data[index]["players"][0]["won"] in data[index]:
if game_data[index]["players"][0]["player_name"] == "Tom":
tom_won.append(game_data[index]["players"][0]["won"])
for game_data[index]["players"][1]["won"] in data[index]:
if game_data[index]["players"][1]["player_name"] == "Tom":
tom_won.append(game_data[index]["players"][1]["won"])
index += 1