match results data.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import pickle\n",
    "from selenium import webdriver\n",
    "import time\n",
    "import os\n",
    "from selenium.webdriver.common.by import By\n",
    "from utils import crawling_game_results, crawling_match_url, match_df, crawling_seasons, crawling_seasons_add, crawling_all_matches"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "# set repository path of webdriver\n",
    "path = './chromedriver'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "# test webdriver\n",
    "driver = webdriver.Chrome(path)\n",
    "driver.implicitly_wait(3)\n",
    "driver.get('https:/1xbet.whoscored.com/')\n",
    "driver.implicitly_wait(3)\n",
    "driver.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "# ex) Premier leauge 2021 season \n",
    "# URL : https://1xbet.whoscored.com/Regions/252/Tournaments/2/Seasons/8228\n",
    "# region number : 252\n",
    "# tournament number : 2\n",
    "# season number : 8228"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "page 33:  82%|████████▎ | 33/40 [04:01<00:51,  7.31s/it]\n"
     ]
    }
   ],
   "source": [
    "# crawling match URLs\n",
    "match_url = crawling_match_url(path, 252, 2, 8618)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['https://1xbet.whoscored.com/Matches/1485437/Live/England-Premier-League-2020-2021-Crystal-Palace-Wolverhampton',\n",
       " 'https://1xbet.whoscored.com/Matches/1485322/Live/England-Premier-League-2020-2021-Everton-Newcastle',\n",
       " 'https://1xbet.whoscored.com/Matches/1485482/Live/England-Premier-League-2020-2021-Chelsea-West-Bromwich',\n",
       " 'https://1xbet.whoscored.com/Matches/1485345/Live/England-Premier-League-2020-2021-Fulham-Leicester',\n",
       " 'https://1xbet.whoscored.com/Matches/1485499/Live/England-Premier-League-2020-2021-Leicester-Newcastle']"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "match_url[0:5]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "# crawling match results data\n",
    "# ex) Liverpool vs Leicester (2021)\n",
    "temp_match_url = match_url[0]\n",
    "match_result = crawling_game_results(path, temp_match_url)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'home_shot': '11',\n",
       " 'away_shot': '6',\n",
       " 'home_possession': '47.3',\n",
       " 'away_possession': '52.7',\n",
       " 'home_pass_success': '87',\n",
       " 'away_pass_success': '88',\n",
       " 'home_dribbles': '11',\n",
       " 'away_dribbles': '13',\n",
       " 'home_aerials_won': '9',\n",
       " 'away_aerials_won': '8',\n",
       " 'home_tackles': '14',\n",
       " 'away_tackles': '25',\n",
       " 'home_corners': '1',\n",
       " 'away_corners': '6',\n",
       " 'home_dispossessed': '18',\n",
       " 'away_dispossessed': '3',\n",
       " 'home_missing_player': 7,\n",
       " 'away_missing_player': 4,\n",
       " 'home_missing_player_rating': 6.3,\n",
       " 'away_missing_player_rating': 6.59,\n",
       " 'home': 'Crystal Palace',\n",
       " 'away': 'Wolverhampton',\n",
       " 'half_home_score': '0 ',\n",
       " 'half_away_score': ' 0',\n",
       " 'full_home_score': '1 ',\n",
       " 'full_away_score': ' 0',\n",
       " 'kick_off': '15:00',\n",
       " 'date': 'Jmos, 30-Jan-21',\n",
       " 'matchup_home_goals': '3',\n",
       " 'matchup_away_goals': '7',\n",
       " 'matchup_home_wins': 'Won (17%)',\n",
       " 'matchup_draw': 'Drew (17%)',\n",
       " 'matchup_away_wins': 'Won (67%)',\n",
       " 'home_total_att': '11',\n",
       " 'away_total_att': '6',\n",
       " 'home_open_att': '8',\n",
       " 'away_open_att': '3',\n",
       " 'home_set_att': '2',\n",
       " 'away_set_att': '3',\n",
       " 'home_counter_att': '1',\n",
       " 'away_counter_att': '0',\n",
       " 'home_pk_att': '0',\n",
       " 'away_pk_att': '0',\n",
       " 'home_own_att': '0',\n",
       " 'away_own_att': '0',\n",
       " 'home_total_passes': '529',\n",
       " 'away_total_passes': '589',\n",
       " 'home_crosses_passes': '5',\n",
       " 'away_crosses_passes': '25',\n",
       " 'home_long_balls': '58',\n",
       " 'away_long_balls': '31',\n",
       " 'home_short_passes': '466',\n",
       " 'away_short_passes': '533'}"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "match_result"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "page 35:  88%|████████▊ | 35/40 [04:15<00:36,  7.29s/it]\n",
      "PL2122_match_url.csv: done, 380 matches\n",
      "match_url 1 : cawling done\n",
      "match_url 2 : cawling done\n",
      "match_url 3 : cawling done\n",
      "match_url 4 : cawling done\n",
      "match_url 5 : cawling done\n",
      "match_url 6 : cawling done\n",
      "match_url 7 : cawling done\n",
      "match_url 8 : cawling done\n",
      "match_url 9 : cawling done\n",
      "match_url 10 : cawling done\n",
      "match_url 11 : cawling done\n",
      "match_url 11 : error\n",
      "match_url 13 : cawling done\n",
      "match_url 14 : cawling done\n",
      "match_url 15 : cawling done\n",
      "match_url 16 : cawling done\n",
      "match_url 17 : cawling done\n",
      "match_url 18 : cawling done\n",
      "match_url 19 : cawling done\n",
      "match_url 20 : cawling done\n",
      "match_url 21 : cawling done\n",
      "match_url 22 : cawling done\n",
      "match_url 23 : cawling done\n",
      "match_url 24 : cawling done\n",
      "match_url 25 : cawling done\n",
      "match_url 26 : cawling done\n",
      "match_url 26 : error\n",
      "match_url 28 : cawling done\n",
      "match_url 29 : cawling done\n",
      "match_url 30 : cawling done\n",
      "match_url 31 : cawling done\n",
      "match_url 32 : cawling done\n",
      "match_url 33 : cawling done\n",
      "match_url 34 : cawling done\n",
      "match_url 35 : cawling done\n",
      "match_url 36 : cawling done\n",
      "match_url 37 : cawling done\n",
      "match_url 38 : cawling done\n",
      "match_url 39 : cawling done\n",
      "match_url 40 : cawling done\n",
      "match_url 41 : cawling done\n",
      "match_url 42 : cawling done\n",
      "match_url 43 : cawling done\n",
      "match_url 44 : cawling done\n",
      "match_url 45 : cawling done\n",
      "match_url 46 : cawling done\n",
      "match_url 46 : error\n",
      "match_url 48 : cawling done\n",
      "match_url 49 : cawling done\n",
      "match_url 50 : cawling done\n",
      "match_url 51 : cawling done\n",
      "match_url 52 : cawling done\n",
      "match_url 53 : cawling done\n",
      "match_url 54 : cawling done\n",
      "match_url 55 : cawling done\n",
      "match_url 56 : cawling done\n",
      "match_url 56 : error\n",
      "match_url 58 : cawling done\n",
      "match_url 59 : cawling done\n",
      "match_url 60 : cawling done\n",
      "match_url 61 : cawling done\n",
      "match_url 61 : error\n",
      "match_url 62 : error\n",
      "match_url 64 : cawling done\n",
      "match_url 65 : cawling done\n",
      "match_url 66 : cawling done\n",
      "match_url 67 : cawling done\n",
      "match_url 68 : cawling done\n",
      "match_url 69 : cawling done\n",
      "match_url 70 : cawling done\n",
      "match_url 71 : cawling done\n",
      "match_url 72 : cawling done\n",
      "match_url 73 : cawling done\n",
      "match_url 74 : cawling done\n",
      "match_url 74 : error\n",
      "match_url 76 : cawling done\n",
      "match_url 77 : cawling done\n",
      "match_url 77 : error\n",
      "match_url 78 : error\n",
      "match_url 79 : error\n",
      "match_url 81 : cawling done\n",
      "match_url 82 : cawling done\n",
      "match_url 83 : cawling done\n",
      "match_url 84 : cawling done\n",
      "match_url 85 : cawling done\n",
      "match_url 86 : cawling done\n",
      "match_url 87 : cawling done\n",
      "match_url 88 : cawling done\n",
      "match_url 89 : cawling done\n",
      "match_url 90 : cawling done\n",
      "match_url 91 : cawling done\n",
      "match_url 92 : cawling done\n",
      "match_url 93 : cawling done\n",
      "match_url 94 : cawling done\n",
      "match_url 95 : cawling done\n",
      "match_url 96 : cawling done\n",
      "match_url 97 : cawling done\n",
      "match_url 98 : cawling done\n",
      "match_url 99 : cawling done\n",
      "match_url 100 : cawling done\n",
      "match_url 101 : cawling done\n",
      "match_url 102 : cawling done\n",
      "match_url 103 : cawling done\n",
      "match_url 104 : cawling done\n",
      "match_url 105 : cawling done\n",
      "match_url 106 : cawling done\n",
      "match_url 107 : cawling done\n",
      "match_url 108 : cawling done\n",
      "match_url 109 : cawling done\n",
      "match_url 110 : cawling done\n",
      "match_url 111 : cawling done\n",
      "match_url 112 : cawling done\n",
      "match_url 113 : cawling done\n",
      "match_url 114 : cawling done\n",
      "match_url 115 : cawling done\n",
      "match_url 116 : cawling done\n",
      "match_url 117 : cawling done\n",
      "match_url 118 : cawling done\n",
      "match_url 119 : cawling done\n",
      "match_url 120 : cawling done\n",
      "match_url 121 : cawling done\n",
      "match_url 122 : cawling done\n",
      "match_url 123 : cawling done\n",
      "match_url 124 : cawling done\n",
      "match_url 125 : cawling done\n",
      "match_url 126 : cawling done\n",
      "match_url 127 : cawling done\n",
      "match_url 128 : cawling done\n",
      "match_url 129 : cawling done\n",
      "match_url 130 : cawling done\n",
      "match_url 131 : cawling done\n",
      "match_url 132 : cawling done\n",
      "match_url 133 : cawling done\n",
      "match_url 134 : cawling done\n",
      "match_url 135 : cawling done\n",
      "match_url 136 : cawling done\n",
      "match_url 137 : cawling done\n",
      "match_url 138 : cawling done\n",
      "match_url 139 : cawling done\n",
      "match_url 140 : cawling done\n",
      "match_url 141 : cawling done\n",
      "match_url 142 : cawling done\n",
      "match_url 143 : cawling done\n",
      "match_url 144 : cawling done\n",
      "match_url 145 : cawling done\n",
      "match_url 146 : cawling done\n",
      "match_url 147 : cawling done\n",
      "match_url 148 : cawling done\n",
      "match_url 149 : cawling done\n",
      "match_url 150 : cawling done\n",
      "match_url 151 : cawling done\n",
      "match_url 152 : cawling done\n",
      "match_url 153 : cawling done\n",
      "match_url 154 : cawling done\n",
      "match_url 155 : cawling done\n",
      "match_url 156 : cawling done\n",
      "match_url 156 : error\n",
      "match_url 157 : error\n",
      "match_url 158 : error\n",
      "match_url 159 : error\n",
      "match_url 160 : error\n",
      "match_url 161 : error\n",
      "match_url 162 : error\n",
      "match_url 163 : error\n",
      "match_url 164 : error\n",
      "match_url 165 : error\n",
      "match_url 167 : cawling done\n",
      "match_url 168 : cawling done\n",
      "match_url 169 : cawling done\n",
      "match_url 169 : error\n",
      "match_url 171 : cawling done\n",
      "match_url 172 : cawling done\n",
      "match_url 173 : cawling done\n",
      "match_url 174 : cawling done\n",
      "match_url 175 : cawling done\n",
      "match_url 176 : cawling done\n",
      "match_url 177 : cawling done\n",
      "match_url 178 : cawling done\n",
      "match_url 179 : cawling done\n",
      "match_url 180 : cawling done\n",
      "match_url 181 : cawling done\n",
      "match_url 182 : cawling done\n",
      "match_url 183 : cawling done\n",
      "match_url 184 : cawling done\n",
      "match_url 185 : cawling done\n",
      "match_url 186 : cawling done\n",
      "match_url 187 : cawling done\n",
      "match_url 188 : cawling done\n",
      "match_url 189 : cawling done\n",
      "match_url 190 : cawling done\n",
      "match_url 191 : cawling done\n",
      "match_url 192 : cawling done\n",
      "match_url 193 : cawling done\n",
      "match_url 194 : cawling done\n",
      "match_url 195 : cawling done\n",
      "match_url 195 : error\n",
      "match_url 197 : cawling done\n",
      "match_url 198 : cawling done\n",
      "match_url 199 : cawling done\n",
      "match_url 200 : cawling done\n",
      "match_url 201 : cawling done\n",
      "match_url 202 : cawling done\n",
      "match_url 203 : cawling done\n",
      "match_url 204 : cawling done\n",
      "match_url 205 : cawling done\n",
      "match_url 206 : cawling done\n",
      "match_url 207 : cawling done\n",
      "match_url 208 : cawling done\n",
      "match_url 209 : cawling done\n",
      "match_url 210 : cawling done\n",
      "match_url 211 : cawling done\n",
      "match_url 212 : cawling done\n",
      "match_url 213 : cawling done\n",
      "match_url 214 : cawling done\n",
      "match_url 215 : cawling done\n",
      "match_url 216 : cawling done\n",
      "match_url 217 : cawling done\n",
      "match_url 218 : cawling done\n",
      "match_url 219 : cawling done\n",
      "match_url 220 : cawling done\n",
      "match_url 221 : cawling done\n",
      "match_url 222 : cawling done\n",
      "match_url 223 : cawling done\n",
      "match_url 224 : cawling done\n",
      "match_url 225 : cawling done\n",
      "match_url 226 : cawling done\n",
      "match_url 227 : cawling done\n",
      "match_url 228 : cawling done\n",
      "match_url 229 : cawling done\n",
      "match_url 230 : cawling done\n",
      "match_url 231 : cawling done\n",
      "match_url 232 : cawling done\n",
      "match_url 233 : cawling done\n",
      "match_url 234 : cawling done\n",
      "match_url 235 : cawling done\n",
      "match_url 236 : cawling done\n",
      "match_url 237 : cawling done\n",
      "match_url 238 : cawling done\n",
      "match_url 239 : cawling done\n",
      "match_url 240 : cawling done\n",
      "match_url 241 : cawling done\n",
      "match_url 242 : cawling done\n",
      "match_url 243 : cawling done\n",
      "match_url 244 : cawling done\n",
      "match_url 245 : cawling done\n",
      "match_url 246 : cawling done\n",
      "match_url 247 : cawling done\n",
      "match_url 248 : cawling done\n",
      "match_url 249 : cawling done\n",
      "match_url 250 : cawling done\n",
      "match_url 251 : cawling done\n",
      "match_url 252 : cawling done\n",
      "match_url 253 : cawling done\n",
      "match_url 254 : cawling done\n",
      "match_url 255 : cawling done\n",
      "match_url 256 : cawling done\n",
      "match_url 257 : cawling done\n",
      "match_url 258 : cawling done\n",
      "match_url 259 : cawling done\n",
      "match_url 260 : cawling done\n",
      "match_url 261 : cawling done\n",
      "match_url 262 : cawling done\n",
      "match_url 263 : cawling done\n",
      "match_url 264 : cawling done\n",
      "match_url 265 : cawling done\n",
      "match_url 266 : cawling done\n",
      "match_url 267 : cawling done\n",
      "match_url 268 : cawling done\n",
      "match_url 269 : cawling done\n",
      "match_url 270 : cawling done\n",
      "match_url 271 : cawling done\n",
      "match_url 272 : cawling done\n",
      "match_url 273 : cawling done\n",
      "match_url 274 : cawling done\n",
      "match_url 275 : cawling done\n",
      "match_url 276 : cawling done\n",
      "match_url 277 : cawling done\n",
      "match_url 278 : cawling done\n",
      "match_url 279 : cawling done\n",
      "match_url 280 : cawling done\n",
      "match_url 281 : cawling done\n",
      "match_url 282 : cawling done\n",
      "match_url 283 : cawling done\n",
      "match_url 284 : cawling done\n",
      "match_url 285 : cawling done\n",
      "match_url 286 : cawling done\n",
      "match_url 287 : cawling done\n",
      "match_url 288 : cawling done\n",
      "match_url 289 : cawling done\n",
      "match_url 290 : cawling done\n",
      "match_url 291 : cawling done\n",
      "match_url 292 : cawling done\n",
      "match_url 293 : cawling done\n",
      "match_url 294 : cawling done\n",
      "match_url 295 : cawling done\n",
      "match_url 296 : cawling done\n",
      "match_url 297 : cawling done\n",
      "match_url 298 : cawling done\n",
      "match_url 299 : cawling done\n",
      "match_url 300 : cawling done\n",
      "match_url 301 : cawling done\n",
      "match_url 302 : cawling done\n",
      "match_url 303 : cawling done\n",
      "match_url 304 : cawling done\n",
      "match_url 305 : cawling done\n",
      "match_url 306 : cawling done\n",
      "match_url 307 : cawling done\n",
      "match_url 308 : cawling done\n",
      "match_url 309 : cawling done\n",
      "match_url 310 : cawling done\n",
      "match_url 311 : cawling done\n",
      "match_url 312 : cawling done\n",
      "match_url 313 : cawling done\n",
      "match_url 314 : cawling done\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "c:\\Users\\jaeminiman\\AppData\\Local\\Programs\\Python\\Python310\\lib\\site-packages\\numpy\\core\\fromnumeric.py:3432: RuntimeWarning: Mean of empty slice.\n",
      "  return _methods._mean(a, axis=axis, dtype=dtype,\n",
      "c:\\Users\\jaeminiman\\AppData\\Local\\Programs\\Python\\Python310\\lib\\site-packages\\numpy\\core\\_methods.py:190: RuntimeWarning: invalid value encountered in double_scalars\n",
      "  ret = ret.dtype.type(ret / rcount)\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "match_url 315 : cawling done\n",
      "match_url 316 : cawling done\n",
      "match_url 317 : cawling done\n",
      "match_url 318 : cawling done\n",
      "match_url 319 : cawling done\n",
      "match_url 320 : cawling done\n",
      "match_url 321 : cawling done\n",
      "match_url 322 : cawling done\n",
      "match_url 323 : cawling done\n",
      "match_url 324 : cawling done\n",
      "match_url 325 : cawling done\n",
      "match_url 326 : cawling done\n",
      "match_url 327 : cawling done\n",
      "match_url 328 : cawling done\n",
      "match_url 329 : cawling done\n",
      "match_url 330 : cawling done\n",
      "match_url 331 : cawling done\n",
      "match_url 332 : cawling done\n",
      "match_url 333 : cawling done\n",
      "match_url 334 : cawling done\n",
      "match_url 335 : cawling done\n",
      "match_url 336 : cawling done\n",
      "match_url 337 : cawling done\n",
      "match_url 338 : cawling done\n",
      "match_url 339 : cawling done\n",
      "match_url 340 : cawling done\n",
      "match_url 341 : cawling done\n",
      "match_url 342 : cawling done\n",
      "match_url 343 : cawling done\n",
      "match_url 344 : cawling done\n",
      "match_url 345 : cawling done\n",
      "match_url 346 : cawling done\n",
      "match_url 347 : cawling done\n",
      "match_url 348 : cawling done\n",
      "match_url 349 : cawling done\n",
      "match_url 350 : cawling done\n",
      "match_url 351 : cawling done\n",
      "match_url 352 : cawling done\n",
      "match_url 353 : cawling done\n",
      "match_url 354 : cawling done\n",
      "match_url 355 : cawling done\n",
      "match_url 356 : cawling done\n",
      "match_url 357 : cawling done\n",
      "match_url 358 : cawling done\n",
      "match_url 359 : cawling done\n",
      "match_url 360 : cawling done\n",
      "match_url 361 : cawling done\n",
      "match_url 362 : cawling done\n",
      "match_url 363 : cawling done\n",
      "match_url 364 : cawling done\n",
      "match_url 365 : cawling done\n",
      "match_url 366 : cawling done\n",
      "match_url 367 : cawling done\n",
      "match_url 368 : cawling done\n",
      "match_url 369 : cawling done\n",
      "match_url 370 : cawling done\n",
      "match_url 371 : cawling done\n",
      "match_url 372 : cawling done\n",
      "match_url 373 : cawling done\n",
      "match_url 374 : cawling done\n",
      "match_url 375 : cawling done\n",
      "match_url 376 : cawling done\n",
      "match_url 377 : cawling done\n",
      "match_url 378 : cawling done\n",
      "match_url 379 : cawling done\n",
      "match_url 380 : cawling done\n",
      "[11, 26, 46, 56, 61, 62, 74, 77, 78, 79, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 169, 195]\n",
      "there are no match_number.csv file\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "()"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# crawling all mathces data in the league.\n",
    "crawling_all_matches(path,252,2,8618,'PL2122')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "there are no match_number.csv file\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "()"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "crawling_seasons_add(path, \"PL2122\", [11, 26, 46, 56, 61, 62, 74, 77, 78, 79, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 169, 195])"
   ]
  },
  {
   "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>Unnamed: 0</th>\n",
       "      <th>home_shot</th>\n",
       "      <th>away_shot</th>\n",
       "      <th>home_possession</th>\n",
       "      <th>away_possession</th>\n",
       "      <th>home_pass_success</th>\n",
       "      <th>away_pass_success</th>\n",
       "      <th>home_dribbles</th>\n",
       "      <th>away_dribbles</th>\n",
       "      <th>home_aerials_won</th>\n",
       "      <th>...</th>\n",
       "      <th>home_own_att</th>\n",
       "      <th>away_own_att</th>\n",
       "      <th>home_total_passes</th>\n",
       "      <th>away_total_passes</th>\n",
       "      <th>home_crosses_passes</th>\n",
       "      <th>away_crosses_passes</th>\n",
       "      <th>home_long_balls</th>\n",
       "      <th>away_long_balls</th>\n",
       "      <th>home_short_passes</th>\n",
       "      <th>away_short_passes</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>14</td>\n",
       "      <td>5</td>\n",
       "      <td>43.1</td>\n",
       "      <td>56.9</td>\n",
       "      <td>84</td>\n",
       "      <td>86</td>\n",
       "      <td>11</td>\n",
       "      <td>9</td>\n",
       "      <td>8</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>470</td>\n",
       "      <td>618</td>\n",
       "      <td>22</td>\n",
       "      <td>9</td>\n",
       "      <td>52</td>\n",
       "      <td>69</td>\n",
       "      <td>393</td>\n",
       "      <td>539</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>15</td>\n",
       "      <td>12</td>\n",
       "      <td>34.1</td>\n",
       "      <td>65.9</td>\n",
       "      <td>79</td>\n",
       "      <td>85</td>\n",
       "      <td>15</td>\n",
       "      <td>13</td>\n",
       "      <td>17</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>351</td>\n",
       "      <td>675</td>\n",
       "      <td>23</td>\n",
       "      <td>25</td>\n",
       "      <td>54</td>\n",
       "      <td>44</td>\n",
       "      <td>274</td>\n",
       "      <td>606</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>9</td>\n",
       "      <td>21</td>\n",
       "      <td>42.4</td>\n",
       "      <td>57.6</td>\n",
       "      <td>73</td>\n",
       "      <td>83</td>\n",
       "      <td>8</td>\n",
       "      <td>7</td>\n",
       "      <td>25</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>354</td>\n",
       "      <td>479</td>\n",
       "      <td>15</td>\n",
       "      <td>16</td>\n",
       "      <td>63</td>\n",
       "      <td>55</td>\n",
       "      <td>276</td>\n",
       "      <td>407</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>22</td>\n",
       "      <td>10</td>\n",
       "      <td>62.7</td>\n",
       "      <td>37.3</td>\n",
       "      <td>87</td>\n",
       "      <td>73</td>\n",
       "      <td>5</td>\n",
       "      <td>7</td>\n",
       "      <td>19</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>603</td>\n",
       "      <td>361</td>\n",
       "      <td>38</td>\n",
       "      <td>15</td>\n",
       "      <td>57</td>\n",
       "      <td>65</td>\n",
       "      <td>508</td>\n",
       "      <td>281</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>16</td>\n",
       "      <td>8</td>\n",
       "      <td>61.3</td>\n",
       "      <td>38.7</td>\n",
       "      <td>82</td>\n",
       "      <td>71</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>17</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>557</td>\n",
       "      <td>350</td>\n",
       "      <td>20</td>\n",
       "      <td>13</td>\n",
       "      <td>62</td>\n",
       "      <td>54</td>\n",
       "      <td>474</td>\n",
       "      <td>282</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 54 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0  home_shot  away_shot  home_possession  away_possession  \\\n",
       "0           0         14          5             43.1             56.9   \n",
       "1           1         15         12             34.1             65.9   \n",
       "2           2          9         21             42.4             57.6   \n",
       "3           3         22         10             62.7             37.3   \n",
       "4           4         16          8             61.3             38.7   \n",
       "\n",
       "   home_pass_success  away_pass_success  home_dribbles  away_dribbles  \\\n",
       "0                 84                 86             11              9   \n",
       "1                 79                 85             15             13   \n",
       "2                 73                 83              8              7   \n",
       "3                 87                 73              5              7   \n",
       "4                 82                 71              5              6   \n",
       "\n",
       "   home_aerials_won  ...  home_own_att  away_own_att  home_total_passes  \\\n",
       "0                 8  ...             0             0                470   \n",
       "1                17  ...             0             0                351   \n",
       "2                25  ...             0             0                354   \n",
       "3                19  ...             0             0                603   \n",
       "4                17  ...             0             0                557   \n",
       "\n",
       "   away_total_passes  home_crosses_passes  away_crosses_passes  \\\n",
       "0                618                   22                    9   \n",
       "1                675                   23                   25   \n",
       "2                479                   15                   16   \n",
       "3                361                   38                   15   \n",
       "4                350                   20                   13   \n",
       "\n",
       "   home_long_balls  away_long_balls  home_short_passes  away_short_passes  \n",
       "0               52               69                393                539  \n",
       "1               54               44                274                606  \n",
       "2               63               55                276                407  \n",
       "3               57               65                508                281  \n",
       "4               62               54                474                282  \n",
       "\n",
       "[5 rows x 54 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.read_csv('PL2122_match.csv').head()"
   ]
  },
  {
   "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.10.6"
  },
  "vscode": {
   "interpreter": {
    "hash": "e31df9372a7639b42ae8f2863a2f7033717a11a9b12168b46ffbb844a76a9c7c"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}