Skip to content

Instantly share code, notes, and snippets.

@jfrolich

jfrolich/gist:3108615ddca27318ad7f

Created May 27, 2014 17:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jfrolich/3108615ddca27318ad7f to your computer and use it in GitHub Desktop.
Save jfrolich/3108615ddca27318ad7f to your computer and use it in GitHub Desktop.
Download ZIP
WorldCup Model V1
Raw
gistfile1.txt
{
"metadata": {
"name": "",
"signature": "sha256:7dd98943a42a3b5dadac425cbc531b5432fa5b7a285c1822445d21393b63f47a"
},
"nbformat": 3,
"nbformat_minor": 0,
"worksheets": [
{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Scraping\n",
"I found a really nice website (http://oddschecker.com) with betting odds for different final standings for a particular game. It lists odds for around 25 betting sites.\n",
"\n",
"These odds are probably close to the real odds with the rationale that most betting sites are free markets. So all information should be included in the market and thus the odds (people are betting real money).\n",
"\n",
"With the following command we scrape all possible standings for a particular match from oddschecker.com.\n",
"\n",
"Click [here][1] to see it for yourself.\n",
"\n",
"[1]: http://www.oddschecker.com/football/world-cup/brazil-v-croatia/correct-score"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Below I will scrape the first table and show the first 15 columns"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"import pandas as pd\n",
"\n",
"df = pd.read_html('http://www.oddschecker.com/football/world-cup/brazil-v-croatia/correct-score', attrs = {'class': 'eventTable'}, infer_types=False)[0]\n",
"df.loc[:, :15]"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>0</th>\n",
" <th>1</th>\n",
" <th>2</th>\n",
" <th>3</th>\n",
" <th>4</th>\n",
" <th>5</th>\n",
" <th>6</th>\n",
" <th>7</th>\n",
" <th>8</th>\n",
" <th>9</th>\n",
" <th>10</th>\n",
" <th>11</th>\n",
" <th>12</th>\n",
" <th>13</th>\n",
" <th>14</th>\n",
" <th>15</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0 </th>\n",
" <td> 6.4</td>\n",
" <td> brazil 2-0</td>\n",
" <td> Show GraphBrazil 2-0</td>\n",
" <td> 9/2</td>\n",
" <td> 9/2</td>\n",
" <td> </td>\n",
" <td> 4</td>\n",
" <td> </td>\n",
" <td> 21/5</td>\n",
" <td> 5</td>\n",
" <td> 5</td>\n",
" <td> 4</td>\n",
" <td> 27/5</td>\n",
" <td> 9/2</td>\n",
" <td> 24/5</td>\n",
" <td> 5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1 </th>\n",
" <td> 6.5</td>\n",
" <td> brazil 1-0</td>\n",
" <td> Show GraphBrazil 1-0</td>\n",
" <td> 5</td>\n",
" <td> 5</td>\n",
" <td> </td>\n",
" <td> 9/2</td>\n",
" <td> </td>\n",
" <td> 5</td>\n",
" <td> 11/2</td>\n",
" <td> 5</td>\n",
" <td> 19/4</td>\n",
" <td> 24/5</td>\n",
" <td> 11/2</td>\n",
" <td> 11/2</td>\n",
" <td> 11/2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2 </th>\n",
" <td> 8.5</td>\n",
" <td> brazil 3-0</td>\n",
" <td> Show GraphBrazil 3-0</td>\n",
" <td> 6</td>\n",
" <td> 7</td>\n",
" <td> </td>\n",
" <td> 6</td>\n",
" <td> </td>\n",
" <td> 13/2</td>\n",
" <td> 15/2</td>\n",
" <td> 15/2</td>\n",
" <td> 6</td>\n",
" <td> 7</td>\n",
" <td> 7</td>\n",
" <td> 7</td>\n",
" <td> 13/2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3 </th>\n",
" <td> 10.0</td>\n",
" <td> brazil 2-1</td>\n",
" <td> Show GraphBrazil 2-1</td>\n",
" <td> 17/2</td>\n",
" <td> 15/2</td>\n",
" <td> </td>\n",
" <td> 17/2</td>\n",
" <td> </td>\n",
" <td> 8</td>\n",
" <td> 9</td>\n",
" <td> 15/2</td>\n",
" <td> 15/2</td>\n",
" <td> 8</td>\n",
" <td> 9</td>\n",
" <td> 17/2</td>\n",
" <td> 8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4 </th>\n",
" <td> 10.5</td>\n",
" <td> any other score</td>\n",
" <td> Show GraphAny Other Score</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>5 </th>\n",
" <td> 12.0</td>\n",
" <td> draw 1-1</td>\n",
" <td> Show GraphDraw 1-1</td>\n",
" <td> 17/2</td>\n",
" <td> 15/2</td>\n",
" <td> </td>\n",
" <td> 9</td>\n",
" <td> </td>\n",
" <td> 9</td>\n",
" <td> 11</td>\n",
" <td> 17/2</td>\n",
" <td> 17/2</td>\n",
" <td> 8</td>\n",
" <td> 10</td>\n",
" <td> 10</td>\n",
" <td> 10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6 </th>\n",
" <td> 13.0</td>\n",
" <td> brazil 3-1</td>\n",
" <td> Show GraphBrazil 3-1</td>\n",
" <td> 11</td>\n",
" <td> 11</td>\n",
" <td> </td>\n",
" <td> 12</td>\n",
" <td> </td>\n",
" <td> 11</td>\n",
" <td> 12</td>\n",
" <td> 11</td>\n",
" <td> 10</td>\n",
" <td> 12</td>\n",
" <td> 12</td>\n",
" <td> 12</td>\n",
" <td> 11</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7 </th>\n",
" <td> 15.0</td>\n",
" <td> draw 0-0</td>\n",
" <td> Show GraphDraw 0-0</td>\n",
" <td> 10</td>\n",
" <td> 11</td>\n",
" <td> </td>\n",
" <td> 10</td>\n",
" <td> </td>\n",
" <td> 12</td>\n",
" <td> 13</td>\n",
" <td> 11</td>\n",
" <td> 11</td>\n",
" <td> 13</td>\n",
" <td> 11</td>\n",
" <td> 14</td>\n",
" <td> 11</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8 </th>\n",
" <td> 15.0</td>\n",
" <td> brazil 4-0</td>\n",
" <td> Show GraphBrazil 4-0</td>\n",
" <td> 11</td>\n",
" <td> 14</td>\n",
" <td> </td>\n",
" <td> 11</td>\n",
" <td> </td>\n",
" <td> 12</td>\n",
" <td> 14</td>\n",
" <td> 13</td>\n",
" <td> 11</td>\n",
" <td> 11</td>\n",
" <td> 12</td>\n",
" <td> 12</td>\n",
" <td> 11</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9 </th>\n",
" <td> 23.0</td>\n",
" <td> brazil 4-1</td>\n",
" <td> Show GraphBrazil 4-1</td>\n",
" <td> 20</td>\n",
" <td> 20</td>\n",
" <td> </td>\n",
" <td> 20</td>\n",
" <td> </td>\n",
" <td> 20</td>\n",
" <td> 21</td>\n",
" <td> 20</td>\n",
" <td> 18</td>\n",
" <td> 20</td>\n",
" <td> 20</td>\n",
" <td> 22</td>\n",
" <td> 18</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td> 29.0</td>\n",
" <td> croatia 1-0</td>\n",
" <td> Show GraphCroatia 1-0</td>\n",
" <td> 22</td>\n",
" <td> 20</td>\n",
" <td> </td>\n",
" <td> 20</td>\n",
" <td> </td>\n",
" <td> 20</td>\n",
" <td> 28</td>\n",
" <td> 25</td>\n",
" <td> 20</td>\n",
" <td> 19</td>\n",
" <td> 16</td>\n",
" <td> 28</td>\n",
" <td> 20</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td> 34.0</td>\n",
" <td> draw 2-2</td>\n",
" <td> Show GraphDraw 2-2</td>\n",
" <td> 25</td>\n",
" <td> 22</td>\n",
" <td> </td>\n",
" <td> 33</td>\n",
" <td> </td>\n",
" <td> 28</td>\n",
" <td> 30</td>\n",
" <td> 22</td>\n",
" <td> 28</td>\n",
" <td> 20</td>\n",
" <td> 28</td>\n",
" <td> 28</td>\n",
" <td> 28</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td> 34.0</td>\n",
" <td> brazil 5-0</td>\n",
" <td> Show GraphBrazil 5-0</td>\n",
" <td> 22</td>\n",
" <td> 33</td>\n",
" <td> </td>\n",
" <td> 22</td>\n",
" <td> </td>\n",
" <td> 28</td>\n",
" <td> 30</td>\n",
" <td> 25</td>\n",
" <td> 25</td>\n",
" <td> 20</td>\n",
" <td> 22</td>\n",
" <td> 28</td>\n",
" <td> 25</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td> 36.0</td>\n",
" <td> croatia 2-1</td>\n",
" <td> Show GraphCroatia 2-1</td>\n",
" <td> 33</td>\n",
" <td> 28</td>\n",
" <td> </td>\n",
" <td> 33</td>\n",
" <td> </td>\n",
" <td> 28</td>\n",
" <td> 35</td>\n",
" <td> 33</td>\n",
" <td> 28</td>\n",
" <td> 26</td>\n",
" <td> 28</td>\n",
" <td> 33</td>\n",
" <td> 28</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td> 42.5</td>\n",
" <td> brazil 3-2</td>\n",
" <td> Show GraphBrazil 3-2</td>\n",
" <td> 33</td>\n",
" <td> 33</td>\n",
" <td> </td>\n",
" <td> 40</td>\n",
" <td> </td>\n",
" <td> 33</td>\n",
" <td> 35</td>\n",
" <td> 30</td>\n",
" <td> 33</td>\n",
" <td> 30</td>\n",
" <td> 33</td>\n",
" <td> 40</td>\n",
" <td> 40</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td> 51.0</td>\n",
" <td> brazil 5-1</td>\n",
" <td> Show GraphBrazil 5-1</td>\n",
" <td> 40</td>\n",
" <td> 50</td>\n",
" <td> </td>\n",
" <td> 40</td>\n",
" <td> </td>\n",
" <td> 40</td>\n",
" <td> 40</td>\n",
" <td> 40</td>\n",
" <td> 40</td>\n",
" <td> 36</td>\n",
" <td> 33</td>\n",
" <td> 45</td>\n",
" <td> 50</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td> 81.0</td>\n",
" <td> brazil 4-2</td>\n",
" <td> Show GraphBrazil 4-2</td>\n",
" <td> 50</td>\n",
" <td> 50</td>\n",
" <td> </td>\n",
" <td> 80</td>\n",
" <td> </td>\n",
" <td> 66</td>\n",
" <td> 80</td>\n",
" <td> 55</td>\n",
" <td> 66</td>\n",
" <td> 55</td>\n",
" <td> 50</td>\n",
" <td> 66</td>\n",
" <td> 66</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td> 91.0</td>\n",
" <td> croatia 2-0</td>\n",
" <td> Show GraphCroatia 2-0</td>\n",
" <td> 50</td>\n",
" <td> 50</td>\n",
" <td> </td>\n",
" <td> 66</td>\n",
" <td> </td>\n",
" <td> 66</td>\n",
" <td> 80</td>\n",
" <td> 80</td>\n",
" <td> 66</td>\n",
" <td> 50</td>\n",
" <td> 66</td>\n",
" <td> 80</td>\n",
" <td> 66</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td> 101.0</td>\n",
" <td> brazil 6-0</td>\n",
" <td> Show GraphBrazil 6-0</td>\n",
" <td> 50</td>\n",
" <td> 66</td>\n",
" <td> </td>\n",
" <td> 66</td>\n",
" <td> </td>\n",
" <td> 66</td>\n",
" <td> 100</td>\n",
" <td> 75</td>\n",
" <td> 66</td>\n",
" <td> 40</td>\n",
" <td> 40</td>\n",
" <td> 66</td>\n",
" <td> 66</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td> 101.0</td>\n",
" <td> brazil 6-1</td>\n",
" <td> Show GraphBrazil 6-1</td>\n",
" <td> 66</td>\n",
" <td> 80</td>\n",
" <td> </td>\n",
" <td> 100</td>\n",
" <td> </td>\n",
" <td> 100</td>\n",
" <td> 100</td>\n",
" <td> 100</td>\n",
" <td> </td>\n",
" <td> 75</td>\n",
" <td> 80</td>\n",
" <td> 100</td>\n",
" <td> 100</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td> 151.0</td>\n",
" <td> croatia 3-2</td>\n",
" <td> Show GraphCroatia 3-2</td>\n",
" <td> 100</td>\n",
" <td> 80</td>\n",
" <td> </td>\n",
" <td> 150</td>\n",
" <td> </td>\n",
" <td> 125</td>\n",
" <td> 110</td>\n",
" <td> 100</td>\n",
" <td> 100</td>\n",
" <td> 70</td>\n",
" <td> 125</td>\n",
" <td> 100</td>\n",
" <td> 80</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td> 170.0</td>\n",
" <td> brazil 5-2</td>\n",
" <td> Show GraphBrazil 5-2</td>\n",
" <td> 80</td>\n",
" <td> 100</td>\n",
" <td> </td>\n",
" <td> 150</td>\n",
" <td> </td>\n",
" <td> 125</td>\n",
" <td> 110</td>\n",
" <td> 100</td>\n",
" <td> </td>\n",
" <td> 100</td>\n",
" <td> 100</td>\n",
" <td> 125</td>\n",
" <td> 125</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td> 201.0</td>\n",
" <td> draw 3-3</td>\n",
" <td> Show GraphDraw 3-3</td>\n",
" <td> 100</td>\n",
" <td> 100</td>\n",
" <td> </td>\n",
" <td> 200</td>\n",
" <td> </td>\n",
" <td> 150</td>\n",
" <td> 125</td>\n",
" <td> 125</td>\n",
" <td> 100</td>\n",
" <td> 80</td>\n",
" <td> 150</td>\n",
" <td> 125</td>\n",
" <td> 100</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td> 201.0</td>\n",
" <td> croatia 3-1</td>\n",
" <td> Show GraphCroatia 3-1</td>\n",
" <td> 100</td>\n",
" <td> 80</td>\n",
" <td> </td>\n",
" <td> 200</td>\n",
" <td> </td>\n",
" <td> 125</td>\n",
" <td> 125</td>\n",
" <td> 150</td>\n",
" <td> 100</td>\n",
" <td> 80</td>\n",
" <td> 125</td>\n",
" <td> 125</td>\n",
" <td> 100</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td> 201.0</td>\n",
" <td> brazil 7-0</td>\n",
" <td> Show GraphBrazil 7-0</td>\n",
" <td> 100</td>\n",
" <td> 200</td>\n",
" <td> </td>\n",
" <td> 150</td>\n",
" <td> </td>\n",
" <td> 200</td>\n",
" <td> 150</td>\n",
" <td> 175</td>\n",
" <td> </td>\n",
" <td> 90</td>\n",
" <td> 125</td>\n",
" <td> 150</td>\n",
" <td> 150</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td> 250.0</td>\n",
" <td> draw 5-5</td>\n",
" <td> Show GraphDraw 5-5</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>26</th>\n",
" <td> 251.0</td>\n",
" <td> brazil 4-3</td>\n",
" <td> Show GraphBrazil 4-3</td>\n",
" <td> 150</td>\n",
" <td> 200</td>\n",
" <td> </td>\n",
" <td> 200</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 250</td>\n",
" <td> 200</td>\n",
" <td> </td>\n",
" <td> 160</td>\n",
" <td> 200</td>\n",
" <td> 150</td>\n",
" <td> 150</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td> 251.0</td>\n",
" <td> brazil 6-2</td>\n",
" <td> Show GraphBrazil 6-2</td>\n",
" <td> 200</td>\n",
" <td> 200</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 250</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 225</td>\n",
" <td> 225</td>\n",
" <td> 200</td>\n",
" <td> 250</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td> 251.0</td>\n",
" <td> brazil 7-1</td>\n",
" <td> Show GraphBrazil 7-1</td>\n",
" <td> 150</td>\n",
" <td> 200</td>\n",
" <td> </td>\n",
" <td> 200</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 250</td>\n",
" <td> 250</td>\n",
" <td> </td>\n",
" <td> 160</td>\n",
" <td> 200</td>\n",
" <td> 200</td>\n",
" <td> 250</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td> 301.0</td>\n",
" <td> croatia 6-3</td>\n",
" <td> Show GraphCroatia 6-3</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> 300</td>\n",
" <td> </td>\n",
" </tr>\n",
" <tr>\n",
" <th>30</th>\n",
" <td> 301.0</td>\n",
" <td> croatia 7-2</td>\n",
" <td> Show GraphCroatia 7-2</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> 300</td>\n",
" <td> </td>\n",
" </tr>\n",
" <tr>\n",
" <th>31</th>\n",
" <td> 351.0</td>\n",
" <td> draw 4-4</td>\n",
" <td> Show GraphDraw 4-4</td>\n",
" <td> </td>\n",
" <td> 250</td>\n",
" <td> </td>\n",
" <td> 200</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 250</td>\n",
" <td> 350</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 250</td>\n",
" <td> 200</td>\n",
" </tr>\n",
" <tr>\n",
" <th>32</th>\n",
" <td> 401.0</td>\n",
" <td> croatia 3-0</td>\n",
" <td> Show GraphCroatia 3-0</td>\n",
" <td> 200</td>\n",
" <td> 200</td>\n",
" <td> </td>\n",
" <td> 200</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 250</td>\n",
" <td> 400</td>\n",
" <td> 100</td>\n",
" <td> 150</td>\n",
" <td> 225</td>\n",
" <td> 200</td>\n",
" <td> 125</td>\n",
" </tr>\n",
" <tr>\n",
" <th>33</th>\n",
" <td> 401.0</td>\n",
" <td> brazil 6-3</td>\n",
" <td> Show GraphBrazil 6-3</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> 250</td>\n",
" <td> </td>\n",
" </tr>\n",
" <tr>\n",
" <th>34</th>\n",
" <td> 426.0</td>\n",
" <td> brazil 5-3</td>\n",
" <td> Show GraphBrazil 5-3</td>\n",
" <td> 350</td>\n",
" <td> 250</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 250</td>\n",
" <td> 425</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 400</td>\n",
" <td> 250</td>\n",
" <td> </td>\n",
" </tr>\n",
" <tr>\n",
" <th>35</th>\n",
" <td> 501.0</td>\n",
" <td> brazil 10-0</td>\n",
" <td> Show GraphBrazil 10-0</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 500</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" </tr>\n",
" <tr>\n",
" <th>36</th>\n",
" <td> 501.0</td>\n",
" <td> brazil 5-4</td>\n",
" <td> Show GraphBrazil 5-4</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 500</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 300</td>\n",
" <td> </td>\n",
" </tr>\n",
" <tr>\n",
" <th>37</th>\n",
" <td> 501.0</td>\n",
" <td> brazil 7-2</td>\n",
" <td> Show GraphBrazil 7-2</td>\n",
" <td> 500</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> 250</td>\n",
" <td> </td>\n",
" </tr>\n",
" <tr>\n",
" <th>38</th>\n",
" <td> 501.0</td>\n",
" <td> brazil 8-0</td>\n",
" <td> Show GraphBrazil 8-0</td>\n",
" <td> 350</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 200</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 500</td>\n",
" <td> </td>\n",
" <td> 225</td>\n",
" <td> 275</td>\n",
" <td> 250</td>\n",
" <td> 300</td>\n",
" </tr>\n",
" <tr>\n",
" <th>39</th>\n",
" <td> 501.0</td>\n",
" <td> brazil 8-1</td>\n",
" <td> Show GraphBrazil 8-1</td>\n",
" <td> 500</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 500</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 250</td>\n",
" <td> </td>\n",
" </tr>\n",
" <tr>\n",
" <th>40</th>\n",
" <td> 501.0</td>\n",
" <td> brazil 9-0</td>\n",
" <td> Show GraphBrazil 9-0</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 500</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 300</td>\n",
" <td> 500</td>\n",
" </tr>\n",
" <tr>\n",
" <th>41</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 10-0</td>\n",
" <td> Show GraphCroatia 10-0</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 500</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" </tr>\n",
" <tr>\n",
" <th>42</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 4-0</td>\n",
" <td> Show GraphCroatia 4-0</td>\n",
" <td> </td>\n",
" <td> 250</td>\n",
" <td> </td>\n",
" <td> 200</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 250</td>\n",
" <td> 500</td>\n",
" <td> 100</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 300</td>\n",
" <td> 200</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 4-1</td>\n",
" <td> Show GraphCroatia 4-1</td>\n",
" <td> </td>\n",
" <td> 250</td>\n",
" <td> </td>\n",
" <td> 200</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 250</td>\n",
" <td> 500</td>\n",
" <td> 100</td>\n",
" <td> 275</td>\n",
" <td> </td>\n",
" <td> 250</td>\n",
" <td> 200</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 4-2</td>\n",
" <td> Show GraphCroatia 4-2</td>\n",
" <td> 500</td>\n",
" <td> 250</td>\n",
" <td> </td>\n",
" <td> 200</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 250</td>\n",
" <td> 500</td>\n",
" <td> 100</td>\n",
" <td> 250</td>\n",
" <td> </td>\n",
" <td> 250</td>\n",
" <td> 200</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 4-3</td>\n",
" <td> Show GraphCroatia 4-3</td>\n",
" <td> </td>\n",
" <td> 250</td>\n",
" <td> </td>\n",
" <td> 200</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 250</td>\n",
" <td> 500</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 250</td>\n",
" <td> 200</td>\n",
" </tr>\n",
" <tr>\n",
" <th>46</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 5-0</td>\n",
" <td> Show GraphCroatia 5-0</td>\n",
" <td> </td>\n",
" <td> 250</td>\n",
" <td> </td>\n",
" <td> 200</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 250</td>\n",
" <td> 500</td>\n",
" <td> 100</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 300</td>\n",
" <td> </td>\n",
" </tr>\n",
" <tr>\n",
" <th>47</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 5-1</td>\n",
" <td> Show GraphCroatia 5-1</td>\n",
" <td> </td>\n",
" <td> 250</td>\n",
" <td> </td>\n",
" <td> 200</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 250</td>\n",
" <td> 500</td>\n",
" <td> 100</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 300</td>\n",
" <td> </td>\n",
" </tr>\n",
" <tr>\n",
" <th>48</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 5-2</td>\n",
" <td> Show GraphCroatia 5-2</td>\n",
" <td> </td>\n",
" <td> 250</td>\n",
" <td> </td>\n",
" <td> 200</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 250</td>\n",
" <td> 500</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 300</td>\n",
" <td> 500</td>\n",
" </tr>\n",
" <tr>\n",
" <th>49</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 5-3</td>\n",
" <td> Show GraphCroatia 5-3</td>\n",
" <td> </td>\n",
" <td> 250</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 250</td>\n",
" <td> 500</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 300</td>\n",
" <td> </td>\n",
" </tr>\n",
" <tr>\n",
" <th>50</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 5-4</td>\n",
" <td> Show GraphCroatia 5-4</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 500</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 300</td>\n",
" <td> </td>\n",
" </tr>\n",
" <tr>\n",
" <th>51</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 6-0</td>\n",
" <td> Show GraphCroatia 6-0</td>\n",
" <td> </td>\n",
" <td> 250</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 250</td>\n",
" <td> 500</td>\n",
" <td> 100</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 300</td>\n",
" <td> </td>\n",
" </tr>\n",
" <tr>\n",
" <th>52</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 6-1</td>\n",
" <td> Show GraphCroatia 6-1</td>\n",
" <td> </td>\n",
" <td> 250</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 250</td>\n",
" <td> 500</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 300</td>\n",
" <td> </td>\n",
" </tr>\n",
" <tr>\n",
" <th>53</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 6-2</td>\n",
" <td> Show GraphCroatia 6-2</td>\n",
" <td> </td>\n",
" <td> 250</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 250</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 300</td>\n",
" <td> 500</td>\n",
" </tr>\n",
" <tr>\n",
" <th>54</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 7-0</td>\n",
" <td> Show GraphCroatia 7-0</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 500</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 300</td>\n",
" <td> </td>\n",
" </tr>\n",
" <tr>\n",
" <th>55</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 7-1</td>\n",
" <td> Show GraphCroatia 7-1</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 500</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 300</td>\n",
" <td> </td>\n",
" </tr>\n",
" <tr>\n",
" <th>56</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 8-0</td>\n",
" <td> Show GraphCroatia 8-0</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 500</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 300</td>\n",
" <td> </td>\n",
" </tr>\n",
" <tr>\n",
" <th>57</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 8-1</td>\n",
" <td> Show GraphCroatia 8-1</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 500</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 300</td>\n",
" <td> </td>\n",
" </tr>\n",
" <tr>\n",
" <th>58</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 9-0</td>\n",
" <td> Show GraphCroatia 9-0</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 500</td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> </td>\n",
" <td> 300</td>\n",
" <td> </td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 64,
"text": [
" 0 1 2 3 4 5 6 7 \\\n",
"0 6.4 brazil 2-0 Show GraphBrazil 2-0 9/2 9/2 4 \n",
"1 6.5 brazil 1-0 Show GraphBrazil 1-0 5 5 9/2 \n",
"2 8.5 brazil 3-0 Show GraphBrazil 3-0 6 7 6 \n",
"3 10.0 brazil 2-1 Show GraphBrazil 2-1 17/2 15/2 17/2 \n",
"4 10.5 any other score Show GraphAny Other Score \n",
"5 12.0 draw 1-1 Show GraphDraw 1-1 17/2 15/2 9 \n",
"6 13.0 brazil 3-1 Show GraphBrazil 3-1 11 11 12 \n",
"7 15.0 draw 0-0 Show GraphDraw 0-0 10 11 10 \n",
"8 15.0 brazil 4-0 Show GraphBrazil 4-0 11 14 11 \n",
"9 23.0 brazil 4-1 Show GraphBrazil 4-1 20 20 20 \n",
"10 29.0 croatia 1-0 Show GraphCroatia 1-0 22 20 20 \n",
"11 34.0 draw 2-2 Show GraphDraw 2-2 25 22 33 \n",
"12 34.0 brazil 5-0 Show GraphBrazil 5-0 22 33 22 \n",
"13 36.0 croatia 2-1 Show GraphCroatia 2-1 33 28 33 \n",
"14 42.5 brazil 3-2 Show GraphBrazil 3-2 33 33 40 \n",
"15 51.0 brazil 5-1 Show GraphBrazil 5-1 40 50 40 \n",
"16 81.0 brazil 4-2 Show GraphBrazil 4-2 50 50 80 \n",
"17 91.0 croatia 2-0 Show GraphCroatia 2-0 50 50 66 \n",
"18 101.0 brazil 6-0 Show GraphBrazil 6-0 50 66 66 \n",
"19 101.0 brazil 6-1 Show GraphBrazil 6-1 66 80 100 \n",
"20 151.0 croatia 3-2 Show GraphCroatia 3-2 100 80 150 \n",
"21 170.0 brazil 5-2 Show GraphBrazil 5-2 80 100 150 \n",
"22 201.0 draw 3-3 Show GraphDraw 3-3 100 100 200 \n",
"23 201.0 croatia 3-1 Show GraphCroatia 3-1 100 80 200 \n",
"24 201.0 brazil 7-0 Show GraphBrazil 7-0 100 200 150 \n",
"25 250.0 draw 5-5 Show GraphDraw 5-5 \n",
"26 251.0 brazil 4-3 Show GraphBrazil 4-3 150 200 200 \n",
"27 251.0 brazil 6-2 Show GraphBrazil 6-2 200 200 \n",
"28 251.0 brazil 7-1 Show GraphBrazil 7-1 150 200 200 \n",
"29 301.0 croatia 6-3 Show GraphCroatia 6-3 \n",
"30 301.0 croatia 7-2 Show GraphCroatia 7-2 \n",
"31 351.0 draw 4-4 Show GraphDraw 4-4 250 200 \n",
"32 401.0 croatia 3-0 Show GraphCroatia 3-0 200 200 200 \n",
"33 401.0 brazil 6-3 Show GraphBrazil 6-3 \n",
"34 426.0 brazil 5-3 Show GraphBrazil 5-3 350 250 \n",
"35 501.0 brazil 10-0 Show GraphBrazil 10-0 \n",
"36 501.0 brazil 5-4 Show GraphBrazil 5-4 \n",
"37 501.0 brazil 7-2 Show GraphBrazil 7-2 500 \n",
"38 501.0 brazil 8-0 Show GraphBrazil 8-0 350 200 \n",
"39 501.0 brazil 8-1 Show GraphBrazil 8-1 500 \n",
"40 501.0 brazil 9-0 Show GraphBrazil 9-0 \n",
"41 501.0 croatia 10-0 Show GraphCroatia 10-0 \n",
"42 501.0 croatia 4-0 Show GraphCroatia 4-0 250 200 \n",
"43 501.0 croatia 4-1 Show GraphCroatia 4-1 250 200 \n",
"44 501.0 croatia 4-2 Show GraphCroatia 4-2 500 250 200 \n",
"45 501.0 croatia 4-3 Show GraphCroatia 4-3 250 200 \n",
"46 501.0 croatia 5-0 Show GraphCroatia 5-0 250 200 \n",
"47 501.0 croatia 5-1 Show GraphCroatia 5-1 250 200 \n",
"48 501.0 croatia 5-2 Show GraphCroatia 5-2 250 200 \n",
"49 501.0 croatia 5-3 Show GraphCroatia 5-3 250 \n",
"50 501.0 croatia 5-4 Show GraphCroatia 5-4 \n",
"51 501.0 croatia 6-0 Show GraphCroatia 6-0 250 \n",
"52 501.0 croatia 6-1 Show GraphCroatia 6-1 250 \n",
"53 501.0 croatia 6-2 Show GraphCroatia 6-2 250 \n",
"54 501.0 croatia 7-0 Show GraphCroatia 7-0 \n",
"55 501.0 croatia 7-1 Show GraphCroatia 7-1 \n",
"56 501.0 croatia 8-0 Show GraphCroatia 8-0 \n",
"57 501.0 croatia 8-1 Show GraphCroatia 8-1 \n",
"58 501.0 croatia 9-0 Show GraphCroatia 9-0 \n",
"\n",
" 8 9 10 11 12 13 14 15 \n",
"0 21/5 5 5 4 27/5 9/2 24/5 5 \n",
"1 5 11/2 5 19/4 24/5 11/2 11/2 11/2 \n",
"2 13/2 15/2 15/2 6 7 7 7 13/2 \n",
"3 8 9 15/2 15/2 8 9 17/2 8 \n",
"4 \n",
"5 9 11 17/2 17/2 8 10 10 10 \n",
"6 11 12 11 10 12 12 12 11 \n",
"7 12 13 11 11 13 11 14 11 \n",
"8 12 14 13 11 11 12 12 11 \n",
"9 20 21 20 18 20 20 22 18 \n",
"10 20 28 25 20 19 16 28 20 \n",
"11 28 30 22 28 20 28 28 28 \n",
"12 28 30 25 25 20 22 28 25 \n",
"13 28 35 33 28 26 28 33 28 \n",
"14 33 35 30 33 30 33 40 40 \n",
"15 40 40 40 40 36 33 45 50 \n",
"16 66 80 55 66 55 50 66 66 \n",
"17 66 80 80 66 50 66 80 66 \n",
"18 66 100 75 66 40 40 66 66 \n",
"19 100 100 100 75 80 100 100 \n",
"20 125 110 100 100 70 125 100 80 \n",
"21 125 110 100 100 100 125 125 \n",
"22 150 125 125 100 80 150 125 100 \n",
"23 125 125 150 100 80 125 125 100 \n",
"24 200 150 175 90 125 150 150 \n",
"25 \n",
"26 250 200 160 200 150 150 \n",
"27 250 225 225 200 250 \n",
"28 250 250 160 200 200 250 \n",
"29 300 \n",
"30 300 \n",
"31 250 350 250 200 \n",
"32 250 400 100 150 225 200 125 \n",
"33 250 \n",
"34 250 425 400 250 \n",
"35 500 \n",
"36 500 300 \n",
"37 250 \n",
"38 500 225 275 250 300 \n",
"39 500 250 \n",
"40 500 300 500 \n",
"41 500 \n",
"42 250 500 100 300 200 \n",
"43 250 500 100 275 250 200 \n",
"44 250 500 100 250 250 200 \n",
"45 250 500 250 200 \n",
"46 250 500 100 300 \n",
"47 250 500 100 300 \n",
"48 250 500 300 500 \n",
"49 250 500 300 \n",
"50 500 300 \n",
"51 250 500 100 300 \n",
"52 250 500 300 \n",
"53 250 300 500 \n",
"54 500 300 \n",
"55 500 300 \n",
"56 500 300 \n",
"57 500 300 \n",
"58 500 300 "
]
}
],
"prompt_number": 64
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Interesting to see there is a hidden odds field in the table (column 0), this is some kind of combination of the later columns of odds of betting sites?"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Preproces\n",
"We need to preprocess the cell value from odds fractions (9/2) to a decimal number.\n",
"\n",
"This function will do just that:"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"import numpy as np\n",
"\n",
"import math\n",
"\n",
"def preprocess(x):\n",
" try:\n",
" fr = x.split('/')\n",
" return (float(fr[1])+float(fr[0]))/(float(fr[1]))\n",
" except:\n",
" if x == \"\": return np.nan\n",
" try:\n",
" if math.isnan(x): return np.nan\n",
" return (float(x)+1.)\n",
" except:\n",
" return x\n",
"\n",
"df2 = df.applymap(preprocess)\n",
"df2.loc[:10, :15]"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>0</th>\n",
" <th>1</th>\n",
" <th>2</th>\n",
" <th>3</th>\n",
" <th>4</th>\n",
" <th>5</th>\n",
" <th>6</th>\n",
" <th>7</th>\n",
" <th>8</th>\n",
" <th>9</th>\n",
" <th>10</th>\n",
" <th>11</th>\n",
" <th>12</th>\n",
" <th>13</th>\n",
" <th>14</th>\n",
" <th>15</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0 </th>\n",
" <td> 6.4</td>\n",
" <td> brazil 2-0</td>\n",
" <td> Show GraphBrazil 2-0</td>\n",
" <td> 5.5</td>\n",
" <td> 5.5</td>\n",
" <td>NaN</td>\n",
" <td> 4</td>\n",
" <td> 5.5</td>\n",
" <td> 5.2</td>\n",
" <td> 5</td>\n",
" <td> 5</td>\n",
" <td> 4</td>\n",
" <td> 6.4</td>\n",
" <td> 5.5</td>\n",
" <td> 5.8</td>\n",
" <td> 5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1 </th>\n",
" <td> 6.5</td>\n",
" <td> brazil 1-0</td>\n",
" <td> Show GraphBrazil 1-0</td>\n",
" <td> 5</td>\n",
" <td> 5</td>\n",
" <td>NaN</td>\n",
" <td> 5.5</td>\n",
" <td> 5</td>\n",
" <td> 5</td>\n",
" <td> 6.5</td>\n",
" <td> 5</td>\n",
" <td> 5.75</td>\n",
" <td> 5.8</td>\n",
" <td> 6.5</td>\n",
" <td> 6.5</td>\n",
" <td> 6.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2 </th>\n",
" <td> 8.5</td>\n",
" <td> brazil 3-0</td>\n",
" <td> Show GraphBrazil 3-0</td>\n",
" <td> 6</td>\n",
" <td> 7</td>\n",
" <td>NaN</td>\n",
" <td> 6</td>\n",
" <td> 7.5</td>\n",
" <td> 7.5</td>\n",
" <td> 8.5</td>\n",
" <td> 8.5</td>\n",
" <td> 6</td>\n",
" <td> 7</td>\n",
" <td> 7</td>\n",
" <td> 7</td>\n",
" <td> 7.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3 </th>\n",
" <td> 10.0</td>\n",
" <td> brazil 2-1</td>\n",
" <td> Show GraphBrazil 2-1</td>\n",
" <td> 9.5</td>\n",
" <td> 8.5</td>\n",
" <td>NaN</td>\n",
" <td> 9.5</td>\n",
" <td> 8</td>\n",
" <td> 8</td>\n",
" <td> 9</td>\n",
" <td> 8.5</td>\n",
" <td> 8.5</td>\n",
" <td> 8</td>\n",
" <td> 9</td>\n",
" <td> 9.5</td>\n",
" <td> 8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4 </th>\n",
" <td> 10.5</td>\n",
" <td> any other score</td>\n",
" <td> Show GraphAny Other Score</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5 </th>\n",
" <td> 12.0</td>\n",
" <td> draw 1-1</td>\n",
" <td> Show GraphDraw 1-1</td>\n",
" <td> 9.5</td>\n",
" <td> 8.5</td>\n",
" <td>NaN</td>\n",
" <td> 9</td>\n",
" <td> 9</td>\n",
" <td> 9</td>\n",
" <td> 11</td>\n",
" <td> 9.5</td>\n",
" <td> 9.5</td>\n",
" <td> 8</td>\n",
" <td> 10</td>\n",
" <td> 10</td>\n",
" <td> 10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6 </th>\n",
" <td> 13.0</td>\n",
" <td> brazil 3-1</td>\n",
" <td> Show GraphBrazil 3-1</td>\n",
" <td> 11</td>\n",
" <td> 11</td>\n",
" <td>NaN</td>\n",
" <td> 12</td>\n",
" <td> 11</td>\n",
" <td> 11</td>\n",
" <td> 12</td>\n",
" <td> 11</td>\n",
" <td> 10</td>\n",
" <td> 12</td>\n",
" <td> 12</td>\n",
" <td> 12</td>\n",
" <td> 11</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7 </th>\n",
" <td> 15.0</td>\n",
" <td> draw 0-0</td>\n",
" <td> Show GraphDraw 0-0</td>\n",
" <td> 10</td>\n",
" <td> 11</td>\n",
" <td>NaN</td>\n",
" <td> 10</td>\n",
" <td> 11</td>\n",
" <td> 12</td>\n",
" <td> 13</td>\n",
" <td> 11</td>\n",
" <td> 11</td>\n",
" <td> 13</td>\n",
" <td> 11</td>\n",
" <td> 14</td>\n",
" <td> 11</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8 </th>\n",
" <td> 15.0</td>\n",
" <td> brazil 4-0</td>\n",
" <td> Show GraphBrazil 4-0</td>\n",
" <td> 11</td>\n",
" <td> 14</td>\n",
" <td>NaN</td>\n",
" <td> 11</td>\n",
" <td> 11</td>\n",
" <td> 12</td>\n",
" <td> 14</td>\n",
" <td> 13</td>\n",
" <td> 11</td>\n",
" <td> 11</td>\n",
" <td> 12</td>\n",
" <td> 12</td>\n",
" <td> 11</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9 </th>\n",
" <td> 23.0</td>\n",
" <td> brazil 4-1</td>\n",
" <td> Show GraphBrazil 4-1</td>\n",
" <td> 20</td>\n",
" <td> 20</td>\n",
" <td>NaN</td>\n",
" <td> 20</td>\n",
" <td> 18</td>\n",
" <td> 20</td>\n",
" <td> 21</td>\n",
" <td> 20</td>\n",
" <td> 18</td>\n",
" <td> 20</td>\n",
" <td> 20</td>\n",
" <td> 22</td>\n",
" <td> 18</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td> 29.0</td>\n",
" <td> croatia 1-0</td>\n",
" <td> Show GraphCroatia 1-0</td>\n",
" <td> 22</td>\n",
" <td> 20</td>\n",
" <td>NaN</td>\n",
" <td> 20</td>\n",
" <td> 20</td>\n",
" <td> 20</td>\n",
" <td> 28</td>\n",
" <td> 25</td>\n",
" <td> 20</td>\n",
" <td> 19</td>\n",
" <td> 16</td>\n",
" <td> 28</td>\n",
" <td> 20</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 56,
"text": [
" 0 1 2 3 4 5 6 7 \\\n",
"0 6.4 brazil 2-0 Show GraphBrazil 2-0 5.5 5.5 NaN 4 5.5 \n",
"1 6.5 brazil 1-0 Show GraphBrazil 1-0 5 5 NaN 5.5 5 \n",
"2 8.5 brazil 3-0 Show GraphBrazil 3-0 6 7 NaN 6 7.5 \n",
"3 10.0 brazil 2-1 Show GraphBrazil 2-1 9.5 8.5 NaN 9.5 8 \n",
"4 10.5 any other score Show GraphAny Other Score NaN NaN NaN NaN NaN \n",
"5 12.0 draw 1-1 Show GraphDraw 1-1 9.5 8.5 NaN 9 9 \n",
"6 13.0 brazil 3-1 Show GraphBrazil 3-1 11 11 NaN 12 11 \n",
"7 15.0 draw 0-0 Show GraphDraw 0-0 10 11 NaN 10 11 \n",
"8 15.0 brazil 4-0 Show GraphBrazil 4-0 11 14 NaN 11 11 \n",
"9 23.0 brazil 4-1 Show GraphBrazil 4-1 20 20 NaN 20 18 \n",
"10 29.0 croatia 1-0 Show GraphCroatia 1-0 22 20 NaN 20 20 \n",
"\n",
" 8 9 10 11 12 13 14 15 \n",
"0 5.2 5 5 4 6.4 5.5 5.8 5 \n",
"1 5 6.5 5 5.75 5.8 6.5 6.5 6.5 \n",
"2 7.5 8.5 8.5 6 7 7 7 7.5 \n",
"3 8 9 8.5 8.5 8 9 9.5 8 \n",
"4 NaN NaN NaN NaN NaN NaN NaN NaN \n",
"5 9 11 9.5 9.5 8 10 10 10 \n",
"6 11 12 11 10 12 12 12 11 \n",
"7 12 13 11 11 13 11 14 11 \n",
"8 12 14 13 11 11 12 12 11 \n",
"9 20 21 20 18 20 20 22 18 \n",
"10 20 28 25 20 19 16 28 20 "
]
}
],
"prompt_number": 56
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Drop the second column, and convert convert everything to numbers"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"df3 = df2.drop(2,1).convert_objects(convert_numeric=True)\n",
"df3.loc[:10, :10]"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>0</th>\n",
" <th>1</th>\n",
" <th>3</th>\n",
" <th>4</th>\n",
" <th>5</th>\n",
" <th>6</th>\n",
" <th>7</th>\n",
" <th>8</th>\n",
" <th>9</th>\n",
" <th>10</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0 </th>\n",
" <td> 6.4</td>\n",
" <td> brazil 2-0</td>\n",
" <td> 5.5</td>\n",
" <td> 5.5</td>\n",
" <td>NaN</td>\n",
" <td> 4.0</td>\n",
" <td> 5.5</td>\n",
" <td> 5.2</td>\n",
" <td> 5.0</td>\n",
" <td> 5.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1 </th>\n",
" <td> 6.5</td>\n",
" <td> brazil 1-0</td>\n",
" <td> 5.0</td>\n",
" <td> 5.0</td>\n",
" <td>NaN</td>\n",
" <td> 5.5</td>\n",
" <td> 5.0</td>\n",
" <td> 5.0</td>\n",
" <td> 6.5</td>\n",
" <td> 5.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2 </th>\n",
" <td> 8.5</td>\n",
" <td> brazil 3-0</td>\n",
" <td> 6.0</td>\n",
" <td> 7.0</td>\n",
" <td>NaN</td>\n",
" <td> 6.0</td>\n",
" <td> 7.5</td>\n",
" <td> 7.5</td>\n",
" <td> 8.5</td>\n",
" <td> 8.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3 </th>\n",
" <td> 10.0</td>\n",
" <td> brazil 2-1</td>\n",
" <td> 9.5</td>\n",
" <td> 8.5</td>\n",
" <td>NaN</td>\n",
" <td> 9.5</td>\n",
" <td> 8.0</td>\n",
" <td> 8.0</td>\n",
" <td> 9.0</td>\n",
" <td> 8.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4 </th>\n",
" <td> 10.5</td>\n",
" <td> any other score</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td>NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5 </th>\n",
" <td> 12.0</td>\n",
" <td> draw 1-1</td>\n",
" <td> 9.5</td>\n",
" <td> 8.5</td>\n",
" <td>NaN</td>\n",
" <td> 9.0</td>\n",
" <td> 9.0</td>\n",
" <td> 9.0</td>\n",
" <td> 11.0</td>\n",
" <td> 9.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6 </th>\n",
" <td> 13.0</td>\n",
" <td> brazil 3-1</td>\n",
" <td> 11.0</td>\n",
" <td> 11.0</td>\n",
" <td>NaN</td>\n",
" <td> 12.0</td>\n",
" <td> 11.0</td>\n",
" <td> 11.0</td>\n",
" <td> 12.0</td>\n",
" <td> 11.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7 </th>\n",
" <td> 15.0</td>\n",
" <td> draw 0-0</td>\n",
" <td> 10.0</td>\n",
" <td> 11.0</td>\n",
" <td>NaN</td>\n",
" <td> 10.0</td>\n",
" <td> 11.0</td>\n",
" <td> 12.0</td>\n",
" <td> 13.0</td>\n",
" <td> 11.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8 </th>\n",
" <td> 15.0</td>\n",
" <td> brazil 4-0</td>\n",
" <td> 11.0</td>\n",
" <td> 14.0</td>\n",
" <td>NaN</td>\n",
" <td> 11.0</td>\n",
" <td> 11.0</td>\n",
" <td> 12.0</td>\n",
" <td> 14.0</td>\n",
" <td> 13.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9 </th>\n",
" <td> 23.0</td>\n",
" <td> brazil 4-1</td>\n",
" <td> 20.0</td>\n",
" <td> 20.0</td>\n",
" <td>NaN</td>\n",
" <td> 20.0</td>\n",
" <td> 18.0</td>\n",
" <td> 20.0</td>\n",
" <td> 21.0</td>\n",
" <td> 20.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td> 29.0</td>\n",
" <td> croatia 1-0</td>\n",
" <td> 22.0</td>\n",
" <td> 20.0</td>\n",
" <td>NaN</td>\n",
" <td> 20.0</td>\n",
" <td> 20.0</td>\n",
" <td> 20.0</td>\n",
" <td> 28.0</td>\n",
" <td> 25.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 57,
"text": [
" 0 1 3 4 5 6 7 8 9 10\n",
"0 6.4 brazil 2-0 5.5 5.5 NaN 4.0 5.5 5.2 5.0 5.0\n",
"1 6.5 brazil 1-0 5.0 5.0 NaN 5.5 5.0 5.0 6.5 5.0\n",
"2 8.5 brazil 3-0 6.0 7.0 NaN 6.0 7.5 7.5 8.5 8.5\n",
"3 10.0 brazil 2-1 9.5 8.5 NaN 9.5 8.0 8.0 9.0 8.5\n",
"4 10.5 any other score NaN NaN NaN NaN NaN NaN NaN NaN\n",
"5 12.0 draw 1-1 9.5 8.5 NaN 9.0 9.0 9.0 11.0 9.5\n",
"6 13.0 brazil 3-1 11.0 11.0 NaN 12.0 11.0 11.0 12.0 11.0\n",
"7 15.0 draw 0-0 10.0 11.0 NaN 10.0 11.0 12.0 13.0 11.0\n",
"8 15.0 brazil 4-0 11.0 14.0 NaN 11.0 11.0 12.0 14.0 13.0\n",
"9 23.0 brazil 4-1 20.0 20.0 NaN 20.0 18.0 20.0 21.0 20.0\n",
"10 29.0 croatia 1-0 22.0 20.0 NaN 20.0 20.0 20.0 28.0 25.0"
]
}
],
"prompt_number": 57
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Calculate mean odds"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"mean_odds = df3.loc[:, 3:].mean(1)\n",
"mean_odds[:10]"
],
"language": "python",
"metadata": {},
"outputs": [
{
"metadata": {},
"output_type": "pyout",
"prompt_number": 58,
"text": [
"0 5.330952\n",
"1 5.654762\n",
"2 7.188095\n",
"3 8.611905\n",
"4 5.675000\n",
"5 9.369048\n",
"6 11.342857\n",
"7 11.445238\n",
"8 11.916667\n",
"9 19.777778\n",
"dtype: float64"
]
}
],
"prompt_number": 58
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"We can see below that the mean odds are not the same as the first hidden column."
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"pd.concat([df.loc[:,0], df.loc[:,1], mean_odds], 1)"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>0</th>\n",
" <th>1</th>\n",
" <th>2</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0 </th>\n",
" <td> 6.4</td>\n",
" <td> brazil 2-0</td>\n",
" <td> 5.330952</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1 </th>\n",
" <td> 6.5</td>\n",
" <td> brazil 1-0</td>\n",
" <td> 5.654762</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2 </th>\n",
" <td> 8.5</td>\n",
" <td> brazil 3-0</td>\n",
" <td> 7.188095</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3 </th>\n",
" <td> 10.0</td>\n",
" <td> brazil 2-1</td>\n",
" <td> 8.611905</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4 </th>\n",
" <td> 10.5</td>\n",
" <td> any other score</td>\n",
" <td> 5.675000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5 </th>\n",
" <td> 12.0</td>\n",
" <td> draw 1-1</td>\n",
" <td> 9.369048</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6 </th>\n",
" <td> 13.0</td>\n",
" <td> brazil 3-1</td>\n",
" <td> 11.342857</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7 </th>\n",
" <td> 15.0</td>\n",
" <td> draw 0-0</td>\n",
" <td> 11.445238</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8 </th>\n",
" <td> 15.0</td>\n",
" <td> brazil 4-0</td>\n",
" <td> 11.916667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9 </th>\n",
" <td> 23.0</td>\n",
" <td> brazil 4-1</td>\n",
" <td> 19.777778</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td> 29.0</td>\n",
" <td> croatia 1-0</td>\n",
" <td> 21.928571</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td> 34.0</td>\n",
" <td> draw 2-2</td>\n",
" <td> 26.285714</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td> 34.0</td>\n",
" <td> brazil 5-0</td>\n",
" <td> 25.323529</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td> 36.0</td>\n",
" <td> croatia 2-1</td>\n",
" <td> 30.714286</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td> 42.5</td>\n",
" <td> brazil 3-2</td>\n",
" <td> 34.452381</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td> 51.0</td>\n",
" <td> brazil 5-1</td>\n",
" <td> 41.352941</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td> 81.0</td>\n",
" <td> brazil 4-2</td>\n",
" <td> 61.083333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td> 91.0</td>\n",
" <td> croatia 2-0</td>\n",
" <td> 68.119048</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td> 101.0</td>\n",
" <td> brazil 6-0</td>\n",
" <td> 60.875000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td> 101.0</td>\n",
" <td> brazil 6-1</td>\n",
" <td> 87.928571</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td> 151.0</td>\n",
" <td> croatia 3-2</td>\n",
" <td> 107.761905</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td> 170.0</td>\n",
" <td> brazil 5-2</td>\n",
" <td> 110.933333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td> 201.0</td>\n",
" <td> draw 3-3</td>\n",
" <td> 127.047619</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td> 201.0</td>\n",
" <td> croatia 3-1</td>\n",
" <td> 124.523810</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td> 201.0</td>\n",
" <td> brazil 7-0</td>\n",
" <td> 139.642857</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td> 250.0</td>\n",
" <td> draw 5-5</td>\n",
" <td> 249.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td> 251.0</td>\n",
" <td> brazil 4-3</td>\n",
" <td> 182.933333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td> 251.0</td>\n",
" <td> brazil 6-2</td>\n",
" <td> 209.090909</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td> 251.0</td>\n",
" <td> brazil 7-1</td>\n",
" <td> 191.923077</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td> 301.0</td>\n",
" <td> croatia 6-3</td>\n",
" <td> 300.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>30</th>\n",
" <td> 301.0</td>\n",
" <td> croatia 7-2</td>\n",
" <td> 300.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31</th>\n",
" <td> 351.0</td>\n",
" <td> draw 4-4</td>\n",
" <td> 245.363636</td>\n",
" </tr>\n",
" <tr>\n",
" <th>32</th>\n",
" <td> 401.0</td>\n",
" <td> croatia 3-0</td>\n",
" <td> 197.550000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>33</th>\n",
" <td> 401.0</td>\n",
" <td> brazil 6-3</td>\n",
" <td> 325.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>34</th>\n",
" <td> 426.0</td>\n",
" <td> brazil 5-3</td>\n",
" <td> 287.400000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>35</th>\n",
" <td> 501.0</td>\n",
" <td> brazil 10-0</td>\n",
" <td> 500.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>36</th>\n",
" <td> 501.0</td>\n",
" <td> brazil 5-4</td>\n",
" <td> 324.750000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>37</th>\n",
" <td> 501.0</td>\n",
" <td> brazil 7-2</td>\n",
" <td> 350.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>38</th>\n",
" <td> 501.0</td>\n",
" <td> brazil 8-0</td>\n",
" <td> 275.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>39</th>\n",
" <td> 501.0</td>\n",
" <td> brazil 8-1</td>\n",
" <td> 370.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>40</th>\n",
" <td> 501.0</td>\n",
" <td> brazil 9-0</td>\n",
" <td> 400.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>41</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 10-0</td>\n",
" <td> 500.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 4-0</td>\n",
" <td> 229.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 4-1</td>\n",
" <td> 236.533333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 4-2</td>\n",
" <td> 249.875000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 4-3</td>\n",
" <td> 259.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>46</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 5-0</td>\n",
" <td> 229.800000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>47</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 5-1</td>\n",
" <td> 229.800000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>48</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 5-2</td>\n",
" <td> 299.888889</td>\n",
" </tr>\n",
" <tr>\n",
" <th>49</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 5-3</td>\n",
" <td> 285.571429</td>\n",
" </tr>\n",
" <tr>\n",
" <th>50</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 5-4</td>\n",
" <td> 324.750000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>51</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 6-0</td>\n",
" <td> 231.125000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>52</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 6-1</td>\n",
" <td> 291.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>53</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 6-2</td>\n",
" <td> 291.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>54</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 7-0</td>\n",
" <td> 300.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>55</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 7-1</td>\n",
" <td> 325.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>56</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 8-0</td>\n",
" <td> 325.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>57</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 8-1</td>\n",
" <td> 366.666667</td>\n",
" </tr>\n",
" <tr>\n",
" <th>58</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 9-0</td>\n",
" <td> 366.666667</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 59,
"text": [
" 0 1 2\n",
"0 6.4 brazil 2-0 5.330952\n",
"1 6.5 brazil 1-0 5.654762\n",
"2 8.5 brazil 3-0 7.188095\n",
"3 10.0 brazil 2-1 8.611905\n",
"4 10.5 any other score 5.675000\n",
"5 12.0 draw 1-1 9.369048\n",
"6 13.0 brazil 3-1 11.342857\n",
"7 15.0 draw 0-0 11.445238\n",
"8 15.0 brazil 4-0 11.916667\n",
"9 23.0 brazil 4-1 19.777778\n",
"10 29.0 croatia 1-0 21.928571\n",
"11 34.0 draw 2-2 26.285714\n",
"12 34.0 brazil 5-0 25.323529\n",
"13 36.0 croatia 2-1 30.714286\n",
"14 42.5 brazil 3-2 34.452381\n",
"15 51.0 brazil 5-1 41.352941\n",
"16 81.0 brazil 4-2 61.083333\n",
"17 91.0 croatia 2-0 68.119048\n",
"18 101.0 brazil 6-0 60.875000\n",
"19 101.0 brazil 6-1 87.928571\n",
"20 151.0 croatia 3-2 107.761905\n",
"21 170.0 brazil 5-2 110.933333\n",
"22 201.0 draw 3-3 127.047619\n",
"23 201.0 croatia 3-1 124.523810\n",
"24 201.0 brazil 7-0 139.642857\n",
"25 250.0 draw 5-5 249.000000\n",
"26 251.0 brazil 4-3 182.933333\n",
"27 251.0 brazil 6-2 209.090909\n",
"28 251.0 brazil 7-1 191.923077\n",
"29 301.0 croatia 6-3 300.000000\n",
"30 301.0 croatia 7-2 300.000000\n",
"31 351.0 draw 4-4 245.363636\n",
"32 401.0 croatia 3-0 197.550000\n",
"33 401.0 brazil 6-3 325.000000\n",
"34 426.0 brazil 5-3 287.400000\n",
"35 501.0 brazil 10-0 500.000000\n",
"36 501.0 brazil 5-4 324.750000\n",
"37 501.0 brazil 7-2 350.000000\n",
"38 501.0 brazil 8-0 275.000000\n",
"39 501.0 brazil 8-1 370.000000\n",
"40 501.0 brazil 9-0 400.000000\n",
"41 501.0 croatia 10-0 500.000000\n",
"42 501.0 croatia 4-0 229.000000\n",
"43 501.0 croatia 4-1 236.533333\n",
"44 501.0 croatia 4-2 249.875000\n",
"45 501.0 croatia 4-3 259.000000\n",
"46 501.0 croatia 5-0 229.800000\n",
"47 501.0 croatia 5-1 229.800000\n",
"48 501.0 croatia 5-2 299.888889\n",
"49 501.0 croatia 5-3 285.571429\n",
"50 501.0 croatia 5-4 324.750000\n",
"51 501.0 croatia 6-0 231.125000\n",
"52 501.0 croatia 6-1 291.666667\n",
"53 501.0 croatia 6-2 291.666667\n",
"54 501.0 croatia 7-0 300.000000\n",
"55 501.0 croatia 7-1 325.000000\n",
"56 501.0 croatia 8-0 325.000000\n",
"57 501.0 croatia 8-1 366.666667\n",
"58 501.0 croatia 9-0 366.666667"
]
}
],
"prompt_number": 59
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"It looks like the first number is the maximum (best) odds you can get. And the list is sorted accordingly."
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"pd.concat([df.loc[:,0], df.loc[:,1], df3.loc[:, 3:].max(1)], 1)"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>0</th>\n",
" <th>1</th>\n",
" <th>2</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0 </th>\n",
" <td> 6.4</td>\n",
" <td> brazil 2-0</td>\n",
" <td> 6.4</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1 </th>\n",
" <td> 6.5</td>\n",
" <td> brazil 1-0</td>\n",
" <td> 6.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2 </th>\n",
" <td> 8.5</td>\n",
" <td> brazil 3-0</td>\n",
" <td> 8.6</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3 </th>\n",
" <td> 10.0</td>\n",
" <td> brazil 2-1</td>\n",
" <td> 9.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4 </th>\n",
" <td> 10.5</td>\n",
" <td> any other score</td>\n",
" <td> 10.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5 </th>\n",
" <td> 12.0</td>\n",
" <td> draw 1-1</td>\n",
" <td> 11.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6 </th>\n",
" <td> 13.0</td>\n",
" <td> brazil 3-1</td>\n",
" <td> 14.2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7 </th>\n",
" <td> 15.0</td>\n",
" <td> draw 0-0</td>\n",
" <td> 14.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8 </th>\n",
" <td> 15.0</td>\n",
" <td> brazil 4-0</td>\n",
" <td> 14.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9 </th>\n",
" <td> 23.0</td>\n",
" <td> brazil 4-1</td>\n",
" <td> 22.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td> 29.0</td>\n",
" <td> croatia 1-0</td>\n",
" <td> 29.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td> 34.0</td>\n",
" <td> draw 2-2</td>\n",
" <td> 33.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td> 34.0</td>\n",
" <td> brazil 5-0</td>\n",
" <td> 33.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td> 36.0</td>\n",
" <td> croatia 2-1</td>\n",
" <td> 38.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td> 42.5</td>\n",
" <td> brazil 3-2</td>\n",
" <td> 42.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td> 51.0</td>\n",
" <td> brazil 5-1</td>\n",
" <td> 50.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td> 81.0</td>\n",
" <td> brazil 4-2</td>\n",
" <td> 80.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td> 91.0</td>\n",
" <td> croatia 2-0</td>\n",
" <td> 100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td> 101.0</td>\n",
" <td> brazil 6-0</td>\n",
" <td> 100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td> 101.0</td>\n",
" <td> brazil 6-1</td>\n",
" <td> 100.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td> 151.0</td>\n",
" <td> croatia 3-2</td>\n",
" <td> 156.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td> 170.0</td>\n",
" <td> brazil 5-2</td>\n",
" <td> 169.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td> 201.0</td>\n",
" <td> draw 3-3</td>\n",
" <td> 200.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td> 201.0</td>\n",
" <td> croatia 3-1</td>\n",
" <td> 208.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td> 201.0</td>\n",
" <td> brazil 7-0</td>\n",
" <td> 200.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td> 250.0</td>\n",
" <td> draw 5-5</td>\n",
" <td> 249.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td> 251.0</td>\n",
" <td> brazil 4-3</td>\n",
" <td> 250.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td> 251.0</td>\n",
" <td> brazil 6-2</td>\n",
" <td> 250.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td> 251.0</td>\n",
" <td> brazil 7-1</td>\n",
" <td> 250.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td> 301.0</td>\n",
" <td> croatia 6-3</td>\n",
" <td> 300.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>30</th>\n",
" <td> 301.0</td>\n",
" <td> croatia 7-2</td>\n",
" <td> 300.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31</th>\n",
" <td> 351.0</td>\n",
" <td> draw 4-4</td>\n",
" <td> 350.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>32</th>\n",
" <td> 401.0</td>\n",
" <td> croatia 3-0</td>\n",
" <td> 400.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>33</th>\n",
" <td> 401.0</td>\n",
" <td> brazil 6-3</td>\n",
" <td> 400.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>34</th>\n",
" <td> 426.0</td>\n",
" <td> brazil 5-3</td>\n",
" <td> 425.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>35</th>\n",
" <td> 501.0</td>\n",
" <td> brazil 10-0</td>\n",
" <td> 500.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>36</th>\n",
" <td> 501.0</td>\n",
" <td> brazil 5-4</td>\n",
" <td> 500.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>37</th>\n",
" <td> 501.0</td>\n",
" <td> brazil 7-2</td>\n",
" <td> 500.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>38</th>\n",
" <td> 501.0</td>\n",
" <td> brazil 8-0</td>\n",
" <td> 500.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>39</th>\n",
" <td> 501.0</td>\n",
" <td> brazil 8-1</td>\n",
" <td> 500.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>40</th>\n",
" <td> 501.0</td>\n",
" <td> brazil 9-0</td>\n",
" <td> 500.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>41</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 10-0</td>\n",
" <td> 500.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 4-0</td>\n",
" <td> 500.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 4-1</td>\n",
" <td> 500.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 4-2</td>\n",
" <td> 500.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 4-3</td>\n",
" <td> 500.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>46</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 5-0</td>\n",
" <td> 500.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>47</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 5-1</td>\n",
" <td> 500.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>48</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 5-2</td>\n",
" <td> 500.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>49</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 5-3</td>\n",
" <td> 500.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>50</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 5-4</td>\n",
" <td> 500.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>51</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 6-0</td>\n",
" <td> 500.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>52</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 6-1</td>\n",
" <td> 500.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>53</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 6-2</td>\n",
" <td> 500.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>54</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 7-0</td>\n",
" <td> 500.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>55</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 7-1</td>\n",
" <td> 500.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>56</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 8-0</td>\n",
" <td> 500.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>57</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 8-1</td>\n",
" <td> 500.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>58</th>\n",
" <td> 501.0</td>\n",
" <td> croatia 9-0</td>\n",
" <td> 500.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 60,
"text": [
" 0 1 2\n",
"0 6.4 brazil 2-0 6.4\n",
"1 6.5 brazil 1-0 6.5\n",
"2 8.5 brazil 3-0 8.6\n",
"3 10.0 brazil 2-1 9.5\n",
"4 10.5 any other score 10.5\n",
"5 12.0 draw 1-1 11.0\n",
"6 13.0 brazil 3-1 14.2\n",
"7 15.0 draw 0-0 14.0\n",
"8 15.0 brazil 4-0 14.0\n",
"9 23.0 brazil 4-1 22.5\n",
"10 29.0 croatia 1-0 29.0\n",
"11 34.0 draw 2-2 33.0\n",
"12 34.0 brazil 5-0 33.0\n",
"13 36.0 croatia 2-1 38.0\n",
"14 42.5 brazil 3-2 42.5\n",
"15 51.0 brazil 5-1 50.0\n",
"16 81.0 brazil 4-2 80.0\n",
"17 91.0 croatia 2-0 100.0\n",
"18 101.0 brazil 6-0 100.0\n",
"19 101.0 brazil 6-1 100.0\n",
"20 151.0 croatia 3-2 156.0\n",
"21 170.0 brazil 5-2 169.0\n",
"22 201.0 draw 3-3 200.0\n",
"23 201.0 croatia 3-1 208.0\n",
"24 201.0 brazil 7-0 200.0\n",
"25 250.0 draw 5-5 249.0\n",
"26 251.0 brazil 4-3 250.0\n",
"27 251.0 brazil 6-2 250.0\n",
"28 251.0 brazil 7-1 250.0\n",
"29 301.0 croatia 6-3 300.0\n",
"30 301.0 croatia 7-2 300.0\n",
"31 351.0 draw 4-4 350.0\n",
"32 401.0 croatia 3-0 400.0\n",
"33 401.0 brazil 6-3 400.0\n",
"34 426.0 brazil 5-3 425.0\n",
"35 501.0 brazil 10-0 500.0\n",
"36 501.0 brazil 5-4 500.0\n",
"37 501.0 brazil 7-2 500.0\n",
"38 501.0 brazil 8-0 500.0\n",
"39 501.0 brazil 8-1 500.0\n",
"40 501.0 brazil 9-0 500.0\n",
"41 501.0 croatia 10-0 500.0\n",
"42 501.0 croatia 4-0 500.0\n",
"43 501.0 croatia 4-1 500.0\n",
"44 501.0 croatia 4-2 500.0\n",
"45 501.0 croatia 4-3 500.0\n",
"46 501.0 croatia 5-0 500.0\n",
"47 501.0 croatia 5-1 500.0\n",
"48 501.0 croatia 5-2 500.0\n",
"49 501.0 croatia 5-3 500.0\n",
"50 501.0 croatia 5-4 500.0\n",
"51 501.0 croatia 6-0 500.0\n",
"52 501.0 croatia 6-1 500.0\n",
"53 501.0 croatia 6-2 500.0\n",
"54 501.0 croatia 7-0 500.0\n",
"55 501.0 croatia 7-1 500.0\n",
"56 501.0 croatia 8-0 500.0\n",
"57 501.0 croatia 8-1 500.0\n",
"58 501.0 croatia 9-0 500.0"
]
}
],
"prompt_number": 60
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"It looks like the first entry is always the one with the lowest odds (most likely)\n",
"\n",
"Fetch most likely standing by catching the first entry"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"def standing(team1, team2):\n",
" df = pd.read_html('http://www.oddschecker.com/football/world-cup/%s-v-%s/correct-score' % (team1, team2), attrs = {'class': 'eventTable'}, infer_types=False)[0]\n",
" print('%s - %s / standing: %s'% (team1, team2, df.loc[0,1]))\n",
" \n",
"print('Group A')\n",
"standing('brazil', 'croatia')\n",
"standing('mexico', 'cameroon')"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "stream",
"stream": "stdout",
"text": [
"Group A\n",
"brazil - croatia / standing: brazil 2-0"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"mexico - cameroon / standing: mexico 1-0"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n"
]
}
],
"prompt_number": 43
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Order of the games in the pool form"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"order = [0,1,2,3,0,2,3,1,3,0,1,2]\n",
"zip(*[iter(order)]*2)"
],
"language": "python",
"metadata": {},
"outputs": [
{
"metadata": {},
"output_type": "pyout",
"prompt_number": 49,
"text": [
"[(0, 1), (2, 3), (0, 2), (3, 1), (3, 0), (1, 2)]"
]
}
],
"prompt_number": 49
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Now calculate all standings for every game. And ... voila we have the most probable outcomes according to 25 betting markets.\n",
"\n",
"Be sure to run it as late as possible, as the odds are becoming more accurate the closer we are to the world cup."
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"import numpy as np\n",
"\n",
"def standing(team1, team2):\n",
" df = pd.read_html('http://www.oddschecker.com/football/world-cup/%s-v-%s/correct-score' % (team1, team2), attrs = {'class': 'eventTable'}, infer_types=False)[0]\n",
" print('%s - %s / standing: %s'% (team1, team2, df.loc[0,1]))\n",
"\n",
"def to_vs(teams): \n",
" order = [0,1,2,3,0,2,3,1,3,0,1,2]\n",
" return zip(*[iter(teams[order])]*2)\n",
"\n",
"# Groups\n",
"group_a = np.array(['brazil', 'croatia', 'mexico', 'cameroon'])\n",
"group_b = np.array(['spain', 'netherlands', 'chile', 'australia'])\n",
"group_c = np.array(['colombia', 'greece', 'ivory-coast', 'japan'])\n",
"group_d = np.array(['uruguay', 'costa-rica', 'england', 'italy'])\n",
"group_e = np.array(['switzerland', 'ecuador', 'france', 'honduras'])\n",
"group_f = np.array(['argentina', 'bosnia-herzegovina', 'iran', 'nigeria'])\n",
"group_g = np.array(['germany', 'portugal', 'ghana', 'usa'])\n",
"group_h = np.array(['belgium', 'algeria', 'russia', 'south-korea'])\n",
"\n",
"for i, group in enumerate([group_a, group_b, group_c, group_d, group_e, group_f, group_g, group_h]):\n",
" group_letter = chr(ord('a') + i)\n",
" print \"-\" * 20\n",
" print \"Group %s\" % group_letter\n",
" print \"-\" * 20\n",
" for match in to_vs(group):\n",
" try:\n",
" standing(*match)\n",
" except:\n",
" print(\"%s-%s mislukt\" % match)"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "stream",
"stream": "stdout",
"text": [
"--------------------\n",
"Group a\n",
"--------------------\n",
"brazil - croatia / standing: brazil 2-0"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"mexico - cameroon / standing: mexico 1-0"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"brazil - mexico / standing: brazil 2-0"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"cameroon - croatia / standing: croatia 1-0"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"cameroon - brazil / standing: brazil 2-0"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"croatia - mexico / standing: draw 1-1"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"--------------------\n",
"Group b\n",
"--------------------\n",
"spain - netherlands / standing: spain 1-0"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"chile - australia / standing: chile 1-0"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"spain - chile / standing: spain 1-0"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"australia - netherlands / standing: netherlands 2-0"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"australia - spain / standing: spain 2-0"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"netherlands - chile / standing: draw 1-1"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"--------------------\n",
"Group c\n",
"--------------------\n",
"colombia - greece / standing: colombia 1-0"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"ivory-coast - japan / standing: draw 1-1"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"colombia - ivory-coast / standing: colombia 1-0"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"japan - greece / standing: draw 1-1"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"japan - colombia / standing: colombia 1-0"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"greece - ivory-coast / standing: draw 1-1"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"--------------------\n",
"Group d\n",
"--------------------\n",
"uruguay - costa-rica / standing: uruguay 1-0"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"england - italy / standing: draw 1-1"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"uruguay - england / standing: draw 1-1"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"italy - costa-rica / standing: italy 2-0"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"italy - uruguay / standing: draw 1-1"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"costa-rica - england / standing: england 2-0"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"--------------------\n",
"Group e\n",
"--------------------\n",
"switzerland - ecuador / standing: draw 1-1"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"france - honduras / standing: france 1-0"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"switzerland - france / standing: draw 1-1"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"honduras - ecuador / standing: ecuador 1-0"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"honduras - switzerland / standing: switzerland 1-0"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"ecuador - france / standing: france 1-0"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"--------------------\n",
"Group f\n",
"--------------------\n",
"argentina - bosnia-herzegovina / standing: argentina 2-0"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"iran - nigeria / standing: nigeria 1-0"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"argentina - iran / standing: argentina 2-0"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"nigeria - bosnia-herzegovina / standing: draw 1-1"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"nigeria - argentina / standing: argentina 1-0"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"bosnia-herzegovina-iran mislukt"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"--------------------\n",
"Group g\n",
"--------------------\n",
"germany - portugal / standing: draw 1-1"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"ghana - usa / standing: draw 1-1"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"germany - ghana / standing: germany 2-0"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"usa - portugal / standing: portugal 1-0"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"usa - germany / standing: germany 2-0"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"portugal - ghana / standing: portugal 1-0"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"--------------------\n",
"Group h\n",
"--------------------\n",
"belgium - algeria / standing: belgium 1-0"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"russia - south-korea / standing: russia 1-0"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"belgium - russia / standing: draw 1-1"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"south-korea - algeria / standing: draw 1-1"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"south-korea - belgium / standing: belgium 1-0"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n",
"algeria - russia / standing: russia 1-0"
]
},
{
"output_type": "stream",
"stream": "stdout",
"text": [
"\n"
]
}
],
"prompt_number": 65
},
{
"cell_type": "code",
"collapsed": false,
"input": [],
"language": "python",
"metadata": {},
"outputs": []
}
],
"metadata": {}
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment