dataset_war_of_five_kings.ipynb

{
 "metadata": {
  "name": "",
  "signature": "sha256:b1928bd13ba79ca40e6401c99d086b4997133b5c2bd79e81203fce4f62f22e58"
 },
 "nbformat": 3,
 "nbformat_minor": 0,
 "worksheets": [
  {
   "cells": [
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "# Battle of Five Kings Dataset\n",
      "\n",
      "This snippit was written by [Chris R. Albon](http://www.chrisralbon.com/) and is part of his collection of [well-documented Python snippits](/~https://github.com/chrisalbon/code_py). All code is written in Python 3 in iPython notebook and offered under the [Creative Commons Attribution-ShareAlike 4.0 International License](http://creativecommons.org/licenses/by-sa/4.0/).\n",
      "\n",
      "Based on: /~https://github.com/chrisalbon/war_of_the_five_kings_dataset"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "# Import modules\n",
      "import pandas as pd\n",
      "\n",
      "# Set ipython's max row display\n",
      "pd.set_option('display.max_row', 1000)\n",
      "\n",
      "# Set iPython's max column width to 50\n",
      "pd.set_option('display.max_columns', 50)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 1
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "df = pd.read_csv('https://www.dropbox.com/s/52cb7kcflr8qm2u/5kings_battles_v1.csv?dl=1')\n",
      "df.head()"
     ],
     "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>name</th>\n",
        "      <th>year</th>\n",
        "      <th>battle_number</th>\n",
        "      <th>attacker_king</th>\n",
        "      <th>defender_king</th>\n",
        "      <th>attacker_1</th>\n",
        "      <th>attacker_2</th>\n",
        "      <th>attacker_3</th>\n",
        "      <th>attacker_4</th>\n",
        "      <th>defender_1</th>\n",
        "      <th>defender_2</th>\n",
        "      <th>defender_3</th>\n",
        "      <th>defender_4</th>\n",
        "      <th>attacker_outcome</th>\n",
        "      <th>battle_type</th>\n",
        "      <th>major_death</th>\n",
        "      <th>major_capture</th>\n",
        "      <th>attacker_size</th>\n",
        "      <th>defender_size</th>\n",
        "      <th>attacker_commander</th>\n",
        "      <th>defender_commander</th>\n",
        "      <th>summer</th>\n",
        "      <th>location</th>\n",
        "      <th>region</th>\n",
        "      <th>note</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>    Battle of the Golden Tooth</td>\n",
        "      <td> 298</td>\n",
        "      <td> 1</td>\n",
        "      <td> Joffrey/Tommen Baratheon</td>\n",
        "      <td>               Robb Stark</td>\n",
        "      <td> Lannister</td>\n",
        "      <td>   NaN</td>\n",
        "      <td> NaN</td>\n",
        "      <td> NaN</td>\n",
        "      <td>     Tully</td>\n",
        "      <td> NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  win</td>\n",
        "      <td> pitched battle</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td> 15000</td>\n",
        "      <td>  4000</td>\n",
        "      <td>                                   Jaime Lannister</td>\n",
        "      <td>                              Clement Piper, Vance</td>\n",
        "      <td> 1</td>\n",
        "      <td>    Golden Tooth</td>\n",
        "      <td> The Westerlands</td>\n",
        "      <td> NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1</th>\n",
        "      <td>   Battle at the Mummer's Ford</td>\n",
        "      <td> 298</td>\n",
        "      <td> 2</td>\n",
        "      <td> Joffrey/Tommen Baratheon</td>\n",
        "      <td>               Robb Stark</td>\n",
        "      <td> Lannister</td>\n",
        "      <td>   NaN</td>\n",
        "      <td> NaN</td>\n",
        "      <td> NaN</td>\n",
        "      <td> Baratheon</td>\n",
        "      <td> NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  win</td>\n",
        "      <td>         ambush</td>\n",
        "      <td> 1</td>\n",
        "      <td> 0</td>\n",
        "      <td>   NaN</td>\n",
        "      <td>   120</td>\n",
        "      <td>                                    Gregor Clegane</td>\n",
        "      <td>                                  Beric Dondarrion</td>\n",
        "      <td> 1</td>\n",
        "      <td>   Mummer's Ford</td>\n",
        "      <td>  The Riverlands</td>\n",
        "      <td> NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2</th>\n",
        "      <td>            Battle of Riverrun</td>\n",
        "      <td> 298</td>\n",
        "      <td> 3</td>\n",
        "      <td> Joffrey/Tommen Baratheon</td>\n",
        "      <td>               Robb Stark</td>\n",
        "      <td> Lannister</td>\n",
        "      <td>   NaN</td>\n",
        "      <td> NaN</td>\n",
        "      <td> NaN</td>\n",
        "      <td>     Tully</td>\n",
        "      <td> NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  win</td>\n",
        "      <td> pitched battle</td>\n",
        "      <td> 0</td>\n",
        "      <td> 1</td>\n",
        "      <td> 15000</td>\n",
        "      <td> 10000</td>\n",
        "      <td>                      Jaime Lannister, Andros Brax</td>\n",
        "      <td>                     Edmure Tully, Tytos Blackwood</td>\n",
        "      <td> 1</td>\n",
        "      <td>        Riverrun</td>\n",
        "      <td>  The Riverlands</td>\n",
        "      <td> NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3</th>\n",
        "      <td>      Battle of the Green Fork</td>\n",
        "      <td> 298</td>\n",
        "      <td> 4</td>\n",
        "      <td>               Robb Stark</td>\n",
        "      <td> Joffrey/Tommen Baratheon</td>\n",
        "      <td>     Stark</td>\n",
        "      <td>   NaN</td>\n",
        "      <td> NaN</td>\n",
        "      <td> NaN</td>\n",
        "      <td> Lannister</td>\n",
        "      <td> NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> loss</td>\n",
        "      <td> pitched battle</td>\n",
        "      <td> 1</td>\n",
        "      <td> 1</td>\n",
        "      <td> 18000</td>\n",
        "      <td> 20000</td>\n",
        "      <td> Roose Bolton, Wylis Manderly, Medger Cerwyn, H...</td>\n",
        "      <td> Tywin Lannister, Gregor Clegane, Kevan Lannist...</td>\n",
        "      <td> 1</td>\n",
        "      <td>      Green Fork</td>\n",
        "      <td>  The Riverlands</td>\n",
        "      <td> NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>4</th>\n",
        "      <td> Battle of the Whispering Wood</td>\n",
        "      <td> 298</td>\n",
        "      <td> 5</td>\n",
        "      <td>               Robb Stark</td>\n",
        "      <td> Joffrey/Tommen Baratheon</td>\n",
        "      <td>     Stark</td>\n",
        "      <td> Tully</td>\n",
        "      <td> NaN</td>\n",
        "      <td> NaN</td>\n",
        "      <td> Lannister</td>\n",
        "      <td> NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  win</td>\n",
        "      <td>         ambush</td>\n",
        "      <td> 1</td>\n",
        "      <td> 1</td>\n",
        "      <td>  1875</td>\n",
        "      <td>  6000</td>\n",
        "      <td>                         Robb Stark, Brynden Tully</td>\n",
        "      <td>                                   Jaime Lannister</td>\n",
        "      <td> 1</td>\n",
        "      <td> Whispering Wood</td>\n",
        "      <td>  The Riverlands</td>\n",
        "      <td> NaN</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 2,
       "text": [
        "                            name  year  battle_number  \\\n",
        "0     Battle of the Golden Tooth   298              1   \n",
        "1    Battle at the Mummer's Ford   298              2   \n",
        "2             Battle of Riverrun   298              3   \n",
        "3       Battle of the Green Fork   298              4   \n",
        "4  Battle of the Whispering Wood   298              5   \n",
        "\n",
        "              attacker_king             defender_king attacker_1 attacker_2  \\\n",
        "0  Joffrey/Tommen Baratheon                Robb Stark  Lannister        NaN   \n",
        "1  Joffrey/Tommen Baratheon                Robb Stark  Lannister        NaN   \n",
        "2  Joffrey/Tommen Baratheon                Robb Stark  Lannister        NaN   \n",
        "3                Robb Stark  Joffrey/Tommen Baratheon      Stark        NaN   \n",
        "4                Robb Stark  Joffrey/Tommen Baratheon      Stark      Tully   \n",
        "\n",
        "  attacker_3 attacker_4 defender_1 defender_2  defender_3  defender_4  \\\n",
        "0        NaN        NaN      Tully        NaN         NaN         NaN   \n",
        "1        NaN        NaN  Baratheon        NaN         NaN         NaN   \n",
        "2        NaN        NaN      Tully        NaN         NaN         NaN   \n",
        "3        NaN        NaN  Lannister        NaN         NaN         NaN   \n",
        "4        NaN        NaN  Lannister        NaN         NaN         NaN   \n",
        "\n",
        "  attacker_outcome     battle_type  major_death  major_capture  attacker_size  \\\n",
        "0              win  pitched battle            1              0          15000   \n",
        "1              win          ambush            1              0            NaN   \n",
        "2              win  pitched battle            0              1          15000   \n",
        "3             loss  pitched battle            1              1          18000   \n",
        "4              win          ambush            1              1           1875   \n",
        "\n",
        "   defender_size                                 attacker_commander  \\\n",
        "0           4000                                    Jaime Lannister   \n",
        "1            120                                     Gregor Clegane   \n",
        "2          10000                       Jaime Lannister, Andros Brax   \n",
        "3          20000  Roose Bolton, Wylis Manderly, Medger Cerwyn, H...   \n",
        "4           6000                          Robb Stark, Brynden Tully   \n",
        "\n",
        "                                  defender_commander  summer         location  \\\n",
        "0                               Clement Piper, Vance       1     Golden Tooth   \n",
        "1                                   Beric Dondarrion       1    Mummer's Ford   \n",
        "2                      Edmure Tully, Tytos Blackwood       1         Riverrun   \n",
        "3  Tywin Lannister, Gregor Clegane, Kevan Lannist...       1       Green Fork   \n",
        "4                                    Jaime Lannister       1  Whispering Wood   \n",
        "\n",
        "            region note  \n",
        "0  The Westerlands  NaN  \n",
        "1   The Riverlands  NaN  \n",
        "2   The Riverlands  NaN  \n",
        "3   The Riverlands  NaN  \n",
        "4   The Riverlands  NaN  "
       ]
      }
     ],
     "prompt_number": 2
    }
   ],
   "metadata": {}
  }
 ]
}