imDP.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# <center>TMDP movies Data Analysis Project</center>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Table of contents:\n",
    "- `Phase one:` Data Gathering.\n",
    "- `Phase two:` Assesing.\n",
    "- `Phase three:` Cleaning.\n",
    "- `Phase four:` Visualization and Analysis."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Phase one: Data Gathering."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import re\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Importing the dataset\n",
    "movies = pd.read_csv('tmdb-movies.csv')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Phase two: Assesing."
   ]
  },
  {
   "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>id</th>\n",
       "      <th>imdb_id</th>\n",
       "      <th>popularity</th>\n",
       "      <th>budget</th>\n",
       "      <th>revenue</th>\n",
       "      <th>original_title</th>\n",
       "      <th>cast</th>\n",
       "      <th>homepage</th>\n",
       "      <th>director</th>\n",
       "      <th>tagline</th>\n",
       "      <th>...</th>\n",
       "      <th>overview</th>\n",
       "      <th>runtime</th>\n",
       "      <th>genres</th>\n",
       "      <th>production_companies</th>\n",
       "      <th>release_date</th>\n",
       "      <th>vote_count</th>\n",
       "      <th>vote_average</th>\n",
       "      <th>release_year</th>\n",
       "      <th>budget_adj</th>\n",
       "      <th>revenue_adj</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>135397</td>\n",
       "      <td>tt0369610</td>\n",
       "      <td>32.985763</td>\n",
       "      <td>150000000</td>\n",
       "      <td>1513528810</td>\n",
       "      <td>Jurassic World</td>\n",
       "      <td>Chris Pratt|Bryce Dallas Howard|Irrfan Khan|Vi...</td>\n",
       "      <td>http://www.jurassicworld.com/</td>\n",
       "      <td>Colin Trevorrow</td>\n",
       "      <td>The park is open.</td>\n",
       "      <td>...</td>\n",
       "      <td>Twenty-two years after the events of Jurassic ...</td>\n",
       "      <td>124</td>\n",
       "      <td>Action|Adventure|Science Fiction|Thriller</td>\n",
       "      <td>Universal Studios|Amblin Entertainment|Legenda...</td>\n",
       "      <td>6/9/15</td>\n",
       "      <td>5562</td>\n",
       "      <td>6.5</td>\n",
       "      <td>2015</td>\n",
       "      <td>1.379999e+08</td>\n",
       "      <td>1.392446e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>76341</td>\n",
       "      <td>tt1392190</td>\n",
       "      <td>28.419936</td>\n",
       "      <td>150000000</td>\n",
       "      <td>378436354</td>\n",
       "      <td>Mad Max: Fury Road</td>\n",
       "      <td>Tom Hardy|Charlize Theron|Hugh Keays-Byrne|Nic...</td>\n",
       "      <td>http://www.madmaxmovie.com/</td>\n",
       "      <td>George Miller</td>\n",
       "      <td>What a Lovely Day.</td>\n",
       "      <td>...</td>\n",
       "      <td>An apocalyptic story set in the furthest reach...</td>\n",
       "      <td>120</td>\n",
       "      <td>Action|Adventure|Science Fiction|Thriller</td>\n",
       "      <td>Village Roadshow Pictures|Kennedy Miller Produ...</td>\n",
       "      <td>5/13/15</td>\n",
       "      <td>6185</td>\n",
       "      <td>7.1</td>\n",
       "      <td>2015</td>\n",
       "      <td>1.379999e+08</td>\n",
       "      <td>3.481613e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>262500</td>\n",
       "      <td>tt2908446</td>\n",
       "      <td>13.112507</td>\n",
       "      <td>110000000</td>\n",
       "      <td>295238201</td>\n",
       "      <td>Insurgent</td>\n",
       "      <td>Shailene Woodley|Theo James|Kate Winslet|Ansel...</td>\n",
       "      <td>http://www.thedivergentseries.movie/#insurgent</td>\n",
       "      <td>Robert Schwentke</td>\n",
       "      <td>One Choice Can Destroy You</td>\n",
       "      <td>...</td>\n",
       "      <td>Beatrice Prior must confront her inner demons ...</td>\n",
       "      <td>119</td>\n",
       "      <td>Adventure|Science Fiction|Thriller</td>\n",
       "      <td>Summit Entertainment|Mandeville Films|Red Wago...</td>\n",
       "      <td>3/18/15</td>\n",
       "      <td>2480</td>\n",
       "      <td>6.3</td>\n",
       "      <td>2015</td>\n",
       "      <td>1.012000e+08</td>\n",
       "      <td>2.716190e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>140607</td>\n",
       "      <td>tt2488496</td>\n",
       "      <td>11.173104</td>\n",
       "      <td>200000000</td>\n",
       "      <td>2068178225</td>\n",
       "      <td>Star Wars: The Force Awakens</td>\n",
       "      <td>Harrison Ford|Mark Hamill|Carrie Fisher|Adam D...</td>\n",
       "      <td>http://www.starwars.com/films/star-wars-episod...</td>\n",
       "      <td>J.J. Abrams</td>\n",
       "      <td>Every generation has a story.</td>\n",
       "      <td>...</td>\n",
       "      <td>Thirty years after defeating the Galactic Empi...</td>\n",
       "      <td>136</td>\n",
       "      <td>Action|Adventure|Science Fiction|Fantasy</td>\n",
       "      <td>Lucasfilm|Truenorth Productions|Bad Robot</td>\n",
       "      <td>12/15/15</td>\n",
       "      <td>5292</td>\n",
       "      <td>7.5</td>\n",
       "      <td>2015</td>\n",
       "      <td>1.839999e+08</td>\n",
       "      <td>1.902723e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>168259</td>\n",
       "      <td>tt2820852</td>\n",
       "      <td>9.335014</td>\n",
       "      <td>190000000</td>\n",
       "      <td>1506249360</td>\n",
       "      <td>Furious 7</td>\n",
       "      <td>Vin Diesel|Paul Walker|Jason Statham|Michelle ...</td>\n",
       "      <td>http://www.furious7.com/</td>\n",
       "      <td>James Wan</td>\n",
       "      <td>Vengeance Hits Home</td>\n",
       "      <td>...</td>\n",
       "      <td>Deckard Shaw seeks revenge against Dominic Tor...</td>\n",
       "      <td>137</td>\n",
       "      <td>Action|Crime|Thriller</td>\n",
       "      <td>Universal Pictures|Original Film|Media Rights ...</td>\n",
       "      <td>4/1/15</td>\n",
       "      <td>2947</td>\n",
       "      <td>7.3</td>\n",
       "      <td>2015</td>\n",
       "      <td>1.747999e+08</td>\n",
       "      <td>1.385749e+09</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       id    imdb_id  popularity     budget     revenue  \\\n",
       "0  135397  tt0369610   32.985763  150000000  1513528810   \n",
       "1   76341  tt1392190   28.419936  150000000   378436354   \n",
       "2  262500  tt2908446   13.112507  110000000   295238201   \n",
       "3  140607  tt2488496   11.173104  200000000  2068178225   \n",
       "4  168259  tt2820852    9.335014  190000000  1506249360   \n",
       "\n",
       "                 original_title  \\\n",
       "0                Jurassic World   \n",
       "1            Mad Max: Fury Road   \n",
       "2                     Insurgent   \n",
       "3  Star Wars: The Force Awakens   \n",
       "4                     Furious 7   \n",
       "\n",
       "                                                cast  \\\n",
       "0  Chris Pratt|Bryce Dallas Howard|Irrfan Khan|Vi...   \n",
       "1  Tom Hardy|Charlize Theron|Hugh Keays-Byrne|Nic...   \n",
       "2  Shailene Woodley|Theo James|Kate Winslet|Ansel...   \n",
       "3  Harrison Ford|Mark Hamill|Carrie Fisher|Adam D...   \n",
       "4  Vin Diesel|Paul Walker|Jason Statham|Michelle ...   \n",
       "\n",
       "                                            homepage          director  \\\n",
       "0                      http://www.jurassicworld.com/   Colin Trevorrow   \n",
       "1                        http://www.madmaxmovie.com/     George Miller   \n",
       "2     http://www.thedivergentseries.movie/#insurgent  Robert Schwentke   \n",
       "3  http://www.starwars.com/films/star-wars-episod...       J.J. Abrams   \n",
       "4                           http://www.furious7.com/         James Wan   \n",
       "\n",
       "                         tagline  ...  \\\n",
       "0              The park is open.  ...   \n",
       "1             What a Lovely Day.  ...   \n",
       "2     One Choice Can Destroy You  ...   \n",
       "3  Every generation has a story.  ...   \n",
       "4            Vengeance Hits Home  ...   \n",
       "\n",
       "                                            overview runtime  \\\n",
       "0  Twenty-two years after the events of Jurassic ...     124   \n",
       "1  An apocalyptic story set in the furthest reach...     120   \n",
       "2  Beatrice Prior must confront her inner demons ...     119   \n",
       "3  Thirty years after defeating the Galactic Empi...     136   \n",
       "4  Deckard Shaw seeks revenge against Dominic Tor...     137   \n",
       "\n",
       "                                      genres  \\\n",
       "0  Action|Adventure|Science Fiction|Thriller   \n",
       "1  Action|Adventure|Science Fiction|Thriller   \n",
       "2         Adventure|Science Fiction|Thriller   \n",
       "3   Action|Adventure|Science Fiction|Fantasy   \n",
       "4                      Action|Crime|Thriller   \n",
       "\n",
       "                                production_companies release_date vote_count  \\\n",
       "0  Universal Studios|Amblin Entertainment|Legenda...       6/9/15       5562   \n",
       "1  Village Roadshow Pictures|Kennedy Miller Produ...      5/13/15       6185   \n",
       "2  Summit Entertainment|Mandeville Films|Red Wago...      3/18/15       2480   \n",
       "3          Lucasfilm|Truenorth Productions|Bad Robot     12/15/15       5292   \n",
       "4  Universal Pictures|Original Film|Media Rights ...       4/1/15       2947   \n",
       "\n",
       "   vote_average  release_year    budget_adj   revenue_adj  \n",
       "0           6.5          2015  1.379999e+08  1.392446e+09  \n",
       "1           7.1          2015  1.379999e+08  3.481613e+08  \n",
       "2           6.3          2015  1.012000e+08  2.716190e+08  \n",
       "3           7.5          2015  1.839999e+08  1.902723e+09  \n",
       "4           7.3          2015  1.747999e+08  1.385749e+09  \n",
       "\n",
       "[5 rows x 21 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Checking the first few values of the dataset.\n",
    "movies.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>id</th>\n",
       "      <th>imdb_id</th>\n",
       "      <th>popularity</th>\n",
       "      <th>budget</th>\n",
       "      <th>revenue</th>\n",
       "      <th>original_title</th>\n",
       "      <th>cast</th>\n",
       "      <th>homepage</th>\n",
       "      <th>director</th>\n",
       "      <th>tagline</th>\n",
       "      <th>...</th>\n",
       "      <th>overview</th>\n",
       "      <th>runtime</th>\n",
       "      <th>genres</th>\n",
       "      <th>production_companies</th>\n",
       "      <th>release_date</th>\n",
       "      <th>vote_count</th>\n",
       "      <th>vote_average</th>\n",
       "      <th>release_year</th>\n",
       "      <th>budget_adj</th>\n",
       "      <th>revenue_adj</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>10861</th>\n",
       "      <td>21</td>\n",
       "      <td>tt0060371</td>\n",
       "      <td>0.080598</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>The Endless Summer</td>\n",
       "      <td>Michael Hynson|Robert August|Lord 'Tally Ho' B...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bruce Brown</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>The Endless Summer, by Bruce Brown, is one of ...</td>\n",
       "      <td>95</td>\n",
       "      <td>Documentary</td>\n",
       "      <td>Bruce Brown Films</td>\n",
       "      <td>6/15/66</td>\n",
       "      <td>11</td>\n",
       "      <td>7.4</td>\n",
       "      <td>1966</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10862</th>\n",
       "      <td>20379</td>\n",
       "      <td>tt0060472</td>\n",
       "      <td>0.065543</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Grand Prix</td>\n",
       "      <td>James Garner|Eva Marie Saint|Yves Montand|Tosh...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>John Frankenheimer</td>\n",
       "      <td>Cinerama sweeps YOU into a drama of speed and ...</td>\n",
       "      <td>...</td>\n",
       "      <td>Grand Prix driver Pete Aron is fired by his te...</td>\n",
       "      <td>176</td>\n",
       "      <td>Action|Adventure|Drama</td>\n",
       "      <td>Cherokee Productions|Joel Productions|Douglas ...</td>\n",
       "      <td>12/21/66</td>\n",
       "      <td>20</td>\n",
       "      <td>5.7</td>\n",
       "      <td>1966</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10863</th>\n",
       "      <td>39768</td>\n",
       "      <td>tt0060161</td>\n",
       "      <td>0.065141</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Beregis Avtomobilya</td>\n",
       "      <td>Innokentiy Smoktunovskiy|Oleg Efremov|Georgi Z...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Eldar Ryazanov</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>An insurance agent who moonlights as a carthie...</td>\n",
       "      <td>94</td>\n",
       "      <td>Mystery|Comedy</td>\n",
       "      <td>Mosfilm</td>\n",
       "      <td>1/1/66</td>\n",
       "      <td>11</td>\n",
       "      <td>6.5</td>\n",
       "      <td>1966</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10864</th>\n",
       "      <td>21449</td>\n",
       "      <td>tt0061177</td>\n",
       "      <td>0.064317</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>What's Up, Tiger Lily?</td>\n",
       "      <td>Tatsuya Mihashi|Akiko Wakabayashi|Mie Hama|Joh...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Woody Allen</td>\n",
       "      <td>WOODY ALLEN STRIKES BACK!</td>\n",
       "      <td>...</td>\n",
       "      <td>In comic Woody Allen's film debut, he took the...</td>\n",
       "      <td>80</td>\n",
       "      <td>Action|Comedy</td>\n",
       "      <td>Benedict Pictures Corp.</td>\n",
       "      <td>11/2/66</td>\n",
       "      <td>22</td>\n",
       "      <td>5.4</td>\n",
       "      <td>1966</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10865</th>\n",
       "      <td>22293</td>\n",
       "      <td>tt0060666</td>\n",
       "      <td>0.035919</td>\n",
       "      <td>19000</td>\n",
       "      <td>0</td>\n",
       "      <td>Manos: The Hands of Fate</td>\n",
       "      <td>Harold P. Warren|Tom Neyman|John Reynolds|Dian...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Harold P. Warren</td>\n",
       "      <td>It's Shocking! It's Beyond Your Imagination!</td>\n",
       "      <td>...</td>\n",
       "      <td>A family gets lost on the road and stumbles up...</td>\n",
       "      <td>74</td>\n",
       "      <td>Horror</td>\n",
       "      <td>Norm-Iris</td>\n",
       "      <td>11/15/66</td>\n",
       "      <td>15</td>\n",
       "      <td>1.5</td>\n",
       "      <td>1966</td>\n",
       "      <td>127642.279154</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          id    imdb_id  popularity  budget  revenue  \\\n",
       "10861     21  tt0060371    0.080598       0        0   \n",
       "10862  20379  tt0060472    0.065543       0        0   \n",
       "10863  39768  tt0060161    0.065141       0        0   \n",
       "10864  21449  tt0061177    0.064317       0        0   \n",
       "10865  22293  tt0060666    0.035919   19000        0   \n",
       "\n",
       "                 original_title  \\\n",
       "10861        The Endless Summer   \n",
       "10862                Grand Prix   \n",
       "10863       Beregis Avtomobilya   \n",
       "10864    What's Up, Tiger Lily?   \n",
       "10865  Manos: The Hands of Fate   \n",
       "\n",
       "                                                    cast homepage  \\\n",
       "10861  Michael Hynson|Robert August|Lord 'Tally Ho' B...      NaN   \n",
       "10862  James Garner|Eva Marie Saint|Yves Montand|Tosh...      NaN   \n",
       "10863  Innokentiy Smoktunovskiy|Oleg Efremov|Georgi Z...      NaN   \n",
       "10864  Tatsuya Mihashi|Akiko Wakabayashi|Mie Hama|Joh...      NaN   \n",
       "10865  Harold P. Warren|Tom Neyman|John Reynolds|Dian...      NaN   \n",
       "\n",
       "                 director                                            tagline  \\\n",
       "10861         Bruce Brown                                                NaN   \n",
       "10862  John Frankenheimer  Cinerama sweeps YOU into a drama of speed and ...   \n",
       "10863      Eldar Ryazanov                                                NaN   \n",
       "10864         Woody Allen                          WOODY ALLEN STRIKES BACK!   \n",
       "10865    Harold P. Warren       It's Shocking! It's Beyond Your Imagination!   \n",
       "\n",
       "       ...                                           overview runtime  \\\n",
       "10861  ...  The Endless Summer, by Bruce Brown, is one of ...      95   \n",
       "10862  ...  Grand Prix driver Pete Aron is fired by his te...     176   \n",
       "10863  ...  An insurance agent who moonlights as a carthie...      94   \n",
       "10864  ...  In comic Woody Allen's film debut, he took the...      80   \n",
       "10865  ...  A family gets lost on the road and stumbles up...      74   \n",
       "\n",
       "                       genres  \\\n",
       "10861             Documentary   \n",
       "10862  Action|Adventure|Drama   \n",
       "10863          Mystery|Comedy   \n",
       "10864           Action|Comedy   \n",
       "10865                  Horror   \n",
       "\n",
       "                                    production_companies release_date  \\\n",
       "10861                                  Bruce Brown Films      6/15/66   \n",
       "10862  Cherokee Productions|Joel Productions|Douglas ...     12/21/66   \n",
       "10863                                            Mosfilm       1/1/66   \n",
       "10864                            Benedict Pictures Corp.      11/2/66   \n",
       "10865                                          Norm-Iris     11/15/66   \n",
       "\n",
       "      vote_count  vote_average  release_year     budget_adj  revenue_adj  \n",
       "10861         11           7.4          1966       0.000000          0.0  \n",
       "10862         20           5.7          1966       0.000000          0.0  \n",
       "10863         11           6.5          1966       0.000000          0.0  \n",
       "10864         22           5.4          1966       0.000000          0.0  \n",
       "10865         15           1.5          1966  127642.279154          0.0  \n",
       "\n",
       "[5 rows x 21 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Checking the last few values of the dataset.\n",
    "movies.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 10866 entries, 0 to 10865\n",
      "Data columns (total 21 columns):\n",
      " #   Column                Non-Null Count  Dtype  \n",
      "---  ------                --------------  -----  \n",
      " 0   id                    10866 non-null  int64  \n",
      " 1   imdb_id               10856 non-null  object \n",
      " 2   popularity            10866 non-null  float64\n",
      " 3   budget                10866 non-null  int64  \n",
      " 4   revenue               10866 non-null  int64  \n",
      " 5   original_title        10866 non-null  object \n",
      " 6   cast                  10790 non-null  object \n",
      " 7   homepage              2936 non-null   object \n",
      " 8   director              10822 non-null  object \n",
      " 9   tagline               8042 non-null   object \n",
      " 10  keywords              9373 non-null   object \n",
      " 11  overview              10862 non-null  object \n",
      " 12  runtime               10866 non-null  int64  \n",
      " 13  genres                10843 non-null  object \n",
      " 14  production_companies  9836 non-null   object \n",
      " 15  release_date          10866 non-null  object \n",
      " 16  vote_count            10866 non-null  int64  \n",
      " 17  vote_average          10866 non-null  float64\n",
      " 18  release_year          10866 non-null  int64  \n",
      " 19  budget_adj            10866 non-null  float64\n",
      " 20  revenue_adj           10866 non-null  float64\n",
      "dtypes: float64(4), int64(6), object(11)\n",
      "memory usage: 1.7+ MB\n"
     ]
    }
   ],
   "source": [
    "# Checking for missing values and datatypes.\n",
    "movies.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>popularity</th>\n",
       "      <th>budget</th>\n",
       "      <th>revenue</th>\n",
       "      <th>runtime</th>\n",
       "      <th>vote_count</th>\n",
       "      <th>vote_average</th>\n",
       "      <th>release_year</th>\n",
       "      <th>budget_adj</th>\n",
       "      <th>revenue_adj</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>10866.000000</td>\n",
       "      <td>10866.000000</td>\n",
       "      <td>1.086600e+04</td>\n",
       "      <td>1.086600e+04</td>\n",
       "      <td>10866.000000</td>\n",
       "      <td>10866.000000</td>\n",
       "      <td>10866.000000</td>\n",
       "      <td>10866.000000</td>\n",
       "      <td>1.086600e+04</td>\n",
       "      <td>1.086600e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>66064.177434</td>\n",
       "      <td>0.646441</td>\n",
       "      <td>1.462570e+07</td>\n",
       "      <td>3.982332e+07</td>\n",
       "      <td>102.070863</td>\n",
       "      <td>217.389748</td>\n",
       "      <td>5.974922</td>\n",
       "      <td>2001.322658</td>\n",
       "      <td>1.755104e+07</td>\n",
       "      <td>5.136436e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>92130.136561</td>\n",
       "      <td>1.000185</td>\n",
       "      <td>3.091321e+07</td>\n",
       "      <td>1.170035e+08</td>\n",
       "      <td>31.381405</td>\n",
       "      <td>575.619058</td>\n",
       "      <td>0.935142</td>\n",
       "      <td>12.812941</td>\n",
       "      <td>3.430616e+07</td>\n",
       "      <td>1.446325e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>5.000000</td>\n",
       "      <td>0.000065</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>1960.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>10596.250000</td>\n",
       "      <td>0.207583</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>90.000000</td>\n",
       "      <td>17.000000</td>\n",
       "      <td>5.400000</td>\n",
       "      <td>1995.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>20669.000000</td>\n",
       "      <td>0.383856</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>99.000000</td>\n",
       "      <td>38.000000</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>2006.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>75610.000000</td>\n",
       "      <td>0.713817</td>\n",
       "      <td>1.500000e+07</td>\n",
       "      <td>2.400000e+07</td>\n",
       "      <td>111.000000</td>\n",
       "      <td>145.750000</td>\n",
       "      <td>6.600000</td>\n",
       "      <td>2011.000000</td>\n",
       "      <td>2.085325e+07</td>\n",
       "      <td>3.369710e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>417859.000000</td>\n",
       "      <td>32.985763</td>\n",
       "      <td>4.250000e+08</td>\n",
       "      <td>2.781506e+09</td>\n",
       "      <td>900.000000</td>\n",
       "      <td>9767.000000</td>\n",
       "      <td>9.200000</td>\n",
       "      <td>2015.000000</td>\n",
       "      <td>4.250000e+08</td>\n",
       "      <td>2.827124e+09</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  id    popularity        budget       revenue       runtime  \\\n",
       "count   10866.000000  10866.000000  1.086600e+04  1.086600e+04  10866.000000   \n",
       "mean    66064.177434      0.646441  1.462570e+07  3.982332e+07    102.070863   \n",
       "std     92130.136561      1.000185  3.091321e+07  1.170035e+08     31.381405   \n",
       "min         5.000000      0.000065  0.000000e+00  0.000000e+00      0.000000   \n",
       "25%     10596.250000      0.207583  0.000000e+00  0.000000e+00     90.000000   \n",
       "50%     20669.000000      0.383856  0.000000e+00  0.000000e+00     99.000000   \n",
       "75%     75610.000000      0.713817  1.500000e+07  2.400000e+07    111.000000   \n",
       "max    417859.000000     32.985763  4.250000e+08  2.781506e+09    900.000000   \n",
       "\n",
       "         vote_count  vote_average  release_year    budget_adj   revenue_adj  \n",
       "count  10866.000000  10866.000000  10866.000000  1.086600e+04  1.086600e+04  \n",
       "mean     217.389748      5.974922   2001.322658  1.755104e+07  5.136436e+07  \n",
       "std      575.619058      0.935142     12.812941  3.430616e+07  1.446325e+08  \n",
       "min       10.000000      1.500000   1960.000000  0.000000e+00  0.000000e+00  \n",
       "25%       17.000000      5.400000   1995.000000  0.000000e+00  0.000000e+00  \n",
       "50%       38.000000      6.000000   2006.000000  0.000000e+00  0.000000e+00  \n",
       "75%      145.750000      6.600000   2011.000000  2.085325e+07  3.369710e+07  \n",
       "max     9767.000000      9.200000   2015.000000  4.250000e+08  2.827124e+09  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Checking for max values, min values, mean values and count\n",
    "movies.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>id</th>\n",
       "      <th>imdb_id</th>\n",
       "      <th>popularity</th>\n",
       "      <th>budget</th>\n",
       "      <th>revenue</th>\n",
       "      <th>original_title</th>\n",
       "      <th>cast</th>\n",
       "      <th>homepage</th>\n",
       "      <th>director</th>\n",
       "      <th>tagline</th>\n",
       "      <th>...</th>\n",
       "      <th>overview</th>\n",
       "      <th>runtime</th>\n",
       "      <th>genres</th>\n",
       "      <th>production_companies</th>\n",
       "      <th>release_date</th>\n",
       "      <th>vote_count</th>\n",
       "      <th>vote_average</th>\n",
       "      <th>release_year</th>\n",
       "      <th>budget_adj</th>\n",
       "      <th>revenue_adj</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2090</th>\n",
       "      <td>42194</td>\n",
       "      <td>tt0411951</td>\n",
       "      <td>0.59643</td>\n",
       "      <td>30000000</td>\n",
       "      <td>967000</td>\n",
       "      <td>TEKKEN</td>\n",
       "      <td>Jon Foo|Kelly Overton|Cary-Hiroyuki Tagawa|Ian...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Dwight H. Little</td>\n",
       "      <td>Survival is no game</td>\n",
       "      <td>...</td>\n",
       "      <td>In the year of 2039, after World Wars destroy ...</td>\n",
       "      <td>92</td>\n",
       "      <td>Crime|Drama|Action|Thriller|Science Fiction</td>\n",
       "      <td>Namco|Light Song Films</td>\n",
       "      <td>3/20/10</td>\n",
       "      <td>110</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2010</td>\n",
       "      <td>30000000.0</td>\n",
       "      <td>967000.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         id    imdb_id  popularity    budget  revenue original_title  \\\n",
       "2090  42194  tt0411951     0.59643  30000000   967000         TEKKEN   \n",
       "\n",
       "                                                   cast homepage  \\\n",
       "2090  Jon Foo|Kelly Overton|Cary-Hiroyuki Tagawa|Ian...      NaN   \n",
       "\n",
       "              director              tagline  ...  \\\n",
       "2090  Dwight H. Little  Survival is no game  ...   \n",
       "\n",
       "                                               overview runtime  \\\n",
       "2090  In the year of 2039, after World Wars destroy ...      92   \n",
       "\n",
       "                                           genres    production_companies  \\\n",
       "2090  Crime|Drama|Action|Thriller|Science Fiction  Namco|Light Song Films   \n",
       "\n",
       "     release_date vote_count  vote_average  release_year  budget_adj  \\\n",
       "2090      3/20/10        110           5.0          2010  30000000.0   \n",
       "\n",
       "      revenue_adj  \n",
       "2090     967000.0  \n",
       "\n",
       "[1 rows x 21 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Checking for duplicated values.\n",
    "movies[movies.duplicated()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['id', 'imdb_id', 'popularity', 'budget', 'revenue', 'original_title',\n",
       "       'cast', 'homepage', 'director', 'tagline', 'keywords', 'overview',\n",
       "       'runtime', 'genres', 'production_companies', 'release_date',\n",
       "       'vote_count', 'vote_average', 'release_year', 'budget_adj',\n",
       "       'revenue_adj'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Checking for column names.\n",
    "movies.columns"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### <font color='Purple'>Quality</font>\n",
    "\n",
    "#### <font color='Grey'>Accuracy issues:</font>\n",
    "- Budget of the movie title \"The Warrior's Way\" is wrong. (42,000,000 instead of 425,000,000)\n",
    "\n",
    "#### <font color='Grey'>Consistensy issues:</font>\n",
    "- Duplicated rows with ID = 42194\n",
    "- Date need to be edited and corrected.\n",
    "- Change release year type to string\n",
    "- Change release date time to datetime\n",
    "\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### <font color='Purple'>Tidiness</font>\n",
    "- Drop the columns ['release_year', 'budget_adj', 'revenue_adj']\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Phase three: Cleaning."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Creating a copy of the movies dataframe**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "movies_clean = movies.copy()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**fixing the budget number of the movie id 46528**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "movies_clean.loc[movies_clean.id == 46528, 'budget'] = 45000000"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Changing release year type**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "movies_clean['release_year'] = movies_clean['release_year'].astype('str')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dtype('O')"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies_clean['release_year'].dtype"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**fixing date**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "def replaceYear(row):\n",
    "    pattern = '(^\\d+/\\d+/)'\n",
    "    year = re.findall(pattern, row.loc['release_date'])[0] + row.loc['release_year']\n",
    "    return year"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "movies_clean['release_date'] = movies_clean.apply(replaceYear, axis = 1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0          6/9/2015\n",
       "1         5/13/2015\n",
       "2         3/18/2015\n",
       "3        12/15/2015\n",
       "4          4/1/2015\n",
       "            ...    \n",
       "10861     6/15/1966\n",
       "10862    12/21/1966\n",
       "10863      1/1/1966\n",
       "10864     11/2/1966\n",
       "10865    11/15/1966\n",
       "Name: release_date, Length: 10866, dtype: object"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies_clean['release_date'] "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "movies_clean.drop(columns=['release_year', 'budget_adj','revenue_adj'], inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "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>id</th>\n",
       "      <th>imdb_id</th>\n",
       "      <th>popularity</th>\n",
       "      <th>budget</th>\n",
       "      <th>revenue</th>\n",
       "      <th>original_title</th>\n",
       "      <th>cast</th>\n",
       "      <th>homepage</th>\n",
       "      <th>director</th>\n",
       "      <th>tagline</th>\n",
       "      <th>keywords</th>\n",
       "      <th>overview</th>\n",
       "      <th>runtime</th>\n",
       "      <th>genres</th>\n",
       "      <th>production_companies</th>\n",
       "      <th>release_date</th>\n",
       "      <th>vote_count</th>\n",
       "      <th>vote_average</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>135397</td>\n",
       "      <td>tt0369610</td>\n",
       "      <td>32.985763</td>\n",
       "      <td>150000000</td>\n",
       "      <td>1513528810</td>\n",
       "      <td>Jurassic World</td>\n",
       "      <td>Chris Pratt|Bryce Dallas Howard|Irrfan Khan|Vi...</td>\n",
       "      <td>http://www.jurassicworld.com/</td>\n",
       "      <td>Colin Trevorrow</td>\n",
       "      <td>The park is open.</td>\n",
       "      <td>monster|dna|tyrannosaurus rex|velociraptor|island</td>\n",
       "      <td>Twenty-two years after the events of Jurassic ...</td>\n",
       "      <td>124</td>\n",
       "      <td>Action|Adventure|Science Fiction|Thriller</td>\n",
       "      <td>Universal Studios|Amblin Entertainment|Legenda...</td>\n",
       "      <td>6/9/2015</td>\n",
       "      <td>5562</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>76341</td>\n",
       "      <td>tt1392190</td>\n",
       "      <td>28.419936</td>\n",
       "      <td>150000000</td>\n",
       "      <td>378436354</td>\n",
       "      <td>Mad Max: Fury Road</td>\n",
       "      <td>Tom Hardy|Charlize Theron|Hugh Keays-Byrne|Nic...</td>\n",
       "      <td>http://www.madmaxmovie.com/</td>\n",
       "      <td>George Miller</td>\n",
       "      <td>What a Lovely Day.</td>\n",
       "      <td>future|chase|post-apocalyptic|dystopia|australia</td>\n",
       "      <td>An apocalyptic story set in the furthest reach...</td>\n",
       "      <td>120</td>\n",
       "      <td>Action|Adventure|Science Fiction|Thriller</td>\n",
       "      <td>Village Roadshow Pictures|Kennedy Miller Produ...</td>\n",
       "      <td>5/13/2015</td>\n",
       "      <td>6185</td>\n",
       "      <td>7.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>262500</td>\n",
       "      <td>tt2908446</td>\n",
       "      <td>13.112507</td>\n",
       "      <td>110000000</td>\n",
       "      <td>295238201</td>\n",
       "      <td>Insurgent</td>\n",
       "      <td>Shailene Woodley|Theo James|Kate Winslet|Ansel...</td>\n",
       "      <td>http://www.thedivergentseries.movie/#insurgent</td>\n",
       "      <td>Robert Schwentke</td>\n",
       "      <td>One Choice Can Destroy You</td>\n",
       "      <td>based on novel|revolution|dystopia|sequel|dyst...</td>\n",
       "      <td>Beatrice Prior must confront her inner demons ...</td>\n",
       "      <td>119</td>\n",
       "      <td>Adventure|Science Fiction|Thriller</td>\n",
       "      <td>Summit Entertainment|Mandeville Films|Red Wago...</td>\n",
       "      <td>3/18/2015</td>\n",
       "      <td>2480</td>\n",
       "      <td>6.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>140607</td>\n",
       "      <td>tt2488496</td>\n",
       "      <td>11.173104</td>\n",
       "      <td>200000000</td>\n",
       "      <td>2068178225</td>\n",
       "      <td>Star Wars: The Force Awakens</td>\n",
       "      <td>Harrison Ford|Mark Hamill|Carrie Fisher|Adam D...</td>\n",
       "      <td>http://www.starwars.com/films/star-wars-episod...</td>\n",
       "      <td>J.J. Abrams</td>\n",
       "      <td>Every generation has a story.</td>\n",
       "      <td>android|spaceship|jedi|space opera|3d</td>\n",
       "      <td>Thirty years after defeating the Galactic Empi...</td>\n",
       "      <td>136</td>\n",
       "      <td>Action|Adventure|Science Fiction|Fantasy</td>\n",
       "      <td>Lucasfilm|Truenorth Productions|Bad Robot</td>\n",
       "      <td>12/15/2015</td>\n",
       "      <td>5292</td>\n",
       "      <td>7.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>168259</td>\n",
       "      <td>tt2820852</td>\n",
       "      <td>9.335014</td>\n",
       "      <td>190000000</td>\n",
       "      <td>1506249360</td>\n",
       "      <td>Furious 7</td>\n",
       "      <td>Vin Diesel|Paul Walker|Jason Statham|Michelle ...</td>\n",
       "      <td>http://www.furious7.com/</td>\n",
       "      <td>James Wan</td>\n",
       "      <td>Vengeance Hits Home</td>\n",
       "      <td>car race|speed|revenge|suspense|car</td>\n",
       "      <td>Deckard Shaw seeks revenge against Dominic Tor...</td>\n",
       "      <td>137</td>\n",
       "      <td>Action|Crime|Thriller</td>\n",
       "      <td>Universal Pictures|Original Film|Media Rights ...</td>\n",
       "      <td>4/1/2015</td>\n",
       "      <td>2947</td>\n",
       "      <td>7.3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       id    imdb_id  popularity     budget     revenue  \\\n",
       "0  135397  tt0369610   32.985763  150000000  1513528810   \n",
       "1   76341  tt1392190   28.419936  150000000   378436354   \n",
       "2  262500  tt2908446   13.112507  110000000   295238201   \n",
       "3  140607  tt2488496   11.173104  200000000  2068178225   \n",
       "4  168259  tt2820852    9.335014  190000000  1506249360   \n",
       "\n",
       "                 original_title  \\\n",
       "0                Jurassic World   \n",
       "1            Mad Max: Fury Road   \n",
       "2                     Insurgent   \n",
       "3  Star Wars: The Force Awakens   \n",
       "4                     Furious 7   \n",
       "\n",
       "                                                cast  \\\n",
       "0  Chris Pratt|Bryce Dallas Howard|Irrfan Khan|Vi...   \n",
       "1  Tom Hardy|Charlize Theron|Hugh Keays-Byrne|Nic...   \n",
       "2  Shailene Woodley|Theo James|Kate Winslet|Ansel...   \n",
       "3  Harrison Ford|Mark Hamill|Carrie Fisher|Adam D...   \n",
       "4  Vin Diesel|Paul Walker|Jason Statham|Michelle ...   \n",
       "\n",
       "                                            homepage          director  \\\n",
       "0                      http://www.jurassicworld.com/   Colin Trevorrow   \n",
       "1                        http://www.madmaxmovie.com/     George Miller   \n",
       "2     http://www.thedivergentseries.movie/#insurgent  Robert Schwentke   \n",
       "3  http://www.starwars.com/films/star-wars-episod...       J.J. Abrams   \n",
       "4                           http://www.furious7.com/         James Wan   \n",
       "\n",
       "                         tagline  \\\n",
       "0              The park is open.   \n",
       "1             What a Lovely Day.   \n",
       "2     One Choice Can Destroy You   \n",
       "3  Every generation has a story.   \n",
       "4            Vengeance Hits Home   \n",
       "\n",
       "                                            keywords  \\\n",
       "0  monster|dna|tyrannosaurus rex|velociraptor|island   \n",
       "1   future|chase|post-apocalyptic|dystopia|australia   \n",
       "2  based on novel|revolution|dystopia|sequel|dyst...   \n",
       "3              android|spaceship|jedi|space opera|3d   \n",
       "4                car race|speed|revenge|suspense|car   \n",
       "\n",
       "                                            overview  runtime  \\\n",
       "0  Twenty-two years after the events of Jurassic ...      124   \n",
       "1  An apocalyptic story set in the furthest reach...      120   \n",
       "2  Beatrice Prior must confront her inner demons ...      119   \n",
       "3  Thirty years after defeating the Galactic Empi...      136   \n",
       "4  Deckard Shaw seeks revenge against Dominic Tor...      137   \n",
       "\n",
       "                                      genres  \\\n",
       "0  Action|Adventure|Science Fiction|Thriller   \n",
       "1  Action|Adventure|Science Fiction|Thriller   \n",
       "2         Adventure|Science Fiction|Thriller   \n",
       "3   Action|Adventure|Science Fiction|Fantasy   \n",
       "4                      Action|Crime|Thriller   \n",
       "\n",
       "                                production_companies release_date  vote_count  \\\n",
       "0  Universal Studios|Amblin Entertainment|Legenda...     6/9/2015        5562   \n",
       "1  Village Roadshow Pictures|Kennedy Miller Produ...    5/13/2015        6185   \n",
       "2  Summit Entertainment|Mandeville Films|Red Wago...    3/18/2015        2480   \n",
       "3          Lucasfilm|Truenorth Productions|Bad Robot   12/15/2015        5292   \n",
       "4  Universal Pictures|Original Film|Media Rights ...     4/1/2015        2947   \n",
       "\n",
       "   vote_average  \n",
       "0           6.5  \n",
       "1           7.1  \n",
       "2           6.3  \n",
       "3           7.5  \n",
       "4           7.3  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies_clean.head(5)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Changing release date to datetime**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "movies_clean.release_date = pd.to_datetime(movies_clean.release_date)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dtype('<M8[ns]')"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies_clean.release_date.dtype"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 10866 entries, 0 to 10865\n",
      "Data columns (total 18 columns):\n",
      " #   Column                Non-Null Count  Dtype         \n",
      "---  ------                --------------  -----         \n",
      " 0   id                    10866 non-null  int64         \n",
      " 1   imdb_id               10856 non-null  object        \n",
      " 2   popularity            10866 non-null  float64       \n",
      " 3   budget                10866 non-null  int64         \n",
      " 4   revenue               10866 non-null  int64         \n",
      " 5   original_title        10866 non-null  object        \n",
      " 6   cast                  10790 non-null  object        \n",
      " 7   homepage              2936 non-null   object        \n",
      " 8   director              10822 non-null  object        \n",
      " 9   tagline               8042 non-null   object        \n",
      " 10  keywords              9373 non-null   object        \n",
      " 11  overview              10862 non-null  object        \n",
      " 12  runtime               10866 non-null  int64         \n",
      " 13  genres                10843 non-null  object        \n",
      " 14  production_companies  9836 non-null   object        \n",
      " 15  release_date          10866 non-null  datetime64[ns]\n",
      " 16  vote_count            10866 non-null  int64         \n",
      " 17  vote_average          10866 non-null  float64       \n",
      "dtypes: datetime64[ns](1), float64(2), int64(5), object(10)\n",
      "memory usage: 1.5+ MB\n"
     ]
    }
   ],
   "source": [
    "movies_clean.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**dropping duplicates**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "movies_clean.drop_duplicates(inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "movies_clean = movies_clean.reset_index(drop = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\Zoey\\Anaconda3\\lib\\site-packages\\ipykernel_launcher.py:1: UserWarning: Boolean Series key will be reindexed to match DataFrame index.\n",
      "  \"\"\"Entry point for launching an IPython kernel.\n"
     ]
    },
    {
     "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>id</th>\n",
       "      <th>imdb_id</th>\n",
       "      <th>popularity</th>\n",
       "      <th>budget</th>\n",
       "      <th>revenue</th>\n",
       "      <th>original_title</th>\n",
       "      <th>cast</th>\n",
       "      <th>homepage</th>\n",
       "      <th>director</th>\n",
       "      <th>tagline</th>\n",
       "      <th>keywords</th>\n",
       "      <th>overview</th>\n",
       "      <th>runtime</th>\n",
       "      <th>genres</th>\n",
       "      <th>production_companies</th>\n",
       "      <th>release_date</th>\n",
       "      <th>vote_count</th>\n",
       "      <th>vote_average</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2090</th>\n",
       "      <td>60309</td>\n",
       "      <td>tt0968264</td>\n",
       "      <td>0.591206</td>\n",
       "      <td>25000000</td>\n",
       "      <td>15478800</td>\n",
       "      <td>The Conspirator</td>\n",
       "      <td>Evan Rachel Wood|James McAvoy|Kevin Kline|Robi...</td>\n",
       "      <td>http://www.conspiratorthemovie.com/</td>\n",
       "      <td>Robert Redford</td>\n",
       "      <td>One bullet killed the President. But not one man.</td>\n",
       "      <td>president|history|conspiracy|lawyer|trial</td>\n",
       "      <td>Mary Surratt is the lone female charged as a c...</td>\n",
       "      <td>122</td>\n",
       "      <td>Crime|Drama|History</td>\n",
       "      <td>Wildwood Enterprises|American Film Company</td>\n",
       "      <td>2010-09-10</td>\n",
       "      <td>78</td>\n",
       "      <td>5.9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         id    imdb_id  popularity    budget   revenue   original_title  \\\n",
       "2090  60309  tt0968264    0.591206  25000000  15478800  The Conspirator   \n",
       "\n",
       "                                                   cast  \\\n",
       "2090  Evan Rachel Wood|James McAvoy|Kevin Kline|Robi...   \n",
       "\n",
       "                                 homepage        director  \\\n",
       "2090  http://www.conspiratorthemovie.com/  Robert Redford   \n",
       "\n",
       "                                                tagline  \\\n",
       "2090  One bullet killed the President. But not one man.   \n",
       "\n",
       "                                       keywords  \\\n",
       "2090  president|history|conspiracy|lawyer|trial   \n",
       "\n",
       "                                               overview  runtime  \\\n",
       "2090  Mary Surratt is the lone female charged as a c...      122   \n",
       "\n",
       "                   genres                        production_companies  \\\n",
       "2090  Crime|Drama|History  Wildwood Enterprises|American Film Company   \n",
       "\n",
       "     release_date  vote_count  vote_average  \n",
       "2090   2010-09-10          78           5.9  "
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies_clean[movies.duplicated()]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Phase four: Visualization and Analysis."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Questions:\n",
    "- What is the most rated movie?\n",
    "- What is the most voted movie?\n",
    "- Most successful director?\n",
    "- Top 3 movies for the top 3 directors?\n",
    "- Highest movie budget?\n",
    "- Longest movie runtime?\n",
    "- Most famous Genres?\n",
    "- Top Movies for each Genre?\n",
    "- Most popular movie?\n",
    "- Does the production of movies increase or decrease?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "def visualize_bar(axes, x, y, ticklabel, rotation, ylabel):\n",
    "    axes.bar(x,y)\n",
    "    axes.set_xticklabels(ticklabel, rotation = rotation)\n",
    "    axes.set_ylabel(ylabel)\n",
    "    plt.show()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**What is the most rated movie?\n",
    "Here we can see that the top rated movie is \"The Story of Film: An Odyssey\" with an average vote of 9.2** "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "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>id</th>\n",
       "      <th>imdb_id</th>\n",
       "      <th>popularity</th>\n",
       "      <th>budget</th>\n",
       "      <th>revenue</th>\n",
       "      <th>original_title</th>\n",
       "      <th>cast</th>\n",
       "      <th>homepage</th>\n",
       "      <th>director</th>\n",
       "      <th>tagline</th>\n",
       "      <th>keywords</th>\n",
       "      <th>overview</th>\n",
       "      <th>runtime</th>\n",
       "      <th>genres</th>\n",
       "      <th>production_companies</th>\n",
       "      <th>release_date</th>\n",
       "      <th>vote_count</th>\n",
       "      <th>vote_average</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3893</th>\n",
       "      <td>125336</td>\n",
       "      <td>tt2044056</td>\n",
       "      <td>0.006925</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>The Story of Film: An Odyssey</td>\n",
       "      <td>Mark Cousins|Jean-Michel Frodon|Cari Beauchamp...</td>\n",
       "      <td>http://www.channel4.com/programmes/the-story-o...</td>\n",
       "      <td>Mark Cousins</td>\n",
       "      <td>NaN</td>\n",
       "      <td>cinema|nouvelle vague|hindi cinema|cinema novo...</td>\n",
       "      <td>The Story of Film: An Odyssey, written and dir...</td>\n",
       "      <td>900</td>\n",
       "      <td>Documentary</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2011-09-03</td>\n",
       "      <td>14</td>\n",
       "      <td>9.2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          id    imdb_id  popularity  budget  revenue  \\\n",
       "3893  125336  tt2044056    0.006925       0        0   \n",
       "\n",
       "                     original_title  \\\n",
       "3893  The Story of Film: An Odyssey   \n",
       "\n",
       "                                                   cast  \\\n",
       "3893  Mark Cousins|Jean-Michel Frodon|Cari Beauchamp...   \n",
       "\n",
       "                                               homepage      director tagline  \\\n",
       "3893  http://www.channel4.com/programmes/the-story-o...  Mark Cousins     NaN   \n",
       "\n",
       "                                               keywords  \\\n",
       "3893  cinema|nouvelle vague|hindi cinema|cinema novo...   \n",
       "\n",
       "                                               overview  runtime       genres  \\\n",
       "3893  The Story of Film: An Odyssey, written and dir...      900  Documentary   \n",
       "\n",
       "     production_companies release_date  vote_count  vote_average  \n",
       "3893                  NaN   2011-09-03          14           9.2  "
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies_clean[movies_clean.vote_average == movies_clean.vote_average.max()]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**What is the most voted movie? Here we find that \"inception\" is the top voted movie with a vote count of 9767**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "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>id</th>\n",
       "      <th>imdb_id</th>\n",
       "      <th>popularity</th>\n",
       "      <th>budget</th>\n",
       "      <th>revenue</th>\n",
       "      <th>original_title</th>\n",
       "      <th>cast</th>\n",
       "      <th>homepage</th>\n",
       "      <th>director</th>\n",
       "      <th>tagline</th>\n",
       "      <th>...</th>\n",
       "      <th>overview</th>\n",
       "      <th>runtime</th>\n",
       "      <th>genres</th>\n",
       "      <th>production_companies</th>\n",
       "      <th>release_date</th>\n",
       "      <th>vote_count</th>\n",
       "      <th>vote_average</th>\n",
       "      <th>release_year</th>\n",
       "      <th>budget_adj</th>\n",
       "      <th>revenue_adj</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1919</th>\n",
       "      <td>27205</td>\n",
       "      <td>tt1375666</td>\n",
       "      <td>9.363643</td>\n",
       "      <td>160000000</td>\n",
       "      <td>825500000</td>\n",
       "      <td>Inception</td>\n",
       "      <td>Leonardo DiCaprio|Joseph Gordon-Levitt|Ellen P...</td>\n",
       "      <td>http://inceptionmovie.warnerbros.com/</td>\n",
       "      <td>Christopher Nolan</td>\n",
       "      <td>Your mind is the scene of the crime.</td>\n",
       "      <td>...</td>\n",
       "      <td>Cobb, a skilled thief who commits corporate es...</td>\n",
       "      <td>148</td>\n",
       "      <td>Action|Thriller|Science Fiction|Mystery|Adventure</td>\n",
       "      <td>Legendary Pictures|Warner Bros.|Syncopy</td>\n",
       "      <td>7/14/10</td>\n",
       "      <td>9767</td>\n",
       "      <td>7.9</td>\n",
       "      <td>2010</td>\n",
       "      <td>160000000.0</td>\n",
       "      <td>825500000.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         id    imdb_id  popularity     budget    revenue original_title  \\\n",
       "1919  27205  tt1375666    9.363643  160000000  825500000      Inception   \n",
       "\n",
       "                                                   cast  \\\n",
       "1919  Leonardo DiCaprio|Joseph Gordon-Levitt|Ellen P...   \n",
       "\n",
       "                                   homepage           director  \\\n",
       "1919  http://inceptionmovie.warnerbros.com/  Christopher Nolan   \n",
       "\n",
       "                                   tagline  ...  \\\n",
       "1919  Your mind is the scene of the crime.  ...   \n",
       "\n",
       "                                               overview runtime  \\\n",
       "1919  Cobb, a skilled thief who commits corporate es...     148   \n",
       "\n",
       "                                                 genres  \\\n",
       "1919  Action|Thriller|Science Fiction|Mystery|Adventure   \n",
       "\n",
       "                         production_companies release_date vote_count  \\\n",
       "1919  Legendary Pictures|Warner Bros.|Syncopy      7/14/10       9767   \n",
       "\n",
       "      vote_average  release_year   budget_adj  revenue_adj  \n",
       "1919           7.9          2010  160000000.0  825500000.0  \n",
       "\n",
       "[1 rows x 21 columns]"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies[movies.vote_count == movies.vote_count.max()]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Most successful director? We can see here that \"Christopher Nolan\" is the most famous director as he has a total vote count of 41759**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "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>director</th>\n",
       "      <th>vote_count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Christopher Nolan</td>\n",
       "      <td>41759</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Steven Spielberg</td>\n",
       "      <td>36735</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Peter Jackson</td>\n",
       "      <td>31796</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Quentin Tarantino</td>\n",
       "      <td>27894</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ridley Scott</td>\n",
       "      <td>24801</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5062</th>\n",
       "      <td>Kevin Bacon</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5063</th>\n",
       "      <td>Kevin Dowling|Geoff Burton</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5064</th>\n",
       "      <td>Alonso Mayo</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5065</th>\n",
       "      <td>Allan Holzman</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5066</th>\n",
       "      <td>Alex Winter|Tom Stern</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5067 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                        director  vote_count\n",
       "0              Christopher Nolan       41759\n",
       "1               Steven Spielberg       36735\n",
       "2                  Peter Jackson       31796\n",
       "3              Quentin Tarantino       27894\n",
       "4                   Ridley Scott       24801\n",
       "...                          ...         ...\n",
       "5062                 Kevin Bacon          10\n",
       "5063  Kevin Dowling|Geoff Burton          10\n",
       "5064                 Alonso Mayo          10\n",
       "5065               Allan Holzman          10\n",
       "5066       Alex Winter|Tom Stern          10\n",
       "\n",
       "[5067 rows x 2 columns]"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "top_directors = movies_clean.groupby(['director'])[['vote_count']].sum().sort_values(by=['vote_count'], ascending=False)\n",
    "top_directors = top_directors.reset_index()\n",
    "top_directors"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\Zoey\\Anaconda3\\lib\\site-packages\\ipykernel_launcher.py:3: UserWarning: FixedFormatter should only be used together with FixedLocator\n",
      "  This is separate from the ipykernel package so we can avoid doing imports until\n"
     ]
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAZEAAAFFCAYAAAAtjtBuAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuMSwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/d3fzzAAAACXBIWXMAAAsTAAALEwEAmpwYAABb6klEQVR4nO2deXhcV3n/P19ttqzNtqTYJoYkDU6c4JBAFgKFGjCQsENKSkIhKbhlM0tLf6WklBKWlKVshUIKJUACKRC2EmgChGxsTtLYODshziJiYsmyLMuSLXmk0fv745yRx8rV4njOvZrr830ePZo5d+587pk7c997znkXmRlRUVFRUVGPRTVZH0BUVFRUVPUqGpGoqKioqMesaESioqKioh6zohGJioqKinrMikYkKioqKuoxKxqRqKioqKjHrLqsDyBt3XDDDTZv3rysDyMqKiqqarRnz57ta9as6UzadsgZkXnz5rFy5crgnK6uLo444ojgnEOFlwUz8qqblwUzr7yNGzd2TbUtTmcFUn19feRVOTPyqpuXBTPvvCRFIxJIbW1tkVflzMirbl4WzLzzkhSNSCBt37498qqcGXnVzcuCmXdekqIRCaS835HEu8rIm+u8LJh55yUpGpFAKhQKkVflzMirbl4WzLzzkhSNSCANDw9HXpUzI6+6eVkw885LUjQigbR06dLIq3Jm5FU3Lwtm3nlJikYkkLq7uyOvypmRV928LJh55yXpkAs2PBi94Mu/nfVrn7pwlI3X7JjVa3/21095rIc0oYaGhoN+j7nMy4IZedXNy4KZd16S4kgkkLYOp/vRtrS05JqXBTPyqpuXBTPvvCRFIxJIx7QUU+X19fXlmpcFM/Kqm5cFM++8JEUjEkj3765Nlbdo0aJc87JgRl5187Jg5p2XpGhEAqm9YTxV3qHgWpj3PkZe9TPzzktSqkZEUq2k30r6sX++WNI1ku7z/xeVvfYCSZsl3SvpjLL2kyXd4bd9VpJ8+zxJ3/btN0s6Ms2+TdbCekuVNzIykmteFszIq25eFsy885KU9kjkncA9Zc/fA1xrZiuAa/1zJB0PnAM8CTgT+IKk0vzQxcAbgRX+70zfvhboN7MnAp8GPha2K9Nrw850Hd8OBf/0vPcx8qqfmXdeklIzIpKWAy8GvlzW/HLgUv/4UuAVZe3fMrO9ZvYgsBk4TdIyoNXM1puZAZdN2qf0Xt8F1pRGKVno5IVjqfIOBf/0vPcx8qqfmXdektIciXwGeDdQvliwxMy2Avj/h/n2w4GHy163xbcd7h9Pbt9vHzMbAwaA9or24AC0czRd+zV//vxc87JgRl5187Jg5p2XpFTmXCS9BNhmZhskPXs2uyS02TTt0+2zn7Zt28batWupq6ujWCxy1llnsW7dOrq7u2lqaqK2tpZdu3bR2dnJjh07MDM6Ozvp6enhmGY3ulg2f5xNA3Wc0DrGmIn7hmpZ1TrGluEa6mtgybxxHhmpYXVHgT1F0bWnluNaxnhoTy0tdUZ7wzgbdtZx8sIxBsfE0NAQfX19LFq0iOHhYUZGRli6dCnd3d3Mnz+fxsZG+vv7aW9vZ3BwkEKhMLG9sbGRhoYGBgYGaG5uZmBggNHR0YntM/WpubkZgKGhIZYsWUJvby+SWLx4Mb29vbS2tlIsFtm9e/fEe9bX11NbW0tXVxdtbW0UCgWGh4cntjc0NNDS0lKRPnV0dEz0qbm5ma6urmB9amtrY/v27RN9GhgYYOHChUH7VH6exsbG6OrqCtqn8vM0Pj5ese/eVH0qP09DQ0MUCoWgfUo6T11dXcH6NPk81dbW0tfXF7xPpfM0MDAAELRPpfM05cXazQqFlaSPAK8DxoD5QCvwfeBU4NlmttVPVd1gZsdKugDAzD7i9/8pcCHwEHC9ma307ef6/d9Ueo2ZrZdUB3QDnTapg+vXr7fHWh73QCLWV3cUuHH77KJJKxGxnteynFkyI6+6eVkw88rbuHHjhjVr1pyStC2V6Swzu8DMlpvZkbgF8+vM7LXAlcD5/mXnAz/0j68EzvEeV0fhFtBv8VNeg5JO9+sd503ap/Rer/KMdF2kyvT7wXTjRNrb0525S5uXBTPyqpuXBTPvvCRlHSfyUeD5ku4Dnu+fY2Z3AVcAdwM/AdaZWSkE/C24xfnNwP3A1b79EqBd0mbgXXhPr6y0rDHdOJHBwcFc87JgRl5187Jg5p2XpNQTMJrZDcAN/nEfsGaK110EXJTQfiuwKqF9BDi7god6UGqpS3cQdCgUw8l7HyOv+pl55yUp65FIbhXjRKqfGXnVzcuCmXdekqIRCaQYJ1L9zMirbl4WzLzzkhSNSCD1FdL9aBsbG3PNy4IZedXNy4KZd16SohEJpMGxdIMND4ViOHnvY+RVPzPvvCRFIxJIRy5It55IKegor7wsmJFX3bwsmHnnJSkakUC6ZzDdhfWOjo5c87JgRl5187Jg5p2XpGhEAumIOBKpembkVTcvC2beeUmKRiSQFtSmGycyOjqaa14WzMirbl4WzLzzkhSNSCDFOJHqZ0ZedfOyYOadl6RoRAIpxolUPzPyqpuXBTPvvCRFIxJIPXvT/WibmppyzcuCGXnVzcuCmXdeklLPnXWoaLQC+RcPJPX80U1j3L/74Zlf6HWw6edra9PNUpwFM/Kqm5cFM++8JMWRSCAtTzmLb9q8Xbt2pcrLghl51c3Lgpl3XpKiEQmkO3elO8hLm9fZ2ZkqLwtm5FU3Lwtm3nlJikYkkFY0pxsnkjZvx44dqfKyYEZedfOyYOadl6RoRAKpTunGiaTNy6JoZNrMyKtuXhbMvPOSlIoRkTRf0i2SbpN0l6QP+PYLJf1R0ib/96KyfS6QtFnSvZLOKGs/WdIdfttnfZlcfCndb/v2myUdmUbfptIdKU8vpc2LUxORN9d5WTDzzktSWiORvcBzzexE4CTgTEmn+22fNrOT/N9VAJKOx9VifxJwJvAFSSU3hIuBN+Lqrq/w2wHWAv1m9kTg08DHwndrap3Ulm6cSNq8np6eVHlZMCOvunlZMPPOS1IqRsSchvzTev833Tjs5cC3zGyvmT2Iq6d+mqRlQKuZrTc3jrsMeEXZPpf6x98F1pRGKVlo60i6M4Vp85qbm1PlZcGMvOrmZcHMOy9Jqc2B+JHEBuCJwOfN7GZJLwTeJuk84Fbg782sHzgcuKls9y2+bdQ/ntyO//8wgJmNSRoA2oHt5cexbds21q5dS11dHcVikbPOOot169bR3d1NU1MTtbW17Nq1i87OTnbs2IGZ0dnZSU9PD8c0u7v9ZfPH2TRQxwmtY4yZuG+ollWtY2wZrqG+BpbMG6e/IFZ3FNhTFF17ajmuZYyH9tTSUme0N4yzYWcdJy8cY3BMDA0N0dfXx6JFixgeHmZkZISlS5eyuqPAzlHRV6jh6KYivx+sZVnjOC11NrF/X6GGwTGxqnWMnaM1HLGgyILafdt79tYwOu5cgO/cVceK5iJ1MkZGRujp6Zn4Eg4NDbFkyRJ6e3uRxOLFi+nt7aW1tZViscju3btZunQp3d3d1NfXY2Z0dXXR1tZGoVBgeHh4YntDQwMtLS2Jferu7mb+/Pk0NjbS399Pe3s7g4ODFAqFie2NjY00NDQwMDBAR0cHAwMDjI6OMm/ePLq6umY8T4+1T21tbWzfvn2iTzt27KC5uTlon0rbm5qa2L17N0NDQ0H7VH6eSp9pyD6Vn6e+vj727NkTtE+Tz9POnTsZGhoK1qfJ56m0RhGyT+Xnqbe3l7GxsaB9mslQKe2FGUkLgR8Abwd6cRd5Az4ELDOzN0j6PLDezL7h97kEuAr4A/ARM3ueb38W8G4ze6mku4AzzGyL33Y/cJqZ9ZXz169fbytXrnxMx34gwX+rOwrcuH12BWOmCvwLxZuOOVt1dXVxxBFHHNR7zHVm5FU3LwtmXnkbN27csGbNmlOStqXunWVmO4EbgDPNrMfMimY2DvwXcJp/2Rbg8WW7LQce8e3LE9r320dSHdAGZOb/tmkg3YXutHlLlixJlZcFM/Kqm5cFM++8JKXlndXpRyBIagSeB/zOr3GU9ErgTv/4SuAc73F1FG4B/RYz2woMSjrdr3ecB/ywbJ/z/eNXAddZhv5vJ7Smu9CdNq+3tzdVXhbMyKtuXhbMvPOSlNbt6zLgUr8uUgNcYWY/lvR1SSfhprMeAt4EYGZ3SboCuBsYA9aZWSma7i3A14BG4Gr/B3AJ8HVJm3EjkHNS6NeUGrN01/TT5mXhs5A2M/Kqm5cFM++8JKViRMzsduBRk/Bm9rpp9rkIuCih/VZgVUL7CHD2wR1p5XTfULqJ0dLmLV68OFVeFszIq25eFsy885IUI9YDaVXK00tp8+LUROTNdV4WzLzzkhSNSCBtGU73o02b19ramiovC2bkVTcvC2beeUmKRiSQ6lP+ZNPmFYvpJnzMghl51c3Lgpl3XpKiEQmkJfPSre+RNm/37t2p8rJgRl5187Jg5p2XpGhEAmnDznTjNtLmLV26NFVeFszIq25eFsy885IUjUggnbww3YXutHnd3d2p8rJgRl5187Jg5p2XpGhEAmlPMV3/7bR59fX1qfKyYEZedfOyYOadl6RoRAKpa0+6cRtp89ra2lLlZcGMvOrmZcHMOy9J0YgE0nEt6U4vpc3bvn37zC+qcmbkVTcvC2beeUmKRiSQHkp5ZJA2L95VRt5c52XBzDsvSem69BxCaqlLN/djJXgHknp+VesYdx5ASd6DTT0PUCgUDvo9Iu/Q4WXBzDsvSXEkEkjtDenGbeSdBzA8PBx5kTenmXnnJSkakUDKe5xI2jzIvw9+5FU/M++8JEUjEkh5jxNJmwf598GPvOpn5p2XpGhEAmlwLN24jbzzABoaZl/+N/IiLwtm3nlJikYkkLamnFU37zyAlpaWyIu8Oc3MOy9JaZXHnS/pFkm3SbpL0gd8+2JJ10i6z/9fVLbPBZI2S7pX0hll7SdLusNv+6wvk4svpftt336zpCPT6NtUOqYl3eyaeecB9PX1RV7kzWlm3nlJSut2ci/wXDM7ETgJOFPS6cB7gGvNbAVwrX+OpONx5W2fBJwJfMGX1gW4GHgjru76Cr8dYC3Qb2ZPBD4NfCyFfk2p+3enG7eRdx7AokWLZn5R5EVehsy885KUihExpyH/tN7/GfBy4FLffinwCv/45cC3zGyvmT0IbAZOk7QMaDWz9WZmwGWT9im913eBNcqwAHHeXW6ji2/kzXVeFsy885KUmp+mH0lsAJ4IfN7Mbpa0xMy2ApjZVkmH+ZcfDtxUtvsW3zbqH09uL+3zsH+vMUkDQDuwX16Abdu2sXbtWurq6igWi5x11lmsW7eO7u5umpqaqK2tZdeuXXR2drJjxw7MjM7OTnp6ejim2XkkLZs/zqaBOk5oHWPMxH1DtaxqHWPLcA31Na62R0ONsbqjwJ6i6NpTy3EtYzy0p5aWOqO9YZwNO+s4eeEYg2NiaGiIvr4+Fi1axPDwMCMjIyxdupTVHQV2joq+Qg1HNxX5/WAtyxrHaamzif37CjUMjokT28bYOlLLEQuKLKjdt71nbw2j47C8cZw7d9WxorlInYyRkRF6enpobm4GYGhoiLb68Wn7VHrPPUXR2TDOwvrClH3aOlzDMS1F7t9dS3vDOF1dXSxdupTu7m7mz59PY2Mj/f39tLe3Mzg4SKFQmNje2NhIQ0MDAwMDdHR0MDAwwOjoKMVika6urhnPU3mflixZQm9vL5JYvHgxvb29tLa2UiwW2b179wSzvr6etrY2tm/fTltbG4VCgZ6eHhYuXEh3dzcNDQ20tLQknqeD6VNpe1NTE/39/YyMjATt0/Dw8MT2oaEhmpqagvap/Dxt27aNQqEQtE+Tz1NfX1/QPk0+T8PDw9TV1QXtU/l56unpAQjap9J5mvLa7m7o05OkhcAPgLcDvzKzhWXb+s1skaTPA+vN7Bu+/RLgKuAPwEfM7Hm+/VnAu83spZLuAs4wsy1+2/3AaWa236Th+vXrbeXKlY/p2A8koru5bpyhsdkN9KaK5g7Fm4qZNu9AtXfvXubNm3fQ7xN5hwYvC2ZeeRs3btywZs2aU5K2pe5iY2Y7gRtwaxk9fooK/3+bf9kW4PFluy0HHvHtyxPa99tHUh3QBuwI0YfZKO9xGzFOJPLmOi8LZt55SUrLO6vTj0CQ1Ag8D/gdcCVwvn/Z+cAP/eMrgXO8x9VRuAX0W/zU16Ck0/16x3mT9im916uA6yztYVaZdo6muxyTdx7A/PnzIy/y5jQz77wkpbUmsgy41K+L1ABXmNmPJa0HrpC0FjdVdTaAmd0l6QrgbmAMWGdmJZ/StwBfAxqBq/0fwCXA1yVtxo1AzkmlZ1Oor5DuIC/vPHDzvpEXeXOZmXdeklIxImZ2O/CoSXG/XrFmin0uAi5KaL8VWJXQPoI3QnNBRzcV2TKcnhts3nkA/f39tLa2Rl7kzVlm3nlJihHrgfT7wXQvsHnnAbS3t0de5M1pZt55SYpGJJCWNaYbR5F3HsDg4GDkRd6cZuadl6RoRAKpGotSzWUe5L/gT+RVPzPvvCTNyohISnSVlbQtqT0q//U9Yj2RyJvrvCyYeeclabYjkfrJDZLqgfQnxqtEeY/biHEikTfXeVkw885L0rS3k5J+ictxNV/SLyZtXg78JtSBVbvy7nJbCd6BRMiDr+t+zeziRysRIZ93d82887Jg5p2XpJnmJL4MCDgVF4dRkgE9wHWBjqvqlfciUVkUpUqbmfcCQ3nnZcHMOy9J0xoRM7sUQNJNZva7dA4pHzpyQZGuPenN9uWdlwVzYGCAhQsXRl6V8rJg5p2XpFmtjprZ7yS9AFcLpHnStn8JcFxVr3sG0114zjsvC2ZHR0fkVTEvC2beeUmarXfWfwDfAE7GJTks/S2fbr9DWUcsSLfyX955WTAHBgYir4p5WTDzzkvSbG/tzgVOMrOHQx5MnrSgNt04irzzsmCOjo5GXhXzsmDmnZek2brY9AE7Ax5H7pT3uI0s4kTSZubd5z/vvCyYeeclabZG5JPA5ZKeLulPyv9CHlw1K+9xG1nEiaTNzLvPf955WTDzzkvSbG/tLvb/XzKp3YgBh4nq2Ztu3EbeeVkwm5qaIq+KeVkw885L0my9s2KOrQPUaMr5CfPOy4JZW5vu/VHkVT8z77wkReMQSMtTznKbd14WzF27dkVeFfOyYOadl6TZuvj+UtIvkv5muf/jJV0v6R5Jd0l6p2+/UNIfJW3yfy8q2+cCSZsl3SvpjLL2kyXd4bd91pfJxZfS/bZvv1nSkQf0SVRYd+5KdxE477wsmJ2dnZFXxbwsmHnnJWm2I5Ev49KelP7+F1gK/HyW+48Bf29mxwGnA+skHe+3fdrMTvJ/VwH4becATwLOBL7gS+uCW595I67u+gq/HWAt0G9mTwQ+DXxslscWRCua041pyDsvC+aOHbPL0xV5c5OXBTPvvCTNdk3k0sltkr4HfBX44Cz23wps9Y8HJd0DHD7NLi8HvmVme4EHfd300yQ9BLSa2Xp/DJcBr8DVWX85cKHf/7vAf0iSmaUf0ADUKV1s3nlZMNP+6kRe9TPzzkvSwcwP/BF48oHu5KeZngLcDPwp8DZJ5wG34kYr/TgDc1PZblt826h/PLkd//9hADMbkzQAtAPby/nbtm1j7dq11NXVUSwWOeuss1i3bh3d3d00NTVRW1vLrl276OzsZMeOHZgZnZ2d9PT0cEyzczFdNn+cTQN1nNA6xpiJ+4ZqWdU6xpbhGuprYMm8ce4bqmV1R4E9RdG1p5bjWsZ4aE8tLXVGe8M4G3bWcfLCMQbHxNDQEH19fSxatIjh4WFGRkZYunQpqzsK7BwVfYUajm4q8vvBWpY1jtNSZxP79xVqGBwTC2qNw+aNc8SCIgtq923v2VvD6LhbT7hzVx0rmovUyRgZGaGnp4fmZpfFZmhoiLb68Wn7VHrPPUXxyEgNqzsKU/Zp63ANx7QUuX93Le0N43R1dbF06VK6u7uZP38+jY2NrO4oTNunIxcUuWewbqJPpc90qj7dsauOk9rG2DpSQ19fH0NDQyxZsoTe3l4ksXjxYnp7e2ltbaVYLLJ79+6JY6qvr6etrY3t27fT1tZGoVCgUCiwd+9euru7aWhooKWlJfE8lfepv7+f9vZ2BgcHKRQKE9sbGxtpaGhgYGCAjo4OBgYGGB0dndje1NREQ0MDXV1did+98vN0MH0aHh6e2F5TUzPld69SfSr/PRWLRR5++OGgfZp8niQlfvcq1afJ52nevHkV+e5N16fy81QoFOjp6Qnap9J5mvKaPhtLJukNk5oWAGcBo2Z2RsIuU71PM3AjcJGZfV/SEtxF3oAPAcvM7A2SPg+sN7Nv+P0uAa4C/gB8xMye59ufBbzbzF4q6S7gDDPb4rfdD5xmZn3lx7B+/XpbuXLlbA95Px1I6vLVHQVu3D67DJtTpS0PxZuKOZd5B8pM+zOtROr5rq4ujjjiiIN+n8jLjplX3saNGzesWbPmlKRtsx2JvG7S8924WiKfnu1B+CJW3wMuN7PvA5hZT9n2/wJ+7J9uweXmKmk58IhvX57QXr7PFkl1QBuQ2YTh1pF0Hd/yzsuCmTZvpju+yJv7zLzzkjTbNZHnHAzEe1BdAtxjZp8qa1/m10sAXgnc6R9fCfy3pE8Bj8MtoN9iZkVJg5JOx02HnQd8rmyf84H1wKuA67JaD4mKioo6VDTrWy1JKyT9i6Qv+v8rDoDzp7jRzHMnufN+3Lvr3g48B/g7ADO7C7gCuBv4CbDOzEquOW/BeYttBu7HLaqDM1LtfhH+XcB7DuD4Kq5l89ONacg7Lwtm2ryhoaHIq3Jm3nlJmtVIRNJLgctx001dwLHArZJeZ2ZXzrS/mf0KVyFxsq6aZp+LgIsS2m8FViW0jwBnz3QsaWnTQLoxDXnnZcFMm7dkyZLIq3Jm3nlJmu1I5F+Bl5vZa8zsAjP7S5xL7b+GO7Tq1gmt6SYLzDsvC2bavN7e3sircmbeeUmarRFZDvxyUtuviEWpptSYpVsPPO+8LJhp83zyhcirYmbeeUmarRHZBPz9pLZ3+faoBN03lG5itLzzsmCmzVu8eHHkVTkz77wkzdaIvAX4a0mP+LxUjwB/49ujErQq5amQvPOyYKbNy/tUSJzOqn5ekmbr4vs7SaW8V4/DxWbcbGbZ12aco9oynG6MQd55WTDT5rW2tkZelTPzzkvStEZE0mJc1PdPzGwMtw5S2nampJt9mpKoSapP+Rqbd14WzLR5xWK6CSbzzsuCmXdekmb6mfwzcPIU254CvLeyh5MfLZmXboxB3nlZMNPm7d69O/KqnJl3XpJmMiIvAb44xbYv4dx8oxK0YWe6MQZ552XBTJu3dOnSyKtyZt55SZrpV7LUzLZPsW0HkH2kyxzVyQvHDihBYeTNPWYleHM54WN3d3eqyQLT5mXBzDsvSTONRPolHTvFtmOAnZU9nPxoTzFd/+2887Jg5p1XX1+fa14WzLzzkjTTSOQHwGclvcLMhkuNkhpxGXy/G/Lgqllde9KNMcg7LwtmNfIOZORz2Lxxtu3tmfmFVGbk09bWdtDvMdeZeeclaSYj8j7gOuABST/BVSdcBpyBKwD1/rCHV706rmWMbXvTm3rJOy8LZuTNrLRr0Byotm/fTlNT00G/T+RNrWmns8xsEHgGzpjMB07x/98HPMtvj0rQQynfxeadlwUz8qqbB/kfGVTDSAQfUPhl/xc1S7XUpVvKJO+8LJiRV908gEKhEHmBlUHI2KGh9oZ0YwzyzsuCGXnVzQMYHh6e+UWRd1BKxYhIeryk6yXdI+kuSe/07YslXSPpPv9/Udk+F0jaLOleSWeUtZ/sC1ltlvRZXzURSfMkfdu33yzpyDT6NpXyHtMQ40Qib67zIP9xG3MhTiStkcgY8PdmVsq/tU7S8bjqg9ea2QrgWv8cv+0c4EnAmcAXJJUmVC8G3ogrmbvCbwdYC/Sb2RNxnmMfS6NjU+nkhekm78s7Lwtm5FU3D1wcReSF1QEZEUk1kpYdKMTMtprZRv94ELgHOBwX8X6pf9mlwCv845cD3zKzvWb2IK4U7mme3Wpm63399Msm7VN6r+8Ca0qjlCw0OJYuOu+8LJiRV908gIaGdD0I885L0qyMiKSFkv4bGMFd0JH0MkkfPlCgn2Z6CnAzsMTMtoIzNMBh/mWH41yIS9ri2w73jye377ePTxY5ALQf6PFVSltTzgCbd14WzMirbh5AS0tL5AXWbCcp/xPoB44A7vZt64FP4pI0zkqSmoHvAX9rZrumGSgkbbBp2qfbZz9t27aNtWvXUldXR7FY5KyzzmLdunV0d3fT1NREbW0tu3btorOzkx07dmBmdHZ20tPTwzHNbji+bP44mwbqOKF1jDET9w3Vsqp1jC3DNdTXuMR9DTXGMeNF9hRF155ajmsZ46E9tbTUGe0N42zYWcfJC8cYHBNDQ0P09fWxaNEihoeHGRkZYenSpazuKLBzVPQVaji6qcjvB2tZ1jhOS51N7N9XqGFwTKzuKPCTnnkcsaDIgtp923v21jA6Dssbx7lzVx0rmovUyRgZGaGnp4fm5mYAhoaGaKsfn7ZPpffcUxSdDeMcUyxO2aetwzUc01Lk/t21tDeM09XVxdKlS+nu7mb+/Pk0NjayuqMwbZ+OXFDknsG6iT6VPtOp+nTHrjpOahtj60gNfX19DA0NsWTJEnp7e5HE4sWLWd1RmLJPk8/TUxeO8v1H5k3Zp4X1ZZ9zTw+NjY309/fT3t7O4OAghUKB5rrxaftUfp5WNo/RP1qcsk/l372HH354ok+9vb20trZSLBZZ3VGYtk/l52nZ/CI39jZM2afy797Q0NBEn0rnsbGxkSMWFKftU/l5eu5hBbr21E7Zp8nfvf7+forFIrt3755g1tfX09bWxvbt22lra6NQKDA8PDyxvaGhgZaWlonf05YtW2hqanrUd2/yeSrvU0NDAwMDA3R0dDAwMMDo6OjE9pmuEcPDw3R2diZ+98rP08H0qfwa8cADD7BkyZKgfSpdI6a8WLtZoeklqRd4nJmNStphZot9+4CZzcpRWVI98GPgp2b2Kd92L/BsM9vqp6puMLNjJV0AYGYf8a/7KXAh8BBwvZmt9O3n+v3fVHqNma2XVAd0A502qYPr16+3lStXzuaQH6UDCaxa3lhky/Ds/OKnCqoKxZuKOZd5B8pM+zONvMrypmMeiHbt2pVqzY288jZu3LhhzZo1pyRtm+34cgDoKG+Q9ARcBPuM8msTlwD3lAyI15XA+f7x+cAPy9rP8R5XR+EW0G/xU16Dkk7373nepH1K7/Uq4LrJBiRN5d19Mrr4Rt5c50H+XW7ngovvbKezvgx8T9J7gRpJTwf+FTfNNRv9KfA64A5Jm3zbPwEfBa6QtBb4A3A2gJndJekK3NTZGLDOzErVV94CfA1oBK72f+CM1NclbcZlGD5nlscWRAvr07VfeedlwYy86uYBjIyMRF5gzdaIfAy3qP55oB74Cq7OyL/PZmcz+xXJaxYAa6bY5yLgooT2W4FVCe0jeCM0F5R3H/wYJxJ5c50H+Y/bqKY4kSVm9hkzO97MmszsODP7DLGeyJTKuw9+jBOJvLnOg/zHbcyFOJHZ3hr8HkhavbkbWFy5w8mPdo6m6xOfd14WzMibe7wDdcY4sW2U267ZMavXVmIhf/78+Qf9HnOZl6TZjkQedfYltQLpr5RVifoK6frE552XBTPyqpuXBbOxsTHXvCRN+wlLeljSH4BGSX8o/8N5Zv1PGgdZjTq6qTjziyJvTjMjr7p5WTD7+/tzzUvSTNNZr8WNQq7CeVeVZECPmd0b6sCqXb8fTLd2Qt55WTAjr7p5WTDb29NNkpE2L0kzFaW60cxuADr849LfL6IBmV7LGtOd6cs7Lwtm5FU3Lwvm4GC6dfrS5iVpthOGo5I+IOkBSSP+/wckZZ/9a44q7wV/YlGqyJvrvCyYh2JRqtl6Z30cOA14M9CFy6H1PpzH1t+FObTqVt598GOcSOTNdV4lmAfqDdZcN87QWHreYHMhTmS2n/DZwIlm1uef3ytpI3Ab0Ygk6uSFY9y4Pb2BWt55WTAjr7p5WTArwTsQw7W6ozBrXiWMVpIes4vvDO2HvPLuPnkouGtGXnXzsmDmnZek2R7Bd4AfSTpD0nGSzsS5914R7MiqXHkv+BOLUkXeXOdlwcw7L0kzxYmUtr8b+Dkud9YG4HPA9cA/Bj26KtaRC9L1T887Lwtm5FU3Lwtm3nlJmmlN5I+Svg5cZmb/AvxLCseUC90zmO4iYt55WTAjr7p5WTDzzkvSTNNZbwaOAv5P0kZJ75DUMcM+UcARKd8h5J2XBTPyqpuXBTPvvCTNFGz4QzM7G1iGS/3+F8AWSVdK+nNfrTAqQQtq0/VPzzsvC2bkVTcvC2beeUma1cK6me00sy+a2TOB44BbgU8zy8qGh6Ly7oNfjT7/kXdo8bJg5p2XpAPyD5M0DzgVeBqulsgds9zvK5K2SbqzrO1CSX+UtMn/vahs2wWSNku6V9IZZe0nS7rDb/usL5GLL6P7bd9+s6QjD6RfIZT3Wg2xnkjkzXVeFsy885I0KyMi6ZmSvgT0AB8GbgKOMbPnzJLzNeDMhPZPm9lJ/u8qzzoeV9r2SX6fL0gqZVG7GHgjrub6irL3XAv0m9kTcSOkj83yuIKpZ2+6/tt552XBjLzq5mXBzDsvSTO5+F4o6X7gR77pxWZ2jJl9yMy6Zgsxs1/g6p7PRi8HvmVme83sQWAzcJqkZUCrma03MwMuA15Rts+l/vF3gTWlUUpWGk0511zeeVkwI6+6eVkw885L0kxm7HTgvcAyM3ujmf26wvy3SbrdT3ct8m2HAw+XvWaLbzvcP57cvt8+ZjYGDACZ5khennL20LzzsmBGXnXzsmDmnZekaVdlzCxpCqpSuhj4EK42yYeATwJvIDmVik3Tzgzb9tO2bdtYu3YtdXV1FItFzjrrLNatW0d3dzdNTU3U1taya9cuOjs72bFjB2ZGZ2cnPT09HNPs5h+XzR9n00AdJ7SOMWbivqFaVrWOsWW4hvoaWDJvnAd217K6o8CeoujaU8txLWM8tKeWljqjvWGcDTvrOHnhGINjYmhoiL6+PhYtWsTw8DAjIyMsXbqU1R0Fdo6KvkINRzcV+f1gLcsax2mps4n9+wo1DI6JxlrjsHnjHLGgyILafdt79tYwOu6+bHfuqmNFc5E6GSMjI/T09NDc3AzA0NAQbfXj0/ap9J57iuKR4RpWdxSm7NPW4RqOaSly/+5a2hvG6erqYunSpXR3dzN//nwaGxtZ3VGYtk9HLihyz2DdRJ9Kn+lUfbpjVx0ntY2xdaSGvr4+hoaGWLJkCb29vUhi8eLFrO4oTNmnyeepsdZorhufsk8L68s+554eGhsb6e/vp729ncHBQQqFwsT+U/Wp/DwNjIrVHYUp+1T+3Xv44Ycn+tTb20trayvFYpHVHYVp+1R+nsxg2bzilH0q/+4NDQ1N9Kl0HhsbGzliQXHaPpWfpzoZz2wvTNmnyd+9/v5+isUiu3fvnmCeumh0xt9T+XkaG2e/z2S631NXVxeNjY00NDQwMDBAR0cHpy4andXvqdSnoTFxTPPYrK4Re/fupbu7m/r6etra2ti+fTttbW2sah2b8fdUOk+NtcaJbaOzukZ0dXXR0dHBwMAAo6OjE5/pTNe90jViKsnNDIWXX+z+sZmtmm6bpAsAzOwjfttPgQuBh4DrzWylbz8XeLaZvan0GjNbL6kO6AY6LaFz69evt5UrVz6mPhxIYrTTF49y047ZeUBPlRgtFG8q5lzmHSgz7c808irLm4qZ9nfmUPiOzkYbN27csGbNmlOStmW2KuPXOEp6JVDy3LoSOMd7XB2FW0C/xcy2AoOSTvfrHecBPyzb53z/+FXAdUkGJE3VKV183nlZMCOvunlZMPPOSzyGNCCSvgk8G+iQtAV4P/BsSSfhpp0eAt4EYGZ3SboCuBsYA9aZWSks8y04T69G4Gr/B3AJ8HVJm3EL+OcE79QMumNXuv7beedlwYy86uZlwcw7L0mpjETM7FwzW2Zm9Wa23MwuMbPXmdkJZvZkM3uZH2mUXn+RmR1tZsea2dVl7bea2Sq/7W2l0YaZjZjZ2Wb2RDM7zcweSKNf0+mktnT9t/POy4IZedXNy4KZd16SsncyzqlKi4aRV73MyKtuXhbMvPOSlP0RREVFRUVVraIRCaRl89P13847Lwtm5FU3Lwtm3nlJikYkkDYNpLvglXdeFszIq25eFsy885IUjUggndCa7oJX3nlZMCOvunlZMPPOS1I0IoE0Zumm7so7Lwtm5FU3Lwtm3nlJikYkkO4bqp35RZE3p5mRV928LJh55yUpGpFAWpXyMDPvvCyYkVfdvCyYeeclKRqRQNoynO5Hm3deFszIq25eFsy885KU/RHkVPUpf7J552XBjLzq5mXBzDsvSXPgEPKpJfPS9d/OOy8LZuRVNy8LZt55SYpGJJA27EzXfzvvvCyYkVfdvCyYeeclKRqRQDp5YboLXnnnZcGMvOrmZcHMOy9J0YgE0p5iuv7beedlwYy86uZlwcw7L0nRiARS1550/bfzzsuCGXnVzcuCmXdekqIRCaTjWtIdZuadlwUz8qqblwUz77wkpWJEJH1F0jZJd5a1LZZ0jaT7/P9FZdsukLRZ0r2SzihrP1nSHX7bZ32ZXHwp3W/79pt9zfZM9VDKdwh552XBjLzq5mXBzDsvSWmNRL4GnDmp7T3AtWa2ArjWP0fS8bjytk/y+3xBUumTuhh4I67u+oqy91wL9JvZE4FPAx8L1pNZqqUu3drHeedlwYy86uZlwcw7L0lplcf9Ba72ebleDlzqH18KvKKs/VtmttfMHgQ2A6dJWga0mtl6Xxb3skn7lN7ru8Ca0iglK7U3pOu/nXdeFszIq25eFsy885KUpZPxklJddTPbKukw3344cFPZ67b4tlH/eHJ7aZ+H/XuNSRoA2oHtk6Hbtm1j7dq11NXVUSwWOeuss1i3bh3d3d00NTVRW1vLrl276OzsZMeOHZgZnZ2d9PT0cEyzm39cNn+cTQN1nNA6xpiJ+4ZqWdU6xpbhGuprXADQ7wZrWd1RYE9RdO2p5biWMR7aU0tLndHeMM6GnXWcvHCMwTExNDREX18fixYtYnh4mJGREZYuXcrqjgI7R0VfoYajm4r8frCWZY3jtNTZxP59hRoGx0RDjXHYvHGOWFBkQe2+7T17axgdh+WN49y5q44VzUXqZIyMjNDT00NzczMAQ0NDtNWPT9un0nu6PtWwuqMwZZ+2DtdwTEuR+3fX0t4wTldXF0uXLqW7u5v58+fT2NjI6o7CtH06ckGRewbrJvpU+kyn6tMdu+o4qW2MrSM19PX1MTQ0xJIlS+jt7UUSixcvZnVHYZo+7X+eGmqM5rrxKfu0sL7sc+7pobGxkf7+ftrb2xkcHKRQKEzsP1Wfys/T9oJY3VGYsk/l372HH354ok+9vb20trZSLBZZ3VGYtk/l56kwDsvmFafsU/l3b2hoaKJPpfPY2NjIEQuK0/ap/DyB8cz2wpR9mvzd6+/vp1gssnv37gnmqYtGZ/w9lZ+n4SL7fSbT/Z66urpobGykoaGBgYEBOjo6OHXR6Kx+T6U+9RfEMc1js7pG7N27l+7uburr62lra2P79u20tbWxqnVsxt9T6Tw11Bgnto3O6hrR1dVFR0cHAwMDjI6OTnymM133SteIqSR3Ux9efp3ix2a2yj/faWYLy7b3m9kiSZ8H1pvZN3z7JcBVwB+Aj5jZ83z7s4B3m9lLJd0FnGFmW/y2+4HTzKxv8nGsX7/eVq5c+Zj68IIv/3bWr13dUeDG7Q2zeu3P/vopqfKmYs5l3oEy0/5MI6+yvKmYaX9nDoXv6Gy0cePGDWvWrDklaVuW3lk9fooK/3+bb98CPL7sdcuBR3z78oT2/faRVAe08ejps1Q1OJbubFreeVkwI6+6eVkw885LUpZG5ErgfP/4fOCHZe3neI+ro3AL6Lf4qa9BSaf79Y7zJu1Teq9XAddZWkOsKbQ15eyaeedlwYy86uZlwcw7L0lpufh+E1gPHCtpi6S1wEeB50u6D3i+f46Z3QVcAdwN/ARYZ2ZF/1ZvAb6MW2y/H7jat18CtEvaDLwL7+mVpY5pKc78osib08zIq25eFsy885KUysK6mZ07xaY1U7z+IuCihPZbgVUJ7SPA2QdzjJXW/bvT9d/OOy8LZuRVNy8LZt55Scp+LJRT5d3VL7prRt5c52XBzDsvSdGIBNLC+nSXZPLOy4IZedXNy4KZd16SohEJpLzXFYi1ISJvrvOyYOadl6RoRAIp73UFYm2IyJvrvCyYeeclKRqRQNo5mq7/dt55WTAjr7p5WTDzzktSNCKB1FdI96PNOy8LZuRVNy8LZt55Scr+CHKqo5vS9d/OOy8LZuRVNy8LZt55SYpGJJB+P5iu/3beeVkwI6+6eVkw885LUjQigbSsMV3/7bzzsmBGXnXzsmDmnZekaEQCKe/FaWKBocib67wsmHnnJSkakUDKu7949PmPvLnOy4KZd16SohEJpLz7i0ef/8ib67wsmHnnJSkakUDKu6tfdNeMvLnOy4KZd16Ssj+CnCrvxWligaHIm+u8LJh55yUpGpFAOnJBuv7beedlwYy86uZlwcw7L0nRiATSPYPpLnjlnZcFM/Kqm5cFM++8JGVuRCQ9JOkOSZsk3erbFku6RtJ9/v+istdfIGmzpHslnVHWfrJ/n82SPutL6GamI1K+Q8g7Lwtm5FU3Lwtm3nlJytyIeD3HzE4ys1P88/cA15rZCuBa/xxJxwPnAE8CzgS+IKkUsnkx8EZcTfYVfntmWlCbrv923nlZMCOvunlZMPPOS9JcMSKT9XLgUv/4UuAVZe3fMrO9ZvYgrtb6aZKWAa1mtt7MDLisbJ9MlHd/8ejzH3lznZcFM++8JGV/BGDAzyQZ8EUz+xKwxMy2ApjZVkmH+dceDtxUtu8W3zbqH09uf5S2bdvG2rVrqauro1gsctZZZ7Fu3Tq6u7tpamqitraWXbt20dnZyY4dOzAzOjs76enp4Zhm55O9bP44mwbqOKF1jDET9w3Vsqp1jC3DNdTXwJJ54zTUGIVxsacouvbUclzLGA/tqaWlzmhvGGfDzjpOXjjG4JgYGhqir6+PRYsWMTw8zMjICEuXLmV1R4Gdo6KvUMPRTUV+P1jLssZxWupsYv++Qg2DY2J1R4Gf9MzjiAVFFtTu296zt4bRcVjeOM6du+pY0VykTsbIyAg9PT00NzcDMDQ0RFv9+LR9Kr3nnqLobBhnd1FT9mnrcA3HtBS5f3ct7Q3jdHV1sXTpUrq7u5k/fz6NjY2s7ihM26cjFxS5Z7Buok+lz3SqPt2xq46T2sbYOlJDX18fQ0NDLFmyhN7eXiSxePFiVncUpuzT5PP01IWjfP+ReVP2aWF92efc00NjYyP9/f20t7czODhIoVCguW582j6Vn6eVzWP0j9ZM2afy797DDz880afe3l5aW1spFous7ihM26fy87RsfpEbexum7FP5d29oaGiiT6Xz2NjYyBELitP2qfw8nblkL117aqfs0+TvXn9/P8Vikd27d08wT100OuPvqfw8PWPxKD17axL7NPm719XVRWNjIw0NDQwMDNDR0cGpi0Zn9Xsq9am9wbXP5hqxd+9euru7qa+vp62tje3bt9PW1saq1rEZf0+l83TW4/Zy20DdrK4RXV1ddHR0MDAwwOjo6MRnOtN1r3SNmEpyN+7ZSdLjzOwRbyiuAd4OXGlmC8te029miyR9HlhvZt/w7ZcAVwF/AD5iZs/z7c8C3m1mL53MW79+va1cufIxHesLvvzbWb92ZcsYv5vlotfP/vopqfKmYs5l3oEy0/5MI6+yvKmYaX9nDoXv6Gy0cePGDWvWrDklaVvm01lm9oj/vw34AXAa0OOnqPD/t/mXbwEeX7b7cuAR3748oT0zjaacFy3vvCyYkVfdvCyYeeclKVMjIqlJUkvpMfAC4E7gSuB8/7LzgR/6x1cC50iaJ+ko3AL6LX7qa1DS6d4r67yyfTLR8pSza+adlwUz8qqblwUz77wkZb0msgT4gffGrQP+28x+Iun/gCskrcVNVZ0NYGZ3SboCuBsYA9aZWcnH7S3A14BG4Gr/l5nu3JXuR5t3XhbMyKtuXhbMvPOSlOkRmNkDwIkJ7X3Amin2uQi4KKH9VmBVpY/xsWpFc5G+HekN9PLOy4IZedXNy4KZd16SMl8TyavqlK7DQt55WTAjr7p5WTDzzktSNCKBdEfKw8y887JgRl5187Jg5p2XpGhEAumktnTz/OedlwUz8qqblwUz77wkRSMSSKVAqsirXmbkVTcvC2beeUnK/giioqKioqpW0YgE0rL56fpv552XBTPyqpuXBTPvvCRFIxJImwbSXfDKOy8LZuRVNy8LZt55SYpGJJBOaE13wSvvvCyYkVfdvCyYeeclKRqRQBqzdGti5Z2XBTPyqpuXBTPvvCRFIxJI9w3VzvyiyJvTzMirbl4WzLzzkhSNSCCtSnmYmXdeFszIq25eFsy885IUjUggbRlO96PNOy8LZuRVNy8LZt55Scr+CHKq+pQ/2bzzsmBGXnXzsmDmnZekOXAI+dSSeen6b+edlwUz8qqblwUz77wkRSMSSBt2puu/nXdeFszIq25eFsy885IUjUggnbww3QWvvPOyYEZedfOyYOadl6RcGRFJZ0q6V9JmSe/J8lhuvT7dwop552XBjLzq5mXBzDsvSbkxIpJqgc8DLwSOB86VdHxWx/PbG9I9uXnnZcGMvOrmZcHMOy9JuTEiwGnAZjN7wMwKwLeAl2d1MI0pf7J552XBjLzq5mXBzDsvSTLLvrxiJSTpVcCZZvbX/vnrgKeZ2dvKX3fVVVcNbt26deKjb21t7V28ePH2Sh/Pjh07OkK876HKy4IZedXNy4KZY94Ra9as6UzakP3SfuWUlETmURbyRS96UUsKxxIVFRV1SGgODIYqpi3A48ueLwceyehYoqKiog4J5cmI/B+wQtJRkhqAc4ArMz6mqKioqFwrN9NZZjYm6W3AT4Fa4CtmdlfGhxUVFRWVa+VmYX0uSNIzgCMpM85mdllmB5QDSXoZ8Gf+6Y1m9qOArLPN7DsztVWIVQu8w8w+Xen3noF7OHAE+39HfxGIdTSwxcz2Sno28GTgMjPbGYJXxm0EnmBm94bkeNZiM9sRmjOJWQssYf9z+Ic0j2G/44lGpDKS9HXgaGATUPTNZmbvCMQb5NGOAwPArcDfm9kDFeadBXwMOAznxCBc/1oryZnE/AjOdfty33QucKuZXRCIt9HMnjpTWwV5N5jZs0O89xS8jwGvBu5m/+/oywLxNgGn4G6sfoqbXj7WzF4UgueZLwU+ATSY2VGSTgI+GLCP9+F+818FrrbAF1RJbwfeD/QApcRZZmZPDsmd9piiEamMJN0DHB/6S1TG+wDOceC/cRf0c4ClwL3AWyp9cZK0GXipmd1TyfedgXk7cJKZjfvntcBvK/2DkfRC4EXAXwDfLtvUijunp1WSV8a9CGjzzN2ldjPbGIh3L/BkM9sb4v0TeBvN7KmS/gEYMbPPSfqtmT0lIHMD8FzghhJH0u2hLrKSBDwPeAPuhufbwNfM7PeBeJtxoQt9Id7/sSg3ayJzQHfiLuJbU+KdaWZPK3v+JUk3mdkHJf1TAF5PmgakTAuB0nRBWyDGI7gR3MuADWXtg8DfBWICPMP//2BZm+EugiH0AFAPpGJEgFFJ5wLnAy/1bfWBmWNmNuCu7eHlbxqvAa6R9BzgG8BbJd0GvMfM1lcY+TBuxmHOKBqRyqkDuFvSLZT9SEMNo4FxSX8BfNc/f1XZthCjoVslfRv4H/bv3/cDsEr6CPBbSdfjRlt/BlR8KsvMbgNuk7TEzC4t3ybpncC/V5rpuc8J8b7TaA+wSdK17H8Og0y5Aq8H3gxcZGYPSjoKd5ENqTslvQaolbQCeAfwm1AwSe3Aa4HX4aaY3o6btjsJ+A5wVIWRDwA3SPpf9j+Hn6owZ9aK01kVkqTVSe1mdmMg3p/gLm5PxxmNm3B3zX8ETjazX1WY99WEZjOzN1SSk8BdBpyKMyI3m1l3QFbSmkiw6RdJS4B/BR5nZi/0ud6ebmaXBOKdn9Q+2XBWsyQtAN4LvAD3nfkp8CEzGwnE+z3wdeCrZrZl0rZ/NLOPVZj3/qR2M/tAJTkHomhEqlB+beCjZvYPWR9LaKXhTeSnXF4DPBP4ZdmmFqBoZs+rJK+MezVuQfa9ZnaipDrcms8JIXie2QAc45/ea2ajARhXmNlfSLqDhFFxWovA/nfSZGa7AjKU1jroJG4L7iZuKG32ZMXprApJ0unA54DjgAZcrMruEN5LZlaUdHKl33c6SVqO69+f4i4MvwLeOfnuq8LMkjfRXZR5ogCVdkn9DW4tqwP4ZFn7IHB7hVnl6jCzKyRdABOxTsWZdnqs8m62lwIP4e7SHy/p/AAuvu/0/19S4fedUZL+GzeFVsStb7VJ+pSZ/VsgZIekdwNPAuaXGs0syLqWpFW4kc9i/3w7cF6WMXHRiFRO/4HzkPoOzq3xPGBFQN5vJV3peeWePaHWKL6K8wQ72z9/rW97fiAewCtwLqFBF4LNrAvoAp7up5hO9ZvuMbOQVX92+zl1g4kbkZCLpp8EXlCKn5B0DPBNoKI3JGZWci453sz2y1Uu6c3Af1aSN0nHm9kuSX8JXAX8I86YhDIil+M8sl6CM17nA72BWABfAt5lZtfDxI3Bf7HPSSN15SntSeYys81ArZkVzeyrwLMD4hYDfThPnpf6v5B3fp1m9lUzG/N/XwMSs3pWUCVvolQk6WzgFpyh/AvgZp8dOpTehVuEPVrSr4HLcAuzoVRfHoDn3VBDfr7vkzRxRy7pHwlfnqFeUj3uBuSHfrou5HRTu1/DGjWzG/0a4ekBeU0lAwJgZjcATQF5MyqORCqnPX6+eZOkj+OmR4KdXDN7faj3nkLbJb0Wd+cKLvAvtK962t5E/wycambbACR1Aj9nnwdcRWVmG71DxrG46aUgaxRl2iDpEtx0CMBfsr9Lc6X1MuDHPk7kTGClbwupL+Km624DfiHpCCDYmghQOl9bJb0Y5y6+PCDvAUnvY985fC3wYEDejIoL6xWS/7Juw93Z/R0upuELfnQSgncMcDGwxMxWSXoy8DIz+3Ag3hNwU3ZP902/xq2JdIXgeWaq3kSS7ihf1JZUA9wWeKE7tVQ5kuYB63AOBMKtLX0h5HShpMNwhngD8IaMFqHrQk1LSnoJzhnj8bg1w1bgA2YWJPmrpEXAB3DnENw5vNACp5KZ9piiEalOSboR+Afgi2WRuXea2apsj6x6JenfcPmdSqOtVwN3mNm7A/FSS5XjDeLtaXw/tC8lj/z/BmDMP7YQziZl7FTdptOWUszvNutjikbk4DSVG2NJAdMt/J+ZnVoexyBpk5mdFIj3ceDDwDDwE+BE4G/NrOLBY1m6iMrlCJu4UzezHwRkpZ0q53LgAsswWV9opeU2LWk+7iajH/gR8G7gWcD9uLiUINUGp4hlCpbfbTaKayIHr9TdGL22y2VJLXn2vIqwKVdeYGbvlvRKXAGws4HrCROBnImLqI+ovqrk4SapUdKRZvZQIGTaqXKWAXf5rArlHn2hkhO+ErjOzAb884XAs83sf0LwvNJym74Mtx7SBPw97lz+B+4G5GtU+LurffndDpf02bJNrbhRXmaKRuQgVb4mMMk99JbSAm0grcO5+62U9Efc4tpfBuSVvHheBHzTzHYoUH6iMhfRt5rZP5Zv87Ej//jovSqi77C/q2TRt52a/PLHJkk/whn/FtJNlZN2VPP7y0dyZrbTR1z/T0BmWm7Tx/u1yDpcuvtSxoqfyOXNqrSyyu82o6IRqZDk8lj9G3ADbirkc5L+wcxCefY8ADxPUhNQY2aDIThl+pGk3+Gms97qPZeCpJIo0/N5tMF4YUJbpVRnZoXSEzMreI+7SusTAd5zRpnZjd4BZIWZ/dynCKkNiEwKIQh9zZnsNt3J/nnlKqUCTIx0JpfhrvjIx8xuk3QnbkZgTqWpiUakcnovKbqH+rut9+OGzybpV7i6CUHcbs3sPX4UsMtHzO8hkLumpLcAbwX+RC4dfEktOK+wUOqV9LKSZ42klwMVn9s2n0/NT59tNZ/XSa6Y0pJK80qS9DfAG3ExRkcDh+MC/9YEQt4q6VPA53Ejg7cT1qU4Tbfp5X5aSWWP8c8PD8ArZapol9RQfrOTteLCeoWUtnuopGtw7n2lNYm/xM03h8rz9BUrS7YoqRkXzFXxC5CkNmARLovve8o2DVrAKnJ+jely4HG4i8HDuJQSody0bwWeUbog+FHPr82sotNnZbxNuJoXN5c5Y9wR8DvaBLwPV28D4Ge4jL67p97roJlnAz8xs0FJ/ww8FfiwVbhGy1Tu5yUFdEP/Iq5PV7L/ulZmWXzjSKRy+omkn7K/e+hVAXmLzexDZc8/LOkVAXl/lHSxmb3F+6r/Ly7dQsXlF2IHgHO1fynQZknNobyLzOx+4HRvIJXCFGFa02cl7fUMwMVPEDCa2xuL9/hzllaiwPeZ2XckPRM4Azd1eDHwtOl3OzBlOKX0iP+rwY3MM1c0IhWSmf2DpD/HJSgU8KWQ7qHA9ZLOAa7wz1+Fu7AHkZm9T9LHJP0nLtfSR83se6F4AJLeBlzIpFKguFiOSnJeiouhKDlJvAv4c0lduIDKUBHBqUyflelGuYJljZKej5syDFmz/hnAl4Fm4AmSTgTeZGZvDcVk33rEi4GLzeyHki4MyEtVlmHK96kUp7OqTJMCuZrY96OpBYYqHcjl4yYmnuKmJ27BxYoELUqllEqB+nWX081sj1wE8qdwaV2eApxtZmcE4qY9fVYDrGX/WhtfDhWnIulm3M3NlWkFxEr6Ma6mzvNwNzvDOE/JE0Mx05Rcgbak2KlQ1TBnVDQiBylJDzL1lICZ2dFpHk+lpeRiVCWZBSxK5X8wz7ewmXSRdFvpIiPpK7jF2I/558EDuVKcPktVkm42s6dp/4DY20Je0L3H2Zm4TAP3yRU1O8HMfhaKmaa0fwmI+cCf40oCB8mqMBvF6ayD1ymTntfgMsD+P+C3lYZJmvaCVukFREs/0WO50ioFKn8h34PzVPpC2bb5ybtUBDoPdxE4EqgrrVWY2Qen2e1geC8BPsS+Il8ibBqSh/2Ulvm1nncA9wRilUZat5SPdHzMUcWDOSV9jukzVQRJEmpmk73bfi2XAikzRSNykCpNtfgv8Otw+aw2AS82s7sDID85zTbDpYavuCRdilsf2OmfLwI+GXIkAvzB/zX4v1D6DO6c7cLVELkVQNJTCBtN/kOcA8EGyoxkQH0GOAt3l57GFMSbcSWcD8dlOfgZLkg2iMxsXNJtkp4QyvmiTLcGfv9ESVpc9rQGN2W3NItjKSlOZx2k5GoXvAEXNfor4CPeyydXUkKt8aS2apVcGd7DcG7Z475tGa4GR5ALUuj1gQTe9cCaUv/yKEnX4TIMpJLapYzbFNJ1uYxTmj4XLt3Jg7j4sF+FZk+lOBI5eD2IO5mfwd01n+i9UIBwC89+7vddwBPM7I2SVuCqAP44BA+okbTIzPo9fzGBvz8+YDOV0qNm9kfcgmx5W+icVr+RdIKZ3RGYU9K7gav89EfI6UFgIpjy7Tw61X3IC3qq3kuSng5cQkoeaGZ2VIj3PRhFI3Lw+jnuzuBE/1cuA0KWq93AvlxPW3B5nkIZkU/iLnqlCPyzgYsCsUpKu/Ro2nom8Ff+7nIv+9YoQmUpvggYwhnkkNODJf0P7gL7I/a5aAeVudQuaeaw+wwuHuVKz79N0p+FAMmlrNltZtvlcoI9E9hsYRNaznxccTqrOiXpVjM7JWXPlycBz8Fd7K4NtOZTzttgZidLur10YZV0o+1LdlfV8heFR8kCFfoqfWdCvPcUvJvNrKJBfrNgTs5h9ywgWA67tDzQ5KoZ/hXuxvRbOBfmG3BBlLeZ2d9WkncgiiOR6lVBLtdSKVvp0QRenDWzuyT14qeWUljATLX0qKRPAF81s7tCMTyn1cx24TKwpqmfS3pBiu6u/y6Xtfdn7D99VlEPwklKNYcd6XmgnQscByzATZsv9XFNdTinkMwUjUj16v24gL/HyxUb+lPcnUoQSXoZbkrrcbgywEfgfixPCsXEpXJpw9VrKJUeDZn2+nfAl/wP86u4lPch0oj/N26KLikZoQF/EoAJzjPq3ZL24gx0aBffE3Aei89l/4wDIQPjaiZNX/WRnE24UkrLA23EXIqcgqT7zWwPTGQRzjQZY5zOqoC8e+/pZvablLntwOm4i8FNFqiammfdhvvx/9zMniLpOcC5ZvbGQLxa4B1m9ukQ7z8D+1jg9bi7v18D/2Vm11fw/Z9uZusr9X5zVXKlA55sKWacVcoljtOSpAdwsWcCPo4LJaD0PMug5mhEKiRJ683s6SlwVprZ76YKOgw1VVC2BnMb8BTvk3+LmZ0WgueZ15vZc0K9/xTMWtwo4fXA43G5yZ6JW9A8p0KMiSj4tL43ZexFwAr293b7RSDWt4G3B17YTuKmWeJ4Pi6VzGQPworGT82QOSLToOA4nVU5/UwuAeP3AwdyvQtXEyIp6DDkVMFOH9X9C+BySdsIX5bzN5L+A+ehVe7zH8pQfgpXI+Va4F/N7Ba/6WOS7q0kquxxsIj4R0Glv8aVHl6Om0c/HVhPuO/MEuB3kv6PdCo3ltyK0yxx/HXcNOgZwAdxJRkqviaSceaIaRVHIhWSXGLEUkLEYcLPN6cqudoQI7h+/SXQBlxuAZMj+uC4ybIQcSKe9wbgW6X55knb2iq1PuJHc8/GzdVf5x9PGBYLVDNF0h0419ebzOwkSSuBD5jZqwPxEr3ozBflCsRMu0bLb/307u1m9mQffPzTUN/Ruag4EqmQzCzV3P5+GP1WfGVD4JfAf5qvkldpTYrGTaWWQtpTWcDXgNdI+hMz+6CkJ+C8YG6p8AJ7G25RvWQ4ykdWIRfWR8xsRBKS5vlp0WMDsbIoxwvp12gpeRDulLQK6MYFVx4yikakQpJUukM/ysw+JOnxwLKyKZFK6zKci+jn/PNzcUPrsysJ0b7U80naC9wPvNfMrq0kt4z/Yh493xwkQSGujOs4bnrng7jP93vsC1yriMzsyEq+3wFoi6SFuCDAayT149ymg0jpl+OF9Gu0fMmvM70PF3DYDPxLQN6cU5zOqpAkXYy/AJnZcf6L9bOAw+hHBTSFDjZMOIZaYBVuWqviOaDkCmAtwAU4fhlXm+IWM1tbaZbnbTSzp6YZwJmV/FRTG66UbBDvKaVcjte/f6o1WtKW/829mEenkonlcXOgp5UuQABm1h94GP1bSaeb2U0Akp6Gc0dNTWZWBG6TS4sdQs/w88y3m9kHJH2ScGlkAEb9j7QUwNlJSuk6QkrSqUCHmV1davNTTS/DxXIkxatUQqmW44X0SxxrUjr/suMINVr+EW5t8g7myHczGpHKKe0L0NOA8ySVIsafANzjF0/NwuVfepTM7IuB3nrY/98j6XG4wLGQCeg+C/wAOEzSRbiRzz8H5KWlfyM5EPVu4EuE8866USmV41V2JY7TTue/PM3f9mwUjUjllPYF6MyA752pJP3MzF4A/NjP4f8bbvHZcNNaQWRml0vagJuzF/AKM6u4u6b2rwmRdByV9s5qT3JxNbPNPmA1lN6Di6G4A3gTcBXhzt9FOJflUvGt17KvxPF/4lxwQ2i5maX5W7xa6aaumVFxTaSC8i6TpQvQtYEuQAuAUTMb9c+PBV4EdFm4tPO1OLfF54V4/wTexJpEWds8YH6FvaRK753qRV3714R4AtDvHy8E/mAVTvctabOZPfFAtx0E71gzS4yrkfSnZlbxaVdlVOJY0peAz1lK6fwlvRL4Bs49PI3UNTMqjkQqq/tw1fHqIFiCwp/g7u7uk/REXLDY5cBLJJ1qZhdUmIeZFSXtqWSsxAxq81HHj5KkEDVaNrDvol5S6XnFXW5LRsI7DlxpZlf55y/EZWettH7uR8f/XB4IK+kDuDiVSuseSV8H1pnZ0KRtnwNCXNClFEscl6aNcb/118ulJUkjnf8ngaeTXnXKGRWNSIUk6e24pIg9uIDD0gWo0l+mRWZ2n398Pi5J4Nv9Iv4GoOJGxGsEuEPSNewfPR6ilnQbLvWIErZVvEZLpe/8D0Cnmtmby47jakkfCsD5e9w00mbvMQWu9s2twF8H4N2FS0a4UdJ5JecPr6RzWgl9hnRLHL8kwHvORvcBd84VAwLRiFRS78RVFgwWwe1V/uV5Lm69oBRUFXIh/3/9XxrqsrC12/eTpshDVpKFS12+XdI/46YnDDePX/Hvjw8UPVfSn7Av6/JdZvZApVleo2b2Xkk/Bb4h6TLgw+bK8ga5+JnZVzzvMOC2sk3duDxoleZ1AcgVh7qr5AUmqQU4HghSEwZnEG+QdDUpVKecjaIRqZwexnlphNbtcnUv/gg8EZd6Gr8AHUxmdqlc/ZInTDXfXUGFuludSqU8ZPOBU3AXIeFGkTfjsgKE0Lm40WspQeAvfFsQeaMRynAk8X4h6RTc1NIvJf1lYF4WJY4vZv/pud0JbZXUg/6vgXSqU86oaEQOUpLe5R8+gLtD+F/C3iH8DW7UcyTwAtuX5+l44BMVZk3Iu1B+AvfFPUrSScAHLUwyvdcFeM8pVUqvIulbwBtLi6Q+jcX/C8jdgTuXeVN5HrCduFQy5+NS8yzI6qACSeVTS+ayWwe7rppZqjXkZ6NoRA5epZxZf/B/Qe8QzGwY+GhC+2+AkPVMLsRFH9/geZvkMqZWXGZ2Z4j3nYVWlnvZmNmd3lhWVJI+Y2Z/K+lHJEzvBDLMaeq/Jjf4kewvgaqu65GgByS9Azf6ABcLU/HRnqT/MLO3zcXvTHTxrbAkteK8M9IufRpUSq4lPVH7PA+S9E3cdET5GkWzmVV0iknSyWa2QSlnufUpQbaY2V5Jz8ZN113mRwu5kXdJX8L+EeRByjhLOgwXI/Zc3HfmWuBvrcI1VCTtMrPWtL8zs1E0IhWSn/v9KvtGJgPAG8wsVEqJVCXpEtwP5D24NA/vAOrLvYuqXXKZkd8C/Jlv+gVwsQXKjOx9/q8yszQinUu5rE7BTYX+FJcw8Fgze1Ea/DQ0yUtyoiRvtd/sJMVOzRVFI1IhSbod5xf/S//8mcAXqv3LW5IPcnwv8ALf9FPgQyEvgJL+FDeNdgTurrLkgx8qVXqqkqtW91ycsfoWLqAzWKEv7Usw+Q+4tPCfm8sXp8ciSZtxeeyCeklKereZfVwub1zS9FJFXd8lbQGmXF+N3ln50GDJgACY2a/k0qgHkaRjcHWWSxfYEjdUHqQXm9l7cYakdAxnA98JxAO4BPg7XPxLMRRE0hVm9hdlAWT7KdSNgJm9Xq6I0QuB1wBfkHSNmYWI3QCX3+1cXHzRS31bfSAWkt5pZv8+U1uFlZaXZCkbxa0psMDVYWkmfc/FGRVHIhWSpE/jPE++ibsQvRqXzuJ7UPlYA7nqeP/JpAtsqOmzpNQRIdNJ+Pe/2cyeFur9yzjLzGyrXAGlR8n2JfULxa/H5UJ7PfAsM+sMxDkeeDOw3sy+6R0jXm1mj3LUqBAv6TsTdOTjp12PxcU0zYk4ikoo9G/tYBSNSIWk5FKuJVmlRwiSNpjZyZV8zyk4L8Tl5voLXK3zklqB483stIDsj+LuwL7P/heEUMF/k/m1wDlmdnmg9z8TOAdXL+UG3Of7s8BTWsFjffxo5zXAs3BTdSW1AEULmINN0vuT2ivtGivpyum2V9pbai5PO0YjUqWSdCGwDReoVn6BrXSywBOBk3CV/sortg0C15tZfyV5k9ip1Fj3HnXrcJX3rgSuAd6GixHZZGYvrySvjPst3FrI1WksrpfH+phZsFgfP6I7CvgIzhGjpEFcuvZgRjItSerFTZ19ExeQut80U6W9pSQtrvRvu1KKRqRCktSG8wopefbciPuBBpmflcsEO1nBFp39lEsd6USspypJP8RNPa7HJe9bhIv1eaeZbcrw0CoquTT3zwVusMCVBpV+5udUY298/56PyzDwZNz02TfN7K5KcqpBcWG9cvoKcCdu2gdc1PVXgcRstAcrSz9p4JmkFLEu6bVm9o2ybAD7KcD89p+ULqSSvoyryf2E0LE+Pu/S54DjcJ9rLbDbwqX1HjOzAWn/m+YQIEs/8/PX/f9gWRvKZa6q50+An8iVKTgXl7Hig2YWqtLnnFQ0IpXT0Wb252XPP6B9GVMrLu9y+y7cxe6NklbgfP5/HAh5IY+OWD8yEKvJ/29J2Bbiojc68ebu4vdgSsGi/4FbE/kOLn7jPFw+tFC6U9JrgFr/fXkHYbMcpJb5ucyh5KQkjzDczEBF5Y3Hi3EG5Ehc0GHI8s1zUtGIVE7Dkp5pZr+CiRiH4Rn2ORh9FeeZ9Qz/fAvuYhTKiCTdxQaR7Su3+3ObVMDIf66V1omSdpUQuHKuu0ih4I+56oK1/s72q5JCXtTfjnPR3ouby/8pECL1fElpZn4u6XxgsgvxXyW0HZQkXQqsAq4GPmDZperJXHFNpELyC9CX4WphgJtjP9/Mbg/Eu9XMTpmUhmSiulsAXuoR61m4FacpSb/AFaH6Mi5l+Vbgr0KdwyyUhjeY56TqESZXdqE0uiq/iGZeaTBtxZFI5bTLzE70nj6Y2S4FSlDoVfA/UIOJvEghPXzK72L/G3cX++EQIElPx42wOieti7Ti1g3yotfhypy+DRdU+XicgQ4in5rnn3BTL+UBqkGCKZVu5uff4IxwB/tS+4P3CKs0zMxqKv2e1apoRCqn7wFPNbNdZW3fBULFclyIW9h7vKTLgT/FDdsrKrl8Um/GzdXfATw9BRfNBlx0bh37r4vsAl4VmJ2azKxLUqd/nEaK78txWQ7uYF9eqZC6kPQyP3f51CC7K+1eGzW9ohE5SElaiasWN7kueCsBajuXZGY/8y6bp+OG0O80s+0BUJfiFp5/iUvPcRzwtwE4E/IXgRslfS10tHgWkltYej9uBCKgRtIY8Dkz+2BAdK+ZTRskV2Gl5g0GmXiERRGNSCV0LK7e8kL25SMCN4z+m1BQHzH7TeBKc+VPQ+n4MvfXS4BbArIma56kL/Ho6ZdQ+cHS0t/iRo6nmtmDAHKlay+W9Hdm9ulA3Pd7F+Zr2T9ANZRHUdreYJCiR1iUU1xYr5AkPd3M1qfIW43Lz/Vi3IX928CPrcJpyycvZKe5sK2U84OlJUm/BZ4/eeTop7Z+Fiq9haRvACuBu9g/TXqQevbaP/Oz2Jf5OUhqfc88P6ndzC4NxTzUFY1IhSTp47iF5mHcWsWJuOI03wjMrcVFIf8NcGalvUIkFdl3RyegEdhDCl4oaeUHS1uS7jSzVQe6rQLcINHps+DmslBblFP0MKicXuAX1V+Ci9kopWoPJu+d9ee4he9TcesXFZWZ1ZpZq/9rMbO6sseh3Rh/JOmtkpZJWlz6C8xMQ4XHuO1gdZNcJt9UJOlUufT6t+OmmG6TFPSmQNIKSd+VdLekB0p/IZmHuuKaSOVUqsvwIlwOnR0hA/MkfRt4Gm7U83lcPqQ0PG7SVGlqotwYG1DtRanKgxvLJQI6YwDPBM6Xy7u2l32jyVCF0y4B3mr7F2r7Ki7XVCh9Fee08GlcduTXMwdrcORJ0YhUTj+S9DvcdNZb/fx2sLlf3I/lNT7SOZfKID9YKjKzrGJdzkyZl2qhNq9GM7tWkrxn34WSfokzLFEBFNdEKihJi3BBh0W/qNhqZt2BWGnnzkpdh0Ifs5Ckwygb8ZjZHyr8/iXHi9eRUKjNXIXMIJL0a1zU+neB64A/Ah81s2NDMQ91RSNykJL0XDO7blKMyIRCuU/66awNwHlmtsqvj6w3s5NC8LLQodDHNCXpZbho7sfhatEcAdxjZk+qMCfVAm2T2KfiStcuxOUFawM+bmY3hWIe6orTWQev1bg7npcmbDPCZfU82sxe7XMGYWbDSiM7Yro6FPqYpj6EC079uZk9RdJzcBloKyoze06l3/MA2P/nHw7h1kOiAisakYOUmb1fUg2uOt0VKaLTzp2VhQ6FPqapUTPrk1QjqcbMrpf0sVAwpVioTSmXq43ap2hEKiAzG5f0NiBNI3Ihj86dlbc7r/eTQn6wQ0g7JTXjUthcLmkbEDIPWpqF2p7ONOVqo8IprolUSJLeh/PM+jb7p1sIVhdZUjv7cmfdFCh3VqY6FPqYlryjwgjus3wtLr/b5aG+o5I2TV6/SmqrECuWq81I0YhUSEq/5vm1ZrZmprZqlqQ/S2o3s18ktUcly7vVTv6hl+7UR4D7gfea2bUV5q4H/sH2L9T2CTN7eiU5CdxSudp/w02fHVLlatNWnM6qkNKKaZBLzb4A6PAuxaWLQSvO6yZPKg8ynI9LK74Bl+YlapYys6Qyw8DEHfwqXJr4SqdbeQtwqV8bEbCDfQGkFZdiudpMFI1IBSXpGTw64+xlFca8CZcF9nG4C2rJiOzCRa7nRma2n8ebpMcDH8/ocHIpH6x6m6SK362b2SZcdH4pPc4eXKxIxYtEKZarzUxxOqtCkvR14GhgE/syzlqoFNSS3n6oDdO9e+/tWSQRjJq9vNFYBxwO/BD4uX/+/4DbzOzlAZixXG1GikakQpJ0D672RtAP1AdTPVyKhJd0Hi4JYxdwYciF/LTl745Ln2cNcBLwkJm9NrODippRkn4I9APrgTXAIly1ynf60UlUjhSNSIUk6TvAO8xsa2DORuB5PsHjnwHfwtU/Pwk4zsxyUz52Um2IMZwB+XVWxxM1O5WnnPdrLttxqWtiKvgcKq6JHKQk/Qh3t9wC3C3pFvavGlfpIKfastHGq4Evmdn3gO9J2lRhVtb6Dq62O8C9ZhYDDatDo6UHPo/cg9GA5FfRiBy8PpEyr1ZSnZmN4aYK3li2LRfnU1I9zj3zdcBDuKmswyR9zsw+KukpZvbbLI8xalqVp7oX0Oifx/WJHCoXF52M9UdgyeRpFj/V9McAvG8CN0rajgtuLNVqeCJQ8XQSGemTODfmI0t3sH6x9hOSLsalNM9lmvg8KMNU91EZKK6JHKQk/Rj4JzO7fVL7KcD7J7upVoh5OrAMV497t287Bmg2s42V5qUtSZuBFZOdFMrm118Ys7JGRc0NRSNykNL09bIzqWld7ZL0ezM75kC3RUVFpa9YY/3gNV0508bUjiJfutu7Lu8nSa/F1YqIioqaI4ojkYOUpG8C15nZf01qXwu8wMxenc2RVa8kHY5LVzGMi8o34FScUX6lmYVYa4qKinoMikbkICVpCfADoIC74AGcgguuemWo8riHgiQ9F3gSzqvnrkonCIyKijp4RSNSIfkqcaW1kbvM7LosjycqKioqDUUjEhUVFRX1mBUX1qOioqKiHrOiEYmKioqKesyKRiQqKioq6jErGpGoqKioqMesaESioqKioh6z/j86GQZ+mT2ThQAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "plt.style.use(\"bmh\")\n",
    "fig, ax = plt.subplots()\n",
    "x = top_directors.loc[:10,'director']\n",
    "y = top_directors.loc[:10,'vote_count']\n",
    "visualize_bar(ax, x, y, x, 90, \"Vote Count\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Top 3 movies for the top 3 directors? For \"Christopher Nolan\" his top 3 movies are the following:**\n",
    "- The Dark Knight with rating of 8.1\n",
    "- Interstellar with rating of 8.0\n",
    "- Inception with rating of 7.9"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "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>id</th>\n",
       "      <th>popularity</th>\n",
       "      <th>budget</th>\n",
       "      <th>revenue</th>\n",
       "      <th>runtime</th>\n",
       "      <th>vote_count</th>\n",
       "      <th>vote_average</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>original_title</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>The Dark Knight</th>\n",
       "      <td>155</td>\n",
       "      <td>8.466668</td>\n",
       "      <td>185000000</td>\n",
       "      <td>1001921825</td>\n",
       "      <td>152</td>\n",
       "      <td>8432</td>\n",
       "      <td>8.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Interstellar</th>\n",
       "      <td>157336</td>\n",
       "      <td>24.949134</td>\n",
       "      <td>165000000</td>\n",
       "      <td>621752480</td>\n",
       "      <td>169</td>\n",
       "      <td>6498</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Inception</th>\n",
       "      <td>27205</td>\n",
       "      <td>9.363643</td>\n",
       "      <td>160000000</td>\n",
       "      <td>825500000</td>\n",
       "      <td>148</td>\n",
       "      <td>9767</td>\n",
       "      <td>7.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Memento</th>\n",
       "      <td>77</td>\n",
       "      <td>3.095625</td>\n",
       "      <td>9000000</td>\n",
       "      <td>39723096</td>\n",
       "      <td>113</td>\n",
       "      <td>2144</td>\n",
       "      <td>7.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The Prestige</th>\n",
       "      <td>1124</td>\n",
       "      <td>2.582095</td>\n",
       "      <td>40000000</td>\n",
       "      <td>109676311</td>\n",
       "      <td>130</td>\n",
       "      <td>2519</td>\n",
       "      <td>7.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The Dark Knight Rises</th>\n",
       "      <td>49026</td>\n",
       "      <td>6.591277</td>\n",
       "      <td>250000000</td>\n",
       "      <td>1081041287</td>\n",
       "      <td>165</td>\n",
       "      <td>6723</td>\n",
       "      <td>7.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Batman Begins</th>\n",
       "      <td>272</td>\n",
       "      <td>5.400826</td>\n",
       "      <td>150000000</td>\n",
       "      <td>374218673</td>\n",
       "      <td>140</td>\n",
       "      <td>4914</td>\n",
       "      <td>7.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Following</th>\n",
       "      <td>11660</td>\n",
       "      <td>0.225908</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>69</td>\n",
       "      <td>151</td>\n",
       "      <td>7.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Insomnia</th>\n",
       "      <td>320</td>\n",
       "      <td>1.111488</td>\n",
       "      <td>46000000</td>\n",
       "      <td>113714830</td>\n",
       "      <td>118</td>\n",
       "      <td>564</td>\n",
       "      <td>6.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Doodlebug</th>\n",
       "      <td>43629</td>\n",
       "      <td>0.168542</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>47</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                           id  popularity     budget     revenue  runtime  \\\n",
       "original_title                                                              \n",
       "The Dark Knight           155    8.466668  185000000  1001921825      152   \n",
       "Interstellar           157336   24.949134  165000000   621752480      169   \n",
       "Inception               27205    9.363643  160000000   825500000      148   \n",
       "Memento                    77    3.095625    9000000    39723096      113   \n",
       "The Prestige             1124    2.582095   40000000   109676311      130   \n",
       "The Dark Knight Rises   49026    6.591277  250000000  1081041287      165   \n",
       "Batman Begins             272    5.400826  150000000   374218673      140   \n",
       "Following               11660    0.225908          0           0       69   \n",
       "Insomnia                  320    1.111488   46000000   113714830      118   \n",
       "Doodlebug               43629    0.168542          0           0        3   \n",
       "\n",
       "                       vote_count  vote_average  \n",
       "original_title                                   \n",
       "The Dark Knight              8432           8.1  \n",
       "Interstellar                 6498           8.0  \n",
       "Inception                    9767           7.9  \n",
       "Memento                      2144           7.9  \n",
       "The Prestige                 2519           7.8  \n",
       "The Dark Knight Rises        6723           7.5  \n",
       "Batman Begins                4914           7.3  \n",
       "Following                     151           7.1  \n",
       "Insomnia                      564           6.6  \n",
       "Doodlebug                      47           6.5  "
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies_clean[movies_clean.director == 'Christopher Nolan'].groupby(['original_title']).sum().sort_values(by=['vote_average'], ascending=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Top 3 movies for the top 3 directors? For \"Steven Spielberg\" his top 3 movies are the following:**\n",
    "- Schindler's List with rating of 8.1\n",
    "- Saving Private Ryan with rating of 7.7\n",
    "- Catch Me If You Can with rating of 7.6"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "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>id</th>\n",
       "      <th>popularity</th>\n",
       "      <th>budget</th>\n",
       "      <th>revenue</th>\n",
       "      <th>runtime</th>\n",
       "      <th>vote_count</th>\n",
       "      <th>vote_average</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>original_title</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Schindler's List</th>\n",
       "      <td>424</td>\n",
       "      <td>2.377288</td>\n",
       "      <td>22000000</td>\n",
       "      <td>321265768</td>\n",
       "      <td>195</td>\n",
       "      <td>2632</td>\n",
       "      <td>8.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Saving Private Ryan</th>\n",
       "      <td>857</td>\n",
       "      <td>2.170136</td>\n",
       "      <td>70000000</td>\n",
       "      <td>481840909</td>\n",
       "      <td>169</td>\n",
       "      <td>3396</td>\n",
       "      <td>7.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Catch Me If You Can</th>\n",
       "      <td>640</td>\n",
       "      <td>2.973115</td>\n",
       "      <td>52000000</td>\n",
       "      <td>352114312</td>\n",
       "      <td>141</td>\n",
       "      <td>2277</td>\n",
       "      <td>7.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The Color Purple</th>\n",
       "      <td>873</td>\n",
       "      <td>1.012186</td>\n",
       "      <td>15000000</td>\n",
       "      <td>146292009</td>\n",
       "      <td>154</td>\n",
       "      <td>168</td>\n",
       "      <td>7.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Raiders of the Lost Ark</th>\n",
       "      <td>85</td>\n",
       "      <td>4.578300</td>\n",
       "      <td>18000000</td>\n",
       "      <td>389925971</td>\n",
       "      <td>115</td>\n",
       "      <td>2506</td>\n",
       "      <td>7.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Indiana Jones and the Last Crusade</th>\n",
       "      <td>89</td>\n",
       "      <td>3.536655</td>\n",
       "      <td>48000000</td>\n",
       "      <td>474171806</td>\n",
       "      <td>127</td>\n",
       "      <td>2031</td>\n",
       "      <td>7.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Jurassic Park</th>\n",
       "      <td>329</td>\n",
       "      <td>2.204926</td>\n",
       "      <td>63000000</td>\n",
       "      <td>920100000</td>\n",
       "      <td>127</td>\n",
       "      <td>3169</td>\n",
       "      <td>7.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Jaws</th>\n",
       "      <td>578</td>\n",
       "      <td>2.563191</td>\n",
       "      <td>7000000</td>\n",
       "      <td>470654000</td>\n",
       "      <td>124</td>\n",
       "      <td>1415</td>\n",
       "      <td>7.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>E.T. the Extra-Terrestrial</th>\n",
       "      <td>601</td>\n",
       "      <td>2.900556</td>\n",
       "      <td>10500000</td>\n",
       "      <td>792910554</td>\n",
       "      <td>115</td>\n",
       "      <td>1830</td>\n",
       "      <td>7.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Bridge of Spies</th>\n",
       "      <td>296098</td>\n",
       "      <td>3.648210</td>\n",
       "      <td>40000000</td>\n",
       "      <td>162610473</td>\n",
       "      <td>141</td>\n",
       "      <td>1638</td>\n",
       "      <td>7.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The Terminal</th>\n",
       "      <td>594</td>\n",
       "      <td>1.682492</td>\n",
       "      <td>60000000</td>\n",
       "      <td>219417255</td>\n",
       "      <td>128</td>\n",
       "      <td>1131</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Duel</th>\n",
       "      <td>839</td>\n",
       "      <td>0.462681</td>\n",
       "      <td>450000</td>\n",
       "      <td>0</td>\n",
       "      <td>90</td>\n",
       "      <td>166</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Close Encounters of the Third Kind</th>\n",
       "      <td>840</td>\n",
       "      <td>1.104816</td>\n",
       "      <td>20000000</td>\n",
       "      <td>303788635</td>\n",
       "      <td>135</td>\n",
       "      <td>600</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>War Horse</th>\n",
       "      <td>57212</td>\n",
       "      <td>1.592819</td>\n",
       "      <td>66000000</td>\n",
       "      <td>177584879</td>\n",
       "      <td>146</td>\n",
       "      <td>611</td>\n",
       "      <td>6.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Indiana Jones and the Temple of Doom</th>\n",
       "      <td>87</td>\n",
       "      <td>2.556799</td>\n",
       "      <td>28000000</td>\n",
       "      <td>333000000</td>\n",
       "      <td>118</td>\n",
       "      <td>1735</td>\n",
       "      <td>6.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Empire of the Sun</th>\n",
       "      <td>10110</td>\n",
       "      <td>0.460550</td>\n",
       "      <td>38000000</td>\n",
       "      <td>0</td>\n",
       "      <td>153</td>\n",
       "      <td>285</td>\n",
       "      <td>6.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Minority Report</th>\n",
       "      <td>180</td>\n",
       "      <td>2.103595</td>\n",
       "      <td>102000000</td>\n",
       "      <td>358372926</td>\n",
       "      <td>145</td>\n",
       "      <td>1595</td>\n",
       "      <td>6.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Munich</th>\n",
       "      <td>612</td>\n",
       "      <td>0.869394</td>\n",
       "      <td>70000000</td>\n",
       "      <td>130358911</td>\n",
       "      <td>164</td>\n",
       "      <td>382</td>\n",
       "      <td>6.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The Adventures of Tintin</th>\n",
       "      <td>17578</td>\n",
       "      <td>2.234300</td>\n",
       "      <td>130000000</td>\n",
       "      <td>371940071</td>\n",
       "      <td>107</td>\n",
       "      <td>1448</td>\n",
       "      <td>6.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Amistad</th>\n",
       "      <td>11831</td>\n",
       "      <td>0.221360</td>\n",
       "      <td>36000000</td>\n",
       "      <td>74000000</td>\n",
       "      <td>155</td>\n",
       "      <td>167</td>\n",
       "      <td>6.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lincoln</th>\n",
       "      <td>72976</td>\n",
       "      <td>1.312488</td>\n",
       "      <td>65000000</td>\n",
       "      <td>275293450</td>\n",
       "      <td>149</td>\n",
       "      <td>993</td>\n",
       "      <td>6.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>A.I. Artificial Intelligence</th>\n",
       "      <td>644</td>\n",
       "      <td>2.971372</td>\n",
       "      <td>100000000</td>\n",
       "      <td>235926552</td>\n",
       "      <td>146</td>\n",
       "      <td>1133</td>\n",
       "      <td>6.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hook</th>\n",
       "      <td>879</td>\n",
       "      <td>2.326917</td>\n",
       "      <td>70000000</td>\n",
       "      <td>300854823</td>\n",
       "      <td>144</td>\n",
       "      <td>834</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The Sugarland Express</th>\n",
       "      <td>5121</td>\n",
       "      <td>0.415866</td>\n",
       "      <td>3000000</td>\n",
       "      <td>12800000</td>\n",
       "      <td>110</td>\n",
       "      <td>33</td>\n",
       "      <td>6.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The Lost World: Jurassic Park</th>\n",
       "      <td>330</td>\n",
       "      <td>0.210550</td>\n",
       "      <td>73000000</td>\n",
       "      <td>229074524</td>\n",
       "      <td>129</td>\n",
       "      <td>1655</td>\n",
       "      <td>6.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>War of the Worlds</th>\n",
       "      <td>74</td>\n",
       "      <td>1.844731</td>\n",
       "      <td>132000000</td>\n",
       "      <td>591739379</td>\n",
       "      <td>116</td>\n",
       "      <td>1238</td>\n",
       "      <td>5.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Always</th>\n",
       "      <td>11352</td>\n",
       "      <td>0.494235</td>\n",
       "      <td>31000000</td>\n",
       "      <td>74134790</td>\n",
       "      <td>122</td>\n",
       "      <td>68</td>\n",
       "      <td>5.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Indiana Jones and the Kingdom of the Crystal Skull</th>\n",
       "      <td>217</td>\n",
       "      <td>3.161670</td>\n",
       "      <td>185000000</td>\n",
       "      <td>786636033</td>\n",
       "      <td>122</td>\n",
       "      <td>1537</td>\n",
       "      <td>5.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1941</th>\n",
       "      <td>11519</td>\n",
       "      <td>0.387797</td>\n",
       "      <td>35000000</td>\n",
       "      <td>31755742</td>\n",
       "      <td>113</td>\n",
       "      <td>62</td>\n",
       "      <td>5.4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                        id  popularity  \\\n",
       "original_title                                                           \n",
       "Schindler's List                                       424    2.377288   \n",
       "Saving Private Ryan                                    857    2.170136   \n",
       "Catch Me If You Can                                    640    2.973115   \n",
       "The Color Purple                                       873    1.012186   \n",
       "Raiders of the Lost Ark                                 85    4.578300   \n",
       "Indiana Jones and the Last Crusade                      89    3.536655   \n",
       "Jurassic Park                                          329    2.204926   \n",
       "Jaws                                                   578    2.563191   \n",
       "E.T. the Extra-Terrestrial                             601    2.900556   \n",
       "Bridge of Spies                                     296098    3.648210   \n",
       "The Terminal                                           594    1.682492   \n",
       "Duel                                                   839    0.462681   \n",
       "Close Encounters of the Third Kind                     840    1.104816   \n",
       "War Horse                                            57212    1.592819   \n",
       "Indiana Jones and the Temple of Doom                    87    2.556799   \n",
       "Empire of the Sun                                    10110    0.460550   \n",
       "Minority Report                                        180    2.103595   \n",
       "Munich                                                 612    0.869394   \n",
       "The Adventures of Tintin                             17578    2.234300   \n",
       "Amistad                                              11831    0.221360   \n",
       "Lincoln                                              72976    1.312488   \n",
       "A.I. Artificial Intelligence                           644    2.971372   \n",
       "Hook                                                   879    2.326917   \n",
       "The Sugarland Express                                 5121    0.415866   \n",
       "The Lost World: Jurassic Park                          330    0.210550   \n",
       "War of the Worlds                                       74    1.844731   \n",
       "Always                                               11352    0.494235   \n",
       "Indiana Jones and the Kingdom of the Crystal Skull     217    3.161670   \n",
       "1941                                                 11519    0.387797   \n",
       "\n",
       "                                                       budget    revenue  \\\n",
       "original_title                                                             \n",
       "Schindler's List                                     22000000  321265768   \n",
       "Saving Private Ryan                                  70000000  481840909   \n",
       "Catch Me If You Can                                  52000000  352114312   \n",
       "The Color Purple                                     15000000  146292009   \n",
       "Raiders of the Lost Ark                              18000000  389925971   \n",
       "Indiana Jones and the Last Crusade                   48000000  474171806   \n",
       "Jurassic Park                                        63000000  920100000   \n",
       "Jaws                                                  7000000  470654000   \n",
       "E.T. the Extra-Terrestrial                           10500000  792910554   \n",
       "Bridge of Spies                                      40000000  162610473   \n",
       "The Terminal                                         60000000  219417255   \n",
       "Duel                                                   450000          0   \n",
       "Close Encounters of the Third Kind                   20000000  303788635   \n",
       "War Horse                                            66000000  177584879   \n",
       "Indiana Jones and the Temple of Doom                 28000000  333000000   \n",
       "Empire of the Sun                                    38000000          0   \n",
       "Minority Report                                     102000000  358372926   \n",
       "Munich                                               70000000  130358911   \n",
       "The Adventures of Tintin                            130000000  371940071   \n",
       "Amistad                                              36000000   74000000   \n",
       "Lincoln                                              65000000  275293450   \n",
       "A.I. Artificial Intelligence                        100000000  235926552   \n",
       "Hook                                                 70000000  300854823   \n",
       "The Sugarland Express                                 3000000   12800000   \n",
       "The Lost World: Jurassic Park                        73000000  229074524   \n",
       "War of the Worlds                                   132000000  591739379   \n",
       "Always                                               31000000   74134790   \n",
       "Indiana Jones and the Kingdom of the Crystal Skull  185000000  786636033   \n",
       "1941                                                 35000000   31755742   \n",
       "\n",
       "                                                    runtime  vote_count  \\\n",
       "original_title                                                            \n",
       "Schindler's List                                        195        2632   \n",
       "Saving Private Ryan                                     169        3396   \n",
       "Catch Me If You Can                                     141        2277   \n",
       "The Color Purple                                        154         168   \n",
       "Raiders of the Lost Ark                                 115        2506   \n",
       "Indiana Jones and the Last Crusade                      127        2031   \n",
       "Jurassic Park                                           127        3169   \n",
       "Jaws                                                    124        1415   \n",
       "E.T. the Extra-Terrestrial                              115        1830   \n",
       "Bridge of Spies                                         141        1638   \n",
       "The Terminal                                            128        1131   \n",
       "Duel                                                     90         166   \n",
       "Close Encounters of the Third Kind                      135         600   \n",
       "War Horse                                               146         611   \n",
       "Indiana Jones and the Temple of Doom                    118        1735   \n",
       "Empire of the Sun                                       153         285   \n",
       "Minority Report                                         145        1595   \n",
       "Munich                                                  164         382   \n",
       "The Adventures of Tintin                                107        1448   \n",
       "Amistad                                                 155         167   \n",
       "Lincoln                                                 149         993   \n",
       "A.I. Artificial Intelligence                            146        1133   \n",
       "Hook                                                    144         834   \n",
       "The Sugarland Express                                   110          33   \n",
       "The Lost World: Jurassic Park                           129        1655   \n",
       "War of the Worlds                                       116        1238   \n",
       "Always                                                  122          68   \n",
       "Indiana Jones and the Kingdom of the Crystal Skull      122        1537   \n",
       "1941                                                    113          62   \n",
       "\n",
       "                                                    vote_average  \n",
       "original_title                                                    \n",
       "Schindler's List                                             8.1  \n",
       "Saving Private Ryan                                          7.7  \n",
       "Catch Me If You Can                                          7.6  \n",
       "The Color Purple                                             7.5  \n",
       "Raiders of the Lost Ark                                      7.5  \n",
       "Indiana Jones and the Last Crusade                           7.4  \n",
       "Jurassic Park                                                7.4  \n",
       "Jaws                                                         7.3  \n",
       "E.T. the Extra-Terrestrial                                   7.2  \n",
       "Bridge of Spies                                              7.1  \n",
       "The Terminal                                                 7.0  \n",
       "Duel                                                         7.0  \n",
       "Close Encounters of the Third Kind                           7.0  \n",
       "War Horse                                                    6.9  \n",
       "Indiana Jones and the Temple of Doom                         6.9  \n",
       "Empire of the Sun                                            6.9  \n",
       "Minority Report                                              6.9  \n",
       "Munich                                                       6.7  \n",
       "The Adventures of Tintin                                     6.6  \n",
       "Amistad                                                      6.6  \n",
       "Lincoln                                                      6.6  \n",
       "A.I. Artificial Intelligence                                 6.6  \n",
       "Hook                                                         6.5  \n",
       "The Sugarland Express                                        6.1  \n",
       "The Lost World: Jurassic Park                                6.1  \n",
       "War of the Worlds                                            5.9  \n",
       "Always                                                       5.8  \n",
       "Indiana Jones and the Kingdom of the Crystal Skull           5.6  \n",
       "1941                                                         5.4  "
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies_clean[movies_clean.director == 'Steven Spielberg'].groupby(['original_title']).sum().sort_values(by=['vote_average'], ascending=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Top 3 movies for the top 3 directors? For \"Peter Jackson\" his top 3 movies are the following:**\n",
    "- The Lord of the Rings: The Return of the King with rating of 7.9\n",
    "- The Lord of the Rings: The Fellowship of the Ring\t with rating of 7.8\n",
    "- The Lord of the Rings: The Two Towers with rating of 7.8"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "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>id</th>\n",
       "      <th>popularity</th>\n",
       "      <th>budget</th>\n",
       "      <th>revenue</th>\n",
       "      <th>runtime</th>\n",
       "      <th>vote_count</th>\n",
       "      <th>vote_average</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>original_title</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>The Lord of the Rings: The Return of the King</th>\n",
       "      <td>122</td>\n",
       "      <td>7.122455</td>\n",
       "      <td>94000000</td>\n",
       "      <td>1118888979</td>\n",
       "      <td>201</td>\n",
       "      <td>5636</td>\n",
       "      <td>7.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The Lord of the Rings: The Fellowship of the Ring</th>\n",
       "      <td>120</td>\n",
       "      <td>8.575419</td>\n",
       "      <td>93000000</td>\n",
       "      <td>871368364</td>\n",
       "      <td>178</td>\n",
       "      <td>6079</td>\n",
       "      <td>7.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The Lord of the Rings: The Two Towers</th>\n",
       "      <td>121</td>\n",
       "      <td>8.095275</td>\n",
       "      <td>79000000</td>\n",
       "      <td>926287400</td>\n",
       "      <td>179</td>\n",
       "      <td>5114</td>\n",
       "      <td>7.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The Hobbit: The Desolation of Smaug</th>\n",
       "      <td>57158</td>\n",
       "      <td>4.310786</td>\n",
       "      <td>250000000</td>\n",
       "      <td>958400000</td>\n",
       "      <td>161</td>\n",
       "      <td>2952</td>\n",
       "      <td>7.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Braindead</th>\n",
       "      <td>763</td>\n",
       "      <td>0.766646</td>\n",
       "      <td>3000000</td>\n",
       "      <td>242623</td>\n",
       "      <td>104</td>\n",
       "      <td>166</td>\n",
       "      <td>7.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The Hobbit: The Battle of the Five Armies</th>\n",
       "      <td>122917</td>\n",
       "      <td>10.174599</td>\n",
       "      <td>250000000</td>\n",
       "      <td>955119788</td>\n",
       "      <td>144</td>\n",
       "      <td>3110</td>\n",
       "      <td>7.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The Hobbit: An Unexpected Journey</th>\n",
       "      <td>49051</td>\n",
       "      <td>4.218933</td>\n",
       "      <td>250000000</td>\n",
       "      <td>1017003568</td>\n",
       "      <td>169</td>\n",
       "      <td>6417</td>\n",
       "      <td>6.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Heavenly Creatures</th>\n",
       "      <td>1024</td>\n",
       "      <td>0.834029</td>\n",
       "      <td>5000000</td>\n",
       "      <td>3049135</td>\n",
       "      <td>99</td>\n",
       "      <td>149</td>\n",
       "      <td>6.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The Lovely Bones</th>\n",
       "      <td>7980</td>\n",
       "      <td>1.673879</td>\n",
       "      <td>65000000</td>\n",
       "      <td>93525586</td>\n",
       "      <td>136</td>\n",
       "      <td>600</td>\n",
       "      <td>6.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>The Frighteners</th>\n",
       "      <td>10779</td>\n",
       "      <td>0.923851</td>\n",
       "      <td>30000000</td>\n",
       "      <td>29359216</td>\n",
       "      <td>110</td>\n",
       "      <td>184</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>King Kong</th>\n",
       "      <td>254</td>\n",
       "      <td>1.508329</td>\n",
       "      <td>207000000</td>\n",
       "      <td>550000000</td>\n",
       "      <td>187</td>\n",
       "      <td>1289</td>\n",
       "      <td>6.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Bad Taste</th>\n",
       "      <td>9964</td>\n",
       "      <td>0.606128</td>\n",
       "      <td>25710</td>\n",
       "      <td>0</td>\n",
       "      <td>91</td>\n",
       "      <td>74</td>\n",
       "      <td>6.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Meet the Feebles</th>\n",
       "      <td>8216</td>\n",
       "      <td>0.257575</td>\n",
       "      <td>750000</td>\n",
       "      <td>0</td>\n",
       "      <td>94</td>\n",
       "      <td>26</td>\n",
       "      <td>6.2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                       id  popularity  \\\n",
       "original_title                                                          \n",
       "The Lord of the Rings: The Return of the King         122    7.122455   \n",
       "The Lord of the Rings: The Fellowship of the Ring     120    8.575419   \n",
       "The Lord of the Rings: The Two Towers                 121    8.095275   \n",
       "The Hobbit: The Desolation of Smaug                 57158    4.310786   \n",
       "Braindead                                             763    0.766646   \n",
       "The Hobbit: The Battle of the Five Armies          122917   10.174599   \n",
       "The Hobbit: An Unexpected Journey                   49051    4.218933   \n",
       "Heavenly Creatures                                   1024    0.834029   \n",
       "The Lovely Bones                                     7980    1.673879   \n",
       "The Frighteners                                     10779    0.923851   \n",
       "King Kong                                             254    1.508329   \n",
       "Bad Taste                                            9964    0.606128   \n",
       "Meet the Feebles                                     8216    0.257575   \n",
       "\n",
       "                                                      budget     revenue  \\\n",
       "original_title                                                             \n",
       "The Lord of the Rings: The Return of the King       94000000  1118888979   \n",
       "The Lord of the Rings: The Fellowship of the Ring   93000000   871368364   \n",
       "The Lord of the Rings: The Two Towers               79000000   926287400   \n",
       "The Hobbit: The Desolation of Smaug                250000000   958400000   \n",
       "Braindead                                            3000000      242623   \n",
       "The Hobbit: The Battle of the Five Armies          250000000   955119788   \n",
       "The Hobbit: An Unexpected Journey                  250000000  1017003568   \n",
       "Heavenly Creatures                                   5000000     3049135   \n",
       "The Lovely Bones                                    65000000    93525586   \n",
       "The Frighteners                                     30000000    29359216   \n",
       "King Kong                                          207000000   550000000   \n",
       "Bad Taste                                              25710           0   \n",
       "Meet the Feebles                                      750000           0   \n",
       "\n",
       "                                                   runtime  vote_count  \\\n",
       "original_title                                                           \n",
       "The Lord of the Rings: The Return of the King          201        5636   \n",
       "The Lord of the Rings: The Fellowship of the Ring      178        6079   \n",
       "The Lord of the Rings: The Two Towers                  179        5114   \n",
       "The Hobbit: The Desolation of Smaug                    161        2952   \n",
       "Braindead                                              104         166   \n",
       "The Hobbit: The Battle of the Five Armies              144        3110   \n",
       "The Hobbit: An Unexpected Journey                      169        6417   \n",
       "Heavenly Creatures                                      99         149   \n",
       "The Lovely Bones                                       136         600   \n",
       "The Frighteners                                        110         184   \n",
       "King Kong                                              187        1289   \n",
       "Bad Taste                                               91          74   \n",
       "Meet the Feebles                                        94          26   \n",
       "\n",
       "                                                   vote_average  \n",
       "original_title                                                   \n",
       "The Lord of the Rings: The Return of the King               7.9  \n",
       "The Lord of the Rings: The Fellowship of the Ring           7.8  \n",
       "The Lord of the Rings: The Two Towers                       7.8  \n",
       "The Hobbit: The Desolation of Smaug                         7.6  \n",
       "Braindead                                                   7.4  \n",
       "The Hobbit: The Battle of the Five Armies                   7.1  \n",
       "The Hobbit: An Unexpected Journey                           6.9  \n",
       "Heavenly Creatures                                          6.6  \n",
       "The Lovely Bones                                            6.6  \n",
       "The Frighteners                                             6.5  \n",
       "King Kong                                                   6.4  \n",
       "Bad Taste                                                   6.2  \n",
       "Meet the Feebles                                            6.2  "
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies_clean[movies_clean.director == 'Peter Jackson'].groupby(['original_title']).sum().sort_values(by=['vote_average'], ascending=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Highest movie budget? Here we can see it's the movie \"Pirates of the Caribbean: On Stranger Tides\" with a budget of 380,000,000$**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "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>id</th>\n",
       "      <th>imdb_id</th>\n",
       "      <th>popularity</th>\n",
       "      <th>budget</th>\n",
       "      <th>revenue</th>\n",
       "      <th>original_title</th>\n",
       "      <th>cast</th>\n",
       "      <th>homepage</th>\n",
       "      <th>director</th>\n",
       "      <th>tagline</th>\n",
       "      <th>keywords</th>\n",
       "      <th>overview</th>\n",
       "      <th>runtime</th>\n",
       "      <th>genres</th>\n",
       "      <th>production_companies</th>\n",
       "      <th>release_date</th>\n",
       "      <th>vote_count</th>\n",
       "      <th>vote_average</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3374</th>\n",
       "      <td>1865</td>\n",
       "      <td>tt1298650</td>\n",
       "      <td>4.95513</td>\n",
       "      <td>380000000</td>\n",
       "      <td>1021683000</td>\n",
       "      <td>Pirates of the Caribbean: On Stranger Tides</td>\n",
       "      <td>Johnny Depp|PenÃ©lope Cruz|Geoffrey Rush|Ian M...</td>\n",
       "      <td>http://disney.go.com/pirates/index-on-stranger...</td>\n",
       "      <td>Rob Marshall</td>\n",
       "      <td>Live Forever Or Die Trying.</td>\n",
       "      <td>sea|captain|mutiny|sword|prime minister</td>\n",
       "      <td>Captain Jack Sparrow crosses paths with a woma...</td>\n",
       "      <td>136</td>\n",
       "      <td>Adventure|Action|Fantasy</td>\n",
       "      <td>Walt Disney Pictures|Jerry Bruckheimer Films|M...</td>\n",
       "      <td>2011-05-11</td>\n",
       "      <td>3180</td>\n",
       "      <td>6.3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        id    imdb_id  popularity     budget     revenue  \\\n",
       "3374  1865  tt1298650     4.95513  380000000  1021683000   \n",
       "\n",
       "                                   original_title  \\\n",
       "3374  Pirates of the Caribbean: On Stranger Tides   \n",
       "\n",
       "                                                   cast  \\\n",
       "3374  Johnny Depp|PenÃ©lope Cruz|Geoffrey Rush|Ian M...   \n",
       "\n",
       "                                               homepage      director  \\\n",
       "3374  http://disney.go.com/pirates/index-on-stranger...  Rob Marshall   \n",
       "\n",
       "                          tagline                                 keywords  \\\n",
       "3374  Live Forever Or Die Trying.  sea|captain|mutiny|sword|prime minister   \n",
       "\n",
       "                                               overview  runtime  \\\n",
       "3374  Captain Jack Sparrow crosses paths with a woma...      136   \n",
       "\n",
       "                        genres  \\\n",
       "3374  Adventure|Action|Fantasy   \n",
       "\n",
       "                                   production_companies release_date  \\\n",
       "3374  Walt Disney Pictures|Jerry Bruckheimer Films|M...   2011-05-11   \n",
       "\n",
       "      vote_count  vote_average  \n",
       "3374        3180           6.3  "
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies_clean[movies_clean.budget == movies_clean.budget.max()]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Longest movie runtime? it's the movie \"The Story of Film: An Odyssey\" with a runtime of 15 hours.**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "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>id</th>\n",
       "      <th>imdb_id</th>\n",
       "      <th>popularity</th>\n",
       "      <th>budget</th>\n",
       "      <th>revenue</th>\n",
       "      <th>original_title</th>\n",
       "      <th>cast</th>\n",
       "      <th>homepage</th>\n",
       "      <th>director</th>\n",
       "      <th>tagline</th>\n",
       "      <th>keywords</th>\n",
       "      <th>overview</th>\n",
       "      <th>runtime</th>\n",
       "      <th>genres</th>\n",
       "      <th>production_companies</th>\n",
       "      <th>release_date</th>\n",
       "      <th>vote_count</th>\n",
       "      <th>vote_average</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3893</th>\n",
       "      <td>125336</td>\n",
       "      <td>tt2044056</td>\n",
       "      <td>0.006925</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>The Story of Film: An Odyssey</td>\n",
       "      <td>Mark Cousins|Jean-Michel Frodon|Cari Beauchamp...</td>\n",
       "      <td>http://www.channel4.com/programmes/the-story-o...</td>\n",
       "      <td>Mark Cousins</td>\n",
       "      <td>NaN</td>\n",
       "      <td>cinema|nouvelle vague|hindi cinema|cinema novo...</td>\n",
       "      <td>The Story of Film: An Odyssey, written and dir...</td>\n",
       "      <td>900</td>\n",
       "      <td>Documentary</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2011-09-03</td>\n",
       "      <td>14</td>\n",
       "      <td>9.2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          id    imdb_id  popularity  budget  revenue  \\\n",
       "3893  125336  tt2044056    0.006925       0        0   \n",
       "\n",
       "                     original_title  \\\n",
       "3893  The Story of Film: An Odyssey   \n",
       "\n",
       "                                                   cast  \\\n",
       "3893  Mark Cousins|Jean-Michel Frodon|Cari Beauchamp...   \n",
       "\n",
       "                                               homepage      director tagline  \\\n",
       "3893  http://www.channel4.com/programmes/the-story-o...  Mark Cousins     NaN   \n",
       "\n",
       "                                               keywords  \\\n",
       "3893  cinema|nouvelle vague|hindi cinema|cinema novo...   \n",
       "\n",
       "                                               overview  runtime       genres  \\\n",
       "3893  The Story of Film: An Odyssey, written and dir...      900  Documentary   \n",
       "\n",
       "     production_companies release_date  vote_count  vote_average  \n",
       "3893                  NaN   2011-09-03          14           9.2  "
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies_clean[movies_clean.runtime == movies_clean.runtime.max()]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Most famous Genres? Here we can see that \"Comedy\" is the most Genre as it has a total vote count of 100806, then followed by \"Drama\" with a total vote count of 97204**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "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>id</th>\n",
       "      <th>popularity</th>\n",
       "      <th>budget</th>\n",
       "      <th>revenue</th>\n",
       "      <th>runtime</th>\n",
       "      <th>vote_count</th>\n",
       "      <th>vote_average</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>genres</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Comedy</th>\n",
       "      <td>48950395</td>\n",
       "      <td>375.247922</td>\n",
       "      <td>6771216919</td>\n",
       "      <td>20323889661</td>\n",
       "      <td>66346</td>\n",
       "      <td>100806</td>\n",
       "      <td>4151.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Drama</th>\n",
       "      <td>61905013</td>\n",
       "      <td>361.127929</td>\n",
       "      <td>5787292732</td>\n",
       "      <td>15107533347</td>\n",
       "      <td>79537</td>\n",
       "      <td>97204</td>\n",
       "      <td>4499.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Adventure|Fantasy|Action</th>\n",
       "      <td>253738</td>\n",
       "      <td>57.045550</td>\n",
       "      <td>1776900000</td>\n",
       "      <td>7597483556</td>\n",
       "      <td>2139</td>\n",
       "      <td>41063</td>\n",
       "      <td>101.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Drama|Romance</th>\n",
       "      <td>11588949</td>\n",
       "      <td>161.440368</td>\n",
       "      <td>2703887169</td>\n",
       "      <td>6798112125</td>\n",
       "      <td>32671</td>\n",
       "      <td>40579</td>\n",
       "      <td>1810.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Comedy|Romance</th>\n",
       "      <td>11238921</td>\n",
       "      <td>159.129492</td>\n",
       "      <td>3413566906</td>\n",
       "      <td>11545724341</td>\n",
       "      <td>26918</td>\n",
       "      <td>39780</td>\n",
       "      <td>1556.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TV Movie|Horror|Mystery</th>\n",
       "      <td>30931</td>\n",
       "      <td>0.089413</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>96</td>\n",
       "      <td>10</td>\n",
       "      <td>4.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Action|Adventure|Foreign|Thriller</th>\n",
       "      <td>35153</td>\n",
       "      <td>0.583302</td>\n",
       "      <td>4500000</td>\n",
       "      <td>0</td>\n",
       "      <td>102</td>\n",
       "      <td>10</td>\n",
       "      <td>4.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Drama|Action|Science Fiction|Thriller</th>\n",
       "      <td>55281</td>\n",
       "      <td>0.235312</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>90</td>\n",
       "      <td>10</td>\n",
       "      <td>3.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Action|Comedy|Mystery|Romance|Thriller</th>\n",
       "      <td>19900</td>\n",
       "      <td>0.125174</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>92</td>\n",
       "      <td>10</td>\n",
       "      <td>5.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Comedy|Thriller|Crime|Romance</th>\n",
       "      <td>28121</td>\n",
       "      <td>0.028143</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>108</td>\n",
       "      <td>10</td>\n",
       "      <td>6.3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2039 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              id  popularity      budget  \\\n",
       "genres                                                                     \n",
       "Comedy                                  48950395  375.247922  6771216919   \n",
       "Drama                                   61905013  361.127929  5787292732   \n",
       "Adventure|Fantasy|Action                  253738   57.045550  1776900000   \n",
       "Drama|Romance                           11588949  161.440368  2703887169   \n",
       "Comedy|Romance                          11238921  159.129492  3413566906   \n",
       "...                                          ...         ...         ...   \n",
       "TV Movie|Horror|Mystery                    30931    0.089413           0   \n",
       "Action|Adventure|Foreign|Thriller          35153    0.583302     4500000   \n",
       "Drama|Action|Science Fiction|Thriller      55281    0.235312           0   \n",
       "Action|Comedy|Mystery|Romance|Thriller     19900    0.125174           0   \n",
       "Comedy|Thriller|Crime|Romance              28121    0.028143           0   \n",
       "\n",
       "                                            revenue  runtime  vote_count  \\\n",
       "genres                                                                     \n",
       "Comedy                                  20323889661    66346      100806   \n",
       "Drama                                   15107533347    79537       97204   \n",
       "Adventure|Fantasy|Action                 7597483556     2139       41063   \n",
       "Drama|Romance                            6798112125    32671       40579   \n",
       "Comedy|Romance                          11545724341    26918       39780   \n",
       "...                                             ...      ...         ...   \n",
       "TV Movie|Horror|Mystery                           0       96          10   \n",
       "Action|Adventure|Foreign|Thriller                 0      102          10   \n",
       "Drama|Action|Science Fiction|Thriller             0       90          10   \n",
       "Action|Comedy|Mystery|Romance|Thriller            0       92          10   \n",
       "Comedy|Thriller|Crime|Romance                     0      108          10   \n",
       "\n",
       "                                        vote_average  \n",
       "genres                                                \n",
       "Comedy                                        4151.0  \n",
       "Drama                                         4499.8  \n",
       "Adventure|Fantasy|Action                       101.6  \n",
       "Drama|Romance                                 1810.8  \n",
       "Comedy|Romance                                1556.2  \n",
       "...                                              ...  \n",
       "TV Movie|Horror|Mystery                          4.6  \n",
       "Action|Adventure|Foreign|Thriller                4.8  \n",
       "Drama|Action|Science Fiction|Thriller            3.5  \n",
       "Action|Comedy|Mystery|Romance|Thriller           5.2  \n",
       "Comedy|Thriller|Crime|Romance                    6.3  \n",
       "\n",
       "[2039 rows x 7 columns]"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies_clean.groupby(['genres']).sum().sort_values(by=['vote_count'], ascending=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Top Movies for each Genre? Here we can see each famous movie for each genre**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "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>original_title</th>\n",
       "      <th>vote_count</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>genres</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Action</th>\n",
       "      <td>í˜•ì‚¬ Duelist</td>\n",
       "      <td>2349</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Action|Adventure</th>\n",
       "      <td>The Quest</td>\n",
       "      <td>1215</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Action|Adventure|Animation</th>\n",
       "      <td>Tekkon kinkurÃ®to</td>\n",
       "      <td>142</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Action|Adventure|Animation|Comedy|Drama</th>\n",
       "      <td>Everyone's Hero</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Action|Adventure|Animation|Comedy|Family</th>\n",
       "      <td>VeggieTales: Jonah</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Western|Drama|Crime|Romance</th>\n",
       "      <td>Ain't Them Bodies Saints</td>\n",
       "      <td>91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Western|History</th>\n",
       "      <td>The Long Riders</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Western|History|War</th>\n",
       "      <td>The Alamo</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Western|Horror|Thriller</th>\n",
       "      <td>From Dusk Till Dawn 3: The Hangman's Daughter</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Western|Thriller</th>\n",
       "      <td>Sweetwater</td>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2039 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                         original_title  \\\n",
       "genres                                                                                    \n",
       "Action                                                                   í˜•ì‚¬ Duelist   \n",
       "Action|Adventure                                                              The Quest   \n",
       "Action|Adventure|Animation                                            Tekkon kinkurÃ®to   \n",
       "Action|Adventure|Animation|Comedy|Drama                                 Everyone's Hero   \n",
       "Action|Adventure|Animation|Comedy|Family                             VeggieTales: Jonah   \n",
       "...                                                                                 ...   \n",
       "Western|Drama|Crime|Romance                                    Ain't Them Bodies Saints   \n",
       "Western|History                                                         The Long Riders   \n",
       "Western|History|War                                                           The Alamo   \n",
       "Western|Horror|Thriller                   From Dusk Till Dawn 3: The Hangman's Daughter   \n",
       "Western|Thriller                                                             Sweetwater   \n",
       "\n",
       "                                          vote_count  \n",
       "genres                                                \n",
       "Action                                          2349  \n",
       "Action|Adventure                                1215  \n",
       "Action|Adventure|Animation                       142  \n",
       "Action|Adventure|Animation|Comedy|Drama           30  \n",
       "Action|Adventure|Animation|Comedy|Family          17  \n",
       "...                                              ...  \n",
       "Western|Drama|Crime|Romance                       91  \n",
       "Western|History                                   17  \n",
       "Western|History|War                               60  \n",
       "Western|Horror|Thriller                           44  \n",
       "Western|Thriller                                  41  \n",
       "\n",
       "[2039 rows x 2 columns]"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies_clean[['original_title','genres','vote_count']].groupby(['genres']).max()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Most popular movie? top popular movie is \"Jurassic World\" with a popularity rating of 32.98**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "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>id</th>\n",
       "      <th>imdb_id</th>\n",
       "      <th>popularity</th>\n",
       "      <th>budget</th>\n",
       "      <th>revenue</th>\n",
       "      <th>original_title</th>\n",
       "      <th>cast</th>\n",
       "      <th>homepage</th>\n",
       "      <th>director</th>\n",
       "      <th>tagline</th>\n",
       "      <th>keywords</th>\n",
       "      <th>overview</th>\n",
       "      <th>runtime</th>\n",
       "      <th>genres</th>\n",
       "      <th>production_companies</th>\n",
       "      <th>release_date</th>\n",
       "      <th>vote_count</th>\n",
       "      <th>vote_average</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>135397</td>\n",
       "      <td>tt0369610</td>\n",
       "      <td>32.985763</td>\n",
       "      <td>150000000</td>\n",
       "      <td>1513528810</td>\n",
       "      <td>Jurassic World</td>\n",
       "      <td>Chris Pratt|Bryce Dallas Howard|Irrfan Khan|Vi...</td>\n",
       "      <td>http://www.jurassicworld.com/</td>\n",
       "      <td>Colin Trevorrow</td>\n",
       "      <td>The park is open.</td>\n",
       "      <td>monster|dna|tyrannosaurus rex|velociraptor|island</td>\n",
       "      <td>Twenty-two years after the events of Jurassic ...</td>\n",
       "      <td>124</td>\n",
       "      <td>Action|Adventure|Science Fiction|Thriller</td>\n",
       "      <td>Universal Studios|Amblin Entertainment|Legenda...</td>\n",
       "      <td>2015-06-09</td>\n",
       "      <td>5562</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       id    imdb_id  popularity     budget     revenue  original_title  \\\n",
       "0  135397  tt0369610   32.985763  150000000  1513528810  Jurassic World   \n",
       "\n",
       "                                                cast  \\\n",
       "0  Chris Pratt|Bryce Dallas Howard|Irrfan Khan|Vi...   \n",
       "\n",
       "                        homepage         director            tagline  \\\n",
       "0  http://www.jurassicworld.com/  Colin Trevorrow  The park is open.   \n",
       "\n",
       "                                            keywords  \\\n",
       "0  monster|dna|tyrannosaurus rex|velociraptor|island   \n",
       "\n",
       "                                            overview  runtime  \\\n",
       "0  Twenty-two years after the events of Jurassic ...      124   \n",
       "\n",
       "                                      genres  \\\n",
       "0  Action|Adventure|Science Fiction|Thriller   \n",
       "\n",
       "                                production_companies release_date  vote_count  \\\n",
       "0  Universal Studios|Amblin Entertainment|Legenda...   2015-06-09        5562   \n",
       "\n",
       "   vote_average  \n",
       "0           6.5  "
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies_clean[movies_clean.popularity == movies_clean.popularity.max()]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Does the production of movies increase or decrease? as you can see here, the movie production increases each year**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [],
   "source": [
    "def plot_timeseries(axes, x, y, color, xlabel, ylabel):\n",
    "    axes.plot(x, y, color = color)\n",
    "    axes.set_xlabel(xlabel)\n",
    "    axes.set_ylabel(ylabel, color = color)\n",
    "    axes.tick_params('y', colors = color)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYQAAAEGCAYAAABlxeIAAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuMSwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/d3fzzAAAACXBIWXMAAAsTAAALEwEAmpwYAABDuElEQVR4nO29eXxU1d34//7MHrKZzYCiqIjgUleqfWpdkSqKYrFWtCoiYvsUl1btU7F9tJt162Ndqr9+a3Gpa11qQcQFad0KagtVK8imGKCQkI2sM5nJ5Pz+uDdhCJlkksx2z5z36zWvmTn3zp3z5oT7mbOLUgqDwWAwGFyZzoDBYDAYsgMTEAwGg8EAmIBgMBgMBhsTEAwGg8EAmIBgMBgMBhsTEAwGg8EAgCfTGRgOb775pvL7/ZnOhsFgMDiK9vb2ukmTJlX0Tnd0QPD7/UyYMGFIn62qqmLMmDFJzlF2oLMb6O1n3JyLk/xWrlxZ1Vd6zjYZeb3eTGchZejsBnr7GTfnooNfzgaE4uLiTGchZejsBnr7GTfnooNfzgaEurq6TGchZejsBnr7GTfnooNfzgYEHaJ5PHR2A739jJtz0cEvLQFBhPEifBjzaBbh+yKUirBEhPX2c0nMZ+aJsEGEtSKcnuw8hcPhZF8ya9DZDfT2M27ORQe/tAQEpVirFEcqxZHAMUA78CJwI7BUKcYBS+33iHAIMAM4FDgDeFAEdzLzFAwGk3m5rEJnN9Dbz7g5Fx38MtFkNAn4TCmqgGnAY3b6Y8C59utpwDNK0aEUG4ENwLHJzMTIkSOTebmsQmc30NvPuDmXVPj95z9CU5Mk/brxyERAmAE8bb+uVIptAPbznnb63sDmmM9ssdOSRnV1dTIvl1Xo7AZ6+xk355Jsv6oqF1/5SjHf/GZBUq/bH2mdmCaCDzgHmDfQqX2k7baTz/btitmz/Xg8HqLRKNOn1zF3rpfq6mry8/Nxu900NzdTUVFBQ0MDSikqKiqoqakhEolQX19Pa2srlZWV1NbWIiKUlpZSW1tLUVER0WiUtrY2Ro4cSXV1NV6vl+LiYurq6iguLiYcDhMMBnuO+3w+CgsLqa+vp6SkhGAwSCgU6jkeCATIy8ujsbGRsrIyWlpaCIfDPcfz8vLw+Xw0NTVRXl5OU1MTkUik5/hATgUF1h9Oa2sroVBIO6fucmpvb6e9vV0rp+5yam1tpbGxUSun7nIKh8NUVVVp5RRbTq2trWzdujVpTvfeO5a2NmHFCg8bN0ZwubYmzSnujTedO6aJMA2YqxRft9+vBU5Wim0ijALeVIrxIlbAUIrb7PNeA36qFMtjr7d8+XI11JnKra2tA/7jOBWd3UBvP+PmXJLp19AgHH54Me3t1m/jBx5o48ILk9dpvXLlyhWTJk2a2Ds93U1GF7KzuQhgITDTfj0TWBCTPkMEvwj7A+OAD5KZkfr6+mReLqvQ2Q309jNuziWZfvPn+2lvF/x+6wf722+npzEnbQFBhBHAZODPMcm3A5NFWG8fux1AKVYBzwKrgVexahXRZOanpKRk4JMcis5uoLefcXMuyfILBuGhh6xFO3/2M2vk0ltveUlHY07aAoJStCtFmVI0xaTVK8UkpRhnPzfEHLtVKcYqxXileCXZ+dFhiFg8dHYDvf2Mm3NJlt+f/uSjrs7FEUd0MmdOB3vu2UV1tYt161J/u87ZmcqhUCjTWUgZOruB3n7Gzbkkwy8ahQceCABw1VUhRODEEyOAVUtINTkbEHQeE62zG+jtZ9ycSzL8XnnFy2efudl33yjTplmB4KSTOoH09CPkbEDQeUy0zm6gt59xcy7J8Lv/fqt28N//3YHHvv+fdJIVGN55x0tn57C/ol9yNiAEAoFMZyFl6OwGevsZN+cyXL/33nPzj3942GOPLr797Y6e9NGjFWPHRmlpET78MKkr+OxGzgaEvLy8TGchZejsBnr7GTfnMly/3/7WCiizZ3fQezrDiSdaVYNU9yPkbEBobGzMdBZShs5uoLefcXMuw/Fbv97FK6948fsVc+Z07Ha8u9ko1f0IORsQysrKMp2FlKGzG+jtZ9ycy3D8HnrIj1LCBReE2XPP3SccnHBCJyKK99/30N4+nFz2T84GhJaWlkxnIWXo7AZ6+xk35zIcvyVLrKagSy7ZvXYAUFKiOOKIKOGw8P77qasl5GxA0GEzi3jo7AZ6+xk35zJUvy++cFFV5aa4uIsjj4y/IEM6+hFyNiDoPCZaZzfQ28+4OZeh+r31lvWL/4QTOnH3M4goHf0IORsQdB4TrbMb6O1n3JzLUP26f/F3T0CLx3HHdeLzKT76yE1DQ2o2zcnZgKDzEDid3UBvP+PmXIbi19W18xd/dw0gHiNGWEFBKeGdd1JTS8jZgODz+TKdhZShsxvo7WfcnMtQ/FatctPQ4GKvvboYO7ZrwPO7+xHefjs1/Qg5GxCampoGPsmh6OwGevsZN+cyFL8339xZO5AEWoG6axHd/Q7JJmcDQnl5eaazkDJ0dgO9/YybcxmKX/cv/YH6D7o58sgohYWKzz93s3lz8m/fORsQdP61orMb6O1n3JzLYP3CYVi+3Pql373E9UB4PHDCCamrJaRnX7YsJBJJrACciM5uoLefcXMug/X75z89tLcL48dHGTky8e3QJk+O0NYmlJcnfwu1nA0IOo+J1tkN9PYzbs5lsH6x/QeDYebMMDNnpmaSX842Gek8JlpnN9Dbz7g5l8H6dfcfnHxyijc5GAQ5GxDy8/MznYWUobMb6O1n3JzLYPyam2HFCjdut+KrX82eprScDQju/uaIOxyd3UBvP+PmXAbjt3y5l2hUOProKEVFKczUIElbQBBhDxGeF2GNCJ+K8F8ilIqwRIT19nNJzPnzRNggwloRTk92fpqbm5N9yaxBZzfQ28+4OZfB+HX3HyQ6uihdpLOGcC/wqlJMAI4APgVuBJYqxThgqf0eEQ4BZgCHAmcAD4qQ1J8XFRUVybxcVqGzG+jtZ9ycy2D8srH/ANIUEEQoAk4E5gMoRVgpdgDTgMfs0x4DzrVfTwOeUYoOpdgIbACOTWaeGhoaknm5rEJnN9Dbz7g5l0T9amqETz91k5enmDgxuwJCuoadHgDUAo+IcASwArgWqFSKbQBKsU2EPe3z9wbei/n8FjttF7ZvV8ye7cfj8RCNRpk+vY65c71UV1eTn5+P2+2mubmZiooKGhoaUEpRUVFBTU0NoVCI+vp6WltbqayspLa2FhGhtLSU2tpaioqKiEajtLW1MXLkSKqrq/F6vRQXF1NXV0dxcTHhcJhgMNhz3OfzUVhYSH19PSUlJQSDQUKhUM/xQCBAXl4ejY2NlJWV0dLSQjgc7jmel5eHz+ejqamJ8vJympqaiEQiPccHciqwN2JtbGykvLxcK6fYcmpubtbOqbucGhsbyc/P18qpu5xaW1upqqrSyim2nBobG3G5XAM6LV1aCcCXvxxix46ajDjFQ5RK/uSG3b5EmIh1gz9eKd4X4V6gGbhaKfaIOa9RKUpEeABYrhRP2OnzgcVK8ULsdZcvX64mTJgwpDyFQiECgcDQhLIcnd1Abz/j5lwS9bvqqhE89ZSfn/60nWuu6XuHtFSzcuXKFZMmTZrYOz1dfQhbgC1K8b79/nngaKBGhFEA9vP2mPP3ifn8aGBrMjNUU1OTzMtlFTq7gd5+xs25JOKn1M79D7Kt/wDSFBCUohrYLMJ4O2kSsBpYCMy002YCC+zXC4EZIvhF2B8YB3yQzDwNVHVyMjq7gd5+xs25JOK3bp2L//zHRWlpF4cdFn+7zEyRzqUrrgaeFMEHfA7MwgpIz4owG9gEnA+gFKtEeBYraHQCc5Ui+/71DAaDYRA884wfgNNPj+DKwllgacuSUnyoFBOV4nClOFcpGpWiXikmKcU4+7kh5vxblWKsUoxXileSnZ/W1tZkXzJr0NkN9PYzbs5lIL9IBJ5+2tpE55JLMtN3MBBZGKPSQ2VlZaazkDJ0dgO9/YybcxnIb8kSL9u3uxg3Lspxx2Vng0fOBoTa2tpMZyFl6OwGevsZN+cykN/jj++sHSSyO1omyNmAINlaIklAZzfQ28+4OZf+/LZuFZYs8eL1Ki64IDVLVyeDnA0IpaWlmc5CytDZDfT2M27OpT+/p5/209UlTJkSoaIi9XO/hkrOBgSdq686u4HefsbNucTz6+qCJ57I7s7kbnI2IBRl05qzSUZnN9Dbz7g5l3h+77zjoarKzejR0aycjBZLzgaEaDQ7e/mTgc5uoLefcXMu8fwef9yae/Dtb4fJ9i0hcjYgtLW1ZToLKUNnN9Dbz7g5l778GhqERYu8iCi+/e3sbi6CHA4IOm/4rbMb6O1n3JxLX37PPusjHBZOOaWT0aOztzO5m5wNCDpv+K2zG+jtZ9ycS28/pXY2F2V7Z3I3ORsQvF5vprOQMnR2A739jJtz6e23cqWbTz91U1bWxZQp2bVVZjxyNiAUFxdnOgspQ2c30NvPuDmX3n7dtYMZM8L4fJnI0eDJ2YBQV1eX6SykDJ3dQG8/4+ZcYv2CQXjxRSsKOKEzuZucDQg6/1rR2Q309jNu2c1ddwU466wCduzYfZmKWL9XXvHS0iIcdVQnEyZ0pTOLwyJnA0I4nL3riQwXnd1Abz/jlr189pmLO+4IsHy5l0cf3b0NKNbvT3+ymouyed2ivsjZgBAMBjOdhZShsxvo7Wfcspdf/zpAV5dVM3j4YT+dvSYdd/vV1Ah//asHj0cxfboJCI5A5zHROruB3n7GLTtZv97Fc8/58HgUe+3VxZYtbl59dddRRd1+L7zgIxoVJk+OUF6e/XMPYsnZgKDzmGid3UBvP+OWndx1l1U7+Pa3w1x1VQiAhx7y73JOt9+f/mQ1JzmtuQhyOCD4nDIObAjo7AZ6+xm37GPNGhcvvODD61Vcf32Qiy7qID9f8c47Xlav3nkL9fl8rFrl5t//9lBc3MXppztj7kEsORsQCgsLM52FlKGzG+jtZ9yyjzvvzEMp4dJLOxg9WlFUBDNmWENJ//CHQM95hYWFPbWD6dMj+P19Xi6rSVtAEOELEf4twoci/NNOKxVhiQjr7eeSmPPnibBBhLUinJ7s/NTX1yf7klmDzm6gt59xyy5Wr3axYIEXn0/x/e+HetKvuMIKCM8+6+sZglpTU89zz3U3Fzln7kEs6a4hnKIURyrFRPv9jcBSpRgHLLXfI8IhwAzgUOAM4EERkrpwbElJycAnORSd3UBvP+OWXdxxh1U7uOyyDvbee2cH8fjxXZx0UoT2duHJJ60gsHr1KGpqXIwdG+XLX3bmUt+ZbjKaBjxmv34MODcm/Rml6FCKjcAG4NhkfrHTh8D1h85uoLefccsePvnEzUsv+QgEFNdeG9rt+Jw5Vi1g/nw/0Sg895zVfHTBBWGcun10OgOCAl4XYYUIV9pplUqxDcB+3tNO3xvYHPPZLXZa0giFdi9gXdDZDfT2M27Zwx13WDf4yy7rYNSo3YePnn56hH33jfLFF27+8hcvb7xh9ZF861vOG13UjSeN33W8UmwVYU9giQhr+jm3r/i6W4ls366YPduPx+MhGo0yfXodc+d6qa6uJj8/H7fbTXNzMxUVFTQ0NKCUoqKigpqaGgKBAPX19bS2tlJZWUltbS0iQmlpKbW1tRQVFRGNRmlra2PkyJFUV1fj9XopLi6mrq6O4uJiwuEwwWCw57jP56OwsJD6+npKSkoIBoOEQqGe44FAgLy8PBobGykrK6OlpYVwONxzPC8vD5/PR1NTE+Xl5TQ1NRGJRHqOD+RUUFAAWDs3hUIhrZxiywmgvb1dK6fucopGozQ2Nmrl1F1OPp+PqqoqRzi9804TL788gUCgi/PO20AoVNan04wZndx5ZwU/+MEIQiEXEye2UVbWQlVV9jnFllPcG69S6Z84IcJPgVZgDnCyUmwTYRTwplKMF2EegFLcZp//GvBTpVgee53ly5erCRMmDCkPVVVVjBkzZhgW2YvObqC3n3HLDm65JY/77w8we3aIu+6K39TV2CgcdlgxwaD1G/a++9q4+OLsryGsXLlyxaRJkyb2Tk+oyUiEU0TY3349SoTHRHhYhISmHoqQL0Jh92vg68AnwEJgpn3aTGCB/XohMEMEv/2944APEvmuRAkEAgOf5FB0dgO9/Yxb5lEKFi2yZiF/4xv9zyUoKVF885tWAPD7uzjnnOwPBv2RaB/Cg0B3t/n/AV6sJpzfJ/j5SuBdET7CurG/rBSvArcDk0VYD0y236MUq4BngdXAq8BcpUhqt31eXl4yL5dV6OwGevsZt8yzapWbjRvdVFR0cdxxnQOeP3duiMJCxUUXtVJUlIYMppBE+xD2VopNIniA04ExQBjYmsiHleJz4Ig+0uuBSXE+cytwa4L5GzSNjY0UOb304qCzG+jtZ9wyz8KFVu3gzDMjuBMY7H7QQV1s3LiDzZursG6NziXRgNAsQiVwGLBaKVpF8GHVFBxJWVlZprOQMnR2A739jFvmWbTImldw9tmJN/+4XM7x649Em4zuB/4BPAk8YKcdD/2OFMpqWlpaMp2FlKGzG+jtZ9wyy/r1LtascVNc3MUJJwzcXBSLE/wGIqEaglLcIcKLQFQpPrOT/wPMTlnOUozTN+voD53dQG8/45ZZXnrJqh1MmRLBO8j2Dyf4DUSio4wWKMW6mGCAUqwDfp6ynKUYJ6/NPhA6u4HefsYts3SPLjr77MGvVOoEv4FItMnolDjpJycpH2nHyWuzD4TObqC3n3HLHJs2ufjwQw/5+YpTThl8QMh2v0Tot8lIpKcG4It53c0BQFVKcpUGnDIEbijo7AZ6+xm3zPHSS1btYPLkCEOZMpHtfokwUB/CPvazK+Y1WHMQNgM/TUGe0oJTN+tIBJ3dQG8/45Y5hjK6KJZs90uEfgOCUswCEGGZUjyUniylh6amJvbYY49MZyMl6OwGevsZt8xQXS188IGbQEAxefLQdjrLZr9ESXSU0UMiFAPjgYJex/6aioylmvLy8kxnIWXo7AZ6+xm3zPDyyz6UEk49NcwA67/FJZv9EiWhgCDCZVjzD1qB9phDCqsvwXE0NTWRn5+f6WykBJ3dQG8/45YZukcXTZ069H2Qs9kvURKdqXwr8E2leCWVmUknkYjzNsBOFJ3dQG8/45Z+GhqEd9/14PEozjhj6HnMVr/BkOiwUw/weiozkm50GDMcD53dQG8/45Z+Fi/2Eo0KJ57YyR57DH07gGz1GwyJBoQ7gJ+IZHzLzaShw5jheOjsBnr7Gbf0s2CBNTpo6tThzTTOVr/BkGiT0Q+AkcD/iFAfe0Ap9k16rtKA09v6+kNnN9Dbz7ill7fe8rB0qZdAQHHWWcNr8slGv8GSaEC4OKW5yADuRNa1dSg6u4HefsYtfYRCcP31IwC44YYQFRXD2z0y2/yGQqLDTt9KdUbSTXNzMyUlJZnORkrQ2Q309jNu6ePuuwN8/rmb8eOjXHVVaNjXyza/oZDosNO4i9gpxc3Jy076qKioyHQWUobObqC3n3FLD2vXurj3Xmt9it/8po1kTDLOJr+hkmgn8T69Hl8GbgDGpihfKaehoSHTWUgZOruB3n7GLfUoZTUVRSLCpZd28JWvJGd33mzxGw6JNhnN6p0mwhnAhUnPUZpQanjthdmMzm6gt59xSz1PPeVj2TIvFRVd3HJLMGnXzRa/4TCcYaSvA+cmKR9pR4fqXTx0dgO9/YxbaqmrE26+2VqV9Je/DFJSkrybeDb4DZdEN8g5oNfjMOCXWCueOpKamppMZyFl6OwGevsZt9Ry8815NDa6OOmkCN/8ZnJ3OMsGv+GSaA1hA7Deft4AvAecAMwczJeJ4BbhXyIsst+XirBEhPX2c0nMufNE2CDCWhFOH8z3JELBUFewcgA6u4HefsYtdSxf7uGZZ/z4/Yr/+792RJJ7/Uz7JYOEAoJSuJTCbT+7lKJAKU5QihWD/L5rgU9j3t8ILFWKccBS+z0iHALMAA4FzgAeFMH5g3wNBkPG+O1v/QBcfXWIAw7oynBuspOE+xBE8IhwoggXinCCSMKT2ro/Pxo4C/hDTPI04DH79WPs7JOYBjyjFB1KsRGrVnLsYL5vIFpbW5N5uaxCZzfQ28+4pYaqKhevvurF51PMmdORku/QoewSnYcwAXgJyMPqN9gHCIlwtlK7/OLvj3uA/wEKY9IqlWIbgFJsE2FPO31vrGapbrbYabuwfbti9mw/Ho+HaDTK9Ol1zJ3rpbq6mvz8fNxuN83NzVRUVNDQ0IBSioqKCmpqavD7/dTX19Pa2kplZSW1tbWICKWlpdTW1lJUVEQ0GqWtrY2RI0dSXV2N1+uluLiYuro6iouLCYfDBIPBnuM+n4/CwkLq6+spKSkhGAwSCoV6jgcCAfLy8mhsbKSsrIyWlhbC4XDP8by8PHw+H01NTZSXl9PU1EQkEuk5PpBTd5W1s7OTUCiklVNsOSmlaG9v18qpu5w6OztpbGzUyqm7nHw+H1VVVRlx+t3vxqKUMHlyA0VFYaqqkuMUW06dnZ1s3brVEeUU916fyFApEf4KvAL8WimUnXYDcJZSnJLA56cCZyrF90Q4GbhBKaaKsEMp9og5r1EpSkR4AFiuFE/Y6fOBxUrxQux1ly9friZMmDBg/vti8+bN7LPPPgOf6EB0dgO9/Yxb8mlvh8MOK2bHDhdvvNHM0UcnZ95Bb5xUditXrlwxadKkib3TE232ORKY3B0MbO4Bfpzg548HzhHhTCAAFInwBFAjwii7djAK2G6fv4Vd93AeDWxN8LsSQpLdo5RF6OwGevsZt+Tz3HM+duxwccwxnSkLBqBH2SXah7AVOKlX2gkkeJNWinlKMVop9sPqLP6rUlwMLGTnSKWZwAL79UJghgh+EfYHxgEfJJjXhCgtLU3m5bIKnd1Abz/jllyUgocesjqTr7wyNX0H3ehQdokGhJuAhSI8I8IdIjyDddO+aZjffzswWYT1wGT7PUqxCngWWA28CsxViqSG9tra2mReLqvQ2Q309jNuyWXZMg+rV3vYc88upk1L7ryD3uhQdokuXbFQhKOBbwF7AZ8ANyvFusF+oVK8Cbxpv64HJsU571asrTtTQlFRUaounXF0dgO9/Yxbcvn9763awcyZHUlZwK4/dCi7REcZ+YGNSvHLmDSvCH6lSG09LEVEo6lrS8w0OruB3n7GLXls2SIsXuzF41Fcdlnqb1M6lF2iTUZLgGN6pR0DvJbc7KSPtra2TGchZejsBnr7Gbfk8eijfqJR4ZxzIowalfqF53Qou0QDwpeA93ulfQAckdzspA8dNsSOh85uoLefcUsOoRA89pjVXDRnzvA3v0kEHcou0YDQBFT2SqsEHBsSddgQOx46u4HefsYtObz4oo/6ehdHHNHJscempylHh7JLNCC8ADwlwmEijBDhS8AfsUYCORKv15vpLKQMnd1Abz/jlhz+8Ifu2kFH0hexi4cOZZdoQPgx1qJ0HwAtWMtKrAHmpShfKae4uDjTWUgZOruB3n7Gbfh89pmLf/3LQ2GhYvr01A41jUWHskt0tdOQUswF8oGRQIFSXO3UEUYAdXV1mc5CytDZDfT2M27D56WXrF/qZ54ZJhBIy1cCepTdoFYstZeucP7sC/SI5vHQ2Q309jNuw2fBAmvCwTnnRNLyfd3oUHbD2ULT0YTD6atKphud3UBvP+M2PL74wsVHH3koKFCcckp6A4IOZZezASEYTN7m2tmGzm6gt59xGx4LF1rNRaefHklrcxHoUXY5GxB0GDMcD53dQG8/4zY8Fi7sbi5K/691HcpuMDumTRZhvggv2e8ninBq6rKWWnQYMxwPnd1Abz/jNnQ2b3axcqWH/HzFaaelt7kI9Ci7hAKCCFcD/x+wHjjRTg7CzrWNnIYv1StdZRCd3UBvP+M2dLpHF02eHCEvL6Vf1Sc6lF2iNYTvA6cpxe1A9+7Ua4DxqchUOigsLBz4JIeisxvo7Wfchk4mm4tAj7JLNCAUYu2lDPTsmuYFHNutXl9fn+kspAyd3UBvP+M2NLZuFT74wENeXmaai0CPsks0ILwN3Ngr7Rrgb8nNTvooKSnJdBZShs5uoLefcRsaL71k1Q4mTYowwD7yKUOHsks0IFwNfEOEL4BCEdYC5wPXpSpjqUaHIWLx0NkN9PYzbkOje7hpqndF6w8dyi7RHdO2ifBl4FhgX6zmow+U6ulPcByhUHqWxM0EOruB3n7GbfBUVwvvvefB71dMnpyZ5iLQo+wSXrrCXrbifXbfF8GR6DBmOB46u4HefsZt8Lz8sg+lhFNPDZPJXSx1KLu4TUYifBrzerMIm/p6pCebyUeHMcPx0NkN9PYzboOnu7ko3WsX9UaHsuuvhjAn5vXFw/kSEQJYHdN++zufV4pbRCgF/gTsB3wBfEspGu3PzANmA1HgGqWSu11nIN3z2tOIzm6gt59xGxy1tcLf/+7B61VMmZLZQY86lF3cgKAU78a8XaUUw1nbtQM4VSlaRfAC74rwCjAdWKoUt4twI9ZIph+JcAgwAzgU2At4Q4SDlCJpWx/lZWLmSprQ2Q309jNug+PJJ310dQmnnZbZ5iLQo+wSHWW0SYTFIlwsQv5gv0QplFK02m+99kMB04DH7PTHgHPt19OAZ5SiQyk2AhuwOrSTRmNjYzIvl1Xo7AZ6+xm3xPn3v93cfrt1E549O/Nbs+hQdokGhH2BRcB3gWoRnhbhbJHEO6VFcIvwIbAdWKIU7wOVSrENrJFMwJ726XuzcyIcwBY7LWmUlZUl83JZhc5uoLefcUuMtja44op8wmHh8stDTJ7cmbRrDxUdyi7RYad1wIPAgyLsC1wE3Ao8DFQkeI0ocKQIewAvinBYP6f3tQuq6p2wfbti9mw/Ho+HaDTK9Ol1zJ3rpbq6mvz8fNxuN83NzVRUVNDQ0IBSioqKCmpqaohEIpSUlNDa2kplZSW1tbWICKWlpdTW1lJUVEQ0GqWtrY2RI0dSXV2N1+uluLiYuro6iouLCYfDBIPBnuM+n4/CwkLq6+spKSkhGAwSCoV6jgcCAfLy8mhsbKSsrIyWlhbC4XDP8by8PHw+H01NTZSXl9PU1EQkEuk5PpBTgT0jp7q6mrFjx2rlFFtOra2tjBkzRiun7nKqqqpir7320sqpu5zq6urw+XxJcfr+9z2sX+9m3LgwV1yxltbW0ow4xZZTVVUVJSUljiinuDdepXa7z/b/AWs+wkXABUCbUowb1AWsa9wCtGF1XJ9sz3MYBbypFOPtDmWU4jb7/NeAnyrF8tjrLF++XE2YMGGwXw9AVVUVY8aMGdJnsx2d3UBvP+M2MC+95GXmzAL8fsUbb7Rw6KFJ61ocFk4qu5UrV66YNGnSxN7pia52eogIvxDhM+AvdvK5iQYDESrsmgEi5AGnYS2OtxCYaZ82E1hgv14IzBDBL8L+wDjgg0S+K1F0GDMcD53dQG8/49Y/W7YI1147AoCf/SyYNcEA9Ci7RPsQ/g6MAq4ERivFD5Qa1A16FPA3ET4G/oHVh7AIuB2YLMJ6YLL9HqVYBTwLrAZeBeYmc4QR6DFmOB46u4HefsYtPtEo/Pd/57Njh4vJkyPMmZP5juRYdCi7RDuFK5Ua+sqmSvExcFQf6fXApDifuRWrnyIl6DBELB46u4HefsYtPr/5TYC//93Lnnt28dvftiF99TRmEB3KLqEaglKERZglwl9FWGs/z0p15lKJDptZxENnN9Dbz7jtTjQKt9ySx69+Zd1wH3ywjYqKwfV9pgMdyi7RPoQfY00aewZr2etngP+x0x1JU1NTprOQMnR2A739jNuuNDYK559fwP33B3C7FXfd1c6pp2Z+iGlf6FB2iTYZXYE1GqiqO8Ee+fM2KWzWSSXl5eWZzkLK0NkN9PYzbjtZtcrNJZfk88UXbsrLu3jkkTaOPz47gwHoUXaJdirnA7W90uoBxzaa6RDN46GzG+jtZ9wsXnzRy+mnF/LFF26OPLKTv/61OauDAehRdokGhFeBJ0UYL0KeCBOwlppI6oJz6SQSyezKiKlEZzfQ28+4wfz5fmbPLqC9Xbjggg5efrmF0aOzr8+gNzqUXaIB4SqgBfgIaAU+xJpYdnVqspV6dBgzHA+d3UBvv1x3e+89N/PmWQ0Pv/xlOw8+2I5TBu/oUHaJjjJqVopLgRFYcwpGKMWlSrEjlZlLJTqMGY6Hzm6gt18uu9XUCJdfXkBnpzB3bojvfa8j64aW9ocOZddvp7K9blFfjO4uKKWcuUlOfv6gF211DDq7gd5+ueoWicDs2flUV7v46lcj3HKL8/Yn1qHsBhpl9AU7F5WLt+CcO5kZShdutyOznRA6u4Hefrnq9rOf5bFsmZeRI7uYP78NT8LrKGcPOpTdQE1GHwPrgZ8AY9i5l0H3w7EzMZqbmzOdhZShsxvo7ZeLbi++6OXBBwN4PIqHH26lsjL7O5D7Qoey6zcgKMWRwDeBUuBdYDHWTmY+pYgme32hdFJRkdCq3Y5EZzfQ2y/X3NascXHNNVZTyy9+EeQrX3HsLUWLshuwU1kpPlGKHwL7A3cDU4FtIhyd6sylkoaGhkxnIWXo7AZ6++WS28aNLi6+uIC2NuG888JceWV2LVY3WHQou0SHnYK1BPVJwH8B/wIcvV/cYPeBcBI6u4HefrnitnSph1NPLeTzz90cdlgn99yTfYvVDRYdyq7fgCBCqQhzRfgAax+EVuBEpTjF3uvYsehQvYuHzm6gt5/ubkrBvff6ueCCApqaXEyZEmbRohY0GKCjRdkNVEPYijUp7S/AXOA94EARTu1+pDh/KaOmpibTWUgZOruB3n46u33xRS2zZ+fzs5+NoKtL+NGPgjz+eBtFRZnOWXLQoewGGtxVDQSwtrqc08dxBRyQ7Eylg4H2FnUyOruB3n66ubW0wPr1btatc3PvveNZu9ZHQYHid79r48wznb/UQyw6lF2/AUEp9ktTPgwGgwaEQnD//QGWLfOwbp2bbdt2bYQ48MAoTzzRykEHdWUoh4b+cOD0j+TQ2tpKWVlZprOREnR2A739nOy2YYOLyy/P55NPdt5WfD7FgQdGOeigLkaPruOGG/K0aSLqjZPLrpucDQiVlZWZzkLK0NkN9PZzqtsLL3j5wQ/yaW0V9t8/yi23BDnssChjxnTRPYE3FBICgczmM5U4texiGcywU62ore29vYM+6OwGevs5zS0YhO9/fwRz5hTQ2ip84xth/va3Zs45J8IBB+wMBuA8t8Gig1/O1hDE6YOe+0FnN9Dbz0lun33mYubMfFav9uD3K371q3Yuuywcdz6Bk9yGgg5+aakhiLCPCH8T4VMRVolwrZ1eKsISEdbbzyUxn5knwgYR1opwerLzVFpamuxLZg06u4Hefk5x++QTN1OmFLJ6tYexY6O8/noLs2bFDwbgHLehooNfupqMOoHrleJg4CvAXBEOAW4ElirFOGCp/R772AzgUOAM4EGR5K6qqkP1Lh46u4Hefpl2W7rUw/XXj2Djxvi3hn/9y8055xRQV+filFMi/PWvzXzpSwOvQZRpt1Sjg19aAoJSbFOKlfbrFuBTYG9gGtZWnNjP59qvpwHPKEWHPSN6A3BsMvNUpOtQB/R2A739Mum2ZYswa1YBjzzi52tfK+L++/109trG+L333Jx7biE7dlizjJ96qpXCwsSur3O5gR5+ae9DEGE/4CjgfaBSKbaBFTRE2NM+bW+sWdHdbLHTdmH7dsXs2X48Hg/RaJTp0+uYO9dLdXU1+fn5uN1umpubqaiooKGhAaUUFRUV1NTU0NXVRVdXF62trVRWVlJbW4uIUFpaSm1tLUVFRUSjUdra2hg5ciTV1dV4vV6Ki4upq6ujuLiYcDhMMBjsOe7z+SgsLKS+vp6SkhKCwSChUKjneCAQIC8vj8bGRsrKymhpaSEcDvccz8vLw+fz0dTURHl5OU1NTUQikZ7jAzl1T4zZvn07eXl5WjnFllN7ezt+v18rp+5y6t51K91OgUAe11yzD62twsiRnVRXe7jllhE8/7yXm276nGOOcfH++/nMmVNJKCScfvoOfvGLTShVQVVV/07d5dTY2Ehzc7MW5RTvby8YDDrCKe79OZ0LMolQALwF3KoUfxZhh1LsEXO8USlKRHgAWK4UT9jp84HFSvFC7PWWL1+uJkyYMKS8VFVVMWbMmKGqZDU6u4Hefplye/55L1deWUBRURfvvdfMJ5+4ue66EWzZ4sbtVnzrW2H+/GcfHR3ChRd2cN997Qx2Pxidyw2c5bdy5coVkyZNmtg7PW3DTkXwAi8ATyrFn+3kGhFG2cdHAdvt9C3APjEfH421rlLS0GFD7Hjo7AZ6+2XCra5OmDdvBGDtSTBypOK00zpZtqyZ73wnRFcXPP20n44OYdasDu6/f/DBAPQuN9DDL12jjASYD3yqFHfHHFoIzLRfzwQWxKTPEMEvwv5YS29/kMw86bAhdjx0dgO9/TLhdtNNedTXuzjxxAgXXxzuSS8ogNtuC/Laay2cdFKEH/0oyK9/3Y5riHcNncsN9PBLVx/C8cAlwL9F+NBOuwm4HXhWhNnAJuB8AKVYJcKzwGqsEUpzk707m9frTeblsgqd3UBvv2S6hULw5pteFi3y0twszJzZwamndu4yNPT11z08/7yfvDzFb37T3uew0YkTo7z4Yuuw86NzuYEefmkJCErxLhBvhPKkOJ+5Fbg1VXkqLi5O1aUzjs5uoLffcN2am2HJEi8vv+zjjTe8tLbu/G+3aJGPo47q5LrrQkyZEqG1Fa6/3tqIYN68IPvvn9oF53QuN9DDL2dnKtfV1ZGvw64cfaCzG+jtNxy31atdnHVWIU1NO9t0jjiik6lTI7hc8Lvf+fnXvzxcckkBEyZEGT26i//8x8VRR3Xy3e+mfvtKncsN9PDL2YCgQzSPh85uoLffcNzuvTdAU5OLww7rZMaMMFOnRth3352/+r/znRBPPOHnvvsCrFnjZs0aNx6P4r772vGk4U6gc7mBHn45GxDC4fDAJzkUnd1Ab7+hutXWCgsW+BBRPPlkG/vss3vzz4gRcOWVHVx2WQd/+pOPJ57wc8EFHRx6aFK75+Kic7mBHn45GxCCwWCms5AydHYDvf2G6vbEE37CYeGMM8J9BoNYfD645JIwl1yS3huYzuUGevjl7PLXOowZjofObqC331DcolF45BEfALNnp74vYKjoXG6gh1/OBgQdxgzHQ2c30NtvKG6vv+5lyxY3BxwQ5ZRTOgf+QIbQudxAD7+cDQg+ny/TWUgZOruB3n5DcfvDH/wAzJrVMeRJY+lA53IDPfyy+M8ntRQmukSjA9HZDfT2G6zbZ5+5+NvfvAQCiosuyu5OTZ3LDfTwy9mAUF9fn+kspAyd3UBvv8G6PfywVTs477wwJSXpW6hyKOhcbqCHX84GhJKSkoFPcig6u4Gz/LZuFTZvTvy/2WDc2tvhqaeyvzO5GyeV21DQwS9nA4IOQ8TiobMbOMfvn/90c9xxxRxxRDHf+lYBS5Z46BpgdYjBuL3wgo+mJhfHHNPJkUemZy7BcHBKuQ0VHfxyNiCEQqFMZyFl6OwGzvBbvdrFt75VQFubIKJ44w0vF1xQyHHHFfG73/lpbu77c4m6KQXz51vNRU6oHYAzym046OCXswFBhzHD8dDZDbLf7/PPXZx3nrXN5Jlnhvn00yZuuaWd0aOjfPaZm5tuGsGhh+7BpZfmM3++nw0bXHTvU5Wo2z//6ebjjz2UlnZx7rnZ3ZncTbaX23DRwS9nZypXV1c7ZnejwaKzG2S339atwvTpBdTUWPsL/OEPbQQCcO21Hcyd28Grr3r5/e/9vPuul0WLfCxaZPUBjB4d5aSTOqmoaMfjCdDSIrS2Ss9z740Nv/jC+i138cVhAoF0Ww6NbC63ZKCDX84GhIBT/hcNAZ3dIHv96uuF6dML2bTJzdFHd/L446273Kw9Hpg6NcLUqRE2bXLx5pse3nrLy9tve9iyxc2TT7rpY+vwuPj9ilmznNFcBNlbbslCB7+cDQh5eXmZzkLK0NkNss8vGoU1a9xcc80I1q1zc/DBUZ57rpX+hqXvu28Xl14a5tJLw3R1wSefuHnzTQ9btnRSVualsFBRUKB6nvuacDZmTBdjxqR2D4Nkkm3llmx08MvZgNDY2EhRUVGms5ESdHaDzPvV1grLlnlYudLDihVuPvrIQ1ubtRHNfvtFeeGFlkHNCXC54PDDoxx+eNRRG7UPlkyXW6rRwS9nA0JZWVmms5AydHaDzPl1dsKDD/q54448gsFdNwAcMybKccd18uMfhxg5cugTxHQuO53dQA+/nA0ILS0tFBQUZDobKUFnN8iM38cfW01CH39s/Zc54YQIxx3XycSJnRx1VJSKiuTMEta57HR2Az38cjYg6LCZRTx0doP0+gWDcMcdeTzwgJ9oVBg9Osrdd7dz2mmpWVVU57LT2Q308EvLPAQRHhZhuwifxKSVirBEhPX2c0nMsXkibBBhrQinpyJPOowZjofObpB6v5YWeOcdD/fe6+eEE4q4774AXV3WFpTLljWnLBiA3mWnsxvo4ZeuiWmPAmf0SrsRWKoU44Cl9ntEOASYARxqf+ZBEdzJzpAOa5fHQ2c3SI3fK694ufrqERx/fBH77bcH06YV8rOfjeDzz61RQ6+91sJttwVJdYuAzmWnsxvo4ZeWJiOleFuE/XolTwNOtl8/BrwJ/MhOf0YpOoCNImwAjgWWJzNPOgwRi4fObpB8v2ef9fHd7+b3vPd4FF/6UidHH93Jccd1cs45EdK11L3OZaezG+jhl8k+hEql2AagFNtE2NNO3xt4L+a8LQxmtk6C6LCZRTx0doPk+q1b5+L660cAcNVVIaZODXP44dGMzf7Vuex0dgM9/LKxU1n6SOtzCMf27YrZs/14PB6i0SjTp9cxd66X6upq8vPzcbvdNDc3U1FRQUNDA0opKioqqKmpIRgMEo1GaW1tpbKyktraWkSE0tJSamtrKSoqIhqN0tbWxsiRI6mursbr9VJcXExdXR3FxcWEw2GCwWDPcZ/PR2FhIfX19ZSUlBAMBgmFQj3HA4EAeXl5NDY2UlZWRktLC+FwuOd4Xl4ePp+PpqYmysvLaWpqIhKJ9BwfyKl7hMN//vMfAoGAVk6x5bRjxw58Pt+wnbZsaWDWrINpaxOmTGngppvC1NRU09QUIBxOr1N3OW3atAmllBbl1Ptvr7q6mqamJq2cYstp06ZNtLe3O8Ip7s1X9V4kJUXYTUaLlOIw+/1a4GS7djAKeFMpxoswD0ApbrPPew34qVK7NxktX75cTZgwYUj5aWtrIz8/f+ATHYjObpA8v2uvHcHjj/s58MAoS5c29zuzOF3oXHY6u4Gz/FauXLli0qRJE3unZ3K104XATPv1TGBBTPoMEfwi7A+MAz5I9pc3NTUl+5JZg85ukBy/557z8fjjfgIBxSOPtGVFMAC9y05nN9DDLy1NRiI8jdWBXC7CFuAW4HbgWRFmA5uA8wGUYpUIzwKrgU5grlIkffePSCSS7EtmDTq7wfD91q93cd11Vr/Br37VzqGHZs/mMjqXnc5uoIdfukYZXRjn0KQ4598K3Jq6HOkxZjgeOrvBTr/t26VnPaHNm13k59OzIFz3I3aBuMJCRV4ezJqVT1ubcN55YWbOzK7JRDqXnc5uoIdfNnYqpwUd1i6Ph65unZ3wxBM+XnkF1qwpYvPmoU9PGTs2yt13tyF9DWHIILqWHejtBnr45WxAcErnz1DQ0U0puOGGEfzxj37A8isoUBx1VCfHHNPJgQd2EQwKra3Q0iI9j+5NZmLf+/2KRx/Nnn6DWHQsu250dgM9/HI2ILjdSZ/8nDXo6PbrXwf44x+tTuB58+o57TQvBx3UhW6qOpZdNzq7gR5+ObuncnO8Xc41QDe3xx/3cdttebhcioceauOcc7Zw8MH6BQPQr+xi0dkN9PDL2RpCRUVFprOQMpziphR88IGbxYt9HHpolGnTwvj9u57z+uuenhFBd97ZzllnRWhvd4bfUHBK2Q0Fnd1AD7+crSE0NDRkOgspI9vdQiF46ikfp55ayJQpRdx/f4DvfjefI44o5rbbAlRXWz29K1a4ufzyAqJR4frrg1x+uTUiKNv9hoNxcy46+OVsDSFdM7QzQba6bdsmzJ/v57HH/NTXW79Fysq6mD49zN//7mH1ag933ZXHb34T4OyzI7z9tof2duHCCzu46aZQz3Wy1S8ZGDfnooNfzgYEHap38ejt1tYG99wToLxcMWdOR58btncTiVjnhkIwc2aYffcd/ibujY3CPfcEeOghP6GQ9ev/8MM7ufLKDqZPDxMIWM1Hy5Z5+P3v/bz8spcXX7QWCps0KcI997TvMjw0l8pOJ3R2Az38cjYg1NTUOH7McDxi3dascTFrVgFr11o9sO++6+GBB9roay/w2lph1qx8li3zAnDvvQHOOCPCnDkdnHhi56DH7Le3w//7fwHuvddPc7MVhaZODfO974U47rjoLtcTgeOP7+T44zvZskV45BE/DQ0ufvGLdrze+H66Ydyciw5+ORsQnL73aX90uz31lI8f/nAEwaAwdmyUujrh5Zd9rFvn5sknWznwwJ2//v/1LzeXXFLA1q0uRo7s4vjjO1m40MvixT4WL/YxYUKUK64I8V//1cnYsV1x9weIRGDjRhdvv+3l7rsDVFdbgeCkkyLcfHOQo44aeJmI0aMV//u/objHc6HsdERnN9DDL2cDQiZZvdrFT34ygo8/dvO1r3Vy9tlhJk+O9PmrfSi0twv/+78jeOYZa8jOjBkd3HlnO9u3u7j44gLWrHEzaVIRDz3Uyte/3snTT/u47roRdHQIxx7byaOPtjJypOLWW4XHHvPzyCN+1qxxc8MN1sQbt1ux//5dHHRQlIMOiuJ2w9q1btatc7Nxo4tIZOdP/yOP7OTmm4OcfHLqtp00GAzJIW3LX6eC4Sx/XVVVldTq3cqVbubP97Ntm4upU8NMnx5hjz12/bdtahJuuy3A/PnWhu2x+HyKk0+OMHVqhEMOie6yJk9+Pgk316xY4ebKK31s3BggL09x113tXHTRzvV6Wlpg7tx8Fi3yIaI48cRO3nrLapO57LIObr+9fbdf/+EwvPSSlz//2ceaNW6qqlx0dcXP0D77RBk/vouLLupg2rRI0peHSHbZZRPGzbk4yS/e8tc5GxBCoRCBYW6LFQ7DggU+fv97PytW7FrZ8vsVU6ZEuPDCDk46qZNnnvHxi1/kUV/vwuVSzJrVwWWXhXn7bQ+LFnl57z0PSvV95xRRVFYqLrggzOzZIUaP3r3M1q1zceutebz0knU3Hz8+ysMPt3Lwwbt3CisFd98d4Fe/CqCU4PUq7ryzPeGF3kIh+OwzN2vXuli3zk00CgcdZNUYDjwwSqpn8Cej7LIV4+ZcnORnAkIvNm/ezD777JPw+e3tsG2bq+exZo2Lp57yU1NjtZEXF3dxySVhDj44ynPP+XjrrZ03+EBA9Yyu+epXI9x+e5DDDtu1LX37dmHxYi+vv+6lpsa1y/o77e07A4XLpTjzzAhXXtnB8cd3sm2bcMcdeTz1lI9oVAgEFBdeWMvPf+4d8Ma8ZImHJ57wM3duiGOPzZ4loAdisGXnJIybc3GSX7yAkJN9CMcdV0QoNJ6SEvcuTTMjRli/fnsvilZfL+zY0fdYzYMPjjJnTojzzw/33IAvvDDMli3Cc8/5efppHxs2uBk1qouf/7yd6dP7bkLZc0/FZZeFueyy3X+ld3ZaTVIPPRRgwQIvixb5WLTIx7hxUTZvdhEKCW63YubMDn74wyBdXTXk548e8N9h8uROJk92Xtu+ZNsSpUnEuDkXHfxyroagFFRW7kFn5+AKz+dTjBzZxV57dTFqlGKvvbr4+tcjfO1r/Q/HVAo2bXJRWdmVlI3bq6uFRx/18+ijfrZvt4LUtGlhbropyLhxVvNQe3s7I0aMGP6XZSk6+xk35+IkP1NDiOHf/25i7dqtFBWN3qUm0N4OgQC7ba5SUqIoK1ND6hwVgTFjhj+5q5uRIxU33hjiuutCvPWWh732Urvt+FVbW+uYzq2hoLOfcXMuOvjlXEAQgcpKhc8XoKTEOe3mvfH5iNvcU5Ss8atZis5+xs256OCXs4vbRaPODQYDobMb6O1n3JyLDn45GxDa2toynYWUobMb6O1n3JyLDn45GxB02BA7Hjq7gd5+xs256OCX1QFBhDNEWCvCBhFuTOa1q6urk3m5rEJnN9Dbz7g5Fx38sjYgiOAGHgCmAIcAF4pwSLKu/5e//CVZl8o6dHYDvf2Mm3PRwS9rAwJwLLBBKT5XijDwDDAtWRf/85//nKxLZR06u4HefsbNuejgl80BYW9gc8z7LXZaUujsdN4M3UTR2Q309jNuzkUHv6ydqSzC+cDpSnGF/f4S4FiluLr7nMWL/9aybVteT1ArKorUlpaG6xK5fkNDQ3lpaWlC5zoNnd1Abz/j5lwc5jdm0qRJu23xls0T07YAsStFjQa2xp5w5pmnFKY1RwaDwaAx2dxk9A9gnAj7i+ADZgALM5wng8Fg0JasrSEoRacIVwGvAW7gYaVYleFsGQwGg7Zkcw0BpVisFAcpxViluLW/c0XkYRHZLiKfxKQdISLLReTfIvKSiBTFHDvcPrbKPh6w04+x328QkfskS9a0HYyfiHxbRD6MeXSJyJH2sazzG6SbV0Qes9M/FZF5MZ9xuptPRB6x0z8SkZNjPpONbvuIyN/sclglItfa6aUiskRE1tvPJTGfmWc7rBWR02PSHe8nImX2+a0i8tte18o6vz5RSmnxAE4EjgY+iUn7B3CS/fpy4Bf2aw/wMXCE/b4McNuvPwD+CxDgFWBKpt0G69frc18CPo95n3V+gyy7i4Bn7NcjgC+A/TRxmws8Yr/eE1gBuLLYbRRwtP26EFiHNWfoTuBGO/1G4A779SHAR4Af2B/4LJv/3w3BLx/4GvBd4Le9rpV1fn09srqGMBiUUm8DDb2SxwNv26+XAOfZr78OfKyU+sj+bL1SKioio4AipdRyZZXiH4FzU575BBikXywXAk8DZKvfIN0UkC8iHiAPCAPNmrgdAiy1P7cd2AFMzGK3bUqplfbrFuBTrKHh04DH7NMeY2dep2EF8w6l1EZgA3CsLn5KqTal1LtAKPY62erXF9oEhDh8Apxjvz6fnaOWDgKUiLwmIitF5H/s9L2xRjd1k9S5Dykgnl8sF2AHBJzlF8/teaAN2AZsAn6tlGpAD7ePgGki4hGR/YFj7GNZ7yYi+wFHAe8DlUqpbWDdVLFqOxB/bpEufvHIer9udA8IlwNzRWQFVpWve39KD1bV7tv28zdEZBJWda432TlRwyKeHwAichzQrpTqbr92kl88t2OBKLAXVrPD9SJyAHq4PYx1s/gncA+wDOgky91EpAB4Afi+Uqq5v1P7SFP9pGcFg/CLe4k+0rLGL5asHWWUDJRSa7CahxCRg4Cz7ENbgLeUUnX2scVY7bxPYM136Ga3uQ/ZRD9+3cxgZ+0ALG9H+PXjdhHwqlIqAmwXkb8DE4F3cLibUqoT+EH3eSKyDFgPNJKlbiLixbpZPqmU6l67oUZERimlttnNJdvt9Hhzi7L273KQfvHIWr/eaF1DEJE97WcX8BPgd/ah14DDRWSE3RZ9ErDarv61iMhX7FEAlwILMpD1hOjHrzvtfKw1oICe6q0j/Ppx2wScKhb5wFeANTq42X+P+fbryUCnUipr/y7tvMwHPlVK3R1zaCEw0349k515XQjMEBG/3SQ2DvhAI78+yVa/Psl0r3ayHli/hLcBEayIPBu4FmtkwDrgduylOuzzLwZWYbXn3hmTPtFO+wz4bexnHOZ3MvBeH9fJOr/BuAEFwHN22a0GfqiR237AWqzOyzeAMVnu9jWspo+PgQ/tx5lYo/aWYtVulgKlMZ/5se2wlpiRNhr5fYE1iKDVLu9DstWvr0fWrmVkMBgMhvSidZORwWAwGBLHBASDwWAwACYgGAwGg8HGBASDwWAwACYgGAwGg8HGBARDTiMib4rIFZnOh8GQDZiAYHA8IvKFiATtZYerReRRe7kBRyEiT4rIw73SThKRentGrMGQUkxAMOjC2UqpAuBIrEXI5vV/elZyDXCmPUsZsfboeAi4XtmLqQ0Xe2a+wdAnJiAYtEIpVY21NMmR3Wn2kgHLRGSH9Np4pjcicrm9IUqjvRrumJhj94rIZhFpFpEVInJCzLFjReSf9rEaEbk75lhC36+UqgeuBn5vL2FxC/CZUurR/q4hIrPsPLeIyOci8p2YYyeLyBYR+ZGIVAOPJPpvachBMj1V2jzMY7gPrOUCTrNfjwb+Ddxrv98bqMdacsAFTLbfV9jH3wSusF+fi7VG/8FYCz/+BFgW8z0XYy1b4AGuB6qBgH1sOXCJ/boA+Eoi3x/H53ms9XLqgX0TcDgLGIu1quZJQDs7N3Y5GWvF1DuwNqbJy3R5mUf2PkwNwaALfxGRFqz19rdj/boG6ya+WCm1WCnVpZRagrW89Jl9XOM7wG1KqU+VtfLor4Aju2sJSqknlLWZUqdS6v+wbrDj7c9GgANFpFwp1aqUem8I39/NXOBU4OdKqU0DXUMp9bJS6jNl8RbwOnBCzPW6gFuUtTFNMJF/TENuYgKCQRfOVUoVYv0ingCU2+ljgPPtppYdIrIDa9GyvjppxwD3xpzXgPWre28AEbnebpppso8Xx3zPbKyNl9aIyD9EZOoQvh8ApVQNUIe1gN+A1xCRKSLynog02MfOjMkXQK1SapddvAyGvjAdTAatUEq9JSKPAr/GagLaDDyulJqTwMc3A7cqpZ7sfcDuL/gRMAlYpZTqEpFG7M1PlFLrgQvtJa2nA8+LSNkgv7+/fPV5DRHxY63XfymwQCkVEZG/dOfLxqxgaUgIU0Mw6Mg9wGQRORJr06OzReR0EXGLSMDuaB3dx+d+B8wTkUMBRKRYRM63jxVitcXXAh4RuRko6v6giFwsIhVKqS6svZDB2tltMN8fj/6u4cNquqoFOkVkCvbmOwbDYDEBwaAdSqlarI3M/1cptRlrU/SbsG6am4Ef0sffvlLqRazO12dEpBlr/fop9uHXgFew9jCowtpIPXZ/4DOAVSLSCtwLzFBKhQbz/f34xL2GsjZ/vwZ4FmtntYuwOqQNhkFj9kMwGAwGA2BqCAaDwWCwMQHBYDAYDIAJCAaDwWCwMQHBYDAYDIAJCAaDwWCwMQHBYDAYDIAJCAaDwWCwMQHBYDAYDIAJCAaDwWCw+f8BXCtb8tRSOFMAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "fig, axes = plt.subplots()\n",
    "x = np.sort(movies_clean.release_date.dt.year.unique())\n",
    "y = movies_clean.groupby(movies_clean.release_date.dt.year).count().iloc[:,0].to_list()\n",
    "plot_timeseries(axes, x, y, 'blue', 'Release Year', 'Movie counts')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Conclusions**\n",
    "In the first section i gathered the data, then i assessed it and then cleaned it. I then deduced some answers to the questions listed above. The analysis contains the answer to the following questions:\n",
    "\n",
    "What is the most rated movie?\n",
    "What is the most voted movie?\n",
    "Most successful director?\n",
    "Top 3 movies for the top 3 directors?\n",
    "Highest movie budget?\n",
    "Longest movie runtime?\n",
    "Most famous Genres?\n",
    "Top Movies for each Genre?\n",
    "Most popular movie?\n",
    "Does the production of movies increase or decrease?\n",
    "\n",
    "**Limitations**\n",
    "This dataset had some limitations like some values are encoded in a wrong way.\n",
    "It also has some missing values of some columns, i did not drop them as they are useful to answer other questions.\n",
    "Also the dataset is not updated."
   ]
  }
 ],
 "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.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}