Notebook

In [5]:

import requests
from bs4 import BeautifulSoup
import json
import pandas as pd

In [3]:

#scrape a single game shots. We will allow users to enter a base url
base_url = 'https://understat.com/match/'
match = str(input('Please enter the match id: '))
url = base_url+match

Please enter the match id: 14898

In [26]:

#Use requests to get the webpage and BeautifulSoup to parse the page
res = requests.get(url)
soup = BeautifulSoup(res.content, 'lxml')
scripts = soup.find_all('script')

In [27]:

#get only the shotsData
strings = scripts[1].string

In [28]:

strings

Out[28]:

"\n\tvar shotsData \t= JSON.parse('\\x7B\\x22h\\x22\\x3A\\x5B\\x7B\\x22id\\x22\\x3A\\x22392487\\x22,\\x22minute\\x22\\x3A\\x221\\x22,\\x22result\\x22\\x3A\\x22MissedShots\\x22,\\x22X\\x22\\x3A\\x220.8880000305175781\\x22,\\x22Y\\x22\\x3A\\x220.43099998474121093\\x22,\\x22xG\\x22\\x3A\\x220.110611192882061\\x22,\\x22player\\x22\\x3A\\x22Philippe\\x20Coutinho\\x22,\\x22h_a\\x22\\x3A\\x22h\\x22,\\x22player_id\\x22\\x3A\\x22488\\x22,\\x22situation\\x22\\x3A\\x22OpenPlay\\x22,\\x22season\\x22\\x3A\\x222020\\x22,\\x22shotType\\x22\\x3A\\x22RightFoot\\x22,\\x22match_id\\x22\\x3A\\x2214898\\x22,\\x22h_team\\x22\\x3A\\x22Barcelona\\x22,\\x22a_team\\x22\\x3A\\x22Levante\\x22,\\x22h_goals\\x22\\x3A\\x221\\x22,\\x22a_goals\\x22\\x3A\\x220\\x22,\\x22date\\x22\\x3A\\x222020\\x2D12\\x2D13\\x2020\\x3A00\\x3A00\\x22,\\x22player_assisted\\x22\\x3A\\x22Sergi\\x5Cu00f1o\\x20Dest\\x22,\\x22lastAction\\x22\\x3A\\x22Pass\\x22\\x7D,\\x7B\\x22id\\x22\\x3A\\x22392489\\x22,\\x22minute\\x22\\x3A\\x2212\\x22,\\x22result\\x22\\x3A\\x22BlockedShot\\x22,\\x22X\\x22\\x3A\\x220.855999984741211\\x22,\\x22Y\\x22\\x3A\\x220.6759999847412109\\x22,\\x22xG\\x22\\x3A\\x220.04891153424978256\\x22,\\x22player\\x22\\x3A\\x22Lionel\\x20Messi\\x22,\\x22h_a\\x22\\x3A\\x22h\\x22,\\x22player_id\\x22\\x3A\\x222097\\x22,\\x22situation\\x22\\x3A\\x22OpenPlay\\x22,\\x22season\\x22\\x3A\\x222020\\x22,\\x22shotType\\x22\\x3A\\x22LeftFoot\\x22,\\x22match_id\\x22\\x3A\\x2214898\\x22,\\x22h_team\\x22\\x3A\\x22Barcelona\\x22,\\x22a_team\\x22\\x3A\\x22Levante\\x22,\\x22h_goals\\x22\\x3A\\x221\\x22,\\x22a_goals\\x22\\x3A\\x220\\x22,\\x22date\\x22\\x3A\\x222020\\x2D12\\x2D13\\x2020\\x3A00\\x3A00\\x22,\\x22player_assisted\\x22\\x3A\\x22Jordi\\x20Alba\\x22,\\x22lastAction\\x22\\x3A\\x22Pass\\x22\\x7D,\\x7B\\x22id\\x22\\x3A\\x22392490\\x22,\\x22minute\\x22\\x3A\\x2215\\x22,\\x22result\\x22\\x3A\\x22SavedShot\\x22,\\x22X\\x22\\x3A\\x220.855999984741211\\x22,\\x22Y\\x22\\x3A\\x220.725999984741211\\x22,\\x22xG\\x22\\x3A\\x220.032116737216711044\\x22,\\x22player\\x22\\x3A\\x22Martin\\x20Braithwaite\\x22,\\x22h_a\\x22\\x3A\\x22h\\x22,\\x22player_id\\x22\\x3A\\x223211\\x22,\\x22situation\\x22\\x3A\\x22OpenPlay\\x22,\\x22season\\x22\\x3A\\x222020\\x22,\\x22shotType\\x22\\x3A\\x22RightFoot\\x22,\\x22match_id\\x22\\x3A\\x2214898\\x22,\\x22h_team\\x22\\x3A\\x22Barcelona\\x22,\\x22a_team\\x22\\x3A\\x22Levante\\x22,\\x22h_goals\\x22\\x3A\\x221\\x22,\\x22a_goals\\x22\\x3A\\x220\\x22,\\x22date\\x22\\x3A\\x222020\\x2D12\\x2D13\\x2020\\x3A00\\x3A00\\x22,\\x22player_assisted\\x22\\x3A\\x22Antoine\\x20Griezmann\\x22,\\x22lastAction\\x22\\x3A\\x22Pass\\x22\\x7D,\\x7B\\x22id\\x22\\x3A\\x22392492\\x22,\\x22minute\\x22\\x3A\\x2219\\x22,\\x22result\\x22\\x3A\\x22SavedShot\\x22,\\x22X\\x22\\x3A\\x220.8669999694824219\\x22,\\x22Y\\x22\\x3A\\x220.3220000076293945\\x22,\\x22xG\\x22\\x3A\\x220.04845098406076431\\x22,\\x22player\\x22\\x3A\\x22Antoine\\x20Griezmann\\x22,\\x22h_a\\x22\\x3A\\x22h\\x22,\\x22player_id\\x22\\x3A\\x222270\\x22,\\x22situation\\x22\\x3A\\x22OpenPlay\\x22,\\x22season\\x22\\x3A\\x222020\\x22,\\x22shotType\\x22\\x3A\\x22RightFoot\\x22,\\x22match_id\\x22\\x3A\\x2214898\\x22,\\x22h_team\\x22\\x3A\\x22Barcelona\\x22,\\x22a_team\\x22\\x3A\\x22Levante\\x22,\\x22h_goals\\x22\\x3A\\x221\\x22,\\x22a_goals\\x22\\x3A\\x220\\x22,\\x22date\\x22\\x3A\\x222020\\x2D12\\x2D13\\x2020\\x3A00\\x3A00\\x22,\\x22player_assisted\\x22\\x3A\\x22Frenkie\\x20de\\x20Jong\\x22,\\x22lastAction\\x22\\x3A\\x22Pass\\x22\\x7D,\\x7B\\x22id\\x22\\x3A\\x22392493\\x22,\\x22minute\\x22\\x3A\\x2221\\x22,\\x22result\\x22\\x3A\\x22SavedShot\\x22,\\x22X\\x22\\x3A\\x220.9109999847412109\\x22,\\x22Y\\x22\\x3A\\x220.43\\x22,\\x22xG\\x22\\x3A\\x220.29747647047042847\\x22,\\x22player\\x22\\x3A\\x22Antoine\\x20Griezmann\\x22,\\x22h_a\\x22\\x3A\\x22h\\x22,\\x22player_id\\x22\\x3A\\x222270\\x22,\\x22situation\\x22\\x3A\\x22SetPiece\\x22,\\x22season\\x22\\x3A\\x222020\\x22,\\x22shotType\\x22\\x3A\\x22Head\\x22,\\x22match_id\\x22\\x3A\\x2214898\\x22,\\x22h_team\\x22\\x3A\\x22Barcelona\\x22,\\x22a_team\\x22\\x3A\\x22Levante\\x22,\\x22h_goals\\x22\\x3A\\x221\\x22,\\x22a_goals\\x22\\x3A\\x220\\x22,\\x22date\\x22\\x3A\\x222020\\x2D12\\x2D13\\x2020\\x3A00\\x3A00\\x22,\\x22player_assisted\\x22\\x3A\\x22Lionel\\x20Messi\\x22,\\x22lastAction\\x22\\x3A\\x22Chipped\\x22\\x7D,\\x7B\\x22id\\x22\\x3A\\x22392494\\x22,\\x22minute\\x22\\x3A\\x2221\\x22,\\x22result\\x22\\x3A\\x22MissedShots\\x22,\\x22X\\x22\\x3A\\x220.9690000152587891\\x22,\\x22Y\\x22\\x3A\\x220.5279999923706055\\x22,\\x22xG\\x22\\x3A\\x220.7536893486976624\\x22,\\x22player\\x22\\x3A\\x22Clement\\x20Lenglet\\x22,\\x22h_a\\x22\\x3A\\x22h\\x22,\\x22player_id\\x22\\x3A\\x225050\\x22,\\x22situation\\x22\\x3A\\x22SetPiece\\x22,\\x22season\\x22\\x3A\\x222020\\x22,\\x22shotType\\x22\\x3A\\x22LeftFoot\\x22,\\x22match_id\\x22\\x3A\\x2214898\\x22,\\x22h_team\\x22\\x3A\\x22Barcelona\\x22,\\x22a_team\\x22\\x3A\\x22Levante\\x22,\\x22h_goals\\x22\\x3A\\x221\\x22,\\x22a_goals\\x22\\x3A\\x220\\x22,\\x22date\\x22\\x3A\\x222020\\x2D12\\x2D13\\x2020\\x3A00\\x3A00\\x22,\\x22player_assisted\\x22\\x3Anull,\\x22lastAction\\x22\\x3A\\x22Rebound\\x22\\x7D,\\x7B\\x22id\\x22\\x3A\\x22392496\\x22,\\x22minute\\x22\\x3A\\x2225\\x22,\\x22result\\x22\\x3A\\x22MissedShots\\x22,\\x22X\\x22\\x3A\\x220.89\\x22,\\x22Y\\x22\\x3A\\x220.51\\x22,\\x22xG\\x22\\x3A\\x220.08828572183847427\\x22,\\x22player\\x22\\x3A\\x22Lionel\\x20Messi\\x22,\\x22h_a\\x22\\x3A\\x22h\\x22,\\x22player_id\\x22\\x3A\\x222097\\x22,\\x22situation\\x22\\x3A\\x22OpenPlay\\x22,\\x22season\\x22\\x3A\\x222020\\x22,\\x22shotType\\x22\\x3A\\x22Head\\x22,\\x22match_id\\x22\\x3A\\x2214898\\x22,\\x22h_team\\x22\\x3A\\x22Barcelona\\x22,\\x22a_team\\x22\\x3A\\x22Levante\\x22,\\x22h_goals\\x22\\x3A\\x221\\x22,\\x22a_goals\\x22\\x3A\\x220\\x22,\\x22date\\x22\\x3A\\x222020\\x2D12\\x2D13\\x2020\\x3A00\\x3A00\\x22,\\x22player_assisted\\x22\\x3A\\x22Antoine\\x20Griezmann\\x22,\\x22lastAction\\x22\\x3A\\x22Cross\\x22\\x7D,\\x7B\\x22id\\x22\\x3A\\x22392498\\x22,\\x22minute\\x22\\x3A\\x2229\\x22,\\x22result\\x22\\x3A\\x22MissedShots\\x22,\\x22X\\x22\\x3A\\x220.8230000305175781\\x22,\\x22Y\\x22\\x3A\\x220.3509999847412109\\x22,\\x22xG\\x22\\x3A\\x220.03806573152542114\\x22,\\x22player\\x22\\x3A\\x22Lionel\\x20Messi\\x22,\\x22h_a\\x22\\x3A\\x22h\\x22,\\x22player_id\\x22\\x3A\\x222097\\x22,\\x22situation\\x22\\x3A\\x22OpenPlay\\x22,\\x22season\\x22\\x3A\\x222020\\x22,\\x22shotType\\x22\\x3A\\x22LeftFoot\\x22,\\x22match_id\\x22\\x3A\\x2214898\\x22,\\x22h_team\\x22\\x3A\\x22Barcelona\\x22,\\x22a_team\\x22\\x3A\\x22Levante\\x22,\\x22h_goals\\x22\\x3A\\x221\\x22,\\x22a_goals\\x22\\x3A\\x220\\x22,\\x22date\\x22\\x3A\\x222020\\x2D12\\x2D13\\x2020\\x3A00\\x3A00\\x22,\\x22player_assisted\\x22\\x3A\\x22Frenkie\\x20de\\x20Jong\\x22,\\x22lastAction\\x22\\x3A\\x22Pass\\x22\\x7D,\\x7B\\x22id\\x22\\x3A\\x22392499\\x22,\\x22minute\\x22\\x3A\\x2236\\x22,\\x22result\\x22\\x3A\\x22BlockedShot\\x22,\\x22X\\x22\\x3A\\x220.7559999847412109\\x22,\\x22Y\\x22\\x3A\\x220.33\\x22,\\x22xG\\x22\\x3A\\x220.05780152603983879\\x22,\\x22player\\x22\\x3A\\x22Lionel\\x20Messi\\x22,\\x22h_a\\x22\\x3A\\x22h\\x22,\\x22player_id\\x22\\x3A\\x222097\\x22,\\x22situation\\x22\\x3A\\x22DirectFreekick\\x22,\\x22season\\x22\\x3A\\x222020\\x22,\\x22shotType\\x22\\x3A\\x22LeftFoot\\x22,\\x22match_id\\x22\\x3A\\x2214898\\x22,\\x22h_team\\x22\\x3A\\x22Barcelona\\x22,\\x22a_team\\x22\\x3A\\x22Levante\\x22,\\x22h_goals\\x22\\x3A\\x221\\x22,\\x22a_goals\\x22\\x3A\\x220\\x22,\\x22date\\x22\\x3A\\x222020\\x2D12\\x2D13\\x2020\\x3A00\\x3A00\\x22,\\x22player_assisted\\x22\\x3Anull,\\x22lastAction\\x22\\x3A\\x22Standard\\x22\\x7D,\\x7B\\x22id\\x22\\x3A\\x22392500\\x22,\\x22minute\\x22\\x3A\\x2237\\x22,\\x22result\\x22\\x3A\\x22SavedShot\\x22,\\x22X\\x22\\x3A\\x220.815\\x22,\\x22Y\\x22\\x3A\\x220.72\\x22,\\x22xG\\x22\\x3A\\x220.019371867179870605\\x22,\\x22player\\x22\\x3A\\x22Jordi\\x20Alba\\x22,\\x22h_a\\x22\\x3A\\x22h\\x22,\\x22player_id\\x22\\x3A\\x222093\\x22,\\x22situation\\x22\\x3A\\x22FromCorner\\x22,\\x22season\\x22\\x3A\\x222020\\x22,\\x22shotType\\x22\\x3A\\x22LeftFoot\\x22,\\x22match_id\\x22\\x3A\\x2214898\\x22,\\x22h_team\\x22\\x3A\\x22Barcelona\\x22,\\x22a_team\\x22\\x3A\\x22Levante\\x22,\\x22h_goals\\x22\\x3A\\x221\\x22,\\x22a_goals\\x22\\x3A\\x220\\x22,\\x22date\\x22\\x3A\\x222020\\x2D12\\x2D13\\x2020\\x3A00\\x3A00\\x22,\\x22player_assisted\\x22\\x3Anull,\\x22lastAction\\x22\\x3A\\x22None\\x22\\x7D,\\x7B\\x22id\\x22\\x3A\\x22392501\\x22,\\x22minute\\x22\\x3A\\x2239\\x22,\\x22result\\x22\\x3A\\x22SavedShot\\x22,\\x22X\\x22\\x3A\\x220.909000015258789\\x22,\\x22Y\\x22\\x3A\\x220.4159999847412109\\x22,\\x22xG\\x22\\x3A\\x220.0710151344537735\\x22,\\x22player\\x22\\x3A\\x22Antoine\\x20Griezmann\\x22,\\x22h_a\\x22\\x3A\\x22h\\x22,\\x22player_id\\x22\\x3A\\x222270\\x22,\\x22situation\\x22\\x3A\\x22SetPiece\\x22,\\x22season\\x22\\x3A\\x222020\\x22,\\x22shotType\\x22\\x3A\\x22RightFoot\\x22,\\x22match_id\\x22\\x3A\\x2214898\\x22,\\x22h_team\\x22\\x3A\\x22Barcelona\\x22,\\x22a_team\\x22\\x3A\\x22Levante\\x22,\\x22h_goals\\x22\\x3A\\x221\\x22,\\x22a_goals\\x22\\x3A\\x220\\x22,\\x22date\\x22\\x3A\\x222020\\x2D12\\x2D13\\x2020\\x3A00\\x3A00\\x22,\\x22player_assisted\\x22\\x3A\\x22Lionel\\x20Messi\\x22,\\x22lastAction\\x22\\x3A\\x22Cross\\x22\\x7D,\\x7B\\x22id\\x22\\x3A\\x22392502\\x22,\\x22minute\\x22\\x3A\\x2242\\x22,\\x22result\\x22\\x3A\\x22SavedShot\\x22,\\x22X\\x22\\x3A\\x220.730999984741211\\x22,\\x22Y\\x22\\x3A\\x220.5690000152587891\\x22,\\x22xG\\x22\\x3A\\x220.05699247121810913\\x22,\\x22player\\x22\\x3A\\x22Lionel\\x20Messi\\x22,\\x22h_a\\x22\\x3A\\x22h\\x22,\\x22player_id\\x22\\x3A\\x222097\\x22,\\x22situation\\x22\\x3A\\x22DirectFreekick\\x22,\\x22season\\x22\\x3A\\x222020\\x22,\\x22shotType\\x22\\x3A\\x22LeftFoot\\x22,\\x22match_id\\x22\\x3A\\x2214898\\x22,\\x22h_team\\x22\\x3A\\x22Barcelona\\x22,\\x22a_team\\x22\\x3A\\x22Levante\\x22,\\x22h_goals\\x22\\x3A\\x221\\x22,\\x22a_goals\\x22\\x3A\\x220\\x22,\\x22date\\x22\\x3A\\x222020\\x2D12\\x2D13\\x2020\\x3A00\\x3A00\\x22,\\x22player_assisted\\x22\\x3Anull,\\x22lastAction\\x22\\x3A\\x22Standard\\x22\\x7D,\\x7B\\x22id\\x22\\x3A\\x22392503\\x22,\\x22minute\\x22\\x3A\\x2242\\x22,\\x22result\\x22\\x3A\\x22SavedShot\\x22,\\x22X\\x22\\x3A\\x220.475\\x22,\\x22Y\\x22\\x3A\\x220.750999984741211\\x22,\\x22xG\\x22\\x3A\\x220.007011083420366049\\x22,\\x22player\\x22\\x3A\\x22Jordi\\x20Alba\\x22,\\x22h_a\\x22\\x3A\\x22h\\x22,\\x22player_id\\x22\\x3A\\x222093\\x22,\\x22situation\\x22\\x3A\\x22OpenPlay\\x22,\\x22season\\x22\\x3A\\x222020\\x22,\\x22shotType\\x22\\x3A\\x22LeftFoot\\x22,\\x22match_id\\x22\\x3A\\x2214898\\x22,\\x22h_team\\x22\\x3A\\x22Barcelona\\x22,\\x22a_team\\x22\\x3A\\x22Levante\\x22,\\x22h_goals\\x22\\x3A\\x221\\x22,\\x22a_goals\\x22\\x3A\\x220\\x22,\\x22date\\x22\\x3A\\x222020\\x2D12\\x2D13\\x2020\\x3A00\\x3A00\\x22,\\x22player_assisted\\x22\\x3A\\x22Martin\\x20Braithwaite\\x22,\\x22lastAction\\x22\\x3A\\x22BallRecovery\\x22\\x7D,\\x7B\\x22id\\x22\\x3A\\x22392504\\x22,\\x22minute\\x22\\x3A\\x2250\\x22,\\x22result\\x22\\x3A\\x22BlockedShot\\x22,\\x22X\\x22\\x3A\\x220.9680000305175781\\x22,\\x22Y\\x22\\x3A\\x220.6480000305175782\\x22,\\x22xG\\x22\\x3A\\x220.072198785841465\\x22,\\x22player\\x22\\x3A\\x22Lionel\\x20Messi\\x22,\\x22h_a\\x22\\x3A\\x22h\\x22,\\x22player_id\\x22\\x3A\\x222097\\x22,\\x22situation\\x22\\x3A\\x22OpenPlay\\x22,\\x22season\\x22\\x3A\\x222020\\x22,\\x22shotType\\x22\\x3A\\x22LeftFoot\\x22,\\x22match_id\\x22\\x3A\\x2214898\\x22,\\x22h_team\\x22\\x3A\\x22Barcelona\\x22,\\x22a_team\\x22\\x3A\\x22Levante\\x22,\\x22h_goals\\x22\\x3A\\x221\\x22,\\x22a_goals\\x22\\x3A\\x220\\x22,\\x22date\\x22\\x3A\\x222020\\x2D12\\x2D13\\x2020\\x3A00\\x3A00\\x22,\\x22player_assisted\\x22\\x3A\\x22Jordi\\x20Alba\\x22,\\x22lastAction\\x22\\x3A\\x22Pass\\x22\\x7D,\\x7B\\x22id\\x22\\x3A\\x22392505\\x22,\\x22minute\\x22\\x3A\\x2251\\x22,\\x22result\\x22\\x3A\\x22MissedShots\\x22,\\x22X\\x22\\x3A\\x220.8569999694824219\\x22,\\x22Y\\x22\\x3A\\x220.720999984741211\\x22,\\x22xG\\x22\\x3A\\x220.032172270119190216\\x22,\\x22player\\x22\\x3A\\x22Philippe\\x20Coutinho\\x22,\\x22h_a\\x22\\x3A\\x22h\\x22,\\x22player_id\\x22\\x3A\\x22488\\x22,\\x22situation\\x22\\x3A\\x22OpenPlay\\x22,\\x22season\\x22\\x3A\\x222020\\x22,\\x22shotType\\x22\\x3A\\x22RightFoot\\x22,\\x22match_id\\x22\\x3A\\x2214898\\x22,\\x22h_team\\x22\\x3A\\x22Barcelona\\x22,\\x22a_team\\x22\\x3A\\x22Levante\\x22,\\x22h_goals\\x22\\x3A\\x221\\x22,\\x22a_goals\\x22\\x3A\\x220\\x22,\\x22date\\x22\\x3A\\x222020\\x2D12\\x2D13\\x2020\\x3A00\\x3A00\\x22,\\x22player_assisted\\x22\\x3A\\x22Frenkie\\x20de\\x20Jong\\x22,\\x22lastAction\\x22\\x3A\\x22Pass\\x22\\x7D,\\x7B\\x22id\\x22\\x3A\\x22392506\\x22,\\x22minute\\x22\\x3A\\x2253\\x22,\\x22result\\x22\\x3A\\x22MissedShots\\x22,\\x22X\\x22\\x3A\\x220.8009999847412109\\x22,\\x22Y\\x22\\x3A\\x220.595999984741211\\x22,\\x22xG\\x22\\x3A\\x220.03635625168681145\\x22,\\x22player\\x22\\x3A\\x22Lionel\\x20Messi\\x22,\\x22h_a\\x22\\x3A\\x22h\\x22,\\x22player_id\\x22\\x3A\\x222097\\x22,\\x22situation\\x22\\x3A\\x22OpenPlay\\x22,\\x22season\\x22\\x3A\\x222020\\x22,\\x22shotType\\x22\\x3A\\x22LeftFoot\\x22,\\x22match_id\\x22\\x3A\\x2214898\\x22,\\x22h_team\\x22\\x3A\\x22Barcelona\\x22,\\x22a_team\\x22\\x3A\\x22Levante\\x22,\\x22h_goals\\x22\\x3A\\x221\\x22,\\x22a_goals\\x22\\x3A\\x220\\x22,\\x22date\\x22\\x3A\\x222020\\x2D12\\x2D13\\x2020\\x3A00\\x3A00\\x22,\\x22player_assisted\\x22\\x3A\\x22Antoine\\x20Griezmann\\x22,\\x22lastAction\\x22\\x3A\\x22Pass\\x22\\x7D,\\x7B\\x22id\\x22\\x3A\\x22392507\\x22,\\x22minute\\x22\\x3A\\x2255\\x22,\\x22result\\x22\\x3A\\x22SavedShot\\x22,\\x22X\\x22\\x3A\\x220.7819999694824219\\x22,\\x22Y\\x22\\x3A\\x220.6020000076293945\\x22,\\x22xG\\x22\\x3A\\x220.04149062559008598\\x22,\\x22player\\x22\\x3A\\x22Philippe\\x20Coutinho\\x22,\\x22h_a\\x22\\x3A\\x22h\\x22,\\x22player_id\\x22\\x3A\\x22488\\x22,\\x22situation\\x22\\x3A\\x22OpenPlay\\x22,\\x22season\\x22\\x3A\\x222020\\x22,\\x22shotType\\x22\\x3A\\x22RightFoot\\x22,\\x22match_id\\x22\\x3A\\x2214898\\x22,\\x22h_team\\x22\\x3A\\x22Barcelona\\x22,\\x22a_team\\x22\\x3A\\x22Levante\\x22,\\x22h_goals\\x22\\x3A\\x221\\x22,\\x22a_goals\\x22\\x3A\\x220\\x22,\\x22date\\x22\\x3A\\x222020\\x2D12\\x2D13\\x2020\\x3A00\\x3A00\\x22,\\x22player_assisted\\x22\\x3A\\x22Frenkie\\x20de\\x20Jong\\x22,\\x22lastAction\\x22\\x3A\\x22LayOff\\x22\\x7D,\\x7B\\x22id\\x22\\x3A\\x22392508\\x22,\\x22minute\\x22\\x3A\\x2261\\x22,\\x22result\\x22\\x3A\\x22MissedShots\\x22,\\x22X\\x22\\x3A\\x220.76\\x22,\\x22Y\\x22\\x3A\\x220.3940000152587891\\x22,\\x22xG\\x22\\x3A\\x220.02280627191066742\\x22,\\x22player\\x22\\x3A\\x22Antoine\\x20Griezmann\\x22,\\x22h_a\\x22\\x3A\\x22h\\x22,\\x22player_id\\x22\\x3A\\x222270\\x22,\\x22situation\\x22\\x3A\\x22OpenPlay\\x22,\\x22season\\x22\\x3A\\x222020\\x22,\\x22shotType\\x22\\x3A\\x22LeftFoot\\x22,\\x22match_id\\x22\\x3A\\x2214898\\x22,\\x22h_team\\x22\\x3A\\x22Barcelona\\x22,\\x22a_team\\x22\\x3A\\x22Levante\\x22,\\x22h_goals\\x22\\x3A\\x221\\x22,\\x22a_goals\\x22\\x3A\\x220\\x22,\\x22date\\x22\\x3A\\x222020\\x2D12\\x2D13\\x2020\\x3A00\\x3A00\\x22,\\x22player_assisted\\x22\\x3Anull,\\x22lastAction\\x22\\x3A\\x22Dispossessed\\x22\\x7D,\\x7B\\x22id\\x22\\x3A\\x22392509\\x22,\\x22minute\\x22\\x3A\\x2262\\x22,\\x22result\\x22\\x3A\\x22SavedShot\\x22,\\x22X\\x22\\x3A\\x220.9080000305175782\\x22,\\x22Y\\x22\\x3A\\x220.5940000152587891\\x22,\\x22xG\\x22\\x3A\\x220.11746534705162048\\x22,\\x22player\\x22\\x3A\\x22Lionel\\x20Messi\\x22,\\x22h_a\\x22\\x3A\\x22h\\x22,\\x22player_id\\x22\\x3A\\x222097\\x22,\\x22situation\\x22\\x3A\\x22OpenPlay\\x22,\\x22season\\x22\\x3A\\x222020\\x22,\\x22shotType\\x22\\x3A\\x22LeftFoot\\x22,\\x22match_id\\x22\\x3A\\x2214898\\x22,\\x22h_team\\x22\\x3A\\x22Barcelona\\x22,\\x22a_team\\x22\\x3A\\x22Levante\\x22,\\x22h_goals\\x22\\x3A\\x221\\x22,\\x22a_goals\\x22\\x3A\\x220\\x22,\\x22date\\x22\\x3A\\x222020\\x2D12\\x2D13\\x2020\\x3A00\\x3A00\\x22,\\x22player_assisted\\x22\\x3A\\x22Antoine\\x20Griezmann\\x22,\\x22lastAction\\x22\\x3A\\x22Pass\\x22\\x7D,\\x7B\\x22id\\x22\\x3A\\x22392510\\x22,\\x22minute\\x22\\x3A\\x2264\\x22,\\x22result\\x22\\x3A\\x22SavedShot\\x22,\\x22X\\x22\\x3A\\x220.7369999694824219\\x22,\\x22Y\\x22\\x3A\\x220.47299999237060547\\x22,\\x22xG\\x22\\x3A\\x220.06325993686914444\\x22,\\x22player\\x22\\x3A\\x22Lionel\\x20Messi\\x22,\\x22h_a\\x22\\x3A\\x22h\\x22,\\x22player_id\\x22\\x3A\\x222097\\x22,\\x22situation\\x22\\x3A\\x22DirectFreekick\\x22,\\x22season\\x22\\x3A\\x222020\\x22,\\x22shotType\\x22\\x3A\\x22LeftFoot\\x22,\\x22match_id\\x22\\x3A\\x2214898\\x22,\\x22h_team\\x22\\x3A\\x22Barcelona\\x22,\\x22a_team\\x22\\x3A\\x22Levante\\x22,\\x22h_goals\\x22\\x3A\\x221\\x22,\\x22a_goals\\x22\\x3A\\x220\\x22,\\x22date\\x22\\x3A\\x222020\\x2D12\\x2D13\\x2020\\x3A00\\x3A00\\x22,\\x22player_assisted\\x22\\x3Anull,\\x22lastAction\\x22\\x3A\\x22Standard\\x22\\x7D,\\x7B\\x22id\\x22\\x3A\\x22392511\\x22,\\x22minute\\x22\\x3A\\x2270\\x22,\\x22result\\x22\\x3A\\x22SavedShot\\x22,\\x22X\\x22\\x3A\\x220.9769999694824218\\x22,\\x22Y\\x22\\x3A\\x220.6569999694824219\\x22,\\x22xG\\x22\\x3A\\x220.06019793823361397\\x22,\\x22player\\x22\\x3A\\x22Lionel\\x20Messi\\x22,\\x22h_a\\x22\\x3A\\x22h\\x22,\\x22player_id\\x22\\x3A\\x222097\\x22,\\x22situation\\x22\\x3A\\x22OpenPlay\\x22,\\x22season\\x22\\x3A\\x222020\\x22,\\x22shotType\\x22\\x3A\\x22LeftFoot\\x22,\\x22match_id\\x22\\x3A\\x2214898\\x22,\\x22h_team\\x22\\x3A\\x22Barcelona\\x22,\\x22a_team\\x22\\x3A\\x22Levante\\x22,\\x22h_goals\\x22\\x3A\\x221\\x22,\\x22a_goals\\x22\\x3A\\x220\\x22,\\x22date\\x22\\x3A\\x222020\\x2D12\\x2D13\\x2020\\x3A00\\x3A00\\x22,\\x22player_assisted\\x22\\x3Anull,\\x22lastAction\\x22\\x3A\\x22None\\x22\\x7D,\\x7B\\x22id\\x22\\x3A\\x22392512\\x22,\\x22minute\\x22\\x3A\\x2271\\x22,\\x22result\\x22\\x3A\\x22MissedShots\\x22,\\x22X\\x22\\x3A\\x220.9340000152587891\\x22,\\x22Y\\x22\\x3A\\x220.4570000076293945\\x22,\\x22xG\\x22\\x3A\\x220.3572489619255066\\x22,\\x22player\\x22\\x3A\\x22Martin\\x20Braithwaite\\x22,\\x22h_a\\x22\\x3A\\x22h\\x22,\\x22player_id\\x22\\x3A\\x223211\\x22,\\x22situation\\x22\\x3A\\x22FromCorner\\x22,\\x22season\\x22\\x3A\\x222020\\x22,\\x22shotType\\x22\\x3A\\x22Head\\x22,\\x22match_id\\x22\\x3A\\x2214898\\x22,\\x22h_team\\x22\\x3A\\x22Barcelona\\x22,\\x22a_team\\x22\\x3A\\x22Levante\\x22,\\x22h_goals\\x22\\x3A\\x221\\x22,\\x22a_goals\\x22\\x3A\\x220\\x22,\\x22date\\x22\\x3A\\x222020\\x2D12\\x2D13\\x2020\\x3A00\\x3A00\\x22,\\x22player_assisted\\x22\\x3A\\x22Lionel\\x20Messi\\x22,\\x22lastAction\\x22\\x3A\\x22Cross\\x22\\x7D,\\x7B\\x22id\\x22\\x3A\\x22392513\\x22,\\x22minute\\x22\\x3A\\x2275\\x22,\\x22result\\x22\\x3A\\x22Goal\\x22,\\x22X\\x22\\x3A\\x220.879000015258789\\x22,\\x22Y\\x22\\x3A\\x220.6190000152587891\\x22,\\x22xG\\x22\\x3A\\x220.30587369203567505\\x22,\\x22player\\x22\\x3A\\x22Lionel\\x20Messi\\x22,\\x22h_a\\x22\\x3A\\x22h\\x22,\\x22player_id\\x22\\x3A\\x222097\\x22,\\x22situation\\x22\\x3A\\x22OpenPlay\\x22,\\x22season\\x22\\x3A\\x222020\\x22,\\x22shotType\\x22\\x3A\\x22LeftFoot\\x22,\\x22match_id\\x22\\x3A\\x2214898\\x22,\\x22h_team\\x22\\x3A\\x22Barcelona\\x22,\\x22a_team\\x22\\x3A\\x22Levante\\x22,\\x22h_goals\\x22\\x3A\\x221\\x22,\\x22a_goals\\x22\\x3A\\x220\\x22,\\x22date\\x22\\x3A\\x222020\\x2D12\\x2D13\\x2020\\x3A00\\x3A00\\x22,\\x22player_assisted\\x22\\x3A\\x22Frenkie\\x20de\\x20Jong\\x22,\\x22lastAction\\x22\\x3A\\x22Pass\\x22\\x7D,\\x7B\\x22id\\x22\\x3A\\x22392514\\x22,\\x22minute\\x22\\x3A\\x2280\\x22,\\x22result\\x22\\x3A\\x22SavedShot\\x22,\\x22X\\x22\\x3A\\x220.96\\x22,\\x22Y\\x22\\x3A\\x220.639000015258789\\x22,\\x22xG\\x22\\x3A\\x220.10610634088516235\\x22,\\x22player\\x22\\x3A\\x22Lionel\\x20Messi\\x22,\\x22h_a\\x22\\x3A\\x22h\\x22,\\x22player_id\\x22\\x3A\\x222097\\x22,\\x22situation\\x22\\x3A\\x22OpenPlay\\x22,\\x22season\\x22\\x3A\\x222020\\x22,\\x22shotType\\x22\\x3A\\x22LeftFoot\\x22,\\x22match_id\\x22\\x3A\\x2214898\\x22,\\x22h_team\\x22\\x3A\\x22Barcelona\\x22,\\x22a_team\\x22\\x3A\\x22Levante\\x22,\\x22h_goals\\x22\\x3A\\x221\\x22,\\x22a_goals\\x22\\x3A\\x220\\x22,\\x22date\\x22\\x3A\\x222020\\x2D12\\x2D13\\x2020\\x3A00\\x3A00\\x22,\\x22player_assisted\\x22\\x3A\\x22Martin\\x20Braithwaite\\x22,\\x22lastAction\\x22\\x3A\\x22Pass\\x22\\x7D\\x5D,\\x22a\\x22\\x3A\\x5B\\x7B\\x22id\\x22\\x3A\\x22392488\\x22,\\x22minute\\x22\\x3A\\x2211\\x22,\\x22result\\x22\\x3A\\x22SavedShot\\x22,\\x22X\\x22\\x3A\\x220.91\\x22,\\x22Y\\x22\\x3A\\x220.534000015258789\\x22,\\x22xG\\x22\\x3A\\x220.4909251630306244\\x22,\\x22player\\x22\\x3A\\x22Jorge\\x20De\\x20Frutos\\x22,\\x22h_a\\x22\\x3A\\x22a\\x22,\\x22player_id\\x22\\x3A\\x228107\\x22,\\x22situation\\x22\\x3A\\x22OpenPlay\\x22,\\x22season\\x22\\x3A\\x222020\\x22,\\x22shotType\\x22\\x3A\\x22LeftFoot\\x22,\\x22match_id\\x22\\x3A\\x2214898\\x22,\\x22h_team\\x22\\x3A\\x22Barcelona\\x22,\\x22a_team\\x22\\x3A\\x22Levante\\x22,\\x22h_goals\\x22\\x3A\\x221\\x22,\\x22a_goals\\x22\\x3A\\x220\\x22,\\x22date\\x22\\x3A\\x222020\\x2D12\\x2D13\\x2020\\x3A00\\x3A00\\x22,\\x22player_assisted\\x22\\x3A\\x22Gonzalo\\x20Melero\\x22,\\x22lastAction\\x22\\x3A\\x22Pass\\x22\\x7D,\\x7B\\x22id\\x22\\x3A\\x22392491\\x22,\\x22minute\\x22\\x3A\\x2218\\x22,\\x22result\\x22\\x3A\\x22MissedShots\\x22,\\x22X\\x22\\x3A\\x220.9419999694824219\\x22,\\x22Y\\x22\\x3A\\x220.3920000076293945\\x22,\\x22xG\\x22\\x3A\\x220.3912094235420227\\x22,\\x22player\\x22\\x3A\\x22Dani\\x20G\\x5Cu00f3mez\\x22,\\x22h_a\\x22\\x3A\\x22a\\x22,\\x22player_id\\x22\\x3A\\x228774\\x22,\\x22situation\\x22\\x3A\\x22OpenPlay\\x22,\\x22season\\x22\\x3A\\x222020\\x22,\\x22shotType\\x22\\x3A\\x22RightFoot\\x22,\\x22match_id\\x22\\x3A\\x2214898\\x22,\\x22h_team\\x22\\x3A\\x22Barcelona\\x22,\\x22a_team\\x22\\x3A\\x22Levante\\x22,\\x22h_goals\\x22\\x3A\\x221\\x22,\\x22a_goals\\x22\\x3A\\x220\\x22,\\x22date\\x22\\x3A\\x222020\\x2D12\\x2D13\\x2020\\x3A00\\x3A00\\x22,\\x22player_assisted\\x22\\x3A\\x22Roger\\x22,\\x22lastAction\\x22\\x3A\\x22Throughball\\x22\\x7D,\\x7B\\x22id\\x22\\x3A\\x22392495\\x22,\\x22minute\\x22\\x3A\\x2224\\x22,\\x22result\\x22\\x3A\\x22MissedShots\\x22,\\x22X\\x22\\x3A\\x220.794000015258789\\x22,\\x22Y\\x22\\x3A\\x220.25799999237060545\\x22,\\x22xG\\x22\\x3A\\x220.022036507725715637\\x22,\\x22player\\x22\\x3A\\x22Coke\\x22,\\x22h_a\\x22\\x3A\\x22a\\x22,\\x22player_id\\x22\\x3A\\x222073\\x22,\\x22situation\\x22\\x3A\\x22OpenPlay\\x22,\\x22season\\x22\\x3A\\x222020\\x22,\\x22shotType\\x22\\x3A\\x22RightFoot\\x22,\\x22match_id\\x22\\x3A\\x2214898\\x22,\\x22h_team\\x22\\x3A\\x22Barcelona\\x22,\\x22a_team\\x22\\x3A\\x22Levante\\x22,\\x22h_goals\\x22\\x3A\\x221\\x22,\\x22a_goals\\x22\\x3A\\x220\\x22,\\x22date\\x22\\x3A\\x222020\\x2D12\\x2D13\\x2020\\x3A00\\x3A00\\x22,\\x22player_assisted\\x22\\x3A\\x22Gonzalo\\x20Melero\\x22,\\x22lastAction\\x22\\x3A\\x22Pass\\x22\\x7D,\\x7B\\x22id\\x22\\x3A\\x22392497\\x22,\\x22minute\\x22\\x3A\\x2227\\x22,\\x22result\\x22\\x3A\\x22SavedShot\\x22,\\x22X\\x22\\x3A\\x220.7390000152587891\\x22,\\x22Y\\x22\\x3A\\x220.46900001525878904\\x22,\\x22xG\\x22\\x3A\\x220.029262805357575417\\x22,\\x22player\\x22\\x3A\\x22Dani\\x20G\\x5Cu00f3mez\\x22,\\x22h_a\\x22\\x3A\\x22a\\x22,\\x22player_id\\x22\\x3A\\x228774\\x22,\\x22situation\\x22\\x3A\\x22FromCorner\\x22,\\x22season\\x22\\x3A\\x222020\\x22,\\x22shotType\\x22\\x3A\\x22RightFoot\\x22,\\x22match_id\\x22\\x3A\\x2214898\\x22,\\x22h_team\\x22\\x3A\\x22Barcelona\\x22,\\x22a_team\\x22\\x3A\\x22Levante\\x22,\\x22h_goals\\x22\\x3A\\x221\\x22,\\x22a_goals\\x22\\x3A\\x220\\x22,\\x22date\\x22\\x3A\\x222020\\x2D12\\x2D13\\x2020\\x3A00\\x3A00\\x22,\\x22player_assisted\\x22\\x3A\\x22Micka\\x5Cu00ebl\\x20Malsa\\x22,\\x22lastAction\\x22\\x3A\\x22Pass\\x22\\x7D,\\x7B\\x22id\\x22\\x3A\\x22392515\\x22,\\x22minute\\x22\\x3A\\x2292\\x22,\\x22result\\x22\\x3A\\x22BlockedShot\\x22,\\x22X\\x22\\x3A\\x220.7719999694824219\\x22,\\x22Y\\x22\\x3A\\x220.34900001525878904\\x22,\\x22xG\\x22\\x3A\\x220.023837022483348846\\x22,\\x22player\\x22\\x3A\\x22Morales\\x22,\\x22h_a\\x22\\x3A\\x22a\\x22,\\x22player_id\\x22\\x3A\\x222186\\x22,\\x22situation\\x22\\x3A\\x22OpenPlay\\x22,\\x22season\\x22\\x3A\\x222020\\x22,\\x22shotType\\x22\\x3A\\x22RightFoot\\x22,\\x22match_id\\x22\\x3A\\x2214898\\x22,\\x22h_team\\x22\\x3A\\x22Barcelona\\x22,\\x22a_team\\x22\\x3A\\x22Levante\\x22,\\x22h_goals\\x22\\x3A\\x221\\x22,\\x22a_goals\\x22\\x3A\\x220\\x22,\\x22date\\x22\\x3A\\x222020\\x2D12\\x2D13\\x2020\\x3A00\\x3A00\\x22,\\x22player_assisted\\x22\\x3A\\x22Son\\x22,\\x22lastAction\\x22\\x3A\\x22Pass\\x22\\x7D,\\x7B\\x22id\\x22\\x3A\\x22392516\\x22,\\x22minute\\x22\\x3A\\x2295\\x22,\\x22result\\x22\\x3A\\x22SavedShot\\x22,\\x22X\\x22\\x3A\\x220.7869999694824219\\x22,\\x22Y\\x22\\x3A\\x220.36400001525878906\\x22,\\x22xG\\x22\\x3A\\x220.021608645096421242\\x22,\\x22player\\x22\\x3A\\x22Son\\x22,\\x22h_a\\x22\\x3A\\x22a\\x22,\\x22player_id\\x22\\x3A\\x228775\\x22,\\x22situation\\x22\\x3A\\x22FromCorner\\x22,\\x22season\\x22\\x3A\\x222020\\x22,\\x22shotType\\x22\\x3A\\x22RightFoot\\x22,\\x22match_id\\x22\\x3A\\x2214898\\x22,\\x22h_team\\x22\\x3A\\x22Barcelona\\x22,\\x22a_team\\x22\\x3A\\x22Levante\\x22,\\x22h_goals\\x22\\x3A\\x221\\x22,\\x22a_goals\\x22\\x3A\\x220\\x22,\\x22date\\x22\\x3A\\x222020\\x2D12\\x2D13\\x2020\\x3A00\\x3A00\\x22,\\x22player_assisted\\x22\\x3Anull,\\x22lastAction\\x22\\x3A\\x22None\\x22\\x7D\\x5D\\x7D'),\n\t\tmatch_info \t= JSON.parse('\\x7B\\x22id\\x22\\x3A\\x2214898\\x22,\\x22fid\\x22\\x3A\\x221492065\\x22,\\x22h\\x22\\x3A\\x22148\\x22,\\x22a\\x22\\x3A\\x22151\\x22,\\x22date\\x22\\x3A\\x222020\\x2D12\\x2D13\\x2020\\x3A00\\x3A00\\x22,\\x22league_id\\x22\\x3A\\x224\\x22,\\x22season\\x22\\x3A\\x222020\\x22,\\x22h_goals\\x22\\x3A\\x221\\x22,\\x22a_goals\\x22\\x3A\\x220\\x22,\\x22team_h\\x22\\x3A\\x22Barcelona\\x22,\\x22team_a\\x22\\x3A\\x22Levante\\x22,\\x22h_xg\\x22\\x3A\\x222.62077\\x22,\\x22a_xg\\x22\\x3A\\x220.97888\\x22,\\x22h_w\\x22\\x3A\\x220.7777\\x22,\\x22h_d\\x22\\x3A\\x220.1608\\x22,\\x22h_l\\x22\\x3A\\x220.0615\\x22,\\x22league\\x22\\x3A\\x22La\\x20liga\\x22,\\x22h_shot\\x22\\x3A\\x2224\\x22,\\x22a_shot\\x22\\x3A\\x226\\x22,\\x22h_shotOnTarget\\x22\\x3A\\x2213\\x22,\\x22a_shotOnTarget\\x22\\x3A\\x223\\x22,\\x22h_deep\\x22\\x3A\\x2219\\x22,\\x22a_deep\\x22\\x3A\\x225\\x22,\\x22a_ppda\\x22\\x3A\\x2218.3750\\x22,\\x22h_ppda\\x22\\x3A\\x2215.8667\\x22\\x7D');\n"

