Exercises-2.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "%matplotlib inline\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style>body {\n",
       "    margin: 0;\n",
       "    font-family: Helvetica;\n",
       "}\n",
       "table.dataframe {\n",
       "    border-collapse: collapse;\n",
       "    border: none;\n",
       "}\n",
       "table.dataframe tr {\n",
       "    border: none;\n",
       "}\n",
       "table.dataframe td, table.dataframe th {\n",
       "    margin: 0;\n",
       "    border: 1px solid white;\n",
       "    padding-left: 0.25em;\n",
       "    padding-right: 0.25em;\n",
       "}\n",
       "table.dataframe th:not(:empty) {\n",
       "    background-color: #fec;\n",
       "    text-align: left;\n",
       "    font-weight: normal;\n",
       "}\n",
       "table.dataframe tr:nth-child(2) th:empty {\n",
       "    border-left: none;\n",
       "    border-right: 1px dashed #888;\n",
       "}\n",
       "table.dataframe td {\n",
       "    border: 2px solid #ccf;\n",
       "    background-color: #f4f4ff;\n",
       "}\n",
       "h3 {\n",
       "    color: white;\n",
       "    background-color: black;\n",
       "    padding: 0.5em;\n",
       "}\n",
       "</style>"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from IPython.core.display import HTML\n",
    "css = open('style-table.css').read() + open('style-notebook.css').read()\n",
    "HTML('<style>{}</style>'.format(css))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>title</th>\n",
       "      <th>year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>The Rising Son</td>\n",
       "      <td>1990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>The Thousand Plane Raid</td>\n",
       "      <td>1969</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Crucea de piatra</td>\n",
       "      <td>1993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>The 86</td>\n",
       "      <td>2015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Gaiking II</td>\n",
       "      <td>2011</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     title  year\n",
       "0           The Rising Son  1990\n",
       "1  The Thousand Plane Raid  1969\n",
       "2         Crucea de piatra  1993\n",
       "3                   The 86  2015\n",
       "4               Gaiking II  2011"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "titles = pd.DataFrame.from_csv('data/titles.csv', index_col=None)\n",
    "titles.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>title</th>\n",
       "      <th>year</th>\n",
       "      <th>name</th>\n",
       "      <th>type</th>\n",
       "      <th>character</th>\n",
       "      <th>n</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Suuri illusioni</td>\n",
       "      <td>1985</td>\n",
       "      <td>Homo $</td>\n",
       "      <td>actor</td>\n",
       "      <td>Guests</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Gangsta Rap: The Glockumentary</td>\n",
       "      <td>2007</td>\n",
       "      <td>Too $hort</td>\n",
       "      <td>actor</td>\n",
       "      <td>Himself</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Menace II Society</td>\n",
       "      <td>1993</td>\n",
       "      <td>Too $hort</td>\n",
       "      <td>actor</td>\n",
       "      <td>Lew-Loc</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Porndogs: The Adventures of Sadie</td>\n",
       "      <td>2009</td>\n",
       "      <td>Too $hort</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bosco</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Stop Pepper Palmer</td>\n",
       "      <td>2014</td>\n",
       "      <td>Too $hort</td>\n",
       "      <td>actor</td>\n",
       "      <td>Himself</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                               title  year       name   type character   n\n",
       "0                    Suuri illusioni  1985     Homo $  actor    Guests  22\n",
       "1     Gangsta Rap: The Glockumentary  2007  Too $hort  actor   Himself NaN\n",
       "2                  Menace II Society  1993  Too $hort  actor   Lew-Loc  27\n",
       "3  Porndogs: The Adventures of Sadie  2009  Too $hort  actor     Bosco   3\n",
       "4                 Stop Pepper Palmer  2014  Too $hort  actor   Himself NaN"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cast = pd.DataFrame.from_csv('data/cast.csv', index_col=None)\n",
    "cast.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "### What are the ten most common movie names of all time?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Hamlet                  19\n",
       "Macbeth                 14\n",
       "Carmen                  14\n",
       "The Three Musketeers    12\n",
       "Blood Money             11\n",
       "She                     11\n",
       "Maya                    11\n",
       "The Outsider            11\n",
       "Eva                     10\n",
       "Karma                   10\n",
       "dtype: int64"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "titles.title.value_counts().head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "### Which three years of the 1930s saw the most films released?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Int64Index([1937, 1936, 1938], dtype='int64')"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "s=titles[(titles.year >= 1930) & (titles.year <= 1939)].year.value_counts()\n",
    "s.index[0:3]\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "### Plot the number of films that have been released each decade over the history of cinema."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x10889eb8>"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAX8AAAEOCAYAAABhOhcDAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAGTlJREFUeJzt3X+Q3PV93/HnCwRYxSqqChW/Qa1FQS6ubWrkpA4+Aiaa\nTgaUCQWRlgpHTT2oLmnSppGYNpw7GRvqSShOK6Y/IAhsK2iMDbhgIUG5pHUqBFgEGVlBJBaWBBJE\nxoBtbEvm1T++H6HlOOn2bnd1t/d5PWZ27ruf7/f73s/e7b72u5/vZ/dkm4iIqMsRE92BiIg4/BL+\nEREVSvhHRFQo4R8RUaGEf0REhRL+EREVaiv8Jc2U9CVJ35K0WdJ8SbMkrZP0rKS1kma2bL9c0lZJ\nWyRd0tJ+nqRNZd0tLe3HSLq7tK+XdEZ372ZERLRq98j/FuBB2+cA7wO2AMuAdbbPAh4p15E0D7gS\nmAcsAFZIUqlzK7DE9lxgrqQFpX0JsKe03wzc1PE9i4iIgxo1/CUdB/yc7dsBbO+z/SpwKbCybLYS\nWFiWLwNW2d5rexvwHDBf0knADNsbynZ3tuzTWuse4KKO7lVERBxSO0f+c4CXJf2hpG9I+h+SjgVm\n295dttkNzC7LJwM7WvbfAZwyQvvO0k75uR2aFxfgVUmzxnOHIiJidO2E/zTgg8AK2x8EfkAZ4tnP\nzXdE5HsiIiL6xLQ2ttkB7LD9eLn+JWA5sEvSibZ3lSGdl8r6ncBpLfufWmrsLMvD2/fvczrwgqRp\nwHG2v9vaCUl5cYmIGAfbGt426pG/7V3AdklnlaaLgWeArwKLS9ti4N6yfD+wSNLRkuYAc4ENpc5r\nZaaQgKuB+1r22V/rcpoTyCP1pe3LDTfcMKbtx3pJ/Ymr3899T/3UP9z1D6adI3+AfwV8QdLRwF8A\nHweOBFZLWgJsA64oAb1Z0mpgM7APWOoDPVgK3AFMp5k9tKa03wbcJWkrsAdY1Ga/IiJiHNoKf9t/\nBnxohFUXH2T7TwOfHqH9SeDcEdp/THnxiIiI3puyn/AdGBhI/Slav5/7nvqpP1nq61BjQpOJJPdL\nXyMiJgtJeDwnfCMiYupJ+EdEVCjhHxFRoYR/RESFEv4RERVK+EdEVKjdT/hGRESLA/+mpH2Tabp6\nwj8iYtzGEuZjf7HopQz7RERUKOEfEVGhhH9ERIUS/hERFUr4R0RUKOEfEVGhhH9ERIUS/hERFUr4\nR0RUKOEfEVGhhH9ERIUS/hERFUr4R0RUKOEfEVGhhH9ERIUS/hERFUr4R0RUKOEfEVGhtsJf0jZJ\nT0vaKGlDaZslaZ2kZyWtlTSzZfvlkrZK2iLpkpb28yRtKutuaWk/RtLdpX29pDO6eScjIuLt2j3y\nNzBg+wO2zy9ty4B1ts8CHinXkTQPuBKYBywAVujAfzq+FVhiey4wV9KC0r4E2FPabwZu6vB+RUTE\nIYxl2Gf4fx++FFhZllcCC8vyZcAq23ttbwOeA+ZLOgmYYXtD2e7Oln1aa90DXDSGfkVExBiN5cj/\nYUlPSPq10jbb9u6yvBuYXZZPBna07LsDOGWE9p2lnfJzO4DtfcCrkmaN5Y5ERET7prW53T+0/aKk\nE4B1kra0rrRtSe5+9yIiohfaCn/bL5afL0v6CnA+sFvSibZ3lSGdl8rmO4HTWnY/leaIf2dZHt6+\nf5/TgRckTQOOs/3d4f0YHBx8a3lgYICBgYF2uh8RUY2hoSGGhoZG3U72oQ/YJf014Ejbr0s6FlgL\nfAq4mOYk7U2SlgEzbS8rJ3y/SPMCcQrwMPCe8u7gMeA6YAPwAPA522skLQXOtX2tpEXAQtuLhvXD\no/U1IuJwaeaxjCWTxERkmCRsDz9n29aR/2zgK2XCzjTgC7bXSnoCWC1pCbANuALA9mZJq4HNwD5g\naUtqLwXuAKYDD9peU9pvA+6StBXYA7wt+CMiortGPfKfLHLkHxGTSb8f+ecTvhERFUr4R0RUKOEf\nEVGhhH9ERIUS/hERFUr4R0RUKOEfEVGhhH9ERIUS/hERFUr4R0RUKOEfEVGhhH9ERIUS/hERFUr4\nR0RUKOEfEVGhhH9ERIUS/hERFUr4R0RUKOEfEVGhhH9ERIUS/hERFUr4R0RUKOEfEVGhhH9ERIUS\n/hERFUr4R0RUKOEfEVGhhH9ERIUS/hERFWor/CUdKWmjpK+W67MkrZP0rKS1kma2bLtc0lZJWyRd\n0tJ+nqRNZd0tLe3HSLq7tK+XdEY372BERLxTu0f+vw5sBlyuLwPW2T4LeKRcR9I84EpgHrAAWCFJ\nZZ9bgSW25wJzJS0o7UuAPaX9ZuCmzu5SRESMZtTwl3Qq8I+A/wnsD/JLgZVleSWwsCxfBqyyvdf2\nNuA5YL6kk4AZtjeU7e5s2ae11j3AReO+NxER0ZZ2jvxvBn4LeLOlbbbt3WV5NzC7LJ8M7GjZbgdw\nygjtO0s75ed2ANv7gFclzRrDfYiIiDGadqiVkn4ReMn2RkkDI21j25I80rpuGxwcfGt5YGCAgYER\nuxQRUa2hoSGGhoZG3U72wXNb0qeBq4F9wLuAvw58GfgQMGB7VxnSedT22ZKWAdi+sey/BrgBeL5s\nc05pvwq4wPa1ZZtB2+slTQNetH3CCH3xofoaEXE4Naczx5JJYiIyTBK2Nbz9kMM+tq+3fZrtOcAi\n4H/bvhq4H1hcNlsM3FuW7wcWSTpa0hxgLrDB9i7gNUnzywngq4H7WvbZX+tymhPIERHRQ4cc9hnB\n/petG4HVkpYA24ArAGxvlrSaZmbQPmBpy+H6UuAOYDrwoO01pf024C5JW4E9NC8yERHRQ4cc9plM\nMuwTEZPJlB72iYiIqSnhHxFRoYR/RESFEv4RERUa62yfiIi+cOBrxdpX06SShH9ETGFjm41Tkwz7\nRERUKOEfEVGhhH9ERIUS/hERFUr4R0RUKOEfEVGhhH9ERIUS/hERFUr4R0RUKOEfEVGhhH9ERIUS\n/hERFUr4R0RUKOEfEVGhhH9ERIUS/hERFUr4R0RUKOEfEVGhhH9ERIUS/hERFUr4R0RUKOEfEVGh\nQ4a/pHdJekzSU5I2S/pMaZ8laZ2kZyWtlTSzZZ/lkrZK2iLpkpb28yRtKutuaWk/RtLdpX29pDN6\ncUcjIuKAQ4a/7R8BF9p+P/A+4EJJHwGWAetsnwU8Uq4jaR5wJTAPWACskKRS7lZgie25wFxJC0r7\nEmBPab8ZuKmbdzAiIt5p1GEf2z8si0cDRwKvAJcCK0v7SmBhWb4MWGV7r+1twHPAfEknATNsbyjb\n3dmyT2ute4CLxn1vIiKiLaOGv6QjJD0F7AYetf0MMNv27rLJbmB2WT4Z2NGy+w7glBHad5Z2ys/t\nALb3Aa9KmjW+uxMREe2YNtoGtt8E3i/pOOAhSRcOW29J7lUHWw0ODr61PDAwwMDAwOG42YiIvjE0\nNMTQ0NCo28luP7cl/QfgDeCfAwO2d5UhnUdtny1pGYDtG8v2a4AbgOfLNueU9quAC2xfW7YZtL1e\n0jTgRdsnjHDbHktfI6JuzenGsWSGGGMe9rR+t0jCtoa3jzbb5/j9M3kkTQc+BmwE7gcWl80WA/eW\n5fuBRZKOljQHmAtssL0LeE3S/HIC+GrgvpZ99te6nOYEckRE9NBowz4nASslHUHzQnGX7UckbQRW\nS1oCbAOuALC9WdJqYDOwD1jacri+FLgDmA48aHtNab8NuEvSVmAPsKhbdy4iIkY2pmGfiZRhn4gY\niwz7lFsdz7BPRERMTQn/iIgKJfwjIiqU8I+IqFDCPyKiQgn/iIgKJfwjIiqU8I+IqFDCPyKiQgn/\niIgKJfwjIiqU8I+IqFDCPyKiQgn/iIgKJfwjIiqU8I+IqFDCPyKiQgn/iIgKJfwjIiqU8I+IqFDC\nPyKiQgn/iIgKJfwjIiqU8I+IqFDCPyKiQgn/iIgKJfwjIiqU8I+IqNCo4S/pNEmPSnpG0jclXVfa\nZ0laJ+lZSWslzWzZZ7mkrZK2SLqkpf08SZvKulta2o+RdHdpXy/pjG7f0YiYXCSN+RLd086R/17g\nN2y/F/gw8C8lnQMsA9bZPgt4pFxH0jzgSmAesABYoQN/tVuBJbbnAnMlLSjtS4A9pf1m4Kau3LuI\nmOQ8hkt006jhb3uX7afK8veBbwGnAJcCK8tmK4GFZfkyYJXtvba3Ac8B8yWdBMywvaFsd2fLPq21\n7gEu6uRORUTEoY1pzF/SmcAHgMeA2bZ3l1W7gdll+WRgR8tuO2heLIa37yztlJ/bAWzvA16VNGss\nfYuIiPZNa3dDSe+mOSr/dduvt46/2baknr8vGxwcfGt5YGCAgYGBXt9kRERfGRoaYmhoaNTtZI+e\n2ZKOAv4X8DXb/7m0bQEGbO8qQzqP2j5b0jIA2zeW7dYANwDPl23OKe1XARfYvrZsM2h7vaRpwIu2\nTxjWB7fT14joD80B5Fie02IsGdDv9btFErbfcba8ndk+Am4DNu8P/uJ+YHFZXgzc29K+SNLRkuYA\nc4ENtncBr0maX2peDdw3Qq3LaU4gR0REj4x65C/pI8CfAE9z4GVuObABWA2cDmwDrrD9vbLP9cCv\nAvtohokeKu3nAXcA04EHbe+fNnoMcBfN+YQ9wKJysri1HznyjziMxjO1cjIdOfd7/W452JF/W8M+\nk0HCP+Lw6vfw7Pf63TLuYZ+IiJh6Ev4RERVK+EdEVCjhHxFRobY/5BURk0uvZ+PE1Jbwj+hrY5tt\nErFfhn0iIiqU8I+IqFCGfSJ6JGPyMZkl/CN6KmPyMTll2CciokIJ/4iICiX8IyIqlPCPiKhQwj8i\nokIJ/4iICiX8IyIqlPCPiKhQwj8iokIJ/4iICiX8IyIqlPCPiKhQwj8iokIJ/4iICiX8IyIqlO/z\nj2rln61EzRL+Ubn8s5WoU4Z9IiIqNGr4S7pd0m5Jm1raZklaJ+lZSWslzWxZt1zSVklbJF3S0n6e\npE1l3S0t7cdIuru0r5d0RjfvYEREvFM7R/5/CCwY1rYMWGf7LOCRch1J84ArgXllnxU6MLB6K7DE\n9lxgrqT9NZcAe0r7zcBNHdyfiIhow6jhb/v/AK8Ma74UWFmWVwILy/JlwCrbe21vA54D5ks6CZhh\ne0PZ7s6WfVpr3QNcNI77ERERYzDeMf/ZtneX5d3A7LJ8MrCjZbsdwCkjtO8s7ZSf2wFs7wNelTRr\nnP2KiIg2dHzC183ct8x/i4joI+Od6rlb0om2d5UhnZdK+07gtJbtTqU54t9Zloe379/ndOAFSdOA\n42x/d6QbHRwcfGt5YGCAgYGBcXY/umWsc+UzTz6it4aGhhgaGhp1O7XzZJR0JvBV2+eW6/+J5iTt\nTZKWATNtLysnfL8InE8znPMw8B7blvQYcB2wAXgA+JztNZKWAufavlbSImCh7UUj9MEJjsmnCf92\n/y6aVOE/tr7DWPuf+qnfSf1ukYTtdxyljXrkL2kV8FHgeEnbgd8BbgRWS1oCbAOuALC9WdJqYDOw\nD1jakthLgTuA6cCDtteU9tuAuyRtBfYA7wj+iIjorraO/CeDHPlPTjnyT/3U7039bjnYkX8+4RsR\nUaF8t88Uly8vi4iRJPyr0J9fXpYXrojeSfjHJNefL1wRk13G/CMiKpTwj4ioUMI/IqJCCf+IiAol\n/CMiKpTZPhMs0xkjYiIk/CeFTGeMiMMrwz4RERVK+EdEVCjhHxFRoYR/RESFEv4RERVK+EdEVCjh\nHxFRoYR/RESFEv4RERVK+EdEVCjhHxFRoYR/RESFEv4RERVK+EdEVCjhHxFRoYR/RESFEv4RERWa\nNOEvaYGkLZK2Svrtie5PRMRUNinCX9KRwH8BFgDzgKskndNJzaGhoS70bOLqQ+pPTO3UT/3JXb9b\n2TMpwh84H3jO9jbbe4E/Ai7rpGDCfyrX72Xt1E/9yV1/qoX/KcD2lus7SltERPTAZAl/T3QHIiJq\nInvic1fSh4FB2wvK9eXAm7Zvatlm4jsaEdGHbGt422QJ/2nAnwMXAS8AG4CrbH9rQjsWETFFTZvo\nDgDY3ifpk8BDwJHAbQn+iIjemRRH/hERcXhNlhO+ERFxGE2KYZ+IiF6QtABYyIGp4zuBe22vqb3+\nlBj26ec/QOpPXO3Un9r1Jd0CzAXuLHUBTgWupvlQ6XVV1+/38O/7P0DqT0jt1K+i/lbbc0doF7DV\n9ntqro/tvr6UX8JI7aJ5AKV+n9bv576n/qSovwk4f4T2+cCm2utPhTH/H0k63/aGYe3nA2+kfl/X\n7+e+p/7E178GuFXSDJqvjIHmncVrZV3V9afCsM95wK3ASL+gpbafTP3+rN/PfU/9ia/fcjsnASeX\nqztt7+pG3WH13zpnYfvFfqjf9+G/X8svyMALPfoD5AHUXv0d3fz99LL2CPV7+bsx/f/Y6eXvv+vP\n3TI+Pp+W/gMb3OPgk3S27S1dqnWUm287bm073vZfdVR3CoX/h2iOGn4KPNutX3ypnQfQoWsfafun\nZfk44D0047mvdVp7hNtaantFt+uW2jNoTkD+pe3vdaHe0cA+22+W6z8PfBB4xvbXulD/fbaf7rTO\nKLdxOvCa7e9JmgOcB2yx/c0u3kZPnruSLgFWAM/x9ncWc2neWTzUjds5yG1vt31ahzUuBO4CpgNP\nAp+w/e2ybqPtD3RSv+/H/CV9FPg94Hs0D8w/BWZK2gtcbXv7ofZvo/5BH0AliHr2AALWAV17AEl6\n2wOo1O/oASTpSuC/SnoV+E3gFuAvaH4//8IdTNmT9G9GaL5e0rsAbP/+eGuX+itsLy3LHwG+yIG+\nf8L2A53UB54APgq8Ium3gF8CHgR+U9JHbS/rsP5GSd8GVgGrbG/usN7bSFoGfAL4iaTPAv8W+Drw\nKUm32/69Duv39LkLfA642Pa2Ybc7B/gacHYnxSX9wSFWz+ykdvFZ4BeAzcAvA+skXW37/3Wh9pSY\n7fMUcEJZnkMzRxjgY8DaLtTfApw5QvscmiOgTuv/wSEur3eh/hPAe2lmUFxO8yL2M2Xdxi7Ufxo4\nsfw+fgicXdrPoHl31Ent7wN3AzeUyyDwyv7rXej7xpblIeCDZflvA092of43W5afBKaX5Wl0ZzbI\nRuDvAZ8uf9engWUjPV7HWX8zzVHn8eVvsf95dizNu5dO6/f6ubsVOGqE9qPpzmyi12leHK8BFrdc\nrgH2dKH+08Ouv5fmCzAXduO52/dH/sARtl8uy9+hCR1sryvziDt1JAfmILfaSXfeOV1Dc0T1Y97+\nfw0E/EoX6h9t+5my/CVJ3wK+rO79n+SfuowBS/q2y1t2289LOqrD2vOA36cJm0HbP5S02PanOqw7\nkuNsfwPA9l9K6sZXn7wu6Vzbm4CXaYL0DeAomr9vx9wMv1xP845oPrAI+L+SvmP7Zzssv8/2G5J+\nQvPC/t1ymz+Q9GaHtaH3z93bgcclreLAu/bTaH5Ht3eh/hM0L/BfH75C0mAX6v9E0on7n1+2n5F0\nEfAA8Hc6LT4Vwv9JSbcBjwKXlp9IOpbufHdRHkCjkHSEm3Htj7e0TaMJuXGz/R3gckkLgYcl3dxZ\nT9/hbEmbyvIcSX/D9itq/qd0py9c0BwVfl7S08BLwBOS/gQ4F/hMF+q/je3HgMfKcNkFXSj5THnc\nHwusBVZL+grw88CfdaF+T5+7tj8j6T6afwn74dK8E/gVd2eI7JeBHx3kts/sQv3lNO+q3zrBbntH\nGS77ZKfF+/6Ebzmp9mvAOTQPyNtt/1TSdGC2h433jfM25tE8gN6a7QPc340HkKRZwI9s/7DTWgep\n/zHgZdtPDWufCXzS9u92WP98miGMN4a1nwl8xPbnO6nfUu/dNMM+59vuRrDt72OrF2z/RNLxwAW2\nv9yF25gGXAKcRXOwtR14yN05ofxPbH+h0zqHqP8umoOcF20/JOmfAj9LMxT632z/uMP6PX/uxsH1\nffhHRIykHOAsoxkjn00zrPoScC9wY6cvwP1ev++/0lnShyQ9Kunzkk6TtE7Sq5Iel9TRTJZSf4ak\n/yjpGUmvSforSY9JuqYL3U/9sdde3w99n8L1++b3D6ymmSAwAMyyPQu4kGZ20era6/f9kb+kx4Hf\noZla9VngN4Av0YxL/q7tn+mw/v3AV4CHgX8MvBv4I+Df03zg5frU7039fu576k+K+s/aPmus62qp\n3/F0sIm+8Pbpet8Ztu6pLtQfPt3qifLzCODPU7939fu576k/KeqvA/4dzfmD/W0nAr8NPFx7/b4f\n9gH2SvoFSVfQfBj3l+CtD5B0dEKq+IGknys1LwP2ALh8ajP1e1q/n/ue+hNf/0qazyj8saRXJL1C\n83mOvwlcUX39Tl89JvpC8w2AQzSfcjyD5i3ka8A3gH/Qhfp/H3icZpzt68DfLe0nANelfu/q93Pf\nU3/i65da5wAXAzOGtS+ovX7HnZvMF+DjPa7/q6k/MfX7ue+pf3jqA9fRfCL2XuB5YGHLum58ur2/\n6/fyDzjRF2B76k/N+v3c99Q/PPWBbwLvLstn0nzFxr8u17sRzn1dv+8/4asDn9AcyezU79/6/dz3\n1J/4+jSzGb8PYHtbOQ94j6Qz6M7Xa/R1/b4Pf+BvAQto5sMO96ep39f1+7nvqT/x9V+S9H6XT7fb\n/r6kXwRuA95Xe/2pEP4P0Lw12jh8haQ/Tv2+rt/PfU/9ia//z4C3/Q8L23slLQb+e+31+/5DXhER\nMXZTYZ5/RESMUcI/IqJCCf+IiAol/CMiKpTwj4io0P8HA6Buqj+Xx1QAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x1089c630>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "(titles.year//10*10).value_counts().sort_index().plot(kind='bar')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "titles.plot()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "### Plot the number of \"Hamlet\" films made each decade."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x2b0b9c88>"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXAAAAEOCAYAAACQMUyOAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAFeNJREFUeJzt3X+w7HV93/Hni1+jIzaMpb1VuAZSsJGpRmqLt2hlzcQU\n7zhop7YhrRLpTGV0HJ20TTUMHY6ddJI0jRrMiDcTddBpYaxJGYxQhliWRtOiwuUCwk2gkeaCEU0B\njVyNIO/+scv1sOw9u9y7u+fzOff5mDlzd7/fz9nP6+zufe33fM7+SFUhSerPUZsdQJJ0aCxwSeqU\nBS5JnbLAJalTFrgkdcoCl6ROzVXgSY5OsjvJZw6y/7Ik9yTZk+TMxUaUJE0z7xH4u4G7gKc9aTzJ\nTuC0qjodeBtw+eLiSZIOZmaBJzkZ2An8NpApQ84DrgCoqpuBE5JsW2RISdLTzXME/gHgF4AnDrL/\nJGDfuvP3AycfZi5J0gwbFniS1wPfqKrdTD/6PjB04ryvz5ekJTtmxv6zgfPG69zPAv5Kkk9U1QXr\nxjwAbF93/uTxtqdIYqlL0iGoqqkH0BsegVfVxVW1vapOBc4H/sdEeQNcA1wAkGQH8EhVPXiQyzus\nr0svvfSwL2MrZGglRwsZWsnRQoZWcrSQYVU5xs22wdelM/bP7sWNzDoCf1oHj4v6ovHEu6rq2iQ7\nk9wLPApc+AwvU5J0COYu8Kq6CbhpfHrXxL53LjiXJGmGrl6JORgMNjtCExmgjRwtZIA2crSQAdrI\n0UIGaCXHYKmXnllrLAubKKlVzSVJq5CEw3vSXWaucyehDuWPmJKkdlngktQpC1ySOmWBS1KnLHBJ\n6pQFLkmdssAlqVMWuCR1ygKXpE5Z4JLUKQtckjplgUtSpyxwSeqUBS5JnbLAJalTFrgkdcoCl6RO\nzSzwJM9KcnOS25LcleSXp4wZJPlWkt3jr0uWE1eS9KSZH2pcVd9L8pqq2p/kGODzSV5VVZ+fGHpT\nVZ23nJiSpElzLaFU1f7xyeOAo4GHpgyb+pltkqTlmKvAkxyV5DbgQeDGqrprYkgBZyfZk+TaJGcs\nOqgk6anmPQJ/oqpeBpwMvDrJYGLIrcD2qvoJ4EPA1QtNKUl6mplr4OtV1beSfBb4u8Bw3fa/WHf6\nuiQfTvK8qnrKUsva2tqB04PBgMFgcGipJWmLGg6HDIfDucamqjYekJwIPF5VjyR5NnA98L6q+ty6\nMduAb1RVJTkL+FRVnTJxOTVrLknqSRJGK8iHfAnM0cFU1dS/Mc5zBP584IokRzFacvlkVX0uyUUA\nVbULeBPw9iSPA/uB85/BTyBJOgQzj8AXNpFH4JK2mM0+AveVmJLUKQtckjplgUtSpyxwSeqUBS5J\nnbLAJalTFrgkdcoCl6ROWeCS1CkLXJI6ZYFLUqcscEnqlAUuSZ2ywCWpUxa4JHXKApekTlngktQp\nC1ySOmWBS1KnNizwJM9KcnOS25LcleSXDzLusiT3JNmT5MzlRJUkrbfhp9JX1feSvKaq9ic5Bvh8\nkldV1eefHJNkJ3BaVZ2e5BXA5cCO5caWJM1cQqmq/eOTxwFHAw9NDDkPuGI89mbghCTbFhlSkvR0\nMws8yVFJbgMeBG6sqrsmhpwE7Ft3/n7g5MVFlCRNs+ESCkBVPQG8LMmPANcnGVTVcGJYJr9t2mWt\nra0dOD0YDBgMBj+8gExexKGpmjq1JHVhOBwyHA7nGptnUnhJ/h3w3ar6T+u2fQQYVtVV4/N7gXOq\n6sGJ762N5hoV+OGWbyxwSStz+L01u7OSUFVTj3BnPQvlxCQnjE8/G3gtsHti2DXABeMxO4BHJstb\nkrR4s5ZQng9ckeQoRmX/yar6XJKLAKpqV1Vdm2RnknuBR4ELlxtZkgTPcAnlsCZyCUXSFtP0Eook\nqV0WuCR1ygKXpE5Z4JLUKQtckjplgUtSpyxwSeqUBS5JnbLAJalTFrgkdcoCl6ROWeCS1CkLXJI6\nZYFLUqcscEnqlAUuSZ2ywCWpUxa4JHXKApekTs0s8CTbk9yY5CtJ7kzyriljBkm+lWT3+OuS5cSV\nJD1p1qfSAzwG/HxV3ZbkeOCWJDdU1d0T426qqvMWH1GSNM3MI/Cq+npV3TY+/R3gbuAFU4ZO/dRk\nSdJyPKM18CSnAGcCN0/sKuDsJHuSXJvkjMXEkyQdzDxLKACMl08+Dbx7fCS+3q3A9qran+R1wNXA\niyYvY21t7cDpwWDAYDA4hMiStHUNh0OGw+FcY1NVswclxwK/B1xXVR+cY/xXgZdX1UPrttVGcyVh\ndCB/OMI8P48kLcLh99bszkpCVU1dop7nWSgBPgrcdbDyTrJtPI4kZzF6YHho2lhJ0mLMs4TySuDN\nwO1Jdo+3XQy8EKCqdgFvAt6e5HFgP3D+ErJKktaZawllIRO5hCJpi2l+CUWS1CYLXJI6ZYFLUqcs\ncEnqlAUuSZ2ywCWpUxa4JHXKApekTlngktQpC1ySOmWBS1KnLHBJ6pQFLkmdssAlqVMWuCR1ygKX\npE5Z4JLUKQtckjplgUtSp+b5VPrtSW5M8pUkdyZ510HGXZbkniR7kpy5+KiSpPXm+VT6x4Cfr6rb\nkhwP3JLkhqq6+8kBSXYCp1XV6UleAVwO7FhOZEkSzHEEXlVfr6rbxqe/A9wNvGBi2HnAFeMxNwMn\nJNm24KySpHWe0Rp4klOAM4GbJ3adBOxbd/5+4OTDCSZJ2tg8SygAjJdPPg28e3wk/rQhE+drcsDa\n2tqB04PBgMFgMO/0OkIlk3erQ1P1tLtjlzlasIjrwtvj4IbDIcPhcK6xmecHSHIs8HvAdVX1wSn7\nPwIMq+qq8fm9wDlV9eC6MbXRXKMb5HCvzDR5g+jQtXK/aCVHCw7/utg6t8cqroskVNXUR6x5noUS\n4KPAXdPKe+wa4ILx+B3AI+vLW5K0ePMsobwSeDNwe5Ld420XAy8EqKpdVXVtkp1J7gUeBS5cSlpJ\n0gFzLaEsZCKXUHQIWrlftJKjBS6hLDLHkpdQJEltssAlqVMWuCR1ygKXpE5Z4JLUKQtckjplgUtS\npyxwSeqUBS5JnbLAJalTFrgkdcoCl6ROWeCS1CkLXJI6ZYFLUqcscEnqlAUuSZ2ywCWpUxa4JHVq\nnk+l/1iSB5PccZD9gyTfSrJ7/HXJ4mNKkibN86n0Hwc+BHxigzE3VdV5i4kkSZrHzCPwqvoD4OEZ\nw6Z+YrIkaXkWsQZewNlJ9iS5NskZC7hMSdIM8yyhzHIrsL2q9id5HXA18KJpA9fW1g6cHgwGDAaD\nBUwvSVvHcDhkOBzONTZVNXtQcgrwmap6yRxjvwq8vKoemtheG82VhNHB/OEI8/w86kcr94tWcrTg\n8K+LrXN7rOK6SEJVTV2mPuwllCTbMvopSHIWoweFh2Z8myTpMM1cQklyJXAOcGKSfcClwLEAVbUL\neBPw9iSPA/uB85cXV5L0pLmWUBYykUsoOgSt3C9aydECl1AWmWOTl1AkSZvDApekTlngktQpC1yS\nOmWBS1KnLHBJ6pQFLkmdssAlqVMWuCR1ygKXpE5Z4JLUKQtckjplgUtSpyxwSeqUBS5JnbLAJalT\nFrgkdcoCl6ROWeCS1KmZBZ7kY0keTHLHBmMuS3JPkj1JzlxsREnSNPMcgX8cOPdgO5PsBE6rqtOB\ntwGXLyibJGkDMwu8qv4AeHiDIecBV4zH3gyckGTbYuJJkg5mEWvgJwH71p2/Hzh5AZcrSdrAMQu6\nnEycr2mD1tbWDpweDAYMBoMFTb84yeSPcmiqpl4F3WRoKYdGvD2ODMPhkOFwONfYzHNjJjkF+ExV\nvWTKvo8Aw6q6anx+L3BOVT04Ma42mmt05zzcO1YWVFqbm6OFDK3kaCFDKzlayLCYHC1kaCXH7AxJ\nqKqpj96LWEK5BrhgPNEO4JHJ8pYkLd7MJZQkVwLnACcm2QdcChwLUFW7quraJDuT3As8Cly4zMCS\npJG5llAWMpFLKF1laCVHCxlaydFChsXkaCFDKzk2fwlFkrQJLHBJ6pQFLkmdssAlqVMWuCR1ygKX\npE5Z4JLUKQtckjplgUtSpyxwSeqUBS5JnbLAJalTFrgkdcoCl6ROWeCS1CkLXJI6ZYFLUqcscEnq\nlAUuSZ2aq8CTnJtkb5J7krxnyv5Bkm8l2T3+umTxUSVJ683zqfRHA78J/BTwAPClJNdU1d0TQ2+q\nqvOWkFGSNMU8R+BnAfdW1X1V9RhwFfCGKeOmfmqyJGk55inwk4B9687fP962XgFnJ9mT5NokZywq\noCRpuplLKIzKeZZbge1VtT/J64CrgRdNDlpbWztwejAYMBgM5kspSUeI4XDIcDica2yqNu7nJDuA\ntao6d3z+F4EnqupXN/ierwIvr6qH1m2rjeZKwnyPFRumZdbPM/MSGsjRQoZWcrSQoZUcLWRYTI4W\nMrSSY3aGJFTV1CXqeZZQvgycnuSUJMcBPwNcMzHBtox+EpKcxeiB4aGnX5QkaVFmLqFU1eNJ3glc\nDxwNfLSq7k5y0Xj/LuBNwNuTPA7sB85fYmZJEnMsoSxsIpdQusrQSo4WMrSSo4UMi8nRQoZWcix/\nCUWS1CALXJI6ZYFLUqcscEnqlAUuSZ2ywCWpUxa4JHXKApekTlngktQpC1ySOmWBS1KnLHBJ6pQF\nLkmdssAlqVMWuCR1ygKXpE5Z4JLUKQtckjo1s8CTnJtkb5J7krznIGMuG+/fk+TMxceUJE3asMCT\nHA38JnAucAbws0lePDFmJ3BaVZ0OvA24fElZgeHyLnpuw80OMDbc7AC0kQHayDHc7ABjw80OQBsZ\noI0cw6Ve+qwj8LOAe6vqvqp6DLgKeMPEmPOAKwCq6mbghCTbFp4UOBJukPkNNzsAbWSANnIMNzvA\n2HCzA9BGBmgjx3Cplz6rwE8C9q07f/9426wxJx9+NEnSRmYV+Mafd/9Dkx95P+/3SZIOUaoO3rVJ\ndgBrVXXu+PwvAk9U1a+uG/MRYFhVV43P7wXOqaoHJy7LUpekQ1BVkwfJABwz4/u+DJye5BTga8DP\nAD87MeYa4J3AVePCf2SyvDcKIEk6NBsWeFU9nuSdwPXA0cBHq+ruJBeN9++qqmuT7ExyL/AocOHS\nU0uSNl5CkSS1y1diSlKnZq2BS1LzkpwLvJEfPs35AeDqqvrvWzlDs0soR+oN0mqOFjK0kqOFDK3k\naCTDbwCnA58Yzw+j16K8hdELEd+1VTM0WeBH8g3SYo4WMrSSo4UMreRoIcM4xz3jt/KY3B7gnqo6\nbctmqKrmvsY/8LTtYXTHOCIytJKjhQyt5GghQys5Wsgwnu8O4Kwp218B3LGVM7S6Bv69JGdV1Rcn\ntp8FfPcIytBKjhYytJKjhQyt5GghA8BbgcuTPJfRW3nA6DeBb4/3bdkMrS6hvJzRuxpOuzLeUVW3\nHAkZWsnRQoZWcrSQoZUcLWSYyPN84AXjsw9U1ddXOf+6DAf+HlBVf7bU+Vos8Cet+spoNcOUHPcf\nCXfOOXIUR8h/1DlzbPb9ooCvbdL/0zBarjhwXQBfrAYKLsmPV9XepVx2Az/fM7LMK+Mg8x1bo7fS\nXb/txKr681VlmJLpHVX14U2c/7mM/nj1J1X1yArnPQ54vKqeGJ//SeDvAF+pqutWlOGlVXX7Kuaa\nJckLgW9X1SNJTgVeDuytqjtXnOPvMTry/gHwx6v8/zme/6eBDwP38tTfBE5n9JvA9avMMynJvqra\nvpTL7rDAl3ZlTMzzGuCTwLOBW4CLquqr4327q2olnzyU5F9P2Xwx8B8Aqur9K8jw4ap6x/j0q4D/\nAvwfRv9BLqqqzy47w3ju2xm9UdrDSX4B+EfAtcA5wC1V9d4VZPgB8FXgSuDKqrpr2XMeJMd7gYuA\n7wO/Bvwb4AvADuBjVfXrK8hwDvDrwCOMHjz+EDgBeAx4S1Xt2+DbF5ljL3BuVd03sf1U4Lqq+vEV\nZPjQBrvfWlXPXca8Tf4Rc8aVccKKYvwa8A+Bu4B/DNyQ5C1V9b9WNP+T3gd8dpwDRn/hP4rRuuOq\n/P11p38JeGNV3Zrkx4D/Os63CkdV1cPj0+cDr6qq7yb5FWA3sPQCB25n9DS5fwZck2Q/owe0qyYL\nZMkuYPQpWc8B7gNOrapvJnkO8EVGxbpsvwG8djzvqcAHquqVSV4LfBT46RVkgNH7ND0wZfsDrK7j\n3sroQfQveerbaYfRfWUpmixwNunKmHBcVX1lfPrTSe4Gfvdgnwu6RGcA72f0H3WtqvYn+bmqet+K\nczzpR6rqVoCq+pMkq3w7hr9I8pKqugP4JqPfjr4LHMvT35N+acZLFBcDFyd5BaMHk88n+dOqOntF\nMR4fP3h9H9gPPDTO9miSJ1aU4aiq+ub49J8CPzrOcMP4OeKr8jHgS0mu5IdLKNsZ3S4fW1GGLwN3\nVtUXJnckWVvWpE0uoSS5EbjkIFfGfVV1ygoyfBl4/fo/CiU5mdHR5t+squOXnWEizxuBfwt8APiP\nVXXqCuf+LqP1RYBTge3jZYyjgT1V9bdXlOOljJa1bmf0wP4q4H8CLwHeX1X/eQUZpi6fjR/IXl1V\nw2VnGM935fjkcxg96+PZwH8DfpLRwcebV5Dh48ATwI2MPlrx/qr6V+PfAm5ZxdLFuixnMPq4xwPP\nQgGuWdUSV5LnAd+rqv2rmO/AvI0W+KZcGRMZXgt8s6pum9h+AvDOqvqlTch0PLDG6AUDr17hvKdM\nbPpaVX0/yYmMSut3V5jlGEa/mr+I0W+Q+4DrV/XH1CT/fBUPFHPkeBajI8w/q6rrk7wZOBvYC+yq\nqr9cQYbjgH8JvBjYw2jt/QdJng1sW/GS0hGpyQKXpHmND6rey+g9WbYx+u3sG8DVwK+s4sF9szI0\n+XaySZ6b5N8n+UqSbyf58yQ3J3nrkZRhgxz/2+vC+4X3iwM+BTwMDIDnVdXzgNcwenbMp7ZyhiaP\nwJNcw2g97/eBfwIcD1wFXMJone3iIyFDKzlayNBKjhYytJKjhQzjHH9cVS96pvu2RIZa0RvOPJMv\n4PaJ818e/3sU8EdHSoZWcrSQoZUcLWRoJUcLGcbz3cDoD/zb1m37G8B7gN/fyhmaXEIBHk3yDwCS\nvAH4fwA1fgXeEZShlRwtZGglRwsZWsnRQgYYfdj6icBNSR5O8jAwBP4q8E+3dIZVPUo+w0eznwC+\nxGj96AvA3xpv/2vAu46UDK3kaCFDKzlayNBKjhYyrMvyYuCngOdObD93K2dY2RW8wCvpX5ihnRwt\nZGglRwsZWsmxygzAu4A/YvSMj//L6JXCT+7bvZUzNPlHzI1kRe+F0nqGVnK0kKGVHC1kaCXHKjMk\nuRPYUVXfGb9m4XeAT1bVBw/2wqutkqHJl9InuWOD3duOlAyt5GghQys5WsjQSo4WMoylqr4DUFX3\nZfQmW7+T5EdZ3VssbEqGJgsc+OvAuYyeVznpD4+gDK3kaCFDKzlayNBKjhYyAHwjyctq/Krp8VHw\n6xm9odZLt3KGVgv8s8DxVbV7ckeSm46gDK3kaCFDKzlayNBKjhYywOidGZ/ynv1V9ViSnwN+aytn\n6G4NXJI00urzwCVJM1jgktQpC1ySOmWBS1KnLHBJ6tT/BzKsvKvrg6wEAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x2b92ddd8>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "d=titles[titles.title=='Hamlet'].year//10*10\n",
    "d.value_counts().sort_index().plot(kind='bar')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "### Plot the number of \"Rustler\" characters in each decade of the history of film."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "### Plot the number of \"Hamlet\" characters each decade."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "### What are the 11 most common character names in movie history?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "### Who are the 10 people most often credited as \"Herself\" in film history?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "### Who are the 10 people most often credited as \"Himself\" in film history?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "### Which actors or actresses appeared in the most movies in the year 1945?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "### Which actors or actresses appeared in the most movies in the year 1985?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "### Plot how many roles Mammootty has played in each year of his career."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "### What are the 10 most frequent roles that start with the phrase \"Patron in\"?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "### What are the 10 most frequent roles that start with the word \"Science\"?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "### Plot the n-values of the roles that Judi Dench has played over her career."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "### Plot the n-values of Cary Grant's roles through his career."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "### Plot the n-value of the roles that Sidney Poitier has acted over the years."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "### How many leading (n=1) roles were available to actors, and how many to actresses, in the 1950s?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "### How many supporting (n=2) roles were available to actors, and how many to actresses, in the 1950s?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "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.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}