2. Recommendation System.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "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>Movie_ID</th>\n",
       "      <th>Title</th>\n",
       "      <th>Year</th>\n",
       "      <th>Genre</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>34759</td>\n",
       "      <td>Aaghaaz</td>\n",
       "      <td>2000</td>\n",
       "      <td>Thriller</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>34760</td>\n",
       "      <td>Aaj Ka Ravan</td>\n",
       "      <td>2000</td>\n",
       "      <td>Drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>34761</td>\n",
       "      <td>Anjaane</td>\n",
       "      <td>2000</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>34762</td>\n",
       "      <td>Anokha Moti</td>\n",
       "      <td>2000</td>\n",
       "      <td>Family</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>34763</td>\n",
       "      <td>Apradhi Kaun</td>\n",
       "      <td>2000</td>\n",
       "      <td>Thriller</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2084</th>\n",
       "      <td>36968</td>\n",
       "      <td>Panipat</td>\n",
       "      <td>2019</td>\n",
       "      <td>Action/battle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2085</th>\n",
       "      <td>36969</td>\n",
       "      <td>Pati, Patni Aur Woh</td>\n",
       "      <td>2019</td>\n",
       "      <td>Comedy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2086</th>\n",
       "      <td>36970</td>\n",
       "      <td>Mardaani 2</td>\n",
       "      <td>2019</td>\n",
       "      <td>Crime,Thriller</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2087</th>\n",
       "      <td>36971</td>\n",
       "      <td>Dabangg 3</td>\n",
       "      <td>2019</td>\n",
       "      <td>Action</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2088</th>\n",
       "      <td>36972</td>\n",
       "      <td>Good News</td>\n",
       "      <td>2019</td>\n",
       "      <td>Comedy</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2089 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Movie_ID                Title  Year           Genre\n",
       "0        34759             Aaghaaz   2000        Thriller\n",
       "1        34760         Aaj Ka Ravan  2000           Drama\n",
       "2        34761              Anjaane  2000         Romance\n",
       "3        34762          Anokha Moti  2000          Family\n",
       "4        34763         Apradhi Kaun  2000        Thriller\n",
       "...        ...                  ...   ...             ...\n",
       "2084     36968              Panipat  2019   Action/battle\n",
       "2085     36969  Pati, Patni Aur Woh  2019          Comedy\n",
       "2086     36970           Mardaani 2  2019  Crime,Thriller\n",
       "2087     36971            Dabangg 3  2019          Action\n",
       "2088     36972            Good News  2019          Comedy\n",
       "\n",
       "[2089 rows x 4 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies_df = pd.read_csv('Movie_List.csv',encoding= 'unicode_escape')\n",
    "movies_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Movie_ID     0\n",
       "Title        0\n",
       "Year         0\n",
       "Genre       54\n",
       "dtype: int64"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies_df.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "movies_df.dropna(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Thriller', 'Drama', 'Romance', 'Family', 'Drama, Social',\n",
       "       'Action', 'Action, Drama', 'Comedy, Drama', 'Comedy', 'Horror',\n",
       "       'Action, Romance', 'Romance, Drama', 'Comedy, Romance',\n",
       "       'Drama, Family, Thriller', 'Crime', 'Comedy, Drama, Romance',\n",
       "       'Comedy, romance', 'Romance, Drama, Musical', 'Action, romance',\n",
       "       'Romance, drama', 'Drama, War, Thriller',\n",
       "       'Drama, Romance, Musical, Family',\n",
       "       'Comedy, Drama, Romance, Musical', 'Comedy, Musical',\n",
       "       'Drama, Romance', 'Thriller, Action, Romance',\n",
       "       'Suspense, Thriller', 'Thriller\\n', 'Family Drama\\n',\n",
       "       'Action Comedy\\n', 'Thriller, Suspense, Crime\\n',\n",
       "       'Thriller, Horror\\n', 'Romance\\n', 'History\\n',\n",
       "       'Drama, Romance, Social\\n', 'Action\\n', '\\n', 'Drama\\n',\n",
       "       'Drama, Romance, Musical, Social\\n', 'Drama, Romance\\n',\n",
       "       'Drama, Comedy, Romance, Musical\\n', 'Action, Romance\\n',\n",
       "       'Drama, War, Romance, Action\\n', 'Action, Drama, Thriller\\n',\n",
       "       'Comedy\\n', 'Drama, Romance, Family\\n', 'Comedy, Drama\\n',\n",
       "       'Comedy, Romance\\n', 'Drama, Musical, Social\\n',\n",
       "       'Drama, Romance, Musical, Crime\\n', 'Comedy, Family\\n',\n",
       "       'Drama, Romance, Thriller\\n', 'Romance, Drama\\n',\n",
       "       'Historical Drama\\n', 'Thriller, Action\\n', 'Historical\\n',\n",
       "       'Action, Thriller\\n', 'Action, Comedy\\n', \"Children's\\n\",\n",
       "       'Comedy, Romance, Crime\\n', 'Crime, Drama\\n',\n",
       "       'Romance, Drama, Musical, Historical\\n',\n",
       "       'Family, Romance, Drama\\n', 'Erotic\\n', 'Thriller, Romance\\n',\n",
       "       'Thriller, Romance, Musical\\n', 'Fantasy\\n',\n",
       "       'Romance, Drama, Comedy\\n', 'Romance, Drama, Comedy, Musical\\n',\n",
       "       'Family, Drama, Social\\n', 'Action, Crime\\n',\n",
       "       'Horror, Thriller, Romance, Musical\\n', 'Drama, Family\\n',\n",
       "       'Drama, Romance, Social, Musical\\n', 'Historical, Drama\\n',\n",
       "       'Musical\\n', 'Horror\\n', 'Drama, Romance, Comedy, Musical\\n',\n",
       "       'Action, Drama, Romance, Thriller\\n', 'Horror, Thriller\\n',\n",
       "       'Action, Drama, Romance\\n', 'Drama, Social\\n',\n",
       "       'Drama, Action, Thriller\\n', 'Drama, Thriller\\n',\n",
       "       'Drama, Musical\\n',\n",
       "       'Drama, Romance, Comedy, Family, Musical, Social\\n',\n",
       "       'Romance, Fantasy, Musical\\n', 'Drama, Romance, Musical\\n',\n",
       "       'War, Drama, Historical\\n', 'Comedy, Social, Musical\\n', 'Adult\\n',\n",
       "       'War, Drama\\n', 'Mystery, Thriller\\n', 'Romance, Comedy\\n',\n",
       "       'Adult Romance\\n', 'Thriller, Drama\\n', 'Fantasy, Thriller\\n',\n",
       "       'Erotic Romance\\n', 'Comedy, Drama, Romance, Family\\n',\n",
       "       'Comedy, Romance, Drama, Musical\\n', 'Adult Drama\\n',\n",
       "       'Adult Comedy\\n', 'War, Drama, Action, Romance\\n',\n",
       "       'Adult Thriller\\n', 'Action, Musical, Drama, Comedy\\n',\n",
       "       'Mystery, Drama\\n', 'Romance, Musical Drama\\n',\n",
       "       'Action, Comedy, Romance\\n', 'Comedy, Romance, Musical\\n',\n",
       "       'Black Comedy\\n', 'Sports Comedy\\n', 'Action, Drama\\n',\n",
       "       'Romantic, Comedy\\n', 'Fantasy Thriller\\n',\n",
       "       'Drama, Romance, Family, Musical\\n', 'Drama, Action\\n',\n",
       "       'Crime / Thriller\\n', 'Romance, Drama, Family\\n',\n",
       "       'Comedy, Crime, Romance, Musical\\n', 'Erotic Drama\\n',\n",
       "       'Action, Thriller, Suspense\\n', 'Erotic Thriller\\n',\n",
       "       'Romantic Comedy\\n', 'Family drama\\n', 'Sports, Drama, Social\\n',\n",
       "       'Erotic, Crime\\n', 'Erotic romance\\n', 'Drama, Historical\\n',\n",
       "       'Comedy, Drama, Romance\\n', 'Romance, Musical\\n',\n",
       "       'Erotic thriller\\n', 'Fantasy, Romance, Musical\\n',\n",
       "       'Romance, Comedy, Drama, Social\\n', 'History, Epic, Romance\\n',\n",
       "       'Fantasy, Comedy\\n', 'Thriller, Mystery',\n",
       "       'Comedy, Romance, Social', 'Drama, Romance, Crime',\n",
       "       'Comedy, Thriller', 'Action, Sports, Romance',\n",
       "       'Drama, Romance, Family, Social', 'Drama, Comedy',\n",
       "       'Drama, Thriller, Business', 'Comedy, Crime',\n",
       "       'Thriller, Action, Romance, Musical', 'Thriller, Action, Drama',\n",
       "       'Drama, Thriller', 'Drama, Romance, Thriller, Musical',\n",
       "       'Action, Thriller', 'Thriller, Comedy', 'Drama, Romance, Social',\n",
       "       'Supensene, Thriller, Sci-fi', 'Drama, Romance, Musical, Comedy',\n",
       "       'Comedy, Adult', 'Social, Adult', 'Drama, Thriller, War',\n",
       "       'Drama, Romance, Musical, Comedy, Family, Social',\n",
       "       'Superhero, Action, Fantasy, Romance, Musical',\n",
       "       'Comedy, Social, Musical', 'Romance, Comedy', 'Thriller, Fantasy',\n",
       "       'Drama, Social, Action', 'Drama, Patriotic, Social',\n",
       "       'Horror, Thriller', 'Drama, Family', 'Social, Thriller', 'B-grade',\n",
       "       'Drama, Romance, Social, Historical', 'War\\n',\n",
       "       'Drama, Thriller, Romance\\n', 'Family, Drama, Sports\\n',\n",
       "       'Mythological\\n', 'Mystery, Thriller, Comedy\\n',\n",
       "       'Action, Drama, Romance, Crime\\n',\n",
       "       'Crime Fiction, Drama, Historical\\n', 'Short Film\\n', 'Sports\\n',\n",
       "       'Romance, Comedy, Drama\\n', 'Family, Drama\\n',\n",
       "       'Thriller, Horror, Romance, Mystery\\n',\n",
       "       'Action, Comedy, Romance, Musical\\n', 'Romance, comedy\\n',\n",
       "       'Drama, Romance, Social, Comedy\\n', 'Action, Patriotic\\n',\n",
       "       'Musical, Drama\\n', 'Romance |\\n',\n",
       "       'Action, Romance, Comedy, Drama\\n', 'Drama, romance\\n',\n",
       "       'Cricket\\n', 'Drama, social, musical, romance\\n',\n",
       "       'Action, crime, drama\\n', 'Romance, drama, social\\n', 'Social',\n",
       "       'Action, Comedy', 'History, Romance', 'Social, Drama, History',\n",
       "       'Crime, Thriller', 'action, Romance',\n",
       "       'Drama, action, Crime, Thriller, Romance',\n",
       "       'Comedy, Drama, Fantasy', 'Fantasy',\n",
       "       'action, Crime, Drama, Thriller', 'Drama, Romance, Fantasy',\n",
       "       'Drama, Mystery, Thriller', 'Drama, Musical, Romance',\n",
       "       'Thriler, Spy', 'Adventure', 'action, Comedy, Crime, Romance',\n",
       "       'Drama, Romance, Musical', 'Musical, Romance, Thriller',\n",
       "       'Adventure, Drama', 'Horror, Mystery, Romance, Thriller',\n",
       "       'Biography, Drama', 'Superhero, action, Adventure, Fantasy',\n",
       "       'Animation, Family, Romance', 'Comedy, Social',\n",
       "       'Comedy, Drama, Musical, Romance', 'Politics',\n",
       "       'Musical, Drama, Romance, Family', 'Romance, Drama, Romance',\n",
       "       'action, Drama, Mystery, Romance, Thriller', 'Animation', 'Sports',\n",
       "       'Drama, Fantasy, Musical', 'Crime, Drama, Mystery',\n",
       "       'Action Comedy', 'Romantic Comedy', 'Political', 'Action Thriller',\n",
       "       'Historical Drama', 'Romance, Drama, Social, Comedy',\n",
       "       'Action Thriller, Romance', 'Action, comedy, romance',\n",
       "       'Dark comedy', 'Musical', 'Action thriller',\n",
       "       'Romantic comedy, sports', 'Romantic comedy', 'Drama, romance',\n",
       "       'Musical, social, drama, romance', 'Thriller, romance',\n",
       "       'Comedy, thriller, social', 'Drama, family', 'Epic film',\n",
       "       'Comedy, Crime, Romance', 'Action/Thriller', 'Sports/Social',\n",
       "       'Found footage', 'horror', 'Social/Drama',\n",
       "       'Comedy/Romance/Fantasy', 'Romance/Drama', 'Children/Drama',\n",
       "       'Comedy/Romance', 'Thriller/Romance', 'Drama/Political Thriller',\n",
       "       'Action/Romance', 'Action, Romance, Thriller, Crime',\n",
       "       'Political, Comedy', 'Mystery, Suspense', 'Horror/Thriller',\n",
       "       'Biographical', 'Biographical, Animation', 'Action, Adventure',\n",
       "       'Romance / Thriller', 'Period', 'Comedy / Crime', 'Drama Romance',\n",
       "       'Action comedy', 'Animated', 'Social thriller',\n",
       "       'Adult/Comedy/Romance', 'Comedy/Drama/Action',\n",
       "       'Adult/Romance/Comedy', 'Comedy/Comedy/Comedy', 'Cult',\n",
       "       'Family drama', 'Thriller/Black comedy', 'Children',\n",
       "       'Mystery/Action', 'Satire/Comedy/Teen film', 'Superhero/Children',\n",
       "       'Drama/Cult', 'Comedy Road movie', 'Teen/Comedy', 'Romance/Comedy',\n",
       "       'Horror/Romance', 'Action/Drama', 'Psychological thriller',\n",
       "       'Drama/Comedy', 'Drama/Thriller', 'Romance/Teen', 'Action/Comedy',\n",
       "       'Romance/Road', 'Comedy/Social', 'Romance/Action',\n",
       "       'Romantic/Comedy', 'Comedy/Action', 'Romantic',\n",
       "       'Romance Comedy Crime', 'Action/Sci-Fi', 'Action/thriller',\n",
       "       'Comedy/Crime', 'Adult/Horror', 'Adult/Romance/Thriller',\n",
       "       'Suspense/Thriller', 'Adult/Thriller', 'Crime/Thriller',\n",
       "       'Romance/Thriller', 'Adult/Action/Crime', 'Computer-Animated',\n",
       "       'Adult/Romantic', 'Action/comedy', 'Political/Thriller',\n",
       "       'Adult/Crime/Thriller', 'Adult/Comedy', 'Thriller/Social',\n",
       "       'Adult/Suspense/Thriller', 'Adult/Drama', 'Rom-Com',\n",
       "       'Computer Animated', 'Political Thriller', 'Thriller/Crime',\n",
       "       'Musical Comedy', 'Animation/Drama/Children', 'Drama/Suspense',\n",
       "       'Thriller/Drama', 'Romance/Crime', 'Animation/Musical',\n",
       "       'Drama/Family', 'Drama/Dance', 'Satire/Comedy', 'Comedy/Satire',\n",
       "       'Musical romance', 'Anthology', 'Children/Animation',\n",
       "       'Zombie comedy', 'Coming of age', 'Drama/Action', 'Romantic drama',\n",
       "       'Romantic thriller', 'Comedy/Thriller', 'Biopic', 'Rom-com',\n",
       "       'Avant-garde', 'Erotic/Thriller', 'Crime/Romance',\n",
       "       'Drama/Espionage thriller', 'Political thriller', 'Adult comedy',\n",
       "       'Rom com/Action', 'Suspense thriller',\n",
       "       'Psychological thriller/Romance', 'War comedy', 'Masala',\n",
       "       'Drama/Biography', 'Political/Drama', 'Crime/Drama', 'Superhero',\n",
       "       'Comedy/Crime/Romance', 'Action/Adventure',\n",
       "       'Black Comedy/Thriller', 'Experimental', 'Action - comedy',\n",
       "       'Drama/Social', 'Documentary', 'Drama/Romance', 'Social/Action',\n",
       "       'Horror Comedy', 'Horror/Adult', 'Sci-fi/Comedy', 'Drama/Fantasy',\n",
       "       'Fantasy/Children', 'Musical/Drama', 'Mystery/Thriller/Drama',\n",
       "       'Adult', 'Mystery', 'Comedy/Drama', 'Comedy/Drama/Romance',\n",
       "       'Dance', 'Social satire', 'Political Satire',\n",
       "       'Found footage / Horror', 'Erotica/Thriller', 'Action/romance',\n",
       "       'Comedy/thriller', 'Romantic/comedy', 'Action/drama',\n",
       "       'Romance/thriller', 'Historical drama', 'Crime/drama',\n",
       "       'Romance/drama', 'Political drama', 'Sci fi/thriller',\n",
       "       'Dance/drama', 'Crime/action', 'Thriller/drama', 'Comedy/drama',\n",
       "       'Spoof, comedy, thriller', 'Romance/comedy', 'Social/comedy',\n",
       "       'Action, comedy, drama', 'Drama/thriller', 'Social/drama',\n",
       "       'Crime/comedy', 'Romantic/drama', 'Crime/thriller',\n",
       "       'Adult/thriller', 'Neo-noir', 'War/Thriller', 'Musical drama',\n",
       "       'Biopic/drama', 'Actiom/drama', 'Drama/comedy', 'Satire',\n",
       "       'Action/thriller/romance', 'Action/drama/thriller',\n",
       "       'Adventure, drama', 'Thriller/horror', 'Action/biopic',\n",
       "       'Comedy/romance', 'Sports/drama', 'Sex comedy/horror',\n",
       "       'Road movie', 'Period drama', 'Superhero/Action/comedy',\n",
       "       'Comedy/sports', 'Biopic/sports', 'Drama/romance',\n",
       "       'Supernatural comedy', 'Animation/comedy/adventure',\n",
       "       'Social drama', 'Comedy thriller', 'Drama/action',\n",
       "       'Romantic/erotic', 'Romantic/horror', 'Crime drama',\n",
       "       'Comedy/crime', 'War/drama', 'Romance/action', 'Anthology/drama',\n",
       "       'Political crime thriller', 'Suspense/Mystery', 'Sex/drama',\n",
       "       'Period drama/action', 'Musical/drama', 'Action/crime Thriller',\n",
       "       'Biographic', 'Road film', 'Social/Comedy', 'Erotic thriller',\n",
       "       'Drama/disaster', 'Suspense/thriller', 'Comedy drama',\n",
       "       'Psychological,Thriller', 'Suspense,Thriller', 'drama',\n",
       "       'Comedy,Drama', 'Romantic,Comedy', 'thriller', 'Romantic/ Comedy',\n",
       "       'Satire/ Comedy', 'Action, thriller', 'Romantic,thriller',\n",
       "       'Crime,Drama', 'Horror,Thriller', 'Horror,Comedy',\n",
       "       'Suspense,thriller', 'Romantic,comedy', 'Musical,comedy',\n",
       "       'Crime,Comedy', 'Sports/Drama', 'Action/War',\n",
       "       'Psychological,drama', 'Romantic/Drama', 'Action/Drama/Musical',\n",
       "       'Romance, Social,Drama', 'romance,comedy',\n",
       "       'Comedy, Romance, Drama', 'Action,Thriller',\n",
       "       'Romance,Family,Drama', 'action/adventure', 'Adult-comedy',\n",
       "       'Crime, Drama', 'Biography,Drama', 'comedy',\n",
       "       'Drama/ Coming of Age', 'Romance, comedy', 'Drama /Thriller',\n",
       "       'Social ,Drama', 'Drama/historical', 'Period drama / thriller',\n",
       "       'Drama/ Thriller', 'Action ,Thriller', 'Romance, thriller',\n",
       "       'Family, Drama', 'crime, thriller', 'Romance,drama',\n",
       "       'Horror Thriller', 'Historical/Romance', 'Black Comedy',\n",
       "       'Action/battle', 'Crime,Thriller'], dtype=object)"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies_df.Genre.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Thriller', 'Drama', 'Romance', 'Family', 'Drama, Social',\n",
       "       'Action', 'Action, Drama', 'Comedy, Drama', 'Comedy', 'Horror',\n",
       "       'Action, Romance', 'Romance, Drama', 'Comedy, Romance',\n",
       "       'Drama, Family, Thriller', 'Crime', 'Comedy, Drama, Romance',\n",
       "       'Comedy, romance', 'Romance, Drama, Musical', 'Action, romance',\n",
       "       'Romance, drama', 'Drama, War, Thriller',\n",
       "       'Drama, Romance, Musical, Family',\n",
       "       'Comedy, Drama, Romance, Musical', 'Comedy, Musical',\n",
       "       'Drama, Romance', 'Thriller, Action, Romance',\n",
       "       'Suspense, Thriller', 'Family Drama', 'Action Comedy',\n",
       "       'Thriller, Suspense, Crime', 'Thriller, Horror', 'History',\n",
       "       'Drama, Romance, Social', '', 'Drama, Romance, Musical, Social',\n",
       "       'Drama, Comedy, Romance, Musical', 'Drama, War, Romance, Action',\n",
       "       'Action, Drama, Thriller', 'Drama, Romance, Family',\n",
       "       'Drama, Musical, Social', 'Drama, Romance, Musical, Crime',\n",
       "       'Comedy, Family', 'Drama, Romance, Thriller', 'Historical Drama',\n",
       "       'Thriller, Action', 'Historical', 'Action, Thriller',\n",
       "       'Action, Comedy', \"Children's\", 'Comedy, Romance, Crime',\n",
       "       'Crime, Drama', 'Romance, Drama, Musical, Historical',\n",
       "       'Family, Romance, Drama', 'Erotic', 'Thriller, Romance',\n",
       "       'Thriller, Romance, Musical', 'Fantasy', 'Romance, Drama, Comedy',\n",
       "       'Romance, Drama, Comedy, Musical', 'Family, Drama, Social',\n",
       "       'Action, Crime', 'Horror, Thriller, Romance, Musical',\n",
       "       'Drama, Family', 'Drama, Romance, Social, Musical',\n",
       "       'Historical, Drama', 'Musical', 'Drama, Romance, Comedy, Musical',\n",
       "       'Action, Drama, Romance, Thriller', 'Horror, Thriller',\n",
       "       'Action, Drama, Romance', 'Drama, Action, Thriller',\n",
       "       'Drama, Thriller', 'Drama, Musical',\n",
       "       'Drama, Romance, Comedy, Family, Musical, Social',\n",
       "       'Romance, Fantasy, Musical', 'Drama, Romance, Musical',\n",
       "       'War, Drama, Historical', 'Comedy, Social, Musical', 'Adult',\n",
       "       'War, Drama', 'Mystery, Thriller', 'Romance, Comedy',\n",
       "       'Adult Romance', 'Thriller, Drama', 'Fantasy, Thriller',\n",
       "       'Erotic Romance', 'Comedy, Drama, Romance, Family',\n",
       "       'Comedy, Romance, Drama, Musical', 'Adult Drama', 'Adult Comedy',\n",
       "       'War, Drama, Action, Romance', 'Adult Thriller',\n",
       "       'Action, Musical, Drama, Comedy', 'Mystery, Drama',\n",
       "       'Romance, Musical Drama', 'Action, Comedy, Romance',\n",
       "       'Comedy, Romance, Musical', 'Black Comedy', 'Sports Comedy',\n",
       "       'Romantic, Comedy', 'Fantasy Thriller',\n",
       "       'Drama, Romance, Family, Musical', 'Drama, Action',\n",
       "       'Crime / Thriller', 'Romance, Drama, Family',\n",
       "       'Comedy, Crime, Romance, Musical', 'Erotic Drama',\n",
       "       'Action, Thriller, Suspense', 'Erotic Thriller', 'Romantic Comedy',\n",
       "       'Family drama', 'Sports, Drama, Social', 'Erotic, Crime',\n",
       "       'Erotic romance', 'Drama, Historical', 'Romance, Musical',\n",
       "       'Erotic thriller', 'Fantasy, Romance, Musical',\n",
       "       'Romance, Comedy, Drama, Social', 'History, Epic, Romance',\n",
       "       'Fantasy, Comedy', 'Thriller, Mystery', 'Comedy, Romance, Social',\n",
       "       'Drama, Romance, Crime', 'Comedy, Thriller',\n",
       "       'Action, Sports, Romance', 'Drama, Romance, Family, Social',\n",
       "       'Drama, Comedy', 'Drama, Thriller, Business', 'Comedy, Crime',\n",
       "       'Thriller, Action, Romance, Musical', 'Thriller, Action, Drama',\n",
       "       'Drama, Romance, Thriller, Musical', 'Thriller, Comedy',\n",
       "       'Supensene, Thriller, Sci-fi', 'Drama, Romance, Musical, Comedy',\n",
       "       'Comedy, Adult', 'Social, Adult', 'Drama, Thriller, War',\n",
       "       'Drama, Romance, Musical, Comedy, Family, Social',\n",
       "       'Superhero, Action, Fantasy, Romance, Musical',\n",
       "       'Thriller, Fantasy', 'Drama, Social, Action',\n",
       "       'Drama, Patriotic, Social', 'Social, Thriller', 'B-grade',\n",
       "       'Drama, Romance, Social, Historical', 'War',\n",
       "       'Drama, Thriller, Romance', 'Family, Drama, Sports',\n",
       "       'Mythological', 'Mystery, Thriller, Comedy',\n",
       "       'Action, Drama, Romance, Crime',\n",
       "       'Crime Fiction, Drama, Historical', 'Short Film', 'Sports',\n",
       "       'Romance, Comedy, Drama', 'Family, Drama',\n",
       "       'Thriller, Horror, Romance, Mystery',\n",
       "       'Action, Comedy, Romance, Musical', 'Romance, comedy',\n",
       "       'Drama, Romance, Social, Comedy', 'Action, Patriotic',\n",
       "       'Musical, Drama', 'Romance |', 'Action, Romance, Comedy, Drama',\n",
       "       'Drama, romance', 'Cricket', 'Drama, social, musical, romance',\n",
       "       'Action, crime, drama', 'Romance, drama, social', 'Social',\n",
       "       'History, Romance', 'Social, Drama, History', 'Crime, Thriller',\n",
       "       'action, Romance', 'Drama, action, Crime, Thriller, Romance',\n",
       "       'Comedy, Drama, Fantasy', 'action, Crime, Drama, Thriller',\n",
       "       'Drama, Romance, Fantasy', 'Drama, Mystery, Thriller',\n",
       "       'Drama, Musical, Romance', 'Thriler, Spy', 'Adventure',\n",
       "       'action, Comedy, Crime, Romance', 'Musical, Romance, Thriller',\n",
       "       'Adventure, Drama', 'Horror, Mystery, Romance, Thriller',\n",
       "       'Biography, Drama', 'Superhero, action, Adventure, Fantasy',\n",
       "       'Animation, Family, Romance', 'Comedy, Social',\n",
       "       'Comedy, Drama, Musical, Romance', 'Politics',\n",
       "       'Musical, Drama, Romance, Family', 'Romance, Drama, Romance',\n",
       "       'action, Drama, Mystery, Romance, Thriller', 'Animation',\n",
       "       'Drama, Fantasy, Musical', 'Crime, Drama, Mystery', 'Political',\n",
       "       'Action Thriller', 'Romance, Drama, Social, Comedy',\n",
       "       'Action Thriller, Romance', 'Action, comedy, romance',\n",
       "       'Dark comedy', 'Action thriller', 'Romantic comedy, sports',\n",
       "       'Romantic comedy', 'Musical, social, drama, romance',\n",
       "       'Thriller, romance', 'Comedy, thriller, social', 'Drama, family',\n",
       "       'Epic film', 'Comedy, Crime, Romance', 'Action/Thriller',\n",
       "       'Sports/Social', 'Found footage', 'horror', 'Social/Drama',\n",
       "       'Comedy/Romance/Fantasy', 'Romance/Drama', 'Children/Drama',\n",
       "       'Comedy/Romance', 'Thriller/Romance', 'Drama/Political Thriller',\n",
       "       'Action/Romance', 'Action, Romance, Thriller, Crime',\n",
       "       'Political, Comedy', 'Mystery, Suspense', 'Horror/Thriller',\n",
       "       'Biographical', 'Biographical, Animation', 'Action, Adventure',\n",
       "       'Romance / Thriller', 'Period', 'Comedy / Crime', 'Drama Romance',\n",
       "       'Action comedy', 'Animated', 'Social thriller',\n",
       "       'Adult/Comedy/Romance', 'Comedy/Drama/Action',\n",
       "       'Adult/Romance/Comedy', 'Comedy/Comedy/Comedy', 'Cult',\n",
       "       'Thriller/Black comedy', 'Children', 'Mystery/Action',\n",
       "       'Satire/Comedy/Teen film', 'Superhero/Children', 'Drama/Cult',\n",
       "       'Comedy Road movie', 'Teen/Comedy', 'Romance/Comedy',\n",
       "       'Horror/Romance', 'Action/Drama', 'Psychological thriller',\n",
       "       'Drama/Comedy', 'Drama/Thriller', 'Romance/Teen', 'Action/Comedy',\n",
       "       'Romance/Road', 'Comedy/Social', 'Romance/Action',\n",
       "       'Romantic/Comedy', 'Comedy/Action', 'Romantic',\n",
       "       'Romance Comedy Crime', 'Action/Sci-Fi', 'Action/thriller',\n",
       "       'Comedy/Crime', 'Adult/Horror', 'Adult/Romance/Thriller',\n",
       "       'Suspense/Thriller', 'Adult/Thriller', 'Crime/Thriller',\n",
       "       'Romance/Thriller', 'Adult/Action/Crime', 'Computer-Animated',\n",
       "       'Adult/Romantic', 'Action/comedy', 'Political/Thriller',\n",
       "       'Adult/Crime/Thriller', 'Adult/Comedy', 'Thriller/Social',\n",
       "       'Adult/Suspense/Thriller', 'Adult/Drama', 'Rom-Com',\n",
       "       'Computer Animated', 'Political Thriller', 'Thriller/Crime',\n",
       "       'Musical Comedy', 'Animation/Drama/Children', 'Drama/Suspense',\n",
       "       'Thriller/Drama', 'Romance/Crime', 'Animation/Musical',\n",
       "       'Drama/Family', 'Drama/Dance', 'Satire/Comedy', 'Comedy/Satire',\n",
       "       'Musical romance', 'Anthology', 'Children/Animation',\n",
       "       'Zombie comedy', 'Coming of age', 'Drama/Action', 'Romantic drama',\n",
       "       'Romantic thriller', 'Comedy/Thriller', 'Biopic', 'Rom-com',\n",
       "       'Avant-garde', 'Erotic/Thriller', 'Crime/Romance',\n",
       "       'Drama/Espionage thriller', 'Political thriller', 'Adult comedy',\n",
       "       'Rom com/Action', 'Suspense thriller',\n",
       "       'Psychological thriller/Romance', 'War comedy', 'Masala',\n",
       "       'Drama/Biography', 'Political/Drama', 'Crime/Drama', 'Superhero',\n",
       "       'Comedy/Crime/Romance', 'Action/Adventure',\n",
       "       'Black Comedy/Thriller', 'Experimental', 'Action - comedy',\n",
       "       'Drama/Social', 'Documentary', 'Drama/Romance', 'Social/Action',\n",
       "       'Horror Comedy', 'Horror/Adult', 'Sci-fi/Comedy', 'Drama/Fantasy',\n",
       "       'Fantasy/Children', 'Musical/Drama', 'Mystery/Thriller/Drama',\n",
       "       'Mystery', 'Comedy/Drama', 'Comedy/Drama/Romance', 'Dance',\n",
       "       'Social satire', 'Political Satire', 'Found footage / Horror',\n",
       "       'Erotica/Thriller', 'Action/romance', 'Comedy/thriller',\n",
       "       'Romantic/comedy', 'Action/drama', 'Romance/thriller',\n",
       "       'Historical drama', 'Crime/drama', 'Romance/drama',\n",
       "       'Political drama', 'Sci fi/thriller', 'Dance/drama',\n",
       "       'Crime/action', 'Thriller/drama', 'Comedy/drama',\n",
       "       'Spoof, comedy, thriller', 'Romance/comedy', 'Social/comedy',\n",
       "       'Action, comedy, drama', 'Drama/thriller', 'Social/drama',\n",
       "       'Crime/comedy', 'Romantic/drama', 'Crime/thriller',\n",
       "       'Adult/thriller', 'Neo-noir', 'War/Thriller', 'Musical drama',\n",
       "       'Biopic/drama', 'Actiom/drama', 'Drama/comedy', 'Satire',\n",
       "       'Action/thriller/romance', 'Action/drama/thriller',\n",
       "       'Adventure, drama', 'Thriller/horror', 'Action/biopic',\n",
       "       'Comedy/romance', 'Sports/drama', 'Sex comedy/horror',\n",
       "       'Road movie', 'Period drama', 'Superhero/Action/comedy',\n",
       "       'Comedy/sports', 'Biopic/sports', 'Drama/romance',\n",
       "       'Supernatural comedy', 'Animation/comedy/adventure',\n",
       "       'Social drama', 'Comedy thriller', 'Drama/action',\n",
       "       'Romantic/erotic', 'Romantic/horror', 'Crime drama',\n",
       "       'Comedy/crime', 'War/drama', 'Romance/action', 'Anthology/drama',\n",
       "       'Political crime thriller', 'Suspense/Mystery', 'Sex/drama',\n",
       "       'Period drama/action', 'Musical/drama', 'Action/crime Thriller',\n",
       "       'Biographic', 'Road film', 'Social/Comedy', 'Drama/disaster',\n",
       "       'Suspense/thriller', 'Comedy drama', 'Psychological,Thriller',\n",
       "       'Suspense,Thriller', 'drama', 'Comedy,Drama', 'Romantic,Comedy',\n",
       "       'thriller', 'Romantic/ Comedy', 'Satire/ Comedy',\n",
       "       'Action, thriller', 'Romantic,thriller', 'Crime,Drama',\n",
       "       'Horror,Thriller', 'Horror,Comedy', 'Suspense,thriller',\n",
       "       'Romantic,comedy', 'Musical,comedy', 'Crime,Comedy',\n",
       "       'Sports/Drama', 'Action/War', 'Psychological,drama',\n",
       "       'Romantic/Drama', 'Action/Drama/Musical', 'Romance, Social,Drama',\n",
       "       'romance,comedy', 'Comedy, Romance, Drama', 'Action,Thriller',\n",
       "       'Romance,Family,Drama', 'action/adventure', 'Adult-comedy',\n",
       "       'Biography,Drama', 'comedy', 'Drama/ Coming of Age',\n",
       "       'Drama /Thriller', 'Social ,Drama', 'Drama/historical',\n",
       "       'Period drama / thriller', 'Drama/ Thriller', 'Action ,Thriller',\n",
       "       'Romance, thriller', 'crime, thriller', 'Romance,drama',\n",
       "       'Horror Thriller', 'Historical/Romance', 'Action/battle',\n",
       "       'Crime,Thriller'], dtype=object)"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies_df.Genre=movies_df.Genre.apply(lambda x: x.replace('\\n', ''))\n",
    "movies_df.Genre.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['thriller', 'drama', 'romance', 'family', 'drama, social',\n",
       "       'action', 'action, drama', 'comedy, drama', 'comedy', 'horror',\n",
       "       'action, romance', 'romance, drama', 'comedy, romance',\n",
       "       'drama, family, thriller', 'crime', 'comedy, drama, romance',\n",
       "       'romance, drama, musical', 'drama, war, thriller',\n",
       "       'drama, romance, musical, family',\n",
       "       'comedy, drama, romance, musical', 'comedy, musical',\n",
       "       'drama, romance', 'thriller, action, romance',\n",
       "       'suspense, thriller', 'family drama', 'action comedy',\n",
       "       'thriller, suspense, crime', 'thriller, horror', 'history',\n",
       "       'drama, romance, social', '', 'drama, romance, musical, social',\n",
       "       'drama, comedy, romance, musical', 'drama, war, romance, action',\n",
       "       'action, drama, thriller', 'drama, romance, family',\n",
       "       'drama, musical, social', 'drama, romance, musical, crime',\n",
       "       'comedy, family', 'drama, romance, thriller', 'historical drama',\n",
       "       'thriller, action', 'historical', 'action, thriller',\n",
       "       'action, comedy', \"children's\", 'comedy, romance, crime',\n",
       "       'crime, drama', 'romance, drama, musical, historical',\n",
       "       'family, romance, drama', 'erotic', 'thriller, romance',\n",
       "       'thriller, romance, musical', 'fantasy', 'romance, drama, comedy',\n",
       "       'romance, drama, comedy, musical', 'family, drama, social',\n",
       "       'action, crime', 'horror, thriller, romance, musical',\n",
       "       'drama, family', 'drama, romance, social, musical',\n",
       "       'historical, drama', 'musical', 'drama, romance, comedy, musical',\n",
       "       'action, drama, romance, thriller', 'horror, thriller',\n",
       "       'action, drama, romance', 'drama, action, thriller',\n",
       "       'drama, thriller', 'drama, musical',\n",
       "       'drama, romance, comedy, family, musical, social',\n",
       "       'romance, fantasy, musical', 'drama, romance, musical',\n",
       "       'war, drama, historical', 'comedy, social, musical', 'adult',\n",
       "       'war, drama', 'mystery, thriller', 'romance, comedy',\n",
       "       'adult romance', 'thriller, drama', 'fantasy, thriller',\n",
       "       'erotic romance', 'comedy, drama, romance, family',\n",
       "       'comedy, romance, drama, musical', 'adult drama', 'adult comedy',\n",
       "       'war, drama, action, romance', 'adult thriller',\n",
       "       'action, musical, drama, comedy', 'mystery, drama',\n",
       "       'romance, musical drama', 'action, comedy, romance',\n",
       "       'comedy, romance, musical', 'black comedy', 'sports comedy',\n",
       "       'romantic, comedy', 'fantasy thriller',\n",
       "       'drama, romance, family, musical', 'drama, action',\n",
       "       'crime / thriller', 'romance, drama, family',\n",
       "       'comedy, crime, romance, musical', 'erotic drama',\n",
       "       'action, thriller, suspense', 'erotic thriller', 'romantic comedy',\n",
       "       'sports, drama, social', 'erotic, crime', 'drama, historical',\n",
       "       'romance, musical', 'fantasy, romance, musical',\n",
       "       'romance, comedy, drama, social', 'history, epic, romance',\n",
       "       'fantasy, comedy', 'thriller, mystery', 'comedy, romance, social',\n",
       "       'drama, romance, crime', 'comedy, thriller',\n",
       "       'action, sports, romance', 'drama, romance, family, social',\n",
       "       'drama, comedy', 'drama, thriller, business', 'comedy, crime',\n",
       "       'thriller, action, romance, musical', 'thriller, action, drama',\n",
       "       'drama, romance, thriller, musical', 'thriller, comedy',\n",
       "       'supensene, thriller, sci-fi', 'drama, romance, musical, comedy',\n",
       "       'comedy, adult', 'social, adult', 'drama, thriller, war',\n",
       "       'drama, romance, musical, comedy, family, social',\n",
       "       'superhero, action, fantasy, romance, musical',\n",
       "       'thriller, fantasy', 'drama, social, action',\n",
       "       'drama, patriotic, social', 'social, thriller', 'b-grade',\n",
       "       'drama, romance, social, historical', 'war',\n",
       "       'drama, thriller, romance', 'family, drama, sports',\n",
       "       'mythological', 'mystery, thriller, comedy',\n",
       "       'action, drama, romance, crime',\n",
       "       'crime fiction, drama, historical', 'short film', 'sports',\n",
       "       'romance, comedy, drama', 'family, drama',\n",
       "       'thriller, horror, romance, mystery',\n",
       "       'action, comedy, romance, musical',\n",
       "       'drama, romance, social, comedy', 'action, patriotic',\n",
       "       'musical, drama', 'romance |', 'action, romance, comedy, drama',\n",
       "       'cricket', 'drama, social, musical, romance',\n",
       "       'action, crime, drama', 'romance, drama, social', 'social',\n",
       "       'history, romance', 'social, drama, history', 'crime, thriller',\n",
       "       'drama, action, crime, thriller, romance',\n",
       "       'comedy, drama, fantasy', 'action, crime, drama, thriller',\n",
       "       'drama, romance, fantasy', 'drama, mystery, thriller',\n",
       "       'drama, musical, romance', 'thriler, spy', 'adventure',\n",
       "       'action, comedy, crime, romance', 'musical, romance, thriller',\n",
       "       'adventure, drama', 'horror, mystery, romance, thriller',\n",
       "       'biography, drama', 'superhero, action, adventure, fantasy',\n",
       "       'animation, family, romance', 'comedy, social',\n",
       "       'comedy, drama, musical, romance', 'politics',\n",
       "       'musical, drama, romance, family', 'romance, drama, romance',\n",
       "       'action, drama, mystery, romance, thriller', 'animation',\n",
       "       'drama, fantasy, musical', 'crime, drama, mystery', 'political',\n",
       "       'action thriller', 'romance, drama, social, comedy',\n",
       "       'action thriller, romance', 'dark comedy',\n",
       "       'romantic comedy, sports', 'musical, social, drama, romance',\n",
       "       'comedy, thriller, social', 'epic film', 'comedy, crime, romance',\n",
       "       'action/thriller', 'sports/social', 'found footage',\n",
       "       'social/drama', 'comedy/romance/fantasy', 'romance/drama',\n",
       "       'children/drama', 'comedy/romance', 'thriller/romance',\n",
       "       'drama/political thriller', 'action/romance',\n",
       "       'action, romance, thriller, crime', 'political, comedy',\n",
       "       'mystery, suspense', 'horror/thriller', 'biographical',\n",
       "       'biographical, animation', 'action, adventure',\n",
       "       'romance / thriller', 'period', 'comedy / crime', 'drama romance',\n",
       "       'animated', 'social thriller', 'adult/comedy/romance',\n",
       "       'comedy/drama/action', 'adult/romance/comedy',\n",
       "       'comedy/comedy/comedy', 'cult', 'thriller/black comedy',\n",
       "       'children', 'mystery/action', 'satire/comedy/teen film',\n",
       "       'superhero/children', 'drama/cult', 'comedy road movie',\n",
       "       'teen/comedy', 'romance/comedy', 'horror/romance', 'action/drama',\n",
       "       'psychological thriller', 'drama/comedy', 'drama/thriller',\n",
       "       'romance/teen', 'action/comedy', 'romance/road', 'comedy/social',\n",
       "       'romance/action', 'romantic/comedy', 'comedy/action', 'romantic',\n",
       "       'romance comedy crime', 'action/sci-fi', 'comedy/crime',\n",
       "       'adult/horror', 'adult/romance/thriller', 'suspense/thriller',\n",
       "       'adult/thriller', 'crime/thriller', 'romance/thriller',\n",
       "       'adult/action/crime', 'computer-animated', 'adult/romantic',\n",
       "       'political/thriller', 'adult/crime/thriller', 'adult/comedy',\n",
       "       'thriller/social', 'adult/suspense/thriller', 'adult/drama',\n",
       "       'rom-com', 'computer animated', 'political thriller',\n",
       "       'thriller/crime', 'musical comedy', 'animation/drama/children',\n",
       "       'drama/suspense', 'thriller/drama', 'romance/crime',\n",
       "       'animation/musical', 'drama/family', 'drama/dance',\n",
       "       'satire/comedy', 'comedy/satire', 'musical romance', 'anthology',\n",
       "       'children/animation', 'zombie comedy', 'coming of age',\n",
       "       'drama/action', 'romantic drama', 'romantic thriller',\n",
       "       'comedy/thriller', 'biopic', 'avant-garde', 'erotic/thriller',\n",
       "       'crime/romance', 'drama/espionage thriller', 'rom com/action',\n",
       "       'suspense thriller', 'psychological thriller/romance',\n",
       "       'war comedy', 'masala', 'drama/biography', 'political/drama',\n",
       "       'crime/drama', 'superhero', 'comedy/crime/romance',\n",
       "       'action/adventure', 'black comedy/thriller', 'experimental',\n",
       "       'action - comedy', 'drama/social', 'documentary', 'drama/romance',\n",
       "       'social/action', 'horror comedy', 'horror/adult', 'sci-fi/comedy',\n",
       "       'drama/fantasy', 'fantasy/children', 'musical/drama',\n",
       "       'mystery/thriller/drama', 'mystery', 'comedy/drama',\n",
       "       'comedy/drama/romance', 'dance', 'social satire',\n",
       "       'political satire', 'found footage / horror', 'erotica/thriller',\n",
       "       'political drama', 'sci fi/thriller', 'dance/drama',\n",
       "       'crime/action', 'spoof, comedy, thriller', 'social/comedy',\n",
       "       'action, comedy, drama', 'crime/comedy', 'romantic/drama',\n",
       "       'neo-noir', 'war/thriller', 'musical drama', 'biopic/drama',\n",
       "       'actiom/drama', 'satire', 'action/thriller/romance',\n",
       "       'action/drama/thriller', 'thriller/horror', 'action/biopic',\n",
       "       'sports/drama', 'sex comedy/horror', 'road movie', 'period drama',\n",
       "       'superhero/action/comedy', 'comedy/sports', 'biopic/sports',\n",
       "       'supernatural comedy', 'animation/comedy/adventure',\n",
       "       'social drama', 'comedy thriller', 'romantic/erotic',\n",
       "       'romantic/horror', 'crime drama', 'war/drama', 'anthology/drama',\n",
       "       'political crime thriller', 'suspense/mystery', 'sex/drama',\n",
       "       'period drama/action', 'action/crime thriller', 'biographic',\n",
       "       'road film', 'drama/disaster', 'comedy drama',\n",
       "       'psychological,thriller', 'suspense,thriller', 'comedy,drama',\n",
       "       'romantic,comedy', 'romantic/ comedy', 'satire/ comedy',\n",
       "       'romantic,thriller', 'crime,drama', 'horror,thriller',\n",
       "       'horror,comedy', 'musical,comedy', 'crime,comedy', 'action/war',\n",
       "       'psychological,drama', 'action/drama/musical',\n",
       "       'romance, social,drama', 'romance,comedy',\n",
       "       'comedy, romance, drama', 'action,thriller',\n",
       "       'romance,family,drama', 'adult-comedy', 'biography,drama',\n",
       "       'drama/ coming of age', 'drama /thriller', 'social ,drama',\n",
       "       'drama/historical', 'period drama / thriller', 'drama/ thriller',\n",
       "       'action ,thriller', 'romance, thriller', 'romance,drama',\n",
       "       'horror thriller', 'historical/romance', 'action/battle',\n",
       "       'crime,thriller'], dtype=object)"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies_df.Genre=movies_df.Genre.apply(lambda x: x.lower())\n",
    "movies_df.Genre=movies_df.Genre.apply(lambda x: x.strip())\n",
    "movies_df.Genre.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Movie_ID</th>\n",
       "      <th>Title</th>\n",
       "      <th>Year</th>\n",
       "      <th>Genre</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>34759</td>\n",
       "      <td>Aaghaaz</td>\n",
       "      <td>2000</td>\n",
       "      <td>[thriller]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>34760</td>\n",
       "      <td>Aaj Ka Ravan</td>\n",
       "      <td>2000</td>\n",
       "      <td>[drama]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>34761</td>\n",
       "      <td>Anjaane</td>\n",
       "      <td>2000</td>\n",
       "      <td>[romance]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>34762</td>\n",
       "      <td>Anokha Moti</td>\n",
       "      <td>2000</td>\n",
       "      <td>[family]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>34763</td>\n",
       "      <td>Apradhi Kaun</td>\n",
       "      <td>2000</td>\n",
       "      <td>[thriller]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Movie_ID         Title  Year       Genre\n",
       "0     34759      Aaghaaz   2000  [thriller]\n",
       "1     34760  Aaj Ka Ravan  2000     [drama]\n",
       "2     34761       Anjaane  2000   [romance]\n",
       "3     34762   Anokha Moti  2000    [family]\n",
       "4     34763  Apradhi Kaun  2000  [thriller]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies_df['Genre'] = movies_df.Genre.str.split(',|/')\n",
    "movies_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "movies_df.drop_duplicates(subset =\"Title\", keep = False, inplace = True) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Movie_ID      0\n",
       "Title         0\n",
       "Year          0\n",
       "Genre       152\n",
       "dtype: int64"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies_df.Title = movies_df.Title.apply(lambda x: x.strip())\n",
    "movies_df.Genre = movies_df.Genre.apply(lambda x: np.nan if x==[''] else x)\n",
    "movies_df.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "movies_df.dropna(inplace=True)"
   ]
  },
  {
   "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>Movie_ID</th>\n",
       "      <th>Title</th>\n",
       "      <th>Year</th>\n",
       "      <th>Genre</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>34759</td>\n",
       "      <td>Aaghaaz</td>\n",
       "      <td>2000</td>\n",
       "      <td>[thriller]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>34760</td>\n",
       "      <td>Aaj Ka Ravan</td>\n",
       "      <td>2000</td>\n",
       "      <td>[drama]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>34761</td>\n",
       "      <td>Anjaane</td>\n",
       "      <td>2000</td>\n",
       "      <td>[romance]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>34762</td>\n",
       "      <td>Anokha Moti</td>\n",
       "      <td>2000</td>\n",
       "      <td>[family]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>34763</td>\n",
       "      <td>Apradhi Kaun</td>\n",
       "      <td>2000</td>\n",
       "      <td>[thriller]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2084</th>\n",
       "      <td>36968</td>\n",
       "      <td>Panipat</td>\n",
       "      <td>2019</td>\n",
       "      <td>[action, battle]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2085</th>\n",
       "      <td>36969</td>\n",
       "      <td>Pati, Patni Aur Woh</td>\n",
       "      <td>2019</td>\n",
       "      <td>[comedy]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2086</th>\n",
       "      <td>36970</td>\n",
       "      <td>Mardaani 2</td>\n",
       "      <td>2019</td>\n",
       "      <td>[crime, thriller]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2087</th>\n",
       "      <td>36971</td>\n",
       "      <td>Dabangg 3</td>\n",
       "      <td>2019</td>\n",
       "      <td>[action]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2088</th>\n",
       "      <td>36972</td>\n",
       "      <td>Good News</td>\n",
       "      <td>2019</td>\n",
       "      <td>[comedy]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1883 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Movie_ID                Title  Year              Genre\n",
       "0        34759              Aaghaaz  2000         [thriller]\n",
       "1        34760         Aaj Ka Ravan  2000            [drama]\n",
       "2        34761              Anjaane  2000          [romance]\n",
       "3        34762          Anokha Moti  2000           [family]\n",
       "4        34763         Apradhi Kaun  2000         [thriller]\n",
       "...        ...                  ...   ...                ...\n",
       "2084     36968              Panipat  2019   [action, battle]\n",
       "2085     36969  Pati, Patni Aur Woh  2019           [comedy]\n",
       "2086     36970           Mardaani 2  2019  [crime, thriller]\n",
       "2087     36971            Dabangg 3  2019           [action]\n",
       "2088     36972            Good News  2019           [comedy]\n",
       "\n",
       "[1883 rows x 4 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Movie_ID     int64\n",
       "Title       object\n",
       "Year         int64\n",
       "Genre       object\n",
       "dtype: object"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies_df.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Movie_ID</th>\n",
       "      <th>Title</th>\n",
       "      <th>Year</th>\n",
       "      <th>Genre</th>\n",
       "      <th>thriller</th>\n",
       "      <th>drama</th>\n",
       "      <th>romance</th>\n",
       "      <th>family</th>\n",
       "      <th>social</th>\n",
       "      <th>action</th>\n",
       "      <th>...</th>\n",
       "      <th>sex</th>\n",
       "      <th>crime thriller</th>\n",
       "      <th>biographic</th>\n",
       "      <th>road film</th>\n",
       "      <th>disaster</th>\n",
       "      <th>comedy drama</th>\n",
       "      <th>psychological</th>\n",
       "      <th>adult-comedy</th>\n",
       "      <th>horror thriller</th>\n",
       "      <th>battle</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>34759</td>\n",
       "      <td>Aaghaaz</td>\n",
       "      <td>2000</td>\n",
       "      <td>[thriller]</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>34760</td>\n",
       "      <td>Aaj Ka Ravan</td>\n",
       "      <td>2000</td>\n",
       "      <td>[drama]</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>34761</td>\n",
       "      <td>Anjaane</td>\n",
       "      <td>2000</td>\n",
       "      <td>[romance]</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>34762</td>\n",
       "      <td>Anokha Moti</td>\n",
       "      <td>2000</td>\n",
       "      <td>[family]</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>34763</td>\n",
       "      <td>Apradhi Kaun</td>\n",
       "      <td>2000</td>\n",
       "      <td>[thriller]</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 126 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Movie_ID         Title  Year       Genre  thriller  drama  romance  family  \\\n",
       "0     34759       Aaghaaz  2000  [thriller]       1.0    0.0      0.0     0.0   \n",
       "1     34760  Aaj Ka Ravan  2000     [drama]       0.0    1.0      0.0     0.0   \n",
       "2     34761       Anjaane  2000   [romance]       0.0    0.0      1.0     0.0   \n",
       "3     34762   Anokha Moti  2000    [family]       0.0    0.0      0.0     1.0   \n",
       "4     34763  Apradhi Kaun  2000  [thriller]       1.0    0.0      0.0     0.0   \n",
       "\n",
       "   social  action  ...  sex  crime thriller  biographic  road film  disaster  \\\n",
       "0     0.0     0.0  ...  0.0             0.0         0.0        0.0       0.0   \n",
       "1     0.0     0.0  ...  0.0             0.0         0.0        0.0       0.0   \n",
       "2     0.0     0.0  ...  0.0             0.0         0.0        0.0       0.0   \n",
       "3     0.0     0.0  ...  0.0             0.0         0.0        0.0       0.0   \n",
       "4     0.0     0.0  ...  0.0             0.0         0.0        0.0       0.0   \n",
       "\n",
       "   comedy drama  psychological  adult-comedy  horror thriller  battle  \n",
       "0           0.0            0.0           0.0              0.0     0.0  \n",
       "1           0.0            0.0           0.0              0.0     0.0  \n",
       "2           0.0            0.0           0.0              0.0     0.0  \n",
       "3           0.0            0.0           0.0              0.0     0.0  \n",
       "4           0.0            0.0           0.0              0.0     0.0  \n",
       "\n",
       "[5 rows x 126 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Copying the movie dataframe into a new one since we won't need to use the genre information in our first case.\n",
    "moviesWithGenres_df = movies_df.copy()\n",
    "\n",
    "#For every row in the dataframe, iterate through the list of genres and place a 1 into the corresponding column\n",
    "for index, row in movies_df.iterrows():\n",
    "    for genre in row['Genre']:\n",
    "        moviesWithGenres_df.at[index, genre.strip()] = 1\n",
    "#Filling in the NaN values with 0 to show that a movie doesn't have that column's genre\n",
    "moviesWithGenres_df = moviesWithGenres_df.fillna(0)\n",
    "moviesWithGenres_df.head()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>rating</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Dahshat</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Raaz</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Darna Mana Hai</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Kaal</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Phoonk</td>\n",
       "      <td>6.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1920</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Raaz: The Mystery Continues</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         Title  rating\n",
       "0                      Dahshat     7.0\n",
       "1                         Raaz     8.0\n",
       "2               Darna Mana Hai     8.0\n",
       "3                         Kaal     9.0\n",
       "4                       Phoonk     6.5\n",
       "5                         1920    10.0\n",
       "6  Raaz: The Mystery Continues     8.0"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "userInput = [\n",
    "            {'Title':'Dahshat', 'rating':7},\n",
    "            {'Title':'Raaz', 'rating':8},\n",
    "            {'Title':'Darna Mana Hai', 'rating':8},\n",
    "            {'Title':'Kaal', 'rating':9},\n",
    "            {'Title':'Phoonk', 'rating':6.5},\n",
    "            {'Title':'1920', 'rating':10},\n",
    "            {'Title':\"Raaz: The Mystery Continues\", 'rating':8}\n",
    "         ] \n",
    "inputMovies = pd.DataFrame(userInput)\n",
    "inputMovies"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>rating</th>\n",
       "      <th>Movie_ID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Dahshat</td>\n",
       "      <td>7.0</td>\n",
       "      <td>34776</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Raaz</td>\n",
       "      <td>8.0</td>\n",
       "      <td>34968</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Darna Mana Hai</td>\n",
       "      <td>8.0</td>\n",
       "      <td>35011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Kaal</td>\n",
       "      <td>9.0</td>\n",
       "      <td>35265</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Phoonk</td>\n",
       "      <td>6.5</td>\n",
       "      <td>35606</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1920</td>\n",
       "      <td>10.0</td>\n",
       "      <td>35615</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Raaz: The Mystery Continues</td>\n",
       "      <td>8.0</td>\n",
       "      <td>35657</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         Title  rating  Movie_ID\n",
       "0                      Dahshat     7.0     34776\n",
       "1                         Raaz     8.0     34968\n",
       "2               Darna Mana Hai     8.0     35011\n",
       "3                         Kaal     9.0     35265\n",
       "4                       Phoonk     6.5     35606\n",
       "5                         1920    10.0     35615\n",
       "6  Raaz: The Mystery Continues     8.0     35657"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Filtering out the movies by title\n",
    "inputId = movies_df[movies_df['Title'].isin(inputMovies['Title'].tolist())]\n",
    "inputMovies['Movie_ID'] = inputId['Movie_ID'].values\n",
    "inputMovies"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Movie_ID</th>\n",
       "      <th>Title</th>\n",
       "      <th>Year</th>\n",
       "      <th>Genre</th>\n",
       "      <th>thriller</th>\n",
       "      <th>drama</th>\n",
       "      <th>romance</th>\n",
       "      <th>family</th>\n",
       "      <th>social</th>\n",
       "      <th>action</th>\n",
       "      <th>...</th>\n",
       "      <th>sex</th>\n",
       "      <th>crime thriller</th>\n",
       "      <th>biographic</th>\n",
       "      <th>road film</th>\n",
       "      <th>disaster</th>\n",
       "      <th>comedy drama</th>\n",
       "      <th>psychological</th>\n",
       "      <th>adult-comedy</th>\n",
       "      <th>horror thriller</th>\n",
       "      <th>battle</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>34776</td>\n",
       "      <td>Dahshat</td>\n",
       "      <td>2000</td>\n",
       "      <td>[horror]</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>209</th>\n",
       "      <td>34968</td>\n",
       "      <td>Raaz</td>\n",
       "      <td>2002</td>\n",
       "      <td>[horror,  thriller,  romance,  musical]</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>252</th>\n",
       "      <td>35011</td>\n",
       "      <td>Darna Mana Hai</td>\n",
       "      <td>2003</td>\n",
       "      <td>[horror,  thriller]</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>505</th>\n",
       "      <td>35265</td>\n",
       "      <td>Kaal</td>\n",
       "      <td>2005</td>\n",
       "      <td>[horror,  thriller]</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>833</th>\n",
       "      <td>35606</td>\n",
       "      <td>Phoonk</td>\n",
       "      <td>2008</td>\n",
       "      <td>[horror]</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>842</th>\n",
       "      <td>35615</td>\n",
       "      <td>1920</td>\n",
       "      <td>2008</td>\n",
       "      <td>[horror,  mystery,  romance,  thriller]</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>874</th>\n",
       "      <td>35657</td>\n",
       "      <td>Raaz: The Mystery Continues</td>\n",
       "      <td>2009</td>\n",
       "      <td>[horror]</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7 rows × 126 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Movie_ID                        Title  Year  \\\n",
       "17      34776                      Dahshat  2000   \n",
       "209     34968                         Raaz  2002   \n",
       "252     35011               Darna Mana Hai  2003   \n",
       "505     35265                         Kaal  2005   \n",
       "833     35606                       Phoonk  2008   \n",
       "842     35615                         1920  2008   \n",
       "874     35657  Raaz: The Mystery Continues  2009   \n",
       "\n",
       "                                       Genre  thriller  drama  romance  \\\n",
       "17                                  [horror]       0.0    0.0      0.0   \n",
       "209  [horror,  thriller,  romance,  musical]       1.0    0.0      1.0   \n",
       "252                      [horror,  thriller]       1.0    0.0      0.0   \n",
       "505                      [horror,  thriller]       1.0    0.0      0.0   \n",
       "833                                 [horror]       0.0    0.0      0.0   \n",
       "842  [horror,  mystery,  romance,  thriller]       1.0    0.0      1.0   \n",
       "874                                 [horror]       0.0    0.0      0.0   \n",
       "\n",
       "     family  social  action  ...  sex  crime thriller  biographic  road film  \\\n",
       "17      0.0     0.0     0.0  ...  0.0             0.0         0.0        0.0   \n",
       "209     0.0     0.0     0.0  ...  0.0             0.0         0.0        0.0   \n",
       "252     0.0     0.0     0.0  ...  0.0             0.0         0.0        0.0   \n",
       "505     0.0     0.0     0.0  ...  0.0             0.0         0.0        0.0   \n",
       "833     0.0     0.0     0.0  ...  0.0             0.0         0.0        0.0   \n",
       "842     0.0     0.0     0.0  ...  0.0             0.0         0.0        0.0   \n",
       "874     0.0     0.0     0.0  ...  0.0             0.0         0.0        0.0   \n",
       "\n",
       "     disaster  comedy drama  psychological  adult-comedy  horror thriller  \\\n",
       "17        0.0           0.0            0.0           0.0              0.0   \n",
       "209       0.0           0.0            0.0           0.0              0.0   \n",
       "252       0.0           0.0            0.0           0.0              0.0   \n",
       "505       0.0           0.0            0.0           0.0              0.0   \n",
       "833       0.0           0.0            0.0           0.0              0.0   \n",
       "842       0.0           0.0            0.0           0.0              0.0   \n",
       "874       0.0           0.0            0.0           0.0              0.0   \n",
       "\n",
       "     battle  \n",
       "17      0.0  \n",
       "209     0.0  \n",
       "252     0.0  \n",
       "505     0.0  \n",
       "833     0.0  \n",
       "842     0.0  \n",
       "874     0.0  \n",
       "\n",
       "[7 rows x 126 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#We're going to start by learning the input's preferences, so let's get the subset of movies that the input has watched from the \n",
    "#Dataframe containing genres defined with binary values.\n",
    "\n",
    "#Filtering out the movies from the input\n",
    "userMovies = moviesWithGenres_df[moviesWithGenres_df['Title'].isin(inputMovies['Title'].tolist())]\n",
    "# userMovies = moviesWithGenres_df[moviesWithGenres_df['movieId'].isin(inputMovies['movieId'].tolist())]\n",
    "userMovies\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "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>thriller</th>\n",
       "      <th>drama</th>\n",
       "      <th>romance</th>\n",
       "      <th>family</th>\n",
       "      <th>social</th>\n",
       "      <th>action</th>\n",
       "      <th>comedy</th>\n",
       "      <th>horror</th>\n",
       "      <th>crime</th>\n",
       "      <th>musical</th>\n",
       "      <th>...</th>\n",
       "      <th>sex</th>\n",
       "      <th>crime thriller</th>\n",
       "      <th>biographic</th>\n",
       "      <th>road film</th>\n",
       "      <th>disaster</th>\n",
       "      <th>comedy drama</th>\n",
       "      <th>psychological</th>\n",
       "      <th>adult-comedy</th>\n",
       "      <th>horror thriller</th>\n",
       "      <th>battle</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7 rows × 122 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   thriller  drama  romance  family  social  action  comedy  horror  crime  \\\n",
       "0       0.0    0.0      0.0     0.0     0.0     0.0     0.0     1.0    0.0   \n",
       "1       1.0    0.0      1.0     0.0     0.0     0.0     0.0     1.0    0.0   \n",
       "2       1.0    0.0      0.0     0.0     0.0     0.0     0.0     1.0    0.0   \n",
       "3       1.0    0.0      0.0     0.0     0.0     0.0     0.0     1.0    0.0   \n",
       "4       0.0    0.0      0.0     0.0     0.0     0.0     0.0     1.0    0.0   \n",
       "5       1.0    0.0      1.0     0.0     0.0     0.0     0.0     1.0    0.0   \n",
       "6       0.0    0.0      0.0     0.0     0.0     0.0     0.0     1.0    0.0   \n",
       "\n",
       "   musical  ...  sex  crime thriller  biographic  road film  disaster  \\\n",
       "0      0.0  ...  0.0             0.0         0.0        0.0       0.0   \n",
       "1      1.0  ...  0.0             0.0         0.0        0.0       0.0   \n",
       "2      0.0  ...  0.0             0.0         0.0        0.0       0.0   \n",
       "3      0.0  ...  0.0             0.0         0.0        0.0       0.0   \n",
       "4      0.0  ...  0.0             0.0         0.0        0.0       0.0   \n",
       "5      0.0  ...  0.0             0.0         0.0        0.0       0.0   \n",
       "6      0.0  ...  0.0             0.0         0.0        0.0       0.0   \n",
       "\n",
       "   comedy drama  psychological  adult-comedy  horror thriller  battle  \n",
       "0           0.0            0.0           0.0              0.0     0.0  \n",
       "1           0.0            0.0           0.0              0.0     0.0  \n",
       "2           0.0            0.0           0.0              0.0     0.0  \n",
       "3           0.0            0.0           0.0              0.0     0.0  \n",
       "4           0.0            0.0           0.0              0.0     0.0  \n",
       "5           0.0            0.0           0.0              0.0     0.0  \n",
       "6           0.0            0.0           0.0              0.0     0.0  \n",
       "\n",
       "[7 rows x 122 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#We'll only need the actual genre table, so let's clean this up a bit by resetting the index and dropping the movieId, title, \n",
    "#genres and year columns.\n",
    "\n",
    "#Resetting the index to avoid future issues\n",
    "userMovies = userMovies.reset_index(drop=True)\n",
    "#Dropping unnecessary issues due to save memory and to avoid issues\n",
    "userGenreTable = userMovies.drop(['Movie_ID','Title', 'Year','Genre'], 1)\n",
    "userGenreTable"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>rating</th>\n",
       "      <th>Movie_ID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Dahshat</td>\n",
       "      <td>7.0</td>\n",
       "      <td>34776</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Raaz</td>\n",
       "      <td>8.0</td>\n",
       "      <td>34968</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Darna Mana Hai</td>\n",
       "      <td>8.0</td>\n",
       "      <td>35011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Kaal</td>\n",
       "      <td>9.0</td>\n",
       "      <td>35265</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Phoonk</td>\n",
       "      <td>6.5</td>\n",
       "      <td>35606</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1920</td>\n",
       "      <td>10.0</td>\n",
       "      <td>35615</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Raaz: The Mystery Continues</td>\n",
       "      <td>8.0</td>\n",
       "      <td>35657</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         Title  rating  Movie_ID\n",
       "0                      Dahshat     7.0     34776\n",
       "1                         Raaz     8.0     34968\n",
       "2               Darna Mana Hai     8.0     35011\n",
       "3                         Kaal     9.0     35265\n",
       "4                       Phoonk     6.5     35606\n",
       "5                         1920    10.0     35615\n",
       "6  Raaz: The Mystery Continues     8.0     35657"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "inputMovies"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "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>thriller</th>\n",
       "      <th>drama</th>\n",
       "      <th>romance</th>\n",
       "      <th>family</th>\n",
       "      <th>social</th>\n",
       "      <th>action</th>\n",
       "      <th>comedy</th>\n",
       "      <th>horror</th>\n",
       "      <th>crime</th>\n",
       "      <th>musical</th>\n",
       "      <th>...</th>\n",
       "      <th>sex</th>\n",
       "      <th>crime thriller</th>\n",
       "      <th>biographic</th>\n",
       "      <th>road film</th>\n",
       "      <th>disaster</th>\n",
       "      <th>comedy drama</th>\n",
       "      <th>psychological</th>\n",
       "      <th>adult-comedy</th>\n",
       "      <th>horror thriller</th>\n",
       "      <th>battle</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7 rows × 122 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   thriller  drama  romance  family  social  action  comedy  horror  crime  \\\n",
       "0       0.0    0.0      0.0     0.0     0.0     0.0     0.0     1.0    0.0   \n",
       "1       1.0    0.0      1.0     0.0     0.0     0.0     0.0     1.0    0.0   \n",
       "2       1.0    0.0      0.0     0.0     0.0     0.0     0.0     1.0    0.0   \n",
       "3       1.0    0.0      0.0     0.0     0.0     0.0     0.0     1.0    0.0   \n",
       "4       0.0    0.0      0.0     0.0     0.0     0.0     0.0     1.0    0.0   \n",
       "5       1.0    0.0      1.0     0.0     0.0     0.0     0.0     1.0    0.0   \n",
       "6       0.0    0.0      0.0     0.0     0.0     0.0     0.0     1.0    0.0   \n",
       "\n",
       "   musical  ...  sex  crime thriller  biographic  road film  disaster  \\\n",
       "0      0.0  ...  0.0             0.0         0.0        0.0       0.0   \n",
       "1      1.0  ...  0.0             0.0         0.0        0.0       0.0   \n",
       "2      0.0  ...  0.0             0.0         0.0        0.0       0.0   \n",
       "3      0.0  ...  0.0             0.0         0.0        0.0       0.0   \n",
       "4      0.0  ...  0.0             0.0         0.0        0.0       0.0   \n",
       "5      0.0  ...  0.0             0.0         0.0        0.0       0.0   \n",
       "6      0.0  ...  0.0             0.0         0.0        0.0       0.0   \n",
       "\n",
       "   comedy drama  psychological  adult-comedy  horror thriller  battle  \n",
       "0           0.0            0.0           0.0              0.0     0.0  \n",
       "1           0.0            0.0           0.0              0.0     0.0  \n",
       "2           0.0            0.0           0.0              0.0     0.0  \n",
       "3           0.0            0.0           0.0              0.0     0.0  \n",
       "4           0.0            0.0           0.0              0.0     0.0  \n",
       "5           0.0            0.0           0.0              0.0     0.0  \n",
       "6           0.0            0.0           0.0              0.0     0.0  \n",
       "\n",
       "[7 rows x 122 columns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "userGenreTable"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "thriller           35.0\n",
       "drama               0.0\n",
       "romance            18.0\n",
       "family              0.0\n",
       "social              0.0\n",
       "                   ... \n",
       "comedy drama        0.0\n",
       "psychological       0.0\n",
       "adult-comedy        0.0\n",
       "horror thriller     0.0\n",
       "battle              0.0\n",
       "Length: 122, dtype: float64"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "#Dot produt to get weights\n",
    "userProfile = userGenreTable.transpose().dot(inputMovies['rating'])\n",
    "#The user profile\n",
    "userProfile\n",
    "# inputMovies['rating']\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "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>thriller</th>\n",
       "      <th>drama</th>\n",
       "      <th>romance</th>\n",
       "      <th>family</th>\n",
       "      <th>social</th>\n",
       "      <th>action</th>\n",
       "      <th>comedy</th>\n",
       "      <th>horror</th>\n",
       "      <th>crime</th>\n",
       "      <th>musical</th>\n",
       "      <th>...</th>\n",
       "      <th>sex</th>\n",
       "      <th>crime thriller</th>\n",
       "      <th>biographic</th>\n",
       "      <th>road film</th>\n",
       "      <th>disaster</th>\n",
       "      <th>comedy drama</th>\n",
       "      <th>psychological</th>\n",
       "      <th>adult-comedy</th>\n",
       "      <th>horror thriller</th>\n",
       "      <th>battle</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Movie_ID</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>34759</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34760</th>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34761</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34762</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34763</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 122 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          thriller  drama  romance  family  social  action  comedy  horror  \\\n",
       "Movie_ID                                                                     \n",
       "34759          1.0    0.0      0.0     0.0     0.0     0.0     0.0     0.0   \n",
       "34760          0.0    1.0      0.0     0.0     0.0     0.0     0.0     0.0   \n",
       "34761          0.0    0.0      1.0     0.0     0.0     0.0     0.0     0.0   \n",
       "34762          0.0    0.0      0.0     1.0     0.0     0.0     0.0     0.0   \n",
       "34763          1.0    0.0      0.0     0.0     0.0     0.0     0.0     0.0   \n",
       "\n",
       "          crime  musical  ...  sex  crime thriller  biographic  road film  \\\n",
       "Movie_ID                  ...                                               \n",
       "34759       0.0      0.0  ...  0.0             0.0         0.0        0.0   \n",
       "34760       0.0      0.0  ...  0.0             0.0         0.0        0.0   \n",
       "34761       0.0      0.0  ...  0.0             0.0         0.0        0.0   \n",
       "34762       0.0      0.0  ...  0.0             0.0         0.0        0.0   \n",
       "34763       0.0      0.0  ...  0.0             0.0         0.0        0.0   \n",
       "\n",
       "          disaster  comedy drama  psychological  adult-comedy  \\\n",
       "Movie_ID                                                        \n",
       "34759          0.0           0.0            0.0           0.0   \n",
       "34760          0.0           0.0            0.0           0.0   \n",
       "34761          0.0           0.0            0.0           0.0   \n",
       "34762          0.0           0.0            0.0           0.0   \n",
       "34763          0.0           0.0            0.0           0.0   \n",
       "\n",
       "          horror thriller  battle  \n",
       "Movie_ID                           \n",
       "34759                 0.0     0.0  \n",
       "34760                 0.0     0.0  \n",
       "34761                 0.0     0.0  \n",
       "34762                 0.0     0.0  \n",
       "34763                 0.0     0.0  \n",
       "\n",
       "[5 rows x 122 columns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Now let's get the genres of every movie in our original dataframe\n",
    "genreTable = moviesWithGenres_df.set_index(moviesWithGenres_df['Movie_ID'])\n",
    "#And drop the unnecessary information\n",
    "genreTable = genreTable.drop(['Movie_ID','Title', 'Year','Genre'], 1)\n",
    "genreTable.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "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>thriller</th>\n",
       "      <th>drama</th>\n",
       "      <th>romance</th>\n",
       "      <th>family</th>\n",
       "      <th>social</th>\n",
       "      <th>action</th>\n",
       "      <th>comedy</th>\n",
       "      <th>horror</th>\n",
       "      <th>crime</th>\n",
       "      <th>musical</th>\n",
       "      <th>...</th>\n",
       "      <th>sex</th>\n",
       "      <th>crime thriller</th>\n",
       "      <th>biographic</th>\n",
       "      <th>road film</th>\n",
       "      <th>disaster</th>\n",
       "      <th>comedy drama</th>\n",
       "      <th>psychological</th>\n",
       "      <th>adult-comedy</th>\n",
       "      <th>horror thriller</th>\n",
       "      <th>battle</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Movie_ID</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>34759</th>\n",
       "      <td>35.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34760</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34761</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34762</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34763</th>\n",
       "      <td>35.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36968</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36969</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36970</th>\n",
       "      <td>35.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36971</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36972</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1883 rows × 122 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          thriller  drama  romance  family  social  action  comedy  horror  \\\n",
       "Movie_ID                                                                     \n",
       "34759         35.0    0.0      0.0     0.0     0.0     0.0     0.0     0.0   \n",
       "34760          0.0    0.0      0.0     0.0     0.0     0.0     0.0     0.0   \n",
       "34761          0.0    0.0     18.0     0.0     0.0     0.0     0.0     0.0   \n",
       "34762          0.0    0.0      0.0     0.0     0.0     0.0     0.0     0.0   \n",
       "34763         35.0    0.0      0.0     0.0     0.0     0.0     0.0     0.0   \n",
       "...            ...    ...      ...     ...     ...     ...     ...     ...   \n",
       "36968          0.0    0.0      0.0     0.0     0.0     0.0     0.0     0.0   \n",
       "36969          0.0    0.0      0.0     0.0     0.0     0.0     0.0     0.0   \n",
       "36970         35.0    0.0      0.0     0.0     0.0     0.0     0.0     0.0   \n",
       "36971          0.0    0.0      0.0     0.0     0.0     0.0     0.0     0.0   \n",
       "36972          0.0    0.0      0.0     0.0     0.0     0.0     0.0     0.0   \n",
       "\n",
       "          crime  musical  ...  sex  crime thriller  biographic  road film  \\\n",
       "Movie_ID                  ...                                               \n",
       "34759       0.0      0.0  ...  0.0             0.0         0.0        0.0   \n",
       "34760       0.0      0.0  ...  0.0             0.0         0.0        0.0   \n",
       "34761       0.0      0.0  ...  0.0             0.0         0.0        0.0   \n",
       "34762       0.0      0.0  ...  0.0             0.0         0.0        0.0   \n",
       "34763       0.0      0.0  ...  0.0             0.0         0.0        0.0   \n",
       "...         ...      ...  ...  ...             ...         ...        ...   \n",
       "36968       0.0      0.0  ...  0.0             0.0         0.0        0.0   \n",
       "36969       0.0      0.0  ...  0.0             0.0         0.0        0.0   \n",
       "36970       0.0      0.0  ...  0.0             0.0         0.0        0.0   \n",
       "36971       0.0      0.0  ...  0.0             0.0         0.0        0.0   \n",
       "36972       0.0      0.0  ...  0.0             0.0         0.0        0.0   \n",
       "\n",
       "          disaster  comedy drama  psychological  adult-comedy  \\\n",
       "Movie_ID                                                        \n",
       "34759          0.0           0.0            0.0           0.0   \n",
       "34760          0.0           0.0            0.0           0.0   \n",
       "34761          0.0           0.0            0.0           0.0   \n",
       "34762          0.0           0.0            0.0           0.0   \n",
       "34763          0.0           0.0            0.0           0.0   \n",
       "...            ...           ...            ...           ...   \n",
       "36968          0.0           0.0            0.0           0.0   \n",
       "36969          0.0           0.0            0.0           0.0   \n",
       "36970          0.0           0.0            0.0           0.0   \n",
       "36971          0.0           0.0            0.0           0.0   \n",
       "36972          0.0           0.0            0.0           0.0   \n",
       "\n",
       "          horror thriller  battle  \n",
       "Movie_ID                           \n",
       "34759                 0.0     0.0  \n",
       "34760                 0.0     0.0  \n",
       "34761                 0.0     0.0  \n",
       "34762                 0.0     0.0  \n",
       "34763                 0.0     0.0  \n",
       "...                   ...     ...  \n",
       "36968                 0.0     0.0  \n",
       "36969                 0.0     0.0  \n",
       "36970                 0.0     0.0  \n",
       "36971                 0.0     0.0  \n",
       "36972                 0.0     0.0  \n",
       "\n",
       "[1883 rows x 122 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "genreTable*userProfile"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Movie_ID\n",
       "34759    35.0\n",
       "34760     0.0\n",
       "34761    18.0\n",
       "34762     0.0\n",
       "34763    35.0\n",
       "         ... \n",
       "36968     0.0\n",
       "36969     0.0\n",
       "36970    35.0\n",
       "36971     0.0\n",
       "36972     0.0\n",
       "Length: 1883, dtype: float64"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "(genreTable*userProfile).sum(axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Movie_ID\n",
       "34759    0.274510\n",
       "34760    0.000000\n",
       "34761    0.141176\n",
       "34762    0.000000\n",
       "34763    0.274510\n",
       "           ...   \n",
       "36968    0.000000\n",
       "36969    0.000000\n",
       "36970    0.274510\n",
       "36971    0.000000\n",
       "36972    0.000000\n",
       "Length: 1883, dtype: float64"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "((genreTable*userProfile).sum(axis=1))/(userProfile.sum())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Movie_ID\n",
       "34759    0.274510\n",
       "34760    0.000000\n",
       "34761    0.141176\n",
       "34762    0.000000\n",
       "34763    0.274510\n",
       "dtype: float64"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "#Multiply the genres by the weights and then take the weighted average\n",
    "recommendationTable_df = ((genreTable*userProfile).sum(axis=1))/(userProfile.sum())\n",
    "recommendationTable_df.head()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Movie_ID\n",
       "35474    0.937255\n",
       "35615    0.937255\n",
       "34968    0.921569\n",
       "36814    0.717647\n",
       "35011    0.717647\n",
       "35293    0.717647\n",
       "35265    0.717647\n",
       "35416    0.717647\n",
       "36831    0.717647\n",
       "34845    0.717647\n",
       "35854    0.717647\n",
       "36580    0.717647\n",
       "35931    0.584314\n",
       "35643    0.494118\n",
       "35611    0.478431\n",
       "35365    0.478431\n",
       "35375    0.478431\n",
       "35373    0.478431\n",
       "34937    0.478431\n",
       "35657    0.443137\n",
       "dtype: float64"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Sort our recommendations in descending order\n",
    "recommendationTable_df = recommendationTable_df.sort_values(ascending=False)\n",
    "#Just a peek at the values\n",
    "recommendationTable_df.head(20)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Int64Index([35474, 35615, 34968, 36814, 35011, 35293, 35265, 35416, 36831,\n",
       "            34845],\n",
       "           dtype='int64', name='Movie_ID')"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "recommendationTable_df.head(10).keys()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Movie_ID</th>\n",
       "      <th>Title</th>\n",
       "      <th>Year</th>\n",
       "      <th>Genre</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>34845</td>\n",
       "      <td>Aks</td>\n",
       "      <td>2001</td>\n",
       "      <td>[thriller,  horror]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>209</th>\n",
       "      <td>34968</td>\n",
       "      <td>Raaz</td>\n",
       "      <td>2002</td>\n",
       "      <td>[horror,  thriller,  romance,  musical]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>252</th>\n",
       "      <td>35011</td>\n",
       "      <td>Darna Mana Hai</td>\n",
       "      <td>2003</td>\n",
       "      <td>[horror,  thriller]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>505</th>\n",
       "      <td>35265</td>\n",
       "      <td>Kaal</td>\n",
       "      <td>2005</td>\n",
       "      <td>[horror,  thriller]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>533</th>\n",
       "      <td>35293</td>\n",
       "      <td>Naina</td>\n",
       "      <td>2005</td>\n",
       "      <td>[horror,  thriller]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>655</th>\n",
       "      <td>35416</td>\n",
       "      <td>Sacred Evil  A True Story</td>\n",
       "      <td>2006</td>\n",
       "      <td>[horror,  thriller]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>712</th>\n",
       "      <td>35474</td>\n",
       "      <td>Darling</td>\n",
       "      <td>2007</td>\n",
       "      <td>[thriller,  horror,  romance,  mystery]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>842</th>\n",
       "      <td>35615</td>\n",
       "      <td>1920</td>\n",
       "      <td>2008</td>\n",
       "      <td>[horror,  mystery,  romance,  thriller]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1930</th>\n",
       "      <td>36814</td>\n",
       "      <td>The Past</td>\n",
       "      <td>2018</td>\n",
       "      <td>[horror, thriller]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1947</th>\n",
       "      <td>36831</td>\n",
       "      <td>Ekta</td>\n",
       "      <td>2018</td>\n",
       "      <td>[horror, thriller]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Movie_ID                       Title  Year  \\\n",
       "86       34845                         Aks  2001   \n",
       "209      34968                        Raaz  2002   \n",
       "252      35011              Darna Mana Hai  2003   \n",
       "505      35265                        Kaal  2005   \n",
       "533      35293                       Naina  2005   \n",
       "655      35416  Sacred Evil  A True Story  2006   \n",
       "712      35474                     Darling  2007   \n",
       "842      35615                        1920  2008   \n",
       "1930     36814                    The Past  2018   \n",
       "1947     36831                        Ekta  2018   \n",
       "\n",
       "                                        Genre  \n",
       "86                        [thriller,  horror]  \n",
       "209   [horror,  thriller,  romance,  musical]  \n",
       "252                       [horror,  thriller]  \n",
       "505                       [horror,  thriller]  \n",
       "533                       [horror,  thriller]  \n",
       "655                       [horror,  thriller]  \n",
       "712   [thriller,  horror,  romance,  mystery]  \n",
       "842   [horror,  mystery,  romance,  thriller]  \n",
       "1930                       [horror, thriller]  \n",
       "1947                       [horror, thriller]  "
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#The final recommendation table\n",
    "movies_df.loc[movies_df['Movie_ID'].isin(recommendationTable_df.head(10).keys())]"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.6"
  },
  "pycharm": {
   "stem_cell": {
    "cell_type": "raw",
    "metadata": {
     "collapsed": false
    },
    "source": []
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}