Horses.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# data_dir = './horses/'\n",
    "# horses_df = pd.read_csv(data_dir + 'horses.csv',\n",
    "#                         usecols=['age', 'sex_id', 'prize_money'])\n",
    "# horse_sexes_df = pd.read_csv(data_dir + 'horse_sexes.csv').set_index('id')\n",
    "# riders_df = pd.read_csv(data_dir + 'riders.csv').set_index('id')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 182,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# Dataset Source: https://www.kaggle.com/gunner38/horseracing\n",
    "tips_df = pd.read_csv('horse_tips.csv', encoding='latin1')\n",
    "tips_df['Bet Type'] = tips_df['Bet Type'].apply(lambda x : 1 if x == 'Win' else 0)\n",
    "tips_df['Result'] = tips_df['Result'].apply(lambda x : 1 if x == 'Win' else 0)\n",
    "\n",
    "horses = np.sort(tips_df['Horse'].unique())\n",
    "tracks = np.sort(tips_df['Track'].unique())\n",
    "\n",
    "tips_df['Horse'] = tips_df['Horse'].apply(lambda x : np.where(horses == x)[0][0])\n",
    "tips_df['Track'] = tips_df['Track'].apply(lambda x : np.where(tracks == x)[0][0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 97,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "tipsters = tips_df['Tipster'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 151,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Success Rate</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Tipster G</th>\n",
       "      <td>0.672414</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tipster C</th>\n",
       "      <td>0.616226</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tipster F</th>\n",
       "      <td>0.520548</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tipster M</th>\n",
       "      <td>0.520376</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tipster N</th>\n",
       "      <td>0.496386</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           Success Rate\n",
       "Tipster G      0.672414\n",
       "Tipster C      0.616226\n",
       "Tipster F      0.520548\n",
       "Tipster M      0.520376\n",
       "Tipster N      0.496386"
      ]
     },
     "execution_count": 151,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "success_rates = dict()\n",
    "for tipster in tipsters:\n",
    "    successes = tips_df[(tips_df['Tipster'] == tipster) & (tips_df['Bet Type'] == tips_df['Result'])].shape[0]\n",
    "    total = tips_df[(tips_df['Tipster'] == tipster)].shape[0]\n",
    "    success_rates[tipster] = successes/total\n",
    "successes_df = pd.DataFrame(pd.Series(success_rates), columns=['Success Rate']).sort_values(by='Success Rate', ascending=False)\n",
    "successes_df.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 149,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "X_G = tips_df[tips_df.Tipster=='Tipster G']\n",
    "X_C = tips_df[tips_df.Tipster=='Tipster C']\n",
    "X_F = tips_df[tips_df.Tipster=='Tipster F']\n",
    "X_M = tips_df[tips_df.Tipster=='Tipster M']\n",
    "X_N = tips_df[tips_df.Tipster=='Tipster N']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "We model the online learning algorithm as follows.\n",
    "\n",
    "In each round, we are given a betting scheme from each tipster, drawn uniformly at random from the pool of possible schemes. We model the quality function (the return) using OLS on the features. The true return is computed as if ten dollars were bet in any scheme from the odds and the true result (i.e. 10 * the odds)."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 183,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>UID</th>\n",
       "      <th>ID</th>\n",
       "      <th>Tipster</th>\n",
       "      <th>Date</th>\n",
       "      <th>Track</th>\n",
       "      <th>Horse</th>\n",
       "      <th>Bet Type</th>\n",
       "      <th>Odds</th>\n",
       "      <th>Result</th>\n",
       "      <th>TipsterActive</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Tipster A</td>\n",
       "      <td>24/07/2015</td>\n",
       "      <td>2</td>\n",
       "      <td>5158</td>\n",
       "      <td>1</td>\n",
       "      <td>8.00</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>Tipster A</td>\n",
       "      <td>24/07/2015</td>\n",
       "      <td>96</td>\n",
       "      <td>13108</td>\n",
       "      <td>1</td>\n",
       "      <td>4.50</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>Tipster A</td>\n",
       "      <td>24/07/2015</td>\n",
       "      <td>114</td>\n",
       "      <td>13411</td>\n",
       "      <td>1</td>\n",
       "      <td>7.00</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>Tipster A</td>\n",
       "      <td>24/07/2015</td>\n",
       "      <td>74</td>\n",
       "      <td>8976</td>\n",
       "      <td>1</td>\n",
       "      <td>5.00</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>Tipster A</td>\n",
       "      <td>25/07/2015</td>\n",
       "      <td>2</td>\n",
       "      <td>10554</td>\n",
       "      <td>1</td>\n",
       "      <td>4.33</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>Tipster A</td>\n",
       "      <td>25/07/2015</td>\n",
       "      <td>114</td>\n",
       "      <td>327</td>\n",
       "      <td>1</td>\n",
       "      <td>6.00</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>Tipster A</td>\n",
       "      <td>25/07/2015</td>\n",
       "      <td>73</td>\n",
       "      <td>9791</td>\n",
       "      <td>1</td>\n",
       "      <td>6.00</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>Tipster A</td>\n",
       "      <td>25/07/2015</td>\n",
       "      <td>62</td>\n",
       "      <td>2019</td>\n",
       "      <td>1</td>\n",
       "      <td>6.00</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>Tipster A</td>\n",
       "      <td>26/07/2015</td>\n",
       "      <td>12</td>\n",
       "      <td>12101</td>\n",
       "      <td>1</td>\n",
       "      <td>5.50</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>Tipster A</td>\n",
       "      <td>26/07/2015</td>\n",
       "      <td>80</td>\n",
       "      <td>115</td>\n",
       "      <td>1</td>\n",
       "      <td>2.00</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>Tipster A</td>\n",
       "      <td>26/07/2015</td>\n",
       "      <td>104</td>\n",
       "      <td>8878</td>\n",
       "      <td>0</td>\n",
       "      <td>10.00</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>Tipster A</td>\n",
       "      <td>01/08/2015</td>\n",
       "      <td>96</td>\n",
       "      <td>5508</td>\n",
       "      <td>1</td>\n",
       "      <td>8.00</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>Tipster A</td>\n",
       "      <td>01/08/2015</td>\n",
       "      <td>47</td>\n",
       "      <td>4484</td>\n",
       "      <td>1</td>\n",
       "      <td>6.00</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>Tipster A</td>\n",
       "      <td>02/08/2015</td>\n",
       "      <td>18</td>\n",
       "      <td>6602</td>\n",
       "      <td>1</td>\n",
       "      <td>6.00</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "      <td>Tipster A</td>\n",
       "      <td>04/08/2015</td>\n",
       "      <td>85</td>\n",
       "      <td>15390</td>\n",
       "      <td>1</td>\n",
       "      <td>3.25</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>Tipster A</td>\n",
       "      <td>04/08/2015</td>\n",
       "      <td>14</td>\n",
       "      <td>7851</td>\n",
       "      <td>1</td>\n",
       "      <td>2.75</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>17</td>\n",
       "      <td>17</td>\n",
       "      <td>Tipster A</td>\n",
       "      <td>04/08/2015</td>\n",
       "      <td>16</td>\n",
       "      <td>1554</td>\n",
       "      <td>1</td>\n",
       "      <td>3.50</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>Tipster A</td>\n",
       "      <td>05/08/2015</td>\n",
       "      <td>11</td>\n",
       "      <td>12537</td>\n",
       "      <td>1</td>\n",
       "      <td>3.25</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>19</td>\n",
       "      <td>19</td>\n",
       "      <td>Tipster A</td>\n",
       "      <td>05/08/2015</td>\n",
       "      <td>73</td>\n",
       "      <td>10307</td>\n",
       "      <td>1</td>\n",
       "      <td>3.25</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>Tipster A</td>\n",
       "      <td>06/08/2015</td>\n",
       "      <td>111</td>\n",
       "      <td>6326</td>\n",
       "      <td>0</td>\n",
       "      <td>11.00</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>21</td>\n",
       "      <td>21</td>\n",
       "      <td>Tipster A</td>\n",
       "      <td>14/08/2015</td>\n",
       "      <td>74</td>\n",
       "      <td>3358</td>\n",
       "      <td>1</td>\n",
       "      <td>1.80</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22</td>\n",
       "      <td>22</td>\n",
       "      <td>Tipster A</td>\n",
       "      <td>15/08/2015</td>\n",
       "      <td>72</td>\n",
       "      <td>15487</td>\n",
       "      <td>1</td>\n",
       "      <td>4.00</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "      <td>Tipster A</td>\n",
       "      <td>15/08/2015</td>\n",
       "      <td>72</td>\n",
       "      <td>2269</td>\n",
       "      <td>0</td>\n",
       "      <td>7.50</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>24</td>\n",
       "      <td>24</td>\n",
       "      <td>Tipster A</td>\n",
       "      <td>15/08/2015</td>\n",
       "      <td>72</td>\n",
       "      <td>304</td>\n",
       "      <td>1</td>\n",
       "      <td>4.50</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>25</td>\n",
       "      <td>25</td>\n",
       "      <td>Tipster A</td>\n",
       "      <td>15/08/2015</td>\n",
       "      <td>66</td>\n",
       "      <td>14466</td>\n",
       "      <td>1</td>\n",
       "      <td>3.25</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "      <td>Tipster A</td>\n",
       "      <td>16/08/2015</td>\n",
       "      <td>102</td>\n",
       "      <td>10427</td>\n",
       "      <td>0</td>\n",
       "      <td>8.00</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "      <td>Tipster A</td>\n",
       "      <td>16/08/2015</td>\n",
       "      <td>102</td>\n",
       "      <td>6517</td>\n",
       "      <td>1</td>\n",
       "      <td>2.50</td>\n",
       "      <td>0</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>28</td>\n",
       "      <td>28</td>\n",
       "      <td>Tipster A</td>\n",
       "      <td>18/08/2015</td>\n",
       "      <td>59</td>\n",
       "      <td>4285</td>\n",
       "      <td>1</td>\n",
       "      <td>11.00</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>29</td>\n",
       "      <td>29</td>\n",
       "      <td>Tipster A</td>\n",
       "      <td>18/08/2015</td>\n",
       "      <td>16</td>\n",
       "      <td>5607</td>\n",
       "      <td>0</td>\n",
       "      <td>11.00</td>\n",
       "      <td>1</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>30</td>\n",
       "      <td>30</td>\n",
       "      <td>Tipster A</td>\n",
       "      <td>18/08/2015</td>\n",
       "      <td>16</td>\n",
       "      <td>14522</td>\n",
       "      <td>1</td>\n",
       "      <td>3.25</td>\n",
       "      <td>0</td>\n",
       "      <td>True</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38218</th>\n",
       "      <td>38219</td>\n",
       "      <td>580</td>\n",
       "      <td>Tipster E1</td>\n",
       "      <td>30/01/2016</td>\n",
       "      <td>26</td>\n",
       "      <td>7209</td>\n",
       "      <td>1</td>\n",
       "      <td>3.00</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38219</th>\n",
       "      <td>38220</td>\n",
       "      <td>581</td>\n",
       "      <td>Tipster E1</td>\n",
       "      <td>03/02/2016</td>\n",
       "      <td>73</td>\n",
       "      <td>14716</td>\n",
       "      <td>0</td>\n",
       "      <td>34.00</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38220</th>\n",
       "      <td>38221</td>\n",
       "      <td>582</td>\n",
       "      <td>Tipster E1</td>\n",
       "      <td>10/02/2016</td>\n",
       "      <td>12</td>\n",
       "      <td>14716</td>\n",
       "      <td>0</td>\n",
       "      <td>15.00</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38221</th>\n",
       "      <td>38222</td>\n",
       "      <td>583</td>\n",
       "      <td>Tipster E1</td>\n",
       "      <td>13/02/2016</td>\n",
       "      <td>111</td>\n",
       "      <td>1384</td>\n",
       "      <td>0</td>\n",
       "      <td>13.00</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38222</th>\n",
       "      <td>38223</td>\n",
       "      <td>584</td>\n",
       "      <td>Tipster E1</td>\n",
       "      <td>14/02/2016</td>\n",
       "      <td>92</td>\n",
       "      <td>4982</td>\n",
       "      <td>1</td>\n",
       "      <td>4.50</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38223</th>\n",
       "      <td>38224</td>\n",
       "      <td>585</td>\n",
       "      <td>Tipster E1</td>\n",
       "      <td>25/02/2016</td>\n",
       "      <td>47</td>\n",
       "      <td>13367</td>\n",
       "      <td>0</td>\n",
       "      <td>11.00</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38224</th>\n",
       "      <td>38225</td>\n",
       "      <td>586</td>\n",
       "      <td>Tipster E1</td>\n",
       "      <td>13/03/2016</td>\n",
       "      <td>106</td>\n",
       "      <td>2723</td>\n",
       "      <td>1</td>\n",
       "      <td>5.50</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38225</th>\n",
       "      <td>38226</td>\n",
       "      <td>587</td>\n",
       "      <td>Tipster E1</td>\n",
       "      <td>13/03/2016</td>\n",
       "      <td>53</td>\n",
       "      <td>8120</td>\n",
       "      <td>0</td>\n",
       "      <td>21.00</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38226</th>\n",
       "      <td>38227</td>\n",
       "      <td>588</td>\n",
       "      <td>Tipster E1</td>\n",
       "      <td>15/03/2016</td>\n",
       "      <td>17</td>\n",
       "      <td>480</td>\n",
       "      <td>1</td>\n",
       "      <td>5.00</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38227</th>\n",
       "      <td>38228</td>\n",
       "      <td>589</td>\n",
       "      <td>Tipster E1</td>\n",
       "      <td>15/03/2016</td>\n",
       "      <td>17</td>\n",
       "      <td>2365</td>\n",
       "      <td>0</td>\n",
       "      <td>26.00</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38228</th>\n",
       "      <td>38229</td>\n",
       "      <td>590</td>\n",
       "      <td>Tipster E1</td>\n",
       "      <td>15/03/2016</td>\n",
       "      <td>17</td>\n",
       "      <td>9238</td>\n",
       "      <td>0</td>\n",
       "      <td>67.00</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38229</th>\n",
       "      <td>38230</td>\n",
       "      <td>591</td>\n",
       "      <td>Tipster E1</td>\n",
       "      <td>17/03/2016</td>\n",
       "      <td>17</td>\n",
       "      <td>1722</td>\n",
       "      <td>1</td>\n",
       "      <td>6.50</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38230</th>\n",
       "      <td>38231</td>\n",
       "      <td>592</td>\n",
       "      <td>Tipster E1</td>\n",
       "      <td>17/03/2016</td>\n",
       "      <td>16</td>\n",
       "      <td>2133</td>\n",
       "      <td>1</td>\n",
       "      <td>6.50</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38231</th>\n",
       "      <td>38232</td>\n",
       "      <td>593</td>\n",
       "      <td>Tipster E1</td>\n",
       "      <td>18/03/2016</td>\n",
       "      <td>17</td>\n",
       "      <td>3129</td>\n",
       "      <td>0</td>\n",
       "      <td>17.00</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38232</th>\n",
       "      <td>38233</td>\n",
       "      <td>594</td>\n",
       "      <td>Tipster E1</td>\n",
       "      <td>18/03/2016</td>\n",
       "      <td>17</td>\n",
       "      <td>8066</td>\n",
       "      <td>1</td>\n",
       "      <td>8.00</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38233</th>\n",
       "      <td>38234</td>\n",
       "      <td>595</td>\n",
       "      <td>Tipster E1</td>\n",
       "      <td>18/03/2016</td>\n",
       "      <td>17</td>\n",
       "      <td>11674</td>\n",
       "      <td>0</td>\n",
       "      <td>11.00</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38234</th>\n",
       "      <td>38235</td>\n",
       "      <td>596</td>\n",
       "      <td>Tipster E1</td>\n",
       "      <td>19/03/2016</td>\n",
       "      <td>54</td>\n",
       "      <td>8847</td>\n",
       "      <td>0</td>\n",
       "      <td>11.00</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38235</th>\n",
       "      <td>38236</td>\n",
       "      <td>597</td>\n",
       "      <td>Tipster E1</td>\n",
       "      <td>20/03/2016</td>\n",
       "      <td>12</td>\n",
       "      <td>9366</td>\n",
       "      <td>1</td>\n",
       "      <td>5.00</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38236</th>\n",
       "      <td>38237</td>\n",
       "      <td>598</td>\n",
       "      <td>Tipster E1</td>\n",
       "      <td>26/03/2016</td>\n",
       "      <td>67</td>\n",
       "      <td>1628</td>\n",
       "      <td>1</td>\n",
       "      <td>7.50</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38237</th>\n",
       "      <td>38238</td>\n",
       "      <td>599</td>\n",
       "      <td>Tipster E1</td>\n",
       "      <td>28/03/2016</td>\n",
       "      <td>35</td>\n",
       "      <td>11945</td>\n",
       "      <td>0</td>\n",
       "      <td>29.00</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38238</th>\n",
       "      <td>38239</td>\n",
       "      <td>600</td>\n",
       "      <td>Tipster E1</td>\n",
       "      <td>30/03/2016</td>\n",
       "      <td>92</td>\n",
       "      <td>1436</td>\n",
       "      <td>1</td>\n",
       "      <td>5.00</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38239</th>\n",
       "      <td>38240</td>\n",
       "      <td>601</td>\n",
       "      <td>Tipster E1</td>\n",
       "      <td>30/03/2016</td>\n",
       "      <td>92</td>\n",
       "      <td>6295</td>\n",
       "      <td>1</td>\n",
       "      <td>6.00</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38240</th>\n",
       "      <td>38241</td>\n",
       "      <td>602</td>\n",
       "      <td>Tipster E1</td>\n",
       "      <td>30/03/2016</td>\n",
       "      <td>34</td>\n",
       "      <td>407</td>\n",
       "      <td>1</td>\n",
       "      <td>4.33</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38241</th>\n",
       "      <td>38242</td>\n",
       "      <td>603</td>\n",
       "      <td>Tipster E1</td>\n",
       "      <td>01/04/2016</td>\n",
       "      <td>107</td>\n",
       "      <td>14141</td>\n",
       "      <td>1</td>\n",
       "      <td>4.50</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38242</th>\n",
       "      <td>38243</td>\n",
       "      <td>604</td>\n",
       "      <td>Tipster E1</td>\n",
       "      <td>01/04/2016</td>\n",
       "      <td>111</td>\n",
       "      <td>5905</td>\n",
       "      <td>1</td>\n",
       "      <td>10.00</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38243</th>\n",
       "      <td>38244</td>\n",
       "      <td>605</td>\n",
       "      <td>Tipster E1</td>\n",
       "      <td>02/04/2016</td>\n",
       "      <td>54</td>\n",
       "      <td>12946</td>\n",
       "      <td>1</td>\n",
       "      <td>7.00</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38244</th>\n",
       "      <td>38245</td>\n",
       "      <td>606</td>\n",
       "      <td>Tipster E1</td>\n",
       "      <td>02/04/2016</td>\n",
       "      <td>26</td>\n",
       "      <td>4591</td>\n",
       "      <td>0</td>\n",
       "      <td>12.00</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38245</th>\n",
       "      <td>38246</td>\n",
       "      <td>607</td>\n",
       "      <td>Tipster E1</td>\n",
       "      <td>02/04/2016</td>\n",
       "      <td>26</td>\n",
       "      <td>6824</td>\n",
       "      <td>1</td>\n",
       "      <td>7.00</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38246</th>\n",
       "      <td>38247</td>\n",
       "      <td>608</td>\n",
       "      <td>Tipster E1</td>\n",
       "      <td>02/04/2016</td>\n",
       "      <td>53</td>\n",
       "      <td>7068</td>\n",
       "      <td>1</td>\n",
       "      <td>4.33</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38247</th>\n",
       "      <td>38248</td>\n",
       "      <td>609</td>\n",
       "      <td>Tipster E1</td>\n",
       "      <td>31/05/2016</td>\n",
       "      <td>82</td>\n",
       "      <td>4015</td>\n",
       "      <td>1</td>\n",
       "      <td>5.00</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>38248 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         UID   ID     Tipster        Date  Track  Horse  Bet Type   Odds  \\\n",
       "0          1    1   Tipster A  24/07/2015      2   5158         1   8.00   \n",
       "1          2    2   Tipster A  24/07/2015     96  13108         1   4.50   \n",
       "2          3    3   Tipster A  24/07/2015    114  13411         1   7.00   \n",
       "3          4    4   Tipster A  24/07/2015     74   8976         1   5.00   \n",
       "4          5    5   Tipster A  25/07/2015      2  10554         1   4.33   \n",
       "5          6    6   Tipster A  25/07/2015    114    327         1   6.00   \n",
       "6          7    7   Tipster A  25/07/2015     73   9791         1   6.00   \n",
       "7          8    8   Tipster A  25/07/2015     62   2019         1   6.00   \n",
       "8          9    9   Tipster A  26/07/2015     12  12101         1   5.50   \n",
       "9         10   10   Tipster A  26/07/2015     80    115         1   2.00   \n",
       "10        11   11   Tipster A  26/07/2015    104   8878         0  10.00   \n",
       "11        12   12   Tipster A  01/08/2015     96   5508         1   8.00   \n",
       "12        13   13   Tipster A  01/08/2015     47   4484         1   6.00   \n",
       "13        14   14   Tipster A  02/08/2015     18   6602         1   6.00   \n",
       "14        15   15   Tipster A  04/08/2015     85  15390         1   3.25   \n",
       "15        16   16   Tipster A  04/08/2015     14   7851         1   2.75   \n",
       "16        17   17   Tipster A  04/08/2015     16   1554         1   3.50   \n",
       "17        18   18   Tipster A  05/08/2015     11  12537         1   3.25   \n",
       "18        19   19   Tipster A  05/08/2015     73  10307         1   3.25   \n",
       "19        20   20   Tipster A  06/08/2015    111   6326         0  11.00   \n",
       "20        21   21   Tipster A  14/08/2015     74   3358         1   1.80   \n",
       "21        22   22   Tipster A  15/08/2015     72  15487         1   4.00   \n",
       "22        23   23   Tipster A  15/08/2015     72   2269         0   7.50   \n",
       "23        24   24   Tipster A  15/08/2015     72    304         1   4.50   \n",
       "24        25   25   Tipster A  15/08/2015     66  14466         1   3.25   \n",
       "25        26   26   Tipster A  16/08/2015    102  10427         0   8.00   \n",
       "26        27   27   Tipster A  16/08/2015    102   6517         1   2.50   \n",
       "27        28   28   Tipster A  18/08/2015     59   4285         1  11.00   \n",
       "28        29   29   Tipster A  18/08/2015     16   5607         0  11.00   \n",
       "29        30   30   Tipster A  18/08/2015     16  14522         1   3.25   \n",
       "...      ...  ...         ...         ...    ...    ...       ...    ...   \n",
       "38218  38219  580  Tipster E1  30/01/2016     26   7209         1   3.00   \n",
       "38219  38220  581  Tipster E1  03/02/2016     73  14716         0  34.00   \n",
       "38220  38221  582  Tipster E1  10/02/2016     12  14716         0  15.00   \n",
       "38221  38222  583  Tipster E1  13/02/2016    111   1384         0  13.00   \n",
       "38222  38223  584  Tipster E1  14/02/2016     92   4982         1   4.50   \n",
       "38223  38224  585  Tipster E1  25/02/2016     47  13367         0  11.00   \n",
       "38224  38225  586  Tipster E1  13/03/2016    106   2723         1   5.50   \n",
       "38225  38226  587  Tipster E1  13/03/2016     53   8120         0  21.00   \n",
       "38226  38227  588  Tipster E1  15/03/2016     17    480         1   5.00   \n",
       "38227  38228  589  Tipster E1  15/03/2016     17   2365         0  26.00   \n",
       "38228  38229  590  Tipster E1  15/03/2016     17   9238         0  67.00   \n",
       "38229  38230  591  Tipster E1  17/03/2016     17   1722         1   6.50   \n",
       "38230  38231  592  Tipster E1  17/03/2016     16   2133         1   6.50   \n",
       "38231  38232  593  Tipster E1  18/03/2016     17   3129         0  17.00   \n",
       "38232  38233  594  Tipster E1  18/03/2016     17   8066         1   8.00   \n",
       "38233  38234  595  Tipster E1  18/03/2016     17  11674         0  11.00   \n",
       "38234  38235  596  Tipster E1  19/03/2016     54   8847         0  11.00   \n",
       "38235  38236  597  Tipster E1  20/03/2016     12   9366         1   5.00   \n",
       "38236  38237  598  Tipster E1  26/03/2016     67   1628         1   7.50   \n",
       "38237  38238  599  Tipster E1  28/03/2016     35  11945         0  29.00   \n",
       "38238  38239  600  Tipster E1  30/03/2016     92   1436         1   5.00   \n",
       "38239  38240  601  Tipster E1  30/03/2016     92   6295         1   6.00   \n",
       "38240  38241  602  Tipster E1  30/03/2016     34    407         1   4.33   \n",
       "38241  38242  603  Tipster E1  01/04/2016    107  14141         1   4.50   \n",
       "38242  38243  604  Tipster E1  01/04/2016    111   5905         1  10.00   \n",
       "38243  38244  605  Tipster E1  02/04/2016     54  12946         1   7.00   \n",
       "38244  38245  606  Tipster E1  02/04/2016     26   4591         0  12.00   \n",
       "38245  38246  607  Tipster E1  02/04/2016     26   6824         1   7.00   \n",
       "38246  38247  608  Tipster E1  02/04/2016     53   7068         1   4.33   \n",
       "38247  38248  609  Tipster E1  31/05/2016     82   4015         1   5.00   \n",
       "\n",
       "       Result TipsterActive  \n",
       "0           0          True  \n",
       "1           0          True  \n",
       "2           0          True  \n",
       "3           0          True  \n",
       "4           1          True  \n",
       "5           0          True  \n",
       "6           0          True  \n",
       "7           0          True  \n",
       "8           0          True  \n",
       "9           0          True  \n",
       "10          0          True  \n",
       "11          0          True  \n",
       "12          0          True  \n",
       "13          0          True  \n",
       "14          1          True  \n",
       "15          0          True  \n",
       "16          0          True  \n",
       "17          0          True  \n",
       "18          0          True  \n",
       "19          0          True  \n",
       "20          0          True  \n",
       "21          0          True  \n",
       "22          0          True  \n",
       "23          1          True  \n",
       "24          0          True  \n",
       "25          0          True  \n",
       "26          0          True  \n",
       "27          1          True  \n",
       "28          1          True  \n",
       "29          0          True  \n",
       "...       ...           ...  \n",
       "38218       0         False  \n",
       "38219       0         False  \n",
       "38220       0         False  \n",
       "38221       1         False  \n",
       "38222       0         False  \n",
       "38223       0         False  \n",
       "38224       0         False  \n",
       "38225       0         False  \n",
       "38226       1         False  \n",
       "38227       0         False  \n",
       "38228       0         False  \n",
       "38229       1         False  \n",
       "38230       0         False  \n",
       "38231       0         False  \n",
       "38232       0         False  \n",
       "38233       1         False  \n",
       "38234       1         False  \n",
       "38235       0         False  \n",
       "38236       0         False  \n",
       "38237       0         False  \n",
       "38238       0         False  \n",
       "38239       0         False  \n",
       "38240       0         False  \n",
       "38241       0         False  \n",
       "38242       0         False  \n",
       "38243       0         False  \n",
       "38244       0         False  \n",
       "38245       0         False  \n",
       "38246       0         False  \n",
       "38247       0         False  \n",
       "\n",
       "[38248 rows x 10 columns]"
      ]
     },
     "execution_count": 183,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tips_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.5.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}