Exercises-3.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "%matplotlib inline\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "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": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\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>Burgtheater</td>\n",
       "      <td>1936</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Main Hoon Angrakshak</td>\n",
       "      <td>2003</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Faded Memories</td>\n",
       "      <td>2008</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Cinema Six</td>\n",
       "      <td>2012</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>I Want Your Love</td>\n",
       "      <td>2012</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  title  year\n",
       "0           Burgtheater  1936\n",
       "1  Main Hoon Angrakshak  2003\n",
       "2        Faded Memories  2008\n",
       "3            Cinema Six  2012\n",
       "4      I Want Your Love  2012"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "titles = pd.read_csv('data/titles.csv', index_col=None)\n",
    "titles.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\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>Closet Monster</td>\n",
       "      <td>2015</td>\n",
       "      <td>Buffy #1</td>\n",
       "      <td>actor</td>\n",
       "      <td>Buffy 4</td>\n",
       "      <td>31.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</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.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Battle of the Sexes</td>\n",
       "      <td>2017</td>\n",
       "      <td>$hutter</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bobby Riggs Fan</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Secret in Their Eyes</td>\n",
       "      <td>2015</td>\n",
       "      <td>$hutter</td>\n",
       "      <td>actor</td>\n",
       "      <td>2002 Dodger Fan</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Steve Jobs</td>\n",
       "      <td>2015</td>\n",
       "      <td>$hutter</td>\n",
       "      <td>actor</td>\n",
       "      <td>1988 Opera House Patron</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  title  year      name   type                character     n\n",
       "0        Closet Monster  2015  Buffy #1  actor                  Buffy 4  31.0\n",
       "1       Suuri illusioni  1985    Homo $  actor                   Guests  22.0\n",
       "2   Battle of the Sexes  2017   $hutter  actor          Bobby Riggs Fan  10.0\n",
       "3  Secret in Their Eyes  2015   $hutter  actor          2002 Dodger Fan   NaN\n",
       "4            Steve Jobs  2015   $hutter  actor  1988 Opera House Patron   NaN"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cast = pd.read_csv('data/cast.csv', index_col=None)\n",
    "cast.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "### Using groupby(), plot the number of films that have been released each decade in the history of cinema."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x1a881155438>"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYcAAAEKCAYAAAD5MJl4AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4xLCBo\ndHRwOi8vbWF0cGxvdGxpYi5vcmcvAOZPmwAAIABJREFUeJzt3Xt8VPWd//HXh0CAJJCEQLgkQLgE\nbygKKWDF1mqraN1iL7Z2u5Vad+n21+623e62ut3faq9r++v95q5rbbHdrrrturKtFlmrK+CNIBYF\nhAzhFkBISAi5ALl9fn/MNzglAQYMc2aS9/PxmMec+ZzvTL4nk+Sd8z3fOcfcHRERkUSDou6AiIik\nH4WDiIj0oHAQEZEeFA4iItKDwkFERHpQOIiISA8KBxER6UHhICIiPSgcRESkh8FRd+BMjR492svK\nyqLuhohIxli7dm2du49Jpm3GhkNZWRmVlZVRd0NEJGOY2Y5k22pYSUREelA4iIhIDwoHERHpQeEg\nIiI9KBxERKQHhYOIiPSgcBARkR4UDiIiGeJ/Nu7j3pXVdHad/cs7KxxERDLEA2t2cf+zO8gaZGf9\naykcREQyQHtnF89VH2BB+eiUfD2Fg4hIBvjDroM0H+1gwXSFg4iIBKtidZjBm6cVpeTrKRxERDLA\nqqo6LizJpyAnOyVfT+EgIpLmmo60s27XwZQNKYHCQUQk7T1fXU9nlyscRETkdatidQwbMojZkwtT\n9jUVDiIiaW5VrI43lY1i2JCslH1NhYOISBp7rfEIsf3NXJ6izzd0UziIiKSxVbE6ABZMT+rSz31G\n4SAiksZWVdVSlJvNueNGpPTrnjIczOwcM3sp4XbIzD5tZqPMbIWZVYX7wtDezOz7ZhYzs/VmNjvh\ntRaH9lVmtjihPsfMXg7P+b6Znf0Th4iIpDl3Z1XsAJdNH82gFJxPKdEpw8HdN7v7xe5+MTAHaAUe\nBm4DnnD3cuCJ8BjgWqA83JYAdwOY2SjgDmAeMBe4oztQQpslCc9b2CdbJyKSwTbva6Ku+WhKp7B2\nO91hpauAre6+A1gELA31pcANYXkRcL/HPQcUmNl44BpghbvXu3sDsAJYGNaNdPdn3d2B+xNeS0Rk\nwFpVFT/ecFmKD0bD6YfDTcC/h+Wx7r4XINwXh3oJsCvhOTWhdrJ6TS/1HsxsiZlVmlllbW3taXZd\nRCSzrIrVMXV0LiUFw1P+tZMOBzPLBt4F/MepmvZS8zOo9yy63+PuFe5eMWZMao/ci4ikUltHF89X\n16fsFN3HO509h2uBF919X3i8LwwJEe73h3oNMDHheaXAnlPUS3upi4gMWC/ubOBweyeXRXC8AU4v\nHD7I60NKAMuA7hlHi4FHEuo3h1lL84HGMOy0HLjazArDgeirgeVhXZOZzQ+zlG5OeC0RkQFpVVUd\nWYOMS1N0iu7jDU6mkZnlAO8APpZQvgt4yMxuBXYCN4b6o8B1QIz4zKZbANy93sy+DKwJ7b7k7vVh\n+ePAz4DhwGPhJiIyYK2K1TGrNJ+Rw4ZE8vWTCgd3bwWKjqsdID576fi2DnziBK9zH3BfL/VKYGYy\nfRER6e8aW9tZX3OQT75temR90CekRUTSzLPVB+hyWFAe3cQbhYOISJpZFaslJzuLiycWRNYHhYOI\nSJpZHTvA/KlFZA+O7k+0wkFEJI3UNLSyra4lsims3RQOIiJpZHU4RXeqr99wPIWDiEgaWVlVR/GI\noZQX50XaD4WDiEia6Opyntl6gAXTRxP1lQsUDiIiaWLj3kPUt7RFdj6lRAoHEZE00X1J0KgPRoPC\nQUQkbayO1TFjbB5jRw6LuisKBxGRdHCkvZMXttWnxV4DKBxERNLC2h0NHO3oinwKazeFg4hIGlhZ\nVcfgQcbcKdGcovt4CgcRkTSwKlbL7EmF5A1N6mTZZ53CQUQkYvUtbWzYcygtprB2UziIiETsma11\nuKfHFNZuCgcRkYitjtUxYuhgZpXmR92VY5IKBzMrMLNfmdmrZrbJzC41s1FmtsLMqsJ9YWhrZvZ9\nM4uZ2Xozm53wOotD+yozW5xQn2NmL4fnfN+i/ty4iEiKuDsrq+qYP62IwVnp8/96sj35HvA7dz8X\nmAVsAm4DnnD3cuCJ8BjgWqA83JYAdwOY2SjgDmAeMBe4oztQQpslCc9b+MY2S0QkM+ysb6Wm4XDa\nTGHtdspwMLORwFuAnwC4e5u7HwQWAUtDs6XADWF5EXC/xz0HFJjZeOAaYIW717t7A7ACWBjWjXT3\nZ8P1p+9PeC0RkX5tZVX6nDIjUTJ7DlOBWuCnZrbOzO41s1xgrLvvBQj3xaF9CbAr4fk1oXayek0v\n9R7MbImZVZpZZW1tbRJdFxFJb6tjdUzIH8bU0blRd+WPJBMOg4HZwN3ufgnQwutDSL3p7XiBn0G9\nZ9H9HnevcPeKMWOiu/C2iEhf6Ayn6L4sDU7RfbxkwqEGqHH358PjXxEPi31hSIhwvz+h/cSE55cC\ne05RL+2lLiLSr728u5HGw+1p9fmGbqcMB3d/DdhlZueE0lXARmAZ0D3jaDHwSFheBtwcZi3NBxrD\nsNNy4GozKwwHoq8Glod1TWY2P8xSujnhtURE+q3VaXSK7uMl+zntvwL+zcyygWrgFuLB8pCZ3Qrs\nBG4MbR8FrgNiQGtoi7vXm9mXgTWh3ZfcvT4sfxz4GTAceCzcRET6tZVVtZw3fiSj84ZG3ZUekgoH\nd38JqOhl1VW9tHXgEyd4nfuA+3qpVwIzk+mLiEh/0NrWwYs7DvKRy8qi7kqv0ucTFyIiA8gL2+pp\n6+xKyyElUDiIiERidayO7KxBzC0bFXVXeqVwEBGJwMqqOuZMLmR4dlbUXemVwkFEJMVqm47y6mtN\naTmFtZvCQUQkxZ7ZGp/CuiBNjzeAwkFEJOVWVtWRP3wIM0vS5xTdx1M4iIikkLuzOlbHZdOLyBqU\nXqfMSKRwEBFJoa21LextPJK2U1i7KRxERFKo+5QZl09P75OHKhxERFJoZVUdE0cNZ1JRTtRdOSmF\ng4hIinR0dvFc9QEWpPleAygcRERS5g81B2k+2pHWU1i7KRxERFJkZVUdZvDmaUVRd+WUFA4iIimy\nOlbHzAn5FOZmR92VU1I4iIikQPPRDtbtPJjWp8xIpHAQEUmB56sP0NHlXJ4BxxtA4SAikhIrq+oY\nOngQsycXRt2VpCQVDma23cxeNrOXzKwy1EaZ2Qozqwr3haFuZvZ9M4uZ2Xozm53wOotD+yozW5xQ\nnxNePxaem76fKRcROQOrY3XMnTKKYUPS8xTdxzudPYe3ufvF7t59udDbgCfcvRx4IjwGuBYoD7cl\nwN0QDxPgDmAeMBe4oztQQpslCc9beMZbJCKSZl5rPELV/uaMmMLa7Y0MKy0CloblpcANCfX7Pe45\noMDMxgPXACvcvd7dG4AVwMKwbqS7PxuuP31/wmuJiGS8VeGUGZlyMBqSDwcHHjeztWa2JNTGuvte\ngHBfHOolwK6E59aE2snqNb3UezCzJWZWaWaVtbW1SXZdRCRaq2N1FOVmc964kVF3JWmDk2x3mbvv\nMbNiYIWZvXqStr0dL/AzqPcsut8D3ANQUVHRaxsRkXTi7qyK1fHm6aMZlMan6D5eUnsO7r4n3O8H\nHiZ+zGBfGBIi3O8PzWuAiQlPLwX2nKJe2ktdRCTjbdnXTG3TURZMT/9PRSc6ZTiYWa6ZjeheBq4G\nXgGWAd0zjhYDj4TlZcDNYdbSfKAxDDstB642s8JwIPpqYHlY12Rm88MspZsTXktEJKOtrIoPgS8o\nT/+T7SVKZlhpLPBwmF06GPilu//OzNYAD5nZrcBO4MbQ/lHgOiAGtAK3ALh7vZl9GVgT2n3J3evD\n8seBnwHDgcfCTUQk462O1TF1dC4lBcOj7sppOWU4uHs1MKuX+gHgql7qDnziBK91H3BfL/VKYGYS\n/RURyRhtHV08v62e984uPXXjNKNPSIuInCUv7mygta0zo6awdlM4iIicJatjdQwymD81sw5Gg8JB\nROSsWVlVx6yJBeQPHxJ1V06bwkFE5CxoPNzO+pqDGXXKjEQKBxGRs+DZrQfochQOIiLyutWxOnKy\ns7hkUmacovt4CgcRkbNgVayOeVNGkT04M//MZmavRUTSWE1DK9vqWjLuU9GJFA4iIn1sdfcpujP0\neAMoHERE+tzKqjrGjBjKjLF5UXfljCkcRET6UFeX88zWAyyYPppMvuKxwkFEpA9t3HuI+pa2jB5S\nAoWDiEif6j7ecJnCQUREuq2K1VFenMe4/GFRd+UNUTiIiPSRI+2dvLCtPuP3GkDhICLSZ9buaOBo\nRxeXZ+Apuo+ncBAR6SMrq+oYPMiYl4Gn6D5e0uFgZllmts7MfhMeTzGz582sysweNLPsUB8aHsfC\n+rKE17g91Deb2TUJ9YWhFjOz2/pu80REUmd1rI5LJhWQNzSZKzCnt9PZc/gUsCnh8deB77h7OdAA\n3BrqtwIN7j4d+E5oh5mdD9wEXAAsBH4cAicL+BFwLXA+8MHQVkQkYzS0tPHKnkYWTM/cU2YkSioc\nzKwUeCdwb3hswJXAr0KTpcANYXlReExYf1Vovwh4wN2Puvs2IAbMDbeYu1e7exvwQGgrIpIxntl6\nAHdYUJ75Q0qQ/J7Dd4HPAV3hcRFw0N07wuMaoCQslwC7AML6xtD+WP2455yoLiKSMVbFaskbOphZ\npQVRd6VPnDIczOx6YL+7r00s99LUT7HudOu99WWJmVWaWWVtbe1Jei0ikjqdXc7TW+qYP7WIwVn9\nY55PMltxGfAuM9tOfMjnSuJ7EgVm1n3UpRTYE5ZrgIkAYX0+UJ9YP+45J6r34O73uHuFu1eMGdM/\nxvVEJPP98oWd7D54mPfM7j+DHqcMB3e/3d1L3b2M+AHl37v7h4AngfeFZouBR8LysvCYsP737u6h\nflOYzTQFKAdeANYA5WH2U3b4Gsv6ZOtERM6yhpY2vvX4Zi6dWsS1M8dF3Z0+80bmW30eeMDMvgKs\nA34S6j8Bfm5mMeJ7DDcBuPsGM3sI2Ah0AJ9w904AM/sksBzIAu5z9w1voF8iIinzzcc303Skgzvf\ndUFGn4X1eBb/pz7zVFRUeGVlZdTdEJEB7JXdjfzJD1ex+NIy7nzXBVF355TMbK27VyTTtn8cORER\nSTF3545lGxiVk81n3jEj6u70OYWDiMgZeHjdbtbuaODzC88lf/iQqLvT5xQOIiKnqelIO//02KvM\nmljA++aURt2dsyLzTwAiIpJiP/h9jNqmo/zrzRUMGtR/DkIn0p6DiMhpiO1v5r5V23h/RSkXT+wf\nn4bujcJBRCRJ7s4X/3sDw7Oz+NzCc6PuzlmlcBARSdLjG/exsqqOz7x9BqPzhkbdnbNK4SAikoQj\n7Z18+TcbmTE2jw9fOjnq7px1OiAtIpKEf/nfamoaDvPLv5jHkH5ycr2T6f9bKCLyBu2qb+XHT8V4\n50XjefO0zL8+dDIUDiIip/DV325ikBlfuO68qLuSMgoHEZGTWFVVx+82vMYn3jaNCQXDo+5Oyigc\nREROoL2zizv/ewOTRuXw55dPjbo7KaVwEBE5gaXPbCe2v5l/vP58hg3Jiro7KaVwEBHpxf6mI3z3\nf6q44pwxXHVecdTdSTmFg4hIL77+2GaOdnTyj9ef368u4pMshYOIyHHW7mjg1y/W8OeXT2XqmLyo\nuxOJU4aDmQ0zsxfM7A9mtsHMvhjqU8zseTOrMrMHw/WfCdeIftDMYmF9WcJr3R7qm83smoT6wlCL\nmdltfb+ZIiLJ6exy7ly2gXEjh/HJt02PujuRSWbP4ShwpbvPAi4GFprZfODrwHfcvRxoAG4N7W8F\nGtx9OvCd0A4zO5/49aQvABYCPzazLDPLAn4EXAucD3wwtBURSbkH1+zi5d2N3H7dueQOHbgnkThl\nOHhcc3g4JNwcuBL4VagvBW4Iy4vCY8L6qyw+YLcIeMDdj7r7NiAGzA23mLtXu3sb8EBoKyKSUgdb\n2/h/y19l7pRRvGvWhKi7E6mkjjmE//BfAvYDK4CtwEF37whNaoCSsFwC7AII6xuBosT6cc85UV1E\nJKW+vWILjYfbufNPLhiQB6ETJRUO7t7p7hcDpcT/0+/tM+Qe7nv7jvoZ1HswsyVmVmlmlbW1tafu\nuIhIkjbuOcQvntvBn82fzPkTRkbdncid1mwldz8IPAXMBwrMrHtArhTYE5ZrgIkAYX0+UJ9YP+45\nJ6r39vXvcfcKd68YM2bM6XRdROSE3OMHofOHD+Fv3jEj6u6khWRmK40xs4KwPBx4O7AJeBJ4X2i2\nGHgkLC8Ljwnrf+/uHuo3hdlMU4By4AVgDVAeZj9lEz9ovawvNk5EJBnL/rCHF7bX83fXnEtBTnbU\n3UkLyRyKHw8sDbOKBgEPuftvzGwj8ICZfQVYB/wktP8J8HMzixHfY7gJwN03mNlDwEagA/iEu3cC\nmNkngeVAFnCfu2/osy0UETmJlqMdfO3RTcwsGckH3jTx1E8YIE4ZDu6+Hrikl3o18eMPx9ePADee\n4LW+Cny1l/qjwKNJ9FdEpE/98MkY+w4d5ccfmkPWoIF9EDqRPiEtIgNWdW0z966s5r2zS5kzuTDq\n7qQVhYOIDEjuzpd+s5Ghg7P4/LXnRN2dtKNwEJEB6YlN+3lqcy2ffns5xSOGRd2dtKNwEJEB50h7\nJ1/6zUamF+ex+M1lUXcnLQ3cE4eIyIB178pqdta38otb5zEkS/8j90bfFREZUPYcPMyPntzKwgvG\nsaB8dNTdSVsKBxEZUL766Ca63PnCO3s7C5B0UziIyIDxzNY6frt+L//niulMHJUTdXfSmsJBRAaE\n9s4uvrhsI6WFw/nYW6dG3Z20p3AQkQHh58/uYPO+Jv7v9eczbEhW1N1JewoHEen36pqP8p3/2cLl\n5aO5+vyxUXcnIygcRKTf+8bvXuVwWyd36CI+SdPnHESk3znY2sYruw+xfvdBXq5p5LFXXmPJW6Yy\nvTgv6q5lDIWDiGS0xsPtvLK7kZd3N/JyTfx+Z33rsfWTi3K4cU4pf31VeYS9zDwKBxHJGIeOxIPg\nld2NrK+J328/8HoQTBw1nAtL8vng3ElcVJrPzAn55OcMibDHmUvhICJpqelIOxv2HDq2N/Dy7ka2\n1bUcW19SMJyLSvO5sWLisSAozNVV3PqKwkFEItdytIMNew6xvuZgfK8gBIF7fP2E/GFcWJrPe2eX\ncGFpAReW5DNKQXBWnTIczGwicD8wDugC7nH375nZKOBBoAzYDrzf3RssPhXge8B1QCvwEXd/MbzW\nYuAfwkt/xd2Xhvoc4GfAcOJXhPtUuO60iPQjh9s6qa5rZmttC1v3N1Nd18KmvYfYWtt8LAjGjYwH\nwQ0Xl3BhaT4XluQzOm9otB0fgJLZc+gAPuvuL5rZCGCtma0APgI84e53mdltwG3A54FrgfJwmwfc\nDcwLYXIHUAF4eJ1l7t4Q2iwBniMeDguBx/puM0UkVdyd/U1H2bq/ma21IQhqm6mubWH3wcPH2pnB\nxMIcZozN4/qLxseHhkrydW2FNJHMNaT3AnvDcpOZbQJKgEXAFaHZUuAp4uGwCLg//Of/nJkVmNn4\n0HaFu9cDhIBZaGZPASPd/dlQvx+4AYWDSFo70t7JjgOt4Q//H4dA89GOY+1ysrOYNiaPN5UVctOY\niUwdk8e04lzKinL1SeU0dlrHHMysDLgEeB4YG4IDd99rZsWhWQmwK+FpNaF2snpNL3URiZi7c6Cl\njerwh797b6C6roVd9a10JQz+TsgfxrTiPN47u4RpxXlMGxO/jR05VB88y0BJh4OZ5QG/Bj7t7odO\n8mb3tsLPoN5bH5YQH35i0qRJp+qyiCSps8upaWgltr/52K17SKjxcPuxdkMHD2LK6FxmluSz6OIS\npo3JZdqYPKaMziV3qOa39CdJvZtmNoR4MPybu/9nKO8zs/Fhr2E8sD/Ua4CJCU8vBfaE+hXH1Z8K\n9dJe2vfg7vcA9wBUVFTogLXIaTrS3sm2upbXQyDsDVTXtdDW0XWs3ei8bKaNyeOdF40PewDxECgp\nGM6gQdoLGAiSma1kwE+ATe7+7YRVy4DFwF3h/pGE+ifN7AHiB6QbQ4AsB75mZoWh3dXA7e5eb2ZN\nZjaf+HDVzcAP+mDbRAasxsPt8f/+QwB07wkkDgV1HxCeNiaXy8tHM704j+lhOKggR9NEB7pk9hwu\nAz4MvGxmL4Xa3xMPhYfM7FZgJ3BjWPco8WmsMeJTWW8BCCHwZWBNaPel7oPTwMd5fSrrY+hgtMgp\nuTv7Dh0NewFNCSHQQm3T0WPtsgcPYuroXGZOiA8FTS/OY/qYPKaO0QFhOTHL1I8TVFRUeGVlZdTd\nEEmpto4uHlyzk1+/uJvY/uY/mhU0YtjgY3/4p4X76cV5TByVQ5aGggQws7XuXpFMWx1BEskAHZ1d\nPLxuN997ooqahsNcWBL/tHD3MND04jzGjNCsIOk7CgeRNNbV5Tz6yl6+vWIL1bUtXFiSz1dumMlb\nZ4xREMhZpXAQSUPuzhOb9vOtFVvYtPcQM8bm8c9/NodrLhirUJCUUDiIpJnVsTq++fhm1u08yOSi\nHL77gYv5k1kTdNxAUkrhIJIm1u6o55vLt/Bs9QHG5w/jn95zIe+bU8qQLF3NV1JP4SASsVd2N/Kt\nxzfz5OZaRudl84/Xn8+fzpukaaYSKYWDSERi+5v49ootPPrya+QPH8LnFp7DR95cRk62fi0levop\nFEmxnQda+e4TW/ivdbsZPiSLv75yOrdePpX84bqcpaQPhYNIirzWeITv/76Kh9bsImuQ8eeXT+Vj\nb5lKkS5kI2lI4SByltU1H+Xup7by8+d24O58cO4kPnnldMaO1EVtJH0pHETOksbD7fzr09Xct3ob\nR9o7ec/sUj51VTkTR+VE3TWRU1I4iPSxlqMd/HT1Nu55uppDRzq4/qLxfPrtM5henBd110SSpnAQ\n6SONre08sGYn9zxdzYGWNt5+XjF/845zOH/CyKi7JnLaFA4ib1BsfzM/e2Ybv167m8PtnSyYPpq/\nuXoGsycVnvrJImlK4SByBrq6nP+tquWnq7fz9JZasgcPYtGsCXzksjIumJAfdfdE3jCFg8hpaDna\nwX++WMNPn9lOdW0LY0YM5bPvmMEH501itKakSj+icBBJwq76Vu5/djsPrNlF05EOZpXm890PXMx1\nF44ne7DOfST9TzLXkL4PuB7Y7+4zQ20U8CBQBmwH3u/uDeF6098jfpnQVuAj7v5ieM5i4B/Cy37F\n3ZeG+hxev0Too8CnPFMvTyf9irvz/LZ6frp6Gys27sPMuHbmOG65bAqzJxXo1NnSryWz5/Az4IfA\n/Qm124An3P0uM7stPP48cC1QHm7zgLuBeSFM7gAqAAfWmtkyd28IbZYAzxEPh4XoGtISoSPtnSz7\nwx5+uno7m/YeojBnCH/51ml8+NLJjM8fHnX3RFLilOHg7k+bWdlx5UXAFWF5KfAU8XBYBNwf/vN/\nzswKzGx8aLvC3esBzGwFsNDMngJGuvuzoX4/cAMKh36praOLmoZWdhxoZfuBFnYcaGVHuG8+2sH0\n4jxmjB3BOeNGMGPsCGaMzWPEsNSdb2jfoSP84rkd/PL5nRxoaeOcsSO46z0XcsMlJTpDqgw4Z3rM\nYay77wVw971mVhzqJcCuhHY1oXayek0vdclQh9s62VH/+h/+7Qda2RnCYM/Bw3QlDBjmDR3MpFE5\nnDt+BDnZg4ntb+ahyl20tnUea1NSMJwZY/OYMW4E54yNh8b04rw+/WP90q6D/HT1Nn67fi+d7lx1\n7lg+elkZl04r0tCRDFh9fUC6t98kP4N67y9utoT4EBSTJk06k/5JH2g83H7sD/7O+la214UwqG9h\n36Gjf9S2MGcIk4tymTO5kPfMLqWsKIfJRTlMLsqlKDe7xx/fri5n98HDbNnXxOZ9TWx5rYnN+5pZ\nHTtAW2cXAIMMyopy43sXITTOGZfH5KLcpC+M097Zxe9eeY2frt7GizsPkjd0MB++dDIfeXMZk4ty\n++YbJZLBzjQc9pnZ+LDXMB7YH+o1wMSEdqXAnlC/4rj6U6Fe2kv7Xrn7PcA9ABUVFTpofZbtOXiY\ntTsaqNrfzM6wF7DjQAsNre1/1K54xFDKinJ5S/mYY3/4y4pymVSUc9qnoR40yJg4KoeJo3K46ryx\nx+odnV1sP9AaD43Xmo6Fx+MbXzu2N5KdNYipY3KPDUudE4aoSgqGMyhcYrOhpY1fvrCTnz+7g9cO\nHaGsKIc7/uR83jenNKVDWCLp7kzDYRmwGLgr3D+SUP+kmT1A/IB0YwiQ5cDXzKz7I6NXA7e7e72Z\nNZnZfOB54GbgB2fYJ3kDOjq7ePW1JtbuaKByRwNrt9ezp/EIAGYwIX84ZaNzuPbC8UweFQJgdA6T\nRuWk5OI0g7MGMb04j+nFeVx34fhj9SPtnWytbQ6hEb+v3N7AIy+9/j9GTnYW5WNHMHbEUP53Sy1H\nO7pYMH00X333TN52TvGx4BCR1yUzlfXfif/XP9rMaojPOroLeMjMbgV2AjeG5o8Sn8YaIz6V9RaA\nEAJfBtaEdl/qPjgNfJzXp7I+hg5Gp0TTkXbW7TxI5Y4GXtzRwLqdDbSEsf5xI4cxp6yQv5hcyJzJ\nhZwzbgRDB6fnAdlhQ7K4YEJ+j08lNx1pp2p/cxiWiu9pbNx7iPfMLuWWy8qYMXZERD0WyQyWqR8p\nqKio8MrKyqi7kRHc4+P4a3c0ULk9vmew+bVDdHl8/P7ccSOZM7mQirJ4GJQUDNeBWJF+yMzWuntF\nMm31Cel+qL2zi017D1G5vYG1O+K31w7Fh4hys7O4ZFIhf3VlORVlhVw8sUBj7SLSg8KhH2g83M66\nnQ3H9gxe2nWQw+3xIaKSguHMnTKKOWGI6NxxIxic5IweERm4FA4Zat+hI/zoyRjPV9ezZX8T7pA1\nyDhv/Ag+8KaJx4aJ9IleETkTCocM9Nv1e/nCf73M4bZO5k0t4roLxx8bIsodqrdURN44/SXJII2H\n27lz2QYeXrebWRML+M77ZzF1jC49KSJ9T+GQIZ7deoDPPvQS+5qO8pm3z+ATb5umYwcictYoHNLc\nkfZOvvX4Zu5dtY0pRbn858emqEYbAAAJdUlEQVTfzKyJBVF3S0T6OYVDGtu45xCfefAlNu9r4uZL\nJ3P7tecxPDs9P4wmIv2LwiENdXY5/7qymm89vpmCnGx+dsubuOKc4lM/UUSkjygc0syu+lY++9Af\neGF7PdfOHMfX3n0hhbnZUXdLRAYYhUOacHd+tbaGL/73Rgz49vtn8e5LSnQaCxGJhMIhDRxoPsrf\nP/wyyzfsY96UUXzr/bMoLcyJulsiMoApHCL2+1f38blfvcyhw+184brzuHXBFJ1CWkQip3CISGtb\nB1/97Sb+7fmdnDtuBL/487mcO25k1N0SEQEUDpFYt7OBzzz4EjvqW/nYW6fyN++YkbbXSxCRgUnh\nkELtnV384PcxfvRkjHEjh/HAX8xn3tSiqLslItKDwiFFttY285kHX2J9TSPvnV3Kne86X9dREJG0\nlTbhYGYLge8BWcC97n5XxF3qE+7Oz5/bwdce3cTwIVnc/aHZXJtwDWQRkXSUFuFgZlnAj4B3ADXA\nGjNb5u4bo+3ZG7Pv0BH+7lfreXpLLVecM4ZvvPciikcOi7pbIiKnlBbhAMwFYu5eDWBmDwCLgIwN\nh+5rLhxt7+IrN8zkQ/Mm6QNtIpIx0iUcSoBdCY9rgHln4wtd/4OVHG7rxAEcnPjQT/weHI/fe7y9\nh4Ue6+luk/j49ddpPNyuay6ISMZKl3Do7V9q79HIbAmwBGDSpEln9IXKi0fQ1tEFFv+iZhbu//hx\nfL2Fr0tCG4vfh0a9rQOYMjqXD8+frGsuiEhGSpdwqAEmJjwuBfYc38jd7wHuAaioqOgRHsn4zgcu\nPpOniYgMKOnyb+0aoNzMpphZNnATsCziPomIDFhpsefg7h1m9klgOfGprPe5+4aIuyUiMmClRTgA\nuPujwKNR90NERNJnWElERNKIwkFERHpQOIiISA8KBxER6UHhICIiPVj36SEyjZnVAjui7sdJjAbq\nou5EH9G2pJ/+sh2gbUmlye4+JpmGGRsO6c7MKt29Iup+9AVtS/rpL9sB2pZ0pWElERHpQeEgIiI9\nKBzOnnui7kAf0rakn/6yHaBtSUs65iAiIj1oz0FERHpQOJwGM7vPzPab2SsJtVlm9qyZvWxm/21m\nIxPW3W5mMTPbbGbXJNQXhlrMzG5L5+0ws3eY2dpQX2tmVyY8Z06ox8zs+xbBdVBP9z0J6yeZWbOZ\n/W1CLdL3JPThdH++LgrrNoT1w0I9o94XMxtiZktDfZOZ3Z7wnKh/Vyaa2ZOhXxvM7FOhPsrMVphZ\nVbgvDHUL3/OYma03s9kJr7U4tK8ys8Wp3pbT5u66JXkD3gLMBl5JqK0B3hqWPwp8OSyfD/wBGApM\nAbYSPx15VlieCmSHNuen8XZcAkwIyzOB3QnPeQG4lPjF8B4Drk3n9yRh/a+B/wD+NjyO/D05g/dl\nMLAemBUeFwFZmfi+AH8KPBCWc4DtQFk6vC/AeGB2WB4BbAm/298Abgv124Cvh+XrwvfcgPnA86E+\nCqgO94VhuTDV78vp3LTncBrc/Wmg/rjyOcDTYXkF8N6wvIj4D/xRd98GxIC54RZz92p3bwMeCG1T\n5nS2w93XuXv3Vfk2AMPMbKiZjQdGuvuzHv/pvx+44ez3/o+d5nuCmd1A/Bcz8Xohkb8ncNrbcjWw\n3t3/EJ57wN07M/R9cSDXzAYDw4E24BBp8L64+153fzEsNwGbiF/zfhGwNDRbyuvf40XA/R73HFAQ\n3pNrgBXuXu/uDcS3f2EKN+W0KRzeuFeAd4XlG3n9cqclwK6EdjWhdqJ61E60HYneC6xz96PE+1yT\nsC5dtgNOsC1mlgt8Hvjice3T9T2BE78vMwA3s+Vm9qKZfS7UM+59AX4FtAB7gZ3AN929njR7X8ys\njPie9PPAWHffC/EAAYpDs0z7vT8hhcMb91HgE2a2lvhuZ1uo9zbO6yepR+1E2wGAmV0AfB34WHep\nl9dIh+2AE2/LF4HvuHvzce0zcVsGAwuAD4X7d5vZVWTmtswFOoEJxIdgP2tmU0mjbTGzPOLDkZ92\n90Mna9pLLZ1/708oba4El6nc/VXiu/iY2QzgnWFVDX/833cp0D08c6J6ZE6yHZhZKfAwcLO7bw3l\nGuJ975YW2wEn3ZZ5wPvM7BtAAdBlZkeAtaThewKn/Pn6X3evC+seJT7G/wsy7335U+B37t4O7Dez\n1UAF8f+0I39fzGwI8WD4N3f/z1DeZ2bj3X1vGDbaH+on+r2vAa44rv7U2ez3G6U9hzfIzIrD/SDg\nH4B/DquWATeF8fkpQDnxA4VrgHIzm2Jm2cBNoW2kTrQdZlYA/Ba43d1Xd7cPu9JNZjY/zIa5GXgk\n5R3vxYm2xd0vd/cydy8Dvgt8zd1/SJq+J3DSn6/lwEVmlhPG6t8KbMzE94X4UNKVYaZPLvEDua+S\nBu9L+B7+BNjk7t9OWLUM6J5xtJjXv8fLgJvDtswHGsN7shy42swKw8ymq0MtfUV9RDyTbsC/Ex8X\nbSf+n8CtwKeIz2DYAtxF+GBhaP8F4rMtNpMwY4T4jIYtYd0X0nk7iP8StwAvJdyKw7oK4uPIW4Ef\nJm57Om7Lcc+7kzBbKR3ekzP8+foz4gfWXwG+kVDPqPcFyCM+e2wDsBH4u3R5X4gP2TnxmWHdP//X\nEZ8d9gRQFe5HhfYG/Cj092WgIuG1Pkp8YkoMuCWKn7HTuekT0iIi0oOGlUREpAeFg4iI9KBwEBGR\nHhQOIiLSg8JBRER6UDiIiEgPCgeRiJhZVtR9EDkRhYNIEszsy93n8g+Pv2pmf21mf2dma8K5+7+Y\nsP6/LH79iw1mtiSh3mxmXzKz54mfVlskLSkcRJLzE8LpEsLpH24C9hE/Lcpc4GJgjpm9JbT/qLvP\nIf5p5b82s6JQzyV+jYN57r4qlRsgcjp04j2RJLj7djM7YGaXAGOBdcCbiJ8jZ11olkc8LJ4mHgjv\nDvWJoX6A+NlHf53KvoucCYWDSPLuBT4CjAPuA64C/snd/yWxkZldAbwduNTdW83sKWBYWH3E3TtT\n1WGRM6VhJZHkPUz86l1vIn5GzeXAR8O5/jGzknDm0XygIQTDucTPMiqSUbTnIJIkd28zsyeBg+G/\n/8fN7Dzg2fiZnWkmfqbU3wF/aWbriZ+R97mo+ixypnRWVpEkhQPRLwI3untV1P0ROZs0rCSSBDM7\nn/h5+J9QMMhAoD0HERHpQXsOIiLSg8JBRER6UDiIiEgPCgcREelB4SAiIj0oHEREpIf/D+WJJaob\nr3WTAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x1a880cb0898>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "titles[titles.year < 2020].groupby(titles.year // 10 * 10).year.size().plot()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "### Use groupby() to plot the number of \"Hamlet\" films made each decade."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x1a8812a7b00>"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXcAAAEKCAYAAADpfBXhAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4xLCBo\ndHRwOi8vbWF0cGxvdGxpYi5vcmcvAOZPmwAAIABJREFUeJzt3Xt4VfWd7/H3NzcIJNxDQAICAkIA\nUUitrZe2XKzaKWprp3bOtLW143iOc7SdmTPV6vHWi7XPeXqxnWc6tnZqn5lpO7XVoa1UwUvVtqKg\nkhDCTaBlBwiRkE0CgZDke/7YKzbGhOwkO1l7r/15Pc9+svfav2R9Fxu+rPzWd31/5u6IiEi05IQd\ngIiIpJ6Su4hIBCm5i4hEkJK7iEgEKbmLiESQkruISAQpuYuIRJCSu4hIBCm5i4hEUF5YO540aZLP\nnDkzrN2LiGSkTZs2veHuJX2NCy25z5w5k40bN4a1exGRjGRmf0xmnKZlREQiSMldRCSClNxFRCJI\nyV1EJIKU3EVEIiip5G5me82sysxeM7O3lbhYwgNmtsvMKs1saepDFRGRZPWnFPJ97v5GL+9dDswN\nHu8E/iX4KiIiIUjVtMyVwI884UVgnJlNTdHPFhGJjG+t38kLO3s7T06dZJO7A0+a2SYzu6GH96cB\n+7q8jgXb3sLMbjCzjWa2sb6+vv/RiohksOaTbXzzqR1s/GPDkO8r2eR+obsvJTH9cpOZXdLtfevh\ne9628ra7P+juFe5eUVLS592zIiKRUl0bxx2WlI0b8n0lldzdfX/w9RDwKHB+tyExYHqX12XA/lQE\nKCISFZWxOACLy8YO+b76TO5mNtrMijufA5cCW7oNWwN8IqiauQCIu/uBlEcrIpLBKmvjTBtXyKSi\nEUO+r2SqZUqBR82sc/x/uvtvzOxGAHf/LvA4cAWwCzgOfGpowhURyVyVsUbOGYazdkgiubv7bmBJ\nD9u/2+W5AzelNjQRkehoPN7KHw8f56PvmN734BTQHaoiIsOgqjYx3z4cF1NByV1EZFh0XkxdNG14\npmWU3EVEhkFlrJFZk0YztjB/WPan5C4iMgwqY3EWD9NZOyi5i4gMuUNNJzgQPzFslTKg5C4iMuSq\ngvn2c4bpYioouYuIDLnKWJwcg0XTxgzbPpXcRUSGWGWskbmTixlV0J8u64Oj5C4iMoTcPXExdRjn\n20HJXURkSO2Pn+DwsVaWKLmLiERH5b5GABYP48VUUHIXERlSlbVx8nONBVOLh3W/Su4iIkOoMtbI\n2VOKGZGXO6z7VXIXERkinRdTh7O+vZOSu4jIENl7+DhNJ9o4ZxjbDnRKOrmbWa6ZvWpmv+rhvevM\nrN7MXgsen0ltmCIimacylriYGsaZe38q6m8BaoDebrH6qbv/3eBDEhGJhspYnBF5OcwrLRr2fSd1\n5m5mZcAHgO8PbTgiItFRGWtk4RljyMsd/hnwZPf4TeCfgI7TjPmwmVWa2SNmNjzrSImIpKn2DmdL\n7dFQpmQgieRuZn8BHHL3TacZ9ktgprufA6wHHu7lZ91gZhvNbGN9ff2AAhYRyQS7DjXTcqp9WNv8\ndpXMmfuFwGoz2wv8BFhuZv/edYC7H3b3k8HL7wHLevpB7v6gu1e4e0VJSckgwhYRSW9hXkyFJJK7\nu9/m7mXuPhO4Fnja3f+66xgzm9rl5WoSF15FRLJWZSxO0Yg8Zk8aHcr+B9x/0szuBTa6+xrgZjNb\nDbQBDcB1qQlPRCQzVdbGWTRtDDk5Fsr++5Xc3f1Z4Nng+Z1dtt8G3JbKwEREMlVrWwc1+49y3YUz\nQ4tBd6iKiKTYjromWts7QruYCkruIiIptzm4mLokpIupoOQuIpJylfvijB+VT9n4wtBiUHIXEUmx\nyto4i8vGYRbOxVRQchcRSamW1nZ21DWF0gmyKyV3EZEU2nrgKO0dHurFVFByFxFJqbDvTO2k5C4i\nkkJVsTiTi0cwZezIUONQchcRSaHNscbQp2RAyV1EJGWaTpxi9xvHQp+SASV3EZGU2VJ7FHd05i4i\nEiXpcjEVlNxFRFKmsjZO2fhCJowuCDsUJXcRkVSpTJOLqaDkLiKSEkeOtbKvoSUtpmRAyV1EJCUq\na+MAobcd6JR0cjezXDN71cx+1cN7I8zsp2a2y8w2mNnMVAYpIpLuqoKLqYsycFrmFnpfG/V64Ii7\nzwG+Adw/2MBERDLJ5lic2ZNGM2ZkftihAEkmdzMrAz4AfL+XIVcCDwfPHwFWWJi9LkVEhllVLJ42\nF1Mh+TP3bwL/BHT08v40YB+Au7cBcWDioKMTEckAh46e4ODRE2lzMRWSSO5m9hfAIXffdLphPWzz\nHn7WDWa20cw21tfX9yNMEZH0tTkWXEzNsDP3C4HVZrYX+Amw3Mz+vduYGDAdwMzygLFAQ/cf5O4P\nunuFu1eUlJQMKnARkXRRFWskx2DhGRmU3N39Nncvc/eZwLXA0+7+192GrQE+GTy/JhjztjN3EZEo\n2hyLM6+0mMKC3LBDedOA69zN7F4zWx28fAiYaGa7gL8Hbk1FcCIi6c7dqapNr4upAHn9GezuzwLP\nBs/v7LL9BPCRVAYmIpIJYkdaaDjWyuI0upgKukNVRGRQqoI7U5ek2Zm7kruIyCBsjjWSn2ucPaU4\n7FDeQsldRGQQqmJxFkwdw4i89LmYCkruIiID1tHhaXdnaicldxGRAdpz+BhNJ9s4Z1p6XUwFJXcR\nkQGr6rwzdbrO3EVEImNzrJGR+TnMKSkKO5S3UXIXERmgqlicRWeMJS83/VJp+kUkIpIB2to72LI/\nzuI0vJgKSu4iIgOyq76ZE6c6WJJmd6Z2UnIXERmAyn2Ji6k6cxcRiZDNsUaKR+Qxa+LosEPpkZK7\niMgAVNUm5ttzctJzRVEldxGRfjrZ1k7NgaNpOyUDSu4iIv22/WATp9o9bS+mgpK7iEi/da6Zunha\nBp+5m9lIM3vJzDabWbWZ3dPDmOvMrN7MXgsenxmacEVEwlcVa2TC6ALKxheGHUqvklmJ6SSw3N2b\nzSwfeMHM1rr7i93G/dTd/y71IYqIpJfKWJzF08Zilp4XUyG5BbLd3ZuDl/nBQ4tfi0hWamltZ0dd\nU9qtvNRdUnPuZpZrZq8Bh4B17r6hh2EfNrNKM3vEzKb38nNuMLONZraxvr5+EGGLiISjen+cDift\n1kztLqnk7u7t7n4uUAacb2aLug35JTDT3c8B1gMP9/JzHnT3CnevKCkpGUzcIiKh6LyYmo4LdHTV\nr2oZd28EngUu67b9sLufDF5+D1iWkuhERNJMVayR0jEjKB0zMuxQTiuZapkSMxsXPC8EVgLbuo2Z\n2uXlaqAmlUGKiKSLylicc9J8SgaSq5aZCjxsZrkk/jP4L3f/lZndC2x09zXAzWa2GmgDGoDrhipg\nEZGwHD1xit1vHONDS6eFHUqf+kzu7l4JnNfD9ju7PL8NuC21oYmIpJctnTcvZcCZu+5QFRFJUmVt\ncDE1je9M7aTkLiKSpMpYI9MnFDJ+dEHYofRJyV1EJEmZcjEVlNxFRJJyuPkksSMtGTElA0ruIiJJ\neXO+XWfuIiLRURWLYwaLpo0JO5SkKLmLiCShMtbI7EmjKR6ZH3YoSVFyFxFJQmUsntYrL3Wn5C4i\n0oeD8RMcajqZ1mumdqfkLiLSh8pYI5A5F1NByV1EpE+VsTi5OUb51My4mApK7iIifaqsjTOvtJjC\ngtywQ0makruIyGm4O5Wxxoy5eamTkruIyGnsa2ih8fgpzpmu5C4iEhmVtcHF1GmZczEVkluJaaSZ\nvWRmm82s2szu6WHMCDP7qZntMrMNZjZzKIIVERlulbE4Bbk5nD2lOOxQ+iWZM/eTwHJ3XwKcC1xm\nZhd0G3M9cMTd5wDfAO5PbZgiIuGojDWy4IwxFORl1kRHn9F6QnPwMj94eLdhVwIPB88fAVaYmaUs\nShGREHR0OFtqj2bcxVRIcs7dzHLN7DXgELDO3Td0GzIN2Afg7m1AHJiYykA7vby3gU/84CWaTpwa\nih8vIvKm3W8co/lkG+dk0J2pnZJK7u7e7u7nAmXA+Wa2qNuQns7Su5/dY2Y3mNlGM9tYX1/f/2hJ\n/E/63I56ntvxxoC+X0QkWZl4Z2qnfk0iuXsj8CxwWbe3YsB0ADPLA8YCDT18/4PuXuHuFSUlJQMK\neNmZ4xk/Kp91Ww8O6PtFRJJVGYtTmJ/LnMlFYYfSb8lUy5SY2bjgeSGwEtjWbdga4JPB82uAp939\nbWfuqZCXm8Py+aU8ve0Qp9o7hmIXIiJA4sx90bQx5OZk3iXEZM7cpwLPmFkl8DKJOfdfmdm9ZrY6\nGPMQMNHMdgF/D9w6NOEmrCov5eiJNl7e87ZfDkREUuJUewfV+49m5JQMQF5fA9y9Ejivh+13dnl+\nAvhIakPr3SXzJjEiL4d1NXW8e86k4dqtiGSRnXXNnGzryMiLqZChd6iOKsjjojmTWLe1jiGa/RGR\nLJfJF1MhQ5M7wMryUmJHWth2sCnsUEQkgipr4xSPzGPmxFFhhzIgGZvcVyyYjBms21oXdigiEkGV\nsUbOKRtLpt6PmbHJfXLxSM6dPk7JXURS7sSpdrYfbMrYKRnI4OQOiaqZqto4B+ItYYciIhGy7WAT\np9o9I9sOdMro5H5peSkA62sOhRyJiERJVefF1Ok6cw/FWSVFzJo0WlMzIpJSm2NxJo4u4IyxI8MO\nZcAyOrmbGSsXTOYPr7+hRmIikjKZfjEVMjy5A6wqn8Kpdue3OwbWiExEpKtjJ9vYdaiZxRl8MRUi\nkNyXnTmeCaMLNDUjIilRvf8oHQ5LMvTO1E4Zn9xzc4zl8yfzjBqJiUgKdN6ZuljJPXxqJCYiqVIZ\nizN17EgmF2fuxVSISHK/eG6ikdiTmpoRkUGqqo1nbLOwriKR3NVITERSId5yij1vHMvoO1M7RSK5\nQ2JqpraxhZoDaiQmIgOzpTYOoDP3dLJiQakaiYnIoGzuvJiawW0HOiWzzN50M3vGzGrMrNrMbulh\nzHvNLG5mrwWPO3v6WUOppHgE500fx7oara0qIgNTuS/OmRNHMW5UQdihDFoyZ+5twD+4+wLgAuAm\nMyvvYdzz7n5u8Lg3pVEmaVX5FLbUHlUjMREZkKraeCTO2iGJ5O7uB9z9leB5E1ADTBvqwAZiVWcj\nMU3NiEg/vdF8ktrGFpZE4GIq9HPO3cxmklhPdUMPb7/LzDab2VozW5iC2PrtrJLRzJo0WiWRItJv\nVbHoXEyFfiR3MysCfg581t2Pdnv7FeBMd18CfBt4rJefcYOZbTSzjfX1qe8FY2asKi/lxd2HOapG\nYiLSD5tjjZjBwmyZlgEws3wSif0/3P0X3d9396Pu3hw8fxzIN7NJPYx70N0r3L2ipKRkkKH3bFV5\naaKR2HY1EhOR5FXF4swpKaJoRF7YoaREMtUyBjwE1Lj713sZMyUYh5mdH/zcw6kMNFlLZ4xnohqJ\niUg/uDubY/GM7yfTVTL/RV0IfByoMrPXgm1fAGYAuPt3gWuA/2lmbUALcK2HdKtoZyOx31Qf5FR7\nB/m5kSnlF5EhcvDoCd5oPhmZi6mQRHJ39xeA03asd/fvAN9JVVCDtaq8lJ9tivHSngYunPO22SER\nkbfYvC9xMTVKZ+6RPK29KGgkpqkZEUlGZayRvByjfOqYsENJmUgm91EFeVw8V43ERCQ5VbVx5pUW\nMzI/N+xQUiaSyR3+3Ehs64HuVZsiIn/m7lTG4iyZHp0pGYhwcl8+X43ERKRvf2o4TrzlVCTa/HYV\n2eReUjyCpTPGK7mLyGltDu5MjUpPmU6RTe6QmJqp3n+U/Y1qJCYiPauKNVKQl8PZU4rDDiWlIp3c\nVy4IGonV6OxdRHq2ORanfOqYyN0TE62j6WbO5CJmTxqtqRkR6VF7h7OlNs6SCNW3d4p0cgfUSExE\nerW7vpnjre0sjtjFVMiS5H6q3XlWjcREpJvOi6k6c89A56mRmIj0oirWyKiCXGaXFIUdSspFPrnn\n5hgrFkzm2e2HaG3rCDscEUkjm2NxFk0bS27OadtnZaTIJ3dIVM00nWjjpT0NYYciImniVHsHWw8c\njeSUDGRJcr94bgkj83NYt/Vg2KGISJrYfrCJ1raOSF5MhSxJ7oUFuVw0p0SNxETkTVW10b2YClmS\n3AEuLS9lf/wE1fvVSExEEm1+xxbmM2PCqLBDGRLJLLM33cyeMbMaM6s2s1t6GGNm9oCZ7TKzSjNb\nOjThDtzyBZPVSExE3rR5X5xzysYSrBAaOcmcubcB/+DuC4ALgJvMrLzbmMuBucHjBuBfUhplCkwq\nGsGyGePVikBEOHGqnR11TZFrFtZVMsvsHQAOBM+bzKwGmAZs7TLsSuBHwbqpL5rZODObGnxv2lhZ\nXspX126jtrGFaeMKww5H0tSuQ83UN50MZd/lU8cwdlR+KPsOw+Hmk+yoax72/e49fIy2Do9cm9+u\nklkg+01mNhM4D9jQ7a1pwL4ur2PBtrckdzO7gcSZPTNmzOhfpCmwKkju67fW8cl3zxz2/Uv6e2b7\nIT71by+Htv+y8YU8+blLGFXQr3+aGSl+/BTv/+bzvNEczn+kOQbnTldyx8yKgJ8Dn3X37lcle5q0\neltZirs/CDwIUFFRMexlK2eVFDG7JNFITMldumtpbefO/97C7JLRfOmqRdjp14VPudrGFv7xZ5v5\n1lM7ue3yBcO67zDc/8Q2Go6d5NsfO49JRSOGff8TiwqYMnbksO93uCSV3M0sn0Ri/w93/0UPQ2LA\n9C6vy4D9gw8v9VaVl/LQ83uIt5xibGH2/PorffvnZ3axr6GF//ybd/LusyaFEsOG3Yd56Pk9fOi8\nssj1F+/qlT8d4ccv/YlPvXsWH1xyRtjhRFIy1TIGPATUuPvXexm2BvhEUDVzARBPt/n2TpeWl9LW\n4Ty7/VDYoUga2XWoiX997nU+dN600BI7wG1XLKBoZB53PFZFR0c078loa+/g9ke3UFo8kr+/dF7Y\n4URWMtUyFwIfB5ab2WvB4wozu9HMbgzGPA7sBnYB3wP+19CEO3jnTk80Eltfo+QuCe7OHY9toTA/\nly98INzpkAmjC/jC5Qt4ee8RHtkUCzWWofLD3++l5sBR7vpgOUUjon9tISzJVMu8QM9z6l3HOHBT\nqoIaSp2NxNZWHaS1rYOCvKy5j0t68eirtby4u4GvXL04lLnf7q5ZVsbPNu3jvrU1rCwvZcLogrBD\nSpkD8Ra+sW4H7zu7hMsWTQk7nEjLysy2qnwKTSfb2LDncNihSMgaj7fy5V/XcN6McVz7jul9f8Mw\nyMkxvnTVYppOtPHVtTVhh5NS9/5yK20dzj2rF0X25qF0kZXJ/aI5k4JGYrqhKdt97YntNLac4stX\nLSYnjdq+nj2lmOsvnsV/bYzx8t5odDN9Ztsh1m45yM0r5jJjYjRv+U8nWZncCwtyuXhuCevVSCyr\nbfrjEf5zw5/41LtnUn7GmLDDeZtbVsxl2rhCbn+0ilPtmb0WQUtrO3eu2cKcyUX8zcWzww4nK2Rl\ncodESaQaiWWvtvYO7nhsC1PGjOSzq9KzYmNUQR53r17IjrpmHnphT9jhDMp3ntnJvoYWvnjlIl3n\nGiZZ+6e8fL4aiWWzzoqNu1end8XGqvJSVpWX8q31O4kdOR52OAOy61ATDz63mw8tnca7zpoYdjhZ\nI2uTe2cjMSX37LO/sYWvr9vB8vmTef/C9K/YuHv1wsTXNVv7GJl+3J3bH93CqII8vnBF9O+6TSdZ\nm9whcVa09cDRjD0jkoG595db6XDnntULM6JiY9q4Qj67ci7ra+p4sjqzVhP7xSu1bNjTwOcvm58W\nZabZJOuTO8B6nb1njae31fGb6oP87+VzmZ5BizR8+qJZnF1azN1rqjl2si3scJLSeLyVLz+eXmWm\n2SSrk/vskiLOKhnNOvV4zwqJxmDVGVmxkZ+bw5evXsT++AkeeGpn2OEk5f7fbCeehmWm2SKrkzsk\nbmjasLuBeMupsEORIfbtp3cSO9LCl67KzIqNipkT+GjFdL7/wh62HUzvKq9Nf2wIGoOlZ5lpNsi8\nv+Eptqp8shqJZYGddU187/ndfHhpGRfMztyKjVsvn8+YkXnc/uiWtG0s1tkYbOrY9C0zzQZZn9zP\nnT6eSUUFqpqJMHfn9sc6Kzbmhx3OoIwfXcAXrljApj8e4Web9vX9DSH44e/3su1gE3d9cGFal5lG\nXdYn99wcY8X8Un67vZ7Wtsy+C1B69vNXanlpTwO3Xj6fiRGo2LhmWRnnz5zAfWu3cTikVYx689Yy\n09Kww8lqWZ/cIVE103SyjRd3q5FY1DQeb+Urj9ewdMY4PloRjYoNM+NLVy+i+UQb963dFnY4b3HP\nL6szqsw0ypTcgYvmTqIwP1dTMxF0/2+2JSo2ro5Wxca80mL+5pLZPLIpxoY0OSl5qqaOJ6rruHlF\nZpWZRpWSOzAyP5eL505ifY0aiUVJomJjH9dfNIsFU6NXsXHz8rmUjS/kjse2hD6l2FlmOndyEZ+5\nKLPKTKMqmWX2fmBmh8xsSy/vv9fM4l1Waboz9WEOvZXlpRyIn2BLbXqXmElyTgUVG2eMHcktK+aG\nHc6QKCzI5Z7VC9l5qJnvv7A71FgeeHontY2ZW2YaRcl8Cj8ELutjzPPufm7wuHfwYQ2/FfMnk2Po\nhqaI+OHvgoqN1QsZHeGKjRULSnn/wlIeeGon+xrCaaOxo66J7z23m2uWlfHODC4zjZo+k7u7PwdE\nY7WA05hYNIJlZ6qRWBTsb2zhG+t3sHLBZC4tj37Fxl0fXEiOGXetqR72aUV3545Ht1A0Mo/bLs/s\nMtOoSdXvT+8ys81mttbMFvY2yMxuMLONZraxvr4+RbtOnVXlpdQcOBraGZCkRmfFxl0fzI6KjTPG\nFfK5lfN4etshnqge3pOTRzbFeGlvA7deFo0y0yhJRXJ/BTjT3ZcA3wYe622guz/o7hXuXlFSUpKC\nXafWqvJE+9f1mprJWOu3Jio2blkxL6sqNq67cCbzpxRzzy+Hr7HYkWOt3Ld2G8vOHM9fRqTMNEoG\nndzd/ai7NwfPHwfyzWzSoCMLwaxJo5kzuUhTMxnqeGsbd62pZl5pEZ+5eFbY4QyrRGOxxRyIn+Cb\n63cMyz7/XGa6KFJlplEx6ORuZlMs+N3XzM4PfmZ6FN4OwMoFpWzY00D8uBqJZZpvP70rqNhYTH5u\n9lVsLDtzPB87fzo/+F1ilamhtHFvAz95OVFmOn9K9MpMoyCZUsgfA38AzjazmJldb2Y3mtmNwZBr\ngC1mthl4ALjWM7hYfFV5Ke0dzrM71Egsk3RWbHxkWRnnz5oQdjih+fxl8xlbmM/tj1YNWWOxU8H6\ns1EuM42CPmvE3P1jfbz/HeA7KYsoZOdNH8ekohE8ubWOK8+dFnY4koS3VGxk+VJu40YVcPsVC/iH\nn23mpxv38bHzZ6R8H//2uz1sO9jEgx9fFuky00yXfb+79iEnx1i5YDK/3V7Pybb2sMORJHRWbNx2\n+XwmjC4IO5zQfWjpNN45awJfXbuNN1LcWKy2sYVvrNuZKDPNgPVns5mSew9WlZfSfLKNF3dHvrw/\n4x05lmgMVnHmeD6yTBUbkGgs9uWrF3G8tY37Hk9tY7F71lQDf160W9KXknsPLpzT2UgssxYjzkZf\nXbuNphNtfEkVG28xZ3IxN1wym5+/EuMPr6emvmHd1jqe3FrHLSvnUjY+e8pMM5WSew/ebCS29ZAa\niaWxjXsb+OnGfVx/sSo2evJ375vL9AmF/N//HnxjseOtbdwdlJlef1F2lZlmKiX3XqwqL+XgUTUS\nS1edjcGmjStUxUYvCgtyuXf1InYdauZ7zw+usdgDTyXKTL98dXaWmWYifUq9WLGgNNFITFMzaenf\nfreH7XVN3L16IaMKVLHRm/fNn8zli6bwwFM7+dPhgbXV2H6wie8/v5u/rCjjHTOzt8w00yi592LC\n6AIqzpzAk7pbNe10VmysKi9lVRY0BhusOz9YTl6OcdeaLf2eZuzocO54rIrikXncenl2l5lmGiX3\n01hVXsq2g01qJJZm7lbFRr9MHVvI51bN45nt9TxR3b/fRB95JcbLe49w2+ULVGaaYZTcT2NlcFao\nXjPpY93WOtZtreOzK+cybVxh2OFkjOvePZMFU8dw95qtNCfZWKzhWCv3PV7DO2aO55plZUMcoaSa\nkvtpqJFYeums2Di7tJhPq2KjX/Jyc/jK1YuoazrBN9Yl11jsq2trEmWmV0Vr/dlsoeTeh1Xlpby0\nV43E0sG3ntoZVGwsUsXGAJw3YzwfO38GP/z9Xqr3x0879uW9DfzXxhjXXzyLs6cUD1OEkkr6F9KH\nzkZiz2xXI7EwbT/YxEPP7+GjFdOpUMXGgH3+/fMZV5jP7Y9u6bWxWKLMtEplphlOyb0P55aNo6R4\nhKZmQvTWig0t5TYYY0flc8dfLOC1fY38+OU/9TjmoRf2sKOumXtUZprRlNz70NlI7Nnth9RILCSP\nbAoqNq5YwHhVbAzaVedO412zJ3J/D43FYkeO8631iTLTlSozzWhK7klYVV7Ksdb2lPXokOQ1HGvl\nvrU1nD9zAtcsVcVGKpgZX7xqES2n2vnKr2ve8t7da7YmvqrMNOMls1jHD8zskJlt6eV9M7MHzGyX\nmVWa2dLUhxmud5/V2UhMUzPD7c2KDTUGS6k5k4u48T1n8YtXa/n9628A8GT1QdbX1PG5VSozjYJk\nztx/CFx2mvcvB+YGjxuAfxl8WOllZH4ul8ybxPqaOjUSG0adFRufuXg280pVsZFqN71vDjMmjOKO\nx7bQeLz1zTLTT12oMtMo6DO5u/tzwOkam18J/MgTXgTGmdnUVAWYLlaVT6Hu6Emqak9fQiap0bVi\n4+YVc8IOJ5JG5udy75UL2V1/jKv++Xfsj59QmWmEpOJS+DRgX5fXsWDbgRT87LSxfP5kcgw+8/BG\nxhbmhx1O5J1oa2dfQwsPfbJCFRtD6L1nT+YDi6fy66oDXPsOlZlGSSr+1fQ0Edrj3IWZ3UBi6oYZ\nM1K/tuNQmjC6gM9fNp/NscawQ8kaH7/gTFYsUMXGULt79UJmTBzFjZecFXYokkKpSO4xoOv6ZmXA\n/p4GuvuDwIMAFRUVGTd5/bfDgmPPAAAGxUlEQVTv0V9+iZ6S4hF8/jLdPxA1qZhcWwN8IqiauQCI\nu3ukpmRERDJNn2fuZvZj4L3AJDOLAXcB+QDu/l3gceAKYBdwHPjUUAUrIiLJ6TO5u/vH+njfgZtS\nFpGIiAyaap5ERCJIyV1EJIKU3EVEIkjJXUQkgpTcRUQiyMJqhGVm9cAfQ9n54EwC3gg7iGGmY46+\nbDteyNxjPtPdS/oaFFpyz1RmttHdK8KOYzjpmKMv244Xon/MmpYREYkgJXcRkQhScu+/B8MOIAQ6\n5ujLtuOFiB+z5txFRCJIZ+4iIhGU9cm9pwXAzWyJmf3BzKrM7JdmNibYvsrMNgXbN5nZ8i7fsyzY\nvitYMDxtV3PuzzF3eX+GmTWb2T922XaZmW0PjvnW4TyG/urvMZvZOcF71cH7I4PtkfyczSzfzB4O\ntteY2W1dvieTPufpZvZMcAzVZnZLsH2Cma0zs53B1/HBdgs+x11mVmlmS7v8rE8G43ea2SfDOqYB\nc/esfgCXAEuBLV22vQy8J3j+aeCLwfPzgDOC54uA2i7f8xLwLhIrU60FLg/72FJxzF3e/znwM+Af\ng9e5wOvAbKAA2AyUh31sKfqc84BKYEnweiKQG+XPGfgr4CfB81HAXmBmBn7OU4GlwfNiYAdQDnwN\nuDXYfitwf/D8iuBzNOACYEOwfQKwO/g6Png+Puzj688j68/cvecFwM8GnguerwM+HIx91d07V5mq\nBkaa2YhgQfAx7v4HT/zN+BFw1dBHPzD9OWYAM7uKxF/u6i7jzwd2uftud28FfkJisfS01M9jvhSo\ndPfNwfcedvf2iH/ODow2szygEGgFjpJ5n/MBd38leN4E1JBY0/lK4OFg2MP8+XO7EviRJ7wIjAs+\n5/cD69y9wd2PkPizumwYD2XQsj6592ILsDp4/hHeuoxgpw8Dr7r7SRJ/eWJd3utcJDyT9HjMZjYa\n+DxwT7fxvS2Mnkl6+5znAW5mT5jZK2b2T8H2yH7OwCPAMRIL2/8J+H/u3kAGf85mNpPEb9sbgFIP\nVogLvk4OhvV2fBl73J2U3Hv2aeAmM9tE4le71q5vmtlC4H7gbzs39fAzMq0Mqbdjvgf4hrs3dxsf\n5WPOAy4C/kfw9WozW0G0j/l8oB04A5gF/IOZzSZDj9nMikhMJX7W3Y+ebmgP2/w02zNGKhbIjhx3\n30biV3PMbB7wgc73zKwMeBT4hLu/HmyOkVgYvFOvi4Snq9Mc8zuBa8zsa8A4oMPMTgCbSHJh9HR1\nmmOOAb919zeC9x4nMXf970T3c/4r4Dfufgo4ZGa/AypInL1m1OdsZvkkEvt/uPsvgs11ZjbV3Q8E\n0y6Hgu0xej6+GInlRbtuf3Yo4041nbn3wMwmB19zgDuA7wavxwG/Bm5z9991jg9+zWsyswuC6olP\nAP897IEPQm/H7O4Xu/tMd58JfBP4irt/h8SFublmNsvMCoBrSSyWnjF6O2bgCeAcMxsVzEG/B9ga\n5c+ZxFTM8qB6ZDSJi4vbyLDPOfhcHgJq3P3rXd5aA3RWvHySP39ua4BPBMd9ARAPPucngEvNbHxQ\nWXNpsC1zhH1FN+wH8GMS84ynSPxvfT1wC4mr7DuAr/Lnm73uIDEv+VqXx+TgvQoS85mvA9/p/J50\nfPTnmLt9390E1TLB6yuC8a8Dt4d9XKk8ZuCvSVxA3gJ8rcv2SH7OQBGJaqhqYCvwfzL0c76IxPRJ\nZZd/o1eQqHh6CtgZfJ0QjDfgn4NjqwIquvysTwO7gsenwj62/j50h6qISARpWkZEJIKU3EVEIkjJ\nXUQkgpTcRUQiSMldRCSClNxFRCJIyV1kEMwsN+wYRHqi5C5Zw8y+2NnfO3j9ZTO72cz+j5m9HPTz\nvqfL+49Zom9/tZnd0GV7s5nda2YbSLT/FUk7Su6STR4iuAU9uP3+WqAOmEuicda5wDIzuyQY/2l3\nX0birtSbzWxisH00iR7p73T3F4bzAESSpcZhkjXcfa+ZHTaz84BS4FXgHST6hrwaDCsikeyfI5HQ\nrw62Tw+2HybRPfHnwxm7SH8puUu2+T5wHTAF+AGwArjP3f+16yAzey+wEniXux83s2eBkcHbJ9y9\nfbgCFhkITctItnmUxIo67yDR5e8J4NNB/2/MbFrQOXEscCRI7PNJdEkUyRg6c5es4u6tZvYM0Bic\nfT9pZguAPyS6xdJMoiPkb4AbzawS2A68GFbMIgOhrpCSVYILqa8AH3H3nWHHIzJUNC0jWcPMykn0\n5n5KiV2iTmfuIiIRpDN3EZEIUnIXEYkgJXcRkQhSchcRiSAldxGRCFJyFxGJoP8PoqzaUMMniGcA\nAAAASUVORK5CYII=\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x1a880c8ab38>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "titles[(titles.year < 2020) & (titles.title == 'Hamlet')].groupby(titles.year // 10 * 10).year.size().plot()"
   ]
  },
  {
   "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 each year of the 1950s?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "year  type   \n",
       "1950  actor      7649\n",
       "      actress    3204\n",
       "1951  actor      8053\n",
       "      actress    3396\n",
       "1952  actor      7681\n",
       "      actress    3344\n",
       "1953  actor      8129\n",
       "      actress    3582\n",
       "1954  actor      7792\n",
       "      actress    3487\n",
       "1955  actor      8046\n",
       "      actress    3436\n",
       "1956  actor      8329\n",
       "      actress    3689\n",
       "1957  actor      8905\n",
       "      actress    3907\n",
       "1958  actor      8978\n",
       "      actress    3823\n",
       "1959  actor      8517\n",
       "      actress    3926\n",
       "dtype: int64"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cast[(cast.year // 10 == 195) & cast.n == 1].groupby(['year', 'type']).size()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "### In the 1950s decade taken as a whole, how many total roles were available to actors, and how many to actresses, for each \"n\" number 1 through 5?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "n    type   \n",
       "1.0  actor      6692\n",
       "     actress    3040\n",
       "2.0  actor      4640\n",
       "     actress    4635\n",
       "3.0  actor      5654\n",
       "     actress    3201\n",
       "4.0  actor      5663\n",
       "     actress    2881\n",
       "5.0  actor      5674\n",
       "     actress    2592\n",
       "dtype: int64"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cast[(cast.year // 10 == 195) & (cast.n <= 5)].groupby(['n','type']).size()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "### Use groupby() to determine how many roles are listed for each of the Pink Panther movies."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\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>1010</th>\n",
       "      <td>The Pink Panther</td>\n",
       "      <td>2006</td>\n",
       "      <td>William Abadie</td>\n",
       "      <td>actor</td>\n",
       "      <td>Bizu</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2100</th>\n",
       "      <td>Revenge of the Pink Panther</td>\n",
       "      <td>1978</td>\n",
       "      <td>Fredric Abbott</td>\n",
       "      <td>actor</td>\n",
       "      <td>Douvier's Soldier</td>\n",
       "      <td>38.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4921</th>\n",
       "      <td>Curse of the Pink Panther</td>\n",
       "      <td>1983</td>\n",
       "      <td>William Abney</td>\n",
       "      <td>actor</td>\n",
       "      <td>Hugo the Houseman</td>\n",
       "      <td>33.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13007</th>\n",
       "      <td>Son of the Pink Panther</td>\n",
       "      <td>1993</td>\n",
       "      <td>Tony Adams</td>\n",
       "      <td>actor</td>\n",
       "      <td>Wedding Guest</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13008</th>\n",
       "      <td>The Return of the Pink Panther</td>\n",
       "      <td>1975</td>\n",
       "      <td>Tony Adams</td>\n",
       "      <td>actor</td>\n",
       "      <td>Waiter</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14470</th>\n",
       "      <td>The Return of the Pink Panther</td>\n",
       "      <td>1975</td>\n",
       "      <td>Yashaw Adem</td>\n",
       "      <td>actor</td>\n",
       "      <td>Museum Guard</td>\n",
       "      <td>24.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15078</th>\n",
       "      <td>The Pink Panther</td>\n",
       "      <td>2006</td>\n",
       "      <td>Scott (II) Adkins</td>\n",
       "      <td>actor</td>\n",
       "      <td>Jacquard</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34701</th>\n",
       "      <td>Revenge of the Pink Panther</td>\n",
       "      <td>1978</td>\n",
       "      <td>Lewis Alexander</td>\n",
       "      <td>actor</td>\n",
       "      <td>Attendee at Clouseau's Memorial Service</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40517</th>\n",
       "      <td>Revenge of the Pink Panther</td>\n",
       "      <td>1978</td>\n",
       "      <td>Irvin Allen</td>\n",
       "      <td>actor</td>\n",
       "      <td>Haig &amp; Haig</td>\n",
       "      <td>17.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57923</th>\n",
       "      <td>The Pink Panther</td>\n",
       "      <td>2006</td>\n",
       "      <td>Patrick (III) Anderson</td>\n",
       "      <td>actor</td>\n",
       "      <td>NYC Firefighter</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69064</th>\n",
       "      <td>Revenge of the Pink Panther</td>\n",
       "      <td>1978</td>\n",
       "      <td>Paul Antrim</td>\n",
       "      <td>actor</td>\n",
       "      <td>Lookout</td>\n",
       "      <td>40.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81803</th>\n",
       "      <td>Curse of the Pink Panther</td>\n",
       "      <td>1983</td>\n",
       "      <td>Peter Arne</td>\n",
       "      <td>actor</td>\n",
       "      <td>General Bufoni</td>\n",
       "      <td>14.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81830</th>\n",
       "      <td>The Return of the Pink Panther</td>\n",
       "      <td>1975</td>\n",
       "      <td>Peter Arne</td>\n",
       "      <td>actor</td>\n",
       "      <td>Colonel Sharki</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81835</th>\n",
       "      <td>Trail of the Pink Panther</td>\n",
       "      <td>1982</td>\n",
       "      <td>Peter Arne</td>\n",
       "      <td>actor</td>\n",
       "      <td>Col. Bufoni</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86621</th>\n",
       "      <td>The Pink Panther</td>\n",
       "      <td>2006</td>\n",
       "      <td>Michael Arthur</td>\n",
       "      <td>actor</td>\n",
       "      <td>Officer #1</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91155</th>\n",
       "      <td>The Return of the Pink Panther</td>\n",
       "      <td>1975</td>\n",
       "      <td>Gr?goire Aslan</td>\n",
       "      <td>actor</td>\n",
       "      <td>Chief of Lugash Police</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97538</th>\n",
       "      <td>Son of the Pink Panther</td>\n",
       "      <td>1993</td>\n",
       "      <td>Harry Audley</td>\n",
       "      <td>actor</td>\n",
       "      <td>Pilot</td>\n",
       "      <td>29.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98058</th>\n",
       "      <td>Revenge of the Pink Panther</td>\n",
       "      <td>1978</td>\n",
       "      <td>Charles Augins</td>\n",
       "      <td>actor</td>\n",
       "      <td>Vic Vancouver</td>\n",
       "      <td>16.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146145</th>\n",
       "      <td>The Pink Panther</td>\n",
       "      <td>1963</td>\n",
       "      <td>John Bartha</td>\n",
       "      <td>actor</td>\n",
       "      <td>Policeman</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150085</th>\n",
       "      <td>Revenge of the Pink Panther</td>\n",
       "      <td>1978</td>\n",
       "      <td>Alfie Bass</td>\n",
       "      <td>actor</td>\n",
       "      <td>Fernet</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163599</th>\n",
       "      <td>Revenge of the Pink Panther</td>\n",
       "      <td>1978</td>\n",
       "      <td>Tony Beckley</td>\n",
       "      <td>actor</td>\n",
       "      <td>Guy Algo</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166216</th>\n",
       "      <td>Curse of the Pink Panther</td>\n",
       "      <td>1983</td>\n",
       "      <td>Geoffrey Beevers</td>\n",
       "      <td>actor</td>\n",
       "      <td>Concierge</td>\n",
       "      <td>37.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169654</th>\n",
       "      <td>The Pink Panther</td>\n",
       "      <td>2006</td>\n",
       "      <td>Dexter Bell</td>\n",
       "      <td>actor</td>\n",
       "      <td>Terry Ahkee-Sauce</td>\n",
       "      <td>33.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170855</th>\n",
       "      <td>Revenge of the Pink Panther</td>\n",
       "      <td>1978</td>\n",
       "      <td>Michael Bell</td>\n",
       "      <td>actor</td>\n",
       "      <td>Claude Russo</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177799</th>\n",
       "      <td>Son of the Pink Panther</td>\n",
       "      <td>1993</td>\n",
       "      <td>Roberto Benigni</td>\n",
       "      <td>actor</td>\n",
       "      <td>Gendarme Jacques Gambrelli</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184021</th>\n",
       "      <td>Trail of the Pink Panther</td>\n",
       "      <td>1982</td>\n",
       "      <td>Harold Berens</td>\n",
       "      <td>actor</td>\n",
       "      <td>Hotel Clerk</td>\n",
       "      <td>22.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>204729</th>\n",
       "      <td>The Pink Panther</td>\n",
       "      <td>1963</td>\n",
       "      <td>Riccardo Billi</td>\n",
       "      <td>actor</td>\n",
       "      <td>Aristotle Sarajos</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>215948</th>\n",
       "      <td>Trail of the Pink Panther</td>\n",
       "      <td>1982</td>\n",
       "      <td>Colin Blakely</td>\n",
       "      <td>actor</td>\n",
       "      <td>Section Director Alec Drummond</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>218205</th>\n",
       "      <td>The Pink Panther</td>\n",
       "      <td>2006</td>\n",
       "      <td>Antoine Blanquefort</td>\n",
       "      <td>actor</td>\n",
       "      <td>Ballroom Reporter</td>\n",
       "      <td>44.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223474</th>\n",
       "      <td>Revenge of the Pink Panther</td>\n",
       "      <td>1978</td>\n",
       "      <td>John Bluthal</td>\n",
       "      <td>actor</td>\n",
       "      <td>Guard at Cemetery</td>\n",
       "      <td>54.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3229849</th>\n",
       "      <td>The Pink Panther</td>\n",
       "      <td>2006</td>\n",
       "      <td>Charlotte Maier</td>\n",
       "      <td>actress</td>\n",
       "      <td>Dialect Instructor</td>\n",
       "      <td>17.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3261242</th>\n",
       "      <td>Curse of the Pink Panther</td>\n",
       "      <td>1983</td>\n",
       "      <td>Mollie Maureen</td>\n",
       "      <td>actress</td>\n",
       "      <td>Rich Old Lady</td>\n",
       "      <td>26.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3261251</th>\n",
       "      <td>The Return of the Pink Panther</td>\n",
       "      <td>1975</td>\n",
       "      <td>Mollie Maureen</td>\n",
       "      <td>actress</td>\n",
       "      <td>Little Old Lady</td>\n",
       "      <td>18.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3263145</th>\n",
       "      <td>Revenge of the Pink Panther</td>\n",
       "      <td>1978</td>\n",
       "      <td>Pepsi Maycock</td>\n",
       "      <td>actress</td>\n",
       "      <td>Sam Spade and the Private Eyes</td>\n",
       "      <td>23.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3266041</th>\n",
       "      <td>The Pink Panther</td>\n",
       "      <td>2006</td>\n",
       "      <td>Susan McBrien</td>\n",
       "      <td>actress</td>\n",
       "      <td>Strolling Pedestrian</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3324588</th>\n",
       "      <td>The Pink Panther</td>\n",
       "      <td>2006</td>\n",
       "      <td>Emily Mortimer</td>\n",
       "      <td>actress</td>\n",
       "      <td>Nicole</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3329333</th>\n",
       "      <td>Son of the Pink Panther</td>\n",
       "      <td>1993</td>\n",
       "      <td>Jacinta Mulcahy</td>\n",
       "      <td>actress</td>\n",
       "      <td>Louise Chauvin</td>\n",
       "      <td>30.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3346112</th>\n",
       "      <td>Trail of the Pink Panther</td>\n",
       "      <td>1982</td>\n",
       "      <td>Madlena Nedeva</td>\n",
       "      <td>actress</td>\n",
       "      <td>Mme. Dreyfuss</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3404457</th>\n",
       "      <td>Son of the Pink Panther</td>\n",
       "      <td>1993</td>\n",
       "      <td>Natasha Pavlovich</td>\n",
       "      <td>actress</td>\n",
       "      <td>Rima</td>\n",
       "      <td>16.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3408498</th>\n",
       "      <td>The Pink Panther</td>\n",
       "      <td>2006</td>\n",
       "      <td>Colleen Pelletier</td>\n",
       "      <td>actress</td>\n",
       "      <td>Passenger at JFK</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3536888</th>\n",
       "      <td>The Return of the Pink Panther</td>\n",
       "      <td>1975</td>\n",
       "      <td>Catherine Schell</td>\n",
       "      <td>actress</td>\n",
       "      <td>Lady Claudine Litton</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3543590</th>\n",
       "      <td>The Pink Panther</td>\n",
       "      <td>2006</td>\n",
       "      <td>Yvonne Sci?</td>\n",
       "      <td>actress</td>\n",
       "      <td>Casino Waitress</td>\n",
       "      <td>45.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3559848</th>\n",
       "      <td>Revenge of the Pink Panther</td>\n",
       "      <td>1978</td>\n",
       "      <td>Christine Shaw</td>\n",
       "      <td>actress</td>\n",
       "      <td>Nurse</td>\n",
       "      <td>48.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3572247</th>\n",
       "      <td>Curse of the Pink Panther</td>\n",
       "      <td>1983</td>\n",
       "      <td>Tusse Silberg</td>\n",
       "      <td>actress</td>\n",
       "      <td>Spanish Nurse</td>\n",
       "      <td>50.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3574043</th>\n",
       "      <td>Revenge of the Pink Panther</td>\n",
       "      <td>1978</td>\n",
       "      <td>Jacqui Simm</td>\n",
       "      <td>actress</td>\n",
       "      <td>Chinese Lady of Easy Virtue</td>\n",
       "      <td>30.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3586027</th>\n",
       "      <td>Curse of the Pink Panther</td>\n",
       "      <td>1983</td>\n",
       "      <td>Liz Smith</td>\n",
       "      <td>actress</td>\n",
       "      <td>Marta Balls</td>\n",
       "      <td>27.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3586043</th>\n",
       "      <td>Son of the Pink Panther</td>\n",
       "      <td>1993</td>\n",
       "      <td>Liz Smith</td>\n",
       "      <td>actress</td>\n",
       "      <td>Marta Balls</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3586053</th>\n",
       "      <td>Trail of the Pink Panther</td>\n",
       "      <td>1982</td>\n",
       "      <td>Liz Smith</td>\n",
       "      <td>actress</td>\n",
       "      <td>Martha Balls</td>\n",
       "      <td>17.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3597621</th>\n",
       "      <td>Curse of the Pink Panther</td>\n",
       "      <td>1983</td>\n",
       "      <td>Jacqueline Spears</td>\n",
       "      <td>actress</td>\n",
       "      <td>Figure In Black</td>\n",
       "      <td>58.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3601531</th>\n",
       "      <td>Trail of the Pink Panther</td>\n",
       "      <td>1982</td>\n",
       "      <td>Kathleen St. John</td>\n",
       "      <td>actress</td>\n",
       "      <td>Nanna</td>\n",
       "      <td>21.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3634190</th>\n",
       "      <td>The Pink Panther</td>\n",
       "      <td>2006</td>\n",
       "      <td>Alice Taglioni</td>\n",
       "      <td>actress</td>\n",
       "      <td>Female Reporter</td>\n",
       "      <td>24.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3639018</th>\n",
       "      <td>Revenge of the Pink Panther</td>\n",
       "      <td>1978</td>\n",
       "      <td>Maureen Tann</td>\n",
       "      <td>actress</td>\n",
       "      <td>Chinese Lady of Easy Virtue</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3677833</th>\n",
       "      <td>The Pink Panther</td>\n",
       "      <td>2006</td>\n",
       "      <td>Mira Tzur</td>\n",
       "      <td>actress</td>\n",
       "      <td>Escort</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3719322</th>\n",
       "      <td>Curse of the Pink Panther</td>\n",
       "      <td>1983</td>\n",
       "      <td>Emma Walton Hamilton</td>\n",
       "      <td>actress</td>\n",
       "      <td>Angry Hooker</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3727830</th>\n",
       "      <td>Revenge of the Pink Panther</td>\n",
       "      <td>1978</td>\n",
       "      <td>Rita Webb</td>\n",
       "      <td>actress</td>\n",
       "      <td>Lady at Window</td>\n",
       "      <td>53.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3730761</th>\n",
       "      <td>Revenge of the Pink Panther</td>\n",
       "      <td>1978</td>\n",
       "      <td>Elisabeth Welch</td>\n",
       "      <td>actress</td>\n",
       "      <td>Mrs. Wu</td>\n",
       "      <td>24.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3731248</th>\n",
       "      <td>The Pink Panther</td>\n",
       "      <td>1963</td>\n",
       "      <td>Meri Welles</td>\n",
       "      <td>actress</td>\n",
       "      <td>Monica Fawn</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3733044</th>\n",
       "      <td>The Pink Panther</td>\n",
       "      <td>2006</td>\n",
       "      <td>Colleen Werthmann</td>\n",
       "      <td>actress</td>\n",
       "      <td>Jane</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3755769</th>\n",
       "      <td>The Pink Panther</td>\n",
       "      <td>2006</td>\n",
       "      <td>Jadin Wong</td>\n",
       "      <td>actress</td>\n",
       "      <td>Granny</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3766595</th>\n",
       "      <td>Revenge of the Pink Panther</td>\n",
       "      <td>1978</td>\n",
       "      <td>Rosita Yarboy</td>\n",
       "      <td>actress</td>\n",
       "      <td>Sam Spade and the Private Eyes</td>\n",
       "      <td>21.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>363 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  title  year                    name  \\\n",
       "1010                   The Pink Panther  2006          William Abadie   \n",
       "2100        Revenge of the Pink Panther  1978          Fredric Abbott   \n",
       "4921          Curse of the Pink Panther  1983           William Abney   \n",
       "13007           Son of the Pink Panther  1993              Tony Adams   \n",
       "13008    The Return of the Pink Panther  1975              Tony Adams   \n",
       "14470    The Return of the Pink Panther  1975             Yashaw Adem   \n",
       "15078                  The Pink Panther  2006       Scott (II) Adkins   \n",
       "34701       Revenge of the Pink Panther  1978         Lewis Alexander   \n",
       "40517       Revenge of the Pink Panther  1978             Irvin Allen   \n",
       "57923                  The Pink Panther  2006  Patrick (III) Anderson   \n",
       "69064       Revenge of the Pink Panther  1978             Paul Antrim   \n",
       "81803         Curse of the Pink Panther  1983              Peter Arne   \n",
       "81830    The Return of the Pink Panther  1975              Peter Arne   \n",
       "81835         Trail of the Pink Panther  1982              Peter Arne   \n",
       "86621                  The Pink Panther  2006          Michael Arthur   \n",
       "91155    The Return of the Pink Panther  1975          Gr?goire Aslan   \n",
       "97538           Son of the Pink Panther  1993            Harry Audley   \n",
       "98058       Revenge of the Pink Panther  1978          Charles Augins   \n",
       "146145                 The Pink Panther  1963             John Bartha   \n",
       "150085      Revenge of the Pink Panther  1978              Alfie Bass   \n",
       "163599      Revenge of the Pink Panther  1978            Tony Beckley   \n",
       "166216        Curse of the Pink Panther  1983        Geoffrey Beevers   \n",
       "169654                 The Pink Panther  2006             Dexter Bell   \n",
       "170855      Revenge of the Pink Panther  1978            Michael Bell   \n",
       "177799          Son of the Pink Panther  1993         Roberto Benigni   \n",
       "184021        Trail of the Pink Panther  1982           Harold Berens   \n",
       "204729                 The Pink Panther  1963          Riccardo Billi   \n",
       "215948        Trail of the Pink Panther  1982           Colin Blakely   \n",
       "218205                 The Pink Panther  2006     Antoine Blanquefort   \n",
       "223474      Revenge of the Pink Panther  1978            John Bluthal   \n",
       "...                                 ...   ...                     ...   \n",
       "3229849                The Pink Panther  2006         Charlotte Maier   \n",
       "3261242       Curse of the Pink Panther  1983          Mollie Maureen   \n",
       "3261251  The Return of the Pink Panther  1975          Mollie Maureen   \n",
       "3263145     Revenge of the Pink Panther  1978           Pepsi Maycock   \n",
       "3266041                The Pink Panther  2006           Susan McBrien   \n",
       "3324588                The Pink Panther  2006          Emily Mortimer   \n",
       "3329333         Son of the Pink Panther  1993         Jacinta Mulcahy   \n",
       "3346112       Trail of the Pink Panther  1982          Madlena Nedeva   \n",
       "3404457         Son of the Pink Panther  1993       Natasha Pavlovich   \n",
       "3408498                The Pink Panther  2006       Colleen Pelletier   \n",
       "3536888  The Return of the Pink Panther  1975        Catherine Schell   \n",
       "3543590                The Pink Panther  2006             Yvonne Sci?   \n",
       "3559848     Revenge of the Pink Panther  1978          Christine Shaw   \n",
       "3572247       Curse of the Pink Panther  1983           Tusse Silberg   \n",
       "3574043     Revenge of the Pink Panther  1978             Jacqui Simm   \n",
       "3586027       Curse of the Pink Panther  1983               Liz Smith   \n",
       "3586043         Son of the Pink Panther  1993               Liz Smith   \n",
       "3586053       Trail of the Pink Panther  1982               Liz Smith   \n",
       "3597621       Curse of the Pink Panther  1983       Jacqueline Spears   \n",
       "3601531       Trail of the Pink Panther  1982       Kathleen St. John   \n",
       "3634190                The Pink Panther  2006          Alice Taglioni   \n",
       "3639018     Revenge of the Pink Panther  1978            Maureen Tann   \n",
       "3677833                The Pink Panther  2006               Mira Tzur   \n",
       "3719322       Curse of the Pink Panther  1983    Emma Walton Hamilton   \n",
       "3727830     Revenge of the Pink Panther  1978               Rita Webb   \n",
       "3730761     Revenge of the Pink Panther  1978         Elisabeth Welch   \n",
       "3731248                The Pink Panther  1963             Meri Welles   \n",
       "3733044                The Pink Panther  2006       Colleen Werthmann   \n",
       "3755769                The Pink Panther  2006              Jadin Wong   \n",
       "3766595     Revenge of the Pink Panther  1978           Rosita Yarboy   \n",
       "\n",
       "            type                                character     n  \n",
       "1010       actor                                     Bizu  11.0  \n",
       "2100       actor                        Douvier's Soldier  38.0  \n",
       "4921       actor                        Hugo the Houseman  33.0  \n",
       "13007      actor                            Wedding Guest   NaN  \n",
       "13008      actor                                   Waiter   NaN  \n",
       "14470      actor                             Museum Guard  24.0  \n",
       "15078      actor                                 Jacquard  20.0  \n",
       "34701      actor  Attendee at Clouseau's Memorial Service   NaN  \n",
       "40517      actor                              Haig & Haig  17.0  \n",
       "57923      actor                          NYC Firefighter   NaN  \n",
       "69064      actor                                  Lookout  40.0  \n",
       "81803      actor                           General Bufoni  14.0  \n",
       "81830      actor                           Colonel Sharki   5.0  \n",
       "81835      actor                              Col. Bufoni  11.0  \n",
       "86621      actor                               Officer #1   NaN  \n",
       "91155      actor                   Chief of Lugash Police   7.0  \n",
       "97538      actor                                    Pilot  29.0  \n",
       "98058      actor                            Vic Vancouver  16.0  \n",
       "146145     actor                                Policeman   NaN  \n",
       "150085     actor                                   Fernet  11.0  \n",
       "163599     actor                                 Guy Algo   6.0  \n",
       "166216     actor                                Concierge  37.0  \n",
       "169654     actor                        Terry Ahkee-Sauce  33.0  \n",
       "170855     actor                             Claude Russo   NaN  \n",
       "177799     actor               Gendarme Jacques Gambrelli   1.0  \n",
       "184021     actor                              Hotel Clerk  22.0  \n",
       "204729     actor                        Aristotle Sarajos  11.0  \n",
       "215948     actor           Section Director Alec Drummond   NaN  \n",
       "218205     actor                        Ballroom Reporter  44.0  \n",
       "223474     actor                        Guard at Cemetery  54.0  \n",
       "...          ...                                      ...   ...  \n",
       "3229849  actress                       Dialect Instructor  17.0  \n",
       "3261242  actress                            Rich Old Lady  26.0  \n",
       "3261251  actress                          Little Old Lady  18.0  \n",
       "3263145  actress           Sam Spade and the Private Eyes  23.0  \n",
       "3266041  actress                     Strolling Pedestrian   NaN  \n",
       "3324588  actress                                   Nicole   4.0  \n",
       "3329333  actress                           Louise Chauvin  30.0  \n",
       "3346112  actress                            Mme. Dreyfuss  25.0  \n",
       "3404457  actress                                     Rima  16.0  \n",
       "3408498  actress                         Passenger at JFK   NaN  \n",
       "3536888  actress                     Lady Claudine Litton   3.0  \n",
       "3543590  actress                          Casino Waitress  45.0  \n",
       "3559848  actress                                    Nurse  48.0  \n",
       "3572247  actress                            Spanish Nurse  50.0  \n",
       "3574043  actress              Chinese Lady of Easy Virtue  30.0  \n",
       "3586027  actress                              Marta Balls  27.0  \n",
       "3586043  actress                              Marta Balls  20.0  \n",
       "3586053  actress                             Martha Balls  17.0  \n",
       "3597621  actress                          Figure In Black  58.0  \n",
       "3601531  actress                                    Nanna  21.0  \n",
       "3634190  actress                          Female Reporter  24.0  \n",
       "3639018  actress              Chinese Lady of Easy Virtue  28.0  \n",
       "3677833  actress                                   Escort   NaN  \n",
       "3719322  actress                             Angry Hooker  20.0  \n",
       "3727830  actress                           Lady at Window  53.0  \n",
       "3730761  actress                                  Mrs. Wu  24.0  \n",
       "3731248  actress                              Monica Fawn  12.0  \n",
       "3733044  actress                                     Jane   NaN  \n",
       "3755769  actress                                   Granny   NaN  \n",
       "3766595  actress           Sam Spade and the Private Eyes  21.0  \n",
       "\n",
       "[363 rows x 6 columns]"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cast[cast.title.str.endswith('Pink Panther')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "year\n",
       "1963    21\n",
       "1975    30\n",
       "1978    68\n",
       "1982    41\n",
       "1983    67\n",
       "1993    46\n",
       "2006    90\n",
       "dtype: int64"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cast[cast.title.str.endswith( 'Pink Panther')].groupby(['year']).size()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "### List, in order by year, each of the films in which Frank Oz has played more than 1 role."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "year  title                                         \n",
       "1979  The Muppet Movie                                  8\n",
       "1980  Star Wars: Episode V - The Empire Strikes Back    1\n",
       "      The Blues Brothers                                1\n",
       "1981  An American Werewolf in London                    2\n",
       "      The Great Muppet Caper                            6\n",
       "1982  The Dark Crystal                                  2\n",
       "1983  Star Wars: Episode VI - Return of the Jedi        1\n",
       "      Superman III                                      1\n",
       "      Trading Places                                    1\n",
       "1984  The Muppets Take Manhattan                        7\n",
       "1985  Follow That Bird                                  3\n",
       "      Spies Like Us                                     1\n",
       "1986  Labyrinth                                         1\n",
       "1992  Innocent Blood                                    1\n",
       "      The Muppet Christmas Carol                        7\n",
       "1996  Muppet Treasure Island                            4\n",
       "1998  Blues Brothers 2000                               1\n",
       "1999  Muppets from Space                                4\n",
       "      Star Wars: Episode I - The Phantom Menace         1\n",
       "      The Adventures of Elmo in Grouchland              3\n",
       "2001  Monsters, Inc.                                    1\n",
       "2002  Star Wars: Episode II - Attack of the Clones      1\n",
       "2005  Star Wars: Episode III - Revenge of the Sith      1\n",
       "      Zathura: A Space Adventure                        1\n",
       "2010  Sesame Street: C is for Cookie Monster            1\n",
       "2015  Inside Out                                        1\n",
       "      Star Wars: Episode VII - The Force Awakens        1\n",
       "      The Great Gilly Hopkins                           1\n",
       "dtype: int64"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "frank_oz = cast[cast.name == 'Frank Oz'].groupby(['year','title']).size()\n",
    "frank_oz"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "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  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": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "frank_oz[frank_oz > 1]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "### List each of the characters that Frank Oz has portrayed at least twice."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "character\n",
       "Animal                                                  6\n",
       "Aughra, a Keeper Of Secrets (performer)                 1\n",
       "Bert                                                    3\n",
       "Brain Surgeon                                           1\n",
       "Chamberlain (performer)                                 1\n",
       "Cookie Monster                                          5\n",
       "Corrections Officer                                     1\n",
       "Corrupt Cop                                             1\n",
       "Doc Hopper's Men                                        1\n",
       "Fozzie                                                  1\n",
       "Fozzie Bear                                             4\n",
       "Fozzie Bear as Fozziewig                                1\n",
       "Fungus                                                  1\n",
       "George the Janitor                                      1\n",
       "Gramps                                                  1\n",
       "Grover                                                  2\n",
       "Horse and Carriage Driver                               1\n",
       "Marvin Suggs                                            1\n",
       "Miss Piggy                                              6\n",
       "Miss Piggy as Emily Cratchit                            1\n",
       "Motorcycle Guy                                          1\n",
       "Mr. Collins                                             1\n",
       "Ocean Breeze Soap Board Member                          1\n",
       "Pathologist                                             1\n",
       "Robot                                                   1\n",
       "Sam the Eagle                                           5\n",
       "Sam the Eagle as Headmaster of Junior High Graduates    1\n",
       "Subconscious Guard Dave                                 1\n",
       "Swedish Chef                                            1\n",
       "Swedish Chef (assistant)                                1\n",
       "Test Monitor                                            1\n",
       "The Wiseman                                             1\n",
       "Vegetable Salesman                                      1\n",
       "Warden                                                  1\n",
       "Yoda                                                    6\n",
       "dtype: int64"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "frank_oz_characters = cast[cast.name == 'Frank Oz'].groupby(['character']).size()\n",
    "frank_oz_characters"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "character\n",
       "Animal            6\n",
       "Bert              3\n",
       "Cookie Monster    5\n",
       "Fozzie Bear       4\n",
       "Grover            2\n",
       "Miss Piggy        6\n",
       "Sam the Eagle     5\n",
       "Yoda              6\n",
       "dtype: int64"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "frank_oz_characters[frank_oz_characters > 1]"
   ]
  },
  {
   "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.6.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}