{
"metadata": {
"name": "",
"signature": "sha256:f37d87c5d78ae3b0b10cbc1359b86c839e814f590091e4ab2c0b5b9d14a6e2d1"
},
"nbformat": 3,
"nbformat_minor": 0,
"worksheets": [
{
"cells": [
{
"cell_type": "heading",
"level": 1,
"metadata": {},
"source": [
"Marvel API: Boring Data!"
]
},
{
"cell_type": "heading",
"level": 3,
"metadata": {},
"source": [
"Portland Data Science Meetup, November 2014"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"import md5\n",
"import os\n",
"import time\n",
"import urlparse\n",
"\n",
"import bokeh.charts as bc\n",
"import matplotlib.pyplot as plt\n",
"import pandas as pd\n",
"import requests\n",
"import qgrid\n",
"import seaborn as sns\n",
"\n",
"%matplotlib inline\n",
"qgrid.nbinstall()\n",
"\n",
"# Quick and Dirty API wrapper\n",
"\n",
"class Marvelous(object):\n",
"\n",
" base_url = \"http://gateway.marvel.com\"\n",
"\n",
" def __init__(self, private_key=None, public_key=None):\n",
" \"\"\"A microwrapper for the Marvel API\"\"\"\n",
" \n",
" if private_key and public_key:\n",
" self.private_key = private\n",
" self.public_key = public_key\n",
" else:\n",
" self.private_key = os.getenv('MARVEL_PRIVATE_KEY')\n",
" self.public_key = os.getenv('MARVEL_PUBLIC_KEY')\n",
" \n",
" def request(self, endpoint, **kwargs):\n",
" \"\"\"Make a request against the Marvel API\"\"\"\n",
" ts = str(int(time.time()))\n",
" concat = ''.join([ts, self.private_key, self.public_key])\n",
" query_params = {\n",
" 'ts': ts, \n",
" 'apikey': self.public_key, \n",
" 'hash': md5.new(concat).hexdigest()}\n",
" query_params.update(kwargs)\n",
" url = urlparse.urljoin(self.base_url, endpoint)\n",
" resp = requests.get(url, params=query_params)\n",
" if resp.status_code != 200:\n",
" resp.raise_for_status()\n",
" else:\n",
" return resp.json()\n",
" \n",
" def get_character(self, character_name):\n",
" \"\"\"Get the data for a given character name\"\"\"\n",
" resp = self.request('/v1/public/characters', name=character_name)\n",
" result = resp['data']['results'][0]\n",
" return {\n",
" 'name': result['name'],\n",
" 'description': result['description'],\n",
" 'id': result['id'],\n",
" 'comic_count': result['comics']['available'],\n",
" 'story_count': result['stories']['available'],\n",
" 'series_count': result['series']['available'],\n",
" 'event_count': result['events']['available']\n",
" }"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 6
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"api = Marvelous()"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 7
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"api.get_character('Captain America')"
],
"language": "python",
"metadata": {},
"outputs": [
{
"metadata": {},
"output_type": "pyout",
"prompt_number": 8,
"text": [
"{'comic_count': 1422,\n",
" 'description': u\"Vowing to serve his country any way he could, young Steve Rogers took the super soldier serum to become America's one-man army. Fighting for the red, white and blue for over 60 years, Captain America is the living, breathing symbol of freedom and liberty.\",\n",
" 'event_count': 19,\n",
" 'id': 1009220,\n",
" 'name': u'Captain America',\n",
" 'series_count': 375,\n",
" 'story_count': 2285}"
]
}
],
"prompt_number": 8
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"cap_comics = api.request('/v1/public/characters/1009220/comics', dateRange='2010-01-01,2014-11-01', limit=100)"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 9
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"# Let's get all of the characters in this list of comics\n",
"comic_list = cap_comics['data']['results']\n",
"character_set = {c['name'] for comic in comic_list for c in comic['characters']['items']}"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 10
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"# Let's only get comic ids for comics that have associated characters\n",
"comic_ids = [str(com['id']) for com in comic_list if com['characters']['available'] > 10]\n",
"# Marvel's API will only accept up to 10 comic ids\n",
"joined_ids = ','.join(comic_ids[:5])\n",
"joined_ids"
],
"language": "python",
"metadata": {},
"outputs": [