imdb_data.ipynb

{
 "metadata": {
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "2.7.16"
  },
  "orig_nbformat": 2,
  "kernelspec": {
   "name": "python2716jvsc74a57bd0767d51c1340bd893661ea55ea3124f6de3c7a262a8b4abca0554b478b1e2ff90",
   "display_name": "Python 2.7.16 64-bit"
  },
  "metadata": {
   "interpreter": {
    "hash": "767d51c1340bd893661ea55ea3124f6de3c7a262a8b4abca0554b478b1e2ff90"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2,
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import string"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "output_type": "stream",
     "name": "stderr",
     "text": [
      "/Users/claireyin/Library/Python/2.7/lib/python/site-packages/IPython/core/interactiveshell.py:2714: DtypeWarning: Columns (3) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "Index([u'imdb_title_id', u'title', u'original_title', u'year',\n",
      "       u'date_published', u'genre', u'duration', u'country', u'language',\n",
      "       u'director', u'writer', u'production_company', u'actors',\n",
      "       u'description', u'avg_vote', u'votes', u'budget', u'usa_gross_income',\n",
      "       u'worlwide_gross_income', u'metascore', u'reviews_from_users',\n",
      "       u'reviews_from_critics'],\n",
      "      dtype='object')\n"
     ]
    }
   ],
   "source": [
    "imdb_movies_path = 'imdb_data/IMDb movies.csv'\n",
    "imdb_ratings_path = 'imdb_data/IMDb ratings.csv'\n",
    "movie_path = 'data_cleaned_merged/movie_title_metadata.csv'\n",
    "\n",
    "imdb_df = pd.read_csv(imdb_movies_path)\n",
    "ratings_df = pd.read_csv(imdb_ratings_path)\n",
    "movies_df = pd.read_csv(movie_path)\n",
    "\n",
    "print(imdb_df.columns)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "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>Unnamed: 0</th>\n      <th>movie_id</th>\n      <th>title</th>\n      <th>year</th>\n      <th>rating</th>\n      <th>votes</th>\n      <th>genres</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>0</td>\n      <td>m0</td>\n      <td>10 Things I Hate About You</td>\n      <td>1999</td>\n      <td>6.9</td>\n      <td>62847.0</td>\n      <td>['comedy' 'romance']</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>1</td>\n      <td>m1</td>\n      <td>1492 Conquest Of Paradise</td>\n      <td>1992</td>\n      <td>6.2</td>\n      <td>10421.0</td>\n      <td>['adventure' 'biography' 'drama' 'history']</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>2</td>\n      <td>m2</td>\n      <td>15 Minutes</td>\n      <td>2001</td>\n      <td>6.1</td>\n      <td>25854.0</td>\n      <td>['action' 'crime' 'drama' 'thriller']</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>3</td>\n      <td>m3</td>\n      <td>2001 A Space Odyssey</td>\n      <td>1968</td>\n      <td>8.4</td>\n      <td>163227.0</td>\n      <td>['adventure' 'mystery' 'sci-fi']</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>4</td>\n      <td>m4</td>\n      <td>48 Hrs</td>\n      <td>1982</td>\n      <td>6.9</td>\n      <td>22289.0</td>\n      <td>['action' 'comedy' 'crime' 'drama' 'thriller']</td>\n    </tr>\n  </tbody>\n</table>\n</div>",
      "text/plain": [
       "   Unnamed: 0 movie_id                       title  year  rating     votes  \\\n",
       "0           0       m0  10 Things I Hate About You  1999     6.9   62847.0   \n",
       "1           1       m1   1492 Conquest Of Paradise  1992     6.2   10421.0   \n",
       "2           2       m2                  15 Minutes  2001     6.1   25854.0   \n",
       "3           3       m3        2001 A Space Odyssey  1968     8.4  163227.0   \n",
       "4           4       m4                      48 Hrs  1982     6.9   22289.0   \n",
       "\n",
       "                                           genres  \n",
       "0                            ['comedy' 'romance']  \n",
       "1     ['adventure' 'biography' 'drama' 'history']  \n",
       "2           ['action' 'crime' 'drama' 'thriller']  \n",
       "3                ['adventure' 'mystery' 'sci-fi']  \n",
       "4  ['action' 'comedy' 'crime' 'drama' 'thriller']  "
      ]
     },
     "metadata": {},
     "execution_count": 3
    }
   ],
   "source": [
    "merged_imdb = ratings_df.merge(imdb_df, on='imdb_title_id')\n",
    "merged_imdb['year'] = merged_imdb['year'].apply(lambda x: str(x)[0:4])\n",
    "merged_imdb['original_title'] = merged_imdb['original_title'].apply(lambda x: x.translate(None, string.punctuation).lower().title())\n",
    "merged_imdb = merged_imdb.rename(columns={'title':'title_spanish'})\n",
    "merged_imdb = merged_imdb.rename(columns={'original_title':'title'})\n",
    "\n",
    "movies_df['title'] = movies_df['title'].apply(lambda x: x.translate(None, string.punctuation).lower().title())\n",
    "movies_df['year'] = movies_df['year'].apply(lambda x: str(x)[0:4])\n",
    "\n",
    "movies_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "all_data = movies_df.merge(merged_imdb, on=['title','year'])\n",
    "                            "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "movies = pd.read_csv(movie_path)[['movie_id','title']]\n",
    "all_imdb_final = all_data.drop(columns='title')\n",
    "final_df = movies.merge(all_imdb_final, on=['movie_id'])\n",
    "# final_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "['Ghostbusters',\n",
       " 'Invaders From Mars',\n",
       " 'L\\xef\\xbf\\xbdOn',\n",
       " 'Labor Of Love',\n",
       " 'Mighty Morphin Power Rangers',\n",
       " 'My Mother Dreams The Satans Disciples In New York',\n",
       " 'Pirates Of The Caribbean',\n",
       " 'Plastic Man',\n",
       " 'Rko 281',\n",
       " 'Simone',\n",
       " 'Star Trek The Wrath Of Khan',\n",
       " 'New Nightmare',\n",
       " 'Alien Vs Predator',\n",
       " 'Beetle Juice',\n",
       " 'Body Of Evidence',\n",
       " 'Crazy Love',\n",
       " 'Crouching Tiger Hidden Dragon',\n",
       " 'The Devil And Daniel Webster',\n",
       " 'Star Wars The Empire Strikes Back',\n",
       " 'Five Feet High And Rising',\n",
       " 'Jason Lives Friday The 13Th Part Vi',\n",
       " 'Hellraiser Hellseeker',\n",
       " 'Last Of The Mohicans',\n",
       " 'Manhunt',\n",
       " 'Arcade',\n",
       " 'Nan',\n",
       " 'Neuromancer',\n",
       " 'The Producers',\n",
       " 'Quantum Project',\n",
       " 'Red White Black  Blue',\n",
       " 'Route 9',\n",
       " 'Spare Me',\n",
       " 'Stranglehold',\n",
       " 'Uturn',\n",
       " 'The Witching Hour',\n",
       " 'Whos Your Daddy']"
      ]
     },
     "metadata": {},
     "execution_count": 7
    }
   ],
   "source": [
    "unmerged = all_data[all_data['imdb_title_id'].isna()][['movie_id', 'title', 'year']]\n",
    "unmerged['title'].tolist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 114,
   "metadata": {},
   "outputs": [],
   "source": [
    "# merged_imdb.to_csv('data_cleaned_merged/imdb.csv')\n",
    "# final_df.to_csv('data_cleaned_merged/imdb_with_metadata.csv')\n",
    "\n",
    "# unmerged.to_csv('data_cleaned_merged/unmerged.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "['10 Things I Hate About You',\n",
       " '1492: Conquest Of Paradise',\n",
       " '15 Minutes',\n",
       " '2001: A Space Odyssey',\n",
       " '48 Hrs.',\n",
       " 'The Fifth Element',\n",
       " '8Mm',\n",
       " 'A Nightmare On Elm Street 4: The Dream Master',\n",
       " 'A Nightmare On Elm Street: The Dream Child',\n",
       " 'The Atomic Submarine',\n",
       " 'Affliction',\n",
       " 'Air Force One',\n",
       " 'Airplane Ii: The Sequel',\n",
       " 'Airplane!',\n",
       " 'Alien Nation',\n",
       " 'Aliens',\n",
       " 'Amadeus',\n",
       " 'An American Werewolf In London',\n",
       " 'American Madness',\n",
       " 'American Outlaws',\n",
       " 'American Psycho',\n",
       " 'Antitrust',\n",
       " 'Austin Powers: International Man Of Mystery',\n",
       " 'The Avengers',\n",
       " 'Bachelor Party',\n",
       " 'Backdraft',\n",
       " 'Bad Lieutenant',\n",
       " 'Bamboozled',\n",
       " 'Barry Lyndon',\n",
       " 'Basic',\n",
       " 'Big Fish',\n",
       " 'Birthday Girl',\n",
       " 'Black Snake Moan',\n",
       " 'Black Rain',\n",
       " 'Blade Runner',\n",
       " 'Blast From The Past',\n",
       " 'Blue Velvet',\n",
       " 'The Boondock Saints',\n",
       " 'Bottle Rocket',\n",
       " 'The Bourne Supremacy',\n",
       " 'Braveheart',\n",
       " 'The Butterfly Effect',\n",
       " 'Casablanca',\n",
       " 'Cast Away',\n",
       " 'The Cider House Rules',\n",
       " 'Confidence',\n",
       " 'Croupier',\n",
       " 'Dark Star',\n",
       " 'Dark Angel',\n",
       " 'Detroit Rock City',\n",
       " 'Donnie Darko',\n",
       " 'Drop Dead Gorgeous',\n",
       " 'Duck Soup',\n",
       " 'The Elephant Man',\n",
       " 'Erik The Viking',\n",
       " 'Eternal Sunshine Of The Spotless Mind',\n",
       " 'Even Cowgirls Get The Blues',\n",
       " 'Event Horizon',\n",
       " 'Fantastic Four',\n",
       " 'Fast Times At Ridgemont High',\n",
       " 'Fear And Loathing In Las Vegas',\n",
       " 'Feast',\n",
       " 'Frances',\n",
       " 'Frankenstein',\n",
       " 'Friday The 13Th',\n",
       " 'From Dusk Till Dawn',\n",
       " 'G.I. Jane',\n",
       " 'Godzilla',\n",
       " 'Galaxy Quest',\n",
       " 'George Washington',\n",
       " 'Get Shorty',\n",
       " 'Ghost Ship',\n",
       " 'Ghost World',\n",
       " 'The Ghost And The Darkness',\n",
       " 'Ghostbusters Ii',\n",
       " 'Gladiator',\n",
       " 'The Graduate',\n",
       " 'Grand Hotel',\n",
       " 'The Grifters',\n",
       " 'Halloween H20: 20 Years Later',\n",
       " 'Halloween: The Curse Of Michael Myers',\n",
       " 'Happy Birthday Wanda June',\n",
       " 'Hardcore',\n",
       " 'Harold And Maude',\n",
       " 'Hellbound: Hellraiser Ii',\n",
       " 'Hellboy',\n",
       " 'Hellraiser',\n",
       " 'High Fidelity',\n",
       " 'Highlander',\n",
       " 'His Girl Friday',\n",
       " 'Hope And Glory',\n",
       " 'House Of 1000 Corpses',\n",
       " 'Human Nature',\n",
       " 'The Hustler',\n",
       " 'I Am Legend',\n",
       " 'Independence Day',\n",
       " 'Indiana Jones And The Last Crusade',\n",
       " 'Indiana Jones And The Temple Of Doom',\n",
       " 'Innerspace',\n",
       " 'The Insider',\n",
       " 'Intolerable Cruelty',\n",
       " 'It Happened One Night',\n",
       " 'Jfk',\n",
       " 'Jackie Brown',\n",
       " \"Jacob'S Ladder\",\n",
       " 'Jason X',\n",
       " 'Jaws',\n",
       " 'Juno',\n",
       " 'Kalifornia',\n",
       " 'Kids',\n",
       " 'Knight Moves',\n",
       " 'Krull',\n",
       " 'Leaving Las Vegas',\n",
       " 'Legally Blonde',\n",
       " 'Legend',\n",
       " 'Life As A House',\n",
       " 'The Life Of David Gale',\n",
       " 'Little Nicky',\n",
       " \"Logan'S Run\",\n",
       " 'Lost Highway',\n",
       " 'Lost Horizon',\n",
       " 'Men In Black',\n",
       " 'Minority Report',\n",
       " 'Made',\n",
       " 'Malcolm X',\n",
       " 'Man On Fire',\n",
       " 'Marty',\n",
       " 'Mash',\n",
       " 'Meet John Doe',\n",
       " 'Metro',\n",
       " 'Metropolis',\n",
       " 'Mobsters',\n",
       " 'Monkeybone',\n",
       " 'Mr. Smith Goes To Washington',\n",
       " 'Mr. Deeds Goes To Town',\n",
       " 'Mumford',\n",
       " 'The Mummy',\n",
       " 'Mystery Men',\n",
       " 'Napoleon',\n",
       " 'Next Friday',\n",
       " 'Nick Of Time',\n",
       " 'The Night Of The Hunter',\n",
       " 'A Nightmare On Elm Street',\n",
       " 'Ninotchka',\n",
       " 'Nixon',\n",
       " 'No Country For Old Men',\n",
       " 'Nurse Betty',\n",
       " 'O Brother Where Art Thou?',\n",
       " 'An Officer And A Gentleman',\n",
       " 'Panic Room',\n",
       " 'Panther',\n",
       " 'The Patriot',\n",
       " 'Pet Sematary',\n",
       " 'Platinum Blonde',\n",
       " 'Pleasantville',\n",
       " 'Punch-Drunk Love',\n",
       " 'Quills',\n",
       " 'Raging Bull',\n",
       " 'Rear Window',\n",
       " 'Rebel Without A Cause',\n",
       " 'Reindeer Games',\n",
       " 'Reservoir Dogs',\n",
       " 'Roughshod',\n",
       " 'Scary Movie 2',\n",
       " 'Serial Mom',\n",
       " 'The Seventh Victim',\n",
       " 'Sex Lies And Videotape',\n",
       " 'Shivers',\n",
       " 'Shock Treatment',\n",
       " 'Sideways',\n",
       " 'Signs',\n",
       " 'Silverado',\n",
       " 'The Sixth Sense',\n",
       " 'Slash',\n",
       " 'Slither',\n",
       " 'Smokey And The Bandit',\n",
       " \"Smokin' Aces\",\n",
       " 'Solaris',\n",
       " 'Someone To Watch Over Me',\n",
       " 'Spider-Man',\n",
       " 'Stalag 17',\n",
       " 'Star Trek: Generations',\n",
       " 'Star Trek Iii: The Search For Spock',\n",
       " 'Star Trek Iv: The Voyage Home',\n",
       " 'Star Trek: Insurrection',\n",
       " 'Star Trek: First Contact',\n",
       " 'Star Trek Vi: The Undiscovered Country',\n",
       " 'Star Trek: Nemesis',\n",
       " 'Starman',\n",
       " 'Strange Days',\n",
       " 'Suspect Zero',\n",
       " 'Swingers',\n",
       " 'The Godfather',\n",
       " 'The Talented Mr. Ripley',\n",
       " 'Taxi Driver',\n",
       " 'The Rock',\n",
       " 'The Majestic',\n",
       " 'The Birds',\n",
       " 'The Body Snatcher',\n",
       " 'The Crow: Salvation',\n",
       " 'The Day The Earth Stood Still',\n",
       " 'The Lost Boys',\n",
       " 'The Thing',\n",
       " 'The Time Machine',\n",
       " 'The Jacket',\n",
       " 'Thelma & Louise',\n",
       " \"There'S Something About Mary\",\n",
       " 'Thirteen Days',\n",
       " 'Thunderheart',\n",
       " 'Top Gun',\n",
       " 'Total Recall',\n",
       " 'Tremors',\n",
       " 'True Believer',\n",
       " 'Twin Peaks: Fire Walk With Me',\n",
       " 'The Verdict',\n",
       " 'The War Of The Worlds',\n",
       " 'White Squall',\n",
       " 'Wild At Heart',\n",
       " 'Wonder Boys',\n",
       " 'The Woodsman',\n",
       " 'The Abyss',\n",
       " \"L'Avventura\",\n",
       " 'Agnes Of God',\n",
       " \"A Hard Day'S Night\",\n",
       " 'Alien',\n",
       " 'All About Eve',\n",
       " \"All The President'S Men\",\n",
       " 'American Pie',\n",
       " 'An American Werewolf In Paris',\n",
       " 'Anastasia',\n",
       " 'Annie Hall',\n",
       " 'The Anniversary Party',\n",
       " 'Antz',\n",
       " 'The Apartment',\n",
       " 'Apocalypse Now',\n",
       " 'Arctic Blue',\n",
       " 'As Good As It Gets',\n",
       " 'Assassins',\n",
       " 'Asylum',\n",
       " 'A Walk To Remember',\n",
       " 'Back To The Future',\n",
       " 'Badlands',\n",
       " 'The Adventures Of Buckaroo Banzai Across The 8Th Dimension',\n",
       " 'Barton Fink',\n",
       " 'Basic Instinct',\n",
       " 'Basquiat',\n",
       " 'Batman Returns',\n",
       " 'Batman And Robin',\n",
       " 'Batman Forever',\n",
       " 'Batman',\n",
       " 'Bean',\n",
       " 'Beavis And Butt-Head Do America',\n",
       " 'Being There',\n",
       " 'Being John Malkovich',\n",
       " 'Beloved',\n",
       " 'The Big Lebowski',\n",
       " 'The Black Dahlia',\n",
       " 'Blade Ii',\n",
       " 'Blade',\n",
       " 'Book Of Shadows: Blair Witch 2',\n",
       " 'Blood Simple.',\n",
       " 'Bloodmoon',\n",
       " 'Blow',\n",
       " 'La Battaglia Di Algeri',\n",
       " 'The Bridges Of Madison County',\n",
       " 'Bones',\n",
       " 'Bound',\n",
       " 'The Bourne Identity',\n",
       " 'Brazil',\n",
       " 'Bringing Out The Dead',\n",
       " 'Broadcast News',\n",
       " 'A Bucket Of Blood',\n",
       " 'Buffy The Vampire Slayer',\n",
       " 'Bull Durham',\n",
       " 'Casino',\n",
       " 'Catwoman',\n",
       " 'Cellular',\n",
       " 'The Crying Game',\n",
       " 'Charade',\n",
       " 'Cherry Falls',\n",
       " 'Chill Factor',\n",
       " 'Chinatown',\n",
       " 'Nuovo Cinema Paradiso',\n",
       " 'Citizen Kane',\n",
       " 'Clerks.',\n",
       " 'Cliffhanger',\n",
       " 'A Clockwork Orange',\n",
       " 'Collateral',\n",
       " 'Conspiracy Theory',\n",
       " 'Contact',\n",
       " 'Cool Hand Luke',\n",
       " 'Copycat',\n",
       " 'Crash',\n",
       " 'Crime Spree',\n",
       " 'The Crow',\n",
       " 'Cruel Intentions',\n",
       " 'The Curse Of The Cat People',\n",
       " 'The Curse',\n",
       " 'Dark City',\n",
       " 'Dave',\n",
       " 'Day Of The Dead',\n",
       " 'Dead Poets Society',\n",
       " 'Deep Rising',\n",
       " 'The Deer Hunter',\n",
       " 'Demolition Man',\n",
       " 'Die Hard',\n",
       " 'Dog Day Afternoon',\n",
       " 'Domino',\n",
       " 'Do The Right Thing',\n",
       " 'Dumb And Dumberer: When Harry Met Lloyd',\n",
       " 'Dune',\n",
       " 'Ed Wood',\n",
       " 'Edtv',\n",
       " 'Election',\n",
       " 'L.A. Confidential',\n",
       " 'Enemy Of The State',\n",
       " 'The English Patient',\n",
       " 'Entrapment',\n",
       " 'Erin Brockovich',\n",
       " 'Escape From The Planet Of The Apes',\n",
       " 'Escape From L.A.',\n",
       " 'Excalibur',\n",
       " 'The Exorcist',\n",
       " 'The Fabulous Baker Boys',\n",
       " 'Face/Off',\n",
       " 'The Family Man',\n",
       " 'The Fantastic Four',\n",
       " 'Fantastic Voyage',\n",
       " 'Fargo',\n",
       " 'Fight Club',\n",
       " 'Final Destination 2',\n",
       " 'Final Destination',\n",
       " 'Rambo: First Blood Part Ii',\n",
       " 'The Fisher King',\n",
       " 'Five Easy Pieces',\n",
       " 'Fletch',\n",
       " 'The Adventures Of Ford Fairlane',\n",
       " 'The French Connection',\n",
       " 'Frequency',\n",
       " 'Friday The 13Th Part Iii',\n",
       " 'Jason Goes To Hell: The Final Friday',\n",
       " 'Friday The 13Th Part Viii: Jason Takes Manhattan',\n",
       " 'Game 6',\n",
       " 'Gandhi',\n",
       " 'Gattaca',\n",
       " 'The Getaway',\n",
       " 'Get Carter',\n",
       " 'Glengarry Glen Ross',\n",
       " 'The Godfather: Part Ii',\n",
       " 'Gods And Monsters',\n",
       " 'Gone In Sixty Seconds',\n",
       " 'Goodfellas',\n",
       " 'Good Will Hunting',\n",
       " 'The Grapes Of Wrath',\n",
       " 'Grosse Pointe Blank',\n",
       " 'The Horse Whisperer',\n",
       " 'Hackers',\n",
       " 'Halloween 4: The Return Of Michael Myers',\n",
       " 'Halloween',\n",
       " 'Hannah And Her Sisters',\n",
       " 'Hannibal',\n",
       " 'Happy Campers',\n",
       " 'Heathers',\n",
       " 'Heavenly Creatures',\n",
       " 'Hero',\n",
       " 'Hider In The House',\n",
       " 'Highlander Iii: The Sorcerer',\n",
       " 'Hostage',\n",
       " 'Hotel Rwanda',\n",
       " 'House On Haunted Hill',\n",
       " 'House Of The Damned',\n",
       " 'Hellraiser Iii: Hell On Earth',\n",
       " 'Hudson Hawk',\n",
       " 'The Hudsucker Proxy',\n",
       " 'I Walked With A Zombie',\n",
       " 'The Ice Storm',\n",
       " 'Insomnia',\n",
       " 'Interview With The Vampire: The Vampire Chronicles',\n",
       " 'I Still Know What You Did Last Summer',\n",
       " 'Isle Of The Dead',\n",
       " \"It'S A Wonderful Life\",\n",
       " 'Jaws 2',\n",
       " 'Jaws 3-D',\n",
       " 'Jaws: The Revenge',\n",
       " 'The Jazz Singer',\n",
       " 'Jennifer Eight',\n",
       " 'Jerry Maguire',\n",
       " 'Jurassic Park Iii',\n",
       " 'The Lost World: Jurassic Park',\n",
       " 'Jurassic Park',\n",
       " 'Freddy Vs. Jason',\n",
       " 'Kafka',\n",
       " 'King Kong',\n",
       " 'Klute',\n",
       " 'Kramer Vs. Kramer',\n",
       " 'Kundun',\n",
       " 'Lake Placid',\n",
       " 'The Silence Of The Lambs',\n",
       " 'Leviathan',\n",
       " 'Lock Stock And Two Smoking Barrels',\n",
       " 'Lone Star',\n",
       " 'Lord Of Illusions',\n",
       " 'Lost In Translation',\n",
       " 'Lost Souls',\n",
       " 'Love & Basketball',\n",
       " 'Magnolia',\n",
       " 'The Man In The Iron Mask',\n",
       " 'The Man In The Iron Mask',\n",
       " 'Manhunter',\n",
       " 'Man On The Moon',\n",
       " 'The Matrix',\n",
       " 'Halloween Iii: Season Of The Witch',\n",
       " 'Meet Joe Black',\n",
       " 'Memento',\n",
       " 'Miami Vice',\n",
       " 'Midnight Cowboy',\n",
       " 'Midnight Express',\n",
       " 'Mimic',\n",
       " 'Misery',\n",
       " 'Mission: Impossible Ii',\n",
       " 'Mission: Impossible',\n",
       " 'Moonstruck',\n",
       " 'Monty Python And The Holy Grail',\n",
       " 'Mrs Brown',\n",
       " 'Mulholland Dr.',\n",
       " 'My Girl 2',\n",
       " 'My Girl',\n",
       " \"My Best Friend'S Wedding\",\n",
       " 'Nashville',\n",
       " 'Natural Born Killers',\n",
       " 'Nothing But A Man',\n",
       " 'The Negotiator',\n",
       " 'Never Been Kissed',\n",
       " 'The Nightmare Before Christmas',\n",
       " \"A Nightmare On Elm Street Part 2: Freddy'S Revenge\",\n",
       " 'A Nightmare On Elm Street 3: Dream Warriors',\n",
       " 'Notting Hill',\n",
       " \"One Flew Over The Cuckoo'S Nest\",\n",
       " 'Only You',\n",
       " 'On The Waterfront',\n",
       " 'Orgy Of The Dead',\n",
       " 'Out Of Sight',\n",
       " 'Pearl Harbor',\n",
       " 'Peggy Sue Got Married',\n",
       " 'Pet Sematary Ii',\n",
       " 'Philadelphia',\n",
       " 'Pitch Black',\n",
       " 'Planet Of The Apes',\n",
       " 'Platoon',\n",
       " 'Playback',\n",
       " \"The Ploughman'S Lunch\",\n",
       " 'Point Break',\n",
       " 'Predator',\n",
       " 'Pretty Woman',\n",
       " 'The Princess Bride',\n",
       " 'Psycho',\n",
       " 'Maniac',\n",
       " 'Vampyr',\n",
       " 'Mystery Of The Wax Museum',\n",
       " 'Rambling Rose',\n",
       " 'Star Wars: Episode Vi - Return Of The Jedi',\n",
       " 'The Rocky Horror Picture Show',\n",
       " 'Rocky',\n",
       " 'Who Framed Roger Rabbit',\n",
       " 'Romeo And Juliet',\n",
       " 'Ronin',\n",
       " 'Rush Hour 2',\n",
       " 'Rush Hour',\n",
       " 'Runaway Bride',\n",
       " 'Sleepless In Seattle',\n",
       " 'Salt Of The Earth',\n",
       " 'The Salton Sea',\n",
       " 'Saving Private Ryan',\n",
       " 'Say Anything...',\n",
       " \"Schindler'S List\",\n",
       " 'Scream 2',\n",
       " 'Scream 3',\n",
       " 'Scream',\n",
       " 'Seven',\n",
       " 'The Searchers',\n",
       " 'Seven Days To Live',\n",
       " 'Shakespeare In Love',\n",
       " 'Shallow Grave',\n",
       " 'Shampoo',\n",
       " 'The Shining',\n",
       " 'Silver Bullet',\n",
       " 'Sister Act',\n",
       " 'Sleepy Hollow',\n",
       " 'Sling Blade',\n",
       " 'Smoke',\n",
       " 'Snow Falling On Cedars',\n",
       " 'Soldier',\n",
       " 'Soldier',\n",
       " 'Some Like It Hot',\n",
       " 'The Wedding Date',\n",
       " 'Sounder',\n",
       " 'South Park: Bigger Longer & Uncut',\n",
       " 'Spacejacked',\n",
       " 'Sphere',\n",
       " 'Star Wars',\n",
       " 'Starship Troopers',\n",
       " 'Star Trek: The Motion Picture',\n",
       " 'State And Main',\n",
       " 'Stepmom',\n",
       " 'Storytelling',\n",
       " 'Dr. Strangelove Or: How I Learned To Stop Worrying And Love The Bomb',\n",
       " 'Suburbia',\n",
       " 'Sugar & Spice',\n",
       " 'Sunset Blvd.',\n",
       " 'Supergirl',\n",
       " 'Superman Iii',\n",
       " 'Superman Ii',\n",
       " 'Superman Iv: The Quest For Peace',\n",
       " 'Superman',\n",
       " 'The Sweet Hereafter',\n",
       " 'Sweet Smell Of Success',\n",
       " 'Terminator 2: Judgment Day',\n",
       " 'Taking Sides',\n",
       " 'The Terminator',\n",
       " 'The Game',\n",
       " 'The Haunting',\n",
       " 'The Limey',\n",
       " \"The Man Who Wasn'T There\",\n",
       " 'The Relic',\n",
       " 'The Truman Show',\n",
       " 'The X Files',\n",
       " 'The Cell',\n",
       " 'The Third Man',\n",
       " 'The Beach',\n",
       " 'The Believer',\n",
       " 'Le Grand Bleu',\n",
       " 'The Hebrew Hammer',\n",
       " 'The Leopard Man',\n",
       " 'The Lost Son',\n",
       " 'The Messenger',\n",
       " 'The Pianist',\n",
       " 'The Piano',\n",
       " 'The Sting',\n",
       " 'The Thin Man',\n",
       " 'Three Kings',\n",
       " 'Thx 1138',\n",
       " 'Ticker',\n",
       " 'Trouble In Paradise',\n",
       " 'Titanic',\n",
       " 'Transatlantic Merry-Go-Round',\n",
       " 'Tombstone',\n",
       " 'Tomorrow Never Dies',\n",
       " 'To Sleep With Anger',\n",
       " 'Toy Story',\n",
       " 'The Magic Toyshop',\n",
       " 'Traffic',\n",
       " 'Trainspotting',\n",
       " 'Star Trek V: The Final Frontier',\n",
       " 'Tron',\n",
       " 'True Lies',\n",
       " 'True Romance',\n",
       " 'Twelve Monkeys',\n",
       " 'U Turn',\n",
       " 'Unbreakable',\n",
       " 'Unforgiven',\n",
       " 'The Usual Suspects',\n",
       " 'Verdict',\n",
       " 'Vertigo',\n",
       " 'Very Bad Things',\n",
       " 'Viridiana',\n",
       " 'Virtuosity',\n",
       " 'Wag The Dog',\n",
       " 'Wall Street',\n",
       " 'Waxwork',\n",
       " 'What Lies Beneath',\n",
       " 'What Women Want',\n",
       " 'White Angel',\n",
       " 'Wild Things',\n",
       " 'Wild Wild West',\n",
       " 'Willow',\n",
       " 'Witness',\n",
       " 'The Wizard Of Oz',\n",
       " 'The World Is Not Enough',\n",
       " 'Watchmen',\n",
       " 'Xxx',\n",
       " 'X-Men',\n",
       " 'Young Frankenstein',\n",
       " 'Zulu Dawn']"
      ]
     },
     "metadata": {},
     "execution_count": 10
    }
   ],
   "source": [
    "final_df['title'].tolist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ]
}