2. Clean_data.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import io\n",
    "import sys\n",
    "import os.path\n",
    "import urllib.request\n",
    "from tqdm import tqdm\n",
    "from os import listdir\n",
    "from PIL import Image\n",
    "import glob\n",
    "\n",
    "pd.set_option('display.max_colwidth', -1)\n",
    "np.set_printoptions(threshold=sys.maxsize)"
   ]
  },
  {
   "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>imdbId</th>\n",
       "      <th>Title</th>\n",
       "      <th>Genre</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>114709</td>\n",
       "      <td>Toy Story (1995)</td>\n",
       "      <td>Animation|Adventure|Comedy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>113497</td>\n",
       "      <td>Jumanji (1995)</td>\n",
       "      <td>Action|Adventure|Family</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>113228</td>\n",
       "      <td>Grumpier Old Men (1995)</td>\n",
       "      <td>Comedy|Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>114885</td>\n",
       "      <td>Waiting to Exhale (1995)</td>\n",
       "      <td>Comedy|Drama|Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>113041</td>\n",
       "      <td>Father of the Bride Part II (1995)</td>\n",
       "      <td>Comedy|Family|Romance</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   imdbId                               Title                       Genre\n",
       "0  114709  Toy Story (1995)                    Animation|Adventure|Comedy\n",
       "1  113497  Jumanji (1995)                      Action|Adventure|Family   \n",
       "2  113228  Grumpier Old Men (1995)             Comedy|Romance            \n",
       "3  114885  Waiting to Exhale (1995)            Comedy|Drama|Romance      \n",
       "4  113041  Father of the Bride Part II (1995)  Comedy|Family|Romance     "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv(\"MovieGenre_cleaned.csv\",encoding='ISO-8859-1')\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(37495, 3)"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Number of files found: 36918\n"
     ]
    }
   ],
   "source": [
    "# How many images actually downloaded\n",
    "\n",
    "image_list = []\n",
    "for file in glob.glob(\"Posters/*.jpg\"):\n",
    "    image_list.append(file)\n",
    "    \n",
    "print(\"Number of files found:\", len(image_list))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Resolve mis-match\n",
    "# Create new dataframe with paths of found images and fill with corresponding metadata from dataframe. \n",
    "\n",
    "image_paths = []\n",
    "imdb_id = []\n",
    "genres = []\n",
    "titles = []\n",
    "\n",
    "for file in glob.glob(\"Posters/*.jpg\"):\n",
    "    \n",
    "    #img_id = file.split('.')[0]    \n",
    "    img_id = file[file.find('/')+1 : file.find('.')]\n",
    "    title = df[df[\"imdbId\"] == int(img_id)][\"Title\"].values[0]\n",
    "    genre = df[df[\"imdbId\"] == int(img_id)][\"Genre\"].values[0]\n",
    "    \n",
    "    image_paths.append(file)\n",
    "    imdb_id.append(img_id)\n",
    "    genres.append(genre)\n",
    "    titles.append(title)\n",
    "    \n",
    "    \n",
    "df_2 = pd.DataFrame({'imdbId': imdb_id, 'Genre': genres, 'Title': titles, 'Image_Paths': image_paths})\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(36918, 4)\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Image_Paths</th>\n",
       "      <th>imdbId</th>\n",
       "      <th>Genre</th>\n",
       "      <th>Title</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Posters/27428.jpg</td>\n",
       "      <td>27428</td>\n",
       "      <td>Crime|Mystery|Drama</td>\n",
       "      <td>The Case of the Black Cat (1936)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Posters/972555.jpg</td>\n",
       "      <td>972555</td>\n",
       "      <td>Crime|Drama|Thriller</td>\n",
       "      <td>Exhibit A (2007)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Posters/1424062.jpg</td>\n",
       "      <td>1424062</td>\n",
       "      <td>Documentary</td>\n",
       "      <td>The Thorn in the Heart (2009)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Posters/1185371.jpg</td>\n",
       "      <td>1185371</td>\n",
       "      <td>Documentary</td>\n",
       "      <td>Corman's World: Exploits of a Hollywood Rebel (2011)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Posters/113369.jpg</td>\n",
       "      <td>113369</td>\n",
       "      <td>Drama</td>\n",
       "      <td>I Shot a Man in Vegas (1995)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           Image_Paths   imdbId                 Genre  \\\n",
       "0  Posters/27428.jpg    27428    Crime|Mystery|Drama    \n",
       "1  Posters/972555.jpg   972555   Crime|Drama|Thriller   \n",
       "2  Posters/1424062.jpg  1424062  Documentary            \n",
       "3  Posters/1185371.jpg  1185371  Documentary            \n",
       "4  Posters/113369.jpg   113369   Drama                  \n",
       "\n",
       "                                                  Title  \n",
       "0  The Case of the Black Cat (1936)                      \n",
       "1  Exhibit A (2007)                                      \n",
       "2  The Thorn in the Heart (2009)                         \n",
       "3  Corman's World: Exploits of a Hollywood Rebel (2011)  \n",
       "4  I Shot a Man in Vegas (1995)                          "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "print(df_2.shape)\n",
    "df_2.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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>Image_Paths</th>\n",
       "      <th>imdbId</th>\n",
       "      <th>Genre</th>\n",
       "      <th>Title</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Posters/27428.jpg</td>\n",
       "      <td>27428</td>\n",
       "      <td>Crime|Mystery|Drama</td>\n",
       "      <td>The Case of the Black Cat (1936)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Posters/972555.jpg</td>\n",
       "      <td>972555</td>\n",
       "      <td>Crime|Drama|Thriller</td>\n",
       "      <td>Exhibit A (2007)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Posters/1424062.jpg</td>\n",
       "      <td>1424062</td>\n",
       "      <td>Documentary</td>\n",
       "      <td>The Thorn in the Heart (2009)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Posters/1185371.jpg</td>\n",
       "      <td>1185371</td>\n",
       "      <td>Documentary</td>\n",
       "      <td>Corman's World: Exploits of a Hollywood Rebel (2011)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Posters/113369.jpg</td>\n",
       "      <td>113369</td>\n",
       "      <td>Drama</td>\n",
       "      <td>I Shot a Man in Vegas (1995)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           Image_Paths   imdbId                 Genre  \\\n",
       "0  Posters/27428.jpg    27428    Crime|Mystery|Drama    \n",
       "1  Posters/972555.jpg   972555   Crime|Drama|Thriller   \n",
       "2  Posters/1424062.jpg  1424062  Documentary            \n",
       "3  Posters/1185371.jpg  1185371  Documentary            \n",
       "4  Posters/113369.jpg   113369   Drama                  \n",
       "\n",
       "                                                  Title  \n",
       "0  The Case of the Black Cat (1936)                      \n",
       "1  Exhibit A (2007)                                      \n",
       "2  The Thorn in the Heart (2009)                         \n",
       "3  Corman's World: Exploits of a Hollywood Rebel (2011)  \n",
       "4  I Shot a Man in Vegas (1995)                          "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "columnsTitles = ['Image_Paths','imdbId','Genre','Title']\n",
    "df_2 = df_2.reindex(columns=columnsTitles)\n",
    "df_2.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_2.to_csv(\"MovieGenre_final.csv\", index = None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "ORIGINAL: 37495\n",
      "TRIMMED: 36918\n",
      "#unique ID values in ORIGINAL: 36918\n",
      "#unique ID values in TRIMMED: 36918\n"
     ]
    }
   ],
   "source": [
    "# Investigating which of the Imdb_Id of the original csv, did not have a corresponding image\n",
    "\n",
    "Original_ID_list = np.asarray(df['imdbId']).astype(int)\n",
    "ID_with_images_found = np.asarray(df_2['imdbId']).astype(int)\n",
    "\n",
    "#Original lengths of the two arrays \n",
    "print(\"ORIGINAL:\", len(Original_ID_list))\n",
    "print(\"TRIMMED:\", len(ID_with_images_found))\n",
    "\n",
    "#First compare the unique values of these two arrays\n",
    "uniq1, counts1 = np.unique(Original_ID_list, return_counts=True)\n",
    "print(\"#unique ID values in ORIGINAL:\", len(uniq1))\n",
    "\n",
    "uniq2, counts2 = np.unique(ID_with_images_found, return_counts=True)\n",
    "print(\"#unique ID values in TRIMMED:\", len(uniq2))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "       imdbId             Title                 Genre\n",
      "11464  11358   Just Pals (1920)  Comedy|Drama|Western\n",
      "12042  11358   Just Pals (1920)  Comedy|Drama|Western\n",
      "       imdbId              Title                     Genre\n",
      "11386  13556   Robin Hood (1922)  Adventure|Family|Romance\n",
      "11964  13556   Robin Hood (1922)  Adventure|Family|Romance\n",
      "       imdbId             Title            Genre\n",
      "11465  17463   3 Bad Men (1926)  Romance|Western\n",
      "12043  17463   3 Bad Men (1926)  Romance|Western\n",
      "       imdbId            Title                    Genre\n",
      "11608  18192   Napoleon (1927)  Biography|Drama|History\n",
      "12186  18192   Napoleon (1927)  Biography|Drama|History\n",
      "       imdbId             Title      Genre\n",
      "11528  18909   Four Sons (1928)  Drama|War\n",
      "12106  18909   Four Sons (1928)  Drama|War\n",
      "       imdbId                   Title                   Genre\n",
      "11530  18972   Hangman's House (1928)  Drama|Romance|Thriller\n",
      "12108  18972   Hangman's House (1928)  Drama|Romance|Thriller\n",
      "       imdbId                       Title  Genre\n",
      "11463  19074   Laugh, Clown, Laugh (1928)  Drama\n",
      "12041  19074   Laugh, Clown, Laugh (1928)  Drama\n",
      "       imdbId                 Title                    Genre\n",
      "11776  20030   The Iron Mask (1929)  Adventure|Drama|History\n",
      "12354  20030   The Iron Mask (1929)  Adventure|Drama|History\n",
      "       imdbId                 Title                  Genre\n",
      "11537  20702   Born Reckless (1930)  Crime|Drama|Film-Noir\n",
      "12115  20702   Born Reckless (1930)  Crime|Drama|Film-Noir\n",
      "       imdbId                Title               Genre\n",
      "11539  21508   Up the River (1930)  Comedy|Crime|Drama\n",
      "12117  21508   Up the River (1930)  Comedy|Crime|Drama\n",
      "       imdbId                          Title                   Genre\n",
      "11616  22074   The Smiling Lieutenant (1931)  Comedy|Romance|Musical\n",
      "12194  22074   The Smiling Lieutenant (1931)  Comedy|Romance|Musical\n",
      "       imdbId                Title             Genre\n",
      "11545  22353   Seas Beneath (1931)  Action|Drama|War\n",
      "12123  22353   Seas Beneath (1931)  Action|Drama|War\n",
      "       imdbId                     Title   Genre\n",
      "11269  23236   The Monster Walks (1932)  Horror\n",
      "11847  23236   The Monster Walks (1932)  Horror\n",
      "       imdbId                             Title                 Genre\n",
      "11684  23249   Murders in the Rue Morgue (1932)  Crime|Horror|Mystery\n",
      "12262  23249   Murders in the Rue Morgue (1932)  Crime|Horror|Mystery\n",
      "       imdbId                     Title                   Genre\n",
      "11748  23303   One Hour with You (1932)  Comedy|Musical|Romance\n",
      "12326  23303   One Hour with You (1932)  Comedy|Musical|Romance\n",
      "       imdbId               Title                 Genre\n",
      "11598  23955   Doctor Bull (1933)  Comedy|Drama|Romance\n",
      "12176  23955   Doctor Bull (1933)  Comedy|Drama|Romance\n",
      "       imdbId              Title  Genre\n",
      "11781  24453   Pilgrimage (1933)  Drama\n",
      "12359  24453   Pilgrimage (1933)  Drama\n",
      "       imdbId                             Title                   Genre\n",
      "11503  25004   The Count of Monte Cristo (1934)  Action|Adventure|Drama\n",
      "12081  25004   The Count of Monte Cristo (1934)  Action|Adventure|Drama\n",
      "       imdbId               Title              Genre\n",
      "11460  25948   Viva Villa! (1934)  Biography|Western\n",
      "12038  25948   Viva Villa! (1934)  Biography|Western\n",
      "       imdbId                      Title                  Genre\n",
      "11780  26008   The World Moves On (1934)  Drama|History|Romance\n",
      "12358  26008   The World Moves On (1934)  Drama|History|Romance\n",
      "       imdbId                  Title    Genre\n",
      "11303  26267   The Dawn Rider (1935)  Western\n",
      "11881  26267   The Dawn Rider (1935)  Western\n",
      "       imdbId                            Title                 Genre\n",
      "11779  27042   Steamboat Round the Bend (1935)  Comedy|Drama|Romance\n",
      "12357  27042   Steamboat Round the Bend (1935)  Comedy|Drama|Romance\n",
      "       imdbId                Title    Genre\n",
      "11325  27087   Texas Terror (1935)  Western\n",
      "11903  27087   Texas Terror (1935)  Western\n",
      "       imdbId                     Title                   Genre\n",
      "11683  27800   The Invisible Ray (1936)  Horror|Sci-Fi|Thriller\n",
      "12261  27800   The Invisible Ray (1936)  Horror|Sci-Fi|Thriller\n",
      "       imdbId                                Title                    Genre\n",
      "11505  28141   The Prisoner of Shark Island (1936)  Biography|Drama|History\n",
      "12083  28141   The Prisoner of Shark Island (1936)  Biography|Drama|History\n",
      "       imdbId                  Title             Genre\n",
      "11686  28345   Tarzan Escapes (1936)  Action|Adventure\n",
      "12264  28345   Tarzan Escapes (1936)  Action|Adventure\n",
      "       imdbId                          Title                  Genre\n",
      "11461  31851   The Return of Doctor X (1939)  Horror|Mystery|Sci-Fi\n",
      "12039  31851   The Return of Doctor X (1939)  Horror|Mystery|Sci-Fi\n",
      "       imdbId                       Title  Genre\n",
      "11725  31976   The Stars Look Down (1940)  Drama\n",
      "12303  31976   The Stars Look Down (1940)  Drama\n",
      "       imdbId                       Title                    Genre\n",
      "11687  32007   Tarzan Finds a Son! (1939)  Action|Adventure|Family\n",
      "12265  32007   Tarzan Finds a Son! (1939)  Action|Adventure|Family\n",
      "       imdbId                Title                Genre\n",
      "11682  32258   Black Friday (1940)  Drama|Horror|Sci-Fi\n",
      "12260  32258   Black Friday (1940)  Drama|Horror|Sci-Fi\n",
      "       imdbId                 Title  Genre\n",
      "11514  33677   The Great Lie (1941)  Drama\n",
      "12092  33677   The Great Lie (1941)  Drama\n",
      "       imdbId                Title            Genre\n",
      "11273  34162   The Sea Wolf (1941)  Drama|Adventure\n",
      "11851  34162   The Sea Wolf (1941)  Drama|Adventure\n",
      "       imdbId                             Title                    Genre\n",
      "11348  34182   The Shepherd of the Hills (1941)  Adventure|Drama|Romance\n",
      "11926  34182   The Shepherd of the Hills (1941)  Adventure|Drama|Romance\n",
      "       imdbId                       Title                 Genre\n",
      "11592  34241   Sun Valley Serenade (1941)  Comedy|Music|Romance\n",
      "12170  34241   Sun Valley Serenade (1941)  Comedy|Music|Romance\n",
      "       imdbId                            Title                     Genre\n",
      "11688  34266   Tarzan's Secret Treasure (1941)  Action|Adventure|Romance\n",
      "12266  34266   Tarzan's Secret Treasure (1941)  Action|Adventure|Romance\n",
      "       imdbId                       Title                  Genre\n",
      "11353  34272   That Hamilton Woman (1941)  Drama|History|Romance\n",
      "11931  34272   That Hamilton Woman (1941)  Drama|History|Romance\n",
      "       imdbId                     Title      Genre\n",
      "11519  34891   In Which We Serve (1942)  Drama|War\n",
      "12097  34891   In Which We Serve (1942)  Drama|War\n",
      "       imdbId                       Title          Genre\n",
      "11554  34936   Keeper of the Flame (1942)  Drama|Mystery\n",
      "12132  34936   Keeper of the Flame (1942)  Drama|Mystery\n",
      "       imdbId                               Title             Genre\n",
      "11689  35419   Tarzan's New York Adventure (1942)  Action|Adventure\n",
      "12267  35419   Tarzan's New York Adventure (1942)  Action|Adventure\n",
      "       imdbId                Title              Genre\n",
      "11491  35440   Thunder Rock (1942)  Drama|Fantasy|War\n",
      "12069  35440   Thunder Rock (1942)  Drama|Fantasy|War\n",
      "       imdbId                      Title                  Genre\n",
      "11379  36641   Between Two Worlds (1944)  Mystery|Drama|Fantasy\n",
      "11957  36641   Between Two Worlds (1944)  Mystery|Drama|Fantasy\n",
      "       imdbId                      Title            Genre\n",
      "11259  36692   Can't Help Singing (1944)  Musical|Western\n",
      "11837  36692   Can't Help Singing (1944)  Musical|Western\n",
      "       imdbId                Title          Genre\n",
      "11299  39402   The Fugitive (1947)  Drama|History\n",
      "11877  39402   The Fugitive (1947)  Drama|History\n",
      "       imdbId                     Title                   Genre\n",
      "11555  40317   The Emperor Waltz (1948)  Comedy|Musical|Romance\n",
      "12133  40317   The Emperor Waltz (1948)  Comedy|Musical|Romance\n",
      "       imdbId                      Title                  Genre\n",
      "11573  40974   The Woman in White (1948)  Drama|Mystery|Romance\n",
      "12151  40974   The Woman in White (1948)  Drama|Mystery|Romance\n",
      "       imdbId                       Title                  Genre\n",
      "11279  41786   The Reckless Moment (1949)  Crime|Drama|Film-Noir\n",
      "11857  41786   The Reckless Moment (1949)  Crime|Drama|Film-Noir\n",
      "       imdbId              Title                     Genre\n",
      "11730  42046   The Window (1949)  Drama|Film-Noir|Thriller\n",
      "12308  42046   The Window (1949)  Drama|Film-Noir|Thriller\n",
      "       imdbId                      Title                  Genre\n",
      "11236  42281   The Breaking Point (1950)  Crime|Drama|Film-Noir\n",
      "11814  42281   The Breaking Point (1950)  Crime|Drama|Film-Noir\n",
      "       imdbId                           Title                  Genre\n",
      "11769  43132   Where the Sidewalk Ends (1950)  Crime|Film-Noir|Drama\n",
      "12347  43132   Where the Sidewalk Ends (1950)  Crime|Film-Noir|Drama\n",
      "       imdbId                    Title             Genre\n",
      "11330  44072   The Steel Helmet (1951)  Action|Drama|War\n",
      "11908  44072   The Steel Helmet (1951)  Action|Drama|War\n",
      "       imdbId                            Title                  Genre\n",
      "11318  44789   Kansas City Confidential (1952)  Crime|Drama|Film-Noir\n",
      "11896  44789   Kansas City Confidential (1952)  Crime|Drama|Film-Noir\n",
      "       imdbId                Title                    Genre\n",
      "11690  45296   Viva Zapata! (1952)  Biography|Drama|History\n",
      "12268  45296   Viva Zapata! (1952)  Biography|Drama|History\n",
      "       imdbId                   Title                     Genre\n",
      "11724  46031   The Man Between (1953)  Drama|Film-Noir|Thriller\n",
      "12302  46031   The Man Between (1953)  Drama|Film-Noir|Thriller\n",
      "       imdbId                    Title                    Genre\n",
      "11422  47200   The Mad Magician (1954)  Horror|Thriller|Mystery\n",
      "12000  47200   The Mad Magician (1954)  Horror|Thriller|Mystery\n",
      "       imdbId               Title             Genre\n",
      "11771  47889   Blood Alley (1955)  Action|Adventure\n",
      "12349  47889   Blood Alley (1955)  Action|Adventure\n",
      "       imdbId                       Title                  Genre\n",
      "11304  47985   The Desperate Hours (1955)  Crime|Drama|Film-Noir\n",
      "11882  47985   The Desperate Hours (1955)  Crime|Drama|Film-Noir\n",
      "       imdbId                     Title  Genre\n",
      "11527  48198   Ikimono no kiroku (1955)  Drama\n",
      "12105  48198   Ikimono no kiroku (1955)  Drama\n",
      "       imdbId                           Title      Genre\n",
      "11243  49004   Between Heaven and Hell (1956)  Drama|War\n",
      "11821  49004   Between Heaven and Hell (1956)  Drama|War\n",
      "       imdbId                 Title   Genre\n",
      "11484  50456   The Green Man (1956)  Comedy\n",
      "12062  50456   The Green Man (1956)  Comedy\n",
      "       imdbId                       Title  Genre\n",
      "11356  51093   TÃÂ«kyÃÂ« boshoku (1957)  Drama\n",
      "11934  51093   TÃÂ«kyÃÂ« boshoku (1957)  Drama\n",
      "       imdbId                       Title                Genre\n",
      "11778  51198   The Wings of Eagles (1957)  Biography|Drama|War\n",
      "12356  51198   The Wings of Eagles (1957)  Biography|Drama|War\n",
      "       imdbId             Title         Genre\n",
      "11430  51720   Higanbana (1958)  Comedy|Drama\n",
      "12008  51720   Higanbana (1958)  Comedy|Drama\n",
      "       imdbId                      Title                   Genre\n",
      "11741  52106   The Quiet American (1958)  Drama|Romance|Thriller\n",
      "12319  52106   The Quiet American (1958)  Drama|Romance|Thriller\n",
      "       imdbId                     Title    Genre\n",
      "11745  52724   Day of the Outlaw (1959)  Western\n",
      "12323  52724   Day of the Outlaw (1959)  Western\n",
      "       imdbId                 Title                Genre\n",
      "11774  52792   The FBI Story (1959)  Crime|Drama|History\n",
      "12352  52792   The FBI Story (1959)  Crime|Drama|History\n",
      "       imdbId                Title  Genre\n",
      "11782  53017   Lonelyhearts (1958)  Drama\n",
      "12360  53017   Lonelyhearts (1958)  Drama\n",
      "       imdbId                     Title                  Genre\n",
      "11255  53666   Les Bonnes Femmes (1960)  Drama|Mystery|Romance\n",
      "11833  53666   Les Bonnes Femmes (1960)  Drama|Mystery|Romance\n",
      "       imdbId                  Title                     Genre\n",
      "11796  54038   The Lost World (1960)  Adventure|Fantasy|Sci-Fi\n",
      "12374  54038   The Lost World (1960)  Adventure|Fantasy|Sci-Fi\n",
      "       imdbId                                         Title        Genre\n",
      "11235  54745   Chronique d'un ÃÂ©tÃÂ© (Paris 1960) (1961)  Documentary\n",
      "11813  54745   Chronique d'un ÃÂ©tÃÂ© (Paris 1960) (1961)  Documentary\n",
      "       imdbId            Title  Genre\n",
      "11799  55320   Il Posto (1961)  Drama\n",
      "12377  55320   Il Posto (1961)  Drama\n",
      "       imdbId               Title  Genre\n",
      "11798  55981   I Fidanzati (1963)  Drama\n",
      "12376  55981   I Fidanzati (1963)  Drama\n",
      "       imdbId                    Title  Genre\n",
      "11581  56049   The Naked Island (1960)  Drama\n",
      "12159  56049   The Naked Island (1960)  Drama\n",
      "       imdbId               Title         Genre\n",
      "11639  56919   Black Peter (1964)  Comedy|Drama\n",
      "12217  56919   Black Peter (1964)  Comedy|Drama\n",
      "       imdbId                     Title                    Genre\n",
      "11488  58203   That Man from Rio (1964)  Action|Adventure|Comedy\n",
      "12066  58203   That Man from Rio (1964)  Action|Adventure|Comedy\n",
      "       imdbId                Title                     Genre\n",
      "11435  58275   Lemonade Joe (1964)  Adventure|Comedy|Musical\n",
      "12013  58275   Lemonade Joe (1964)  Adventure|Comedy|Musical\n",
      "       imdbId                     Title  Genre\n",
      "11424  58500   The Pumpkin Eater (1964)  Drama\n",
      "12002  58500   The Pumpkin Eater (1964)  Drama\n",
      "       imdbId                                     Title  \\\n",
      "11428  58548   Santa Claus Conquers the Martians (1964)   \n",
      "12006  58548   Santa Claus Conquers the Martians (1964)   \n",
      "\n",
      "                         Genre  \n",
      "11428  Adventure|Comedy|Family  \n",
      "12006  Adventure|Comedy|Family  \n",
      "       imdbId                         Title         Genre\n",
      "11389  58564   Sedotta e abbandonata (1964)  Comedy|Drama\n",
      "11967  58564   Sedotta e abbandonata (1964)  Comedy|Drama\n",
      "       imdbId             Title     Genre\n",
      "11237  59496   The Nanny (1965)  Thriller\n",
      "11815  59496   The Nanny (1965)  Thriller\n",
      "       imdbId                 Title                 Genre\n",
      "11599  60647   Made in U.S.A (1966)  Comedy|Crime|Mystery\n",
      "12177  60647   Made in U.S.A (1966)  Comedy|Crime|Mystery\n",
      "       imdbId          Title  Genre\n",
      "11521  61042   Hunger (1966)  Drama\n",
      "12099  61042   Hunger (1966)  Drama\n",
      "       imdbId                    Title                   Genre\n",
      "11775  62639   Farewell, Friend (1968)  Action|Adventure|Crime\n",
      "12353  62639   Farewell, Friend (1968)  Action|Adventure|Crime\n",
      "       imdbId                Title                   Genre\n",
      "11308  63060   Hellfighters (1968)  Action|Adventure|Drama\n",
      "11886  63060   Hellfighters (1968)  Action|Adventure|Drama\n",
      "       imdbId                       Title                  Genre\n",
      "11634  63278   Marketa LazarovÃÃ (1967)  Drama|History|Romance\n",
      "12212  63278   Marketa LazarovÃÃ (1967)  Drama|History|Romance\n",
      "       imdbId                  Title          Genre\n",
      "11452  63483   Rachel, Rachel (1968)  Drama|Romance\n",
      "12030  63483   Rachel, Rachel (1968)  Drama|Romance\n",
      "       imdbId                              Title  Genre\n",
      "11487  63599   The Shoes of the Fisherman (1968)  Drama\n",
      "12065  63599   The Shoes of the Fisherman (1968)  Drama\n",
      "       imdbId              Title                  Genre\n",
      "11770  63970   100 Rifles (1969)  Adventure|Romance|War\n",
      "12348  63970   100 Rifles (1969)  Adventure|Romance|War\n",
      "       imdbId                  Title        Genre\n",
      "11586  64253   Downhill Racer (1969)  Drama|Sport\n",
      "12164  64253   Downhill Racer (1969)  Drama|Sport\n",
      "       imdbId                      Title               Genre\n",
      "11765  64256   Antonio das Mortes (1969)  Action|Crime|Drama\n",
      "12343  64256   Antonio das Mortes (1969)  Action|Crime|Drama\n",
      "       imdbId                        Title  Genre\n",
      "11316  65391   The American Soldier (1970)  Drama\n",
      "11894  65391   The American Soldier (1970)  Drama\n",
      "       imdbId                         Title                    Genre\n",
      "11441  65398   And Soon the Darkness (1970)  Horror|Mystery|Thriller\n",
      "12019  65398   And Soon the Darkness (1970)  Horror|Mystery|Thriller\n",
      "       imdbId                            Title                   Genre\n",
      "11462  65542   The Cheyenne Social Club (1970)  Comedy|Romance|Western\n",
      "12040  65542   The Cheyenne Social Club (1970)  Comedy|Romance|Western\n",
      "       imdbId                Title    Genre\n",
      "11772  66907   Chato's Land (1972)  Western\n",
      "12350  66907   Chato's Land (1972)  Western\n",
      "       imdbId              Title               Genre\n",
      "11773  66970   Cold Sweat (1970)  Action|Crime|Drama\n",
      "12351  66970   Cold Sweat (1970)  Action|Crime|Drama\n",
      "       imdbId                        Title                    Genre\n",
      "11258  67402   Mary, Queen of Scots (1971)  Biography|Drama|History\n",
      "11836  67402   Mary, Queen of Scots (1971)  Biography|Drama|History\n",
      "       imdbId                              Title                 Genre\n",
      "11402  67958   W.R. - Misterije organizma (1971)  Comedy|Drama|Fantasy\n",
      "11980  67958   W.R. - Misterije organizma (1971)  Comedy|Drama|Fantasy\n",
      "       imdbId                Title          Genre\n",
      "11794  68595   Flesh Gordon (1974)  Comedy|Sci-Fi\n",
      "12372  68595   Flesh Gordon (1974)  Comedy|Sci-Fi\n",
      "       imdbId        Title               Genre\n",
      "11672  69134   Pulp (1972)  Comedy|Crime|Drama\n",
      "12250  69134   Pulp (1972)  Comedy|Crime|Drama\n",
      "       imdbId           Title           Genre\n",
      "11421  69226   Savages (1972)  Fantasy|Comedy\n",
      "11999  69226   Savages (1972)  Fantasy|Comedy\n",
      "       imdbId                                        Title               Genre\n",
      "11381  70085   FuryÃÂ« anego den: Inoshika OchÃÂ« (1973)  Action|Crime|Drama\n",
      "11959  70085   FuryÃÂ« anego den: Inoshika OchÃÂ« (1973)  Action|Crime|Drama\n",
      "       imdbId                                Title           Genre\n",
      "11667  70794   The Thief Who Came to Dinner (1973)  Comedy|Romance\n",
      "12245  70794   The Thief Who Came to Dinner (1973)  Comedy|Romance\n",
      "       imdbId                     Title                   Genre\n",
      "11404  70825   The Train Robbers (1973)  Comedy|Romance|Western\n",
      "11982  70825   The Train Robbers (1973)  Comedy|Romance|Western\n",
      "       imdbId                 Title                 Genre\n",
      "11493  70904   Welt am Draht (1973)  Crime|Mystery|Sci-Fi\n",
      "12071  70904   Welt am Draht (1973)  Crime|Mystery|Sci-Fi\n",
      "       imdbId        Title   Genre\n",
      "11470  70913   Che? (1972)  Comedy\n",
      "12048  70913   Che? (1972)  Comedy\n",
      "       imdbId              Title  Genre\n",
      "11785  71483   Wrong Move (1975)  Drama\n",
      "12363  71483   Wrong Move (1975)  Drama\n",
      "       imdbId                      Title         Genre\n",
      "11302  72195   Space Is the Place (1974)  Sci-Fi|Music\n",
      "11880  72195   Space Is the Place (1974)  Sci-Fi|Music\n",
      "       imdbId                     Title  Genre\n",
      "11620  72446   The Promised Land (1975)  Drama\n",
      "12198  72446   The Promised Land (1975)  Drama\n",
      "       imdbId                     Title  Genre\n",
      "11481  73152   Kings of the Road (1976)  Drama\n",
      "12059  73152   Kings of the Road (1976)  Drama\n",
      "       imdbId                    Title                  Genre\n",
      "11685  73240   The Killer Elite (1975)  Action|Crime|Thriller\n",
      "12263  73240   The Killer Elite (1975)  Action|Crime|Thriller\n",
      "       imdbId                           Title                   Genre\n",
      "11615  73373   Terror of Mechagodzilla (1975)  Action|Adventure|Drama\n",
      "12193  73373   Terror of Mechagodzilla (1975)  Action|Adventure|Drama\n",
      "       imdbId            Title               Genre\n",
      "11777  75263   St. Ives (1976)  Action|Crime|Drama\n",
      "12355  75263   St. Ives (1976)  Action|Crime|Drama\n",
      "       imdbId           Title               Genre\n",
      "11795  76804   Telefon (1977)  Action|Crime|Drama\n",
      "12373  76804   Telefon (1977)  Action|Crime|Drama\n",
      "       imdbId                   Title                Genre\n",
      "11455  76910   Welcome to L.A. (1976)  Drama|Music|Romance\n",
      "12033  76910   Welcome to L.A. (1976)  Drama|Music|Romance\n",
      "       imdbId                    Title   Genre\n",
      "11550  76913   Which Way Is Up? (1977)  Comedy\n",
      "12128  76913   Which Way Is Up? (1977)  Comedy\n",
      "       imdbId             Title         Genre\n",
      "11522  78259   The Shout (1978)  Horror|Drama\n",
      "12100  78259   The Shout (1978)  Horror|Drama\n",
      "       imdbId                           Title                 Genre\n",
      "11288  79278   Chilly Scenes of Winter (1979)  Comedy|Drama|Romance\n",
      "11866  79278   Chilly Scenes of Winter (1979)  Comedy|Drama|Romance\n",
      "       imdbId        Title        Genre\n",
      "11270  79871   Scum (1979)  Crime|Drama\n",
      "11848  79871   Scum (1979)  Crime|Drama\n",
      "       imdbId                              Title          Genre\n",
      "11271  81494   Return to the 36th Chamber (1980)  Action|Comedy\n",
      "11849  81494   Return to the 36th Chamber (1980)  Action|Comedy\n",
      "       imdbId             Title  Genre\n",
      "11631  82313   Eijanaika (1981)  Drama\n",
      "12209  82313   Eijanaika (1981)  Drama\n",
      "       imdbId                  Title            Genre\n",
      "11509  83296   Visiting Hours (1982)  Horror|Thriller\n",
      "12087  83296   Visiting Hours (1982)  Horror|Thriller\n",
      "       imdbId                   Title          Genre\n",
      "11641  83728   Chan Is Missing (1982)  Drama|Mystery\n",
      "12219  83728   Chan Is Missing (1982)  Drama|Mystery\n",
      "       imdbId                     Title  Genre\n",
      "11788  84465   The Prefab People (1982)  Drama\n",
      "12366  84465   The Prefab People (1982)  Drama\n",
      "       imdbId               Title  Genre\n",
      "11784  84807   Boat People (1982)  Drama\n",
      "12362  84807   Boat People (1982)  Drama\n",
      "       imdbId          Title            Genre\n",
      "11626  85213   Le bal (1983)  History|Musical\n",
      "12204  85213   Le bal (1983)  History|Musical\n",
      "       imdbId             Title   Genre\n",
      "11618  85764   Joysticks (1983)  Comedy\n",
      "12196  85764   Joysticks (1983)  Comedy\n",
      "       imdbId                   Title          Genre\n",
      "11490  86650   ÃÃ nos amours (1983)  Drama|Romance\n",
      "12068  86650   ÃÃ nos amours (1983)  Drama|Romance\n",
      "       imdbId              Title  Genre\n",
      "11593  89537   Mala Noche (1986)  Drama\n",
      "12171  89537   Mala Noche (1986)  Drama\n",
      "       imdbId                 Title                  Genre\n",
      "11797  89847   The Protector (1985)  Action|Crime|Thriller\n",
      "12375  89847   The Protector (1985)  Action|Crime|Thriller\n",
      "       imdbId                    Title         Genre\n",
      "11600  89904   Restless Natives (1985)  Comedy|Crime\n",
      "12178  89904   Restless Natives (1985)  Comedy|Crime\n",
      "       imdbId              Title  Genre\n",
      "11370  90608   All Passion Spent  Drama\n",
      "11948  90608   All Passion Spent  Drama\n",
      "       imdbId                               Title          Genre\n",
      "11786  91406   LiÃÃn liÃÃn fengchÃÂ©n (1986)  Drama|Romance\n",
      "12364  91406   LiÃÃn liÃÃn fengchÃÂ©n (1986)  Drama|Romance\n",
      "       imdbId           Title                    Genre\n",
      "11632  91757   Pirates (1986)  Adventure|Comedy|Family\n",
      "12210  91757   Pirates (1986)  Adventure|Comedy|Family\n",
      "       imdbId                                   Title        Genre\n",
      "11248  92561   ...And the Pursuit of Happiness (1986)  Documentary\n",
      "11826  92561   ...And the Pursuit of Happiness (1986)  Documentary\n",
      "       imdbId                        Title            Genre\n",
      "11764  92963   Yuki yukite, shingun (1987)  Documentary|War\n",
      "12342  92963   Yuki yukite, shingun (1987)  Documentary|War\n",
      "       imdbId            Title                       Genre\n",
      "11274  94238   Valhalla (1986)  Animation|Adventure|Family\n",
      "11852  94238   Valhalla (1986)  Animation|Adventure|Family\n",
      "       imdbId                           Title   Genre\n",
      "11277  94641   Amanece, que no es poco (1989)  Comedy\n",
      "11855  94641   Amanece, que no es poco (1989)  Comedy\n",
      "       imdbId              Title                     Genre\n",
      "11508  94918   Crime Zone (1989)  Action|Adventure|Fantasy\n",
      "12086  94918   Crime Zone (1989)  Action|Adventure|Fantasy\n",
      "       imdbId                              Title         Genre\n",
      "11585  95903   The Prince of Pennsylvania (1988)  Comedy|Drama\n",
      "12163  95903   The Prince of Pennsylvania (1988)  Comedy|Drama\n",
      "       imdbId                    Title                   Genre\n",
      "11466  99753   Heaven and Earth (1990)  Action|Adventure|Drama\n",
      "12044  99753   Heaven and Earth (1990)  Action|Adventure|Drama\n",
      "       imdbId                   Title                Genre\n",
      "11506  99817   I Come in Peace (1990)  Action|Crime|Horror\n",
      "12084  99817   I Come in Peace (1990)  Action|Crime|Horror\n",
      "       imdbId                 Title          Genre\n",
      "11392  101595  Close My Eyes (1991)  Drama|Romance\n",
      "11970  101595  Close My Eyes (1991)  Drama|Romance\n",
      "       imdbId            Title               Genre\n",
      "11410  102789  Ricochet (1991)  Action|Crime|Drama\n",
      "11988  102789  Ricochet (1991)  Action|Crime|Drama\n",
      "       imdbId                  Title                 Genre\n",
      "11347  103805  Beyond the Law (1993)  Crime|Drama|Thriller\n",
      "11925  103805  Beyond the Law (1993)  Crime|Drama|Thriller\n",
      "       imdbId                 Title        Genre\n",
      "11489  106579  Clean, Shaven (1993)  Crime|Drama\n",
      "12067  106579  Clean, Shaven (1993)  Crime|Drama\n",
      "       imdbId           Title  Genre\n",
      "11723  106911  Fiorile (1993)  Drama\n",
      "12301  106911  Fiorile (1993)  Drama\n",
      "       imdbId                                 Title   Genre\n",
      "11588  107953  Return of the Living Dead III (1993)  Horror\n",
      "12166  107953  Return of the Living Dead III (1993)  Horror\n",
      "       imdbId                      Title                  Genre\n",
      "11285  108593  Last Hero in China (1993)  Action|Comedy|History\n",
      "11863  108593  Last Hero in China (1993)  Action|Comedy|History\n",
      "       imdbId                     Title          Genre\n",
      "11319  113264  Harrison Bergeron (1995)  Comedy|Sci-Fi\n",
      "11897  113264  Harrison Bergeron (1995)  Comedy|Sci-Fi\n",
      "       imdbId                           Title                 Genre\n",
      "11425  115950  Cosas que nunca te dije (1996)  Comedy|Drama|Romance\n",
      "12003  115950  Cosas que nunca te dije (1996)  Comedy|Drama|Romance\n",
      "       imdbId              Title                   Genre\n",
      "11803  116118  Doctor Who (1996)  Adventure|Drama|Sci-Fi\n",
      "12381  116118  Doctor Who (1996)  Adventure|Drama|Sci-Fi\n",
      "       imdbId                 Title                  Genre\n",
      "11363  141716  Party Monster (1998)  Documentary|Biography\n",
      "11941  141716  Party Monster (1998)  Documentary|Biography\n",
      "       imdbId         Title                Genre\n",
      "11703  193763  Besat (1999)  Action|Crime|Horror\n",
      "12281  193763  Besat (1999)  Action|Crime|Horror\n",
      "       imdbId                Title                Genre\n",
      "11559  200465  The Bank Job (2008)  Crime|Drama|Romance\n",
      "12137  200465  The Bank Job (2008)  Crime|Drama|Romance\n",
      "       imdbId              Title                 Genre\n",
      "11268  210302  SÃÂ«seiji (1999)  Drama|Fantasy|Horror\n",
      "11846  210302  SÃÂ«seiji (1999)  Drama|Fantasy|Horror\n",
      "       imdbId         Title                   Genre\n",
      "11339  211933  Awake (2007)  Crime|Mystery|Thriller\n",
      "11917  211933  Awake (2007)  Crime|Mystery|Thriller\n",
      "       imdbId                       Title                 Genre\n",
      "11295  219171  Ripley Under Ground (2005)  Crime|Drama|Thriller\n",
      "11873  219171  Ripley Under Ground (2005)  Crime|Drama|Thriller\n",
      "       imdbId              Title               Genre\n",
      "11417  220644  Cheung foh (1999)  Action|Crime|Drama\n",
      "11995  220644  Cheung foh (1999)  Action|Crime|Drama\n",
      "       imdbId                                 Title        Genre\n",
      "11763  233809  Gokushiteki erosu: Renka 1974 (1974)  Documentary\n",
      "12341  233809  Gokushiteki erosu: Renka 1974 (1974)  Documentary\n",
      "       imdbId                 Title                    Genre\n",
      "11553  239441  Gran Paradiso (2000)  Adventure|Drama|Romance\n",
      "12131  239441  Gran Paradiso (2000)  Adventure|Drama|Romance\n",
      "       imdbId                   Title  Genre\n",
      "11427  241663  Lavoura Arcaica (2001)  Drama\n",
      "12005  241663  Lavoura Arcaica (2001)  Drama\n",
      "       imdbId              Title            Genre\n",
      "11611  254252  Dead Awake (2001)  Action|Thriller\n",
      "12189  254252  Dead Awake (2001)  Action|Thriller\n",
      "       imdbId       Title                 Genre\n",
      "11440  259822  .45 (2006)  Crime|Drama|Thriller\n",
      "12018  259822  .45 (2006)  Crime|Drama|Thriller\n",
      "       imdbId                                   Title                   Genre\n",
      "11349  277327  As Far as My Feet Will Carry Me (2001)  Action|Adventure|Drama\n",
      "11927  277327  As Far as My Feet Will Carry Me (2001)  Action|Adventure|Drama\n",
      "       imdbId                       Title          Genre\n",
      "11708  281680  The Bread, My Sweet (2001)  Drama|Romance\n",
      "12286  281680  The Bread, My Sweet (2001)  Drama|Romance\n",
      "       imdbId               Title                  Genre\n",
      "11396  281938  Joe and Max (2002)  Biography|Drama|Sport\n",
      "11974  281938  Joe and Max (2002)  Biography|Drama|Sport\n",
      "       imdbId           Title                  Genre\n",
      "11538  282599  Siworae (2000)  Drama|Fantasy|Romance\n",
      "12116  282599  Siworae (2000)  Drama|Fantasy|Romance\n",
      "       imdbId                              Title                 Genre\n",
      "11315  283337  Ever Since the World Ended (2001)  Drama|Mystery|Sci-Fi\n",
      "11893  283337  Ever Since the World Ended (2001)  Drama|Mystery|Sci-Fi\n",
      "       imdbId                                          Title  \\\n",
      "11324  284363  Obsluhoval jsem anglickÃÂ©ho krÃÃle (2006)   \n",
      "11902  284363  Obsluhoval jsem anglickÃÂ©ho krÃÃle (2006)   \n",
      "\n",
      "                      Genre  \n",
      "11324  Comedy|Drama|Romance  \n",
      "11902  Comedy|Drama|Romance  \n",
      "       imdbId                                      Title                 Genre\n",
      "11292  292963  Before the Devil Knows You're Dead (2007)  Crime|Drama|Thriller\n",
      "11870  292963  Before the Devil Knows You're Dead (2007)  Crime|Drama|Thriller\n",
      "       imdbId                                   Title        Genre\n",
      "11344  296881  Symbiopsychotaxiplasm: Take One (1968)  Documentary\n",
      "11922  296881  Symbiopsychotaxiplasm: Take One (1968)  Documentary\n",
      "       imdbId                 Title  Genre\n",
      "11793  312886  July Rhapsody (2002)  Drama\n",
      "12371  312886  July Rhapsody (2002)  Drama\n",
      "       imdbId                      Title                  Genre\n",
      "11251  316599  Graveyard of Honor (2002)  Action|Crime|Thriller\n",
      "11829  316599  Graveyard of Honor (2002)  Action|Crime|Thriller\n",
      "       imdbId                                  Title                    Genre\n",
      "11495  318590  Cazuza: O Tempo NÃÂ£o PÃÃra (2004)  Biography|Music|Romance\n",
      "12073  318590  Cazuza: O Tempo NÃÂ£o PÃÃra (2004)  Biography|Music|Romance\n",
      "       imdbId                         Title           Genre\n",
      "11494  322298  The Bottom of the Sea (2003)  Drama|Thriller\n",
      "12072  322298  The Bottom of the Sea (2003)  Drama|Thriller\n",
      "       imdbId                        Title                 Genre\n",
      "11426  339489  Palabras encadenadas (2003)  Crime|Drama|Thriller\n",
      "12004  339489  Palabras encadenadas (2003)  Crime|Drama|Thriller\n",
      "       imdbId                 Title            Genre\n",
      "11449  345461  The Detonator (2006)  Action|Thriller\n",
      "12027  345461  The Detonator (2006)  Action|Thriller\n",
      "       imdbId               Title  Genre\n",
      "11665  348853  Nathalie... (2003)  Drama\n",
      "12243  348853  Nathalie... (2003)  Drama\n",
      "       imdbId              Title                 Genre\n",
      "11250  355611  Jonny Vang (2003)  Comedy|Drama|Mystery\n",
      "11828  355611  Jonny Vang (2003)  Comedy|Drama|Mystery\n",
      "       imdbId                                                Title  \\\n",
      "11252  356201  Wood & Stock: Sexo, OrÃÂ©gano e Rock'n'Roll (2006)   \n",
      "11830  356201  Wood & Stock: Sexo, OrÃÂ©gano e Rock'n'Roll (2006)   \n",
      "\n",
      "                  Genre  \n",
      "11252  Animation|Comedy  \n",
      "11830  Animation|Comedy  \n",
      "       imdbId                Title  Genre\n",
      "11445  356453  Cama adentro (2004)  Drama\n",
      "12023  356453  Cama adentro (2004)  Drama\n",
      "       imdbId          Title                 Genre\n",
      "11287  357585  Decoys (2004)  Comedy|Horror|Sci-Fi\n",
      "11865  357585  Decoys (2004)  Comedy|Horror|Sci-Fi\n",
      "       imdbId               Title                 Genre\n",
      "11238  360323  10th & Wolf (2006)  Crime|Drama|Thriller\n",
      "11816  360323  10th & Wolf (2006)  Crime|Drama|Thriller\n",
      "       imdbId         Title           Genre\n",
      "11362  362538  Noise (2004)  Thriller|Drama\n",
      "11940  362538  Noise (2004)  Thriller|Drama\n",
      "       imdbId                                                      Title  \\\n",
      "11738  367882  Indiana Jones and the Kingdom of the Crystal Skull (2008)   \n",
      "12316  367882  Indiana Jones and the Kingdom of the Crystal Skull (2008)   \n",
      "\n",
      "                          Genre  \n",
      "11738  Action|Adventure|Fantasy  \n",
      "12316  Action|Adventure|Fantasy  \n",
      "       imdbId                  Title                  Genre\n",
      "11346  368794  I'm Not There. (2007)  Biography|Drama|Music\n",
      "11924  368794  I'm Not There. (2007)  Biography|Drama|Music\n",
      "       imdbId            Title                    Genre\n",
      "11702  371746  Iron Man (2008)  Action|Adventure|Sci-Fi\n",
      "12280  371746  Iron Man (2008)  Action|Adventure|Sci-Fi\n",
      "       imdbId                      Title                 Genre\n",
      "11436  372873  Dragon Wars: D-War (2007)  Action|Drama|Fantasy\n",
      "12014  372873  Dragon Wars: D-War (2007)  Action|Drama|Fantasy\n",
      "       imdbId                Title                 Genre\n",
      "11629  379865  Leatherheads (2008)  Comedy|Drama|Romance\n",
      "12207  379865  Leatherheads (2008)  Comedy|Drama|Romance\n",
      "       imdbId                Title  Genre\n",
      "11756  379976  Savage Grace (2007)  Drama\n",
      "12334  379976  Savage Grace (2007)  Drama\n",
      "       imdbId              Title          Genre\n",
      "11361  381392  Ma mÃÂ¬re (2004)  Drama|Romance\n",
      "11939  381392  Ma mÃÂ¬re (2004)  Drama|Romance\n",
      "       imdbId              Title                  Genre\n",
      "11613  381668  Sud pralad (2004)  Drama|Fantasy|Romance\n",
      "12191  381668  Sud pralad (2004)  Drama|Fantasy|Romance\n",
      "       imdbId            Title                   Genre\n",
      "11467  385586  Cat Soup (2001)  Animation|Short|Comedy\n",
      "12045  385586  Cat Soup (2001)  Animation|Short|Comedy\n",
      "       imdbId                      Title                     Genre\n",
      "11340  385752  The Golden Compass (2007)  Adventure|Family|Fantasy\n",
      "11918  385752  The Golden Compass (2007)  Adventure|Family|Fantasy\n",
      "       imdbId                  Title                     Genre\n",
      "11575  386820  Terkel i knibe (2004)  Animation|Comedy|Musical\n",
      "12153  386820  Terkel i knibe (2004)  Animation|Comedy|Musical\n",
      "       imdbId                 Title        Genre\n",
      "11743  387682  Wesley Willis (2003)  Documentary\n",
      "12321  387682  Wesley Willis (2003)  Documentary\n",
      "       imdbId                      Title         Genre\n",
      "11282  388182  King of California (2007)  Comedy|Drama\n",
      "11860  388182  King of California (2007)  Comedy|Drama\n",
      "       imdbId            Title          Genre\n",
      "11633  388556  Zebraman (2004)  Comedy|Sci-Fi\n",
      "12211  388556  Zebraman (2004)  Comedy|Sci-Fi\n",
      "       imdbId               Title  Genre\n",
      "11594  389235  On the Outs (2004)  Drama\n",
      "12172  389235  On the Outs (2004)  Drama\n",
      "       imdbId             Title                       Genre\n",
      "11290  389790  Bee Movie (2007)  Animation|Adventure|Comedy\n",
      "11868  389790  Bee Movie (2007)  Animation|Adventure|Comedy\n",
      "       imdbId                                     Title           Genre\n",
      "11260  391229  I Want Someone to Eat Cheese With (2006)  Comedy|Romance\n",
      "11838  391229  I Want Someone to Eat Cheese With (2006)  Comedy|Romance\n",
      "       imdbId             Title                    Genre\n",
      "11617  395119  Alatriste (2006)  Adventure|Drama|History\n",
      "12195  395119  Alatriste (2006)  Adventure|Drama|History\n",
      "       imdbId                                              Title        Genre\n",
      "11532  395421  The 10th Judicial Court: Judicial Hearings (2004)  Documentary\n",
      "12110  395421  The 10th Judicial Court: Judicial Hearings (2004)  Documentary\n",
      "       imdbId                    Title           Genre\n",
      "11364  396190  Return to Sender (2004)  Drama|Thriller\n",
      "11942  396190  Return to Sender (2004)  Drama|Thriller\n",
      "       imdbId              Title             Genre\n",
      "11578  398237  NyÃ_cker! (2004)  Animation|Comedy\n",
      "12156  398237  NyÃ_cker! (2004)  Animation|Comedy\n",
      "       imdbId         Title                 Genre\n",
      "11450  399095  Trade (2007)  Crime|Drama|Thriller\n",
      "12028  399095  Trade (2007)  Crime|Drama|Thriller\n",
      "       imdbId                                     Title            Genre\n",
      "11293  401383  The Diving Bell and the Butterfly (2007)  Biography|Drama\n",
      "11871  401383  The Diving Bell and the Butterfly (2007)  Biography|Drama\n",
      "       imdbId                   Title                  Genre\n",
      "11314  405336  Southland Tales (2006)  Comedy|Mystery|Sci-Fi\n",
      "11892  405336  Southland Tales (2006)  Comedy|Mystery|Sci-Fi\n",
      "       imdbId           Title           Genre\n",
      "11477  406759  The Eye (2008)  Horror|Mystery\n",
      "12055  406759  The Eye (2008)  Horror|Mystery\n",
      "       imdbId                                                  Title  \\\n",
      "11398  408236  Sweeney Todd: The Demon Barber of Fleet Street (2007)   \n",
      "11976  408236  Sweeney Todd: The Demon Barber of Fleet Street (2007)   \n",
      "\n",
      "                      Genre  \n",
      "11398  Drama|Horror|Musical  \n",
      "11976  Drama|Horror|Musical  \n",
      "       imdbId                Title                    Genre\n",
      "11650  410377  Nim's Island (2008)  Adventure|Comedy|Family\n",
      "12228  410377  Nim's Island (2008)  Adventure|Comedy|Family\n",
      "       imdbId                                Title   Genre\n",
      "11360  411269  Day of the Dead 2: Contagium (2005)  Horror\n",
      "11938  411269  Day of the Dead 2: Contagium (2005)  Horror\n",
      "       imdbId                               Title                     Genre\n",
      "11483  411477  Hellboy II: The Golden Army (2008)  Action|Adventure|Fantasy\n",
      "12061  411477  Hellboy II: The Golden Army (2008)  Action|Adventure|Fantasy\n",
      "       imdbId             Title                 Genre\n",
      "11696  412637  Delirious (2006)  Comedy|Drama|Romance\n",
      "12274  412637  Delirious (2006)  Comedy|Drama|Romance\n",
      "       imdbId                     Title  Genre\n",
      "11625  412808  The Hawk Is Dying (2006)  Drama\n",
      "12203  412808  The Hawk Is Dying (2006)  Drama\n",
      "       imdbId        Title           Genre\n",
      "11359  413879  Cake (2005)  Comedy|Romance\n",
      "11937  413879  Cake (2005)  Comedy|Romance\n",
      "       imdbId                  Title         Genre\n",
      "11732  415489  American Crude (2008)  Comedy|Drama\n",
      "12310  415489  American Crude (2008)  Comedy|Drama\n",
      "       imdbId                 Title                Genre\n",
      "11283  415965  Martian Child (2007)  Comedy|Drama|Family\n",
      "11861  415965  Martian Child (2007)  Comedy|Drama|Family\n",
      "       imdbId                                    Title  \\\n",
      "11563  416044  Mongol: The Rise of Genghis Khan (2007)   \n",
      "12141  416044  Mongol: The Rise of Genghis Khan (2007)   \n",
      "\n",
      "                           Genre  \n",
      "11563  Adventure|Biography|Drama  \n",
      "12141  Adventure|Biography|Drama  \n",
      "       imdbId                             Title                     Genre\n",
      "11534  416236  The Spiderwick Chronicles (2008)  Adventure|Family|Fantasy\n",
      "12112  416236  The Spiderwick Chronicles (2008)  Adventure|Family|Fantasy\n",
      "       imdbId               Title  Genre\n",
      "11637  416675  Dark Matter (2007)  Drama\n",
      "12215  416675  Dark Matter (2007)  Drama\n",
      "       imdbId                Title   Genre\n",
      "11407  417056  Pledge This! (2006)  Comedy\n",
      "11985  417056  Pledge This! (2006)  Comedy\n",
      "       imdbId         Title            Genre\n",
      "11697  417871  Klimt (2006)  Biography|Drama\n",
      "12275  417871  Klimt (2006)  Biography|Drama\n",
      "       imdbId               Title            Genre\n",
      "11619  419160  Spirit Trap (2005)  Horror|Thriller\n",
      "12197  419160  Spirit Trap (2005)  Horror|Thriller\n",
      "       imdbId           Title          Genre\n",
      "11691  419449  Antares (2004)  Drama|Romance\n",
      "12269  419449  Antares (2004)  Drama|Romance\n",
      "       imdbId                     Title                 Genre\n",
      "11595  419766  GarÃÂ¤on stupide (2004)  Comedy|Drama|Romance\n",
      "12173  419766  GarÃÂ¤on stupide (2004)  Comedy|Drama|Romance\n",
      "       imdbId                   Title  Genre\n",
      "11380  419887  The Kite Runner (2007)  Drama\n",
      "11958  419887  The Kite Runner (2007)  Drama\n",
      "       imdbId                           Title           Genre\n",
      "11584  420740  A Little Trip to Heaven (2005)  Drama|Thriller\n",
      "12162  420740  A Little Trip to Heaven (2005)  Drama|Thriller\n",
      "       imdbId                Title               Genre\n",
      "11657  421073  Street Kings (2008)  Action|Crime|Drama\n",
      "12235  421073  Street Kings (2008)  Action|Crime|Drama\n",
      "       imdbId           Title                  Genre\n",
      "11246  421082  Control (2007)  Biography|Drama|Music\n",
      "11824  421082  Control (2007)  Biography|Drama|Music\n",
      "       imdbId           Title          Genre\n",
      "11453  422401  Hatchet (2006)  Comedy|Horror\n",
      "12031  422401  Hatchet (2006)  Comedy|Horror\n",
      "       imdbId                  Title               Genre\n",
      "11442  423382  Tjenare kungen (2005)  Comedy|Drama|Music\n",
      "12020  423382  Tjenare kungen (2005)  Comedy|Drama|Music\n",
      "       imdbId                                                    Title  \\\n",
      "11433  424287  The Mostly Unfabulous Social Life of Ethan Green (2005)   \n",
      "12011  424287  The Mostly Unfabulous Social Life of Ethan Green (2005)   \n",
      "\n",
      "                Genre  \n",
      "11433  Comedy|Romance  \n",
      "12011  Comedy|Romance  \n",
      "       imdbId                                       Title          Genre\n",
      "11544  424430  Sekai no chÃÃshin de, ai o sakebu (2004)  Drama|Romance\n",
      "12122  424430  Sekai no chÃÃshin de, ai o sakebu (2004)  Drama|Romance\n",
      "       imdbId                 Title                  Genre\n",
      "11783  424600  The Andromeda Strain  Drama|Sci-Fi|Thriller\n",
      "12361  424600  The Andromeda Strain  Drama|Sci-Fi|Thriller\n",
      "       imdbId           Title                 Genre\n",
      "11383  424789  Allegro (2005)  Drama|Romance|Sci-Fi\n",
      "11961  424789  Allegro (2005)  Drama|Romance|Sci-Fi\n",
      "       imdbId                Title        Genre\n",
      "11323  425094  Heavens Fall (2006)  Crime|Drama\n",
      "11901  425094  Heavens Fall (2006)  Crime|Drama\n",
      "       imdbId        Title           Genre\n",
      "11374  425236  Mary (2005)  Drama|Thriller\n",
      "11952  425236  Mary (2005)  Drama|Thriller\n",
      "       imdbId              Title                 Genre\n",
      "11692  425326  Outsourced (2006)  Comedy|Drama|Romance\n",
      "12270  425326  Outsourced (2006)  Comedy|Drama|Romance\n",
      "       imdbId                      Title   Genre\n",
      "11230  425395  Relative Strangers (2006)  Comedy\n",
      "11808  425395  Relative Strangers (2006)  Comedy\n",
      "       imdbId                    Title                 Genre\n",
      "11543  425413  Run, Fatboy, Run (2007)  Comedy|Romance|Sport\n",
      "12121  425413  Run, Fatboy, Run (2007)  Comedy|Romance|Sport\n",
      "       imdbId                   Title                 Genre\n",
      "11656  426592  Superhero Movie (2008)  Action|Comedy|Sci-Fi\n",
      "12234  426592  Superhero Movie (2008)  Action|Comedy|Sci-Fi\n",
      "       imdbId               Title        Genre\n",
      "11301  426931  August Rush (2007)  Drama|Music\n",
      "11879  426931  August Rush (2007)  Drama|Music\n",
      "       imdbId                      Title                    Genre\n",
      "11412  427309  The Great Debaters (2007)  Biography|Drama|Romance\n",
      "11990  427309  The Great Debaters (2007)  Biography|Drama|Romance\n",
      "       imdbId              Title               Genre\n",
      "11549  427582  The Method (2005)  Comedy|Crime|Drama\n",
      "12127  427582  The Method (2005)  Comedy|Crime|Drama\n",
      "       imdbId             Title   Genre\n",
      "11753  427998  The Grand (2007)  Comedy\n",
      "12331  427998  The Grand (2007)  Comedy\n",
      "       imdbId                                     Title            Genre\n",
      "11286  428212  All Souls Day: Dia de los Muertos (2005)  Horror|Thriller\n",
      "11864  428212  All Souls Day: Dia de los Muertos (2005)  Horror|Thriller\n",
      "       imdbId                   Title          Genre\n",
      "11418  431308  P.S. I Love You (2007)  Drama|Romance\n",
      "11996  431308  P.S. I Love You (2007)  Drama|Romance\n",
      "       imdbId                         Title  Genre\n",
      "11375  433398  Journey from the Fall (2006)  Drama\n",
      "11953  433398  Journey from the Fall (2006)  Drama\n",
      "       imdbId                            Title   Genre\n",
      "11746  435706  Nina's Heavenly Delights (2006)  Comedy\n",
      "12324  435706  Nina's Heavenly Delights (2006)  Comedy\n",
      "       imdbId             Title         Genre\n",
      "11520  436607  The Motel (2005)  Comedy|Drama\n",
      "12098  436607  The Motel (2005)  Comedy|Drama\n",
      "       imdbId                     Title          Genre\n",
      "11701  436889  Die weisse Massai (2005)  Drama|Romance\n",
      "12279  436889  Die weisse Massai (2005)  Drama|Romance\n",
      "       imdbId                    Title                     Genre\n",
      "11673  437954  Virgin Territory (2007)  Adventure|Comedy|History\n",
      "12251  437954  Virgin Territory (2007)  Adventure|Comedy|History\n",
      "       imdbId                        Title                    Genre\n",
      "11355  438859  The Color of Freedom (2007)  Biography|Drama|History\n",
      "11933  438859  The Color of Freedom (2007)  Biography|Drama|History\n",
      "       imdbId                 Title                       Genre\n",
      "11300  439123  Azur et Asmar (2006)  Animation|Adventure|Family\n",
      "11878  439123  Azur et Asmar (2006)  Animation|Adventure|Family\n",
      "       imdbId           Title        Genre\n",
      "11385  439511  Commune (2005)  Documentary\n",
      "11963  439511  Commune (2005)  Documentary\n",
      "       imdbId  \\\n",
      "11429  439547   \n",
      "12007  439547   \n",
      "\n",
      "                                                                            Title  \\\n",
      "11429  2 Filhos de Francisco: A HistÃ_ria de ZezÃÂ© di Camargo & Luciano (2005)   \n",
      "12007  2 Filhos de Francisco: A HistÃ_ria de ZezÃÂ© di Camargo & Luciano (2005)   \n",
      "\n",
      "                         Genre  \n",
      "11429  Biography|Drama|History  \n",
      "12007  Biography|Drama|History  \n",
      "       imdbId              Title                   Genre\n",
      "11480  440846  Fallen Art (2004)  Comedy|Animation|Short\n",
      "12058  440846  Fallen Art (2004)  Comedy|Animation|Short\n",
      "       imdbId                 Title                       Genre\n",
      "11761  441773  Kung Fu Panda (2008)  Animation|Action|Adventure\n",
      "12339  441773  Kung Fu Panda (2008)  Animation|Action|Adventure\n",
      "       imdbId           Title                       Genre\n",
      "11311  442933  Beowulf (2007)  Animation|Action|Adventure\n",
      "11889  442933  Beowulf (2007)  Animation|Action|Adventure\n",
      "       imdbId                 Title                Genre\n",
      "11533  443274  Vantage Point (2008)  Crime|Drama|Mystery\n",
      "12111  443274  Vantage Point (2008)  Crime|Drama|Mystery\n",
      "       imdbId              Title   Genre\n",
      "11603  443450  Black Dawn (2005)  Action\n",
      "12181  443450  Black Dawn (2005)  Action\n",
      "       imdbId                 Title                  Genre\n",
      "11391  443527  The Hamiltons (2006)  Drama|Horror|Thriller\n",
      "11969  443527  The Hamiltons (2006)  Drama|Horror|Thriller\n",
      "       imdbId             Title                   Genre\n",
      "11558  443649  10,000 BC (2008)  Action|Adventure|Drama\n",
      "12136  443649  10,000 BC (2008)  Action|Adventure|Drama\n",
      "       imdbId  \\\n",
      "11234  443680   \n",
      "11812  443680   \n",
      "\n",
      "                                                                   Title  \\\n",
      "11234  The Assassination of Jesse James by the Coward Robert Ford (2007)   \n",
      "11812  The Assassination of Jesse James by the Coward Robert Ford (2007)   \n",
      "\n",
      "                       Genre  \n",
      "11234  Biography|Crime|Drama  \n",
      "11812  Biography|Crime|Drama  \n",
      "       imdbId                           Title          Genre\n",
      "11382  443844  Les amants rÃÂ©guliers (2005)  Drama|Romance\n",
      "11960  443844  Les amants rÃÂ©guliers (2005)  Drama|Romance\n",
      "       imdbId              Title                   Genre\n",
      "11291  444778  Mah nakorn (2004)  Comedy|Fantasy|Romance\n",
      "11869  444778  Mah nakorn (2004)  Comedy|Fantasy|Romance\n",
      "       imdbId                   Title               Genre\n",
      "11305  445336  You, the Living (2007)  Comedy|Drama|Music\n",
      "11883  445336  You, the Living (2007)  Comedy|Drama|Music\n",
      "       imdbId              Title           Genre\n",
      "11240  446298  Civic Duty (2006)  Drama|Thriller\n",
      "11818  446298  Civic Duty (2006)  Drama|Thriller\n",
      "       imdbId              Title         Genre\n",
      "11272  446752  Full of It (2007)  Drama|Comedy\n",
      "11850  446752  Full of It (2007)  Drama|Comedy\n",
      "       imdbId                     Title              Genre\n",
      "11394  448154  Tirante el Blanco (2006)  Adventure|Romance\n",
      "11972  448154  Tirante el Blanco (2006)  Adventure|Romance\n",
      "       imdbId                    Title        Genre\n",
      "11244  449018  The Final Season (2007)  Drama|Sport\n",
      "11822  449018  The Final Season (2007)  Drama|Sport\n",
      "       imdbId                Title                       Genre\n",
      "11536  449994  Jodhaa Akbar (2008)  Action|Adventure|Biography\n",
      "12114  449994  Jodhaa Akbar (2008)  Action|Adventure|Biography\n",
      "       imdbId                  Title                 Genre\n",
      "11408  450972  As You Like It (2006)  Drama|Comedy|Romance\n",
      "11986  450972  As You Like It (2006)  Drama|Comedy|Romance\n",
      "       imdbId                       Title                       Genre\n",
      "11561  451079  Horton Hears a Who! (2008)  Animation|Adventure|Comedy\n",
      "12139  451079  Horton Hears a Who! (2008)  Animation|Adventure|Comedy\n",
      "       imdbId               Title          Genre\n",
      "11590  453548  Snow Angels (2007)  Drama|Romance\n",
      "12168  453548  Snow Angels (2007)  Drama|Romance\n",
      "       imdbId             Title                 Genre\n",
      "11640  454065  La antena (2007)  Drama|Fantasy|Sci-Fi\n",
      "12218  454065  La antena (2007)  Drama|Fantasy|Sci-Fi\n",
      "       imdbId                Title           Genre\n",
      "11715  454084  Blind Dating (2006)  Comedy|Romance\n",
      "12293  454084  Blind Dating (2006)  Comedy|Romance\n",
      "       imdbId               Title          Genre\n",
      "11249  454457  Frostbitten (2006)  Horror|Comedy\n",
      "11827  454457  Frostbitten (2006)  Horror|Comedy\n",
      "       imdbId                   Title                    Genre\n",
      "11256  454864  The Last Winter (2006)  Horror|Mystery|Thriller\n",
      "11834  454864  The Last Winter (2006)  Horror|Mystery|Thriller\n",
      "       imdbId                     Title                 Genre\n",
      "11580  455805  Then She Found Me (2007)  Comedy|Drama|Romance\n",
      "12158  455805  Then She Found Me (2007)  Comedy|Drama|Romance\n",
      "       imdbId                        Title  Genre\n",
      "11446  456041  Anche libero va bene (2006)  Drama\n",
      "12024  456041  Anche libero va bene (2006)  Drama\n",
      "       imdbId                Title           Genre\n",
      "11387  456121  Densha otoko (2005)  Comedy|Romance\n",
      "11965  456121  Densha otoko (2005)  Comedy|Romance\n",
      "       imdbId                Title                      Genre\n",
      "11552  457090  The Marksman (2005)  Action|Adventure|Thriller\n",
      "12130  457090  The Marksman (2005)  Action|Adventure|Thriller\n",
      "       imdbId                                  Title                  Genre\n",
      "11312  457419  Mr. Magorium's Wonder Emporium (2007)  Comedy|Family|Fantasy\n",
      "11890  457419  Mr. Magorium's Wonder Emporium (2007)  Comedy|Family|Fantasy\n",
      "       imdbId                    Title                 Genre\n",
      "11397  460721  The Big Bad Swim (2006)  Comedy|Romance|Sport\n",
      "11975  460721  The Big Bad Swim (2006)  Comedy|Romance|Sport\n",
      "       imdbId                Title                 Genre\n",
      "11800  460745  Chaos Theory (2008)  Comedy|Drama|Romance\n",
      "12378  460745  Chaos Theory (2008)  Comedy|Drama|Romance\n",
      "       imdbId              Title                      Genre\n",
      "11517  460766  Deep Water (2006)  Documentary|History|Sport\n",
      "12095  460766  Deep Water (2006)  Documentary|History|Sport\n",
      "       imdbId                                                 Title  \\\n",
      "11443  460780  In the Name of the King: A Dungeon Siege Tale (2007)   \n",
      "12021  460780  In the Name of the King: A Dungeon Siege Tale (2007)   \n",
      "\n",
      "                          Genre  \n",
      "11443  Action|Adventure|Fantasy  \n",
      "12021  Action|Adventure|Fantasy  \n",
      "       imdbId            Title                   Genre\n",
      "11712  460791  The Fall (2006)  Adventure|Comedy|Drama\n",
      "12290  460791  The Fall (2006)  Adventure|Comedy|Drama\n",
      "       imdbId             Title                    Genre\n",
      "11334  461770  Enchanted (2007)  Animation|Comedy|Family\n",
      "11912  461770  Enchanted (2007)  Animation|Comedy|Family\n",
      "       imdbId                       Title         Genre\n",
      "11413  461804  Mongolian Ping Pong (2005)  Comedy|Drama\n",
      "11991  461804  Mongolian Ping Pong (2005)  Comedy|Drama\n",
      "       imdbId                      Title            Genre\n",
      "11572  462023  Romulus, My Father (2007)  Biography|Drama\n",
      "12150  462023  Romulus, My Father (2007)  Biography|Drama\n",
      "       imdbId       Title         Genre\n",
      "11437  462392  LOL (2006)  Comedy|Drama\n",
      "12015  462392  LOL (2006)  Comedy|Drama\n",
      "       imdbId                                 Title                  Genre\n",
      "11624  462477  Pierrepoint: The Last Hangman (2005)  Biography|Crime|Drama\n",
      "12202  462477  Pierrepoint: The Last Hangman (2005)  Biography|Crime|Drama\n",
      "       imdbId         Title                Genre\n",
      "11474  462499  Rambo (2008)  Action|Thriller|War\n",
      "12052  462499  Rambo (2008)  Action|Thriller|War\n",
      "       imdbId                 Title                 Genre\n",
      "11371  462579  The Treatment (2006)  Comedy|Drama|Romance\n",
      "11949  462579  The Treatment (2006)  Comedy|Drama|Romance\n",
      "       imdbId           Title           Genre\n",
      "11556  463027  Descent (2007)  Drama|Thriller\n",
      "12134  463027  Descent (2007)  Drama|Thriller\n",
      "       imdbId             Title                  Genre\n",
      "11432  463850  10.5: Apocalypse  Drama|Sci-Fi|Thriller\n",
      "12010  463850  10.5: Apocalypse  Drama|Sci-Fi|Thriller\n",
      "       imdbId                 Title                 Genre\n",
      "11242  464061  I'm Reed Fish (2006)  Comedy|Drama|Romance\n",
      "11820  464061  I'm Reed Fish (2006)  Comedy|Drama|Romance\n",
      "       imdbId                 Title                   Genre\n",
      "11352  464141  The Orphanage (2007)  Drama|Mystery|Thriller\n",
      "11930  464141  The Orphanage (2007)  Drama|Mystery|Thriller\n",
      "       imdbId                                          Title   Genre\n",
      "11801  464907  The Boys & Girls Guide to Getting Down (2006)  Comedy\n",
      "12379  464907  The Boys & Girls Guide to Getting Down (2006)  Comedy\n",
      "       imdbId                      Title        Genre\n",
      "11643  464955  FehÃÂ©r tenyÃÂ©r (2006)  Drama|Sport\n",
      "12221  464955  FehÃÂ©r tenyÃÂ©r (2006)  Drama|Sport\n",
      "       imdbId                                      Title  \\\n",
      "11399  465234  National Treasure: Book of Secrets (2007)   \n",
      "11977  465234  National Treasure: Book of Secrets (2007)   \n",
      "\n",
      "                         Genre  \n",
      "11399  Action|Adventure|Family  \n",
      "11977  Action|Adventure|Family  \n",
      "       imdbId          Title               Genre\n",
      "11335  465494  Hitman (2007)  Action|Crime|Drama\n",
      "11913  465494  Hitman (2007)  Action|Crime|Drama\n",
      "       imdbId                 Title                    Genre\n",
      "11231  466664  Alien Autopsy (2006)  Biography|Comedy|Sci-Fi\n",
      "11809  466664  Alien Autopsy (2006)  Biography|Comedy|Sci-Fi\n",
      "       imdbId                    Title   Genre\n",
      "11671  466771  Puff, Puff, Pass (2006)  Comedy\n",
      "12249  466771  Puff, Puff, Pass (2006)  Comedy\n",
      "       imdbId              Title                  Genre\n",
      "11568  466816  Hallam Foe (2007)  Drama|Mystery|Romance\n",
      "12146  466816  Hallam Foe (2007)  Drama|Mystery|Romance\n",
      "       imdbId        Title         Genre\n",
      "11354  467406  Juno (2007)  Comedy|Drama\n",
      "11932  467406  Juno (2007)  Comedy|Drama\n",
      "       imdbId                   Title        Genre\n",
      "11602  468442  51 Birch Street (2005)  Documentary\n",
      "12180  468442  51 Birch Street (2005)  Documentary\n",
      "       imdbId                   Title               Genre\n",
      "11597  468569  The Dark Knight (2008)  Action|Crime|Drama\n",
      "12175  468569  The Dark Knight (2008)  Action|Crime|Drama\n",
      "       imdbId                       Title         Genre\n",
      "11511  468820  Noriko no shokutaku (2005)  Drama|Horror\n",
      "12089  468820  Noriko no shokutaku (2005)  Drama|Horror\n",
      "       imdbId                                  Title         Genre\n",
      "11740  469099  Hey Hey It's Esther Blueburger (2008)  Comedy|Drama\n",
      "12318  469099  Hey Hey It's Esther Blueburger (2008)  Comedy|Drama\n",
      "       imdbId                       Title          Genre\n",
      "11401  469494  There Will Be Blood (2007)  Drama|History\n",
      "11979  469494  There Will Be Blood (2007)  Drama|History\n",
      "       imdbId                     Title                   Genre\n",
      "11679  470732  Bernard and Doris (2006)  Biography|Comedy|Drama\n",
      "12257  470732  Bernard and Doris (2006)  Biography|Comedy|Drama\n",
      "       imdbId                                Title                     Genre\n",
      "11343  471711  Futurama: Bender's Big Score (2007)  Animation|Comedy|Romance\n",
      "11921  471711  Futurama: Bender's Big Score (2007)  Animation|Comedy|Romance\n",
      "       imdbId                        Title                   Genre\n",
      "11403  472062  Charlie Wilson's War (2007)  Biography|Comedy|Drama\n",
      "11981  472062  Charlie Wilson's War (2007)  Biography|Comedy|Drama\n",
      "       imdbId            Title                   Genre\n",
      "11569  472160  Penelope (2006)  Comedy|Fantasy|Romance\n",
      "12147  472160  Penelope (2006)  Comedy|Fantasy|Romance\n",
      "       imdbId               Title                Genre\n",
      "11627  473074  The Gymnast (2006)  Drama|Romance|Sport\n",
      "12205  473074  The Gymnast (2006)  Drama|Romance|Sport\n",
      "       imdbId             Title                Genre\n",
      "11393  473356  The Flock (2007)  Crime|Drama|Mystery\n",
      "11971  473356  The Flock (2007)  Crime|Drama|Mystery\n",
      "       imdbId          Title          Genre\n",
      "11621  475241  Khadak (2006)  Drama|Romance\n",
      "12199  475241  Khadak (2006)  Drama|Romance\n",
      "       imdbId                 Title         Genre\n",
      "11706  475984  Mister Lonely (2007)  Comedy|Drama\n",
      "12284  475984  Mister Lonely (2007)  Comedy|Drama\n",
      "       imdbId                                                          Title  \\\n",
      "11566  475998  The Pirates Who Don't Do Anything: A VeggieTales Movie (2008)   \n",
      "12144  475998  The Pirates Who Don't Do Anything: A VeggieTales Movie (2008)   \n",
      "\n",
      "                            Genre  \n",
      "11566  Animation|Adventure|Comedy  \n",
      "12144  Animation|Adventure|Comedy  \n",
      "       imdbId                              Title                 Genre\n",
      "11395  477139  Wristcutters: A Love Story (2006)  Comedy|Drama|Fantasy\n",
      "11973  477139  Wristcutters: A Love Story (2006)  Comedy|Drama|Fantasy\n",
      "       imdbId                          Title                 Genre\n",
      "11294  477348  No Country for Old Men (2007)  Crime|Drama|Thriller\n",
      "11872  477348  No Country for Old Men (2007)  Crime|Drama|Thriller\n",
      "       imdbId             Title         Genre\n",
      "11699  477916  Viva Cuba (2005)  Comedy|Drama\n",
      "12277  477916  Viva Cuba (2005)  Comedy|Drama\n",
      "       imdbId      Title                 Genre\n",
      "11622  478087  21 (2008)  Crime|Drama|Thriller\n",
      "12200  478087  21 (2008)  Crime|Drama|Thriller\n",
      "       imdbId                     Title        Genre\n",
      "11727  478090  A/k/a Tommy Chong (2006)  Documentary\n",
      "12305  478090  A/k/a Tommy Chong (2006)  Documentary\n",
      "       imdbId                  Title  Genre\n",
      "11642  478999  Karov La Bayit (2005)  Drama\n",
      "12220  478999  Karov La Bayit (2005)  Drama\n",
      "       imdbId                 Title         Genre\n",
      "11390  479289  The Go-Getter (2007)  Comedy|Drama\n",
      "11968  479289  The Go-Getter (2007)  Comedy|Drama\n",
      "       imdbId                  Title        Genre\n",
      "11747  479916  Following Sean (2005)  Documentary\n",
      "12325  479916  Following Sean (2005)  Documentary\n",
      "       imdbId                   Title           Genre\n",
      "11471  479968  One Missed Call (2008)  Horror|Mystery\n",
      "12049  479968  One Missed Call (2008)  Horror|Mystery\n",
      "       imdbId                          Title  Genre\n",
      "11457  480001  The Sensation of Sight (2006)  Drama\n",
      "12035  480001  The Sensation of Sight (2006)  Drama\n",
      "       imdbId           Title     Genre\n",
      "11232  480011  Closure (2007)  Thriller\n",
      "11810  480011  Closure (2007)  Thriller\n",
      "       imdbId               Title                Genre\n",
      "11341  480249  I Am Legend (2007)  Drama|Horror|Sci-Fi\n",
      "11919  480249  I Am Legend (2007)  Drama|Horror|Sci-Fi\n",
      "       imdbId              Title           Genre\n",
      "11485  480251  Ira & Abby (2006)  Comedy|Romance\n",
      "12063  480251  Ira & Abby (2006)  Comedy|Romance\n",
      "       imdbId                                             Title  \\\n",
      "11659  481536  Harold & Kumar Escape from Guantanamo Bay (2008)   \n",
      "12237  481536  Harold & Kumar Escape from Guantanamo Bay (2008)   \n",
      "\n",
      "                  Genre  \n",
      "11659  Adventure|Comedy  \n",
      "12237  Adventure|Comedy  \n",
      "       imdbId         Title          Genre\n",
      "11722  482463  Bella (2006)  Drama|Romance\n",
      "12300  482463  Bella (2006)  Drama|Romance\n",
      "       imdbId           Title                    Genre\n",
      "11752  482599  Shutter (2008)  Horror|Mystery|Thriller\n",
      "12330  482599  Shutter (2008)  Horror|Mystery|Thriller\n",
      "       imdbId                 Title                    Genre\n",
      "11755  482606  The Strangers (2008)  Horror|Mystery|Thriller\n",
      "12333  482606  The Strangers (2008)  Horror|Mystery|Thriller\n",
      "       imdbId                       Title         Genre\n",
      "11648  482901  El baÃÂ±o del Papa (2007)  Comedy|Drama\n",
      "12226  482901  El baÃÂ±o del Papa (2007)  Comedy|Drama\n",
      "       imdbId            Title                   Genre\n",
      "11560  483607  Doomsday (2008)  Action|Sci-Fi|Thriller\n",
      "12138  483607  Doomsday (2008)  Action|Sci-Fi|Thriller\n",
      "       imdbId                               Title          Genre\n",
      "11313  484740  Love in the Time of Cholera (2007)  Drama|Romance\n",
      "11891  484740  Love in the Time of Cholera (2007)  Drama|Romance\n",
      "       imdbId                Title           Genre\n",
      "11504  484877  Wedding Daze (2006)  Comedy|Romance\n",
      "12082  484877  Wedding Daze (2006)  Comedy|Romance\n",
      "       imdbId                     Title                 Genre\n",
      "11529  485851  The Air I Breathe (2007)  Crime|Drama|Thriller\n",
      "12107  485851  The Air I Breathe (2007)  Crime|Drama|Thriller\n",
      "       imdbId                   Title   Genre\n",
      "11229  486572  The Dog Problem (2006)  Comedy\n",
      "11807  486572  The Dog Problem (2006)  Comedy\n",
      "       imdbId                Title               Genre\n",
      "11472  486578  First Sunday (2008)  Comedy|Crime|Drama\n",
      "12050  486578  First Sunday (2008)  Comedy|Crime|Drama\n",
      "       imdbId              Title                  Genre\n",
      "11310  486583  Fred Claus (2007)  Comedy|Family|Fantasy\n",
      "11888  486583  Fred Claus (2007)  Comedy|Family|Fantasy\n",
      "       imdbId                      Title         Genre\n",
      "11583  486674  What Just Happened (2008)  Comedy|Drama\n",
      "12161  486674  What Just Happened (2008)  Comedy|Drama\n",
      "       imdbId                  Title          Genre\n",
      "11750  487273  Les tÃÂ©moins (2007)  Drama|Romance\n",
      "12328  487273  Les tÃÂ©moins (2007)  Drama|Romance\n",
      "       imdbId      Title                 Genre\n",
      "11328  488478  12 (2007)  Crime|Drama|Thriller\n",
      "11906  488478  12 (2007)  Crime|Drama|Thriller\n",
      "       imdbId                      Title                   Genre\n",
      "11751  488604  The Oxford Murders (2008)  Crime|Mystery|Thriller\n",
      "12329  488604  The Oxford Murders (2008)  Crime|Mystery|Thriller\n",
      "       imdbId              Title                  Genre\n",
      "11666  488988  Chapter 27 (2007)  Biography|Crime|Drama\n",
      "12244  488988  Chapter 27 (2007)  Biography|Crime|Drama\n",
      "       imdbId          Title                    Genre\n",
      "11523  489099  Jumper (2008)  Action|Adventure|Sci-Fi\n",
      "12101  489099  Jumper (2008)  Action|Adventure|Sci-Fi\n",
      "       imdbId             Title      Genre\n",
      "11635  489281  Stop-Loss (2008)  Drama|War\n",
      "12213  489281  Stop-Loss (2008)  Drama|War\n",
      "       imdbId                      Title             Genre\n",
      "11478  489282  Strange Wilderness (2008)  Adventure|Comedy\n",
      "12056  489282  Strange Wilderness (2008)  Adventure|Comedy\n",
      "       imdbId                    Title         Genre\n",
      "11411  489458  O Cheiro do Ralo (2006)  Comedy|Drama\n",
      "11989  489458  O Cheiro do Ralo (2006)  Comedy|Drama\n",
      "       imdbId             Title                 Genre\n",
      "11388  489664  Shattered (2007)  Crime|Drama|Thriller\n",
      "11966  489664  Shattered (2007)  Crime|Drama|Thriller\n",
      "       imdbId                                Title   Genre\n",
      "11758  490076  All the Boys Love Mandy Lane (2006)  Horror\n",
      "12336  490076  All the Boys Love Mandy Lane (2006)  Horror\n",
      "       imdbId              Title                 Genre\n",
      "11414  490579  Dedication (2007)  Comedy|Drama|Romance\n",
      "11992  490579  Dedication (2007)  Comedy|Drama|Romance\n",
      "       imdbId                   Title  Genre\n",
      "11438  492463  In Between Days (2006)  Drama\n",
      "12016  492463  In Between Days (2006)  Drama\n",
      "       imdbId              Title            Genre\n",
      "11320  494199  5ive Girls (2006)  Horror|Thriller\n",
      "11898  494199  5ive Girls (2006)  Horror|Thriller\n",
      "       imdbId                     Title                   Genre\n",
      "11695  494271  The Unknown Woman (2006)  Drama|Mystery|Thriller\n",
      "12273  494271  The Unknown Woman (2006)  Drama|Mystery|Thriller\n",
      "       imdbId                                Title           Genre\n",
      "11512  494652  Welcome Home, Roscoe Jenkins (2008)  Comedy|Romance\n",
      "12090  494652  Welcome Home, Roscoe Jenkins (2008)  Comedy|Romance\n",
      "       imdbId        Title          Genre\n",
      "11257  494834  Silk (2007)  Drama|Romance\n",
      "11835  494834  Silk (2007)  Drama|Romance\n",
      "       imdbId                            Title         Genre\n",
      "11768  495040  Kunsten at grÃ_de i kor (2006)  Comedy|Drama\n",
      "12346  495040  Kunsten at grÃ_de i kor (2006)  Comedy|Drama\n",
      "       imdbId                     Title                Genre\n",
      "11579  496319  The Hottest State (2006)  Drama|Music|Romance\n",
      "12157  496319  The Hottest State (2006)  Drama|Music|Romance\n",
      "       imdbId                              Title                 Genre\n",
      "11297  496328  Itty Bitty Titty Committee (2007)  Comedy|Drama|Romance\n",
      "11875  496328  Itty Bitty Titty Committee (2007)  Comedy|Drama|Romance\n",
      "       imdbId            Title                  Genre\n",
      "11707  497323  Anamorph (2007)  Crime|Horror|Thriller\n",
      "12285  497323  Anamorph (2007)  Crime|Horror|Thriller\n",
      "       imdbId                    Title          Genre\n",
      "11510  497876  46-okunen no koi (2006)  Drama|Fantasy\n",
      "12088  497876  46-okunen no koi (2006)  Drama|Fantasy\n",
      "       imdbId                     Title                 Genre\n",
      "11655  497972  Sex and Death 101 (2007)  Comedy|Drama|Romance\n",
      "12233  497972  Sex and Death 101 (2007)  Comedy|Drama|Romance\n",
      "       imdbId            Title  Genre\n",
      "11233  498097  Iklimler (2006)  Drama\n",
      "11811  498097  Iklimler (2006)  Drama\n",
      "       imdbId                                            Title  \\\n",
      "11728  499448  The Chronicles of Narnia: Prince Caspian (2008)   \n",
      "12306  499448  The Chronicles of Narnia: Prince Caspian (2008)   \n",
      "\n",
      "                         Genre  \n",
      "11728  Action|Adventure|Family  \n",
      "12306  Action|Adventure|Family  \n",
      "       imdbId              Title                 Genre\n",
      "11614  499570  Slipstream (2007)  Comedy|Drama|Fantasy\n",
      "12192  499570  Slipstream (2007)  Comedy|Drama|Fantasy\n",
      "       imdbId                     Title                 Genre\n",
      "11241  756672  The Killing Floor (2007)  Crime|Horror|Mystery\n",
      "11819  756672  The Killing Floor (2007)  Crime|Horror|Mystery\n",
      "       imdbId                      Title                 Genre\n",
      "11306  756683  The Man from Earth (2007)  Drama|Fantasy|Sci-Fi\n",
      "11884  756683  The Man from Earth (2007)  Drama|Fantasy|Sci-Fi\n",
      "       imdbId                         Title         Genre\n",
      "11345  757361  Margot at the Wedding (2007)  Comedy|Drama\n",
      "11923  757361  Margot at the Wedding (2007)  Comedy|Drama\n",
      "       imdbId             Title                  Genre\n",
      "11644  758053  Saawariya (2007)  Drama|Musical|Romance\n",
      "12222  758053  Saawariya (2007)  Drama|Musical|Romance\n",
      "       imdbId                                Title                 Genre\n",
      "11405  758730  Aliens vs. Predator: Requiem (2007)  Action|Horror|Sci-Fi\n",
      "11983  758730  Aliens vs. Predator: Requiem (2007)  Action|Horror|Sci-Fi\n",
      "       imdbId            Title             Genre\n",
      "11239  758732  Beaufort (2007)  Action|Drama|War\n",
      "11817  758732  Beaufort (2007)  Action|Drama|War\n",
      "       imdbId          Title               Genre\n",
      "11254  758771  Outlaw (2007)  Action|Crime|Drama\n",
      "11832  758771  Outlaw (2007)  Action|Crime|Drama\n",
      "       imdbId                               Title          Genre\n",
      "11366  758784  Starting Out in the Evening (2007)  Drama|Romance\n",
      "11944  758784  Starting Out in the Evening (2007)  Drama|Romance\n",
      "       imdbId         Title                 Genre\n",
      "11792  758786  Stuck (2007)  Crime|Drama|Thriller\n",
      "12370  758786  Stuck (2007)  Crime|Drama|Thriller\n",
      "       imdbId               Title               Genre\n",
      "11228  758798  Weirdsville (2007)  Comedy|Crime|Drama\n",
      "11806  758798  Weirdsville (2007)  Comedy|Crime|Drama\n",
      "       imdbId                      Title                   Genre\n",
      "11459  760311  He Was a Quiet Man (2007)  Drama|Romance|Thriller\n",
      "12037  760311  He Was a Quiet Man (2007)  Drama|Romance|Thriller\n",
      "       imdbId                   Title                     Genre\n",
      "11415  760329  The Water Horse (2007)  Adventure|Family|Fantasy\n",
      "11993  760329  The Water Horse (2007)  Adventure|Family|Fantasy\n",
      "       imdbId  \\\n",
      "11739  762104   \n",
      "12317  762104   \n",
      "\n",
      "                                                                     Title  \\\n",
      "11739  How to Rob a Bank (and 10 Tips to Actually Get Away with It) (2007)   \n",
      "12317  How to Rob a Bank (and 10 Tips to Actually Get Away with It) (2007)   \n",
      "\n",
      "                      Genre  \n",
      "11739  Comedy|Crime|Mystery  \n",
      "12317  Comedy|Crime|Mystery  \n",
      "       imdbId             Title        Genre\n",
      "11357  762117  Maxed Out (2006)  Documentary\n",
      "11935  762117  Maxed Out (2006)  Documentary\n",
      "       imdbId                       Title          Genre\n",
      "11358  765120  My Blueberry Nights (2007)  Drama|Romance\n",
      "11936  765120  My Blueberry Nights (2007)  Drama|Romance\n",
      "       imdbId                     Title                  Genre\n",
      "11289  765429  American Gangster (2007)  Biography|Crime|Drama\n",
      "11867  765429  American Gangster (2007)  Biography|Crime|Drama\n",
      "       imdbId                   Title                Genre\n",
      "11253  765451  Fugitive Pieces (2007)  Adventure|Drama|War\n",
      "11831  765451  Fugitive Pieces (2007)  Adventure|Drama|War\n",
      "       imdbId                                Title                 Genre\n",
      "11759  768120  Kiraware Matsuko no isshÃÂ« (2006)  Comedy|Drama|Musical\n",
      "12337  768120  Kiraware Matsuko no isshÃÂ« (2006)  Comedy|Drama|Musical\n",
      "       imdbId               Title                    Genre\n",
      "11513  770752  Fool's Gold (2008)  Action|Adventure|Comedy\n",
      "12091  770752  Fool's Gold (2008)  Action|Adventure|Comedy\n",
      "       imdbId                Title  Genre\n",
      "11475  770810  How She Move (2007)  Drama\n",
      "12053  770810  How She Move (2007)  Drama\n",
      "       imdbId                 Title  Genre\n",
      "11551  772168  Grace Is Gone (2007)  Drama\n",
      "12129  772168  Grace Is Gone (2007)  Drama\n",
      "       imdbId  \\\n",
      "11365  775438   \n",
      "11943  775438   \n",
      "\n",
      "                                                                  Title  \\\n",
      "11365  Buy the Ticket, Take the Ride: Hunter S. Thompson on Film (2006)   \n",
      "11943  Buy the Ticket, Take the Ride: Hunter S. Thompson on Film (2006)   \n",
      "\n",
      "             Genre  \n",
      "11365  Documentary  \n",
      "11943  Documentary  \n",
      "       imdbId               Title         Genre\n",
      "11350  775529  The Savages (2007)  Comedy|Drama\n",
      "11928  775529  The Savages (2007)  Comedy|Drama\n",
      "       imdbId               Title                 Genre\n",
      "11262  779982  Black Sheep (2006)  Comedy|Horror|Sci-Fi\n",
      "11840  779982  Black Sheep (2006)  Comedy|Horror|Sci-Fi\n",
      "       imdbId              Title                 Genre\n",
      "11515  780486  Blue State (2007)  Comedy|Drama|Romance\n",
      "12093  780486  Blue State (2007)  Comedy|Drama|Romance\n",
      "       imdbId          Title  Genre\n",
      "11502  780492  Canvas (2006)  Drama\n",
      "12080  780492  Canvas (2006)  Drama\n",
      "       imdbId            Title                 Genre\n",
      "11444  780516  Flawless (2007)  Crime|Drama|Thriller\n",
      "12022  780516  Flawless (2007)  Crime|Drama|Thriller\n",
      "       imdbId                          Title                 Genre\n",
      "11266  780534  My Mom's New Boyfriend (2008)  Comedy|Crime|Romance\n",
      "11844  780534  My Mom's New Boyfriend (2008)  Comedy|Crime|Romance\n",
      "       imdbId             Title               Genre\n",
      "11486  780536  In Bruges (2008)  Comedy|Crime|Drama\n",
      "12064  780536  In Bruges (2008)  Comedy|Crime|Drama\n",
      "       imdbId                             Title                 Genre\n",
      "11284  780583  Flight of the Living Dead (2007)  Action|Horror|Sci-Fi\n",
      "11862  780583  Flight of the Living Dead (2007)  Action|Horror|Sci-Fi\n",
      "       imdbId              Title                   Genre\n",
      "11482  780607  The Signal (2007)  Horror|Sci-Fi|Thriller\n",
      "12060  780607  The Signal (2007)  Horror|Sci-Fi|Thriller\n",
      "       imdbId               Title   Genre\n",
      "11327  780608  Smiley Face (2007)  Comedy\n",
      "11905  780608  Smiley Face (2007)  Comedy\n",
      "       imdbId         Title                  Genre\n",
      "11507  780622  Teeth (2007)  Comedy|Fantasy|Horror\n",
      "12085  780622  Teeth (2007)  Comedy|Fantasy|Horror\n",
      "       imdbId                      Title                   Genre\n",
      "11479  785007  Over Her Dead Body (2008)  Comedy|Fantasy|Romance\n",
      "12057  785007  Over Her Dead Body (2008)  Comedy|Fantasy|Romance\n",
      "       imdbId             Title         Genre\n",
      "11716  790623  Meet Bill (2007)  Comedy|Drama\n",
      "12294  790623  Meet Bill (2007)  Comedy|Drama\n",
      "       imdbId              Title                Genre\n",
      "11298  790706  Crazy Love (2007)  Documentary|Romance\n",
      "11876  790706  Crazy Love (2007)  Documentary|Romance\n",
      "       imdbId                        Title          Genre\n",
      "11332  792966  La faute ÃÃ Fidel! (2006)  Drama|History\n",
      "11910  792966  La faute ÃÃ Fidel! (2006)  Drama|History\n",
      "       imdbId        Title                 Genre\n",
      "11721  795439  Numb (2007)  Comedy|Drama|Romance\n",
      "12299  795439  Numb (2007)  Comedy|Drama|Romance\n",
      "       imdbId                     Title                Genre\n",
      "11431  795493  Cassandra's Dream (2007)  Crime|Drama|Romance\n",
      "12009  795493  Cassandra's Dream (2007)  Crime|Drama|Romance\n",
      "       imdbId                       Title            Genre\n",
      "11612  796307  Under the Same Moon (2007)  Adventure|Drama\n",
      "12190  796307  Under the Same Moon (2007)  Adventure|Drama\n",
      "       imdbId                  Title   Genre\n",
      "11296  799934  Be Kind Rewind (2008)  Comedy\n",
      "11874  799934  Be Kind Rewind (2008)  Comedy\n",
      "       imdbId                             Title                 Genre\n",
      "11654  800039  Forgetting Sarah Marshall (2008)  Comedy|Drama|Romance\n",
      "12232  800039  Forgetting Sarah Marshall (2008)  Comedy|Drama|Romance\n",
      "       imdbId                                         Title  \\\n",
      "11501  800099  Joe Strummer: The Future Is Unwritten (2007)   \n",
      "12079  800099  Joe Strummer: The Future Is Unwritten (2007)   \n",
      "\n",
      "                             Genre  \n",
      "11501  Documentary|Biography|Music  \n",
      "12079  Documentary|Biography|Music  \n",
      "       imdbId             Title                Genre\n",
      "11693  800240  Deception (2008)  Crime|Drama|Mystery\n",
      "12271  800240  Deception (2008)  Crime|Drama|Mystery\n",
      "       imdbId                     Title                  Genre\n",
      "11717  802948  An American Crime (2007)  Biography|Crime|Drama\n",
      "12295  802948  An American Crime (2007)  Biography|Crime|Drama\n",
      "       imdbId                 Title   Genre\n",
      "11789  803057  The Promotion (2008)  Comedy\n",
      "12367  803057  The Promotion (2008)  Comedy\n",
      "       imdbId                Title                Genre\n",
      "11591  804505  Married Life (2007)  Crime|Drama|Romance\n",
      "12169  804505  Married Life (2007)  Crime|Drama|Romance\n",
      "       imdbId      Title                  Genre\n",
      "11337  804516  P2 (2007)  Crime|Horror|Thriller\n",
      "11915  804516  P2 (2007)  Crime|Horror|Thriller\n",
      "       imdbId                          Title            Genre\n",
      "11351  804555  Wrong Turn 2: Dead End (2007)  Horror|Thriller\n",
      "11929  804555  Wrong Turn 2: Dead End (2007)  Horror|Thriller\n",
      "       imdbId                        Title  Genre\n",
      "11524  807054  It's a Free World... (2007)  Drama\n",
      "12102  807054  It's a Free World... (2007)  Drama\n",
      "       imdbId           Title  Genre\n",
      "11576  807721  Meduzot (2007)  Drama\n",
      "12154  807721  Meduzot (2007)  Drama\n",
      "       imdbId               Title               Genre\n",
      "11562  808279  Funny Games (2007)  Crime|Drama|Horror\n",
      "12140  808279  Funny Games (2007)  Crime|Drama|Horror\n",
      "       imdbId              Title                      Genre\n",
      "11245  808417  Persepolis (2007)  Animation|Biography|Drama\n",
      "11823  808417  Persepolis (2007)  Animation|Biography|Drama\n",
      "       imdbId               Title          Genre\n",
      "11735  808486  Suden vuosi (2007)  Drama|Romance\n",
      "12313  808486  Suden vuosi (2007)  Drama|Romance\n",
      "       imdbId                          Title                       Genre\n",
      "11468  808506  Toki o kakeru shÃÂ«jo (2006)  Animation|Adventure|Comedy\n",
      "12046  808506  Toki o kakeru shÃÂ«jo (2006)  Animation|Adventure|Comedy\n",
      "       imdbId                           Title            Genre\n",
      "11384  810823  The Deaths of Ian Stone (2007)  Horror|Thriller\n",
      "11962  810823  The Deaths of Ian Stone (2007)  Horror|Thriller\n",
      "       imdbId               Title                 Genre\n",
      "11662  811080  Speed Racer (2008)  Action|Family|Sci-Fi\n",
      "12240  811080  Speed Racer (2008)  Action|Family|Sci-Fi\n",
      "       imdbId                 Title                 Genre\n",
      "11565  811138  The Love Guru (2008)  Comedy|Romance|Sport\n",
      "12143  811138  The Love Guru (2008)  Comedy|Romance|Sport\n",
      "       imdbId              Title               Genre\n",
      "11767  812243  Ex Drummer (2007)  Comedy|Crime|Drama\n",
      "12345  812243  Ex Drummer (2007)  Comedy|Crime|Drama\n",
      "       imdbId              Title                 Genre\n",
      "11604  814130  The Hammer (2007)  Comedy|Romance|Sport\n",
      "12182  814130  The Hammer (2007)  Comedy|Romance|Sport\n",
      "       imdbId          Title  Genre\n",
      "11492  814666  Bamako (2006)  Drama\n",
      "12070  814666  Bamako (2006)  Drama\n",
      "       imdbId                            Title                   Genre\n",
      "11670  815178  The Life Before Her Eyes (2007)  Drama|Mystery|Thriller\n",
      "12248  815178  The Life Before Her Eyes (2007)  Drama|Mystery|Thriller\n",
      "       imdbId              Title                   Genre\n",
      "11675  815241  Religulous (2008)  Documentary|Comedy|War\n",
      "12253  815241  Religulous (2008)  Documentary|Comedy|War\n",
      "       imdbId                   Title  Genre\n",
      "11498  816616  Poor Boy's Game (2007)  Drama\n",
      "12076  816616  Poor Boy's Game (2007)  Drama\n",
      "       imdbId           Title  Genre\n",
      "11278  817225  Milyang (2007)  Drama\n",
      "11856  817225  Milyang (2007)  Drama\n",
      "       imdbId                   Title         Genre\n",
      "11610  817538  Drillbit Taylor (2008)  Comedy|Drama\n",
      "12188  817538  Drillbit Taylor (2008)  Comedy|Drama\n",
      "       imdbId                                   Title        Genre\n",
      "11372  819354  10 Questions for the Dalai Lama (2006)  Documentary\n",
      "11950  819354  10 Questions for the Dalai Lama (2006)  Documentary\n",
      "       imdbId           Title               Genre\n",
      "11275  821470  Jjakpae (2006)  Action|Crime|Drama\n",
      "11853  821470  Jjakpae (2006)  Action|Crime|Drama\n",
      "       imdbId                Title  Genre\n",
      "11321  822849  Rails & Ties (2007)  Drama\n",
      "11899  822849  Rails & Ties (2007)  Drama\n",
      "       imdbId                   Title                   Genre\n",
      "11377  825232  The Bucket List (2007)  Adventure|Comedy|Drama\n",
      "11955  825232  The Bucket List (2007)  Adventure|Comedy|Drama\n",
      "       imdbId           Title                 Genre\n",
      "11497  825236  Caramel (2007)  Comedy|Drama|Romance\n",
      "12075  825236  Caramel (2007)  Comedy|Drama|Romance\n",
      "       imdbId                        Title               Genre\n",
      "11540  826547  Great World of Sound (2007)  Comedy|Drama|Music\n",
      "12118  826547  Great World of Sound (2007)  Comedy|Drama|Music\n",
      "       imdbId                             Title         Genre\n",
      "11711  826711  Le voyage du ballon rouge (2007)  Drama|Family\n",
      "12289  826711  Le voyage du ballon rouge (2007)  Drama|Family\n",
      "       imdbId           Title  Genre\n",
      "11729  827517  Reprise (2006)  Drama\n",
      "12307  827517  Reprise (2006)  Drama\n",
      "       imdbId                Title                  Genre\n",
      "11628  827521  The Shepherd (2008)  Action|Crime|Thriller\n",
      "12206  827521  The Shepherd (2008)  Action|Crime|Thriller\n",
      "       imdbId                                    Title               Genre\n",
      "11646  827713  I Always Wanted to Be a Gangster (2007)  Comedy|Crime|Drama\n",
      "12224  827713  I Always Wanted to Be a Gangster (2007)  Comedy|Crime|Drama\n",
      "       imdbId                                      Title            Genre\n",
      "11790  829098  When Did You Last See Your Father? (2007)  Biography|Drama\n",
      "12368  829098  When Did You Last See Your Father? (2007)  Biography|Drama\n",
      "       imdbId                      Title               Genre\n",
      "11736  830558  The Girl Next Door (2007)  Crime|Drama|Horror\n",
      "12314  830558  The Girl Next Door (2007)  Crime|Drama|Horror\n",
      "       imdbId                   Title        Genre\n",
      "11368  830968  Suicide Killers (2006)  Documentary\n",
      "11946  830968  Suicide Killers (2006)  Documentary\n",
      "       imdbId                     Title                 Genre\n",
      "11526  832266  Definitely, Maybe (2008)  Comedy|Drama|Romance\n",
      "12104  832266  Definitely, Maybe (2008)  Comedy|Drama|Romance\n",
      "       imdbId                     Title                 Genre\n",
      "11469  837803  Sex and Breakfast (2007)  Comedy|Drama|Romance\n",
      "12047  837803  Sex and Breakfast (2007)  Comedy|Drama|Romance\n",
      "       imdbId                   Title        Genre\n",
      "11548  839938  Out of the Blue (2006)  Crime|Drama\n",
      "12126  839938  Out of the Blue (2006)  Crime|Drama\n",
      "       imdbId            Title         Genre\n",
      "11542  839980  Semi-Pro (2008)  Comedy|Sport\n",
      "12120  839980  Semi-Pro (2008)  Comedy|Sport\n",
      "       imdbId                       Title                  Genre\n",
      "11419  841032  The Perfect Holiday (2007)  Comedy|Family|Fantasy\n",
      "11997  841032  The Perfect Holiday (2007)  Comedy|Family|Fantasy\n",
      "       imdbId                                  Title         Genre\n",
      "11406  841046  Walk Hard: The Dewey Cox Story (2007)  Comedy|Music\n",
      "11984  841046  Walk Hard: The Dewey Cox Story (2007)  Comedy|Music\n",
      "       imdbId                Title        Genre\n",
      "11749  841119  Lake of Fire (2006)  Documentary\n",
      "12327  841119  Lake of Fire (2006)  Documentary\n",
      "       imdbId                       Title                Genre\n",
      "11726  844462  The Unknown Soldier (2006)  Documentary|History\n",
      "12304  844462  The Unknown Soldier (2006)  Documentary|History\n",
      "       imdbId                 Title                    Genre\n",
      "11680  845046  Son of Rambow (2007)  Action|Adventure|Comedy\n",
      "12258  845046  Son of Rambow (2007)  Action|Adventure|Comedy\n",
      "       imdbId                   Title   Genre\n",
      "11677  845955  Are You Scared? (2006)  Horror\n",
      "12255  845955  Are You Scared? (2006)  Horror\n",
      "       imdbId                                  Title               Genre\n",
      "11791  846040  Mio fratello ÃÂ¬ figlio unico (2007)  Comedy|Crime|Drama\n",
      "12369  846040  Mio fratello ÃÂ¬ figlio unico (2007)  Comedy|Crime|Drama\n",
      "       imdbId             Title        Genre\n",
      "11373  847817  Helvetica (2007)  Documentary\n",
      "11951  847817  Helvetica (2007)  Documentary\n",
      "       imdbId            Title                 Genre\n",
      "11458  848542  Arranged (2007)  Comedy|Drama|Romance\n",
      "12036  848542  Arranged (2007)  Comedy|Drama|Romance\n",
      "       imdbId                     Title            Genre\n",
      "11567  848557  Diary of the Dead (2007)  Horror|Thriller\n",
      "12145  848557  Diary of the Dead (2007)  Horror|Thriller\n",
      "       imdbId                         Title                  Genre\n",
      "11547  854678  Taxi to the Dark Side (2007)  Documentary|Crime|War\n",
      "12125  854678  Taxi to the Dark Side (2007)  Documentary|Crime|War\n",
      "       imdbId                Title         Genre\n",
      "11400  855824  Hei yan quan (2006)  Comedy|Drama\n",
      "11978  855824  Hei yan quan (2006)  Comedy|Drama\n",
      "       imdbId                       Title  Genre\n",
      "11661  855895  Nue propriÃÂ©tÃÂ© (2006)  Drama\n",
      "12239  855895  Nue propriÃÂ©tÃÂ© (2006)  Drama\n",
      "       imdbId                         Title                Genre\n",
      "11307  856052  Yeui-eomneun geotdeul (2006)  Action|Comedy|Crime\n",
      "11885  856052  Yeui-eomneun geotdeul (2006)  Action|Comedy|Crime\n",
      "       imdbId          Title   Genre\n",
      "11649  856288  Inside (2007)  Horror\n",
      "12227  856288  Inside (2007)  Horror\n",
      "       imdbId               Title  Genre\n",
      "11658  857191  The Visitor (2007)  Drama\n",
      "12236  857191  The Visitor (2007)  Drama\n",
      "       imdbId                Title            Genre\n",
      "11456  857295  Timber Falls (2007)  Horror|Thriller\n",
      "12034  857295  Timber Falls (2007)  Horror|Thriller\n",
      "       imdbId                                                Title  Genre\n",
      "11281  857355  O Ano em Que Meus Pais SaÃ_ram de FÃÂ©rias (2006)  Drama\n",
      "11859  857355  O Ano em Que Meus Pais SaÃ_ram de FÃÂ©rias (2006)  Drama\n",
      "       imdbId           Title                  Genre\n",
      "11663  857376  Gabriel (2007)  Action|Fantasy|Horror\n",
      "12241  857376  Gabriel (2007)  Action|Fantasy|Horror\n",
      "       imdbId                Title                 Genre\n",
      "11623  858479  Smart People (2008)  Comedy|Drama|Romance\n",
      "12201  858479  Smart People (2008)  Comedy|Drama|Romance\n",
      "       imdbId               Title               Genre\n",
      "11280  861739  Elite Squad (2007)  Action|Crime|Drama\n",
      "11858  861739  Elite Squad (2007)  Action|Crime|Drama\n",
      "       imdbId                         Title                     Genre\n",
      "11668  865556  The Forbidden Kingdom (2008)  Action|Adventure|Fantasy\n",
      "12246  865556  The Forbidden Kingdom (2008)  Action|Adventure|Fantasy\n",
      "       imdbId                             Title                 Genre\n",
      "11247  866437  The Jane Austen Book Club (2007)  Comedy|Drama|Romance\n",
      "11825  866437  The Jane Austen Book Club (2007)  Comedy|Drama|Romance\n",
      "       imdbId                 Title           Genre\n",
      "11704  866439  Made of Honor (2008)  Comedy|Romance\n",
      "12282  866439  Made of Honor (2008)  Comedy|Romance\n",
      "       imdbId                     Title        Genre\n",
      "11570  870090  Cidade dos Homens (2007)  Crime|Drama\n",
      "12148  870090  Cidade dos Homens (2007)  Crime|Drama\n",
      "       imdbId                    Title               Genre\n",
      "11496  870112  Future by Design (2006)  Documentary|Sci-Fi\n",
      "12074  870112  Future by Design (2006)  Documentary|Sci-Fi\n",
      "       imdbId             Title           Genre\n",
      "11694  871426  Baby Mama (2008)  Comedy|Romance\n",
      "12272  871426  Baby Mama (2008)  Comedy|Romance\n",
      "       imdbId                Title           Genre\n",
      "11531  872224  Street Thief (2006)  Crime|Thriller\n",
      "12109  872224  Street Thief (2006)  Crime|Thriller\n",
      "       imdbId             Title         Genre\n",
      "11660  875113  99 francs (2007)  Comedy|Drama\n",
      "12238  875113  99 francs (2007)  Comedy|Drama\n",
      "       imdbId                Title                Genre\n",
      "11326  878695  Murder Party (2007)  Comedy|Drama|Horror\n",
      "11904  878695  Murder Party (2007)  Comedy|Drama|Horror\n",
      "       imdbId                      Title  Genre\n",
      "11263  880502  The Edge of Heaven (2007)  Drama\n",
      "11841  880502  The Edge of Heaven (2007)  Drama\n",
      "       imdbId               Title                   Genre\n",
      "11473  880578  Untraceable (2008)  Crime|Mystery|Thriller\n",
      "12051  880578  Untraceable (2008)  Crime|Mystery|Thriller\n",
      "       imdbId              Title                   Genre\n",
      "11630  881200  Ji jie hao (2007)  Action|Biography|Drama\n",
      "12208  881200  Ji jie hao (2007)  Action|Biography|Drama\n",
      "       imdbId             Title                   Genre\n",
      "11734  884224  War, Inc. (2008)  Action|Comedy|Thriller\n",
      "12312  884224  War, Inc. (2008)  Action|Comedy|Thriller\n",
      "       imdbId            Title   Genre\n",
      "11333  884328  The Mist (2007)  Horror\n",
      "11911  884328  The Mist (2007)  Horror\n",
      "       imdbId                   Title           Genre\n",
      "11454  887719  Blonde Ambition (2007)  Comedy|Romance\n",
      "12032  887719  Blonde Ambition (2007)  Comedy|Romance\n",
      "       imdbId          Title           Genre\n",
      "11265  890870  Saw IV (2007)  Horror|Mystery\n",
      "11843  890870  Saw IV (2007)  Horror|Mystery\n",
      "       imdbId                   Title               Genre\n",
      "11309  891527  Lions for Lambs (2007)  Drama|Thriller|War\n",
      "11887  891527  Lions for Lambs (2007)  Drama|Thriller|War\n",
      "       imdbId         Title              Genre\n",
      "11516  892375  U2 3D (2007)  Documentary|Music\n",
      "12094  892375  U2 3D (2007)  Documentary|Music\n",
      "       imdbId                               Title        Genre\n",
      "11678  892425  Before Flying Back to Earth (2005)  Documentary\n",
      "12256  892425  Before Flying Back to Earth (2005)  Documentary\n",
      "       imdbId           Title                 Genre\n",
      "11676  892899  Outpost (2008)  Action|Horror|Sci-Fi\n",
      "12254  892899  Outpost (2008)  Action|Horror|Sci-Fi\n",
      "       imdbId           Title                  Genre\n",
      "11423  893356  Nanking (2007)  Biography|History|War\n",
      "12001  893356  Nanking (2007)  Biography|History|War\n",
      "       imdbId                 Title                        Genre\n",
      "11636  893382  Shine a Light (2008)  Documentary|Biography|Music\n",
      "12214  893382  Shine a Light (2008)  Documentary|Biography|Music\n",
      "       imdbId                      Title         Genre\n",
      "11742  893509  Blonde and Blonder (2007)  Comedy|Crime\n",
      "12320  893509  Blonde and Blonder (2007)  Comedy|Crime\n",
      "       imdbId           Title                   Genre\n",
      "11451  896798  Cleaner (2007)  Crime|Mystery|Thriller\n",
      "12029  896798  Cleaner (2007)  Crime|Mystery|Thriller\n",
      "       imdbId                           Title                  Genre\n",
      "11500  901507  Rise of the Footsoldier (2007)  Biography|Crime|Drama\n",
      "12078  901507  Rise of the Footsoldier (2007)  Biography|Crime|Drama\n",
      "       imdbId                                    Title  \\\n",
      "11577  902272  Justice League: The New Frontier (2008)   \n",
      "12155  902272  Justice League: The New Frontier (2008)   \n",
      "\n",
      "                            Genre  \n",
      "11577  Animation|Action|Adventure  \n",
      "12155  Animation|Action|Adventure  \n",
      "       imdbId         Title                 Genre\n",
      "11645  903627  Julia (2008)  Crime|Drama|Thriller\n",
      "12223  903627  Julia (2008)  Crime|Drama|Thriller\n",
      "       imdbId              Title                          Genre\n",
      "11571  905979  Chicago 10 (2007)  Documentary|Animation|History\n",
      "12149  905979  Chicago 10 (2007)  Documentary|Animation|History\n",
      "       imdbId                          Title         Genre\n",
      "11264  906108  Why Did I Get Married? (2007)  Comedy|Drama\n",
      "11842  906108  Why Did I Get Married? (2007)  Comedy|Drama\n",
      "       imdbId                    Title                 Genre\n",
      "11714  907680  Walk All Over Me (2007)  Crime|Drama|Thriller\n",
      "12292  907680  Walk All Over Me (2007)  Crime|Drama|Thriller\n",
      "       imdbId                                                 Title  \\\n",
      "11317  910873  An Evening with Kevin Smith 2: Evening Harder (2006)   \n",
      "11895  910873  An Evening with Kevin Smith 2: Evening Harder (2006)   \n",
      "\n",
      "                    Genre  \n",
      "11317  Documentary|Comedy  \n",
      "11895  Documentary|Comedy  \n",
      "       imdbId                               Title        Genre\n",
      "11369  912580  The Devil Came on Horseback (2007)  Documentary\n",
      "11947  912580  The Devil Came on Horseback (2007)  Documentary\n",
      "       imdbId                             Title                Genre\n",
      "11267  912583  For the Bible Tells Me So (2007)  Documentary|Romance\n",
      "11845  912583  For the Bible Tells Me So (2007)  Documentary|Romance\n",
      "       imdbId                              Title        Genre\n",
      "11653  912590  Manda Bala (Send a Bullet) (2007)  Documentary\n",
      "12231  912590  Manda Bala (Send a Bullet) (2007)  Documentary\n",
      "       imdbId                           Title                       Genre\n",
      "11276  912592  My Kid Could Paint That (2007)  Documentary|Family|Mystery\n",
      "11854  912592  My Kid Could Paint That (2007)  Documentary|Family|Mystery\n",
      "       imdbId             Title                  Genre\n",
      "11564  912599  War Dance (2007)  Documentary|Music|War\n",
      "12142  912599  War Dance (2007)  Documentary|Music|War\n",
      "       imdbId              Title  Genre\n",
      "11601  914382  Quiet City (2007)  Drama\n",
      "12179  914382  Quiet City (2007)  Drama\n",
      "       imdbId                     Title  Genre\n",
      "11587  918557  Saving Sarah Cain (2007)  Drama\n",
      "12165  918557  Saving Sarah Cain (2007)  Drama\n",
      "       imdbId              Title           Genre\n",
      "11700  926129  Prom Night (2008)  Horror|Mystery\n",
      "12278  926129  Prom Night (2008)  Horror|Mystery\n",
      "       imdbId         Title            Genre\n",
      "11709  936501  Taken (2008)  Action|Thriller\n",
      "12287  936501  Taken (2008)  Action|Thriller\n",
      "       imdbId            Title               Genre\n",
      "11367  937237  Redacted (2007)  Crime|Thriller|War\n",
      "11945  937237  Redacted (2007)  Crime|Thriller|War\n",
      "       imdbId                Title                  Genre\n",
      "11525  937347  Already Dead (2007)  Action|Crime|Thriller\n",
      "12103  937347  Already Dead (2007)  Action|Crime|Thriller\n",
      "       imdbId                  Title                 Genre\n",
      "11336  937375  This Christmas (2007)  Comedy|Drama|Romance\n",
      "11914  937375  This Christmas (2007)  Comedy|Drama|Romance\n",
      "       imdbId                         Title               Genre\n",
      "11762  939681  What Would Jesus Buy? (2007)  Documentary|Comedy\n",
      "12340  939681  What Would Jesus Buy? (2007)  Documentary|Comedy\n",
      "       imdbId                              Title              Genre\n",
      "11744  940620  Patti Smith: Dream of Life (2008)  Documentary|Music\n",
      "12322  940620  Patti Smith: Dream of Life (2008)  Documentary|Music\n",
      "       imdbId                     Title                 Genre\n",
      "11609  940709  Cheung gong 7 hou (2008)  Comedy|Family|Sci-Fi\n",
      "12187  940709  Cheung gong 7 hou (2008)  Comedy|Family|Sci-Fi\n",
      "       imdbId           Title                Genre\n",
      "11731  942384  Shelter (2007)  Drama|Romance|Sport\n",
      "12309  942384  Shelter (2007)  Drama|Romance|Sport\n",
      "       imdbId                              Title                   Genre\n",
      "11713  942903  Stargate: The Ark of Truth (2008)  Action|Adventure|Drama\n",
      "12291  942903  Stargate: The Ark of Truth (2008)  Action|Adventure|Drama\n",
      "       imdbId                               Title         Genre\n",
      "11518  945356  Kunsten ÃÂ´ tenke negativt (2006)  Comedy|Drama\n",
      "12096  945356  Kunsten ÃÂ´ tenke negativt (2006)  Comedy|Drama\n",
      "       imdbId             Title                  Genre\n",
      "11448  951216  Mad Money (2008)  Comedy|Crime|Thriller\n",
      "12026  951216  Mad Money (2008)  Comedy|Crime|Thriller\n",
      "       imdbId                           Title                    Genre\n",
      "11342  952640  Alvin and the Chipmunks (2007)  Animation|Comedy|Family\n",
      "11920  952640  Alvin and the Chipmunks (2007)  Animation|Comedy|Family\n",
      "       imdbId                                 Title          Genre\n",
      "11787  960144  You Don't Mess with the Zohan (2008)  Action|Comedy\n",
      "12365  960144  You Don't Mess with the Zohan (2008)  Action|Comedy\n",
      "       imdbId                Title           Genre\n",
      "11409  960790  Keinohrhasen (2007)  Comedy|Romance\n",
      "11987  960790  Keinohrhasen (2007)  Comedy|Romance\n",
      "       imdbId                         Title        Genre\n",
      "11261  961117  Manufacturing Dissent (2007)  Documentary\n",
      "11839  961117  Manufacturing Dissent (2007)  Documentary\n",
      "       imdbId                                          Title  \\\n",
      "11669  963208  Where in the World Is Osama Bin Laden? (2008)   \n",
      "12247  963208  Where in the World Is Osama Bin Laden? (2008)   \n",
      "\n",
      "                        Genre  \n",
      "11669  Documentary|Comedy|War  \n",
      "12247  Documentary|Comedy|War  \n",
      "       imdbId             Title   Genre\n",
      "11651  963794  The Ruins (2008)  Horror\n",
      "12229  963794  The Ruins (2008)  Horror\n",
      "       imdbId                                                        Title  \\\n",
      "11499  970184  Operation Homecoming: Writing the Wartime Experience (2007)   \n",
      "12077  970184  Operation Homecoming: Writing the Wartime Experience (2007)   \n",
      "\n",
      "             Genre  \n",
      "11499  Documentary  \n",
      "12077  Documentary  \n",
      "       imdbId                                  Title           Genre\n",
      "11589  970468  Miss Pettigrew Lives for a Day (2008)  Comedy|Romance\n",
      "12167  970468  Miss Pettigrew Lives for a Day (2008)  Comedy|Romance\n",
      "       imdbId                                     Title   Genre\n",
      "11720  974959  American Pie Presents: Beta House (2007)  Comedy\n",
      "12298  974959  American Pie Presents: Beta House (2007)  Comedy\n",
      "       imdbId               Title               Genre\n",
      "11710  977214  Hero Wanted (2008)  Action|Crime|Drama\n",
      "12288  977214  Hero Wanted (2008)  Action|Crime|Drama\n",
      "       imdbId                   Title        Genre\n",
      "11378  977649  Fall from Grace (2007)  Documentary\n",
      "11956  977649  Fall from Grace (2007)  Documentary\n",
      "       imdbId                    Title               Genre\n",
      "11434  986264  Taare Zameen Par (2007)  Drama|Family|Music\n",
      "12012  986264  Taare Zameen Par (2007)  Drama|Family|Music\n",
      "       imdbId              Title        Genre\n",
      "11322  988102  Darfur Now (2007)  Documentary\n",
      "11900  988102  Darfur Now (2007)  Documentary\n",
      "       imdbId         Title  Genre\n",
      "11596  988108  Klass (2007)  Drama\n",
      "12174  988108  Klass (2007)  Drama\n",
      "       imdbId              Title           Genre\n",
      "11420  988595  27 Dresses (2008)  Comedy|Romance\n",
      "11998  988595  27 Dresses (2008)  Comedy|Romance\n",
      "       imdbId                               Title                Genre\n",
      "11416  991178  Battlestar Galactica: Razor (2007)  Action|Drama|Sci-Fi\n",
      "11994  991178  Battlestar Galactica: Razor (2007)  Action|Drama|Sci-Fi\n",
      "       imdbId                              Title        Genre\n",
      "11638  995061  The Business of Being Born (2008)  Documentary\n",
      "12216  995061  The Business of Being Born (2008)  Documentary\n",
      "       imdbId       Title          Genre\n",
      "11329  995829  XXY (2007)  Drama|Romance\n",
      "11907  995829  XXY (2007)  Drama|Romance\n",
      "       imdbId                     Title                   Genre\n",
      "11557  997047  College Road Trip (2008)  Adventure|Comedy|Drama\n",
      "12135  997047  College Road Trip (2008)  Adventure|Comedy|Drama\n",
      "        imdbId           Title          Genre\n",
      "11766  1000771  Recount (2008)  Drama|History\n",
      "12344  1000771  Recount (2008)  Drama|History\n",
      "        imdbId                    Title                 Genre\n",
      "11754  1000774  Sex and the City (2008)  Comedy|Drama|Romance\n",
      "12332  1000774  Sex and the City (2008)  Comedy|Drama|Romance\n",
      "        imdbId                      Title         Genre\n",
      "11541  1001562  Witless Protection (2008)  Comedy|Crime\n",
      "12119  1001562  Witless Protection (2008)  Comedy|Crime\n",
      "        imdbId                    Title        Genre\n",
      "11607  1002540  Malon 9 Kochavim (2007)  Documentary\n",
      "12185  1002540  Malon 9 Kochavim (2007)  Documentary\n",
      "        imdbId                       Title   Genre\n",
      "11664  1007950  Diminished Capacity (2008)  Comedy\n",
      "12242  1007950  Diminished Capacity (2008)  Comedy\n",
      "        imdbId           Title        Genre\n",
      "11705  1012804  Redbelt (2008)  Drama|Sport\n",
      "12283  1012804  Redbelt (2008)  Drama|Sport\n",
      "        imdbId                   Title               Genre\n",
      "11605  1023111  Never Back Down (2008)  Action|Drama|Sport\n",
      "12183  1023111  Never Back Down (2008)  Action|Drama|Sport\n",
      "        imdbId                          Title                Genre\n",
      "11535  1023481  Step Up 2: The Streets (2008)  Drama|Music|Romance\n",
      "12113  1023481  Step Up 2: The Streets (2008)  Drama|Music|Romance\n",
      "        imdbId                Title                Genre\n",
      "11338  1024943  Om Shanti Om (2007)  Action|Comedy|Drama\n",
      "11916  1024943  Om Shanti Om (2007)  Action|Comedy|Drama\n",
      "        imdbId                        Title        Genre\n",
      "11376  1029172  The War on Democracy (2007)  Documentary\n",
      "11954  1029172  The War on Democracy (2007)  Documentary\n",
      "        imdbId                     Title                          Genre\n",
      "11606  1032854  Terror's Advocate (2007)  Documentary|Biography|History\n",
      "12184  1032854  Terror's Advocate (2007)  Documentary|Biography|History\n",
      "        imdbId                         Title           Genre\n",
      "11718  1033643  What Happens in Vegas (2008)  Comedy|Romance\n",
      "12296  1033643  What Happens in Vegas (2008)  Comedy|Romance\n",
      "        imdbId                                            Title  \\\n",
      "11804  1037033  A Complete History of My Sexual Failures (2008)   \n",
      "12382  1037033  A Complete History of My Sexual Failures (2008)   \n",
      "\n",
      "                    Genre  \n",
      "11804  Documentary|Comedy  \n",
      "12382  Documentary|Comedy  \n",
      "        imdbId         Title                    Genre\n",
      "11439  1038988  [Rec] (2007)  Horror|Mystery|Thriller\n",
      "12017  1038988  [Rec] (2007)  Horror|Mystery|Thriller\n",
      "        imdbId                  Title                 Genre\n",
      "11674  1045670  Happy-Go-Lucky (2008)  Comedy|Drama|Romance\n",
      "12252  1045670  Happy-Go-Lucky (2008)  Comedy|Drama|Romance\n",
      "        imdbId               Title              Genre\n",
      "11733  1047007  Young@Heart (2007)  Documentary|Music\n",
      "12311  1047007  Young@Heart (2007)  Documentary|Music\n",
      "        imdbId               Title                 Genre\n",
      "11447  1060277  Cloverfield (2008)  Action|Horror|Sci-Fi\n",
      "12025  1060277  Cloverfield (2008)  Action|Horror|Sci-Fi\n",
      "        imdbId                   Title          Genre\n",
      "11647  1068658  Le premier venu (2008)  Drama|Romance\n",
      "12225  1068658  Le premier venu (2008)  Drama|Romance\n",
      "        imdbId                     Title   Genre\n",
      "11476  1073498  Meet the Spartans (2008)  Comedy\n",
      "12054  1073498  Meet the Spartans (2008)  Comedy\n",
      "        imdbId         Title  Genre\n",
      "11802  1078188  Boy A (2007)  Drama\n",
      "12380  1078188  Boy A (2007)  Drama\n",
      "        imdbId            Title  Genre\n",
      "11719  1080695  Hvid nat (2007)  Drama\n",
      "12297  1080695  Hvid nat (2007)  Drama\n",
      "        imdbId                                     Title        Genre\n",
      "11698  1091617  Expelled: No Intelligence Allowed (2008)  Documentary\n",
      "12276  1091617  Expelled: No Intelligence Allowed (2008)  Documentary\n",
      "        imdbId                      Title              Genre\n",
      "11582  1094594  Sigur RÃ_s: Heima (2007)  Documentary|Music\n",
      "12160  1094594  Sigur RÃ_s: Heima (2007)  Documentary|Music\n",
      "        imdbId                Title              Genre\n",
      "11652  1097239  Joy Division (2007)  Documentary|Music\n",
      "12230  1097239  Joy Division (2007)  Documentary|Music\n",
      "        imdbId                      Title        Genre\n",
      "11546  1097256  Please Vote for Me (2007)  Documentary\n",
      "12124  1097256  Please Vote for Me (2007)  Documentary\n",
      "        imdbId                 Title               Genre\n",
      "11681  1111833  Super High Me (2007)  Documentary|Comedy\n",
      "12259  1111833  Super High Me (2007)  Documentary|Comedy\n",
      "        imdbId             Title        Genre\n",
      "11737  1112115  King Corn (2007)  Documentary\n",
      "12315  1112115  King Corn (2007)  Documentary\n",
      "        imdbId                                             Title        Genre\n",
      "11331  1135489  Endgame: Blueprint for Global Enslavement (2007)  Documentary\n",
      "11909  1135489  Endgame: Blueprint for Global Enslavement (2007)  Documentary\n",
      "        imdbId                           Title              Genre\n",
      "11757  1151309  Bigger Stronger Faster* (2008)  Documentary|Sport\n",
      "12335  1151309  Bigger Stronger Faster* (2008)  Documentary|Sport\n",
      "        imdbId             Title                Genre\n",
      "11574  1166827  Zeitgeist (2007)  Documentary|History\n",
      "12152  1166827  Zeitgeist (2007)  Documentary|History\n",
      "        imdbId                                             Title  \\\n",
      "11760  1219671  Allan Quatermain and the Temple of Skulls (2008)   \n",
      "12338  1219671  Allan Quatermain and the Temple of Skulls (2008)   \n",
      "\n",
      "                          Genre  \n",
      "11760  Action|Adventure|Romance  \n",
      "12338  Action|Adventure|Romance  \n"
     ]
    }
   ],
   "source": [
    "#Find the ID values which are non-unique\n",
    "non_unique_id = []\n",
    "for i in range(len(counts1)):\n",
    "    \n",
    "    if (counts1[i]>1):\n",
    "        #print(uniq1[i], \"with freq=\", counts1[i])\n",
    "        non_unique_id.append(uniq1[i])\n",
    "        \n",
    "#print(non_unique_id)\n",
    "\n",
    "#Find rows where the column value of imdb is among these non_unique_id values\n",
    "for i in range(len(non_unique_id)):\n",
    "    \n",
    "    print(df.loc[df['imdbId'] == int(non_unique_id[i])])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Therefore, we conclude that the duplicate IMDB IDs are now removed and we have only unique IDs with their \n",
    "#corresponding posters \n",
    "#Next : Organise_data with \"MovieGenre_final.csv\""
   ]
  }
 ],
 "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.5.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}