In [29]:

# strip unnecessary symbols and get only JSON data 
ind_start = strings.index("('")+2 
ind_end = strings.index("')") 
json_data = strings[ind_start:ind_end] 
json_data = json_data.encode('utf8').decode('unicode_escape')

#convert string to json format
data = json.loads(json_data)

In [30]:

data

Out[30]:

{'h': [{'id': '392487',
   'minute': '1',
   'result': 'MissedShots',
   'X': '0.8880000305175781',
   'Y': '0.43099998474121093',
   'xG': '0.110611192882061',
   'player': 'Philippe Coutinho',
   'h_a': 'h',
   'player_id': '488',
   'situation': 'OpenPlay',
   'season': '2020',
   'shotType': 'RightFoot',
   'match_id': '14898',
   'h_team': 'Barcelona',
   'a_team': 'Levante',
   'h_goals': '1',
   'a_goals': '0',
   'date': '2020-12-13 20:00:00',
   'player_assisted': 'Sergiño Dest',
   'lastAction': 'Pass'},
  {'id': '392489',
   'minute': '12',
   'result': 'BlockedShot',
   'X': '0.855999984741211',
   'Y': '0.6759999847412109',
   'xG': '0.04891153424978256',
   'player': 'Lionel Messi',
   'h_a': 'h',
   'player_id': '2097',
   'situation': 'OpenPlay',
   'season': '2020',
   'shotType': 'LeftFoot',
   'match_id': '14898',
   'h_team': 'Barcelona',
   'a_team': 'Levante',
   'h_goals': '1',
   'a_goals': '0',
   'date': '2020-12-13 20:00:00',
   'player_assisted': 'Jordi Alba',
   'lastAction': 'Pass'},
  {'id': '392490',
   'minute': '15',
   'result': 'SavedShot',
   'X': '0.855999984741211',
   'Y': '0.725999984741211',
   'xG': '0.032116737216711044',
   'player': 'Martin Braithwaite',
   'h_a': 'h',
   'player_id': '3211',
   'situation': 'OpenPlay',
   'season': '2020',
   'shotType': 'RightFoot',
   'match_id': '14898',
   'h_team': 'Barcelona',
   'a_team': 'Levante',
   'h_goals': '1',
   'a_goals': '0',
   'date': '2020-12-13 20:00:00',
   'player_assisted': 'Antoine Griezmann',
   'lastAction': 'Pass'},
  {'id': '392492',
   'minute': '19',
   'result': 'SavedShot',
   'X': '0.8669999694824219',
   'Y': '0.3220000076293945',
   'xG': '0.04845098406076431',
   'player': 'Antoine Griezmann',
   'h_a': 'h',
   'player_id': '2270',
   'situation': 'OpenPlay',
   'season': '2020',
   'shotType': 'RightFoot',
   'match_id': '14898',
   'h_team': 'Barcelona',
   'a_team': 'Levante',
   'h_goals': '1',
   'a_goals': '0',
   'date': '2020-12-13 20:00:00',
   'player_assisted': 'Frenkie de Jong',
   'lastAction': 'Pass'},
  {'id': '392493',
   'minute': '21',
   'result': 'SavedShot',
   'X': '0.9109999847412109',
   'Y': '0.43',
   'xG': '0.29747647047042847',
   'player': 'Antoine Griezmann',
   'h_a': 'h',
   'player_id': '2270',
   'situation': 'SetPiece',
   'season': '2020',
   'shotType': 'Head',
   'match_id': '14898',
   'h_team': 'Barcelona',
   'a_team': 'Levante',
   'h_goals': '1',
   'a_goals': '0',
   'date': '2020-12-13 20:00:00',
   'player_assisted': 'Lionel Messi',
   'lastAction': 'Chipped'},
  {'id': '392494',
   'minute': '21',
   'result': 'MissedShots',
   'X': '0.9690000152587891',
   'Y': '0.5279999923706055',
   'xG': '0.7536893486976624',
   'player': 'Clement Lenglet',
   'h_a': 'h',
   'player_id': '5050',
   'situation': 'SetPiece',
   'season': '2020',
   'shotType': 'LeftFoot',
   'match_id': '14898',
   'h_team': 'Barcelona',
   'a_team': 'Levante',
   'h_goals': '1',
   'a_goals': '0',
   'date': '2020-12-13 20:00:00',
   'player_assisted': None,
   'lastAction': 'Rebound'},
  {'id': '392496',
   'minute': '25',
   'result': 'MissedShots',
   'X': '0.89',
   'Y': '0.51',
   'xG': '0.08828572183847427',
   'player': 'Lionel Messi',
   'h_a': 'h',
   'player_id': '2097',
   'situation': 'OpenPlay',
   'season': '2020',
   'shotType': 'Head',
   'match_id': '14898',
   'h_team': 'Barcelona',
   'a_team': 'Levante',
   'h_goals': '1',
   'a_goals': '0',
   'date': '2020-12-13 20:00:00',
   'player_assisted': 'Antoine Griezmann',
   'lastAction': 'Cross'},
  {'id': '392498',
   'minute': '29',
   'result': 'MissedShots',
   'X': '0.8230000305175781',
   'Y': '0.3509999847412109',
   'xG': '0.03806573152542114',
   'player': 'Lionel Messi',
   'h_a': 'h',
   'player_id': '2097',
   'situation': 'OpenPlay',
   'season': '2020',
   'shotType': 'LeftFoot',
   'match_id': '14898',
   'h_team': 'Barcelona',
   'a_team': 'Levante',
   'h_goals': '1',
   'a_goals': '0',
   'date': '2020-12-13 20:00:00',
   'player_assisted': 'Frenkie de Jong',
   'lastAction': 'Pass'},
  {'id': '392499',
   'minute': '36',
   'result': 'BlockedShot',
   'X': '0.7559999847412109',
   'Y': '0.33',
   'xG': '0.05780152603983879',
   'player': 'Lionel Messi',
   'h_a': 'h',
   'player_id': '2097',
   'situation': 'DirectFreekick',
   'season': '2020',
   'shotType': 'LeftFoot',
   'match_id': '14898',
   'h_team': 'Barcelona',
   'a_team': 'Levante',
   'h_goals': '1',
   'a_goals': '0',
   'date': '2020-12-13 20:00:00',
   'player_assisted': None,
   'lastAction': 'Standard'},
  {'id': '392500',
   'minute': '37',
   'result': 'SavedShot',
   'X': '0.815',
   'Y': '0.72',
   'xG': '0.019371867179870605',
   'player': 'Jordi Alba',
   'h_a': 'h',
   'player_id': '2093',
   'situation': 'FromCorner',
   'season': '2020',
   'shotType': 'LeftFoot',
   'match_id': '14898',
   'h_team': 'Barcelona',
   'a_team': 'Levante',
   'h_goals': '1',
   'a_goals': '0',
   'date': '2020-12-13 20:00:00',
   'player_assisted': None,
   'lastAction': 'None'},
  {'id': '392501',
   'minute': '39',
   'result': 'SavedShot',
   'X': '0.909000015258789',
   'Y': '0.4159999847412109',
   'xG': '0.0710151344537735',
   'player': 'Antoine Griezmann',
   'h_a': 'h',
   'player_id': '2270',
   'situation': 'SetPiece',
   'season': '2020',
   'shotType': 'RightFoot',
   'match_id': '14898',
   'h_team': 'Barcelona',
   'a_team': 'Levante',
   'h_goals': '1',
   'a_goals': '0',
   'date': '2020-12-13 20:00:00',
   'player_assisted': 'Lionel Messi',
   'lastAction': 'Cross'},
  {'id': '392502',
   'minute': '42',
   'result': 'SavedShot',
   'X': '0.730999984741211',
   'Y': '0.5690000152587891',
   'xG': '0.05699247121810913',
   'player': 'Lionel Messi',
   'h_a': 'h',
   'player_id': '2097',
   'situation': 'DirectFreekick',
   'season': '2020',
   'shotType': 'LeftFoot',
   'match_id': '14898',
   'h_team': 'Barcelona',
   'a_team': 'Levante',
   'h_goals': '1',
   'a_goals': '0',
   'date': '2020-12-13 20:00:00',
   'player_assisted': None,
   'lastAction': 'Standard'},
  {'id': '392503',
   'minute': '42',
   'result': 'SavedShot',
   'X': '0.475',
   'Y': '0.750999984741211',
   'xG': '0.007011083420366049',
   'player': 'Jordi Alba',
   'h_a': 'h',
   'player_id': '2093',
   'situation': 'OpenPlay',
   'season': '2020',
   'shotType': 'LeftFoot',
   'match_id': '14898',
   'h_team': 'Barcelona',
   'a_team': 'Levante',
   'h_goals': '1',
   'a_goals': '0',
   'date': '2020-12-13 20:00:00',
   'player_assisted': 'Martin Braithwaite',
   'lastAction': 'BallRecovery'},
  {'id': '392504',
   'minute': '50',
   'result': 'BlockedShot',
   'X': '0.9680000305175781',
   'Y': '0.6480000305175782',
   'xG': '0.072198785841465',
   'player': 'Lionel Messi',
   'h_a': 'h',
   'player_id': '2097',
   'situation': 'OpenPlay',
   'season': '2020',
   'shotType': 'LeftFoot',
   'match_id': '14898',
   'h_team': 'Barcelona',
   'a_team': 'Levante',
   'h_goals': '1',
   'a_goals': '0',
   'date': '2020-12-13 20:00:00',
   'player_assisted': 'Jordi Alba',
   'lastAction': 'Pass'},
  {'id': '392505',
   'minute': '51',
   'result': 'MissedShots',
   'X': '0.8569999694824219',
   'Y': '0.720999984741211',
   'xG': '0.032172270119190216',
   'player': 'Philippe Coutinho',
   'h_a': 'h',
   'player_id': '488',
   'situation': 'OpenPlay',
   'season': '2020',
   'shotType': 'RightFoot',
   'match_id': '14898',
   'h_team': 'Barcelona',
   'a_team': 'Levante',
   'h_goals': '1',
   'a_goals': '0',
   'date': '2020-12-13 20:00:00',
   'player_assisted': 'Frenkie de Jong',
   'lastAction': 'Pass'},
  {'id': '392506',
   'minute': '53',
   'result': 'MissedShots',
   'X': '0.8009999847412109',
   'Y': '0.595999984741211',
   'xG': '0.03635625168681145',
   'player': 'Lionel Messi',
   'h_a': 'h',
   'player_id': '2097',
   'situation': 'OpenPlay',
   'season': '2020',
   'shotType': 'LeftFoot',
   'match_id': '14898',
   'h_team': 'Barcelona',
   'a_team': 'Levante',
   'h_goals': '1',
   'a_goals': '0',
   'date': '2020-12-13 20:00:00',
   'player_assisted': 'Antoine Griezmann',
   'lastAction': 'Pass'},
  {'id': '392507',
   'minute': '55',
   'result': 'SavedShot',
   'X': '0.7819999694824219',
   'Y': '0.6020000076293945',
   'xG': '0.04149062559008598',
   'player': 'Philippe Coutinho',
   'h_a': 'h',
   'player_id': '488',
   'situation': 'OpenPlay',
   'season': '2020',
   'shotType': 'RightFoot',
   'match_id': '14898',
   'h_team': 'Barcelona',
   'a_team': 'Levante',
   'h_goals': '1',
   'a_goals': '0',
   'date': '2020-12-13 20:00:00',
   'player_assisted': 'Frenkie de Jong',
   'lastAction': 'LayOff'},
  {'id': '392508',
   'minute': '61',
   'result': 'MissedShots',
   'X': '0.76',
   'Y': '0.3940000152587891',
   'xG': '0.02280627191066742',
   'player': 'Antoine Griezmann',
   'h_a': 'h',
   'player_id': '2270',
   'situation': 'OpenPlay',
   'season': '2020',
   'shotType': 'LeftFoot',
   'match_id': '14898',
   'h_team': 'Barcelona',
   'a_team': 'Levante',
   'h_goals': '1',
   'a_goals': '0',
   'date': '2020-12-13 20:00:00',
   'player_assisted': None,
   'lastAction': 'Dispossessed'},
  {'id': '392509',
   'minute': '62',
   'result': 'SavedShot',
   'X': '0.9080000305175782',
   'Y': '0.5940000152587891',
   'xG': '0.11746534705162048',
   'player': 'Lionel Messi',
   'h_a': 'h',
   'player_id': '2097',
   'situation': 'OpenPlay',
   'season': '2020',
   'shotType': 'LeftFoot',
   'match_id': '14898',
   'h_team': 'Barcelona',
   'a_team': 'Levante',
   'h_goals': '1',
   'a_goals': '0',
   'date': '2020-12-13 20:00:00',
   'player_assisted': 'Antoine Griezmann',
   'lastAction': 'Pass'},
  {'id': '392510',
   'minute': '64',
   'result': 'SavedShot',
   'X': '0.7369999694824219',
   'Y': '0.47299999237060547',
   'xG': '0.06325993686914444',
   'player': 'Lionel Messi',
   'h_a': 'h',
   'player_id': '2097',
   'situation': 'DirectFreekick',
   'season': '2020',
   'shotType': 'LeftFoot',
   'match_id': '14898',
   'h_team': 'Barcelona',
   'a_team': 'Levante',
   'h_goals': '1',
   'a_goals': '0',
   'date': '2020-12-13 20:00:00',
   'player_assisted': None,
   'lastAction': 'Standard'},
  {'id': '392511',
   'minute': '70',
   'result': 'SavedShot',
   'X': '0.9769999694824218',
   'Y': '0.6569999694824219',
   'xG': '0.06019793823361397',
   'player': 'Lionel Messi',
   'h_a': 'h',
   'player_id': '2097',
   'situation': 'OpenPlay',
   'season': '2020',
   'shotType': 'LeftFoot',
   'match_id': '14898',
   'h_team': 'Barcelona',
   'a_team': 'Levante',
   'h_goals': '1',
   'a_goals': '0',
   'date': '2020-12-13 20:00:00',
   'player_assisted': None,
   'lastAction': 'None'},
  {'id': '392512',
   'minute': '71',
   'result': 'MissedShots',
   'X': '0.9340000152587891',
   'Y': '0.4570000076293945',
   'xG': '0.3572489619255066',
   'player': 'Martin Braithwaite',
   'h_a': 'h',
   'player_id': '3211',
   'situation': 'FromCorner',
   'season': '2020',
   'shotType': 'Head',
   'match_id': '14898',
   'h_team': 'Barcelona',
   'a_team': 'Levante',
   'h_goals': '1',
   'a_goals': '0',
   'date': '2020-12-13 20:00:00',
   'player_assisted': 'Lionel Messi',
   'lastAction': 'Cross'},
  {'id': '392513',
   'minute': '75',
   'result': 'Goal',
   'X': '0.879000015258789',
   'Y': '0.6190000152587891',
   'xG': '0.30587369203567505',
   'player': 'Lionel Messi',
   'h_a': 'h',
   'player_id': '2097',
   'situation': 'OpenPlay',
   'season': '2020',
   'shotType': 'LeftFoot',
   'match_id': '14898',
   'h_team': 'Barcelona',
   'a_team': 'Levante',
   'h_goals': '1',
   'a_goals': '0',
   'date': '2020-12-13 20:00:00',
   'player_assisted': 'Frenkie de Jong',
   'lastAction': 'Pass'},
  {'id': '392514',
   'minute': '80',
   'result': 'SavedShot',
   'X': '0.96',
   'Y': '0.639000015258789',
   'xG': '0.10610634088516235',
   'player': 'Lionel Messi',
   'h_a': 'h',
   'player_id': '2097',
   'situation': 'OpenPlay',
   'season': '2020',
   'shotType': 'LeftFoot',
   'match_id': '14898',
   'h_team': 'Barcelona',
   'a_team': 'Levante',
   'h_goals': '1',
   'a_goals': '0',
   'date': '2020-12-13 20:00:00',
   'player_assisted': 'Martin Braithwaite',
   'lastAction': 'Pass'}],
 'a': [{'id': '392488',
   'minute': '11',
   'result': 'SavedShot',
   'X': '0.91',
   'Y': '0.534000015258789',
   'xG': '0.4909251630306244',
   'player': 'Jorge De Frutos',
   'h_a': 'a',
   'player_id': '8107',
   'situation': 'OpenPlay',
   'season': '2020',
   'shotType': 'LeftFoot',
   'match_id': '14898',
   'h_team': 'Barcelona',
   'a_team': 'Levante',
   'h_goals': '1',
   'a_goals': '0',
   'date': '2020-12-13 20:00:00',
   'player_assisted': 'Gonzalo Melero',
   'lastAction': 'Pass'},
  {'id': '392491',
   'minute': '18',
   'result': 'MissedShots',
   'X': '0.9419999694824219',
   'Y': '0.3920000076293945',
   'xG': '0.3912094235420227',
   'player': 'Dani Gómez',
   'h_a': 'a',
   'player_id': '8774',
   'situation': 'OpenPlay',
   'season': '2020',
   'shotType': 'RightFoot',
   'match_id': '14898',
   'h_team': 'Barcelona',
   'a_team': 'Levante',
   'h_goals': '1',
   'a_goals': '0',
   'date': '2020-12-13 20:00:00',
   'player_assisted': 'Roger',
   'lastAction': 'Throughball'},
  {'id': '392495',
   'minute': '24',
   'result': 'MissedShots',
   'X': '0.794000015258789',
   'Y': '0.25799999237060545',
   'xG': '0.022036507725715637',
   'player': 'Coke',
   'h_a': 'a',
   'player_id': '2073',
   'situation': 'OpenPlay',
   'season': '2020',
   'shotType': 'RightFoot',
   'match_id': '14898',
   'h_team': 'Barcelona',
   'a_team': 'Levante',
   'h_goals': '1',
   'a_goals': '0',
   'date': '2020-12-13 20:00:00',
   'player_assisted': 'Gonzalo Melero',
   'lastAction': 'Pass'},
  {'id': '392497',
   'minute': '27',
   'result': 'SavedShot',
   'X': '0.7390000152587891',
   'Y': '0.46900001525878904',
   'xG': '0.029262805357575417',
   'player': 'Dani Gómez',
   'h_a': 'a',
   'player_id': '8774',
   'situation': 'FromCorner',
   'season': '2020',
   'shotType': 'RightFoot',
   'match_id': '14898',
   'h_team': 'Barcelona',
   'a_team': 'Levante',
   'h_goals': '1',
   'a_goals': '0',
   'date': '2020-12-13 20:00:00',
   'player_assisted': 'Mickaël Malsa',
   'lastAction': 'Pass'},
  {'id': '392515',
   'minute': '92',
   'result': 'BlockedShot',
   'X': '0.7719999694824219',
   'Y': '0.34900001525878904',
   'xG': '0.023837022483348846',
   'player': 'Morales',
   'h_a': 'a',
   'player_id': '2186',
   'situation': 'OpenPlay',
   'season': '2020',
   'shotType': 'RightFoot',
   'match_id': '14898',
   'h_team': 'Barcelona',
   'a_team': 'Levante',
   'h_goals': '1',
   'a_goals': '0',
   'date': '2020-12-13 20:00:00',
   'player_assisted': 'Son',
   'lastAction': 'Pass'},
  {'id': '392516',
   'minute': '95',
   'result': 'SavedShot',
   'X': '0.7869999694824219',
   'Y': '0.36400001525878906',
   'xG': '0.021608645096421242',
   'player': 'Son',
   'h_a': 'a',
   'player_id': '8775',
   'situation': 'FromCorner',
   'season': '2020',
   'shotType': 'RightFoot',
   'match_id': '14898',
   'h_team': 'Barcelona',
   'a_team': 'Levante',
   'h_goals': '1',
   'a_goals': '0',
   'date': '2020-12-13 20:00:00',
   'player_assisted': None,
   'lastAction': 'None'}]}

