Solutions-5.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",
       "      <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": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cast = pd.read_csv('data/cast.csv')\n",
    "cast.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>country</th>\n",
       "      <th>date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>#73, Shaanthi Nivaasa</td>\n",
       "      <td>2007</td>\n",
       "      <td>India</td>\n",
       "      <td>2007-06-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>#Beings</td>\n",
       "      <td>2015</td>\n",
       "      <td>Romania</td>\n",
       "      <td>2015-01-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>#Ewankosau saranghaeyo</td>\n",
       "      <td>2015</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>2015-01-21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>#Nerealnaya lyubov</td>\n",
       "      <td>2014</td>\n",
       "      <td>Russia</td>\n",
       "      <td>2014-02-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>#Stuck</td>\n",
       "      <td>2014</td>\n",
       "      <td>Turkey</td>\n",
       "      <td>2014-07-01</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    title  year      country       date\n",
       "0   #73, Shaanthi Nivaasa  2007        India 2007-06-15\n",
       "1                 #Beings  2015      Romania 2015-01-29\n",
       "2  #Ewankosau saranghaeyo  2015  Philippines 2015-01-21\n",
       "3      #Nerealnaya lyubov  2014       Russia 2014-02-13\n",
       "4                  #Stuck  2014       Turkey 2014-07-01"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "release_dates = pd.read_csv('data/release_dates.csv', \n",
    "                                      parse_dates=['date'], infer_datetime_format=True)\n",
    "release_dates.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x7fad7bc9f400>"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAWwAAAEBCAYAAABc9Z89AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAFNJJREFUeJzt3X+MZXd93vH3Yy+/DMQLgqy3QLJV1EDbEC2ERjQIZSCQ\nbqrINUla1U0UG0hUqSq4qIlwm0q4QSo2LTRRqqaqsPGSKERRUAgGEezQncSWFfMjO876V9xKrGq3\neIHYBgyNAuHTP+4Z79xh7p3ZmXPmnjvf90u68j3n3Hue8z1z9zt3njlznapCkjR+Fy36ACRJO+OE\nLUlLwglbkpaEE7YkLQknbElaEk7YkrQk5k7YSZ6e5K4ka0nuS/Kubv11SR5Ocrq7ndifw5WkdmW7\n67CTXFJVX09yCLgD+AXgR4CvVtV79+EYJUnsoBKpqq93d58KXAw81i1nqIOSJH27bSfsJBclWQPO\nAaeq6t5u01uS3J3kxiSHBz1KSdL2lciTD0wuBT4BXAvcB3yx2/RO4GhVvXmQI5QkAXBopw+sqi8n\n+RjwiqpaXV+f5H3ALZsfn8QPKZGkXaiqrSvnqpp5A54HHO7uPwP4Yya/cLxsw2PeBvzWFs+tefve\n7gZct5fnL1tui2P2XLeR7Zgv+Lk1a9t277CPAieTXMSk7/6Nqvpkkg8kOQ4U8Dngn+/wG8eFODbA\nPsecu8js1nIXmb2o3EVmLyp3kdmD5M6dsKvqDPDyLdb/7BAHI0mabcx/6XhzY7mLzG4td5HZi8pd\nZPaicheZPUjujq8SueAdJ1WzinNJ0pbmzZ2jfYedZKWl3EVmt5a7yGzH3Eb2ULmjnbAlSdOsRCRp\nRJayEpEkTRvthH3QuqcxZ7eWu8hsx9xGth22JDXODluSLlAfn5U0a36cN3fu+MOfJEkb7WXO3t17\n2dFWIgetexpzdmu5i8x2zK1krw6y19FO2JKkaXbYknSBJh323iqR3XTYvsOWpCUx2gnbvs3cg5jt\nmFvJXh1kr6OdsCVJ0+ywJekC2WFLkuYa7YRt32buQcx2zK1krw6y19FO2JKkaXbYknSBFtVh+1ki\nkpbWXj+EadneVI62ErFvM/cgZjvmIdSc26k524a0Oshe507YSZ6e5K4ka0nuS/Kubv1zk9yW5MEk\ntyY5PMjRSZKetG2HneSSqvp6kkPAHcAvAJcDX6qqdyd5O/Ccqrp20/PssCUNam9d8uweedjc+dl7\nug67qr7e3X0qcDHwGJMJ+2S3/iRwxQUfryTpgmw7YSe5KMkacA44VVX3Akeq6lz3kHPAkb4P7OD2\nbePLbi13kdmOeb+tHqjcba8SqapvAceTXAp8IslrNm2vPv53OZKk+XZ8WV9VfTnJx4AfAM4luayq\nHklyFPjCVs9JcjNwtlt8HFirqtVu20q33y2X19ft9PEHZXnj2Pcrv6pWWxrvxsxFf71bON9Dvr7O\nW+3+u3KByxO7ef1M9jFr/9tvX3/9dfu+ult9ljnm/tIxyfOAb1bV40meAXwC+PfAPwD+oqpuSHIt\ncNhfOkrab/7ScdpR4H90HfZdwC1V9UngeuD1SR4EXtst96rFvq21MXuu28i2w+7P3Eqkqs4AL99i\n/aPA6wY5IknSlvwsEUlLy0pEkjRKo52wW+zbWhuz57qNbDvs/ox2wpYkTbPDlrS07LAlSaM02gm7\nxb6ttTF7rtvItsPuz2gnbEnSNDtsSUvLDluSNEqjnbBb7NtaG7Pnuo1sO+z+jHbCliRNs8OWtLTs\nsCVJozTaCbvFvq21MXuu28i2w+7PaCdsSdI0O2xJS8sOW5I0SqOdsFvs21obs+e6jWw77P6MdsKW\nJE2zw5a0tOywJUmjNNoJu8W+rbUxe67byLbD7s/cCTvJi5KcSnJvknuSvLVbf12Sh5Oc7m4nBjk6\nSdKT5nbYSS4DLquqtSTPAj4LXAH8E+CrVfXeOc+1w5Y0qNY67EPzdllVjwCPdPefSHI/8IInEyVJ\n+2bHHXaSY8DLgD/pVr0lyd1JbkxyuO8Da7Fva23Mnus2su2w+zP3Hfa6rg75XeCa7p32rwO/3G1+\nJ/Ae4M1bPO9m4Gy3+DiwVlWr3bYVgFnLwPEkM7cPtbzh2Pclb9Pycbqv9ILymxkvvr4WkT/Y+Tw/\nQa5sWt7Z9l28frp9bN7f+vLajLzzh51kpapWu31f3a0+yxzbXoed5CnAR4GPV9WvbLH9GHBLVb10\n03o7bEmDaq3D3u4qkQA3AvdtnKyTHN3wsDcAZy78gCVJF2K7DvtVwM8Ar9lwCd+PATck+bMkdwM/\nDLyt7wNrsW9rbcye6zay7bD7s91VInew9aT+8UGORpI0k58lImlp2WFLkkZptBN2i31ba2P2XLeR\nbYfdn9FO2JKkaXbYkpaWHbYkaZRGO2G32Le1NmbPdRvZdtj9Ge2ELUmaZoctaWnZYUuSRmm0E3aL\nfVtrY/Zct5Fth92f0U7YkqRpdtiSlpYdtiRplEY7YbfYt7U2Zs91G9l22P0Z7YQtSZpmhy1padlh\nS5JGabQTdot9W2tj9ly3kW2H3Z/RTtiSpGl22JKWlh22JGmURjtht9i3tTZmz3Ub2XbY/Zk7YSd5\nUZJTSe5Nck+St3brn5vktiQPJrk1yeFBjk6S9KS5HXaSy4DLqmotybOAzwJXAG8EvlRV707yduA5\nVXXtpufaYUsalB32BlX1SFWtdfefAO4HXgBcDpzsHnaSySQuSRrQjjvsJMeAlwF3AUeq6ly36Rxw\npO8Da7Fva23Mnus2su2w+3NoJw/q6pAPAddU1VeT8+/Wq6omPx5s+bybgbPd4uPAWlWtdttWuudv\nuQwcTzJz+1DLG459X/I2LR+n+0ovKL+Z8eLraxH5g53P8xPkyqblnW3fxeun28fm/a0vr83IO3/Y\nSVaqarXb99Xd6rPMse112EmeAnwU+HhV/Uq37gFgpaoeSXIUOFVVL9n0PDtsSYOyw55+YoAbgfvW\nJ+vOR4CruvtXAR++8AOWJF2I7TrsVwE/A7wmyenudgK4Hnh9kgeB13bLvWqxb2ttzJ7rNrLtsPsz\nt8OuqjuYPam/rv/DkSTN4meJSFpadtiSpFEa7YTdYt/W2pg9121k22H3Z7QTtiRpmh22pKVlhy1J\nGqXRTtgt9m2tjdlz3Ua2HXZ/RjthS5Km2WFLWlp22JKkURrthN1i39bamD3XbWTbYfdntBO2JGma\nHbakpWWHLUkapdFO2C32ba2N2XPdRrYddn9GO2FLkqbZYUtaWnbYkqRRGu2E3WLf1tqYPddtZNth\n92e0E7YkaZodtqSlZYctSRql0U7YLfZtrY3Zc91Gth12f7adsJPclORckjMb1l2X5OEkp7vbiUGO\nTpL0pG077CSvBp4APlBVL+3WvQP4alW9d87z7LAlDcoOe5Oquh14bMtESdK+2UuH/ZYkdye5Mcnh\n3o6o02Lf1tqYPddtZNth9+fQLp/368Avd/ffCbwHePPmByW5GTjbLT4OrFXVardtBWDWMnA8yczt\nQy1vOPZ9ydu0fJzuK72g/GbGi6+vReQPdj7PT5Arm5Z3tn0Xr59uH5v3t768NiPv/GEnWamq1W7f\nV3erzzLHjq7DTnIMuGW9w97JNjtsSUOzw95JVHJ0w+IbgDOzHitJ6sdOLuv7IHAn8OIkDyV5E3BD\nkj9Lcjfww8Db+j6wFvu21sbsuW4j2w67P9t22FV15RarbxrgWCRJc/hZIpKWlh22JGmURjtht9i3\ntTZmz3Ub2XbY/RnthC1JmmaHLWlp2WFLkkZptBN2i31ba2P2XLeRbYfdn9FO2JKkaXbYkpaWHbYk\naZRGO2G32Le1NmbPdRvZdtj9Ge2ELUmaZoctaWnZYUuSRmm0E3aLfVtrY/ZcH5zsJLWX21DHZYct\nSVuqGbdTc7YNOFcfQHbYkvZsObtkO2xJ0kBGO2HbMZp7ELNbHPPieuRFZg+TO9oJW5I0zQ5b0p4t\nZ5dshy1JGshoJ2w7RnMPYnaLY7bD7s+2E3aSm5KcS3Jmw7rnJrktyYNJbk1yeJCjkyQ9adsOO8mr\ngSeAD1TVS7t17wa+VFXvTvJ24DlVde2m59lhS41Yzi75AHbYVXU78Nim1ZcDJ7v7J4ErLuBIJUm7\nsNsO+0hVnevunwOO9HQ8T7JjNPcgZrc4Zjvs/hza6w6qauaHtyS5GTjbLT4OrFXVardtpXv+lsvA\n8SQztw+1vOHY9yVv0/Jxuq/0gvKbGS++vnrd/8QqsLLhPjte3uv5nL3/nW3vf7xrM/LOH3aSlapa\n7fZ9dbf6LHPs6DrsJMeAWzZ02A8AK1X1SJKjwKmqesmm59hhS41Yzi75AHbYM3wEuKq7fxXw4V3u\nR5K0Qzu5rO+DwJ3Ai5M8lOSNwPXA65M8CLy2W+6VHaO5BzG7xTHbYfdn2w67qq6csel1PR+LJGkO\nP0tE0p4tZ5fcToctSdpno52w7RjNPYjZLY7ZDrs/o52wJUnT7LAl7dlydsl22JKkgYx2wrZjNPcg\nZrc4Zjvs/ox2wpYkTbPDlrRny9kl22FLkgYy2gnbjtHcg5jd4pjtsPsz2glbkjTNDlvSni1nl2yH\nLUkayGgnbDtGcw9idotjtsPuz2gnbEnSNDtsSXu2nF2yHbYkaSCjnbDtGM09iNktjtkOuz+jnbAl\nSdPssCXt2XJ2yXbYkqSBjHbCtmM09yBmtzhmO+z+HNrLk5OcBb4C/DXwjar6wT4OSpL07fbUYSf5\nHPADVfXoFtvssKVGLGeX3GaH7aQsSftgrxN2AX+Y5DNJfr6PA1pnx2juQcxuccx22P3ZU4cNvKqq\nPp/k+cBtSR6oqtvXNya5GTjbLT4OrFXVardtBWDWMnA8ycztQy1vOPZ9ydu0fJzuK72g/GbGi6+v\nXvc/sQqsbLjPjpf3ej5n739n2/sf79qMvPOHnWSlqla7fV/drT7LHL1dh53kHcATVfWebtkOW2rE\ncnbJDXXYSS5J8uzu/jOBHwXO7HZ/kqT59tJhHwFuT7IG3AV8tKpu7eew7BjNPZjZLY7ZDrs/u+6w\nq+pzTDoxSdI+8LNEJO3ZcnbJDXXYkqT9NdoJ247R3IOY3eKY7bD7M9oJW5I0zQ5b0p4tZ5dshy1J\nGshoJ2w7RnMPYnaLY7bD7s9oJ2xJ0jQ7bEl7tpxdsh22JGkgo52w7RjNPYjZLY7ZDrs/o52wJUnT\n7LAl7dlydsl22JKkgSxswk5Se7kNeFwrQ+17rNmt5Q6d7Wt7s9XFxC40e5jcBb/Drjm3U3O2SWO3\nm9e1r23Nt7AOe1HdkzS0Fl/by9kl22FLkgYy4gl7dSGpB7VXNXcs2auLiaXNMdthS5IWwg5b6lmL\nr+3l7JKXr8Pe9f81fZnt9dKpvX2Rly93kdnLlrtILY65NbuuRJKcSPJAkv+Z5O19HtTEav+7nLKo\ny64WdSnjbnOHzD6o53qe1YH33+KYx5g9TO6uJuwkFwP/BTgB/B3gyiR/u88Dg7V+dzf63EVmt5a7\nyGzH3Eb2MLm7fYf9g8D/qqqzVfUN4LeBf9TfYQE83u/uRp+7yOzWcheZ7ZjbyB4md7cT9guAhzYs\nP9ytkyQNZLcT9j78De3Z4SNGlbvI7NZyF5m9qNxFZi8qd5HZw+Tu6rK+JK8ErquqE93yvwG+VVU3\nbHiMH4wgSbsw85K/XU7Yh4A/B34E+L/Ap4Arq+r+vRykJGm2XV2HXVXfTPIvgU8AFwM3OllL0rAG\n+0tHSVK/mvxLx3XdteN/A7irqp7YsP5EVf3B4o5sfyR5NZNLNM9U1a0D5rwSuL+qvpzkEuBa4OXA\nvcB/qKovD5j9VuD3quqhbR/cb+7TgH8K/J+q+sMkPw38EHAf8N+7y2GHzP8e4CeAFwLfYlJh/lZV\nfWXIXA1r1B/+lOSNA+77rcCHgbcA9ya5YsPmdw2VO+d4PrAPGZ/acP/ngV8DngW8o/vF8VBuAr7W\n3f9V4DuA64H/B7x/wFyAdwKfSnJHkn+R5PkD5617P/APgWuS/AbwU8CfMPkG+b4hg5NcA/w34Gld\n3tOA7wLuSvKaIbM1sKoa7Q14aMB93wM8q7t/DPgM8K+65dMDj+sW4CPdf9dvX1tfP2Du6Q33PwM8\nv7v/TOCeAXPv33D/Tzdtu3vgc32ayRuTH2XyjeOLwB8AVwHPHjD3TPffQ8AXgEPdcta3DZh9D3Bx\nd/8S4I+6+98FrA2Ye5jJN+IHgMeAR7v71wOHhxzzNsf18QH3fWk3vt8E/tmmbf+177yFVyJJzszZ\n/J1DRldXg1TV2e6zgj+U5LuZ/KMa0guZ/Gj8PiY/rgZ4BfCfBs69OMlzu7yLq+qLAFX1tSTfHDD3\n3iRvqqqbgLuT/L2q+nSS7wX+asBcAKrqW8CtwK1Jngr8GHAl8B7geQPFXtTVIpcAz2DyD/svgKcz\n/E+2BTwF+Osu75kAVfW/kzxlwNzfAT4JrADnqqqSHGXyzfF3mHzTHESSl8/aBLxsqFwmP0k9CHwI\neFOSnwR+uqr+Evj7fYctfMJmMimfYPIdebM7B8z9QpLjVbUGUFVPJPlx4Ebg+wfMhcnkfA3wS8Av\nVtXpJH9ZVX80cO53AJ/t7leSo1X1+STPHjj354BfTfLvmLzDvTPJw0z+WvbnBs6eUlV/Bfw+8PtJ\nnjlg1G8C9wPfAP41cHuSO4FXAicHzIXJG4FPJ7kLeDVwA0CS72TyTWMox2rD32IAVNXngeuTvGnA\nXIBPA388Y9ulA+Z+T1X9RHf/95L8EvDJJD1/VMfEwq8SSXIT8P6qun2LbR+sqisHyn0R8I2qemTT\n+gCvqqo7hsjdlPVC4D8z+ZH58qp60dCZM47jEuBIVX1u4JxLgb/J5I3Cw5vP/UCZL66qPx86Z0b2\nMeArVfVo90vAVwAPVNXd+5D9fcBLmFRdDwyd12XeBtwGnKyqc926y5i8w359Vb1uwOx7gTdU1YNb\nbHtoqH9bSe4H/m73U9z6uquBX2RSuX53r3mLnrAF3Tv7H6qqf7voY5F2q6vbrgUuB450q88x+X3N\n9VX16IDZ/5jJ7wa+7ZtTkiuq6sMD5f5H4Naqum3T+hPAr1XV3+o1zwlb0tCSvLGqhr4iaFb2+u9P\nlj7XCVvS4IasJcaaPUTuGH7pKOkA2OaKryNzti1t9n7nOmFL6suirvhaZPa+5jphS+rLx5hcGXF6\n84YkQ1+yuqjsfc21w5akJTHqzxKRJJ3nhC1JS8IJW5KWhBO2JC0JJ2xJWhL/H6/HaLvWlYLDAAAA\nAElFTkSuQmCC\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x7fad7ccf49b0>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Make a bar plot of the months in which movies\n",
    "# with \"Christmas\" in their title tend to be released in the USA.\n",
    "\n",
    "rd = release_dates\n",
    "rd = rd[rd.title.str.contains('Christmas')]\n",
    "rd = rd[rd.country == 'USA']\n",
    "rd.date.dt.month.value_counts().sort_index().plot(kind='bar')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x7fad7ca8f6d8>"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAW8AAAEBCAYAAAC3wiQ+AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAADpBJREFUeJzt3X+o3fV9x/HXy1yLA0dFZGFNbgnMCBUKC4yY2TLP6Arx\nQuM/wnSMEveHIgSH7A+HCN2gpfuzc6LLH2rSFQxSqaiNlFI8acsg3TQ3tRpH8seFJGKE6RVrGDPt\nu3+c701OT87Pm8/J9/v+3ucDLp7P+X48vLlwX/fj637P0REhAEAu19Q9AABgdoQ3ACREeANAQoQ3\nACREeANAQoQ3ACQ0NrxtX2f7qO1l22/b/vaIfY/bPmn7uO0d8xkVALBmYdzFiPg/238ZEedtL0j6\nue0vR8TP1/bYXpJ0c0Rst32bpKck7Zrv2ACwsU2sTSLifPXwM5I2SfpgYMseSQervUcl3WB7c8kh\nAQC/b2J4277G9rKkc5Jei4i3B7ZskXS6b31G0tZyIwIABk1z8v5tRPypeoH8F7Y7Q7Z58F8rMBsA\nYISxnXe/iPjI9g8l/Zmkbt+ls5IW+9Zbq+d+j20CHQDWISIGD8jjw9v2TZIuRMSq7T+Q9FVJ/zyw\n7SVJ+yQdsr1L0mpEnJt2AKxP75chvw/L+KfqC2WYn/WCRh18J528/1jSQdvXqFex/EdE/MT2A5IU\nEfsj4rDtJdunJH0i6b6SgwPzt1L3AMDMfLU+EtZ28Nu4HE7eJe2VdKDmGdqEk3dJo7KTd1gC2lv3\nAMDMOHknxckbzcXJuyRO3sBI3boHAGZGeANAQtQmSVGboLmoTUqiNgGAFiG8ATpvJER4A0BCdN5J\n0Xmjuei8S6LzBoAWIbwBOm8kRHgDQEJ03knReaO56LxLovMGgBYhvAE6byREeANAQnTeSdF5o7no\nvEui8waAFiG8ATpvJER4A0BCdN5J0Xmjuei8S6LzBoAWIbwBOm8kRHgDQEJ03knReaO56LxLovMG\ngBYhvAE6byREeANAQmPD2/ai7ddsv2X7V7YfGrKnY/sj28eqr8fmNy4wD526BwBmtjDh+qeSHo6I\nZdvXS3rd9o8j4sTAviMRsWc+IwIABo09eUfEexGxXD3+taQTkj43ZCt/WUZi3boHAGY2dedte5uk\nHZKODlwKSbfbPm77sO1by40HABhmqvu8q8qkK+mbEfHiwLU/lPSbiDhv+05J/xoRtwx5De7zLoj7\nvNFc3Odd0qjsnNR5y/a1kl6Q9L3B4JakiPi47/Grtp+0fWNEfDDktQ5IWqmWq5KWI6JbXetUr8F6\ninVPV5f+2Lb2NGvW9a/r/vnIvK4e7+19Py/m5WXGnrxtW9JBSf8bEQ+P2LNZ0vsREbZ3Sno+IrYN\n2cfJuyBO3iV1xR0nJXHyLmm9J+8vSfpbSb+0fax67lFJn5ekiNgv6W5JD9q+IOm8pHuKTQ0AGIrP\nNkmKkzeai5N3SXy2CQC0COENcJ83EiK8ASAhOu+k6LzRXHTeJdF5A0CLEN4AnTcSIrwBICE676To\nvNFcdN4l0XkDQIsQ3gCdNxIivAEgITrvpOi80Vx03iXReQNAixDeAJ03EiK8ASAhOu+k6LzRXHTe\nJdF5A0CLEN4AnTcSIrwBICE676TovNFcdN4l0XkDQIsQ3gCdNxIivAEgITrvpOi80Vx03iXReQNA\nixDeAJ03EiK8ASAhOu+k6LzRXHTeJdF5A0CLjA1v24u2X7P9lu1f2X5oxL7HbZ+0fdz2jvmMCsxL\nt+4BgJktTLj+qaSHI2LZ9vWSXrf944g4sbbB9pKkmyNiu+3bJD0ladf8RgYAjD15R8R7EbFcPf61\npBOSPjewbY+kg9Weo5JusL15DrMCc9KpewBgZlN33ra3Sdoh6ejApS2STvetz0jaeqWDAQBGm1Sb\nSJKqyuT7kv6+OoFftmVgPfQ2CNsHJK1Uy1VJyxHRra51JIn1dOueri6dGteeZj37eu1xU+bJv677\n5yPzunq8t/f9vJiXl5l4q6DtayW9IunViPjOkOv/LqkbEYeq9TuS7oiIcwP7uFWwIG4VLKkrqpOS\nuFWwpHXdKmjbkp6W9Paw4K68JOnr1f5dklYHgxtotk7dAwAzG3vytv1lST+V9EtdOuY9KunzkhQR\n+6t9T0jaLekTSfdFxBtDXouTd0GcvNFcnLxLGpWdvMMyKcK7pK44fZdEeJfEOywBoEU4eSfFyRvN\nxcm7JE7eANAihDfAZ5sgIcIbABKi806KzhvNReddEp03ALQI4Q3QeSMhwhsAEqLzTorOG81F510S\nnTcAtAjhDdB5IyHCGwASovNOis4bzUXnXRKdNwC0COEN0HkjIcIbABKi806KzhvNReddEp03ALQI\n4Q3QeSMhwhsAEqLzTorOG81F510SnTcAtAjhDdB5IyHCGwASovNOis4bzUXnXRKdNwC0COEN0Hkj\noYnhbfsZ2+dsvzniesf2R7aPVV+PlR8TANBvYYo9z0r6N0nfHbPnSETsKTMScLV16h4AmNnEk3dE\n/EzShxO28ccJALiKSnTeIel228dtH7Z9a4HXBK6ibt0DADObpjaZ5A1JixFx3vadkl6UdEuB1wUA\njHDF4R0RH/c9ftX2k7ZvjIgPBvfaPiBppVquSlqOiG51rVO9Busp1j1dXepr155mPfu607B58q/r\n/vnIvK4e7+19Py/m5WWmepOO7W2SXo6ILw65tlnS+xERtndKej4itg3Zx5t0CuJNOmgu3qRT0qjs\nnHjytv2cpDsk3WT7tKRvSLpWkiJiv6S7JT1o+4Kk85LuKTk4MH9dcccJsuHt8Ulx8i6pK8K7JE7e\nJY3KTsI7KcIbzUV4l8RnmwBAixDeAPd5IyHCGwASovNOis4bzUXnXRKdNwC0COEN0HkjIcIbABKi\n806KzhvNReddEp03ALQI4Q3QeSMhwhsAEqLzTorOG81F510SnTcAtAjhDdB5IyHCGwASovNOis4b\nzUXnXRKdNwC0COEN0HkjIcIbABKi806KzhvNReddEp03ALQI4Q3QeSMhwhsAEqLzTorOG81F510S\nnTcAtAjhDdB5IyHCGwASmhjetp+xfc72m2P2PG77pO3jtneUHRGYt07dAwAzm+bk/ayk3aMu2l6S\ndHNEbJd0v6SnCs0GABhhYnhHxM8kfThmyx5JB6u9RyXdYHtzmfGAq6Fb9wDAzEp03lskne5bn5G0\ntcDrAgBGKPUHy8F7ELkBGYl06h4AmNlCgdc4K2mxb721eu4ytg9IWqmWq5KWI6JbXetIEuvp1j1d\nXQqetadZs65/XffPR+Z19Xhv7/t5MS8vM9U7LG1vk/RyRHxxyLUlSfsiYsn2LknfiYhdQ/bxDsuC\neIdlSV1x+i6Jd1iWNCo7J568bT8n6Q5JN9k+Lekbkq6VpIjYHxGHbS/ZPiXpE0n3lR0dADCIzzZJ\nipM3mouTd0l8tgkAtAjhDXCfNxIivAEgITrvpOi80Vx03iXReQNAixDeAJ03EiK8ASAhOu+k6LzR\nXHTeJdF5A0CLEN4AnTcSIrwBICE676TovNFcdN4l0XkDQIsQ3gCdNxIivAEgITrvpOi80Vx03iXR\neQNAixDeAJ03EiK8ASAhOu+k6LzRXHTeJdF5A0CLEN4AnTcSIrwBICE676TovNFcdN4l0XkDQIsQ\n3gCdNxIivAEgITrvpOi80Vx03iWtu/O2vdv2O7ZP2n5kyPWO7Y9sH6u+His1NABguIVxF21vkvSE\npL+SdFbSf9l+KSJODGw9EhF75jQjMGddSZ2aZwBmM+nkvVPSqYhYiYhPJR2SdNeQffwnEgBcRZPC\ne4uk033rM9Vz/ULS7baP2z5s+9aSAwLz16l7AGBmY2sTTfcXsTckLUbEedt3SnpR0i1XPBkAYKRJ\n4X1W0mLfelG90/dFEfFx3+NXbT9p+8aI+GDwxWwfkLRSLVclLUdEt7rWqV6D9RTrnq4unRrXnmY9\n+3rtcVPmyb+u++cj87p6vLf3/byYl5cZe6ug7QVJ/yPpK5LelfQLSff2/8HS9mZJ70dE2N4p6fmI\n2DbktbhVsCBuFSypK6qTkrhVsKRR2Tn25B0RF2zvk/QjSZskPR0RJ2w/UF3fL+luSQ/aviDpvKR7\nik8PzFWn7gGAmfEmnaQ4eaO5OHmXxAdTASN16x4AmBnhDQAJUZskRW2C5qI2KYnaBABahPAG6LyR\nEOENAAnReSdF543movMuic4bAFqE8AbovJEQ4Q0ACdF5J0Xnjeai8y6JzhsAWoTwBui8kRDhDQAJ\n0XknReeN5qLzLonOGwBahPAG6LyREOENAAnReSdF543movMuic4bAFqE8AbovJEQ4Q0ACdF5J0Xn\njeai8y6JzhsAWoTwBui8kRDhDQAJ0XknReeN5qLzLonOGwBaZGJ4295t+x3bJ20/MmLP49X147Z3\nlB8TmKdu3QMAMxsb3rY3SXpC0m5Jt0q61/YXBvYsSbo5IrZLul/SU3OaFZiT5boHAGY26eS9U9Kp\niFiJiE8lHZJ018CePZIOSlJEHJV0g+3NxScF5ma17gGAmU0K7y2STvetz1TPTdqz9cpHAwCMMim8\np72dYfAvodwGgURW6h4AmNnChOtnJS32rRfVO1mP27O1eu4yvdvbUA53Y5VzsO4BWoWf9fmbFN7/\nLWm77W2S3pX015LuHdjzkqR9kg7Z3iVpNSLODb4Q930CQDljwzsiLtjeJ+lHkjZJejoiTth+oLq+\nPyIO216yfUrSJ5Lum/vUALDBXbV3WAIAyuEdlgCQEOENAAkR3tgwbH/W9r/Y/p7tvxm49mRdcwHr\nQXhjI3m2+ucL6n3Uwwu2r6ue+/OaZgLWhfDGRvInEfGPEfGDiPiapDck/cT2TXUPBsxq0n3eQJt8\nxvY1EfFbSYqIb9k+K+mIpOvrHQ2YDSdvbCSvSPpK/xMRcUDSP0j6/zoGAtaL+7wBSbb/LiKeqXsO\nYFqENyDJ9umIWJy8E2gGOm9sGLbfHHOZz6BHKoQ3NpI/Uu//CvXhkGv/eZVnAa4I4Y2N5IeSro+I\nY4MXbB+pYR5g3ei8ASAhbhUEgIQIbwBIiPAGgIQIbwBIiPAGgIR+By6XC/HCLf2UAAAAAElFTkSu\nQmCC\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x7fad7ca8b9b0>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Make a bar plot of the months in which movies\n",
    "# whose titles start with \"The Hobbit\" are released in the USA.\n",
    "\n",
    "rd = release_dates\n",
    "rd = rd[rd.title.str.startswith('The Hobbit')]\n",
    "rd = rd[rd.country == 'USA']\n",
    "rd.date.dt.month.value_counts().sort_index().plot(kind='bar')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x7fad7ca57198>"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAWwAAAD7CAYAAABOi672AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAFEdJREFUeJzt3WuMXHd9xvHnSUxEws1EFMdAVCO15aJCTZoi1BSxCaQy\nUhXCm0qRUBNu6hvCRQIlvQmrSE2ICgW1Em9wsNNK6QsqRQkVJQH8rxJFNYV6jbGTBqqsFLfYBJHQ\nmEAh5NcXc4yXze6Z2Tkz8zv/Pd+PtNKcuf0f/zP+Zfbx2VlHhAAA/XdOdgAAwGQY2ABQCQY2AFSC\ngQ0AlWBgA0AlGNgAUInWgW372bYP2V62fdz2Tc31e22fsH24+dqzmLgAMFwedx627Qsi4knb2yTd\nJ+nDkt4s6YmI+OQCMgIANEElEhFPNhfPk3SupMeaY88rFADgmcYObNvn2F6WdErSwYg41tx0ve0j\ntvfZ3j7XlACA8ZXIL+5ov0DSlyTdKOm4pEebmz4maWdEvHvN/fmZdwCYQkSs22Bs28QT/ND2P0u6\nNCLKmettf1bSXZtZdBZs742IvfN6/nkjfy7y56o5/7yzt73ZHXeWyIvO1B22z5d0paTDti9adbe3\nSzo6i6AAgI2Ne4e9U9IB2+doNNz/PiK+Yvs227slhaSHJf3xnHOuZ1fCmrO0KztAR7uyA3S0KztA\nR7uyA3S0KztAB7uyFm4d2BFxVNIl61z/R3NLNLnl7AAdkT8X+XPVnD8t+8T/6LjpJ7Zjnh02AGxF\nbbOTH00HgEpUO7BtL2Vn6IL8ucifq+b8mdmrHdgAMDR02ADQI3TYALAFVDuwa+7AJPJnI3+umvPT\nYQMAxqLDBoAeocMGgC2g2oFdcwcmkT8b+XPVnJ8OGwAwFh02APQIHTYAbAHVDuyaOzCJ/NnIn6tP\n+W3HvL9mlbXagQ0AsxOb+Dq4yfvPDh02gEEbvQOe5+8M96Z+vy0dNgBsAdUO7D51YNMgfy7y56o7\nf0lbudqBDQBDQ4cNYNDosAEAM1ftwK67AyN/NvLnqjt/SVu5dWDbfrbtQ7aXbR+3fVNz/YW277H9\nkO27bW9fTFwAGK6xHbbtCyLiSdvbJN0n6cOSrpL0/Yi4xfYNkl4YETeueRwdNoDe21IddkQ82Vw8\nT9K5kh7TaGAfaK4/IOnqScMAAKYzdmDbPsf2sqRTkg5GxDFJOyLiVHOXU5J2zDHjRrmWFr3mLJE/\nF/lz1Z2/pK28bdwdIuJpSbttv0DSl2xfvub2DT/cxPZ+SSvN4eOSliOiNLctNY+f6rjJNPXjs4/J\nT37y9yf/2SG8pHkct63fXL6uecCKWmzqPGzbfyHpx5LeI2kpIk7a3qnRO+9XrrkvHTaA3tsyHbbt\nF505A8T2+ZKulHRY0p2Srm3udq2kOyYNAwCYzrgOe6ekrzYd9iFJd0XEVyTdLOlK2w9JuqI5Xqi6\nOzDyZyN/rrrzl7SVWzvsiDgq6ZJ1rv+BpLfMKxQA4Jn4LBEAg7ZlOmwAQH9UO7Dr7sDIn438uerO\nX9JWrnZgA8DQ0GEDGDQ6bADAzFU7sOvuwMifjfy56s5f0laudmADwNDQYQMYNDpsAMDMVTuw6+7A\nyJ+N/Lnqzl/SVq52YAPA0NBhAxg0OmwAwMxVO7Dr7sDIn438uerOX9JWrnZgA8DQ0GEDGDQ6bADA\nzFU7sOvuwMifjfy56s5f0laudmADwNDQYQMYNDpsAMDMVTuw6+7AyJ+N/Lnqzl/SVm4d2LYvtn3Q\n9jHb37L9/ub6vbZP2D7cfO1ZTFwAGK7WDtv2RZIuiohl28+V9A1JV0v6Q0lPRMQnWx5Lhw2g92rq\nsLe1PTAiTko62Vw+bfsBSS/9RQoAwMJM3GHb3iXpdZL+rbnqettHbO+zvX0O2cblWVr0mrNE/lzk\nz1V3/pK2cus77DOaOuTzkj7QvNP+jKS/bG7+mKRPSHr3Oo/bL2mlOXxc0nJElOa2JUma9ljSbttT\nPz77mPzkJ39/8p8dwkuax3Hb+s3l65oHrKjF2POwbT9L0hckfTEiPrXO7bsk3RURr1lzPR02gN6r\nqcMed5aIJe2TdHz1sLa9c9Xd3i7p6KRhAADTGddhXybpHZIuX3UK31slfdz2N20fkfQmSR+ad9C1\n6u7AyJ+N/Lnqzl/SVh53lsh9Wn+of3E+cQAAG+GzRAAM2pbpsAEA/VHtwK67AyN/NvLnqjt/SVu5\n2oENAENDhw1g0OiwAQAzV+3ArrsDI3828ueqO39JW7nagQ0AQ0OHDWDQ6LABADNX7cCuuwMjfzby\n56o7f0lbudqBDQBDQ4cNYNDosAEAM1ftwK67AyN/NvLnqjt/SVu52oENAENDhw1g0OiwAQAzV+3A\nrrsDI3828ueqO39JW7nagQ0AQ0OHDWDQauqwW39r+iKNNm2++B8IgJr1rBKJTXwd3OT9+6XuDo/8\n2cifqaSt3DqwbV9s+6DtY7a/Zfv9zfUX2r7H9kO277a9fTFxAWC4Wjts2xdJuigilm0/V9I3JF0t\n6Z2Svh8Rt9i+QdILI+LGNY/dVIfdtx4JwDD0bfZMfR52RJyMiOXm8mlJD0h6qaSrJB1o7nZAoyEO\nAJijiTts27skvU7SIUk7IuJUc9MpSTtmnmyssvglZ6juDo/82cifqaStPNFZIk0d8k+SPhART9hn\n361HRGx0hoft/ZJWmsPHJS1HRGluW2oeX84+okhaWnVZLcfLY25fezxac6P1F30sabfttPXJT37y\nr85zJtaS5nHctn5z+brmAStqMfY8bNvPkvQFSV+MiE811z0oaSkiTtreKelgRLxyzePosAH0Xt9m\nz9QdtkdvpfdJOn5mWDfulHRtc/laSXdMGgYAMJ1xHfZlkt4h6XLbh5uvPZJulnSl7YckXdEcL1hZ\n/JIzVHeHR/5s5M9U0lZu7bAj4j5tPNTfMvs4AICN9OazRPrWIwEYhr7Nnqk7bABAf1Q8sEt2gE7q\n7vDIn438mUrayhUPbAAYFjpsAIPWt9lDhw0AW0DFA7tkB+ik7g6P/NnIn6mkrVzxwAaAYaHDBjBo\nfZs9dNgAsAVUPLBLdoBO6u7wyJ+N/JlK2soVD2wAGBY6bACD1rfZQ4cNAFtAxQO7ZAfopO4Oj/yz\nZjvm/ZX9Z1ytb/u/OSVt5YoHNrDVxCa+Dm7y/tgK6LCBHuD1n6dve0+HDQBbQMUDu2QH6KTuDo/8\n+Up2gE7q3v+StnLFAxsAhoUOG+gBXv95+rb3dNgAsAVUPLBLdoBO6u7wyJ+vZAfopO79L2krjx3Y\ntm+1fcr20VXX7bV9wvbh5mvPfGMCAMZ22LbfKOm0pNsi4jXNdR+V9EREfLLlcXTYwIR4/efp2953\n6rAj4l5Jj62bAgCwMF067OttH7G9z/b2mSWaWFn8kjNUd4dH/nwlO0Ande9/SVt52oH9GUkvl7Rb\n0nclfWK9O9ne3/Tde21/cPV/JNtLz/yPVtZcbjte3uT9f/lFsnb9RR9L2t2nPORPzyNe/5l5ija3\nn5s7blu/ubz/zLxUi4nOw7a9S9JdZzrsSW4zHTYwMV7/efq2922zc6p32LZ3rjp8u6SjG90XADAb\nk5zWd7uk+yW9wvYjtt8l6eO2v2n7iKQ3SfrQnHOuoyx+yRl65rfDdSF/tpIdoJO697+krbxt3B0i\n4pp1rr51DlkAAC34LBGgB3j95+nb3s+8wwYALF7FA7tkB+ik7g6P/PlKdoBO6t7/krZyxQMbAIaF\nDhvoAV7/efq293TYALAFVDywS3aATuru8Mifr2QH6KTu/S9pK1c8sAFgWOiwgR7g9Z+nb3tPhw0A\nW0DFA7tkB+ik7g6P/PlKdoBO6t7/krZyxQMbAIaFDhvoAV7/efq293TYALAFVDywS3aATuru8Mif\nr2QH6KTu/S9pK1c8sAFgWOiwgR7g9Z+nb3tPhw0AW0DFA7tkB+ik7g6P/PlKdoBO6t7/krZyxQMb\nAIaFDhuSzuz/fLH/G+P1n6dve982O8f+1nQMyXxftAC6qbgSKdkBOqm7w5PY/2wlO0Ande9/SVt5\n7MC2favtU7aPrrruQtv32H7I9t22t883JgBgbIdt+42STku6LSJe01x3i6TvR8Qttm+Q9MKIuHHN\n4+iwK8L+52L/8/Rt7zudhx0R90p6bM3VV0k60Fw+IOnqScMAAKYzbYe9IyJONZdPSdoxozybUBa/\n5AzV3eFJ7H+2kh2gk7r3v6St3PkskYiIjU4Js71f0kpz+Lik5YgozW1LzePL2UcUSUurLqvleHnM\n7WuPR2tutP6ijyXttp22PvvP/if/eXu2/2v3a7bHbes3l69rHrCiFhOdh217l6S7VnXYD0paioiT\ntndKOhgRr1zzGDrsirD/udj/PH3b+3l8lsidkq5tLl8r6Y4pnwcAMKFJTuu7XdL9kl5h+xHb75R0\ns6QrbT8k6YrmeMHK4pecobo7PIn9z1ayA3RS9/6XtJXHdtgRcc0GN71lxlkAAC34LBFIYv+zsf95\n+rb3fB42AGwBFQ/skh2gk7o7PIn9z1ayA3RS9/6XtJUrHtgAMCx02JDE/mdj//P0be/psAFgC6h4\nYJfsAJ3U3eFJ7H+2kh2gk7r3v6StzG+cAdDZNL9izp68oaHOGaHDhiT2P1vt+z/f/DVnl+iwAWCA\nKh7YJTtAJ3V3eBL7n61kB+ioZAfooKStXPHABoBhocOGJPY/W+37T4fdugIdNgAMTcUDu2QH6IQO\nNRf7n61kB+igpK1c8cAGgGGhw4Yk9j9b7ftPh926Ah02AAxNxQO7ZAfohA41F/ufrWQH6KCkrVzx\nwAaAYaHDhiT2P1vt+0+H3boCHTYADE3FA7tkB+iEDjUX+5+tZAfooKSt3OnzsG2vSPpfST+X9LOI\neP0sQgEAnqlTh237YUm/HRE/WOc2OuyKsP+5at9/OuzWFXrVYfOXEAAWoOvADklftv112++dRaDJ\nlcUuN2N0qLnY/2wlO0AHJW3lrr/T8bKI+K7tX5F0j+0HI+LeMzfa3i9ppTl8XNJyRJTmtiVJOnM8\nUiQtrbqsluPlMbevPR6tudH6iz6WtNt22vpbcP/n+jsFG5ez/zn55//6H5e323Hb+s3l65oHrKjF\nzM7Dtv1RSacj4hPNMR12RWrff/KPXaHi/DVnl3rRYdu+wPbzmsvPkfT7ko5O+3wAgHZdOuwdku61\nvSzpkKQvRMTds4k1ibK4peaADjVbyQ7QUckO0FHJDtBBSVt56g47Ih6WtHuGWQAALfgsEUiqf//J\nP3aFivPXnF3qRYcNAFisigd2yQ7QCR12tpIdoKOSHaCjkh2gg5K2csUDGwCGhQ4bkurff/KPXaHi\n/DVnl+iwAWCAKh7YJTtAJ3TY2Up2gI5KdoCOSnaADkrayl0/SwSNRXyWBZUOMGx02LN6dvKPW4H8\nbc9O/rZnrzi7RIcNAANU8cAu2QE6KtkBOirZAToq2QE6KtkBOirZATooaStXPLABYFjosGf17OQf\ntwL5256d/G3PXnF2iQ4bAAao4oFdsgN0VLIDdFSyA3RUsgN0VLIDdFSyA3RQ0laueGADwLDQYc/q\n2ck/bgXytz07+dueveLsEh02AAxQxQO7ZAfoqGQH6KhkB+ioZAfoqGQH6KhkB+igpK1c8cAGgGGh\nw57Vs5N/3Arkb3t28rc9e8XZJTpsABigqQe27T22H7T9bds3zDLUZMril5ypkh2go5IdoKOSHaCj\nkh2go5IdoIOStvJUA9v2uZL+TtIeSa+WdI3tV80y2HjLi11u5sifi/y5as6fl33ad9ivl/SdiFiJ\niJ9J+kdJb5tdrEk8vtjlZo78ucifq+b8edmnHdgvlfTIquMTzXUAgDmZdmDP859UJ7SSHaCjlewA\nHa1kB+hoJTtARyvZATpayQ7QwUraylOd1mf7DZL2RsSe5vhPJD0dER9fdZ8eDHUAqM9Gp/VNO7C3\nSfpPSW+W9D+Svibpmoh4oEtIAMDGpvqt6RHxlO33SfqSpHMl7WNYA8B8ze0nHQEAszXVO+xFa87x\nfpvOnolyQtKdvKtfjGb/XyLpUEScXnX9noj4l7xkk7H9e5J+EBHHbS9JulTS4Yj4Sm6y4bH9Ro1O\nCz4aEXdn52nT/FvdAxHxQ9sXSLpR0iWSjkn6q4j44aIz9f5H05ufory9OTzUfJ0j6fbmHzurZfud\n2RnGsf1+SXdIul7SMdtXr7r5ppxUk7N9k6S/lnTA9i2SbpZ0vqSP2v5Iargp2b4tO8OkbH9t1eX3\nSvpbSc/VaP/7/vf3Vkk/ai5/WtLzNXr9/FjS5zIC9b4Ssf1tSa9ufkBn9fXnSToeEb+Wk6w7249E\nxMXZOdrY/pakN0TEadu7JH1e0j9ExKdsH46I16UGHMP2cUmvlXSepFOSXta8Yzpfo+8YXpsacAzb\nd2l0Gu3qswaukPRVSRERV6UEm9Dq14jtr0t6a0Q8avs5Gu3/b+Ym3JjtByLiVc3l/4iIS1bddiQi\nfmvRmWqoRH6uURWysub6lzS39Zrtoy03v3hhQabnMzVIRKw0lcI/2f5V/fIQ6aufRsRTkp6y/V9n\nvo2NiB/bfjo52yReJum4pM9KelqjPb9Uo+8aanCu7Qs1yn1uRDwqSRHxI9tP5UYb65jtd0XErZKO\n2P6diPh3278h6acZgWoY2B+U9GXb39HZn668WNKvS3pfWqrJvVijz1x5bJ3b7l9wlml8z/buiFiW\npOad9h9I2qfRO9e++z/bF0TEkxr1j5Ik29s1GoB9d6mkD0j6M0kfiYjDtn8SEf+anGtSz5f0jeZy\n2N4ZEd+1/bzMUBN6j6RP2/5zSY9Kut/2CY3m0HsyAvW+EpF+8WFTr9fonXZI+m9JX2/eOfWa7Vsl\nfS4i7l3nttsj4pqEWBOzfbGkn0XEyTXXW9JlEXFfTrLJ2H52RPxknetfJGlnRLR9B9Qbtl8m6W8k\nfU/SVX2v0sZp/hFvR0Q8nJ1lHNsvkPRyjd7gnlj7d2GhWWoY2ABGmu9ufjci/jQ7CxaPgQ0Alej9\naX0AgBEGNgBUgoENAJVgYANAJf4fnI1rJqK1iGkAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x7fad7ca5f8d0>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Make a bar plot of the day of the week on which movies\n",
    "# with \"Romance\" in their title tend to be released in the USA.\n",
    "\n",
    "rd = release_dates\n",
    "rd = rd[rd.title.str.contains('Romance')]\n",
    "rd = rd[rd.country == 'USA']\n",
    "rd.date.dt.dayofweek.value_counts().sort_index().plot(kind='bar')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x7fad7c9ba518>"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAWwAAAD7CAYAAABOi672AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAE1hJREFUeJzt3WusZWV9x/HfT6ZW8K6NVAvp0VasRuioaEiVelRIxsai\n75pJq45GXzTFW1sqamN95YXaqrHpi6rDQNTpRQ2RxFhRWQRDi7cZHGCo2njSQetAlaHBG+D8+2Kv\nKWuO5+yzznr2Pv/17PP9JCfsZ6291/qdh8PDPr9Ze40jQgCA8XtQdgAAQD8s2ABQCRZsAKgECzYA\nVIIFGwAqwYINAJWYumDb3mv7qO1Dq7a/zvZh2zfbfs98IwIApI3fYV8uaVd3g+0XSLpI0jkR8XRJ\n751TNgBAx9QFOyKul3TXqs1/LOldEXFf+5w755QNANAxpMN+sqTftf3vthvb5846FADgF+0Y+JpH\nR8R5tp8t6Z8lPWn1k2zzmXcAGCAivNb2IQv27ZI+1R70K7aP235sRPyg70lnwfY7IuId8zr+vJE/\nV835a84ukb/H8dd9szukErlK0gvbA58l6cFrLdYAgNma+g7b9n5Jz5f0WNtHJL1d0l5Je9tL/e6V\n9Iq5p1zbUtJ5Z2UpO0ChpewAhZayAxRYyg5QaCk7QKGlrBNPXbAjYvc6u14+hyybdTA7QCHy56o5\nf83ZJfIP5nndD9t2zLPDBoBFNG3t5KPpAFCJahds28vZGUqQP1fN+WvOLpG/RLULNgBsN3TYADAi\ndNgAsACqXbDpwXKRP0/N2SXyl6h2wQaA7YYOGwBGZNraOeTmTwBmaCvubMmbp8VQbSVCD5aL/LMW\nm/i6dpPPH5fxzf3m0GEDADZEhw0km1Qi83wnbCqRinAdNgAsgGoXbHqwXOTP1GQHKFL33NNhAwB6\noMMGktFho4sOGwAWQLULNj1YLvJnarIDFKl77kfcYdvea/to+xfurt73Z7aP237M/OIBAE6Y2mHb\nPl/SPZKujIizO9vPlPQhSU+R9KyI+OEar6XDBnqgw0bX4A47Iq6XdNcau/5W0l/MIBsAoKdNd9i2\nXyrp9oj4xhzybCbHcub5S5E/V935m+wAReqe+9z8m7pbn+3TJL1V0oXdzVOev0/SSjs8JulgRDTt\nvmVJGjqWtNP24Ndnj8lP/pPznIi1rHmMs78/xuuP28d7NLGiKTa8Dtv2kqSrI+Js22dL+rykH7e7\nz5D0XUnPiYg7Vr2ODhvogQ4bXTO7H3ZEHJJ0eufA39E6f+gIAJitjS7r2y/pBkln2T5i+1WrnpJ2\ns116sFzkz9RkByhS99yPuMOOiN0b7H/SbOMAANbDvUSAZHTY6OJeIgCwAKpdsOnBcpE/U5MdoEjd\ncz/ie4kAAMaDDhtIRoeNLjpsAFgA1S7Y9GC5yJ+pyQ5QpO65p8MGAPRAhw0ko8NGFx02ACyAahds\nerBc5M/UZAcoUvfc02EDAHqgwwaS0WGjiw4bABZAtQs2PVgu8mdqsgMUqXvu6bABAD3QYQPJ6LDR\nRYcNAAug2gWbHiwX+TM12QGK1D33I++wbe+1fdT2oc62v7Z92PZNtj9l+5HzjQkA2LDDtn2+pHsk\nXRkRZ7fbLpT0hYg4bvvdkhQRl656HR020AMdNrqKOuyIuF7SXau2XRMRx9vhjZLOKE4JAJhqFh32\nqyV9ZgbH2RR6sFzkz9RkByhS99zn5t9R8mLbb5N0b0R8fJ39+ySttMNjkg5GRNPuW5akoWNJO20P\nfn32mPzkPznPiVjLmsc4+/tjvP64fbxHEyuaotd12LaXJF19osNut+2R9FpJL4qIn67xGjpsoAc6\nbHRNWzsHvcO2vUvSJZKev9ZiDQCYvT6X9e2XdIOkp9g+YvvVkj4o6WGSrrF9wPbfzznnWrmWt/qc\ns0T+XHXnb7IDFKl77kfeYUfE7jU2751DFgDAFNxLBEhGh40u7iUCAAug2gWbHiwX+TM12QGK1D33\nI7+XCABgHOiwgWR02OiiwwaABVDtgk0Plov8mZrsAEXqnns6bABAD3TYQDI6bHTRYQPAAqh2waYH\ny0X+TE12gCJ1zz0dNgCgBzpsIBkdNrrosAFgAVS7YNOD5SJ/piY7QJG6554OGwDQAx02kIwOG110\n2ACwAKpdsOnBcpE/U5MdoEjdcz/iDtv2XttHbR/qbHuM7Wtsf9P252w/av4xAQBTO2zb50u6R9KV\nEXF2u+0ySf8TEZfZfrOkR0fEpWu8lg4b6IEOG12DO+yIuF7SXas2XyTpivbxFZJeVpwQALChIR32\n6RFxtH18VNLpM8zTGz1YLvJnarIDFKl77nPz7yh5cUTE5Ne5tdneJ2mlHR6TdDAimnbfcnuMQWNJ\nO20Pfn32mPzkPznPiVjLmsc4+/tjvP64fbxHEyuaYsPrsG0vSbq602HfJmk5Ir5v+/GSro2I31rj\ndXTYQA902Oia9XXYn5b0yvbxKyVdNTQYAKC/jS7r2y/pBklPsX3E9qskvVvShba/KemF7XjL0YPl\nIn+mJjtAkbrnfsQddkTsXmfXBXPIAgCYgnuJAMnosNHFvUQAYAFUu2DTg+Uif6YmO0CRuud+xPcS\nAQCMBx02kIwOG1102ACwAKpdsOnBcpE/U5MdoEjdc0+HDQDogQ4bSEaHjS46bABYANUu2PRgucif\nqckOUKTuuafDBgD0QIcNJKPDRhcdNgAsgGoXbHqwXOTP1GQHKFL33NNhAwB6oMMGktFho4sOGwAW\nQLULNj1YLvJnarIDFKl77ivtsG2/xfYttg/Z/rjtX55lMADAyQZ12LaXJH1R0lMj4me2/0nSZyLi\nis5z6LCBHuiw0TVt7Zz6t6ZP8b+S7pN0mu2fSzpN0ncHHgsA0MOgSiQifijpbyT9l6TvSToWEZ+f\nZbCN0IPlIn+mJjtAkbrnPjf/oHfYtn9D0hslLUm6W9K/2P7DiPjYquftk7TSDo9JOhgRTbtvWZKG\njiXttD349dlj8pP/5DwnYi1rHuPs74/x+uP28R5NrGiKoR32H0i6MCJe045fLum8iPiTznPosIEe\n6LDRNY/rsG+TdJ7tU21b0gWSbh0aEACwsaEd9k2SrpT0VUnfaDf/w6xC9UEPlov8mZrsAEXqnvsK\nO2xJiojLJF02wywAgCm4lwiQjA4bXdxLBAAWQLULNj1YLvJnarIDFKl77iu9lwgAYGvRYQPJ6LDR\nRYcNAAug2gWbHiwX+TM12QGK1D33dNgAgB7osIFkdNjoosMGgAVQ7YJND5aL/Jma7ABF6p57OmwA\nQA902EAyOmx00WEDwAKodsGmB8tF/kxNdoAidc89HTYAoAc6bCAZHTa66LABYAFUu2DTg+Uif6Ym\nO0CRuue+0g7b9qNsf8L2Ydu32j5vlsEAACcb3GHbvkLSdRGx1/YOSQ+NiLs7++mwgR7osNE1be0c\ntGDbfqSkAxHxpCEnBfAAFmx0zeMPHZ8o6U7bl9v+uu0P2T5teMTNowfLRf5MTXaAInXPfW7+HQWv\ne6akiyPiK7bfL+lSSW/vPsn2Pkkr7fCYpIMR0bT7liVp6FjSTtuDX589Jj/5T85zItay5jHO/v4Y\nrz9uH+/RxIqmGFqJ/Kqkf4uIJ7bj50m6NCJe0nkOlQjQA5UIumZeiUTE9yUdsX1Wu+kCSbcMzAcA\n6KHkOuzXSfqY7ZsknSPpnbOJ1A89WC7yZ2qyAxSpe+7r7LAVETdJevYMswAApuBeIkAyOmx0cS8R\nAFgA1S7Y9GC5yJ+pyQ5QpO65r/ReIgCArUWHDSSjw0YXHTYALIBqF2x6sFzkz9RkByhS99zTYQMA\neqDDBpLRYaOLDhsAFkC1CzY9WC7yZ2qyAxSpe+7psAEAPdBhA8nosNFFhw0AC6DaBZseLBf5MzXZ\nAYrUPfd02ACAHuiwgWR02OiiwwaABVDtgk0Plov8mZrsAEXqnvuKO2zbp9g+YPvqWQUCAKytqMO2\n/aeSniXp4RFx0ap9dNhAD3TY6JpLh237DEm/J+nDkvhhAIA5K6lE3ifpEknHZ5RlU+jBcpE/U5Md\noEjdc5+bf8eQF9l+iaQ7IuLAtPC290laaYfHJB2MiKbdtyxJQ8eSdtoe/PrsMfnJf3KeE7GWNY9x\n9vfHeP1x+3iPJlY0xaAO2/Y7Jb1c0v2SHiLpEZI+GRGv6DyHDhvogQ4bXdPWzuIPzth+vqQ/j4jf\n73tSAA9gwUbXVnxwZp4/bWuiB8tF/kxNdoAidc99hR12V0RcJ+m6GWQBAEzBvUSAZFQi6OJeIgCw\nAKpdsOnBcpE/U5MdoEjdc1/xvUQAAFuHDhtIRoeNLjpsAFgA1S7Y9GC5yJ+pyQ5QpO65p8MGAPRA\nhw0ko8NG17S1s/iTjlgMk0Vjvlg0MEY1/exXW4nQg81DbOLr2k0+f1zGOf99NdkBioxz7uv42a92\nwQaA7YYOG5LoUTMx97nGNv9chw0AC6DaBXucPVh/teenR83UZAcoUvfcS5nzX+2CDQDbDR02JI2v\nx9tOmPtcY5t/OmwAWACDF2zbZ9q+1vYttm+2/fpZButx/uWtPN+s1Z6fHjVTkx2gSN1zL2XOf8kn\nHe+T9KaIOGj7YZK+ZvuaiDg8o2wAgI6Zddi2r5L0wYj4Qjumw67I2Hq87YS5zzW2+Z97h217SdIz\nJN04i+MBAH5R8YLd1iGfkPSGiLinPFLv8y5v1bnmofb89KiZmuwAReqee6nWDlu2f0nSJyV9NCKu\nWmP/Pkkr7fCYpIMR0bT7liVp6FjSTtuDX589Hlv+iUbScuexpowPbrB/9Xhyzjl+P5v+ndbedEvw\ngvnNf/uP3vO5ufE8f362au7nlX9y+PYfCfPfPt7TvmBFUwzusD2Z8Ssk/SAi3rTGfjrsioytx9v0\n0SvOX3N2ifw9zjCKDvu5kv5I0gtsH2i/dhUcDwAwxeAFOyK+FBEPioidEfGM9uuzsww3Te09WO35\na+9R687fZAco1GQHKNSknZlPOgJAJbiXCCSNr8fb9NErzl9zdon8Pc4wig4bALCFql2wa++Aa89P\nD5mpyQ5QqMkOUKhJO3O1CzYAbDd02JA0vh5v00evOH/N2SXy9zgDHTYAbDfVLti1d8C156eHzNRk\nByjUZAco1KSdudoFGwC2GzpsSBpfj7fpo1ecv+bsEvl7nGFmHXbR3fpmacgdvzZr/v/S54v/AQLb\n28gqkdjE17WbfD75Z6vJDlCoyQ5QoMkOUKjJDlCoSTvzyBZsAMB6RtNhj61H2vTRyb/RGci/3pEr\nzi6Rv8cZuA4bALabihfsJjtAoSY7QKEmO0ChJjtAgSY7QKEmO0ChJu3MFS/YALC90GHP6ujk3+gM\n5F/vyBVnl8jf4wx02ACw3QxesG3vsn2b7W/ZfvMsQ/XTbP0pZ6rJDlCoyQ5QqMkOUKDJDlCoyQ5Q\nqEk786AF2/Ypkv5O0i5JT5O02/ZTZxlsYwe39nQzR/5cNeevObtE/uGGvsN+jqRvR8RKRNwn6R8l\nvXR2sfo4trWnmzny56o5f83ZJfIPN3TB/jVJRzrj29ttAIA5Gbpgj+DmFivZAQqtZAcotJIdoNBK\ndoACK9kBCq1kByi0knbmQZf12T5P0jsiYlc7fouk4xHxns5zRrCoA0B91rusb+iCvUPSf0h6kaTv\nSfqypN0RcbgkJABgfYPuhx0R99u+WNK/SjpF0kdYrAFgvub2SUcAwGyN5m+cmaa9xvuleuBKlNsl\nfZp39Vujnf8nSLoxIu7pbN8VEZ/NS9aP7edJ+mFE3Nr+5cfnSjoQEV/ITba92D5fk0uCD0XE57Lz\nbKT9s7rDEXG37dMkXSrpmZJukfTOiLh7qzON/qPp7aco97fDG9uvB0na3/5hZ7Vsvyo7w0Zsv17S\nVZJeJ+kW2y/r7H5XTqr+bL9L0nslXWH7MknvlnSqpL+yfUlquAFsX5mdoS/bX+48fq2kD0p6mCZz\nX8N/u3sl/ah9/AFJj9Dk5+cnki7PCDT6SsT2tyQ9rf2ATnf7gyXdGhG/mZOsnO0jEXFmdo5pbN8s\n6byIuMf2kqRPSPpoRLzf9oGIeEZqwA3YvlXSOZIeLOmopDPad0ynavIbwzmpAaewfbUml9B2rxh4\noaQvSoqIuCglWE/dnw/bX5X04oi40/ZDNZn7p+cmnM724Yh4avv46xHxzM6+myLit7c6Uw2VyM81\nqUJWVm1/Qrtv1GwfmrL7cVsWZDifqEEiYqWtFD5p+9d18kIyVvdGxP2S7rf9nyd+jY2In9g+npxt\nI2dIulXShyUd12S+z9XkN4YanGL7MZrkPiUi7pSkiPiR7ftzo/Vyi+1XR8ReSTfZfnZEfMX2WZLu\nzQhUw4L9Rkmft/1tPfDpyjMlPVnSxWmp+nucJvdcuWuNfTdscZYh7rC9MyIOSlL7Tvslkj6iyTvX\nsfuZ7dMi4sea9I+SJNuP0mQRHLNzJb1B0tskXRIRB2z/NCKuS87V1yMkfa19HLYfHxH/bfvhmaE2\n4TWSPmD7LyXdKekG27drsg69JiPQ6CsR6f9vNvUcTd5ph6TvSvpq+85p1GzvlXR5RFy/xr79EbE7\nIVZvts+UdF9EfH/Vdkt6bkR8KSdZP7YfEhE/XWP7r0h6fERM+w1oFGyfIel9ku6QdNHYa7SNtH+A\nd3pEfCc7Sx+2HynpiZq8wb199X8LW5qlhgUbgNT+ZvM7EfHW7CzIwYINAJUY/WV9AIAJFmwAqAQL\nNgBUggUbACrxf50vriSqgvopAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x7fad7c9c4908>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Make a bar plot of the day of the week on which movies\n",
    "# with \"Action\" in their title tend to be released in the USA.\n",
    "\n",
    "rd = release_dates\n",
    "rd = rd[rd.title.str.contains('Action')]\n",
    "rd = rd[rd.country == 'USA']\n",
    "rd.date.dt.dayofweek.value_counts().sort_index().plot(kind='bar')"
   ]
  },
  {
   "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>title</th>\n",
       "      <th>year</th>\n",
       "      <th>name</th>\n",
       "      <th>type</th>\n",
       "      <th>character</th>\n",
       "      <th>n</th>\n",
       "      <th>country</th>\n",
       "      <th>date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>GoldenEye</td>\n",
       "      <td>1995</td>\n",
       "      <td>Judi Dench</td>\n",
       "      <td>actress</td>\n",
       "      <td>M</td>\n",
       "      <td>6</td>\n",
       "      <td>USA</td>\n",
       "      <td>1995-11-17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Jack &amp; Sarah</td>\n",
       "      <td>1995</td>\n",
       "      <td>Judi Dench</td>\n",
       "      <td>actress</td>\n",
       "      <td>Margaret</td>\n",
       "      <td>3</td>\n",
       "      <td>USA</td>\n",
       "      <td>1996-03-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Hamlet</td>\n",
       "      <td>1996</td>\n",
       "      <td>Judi Dench</td>\n",
       "      <td>actress</td>\n",
       "      <td>Hecuba</td>\n",
       "      <td>12</td>\n",
       "      <td>USA</td>\n",
       "      <td>1996-12-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Mrs Brown</td>\n",
       "      <td>1997</td>\n",
       "      <td>Judi Dench</td>\n",
       "      <td>actress</td>\n",
       "      <td>Queen Victoria</td>\n",
       "      <td>1</td>\n",
       "      <td>USA</td>\n",
       "      <td>1997-07-18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Tomorrow Never Dies</td>\n",
       "      <td>1997</td>\n",
       "      <td>Judi Dench</td>\n",
       "      <td>actress</td>\n",
       "      <td>M</td>\n",
       "      <td>9</td>\n",
       "      <td>USA</td>\n",
       "      <td>1997-12-19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Shakespeare in Love</td>\n",
       "      <td>1998</td>\n",
       "      <td>Judi Dench</td>\n",
       "      <td>actress</td>\n",
       "      <td>Queen Elizabeth</td>\n",
       "      <td>12</td>\n",
       "      <td>USA</td>\n",
       "      <td>1999-01-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Tea with Mussolini</td>\n",
       "      <td>1999</td>\n",
       "      <td>Judi Dench</td>\n",
       "      <td>actress</td>\n",
       "      <td>Arabella</td>\n",
       "      <td>2</td>\n",
       "      <td>USA</td>\n",
       "      <td>1999-05-14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>The World Is Not Enough</td>\n",
       "      <td>1999</td>\n",
       "      <td>Judi Dench</td>\n",
       "      <td>actress</td>\n",
       "      <td>M</td>\n",
       "      <td>6</td>\n",
       "      <td>USA</td>\n",
       "      <td>1999-11-19</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     title  year        name     type        character   n  \\\n",
       "0                GoldenEye  1995  Judi Dench  actress                M   6   \n",
       "2             Jack & Sarah  1995  Judi Dench  actress         Margaret   3   \n",
       "1                   Hamlet  1996  Judi Dench  actress           Hecuba  12   \n",
       "3                Mrs Brown  1997  Judi Dench  actress   Queen Victoria   1   \n",
       "7      Tomorrow Never Dies  1997  Judi Dench  actress                M   9   \n",
       "4      Shakespeare in Love  1998  Judi Dench  actress  Queen Elizabeth  12   \n",
       "5       Tea with Mussolini  1999  Judi Dench  actress         Arabella   2   \n",
       "6  The World Is Not Enough  1999  Judi Dench  actress                M   6   \n",
       "\n",
       "  country       date  \n",
       "0     USA 1995-11-17  \n",
       "2     USA 1996-03-22  \n",
       "1     USA 1996-12-25  \n",
       "3     USA 1997-07-18  \n",
       "7     USA 1997-12-19  \n",
       "4     USA 1999-01-08  \n",
       "5     USA 1999-05-14  \n",
       "6     USA 1999-11-19  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# On which date was each Judi Dench movie from the 1990s released in the USA?\n",
    "\n",
    "usa = release_dates[release_dates.country == 'USA']\n",
    "\n",
    "c = cast\n",
    "c = c[c.name == 'Judi Dench']\n",
    "c = c[c.year // 10 * 10 == 1990]\n",
    "c.merge(usa).sort_values('date')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x7fad7babf710>"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAWwAAAEBCAYAAABc9Z89AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAFLFJREFUeJzt3X+s5Xld3/Hnmx0VFmSJsSIpxDGkWjXaxaChWOpQkGyN\npa3WxK1GFoJ/qYBBA9amJf2jYq0pxto/Ku6ORLQJ+HPxR6Fkv/7I2gK6gwssriW9KVvrQrALBYvs\nZt/94/O93jPjnXvvnHvP+b7O7PORTPZ8z/fO9/uc7z37me99z7kz1d1IkvI9bukASdLJuGBL0o5w\nwZakHeGCLUk7wgVbknaEC7Yk7YgjF+yqur2qHqyqe1ee+7yqekdV3V9Vb6+qp2w+U5J03B32HcAt\nVzz3WuAd3f0lwDvnbUnShtVx3zhTVeeBO7v7K+ftDwJf390PVtUXAlN3/81Nh0rSY906M+yndveD\n8+MHgaeeYY8k6SpO9YeOPW7P/d52SdqCc2v8nAer6gu7+0+r6mnARw77oKpyIZekNXR3XW3HkT+A\n88C9K9v/BnjN/Pi1wOuv8vP6uGOf4NyvO+0xroeGlI6EhpSOhIaUjm00AA19zI9/ecx+eheuxVGd\nx72t7+eBu4EvraoPV9VLgdcD31BV9wN/b97elPMbPPZJnV86YHZ+6QAyGiCj4/zSAbPzSweQ0QDs\nLR0AG74WR45EuvvWq+x64QZaJElHSP9Ox4tLB5DRABkdF5cOmF1cOoCMBsjouLh0wHDb0gGw4Wtx\n7Puw1z5wVffVBueSdA3GmxhOu1YVu7AmHbV2Rt9hV9UFG4aEjoQGyOhIaICMjoSGYVo6YOPXInrB\nliQdcCQiKZ4jkcE7bEnaEdELdsJsLKEBMjoSGiCjI6EBMjoSGoZp6QBn2JKkwRm2pHjOsAfvsCVp\nR0Qv2AmzsYQGyOhIaICMjoQGyOhIaBimpQOcYUuSBmfYkuI5wx68w5akHRG9YCfMxhIaIKMjoQEy\nOhIaIKMjoWGYlg5whi1JGpxhS4rnDHvwDluSdkT0gp0wG0togIyOhAbI6EhogIyOhIZhWjrAGbYk\naXCGLSmeM+zBO2xJ2hHRC3bCbCyhATI6EhogoyOhATI6EhqGaekAZ9iSpMEZtqR4zrAH77AlaUdE\nL9gJs7GEBsjoSGiAjI6EBsjoSGgYpqUDnGFLkgZn2JLiOcMevMOWpB0RvWAnzMYSGiCjI6EBMjoS\nGiCjI6FhmJYOcIYtSRqcYUuK5wx78A5bknZE9IKdMBtLaICMjoQGyOhIaICMjoSGYVo6wBm2JGlY\ne4ZdVT8IfAfwKHAv8NLu/ouV/c6wJZ0JZ9jDWnfYVXUe+C7gq7v7K4EbgG9bN1CSdLx1RyKfAB4G\nbqyqc8CNwP86s6pZwmwsoQEyOhIaIKMjoQEyOhIahmnpgMwZdnf/GfBjwP8E/gR4qLv/y1mGSZIu\nt9YMu6qeCdwJPA/4OPAW4K3d/eaVj3GGLelMOMMezq15zGcDd3f3x+YT/CLwXODNqx9UVReBvXnz\nIeBSd0/zvgsAbrvtttvHbQ8TcGHlMWtsD0v/ela358e3zWl7HGHdO+y/xVicvwb4NHAReFd3/+TK\nx5z6DruqLlz+Cdu+hIaUjoSGlI6EhpSObTSc7A574mCBPvQoG7/DPotrcebvEunu9wJvAt4D/OH8\n9H9cL0+SdBL+XSKS4jnDHvxOR0naEdELdsL7OxMaIKMjoQEyOhIaIKMjoWGYlg7IfB+2JGn7nGFL\niucMe/AOW5J2RPSCnTAbS2iAjI6EBsjoSGiAjI6EhmFaOsAZtiRpcIYtKZ4z7ME7bEnaEdELdsJs\nLKEBMjoSGiCjI6EBMjoSGoZp6QBn2JKkwRm2pHjOsAfvsCVpR0Qv2AmzsYQGyOhIaICMjoQGyOhI\naBimpQOcYUuSBmfYkuI5wx68w5akHRG9YCfMxhIaIKMjoQEyOhIaIKMjoWGYlg5whi1JGpxhS4rn\nDHvwDluSdkT0gp0wG0togIyOhAbI6EhogIyOhIZhWjrAGbYkaXCGLSmeM+zBO2xJ2hHRC3bCbCyh\nATI6EhogoyOhATI6EhqGaekAZ9iSpMEZtqR4zrAH77AlaUdEL9gJs7GEBsjoSGiAjI6EBsjoSGgY\npqUDnGFLkgZn2JLiOcMevMOWpB0RvWAnzMYSGiCjI6EBMjoSGiCjI6FhmJYOcIYtSRrWnmFX1VOA\nNwJfwRguvay7/+vKfmfYks6EM+zh3CmO++PAr3f3P6mqc8ATT3EsSdIx1hqJVNVNwPO6+3aA7n6k\nuz9+pmVkzMYSGiCjI6EBMjoSGiCjI6FhmJYOiJ1hfzHw0aq6o6r+oKp+qqpuPMswSdLl1pphV9Wz\ngd8Dntvd766qNwCf6O5/sfIxzrAlnQln2MO6M+wHgAe6+93z9luB1x5y4ovA3rz5EHCpu6d53wUA\nt9122+3jtocJuLDymDW2h6V/Pavb8+Pb5rQ9jnCad4n8NvDy7r6/ql4HPKG7X7Oy/9R32FV14fJP\n2PYlNKR0JDSkdCQ0pHRso+Fkd9gTBwv0oUfZ+B32WVyLTb1L5HuBN1fVZwMfAl56imNJko7h3yUi\nKZ4z7MHvdJSkHRG9YCe8vzOhATI6EhogoyOhATI6EhqGaemA2PdhS5K2zBm2pHjOsAfvsCVpR0Qv\n2AmzsYQGyOhIaICMjoQGyOhIaBimpQOcYUuSBmfYkuI5wx68w5akHRG9YCfMxhIaIKMjoQEyOhIa\nIKMjoWGYlg5whi1JGpxhS4rnDHvwDluSdkT0gp0wG0togIyOhAbI6EhogIyOhIZhWjrAGbYkaXCG\nLSmeM+zBO2xJ2hHRC3bCbCyhATI6EhogoyOhATI6EhqGaekAZ9iSpMEZtqR4zrAH77AlaUdEL9gJ\ns7GEBsjoSGiAjI6EBsjoSGgYpqUDnGFLkgZn2JLiOcMevMOWpB0RvWAnzMYSGiCjI6EBMjoSGiCj\nI6FhmJYOcIYtSRqcYUuK5wx78A5bknZE9IKdMBtLaICMjoQGyOhIaICMjoSGYVo6wBm2JGlwhi0p\nnjPswTtsSdoR0Qt2wmwsoQEyOhIaIKMjoQEyOhIahmnpAGfYkqTBGbakeM6wh1PdYVfVDVV1T1Xd\neZrjSJKOd9qRyCuBD3D63/oOlTAbS2iAjI6EBsjoSGiAjI6EhmFaOiB3hl1VTwe+EXgjEP9lhiTt\nurVn2FX1FuBfA08Gvr+7/8EV+51hSzoTzrCHte6wq+qbgI909z14dy1JW3FuzZ/3XODFVfWNwOOB\nJ1fVm7r7O1c/qKouAnvz5kPApe6e5n0XAI7Zvrm733ANH3/m2/vPLXX+le1XrXH9znp78c/H6udi\nqfPP2wmfj7+8Btf752OYgAsrj7li+xLwqiP2HzjF9b6Ls/H8/ePPx75tfn7vqJ906rf1VdXXs6GR\nSFVduPwTtn0JDSkdCQ0pHQkNKR3baDjZSGTiYIE+9CinHokc33Fcw/EdR62dZ7Vgv7q7X3zSk0rS\ntUiZYW+jY6ML9jonlaRr4YI9RH9resL7OxMaIKMjoQEyOhIaIKMjoWGYlg5g0w3RC7Yk6YAjEUnx\nHIkM3mFL0o6IXrATZmMJDZDRkdAAGR0JDZDRkdAwTEsH4AxbkgQ4w5a0A5xhD95hS9KOiF6wE2Zj\nCQ2Q0ZHQABkdCQ2Q0ZHQMExLB+AMW5IEOMOWtAOcYQ/eYUvSjohesBNmYwkNkNGR0AAZHQkNkNGR\n0DBMSwfgDFuSBDjDlrQDnGEP3mFL0o6IXrATZmMJDZDRkdAAGR0JDZDRkdAwTEsH4AxbkgQsOMMe\ns6DTux7m5F6LA14LHcYZ9nDulGc+pdP/wq8fXosDXgvpMOEjkWnpAOdzK7wWB1KuRUJHQsMwLR2A\nM2xJErD4DHv5mVQCr8UBr4UOk/K6WHqG7R22JO2I8AV7WjrA+dwKr8WBlGuR0JHQMExLB+AMW5IE\nOMOO4LU44LXQYVJeF86wJUknEr5gT0sHOJ9b4bU4kHItEjoSGoZp6QCcYUuSAGfYEbwWB7wWOkzK\n68IZtiTpRMIX7GnpAOdzK7wWB1KuRUJHQsMwLR2AM2xJEuAMO4LX4oDXQodJeV04w5YknchaC3ZV\nPaOq7qqq91fV+6rqFWcdNkybOew1cD53wGtxIOVaJHQkNAzT0gFsumHdf3HmYeD7uvtSVT0J+P2q\nekd333eGbZKkFWcyw66qXwZ+orvfufKcM+wT8loc8FroMCmvi52fYVfVeeBZwH877bEkSVd3qn+E\ndx6HvBV4ZXd/8pD9F4G9efMh4FJ3TwcfMQEXVh5zxfYl4FVH7L/sXBcA9o9/0m3grsN+bWt4/jrn\nP7ge83+uej3eANx8xP5xzHXPf8Ltm7v7DRs8/oqjrse08nGH7T+TnjP919vX7DmT12Z316Y+X909\nrX7uNvX6GyYC1osTHP/CEfsv/JXzz49vmz9gjyOsPRKpqs8C3gb8xv7/xFfsP4ORyMTqgnTIUbbw\nJc5xDafvSLkWx1n9DWGD54i4Fr4uTs7XxbU0HN9x1Nq51oJdVQX8DPCx7v6+az3p/v7HykxqFxpS\npFyLhI6EhhQp12JXZ9hfB3wH8Pyqumf+ccuax5IkncBaC3Z3/253P667b+7uZ80/fvOs4x4L76s8\nuWnpAN9ve5lp6YDZtHSAr4vLTBs9ut/pKEk74jH/d4kkdCQ0pEi5FgkdCQ0pUq7Frs6wJUlbFr5g\nT0sHkNEACR3OKldNSwfMpqUDfF1cZtro0cMXbEnSPmfYAR0JDSlSrkVCR0JDipRr4QxbknQi4Qv2\ntHQAGQ2Q0OGsctW0dMBsWjrA18Vlpo0ePXzBliTtc4Yd0JHQkCLlWiR0JDSkSLkWzrAlSScSvmBP\nSweQ0QAJHc4qV01LB8ympQN8XVxm2ujRwxdsSdI+Z9gBHQkNKVKuRUJHQkOKlGvhDFuSdCLhC/a0\ndAAZDZDQ4axy1bR0wGxaOsDXxWWmjR49fMGWJO1zhh3QkdCQIuVaJHQkNKRIuRZLz7DPnfLMuo6M\nF+PpXQ8LhA74usgRPhKZlg4gowG219FH/LjrmP2b+Wrtr5q2dJ6jTEsHzKYtncfXxclMGz16+IIt\nSdrnDDugI6EhpSOhIaUjoSGlI6FhWx2+D1uSrgPhC/a0dAAZDZDRMS0dMJuWDiCjATI6pqUDZtPS\nATjDliQBzrAjOhIaUjoSGlI6EhpSOhIattXhDFuSrgPhC/a0dAAZDZDRMS0dMJuWDiCjATI6pqUD\nZtPSATjDliQBzrAjOhIaUjoSGlI6EhpSOhIattXhDFuSrgPhC/a0dAAZDZDRMS0dMJuWDiCjATI6\npqUDZtPSATjDliQBzrAjOhIaUjoSGlI6EhpSOhIattXhDFuSrgNrL9hVdUtVfbCq/riqXnOWUQem\nzRz2mkxLB8ympQPIaICMjmnpgNm0dAAZDZDRMW306Gst2FV1A/DvgVuALwduraovO8uw4dLZH/Ka\nJTRARkdCA2R0JDRARkdCA2R0bLZh3TvsrwX+e3fvdffDwH8C/uHZZe176OwPec0SGiCjI6EBMjoS\nGiCjI6EBMjo227Dugv3XgQ+vbD8wPydJ2pB1F+wt/SNte9s5zZH2lg6Y7S0dQEYDZHTsLR0w21s6\ngIwGyOjY2+jR13pbX1U9B3hdd98yb/8g8Gh3/8jKx2zrX96UpOvK1d7Wt+6CfQ74I+AFwJ8A7wJu\n7e77ThMpSbq6c+v8pO5+pKq+B/jPwA3AT7tYS9Jmbew7HSVJZ8vvdFxRVV9WVS+oqidd8fwtW+74\nO1X15fPjC1X1/VX1gm02JKqq51XVq6vqRVs853Oq6qb58Y1V9a+q6m1V9SP7z2+p4xVV9Yxtne8q\nDZ9TVS+pqhfO299eVT9ZVd9dVZ+1ZNtjRfwddlW9tLvv2MJ5XgF8N3Af8Czgld39y/O+e7r7WZtu\nmM/1w8DzGaOmu4C/C/wa8A3And39o9voOKTrTd39nVs+57u6+2vnx9/F+Pz8EvAi4G3d/cNbaPgA\n8FXzGPCngE8BbwVeOD//zZtumDs+Dvw58CHg54C3dPdHt3HulYafY7wub2S84fhJwC8yrgXd/ZJt\n9jwmdXf0D+DDWzrP+4AnzY/PA+8BXjVv37PFX+8HGH+2cCPwf4Gb5uefAPzhlhruBH51/u/+j0/t\nP7/Fa3HPyuP3AH9tfvxE4H1barhv5fEfXLHvvdu8FoyviF8E3A58FPhN4CXA526p4d75v+eAjwDn\n5u3a37f0D+A3tnSem4DXAz8L/NMr9v2HTZ13rT90PGtVde8Ru79gWxnd/UmA7t6rqgvAL1TVFzFe\nkNvyme5+BHikqj7U3R+fm/5fVT26pYanM37jeCPwKOPX/2zg327p/PtuqKrPm89/Q893lN39qap6\nZEsN76+ql3X37cB7q+pruvvdVfUlwGe21ABAdz8KvB14e1V9NvD3gVuBHwM+fwsJj6uqz2HcTDyB\nsWh9DHg8WxyvVtVXX20X46vjbbgDuB/4BeBlVfUtwLd396eBv72pk0Ys2IxF+Rbg/xyy7+4tNXyk\nqm7u7ksA3f3Jqvom4KeBr9pSA8BfVNWN3f3nwF++MKvqKYzFcxueDbwS+CHgB7r7nqr6dHf/1pbO\nv+/JwO/Pj7uqntbd/7uqPneLDS8Hfryq/jnjrvbuqnqA8Z2+L99ix2W6+zPArwC/UlVP3NJpf5Yx\nMnwYeDXwO1V1N/Ac4Ge21ADwbuC3r7JvW3+u8Mw+GIf9UlX9EPDOqtrAX9FxIGKGXVW3A3d09+8c\nsu/nu/vWLTQ8A3i4u//0iucL+Lru/t1NN8zne/z8u/SVz38+8LTuPuqrkbNueTrw7xhf/r64uxf9\nQ699VXUj8NTu/h9bPOdNwBczbnIeuPJ1soXzf2l3/9E2z3mVjvPAJ7r7z6rqmYzf3D/Y3e/dYsP7\ngX/c3fcfsu/D23idVtV9wFfMX/XsP3cb8AOM0eoXbeS8CQu2ss1faTy3u//Z0i1SVX0rY2b+wUP2\n/aOe3yyw4YYfBd7e3e+44vlbgJ/o7r+xkfO6YEu6Xqz8ecN12eCCLem6sa2RyFINKX/oKEkncsy7\nyp56PTe4YEvaNQnvKlukwQVb0q75NcY7Me65ckdVbeutp4s0OMOWpB3hX/4kSTvCBVuSdoQLtiTt\nCBdsSdoRLtiStCP+Pyx8Seu0sW9cAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x7fad7c616cc0>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# In which months do films with Judi Dench tend to be released in the USA?\n",
    "\n",
    "c = cast\n",
    "c = c[c.name == 'Judi Dench']\n",
    "m = c.merge(usa).sort_values('date')\n",
    "m.date.dt.month.value_counts().sort_index().plot(kind='bar')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x7fad7ca2da20>"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAWYAAAEBCAYAAABL1w/0AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAGXlJREFUeJzt3X+MbGddx/H3l1764xYowQYoFr21EeRnf1BIRcCtFNIi\nFERNaDBwS8ofAgIKhFaMgn8IBAkQhRiB9oIWjFQKlh9SwD4FUgNU7i2FFtCGFRAoDfUWpBZa+/WP\nc8aZWXbnzO7MOc9n735eSXP37Eyf874zs8+d/e7sbmQmZmam4261A8zMbJo3ZjMzMd6YzczEeGM2\nMxPjjdnMTIw3ZjMzMZ0bc0S8JCKui4gvRcRLhogyM9vJZm7MEfFw4Hzg0cBJwFMj4sQhwszMdqqu\nZ8y/BHw2M2/PzP8FrgKe2X+WmdnO1bUxfwl4fETcJyJ2A78OHN9/lpnZzrVr1oWZ+ZWIeD1wBfAj\nYD9w1xBhZmY7VWzmZ2VExJ8B38jMv5p4n3/YhpnZFmRmbHTBzP+A+7Z//hxwA3CvNZdn1xpznOPV\ni66xjP8UOhQaVDoUGlQ6FBpUOoZoABKy478/6bic7DrHRpfNHGW0Lo2InwHuAF6QmT/Y1D8J89nT\nw5pbsad2ABoNoNGxp3ZAa0/tADQaQKNjT+2AxmpvK3duzJn5hN7ObmZmP0XlO//21Q5o7asdgEYD\naHTsqx3Q2lc7AI0G0OjYVzugsbe3lTf1xb91F4jI3GiAbWa2DTUvalj0dQ3BrL1x1t4p8Yw5IlZq\nN4BGh0IDaHQoNIBGh0IDaHQoNDRKbytLbMxmZjbmUYaZ2RoeZZiZ2RSJjVllZqTQodAAGh0KDaDR\nodAAGh0KDY3S28oSG7OZmY15xmxmtoZnzGZmNkViY1aZGSl0KDSARodCA2h0KDSARodCQ6P0trLE\nxmxmZmOeMZuZreEZs5mZTZHYmFVmRgodCg2g0aHQABodCg2g0aHQ0Ci9rSyxMZuZ2VjnjDkiLgR+\nh+aXsF4HnJeZP5643DNmMzukSM+YI2IP8Hzg1Mx8BHAY8Kyth5qZWZeuUcYPaH7X3+6I2AXsBv5z\n2REqMyOFDoUG0OhQaACNDoUG0OhQaGiU3laeuTFn5i3AG4FvAN8GDmbmJ3qrMTOz2TPmiDgRuBx4\nPHAr8D7g0sy8ZOI6njGb2SGl9oy567dknwZcnZnfbxd6P/BY4JLJK0XEPsa/y/sgcCAzS3vZCoCP\nfexjH2+X47HS/rmypePJ9du397ZXWGWGrmfMJ9Fswo8Gbqf57bSfy8y3Tlxn4WfMEbEyumFqUuhQ\naFDpUGhQ6VBoUOkYomG+Z8yF8Ya87ir9vCojM68F3g1cA3yxffdfz/p/zMxsMf5ZGWZma9SeMfs7\n/8zMxEhszCqvS1ToUGgAjQ6FBtDoUGgAjQ6FhkbpbWWJjdnMzMY8YzYzW8MzZjMzmyKxMavMjBQ6\nFBpAo0OhATQ6FBpAo0OhoVF6W1liYzYzszHPmM3M1vCM2czMpkhszCozI4UOhQbQ6FBoAI0OhQbQ\n6FBoaJTeVpbYmM3MbMwzZjOzNTxjNjOzKRIbs8rMSKFDoQE0OhQaQKNDoQE0OhQaGqW3lSU2ZjMz\nG/OM2cxsDfkZc0Q8OCL2T/x3a0S8eJFcMzPbWOfGnJlfzcxTMvMU4FHAbcBly4xQmRkpdCg0gEaH\nQgNodCg0gEaHQkOj9LbyZmfMZwI3ZuY3+4gxM7NNzpgj4iLgmsx828T7PGM2s0NK7RnzrrlPEXE4\n8DTgletctg9YbQ8PAgdGv1589GmHj3289rh58C/FGQp/Hx8fOsdjpf1zZUvHax7vK8De9gqrzDD3\nM+aIeDrwu5l51pr3L/yMOSJWRjdMTQodCg1DdXQ/KymMH/AbrjLzWckyKNwnCg0qHRqPTeh+fA7z\nnX/nAu/dxPXNzGwL5nrGHBFHA/8BnJCZP1xzmWfMtiVDzPHMtmJbzJgz80fAsVusMzOzTZD4lmyV\n1yUqdCg0gEpHqR0AaNwWCg2g0aHQ0Ci9rSyxMZuZ2Zh/VoZV4xmzqao9Y/YzZjMzMRIbs8rMSKFD\noQFUOkrtAEDjtlBoAI0OhYZG6W1liY3ZzMzGPGO2ajxjNlWeMZuZ2RSJjVllZqTQodAAKh2ldgCg\ncVsoNIBGh0JDo/S2ssTGbGZmY54xWzWeMZsqz5jNzGyKxMasMjNS6FBoAJWOUjsA0LgtFBpAo0Oh\noVF6W1liYzYzszHPmK0az5hNlWfMZmY2pXNjjoh7R8SlEXFDRFwfEacvO0JlZqTQodAAKh2ldgCg\ncVsoNIBGh0JDo/S28jy/weQtwEcy87ciYhdwdG81ZmY2e8YcEccA+zPzF2ZcxzNm2xLPmE2V+oz5\nBODmiLg4Ir4QEW+PiN2LpJqZ2Wxdo4xdwKnAizLz8xHxZuAC4I8nrxQR+4DV9vAgcCAzS3vZCkDH\n8cmZ+eZNXL+X48nZVY3zt8cv3cLtt/TjtbdJX+cbz+lGp508Hr290eWNiFhZoGfRp0W068UWzz/X\n8eh9NT8+2mOFx2fv+8VYaf9cWee4TFxvvcvX3V/2tldYZYauUcb9gX/JzBPa48cBF2TmUyeus/Ao\nY/IDqyaFDoWGoTq6P10sTG7AG6yy0Chjvk9Zuzr6H6fspMeFQsMQj4tZe2fn65gj4lPA+Zn5tYh4\nNXBUZr5ynsXNZlGYMSs0mJ7aM+Z5XpXxe8AlEXE4cCNw3tYizcxsHp2vY87MazPz0Zl5UmY+MzNv\nXXaEyusSFToUGkClo9QOaJXaASL3h0aHQkOj9Layv/PPzEyMf1aGVaMw31VoMD21Z8x+xmxmJkZi\nY1aZGSl0KDSASkepHdAqtQNE7g+NDoWGRultZYmN2czMxjxjtmoU5rsKDabHM2YzM5sisTGrzIwU\nOhQaQKWj1A5oldoBIveHRodCQ6P0trLExmxmZmOeMVs1CvNdhQbT4xmzmZlNkdiYVWZGCh0KDaDS\nUWoHtErtAJH7Q6NDoaFReltZYmM2M7Mxz5itGoX5rkKD6fGM2czMpsy1MUfEakR8MSL2R8Tnlh2h\nMjNS6FBoAJWOUjugVWoHiNwfGh0KDY3S28rz/AYTaJ7Tr2TmLb2VmJkZMOeMOSK+DpyWmd9f5zLP\nmG1LFOa7Cg2mZ7vMmBP4RERcExHP30qimZnNZ96N+Vcy8xTgbOCFEfH4ZUaozIwUOhQaQKWj1A5o\nldoBIveHRodCQ6P0tvJcM+bM/E77580RcRnwGODTo8sjYh+w2h4eBA5kZmkvW2n/31nHJ9P+Lee8\n/iF7DJwcEX2f70rmEDH7s/PMjMX/vqO/9gpbO27WXOD2btecdb4Dc/SMWzZz/nmP+15f7PFZfb8Y\nG/21V7Z0PLl++/be9gqrzNA5Y46I3cBhmfnDiDgauAJ4TWZe0V7uGfM2ozJXVehQaDA9tWfM8zxj\nvh9wWfvsaRdwyWhTNjOz5eucMWfm1zPz5Pa/h2fma5cdoTIzUuhQaGiU2gFoNIBCh8rjQqFDoaFR\nelvZ3/lnZibGPytjB1KZqyp0KDSYntozZj9jNjMTI7Exq8yMFDoUGhqldgAaDaDQofK4UOhQaGiU\n3laW2JjNzGzMM+YdSGWuqtCh0GB6PGM2M7MpEhuzysxIoUOhoVFqB6DRAAodKo8LhQ6FhkbpbWWJ\njdnMzMY8Y96BVOaqCh0KDabHM2YzM5sisTGrzIwUOhQaGqV2ABoNoNCh8rhQ6FBoaJTeVpbYmM3M\nbMwz5h1IZa6q0KHQYHo8YzYzsykSG7PKzEihQ6GhUWoHoNEACh0qjwuFDoWGRult5bk25og4LCL2\nR8TlvZWYmRkw54w5Iv4AeBRwz8w8Z81lnjFvMypzVYUOhQbTIz9jjojjgacA7wD84DMz69k8o4w3\nAa8A7uorQmVmpNCh0NAotQPQaACFDpXHhUKHQkOj9LbyzI05Ip4KfC8z9+Nny2Zmg9jVcfljgXMi\n4inAkcC9IuLdmfmcyStFxD5gtT08CBzIzNJetgLQdTyx1lzX7+M4M0vN80/eBn2fb2x02pVNHo9b\nF/v7zjrfyhw9i91e4zU3Wn/ianNcXvvxc6g8PmvvF2Ojv/bKOscrHZdPr9++vbe9wiozzP0NJhHx\nq8DLM/Npa97vL/5tMypf8FLoUGgwPfJf/Ftj0dJ1qcyMFDoUGhqldgAaDaDQofK4UOhQaGiU3lbu\nGmX8v8y8CriqtxIzMwP8szJ2JJVP3xU6FBpMz3YbZZiZWc8kNmaVmZFCh0JDo9QOQKMBFDpUHhcK\nHQoNjdLbyhIbs5mZjXnGvAOpzFUVOhQaTI9nzGZmNkViY1aZGSl0KDQ0Su0ANBpAoUPlcaHQodDQ\nKL2tLLExm5nZmGfMO5DKXFWhQ6HB9HjGbGZmUyQ2ZpWZkUKHQkOj1A5AowEUOlQeFwodCg2N0tvK\nEhuzmZmNeca8A6nMVRU6FBpMj2fMZmY2RWJjVpkZKXQoNDRK7QA0GkChQ+VxodCh0NAova0ssTGb\nmdlY54w5Io6k+QH5RwCHAx/MzAsnLveMeZtRmasqdCg0mJ7aM+bO32CSmbdHxBmZeVtE7AI+ExGP\ny8zPLFBsZmYbmGuUkZm3tW8eDhwG3LLMCJWZkUKHQkOj1A5AowEUOlQeFwodCg2N0tvKc23MEXG3\niDgA3ARcmZnX91ZkZrbDbep1zBFxDPAx4ILMLO37PGPeZlTmqgodCg2mR37GPCkzb42IDwOnMfE8\nPiL2Aavt4UHgwMTGvdL+vz5mdIcvbnSHbrVnrLR/rmzyuLHo7bH184+OmzW3fv7Rmls9/8QyWzj/\nxP1xJQvKzBB4fC/jeCm3xSI9Y6X9c2VLx5Prt2/vba+wOqt/nldlHAvcmZkHI+IommfMr8nMT7aX\nL/yMefIDq6YhOrr/JS5MbjobrDLAs8SujiGeMXc1LN5x6NwWwzxr3x4fI0N9NrdYx6LPmI8D3hUR\nd6OZSf/NaFM2M7Pl88/KGJjCTFOhQaVDoWE5HYfOnFvhtqg9Y/Z3/pmZiZHYmFVel6jRUWoHtErt\nADQaQKOj1A4A/DEyrfS2ssTGbGZmY54xD0xhpqnQoNKh0LCcDs+YJ1YQuD+6OzxjNjPbRiQ2Zo25\nlUpHqR3QKrUD0GgAjY5SOwDwx8i00tvKEhuzmZmNecY8MIWZpkKDSodCw3I6PGOeWEHg/uju8IzZ\nzGwbkdiYNeZWKh2ldkCr1A5AowE0OkrtAMAfI9NKbytLbMxmZjbmGfPAFGaaCg0qHQoNy+nwjHli\nBYH7o7vDM2Yzs21EYmPWmFupdJTaAa1SOwCNBtDoKLUDAH+MTCu9rSyxMZuZ2ZhnzANTmGkqNKh0\nKDQsp8Mz5okVBO6P7o6FZswR8cCIuDIivhwRX4qIFy+SamZms80zyrgD+P3MfBhwOvDCiHjIMiM0\n5lYqHaV2QKvUDkCjATQ6Su0AwB8j00pvK3duzJn53cw80L7938ANwAN6KzIz2+E2NWOOiD3AVcDD\n2k3aM+ZNUphpKjSodCg0LKfDM+aJFQTuj+6ORX9L9miRewCXAi8ZbcoTl+0DVtvDg8CB0a84bz/1\nuXLe88ySmTH6VGrN+tvmuFEY/9rz0bs3e9zYas90y/DnH98eWz3/6LhZ0/fHYufPzNJsRktxxqIf\nL2Ol/XNlk8eNeudf+anzt2/vba+wygxzPWOOiLsDHwI+mplvXnNZ5zPm7n99CpMfaBus0vszgskP\n8B7PUf22mO/ZQFfHEM9KuhoW7zh0bouhniUqdCg0LN6x6KsyAngncP3aTdnMzJav8xlzRDwO+BTw\nRcb/hFyYmf/UXr6EZ8xzpR4SMzSF20KhQaVDoWE5HQoNKh0KDd0dC82YM/Mz+DsEzcwGI7LhltoB\ngF+jOa3UDkCjATQ6Su2AVqkdgEYD+GdlmJntIIP8rAyV2ZUChdtCoUGlQ6FhOR0KDSodCg3dHf55\nzGZm24jIxlxqBwCeMU8rtQPQaACNjlI7oFVqB6DRAJ4xm5ntIJ4xD0zhtlBoUOlQaFhOh0KDSodC\nQ3eHZ8xmZtuIyMZcagcAnjFPK7UD0GgAjY5SO6BVageg0QCeMZuZ7SCeMQ9M4bZQaFDpUGhYTodC\ng0qHQkN3h2fMZmbbiMjGXGoHAJ4xTyu1A9BoAI2OUjugVWoHoNEAnjGbme0gnjEPTOG2UGhQ6VBo\nWE6HQoNKh0JDd4dnzGZm28g8v1rqooi4KSKu6y+j9Lf0JnjGPKnUDkCjATQ6Su2AVqkdgEYD1J4x\nXwyc1VuBmZlNmfe3ZO8BLs/MR6xzmWfMm6BwWyg0qHQoNCynQ6FBpUOhobvDM2Yzs22k85exziMi\n9gGr7eFB4EBmlvaylelrl/bPlYnjA8BLZ1w+da4VgLXrdx0DV871l+l2xlbOPzpuFH767zc6fjNw\n8ozLJ5bZwvnnuz+YeF8/5x/fHhutP3nujS4fN/R3fxQGenzOsf5Kb+ef7/6A7sfnYveH0H7Rsf4K\n8zw+J9dv397bXmGVGURGGYXJO3aDVQb4lLWrY4hPkboaFu/wbbGZhnk6FG6LoT59V+hQaFi8Y9be\nKbIxz8OzxGV1KDSodCg0LKdDoUGlQ6Ghu2OhGXNEvBe4GnhQRHwzIs7beqiZmXXp3Jgz89zMfEBm\nHpGZD8zMi5efUZa/5JaU2gFoNIBGR6kd0Cq1A9BoAI2OUjugVXpb2a/KMDMTs2N+VoZCg0qHQoNK\nh0LDcjoUGlQ6FBq6O/w6ZjOzbURkYy61A1qldgAaDaDRUWoHtErtADQaQKOj1A5old5WFtmYzcxs\nxDPmARtUOhQaVDoUGpbTodCg0qHQ0N3hGbOZ2TYisjGX2gGtUjsAjQbQ6Ci1A1qldgAaDaDRUWoH\ntEpvK4tszGZmNuIZ84ANKh0KDSodCg3L6VBoUOlQaOju8IzZzGwbEdmYS+2AVqkdgEYDaHSU2gGt\nUjsAjQbQ6Ci1A1qlt5VFNmYzMxvxjHnABpUOhQaVDoWG5XQoNKh0KDR0d3jGbGa2jczzg/LPioiv\nRMS/RcQr+8ko/Sy7aaV2ABoNoNFRage0Su0ANBpAo6PUDmiV3laeuTFHxGHAXwJnAQ8Fzo2Ihyw/\n48Dyl9wShQ6FBtDoUGgAjQ6FBtDoUGiAPju6njE/Bvj3zFzNzDuAvwOevvyMg8tfcksUOhQaQKND\noQE0OhQaQKNDoQH67OjamH8W+ObE8bfa95mZWU+6NuZFvyw5p9VhTtNptXYAGg2g0bFaO6C1WjsA\njQbQ6FitHdBa7W3lmS+Xi4jTgVdn5lnt8YXAXZn5+onrDLR5m5kdWjZ6uVzXxrwL+CrwRODbwOeA\nczPzhj4izcwMds26MDPvjIgXAR8DDgPe6U3ZzKxfC3/nn5mZLdeO/c6/iHhcRDy0fXslIl4eEU+s\n3VVbRDw+Il4WEU8e8JynR8Qx7du7I+JPI+JDEfH60fsH6nhxRDxwqPNt0HBERDw3Is5sj58dEW+N\niBdGxN1rttlwZJ4xR8R5mXnxQOd6LXAGzXjmSuAJwIeBJwGXZ+YbhuhYp+vdmfmcgc/5ucx8TPv2\n84EXApcBTwY+lJmvHaDheuCR7ejs7cCPgEuBM9v3P7PvhrbjVuA24EbgPcD7MvPmIc490fAemsfl\nbpoXyt4DeD/NbUFmPnfIHqtDaWP+ZmYO8mxltBEAhwM3Acdn5q0RcRTw2cx85AANl9O8HHHyq7K/\nBvwzkJl5Tt8Nbcf+zDylffsa4OzMvDkijqa5LR4+QMMNmfmQ9u0vZOapE5ddm5kn9d3Qnms/8Cia\nTfBZwNOAfwXeC7w/M384QMN1mfmI9gvv3wYe0P6DFcAXM/MRfTe0HfcGLgCeAdyP5rH6PeADwOsy\ns+p3eUTERzPz7IHOdQxwIXA88JHMfM/EZW/LzBcs+5wzv/i3bBFx3YyL7ztYCPwkM+8E7oyIGzPz\nVoDM/J+IuGughuOB64F3AHfRbNCnAX8+0PlHDouI+7TnP2z0DDEzfxQRdw7U8OWIeF5mXgRcGxGP\nzszPR8SDgJ8M1ABAZt4FXAFcERGHA2cD5wJvBI4dIOFuEXEEzTPmo4BjgO8DRzLs6PHvgU8CK8BN\nmZkRcRzw3Pay3kddEXHqRhcBp/R9/gkXA18D/gF4XkT8JvDszLwd+OU+Tjjoxkyz+Z4F/Nc6l109\nYMePI2J3Zt4GTD47uzfNJjmE04CXAK8CXpGZ+yPi9sy8aqDzj9yL5lkhQEbEcZn5nYi454AN5wNv\niYg/Am4Gro6Ib9F81+n5A3ZMycyfAB8EPth+BjGEvwVuAO4AXgZ8OiKuBk4H3jVQA8Ceye9XAMjM\n7wCvi4jnDdTweeBTG1w22NcegBMnxmmXRcSrgE9GRA8/nqIx6CgjIi4CLs7MT69z2Xsz89yBOo5s\n/7Vb+/5jgeMyc9Yz+2W3HA+8iebTxHOGGud0iYjdwP0y8+sDnvMY4ASaJwzfyszvDnXu9vwPzsyv\nDnnODTr2AD/IzFsi4kSaf8S/kpnXDtjwceDjwLsy86b2ffenecb8pMw8c4CGLwO/kZlfW+eyIUef\nNwAPaz+bGr1vL/AK4B6Z+fNLP6fKjHmni4inAo/NzD+s3WLWjrcuAM6hmTFD8/WYf6SZMd8yQMNv\nA9dl5lfWuewZmfmBvhvac70BuCIzP77m/WcBf5GZv7j0c3pjNrPNGPIVVDMaRl+TqKqvDm/MZrYp\nQ44RlBv67Bj6i39mtg10vILqfjMuO6QaanV4Yzaz9Si8gkqhoUqHN2YzW8+HaV5xsH/tBREx1Es6\nFRqqdHjGbGYmZsf+ECMzM1XemM3MxHhjNjMT443ZzEyMN2YzMzH/B8XbDA5jWzyPAAAAAElFTkSu\nQmCC\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x7fad7c5a3f28>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# In which months do films with Tom Cruise tend to be released in the USA?\n",
    "\n",
    "c = cast\n",
    "c = c[c.name == 'Tom Cruise']\n",
    "m = c.merge(usa).sort_values('date')\n",
    "m.date.dt.month.value_counts().sort_index().plot(kind='bar')"
   ]
  },
  {
   "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
}