{ "metadata": { "name": "", "signature": "sha256:6e9f44a0d1b02463710851105860d65cb63879df0c34eb860aeb4a7565ce4e89" }, "nbformat": 3, "nbformat_minor": 0, "worksheets": [ { "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Battle of Five Kings Dataset\n", "\n", "- **Author:** [Chris Albon](http://www.chrisalbon.com/), [@ChrisAlbon](https://twitter.com/chrisalbon)\n", "- **Date:** -\n", "- **Repo:** [Python 3 code snippets for data science](https://github.com/chrisalbon/code_py)\n", "- **Note:** 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": [ "
\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
nameyearbattle_numberattacker_kingdefender_kingattacker_1attacker_2attacker_3attacker_4defender_1defender_2defender_3defender_4attacker_outcomebattle_typemajor_deathmajor_captureattacker_sizedefender_sizeattacker_commanderdefender_commandersummerlocationregionnote
0 Battle of the Golden Tooth 298 1 Joffrey/Tommen Baratheon Robb Stark Lannister NaN NaN NaN Tully NaNNaNNaN win pitched battle 1 0 15000 4000 Jaime Lannister Clement Piper, Vance 1 Golden Tooth The Westerlands NaN
1 Battle at the Mummer's Ford 298 2 Joffrey/Tommen Baratheon Robb Stark Lannister NaN NaN NaN Baratheon NaNNaNNaN win ambush 1 0 NaN 120 Gregor Clegane Beric Dondarrion 1 Mummer's Ford The Riverlands NaN
2 Battle of Riverrun 298 3 Joffrey/Tommen Baratheon Robb Stark Lannister NaN NaN NaN Tully NaNNaNNaN win pitched battle 0 1 15000 10000 Jaime Lannister, Andros Brax Edmure Tully, Tytos Blackwood 1 Riverrun The Riverlands NaN
3 Battle of the Green Fork 298 4 Robb Stark Joffrey/Tommen Baratheon Stark NaN NaN NaN Lannister NaNNaNNaN loss pitched battle 1 1 18000 20000 Roose Bolton, Wylis Manderly, Medger Cerwyn, H... Tywin Lannister, Gregor Clegane, Kevan Lannist... 1 Green Fork The Riverlands NaN
4 Battle of the Whispering Wood 298 5 Robb Stark Joffrey/Tommen Baratheon Stark Tully NaN NaN Lannister NaNNaNNaN win ambush 1 1 1875 6000 Robb Stark, Brynden Tully Jaime Lannister 1 Whispering Wood The Riverlands NaN
\n", "
" ], "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": {} } ] }