3. Odds.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "eb0004fe",
   "metadata": {},
   "outputs": [],
   "source": [
    "import os, json\n",
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "f50b56e5",
   "metadata": {},
   "outputs": [],
   "source": [
    "years = [year for year in range(2016,2022+1)]\n",
    "odds_dfs = []\n",
    "for year in years:\n",
    "    path_str = 'data/Odds/' + str(year) + '/'\n",
    "    for x, file_name in enumerate([x_json for x_json in os.listdir(path_str) if x_json.endswith('.json')]):\n",
    "        with open(path_str + file_name) as json_file:\n",
    "            if x == 0:\n",
    "                odds_df = pd.DataFrame(json.load(json_file))\n",
    "            else:\n",
    "                odds_df = pd.concat([odds_df,pd.DataFrame(json.load(json_file))])\n",
    "    odds_df['Season'] = year\n",
    "    odds_dfs.append(odds_df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "4a49124b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0     False\n",
       "1      True\n",
       "2     False\n",
       "3      True\n",
       "4     False\n",
       "      ...  \n",
       "8     False\n",
       "9      True\n",
       "10     True\n",
       "11     True\n",
       "12     True\n",
       "Name: Favorite, Length: 256, dtype: bool"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "odds_dfs[0]['Favorite'].str[:2]==\"at\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "e60c7e64",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0        nthers\n",
       "1        Texans\n",
       "2         ngals\n",
       "3        Eagles\n",
       "4         ckers\n",
       "        ...    \n",
       "8          ints\n",
       "9       Packers\n",
       "10     Chargers\n",
       "11      Raiders\n",
       "12     Seahawks\n",
       "Name: Favorite, Length: 256, dtype: object"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "odds_dfs[0]['Favorite'].str[2:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "5506b7a4",
   "metadata": {},
   "outputs": [],
   "source": [
    "full_odds = pd.concat(odds_dfs).reset_index(drop = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "0a594361",
   "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>Date</th>\n",
       "      <th>Favorite</th>\n",
       "      <th>UnderDog</th>\n",
       "      <th>PointSpread</th>\n",
       "      <th>OverUnder</th>\n",
       "      <th>AwayTeamMoneyLine</th>\n",
       "      <th>HomeTeamMoneyLine</th>\n",
       "      <th>Season</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>September 8, 2016 8:30 PM</td>\n",
       "      <td>Panthers</td>\n",
       "      <td>at Broncos</td>\n",
       "      <td>-3.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>-165</td>\n",
       "      <td>+145</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>September 11, 2016 1:00 PM</td>\n",
       "      <td>at Texans</td>\n",
       "      <td>Bears</td>\n",
       "      <td>-6.0</td>\n",
       "      <td>42.5</td>\n",
       "      <td>+220</td>\n",
       "      <td>-260</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>September 11, 2016 1:00 PM</td>\n",
       "      <td>Bengals</td>\n",
       "      <td>at Jets</td>\n",
       "      <td>-3.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>-115</td>\n",
       "      <td>-105</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>September 11, 2016 1:00 PM</td>\n",
       "      <td>at Eagles</td>\n",
       "      <td>Browns</td>\n",
       "      <td>-4.0</td>\n",
       "      <td>41.5</td>\n",
       "      <td>+165</td>\n",
       "      <td>-190</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>September 11, 2016 1:00 PM</td>\n",
       "      <td>Packers</td>\n",
       "      <td>at Jaguars</td>\n",
       "      <td>-6.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>-210</td>\n",
       "      <td>+175</td>\n",
       "      <td>2016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1744</th>\n",
       "      <td>December 4, 2022 4:05 PM</td>\n",
       "      <td>at 49ers</td>\n",
       "      <td>Dolphins</td>\n",
       "      <td>-4.5</td>\n",
       "      <td>45.5</td>\n",
       "      <td>+180</td>\n",
       "      <td>-217</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1745</th>\n",
       "      <td>December 4, 2022 4:25 PM</td>\n",
       "      <td>Chiefs</td>\n",
       "      <td>at Bengals</td>\n",
       "      <td>-2.0</td>\n",
       "      <td>52.5</td>\n",
       "      <td>-134</td>\n",
       "      <td>+113</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1746</th>\n",
       "      <td>December 4, 2022 4:25 PM</td>\n",
       "      <td>at Raiders</td>\n",
       "      <td>Chargers</td>\n",
       "      <td>-2.5</td>\n",
       "      <td>49.5</td>\n",
       "      <td>+115</td>\n",
       "      <td>-136</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1747</th>\n",
       "      <td>December 4, 2022 8:20 PM</td>\n",
       "      <td>at Cowboys</td>\n",
       "      <td>Colts</td>\n",
       "      <td>-10.5</td>\n",
       "      <td>44.0</td>\n",
       "      <td>+394</td>\n",
       "      <td>-513</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1748</th>\n",
       "      <td>December 5, 2022 8:15 PM</td>\n",
       "      <td>at Buccaneers</td>\n",
       "      <td>Saints</td>\n",
       "      <td>-3.5</td>\n",
       "      <td>40.5</td>\n",
       "      <td>+162</td>\n",
       "      <td>-193</td>\n",
       "      <td>2022</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1749 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                            Date       Favorite    UnderDog PointSpread  \\\n",
       "0      September 8, 2016 8:30 PM       Panthers  at Broncos        -3.0   \n",
       "1     September 11, 2016 1:00 PM      at Texans       Bears        -6.0   \n",
       "2     September 11, 2016 1:00 PM        Bengals     at Jets        -3.0   \n",
       "3     September 11, 2016 1:00 PM      at Eagles      Browns        -4.0   \n",
       "4     September 11, 2016 1:00 PM        Packers  at Jaguars        -6.0   \n",
       "...                          ...            ...         ...         ...   \n",
       "1744    December 4, 2022 4:05 PM       at 49ers    Dolphins        -4.5   \n",
       "1745    December 4, 2022 4:25 PM         Chiefs  at Bengals        -2.0   \n",
       "1746    December 4, 2022 4:25 PM     at Raiders    Chargers        -2.5   \n",
       "1747    December 4, 2022 8:20 PM     at Cowboys       Colts       -10.5   \n",
       "1748    December 5, 2022 8:15 PM  at Buccaneers      Saints        -3.5   \n",
       "\n",
       "     OverUnder AwayTeamMoneyLine HomeTeamMoneyLine  Season  \n",
       "0         41.0              -165              +145    2016  \n",
       "1         42.5              +220              -260    2016  \n",
       "2         42.0              -115              -105    2016  \n",
       "3         41.5              +165              -190    2016  \n",
       "4         48.0              -210              +175    2016  \n",
       "...        ...               ...               ...     ...  \n",
       "1744      45.5              +180              -217    2022  \n",
       "1745      52.5              -134              +113    2022  \n",
       "1746      49.5              +115              -136    2022  \n",
       "1747      44.0              +394              -513    2022  \n",
       "1748      40.5              +162              -193    2022  \n",
       "\n",
       "[1749 rows x 8 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "full_odds"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "275c7849",
   "metadata": {},
   "outputs": [],
   "source": [
    "full_odds['home_team'] = np.where(full_odds['Favorite'].str[:2]==\"at\",full_odds['Favorite'].str[3:],full_odds['UnderDog'].str[3:])\n",
    "full_odds['away_team'] = np.where(full_odds['Favorite'].str[:2]==\"at\",full_odds['UnderDog'],full_odds['Favorite'])\n",
    "full_odds['home_fav'] = np.where(full_odds['Favorite'].str[:2]==\"at\",True,False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "64fe1035",
   "metadata": {},
   "outputs": [],
   "source": [
    "full_odds['date_match'] = pd.to_datetime(full_odds['Date']).dt.normalize()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "099fe608",
   "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>Date</th>\n",
       "      <th>Favorite</th>\n",
       "      <th>UnderDog</th>\n",
       "      <th>PointSpread</th>\n",
       "      <th>OverUnder</th>\n",
       "      <th>AwayTeamMoneyLine</th>\n",
       "      <th>HomeTeamMoneyLine</th>\n",
       "      <th>Season</th>\n",
       "      <th>home_team</th>\n",
       "      <th>away_team</th>\n",
       "      <th>home_fav</th>\n",
       "      <th>date_match</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>September 8, 2016 8:30 PM</td>\n",
       "      <td>Panthers</td>\n",
       "      <td>at Broncos</td>\n",
       "      <td>-3.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>-165</td>\n",
       "      <td>+145</td>\n",
       "      <td>2016</td>\n",
       "      <td>Broncos</td>\n",
       "      <td>Panthers</td>\n",
       "      <td>False</td>\n",
       "      <td>2016-09-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>September 11, 2016 1:00 PM</td>\n",
       "      <td>at Texans</td>\n",
       "      <td>Bears</td>\n",
       "      <td>-6.0</td>\n",
       "      <td>42.5</td>\n",
       "      <td>+220</td>\n",
       "      <td>-260</td>\n",
       "      <td>2016</td>\n",
       "      <td>Texans</td>\n",
       "      <td>Bears</td>\n",
       "      <td>True</td>\n",
       "      <td>2016-09-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>September 11, 2016 1:00 PM</td>\n",
       "      <td>Bengals</td>\n",
       "      <td>at Jets</td>\n",
       "      <td>-3.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>-115</td>\n",
       "      <td>-105</td>\n",
       "      <td>2016</td>\n",
       "      <td>Jets</td>\n",
       "      <td>Bengals</td>\n",
       "      <td>False</td>\n",
       "      <td>2016-09-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>September 11, 2016 1:00 PM</td>\n",
       "      <td>at Eagles</td>\n",
       "      <td>Browns</td>\n",
       "      <td>-4.0</td>\n",
       "      <td>41.5</td>\n",
       "      <td>+165</td>\n",
       "      <td>-190</td>\n",
       "      <td>2016</td>\n",
       "      <td>Eagles</td>\n",
       "      <td>Browns</td>\n",
       "      <td>True</td>\n",
       "      <td>2016-09-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>September 11, 2016 1:00 PM</td>\n",
       "      <td>Packers</td>\n",
       "      <td>at Jaguars</td>\n",
       "      <td>-6.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>-210</td>\n",
       "      <td>+175</td>\n",
       "      <td>2016</td>\n",
       "      <td>Jaguars</td>\n",
       "      <td>Packers</td>\n",
       "      <td>False</td>\n",
       "      <td>2016-09-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1744</th>\n",
       "      <td>December 4, 2022 4:05 PM</td>\n",
       "      <td>at 49ers</td>\n",
       "      <td>Dolphins</td>\n",
       "      <td>-4.5</td>\n",
       "      <td>45.5</td>\n",
       "      <td>+180</td>\n",
       "      <td>-217</td>\n",
       "      <td>2022</td>\n",
       "      <td>49ers</td>\n",
       "      <td>Dolphins</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-12-04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1745</th>\n",
       "      <td>December 4, 2022 4:25 PM</td>\n",
       "      <td>Chiefs</td>\n",
       "      <td>at Bengals</td>\n",
       "      <td>-2.0</td>\n",
       "      <td>52.5</td>\n",
       "      <td>-134</td>\n",
       "      <td>+113</td>\n",
       "      <td>2022</td>\n",
       "      <td>Bengals</td>\n",
       "      <td>Chiefs</td>\n",
       "      <td>False</td>\n",
       "      <td>2022-12-04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1746</th>\n",
       "      <td>December 4, 2022 4:25 PM</td>\n",
       "      <td>at Raiders</td>\n",
       "      <td>Chargers</td>\n",
       "      <td>-2.5</td>\n",
       "      <td>49.5</td>\n",
       "      <td>+115</td>\n",
       "      <td>-136</td>\n",
       "      <td>2022</td>\n",
       "      <td>Raiders</td>\n",
       "      <td>Chargers</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-12-04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1747</th>\n",
       "      <td>December 4, 2022 8:20 PM</td>\n",
       "      <td>at Cowboys</td>\n",
       "      <td>Colts</td>\n",
       "      <td>-10.5</td>\n",
       "      <td>44.0</td>\n",
       "      <td>+394</td>\n",
       "      <td>-513</td>\n",
       "      <td>2022</td>\n",
       "      <td>Cowboys</td>\n",
       "      <td>Colts</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-12-04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1748</th>\n",
       "      <td>December 5, 2022 8:15 PM</td>\n",
       "      <td>at Buccaneers</td>\n",
       "      <td>Saints</td>\n",
       "      <td>-3.5</td>\n",
       "      <td>40.5</td>\n",
       "      <td>+162</td>\n",
       "      <td>-193</td>\n",
       "      <td>2022</td>\n",
       "      <td>Buccaneers</td>\n",
       "      <td>Saints</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-12-05</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1749 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                            Date       Favorite    UnderDog PointSpread  \\\n",
       "0      September 8, 2016 8:30 PM       Panthers  at Broncos        -3.0   \n",
       "1     September 11, 2016 1:00 PM      at Texans       Bears        -6.0   \n",
       "2     September 11, 2016 1:00 PM        Bengals     at Jets        -3.0   \n",
       "3     September 11, 2016 1:00 PM      at Eagles      Browns        -4.0   \n",
       "4     September 11, 2016 1:00 PM        Packers  at Jaguars        -6.0   \n",
       "...                          ...            ...         ...         ...   \n",
       "1744    December 4, 2022 4:05 PM       at 49ers    Dolphins        -4.5   \n",
       "1745    December 4, 2022 4:25 PM         Chiefs  at Bengals        -2.0   \n",
       "1746    December 4, 2022 4:25 PM     at Raiders    Chargers        -2.5   \n",
       "1747    December 4, 2022 8:20 PM     at Cowboys       Colts       -10.5   \n",
       "1748    December 5, 2022 8:15 PM  at Buccaneers      Saints        -3.5   \n",
       "\n",
       "     OverUnder AwayTeamMoneyLine HomeTeamMoneyLine  Season   home_team  \\\n",
       "0         41.0              -165              +145    2016     Broncos   \n",
       "1         42.5              +220              -260    2016      Texans   \n",
       "2         42.0              -115              -105    2016        Jets   \n",
       "3         41.5              +165              -190    2016      Eagles   \n",
       "4         48.0              -210              +175    2016     Jaguars   \n",
       "...        ...               ...               ...     ...         ...   \n",
       "1744      45.5              +180              -217    2022       49ers   \n",
       "1745      52.5              -134              +113    2022     Bengals   \n",
       "1746      49.5              +115              -136    2022     Raiders   \n",
       "1747      44.0              +394              -513    2022     Cowboys   \n",
       "1748      40.5              +162              -193    2022  Buccaneers   \n",
       "\n",
       "     away_team  home_fav date_match  \n",
       "0     Panthers     False 2016-09-08  \n",
       "1        Bears      True 2016-09-11  \n",
       "2      Bengals     False 2016-09-11  \n",
       "3       Browns      True 2016-09-11  \n",
       "4      Packers     False 2016-09-11  \n",
       "...        ...       ...        ...  \n",
       "1744  Dolphins      True 2022-12-04  \n",
       "1745    Chiefs     False 2022-12-04  \n",
       "1746  Chargers      True 2022-12-04  \n",
       "1747     Colts      True 2022-12-04  \n",
       "1748    Saints      True 2022-12-05  \n",
       "\n",
       "[1749 rows x 12 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "full_odds"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "2ba399d4",
   "metadata": {},
   "outputs": [],
   "source": [
    "names_key = ['Broncos', 'Texans', 'Jets', 'Eagles', 'Jaguars', 'Chiefs',\n",
    "       'Saints', 'Titans', 'Ravens', 'Falcons', 'Seahawks', 'Colts',\n",
    "       'Cowboys', 'Cardinals', 'Commanders', '49ers', 'Buccaneers',\n",
    "       'Panthers', 'Chargers', 'Steelers', 'Patriots', 'Giants',\n",
    "       'Lions', 'Vikings', 'Bengals', 'Browns', 'Rams', 'Raiders',\n",
    "       'Dolphins', 'Bears', 'Bills', 'Packers']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "8506de04",
   "metadata": {},
   "outputs": [],
   "source": [
    "abbr_val = ['DEN','HOU','NYJ','PHI','JAX','KC','NO','TEN','BAL','ATL','SEA','IND','DAL','ARI','WAS','SF','TB','CAR','LAC',\n",
    "           'PIT','NE','NYG','DET','MIN','CIN','CLE','LAR','LV','MIA','CHI','BUF','GB',]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "556a1385",
   "metadata": {},
   "outputs": [],
   "source": [
    "odds_to_abbr_map = {names_key[i]:abbr_val[i] for i in range(len(names_key))}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "85cefcb4",
   "metadata": {},
   "outputs": [],
   "source": [
    "full_odds['home_abbr'] = full_odds['home_team'].map(odds_to_abbr_map)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "9ad01e07",
   "metadata": {},
   "outputs": [],
   "source": [
    "full_odds['away_abbr'] = full_odds['away_team'].map(odds_to_abbr_map)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "592e6cc9",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Date                 November 1, 2020 4:05 PM\n",
       "Favorite                             Chargers\n",
       "UnderDog                           at Broncos\n",
       "PointSpread                              -3.0\n",
       "OverUnder                                44.0\n",
       "AwayTeamMoneyLine                        -178\n",
       "HomeTeamMoneyLine                        +147\n",
       "Season                                   2020\n",
       "home_team                             Broncos\n",
       "away_team                            Chargers\n",
       "home_fav                                False\n",
       "date_match                2020-11-01 00:00:00\n",
       "home_abbr                                 DEN\n",
       "away_abbr                                 LAC\n",
       "Name: 1263, dtype: object"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "full_odds.iloc[1263]\n",
    "#.map(odds_to_abbr_map)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "93e3c0db",
   "metadata": {},
   "outputs": [],
   "source": [
    "full_odds['AwayTeamMoneyLine'] = pd.to_numeric(full_odds.AwayTeamMoneyLine)\n",
    "full_odds['HomeTeamMoneyLine'] = pd.to_numeric(full_odds.HomeTeamMoneyLine)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "ba1fff90",
   "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>Date</th>\n",
       "      <th>Favorite</th>\n",
       "      <th>UnderDog</th>\n",
       "      <th>PointSpread</th>\n",
       "      <th>OverUnder</th>\n",
       "      <th>AwayTeamMoneyLine</th>\n",
       "      <th>HomeTeamMoneyLine</th>\n",
       "      <th>Season</th>\n",
       "      <th>home_team</th>\n",
       "      <th>away_team</th>\n",
       "      <th>home_fav</th>\n",
       "      <th>date_match</th>\n",
       "      <th>home_abbr</th>\n",
       "      <th>away_abbr</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>September 8, 2016 8:30 PM</td>\n",
       "      <td>Panthers</td>\n",
       "      <td>at Broncos</td>\n",
       "      <td>-3.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>-165</td>\n",
       "      <td>145</td>\n",
       "      <td>2016</td>\n",
       "      <td>Broncos</td>\n",
       "      <td>Panthers</td>\n",
       "      <td>False</td>\n",
       "      <td>2016-09-08</td>\n",
       "      <td>DEN</td>\n",
       "      <td>CAR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>September 11, 2016 1:00 PM</td>\n",
       "      <td>at Texans</td>\n",
       "      <td>Bears</td>\n",
       "      <td>-6.0</td>\n",
       "      <td>42.5</td>\n",
       "      <td>220</td>\n",
       "      <td>-260</td>\n",
       "      <td>2016</td>\n",
       "      <td>Texans</td>\n",
       "      <td>Bears</td>\n",
       "      <td>True</td>\n",
       "      <td>2016-09-11</td>\n",
       "      <td>HOU</td>\n",
       "      <td>CHI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>September 11, 2016 1:00 PM</td>\n",
       "      <td>Bengals</td>\n",
       "      <td>at Jets</td>\n",
       "      <td>-3.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>-115</td>\n",
       "      <td>-105</td>\n",
       "      <td>2016</td>\n",
       "      <td>Jets</td>\n",
       "      <td>Bengals</td>\n",
       "      <td>False</td>\n",
       "      <td>2016-09-11</td>\n",
       "      <td>NYJ</td>\n",
       "      <td>CIN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>September 11, 2016 1:00 PM</td>\n",
       "      <td>at Eagles</td>\n",
       "      <td>Browns</td>\n",
       "      <td>-4.0</td>\n",
       "      <td>41.5</td>\n",
       "      <td>165</td>\n",
       "      <td>-190</td>\n",
       "      <td>2016</td>\n",
       "      <td>Eagles</td>\n",
       "      <td>Browns</td>\n",
       "      <td>True</td>\n",
       "      <td>2016-09-11</td>\n",
       "      <td>PHI</td>\n",
       "      <td>CLE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>September 11, 2016 1:00 PM</td>\n",
       "      <td>Packers</td>\n",
       "      <td>at Jaguars</td>\n",
       "      <td>-6.0</td>\n",
       "      <td>48.0</td>\n",
       "      <td>-210</td>\n",
       "      <td>175</td>\n",
       "      <td>2016</td>\n",
       "      <td>Jaguars</td>\n",
       "      <td>Packers</td>\n",
       "      <td>False</td>\n",
       "      <td>2016-09-11</td>\n",
       "      <td>JAX</td>\n",
       "      <td>GB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1744</th>\n",
       "      <td>December 4, 2022 4:05 PM</td>\n",
       "      <td>at 49ers</td>\n",
       "      <td>Dolphins</td>\n",
       "      <td>-4.5</td>\n",
       "      <td>45.5</td>\n",
       "      <td>180</td>\n",
       "      <td>-217</td>\n",
       "      <td>2022</td>\n",
       "      <td>49ers</td>\n",
       "      <td>Dolphins</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-12-04</td>\n",
       "      <td>SF</td>\n",
       "      <td>MIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1745</th>\n",
       "      <td>December 4, 2022 4:25 PM</td>\n",
       "      <td>Chiefs</td>\n",
       "      <td>at Bengals</td>\n",
       "      <td>-2.0</td>\n",
       "      <td>52.5</td>\n",
       "      <td>-134</td>\n",
       "      <td>113</td>\n",
       "      <td>2022</td>\n",
       "      <td>Bengals</td>\n",
       "      <td>Chiefs</td>\n",
       "      <td>False</td>\n",
       "      <td>2022-12-04</td>\n",
       "      <td>CIN</td>\n",
       "      <td>KC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1746</th>\n",
       "      <td>December 4, 2022 4:25 PM</td>\n",
       "      <td>at Raiders</td>\n",
       "      <td>Chargers</td>\n",
       "      <td>-2.5</td>\n",
       "      <td>49.5</td>\n",
       "      <td>115</td>\n",
       "      <td>-136</td>\n",
       "      <td>2022</td>\n",
       "      <td>Raiders</td>\n",
       "      <td>Chargers</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-12-04</td>\n",
       "      <td>LV</td>\n",
       "      <td>LAC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1747</th>\n",
       "      <td>December 4, 2022 8:20 PM</td>\n",
       "      <td>at Cowboys</td>\n",
       "      <td>Colts</td>\n",
       "      <td>-10.5</td>\n",
       "      <td>44.0</td>\n",
       "      <td>394</td>\n",
       "      <td>-513</td>\n",
       "      <td>2022</td>\n",
       "      <td>Cowboys</td>\n",
       "      <td>Colts</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-12-04</td>\n",
       "      <td>DAL</td>\n",
       "      <td>IND</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1748</th>\n",
       "      <td>December 5, 2022 8:15 PM</td>\n",
       "      <td>at Buccaneers</td>\n",
       "      <td>Saints</td>\n",
       "      <td>-3.5</td>\n",
       "      <td>40.5</td>\n",
       "      <td>162</td>\n",
       "      <td>-193</td>\n",
       "      <td>2022</td>\n",
       "      <td>Buccaneers</td>\n",
       "      <td>Saints</td>\n",
       "      <td>True</td>\n",
       "      <td>2022-12-05</td>\n",
       "      <td>TB</td>\n",
       "      <td>NO</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1749 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                            Date       Favorite    UnderDog PointSpread  \\\n",
       "0      September 8, 2016 8:30 PM       Panthers  at Broncos        -3.0   \n",
       "1     September 11, 2016 1:00 PM      at Texans       Bears        -6.0   \n",
       "2     September 11, 2016 1:00 PM        Bengals     at Jets        -3.0   \n",
       "3     September 11, 2016 1:00 PM      at Eagles      Browns        -4.0   \n",
       "4     September 11, 2016 1:00 PM        Packers  at Jaguars        -6.0   \n",
       "...                          ...            ...         ...         ...   \n",
       "1744    December 4, 2022 4:05 PM       at 49ers    Dolphins        -4.5   \n",
       "1745    December 4, 2022 4:25 PM         Chiefs  at Bengals        -2.0   \n",
       "1746    December 4, 2022 4:25 PM     at Raiders    Chargers        -2.5   \n",
       "1747    December 4, 2022 8:20 PM     at Cowboys       Colts       -10.5   \n",
       "1748    December 5, 2022 8:15 PM  at Buccaneers      Saints        -3.5   \n",
       "\n",
       "     OverUnder  AwayTeamMoneyLine  HomeTeamMoneyLine  Season   home_team  \\\n",
       "0         41.0               -165                145    2016     Broncos   \n",
       "1         42.5                220               -260    2016      Texans   \n",
       "2         42.0               -115               -105    2016        Jets   \n",
       "3         41.5                165               -190    2016      Eagles   \n",
       "4         48.0               -210                175    2016     Jaguars   \n",
       "...        ...                ...                ...     ...         ...   \n",
       "1744      45.5                180               -217    2022       49ers   \n",
       "1745      52.5               -134                113    2022     Bengals   \n",
       "1746      49.5                115               -136    2022     Raiders   \n",
       "1747      44.0                394               -513    2022     Cowboys   \n",
       "1748      40.5                162               -193    2022  Buccaneers   \n",
       "\n",
       "     away_team  home_fav date_match home_abbr away_abbr  \n",
       "0     Panthers     False 2016-09-08       DEN       CAR  \n",
       "1        Bears      True 2016-09-11       HOU       CHI  \n",
       "2      Bengals     False 2016-09-11       NYJ       CIN  \n",
       "3       Browns      True 2016-09-11       PHI       CLE  \n",
       "4      Packers     False 2016-09-11       JAX        GB  \n",
       "...        ...       ...        ...       ...       ...  \n",
       "1744  Dolphins      True 2022-12-04        SF       MIA  \n",
       "1745    Chiefs     False 2022-12-04       CIN        KC  \n",
       "1746  Chargers      True 2022-12-04        LV       LAC  \n",
       "1747     Colts      True 2022-12-04       DAL       IND  \n",
       "1748    Saints      True 2022-12-05        TB        NO  \n",
       "\n",
       "[1749 rows x 14 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "full_odds"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "a94e76c1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Season\n",
       "2016    256\n",
       "2017    257\n",
       "2018    256\n",
       "2019    256\n",
       "2020    257\n",
       "2021    272\n",
       "2022    195\n",
       "Name: Season, dtype: int64"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "full_odds.groupby(['Season'])['Season'].count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "efb8f962",
   "metadata": {},
   "outputs": [],
   "source": [
    "full_odds.to_csv('data/odds_final.csv')"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}