Scraping La-Liga 2018-2019.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import urllib\n",
    "import bs4\n",
    "import selenium\n",
    "import re\n",
    "import time\n",
    "import csv\n",
    "# selenium\n",
    "#from selenium.webdriver.support.ui import WebDriverWait\n",
    "#from selenium.webdriver.support import expected_conditions as EC\n",
    "#from selenium.webdriver.common.by import By\n",
    "#from selenium import webdriver"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "links = ['20190428', '20190331', '20190303', '20190203', '20190106', '20181209', '20181111', '20181014', '20180916', '20180819']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['20190428',\n",
       " '20190331',\n",
       " '20190303',\n",
       " '20190203',\n",
       " '20190106',\n",
       " '20181209',\n",
       " '20181111',\n",
       " '20181014',\n",
       " '20180916',\n",
       " '20180819']"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "links"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def fetch_website(links):\n",
    "    urls = []\n",
    "    url = 'https://www.msn.com/en-us/sports/soccer/la-liga/scores/'\n",
    "    urls.append(url)\n",
    "    url += 'sp'\n",
    "    for i, l in  enumerate(links):\n",
    "        url += '-d-' + links[i]\n",
    "        urls.append(url)\n",
    "    return urls"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "urls = fetch_website(links)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['https://www.msn.com/en-us/sports/soccer/la-liga/scores/',\n",
       " 'https://www.msn.com/en-us/sports/soccer/la-liga/scores/sp-d-20190428',\n",
       " 'https://www.msn.com/en-us/sports/soccer/la-liga/scores/sp-d-20190428-d-20190331',\n",
       " 'https://www.msn.com/en-us/sports/soccer/la-liga/scores/sp-d-20190428-d-20190331-d-20190303',\n",
       " 'https://www.msn.com/en-us/sports/soccer/la-liga/scores/sp-d-20190428-d-20190331-d-20190303-d-20190203',\n",
       " 'https://www.msn.com/en-us/sports/soccer/la-liga/scores/sp-d-20190428-d-20190331-d-20190303-d-20190203-d-20190106',\n",
       " 'https://www.msn.com/en-us/sports/soccer/la-liga/scores/sp-d-20190428-d-20190331-d-20190303-d-20190203-d-20190106-d-20181209',\n",
       " 'https://www.msn.com/en-us/sports/soccer/la-liga/scores/sp-d-20190428-d-20190331-d-20190303-d-20190203-d-20190106-d-20181209-d-20181111',\n",
       " 'https://www.msn.com/en-us/sports/soccer/la-liga/scores/sp-d-20190428-d-20190331-d-20190303-d-20190203-d-20190106-d-20181209-d-20181111-d-20181014',\n",
       " 'https://www.msn.com/en-us/sports/soccer/la-liga/scores/sp-d-20190428-d-20190331-d-20190303-d-20190203-d-20190106-d-20181209-d-20181111-d-20181014-d-20180916',\n",
       " 'https://www.msn.com/en-us/sports/soccer/la-liga/scores/sp-d-20190428-d-20190331-d-20190303-d-20190203-d-20190106-d-20181209-d-20181111-d-20181014-d-20180916-d-20180819']"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "urls"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def get_stats(stats):\n",
    "    stat_list = ['BALL', 'SHOTS', 'FOULS', 'CORNERS', 'SAVES', 'OFFSIDES', 'YELLOW', 'RED']\n",
    "    len_stats = len(stats)\n",
    "    home_shots_og = None\n",
    "    away_shots_og = None\n",
    "    home_saves = None\n",
    "    away_saves = None\n",
    "    home_offsides = None\n",
    "    away_offsides = None\n",
    "    home_poss = None\n",
    "    away_poss = None\n",
    "    home_fouls = None\n",
    "    away_fouls = None\n",
    "    home_shots = None\n",
    "    away_shots = None\n",
    "    home_corners = None\n",
    "    away_corners = None\n",
    "    home_yellow = None\n",
    "    away_yellow = None\n",
    "    home_red = None\n",
    "    away_red = None\n",
    "    for i in range(len_stats):\n",
    "        if stats[i][1] in stat_list:\n",
    "            if stats[i][1] == 'BALL':\n",
    "                home_poss = stats[i][0]\n",
    "                away_poss = stats[i][-1]\n",
    "            if stats[i][1] == 'FOULS':\n",
    "                home_fouls = stats[i][0]\n",
    "                away_fouls = stats[i][-1]\n",
    "            if stats[i][1] == 'CORNERS':\n",
    "                home_corners = stats[i][0]\n",
    "                away_corners = stats[i][-1]\n",
    "            if stats[i][1] == 'SAVES':\n",
    "                home_saves = stats[i][0]\n",
    "                away_saves = stats[i][-1]\n",
    "            if stats[i][1] == 'OFFSIDES':\n",
    "                home_offsides = stats[i][0]\n",
    "                away_offsides = stats[i][-1]\n",
    "            if stats[i][1] == 'YELLOW':\n",
    "                home_yellow = stats[i][0]\n",
    "                away_yellow = stats[i][-1]\n",
    "            if stats[i][1] == 'RED':\n",
    "                home_red = stats[i][0]\n",
    "                away_red = stats[i][-1]\n",
    "            if stats[i][1] == 'SHOTS':\n",
    "                if len(stats[i]) == 3:\n",
    "                    home_shots = stats[i][0]\n",
    "                    away_shots = stats[i][-1]\n",
    "                else:\n",
    "                    home_shots_og = stats[i][0]\n",
    "                    away_shots_og = stats[i][-1]\n",
    "    return(home_poss, away_poss, home_shots, away_shots, home_shots_og, away_shots_og, home_fouls, away_fouls, home_corners, \n",
    "           away_corners, home_saves, away_saves, home_offsides, away_offsides, home_yellow, away_yellow, home_red, away_red)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def get_score_count_perhalf(score_link):\n",
    "    result_link = score_link.find('div', {'id': 'main'}).find('div', {'class': 'teamevent'})\n",
    "    home_team_scores = []\n",
    "    home_team_scores_firsthalf = 0\n",
    "    home_team_scores_secondhalf = 0\n",
    "    try:\n",
    "        home_team_link = result_link.find('div', {'class': 'hometeamevent'}).findAll('span', {'class': 'scoremins'})\n",
    "        for h in home_team_link:\n",
    "            score = h.text.strip().split(\"'\")[0]\n",
    "            if int(score) <= 45:\n",
    "                home_team_scores_firsthalf += 1\n",
    "            if int(score) > 45:\n",
    "                home_team_scores_secondhalf += 1\n",
    "            home_team_scores.append(score)\n",
    "    except AttributeError:\n",
    "        # check this later.(Leganes vs Celta: Apr 27)\n",
    "        home_team_scores.append(99)\n",
    "        home_team_scores_firsthalf = 99\n",
    "        home_team_scores_secondhalf = 99\n",
    "\n",
    "    away_team_scores = []\n",
    "    away_team_scores_firsthalf = 0\n",
    "    away_team_scores_secondhalf = 0\n",
    "        \n",
    "    try:\n",
    "        away_team_link = result_link.find('div', {'class': 'visitingteamevent'}).findAll('span', {'class': 'scoremins'})\n",
    "        for a in away_team_link:\n",
    "            score = a.text.strip().split(\"'\")[0]\n",
    "            if int(score) <= 45:\n",
    "                away_team_scores_firsthalf += 1\n",
    "            if int(score) > 45:\n",
    "                away_team_scores_secondhalf += 1\n",
    "            away_team_scores.append(score)\n",
    "    except AttributeError:\n",
    "        away_team_scores.append(99)\n",
    "        away_team_scores_firsthalf = 99\n",
    "        away_team_scores_secondhalf = 99\n",
    "        \n",
    "    return(home_team_scores_firsthalf, home_team_scores_secondhalf, away_team_scores_firsthalf, away_team_scores_secondhalf)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def get_html(urls):\n",
    "    teams = []\n",
    "    for url in urls:\n",
    "        html = urllib.request.urlopen(url).read()\n",
    "        raw = bs4.BeautifulSoup(html, 'lxml')\n",
    "        results = raw.find('div', {'class': 'sectionsgroup'}).findAll('tbody', {'class': ['even rowlink', 'odd rowlink']})\n",
    "        for r in results:\n",
    "            home_team = r.find('td', {'class': 'teamname teaminline alignright size23'}).text.strip()\n",
    "            away_team = r.find('td', {'class': 'teamname size23'}).text.strip()\n",
    "            match_date = r.find('td', {'class': 'groupingcolumn paddingleft'}).find('div', {'class': 'matchdate'}).text.strip()\n",
    "            scores = r.findAll('td', {'class': 'teamscore'})\n",
    "            \n",
    "            #for s in scores:\n",
    "                #home_team_score = s.text.strip()\n",
    "            \n",
    "            home_team_score = scores[0].text.strip()\n",
    "            away_team_score = scores[1].text.strip()\n",
    "\n",
    "            data_link = 'https://www.msn.com' + r.find('a').get('href')\n",
    "            \n",
    "            try:\n",
    "                html_link = urllib.request.urlopen(data_link)\n",
    "                raw_link = bs4.BeautifulSoup(html_link, 'lxml')\n",
    "                result_link = raw_link.find('div', {'id': 'main'}).find('div', {'id': 'matchupgamestatsmodule'}).findAll('div', {'class': 'statsitem'})\n",
    "            except urllib.error.HTTPError:\n",
    "                # check this at the end. hard coded link\n",
    "                html_link = urllib.request.urlopen('https://www.msn.com/en-us/sports/soccer/la-liga/eibar-v-barcelona/game-center/sp-id-80402000001009693')\n",
    "                raw_link = bs4.BeautifulSoup(html_link, 'lxml')\n",
    "                result_link = raw_link.find('div', {'id': 'main'}).find('div', {'id': 'matchupgamestatsmodule'}).findAll('div', {'class': 'statsitem'})\n",
    "            stats = []\n",
    "            chf, chs, caf, cas = get_score_count_perhalf(raw_link)\n",
    "            for rl in result_link:\n",
    "                stats.append(rl.text.split())\n",
    "            '''home_team_posession = stats[0][0]\n",
    "            away_team_posession = stats[0][-1]\n",
    "            home_team_shots = stats[1][0]\n",
    "            away_team_shots = stats[1][-1]\n",
    "            home_team_shots_on_goal = stats[2][0]\n",
    "            away_team_shots_on_goal = stats[2][-1]\n",
    "            home_team_fouls = stats[3][0]\n",
    "            away_team_fouls = stats[3][-1]\n",
    "            home_team_corners = stats[4][0]\n",
    "            away_team_corners = stats[4][-1]\n",
    "            home_team_saves = stats[5][0]\n",
    "            away_team_saves = stats[5][-1]\n",
    "            home_team_y_cards = stats[6][0]\n",
    "            away_team_y_cards = stats[6][-1]\n",
    "            try:\n",
    "                home_team_r_cards = stats[7][0]\n",
    "            except IndexError:\n",
    "                home_team_r_cards = 0\n",
    "            try:\n",
    "                away_team_r_cards = stats[7][-1]\n",
    "            except IndexError:\n",
    "                away_team_r_cards = 0'''\n",
    "            res = get_stats(stats)\n",
    "            teams.append([match_date.split(',')[0], match_date.split(',')[1][1:], home_team, away_team,\n",
    "                          home_team_score, away_team_score, chf, chs, caf, cas, data_link, res[0], res[1], res[2], res[3],\n",
    "                          res[4], res[5], res[6], res[7], res[8], res[9], res[10], res[11], res[12], res[13], res[14],\n",
    "                          res[15], res[16], res[17]])\n",
    "        time.sleep(5)\n",
    "        \n",
    "    return teams"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "metadata": {},
   "outputs": [],
   "source": [
    "all_matches = get_html(urls)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[['Sun',\n",
       "  'May 19',\n",
       "  'Eibar',\n",
       "  'Barça',\n",
       "  '2',\n",
       "  '2',\n",
       "  2,\n",
       "  0,\n",
       "  2,\n",
       "  0,\n",
       "  'https://www.msn.com/en-us/sports/soccer/la-liga/eibar-v-barcelona/game-center/sp-id-80402000001009693',\n",
       "  '39',\n",
       "  '61',\n",
       "  '18',\n",
       "  '8',\n",
       "  '8',\n",
       "  '3',\n",
       "  '17',\n",
       "  '5',\n",
       "  '5',\n",
       "  '2',\n",
       "  '1',\n",
       "  '6',\n",
       "  None,\n",
       "  None,\n",
       "  '4',\n",
       "  '2',\n",
       "  '0',\n",
       "  '0'],\n",
       " ['Sun',\n",
       "  'May 19',\n",
       "  'Real Madrid',\n",
       "  'Betis',\n",
       "  '0',\n",
       "  '2',\n",
       "  0,\n",
       "  0,\n",
       "  0,\n",
       "  2,\n",
       "  'https://www.msn.com/en-us/sports/soccer/la-liga/real-madrid-v-real-betis/game-center/sp-id-80402000001009694',\n",
       "  '47',\n",
       "  '53',\n",
       "  '9',\n",
       "  '9',\n",
       "  '2',\n",
       "  '7',\n",
       "  '18',\n",
       "  '10',\n",
       "  '1',\n",
       "  '5',\n",
       "  '5',\n",
       "  '2',\n",
       "  '1',\n",
       "  '4',\n",
       "  '4',\n",
       "  '1',\n",
       "  '0',\n",
       "  '0'],\n",
       " ['Sat',\n",
       "  'May 18',\n",
       "  'Alavés',\n",
       "  'Girona',\n",
       "  '2',\n",
       "  '1',\n",
       "  1,\n",
       "  1,\n",
       "  0,\n",
       "  1,\n",
       "  'https://www.msn.com/en-us/sports/soccer/la-liga/alav%c3%a9s-v-girona/game-center/sp-id-80402000001009686',\n",
       "  '43',\n",
       "  '57',\n",
       "  '14',\n",
       "  '13',\n",
       "  '7',\n",
       "  '4',\n",
       "  '13',\n",
       "  '10',\n",
       "  '6',\n",
       "  '4',\n",
       "  '3',\n",
       "  '5',\n",
       "  '1',\n",
       "  '4',\n",
       "  '3',\n",
       "  '3',\n",
       "  '0',\n",
       "  '0'],\n",
       " ['Sat',\n",
       "  'May 18',\n",
       "  'Celta',\n",
       "  'Rayo',\n",
       "  '2',\n",
       "  '2',\n",
       "  0,\n",
       "  2,\n",
       "  1,\n",
       "  1,\n",
       "  'https://www.msn.com/en-us/sports/soccer/la-liga/celta-de-vigo-v-rayo-vallecano/game-center/sp-id-80402000001009687',\n",
       "  '45',\n",
       "  '55',\n",
       "  '14',\n",
       "  '11',\n",
       "  '5',\n",
       "  '4',\n",
       "  '16',\n",
       "  '20',\n",
       "  '3',\n",
       "  '5',\n",
       "  '2',\n",
       "  '3',\n",
       "  '1',\n",
       "  '2',\n",
       "  '0',\n",
       "  '4',\n",
       "  '0',\n",
       "  '0'],\n",
       " ['Sat',\n",
       "  'May 18',\n",
       "  'Huesca',\n",
       "  'Leganés',\n",
       "  '2',\n",
       "  '1',\n",
       "  1,\n",
       "  2,\n",
       "  0,\n",
       "  0,\n",
       "  'https://www.msn.com/en-us/sports/soccer/la-liga/huesca-v-legan%c3%a9s/game-center/sp-id-80402000001009690',\n",
       "  '50',\n",
       "  '50',\n",
       "  '15',\n",
       "  '9',\n",
       "  '6',\n",
       "  '1',\n",
       "  '18',\n",
       "  '12',\n",
       "  '4',\n",
       "  '6',\n",
       "  '1',\n",
       "  '4',\n",
       "  '1',\n",
       "  '2',\n",
       "  '0',\n",
       "  '1',\n",
       "  '0',\n",
       "  '0'],\n",
       " ['Sat',\n",
       "  'May 18',\n",
       "  'Espanyol',\n",
       "  'Real Sociedad',\n",
       "  '2',\n",
       "  '0',\n",
       "  0,\n",
       "  2,\n",
       "  0,\n",
       "  0,\n",
       "  'https://www.msn.com/en-us/sports/soccer/la-liga/espanyol-v-real-sociedad/game-center/sp-id-80402000001009688',\n",
       "  '37',\n",
       "  '63',\n",
       "  '10',\n",
       "  '11',\n",
       "  '4',\n",
       "  '2',\n",
       "  '13',\n",
       "  '13',\n",
       "  '4',\n",
       "  '5',\n",
       "  '2',\n",
       "  '2',\n",
       "  '3',\n",
       "  '1',\n",
       "  '3',\n",
       "  '2',\n",
       "  '0',\n",
       "  '0'],\n",
       " ['Sat',\n",
       "  'May 18',\n",
       "  'Getafe',\n",
       "  'Villarreal',\n",
       "  '2',\n",
       "  '2',\n",
       "  1,\n",
       "  1,\n",
       "  1,\n",
       "  1,\n",
       "  'https://www.msn.com/en-us/sports/soccer/la-liga/getafe-v-villarreal/game-center/sp-id-80402000001009689',\n",
       "  '41',\n",
       "  '59',\n",
       "  '17',\n",
       "  '8',\n",
       "  '5',\n",
       "  '4',\n",
       "  '16',\n",
       "  '20',\n",
       "  '6',\n",
       "  '4',\n",
       "  '2',\n",
       "  '3',\n",
       "  '6',\n",
       "  '4',\n",
       "  '2',\n",
       "  '3',\n",
       "  '0',\n",
       "  '0'],\n",
       " ['Sat',\n",
       "  'May 18',\n",
       "  'Sevilla FC',\n",
       "  'Athletic',\n",
       "  '2',\n",
       "  '0',\n",
       "  1,\n",
       "  1,\n",
       "  0,\n",
       "  0,\n",
       "  'https://www.msn.com/en-us/sports/soccer/la-liga/sevilla-v-athletic-club/game-center/sp-id-80402000001009691',\n",
       "  '47',\n",
       "  '53',\n",
       "  '9',\n",
       "  '10',\n",
       "  '3',\n",
       "  '1',\n",
       "  '14',\n",
       "  '19',\n",
       "  '2',\n",
       "  '3',\n",
       "  '1',\n",
       "  '2',\n",
       "  None,\n",
       "  None,\n",
       "  '4',\n",
       "  '2',\n",
       "  '0',\n",
       "  '0'],\n",
       " ['Sat',\n",
       "  'May 18',\n",
       "  'Valladolid',\n",
       "  'Valencia',\n",
       "  '0',\n",
       "  '2',\n",
       "  0,\n",
       "  0,\n",
       "  1,\n",
       "  1,\n",
       "  'https://www.msn.com/en-us/sports/soccer/la-liga/real-valladolid-v-valencia-cf/game-center/sp-id-80402000001009695',\n",
       "  '50',\n",
       "  '50',\n",
       "  '19',\n",
       "  '9',\n",
       "  '4',\n",
       "  '6',\n",
       "  '12',\n",
       "  '10',\n",
       "  '8',\n",
       "  '2',\n",
       "  '4',\n",
       "  '4',\n",
       "  '1',\n",
       "  '3',\n",
       "  '1',\n",
       "  '4',\n",
       "  '0',\n",
       "  '0'],\n",
       " ['Sat',\n",
       "  'May 18',\n",
       "  'Levante',\n",
       "  'Atlético',\n",
       "  '2',\n",
       "  '2',\n",
       "  2,\n",
       "  0,\n",
       "  0,\n",
       "  2,\n",
       "  'https://www.msn.com/en-us/sports/soccer/la-liga/levante-v-atl%c3%a9tico-de-madrid/game-center/sp-id-80402000001009692',\n",
       "  '46',\n",
       "  '54',\n",
       "  '17',\n",
       "  '17',\n",
       "  '7',\n",
       "  '8',\n",
       "  '9',\n",
       "  '7',\n",
       "  '6',\n",
       "  '4',\n",
       "  '6',\n",
       "  '5',\n",
       "  None,\n",
       "  None,\n",
       "  '0',\n",
       "  '1',\n",
       "  '0',\n",
       "  '1'],\n",
       " ['Sun',\n",
       "  'May 12',\n",
       "  'Athletic',\n",
       "  'Celta',\n",
       "  '3',\n",
       "  '1',\n",
       "  3,\n",
       "  0,\n",
       "  0,\n",
       "  1,\n",
       "  'https://www.msn.com/en-us/sports/soccer/la-liga/athletic-club-v-celta-de-vigo/game-center/sp-id-80402000001009676',\n",
       "  '52',\n",
       "  '48',\n",
       "  '8',\n",
       "  '4',\n",
       "  '4',\n",
       "  '2',\n",
       "  '16',\n",
       "  '18',\n",
       "  '3',\n",
       "  '3',\n",
       "  '1',\n",
       "  '1',\n",
       "  '1',\n",
       "  '1',\n",
       "  '4',\n",
       "  '3',\n",
       "  '0',\n",
       "  '0'],\n",
       " ['Sun',\n",
       "  'May 12',\n",
       "  'Atlético',\n",
       "  'Sevilla FC',\n",
       "  '1',\n",
       "  '1',\n",
       "  1,\n",
       "  0,\n",
       "  0,\n",
       "  1,\n",
       "  'https://www.msn.com/en-us/sports/soccer/la-liga/atl%c3%a9tico-de-madrid-v-sevilla/game-center/sp-id-80402000001009677',\n",
       "  '48',\n",
       "  '52',\n",
       "  '11',\n",
       "  '11',\n",
       "  '4',\n",
       "  '5',\n",
       "  '16',\n",
       "  '12',\n",
       "  '5',\n",
       "  '7',\n",
       "  '4',\n",
       "  '3',\n",
       "  '7',\n",
       "  '5',\n",
       "  '5',\n",
       "  '4',\n",
       "  '0',\n",
       "  '0'],\n",
       " ['Sun',\n",
       "  'May 12',\n",
       "  'Barça',\n",
       "  'Getafe',\n",
       "  '2',\n",
       "  '0',\n",
       "  1,\n",
       "  0,\n",
       "  0,\n",
       "  1,\n",
       "  'https://www.msn.com/en-us/sports/soccer/la-liga/barcelona-v-getafe/game-center/sp-id-80402000001009678',\n",
       "  '79',\n",
       "  '21',\n",
       "  '13',\n",
       "  '11',\n",
       "  None,\n",
       "  None,\n",
       "  '9',\n",
       "  '13',\n",
       "  '4',\n",
       "  '3',\n",
       "  None,\n",
       "  None,\n",
       "  '1',\n",
       "  '5',\n",
       "  '1',\n",
       "  '3',\n",
       "  '0',\n",
       "  '0'],\n",
       " ['Sun',\n",
       "  'May 12',\n",
       "  'Betis',\n",
       "  'Huesca',\n",
       "  '2',\n",
       "  '1',\n",
       "  1,\n",
       "  1,\n",
       "  0,\n",
       "  1,\n",
       "  'https://www.msn.com/en-us/sports/soccer/la-liga/real-betis-v-huesca/game-center/sp-id-80402000001009679',\n",
       "  '62',\n",
       "  '38',\n",
       "  '17',\n",
       "  '9',\n",
       "  '8',\n",
       "  '2',\n",
       "  '13',\n",
       "  '15',\n",
       "  '9',\n",
       "  '2',\n",
       "  '1',\n",
       "  '6',\n",
       "  '1',\n",
       "  '3',\n",
       "  '3',\n",
       "  '5',\n",
       "  '0',\n",
       "  '1'],\n",
       " ['Sun',\n",
       "  'May 12',\n",
       "  'Girona',\n",
       "  'Levante',\n",
       "  '1',\n",
       "  '2',\n",
       "  0,\n",
       "  1,\n",
       "  0,\n",
       "  2,\n",
       "  'https://www.msn.com/en-us/sports/soccer/la-liga/girona-v-levante/game-center/sp-id-80402000001009680',\n",
       "  '60',\n",
       "  '40',\n",
       "  '14',\n",
       "  '7',\n",
       "  '6',\n",
       "  '3',\n",
       "  '15',\n",
       "  '16',\n",
       "  '9',\n",
       "  '2',\n",
       "  '1',\n",
       "  '5',\n",
       "  None,\n",
       "  None,\n",
       "  '2',\n",
       "  '3',\n",
       "  '0',\n",
       "  '0'],\n",
       " ['Sun',\n",
       "  'May 12',\n",
       "  'Rayo',\n",
       "  'Valladolid',\n",
       "  '1',\n",
       "  '2',\n",
       "  0,\n",
       "  1,\n",
       "  1,\n",
       "  1,\n",
       "  'https://www.msn.com/en-us/sports/soccer/la-liga/rayo-vallecano-v-real-valladolid/game-center/sp-id-80402000001009681',\n",
       "  '70',\n",
       "  '30',\n",
       "  '16',\n",
       "  '9',\n",
       "  '5',\n",
       "  '6',\n",
       "  '13',\n",
       "  '9',\n",
       "  '4',\n",
       "  '2',\n",
       "  '4',\n",
       "  '4',\n",
       "  '3',\n",
       "  '2',\n",
       "  '2',\n",
       "  '2',\n",
       "  '0',\n",
       "  '0'],\n",
       " ['Sun',\n",
       "  'May 12',\n",
       "  'Valencia',\n",
       "  'Alavés',\n",
       "  '3',\n",
       "  '1',\n",
       "  2,\n",
       "  1,\n",
       "  1,\n",
       "  0,\n",
       "  'https://www.msn.com/en-us/sports/soccer/la-liga/valencia-cf-v-alav%c3%a9s/game-center/sp-id-80402000001009682',\n",
       "  '43',\n",
       "  '57',\n",
       "  '10',\n",
       "  '10',\n",
       "  '4',\n",
       "  '3',\n",
       "  '9',\n",
       "  '14',\n",
       "  '7',\n",
       "  '4',\n",
       "  '2',\n",
       "  '1',\n",
       "  None,\n",
       "  None,\n",
       "  '2',\n",
       "  '5',\n",
       "  '0',\n",
       "  '0'],\n",
       " ['Sun',\n",
       "  'May 12',\n",
       "  'Villarreal',\n",
       "  'Eibar',\n",
       "  '1',\n",
       "  '0',\n",
       "  0,\n",
       "  1,\n",
       "  0,\n",
       "  0,\n",
       "  'https://www.msn.com/en-us/sports/soccer/la-liga/villarreal-v-eibar/game-center/sp-id-80402000001009683',\n",
       "  '42',\n",
       "  '58',\n",
       "  '11',\n",
       "  '5',\n",
       "  None,\n",
       "  None,\n",
       "  '11',\n",
       "  '14',\n",
       "  '5',\n",
       "  '3',\n",
       "  None,\n",
       "  None,\n",
       "  '6',\n",
       "  '6',\n",
       "  '3',\n",
       "  '2',\n",
       "  '0',\n",
       "  '0'],\n",
       " ['Sun',\n",
       "  'May 12',\n",
       "  'Leganés',\n",
       "  'Espanyol',\n",
       "  '0',\n",
       "  '2',\n",
       "  0,\n",
       "  0,\n",
       "  1,\n",
       "  1,\n",
       "  'https://www.msn.com/en-us/sports/soccer/la-liga/legan%c3%a9s-v-espanyol/game-center/sp-id-80402000001009684',\n",
       "  '47',\n",
       "  '53',\n",
       "  '11',\n",
       "  '19',\n",
       "  '4',\n",
       "  '7',\n",
       "  '11',\n",
       "  '9',\n",
       "  '6',\n",
       "  '7',\n",
       "  '5',\n",
       "  '4',\n",
       "  '2',\n",
       "  '6',\n",
       "  '2',\n",
       "  '1',\n",
       "  '1',\n",
       "  '0'],\n",
       " ['Sun',\n",
       "  'May 12',\n",
       "  'Real Sociedad',\n",
       "  'Real Madrid',\n",
       "  '3',\n",
       "  '1',\n",
       "  1,\n",
       "  2,\n",
       "  1,\n",
       "  0,\n",
       "  'https://www.msn.com/en-us/sports/soccer/la-liga/real-sociedad-v-real-madrid/game-center/sp-id-80402000001009685',\n",
       "  '54',\n",
       "  '46',\n",
       "  '19',\n",
       "  '6',\n",
       "  '7',\n",
       "  '2',\n",
       "  '12',\n",
       "  '16',\n",
       "  '5',\n",
       "  '2',\n",
       "  '1',\n",
       "  '4',\n",
       "  '3',\n",
       "  '3',\n",
       "  '1',\n",
       "  '2',\n",
       "  '0',\n",
       "  '1'],\n",
       " ['Sun',\n",
       "  'May 5',\n",
       "  'Huesca',\n",
       "  'Valencia',\n",
       "  '2',\n",
       "  '6',\n",
       "  1,\n",
       "  2,\n",
       "  4,\n",
       "  1,\n",
       "  'https://www.msn.com/en-us/sports/soccer/la-liga/huesca-v-valencia-cf/game-center/sp-id-80402000001009668',\n",
       "  '51',\n",
       "  '49',\n",
       "  '24',\n",
       "  '10',\n",
       "  '4',\n",
       "  '7',\n",
       "  '10',\n",
       "  '9',\n",
       "  '7',\n",
       "  '5',\n",
       "  '2',\n",
       "  '2',\n",
       "  None,\n",
       "  None,\n",
       "  '2',\n",
       "  '1',\n",
       "  '0',\n",
       "  '0'],\n",
       " ['Sun',\n",
       "  'May 5',\n",
       "  'Valladolid',\n",
       "  'Athletic',\n",
       "  '1',\n",
       "  '0',\n",
       "  1,\n",
       "  0,\n",
       "  0,\n",
       "  0,\n",
       "  'https://www.msn.com/en-us/sports/soccer/la-liga/real-valladolid-v-athletic-club/game-center/sp-id-80402000001009671',\n",
       "  '40',\n",
       "  '60',\n",
       "  '10',\n",
       "  '9',\n",
       "  '3',\n",
       "  '1',\n",
       "  '14',\n",
       "  '22',\n",
       "  '1',\n",
       "  '3',\n",
       "  '1',\n",
       "  '2',\n",
       "  '1',\n",
       "  '1',\n",
       "  '5',\n",
       "  '5',\n",
       "  '0',\n",
       "  '0'],\n",
       " ['Sun',\n",
       "  'May 5',\n",
       "  'Real Madrid',\n",
       "  'Villarreal',\n",
       "  '3',\n",
       "  '2',\n",
       "  2,\n",
       "  1,\n",
       "  1,\n",
       "  1,\n",
       "  'https://www.msn.com/en-us/sports/soccer/la-liga/real-madrid-v-villarreal/game-center/sp-id-80402000001009670',\n",
       "  '60',\n",
       "  '40',\n",
       "  '24',\n",
       "  '15',\n",
       "  '11',\n",
       "  '7',\n",
       "  '9',\n",
       "  '14',\n",
       "  '8',\n",
       "  '3',\n",
       "  '5',\n",
       "  '8',\n",
       "  '3',\n",
       "  '3',\n",
       "  '0',\n",
       "  '3',\n",
       "  '0',\n",
       "  '0'],\n",
       " ['Sun',\n",
       "  'May 5',\n",
       "  'Eibar',\n",
       "  'Betis',\n",
       "  '1',\n",
       "  '0',\n",
       "  1,\n",
       "  0,\n",
       "  0,\n",
       "  0,\n",
       "  'https://www.msn.com/en-us/sports/soccer/la-liga/eibar-v-real-betis/game-center/sp-id-80402000001009674',\n",
       "  '46',\n",
       "  '54',\n",
       "  '14',\n",
       "  '12',\n",
       "  '6',\n",
       "  '6',\n",
       "  '15',\n",
       "  '7',\n",
       "  '11',\n",
       "  '8',\n",
       "  '6',\n",
       "  '5',\n",
       "  '1',\n",
       "  '3',\n",
       "  '3',\n",
       "  '2',\n",
       "  '0',\n",
       "  '0'],\n",
       " ['Sun',\n",
       "  'May 5',\n",
       "  'Getafe',\n",
       "  'Girona',\n",
       "  '2',\n",
       "  '0',\n",
       "  1,\n",
       "  1,\n",
       "  0,\n",
       "  0,\n",
       "  'https://www.msn.com/en-us/sports/soccer/la-liga/getafe-v-girona/game-center/sp-id-80402000001009667',\n",
       "  '41',\n",
       "  '59',\n",
       "  '13',\n",
       "  '4',\n",
       "  '8',\n",
       "  '2',\n",
       "  '15',\n",
       "  '13',\n",
       "  '1',\n",
       "  '3',\n",
       "  '2',\n",
       "  '6',\n",
       "  '1',\n",
       "  '2',\n",
       "  '3',\n",
       "  '3',\n",
       "  '0',\n",
       "  '1'],\n",
       " ['Sat',\n",
       "  'May 4',\n",
       "  'Celta',\n",
       "  'Barça',\n",
       "  '2',\n",
       "  '0',\n",
       "  0,\n",
       "  2,\n",
       "  0,\n",
       "  0,\n",
       "  'https://www.msn.com/en-us/sports/soccer/la-liga/celta-de-vigo-v-barcelona/game-center/sp-id-80402000001009673',\n",
       "  '35',\n",
       "  '65',\n",
       "  '14',\n",
       "  '8',\n",
       "  '6',\n",
       "  '1',\n",
       "  '11',\n",
       "  '13',\n",
       "  '11',\n",
       "  '1',\n",
       "  '1',\n",
       "  '4',\n",
       "  '2',\n",
       "  '1',\n",
       "  '1',\n",
       "  '5',\n",
       "  '0',\n",
       "  '0'],\n",
       " ['Sat',\n",
       "  'May 4',\n",
       "  'Alavés',\n",
       "  'Real Sociedad',\n",
       "  '0',\n",
       "  '1',\n",
       "  1,\n",
       "  0,\n",
       "  0,\n",
       "  0,\n",
       "  'https://www.msn.com/en-us/sports/soccer/la-liga/alav%c3%a9s-v-real-sociedad/game-center/sp-id-80402000001009666',\n",
       "  '50',\n",
       "  '50',\n",
       "  '18',\n",
       "  '9',\n",
       "  '6',\n",
       "  '2',\n",
       "  '7',\n",
       "  '22',\n",
       "  '13',\n",
       "  '6',\n",
       "  '2',\n",
       "  '6',\n",
       "  '3',\n",
       "  '2',\n",
       "  '1',\n",
       "  '3',\n",
       "  '0',\n",
       "  '0'],\n",
       " ['Sat',\n",
       "  'May 4',\n",
       "  'Espanyol',\n",
       "  'Atlético',\n",
       "  '3',\n",
       "  '0',\n",
       "  0,\n",
       "  2,\n",
       "  1,\n",
       "  0,\n",
       "  'https://www.msn.com/en-us/sports/soccer/la-liga/espanyol-v-atl%c3%a9tico-de-madrid/game-center/sp-id-80402000001009672',\n",
       "  '50',\n",
       "  '50',\n",
       "  '11',\n",
       "  '11',\n",
       "  '5',\n",
       "  '3',\n",
       "  '11',\n",
       "  '14',\n",
       "  '5',\n",
       "  '6',\n",
       "  '3',\n",
       "  '3',\n",
       "  None,\n",
       "  None,\n",
       "  '1',\n",
       "  '2',\n",
       "  '0',\n",
       "  '0'],\n",
       " ['Sat',\n",
       "  'May 4',\n",
       "  'Levante',\n",
       "  'Rayo',\n",
       "  '4',\n",
       "  '1',\n",
       "  2,\n",
       "  2,\n",
       "  0,\n",
       "  1,\n",
       "  'https://www.msn.com/en-us/sports/soccer/la-liga/levante-v-rayo-vallecano/game-center/sp-id-80402000001009669',\n",
       "  '35',\n",
       "  '65',\n",
       "  '11',\n",
       "  '20',\n",
       "  '7',\n",
       "  '3',\n",
       "  '17',\n",
       "  '12',\n",
       "  '6',\n",
       "  '7',\n",
       "  '2',\n",
       "  '3',\n",
       "  None,\n",
       "  None,\n",
       "  '1',\n",
       "  '2',\n",
       "  '0',\n",
       "  '1'],\n",
       " ['Fri',\n",
       "  'May 3',\n",
       "  'Sevilla FC',\n",
       "  'Leganés',\n",
       "  '0',\n",
       "  '3',\n",
       "  0,\n",
       "  0,\n",
       "  2,\n",
       "  1,\n",
       "  'https://www.msn.com/en-us/sports/soccer/la-liga/sevilla-v-legan%c3%a9s/game-center/sp-id-80402000001009675',\n",
       "  '64',\n",
       "  '36',\n",
       "  '7',\n",
       "  '9',\n",
       "  '3',\n",
       "  '5',\n",
       "  '11',\n",
       "  '23',\n",
       "  '3',\n",
       "  '4',\n",
       "  '2',\n",
       "  '3',\n",
       "  '3',\n",
       "  '3',\n",
       "  '1',\n",
       "  '1',\n",
       "  '0',\n",
       "  '0'],\n",
       " ['Mon',\n",
       "  'Apr 29',\n",
       "  'Betis',\n",
       "  'Espanyol',\n",
       "  '1',\n",
       "  '1',\n",
       "  0,\n",
       "  1,\n",
       "  1,\n",
       "  0,\n",
       "  'https://www.msn.com/en-us/sports/soccer/la-liga/real-betis-v-espanyol/game-center/sp-id-80402000001009658',\n",
       "  '54',\n",
       "  '46',\n",
       "  '18',\n",
       "  '10',\n",
       "  '5',\n",
       "  '4',\n",
       "  '16',\n",
       "  '14',\n",
       "  '6',\n",
       "  '5',\n",
       "  '2',\n",
       "  '5',\n",
       "  '1',\n",
       "  '2',\n",
       "  '4',\n",
       "  '1',\n",
       "  '0',\n",
       "  '0'],\n",
       " ['Sun',\n",
       "  'Apr 28',\n",
       "  'Rayo',\n",
       "  'Real Madrid',\n",
       "  '1',\n",
       "  '0',\n",
       "  1,\n",
       "  0,\n",
       "  0,\n",
       "  0,\n",
       "  'https://www.msn.com/en-us/sports/soccer/la-liga/rayo-vallecano-v-real-madrid/game-center/sp-id-80402000001009660',\n",
       "  '49',\n",
       "  '51',\n",
       "  '12',\n",
       "  '9',\n",
       "  '5',\n",
       "  '3',\n",
       "  '21',\n",
       "  '6',\n",
       "  '6',\n",
       "  '6',\n",
       "  '3',\n",
       "  '3',\n",
       "  '3',\n",
       "  '6',\n",
       "  '2',\n",
       "  '5',\n",
       "  '0',\n",
       "  '0'],\n",
       " ['Sun',\n",
       "  'Apr 28',\n",
       "  'Villarreal',\n",
       "  'Huesca',\n",
       "  '1',\n",
       "  '1',\n",
       "  1,\n",
       "  0,\n",
       "  0,\n",
       "  1,\n",
       "  'https://www.msn.com/en-us/sports/soccer/la-liga/villarreal-v-huesca/game-center/sp-id-80402000001009665',\n",
       "  '47',\n",
       "  '53',\n",
       "  '18',\n",
       "  '14',\n",
       "  '5',\n",
       "  '3',\n",
       "  '15',\n",
       "  '22',\n",
       "  None,\n",
       "  None,\n",
       "  '2',\n",
       "  '4',\n",
       "  '1',\n",
       "  '3',\n",
       "  '5',\n",
       "  '2',\n",
       "  '0',\n",
       "  '1'],\n",
       " ['Sun',\n",
       "  'Apr 28',\n",
       "  'Real Sociedad',\n",
       "  'Getafe',\n",
       "  '2',\n",
       "  '1',\n",
       "  1,\n",
       "  1,\n",
       "  0,\n",
       "  1,\n",
       "  'https://www.msn.com/en-us/sports/soccer/la-liga/real-sociedad-v-getafe/game-center/sp-id-80402000001009664',\n",
       "  '50',\n",
       "  '50',\n",
       "  '11',\n",
       "  '12',\n",
       "  '7',\n",
       "  '3',\n",
       "  '17',\n",
       "  '14',\n",
       "  '5',\n",
       "  '7',\n",
       "  '2',\n",
       "  '5',\n",
       "  '3',\n",
       "  '1',\n",
       "  '2',\n",
       "  '3',\n",
       "  '0',\n",
       "  '0'],\n",
       " ['Sun',\n",
       "  'Apr 28',\n",
       "  'Girona',\n",
       "  'Sevilla FC',\n",
       "  '1',\n",
       "  '0',\n",
       "  0,\n",
       "  1,\n",
       "  0,\n",
       "  0,\n",
       "  'https://www.msn.com/en-us/sports/soccer/la-liga/girona-v-sevilla/game-center/sp-id-80402000001009659',\n",
       "  '43',\n",
       "  '57',\n",
       "  '15',\n",
       "  '7',\n",
       "  '4',\n",
       "  '3',\n",
       "  '12',\n",
       "  '18',\n",
       "  '3',\n",
       "  '6',\n",
       "  '3',\n",
       "  '3',\n",
       "  None,\n",
       "  None,\n",
       "  '1',\n",
       "  '2',\n",
       "  '0',\n",
       "  '1'],\n",
       " ['Sun',\n",
       "  'Apr 28',\n",
       "  'Valencia',\n",
       "  'Eibar',\n",
       "  '0',\n",
       "  '1',\n",
       "  0,\n",
       "  0,\n",
       "  0,\n",
       "  1,\n",
       "  'https://www.msn.com/en-us/sports/soccer/la-liga/valencia-cf-v-eibar/game-center/sp-id-80402000001009663',\n",
       "  '49',\n",
       "  '51',\n",
       "  '7',\n",
       "  '13',\n",
       "  '2',\n",
       "  '3',\n",
       "  '10',\n",
       "  '15',\n",
       "  '7',\n",
       "  '6',\n",
       "  '3',\n",
       "  '2',\n",
       "  '6',\n",
       "  '1',\n",
       "  '2',\n",
       "  '3',\n",
       "  '0',\n",
       "  '0']]"
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "all_matches"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "380"
      ]
     },
     "execution_count": 73,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(all_matches)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "cols = ['match_day', 'match_date', 'home_team', 'away_team', 'home_team_score', 'away_team_score', 'HT_num_goals_firsthalf', \n",
    "            'HT_num_goals_secondhalf', 'AT_num_goals_firsthalf', 'AT_num_goals_secondhalf', 'match_link', 'home_posession', \n",
    "            'away_posession', 'home_shots', 'away_shots', 'home_shots_ontarget', 'away_shots_ontarget', 'home_fouls', \n",
    "            'away_fouls', 'home_corners', 'away_corners', 'home_saves', 'away_saves', 'home_offsides', 'away_offsides', \n",
    "            'home_yellow', 'away_yellow', 'home_red', 'away_red']\n",
    "df = pd.DataFrame(all_matches, columns=cols)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 380 entries, 0 to 379\n",
      "Data columns (total 29 columns):\n",
      "match_day                  380 non-null object\n",
      "match_date                 380 non-null object\n",
      "home_team                  380 non-null object\n",
      "away_team                  380 non-null object\n",
      "home_team_score            380 non-null object\n",
      "away_team_score            380 non-null object\n",
      "HT_num_goals_firsthalf     380 non-null int64\n",
      "HT_num_goals_secondhalf    380 non-null int64\n",
      "AT_num_goals_firsthalf     380 non-null int64\n",
      "AT_num_goals_secondhalf    380 non-null int64\n",
      "match_link                 380 non-null object\n",
      "home_posession             380 non-null object\n",
      "away_posession             380 non-null object\n",
      "home_shots                 380 non-null object\n",
      "away_shots                 380 non-null object\n",
      "home_shots_ontarget        366 non-null object\n",
      "away_shots_ontarget        366 non-null object\n",
      "home_fouls                 380 non-null object\n",
      "away_fouls                 380 non-null object\n",
      "home_corners               362 non-null object\n",
      "away_corners               362 non-null object\n",
      "home_saves                 336 non-null object\n",
      "away_saves                 336 non-null object\n",
      "home_offsides              264 non-null object\n",
      "away_offsides              264 non-null object\n",
      "home_yellow                380 non-null object\n",
      "away_yellow                380 non-null object\n",
      "home_red                   380 non-null object\n",
      "away_red                   380 non-null object\n",
      "dtypes: int64(4), object(25)\n",
      "memory usage: 86.2+ KB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv('laliga-2018-2019.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "laliga = pd.read_csv('laliga-2018-2019.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "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>match_day</th>\n",
       "      <th>match_date</th>\n",
       "      <th>home_team</th>\n",
       "      <th>away_team</th>\n",
       "      <th>home_team_score</th>\n",
       "      <th>away_team_score</th>\n",
       "      <th>HT_num_goals_firsthalf</th>\n",
       "      <th>HT_num_goals_secondhalf</th>\n",
       "      <th>AT_num_goals_firsthalf</th>\n",
       "      <th>AT_num_goals_secondhalf</th>\n",
       "      <th>...</th>\n",
       "      <th>home_corners</th>\n",
       "      <th>away_corners</th>\n",
       "      <th>home_saves</th>\n",
       "      <th>away_saves</th>\n",
       "      <th>home_offsides</th>\n",
       "      <th>away_offsides</th>\n",
       "      <th>home_yellow</th>\n",
       "      <th>away_yellow</th>\n",
       "      <th>home_red</th>\n",
       "      <th>away_red</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Sun</td>\n",
       "      <td>May 19</td>\n",
       "      <td>Eibar</td>\n",
       "      <td>Barça</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Sun</td>\n",
       "      <td>May 19</td>\n",
       "      <td>Real Madrid</td>\n",
       "      <td>Betis</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Sat</td>\n",
       "      <td>May 18</td>\n",
       "      <td>Alavés</td>\n",
       "      <td>Girona</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>6.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Sat</td>\n",
       "      <td>May 18</td>\n",
       "      <td>Celta</td>\n",
       "      <td>Rayo</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Sat</td>\n",
       "      <td>May 18</td>\n",
       "      <td>Huesca</td>\n",
       "      <td>Leganés</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 29 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  match_day match_date    home_team away_team  home_team_score  \\\n",
       "0       Sun     May 19        Eibar     Barça                2   \n",
       "1       Sun     May 19  Real Madrid     Betis                0   \n",
       "2       Sat     May 18       Alavés    Girona                2   \n",
       "3       Sat     May 18        Celta      Rayo                2   \n",
       "4       Sat     May 18       Huesca   Leganés                2   \n",
       "\n",
       "   away_team_score  HT_num_goals_firsthalf  HT_num_goals_secondhalf  \\\n",
       "0                2                       2                        0   \n",
       "1                2                       0                        0   \n",
       "2                1                       1                        1   \n",
       "3                2                       0                        2   \n",
       "4                1                       1                        2   \n",
       "\n",
       "   AT_num_goals_firsthalf  AT_num_goals_secondhalf    ...    home_corners  \\\n",
       "0                       2                        0    ...             5.0   \n",
       "1                       0                        2    ...             1.0   \n",
       "2                       0                        1    ...             6.0   \n",
       "3                       1                        1    ...             3.0   \n",
       "4                       0                        0    ...             4.0   \n",
       "\n",
       "   away_corners  home_saves  away_saves  home_offsides  away_offsides  \\\n",
       "0           2.0         1.0         6.0            NaN            NaN   \n",
       "1           5.0         5.0         2.0            1.0            4.0   \n",
       "2           4.0         3.0         5.0            1.0            4.0   \n",
       "3           5.0         2.0         3.0            1.0            2.0   \n",
       "4           6.0         1.0         4.0            1.0            2.0   \n",
       "\n",
       "   home_yellow  away_yellow  home_red  away_red  \n",
       "0            4            2         0         0  \n",
       "1            4            1         0         0  \n",
       "2            3            3         0         0  \n",
       "3            0            4         0         0  \n",
       "4            0            1         0         0  \n",
       "\n",
       "[5 rows x 29 columns]"
      ]
     },
     "execution_count": 81,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "laliga.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "metadata": {},
   "outputs": [
    {
     "ename": "TypeError",
     "evalue": "to_sql() missing 1 required positional argument: 'con'",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mTypeError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-82-68eeb0a968af>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m()\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[0mdf\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mto_sql\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m'laliga-2018-19.sql'\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;31mTypeError\u001b[0m: to_sql() missing 1 required positional argument: 'con'"
     ]
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "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.6.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}