data_preprocessing/EnglishLeague.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import zipfile # it is used for reading the zip file without extrating\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "#reading files\n",
    "\n",
    "with zipfile.ZipFile(\"matches.zip\") as Z:\n",
    "    with Z.open(\"matches_England.json\") as f:\n",
    "        matches_df = pd.read_json(f)\n",
    "        \n",
    "with zipfile.ZipFile(\"events.zip\") as Z:\n",
    "    with Z.open(\"events_England.json\") as f:\n",
    "        events_df = pd.read_json(f)\n",
    "        \n",
    "competitions = pd.read_json(\"competitions.json\")\n",
    "playerRank = pd.read_json(\"playerank.json\")\n",
    "players = pd.read_json(\"players.json\")\n",
    "\n",
    "eventId_name = pd.read_csv(\"eventid2name.csv\")\n",
    "tags_name = pd.read_csv(\"tags2name.csv\")\n",
    "\n",
    "# all_teams"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "# matches_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "all_teams =pd.read_json(\"teams.json\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "# events_df.shape, events_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "# competitions"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "# playerRank.shape,playerRank.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "# players.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "# tags_name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "# matches_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "# events_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "# matches_df[matches_df.wyId == 2499719]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "#weekly points\n",
    "\n",
    "point_data = list()\n",
    "for i in range(len(matches_df)):\n",
    "    gameweek = matches_df.iloc[i].gameweek# iloc is used for the locating data in a data frame\n",
    "    label = matches_df.iloc[i].label\n",
    "    match_id = matches_df.iloc[i].wyId\n",
    "    \n",
    "    score = label.split(\",\")[1]\n",
    "    b = score.split(\"-\")\n",
    "    c = [int(i) for i in b]\n",
    "    diff = c[0] - c[1]\n",
    "    \n",
    "    [[home_team, away_team], [home_score, away_score]] = [[o.strip() for o in s.split('-')] for s in label.split(',')]# here we have converted the label column into a nested list, od home team/away team . HOme score and Away score \n",
    "    home_score = int(home_score)\n",
    "    away_score = int(away_score)\n",
    "    if home_score > away_score:# we have identified the winner /looser and Draw\n",
    "        home_point = 3\n",
    "        away_point = 0\n",
    "    if away_score > home_score:\n",
    "        away_point = 3\n",
    "        home_point = 0\n",
    "    if away_score == home_score:\n",
    "        home_point = 1\n",
    "        away_point = 1\n",
    "    point_data.append([gameweek, home_team, home_point,label,match_id,diff]) #here we have summarize the team with week and point all together\n",
    "    point_data.append([gameweek, away_team, away_point,label,match_id,-diff])\n",
    "point_df = pd.DataFrame(point_data, columns=['gameweek', 'team', 'point','label','matchId','tempgd']) #setup a datafram"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "weeks = np.sort(point_df.gameweek.unique())\n",
    "teams = point_df.team.unique()\n",
    "points_cp = pd.DataFrame([])\n",
    "\n",
    "for team in teams:\n",
    "    t1 = point_df[point_df.team == team]\n",
    "    cumP = {}\n",
    "    cumgd ={}\n",
    "    t1 = t1.sort_values(by=['gameweek'])\n",
    "    for week in weeks:\n",
    "        if week == 1:\n",
    "            cumP[week] = int(t1[t1.gameweek == 1]['point'])\n",
    "            cumgd[week] = int(t1[t1.gameweek == 1]['tempgd'])\n",
    "        else:\n",
    "            cumP[week] = int(t1[t1.gameweek == week]['point']) + cumP.get(week -1) \n",
    "            cumgd[week] = int(t1[t1.gameweek == week]['tempgd']) + cumgd.get(week -1)\n",
    "    \n",
    "    t1['cummPoints'] = t1.apply(lambda x : cumP.get(x.gameweek),axis =1)\n",
    "    t1['gd'] = t1.apply(lambda x : cumgd.get(x.gameweek),axis =1)\n",
    "#     print(t1)\n",
    "    points_cp = points_cp.append(t1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "weekly_points = pd.DataFrame()\n",
    "for week in weeks:\n",
    "    t1 = points_cp[points_cp.gameweek == week]\n",
    "    t2 =t1.sort_values(by=['cummPoints','gd'],ascending=False)\n",
    "    t2['rank'] = [i for i in range(1,t2.shape[0]+1)]\n",
    "    weekly_points = weekly_points.append(t2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "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>gameweek</th>\n",
       "      <th>team</th>\n",
       "      <th>point</th>\n",
       "      <th>label</th>\n",
       "      <th>matchId</th>\n",
       "      <th>tempgd</th>\n",
       "      <th>cummPoints</th>\n",
       "      <th>gd</th>\n",
       "      <th>rank</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>740</th>\n",
       "      <td>1</td>\n",
       "      <td>Manchester United</td>\n",
       "      <td>3</td>\n",
       "      <td>Manchester United - West Ham United, 4 - 0</td>\n",
       "      <td>2499724</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>749</th>\n",
       "      <td>1</td>\n",
       "      <td>Huddersfield Town</td>\n",
       "      <td>3</td>\n",
       "      <td>Crystal Palace - Huddersfield Town, 0 - 3</td>\n",
       "      <td>2499722</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>745</th>\n",
       "      <td>1</td>\n",
       "      <td>Manchester City</td>\n",
       "      <td>3</td>\n",
       "      <td>Brighton &amp; Hove Albion - Manchester City, 0 - 2</td>\n",
       "      <td>2499720</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>743</th>\n",
       "      <td>1</td>\n",
       "      <td>Tottenham Hotspur</td>\n",
       "      <td>3</td>\n",
       "      <td>Newcastle United - Tottenham Hotspur, 0 - 2</td>\n",
       "      <td>2499725</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>747</th>\n",
       "      <td>1</td>\n",
       "      <td>Burnley</td>\n",
       "      <td>3</td>\n",
       "      <td>Chelsea - Burnley, 2 - 3</td>\n",
       "      <td>2499721</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>5</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>4</th>\n",
       "      <td>38</td>\n",
       "      <td>Huddersfield Town</td>\n",
       "      <td>0</td>\n",
       "      <td>Huddersfield Town - Arsenal, 0 - 1</td>\n",
       "      <td>2500091</td>\n",
       "      <td>-1</td>\n",
       "      <td>37</td>\n",
       "      <td>-30</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>38</td>\n",
       "      <td>Southampton</td>\n",
       "      <td>0</td>\n",
       "      <td>Southampton - Manchester City, 0 - 1</td>\n",
       "      <td>2500095</td>\n",
       "      <td>-1</td>\n",
       "      <td>36</td>\n",
       "      <td>-19</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>38</td>\n",
       "      <td>Swansea City</td>\n",
       "      <td>0</td>\n",
       "      <td>Swansea City - Stoke City, 1 - 2</td>\n",
       "      <td>2500096</td>\n",
       "      <td>-1</td>\n",
       "      <td>33</td>\n",
       "      <td>-28</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>38</td>\n",
       "      <td>Stoke City</td>\n",
       "      <td>3</td>\n",
       "      <td>Swansea City - Stoke City, 1 - 2</td>\n",
       "      <td>2500096</td>\n",
       "      <td>1</td>\n",
       "      <td>33</td>\n",
       "      <td>-33</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>38</td>\n",
       "      <td>West Bromwich Albion</td>\n",
       "      <td>0</td>\n",
       "      <td>Crystal Palace - West Bromwich Albion, 2 - 0</td>\n",
       "      <td>2500090</td>\n",
       "      <td>-2</td>\n",
       "      <td>31</td>\n",
       "      <td>-25</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>760 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     gameweek                  team  point  \\\n",
       "740         1     Manchester United      3   \n",
       "749         1     Huddersfield Town      3   \n",
       "745         1       Manchester City      3   \n",
       "743         1     Tottenham Hotspur      3   \n",
       "747         1               Burnley      3   \n",
       "..        ...                   ...    ...   \n",
       "4          38     Huddersfield Town      0   \n",
       "12         38           Southampton      0   \n",
       "14         38          Swansea City      0   \n",
       "15         38            Stoke City      3   \n",
       "3          38  West Bromwich Albion      0   \n",
       "\n",
       "                                               label  matchId  tempgd  \\\n",
       "740       Manchester United - West Ham United, 4 - 0  2499724       4   \n",
       "749        Crystal Palace - Huddersfield Town, 0 - 3  2499722       3   \n",
       "745  Brighton & Hove Albion - Manchester City, 0 - 2  2499720       2   \n",
       "743      Newcastle United - Tottenham Hotspur, 0 - 2  2499725       2   \n",
       "747                         Chelsea - Burnley, 2 - 3  2499721       1   \n",
       "..                                               ...      ...     ...   \n",
       "4                 Huddersfield Town - Arsenal, 0 - 1  2500091      -1   \n",
       "12              Southampton - Manchester City, 0 - 1  2500095      -1   \n",
       "14                  Swansea City - Stoke City, 1 - 2  2500096      -1   \n",
       "15                  Swansea City - Stoke City, 1 - 2  2500096       1   \n",
       "3       Crystal Palace - West Bromwich Albion, 2 - 0  2500090      -2   \n",
       "\n",
       "     cummPoints  gd  rank  \n",
       "740           3   4     1  \n",
       "749           3   3     2  \n",
       "745           3   2     3  \n",
       "743           3   2     4  \n",
       "747           3   1     5  \n",
       "..          ...  ..   ...  \n",
       "4            37 -30    16  \n",
       "12           36 -19    17  \n",
       "14           33 -28    18  \n",
       "15           33 -33    19  \n",
       "3            31 -25    20  \n",
       "\n",
       "[760 rows x 9 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "weekly_points"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "weekly_points = weekly_points.sort_values(by=[\"team\",'gameweek'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "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>gameweek</th>\n",
       "      <th>team</th>\n",
       "      <th>point</th>\n",
       "      <th>label</th>\n",
       "      <th>matchId</th>\n",
       "      <th>tempgd</th>\n",
       "      <th>cummPoints</th>\n",
       "      <th>gd</th>\n",
       "      <th>rank</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>755</th>\n",
       "      <td>1</td>\n",
       "      <td>AFC Bournemouth</td>\n",
       "      <td>0</td>\n",
       "      <td>West Bromwich Albion - AFC Bournemouth, 1 - 0</td>\n",
       "      <td>2499728</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>-1</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>728</th>\n",
       "      <td>2</td>\n",
       "      <td>AFC Bournemouth</td>\n",
       "      <td>0</td>\n",
       "      <td>AFC Bournemouth - Watford, 0 - 2</td>\n",
       "      <td>2499729</td>\n",
       "      <td>-2</td>\n",
       "      <td>0</td>\n",
       "      <td>-3</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>718</th>\n",
       "      <td>3</td>\n",
       "      <td>AFC Bournemouth</td>\n",
       "      <td>0</td>\n",
       "      <td>AFC Bournemouth - Manchester City, 1 - 2</td>\n",
       "      <td>2499739</td>\n",
       "      <td>-1</td>\n",
       "      <td>0</td>\n",
       "      <td>-4</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>689</th>\n",
       "      <td>4</td>\n",
       "      <td>AFC Bournemouth</td>\n",
       "      <td>0</td>\n",
       "      <td>Arsenal - AFC Bournemouth, 3 - 0</td>\n",
       "      <td>2499749</td>\n",
       "      <td>-3</td>\n",
       "      <td>0</td>\n",
       "      <td>-7</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>678</th>\n",
       "      <td>5</td>\n",
       "      <td>AFC Bournemouth</td>\n",
       "      <td>3</td>\n",
       "      <td>AFC Bournemouth - Brighton &amp; Hove Albion, 2 - 1</td>\n",
       "      <td>2499759</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>-6</td>\n",
       "      <td>19</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>92</th>\n",
       "      <td>34</td>\n",
       "      <td>West Ham United</td>\n",
       "      <td>1</td>\n",
       "      <td>West Ham United - Stoke City, 1 - 1</td>\n",
       "      <td>2500058</td>\n",
       "      <td>0</td>\n",
       "      <td>36</td>\n",
       "      <td>-18</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>35</td>\n",
       "      <td>West Ham United</td>\n",
       "      <td>0</td>\n",
       "      <td>Arsenal - West Ham United, 4 - 1</td>\n",
       "      <td>2500060</td>\n",
       "      <td>-3</td>\n",
       "      <td>36</td>\n",
       "      <td>-21</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>36</td>\n",
       "      <td>West Ham United</td>\n",
       "      <td>0</td>\n",
       "      <td>West Ham United - Manchester City, 1 - 4</td>\n",
       "      <td>2500078</td>\n",
       "      <td>-3</td>\n",
       "      <td>36</td>\n",
       "      <td>-24</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>37</td>\n",
       "      <td>West Ham United</td>\n",
       "      <td>3</td>\n",
       "      <td>Leicester City - West Ham United, 0 - 2</td>\n",
       "      <td>2500084</td>\n",
       "      <td>2</td>\n",
       "      <td>39</td>\n",
       "      <td>-22</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>38</td>\n",
       "      <td>West Ham United</td>\n",
       "      <td>3</td>\n",
       "      <td>West Ham United - Everton, 3 - 1</td>\n",
       "      <td>2500098</td>\n",
       "      <td>2</td>\n",
       "      <td>42</td>\n",
       "      <td>-20</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>760 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     gameweek             team  point  \\\n",
       "755         1  AFC Bournemouth      0   \n",
       "728         2  AFC Bournemouth      0   \n",
       "718         3  AFC Bournemouth      0   \n",
       "689         4  AFC Bournemouth      0   \n",
       "678         5  AFC Bournemouth      3   \n",
       "..        ...              ...    ...   \n",
       "92         34  West Ham United      1   \n",
       "77         35  West Ham United      0   \n",
       "56         36  West Ham United      0   \n",
       "43         37  West Ham United      3   \n",
       "18         38  West Ham United      3   \n",
       "\n",
       "                                               label  matchId  tempgd  \\\n",
       "755    West Bromwich Albion - AFC Bournemouth, 1 - 0  2499728      -1   \n",
       "728                 AFC Bournemouth - Watford, 0 - 2  2499729      -2   \n",
       "718         AFC Bournemouth - Manchester City, 1 - 2  2499739      -1   \n",
       "689                 Arsenal - AFC Bournemouth, 3 - 0  2499749      -3   \n",
       "678  AFC Bournemouth - Brighton & Hove Albion, 2 - 1  2499759       1   \n",
       "..                                               ...      ...     ...   \n",
       "92               West Ham United - Stoke City, 1 - 1  2500058       0   \n",
       "77                  Arsenal - West Ham United, 4 - 1  2500060      -3   \n",
       "56          West Ham United - Manchester City, 1 - 4  2500078      -3   \n",
       "43           Leicester City - West Ham United, 0 - 2  2500084       2   \n",
       "18                  West Ham United - Everton, 3 - 1  2500098       2   \n",
       "\n",
       "     cummPoints  gd  rank  \n",
       "755           0  -1    13  \n",
       "728           0  -3    16  \n",
       "718           0  -4    18  \n",
       "689           0  -7    19  \n",
       "678           3  -6    19  \n",
       "..          ...  ..   ...  \n",
       "92           36 -18    13  \n",
       "77           36 -21    14  \n",
       "56           36 -24    15  \n",
       "43           39 -22    15  \n",
       "18           42 -20    13  \n",
       "\n",
       "[760 rows x 9 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "weekly_points"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "weekly_points.to_csv(\"englandLeague.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Burnley', 'AFC Bournemouth', 'Crystal Palace',\n",
       "       'West Bromwich Albion', 'Huddersfield Town', 'Arsenal',\n",
       "       'Liverpool', 'Brighton & Hove Albion', 'Manchester United',\n",
       "       'Watford', 'Newcastle United', 'Chelsea', 'Southampton',\n",
       "       'Manchester City', 'Swansea City', 'Stoke City',\n",
       "       'Tottenham Hotspur', 'Leicester City', 'West Ham United',\n",
       "       'Everton'], dtype=object)"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "teams"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "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
}