
{
"metadata": {},
"output_type": "pyout",
"prompt_number": 11,
"text": [
"'41278,35241,41191,42118,42117'"
]
}
],
"prompt_number": 11
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"all_characters = api.request('/v1/public/characters', comics=joined_ids, limit=50)"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 12
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"character_list = all_characters['data']['results']\n",
"records = []\n",
"for character in character_list:\n",
" records.append({\n",
" 'name': character['name'],\n",
" 'description': character['description'],\n",
" 'id': character['id'],\n",
" 'comic_count': character['comics']['available'],\n",
" 'story_count': character['stories']['available'],\n",
" 'series_count': character['series']['available'],\n",
" 'event_count': character['events']['available']\n",
" })"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 13
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"hero_df = pd.DataFrame(records)\n",
"qgrid.show_grid(hero_df, remote_js=True)"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"\n",
"
\n",
"\n",
"
"
],
"metadata": {},
"output_type": "display_data"
},
{
"javascript": [
"var path_dictionary = {\n",
" jquery_drag: \"https://cdn.rawgit.com/quantopian/qgrid/6988858671b6f80c7d1987e07ebff3dc810d20ce/qgrid/qgridjs//lib/jquery.event.drag-2.2\",\n",
" slick_core: \"https://cdn.rawgit.com/quantopian/qgrid/6988858671b6f80c7d1987e07ebff3dc810d20ce/qgrid/qgridjs//lib/slick.core.2.2\",\n",
" slick_data_view: \"https://cdn.rawgit.com/quantopian/qgrid/6988858671b6f80c7d1987e07ebff3dc810d20ce/qgrid/qgridjs//lib/slick.dataview.2.2\",\n",
" slick_grid: \"https://cdn.rawgit.com/quantopian/qgrid/6988858671b6f80c7d1987e07ebff3dc810d20ce/qgrid/qgridjs//lib/slick.grid.2.2\",\n",
" data_grid: \"https://cdn.rawgit.com/quantopian/qgrid/6988858671b6f80c7d1987e07ebff3dc810d20ce/qgrid/qgridjs//qgrid\",\n",
" date_filter: \"https://cdn.rawgit.com/quantopian/qgrid/6988858671b6f80c7d1987e07ebff3dc810d20ce/qgrid/qgridjs//qgrid.datefilter\",\n",
" slider_filter: \"https://cdn.rawgit.com/quantopian/qgrid/6988858671b6f80c7d1987e07ebff3dc810d20ce/qgrid/qgridjs//qgrid.sliderfilter\",\n",
" filter_base: \"https://cdn.rawgit.com/quantopian/qgrid/6988858671b6f80c7d1987e07ebff3dc810d20ce/qgrid/qgridjs//qgrid.filterbase\",\n",
" handlebars: \"https://cdnjs.cloudflare.com/ajax/libs/handlebars.js/2.0.0/handlebars.min\"\n",
"};\n",
"\n",
"var existing_config = require.s.contexts._.config;\n",
"if (!existing_config.paths['underscore']){\n",
" path_dictionary['underscore'] = \"https://cdnjs.cloudflare.com/ajax/libs/underscore.js/1.7.0/underscore-min\";\n",
"}\n",
"\n",
"if (!existing_config.paths['moment']){\n",
" path_dictionary['moment'] = \"https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.8.3/moment.min\";\n",
"}\n",
"\n",
"if (!existing_config.paths['jqueryui']){\n",
" path_dictionary['jqueryui'] = \"https://ajax.googleapis.com/ajax/libs/jqueryui/1.11.1/jquery-ui.min\";\n",
"}\n",
"\n",
"require.config({\n",
" paths: path_dictionary\n",
"});\n",
"\n",
"if (typeof jQuery === 'function') {\n",
" define('jquery', function() { return jQuery; });\n",
"}\n",
"\n",
"require([\n",
" 'jquery',\n",
" 'jquery_drag',\n",
" 'slick_core',\n",
" 'slick_data_view'\n",
"],\n",
"function($){\n",
" $('#f54a699c-b43e-4388-8ee5-10e72099f28a').closest('.rendered_html').removeClass('rendered_html');\n",
" require(['slick_grid'], function(){\n",
" require([\"data_grid\"], function(dgrid){\n",
" var grid = new dgrid.QGrid('#f54a699c-b43e-4388-8ee5-10e72099f28a', [{\"null\":0,\"comic_count\":963,\"description\":\"Earth's Mightiest Heroes joined forces to take on threats that were too big for any one hero to tackle. With a roster that has included Captain America, Iron Man, Ant-Man, Hulk, Thor, Wasp and dozens more over the years, the Avengers have come to be regarded as Earth's No. 1 team.\",\"event_count\":21,\"id\":1009165,\"name\":\"Avengers\",\"series_count\":192,\"story_count\":1373},{\"null\":1,\"comic_count\":336,\"description\":\"\",\"event_count\":13,\"id\":1009187,\"name\":\"Black Panther\",\"series_count\":101,\"story_count\":461},{\"null\":2,\"comic_count\":286,\"description\":\"\",\"event_count\":8,\"id\":1009189,\"name\":\"Black Widow\",\"series_count\":120,\"story_count\":296},{\"null\":3,\"comic_count\":1422,\"description\":\"Vowing to serve his country any way he could, young Steve Rogers took the super soldier serum to become America's one-man army. Fighting for the red, white and blue for over 60 years, Captain America is the living, breathing symbol of freedom and liberty.\",\"event_count\":19,\"id\":1009220,\"name\":\"Captain America\",\"series_count\":375,\"story_count\":2285},{\"null\":4,\"comic_count\":321,\"description\":\"\",\"event_count\":14,\"id\":1010338,\"name\":\"Captain Marvel (Carol Danvers)\",\"series_count\":82,\"story_count\":451},{\"null\":5,\"comic_count\":552,\"description\":\"\",\"event_count\":22,\"id\":1009243,\"name\":\"Colossus\",\"series_count\":150,\"story_count\":663},{\"null\":6,\"comic_count\":697,\"description\":\"\",\"event_count\":26,\"id\":1009257,\"name\":\"Cyclops\",\"series_count\":214,\"story_count\":752},{\"null\":7,\"comic_count\":818,\"description\":\"Abandoned by his mother, Matt Murdock was raised by his father, boxer \\\"Battling Jack\\\" Murdock, in Hell's Kitchen. Realizing that rules were needed to prevent people from behaving badly, young Matt decided to study law; however, when he saved a man from an oncoming truck, it spilled a radioactive cargo that rendered Matt blind while enhancing his remaining senses. Under the harsh tutelage of blind martial arts master Stick, Matt mastered his heightened senses and became a formidable fighter.\",\"event_count\":11,\"id\":1009262,\"name\":\"Daredevil\",\"series_count\":162,\"story_count\":1316},{\"null\":8,\"comic_count\":70,\"description\":\"\",\"event_count\":1,\"id\":1009276,\"name\":\"Doctor Octopus\",\"series_count\":32,\"story_count\":69},{\"null\":9,\"comic_count\":412,\"description\":\"\",\"event_count\":12,\"id\":1009282,\"name\":\"Doctor Strange\",\"series_count\":123,\"story_count\":562},{\"null\":10,\"comic_count\":221,\"description\":\"\",\"event_count\":7,\"id\":1009310,\"name\":\"Emma Frost\",\"series_count\":84,\"story_count\":208},{\"null\":11,\"comic_count\":1077,\"description\":\"After being exposed to cosmic rays, Reed Richards, Susan Storm, Ben Grimm and Johnny Storm found they had amazing new powers. Reed Richards found he has the ability to stretch his body in any way he wanted, while Susan Storm can turn herself, objects and other people invisible. Ben Grimm transformed into a rocky, super-strong behemoth and Johnny Storm has the ability to set himself on fire. Dubbed the Fantastic Four, Mr. Fantastic, Invisible Woman, Thing and the Human Torch are Marvel's First Family.\",\"event_count\":21,\"id\":1009299,\"name\":\"Fantastic Four\",\"series_count\":224,\"story_count\":1776},{\"null\":12,\"comic_count\":295,\"description\":\"\",\"event_count\":10,\"id\":1009313,\"name\":\"Gambit\",\"series_count\":84,\"story_count\":363},{\"null\":13,\"comic_count\":231,\"description\":\" \",\"event_count\":8,\"id\":1011490,\"name\":\"Hank Pym\",\"series_count\":84,\"story_count\":301},{\"null\":14,\"comic_count\":213,\"description\":\"\",\"event_count\":14,\"id\":1009338,\"name\":\"Hawkeye\",\"series_count\":103,\"story_count\":215},{\"null\":15,\"comic_count\":62,\"description\":\"\",\"event_count\":5,\"id\":1011428,\"name\":\"Hope Summers\",\"series_count\":12,\"story_count\":84},{\"null\":16,\"comic_count\":1304,\"description\":\"Caught in a gamma bomb explosion while trying to save the life of a teenager, Dr. Bruce Banner was transformed into the incredibly powerful creature called the Hulk. An all too often misunderstood hero, the angrier the Hulk gets, the stronger the Hulk gets.\",\"event_count\":24,\"id\":1009351,\"name\":\"Hulk\",\"series_count\":314,\"story_count\":1973},{\"null\":17,\"comic_count\":123,\"description\":\"\",\"event_count\":9,\"id\":1009367,\"name\":\"Iron Fist (Danny Rand)\",\"series_count\":51,\"story_count\":130},{\"null\":18,\"comic_count\":2027,\"description\":\"Wounded, captured and forced to build a weapon by his enemies, billionaire industrialist Tony Stark instead created an advanced suit of armor to save his life and escape captivity. Now with a new outlook on life, Tony uses his money and intelligence to make the world a safer, better place as Iron Man.\",\"event_count\":24,\"id\":1009368,\"name\":\"Iron Man\",\"series_count\":443,\"story_count\":2885},{\"null\":19,\"comic_count\":74,\"description\":\"U.S. Air Force pilot and Tony Stark's friend who has his own suit of Iron Man armor, nicknamed, \\\"War Machine.\\\"\",\"event_count\":4,\"id\":1009538,\"name\":\"Iron Patriot (James Rhodes)\",\"series_count\":29,\"story_count\":92},{\"null\":20,\"comic_count\":40,\"description\":\"\",\"event_count\":2,\"id\":1009378,\"name\":\"Jessica Jones\",\"series_count\":15,\"story_count\":58},{\"null\":21,\"comic_count\":151,\"description\":\"\",\"event_count\":9,\"id\":1009382,\"name\":\"Juggernaut\",\"series_count\":74,\"story_count\":153},{\"null\":22,\"comic_count\":54,\"description\":\"\",\"event_count\":1,\"id\":1009404,\"name\":\"Lizard\",\"series_count\":18,\"story_count\":62},{\"null\":23,\"comic_count\":187,\"description\":\"\",\"event_count\":7,\"id\":1009407,\"name\":\"Loki\",\"series_count\":77,\"story_count\":186},{\"null\":24,\"comic_count\":104,\"description\":\"\",\"event_count\":7,\"id\":1009215,\"name\":\"Luke Cage\",\"series_count\":52,\"story_count\":96},{\"null\":25,\"comic_count\":249,\"description\":\"\",\"event_count\":15,\"id\":1009417,\"name\":\"Magneto\",\"series_count\":111,\"story_count\":247},{\"null\":26,\"comic_count\":282,\"description\":\"\",\"event_count\":10,\"id\":1009471,\"name\":\"Nick Fury\",\"series_count\":123,\"story_count\":266},{\"null\":27,\"comic_count\":125,\"description\":\"\",\"event_count\":6,\"id\":1009325,\"name\":\"Norman Osborn\",\"series_count\":54,\"story_count\":134},{\"null\":28,\"comic_count\":48,\"description\":\"\",\"event_count\":3,\"id\":1011360,\"name\":\"Red Hulk\",\"series_count\":19,\"story_count\":55},{\"null\":29,\"comic_count\":15,\"description\":\"\",\"event_count\":2,\"id\":1011436,\"name\":\"Red She-Hulk\",\"series_count\":5,\"story_count\":16},{\"null\":30,\"comic_count\":112,\"description\":\"\",\"event_count\":4,\"id\":1009535,\"name\":\"Red Skull\",\"series_count\":56,\"story_count\":98},{\"null\":31,\"comic_count\":20,\"description\":\"\",\"event_count\":0,\"id\":1011426,\"name\":\"Scarlet Spider (Kaine)\",\"series_count\":4,\"story_count\":21},{\"null\":32,\"comic_count\":261,\"description\":\"\",\"event_count\":13,\"id\":1009562,\"name\":\"Scarlet Witch\",\"series_count\":107,\"story_count\":293},{\"null\":33,\"comic_count\":61,\"description\":\"Empowered by the enigmatic Professor's secret formula, high school student Robert Reynolds became a superhuman.\",\"event_count\":7,\"id\":1009571,\"name\":\"Sentry (Robert Reynolds)\",\"series_count\":26,\"story_count\":58},{\"null\":34,\"comic_count\":353,\"description\":\"When Zenn-La was threatened by the world-devouring entity known as Galactus, Norrin Radd stood up for his home planet and offered to work for Galactus, finding him new planets to eat, in exchange for saving his own. Years later, the Surfer has protected Earth and many other planets, becoming one of the greatest heroes in the universe.\",\"event_count\":12,\"id\":1009592,\"name\":\"Silver Surfer\",\"series_count\":92,\"story_count\":517},{\"null\":35,\"comic_count\":2575,\"description\":\"Bitten by a radioactive spider, high school student Peter Parker gained the speed, strength and powers of a spider. Adopting the name Spider-Man, Peter hoped to start a career using his new abilities. Taught that with great power comes great responsibility, Spidey has vowed to use his powers to help people.\",\"event_count\":29,\"id\":1009610,\"name\":\"Spider-Man\",\"series_count\":531,\"story_count\":4165},{\"null\":36,\"comic_count\":95,\"description\":\"When young Jessica Drew suffered uranium poisoning in 1931, her father was forced to inject her with his untested spider serum and seal her in a genetic accelerator.\",\"event_count\":7,\"id\":1009608,\"name\":\"Spider-Woman (Jessica Drew)\",\"series_count\":37,\"story_count\":90},{\"null\":37,\"comic_count\":598,\"description\":\"Ororo Monroe is the descendant of an ancient line of African priestesses, all of whom have white hair, blue eyes, and the potential to wield magic.\",\"event_count\":21,\"id\":1009629,\"name\":\"Storm\",\"series_count\":152,\"story_count\":692},{\"null\":38,\"comic_count\":537,\"description\":\"Prince Namor is the half-human\\/half-Atlantean ruler of Atlantis.\",\"event_count\":15,\"id\":1010791,\"name\":\"Sub-Mariner\",\"series_count\":160,\"story_count\":725},{\"null\":39,\"comic_count\":19,\"description\":\"Tyros was once the dictator of the city Lanlak on the planet Birj, where his superhuman ability to command rocks and earth enabled him to overcome all resistance, but his rule of Lanlak came to an end when he was sought by the world-devouring Galactus to serve as his latest Herald.\",\"event_count\":0,\"id\":1009651,\"name\":\"Terrax\",\"series_count\":13,\"story_count\":14},{\"null\":40,\"comic_count\":413,\"description\":\"The radiation that mutated Reed Richards, Sue Storm and Johnny Storm into superhuman beings had also mutated Ben Grimm, transforming him into a grotesque, rock-hided strongman dubbed the Thing.\",\"event_count\":20,\"id\":1009662,\"name\":\"Thing\",\"series_count\":168,\"story_count\":481},{\"null\":41,\"comic_count\":1240,\"description\":\"As the Norse God of thunder and lightning, Thor wields one of the greatest weapons ever made, the enchanted hammer Mjolnir.\\r\\nWhile others have described Thor as an over-muscled, oafish imbecile, he's quite smart and compassionate. He's self-assured, and he would never, ever stop fighting for a worthwhile cause.\\r\\n\\r\\n\",\"event_count\":21,\"id\":1009664,\"name\":\"Thor\",\"series_count\":302,\"story_count\":1948},{\"null\":42,\"comic_count\":30,\"description\":\"Uatu grew so fond of the lifeforms he observed that he occasionally violated his vow of non-interference when Earth's existence was threatened.\",\"event_count\":1,\"id\":1009683,\"name\":\"Uatu The Watcher\",\"series_count\":10,\"story_count\":31},{\"null\":43,\"comic_count\":268,\"description\":\"The metal monstrosity called Ultron created the synthetic humanoid known as the Vision from the remains of the original android Human Torch of the 1940s to serve as a vehicle of vengeance against the Avengers.\",\"event_count\":11,\"id\":1009697,\"name\":\"Vision\",\"series_count\":93,\"story_count\":302},{\"null\":44,\"comic_count\":234,\"description\":\"When Janet Van Dyne's father died, she convinced her father's associate Hank Pym to give her a supply of \\\"Pym particles\\\"; Pym also subjected her to a procedure which granted her the ability to, upon shrinking, grow wings and fire blasts of energy, which she called her \\\"wasp's stings.\\\"\",\"event_count\":11,\"id\":1009707,\"name\":\"Wasp\",\"series_count\":105,\"story_count\":251},{\"null\":45,\"comic_count\":3,\"description\":\"William Stryker became convinced that Satan had a plot to corrupt humankind by taking over their souls while still in the womb, resulting in their mutations.\",\"event_count\":0,\"id\":1009633,\"name\":\"William Stryker\",\"series_count\":1,\"story_count\":4},{\"null\":46,\"comic_count\":1794,\"description\":\"Born with super-human senses and the power to heal from almost any wound, Wolverine was captured by a secret Canadian organization and given an unbreakable skeleton and claws. Treated like an animal, it took years for him to control himself. Now, he's a premiere member of both the X-Men and the Avengers.\",\"event_count\":32,\"id\":1009718,\"name\":\"Wolverine\",\"series_count\":436,\"story_count\":2445},{\"null\":47,\"comic_count\":2531,\"description\":\"Feared and hated by humans because they're different, the X-Men are heroic mutants, individuals born with special powers who've sworn to use their gifts to protect mutants as well as humans.\",\"event_count\":34,\"id\":1009726,\"name\":\"X-Men\",\"series_count\":469,\"story_count\":3781}], [{\"field\": null, \"type\": \"Integer\"}, {\"field\": \"comic_count\", \"type\": \"Integer\"}, {\"field\": \"description\"}, {\"field\": \"event_count\", \"type\": \"Integer\"}, {\"field\": \"id\", \"type\": \"Integer\"}, {\"field\": \"name\"}, {\"field\": \"series_count\", \"type\": \"Integer\"}, {\"field\": \"story_count\", \"type\": \"Integer\"}]);\n",
" grid.initialize_slick_grid();\n",
" });\n",
" });\n",
"});"
],
"metadata": {},
"output_type": "display_data"
}
],
"prompt_number": 14
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"# For quick and dirty exploratory analysis, I usually start with Pandas native plotting functionality\n",
"hero_df['comic_count'].plot(kind='bar')"
],
"language": "python",
"metadata": {},
"outputs": [