Building_Recommender_System.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Building Recommender System"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Simple Recommender Engine menawarkan rekomendasi yang umum untuk semua user berdasarkan popularitas film dan terkadang genre.\n",
    "\n",
    "Ide awal di balik sistem rekomendasi ini adalah sebagai berikut.\n",
    "\n",
    "- Film-film yang lebih populer akan memiliki kemungkinan yang lebih besar untuk disukai juga oleh rata-rata penonton.\n",
    "- Model ini tidak memberikan rekomendasi yang personal untuk setiap tipe user. \n",
    "- Implementasi model ini pun juga bisa dibilang cukup mudah, yang perlu kita lakukan hanyalah mengurutkan film-film tersebut berdasarkan rating dan popularitas dan menunjukkan film teratas dari list film tersebut.\n",
    "\n",
    "Sebagai tambahan, kita dapat menambahkan genre untuk mendapatkan film teratas untuk genre spesifik tersebut"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Formula dari IMDB dengan Weighted Rating"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Weighted Rating (WR) = ((v/v+m)*R) + ((v/v+m) *C)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "dimana,\n",
    "\n",
    "- v: jumlah votes untuk film tersebut\n",
    "- m: jumlah minimum votes yang dibutuhkan supaya dapat masuk dalam chart\n",
    "- R: rata-rata rating dari film tersebut\n",
    "- C: rata-rata jumlah votes dari seluruh semesta film"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "#import library\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "pd.set_option('display.max_columns', None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "#pembacaan dataset\n",
    "movie_df = pd.read_csv('https://storage.googleapis.com/dqlab-dataset/title.basics.tsv', sep='\\t') #untuk menyimpan title_basics.tsv\n",
    "rating_df = pd.read_csv('https://storage.googleapis.com/dqlab-dataset/title.ratings.tsv', sep='\\t') #untuk menyimpan title.ratings.tsv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>tconst</th>\n",
       "      <th>titleType</th>\n",
       "      <th>primaryTitle</th>\n",
       "      <th>originalTitle</th>\n",
       "      <th>isAdult</th>\n",
       "      <th>startYear</th>\n",
       "      <th>endYear</th>\n",
       "      <th>runtimeMinutes</th>\n",
       "      <th>genres</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>tt0221078</td>\n",
       "      <td>short</td>\n",
       "      <td>Circle Dance, Ute Indians</td>\n",
       "      <td>Circle Dance, Ute Indians</td>\n",
       "      <td>0</td>\n",
       "      <td>1898</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>Documentary,Short</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>tt8862466</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>¡El #TeamOsos va con todo al \"Reality del amor\"!</td>\n",
       "      <td>¡El #TeamOsos va con todo al \"Reality del amor\"!</td>\n",
       "      <td>0</td>\n",
       "      <td>2018</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>Comedy,Drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>tt7157720</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Episode #3.41</td>\n",
       "      <td>Episode #3.41</td>\n",
       "      <td>0</td>\n",
       "      <td>2016</td>\n",
       "      <td>\\N</td>\n",
       "      <td>29</td>\n",
       "      <td>Comedy,Game-Show</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>tt2974998</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Episode dated 16 May 1987</td>\n",
       "      <td>Episode dated 16 May 1987</td>\n",
       "      <td>0</td>\n",
       "      <td>1987</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>News</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>tt2903620</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Frances Bavier: Aunt Bee Retires</td>\n",
       "      <td>Frances Bavier: Aunt Bee Retires</td>\n",
       "      <td>0</td>\n",
       "      <td>1973</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>Documentary</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      tconst  titleType                                      primaryTitle  \\\n",
       "0  tt0221078      short                         Circle Dance, Ute Indians   \n",
       "1  tt8862466  tvEpisode  ¡El #TeamOsos va con todo al \"Reality del amor\"!   \n",
       "2  tt7157720  tvEpisode                                     Episode #3.41   \n",
       "3  tt2974998  tvEpisode                         Episode dated 16 May 1987   \n",
       "4  tt2903620  tvEpisode                  Frances Bavier: Aunt Bee Retires   \n",
       "\n",
       "                                      originalTitle  isAdult startYear  \\\n",
       "0                         Circle Dance, Ute Indians        0      1898   \n",
       "1  ¡El #TeamOsos va con todo al \"Reality del amor\"!        0      2018   \n",
       "2                                     Episode #3.41        0      2016   \n",
       "3                         Episode dated 16 May 1987        0      1987   \n",
       "4                  Frances Bavier: Aunt Bee Retires        0      1973   \n",
       "\n",
       "  endYear runtimeMinutes             genres  \n",
       "0      \\N             \\N  Documentary,Short  \n",
       "1      \\N             \\N       Comedy,Drama  \n",
       "2      \\N             29   Comedy,Game-Show  \n",
       "3      \\N             \\N               News  \n",
       "4      \\N             \\N        Documentary  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Menampilkan 5 data teratas tabel movie\n",
    "movie_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 9025 entries, 0 to 9024\n",
      "Data columns (total 9 columns):\n",
      " #   Column          Non-Null Count  Dtype \n",
      "---  ------          --------------  ----- \n",
      " 0   tconst          9025 non-null   object\n",
      " 1   titleType       9025 non-null   object\n",
      " 2   primaryTitle    9011 non-null   object\n",
      " 3   originalTitle   9011 non-null   object\n",
      " 4   isAdult         9025 non-null   int64 \n",
      " 5   startYear       9025 non-null   object\n",
      " 6   endYear         9025 non-null   object\n",
      " 7   runtimeMinutes  9025 non-null   object\n",
      " 8   genres          9014 non-null   object\n",
      "dtypes: int64(1), object(8)\n",
      "memory usage: 634.7+ KB\n"
     ]
    }
   ],
   "source": [
    "#Mengecek tipe data dan informasi lainnya dari setiap kolom pada table movie\n",
    "movie_df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "tconst             0\n",
       "titleType          0\n",
       "primaryTitle      14\n",
       "originalTitle     14\n",
       "isAdult            0\n",
       "startYear          0\n",
       "endYear            0\n",
       "runtimeMinutes     0\n",
       "genres            11\n",
       "dtype: int64"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#pengecekan data dengan nilai NULL pada table movie\n",
    "movie_df.isnull().sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Dari hasil pengecekan nilai NULL yang sudah dilakukan diketahui bahwa kolom 'primaryTitle' dan 'originalTitle' memiliki banyak data yang bernilai NULL.\n",
    "\n",
    "Hal selanjutnya yang akan kita lakukan adalah melakukan pengecekan terhadap bentuk data dari kolom primaryTitle dan originalTitle yang bernilai NULL. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>tconst</th>\n",
       "      <th>titleType</th>\n",
       "      <th>primaryTitle</th>\n",
       "      <th>originalTitle</th>\n",
       "      <th>isAdult</th>\n",
       "      <th>startYear</th>\n",
       "      <th>endYear</th>\n",
       "      <th>runtimeMinutes</th>\n",
       "      <th>genres</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>9000</th>\n",
       "      <td>tt10790040</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2019</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9001</th>\n",
       "      <td>tt10891902</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2020</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>Crime</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9002</th>\n",
       "      <td>tt11737860</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2020</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>Comedy,Drama,Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9003</th>\n",
       "      <td>tt11737862</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2020</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>Comedy,Drama,Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9004</th>\n",
       "      <td>tt11737866</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2020</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>Comedy,Drama,Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9005</th>\n",
       "      <td>tt11737872</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2020</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9006</th>\n",
       "      <td>tt11737874</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2020</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>Comedy,Drama,Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9007</th>\n",
       "      <td>tt1971246</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2011</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>Biography</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9008</th>\n",
       "      <td>tt2067043</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>1965</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>Music</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9009</th>\n",
       "      <td>tt4404732</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2015</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>Comedy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9010</th>\n",
       "      <td>tt5773048</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2015</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>Talk-Show</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9011</th>\n",
       "      <td>tt8473688</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>1987</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>Drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9012</th>\n",
       "      <td>tt8541336</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2018</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>Reality-TV,Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9013</th>\n",
       "      <td>tt9824302</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2016</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>Documentary</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          tconst  titleType primaryTitle originalTitle  isAdult startYear  \\\n",
       "9000  tt10790040  tvEpisode          NaN           NaN        0      2019   \n",
       "9001  tt10891902  tvEpisode          NaN           NaN        0      2020   \n",
       "9002  tt11737860  tvEpisode          NaN           NaN        0      2020   \n",
       "9003  tt11737862  tvEpisode          NaN           NaN        0      2020   \n",
       "9004  tt11737866  tvEpisode          NaN           NaN        0      2020   \n",
       "9005  tt11737872  tvEpisode          NaN           NaN        0      2020   \n",
       "9006  tt11737874  tvEpisode          NaN           NaN        0      2020   \n",
       "9007   tt1971246  tvEpisode          NaN           NaN        0      2011   \n",
       "9008   tt2067043  tvEpisode          NaN           NaN        0      1965   \n",
       "9009   tt4404732  tvEpisode          NaN           NaN        0      2015   \n",
       "9010   tt5773048  tvEpisode          NaN           NaN        0      2015   \n",
       "9011   tt8473688  tvEpisode          NaN           NaN        0      1987   \n",
       "9012   tt8541336  tvEpisode          NaN           NaN        0      2018   \n",
       "9013   tt9824302  tvEpisode          NaN           NaN        0      2016   \n",
       "\n",
       "     endYear runtimeMinutes                genres  \n",
       "9000      \\N             \\N                    \\N  \n",
       "9001      \\N             \\N                 Crime  \n",
       "9002      \\N             \\N  Comedy,Drama,Romance  \n",
       "9003      \\N             \\N  Comedy,Drama,Romance  \n",
       "9004      \\N             \\N  Comedy,Drama,Romance  \n",
       "9005      \\N             \\N                    \\N  \n",
       "9006      \\N             \\N  Comedy,Drama,Romance  \n",
       "9007      \\N             \\N             Biography  \n",
       "9008      \\N             \\N                 Music  \n",
       "9009      \\N             \\N                Comedy  \n",
       "9010      \\N             \\N             Talk-Show  \n",
       "9011      \\N             \\N                 Drama  \n",
       "9012      \\N             \\N    Reality-TV,Romance  \n",
       "9013      \\N             \\N           Documentary  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Analisis kolom dengan data bernilai NULL table Movie\n",
    "movie_df.loc[(movie_df['primaryTitle'].isnull())|(movie_df['originalTitle'].isnull())]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "9011"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Membuang data dengan nilai NULL\n",
    "\n",
    "#mengupdate movie_df dengan membuang data-data bernilai NULL\n",
    "movie_df = movie_df.loc[(movie_df['primaryTitle'].notnull())&(movie_df['originalTitle'].notnull())]\n",
    "\n",
    "#menampilkan jumlah data setelah data dengan nilai NULL dibuang\n",
    "len(movie_df)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#Analisis kolom dengan data bernilai NULL.\n",
    "\n",
    "Selain kolom 'primaryTitle' dan 'originalTitle',masih terdapat kolom lain yang memiliki data bernilai NULL. Kolom tersebut adalah kolom 'genres'\n",
    "\n",
    "Selanjutnya, kita akan melakukan hal yang sama seperti yang sudah kita lakukan pada kolom 'primaryTitle' dan 'originalTitle'.\n",
    "\n",
    "Lakukan pengecekan terhadap bentuk data dari kolom genres yang bernilai NULL. "
   ]
  },
  {
   "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>tconst</th>\n",
       "      <th>titleType</th>\n",
       "      <th>primaryTitle</th>\n",
       "      <th>originalTitle</th>\n",
       "      <th>isAdult</th>\n",
       "      <th>startYear</th>\n",
       "      <th>endYear</th>\n",
       "      <th>runtimeMinutes</th>\n",
       "      <th>genres</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>9014</th>\n",
       "      <td>tt10233364</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Rolling in the Deep Dish\\tRolling in the Deep ...</td>\n",
       "      <td>0</td>\n",
       "      <td>2019</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>Reality-TV</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9015</th>\n",
       "      <td>tt10925142</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>The IMDb Show on Location: Star Wars Galaxy's ...</td>\n",
       "      <td>0</td>\n",
       "      <td>2019</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>Talk-Show</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9016</th>\n",
       "      <td>tt10970874</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Die Bauhaus-Stadt Tel Aviv - Vorbild für die M...</td>\n",
       "      <td>0</td>\n",
       "      <td>2019</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9017</th>\n",
       "      <td>tt11670006</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>...ein angenehmer Unbequemer...\\t...ein angene...</td>\n",
       "      <td>0</td>\n",
       "      <td>1981</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>Documentary</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9018</th>\n",
       "      <td>tt11868642</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>GGN Heavyweight Championship Lungs With Mike T...</td>\n",
       "      <td>0</td>\n",
       "      <td>2020</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>Talk-Show</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9019</th>\n",
       "      <td>tt2347742</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>No sufras por la alergia esta primavera\\tNo su...</td>\n",
       "      <td>0</td>\n",
       "      <td>2004</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9020</th>\n",
       "      <td>tt3984412</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>I'm Not Going to Come Last, I'm Just Going to ...</td>\n",
       "      <td>0</td>\n",
       "      <td>2014</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>Reality-TV</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9021</th>\n",
       "      <td>tt8740950</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Weight Loss Resolution Restart - Ins &amp; Outs of...</td>\n",
       "      <td>0</td>\n",
       "      <td>2015</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>Reality-TV</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9022</th>\n",
       "      <td>tt9822816</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Zwischen Vertuschung und Aufklärung - Missbrau...</td>\n",
       "      <td>0</td>\n",
       "      <td>2019</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9023</th>\n",
       "      <td>tt9900062</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>The Direction of Yuu's Love: Hings Aren't Goin...</td>\n",
       "      <td>0</td>\n",
       "      <td>1994</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>Animation,Comedy,Drama</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9024</th>\n",
       "      <td>tt9909210</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Politik und/oder Moral - Wie weit geht das Ver...</td>\n",
       "      <td>0</td>\n",
       "      <td>2005</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          tconst  titleType  \\\n",
       "9014  tt10233364  tvEpisode   \n",
       "9015  tt10925142  tvEpisode   \n",
       "9016  tt10970874  tvEpisode   \n",
       "9017  tt11670006  tvEpisode   \n",
       "9018  tt11868642  tvEpisode   \n",
       "9019   tt2347742  tvEpisode   \n",
       "9020   tt3984412  tvEpisode   \n",
       "9021   tt8740950  tvEpisode   \n",
       "9022   tt9822816  tvEpisode   \n",
       "9023   tt9900062  tvEpisode   \n",
       "9024   tt9909210  tvEpisode   \n",
       "\n",
       "                                           primaryTitle originalTitle  \\\n",
       "9014  Rolling in the Deep Dish\\tRolling in the Deep ...             0   \n",
       "9015  The IMDb Show on Location: Star Wars Galaxy's ...             0   \n",
       "9016  Die Bauhaus-Stadt Tel Aviv - Vorbild für die M...             0   \n",
       "9017  ...ein angenehmer Unbequemer...\\t...ein angene...             0   \n",
       "9018  GGN Heavyweight Championship Lungs With Mike T...             0   \n",
       "9019  No sufras por la alergia esta primavera\\tNo su...             0   \n",
       "9020  I'm Not Going to Come Last, I'm Just Going to ...             0   \n",
       "9021  Weight Loss Resolution Restart - Ins & Outs of...             0   \n",
       "9022  Zwischen Vertuschung und Aufklärung - Missbrau...             0   \n",
       "9023  The Direction of Yuu's Love: Hings Aren't Goin...             0   \n",
       "9024  Politik und/oder Moral - Wie weit geht das Ver...             0   \n",
       "\n",
       "      isAdult startYear endYear          runtimeMinutes genres  \n",
       "9014     2019        \\N      \\N              Reality-TV    NaN  \n",
       "9015     2019        \\N      \\N               Talk-Show    NaN  \n",
       "9016     2019        \\N      \\N                      \\N    NaN  \n",
       "9017     1981        \\N      \\N             Documentary    NaN  \n",
       "9018     2020        \\N      \\N               Talk-Show    NaN  \n",
       "9019     2004        \\N      \\N                      \\N    NaN  \n",
       "9020     2014        \\N      \\N              Reality-TV    NaN  \n",
       "9021     2015        \\N      \\N              Reality-TV    NaN  \n",
       "9022     2019        \\N      \\N                      \\N    NaN  \n",
       "9023     1994        \\N      \\N  Animation,Comedy,Drama    NaN  \n",
       "9024     2005        \\N      \\N                      \\N    NaN  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movie_df = movie_df.loc[(movie_df['primaryTitle'].notnull()) & (movie_df['originalTitle'].notnull())]\n",
    "\n",
    "movie_df.loc[movie_df['genres'].isnull()]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#Membuang data dengan nilai NULL.\n",
    "\n",
    "Setelah melihat hasil sebelumnya, dapat dilihat bahwa semua data tidak memiliki judul dan kita dapat membuang data-data tersebut.Pekerjaan selanjutnya yang akan kita lakukan adalah membuang data dengan nilai NULL tersebut dan melihat jumlah data yang ada setelah data-data bernilai NULL tersebut dibuang. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "9000"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#mengupdate movie_df dengan membuang data-data bernilai NULL\n",
    "movie_df = movie_df.loc[movie_df['genres'].notnull()]\n",
    "\n",
    "#menampilkan jumlah data setelah data dengan nilai NULL dibuang\n",
    "len(movie_df)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#Mengubah Nilai '\\\\N' .\n",
    "\n",
    "Jika kita perhatikan pada kolom 'startYear' , 'endYear', dan 'runtimeMinutes', terdapat data dengan nilai '\\\\N'\n",
    "\n",
    "'\\\\N' berarti NULL.\n",
    "\n",
    "Hal selanjutnya yang akan kita lakukan adalah mengubah nilai dari \\\\\\N tersebur menjadi np.nan dan melakukan casting kolom startYear, endYear, dan runtimeMinutes menjadi float64."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([1898., 2018., 2016., 1987., 1973.])"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#mengubah nilai '\\\\N' pada startYear menjadi np.nan dan cast kolomnya menjadi float64\n",
    "movie_df['startYear'] = movie_df['startYear'].replace('\\\\N',np.nan)\n",
    "movie_df['startYear'] = movie_df['startYear'].astype('float64')\n",
    "\n",
    "movie_df['startYear'].unique()[:5]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([  nan, 2005., 1955., 2006., 1999.])"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#mengubah nilai '\\\\N' pada endYear menjadi np.nan dan cast kolomnya menjadi float64\n",
    "movie_df['endYear'] = movie_df['endYear'].replace('\\\\N',np.nan)\n",
    "movie_df['endYear'] = movie_df['endYear'].astype('float64')\n",
    "movie_df['endYear'].unique()[:5]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([nan, 29.,  7., 23., 85.])"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#mengubah nilai '\\\\N' pada runtimeMinutes menjadi np.nan dan cast kolomnya menjadi float64\n",
    "movie_df['runtimeMinutes'] = movie_df['runtimeMinutes'].replace('\\\\N',np.nan)\n",
    "movie_df['runtimeMinutes'] = movie_df['runtimeMinutes'].astype('float64')\n",
    "movie_df['runtimeMinutes'].unique()[:5]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#Mengubah nilai genres menjadi list.\n",
    "\n",
    "Selanjutnya, membuat sebuah function yang bernama transform_to_list untuk mengubah nilai genre menjadi list. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "def transform_to_list(x):\n",
    "    if ',' in x: \n",
    "    #ubah menjadi list apabila ada data pada kolom genre\n",
    "        return x.split(',')\n",
    "    else: \n",
    "    #jika tidak ada data, ubah menjadi list kosong\n",
    "        return []\n",
    "\n",
    "movie_df['genres'] = movie_df['genres'].apply(lambda x: transform_to_list(x))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Tabel Rating"
   ]
  },
  {
   "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>tconst</th>\n",
       "      <th>averageRating</th>\n",
       "      <th>numVotes</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>tt0000001</td>\n",
       "      <td>5.6</td>\n",
       "      <td>1608</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>tt0000002</td>\n",
       "      <td>6.0</td>\n",
       "      <td>197</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>tt0000003</td>\n",
       "      <td>6.5</td>\n",
       "      <td>1285</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>tt0000004</td>\n",
       "      <td>6.1</td>\n",
       "      <td>121</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>tt0000005</td>\n",
       "      <td>6.1</td>\n",
       "      <td>2050</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      tconst  averageRating  numVotes\n",
       "0  tt0000001            5.6      1608\n",
       "1  tt0000002            6.0       197\n",
       "2  tt0000003            6.5      1285\n",
       "3  tt0000004            6.1       121\n",
       "4  tt0000005            6.1      2050"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Menampilkan 5 data Teratas table Rating\n",
    "rating_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 1030009 entries, 0 to 1030008\n",
      "Data columns (total 3 columns):\n",
      " #   Column         Non-Null Count    Dtype  \n",
      "---  ------         --------------    -----  \n",
      " 0   tconst         1030009 non-null  object \n",
      " 1   averageRating  1030009 non-null  float64\n",
      " 2   numVotes       1030009 non-null  int64  \n",
      "dtypes: float64(1), int64(1), object(1)\n",
      "memory usage: 23.6+ MB\n"
     ]
    }
   ],
   "source": [
    "#Menampilkan info data tabel rating\n",
    "rating_df.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Joining tabel movie and Rating.\n",
    "\n",
    "lakukan inner join antara rating_df dan movie_df untuk mendapatkan rating pada setiap film yang tersedia, lalu tampilkan 5 data teratas dan tipe data dari tiap kolom yang ada."
   ]
  },
  {
   "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>tconst</th>\n",
       "      <th>titleType</th>\n",
       "      <th>primaryTitle</th>\n",
       "      <th>originalTitle</th>\n",
       "      <th>isAdult</th>\n",
       "      <th>startYear</th>\n",
       "      <th>endYear</th>\n",
       "      <th>runtimeMinutes</th>\n",
       "      <th>genres</th>\n",
       "      <th>averageRating</th>\n",
       "      <th>numVotes</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>tt0043745</td>\n",
       "      <td>short</td>\n",
       "      <td>Lion Down</td>\n",
       "      <td>Lion Down</td>\n",
       "      <td>0</td>\n",
       "      <td>1951.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.0</td>\n",
       "      <td>[Animation, Comedy, Family]</td>\n",
       "      <td>7.1</td>\n",
       "      <td>459</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>tt0167491</td>\n",
       "      <td>video</td>\n",
       "      <td>Wicked Covergirls</td>\n",
       "      <td>Wicked Covergirls</td>\n",
       "      <td>1</td>\n",
       "      <td>1998.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>85.0</td>\n",
       "      <td>[]</td>\n",
       "      <td>5.7</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>tt6574096</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Shadow Play - Part 2</td>\n",
       "      <td>Shadow Play - Part 2</td>\n",
       "      <td>0</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22.0</td>\n",
       "      <td>[Adventure, Animation, Comedy]</td>\n",
       "      <td>8.5</td>\n",
       "      <td>240</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>tt6941700</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>RuPaul Roast</td>\n",
       "      <td>RuPaul Roast</td>\n",
       "      <td>0</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>8.0</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>tt7305674</td>\n",
       "      <td>video</td>\n",
       "      <td>UCLA Track &amp; Field Promo</td>\n",
       "      <td>UCLA Track &amp; Field Promo</td>\n",
       "      <td>0</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[Short, Sport]</td>\n",
       "      <td>9.7</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      tconst  titleType              primaryTitle             originalTitle  \\\n",
       "0  tt0043745      short                 Lion Down                 Lion Down   \n",
       "1  tt0167491      video         Wicked Covergirls         Wicked Covergirls   \n",
       "2  tt6574096  tvEpisode      Shadow Play - Part 2      Shadow Play - Part 2   \n",
       "3  tt6941700  tvEpisode              RuPaul Roast              RuPaul Roast   \n",
       "4  tt7305674      video  UCLA Track & Field Promo  UCLA Track & Field Promo   \n",
       "\n",
       "   isAdult  startYear  endYear  runtimeMinutes  \\\n",
       "0        0     1951.0      NaN             7.0   \n",
       "1        1     1998.0      NaN            85.0   \n",
       "2        0     2017.0      NaN            22.0   \n",
       "3        0     2017.0      NaN             NaN   \n",
       "4        0     2017.0      NaN             NaN   \n",
       "\n",
       "                           genres  averageRating  numVotes  \n",
       "0     [Animation, Comedy, Family]            7.1       459  \n",
       "1                              []            5.7         7  \n",
       "2  [Adventure, Animation, Comedy]            8.5       240  \n",
       "3                              []            8.0        11  \n",
       "4                  [Short, Sport]            9.7         7  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Lakukan join pada kedua table (pada kolom tconst)\n",
    "movie_rating_df = pd.merge(movie_df,rating_df,on='tconst',how='inner')\n",
    "\n",
    "#Tampilkan 5 data teratas\n",
    "movie_rating_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 1376 entries, 0 to 1375\n",
      "Data columns (total 11 columns):\n",
      " #   Column          Non-Null Count  Dtype  \n",
      "---  ------          --------------  -----  \n",
      " 0   tconst          1376 non-null   object \n",
      " 1   titleType       1376 non-null   object \n",
      " 2   primaryTitle    1376 non-null   object \n",
      " 3   originalTitle   1376 non-null   object \n",
      " 4   isAdult         1376 non-null   int64  \n",
      " 5   startYear       1376 non-null   float64\n",
      " 6   endYear         26 non-null     float64\n",
      " 7   runtimeMinutes  1004 non-null   float64\n",
      " 8   genres          1376 non-null   object \n",
      " 9   averageRating   1376 non-null   float64\n",
      " 10  numVotes        1376 non-null   int64  \n",
      "dtypes: float64(4), int64(2), object(5)\n",
      "memory usage: 129.0+ KB\n"
     ]
    }
   ],
   "source": [
    "#Tampilkan tipe data dari tiap kolom\n",
    "movie_rating_df.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Memperkecil Ukuran Tabel.\n",
    "\n",
    "memperkecil ukuran table dengan menghilangkan semua nilai NULL dari kolom startYear dan runtimeMinutes karena tidak masuk akal jikalau film tersebut tidak diketahui kapan tahun rilis dan durasi nya. \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 1004 entries, 0 to 1374\n",
      "Data columns (total 11 columns):\n",
      " #   Column          Non-Null Count  Dtype  \n",
      "---  ------          --------------  -----  \n",
      " 0   tconst          1004 non-null   object \n",
      " 1   titleType       1004 non-null   object \n",
      " 2   primaryTitle    1004 non-null   object \n",
      " 3   originalTitle   1004 non-null   object \n",
      " 4   isAdult         1004 non-null   int64  \n",
      " 5   startYear       1004 non-null   float64\n",
      " 6   endYear         17 non-null     float64\n",
      " 7   runtimeMinutes  1004 non-null   float64\n",
      " 8   genres          1004 non-null   object \n",
      " 9   averageRating   1004 non-null   float64\n",
      " 10  numVotes        1004 non-null   int64  \n",
      "dtypes: float64(4), int64(2), object(5)\n",
      "memory usage: 94.1+ KB\n"
     ]
    }
   ],
   "source": [
    "#dropna untuk menghilangkan nilai NULL\n",
    "movie_rating_df = movie_rating_df.dropna(subset=['startYear','runtimeMinutes'])\n",
    "\n",
    "movie_rating_df.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Mencari nilai C.\n",
    "\n",
    "Hal pertama yang dicari adalah nilai dari C yang merupakan rata-rata dari averageRating"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "6.829581673306767"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "C = movie_rating_df['averageRating'].mean()\n",
    "\n",
    "C"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Mencari nilai m.\n",
    "\n",
    "ambil contoh film dengan numVotes di atas 80% populasi, jadi populasi yang akan diambil hanya sebesar 20%. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "229.0"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "m = movie_rating_df['numVotes'].quantile(0.8)\n",
    "\n",
    "m"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Membuat fungsi weighted formula\n",
    "\n",
    "Selanjutyna membuat sebuah fungsi dengan menggunakan dataframe sebagai variable. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0       7.009992\n",
       "1       6.796077\n",
       "2       7.684380\n",
       "5       6.921384\n",
       "6       6.869089\n",
       "          ...   \n",
       "1369    6.867943\n",
       "1371    6.590335\n",
       "1372    6.892455\n",
       "1373    6.820403\n",
       "1374    6.924997\n",
       "Name: score, Length: 1004, dtype: float64"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def imdb_weighted_rating(df, var=0.8):\n",
    "    v = df['numVotes']\n",
    "    R = df['averageRating']\n",
    "    C = df['averageRating'].mean()\n",
    "    m = df['numVotes'].quantile(var)\n",
    "    df['score'] =(v/(m+v))*R +(m/(m+v))*C #Rumus IMDb \n",
    "    return df['score']\n",
    "    \n",
    "imdb_weighted_rating(movie_rating_df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "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>tconst</th>\n",
       "      <th>titleType</th>\n",
       "      <th>primaryTitle</th>\n",
       "      <th>originalTitle</th>\n",
       "      <th>isAdult</th>\n",
       "      <th>startYear</th>\n",
       "      <th>endYear</th>\n",
       "      <th>runtimeMinutes</th>\n",
       "      <th>genres</th>\n",
       "      <th>averageRating</th>\n",
       "      <th>numVotes</th>\n",
       "      <th>score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>tt0043745</td>\n",
       "      <td>short</td>\n",
       "      <td>Lion Down</td>\n",
       "      <td>Lion Down</td>\n",
       "      <td>0</td>\n",
       "      <td>1951.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.0</td>\n",
       "      <td>[Animation, Comedy, Family]</td>\n",
       "      <td>7.1</td>\n",
       "      <td>459</td>\n",
       "      <td>7.009992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>tt0167491</td>\n",
       "      <td>video</td>\n",
       "      <td>Wicked Covergirls</td>\n",
       "      <td>Wicked Covergirls</td>\n",
       "      <td>1</td>\n",
       "      <td>1998.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>85.0</td>\n",
       "      <td>[]</td>\n",
       "      <td>5.7</td>\n",
       "      <td>7</td>\n",
       "      <td>6.796077</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>tt6574096</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Shadow Play - Part 2</td>\n",
       "      <td>Shadow Play - Part 2</td>\n",
       "      <td>0</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22.0</td>\n",
       "      <td>[Adventure, Animation, Comedy]</td>\n",
       "      <td>8.5</td>\n",
       "      <td>240</td>\n",
       "      <td>7.684380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>tt2262289</td>\n",
       "      <td>movie</td>\n",
       "      <td>The Pin</td>\n",
       "      <td>The Pin</td>\n",
       "      <td>0</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>85.0</td>\n",
       "      <td>[]</td>\n",
       "      <td>7.7</td>\n",
       "      <td>27</td>\n",
       "      <td>6.921384</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>tt0874027</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Episode #32.9</td>\n",
       "      <td>Episode #32.9</td>\n",
       "      <td>0</td>\n",
       "      <td>2006.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29.0</td>\n",
       "      <td>[Comedy, Game-Show, News]</td>\n",
       "      <td>8.0</td>\n",
       "      <td>8</td>\n",
       "      <td>6.869089</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      tconst  titleType          primaryTitle         originalTitle  isAdult  \\\n",
       "0  tt0043745      short             Lion Down             Lion Down        0   \n",
       "1  tt0167491      video     Wicked Covergirls     Wicked Covergirls        1   \n",
       "2  tt6574096  tvEpisode  Shadow Play - Part 2  Shadow Play - Part 2        0   \n",
       "5  tt2262289      movie               The Pin               The Pin        0   \n",
       "6  tt0874027  tvEpisode         Episode #32.9         Episode #32.9        0   \n",
       "\n",
       "   startYear  endYear  runtimeMinutes                          genres  \\\n",
       "0     1951.0      NaN             7.0     [Animation, Comedy, Family]   \n",
       "1     1998.0      NaN            85.0                              []   \n",
       "2     2017.0      NaN            22.0  [Adventure, Animation, Comedy]   \n",
       "5     2013.0      NaN            85.0                              []   \n",
       "6     2006.0      NaN            29.0       [Comedy, Game-Show, News]   \n",
       "\n",
       "   averageRating  numVotes     score  \n",
       "0            7.1       459  7.009992  \n",
       "1            5.7         7  6.796077  \n",
       "2            8.5       240  7.684380  \n",
       "5            7.7        27  6.921384  \n",
       "6            8.0         8  6.869089  "
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#melakukan pengecekan dataframe\n",
    "movie_rating_df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Membuat simple recommender system\n",
    "\n",
    "sebelumnya, telah terdapat field tambahan 'score'.\n",
    "\n",
    "Pertama, filter numVotes yang lebih dari m kemudian diurutkan score dari tertinggi ke terendah untuk diambil nilai beberapa nilai teratas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "def simple_recommender(df, top=100):\n",
    "    df = df.loc[df['numVotes'] >= m]\n",
    "    df = df.sort_values(by='score', ascending=False) #urutkan dari nilai tertinggi ke terendah\n",
    "    \n",
    "    #Ambil data 100 teratas\n",
    "    df = df[:top]\n",
    "    return df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "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>tconst</th>\n",
       "      <th>titleType</th>\n",
       "      <th>primaryTitle</th>\n",
       "      <th>originalTitle</th>\n",
       "      <th>isAdult</th>\n",
       "      <th>startYear</th>\n",
       "      <th>endYear</th>\n",
       "      <th>runtimeMinutes</th>\n",
       "      <th>genres</th>\n",
       "      <th>averageRating</th>\n",
       "      <th>numVotes</th>\n",
       "      <th>score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>tt4110822</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>S.O.S. Part 2</td>\n",
       "      <td>S.O.S. Part 2</td>\n",
       "      <td>0</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>43.0</td>\n",
       "      <td>[Action, Adventure, Drama]</td>\n",
       "      <td>9.4</td>\n",
       "      <td>3820</td>\n",
       "      <td>9.254624</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>236</th>\n",
       "      <td>tt2200252</td>\n",
       "      <td>video</td>\n",
       "      <td>Attack of the Clones Review</td>\n",
       "      <td>Attack of the Clones Review</td>\n",
       "      <td>0</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86.0</td>\n",
       "      <td>[]</td>\n",
       "      <td>9.3</td>\n",
       "      <td>1411</td>\n",
       "      <td>8.955045</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1181</th>\n",
       "      <td>tt7697962</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Chapter Seventeen: The Missionaries</td>\n",
       "      <td>Chapter Seventeen: The Missionaries</td>\n",
       "      <td>0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>54.0</td>\n",
       "      <td>[Drama, Fantasy, Horror]</td>\n",
       "      <td>9.2</td>\n",
       "      <td>1536</td>\n",
       "      <td>8.892450</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>326</th>\n",
       "      <td>tt7124590</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Chapter Thirty-Four: Judgment Night</td>\n",
       "      <td>Chapter Thirty-Four: Judgment Night</td>\n",
       "      <td>0</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>42.0</td>\n",
       "      <td>[Crime, Drama, Mystery]</td>\n",
       "      <td>9.1</td>\n",
       "      <td>1859</td>\n",
       "      <td>8.850993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1045</th>\n",
       "      <td>tt0533506</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>The Prom</td>\n",
       "      <td>The Prom</td>\n",
       "      <td>0</td>\n",
       "      <td>1999.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>60.0</td>\n",
       "      <td>[Action, Drama, Fantasy]</td>\n",
       "      <td>8.9</td>\n",
       "      <td>2740</td>\n",
       "      <td>8.740308</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>tt8399426</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Savages</td>\n",
       "      <td>Savages</td>\n",
       "      <td>0</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>58.0</td>\n",
       "      <td>[Drama, Fantasy, Romance]</td>\n",
       "      <td>9.0</td>\n",
       "      <td>1428</td>\n",
       "      <td>8.700045</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1234</th>\n",
       "      <td>tt2843830</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>VIII.</td>\n",
       "      <td>VIII.</td>\n",
       "      <td>0</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>57.0</td>\n",
       "      <td>[Adventure, Drama]</td>\n",
       "      <td>8.9</td>\n",
       "      <td>1753</td>\n",
       "      <td>8.660784</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1087</th>\n",
       "      <td>tt4295140</td>\n",
       "      <td>tvSeries</td>\n",
       "      <td>Chef's Table</td>\n",
       "      <td>Chef's Table</td>\n",
       "      <td>0</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>50.0</td>\n",
       "      <td>[]</td>\n",
       "      <td>8.6</td>\n",
       "      <td>12056</td>\n",
       "      <td>8.566998</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1054</th>\n",
       "      <td>tt2503932</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Trial and Error</td>\n",
       "      <td>Trial and Error</td>\n",
       "      <td>0</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>43.0</td>\n",
       "      <td>[Drama, Fantasy, Horror]</td>\n",
       "      <td>8.6</td>\n",
       "      <td>2495</td>\n",
       "      <td>8.451165</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>448</th>\n",
       "      <td>tt0337566</td>\n",
       "      <td>video</td>\n",
       "      <td>AC/DC: Live at Donington</td>\n",
       "      <td>AC/DC: Live at Donington</td>\n",
       "      <td>0</td>\n",
       "      <td>1992.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>120.0</td>\n",
       "      <td>[Documentary, Music]</td>\n",
       "      <td>8.5</td>\n",
       "      <td>1343</td>\n",
       "      <td>8.256663</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>624</th>\n",
       "      <td>tt0620159</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Strike Out</td>\n",
       "      <td>Strike Out</td>\n",
       "      <td>0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.0</td>\n",
       "      <td>[]</td>\n",
       "      <td>8.7</td>\n",
       "      <td>401</td>\n",
       "      <td>8.020118</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1281</th>\n",
       "      <td>tt3166390</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Looking for a Plus-One</td>\n",
       "      <td>Looking for a Plus-One</td>\n",
       "      <td>0</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.0</td>\n",
       "      <td>[Comedy, Drama, Romance]</td>\n",
       "      <td>8.7</td>\n",
       "      <td>396</td>\n",
       "      <td>8.014679</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>314</th>\n",
       "      <td>tt0954759</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Ben Franklin</td>\n",
       "      <td>Ben Franklin</td>\n",
       "      <td>0</td>\n",
       "      <td>2007.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21.0</td>\n",
       "      <td>[]</td>\n",
       "      <td>8.1</td>\n",
       "      <td>2766</td>\n",
       "      <td>8.002863</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189</th>\n",
       "      <td>tt5661506</td>\n",
       "      <td>video</td>\n",
       "      <td>Florence + the Machine: The Odyssey</td>\n",
       "      <td>Florence + the Machine: The Odyssey</td>\n",
       "      <td>0</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>49.0</td>\n",
       "      <td>[]</td>\n",
       "      <td>8.8</td>\n",
       "      <td>330</td>\n",
       "      <td>7.992798</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>tt3954426</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Bleeding Kansas</td>\n",
       "      <td>Bleeding Kansas</td>\n",
       "      <td>0</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>42.0</td>\n",
       "      <td>[Drama, Western]</td>\n",
       "      <td>8.6</td>\n",
       "      <td>437</td>\n",
       "      <td>7.991253</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1344</th>\n",
       "      <td>tt6644294</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>The Hostile Hospital: Part Two</td>\n",
       "      <td>The Hostile Hospital: Part Two</td>\n",
       "      <td>0</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40.0</td>\n",
       "      <td>[Adventure, Comedy, Drama]</td>\n",
       "      <td>8.3</td>\n",
       "      <td>812</td>\n",
       "      <td>7.976536</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1242</th>\n",
       "      <td>tt3677742</td>\n",
       "      <td>tvSpecial</td>\n",
       "      <td>Saturday Night Live: 40th Anniversary Special</td>\n",
       "      <td>Saturday Night Live: 40th Anniversary Special</td>\n",
       "      <td>0</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>106.0</td>\n",
       "      <td>[]</td>\n",
       "      <td>8.1</td>\n",
       "      <td>1931</td>\n",
       "      <td>7.965312</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1217</th>\n",
       "      <td>tt3642464</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Giant Woman</td>\n",
       "      <td>Giant Woman</td>\n",
       "      <td>0</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11.0</td>\n",
       "      <td>[Adventure, Animation, Comedy]</td>\n",
       "      <td>8.4</td>\n",
       "      <td>566</td>\n",
       "      <td>7.947641</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>544</th>\n",
       "      <td>tt0734655</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>The Little People</td>\n",
       "      <td>The Little People</td>\n",
       "      <td>0</td>\n",
       "      <td>1962.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25.0</td>\n",
       "      <td>[Drama, Fantasy, Horror]</td>\n",
       "      <td>8.1</td>\n",
       "      <td>1559</td>\n",
       "      <td>7.937290</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>tt9119838</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Parisian Legend Has It...</td>\n",
       "      <td>Parisian Legend Has It...</td>\n",
       "      <td>0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>42.0</td>\n",
       "      <td>[]</td>\n",
       "      <td>8.9</td>\n",
       "      <td>263</td>\n",
       "      <td>7.936330</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>357</th>\n",
       "      <td>tt4084774</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Trial and Punishment</td>\n",
       "      <td>Trial and Punishment</td>\n",
       "      <td>0</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>56.0</td>\n",
       "      <td>[Adventure, Drama]</td>\n",
       "      <td>8.8</td>\n",
       "      <td>289</td>\n",
       "      <td>7.928908</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1111</th>\n",
       "      <td>tt4174072</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Immortal Emerges from Cave</td>\n",
       "      <td>Immortal Emerges from Cave</td>\n",
       "      <td>0</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>53.0</td>\n",
       "      <td>[Action, Adventure, Crime]</td>\n",
       "      <td>8.0</td>\n",
       "      <td>2898</td>\n",
       "      <td>7.914287</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>790</th>\n",
       "      <td>tt4279086</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>And Santa's Midnight Run</td>\n",
       "      <td>And Santa's Midnight Run</td>\n",
       "      <td>0</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>42.0</td>\n",
       "      <td>[Action, Adventure, Comedy]</td>\n",
       "      <td>8.2</td>\n",
       "      <td>823</td>\n",
       "      <td>7.901687</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>972</th>\n",
       "      <td>tt0048028</td>\n",
       "      <td>movie</td>\n",
       "      <td>East of Eden</td>\n",
       "      <td>East of Eden</td>\n",
       "      <td>0</td>\n",
       "      <td>1955.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>118.0</td>\n",
       "      <td>[]</td>\n",
       "      <td>7.9</td>\n",
       "      <td>38543</td>\n",
       "      <td>7.893678</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>819</th>\n",
       "      <td>tt0032156</td>\n",
       "      <td>movie</td>\n",
       "      <td>The Story of the Last Chrysanthemum</td>\n",
       "      <td>Zangiku monogatari</td>\n",
       "      <td>0</td>\n",
       "      <td>1939.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>143.0</td>\n",
       "      <td>[Drama, Romance]</td>\n",
       "      <td>7.9</td>\n",
       "      <td>2974</td>\n",
       "      <td>7.823470</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         tconst  titleType                                   primaryTitle  \\\n",
       "68    tt4110822  tvEpisode                                  S.O.S. Part 2   \n",
       "236   tt2200252      video                    Attack of the Clones Review   \n",
       "1181  tt7697962  tvEpisode            Chapter Seventeen: The Missionaries   \n",
       "326   tt7124590  tvEpisode            Chapter Thirty-Four: Judgment Night   \n",
       "1045  tt0533506  tvEpisode                                       The Prom   \n",
       "71    tt8399426  tvEpisode                                        Savages   \n",
       "1234  tt2843830  tvEpisode                                          VIII.   \n",
       "1087  tt4295140   tvSeries                                   Chef's Table   \n",
       "1054  tt2503932  tvEpisode                                Trial and Error   \n",
       "448   tt0337566      video                       AC/DC: Live at Donington   \n",
       "624   tt0620159  tvEpisode                                     Strike Out   \n",
       "1281  tt3166390  tvEpisode                         Looking for a Plus-One   \n",
       "314   tt0954759  tvEpisode                                   Ben Franklin   \n",
       "189   tt5661506      video            Florence + the Machine: The Odyssey   \n",
       "151   tt3954426  tvEpisode                                Bleeding Kansas   \n",
       "1344  tt6644294  tvEpisode                 The Hostile Hospital: Part Two   \n",
       "1242  tt3677742  tvSpecial  Saturday Night Live: 40th Anniversary Special   \n",
       "1217  tt3642464  tvEpisode                                    Giant Woman   \n",
       "544   tt0734655  tvEpisode                              The Little People   \n",
       "49    tt9119838  tvEpisode                      Parisian Legend Has It...   \n",
       "357   tt4084774  tvEpisode                           Trial and Punishment   \n",
       "1111  tt4174072  tvEpisode                     Immortal Emerges from Cave   \n",
       "790   tt4279086  tvEpisode                       And Santa's Midnight Run   \n",
       "972   tt0048028      movie                                   East of Eden   \n",
       "819   tt0032156      movie            The Story of the Last Chrysanthemum   \n",
       "\n",
       "                                      originalTitle  isAdult  startYear  \\\n",
       "68                                    S.O.S. Part 2        0     2015.0   \n",
       "236                     Attack of the Clones Review        0     2010.0   \n",
       "1181            Chapter Seventeen: The Missionaries        0     2019.0   \n",
       "326             Chapter Thirty-Four: Judgment Night        0     2018.0   \n",
       "1045                                       The Prom        0     1999.0   \n",
       "71                                          Savages        0     2018.0   \n",
       "1234                                          VIII.        0     2014.0   \n",
       "1087                                   Chef's Table        0     2015.0   \n",
       "1054                                Trial and Error        0     2013.0   \n",
       "448                        AC/DC: Live at Donington        0     1992.0   \n",
       "624                                      Strike Out        0     2000.0   \n",
       "1281                         Looking for a Plus-One        0     2014.0   \n",
       "314                                    Ben Franklin        0     2007.0   \n",
       "189             Florence + the Machine: The Odyssey        0     2016.0   \n",
       "151                                 Bleeding Kansas        0     2014.0   \n",
       "1344                 The Hostile Hospital: Part Two        0     2018.0   \n",
       "1242  Saturday Night Live: 40th Anniversary Special        0     2015.0   \n",
       "1217                                    Giant Woman        0     2014.0   \n",
       "544                               The Little People        0     1962.0   \n",
       "49                        Parisian Legend Has It...        0     2019.0   \n",
       "357                            Trial and Punishment        0     2015.0   \n",
       "1111                     Immortal Emerges from Cave        0     2017.0   \n",
       "790                        And Santa's Midnight Run        0     2014.0   \n",
       "972                                    East of Eden        0     1955.0   \n",
       "819                              Zangiku monogatari        0     1939.0   \n",
       "\n",
       "      endYear  runtimeMinutes                          genres  averageRating  \\\n",
       "68        NaN            43.0      [Action, Adventure, Drama]            9.4   \n",
       "236       NaN            86.0                              []            9.3   \n",
       "1181      NaN            54.0        [Drama, Fantasy, Horror]            9.2   \n",
       "326       NaN            42.0         [Crime, Drama, Mystery]            9.1   \n",
       "1045      NaN            60.0        [Action, Drama, Fantasy]            8.9   \n",
       "71        NaN            58.0       [Drama, Fantasy, Romance]            9.0   \n",
       "1234      NaN            57.0              [Adventure, Drama]            8.9   \n",
       "1087      NaN            50.0                              []            8.6   \n",
       "1054      NaN            43.0        [Drama, Fantasy, Horror]            8.6   \n",
       "448       NaN           120.0            [Documentary, Music]            8.5   \n",
       "624       NaN            30.0                              []            8.7   \n",
       "1281      NaN            28.0        [Comedy, Drama, Romance]            8.7   \n",
       "314       NaN            21.0                              []            8.1   \n",
       "189       NaN            49.0                              []            8.8   \n",
       "151       NaN            42.0                [Drama, Western]            8.6   \n",
       "1344      NaN            40.0      [Adventure, Comedy, Drama]            8.3   \n",
       "1242      NaN           106.0                              []            8.1   \n",
       "1217      NaN            11.0  [Adventure, Animation, Comedy]            8.4   \n",
       "544       NaN            25.0        [Drama, Fantasy, Horror]            8.1   \n",
       "49        NaN            42.0                              []            8.9   \n",
       "357       NaN            56.0              [Adventure, Drama]            8.8   \n",
       "1111      NaN            53.0      [Action, Adventure, Crime]            8.0   \n",
       "790       NaN            42.0     [Action, Adventure, Comedy]            8.2   \n",
       "972       NaN           118.0                              []            7.9   \n",
       "819       NaN           143.0                [Drama, Romance]            7.9   \n",
       "\n",
       "      numVotes     score  \n",
       "68        3820  9.254624  \n",
       "236       1411  8.955045  \n",
       "1181      1536  8.892450  \n",
       "326       1859  8.850993  \n",
       "1045      2740  8.740308  \n",
       "71        1428  8.700045  \n",
       "1234      1753  8.660784  \n",
       "1087     12056  8.566998  \n",
       "1054      2495  8.451165  \n",
       "448       1343  8.256663  \n",
       "624        401  8.020118  \n",
       "1281       396  8.014679  \n",
       "314       2766  8.002863  \n",
       "189        330  7.992798  \n",
       "151        437  7.991253  \n",
       "1344       812  7.976536  \n",
       "1242      1931  7.965312  \n",
       "1217       566  7.947641  \n",
       "544       1559  7.937290  \n",
       "49         263  7.936330  \n",
       "357        289  7.928908  \n",
       "1111      2898  7.914287  \n",
       "790        823  7.901687  \n",
       "972      38543  7.893678  \n",
       "819       2974  7.823470  "
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Ambil data 25 teratas     \n",
    "simple_recommender(movie_rating_df, top=25)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = movie_rating_df.copy()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Membuat simple recommender system dengan user preferences.\n",
    "\n",
    "sebelumnya, dapat dilihat daftar film telah diurutkan dari score tertinggi ke terendah.\n",
    "\n",
    "Film dengan averageRating yang tinggi tidak selalu mendapat posisi yang lebih tinggi dibanding film dengan averageRating lebih rendah, hal ini disebabkan karena kita juga memperhitungkan faktor banyaknya votes\n",
    "\n",
    "\n",
    "Sistem rekomendasi ini masih bisa ditingkatkan dengan menambah filter spesifik tentang titleType, startYear, ataupun filter yang lain\n",
    "\n",
    "Selanjutnya yang akan dilakukan adalah membuat function untuk melakukan filter berdasarkan isAdult, startYear, dan genres. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "def user_prefer_recommender(df, ask_adult, ask_start_year, ask_genre, top=100):\n",
    "    #ask_adult = yes/no\n",
    "    if ask_adult.lower() == 'yes':\n",
    "        df= df.loc[df['isAdult']==1]\n",
    "    elif ask_adult.lower() == 'no':\n",
    "        df=df.loc[df['isAdult']==0]\n",
    "\n",
    "    #ask_start_year = numeric\n",
    "    df = df.loc[df['startYear'] >= int(ask_start_year)]\n",
    "\n",
    "    #ask_genre = 'all' atau yang lain\n",
    "    if ask_genre.lower() == 'all':\n",
    "        df = df\n",
    "    else:\n",
    "        def filter_genre(x):\n",
    "            if ask_genre.lower() in str(x).lower():\n",
    "                return True\n",
    "            else:\n",
    "                return False\n",
    "        df = df.loc[df['genres'].apply(lambda x: filter_genre(x))]\n",
    "\n",
    "    df = df.loc[df['numVotes']>= m]  #Mengambil film dengan numVotes yang lebih besar atau sama dengan nilai m \n",
    "    df = df.sort_values(by='score', ascending=False)\n",
    "    \n",
    "    #jika kamu hanya ingin mengambil 100 teratas\n",
    "    df = df[:top]\n",
    "    return df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "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>tconst</th>\n",
       "      <th>titleType</th>\n",
       "      <th>primaryTitle</th>\n",
       "      <th>originalTitle</th>\n",
       "      <th>isAdult</th>\n",
       "      <th>startYear</th>\n",
       "      <th>endYear</th>\n",
       "      <th>runtimeMinutes</th>\n",
       "      <th>genres</th>\n",
       "      <th>averageRating</th>\n",
       "      <th>numVotes</th>\n",
       "      <th>score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>tt4110822</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>S.O.S. Part 2</td>\n",
       "      <td>S.O.S. Part 2</td>\n",
       "      <td>0</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>43.0</td>\n",
       "      <td>[Action, Adventure, Drama]</td>\n",
       "      <td>9.4</td>\n",
       "      <td>3820</td>\n",
       "      <td>9.254624</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1181</th>\n",
       "      <td>tt7697962</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Chapter Seventeen: The Missionaries</td>\n",
       "      <td>Chapter Seventeen: The Missionaries</td>\n",
       "      <td>0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>54.0</td>\n",
       "      <td>[Drama, Fantasy, Horror]</td>\n",
       "      <td>9.2</td>\n",
       "      <td>1536</td>\n",
       "      <td>8.892450</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>326</th>\n",
       "      <td>tt7124590</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Chapter Thirty-Four: Judgment Night</td>\n",
       "      <td>Chapter Thirty-Four: Judgment Night</td>\n",
       "      <td>0</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>42.0</td>\n",
       "      <td>[Crime, Drama, Mystery]</td>\n",
       "      <td>9.1</td>\n",
       "      <td>1859</td>\n",
       "      <td>8.850993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>tt8399426</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Savages</td>\n",
       "      <td>Savages</td>\n",
       "      <td>0</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>58.0</td>\n",
       "      <td>[Drama, Fantasy, Romance]</td>\n",
       "      <td>9.0</td>\n",
       "      <td>1428</td>\n",
       "      <td>8.700045</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1234</th>\n",
       "      <td>tt2843830</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>VIII.</td>\n",
       "      <td>VIII.</td>\n",
       "      <td>0</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>57.0</td>\n",
       "      <td>[Adventure, Drama]</td>\n",
       "      <td>8.9</td>\n",
       "      <td>1753</td>\n",
       "      <td>8.660784</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1054</th>\n",
       "      <td>tt2503932</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Trial and Error</td>\n",
       "      <td>Trial and Error</td>\n",
       "      <td>0</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>43.0</td>\n",
       "      <td>[Drama, Fantasy, Horror]</td>\n",
       "      <td>8.6</td>\n",
       "      <td>2495</td>\n",
       "      <td>8.451165</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1281</th>\n",
       "      <td>tt3166390</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Looking for a Plus-One</td>\n",
       "      <td>Looking for a Plus-One</td>\n",
       "      <td>0</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>28.0</td>\n",
       "      <td>[Comedy, Drama, Romance]</td>\n",
       "      <td>8.7</td>\n",
       "      <td>396</td>\n",
       "      <td>8.014679</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>tt3954426</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Bleeding Kansas</td>\n",
       "      <td>Bleeding Kansas</td>\n",
       "      <td>0</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>42.0</td>\n",
       "      <td>[Drama, Western]</td>\n",
       "      <td>8.6</td>\n",
       "      <td>437</td>\n",
       "      <td>7.991253</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1344</th>\n",
       "      <td>tt6644294</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>The Hostile Hospital: Part Two</td>\n",
       "      <td>The Hostile Hospital: Part Two</td>\n",
       "      <td>0</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40.0</td>\n",
       "      <td>[Adventure, Comedy, Drama]</td>\n",
       "      <td>8.3</td>\n",
       "      <td>812</td>\n",
       "      <td>7.976536</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>357</th>\n",
       "      <td>tt4084774</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Trial and Punishment</td>\n",
       "      <td>Trial and Punishment</td>\n",
       "      <td>0</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>56.0</td>\n",
       "      <td>[Adventure, Drama]</td>\n",
       "      <td>8.8</td>\n",
       "      <td>289</td>\n",
       "      <td>7.928908</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>708</th>\n",
       "      <td>tt2751234</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Resurrection</td>\n",
       "      <td>Resurrection</td>\n",
       "      <td>0</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>43.0</td>\n",
       "      <td>[Crime, Drama, Horror]</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1077</td>\n",
       "      <td>7.794774</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>605</th>\n",
       "      <td>tt9141176</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>59 horas desaparecido</td>\n",
       "      <td>59 horas desaparecido</td>\n",
       "      <td>0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>48.0</td>\n",
       "      <td>[Crime, Drama, Thriller]</td>\n",
       "      <td>8.1</td>\n",
       "      <td>674</td>\n",
       "      <td>7.777823</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>983</th>\n",
       "      <td>tt5063116</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Shell</td>\n",
       "      <td>Shell</td>\n",
       "      <td>0</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>32.0</td>\n",
       "      <td>[Comedy, Drama]</td>\n",
       "      <td>8.5</td>\n",
       "      <td>275</td>\n",
       "      <td>7.741020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1017</th>\n",
       "      <td>tt2206822</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Vested Interest</td>\n",
       "      <td>Vested Interest</td>\n",
       "      <td>0</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>43.0</td>\n",
       "      <td>[Comedy, Crime, Drama]</td>\n",
       "      <td>8.0</td>\n",
       "      <td>525</td>\n",
       "      <td>7.644528</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>tt0847785</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Like It Was</td>\n",
       "      <td>Like It Was</td>\n",
       "      <td>0</td>\n",
       "      <td>2006.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>43.0</td>\n",
       "      <td>[Comedy, Drama, Mystery]</td>\n",
       "      <td>8.1</td>\n",
       "      <td>405</td>\n",
       "      <td>7.641127</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>625</th>\n",
       "      <td>tt7348490</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Forced Perspective</td>\n",
       "      <td>Forced Perspective</td>\n",
       "      <td>0</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>43.0</td>\n",
       "      <td>[Crime, Drama, Mystery]</td>\n",
       "      <td>7.9</td>\n",
       "      <td>413</td>\n",
       "      <td>7.518184</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1272</th>\n",
       "      <td>tt0534736</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Sex, Lies and Larvae</td>\n",
       "      <td>Sex, Lies and Larvae</td>\n",
       "      <td>0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>46.0</td>\n",
       "      <td>[Crime, Drama, Mystery]</td>\n",
       "      <td>7.7</td>\n",
       "      <td>689</td>\n",
       "      <td>7.482870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>800</th>\n",
       "      <td>tt0901201</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Crossroads</td>\n",
       "      <td>Crossroads</td>\n",
       "      <td>0</td>\n",
       "      <td>2006.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>42.0</td>\n",
       "      <td>[Action, Drama, Mystery]</td>\n",
       "      <td>7.7</td>\n",
       "      <td>654</td>\n",
       "      <td>7.474263</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>659</th>\n",
       "      <td>tt3909890</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Moppa</td>\n",
       "      <td>Moppa</td>\n",
       "      <td>0</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>27.0</td>\n",
       "      <td>[Comedy, Drama]</td>\n",
       "      <td>7.8</td>\n",
       "      <td>410</td>\n",
       "      <td>7.452229</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1170</th>\n",
       "      <td>tt0647504</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Tainted Fruit</td>\n",
       "      <td>Tainted Fruit</td>\n",
       "      <td>0</td>\n",
       "      <td>2001.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>98.0</td>\n",
       "      <td>[Crime, Drama, Mystery]</td>\n",
       "      <td>7.7</td>\n",
       "      <td>538</td>\n",
       "      <td>7.440123</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1001</th>\n",
       "      <td>tt2129485</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>A Desperate Man</td>\n",
       "      <td>A Desperate Man</td>\n",
       "      <td>0</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>44.0</td>\n",
       "      <td>[Action, Crime, Drama]</td>\n",
       "      <td>7.7</td>\n",
       "      <td>501</td>\n",
       "      <td>7.426951</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>977</th>\n",
       "      <td>tt4391820</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Aisling</td>\n",
       "      <td>Aisling</td>\n",
       "      <td>0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>51.0</td>\n",
       "      <td>[Crime, Drama, Fantasy]</td>\n",
       "      <td>7.5</td>\n",
       "      <td>1558</td>\n",
       "      <td>7.414087</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1096</th>\n",
       "      <td>tt6822518</td>\n",
       "      <td>movie</td>\n",
       "      <td>Yasamak Güzel Sey</td>\n",
       "      <td>Yasamak Güzel Sey</td>\n",
       "      <td>0</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>101.0</td>\n",
       "      <td>[Comedy, Drama]</td>\n",
       "      <td>7.5</td>\n",
       "      <td>1541</td>\n",
       "      <td>7.413262</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>910</th>\n",
       "      <td>tt3348270</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Bloodline</td>\n",
       "      <td>Bloodline</td>\n",
       "      <td>0</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>44.0</td>\n",
       "      <td>[Drama, Horror, Mystery]</td>\n",
       "      <td>7.7</td>\n",
       "      <td>436</td>\n",
       "      <td>7.400262</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>746</th>\n",
       "      <td>tt0534765</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>You've Got Male</td>\n",
       "      <td>You've Got Male</td>\n",
       "      <td>0</td>\n",
       "      <td>2001.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>45.0</td>\n",
       "      <td>[Crime, Drama, Mystery]</td>\n",
       "      <td>7.6</td>\n",
       "      <td>620</td>\n",
       "      <td>7.392196</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299</th>\n",
       "      <td>tt4527626</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>His Troubled Thoughts</td>\n",
       "      <td>His Troubled Thoughts</td>\n",
       "      <td>0</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>59.0</td>\n",
       "      <td>[Crime, Drama, Thriller]</td>\n",
       "      <td>7.5</td>\n",
       "      <td>859</td>\n",
       "      <td>7.358892</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>509</th>\n",
       "      <td>tt1256301</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Nine Lives</td>\n",
       "      <td>Nine Lives</td>\n",
       "      <td>0</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>44.0</td>\n",
       "      <td>[Action, Crime, Drama]</td>\n",
       "      <td>7.6</td>\n",
       "      <td>501</td>\n",
       "      <td>7.358321</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>897</th>\n",
       "      <td>tt2349242</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>The Fifth Man</td>\n",
       "      <td>The Fifth Man</td>\n",
       "      <td>0</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>44.0</td>\n",
       "      <td>[Action, Crime, Drama]</td>\n",
       "      <td>7.8</td>\n",
       "      <td>270</td>\n",
       "      <td>7.354658</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1090</th>\n",
       "      <td>tt0212815</td>\n",
       "      <td>movie</td>\n",
       "      <td>Big Eden</td>\n",
       "      <td>Big Eden</td>\n",
       "      <td>0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>118.0</td>\n",
       "      <td>[Comedy, Drama, Romance]</td>\n",
       "      <td>7.3</td>\n",
       "      <td>3906</td>\n",
       "      <td>7.273948</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>tt1753383</td>\n",
       "      <td>movie</td>\n",
       "      <td>A Dog's Purpose</td>\n",
       "      <td>A Dog's Purpose</td>\n",
       "      <td>0</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>100.0</td>\n",
       "      <td>[Adventure, Comedy, Drama]</td>\n",
       "      <td>7.2</td>\n",
       "      <td>61521</td>\n",
       "      <td>7.198626</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>550</th>\n",
       "      <td>tt8163822</td>\n",
       "      <td>short</td>\n",
       "      <td>The Neighbors' Window</td>\n",
       "      <td>The Neighbors' Window</td>\n",
       "      <td>0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21.0</td>\n",
       "      <td>[Drama, Short]</td>\n",
       "      <td>7.2</td>\n",
       "      <td>2222</td>\n",
       "      <td>7.165391</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>834</th>\n",
       "      <td>tt6509862</td>\n",
       "      <td>movie</td>\n",
       "      <td>Mr. Long</td>\n",
       "      <td>Ryu san</td>\n",
       "      <td>0</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>129.0</td>\n",
       "      <td>[Action, Crime, Drama]</td>\n",
       "      <td>7.1</td>\n",
       "      <td>960</td>\n",
       "      <td>7.047918</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600</th>\n",
       "      <td>tt0329002</td>\n",
       "      <td>movie</td>\n",
       "      <td>Hard Goodbyes: My Father</td>\n",
       "      <td>Dyskoloi apohairetismoi: O babas mou</td>\n",
       "      <td>0</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>113.0</td>\n",
       "      <td>[Drama, Family]</td>\n",
       "      <td>7.1</td>\n",
       "      <td>423</td>\n",
       "      <td>7.005022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>642</th>\n",
       "      <td>tt0993186</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Daleks in Manhattan</td>\n",
       "      <td>Daleks in Manhattan</td>\n",
       "      <td>0</td>\n",
       "      <td>2007.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>45.0</td>\n",
       "      <td>[Adventure, Drama, Family]</td>\n",
       "      <td>7.0</td>\n",
       "      <td>4982</td>\n",
       "      <td>6.992511</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>691</th>\n",
       "      <td>tt3663996</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Storm Watch</td>\n",
       "      <td>Storm Watch</td>\n",
       "      <td>0</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>43.0</td>\n",
       "      <td>[Drama, Romance]</td>\n",
       "      <td>7.0</td>\n",
       "      <td>309</td>\n",
       "      <td>6.927461</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>727</th>\n",
       "      <td>tt3563898</td>\n",
       "      <td>tvSeries</td>\n",
       "      <td>Brynhildr in the Darkness</td>\n",
       "      <td>Gokukoku no Brynhildr</td>\n",
       "      <td>0</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22.0</td>\n",
       "      <td>[Action, Animation, Drama]</td>\n",
       "      <td>6.8</td>\n",
       "      <td>733</td>\n",
       "      <td>6.807042</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>tt0464049</td>\n",
       "      <td>movie</td>\n",
       "      <td>The History Boys</td>\n",
       "      <td>The History Boys</td>\n",
       "      <td>0</td>\n",
       "      <td>2006.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>109.0</td>\n",
       "      <td>[Comedy, Drama, Romance]</td>\n",
       "      <td>6.8</td>\n",
       "      <td>19858</td>\n",
       "      <td>6.800337</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>893</th>\n",
       "      <td>tt8858104</td>\n",
       "      <td>movie</td>\n",
       "      <td>Guava Island</td>\n",
       "      <td>Guava Island</td>\n",
       "      <td>0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>55.0</td>\n",
       "      <td>[Comedy, Drama, Music]</td>\n",
       "      <td>6.7</td>\n",
       "      <td>7935</td>\n",
       "      <td>6.703635</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>927</th>\n",
       "      <td>tt3663990</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Pilot</td>\n",
       "      <td>Pilot</td>\n",
       "      <td>0</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>44.0</td>\n",
       "      <td>[Drama, Romance]</td>\n",
       "      <td>6.6</td>\n",
       "      <td>403</td>\n",
       "      <td>6.683187</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>462</th>\n",
       "      <td>tt5197828</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>Right</td>\n",
       "      <td>Right</td>\n",
       "      <td>0</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>42.0</td>\n",
       "      <td>[Crime, Drama, Mystery]</td>\n",
       "      <td>6.5</td>\n",
       "      <td>641</td>\n",
       "      <td>6.586752</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1068</th>\n",
       "      <td>tt8369852</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>I Think We're Alone Now</td>\n",
       "      <td>I Think We're Alone Now</td>\n",
       "      <td>0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>43.0</td>\n",
       "      <td>[Adventure, Drama, Mystery]</td>\n",
       "      <td>6.3</td>\n",
       "      <td>563</td>\n",
       "      <td>6.453124</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>940</th>\n",
       "      <td>tt0396190</td>\n",
       "      <td>movie</td>\n",
       "      <td>Return to Sender</td>\n",
       "      <td>Return to Sender</td>\n",
       "      <td>0</td>\n",
       "      <td>2004.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>109.0</td>\n",
       "      <td>[Drama, Thriller]</td>\n",
       "      <td>6.4</td>\n",
       "      <td>2342</td>\n",
       "      <td>6.438263</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>610</th>\n",
       "      <td>tt3526706</td>\n",
       "      <td>movie</td>\n",
       "      <td>Chevalier</td>\n",
       "      <td>Chevalier</td>\n",
       "      <td>0</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>105.0</td>\n",
       "      <td>[Comedy, Drama]</td>\n",
       "      <td>6.3</td>\n",
       "      <td>3890</td>\n",
       "      <td>6.329443</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1126</th>\n",
       "      <td>tt2151739</td>\n",
       "      <td>movie</td>\n",
       "      <td>Meet Me in Montenegro</td>\n",
       "      <td>Meet Me in Montenegro</td>\n",
       "      <td>0</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>90.0</td>\n",
       "      <td>[Comedy, Drama, Romance]</td>\n",
       "      <td>5.8</td>\n",
       "      <td>258</td>\n",
       "      <td>6.284136</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>637</th>\n",
       "      <td>tt0857275</td>\n",
       "      <td>movie</td>\n",
       "      <td>Wonderful World</td>\n",
       "      <td>Wonderful World</td>\n",
       "      <td>0</td>\n",
       "      <td>2009.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>89.0</td>\n",
       "      <td>[Drama, Romance]</td>\n",
       "      <td>6.1</td>\n",
       "      <td>2288</td>\n",
       "      <td>6.166378</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>385</th>\n",
       "      <td>tt0472259</td>\n",
       "      <td>movie</td>\n",
       "      <td>Alone with Her</td>\n",
       "      <td>Alone with Her</td>\n",
       "      <td>0</td>\n",
       "      <td>2006.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>78.0</td>\n",
       "      <td>[Crime, Drama, Thriller]</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3738</td>\n",
       "      <td>6.047889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1014</th>\n",
       "      <td>tt1159705</td>\n",
       "      <td>movie</td>\n",
       "      <td>Teenage Angst</td>\n",
       "      <td>Teenage Angst</td>\n",
       "      <td>0</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>64.0</td>\n",
       "      <td>[Drama, Thriller]</td>\n",
       "      <td>5.3</td>\n",
       "      <td>355</td>\n",
       "      <td>5.899785</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1043</th>\n",
       "      <td>tt5518756</td>\n",
       "      <td>movie</td>\n",
       "      <td>The Misandrists</td>\n",
       "      <td>The Misandrists</td>\n",
       "      <td>0</td>\n",
       "      <td>2017.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>91.0</td>\n",
       "      <td>[Comedy, Drama]</td>\n",
       "      <td>5.1</td>\n",
       "      <td>387</td>\n",
       "      <td>5.742978</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1154</th>\n",
       "      <td>tt1386492</td>\n",
       "      <td>movie</td>\n",
       "      <td>This Is Not a Movie</td>\n",
       "      <td>This Is Not a Movie</td>\n",
       "      <td>0</td>\n",
       "      <td>2011.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>99.0</td>\n",
       "      <td>[Comedy, Drama]</td>\n",
       "      <td>4.6</td>\n",
       "      <td>642</td>\n",
       "      <td>5.186193</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>492</th>\n",
       "      <td>tt0882806</td>\n",
       "      <td>movie</td>\n",
       "      <td>Sugar Boxx</td>\n",
       "      <td>Sugar Boxx</td>\n",
       "      <td>0</td>\n",
       "      <td>2009.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86.0</td>\n",
       "      <td>[Crime, Drama]</td>\n",
       "      <td>3.5</td>\n",
       "      <td>229</td>\n",
       "      <td>5.164791</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>922</th>\n",
       "      <td>tt2948790</td>\n",
       "      <td>movie</td>\n",
       "      <td>Return to Sender</td>\n",
       "      <td>Return to Sender</td>\n",
       "      <td>0</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>92.0</td>\n",
       "      <td>[Drama, Thriller]</td>\n",
       "      <td>5.1</td>\n",
       "      <td>11434</td>\n",
       "      <td>5.133960</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>690</th>\n",
       "      <td>tt4477536</td>\n",
       "      <td>movie</td>\n",
       "      <td>Fifty Shades Freed</td>\n",
       "      <td>Fifty Shades Freed</td>\n",
       "      <td>0</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>105.0</td>\n",
       "      <td>[Drama, Romance, Thriller]</td>\n",
       "      <td>4.5</td>\n",
       "      <td>50572</td>\n",
       "      <td>4.510501</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>677</th>\n",
       "      <td>tt8923408</td>\n",
       "      <td>tvEpisode</td>\n",
       "      <td>#JinnHunter</td>\n",
       "      <td>#JinnHunter</td>\n",
       "      <td>0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24.0</td>\n",
       "      <td>[Drama, Fantasy, Horror]</td>\n",
       "      <td>3.6</td>\n",
       "      <td>592</td>\n",
       "      <td>4.500821</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1039</th>\n",
       "      <td>tt5227468</td>\n",
       "      <td>movie</td>\n",
       "      <td>Beiimaan Love</td>\n",
       "      <td>Beiimaan Love</td>\n",
       "      <td>0</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>120.0</td>\n",
       "      <td>[Drama, Romance, Thriller]</td>\n",
       "      <td>2.8</td>\n",
       "      <td>374</td>\n",
       "      <td>4.330305</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1138</th>\n",
       "      <td>tt1126516</td>\n",
       "      <td>movie</td>\n",
       "      <td>Money Hai Toh Honey Hai</td>\n",
       "      <td>Money Hai Toh Honey Hai</td>\n",
       "      <td>0</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>138.0</td>\n",
       "      <td>[Comedy, Drama]</td>\n",
       "      <td>2.8</td>\n",
       "      <td>527</td>\n",
       "      <td>4.020601</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1208</th>\n",
       "      <td>tt3044882</td>\n",
       "      <td>movie</td>\n",
       "      <td>Nasha</td>\n",
       "      <td>Nasha</td>\n",
       "      <td>0</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>122.0</td>\n",
       "      <td>[Drama, Thriller]</td>\n",
       "      <td>3.2</td>\n",
       "      <td>1132</td>\n",
       "      <td>3.810708</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1197</th>\n",
       "      <td>tt3016748</td>\n",
       "      <td>movie</td>\n",
       "      <td>Jacob's Ladder</td>\n",
       "      <td>Jacob's Ladder</td>\n",
       "      <td>0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>89.0</td>\n",
       "      <td>[Drama, Horror, Mystery]</td>\n",
       "      <td>3.4</td>\n",
       "      <td>2065</td>\n",
       "      <td>3.742360</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>846</th>\n",
       "      <td>tt0488164</td>\n",
       "      <td>movie</td>\n",
       "      <td>Moscow Zero</td>\n",
       "      <td>Moscow Zero</td>\n",
       "      <td>0</td>\n",
       "      <td>2006.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>82.0</td>\n",
       "      <td>[Action, Drama, Horror]</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1620</td>\n",
       "      <td>3.474296</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>tt0299981</td>\n",
       "      <td>tvMovie</td>\n",
       "      <td>Highlander: The Source</td>\n",
       "      <td>Highlander: The Source</td>\n",
       "      <td>0</td>\n",
       "      <td>2007.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86.0</td>\n",
       "      <td>[Action, Adventure, Drama]</td>\n",
       "      <td>3.1</td>\n",
       "      <td>8855</td>\n",
       "      <td>3.194020</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         tconst  titleType                         primaryTitle  \\\n",
       "68    tt4110822  tvEpisode                        S.O.S. Part 2   \n",
       "1181  tt7697962  tvEpisode  Chapter Seventeen: The Missionaries   \n",
       "326   tt7124590  tvEpisode  Chapter Thirty-Four: Judgment Night   \n",
       "71    tt8399426  tvEpisode                              Savages   \n",
       "1234  tt2843830  tvEpisode                                VIII.   \n",
       "1054  tt2503932  tvEpisode                      Trial and Error   \n",
       "1281  tt3166390  tvEpisode               Looking for a Plus-One   \n",
       "151   tt3954426  tvEpisode                      Bleeding Kansas   \n",
       "1344  tt6644294  tvEpisode       The Hostile Hospital: Part Two   \n",
       "357   tt4084774  tvEpisode                 Trial and Punishment   \n",
       "708   tt2751234  tvEpisode                         Resurrection   \n",
       "605   tt9141176  tvEpisode                59 horas desaparecido   \n",
       "983   tt5063116  tvEpisode                                Shell   \n",
       "1017  tt2206822  tvEpisode                      Vested Interest   \n",
       "73    tt0847785  tvEpisode                          Like It Was   \n",
       "625   tt7348490  tvEpisode                   Forced Perspective   \n",
       "1272  tt0534736  tvEpisode                 Sex, Lies and Larvae   \n",
       "800   tt0901201  tvEpisode                           Crossroads   \n",
       "659   tt3909890  tvEpisode                                Moppa   \n",
       "1170  tt0647504  tvEpisode                        Tainted Fruit   \n",
       "1001  tt2129485  tvEpisode                      A Desperate Man   \n",
       "977   tt4391820  tvEpisode                              Aisling   \n",
       "1096  tt6822518      movie                    Yasamak Güzel Sey   \n",
       "910   tt3348270  tvEpisode                            Bloodline   \n",
       "746   tt0534765  tvEpisode                      You've Got Male   \n",
       "299   tt4527626  tvEpisode                His Troubled Thoughts   \n",
       "509   tt1256301  tvEpisode                           Nine Lives   \n",
       "897   tt2349242  tvEpisode                        The Fifth Man   \n",
       "1090  tt0212815      movie                             Big Eden   \n",
       "109   tt1753383      movie                      A Dog's Purpose   \n",
       "550   tt8163822      short                The Neighbors' Window   \n",
       "834   tt6509862      movie                             Mr. Long   \n",
       "600   tt0329002      movie             Hard Goodbyes: My Father   \n",
       "642   tt0993186  tvEpisode                  Daleks in Manhattan   \n",
       "691   tt3663996  tvEpisode                          Storm Watch   \n",
       "727   tt3563898   tvSeries            Brynhildr in the Darkness   \n",
       "164   tt0464049      movie                     The History Boys   \n",
       "893   tt8858104      movie                         Guava Island   \n",
       "927   tt3663990  tvEpisode                                Pilot   \n",
       "462   tt5197828  tvEpisode                                Right   \n",
       "1068  tt8369852  tvEpisode              I Think We're Alone Now   \n",
       "940   tt0396190      movie                     Return to Sender   \n",
       "610   tt3526706      movie                            Chevalier   \n",
       "1126  tt2151739      movie                Meet Me in Montenegro   \n",
       "637   tt0857275      movie                      Wonderful World   \n",
       "385   tt0472259      movie                       Alone with Her   \n",
       "1014  tt1159705      movie                        Teenage Angst   \n",
       "1043  tt5518756      movie                      The Misandrists   \n",
       "1154  tt1386492      movie                  This Is Not a Movie   \n",
       "492   tt0882806      movie                           Sugar Boxx   \n",
       "922   tt2948790      movie                     Return to Sender   \n",
       "690   tt4477536      movie                   Fifty Shades Freed   \n",
       "677   tt8923408  tvEpisode                          #JinnHunter   \n",
       "1039  tt5227468      movie                        Beiimaan Love   \n",
       "1138  tt1126516      movie              Money Hai Toh Honey Hai   \n",
       "1208  tt3044882      movie                                Nasha   \n",
       "1197  tt3016748      movie                       Jacob's Ladder   \n",
       "846   tt0488164      movie                          Moscow Zero   \n",
       "90    tt0299981    tvMovie               Highlander: The Source   \n",
       "\n",
       "                             originalTitle  isAdult  startYear  endYear  \\\n",
       "68                           S.O.S. Part 2        0     2015.0      NaN   \n",
       "1181   Chapter Seventeen: The Missionaries        0     2019.0      NaN   \n",
       "326    Chapter Thirty-Four: Judgment Night        0     2018.0      NaN   \n",
       "71                                 Savages        0     2018.0      NaN   \n",
       "1234                                 VIII.        0     2014.0      NaN   \n",
       "1054                       Trial and Error        0     2013.0      NaN   \n",
       "1281                Looking for a Plus-One        0     2014.0      NaN   \n",
       "151                        Bleeding Kansas        0     2014.0      NaN   \n",
       "1344        The Hostile Hospital: Part Two        0     2018.0      NaN   \n",
       "357                   Trial and Punishment        0     2015.0      NaN   \n",
       "708                           Resurrection        0     2014.0      NaN   \n",
       "605                  59 horas desaparecido        0     2019.0      NaN   \n",
       "983                                  Shell        0     2016.0      NaN   \n",
       "1017                       Vested Interest        0     2012.0      NaN   \n",
       "73                             Like It Was        0     2006.0      NaN   \n",
       "625                     Forced Perspective        0     2018.0      NaN   \n",
       "1272                  Sex, Lies and Larvae        0     2000.0      NaN   \n",
       "800                             Crossroads        0     2006.0      NaN   \n",
       "659                                  Moppa        0     2014.0      NaN   \n",
       "1170                         Tainted Fruit        0     2001.0      NaN   \n",
       "1001                       A Desperate Man        0     2012.0      NaN   \n",
       "977                                Aisling        0     2019.0      NaN   \n",
       "1096                     Yasamak Güzel Sey        0     2017.0      NaN   \n",
       "910                              Bloodline        0     2014.0      NaN   \n",
       "746                        You've Got Male        0     2001.0      NaN   \n",
       "299                  His Troubled Thoughts        0     2016.0      NaN   \n",
       "509                             Nine Lives        0     2008.0      NaN   \n",
       "897                          The Fifth Man        0     2012.0      NaN   \n",
       "1090                              Big Eden        0     2000.0      NaN   \n",
       "109                        A Dog's Purpose        0     2017.0      NaN   \n",
       "550                  The Neighbors' Window        0     2019.0      NaN   \n",
       "834                                Ryu san        0     2017.0      NaN   \n",
       "600   Dyskoloi apohairetismoi: O babas mou        0     2002.0      NaN   \n",
       "642                    Daleks in Manhattan        0     2007.0      NaN   \n",
       "691                            Storm Watch        0     2014.0      NaN   \n",
       "727                  Gokukoku no Brynhildr        0     2014.0      NaN   \n",
       "164                       The History Boys        0     2006.0      NaN   \n",
       "893                           Guava Island        0     2019.0      NaN   \n",
       "927                                  Pilot        0     2014.0      NaN   \n",
       "462                                  Right        0     2016.0      NaN   \n",
       "1068               I Think We're Alone Now        0     2019.0      NaN   \n",
       "940                       Return to Sender        0     2004.0      NaN   \n",
       "610                              Chevalier        0     2015.0      NaN   \n",
       "1126                 Meet Me in Montenegro        0     2014.0      NaN   \n",
       "637                        Wonderful World        0     2009.0      NaN   \n",
       "385                         Alone with Her        0     2006.0      NaN   \n",
       "1014                         Teenage Angst        0     2008.0      NaN   \n",
       "1043                       The Misandrists        0     2017.0      NaN   \n",
       "1154                   This Is Not a Movie        0     2011.0      NaN   \n",
       "492                             Sugar Boxx        0     2009.0      NaN   \n",
       "922                       Return to Sender        0     2015.0      NaN   \n",
       "690                     Fifty Shades Freed        0     2018.0      NaN   \n",
       "677                            #JinnHunter        0     2019.0      NaN   \n",
       "1039                         Beiimaan Love        0     2016.0      NaN   \n",
       "1138               Money Hai Toh Honey Hai        0     2008.0      NaN   \n",
       "1208                                 Nasha        0     2013.0      NaN   \n",
       "1197                        Jacob's Ladder        0     2019.0      NaN   \n",
       "846                            Moscow Zero        0     2006.0      NaN   \n",
       "90                  Highlander: The Source        0     2007.0      NaN   \n",
       "\n",
       "      runtimeMinutes                       genres  averageRating  numVotes  \\\n",
       "68              43.0   [Action, Adventure, Drama]            9.4      3820   \n",
       "1181            54.0     [Drama, Fantasy, Horror]            9.2      1536   \n",
       "326             42.0      [Crime, Drama, Mystery]            9.1      1859   \n",
       "71              58.0    [Drama, Fantasy, Romance]            9.0      1428   \n",
       "1234            57.0           [Adventure, Drama]            8.9      1753   \n",
       "1054            43.0     [Drama, Fantasy, Horror]            8.6      2495   \n",
       "1281            28.0     [Comedy, Drama, Romance]            8.7       396   \n",
       "151             42.0             [Drama, Western]            8.6       437   \n",
       "1344            40.0   [Adventure, Comedy, Drama]            8.3       812   \n",
       "357             56.0           [Adventure, Drama]            8.8       289   \n",
       "708             43.0       [Crime, Drama, Horror]            8.0      1077   \n",
       "605             48.0     [Crime, Drama, Thriller]            8.1       674   \n",
       "983             32.0              [Comedy, Drama]            8.5       275   \n",
       "1017            43.0       [Comedy, Crime, Drama]            8.0       525   \n",
       "73              43.0     [Comedy, Drama, Mystery]            8.1       405   \n",
       "625             43.0      [Crime, Drama, Mystery]            7.9       413   \n",
       "1272            46.0      [Crime, Drama, Mystery]            7.7       689   \n",
       "800             42.0     [Action, Drama, Mystery]            7.7       654   \n",
       "659             27.0              [Comedy, Drama]            7.8       410   \n",
       "1170            98.0      [Crime, Drama, Mystery]            7.7       538   \n",
       "1001            44.0       [Action, Crime, Drama]            7.7       501   \n",
       "977             51.0      [Crime, Drama, Fantasy]            7.5      1558   \n",
       "1096           101.0              [Comedy, Drama]            7.5      1541   \n",
       "910             44.0     [Drama, Horror, Mystery]            7.7       436   \n",
       "746             45.0      [Crime, Drama, Mystery]            7.6       620   \n",
       "299             59.0     [Crime, Drama, Thriller]            7.5       859   \n",
       "509             44.0       [Action, Crime, Drama]            7.6       501   \n",
       "897             44.0       [Action, Crime, Drama]            7.8       270   \n",
       "1090           118.0     [Comedy, Drama, Romance]            7.3      3906   \n",
       "109            100.0   [Adventure, Comedy, Drama]            7.2     61521   \n",
       "550             21.0               [Drama, Short]            7.2      2222   \n",
       "834            129.0       [Action, Crime, Drama]            7.1       960   \n",
       "600            113.0              [Drama, Family]            7.1       423   \n",
       "642             45.0   [Adventure, Drama, Family]            7.0      4982   \n",
       "691             43.0             [Drama, Romance]            7.0       309   \n",
       "727             22.0   [Action, Animation, Drama]            6.8       733   \n",
       "164            109.0     [Comedy, Drama, Romance]            6.8     19858   \n",
       "893             55.0       [Comedy, Drama, Music]            6.7      7935   \n",
       "927             44.0             [Drama, Romance]            6.6       403   \n",
       "462             42.0      [Crime, Drama, Mystery]            6.5       641   \n",
       "1068            43.0  [Adventure, Drama, Mystery]            6.3       563   \n",
       "940            109.0            [Drama, Thriller]            6.4      2342   \n",
       "610            105.0              [Comedy, Drama]            6.3      3890   \n",
       "1126            90.0     [Comedy, Drama, Romance]            5.8       258   \n",
       "637             89.0             [Drama, Romance]            6.1      2288   \n",
       "385             78.0     [Crime, Drama, Thriller]            6.0      3738   \n",
       "1014            64.0            [Drama, Thriller]            5.3       355   \n",
       "1043            91.0              [Comedy, Drama]            5.1       387   \n",
       "1154            99.0              [Comedy, Drama]            4.6       642   \n",
       "492             86.0               [Crime, Drama]            3.5       229   \n",
       "922             92.0            [Drama, Thriller]            5.1     11434   \n",
       "690            105.0   [Drama, Romance, Thriller]            4.5     50572   \n",
       "677             24.0     [Drama, Fantasy, Horror]            3.6       592   \n",
       "1039           120.0   [Drama, Romance, Thriller]            2.8       374   \n",
       "1138           138.0              [Comedy, Drama]            2.8       527   \n",
       "1208           122.0            [Drama, Thriller]            3.2      1132   \n",
       "1197            89.0     [Drama, Horror, Mystery]            3.4      2065   \n",
       "846             82.0      [Action, Drama, Horror]            3.0      1620   \n",
       "90              86.0   [Action, Adventure, Drama]            3.1      8855   \n",
       "\n",
       "         score  \n",
       "68    9.254624  \n",
       "1181  8.892450  \n",
       "326   8.850993  \n",
       "71    8.700045  \n",
       "1234  8.660784  \n",
       "1054  8.451165  \n",
       "1281  8.014679  \n",
       "151   7.991253  \n",
       "1344  7.976536  \n",
       "357   7.928908  \n",
       "708   7.794774  \n",
       "605   7.777823  \n",
       "983   7.741020  \n",
       "1017  7.644528  \n",
       "73    7.641127  \n",
       "625   7.518184  \n",
       "1272  7.482870  \n",
       "800   7.474263  \n",
       "659   7.452229  \n",
       "1170  7.440123  \n",
       "1001  7.426951  \n",
       "977   7.414087  \n",
       "1096  7.413262  \n",
       "910   7.400262  \n",
       "746   7.392196  \n",
       "299   7.358892  \n",
       "509   7.358321  \n",
       "897   7.354658  \n",
       "1090  7.273948  \n",
       "109   7.198626  \n",
       "550   7.165391  \n",
       "834   7.047918  \n",
       "600   7.005022  \n",
       "642   6.992511  \n",
       "691   6.927461  \n",
       "727   6.807042  \n",
       "164   6.800337  \n",
       "893   6.703635  \n",
       "927   6.683187  \n",
       "462   6.586752  \n",
       "1068  6.453124  \n",
       "940   6.438263  \n",
       "610   6.329443  \n",
       "1126  6.284136  \n",
       "637   6.166378  \n",
       "385   6.047889  \n",
       "1014  5.899785  \n",
       "1043  5.742978  \n",
       "1154  5.186193  \n",
       "492   5.164791  \n",
       "922   5.133960  \n",
       "690   4.510501  \n",
       "677   4.500821  \n",
       "1039  4.330305  \n",
       "1138  4.020601  \n",
       "1208  3.810708  \n",
       "1197  3.742360  \n",
       "846   3.474296  \n",
       "90    3.194020  "
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "user_prefer_recommender(df,\n",
    "                       ask_adult = 'no',\n",
    "                        ask_start_year = 2000,\n",
    "                       ask_genre = 'drama'\n",
    "                    )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}