Exercises-5_Solution.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('D:/Data Visualization Project/style-table.css').read() + open('D:/Data Visualization Project/style-notebook.css').read()\n",
    "HTML('<style>{}</style>'.format(css))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cast = pd.read_csv('D:/Data Visualization Project/cast.csv')\n",
    "cast.head()"
   ]
  },
  {
   "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",
       "      <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>#BKKY</td>\n",
       "      <td>2016</td>\n",
       "      <td>Cambodia</td>\n",
       "      <td>2017-10-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</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>3</th>\n",
       "      <td>#Captured</td>\n",
       "      <td>2017</td>\n",
       "      <td>USA</td>\n",
       "      <td>2017-09-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>#Ewankosau saranghaeyo</td>\n",
       "      <td>2015</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>2015-01-21</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                   #BKKY  2016     Cambodia 2017-10-12\n",
       "2                 #Beings  2015      Romania 2015-01-29\n",
       "3               #Captured  2017          USA 2017-09-05\n",
       "4  #Ewankosau saranghaeyo  2015  Philippines 2015-01-21"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "release_dates = pd.read_csv(\n",
    "    'D:/Data Visualization Project/release_dates.csv',\n",
    "    parse_dates=['date'],\n",
    "    infer_datetime_format=True,\n",
    ")\n",
    "release_dates.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "### Make a bar plot of the months in which movies with \"Christmas\" in their title tend to be released in the USA."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x76798c8>"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXAAAAD9CAYAAAClQCyNAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAANZklEQVR4nO3dbYxlB13H8e+PtspDeWjtdF0o7RpTK6Cw1UmtNjGVUi0P0hKtUCIZtWZfAFITErLIG31XE2P0hSZueHCjtFqesisIdllcDIqlW1qgpK2LpBbs0h1aiuALsOXvi3u2nc7Odu7O3Dt3/t3vJ2nuPefch393dr979txz701VIUnq52mzHkCStDYGXJKaMuCS1JQBl6SmDLgkNWXAJampU8e5UZJ7ge8AjwKPVNV8kjOBvwe2AfcCv1FV35rOmJKk5U5kD/yXqmp7Vc0PyzuB/VV1PrB/WJYkbZCM80aeYQ98vqq+uWTdPcClVXU4yVbgQFVd8GSPc9ZZZ9W2bdvWN7EknWRuu+22b1bV3PL1Yx1CAQq4OUkBf1VVu4AtVXUYYIj42SvdMckOYAfAueeey8GDB9f0PyBJJ6sk/7XS+nEDfklV3T9Eel+Su8d94iH2uwDm5+d9374kTchYx8Cr6v7h8gjwEeAi4IHh0AnD5ZFpDSlJOtaqAU/yrCTPPnod+GXgTmAvsDDcbAHYM60hJUnHGucQyhbgI0mO3v6GqvpEkluBm5JcC9wHXD29MSVJy60a8Kr6KvCyFdY/CFw2jaEkSavznZiS1JQBl6SmDLgkNTXueeCSdNLatvNjE3/Me69/9bofwz1wSWrKgEtSUwZckpoy4JLUlAGXpKYMuCQ1ZcAlqSkDLklNGXBJasqAS1JTBlySmjLgktSUAZekpgy4JDVlwCWpKQMuSU35hQ6SZmrSX5YwiS9K6MI9cElqyoBLUlMGXJKaMuCS1JQBl6SmDLgkNWXAJakpAy5JTRlwSWrKgEtSUwZckpoy4JLUlAGXpKbGDniSU5LcnuSjw/KZSfYlOTRcnjG9MSVJy53IHvh1wF1LlncC+6vqfGD/sCxJ2iBjBTzJOcCrgXcvWX0lsHu4vhu4arKjSZKezLh74H8GvAP4wZJ1W6rqMMBwefZKd0yyI8nBJAcXFxfXNawk6XGrBjzJa4AjVXXbWp6gqnZV1XxVzc/Nza3lISRJKxjnK9UuAV6b5FXA04HnJPlb4IEkW6vqcJKtwJFpDipJeqJV98Cr6p1VdU5VbQPeAHyqqn4T2AssDDdbAPZMbUpJ0jHWcx749cDlSQ4Blw/LkqQNckLfSl9VB4ADw/UHgcsmP5IkaRy+E1OSmjLgktSUAZekpgy4JDVlwCWpKQMuSU0ZcElqyoBLUlMGXJKaMuCS1JQBl6SmDLgkNWXAJakpAy5JTRlwSWrKgEtSUwZckpoy4JLUlAGXpKYMuCQ1ZcAlqSkDLklNGXBJasqAS1JTBlySmjLgktSUAZekpgy4JDVlwCWpKQMuSU0ZcElqyoBLUlMGXJKaMuCS1NSqAU/y9CSfS/KFJF9O8kfD+jOT7EtyaLg8Y/rjSpKOGmcP/HvAy6vqZcB24IokFwM7gf1VdT6wf1iWJG2QVQNeI98dFk8b/ivgSmD3sH43cNVUJpQkrWisY+BJTklyB3AE2FdVtwBbquowwHB59vTGlCQtN1bAq+rRqtoOnANclOSnxn2CJDuSHExycHFxca1zSpKWOaGzUKrqYeAAcAXwQJKtAMPlkePcZ1dVzVfV/Nzc3DrHlSQdNc5ZKHNJnjdcfwbwCuBuYC+wMNxsAdgzrSElScc6dYzbbAV2JzmFUfBvqqqPJvkscFOSa4H7gKunOKckaZlVA15VXwQuXGH9g8Bl0xhKkrQ634kpSU0ZcElqyoBLUlMGXJKaMuCS1JQBl6SmDLgkNWXAJakpAy5JTRlwSWrKgEtSUwZckpoy4JLUlAGXpKYMuCQ1ZcAlqSkDLklNGXBJasqAS1JTBlySmjLgktSUAZekpgy4JDVlwCWpKQMuSU0ZcElqyoBLUlMGXJKaMuCS1JQBl6SmDLgkNWXAJakpAy5JTRlwSWrKgEtSU6sGPMkLk/xzkruSfDnJdcP6M5PsS3JouDxj+uNKko4aZw/8EeDtVfUi4GLgLUleDOwE9lfV+cD+YVmStEFWDXhVHa6qzw/XvwPcBbwAuBLYPdxsN3DVtIaUJB3rhI6BJ9kGXAjcAmypqsMwijxw9nHusyPJwSQHFxcX1zetJOkxYwc8yenAh4Dfr6r/Gfd+VbWrquaran5ubm4tM0qSVjBWwJOcxije76+qDw+rH0iyddi+FTgynRElSSsZ5yyUAO8B7qqqP12yaS+wMFxfAPZMfjxJ0vGcOsZtLgHeBHwpyR3Duj8ArgduSnItcB9w9XRGlCStZNWAV9VngBxn82WTHUeSNC7fiSlJTRlwSWrKgEtSUwZckpoy4JLUlAGXpKYMuCQ1ZcAlqSkDLklNGXBJasqAS1JTBlySmjLgktSUAZekpgy4JDVlwCWpKQMuSU0ZcElqyoBLUlMGXJKaMuCS1JQBl6SmDLgkNWXAJakpAy5JTRlwSWrKgEtSUwZckpoy4JLUlAGXpKYMuCQ1ZcAlqSkDLklNnTrrASRNx7adH5v4Y957/asn/phau1X3wJO8N8mRJHcuWXdmkn1JDg2XZ0x3TEnScuMcQvlr4Ipl63YC+6vqfGD/sCxJ2kCrBryq/gV4aNnqK4Hdw/XdwFUTnkuStIq1voi5paoOAwyXZx/vhkl2JDmY5ODi4uIan06StNzUz0Kpql1VNV9V83Nzc9N+Okk6aaw14A8k2QowXB6Z3EiSpHGsNeB7gYXh+gKwZzLjSJLGNc5phDcCnwUuSPL1JNcC1wOXJzkEXD4sS5I20Kpv5Kmqa46z6bIJzyJJOgG+lV6SmjLgktSUAZekpgy4JDVlwCWpKQMuSU0ZcElqyoBLUlMGXJKaMuCS1JQBl6SmNuWXGvtlrJK0OvfAJakpAy5JTRlwSWrKgEtSUwZckpoy4JLUlAGXpKYMuCQ1ZcAlqSkDLklNGXBJasqAS1JTm/LDrKTNzA9b02bhHrgkNWXAJakpAy5JTXkMfB26HAvtMqekE+MeuCQ1ZcAlqSkDLklNGXBJasoXMbVp+GKrdGLWtQee5Iok9yT5SpKdkxpKkrS6NQc8ySnAXwCvBF4MXJPkxZMaTJL05NazB34R8JWq+mpVfR/4O+DKyYwlSVpNqmptd0x+Hbiiqn53WH4T8HNV9dZlt9sB7BgWLwDuWfu4KzoL+OaEH3ManHNyOswIzjlpJ/Oc51XV3PKV63kRMyusO+Zvg6raBexax/M8+RDJwaqan9bjT4pzTk6HGcE5J805j7WeQyhfB164ZPkc4P71jSNJGtd6An4rcH6SH0vyQ8AbgL2TGUuStJo1H0KpqkeSvBX4J+AU4L1V9eWJTTa+qR2emTDnnJwOM4JzTppzLrPmFzElSbPlW+klqSkDLklNGXBJasoPs5qCJD8JvAC4paq+u2T9FVX1idlN9rgkbwM+UlVfm/UsT2bJGU73V9Unk7wR+AXgLmBXVf3fTAdcIsmPA69jdHrtI8Ah4Maq+vZMB9NT1lPmRcwkv11V79sEc7wNeAujwGwHrquqPcO2z1fVz8xyvqOSfBv4X+A/gRuBD1TV4mynOlaS9zPa0Xgm8DBwOvBh4DJGv38XZjjeY4af+68CnwZeBdwBfItR0N9cVQdmN52eqp5KAb+vqs7dBHN8Cfj5qvpukm3AB4G/qao/T3J7VV040wEHSW4HfhZ4BfB64LXAbYxi/uGq+s4Mx3tMki9W1UuTnAr8N/D8qno0SYAvVNVLZzwi8NjPffsw2zOBf6yqS5OcC+zZLD93PbW0OoSS5IvH2wRs2chZnsQpRw+bVNW9SS4FPpjkPFb++IFZqar6AXAzcHOS0xh9suQ1wJ8Ax3zuwow8bTiM8ixGe+HPBR4Cfhg4bZaDreBU4FFGsz0boKruG35tN4UkzwXeCVzF4z/jI8Ae4PqqenhWs40rycer6pWzngMgyXMY/XqeA3y8qm5Ysu0vq+rN03z+VgFnFOlfYfRP06UC/NvGj7OibyTZXlV3AAx74q8B3gv89GxHe4In/GUyHEveC+xN8ozZjLSi9wB3M3qz2LuADyT5KnAxo0/A3CzeDdya5N+BXwT+GCDJHKO/cDaLm4BPAZdW1TcAkvwosAB8ALh8hrM9JsnxDjWG0aHJzeJ9jF7r+BDwO0l+DXhjVX2P0e/RqWp1CCXJe4D3VdVnVth2Q1W9cQZjLZ/jHOCRo384lm27pKr+dQZjHSPJT1TVf8x6jnEkeT5AVd2f5HmMDvvcV1Wfm+1kT5TkJcCLgDur6u5Zz7OSJPdU1QUnum2jJXmU0esJK/2r9eKq2hQ7GUnuqKrtS5bfxeg1kNcC+6b9mlergEtanyQ3A58EdlfVA8O6LcBvAZdX1StmON5jktwJvK6qDq2w7WtV9cIV7rbhktwFvGQ4HHl03QLwDuD0qjpvms/veeDSyeX1wI8An07yUJKHgAPAmcDVsxxsmT/k+H36vQ2cYzX/ALx86Yqq2g28Hfj+tJ/cPXBJwOY5FXc1zrnkOQy4JNg8p+Kuxjkf1+0sFEnr0ORUXOcckwGXTi4dTsUF5xyLAZdOLh9ldHbEHcs3JDmw8eMcl3OOwWPgktSUpxFKUlMGXJKaMuCS1JQBl6Sm/h8KG5Qd7Cgd6QAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "reld = release_dates\n",
    "reld = reld[reld.title.str.contains('Christmas')]\n",
    "reld = reld[reld.country == 'USA']\n",
    "reld.date.dt.month.value_counts().sort_index().plot(kind='bar')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "### Make a bar plot of the months in which movies whose titles start with \"The Hobbit\" are released in the USA."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x9dec7a8>"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXQAAAD7CAYAAAB68m/qAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAL5ElEQVR4nO3cUcjd9X3H8fdHk3YDO4TlYUqSx5QtN3WwKQ9R6Y2UjWkmy40XcVDBmwfFQgveSC8suxjbbnrh4gyB2tZRWgYWybpIKaxFZehMQkwbM+GhbPPBQFO7xQZlku27ixzh4Xie5/xPcp48+PX9gkPO///75X++V28O//xPUlVIkj7+rtvqASRJ82HQJakJgy5JTRh0SWrCoEtSEwZdkprYtlUfvGPHjtqzZ89WfbwkfSydOHHil1W1MGlty4K+Z88ejh8/vlUfL0kfS0n+Y701b7lIUhMGXZKaMOiS1IRBl6QmDLokNTE16El+I8m/Jnk9yZkkfzFhT5I8mWQlyekkt2/OuJKk9Qx5bPF/gC9U1cUk24GXk7xQVa+s2XMvsHf0ugN4evSnJOkamfoNvS67ODrcPnqN/yfqB4BnR3tfAW5McvN8R5UkbWTQD4uSXA+cAH4PeKqqXh3bshN4a83x6ujcubHrLAPLAIuLi1c4sibZ8/g/bfUI0kT//td/utUjfGIM+kfRqvrfqvpDYBewL8nvj23JpL824TpHqmqpqpYWFib+clWSdIVmesqlqv4b+Alwz9jSKrB7zfEu4O2rmkySNJMhT7ksJLlx9P43gT8C/m1s21HgwdHTLncCF6rqHJKka2bIPfSbgW+P7qNfB/xDVf0gycMAVXUYOAbsB1aA94CHNmleSdI6pga9qk4Dt004f3jN+wIene9okqRZ+EtRSWrCoEtSEwZdkpow6JLUhEGXpCYMuiQ1YdAlqQmDLklNGHRJasKgS1ITBl2SmjDoktSEQZekJgy6JDVh0CWpCYMuSU0YdElqwqBLUhMGXZKaMOiS1IRBl6QmDLokNWHQJakJgy5JTRh0SWpiatCT7E7y4yRnk5xJ8uUJe+5OciHJqdHric0ZV5K0nm0D9lwCHquqk0k+A5xI8qOqemNs30tVdd/8R5QkDTH1G3pVnauqk6P3vwbOAjs3ezBJ0mxmuoeeZA9wG/DqhOW7krye5IUkt67z95eTHE9y/Pz58zMPK0la3+CgJ7kBeA74SlW9O7Z8Erilqv4A+Fvg+UnXqKojVbVUVUsLCwtXOrMkaYJBQU+yncsx/05VfX98vareraqLo/fHgO1Jdsx1UknShoY85RLgG8DZqvr6OntuGu0jyb7Rdd+Z56CSpI0Necrl88AXgZ8mOTU691VgEaCqDgP3A48kuQS8DxysqtqEeSVJ65ga9Kp6GciUPYeAQ/MaSpI0O38pKklNGHRJasKgS1ITBl2SmjDoktSEQZekJgy6JDVh0CWpCYMuSU0YdElqwqBLUhMGXZKaMOiS1IRBl6QmDLokNWHQJakJgy5JTRh0SWrCoEtSEwZdkpow6JLUhEGXpCYMuiQ1YdAlqQmDLklNGHRJamJq0JPsTvLjJGeTnEny5Ql7kuTJJCtJTie5fXPGlSStZ9uAPZeAx6rqZJLPACeS/Kiq3liz515g7+h1B/D06E9J0jUy9Rt6VZ2rqpOj978GzgI7x7YdAJ6ty14Bbkxy89ynlSSta6Z76En2ALcBr44t7QTeWnO8ykejT5LlJMeTHD9//vxsk0qSNjQ46EluAJ4DvlJV744vT/gr9ZETVUeqaqmqlhYWFmabVJK0oUFBT7KdyzH/TlV9f8KWVWD3muNdwNtXP54kaaghT7kE+AZwtqq+vs62o8CDo6dd7gQuVNW5Oc4pSZpiyFMunwe+CPw0yanRua8CiwBVdRg4BuwHVoD3gIfmP6okaSNTg15VLzP5HvnaPQU8Oq+hJEmz85eiktSEQZekJgy6JDVh0CWpCYMuSU0YdElqwqBLUhMGXZKaMOiS1IRBl6QmDLokNWHQJakJgy5JTRh0SWrCoEtSEwZdkpow6JLUhEGXpCYMuiQ1YdAlqQmDLklNGHRJasKgS1ITBl2SmjDoktTE1KAneSbJL5L8bJ31u5NcSHJq9Hpi/mNKkqbZNmDPt4BDwLMb7Hmpqu6by0SSpCsy9Rt6Vb0I/OoazCJJugrzuod+V5LXk7yQ5NY5XVOSNIMht1ymOQncUlUXk+wHngf2TtqYZBlYBlhcXJzDR0uSPnTV39Cr6t2qujh6fwzYnmTHOnuPVNVSVS0tLCxc7UdLkta46qAnuSlJRu/3ja75ztVeV5I0m6m3XJJ8F7gb2JFkFfgasB2gqg4D9wOPJLkEvA8crKratIklSRNNDXpVPTBl/RCXH2uUJG0hfykqSU0YdElqwqBLUhMGXZKaMOiS1IRBl6QmDLokNWHQJakJgy5JTRh0SWrCoEtSEwZdkpow6JLUhEGXpCYMuiQ1YdAlqQmDLklNGHRJasKgS1ITBl2SmjDoktSEQZekJgy6JDVh0CWpCYMuSU0YdElqYmrQkzyT5BdJfrbOepI8mWQlyekkt89/TEnSNEO+oX8LuGeD9XuBvaPXMvD01Y8lSZrV1KBX1YvArzbYcgB4ti57Bbgxyc3zGlCSNMw87qHvBN5ac7w6OvcRSZaTHE9y/Pz583P4aEnSh+YR9Ew4V5M2VtWRqlqqqqWFhYU5fLQk6UPzCPoqsHvN8S7g7TlcV5I0g3kE/Sjw4OhplzuBC1V1bg7XlSTNYNu0DUm+C9wN7EiyCnwN2A5QVYeBY8B+YAV4D3hos4aVJK1vatCr6oEp6wU8OreJJElXxF+KSlITBl2SmjDoktSEQZekJgy6JDVh0CWpCYMuSU0YdElqwqBLUhMGXZKaMOiS1IRBl6QmDLokNWHQJakJgy5JTRh0SWrCoEtSEwZdkpow6JLUhEGXpCYMuiQ1YdAlqQmDLklNGHRJasKgS1ITg4Ke5J4kbyZZSfL4hPW7k1xIcmr0emL+o0qSNrJt2oYk1wNPAX8MrAKvJTlaVW+MbX2pqu7bhBklSQMM+Ya+D1ipqp9X1QfA94ADmzuWJGlWQ4K+E3hrzfHq6Ny4u5K8nuSFJLfOZTpJ0mBTb7kAmXCuxo5PArdU1cUk+4Hngb0fuVCyDCwDLC4uzjiqJGkjQ76hrwK71xzvAt5eu6Gq3q2qi6P3x4DtSXaMX6iqjlTVUlUtLSwsXMXYkqRxQ4L+GrA3yWeTfAo4CBxduyHJTUkyer9vdN135j2sJGl9U2+5VNWlJF8CfghcDzxTVWeSPDxaPwzcDzyS5BLwPnCwqsZvy0iSNtGQe+gf3kY5Nnbu8Jr3h4BD8x1NkjQLfykqSU0YdElqwqBLUhMGXZKaMOiS1IRBl6QmDLokNWHQJakJgy5JTRh0SWrCoEtSEwZdkpow6JLUhEGXpCYMuiQ1YdAlqQmDLklNGHRJasKgS1ITBl2SmjDoktSEQZekJgy6JDVh0CWpCYMuSU0YdElqYlDQk9yT5M0kK0ken7CeJE+O1k8nuX3+o0qSNjI16EmuB54C7gU+BzyQ5HNj2+4F9o5ey8DTc55TkjTFkG/o+4CVqvp5VX0AfA84MLbnAPBsXfYKcGOSm+c8qyRpA9sG7NkJvLXmeBW4Y8CencC5tZuSLHP5GzzAxSRvzjStdO3sAH651UN0kL/Z6gnauWW9hSFBz4RzdQV7qKojwJEBnyltqSTHq2ppq+eQZjHklssqsHvN8S7g7SvYI0naREOC/hqwN8lnk3wKOAgcHdtzFHhw9LTLncCFqjo3fiFJ0uaZesulqi4l+RLwQ+B64JmqOpPk4dH6YeAYsB9YAd4DHtq8kaVrwluD+thJ1UdudUuSPob8pagkNWHQJakJgy5JTRh0SWrCoEtSEwZdn3hJfivJXyX5+yR/Prb2d1s1lzQrgy7BN7n831c8BxxM8lyST4/W7ty6saTZGHQJfreqHq+q56vqz4CTwD8n+e2tHkyaxZD/nEvq7tNJrquq/wOoqr9Msgq8CNywtaNJw/kNXYJ/BL6w9kRVfRt4DPhgSyaSroA//Zc2kOShqvrmVs8hDWHQpQ0k+c+qWtzqOaQhvIeuT7wkp9dbAn7nWs4iXQ2DLl2O9p8A/zV2PsC/XPtxpCtj0CX4AXBDVZ0aX0jyk2s/jnRlvIcuSU342KIkNWHQJakJgy5JTRh0SWrCoEtSE/8PDGa49HlTWN4AAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "reld = release_dates\n",
    "reld = reld[reld.title.str.contains('The Hobbit')]\n",
    "reld = reld[reld.country == 'USA']\n",
    "reld.date.dt.month.value_counts().sort_index().plot(kind='bar')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "### Make a bar plot of the day of the week on which movies with \"Romance\" in their title tend to be released in the USA."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x3ce3700>"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXAAAAD1CAYAAABJE67gAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAANYklEQVR4nO3df6zdd13H8ddr3UBgC3bpWa3txlWsyPyxO7zpMPWP4QDratwwkliT2ZjN8geNW0KMN9ME/EPTP4SFPwxJcYVqYGQCywpdgKaCy3SW3c6ytd5hEcso69o7Ubc5ArR7+cf53uR6d2/Puedn3/b5SG7OOZ/z653t9tlvv/f7PddJBACo55JxDwAA6A0BB4CiCDgAFEXAAaAoAg4ARRFwACjq0lG+2Zo1azIxMTHKtwSA8g4fPvxcktbi9ZEGfGJiQjMzM6N8SwAoz/a3llpnFwoAFEXAAaAoAg4ARRFwACiKgANAUQQcAIoi4ABQFAEHgKJGeiIPAFQwMb1/qK9/YtfWgbwOW+AAUBQBB4CiCDgAFEXAAaAoAg4ARRFwACiKgANAUQQcAIrqGHDbP2L7q7a/ZvuY7T9t1q+0fcD28eZy9fDHBQDM62YL/PuSfiXJdZImJW2x/VZJ05IOJtko6WBzGwAwIh0DnrYXm5uXNV+RdIukvc36Xkm3DmVCAMCSutoHbnuV7SOSzkg6kOSQpLVJTklSc3nV8MYEACzWVcCTnEsyKWmDpE22f67bN7C9w/aM7Zm5uble5wQALLKio1CS/Jekr0jaIum07XWS1FyeWeY5u5NMJZlqtVp9jgsAmNfNUSgt2z/aXH+NpLdLekrSPknbm4dtl/TgsIYEALxSN58Hvk7SXtur1A7+/Uk+b/tRSffbvl3S05LePcQ5AQCLdAx4kickXb/E+n9IumkYQwEAOuNMTAAoioADQFEEHACKIuAAUBQBB4CiCDgAFEXAAaAoAg4ARRFwACiKgANAUQQcAIoi4ABQFAEHgKIIOAAURcABoCgCDgBFEXAAKIqAA0BRBBwAiiLgAFAUAQeAogg4ABRFwAGgKAIOAEV1DLjtq21/2fas7WO272zWP2D7O7aPNF83D39cAMC8S7t4zFlJ70vyuO0rJB22faC5754kfzG88QAAy+kY8CSnJJ1qrr9ge1bS+mEPBgA4vxXtA7c9Iel6SYeapZ22n7C9x/bqAc8GADiPrgNu+3JJn5F0V5LnJX1E0hslTaq9hf7BZZ63w/aM7Zm5ubkBjAwAkLoMuO3L1I73J5J8VpKSnE5yLsnLkj4qadNSz02yO8lUkqlWqzWouQHgotfNUSiWdK+k2SQfWrC+bsHD3iXp6ODHAwAsp5ujUDZLuk3Sk7aPNGt3S9pme1JSJJ2Q9J6hTAgAWFI3R6E8IslL3PXQ4McBAHSLMzEBoCgCDgBFEXAAKIqAA0BRBBwAiiLgAFAUAQeAogg4ABRFwAGgKAIOAEURcAAoioADQFEEHACKIuAAUFQ3nwc+NhPT+4f6+id2bR3q6wPAMLEFDgBFEXAAKIqAA0BRBBwAiiLgAFAUAQeAogg4ABRFwAGgqI4Bt3217S/bnrV9zPadzfqVtg/YPt5crh7+uACAed1sgZ+V9L4kb5b0VknvtX2tpGlJB5NslHSwuQ0AGJGOAU9yKsnjzfUXJM1KWi/pFkl7m4ftlXTrsIYEALzSivaB256QdL2kQ5LWJjkltSMv6apBDwcAWF7XAbd9uaTPSLoryfMreN4O2zO2Z+bm5nqZEQCwhK4CbvsyteP9iSSfbZZP217X3L9O0pmlnptkd5KpJFOtVmsQMwMA1N1RKJZ0r6TZJB9acNc+Sdub69slPTj48QAAy+nm88A3S7pN0pO2jzRrd0vaJel+27dLelrSu4czIgBgKR0DnuQRSV7m7psGOw4AoFuciQkARRFwACiKgANAUQQcAIoi4ABQFAEHgKIIOAAURcABoKhuzsQEMGIT0/uH+vondm0d6utjNNgCB4CiCDgAFEXAAaAoAg4ARRFwACiKgANAUQQcAIoi4ABQFAEHgKIIOAAURcABoCgCDgBFEXAAKIqAA0BRBBwAiuoYcNt7bJ+xfXTB2gdsf8f2kebr5uGOCQBYrJst8I9L2rLE+j1JJpuvhwY7FgCgk44BT/KwpO+OYBYAwAr0sw98p+0nml0sq5d7kO0dtmdsz8zNzfXxdgCAhXoN+EckvVHSpKRTkj643AOT7E4ylWSq1Wr1+HYAgMV6CniS00nOJXlZ0kclbRrsWACATnoKuO11C26+S9LR5R4LABiOSzs9wPZ9km6UtMb2SUnvl3Sj7UlJkXRC0nuGOCMAYAkdA55k2xLL9w5hFgDACnAmJgAURcABoCgCDgBFEXAAKIqAA0BRBBwAiiLgAFAUAQeAogg4ABRFwAGgKAIOAEURcAAoioADQFEEHACKIuAAUBQBB4CiCDgAFEXAAaAoAg4ARRFwACiq4y81xsVrYnr/0F77xK6tQ3tt4GLBFjgAFEXAAaCojgG3vcf2GdtHF6xdafuA7ePN5erhjgkAWKybLfCPS9qyaG1a0sEkGyUdbG4DAEaoY8CTPCzpu4uWb5G0t7m+V9KtA54LANBBr/vA1yY5JUnN5VWDGwkA0I2h/xDT9g7bM7Zn5ubmhv12AHDR6DXgp22vk6Tm8sxyD0yyO8lUkqlWq9Xj2wEAFus14PskbW+ub5f04GDGAQB0q5vDCO+T9KikN9k+aft2SbskvcP2cUnvaG4DAEao46n0SbYtc9dNA54FALACnIkJAEURcAAoioADQFEEHACKIuAAUBQBB4CiCDgAFEXAAaAoficmgIEb5u9TlfidqvPYAgeAogg4ABRFwAGgKAIOAEURcAAoiqNQ8P8SR0HgYsAWOAAURcABoCgCDgBFEXAAKIqAA0BRBBwAiiLgAFAUAQeAovo6kcf2CUkvSDon6WySqUEMBQDobBBnYr4tyXMDeB0AwAqwCwUAiuo34JH0JduHbe8YxEAAgO70uwtlc5JnbF8l6YDtp5I8vPABTdh3SNI111zT59sBAOb1tQWe5Jnm8oykByRtWuIxu5NMJZlqtVr9vB0AYIGeA277dbavmL8u6Z2Sjg5qMADA+fWzC2WtpAdsz7/OJ5N8YSBTAQA66jngSb4p6boBzgIAWAEOIwSAogg4ABRFwAGgKAIOAEURcAAoioADQFEEHACKIuAAUNQgPg8cy5iY3j/U1z+xa+tQXx/AhY0tcAAoioADQFEEHACKIuAAUBQBB4CiCDgAFEXAAaAoAg4ARRFwACiKgANAUQQcAIoi4ABQFAEHgKIIOAAURcABoKi+Am57i+2v2/6G7elBDQUA6KzngNteJekvJf2apGslbbN97aAGAwCcXz9b4JskfSPJN5P8QNKnJN0ymLEAAJ04SW9PtH9L0pYkdzS3b5N0Q5Kdix63Q9KO5uabJH2993E7WiPpuSG+/rAx//hUnl1i/nEb9vxvSNJavNjP78T0Emuv+NsgyW5Ju/t4n67ZnkkyNYr3GgbmH5/Ks0vMP27jmr+fXSgnJV294PYGSc/0Nw4AoFv9BPwxSRtt/4TtV0n6bUn7BjMWAKCTnnehJDlre6ekL0paJWlPkmMDm6w3I9lVM0TMPz6VZ5eYf9zGMn/PP8QEAIwXZ2ICQFEEHACKIuAAUFQ/x4GPle2fUfvMz/VqH3/+jKR9SWbHOthFovnvv17SoSQvLljfkuQL45usO7Y3SUqSx5qPgNgi6akkD415tJ7Y/uskvzvuOXph+5fVPrP7aJIvjXueTmzfIGk2yfO2XyNpWtJbJP2LpD9P8t8jm6XiDzFt/5GkbWqfvn+yWd6g9qGMn0qya1yzDYLt30vysXHPsRzbfyDpvZJmJU1KujPJg819jyd5yzjn68T2+9X+DJ9LJR2QdIOkr0h6u6QvJvmz8U3Xme3Fh+ta0tsk/Z0kJfmNkQ+1Ara/mmRTc/331f5eekDSOyV97kL/82v7mKTrmiPxdkt6SdKnJd3UrP/myGYpGvB/lfSzSX64aP1Vko4l2TieyQbD9tNJrhn3HMux/aSkX0ryou0Jtb95/ybJh23/c5LrxzpgB838k5JeLelZSRsWbE0dSvILYx2wA9uPq72191dq/+vTku5TewNGSf5+fNN1tvB7xPZjkm5OMmf7dZL+KcnPj3fC87M9m+TNzfX/s8Fi+0iSyVHNUnUXysuSflzStxatr2vuu+DZfmK5uyStHeUsPVg1v9skyQnbN0r6tO03aOmPWLjQnE1yTtJLtv8tyfOSlOR7tit8/0xJulPSH0v6wyRHbH/vQg/3ApfYXq32z+CcZE6SkvyP7bPjHa0rRxf8K/lrtqeSzNj+aUk/7PTkQaoa8LskHbR9XNK3m7VrJP2UpJ3LPuvCslbSr0r6z0XrlvSPox9nRZ61PZnkiCQ1W+K/LmmPpAt666nxA9uvTfKSpF+cX7T9ehXYAEjysqR7bP9tc3latf4sv17SYbW/12P7x5I8a/ty1dgAuEPSh23/idofYPWo7W+r3aI7RjlIyV0okmT7ErV/8LFe7f/pJyU91mxZXfBs3yvpY0keWeK+Tyb5nTGM1RXbG9Tein12ifs2J/mHMYzVNduvTvL9JdbXSFqX5MkxjNUz21slbU5y97hn6Yft10pam+Tfxz1LN2xfIekn1f7L82SS0yOfoWrAAeBix3HgAFAUAQeAogg4ABRFwAGgKAIOAEX9L+OZd7qIe5LPAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "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": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "### Make a bar plot of the day of the week on which movies with \"Action\" in their title tend to be released in the USA."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x4776658>"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXAAAAD1CAYAAABJE67gAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAN5ElEQVR4nO3df4xlZ13H8fenXYssINTspZRuh2mVVgGx4PDL+qP8dKVNawx/dBWsWJzECBSjwiIm/UuzUSI20WAmsBQVt9FaBK0CDVgatCydXRa62y0/hKUs0O40NSCUUNZ+/WMuyXCdnXvn3jNz90nfr6SZe5975pxPtnc+++wz59yTqkKS1J7Tph1AkjQeC1ySGmWBS1KjLHBJapQFLkmNssAlqVFbNvNg27Ztq9nZ2c08pCQ1b//+/fdXVW9wfFMLfHZ2lsXFxc08pCQ1L8mXVht3CUWSGmWBS1KjLHBJapQFLkmNssAlqVEWuCQ1ygKXpEZZ4JLUqE29kEfSaGZ33byh+z+6+9IN3b82hzNwSWqUBS5JjbLAJalRFrgkNcoCl6RGWeCS1CgLXJIaZYFLUqOGFniSPUmOJzk0MP66JJ9JcjjJn2xcREnSakaZgV8P7Fg5kOSFwBXAM6vq6cBbu48mSVrL0AKvqtuABwaGfwvYXVXf6W9zfAOySZLWMO4a+AXAzybZl+SjSZ7TZShJ0nDjfpjVFuBM4PnAc4C/T3J+VdXghknmgXmAmZmZcXNKkgaMOwM/BtxUyz4BPAxsW23Dqlqoqrmqmuv1euPmlCQNGLfA/wl4EUCSC4AzgPu7CiVJGm7oEkqSvcAlwLYkx4BrgT3Anv6phQ8BV622fCJJ2jhDC7yqdp7kpVd2nEWStA5eiSlJjbLAJalRFrgkNcoCl6RGWeCS1CgLXJIaZYFLUqMscElqlAUuSY2ywCWpURa4JDXKApekRlngktQoC1ySGmWBS1KjhhZ4kj1Jjvdv3jD42u8lqSSr3k5NkrRxRpmBXw/sGBxMci7wUuCejjNJkkYwtMCr6jbggVVeehvwRsBbqUnSFIy1Bp7kcuArVfWpjvNIkkY09J6Yg5JsBd4CvGzE7eeBeYCZmZn1Hk6SdBLjzMB/BDgP+FSSo8B24ECSJ622cVUtVNVcVc31er3xk0qSvs+6Z+BVdSfwxO8975f4XFXd32EuSdIQo5xGuBe4HbgwybEkV298LEnSMENn4FW1c8jrs52lkSSNzCsxJalRFrgkNcoCl6RGWeCS1CgLXJIaZYFLUqMscElqlAUuSY2ywCWpURa4JDXKApekRlngktQoC1ySGmWBS1KjLHBJatQoN3TYk+R4kkMrxv40yd1JPp3kvUmesLExJUmDRpmBXw/sGBi7BXhGVT0T+Czw5o5zSZKGGFrgVXUb8MDA2Ieq6kT/6cdZvrGxJGkTdbEG/hvAv3WwH0nSOkxU4EneApwA3rPGNvNJFpMsLi0tTXI4SdIKYxd4kquAy4Bfrao62XZVtVBVc1U11+v1xj2cJGnA0LvSrybJDuBNwM9X1YPdRpIkjWKU0wj3ArcDFyY5luRq4C+AxwG3JDmY5K82OKckacDQGXhV7Vxl+J0bkEWStA5eiSlJjbLAJalRFrgkNcoCl6RGWeCS1CgLXJIaZYFLUqMscElqlAUuSY2ywCWpURa4JDXKApekRlngktQoC1ySGmWBS1KjLHBJatQod+TZk+R4kkMrxn44yS1JPtf/eubGxpQkDRplBn49sGNgbBfw4ap6KvDh/nNJ0iYaWuBVdRvwwMDwFcC7+4/fDfxSx7kkSUOMuwZ+VlV9DaD/9YndRZIkjWLDf4mZZD7JYpLFpaWljT6cJD1ijFvg9yU5G6D/9fjJNqyqhaqaq6q5Xq835uEkSYPGLfD3A1f1H18FvK+bOJKkUY1yGuFe4HbgwiTHklwN7AZemuRzwEv7zyVJm2jLsA2qaudJXnpxx1kkSevglZiS1CgLXJIaZYFLUqMscElqlAUuSY2ywCWpURa4JDXKApekRlngktQoC1ySGmWBS1KjLHBJapQFLkmNssAlqVEWuCQ1aqICT/I7SQ4nOZRkb5If7CqYJGltYxd4knOA1wNzVfUM4HTgyq6CSZLWNukSyhbg0Um2AFuBr04eSZI0irELvKq+ArwVuAf4GvD1qvpQV8EkSWubZAnlTOAK4DzgycBjkrxyle3mkywmWVxaWho/qSTp+0yyhPIS4ItVtVRV3wVuAn56cKOqWqiquaqa6/V6ExxOkrTSJAV+D/D8JFuThOW71B/pJpYkaZhJ1sD3ATcCB4A7+/ta6CiXJGmILZN8c1VdC1zbURZJ0jp4JaYkNcoCl6RGWeCS1CgLXJIaZYFLUqMscElqlAUuSY2ywCWpURa4JDXKApekRlngktQoC1ySGmWBS1KjLHBJapQFLkmNssAlqVETFXiSJyS5McndSY4keUFXwSRJa5vojjzAdcAHquoVSc4AtnaQSZI0grELPMkPAT8H/DpAVT0EPNRNLEnSMJMsoZwPLAHvSvLJJO9I8pjBjZLMJ1lMsri0tDTB4SRJK01S4FuAZwNvr6pnAd8Cdg1uVFULVTVXVXO9Xm+Cw0mSVpqkwI8Bx6pqX//5jSwXuiRpE4xd4FV1L/DlJBf2h14M3NVJKknSUJOehfI64D39M1C+ALx68kiSpFFMVOBVdRCY6yiLJGkdvBJTkhplgUtSoyxwSWqUBS5JjbLAJalRFrgkNcoCl6RGWeCS1CgLXJIaZYFLUqMscElqlAUuSY2ywCWpURa4JDXKApekRk1c4ElO79/U+F+6CCRJGk0XM/BrgCMd7EeStA4TFXiS7cClwDu6iSNJGtWkM/A/B94IPNxBFknSOox9T8wklwHHq2p/kkvW2G4emAeYmZkZ93CagtldN2/Yvo/uvnTD9i1NaiPf+9Dd+3+SGfjFwOVJjgI3AC9K8reDG1XVQlXNVdVcr9eb4HCSpJXGLvCqenNVba+qWeBK4CNV9crOkkmS1uR54JLUqLHXwFeqqluBW7vYlyRpNM7AJalRFrgkNcoCl6RGWeCS1CgLXJIaZYFLUqMscElqlAUuSY2ywCWpURa4JDXKApekRlngktQoC1ySGmWBS1KjLHBJatTYBZ7k3CT/nuRIksNJrukymCRpbZPc0OEE8LtVdSDJ44D9SW6pqrs6yiZJWsMk98T8WlUd6D/+H+AIcE5XwSRJa+tkDTzJLPAsYF8X+5MkDTfxPTGTPBb4R+ANVfWNVV6fB+YBZmZm1rXv2V03TxpvTUd3X7qh+5ceqfzZ3RwTzcCT/ADL5f2eqrpptW2qaqGq5qpqrtfrTXI4SdIKk5yFEuCdwJGq+rPuIkmSRjHJDPxi4FXAi5Ic7P/38o5ySZKGGHsNvKo+BqTDLJKkdfBKTElqlAUuSY2ywCWpURa4JDXKApekRlngktQoC1ySGjXxZ6Ho5Pw8iOnxz16PBM7AJalRFrgkNcoCl6RGWeCS1CgLXJIaZYFLUqMscElqlAUuSY2a9J6YO5J8Jsnnk+zqKpQkabhJ7ol5OvCXwC8CTwN2JnlaV8EkSWubZAb+XODzVfWFqnoIuAG4optYkqRhUlXjfWPyCmBHVb2m//xVwPOq6rUD280D8/2nFwKfGT/uUNuA+zdw/xvN/NPTcnYw/7RtdP6nVFVvcHCSD7Na7YbG/+9vg6paABYmOM7IkixW1dxmHGsjmH96Ws4O5p+2aeWfZAnlGHDuiufbga9OFkeSNKpJCvwO4KlJzktyBnAl8P5uYkmShhl7CaWqTiR5LfBB4HRgT1Ud7izZeDZlqWYDmX96Ws4O5p+2qeQf+5eYkqTp8kpMSWqUBS5JjbLAJalRzd7UOMmPsXzl5zksn3/+VeD9VXVkqsEeIfp//ucA+6rqmyvGd1TVB6aXbDRJngtUVd3R/wiIHcDdVfWvU442liR/XVW/Nu0c40jyMyxf2X2oqj407TzDJHkecKSqvpHk0cAu4NnAXcAfV9XXNy1Li7/ETPImYCfLl+8f6w9vZ/lUxhuqave0snUhyaur6l3TznEySV4P/DZwBLgIuKaq3td/7UBVPXua+YZJci3Ln+GzBbgFeB5wK/AS4INV9UfTSzdcksHTdQO8EPgIQFVdvumh1iHJJ6rquf3Hv8nye+m9wMuAfz7Vf36THAZ+sn8m3gLwIHAj8OL++C9vWpZGC/yzwNOr6rsD42cAh6vqqdNJ1o0k91TVzLRznEySO4EXVNU3k8yy/Ob9m6q6Lsknq+pZUw04RD//RcCjgHuB7StmU/uq6plTDThEkgMsz/bewfK/PgPsZXkCQ1V9dHrphlv5HklyB/DyqlpK8hjg41X1E9NNuLYkR6rqx/uPv2/CkuRgVV20WVlaXUJ5GHgy8KWB8bP7r53yknz6ZC8BZ21mljGc/r1lk6o6muQS4MYkT2H1j1g41Zyoqv8FHkzyX1X1DYCq+naSFt4/c8A1wFuA36+qg0m+faoX9wqnJTmT5d/BpaqWAKrqW0lOTDfaSA6t+Ffyp5LMVdVikguA7w775i61WuBvAD6c5HPAl/tjM8CPAq896XedWs4CfgH474HxAP+5+XHW5d4kF1XVQYD+TPwyYA9wSs+e+h5KsrWqHgR+6nuDSR5PAxOAqnoYeFuSf+h/vY+2fpYfD+xn+b1eSZ5UVfcmeSxtTABeA1yX5A9Z/gCr25N8meUues1mBmlyCQUgyWks/+LjHJb/px8D7ujPrE55Sd4JvKuqPrbKa39XVb8yhVgjSbKd5Vnsvau8dnFV/ccUYo0syaOq6jurjG8Dzq6qO6cQa2xJLgUurqo/mHaWSSTZCpxVVV+cdpZRJHkccD7Lf3keq6r7Nj1DqwUuSY90ngcuSY2ywCWpURa4JDXKApekRlngktSo/wPFEIzB8U6CgwAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "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": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "### On which date was each Judi Dench movie from the 1990s released in the USA?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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",
       "      <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.0</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.0</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.0</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.0</td>\n",
       "      <td>USA</td>\n",
       "      <td>1997-10-03</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.0</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.0</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.0</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.0</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.0   \n",
       "2             Jack & Sarah  1995  Judi Dench  actress         Margaret   3.0   \n",
       "1                   Hamlet  1996  Judi Dench  actress           Hecuba  12.0   \n",
       "3                Mrs Brown  1997  Judi Dench  actress   Queen Victoria   1.0   \n",
       "7      Tomorrow Never Dies  1997  Judi Dench  actress                M   9.0   \n",
       "4      Shakespeare in Love  1998  Judi Dench  actress  Queen Elizabeth  12.0   \n",
       "5       Tea with Mussolini  1999  Judi Dench  actress         Arabella   2.0   \n",
       "6  The World Is Not Enough  1999  Judi Dench  actress                M   6.0   \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-10-03  \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": [
    "us = release_dates[release_dates.country == 'USA']\n",
    "c = cast\n",
    "c = c[c.name == 'Judi Dench']\n",
    "c = c[c.year // 10 == 199]\n",
    "c.merge(us).sort_values('date')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "### In which months do films with Judi Dench tend to be released in the USA?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x4847058>"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXAAAAD4CAYAAAD1jb0+AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nO3de3hU1bk/8O+b+3UmQBLIBDEX7hNuId6AQlVQRAvaUkuF6mn9lRZREXtOxdP2HNuq7aktXorF+ng9BcVTwYpYFUQLalEbwkVIkDDDPUAmQEJmEnKb9fsjM4jjhFxmz+y9J9/P8/gkGeLe72j4Pitrrf0uUUqBiIjMJ0bvAoiIqGcY4EREJsUAJyIyKQY4EZFJMcCJiEwqLpI3y8zMVHl5eZG8JRGR6W3durVGKZUV+HpEAzwvLw+lpaWRvCURkemJyMFgr3MKhYjIpBjgREQmxQAnIjIpBjgRkUkxwImITKrTABeR50SkWkR2nffaIyKyR0R2ishrIpIR3jKJiChQV0bgLwCYHvDaBgBFSqnRAPYCuF/juoiIqBOdBrhSajOAUwGvrVdKtfq+/BjAwDDURkQUFpv3urCv2q13GSHTYg78BwDe6ugPRWS+iJSKSKnL5dLgdkREPaeUwp0vleEP6z/Xu5SQhRTgIvIzAK0AVnb0PUqpp5VSJUqpkqysrzwJSkQUUS53E86cbcWuqjq9SwlZjwNcRG4DcAOAuYrH+hCRSThdHgDA4VONqGts0bma0PQowEVkOoD7AMxUSjVoWxIRUfg4XF/MfZdXndGxktB1ZRvhywC2ABgmIkdE5HYAywCkA9ggIttF5Kkw10lEpAmny4O4GAEA7Db5NEqn3QiVUt8N8vKzYaiFiCjsnC43hvRPx2lPM3abfAQe0XayRER6c7g8GD3QikZrkulH4HyUnoh6jbMtbThyugEFWWmw2yzYV+1GY3Ob3mX1GAOciHqNgycb4FVAYVYqRtqs8Cpgz3HzTqMwwImo13D6dqAUZqWhKNcCAKaeB+ccOBH1Gv4thPmZqUhJiIU1OZ4BTkRkBk6XBznWJKQmtkef3WYx9UImp1CIqNdw1HhQkJV67uuiXCv2HK9HS5tXx6p6jgFORL2CUgrOajcKs9LOvWa3WdDc6v3S05lmwgAnol7B5W5CfVMrCjK/GIHbbb6FzKPmnAdngBNRr+Cobm9iVXDeCDw/Mw3J8bGm7UzIACeiXsFZ49tCmP1FgMfGCEbkpJt2JwoDnIh6BafLg6T4GORYkr70ut1mRUXVGXi95uuKzQAnol7B4XKjIDMNMb5OhH52mwX1Ta04fNp8nbEZ4ETUKzhdX95C6Ge3WQEAu0y4kMkAJ6Kod7alDYdPN3xpC6Hf0AFpiIsRUz7QwwAnoqh38GQDlELQEXhiXCyG9DfnQiYDnIiinuO8JlbB+B+pN9vxvgxwIop6zvOaWAVTZLOgxt2M6vqmSJYVMgY4EUW9wCZWgey57QuZZpsHZ4ATUdRzuNwdTp8AwIgcC0TM90g9A5yIoppSqsMthH5piXHI65dqukfqGeBEFNVc9V9tYhVM+0ImR+BERIbhcLU3sTq/B0owdpsVR043oq6hJRJlaYIBTkRRzd/EquACc+DAea1lj5lnGoUBTkRRzVHtQXJ87FeaWAUyY29wBjgRRTVnjRv5malfaWIVqF9aInKsSabaSsgAJ6Ko5nC5O53/9jPbQmanAS4iz4lItYjsOu+1viKyQUQqfR/7hLdMIqLuO9vShiOnGzvdgeI30maFw+VGY3NbmCvTRldG4C8AmB7w2hIAG5VSQwBs9H1NRGQoB056OmxiFUyRzQKvAiqOm2MU3mmAK6U2AzgV8PIsAC/6Pn8RwI0a10VEFDKnfwthJztQ/L54pD5KArwD/ZVSxwDA9zG7o28UkfkiUioipS6Xq4e3IyLqPn8Tq66OwG3WJGSkxKPcJAuZYV/EVEo9rZQqUUqVZGVlhft2RETnOFwe2KxJSEkI3sQqkIjAbrOY5nSengb4CRHJAQDfx2rtSiIi0obT5e70AZ5ARTYrPj9ej5Y2b5iq0k5PA3wtgNt8n98G4HVtyiEi0oZSCo5OmlgFM9JmQXObF/uq3WGqTDtd2Ub4MoAtAIaJyBERuR3AbwFME5FKANN8XxMRGYarvgnuptYuL2D6+Q85NsNCZqcTQ0qp73bwR1drXAsRkWb8Tay6OwLPz0xFcnwsdh2tw+zxA8NRmmb4JCYRRaXOzsHsSGyMYKTNgnITjMAZ4EQUlZyu9iZWAzppYhWM3WZB+bEz8HqNfcgxA5yIopLD5UZBVudNrIKx2yxwN7Xi4KmGMFSmHQY4EUUlZ033txD6fbGQaewHehjgRBR1utvEKtCQ/mmIjxXD70RhgBNR1PE3sepqG9lAiXGxGJKdzgAnIoo0fxOrno7AAV9v8KN1UMq4C5kMcCKKOo7q7jWxCqYo14qTnmacONOkVVmaY4ATUdRx1nSviVUw587INPBCJgOciKJOd45R68iIHAtEjP1IPQOciKKKUgpOlyek+W8ASE2MQ36/VOw6yhE4EVFE+JtY9XQP+PnsuVaOwImIImVfD3ugBGO3WXC0thG1Dc0hXyscGOBEFFWcPexCGMwXC5nGHIUzwIkoqjhcbqQk9KyJVSCjP1LPACeiqOJ0eZCf2bMmVoH6pibAZk3iCJyIKBIcPTgH80JG2oy7kMkAJ6KocbalDUdrG1Gowfy3n91mgcPlRkNzq2bX1AoDnIiihr+JlZYj8KJcK5QCKo7Va3ZNrTDAiShqOKrbd6BoPQIHgHIDLmQywIkoajh9e8DzQ3wK83w51iT0SYk35Dw4A5yIoobD5UZuRnJITawCiQjsNit2cQRORBQ+zhqPJg/wBLLnWrD3uBstbV7Nrx0KBjgRRQWtmlgFY7dZ0dzmReUJt+bXDgUDnIiiQrWviVWobWSD8S9kGm0ahQFORFHB4VvALMjUPsDz+6UiJSEW5QZbyGSAE1FUcPiaWBVmaz+FEhMjGJljMVxPlJACXEQWi8huEdklIi+LSOjdY4iIesCpYROrYOw2C8qrzsDrNc4hxz0OcBHJBXA3gBKlVBGAWABztCqMiKg7HL4mViKhN7EKxm6zwtPchgMnPWG5fk+EOoUSByBZROIApACoCr0kIqLuc7rcmhzi0BF7rvF6g/c4wJVSRwH8HsAhAMcA1Cml1gd+n4jMF5FSESl1uVw9r5SIqAP+Jlbh2APuNyQ7HfGxEh0BLiJ9AMwCkA/ABiBVROYFfp9S6mmlVIlSqiQrK6vnlRIRdWB/TXsTq3COwBPiYjC0f7qhFjJDmUKZCmC/UsqllGoBsAbABG3KIiLqOi2PUbsQu82C3VVnoJQxFjJDCfBDAC4XkRRpXzW4GkCFNmUREXVdOPeAn68o14pTnmYcP3M2rPfpqlDmwD8B8CqAMgCf+a71tEZ1ERF1mdPXxCo5ITas9zl3yPFRY8yDh7QLRSn130qp4UqpIqXU95RSTVoVRkTUVeFqYhVo+AALRIzzSD2fxCQiU1NKwVEd3i2EfqmJccjPTDXMThQGOBGZWnV9EzzNbREZgQNAkc1qmJ4oDHAiMjVHdfsCZiRG4ED7PPjR2kac9jRH5H4XwgAnIlNz1ERmC6Gf3WYFYIwnMhngRGRq4W5iFejcThQDLGQywInI1Byu9h0o4WpiFahPagJyM5I5AiciCpXT5Q77AzyBRtqM0RucAU5EpuVvYhWpBUw/u80CZ40HnqbWiN43EAOciEzL38QqUguYfkU2K5QC9hzXdxqFAU5EpuXvgRLxEbhBeoMzwInItPxdCPMzIzsCH2BJQt/UBOw6qu88OAOciEwrUk2sAonIudayemKAE5Fp+bcQ6sFus2LviXo0t3p1uT/AACcik1JKhf0czAux2yxoaVOorK7X5f4AA5yITOrEmfYmVoW6jcD17w3OACciU3L6T+HRaQSe1y8VqQmxuj7QwwAnIlPyN7HSawolJkZ8T2RyBE5E1C2OajdSE2LR35KoWw12mxXlx87A69XnkGMGOBGZkrPGg/wINrEKZqTNgobmNuw/6dHl/gxwIjKlSB2jdiFFOvcGZ4ATkek0Nrehqq4x4l0IAw3pn4aE2BjdFjIZ4ERkOv4mVoXZ+mwh9IuPjcHQAWm6bSVkgBOR6ThrfFsIdR6BA4A9x4rdVXVQKvILmQxwIjIdvZpYBVOUa8HphhYcqzsb8XszwInIdBw6NbEKZqSOC5kMcCIyHaeOTawCjchJhwh0aS3LACciU9G7iVWglIQ4FGSmmm8ELiIZIvKqiOwRkQoRuUKrwoiIgtG7iVUwRblWlOuwlTDUEfjjAN5WSg0HMAZAReglERF1zKnTMWoXYrdZUFV3Fqc8zRG9b48DXEQsACYDeBYAlFLNSqlarQojIgrGoXMXwmDs5xYyIzsKD2UEXgDABeB5EdkmIs+IyFd+pxGR+SJSKiKlLpcrhNsREbWfwqN3E6tA53qDR3gePJQAjwNQDGC5UmocAA+AJYHfpJR6WilVopQqycrKCuF2RETtI/CCrDRdm1gFykhJQG5GsqkC/AiAI0qpT3xfv4r2QCciChsjbSE8n91mwe4IbyXscYArpY4DOCwiw3wvXQ2gXJOqiIiCaGxuw9HaRkMtYPrZbVbsP+mBp6k1YvcMdRfKXQBWishOAGMBPBx6SUREwe33ncJjxBF4Ua4FSgEVxyI3jRIXyr+slNoOoESjWoiILsjfxMqoI3CgfSGzJK9vRO7JJzGJyDQc1R6IGKOJVaD+lkT0S02I6CP1DHAiMg1njRs2azKS4vVvYhVIJPKHHDPAicg0HC43CrONN33iV5RrRWV1PZpbvRG5HwOciExBKYX9Lg8KDDh94me3WdDSprD3RH1E7scAJyJTONfEysAj8Eg/Us8AJyJT8PdAKTTwCPzivilIS4yL2Dw4A5yITMFpwCZWgWJiBCNzIreQyQAnIlMwYhOrYEbaLCivOoM2b/gPOWaAE5EpGLGJVTB2mwWNLW3nnhoNJwY4EZmC0+Ux1Ck8HSnKjdxCJgOciAzP38TKyPPffoOz05AQF4PyCMyDM8CJyPD80xFG7IESKD42BsP6p2MXR+BEROcfo2b8KRTA1xu86gyUCu9CJgOciAzP6TJuE6tg7LlW1Da0oKrubFjvwwAnIsNzuNzIzTBmE6tgzp2RGebOhAxwIjI8Z43bFAuYfiMGWBAjwK4wL2QywInI0JRSptlC6JecEIuCrDSUh3khkwFORIZ2/MxZNDS3mWoEDgBFEegNzgAnIkNzunxbCE2ygOlnt1lxrO4sTrqbwnYPBjgRGdq5LoQGbiMbzLmFzDCOwhngRGRoTl8Tq+x0YzexCnT+IcfhwgAnIkPzH6Nm9CZWgawp8RjYJzmsPVEY4ERkaE6DH6N2IfYwL2QywInIsPxNrMzQAyUYu82K/TUeuJtaw3J9BjgRGZazxvin8FxIUW77QmbFsfCMwhngRGRY/i2EZmliFejcQmaYHqlngBORYTlcblM1sQqUnZ6IzLSEsD1SH3KAi0isiGwTkXVaFERE5Od0eUzVxCqQiGCkzRq2hUwtRuCLAFRocJ0OhbunLhEZk7PGbdoFTL8imwWVJ+rR1Nqm+bVDCnARGQjgegDPaFNOcC99egg//stWVJ8Jb29d0pbXq/DgunI8vdmB1jav3uWQyfibWJl1/tvPbrOi1auw97hb82uHOgJ/DMBPAXT4t1NE5otIqYiUulyuHt2kudWL9z6vxtSlm/DX0sMckZvEsvf34ZkP9+Phv+/BjX/6KCKHvFL08DexMvsIfFSuFcWDMow1AheRGwBUK6W2Xuj7lFJPK6VKlFIlWVlZPbrX9yfm461FX8OwAen4j1d34tbnPsXhUw09uhZFxgeVLjz67l7MGmvD8rnFOF7XhJnLPsIj7+zB2Rbtf5Ap+jiqzb0DxW9QvxSsuWMiSvL6an7tUEbgEwHMFJEDAFYBuEpEVmhSVRCFWWl4Zf4V+PUsO8oOnsa1j23GCx/th9fL0bjRVNU2YtGq7RiclYbffHMUrhuVg3fvnYwbx+biyfcduP6JD7D14Cm9yySD8+8BN/sIPJx6HOBKqfuVUgOVUnkA5gB4Tyk1T7PKgoiJEXzvijy8s3gyLsnriwfeKMe3/7wF+6rrw3lb6obmVi8WvlSGppY2LJ83HikJcQCAjJQE/OHmMXjxB5fibIsXs5/aggfW7oYnTE+okfk5qt1IS4wzXROrSDLlPvCBfVLwwvcvwdKbx8DhcmPG4x/iyff3oYULZbp7+O8V2HaoFr+bPQaDg7T/nDI0C+8snozbrsjDi1sO4JpHN2Pz3p6tjVB0c9a0L2CarYlVJGkS4EqpfyilbtDiWl0lIvhm8UBsWDwF00b2xyPvfI6Zyz7CrjAfIkode2NHFV745wF8f2Ierh+d0+H3pSXG4YGZdvz1R1cgMT4Gtz73Kf79rztQ19ASwWrJ6NqPUeP0yYWYcgR+vqz0RDw5txhPzRuPGncTZj35EX77FhfKIm1ftRtLVu9E8aAM3H/diC79OyV5ffH3u7+GhVcW4rVtRzH10U14e9exMFdKZtDQ3IqjtY2m7UIYKaYPcL/pRQPw7uIpmF08EE9tcmDG4x/g0/1cKIsET1MrFqzYisT4WDw5txgJcV3/sUqKj8V/XDsca++ciOz0RPx4RRkWrNiK6nru+e/N9tf4d6BwBH4hURPgQHsD9f+ZPRorbr8MzW1e3PznLfjF33aFrZUjtT9s8Z+vfYZ9LjeemDMOOdbkHl3HbrPibwsn4qfTh2HjnmpMW7qZe/57MYf/HMxsjsAvJKoC3G/SkEysXzwZP5iYjxWfHMQ1Szfh/c+r9S4rKq34+CBe316Fe6cOxaQhmSFdKz42Bnd8fTDeWvQ1DO2fxj3/vZjT18Qqrx8D/EKiMsABICUhDv/1jZF49ccTkJIYh+8//y/c+8p2nPY0611a1Nh+uBa/WleOK4dlYeGVgzW7rn/P/6+457/Xcro8GNjHvE2sIiVqA9xv/MV98Obdk3D3VYOxdkcVpj26CW/uPMZfzUN0ytOMO1ZsRXZ6Eh79zljExGi71SsmRnBrwJ7/m/+8Bfuqte8nQcbjcLlRkMn5785EfYADQGJcLO69ZhjeuGsScqzJWPhSGX70l604weZYPdLmVbjnle2ocTdj+bxiZKQkhO1e5+/53+dyY8bjH3DPf5TzehW3EHZRrwhwvxE5Frx2xwTcf91wbNrrwtSlm/DKvw5xNN5Nf3yvEpv3uvDfM0di9MCMsN8v2J7/WdzzH7WOnzmLxpY20/dAiYReFeAAEBcbgx9NKcTb90zGiBwL7lv9GeY9+wkOneRCWVds2uvC4xsr8c1xubjl0kERvff5e/5dvj3///M29/xHG7MfoxZJvS7A/fIzU7Hqh5fjwRuLsONwHa59bDOe/XA/2rhQ1qGjtY24Z9U2DM1Ox0M3jdLtEWf/nv9vFedi+T/a9/z/6wD3/EcLfxOrwZxC6VSvDXCgfaFs3uUXY/3iybiisB9+va4cs5/6JypPsDlWoOZWLxauLENLm8LyecVITtB3d4A1JR6/mz3m3J7/bz+1Bf/1Ovf8RwN/E6ssNrHqVJzeBRiBLSMZz95WgrU7qvDA2t24/okPYc+1IFLjy6T4WPxoSiGmDO1Zv/RIeOjNcmw/XIs/zS021NNxk4Zk4p17JuMP6/fi+X/ux8aKavzl9ksNVSN1j7PGg0I2seoSBriPiGDW2FxMGpyJpRv24lAEHx45cNKD2577FN8qHohf3DAirLs6emLtjiq8uOUgbp+UjxmjOm5SpZfUxPY9/9ePzsEP/7cUC1aU4bWFE861siVzcVS7cVlBP73LMAX+hAfol5aIh24aFdF7nm1pw7L39uGpTQ5s2uvCr2fZcZ1BgrLyRD2WrN6Jkov7YMl1w/Uu54LGX9wHj88Zi1uf+xQ/f20X/nDzGI7iTKahuRVVdWfZxKqLevUcuFEkxcfi368dhtfvnIgB1kQsWFlmiEOcPU2tWLCyDCkJsVh2SzHiY43/4/K1IVm45+qhWLPtKF769JDe5VA3Oc/1QOEUWFcY/29kL2K3WfG3OybivunDdT/EWSmFJWs+g9PXpGqANSniNfTUXVcNxpShWfjl2nLsPFKrdznUDc4abiHsDga4wcTFxmDB1wvx9qKvYfgAi24Nnf53y0G8saMKP7lmGCYMDq1JVaTFxAge+85YZKUnYsGKMva/MRE2seoeBrhBFWSlYdX8y790iPPzH0Vmn3rZodN48M1yXD08GwumFIb9fuHQJzUBT84tRnX9WSz+v+1shGUSDjax6hYGuIH5D3Fef+8UXJrfF78819ApfPvUT3macefKMgywJmHpzdo3qYqksRdl4L++Ycc/Pnfhyff36V0OdYHT5WYPlG5ggJtAbkYynv+3S/Dod744xHnZe5WaN3Rq8yosWrUNNZ5mLJ87HtaUeE2vr4d5lw3CjWNtWPruXnxYWaN3OXQB/iZW7ELYdQxwkxAR3DRuIN69dwqm2fvj9+v3an6I8xMbK/FBZQ1+OdOOolyrZtfVk4jg4W+OwpDsNNy9ahuO1TXqXRJ1gE2suo8BbjKZaYl48pZi/Pl743FSw0Oc//F5NZ54rxLfKh6IOZdcpFG1xpCSEIfl88ajqaUNC1eWobmVrWiN6NwWQk6hdBkD3KSutQ/Ahnun4NvjQz/E+cjpBtzzynYM65+OB28sisqHXwqz0vC72WNQdqgWv3mrQu9yKAiHq72JVSFH4F3GADcxa3I8fvut0Vj5/y5Di/eLQ5zrz7Z0+RpNre2j0rY2heXzxuvepCqcrh+dg+9PzMPzHx3Aup1VepdDAZwuN9LZxKpbGOBRYOLg9oZOt09qP8T52kc3d/kQ5wfXVWDHkTo88u0xyO8Fjy/ff90IFA/KwH2v7uTxbAbjcHlQwCZW3cIAjxIpCXH4xQ0jsXrBBKR28RDn17cfxV8+Poj5kwswvWhABKvVT0JcDJ6cW4zE+FjcsXIrGprZftYouIWw+xjgUaZ4UB+su3sS7r56CNbuqMLUpZuwbmfVVx7H33uiHktWf4ZL8/rip9cO06lafeRYk/HEnHGorHbj/jWf8Ug9AzjXxIrz393S4wAXkYtE5H0RqRCR3SKySMvCqOcS42Jx77SheOOuScjtk4w7X9r2pUOc3U2t+PGKrUhNjMOyW8YhzgRNqrQ2aUgm7p06FK9vr8KKjw/qXU6v98UxahyBd0cof3NbAfxEKTUCwOUAForISG3KIi2MyLFgzYIJ+NmMEV86xHnJ6p04UOPBH787DtkW8zSp0trCKwfjymFZ+NW69sMqSD/+JlacQuke0erXRxF5HcAypdSGjr6npKRElZaWanI/6p4DNR7ct3onPvFtNbxv+nAs+Lo5+5xoqbahGdc/8SEAYN1dk9An1ViHaejl/T3VePL9fWiM0IHRJ93NOFF/FhW/ms4+KEGIyFalVMlXXtciwEUkD8BmAEVKqTMBfzYfwHwAGDRo0PiDB/nrql68XoX/Kz2Mo7WNWDx1qKn7nGhp55FazF6+BVcU9sPz/3ZJr/7vcsrTjF+9sRt/216F/MzUiO7JHmmz4t5pQyN2PzMJW4CLSBqATQAeUkqtudD3cgRORrXi44P4+d92YfHUoVg0dYje5UScUgrrdh7DA2t3o66xBQuvHIw7rixEYhxHw0bQUYCHdKSaiMQDWA1gZWfhTWRkcy8bhLKDp/HYxr0YNygDkw18wLTWTpw5i5+9tgvvVpzA6IFWrPzhZRg+wKJ3WdQFoexCEQDPAqhQSi3VriSiyBMRPHTTKAzNTseiVdtQVRv9Ta+UUlj16SFMXboJH1S68LMZI7BmwQSGt4mEsgtlIoDvAbhKRLb7/pmhUV1EEZecEIvl84rR0qZwR5Q3vTp0sgFzn/kES9Z8hpE5Frxzz2T8cHJBr9xSamY9nkJRSn0IoPeu9lBUKshKw+9mj8YdK8vw8N8r8MBMu94laarNq/D8R/vx+/WfIy4mBg/fNApzLrmoVy/cmllIc+BE0WjGqBzcPikfz364H8UX98HMMTa9S9LE3hP1+OmrO7H9cC2uGp6Nh24qQo41We+yKAQMcKIgllw3HDsO12LJ6p0YmZOOwdnpepfUY82tXiz/hwPL3q9EelI8Hp8zFjPH2Ng0KgpwwosoiPjYGCy7pRgpCbH48YoyeJrM2fRqx+FafOOPH+LRd/dixqgcbFg8GbPG5jK8owQDnKgDA6xJeGLOODhdbiwxWdOrxuY2PPRmOW7600eoa2zBM7eW4PE549Avjb22owmnUIguYMLgTPzkmmF45J3PUXJxH9w2IU/vkjq1xXESS9bsxMGTDbjlskFYct1wWJLMf0A1fRUDnKgTC6YUouzgaTz4ZjlGDbSieFAfvUsK6szZFvzm73vw8qeHcHG/FLz0w8swoTBT77IojDiFQtSJmBjB0pvHor8lCXeuLMOpCxySoZeNFSdwzdLNeOVfhzB/cgHeXjSZ4d0LMMCJusCaEo/lc8ejxt2MRau2oc1rjPnwk+4m3P3yNtz+YimsyfFYc8dE/OeMEVF9til9gQFO1EWjBlrxwEw7PqiswRMbK3WtRSmF17cfxbRHN+OtXceweGr7AR5jL8rQtS6KLM6BE3XDdy+9CKUHT+GJ9yoxblAGvj4sO+I1HKtrxM9f24WNe6ox9qIM/G72aAztb9596tRzHIETdYOI4KEbR2FY/3Tc88p2HI1g0yuvV+GlTw7hmqWb8ZGjBj+/fgRWL5jA8O7FNDuRpyvYD5yixf4aD2b+8UMkxMWgb4RO8WlobsPR2kZMKOyH335zNAb1S4nIfUl/YekHTtRb5Wem4ulbS7Dik4MRfcBn0dQh+Pb4gXySkgAwwIl67IrCfriisJ/eZVAvxjlwIiKTYoATEZkUA5yIyKQY4EREJsUAJyIyKQY4EZFJMcCJiEyKAU5EZFIRfZReRFwADkbshqHJBFCjdxFhEs3vDYju98f3Zl6hvL+LlVJZgS9GNMDNRERKg/UeiAbR/N6A6H5/fG/mFY73xykUIiKTYoATEZkUA7xjT+tdQHuwXPAAAAMlSURBVBhF83sDovv98b2Zl+bvj3PgREQmxRE4EZFJMcCJiEyKAX4eEblIRN4XkQoR2S0ii/SuSWsiEisi20Rknd61aE1EMkTkVRHZ4/t/eIXeNWlFRBb7fiZ3icjLIpKkd02hEJHnRKRaRHad91pfEdkgIpW+j330rLGnOnhvj/h+LneKyGsikqHFvRjgX9YK4CdKqREALgewUERG6lyT1hYBqNC7iDB5HMDbSqnhAMYgSt6niOQCuBtAiVKqCEAsgDn6VhWyFwBMD3htCYCNSqkhADb6vjajF/DV97YBQJFSajSAvQDu1+JGDPDzKKWOKaXKfJ/Xoz0AcvWtSjsiMhDA9QCe0bsWrYmIBcBkAM8CgFKqWSlVq29VmooDkCwicQBSAFTpXE9IlFKbAZwKeHkWgBd9n78I4MaIFqWRYO9NKbVeKdXq+/JjAAO1uBcDvAMikgdgHIBP9K1EU48B+CkAr96FhEEBABeA531TRM+ISKreRWlBKXUUwO8BHAJwDECdUmq9vlWFRX+l1DGgfTAFIFvnesLlBwDe0uJCDPAgRCQNwGoA9yilzuhdjxZE5AYA1UqprXrXEiZxAIoBLFdKjQPggXl/Bf8S31zwLAD5AGwAUkVknr5VUU+IyM/QPlW7UovrMcADiEg82sN7pVJqjd71aGgigJkicgDAKgBXicgKfUvS1BEAR5RS/t+YXkV7oEeDqQD2K6VcSqkWAGsATNC5pnA4ISI5AOD7WK1zPZoSkdsA3ABgrtLoARwG+HlERNA+h1qhlFqqdz1aUkrdr5QaqJTKQ/sC2HtKqagZxSmljgM4LCLDfC9dDaBcx5K0dAjA5SKS4vsZvRpRskAbYC2A23yf3wbgdR1r0ZSITAdwH4CZSqkGra7LAP+yiQC+h/bR6XbfPzP0Loq67C4AK0VkJ4CxAB7WuR5N+H6reBVAGYDP0P731tSPnYvIywC2ABgmIkdE5HYAvwUwTUQqAUzzfW06Hby3ZQDSAWzw5cpTmtyLj9ITEZkTR+BERCbFACciMikGOBGRSTHAiYhMigFORGRSDHAiIpNigBMRmdT/B0Fwb7dFcwSTAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "c = cast\n",
    "c = c[c.name == 'Judi Dench']\n",
    "m = c.merge(us).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": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "### In which months do films with Tom Cruise tend to be released in the USA?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x9f62400>"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXAAAAD7CAYAAABzGc+QAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAANXUlEQVR4nO3dfZBd9VnA8e9DllbCu5MtfYHtth3K2DqjxR2oxWlrgRobLa3lD2Ba09a6f2gFHcdOtM7wlxqcjtpx1JkdKEWLMEJpxaJtoJg6HStNApEElkpLYxKBsLVaHGCkKY9/3BNn2Wx2N/ecs5tn8/3MZPbuuS/P7+5uvnv33LfITCRJ9Zyw0guQJA3HgEtSUQZckooy4JJUlAGXpKIMuCQVNbKcw9atW5fj4+PLOVKSytuxY8d3MnN07vZlDfj4+Djbt29fzpGSVF5E/Pt8292FIklFGXBJKsqAS1JRBlySijLgklTUogGPiE9FxFMRsXvWth+OiLsj4tHm45n9LlOSNNdSboF/Glg/Z9sm4MuZeS7w5eZzSdIyWjTgmflPwHfnbL4MuKk5fBPwno7XJUlaxLBP5DkrM58AyMwnIuJlRzphREwCkwBjY2NDjpOkY9v4pruGPu+ezRuGOl/vd2Jm5lRmTmTmxOjoYc8ElSQNadiAH4iIVwA0H5/qbkmSpKUYNuB3AhubwxuBv+1mOZKkpVrKwwhvAb4GnBcR+yPil4DNwKUR8ShwafO5JGkZLXonZmZeeYSjLu54LZKko+AzMSWpKAMuSUUZcEkqyoBLUlEGXJKKMuCSVJQBl6SiDLgkFWXAJakoAy5JRRlwSSrKgEtSUQZckooy4JJUlAGXpKIMuCQVZcAlqSgDLklFGXBJKsqAS1JRBlySijLgklSUAZekogy4JBVlwCWpKAMuSUUZcEkqyoBLUlEGXJKKMuCSVJQBl6SiDLgkFdUq4BHxGxHxUETsjohbIuKHulqYJGlhQwc8Il4FXA1MZOaPAmuAK7pamCRpYW13oYwAJ0XECLAWeLz9kiRJSzEy7Bkz8z8i4hPAXuA5YEtmbpl7uoiYBCYBxsbGhh2nVWJ8012tzr9n84YVmd1mrtSXNrtQzgQuA14DvBI4OSLeP/d0mTmVmROZOTE6Ojr8SiVJL9JmF8olwLczcyYzvw/cAbylm2VJkhbTJuB7gTdHxNqICOBiYLqbZUmSFjN0wDPzPuB24H5gV3NZUx2tS5K0iKHvxATIzGuBaztaiyTpKPhMTEkqyoBLUlEGXJKKMuCSVJQBl6SiDLgkFWXAJakoAy5JRRlwSSrKgEtSUQZckooy4JJUlAGXpKIMuCQVZcAlqSgDLklFGXBJKsqAS1JRBlySijLgklSUAZekogy4JBVlwCWpKAMuSUUZcEkqyoBLUlEGXJKKMuCSVJQBl6SiDLgkFWXAJakoAy5JRbUKeEScERG3R8QjETEdET/Z1cIkSQsbaXn+TwJfzMzLI+IlwNoO1iRJWoKhAx4RpwFvBT4IkJnPA893syxJ0mLa7EJ5LTAD3BgRD0TE9RFxckfrkiQtok3AR4Dzgb/IzDcBzwCb5p4oIiYjYntEbJ+ZmWkxTpI0W5uA7wf2Z+Z9zee3Mwj6i2TmVGZOZObE6Ohoi3GSpNmGDnhmPgnsi4jzmk0XAw93sipJ0qLaPgrl14Cbm0egPAZ8qP2SJElL0SrgmbkTmOhoLZKko+AzMSWpKAMuSUUZcEkqyoBLUlEGXJKKMuCSVJQBl6SiDLgkFWXAJakoAy5JRRlwSSrKgEtSUQZckooy4JJUlAGXpKIMuCQV1fYdeVTU+Ka7hj7vns0bOlyJpGF5C1ySijLgklSUAZekogy4JBVlwCWpKAMuSUUZcEkqyoBLUlEGXJKKMuCSVJQBl6SiDLgkFWXAJakoAy5JRRlwSSrKgEtSUa0DHhFrIuKBiPhCFwuSJC1NF7fArwGmO7gcSdJRaBXwiDgb2ABc381yJElL1fYW+J8AHwNeONIJImIyIrZHxPaZmZmW4yRJhwwd8Ij4OeCpzNyx0OkycyozJzJzYnR0dNhxkqQ52twCvwh4d0TsAW4F3hERn+lkVZKkRQ0d8Mz87cw8OzPHgSuAezPz/Z2tTJK0IB8HLklFjXRxIZm5FdjaxWVJkpbGW+CSVJQBl6SiDLgkFWXAJakoAy5JRRlwSSrKgEtSUQZckooy4JJUlAGXpKIMuCQVZcAlqSgDLklFGXBJKsqAS1JRnbweuIYzvumuVuffs3lDRytRn9p8n6t+j4/H67wSvAUuSUUZcEkqyoBLUlEGXJKKMuCSVJQBl6SiDLgkFWXAJakoAy5JRRlwSSrKgEtSUQZckooy4JJUlAGXpKIMuCQVZcAlqaihAx4R50TEP0bEdEQ8FBHXdLkwSdLC2rwjz0HgNzPz/og4FdgREXdn5sMdrU2StIChb4Fn5hOZeX9z+H+AaeBVXS1MkrSwTvaBR8Q48Cbgvi4uT5K0uNZvahwRpwCfBX49M5+e5/hJYBJgbGxswcvyjVAltXG8vVF4q1vgEXEig3jfnJl3zHeazJzKzInMnBgdHW0zTpI0S5tHoQRwAzCdmX/U3ZIkSUvR5hb4RcAHgHdExM7m37s6WpckaRFD7wPPzK8C0eFaJElHwWdiSlJRBlySijLgklSUAZekogy4JBVlwCWpKAMuSUUZcEkqyoBLUlEGXJKKMuCSVJQBl6SiDLgkFWXAJakoAy5JRbV+T8zVwPfi1Grlz/bq5i1wSSrKgEtSUQZckooy4JJUlAGXpKIMuCQVZcAlqSgDLklFGXBJKsqAS1JRBlySijLgklSUAZekogy4JBVlwCWpKAMuSUUZcEkqqlXAI2J9RHwjIr4ZEZu6WpQkaXFDBzwi1gB/Bvws8Abgyoh4Q1cLkyQtrM0t8AuAb2bmY5n5PHArcFk3y5IkLSYyc7gzRlwOrM/MjzSffwC4MDM/Oud0k8Bk8+l5wDeGXOs64DtDnretlZp9vM1dydle5+NjdtXr/OrMHJ27sc270sc82w77bZCZU8BUizmDYRHbM3Oi7eVUmn28zV3J2V7n42P2arvObXah7AfOmfX52cDj7ZYjSVqqNgHfBpwbEa+JiJcAVwB3drMsSdJiht6FkpkHI+KjwJeANcCnMvOhzlZ2uNa7YQrOPt7mruRsr/PxMXtVXeeh78SUJK0sn4kpSUUZcEkqyoBLUlFtHge+KkXEBUBm5rbmpQHWA49k5t8v8zr+MjN/cTlnNnN/isGzbHdn5paeZ10ITGfm0xFxErAJOB94GPj9zPxeT3OvBj6Xmfv6uPwF5h56tNbjmXlPRFwFvAWYBqYy8/s9z38d8F4GD/89CDwK3NLX11n9K3cnZkR8KDNv7Omyr2Xw2i4jwN3AhcBW4BLgS5n5ez3NnfvwywB+GrgXIDPf3cfcZvbXM/OC5vAvA78KfA54J/B3mbm5x9kPAT/WPKJpCngWuB24uNn+Cz3N/R7wDPAt4Bbgtsyc6WPWnLk3M/jZWgv8N3AKcAeD6xuZubHH2VcDPw98BXgXsBP4LwZB/5XM3NrXbPUoM0v9A/b2eNm7GDwkci3wNHBas/0k4MEe594PfAZ4O/C25uMTzeG39fz1fGDW4W3AaHP4ZGBXz7OnZ38N5hy3s8/rzGD34TuBG4AZ4IvARuDUHuc+2HwcAQ4Aa5rPo8+fr2bGrlnz1gJbm8Njs38Gepp9OrAZeAT4z+bfdLPtjD5nL7Cmf+j58k8D/gD4K+CqOcf9eVdzjsldKBHx4JGOAs7qcfTBzPwB8GxEfCsznwbIzOci4oUe504A1wAfB34rM3dGxHOZ+ZUeZx5yQkScySBokc0t0cx8JiIO9jx796y/qP41IiYyc3tEvB7oc3dCZuYLwBZgS0ScyOAvryuBTwCHveZER05odqOczCCipwPfBV4KnNjTzNlGgB80804FyMy9zfXv098w+Gvy7Zn5JEBEvJzBL8zbgEv7GBoR5x/pKODH+5g5y40MdlF9FvhwRLyPQcj/F3hzV0OOyYAziPTPMPgTb7YA/rnHuc9HxNrMfBb4if8fGnE60FvAm5j8cUTc1nw8wPJ9b04HdjD42mZEvDwzn4yIU5j/9W669BHgkxHxuwxe5OdrEbEP2Ncc15cXXa8c7Hu+E7iz2RfflxsY3Apdw+CX9W0R8RiD/9C39jgX4HpgW0T8C/BW4DqAiBhl8EukT+OZed3sDU3Ir4uID/c4dxuDXUbz/Ryf0eNcgNdl5vuaw5+PiI8D90ZEp7tDj8l94BFxA3BjZn51nuP+OjOv6mnuS5vfkHO3rwNekZm7+pg7z7wNwEWZ+TvLMe8Ia1gLnJWZ316GWacCr2XwS2t/Zh7oed7rM/Pf+pyxwOxXAmTm4xFxBoP7V/Zm5teXYfYbgR9hcAf1I33PmzV3C3APcNOh721EnAV8ELg0My/pae5u4L2Z+eg8x+3LzHPmOVtXs6eBNzY3zg5t2wh8DDglM1/dyZxjMeCSVo9mF90mBu8X8LJm8wEGf/Vszsy5f2l3NfdyBvfjHPYS1hHxnsz8fB9zm8v/Q2BLZt4zZ/t64E8z89xO5hhwSSulz0eVHYtzu55twCWtmIjYm5ljx8vcrmcfq3diSlolVupRZSv4aLZlm23AJfVtpR5VtlJzl222AZfUty8weOTFzrlHRMTWVTh32Wa7D1ySivLVCCWpKAMuSUUZcEkqyoBLUlEGXJKK+j+xuwVIbmbckgAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "c = cast\n",
    "c = c[c.name == 'Tom Cruise']\n",
    "m = c.merge(us).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": []
  }
 ],
 "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.8.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}