01-Ingest.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Ingest\n",
    "\n",
    "Goal: Get all cards read in from JSON and saved as a pickle. Keep as much data as will be useful, drop the rest. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import json\n",
    "import re"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "To download all the cards run:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# import all magic cards ever printed, from web 14mb\n",
    "\n",
    "# allsets = pd.read_json('http://mtgjson.com/json/AllSetsArray.json')\n",
    "# allsets.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Else run this to load a locally stored file (and be nice to our kind friend's api)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>block</th>\n",
       "      <th>booster</th>\n",
       "      <th>border</th>\n",
       "      <th>cards</th>\n",
       "      <th>code</th>\n",
       "      <th>gathererCode</th>\n",
       "      <th>magicCardsInfoCode</th>\n",
       "      <th>magicRaritiesCodes</th>\n",
       "      <th>name</th>\n",
       "      <th>oldCode</th>\n",
       "      <th>onlineOnly</th>\n",
       "      <th>releaseDate</th>\n",
       "      <th>type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>Battle for Zendikar</td>\n",
       "      <td>[[rare, mythic rare], uncommon, uncommon, unco...</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Bane of Bal...</td>\n",
       "      <td>BFZ</td>\n",
       "      <td>NaN</td>\n",
       "      <td>bfz</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Battle for Zendikar</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-10-02</td>\n",
       "      <td>expansion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Prairie Str...</td>\n",
       "      <td>EXP</td>\n",
       "      <td>NaN</td>\n",
       "      <td>exp</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Zendikar Expeditions</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-10-02</td>\n",
       "      <td>promo</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   block                                            booster  \\\n",
       "185  Battle for Zendikar  [[rare, mythic rare], uncommon, uncommon, unco...   \n",
       "186                  NaN                                                NaN   \n",
       "\n",
       "    border                                              cards code  \\\n",
       "185  black  [{u'layout': u'normal', u'name': u'Bane of Bal...  BFZ   \n",
       "186  black  [{u'layout': u'normal', u'name': u'Prairie Str...  EXP   \n",
       "\n",
       "    gathererCode magicCardsInfoCode magicRaritiesCodes                  name  \\\n",
       "185          NaN                bfz                NaN   Battle for Zendikar   \n",
       "186          NaN                exp                NaN  Zendikar Expeditions   \n",
       "\n",
       "    oldCode  onlineOnly releaseDate       type  \n",
       "185     NaN         NaN  2015-10-02  expansion  \n",
       "186     NaN         NaN  2015-10-02      promo  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n"
     ]
    }
   ],
   "source": [
    "# import all magic cards from file \n",
    "\n",
    "allsets = pd.read_json('data/AllSetsArray.json')\n",
    "allsets.tail(2)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "\n",
    "Top level dataframe is 186 rows of one set per row. Cards for that set are stored in the \"cards\" colum as another JSON array. Sets tend to have 200-350 cards in each."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# drop columns that are full of nan and/or junk\n",
    "\n",
    "allsets = allsets.drop(['booster', 'gathererCode', 'magicCardsInfoCode', \n",
    "                        'magicCardsInfoCode', 'code',\n",
    "                        'oldCode', 'onlineOnly', 'magicRaritiesCodes'\n",
    "                        ], axis=1)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Grab the most recent set and check it out"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 99,
   "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>artist</th>\n",
       "      <th>cmc</th>\n",
       "      <th>colors</th>\n",
       "      <th>flavor</th>\n",
       "      <th>id</th>\n",
       "      <th>imageName</th>\n",
       "      <th>layout</th>\n",
       "      <th>loyalty</th>\n",
       "      <th>manaCost</th>\n",
       "      <th>multiverseid</th>\n",
       "      <th>...</th>\n",
       "      <th>rarity</th>\n",
       "      <th>subtypes</th>\n",
       "      <th>supertypes</th>\n",
       "      <th>text</th>\n",
       "      <th>toughness</th>\n",
       "      <th>type</th>\n",
       "      <th>types</th>\n",
       "      <th>variations</th>\n",
       "      <th>set</th>\n",
       "      <th>releaseDate</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Chase Stone</td>\n",
       "      <td>7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The continent of Bala Ged was ravaged by massi...</td>\n",
       "      <td>b2baccd791f5ada8bbd505f11bf81e70c8ea27ab</td>\n",
       "      <td>bane of bala ged</td>\n",
       "      <td>normal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>{7}</td>\n",
       "      <td>401814</td>\n",
       "      <td>...</td>\n",
       "      <td>Uncommon</td>\n",
       "      <td>[Eldrazi]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Whenever Bane of Bala Ged attacks, defending p...</td>\n",
       "      <td>5</td>\n",
       "      <td>Creature — Eldrazi</td>\n",
       "      <td>[Creature]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Battle for Zendikar</td>\n",
       "      <td>2015-10-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Todd Lockwood</td>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>cfff5e44e0263f10015fcf613b0f40065acf00b7</td>\n",
       "      <td>blight herder</td>\n",
       "      <td>normal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>{5}</td>\n",
       "      <td>401819</td>\n",
       "      <td>...</td>\n",
       "      <td>Rare</td>\n",
       "      <td>[Eldrazi, Processor]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>When you cast Blight Herder, you may put two c...</td>\n",
       "      <td>5</td>\n",
       "      <td>Creature — Eldrazi Processor</td>\n",
       "      <td>[Creature]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Battle for Zendikar</td>\n",
       "      <td>2015-10-02</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          artist  cmc colors  \\\n",
       "0    Chase Stone    7    NaN   \n",
       "1  Todd Lockwood    5    NaN   \n",
       "\n",
       "                                              flavor  \\\n",
       "0  The continent of Bala Ged was ravaged by massi...   \n",
       "1                                                NaN   \n",
       "\n",
       "                                         id         imageName  layout  \\\n",
       "0  b2baccd791f5ada8bbd505f11bf81e70c8ea27ab  bane of bala ged  normal   \n",
       "1  cfff5e44e0263f10015fcf613b0f40065acf00b7     blight herder  normal   \n",
       "\n",
       "   loyalty manaCost  multiverseid     ...        rarity              subtypes  \\\n",
       "0      NaN      {7}        401814     ...      Uncommon             [Eldrazi]   \n",
       "1      NaN      {5}        401819     ...          Rare  [Eldrazi, Processor]   \n",
       "\n",
       "  supertypes                                               text toughness  \\\n",
       "0        NaN  Whenever Bane of Bala Ged attacks, defending p...         5   \n",
       "1        NaN  When you cast Blight Herder, you may put two c...         5   \n",
       "\n",
       "                           type       types variations                  set  \\\n",
       "0            Creature — Eldrazi  [Creature]        NaN  Battle for Zendikar   \n",
       "1  Creature — Eldrazi Processor  [Creature]        NaN  Battle for Zendikar   \n",
       "\n",
       "  releaseDate  \n",
       "0  2015-10-02  \n",
       "1  2015-10-02  \n",
       "\n",
       "[2 rows x 23 columns]"
      ]
     },
     "execution_count": 99,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# zoom in on cards from latest set, 'Battle for Zendikar'\n",
    "\n",
    "zen = pd.read_json(json.dumps(allsets.cards[185]))\n",
    "\n",
    "# add set name and date\n",
    "zen['set'] = allsets.name[185]\n",
    "zen['releaseDate'] = allsets.releaseDate[185]\n",
    "\n",
    "zen.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 100,
   "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>artist</th>\n",
       "      <th>cmc</th>\n",
       "      <th>colors</th>\n",
       "      <th>flavor</th>\n",
       "      <th>manaCost</th>\n",
       "      <th>name</th>\n",
       "      <th>power</th>\n",
       "      <th>rarity</th>\n",
       "      <th>text</th>\n",
       "      <th>toughness</th>\n",
       "      <th>type</th>\n",
       "      <th>types</th>\n",
       "      <th>set</th>\n",
       "      <th>releaseDate</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Chase Stone</td>\n",
       "      <td>7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The continent of Bala Ged was ravaged by massi...</td>\n",
       "      <td>{7}</td>\n",
       "      <td>Bane of Bala Ged</td>\n",
       "      <td>7</td>\n",
       "      <td>Uncommon</td>\n",
       "      <td>Whenever Bane of Bala Ged attacks, defending p...</td>\n",
       "      <td>5</td>\n",
       "      <td>Creature — Eldrazi</td>\n",
       "      <td>[Creature]</td>\n",
       "      <td>Battle for Zendikar</td>\n",
       "      <td>2015-10-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Todd Lockwood</td>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>{5}</td>\n",
       "      <td>Blight Herder</td>\n",
       "      <td>4</td>\n",
       "      <td>Rare</td>\n",
       "      <td>When you cast Blight Herder, you may put two c...</td>\n",
       "      <td>5</td>\n",
       "      <td>Creature — Eldrazi Processor</td>\n",
       "      <td>[Creature]</td>\n",
       "      <td>Battle for Zendikar</td>\n",
       "      <td>2015-10-02</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          artist  cmc colors  \\\n",
       "0    Chase Stone    7    NaN   \n",
       "1  Todd Lockwood    5    NaN   \n",
       "\n",
       "                                              flavor manaCost  \\\n",
       "0  The continent of Bala Ged was ravaged by massi...      {7}   \n",
       "1                                                NaN      {5}   \n",
       "\n",
       "               name power    rarity  \\\n",
       "0  Bane of Bala Ged     7  Uncommon   \n",
       "1     Blight Herder     4      Rare   \n",
       "\n",
       "                                                text toughness  \\\n",
       "0  Whenever Bane of Bala Ged attacks, defending p...         5   \n",
       "1  When you cast Blight Herder, you may put two c...         5   \n",
       "\n",
       "                           type       types                  set releaseDate  \n",
       "0            Creature — Eldrazi  [Creature]  Battle for Zendikar  2015-10-02  \n",
       "1  Creature — Eldrazi Processor  [Creature]  Battle for Zendikar  2015-10-02  "
      ]
     },
     "execution_count": 100,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# drop junk \n",
    "zen.drop(['id', 'layout', 'multiverseid', 'imageName', 'subtypes', \n",
    "          'supertypes', 'variations', 'loyalty', 'number'], \n",
    "         axis=1, inplace=True)\n",
    "\n",
    "zen.head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 101,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "u'When you cast Blight Herder, you may put two cards your opponents own from exile into their owners\\' graveyards. If you do, put three 1/1 colorless Eldrazi Scion creature tokens onto the battlefield. They have \"Sacrifice this creature: Add {1} to your mana pool.\"'"
      ]
     },
     "execution_count": 101,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# grab the text from card 1\n",
    "\n",
    "zen['text'][1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 102,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "u'When you cast Blight Herder, you may put two cards your opponents own from exile into their owners graveyards. If you do, put three 1/1 colorless Eldrazi Scion creature tokens onto the battlefield. They have \"Sacrifice this creature: Add {1} to your mana pool.\"'"
      ]
     },
     "execution_count": 102,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# fix errors\n",
    "\n",
    "zen['text'].replace(\"\\n\" , \" \", inplace=True, regex=True)\n",
    "zen['text'].replace(\"\\'\" , \"\", inplace=True, regex=True)\n",
    "\n",
    "zen['text'][1]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### More cards\n",
    "\n",
    "Now that we know everything words for one set, lets grab a bunch of sets and make one large table of cards. \"Modern\" is a major rules and format change the creators of the game enacted in 2003. It marks a turning point in the design, so, to start, we're only looking at cards after that date.  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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>index</th>\n",
       "      <th>block</th>\n",
       "      <th>border</th>\n",
       "      <th>cards</th>\n",
       "      <th>name</th>\n",
       "      <th>releaseDate</th>\n",
       "      <th>type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>71</td>\n",
       "      <td>NaN</td>\n",
       "      <td>white</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Abyssal Spe...</td>\n",
       "      <td>Eighth Edition</td>\n",
       "      <td>2003-07-28</td>\n",
       "      <td>core</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>72</td>\n",
       "      <td>Mirrodin</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Æther Spell...</td>\n",
       "      <td>Mirrodin</td>\n",
       "      <td>2003-10-02</td>\n",
       "      <td>expansion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>73</td>\n",
       "      <td>Mirrodin</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Æther Snap'...</td>\n",
       "      <td>Darksteel</td>\n",
       "      <td>2004-02-06</td>\n",
       "      <td>expansion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>74</td>\n",
       "      <td>Mirrodin</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Abuna's Cha...</td>\n",
       "      <td>Fifth Dawn</td>\n",
       "      <td>2004-06-04</td>\n",
       "      <td>expansion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>75</td>\n",
       "      <td>Kamigawa</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Akki Avalan...</td>\n",
       "      <td>Champions of Kamigawa</td>\n",
       "      <td>2004-10-01</td>\n",
       "      <td>expansion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>77</td>\n",
       "      <td>Kamigawa</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Akki Blizza...</td>\n",
       "      <td>Betrayers of Kamigawa</td>\n",
       "      <td>2005-02-04</td>\n",
       "      <td>expansion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>78</td>\n",
       "      <td>Kamigawa</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Adamaro, Fi...</td>\n",
       "      <td>Saviors of Kamigawa</td>\n",
       "      <td>2005-06-03</td>\n",
       "      <td>expansion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>79</td>\n",
       "      <td>NaN</td>\n",
       "      <td>white</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Adarkar Was...</td>\n",
       "      <td>Ninth Edition</td>\n",
       "      <td>2005-07-29</td>\n",
       "      <td>core</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>80</td>\n",
       "      <td>Ravnica</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Agrus Kos, ...</td>\n",
       "      <td>Ravnica: City of Guilds</td>\n",
       "      <td>2005-10-07</td>\n",
       "      <td>expansion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>83</td>\n",
       "      <td>Ravnica</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Absolver Th...</td>\n",
       "      <td>Guildpact</td>\n",
       "      <td>2006-02-03</td>\n",
       "      <td>expansion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>85</td>\n",
       "      <td>Ravnica</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Æthermage's...</td>\n",
       "      <td>Dissension</td>\n",
       "      <td>2006-05-05</td>\n",
       "      <td>expansion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>86</td>\n",
       "      <td>Ice Age</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Adarkar Val...</td>\n",
       "      <td>Coldsnap</td>\n",
       "      <td>2006-07-21</td>\n",
       "      <td>expansion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>88</td>\n",
       "      <td>Time Spiral</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Academy Rui...</td>\n",
       "      <td>Time Spiral</td>\n",
       "      <td>2006-10-06</td>\n",
       "      <td>expansion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>89</td>\n",
       "      <td>Time Spiral</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Akroma, Ang...</td>\n",
       "      <td>Time Spiral \"Timeshifted\"</td>\n",
       "      <td>2006-10-06</td>\n",
       "      <td>expansion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>91</td>\n",
       "      <td>Time Spiral</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Aeon Chroni...</td>\n",
       "      <td>Planar Chaos</td>\n",
       "      <td>2007-02-02</td>\n",
       "      <td>expansion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>94</td>\n",
       "      <td>Time Spiral</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Akroma's Me...</td>\n",
       "      <td>Future Sight</td>\n",
       "      <td>2007-05-04</td>\n",
       "      <td>expansion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>95</td>\n",
       "      <td>NaN</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Abundance',...</td>\n",
       "      <td>Tenth Edition</td>\n",
       "      <td>2007-07-13</td>\n",
       "      <td>core</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>98</td>\n",
       "      <td>Lorwyn</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Adder-Staff...</td>\n",
       "      <td>Lorwyn</td>\n",
       "      <td>2007-10-12</td>\n",
       "      <td>expansion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>101</td>\n",
       "      <td>Lorwyn</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Ambassador ...</td>\n",
       "      <td>Morningtide</td>\n",
       "      <td>2008-02-01</td>\n",
       "      <td>expansion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>103</td>\n",
       "      <td>Shadowmoor</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Advice from...</td>\n",
       "      <td>Shadowmoor</td>\n",
       "      <td>2008-05-02</td>\n",
       "      <td>expansion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>105</td>\n",
       "      <td>Shadowmoor</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Aerie Ouphe...</td>\n",
       "      <td>Eventide</td>\n",
       "      <td>2008-07-25</td>\n",
       "      <td>expansion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>109</td>\n",
       "      <td>Alara</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Ad Nauseam'...</td>\n",
       "      <td>Shards of Alara</td>\n",
       "      <td>2008-10-03</td>\n",
       "      <td>expansion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>111</td>\n",
       "      <td>Alara</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Absorb Vis'...</td>\n",
       "      <td>Conflux</td>\n",
       "      <td>2009-02-06</td>\n",
       "      <td>expansion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>113</td>\n",
       "      <td>Alara</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Anathemance...</td>\n",
       "      <td>Alara Reborn</td>\n",
       "      <td>2009-04-30</td>\n",
       "      <td>expansion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>114</td>\n",
       "      <td>NaN</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Acidic Slim...</td>\n",
       "      <td>Magic 2010</td>\n",
       "      <td>2009-07-17</td>\n",
       "      <td>core</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>118</td>\n",
       "      <td>Zendikar</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Adventuring...</td>\n",
       "      <td>Zendikar</td>\n",
       "      <td>2009-10-02</td>\n",
       "      <td>expansion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>121</td>\n",
       "      <td>Zendikar</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Abyssal Per...</td>\n",
       "      <td>Worldwake</td>\n",
       "      <td>2010-02-05</td>\n",
       "      <td>expansion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>123</td>\n",
       "      <td>Zendikar</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Affa Guard ...</td>\n",
       "      <td>Rise of the Eldrazi</td>\n",
       "      <td>2010-04-23</td>\n",
       "      <td>expansion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>126</td>\n",
       "      <td>NaN</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Acidic Slim...</td>\n",
       "      <td>Magic 2011</td>\n",
       "      <td>2010-07-16</td>\n",
       "      <td>core</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>129</td>\n",
       "      <td>Scars of Mirrodin</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Abuna Acoly...</td>\n",
       "      <td>Scars of Mirrodin</td>\n",
       "      <td>2010-10-01</td>\n",
       "      <td>expansion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>132</td>\n",
       "      <td>Scars of Mirrodin</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Accorder Pa...</td>\n",
       "      <td>Mirrodin Besieged</td>\n",
       "      <td>2011-02-04</td>\n",
       "      <td>expansion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>134</td>\n",
       "      <td>Scars of Mirrodin</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Act of Aggr...</td>\n",
       "      <td>New Phyrexia</td>\n",
       "      <td>2011-05-13</td>\n",
       "      <td>expansion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>136</td>\n",
       "      <td>NaN</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Acidic Slim...</td>\n",
       "      <td>Magic 2012</td>\n",
       "      <td>2011-07-15</td>\n",
       "      <td>core</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>139</td>\n",
       "      <td>Innistrad</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Abattoir Gh...</td>\n",
       "      <td>Innistrad</td>\n",
       "      <td>2011-09-30</td>\n",
       "      <td>expansion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>141</td>\n",
       "      <td>Innistrad</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'double-faced', u'name': u'Affli...</td>\n",
       "      <td>Dark Ascension</td>\n",
       "      <td>2012-02-03</td>\n",
       "      <td>expansion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>143</td>\n",
       "      <td>Innistrad</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Abundant Gr...</td>\n",
       "      <td>Avacyn Restored</td>\n",
       "      <td>2012-05-04</td>\n",
       "      <td>expansion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>145</td>\n",
       "      <td>NaN</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Acidic Slim...</td>\n",
       "      <td>Magic 2013</td>\n",
       "      <td>2012-07-13</td>\n",
       "      <td>core</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>148</td>\n",
       "      <td>Return to Ravnica</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Abrupt Deca...</td>\n",
       "      <td>Return to Ravnica</td>\n",
       "      <td>2012-10-05</td>\n",
       "      <td>expansion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>150</td>\n",
       "      <td>Return to Ravnica</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Act of Trea...</td>\n",
       "      <td>Gatecrash</td>\n",
       "      <td>2013-02-01</td>\n",
       "      <td>expansion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>153</td>\n",
       "      <td>Return to Ravnica</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Advent of t...</td>\n",
       "      <td>Dragon's Maze</td>\n",
       "      <td>2013-05-03</td>\n",
       "      <td>expansion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>155</td>\n",
       "      <td>NaN</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Academy Rai...</td>\n",
       "      <td>Magic 2014 Core Set</td>\n",
       "      <td>2013-07-19</td>\n",
       "      <td>core</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>158</td>\n",
       "      <td>Theros</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Abhorrent O...</td>\n",
       "      <td>Theros</td>\n",
       "      <td>2013-09-27</td>\n",
       "      <td>expansion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>160</td>\n",
       "      <td>Theros</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Acolyte's R...</td>\n",
       "      <td>Born of the Gods</td>\n",
       "      <td>2014-02-07</td>\n",
       "      <td>expansion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>162</td>\n",
       "      <td>Theros</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Aegis of th...</td>\n",
       "      <td>Journey into Nyx</td>\n",
       "      <td>2014-05-02</td>\n",
       "      <td>expansion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>166</td>\n",
       "      <td>NaN</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Accursed Sp...</td>\n",
       "      <td>Magic 2015 Core Set</td>\n",
       "      <td>2014-07-18</td>\n",
       "      <td>core</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>170</td>\n",
       "      <td>Khans of Tarkir</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Abzan Battl...</td>\n",
       "      <td>Khans of Tarkir</td>\n",
       "      <td>2014-09-26</td>\n",
       "      <td>expansion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>177</td>\n",
       "      <td>Khans of Tarkir</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Ugin, the S...</td>\n",
       "      <td>Fate Reforged</td>\n",
       "      <td>2015-01-23</td>\n",
       "      <td>expansion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>179</td>\n",
       "      <td>Khans of Tarkir</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Scion of Ug...</td>\n",
       "      <td>Dragons of Tarkir</td>\n",
       "      <td>2015-03-27</td>\n",
       "      <td>expansion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>182</td>\n",
       "      <td>NaN</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Akroan Jail...</td>\n",
       "      <td>Magic Origins</td>\n",
       "      <td>2015-07-17</td>\n",
       "      <td>core</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>185</td>\n",
       "      <td>Battle for Zendikar</td>\n",
       "      <td>black</td>\n",
       "      <td>[{u'layout': u'normal', u'name': u'Bane of Bal...</td>\n",
       "      <td>Battle for Zendikar</td>\n",
       "      <td>2015-10-02</td>\n",
       "      <td>expansion</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    index                block border  \\\n",
       "0      71                  NaN  white   \n",
       "1      72             Mirrodin  black   \n",
       "2      73             Mirrodin  black   \n",
       "3      74             Mirrodin  black   \n",
       "4      75             Kamigawa  black   \n",
       "5      77             Kamigawa  black   \n",
       "6      78             Kamigawa  black   \n",
       "7      79                  NaN  white   \n",
       "8      80              Ravnica  black   \n",
       "9      83              Ravnica  black   \n",
       "10     85              Ravnica  black   \n",
       "11     86              Ice Age  black   \n",
       "12     88          Time Spiral  black   \n",
       "13     89          Time Spiral  black   \n",
       "14     91          Time Spiral  black   \n",
       "15     94          Time Spiral  black   \n",
       "16     95                  NaN  black   \n",
       "17     98               Lorwyn  black   \n",
       "18    101               Lorwyn  black   \n",
       "19    103           Shadowmoor  black   \n",
       "20    105           Shadowmoor  black   \n",
       "21    109                Alara  black   \n",
       "22    111                Alara  black   \n",
       "23    113                Alara  black   \n",
       "24    114                  NaN  black   \n",
       "25    118             Zendikar  black   \n",
       "26    121             Zendikar  black   \n",
       "27    123             Zendikar  black   \n",
       "28    126                  NaN  black   \n",
       "29    129    Scars of Mirrodin  black   \n",
       "30    132    Scars of Mirrodin  black   \n",
       "31    134    Scars of Mirrodin  black   \n",
       "32    136                  NaN  black   \n",
       "33    139            Innistrad  black   \n",
       "34    141            Innistrad  black   \n",
       "35    143            Innistrad  black   \n",
       "36    145                  NaN  black   \n",
       "37    148    Return to Ravnica  black   \n",
       "38    150    Return to Ravnica  black   \n",
       "39    153    Return to Ravnica  black   \n",
       "40    155                  NaN  black   \n",
       "41    158               Theros  black   \n",
       "42    160               Theros  black   \n",
       "43    162               Theros  black   \n",
       "44    166                  NaN  black   \n",
       "45    170      Khans of Tarkir  black   \n",
       "46    177      Khans of Tarkir  black   \n",
       "47    179      Khans of Tarkir  black   \n",
       "48    182                  NaN  black   \n",
       "49    185  Battle for Zendikar  black   \n",
       "\n",
       "                                                cards  \\\n",
       "0   [{u'layout': u'normal', u'name': u'Abyssal Spe...   \n",
       "1   [{u'layout': u'normal', u'name': u'Æther Spell...   \n",
       "2   [{u'layout': u'normal', u'name': u'Æther Snap'...   \n",
       "3   [{u'layout': u'normal', u'name': u'Abuna's Cha...   \n",
       "4   [{u'layout': u'normal', u'name': u'Akki Avalan...   \n",
       "5   [{u'layout': u'normal', u'name': u'Akki Blizza...   \n",
       "6   [{u'layout': u'normal', u'name': u'Adamaro, Fi...   \n",
       "7   [{u'layout': u'normal', u'name': u'Adarkar Was...   \n",
       "8   [{u'layout': u'normal', u'name': u'Agrus Kos, ...   \n",
       "9   [{u'layout': u'normal', u'name': u'Absolver Th...   \n",
       "10  [{u'layout': u'normal', u'name': u'Æthermage's...   \n",
       "11  [{u'layout': u'normal', u'name': u'Adarkar Val...   \n",
       "12  [{u'layout': u'normal', u'name': u'Academy Rui...   \n",
       "13  [{u'layout': u'normal', u'name': u'Akroma, Ang...   \n",
       "14  [{u'layout': u'normal', u'name': u'Aeon Chroni...   \n",
       "15  [{u'layout': u'normal', u'name': u'Akroma's Me...   \n",
       "16  [{u'layout': u'normal', u'name': u'Abundance',...   \n",
       "17  [{u'layout': u'normal', u'name': u'Adder-Staff...   \n",
       "18  [{u'layout': u'normal', u'name': u'Ambassador ...   \n",
       "19  [{u'layout': u'normal', u'name': u'Advice from...   \n",
       "20  [{u'layout': u'normal', u'name': u'Aerie Ouphe...   \n",
       "21  [{u'layout': u'normal', u'name': u'Ad Nauseam'...   \n",
       "22  [{u'layout': u'normal', u'name': u'Absorb Vis'...   \n",
       "23  [{u'layout': u'normal', u'name': u'Anathemance...   \n",
       "24  [{u'layout': u'normal', u'name': u'Acidic Slim...   \n",
       "25  [{u'layout': u'normal', u'name': u'Adventuring...   \n",
       "26  [{u'layout': u'normal', u'name': u'Abyssal Per...   \n",
       "27  [{u'layout': u'normal', u'name': u'Affa Guard ...   \n",
       "28  [{u'layout': u'normal', u'name': u'Acidic Slim...   \n",
       "29  [{u'layout': u'normal', u'name': u'Abuna Acoly...   \n",
       "30  [{u'layout': u'normal', u'name': u'Accorder Pa...   \n",
       "31  [{u'layout': u'normal', u'name': u'Act of Aggr...   \n",
       "32  [{u'layout': u'normal', u'name': u'Acidic Slim...   \n",
       "33  [{u'layout': u'normal', u'name': u'Abattoir Gh...   \n",
       "34  [{u'layout': u'double-faced', u'name': u'Affli...   \n",
       "35  [{u'layout': u'normal', u'name': u'Abundant Gr...   \n",
       "36  [{u'layout': u'normal', u'name': u'Acidic Slim...   \n",
       "37  [{u'layout': u'normal', u'name': u'Abrupt Deca...   \n",
       "38  [{u'layout': u'normal', u'name': u'Act of Trea...   \n",
       "39  [{u'layout': u'normal', u'name': u'Advent of t...   \n",
       "40  [{u'layout': u'normal', u'name': u'Academy Rai...   \n",
       "41  [{u'layout': u'normal', u'name': u'Abhorrent O...   \n",
       "42  [{u'layout': u'normal', u'name': u'Acolyte's R...   \n",
       "43  [{u'layout': u'normal', u'name': u'Aegis of th...   \n",
       "44  [{u'layout': u'normal', u'name': u'Accursed Sp...   \n",
       "45  [{u'layout': u'normal', u'name': u'Abzan Battl...   \n",
       "46  [{u'layout': u'normal', u'name': u'Ugin, the S...   \n",
       "47  [{u'layout': u'normal', u'name': u'Scion of Ug...   \n",
       "48  [{u'layout': u'normal', u'name': u'Akroan Jail...   \n",
       "49  [{u'layout': u'normal', u'name': u'Bane of Bal...   \n",
       "\n",
       "                         name releaseDate       type  \n",
       "0              Eighth Edition  2003-07-28       core  \n",
       "1                    Mirrodin  2003-10-02  expansion  \n",
       "2                   Darksteel  2004-02-06  expansion  \n",
       "3                  Fifth Dawn  2004-06-04  expansion  \n",
       "4       Champions of Kamigawa  2004-10-01  expansion  \n",
       "5       Betrayers of Kamigawa  2005-02-04  expansion  \n",
       "6         Saviors of Kamigawa  2005-06-03  expansion  \n",
       "7               Ninth Edition  2005-07-29       core  \n",
       "8     Ravnica: City of Guilds  2005-10-07  expansion  \n",
       "9                   Guildpact  2006-02-03  expansion  \n",
       "10                 Dissension  2006-05-05  expansion  \n",
       "11                   Coldsnap  2006-07-21  expansion  \n",
       "12                Time Spiral  2006-10-06  expansion  \n",
       "13  Time Spiral \"Timeshifted\"  2006-10-06  expansion  \n",
       "14               Planar Chaos  2007-02-02  expansion  \n",
       "15               Future Sight  2007-05-04  expansion  \n",
       "16              Tenth Edition  2007-07-13       core  \n",
       "17                     Lorwyn  2007-10-12  expansion  \n",
       "18                Morningtide  2008-02-01  expansion  \n",
       "19                 Shadowmoor  2008-05-02  expansion  \n",
       "20                   Eventide  2008-07-25  expansion  \n",
       "21            Shards of Alara  2008-10-03  expansion  \n",
       "22                    Conflux  2009-02-06  expansion  \n",
       "23               Alara Reborn  2009-04-30  expansion  \n",
       "24                 Magic 2010  2009-07-17       core  \n",
       "25                   Zendikar  2009-10-02  expansion  \n",
       "26                  Worldwake  2010-02-05  expansion  \n",
       "27        Rise of the Eldrazi  2010-04-23  expansion  \n",
       "28                 Magic 2011  2010-07-16       core  \n",
       "29          Scars of Mirrodin  2010-10-01  expansion  \n",
       "30          Mirrodin Besieged  2011-02-04  expansion  \n",
       "31               New Phyrexia  2011-05-13  expansion  \n",
       "32                 Magic 2012  2011-07-15       core  \n",
       "33                  Innistrad  2011-09-30  expansion  \n",
       "34             Dark Ascension  2012-02-03  expansion  \n",
       "35            Avacyn Restored  2012-05-04  expansion  \n",
       "36                 Magic 2013  2012-07-13       core  \n",
       "37          Return to Ravnica  2012-10-05  expansion  \n",
       "38                  Gatecrash  2013-02-01  expansion  \n",
       "39              Dragon's Maze  2013-05-03  expansion  \n",
       "40        Magic 2014 Core Set  2013-07-19       core  \n",
       "41                     Theros  2013-09-27  expansion  \n",
       "42           Born of the Gods  2014-02-07  expansion  \n",
       "43           Journey into Nyx  2014-05-02  expansion  \n",
       "44        Magic 2015 Core Set  2014-07-18       core  \n",
       "45            Khans of Tarkir  2014-09-26  expansion  \n",
       "46              Fate Reforged  2015-01-23  expansion  \n",
       "47          Dragons of Tarkir  2015-03-27  expansion  \n",
       "48              Magic Origins  2015-07-17       core  \n",
       "49        Battle for Zendikar  2015-10-02  expansion  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# slice sets for all of modern (arbritrary rules change date in 2003)\n",
    "\n",
    "modern_sets = allsets[ (allsets['releaseDate'] >= '2003-07-28' ) ]\n",
    "modern_sets = modern_sets.loc[modern_sets['type'].isin(['core', 'expansion'])]\n",
    "modern_sets = modern_sets.loc[modern_sets['border'].isin(['white', 'black'])]\n",
    "\n",
    "modern_sets.reset_index(inplace=True)\n",
    "modern_sets"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Reading in set: Eighth Edition\n",
      "Reading in set: Mirrodin\n",
      "Reading in set: Darksteel\n",
      "Reading in set: Fifth Dawn\n",
      "Reading in set: Champions of Kamigawa\n",
      "Reading in set: Betrayers of Kamigawa\n",
      "Reading in set: Saviors of Kamigawa\n",
      "Reading in set: Ninth Edition\n",
      "Reading in set: Ravnica: City of Guilds\n",
      "Reading in set: Guildpact\n",
      "Reading in set: Dissension\n",
      "Reading in set: Coldsnap\n",
      "Reading in set: Time Spiral\n",
      "Reading in set: Time Spiral \"Timeshifted\"\n",
      "Reading in set: Planar Chaos\n",
      "Reading in set: Future Sight\n",
      "Reading in set: Tenth Edition\n",
      "Reading in set: Lorwyn\n",
      "Reading in set: Morningtide\n",
      "Reading in set: Shadowmoor\n",
      "Reading in set: Eventide\n",
      "Reading in set: Shards of Alara\n",
      "Reading in set: Conflux\n",
      "Reading in set: Alara Reborn\n",
      "Reading in set: Magic 2010\n",
      "Reading in set: Zendikar\n",
      "Reading in set: Worldwake\n",
      "Reading in set: Rise of the Eldrazi\n",
      "Reading in set: Magic 2011\n",
      "Reading in set: Scars of Mirrodin\n",
      "Reading in set: Mirrodin Besieged\n",
      "Reading in set: New Phyrexia\n",
      "Reading in set: Magic 2012\n",
      "Reading in set: Innistrad\n",
      "Reading in set: Dark Ascension\n",
      "Reading in set: Avacyn Restored\n",
      "Reading in set: Magic 2013\n",
      "Reading in set: Return to Ravnica\n",
      "Reading in set: Gatecrash\n",
      "Reading in set: Dragon's Maze\n",
      "Reading in set: Magic 2014 Core Set\n",
      "Reading in set: Theros\n",
      "Reading in set: Born of the Gods\n",
      "Reading in set: Journey into Nyx\n",
      "Reading in set: Magic 2015 Core Set\n",
      "Reading in set: Khans of Tarkir\n",
      "Reading in set: Fate Reforged\n",
      "Reading in set: Dragons of Tarkir\n",
      "Reading in set: Magic Origins\n",
      "Reading in set: Battle for Zendikar\n",
      "\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 11502 entries, 0 to 298\n",
      "Columns: 14 entries, artist to releaseDate\n",
      "dtypes: float64(1), object(13)\n",
      "memory usage: 1.3+ MB\n",
      "None\n"
     ]
    }
   ],
   "source": [
    "# groups cards from sets into one data frame \n",
    "\n",
    "cards = None\n",
    "\n",
    "for s in xrange(len(modern_sets)):\n",
    "    print \"Reading in set:\", modern_sets.name[s]\n",
    "    target = pd.read_json(json.dumps(modern_sets.cards[s]))\n",
    "    \n",
    "    # slice to just the good stuff \n",
    "    target = target[['artist', 'cmc', 'colors', 'flavor', 'manaCost', 'name', \n",
    "                    'power', 'rarity', 'text', 'toughness', 'type', 'types']]\n",
    "    \n",
    "    # add set name and date\n",
    "    target['set'] = modern_sets.name[s]\n",
    "    target['releaseDate'] = modern_sets.releaseDate[s]    \n",
    "    \n",
    "    # add to cards df \n",
    "    cards = pd.concat([cards, target])\n",
    "\n",
    "# clean up errors\n",
    "cards['text'].replace(\"\\n\" , \" \", inplace=True, regex=True)\n",
    "cards['text'].replace(\"\\'\" , \"\", inplace=True, regex=True)\n",
    "cards['flavor'].replace(\"\\n\" , \" \", inplace=True, regex=True)\n",
    "\n",
    "print \n",
    "print cards.info(verbose=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This gives us 11502 cards\n",
    "\n",
    "but this is too many cards, included are promotional tokens that we do not want. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 10765 entries, 0 to 248\n",
      "Columns: 14 entries, artist to releaseDate\n",
      "dtypes: float64(1), object(13)\n",
      "memory usage: 1.2+ MB\n"
     ]
    }
   ],
   "source": [
    "# filter out lands and tokens \n",
    "\n",
    "cards = cards.loc[cards['rarity'].isin(['Common', 'Uncommon', 'Rare', \n",
    "                                        'Mythic Rare'])]\n",
    "cards.info(verbose=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This gives 10765 cards.\n",
    "\n",
    "Now the next problem is some cards do not have a color (artifacts) and some cards are multiple colors (gold, hybrid). Lets leave them out for now.  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 7874 entries, 0 to 197\n",
      "Columns: 14 entries, artist to releaseDate\n",
      "dtypes: float64(1), object(13)\n",
      "memory usage: 922.7+ KB\n"
     ]
    }
   ],
   "source": [
    "# only keep cards with a 'color' attribute\n",
    "cards_no_nulls = cards[cards['colors'].notnull()]\n",
    "\n",
    "# only keep cards with text\n",
    "cards_no_nulls = cards_no_nulls[cards_no_nulls['text'].notnull()]\n",
    "\n",
    "# only keep cards with a mana cost\n",
    "cards_no_nulls = cards_no_nulls[cards_no_nulls['colors'].map(len) == 1]\n",
    "cards_no_nulls.info(verbose=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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>artist</th>\n",
       "      <th>cmc</th>\n",
       "      <th>colors</th>\n",
       "      <th>flavor</th>\n",
       "      <th>manaCost</th>\n",
       "      <th>name</th>\n",
       "      <th>power</th>\n",
       "      <th>rarity</th>\n",
       "      <th>text</th>\n",
       "      <th>toughness</th>\n",
       "      <th>type</th>\n",
       "      <th>types</th>\n",
       "      <th>set</th>\n",
       "      <th>releaseDate</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Michael Sutfin</td>\n",
       "      <td>4</td>\n",
       "      <td>[Black]</td>\n",
       "      <td>To gaze under its hood is to invite death.</td>\n",
       "      <td>{2}{B}{B}</td>\n",
       "      <td>Abyssal Specter</td>\n",
       "      <td>2</td>\n",
       "      <td>Uncommon</td>\n",
       "      <td>Flying Whenever Abyssal Specter deals damage t...</td>\n",
       "      <td>3</td>\n",
       "      <td>Creature — Specter</td>\n",
       "      <td>[Creature]</td>\n",
       "      <td>Eighth Edition</td>\n",
       "      <td>2003-07-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Wayne England</td>\n",
       "      <td>5</td>\n",
       "      <td>[Blue]</td>\n",
       "      <td>Pray that it doesn't seek the safety of your l...</td>\n",
       "      <td>{3}{U}{U}</td>\n",
       "      <td>Air Elemental</td>\n",
       "      <td>4</td>\n",
       "      <td>Uncommon</td>\n",
       "      <td>Flying</td>\n",
       "      <td>4</td>\n",
       "      <td>Creature — Elemental</td>\n",
       "      <td>[Creature]</td>\n",
       "      <td>Eighth Edition</td>\n",
       "      <td>2003-07-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Junko Taguchi</td>\n",
       "      <td>4</td>\n",
       "      <td>[Black]</td>\n",
       "      <td>\"Knowledge demands sacrifice.\"</td>\n",
       "      <td>{3}{B}</td>\n",
       "      <td>Ambition's Cost</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Uncommon</td>\n",
       "      <td>You draw three cards and you lose 3 life.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sorcery</td>\n",
       "      <td>[Sorcery]</td>\n",
       "      <td>Eighth Edition</td>\n",
       "      <td>2003-07-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Alex Horley-Orlandelli</td>\n",
       "      <td>4</td>\n",
       "      <td>[Red]</td>\n",
       "      <td>Just try taking this bull by the horns.</td>\n",
       "      <td>{3}{R}</td>\n",
       "      <td>Anaba Shaman</td>\n",
       "      <td>2</td>\n",
       "      <td>Common</td>\n",
       "      <td>{R}, {T}: Anaba Shaman deals 1 damage to targe...</td>\n",
       "      <td>2</td>\n",
       "      <td>Creature — Minotaur Shaman</td>\n",
       "      <td>[Creature]</td>\n",
       "      <td>Eighth Edition</td>\n",
       "      <td>2003-07-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Melissa A. Benson</td>\n",
       "      <td>5</td>\n",
       "      <td>[White]</td>\n",
       "      <td>A song of life soars over fields of blood.</td>\n",
       "      <td>{4}{W}</td>\n",
       "      <td>Angel of Mercy</td>\n",
       "      <td>3</td>\n",
       "      <td>Uncommon</td>\n",
       "      <td>Flying When Angel of Mercy enters the battlefi...</td>\n",
       "      <td>3</td>\n",
       "      <td>Creature — Angel</td>\n",
       "      <td>[Creature]</td>\n",
       "      <td>Eighth Edition</td>\n",
       "      <td>2003-07-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Marc Fishman</td>\n",
       "      <td>2</td>\n",
       "      <td>[White]</td>\n",
       "      <td>If only every message were as perfect as its b...</td>\n",
       "      <td>{1}{W}</td>\n",
       "      <td>Angelic Page</td>\n",
       "      <td>1</td>\n",
       "      <td>Common</td>\n",
       "      <td>Flying {T}: Target attacking or blocking creat...</td>\n",
       "      <td>1</td>\n",
       "      <td>Creature — Angel Spirit</td>\n",
       "      <td>[Creature]</td>\n",
       "      <td>Eighth Edition</td>\n",
       "      <td>2003-07-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Donato Giancola</td>\n",
       "      <td>4</td>\n",
       "      <td>[Blue]</td>\n",
       "      <td>\"Words—so innocent and powerless are they, as ...</td>\n",
       "      <td>{2}{U}{U}</td>\n",
       "      <td>Archivist</td>\n",
       "      <td>1</td>\n",
       "      <td>Rare</td>\n",
       "      <td>{T}: Draw a card.</td>\n",
       "      <td>1</td>\n",
       "      <td>Creature — Human Wizard</td>\n",
       "      <td>[Creature]</td>\n",
       "      <td>Eighth Edition</td>\n",
       "      <td>2003-07-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Paolo Parente</td>\n",
       "      <td>5</td>\n",
       "      <td>[White]</td>\n",
       "      <td>Knights fight for honor and mercenaries fight ...</td>\n",
       "      <td>{4}{W}</td>\n",
       "      <td>Ardent Militia</td>\n",
       "      <td>2</td>\n",
       "      <td>Uncommon</td>\n",
       "      <td>Vigilance</td>\n",
       "      <td>5</td>\n",
       "      <td>Creature — Human Soldier</td>\n",
       "      <td>[Creature]</td>\n",
       "      <td>Eighth Edition</td>\n",
       "      <td>2003-07-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Mark Zug</td>\n",
       "      <td>8</td>\n",
       "      <td>[White]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>{6}{W}{W}</td>\n",
       "      <td>Avatar of Hope</td>\n",
       "      <td>4</td>\n",
       "      <td>Rare</td>\n",
       "      <td>If you have 3 or less life, Avatar of Hope cos...</td>\n",
       "      <td>9</td>\n",
       "      <td>Creature — Avatar</td>\n",
       "      <td>[Creature]</td>\n",
       "      <td>Eighth Edition</td>\n",
       "      <td>2003-07-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Justin Sweet</td>\n",
       "      <td>4</td>\n",
       "      <td>[White]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>{3}{W}</td>\n",
       "      <td>Aven Cloudchaser</td>\n",
       "      <td>2</td>\n",
       "      <td>Common</td>\n",
       "      <td>Flying (This creature cant be blocked except b...</td>\n",
       "      <td>2</td>\n",
       "      <td>Creature — Bird Soldier</td>\n",
       "      <td>[Creature]</td>\n",
       "      <td>Eighth Edition</td>\n",
       "      <td>2003-07-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Christopher Moeller</td>\n",
       "      <td>4</td>\n",
       "      <td>[Blue]</td>\n",
       "      <td>The same spears that catch their food today wi...</td>\n",
       "      <td>{3}{U}</td>\n",
       "      <td>Aven Fisher</td>\n",
       "      <td>2</td>\n",
       "      <td>Common</td>\n",
       "      <td>Flying (This creature cant be blocked except b...</td>\n",
       "      <td>2</td>\n",
       "      <td>Creature — Bird Soldier</td>\n",
       "      <td>[Creature]</td>\n",
       "      <td>Eighth Edition</td>\n",
       "      <td>2003-07-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Greg &amp; Tim Hildebrandt</td>\n",
       "      <td>5</td>\n",
       "      <td>[White]</td>\n",
       "      <td>Just as each added feather steadies the wing, ...</td>\n",
       "      <td>{4}{W}</td>\n",
       "      <td>Aven Flock</td>\n",
       "      <td>2</td>\n",
       "      <td>Common</td>\n",
       "      <td>Flying (This creature cant be blocked except b...</td>\n",
       "      <td>3</td>\n",
       "      <td>Creature — Bird Soldier</td>\n",
       "      <td>[Creature]</td>\n",
       "      <td>Eighth Edition</td>\n",
       "      <td>2003-07-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Adam Rex</td>\n",
       "      <td>5</td>\n",
       "      <td>[Blue]</td>\n",
       "      <td>\"To empty your mind is to fill your grave.\" —L...</td>\n",
       "      <td>{3}{U}{U}</td>\n",
       "      <td>Balance of Power</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rare</td>\n",
       "      <td>If target opponent has more cards in hand than...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sorcery</td>\n",
       "      <td>[Sorcery]</td>\n",
       "      <td>Eighth Edition</td>\n",
       "      <td>2003-07-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Edward P. Beard, Jr.</td>\n",
       "      <td>1</td>\n",
       "      <td>[Green]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>{G}</td>\n",
       "      <td>Birds of Paradise</td>\n",
       "      <td>0</td>\n",
       "      <td>Rare</td>\n",
       "      <td>Flying {T}: Add one mana of any color to your ...</td>\n",
       "      <td>1</td>\n",
       "      <td>Creature — Bird</td>\n",
       "      <td>[Creature]</td>\n",
       "      <td>Eighth Edition</td>\n",
       "      <td>2003-07-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Paolo Parente</td>\n",
       "      <td>3</td>\n",
       "      <td>[Green]</td>\n",
       "      <td>\"There's never been a dwarven smith who could ...</td>\n",
       "      <td>{2}{G}</td>\n",
       "      <td>Blanchwood Armor</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Uncommon</td>\n",
       "      <td>Enchant creature (Target a creature as you cas...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Enchantment — Aura</td>\n",
       "      <td>[Enchantment]</td>\n",
       "      <td>Eighth Edition</td>\n",
       "      <td>2003-07-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Alex Horley-Orlandelli</td>\n",
       "      <td>1</td>\n",
       "      <td>[Red]</td>\n",
       "      <td>Fire never dies alone.</td>\n",
       "      <td>{X}{R}</td>\n",
       "      <td>Blaze</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Uncommon</td>\n",
       "      <td>Blaze deals X damage to target creature or pla...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sorcery</td>\n",
       "      <td>[Sorcery]</td>\n",
       "      <td>Eighth Edition</td>\n",
       "      <td>2003-07-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Christopher Moeller</td>\n",
       "      <td>2</td>\n",
       "      <td>[White]</td>\n",
       "      <td>Even an enemy is a valuable resource.</td>\n",
       "      <td>{1}{W}</td>\n",
       "      <td>Blessed Reversal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rare</td>\n",
       "      <td>You gain 3 life for each creature attacking you.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Instant</td>\n",
       "      <td>[Instant]</td>\n",
       "      <td>Eighth Edition</td>\n",
       "      <td>2003-07-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Todd Lockwood</td>\n",
       "      <td>5</td>\n",
       "      <td>[White]</td>\n",
       "      <td>\"Their eyes will shrivel and blacken before fa...</td>\n",
       "      <td>{3}{W}{W}</td>\n",
       "      <td>Blinding Angel</td>\n",
       "      <td>2</td>\n",
       "      <td>Rare</td>\n",
       "      <td>Flying (This creature cant be blocked except b...</td>\n",
       "      <td>4</td>\n",
       "      <td>Creature — Angel</td>\n",
       "      <td>[Creature]</td>\n",
       "      <td>Eighth Edition</td>\n",
       "      <td>2003-07-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Franz Vohwinkel</td>\n",
       "      <td>3</td>\n",
       "      <td>[Red]</td>\n",
       "      <td>Heavy light flooded across the landscape, cloa...</td>\n",
       "      <td>{2}{R}</td>\n",
       "      <td>Blood Moon</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rare</td>\n",
       "      <td>Nonbasic lands are Mountains.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Enchantment</td>\n",
       "      <td>[Enchantment]</td>\n",
       "      <td>Eighth Edition</td>\n",
       "      <td>2003-07-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Daren Bader</td>\n",
       "      <td>6</td>\n",
       "      <td>[Red]</td>\n",
       "      <td>After their first encounter, the goblins named...</td>\n",
       "      <td>{5}{R}</td>\n",
       "      <td>Bloodshot Cyclops</td>\n",
       "      <td>4</td>\n",
       "      <td>Rare</td>\n",
       "      <td>{T}, Sacrifice a creature: Bloodshot Cyclops d...</td>\n",
       "      <td>4</td>\n",
       "      <td>Creature — Cyclops Giant</td>\n",
       "      <td>[Creature]</td>\n",
       "      <td>Eighth Edition</td>\n",
       "      <td>2003-07-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Carl Critchlow</td>\n",
       "      <td>2</td>\n",
       "      <td>[Black]</td>\n",
       "      <td>Think of it as a butcher knife with wings.</td>\n",
       "      <td>{1}{B}</td>\n",
       "      <td>Bog Imp</td>\n",
       "      <td>1</td>\n",
       "      <td>Common</td>\n",
       "      <td>Flying (This creature cant be blocked except b...</td>\n",
       "      <td>1</td>\n",
       "      <td>Creature — Imp</td>\n",
       "      <td>[Creature]</td>\n",
       "      <td>Eighth Edition</td>\n",
       "      <td>2003-07-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Dave Dorman</td>\n",
       "      <td>4</td>\n",
       "      <td>[Black]</td>\n",
       "      <td>The bodies of its victims are the only tracks ...</td>\n",
       "      <td>{3}{B}</td>\n",
       "      <td>Bog Wraith</td>\n",
       "      <td>3</td>\n",
       "      <td>Uncommon</td>\n",
       "      <td>Swampwalk (This creature cant be blocked as lo...</td>\n",
       "      <td>3</td>\n",
       "      <td>Creature — Wraith</td>\n",
       "      <td>[Creature]</td>\n",
       "      <td>Eighth Edition</td>\n",
       "      <td>2003-07-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Jason Alexander Behnke</td>\n",
       "      <td>4</td>\n",
       "      <td>[Red]</td>\n",
       "      <td>\"When every reef is bared and every wave is du...</td>\n",
       "      <td>{3}{R}</td>\n",
       "      <td>Boil</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Uncommon</td>\n",
       "      <td>Destroy all Islands.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Instant</td>\n",
       "      <td>[Instant]</td>\n",
       "      <td>Eighth Edition</td>\n",
       "      <td>2003-07-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Alan Rabinowitz</td>\n",
       "      <td>2</td>\n",
       "      <td>[Blue]</td>\n",
       "      <td>\"Returne from whence ye came. . . .\" —Edmund S...</td>\n",
       "      <td>{U}{U}</td>\n",
       "      <td>Boomerang</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Common</td>\n",
       "      <td>Return target permanent to its owners hand.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Instant</td>\n",
       "      <td>[Instant]</td>\n",
       "      <td>Eighth Edition</td>\n",
       "      <td>2003-07-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Andrew Robinson</td>\n",
       "      <td>5</td>\n",
       "      <td>[Blue]</td>\n",
       "      <td>In Mercadia City, loyalties extend only as far...</td>\n",
       "      <td>{3}{U}{U}</td>\n",
       "      <td>Bribery</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rare</td>\n",
       "      <td>Search target opponents library for a creature...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sorcery</td>\n",
       "      <td>[Sorcery]</td>\n",
       "      <td>Eighth Edition</td>\n",
       "      <td>2003-07-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Paolo Parente</td>\n",
       "      <td>4</td>\n",
       "      <td>[Green]</td>\n",
       "      <td>From a whisper to a roar, the call is heard by...</td>\n",
       "      <td>{2}{G}{G}</td>\n",
       "      <td>Call of the Wild</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rare</td>\n",
       "      <td>{2}{G}{G}: Reveal the top card of your library...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Enchantment</td>\n",
       "      <td>[Enchantment]</td>\n",
       "      <td>Eighth Edition</td>\n",
       "      <td>2003-07-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Christopher Rush</td>\n",
       "      <td>2</td>\n",
       "      <td>[Green]</td>\n",
       "      <td>It keeps the upper reaches of the forest free ...</td>\n",
       "      <td>{1}{G}</td>\n",
       "      <td>Canopy Spider</td>\n",
       "      <td>1</td>\n",
       "      <td>Common</td>\n",
       "      <td>Reach (This creature can block creatures with ...</td>\n",
       "      <td>3</td>\n",
       "      <td>Creature — Spider</td>\n",
       "      <td>[Creature]</td>\n",
       "      <td>Eighth Edition</td>\n",
       "      <td>2003-07-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Gary Leach</td>\n",
       "      <td>2</td>\n",
       "      <td>[Red]</td>\n",
       "      <td>In the warrior kingdom of Keld, the cats used ...</td>\n",
       "      <td>{1}{R}</td>\n",
       "      <td>Canyon Wildcat</td>\n",
       "      <td>2</td>\n",
       "      <td>Common</td>\n",
       "      <td>Mountainwalk (This creature cant be blocked as...</td>\n",
       "      <td>1</td>\n",
       "      <td>Creature — Cat</td>\n",
       "      <td>[Creature]</td>\n",
       "      <td>Eighth Edition</td>\n",
       "      <td>2003-07-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Tony Szczudlo</td>\n",
       "      <td>3</td>\n",
       "      <td>[Black]</td>\n",
       "      <td>A wall built from the bodies of the enemy will...</td>\n",
       "      <td>{1}{B}{B}</td>\n",
       "      <td>Carrion Wall</td>\n",
       "      <td>3</td>\n",
       "      <td>Uncommon</td>\n",
       "      <td>Defender (This creature cant attack.) {1}{B}: ...</td>\n",
       "      <td>2</td>\n",
       "      <td>Creature — Wall</td>\n",
       "      <td>[Creature]</td>\n",
       "      <td>Eighth Edition</td>\n",
       "      <td>2003-07-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Berry</td>\n",
       "      <td>3</td>\n",
       "      <td>[Blue]</td>\n",
       "      <td>Though those who study are as many as the hair...</td>\n",
       "      <td>{2}{U}</td>\n",
       "      <td>Catalog</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Common</td>\n",
       "      <td>Draw two cards, then discard a card.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Instant</td>\n",
       "      <td>[Instant]</td>\n",
       "      <td>Eighth Edition</td>\n",
       "      <td>2003-07-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7844</th>\n",
       "      <td>Yeong-Hao Han</td>\n",
       "      <td>4</td>\n",
       "      <td>[Red]</td>\n",
       "      <td>Like a living organism, Zendikar rids itself o...</td>\n",
       "      <td>{3}{R}</td>\n",
       "      <td>Volcanic Upheaval</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Common</td>\n",
       "      <td>Destroy target land.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Instant</td>\n",
       "      <td>[Instant]</td>\n",
       "      <td>Battle for Zendikar</td>\n",
       "      <td>2015-10-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7845</th>\n",
       "      <td>Chris Rallis</td>\n",
       "      <td>4</td>\n",
       "      <td>[Red]</td>\n",
       "      <td>\"A hedron holds magic for a thousand years—or ...</td>\n",
       "      <td>{3}{R}</td>\n",
       "      <td>Zada, Hedron Grinder</td>\n",
       "      <td>3</td>\n",
       "      <td>Rare</td>\n",
       "      <td>Whenever you cast an instant or sorcery spell ...</td>\n",
       "      <td>3</td>\n",
       "      <td>Legendary Creature — Goblin Ally</td>\n",
       "      <td>[Creature]</td>\n",
       "      <td>Battle for Zendikar</td>\n",
       "      <td>2015-10-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7846</th>\n",
       "      <td>Anthony Palumbo</td>\n",
       "      <td>2</td>\n",
       "      <td>[Green]</td>\n",
       "      <td>\"They come because I call. They stay because I...</td>\n",
       "      <td>{1}{G}</td>\n",
       "      <td>Beastcaller Savant</td>\n",
       "      <td>1</td>\n",
       "      <td>Rare</td>\n",
       "      <td>Haste {T}: Add one mana of any color to your m...</td>\n",
       "      <td>1</td>\n",
       "      <td>Creature — Elf Shaman Ally</td>\n",
       "      <td>[Creature]</td>\n",
       "      <td>Battle for Zendikar</td>\n",
       "      <td>2015-10-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7847</th>\n",
       "      <td>Dan Scott</td>\n",
       "      <td>2</td>\n",
       "      <td>[Green]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>{1}{G}</td>\n",
       "      <td>Earthen Arms</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Common</td>\n",
       "      <td>Put two +1/+1 counters on target permanent. Aw...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sorcery</td>\n",
       "      <td>[Sorcery]</td>\n",
       "      <td>Battle for Zendikar</td>\n",
       "      <td>2015-10-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7848</th>\n",
       "      <td>Lake Hurwitz</td>\n",
       "      <td>4</td>\n",
       "      <td>[Green]</td>\n",
       "      <td>\"I always thought the great insects of Tazeem ...</td>\n",
       "      <td>{3}{G}</td>\n",
       "      <td>Giant Mantis</td>\n",
       "      <td>2</td>\n",
       "      <td>Common</td>\n",
       "      <td>Reach (This creature can block creatures with ...</td>\n",
       "      <td>4</td>\n",
       "      <td>Creature — Insect</td>\n",
       "      <td>[Creature]</td>\n",
       "      <td>Battle for Zendikar</td>\n",
       "      <td>2015-10-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7849</th>\n",
       "      <td>Eric Deschamps</td>\n",
       "      <td>6</td>\n",
       "      <td>[Green]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>{4}{G}{G}</td>\n",
       "      <td>Greenwarden of Murasa</td>\n",
       "      <td>5</td>\n",
       "      <td>Mythic Rare</td>\n",
       "      <td>When Greenwarden of Murasa enters the battlefi...</td>\n",
       "      <td>4</td>\n",
       "      <td>Creature — Elemental</td>\n",
       "      <td>[Creature]</td>\n",
       "      <td>Battle for Zendikar</td>\n",
       "      <td>2015-10-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7850</th>\n",
       "      <td>Daniel Ljunggren</td>\n",
       "      <td>4</td>\n",
       "      <td>[Green]</td>\n",
       "      <td>\"Zendikar has given us the weapons to wage war...</td>\n",
       "      <td>{3}{G}</td>\n",
       "      <td>Infuse with the Elements</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Uncommon</td>\n",
       "      <td>Converge — Put X +1/+1 counters on target crea...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Instant</td>\n",
       "      <td>[Instant]</td>\n",
       "      <td>Battle for Zendikar</td>\n",
       "      <td>2015-10-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7851</th>\n",
       "      <td>Daarken</td>\n",
       "      <td>1</td>\n",
       "      <td>[Green]</td>\n",
       "      <td>On Murasa, even the trees grow trees.</td>\n",
       "      <td>{G}</td>\n",
       "      <td>Jaddi Offshoot</td>\n",
       "      <td>0</td>\n",
       "      <td>Uncommon</td>\n",
       "      <td>Defender Landfall — Whenever a land enters the...</td>\n",
       "      <td>3</td>\n",
       "      <td>Creature — Plant</td>\n",
       "      <td>[Creature]</td>\n",
       "      <td>Battle for Zendikar</td>\n",
       "      <td>2015-10-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7852</th>\n",
       "      <td>Willian Murai</td>\n",
       "      <td>3</td>\n",
       "      <td>[Green]</td>\n",
       "      <td>\"The land is not dead, merely sick. I will nur...</td>\n",
       "      <td>{2}{G}</td>\n",
       "      <td>Lifespring Druid</td>\n",
       "      <td>2</td>\n",
       "      <td>Common</td>\n",
       "      <td>{T}: Add one mana of any color to your mana pool.</td>\n",
       "      <td>1</td>\n",
       "      <td>Creature — Elf Druid</td>\n",
       "      <td>[Creature]</td>\n",
       "      <td>Battle for Zendikar</td>\n",
       "      <td>2015-10-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7853</th>\n",
       "      <td>Eric Deschamps</td>\n",
       "      <td>4</td>\n",
       "      <td>[Green]</td>\n",
       "      <td>\"If you're not prepared to fight, you'd best b...</td>\n",
       "      <td>{3}{G}</td>\n",
       "      <td>Murasa Ranger</td>\n",
       "      <td>3</td>\n",
       "      <td>Uncommon</td>\n",
       "      <td>Landfall — Whenever a land enters the battlefi...</td>\n",
       "      <td>3</td>\n",
       "      <td>Creature — Human Warrior</td>\n",
       "      <td>[Creature]</td>\n",
       "      <td>Battle for Zendikar</td>\n",
       "      <td>2015-10-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7854</th>\n",
       "      <td>Wesley Burt</td>\n",
       "      <td>3</td>\n",
       "      <td>[Green]</td>\n",
       "      <td>\"Zendikar will not surrender, and neither can ...</td>\n",
       "      <td>{2}{G}</td>\n",
       "      <td>Natural Connection</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Common</td>\n",
       "      <td>Search your library for a basic land card, put...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Instant</td>\n",
       "      <td>[Instant]</td>\n",
       "      <td>Battle for Zendikar</td>\n",
       "      <td>2015-10-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7855</th>\n",
       "      <td>Lius Lasahido</td>\n",
       "      <td>6</td>\n",
       "      <td>[Green]</td>\n",
       "      <td>Her connection to the plane restored, Nissa fe...</td>\n",
       "      <td>{5}{G}</td>\n",
       "      <td>Nissa's Renewal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rare</td>\n",
       "      <td>Search your library for up to three basic land...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sorcery</td>\n",
       "      <td>[Sorcery]</td>\n",
       "      <td>Battle for Zendikar</td>\n",
       "      <td>2015-10-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7856</th>\n",
       "      <td>Chris Rahn</td>\n",
       "      <td>6</td>\n",
       "      <td>[Green]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>{4}{G}{G}</td>\n",
       "      <td>Oran-Rief Hydra</td>\n",
       "      <td>5</td>\n",
       "      <td>Rare</td>\n",
       "      <td>Trample Landfall — Whenever a land enters the ...</td>\n",
       "      <td>5</td>\n",
       "      <td>Creature — Hydra</td>\n",
       "      <td>[Creature]</td>\n",
       "      <td>Battle for Zendikar</td>\n",
       "      <td>2015-10-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7857</th>\n",
       "      <td>Anastasia Ovchinnikova</td>\n",
       "      <td>2</td>\n",
       "      <td>[Green]</td>\n",
       "      <td>\"The world was not hostile to us—we were benea...</td>\n",
       "      <td>{1}{G}</td>\n",
       "      <td>Oran-Rief Invoker</td>\n",
       "      <td>2</td>\n",
       "      <td>Common</td>\n",
       "      <td>{8}: Oran-Rief Invoker gets +5/+5 and gains tr...</td>\n",
       "      <td>2</td>\n",
       "      <td>Creature — Human Shaman</td>\n",
       "      <td>[Creature]</td>\n",
       "      <td>Battle for Zendikar</td>\n",
       "      <td>2015-10-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7858</th>\n",
       "      <td>Jama Jurabaev</td>\n",
       "      <td>7</td>\n",
       "      <td>[Green]</td>\n",
       "      <td>\"It might fight the Eldrazi, but don't mistake...</td>\n",
       "      <td>{4}{G}{G}{G}</td>\n",
       "      <td>Plated Crusher</td>\n",
       "      <td>7</td>\n",
       "      <td>Uncommon</td>\n",
       "      <td>Trample, hexproof</td>\n",
       "      <td>6</td>\n",
       "      <td>Creature — Beast</td>\n",
       "      <td>[Creature]</td>\n",
       "      <td>Battle for Zendikar</td>\n",
       "      <td>2015-10-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7859</th>\n",
       "      <td>Aaron Miller</td>\n",
       "      <td>2</td>\n",
       "      <td>[Green]</td>\n",
       "      <td>The elf's blade carved deep into the Eldrazi d...</td>\n",
       "      <td>{1}{G}</td>\n",
       "      <td>Plummet</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Common</td>\n",
       "      <td>Destroy target creature with flying.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Instant</td>\n",
       "      <td>[Instant]</td>\n",
       "      <td>Battle for Zendikar</td>\n",
       "      <td>2015-10-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7860</th>\n",
       "      <td>Bastien L. Deharme</td>\n",
       "      <td>4</td>\n",
       "      <td>[Green]</td>\n",
       "      <td>\"This world tires of its long occupation.\"—Nis...</td>\n",
       "      <td>{2}{G}{G}</td>\n",
       "      <td>Reclaiming Vines</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Common</td>\n",
       "      <td>Destroy target artifact, enchantment, or land.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sorcery</td>\n",
       "      <td>[Sorcery]</td>\n",
       "      <td>Battle for Zendikar</td>\n",
       "      <td>2015-10-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7861</th>\n",
       "      <td>Kieran Yanner</td>\n",
       "      <td>3</td>\n",
       "      <td>[Green]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>{2}{G}</td>\n",
       "      <td>Retreat to Kazandu</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Uncommon</td>\n",
       "      <td>Landfall — Whenever a land enters the battlefi...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Enchantment</td>\n",
       "      <td>[Enchantment]</td>\n",
       "      <td>Battle for Zendikar</td>\n",
       "      <td>2015-10-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7862</th>\n",
       "      <td>Yeong-Hao Han</td>\n",
       "      <td>2</td>\n",
       "      <td>[Green]</td>\n",
       "      <td>\"If I die, feed me to a shambler. At least tha...</td>\n",
       "      <td>{1}{G}</td>\n",
       "      <td>Rot Shambler</td>\n",
       "      <td>1</td>\n",
       "      <td>Uncommon</td>\n",
       "      <td>Whenever another creature you control dies, pu...</td>\n",
       "      <td>1</td>\n",
       "      <td>Creature — Fungus</td>\n",
       "      <td>[Creature]</td>\n",
       "      <td>Battle for Zendikar</td>\n",
       "      <td>2015-10-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7863</th>\n",
       "      <td>Daniel Ljunggren</td>\n",
       "      <td>1</td>\n",
       "      <td>[Green]</td>\n",
       "      <td>Eldrazi are not the leopard's preferred prey, ...</td>\n",
       "      <td>{G}</td>\n",
       "      <td>Scythe Leopard</td>\n",
       "      <td>1</td>\n",
       "      <td>Uncommon</td>\n",
       "      <td>Landfall — Whenever a land enters the battlefi...</td>\n",
       "      <td>1</td>\n",
       "      <td>Creature — Cat</td>\n",
       "      <td>[Creature]</td>\n",
       "      <td>Battle for Zendikar</td>\n",
       "      <td>2015-10-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7864</th>\n",
       "      <td>Anna Steinbauer</td>\n",
       "      <td>2</td>\n",
       "      <td>[Green]</td>\n",
       "      <td>\"In my downtime I used to paint the vistas. No...</td>\n",
       "      <td>{1}{G}</td>\n",
       "      <td>Seek the Wilds</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Common</td>\n",
       "      <td>Look at the top four cards of your library. Yo...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sorcery</td>\n",
       "      <td>[Sorcery]</td>\n",
       "      <td>Battle for Zendikar</td>\n",
       "      <td>2015-10-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7865</th>\n",
       "      <td>Kev Walker</td>\n",
       "      <td>2</td>\n",
       "      <td>[Green]</td>\n",
       "      <td>All of Zendikar's beings sense the upheaval th...</td>\n",
       "      <td>{1}{G}</td>\n",
       "      <td>Snapping Gnarlid</td>\n",
       "      <td>2</td>\n",
       "      <td>Common</td>\n",
       "      <td>Landfall — Whenever a land enters the battlefi...</td>\n",
       "      <td>2</td>\n",
       "      <td>Creature — Beast</td>\n",
       "      <td>[Creature]</td>\n",
       "      <td>Battle for Zendikar</td>\n",
       "      <td>2015-10-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7866</th>\n",
       "      <td>Magali Villeneuve</td>\n",
       "      <td>2</td>\n",
       "      <td>[Green]</td>\n",
       "      <td>\"Nissa is not the only one with a deep connect...</td>\n",
       "      <td>{1}{G}</td>\n",
       "      <td>Swell of Growth</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Common</td>\n",
       "      <td>Target creature gets +2/+2 until end of turn. ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Instant</td>\n",
       "      <td>[Instant]</td>\n",
       "      <td>Battle for Zendikar</td>\n",
       "      <td>2015-10-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7867</th>\n",
       "      <td>Daniel Ljunggren</td>\n",
       "      <td>2</td>\n",
       "      <td>[Green]</td>\n",
       "      <td>\"As long as there is a single shred of life, t...</td>\n",
       "      <td>{1}{G}</td>\n",
       "      <td>Sylvan Scrying</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Uncommon</td>\n",
       "      <td>Search your library for a land card, reveal it...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Sorcery</td>\n",
       "      <td>[Sorcery]</td>\n",
       "      <td>Battle for Zendikar</td>\n",
       "      <td>2015-10-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7868</th>\n",
       "      <td>Greg Opalinski</td>\n",
       "      <td>6</td>\n",
       "      <td>[Green]</td>\n",
       "      <td>\"My mount needs neither reins nor bridle. We b...</td>\n",
       "      <td>{5}{G}</td>\n",
       "      <td>Tajuru Beastmaster</td>\n",
       "      <td>5</td>\n",
       "      <td>Common</td>\n",
       "      <td>Rally — Whenever Tajuru Beastmaster or another...</td>\n",
       "      <td>5</td>\n",
       "      <td>Creature — Elf Warrior Ally</td>\n",
       "      <td>[Creature]</td>\n",
       "      <td>Battle for Zendikar</td>\n",
       "      <td>2015-10-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7869</th>\n",
       "      <td>Wesley Burt</td>\n",
       "      <td>3</td>\n",
       "      <td>[Green]</td>\n",
       "      <td>\"In its time of hardship, all of Zendikar crie...</td>\n",
       "      <td>{2}{G}</td>\n",
       "      <td>Tajuru Stalwart</td>\n",
       "      <td>0</td>\n",
       "      <td>Common</td>\n",
       "      <td>Converge — Tajuru Stalwart enters the battlefi...</td>\n",
       "      <td>1</td>\n",
       "      <td>Creature — Elf Scout Ally</td>\n",
       "      <td>[Creature]</td>\n",
       "      <td>Battle for Zendikar</td>\n",
       "      <td>2015-10-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7870</th>\n",
       "      <td>Anastasia Ovchinnikova</td>\n",
       "      <td>5</td>\n",
       "      <td>[Green]</td>\n",
       "      <td>Her rallying cry reaches far beyond the Tajuru...</td>\n",
       "      <td>{3}{G}{G}</td>\n",
       "      <td>Tajuru Warcaller</td>\n",
       "      <td>2</td>\n",
       "      <td>Uncommon</td>\n",
       "      <td>Rally — Whenever Tajuru Warcaller or another A...</td>\n",
       "      <td>1</td>\n",
       "      <td>Creature — Elf Warrior Ally</td>\n",
       "      <td>[Creature]</td>\n",
       "      <td>Battle for Zendikar</td>\n",
       "      <td>2015-10-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7871</th>\n",
       "      <td>Matt Stewart</td>\n",
       "      <td>5</td>\n",
       "      <td>[Green]</td>\n",
       "      <td>It knows nothing of Eldrazi or Planeswalkers, ...</td>\n",
       "      <td>{4}{G}</td>\n",
       "      <td>Territorial Baloth</td>\n",
       "      <td>4</td>\n",
       "      <td>Common</td>\n",
       "      <td>Landfall — Whenever a land enters the battlefi...</td>\n",
       "      <td>4</td>\n",
       "      <td>Creature — Beast</td>\n",
       "      <td>[Creature]</td>\n",
       "      <td>Battle for Zendikar</td>\n",
       "      <td>2015-10-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7872</th>\n",
       "      <td>Tyler Jacobson</td>\n",
       "      <td>3</td>\n",
       "      <td>[Green]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>{1}{G}{G}</td>\n",
       "      <td>Undergrowth Champion</td>\n",
       "      <td>2</td>\n",
       "      <td>Mythic Rare</td>\n",
       "      <td>If damage would be dealt to Undergrowth Champi...</td>\n",
       "      <td>2</td>\n",
       "      <td>Creature — Elemental</td>\n",
       "      <td>[Creature]</td>\n",
       "      <td>Battle for Zendikar</td>\n",
       "      <td>2015-10-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7873</th>\n",
       "      <td>Vincent Proce</td>\n",
       "      <td>4</td>\n",
       "      <td>[Green]</td>\n",
       "      <td>\"The elements understand better than anyone th...</td>\n",
       "      <td>{3}{G}</td>\n",
       "      <td>Woodland Wanderer</td>\n",
       "      <td>2</td>\n",
       "      <td>Rare</td>\n",
       "      <td>Vigilance, trample Converge — Woodland Wandere...</td>\n",
       "      <td>2</td>\n",
       "      <td>Creature — Elemental</td>\n",
       "      <td>[Creature]</td>\n",
       "      <td>Battle for Zendikar</td>\n",
       "      <td>2015-10-02</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7874 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                      artist  cmc   colors  \\\n",
       "0             Michael Sutfin    4  [Black]   \n",
       "1              Wayne England    5   [Blue]   \n",
       "2              Junko Taguchi    4  [Black]   \n",
       "3     Alex Horley-Orlandelli    4    [Red]   \n",
       "4          Melissa A. Benson    5  [White]   \n",
       "5               Marc Fishman    2  [White]   \n",
       "6            Donato Giancola    4   [Blue]   \n",
       "7              Paolo Parente    5  [White]   \n",
       "8                   Mark Zug    8  [White]   \n",
       "9               Justin Sweet    4  [White]   \n",
       "10       Christopher Moeller    4   [Blue]   \n",
       "11    Greg & Tim Hildebrandt    5  [White]   \n",
       "12                  Adam Rex    5   [Blue]   \n",
       "13      Edward P. Beard, Jr.    1  [Green]   \n",
       "14             Paolo Parente    3  [Green]   \n",
       "15    Alex Horley-Orlandelli    1    [Red]   \n",
       "16       Christopher Moeller    2  [White]   \n",
       "17             Todd Lockwood    5  [White]   \n",
       "18           Franz Vohwinkel    3    [Red]   \n",
       "19               Daren Bader    6    [Red]   \n",
       "20            Carl Critchlow    2  [Black]   \n",
       "21               Dave Dorman    4  [Black]   \n",
       "22    Jason Alexander Behnke    4    [Red]   \n",
       "23           Alan Rabinowitz    2   [Blue]   \n",
       "24           Andrew Robinson    5   [Blue]   \n",
       "25             Paolo Parente    4  [Green]   \n",
       "26          Christopher Rush    2  [Green]   \n",
       "27                Gary Leach    2    [Red]   \n",
       "28             Tony Szczudlo    3  [Black]   \n",
       "29                     Berry    3   [Blue]   \n",
       "...                      ...  ...      ...   \n",
       "7844           Yeong-Hao Han    4    [Red]   \n",
       "7845            Chris Rallis    4    [Red]   \n",
       "7846         Anthony Palumbo    2  [Green]   \n",
       "7847               Dan Scott    2  [Green]   \n",
       "7848            Lake Hurwitz    4  [Green]   \n",
       "7849          Eric Deschamps    6  [Green]   \n",
       "7850        Daniel Ljunggren    4  [Green]   \n",
       "7851                 Daarken    1  [Green]   \n",
       "7852           Willian Murai    3  [Green]   \n",
       "7853          Eric Deschamps    4  [Green]   \n",
       "7854             Wesley Burt    3  [Green]   \n",
       "7855           Lius Lasahido    6  [Green]   \n",
       "7856              Chris Rahn    6  [Green]   \n",
       "7857  Anastasia Ovchinnikova    2  [Green]   \n",
       "7858           Jama Jurabaev    7  [Green]   \n",
       "7859            Aaron Miller    2  [Green]   \n",
       "7860      Bastien L. Deharme    4  [Green]   \n",
       "7861           Kieran Yanner    3  [Green]   \n",
       "7862           Yeong-Hao Han    2  [Green]   \n",
       "7863        Daniel Ljunggren    1  [Green]   \n",
       "7864         Anna Steinbauer    2  [Green]   \n",
       "7865              Kev Walker    2  [Green]   \n",
       "7866       Magali Villeneuve    2  [Green]   \n",
       "7867        Daniel Ljunggren    2  [Green]   \n",
       "7868          Greg Opalinski    6  [Green]   \n",
       "7869             Wesley Burt    3  [Green]   \n",
       "7870  Anastasia Ovchinnikova    5  [Green]   \n",
       "7871            Matt Stewart    5  [Green]   \n",
       "7872          Tyler Jacobson    3  [Green]   \n",
       "7873           Vincent Proce    4  [Green]   \n",
       "\n",
       "                                                 flavor      manaCost  \\\n",
       "0            To gaze under its hood is to invite death.     {2}{B}{B}   \n",
       "1     Pray that it doesn't seek the safety of your l...     {3}{U}{U}   \n",
       "2                        \"Knowledge demands sacrifice.\"        {3}{B}   \n",
       "3               Just try taking this bull by the horns.        {3}{R}   \n",
       "4            A song of life soars over fields of blood.        {4}{W}   \n",
       "5     If only every message were as perfect as its b...        {1}{W}   \n",
       "6     \"Words—so innocent and powerless are they, as ...     {2}{U}{U}   \n",
       "7     Knights fight for honor and mercenaries fight ...        {4}{W}   \n",
       "8                                                   NaN     {6}{W}{W}   \n",
       "9                                                   NaN        {3}{W}   \n",
       "10    The same spears that catch their food today wi...        {3}{U}   \n",
       "11    Just as each added feather steadies the wing, ...        {4}{W}   \n",
       "12    \"To empty your mind is to fill your grave.\" —L...     {3}{U}{U}   \n",
       "13                                                  NaN           {G}   \n",
       "14    \"There's never been a dwarven smith who could ...        {2}{G}   \n",
       "15                               Fire never dies alone.        {X}{R}   \n",
       "16                Even an enemy is a valuable resource.        {1}{W}   \n",
       "17    \"Their eyes will shrivel and blacken before fa...     {3}{W}{W}   \n",
       "18    Heavy light flooded across the landscape, cloa...        {2}{R}   \n",
       "19    After their first encounter, the goblins named...        {5}{R}   \n",
       "20           Think of it as a butcher knife with wings.        {1}{B}   \n",
       "21    The bodies of its victims are the only tracks ...        {3}{B}   \n",
       "22    \"When every reef is bared and every wave is du...        {3}{R}   \n",
       "23    \"Returne from whence ye came. . . .\" —Edmund S...        {U}{U}   \n",
       "24    In Mercadia City, loyalties extend only as far...     {3}{U}{U}   \n",
       "25    From a whisper to a roar, the call is heard by...     {2}{G}{G}   \n",
       "26    It keeps the upper reaches of the forest free ...        {1}{G}   \n",
       "27    In the warrior kingdom of Keld, the cats used ...        {1}{R}   \n",
       "28    A wall built from the bodies of the enemy will...     {1}{B}{B}   \n",
       "29    Though those who study are as many as the hair...        {2}{U}   \n",
       "...                                                 ...           ...   \n",
       "7844  Like a living organism, Zendikar rids itself o...        {3}{R}   \n",
       "7845  \"A hedron holds magic for a thousand years—or ...        {3}{R}   \n",
       "7846  \"They come because I call. They stay because I...        {1}{G}   \n",
       "7847                                                NaN        {1}{G}   \n",
       "7848  \"I always thought the great insects of Tazeem ...        {3}{G}   \n",
       "7849                                                NaN     {4}{G}{G}   \n",
       "7850  \"Zendikar has given us the weapons to wage war...        {3}{G}   \n",
       "7851              On Murasa, even the trees grow trees.           {G}   \n",
       "7852  \"The land is not dead, merely sick. I will nur...        {2}{G}   \n",
       "7853  \"If you're not prepared to fight, you'd best b...        {3}{G}   \n",
       "7854  \"Zendikar will not surrender, and neither can ...        {2}{G}   \n",
       "7855  Her connection to the plane restored, Nissa fe...        {5}{G}   \n",
       "7856                                                NaN     {4}{G}{G}   \n",
       "7857  \"The world was not hostile to us—we were benea...        {1}{G}   \n",
       "7858  \"It might fight the Eldrazi, but don't mistake...  {4}{G}{G}{G}   \n",
       "7859  The elf's blade carved deep into the Eldrazi d...        {1}{G}   \n",
       "7860  \"This world tires of its long occupation.\"—Nis...     {2}{G}{G}   \n",
       "7861                                                NaN        {2}{G}   \n",
       "7862  \"If I die, feed me to a shambler. At least tha...        {1}{G}   \n",
       "7863  Eldrazi are not the leopard's preferred prey, ...           {G}   \n",
       "7864  \"In my downtime I used to paint the vistas. No...        {1}{G}   \n",
       "7865  All of Zendikar's beings sense the upheaval th...        {1}{G}   \n",
       "7866  \"Nissa is not the only one with a deep connect...        {1}{G}   \n",
       "7867  \"As long as there is a single shred of life, t...        {1}{G}   \n",
       "7868  \"My mount needs neither reins nor bridle. We b...        {5}{G}   \n",
       "7869  \"In its time of hardship, all of Zendikar crie...        {2}{G}   \n",
       "7870  Her rallying cry reaches far beyond the Tajuru...     {3}{G}{G}   \n",
       "7871  It knows nothing of Eldrazi or Planeswalkers, ...        {4}{G}   \n",
       "7872                                                NaN     {1}{G}{G}   \n",
       "7873  \"The elements understand better than anyone th...        {3}{G}   \n",
       "\n",
       "                          name power       rarity  \\\n",
       "0              Abyssal Specter     2     Uncommon   \n",
       "1                Air Elemental     4     Uncommon   \n",
       "2              Ambition's Cost   NaN     Uncommon   \n",
       "3                 Anaba Shaman     2       Common   \n",
       "4               Angel of Mercy     3     Uncommon   \n",
       "5                 Angelic Page     1       Common   \n",
       "6                    Archivist     1         Rare   \n",
       "7               Ardent Militia     2     Uncommon   \n",
       "8               Avatar of Hope     4         Rare   \n",
       "9             Aven Cloudchaser     2       Common   \n",
       "10                 Aven Fisher     2       Common   \n",
       "11                  Aven Flock     2       Common   \n",
       "12            Balance of Power   NaN         Rare   \n",
       "13           Birds of Paradise     0         Rare   \n",
       "14            Blanchwood Armor   NaN     Uncommon   \n",
       "15                       Blaze   NaN     Uncommon   \n",
       "16            Blessed Reversal   NaN         Rare   \n",
       "17              Blinding Angel     2         Rare   \n",
       "18                  Blood Moon   NaN         Rare   \n",
       "19           Bloodshot Cyclops     4         Rare   \n",
       "20                     Bog Imp     1       Common   \n",
       "21                  Bog Wraith     3     Uncommon   \n",
       "22                        Boil   NaN     Uncommon   \n",
       "23                   Boomerang   NaN       Common   \n",
       "24                     Bribery   NaN         Rare   \n",
       "25            Call of the Wild   NaN         Rare   \n",
       "26               Canopy Spider     1       Common   \n",
       "27              Canyon Wildcat     2       Common   \n",
       "28                Carrion Wall     3     Uncommon   \n",
       "29                     Catalog   NaN       Common   \n",
       "...                        ...   ...          ...   \n",
       "7844         Volcanic Upheaval   NaN       Common   \n",
       "7845      Zada, Hedron Grinder     3         Rare   \n",
       "7846        Beastcaller Savant     1         Rare   \n",
       "7847              Earthen Arms   NaN       Common   \n",
       "7848              Giant Mantis     2       Common   \n",
       "7849     Greenwarden of Murasa     5  Mythic Rare   \n",
       "7850  Infuse with the Elements   NaN     Uncommon   \n",
       "7851            Jaddi Offshoot     0     Uncommon   \n",
       "7852          Lifespring Druid     2       Common   \n",
       "7853             Murasa Ranger     3     Uncommon   \n",
       "7854        Natural Connection   NaN       Common   \n",
       "7855           Nissa's Renewal   NaN         Rare   \n",
       "7856           Oran-Rief Hydra     5         Rare   \n",
       "7857         Oran-Rief Invoker     2       Common   \n",
       "7858            Plated Crusher     7     Uncommon   \n",
       "7859                   Plummet   NaN       Common   \n",
       "7860          Reclaiming Vines   NaN       Common   \n",
       "7861        Retreat to Kazandu   NaN     Uncommon   \n",
       "7862              Rot Shambler     1     Uncommon   \n",
       "7863            Scythe Leopard     1     Uncommon   \n",
       "7864            Seek the Wilds   NaN       Common   \n",
       "7865          Snapping Gnarlid     2       Common   \n",
       "7866           Swell of Growth   NaN       Common   \n",
       "7867            Sylvan Scrying   NaN     Uncommon   \n",
       "7868        Tajuru Beastmaster     5       Common   \n",
       "7869           Tajuru Stalwart     0       Common   \n",
       "7870          Tajuru Warcaller     2     Uncommon   \n",
       "7871        Territorial Baloth     4       Common   \n",
       "7872      Undergrowth Champion     2  Mythic Rare   \n",
       "7873         Woodland Wanderer     2         Rare   \n",
       "\n",
       "                                                   text toughness  \\\n",
       "0     Flying Whenever Abyssal Specter deals damage t...         3   \n",
       "1                                                Flying         4   \n",
       "2             You draw three cards and you lose 3 life.       NaN   \n",
       "3     {R}, {T}: Anaba Shaman deals 1 damage to targe...         2   \n",
       "4     Flying When Angel of Mercy enters the battlefi...         3   \n",
       "5     Flying {T}: Target attacking or blocking creat...         1   \n",
       "6                                     {T}: Draw a card.         1   \n",
       "7                                             Vigilance         5   \n",
       "8     If you have 3 or less life, Avatar of Hope cos...         9   \n",
       "9     Flying (This creature cant be blocked except b...         2   \n",
       "10    Flying (This creature cant be blocked except b...         2   \n",
       "11    Flying (This creature cant be blocked except b...         3   \n",
       "12    If target opponent has more cards in hand than...       NaN   \n",
       "13    Flying {T}: Add one mana of any color to your ...         1   \n",
       "14    Enchant creature (Target a creature as you cas...       NaN   \n",
       "15    Blaze deals X damage to target creature or pla...       NaN   \n",
       "16     You gain 3 life for each creature attacking you.       NaN   \n",
       "17    Flying (This creature cant be blocked except b...         4   \n",
       "18                        Nonbasic lands are Mountains.       NaN   \n",
       "19    {T}, Sacrifice a creature: Bloodshot Cyclops d...         4   \n",
       "20    Flying (This creature cant be blocked except b...         1   \n",
       "21    Swampwalk (This creature cant be blocked as lo...         3   \n",
       "22                                 Destroy all Islands.       NaN   \n",
       "23          Return target permanent to its owners hand.       NaN   \n",
       "24    Search target opponents library for a creature...       NaN   \n",
       "25    {2}{G}{G}: Reveal the top card of your library...       NaN   \n",
       "26    Reach (This creature can block creatures with ...         3   \n",
       "27    Mountainwalk (This creature cant be blocked as...         1   \n",
       "28    Defender (This creature cant attack.) {1}{B}: ...         2   \n",
       "29                 Draw two cards, then discard a card.       NaN   \n",
       "...                                                 ...       ...   \n",
       "7844                               Destroy target land.       NaN   \n",
       "7845  Whenever you cast an instant or sorcery spell ...         3   \n",
       "7846  Haste {T}: Add one mana of any color to your m...         1   \n",
       "7847  Put two +1/+1 counters on target permanent. Aw...       NaN   \n",
       "7848  Reach (This creature can block creatures with ...         4   \n",
       "7849  When Greenwarden of Murasa enters the battlefi...         4   \n",
       "7850  Converge — Put X +1/+1 counters on target crea...       NaN   \n",
       "7851  Defender Landfall — Whenever a land enters the...         3   \n",
       "7852  {T}: Add one mana of any color to your mana pool.         1   \n",
       "7853  Landfall — Whenever a land enters the battlefi...         3   \n",
       "7854  Search your library for a basic land card, put...       NaN   \n",
       "7855  Search your library for up to three basic land...       NaN   \n",
       "7856  Trample Landfall — Whenever a land enters the ...         5   \n",
       "7857  {8}: Oran-Rief Invoker gets +5/+5 and gains tr...         2   \n",
       "7858                                  Trample, hexproof         6   \n",
       "7859               Destroy target creature with flying.       NaN   \n",
       "7860     Destroy target artifact, enchantment, or land.       NaN   \n",
       "7861  Landfall — Whenever a land enters the battlefi...       NaN   \n",
       "7862  Whenever another creature you control dies, pu...         1   \n",
       "7863  Landfall — Whenever a land enters the battlefi...         1   \n",
       "7864  Look at the top four cards of your library. Yo...       NaN   \n",
       "7865  Landfall — Whenever a land enters the battlefi...         2   \n",
       "7866  Target creature gets +2/+2 until end of turn. ...       NaN   \n",
       "7867  Search your library for a land card, reveal it...       NaN   \n",
       "7868  Rally — Whenever Tajuru Beastmaster or another...         5   \n",
       "7869  Converge — Tajuru Stalwart enters the battlefi...         1   \n",
       "7870  Rally — Whenever Tajuru Warcaller or another A...         1   \n",
       "7871  Landfall — Whenever a land enters the battlefi...         4   \n",
       "7872  If damage would be dealt to Undergrowth Champi...         2   \n",
       "7873  Vigilance, trample Converge — Woodland Wandere...         2   \n",
       "\n",
       "                                  type          types                  set  \\\n",
       "0                   Creature — Specter     [Creature]       Eighth Edition   \n",
       "1                 Creature — Elemental     [Creature]       Eighth Edition   \n",
       "2                              Sorcery      [Sorcery]       Eighth Edition   \n",
       "3           Creature — Minotaur Shaman     [Creature]       Eighth Edition   \n",
       "4                     Creature — Angel     [Creature]       Eighth Edition   \n",
       "5              Creature — Angel Spirit     [Creature]       Eighth Edition   \n",
       "6              Creature — Human Wizard     [Creature]       Eighth Edition   \n",
       "7             Creature — Human Soldier     [Creature]       Eighth Edition   \n",
       "8                    Creature — Avatar     [Creature]       Eighth Edition   \n",
       "9              Creature — Bird Soldier     [Creature]       Eighth Edition   \n",
       "10             Creature — Bird Soldier     [Creature]       Eighth Edition   \n",
       "11             Creature — Bird Soldier     [Creature]       Eighth Edition   \n",
       "12                             Sorcery      [Sorcery]       Eighth Edition   \n",
       "13                     Creature — Bird     [Creature]       Eighth Edition   \n",
       "14                  Enchantment — Aura  [Enchantment]       Eighth Edition   \n",
       "15                             Sorcery      [Sorcery]       Eighth Edition   \n",
       "16                             Instant      [Instant]       Eighth Edition   \n",
       "17                    Creature — Angel     [Creature]       Eighth Edition   \n",
       "18                         Enchantment  [Enchantment]       Eighth Edition   \n",
       "19            Creature — Cyclops Giant     [Creature]       Eighth Edition   \n",
       "20                      Creature — Imp     [Creature]       Eighth Edition   \n",
       "21                   Creature — Wraith     [Creature]       Eighth Edition   \n",
       "22                             Instant      [Instant]       Eighth Edition   \n",
       "23                             Instant      [Instant]       Eighth Edition   \n",
       "24                             Sorcery      [Sorcery]       Eighth Edition   \n",
       "25                         Enchantment  [Enchantment]       Eighth Edition   \n",
       "26                   Creature — Spider     [Creature]       Eighth Edition   \n",
       "27                      Creature — Cat     [Creature]       Eighth Edition   \n",
       "28                     Creature — Wall     [Creature]       Eighth Edition   \n",
       "29                             Instant      [Instant]       Eighth Edition   \n",
       "...                                ...            ...                  ...   \n",
       "7844                           Instant      [Instant]  Battle for Zendikar   \n",
       "7845  Legendary Creature — Goblin Ally     [Creature]  Battle for Zendikar   \n",
       "7846        Creature — Elf Shaman Ally     [Creature]  Battle for Zendikar   \n",
       "7847                           Sorcery      [Sorcery]  Battle for Zendikar   \n",
       "7848                 Creature — Insect     [Creature]  Battle for Zendikar   \n",
       "7849              Creature — Elemental     [Creature]  Battle for Zendikar   \n",
       "7850                           Instant      [Instant]  Battle for Zendikar   \n",
       "7851                  Creature — Plant     [Creature]  Battle for Zendikar   \n",
       "7852              Creature — Elf Druid     [Creature]  Battle for Zendikar   \n",
       "7853          Creature — Human Warrior     [Creature]  Battle for Zendikar   \n",
       "7854                           Instant      [Instant]  Battle for Zendikar   \n",
       "7855                           Sorcery      [Sorcery]  Battle for Zendikar   \n",
       "7856                  Creature — Hydra     [Creature]  Battle for Zendikar   \n",
       "7857           Creature — Human Shaman     [Creature]  Battle for Zendikar   \n",
       "7858                  Creature — Beast     [Creature]  Battle for Zendikar   \n",
       "7859                           Instant      [Instant]  Battle for Zendikar   \n",
       "7860                           Sorcery      [Sorcery]  Battle for Zendikar   \n",
       "7861                       Enchantment  [Enchantment]  Battle for Zendikar   \n",
       "7862                 Creature — Fungus     [Creature]  Battle for Zendikar   \n",
       "7863                    Creature — Cat     [Creature]  Battle for Zendikar   \n",
       "7864                           Sorcery      [Sorcery]  Battle for Zendikar   \n",
       "7865                  Creature — Beast     [Creature]  Battle for Zendikar   \n",
       "7866                           Instant      [Instant]  Battle for Zendikar   \n",
       "7867                           Sorcery      [Sorcery]  Battle for Zendikar   \n",
       "7868       Creature — Elf Warrior Ally     [Creature]  Battle for Zendikar   \n",
       "7869         Creature — Elf Scout Ally     [Creature]  Battle for Zendikar   \n",
       "7870       Creature — Elf Warrior Ally     [Creature]  Battle for Zendikar   \n",
       "7871                  Creature — Beast     [Creature]  Battle for Zendikar   \n",
       "7872              Creature — Elemental     [Creature]  Battle for Zendikar   \n",
       "7873              Creature — Elemental     [Creature]  Battle for Zendikar   \n",
       "\n",
       "     releaseDate  \n",
       "0     2003-07-28  \n",
       "1     2003-07-28  \n",
       "2     2003-07-28  \n",
       "3     2003-07-28  \n",
       "4     2003-07-28  \n",
       "5     2003-07-28  \n",
       "6     2003-07-28  \n",
       "7     2003-07-28  \n",
       "8     2003-07-28  \n",
       "9     2003-07-28  \n",
       "10    2003-07-28  \n",
       "11    2003-07-28  \n",
       "12    2003-07-28  \n",
       "13    2003-07-28  \n",
       "14    2003-07-28  \n",
       "15    2003-07-28  \n",
       "16    2003-07-28  \n",
       "17    2003-07-28  \n",
       "18    2003-07-28  \n",
       "19    2003-07-28  \n",
       "20    2003-07-28  \n",
       "21    2003-07-28  \n",
       "22    2003-07-28  \n",
       "23    2003-07-28  \n",
       "24    2003-07-28  \n",
       "25    2003-07-28  \n",
       "26    2003-07-28  \n",
       "27    2003-07-28  \n",
       "28    2003-07-28  \n",
       "29    2003-07-28  \n",
       "...          ...  \n",
       "7844  2015-10-02  \n",
       "7845  2015-10-02  \n",
       "7846  2015-10-02  \n",
       "7847  2015-10-02  \n",
       "7848  2015-10-02  \n",
       "7849  2015-10-02  \n",
       "7850  2015-10-02  \n",
       "7851  2015-10-02  \n",
       "7852  2015-10-02  \n",
       "7853  2015-10-02  \n",
       "7854  2015-10-02  \n",
       "7855  2015-10-02  \n",
       "7856  2015-10-02  \n",
       "7857  2015-10-02  \n",
       "7858  2015-10-02  \n",
       "7859  2015-10-02  \n",
       "7860  2015-10-02  \n",
       "7861  2015-10-02  \n",
       "7862  2015-10-02  \n",
       "7863  2015-10-02  \n",
       "7864  2015-10-02  \n",
       "7865  2015-10-02  \n",
       "7866  2015-10-02  \n",
       "7867  2015-10-02  \n",
       "7868  2015-10-02  \n",
       "7869  2015-10-02  \n",
       "7870  2015-10-02  \n",
       "7871  2015-10-02  \n",
       "7872  2015-10-02  \n",
       "7873  2015-10-02  \n",
       "\n",
       "[7874 rows x 14 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# reset index and drop old index vals \n",
    "\n",
    "cards_no_nulls.reset_index(inplace=True)\n",
    "cards_no_nulls.pop('index')\n",
    "# cards_no_nulls.pop('level_0')\n",
    "cards_no_nulls"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "collapsed": false,
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "# datamunge to get \"color\" out of a list format\n",
    "\n",
    "def nolist(x):\n",
    "    return x[0]\n",
    "\n",
    "cards_no_nulls['colors'] = cards_no_nulls['colors'].apply(nolist)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Some cards have resource symbols in their text with their color. This might give a classifier an unfair advantage. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "u'{1}, {1}: Anaba Shaman deals 1 damage to target creature or player.'"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# remove resource symbols from one card \n",
    "\n",
    "a = cards_no_nulls.text[3]\n",
    "re.sub(\"{[A-Z]}\" , \"{1}\", a)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# remove resource symbols from all cards \n",
    "\n",
    "def tap(x):\n",
    "    return re.sub(\"{T}\" , \"Tap \", x)\n",
    "\n",
    "def nomana(x):\n",
    "    return re.sub(\"{[A-Z]}\" , \"{1}\", x)\n",
    "\n",
    "cards_no_nulls.text = cards_no_nulls.text.apply(tap)\n",
    "cards_no_nulls.text = cards_no_nulls.text.apply(nomana)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "collapsed": false,
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0       Flying Whenever Abyssal Specter deals damage t...\n",
       "1                                                  Flying\n",
       "2               You draw three cards and you lose 3 life.\n",
       "3       {1}, Tap : Anaba Shaman deals 1 damage to targ...\n",
       "4       Flying When Angel of Mercy enters the battlefi...\n",
       "5       Flying Tap : Target attacking or blocking crea...\n",
       "6                                      Tap : Draw a card.\n",
       "7                                               Vigilance\n",
       "8       If you have 3 or less life, Avatar of Hope cos...\n",
       "9       Flying (This creature cant be blocked except b...\n",
       "10      Flying (This creature cant be blocked except b...\n",
       "11      Flying (This creature cant be blocked except b...\n",
       "12      If target opponent has more cards in hand than...\n",
       "13      Flying Tap : Add one mana of any color to your...\n",
       "14      Enchant creature (Target a creature as you cas...\n",
       "15      Blaze deals X damage to target creature or pla...\n",
       "16       You gain 3 life for each creature attacking you.\n",
       "17      Flying (This creature cant be blocked except b...\n",
       "18                          Nonbasic lands are Mountains.\n",
       "19      Tap , Sacrifice a creature: Bloodshot Cyclops ...\n",
       "20      Flying (This creature cant be blocked except b...\n",
       "21      Swampwalk (This creature cant be blocked as lo...\n",
       "22                                   Destroy all Islands.\n",
       "23            Return target permanent to its owners hand.\n",
       "24      Search target opponents library for a creature...\n",
       "25      {2}{1}{1}: Reveal the top card of your library...\n",
       "26      Reach (This creature can block creatures with ...\n",
       "27      Mountainwalk (This creature cant be blocked as...\n",
       "28      Defender (This creature cant attack.) {1}{1}: ...\n",
       "29                   Draw two cards, then discard a card.\n",
       "                              ...                        \n",
       "7844                                 Destroy target land.\n",
       "7845    Whenever you cast an instant or sorcery spell ...\n",
       "7846    Haste Tap : Add one mana of any color to your ...\n",
       "7847    Put two +1/+1 counters on target permanent. Aw...\n",
       "7848    Reach (This creature can block creatures with ...\n",
       "7849    When Greenwarden of Murasa enters the battlefi...\n",
       "7850    Converge — Put X +1/+1 counters on target crea...\n",
       "7851    Defender Landfall — Whenever a land enters the...\n",
       "7852    Tap : Add one mana of any color to your mana p...\n",
       "7853    Landfall — Whenever a land enters the battlefi...\n",
       "7854    Search your library for a basic land card, put...\n",
       "7855    Search your library for up to three basic land...\n",
       "7856    Trample Landfall — Whenever a land enters the ...\n",
       "7857    {8}: Oran-Rief Invoker gets +5/+5 and gains tr...\n",
       "7858                                    Trample, hexproof\n",
       "7859                 Destroy target creature with flying.\n",
       "7860       Destroy target artifact, enchantment, or land.\n",
       "7861    Landfall — Whenever a land enters the battlefi...\n",
       "7862    Whenever another creature you control dies, pu...\n",
       "7863    Landfall — Whenever a land enters the battlefi...\n",
       "7864    Look at the top four cards of your library. Yo...\n",
       "7865    Landfall — Whenever a land enters the battlefi...\n",
       "7866    Target creature gets +2/+2 until end of turn. ...\n",
       "7867    Search your library for a land card, reveal it...\n",
       "7868    Rally — Whenever Tajuru Beastmaster or another...\n",
       "7869    Converge — Tajuru Stalwart enters the battlefi...\n",
       "7870    Rally — Whenever Tajuru Warcaller or another A...\n",
       "7871    Landfall — Whenever a land enters the battlefi...\n",
       "7872    If damage would be dealt to Undergrowth Champi...\n",
       "7873    Vigilance, trample Converge — Woodland Wandere...\n",
       "Name: text, dtype: object"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cards_no_nulls.text"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# store to disk\n",
    "\n",
    "# cards_no_nulls.reset_index(inplace=True)\n",
    "# cards_no_nulls.pop('index')\n",
    "\n",
    "cards_no_nulls.to_pickle('data/cards_modern.pkl')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Some cards have their name in the text, names have no predictive ability and could only lead to overfitting. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "u'{1}, Tap : This deals 1 damage to target creature or player.'"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# remove name from one card \n",
    "\n",
    "re.sub(cards_no_nulls.name[3] , \"This\", cards_no_nulls.text[3] )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {
    "collapsed": false,
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "9.96 minutes\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\HN\\Anaconda2\\lib\\site-packages\\ipykernel\\__main__.py:8: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "0       Flying Whenever This deals damage to a player,...\n",
       "1                                                  Flying\n",
       "2               You draw three cards and you lose 3 life.\n",
       "3       {1}, Tap : This deals 1 damage to target creat...\n",
       "4       Flying When This enters the battlefield, you g...\n",
       "5       Flying Tap : Target attacking or blocking crea...\n",
       "6                                      Tap : Draw a card.\n",
       "7                                               Vigilance\n",
       "8       If you have 3 or less life, This costs {6} les...\n",
       "9       Flying (This creature cant be blocked except b...\n",
       "10      Flying (This creature cant be blocked except b...\n",
       "11      Flying (This creature cant be blocked except b...\n",
       "12      If target opponent has more cards in hand than...\n",
       "13      Flying Tap : Add one mana of any color to your...\n",
       "14      Enchant creature (Target a creature as you cas...\n",
       "15      This deals X damage to target creature or player.\n",
       "16       You gain 3 life for each creature attacking you.\n",
       "17      Flying (This creature cant be blocked except b...\n",
       "18                          Nonbasic lands are Mountains.\n",
       "19      Tap , Sacrifice a creature: This deals damage ...\n",
       "20      Flying (This creature cant be blocked except b...\n",
       "21      Swampwalk (This creature cant be blocked as lo...\n",
       "22                                   Destroy all Islands.\n",
       "23            Return target permanent to its owners hand.\n",
       "24      Search target opponents library for a creature...\n",
       "25      {2}{1}{1}: Reveal the top card of your library...\n",
       "26      Reach (This creature can block creatures with ...\n",
       "27      Mountainwalk (This creature cant be blocked as...\n",
       "28      Defender (This creature cant attack.) {1}{1}: ...\n",
       "29                   Draw two cards, then discard a card.\n",
       "                              ...                        \n",
       "7844                                 Destroy target land.\n",
       "7845    Whenever you cast an instant or sorcery spell ...\n",
       "7846    Haste Tap : Add one mana of any color to your ...\n",
       "7847    Put two +1/+1 counters on target permanent. Aw...\n",
       "7848    Reach (This creature can block creatures with ...\n",
       "7849    When This enters the battlefield, you may retu...\n",
       "7850    Converge — Put X +1/+1 counters on target crea...\n",
       "7851    Defender Landfall — Whenever a land enters the...\n",
       "7852    Tap : Add one mana of any color to your mana p...\n",
       "7853    Landfall — Whenever a land enters the battlefi...\n",
       "7854    Search your library for a basic land card, put...\n",
       "7855    Search your library for up to three basic land...\n",
       "7856    Trample Landfall — Whenever a land enters the ...\n",
       "7857    {8}: This gets +5/+5 and gains trample until e...\n",
       "7858                                    Trample, hexproof\n",
       "7859                 Destroy target creature with flying.\n",
       "7860       Destroy target artifact, enchantment, or land.\n",
       "7861    Landfall — Whenever a land enters the battlefi...\n",
       "7862    Whenever another creature you control dies, pu...\n",
       "7863    Landfall — Whenever a land enters the battlefi...\n",
       "7864    Look at the top four cards of your library. Yo...\n",
       "7865    Landfall — Whenever a land enters the battlefi...\n",
       "7866    Target creature gets +2/+2 until end of turn. ...\n",
       "7867    Search your library for a land card, reveal it...\n",
       "7868    Rally — Whenever This or another Ally enters t...\n",
       "7869    Converge — This enters the battlefield with a ...\n",
       "7870    Rally — Whenever This or another Ally enters t...\n",
       "7871    Landfall — Whenever a land enters the battlefi...\n",
       "7872    If damage would be dealt to This while it has ...\n",
       "7873    Vigilance, trample Converge — This enters the ...\n",
       "Name: text, dtype: object"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# remove card names from all cards  \n",
    "\n",
    "import time\n",
    "\n",
    "t0 = time.time()\n",
    "\n",
    "for i in xrange(len(cards_no_nulls)):\n",
    "    cards_no_nulls['text'][i] = re.sub(cards_no_nulls['name'][i] , \"This\", cards_no_nulls['text'][i]) \n",
    "\n",
    "t1 = time.time()\n",
    "\n",
    "print round((t1-t0)/60, 2), \"minutes\"\n",
    "cards_no_nulls.text"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# store to disk\n",
    "\n",
    "# cards_no_nulls.reset_index(inplace=True)\n",
    "# cards_no_nulls.pop('index')\n",
    "\n",
    "cards_no_nulls.to_pickle('data/cards_modern_no_name.pkl')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Some cards have parentheses explaining what a rules term means. All this text is redundanct and could only mislead a classifer. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "u'Flying  When This enters the battlefield, destroy target enchantment.'"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# remove helper text from one card \n",
    "\n",
    "a = cards_no_nulls.text[9]\n",
    "re.sub('\\([^)]*\\)' , \"\", a)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# remove helper text \n",
    "\n",
    "def hardmode(x):\n",
    "    return re.sub('\\([^)]*\\)' , \"\", x)\n",
    "\n",
    "cards_no_nulls.text = cards_no_nulls.text.apply(hardmode)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# store to disk\n",
    "\n",
    "cards_no_nulls.to_pickle('data/5color_modern_no_name_hardmode.pkl')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "### New DF with all modern cards\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Reading in set: Eighth Edition\n",
      "Reading in set: Mirrodin\n",
      "Reading in set: Darksteel\n",
      "Reading in set: Fifth Dawn\n",
      "Reading in set: Champions of Kamigawa\n",
      "Reading in set: Betrayers of Kamigawa\n",
      "Reading in set: Saviors of Kamigawa\n",
      "Reading in set: Ninth Edition\n",
      "Reading in set: Ravnica: City of Guilds\n",
      "Reading in set: Guildpact\n",
      "Reading in set: Dissension\n",
      "Reading in set: Coldsnap\n",
      "Reading in set: Time Spiral\n",
      "Reading in set: Time Spiral \"Timeshifted\"\n",
      "Reading in set: Planar Chaos\n",
      "Reading in set: Future Sight\n",
      "Reading in set: Tenth Edition\n",
      "Reading in set: Lorwyn\n",
      "Reading in set: Morningtide\n",
      "Reading in set: Shadowmoor\n",
      "Reading in set: Eventide\n",
      "Reading in set: Shards of Alara\n",
      "Reading in set: Conflux\n",
      "Reading in set: Alara Reborn\n",
      "Reading in set: Magic 2010\n",
      "Reading in set: Zendikar\n",
      "Reading in set: Worldwake\n",
      "Reading in set: Rise of the Eldrazi\n",
      "Reading in set: Magic 2011\n",
      "Reading in set: Scars of Mirrodin\n",
      "Reading in set: Mirrodin Besieged\n",
      "Reading in set: New Phyrexia\n",
      "Reading in set: Magic 2012\n",
      "Reading in set: Innistrad\n",
      "Reading in set: Dark Ascension\n",
      "Reading in set: Avacyn Restored\n",
      "Reading in set: Magic 2013\n",
      "Reading in set: Return to Ravnica\n",
      "Reading in set: Gatecrash\n",
      "Reading in set: Dragon's Maze\n",
      "Reading in set: Magic 2014 Core Set\n",
      "Reading in set: Theros\n",
      "Reading in set: Born of the Gods\n",
      "Reading in set: Journey into Nyx\n",
      "Reading in set: Magic 2015 Core Set\n",
      "Reading in set: Khans of Tarkir\n",
      "Reading in set: Fate Reforged\n",
      "Reading in set: Dragons of Tarkir\n",
      "Reading in set: Magic Origins\n",
      "Reading in set: Battle for Zendikar\n",
      "\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 11502 entries, 0 to 298\n",
      "Columns: 14 entries, artist to releaseDate\n",
      "dtypes: float64(1), object(13)\n",
      "memory usage: 1.3+ MB\n",
      "None\n",
      "Done!\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 10521 entries, 0 to 10520\n",
      "Data columns (total 14 columns):\n",
      "artist         10521 non-null object\n",
      "cmc            10066 non-null float64\n",
      "colors         8965 non-null object\n",
      "flavor         7216 non-null object\n",
      "manaCost       10066 non-null object\n",
      "name           10521 non-null object\n",
      "power          5452 non-null object\n",
      "rarity         10521 non-null object\n",
      "text           10521 non-null object\n",
      "toughness      5452 non-null object\n",
      "type           10521 non-null object\n",
      "types          10521 non-null object\n",
      "set            10521 non-null object\n",
      "releaseDate    10521 non-null object\n",
      "dtypes: float64(1), object(13)\n",
      "memory usage: 1.2+ MB\n"
     ]
    }
   ],
   "source": [
    "# groups all modern cards of all colors from sets into one data frame \n",
    "\n",
    "cards = None\n",
    "\n",
    "for s in xrange(len(modern_sets)):\n",
    "    print \"Reading in set:\", modern_sets.name[s]\n",
    "    target = pd.read_json(json.dumps(modern_sets.cards[s]))\n",
    "    \n",
    "    # slice to just the good stuff \n",
    "    target = target[['artist', 'cmc', 'colors', 'flavor', 'manaCost', 'name', \n",
    "                    'power', 'rarity', 'text', 'toughness', 'type', 'types']]\n",
    "    \n",
    "    # add set name and date\n",
    "    target['set'] = modern_sets.name[s]\n",
    "    target['releaseDate'] = modern_sets.releaseDate[s]    \n",
    "    \n",
    "    # add to cards df \n",
    "    cards = pd.concat([cards, target])\n",
    "\n",
    "# clean up errors\n",
    "cards['text'].replace(\"\\n\" , \" \", inplace=True, regex=True)\n",
    "cards['text'].replace(\"\\'\" , \"\", inplace=True, regex=True)\n",
    "\n",
    "print \n",
    "print cards.info(verbose=False)\n",
    "\n",
    "# drop tokens \n",
    "cards_no_nulls = cards.loc[cards['rarity'].isin(['Common', 'Uncommon', \n",
    "                                                 'Rare', 'Mythic Rare'])]\n",
    "\n",
    "# only keep cards with text\n",
    "cards_no_nulls = cards_no_nulls[cards_no_nulls['text'].notnull()]\n",
    "\n",
    "# save the \"tap\" symbol\n",
    "cards_no_nulls.text = cards_no_nulls.text.apply(tap)\n",
    "\n",
    "# flatten all resource symbols from all cards \n",
    "cards_no_nulls.text = cards_no_nulls.text.apply(nomana)\n",
    "\n",
    "# remove helper text \n",
    "cards_no_nulls.text = cards_no_nulls.text.apply(hardmode)\n",
    "\n",
    "# reset index\n",
    "cards_no_nulls.reset_index(inplace=True)\n",
    "cards_no_nulls.pop('index')\n",
    "\n",
    "print \"Done!\"\n",
    "cards_no_nulls.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# store to disk\n",
    "\n",
    "cards_no_nulls.to_pickle('data/all_cards_modern_no_name_hardmode.pkl')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.11"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}