Solutions-3.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 style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>title</th>\n",
       "      <th>year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Tomorrow Ends at Dawn</td>\n",
       "      <td>2002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Brothers of the West</td>\n",
       "      <td>1937</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Nemo</td>\n",
       "      <td>1984</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Pereezd</td>\n",
       "      <td>2014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Bad for Business</td>\n",
       "      <td>2007</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   title  year\n",
       "0  Tomorrow Ends at Dawn  2002\n",
       "1   Brothers of the West  1937\n",
       "2                   Nemo  1984\n",
       "3                Pereezd  2014\n",
       "4       Bad for Business  2007"
      ]
     },
     "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 style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x7fa259c41978>"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAX8AAAEdCAYAAADkeGc2AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAH0BJREFUeJzt3Xu0XGWd5vHvI5GLyIBp6XARgRnDQGwdBCX2TY6idP7o\nAVztQOzRAc04thkHbEeH4JppcVY3Ak43gz1D1vQ0dAAVyZJG7REDATl9sYUIEkFimmAbJAECRi7e\nJfDMH/s9SeV0VXJOXVK1dz2ftWrV3u/e9ey3zqnz1q7f3rWPbBMREePlBcPuQERE7HkZ/CMixlAG\n/4iIMZTBPyJiDGXwj4gYQxn8IyLG0IwGf0kHSfqcpG9LWidpoaS5klZLekDSLZIOaln/AkkbJK2X\ndGpL+4mS7ivLLm9p30fS9aX9DklH9vdpRkREq5nu+V8O3GT7OODVwHpgGbDa9jHAbWUeSQuAs4AF\nwCLgCkkqOcuBJbbnA/MlLSrtS4Ctpf0y4JKen1lERHS028Ff0oHAb9q+CsD2NttPA6cBV5fVrgbO\nKNOnA9fZftb2RuBBYKGkQ4EDbK8p613T8pjWrBuAU3p6VhERsUsz2fM/GnhC0l9I+oak/ytpf2Ce\n7S1lnS3AvDJ9GLCp5fGbgMPbtG8u7ZT7h6F6cwGeljS3mycUERG7N5PBfw5wAnCF7ROAH1NKPFNc\nXSMi14mIiKiJOTNYZxOwyfbXy/zngAuAxyQdYvuxUtJ5vCzfDBzR8viXlYzNZXp6+9RjXg48ImkO\ncKDtH7R2QlLeXCIiumBb7Rp3ewP+BjimTF8IXFpu55e2ZcDFZXoBsBbYm6pk9B1AZdmdwEJAwE3A\notK+FFhephcDn23TB8+kry3rXzib9Wd7S/7w8uvc9+Qnf0/ndxo7Z7LnD/CfgE9L2rsM5u8C9gJW\nSloCbATOLFtZJ2klsA7YBix16UEZ5FcA+1GdPbSqtF8JXCtpA7C1vAH06qg+ZCR/NPMHmZ385I9F\n/owGf9vfBF7XZtGbO6x/EXBRm/a7gVe1af855c0jIiIGr8nf8F2R/MbmDzI7+ckfi3ztqMiMNkl2\nu4MWERHRUaexs7F7/pImkt/M/Dr3PfnJH5X8xg7+ERHRWco+ERENNnZln4iI6Kyxg39d6m7JH63s\n5Cd/XPIbO/hHRERnqflHRDRYav4REbFdYwf/utTdkj9a2clP/rjkN3bwj4iIzlLzj4hosNT8IyJi\nu8YO/nWpuyV/tLKTn/xxyW/s4B8REZ2l5h8R0WCp+UdExHaNHfzrUndL/mhlJz/545Lf2ME/IiI6\nS80/IqLBUvOPiIjtGjv416XulvzRyk5+8sclv7GDf0REdJaaf0REFyTNevAcxhjWaeycs6c7EhHR\nHLMZ/0dr37WxZZ+61N2SP1rZyU9+7yYHmp6af0REdG1GNX9JG4FngOeAZ22fJGkucD1wJLARONP2\nU2X9C4B3l/XPtX1LaT8RWAHsC9xk+7zSvg9wDXACsBU4y/ZD0/qQmn9EjIyq5j+7ss8o1fxnuudv\nYML2a2yfVNqWAattHwPcVuaRtAA4C1gALAKukDS14eXAEtvzgfmSFpX2JcDW0n4ZcMmsn2FERMzY\nbMo+0985TgOuLtNXA2eU6dOB62w/a3sj8CCwUNKhwAG215T1rml5TGvWDcAps+hX+87WvG6Y/OFk\nJz/5vZscaPqervkbuFXSXZLeU9rm2d5SprcA88r0YcCmlsduAg5v0765tFPuHwawvQ14upSVIiJi\nAGZ6quev235U0sHAaknrWxfadjfnvA6S7cnkNzO/zn1PfvPzYWKg6f3q/4wGf9uPlvsnJN0InARs\nkXSI7cdKSefxsvpm4IiWh7+Mao9/c5me3j71mJcDj0iaAxxo+wfT+yFpBdXBZYCngLVTP4ipj0KZ\nz3zmM7+n5neYLPcTu5mvDLJ/ZfqcsqmNdGJ7lzfgRVS1eoD9ga8CpwKXAueX9mXAxWV6AbAW2Bs4\nGvgOO84quhNYSHX84CZgUWlfCiwv04uBz7bph3fX12nrT8xm/dnekj+8/Dr3PfnNyQcMbnO7vUM7\nHkb/O213Jnv+84Abywk7c4BP275F0l3ASklLyrvLmWUr6yStBNYB24ClLj0og/wKYD+qUz1XlfYr\ngWslbaA61XPxDPoVERFdyrV9IiK6MC7n+UdERIM0dvCv+7nCyR9OdvKT37vJgabv6fP8IyKiQVLz\nj4joQmr+ERFRO40d/OteN0z+cLKTn/zeTQ40PTX/iIjoWmr+ERFdSM0/IiJqp7GDf93rhskfTnby\nk9+7yYGmp+YfERFdS80/IqILqflHRETtNHbwr3vdMPnDyU5+8ns3OdD01PwjIqJrqflHRHQhNf+I\niKidxg7+da8bJn842clPfu8mB5qemn9ERHQtNf+IiC6k5h8REbXT2MG/7nXD5A8nO/nJ793kQNNT\n84+IiK6l5h8R0YXU/CMionYaO/jXvW6Y/OFkJz/5vZscaHpq/hER0bXU/CMiupCaf0RE1M6MBn9J\ne0m6R9Jflfm5klZLekDSLZIOaln3AkkbJK2XdGpL+4mS7ivLLm9p30fS9aX9DklH9uOJ1b1umPzh\nZCc/+b2bHGj6nq75nwesY8dnnGXAatvHALeVeSQtAM4CFgCLgCskTX3cWA4ssT0fmC9pUWlfAmwt\n7ZcBl/T2lCIiYnd2W/OX9DJgBfBHwAdt/2tJ64GTbW+RdAgwaftYSRcAz9u+pDx2FXAh8BDwFdvH\nlfbFwITt3yvrfNT2nZLmAI/aPrhNP1Lzj4iRMQ41/8uADwPPt7TNs72lTG8B5pXpw4BNLettAg5v\n0765tFPuHwawvQ14WtLcGfQrIiK6NGdXCyX9NvC47Xs61Zlsu3oHHDxJK4CNZfYpYK3tybJsovRn\nav4Du1ne63zyh5Tf+lpMfvKHmb/DZLmfYOea/8S05ZVB9r9Mn1NW2UgntjvegIuo9sq/CzwK/Bi4\nFlgPHFLWORRYX6aXActaHr8KWAgcAny7pf3twPKWdV5fpucAT3Toi3fV1zbrT8xm/dnekj+8/Dr3\nPfnNyQcMbnO7vUM7Hkb/O213xuf5SzoZ+JCrmv+lVAdpL5G0DDjI9rJywPczwElU5ZxbgVfYtqQ7\ngXOBNcCXgE/aXiVpKfAq2+8rxwLOsL24zfbt1PwjYkTUvea/y7JPG1PP9GJgpaQlVB8rzgSwvU7S\nSqozg7YBS73j3WUp1YHj/YCbbK8q7VcC10raAGwF/snAHxER/dXYb/hKmnCphw2oP8kfUn6d+578\n5uR33vOfZEetf6dH9GXPf7b97+Vsn4iIaJjG7vlHRAxS3Wv+2fOPiBhDjR38O30vIfn1z69z35Pf\n/Py6XNtntmf7RETUwq6+fCq1r76MU2k5Nf+IaKRB1+RT84+IiNpp7OBf97ph8oeTnfzm5w+6Jl+X\nmn9jB/+IiOgsNf+IaKTU/MtWU/OPiIgpjR38616XTP5wspPf/PzU/CuNHfwjIqKz1PwjopFS8y9b\nTc0/IiKmNHbwr3tdMvnDyU5+8/NT8680dvCPiIjOUvOPiEZKzb9sNTX/iIiY0tjBv+51yeQPJzv5\nzc9Pzb/S2ME/IiI6S80/IhopNf+y1dT8IyJiSmMH/7rXJZM/nOzkNz8/Nf9KYwf/iIjoLDX/iGik\n1PzLVlPzj4iIKY0d/Otel0z+cLKT3/z81Pwruxz8Je0r6U5JayWtk/Tx0j5X0mpJD0i6RdJBLY+5\nQNIGSeslndrSfqKk+8qyy1va95F0fWm/Q9KR/XhiERHR2W5r/pJeZPsnkuYAfwd8CDgN+L7tSyWd\nD7zE9jJJC4DPAK8DDgduBebbtqQ1wPttr5F0E/BJ26skLQV+xfZSSWcBb7W9uE0/UvOPiBlLzb9s\ntduav+2flMm9gb2AJ6kG/6tL+9XAGWX6dOA628/a3gg8CCyUdChwgO01Zb1rWh7TmnUDcMosnldE\nRHRht4O/pBdIWgtsAW63fT8wz/aWssoWYF6ZPgzY1PLwTVSfAKa3by7tlPuHAWxvA56WNLe7p7NT\nvyd6zUj+aObXue/JH35+av6VObtbwfbzwPGSDgRulvTGactdffwZPEkrgI1l9ilgre3Jsmyi9Gey\nLD9eEp2W9zqf/OHmZz7zM5nfYbLcT+xmvjIq+d3Ml+lzyqY20sGszvOX9N+AnwL/Hpiw/Vgp6dxu\n+1hJy0oHLi7rrwI+CjxU1jmutL8deIPt95V1LrR9Rzmu8Kjtg9tsOzX/iJix1PzLVrup+Ut6qcqZ\nPJL2A94C3AN8ETi7rHY28Pky/UVgsaS9JR0NzAfW2H4MeEbSQkkC3gl8oeUxU1lvA27r8jlGRMQM\n7a7mfyjwlVLzvxP4K9u3ARcDb5H0APCmMo/tdcBKYB3wZWCpd3y0WAr8ObABeND2qtJ+JfBLkjYA\nHwCW9eOJ1b0umfzhZCe/+fmp+Vd2WfO3fR9wQpv2HwBv7vCYi4CL2rTfDbyqTfvPgTNn2N+IiOiD\nXNsnIhopNf+y1VzbJyIipjR28K97XTL5w8lOfvPzU/OvNHbwj4iIzlLzj4hGSs2/bDU1/4iImNLY\nwb/udcnkDyc7+c3PT82/0tjBPyIiOkvNPyIaKTX/stXU/CMiYkpjB/+61yWTP5zs5Dc/PzX/SmMH\n/4iI6Cw1/4hopNT8y1ZT84+IiCmNHfzrXpdM/nCyk9/8/NT8K40d/CMiorPU/COikVLzL1tNzT8i\nIqY0dvCve10y+cPJTn7z81PzrzR28I+IiM5S84+IRkrNv2w1Nf+IiJjS2MG/7nXJ5A8nO/nNz0/N\nv9LYwT8iIjpLzT8iGik1/7LV1PwjImJKYwf/utclkz+c7OQ3Pz81/0pjB/+IiOhstzV/SUcA1wC/\nTFXg+jPbn5Q0F7geOBLYCJxp+6nymAuAdwPPAefavqW0nwisAPYFbrJ9Xmnfp2zjBGArcJbth6b1\nIzX/iAapauazM0o1+XGo+T8L/L7tVwKvB/6jpOOAZcBq28cAt5V5JC0AzgIWAIuAKyRNbXg5sMT2\nfGC+pEWlfQmwtbRfBlzS5fOMiFrxLG7RT7sd/G0/Znttmf4R8G3gcOA04Oqy2tXAGWX6dOA628/a\n3gg8CCyUdChwgO01Zb1rWh7TmnUDcEovTwrqX5dM/nCykz/8/LrX5BtZ85d0FPAa4E5gnu0tZdEW\nYF6ZPgzY1PKwTVRvFtPbN5d2yv3DALa3AU+XslJERAzAnJmuKOnFVHvl59n+4Y5KDth2N/W72ZK0\ngur4AsBTwFrbk2XZROnLZMv6E52W9zqf/OHl257sd3+TP5z8HSbL/US5tc63Lq+MS343P/8yfU7Z\n1EY6mNGXvCS9EPh/wJdt/8/Sth6YsP1YKencbvtYSctKJy4u660CPgo8VNY5rrS/HXiD7feVdS60\nfYekOcCjtg+e1occ8I1okLofkG38Ad9ysPZKYN3UwF98ETi7TJ8NfL6lfbGkvSUdDcwH1th+DHhG\n0sKS+U7gC22y3kZ1ALknda97Jn842ckffn7da/J1qfnPpOzz68A7gHsl3VPaLgAuBlZKWkI51RPA\n9jpJK4F1wDZgqXd8vFhKdarnflSneq4q7VcC10raQHWq5+Ien1dEROxCru0TEW11cxxvlMomdc/v\nl05j54wP+EbEOJrd4Bb10djLO9S97pn84WQnfyYmBxuf/F3q1++3sYN/RER0lpp/RLRV95p53fP7\nJTX/iIYZ9AHZaLbGln3qXldN/nCy65ff7gJot3do75fJPmYlf7ZS84+IiK6l5h9RU3WvaSd/z+j6\n8g4REdE8jR3861W3Tf6oZPczX5Jne+vHdute007+rqXmH1ELwzggG7F7qflHDEjda87JH25+v6Tm\nHxER2zV28K9LXTj5o5W9J/LrXnNO/nDzU/OPiIiupeYfMSB1rzknf7j5/ZKaf0REbNfYwb/udeHk\nDyd7T+TXveac/OHmp+YfERFdS80/YkDqXnNO/nDz+yU1/4iI2K6xg3/d68LJH072nsive805+cPN\nT80/IiK6lpp/xIDUveac/OHm90tq/hERsV1jB/+614WTP/jsXG8/+XXMT80/oi9yvf0YT6n5x9iq\ne004+c3O75eua/6SrpK0RdJ9LW1zJa2W9ICkWyQd1LLsAkkbJK2XdGpL+4mS7ivLLm9p30fS9aX9\nDklH9vZUIyJid2ZS9vkLYNG0tmXAatvHALeVeSQtAM4CFpTHXCFp6h1nObDE9nxgvqSpzCXA1tJ+\nGXBJD89nuzrXtJM/vOzK5GDjk5/8Huyxmr/tvwWenNZ8GnB1mb4aOKNMnw5cZ/tZ2xuBB4GFkg4F\nDrC9pqx3TctjWrNuAE7p4nlERMQsdHvAd57tLWV6CzCvTB8GbGpZbxNweJv2zaWdcv8wgO1twNOS\n5nbZr+1sT/aakfzRzB9032FisPHJT34P+vX67/lsH1dHjOtx1DgiIgCY0+Xjtkg6xPZjpaTzeGnf\nDBzRst7LqPb4N5fp6e1Tj3k58IikOcCBtn/QbqOSVgAby+xTwNqpd8GpOljL/Ad2s7zX+eRXbmcW\nps466KX/rTXPPvS/mCz3E+xcs52YtryS/OTvifxuXv9l+pyyykY6sb3bG3AUcF/L/KXA+WV6GXBx\nmV4ArAX2Bo4GvsOO00nvBBYCAm4CFpX2pcDyMr0Y+GyHPngmfW1Zf2I268/2lvwdvxdwm9vtbdpm\n9zscrb7Pvv/JT/4ovP47bXe35/lLug44GXgpVX3/D4AvACup9tg3Amfafqqs/xHg3cA24DzbN5f2\nE4EVwH7ATbbPLe37ANcCrwG2AotdHSye3g875/mPnNmd6zyc85w7qft54Mlvdn6/dBo78yWv6EkG\n/+QnfzD5/dL1l7zqqs7nsTchf5DnOte578lPfq/69frv9oBv1IR2cTGyHd+/29ko7Z1HxGCk7NNw\no/XRt5vs2Rmlj+3JT34v+f3SaezMnn+MuNn9cUXEzKTmP6b59a57DjI7+ckf7fw9dm2fiIhontT8\nG2606p6jVVNNfvJHOb9fxu5Uz4iI6Kyxg3/da/Kp+Q8rO/nJH+38nOffEDkPPyKGITX/Iat7XTI1\n/+QnfzD5/ZKaf0REbNfYwT81+SbnDzI7+ckf7fyc5x8REV1LzX/I6l6XTM0/+ckfTH6/pOYfERHb\nNXbwT82/yfmDzE5+8kc7PzX/iIjoWmr+Q1b3umRq/slP/mDy+yU1/4iI2K6xg39q/k3OH2R28pM/\n2vmp+UdERNdS8x+yutclU/NPfvIHk98vqflHRMR2jR38U/Nvcv4gs5Of/NHOT80/IiK6lpr/kNW9\nLpmaf/KTP5j8fknNPyIithuZwV/SIknrJW2QdH4f8ib60K2h5de9Lpmaf/KTPxiNqvlL2gv4X8Ai\nYAHwdknH9Rh7fM8dG2r+2sHG1zq/zn1PfvJ71pexZyQGf+Ak4EHbG20/C3wWOL3HzIN679Yw858a\nbHyt8+vc9+Qnv2d9GXtGZfA/HHi4ZX5TaYuIiAEYlcF/EKccHTWAzD2Yv3Gw8bXOH2R28pM/6vn9\nGXtG4lRPSa8HLrS9qMxfADxv+5KWdYbf0YiIGmp3queoDP5zgH8ATgEeAdYAb7f97aF2LCKioeYM\nuwMAtrdJej9wM7AXcGUG/oiIwRmJPf+IiNizRuWAb0RE7EEjUfaJiBgESYuAM9hx6vhm4PO2V417\nfiPKPnX+BSR/eNnJb3a+pMuB+cA1JRfgZcA7qb5Ueu5Y59d98K/9LyD5Q8lO/ljkb7A9v027gA22\nXzHO+diu9a38ENq1i+oFlPya5te578kfifz7gJPatC8E7hv3/CbU/H8m6STba6a1nwT8NPm1zq9z\n35M//PxzgOWSDqC6ZAxUnyyeKcvGOr8JZZ8TgeVAux/QUtt3J7+e+XXue/KHn9+ynUOBw8rsZtuP\n9SN3Wv72Yxa2H61Dfu0H/yktPyADjwzoF5AX0MzyN/Xz5zPI7Db5g/zZmPq/dgb58+/7326pjy+k\npf/AGg944JN0rO31fcp6oaurHbe2vdT293vKbdDg/zqqvYbngAf69YMv2XkB7Tp7L9vPlekDgVdQ\n1XOf6TW7zbaW2r6i37kl+wCqA5D/aLvn6/JK2hvYZvv5Mv8m4ATgfttf7kP+q23f22vObrbxcuAZ\n209JOho4EVhv+1t93MZA/nYlnQpcATzIzp8s5lN9sri5H9vpsO2HbR/RY8YbgWuB/YC7gffa/m5Z\ndo/t1/SSX/uav6STgT+muoj2icDfAwdJehZ4p+2Hd/X4GeR3fAGVgWhgLyBgNdC3F5CknV5AJb+n\nF5Cks4D/Lelp4IPA5cB3qH4+/8E9nLIn6T+3af6IpH0BbP9Jt9kl/wrbS8v0bwCfYUff32v7S73k\nA3cBJwNPSvow8FbgJuCDkk62vazH/HskfRe4DrjO9roe83YiaRnwXuAXkj4BfAj4KvAxSVfZ/uMe\n8wf6twt8Eniz7Y3Ttns08GXg2F7CJf3pLhb345r7nwB+C1gH/A6wWtI7bX+tD9mNONtnLXBwmT6a\n6hxhgLcAt/Qhfz1wVJv2o6n2gHrN/9Nd3H7Yh/y7gFdSnUHxNqo3sV8ty+7pQ/69wCHl5/ET4NjS\nfiTVp6Nesn8EXA98tNwuBJ6cmu9D3+9pmZ4ETijT/xy4uw/532qZvhvYr0zPoT9ng9wD/ApwUfm9\n3gssa/d67TJ/HdVe50vL72Lq72x/qk8vveYP+m93A/DCNu1705+ziX5I9eZ4DnB2y+0cYGsf8u+d\nNv9KqgtgntGPv93a7/kDL7D9RJn+HtWgg+3V5TziXu3FjnOQW22mP5+czqHao/o5O/9fAwG/24f8\nvW3fX6Y/J+nbwF+qD/8nuXjOpQYs6bsuH9ltPyTphT1mLwD+hGqwudD2TySdbftjPea2c6DtbwDY\n/kdJ/bj0yQ8lvcr2fcATVAPpT4EXUv1+e+aq/PIRqk9EC4HFwN9J+p7tX+sxfpvtn0r6BdUb+w/K\nNn8s6fkes2Hwf7tXAV+XdB07PrUfQfUzuqoP+XdRvcF/dfoCSRf2If8Xkg6Z+vuyfb+kU4AvAf+i\n1/AmDP53S7oSuB04rdwjaX/6c+2ivIB2Q9ILXNW139XSNodqkOua7e8Bb5N0BnCrpMt66+k/cayk\n+8r00ZJeYvtJVf9Tutc3Lqj2Cj8l6V7gceAuSX8DvAr4eB/yd2L7TuDOUi57Qx8i7y+v+/2BW4CV\nkm4E3gR8sw/5A/3btf1xSV+g+pewry/Nm4HfdX9KZL8D/KzDto/qQ/4FVJ+qtx9gt72plMve32t4\n7Q/4loNq7wGOo3pBXmX7OUn7AfM8rd7X5TYWUL2Atp/tA3yxHy8gSXOBn9n+Sa9ZHfLfAjxhe+20\n9oOA99v+wx7zT6IqYfx0WvtRwG/Y/lQv+S15L6Yq+5xkux8D21QfWz1i+xeSXgq8wfZf9mEbc4BT\ngWOodrYeBm52fw4o/1vbn+41Zxf5+1Lt5Dxq+2ZJ7wB+jaoU+n9s/7zH/IH/7UZntR/8IyLaKTs4\ny6hq5POoyqqPA58HLu71Dbju+bW/pLOk10m6XdKnJB0habWkpyV9XVJPZ7KU/AMk/XdJ90t6RtL3\nJd0p6Zw+dD/5s8++ow59b3B+bX7+wEqqEwQmgLm25wJvpDq7aOW459d+z1/S14E/oDq16hPA7wOf\no6pL/qHtX+0x/4vAjcCtwL8BXgx8FvivVF94+UjyB5Nf574nfyTyH7B9zGyXjUt+z6eDDfvGzqfr\nfW/asrV9yJ9+utVd5f4FwD8kf3D5de578kcifzXwX6iOH0y1HQKcD9w67vm1L/sAz0r6LUlnUn0Z\n962w/QskPR2QKn4s6TdL5unAVgCXb20mf6D5de578oeffxbVdxT+WtKTkp6k+j7HLwFnjn1+r+8e\nw75RXQFwkupbjkdSfYR8BvgG8No+5P8r4OtUdbavAv+ytB8MnJv8weXXue/JH35+yToOeDNwwLT2\nReOe33PnRvkGvGvA+e9O/nDy69z35O+ZfOBcqm/Efh54CDijZVk/vt1e7/xB/gKHfQMeTn4z8+vc\n9+TvmXzgW8CLy/RRVJfY+ECZ78fgXOv82n/DVzu+odnOvOTXN7/OfU/+8POpzmb8EYDtjeU44A2S\njqQ/l9eodX7tB3/gl4FFVOfDTvf3ya91fp37nvzh5z8u6XiXb7fb/pGk3wauBF497vlNGPy/RPXR\n6J7pCyT9dfJrnV/nvid/+Pn/Dtjpf1jYflbS2cCfjXt+7b/kFRERs9eE8/wjImKWMvhHRIyhDP4R\nEWMog39ExBjK4B+xh6g//xoyoi/yYoxoQ9LHJJ3XMv9Hks6V9GFJayR9Uy3/ZlPSjZLukvQtSe9p\naf+RpP8haS07/pVgxNBl8I9o7yqq86yn9tjPovpfqq+wfRLwGuDEqatSUl2L5rXA64BzJb2ktL8I\nuMP28bb78cWliL5owpe8IvrO9kOStko6nuoa6vdQDeynSpr6UtL+wCuAvwXOU/WP5gGOAOYDa4Dn\ngBv2aOcjZiCDf0Rnfw68i+o6M1cBpwAft73TtyslTZRlr7f9M0m3A/uWxT9zvkkZIyhln4jObqS6\n9sxrgVXAzcC7Je0PIOlwSQcD/wx4sgz8x5LaftRA9vwjOijXUfkK1cBuYLWk44CvSQL4IfAOqjeG\n35O0jur6619rjdnD3Y6YkVzbJ6KDcqD3buBttr8z7P5E9FPKPhFtSFoAbKD6R9kZ+KNxsucfETGG\nsucfETGGMvhHRIyhDP4REWMog39ExBjK4B8RMYYy+EdEjKH/D99AFgdHHsqVAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x7fa259c41f28>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Using groupby(), plot the number of films\n",
    "# that have been released each decade in the history of cinema.\n",
    "\n",
    "t = titles\n",
    "t.groupby(t.year // 10 * 10).size().plot(kind='bar')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x7fa26f513518>"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXAAAAEdCAYAAAAVczy7AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAH5pJREFUeJzt3XuQZGd53/HvT1pUXIStEJwFJMWrBHFRBbxCWGzERSPH\nELFFCVIhARLAC1X2plRboopAwJRSESm7sOMLAkeAUkZZcCVSCDYqyayswqCXIC4LknaWFSthyTD2\nShiBLS0gFsxFT/4472h7Wz3TPb19+jxn5vep2to+fc6e/qq79c7MMz09igjMzKx/Tug6wMzMpuMF\n3Mysp7yAm5n1lBdwM7Oe8gJuZtZTXsDNzHpqogVc0omS9km6foX975V0l6T9ks6ebaKZmY0y6Wfg\nbwIOAo940bik7cBTI+JM4NeA988uz8zMVjJ2AZd0GrAd+ENAIw65CPgQQETsBU6RtHmWkWZm9kiT\nfAb+buCtwEMr7D8VODSwfQ9w2nF2mZnZGKsu4JJeBnwrIvYx+rPvhw8d2vbP55uZtWzTmP3nARfV\nOfejgZ+R9OGIeP3AMfcCpw9sn1avO4YkL+pmZlOIiNGfQEfERH+A84HrR1y/HdhTL28DvrDCv49J\nb2uVhsuO9xzroSFLR4aGLB0ZGrJ0ZGiYVwcQEKv8+S9j9hOT3MZK+8Z9Bv6I9R5A0s561isjYo+k\n7ZLuBr4PvGGN51yLLS2ee1Jbug6otnQdQI4GyNGxpeuAakvXAeRogBQdS62efeIFPCI+DXy6Xr5y\naN+uGXeZmdkYfftJzN1dB5CjAXJ07O46oNrddQA5GiBHx+6uA6rdXQfAjlbPrjpjaZ2kiJUG8WZm\nPdS8OON41lAxbl1cbe3s1Wfgkhbc0MjQkaEBcnRkaIAcHRkaIEtHafXsvVrAzczsKI9QzMym5BGK\nmZlNpVcLeIaZVoYGyNGRoQFydGRogBwdGRogS0dp9ey9WsDNzOwoz8DNzKbkGbiZmU2lVwt4hplW\nhgbI0ZGhAXJ0ZGiAHB0ZGiBLR2n17L1awM3M7CjPwM3MpuQZuJmZTaVXC3iGmVaGBsjRkaEBcnRk\naIAcHRkaIEtHafXsvVrAzczsKM/Azcym5Bm4mZlNpVcLeIaZVoYGyNGRoQFydGRogBwdGRogS0dp\n9exjF3BJj5a0V9KipIOS3jXimAVJ35G0r/65tJ1cMzNbNtEMXNJjI+KIpE3AzcBbIuLmgf0LwJsj\n4qJVzuEZuJmtK72YgUfEkXrxJOBE4P6RJWZmNjcTLeCSTpC0CNwH3BQRB4cOCeA8Sfsl7ZF01qxD\na8dCG+ftWwPk6MjQADk6MjRAjo4MDZClo7R69kk/A38oIrYCpwEvGnHH3AacHhG/APwBcO1MK83M\n7BE2reXgiPiOpI8Dz2XgQ0tEfG/g8g2S3ifpCRFxzKhF0m5gqW4eBhYjotR9C/Xfr7o9cK6Jjl+v\n28vXdd0z2NLV/RERxY9Hnu0Mj8e8np9Hlfr3whq3H9lXL++ou5ZYxdhvYkp6IvCTiDgs6THAjcA7\nI+KTA8dsBr4VESHpXOAjEbFl6Dz+JqaZrSt9+Cbmk4FP1Rn4XuD6iPikpJ2SdtZjXgkcqMdcDrx6\n8v+AyWWYaWVogBwdGRogR0eGBsjRkaEBsnSUVs8+doQSEQeA54y4/sqBy1cAV8w2zczMVuP3QjEz\nm1IfRihmZpZQrxbwDDOtDA2QoyNDA+ToyNAAOToyNECWjtLq2Xu1gJuZ2VGegZuZTckzcDMzm0qv\nFvAMM60MDZCjI0MD5OjI0AA5OjI0QJaO0urZe7WAm5nZUZ6Bm5lNyTNwMzObSq8W8AwzrQwNkKMj\nQwPk6MjQADk6MjRAlo7S6tl7tYCbmdlRnoGbmU3JM3AzM5tKrxbwDDOtDA2QoyNDA+ToyNAAOToy\nNECWjtLq2Xu1gJuZ2VGegZuZTckzcDMzm0qvFvAMM60MDZCjI0MD5OjI0AA5OjI0QJaO0urZV13A\nJT1a0l5Ji5IOSnrXCse9V9JdkvZLOrudVDMzGzR2Bi7psRFxRNIm4GbgLRFx88D+7cCuiNgu6XnA\neyJi24jzeAZuZutK+hl4RBypF08CTgTuHzrkIuBD9di9wCmSNo87r5mZHZ+xC7ikEyQtAvcBN0XE\nwaFDTgUODWzfA5w2u8RjWhbaOG/fGiBHR4YGyNGRoQFydGRogCwdpdWzbxp3QEQ8BGyV9LPAjZIW\nImK4avjT+5FfU0jaDSzVzcPA4vK5mi9FxpNWn8Isf6mx/OANnH8m2wMdrZx/0m2ax6Sz26/bW6nP\n0K7vj663yfF4PKzr+yPJduvPz6NK/XthaHuy/YPnr5d31F1LrGJNrwOX9J+BH0TE7w5c9wGgRMQ1\ndftO4PyIuG/o3646Az/+WRJMMk8yM5uV1DNwSU+UdEq9/BjgxcC+ocOuA15fj9kGHB5evM3MbPbG\nzcCfDHyqzsD3AtdHxCcl7ZS0EyAi9gBfk3Q3cCVwcXu5pb1TTyjHXC1HR4YGyNGRoQFydGRogCwd\npdWzrzoDj4gDwHNGXH/l0PauGXeZmdkYad4LxTNwM+ub1DNwMzPLq2cLeOk6IMlcLUdHhgbI0ZGh\nAXJ0ZGiALB2l1bP3bAE3M7NlnoGbmU3JM3AzM5tKzxbw0nVAkrlajo4MDZCjI0MD5OjI0ABZOkqr\nZ+/ZAm5mZss8Azczm5Jn4GZmNpWeLeCl64Akc7UcHRkaIEdHhgbI0ZGhAbJ0lFbP3rMF3MzMlnkG\nbmY2Jc/AzcxsKj1bwEvXAUnmajk6MjRAjo4MDZCjI0MDZOkorZ69Zwu4mZkt8wzczGxKnoGbmdlU\neraAl64DkszVcnRkaIAcHRkaIEdHhgbI0lFaPfvYBVzS6ZJukvQVSbdLumTEMQuSviNpX/1zaTu5\nZma2bOwMXNKTgCdFxKKkk4FbgVdExB0DxywAb46Ii1Y5j2fgZraupJ+BR8Q3I2KxXn4QuAN4ysgS\nMzObmzXNwCVtAc4G9g7tCuA8Sfsl7ZF01mzyhpV2TrsGOeZqOToyNECOjgwNkKMjQwNk6Sitnn3T\npAfW8clHgTfVz8QH3QacHhFHJL0UuBZ42ohz7AaW6uZhYDEiytEjCrAwcJmh7cUx+4+5rQWA5fPP\narvt80+6DWyV1Nnt1+2t1Du+6/uj621yPB4P6/r+SLLd+vPzqFL/Xhjanmz/4Pnr5R111xKrmOh1\n4JIeBfwpcENEXD7B8V8HzomI+weu8wzczNaV9DNwSQI+CBxcafGWtLkeh6RzaT4w3D/qWDMzm41J\nZuDPB14LXDDwMsGXStopaWc95pXAAUmLwOXAq9vJLe2cdg1yzNVydGRogBwdGRogR0eGBsjSUVo9\n+9gZeETczJiFPiKuAK6YVZSZmY3n90IxM5tS+hm4mZnl1LMFvHQdkGSulqMjQwPk6MjQADk6MjRA\nlo7S6tl7toCbmdkyz8DNzKbkGbiZmU2lZwt46TogyVwtR0eGBsjRkaEBcnRkaIAsHaXVs/dsATcz\ns2WegZuZTckzcDMzm0rPFvDSdUCSuVqOjgwNkKMjQwPk6MjQAFk6Sqtn79kCbmZmyzwDNzObkmfg\nZmY2lZ4t4KXrgCRztRwdGRogR0eGBsjRkaEBsnSUVs/eswXczMyWeQZuZjYlz8DNzGwqPVvAS9cB\nSeZqOToyNECOjgwNkKMjQwNk6Sitnn2S30p/uqSbJH1F0u2SLlnhuPdKukvSfklnzz7VzMwGjZ2B\nS3oS8KSIWJR0MnAr8IqIuGPgmO3ArojYLul5wHsiYtvQeTwDN7N1Jf0MPCK+GRGL9fKDwB3AU4YO\nuwj4UD1mL3CKpM0T1JuZ2ZTWNAOXtAU4G9g7tOtU4NDA9j3AaccTNlqZ/SnXKMdcLUdHhgbI0ZGh\nAXJ0ZGiALB2l1bNvmvTAOj75KPCm+pn4Iw4Z2n7E1xWSdgNLdfMwsBgR5egRBVgYuMzQ9uKY/cfc\n1gLA8vlntd32+SfdBrZK6uz26/ZW6h3f4v19ExOQxk7OLjjOnrFfJ0/Q8PCXy31+fs7ovmj98Zik\n43gfj6NK/XthaHuy/UP37wKwo+5aWq1/oteBS3oU8KfADRFx+Yj9HwBKRFxTt+8Ezo+I+waO8Qzc\n1izL8yJLRwbzmPu235Clo+UZuJoPYR8EDo5avKvrgNfX47cBhwcXbzMzm71JZuDPB14LXCBpX/3z\nUkk7Je0EiIg9wNck3Q1cCVzcTm5p57RrkGOulqMjQ0OjdB1AjoYsj0npOqAqXQfQ+Qw8Im5msler\n7JpJkZmZTcTvhWKpZXleZOnIwDPwWXb4vVDMzDakni3gpeuAJDPGHB0ZGhql6wByNGR5TErXAVXp\nOoDO3wvFzMxy8gzcUsvyvMjSkYFn4LPs8AzczGxD6tkCXroOSDJjzNGRoaFRug4gR0OWx6R0HVCV\nrgPwDNzMzEbyDNxSy/K8yNKRgWfgs+zwDNzMbEPq2QJeug5IMmPM0ZGhoVG6DiBHQ5bHpHQdUJWu\nA/AM3MzMRvIM3FLL8rzI0pGBZ+Cz7PAM3MxsQ+rZAl66DkgyY8zRkaGhUboOIEdDlsekdB1Qla4D\n8AzczMxG8gzcUsvyvMjSkYFn4LPs8AzczGxD6tkCXroOSDJjzNGRoaFRug4gR0OWx6R0HVCVrgPo\nfAYu6SpJ90k6sML+BUnfGfiFx5fOPtPMzIaNnYFLeiHwIPDhiHjWiP0LwJsj4qIx5/EM3NYsy/Mi\nS0cGnoHPsqPlGXhEfAZ4YGyFmZnN1Sxm4AGcJ2m/pD2SzprBOVdQ2jv1hHLMGHN0ZGholK4DyNGQ\n5TEpXQdUpesA2m7YNINz3AacHhFHJL0UuBZ42qgDJe0GlurmYWAxIsrRIwqwMHCZoe3FMfuPua0F\ngOXzz2q77fNPug1sldTZ7dftrdQ7vu37e+XHe7LtGdzfrP78XJywh5n0dP38zP94FOaxXhzbsvL5\n13L79fKOumuJVUz0OnBJW4DrR83ARxz7deCciLh/6HrPwG3NsjwvsnRk4Bn4LDs6fh24pM2SVC+f\nS/NB4f4x/8zMzI7TJC8jvBr4HPB0SYckvVHSTkk76yGvBA5IWgQuB17dXm5p79QTyjFjzNGRoaFR\nug4gR0OWx6R0HVCVrgPofAYeEa8Zs/8K4IqZFZmZ2UT8XiiWWpbnRZaODDwDn2WH3wvFzGxD6tkC\nXroOSDJjzNGRoaFRug4gR0OWx6R0HVCVrgPo/L1QzMwsJ8/ALbUsz4ssHRl4Bj7LDs/Azcw2pJ4t\n4KXrgCQzxhwdGRoapesAcjRkeUxK1wFV6ToAz8DNzGwkz8AttSzPiywdGXgGPssOz8DNzDakni3g\npeuAJDPGHB0ZGhql6wByNGR5TErXAVXpOgDPwM3MbCTPwC21LM+LLB0ZeAY+yw7PwM3MNqSeLeCl\n64AkM8YcHRkaGqXrAHI0ZHlMStcBVek6AM/AzcxsJM/ALbUsz4ssHRl4Bj7LDs/Azcw2pJ4t4KXr\ngCQzxhwdGRoapesAcjRkeUxK1wFV6TqAzmfgkq6SdJ+kA6sc815Jd0naL+ns2SaamdkoY2fgkl4I\nPAh8OCKeNWL/dmBXRGyX9DzgPRGxbcRxnoHbmmV5XmTpyMAz8Fl2tDwDj4jPAA+scshFwIfqsXuB\nUyRtHndeMzM7PrOYgZ8KHBrYvgc4bQbnHaG0c9o1yDFjzNGRoaFRug4gR0OWx6R0HVCVrgNou2HT\njM4z/On9yK8pJO0GlurmYWAxIsrRIwqwMHCZoe3FMfuPua0FgOXzT7oN3DSqfejc4w4BuGCa24+I\n0nxZNt4EHRdMc/sD2zO5LyJCx/F4VKX+vTDV9rS3P/nzc3HCHo6nZ+zjUY9ddf/xPB5H74/l/54F\nptlu//EozGm9mOj8a7n9enlH3bXEKiZ6HbikLcD1K8zAPwCUiLimbt8JnB8R9w0d14sZeIaODA1Z\nOjI0ZOnI0DCbjgwNWTq6fx34dcDr6w1tAw4PL95mZjZ7k7yM8Grgc8DTJR2S9EZJOyXtBIiIPcDX\nJN0NXAlc3F5uae/UEytdB1Sl6wByNECOjtJ1QFW6DiBHA+ToKK2efewMPCJeM8Exu2aTY2Zmk/J7\noSTsyNCQpSNDQ5aODA2z6cjQkKWj+xm4mZl1oGcLeOk6gBwNkKOjdB1Qla4DyNEAOTpK1wFV6TqA\nzt8LxczMcvIMPGFHhoYsHRkasnRkaJhNR4aGLB2egZuZbUg9W8BL1wHkaIAcHaXrgKp0HUCOBsjR\nUboOqErXAXgGbmZmI3kGnrAjQ0OWjgwNWToyNMymI0NDlg7PwM3MNqSeLeCl6wByNECOjtJ1QFW6\nDiBHA+ToKF0HVKXrADwDNzOzkTwDT9iRoSFLR4aGLB0ZGmbTkaEhS4dn4GZmG1LPFvDSdQA5GiBH\nR+k6oCpdB5CjAXJ0lK4DqtJ1AJ6Bm5nZSJ6BJ+zI0JClI0NDlo4MDbPpyNCQpcMzcDOzDalnC3jp\nOoAcDZCjo3QdUJWuA8jRADk6StcBVek6gBQzcEkXSrpT0l2S3jZi/4Kk70jaV/9cOvtUMzMbNHYG\nLulE4KvALwP3Al8CXhMRdwwcswC8OSIuWuU8noH3qCFLR4aGLB0ZGmbTkaEhS0f7M/BzgbsjYiki\nfgxcA7x8ZImZmc3NJAv4qcChge176nWDAjhP0n5JeySdNavAY5V2TrsmpeuAqnQdQI4GyNFRug6o\nStcB5GiAHB2l1bNvmuCYSb4+uA04PSKOSHopcC3wtOGDJO0GlurmYWAxIsrRIwqwMHCZoe3FMfuP\nua0FgOXzT7p9bMvK5195/8Jx3f7R+2P18zf3xWr7m3NOe/uT3R8ZHo/Jto//8Vg+50q3N+7xGDjN\ncfQc27Ly+du6/cmfn6tvt/94FHI8PyfbP3j+enlH3bXEKiaZgW8DLouIC+v2rwMPRcRvr/Jvvg6c\nExH3D1znGXiPGrJ0ZGjI0pGhYTYdGRqydLQ/A78FOFPSFkknAa8Crhu6gc2SVC+fS/OB4f5HnsrM\nzGZl7AIeET8BdgE3AgeB/xMRd0jaKWlnPeyVwAFJi8DlwKvbyS3tnHZNStcBVek6gBwNkKOjdB1Q\nla4DyNEAOTpKq2efZAZORNwA3DB03ZUDl68ArphtmpmZrcbvhZKwI0NDlo4MDVk6MjTMpiNDQ5YO\nvxeKmdmG1LMFvHQdQI4GyNFRug6oStcB5GiAHB2l64CqdB1AivdCMTOzfDwDT9iRoSFLR4aGLB0Z\nGmbTkaEhS4dn4GZmG1LPFvDSdQA5GiBHR+k6oCpdB5CjAXJ0lK4DqtJ1AJ6Bm5nZSJ6BJ+zI0JCl\nI0NDlo4MDbPpyNCQpcMzcDOzDalnC3jpOoAcDZCjo3QdUJWuA8jRADk6StcBVek6AM/AzcxsJM/A\nE3ZkaMjSkaEhS0eGhtl0ZGjI0uEZuJnZhtSzBbx0HUCOBsjRUboOqErXAeRogBwdpeuAqnQdgGfg\nZmY2kmfgCTsyNGTpyNCQpSNDw2w6MjRk6fAM3MxsQxq7gEu6UNKdku6S9LYVjnlv3b9f0tmzz1xW\n2jv1xErXAVXpOoAcDZCjo3QdUJWuA8jRADk6SqtnX3UBl3Qi8N+BC4GzgNdIeubQMduBp0bEmcCv\nAe9vqRVYbO/UE8vQADk6MjRAjo4MDZCjI0MD5Ohot2HcZ+DnAndHxFJE/Bi4Bnj50DEXAR8CiIi9\nwCmSNs+8FIDD7Zx2TTI0QI6ODA2QoyNDA+ToyNAAOTrabRi3gJ8KHBrYvqdeN+6Y044/zczMVjNu\nAZ/026vD3yFt6aUtS+2cdk2Wug6olroOIEcD5OhY6jqgWuo6gBwNkKNjqdWzr/oyQknbgMsi4sK6\n/evAQxHx2wPHfAAoEXFN3b4TOD8i7hs613xer2hmts6s9DLCTWP+3S3AmZK2AN8AXgW8ZuiY64Bd\nwDV1wT88vHivFmBmZtNZdQGPiJ9I2gXcCJwIfDAi7pC0s+6/MiL2SNou6W7g+8AbWq82M7P5/SSm\nmZnNln8S08ysp8bNwM3M0pN0IfAKjr7M+V7g2oj4s/XckHaEslEfkKwdGRqydGRoyNKRpOE9wJnA\nh+vtQ/OzKK+j+UHES9ZrQ8oFfCM/IBk7MjRk6cjQkKUjQ0PtuKu+lcfw9QLuioinrtuGiEj3p/4H\nj7peNE+MDdGQpSNDQ5aODA1ZOjI01Ns7AJw74vrnAQfWc0PWGfgPJZ0bEV8cuv5c4AcbqCFLR4aG\nLB0ZGrJ0ZGgA2AG8X9Ljad7KA5qvBL5b963bhqwjlHNo3tVw1J1xcUTcuhEasnRkaMjSkaEhS0eG\nhqGeJwNPqZv3RsQ353n7Aw0Pfz8gIv6m1dvLuIAvm/edkbVhRMc9G+HJOUFHsEH+R52wo+vnRQDf\n6Oj/U9GMKx6+L4AvRoIFTtIzIuLOVs6d4L9vTdq8M1a4vUdF81a6g9c9MSL+dl4NI5oujoj3dXj7\nj6f55tXXImJu79kp6STgJxHxUN3+JeA5wFci4oY5NTw7Ir48j9saR9I/Br4bEYclnQGcA9wZEbfP\nueMXaT7z/inwF/P8/7Pe/kuA9wF3c+xXAmfSfCVw4zx7hkk6FBGnt3LuHi7grd0ZQ7dzAfBHwGOA\nW4GdEfH1um9fRLT4m4eO6fiPI65+B/CbABHx+3NoeF9EXFwvvwD438Bf0vwPsjMiPt52Q73tL9O8\nUdoDkt4K/CtgD3A+cGtEvH0ODT8Fvg5cDVwdEQfbvs0VOt4O7AR+BPwO8Bbgs8A24KqI+L05NJwP\n/B7Nm16fA3wOOAX4MfC6iDi0yj+fZcedwIURsTR0/RnADRHxjDk0/MEqu3dExOPbuN2U38Qcc2ec\nMqeM3wH+JXAQ+NfAJyS9LiI+P6fbX/ZO4OO1A5rv8J9AM3ecl38+cPk3gFdExG2S/gnwf2vfPJwQ\nEQ/Uy68GXhARP5D0W8A+oPUFHPgyzcvk/h1wnaQjNB/QrhleQFr2eprfkvU4mvcsPSMivi3pccAX\naRbWtr0HeHG93TOAd0fE8yW9GPgg8JI5NEDzPk33jrj+Xua3xu2g+SD69xz7dtqiea60IuUCTkd3\nxpCTIuIr9fJHJd0B/MlKvxe0RWcBv0/zP+plEXFE0q9ExDvn3LHsZyPiNoCI+Jqkeb4dw/ckPSsi\nDgDfpvnq6AfAo3jke9K3po4o3gG8Q9LzaD6Y3CzpryPivDll/KR+8PoRcAS4v7Z9X9JDc2o4ISK+\nXS//NfDzteET9TXi83IV8CVJV3N0hHI6zeNy1ZwabgFuj4jPDu+QdFlbN5pyhCLpJuDSFe6MpYjY\nMoeGW4CXDX5TSNJpNJ9t/tOIOLnthqGeVwD/CXg38N8i4ow53vYPaOaLAGcAp9cxxonA/oj4Z3Pq\neDbNWOvLNB/YXwD8P+BZwO9HxP+aQ8PI8Vn9QPaiiChtN9Tbu7pefBzNqz4eA3wM+CWaTz5eO4eG\n/wk8BNxE86sV74mIN9evAm6dx+hioOUsml/3+PCrUIDr5jXikvQE4IcRcWQet/fw7SZdwDu5M4Ya\nXgx8OyIWh64/BdgVEb/RQdPJwGU0PzDwojne7pahq74RET+S9ESaRetP5tiyieZL86fRfAV5CLhx\nXt9MlfTv5/GBYoKOR9N8hvk3EXGjpNcC5wF3AldGxN/PoeEk4FeBZwL7aWbvP5X0GGDznEdKG1LK\nBdzMbFL1k6q307wny2aar86+BVwL/NY8Prh31ZDy7WQlPV7Sf5X0FUnflfS3kvZK2rGRGlbp+ILv\nCz8v/Lx42EeAB4AF4AkR8QTgAppXx3xkPTek/Axc0nU087w/B/4NcDJwDXApzZztHRuhIUtHhoYs\nHRkasnRkaKgdfxERT1vrvnXREHN6w5m1/AG+PLR9S/37BOCrG6UhS0eGhiwdGRqydGRoqLf3CZpv\n8G8euO5JwNuAP1/PDSlHKMD3Jb0QQNLLgb8DiPoTeBuoIUtHhoYsHRkasnRkaIDml60/Efi0pAck\nPQAU4B8C/3ZdN8zro+QaP5r9AvAlmvnRZ4Gn1+t/DrhkozRk6cjQkKUjQ0OWjgwNAy3PBH4ZePzQ\n9Reu54a53cEzvJPe6IY8HRkasnRkaMjSMc8G4BLgqzSv+Pgrmp8UXt63bz03pPwm5mo0p/dCyd6Q\npSNDQ5aODA1ZOubZIOl2YFtEPFh/ZuGPgT+KiMtX+sGr9dKQ8kfpJR1YZffmjdKQpSNDQ5aODA1Z\nOjI0VIqIBwEiYknNm2z9saSfZ35vsdBJQ8oFHPhHwIU0r6sc9rkN1JClI0NDlo4MDVk6MjQAfEvS\n1qg/NV0/C34ZzRtqPXs9N2RdwD8OnBwR+4Z3SPr0BmrI0pGhIUtHhoYsHRkaoHlnxmPesz8ifizp\nV4D/sZ4bejcDNzOzRtbXgZuZ2RhewM3MesoLuJlZT3kBNzPrKS/gZhPSfH99nNlYfkLauiTpnZLe\nNLD9m5IukfRWSV+UtF8Dv6tQ0sck3SLpdkm/OnD9g5J+V9IizW98N0vDC7itV1fRvDZ3+TPnVwHf\nBJ4aEecCZwPnLL+bHs17dzwX+EXgEkn/oF7/WOALEbE1Iub5wylmY2X9QR6z4xIRfyXp7yRtpXlf\n5n00i/NLJC3/4MnjgKcCnwHepOYXR0PzG83PBL4I/JTmfS3M0vECbuvZHwJvoHlfjquAfwG8KyKO\n+ck4SQt137aI+KGkm4BH190/DP+0myXlEYqtZx+jea+O5wJ/BtwIvFHS4wAknSrp54CfAR6oi/cz\n8KzbesKfgdu6Vd+L4lM0i3MAn5D0TODzkgC+B7yWZnH/D5IO0ryn8+cHTzPnbLOJ+b1QbN2q37y8\nFXhlRPxl1z1ms+YRiq1Lks4C7qL5hbJevG1d8mfgZmY95c/Azcx6ygu4mVlPeQE3M+spL+BmZj3l\nBdzMrKe8gJuZ9dT/BxT1noPbB61OAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x7fa26f4ff358>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Use groupby() to plot the number of \"Hamlet\" films made each decade.\n",
    "\n",
    "t = titles\n",
    "t = t[t.title == 'Hamlet']\n",
    "t.groupby(t.year // 10 * 10).size().plot(kind='bar')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "year  type   \n",
       "1950  actor      603\n",
       "      actress    267\n",
       "1951  actor      626\n",
       "      actress    272\n",
       "1952  actor      590\n",
       "      actress    282\n",
       "1953  actor      629\n",
       "      actress    283\n",
       "1954  actor      620\n",
       "      actress    298\n",
       "1955  actor      602\n",
       "      actress    263\n",
       "1956  actor      609\n",
       "      actress    284\n",
       "1957  actor      703\n",
       "      actress    281\n",
       "1958  actor      695\n",
       "      actress    273\n",
       "1959  actor      672\n",
       "      actress    286\n",
       "dtype: int64"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# How many leading (n=1) roles were available to actors,\n",
    "# and how many to actresses, in each year of the 1950s?\n",
    "\n",
    "c = cast\n",
    "c = c[c.year // 10 == 195]\n",
    "c = c[c.n == 1]\n",
    "c.groupby(['year', 'type']).size()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "n  type   \n",
       "1  actor      6349\n",
       "   actress    2789\n",
       "2  actor      4354\n",
       "   actress    4375\n",
       "3  actor      5370\n",
       "   actress    3005\n",
       "4  actor      5370\n",
       "   actress    2735\n",
       "5  actor      5403\n",
       "   actress    2426\n",
       "dtype: int64"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# In the 1950s decade taken as a whole,\n",
    "# how many total roles were available to actors,\n",
    "# and how many to actresses, for each \"n\" number 1 through 5?\n",
    "\n",
    "c = cast\n",
    "c = c[c.year // 10 * 10 == 1950]\n",
    "c = c[c.n < 6]\n",
    "c.groupby(['n', 'type']).size()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>n</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>year</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1963</th>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2006</th>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       n\n",
       "year    \n",
       "1963  15\n",
       "2006  50"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Use groupby() to determine how many roles are listed\n",
    "# for each of the Pink Panther movies.\n",
    "\n",
    "c = cast\n",
    "c = c[c.title == 'The Pink Panther']\n",
    "c = c.sort('n').groupby(['year'])[['n']].max()\n",
    "c"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "year  title                                   \n",
       "1979  The Muppet Movie                            8\n",
       "1981  An American Werewolf in London              2\n",
       "      The Great Muppet Caper                      6\n",
       "1982  The Dark Crystal                            2\n",
       "1984  The Muppets Take Manhattan                  7\n",
       "1985  Sesame Street Presents: Follow that Bird    3\n",
       "1992  The Muppet Christmas Carol                  7\n",
       "1996  Muppet Treasure Island                      4\n",
       "1999  Muppets from Space                          4\n",
       "      The Adventures of Elmo in Grouchland        3\n",
       "dtype: int64"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# List, in order by year, each of the films\n",
    "# in which Frank Oz has played more than 1 role.\n",
    "\n",
    "c = cast\n",
    "c = c[c.name == 'Frank Oz']\n",
    "g = c.groupby(['year', 'title']).size()\n",
    "g[g > 1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "character\n",
       "Grover            2\n",
       "Bert              3\n",
       "Cookie Monster    3\n",
       "Fozzie Bear       4\n",
       "Sam the Eagle     5\n",
       "Yoda              5\n",
       "Animal            6\n",
       "Miss Piggy        6\n",
       "dtype: int64"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# List each of the characters that Frank Oz\n",
    "# has portrayed at least twice.\n",
    "\n",
    "c = cast\n",
    "c = c[c.name == 'Frank Oz']\n",
    "g = c.groupby(['character']).size()\n",
    "g[g > 1].order()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "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 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.4.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}