x20103689 DIA IMDB Analysis.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Import the csv \n",
    "import pandas as pd\n",
    "\n",
    "imdbdata = pd.read_csv('imdb.csv', sep=\":\", header = None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>780354\\tnm0000965\\tDanny Boyle</td>\n",
       "      <td>nm0000965</td>\n",
       "      <td>I</td>\n",
       "      <td>nm0000965</td>\n",
       "      <td>tt8079248</td>\n",
       "      <td>tt8079248\\tnm0000965</td>\n",
       "      <td>780354.44</td>\n",
       "      <td>movie\\tYesterday\\t2019\\t116\\tComedy,Fantasy,Music</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>788339\\tnm0583600\\tNancy Meyers</td>\n",
       "      <td>nm0583600</td>\n",
       "      <td>I</td>\n",
       "      <td>nm0583600</td>\n",
       "      <td>tt0120783</td>\n",
       "      <td>tt0120783\\tnm0583600</td>\n",
       "      <td>788339.50</td>\n",
       "      <td>movie\\tThe Parent Trap\\t1998\\t128\\tAdventure,C...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>790272\\tnm0126096\\tJames Ward Byrkit</td>\n",
       "      <td>nm0126096</td>\n",
       "      <td>I</td>\n",
       "      <td>nm0126096</td>\n",
       "      <td>tt2866360</td>\n",
       "      <td>tt2866360\\tnm0126096</td>\n",
       "      <td>790272.00</td>\n",
       "      <td>movie\\tCoherence\\t2013\\t89\\tDrama,Horror,Mystery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>794156\\tnm1834213\\tGary McKendry</td>\n",
       "      <td>nm1834213</td>\n",
       "      <td>I</td>\n",
       "      <td>nm1834213</td>\n",
       "      <td>tt1448755</td>\n",
       "      <td>tt1448755\\tnm1834213</td>\n",
       "      <td>794156.80</td>\n",
       "      <td>movie\\tKiller Elite\\t2011\\t116\\tAction,Crime,T...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>795374\\tnm0193485\\tRichard Curtis</td>\n",
       "      <td>nm0193485</td>\n",
       "      <td>I</td>\n",
       "      <td>nm0193485</td>\n",
       "      <td>tt1131729</td>\n",
       "      <td>tt1131729\\tnm0193485</td>\n",
       "      <td>795374.20</td>\n",
       "      <td>movie\\tPirate Radio\\t2009\\t135\\tComedy,Drama,M...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                      0          1  2          3          4  \\\n",
       "0        780354\\tnm0000965\\tDanny Boyle  nm0000965  I  nm0000965  tt8079248   \n",
       "1       788339\\tnm0583600\\tNancy Meyers  nm0583600  I  nm0583600  tt0120783   \n",
       "2  790272\\tnm0126096\\tJames Ward Byrkit  nm0126096  I  nm0126096  tt2866360   \n",
       "3      794156\\tnm1834213\\tGary McKendry  nm1834213  I  nm1834213  tt1448755   \n",
       "4     795374\\tnm0193485\\tRichard Curtis  nm0193485  I  nm0193485  tt1131729   \n",
       "\n",
       "                      5          6  \\\n",
       "0  tt8079248\\tnm0000965  780354.44   \n",
       "1  tt0120783\\tnm0583600  788339.50   \n",
       "2  tt2866360\\tnm0126096  790272.00   \n",
       "3  tt1448755\\tnm1834213  794156.80   \n",
       "4  tt1131729\\tnm0193485  795374.20   \n",
       "\n",
       "                                                   7  \n",
       "0  movie\\tYesterday\\t2019\\t116\\tComedy,Fantasy,Music  \n",
       "1  movie\\tThe Parent Trap\\t1998\\t128\\tAdventure,C...  \n",
       "2   movie\\tCoherence\\t2013\\t89\\tDrama,Horror,Mystery  \n",
       "3  movie\\tKiller Elite\\t2011\\t116\\tAction,Crime,T...  \n",
       "4  movie\\tPirate Radio\\t2009\\t135\\tComedy,Drama,M...  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "imdbdata.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "#We will rename our columns as thus\n",
    "\n",
    "#Column 0 as Director details\n",
    "#Column 1 as Director ID\n",
    "#Column 2 will be dropped\n",
    "#Column 3 will be dropped\n",
    "#Column 4 as Title ID\n",
    "#Column 5 will be dropped as it is a concatenation of column 4 & 7\n",
    "#Column 6 as Product rating\n",
    "#Column 7 as Movie details\n",
    "\n",
    "#Let's begin with dropped nececcary columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[0, 1, 2, 3, 4, 5, 6, 7]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(imdbdata.columns)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "imdbdata = imdbdata.drop([2,3,5], axis = 1)"
   ]
  },
  {
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>4</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>780354\\tnm0000965\\tDanny Boyle</td>\n",
       "      <td>nm0000965</td>\n",
       "      <td>tt8079248</td>\n",
       "      <td>780354.44</td>\n",
       "      <td>movie\\tYesterday\\t2019\\t116\\tComedy,Fantasy,Music</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>788339\\tnm0583600\\tNancy Meyers</td>\n",
       "      <td>nm0583600</td>\n",
       "      <td>tt0120783</td>\n",
       "      <td>788339.50</td>\n",
       "      <td>movie\\tThe Parent Trap\\t1998\\t128\\tAdventure,C...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>790272\\tnm0126096\\tJames Ward Byrkit</td>\n",
       "      <td>nm0126096</td>\n",
       "      <td>tt2866360</td>\n",
       "      <td>790272.00</td>\n",
       "      <td>movie\\tCoherence\\t2013\\t89\\tDrama,Horror,Mystery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>794156\\tnm1834213\\tGary McKendry</td>\n",
       "      <td>nm1834213</td>\n",
       "      <td>tt1448755</td>\n",
       "      <td>794156.80</td>\n",
       "      <td>movie\\tKiller Elite\\t2011\\t116\\tAction,Crime,T...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>795374\\tnm0193485\\tRichard Curtis</td>\n",
       "      <td>nm0193485</td>\n",
       "      <td>tt1131729</td>\n",
       "      <td>795374.20</td>\n",
       "      <td>movie\\tPirate Radio\\t2009\\t135\\tComedy,Drama,M...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                      0          1          4          6  \\\n",
       "0        780354\\tnm0000965\\tDanny Boyle  nm0000965  tt8079248  780354.44   \n",
       "1       788339\\tnm0583600\\tNancy Meyers  nm0583600  tt0120783  788339.50   \n",
       "2  790272\\tnm0126096\\tJames Ward Byrkit  nm0126096  tt2866360  790272.00   \n",
       "3      794156\\tnm1834213\\tGary McKendry  nm1834213  tt1448755  794156.80   \n",
       "4     795374\\tnm0193485\\tRichard Curtis  nm0193485  tt1131729  795374.20   \n",
       "\n",
       "                                                   7  \n",
       "0  movie\\tYesterday\\t2019\\t116\\tComedy,Fantasy,Music  \n",
       "1  movie\\tThe Parent Trap\\t1998\\t128\\tAdventure,C...  \n",
       "2   movie\\tCoherence\\t2013\\t89\\tDrama,Horror,Mystery  \n",
       "3  movie\\tKiller Elite\\t2011\\t116\\tAction,Crime,T...  \n",
       "4  movie\\tPirate Radio\\t2009\\t135\\tComedy,Drama,M...  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "imdbdata.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Lets fix our director data\n",
    "directordata = imdbdata[0].str.split('\\t').apply(pd.Series)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "scrolled": true
   },
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>780354</td>\n",
       "      <td>nm0000965</td>\n",
       "      <td>Danny Boyle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>788339</td>\n",
       "      <td>nm0583600</td>\n",
       "      <td>Nancy Meyers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>790272</td>\n",
       "      <td>nm0126096</td>\n",
       "      <td>James Ward Byrkit</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>794156</td>\n",
       "      <td>nm1834213</td>\n",
       "      <td>Gary McKendry</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>795374</td>\n",
       "      <td>nm0193485</td>\n",
       "      <td>Richard Curtis</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        0          1                  2\n",
       "0  780354  nm0000965        Danny Boyle\n",
       "1  788339  nm0583600       Nancy Meyers\n",
       "2  790272  nm0126096  James Ward Byrkit\n",
       "3  794156  nm1834213      Gary McKendry\n",
       "4  795374  nm0193485     Richard Curtis"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "directordata.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Rename the columns\n",
    "directordata.columns = ['Product Rating', 'Director ID', 'Directors First Name']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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>Product Rating</th>\n",
       "      <th>Director ID</th>\n",
       "      <th>Directors First Name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>780354</td>\n",
       "      <td>nm0000965</td>\n",
       "      <td>Danny Boyle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>788339</td>\n",
       "      <td>nm0583600</td>\n",
       "      <td>Nancy Meyers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>790272</td>\n",
       "      <td>nm0126096</td>\n",
       "      <td>James Ward Byrkit</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>794156</td>\n",
       "      <td>nm1834213</td>\n",
       "      <td>Gary McKendry</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>795374</td>\n",
       "      <td>nm0193485</td>\n",
       "      <td>Richard Curtis</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Product Rating Director ID Directors First Name\n",
       "0         780354   nm0000965          Danny Boyle\n",
       "1         788339   nm0583600         Nancy Meyers\n",
       "2         790272   nm0126096    James Ward Byrkit\n",
       "3         794156   nm1834213        Gary McKendry\n",
       "4         795374   nm0193485       Richard Curtis"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "directordata.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Lets fix our movie data\n",
    "moviedata = imdbdata[7].str.split('\\t').apply(pd.Series)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "scrolled": true
   },
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>movie</td>\n",
       "      <td>Yesterday</td>\n",
       "      <td>2019</td>\n",
       "      <td>116</td>\n",
       "      <td>Comedy,Fantasy,Music</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>movie</td>\n",
       "      <td>The Parent Trap</td>\n",
       "      <td>1998</td>\n",
       "      <td>128</td>\n",
       "      <td>Adventure,Comedy,Drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>movie</td>\n",
       "      <td>Coherence</td>\n",
       "      <td>2013</td>\n",
       "      <td>89</td>\n",
       "      <td>Drama,Horror,Mystery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>movie</td>\n",
       "      <td>Killer Elite</td>\n",
       "      <td>2011</td>\n",
       "      <td>116</td>\n",
       "      <td>Action,Crime,Thriller</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>movie</td>\n",
       "      <td>Pirate Radio</td>\n",
       "      <td>2009</td>\n",
       "      <td>135</td>\n",
       "      <td>Comedy,Drama,Music</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       0                1     2    3                       4\n",
       "0  movie        Yesterday  2019  116    Comedy,Fantasy,Music\n",
       "1  movie  The Parent Trap  1998  128  Adventure,Comedy,Drama\n",
       "2  movie        Coherence  2013   89    Drama,Horror,Mystery\n",
       "3  movie     Killer Elite  2011  116   Action,Crime,Thriller\n",
       "4  movie     Pirate Radio  2009  135      Comedy,Drama,Music"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "moviedata.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Rename the columns\n",
    "moviedata.columns = ['Title Type', 'Title Name', 'Start Year', 'Title Duration', 'Genre']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title Type</th>\n",
       "      <th>Title Name</th>\n",
       "      <th>Start Year</th>\n",
       "      <th>Title Duration</th>\n",
       "      <th>Genre</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>movie</td>\n",
       "      <td>Yesterday</td>\n",
       "      <td>2019</td>\n",
       "      <td>116</td>\n",
       "      <td>Comedy,Fantasy,Music</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>movie</td>\n",
       "      <td>The Parent Trap</td>\n",
       "      <td>1998</td>\n",
       "      <td>128</td>\n",
       "      <td>Adventure,Comedy,Drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>movie</td>\n",
       "      <td>Coherence</td>\n",
       "      <td>2013</td>\n",
       "      <td>89</td>\n",
       "      <td>Drama,Horror,Mystery</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>movie</td>\n",
       "      <td>Killer Elite</td>\n",
       "      <td>2011</td>\n",
       "      <td>116</td>\n",
       "      <td>Action,Crime,Thriller</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>movie</td>\n",
       "      <td>Pirate Radio</td>\n",
       "      <td>2009</td>\n",
       "      <td>135</td>\n",
       "      <td>Comedy,Drama,Music</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Title Type       Title Name Start Year Title Duration  \\\n",
       "0      movie        Yesterday       2019            116   \n",
       "1      movie  The Parent Trap       1998            128   \n",
       "2      movie        Coherence       2013             89   \n",
       "3      movie     Killer Elite       2011            116   \n",
       "4      movie     Pirate Radio       2009            135   \n",
       "\n",
       "                    Genre  \n",
       "0    Comedy,Fantasy,Music  \n",
       "1  Adventure,Comedy,Drama  \n",
       "2    Drama,Horror,Mystery  \n",
       "3   Action,Crime,Thriller  \n",
       "4      Comedy,Drama,Music  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "moviedata.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>4</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>Title Type</th>\n",
       "      <th>Title Name</th>\n",
       "      <th>Start Year</th>\n",
       "      <th>Title Duration</th>\n",
       "      <th>Genre</th>\n",
       "      <th>Product Rating</th>\n",
       "      <th>Director ID</th>\n",
       "      <th>Directors First Name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>780354\\tnm0000965\\tDanny Boyle</td>\n",
       "      <td>nm0000965</td>\n",
       "      <td>tt8079248</td>\n",
       "      <td>780354.44</td>\n",
       "      <td>movie\\tYesterday\\t2019\\t116\\tComedy,Fantasy,Music</td>\n",
       "      <td>movie</td>\n",
       "      <td>Yesterday</td>\n",
       "      <td>2019</td>\n",
       "      <td>116</td>\n",
       "      <td>Comedy,Fantasy,Music</td>\n",
       "      <td>780354</td>\n",
       "      <td>nm0000965</td>\n",
       "      <td>Danny Boyle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>788339\\tnm0583600\\tNancy Meyers</td>\n",
       "      <td>nm0583600</td>\n",
       "      <td>tt0120783</td>\n",
       "      <td>788339.50</td>\n",
       "      <td>movie\\tThe Parent Trap\\t1998\\t128\\tAdventure,C...</td>\n",
       "      <td>movie</td>\n",
       "      <td>The Parent Trap</td>\n",
       "      <td>1998</td>\n",
       "      <td>128</td>\n",
       "      <td>Adventure,Comedy,Drama</td>\n",
       "      <td>788339</td>\n",
       "      <td>nm0583600</td>\n",
       "      <td>Nancy Meyers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>790272\\tnm0126096\\tJames Ward Byrkit</td>\n",
       "      <td>nm0126096</td>\n",
       "      <td>tt2866360</td>\n",
       "      <td>790272.00</td>\n",
       "      <td>movie\\tCoherence\\t2013\\t89\\tDrama,Horror,Mystery</td>\n",
       "      <td>movie</td>\n",
       "      <td>Coherence</td>\n",
       "      <td>2013</td>\n",
       "      <td>89</td>\n",
       "      <td>Drama,Horror,Mystery</td>\n",
       "      <td>790272</td>\n",
       "      <td>nm0126096</td>\n",
       "      <td>James Ward Byrkit</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>794156\\tnm1834213\\tGary McKendry</td>\n",
       "      <td>nm1834213</td>\n",
       "      <td>tt1448755</td>\n",
       "      <td>794156.80</td>\n",
       "      <td>movie\\tKiller Elite\\t2011\\t116\\tAction,Crime,T...</td>\n",
       "      <td>movie</td>\n",
       "      <td>Killer Elite</td>\n",
       "      <td>2011</td>\n",
       "      <td>116</td>\n",
       "      <td>Action,Crime,Thriller</td>\n",
       "      <td>794156</td>\n",
       "      <td>nm1834213</td>\n",
       "      <td>Gary McKendry</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>795374\\tnm0193485\\tRichard Curtis</td>\n",
       "      <td>nm0193485</td>\n",
       "      <td>tt1131729</td>\n",
       "      <td>795374.20</td>\n",
       "      <td>movie\\tPirate Radio\\t2009\\t135\\tComedy,Drama,M...</td>\n",
       "      <td>movie</td>\n",
       "      <td>Pirate Radio</td>\n",
       "      <td>2009</td>\n",
       "      <td>135</td>\n",
       "      <td>Comedy,Drama,Music</td>\n",
       "      <td>795374</td>\n",
       "      <td>nm0193485</td>\n",
       "      <td>Richard Curtis</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                      0          1          4          6  \\\n",
       "0        780354\\tnm0000965\\tDanny Boyle  nm0000965  tt8079248  780354.44   \n",
       "1       788339\\tnm0583600\\tNancy Meyers  nm0583600  tt0120783  788339.50   \n",
       "2  790272\\tnm0126096\\tJames Ward Byrkit  nm0126096  tt2866360  790272.00   \n",
       "3      794156\\tnm1834213\\tGary McKendry  nm1834213  tt1448755  794156.80   \n",
       "4     795374\\tnm0193485\\tRichard Curtis  nm0193485  tt1131729  795374.20   \n",
       "\n",
       "                                                   7 Title Type  \\\n",
       "0  movie\\tYesterday\\t2019\\t116\\tComedy,Fantasy,Music      movie   \n",
       "1  movie\\tThe Parent Trap\\t1998\\t128\\tAdventure,C...      movie   \n",
       "2   movie\\tCoherence\\t2013\\t89\\tDrama,Horror,Mystery      movie   \n",
       "3  movie\\tKiller Elite\\t2011\\t116\\tAction,Crime,T...      movie   \n",
       "4  movie\\tPirate Radio\\t2009\\t135\\tComedy,Drama,M...      movie   \n",
       "\n",
       "        Title Name Start Year Title Duration                   Genre  \\\n",
       "0        Yesterday       2019            116    Comedy,Fantasy,Music   \n",
       "1  The Parent Trap       1998            128  Adventure,Comedy,Drama   \n",
       "2        Coherence       2013             89    Drama,Horror,Mystery   \n",
       "3     Killer Elite       2011            116   Action,Crime,Thriller   \n",
       "4     Pirate Radio       2009            135      Comedy,Drama,Music   \n",
       "\n",
       "  Product Rating Director ID Directors First Name  \n",
       "0         780354   nm0000965          Danny Boyle  \n",
       "1         788339   nm0583600         Nancy Meyers  \n",
       "2         790272   nm0126096    James Ward Byrkit  \n",
       "3         794156   nm1834213        Gary McKendry  \n",
       "4         795374   nm0193485       Richard Curtis  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Add to our original the fixed data\n",
    "imdbdata = pd.concat([imdbdata, moviedata, directordata], axis = 1)\n",
    "imdbdata.head()"
   ]
  },
  {
   "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>4</th>\n",
       "      <th>Title Type</th>\n",
       "      <th>Title Name</th>\n",
       "      <th>Start Year</th>\n",
       "      <th>Title Duration</th>\n",
       "      <th>Genre</th>\n",
       "      <th>Product Rating</th>\n",
       "      <th>Director ID</th>\n",
       "      <th>Directors First Name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>tt8079248</td>\n",
       "      <td>movie</td>\n",
       "      <td>Yesterday</td>\n",
       "      <td>2019</td>\n",
       "      <td>116</td>\n",
       "      <td>Comedy,Fantasy,Music</td>\n",
       "      <td>780354</td>\n",
       "      <td>nm0000965</td>\n",
       "      <td>Danny Boyle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>tt0120783</td>\n",
       "      <td>movie</td>\n",
       "      <td>The Parent Trap</td>\n",
       "      <td>1998</td>\n",
       "      <td>128</td>\n",
       "      <td>Adventure,Comedy,Drama</td>\n",
       "      <td>788339</td>\n",
       "      <td>nm0583600</td>\n",
       "      <td>Nancy Meyers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>tt2866360</td>\n",
       "      <td>movie</td>\n",
       "      <td>Coherence</td>\n",
       "      <td>2013</td>\n",
       "      <td>89</td>\n",
       "      <td>Drama,Horror,Mystery</td>\n",
       "      <td>790272</td>\n",
       "      <td>nm0126096</td>\n",
       "      <td>James Ward Byrkit</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>tt1448755</td>\n",
       "      <td>movie</td>\n",
       "      <td>Killer Elite</td>\n",
       "      <td>2011</td>\n",
       "      <td>116</td>\n",
       "      <td>Action,Crime,Thriller</td>\n",
       "      <td>794156</td>\n",
       "      <td>nm1834213</td>\n",
       "      <td>Gary McKendry</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>tt1131729</td>\n",
       "      <td>movie</td>\n",
       "      <td>Pirate Radio</td>\n",
       "      <td>2009</td>\n",
       "      <td>135</td>\n",
       "      <td>Comedy,Drama,Music</td>\n",
       "      <td>795374</td>\n",
       "      <td>nm0193485</td>\n",
       "      <td>Richard Curtis</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           4 Title Type       Title Name Start Year Title Duration  \\\n",
       "0  tt8079248      movie        Yesterday       2019            116   \n",
       "1  tt0120783      movie  The Parent Trap       1998            128   \n",
       "2  tt2866360      movie        Coherence       2013             89   \n",
       "3  tt1448755      movie     Killer Elite       2011            116   \n",
       "4  tt1131729      movie     Pirate Radio       2009            135   \n",
       "\n",
       "                    Genre Product Rating Director ID Directors First Name  \n",
       "0    Comedy,Fantasy,Music         780354   nm0000965          Danny Boyle  \n",
       "1  Adventure,Comedy,Drama         788339   nm0583600         Nancy Meyers  \n",
       "2    Drama,Horror,Mystery         790272   nm0126096    James Ward Byrkit  \n",
       "3   Action,Crime,Thriller         794156   nm1834213        Gary McKendry  \n",
       "4      Comedy,Drama,Music         795374   nm0193485       Richard Curtis  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "imdbdata = imdbdata.drop([0,1,6,7], axis = 1)\n",
    "imdbdata.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title ID</th>\n",
       "      <th>Title Type</th>\n",
       "      <th>Title Name</th>\n",
       "      <th>Start Year</th>\n",
       "      <th>Title Duration</th>\n",
       "      <th>Genre</th>\n",
       "      <th>Product Rating</th>\n",
       "      <th>Director ID</th>\n",
       "      <th>Directors First Name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>tt8079248</td>\n",
       "      <td>movie</td>\n",
       "      <td>Yesterday</td>\n",
       "      <td>2019</td>\n",
       "      <td>116</td>\n",
       "      <td>Comedy,Fantasy,Music</td>\n",
       "      <td>780354</td>\n",
       "      <td>nm0000965</td>\n",
       "      <td>Danny Boyle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>tt0120783</td>\n",
       "      <td>movie</td>\n",
       "      <td>The Parent Trap</td>\n",
       "      <td>1998</td>\n",
       "      <td>128</td>\n",
       "      <td>Adventure,Comedy,Drama</td>\n",
       "      <td>788339</td>\n",
       "      <td>nm0583600</td>\n",
       "      <td>Nancy Meyers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>tt2866360</td>\n",
       "      <td>movie</td>\n",
       "      <td>Coherence</td>\n",
       "      <td>2013</td>\n",
       "      <td>89</td>\n",
       "      <td>Drama,Horror,Mystery</td>\n",
       "      <td>790272</td>\n",
       "      <td>nm0126096</td>\n",
       "      <td>James Ward Byrkit</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>tt1448755</td>\n",
       "      <td>movie</td>\n",
       "      <td>Killer Elite</td>\n",
       "      <td>2011</td>\n",
       "      <td>116</td>\n",
       "      <td>Action,Crime,Thriller</td>\n",
       "      <td>794156</td>\n",
       "      <td>nm1834213</td>\n",
       "      <td>Gary McKendry</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>tt1131729</td>\n",
       "      <td>movie</td>\n",
       "      <td>Pirate Radio</td>\n",
       "      <td>2009</td>\n",
       "      <td>135</td>\n",
       "      <td>Comedy,Drama,Music</td>\n",
       "      <td>795374</td>\n",
       "      <td>nm0193485</td>\n",
       "      <td>Richard Curtis</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Title ID Title Type       Title Name Start Year Title Duration  \\\n",
       "0  tt8079248      movie        Yesterday       2019            116   \n",
       "1  tt0120783      movie  The Parent Trap       1998            128   \n",
       "2  tt2866360      movie        Coherence       2013             89   \n",
       "3  tt1448755      movie     Killer Elite       2011            116   \n",
       "4  tt1131729      movie     Pirate Radio       2009            135   \n",
       "\n",
       "                    Genre Product Rating Director ID Directors First Name  \n",
       "0    Comedy,Fantasy,Music         780354   nm0000965          Danny Boyle  \n",
       "1  Adventure,Comedy,Drama         788339   nm0583600         Nancy Meyers  \n",
       "2    Drama,Horror,Mystery         790272   nm0126096    James Ward Byrkit  \n",
       "3   Action,Crime,Thriller         794156   nm1834213        Gary McKendry  \n",
       "4      Comedy,Drama,Music         795374   nm0193485       Richard Curtis  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "imdbdata.rename(columns = {4:'Title ID'}, inplace = True)\n",
    "imdbdata.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Get top 50 directors for the last \n",
    "#Get top genres\n",
    "#Get top title types\n",
    "#Get average duration for top 10 movies in last 20 years\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Let us convert our numeric columns\n",
    "\n",
    "imdbdata['Product Rating'] = pd.to_numeric(imdbdata['Product Rating'])\n",
    "imdbdata['Title Duration'] = pd.to_numeric(imdbdata['Title Duration'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "imdbdata.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [],
   "source": [
    "imdbdatatmp = imdbdata\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 100 entries, 28 to 29\n",
      "Data columns (total 9 columns):\n",
      " #   Column                Non-Null Count  Dtype \n",
      "---  ------                --------------  ----- \n",
      " 0   Title ID              100 non-null    object\n",
      " 1   Title Type            100 non-null    object\n",
      " 2   Title Name            100 non-null    object\n",
      " 3   Start Year            100 non-null    object\n",
      " 4   Title Duration        100 non-null    int64 \n",
      " 5   Genre                 100 non-null    object\n",
      " 6   Product Rating        100 non-null    int64 \n",
      " 7   Director ID           100 non-null    object\n",
      " 8   Directors First Name  100 non-null    object\n",
      "dtypes: int64(2), object(7)\n",
      "memory usage: 7.8+ KB\n"
     ]
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title ID</th>\n",
       "      <th>Title Type</th>\n",
       "      <th>Title Name</th>\n",
       "      <th>Start Year</th>\n",
       "      <th>Title Duration</th>\n",
       "      <th>Genre</th>\n",
       "      <th>Product Rating</th>\n",
       "      <th>Director ID</th>\n",
       "      <th>Directors First Name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>tt1375666</td>\n",
       "      <td>movie</td>\n",
       "      <td>Inception</td>\n",
       "      <td>2010</td>\n",
       "      <td>148</td>\n",
       "      <td>Action,Adventure,Sci-Fi</td>\n",
       "      <td>18266170</td>\n",
       "      <td>nm0634240</td>\n",
       "      <td>Christopher Nolan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>tt0434409</td>\n",
       "      <td>movie</td>\n",
       "      <td>V for Vendetta</td>\n",
       "      <td>2005</td>\n",
       "      <td>132</td>\n",
       "      <td>Action,Drama,Sci-Fi</td>\n",
       "      <td>8491739</td>\n",
       "      <td>nm0574625</td>\n",
       "      <td>James McTeigue</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>tt0110357</td>\n",
       "      <td>movie</td>\n",
       "      <td>The Lion King</td>\n",
       "      <td>1994</td>\n",
       "      <td>88</td>\n",
       "      <td>Adventure,Animation,Dramaloop</td>\n",
       "      <td>8039529</td>\n",
       "      <td>nm0021249</td>\n",
       "      <td>Roger Allers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>tt1431045</td>\n",
       "      <td>movie</td>\n",
       "      <td>Deadpool</td>\n",
       "      <td>2016</td>\n",
       "      <td>108</td>\n",
       "      <td>Action,Adventure,Comedy</td>\n",
       "      <td>7246544</td>\n",
       "      <td>nm1783265</td>\n",
       "      <td>Tim Miller</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>tt1454468</td>\n",
       "      <td>movie</td>\n",
       "      <td>Gravity</td>\n",
       "      <td>2013</td>\n",
       "      <td>91</td>\n",
       "      <td>Drama,Sci-Fi,Thriller</td>\n",
       "      <td>5935814</td>\n",
       "      <td>nm0190859</td>\n",
       "      <td>Alfonso Cuarón</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>tt0796366</td>\n",
       "      <td>movie</td>\n",
       "      <td>Star Trek</td>\n",
       "      <td>2009</td>\n",
       "      <td>127</td>\n",
       "      <td>Action,Adventure,Sci-Fi</td>\n",
       "      <td>4566642</td>\n",
       "      <td>nm0009190</td>\n",
       "      <td>J.J. Abrams</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>tt5052448</td>\n",
       "      <td>movie</td>\n",
       "      <td>Get Out</td>\n",
       "      <td>2017</td>\n",
       "      <td>104</td>\n",
       "      <td>Horror,Mystery,Thriller</td>\n",
       "      <td>3816366</td>\n",
       "      <td>nm1443502</td>\n",
       "      <td>Jordan Peele</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>tt0234215</td>\n",
       "      <td>movie</td>\n",
       "      <td>The Matrix Reloaded</td>\n",
       "      <td>2003</td>\n",
       "      <td>138</td>\n",
       "      <td>Action,Sci-Filoop</td>\n",
       "      <td>3725366</td>\n",
       "      <td>nm0905152</td>\n",
       "      <td>Lilly Wachowski</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>tt2306299</td>\n",
       "      <td>tvSeries</td>\n",
       "      <td>Vikings</td>\n",
       "      <td>2013</td>\n",
       "      <td>44</td>\n",
       "      <td>Action,Adventure,Dramaloop</td>\n",
       "      <td>3683738</td>\n",
       "      <td>nm0935395</td>\n",
       "      <td>Katheryn Winnick</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>tt0945513</td>\n",
       "      <td>movie</td>\n",
       "      <td>Source Code</td>\n",
       "      <td>2011</td>\n",
       "      <td>93</td>\n",
       "      <td>Action,Drama,Mystery</td>\n",
       "      <td>3643710</td>\n",
       "      <td>nm1512910</td>\n",
       "      <td>Duncan Jones</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Title ID Title Type           Title Name Start Year  Title Duration  \\\n",
       "99  tt1375666      movie            Inception       2010             148   \n",
       "98  tt0434409      movie       V for Vendetta       2005             132   \n",
       "97  tt0110357      movie        The Lion King       1994              88   \n",
       "96  tt1431045      movie             Deadpool       2016             108   \n",
       "95  tt1454468      movie              Gravity       2013              91   \n",
       "94  tt0796366      movie            Star Trek       2009             127   \n",
       "93  tt5052448      movie              Get Out       2017             104   \n",
       "92  tt0234215      movie  The Matrix Reloaded       2003             138   \n",
       "91  tt2306299   tvSeries              Vikings       2013              44   \n",
       "90  tt0945513      movie          Source Code       2011              93   \n",
       "\n",
       "                            Genre  Product Rating Director ID  \\\n",
       "99        Action,Adventure,Sci-Fi        18266170   nm0634240   \n",
       "98            Action,Drama,Sci-Fi         8491739   nm0574625   \n",
       "97  Adventure,Animation,Dramaloop         8039529   nm0021249   \n",
       "96        Action,Adventure,Comedy         7246544   nm1783265   \n",
       "95          Drama,Sci-Fi,Thriller         5935814   nm0190859   \n",
       "94        Action,Adventure,Sci-Fi         4566642   nm0009190   \n",
       "93        Horror,Mystery,Thriller         3816366   nm1443502   \n",
       "92              Action,Sci-Filoop         3725366   nm0905152   \n",
       "91     Action,Adventure,Dramaloop         3683738   nm0935395   \n",
       "90           Action,Drama,Mystery         3643710   nm1512910   \n",
       "\n",
       "   Directors First Name  \n",
       "99    Christopher Nolan  \n",
       "98       James McTeigue  \n",
       "97         Roger Allers  \n",
       "96           Tim Miller  \n",
       "95       Alfonso Cuarón  \n",
       "94          J.J. Abrams  \n",
       "93         Jordan Peele  \n",
       "92      Lilly Wachowski  \n",
       "91     Katheryn Winnick  \n",
       "90         Duncan Jones  "
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Get top ten directors based on product rating\n",
    "imdbdatatmp.sort_values(by=['Product Rating'], inplace = True, ascending = False)\n",
    "imdbdatatmp.head(10)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['tvMiniSeries', 'movie', 'tvEpisode', 'tvSeries'], dtype=object)"
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "imdbdata['Title Type'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:>"
      ]
     },
     "execution_count": 74,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXAAAAEsCAYAAADaVeizAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8vihELAAAACXBIWXMAAAsTAAALEwEAmpwYAAATnUlEQVR4nO3df5RndX3f8edLFisiJlAWJfhjgaxYf0SxexIVjklECAYrxErFSrIBGnIiSbTUJmtqD8fm9IRYD22SEzUbE7ONBkUkglEb6CpaPUaziwrCmmIFCYqy1hAxNfzQd//43nGGdWBnZ74zd96zz8c5nO/33u93dl7ny+5r7nzu/XxuqgpJUj8PGzuAJGlxLHBJasoCl6SmLHBJasoCl6SmLHBJamrdSn6zww8/vDZs2LCS31KS2tu5c+fXq2r9nvtXtMA3bNjAjh07VvJbSlJ7Sb40336HUCSpKQtckpqywCWpKQtckpqywCWpKQtckpqywCWpKQtckppa0Yk8y2HDlvePHWFBbr34tLEjSFpjPAKXpKYscElqygKXpKYscElqygKXpKYscElqygKXpKYscElqygKXpKYscElqygKXpKYscElqakEFnuTfJrkxyeeSXJrkEUkOS3JNkpuHx0OXO6wkadZeCzzJUcCvApuq6mnAAcBZwBZge1VtBLYP25KkFbLQIZR1wEFJ1gGPBL4CnA5sG17fBpwx9XSSpAe11wKvqi8DbwRuA+4A/r6qrgYeU1V3DO+5AzhiOYNKkh5oIUMohzI52j4a+CHg4CRnL/QbJDk/yY4kO3bv3r34pJKkB1jIEMoLgFuqandV3QdcATwX+FqSIwGGxzvn++Kq2lpVm6pq0/r166eVW5L2ewsp8NuAZyd5ZJIAJwG7gKuAzcN7NgNXLk9ESdJ89npPzKr6ZJLLgeuA+4FPA1uBRwGXJTmPScmfuZxBJUkPtKCbGlfVRcBFe+y+h8nRuCRpBM7ElKSmLHBJasoCl6SmLHBJasoCl6SmLHBJasoCl6SmLHBJasoCl6SmLHBJasoCl6SmLHBJasoCl6SmLHBJasoCl6SmLHBJasoCl6SmLHBJasoCl6SmLHBJasoCl6SmLHBJasoCl6SmLHBJasoCl6SmLHBJasoCl6SmLHBJasoCl6SmLHBJasoCl6SmLHBJasoCl6SmLHBJasoCl6SmLHBJasoCl6SmLHBJasoCl6SmFlTgSX4wyeVJPp9kV5LnJDksyTVJbh4eD13usJKkWQs9Av8d4H9U1ZOBZwC7gC3A9qraCGwftiVJK2SvBZ7k0cDzgD8CqKp7q+ou4HRg2/C2bcAZyxNRkjSfhRyBHwPsBt6W5NNJ3prkYOAxVXUHwPB4xDLmlCTtYSEFvg54FvDmqjoe+Af2YbgkyflJdiTZsXv37kXGlCTtaSEFfjtwe1V9cti+nEmhfy3JkQDD453zfXFVba2qTVW1af369dPILEliAQVeVV8F/jbJccOuk4CbgKuAzcO+zcCVy5JQkjSvdQt8368A70jycOCLwDlMyv+yJOcBtwFnLk9ESdJ8FlTgVfUZYNM8L5001TSSpAVzJqYkNWWBS1JTFrgkNWWBS1JTFrgkNWWBS1JTFrgkNWWBS1JTFrgkNWWBS1JTFrgkNWWBS1JTFrgkNWWBS1JTFrgkNWWBS1JTFrgkNWWBS1JTFrgkNWWBS1JTFrgkNWWBS1JTFrgkNWWBS1JTFrgkNWWBS1JTFrgkNWWBS1JTFrgkNWWBS1JTFrgkNWWBS1JTFrgkNWWBS1JTFrgkNWWBS1JTFrgkNWWBS1JTCy7wJAck+XSSvxi2D0tyTZKbh8dDly+mJGlP+3IE/ipg15ztLcD2qtoIbB+2JUkrZEEFnuRxwGnAW+fsPh3YNjzfBpwx1WSSpIe00CPw/wb8GvDdOfseU1V3AAyPR0w3miTpoey1wJO8CLizqnYu5hskOT/JjiQ7du/evZg/QpI0j4UcgZ8AvDjJrcA7gecneTvwtSRHAgyPd873xVW1tao2VdWm9evXTym2JGmvBV5Vr62qx1XVBuAs4ENVdTZwFbB5eNtm4MplSylJ+j5LuQ78YuDkJDcDJw/bkqQVsm5f3lxV1wLXDs//L3DS9CNJkhbCmZiS1JQFLklNWeCS1JQFLklNWeCS1JQFLklNWeCS1JQFLklNWeCS1JQFLklNWeCS1JQFLklNWeCS1JQFLklNWeCS1JQFLklNWeCS1JQFLklNWeCS1JQFLklNWeCS1JQFLklNWeCS1JQFLklNWeCS1JQFLklNWeCS1JQFLklNWeCS1JQFLklNWeCS1JQFLklNWeCS1JQFLklNWeCS1JQFLklNWeCS1JQFLklNWeCS1NReCzzJ45N8OMmuJDcmedWw/7Ak1yS5eXg8dPnjSpJmLOQI/H7g31XVPwOeDVyQ5CnAFmB7VW0Etg/bkqQVstcCr6o7quq64fndwC7gKOB0YNvwtm3AGcuUUZI0j30aA0+yATge+CTwmKq6AyYlDxwx9XSSpAe14AJP8ijgPcCrq+qb+/B15yfZkWTH7t27F5NRkjSPBRV4kgOZlPc7quqKYffXkhw5vH4kcOd8X1tVW6tqU1VtWr9+/TQyS5JY2FUoAf4I2FVVl8x56Spg8/B8M3Dl9ONJkh7MugW85wTgZ4Ebknxm2PcbwMXAZUnOA24DzlyWhJKkee21wKvqY0Ae5OWTphtHkrRQzsSUpKYscElqygKXpKYscElqygKXpKYscElqygKXpKYscElqygKXpKYscElqygKXpKYscElqygKXpKYscElqygKXpKYscElqaiF35NF+ZMOW948dYa9uvfi0sSNIq4JH4JLUlAUuSU1Z4JLUlAUuSU1Z4JLUlAUuSU1Z4JLUlAUuSU1Z4JLUlAUuSU1Z4JLUlAUuSU1Z4JLUlAUuSU1Z4JLUlAUuSU1Z4JLUlAUuSU1Z4JLUlAUuSU1Z4JLUlAUuSU0tqcCTnJrkb5J8IcmWaYWSJO3dusV+YZIDgN8HTgZuB/46yVVVddO0wkmdbdjy/rEjLMitF582doQF8fP8fks5Av9R4AtV9cWquhd4J3D6dGJJkvZmKQV+FPC3c7ZvH/ZJklbAoodQgMyzr77vTcn5wPnD5reS/M0SvudKORz4+jT/wPz2NP+0dqb6efpZ+ndzirp8nk+cb+dSCvx24PFzth8HfGXPN1XVVmDrEr7Pikuyo6o2jZ1jrfDznB4/y+nq/nkuZQjlr4GNSY5O8nDgLOCq6cSSJO3Noo/Aq+r+JL8M/CVwAPDHVXXj1JJJkh7SUoZQqKoPAB+YUpbVpNWQTwN+ntPjZzldrT/PVH3feUdJUgNOpZekpixwSWrKApekpizwQZInJdme5HPD9o8ked3YuTpK8oYkj05y4PCZfj3J2WPn6ijJmUkOGZ6/LskVSZ41dq7OkjwxyQuG5wfNfL4dWeCz/hB4LXAfQFVdz+Tadu27U6rqm8CLmEz4ehLw78eN1NZ/rKq7k5wI/BSwDXjzyJnaSvILwOXAHwy7Hge8d7RAS2SBz3pkVX1qj333j5KkvwOHx58GLq2qb4wZprnvDI+nAW+uqiuBh4+Yp7sLgBOAbwJU1c3AEaMmWgILfNbXkxzLsJ5LkpcCd4wbqa33Jfk8sAnYnmQ98I8jZ+rqy0n+APhXwAeS/BP8d7sU9wyrpwKQZB3zrOHUhdeBD5Icw+Si/ucCfwfcApxdVbeOmaurJIcC36yq7yQ5GDikqr46dq5ukjwSOBW4oapuTnIk8PSqunrkaC0leQNwF/BzwK8ArwRuqqr/MGauxbLA9zCUzcOq6u6xs3Q1lM6FwBOq6vwkG4HjquovRo7W0jD+vbGq3jb8NvOoqrpl7FwdJXkYcB5wCpMVVf8SeGs1LcL9vsCTnF1Vb09y4XyvV9UlK52puyTvAnYCP1dVT0tyEPCJqnrmuMn6SXIRk6Go46rqSUl+CHh3VZ0wcjStAktaC2WNOHh4bHsp0Sp0bFW9LMnLAarq20nmWz9ee/czwPHAdQBV9ZXOl72NJckNPMRYd1X9yArGmZr9vsCrauZyojdV1e5Rw6wd9w5H3TMnhI8F7hk3Ulv3VlUlmfksD97bF2heLxoeLxge/3R4fAXw/1Y+znTs90MoM5LczOTE5buAK6rq70aO1FaSk4HXAU8BrmZy2dbPV9W1Y+bqKMlrgI1Mbh7+W8C5wJ9V1e+NGqypJB/fc/hpvn1dWOBzJPlRJpN3zgBuAt5ZVW8fNVRTSf4p8GwmJ4r+qqqmetuq/cnwA/F7J92q6pqRI7WV5DPAL1fVx4bt5zL57fuZY+ZaLAt8HkkOBy4BXlFVB4ydp4skT66qzz/YVO+qum6lM0lzJfnnwB8DPzDsugs4t+vfTQt8kOTRTE4YnQUcC/w5cFlV7Rw1WCNJtg6XDX54nperqp6/4qGaSvKxqjoxyd088ORbmHyWjx4p2pow/HtPVf392FmWwgIfJLmFyZoIl1XVJ0aO09Zwne1zqurjY2eR9pTkB4CLgOcNuz4C/KeuRW6BD5JkONt/CJMjnG+NnamrJJ+oqueMnaO74Yfh9VX1tLGzrBVJ3gN8jsmiYAA/Czyjql4yXqrFc02FWU9N8mkm/3NvSrIzif9wFufqJP/Sa7+Xpqq+C3w2yRPGzrKGHFtVF1XVF4f/Xg8cM3aoxdrvrwOfYytwYVV9GCDJTzC7Nor2zYVMJkh9J8m3cdx2KY4EbkzyKeAfZnZW1YvHi9Tat5OcOOcqlBOAb4+cadEs8FkHz5Q3QFVd66SJxakqZwpOz+vHDrDG/BKwbRgLD/AN4OdHTbQEjoEPkvw5k+nKMzO0zgY2VdUZo4Vqahg6eQVwdFX9ZpLHA0fOs966FiDJE5ksZvU/h4XCDnCxtaUZrkJhuPFIW46BzzoXWA+8B7gCOJzGP5lH9ibgOcC/Hra/Bfz+eHH6mucOMkfR+A4yY0vyqqG87wYuSXJdklPGzrVYFvisY4HHM/lMDgROAj46aqK+fqyqLmC4icOwLIF3kVmcNXUHmVXg3OGo+xQmn+M5wMXjRlo8x8BnvQN4DZOrUL47cpbu7ktyALOLWa3Hz3Sx7qmqe2cu6Ol+B5lVYObKqJ8G3lZVn+18tZQFPmt3Vb1v7BBrxO8ymcl6RJL/DLyUyeJW2ncfSfIbwEHDmiivBPx7ung7k1wNHA28dpj30fbgwpOYgyQnAS8HtjNn6dOqumK0UI0leTKTYSiAD1XVrjHzdLXW7iAztuHzfCbwxaq6a1h07aiqun7cZItjgQ+SvB14MnAjsz+Rq6rOHS9VL8MVEvdV1X3D9nFMflX9kj8IlybJw4GnAl+uqjvHztPNWl1ozQIfJLmhqp4+do7OknwUOG+4+e4PA59icm7hKcCnquq1owZsJMlbgN+rqhuHa5Y/AXwHOAx4TVVdOmrAZtbqQmsW+CDJHwL/tapuGjtLV3N/CCb5TeCwqrpgOHrc6Q/IhUtyY1U9dXj+auAnquqMJI8FPlhVx48aUKuCJzFnnQhsHlYlvIfZ6d8t75U3krlHA88H/gvAcBVF2xNFI7l3zvOTgXcDVNVXG180Mbokj2ByIvhEJn9f/xfwlqr6x1GDLZIFPuvUsQOsAdcneSPwFeCHmdxOjSQ/OGaopu5K8iLgy0yuAz8PvncZ4UFjBmvuvzOZxDNzS7qXM5l9feZoiZbAAh9U1ZfGzrAG/ALwKuAJwClVNXOz2KcAbxwtVU+/yORyzMcCr66qrw77TwLeP1qq/o6rqmfM2f5wks+OlmaJHAPX1CX5GeADVeWd6LWqJPkTJkMmfzVs/xiwuapeOWqwRbLANXVJ3sZkDPyjwDuZ3Ij3/nFT9ZLk16rqDUl+d77Xq+pXVzrTWpBkF3AccNuw6wnALiaXDrc75+UQiqauqs5JciDwQiYLWr0pyTVV9W9GjtbJzMQn78k6XWvqXJdH4Fo2Q4mfymTBoOdV1eEjR9J+Ksnzq+pDw/Ojq+qWOa+9pOtEMwtcU5fkVOAs4CeBa4F3AVc7jLLvkjyJySJrG5jzG3PXiSdjSXJdVT1rz+fzbXfiEIqWwznApcAvzpzITPLbwK+PmqqndwNvAd7KZCamFicP8ny+7TYscC2HjVX13j32vRALfDHur6o3jx1iDagHeT7fdhsWuKYmyS8xmeV2TJK5q7sdAnx8nFTtvS/JK5kszzt3lcxvjBeppWOSXMXkaHvmOcP20ePFWhrHwDU1w6JLhwK/BWyZ89LdFs7iDEs77Kmq6pgVD9NYkh9/qNer6iMrlWWaLHBJ+421NsnMApdWoZnL3pK8ZL7Xu172Nra1NsnMMXBpdfpx4EPAv5jntQIs8EVYa5PMPAKXtN9ZK5PMLHBpFUpy4UO9XlWXrFSWtWStTTKzwKVVaLgBxmeADzJ7g5HvqarXjxCrvSTvYjLJ7INzJ5lVVcs5Cha4tAoleSaTI8VTmSxodSmw3bvRL8180+aTXN9tFcIZFri0yiV5LpM7x7wA+PWqumovX6I9zJ1kBvyfOS8dAny8qs4eJdgSeRWKtIolWQ8cDzwduB24c9xEbf0Zk+GoNTXJzCNwaRVKcg7wMuARwOXAZVVleesBLHBpFRpOYt7A7J1jHvAPtapevOKhtOo4hCKtTj85dgCtfh6BS6vYWlu7Q9P1sLEDSHpILwb+d5I/TXJaEn9r1vd4BC6tcnPW7ngZcCLQdu0OTZcFLjWwVtbu0HQ5hCKtYklOTfInwBeAlzK5N+ZjRw2lVcMjcGkVW2trd2i6PAKXVreNVfXePa5CeeFoabSqeEZbWoW8QbQWwiEUaRXyBtFaCAtckppyDFySmrLAJakpC1ySmrLAJakpC1ySmvr/T7PFd/GwdvMAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "#Get top title type\n",
    "import numpy as np\n",
    "from matplotlib import pyplot as plt\n",
    "\n",
    "\n",
    "imdbdatatmp['Title Type'].value_counts().plot(kind='bar')\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title ID</th>\n",
       "      <th>Title Type</th>\n",
       "      <th>Title Name</th>\n",
       "      <th>Start Year</th>\n",
       "      <th>Title Duration</th>\n",
       "      <th>Genre</th>\n",
       "      <th>Product Rating</th>\n",
       "      <th>Director ID</th>\n",
       "      <th>Directors First Name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>tt2948372</td>\n",
       "      <td>movie</td>\n",
       "      <td>Soul</td>\n",
       "      <td>2020</td>\n",
       "      <td>100</td>\n",
       "      <td>Adventure,Animation,Comedyloop</td>\n",
       "      <td>1456420</td>\n",
       "      <td>nm5358492</td>\n",
       "      <td>Kemp Powers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>tt2661044</td>\n",
       "      <td>tvSeries</td>\n",
       "      <td>The 100</td>\n",
       "      <td>2014</td>\n",
       "      <td>43</td>\n",
       "      <td>Drama,Mystery,Sci-Filoop</td>\n",
       "      <td>1647968</td>\n",
       "      <td>nm4289392</td>\n",
       "      <td>Lindsey Morgan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>tt4729430</td>\n",
       "      <td>movie</td>\n",
       "      <td>Klaus</td>\n",
       "      <td>2019</td>\n",
       "      <td>96</td>\n",
       "      <td>Adventure,Animation,Comedyloop</td>\n",
       "      <td>872963</td>\n",
       "      <td>nm3582089</td>\n",
       "      <td>Carlos Martínez López</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>tt9561862</td>\n",
       "      <td>tvSeries</td>\n",
       "      <td>Love, Death &amp; Robots</td>\n",
       "      <td>2019</td>\n",
       "      <td>15</td>\n",
       "      <td>Animation,Comedy,Fantasyloop</td>\n",
       "      <td>824602</td>\n",
       "      <td>nm3230254</td>\n",
       "      <td>Robert Valley</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>tt7984734</td>\n",
       "      <td>movie</td>\n",
       "      <td>The Lighthouse</td>\n",
       "      <td>2019</td>\n",
       "      <td>109</td>\n",
       "      <td>Drama,Fantasy,Horror</td>\n",
       "      <td>1088137</td>\n",
       "      <td>nm3211470</td>\n",
       "      <td>Robert Eggers</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>tt0094291</td>\n",
       "      <td>movie</td>\n",
       "      <td>Wall Street</td>\n",
       "      <td>1987</td>\n",
       "      <td>126</td>\n",
       "      <td>Crime,Drama</td>\n",
       "      <td>1067087</td>\n",
       "      <td>nm0000231</td>\n",
       "      <td>Oliver Stone</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>tt1320253</td>\n",
       "      <td>movie</td>\n",
       "      <td>The Expendables</td>\n",
       "      <td>2010</td>\n",
       "      <td>103</td>\n",
       "      <td>Action,Adventure,Thriller</td>\n",
       "      <td>2121236</td>\n",
       "      <td>nm0000230</td>\n",
       "      <td>Sylvester Stallone</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>tt0472043</td>\n",
       "      <td>movie</td>\n",
       "      <td>Apocalypto</td>\n",
       "      <td>2006</td>\n",
       "      <td>139</td>\n",
       "      <td>Action,Adventure,Drama</td>\n",
       "      <td>2274955</td>\n",
       "      <td>nm0000154</td>\n",
       "      <td>Mel Gibson</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>tt0106489</td>\n",
       "      <td>movie</td>\n",
       "      <td>A Bronx Tale</td>\n",
       "      <td>1993</td>\n",
       "      <td>121</td>\n",
       "      <td>Crime,Drama,Romance</td>\n",
       "      <td>1003025</td>\n",
       "      <td>nm0000134</td>\n",
       "      <td>Robert De Niro</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>tt0095159</td>\n",
       "      <td>movie</td>\n",
       "      <td>A Fish Called Wanda</td>\n",
       "      <td>1988</td>\n",
       "      <td>108</td>\n",
       "      <td>Comedy,Crimeloop</td>\n",
       "      <td>989790</td>\n",
       "      <td>nm0000092</td>\n",
       "      <td>John Cleese</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>100 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Title ID Title Type            Title Name Start Year Title Duration  \\\n",
       "56  tt2948372      movie                  Soul       2020            100   \n",
       "59  tt2661044   tvSeries               The 100       2014             43   \n",
       "12  tt4729430      movie                 Klaus       2019             96   \n",
       "8   tt9561862   tvSeries  Love, Death & Robots       2019             15   \n",
       "39  tt7984734      movie        The Lighthouse       2019            109   \n",
       "..        ...        ...                   ...        ...            ...   \n",
       "37  tt0094291      movie           Wall Street       1987            126   \n",
       "76  tt1320253      movie       The Expendables       2010            103   \n",
       "78  tt0472043      movie            Apocalypto       2006            139   \n",
       "29  tt0106489      movie          A Bronx Tale       1993            121   \n",
       "28  tt0095159      movie   A Fish Called Wanda       1988            108   \n",
       "\n",
       "                             Genre Product Rating Director ID  \\\n",
       "56  Adventure,Animation,Comedyloop        1456420   nm5358492   \n",
       "59        Drama,Mystery,Sci-Filoop        1647968   nm4289392   \n",
       "12  Adventure,Animation,Comedyloop         872963   nm3582089   \n",
       "8     Animation,Comedy,Fantasyloop         824602   nm3230254   \n",
       "39            Drama,Fantasy,Horror        1088137   nm3211470   \n",
       "..                             ...            ...         ...   \n",
       "37                     Crime,Drama        1067087   nm0000231   \n",
       "76       Action,Adventure,Thriller        2121236   nm0000230   \n",
       "78          Action,Adventure,Drama        2274955   nm0000154   \n",
       "29             Crime,Drama,Romance        1003025   nm0000134   \n",
       "28                Comedy,Crimeloop         989790   nm0000092   \n",
       "\n",
       "     Directors First Name  \n",
       "56            Kemp Powers  \n",
       "59         Lindsey Morgan  \n",
       "12  Carlos Martínez López  \n",
       "8           Robert Valley  \n",
       "39          Robert Eggers  \n",
       "..                    ...  \n",
       "37           Oliver Stone  \n",
       "76     Sylvester Stallone  \n",
       "78             Mel Gibson  \n",
       "29         Robert De Niro  \n",
       "28            John Cleese  \n",
       "\n",
       "[100 rows x 9 columns]"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "imdbdata"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}