Understat Scraper.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "from bs4 import BeautifulSoup\n",
    "import json\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Please enter the match id: 14898\n"
     ]
    }
   ],
   "source": [
    "#scrape a single game shots. We will allow users to enter a base url\n",
    "base_url = 'https://understat.com/match/'\n",
    "match = str(input('Please enter the match id: '))\n",
    "url = base_url+match"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Use requests to get the webpage and BeautifulSoup to parse the page\n",
    "res = requests.get(url)\n",
    "soup = BeautifulSoup(res.content, 'lxml')\n",
    "scripts = soup.find_all('script')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "#get only the shotsData\n",
    "strings = scripts[1].string"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "\"\\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\""
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "strings"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "# strip unnecessary symbols and get only JSON data \n",
    "ind_start = strings.index(\"('\")+2 \n",
    "ind_end = strings.index(\"')\") \n",
    "json_data = strings[ind_start:ind_end] \n",
    "json_data = json_data.encode('utf8').decode('unicode_escape')\n",
    "\n",
    "#convert string to json format\n",
    "data = json.loads(json_data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'h': [{'id': '392487',\n",
       "   'minute': '1',\n",
       "   'result': 'MissedShots',\n",
       "   'X': '0.8880000305175781',\n",
       "   'Y': '0.43099998474121093',\n",
       "   'xG': '0.110611192882061',\n",
       "   'player': 'Philippe Coutinho',\n",
       "   'h_a': 'h',\n",
       "   'player_id': '488',\n",
       "   'situation': 'OpenPlay',\n",
       "   'season': '2020',\n",
       "   'shotType': 'RightFoot',\n",
       "   'match_id': '14898',\n",
       "   'h_team': 'Barcelona',\n",
       "   'a_team': 'Levante',\n",
       "   'h_goals': '1',\n",
       "   'a_goals': '0',\n",
       "   'date': '2020-12-13 20:00:00',\n",
       "   'player_assisted': 'Sergiño Dest',\n",
       "   'lastAction': 'Pass'},\n",
       "  {'id': '392489',\n",
       "   'minute': '12',\n",
       "   'result': 'BlockedShot',\n",
       "   'X': '0.855999984741211',\n",
       "   'Y': '0.6759999847412109',\n",
       "   'xG': '0.04891153424978256',\n",
       "   'player': 'Lionel Messi',\n",
       "   'h_a': 'h',\n",
       "   'player_id': '2097',\n",
       "   'situation': 'OpenPlay',\n",
       "   'season': '2020',\n",
       "   'shotType': 'LeftFoot',\n",
       "   'match_id': '14898',\n",
       "   'h_team': 'Barcelona',\n",
       "   'a_team': 'Levante',\n",
       "   'h_goals': '1',\n",
       "   'a_goals': '0',\n",
       "   'date': '2020-12-13 20:00:00',\n",
       "   'player_assisted': 'Jordi Alba',\n",
       "   'lastAction': 'Pass'},\n",
       "  {'id': '392490',\n",
       "   'minute': '15',\n",
       "   'result': 'SavedShot',\n",
       "   'X': '0.855999984741211',\n",
       "   'Y': '0.725999984741211',\n",
       "   'xG': '0.032116737216711044',\n",
       "   'player': 'Martin Braithwaite',\n",
       "   'h_a': 'h',\n",
       "   'player_id': '3211',\n",
       "   'situation': 'OpenPlay',\n",
       "   'season': '2020',\n",
       "   'shotType': 'RightFoot',\n",
       "   'match_id': '14898',\n",
       "   'h_team': 'Barcelona',\n",
       "   'a_team': 'Levante',\n",
       "   'h_goals': '1',\n",
       "   'a_goals': '0',\n",
       "   'date': '2020-12-13 20:00:00',\n",
       "   'player_assisted': 'Antoine Griezmann',\n",
       "   'lastAction': 'Pass'},\n",
       "  {'id': '392492',\n",
       "   'minute': '19',\n",
       "   'result': 'SavedShot',\n",
       "   'X': '0.8669999694824219',\n",
       "   'Y': '0.3220000076293945',\n",
       "   'xG': '0.04845098406076431',\n",
       "   'player': 'Antoine Griezmann',\n",
       "   'h_a': 'h',\n",
       "   'player_id': '2270',\n",
       "   'situation': 'OpenPlay',\n",
       "   'season': '2020',\n",
       "   'shotType': 'RightFoot',\n",
       "   'match_id': '14898',\n",
       "   'h_team': 'Barcelona',\n",
       "   'a_team': 'Levante',\n",
       "   'h_goals': '1',\n",
       "   'a_goals': '0',\n",
       "   'date': '2020-12-13 20:00:00',\n",
       "   'player_assisted': 'Frenkie de Jong',\n",
       "   'lastAction': 'Pass'},\n",
       "  {'id': '392493',\n",
       "   'minute': '21',\n",
       "   'result': 'SavedShot',\n",
       "   'X': '0.9109999847412109',\n",
       "   'Y': '0.43',\n",
       "   'xG': '0.29747647047042847',\n",
       "   'player': 'Antoine Griezmann',\n",
       "   'h_a': 'h',\n",
       "   'player_id': '2270',\n",
       "   'situation': 'SetPiece',\n",
       "   'season': '2020',\n",
       "   'shotType': 'Head',\n",
       "   'match_id': '14898',\n",
       "   'h_team': 'Barcelona',\n",
       "   'a_team': 'Levante',\n",
       "   'h_goals': '1',\n",
       "   'a_goals': '0',\n",
       "   'date': '2020-12-13 20:00:00',\n",
       "   'player_assisted': 'Lionel Messi',\n",
       "   'lastAction': 'Chipped'},\n",
       "  {'id': '392494',\n",
       "   'minute': '21',\n",
       "   'result': 'MissedShots',\n",
       "   'X': '0.9690000152587891',\n",
       "   'Y': '0.5279999923706055',\n",
       "   'xG': '0.7536893486976624',\n",
       "   'player': 'Clement Lenglet',\n",
       "   'h_a': 'h',\n",
       "   'player_id': '5050',\n",
       "   'situation': 'SetPiece',\n",
       "   'season': '2020',\n",
       "   'shotType': 'LeftFoot',\n",
       "   'match_id': '14898',\n",
       "   'h_team': 'Barcelona',\n",
       "   'a_team': 'Levante',\n",
       "   'h_goals': '1',\n",
       "   'a_goals': '0',\n",
       "   'date': '2020-12-13 20:00:00',\n",
       "   'player_assisted': None,\n",
       "   'lastAction': 'Rebound'},\n",
       "  {'id': '392496',\n",
       "   'minute': '25',\n",
       "   'result': 'MissedShots',\n",
       "   'X': '0.89',\n",
       "   'Y': '0.51',\n",
       "   'xG': '0.08828572183847427',\n",
       "   'player': 'Lionel Messi',\n",
       "   'h_a': 'h',\n",
       "   'player_id': '2097',\n",
       "   'situation': 'OpenPlay',\n",
       "   'season': '2020',\n",
       "   'shotType': 'Head',\n",
       "   'match_id': '14898',\n",
       "   'h_team': 'Barcelona',\n",
       "   'a_team': 'Levante',\n",
       "   'h_goals': '1',\n",
       "   'a_goals': '0',\n",
       "   'date': '2020-12-13 20:00:00',\n",
       "   'player_assisted': 'Antoine Griezmann',\n",
       "   'lastAction': 'Cross'},\n",
       "  {'id': '392498',\n",
       "   'minute': '29',\n",
       "   'result': 'MissedShots',\n",
       "   'X': '0.8230000305175781',\n",
       "   'Y': '0.3509999847412109',\n",
       "   'xG': '0.03806573152542114',\n",
       "   'player': 'Lionel Messi',\n",
       "   'h_a': 'h',\n",
       "   'player_id': '2097',\n",
       "   'situation': 'OpenPlay',\n",
       "   'season': '2020',\n",
       "   'shotType': 'LeftFoot',\n",
       "   'match_id': '14898',\n",
       "   'h_team': 'Barcelona',\n",
       "   'a_team': 'Levante',\n",
       "   'h_goals': '1',\n",
       "   'a_goals': '0',\n",
       "   'date': '2020-12-13 20:00:00',\n",
       "   'player_assisted': 'Frenkie de Jong',\n",
       "   'lastAction': 'Pass'},\n",
       "  {'id': '392499',\n",
       "   'minute': '36',\n",
       "   'result': 'BlockedShot',\n",
       "   'X': '0.7559999847412109',\n",
       "   'Y': '0.33',\n",
       "   'xG': '0.05780152603983879',\n",
       "   'player': 'Lionel Messi',\n",
       "   'h_a': 'h',\n",
       "   'player_id': '2097',\n",
       "   'situation': 'DirectFreekick',\n",
       "   'season': '2020',\n",
       "   'shotType': 'LeftFoot',\n",
       "   'match_id': '14898',\n",
       "   'h_team': 'Barcelona',\n",
       "   'a_team': 'Levante',\n",
       "   'h_goals': '1',\n",
       "   'a_goals': '0',\n",
       "   'date': '2020-12-13 20:00:00',\n",
       "   'player_assisted': None,\n",
       "   'lastAction': 'Standard'},\n",
       "  {'id': '392500',\n",
       "   'minute': '37',\n",
       "   'result': 'SavedShot',\n",
       "   'X': '0.815',\n",
       "   'Y': '0.72',\n",
       "   'xG': '0.019371867179870605',\n",
       "   'player': 'Jordi Alba',\n",
       "   'h_a': 'h',\n",
       "   'player_id': '2093',\n",
       "   'situation': 'FromCorner',\n",
       "   'season': '2020',\n",
       "   'shotType': 'LeftFoot',\n",
       "   'match_id': '14898',\n",
       "   'h_team': 'Barcelona',\n",
       "   'a_team': 'Levante',\n",
       "   'h_goals': '1',\n",
       "   'a_goals': '0',\n",
       "   'date': '2020-12-13 20:00:00',\n",
       "   'player_assisted': None,\n",
       "   'lastAction': 'None'},\n",
       "  {'id': '392501',\n",
       "   'minute': '39',\n",
       "   'result': 'SavedShot',\n",
       "   'X': '0.909000015258789',\n",
       "   'Y': '0.4159999847412109',\n",
       "   'xG': '0.0710151344537735',\n",
       "   'player': 'Antoine Griezmann',\n",
       "   'h_a': 'h',\n",
       "   'player_id': '2270',\n",
       "   'situation': 'SetPiece',\n",
       "   'season': '2020',\n",
       "   'shotType': 'RightFoot',\n",
       "   'match_id': '14898',\n",
       "   'h_team': 'Barcelona',\n",
       "   'a_team': 'Levante',\n",
       "   'h_goals': '1',\n",
       "   'a_goals': '0',\n",
       "   'date': '2020-12-13 20:00:00',\n",
       "   'player_assisted': 'Lionel Messi',\n",
       "   'lastAction': 'Cross'},\n",
       "  {'id': '392502',\n",
       "   'minute': '42',\n",
       "   'result': 'SavedShot',\n",
       "   'X': '0.730999984741211',\n",
       "   'Y': '0.5690000152587891',\n",
       "   'xG': '0.05699247121810913',\n",
       "   'player': 'Lionel Messi',\n",
       "   'h_a': 'h',\n",
       "   'player_id': '2097',\n",
       "   'situation': 'DirectFreekick',\n",
       "   'season': '2020',\n",
       "   'shotType': 'LeftFoot',\n",
       "   'match_id': '14898',\n",
       "   'h_team': 'Barcelona',\n",
       "   'a_team': 'Levante',\n",
       "   'h_goals': '1',\n",
       "   'a_goals': '0',\n",
       "   'date': '2020-12-13 20:00:00',\n",
       "   'player_assisted': None,\n",
       "   'lastAction': 'Standard'},\n",
       "  {'id': '392503',\n",
       "   'minute': '42',\n",
       "   'result': 'SavedShot',\n",
       "   'X': '0.475',\n",
       "   'Y': '0.750999984741211',\n",
       "   'xG': '0.007011083420366049',\n",
       "   'player': 'Jordi Alba',\n",
       "   'h_a': 'h',\n",
       "   'player_id': '2093',\n",
       "   'situation': 'OpenPlay',\n",
       "   'season': '2020',\n",
       "   'shotType': 'LeftFoot',\n",
       "   'match_id': '14898',\n",
       "   'h_team': 'Barcelona',\n",
       "   'a_team': 'Levante',\n",
       "   'h_goals': '1',\n",
       "   'a_goals': '0',\n",
       "   'date': '2020-12-13 20:00:00',\n",
       "   'player_assisted': 'Martin Braithwaite',\n",
       "   'lastAction': 'BallRecovery'},\n",
       "  {'id': '392504',\n",
       "   'minute': '50',\n",
       "   'result': 'BlockedShot',\n",
       "   'X': '0.9680000305175781',\n",
       "   'Y': '0.6480000305175782',\n",
       "   'xG': '0.072198785841465',\n",
       "   'player': 'Lionel Messi',\n",
       "   'h_a': 'h',\n",
       "   'player_id': '2097',\n",
       "   'situation': 'OpenPlay',\n",
       "   'season': '2020',\n",
       "   'shotType': 'LeftFoot',\n",
       "   'match_id': '14898',\n",
       "   'h_team': 'Barcelona',\n",
       "   'a_team': 'Levante',\n",
       "   'h_goals': '1',\n",
       "   'a_goals': '0',\n",
       "   'date': '2020-12-13 20:00:00',\n",
       "   'player_assisted': 'Jordi Alba',\n",
       "   'lastAction': 'Pass'},\n",
       "  {'id': '392505',\n",
       "   'minute': '51',\n",
       "   'result': 'MissedShots',\n",
       "   'X': '0.8569999694824219',\n",
       "   'Y': '0.720999984741211',\n",
       "   'xG': '0.032172270119190216',\n",
       "   'player': 'Philippe Coutinho',\n",
       "   'h_a': 'h',\n",
       "   'player_id': '488',\n",
       "   'situation': 'OpenPlay',\n",
       "   'season': '2020',\n",
       "   'shotType': 'RightFoot',\n",
       "   'match_id': '14898',\n",
       "   'h_team': 'Barcelona',\n",
       "   'a_team': 'Levante',\n",
       "   'h_goals': '1',\n",
       "   'a_goals': '0',\n",
       "   'date': '2020-12-13 20:00:00',\n",
       "   'player_assisted': 'Frenkie de Jong',\n",
       "   'lastAction': 'Pass'},\n",
       "  {'id': '392506',\n",
       "   'minute': '53',\n",
       "   'result': 'MissedShots',\n",
       "   'X': '0.8009999847412109',\n",
       "   'Y': '0.595999984741211',\n",
       "   'xG': '0.03635625168681145',\n",
       "   'player': 'Lionel Messi',\n",
       "   'h_a': 'h',\n",
       "   'player_id': '2097',\n",
       "   'situation': 'OpenPlay',\n",
       "   'season': '2020',\n",
       "   'shotType': 'LeftFoot',\n",
       "   'match_id': '14898',\n",
       "   'h_team': 'Barcelona',\n",
       "   'a_team': 'Levante',\n",
       "   'h_goals': '1',\n",
       "   'a_goals': '0',\n",
       "   'date': '2020-12-13 20:00:00',\n",
       "   'player_assisted': 'Antoine Griezmann',\n",
       "   'lastAction': 'Pass'},\n",
       "  {'id': '392507',\n",
       "   'minute': '55',\n",
       "   'result': 'SavedShot',\n",
       "   'X': '0.7819999694824219',\n",
       "   'Y': '0.6020000076293945',\n",
       "   'xG': '0.04149062559008598',\n",
       "   'player': 'Philippe Coutinho',\n",
       "   'h_a': 'h',\n",
       "   'player_id': '488',\n",
       "   'situation': 'OpenPlay',\n",
       "   'season': '2020',\n",
       "   'shotType': 'RightFoot',\n",
       "   'match_id': '14898',\n",
       "   'h_team': 'Barcelona',\n",
       "   'a_team': 'Levante',\n",
       "   'h_goals': '1',\n",
       "   'a_goals': '0',\n",
       "   'date': '2020-12-13 20:00:00',\n",
       "   'player_assisted': 'Frenkie de Jong',\n",
       "   'lastAction': 'LayOff'},\n",
       "  {'id': '392508',\n",
       "   'minute': '61',\n",
       "   'result': 'MissedShots',\n",
       "   'X': '0.76',\n",
       "   'Y': '0.3940000152587891',\n",
       "   'xG': '0.02280627191066742',\n",
       "   'player': 'Antoine Griezmann',\n",
       "   'h_a': 'h',\n",
       "   'player_id': '2270',\n",
       "   'situation': 'OpenPlay',\n",
       "   'season': '2020',\n",
       "   'shotType': 'LeftFoot',\n",
       "   'match_id': '14898',\n",
       "   'h_team': 'Barcelona',\n",
       "   'a_team': 'Levante',\n",
       "   'h_goals': '1',\n",
       "   'a_goals': '0',\n",
       "   'date': '2020-12-13 20:00:00',\n",
       "   'player_assisted': None,\n",
       "   'lastAction': 'Dispossessed'},\n",
       "  {'id': '392509',\n",
       "   'minute': '62',\n",
       "   'result': 'SavedShot',\n",
       "   'X': '0.9080000305175782',\n",
       "   'Y': '0.5940000152587891',\n",
       "   'xG': '0.11746534705162048',\n",
       "   'player': 'Lionel Messi',\n",
       "   'h_a': 'h',\n",
       "   'player_id': '2097',\n",
       "   'situation': 'OpenPlay',\n",
       "   'season': '2020',\n",
       "   'shotType': 'LeftFoot',\n",
       "   'match_id': '14898',\n",
       "   'h_team': 'Barcelona',\n",
       "   'a_team': 'Levante',\n",
       "   'h_goals': '1',\n",
       "   'a_goals': '0',\n",
       "   'date': '2020-12-13 20:00:00',\n",
       "   'player_assisted': 'Antoine Griezmann',\n",
       "   'lastAction': 'Pass'},\n",
       "  {'id': '392510',\n",
       "   'minute': '64',\n",
       "   'result': 'SavedShot',\n",
       "   'X': '0.7369999694824219',\n",
       "   'Y': '0.47299999237060547',\n",
       "   'xG': '0.06325993686914444',\n",
       "   'player': 'Lionel Messi',\n",
       "   'h_a': 'h',\n",
       "   'player_id': '2097',\n",
       "   'situation': 'DirectFreekick',\n",
       "   'season': '2020',\n",
       "   'shotType': 'LeftFoot',\n",
       "   'match_id': '14898',\n",
       "   'h_team': 'Barcelona',\n",
       "   'a_team': 'Levante',\n",
       "   'h_goals': '1',\n",
       "   'a_goals': '0',\n",
       "   'date': '2020-12-13 20:00:00',\n",
       "   'player_assisted': None,\n",
       "   'lastAction': 'Standard'},\n",
       "  {'id': '392511',\n",
       "   'minute': '70',\n",
       "   'result': 'SavedShot',\n",
       "   'X': '0.9769999694824218',\n",
       "   'Y': '0.6569999694824219',\n",
       "   'xG': '0.06019793823361397',\n",
       "   'player': 'Lionel Messi',\n",
       "   'h_a': 'h',\n",
       "   'player_id': '2097',\n",
       "   'situation': 'OpenPlay',\n",
       "   'season': '2020',\n",
       "   'shotType': 'LeftFoot',\n",
       "   'match_id': '14898',\n",
       "   'h_team': 'Barcelona',\n",
       "   'a_team': 'Levante',\n",
       "   'h_goals': '1',\n",
       "   'a_goals': '0',\n",
       "   'date': '2020-12-13 20:00:00',\n",
       "   'player_assisted': None,\n",
       "   'lastAction': 'None'},\n",
       "  {'id': '392512',\n",
       "   'minute': '71',\n",
       "   'result': 'MissedShots',\n",
       "   'X': '0.9340000152587891',\n",
       "   'Y': '0.4570000076293945',\n",
       "   'xG': '0.3572489619255066',\n",
       "   'player': 'Martin Braithwaite',\n",
       "   'h_a': 'h',\n",
       "   'player_id': '3211',\n",
       "   'situation': 'FromCorner',\n",
       "   'season': '2020',\n",
       "   'shotType': 'Head',\n",
       "   'match_id': '14898',\n",
       "   'h_team': 'Barcelona',\n",
       "   'a_team': 'Levante',\n",
       "   'h_goals': '1',\n",
       "   'a_goals': '0',\n",
       "   'date': '2020-12-13 20:00:00',\n",
       "   'player_assisted': 'Lionel Messi',\n",
       "   'lastAction': 'Cross'},\n",
       "  {'id': '392513',\n",
       "   'minute': '75',\n",
       "   'result': 'Goal',\n",
       "   'X': '0.879000015258789',\n",
       "   'Y': '0.6190000152587891',\n",
       "   'xG': '0.30587369203567505',\n",
       "   'player': 'Lionel Messi',\n",
       "   'h_a': 'h',\n",
       "   'player_id': '2097',\n",
       "   'situation': 'OpenPlay',\n",
       "   'season': '2020',\n",
       "   'shotType': 'LeftFoot',\n",
       "   'match_id': '14898',\n",
       "   'h_team': 'Barcelona',\n",
       "   'a_team': 'Levante',\n",
       "   'h_goals': '1',\n",
       "   'a_goals': '0',\n",
       "   'date': '2020-12-13 20:00:00',\n",
       "   'player_assisted': 'Frenkie de Jong',\n",
       "   'lastAction': 'Pass'},\n",
       "  {'id': '392514',\n",
       "   'minute': '80',\n",
       "   'result': 'SavedShot',\n",
       "   'X': '0.96',\n",
       "   'Y': '0.639000015258789',\n",
       "   'xG': '0.10610634088516235',\n",
       "   'player': 'Lionel Messi',\n",
       "   'h_a': 'h',\n",
       "   'player_id': '2097',\n",
       "   'situation': 'OpenPlay',\n",
       "   'season': '2020',\n",
       "   'shotType': 'LeftFoot',\n",
       "   'match_id': '14898',\n",
       "   'h_team': 'Barcelona',\n",
       "   'a_team': 'Levante',\n",
       "   'h_goals': '1',\n",
       "   'a_goals': '0',\n",
       "   'date': '2020-12-13 20:00:00',\n",
       "   'player_assisted': 'Martin Braithwaite',\n",
       "   'lastAction': 'Pass'}],\n",
       " 'a': [{'id': '392488',\n",
       "   'minute': '11',\n",
       "   'result': 'SavedShot',\n",
       "   'X': '0.91',\n",
       "   'Y': '0.534000015258789',\n",
       "   'xG': '0.4909251630306244',\n",
       "   'player': 'Jorge De Frutos',\n",
       "   'h_a': 'a',\n",
       "   'player_id': '8107',\n",
       "   'situation': 'OpenPlay',\n",
       "   'season': '2020',\n",
       "   'shotType': 'LeftFoot',\n",
       "   'match_id': '14898',\n",
       "   'h_team': 'Barcelona',\n",
       "   'a_team': 'Levante',\n",
       "   'h_goals': '1',\n",
       "   'a_goals': '0',\n",
       "   'date': '2020-12-13 20:00:00',\n",
       "   'player_assisted': 'Gonzalo Melero',\n",
       "   'lastAction': 'Pass'},\n",
       "  {'id': '392491',\n",
       "   'minute': '18',\n",
       "   'result': 'MissedShots',\n",
       "   'X': '0.9419999694824219',\n",
       "   'Y': '0.3920000076293945',\n",
       "   'xG': '0.3912094235420227',\n",
       "   'player': 'Dani Gómez',\n",
       "   'h_a': 'a',\n",
       "   'player_id': '8774',\n",
       "   'situation': 'OpenPlay',\n",
       "   'season': '2020',\n",
       "   'shotType': 'RightFoot',\n",
       "   'match_id': '14898',\n",
       "   'h_team': 'Barcelona',\n",
       "   'a_team': 'Levante',\n",
       "   'h_goals': '1',\n",
       "   'a_goals': '0',\n",
       "   'date': '2020-12-13 20:00:00',\n",
       "   'player_assisted': 'Roger',\n",
       "   'lastAction': 'Throughball'},\n",
       "  {'id': '392495',\n",
       "   'minute': '24',\n",
       "   'result': 'MissedShots',\n",
       "   'X': '0.794000015258789',\n",
       "   'Y': '0.25799999237060545',\n",
       "   'xG': '0.022036507725715637',\n",
       "   'player': 'Coke',\n",
       "   'h_a': 'a',\n",
       "   'player_id': '2073',\n",
       "   'situation': 'OpenPlay',\n",
       "   'season': '2020',\n",
       "   'shotType': 'RightFoot',\n",
       "   'match_id': '14898',\n",
       "   'h_team': 'Barcelona',\n",
       "   'a_team': 'Levante',\n",
       "   'h_goals': '1',\n",
       "   'a_goals': '0',\n",
       "   'date': '2020-12-13 20:00:00',\n",
       "   'player_assisted': 'Gonzalo Melero',\n",
       "   'lastAction': 'Pass'},\n",
       "  {'id': '392497',\n",
       "   'minute': '27',\n",
       "   'result': 'SavedShot',\n",
       "   'X': '0.7390000152587891',\n",
       "   'Y': '0.46900001525878904',\n",
       "   'xG': '0.029262805357575417',\n",
       "   'player': 'Dani Gómez',\n",
       "   'h_a': 'a',\n",
       "   'player_id': '8774',\n",
       "   'situation': 'FromCorner',\n",
       "   'season': '2020',\n",
       "   'shotType': 'RightFoot',\n",
       "   'match_id': '14898',\n",
       "   'h_team': 'Barcelona',\n",
       "   'a_team': 'Levante',\n",
       "   'h_goals': '1',\n",
       "   'a_goals': '0',\n",
       "   'date': '2020-12-13 20:00:00',\n",
       "   'player_assisted': 'Mickaël Malsa',\n",
       "   'lastAction': 'Pass'},\n",
       "  {'id': '392515',\n",
       "   'minute': '92',\n",
       "   'result': 'BlockedShot',\n",
       "   'X': '0.7719999694824219',\n",
       "   'Y': '0.34900001525878904',\n",
       "   'xG': '0.023837022483348846',\n",
       "   'player': 'Morales',\n",
       "   'h_a': 'a',\n",
       "   'player_id': '2186',\n",
       "   'situation': 'OpenPlay',\n",
       "   'season': '2020',\n",
       "   'shotType': 'RightFoot',\n",
       "   'match_id': '14898',\n",
       "   'h_team': 'Barcelona',\n",
       "   'a_team': 'Levante',\n",
       "   'h_goals': '1',\n",
       "   'a_goals': '0',\n",
       "   'date': '2020-12-13 20:00:00',\n",
       "   'player_assisted': 'Son',\n",
       "   'lastAction': 'Pass'},\n",
       "  {'id': '392516',\n",
       "   'minute': '95',\n",
       "   'result': 'SavedShot',\n",
       "   'X': '0.7869999694824219',\n",
       "   'Y': '0.36400001525878906',\n",
       "   'xG': '0.021608645096421242',\n",
       "   'player': 'Son',\n",
       "   'h_a': 'a',\n",
       "   'player_id': '8775',\n",
       "   'situation': 'FromCorner',\n",
       "   'season': '2020',\n",
       "   'shotType': 'RightFoot',\n",
       "   'match_id': '14898',\n",
       "   'h_team': 'Barcelona',\n",
       "   'a_team': 'Levante',\n",
       "   'h_goals': '1',\n",
       "   'a_goals': '0',\n",
       "   'date': '2020-12-13 20:00:00',\n",
       "   'player_assisted': None,\n",
       "   'lastAction': 'None'}]}"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "x = []\n",
    "y = []\n",
    "xG = []\n",
    "result = []\n",
    "team = []\n",
    "data_away = data['a']\n",
    "data_home = data['h']\n",
    "\n",
    "for index in range(len(data_home)):\n",
    "    for key in data_home[index]:\n",
    "        if key == 'X':\n",
    "            x.append(data_home[index][key])\n",
    "        if key == 'Y':\n",
    "            y.append(data_home[index][key])\n",
    "        if key == 'h_team':\n",
    "            team.append(data_home[index][key])\n",
    "        if key == 'xG':\n",
    "            xG.append(data_home[index][key])\n",
    "        if key == 'result':\n",
    "            result.append(data_home[index][key])\n",
    "\n",
    "for index in range(len(data_away)):\n",
    "    for key in data_away[index]:\n",
    "        if key == 'X':\n",
    "            x.append(data_away[index][key])\n",
    "        if key == 'Y':\n",
    "            y.append(data_away[index][key])\n",
    "        if key == 'a_team':\n",
    "            team.append(data_away[index][key])\n",
    "        if key == 'xG':\n",
    "            xG.append(data_away[index][key])\n",
    "        if key == 'result':\n",
    "            result.append(data_away[index][key])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [],
   "source": [
    "col_names = ['x','y','xG','result','team']\n",
    "df = pd.DataFrame([x,y,xG,result,team],index=col_names)\n",
    "df = df.T"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>x</th>\n",
       "      <th>y</th>\n",
       "      <th>xG</th>\n",
       "      <th>result</th>\n",
       "      <th>team</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.8880000305175781</td>\n",
       "      <td>0.43099998474121093</td>\n",
       "      <td>0.110611192882061</td>\n",
       "      <td>MissedShots</td>\n",
       "      <td>Barcelona</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.855999984741211</td>\n",
       "      <td>0.6759999847412109</td>\n",
       "      <td>0.04891153424978256</td>\n",
       "      <td>BlockedShot</td>\n",
       "      <td>Barcelona</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.855999984741211</td>\n",
       "      <td>0.725999984741211</td>\n",
       "      <td>0.032116737216711044</td>\n",
       "      <td>SavedShot</td>\n",
       "      <td>Barcelona</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.8669999694824219</td>\n",
       "      <td>0.3220000076293945</td>\n",
       "      <td>0.04845098406076431</td>\n",
       "      <td>SavedShot</td>\n",
       "      <td>Barcelona</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.9109999847412109</td>\n",
       "      <td>0.43</td>\n",
       "      <td>0.29747647047042847</td>\n",
       "      <td>SavedShot</td>\n",
       "      <td>Barcelona</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0.9690000152587891</td>\n",
       "      <td>0.5279999923706055</td>\n",
       "      <td>0.7536893486976624</td>\n",
       "      <td>MissedShots</td>\n",
       "      <td>Barcelona</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0.89</td>\n",
       "      <td>0.51</td>\n",
       "      <td>0.08828572183847427</td>\n",
       "      <td>MissedShots</td>\n",
       "      <td>Barcelona</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0.8230000305175781</td>\n",
       "      <td>0.3509999847412109</td>\n",
       "      <td>0.03806573152542114</td>\n",
       "      <td>MissedShots</td>\n",
       "      <td>Barcelona</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0.7559999847412109</td>\n",
       "      <td>0.33</td>\n",
       "      <td>0.05780152603983879</td>\n",
       "      <td>BlockedShot</td>\n",
       "      <td>Barcelona</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>0.815</td>\n",
       "      <td>0.72</td>\n",
       "      <td>0.019371867179870605</td>\n",
       "      <td>SavedShot</td>\n",
       "      <td>Barcelona</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>0.909000015258789</td>\n",
       "      <td>0.4159999847412109</td>\n",
       "      <td>0.0710151344537735</td>\n",
       "      <td>SavedShot</td>\n",
       "      <td>Barcelona</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>0.730999984741211</td>\n",
       "      <td>0.5690000152587891</td>\n",
       "      <td>0.05699247121810913</td>\n",
       "      <td>SavedShot</td>\n",
       "      <td>Barcelona</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>0.475</td>\n",
       "      <td>0.750999984741211</td>\n",
       "      <td>0.007011083420366049</td>\n",
       "      <td>SavedShot</td>\n",
       "      <td>Barcelona</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>0.9680000305175781</td>\n",
       "      <td>0.6480000305175782</td>\n",
       "      <td>0.072198785841465</td>\n",
       "      <td>BlockedShot</td>\n",
       "      <td>Barcelona</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>0.8569999694824219</td>\n",
       "      <td>0.720999984741211</td>\n",
       "      <td>0.032172270119190216</td>\n",
       "      <td>MissedShots</td>\n",
       "      <td>Barcelona</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>0.8009999847412109</td>\n",
       "      <td>0.595999984741211</td>\n",
       "      <td>0.03635625168681145</td>\n",
       "      <td>MissedShots</td>\n",
       "      <td>Barcelona</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>0.7819999694824219</td>\n",
       "      <td>0.6020000076293945</td>\n",
       "      <td>0.04149062559008598</td>\n",
       "      <td>SavedShot</td>\n",
       "      <td>Barcelona</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>0.76</td>\n",
       "      <td>0.3940000152587891</td>\n",
       "      <td>0.02280627191066742</td>\n",
       "      <td>MissedShots</td>\n",
       "      <td>Barcelona</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>0.9080000305175782</td>\n",
       "      <td>0.5940000152587891</td>\n",
       "      <td>0.11746534705162048</td>\n",
       "      <td>SavedShot</td>\n",
       "      <td>Barcelona</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>0.7369999694824219</td>\n",
       "      <td>0.47299999237060547</td>\n",
       "      <td>0.06325993686914444</td>\n",
       "      <td>SavedShot</td>\n",
       "      <td>Barcelona</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>0.9769999694824218</td>\n",
       "      <td>0.6569999694824219</td>\n",
       "      <td>0.06019793823361397</td>\n",
       "      <td>SavedShot</td>\n",
       "      <td>Barcelona</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>0.9340000152587891</td>\n",
       "      <td>0.4570000076293945</td>\n",
       "      <td>0.3572489619255066</td>\n",
       "      <td>MissedShots</td>\n",
       "      <td>Barcelona</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>0.879000015258789</td>\n",
       "      <td>0.6190000152587891</td>\n",
       "      <td>0.30587369203567505</td>\n",
       "      <td>Goal</td>\n",
       "      <td>Barcelona</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>0.96</td>\n",
       "      <td>0.639000015258789</td>\n",
       "      <td>0.10610634088516235</td>\n",
       "      <td>SavedShot</td>\n",
       "      <td>Barcelona</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>0.91</td>\n",
       "      <td>0.534000015258789</td>\n",
       "      <td>0.4909251630306244</td>\n",
       "      <td>SavedShot</td>\n",
       "      <td>Levante</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>0.9419999694824219</td>\n",
       "      <td>0.3920000076293945</td>\n",
       "      <td>0.3912094235420227</td>\n",
       "      <td>MissedShots</td>\n",
       "      <td>Levante</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>0.794000015258789</td>\n",
       "      <td>0.25799999237060545</td>\n",
       "      <td>0.022036507725715637</td>\n",
       "      <td>MissedShots</td>\n",
       "      <td>Levante</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>0.7390000152587891</td>\n",
       "      <td>0.46900001525878904</td>\n",
       "      <td>0.029262805357575417</td>\n",
       "      <td>SavedShot</td>\n",
       "      <td>Levante</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>0.7719999694824219</td>\n",
       "      <td>0.34900001525878904</td>\n",
       "      <td>0.023837022483348846</td>\n",
       "      <td>BlockedShot</td>\n",
       "      <td>Levante</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>0.7869999694824219</td>\n",
       "      <td>0.36400001525878906</td>\n",
       "      <td>0.021608645096421242</td>\n",
       "      <td>SavedShot</td>\n",
       "      <td>Levante</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     x                    y                    xG  \\\n",
       "0   0.8880000305175781  0.43099998474121093     0.110611192882061   \n",
       "1    0.855999984741211   0.6759999847412109   0.04891153424978256   \n",
       "2    0.855999984741211    0.725999984741211  0.032116737216711044   \n",
       "3   0.8669999694824219   0.3220000076293945   0.04845098406076431   \n",
       "4   0.9109999847412109                 0.43   0.29747647047042847   \n",
       "5   0.9690000152587891   0.5279999923706055    0.7536893486976624   \n",
       "6                 0.89                 0.51   0.08828572183847427   \n",
       "7   0.8230000305175781   0.3509999847412109   0.03806573152542114   \n",
       "8   0.7559999847412109                 0.33   0.05780152603983879   \n",
       "9                0.815                 0.72  0.019371867179870605   \n",
       "10   0.909000015258789   0.4159999847412109    0.0710151344537735   \n",
       "11   0.730999984741211   0.5690000152587891   0.05699247121810913   \n",
       "12               0.475    0.750999984741211  0.007011083420366049   \n",
       "13  0.9680000305175781   0.6480000305175782     0.072198785841465   \n",
       "14  0.8569999694824219    0.720999984741211  0.032172270119190216   \n",
       "15  0.8009999847412109    0.595999984741211   0.03635625168681145   \n",
       "16  0.7819999694824219   0.6020000076293945   0.04149062559008598   \n",
       "17                0.76   0.3940000152587891   0.02280627191066742   \n",
       "18  0.9080000305175782   0.5940000152587891   0.11746534705162048   \n",
       "19  0.7369999694824219  0.47299999237060547   0.06325993686914444   \n",
       "20  0.9769999694824218   0.6569999694824219   0.06019793823361397   \n",
       "21  0.9340000152587891   0.4570000076293945    0.3572489619255066   \n",
       "22   0.879000015258789   0.6190000152587891   0.30587369203567505   \n",
       "23                0.96    0.639000015258789   0.10610634088516235   \n",
       "24                0.91    0.534000015258789    0.4909251630306244   \n",
       "25  0.9419999694824219   0.3920000076293945    0.3912094235420227   \n",
       "26   0.794000015258789  0.25799999237060545  0.022036507725715637   \n",
       "27  0.7390000152587891  0.46900001525878904  0.029262805357575417   \n",
       "28  0.7719999694824219  0.34900001525878904  0.023837022483348846   \n",
       "29  0.7869999694824219  0.36400001525878906  0.021608645096421242   \n",
       "\n",
       "         result       team  \n",
       "0   MissedShots  Barcelona  \n",
       "1   BlockedShot  Barcelona  \n",
       "2     SavedShot  Barcelona  \n",
       "3     SavedShot  Barcelona  \n",
       "4     SavedShot  Barcelona  \n",
       "5   MissedShots  Barcelona  \n",
       "6   MissedShots  Barcelona  \n",
       "7   MissedShots  Barcelona  \n",
       "8   BlockedShot  Barcelona  \n",
       "9     SavedShot  Barcelona  \n",
       "10    SavedShot  Barcelona  \n",
       "11    SavedShot  Barcelona  \n",
       "12    SavedShot  Barcelona  \n",
       "13  BlockedShot  Barcelona  \n",
       "14  MissedShots  Barcelona  \n",
       "15  MissedShots  Barcelona  \n",
       "16    SavedShot  Barcelona  \n",
       "17  MissedShots  Barcelona  \n",
       "18    SavedShot  Barcelona  \n",
       "19    SavedShot  Barcelona  \n",
       "20    SavedShot  Barcelona  \n",
       "21  MissedShots  Barcelona  \n",
       "22         Goal  Barcelona  \n",
       "23    SavedShot  Barcelona  \n",
       "24    SavedShot    Levante  \n",
       "25  MissedShots    Levante  \n",
       "26  MissedShots    Levante  \n",
       "27    SavedShot    Levante  \n",
       "28  BlockedShot    Levante  \n",
       "29    SavedShot    Levante  "
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}