FeatureSelect.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import warnings\n",
    "warnings.filterwarnings(\"ignore\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv('IMDBcleaned.csv')"
   ]
  },
  {
   "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>Movie Name</th>\n",
       "      <th>Director</th>\n",
       "      <th>Running Time</th>\n",
       "      <th>Country</th>\n",
       "      <th>Language</th>\n",
       "      <th>IMDB Rating</th>\n",
       "      <th>Genre</th>\n",
       "      <th>Number of votes</th>\n",
       "      <th>Plot</th>\n",
       "      <th>Cast</th>\n",
       "      <th>Release Year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>The Shawshank Redemption</td>\n",
       "      <td>Frank Darabont</td>\n",
       "      <td>142</td>\n",
       "      <td>USA</td>\n",
       "      <td>English</td>\n",
       "      <td>9.3</td>\n",
       "      <td>Drama</td>\n",
       "      <td>2,161,135</td>\n",
       "      <td>Two imprisoned men bond over a number of years...</td>\n",
       "      <td>Tim Robbins, Morgan Freeman, Bob Gunton, Willi...</td>\n",
       "      <td>1994</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>The Godfather</td>\n",
       "      <td>Francis Ford Coppola</td>\n",
       "      <td>175</td>\n",
       "      <td>USA</td>\n",
       "      <td>English</td>\n",
       "      <td>9.2</td>\n",
       "      <td>Crime</td>\n",
       "      <td>1,483,236</td>\n",
       "      <td>The aging patriarch of an organized crime dyna...</td>\n",
       "      <td>Marlon Brando, Al Pacino, James Caan, Richard ...</td>\n",
       "      <td>1972</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>The Godfather: Part II</td>\n",
       "      <td>Francis Ford Coppola</td>\n",
       "      <td>202</td>\n",
       "      <td>USA</td>\n",
       "      <td>English</td>\n",
       "      <td>9.0</td>\n",
       "      <td>Crime</td>\n",
       "      <td>1,032,840</td>\n",
       "      <td>The early life and career of Vito Corleone in ...</td>\n",
       "      <td>Al Pacino, Robert Duvall, Diane Keaton, Robert...</td>\n",
       "      <td>1974</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>The Dark Knight</td>\n",
       "      <td>Christopher Nolan</td>\n",
       "      <td>152</td>\n",
       "      <td>USA</td>\n",
       "      <td>English</td>\n",
       "      <td>9.0</td>\n",
       "      <td>Action</td>\n",
       "      <td>2,136,058</td>\n",
       "      <td>When the menace known as the Joker wreaks havo...</td>\n",
       "      <td>Christian Bale, Heath Ledger, Aaron Eckhart, M...</td>\n",
       "      <td>2008</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>12 Angry Men</td>\n",
       "      <td>Sidney Lumet</td>\n",
       "      <td>96</td>\n",
       "      <td>USA</td>\n",
       "      <td>English</td>\n",
       "      <td>8.9</td>\n",
       "      <td>Drama</td>\n",
       "      <td>618,106</td>\n",
       "      <td>A jury holdout attempts to prevent a miscarria...</td>\n",
       "      <td>Martin Balsam, John Fiedler, Lee J. Cobb, E.G....</td>\n",
       "      <td>1957</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Schindler's List</td>\n",
       "      <td>Steven Spielberg</td>\n",
       "      <td>195</td>\n",
       "      <td>USA</td>\n",
       "      <td>English</td>\n",
       "      <td>8.9</td>\n",
       "      <td>Biography</td>\n",
       "      <td>1,121,048</td>\n",
       "      <td>In German-occupied Poland during World War II,...</td>\n",
       "      <td>Liam Neeson, Ben Kingsley, Ralph Fiennes, Caro...</td>\n",
       "      <td>1994</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>The Lord of the Rings: The Return of the King</td>\n",
       "      <td>Peter Jackson</td>\n",
       "      <td>201</td>\n",
       "      <td>New Zealand</td>\n",
       "      <td>English</td>\n",
       "      <td>8.9</td>\n",
       "      <td>Adventure</td>\n",
       "      <td>1,534,570</td>\n",
       "      <td>Gandalf and Aragorn lead the World of Men agai...</td>\n",
       "      <td>Noel Appleby, Ali Astin, Sean Astin, David Aston</td>\n",
       "      <td>2003</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Pulp Fiction</td>\n",
       "      <td>Quentin Tarantino</td>\n",
       "      <td>154</td>\n",
       "      <td>USA</td>\n",
       "      <td>English</td>\n",
       "      <td>8.9</td>\n",
       "      <td>Crime</td>\n",
       "      <td>1,696,342</td>\n",
       "      <td>The lives of two mob hitmen, a boxer, a gangst...</td>\n",
       "      <td>Tim Roth, Amanda Plummer, Laura Lovelace, John...</td>\n",
       "      <td>1994</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>The Good, the Bad and the Ugly</td>\n",
       "      <td>Sergio Leone</td>\n",
       "      <td>178</td>\n",
       "      <td>Italy</td>\n",
       "      <td>Italian</td>\n",
       "      <td>8.8</td>\n",
       "      <td>Western</td>\n",
       "      <td>641,326</td>\n",
       "      <td>A bounty hunting scam joins two men in an unea...</td>\n",
       "      <td>Eli Wallach, Clint Eastwood, Lee Van Cleef, Al...</td>\n",
       "      <td>1967</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Fight Club</td>\n",
       "      <td>David Fincher</td>\n",
       "      <td>139</td>\n",
       "      <td>USA</td>\n",
       "      <td>English</td>\n",
       "      <td>8.8</td>\n",
       "      <td>Drama</td>\n",
       "      <td>1,726,585</td>\n",
       "      <td>An insomniac office worker and a devil-may-car...</td>\n",
       "      <td>Edward Norton, Brad Pitt, Meat Loaf, Zach Grenier</td>\n",
       "      <td>1999</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                      Movie Name              Director  \\\n",
       "0                       The Shawshank Redemption        Frank Darabont   \n",
       "1                                  The Godfather  Francis Ford Coppola   \n",
       "2                         The Godfather: Part II  Francis Ford Coppola   \n",
       "3                                The Dark Knight     Christopher Nolan   \n",
       "4                                   12 Angry Men          Sidney Lumet   \n",
       "5                               Schindler's List      Steven Spielberg   \n",
       "6  The Lord of the Rings: The Return of the King         Peter Jackson   \n",
       "7                                   Pulp Fiction     Quentin Tarantino   \n",
       "8                 The Good, the Bad and the Ugly          Sergio Leone   \n",
       "9                                     Fight Club         David Fincher   \n",
       "\n",
       "   Running Time      Country Language  IMDB Rating      Genre Number of votes  \\\n",
       "0           142          USA  English          9.3      Drama       2,161,135   \n",
       "1           175          USA  English          9.2      Crime       1,483,236   \n",
       "2           202          USA  English          9.0      Crime       1,032,840   \n",
       "3           152          USA  English          9.0     Action       2,136,058   \n",
       "4            96          USA  English          8.9      Drama         618,106   \n",
       "5           195          USA  English          8.9  Biography       1,121,048   \n",
       "6           201  New Zealand  English          8.9  Adventure       1,534,570   \n",
       "7           154          USA  English          8.9      Crime       1,696,342   \n",
       "8           178        Italy  Italian          8.8    Western         641,326   \n",
       "9           139          USA  English          8.8      Drama       1,726,585   \n",
       "\n",
       "                                                Plot  \\\n",
       "0  Two imprisoned men bond over a number of years...   \n",
       "1  The aging patriarch of an organized crime dyna...   \n",
       "2  The early life and career of Vito Corleone in ...   \n",
       "3  When the menace known as the Joker wreaks havo...   \n",
       "4  A jury holdout attempts to prevent a miscarria...   \n",
       "5  In German-occupied Poland during World War II,...   \n",
       "6  Gandalf and Aragorn lead the World of Men agai...   \n",
       "7  The lives of two mob hitmen, a boxer, a gangst...   \n",
       "8  A bounty hunting scam joins two men in an unea...   \n",
       "9  An insomniac office worker and a devil-may-car...   \n",
       "\n",
       "                                                Cast  Release Year  \n",
       "0  Tim Robbins, Morgan Freeman, Bob Gunton, Willi...          1994  \n",
       "1  Marlon Brando, Al Pacino, James Caan, Richard ...          1972  \n",
       "2  Al Pacino, Robert Duvall, Diane Keaton, Robert...          1974  \n",
       "3  Christian Bale, Heath Ledger, Aaron Eckhart, M...          2008  \n",
       "4  Martin Balsam, John Fiedler, Lee J. Cobb, E.G....          1957  \n",
       "5  Liam Neeson, Ben Kingsley, Ralph Fiennes, Caro...          1994  \n",
       "6   Noel Appleby, Ali Astin, Sean Astin, David Aston          2003  \n",
       "7  Tim Roth, Amanda Plummer, Laura Lovelace, John...          1994  \n",
       "8  Eli Wallach, Clint Eastwood, Lee Van Cleef, Al...          1967  \n",
       "9  Edward Norton, Brad Pitt, Meat Loaf, Zach Grenier          1999  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Rows     :  250\n",
      "Columns  :  11\n",
      "\n",
      "Features :  ['Movie Name', 'Director', 'Running Time', 'Country', 'Language', 'IMDB Rating', 'Genre', 'Number of votes', 'Plot', 'Cast', 'Release Year']\n",
      "\n",
      "Missing values :   0\n",
      "\n",
      "Unique values :  \n",
      " Movie Name         250\n",
      "Director           152\n",
      "Running Time       103\n",
      "Country             25\n",
      "Language            18\n",
      "IMDB Rating         13\n",
      "Genre               11\n",
      "Number of votes    249\n",
      "Plot               250\n",
      "Cast               247\n",
      "Release Year        80\n",
      "dtype: int64\n"
     ]
    }
   ],
   "source": [
    "print ('Rows     : ', df.shape[0])\n",
    "print ('Columns  : ', df.shape[1])\n",
    "print ('\\nFeatures : ', df.columns.tolist())\n",
    "print ('\\nMissing values :  ', df.isnull().sum().values.sum())\n",
    "print ('\\nUnique values :  \\n', df.nunique())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 250 entries, 0 to 249\n",
      "Data columns (total 11 columns):\n",
      "Movie Name         250 non-null object\n",
      "Director           250 non-null object\n",
      "Running Time       250 non-null int64\n",
      "Country            250 non-null object\n",
      "Language           250 non-null object\n",
      "IMDB Rating        250 non-null float64\n",
      "Genre              250 non-null object\n",
      "Number of votes    250 non-null object\n",
      "Plot               250 non-null object\n",
      "Cast               250 non-null object\n",
      "Release Year       250 non-null int64\n",
      "dtypes: float64(1), int64(2), object(8)\n",
      "memory usage: 21.6+ KB\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "Movie Name         0\n",
       "Director           0\n",
       "Running Time       0\n",
       "Country            0\n",
       "Language           0\n",
       "IMDB Rating        0\n",
       "Genre              0\n",
       "Number of votes    0\n",
       "Plot               0\n",
       "Cast               0\n",
       "Release Year       0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# type of entries, how many null fields\n",
    "df.info()\n",
    "df.isnull().sum()"
   ]
  },
  {
   "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>count</th>\n",
       "      <th>mean</th>\n",
       "      <th>std</th>\n",
       "      <th>min</th>\n",
       "      <th>25%</th>\n",
       "      <th>50%</th>\n",
       "      <th>75%</th>\n",
       "      <th>max</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Running Time</th>\n",
       "      <td>250.0</td>\n",
       "      <td>130.7680</td>\n",
       "      <td>33.164464</td>\n",
       "      <td>45.0</td>\n",
       "      <td>108.25</td>\n",
       "      <td>127.0</td>\n",
       "      <td>147.75</td>\n",
       "      <td>321.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IMDB Rating</th>\n",
       "      <td>250.0</td>\n",
       "      <td>8.3024</td>\n",
       "      <td>0.228656</td>\n",
       "      <td>8.0</td>\n",
       "      <td>8.10</td>\n",
       "      <td>8.2</td>\n",
       "      <td>8.40</td>\n",
       "      <td>9.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Release Year</th>\n",
       "      <td>250.0</td>\n",
       "      <td>1987.1040</td>\n",
       "      <td>24.228439</td>\n",
       "      <td>1921.0</td>\n",
       "      <td>1972.00</td>\n",
       "      <td>1994.0</td>\n",
       "      <td>2006.00</td>\n",
       "      <td>2019.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              count       mean        std     min      25%     50%      75%  \\\n",
       "Running Time  250.0   130.7680  33.164464    45.0   108.25   127.0   147.75   \n",
       "IMDB Rating   250.0     8.3024   0.228656     8.0     8.10     8.2     8.40   \n",
       "Release Year  250.0  1987.1040  24.228439  1921.0  1972.00  1994.0  2006.00   \n",
       "\n",
       "                 max  \n",
       "Running Time   321.0  \n",
       "IMDB Rating      9.3  \n",
       "Release Year  2019.0  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.describe().T #for numeric values"
   ]
  },
  {
   "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>Movie Name</th>\n",
       "      <th>Director</th>\n",
       "      <th>Cast</th>\n",
       "      <th>Plot</th>\n",
       "      <th>Genre</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>The Shawshank Redemption</td>\n",
       "      <td>Frank Darabont</td>\n",
       "      <td>Tim Robbins, Morgan Freeman, Bob Gunton, Willi...</td>\n",
       "      <td>Two imprisoned men bond over a number of years...</td>\n",
       "      <td>Drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>The Godfather</td>\n",
       "      <td>Francis Ford Coppola</td>\n",
       "      <td>Marlon Brando, Al Pacino, James Caan, Richard ...</td>\n",
       "      <td>The aging patriarch of an organized crime dyna...</td>\n",
       "      <td>Crime</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>The Godfather: Part II</td>\n",
       "      <td>Francis Ford Coppola</td>\n",
       "      <td>Al Pacino, Robert Duvall, Diane Keaton, Robert...</td>\n",
       "      <td>The early life and career of Vito Corleone in ...</td>\n",
       "      <td>Crime</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>The Dark Knight</td>\n",
       "      <td>Christopher Nolan</td>\n",
       "      <td>Christian Bale, Heath Ledger, Aaron Eckhart, M...</td>\n",
       "      <td>When the menace known as the Joker wreaks havo...</td>\n",
       "      <td>Action</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>12 Angry Men</td>\n",
       "      <td>Sidney Lumet</td>\n",
       "      <td>Martin Balsam, John Fiedler, Lee J. Cobb, E.G....</td>\n",
       "      <td>A jury holdout attempts to prevent a miscarria...</td>\n",
       "      <td>Drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Schindler's List</td>\n",
       "      <td>Steven Spielberg</td>\n",
       "      <td>Liam Neeson, Ben Kingsley, Ralph Fiennes, Caro...</td>\n",
       "      <td>In German-occupied Poland during World War II,...</td>\n",
       "      <td>Biography</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>The Lord of the Rings: The Return of the King</td>\n",
       "      <td>Peter Jackson</td>\n",
       "      <td>Noel Appleby, Ali Astin, Sean Astin, David Aston</td>\n",
       "      <td>Gandalf and Aragorn lead the World of Men agai...</td>\n",
       "      <td>Adventure</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Pulp Fiction</td>\n",
       "      <td>Quentin Tarantino</td>\n",
       "      <td>Tim Roth, Amanda Plummer, Laura Lovelace, John...</td>\n",
       "      <td>The lives of two mob hitmen, a boxer, a gangst...</td>\n",
       "      <td>Crime</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>The Good, the Bad and the Ugly</td>\n",
       "      <td>Sergio Leone</td>\n",
       "      <td>Eli Wallach, Clint Eastwood, Lee Van Cleef, Al...</td>\n",
       "      <td>A bounty hunting scam joins two men in an unea...</td>\n",
       "      <td>Western</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Fight Club</td>\n",
       "      <td>David Fincher</td>\n",
       "      <td>Edward Norton, Brad Pitt, Meat Loaf, Zach Grenier</td>\n",
       "      <td>An insomniac office worker and a devil-may-car...</td>\n",
       "      <td>Drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>The Lord of the Rings: The Fellowship of the Ring</td>\n",
       "      <td>Peter Jackson</td>\n",
       "      <td>Alan Howard, Noel Appleby, Sean Astin, Sala Baker</td>\n",
       "      <td>A meek Hobbit from the Shire and eight compani...</td>\n",
       "      <td>Adventure</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Forrest Gump</td>\n",
       "      <td>Robert Zemeckis</td>\n",
       "      <td>Tom Hanks, Rebecca Williams, Sally Field, Mich...</td>\n",
       "      <td>The presidencies of Kennedy and Johnson, the e...</td>\n",
       "      <td>Drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Inception</td>\n",
       "      <td>Christopher Nolan</td>\n",
       "      <td>Leonardo DiCaprio, Joseph Gordon-Levitt, Ellen...</td>\n",
       "      <td>A thief who steals corporate secrets through t...</td>\n",
       "      <td>Action</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Star Wars: Episode V - The Empire Strikes Back</td>\n",
       "      <td>Irvin Kershner</td>\n",
       "      <td>Mark Hamill, Harrison Ford, Carrie Fisher, Bil...</td>\n",
       "      <td>After the Rebels are brutally overpowered by t...</td>\n",
       "      <td>Action</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>The Lord of the Rings: The Two Towers</td>\n",
       "      <td>Peter Jackson</td>\n",
       "      <td>Bruce Allpress, Sean Astin, John Bach, Sala Baker</td>\n",
       "      <td>While Frodo and Sam edge closer to Mordor with...</td>\n",
       "      <td>Adventure</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>The Matrix</td>\n",
       "      <td>Lana Wachowski</td>\n",
       "      <td>Keanu Reeves, Laurence Fishburne, Carrie-Anne ...</td>\n",
       "      <td>A computer hacker learns from mysterious rebel...</td>\n",
       "      <td>Action</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Joker</td>\n",
       "      <td>Todd Phillips</td>\n",
       "      <td>Joaquin Phoenix, Robert De Niro, Zazie Beetz</td>\n",
       "      <td>In Gotham City, mentally-troubled comedian Art...</td>\n",
       "      <td>Crime</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>One Flew Over the Cuckoo's Nest</td>\n",
       "      <td>Milos Forman</td>\n",
       "      <td>Michael Berryman, Peter Brocco, Dean R. Brooks...</td>\n",
       "      <td>A criminal pleads insanity and is admitted to ...</td>\n",
       "      <td>Drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Goodfellas</td>\n",
       "      <td>Martin Scorsese</td>\n",
       "      <td>Robert De Niro, Ray Liotta, Joe Pesci, Lorrain...</td>\n",
       "      <td>The story of Henry Hill and his life in the mo...</td>\n",
       "      <td>Biography</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Seven Samurai</td>\n",
       "      <td>Akira Kurosawa</td>\n",
       "      <td>Toshir√¥ Mifune, Takashi Shimura, Keiko Tsushi...</td>\n",
       "      <td>A poor village under attack by bandits recruit...</td>\n",
       "      <td>Action</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Se7en</td>\n",
       "      <td>David Fincher</td>\n",
       "      <td>Morgan Freeman, Andrew Kevin Walker, Kevin Spa...</td>\n",
       "      <td>Two detectives, a rookie and a veteran, hunt a...</td>\n",
       "      <td>Crime</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>City of God</td>\n",
       "      <td>Fernando Meirelles</td>\n",
       "      <td>Alexandre Rodrigues, Leandro Firmino, Phellipe...</td>\n",
       "      <td>In the slums of Rio, two kids' paths diverge a...</td>\n",
       "      <td>Crime</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Life Is Beautiful</td>\n",
       "      <td>Roberto Benigni</td>\n",
       "      <td>Roberto Benigni, Nicoletta Braschi, Giorgio Ca...</td>\n",
       "      <td>When an open-minded Jewish librarian and his s...</td>\n",
       "      <td>Comedy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>The Silence of the Lambs</td>\n",
       "      <td>Jonathan Demme</td>\n",
       "      <td>Jodie Foster, Lawrence A. Bonney, Kasi Lemmons...</td>\n",
       "      <td>A young F.B.I. cadet must receive the help of ...</td>\n",
       "      <td>Crime</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>It's a Wonderful Life</td>\n",
       "      <td>Frank Capra</td>\n",
       "      <td>James Stewart, Donna Reed, Lionel Barrymore, T...</td>\n",
       "      <td>An angel is sent from Heaven to help a despera...</td>\n",
       "      <td>Drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Star Wars: Episode IV - A New Hope</td>\n",
       "      <td>George Lucas</td>\n",
       "      <td>Mark Hamill, Harrison Ford, Carrie Fisher, Pet...</td>\n",
       "      <td>Luke Skywalker joins forces with a Jedi Knight...</td>\n",
       "      <td>Action</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Saving Private Ryan</td>\n",
       "      <td>Steven Spielberg</td>\n",
       "      <td>Tom Hanks, Tom Sizemore, Edward Burns, Barry P...</td>\n",
       "      <td>Following the Normandy Landings, a group of U....</td>\n",
       "      <td>Drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Spirited Away</td>\n",
       "      <td>Hayao Miyazaki</td>\n",
       "      <td>Rumi Hiiragi, Miyu Irino, Mari Natsuki, Takash...</td>\n",
       "      <td>During her family's move to the suburbs, a sul...</td>\n",
       "      <td>Animation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>The Green Mile</td>\n",
       "      <td>Frank Darabont</td>\n",
       "      <td>Tom Hanks, David Morse, Michael Clarke Duncan,...</td>\n",
       "      <td>The lives of guards on Death Row are affected ...</td>\n",
       "      <td>Crime</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>L√©on: The Professional</td>\n",
       "      <td>Luc Besson</td>\n",
       "      <td>Jean Reno, Gary Oldman, Natalie Portman, Danny...</td>\n",
       "      <td>Mathilda, a 12-year-old girl, is reluctantly t...</td>\n",
       "      <td>Action</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>221</th>\n",
       "      <td>Harry Potter and the Deathly Hallows: Part 2</td>\n",
       "      <td>David Yates</td>\n",
       "      <td>Ralph Fiennes, Michael Gambon, Alan Rickman, D...</td>\n",
       "      <td>Harry (Daniel Radcliffe), Ron (Rupert Grint), ...</td>\n",
       "      <td>Adventure</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222</th>\n",
       "      <td>Spotlight</td>\n",
       "      <td>Tom McCarthy</td>\n",
       "      <td>Mark Ruffalo, Michael Keaton, Rachel McAdams</td>\n",
       "      <td>The true story of how the Boston Globe uncover...</td>\n",
       "      <td>Biography</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223</th>\n",
       "      <td>Dead Poets Society</td>\n",
       "      <td>Peter Weir</td>\n",
       "      <td>Robin Williams, Robert Sean Leonard, Ethan Hawke</td>\n",
       "      <td>English teacher John Keating inspires his stud...</td>\n",
       "      <td>Comedy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224</th>\n",
       "      <td>Ace in the Hole</td>\n",
       "      <td>Billy Wilder</td>\n",
       "      <td>Kirk Douglas, Jan Sterling, Robert Arthur</td>\n",
       "      <td>A frustrated former big-city journalist now st...</td>\n",
       "      <td>Drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225</th>\n",
       "      <td>White Heat</td>\n",
       "      <td>Raoul Walsh</td>\n",
       "      <td>James Cagney, Virginia Mayo, Edmond O'Brien</td>\n",
       "      <td>A psychopathic criminal with a mother complex ...</td>\n",
       "      <td>Action</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>226</th>\n",
       "      <td>Rebecca</td>\n",
       "      <td>Alfred Hitchcock</td>\n",
       "      <td>Laurence Olivier, Joan Fontaine, George Sanders</td>\n",
       "      <td>A self-conscious woman juggles adjusting to he...</td>\n",
       "      <td>Drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>227</th>\n",
       "      <td>Rocky</td>\n",
       "      <td>John G. Avildsen</td>\n",
       "      <td>Sylvester Stallone, Talia Shire, Burt Young, C...</td>\n",
       "      <td>A small-time boxer gets a supremely rare chanc...</td>\n",
       "      <td>Drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>228</th>\n",
       "      <td>Monsters, Inc.</td>\n",
       "      <td>Pete Docter</td>\n",
       "      <td>John Goodman, Billy Crystal, Mary Gibbs, Steve...</td>\n",
       "      <td>In order to power the city, monsters have to s...</td>\n",
       "      <td>Animation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229</th>\n",
       "      <td>It Happened One Night</td>\n",
       "      <td>Frank Capra</td>\n",
       "      <td>Clark Gable, Claudette Colbert, Walter Connoll...</td>\n",
       "      <td>A spoiled heiress running away from her family...</td>\n",
       "      <td>Comedy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>230</th>\n",
       "      <td>The Handmaiden</td>\n",
       "      <td>Chan-wook Park</td>\n",
       "      <td>Min-hee Kim, Jung-woo Ha, Jin-woong Cho</td>\n",
       "      <td>A woman is hired as a handmaiden to a Japanese...</td>\n",
       "      <td>Drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231</th>\n",
       "      <td>La Haine</td>\n",
       "      <td>Mathieu Kassovitz</td>\n",
       "      <td>Vincent Cassel, Hubert Kound√©, Sa√Ød Taghmaou...</td>\n",
       "      <td>24 hours in the lives of three young men in th...</td>\n",
       "      <td>Crime</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>232</th>\n",
       "      <td>Gangs of Wasseypur</td>\n",
       "      <td>Anurag Kashyap</td>\n",
       "      <td>Manoj Bajpayee, Richa Chadha, Nawazuddin Siddi...</td>\n",
       "      <td>A clash between Sultan and Shahid Khan leads t...</td>\n",
       "      <td>Action</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>233</th>\n",
       "      <td>Lagaan: Once Upon a Time in India</td>\n",
       "      <td>Ashutosh Gowariker</td>\n",
       "      <td>Cary Elwes, Mandy Patinkin, Robin Wright</td>\n",
       "      <td>The people of a small village in Victorian Ind...</td>\n",
       "      <td>Adventure</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>234</th>\n",
       "      <td>The Princess Bride</td>\n",
       "      <td>Rob Reiner</td>\n",
       "      <td>Cary Elwes, Mandy Patinkin, Chris Sarandon, Ch...</td>\n",
       "      <td>While home sick in bed, a young boy's grandfat...</td>\n",
       "      <td>Adventure</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>235</th>\n",
       "      <td>PK</td>\n",
       "      <td>Rajkumar Hirani</td>\n",
       "      <td>Aamir Khan, Anushka Sharma, Sanjay Dutt, Boman...</td>\n",
       "      <td>An alien on Earth loses the only device he can...</td>\n",
       "      <td>Comedy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>236</th>\n",
       "      <td>Butch Cassidy and the Sundance Kid</td>\n",
       "      <td>George Roy Hill</td>\n",
       "      <td>Paul Newman, Robert Redford, Katharine Ross, S...</td>\n",
       "      <td>Wyoming, early 1900s. Butch Cassidy and The Su...</td>\n",
       "      <td>Biography</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>237</th>\n",
       "      <td>Before Sunset</td>\n",
       "      <td>Richard Linklater</td>\n",
       "      <td>Ethan Hawke, Julie Delpy, Vernon Dobtcheff</td>\n",
       "      <td>Nine years after Jesse and Celine first met, t...</td>\n",
       "      <td>Drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238</th>\n",
       "      <td>The Help</td>\n",
       "      <td>Tate Taylor</td>\n",
       "      <td>Emma Stone, Viola Davis, Bryce Dallas Howard, ...</td>\n",
       "      <td>An aspiring author during the civil rights mov...</td>\n",
       "      <td>Drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239</th>\n",
       "      <td>Munna Bhai M.B.B.S.</td>\n",
       "      <td>Rajkumar Hirani</td>\n",
       "      <td>Sunil Dutt, Sanjay Dutt, Arshad Warsi, Gracy S...</td>\n",
       "      <td>A gangster sets out to fulfill his father's dr...</td>\n",
       "      <td>Comedy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>240</th>\n",
       "      <td>The Terminator</td>\n",
       "      <td>James Cameron</td>\n",
       "      <td>Arnold Schwarzenegger, Michael Biehn, Linda Ha...</td>\n",
       "      <td>In 1984, a human soldier is tasked to stop an ...</td>\n",
       "      <td>Action</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241</th>\n",
       "      <td>Akira</td>\n",
       "      <td>Katsuhiro √îtomo</td>\n",
       "      <td>Mitsuo Iwata, Nozomu Sasaki, Mami Koyama</td>\n",
       "      <td>A secret military project endangers Neo-Tokyo ...</td>\n",
       "      <td>Animation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>242</th>\n",
       "      <td>In the Mood for Love</td>\n",
       "      <td>Kar-Wai Wong</td>\n",
       "      <td>Maggie Cheung, Tony Chiu-Wai Leung, Ping Lam S...</td>\n",
       "      <td>Two neighbors, a woman and a man, form a stron...</td>\n",
       "      <td>Drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243</th>\n",
       "      <td>Paris, Texas</td>\n",
       "      <td>Wim Wenders</td>\n",
       "      <td>Harry Dean Stanton, Sam Berry, Bernhard Wicki,...</td>\n",
       "      <td>Travis Henderson, an aimless drifter who has b...</td>\n",
       "      <td>Drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>244</th>\n",
       "      <td>Aladdin</td>\n",
       "      <td>Ron Clements</td>\n",
       "      <td>Scott Weinger, Robin Williams, Linda Larkin</td>\n",
       "      <td>A kindhearted street urchin and a power-hungry...</td>\n",
       "      <td>Animation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>245</th>\n",
       "      <td>Swades</td>\n",
       "      <td>Ashutosh Gowariker</td>\n",
       "      <td>Shah Rukh Khan, Gayatri Joshi, Kishori Ballal</td>\n",
       "      <td>A successful Indian scientist returns to an In...</td>\n",
       "      <td>Drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>246</th>\n",
       "      <td>Guardians of the Galaxy</td>\n",
       "      <td>James Gunn</td>\n",
       "      <td>Chris Pratt, Vin Diesel, Bradley Cooper</td>\n",
       "      <td>A group of intergalactic criminals must pull t...</td>\n",
       "      <td>Action</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>247</th>\n",
       "      <td>Infernal Affairs</td>\n",
       "      <td>Andrew Lau</td>\n",
       "      <td>Andy Lau, Tony Chiu-Wai Leung, Anthony Chau-Sa...</td>\n",
       "      <td>A story between a mole in the police departmen...</td>\n",
       "      <td>Crime</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>248</th>\n",
       "      <td>The Battle of Algiers</td>\n",
       "      <td>Gillo Pontecorvo</td>\n",
       "      <td>Jean Martin, Yacef Saadi, Brahim Hadjadj, Sami...</td>\n",
       "      <td>In the 1950s, fear and violence escalate as th...</td>\n",
       "      <td>Drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>249</th>\n",
       "      <td>La leggenda del pianista sull'oceano</td>\n",
       "      <td>Giuseppe Tornatore</td>\n",
       "      <td>Tim Roth, Pruitt Taylor Vince, Mélanie Thierry</td>\n",
       "      <td>A baby boy, discovered in 1900 on an ocean lin...</td>\n",
       "      <td>Drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>250</th>\n",
       "      <td>Castle in the Sky</td>\n",
       "      <td>Hayao Miyazaki</td>\n",
       "      <td>Anna Paquin, James Van Der Beek, Cloris Leachman</td>\n",
       "      <td>A young boy and a girl with a magic crystal mu...</td>\n",
       "      <td>Animation</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>250 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                            Movie Name              Director  \\\n",
       "1                             The Shawshank Redemption        Frank Darabont   \n",
       "2                                        The Godfather  Francis Ford Coppola   \n",
       "3                               The Godfather: Part II  Francis Ford Coppola   \n",
       "4                                      The Dark Knight     Christopher Nolan   \n",
       "5                                         12 Angry Men          Sidney Lumet   \n",
       "6                                     Schindler's List      Steven Spielberg   \n",
       "7        The Lord of the Rings: The Return of the King         Peter Jackson   \n",
       "8                                         Pulp Fiction     Quentin Tarantino   \n",
       "9                       The Good, the Bad and the Ugly          Sergio Leone   \n",
       "10                                          Fight Club         David Fincher   \n",
       "11   The Lord of the Rings: The Fellowship of the Ring         Peter Jackson   \n",
       "12                                        Forrest Gump       Robert Zemeckis   \n",
       "13                                           Inception     Christopher Nolan   \n",
       "14      Star Wars: Episode V - The Empire Strikes Back        Irvin Kershner   \n",
       "15               The Lord of the Rings: The Two Towers         Peter Jackson   \n",
       "16                                          The Matrix        Lana Wachowski   \n",
       "17                                               Joker         Todd Phillips   \n",
       "18                     One Flew Over the Cuckoo's Nest          Milos Forman   \n",
       "19                                          Goodfellas       Martin Scorsese   \n",
       "20                                       Seven Samurai        Akira Kurosawa   \n",
       "21                                               Se7en         David Fincher   \n",
       "22                                         City of God    Fernando Meirelles   \n",
       "23                                   Life Is Beautiful       Roberto Benigni   \n",
       "24                            The Silence of the Lambs        Jonathan Demme   \n",
       "25                               It's a Wonderful Life           Frank Capra   \n",
       "26                  Star Wars: Episode IV - A New Hope          George Lucas   \n",
       "27                                 Saving Private Ryan      Steven Spielberg   \n",
       "28                                       Spirited Away        Hayao Miyazaki   \n",
       "29                                      The Green Mile        Frank Darabont   \n",
       "30                             L√©on: The Professional            Luc Besson   \n",
       "..                                                 ...                   ...   \n",
       "221       Harry Potter and the Deathly Hallows: Part 2           David Yates   \n",
       "222                                          Spotlight          Tom McCarthy   \n",
       "223                                 Dead Poets Society            Peter Weir   \n",
       "224                                    Ace in the Hole          Billy Wilder   \n",
       "225                                         White Heat           Raoul Walsh   \n",
       "226                                            Rebecca      Alfred Hitchcock   \n",
       "227                                              Rocky      John G. Avildsen   \n",
       "228                                     Monsters, Inc.           Pete Docter   \n",
       "229                              It Happened One Night           Frank Capra   \n",
       "230                                     The Handmaiden        Chan-wook Park   \n",
       "231                                           La Haine     Mathieu Kassovitz   \n",
       "232                                 Gangs of Wasseypur        Anurag Kashyap   \n",
       "233                  Lagaan: Once Upon a Time in India    Ashutosh Gowariker   \n",
       "234                                 The Princess Bride            Rob Reiner   \n",
       "235                                                 PK       Rajkumar Hirani   \n",
       "236                 Butch Cassidy and the Sundance Kid       George Roy Hill   \n",
       "237                                      Before Sunset     Richard Linklater   \n",
       "238                                           The Help           Tate Taylor   \n",
       "239                                Munna Bhai M.B.B.S.       Rajkumar Hirani   \n",
       "240                                     The Terminator         James Cameron   \n",
       "241                                              Akira      Katsuhiro √îtomo   \n",
       "242                               In the Mood for Love          Kar-Wai Wong   \n",
       "243                                       Paris, Texas           Wim Wenders   \n",
       "244                                            Aladdin          Ron Clements   \n",
       "245                                             Swades    Ashutosh Gowariker   \n",
       "246                            Guardians of the Galaxy            James Gunn   \n",
       "247                                   Infernal Affairs            Andrew Lau   \n",
       "248                              The Battle of Algiers      Gillo Pontecorvo   \n",
       "249               La leggenda del pianista sull'oceano    Giuseppe Tornatore   \n",
       "250                                  Castle in the Sky        Hayao Miyazaki   \n",
       "\n",
       "                                                  Cast  \\\n",
       "1    Tim Robbins, Morgan Freeman, Bob Gunton, Willi...   \n",
       "2    Marlon Brando, Al Pacino, James Caan, Richard ...   \n",
       "3    Al Pacino, Robert Duvall, Diane Keaton, Robert...   \n",
       "4    Christian Bale, Heath Ledger, Aaron Eckhart, M...   \n",
       "5    Martin Balsam, John Fiedler, Lee J. Cobb, E.G....   \n",
       "6    Liam Neeson, Ben Kingsley, Ralph Fiennes, Caro...   \n",
       "7     Noel Appleby, Ali Astin, Sean Astin, David Aston   \n",
       "8    Tim Roth, Amanda Plummer, Laura Lovelace, John...   \n",
       "9    Eli Wallach, Clint Eastwood, Lee Van Cleef, Al...   \n",
       "10   Edward Norton, Brad Pitt, Meat Loaf, Zach Grenier   \n",
       "11   Alan Howard, Noel Appleby, Sean Astin, Sala Baker   \n",
       "12   Tom Hanks, Rebecca Williams, Sally Field, Mich...   \n",
       "13   Leonardo DiCaprio, Joseph Gordon-Levitt, Ellen...   \n",
       "14   Mark Hamill, Harrison Ford, Carrie Fisher, Bil...   \n",
       "15   Bruce Allpress, Sean Astin, John Bach, Sala Baker   \n",
       "16   Keanu Reeves, Laurence Fishburne, Carrie-Anne ...   \n",
       "17       Joaquin Phoenix, Robert De Niro, Zazie Beetz    \n",
       "18   Michael Berryman, Peter Brocco, Dean R. Brooks...   \n",
       "19   Robert De Niro, Ray Liotta, Joe Pesci, Lorrain...   \n",
       "20   Toshir√¥ Mifune, Takashi Shimura, Keiko Tsushi...   \n",
       "21   Morgan Freeman, Andrew Kevin Walker, Kevin Spa...   \n",
       "22   Alexandre Rodrigues, Leandro Firmino, Phellipe...   \n",
       "23   Roberto Benigni, Nicoletta Braschi, Giorgio Ca...   \n",
       "24   Jodie Foster, Lawrence A. Bonney, Kasi Lemmons...   \n",
       "25   James Stewart, Donna Reed, Lionel Barrymore, T...   \n",
       "26   Mark Hamill, Harrison Ford, Carrie Fisher, Pet...   \n",
       "27   Tom Hanks, Tom Sizemore, Edward Burns, Barry P...   \n",
       "28   Rumi Hiiragi, Miyu Irino, Mari Natsuki, Takash...   \n",
       "29   Tom Hanks, David Morse, Michael Clarke Duncan,...   \n",
       "30   Jean Reno, Gary Oldman, Natalie Portman, Danny...   \n",
       "..                                                 ...   \n",
       "221  Ralph Fiennes, Michael Gambon, Alan Rickman, D...   \n",
       "222       Mark Ruffalo, Michael Keaton, Rachel McAdams   \n",
       "223   Robin Williams, Robert Sean Leonard, Ethan Hawke   \n",
       "224         Kirk Douglas, Jan Sterling, Robert Arthur    \n",
       "225        James Cagney, Virginia Mayo, Edmond O'Brien   \n",
       "226    Laurence Olivier, Joan Fontaine, George Sanders   \n",
       "227  Sylvester Stallone, Talia Shire, Burt Young, C...   \n",
       "228  John Goodman, Billy Crystal, Mary Gibbs, Steve...   \n",
       "229  Clark Gable, Claudette Colbert, Walter Connoll...   \n",
       "230            Min-hee Kim, Jung-woo Ha, Jin-woong Cho   \n",
       "231  Vincent Cassel, Hubert Kound√©, Sa√Ød Taghmaou...   \n",
       "232  Manoj Bajpayee, Richa Chadha, Nawazuddin Siddi...   \n",
       "233           Cary Elwes, Mandy Patinkin, Robin Wright   \n",
       "234  Cary Elwes, Mandy Patinkin, Chris Sarandon, Ch...   \n",
       "235  Aamir Khan, Anushka Sharma, Sanjay Dutt, Boman...   \n",
       "236  Paul Newman, Robert Redford, Katharine Ross, S...   \n",
       "237         Ethan Hawke, Julie Delpy, Vernon Dobtcheff   \n",
       "238  Emma Stone, Viola Davis, Bryce Dallas Howard, ...   \n",
       "239  Sunil Dutt, Sanjay Dutt, Arshad Warsi, Gracy S...   \n",
       "240  Arnold Schwarzenegger, Michael Biehn, Linda Ha...   \n",
       "241           Mitsuo Iwata, Nozomu Sasaki, Mami Koyama   \n",
       "242  Maggie Cheung, Tony Chiu-Wai Leung, Ping Lam S...   \n",
       "243  Harry Dean Stanton, Sam Berry, Bernhard Wicki,...   \n",
       "244        Scott Weinger, Robin Williams, Linda Larkin   \n",
       "245      Shah Rukh Khan, Gayatri Joshi, Kishori Ballal   \n",
       "246            Chris Pratt, Vin Diesel, Bradley Cooper   \n",
       "247  Andy Lau, Tony Chiu-Wai Leung, Anthony Chau-Sa...   \n",
       "248  Jean Martin, Yacef Saadi, Brahim Hadjadj, Sami...   \n",
       "249     Tim Roth, Pruitt Taylor Vince, Mélanie Thierry   \n",
       "250   Anna Paquin, James Van Der Beek, Cloris Leachman   \n",
       "\n",
       "                                                  Plot      Genre  \n",
       "1    Two imprisoned men bond over a number of years...      Drama  \n",
       "2    The aging patriarch of an organized crime dyna...      Crime  \n",
       "3    The early life and career of Vito Corleone in ...      Crime  \n",
       "4    When the menace known as the Joker wreaks havo...     Action  \n",
       "5    A jury holdout attempts to prevent a miscarria...      Drama  \n",
       "6    In German-occupied Poland during World War II,...  Biography  \n",
       "7    Gandalf and Aragorn lead the World of Men agai...  Adventure  \n",
       "8    The lives of two mob hitmen, a boxer, a gangst...      Crime  \n",
       "9    A bounty hunting scam joins two men in an unea...    Western  \n",
       "10   An insomniac office worker and a devil-may-car...      Drama  \n",
       "11   A meek Hobbit from the Shire and eight compani...  Adventure  \n",
       "12   The presidencies of Kennedy and Johnson, the e...      Drama  \n",
       "13   A thief who steals corporate secrets through t...     Action  \n",
       "14   After the Rebels are brutally overpowered by t...     Action  \n",
       "15   While Frodo and Sam edge closer to Mordor with...  Adventure  \n",
       "16   A computer hacker learns from mysterious rebel...     Action  \n",
       "17   In Gotham City, mentally-troubled comedian Art...      Crime  \n",
       "18   A criminal pleads insanity and is admitted to ...      Drama  \n",
       "19   The story of Henry Hill and his life in the mo...  Biography  \n",
       "20   A poor village under attack by bandits recruit...     Action  \n",
       "21   Two detectives, a rookie and a veteran, hunt a...      Crime  \n",
       "22   In the slums of Rio, two kids' paths diverge a...      Crime  \n",
       "23   When an open-minded Jewish librarian and his s...     Comedy  \n",
       "24   A young F.B.I. cadet must receive the help of ...      Crime  \n",
       "25   An angel is sent from Heaven to help a despera...      Drama  \n",
       "26   Luke Skywalker joins forces with a Jedi Knight...     Action  \n",
       "27   Following the Normandy Landings, a group of U....      Drama  \n",
       "28   During her family's move to the suburbs, a sul...  Animation  \n",
       "29   The lives of guards on Death Row are affected ...      Crime  \n",
       "30   Mathilda, a 12-year-old girl, is reluctantly t...     Action  \n",
       "..                                                 ...        ...  \n",
       "221  Harry (Daniel Radcliffe), Ron (Rupert Grint), ...  Adventure  \n",
       "222  The true story of how the Boston Globe uncover...  Biography  \n",
       "223  English teacher John Keating inspires his stud...     Comedy  \n",
       "224  A frustrated former big-city journalist now st...      Drama  \n",
       "225  A psychopathic criminal with a mother complex ...     Action  \n",
       "226  A self-conscious woman juggles adjusting to he...      Drama  \n",
       "227  A small-time boxer gets a supremely rare chanc...      Drama  \n",
       "228  In order to power the city, monsters have to s...  Animation  \n",
       "229  A spoiled heiress running away from her family...     Comedy  \n",
       "230  A woman is hired as a handmaiden to a Japanese...      Drama  \n",
       "231  24 hours in the lives of three young men in th...      Crime  \n",
       "232  A clash between Sultan and Shahid Khan leads t...     Action  \n",
       "233  The people of a small village in Victorian Ind...  Adventure  \n",
       "234  While home sick in bed, a young boy's grandfat...  Adventure  \n",
       "235  An alien on Earth loses the only device he can...     Comedy  \n",
       "236  Wyoming, early 1900s. Butch Cassidy and The Su...  Biography  \n",
       "237  Nine years after Jesse and Celine first met, t...      Drama  \n",
       "238  An aspiring author during the civil rights mov...      Drama  \n",
       "239  A gangster sets out to fulfill his father's dr...     Comedy  \n",
       "240  In 1984, a human soldier is tasked to stop an ...     Action  \n",
       "241  A secret military project endangers Neo-Tokyo ...  Animation  \n",
       "242  Two neighbors, a woman and a man, form a stron...      Drama  \n",
       "243  Travis Henderson, an aimless drifter who has b...      Drama  \n",
       "244  A kindhearted street urchin and a power-hungry...  Animation  \n",
       "245  A successful Indian scientist returns to an In...      Drama  \n",
       "246  A group of intergalactic criminals must pull t...     Action  \n",
       "247  A story between a mole in the police departmen...      Crime  \n",
       "248  In the 1950s, fear and violence escalate as th...      Drama  \n",
       "249  A baby boy, discovered in 1900 on an ocean lin...      Drama  \n",
       "250  A young boy and a girl with a magic crystal mu...  Animation  \n",
       "\n",
       "[250 rows x 5 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = df[['Movie Name','Director','Cast','Plot','Genre']]\n",
    "df.index = list(range(1,251))\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv('IMDBfeatures.csv', index=False)"
   ]
  },
  {
   "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.6.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}