K-Means clustering to cluster shot outcomes for Barcelona.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "from statsbombpy import sb\n",
    "import matplotlib.pyplot as plt\n",
    "from mplsoccer.pitch import Pitch\n",
    "import seaborn as sns\n",
    "import numpy as np\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.cluster import KMeans"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "credentials were not supplied. open data access only\n"
     ]
    },
    {
     "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>competition_id</th>\n",
       "      <th>season_id</th>\n",
       "      <th>country_name</th>\n",
       "      <th>competition_name</th>\n",
       "      <th>competition_gender</th>\n",
       "      <th>season_name</th>\n",
       "      <th>match_updated</th>\n",
       "      <th>match_available</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>16</td>\n",
       "      <td>4</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Champions League</td>\n",
       "      <td>male</td>\n",
       "      <td>2018/2019</td>\n",
       "      <td>2021-04-19T17:36:05.724116</td>\n",
       "      <td>2021-04-19T17:36:05.724116</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>16</td>\n",
       "      <td>1</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Champions League</td>\n",
       "      <td>male</td>\n",
       "      <td>2017/2018</td>\n",
       "      <td>2021-01-23T21:55:30.425330</td>\n",
       "      <td>2021-01-23T21:55:30.425330</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>16</td>\n",
       "      <td>2</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Champions League</td>\n",
       "      <td>male</td>\n",
       "      <td>2016/2017</td>\n",
       "      <td>2020-08-26T12:33:15.869622</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>16</td>\n",
       "      <td>27</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Champions League</td>\n",
       "      <td>male</td>\n",
       "      <td>2015/2016</td>\n",
       "      <td>2020-08-26T12:33:15.869622</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>16</td>\n",
       "      <td>26</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Champions League</td>\n",
       "      <td>male</td>\n",
       "      <td>2014/2015</td>\n",
       "      <td>2020-08-26T12:33:15.869622</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>16</td>\n",
       "      <td>25</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Champions League</td>\n",
       "      <td>male</td>\n",
       "      <td>2013/2014</td>\n",
       "      <td>2020-08-26T12:33:15.869622</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>16</td>\n",
       "      <td>24</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Champions League</td>\n",
       "      <td>male</td>\n",
       "      <td>2012/2013</td>\n",
       "      <td>2020-08-26T12:33:15.869622</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>16</td>\n",
       "      <td>23</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Champions League</td>\n",
       "      <td>male</td>\n",
       "      <td>2011/2012</td>\n",
       "      <td>2020-08-26T12:33:15.869622</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>16</td>\n",
       "      <td>22</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Champions League</td>\n",
       "      <td>male</td>\n",
       "      <td>2010/2011</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>16</td>\n",
       "      <td>21</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Champions League</td>\n",
       "      <td>male</td>\n",
       "      <td>2009/2010</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>16</td>\n",
       "      <td>41</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Champions League</td>\n",
       "      <td>male</td>\n",
       "      <td>2008/2009</td>\n",
       "      <td>2020-08-30T10:18:39.435424</td>\n",
       "      <td>2020-08-30T10:18:39.435424</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>16</td>\n",
       "      <td>39</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Champions League</td>\n",
       "      <td>male</td>\n",
       "      <td>2006/2007</td>\n",
       "      <td>2021-03-31T04:18:30.437060</td>\n",
       "      <td>2021-03-31T04:18:30.437060</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>16</td>\n",
       "      <td>37</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Champions League</td>\n",
       "      <td>male</td>\n",
       "      <td>2004/2005</td>\n",
       "      <td>2021-04-01T06:18:57.459032</td>\n",
       "      <td>2021-04-01T06:18:57.459032</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>16</td>\n",
       "      <td>44</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Champions League</td>\n",
       "      <td>male</td>\n",
       "      <td>2003/2004</td>\n",
       "      <td>2021-04-01T00:34:59.472485</td>\n",
       "      <td>2021-04-01T00:34:59.472485</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>16</td>\n",
       "      <td>76</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Champions League</td>\n",
       "      <td>male</td>\n",
       "      <td>1999/2000</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>37</td>\n",
       "      <td>42</td>\n",
       "      <td>England</td>\n",
       "      <td>FA Women's Super League</td>\n",
       "      <td>female</td>\n",
       "      <td>2019/2020</td>\n",
       "      <td>2020-10-20T18:35:33.568528</td>\n",
       "      <td>2020-10-20T18:35:33.568528</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>37</td>\n",
       "      <td>4</td>\n",
       "      <td>England</td>\n",
       "      <td>FA Women's Super League</td>\n",
       "      <td>female</td>\n",
       "      <td>2018/2019</td>\n",
       "      <td>2021-04-09T20:39:24.201269</td>\n",
       "      <td>2021-04-09T20:39:24.201269</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>43</td>\n",
       "      <td>3</td>\n",
       "      <td>International</td>\n",
       "      <td>FIFA World Cup</td>\n",
       "      <td>male</td>\n",
       "      <td>2018</td>\n",
       "      <td>2020-10-25T14:03:50.263266</td>\n",
       "      <td>2020-10-25T14:03:50.263266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>11</td>\n",
       "      <td>42</td>\n",
       "      <td>Spain</td>\n",
       "      <td>La Liga</td>\n",
       "      <td>male</td>\n",
       "      <td>2019/2020</td>\n",
       "      <td>2020-12-18T12:10:38.985394</td>\n",
       "      <td>2020-12-18T12:10:38.985394</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>11</td>\n",
       "      <td>4</td>\n",
       "      <td>Spain</td>\n",
       "      <td>La Liga</td>\n",
       "      <td>male</td>\n",
       "      <td>2018/2019</td>\n",
       "      <td>2021-04-20T03:24:51.029365</td>\n",
       "      <td>2021-04-20T03:24:51.029365</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>Spain</td>\n",
       "      <td>La Liga</td>\n",
       "      <td>male</td>\n",
       "      <td>2017/2018</td>\n",
       "      <td>2021-04-19T17:36:05.805404</td>\n",
       "      <td>2021-04-19T17:36:05.805404</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>11</td>\n",
       "      <td>2</td>\n",
       "      <td>Spain</td>\n",
       "      <td>La Liga</td>\n",
       "      <td>male</td>\n",
       "      <td>2016/2017</td>\n",
       "      <td>2021-02-02T23:24:58.985975</td>\n",
       "      <td>2021-02-02T23:24:58.985975</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>11</td>\n",
       "      <td>27</td>\n",
       "      <td>Spain</td>\n",
       "      <td>La Liga</td>\n",
       "      <td>male</td>\n",
       "      <td>2015/2016</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>11</td>\n",
       "      <td>26</td>\n",
       "      <td>Spain</td>\n",
       "      <td>La Liga</td>\n",
       "      <td>male</td>\n",
       "      <td>2014/2015</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>11</td>\n",
       "      <td>25</td>\n",
       "      <td>Spain</td>\n",
       "      <td>La Liga</td>\n",
       "      <td>male</td>\n",
       "      <td>2013/2014</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>11</td>\n",
       "      <td>24</td>\n",
       "      <td>Spain</td>\n",
       "      <td>La Liga</td>\n",
       "      <td>male</td>\n",
       "      <td>2012/2013</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>11</td>\n",
       "      <td>23</td>\n",
       "      <td>Spain</td>\n",
       "      <td>La Liga</td>\n",
       "      <td>male</td>\n",
       "      <td>2011/2012</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>11</td>\n",
       "      <td>22</td>\n",
       "      <td>Spain</td>\n",
       "      <td>La Liga</td>\n",
       "      <td>male</td>\n",
       "      <td>2010/2011</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>11</td>\n",
       "      <td>21</td>\n",
       "      <td>Spain</td>\n",
       "      <td>La Liga</td>\n",
       "      <td>male</td>\n",
       "      <td>2009/2010</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>11</td>\n",
       "      <td>41</td>\n",
       "      <td>Spain</td>\n",
       "      <td>La Liga</td>\n",
       "      <td>male</td>\n",
       "      <td>2008/2009</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>11</td>\n",
       "      <td>40</td>\n",
       "      <td>Spain</td>\n",
       "      <td>La Liga</td>\n",
       "      <td>male</td>\n",
       "      <td>2007/2008</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>11</td>\n",
       "      <td>39</td>\n",
       "      <td>Spain</td>\n",
       "      <td>La Liga</td>\n",
       "      <td>male</td>\n",
       "      <td>2006/2007</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>11</td>\n",
       "      <td>38</td>\n",
       "      <td>Spain</td>\n",
       "      <td>La Liga</td>\n",
       "      <td>male</td>\n",
       "      <td>2005/2006</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>11</td>\n",
       "      <td>37</td>\n",
       "      <td>Spain</td>\n",
       "      <td>La Liga</td>\n",
       "      <td>male</td>\n",
       "      <td>2004/2005</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>49</td>\n",
       "      <td>3</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>NWSL</td>\n",
       "      <td>female</td>\n",
       "      <td>2018</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>2</td>\n",
       "      <td>44</td>\n",
       "      <td>England</td>\n",
       "      <td>Premier League</td>\n",
       "      <td>male</td>\n",
       "      <td>2003/2004</td>\n",
       "      <td>2020-08-31T20:40:28.969635</td>\n",
       "      <td>2020-08-31T20:40:28.969635</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>72</td>\n",
       "      <td>30</td>\n",
       "      <td>International</td>\n",
       "      <td>Women's World Cup</td>\n",
       "      <td>female</td>\n",
       "      <td>2019</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    competition_id  season_id              country_name  \\\n",
       "0               16          4                    Europe   \n",
       "1               16          1                    Europe   \n",
       "2               16          2                    Europe   \n",
       "3               16         27                    Europe   \n",
       "4               16         26                    Europe   \n",
       "5               16         25                    Europe   \n",
       "6               16         24                    Europe   \n",
       "7               16         23                    Europe   \n",
       "8               16         22                    Europe   \n",
       "9               16         21                    Europe   \n",
       "10              16         41                    Europe   \n",
       "11              16         39                    Europe   \n",
       "12              16         37                    Europe   \n",
       "13              16         44                    Europe   \n",
       "14              16         76                    Europe   \n",
       "15              37         42                   England   \n",
       "16              37          4                   England   \n",
       "17              43          3             International   \n",
       "18              11         42                     Spain   \n",
       "19              11          4                     Spain   \n",
       "20              11          1                     Spain   \n",
       "21              11          2                     Spain   \n",
       "22              11         27                     Spain   \n",
       "23              11         26                     Spain   \n",
       "24              11         25                     Spain   \n",
       "25              11         24                     Spain   \n",
       "26              11         23                     Spain   \n",
       "27              11         22                     Spain   \n",
       "28              11         21                     Spain   \n",
       "29              11         41                     Spain   \n",
       "30              11         40                     Spain   \n",
       "31              11         39                     Spain   \n",
       "32              11         38                     Spain   \n",
       "33              11         37                     Spain   \n",
       "34              49          3  United States of America   \n",
       "35               2         44                   England   \n",
       "36              72         30             International   \n",
       "\n",
       "           competition_name competition_gender season_name  \\\n",
       "0          Champions League               male   2018/2019   \n",
       "1          Champions League               male   2017/2018   \n",
       "2          Champions League               male   2016/2017   \n",
       "3          Champions League               male   2015/2016   \n",
       "4          Champions League               male   2014/2015   \n",
       "5          Champions League               male   2013/2014   \n",
       "6          Champions League               male   2012/2013   \n",
       "7          Champions League               male   2011/2012   \n",
       "8          Champions League               male   2010/2011   \n",
       "9          Champions League               male   2009/2010   \n",
       "10         Champions League               male   2008/2009   \n",
       "11         Champions League               male   2006/2007   \n",
       "12         Champions League               male   2004/2005   \n",
       "13         Champions League               male   2003/2004   \n",
       "14         Champions League               male   1999/2000   \n",
       "15  FA Women's Super League             female   2019/2020   \n",
       "16  FA Women's Super League             female   2018/2019   \n",
       "17           FIFA World Cup               male        2018   \n",
       "18                  La Liga               male   2019/2020   \n",
       "19                  La Liga               male   2018/2019   \n",
       "20                  La Liga               male   2017/2018   \n",
       "21                  La Liga               male   2016/2017   \n",
       "22                  La Liga               male   2015/2016   \n",
       "23                  La Liga               male   2014/2015   \n",
       "24                  La Liga               male   2013/2014   \n",
       "25                  La Liga               male   2012/2013   \n",
       "26                  La Liga               male   2011/2012   \n",
       "27                  La Liga               male   2010/2011   \n",
       "28                  La Liga               male   2009/2010   \n",
       "29                  La Liga               male   2008/2009   \n",
       "30                  La Liga               male   2007/2008   \n",
       "31                  La Liga               male   2006/2007   \n",
       "32                  La Liga               male   2005/2006   \n",
       "33                  La Liga               male   2004/2005   \n",
       "34                     NWSL             female        2018   \n",
       "35           Premier League               male   2003/2004   \n",
       "36        Women's World Cup             female        2019   \n",
       "\n",
       "                 match_updated             match_available  \n",
       "0   2021-04-19T17:36:05.724116  2021-04-19T17:36:05.724116  \n",
       "1   2021-01-23T21:55:30.425330  2021-01-23T21:55:30.425330  \n",
       "2   2020-08-26T12:33:15.869622            2020-07-29T05:00  \n",
       "3   2020-08-26T12:33:15.869622            2020-07-29T05:00  \n",
       "4   2020-08-26T12:33:15.869622            2020-07-29T05:00  \n",
       "5   2020-08-26T12:33:15.869622            2020-07-29T05:00  \n",
       "6   2020-08-26T12:33:15.869622            2020-07-29T05:00  \n",
       "7   2020-08-26T12:33:15.869622            2020-07-29T05:00  \n",
       "8             2020-07-29T05:00            2020-07-29T05:00  \n",
       "9             2020-07-29T05:00            2020-07-29T05:00  \n",
       "10  2020-08-30T10:18:39.435424  2020-08-30T10:18:39.435424  \n",
       "11  2021-03-31T04:18:30.437060  2021-03-31T04:18:30.437060  \n",
       "12  2021-04-01T06:18:57.459032  2021-04-01T06:18:57.459032  \n",
       "13  2021-04-01T00:34:59.472485  2021-04-01T00:34:59.472485  \n",
       "14            2020-07-29T05:00            2020-07-29T05:00  \n",
       "15  2020-10-20T18:35:33.568528  2020-10-20T18:35:33.568528  \n",
       "16  2021-04-09T20:39:24.201269  2021-04-09T20:39:24.201269  \n",
       "17  2020-10-25T14:03:50.263266  2020-10-25T14:03:50.263266  \n",
       "18  2020-12-18T12:10:38.985394  2020-12-18T12:10:38.985394  \n",
       "19  2021-04-20T03:24:51.029365  2021-04-20T03:24:51.029365  \n",
       "20  2021-04-19T17:36:05.805404  2021-04-19T17:36:05.805404  \n",
       "21  2021-02-02T23:24:58.985975  2021-02-02T23:24:58.985975  \n",
       "22            2020-07-29T05:00            2020-07-29T05:00  \n",
       "23            2020-07-29T05:00            2020-07-29T05:00  \n",
       "24            2020-07-29T05:00            2020-07-29T05:00  \n",
       "25            2020-07-29T05:00            2020-07-29T05:00  \n",
       "26            2020-07-29T05:00            2020-07-29T05:00  \n",
       "27            2020-07-29T05:00            2020-07-29T05:00  \n",
       "28            2020-07-29T05:00            2020-07-29T05:00  \n",
       "29            2020-07-29T05:00            2020-07-29T05:00  \n",
       "30            2020-07-29T05:00            2020-07-29T05:00  \n",
       "31            2020-07-29T05:00            2020-07-29T05:00  \n",
       "32            2020-07-29T05:00            2020-07-29T05:00  \n",
       "33            2020-07-29T05:00            2020-07-29T05:00  \n",
       "34            2020-07-29T05:00            2020-07-29T05:00  \n",
       "35  2020-08-31T20:40:28.969635  2020-08-31T20:40:28.969635  \n",
       "36            2020-07-29T05:00            2020-07-29T05:00  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sb.competitions()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "credentials were not supplied. open data access only\n"
     ]
    },
    {
     "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>match_id</th>\n",
       "      <th>match_date</th>\n",
       "      <th>kick_off</th>\n",
       "      <th>competition</th>\n",
       "      <th>season</th>\n",
       "      <th>home_team</th>\n",
       "      <th>away_team</th>\n",
       "      <th>home_score</th>\n",
       "      <th>away_score</th>\n",
       "      <th>match_status</th>\n",
       "      <th>match_status_360</th>\n",
       "      <th>last_updated</th>\n",
       "      <th>last_updated_360</th>\n",
       "      <th>match_week</th>\n",
       "      <th>competition_stage</th>\n",
       "      <th>stadium</th>\n",
       "      <th>referee</th>\n",
       "      <th>data_version</th>\n",
       "      <th>shot_fidelity_version</th>\n",
       "      <th>xy_fidelity_version</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>303421</td>\n",
       "      <td>2020-07-19</td>\n",
       "      <td>17:00:00.000</td>\n",
       "      <td>Spain - La Liga</td>\n",
       "      <td>2019/2020</td>\n",
       "      <td>Deportivo Alavés</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>available</td>\n",
       "      <td>unscheduled</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>None</td>\n",
       "      <td>38</td>\n",
       "      <td>Regular Season</td>\n",
       "      <td>Estadio de Mendizorroza</td>\n",
       "      <td>J. Martínez</td>\n",
       "      <td>1.1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>303493</td>\n",
       "      <td>2020-06-23</td>\n",
       "      <td>22:00:00.000</td>\n",
       "      <td>Spain - La Liga</td>\n",
       "      <td>2019/2020</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>Athletic Bilbao</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>available</td>\n",
       "      <td>unscheduled</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>None</td>\n",
       "      <td>31</td>\n",
       "      <td>Regular Season</td>\n",
       "      <td>Camp Nou</td>\n",
       "      <td>Jesús Gil</td>\n",
       "      <td>1.1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>303516</td>\n",
       "      <td>2020-06-27</td>\n",
       "      <td>17:00:00.000</td>\n",
       "      <td>Spain - La Liga</td>\n",
       "      <td>2019/2020</td>\n",
       "      <td>Celta Vigo</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>available</td>\n",
       "      <td>unscheduled</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>None</td>\n",
       "      <td>32</td>\n",
       "      <td>Regular Season</td>\n",
       "      <td>Abanca-Balaídos</td>\n",
       "      <td>G. Cuadra</td>\n",
       "      <td>1.1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>303680</td>\n",
       "      <td>2020-07-11</td>\n",
       "      <td>19:30:00.000</td>\n",
       "      <td>Spain - La Liga</td>\n",
       "      <td>2019/2020</td>\n",
       "      <td>Real Valladolid</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>available</td>\n",
       "      <td>unscheduled</td>\n",
       "      <td>2020-12-18T12:10:38.985394</td>\n",
       "      <td>None</td>\n",
       "      <td>36</td>\n",
       "      <td>Regular Season</td>\n",
       "      <td>Estadio Municipal José Zorrilla</td>\n",
       "      <td>Antonio Mateu</td>\n",
       "      <td>1.1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>303532</td>\n",
       "      <td>2020-06-16</td>\n",
       "      <td>22:00:00.000</td>\n",
       "      <td>Spain - La Liga</td>\n",
       "      <td>2019/2020</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>Leganés</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>available</td>\n",
       "      <td>unscheduled</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>None</td>\n",
       "      <td>29</td>\n",
       "      <td>Regular Season</td>\n",
       "      <td>Camp Nou</td>\n",
       "      <td>J. Martínez</td>\n",
       "      <td>1.1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>303400</td>\n",
       "      <td>2020-01-25</td>\n",
       "      <td>16:00:00.000</td>\n",
       "      <td>Spain - La Liga</td>\n",
       "      <td>2019/2020</td>\n",
       "      <td>Valencia</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>available</td>\n",
       "      <td>unscheduled</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>None</td>\n",
       "      <td>21</td>\n",
       "      <td>Regular Season</td>\n",
       "      <td>Estadio de Mestalla</td>\n",
       "      <td>Jesús Gil</td>\n",
       "      <td>1.1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>303634</td>\n",
       "      <td>2020-07-16</td>\n",
       "      <td>21:00:00.000</td>\n",
       "      <td>Spain - La Liga</td>\n",
       "      <td>2019/2020</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>Osasuna</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>available</td>\n",
       "      <td>unscheduled</td>\n",
       "      <td>2020-09-18T13:16:12.825671</td>\n",
       "      <td>None</td>\n",
       "      <td>37</td>\n",
       "      <td>Regular Season</td>\n",
       "      <td>Camp Nou</td>\n",
       "      <td>J. Sánchez</td>\n",
       "      <td>1.1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>303479</td>\n",
       "      <td>2020-03-07</td>\n",
       "      <td>18:30:00.000</td>\n",
       "      <td>Spain - La Liga</td>\n",
       "      <td>2019/2020</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>Real Sociedad</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>available</td>\n",
       "      <td>unscheduled</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>None</td>\n",
       "      <td>27</td>\n",
       "      <td>Regular Season</td>\n",
       "      <td>Camp Nou</td>\n",
       "      <td>J. Martínez</td>\n",
       "      <td>1.1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>303615</td>\n",
       "      <td>2020-07-08</td>\n",
       "      <td>22:00:00.000</td>\n",
       "      <td>Spain - La Liga</td>\n",
       "      <td>2019/2020</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>Espanyol</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>available</td>\n",
       "      <td>unscheduled</td>\n",
       "      <td>2020-09-11T23:12:41.238499</td>\n",
       "      <td>None</td>\n",
       "      <td>35</td>\n",
       "      <td>Regular Season</td>\n",
       "      <td>Camp Nou</td>\n",
       "      <td>J. Munuera</td>\n",
       "      <td>1.1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>303696</td>\n",
       "      <td>2020-06-30</td>\n",
       "      <td>22:00:00.000</td>\n",
       "      <td>Spain - La Liga</td>\n",
       "      <td>2019/2020</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>Atlético Madrid</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>available</td>\n",
       "      <td>unscheduled</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>None</td>\n",
       "      <td>33</td>\n",
       "      <td>Regular Season</td>\n",
       "      <td>Camp Nou</td>\n",
       "      <td>A. Hernández</td>\n",
       "      <td>1.1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>303664</td>\n",
       "      <td>2019-12-14</td>\n",
       "      <td>16:00:00.000</td>\n",
       "      <td>Spain - La Liga</td>\n",
       "      <td>2019/2020</td>\n",
       "      <td>Real Sociedad</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>available</td>\n",
       "      <td>unscheduled</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>None</td>\n",
       "      <td>17</td>\n",
       "      <td>Regular Season</td>\n",
       "      <td>Reale Arena</td>\n",
       "      <td>J. Alberola Rojas</td>\n",
       "      <td>1.1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>303596</td>\n",
       "      <td>2019-12-18</td>\n",
       "      <td>20:00:00.000</td>\n",
       "      <td>Spain - La Liga</td>\n",
       "      <td>2019/2020</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>available</td>\n",
       "      <td>unscheduled</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>None</td>\n",
       "      <td>10</td>\n",
       "      <td>Regular Season</td>\n",
       "      <td>Camp Nou</td>\n",
       "      <td>A. Hernández</td>\n",
       "      <td>1.1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>303487</td>\n",
       "      <td>2019-11-09</td>\n",
       "      <td>21:00:00.000</td>\n",
       "      <td>Spain - La Liga</td>\n",
       "      <td>2019/2020</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>Celta Vigo</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>available</td>\n",
       "      <td>unscheduled</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>None</td>\n",
       "      <td>13</td>\n",
       "      <td>Regular Season</td>\n",
       "      <td>Camp Nou</td>\n",
       "      <td>G. Cuadra</td>\n",
       "      <td>1.1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>303600</td>\n",
       "      <td>2019-10-29</td>\n",
       "      <td>21:15:00.000</td>\n",
       "      <td>Spain - La Liga</td>\n",
       "      <td>2019/2020</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>Real Valladolid</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>available</td>\n",
       "      <td>unscheduled</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>None</td>\n",
       "      <td>11</td>\n",
       "      <td>Regular Season</td>\n",
       "      <td>Camp Nou</td>\n",
       "      <td>J. Alberola Rojas</td>\n",
       "      <td>1.1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>303548</td>\n",
       "      <td>2020-06-13</td>\n",
       "      <td>22:00:00.000</td>\n",
       "      <td>Spain - La Liga</td>\n",
       "      <td>2019/2020</td>\n",
       "      <td>Mallorca</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>available</td>\n",
       "      <td>unscheduled</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>None</td>\n",
       "      <td>28</td>\n",
       "      <td>Regular Season</td>\n",
       "      <td>Iberostar Estadi</td>\n",
       "      <td>C. Del Cerro</td>\n",
       "      <td>1.1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>303473</td>\n",
       "      <td>2019-10-06</td>\n",
       "      <td>21:00:00.000</td>\n",
       "      <td>Spain - La Liga</td>\n",
       "      <td>2019/2020</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>Sevilla</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>available</td>\n",
       "      <td>unscheduled</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>None</td>\n",
       "      <td>8</td>\n",
       "      <td>Regular Season</td>\n",
       "      <td>Camp Nou</td>\n",
       "      <td>Antonio Mateu</td>\n",
       "      <td>1.1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>303610</td>\n",
       "      <td>2020-01-19</td>\n",
       "      <td>21:00:00.000</td>\n",
       "      <td>Spain - La Liga</td>\n",
       "      <td>2019/2020</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>Granada</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>available</td>\n",
       "      <td>unscheduled</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>None</td>\n",
       "      <td>20</td>\n",
       "      <td>Regular Season</td>\n",
       "      <td>Camp Nou</td>\n",
       "      <td>V. Pizarro</td>\n",
       "      <td>1.1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>303652</td>\n",
       "      <td>2020-01-04</td>\n",
       "      <td>21:00:00.000</td>\n",
       "      <td>Spain - La Liga</td>\n",
       "      <td>2019/2020</td>\n",
       "      <td>Espanyol</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>available</td>\n",
       "      <td>unscheduled</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>None</td>\n",
       "      <td>19</td>\n",
       "      <td>Regular Season</td>\n",
       "      <td>RCDE Stadium</td>\n",
       "      <td>C. Del Cerro</td>\n",
       "      <td>1.1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>303430</td>\n",
       "      <td>2019-09-24</td>\n",
       "      <td>21:00:00.000</td>\n",
       "      <td>Spain - La Liga</td>\n",
       "      <td>2019/2020</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>Villarreal</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>available</td>\n",
       "      <td>unscheduled</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>None</td>\n",
       "      <td>6</td>\n",
       "      <td>Regular Season</td>\n",
       "      <td>Camp Nou</td>\n",
       "      <td>R. De Burgos</td>\n",
       "      <td>1.1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>303674</td>\n",
       "      <td>2020-06-19</td>\n",
       "      <td>22:00:00.000</td>\n",
       "      <td>Spain - La Liga</td>\n",
       "      <td>2019/2020</td>\n",
       "      <td>Sevilla</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>available</td>\n",
       "      <td>unscheduled</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>None</td>\n",
       "      <td>30</td>\n",
       "      <td>Regular Season</td>\n",
       "      <td>Estadio Ramón Sánchez Pizjuán</td>\n",
       "      <td>José González</td>\n",
       "      <td>1.1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>303470</td>\n",
       "      <td>2020-03-01</td>\n",
       "      <td>21:00:00.000</td>\n",
       "      <td>Spain - La Liga</td>\n",
       "      <td>2019/2020</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>available</td>\n",
       "      <td>unscheduled</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>None</td>\n",
       "      <td>26</td>\n",
       "      <td>Regular Season</td>\n",
       "      <td>Estadio Santiago Bernabéu</td>\n",
       "      <td>Antonio Mateu</td>\n",
       "      <td>1.1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>303700</td>\n",
       "      <td>2019-10-19</td>\n",
       "      <td>13:00:00.000</td>\n",
       "      <td>Spain - La Liga</td>\n",
       "      <td>2019/2020</td>\n",
       "      <td>Eibar</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>available</td>\n",
       "      <td>unscheduled</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>None</td>\n",
       "      <td>9</td>\n",
       "      <td>Regular Season</td>\n",
       "      <td>Estadio Municipal de Ipurúa</td>\n",
       "      <td>M. Melero</td>\n",
       "      <td>1.1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>303707</td>\n",
       "      <td>2020-02-09</td>\n",
       "      <td>21:00:00.000</td>\n",
       "      <td>Spain - La Liga</td>\n",
       "      <td>2019/2020</td>\n",
       "      <td>Real Betis</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>available</td>\n",
       "      <td>unscheduled</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>None</td>\n",
       "      <td>23</td>\n",
       "      <td>Regular Season</td>\n",
       "      <td>Estadio Benito Villamarín</td>\n",
       "      <td>J. Sánchez</td>\n",
       "      <td>1.1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>303666</td>\n",
       "      <td>2019-09-21</td>\n",
       "      <td>21:00:00.000</td>\n",
       "      <td>Spain - La Liga</td>\n",
       "      <td>2019/2020</td>\n",
       "      <td>Granada</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>available</td>\n",
       "      <td>unscheduled</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>None</td>\n",
       "      <td>5</td>\n",
       "      <td>Regular Season</td>\n",
       "      <td>Estadio Nuevo Los Cármenes</td>\n",
       "      <td>G. Cuadra</td>\n",
       "      <td>1.1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>303725</td>\n",
       "      <td>2020-07-05</td>\n",
       "      <td>22:00:00.000</td>\n",
       "      <td>Spain - La Liga</td>\n",
       "      <td>2019/2020</td>\n",
       "      <td>Villarreal</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>available</td>\n",
       "      <td>unscheduled</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>None</td>\n",
       "      <td>34</td>\n",
       "      <td>Regular Season</td>\n",
       "      <td>Estadio de la Cerámica</td>\n",
       "      <td>C. Del Cerro</td>\n",
       "      <td>1.1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>303504</td>\n",
       "      <td>2019-11-02</td>\n",
       "      <td>16:00:00.000</td>\n",
       "      <td>Spain - La Liga</td>\n",
       "      <td>2019/2020</td>\n",
       "      <td>Levante</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>available</td>\n",
       "      <td>unscheduled</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>None</td>\n",
       "      <td>12</td>\n",
       "      <td>Regular Season</td>\n",
       "      <td>Estadio Ciudad de Valencia</td>\n",
       "      <td>A. Hernández</td>\n",
       "      <td>1.1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>303715</td>\n",
       "      <td>2019-11-23</td>\n",
       "      <td>13:00:00.000</td>\n",
       "      <td>Spain - La Liga</td>\n",
       "      <td>2019/2020</td>\n",
       "      <td>Leganés</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>available</td>\n",
       "      <td>unscheduled</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>None</td>\n",
       "      <td>14</td>\n",
       "      <td>Regular Season</td>\n",
       "      <td>Estadio Municipal de Butarque</td>\n",
       "      <td>S. Jaime</td>\n",
       "      <td>1.1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>303377</td>\n",
       "      <td>2020-02-15</td>\n",
       "      <td>16:00:00.000</td>\n",
       "      <td>Spain - La Liga</td>\n",
       "      <td>2019/2020</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>Getafe</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>available</td>\n",
       "      <td>unscheduled</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>None</td>\n",
       "      <td>24</td>\n",
       "      <td>Regular Season</td>\n",
       "      <td>Camp Nou</td>\n",
       "      <td>G. Cuadra</td>\n",
       "      <td>1.1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>303524</td>\n",
       "      <td>2019-12-01</td>\n",
       "      <td>21:00:00.000</td>\n",
       "      <td>Spain - La Liga</td>\n",
       "      <td>2019/2020</td>\n",
       "      <td>Atlético Madrid</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>available</td>\n",
       "      <td>unscheduled</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>None</td>\n",
       "      <td>15</td>\n",
       "      <td>Regular Season</td>\n",
       "      <td>Estadio Wanda Metropolitano</td>\n",
       "      <td>Antonio Mateu</td>\n",
       "      <td>1.1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>303451</td>\n",
       "      <td>2019-12-07</td>\n",
       "      <td>21:00:00.000</td>\n",
       "      <td>Spain - La Liga</td>\n",
       "      <td>2019/2020</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>Mallorca</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>available</td>\n",
       "      <td>unscheduled</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>None</td>\n",
       "      <td>16</td>\n",
       "      <td>Regular Season</td>\n",
       "      <td>Camp Nou</td>\n",
       "      <td>J. Munuera</td>\n",
       "      <td>1.1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>303517</td>\n",
       "      <td>2019-12-21</td>\n",
       "      <td>16:00:00.000</td>\n",
       "      <td>Spain - La Liga</td>\n",
       "      <td>2019/2020</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>Deportivo Alavés</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>available</td>\n",
       "      <td>unscheduled</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>None</td>\n",
       "      <td>18</td>\n",
       "      <td>Regular Season</td>\n",
       "      <td>Camp Nou</td>\n",
       "      <td>M. Melero</td>\n",
       "      <td>1.1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>303682</td>\n",
       "      <td>2020-02-02</td>\n",
       "      <td>21:00:00.000</td>\n",
       "      <td>Spain - La Liga</td>\n",
       "      <td>2019/2020</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>Levante</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>available</td>\n",
       "      <td>unscheduled</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>None</td>\n",
       "      <td>22</td>\n",
       "      <td>Regular Season</td>\n",
       "      <td>Camp Nou</td>\n",
       "      <td>A. Cordero</td>\n",
       "      <td>1.1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>303731</td>\n",
       "      <td>2020-02-22</td>\n",
       "      <td>16:00:00.000</td>\n",
       "      <td>Spain - La Liga</td>\n",
       "      <td>2019/2020</td>\n",
       "      <td>Barcelona</td>\n",
       "      <td>Eibar</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>available</td>\n",
       "      <td>unscheduled</td>\n",
       "      <td>2020-07-29T05:00</td>\n",
       "      <td>None</td>\n",
       "      <td>25</td>\n",
       "      <td>Regular Season</td>\n",
       "      <td>Camp Nou</td>\n",
       "      <td>C. Soto</td>\n",
       "      <td>1.1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    match_id  match_date      kick_off      competition     season  \\\n",
       "0     303421  2020-07-19  17:00:00.000  Spain - La Liga  2019/2020   \n",
       "1     303493  2020-06-23  22:00:00.000  Spain - La Liga  2019/2020   \n",
       "2     303516  2020-06-27  17:00:00.000  Spain - La Liga  2019/2020   \n",
       "3     303680  2020-07-11  19:30:00.000  Spain - La Liga  2019/2020   \n",
       "4     303532  2020-06-16  22:00:00.000  Spain - La Liga  2019/2020   \n",
       "5     303400  2020-01-25  16:00:00.000  Spain - La Liga  2019/2020   \n",
       "6     303634  2020-07-16  21:00:00.000  Spain - La Liga  2019/2020   \n",
       "7     303479  2020-03-07  18:30:00.000  Spain - La Liga  2019/2020   \n",
       "8     303615  2020-07-08  22:00:00.000  Spain - La Liga  2019/2020   \n",
       "9     303696  2020-06-30  22:00:00.000  Spain - La Liga  2019/2020   \n",
       "10    303664  2019-12-14  16:00:00.000  Spain - La Liga  2019/2020   \n",
       "11    303596  2019-12-18  20:00:00.000  Spain - La Liga  2019/2020   \n",
       "12    303487  2019-11-09  21:00:00.000  Spain - La Liga  2019/2020   \n",
       "13    303600  2019-10-29  21:15:00.000  Spain - La Liga  2019/2020   \n",
       "14    303548  2020-06-13  22:00:00.000  Spain - La Liga  2019/2020   \n",
       "15    303473  2019-10-06  21:00:00.000  Spain - La Liga  2019/2020   \n",
       "16    303610  2020-01-19  21:00:00.000  Spain - La Liga  2019/2020   \n",
       "17    303652  2020-01-04  21:00:00.000  Spain - La Liga  2019/2020   \n",
       "18    303430  2019-09-24  21:00:00.000  Spain - La Liga  2019/2020   \n",
       "19    303674  2020-06-19  22:00:00.000  Spain - La Liga  2019/2020   \n",
       "20    303470  2020-03-01  21:00:00.000  Spain - La Liga  2019/2020   \n",
       "21    303700  2019-10-19  13:00:00.000  Spain - La Liga  2019/2020   \n",
       "22    303707  2020-02-09  21:00:00.000  Spain - La Liga  2019/2020   \n",
       "23    303666  2019-09-21  21:00:00.000  Spain - La Liga  2019/2020   \n",
       "24    303725  2020-07-05  22:00:00.000  Spain - La Liga  2019/2020   \n",
       "25    303504  2019-11-02  16:00:00.000  Spain - La Liga  2019/2020   \n",
       "26    303715  2019-11-23  13:00:00.000  Spain - La Liga  2019/2020   \n",
       "27    303377  2020-02-15  16:00:00.000  Spain - La Liga  2019/2020   \n",
       "28    303524  2019-12-01  21:00:00.000  Spain - La Liga  2019/2020   \n",
       "29    303451  2019-12-07  21:00:00.000  Spain - La Liga  2019/2020   \n",
       "30    303517  2019-12-21  16:00:00.000  Spain - La Liga  2019/2020   \n",
       "31    303682  2020-02-02  21:00:00.000  Spain - La Liga  2019/2020   \n",
       "32    303731  2020-02-22  16:00:00.000  Spain - La Liga  2019/2020   \n",
       "\n",
       "           home_team         away_team  home_score  away_score match_status  \\\n",
       "0   Deportivo Alavés         Barcelona           0           5    available   \n",
       "1          Barcelona   Athletic Bilbao           1           0    available   \n",
       "2         Celta Vigo         Barcelona           2           2    available   \n",
       "3    Real Valladolid         Barcelona           0           1    available   \n",
       "4          Barcelona           Leganés           2           0    available   \n",
       "5           Valencia         Barcelona           2           0    available   \n",
       "6          Barcelona           Osasuna           1           2    available   \n",
       "7          Barcelona     Real Sociedad           1           0    available   \n",
       "8          Barcelona          Espanyol           1           0    available   \n",
       "9          Barcelona   Atlético Madrid           2           2    available   \n",
       "10     Real Sociedad         Barcelona           2           2    available   \n",
       "11         Barcelona       Real Madrid           0           0    available   \n",
       "12         Barcelona        Celta Vigo           4           1    available   \n",
       "13         Barcelona   Real Valladolid           5           1    available   \n",
       "14          Mallorca         Barcelona           0           4    available   \n",
       "15         Barcelona           Sevilla           4           0    available   \n",
       "16         Barcelona           Granada           1           0    available   \n",
       "17          Espanyol         Barcelona           2           2    available   \n",
       "18         Barcelona        Villarreal           2           1    available   \n",
       "19           Sevilla         Barcelona           0           0    available   \n",
       "20       Real Madrid         Barcelona           2           0    available   \n",
       "21             Eibar         Barcelona           0           3    available   \n",
       "22        Real Betis         Barcelona           2           3    available   \n",
       "23           Granada         Barcelona           2           0    available   \n",
       "24        Villarreal         Barcelona           1           4    available   \n",
       "25           Levante         Barcelona           3           1    available   \n",
       "26           Leganés         Barcelona           1           2    available   \n",
       "27         Barcelona            Getafe           2           1    available   \n",
       "28   Atlético Madrid         Barcelona           0           1    available   \n",
       "29         Barcelona          Mallorca           5           2    available   \n",
       "30         Barcelona  Deportivo Alavés           4           1    available   \n",
       "31         Barcelona           Levante           2           1    available   \n",
       "32         Barcelona             Eibar           5           0    available   \n",
       "\n",
       "   match_status_360                last_updated last_updated_360  match_week  \\\n",
       "0       unscheduled            2020-07-29T05:00             None          38   \n",
       "1       unscheduled            2020-07-29T05:00             None          31   \n",
       "2       unscheduled            2020-07-29T05:00             None          32   \n",
       "3       unscheduled  2020-12-18T12:10:38.985394             None          36   \n",
       "4       unscheduled            2020-07-29T05:00             None          29   \n",
       "5       unscheduled            2020-07-29T05:00             None          21   \n",
       "6       unscheduled  2020-09-18T13:16:12.825671             None          37   \n",
       "7       unscheduled            2020-07-29T05:00             None          27   \n",
       "8       unscheduled  2020-09-11T23:12:41.238499             None          35   \n",
       "9       unscheduled            2020-07-29T05:00             None          33   \n",
       "10      unscheduled            2020-07-29T05:00             None          17   \n",
       "11      unscheduled            2020-07-29T05:00             None          10   \n",
       "12      unscheduled            2020-07-29T05:00             None          13   \n",
       "13      unscheduled            2020-07-29T05:00             None          11   \n",
       "14      unscheduled            2020-07-29T05:00             None          28   \n",
       "15      unscheduled            2020-07-29T05:00             None           8   \n",
       "16      unscheduled            2020-07-29T05:00             None          20   \n",
       "17      unscheduled            2020-07-29T05:00             None          19   \n",
       "18      unscheduled            2020-07-29T05:00             None           6   \n",
       "19      unscheduled            2020-07-29T05:00             None          30   \n",
       "20      unscheduled            2020-07-29T05:00             None          26   \n",
       "21      unscheduled            2020-07-29T05:00             None           9   \n",
       "22      unscheduled            2020-07-29T05:00             None          23   \n",
       "23      unscheduled            2020-07-29T05:00             None           5   \n",
       "24      unscheduled            2020-07-29T05:00             None          34   \n",
       "25      unscheduled            2020-07-29T05:00             None          12   \n",
       "26      unscheduled            2020-07-29T05:00             None          14   \n",
       "27      unscheduled            2020-07-29T05:00             None          24   \n",
       "28      unscheduled            2020-07-29T05:00             None          15   \n",
       "29      unscheduled            2020-07-29T05:00             None          16   \n",
       "30      unscheduled            2020-07-29T05:00             None          18   \n",
       "31      unscheduled            2020-07-29T05:00             None          22   \n",
       "32      unscheduled            2020-07-29T05:00             None          25   \n",
       "\n",
       "   competition_stage                          stadium            referee  \\\n",
       "0     Regular Season          Estadio de Mendizorroza        J. Martínez   \n",
       "1     Regular Season                         Camp Nou          Jesús Gil   \n",
       "2     Regular Season                  Abanca-Balaídos          G. Cuadra   \n",
       "3     Regular Season  Estadio Municipal José Zorrilla      Antonio Mateu   \n",
       "4     Regular Season                         Camp Nou        J. Martínez   \n",
       "5     Regular Season              Estadio de Mestalla          Jesús Gil   \n",
       "6     Regular Season                         Camp Nou         J. Sánchez   \n",
       "7     Regular Season                         Camp Nou        J. Martínez   \n",
       "8     Regular Season                         Camp Nou         J. Munuera   \n",
       "9     Regular Season                         Camp Nou       A. Hernández   \n",
       "10    Regular Season                      Reale Arena  J. Alberola Rojas   \n",
       "11    Regular Season                         Camp Nou       A. Hernández   \n",
       "12    Regular Season                         Camp Nou          G. Cuadra   \n",
       "13    Regular Season                         Camp Nou  J. Alberola Rojas   \n",
       "14    Regular Season                 Iberostar Estadi       C. Del Cerro   \n",
       "15    Regular Season                         Camp Nou      Antonio Mateu   \n",
       "16    Regular Season                         Camp Nou         V. Pizarro   \n",
       "17    Regular Season                     RCDE Stadium       C. Del Cerro   \n",
       "18    Regular Season                         Camp Nou       R. De Burgos   \n",
       "19    Regular Season    Estadio Ramón Sánchez Pizjuán      José González   \n",
       "20    Regular Season        Estadio Santiago Bernabéu      Antonio Mateu   \n",
       "21    Regular Season      Estadio Municipal de Ipurúa          M. Melero   \n",
       "22    Regular Season        Estadio Benito Villamarín         J. Sánchez   \n",
       "23    Regular Season       Estadio Nuevo Los Cármenes          G. Cuadra   \n",
       "24    Regular Season           Estadio de la Cerámica       C. Del Cerro   \n",
       "25    Regular Season       Estadio Ciudad de Valencia       A. Hernández   \n",
       "26    Regular Season    Estadio Municipal de Butarque           S. Jaime   \n",
       "27    Regular Season                         Camp Nou          G. Cuadra   \n",
       "28    Regular Season      Estadio Wanda Metropolitano      Antonio Mateu   \n",
       "29    Regular Season                         Camp Nou         J. Munuera   \n",
       "30    Regular Season                         Camp Nou          M. Melero   \n",
       "31    Regular Season                         Camp Nou         A. Cordero   \n",
       "32    Regular Season                         Camp Nou            C. Soto   \n",
       "\n",
       "   data_version shot_fidelity_version xy_fidelity_version  \n",
       "0         1.1.0                     2                   2  \n",
       "1         1.1.0                     2                   2  \n",
       "2         1.1.0                     2                   2  \n",
       "3         1.1.0                     2                   2  \n",
       "4         1.1.0                     2                   2  \n",
       "5         1.1.0                     2                   2  \n",
       "6         1.1.0                     2                   2  \n",
       "7         1.1.0                     2                   2  \n",
       "8         1.1.0                     2                   2  \n",
       "9         1.1.0                     2                   2  \n",
       "10        1.1.0                     2                   2  \n",
       "11        1.1.0                     2                   2  \n",
       "12        1.1.0                     2                   2  \n",
       "13        1.1.0                     2                   2  \n",
       "14        1.1.0                     2                   2  \n",
       "15        1.1.0                     2                   2  \n",
       "16        1.1.0                     2                   2  \n",
       "17        1.1.0                     2                   2  \n",
       "18        1.1.0                     2                   2  \n",
       "19        1.1.0                     2                   2  \n",
       "20        1.1.0                     2                   2  \n",
       "21        1.1.0                     2                   2  \n",
       "22        1.1.0                     2                   2  \n",
       "23        1.1.0                     2                   2  \n",
       "24        1.1.0                     2                   2  \n",
       "25        1.1.0                     2                   2  \n",
       "26        1.1.0                     2                   2  \n",
       "27        1.1.0                     2                   2  \n",
       "28        1.1.0                     2                   2  \n",
       "29        1.1.0                     2                   2  \n",
       "30        1.1.0                     2                   2  \n",
       "31        1.1.0                     2                   2  \n",
       "32        1.1.0                     2                   2  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mat = sb.matches(competition_id=11, season_id=42)\n",
    "mat"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "Ids = []\n",
    "for i in range(len(mat)):\n",
    "    Ids += [mat.match_id[i], ]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "credentials were not supplied. open data access only\n",
      "credentials were not supplied. open data access only\n",
      "credentials were not supplied. open data access only\n",
      "credentials were not supplied. open data access only\n",
      "credentials were not supplied. open data access only\n",
      "credentials were not supplied. open data access only\n",
      "credentials were not supplied. open data access only\n",
      "credentials were not supplied. open data access only\n",
      "credentials were not supplied. open data access only\n",
      "credentials were not supplied. open data access only\n",
      "credentials were not supplied. open data access only\n",
      "credentials were not supplied. open data access only\n",
      "credentials were not supplied. open data access only\n",
      "credentials were not supplied. open data access only\n",
      "credentials were not supplied. open data access only\n",
      "credentials were not supplied. open data access only\n",
      "credentials were not supplied. open data access only\n",
      "credentials were not supplied. open data access only\n",
      "credentials were not supplied. open data access only\n",
      "credentials were not supplied. open data access only\n",
      "credentials were not supplied. open data access only\n",
      "credentials were not supplied. open data access only\n",
      "credentials were not supplied. open data access only\n",
      "credentials were not supplied. open data access only\n",
      "credentials were not supplied. open data access only\n",
      "credentials were not supplied. open data access only\n",
      "credentials were not supplied. open data access only\n",
      "credentials were not supplied. open data access only\n",
      "credentials were not supplied. open data access only\n",
      "credentials were not supplied. open data access only\n",
      "credentials were not supplied. open data access only\n",
      "credentials were not supplied. open data access only\n",
      "credentials were not supplied. open data access only\n"
     ]
    }
   ],
   "source": [
    "E = []\n",
    "for ids in Ids:\n",
    "    ev = sb.events(match_id = ids)\n",
    "    E.append(ev)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>ball_receipt_outcome</th>\n",
       "      <th>ball_recovery_offensive</th>\n",
       "      <th>ball_recovery_recovery_failure</th>\n",
       "      <th>block_deflection</th>\n",
       "      <th>block_offensive</th>\n",
       "      <th>carry_end_location</th>\n",
       "      <th>clearance_body_part</th>\n",
       "      <th>clearance_head</th>\n",
       "      <th>clearance_left_foot</th>\n",
       "      <th>clearance_right_foot</th>\n",
       "      <th>...</th>\n",
       "      <th>shot_deflected</th>\n",
       "      <th>block_save_block</th>\n",
       "      <th>foul_committed_penalty</th>\n",
       "      <th>foul_won_penalty</th>\n",
       "      <th>goalkeeper_punched_out</th>\n",
       "      <th>goalkeeper_shot_saved_off_target</th>\n",
       "      <th>shot_saved_off_target</th>\n",
       "      <th>dribble_no_touch</th>\n",
       "      <th>goalkeeper_success_in_play</th>\n",
       "      <th>goalkeeper_lost_in_play</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3685</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3686</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3687</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3688</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3689</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>129059 rows × 106 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     ball_receipt_outcome ball_recovery_offensive  \\\n",
       "0                     NaN                     NaN   \n",
       "1                     NaN                     NaN   \n",
       "2                     NaN                     NaN   \n",
       "3                     NaN                     NaN   \n",
       "4                     NaN                     NaN   \n",
       "...                   ...                     ...   \n",
       "3685                  NaN                     NaN   \n",
       "3686                  NaN                     NaN   \n",
       "3687                  NaN                     NaN   \n",
       "3688                  NaN                     NaN   \n",
       "3689                  NaN                     NaN   \n",
       "\n",
       "     ball_recovery_recovery_failure block_deflection block_offensive  \\\n",
       "0                               NaN              NaN             NaN   \n",
       "1                               NaN              NaN             NaN   \n",
       "2                               NaN              NaN             NaN   \n",
       "3                               NaN              NaN             NaN   \n",
       "4                               NaN              NaN             NaN   \n",
       "...                             ...              ...             ...   \n",
       "3685                            NaN              NaN             NaN   \n",
       "3686                            NaN              NaN             NaN   \n",
       "3687                            NaN              NaN             NaN   \n",
       "3688                            NaN              NaN             NaN   \n",
       "3689                            NaN              NaN             NaN   \n",
       "\n",
       "     carry_end_location clearance_body_part clearance_head  \\\n",
       "0                   NaN                 NaN            NaN   \n",
       "1                   NaN                 NaN            NaN   \n",
       "2                   NaN                 NaN            NaN   \n",
       "3                   NaN                 NaN            NaN   \n",
       "4                   NaN                 NaN            NaN   \n",
       "...                 ...                 ...            ...   \n",
       "3685                NaN                 NaN            NaN   \n",
       "3686                NaN                 NaN            NaN   \n",
       "3687                NaN                 NaN            NaN   \n",
       "3688                NaN                 NaN            NaN   \n",
       "3689                NaN                 NaN            NaN   \n",
       "\n",
       "     clearance_left_foot clearance_right_foot  ... shot_deflected  \\\n",
       "0                    NaN                  NaN  ...            NaN   \n",
       "1                    NaN                  NaN  ...            NaN   \n",
       "2                    NaN                  NaN  ...            NaN   \n",
       "3                    NaN                  NaN  ...            NaN   \n",
       "4                    NaN                  NaN  ...            NaN   \n",
       "...                  ...                  ...  ...            ...   \n",
       "3685                 NaN                  NaN  ...            NaN   \n",
       "3686                 NaN                  NaN  ...            NaN   \n",
       "3687                 NaN                  NaN  ...            NaN   \n",
       "3688                 NaN                  NaN  ...            NaN   \n",
       "3689                 NaN                  NaN  ...            NaN   \n",
       "\n",
       "     block_save_block foul_committed_penalty foul_won_penalty  \\\n",
       "0                 NaN                    NaN              NaN   \n",
       "1                 NaN                    NaN              NaN   \n",
       "2                 NaN                    NaN              NaN   \n",
       "3                 NaN                    NaN              NaN   \n",
       "4                 NaN                    NaN              NaN   \n",
       "...               ...                    ...              ...   \n",
       "3685              NaN                    NaN              NaN   \n",
       "3686              NaN                    NaN              NaN   \n",
       "3687              NaN                    NaN              NaN   \n",
       "3688              NaN                    NaN              NaN   \n",
       "3689              NaN                    NaN              NaN   \n",
       "\n",
       "     goalkeeper_punched_out goalkeeper_shot_saved_off_target  \\\n",
       "0                       NaN                              NaN   \n",
       "1                       NaN                              NaN   \n",
       "2                       NaN                              NaN   \n",
       "3                       NaN                              NaN   \n",
       "4                       NaN                              NaN   \n",
       "...                     ...                              ...   \n",
       "3685                    NaN                              NaN   \n",
       "3686                    NaN                              NaN   \n",
       "3687                    NaN                              NaN   \n",
       "3688                    NaN                              NaN   \n",
       "3689                    NaN                              NaN   \n",
       "\n",
       "      shot_saved_off_target dribble_no_touch goalkeeper_success_in_play  \\\n",
       "0                       NaN              NaN                        NaN   \n",
       "1                       NaN              NaN                        NaN   \n",
       "2                       NaN              NaN                        NaN   \n",
       "3                       NaN              NaN                        NaN   \n",
       "4                       NaN              NaN                        NaN   \n",
       "...                     ...              ...                        ...   \n",
       "3685                    NaN              NaN                        NaN   \n",
       "3686                    NaN              NaN                        NaN   \n",
       "3687                    NaN              NaN                        NaN   \n",
       "3688                    NaN              NaN                        NaN   \n",
       "3689                    NaN              NaN                        NaN   \n",
       "\n",
       "     goalkeeper_lost_in_play  \n",
       "0                        NaN  \n",
       "1                        NaN  \n",
       "2                        NaN  \n",
       "3                        NaN  \n",
       "4                        NaN  \n",
       "...                      ...  \n",
       "3685                     NaN  \n",
       "3686                     NaN  \n",
       "3687                     NaN  \n",
       "3688                     NaN  \n",
       "3689                     NaN  \n",
       "\n",
       "[129059 rows x 106 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "events = pd.concat(E)\n",
    "events"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['ball_receipt_outcome', 'ball_recovery_offensive',\n",
       "       'ball_recovery_recovery_failure', 'block_deflection', 'block_offensive',\n",
       "       'carry_end_location', 'clearance_body_part', 'clearance_head',\n",
       "       'clearance_left_foot', 'clearance_right_foot',\n",
       "       ...\n",
       "       'shot_deflected', 'block_save_block', 'foul_committed_penalty',\n",
       "       'foul_won_penalty', 'goalkeeper_punched_out',\n",
       "       'goalkeeper_shot_saved_off_target', 'shot_saved_off_target',\n",
       "       'dribble_no_touch', 'goalkeeper_success_in_play',\n",
       "       'goalkeeper_lost_in_play'],\n",
       "      dtype='object', length=106)"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "events.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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>ball_receipt_outcome</th>\n",
       "      <th>ball_recovery_offensive</th>\n",
       "      <th>ball_recovery_recovery_failure</th>\n",
       "      <th>block_deflection</th>\n",
       "      <th>block_offensive</th>\n",
       "      <th>carry_end_location</th>\n",
       "      <th>clearance_body_part</th>\n",
       "      <th>clearance_head</th>\n",
       "      <th>clearance_left_foot</th>\n",
       "      <th>clearance_right_foot</th>\n",
       "      <th>...</th>\n",
       "      <th>shot_deflected</th>\n",
       "      <th>block_save_block</th>\n",
       "      <th>foul_committed_penalty</th>\n",
       "      <th>foul_won_penalty</th>\n",
       "      <th>goalkeeper_punched_out</th>\n",
       "      <th>goalkeeper_shot_saved_off_target</th>\n",
       "      <th>shot_saved_off_target</th>\n",
       "      <th>dribble_no_touch</th>\n",
       "      <th>goalkeeper_success_in_play</th>\n",
       "      <th>goalkeeper_lost_in_play</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3680</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3681</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3683</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3686</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3687</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>80858 rows × 106 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     ball_receipt_outcome ball_recovery_offensive  \\\n",
       "1                     NaN                     NaN   \n",
       "2                     NaN                     NaN   \n",
       "4                     NaN                     NaN   \n",
       "6                     NaN                     NaN   \n",
       "7                     NaN                     NaN   \n",
       "...                   ...                     ...   \n",
       "3680                  NaN                     NaN   \n",
       "3681                  NaN                     NaN   \n",
       "3683                  NaN                     NaN   \n",
       "3686                  NaN                     NaN   \n",
       "3687                  NaN                     NaN   \n",
       "\n",
       "     ball_recovery_recovery_failure block_deflection block_offensive  \\\n",
       "1                               NaN              NaN             NaN   \n",
       "2                               NaN              NaN             NaN   \n",
       "4                               NaN              NaN             NaN   \n",
       "6                               NaN              NaN             NaN   \n",
       "7                               NaN              NaN             NaN   \n",
       "...                             ...              ...             ...   \n",
       "3680                            NaN              NaN             NaN   \n",
       "3681                            NaN              NaN             NaN   \n",
       "3683                            NaN              NaN             NaN   \n",
       "3686                            NaN              NaN             NaN   \n",
       "3687                            NaN              NaN             NaN   \n",
       "\n",
       "     carry_end_location clearance_body_part clearance_head  \\\n",
       "1                   NaN                 NaN            NaN   \n",
       "2                   NaN                 NaN            NaN   \n",
       "4                   NaN                 NaN            NaN   \n",
       "6                   NaN                 NaN            NaN   \n",
       "7                   NaN                 NaN            NaN   \n",
       "...                 ...                 ...            ...   \n",
       "3680                NaN                 NaN            NaN   \n",
       "3681                NaN                 NaN            NaN   \n",
       "3683                NaN                 NaN            NaN   \n",
       "3686                NaN                 NaN            NaN   \n",
       "3687                NaN                 NaN            NaN   \n",
       "\n",
       "     clearance_left_foot clearance_right_foot  ... shot_deflected  \\\n",
       "1                    NaN                  NaN  ...            NaN   \n",
       "2                    NaN                  NaN  ...            NaN   \n",
       "4                    NaN                  NaN  ...            NaN   \n",
       "6                    NaN                  NaN  ...            NaN   \n",
       "7                    NaN                  NaN  ...            NaN   \n",
       "...                  ...                  ...  ...            ...   \n",
       "3680                 NaN                  NaN  ...            NaN   \n",
       "3681                 NaN                  NaN  ...            NaN   \n",
       "3683                 NaN                  NaN  ...            NaN   \n",
       "3686                 NaN                  NaN  ...            NaN   \n",
       "3687                 NaN                  NaN  ...            NaN   \n",
       "\n",
       "     block_save_block foul_committed_penalty foul_won_penalty  \\\n",
       "1                 NaN                    NaN              NaN   \n",
       "2                 NaN                    NaN              NaN   \n",
       "4                 NaN                    NaN              NaN   \n",
       "6                 NaN                    NaN              NaN   \n",
       "7                 NaN                    NaN              NaN   \n",
       "...               ...                    ...              ...   \n",
       "3680              NaN                    NaN              NaN   \n",
       "3681              NaN                    NaN              NaN   \n",
       "3683              NaN                    NaN              NaN   \n",
       "3686              NaN                    NaN              NaN   \n",
       "3687              NaN                    NaN              NaN   \n",
       "\n",
       "     goalkeeper_punched_out goalkeeper_shot_saved_off_target  \\\n",
       "1                       NaN                              NaN   \n",
       "2                       NaN                              NaN   \n",
       "4                       NaN                              NaN   \n",
       "6                       NaN                              NaN   \n",
       "7                       NaN                              NaN   \n",
       "...                     ...                              ...   \n",
       "3680                    NaN                              NaN   \n",
       "3681                    NaN                              NaN   \n",
       "3683                    NaN                              NaN   \n",
       "3686                    NaN                              NaN   \n",
       "3687                    NaN                              NaN   \n",
       "\n",
       "      shot_saved_off_target dribble_no_touch goalkeeper_success_in_play  \\\n",
       "1                       NaN              NaN                        NaN   \n",
       "2                       NaN              NaN                        NaN   \n",
       "4                       NaN              NaN                        NaN   \n",
       "6                       NaN              NaN                        NaN   \n",
       "7                       NaN              NaN                        NaN   \n",
       "...                     ...              ...                        ...   \n",
       "3680                    NaN              NaN                        NaN   \n",
       "3681                    NaN              NaN                        NaN   \n",
       "3683                    NaN              NaN                        NaN   \n",
       "3686                    NaN              NaN                        NaN   \n",
       "3687                    NaN              NaN                        NaN   \n",
       "\n",
       "     goalkeeper_lost_in_play  \n",
       "1                        NaN  \n",
       "2                        NaN  \n",
       "4                        NaN  \n",
       "6                        NaN  \n",
       "7                        NaN  \n",
       "...                      ...  \n",
       "3680                     NaN  \n",
       "3681                     NaN  \n",
       "3683                     NaN  \n",
       "3686                     NaN  \n",
       "3687                     NaN  \n",
       "\n",
       "[80858 rows x 106 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "E = events[events['team']=='Barcelona']\n",
    "E"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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>type</th>\n",
       "      <th>shot_body_part</th>\n",
       "      <th>shot_first_time</th>\n",
       "      <th>shot_one_on_one</th>\n",
       "      <th>shot_open_goal</th>\n",
       "      <th>shot_outcome</th>\n",
       "      <th>shot_statsbomb_xg</th>\n",
       "      <th>shot_technique</th>\n",
       "      <th>shot_type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Starting XI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Half Start</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Half Start</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Pass</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Pass</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3680</th>\n",
       "      <td>Half End</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3681</th>\n",
       "      <td>Half End</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3683</th>\n",
       "      <td>Substitution</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3686</th>\n",
       "      <td>Substitution</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3687</th>\n",
       "      <td>Substitution</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>80858 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              type shot_body_part shot_first_time shot_one_on_one  \\\n",
       "1      Starting XI            NaN             NaN             NaN   \n",
       "2       Half Start            NaN             NaN             NaN   \n",
       "4       Half Start            NaN             NaN             NaN   \n",
       "6             Pass            NaN             NaN             NaN   \n",
       "7             Pass            NaN             NaN             NaN   \n",
       "...            ...            ...             ...             ...   \n",
       "3680      Half End            NaN             NaN             NaN   \n",
       "3681      Half End            NaN             NaN             NaN   \n",
       "3683  Substitution            NaN             NaN             NaN   \n",
       "3686  Substitution            NaN             NaN             NaN   \n",
       "3687  Substitution            NaN             NaN             NaN   \n",
       "\n",
       "     shot_open_goal shot_outcome  shot_statsbomb_xg shot_technique shot_type  \n",
       "1               NaN          NaN                NaN            NaN       NaN  \n",
       "2               NaN          NaN                NaN            NaN       NaN  \n",
       "4               NaN          NaN                NaN            NaN       NaN  \n",
       "6               NaN          NaN                NaN            NaN       NaN  \n",
       "7               NaN          NaN                NaN            NaN       NaN  \n",
       "...             ...          ...                ...            ...       ...  \n",
       "3680            NaN          NaN                NaN            NaN       NaN  \n",
       "3681            NaN          NaN                NaN            NaN       NaN  \n",
       "3683            NaN          NaN                NaN            NaN       NaN  \n",
       "3686            NaN          NaN                NaN            NaN       NaN  \n",
       "3687            NaN          NaN                NaN            NaN       NaN  \n",
       "\n",
       "[80858 rows x 9 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "E_shot = E[['type', 'shot_body_part', 'shot_first_time', 'shot_one_on_one',\n",
    "       'shot_open_goal', 'shot_outcome', 'shot_statsbomb_xg', 'shot_technique',\n",
    "       'shot_type']]\n",
    "E_shot"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Starting XI', 'Half Start', 'Pass', 'Ball Receipt*', 'Carry',\n",
       "       'Pressure', 'Dribble', 'Duel', 'Foul Committed', 'Foul Won',\n",
       "       'Dribbled Past', 'Ball Recovery', 'Dispossessed', 'Miscontrol',\n",
       "       'Shot', 'Goal Keeper', 'Clearance', 'Block', 'Injury Stoppage',\n",
       "       'Half End', 'Substitution', 'Tactical Shift', 'Player Off',\n",
       "       'Player On', 'Referee Ball-Drop', 'Interception', '50/50',\n",
       "       'Shield', 'Bad Behaviour', 'Offside', 'Error', 'Own Goal For'],\n",
       "      dtype=object)"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "E_shot.type.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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>type</th>\n",
       "      <th>shot_body_part</th>\n",
       "      <th>shot_first_time</th>\n",
       "      <th>shot_one_on_one</th>\n",
       "      <th>shot_open_goal</th>\n",
       "      <th>shot_outcome</th>\n",
       "      <th>shot_statsbomb_xg</th>\n",
       "      <th>shot_technique</th>\n",
       "      <th>shot_type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3846</th>\n",
       "      <td>Shot</td>\n",
       "      <td>Right Foot</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Post</td>\n",
       "      <td>0.029270</td>\n",
       "      <td>Normal</td>\n",
       "      <td>Open Play</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3848</th>\n",
       "      <td>Shot</td>\n",
       "      <td>Right Foot</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Off T</td>\n",
       "      <td>0.026954</td>\n",
       "      <td>Normal</td>\n",
       "      <td>Open Play</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3849</th>\n",
       "      <td>Shot</td>\n",
       "      <td>Right Foot</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Post</td>\n",
       "      <td>0.029080</td>\n",
       "      <td>Half Volley</td>\n",
       "      <td>Open Play</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3852</th>\n",
       "      <td>Shot</td>\n",
       "      <td>Left Foot</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Post</td>\n",
       "      <td>0.039079</td>\n",
       "      <td>Normal</td>\n",
       "      <td>Open Play</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3853</th>\n",
       "      <td>Shot</td>\n",
       "      <td>Left Foot</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Saved</td>\n",
       "      <td>0.163406</td>\n",
       "      <td>Half Volley</td>\n",
       "      <td>Open Play</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3621</th>\n",
       "      <td>Shot</td>\n",
       "      <td>Left Foot</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Saved</td>\n",
       "      <td>0.250509</td>\n",
       "      <td>Half Volley</td>\n",
       "      <td>Open Play</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3629</th>\n",
       "      <td>Shot</td>\n",
       "      <td>Left Foot</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Saved Off Target</td>\n",
       "      <td>0.067505</td>\n",
       "      <td>Normal</td>\n",
       "      <td>Free Kick</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3630</th>\n",
       "      <td>Shot</td>\n",
       "      <td>Left Foot</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>Goal</td>\n",
       "      <td>0.835386</td>\n",
       "      <td>Normal</td>\n",
       "      <td>Open Play</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3631</th>\n",
       "      <td>Shot</td>\n",
       "      <td>Left Foot</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Saved</td>\n",
       "      <td>0.364813</td>\n",
       "      <td>Normal</td>\n",
       "      <td>Open Play</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3632</th>\n",
       "      <td>Shot</td>\n",
       "      <td>Right Foot</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>Goal</td>\n",
       "      <td>0.904528</td>\n",
       "      <td>Normal</td>\n",
       "      <td>Open Play</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>430 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      type shot_body_part shot_first_time shot_one_on_one shot_open_goal  \\\n",
       "3846  Shot     Right Foot             NaN             NaN            NaN   \n",
       "3848  Shot     Right Foot             NaN             NaN            NaN   \n",
       "3849  Shot     Right Foot            True             NaN            NaN   \n",
       "3852  Shot      Left Foot             NaN             NaN            NaN   \n",
       "3853  Shot      Left Foot             NaN            True            NaN   \n",
       "...    ...            ...             ...             ...            ...   \n",
       "3621  Shot      Left Foot            True             NaN            NaN   \n",
       "3629  Shot      Left Foot             NaN             NaN            NaN   \n",
       "3630  Shot      Left Foot             NaN             NaN           True   \n",
       "3631  Shot      Left Foot             NaN            True            NaN   \n",
       "3632  Shot     Right Foot            True             NaN           True   \n",
       "\n",
       "          shot_outcome  shot_statsbomb_xg shot_technique  shot_type  \n",
       "3846              Post           0.029270         Normal  Open Play  \n",
       "3848             Off T           0.026954         Normal  Open Play  \n",
       "3849              Post           0.029080    Half Volley  Open Play  \n",
       "3852              Post           0.039079         Normal  Open Play  \n",
       "3853             Saved           0.163406    Half Volley  Open Play  \n",
       "...                ...                ...            ...        ...  \n",
       "3621             Saved           0.250509    Half Volley  Open Play  \n",
       "3629  Saved Off Target           0.067505         Normal  Free Kick  \n",
       "3630              Goal           0.835386         Normal  Open Play  \n",
       "3631             Saved           0.364813         Normal  Open Play  \n",
       "3632              Goal           0.904528         Normal  Open Play  \n",
       "\n",
       "[430 rows x 9 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "E_shot = E_shot[E_shot['type']=='Shot']\n",
    "E_shot"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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>shot_body_part</th>\n",
       "      <th>shot_first_time</th>\n",
       "      <th>shot_one_on_one</th>\n",
       "      <th>shot_open_goal</th>\n",
       "      <th>shot_statsbomb_xg</th>\n",
       "      <th>shot_technique</th>\n",
       "      <th>shot_type</th>\n",
       "      <th>shot_outcome</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Right Foot</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.029270</td>\n",
       "      <td>Normal</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>Post</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Right Foot</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.026954</td>\n",
       "      <td>Normal</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>Off T</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Right Foot</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.029080</td>\n",
       "      <td>Half Volley</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>Post</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Left Foot</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.039079</td>\n",
       "      <td>Normal</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>Post</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Left Foot</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.163406</td>\n",
       "      <td>Half Volley</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>Saved</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>425</th>\n",
       "      <td>Left Foot</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.250509</td>\n",
       "      <td>Half Volley</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>Saved</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>426</th>\n",
       "      <td>Left Foot</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.067505</td>\n",
       "      <td>Normal</td>\n",
       "      <td>Free Kick</td>\n",
       "      <td>Saved Off Target</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>427</th>\n",
       "      <td>Left Foot</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>0.835386</td>\n",
       "      <td>Normal</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>Goal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>428</th>\n",
       "      <td>Left Foot</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.364813</td>\n",
       "      <td>Normal</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>Saved</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>429</th>\n",
       "      <td>Right Foot</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>0.904528</td>\n",
       "      <td>Normal</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>Goal</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>430 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    shot_body_part shot_first_time shot_one_on_one shot_open_goal  \\\n",
       "0       Right Foot             NaN             NaN            NaN   \n",
       "1       Right Foot             NaN             NaN            NaN   \n",
       "2       Right Foot            True             NaN            NaN   \n",
       "3        Left Foot             NaN             NaN            NaN   \n",
       "4        Left Foot             NaN            True            NaN   \n",
       "..             ...             ...             ...            ...   \n",
       "425      Left Foot            True             NaN            NaN   \n",
       "426      Left Foot             NaN             NaN            NaN   \n",
       "427      Left Foot             NaN             NaN           True   \n",
       "428      Left Foot             NaN            True            NaN   \n",
       "429     Right Foot            True             NaN           True   \n",
       "\n",
       "     shot_statsbomb_xg shot_technique  shot_type      shot_outcome  \n",
       "0             0.029270         Normal  Open Play              Post  \n",
       "1             0.026954         Normal  Open Play             Off T  \n",
       "2             0.029080    Half Volley  Open Play              Post  \n",
       "3             0.039079         Normal  Open Play              Post  \n",
       "4             0.163406    Half Volley  Open Play             Saved  \n",
       "..                 ...            ...        ...               ...  \n",
       "425           0.250509    Half Volley  Open Play             Saved  \n",
       "426           0.067505         Normal  Free Kick  Saved Off Target  \n",
       "427           0.835386         Normal  Open Play              Goal  \n",
       "428           0.364813         Normal  Open Play             Saved  \n",
       "429           0.904528         Normal  Open Play              Goal  \n",
       "\n",
       "[430 rows x 8 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "E_shot = E_shot.reset_index()\n",
    "E_shot = E_shot[['shot_body_part', 'shot_first_time', 'shot_one_on_one',\n",
    "            'shot_open_goal', 'shot_statsbomb_xg', 'shot_technique',\n",
    "            'shot_type', 'shot_outcome']]\n",
    "E_shot"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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>shot_body_part</th>\n",
       "      <th>shot_first_time</th>\n",
       "      <th>shot_one_on_one</th>\n",
       "      <th>shot_open_goal</th>\n",
       "      <th>shot_statsbomb_xg</th>\n",
       "      <th>shot_technique</th>\n",
       "      <th>shot_type</th>\n",
       "      <th>shot_outcome</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.029270</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.026954</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1.0</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.029080</td>\n",
       "      <td>0.6</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.039079</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.163406</td>\n",
       "      <td>0.6</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>425</th>\n",
       "      <td>1.0</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.250509</td>\n",
       "      <td>0.6</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>426</th>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.067505</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Free Kick</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>427</th>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>0.835386</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>428</th>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.364813</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>429</th>\n",
       "      <td>1.0</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>0.904528</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Open Play</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>430 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     shot_body_part shot_first_time shot_one_on_one shot_open_goal  \\\n",
       "0               1.0             NaN             NaN            NaN   \n",
       "1               1.0             NaN             NaN            NaN   \n",
       "2               1.0            True             NaN            NaN   \n",
       "3               1.0             NaN             NaN            NaN   \n",
       "4               1.0             NaN            True            NaN   \n",
       "..              ...             ...             ...            ...   \n",
       "425             1.0            True             NaN            NaN   \n",
       "426             1.0             NaN             NaN            NaN   \n",
       "427             1.0             NaN             NaN           True   \n",
       "428             1.0             NaN            True            NaN   \n",
       "429             1.0            True             NaN           True   \n",
       "\n",
       "     shot_statsbomb_xg  shot_technique  shot_type  shot_outcome  \n",
       "0             0.029270             1.0  Open Play             1  \n",
       "1             0.026954             1.0  Open Play             0  \n",
       "2             0.029080             0.6  Open Play             1  \n",
       "3             0.039079             1.0  Open Play             1  \n",
       "4             0.163406             0.6  Open Play             1  \n",
       "..                 ...             ...        ...           ...  \n",
       "425           0.250509             0.6  Open Play             1  \n",
       "426           0.067505             1.0  Free Kick             0  \n",
       "427           0.835386             1.0  Open Play             2  \n",
       "428           0.364813             1.0  Open Play             1  \n",
       "429           0.904528             1.0  Open Play             2  \n",
       "\n",
       "[430 rows x 8 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "E_shot['shot_body_part'] = E_shot['shot_body_part'].replace(['Right Foot', 'Left Foot', 'Head', 'Other'], [1., 1., 0.5, 0.2])\n",
    "E_shot['shot_outcome'] = E_shot['shot_outcome'].replace(['Post', 'Off T', 'Blocked', 'Saved', 'Goal', 'Wayward',\n",
    "       'Saved to Post', 'Saved Off Target'], [1, 0, 1, 1, 2, 0, 1, 0])\n",
    "E_shot['shot_technique'] = E_shot['shot_technique'].replace(['Normal', 'Half Volley', 'Volley', 'Lob', 'Diving Header',\n",
    "       'Overhead Kick', 'Backheel'], [1., 0.6, 0.6, 0.5, 0.2, 0.1, 0.1])\n",
    "E_shot"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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>shot_body_part</th>\n",
       "      <th>shot_first_time</th>\n",
       "      <th>shot_one_on_one</th>\n",
       "      <th>shot_open_goal</th>\n",
       "      <th>shot_statsbomb_xg</th>\n",
       "      <th>shot_technique</th>\n",
       "      <th>shot_type</th>\n",
       "      <th>shot_outcome</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.029270</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.026954</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1.0</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.029080</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.039079</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.163406</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>425</th>\n",
       "      <td>1.0</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.250509</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>426</th>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.067505</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>427</th>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>0.835386</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>428</th>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.364813</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>429</th>\n",
       "      <td>1.0</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>0.904528</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>430 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     shot_body_part shot_first_time shot_one_on_one shot_open_goal  \\\n",
       "0               1.0             NaN             NaN            NaN   \n",
       "1               1.0             NaN             NaN            NaN   \n",
       "2               1.0            True             NaN            NaN   \n",
       "3               1.0             NaN             NaN            NaN   \n",
       "4               1.0             NaN            True            NaN   \n",
       "..              ...             ...             ...            ...   \n",
       "425             1.0            True             NaN            NaN   \n",
       "426             1.0             NaN             NaN            NaN   \n",
       "427             1.0             NaN             NaN           True   \n",
       "428             1.0             NaN            True            NaN   \n",
       "429             1.0            True             NaN           True   \n",
       "\n",
       "     shot_statsbomb_xg  shot_technique  shot_type  shot_outcome  \n",
       "0             0.029270             1.0        0.8             1  \n",
       "1             0.026954             1.0        0.8             0  \n",
       "2             0.029080             0.6        0.8             1  \n",
       "3             0.039079             1.0        0.8             1  \n",
       "4             0.163406             0.6        0.8             1  \n",
       "..                 ...             ...        ...           ...  \n",
       "425           0.250509             0.6        0.8             1  \n",
       "426           0.067505             1.0        0.6             0  \n",
       "427           0.835386             1.0        0.8             2  \n",
       "428           0.364813             1.0        0.8             1  \n",
       "429           0.904528             1.0        0.8             2  \n",
       "\n",
       "[430 rows x 8 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "E_shot['shot_type'] = E_shot['shot_type'].replace(['Open Play', 'Free Kick', 'Penalty'], [0.8, 0.6, 1.])\n",
    "E_shot"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "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>shot_body_part</th>\n",
       "      <th>shot_first_time</th>\n",
       "      <th>shot_one_on_one</th>\n",
       "      <th>shot_open_goal</th>\n",
       "      <th>shot_statsbomb_xg</th>\n",
       "      <th>shot_technique</th>\n",
       "      <th>shot_type</th>\n",
       "      <th>shot_outcome</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.029270</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.026954</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.029080</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.039079</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.163406</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>425</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.250509</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>426</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.067505</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>427</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.835386</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>428</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.364813</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>429</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.904528</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>430 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     shot_body_part  shot_first_time  shot_one_on_one  shot_open_goal  \\\n",
       "0               1.0                0                0               0   \n",
       "1               1.0                0                0               0   \n",
       "2               1.0                1                0               0   \n",
       "3               1.0                0                0               0   \n",
       "4               1.0                0                1               0   \n",
       "..              ...              ...              ...             ...   \n",
       "425             1.0                1                0               0   \n",
       "426             1.0                0                0               0   \n",
       "427             1.0                0                0               1   \n",
       "428             1.0                0                1               0   \n",
       "429             1.0                1                0               1   \n",
       "\n",
       "     shot_statsbomb_xg  shot_technique  shot_type  shot_outcome  \n",
       "0             0.029270             1.0        0.8             1  \n",
       "1             0.026954             1.0        0.8             0  \n",
       "2             0.029080             0.6        0.8             1  \n",
       "3             0.039079             1.0        0.8             1  \n",
       "4             0.163406             0.6        0.8             1  \n",
       "..                 ...             ...        ...           ...  \n",
       "425           0.250509             0.6        0.8             1  \n",
       "426           0.067505             1.0        0.6             0  \n",
       "427           0.835386             1.0        0.8             2  \n",
       "428           0.364813             1.0        0.8             1  \n",
       "429           0.904528             1.0        0.8             2  \n",
       "\n",
       "[430 rows x 8 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "E_shot['shot_first_time'] = E_shot['shot_first_time'].fillna(0)\n",
    "E_shot['shot_first_time'] = E_shot['shot_first_time'].replace([True], [1])\n",
    "E_shot['shot_one_on_one'] = E_shot['shot_one_on_one'].fillna(0)\n",
    "E_shot['shot_one_on_one'] = E_shot['shot_one_on_one'].replace([True], [1])\n",
    "E_shot['shot_open_goal'] = E_shot['shot_open_goal'].fillna(0)\n",
    "E_shot['shot_open_goal'] = E_shot['shot_open_goal'].replace([True], [1])\n",
    "E_shot"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "((430, 7), (430,))"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "x = E_shot[['shot_body_part', 'shot_first_time', 'shot_one_on_one',\n",
    "            'shot_open_goal', 'shot_statsbomb_xg', 'shot_technique',\n",
    "            'shot_type']]\n",
    "y = E_shot['shot_outcome']\n",
    "x.shape, y.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "km = KMeans(n_clusters = 3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([0, 0, 2, 0, 1, 0, 2, 1, 1, 1, 1, 2, 0, 2, 2, 0, 2, 0, 0, 0, 0, 0,\n",
       "       0, 0, 1, 1, 0, 0, 0, 2, 0, 2, 2, 0, 0, 0, 2, 0, 0, 0, 0, 2, 0, 2,\n",
       "       0, 2, 0, 0, 0, 2, 0, 2, 0, 2, 2, 0, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0,\n",
       "       0, 0, 0, 0, 2, 2, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 2, 0, 0, 0, 0,\n",
       "       0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 1, 0, 0, 1, 0, 2, 0, 2,\n",
       "       2, 0, 0, 2, 2, 0, 0, 0, 0, 0, 0, 0, 2, 2, 2, 0, 2, 0, 0, 0, 0, 2,\n",
       "       0, 1, 2, 2, 0, 0, 0, 2, 0, 1, 2, 1, 0, 0, 0, 2, 0, 2, 0, 0, 0, 2,\n",
       "       0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0,\n",
       "       2, 0, 0, 2, 0, 0, 0, 1, 2, 2, 0, 2, 1, 2, 2, 0, 1, 0, 1, 2, 0, 2,\n",
       "       2, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 2, 0, 2,\n",
       "       0, 2, 2, 2, 2, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 2, 1, 2,\n",
       "       1, 1, 2, 0, 2, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 2, 2, 2, 2, 1,\n",
       "       0, 1, 2, 0, 1, 0, 0, 1, 0, 2, 0, 2, 2, 0, 2, 1, 0, 0, 0, 0, 0, 2,\n",
       "       0, 0, 0, 0, 0, 2, 0, 0, 2, 2, 2, 2, 2, 1, 0, 0, 2, 0, 2, 2, 1, 2,\n",
       "       0, 0, 0, 1, 0, 1, 2, 0, 0, 1, 1, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0,\n",
       "       0, 0, 0, 0, 2, 2, 0, 1, 2, 2, 0, 1, 0, 0, 2, 2, 1, 0, 2, 0, 0, 2,\n",
       "       0, 2, 0, 0, 2, 0, 0, 2, 2, 0, 1, 2, 0, 0, 0, 0, 1, 1, 0, 0, 2, 0,\n",
       "       0, 2, 0, 2, 2, 2, 2, 2, 2, 2, 0, 2, 2, 1, 0, 2, 0, 1, 0, 0, 0, 0,\n",
       "       0, 1, 2, 0, 0, 0, 0, 0, 2, 0, 0, 2, 0, 0, 0, 0, 2, 1, 0, 0, 0, 0,\n",
       "       0, 1, 2, 1, 2, 0, 2, 2, 0, 0, 1, 2])"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "y_cluster = km.fit_predict(E_shot[['shot_body_part', 'shot_first_time', 'shot_one_on_one',\n",
    "            'shot_open_goal', 'shot_statsbomb_xg', 'shot_technique']])\n",
    "y_cluster\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "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>shot_body_part</th>\n",
       "      <th>shot_first_time</th>\n",
       "      <th>shot_one_on_one</th>\n",
       "      <th>shot_open_goal</th>\n",
       "      <th>shot_statsbomb_xg</th>\n",
       "      <th>shot_technique</th>\n",
       "      <th>shot_type</th>\n",
       "      <th>shot_outcome</th>\n",
       "      <th>cluster</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.029270</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.026954</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.029080</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.039079</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.163406</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>425</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.250509</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>426</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.067505</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>427</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.835386</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>428</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.364813</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>429</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.904528</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>430 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     shot_body_part  shot_first_time  shot_one_on_one  shot_open_goal  \\\n",
       "0               1.0                0                0               0   \n",
       "1               1.0                0                0               0   \n",
       "2               1.0                1                0               0   \n",
       "3               1.0                0                0               0   \n",
       "4               1.0                0                1               0   \n",
       "..              ...              ...              ...             ...   \n",
       "425             1.0                1                0               0   \n",
       "426             1.0                0                0               0   \n",
       "427             1.0                0                0               1   \n",
       "428             1.0                0                1               0   \n",
       "429             1.0                1                0               1   \n",
       "\n",
       "     shot_statsbomb_xg  shot_technique  shot_type  shot_outcome  cluster  \n",
       "0             0.029270             1.0        0.8             1        0  \n",
       "1             0.026954             1.0        0.8             0        0  \n",
       "2             0.029080             0.6        0.8             1        2  \n",
       "3             0.039079             1.0        0.8             1        0  \n",
       "4             0.163406             0.6        0.8             1        1  \n",
       "..                 ...             ...        ...           ...      ...  \n",
       "425           0.250509             0.6        0.8             1        2  \n",
       "426           0.067505             1.0        0.6             0        0  \n",
       "427           0.835386             1.0        0.8             2        0  \n",
       "428           0.364813             1.0        0.8             1        1  \n",
       "429           0.904528             1.0        0.8             2        2  \n",
       "\n",
       "[430 rows x 9 columns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "E_shot['cluster'] = y_cluster\n",
    "E_shot"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYMAAAEHCAYAAABMRSrcAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8vihELAAAACXBIWXMAAAsTAAALEwEAmpwYAAArk0lEQVR4nO3df3xcdZ3v8dcnkxky/REi7YhC20yrUAq1tKUEoaggUH6sWnXZ1YCCGhdZtqh4l1Wuu+rq5a5cXUWtil2m/PJu/I2tilKQH15xtT9opS2l0i3TNgVhWkilacpMJp/7x5mkk2SSzCSZ/Or7+XjMI3O+8z3f8znfSeaT8z1nvsfcHRERObpVjHQAIiIy8pQMREREyUBERJQMREQEJQMREQEqRzqAgZg6darH4/GRDkNEZEzZsGHDPnePFXptTCaDeDzO+vXrRzoMEZExxcx29faaholERETJQERElAxERAQlAxERQclAREQo89VEZrYSeBvwgrvPLfC6AV8DLgMOAR9w98fLGVPq4Z+T/OKnmLR1B4+9NsPjr27npH1w2j6Y/ufjeCx6Mo/P2s9rQs9ReUwr2XAlB0IZXvdiO5tnRGmLvpoJvI4XK57lz9mDnNqS4cIXK3jizPkk4yeTat5K1d6DXJA8yNKXgLlvI1kzn/h5cWKRA6R+/xAbt25l6+T5PD3pFU5qjTL5hL2sO7SXZ1tn8dY5V3HJKc6ex++Ggy1Mb/oLm0Mhnk8fx8LXTiFy2QLi888HINmcZFJLmoO7dhCfXQfROSQ3vkR86y/Y98ReHqyay/FT1nP+qScSu2gp/OlPcO+9cOKJcNppMH06HDwIkybBwYNsOzbNg3/ewfFtdZx/TAgef5xkdA5xksRad8PChdDSQqo5TJI48ZpmYtOrYM+eoG9Pmc7DW5p4/g81XLhkFnMWTznS79v2kVz7ApPmVXDw1S8Tr4kTmxjrLI/XvZrYnKlB3ZZUsG8vTObgE+091gkqpWDjRmhuhpoaWLAAgMfu/jVrNj3LkpOOZfEbpwflsZ5X0nVsI14T7+zLzphSkExCPB6smmpJsfGZJDTHWTA7Vqi5nu3n2sh1bWdbhba/79A+Htz5IMdPPJ7zZ57fGcPG7SmoSbJgZt5+D1QqRWr7RpI1EJ+5oMc+D7fufTxk7eb1a8d+pVLw8JfX8/yj27nw6hOY8/fnF79ugbK+AyjTjvUR41Cxcs5aamZvBg4Cd/eSDC4DridIBmcBX3P3s/prd9GiRT6QS0sbr3gDDbO2gENruEAFrwBrL7ndXrUb4XvvYMKWpaSJ0DD3AlYsXUfaQhBK976eG1jh9yWSCUHY8YoQlQ6tniHaBllC+M/uYMITb6eFibTN/SEs/TBkI1SGDnH3qgz1Wwo1GIF0muvfVsHyM/L2/Q9/T+RXXyVKK2kiJPgQ9XyfRt5LAwkipLuWz4WrloZpy04I9m1VgmUnLOQb98+m8frHaFi+AOY20rr0eqKhCoi00/DiP5H4yj8RIUOaMIllG+Ga3TSsboB0Ba3ZdsIb3kfmjO92rpNYmqB+M3D11ZDJHIk3FGLJnCt5YOkPIRuBUJolqy7n/j99H+68E+rrO6s2bm6kYXUDkVCEQ+lDWIURrYySzqZpmJogcUN9R7fQ8NVGVjzfQLo1aDN8X4K7bqzPb66HxkZoaAiet7ZCNBo8TySCMPK335Juoc3bOtetoILrXvNdvrMCMpc2QDZCJJrmzncnqJ/bx0b70thI45evpuHSDJEsHKoKYaFQ5z4nlg6i7YGFQ0ND569eZ78Mut28fu3YLzbXc9UVbbQR6qy37Lj/5Bv7r+x/XadHWZ/9VK4d6yPGUt83M9vg7osKvlbuKazNLA78vJdk8B3gEXdvzC1vB85z9+f6anMgySD18M+p/fXbCyeBcspUwVd3B89vqIVwaxm3FYWv7iq4raqMsfurTuxQz9W2TYFTlwGWV+jA8idh/xwAohxiAws5g8dpZUJntSiH2DBhOgtveInD4bzfpUwUvprktytauOh9x9M6oaXn/nfEeyj4D6dqwi7spjm0ZvPqeNe4opVRdv17O7GXXumyD49NeB3n3vBsj/Z/+9UTWOzPwq5dEIuRaklRe2strW29vA/5MU1IFYy56tu72P1U4SOEVApqa4Mk0F00ChueSnHGPX1sHyATAUJdthutjLLr47tK/28wlSJ1ygxq//5wr7/7A257AAr1TzTa+fYMvN0C72u0Mkr7l3byyoHXdKvtPPmtRzqPEHpb1905nD3cpazXfirXjvWzf6W+b30lg5E+Z3AisCdvuSlX1oOZXWNm681sfSqVKnlDyUd+SiQ7sCAHxYGaZPDIljkTZcN524p0ecmylSRrCq+2dlov7U1b2/k0TIa1nEWErkc0YTKsrTkey3YbcczFsuYHzUTIFIyJbGVQnhOq2UlFe4i+hKkgeZz1KF9TM7tA++GgvKIiOHQnGBqJhCI91u/UHj4SU8GYw4SmJDua6yGZDP4xLBh7GNZu72f7ECS/9q5/mhWESTb3stG+JJMkp4b6/N0PhwbY9gAU6p9wmF77s+h2C7yvFYRh8s6C9dc2HikvuK5VEKro+rvYZz+Va8f6iHGo37eRTgY9/6qDj8+ehe4r3H2Ruy+KDSDTxs97J+m+P2fKw4DmePAIZfqpPEihTN62un5oe6iNeHPh1eqaemmvqa7zaYYwdfyBNF1/ITOEqWt+Hg+1dV03F8uSv60hTbhgTITagvKcbPMs2iv6ztgZ2om/2PNXZEnz9gLtZ4Ly9vZgDBeI18RJZ/sYoqvIHImpYMwZsvvj9DYbSjwejBAUjD0DdbP72T4EfwEVXYcr28l0nt8oSTxOfF+2z9/9THaAbQ9Aof7JZOi1P4tut8D72k4GXp5VsH5d/ZHygut6O9n2rr+LffZTuXasjxiH+n0b6WTQBEzPW54GPFuODcXOfxuJnW8gmoGqNMEfXPdHe0Xh8oE+skZ41W1UH4oQPTSRZatOD8b82yJ9r9duvb4WSYeIeAVhC1NFGByimeBcQvhn36H6UITKQzWwKhEMeRyupjITZuWqwkNERCLM2Q/L1nfb5h/+nsj+WVRzgCiHSPAh5rCdBB8iyqGu5YdeZOUqpzIThsPVwXZXJVh27kssvnImiWUbiR6aSNWqb0AmSrR9ItHKKMta/4nooYmdba38UBOJdyaIVgZ1yESp/MPfdVknsTRB7Jt3BP915Vn8SpIlqy7v3GcyUZasupzFbXuCsdvcPxCxiTESS4NtVB9TTdjCREIRqo+pDmKaniDqMaqrIeoxlk1PELEjbYbvS7Byee8nkWOxYHPR6JFzBVVVwfNEAubM6Lr9yoquR1QVVLBs+p2E7zvy/kUst98DGcaJxYgtX0nivjDRDFQfhjChLvs84LYHIL9/qquP9MtgR1K6v68d+3XHt19DJW3k/3IvO+4/u5xE7m3dle9c2aOs134q1471E+NQvm8jfc7gr4BlHDmB/HV3r+ter7uBnkAGXU2kq4nosg1dTaSrifpcd5xdTTRiJ5DNrBE4D5gKPA98FggDuPttuUtLlwOXEFxa+kF37/dTfjDJQETkaNVXMijr9wzcvc/rnjzIRP9QzhhERKR/I33OQERERgElAxERUTIQERElAxERQclARERQMhAREZQMREQEJQMREUHJQEREUDIQERGUDEREBCUDERFByUBERFAyEBERlAxERAQlAxERQclARERQMhAREZQMREQEJQMREUHJQEREUDIQERGUDEREBCUDERFByUBERFAyEBERlAxERAQlAxERQclARERQMhAREZQMREQEJQMREUHJQEREUDIQERGUDEREhGFIBmZ2iZltN7MdZvapAq8fa2Y/M7M/mtlWM/tguWMSEZGuypoMzCwEfBO4FDgVqDezU7tV+wfgSXc/HTgP+Hczi5QzLhER6arcRwZ1wA533+nuaeB7wNJudRyYbGYGTAJeBNrKHJeIiOQpdzI4EdiTt9yUK8u3HJgDPAtsBj7m7u3dGzKza8xsvZmtT6VS5YpXROSoVO5kYAXKvNvyxcAm4ARgPrDczKp7rOS+wt0XufuiWCw21HGKiBzVyp0MmoDpecvTCI4A8n0Q+IkHdgDPAKeUOS4REclT7mSwDjjJzGbmTgq/F1jdrc5u4AIAMzsemA3sLHNcIiKSp7Kcjbt7m5ktA+4HQsBKd99qZtfmXr8N+AJwp5ltJhhW+qS77ytnXCIi0lVZkwGAu98H3Net7La8588CS8odh4iI9E7fQBYRESUDERFRMhAREZQMREQEJQMREUHJQEREUDIQERGUDEREBCUDERFByUBERFAyEBERlAxERAQlAxERQclAREQoIRmY2clm9msz25Jbnmdm/1y+0EREZLiUcmTwH8BNQAbA3Z8guHOZiIiMcaUkgwnuvrZbWdtQBiMiIiOjlGSwz8xeBziAmV0OPFeWqEREZFiVctvLfwBWAKeY2V7gGeB9ZYlKRESGVdHJwN13Ahea2USgwt1fLl9YIiIynIpOBmb2mW7LALj754c4JhERGWalDBO15D2vAt4GbBvacEREZCSUMkz07/nLZvZlYPWQRyQiIsNuMN9AngDMGqpARERk5JRyzmAzuctKgRAQA3S+QERkHCjlnMHb8p63Ac+7u750JiIyDpSSDLpfSlrdcUURgLu/OCQRiYjIsCslGTwOTAdeAgyoAXbnXnN0/kBEZMwq5QTyr4C3u/tUd59CMGz0E3ef6e5KBCIiY1gpyeBMd7+vY8Hdfwm8ZehDEhGR4VbKMNG+3P0LvkswLPQ+YH9ZohIRkWFVypFBPcHlpPcCPwVenSsTEZExrpRvIL8IfKyMsYiIyAjpNxmY2a3u/nEz+xlHvnTWyd3fUZbIRERk2BRzZHBP7ueXyxmIiIiMnH6TgbtvyP18dCAbMLNLgK8RTGFxu7t/sUCd84BbgTCwz93LcpVSqiVFsjlJvCZObPc+WLuW1LzX83B4L3/cswO2H2bmczuoPm06NVOnseC1C+HXvyb55O+YdOlSDp6ziEmRSew5sAeABa9dAMDG5zYGyy9PhN88SrIG4ue/i9iMOV22vfG5jTQfbgagpqqGBa9dQGxi7Eid3dtIbl9L+vgpPN76DMdPPJ7zZ54PQLI5SbplEjt2HaRudpw5M2KkUrBxewpqkkw/fhIH0weJ18Rh/z6S29cSn13XI4Zkc5JJLWkO7trR4/XOeilIJmHS8SkOhpJMihxpOzYxxrbUNtbuXcvrJ9QROTCHeByYkNe3+fvUkmLjM0maX5gEx+6h5lg69zv//ejSj936Zch07Fg8DrHC7Xe8B731zRBtRmTUMfceIz+FK5otBj4H1BIkEQO8r+8YmFkI+BNwEdAErAPq3f3JvDo1wO+AS9x9t5m92t1f6CuWRYsW+fr164uKu0Pj5kYaVjcQCUVIH24h8eNgJo33vwuyvZxGr2iHSodQO7SGIdwOmdCR1ysrKnF3sp6FXL0KhwltkA5BYvoy6j/yDRo3N3L1vVeT8UyX9iOhCHe+807q59bT+J3radiznDbLbSP35W7DqLRK8Eoy3gptUQCWtCZ4+BHIXNoQDN5FWolWRsm2ZfC2NiZkIV3RNYaG1Q2QzdLaniaam0ik4/XOfmqEhgbgDY20XtRAOAwZgrYBzp1xLg/sfCCo7BDeuAyazsGWNhCNREhn0ySWJoJ92tzIB+5tIJ0GKls7doiwhfnImR8h8XiCSChCa1sr2fZs0I8Er9/17ruonzuE1yd07FgkAuk0JBJQ37X9jvcg0t6174Z4MyIjxsw2uPuigq+VkAyeAm4ANgDZjnJ37/XyUjM7G/icu1+cW74pt86/5dW5DjjB3f+5qEAoPRmkWlLU3lpLa1trZ1k0A+3AK+GimylZNAMbrvotC39wIYezhwvXqYyy4W8e4Iy7z6W1lFgyVQSfrK19VuuI4YwfXtRl//Nf33XNk8RmzCGVgtpaaLUU3FDbb9tAkIjaqiB8ZP+ilVE2XLOBM1acUXCbxagKVbH7ht1Dc4TQuWN5sUSjsGtX57/uqd3bqF1xapf3IL9vhmgzIiOqr2RQyqWlB9z9l+7+grvv73j0s86JwJ685aZcWb6TgVeZ2SNmtsHMrirUkJldY2brzWx9KpUqIexgiCUSinQpq2gvcDZ8iIWzsHbLGkIVoV7rVFgFa7esIdJeYuPtIWjv/+0LtwcxdN///NeT29cCwdBGJALUJCFbuH5B3ToyHAqzdu9aKiihjW5CFSGSzckBr99F547lCYeD8o4q29f2eA/y+2aINiMyapWSDB42sy+Z2dlmtrDj0c86VqCs+2dwJXAG8FfAxcC/mNnJPVZyX+Hui9x9UazEf7PiNXHS2XSXsvaKwsENpUwI6uYuIdue7bVOu7dTN3cJ6VLvLFGRDTJafzFUBDF03//81+Oz64BgjDudBprjECpcv6BuHZnJZqg7sY52Smijm2x7tvNcwqB17lieTCYo76gyu67He5DfN0O0GZFRq5SPoLOARcD/Bv499+jvCqMmgsntOkwDni1Q51fu3uLu+4DfAKeXEFe/YhNjJJYmiFZGqT6mmqhXklgFd6yCUJYgPRV4VGQh0gZV6WA53O0zvbKikpDl/uv3oK1wG1QfDoYYEtOXMefkxax850rC1nMMKBKKkFiaYM7Ji0lMX0Y0E6yfny4NI2xhwlQF5ZkoZKIsaV1J+L5EsJyuAoLhmQiVQQyvdI2hY/+jFgGHqsyR1zuGQWKxYIw76jGq7g/aDnOk7WhllCWzlhwJzqHy8WWE71tJxHJ9WxkN9ik2h8TSBBEL4u3sV4JzAsvqlnW+H5FQ5Eg/5l5f+c6VQ3cSuXPHolBdHfxMJLqM3cRmzOl8D/L7rpSTyEVsRmTUKvqcwYAaN6skOIF8AbCX4ATyFe6+Na/OHGA5wVFBBFgLvNfdt/TW7kBOIIOuJtLVRLqaSI5uQ3UC+Rjgr4E4eZekunufdzszs8sILhsNASvd/WYzuza37m25OjcCHyQ4p3u7u9/aV5sDTQYiIkezvpJBKRPVrQIOEFxN9EqxK+VmOr2vW9lt3Za/BHyphFhERGQIlZIMprn7JWWLRERERkwpJ5B/Z2ZvKFskIiIyYoqZqG4zwXUglcAHzWwnwTBRxzeQ55U3RBERKbdihoneVvYoRERkRPU7TOTuu9x9F/Ba4MW85ReB15Q7QBERKb9Szhl8GziYt9ySKxMRkTGulGRgnvelBHdvp7SrkUREZJQqJRnsNLOPmlk49/gYsLNcgYmIyPApJRlcC5xDMK1EE8FcRdeUIygRERleRQ/z5G44894yxiIiIiOk6CMDMzvZzH5tZltyy/PMrOgb0oiIyOhVyjDRfwA3ARkAd38CHSmIiIwLpSSDCe7e/bZPbUMZjIiIjIxSksE+M3sduVuUmNnlwHNliWqEpXZvY90Dd5HavS2vMAXr1gU/i22nJcW6vetItZR2m86xYtvuFHc9sI5tu4d//1ItKdZsWcea36ZKeUsGvr3S336RMaWU7wn8A7ACOMXM9gLPAFeWJaoR1Pid62nYs5xIO6QfDe52VV99DjQ0BDe4TaeD21fV1/fdzuZGGlY3EAlFSGfTJJYmqJ/b9zpjyfXfaWT5ngZoj8CjaZZNT/CNjwzP/jVubuQD9zaQbo1AKE34ownuurG+v7dk4NtrLPntFxlzSrm5zUx3f8bMJgIV7v5yR1l5Q+ypXDe3Se3eRu2KU2nNu0NlNAO7vnUMsZfybuEQjcKuXb3fLaslRe2ttbS2tR5ZpTLKro/vKs8dvIbZtt0pTl1RC+Ej+0cmypPX7GLOjPLuX6G+JROl6tu72P1UbMjvLJZKQW0ttOZtrp+3X2TU6uvmNqUME/0YIHev4pdzZT8abHCjSXL7WiLd7jEfzkLyuG53fA+Hg/sa9tZOc5JIKNJ1lVCYZHPv64wla7cngyOCfO3hoLzMks1JKui27WyY0JRkX2/JwLeXDI4I8vXz9ouMScVMYX0KcBpwrJm9O++lasjdLX2ciM+uI/1o17JMCOIvdjt6ymSCG9z21k5NnHQ23XWVbKbzXr9jXd3sODzadf+oyATlZRavidNOt22HMmT3x/t6Swa+vXgwNJSvn7dfZEwq5shgNsE01jXA2/MeC4G/K1tkIyA2Yw6J6cuIZqD6lWCIKDF9GbFv3hGMDVRXBz8TiT7HCGITYySWJohWRqk+pppoZZTE0sS4GCICmDMjxrLpCchE4ZVqyERZNj1R9iEiONK3EYvC4WDb4fsSrFw+9ENEELzNiURJb7/ImFTKOYOz3f2/+nj9Jnf/tyGLrA/lOmfQIbV7G8nta4nPriM2Y06uMBWMDcTjRX8SpFpSJJuTxGvi4yYR5Nu2O8Xa7UnqZseHJRHkS7Wk2PhMEprjLJhdnkTQZXulv/0io05f5wyKTgZFbORxd184JI31o9zJQERkPBqqE8j9bmcI2xIRkWE0lMlgaA4xRERk2OnIQERESpq1dHE/ZT8ckohERGTYlXJk8I2+ytz9fw8+HBERGQnFfOnsbII7nMXM7BN5L1UDoXIFJiIiw6eYieoiwKRc3cl55X8BLi9HUCIiMrz6TQbu/ijwqJnd6e67zGxyUOwHyx+eiIgMh1KmsJ5sZhuB4wDMbB9wtbtvKUtkIiIybEo5gbwC+IS717p7LfA/cmUiIjLGlZIMJrr7wx0L7v4IMHHIIxIRkWFXyjDRTjP7F+Ce3PL7CO52JiIiY1wpRwYfAmLAT4B7c88/WI6gRERkeBV9ZODuLwEfLWMsIiIyQkqZjuJkM1thZmvM7KGORxHrXWJm281sh5l9qo96Z5pZ1sz03QURkWFWyjmDHwK3AbcD2WJWMLMQ8E3gIqAJWGdmq939yQL1bgHuLyEeEREZIqUkgzZ3/3aJ7dcBO9x9J4CZfQ9YCjzZrd71wI+BM0tsX0REhkC/w0RmdpyZHQf8zMyuM7PXdpTlyvtyIrAnb7kpV5bf/onAuwiOOvqK4xozW29m61OpVH9hi4hICYo5MthAcOOajvsV3EjXG9nM6mPdQvc46H4TnFuBT7p71qz3WyK4+wpyX3JbtGiRbqQjIjKEipmbaCaAmf0t8Ct3/0vu+wYLgS/0s3oTMD1veRrwbLc6i4Dv5RLBVOAyM2tz958WtQciIjJopXzP4J9zieBcghPCdwL9nUNYB5xkZjPNLAK8F1idX8HdZ7p73N3jwI+A65QIRESGVynJoOMKor8CbnP3VQTTW/fK3duAZQRXCW0DfuDuW83sWjO7diABi4jI0CvlaqK9ZvYd4ELgFjM7hiKSibvfB9zXrazgyWJ3/0AJ8YiIyBAp5cjgbwn+w7/E3ZsJprK+sRxBiYjI8CplOopDBPMSdSw/BzxXjqBERGR4lXJkICIi45SSgYiIKBmIiIiSgYiIoGQgIiIoGYiICEoGIiKCkoGIiKBkICIiKBmIiAhKBiIigpKBiIigZCAiIigZiIgISgYiIkJpdzoTERk2mUyGpqYmDh8+PNKhjDlVVVVMmzaNcDhc9DpKBiIyKjU1NTF58mTi8ThmNtLhjBnuzv79+2lqamLmzJlFr6dhIhEZlQ4fPsyUKVOUCEpkZkyZMqXkIyolAxEZtZQIBmYg/aZkICIiSgYiIqX43Oc+x5e//OWS12tubuZb3/rWoLf/zDPPcNZZZ3HSSSfxnve8h3Q6Peg2QclARMaTVArWrQt+jjIDSQbuTnt7e5eyT37yk9xwww08/fTTvOpVryKRSAxJfEoGIjI+NDZCbS1cdFHws7Fx0E3efffdzJs3j9NPP533v//9PV4/77zzWL9+PQD79u0jHo8DsHXrVurq6pg/fz7z5s3j6aef5lOf+hT//d//zfz587nxxhsB+NKXvsSZZ57JvHnz+OxnPwtAMplkzpw5XHfddSxcuJA9e/Z0bs/deeihh7j88ssBuPrqq/npT3866P0EXVoqIuNBKgUNDdDaGjwgWL7wQojFBtTk1q1bufnmm3nssceYOnUqL774YtHr3nbbbXzsYx/jyiuvJJ1Ok81m+eIXv8iWLVvYtGkTAGvWrOHpp59m7dq1uDvveMc7+M1vfsOMGTPYvn07d9xxR48jif3791NTU0NlZfDRPW3aNPbu3Tug/etOyUBExr5kEiKRI4kAIBwOygeYDDr+A586dSoAxx13XNHrnn322dx88800NTXx7ne/m5NOOqlHnTVr1rBmzRoWLFgAwMGDB3n66aeZMWMGtbW1vPGNb+yxjrv3KBuqK640TCQiY188Dt1PpGYyQfkAuXu/H7SVlZWdY/r51/VfccUVrF69mmg0ysUXX8xDDz1UsP2bbrqJTZs2sWnTJnbs2EFDQwMAEydOLLi9qVOn0tzcTFtbGxB8Me+EE04Y0P51p2QgImNfLAaJBESjUF0d/EwkBnxUAHDBBRfwgx/8gP379wMUHCaKx+Ns2LABgB/96Eed5Tt37mTWrFl89KMf5R3veAdPPPEEkydP5uWXX+6sc/HFF7Ny5UoOHjwIwN69e3nhhRf6jMnMOP/88zu3ddddd7F06dIB72M+JQMRGR/q62HXLnjwweBnff2gmjvttNP49Kc/zVve8hZOP/10PvGJT/So84//+I98+9vf5pxzzmHfvn2d5d///veZO3cu8+fP56mnnuKqq65iypQpLF68mLlz53LjjTeyZMkSrrjiCs4++2ze8IY3cPnll3dJFr255ZZb+MpXvsLrX/969u/f33k0MVhWaAxqtFu0aJF3nMEXkfFp27ZtzJkzZ6TDGLMK9Z+ZbXD3RYXq68hARESUDERERMlARERQMhAREYYhGZjZJWa23cx2mNmnCrx+pZk9kXv8zsxOL3dMUmajeH4YESmsrMnAzELAN4FLgVOBejM7tVu1Z4C3uPs84AvAinLGJGVWhvlhRKT8yn1kUAfscPed7p4Gvgd0+YaEu//O3V/KLf4emFbmmKRc8ueHOXAg+NnQoCMEGVdGegrr5cuX8/rXvx4z6/LdhsEqdzI4EdiTt9yUK+tNA/DLQi+Y2TVmtt7M1qf04TI6dcwPk69jfhiRYTCaRyiHagrrxYsX8+CDD1JbWzuU4ZU9GRSa2KPgt9zM7HyCZPDJQq+7+wp3X+Tui2KD+Iq5lFEZ5ocRKVY5RihH2xTWAAsWLOjczlAq96ylTcD0vOVpwLPdK5nZPOB24FJ331/mmKRcOuaHaWgIjggymUHPDyNSjDLMYD0qp7Aup3Ing3XASWY2E9gLvBe4Ir+Cmc0AfgK8393/VOZ4pNzq64O/wGQyOCJQIpBhUIYZrEflFNblVNZk4O5tZrYMuB8IASvdfauZXZt7/TbgM8AU4Fu56WLbeps7Q8aIWExJQIZVOUYoBzuF9VlnncUvfvELLr74Ym6//XZmzZrVo/2bbrqJj3zkI13Kk8lkr1NYl1PZv2fg7ve5+8nu/jp3vzlXdlsuEeDuH3b3V7n7/NxDiUBESlKGGaxH5RTW5aRvIIvIuDDEM1iP2imsv/71rzNt2jSampqYN28eH/7whwe3ozmawlpERiVNYT04msJaRERKpmQgIiJKBiIiomQgIiIoGYiICEoGIiKCkoGISElGegrrK6+8ktmzZzN37lw+9KEPkclkBt0mKBmIyDiSakmxbu86Ui2jbw7roZrC+sorr+Spp55i8+bNtLa2cvvttw9JfEoGIjIuNG5upPbWWi665yJqb62lccvg57AejVNYX3bZZZgZZkZdXR1NTU2D3k8o/6ylIiJll2pJ0bC6gda2VlrbgqlLG1Y1cOHMC4lNHNgERaN9CutMJsM999zD1772tQHtX3dKBiIy5iWbk0RCkc5EABAOhUk2JwecDEb7FNbXXXcdb37zm3nTm95Uwl71TsNEgzSQMcrhHNcczWOoIkMlXhMnne06h3UmmyFeEx9wm4Odwnr16tVEo1EuvvhiHnrooYLt33TTTWzatIlNmzaxY8cOGhoaAPqdwvpf//VfSaVSfOUrXyl1t3qlZDAIAxmjLMe45mjYlshIik2MkViaIFoZpfqYaqKVURJLEwM+KoDRO4X17bffzv33309jYyMVFUP3Ea5kMED5Y5QHXjlAa1srDasa+vwPfCDrDGd8ImNZ/dx6dn18Fw++/0F2fXwX9XMHN4f1aJ3C+tprr+X555/n7LPPZv78+Xz+858f1H520BTWA7Ru7zouuuciDrxyoLOs+phqHnz/g5x54plDts5wxicymmgK68HRFNbDZCBjlOUY1xwN2xKRsU/JYIAGMkZZjnHN0bAtERn7NEw0SKmWFMnmJPGaeNEftANZZzjjExkNtm3bximnnNLvFT3Sk7vz1FNPlTRMpO8ZDFJsYqzkD9mBrDNQw7ktkaFUVVXF/v37mTJlihJCCdyd/fv3U1VVVdJ6SgYiMip13PQ9ldIVcKWqqqpi2rRpJa2jZCAio1I4HGbmzJkjHcZRQyeQRUREyUBERJQMRESEMXppqZmlgF0lrDIV2NdvraOH+qMr9UdX6o+uxlN/1Lp7wcsLx2QyKJWZre/t2tqjkfqjK/VHV+qPro6W/tAwkYiIKBmIiMjRkwxWjHQAo4z6oyv1R1fqj66Oiv44Ks4ZiIhI346WIwMREemDkoGIiIyfZGBml5jZdjPbYWafKvC6mdnXc68/YWYLRyLO4VJEf1yZ64cnzOx3Znb6SMQ5XPrrj7x6Z5pZ1swuH874RkIxfWJm55nZJjPbamaPDneMw6mIv5ljzexnZvbHXH98cCTiLBt3H/MPIAT8NzALiAB/BE7tVucy4JeAAW8E/jDScY9wf5wDvCr3/NKjvT/y6j0E3AdcPtJxj3SfADXAk8CM3PKrRzruEe6P/wncknseA14EIiMd+1A9xsuRQR2ww913unsa+B6wtFudpcDdHvg9UGNmrx3uQIdJv/3h7r9z95dyi78HSpvvdmwp5vcD4Hrgx8ALwxncCCmmT64AfuLuuwHcfTz3SzH94cBkC26uMIkgGbQNb5jlM16SwYnAnrzlplxZqXXGi1L3tYHgqGm86rc/zOxE4F3AbcMY10gq5nfkZOBVZvaImW0ws6uGLbrhV0x/LAfmAM8Cm4GPuXv78IRXfuPlfgaFboPU/ZrZYuqMF0Xvq5mdT5AMzi1rRCOrmP64Ffiku2ePkrtqFdMnlcAZwAVAFPgvM/u9u/+p3MGNgGL642JgE/BW4HXAA2b2/9z9L2WObViMl2TQBEzPW55GkL1LrTNeFLWvZjYPuB241N33D1NsI6GY/lgEfC+XCKYCl5lZm7v/dFgiHH7F/s3sc/cWoMXMfgOcDozHZFBMf3wQ+KIHJw12mNkzwCnA2uEJsbzGyzDROuAkM5tpZhHgvcDqbnVWA1flrip6I3DA3Z8b7kCHSb/9YWYzgJ8A7x+n/+nl67c/3H2mu8fdPQ78CLhuHCcCKO5vZhXwJjOrNLMJwFnAtmGOc7gU0x+7CY6SMLPjgdnAzmGNsozGxZGBu7eZ2TLgfoKrAla6+1Yzuzb3+m0EV4hcBuwADhFk+XGpyP74DDAF+Fbuv+E2H6czMxbZH0eVYvrE3beZ2a+AJ4B24HZ33zJyUZdPkb8jXwDuNLPNBMNKn3T38TK1taajEBGR8TNMJCIig6BkICIiSgYiIqJkICIiKBmIiAhKBiIigpKBjBFmljSzqSXUP8/MzhnAduab2WVDUS8Xw89LjaGIbX/AzJYPdbtydFMykPHqPIJpuks1n+DLiUNVT2RMUDKQUcfMJprZL3I3EdliZu/JvXS9mT1uZpvN7JRc3ePM7Ke5m/T83szmmVkcuBa4IXdjljf1sp2/ybX/RzP7TW4ags8D78mt9x4zq8vd/Gdj7ufsXuq9Jfd8U67u5Nxmqs3sXjN70sxuM7OK3Lbrc/uxxcxuyYvpoJndkpsl9MHc9h8xs51m9o688Keb2a8suBnLZ/voyzNzfVOV69etZjbXzCrM7Fu55Z+b2X12FNzQR/ow0jdU0EOP7g/gr4H/yFs+FkgC1+eWryOYGgHgG8Bnc8/fCmzKPf8c8I/9bGczcGLueU3u5weA5Xl1qoHK3PMLgR/3Uu9nwOLc80kEU72cBxwmuGFKCHgAuBw4gWCem1iu3kPAO3PrOsHEgQD3AmuAMMEEcZvytv0cwXQiUWALsKiP/fxfwJeBbwI35couJ5iipQJ4DfAS4/yGPnr0/dCRgYxGm4ELc/8hv8ndD+TKf5L7uQGI556fC9wD4O4PAVPM7Ngit/MYwVwzf0fwYV3IscAPzWwL8FXgtD7a+oqZfZQgsXTc9GStBzdMyQKNuXjPBB5x91Su3v8F3pyrnwZ+lXu+GXjU3TO55x37DPCAu+9391aCfulrCvLPAxcRzMz6f3Jl5wI/dPd2d/8z8HAf68tRQMlARh0PZlE9g+AD8N/M7DO5l17J/cxyZJLFAd+nwt2vBf6ZYOriTWY2pUC1LwAPu/tc4O1AVS9tfRH4MMF/6r/vGMYqEIv3EnOHjLt3rNNObp89uIlK/sSShdrtzXEERyuT8+I/Km7aIMVTMpBRx8xOAA65+3cJhjcW9lH9N8CVufXOI5h//y/AywQffn1t53Xu/gd3/wywjyApdF/vWGBv7vkH8sq71Mu1tdndbwHWE8xzD1CXmxa5AngP8FvgD8BbzGyqmYWAeqDUm81flDtfEgXeSXBk0psVwL8QHIF0nJ/4LfDXuXMHxxMMaclRTMlARqM3AGvNbBPwaYIx7958DlhkZk8AXwSuzpX/DHhXXyeQgS91nMQlSCp/JBguObXjxDDBsMq/mdljdB1K6l7v4x0no4FWjtxG9L9ycW0BngHu9eA+Gjfl2vgj8Li7ryqqZ474LcHw2CaC8xjrC1Wy4FaVbe7+n7k4zjSztxLc67kpF9d3CBLUgUJtyNFBU1iLHKXMbJK7H8wNj60lOAH+55GOS0bGuLi5jYgMyM/NrAaIAF9QIji66chAxj0z+zTwN92Kf+juN49EPOWQ++/+1wVeusDH9/2tZYgoGYiIiE4gi4iIkoGIiKBkICIiKBmIiAjw/wE9857aBPjV0QAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "def kmeans_viz(X, Y):\n",
    "    plt.scatter(E_shot[E_shot['cluster']==0][X], E_shot[E_shot['cluster']==0][Y], s = 20, c='red', label ='cluster 0')\n",
    "    plt.scatter(E_shot[E_shot['cluster']==1][X], E_shot[E_shot['cluster']==1][Y], s = 20, c='blue', label ='cluster 1')\n",
    "    plt.scatter(E_shot[E_shot['cluster']==2][X], E_shot[E_shot['cluster']==2][Y], s = 20, c='green', label ='cluster 2')\n",
    "    plt.xlabel(X)\n",
    "    plt.ylabel(Y)    \n",
    "    plt.legend() \n",
    "\n",
    "kmeans_viz('shot_statsbomb_xg', 'shot_technique')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "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>shot_body_part</th>\n",
       "      <th>shot_first_time</th>\n",
       "      <th>shot_one_on_one</th>\n",
       "      <th>shot_open_goal</th>\n",
       "      <th>shot_statsbomb_xg</th>\n",
       "      <th>shot_technique</th>\n",
       "      <th>shot_type</th>\n",
       "      <th>shot_outcome</th>\n",
       "      <th>cluster</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.029270</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.026954</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.039079</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.096507</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.253166</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>417</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.262575</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>418</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.143009</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>423</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.238635</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>426</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.067505</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>427</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.835386</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>260 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     shot_body_part  shot_first_time  shot_one_on_one  shot_open_goal  \\\n",
       "0               1.0                0                0               0   \n",
       "1               1.0                0                0               0   \n",
       "3               1.0                0                0               0   \n",
       "5               1.0                0                0               0   \n",
       "12              1.0                0                0               0   \n",
       "..              ...              ...              ...             ...   \n",
       "417             1.0                0                0               0   \n",
       "418             1.0                0                0               0   \n",
       "423             1.0                0                0               0   \n",
       "426             1.0                0                0               0   \n",
       "427             1.0                0                0               1   \n",
       "\n",
       "     shot_statsbomb_xg  shot_technique  shot_type  shot_outcome  cluster  \n",
       "0             0.029270             1.0        0.8             1        0  \n",
       "1             0.026954             1.0        0.8             0        0  \n",
       "3             0.039079             1.0        0.8             1        0  \n",
       "5             0.096507             1.0        0.6             0        0  \n",
       "12            0.253166             1.0        0.8             2        0  \n",
       "..                 ...             ...        ...           ...      ...  \n",
       "417           0.262575             1.0        0.8             2        0  \n",
       "418           0.143009             1.0        0.8             1        0  \n",
       "423           0.238635             1.0        0.8             1        0  \n",
       "426           0.067505             1.0        0.6             0        0  \n",
       "427           0.835386             1.0        0.8             2        0  \n",
       "\n",
       "[260 rows x 9 columns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "E_shot[E_shot['cluster']==0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[[9.25000000e-01 1.66533454e-16 3.46944695e-16 7.69230769e-03\n",
      "  1.02610827e-01 9.63846154e-01]\n",
      " [1.00000000e+00 1.00000000e+00 0.00000000e+00 2.41935484e-02\n",
      "  1.75425332e-01 8.26612903e-01]\n",
      " [8.91304348e-01 1.66533454e-16 1.00000000e+00 2.17391304e-02\n",
      "  2.74341160e-01 9.06521739e-01]]\n"
     ]
    }
   ],
   "source": [
    "K = KMeans(n_clusters=3).fit(E_shot[['shot_body_part', 'shot_first_time', 'shot_one_on_one',\n",
    "            'shot_open_goal', 'shot_statsbomb_xg', 'shot_technique']])\n",
    "centroids = K.cluster_centers_\n",
    "print(centroids)"
   ]
  },
  {
   "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
}