
{
"metadata": {},
"output_type": "pyout",
"prompt_number": 30,
"text": [
""
]
},
{
"metadata": {},
"output_type": "display_data",
"png": "iVBORw0KGgoAAAANSUhEUgAAAXoAAAEDCAYAAAA7jc+ZAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAHZ9JREFUeJzt3XuUVeWd5vFvIXKLRXUugtO2A2vG2b+YgGktTSIaRduo\nSciixyTqaBgl43VolkqybCFecvGajKaFENMjsfHe3TK2SeOSYNSRi0al2miz1F9JnKqoK2g0yEUN\nBXLmj/c9eDicS3GqTtU5bz2ftVics999efe79372Pu/e51RLLpdDRETSNWywKyAiIvWloBcRSZyC\nXkQkcQp6EZHEKehFRBKnoBcRSdzwSoVmthdwC5ABOeB8YCuwGNgBrAVmuXvOzM4BzgW2A1e5+wNm\nNhq4E9gX2Ayc6e5v1mldRESkhGpX9NOAHe5+FHAZcA1wAzDP3Y8GWoDpZrYfMBuYApwIXGtmI4AL\ngGfjuLfHeYiIyACqGPTu/nPgvPh2IrABaHf3FXHYg8DxwOHAanff5u6bgHXAwcCRwLI47rI4roiI\nDKCqffTu/r6ZLQZuAu4iXMXnbQbagLHAxjLDNxUNExGRAVSxjz7P3c8ys/HAU8CogqKxwNuEMG8t\nGN5aYnh+WEUdHR36TQYRkRq0t7e3lCzI5XJl/2VZNiPLsrnx9dgsy17OsuyXWZYdE4f9NMuyr2VZ\nNj7LsueyLBuZZVlblmUvxNdzsiy7Mo57WpZlCystL5fLsWbNmlxe4etiKlOZyupX1ij1UFnvy+L7\nkrla7Yp+CbDYzB4D9gYuBF4Ebok3W58HlsSnbuYDKwndQfPcfauZ3QzcZmYrCU/rnN4vpy0REem1\nikHv7u8Bp5Yomlpi3EXAohLTn9KH+omISB/pC1MiIolT0IuIJE5BLyKSOAW9iEjiFPQiIolT0IuI\nJE5BLyKSOAW9iEjiFPQiIolT0IuIJE5BLyKSOAW9iEjiFPQiIolT0IuIJE5BLyKSOAW9iEjiFPQi\nIolT0IuIJE5BLyKSOAW9iEjiFPQiIolT0IuIJE5BLyKSOAW9iEjiFPQiIolT0IuIJE5BLyKSOAW9\niNRVT08PnZ2ddHd309nZSU9Pz2BXachR0ItIXXV1dTFj7t0sWLqeGXPvpqura7CrNOQMr1RoZnsD\ntwITgJHAVcCrwFKgM472E3e/18zOAc4FtgNXufsDZjYauBPYF9gMnOnub9ZlTUSkYY1pG8c+H95/\nsKsxZFUMeuAM4A/uPsPMPgw8C3wXuMHdb8yPZGb7AbOBdmA0sMrMHgIuAJ519++Z2anAZcBFdVgP\nEZHk9fT07PxE1N3dTWtrKxMnTmTEiBEVp6sW9PcCS+LrYcA2QpibmU0HXiIE96eB1e6+DdhmZuuA\ng4Ejgevj9MuAy/dwvUREJMp3g41pGwfAu3c9xx3Xnk6WZRWnqxj07v4OgJm1EkL/28Ao4BZ3f8bM\n5gFXAr8BNhZMuhloA8YCm4qGiYhIjWrpBmvJ5XIVRzCzA4D7gIXuvtjM2tx9Yyw7CFgA3ASc5O6z\n4vD7gKuBecB17v60mbUBq9x9cqXldXR0VK6QiDSV7u5uFixdzz4f3p8tG15j9rT9mDBhwmBXqykV\ntiWwW3u2t7e3lJwwl8uV/Zdl2fgsy17IsuzYgmFPZFl2eHw9O8uy6+J4z2VZNjLLsrY4zcgsy+Zk\nWXZlHPe0LMsWVlpeLpdjzZo1ubzC18VUpjKV1a+sP+fn7rmpMxfmps25Pzd15sKcu9d1eSmXFbZl\ncXvGcUvmarU++nmE7pYrzOyKOOwi4Edmtg34PXCuu28xs/nASkJf/jx332pmNwO3mdlKYCtwel/O\nZiIisueq9dFfCFxYouioEuMuAhYVDXsPOKUvFRQRkb7RF6ZERBKnoBcRSZyCXkQkcQp6EZHEKehF\nRBKnoBcRSZyCXkQkcQp6EZHEKehFRBKnoBcRSZyCXkQkcQp6EZHEKehFRBKnoBcRSZyCXkQkcQp6\nEZHEKehFRBKnoBcRSZyCXkQkcQp6EZHEKehFRBKnoBcRSZyCXkQkcQp6EZHEKehFRBKnoBcRSZyC\nXkQkcQp6EZHEKehFRBKnoBcRSdzwSoVmtjdwKzABGAlcBbwALAZ2AGuBWe6eM7NzgHOB7cBV7v6A\nmY0G7gT2BTYDZ7r7m3VaF2liPT09dHV1AdDd3U1raysTJ05kxIgRg1sxkQRUu6I/A/iDux8NnAQs\nBG4A5sVhLcB0M9sPmA1MAU4ErjWzEcAFwLNx3NuBy+qzGtLsurq6mDH3bs677lcsWLqeGXPv3hn8\nItI3Fa/ogXuBJfH1MGAbcKi7r4jDHgROAN4HVrv7NmCbma0DDgaOBK6P4y4DLu/HuktixrSNY58P\n7z/Y1RBJTksul6s6kpm1Aj8HbgH+l7vvH4cfC3yDEOKT3f3SOPw2whX8pcBsd3/RzIYB3e5+QKVl\ndXR0VK+QJKe7u5sFS9fvDPotG15j9rT9mDBhwiDXTPqqcNtqu/ZNteOkvb29peSEuVyu4r8syw7I\nsuzpLMvOiu9fKSibnmXZgizLvpxl2cKC4fdlWdaeZdn/ybLs8DisLcuyf6+2vDVr1uTyCl8XU1la\nZe6emzpzYW7anPtz0+bcn5s6c2HO3RuunkOlrD/nV7httV37VlbpOInjlszVin30ZjYeWA5c4u6L\n4+BnzOyY+PoLwArgKeBzZjbSzNqAgwg3alcDXywaV0REBlC1Pvp5QBtwhZldEYddCMyPN1ufB5bE\np27mAysJffnz3H2rmd0M3GZmK4GtwOl1WQsRESmrYtC7+4WEYC82tcS4i4BFRcPeA07pQ/1ERKSP\n9IUpEZHEKehFRBKnoBcRSZyCXkQkcQp6EZHEKehFRBKnoBcRSZyCXkQkcQp6EZHEKehFRBJX7bdu\nRERkANXjr60p6EVEGkj+r62NaRsHwLt3Pccd155OlmU1z1NBLyLSYPr7r62pj15EJHEKehGRxCno\nRUQSp6AXEUmcgl5EJHEKehGRxCnoRUQSp6AXEUmcgl5EJHEKehGRxCnoRUQSp6AXEUmcgl5EJHEK\nehGRxCnoRUQSp6AXEUlcr/7wiJl9BrjO3Y81s0OAfwVeisU/cfd7zewc4FxgO3CVuz9gZqOBO4F9\ngc3Ame7+Zr+vhYiIlFU16M3sEuDrwJY4qB240d1vLBhnP2B2LBsNrDKzh4ALgGfd/XtmdipwGXBR\n/66CiIhU0psr+nXAycAd8X07kJnZdMJV/UXAp4HV7r4N2GZm64CDgSOB6+N0y4DL+7HuIiLSC1X7\n6N39PkJ3TN6TwLfc/RjgZeBKoBXYWDDOZqANGAtsKhomIiIDqCWXy1UdycwmAve4+xFm1ubuG+Pw\ng4AFwE3ASe4+Kw6/D7gamEfo23/azNqAVe4+udKyOjo6qldIktPd3c2Cpet3/kHkLRteY/a0/Zgw\nYcIg10z6qnDbartWV+lYqHactLe3t5ScaS6Xq/ovy7KJWZY9EV8/kWXZ4fH17CzLrsuybHyWZc9l\nWTYyy7K2LMteiK/nZFl2ZRz3tCzLFlZb1po1a3J5ha+LqSytMnfPTZ25MDdtzv25aXPuz02duTDn\n7g1Xz6FS1p/zK9y22q7VyyodC5XK4nxK5mqvnrrJnxPi/+cDC81sG/B74Fx332Jm84GVhO6gee6+\n1cxuBm4zs5XAVuD0PTy5iYhIH/Uq6N29C5gSXz8LHFVinEXAoqJh7wGn9LmWIiJSsz25om9aPT09\ndHV1AaH/q7W1lYkTJzJixIjBrZiIyAAYEkHf1dXFjLl3M6ZtHADv3vUcd1x7OlmWDXLNRETqb0gE\nPcCYtnE771SLiAwl+q0bEZHEKehFRBKnoBcRSZyCXkQkcQp6EZHEKehFRBI3ZB6vlIGhL6eJNB4F\nvfQrfTlNpPEo6KXf6ctpIo1FffQiIolT0IuIJE5BLyJCeJCgs7OT7u5uOjs76enpGewq9RsFvYgI\nHzxIsGDpembMvXvn02Mp0M1YEZEo1QcJdEUvIpI4Bb2ISOIU9CIiiVPQi4gkTkEvIpI4Bb2ISOIU\n9CIiiVPQi4gkTkEvIpI4fTM2AfpjHyJSiYI+AfpjHyJSiYI+Ean+RoeI9F2vgt7MPgNc5+7HmtmB\nwGJgB7AWmOXuOTM7BzgX2A5c5e4PmNlo4E5gX2AzcKa7v1mH9RARkTKq3ow1s0uAW4CRcdCNwDx3\nPxpoAaab2X7AbGAKcCJwrZmNAC4Ano3j3g5c1v+rICIilfTmqZt1wMmEUAc41N1XxNcPAscDhwOr\n3X2bu2+K0xwMHAksi+Mui+OKiMgAqhr07n4foTsmr6Xg9WagDRgLbCwzfFPRMBERGUAtuVyu6khm\nNhG4x92PMLNX3P2AOHw64Sp9OXCSu8+Kw+8DrgbmEfr2nzazNmCVu0+utKyOjo7qFdpD3d3dLFi6\nfufNyi0bXmP2tP2YMGFCfy9qUDTS+tVal0ZaB+lfhdu2kbdro9Sz0rFQ7Thpb29vKTXPWp66ecbM\njnH3x4AvAA8DTwFXm9lIYBRwEOFG7Wrgi8DTcdwVpWe5q8mTJ9PV1cXatWuZNGlSyWfCOzo6aG9v\nLzl9cVlrayssXb/LOJMmTdrt8cM9mWcjlTXS+tVal0ZaB5X17/yKt22jbtdGqWelY6FSWUdHR8n5\nw559MzZ/pf1N4Ltm9jjhRLHE3V8H5gMrCcE/z923AjcDnzSzlcDZwHd7s6CU/3ajiMhA69UVvbt3\nEZ6owd1fAqaWGGcRsKho2HvAKbVUTM+Fi4j0D/3WjYhI4hT0IiKJU9CLiCROQS8ikjgFvYhI4hT0\nIiKJU9CLiCROQS8ikjj94ZE60J/2E5FGoqCvA/1pPxFpJAr6OtFPOIhIo1AfvYhI4hT0IiKJU9CL\niCROQS8ikjgFvYhI4hT0IiKJ0+OVNdKXokSkWSjoa6QvRYlIs1DQ94G+FCUizUB99CIiiVPQi4gk\nTkEvIpI4Bb2ISOIU9CIiiVPQi0hD6unpobOzk+7ubjo7O+np6RnsKjUtBb2INKT8d1UWLF3PjLl3\n7/yCouw5PUcvIg1L31XpHwr6CvQzByKSgpqD3sz+DdgY374MXAssBnYAa4FZ7p4zs3OAc4HtwFXu\n/kCfajyA9DMHIo0pfxGmC7DeqSnozWwUgLsfWzDsF8A8d19hZjcD083s18BsoB0YDawys4fcvWnu\nquijo0jjKbwI0wVYdbVe0X8KGGNmv4zz+DZwqLuviOUPAicA7wOr3X0bsM3M1gEHA2v6Vm0RGep0\nEdZ7tT518w7wQ3c/ETgfuKuofDPQBozlg+6dwuEiIjJAar2i7wTWAbj7S2b2FnBIQflY4G1gE9Ba\nMLwV2FBt5mvXrt3t/ebNm3cbr6Ojo+w8Csu6u7tLLqPaPCtNV2tZretQaz3rsbx61KWR1kFl/Tu/\n4m3b2+1aabpa51mPevZ3WX9lS6Fag34moQtmlpn9OSHAl5vZMe7+GPAF4GHgKeBqMxsJjAIOItyo\nrWjSpEmwdP0u74v73zo6Omhvby85fXFZa2vrLvPr7TwrTVdrWa3rUI/1a6S6NNI6qKx/51e8bXu7\nXStNV+s861HP/i6rNVsqnUhqDfqfAf9gZvk++ZnAW8AtZjYCeB5YEp+6mQ+sJHQTzWumG7EiIimo\nKejdfTswo0TR1BLjLgIW1bIcERHpO/0EgohI4vTN2Aaib+KK1NdQ/aKVgr6B6Ju4IvU1VL9opaBv\nMPoSiEh9DcVjTH30IiKJU9CLiCROQS8ifaa/BtXYmi7otUOJNB79NajG1nQ3Y/v7rrkeaRTpH0Px\nJmezaLqgh/7dofRIo4ikrimDvr+lfCWiTywiklTQD9VvvVWiTyyNofiEO3ny5CG/b8rASSroh+q3\n3qpJ+RNLs9hl39z4RsmfwJXm0yyfmJMKelCoSeNqhn1Tn4r3TLN8Yk4u6EUGSwrdM/pUvOea4QSu\noB/CmuVjZ7NIpXumGYKrGTTS8aWgbxL12GkqfexspJ20mSgkJa+RunUU9E2iXjtNuWBqpJ1UpFk1\nyolfQd9EBnqnaZSddKCl0NcuUkhBL1Iklb52kTwFvUgJQ/XTjKRJQS/J0g1lkUBBL8nSDWWRQEEv\nA2YwrrCboQtGN3+l3hT0MmBSuMKuRyjX4+avTh5SSEEvA6oZrrArqdcTOf3dLs3y5JB+W2dgKOhF\n9lCznKyaoZ76bZ2BoaAfYHoSZM+pzdLWDCekZqegH2Ap9lPXO3jr0Wbqw95z6mZpXnUPejMbBvwE\nOBjYCpzt7r+t93IbWbNfwQzGyapcm9V60mm2PmwY/BOSulma10Bc0f81MMLdp5jZZ4Ab4jBpYo1y\nsurLSadR1qGSRjshNUOb1UOzf5oZiKA/ElgG4O5PmtlhA7BMGUJSD5/efprp7dV+I31KqId6hHKz\nf5oZiKAfC2wqeP++mQ1z9x3lJjjuuOP4w4YttAzbi9yO9zlu+TW8+uqrO8vf3fjGzv+PO+44hg8P\nq7F9+/ad033qhNm7zDM/zRP3Xr5znsOHD985zZRTr9llvLzH/2keLcP2AthluuXLl+8ybv71xIkT\nd6lHfjouPX63cfPzL65Ly7C9OOJr39+tLu9ufIMn7r18t7ps376d/T9zdsn5F7Zl4XT59ixeh3x7\nFq9Dyu1ZWA9gl/YsnqbUvjl8+PCdwVm4b+brn59n4XSF9S8cv7D+hdNNOfWa3erS1dXFpE8dRkvL\nMHK5HYz76Nid0xW2Z+F0+fZ8461Nu0zX1+Orkdqzq6uLr876O0bt8xF+s+ysXdqlUnvm27+4Lvn2\nLKXW4ytfFwgnplWrVu1y4qj1+CqnJZfL9WrEWpnZDcCv3f3e+P4Vdz+g3PgdHR31rZCISKLa29tb\nSg0fiCv61cCXgXvN7LPAc5VGLldRERGpzUAE/b8Anzez1fH9zAFYpoiIRHXvuhERkcE1bLArICIi\n9aWgFxFJnIJeRCRxCvp+ZGZjB7sOIiLFGjLo4+/j9HUeo0oMG21mI8uMP75cXcxs/3J1MrOPmVn+\nkdDXzezsUuOVmG6EmY0uGjbWzP5DuTqKiNSiYZ66MbP/TPgdnMOA9wknoeeAi4G/B0YCxc/Y54Br\ngR8D24Fvu/s/xvk9CvwNcDWwAbgbuAXYAVwIeMF8WoDbgP8e3/+tu/+P+Ns8dwFvEb7hOxMw4D8B\nv4hlfwI+BPxP4PvAGuCTwHfc/bGC9bNYlx5gQVze3sBc4AXgVmB/YF+gE/g9cA7wMjAdOB5oA94G\nVgBLgDtj3YvbZQTQBbwH/Mjd34p1+I67f4cBZGZ3Axe7++v9OM8WyrfJuYT9otS+cj/wt5RoF8K2\n+3Kc13PAjYT9cF5x3c3sRnefE1+f4u7/bGb7AFcChxD2gauAjwGTgEficg8D1gLXADdTpl3i+n2J\nsK88Rjgu/gyYB6wn7GvHEPa7N4FfArfHydUuA9AuzXYcNVLQPwpc6u5PFgz7LGFjziGE9MmEQC/0\nT8BJhBPDvcDt7r44zm84cBkwEZgPZISNtgw4AHiHEKgAfwn8Jj9Tdz/WzB4Gznf3l8zsz4F/BEYD\nU4F/jWWdsewXwOY43WGEnS8DHgZ+C3wV+B5hR/v7uLwNsXwrcE6c12cJP/q2BPgB8CJhJ3wQ2AK0\nAl+I6/YA4eC4oKhNrgd+RjiRzAK+6O5dsU2OZ2AP3Gfjes4HFrt7rmD+tR64Cyu0yea4fnewuyOA\n+8q0S1ccZz/go3EbbQG+Ht/DB2HwCeB5Qhhsjdt8EeGkfD/wV3FZfwFcAZwB/I6wzxwDnEC4GCjX\nLj8jXNi0AuPiuvweOB94Lf57PK7n67F+ubheapeBaZeGOY56o5GC/nF3n1Ji+Gp3P9LMLgHWuft9\nReUr3P3o+LqV0EiXEHakvd39qFi22N3Piq8fA75G2GlvdvflZvaoux8byx+NO+kv3f3EwmUBw+Mv\ncd4PfNXdt8eyp4B38vOIw/4MOJoQ+H/t7kfFcHvR3S2OsxLYq3DdzWylu3/OzB4HtufXr1R7mdlN\nwGp3/+eCssJ1mUK4SppK2Gm74mgDdeCOAf4r4SR3HOFT0INxHj+itgP3kCpt8iBwpbs/VVReqV32\njttnBLDW3bM43iPAIuAbwEWxre4BTovt9A+xXR5z92MKlwUMc/djzOwhd/98QdlqwsmtXLs8ELd/\nC/C8ux8Up/u/hH3lcwXz+pW7H29mTwDb1C4D1i5dcbRBP47cvfC3xEpqpKD/KaHLYRnhR9BagS8C\nf3L34ivWwunuAP4AXOHuW8zsAGA54cp5GaGr5jx3fz+OPxf4S3c/1cz2Bn4Yp/+8u0+N4/xbnP2Y\nWH4X4WpzLGGDHQH8O9Ael3US8Axh57utTD1vJVyZtgGjCD8NsQn4LOGq4t1Y32lx+COELqbRhKuE\nFQXzOgb4br6+JZa1Avgbd38uvj+VcEWyD/DuQB+4BQfLOMInm78idIFtqPHAzV85lWwTM/sY8CF3\n7y4oHwk8VKldCJ8oV5nZf3T335nZgYSrp6PM7BBC19scwsVBfp1eI+wbXwK+5e7PmNnhhJPYW4ST\n1wHAHwmf+r5E6CLcu0K7vE24wvsocBPwOcI+soQQFhe7+6/N7GhC198ZwK/iOlRrl33iVeloYIe7\nb622vzRAuxxPuFiqV7vsG/eXLjMb5+5vxHEa/Tg6HsjcfRJVNFLQDyN0WRzJB794uRr4l0ofU2JY\nnwHc6+7vxGHjCR//5wDT3P3nBePPAJa4+3sFw84CZhY1/CjgU4TunU5C//zP3H27mU0lnGX3JXQp\nrHL3B3qxficQuo5WEz51fIhwInmX0B//CUL30a3Apwn3ET5C+Fh4KGFH2UE4qXwT+N+UvncxmnBQ\nnObu6+Pyv044OF6gtgP31ViPPT1w/+jup5Vpk1XUduCeQgiRQwlddvk2uQyYQPl7NhfH+p7m8eN1\nbJf5wFGxLl/J729m9gvgOnd/PL7/SNw2B7r7pLiPHBTr0Q48RfjJj2WEg/z/EbrRjiR0H74FrIrb\n7np3/28l2mRUHPdKwr7yY8K9mDGEkHmV0I35F4Qrwm8QLg46Cd18N8S6tBAuKNYQ7lWNoPz9qleA\nvwNOdffXzWwM8JU47HNxupPdPRfL7idcAT8R6/xRQlfhZOAT8eRxSFG7LCdcCZ9H+NRW2C4bCH3m\nu7VLXN4Od/+TmX28qF2WEPb1GYSLtVsI++DLhO7MaYRulRfZ9RjaN26jb7LrsVN8r25MUbuMBz5P\n346jWk+AbxW1y3jfg/76hgl62XMWbhaXvHfh7l0lxh8GfJywA37F409Fx0C7tsSBe2D+aiHuuO3x\n35N8EGjnEw7cHwBTKAo0d/9dhfp/HPgO4cBdwAeBdjbhwF3EB4E2kw8CrYXQT78NuMzd74nzezRO\nX+6ezY0F0xWeBFYQTrilyvLT/TiWXQG85O5PV5lncVlhPR8hHNilTkj5sj2dZ/7hg2sIwXlXbL/3\nCWF+CeXvV50Tp/sju54ELiLcXypVdmHcLvmTxz3Azwn7QmHZ27EuxdOVq2fhPPPLez/Wpdp0hWXF\nD17kA70wzHOEe2Tl7tWdF8fPFU2X/42wncdRPAncQunj6JPu/l/isPxxdCjhBPgg4cRZ6jjaTrgP\n903CCS0f1ruckNy9kyoU9A0uHsAlnziK/Yu73buoNk0vlzsMaHf3p2uvff/UpcQ8n6R8mO/l5e/Z\nVDoJpFBW+PDBTYRuoHyY7/Dy96uGUf4k8H4vy4qX1x9l/VWXSg9enEr5e3WvlJkuRwjm4pPAmXwQ\nxnl7Ez5VHFQwrPBYKJ6u+IQ0I77Pd0Httg5ecF+wHP1x8MZ3KeWfOMLdf7An01QKXsLTP7uUmVnZ\nskrTFZRd3F91KSxz9w1xHtOBR8ws3x/fbWY3Eu7ZbDazk/ngns26CtNVmmezlLV4eKT3MTM7tqB7\nahvwWws3AM8rCPm5hKeb9q8w3V4JlLVTJszjOKcAP4xdKIX7W9npSpwEDPhpfH1gUdmmOJ9SZZWm\nywqmO6zSOlSjK/omUOqqvdZpKnX3AOP7u8zDDa7+rsv3KX8DfgLl79l8pMJ0DydQVvbhA+B0ytyv\nInQFlZvunWYv8woPXhSy0vfqyj2wMY7yJ4F+L6tUl95Q0A9BlU4c9Sjr77pYhRvw7n5hhWVVunH/\nrQTKevXwQYl22avcdITHHZu6zKs8eNEbe3ISqFdZX9ZBQS8i0geVgrceZbVQ0IuIJK4hf9RMRET6\nj4JeRCRxCnoRkcQp6EVEEvf/Ae/d4hoMrIQmAAAAAElFTkSuQmCC\n",
"text": [
""
]
}
],
"prompt_number": 30
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"top_10 = hero_df.sort('comic_count', ascending=False)[['name', 'comic_count']][:10]\n",
"qgrid.show_grid(top_10, remote_js=True)"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"\n",
"