In [31]:

x = []
y = []
xG = []
result = []
team = []
data_away = data['a']
data_home = data['h']

for index in range(len(data_home)):
    for key in data_home[index]:
        if key == 'X':
            x.append(data_home[index][key])
        if key == 'Y':
            y.append(data_home[index][key])
        if key == 'h_team':
            team.append(data_home[index][key])
        if key == 'xG':
            xG.append(data_home[index][key])
        if key == 'result':
            result.append(data_home[index][key])

for index in range(len(data_away)):
    for key in data_away[index]:
        if key == 'X':
            x.append(data_away[index][key])
        if key == 'Y':
            y.append(data_away[index][key])
        if key == 'a_team':
            team.append(data_away[index][key])
        if key == 'xG':
            xG.append(data_away[index][key])
        if key == 'result':
            result.append(data_away[index][key])

In [32]:

col_names = ['x','y','xG','result','team']
df = pd.DataFrame([x,y,xG,result,team],index=col_names)
df = df.T

In [33]:

df

Out[33]:

	x	y	xG	result	team
0	0.8880000305175781	0.43099998474121093	0.110611192882061	MissedShots	Barcelona
1	0.855999984741211	0.6759999847412109	0.04891153424978256	BlockedShot	Barcelona
2	0.855999984741211	0.725999984741211	0.032116737216711044	SavedShot	Barcelona
3	0.8669999694824219	0.3220000076293945	0.04845098406076431	SavedShot	Barcelona
4	0.9109999847412109	0.43	0.29747647047042847	SavedShot	Barcelona
5	0.9690000152587891	0.5279999923706055	0.7536893486976624	MissedShots	Barcelona
6	0.89	0.51	0.08828572183847427	MissedShots	Barcelona
7	0.8230000305175781	0.3509999847412109	0.03806573152542114	MissedShots	Barcelona
8	0.7559999847412109	0.33	0.05780152603983879	BlockedShot	Barcelona
9	0.815	0.72	0.019371867179870605	SavedShot	Barcelona
10	0.909000015258789	0.4159999847412109	0.0710151344537735	SavedShot	Barcelona
11	0.730999984741211	0.5690000152587891	0.05699247121810913	SavedShot	Barcelona
12	0.475	0.750999984741211	0.007011083420366049	SavedShot	Barcelona
13	0.9680000305175781	0.6480000305175782	0.072198785841465	BlockedShot	Barcelona
14	0.8569999694824219	0.720999984741211	0.032172270119190216	MissedShots	Barcelona
15	0.8009999847412109	0.595999984741211	0.03635625168681145	MissedShots	Barcelona
16	0.7819999694824219	0.6020000076293945	0.04149062559008598	SavedShot	Barcelona
17	0.76	0.3940000152587891	0.02280627191066742	MissedShots	Barcelona
18	0.9080000305175782	0.5940000152587891	0.11746534705162048	SavedShot	Barcelona
19	0.7369999694824219	0.47299999237060547	0.06325993686914444	SavedShot	Barcelona
20	0.9769999694824218	0.6569999694824219	0.06019793823361397	SavedShot	Barcelona
21	0.9340000152587891	0.4570000076293945	0.3572489619255066	MissedShots	Barcelona
22	0.879000015258789	0.6190000152587891	0.30587369203567505	Goal	Barcelona
23	0.96	0.639000015258789	0.10610634088516235	SavedShot	Barcelona
24	0.91	0.534000015258789	0.4909251630306244	SavedShot	Levante
25	0.9419999694824219	0.3920000076293945	0.3912094235420227	MissedShots	Levante
26	0.794000015258789	0.25799999237060545	0.022036507725715637	MissedShots	Levante
27	0.7390000152587891	0.46900001525878904	0.029262805357575417	SavedShot	Levante
28	0.7719999694824219	0.34900001525878904	0.023837022483348846	BlockedShot	Levante
29	0.7869999694824219	0.36400001525878906	0.021608645096421242	SavedShot	Levante

In [ ]: