gatherdata.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "from pybaseball import playerid_reverse_lookup\n",
    "from pybaseball import batting_stats_range\n",
    "from pybaseball import pitching_stats_range\n",
    "from pybaseball import batting_stats_bref\n",
    "import statsapi\n",
    "import pandas as pd\n",
    "from datetime import date,timedelta\n",
    "from fuzzywuzzy import process, fuzz\n",
    "from pybaseball import cache\n",
    "from IPython.display import display\n",
    "from dateutil import parser\n",
    "import fangraphs_db as fg\n",
    "\n",
    "cache.enable()\n",
    "# cache.config.cache_type='csv'\n",
    "# cache.config.save()\n",
    "\n",
    "######################################## defintions ##############################################\n",
    "\n",
    "def get_team_ids(abrv):\n",
    "    #lookup teams with abbreviation from input\n",
    "    teams = statsapi.lookup_team(abrv)\n",
    "    \n",
    "    #gather team ids from query\n",
    "    team_ids = []\n",
    "    for id_ in teams:\n",
    "        team_ids.append(id_['id'])\n",
    "    \n",
    "    return team_ids\n",
    "\n",
    "def calc_ops(AB,H,BB,HBP,TB,SF):\n",
    "    try:\n",
    "        OPS = (AB*(H+BB+HBP) + TB*(AB+BB+SF+HBP) )/(AB*(AB+BB+SF+HBP))\n",
    "    except:\n",
    "        OPS = 999\n",
    "    return OPS\n",
    "\n",
    "def calc_TB(H,twoB,threeB,HR):\n",
    "    oneB = H - (twoB+threeB+HR)\n",
    "    TB = (oneB) + (2*twoB) + (3*threeB) + (4*HR)\n",
    "    return TB\n",
    "\n",
    "\n",
    "def eat_pitcher_puke_ERA(pitcher,pitching_range):\n",
    "    # calculate pitcher ERA\n",
    "    ERA = 0\n",
    "    total_pitchers = pitching_range['Name'].tolist()\n",
    "    try:\n",
    "        \n",
    "#         print(pitching_range[pitching_range.Name==pitcher].GS.values[0])\n",
    "        if pitching_range[pitching_range.Name==pitcher].GS.values[0]<1:\n",
    "            print(pitcher +' has not played any games in x days')\n",
    "#             print(pitching_range[pitching_range.Name==pitcher].GS.values[0])\n",
    "            ERA = 999\n",
    "            GS = pitching_range[pitching_range.Name==pitcher].GS.values[0]\n",
    "\n",
    "        else:    \n",
    "            ERA = pitching_range[pitching_range.Name==pitcher].ERA.values[0]\n",
    "            GS = pitching_range[pitching_range.Name==pitcher].GS.values[0]\n",
    "\n",
    "\n",
    "    except:\n",
    "        print(pitcher + ' was not found')\n",
    "        \n",
    "        # use fuzzy library to find closest name match.\n",
    "        # if closest match score is greater than 80, then use that name\n",
    "        \n",
    "        closest_match = process.extract(pitcher,total_pitchers,scorer=fuzz.token_sort_ratio)\n",
    "        if closest_match[0][1] > 80:\n",
    "            print('Using closest match: ' + closest_match[0][0])\n",
    "            pitcher = closest_match[0][0]\n",
    "            \n",
    "\n",
    "#             print(pitching_range[pitching_range.Name==pitcher].GS.values[0])\n",
    "            if pitching_range[pitching_range.Name==pitcher].GS.values[0]<1:\n",
    "                print('Player has not played any games in x days')\n",
    "                ERA = 999\n",
    "                GS = 0\n",
    "\n",
    "            else:    \n",
    "                ERA = pitching_range[pitching_range.Name==pitcher].ERA.values[0]\n",
    "                GS = pitching_range[pitching_range.Name==pitcher].GS.values[0]\n",
    "\n",
    "        else:\n",
    "            print('No closest match found')\n",
    "            ERA = 999\n",
    "            GS = 0\n",
    "\n",
    "    \n",
    "    \n",
    "    return ERA,GS\n",
    "    \n",
    "\n",
    "    \n",
    "def eat_pitcher_puke_adv(pitcher,pitching_range):\n",
    "    # calculate pitcher ERA\n",
    "    ERA = 0\n",
    "    try:\n",
    "        \n",
    "#         print(pitching_range[pitching_range.Name==pitcher].GS.values[0])\n",
    "        if pitching_range[pitching_range.Name==pitcher].GS.values[0]<1:\n",
    "            print(pitcher +' has not played any games in x days')\n",
    "#             print(pitching_range[pitching_range.Name==pitcher].GS.values[0])\n",
    "            FIP = 999\n",
    "            xFIP = 999\n",
    "\n",
    "        else:    \n",
    "            FIP = pitching_range[pitching_range.Name==pitcher].FIP.values[0]\n",
    "            xFIP = pitching_range[pitching_range.Name==pitcher].xFIP.values[0]\n",
    "\n",
    "\n",
    "    except:\n",
    "        print(pitcher + ' was not found')\n",
    "        \n",
    "        # use fuzzy library to find closest name match.\n",
    "        # if closest match score is greater than 80, then use that name\n",
    "        \n",
    "        closest_match = process.extract(pitcher,total_pitchers,scorer=fuzz.token_sort_ratio)\n",
    "        if closest_match[0][1] > 80:\n",
    "            print('Using closest match: ' + closest_match[0][0])\n",
    "            pitcher = closest_match[0][0]\n",
    "            \n",
    "\n",
    "#             print(pitching_range[pitching_range.Name==pitcher].GS.values[0])\n",
    "            if pitching_range[pitching_range.Name==pitcher].GS.values[0]<1:\n",
    "                print('Player has not played any games in x days')\n",
    "                FIP = 999\n",
    "                xFIP = 999\n",
    "\n",
    "            else:    \n",
    "                FIP = pitching_range[pitching_range.Name==pitcher].FIP.values[0]\n",
    "                xFIP = pitching_range[pitching_range.Name==pitcher].xFIP.values[0]\n",
    "\n",
    "        else:\n",
    "            print('No closest match found')\n",
    "            FIP = 999\n",
    "            xFIP = 999\n",
    "\n",
    "    \n",
    "    \n",
    "    return FIP,xFIP    \n",
    "    \n",
    "    \n",
    "def eat_pitcher_puke_5RA(pitcher,pitching_range):\n",
    "    # calculate pitcher ERA\n",
    "    ERA = 0\n",
    "    total_pitchers = pitching_range['Name'].tolist()\n",
    "    \n",
    "    try:\n",
    "        ER = pitching_range[pitching_range.Name==pitcher].ER.sum()\n",
    "        IP = pitching_range[pitching_range.Name==pitcher].IP.sum()\n",
    "        \n",
    "        if IP==0:\n",
    "            print(pitcher +' has not played any games in x days')\n",
    "            \n",
    "        ERA = (ER/IP)*5\n",
    "    except:\n",
    "        print(pitcher + ' was not found')\n",
    "        \n",
    "        # use fuzzy library to find closest name match.\n",
    "        # if closest match score is greater than 80, then use that name\n",
    "        \n",
    "        closest_match = process.extract(pitcher,total_pitchers,scorer=fuzz.token_sort_ratio)\n",
    "        if closest_match[0][1] > 80:\n",
    "            print('Using closest match: ' + closest_match[0][0])\n",
    "            pitcher = closest_match[0][0]\n",
    "            \n",
    "            ER = pitching_range[pitching_range.Name==pitcher].ER.sum()\n",
    "            IP = pitching_range[pitching_range.Name==pitcher].IP.sum()\n",
    "            \n",
    "            ERA = (ER/IP)*5\n",
    "        else:\n",
    "            print('No closest match found')\n",
    "            return\n",
    "        \n",
    "    return ERA\n",
    "        \n",
    "    \n",
    "\n",
    "def eat_lineup_puke_OPS(lineup,batting_range):\n",
    "    # calculate lineup OPS\n",
    "\n",
    "    total_players = batting_range['Name'].tolist()\n",
    "    \n",
    "    lineupABs = []\n",
    "    lineupHs = [] \n",
    "    lineupBBs = []\n",
    "    lineupHBPs = []\n",
    "    lineupTBs = []\n",
    "    lineupSFs = []\n",
    "\n",
    "\n",
    "    for player in lineup:\n",
    "        try:\n",
    "            lineupABs.append(batting_range[batting_range.Name==player].AB.values[0])\n",
    "            lineupHs.append(batting_range[batting_range.Name==player].H.values[0])\n",
    "            lineupBBs.append(batting_range[batting_range.Name==player].BB.values[0])\n",
    "            lineupHBPs.append(batting_range[batting_range.Name==player].HBP.values[0])\n",
    "\n",
    "\n",
    "            lineupSFs.append(batting_range[batting_range.Name==player].SF.values[0])\n",
    "\n",
    "            H = batting_range[batting_range.Name==player]['H'].values[0]\n",
    "            twoB = batting_range[batting_range.Name==player]['2B'].values[0]\n",
    "            threeB = batting_range[batting_range.Name==player]['3B'].values[0]\n",
    "            HRs = batting_range[batting_range.Name==player]['HR'].values[0]\n",
    "\n",
    "            lineupTBs.append(calc_TB(H,twoB,threeB,HRs))\n",
    "\n",
    "        except:\n",
    "            print('Batter ' + player + ' was not found')\n",
    "            \n",
    "            # use fuzzy library to find closest name match.\n",
    "            # if closest match score is greater than 80, then use that name\n",
    "            \n",
    "            closest_match = process.extract(player,total_players,scorer=fuzz.token_sort_ratio)\n",
    "            if closest_match[0][1] > 80:\n",
    "                print('Using closest match: ' + closest_match[0][0])\n",
    "                \n",
    "                player = closest_match[0][0]\n",
    "                \n",
    "                lineupABs.append(batting_range[batting_range.Name==player].AB.values[0])\n",
    "                lineupHs.append(batting_range[batting_range.Name==player].H.values[0])\n",
    "                lineupBBs.append(batting_range[batting_range.Name==player].BB.values[0])\n",
    "                lineupHBPs.append(batting_range[batting_range.Name==player].HBP.values[0])\n",
    "\n",
    "\n",
    "                lineupSFs.append(batting_range[batting_range.Name==player].SF.values[0])\n",
    "\n",
    "                H = batting_range[batting_range.Name==player]['H'].values[0]\n",
    "                twoB = batting_range[batting_range.Name==player]['2B'].values[0]\n",
    "                threeB = batting_range[batting_range.Name==player]['3B'].values[0]\n",
    "                HRs = batting_range[batting_range.Name==player]['HR'].values[0]\n",
    "\n",
    "                lineupTBs.append(calc_TB(H,twoB,threeB,HRs))\n",
    "            else:\n",
    "                print('No closest match found.')\n",
    "\n",
    "                \n",
    "                \n",
    "\n",
    "    OPS = calc_ops(sum(lineupABs),sum(lineupHs),sum(lineupBBs),sum(lineupHBPs),sum(lineupTBs),sum(lineupSFs))\n",
    "    \n",
    "    return OPS\n",
    "\n",
    "def eat_lineup_puke_wrcplus(lineup,batting_range):\n",
    "    # given a lineup, calculate the lineup's wRC+ by weighting each members plate appearances\n",
    "    \n",
    "    total_players = batting_range['Name'].tolist()\n",
    "    \n",
    "    lineupPAs = []\n",
    "    lineupWRCs = []\n",
    "\n",
    "\n",
    "    for player in lineup:\n",
    "        try:\n",
    "            lineupPAs.append(batting_range[batting_range.Name==player].PA.values[0])\n",
    "            lineupWRCs.append(batting_range[batting_range.Name==player].wRCplus.values[0])\n",
    "        except:\n",
    "            print('Batter ' + player + ' was not found')\n",
    "            \n",
    "            # use fuzzy library to find closest name match.\n",
    "            # if closest match score is greater than 80, then use that name\n",
    "            \n",
    "            closest_match = process.extract(player,total_players,scorer=fuzz.token_sort_ratio)\n",
    "            if closest_match[0][1] > 80:\n",
    "                print('Using closest match: ' + closest_match[0][0])\n",
    "                \n",
    "                player = closest_match[0][0]\n",
    "                \n",
    "                lineupPAs.append(batting_range[batting_range.Name==player].PA.values[0])\n",
    "                lineupWRCs.append(batting_range[batting_range.Name==player].wRCplus.values[0])\n",
    "            else:\n",
    "                print('No closest match found.')\n",
    "                \n",
    "                \n",
    "    wRCplus = calc_wRCplus(lineupPAs,lineupWRCs)\n",
    "                    \n",
    "    return wRCplus\n",
    "def calc_wRCplus(PAs,WRCs):\n",
    "    \n",
    "    wRCplus = sum(x * y for x, y in zip(WRCs, PAs)) / sum(PAs)\n",
    "    \n",
    "    \n",
    "    return wRCplus\n",
    "    \n",
    "    \n",
    "######################################## main code ##############################################\n",
    "\n",
    "def main(useDate,days,getdata,debug):\n",
    "    # inputs: days = just give how many days you want to go back to pull rolling averages\n",
    "    # outputs: prints home OPS and away OPS (rolling average last x days) for every game today\n",
    "    \n",
    "    \n",
    "    # todays_date = whatever date is in useDate\n",
    "    # yesterdays_date = one day before useDate\n",
    "    # last_x_days = \"days\" before todays date\n",
    "    \n",
    "    # get the game_ids for today's games\n",
    "    todays_date = useDate\n",
    "    yesterdays_date = todays_date - timedelta(days=1)\n",
    "    last_x_days = todays_date  - timedelta(days=days)\n",
    "    print(todays_date,yesterdays_date,last_x_days)\n",
    "    \n",
    "    todays_games = statsapi.schedule(start_date=todays_date,end_date=todays_date)\n",
    "    if debug==1:\n",
    "        print(todays_games)\n",
    "    \n",
    "    # get info from todays games. such as the h/a ids, and probable pitchers\n",
    "    \n",
    "    home_team_ids = []\n",
    "    away_team_ids = []\n",
    "    game_ids = []\n",
    "    home_probable_pitcher = []\n",
    "    away_probable_pitcher = []\n",
    "    \n",
    "\n",
    "    for game in todays_games:\n",
    "            if len(game['home_probable_pitcher'].split(' ')) < 2 and len(game['away_probable_pitcher'].split(' ')) < 2:\n",
    "                print('no probable pitchers for this game. skipping.')\n",
    "            else:\n",
    "                home_team_ids.append(game['home_id'])\n",
    "                away_team_ids.append(game['away_id'])\n",
    "                game_ids.append(game['game_id'])\n",
    "                home_probable_pitcher.append(game['home_probable_pitcher'])\n",
    "                away_probable_pitcher.append(game['away_probable_pitcher'])\n",
    "\n",
    "\n",
    "    home_OPS = []\n",
    "    away_OPS = []\n",
    "    home_wRCplus = []\n",
    "    away_wRCplus = []\n",
    "    home_pitcher_name = []\n",
    "    away_pitcher_name = []\n",
    "    home_ERA = []\n",
    "    away_ERA = []\n",
    "    home_FIP = []\n",
    "    away_FIP = []\n",
    "    home_xFIP = []\n",
    "    away_xFIP = []\n",
    "    home_pitcher_GS = []\n",
    "    away_pitcher_GS = []\n",
    "    home_team = []\n",
    "    away_team = []\n",
    "    game_dates = []\n",
    "    game_times = []\n",
    "    home_after_5 = []\n",
    "    away_after_5 = []\n",
    "    home_total_score = []\n",
    "    away_total_score = []\n",
    "    \n",
    "    \n",
    "    batting_range = batting_stats_range(last_x_days.isoformat(),yesterdays_date.isoformat())\n",
    "    pitching_range = pitching_stats_range(last_x_days.isoformat(),yesterdays_date.isoformat())\n",
    "    \n",
    "    #### need to add season options in this....###\n",
    "\n",
    "    batting_leaderboard = fg.download_leaderboard('https://www.fangraphs.com/leaders.aspx?'\n",
    "                                      'pos=all&stats=bat&lg=all&qual=0&type=8&season=2021&'\n",
    "                                      'month=1000&season1=2021&ind=0&startdate={start}&'\n",
    "                                      'enddate={stop}'.format(start=last_x_days.isoformat(),\n",
    "                                                              stop=yesterdays_date.isoformat()))\n",
    "        \n",
    "    fg_batting_range = fg.clean_file()\n",
    "    \n",
    "    fg_batting_range = fg_batting_range.dropna(subset=['wRCplus'])\n",
    "#     display(fg_batting_range)\n",
    "    \n",
    "    pitching_leaderboard = fg.download_leaderboard('https://www.fangraphs.com/leaders.aspx?'\n",
    "                                      'pos=all&stats=pit&lg=all&qual=0&type=8&season=2021&'\n",
    "                                      'month=1000&season1=2021&ind=0&startdate={start}&'\n",
    "                                      'enddate={stop}'.format(start=last_x_days.isoformat(),\n",
    "                                                              stop=yesterdays_date.isoformat()))\n",
    "    fg_pitching_range = fg.clean_file()\n",
    "    \n",
    "#     display(fg_pitching_range)\n",
    "    \n",
    "    # loop thru all games in game_ids and compile batting data for each lineup, and pitching data for each probable pitcher\n",
    "    i=0\n",
    "    for game_id in game_ids:\n",
    "        # Get lineups\n",
    "        test = statsapi.get('schedule',{'gamePk':game_id,'sportId':1,'hydrate':'lineups'})\n",
    "        \n",
    "        \n",
    "        \n",
    "        \n",
    "        # Get home and away team names\n",
    "        homeTeam = test['dates'][0]['games'][0]['teams']['home']['team']['name']\n",
    "        awayTeam = test['dates'][0]['games'][0]['teams']['away']['team']['name']\n",
    "        \n",
    "        dateOfGame = test['dates'][0]['date']\n",
    "        \n",
    "        timeOfGame = parser.parse(test['dates'][0]['games'][0]['gameDate']).time()\n",
    "        \n",
    "        \n",
    "        # Get players/player ids\n",
    "        awayPlayerIds = []\n",
    "        homePlayersIds = []\n",
    "\n",
    "        awayPlayersNames = []\n",
    "        homePlayersNames = []\n",
    "        try:\n",
    "            for player in test['dates'][0]['games'][0]['lineups']['homePlayers']:\n",
    "                homePlayersNames.append(player['fullName'])\n",
    "                homePlayersIds.append(player['id'])\n",
    "            for player in test['dates'][0]['games'][0]['lineups']['awayPlayers']:\n",
    "                awayPlayersNames.append(player['fullName'])\n",
    "                awayPlayerIds.append(player['id'])\n",
    "                \n",
    "\n",
    "           # get batting range for last 30 days\n",
    "\n",
    "            tHomeTeamOPS = eat_lineup_puke_OPS(homePlayersNames,batting_range)\n",
    "            tAwayTeamOPS = eat_lineup_puke_OPS(awayPlayersNames,batting_range)\n",
    "            \n",
    "            \n",
    "            # get wRC+ for last 30 days\n",
    "            tHomeTeamwRCPlus = eat_lineup_puke_wrcplus(homePlayersNames,fg_batting_range)\n",
    "            tAwayTeamwRCPlus = eat_lineup_puke_wrcplus(awayPlayersNames,fg_batting_range)\n",
    "\n",
    "            # get pitching stats from last 30 days\n",
    "            # get era\n",
    "\n",
    "            tHomeTeamERA,tHomeTeamGS = eat_pitcher_puke_ERA(home_probable_pitcher[i],pitching_range)\n",
    "            tAwayTeamERA,tAwayTeamGS = eat_pitcher_puke_ERA(away_probable_pitcher[i],pitching_range)\n",
    "            \n",
    "            # get adv stats (FIP and xFIP)\n",
    "            tHomeTeamFIP,tHomeTeamxFIP = eat_pitcher_puke_adv(home_probable_pitcher[i],fg_pitching_range)\n",
    "            tAwayTeamFIP,tAwayTeamxFIP = eat_pitcher_puke_adv(away_probable_pitcher[i],fg_pitching_range)\n",
    "            \n",
    "            # get scores from games if they have already happened\n",
    "\n",
    "            home_score = []\n",
    "            away_score = []\n",
    "            \n",
    "            if date.fromisoformat(dateOfGame) != date.today():\n",
    "                boxScore = statsapi.get('game_linescore',{'gamePk':game_id})\n",
    "                for inning in boxScore['innings']:\n",
    "                    if 'runs' in inning['home']:\n",
    "                        home_score.append(inning['home']['runs'])\n",
    "                    else:\n",
    "                        home_score.append(0)\n",
    "\n",
    "                    away_score.append(inning['away']['runs'])\n",
    "\n",
    "                home_after_5.append(sum(home_score[0:5]))\n",
    "                away_after_5.append(sum(away_score[0:5]))\n",
    "\n",
    "                home_total_score.append(sum(home_score))\n",
    "                away_total_score.append(sum(away_score))\n",
    "            else:\n",
    "                home_after_5.append('TBD')\n",
    "                away_after_5.append('TBD')\n",
    "                \n",
    "                home_total_score.append('TBD')\n",
    "                away_total_score.append('TBD')\n",
    "            \n",
    "            \n",
    "            # append to lists\n",
    "            home_OPS.append(tHomeTeamOPS)\n",
    "            away_OPS.append(tAwayTeamOPS)\n",
    "            \n",
    "            home_wRCplus.append(tHomeTeamwRCPlus)\n",
    "            away_wRCplus.append(tAwayTeamwRCPlus)\n",
    "\n",
    "            home_pitcher_name.append(home_probable_pitcher[i])\n",
    "            away_pitcher_name.append(away_probable_pitcher[i])\n",
    "            \n",
    "            home_ERA.append(tHomeTeamERA)\n",
    "            away_ERA.append(tAwayTeamERA)\n",
    "\n",
    "            home_FIP.append(tHomeTeamFIP)\n",
    "            away_FIP.append(tAwayTeamFIP)\n",
    "            \n",
    "            home_xFIP.append(tHomeTeamxFIP)\n",
    "            away_xFIP.append(tAwayTeamxFIP)\n",
    "            \n",
    "            home_pitcher_GS.append(tHomeTeamGS)\n",
    "            away_pitcher_GS.append(tAwayTeamGS)\n",
    "            \n",
    "            home_team.append(homeTeam)\n",
    "            away_team.append(awayTeam)\n",
    "            \n",
    "            game_dates.append(dateOfGame)\n",
    "            game_times.append(timeOfGame)\n",
    "            \n",
    "            \n",
    "            if debug==1:\n",
    "                print('{0} (Lineup {1} day OPS: {2})\\n@ {3} (Lineup {4} day OPS: {5})'.\n",
    "                     format(awayTeam,days,round(tAwayTeamOPS,3),homeTeam, days,round(tHomeTeamOPS,3)))\n",
    "                print('{0} Pitcher is {1}, their {2} day ERA is {3}.\\n@ {4} Pitcher is {5}, their {6} day ERA is {7}'.\n",
    "                     format(awayTeam,away_probable_pitcher[i],days,round(tAwayTeamERA,3),homeTeam,home_probable_pitcher[i],days,round(tHomeTeamERA,3)))\n",
    "\n",
    "        \n",
    "        \n",
    "        \n",
    "\n",
    "        \n",
    "            i+=1\n",
    "                \n",
    "                \n",
    "                \n",
    "        except:\n",
    "            print('error with '+awayTeam+'@'+homeTeam+'. Going to next game.')\n",
    "            i+=1\n",
    "        \n",
    "\n",
    "\n",
    "\n",
    "\n",
    "#     print(home_OPS)\n",
    "#     print(away_OPS)\n",
    "#     print(home_ERA)\n",
    "#     print(away_ERA)\n",
    "    \n",
    "    d = {'HomeTeam': home_team,'AwayTeam':away_team,'GameDate':game_dates,'GameTime':game_times,'HomeOPS':home_OPS,\n",
    "         'AwayOPS':away_OPS, 'HomewRCPlus':home_wRCplus,'AwaywRCPlus':away_wRCplus,\n",
    "         'HomePitcherName':home_pitcher_name,'HomeERA':home_ERA,'HomePitcherGS':home_pitcher_GS,\n",
    "         'AwayPitcherName':away_pitcher_name,'AwayERA':away_ERA,'AwayPitcherGS':away_pitcher_GS,\n",
    "         'HomeFIP':home_FIP,'AwayFIP':away_FIP,'HomexFIP':home_xFIP,'AwayxFIP':away_xFIP,\n",
    "         'HomeScoreAfter5':home_after_5,'AwayScoreAfter5':away_after_5,'HomeTotalScore':home_total_score,\n",
    "         'AwayTotalScore':away_total_score}\n",
    "    df = pd.DataFrame(data=d)\n",
    "        \n",
    "    return df    \n",
    "    \n",
    "    \n",
    "    \n",
    "# x = range(1,40,1)\n",
    "x = range(0,1,1)\n",
    "\n",
    "daterange = pd.date_range(start=\"2018-05-21\",end=\"2018-09-29\")\n",
    "# daterange = pd.date_range(start=\"2021-07-17\",end=\"2021-07-17\")\n",
    "k=0\n",
    "for d in daterange:\n",
    "    useDate = d.date()\n",
    "    print(useDate)\n",
    "    try:\n",
    "        df2 = main(useDate,30,1,0)\n",
    "        if k==0:\n",
    "            df = df2\n",
    "            k+=1\n",
    "        else:\n",
    "            df = df.append(df2,ignore_index=True)\n",
    "            k+=1\n",
    "        print(k)\n",
    "    except:\n",
    "        print('Error with ' + useDate.isoformat() + '. Going to next date.')\n",
    "        k+=1\n",
    "        print(k)\n",
    "\n",
    "display(df)    \n",
    "df.to_csv('C:/Users\\Justin\\Projects\\python_baseball_2021\\mlbdata_052118_092918_adv.csv',index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "scrolled": false
   },
   "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>datetime</th>\n",
       "      <th>event</th>\n",
       "      <th>market</th>\n",
       "      <th>result</th>\n",
       "      <th>profit</th>\n",
       "      <th>sportsbook</th>\n",
       "      <th>participant</th>\n",
       "      <th>market_id</th>\n",
       "      <th>event_id</th>\n",
       "      <th>spread_total</th>\n",
       "      <th>...</th>\n",
       "      <th>sportsbook_id</th>\n",
       "      <th>american_odds</th>\n",
       "      <th>decimal_odds</th>\n",
       "      <th>participant_score</th>\n",
       "      <th>sportsbook_alias</th>\n",
       "      <th>opening_spread_total</th>\n",
       "      <th>opening_american_odds</th>\n",
       "      <th>opening_decimal_odds</th>\n",
       "      <th>GameDate</th>\n",
       "      <th>GameTime</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>6676</th>\n",
       "      <td>2018-05-21T09:45:45-05:00</td>\n",
       "      <td>Baltimore@Chicago</td>\n",
       "      <td>1st Half - Point Spread</td>\n",
       "      <td>L</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>5Dimes</td>\n",
       "      <td>CWS</td>\n",
       "      <td>397</td>\n",
       "      <td>3387805</td>\n",
       "      <td>0.5</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>-150</td>\n",
       "      <td>1.67</td>\n",
       "      <td>2</td>\n",
       "      <td>Sportbet</td>\n",
       "      <td>6.5</td>\n",
       "      <td>-105</td>\n",
       "      <td>1.95</td>\n",
       "      <td>2018-05-21</td>\n",
       "      <td>09:45:45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6677</th>\n",
       "      <td>2018-05-21T09:45:45-05:00</td>\n",
       "      <td>Baltimore@Chicago</td>\n",
       "      <td>1st Half - Point Spread</td>\n",
       "      <td>W</td>\n",
       "      <td>130.0</td>\n",
       "      <td>5Dimes</td>\n",
       "      <td>BAL</td>\n",
       "      <td>397</td>\n",
       "      <td>3387805</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>130</td>\n",
       "      <td>2.3</td>\n",
       "      <td>3</td>\n",
       "      <td>Sportbet</td>\n",
       "      <td>6.5</td>\n",
       "      <td>-115</td>\n",
       "      <td>1.87</td>\n",
       "      <td>2018-05-21</td>\n",
       "      <td>09:45:45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8118</th>\n",
       "      <td>2018-05-21T09:45:54-05:00</td>\n",
       "      <td>Detroit@Minnesota</td>\n",
       "      <td>1st Half - Point Spread</td>\n",
       "      <td>W</td>\n",
       "      <td>69.0</td>\n",
       "      <td>5Dimes</td>\n",
       "      <td>MIN</td>\n",
       "      <td>397</td>\n",
       "      <td>3388173</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>-145</td>\n",
       "      <td>1.69</td>\n",
       "      <td>4</td>\n",
       "      <td>Sportbet</td>\n",
       "      <td>0</td>\n",
       "      <td>102</td>\n",
       "      <td>2.02</td>\n",
       "      <td>2018-05-21</td>\n",
       "      <td>09:45:54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8119</th>\n",
       "      <td>2018-05-21T09:45:54-05:00</td>\n",
       "      <td>Detroit@Minnesota</td>\n",
       "      <td>1st Half - Point Spread</td>\n",
       "      <td>L</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>5Dimes</td>\n",
       "      <td>DET</td>\n",
       "      <td>397</td>\n",
       "      <td>3388173</td>\n",
       "      <td>0.5</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>125</td>\n",
       "      <td>2.25</td>\n",
       "      <td>2</td>\n",
       "      <td>Sportbet</td>\n",
       "      <td>0</td>\n",
       "      <td>-117</td>\n",
       "      <td>1.85</td>\n",
       "      <td>2018-05-21</td>\n",
       "      <td>09:45:54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4194</th>\n",
       "      <td>2018-05-21T10:53:47-05:00</td>\n",
       "      <td>San Diego@Washington</td>\n",
       "      <td>1st Half - Point Spread</td>\n",
       "      <td>W</td>\n",
       "      <td>80.0</td>\n",
       "      <td>5Dimes</td>\n",
       "      <td>WSH</td>\n",
       "      <td>397</td>\n",
       "      <td>3387209</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>-125</td>\n",
       "      <td>1.8</td>\n",
       "      <td>10</td>\n",
       "      <td>Sportbet</td>\n",
       "      <td>0</td>\n",
       "      <td>-120</td>\n",
       "      <td>1.83</td>\n",
       "      <td>2018-05-21</td>\n",
       "      <td>10:53:47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1377</th>\n",
       "      <td>2018-09-28T17:47:45-05:00</td>\n",
       "      <td>New York@Boston</td>\n",
       "      <td>1st Half - Point Spread</td>\n",
       "      <td>W</td>\n",
       "      <td>91.0</td>\n",
       "      <td>5Dimes</td>\n",
       "      <td>NYY</td>\n",
       "      <td>397</td>\n",
       "      <td>3386528</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>-110</td>\n",
       "      <td>1.91</td>\n",
       "      <td>11</td>\n",
       "      <td>Sportbet</td>\n",
       "      <td>0.5</td>\n",
       "      <td>-125</td>\n",
       "      <td>1.8</td>\n",
       "      <td>2018-09-28</td>\n",
       "      <td>17:47:45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7890</th>\n",
       "      <td>2018-09-28T18:01:57-05:00</td>\n",
       "      <td>Washington@Colorado</td>\n",
       "      <td>1st Half - Point Spread</td>\n",
       "      <td>L</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>5Dimes</td>\n",
       "      <td>WSH</td>\n",
       "      <td>397</td>\n",
       "      <td>3388121</td>\n",
       "      <td>0.5</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>120</td>\n",
       "      <td>2.2</td>\n",
       "      <td>2</td>\n",
       "      <td>Sportbet</td>\n",
       "      <td>0</td>\n",
       "      <td>120</td>\n",
       "      <td>2.2</td>\n",
       "      <td>2018-09-28</td>\n",
       "      <td>18:01:57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7891</th>\n",
       "      <td>2018-09-28T18:01:57-05:00</td>\n",
       "      <td>Washington@Colorado</td>\n",
       "      <td>1st Half - Point Spread</td>\n",
       "      <td>W</td>\n",
       "      <td>71.0</td>\n",
       "      <td>5Dimes</td>\n",
       "      <td>COL</td>\n",
       "      <td>397</td>\n",
       "      <td>3388121</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>-140</td>\n",
       "      <td>1.71</td>\n",
       "      <td>5</td>\n",
       "      <td>Sportbet</td>\n",
       "      <td>0</td>\n",
       "      <td>-135</td>\n",
       "      <td>1.74</td>\n",
       "      <td>2018-09-28</td>\n",
       "      <td>18:01:57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7566</th>\n",
       "      <td>2018-09-28T21:06:01-05:00</td>\n",
       "      <td>Oakland@Los Angeles</td>\n",
       "      <td>1st Half - Point Spread</td>\n",
       "      <td>L</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>5Dimes</td>\n",
       "      <td>OAK</td>\n",
       "      <td>397</td>\n",
       "      <td>3388032</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>115</td>\n",
       "      <td>2.15</td>\n",
       "      <td>5</td>\n",
       "      <td>Sportbet</td>\n",
       "      <td>0</td>\n",
       "      <td>-125</td>\n",
       "      <td>1.8</td>\n",
       "      <td>2018-09-28</td>\n",
       "      <td>21:06:01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7567</th>\n",
       "      <td>2018-09-28T21:06:01-05:00</td>\n",
       "      <td>Oakland@Los Angeles</td>\n",
       "      <td>1st Half - Point Spread</td>\n",
       "      <td>W</td>\n",
       "      <td>74.0</td>\n",
       "      <td>5Dimes</td>\n",
       "      <td>LAA</td>\n",
       "      <td>397</td>\n",
       "      <td>3388032</td>\n",
       "      <td>0.5</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>-135</td>\n",
       "      <td>1.74</td>\n",
       "      <td>8</td>\n",
       "      <td>Sportbet</td>\n",
       "      <td>0</td>\n",
       "      <td>110</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2018-09-28</td>\n",
       "      <td>21:06:01</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3376 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                       datetime                 event  \\\n",
       "6676  2018-05-21T09:45:45-05:00     Baltimore@Chicago   \n",
       "6677  2018-05-21T09:45:45-05:00     Baltimore@Chicago   \n",
       "8118  2018-05-21T09:45:54-05:00     Detroit@Minnesota   \n",
       "8119  2018-05-21T09:45:54-05:00     Detroit@Minnesota   \n",
       "4194  2018-05-21T10:53:47-05:00  San Diego@Washington   \n",
       "...                         ...                   ...   \n",
       "1377  2018-09-28T17:47:45-05:00       New York@Boston   \n",
       "7890  2018-09-28T18:01:57-05:00   Washington@Colorado   \n",
       "7891  2018-09-28T18:01:57-05:00   Washington@Colorado   \n",
       "7566  2018-09-28T21:06:01-05:00   Oakland@Los Angeles   \n",
       "7567  2018-09-28T21:06:01-05:00   Oakland@Los Angeles   \n",
       "\n",
       "                       market result profit sportsbook participant market_id  \\\n",
       "6676  1st Half - Point Spread      L -100.0     5Dimes         CWS       397   \n",
       "6677  1st Half - Point Spread      W  130.0     5Dimes         BAL       397   \n",
       "8118  1st Half - Point Spread      W   69.0     5Dimes         MIN       397   \n",
       "8119  1st Half - Point Spread      L -100.0     5Dimes         DET       397   \n",
       "4194  1st Half - Point Spread      W   80.0     5Dimes         WSH       397   \n",
       "...                       ...    ...    ...        ...         ...       ...   \n",
       "1377  1st Half - Point Spread      W   91.0     5Dimes         NYY       397   \n",
       "7890  1st Half - Point Spread      L -100.0     5Dimes         WSH       397   \n",
       "7891  1st Half - Point Spread      W   71.0     5Dimes         COL       397   \n",
       "7566  1st Half - Point Spread      L -100.0     5Dimes         OAK       397   \n",
       "7567  1st Half - Point Spread      W   74.0     5Dimes         LAA       397   \n",
       "\n",
       "     event_id spread_total  ... sportsbook_id american_odds decimal_odds  \\\n",
       "6676  3387805          0.5  ...             3          -150         1.67   \n",
       "6677  3387805         -0.5  ...             3           130          2.3   \n",
       "8118  3388173         -0.5  ...             3          -145         1.69   \n",
       "8119  3388173          0.5  ...             3           125         2.25   \n",
       "4194  3387209         -0.5  ...             3          -125          1.8   \n",
       "...       ...          ...  ...           ...           ...          ...   \n",
       "1377  3386528         -0.5  ...             3          -110         1.91   \n",
       "7890  3388121          0.5  ...             3           120          2.2   \n",
       "7891  3388121         -0.5  ...             3          -140         1.71   \n",
       "7566  3388032         -0.5  ...             3           115         2.15   \n",
       "7567  3388032          0.5  ...             3          -135         1.74   \n",
       "\n",
       "     participant_score sportsbook_alias opening_spread_total  \\\n",
       "6676                 2         Sportbet                  6.5   \n",
       "6677                 3         Sportbet                  6.5   \n",
       "8118                 4         Sportbet                    0   \n",
       "8119                 2         Sportbet                    0   \n",
       "4194                10         Sportbet                    0   \n",
       "...                ...              ...                  ...   \n",
       "1377                11         Sportbet                  0.5   \n",
       "7890                 2         Sportbet                    0   \n",
       "7891                 5         Sportbet                    0   \n",
       "7566                 5         Sportbet                    0   \n",
       "7567                 8         Sportbet                    0   \n",
       "\n",
       "     opening_american_odds opening_decimal_odds    GameDate  GameTime  \n",
       "6676                  -105                 1.95  2018-05-21  09:45:45  \n",
       "6677                  -115                 1.87  2018-05-21  09:45:45  \n",
       "8118                   102                 2.02  2018-05-21  09:45:54  \n",
       "8119                  -117                 1.85  2018-05-21  09:45:54  \n",
       "4194                  -120                 1.83  2018-05-21  10:53:47  \n",
       "...                    ...                  ...         ...       ...  \n",
       "1377                  -125                  1.8  2018-09-28  17:47:45  \n",
       "7890                   120                  2.2  2018-09-28  18:01:57  \n",
       "7891                  -135                 1.74  2018-09-28  18:01:57  \n",
       "7566                  -125                  1.8  2018-09-28  21:06:01  \n",
       "7567                   110                  2.1  2018-09-28  21:06:01  \n",
       "\n",
       "[3376 rows x 22 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "### keep this ####\n",
    "\n",
    "from pybaseball import playerid_reverse_lookup\n",
    "from pybaseball import batting_stats_range\n",
    "from pybaseball import pitching_stats_range\n",
    "from pybaseball import batting_stats_bref\n",
    "import statsapi\n",
    "import pandas as pd\n",
    "from datetime import date,timedelta\n",
    "from fuzzywuzzy import process, fuzz\n",
    "from pybaseball import cache\n",
    "from IPython.display import display\n",
    "from dateutil import parser\n",
    "import fangraphs_db as fg\n",
    "import pandas as pd\n",
    "from datetime import date,timedelta,datetime\n",
    "from pysbr import *\n",
    "from collections import defaultdict\n",
    "\n",
    "def get_odds_by_date_range(start,stop):\n",
    "\n",
    "\n",
    "    start_dt = datetime.strptime(start, '%Y-%m-%d')\n",
    "    stop_dt = datetime.strptime(stop, '%Y-%m-%d')\n",
    "    \n",
    "    mlb = MLB()\n",
    "    sb = Sportsbook()\n",
    "\n",
    "#     print(mlb.sport_config())\n",
    "    \n",
    "    e = EventsByDateRange(mlb.league_id,start_dt,stop_dt)\n",
    "\n",
    "    e_ids = []\n",
    "    for i in range(1,len(e.list())):\n",
    "        if e.list()[i]['event status'] == 'complete':\n",
    "            e_ids.append(e.list()[i]['event id'])\n",
    "\n",
    "            \n",
    "    # get current lines        \n",
    "    cl = CurrentLines(e_ids,mlb.market_ids([397,398,725,91]),sb.ids(['5dimes']))\n",
    "    \n",
    "    # convert to dict\n",
    "    cl_d = Convert(cl.list(e))\n",
    "    \n",
    "    # change dict names to play nice with matlab\n",
    "    cl_d['market_id']               = cl_d.pop('market id')\n",
    "    cl_d['event_id']                = cl_d.pop('event id')\n",
    "    cl_d['spread_total']            = cl_d.pop('spread / total')\n",
    "    cl_d['participant_full_name']   = cl_d.pop('participant full name')\n",
    "    cl_d['participant_id']          = cl_d.pop('participant id')\n",
    "    cl_d['sportsbook_id']           = cl_d.pop('sportsbook id')\n",
    "    cl_d['american_odds']           = cl_d.pop('american odds')\n",
    "    cl_d['decimal_odds']            = cl_d.pop('decimal odds')\n",
    "    cl_d['participant_score']       = cl_d.pop('participant score')\n",
    "    cl_d['sportsbook_alias']        = cl_d.pop('sportsbook alias')\n",
    "\n",
    "    # get opening lines\n",
    "#     print(e_ids)\n",
    "    ol = OpeningLines(e_ids,mlb.market_ids([397,398,725,91]),sb.id(['5dimes']))\n",
    "    \n",
    "    # convert to dict\n",
    "    ol_d = Convert(ol.list(e))\n",
    "    \n",
    "    # change dict names to play nice with matlab\n",
    "    ol_d['market_id']               = ol_d.pop('market id')\n",
    "    ol_d['event_id']                = ol_d.pop('event id')\n",
    "    ol_d['opening_spread_total']    = ol_d.pop('spread / total')\n",
    "    ol_d['participant_full_name']   = ol_d.pop('participant full name')\n",
    "    ol_d['participant_id']          = ol_d.pop('participant id')\n",
    "    ol_d['sportsbook_id']           = ol_d.pop('sportsbook id')\n",
    "    ol_d['opening_american_odds']   = ol_d.pop('american odds')\n",
    "    ol_d['opening_decimal_odds']    = ol_d.pop('decimal odds')\n",
    "    ol_d['participant_score']       = ol_d.pop('participant score')\n",
    "    ol_d['sportsbook_alias']        = ol_d.pop('sportsbook alias')\n",
    "\n",
    "    # this is an unnecessary step but it was an easy fix to get it to play right in matlab\n",
    "    dfc = pd.DataFrame.from_dict(cl_d,orient='index')\n",
    "    dfc = dfc.transpose()\n",
    "    \n",
    "    dfo = pd.DataFrame.from_dict(ol_d,orient='index')\n",
    "    dfo = dfo.transpose()\n",
    "    \n",
    "    # combine opening and closing dataframes\n",
    "    new_df = pd.concat([dfc,dfo['opening_spread_total'],dfo['opening_american_odds'],dfo['opening_decimal_odds']],axis=1)\n",
    "    \n",
    "    return new_df\n",
    "\n",
    "def Convert(lst):\n",
    "\n",
    "    res = defaultdict(list)\n",
    "    {res[key].append(sub[key]) for sub in lst for key in sub}\n",
    "    \n",
    "    \n",
    "    return dict(res)\n",
    "\n",
    "df = get_odds_by_date_range('2018-05-21','2018-09-29')\n",
    "\n",
    "# first_5_pickem = df.loc[df['market_id']==91].sort_values(by=['datetime','event_id'])\n",
    "# first_5_pickem['GameDate'] = first_5_pickem['datetime'].apply(lambda x: parser.parse(x).date())\n",
    "# first_5_pickem['GameTime'] = first_5_pickem['datetime'].apply(lambda x: parser.parse(x).time())\n",
    "\n",
    "\n",
    "\n",
    "first_5_spread = df.loc[df['market_id']==397].sort_values(by=['datetime','event_id'])\n",
    "first_5_spread['GameDate'] = first_5_spread['datetime'].apply(lambda x: parser.parse(x).date())\n",
    "first_5_spread['GameTime'] = first_5_spread['datetime'].apply(lambda x: parser.parse(x).time())\n",
    "\n",
    "display(first_5_spread)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>datetime</th>\n",
       "      <th>event</th>\n",
       "      <th>market</th>\n",
       "      <th>result</th>\n",
       "      <th>profit</th>\n",
       "      <th>sportsbook</th>\n",
       "      <th>participant</th>\n",
       "      <th>market_id</th>\n",
       "      <th>event_id</th>\n",
       "      <th>...</th>\n",
       "      <th>participant_full_name</th>\n",
       "      <th>participant_id</th>\n",
       "      <th>sportsbook_id</th>\n",
       "      <th>american_odds</th>\n",
       "      <th>decimal_odds</th>\n",
       "      <th>participant_score</th>\n",
       "      <th>sportsbook_alias</th>\n",
       "      <th>opening_spread_total</th>\n",
       "      <th>opening_american_odds</th>\n",
       "      <th>opening_decimal_odds</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>5416</th>\n",
       "      <td>5416</td>\n",
       "      <td>2019-05-21T09:24:57-05:00</td>\n",
       "      <td>New York@Baltimore</td>\n",
       "      <td>1st Half - American Total</td>\n",
       "      <td>W</td>\n",
       "      <td>87.0</td>\n",
       "      <td>5Dimes</td>\n",
       "      <td>over</td>\n",
       "      <td>398</td>\n",
       "      <td>3729258</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15143</td>\n",
       "      <td>3</td>\n",
       "      <td>-115</td>\n",
       "      <td>1.87</td>\n",
       "      <td>12</td>\n",
       "      <td>Sportbet</td>\n",
       "      <td>5.0</td>\n",
       "      <td>-115</td>\n",
       "      <td>1.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5417</th>\n",
       "      <td>5417</td>\n",
       "      <td>2019-05-21T09:24:57-05:00</td>\n",
       "      <td>New York@Baltimore</td>\n",
       "      <td>1st Half - American Total</td>\n",
       "      <td>L</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>5Dimes</td>\n",
       "      <td>under</td>\n",
       "      <td>398</td>\n",
       "      <td>3729258</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15144</td>\n",
       "      <td>3</td>\n",
       "      <td>-105</td>\n",
       "      <td>1.95</td>\n",
       "      <td>12</td>\n",
       "      <td>Sportbet</td>\n",
       "      <td>5.0</td>\n",
       "      <td>-105</td>\n",
       "      <td>1.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5740</th>\n",
       "      <td>5740</td>\n",
       "      <td>2019-05-21T12:16:08-05:00</td>\n",
       "      <td>Los Angeles@Tampa Bay</td>\n",
       "      <td>1st Half - American Total</td>\n",
       "      <td>L</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>5Dimes</td>\n",
       "      <td>over</td>\n",
       "      <td>398</td>\n",
       "      <td>3729339</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15143</td>\n",
       "      <td>3</td>\n",
       "      <td>100</td>\n",
       "      <td>2.00</td>\n",
       "      <td>3</td>\n",
       "      <td>Sportbet</td>\n",
       "      <td>4.0</td>\n",
       "      <td>105</td>\n",
       "      <td>2.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5741</th>\n",
       "      <td>5741</td>\n",
       "      <td>2019-05-21T12:16:08-05:00</td>\n",
       "      <td>Los Angeles@Tampa Bay</td>\n",
       "      <td>1st Half - American Total</td>\n",
       "      <td>W</td>\n",
       "      <td>83.0</td>\n",
       "      <td>5Dimes</td>\n",
       "      <td>under</td>\n",
       "      <td>398</td>\n",
       "      <td>3729339</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15144</td>\n",
       "      <td>3</td>\n",
       "      <td>-120</td>\n",
       "      <td>1.83</td>\n",
       "      <td>3</td>\n",
       "      <td>Sportbet</td>\n",
       "      <td>4.0</td>\n",
       "      <td>-125</td>\n",
       "      <td>1.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4156</th>\n",
       "      <td>4156</td>\n",
       "      <td>2019-05-21T15:24:15-05:00</td>\n",
       "      <td>Boston@Toronto</td>\n",
       "      <td>1st Half - American Total</td>\n",
       "      <td>W</td>\n",
       "      <td>105.0</td>\n",
       "      <td>5Dimes</td>\n",
       "      <td>over</td>\n",
       "      <td>398</td>\n",
       "      <td>3728945</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15143</td>\n",
       "      <td>3</td>\n",
       "      <td>105</td>\n",
       "      <td>2.05</td>\n",
       "      <td>6</td>\n",
       "      <td>Sportbet</td>\n",
       "      <td>5.0</td>\n",
       "      <td>100</td>\n",
       "      <td>2.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5081</th>\n",
       "      <td>5081</td>\n",
       "      <td>2019-09-28T18:15:54-05:00</td>\n",
       "      <td>Milwaukee@Colorado</td>\n",
       "      <td>1st Half - American Total</td>\n",
       "      <td>W</td>\n",
       "      <td>91.0</td>\n",
       "      <td>5Dimes</td>\n",
       "      <td>under</td>\n",
       "      <td>398</td>\n",
       "      <td>3729180</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15144</td>\n",
       "      <td>3</td>\n",
       "      <td>-110</td>\n",
       "      <td>1.91</td>\n",
       "      <td>1</td>\n",
       "      <td>Sportbet</td>\n",
       "      <td>7.5</td>\n",
       "      <td>-120</td>\n",
       "      <td>1.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2356</th>\n",
       "      <td>2356</td>\n",
       "      <td>2019-09-28T20:03:54-05:00</td>\n",
       "      <td>Houston@Los Angeles</td>\n",
       "      <td>1st Half - American Total</td>\n",
       "      <td>L</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>5Dimes</td>\n",
       "      <td>over</td>\n",
       "      <td>398</td>\n",
       "      <td>3728501</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15143</td>\n",
       "      <td>3</td>\n",
       "      <td>-110</td>\n",
       "      <td>1.91</td>\n",
       "      <td>3</td>\n",
       "      <td>Sportbet</td>\n",
       "      <td>5.0</td>\n",
       "      <td>100</td>\n",
       "      <td>2.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2357</th>\n",
       "      <td>2357</td>\n",
       "      <td>2019-09-28T20:03:54-05:00</td>\n",
       "      <td>Houston@Los Angeles</td>\n",
       "      <td>1st Half - American Total</td>\n",
       "      <td>W</td>\n",
       "      <td>91.0</td>\n",
       "      <td>5Dimes</td>\n",
       "      <td>under</td>\n",
       "      <td>398</td>\n",
       "      <td>3728501</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15144</td>\n",
       "      <td>3</td>\n",
       "      <td>-110</td>\n",
       "      <td>1.91</td>\n",
       "      <td>3</td>\n",
       "      <td>Sportbet</td>\n",
       "      <td>5.0</td>\n",
       "      <td>-120</td>\n",
       "      <td>1.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6484</th>\n",
       "      <td>6484</td>\n",
       "      <td>2019-09-28T20:06:12-05:00</td>\n",
       "      <td>Oakland@Seattle</td>\n",
       "      <td>1st Half - American Total</td>\n",
       "      <td>L</td>\n",
       "      <td>-100.0</td>\n",
       "      <td>5Dimes</td>\n",
       "      <td>over</td>\n",
       "      <td>398</td>\n",
       "      <td>3729516</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15143</td>\n",
       "      <td>3</td>\n",
       "      <td>-120</td>\n",
       "      <td>1.83</td>\n",
       "      <td>1</td>\n",
       "      <td>Sportbet</td>\n",
       "      <td>5.0</td>\n",
       "      <td>-105</td>\n",
       "      <td>1.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6485</th>\n",
       "      <td>6485</td>\n",
       "      <td>2019-09-28T20:06:12-05:00</td>\n",
       "      <td>Oakland@Seattle</td>\n",
       "      <td>1st Half - American Total</td>\n",
       "      <td>W</td>\n",
       "      <td>100.0</td>\n",
       "      <td>5Dimes</td>\n",
       "      <td>under</td>\n",
       "      <td>398</td>\n",
       "      <td>3729516</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15144</td>\n",
       "      <td>3</td>\n",
       "      <td>100</td>\n",
       "      <td>2.00</td>\n",
       "      <td>1</td>\n",
       "      <td>Sportbet</td>\n",
       "      <td>5.0</td>\n",
       "      <td>-115</td>\n",
       "      <td>1.87</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3416 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Unnamed: 0                   datetime                  event  \\\n",
       "5416        5416  2019-05-21T09:24:57-05:00     New York@Baltimore   \n",
       "5417        5417  2019-05-21T09:24:57-05:00     New York@Baltimore   \n",
       "5740        5740  2019-05-21T12:16:08-05:00  Los Angeles@Tampa Bay   \n",
       "5741        5741  2019-05-21T12:16:08-05:00  Los Angeles@Tampa Bay   \n",
       "4156        4156  2019-05-21T15:24:15-05:00         Boston@Toronto   \n",
       "...          ...                        ...                    ...   \n",
       "5081        5081  2019-09-28T18:15:54-05:00     Milwaukee@Colorado   \n",
       "2356        2356  2019-09-28T20:03:54-05:00    Houston@Los Angeles   \n",
       "2357        2357  2019-09-28T20:03:54-05:00    Houston@Los Angeles   \n",
       "6484        6484  2019-09-28T20:06:12-05:00        Oakland@Seattle   \n",
       "6485        6485  2019-09-28T20:06:12-05:00        Oakland@Seattle   \n",
       "\n",
       "                         market result  profit sportsbook participant  \\\n",
       "5416  1st Half - American Total      W    87.0     5Dimes        over   \n",
       "5417  1st Half - American Total      L  -100.0     5Dimes       under   \n",
       "5740  1st Half - American Total      L  -100.0     5Dimes        over   \n",
       "5741  1st Half - American Total      W    83.0     5Dimes       under   \n",
       "4156  1st Half - American Total      W   105.0     5Dimes        over   \n",
       "...                         ...    ...     ...        ...         ...   \n",
       "5081  1st Half - American Total      W    91.0     5Dimes       under   \n",
       "2356  1st Half - American Total      L  -100.0     5Dimes        over   \n",
       "2357  1st Half - American Total      W    91.0     5Dimes       under   \n",
       "6484  1st Half - American Total      L  -100.0     5Dimes        over   \n",
       "6485  1st Half - American Total      W   100.0     5Dimes       under   \n",
       "\n",
       "      market_id  event_id  ...  participant_full_name participant_id  \\\n",
       "5416        398   3729258  ...                    NaN          15143   \n",
       "5417        398   3729258  ...                    NaN          15144   \n",
       "5740        398   3729339  ...                    NaN          15143   \n",
       "5741        398   3729339  ...                    NaN          15144   \n",
       "4156        398   3728945  ...                    NaN          15143   \n",
       "...         ...       ...  ...                    ...            ...   \n",
       "5081        398   3729180  ...                    NaN          15144   \n",
       "2356        398   3728501  ...                    NaN          15143   \n",
       "2357        398   3728501  ...                    NaN          15144   \n",
       "6484        398   3729516  ...                    NaN          15143   \n",
       "6485        398   3729516  ...                    NaN          15144   \n",
       "\n",
       "      sportsbook_id  american_odds  decimal_odds  participant_score  \\\n",
       "5416              3           -115          1.87                 12   \n",
       "5417              3           -105          1.95                 12   \n",
       "5740              3            100          2.00                  3   \n",
       "5741              3           -120          1.83                  3   \n",
       "4156              3            105          2.05                  6   \n",
       "...             ...            ...           ...                ...   \n",
       "5081              3           -110          1.91                  1   \n",
       "2356              3           -110          1.91                  3   \n",
       "2357              3           -110          1.91                  3   \n",
       "6484              3           -120          1.83                  1   \n",
       "6485              3            100          2.00                  1   \n",
       "\n",
       "      sportsbook_alias opening_spread_total  opening_american_odds  \\\n",
       "5416          Sportbet                  5.0                   -115   \n",
       "5417          Sportbet                  5.0                   -105   \n",
       "5740          Sportbet                  4.0                    105   \n",
       "5741          Sportbet                  4.0                   -125   \n",
       "4156          Sportbet                  5.0                    100   \n",
       "...                ...                  ...                    ...   \n",
       "5081          Sportbet                  7.5                   -120   \n",
       "2356          Sportbet                  5.0                    100   \n",
       "2357          Sportbet                  5.0                   -120   \n",
       "6484          Sportbet                  5.0                   -105   \n",
       "6485          Sportbet                  5.0                   -115   \n",
       "\n",
       "      opening_decimal_odds  \n",
       "5416                  1.87  \n",
       "5417                  1.95  \n",
       "5740                  2.05  \n",
       "5741                  1.80  \n",
       "4156                  2.00  \n",
       "...                    ...  \n",
       "5081                  1.83  \n",
       "2356                  2.00  \n",
       "2357                  1.83  \n",
       "6484                  1.95  \n",
       "6485                  1.87  \n",
       "\n",
       "[3416 rows x 21 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>index_x</th>\n",
       "      <th>HomeTeam_x</th>\n",
       "      <th>AwayTeam_x</th>\n",
       "      <th>GameDate_x</th>\n",
       "      <th>GameTime</th>\n",
       "      <th>HomeOPS</th>\n",
       "      <th>AwayOPS</th>\n",
       "      <th>HomewRCPlus</th>\n",
       "      <th>AwaywRCPlus</th>\n",
       "      <th>...</th>\n",
       "      <th>GameTime_y</th>\n",
       "      <th>AwayTeam_y</th>\n",
       "      <th>OpeningAwayOdds</th>\n",
       "      <th>AwayOdds</th>\n",
       "      <th>OpeningAwaySpread</th>\n",
       "      <th>AwaySpread</th>\n",
       "      <th>OpeningHomeOddsSpreadRatio</th>\n",
       "      <th>HomeOddsSpreadRatio</th>\n",
       "      <th>OpeningAwayOddsSpreadRatio</th>\n",
       "      <th>AwayOddsSpreadRatio</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Baltimore Orioles</td>\n",
       "      <td>New York Yankees</td>\n",
       "      <td>2019-05-21</td>\n",
       "      <td>23:05:00</td>\n",
       "      <td>0.684444</td>\n",
       "      <td>0.812081</td>\n",
       "      <td>77.547067</td>\n",
       "      <td>112.642638</td>\n",
       "      <td>...</td>\n",
       "      <td>12:08:26</td>\n",
       "      <td>New York Yankees</td>\n",
       "      <td>1.67</td>\n",
       "      <td>1.61</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>4.60</td>\n",
       "      <td>4.90</td>\n",
       "      <td>-3.34</td>\n",
       "      <td>-3.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Chicago Cubs</td>\n",
       "      <td>Philadelphia Phillies</td>\n",
       "      <td>2019-05-21</td>\n",
       "      <td>23:05:00</td>\n",
       "      <td>0.832134</td>\n",
       "      <td>0.748106</td>\n",
       "      <td>112.784011</td>\n",
       "      <td>95.336449</td>\n",
       "      <td>...</td>\n",
       "      <td>18:02:33</td>\n",
       "      <td>Philadelphia Phillies</td>\n",
       "      <td>1.83</td>\n",
       "      <td>1.74</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>-4.00</td>\n",
       "      <td>-4.30</td>\n",
       "      <td>3.66</td>\n",
       "      <td>3.48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Cleveland Indians</td>\n",
       "      <td>Oakland Athletics</td>\n",
       "      <td>2019-05-21</td>\n",
       "      <td>22:10:00</td>\n",
       "      <td>0.705041</td>\n",
       "      <td>0.739313</td>\n",
       "      <td>83.243812</td>\n",
       "      <td>100.581645</td>\n",
       "      <td>...</td>\n",
       "      <td>17:06:40</td>\n",
       "      <td>Oakland Athletics</td>\n",
       "      <td>1.83</td>\n",
       "      <td>1.77</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>-4.00</td>\n",
       "      <td>-4.20</td>\n",
       "      <td>3.66</td>\n",
       "      <td>3.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>7.0</td>\n",
       "      <td>Detroit Tigers</td>\n",
       "      <td>Miami Marlins</td>\n",
       "      <td>2019-05-21</td>\n",
       "      <td>23:10:00</td>\n",
       "      <td>0.664616</td>\n",
       "      <td>0.588098</td>\n",
       "      <td>70.105263</td>\n",
       "      <td>61.060000</td>\n",
       "      <td>...</td>\n",
       "      <td>17:09:34</td>\n",
       "      <td>Miami Marlins</td>\n",
       "      <td>1.74</td>\n",
       "      <td>1.65</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>-4.30</td>\n",
       "      <td>-4.70</td>\n",
       "      <td>3.48</td>\n",
       "      <td>3.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>9.0</td>\n",
       "      <td>Houston Astros</td>\n",
       "      <td>Chicago White Sox</td>\n",
       "      <td>2019-05-21</td>\n",
       "      <td>00:10:00</td>\n",
       "      <td>0.904353</td>\n",
       "      <td>0.714527</td>\n",
       "      <td>137.106117</td>\n",
       "      <td>88.751079</td>\n",
       "      <td>...</td>\n",
       "      <td>18:41:10</td>\n",
       "      <td>Chicago White Sox</td>\n",
       "      <td>2.70</td>\n",
       "      <td>2.85</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>-3.00</td>\n",
       "      <td>-2.88</td>\n",
       "      <td>5.40</td>\n",
       "      <td>5.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1522</th>\n",
       "      <td>1687</td>\n",
       "      <td>1556.0</td>\n",
       "      <td>Seattle Mariners</td>\n",
       "      <td>Oakland Athletics</td>\n",
       "      <td>2019-09-28</td>\n",
       "      <td>01:10:00</td>\n",
       "      <td>0.708298</td>\n",
       "      <td>0.863258</td>\n",
       "      <td>92.253247</td>\n",
       "      <td>130.966165</td>\n",
       "      <td>...</td>\n",
       "      <td>20:03:24</td>\n",
       "      <td>Oakland Athletics</td>\n",
       "      <td>1.83</td>\n",
       "      <td>1.91</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>4.00</td>\n",
       "      <td>3.82</td>\n",
       "      <td>-3.66</td>\n",
       "      <td>-3.82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1523</th>\n",
       "      <td>1688</td>\n",
       "      <td>1550.0</td>\n",
       "      <td>St. Louis Cardinals</td>\n",
       "      <td>Chicago Cubs</td>\n",
       "      <td>2019-09-28</td>\n",
       "      <td>23:15:00</td>\n",
       "      <td>0.756738</td>\n",
       "      <td>0.831891</td>\n",
       "      <td>99.833137</td>\n",
       "      <td>114.113978</td>\n",
       "      <td>...</td>\n",
       "      <td>17:13:16</td>\n",
       "      <td>Chicago Cubs</td>\n",
       "      <td>2.10</td>\n",
       "      <td>2.05</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>-3.54</td>\n",
       "      <td>-3.60</td>\n",
       "      <td>4.20</td>\n",
       "      <td>4.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1524</th>\n",
       "      <td>1689</td>\n",
       "      <td>1552.0</td>\n",
       "      <td>Texas Rangers</td>\n",
       "      <td>New York Yankees</td>\n",
       "      <td>2019-09-28</td>\n",
       "      <td>00:05:00</td>\n",
       "      <td>0.760117</td>\n",
       "      <td>0.828818</td>\n",
       "      <td>89.687585</td>\n",
       "      <td>115.260937</td>\n",
       "      <td>...</td>\n",
       "      <td>09:44:11</td>\n",
       "      <td>New York Yankees</td>\n",
       "      <td>1.56</td>\n",
       "      <td>1.56</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>5.16</td>\n",
       "      <td>5.16</td>\n",
       "      <td>-3.12</td>\n",
       "      <td>-3.12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1525</th>\n",
       "      <td>1690</td>\n",
       "      <td>1545.0</td>\n",
       "      <td>Toronto Blue Jays</td>\n",
       "      <td>Tampa Bay Rays</td>\n",
       "      <td>2019-09-28</td>\n",
       "      <td>19:07:00</td>\n",
       "      <td>0.780490</td>\n",
       "      <td>0.843940</td>\n",
       "      <td>101.441606</td>\n",
       "      <td>126.158763</td>\n",
       "      <td>...</td>\n",
       "      <td>09:44:52</td>\n",
       "      <td>Tampa Bay Rays</td>\n",
       "      <td>1.71</td>\n",
       "      <td>1.71</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>4.40</td>\n",
       "      <td>4.40</td>\n",
       "      <td>-3.42</td>\n",
       "      <td>-3.42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1526</th>\n",
       "      <td>1691</td>\n",
       "      <td>1547.0</td>\n",
       "      <td>Washington Nationals</td>\n",
       "      <td>Cleveland Indians</td>\n",
       "      <td>2019-09-28</td>\n",
       "      <td>20:05:00</td>\n",
       "      <td>0.832406</td>\n",
       "      <td>0.691028</td>\n",
       "      <td>111.005658</td>\n",
       "      <td>85.148387</td>\n",
       "      <td>...</td>\n",
       "      <td>14:33:05</td>\n",
       "      <td>Cleveland Indians</td>\n",
       "      <td>2.20</td>\n",
       "      <td>2.65</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>-3.42</td>\n",
       "      <td>-3.06</td>\n",
       "      <td>4.40</td>\n",
       "      <td>5.30</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1527 rows × 44 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Unnamed: 0  index_x            HomeTeam_x             AwayTeam_x  \\\n",
       "0              1      3.0     Baltimore Orioles       New York Yankees   \n",
       "1              2      2.0          Chicago Cubs  Philadelphia Phillies   \n",
       "2              3      0.0     Cleveland Indians      Oakland Athletics   \n",
       "3              4      7.0        Detroit Tigers          Miami Marlins   \n",
       "4              5      9.0        Houston Astros      Chicago White Sox   \n",
       "...          ...      ...                   ...                    ...   \n",
       "1522        1687   1556.0      Seattle Mariners      Oakland Athletics   \n",
       "1523        1688   1550.0   St. Louis Cardinals           Chicago Cubs   \n",
       "1524        1689   1552.0         Texas Rangers       New York Yankees   \n",
       "1525        1690   1545.0     Toronto Blue Jays         Tampa Bay Rays   \n",
       "1526        1691   1547.0  Washington Nationals      Cleveland Indians   \n",
       "\n",
       "      GameDate_x  GameTime   HomeOPS   AwayOPS  HomewRCPlus  AwaywRCPlus  ...  \\\n",
       "0     2019-05-21  23:05:00  0.684444  0.812081    77.547067   112.642638  ...   \n",
       "1     2019-05-21  23:05:00  0.832134  0.748106   112.784011    95.336449  ...   \n",
       "2     2019-05-21  22:10:00  0.705041  0.739313    83.243812   100.581645  ...   \n",
       "3     2019-05-21  23:10:00  0.664616  0.588098    70.105263    61.060000  ...   \n",
       "4     2019-05-21  00:10:00  0.904353  0.714527   137.106117    88.751079  ...   \n",
       "...          ...       ...       ...       ...          ...          ...  ...   \n",
       "1522  2019-09-28  01:10:00  0.708298  0.863258    92.253247   130.966165  ...   \n",
       "1523  2019-09-28  23:15:00  0.756738  0.831891    99.833137   114.113978  ...   \n",
       "1524  2019-09-28  00:05:00  0.760117  0.828818    89.687585   115.260937  ...   \n",
       "1525  2019-09-28  19:07:00  0.780490  0.843940   101.441606   126.158763  ...   \n",
       "1526  2019-09-28  20:05:00  0.832406  0.691028   111.005658    85.148387  ...   \n",
       "\n",
       "     GameTime_y             AwayTeam_y  OpeningAwayOdds AwayOdds  \\\n",
       "0      12:08:26       New York Yankees             1.67     1.61   \n",
       "1      18:02:33  Philadelphia Phillies             1.83     1.74   \n",
       "2      17:06:40      Oakland Athletics             1.83     1.77   \n",
       "3      17:09:34          Miami Marlins             1.74     1.65   \n",
       "4      18:41:10      Chicago White Sox             2.70     2.85   \n",
       "...         ...                    ...              ...      ...   \n",
       "1522   20:03:24      Oakland Athletics             1.83     1.91   \n",
       "1523   17:13:16           Chicago Cubs             2.10     2.05   \n",
       "1524   09:44:11       New York Yankees             1.56     1.56   \n",
       "1525   09:44:52         Tampa Bay Rays             1.71     1.71   \n",
       "1526   14:33:05      Cleveland Indians             2.20     2.65   \n",
       "\n",
       "      OpeningAwaySpread  AwaySpread  OpeningHomeOddsSpreadRatio  \\\n",
       "0                  -0.5        -0.5                        4.60   \n",
       "1                   0.5         0.5                       -4.00   \n",
       "2                   0.5         0.5                       -4.00   \n",
       "3                   0.5         0.5                       -4.30   \n",
       "4                   0.5         0.5                       -3.00   \n",
       "...                 ...         ...                         ...   \n",
       "1522               -0.5        -0.5                        4.00   \n",
       "1523                0.5         0.5                       -3.54   \n",
       "1524               -0.5        -0.5                        5.16   \n",
       "1525               -0.5        -0.5                        4.40   \n",
       "1526                0.5         0.5                       -3.42   \n",
       "\n",
       "      HomeOddsSpreadRatio  OpeningAwayOddsSpreadRatio  AwayOddsSpreadRatio  \n",
       "0                    4.90                       -3.34                -3.22  \n",
       "1                   -4.30                        3.66                 3.48  \n",
       "2                   -4.20                        3.66                 3.54  \n",
       "3                   -4.70                        3.48                 3.30  \n",
       "4                   -2.88                        5.40                 5.70  \n",
       "...                   ...                         ...                  ...  \n",
       "1522                 3.82                       -3.66                -3.82  \n",
       "1523                -3.60                        4.20                 4.10  \n",
       "1524                 5.16                       -3.12                -3.12  \n",
       "1525                 4.40                       -3.42                -3.42  \n",
       "1526                -3.06                        4.40                 5.30  \n",
       "\n",
       "[1527 rows x 44 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>index_x</th>\n",
       "      <th>HomeTeam_x</th>\n",
       "      <th>AwayTeam_x</th>\n",
       "      <th>GameDate_x</th>\n",
       "      <th>GameTime</th>\n",
       "      <th>HomeOPS</th>\n",
       "      <th>AwayOPS</th>\n",
       "      <th>HomewRCPlus</th>\n",
       "      <th>AwaywRCPlus</th>\n",
       "      <th>...</th>\n",
       "      <th>OpeningAwaySpread</th>\n",
       "      <th>AwaySpread</th>\n",
       "      <th>OpeningHomeOddsSpreadRatio</th>\n",
       "      <th>HomeOddsSpreadRatio</th>\n",
       "      <th>OpeningAwayOddsSpreadRatio</th>\n",
       "      <th>AwayOddsSpreadRatio</th>\n",
       "      <th>OpeningTotal</th>\n",
       "      <th>Total</th>\n",
       "      <th>OpeningTotalOdds</th>\n",
       "      <th>TotalOdds</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1284.0</td>\n",
       "      <td>1176.0</td>\n",
       "      <td>Detroit Tigers</td>\n",
       "      <td>Cleveland Indians</td>\n",
       "      <td>2019-08-29</td>\n",
       "      <td>17:10:00</td>\n",
       "      <td>0.687834</td>\n",
       "      <td>0.810574</td>\n",
       "      <td>77.760000</td>\n",
       "      <td>108.295796</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>4.40</td>\n",
       "      <td>4.90</td>\n",
       "      <td>-3.42</td>\n",
       "      <td>-3.22</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.00</td>\n",
       "      <td>1.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1284.0</td>\n",
       "      <td>1176.0</td>\n",
       "      <td>Detroit Tigers</td>\n",
       "      <td>Cleveland Indians</td>\n",
       "      <td>2019-08-29</td>\n",
       "      <td>17:10:00</td>\n",
       "      <td>0.687834</td>\n",
       "      <td>0.810574</td>\n",
       "      <td>77.760000</td>\n",
       "      <td>108.295796</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>4.40</td>\n",
       "      <td>4.90</td>\n",
       "      <td>-3.42</td>\n",
       "      <td>-3.22</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.83</td>\n",
       "      <td>2.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>385.0</td>\n",
       "      <td>347.0</td>\n",
       "      <td>Texas Rangers</td>\n",
       "      <td>Cleveland Indians</td>\n",
       "      <td>2019-06-18</td>\n",
       "      <td>00:05:00</td>\n",
       "      <td>0.723912</td>\n",
       "      <td>0.807953</td>\n",
       "      <td>80.167726</td>\n",
       "      <td>107.817272</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>3.54</td>\n",
       "      <td>3.36</td>\n",
       "      <td>-4.20</td>\n",
       "      <td>-4.56</td>\n",
       "      <td>6.0</td>\n",
       "      <td>5.5</td>\n",
       "      <td>2.00</td>\n",
       "      <td>1.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>385.0</td>\n",
       "      <td>347.0</td>\n",
       "      <td>Texas Rangers</td>\n",
       "      <td>Cleveland Indians</td>\n",
       "      <td>2019-06-18</td>\n",
       "      <td>00:05:00</td>\n",
       "      <td>0.723912</td>\n",
       "      <td>0.807953</td>\n",
       "      <td>80.167726</td>\n",
       "      <td>107.817272</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>3.54</td>\n",
       "      <td>3.36</td>\n",
       "      <td>-4.20</td>\n",
       "      <td>-4.56</td>\n",
       "      <td>6.0</td>\n",
       "      <td>5.5</td>\n",
       "      <td>1.83</td>\n",
       "      <td>2.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>117.0</td>\n",
       "      <td>112.0</td>\n",
       "      <td>Colorado Rockies</td>\n",
       "      <td>Arizona Diamondbacks</td>\n",
       "      <td>2019-05-29</td>\n",
       "      <td>00:40:00</td>\n",
       "      <td>0.869862</td>\n",
       "      <td>0.811858</td>\n",
       "      <td>110.008224</td>\n",
       "      <td>105.536585</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>3.60</td>\n",
       "      <td>3.60</td>\n",
       "      <td>-4.10</td>\n",
       "      <td>-4.10</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.83</td>\n",
       "      <td>1.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3361</th>\n",
       "      <td>765.0</td>\n",
       "      <td>693.0</td>\n",
       "      <td>Tampa Bay Rays</td>\n",
       "      <td>Chicago White Sox</td>\n",
       "      <td>2019-07-20</td>\n",
       "      <td>22:10:00</td>\n",
       "      <td>0.719474</td>\n",
       "      <td>0.769173</td>\n",
       "      <td>93.326301</td>\n",
       "      <td>103.806678</td>\n",
       "      <td>...</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>-3.74</td>\n",
       "      <td>-4.10</td>\n",
       "      <td>3.90</td>\n",
       "      <td>3.60</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.5</td>\n",
       "      <td>1.83</td>\n",
       "      <td>1.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3362</th>\n",
       "      <td>1645.0</td>\n",
       "      <td>1519.0</td>\n",
       "      <td>San Diego Padres</td>\n",
       "      <td>Los Angeles Dodgers</td>\n",
       "      <td>2019-09-25</td>\n",
       "      <td>02:10:00</td>\n",
       "      <td>0.698667</td>\n",
       "      <td>0.811333</td>\n",
       "      <td>86.157468</td>\n",
       "      <td>110.842199</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>4.10</td>\n",
       "      <td>4.00</td>\n",
       "      <td>-3.60</td>\n",
       "      <td>-3.66</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>2.00</td>\n",
       "      <td>1.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3363</th>\n",
       "      <td>1645.0</td>\n",
       "      <td>1519.0</td>\n",
       "      <td>San Diego Padres</td>\n",
       "      <td>Los Angeles Dodgers</td>\n",
       "      <td>2019-09-25</td>\n",
       "      <td>02:10:00</td>\n",
       "      <td>0.698667</td>\n",
       "      <td>0.811333</td>\n",
       "      <td>86.157468</td>\n",
       "      <td>110.842199</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>4.10</td>\n",
       "      <td>4.00</td>\n",
       "      <td>-3.60</td>\n",
       "      <td>-3.66</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>1.83</td>\n",
       "      <td>1.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3366</th>\n",
       "      <td>352.0</td>\n",
       "      <td>319.0</td>\n",
       "      <td>Detroit Tigers</td>\n",
       "      <td>Cleveland Indians</td>\n",
       "      <td>2019-06-16</td>\n",
       "      <td>17:10:00</td>\n",
       "      <td>0.731302</td>\n",
       "      <td>0.763407</td>\n",
       "      <td>87.671096</td>\n",
       "      <td>96.572816</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>3.90</td>\n",
       "      <td>4.10</td>\n",
       "      <td>-3.74</td>\n",
       "      <td>-3.60</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.00</td>\n",
       "      <td>1.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3367</th>\n",
       "      <td>352.0</td>\n",
       "      <td>319.0</td>\n",
       "      <td>Detroit Tigers</td>\n",
       "      <td>Cleveland Indians</td>\n",
       "      <td>2019-06-16</td>\n",
       "      <td>17:10:00</td>\n",
       "      <td>0.731302</td>\n",
       "      <td>0.763407</td>\n",
       "      <td>87.671096</td>\n",
       "      <td>96.572816</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>3.90</td>\n",
       "      <td>4.10</td>\n",
       "      <td>-3.74</td>\n",
       "      <td>-3.60</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.83</td>\n",
       "      <td>2.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3054 rows × 48 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Unnamed: 0  index_x        HomeTeam_x            AwayTeam_x  GameDate_x  \\\n",
       "0         1284.0   1176.0    Detroit Tigers     Cleveland Indians  2019-08-29   \n",
       "1         1284.0   1176.0    Detroit Tigers     Cleveland Indians  2019-08-29   \n",
       "2          385.0    347.0     Texas Rangers     Cleveland Indians  2019-06-18   \n",
       "3          385.0    347.0     Texas Rangers     Cleveland Indians  2019-06-18   \n",
       "4          117.0    112.0  Colorado Rockies  Arizona Diamondbacks  2019-05-29   \n",
       "...          ...      ...               ...                   ...         ...   \n",
       "3361       765.0    693.0    Tampa Bay Rays     Chicago White Sox  2019-07-20   \n",
       "3362      1645.0   1519.0  San Diego Padres   Los Angeles Dodgers  2019-09-25   \n",
       "3363      1645.0   1519.0  San Diego Padres   Los Angeles Dodgers  2019-09-25   \n",
       "3366       352.0    319.0    Detroit Tigers     Cleveland Indians  2019-06-16   \n",
       "3367       352.0    319.0    Detroit Tigers     Cleveland Indians  2019-06-16   \n",
       "\n",
       "      GameTime   HomeOPS   AwayOPS  HomewRCPlus  AwaywRCPlus  ...  \\\n",
       "0     17:10:00  0.687834  0.810574    77.760000   108.295796  ...   \n",
       "1     17:10:00  0.687834  0.810574    77.760000   108.295796  ...   \n",
       "2     00:05:00  0.723912  0.807953    80.167726   107.817272  ...   \n",
       "3     00:05:00  0.723912  0.807953    80.167726   107.817272  ...   \n",
       "4     00:40:00  0.869862  0.811858   110.008224   105.536585  ...   \n",
       "...        ...       ...       ...          ...          ...  ...   \n",
       "3361  22:10:00  0.719474  0.769173    93.326301   103.806678  ...   \n",
       "3362  02:10:00  0.698667  0.811333    86.157468   110.842199  ...   \n",
       "3363  02:10:00  0.698667  0.811333    86.157468   110.842199  ...   \n",
       "3366  17:10:00  0.731302  0.763407    87.671096    96.572816  ...   \n",
       "3367  17:10:00  0.731302  0.763407    87.671096    96.572816  ...   \n",
       "\n",
       "     OpeningAwaySpread  AwaySpread  OpeningHomeOddsSpreadRatio  \\\n",
       "0                 -0.5        -0.5                        4.40   \n",
       "1                 -0.5        -0.5                        4.40   \n",
       "2                 -0.5        -0.5                        3.54   \n",
       "3                 -0.5        -0.5                        3.54   \n",
       "4                 -0.5        -0.5                        3.60   \n",
       "...                ...         ...                         ...   \n",
       "3361               0.5         0.5                       -3.74   \n",
       "3362              -0.5        -0.5                        4.10   \n",
       "3363              -0.5        -0.5                        4.10   \n",
       "3366              -0.5        -0.5                        3.90   \n",
       "3367              -0.5        -0.5                        3.90   \n",
       "\n",
       "     HomeOddsSpreadRatio  OpeningAwayOddsSpreadRatio  AwayOddsSpreadRatio  \\\n",
       "0                   4.90                       -3.42                -3.22   \n",
       "1                   4.90                       -3.42                -3.22   \n",
       "2                   3.36                       -4.20                -4.56   \n",
       "3                   3.36                       -4.20                -4.56   \n",
       "4                   3.60                       -4.10                -4.10   \n",
       "...                  ...                         ...                  ...   \n",
       "3361               -4.10                        3.90                 3.60   \n",
       "3362                4.00                       -3.60                -3.66   \n",
       "3363                4.00                       -3.60                -3.66   \n",
       "3366                4.10                       -3.74                -3.60   \n",
       "3367                4.10                       -3.74                -3.60   \n",
       "\n",
       "      OpeningTotal  Total  OpeningTotalOdds  TotalOdds  \n",
       "0              4.5    4.0              2.00       1.83  \n",
       "1              4.5    4.0              1.83       2.00  \n",
       "2              6.0    5.5              2.00       1.83  \n",
       "3              6.0    5.5              1.83       2.00  \n",
       "4              6.0    6.0              1.83       1.91  \n",
       "...            ...    ...               ...        ...  \n",
       "3361           4.5    4.5              1.83       1.87  \n",
       "3362           5.0    4.5              2.00       1.91  \n",
       "3363           5.0    4.5              1.83       1.91  \n",
       "3366           4.5    4.0              2.00       1.83  \n",
       "3367           4.5    4.0              1.83       2.00  \n",
       "\n",
       "[3054 rows x 48 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "### keep this ####\n",
    "\n",
    "import numpy as np\n",
    "\n",
    "def determine_home_team(row):\n",
    "    away_team_fragment = row['event'].split('@')[0].split(' ')[0]\n",
    "    home_team_fragment = row['event'].split('@')[1].split(' ')[0]\n",
    "    \n",
    "    participant_fragment = row['participant_full_name'].split(' ')[0]\n",
    "    \n",
    "    if home_team_fragment == away_team_fragment:\n",
    "        return None\n",
    "    elif participant_fragment == home_team_fragment:\n",
    "        return row['participant_full_name']\n",
    "    elif participant_fragment == away_team_fragment:\n",
    "        return None\n",
    "    else:\n",
    "        return 'error'\n",
    "\n",
    "def determine_away_team(row):\n",
    "    away_team_fragment = row['event'].split('@')[0].split(' ')[0]\n",
    "    home_team_fragment = row['event'].split('@')[1].split(' ')[0]\n",
    "    \n",
    "    participant_fragment = row['participant_full_name'].split(' ')[0]\n",
    "    \n",
    "    if home_team_fragment == away_team_fragment:\n",
    "        return None\n",
    "    elif participant_fragment == home_team_fragment:\n",
    "        return None\n",
    "    elif participant_fragment == away_team_fragment:\n",
    "        return row['participant_full_name']\n",
    "    else:\n",
    "        return 'error'    \n",
    "    \n",
    "def determine_home_odds(row):\n",
    "    away_team_fragment = row['event'].split('@')[0].split(' ')[0]\n",
    "    home_team_fragment = row['event'].split('@')[1].split(' ')[0]\n",
    "    \n",
    "    participant_fragment = row['participant_full_name'].split(' ')[0]\n",
    "    \n",
    "    if home_team_fragment == away_team_fragment:\n",
    "        return None\n",
    "    elif participant_fragment == home_team_fragment:\n",
    "        return row['decimal_odds']\n",
    "    elif participant_fragment == away_team_fragment:\n",
    "        return None\n",
    "    else:\n",
    "        return 'error'\n",
    "    \n",
    "def determine_away_odds(row):\n",
    "    away_team_fragment = row['event'].split('@')[0].split(' ')[0]\n",
    "    home_team_fragment = row['event'].split('@')[1].split(' ')[0]\n",
    "    \n",
    "    participant_fragment = row['participant_full_name'].split(' ')[0]\n",
    "    \n",
    "    if home_team_fragment == away_team_fragment:\n",
    "        return None\n",
    "    elif participant_fragment == home_team_fragment:\n",
    "        return None\n",
    "    elif participant_fragment == away_team_fragment:\n",
    "        return row['decimal_odds']\n",
    "    else:\n",
    "        return 'error'\n",
    "    \n",
    "def determine_opening_home_odds(row):\n",
    "    away_team_fragment = row['event'].split('@')[0].split(' ')[0]\n",
    "    home_team_fragment = row['event'].split('@')[1].split(' ')[0]\n",
    "    \n",
    "    participant_fragment = row['participant_full_name'].split(' ')[0]\n",
    "    \n",
    "    if home_team_fragment == away_team_fragment:\n",
    "        return None\n",
    "    elif participant_fragment == home_team_fragment:\n",
    "        return row['opening_decimal_odds']\n",
    "    elif participant_fragment == away_team_fragment:\n",
    "        return None\n",
    "    else:\n",
    "        return 'error'\n",
    "    \n",
    "    \n",
    "def determine_opening_home_spread(row):\n",
    "    away_team_fragment = row['event'].split('@')[0].split(' ')[0]\n",
    "    home_team_fragment = row['event'].split('@')[1].split(' ')[0]\n",
    "    \n",
    "    participant_fragment = row['participant_full_name'].split(' ')[0]\n",
    "    \n",
    "    if home_team_fragment == away_team_fragment:\n",
    "        return None\n",
    "    elif participant_fragment == home_team_fragment:\n",
    "        return row['opening_spread_total']\n",
    "    elif participant_fragment == away_team_fragment:\n",
    "        return None\n",
    "    else:\n",
    "        return 'error'\n",
    "    \n",
    "def determine_home_spread(row):\n",
    "    away_team_fragment = row['event'].split('@')[0].split(' ')[0]\n",
    "    home_team_fragment = row['event'].split('@')[1].split(' ')[0]\n",
    "    \n",
    "    participant_fragment = row['participant_full_name'].split(' ')[0]\n",
    "    \n",
    "    if home_team_fragment == away_team_fragment:\n",
    "        return None\n",
    "    elif participant_fragment == home_team_fragment:\n",
    "        return row['spread_total']\n",
    "    elif participant_fragment == away_team_fragment:\n",
    "        return None\n",
    "    else:\n",
    "        return 'error'    \n",
    "    \n",
    "    \n",
    "def determine_opening_away_odds(row):\n",
    "    away_team_fragment = row['event'].split('@')[0].split(' ')[0]\n",
    "    home_team_fragment = row['event'].split('@')[1].split(' ')[0]\n",
    "    \n",
    "    participant_fragment = row['participant_full_name'].split(' ')[0]\n",
    "    \n",
    "    if home_team_fragment == away_team_fragment:\n",
    "        return None\n",
    "    elif participant_fragment == home_team_fragment:\n",
    "        return None\n",
    "    elif participant_fragment == away_team_fragment:\n",
    "        return row['opening_decimal_odds']\n",
    "    else:\n",
    "        return 'error'    \n",
    "def determine_opening_away_spread(row):\n",
    "    away_team_fragment = row['event'].split('@')[0].split(' ')[0]\n",
    "    home_team_fragment = row['event'].split('@')[1].split(' ')[0]\n",
    "    \n",
    "    participant_fragment = row['participant_full_name'].split(' ')[0]\n",
    "    \n",
    "    if home_team_fragment == away_team_fragment:\n",
    "        return None\n",
    "    elif participant_fragment == home_team_fragment:\n",
    "        return None\n",
    "    elif participant_fragment == away_team_fragment:\n",
    "        return row['opening_spread_total']\n",
    "\n",
    "    else:\n",
    "        return 'error'\n",
    "    \n",
    "def determine_away_spread(row):\n",
    "    away_team_fragment = row['event'].split('@')[0].split(' ')[0]\n",
    "    home_team_fragment = row['event'].split('@')[1].split(' ')[0]\n",
    "    \n",
    "    participant_fragment = row['participant_full_name'].split(' ')[0]\n",
    "    \n",
    "    if home_team_fragment == away_team_fragment:\n",
    "        return None\n",
    "    elif participant_fragment == home_team_fragment:\n",
    "        return None\n",
    "    elif participant_fragment == away_team_fragment:\n",
    "        return row['spread_total']\n",
    "    else:\n",
    "        return 'error'        \n",
    "\n",
    "    \n",
    "def determine_over_opening_total(row):\n",
    "    ou = row['participant']\n",
    "    \n",
    "    if ou=='over':\n",
    "        return row['opening_spread_total']\n",
    "    elif ou=='under':\n",
    "        return None\n",
    "    else:\n",
    "        return 'error' \n",
    "def determine_under_opening_total(row):\n",
    "    ou = row['participant']\n",
    "    \n",
    "    if ou=='over':\n",
    "        return None\n",
    "    elif ou=='under':\n",
    "        return row['opening_spread_total']\n",
    "    else:\n",
    "        return 'error'     \n",
    "    \n",
    "def determine_over_total(row):\n",
    "    ou = row['participant']\n",
    "    \n",
    "    if ou=='over':\n",
    "        return row['spread_total']\n",
    "    elif ou=='under':\n",
    "        return None\n",
    "    else:\n",
    "        return 'error'\n",
    "def determine_under_total(row):\n",
    "    ou = row['participant']\n",
    "    \n",
    "    if ou=='over':\n",
    "        return None\n",
    "    elif ou=='under':\n",
    "        return row['spread_total']\n",
    "    else:\n",
    "        return 'error'\n",
    "def determine_opening_over_odds(row):\n",
    "    \n",
    "def determine_over_odds(row):\n",
    "def determine_opening_under_odds(row):\n",
    "def determine_under_odds(row):\n",
    "    \n",
    "################ for first 5 innings moneyline ####################    \n",
    "    \n",
    "    \n",
    "# first_5_pickem['HomeTeam'] = first_5_pickem.apply(lambda row: determine_home_team(row),axis=1)\n",
    "# first_5_pickem['AwayTeam'] = first_5_pickem.apply(lambda row: determine_away_team(row),axis=1)\n",
    "# first_5_pickem['HomeOdds'] = first_5_pickem.apply(lambda row: determine_home_odds(row),axis=1)\n",
    "# first_5_pickem['AwayOdds'] = first_5_pickem.apply(lambda row: determine_away_odds(row),axis=1)\n",
    "# first_5_pickem['OpeningHomeOdds'] = first_5_pickem.apply(lambda row: determine_opening_home_odds(row),axis=1)\n",
    "# first_5_pickem['OpeningAwayOdds'] = first_5_pickem.apply(lambda row: determine_opening_away_odds(row),axis=1)\n",
    "\n",
    "# new_home = first_5_pickem[['event_id','GameDate','GameTime','HomeTeam','OpeningHomeOdds','HomeOdds']].copy().dropna()\n",
    "# new_away = first_5_pickem[['event_id','GameDate','GameTime','AwayTeam','OpeningAwayOdds','AwayOdds']].copy().dropna()                          \n",
    "# home_away = pd.merge(new_home,new_away,on=['event_id','GameDate','GameTime'])\n",
    "\n",
    "\n",
    "# new_home = first_5_pickem[['event_id','GameDate','GameTime','HomeTeam','OpeningHomeOdds','HomeOdds']].copy().dropna()\n",
    "# new_away = first_5_pickem[['event_id','GameDate','GameTime','AwayTeam','OpeningAwayOdds','AwayOdds']].copy().dropna()                          \n",
    "# home_away = pd.merge(new_home,new_away,on=['event_id','GameDate','GameTime'])\n",
    "\n",
    "# home_away = home_away.sort_values(by=['GameDate','event_id'])\n",
    "# home_away_no_double_headers = home_away.drop_duplicates(subset=['GameDate','HomeTeam'],keep='first')\n",
    "\n",
    "\n",
    "################ for first 5 innings spread ####################    \n",
    "\n",
    "# first_5_spread['HomeTeam'] = first_5_spread.apply(lambda row: determine_home_team(row),axis=1)\n",
    "# first_5_spread['AwayTeam'] = first_5_spread.apply(lambda row: determine_away_team(row),axis=1)\n",
    "# first_5_spread['HomeOdds'] = first_5_spread.apply(lambda row: determine_home_odds(row),axis=1)\n",
    "# first_5_spread['AwayOdds'] = first_5_spread.apply(lambda row: determine_away_odds(row),axis=1)\n",
    "# first_5_spread['OpeningHomeOdds'] = first_5_spread.apply(lambda row: determine_opening_home_odds(row),axis=1)\n",
    "# first_5_spread['OpeningAwayOdds'] = first_5_spread.apply(lambda row: determine_opening_away_odds(row),axis=1)\n",
    "# first_5_spread['OpeningHomeSpread'] = first_5_spread.apply(lambda row: determine_opening_home_spread(row),axis=1)\n",
    "# first_5_spread['OpeningAwaySpread'] = first_5_spread.apply(lambda row: determine_opening_away_spread(row),axis=1)\n",
    "# first_5_spread['HomeSpread'] = first_5_spread.apply(lambda row: determine_home_spread(row),axis=1)\n",
    "# first_5_spread['AwaySpread'] = first_5_spread.apply(lambda row: determine_away_spread(row),axis=1)\n",
    "\n",
    "\n",
    "# new_home = first_5_spread[['event_id','GameDate','GameTime','HomeTeam','OpeningHomeOdds','HomeOdds','OpeningHomeSpread','HomeSpread']].copy().dropna()\n",
    "# new_away = first_5_spread[['event_id','GameDate','GameTime','AwayTeam','OpeningAwayOdds','AwayOdds','OpeningAwaySpread','AwaySpread']].copy().dropna()                          \n",
    "# home_away = pd.merge(new_home,new_away,on=['event_id','GameDate'])\n",
    "\n",
    "# home_away = home_away.sort_values(by=['GameDate','event_id'])\n",
    "# home_away_no_double_headers = home_away.drop_duplicates(subset=['GameDate','HomeTeam'],keep='first')\n",
    "\n",
    "\n",
    "\n",
    "# home_away_no_double_headers = home_away_no_double_headers[home_away_no_double_headers.AwayOdds != 'error']\n",
    "\n",
    "# # home_away.to_csv('home_away_pickem_odds_052121_thru_071021.csv')\n",
    "# home_away_no_double_headers = home_away_no_double_headers.sort_values(by=['GameDate','HomeTeam']).reset_index()\n",
    "# home_away_no_double_headers['HomePlusDate'] = home_away_no_double_headers['GameDate'].astype(str) + home_away_no_double_headers['HomeTeam']\n",
    "# # home_away_no_double_headers['OpeningHomeOddsSpreadRatio'] = home_away_no_double_headers['OpeningHomeOdds']/home_away_no_double_headers['OpeningHomeSpread']\n",
    "# # home_away_no_double_headers['HomeOddsSpreadRatio'] = home_away_no_double_headers['HomeOdds']/home_away_no_double_headers['HomeSpread']\n",
    "# # home_away_no_double_headers['OpeningAwayOddsSpreadRatio'] = home_away_no_double_headers['OpeningAwayOdds']/home_away_no_double_headers['OpeningAwaySpread']\n",
    "# # home_away_no_double_headers['AwayOddsSpreadRatio'] = home_away_no_double_headers['AwayOdds']/home_away_no_double_headers['AwaySpread']\n",
    "\n",
    "################ for first 5 innings total ####################    \n",
    "\n",
    "\n",
    "df1 = pd.read_csv('big_odds_20190521_thru_20190929.csv')\n",
    "first_5_total = df1.loc[df1['market_id']==398].sort_values(by=['datetime','event_id'])\n",
    "display(first_5_total)\n",
    "\n",
    "first_5_total = first_5_total[['event_id','opening_spread_total','spread_total','opening_decimal_odds','decimal_odds']]\n",
    "\n",
    "\n",
    "first_5_total = first_5_total.rename(columns={'opening_spread_total':'OpeningTotal','spread_total':'Total','opening_decimal_odds':'OpeningTotalOdds','decimal_odds':'TotalOdds'})\n",
    "\n",
    "\n",
    "\n",
    "df2 = pd.read_csv('adv_stats_plus_spreads_052119_thru_092919_corrected.csv')\n",
    "\n",
    "display(df2)\n",
    "df2 = pd.merge_ordered(df2,first_5_total,on='event_id')\n",
    "df2 = df2.dropna()\n",
    "display(df2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv('big_odds_everything_20180521_thru_20180929.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "scrolled": true
   },
   "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>index</th>\n",
       "      <th>HomeTeam</th>\n",
       "      <th>AwayTeam</th>\n",
       "      <th>GameDate</th>\n",
       "      <th>GameTime</th>\n",
       "      <th>HomeOPS</th>\n",
       "      <th>AwayOPS</th>\n",
       "      <th>HomewRCPlus</th>\n",
       "      <th>AwaywRCPlus</th>\n",
       "      <th>HomePitcherName</th>\n",
       "      <th>...</th>\n",
       "      <th>AwayPitcherGS</th>\n",
       "      <th>HomeFIP</th>\n",
       "      <th>AwayFIP</th>\n",
       "      <th>HomexFIP</th>\n",
       "      <th>AwayxFIP</th>\n",
       "      <th>HomeScoreAfter5</th>\n",
       "      <th>AwayScoreAfter5</th>\n",
       "      <th>HomeTotalScore</th>\n",
       "      <th>AwayTotalScore</th>\n",
       "      <th>HomePlusDate</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>346</td>\n",
       "      <td>Washington Nationals</td>\n",
       "      <td>New York Yankees</td>\n",
       "      <td>2018-05-15</td>\n",
       "      <td>23:05:00</td>\n",
       "      <td>0.641747</td>\n",
       "      <td>0.800546</td>\n",
       "      <td>68.129091</td>\n",
       "      <td>114.971154</td>\n",
       "      <td>Gio Gonzalez</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.84</td>\n",
       "      <td>6.40</td>\n",
       "      <td>4.34</td>\n",
       "      <td>3.76</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2018-05-15Washington Nationals</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>6</td>\n",
       "      <td>Chicago White Sox</td>\n",
       "      <td>Baltimore Orioles</td>\n",
       "      <td>2018-05-21</td>\n",
       "      <td>00:10:00</td>\n",
       "      <td>0.782647</td>\n",
       "      <td>0.768364</td>\n",
       "      <td>112.218950</td>\n",
       "      <td>106.625990</td>\n",
       "      <td>Hector Santiago</td>\n",
       "      <td>...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6.26</td>\n",
       "      <td>5.71</td>\n",
       "      <td>6.06</td>\n",
       "      <td>4.81</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2018-05-21Chicago White Sox</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>8</td>\n",
       "      <td>Los Angeles Dodgers</td>\n",
       "      <td>Colorado Rockies</td>\n",
       "      <td>2018-05-21</td>\n",
       "      <td>02:10:00</td>\n",
       "      <td>0.760405</td>\n",
       "      <td>0.792284</td>\n",
       "      <td>108.168360</td>\n",
       "      <td>99.401760</td>\n",
       "      <td>Walker Buehler</td>\n",
       "      <td>...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2.24</td>\n",
       "      <td>4.28</td>\n",
       "      <td>2.73</td>\n",
       "      <td>3.52</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2018-05-21Los Angeles Dodgers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>Milwaukee Brewers</td>\n",
       "      <td>Arizona Diamondbacks</td>\n",
       "      <td>2018-05-21</td>\n",
       "      <td>23:40:00</td>\n",
       "      <td>0.748855</td>\n",
       "      <td>0.599897</td>\n",
       "      <td>99.846924</td>\n",
       "      <td>61.242784</td>\n",
       "      <td>Chase Anderson</td>\n",
       "      <td>...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6.27</td>\n",
       "      <td>2.31</td>\n",
       "      <td>5.86</td>\n",
       "      <td>2.76</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2018-05-21Milwaukee Brewers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Minnesota Twins</td>\n",
       "      <td>Detroit Tigers</td>\n",
       "      <td>2018-05-21</td>\n",
       "      <td>00:10:00</td>\n",
       "      <td>0.750052</td>\n",
       "      <td>0.756209</td>\n",
       "      <td>102.058968</td>\n",
       "      <td>102.593301</td>\n",
       "      <td>Jose Berrios</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.97</td>\n",
       "      <td>6.16</td>\n",
       "      <td>4.86</td>\n",
       "      <td>5.59</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2018-05-21Minnesota Twins</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1556</th>\n",
       "      <td>1552</td>\n",
       "      <td>Philadelphia Phillies</td>\n",
       "      <td>Atlanta Braves</td>\n",
       "      <td>2018-09-29</td>\n",
       "      <td>23:05:00</td>\n",
       "      <td>0.682352</td>\n",
       "      <td>0.785181</td>\n",
       "      <td>84.520202</td>\n",
       "      <td>108.720497</td>\n",
       "      <td>Aaron Nola</td>\n",
       "      <td>...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.31</td>\n",
       "      <td>2.94</td>\n",
       "      <td>2.84</td>\n",
       "      <td>3.74</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2018-09-29Philadelphia Phillies</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1557</th>\n",
       "      <td>1558</td>\n",
       "      <td>San Diego Padres</td>\n",
       "      <td>Arizona Diamondbacks</td>\n",
       "      <td>2018-09-29</td>\n",
       "      <td>00:40:00</td>\n",
       "      <td>0.715550</td>\n",
       "      <td>0.685843</td>\n",
       "      <td>94.774823</td>\n",
       "      <td>81.771368</td>\n",
       "      <td>Jacob Nix</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>6.49</td>\n",
       "      <td>5.65</td>\n",
       "      <td>5.74</td>\n",
       "      <td>5.22</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2018-09-29San Diego Padres</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1558</th>\n",
       "      <td>1549</td>\n",
       "      <td>San Francisco Giants</td>\n",
       "      <td>Los Angeles Dodgers</td>\n",
       "      <td>2018-09-29</td>\n",
       "      <td>20:05:00</td>\n",
       "      <td>0.642960</td>\n",
       "      <td>0.879029</td>\n",
       "      <td>73.706577</td>\n",
       "      <td>139.350217</td>\n",
       "      <td>Dereck Rodriguez</td>\n",
       "      <td>...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4.02</td>\n",
       "      <td>4.75</td>\n",
       "      <td>5.26</td>\n",
       "      <td>4.07</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2018-09-29San Francisco Giants</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1559</th>\n",
       "      <td>1560</td>\n",
       "      <td>Seattle Mariners</td>\n",
       "      <td>Texas Rangers</td>\n",
       "      <td>2018-09-29</td>\n",
       "      <td>01:10:00</td>\n",
       "      <td>0.742776</td>\n",
       "      <td>0.716065</td>\n",
       "      <td>110.014514</td>\n",
       "      <td>84.599327</td>\n",
       "      <td>James Paxton</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.43</td>\n",
       "      <td>7.69</td>\n",
       "      <td>2.86</td>\n",
       "      <td>4.94</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2018-09-29Seattle Mariners</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1560</th>\n",
       "      <td>1551</td>\n",
       "      <td>Tampa Bay Rays</td>\n",
       "      <td>Toronto Blue Jays</td>\n",
       "      <td>2018-09-29</td>\n",
       "      <td>22:10:00</td>\n",
       "      <td>0.804806</td>\n",
       "      <td>0.794868</td>\n",
       "      <td>122.257549</td>\n",
       "      <td>113.784223</td>\n",
       "      <td>Blake Snell</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.89</td>\n",
       "      <td>2.50</td>\n",
       "      <td>1.85</td>\n",
       "      <td>3.59</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2018-09-29Tampa Bay Rays</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1561 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      index               HomeTeam              AwayTeam    GameDate  \\\n",
       "0       346   Washington Nationals      New York Yankees  2018-05-15   \n",
       "1         6      Chicago White Sox     Baltimore Orioles  2018-05-21   \n",
       "2         8    Los Angeles Dodgers      Colorado Rockies  2018-05-21   \n",
       "3         3      Milwaukee Brewers  Arizona Diamondbacks  2018-05-21   \n",
       "4         5        Minnesota Twins        Detroit Tigers  2018-05-21   \n",
       "...     ...                    ...                   ...         ...   \n",
       "1556   1552  Philadelphia Phillies        Atlanta Braves  2018-09-29   \n",
       "1557   1558       San Diego Padres  Arizona Diamondbacks  2018-09-29   \n",
       "1558   1549   San Francisco Giants   Los Angeles Dodgers  2018-09-29   \n",
       "1559   1560       Seattle Mariners         Texas Rangers  2018-09-29   \n",
       "1560   1551         Tampa Bay Rays     Toronto Blue Jays  2018-09-29   \n",
       "\n",
       "      GameTime   HomeOPS   AwayOPS  HomewRCPlus  AwaywRCPlus  \\\n",
       "0     23:05:00  0.641747  0.800546    68.129091   114.971154   \n",
       "1     00:10:00  0.782647  0.768364   112.218950   106.625990   \n",
       "2     02:10:00  0.760405  0.792284   108.168360    99.401760   \n",
       "3     23:40:00  0.748855  0.599897    99.846924    61.242784   \n",
       "4     00:10:00  0.750052  0.756209   102.058968   102.593301   \n",
       "...        ...       ...       ...          ...          ...   \n",
       "1556  23:05:00  0.682352  0.785181    84.520202   108.720497   \n",
       "1557  00:40:00  0.715550  0.685843    94.774823    81.771368   \n",
       "1558  20:05:00  0.642960  0.879029    73.706577   139.350217   \n",
       "1559  01:10:00  0.742776  0.716065   110.014514    84.599327   \n",
       "1560  22:10:00  0.804806  0.794868   122.257549   113.784223   \n",
       "\n",
       "       HomePitcherName  ...  AwayPitcherGS  HomeFIP AwayFIP  HomexFIP  \\\n",
       "0         Gio Gonzalez  ...            4.0     4.84    6.40      4.34   \n",
       "1      Hector Santiago  ...            5.0     6.26    5.71      6.06   \n",
       "2       Walker Buehler  ...            5.0     2.24    4.28      2.73   \n",
       "3       Chase Anderson  ...            5.0     6.27    2.31      5.86   \n",
       "4         Jose Berrios  ...            1.0     5.97    6.16      4.86   \n",
       "...                ...  ...            ...      ...     ...       ...   \n",
       "1556        Aaron Nola  ...            5.0     5.31    2.94      2.84   \n",
       "1557         Jacob Nix  ...            4.0     6.49    5.65      5.74   \n",
       "1558  Dereck Rodriguez  ...            5.0     4.02    4.75      5.26   \n",
       "1559      James Paxton  ...            3.0     5.43    7.69      2.86   \n",
       "1560       Blake Snell  ...            4.0     1.89    2.50      1.85   \n",
       "\n",
       "      AwayxFIP  HomeScoreAfter5  AwayScoreAfter5  HomeTotalScore  \\\n",
       "0         3.76              3.0              3.0             5.0   \n",
       "1         4.81              1.0              2.0             2.0   \n",
       "2         3.52              1.0              1.0             1.0   \n",
       "3         2.76              3.0              1.0             4.0   \n",
       "4         5.59              2.0              2.0             4.0   \n",
       "...        ...              ...              ...             ...   \n",
       "1556      3.74              0.0              0.0             3.0   \n",
       "1557      5.22              3.0              4.0             4.0   \n",
       "1558      4.07              5.0              5.0             6.0   \n",
       "1559      4.94              1.0              1.0             4.0   \n",
       "1560      3.59              1.0              1.0             4.0   \n",
       "\n",
       "      AwayTotalScore                     HomePlusDate  \n",
       "0                3.0   2018-05-15Washington Nationals  \n",
       "1                3.0      2018-05-21Chicago White Sox  \n",
       "2                2.0    2018-05-21Los Angeles Dodgers  \n",
       "3                2.0      2018-05-21Milwaukee Brewers  \n",
       "4                2.0        2018-05-21Minnesota Twins  \n",
       "...              ...                              ...  \n",
       "1556             0.0  2018-09-29Philadelphia Phillies  \n",
       "1557             5.0       2018-09-29San Diego Padres  \n",
       "1558            10.0   2018-09-29San Francisco Giants  \n",
       "1559             1.0       2018-09-29Seattle Mariners  \n",
       "1560             3.0         2018-09-29Tampa Bay Rays  \n",
       "\n",
       "[1561 rows x 24 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "baseball_stats = pd.read_csv('mlbdata_052118_092918_adv.csv')\n",
    "baseball_stats = baseball_stats.sort_values(by=['GameDate','HomeTeam']).reset_index() \n",
    "baseball_stats['HomePlusDate'] = baseball_stats['GameDate'].astype(str) + baseball_stats['HomeTeam']\n",
    "baseball_stats"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "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>index_x</th>\n",
       "      <th>HomeTeam_x</th>\n",
       "      <th>AwayTeam_x</th>\n",
       "      <th>GameDate_x</th>\n",
       "      <th>GameTime</th>\n",
       "      <th>HomeOPS</th>\n",
       "      <th>AwayOPS</th>\n",
       "      <th>HomewRCPlus</th>\n",
       "      <th>AwaywRCPlus</th>\n",
       "      <th>HomePitcherName</th>\n",
       "      <th>...</th>\n",
       "      <th>OpeningHomeOdds</th>\n",
       "      <th>HomeOdds</th>\n",
       "      <th>OpeningHomeSpread</th>\n",
       "      <th>HomeSpread</th>\n",
       "      <th>GameTime_y</th>\n",
       "      <th>AwayTeam_y</th>\n",
       "      <th>OpeningAwayOdds</th>\n",
       "      <th>AwayOdds</th>\n",
       "      <th>OpeningAwaySpread</th>\n",
       "      <th>AwaySpread</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>6.0</td>\n",
       "      <td>Chicago White Sox</td>\n",
       "      <td>Baltimore Orioles</td>\n",
       "      <td>2018-05-21</td>\n",
       "      <td>00:10:00</td>\n",
       "      <td>0.782647</td>\n",
       "      <td>0.768364</td>\n",
       "      <td>112.218950</td>\n",
       "      <td>106.625990</td>\n",
       "      <td>Hector Santiago</td>\n",
       "      <td>...</td>\n",
       "      <td>1.95</td>\n",
       "      <td>1.67</td>\n",
       "      <td>6.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>09:45:45</td>\n",
       "      <td>Baltimore Orioles</td>\n",
       "      <td>1.87</td>\n",
       "      <td>2.3</td>\n",
       "      <td>6.5</td>\n",
       "      <td>-0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>8.0</td>\n",
       "      <td>Los Angeles Dodgers</td>\n",
       "      <td>Colorado Rockies</td>\n",
       "      <td>2018-05-21</td>\n",
       "      <td>02:10:00</td>\n",
       "      <td>0.760405</td>\n",
       "      <td>0.792284</td>\n",
       "      <td>108.168360</td>\n",
       "      <td>99.401760</td>\n",
       "      <td>Walker Buehler</td>\n",
       "      <td>...</td>\n",
       "      <td>1.87</td>\n",
       "      <td>1.8</td>\n",
       "      <td>4.5</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>19:35:18</td>\n",
       "      <td>Colorado Rockies</td>\n",
       "      <td>1.95</td>\n",
       "      <td>2.05</td>\n",
       "      <td>4.5</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3.0</td>\n",
       "      <td>Milwaukee Brewers</td>\n",
       "      <td>Arizona Diamondbacks</td>\n",
       "      <td>2018-05-21</td>\n",
       "      <td>23:40:00</td>\n",
       "      <td>0.748855</td>\n",
       "      <td>0.599897</td>\n",
       "      <td>99.846924</td>\n",
       "      <td>61.242784</td>\n",
       "      <td>Chase Anderson</td>\n",
       "      <td>...</td>\n",
       "      <td>2.3</td>\n",
       "      <td>1.91</td>\n",
       "      <td>0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>15:46:54</td>\n",
       "      <td>Arizona Diamondbacks</td>\n",
       "      <td>1.69</td>\n",
       "      <td>1.91</td>\n",
       "      <td>0</td>\n",
       "      <td>-0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Minnesota Twins</td>\n",
       "      <td>Detroit Tigers</td>\n",
       "      <td>2018-05-21</td>\n",
       "      <td>00:10:00</td>\n",
       "      <td>0.750052</td>\n",
       "      <td>0.756209</td>\n",
       "      <td>102.058968</td>\n",
       "      <td>102.593301</td>\n",
       "      <td>Jose Berrios</td>\n",
       "      <td>...</td>\n",
       "      <td>2.02</td>\n",
       "      <td>1.69</td>\n",
       "      <td>0</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>09:45:54</td>\n",
       "      <td>Detroit Tigers</td>\n",
       "      <td>1.85</td>\n",
       "      <td>2.25</td>\n",
       "      <td>0</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2.0</td>\n",
       "      <td>New York Mets</td>\n",
       "      <td>Miami Marlins</td>\n",
       "      <td>2018-05-21</td>\n",
       "      <td>23:10:00</td>\n",
       "      <td>0.738696</td>\n",
       "      <td>0.743139</td>\n",
       "      <td>104.647860</td>\n",
       "      <td>105.922674</td>\n",
       "      <td>Jason Vargas</td>\n",
       "      <td>...</td>\n",
       "      <td>2.6</td>\n",
       "      <td>2.15</td>\n",
       "      <td>0</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>17:30:57</td>\n",
       "      <td>Miami Marlins</td>\n",
       "      <td>1.57</td>\n",
       "      <td>1.74</td>\n",
       "      <td>0</td>\n",
       "      <td>0.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",
       "      <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>1682</th>\n",
       "      <td>1538.0</td>\n",
       "      <td>New York Mets</td>\n",
       "      <td>Miami Marlins</td>\n",
       "      <td>2018-09-28</td>\n",
       "      <td>23:10:00</td>\n",
       "      <td>0.810867</td>\n",
       "      <td>0.655152</td>\n",
       "      <td>123.846554</td>\n",
       "      <td>82.024958</td>\n",
       "      <td>Corey Oswalt</td>\n",
       "      <td>...</td>\n",
       "      <td>2.05</td>\n",
       "      <td>1.95</td>\n",
       "      <td>4.5</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>17:05:56</td>\n",
       "      <td>Miami Marlins</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.87</td>\n",
       "      <td>4.5</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1683</th>\n",
       "      <td>1536.0</td>\n",
       "      <td>Philadelphia Phillies</td>\n",
       "      <td>Atlanta Braves</td>\n",
       "      <td>2018-09-28</td>\n",
       "      <td>23:05:00</td>\n",
       "      <td>0.668939</td>\n",
       "      <td>0.740907</td>\n",
       "      <td>80.331606</td>\n",
       "      <td>96.545682</td>\n",
       "      <td>Jerad Eickhoff</td>\n",
       "      <td>...</td>\n",
       "      <td>2.05</td>\n",
       "      <td>1.87</td>\n",
       "      <td>5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>14:35:24</td>\n",
       "      <td>Atlanta Braves</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.95</td>\n",
       "      <td>5</td>\n",
       "      <td>-0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1684</th>\n",
       "      <td>1544.0</td>\n",
       "      <td>San Diego Padres</td>\n",
       "      <td>Arizona Diamondbacks</td>\n",
       "      <td>2018-09-28</td>\n",
       "      <td>02:10:00</td>\n",
       "      <td>0.752829</td>\n",
       "      <td>0.742224</td>\n",
       "      <td>104.932231</td>\n",
       "      <td>95.685575</td>\n",
       "      <td>Eric Lauer</td>\n",
       "      <td>...</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.91</td>\n",
       "      <td>0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>08:40:27</td>\n",
       "      <td>Arizona Diamondbacks</td>\n",
       "      <td>2.1</td>\n",
       "      <td>1.91</td>\n",
       "      <td>0</td>\n",
       "      <td>-0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1686</th>\n",
       "      <td>1545.0</td>\n",
       "      <td>Seattle Mariners</td>\n",
       "      <td>Texas Rangers</td>\n",
       "      <td>2018-09-28</td>\n",
       "      <td>02:10:00</td>\n",
       "      <td>0.748711</td>\n",
       "      <td>0.691074</td>\n",
       "      <td>108.381737</td>\n",
       "      <td>78.990691</td>\n",
       "      <td>Wade LeBlanc</td>\n",
       "      <td>...</td>\n",
       "      <td>1.83</td>\n",
       "      <td>1.8</td>\n",
       "      <td>5</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>08:41:08</td>\n",
       "      <td>Texas Rangers</td>\n",
       "      <td>2</td>\n",
       "      <td>2.05</td>\n",
       "      <td>5</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1687</th>\n",
       "      <td>1537.0</td>\n",
       "      <td>Tampa Bay Rays</td>\n",
       "      <td>Toronto Blue Jays</td>\n",
       "      <td>2018-09-28</td>\n",
       "      <td>23:10:00</td>\n",
       "      <td>0.834832</td>\n",
       "      <td>0.697186</td>\n",
       "      <td>129.357567</td>\n",
       "      <td>87.146040</td>\n",
       "      <td>Tyler Glasnow</td>\n",
       "      <td>...</td>\n",
       "      <td>1.8</td>\n",
       "      <td>1.83</td>\n",
       "      <td>4.5</td>\n",
       "      <td>-0.5</td>\n",
       "      <td>08:13:12</td>\n",
       "      <td>Toronto Blue Jays</td>\n",
       "      <td>2.05</td>\n",
       "      <td>2</td>\n",
       "      <td>4.5</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1497 rows × 39 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      index_x             HomeTeam_x            AwayTeam_x  GameDate_x  \\\n",
       "1         6.0      Chicago White Sox     Baltimore Orioles  2018-05-21   \n",
       "2         8.0    Los Angeles Dodgers      Colorado Rockies  2018-05-21   \n",
       "3         3.0      Milwaukee Brewers  Arizona Diamondbacks  2018-05-21   \n",
       "4         5.0        Minnesota Twins        Detroit Tigers  2018-05-21   \n",
       "5         2.0          New York Mets         Miami Marlins  2018-05-21   \n",
       "...       ...                    ...                   ...         ...   \n",
       "1682   1538.0          New York Mets         Miami Marlins  2018-09-28   \n",
       "1683   1536.0  Philadelphia Phillies        Atlanta Braves  2018-09-28   \n",
       "1684   1544.0       San Diego Padres  Arizona Diamondbacks  2018-09-28   \n",
       "1686   1545.0       Seattle Mariners         Texas Rangers  2018-09-28   \n",
       "1687   1537.0         Tampa Bay Rays     Toronto Blue Jays  2018-09-28   \n",
       "\n",
       "      GameTime   HomeOPS   AwayOPS  HomewRCPlus  AwaywRCPlus  HomePitcherName  \\\n",
       "1     00:10:00  0.782647  0.768364   112.218950   106.625990  Hector Santiago   \n",
       "2     02:10:00  0.760405  0.792284   108.168360    99.401760   Walker Buehler   \n",
       "3     23:40:00  0.748855  0.599897    99.846924    61.242784   Chase Anderson   \n",
       "4     00:10:00  0.750052  0.756209   102.058968   102.593301     Jose Berrios   \n",
       "5     23:10:00  0.738696  0.743139   104.647860   105.922674     Jason Vargas   \n",
       "...        ...       ...       ...          ...          ...              ...   \n",
       "1682  23:10:00  0.810867  0.655152   123.846554    82.024958     Corey Oswalt   \n",
       "1683  23:05:00  0.668939  0.740907    80.331606    96.545682   Jerad Eickhoff   \n",
       "1684  02:10:00  0.752829  0.742224   104.932231    95.685575       Eric Lauer   \n",
       "1686  02:10:00  0.748711  0.691074   108.381737    78.990691     Wade LeBlanc   \n",
       "1687  23:10:00  0.834832  0.697186   129.357567    87.146040    Tyler Glasnow   \n",
       "\n",
       "      ...  OpeningHomeOdds  HomeOdds OpeningHomeSpread  HomeSpread  \\\n",
       "1     ...             1.95      1.67               6.5         0.5   \n",
       "2     ...             1.87       1.8               4.5        -0.5   \n",
       "3     ...              2.3      1.91                 0         0.5   \n",
       "4     ...             2.02      1.69                 0        -0.5   \n",
       "5     ...              2.6      2.15                 0        -0.5   \n",
       "...   ...              ...       ...               ...         ...   \n",
       "1682  ...             2.05      1.95               4.5        -0.5   \n",
       "1683  ...             2.05      1.87                 5         0.5   \n",
       "1684  ...              1.8      1.91                 0         0.5   \n",
       "1686  ...             1.83       1.8                 5        -0.5   \n",
       "1687  ...              1.8      1.83               4.5        -0.5   \n",
       "\n",
       "      GameTime_y            AwayTeam_y  OpeningAwayOdds  AwayOdds  \\\n",
       "1       09:45:45     Baltimore Orioles             1.87       2.3   \n",
       "2       19:35:18      Colorado Rockies             1.95      2.05   \n",
       "3       15:46:54  Arizona Diamondbacks             1.69      1.91   \n",
       "4       09:45:54        Detroit Tigers             1.85      2.25   \n",
       "5       17:30:57         Miami Marlins             1.57      1.74   \n",
       "...          ...                   ...              ...       ...   \n",
       "1682    17:05:56         Miami Marlins              1.8      1.87   \n",
       "1683    14:35:24        Atlanta Braves              1.8      1.95   \n",
       "1684    08:40:27  Arizona Diamondbacks              2.1      1.91   \n",
       "1686    08:41:08         Texas Rangers                2      2.05   \n",
       "1687    08:13:12     Toronto Blue Jays             2.05         2   \n",
       "\n",
       "      OpeningAwaySpread  AwaySpread  \n",
       "1                   6.5        -0.5  \n",
       "2                   4.5         0.5  \n",
       "3                     0        -0.5  \n",
       "4                     0         0.5  \n",
       "5                     0         0.5  \n",
       "...                 ...         ...  \n",
       "1682                4.5         0.5  \n",
       "1683                  5        -0.5  \n",
       "1684                  0        -0.5  \n",
       "1686                  5         0.5  \n",
       "1687                4.5         0.5  \n",
       "\n",
       "[1497 rows x 39 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test_b = pd.merge_ordered(baseball_stats,home_away_no_double_headers,on='HomePlusDate')\n",
    "test_b = test_b.dropna()\n",
    "# test_b.to_csv('stats_plus_odds_052121_thru_071021_corrected.csv')\n",
    "test_b.to_csv('adv_stats_plus_spreads_052118_thru_092918_corrected.csv')\n",
    "\n",
    "test_b"
   ]
  },
  {
   "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.9.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}