generes_based_search.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Module\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "import ast\n",
    "from statistics import mean\n",
    "import pickle\n",
    "\n",
    "#importing preprocessed file\n",
    "movies=pickle.load(open('./data/movies_meta_data.pkl','rb'))\n",
    "\n",
    "movies"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [],
   "source": [
    "# list of all genres\n",
    "all_geners=[]\n",
    "\n",
    "# iterate over all movies\n",
    "for iter in movies.index:\n",
    "    L = []\n",
    "    for obj in ast.literal_eval(movies['genres'][iter]):\n",
    "        print(obj['name'])\n",
    "        L.append(obj['name'])\n",
    "        all_geners.append(obj['name'])\n",
    "    movies['genres'][iter]=L\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>movie_id</th>\n",
       "      <th>genres</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>19995</td>\n",
       "      <td>[Action, Adventure, Fantasy, Science Fiction]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>285</td>\n",
       "      <td>[Adventure, Fantasy, Action]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>206647</td>\n",
       "      <td>[Action, Adventure, Crime]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>49026</td>\n",
       "      <td>[Action, Crime, Drama, Thriller]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>49529</td>\n",
       "      <td>[Action, Adventure, Science Fiction]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4804</th>\n",
       "      <td>9367</td>\n",
       "      <td>[Action, Crime, Thriller]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4805</th>\n",
       "      <td>72766</td>\n",
       "      <td>[Comedy, Romance]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4806</th>\n",
       "      <td>231617</td>\n",
       "      <td>[Comedy, Drama, Romance, TV Movie]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4807</th>\n",
       "      <td>126186</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4808</th>\n",
       "      <td>25975</td>\n",
       "      <td>[Documentary]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4809 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      movie_id                                         genres\n",
       "0        19995  [Action, Adventure, Fantasy, Science Fiction]\n",
       "1          285                   [Adventure, Fantasy, Action]\n",
       "2       206647                     [Action, Adventure, Crime]\n",
       "3        49026               [Action, Crime, Drama, Thriller]\n",
       "4        49529           [Action, Adventure, Science Fiction]\n",
       "...        ...                                            ...\n",
       "4804      9367                      [Action, Crime, Thriller]\n",
       "4805     72766                              [Comedy, Romance]\n",
       "4806    231617             [Comedy, Drama, Romance, TV Movie]\n",
       "4807    126186                                             []\n",
       "4808     25975                                  [Documentary]\n",
       "\n",
       "[4809 rows x 2 columns]"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# generate dataframe of genres and movie id\n",
    "gener_movie_id=pd.DataFrame(movies,columns=['movie_id','genres'])\n",
    "gener_movie_id "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[[19995, 'Action'],\n",
       " [19995, 'Adventure'],\n",
       " [19995, 'Fantasy'],\n",
       " [19995, 'Science Fiction'],\n",
       " [285, 'Adventure'],\n",
       " [285, 'Fantasy'],\n",
       " [285, 'Action'],\n",
       " [206647, 'Action'],\n",
       " [206647, 'Adventure'],\n",
       " [206647, 'Crime'],\n",
       " [49026, 'Action'],\n",
       " [49026, 'Crime'],\n",
       " [49026, 'Drama'],\n",
       " [49026, 'Thriller'],\n",
       " [49529, 'Action'],\n",
       " [49529, 'Adventure'],\n",
       " [49529, 'Science Fiction'],\n",
       " [559, 'Fantasy'],\n",
       " [559, 'Action'],\n",
       " [559, 'Adventure'],\n",
       " [38757, 'Animation'],\n",
       " [38757, 'Family'],\n",
       " [99861, 'Action'],\n",
       " [99861, 'Adventure'],\n",
       " [99861, 'Science Fiction'],\n",
       " [767, 'Adventure'],\n",
       " [767, 'Fantasy'],\n",
       " [767, 'Family'],\n",
       " [209112, 'Action'],\n",
       " [209112, 'Adventure'],\n",
       " [209112, 'Fantasy'],\n",
       " [1452, 'Adventure'],\n",
       " [1452, 'Fantasy'],\n",
       " [1452, 'Action'],\n",
       " [1452, 'Science Fiction'],\n",
       " [10764, 'Adventure'],\n",
       " [10764, 'Action'],\n",
       " [10764, 'Thriller'],\n",
       " [10764, 'Crime'],\n",
       " [58, 'Adventure'],\n",
       " [58, 'Fantasy'],\n",
       " [58, 'Action'],\n",
       " [57201, 'Action'],\n",
       " [57201, 'Adventure'],\n",
       " [57201, 'Western'],\n",
       " [49521, 'Action'],\n",
       " [49521, 'Adventure'],\n",
       " [49521, 'Fantasy'],\n",
       " [49521, 'Science Fiction'],\n",
       " [2454, 'Adventure'],\n",
       " [2454, 'Family'],\n",
       " [2454, 'Fantasy'],\n",
       " [24428, 'Science Fiction'],\n",
       " [24428, 'Action'],\n",
       " [24428, 'Adventure'],\n",
       " [1865, 'Adventure'],\n",
       " [1865, 'Action'],\n",
       " [1865, 'Fantasy'],\n",
       " [41154, 'Action'],\n",
       " [41154, 'Comedy'],\n",
       " [41154, 'Science Fiction'],\n",
       " [122917, 'Action'],\n",
       " [122917, 'Adventure'],\n",
       " [122917, 'Fantasy'],\n",
       " [1930, 'Action'],\n",
       " [1930, 'Adventure'],\n",
       " [1930, 'Fantasy'],\n",
       " [20662, 'Action'],\n",
       " [20662, 'Adventure'],\n",
       " [57158, 'Adventure'],\n",
       " [57158, 'Fantasy'],\n",
       " [2268, 'Adventure'],\n",
       " [2268, 'Fantasy'],\n",
       " [254, 'Adventure'],\n",
       " [254, 'Drama'],\n",
       " [254, 'Action'],\n",
       " [597, 'Drama'],\n",
       " [597, 'Romance'],\n",
       " [597, 'Thriller'],\n",
       " [271110, 'Adventure'],\n",
       " [271110, 'Action'],\n",
       " [271110, 'Science Fiction'],\n",
       " [44833, 'Thriller'],\n",
       " [44833, 'Action'],\n",
       " [44833, 'Adventure'],\n",
       " [44833, 'Science Fiction'],\n",
       " [135397, 'Action'],\n",
       " [135397, 'Adventure'],\n",
       " [135397, 'Science Fiction'],\n",
       " [135397, 'Thriller'],\n",
       " [37724, 'Action'],\n",
       " [37724, 'Adventure'],\n",
       " [37724, 'Thriller'],\n",
       " [558, 'Action'],\n",
       " [558, 'Adventure'],\n",
       " [558, 'Fantasy'],\n",
       " [68721, 'Action'],\n",
       " [68721, 'Adventure'],\n",
       " [68721, 'Science Fiction'],\n",
       " [12155, 'Family'],\n",
       " [12155, 'Fantasy'],\n",
       " [12155, 'Adventure'],\n",
       " [36668, 'Adventure'],\n",
       " [36668, 'Action'],\n",
       " [36668, 'Science Fiction'],\n",
       " [36668, 'Thriller'],\n",
       " [62211, 'Animation'],\n",
       " [62211, 'Family'],\n",
       " [8373, 'Science Fiction'],\n",
       " [8373, 'Action'],\n",
       " [8373, 'Adventure'],\n",
       " [91314, 'Science Fiction'],\n",
       " [91314, 'Action'],\n",
       " [91314, 'Adventure'],\n",
       " [68728, 'Fantasy'],\n",
       " [68728, 'Adventure'],\n",
       " [68728, 'Family'],\n",
       " [102382, 'Action'],\n",
       " [102382, 'Adventure'],\n",
       " [102382, 'Fantasy'],\n",
       " [20526, 'Adventure'],\n",
       " [20526, 'Action'],\n",
       " [20526, 'Science Fiction'],\n",
       " [49013, 'Animation'],\n",
       " [49013, 'Family'],\n",
       " [49013, 'Adventure'],\n",
       " [49013, 'Comedy'],\n",
       " [44912, 'Adventure'],\n",
       " [44912, 'Action'],\n",
       " [44912, 'Thriller'],\n",
       " [44912, 'Science Fiction'],\n",
       " [10193, 'Animation'],\n",
       " [10193, 'Family'],\n",
       " [10193, 'Comedy'],\n",
       " [534, 'Action'],\n",
       " [534, 'Science Fiction'],\n",
       " [534, 'Thriller'],\n",
       " [168259, 'Action'],\n",
       " [72190, 'Action'],\n",
       " [72190, 'Drama'],\n",
       " [72190, 'Horror'],\n",
       " [72190, 'Science Fiction'],\n",
       " [72190, 'Thriller'],\n",
       " [127585, 'Action'],\n",
       " [127585, 'Adventure'],\n",
       " [127585, 'Fantasy'],\n",
       " [127585, 'Science Fiction'],\n",
       " [54138, 'Action'],\n",
       " [54138, 'Adventure'],\n",
       " [54138, 'Science Fiction'],\n",
       " [81005, 'Action'],\n",
       " [81005, 'Family'],\n",
       " [81005, 'Fantasy'],\n",
       " [64682, 'Drama'],\n",
       " [64682, 'Romance'],\n",
       " [9543, 'Adventure'],\n",
       " [9543, 'Fantasy'],\n",
       " [9543, 'Action'],\n",
       " [9543, 'Romance'],\n",
       " [68726, 'Action'],\n",
       " [68726, 'Science Fiction'],\n",
       " [68726, 'Adventure'],\n",
       " [38356, 'Action'],\n",
       " [38356, 'Science Fiction'],\n",
       " [38356, 'Adventure'],\n",
       " [217, 'Adventure'],\n",
       " [217, 'Action'],\n",
       " [105864, 'Adventure'],\n",
       " [105864, 'Animation'],\n",
       " [105864, 'Family'],\n",
       " [62177, 'Animation'],\n",
       " [62177, 'Adventure'],\n",
       " [62177, 'Comedy'],\n",
       " [62177, 'Family'],\n",
       " [62177, 'Action'],\n",
       " [62177, 'Fantasy'],\n",
       " [188927, 'Action'],\n",
       " [188927, 'Adventure'],\n",
       " [188927, 'Science Fiction'],\n",
       " [10681, 'Animation'],\n",
       " [10681, 'Family'],\n",
       " [5174, 'Action'],\n",
       " [5174, 'Comedy'],\n",
       " [5174, 'Crime'],\n",
       " [5174, 'Thriller'],\n",
       " [14161, 'Action'],\n",
       " [14161, 'Adventure'],\n",
       " [14161, 'Science Fiction'],\n",
       " [17979, 'Animation'],\n",
       " [17979, 'Drama'],\n",
       " [76757, 'Science Fiction'],\n",
       " [76757, 'Fantasy'],\n",
       " [76757, 'Action'],\n",
       " [76757, 'Adventure'],\n",
       " [258489, 'Action'],\n",
       " [258489, 'Adventure'],\n",
       " [411, 'Adventure'],\n",
       " [411, 'Family'],\n",
       " [411, 'Fantasy'],\n",
       " [246655, 'Science Fiction'],\n",
       " [155, 'Drama'],\n",
       " [155, 'Action'],\n",
       " [155, 'Crime'],\n",
       " [155, 'Thriller'],\n",
       " [14160, 'Animation'],\n",
       " [14160, 'Comedy'],\n",
       " [14160, 'Family'],\n",
       " [14160, 'Adventure'],\n",
       " [15512, 'Animation'],\n",
       " [15512, 'Family'],\n",
       " [15512, 'Adventure'],\n",
       " [15512, 'Science Fiction'],\n",
       " [1726, 'Action'],\n",
       " [1726, 'Science Fiction'],\n",
       " [1726, 'Adventure'],\n",
       " [44826, 'Adventure'],\n",
       " [44826, 'Drama'],\n",
       " [44826, 'Family'],\n",
       " [8487, 'Action'],\n",
       " [8487, 'Adventure'],\n",
       " [8487, 'Comedy'],\n",
       " [8487, 'Science Fiction'],\n",
       " [8487, 'Western'],\n",
       " [1735, 'Adventure'],\n",
       " [1735, 'Action'],\n",
       " [1735, 'Fantasy'],\n",
       " [297761, 'Action'],\n",
       " [297761, 'Adventure'],\n",
       " [297761, 'Crime'],\n",
       " [297761, 'Fantasy'],\n",
       " [297761, 'Science Fiction'],\n",
       " [2698, 'Fantasy'],\n",
       " [2698, 'Comedy'],\n",
       " [2698, 'Family'],\n",
       " [137113, 'Action'],\n",
       " [137113, 'Science Fiction'],\n",
       " [9804, 'Adventure'],\n",
       " [9804, 'Action'],\n",
       " [14869, 'Adventure'],\n",
       " [14869, 'Action'],\n",
       " [14869, 'Thriller'],\n",
       " [14869, 'Science Fiction'],\n",
       " [150540, 'Drama'],\n",
       " [150540, 'Comedy'],\n",
       " [150540, 'Animation'],\n",
       " [150540, 'Family'],\n",
       " [278927, 'Family'],\n",
       " [278927, 'Adventure'],\n",
       " [278927, 'Drama'],\n",
       " [278927, 'Fantasy'],\n",
       " [10138, 'Adventure'],\n",
       " [10138, 'Action'],\n",
       " [10138, 'Science Fiction'],\n",
       " [58595, 'Adventure'],\n",
       " [58595, 'Fantasy'],\n",
       " [58595, 'Drama'],\n",
       " [102651, 'Fantasy'],\n",
       " [102651, 'Adventure'],\n",
       " [102651, 'Action'],\n",
       " [102651, 'Family'],\n",
       " [102651, 'Romance'],\n",
       " [119450, 'Science Fiction'],\n",
       " [119450, 'Action'],\n",
       " [119450, 'Drama'],\n",
       " [119450, 'Thriller'],\n",
       " [79698, 'Action'],\n",
       " [79698, 'Adventure'],\n",
       " [79698, 'Science Fiction'],\n",
       " [79698, 'Romance'],\n",
       " [64686, 'Drama'],\n",
       " [64686, 'Action'],\n",
       " [64686, 'Adventure'],\n",
       " [64686, 'Fantasy'],\n",
       " [100402, 'Action'],\n",
       " [100402, 'Adventure'],\n",
       " [100402, 'Science Fiction'],\n",
       " [10192, 'Comedy'],\n",
       " [10192, 'Adventure'],\n",
       " [10192, 'Fantasy'],\n",
       " [10192, 'Animation'],\n",
       " [10192, 'Family'],\n",
       " [158852, 'Adventure'],\n",
       " [158852, 'Family'],\n",
       " [158852, 'Mystery'],\n",
       " [158852, 'Science Fiction'],\n",
       " [177572, 'Adventure'],\n",
       " [177572, 'Family'],\n",
       " [177572, 'Animation'],\n",
       " [177572, 'Action'],\n",
       " [177572, 'Comedy'],\n",
       " [82690, 'Family'],\n",
       " [82690, 'Animation'],\n",
       " [82690, 'Comedy'],\n",
       " [82690, 'Adventure'],\n",
       " [5255, 'Adventure'],\n",
       " [5255, 'Animation'],\n",
       " [5255, 'Family'],\n",
       " [5255, 'Fantasy'],\n",
       " [47933, 'Action'],\n",
       " [47933, 'Adventure'],\n",
       " [47933, 'Science Fiction'],\n",
       " [10191, 'Fantasy'],\n",
       " [10191, 'Adventure'],\n",
       " [10191, 'Animation'],\n",
       " [10191, 'Family'],\n",
       " [296, 'Action'],\n",
       " [296, 'Thriller'],\n",
       " [296, 'Science Fiction'],\n",
       " [118340, 'Action'],\n",
       " [118340, 'Science Fiction'],\n",
       " [118340, 'Adventure'],\n",
       " [157336, 'Adventure'],\n",
       " [157336, 'Drama'],\n",
       " [157336, 'Science Fiction'],\n",
       " [27205, 'Action'],\n",
       " [27205, 'Thriller'],\n",
       " [27205, 'Science Fiction'],\n",
       " [27205, 'Mystery'],\n",
       " [27205, 'Adventure'],\n",
       " [315011, 'Action'],\n",
       " [315011, 'Adventure'],\n",
       " [315011, 'Drama'],\n",
       " [315011, 'Horror'],\n",
       " [315011, 'Science Fiction'],\n",
       " [49051, 'Adventure'],\n",
       " [49051, 'Fantasy'],\n",
       " [49051, 'Action'],\n",
       " [9799, 'Action'],\n",
       " [9799, 'Crime'],\n",
       " [9799, 'Thriller'],\n",
       " [4922, 'Fantasy'],\n",
       " [4922, 'Drama'],\n",
       " [4922, 'Thriller'],\n",
       " [4922, 'Mystery'],\n",
       " [4922, 'Romance'],\n",
       " [49538, 'Action'],\n",
       " [49538, 'Science Fiction'],\n",
       " [49538, 'Adventure'],\n",
       " [131634, 'Action'],\n",
       " [131634, 'Adventure'],\n",
       " [131634, 'Science Fiction'],\n",
       " [27022, 'Fantasy'],\n",
       " [27022, 'Adventure'],\n",
       " [27022, 'Action'],\n",
       " [27022, 'Comedy'],\n",
       " [27022, 'Drama'],\n",
       " [503, 'Adventure'],\n",
       " [503, 'Action'],\n",
       " [503, 'Drama'],\n",
       " [503, 'Thriller'],\n",
       " [241259, 'Fantasy'],\n",
       " [810, 'Fantasy'],\n",
       " [810, 'Adventure'],\n",
       " [810, 'Animation'],\n",
       " [810, 'Comedy'],\n",
       " [810, 'Family'],\n",
       " [68735, 'Action'],\n",
       " [68735, 'Adventure'],\n",
       " [68735, 'Fantasy'],\n",
       " [87101, 'Science Fiction'],\n",
       " [87101, 'Action'],\n",
       " [87101, 'Thriller'],\n",
       " [87101, 'Adventure'],\n",
       " [10140, 'Adventure'],\n",
       " [10140, 'Family'],\n",
       " [10140, 'Fantasy'],\n",
       " [676, 'History'],\n",
       " [676, 'Romance'],\n",
       " [676, 'War'],\n",
       " [1858, 'Adventure'],\n",
       " [1858, 'Science Fiction'],\n",
       " [1858, 'Action'],\n",
       " [1966, 'War'],\n",
       " [1966, 'History'],\n",
       " [1966, 'Action'],\n",
       " [1966, 'Adventure'],\n",
       " [1966, 'Drama'],\n",
       " [1966, 'Romance'],\n",
       " [675, 'Adventure'],\n",
       " [675, 'Fantasy'],\n",
       " [675, 'Family'],\n",
       " [675, 'Mystery'],\n",
       " [674, 'Adventure'],\n",
       " [674, 'Fantasy'],\n",
       " [674, 'Family'],\n",
       " [8960, 'Fantasy'],\n",
       " [8960, 'Action'],\n",
       " [6479, 'Drama'],\n",
       " [6479, 'Horror'],\n",
       " [6479, 'Action'],\n",
       " [6479, 'Thriller'],\n",
       " [6479, 'Science Fiction'],\n",
       " [118, 'Adventure'],\n",
       " [118, 'Comedy'],\n",
       " [118, 'Family'],\n",
       " [118, 'Fantasy'],\n",
       " [2062, 'Animation'],\n",
       " [2062, 'Comedy'],\n",
       " [2062, 'Family'],\n",
       " [2062, 'Fantasy'],\n",
       " [272, 'Action'],\n",
       " [272, 'Crime'],\n",
       " [272, 'Drama'],\n",
       " [10527, 'Family'],\n",
       " [10527, 'Animation'],\n",
       " [18360, 'Adventure'],\n",
       " [18360, 'Fantasy'],\n",
       " [18360, 'Action'],\n",
       " [18360, 'Comedy'],\n",
       " [18360, 'Family'],\n",
       " [2080, 'Adventure'],\n",
       " [2080, 'Action'],\n",
       " [2080, 'Thriller'],\n",
       " [2080, 'Science Fiction'],\n",
       " [605, 'Adventure'],\n",
       " [605, 'Action'],\n",
       " [605, 'Thriller'],\n",
       " [605, 'Science Fiction'],\n",
       " [109445, 'Animation'],\n",
       " [109445, 'Adventure'],\n",
       " [109445, 'Family'],\n",
       " [604, 'Adventure'],\n",
       " [604, 'Action'],\n",
       " [604, 'Thriller'],\n",
       " [604, 'Science Fiction'],\n",
       " [76338, 'Action'],\n",
       " [76338, 'Adventure'],\n",
       " [76338, 'Fantasy'],\n",
       " [76341, 'Action'],\n",
       " [76341, 'Adventure'],\n",
       " [76341, 'Science Fiction'],\n",
       " [76341, 'Thriller'],\n",
       " [13448, 'Thriller'],\n",
       " [13448, 'Mystery'],\n",
       " [10195, 'Adventure'],\n",
       " [10195, 'Fantasy'],\n",
       " [10195, 'Action'],\n",
       " [13053, 'Animation'],\n",
       " [13053, 'Family'],\n",
       " [13053, 'Adventure'],\n",
       " [13053, 'Comedy'],\n",
       " [19585, 'Fantasy'],\n",
       " [19585, 'Action'],\n",
       " [19585, 'Adventure'],\n",
       " [19585, 'Family'],\n",
       " [19585, 'Comedy'],\n",
       " [57165, 'Adventure'],\n",
       " [62213, 'Comedy'],\n",
       " [62213, 'Fantasy'],\n",
       " [177677, 'Action'],\n",
       " [177677, 'Adventure'],\n",
       " [177677, 'Thriller'],\n",
       " [7978, 'Drama'],\n",
       " [7978, 'Horror'],\n",
       " [7978, 'Thriller'],\n",
       " [5559, 'Family'],\n",
       " [5559, 'Animation'],\n",
       " [5559, 'Adventure'],\n",
       " [5559, 'Comedy'],\n",
       " [49444, 'Animation'],\n",
       " [49444, 'Family'],\n",
       " [10196, 'Action'],\n",
       " [10196, 'Adventure'],\n",
       " [10196, 'Family'],\n",
       " [10196, 'Fantasy'],\n",
       " [956, 'Adventure'],\n",
       " [956, 'Action'],\n",
       " [956, 'Thriller'],\n",
       " [117251, 'Action'],\n",
       " [117251, 'Drama'],\n",
       " [117251, 'Thriller'],\n",
       " [50321, 'Adventure'],\n",
       " [50321, 'Animation'],\n",
       " [50321, 'Family'],\n",
       " [11619, 'Adventure'],\n",
       " [11619, 'Animation'],\n",
       " [11619, 'Comedy'],\n",
       " [11619, 'Family'],\n",
       " [266647, 'Adventure'],\n",
       " [266647, 'Family'],\n",
       " [266647, 'Fantasy'],\n",
       " [82703, 'Animation'],\n",
       " [82703, 'Adventure'],\n",
       " [82703, 'Family'],\n",
       " [652, 'Adventure'],\n",
       " [652, 'Drama'],\n",
       " [652, 'War'],\n",
       " [80321, 'Animation'],\n",
       " [80321, 'Family'],\n",
       " [36669, 'Adventure'],\n",
       " [36669, 'Action'],\n",
       " [36669, 'Thriller'],\n",
       " [43074, 'Action'],\n",
       " [43074, 'Fantasy'],\n",
       " [43074, 'Comedy'],\n",
       " [95, 'Action'],\n",
       " [95, 'Thriller'],\n",
       " [95, 'Science Fiction'],\n",
       " [95, 'Adventure'],\n",
       " [608, 'Action'],\n",
       " [608, 'Adventure'],\n",
       " [608, 'Comedy'],\n",
       " [608, 'Science Fiction'],\n",
       " [2310, 'Adventure'],\n",
       " [2310, 'Action'],\n",
       " [2310, 'Animation'],\n",
       " [140300, 'Action'],\n",
       " [140300, 'Adventure'],\n",
       " [140300, 'Animation'],\n",
       " [140300, 'Comedy'],\n",
       " [140300, 'Family'],\n",
       " [56292, 'Action'],\n",
       " [56292, 'Thriller'],\n",
       " [56292, 'Adventure'],\n",
       " [81188, 'Fantasy'],\n",
       " [81188, 'Animation'],\n",
       " [81188, 'Family'],\n",
       " [7552, 'Comedy'],\n",
       " [616, 'Drama'],\n",
       " [616, 'Action'],\n",
       " [616, 'War'],\n",
       " [616, 'History'],\n",
       " [147441, 'Adventure'],\n",
       " [147441, 'Drama'],\n",
       " [147441, 'Action'],\n",
       " [13475, 'Science Fiction'],\n",
       " [13475, 'Action'],\n",
       " [13475, 'Adventure'],\n",
       " [557, 'Fantasy'],\n",
       " [557, 'Action'],\n",
       " [82702, 'Fantasy'],\n",
       " [82702, 'Action'],\n",
       " [82702, 'Adventure'],\n",
       " [82702, 'Animation'],\n",
       " [82702, 'Comedy'],\n",
       " [82702, 'Family'],\n",
       " [205584, 'Fantasy'],\n",
       " [10048, 'Action'],\n",
       " [13183, 'Action'],\n",
       " [13183, 'Mystery'],\n",
       " [13183, 'Science Fiction'],\n",
       " [944, 'Action'],\n",
       " [944, 'Adventure'],\n",
       " [944, 'Comedy'],\n",
       " [944, 'Crime'],\n",
       " [944, 'Thriller'],\n",
       " [1927, 'Drama'],\n",
       " [1927, 'Action'],\n",
       " [1927, 'Science Fiction'],\n",
       " [72559, 'Adventure'],\n",
       " [72559, 'Action'],\n",
       " [72559, 'Science Fiction'],\n",
       " [72559, 'Thriller'],\n",
       " [7364, 'Action'],\n",
       " [7364, 'Adventure'],\n",
       " [7364, 'Comedy'],\n",
       " [7364, 'Drama'],\n",
       " [7364, 'Mystery'],\n",
       " [2114, 'Adventure'],\n",
       " [2114, 'Action'],\n",
       " [2114, 'Animation'],\n",
       " [2114, 'Fantasy'],\n",
       " [2114, 'Science Fiction'],\n",
       " [2114, 'Thriller'],\n",
       " [1771, 'Action'],\n",
       " [1771, 'Adventure'],\n",
       " [1771, 'Science Fiction'],\n",
       " [36643, 'Adventure'],\n",
       " [36643, 'Action'],\n",
       " [36643, 'Thriller'],\n",
       " [8619, 'Adventure'],\n",
       " [50620, 'Adventure'],\n",
       " [50620, 'Fantasy'],\n",
       " [50620, 'Drama'],\n",
       " [50620, 'Romance'],\n",
       " [65759, 'Animation'],\n",
       " [65759, 'Comedy'],\n",
       " [65759, 'Family'],\n",
       " [1724, 'Science Fiction'],\n",
       " [1724, 'Action'],\n",
       " [1724, 'Adventure'],\n",
       " [267935, 'Adventure'],\n",
       " [267935, 'Family'],\n",
       " [267935, 'Fantasy'],\n",
       " [281957, 'Western'],\n",
       " [281957, 'Drama'],\n",
       " [281957, 'Adventure'],\n",
       " [281957, 'Thriller'],\n",
       " [77950, 'Animation'],\n",
       " [77950, 'Family'],\n",
       " [44896, 'Animation'],\n",
       " [44896, 'Comedy'],\n",
       " [44896, 'Family'],\n",
       " [44896, 'Western'],\n",
       " [44896, 'Adventure'],\n",
       " [270946, 'Family'],\n",
       " [270946, 'Animation'],\n",
       " [270946, 'Adventure'],\n",
       " [270946, 'Comedy'],\n",
       " [2503, 'Action'],\n",
       " [2503, 'Drama'],\n",
       " [2503, 'Mystery'],\n",
       " [2503, 'Thriller'],\n",
       " [9502, 'Adventure'],\n",
       " [9502, 'Animation'],\n",
       " [9502, 'Family'],\n",
       " [9502, 'Comedy'],\n",
       " [102899, 'Science Fiction'],\n",
       " [102899, 'Action'],\n",
       " [102899, 'Adventure'],\n",
       " [101299, 'Adventure'],\n",
       " [101299, 'Action'],\n",
       " [101299, 'Science Fiction'],\n",
       " [228161, 'Fantasy'],\n",
       " [228161, 'Comedy'],\n",
       " [228161, 'Animation'],\n",
       " [228161, 'Science Fiction'],\n",
       " [228161, 'Family'],\n",
       " [74, 'Adventure'],\n",
       " [74, 'Thriller'],\n",
       " [74, 'Science Fiction'],\n",
       " [8961, 'Adventure'],\n",
       " [8961, 'Action'],\n",
       " [8961, 'Comedy'],\n",
       " [8961, 'Thriller'],\n",
       " [8961, 'Crime'],\n",
       " [417859, 'Action'],\n",
       " [417859, 'Adventure'],\n",
       " [417859, 'Animation'],\n",
       " [417859, 'Family'],\n",
       " [417859, 'Fantasy'],\n",
       " [27576, 'Action'],\n",
       " [27576, 'Mystery'],\n",
       " [27576, 'Thriller'],\n",
       " [86834, 'Drama'],\n",
       " [86834, 'Adventure'],\n",
       " [17578, 'Adventure'],\n",
       " [17578, 'Animation'],\n",
       " [17578, 'Mystery'],\n",
       " [673, 'Adventure'],\n",
       " [673, 'Fantasy'],\n",
       " [673, 'Family'],\n",
       " [6972, 'Drama'],\n",
       " [82700, 'Science Fiction'],\n",
       " [82700, 'Action'],\n",
       " [82700, 'Adventure'],\n",
       " [10567, 'Animation'],\n",
       " [10567, 'Family'],\n",
       " [181533, 'Adventure'],\n",
       " [181533, 'Comedy'],\n",
       " [181533, 'Fantasy'],\n",
       " [181533, 'Family'],\n",
       " [38055, 'Animation'],\n",
       " [38055, 'Action'],\n",
       " [38055, 'Comedy'],\n",
       " [38055, 'Family'],\n",
       " [38055, 'Science Fiction'],\n",
       " [671, 'Adventure'],\n",
       " [671, 'Fantasy'],\n",
       " [671, 'Family'],\n",
       " [49524, 'Fantasy'],\n",
       " [49524, 'Action'],\n",
       " [49524, 'Comedy'],\n",
       " [49524, 'Crime'],\n",
       " [22, 'Adventure'],\n",
       " [22, 'Fantasy'],\n",
       " [22, 'Action'],\n",
       " [131631, 'Science Fiction'],\n",
       " [131631, 'Adventure'],\n",
       " [131631, 'Thriller'],\n",
       " [591, 'Thriller'],\n",
       " [591, 'Mystery'],\n",
       " [172385, 'Animation'],\n",
       " [172385, 'Adventure'],\n",
       " [172385, 'Comedy'],\n",
       " [172385, 'Family'],\n",
       " [36658, 'Adventure'],\n",
       " [36658, 'Action'],\n",
       " [36658, 'Science Fiction'],\n",
       " [36658, 'Thriller'],\n",
       " [51497, 'Action'],\n",
       " [51497, 'Thriller'],\n",
       " [51497, 'Crime'],\n",
       " [58574, 'Adventure'],\n",
       " [58574, 'Action'],\n",
       " [58574, 'Crime'],\n",
       " [58574, 'Mystery'],\n",
       " [18823, 'Adventure'],\n",
       " [18823, 'Fantasy'],\n",
       " [18823, 'Action'],\n",
       " [861, 'Action'],\n",
       " [861, 'Adventure'],\n",
       " [861, 'Science Fiction'],\n",
       " [1911, 'Adventure'],\n",
       " [1911, 'Fantasy'],\n",
       " [1911, 'Action'],\n",
       " [49040, 'Action'],\n",
       " [49040, 'Thriller'],\n",
       " [415, 'Action'],\n",
       " [415, 'Crime'],\n",
       " [415, 'Fantasy'],\n",
       " [8871, 'Family'],\n",
       " [8871, 'Comedy'],\n",
       " [8871, 'Fantasy'],\n",
       " [435, 'Action'],\n",
       " [435, 'Adventure'],\n",
       " [435, 'Science Fiction'],\n",
       " [435, 'Thriller'],\n",
       " [955, 'Adventure'],\n",
       " [955, 'Action'],\n",
       " [955, 'Thriller'],\n",
       " [2133, 'Drama'],\n",
       " [1979, 'Adventure'],\n",
       " [1979, 'Fantasy'],\n",
       " [1979, 'Action'],\n",
       " [1979, 'Thriller'],\n",
       " [87827, 'Adventure'],\n",
       " [87827, 'Drama'],\n",
       " [87827, 'Action'],\n",
       " [1250, 'Thriller'],\n",
       " [1250, 'Action'],\n",
       " [1250, 'Fantasy'],\n",
       " [1250, 'Horror'],\n",
       " [324668, 'Action'],\n",
       " [324668, 'Thriller'],\n",
       " [9471, 'Action'],\n",
       " [9471, 'Adventure'],\n",
       " [9471, 'Comedy'],\n",
       " [70981, 'Science Fiction'],\n",
       " [70981, 'Adventure'],\n",
       " [70981, 'Mystery'],\n",
       " [10996, 'Family'],\n",
       " [10996, 'Adventure'],\n",
       " [10996, 'Animation'],\n",
       " [10996, 'Comedy'],\n",
       " [68724, 'Science Fiction'],\n",
       " [68724, 'Action'],\n",
       " [68724, 'Drama'],\n",
       " [68724, 'Thriller'],\n",
       " [2789, 'Action'],\n",
       " [2789, 'Science Fiction'],\n",
       " [97020, 'Action'],\n",
       " [97020, 'Science Fiction'],\n",
       " [7459, 'Action'],\n",
       " [7459, 'Family'],\n",
       " [7459, 'Science Fiction'],\n",
       " [42888, 'Comedy'],\n",
       " [42888, 'Drama'],\n",
       " [42888, 'Romance'],\n",
       " [37834, 'Action'],\n",
       " [37834, 'Comedy'],\n",
       " [75612, 'Action'],\n",
       " [75612, 'Science Fiction'],\n",
       " [75612, 'Adventure'],\n",
       " [75612, 'Mystery'],\n",
       " [1895, 'Science Fiction'],\n",
       " [1895, 'Adventure'],\n",
       " [1895, 'Action'],\n",
       " [1894, 'Adventure'],\n",
       " [1894, 'Action'],\n",
       " [1894, 'Science Fiction'],\n",
       " [585, 'Animation'],\n",
       " [585, 'Comedy'],\n",
       " [585, 'Family'],\n",
       " [76170, 'Action'],\n",
       " [76170, 'Science Fiction'],\n",
       " [76170, 'Adventure'],\n",
       " [76170, 'Fantasy'],\n",
       " [1893, 'Adventure'],\n",
       " [1893, 'Action'],\n",
       " [1893, 'Science Fiction'],\n",
       " [49519, 'Adventure'],\n",
       " [49519, 'Animation'],\n",
       " [49519, 'Comedy'],\n",
       " [49519, 'Family'],\n",
       " [49519, 'Fantasy'],\n",
       " [2395, 'Fantasy'],\n",
       " [2395, 'Adventure'],\n",
       " [2395, 'Comedy'],\n",
       " [2395, 'Family'],\n",
       " [12100, 'Drama'],\n",
       " [12100, 'Action'],\n",
       " [12100, 'History'],\n",
       " [12100, 'War'],\n",
       " [290595, 'Action'],\n",
       " [290595, 'Adventure'],\n",
       " [290595, 'Drama'],\n",
       " [98566, 'Science Fiction'],\n",
       " [98566, 'Action'],\n",
       " [98566, 'Adventure'],\n",
       " [98566, 'Fantasy'],\n",
       " [98566, 'Comedy'],\n",
       " [49047, 'Science Fiction'],\n",
       " [49047, 'Thriller'],\n",
       " [49047, 'Drama'],\n",
       " [9619, 'Action'],\n",
       " [9619, 'Adventure'],\n",
       " [9619, 'Thriller'],\n",
       " [308531, 'Fantasy'],\n",
       " [308531, 'Action'],\n",
       " [308531, 'Adventure'],\n",
       " [308531, 'Comedy'],\n",
       " [166424, 'Action'],\n",
       " [166424, 'Adventure'],\n",
       " [166424, 'Science Fiction'],\n",
       " [1593, 'Action'],\n",
       " [1593, 'Adventure'],\n",
       " [1593, 'Comedy'],\n",
       " [1593, 'Family'],\n",
       " [1593, 'Fantasy'],\n",
       " [254128, 'Action'],\n",
       " [254128, 'Drama'],\n",
       " [254128, 'Thriller'],\n",
       " [714, 'Adventure'],\n",
       " [714, 'Action'],\n",
       " [714, 'Thriller'],\n",
       " [2024, 'Drama'],\n",
       " [2024, 'History'],\n",
       " [2024, 'War'],\n",
       " [2024, 'Action'],\n",
       " [163, 'Thriller'],\n",
       " [163, 'Crime'],\n",
       " [787, 'Action'],\n",
       " [787, 'Comedy'],\n",
       " [787, 'Drama'],\n",
       " [787, 'Thriller'],\n",
       " [262500, 'Adventure'],\n",
       " [262500, 'Science Fiction'],\n",
       " [262500, 'Thriller'],\n",
       " [2567, 'Drama'],\n",
       " [38745, 'Comedy'],\n",
       " [40805, 'Action'],\n",
       " [40805, 'Crime'],\n",
       " [40805, 'Comedy'],\n",
       " [53182, 'Action'],\n",
       " [53182, 'War'],\n",
       " [41513, 'Animation'],\n",
       " [41513, 'Family'],\n",
       " [41513, 'Adventure'],\n",
       " [41513, 'Comedy'],\n",
       " [41513, 'Fantasy'],\n",
       " [13700, 'Animation'],\n",
       " [13700, 'Family'],\n",
       " [262504, 'Adventure'],\n",
       " [262504, 'Science Fiction'],\n",
       " [39254, 'Action'],\n",
       " [39254, 'Science Fiction'],\n",
       " [39254, 'Drama'],\n",
       " [77931, 'Fantasy'],\n",
       " [77931, 'Family'],\n",
       " [77931, 'Comedy'],\n",
       " [77931, 'Animation'],\n",
       " [1639, 'Action'],\n",
       " [1639, 'Adventure'],\n",
       " [1639, 'Thriller'],\n",
       " [80274, 'Science Fiction'],\n",
       " [80274, 'Action'],\n",
       " [80274, 'Adventure'],\n",
       " [1571, 'Action'],\n",
       " [1571, 'Thriller'],\n",
       " [120, 'Adventure'],\n",
       " [120, 'Fantasy'],\n",
       " [120, 'Action'],\n",
       " [10204, 'Action'],\n",
       " [10204, 'Adventure'],\n",
       " [10204, 'Comedy'],\n",
       " [8489, 'Drama'],\n",
       " [10588, 'Comedy'],\n",
       " [10588, 'Fantasy'],\n",
       " [10588, 'Family'],\n",
       " [2048, 'Action'],\n",
       " [2048, 'Science Fiction'],\n",
       " [1495, 'Drama'],\n",
       " [1495, 'Action'],\n",
       " [1495, 'Adventure'],\n",
       " [1495, 'History'],\n",
       " [1495, 'War'],\n",
       " [10137, 'Animation'],\n",
       " [10137, 'Fantasy'],\n",
       " [10137, 'Family'],\n",
       " [10137, 'Comedy'],\n",
       " [10198, 'Romance'],\n",
       " [10198, 'Family'],\n",
       " [10198, 'Animation'],\n",
       " [10198, 'Music'],\n",
       " [286217, 'Drama'],\n",
       " [286217, 'Adventure'],\n",
       " [286217, 'Science Fiction'],\n",
       " [1635, 'Action'],\n",
       " [1635, 'Thriller'],\n",
       " [1635, 'Science Fiction'],\n",
       " [1635, 'Adventure'],\n",
       " [24113, 'Comedy'],\n",
       " [24113, 'Romance'],\n",
       " [9679, 'Action'],\n",
       " [9679, 'Crime'],\n",
       " [9679, 'Thriller'],\n",
       " [98, 'Action'],\n",
       " [98, 'Drama'],\n",
       " [98, 'Adventure'],\n",
       " [180, 'Action'],\n",
       " [180, 'Thriller'],\n",
       " [180, 'Science Fiction'],\n",
       " [180, 'Mystery'],\n",
       " [672, 'Adventure'],\n",
       " [672, 'Fantasy'],\n",
       " [672, 'Family'],\n",
       " [36557, 'Adventure'],\n",
       " [36557, 'Action'],\n",
       " [36557, 'Thriller'],\n",
       " [869, 'Thriller'],\n",
       " [869, 'Science Fiction'],\n",
       " [869, 'Action'],\n",
       " [869, 'Adventure'],\n",
       " [280, 'Action'],\n",
       " [280, 'Thriller'],\n",
       " [280, 'Science Fiction'],\n",
       " [11322, 'History'],\n",
       " [11322, 'Crime'],\n",
       " [11322, 'Drama'],\n",
       " [4982, 'Drama'],\n",
       " [4982, 'Crime'],\n",
       " [36955, 'Action'],\n",
       " [36955, 'Thriller'],\n",
       " [18487, 'Thriller'],\n",
       " [18487, 'Drama'],\n",
       " [18487, 'Crime'],\n",
       " [39451, 'Comedy'],\n",
       " [39451, 'Romance'],\n",
       " [27581, 'Action'],\n",
       " [27581, 'Comedy'],\n",
       " [27581, 'Crime'],\n",
       " [9268, 'Action'],\n",
       " [9268, 'Drama'],\n",
       " [9268, 'Mystery'],\n",
       " [9268, 'Thriller'],\n",
       " [68718, 'Drama'],\n",
       " [68718, 'Western'],\n",
       " [10545, 'Drama'],\n",
       " [10545, 'Animation'],\n",
       " [10545, 'Family'],\n",
       " [11688, 'Adventure'],\n",
       " [11688, 'Animation'],\n",
       " [11688, 'Comedy'],\n",
       " [11688, 'Family'],\n",
       " [11688, 'Fantasy'],\n",
       " [76163, 'Action'],\n",
       " [76163, 'Adventure'],\n",
       " [76163, 'Thriller'],\n",
       " [2059, 'Adventure'],\n",
       " [2059, 'Action'],\n",
       " [2059, 'Thriller'],\n",
       " [2059, 'Mystery'],\n",
       " [2486, 'Fantasy'],\n",
       " [2486, 'Action'],\n",
       " [2486, 'Adventure'],\n",
       " [2486, 'Family'],\n",
       " [16523, 'Family'],\n",
       " [16523, 'Fantasy'],\n",
       " [116711, 'Animation'],\n",
       " [116711, 'Adventure'],\n",
       " [116711, 'Family'],\n",
       " [116711, 'Fantasy'],\n",
       " [37710, 'Action'],\n",
       " [37710, 'Thriller'],\n",
       " [37710, 'Romance'],\n",
       " [9946, 'Action'],\n",
       " [9946, 'Fantasy'],\n",
       " [9946, 'Horror'],\n",
       " [9946, 'Mystery'],\n",
       " [1372, 'Drama'],\n",
       " [1372, 'Thriller'],\n",
       " [1372, 'Action'],\n",
       " [106646, 'Crime'],\n",
       " [106646, 'Drama'],\n",
       " [106646, 'Comedy'],\n",
       " [414, 'Action'],\n",
       " [414, 'Crime'],\n",
       " [414, 'Fantasy'],\n",
       " [563, 'Adventure'],\n",
       " [563, 'Action'],\n",
       " [563, 'Thriller'],\n",
       " [563, 'Science Fiction'],\n",
       " [83542, 'Drama'],\n",
       " [83542, 'Science Fiction'],\n",
       " [41216, 'Animation'],\n",
       " [41216, 'Adventure'],\n",
       " [41216, 'Family'],\n",
       " [41216, 'Fantasy'],\n",
       " [314, 'Action'],\n",
       " [314, 'Crime'],\n",
       " [184315, 'Action'],\n",
       " [184315, 'Adventure'],\n",
       " [9016, 'Adventure'],\n",
       " [9016, 'Animation'],\n",
       " [9016, 'Family'],\n",
       " [9016, 'Fantasy'],\n",
       " [9016, 'Science Fiction'],\n",
       " [18162, 'Adventure'],\n",
       " [18162, 'Comedy'],\n",
       " ...]"
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# list of genres and movie id\n",
    "list_geners_movie_id=[]\n",
    "\n",
    "# interate over each movies anc append movie id with genres\n",
    "for i in gener_movie_id.index:\n",
    "    for item in gener_movie_id['genres'][i]:\n",
    "        list_geners_movie_id.append([gener_movie_id['movie_id'][i],item])\n",
    "list_geners_movie_id"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 97,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{8193,\n",
       " 8195,\n",
       " 24748,\n",
       " 8197,\n",
       " 8198,\n",
       " 5,\n",
       " 40963,\n",
       " 16388,\n",
       " 8202,\n",
       " 11,\n",
       " 12,\n",
       " 8204,\n",
       " 13,\n",
       " 14,\n",
       " 16,\n",
       " 18,\n",
       " 19,\n",
       " 20,\n",
       " 22,\n",
       " 16406,\n",
       " 24,\n",
       " 25,\n",
       " 122906,\n",
       " 28,\n",
       " 8224,\n",
       " 33,\n",
       " 35,\n",
       " 122917,\n",
       " 38,\n",
       " 16428,\n",
       " 24621,\n",
       " 41009,\n",
       " 16433,\n",
       " 98357,\n",
       " 391,\n",
       " 8247,\n",
       " 32823,\n",
       " 16441,\n",
       " 58,\n",
       " 59,\n",
       " 55,\n",
       " 62,\n",
       " 9782,\n",
       " 65,\n",
       " 66,\n",
       " 417859,\n",
       " 68,\n",
       " 69,\n",
       " 70,\n",
       " 71,\n",
       " 254024,\n",
       " 8265,\n",
       " 74,\n",
       " 75,\n",
       " 73,\n",
       " 77,\n",
       " 78,\n",
       " 79,\n",
       " 8271,\n",
       " 8273,\n",
       " 8272,\n",
       " 76,\n",
       " 80,\n",
       " 85,\n",
       " 24662,\n",
       " 87,\n",
       " 32856,\n",
       " 89,\n",
       " 57431,\n",
       " 90,\n",
       " 24664,\n",
       " 8285,\n",
       " 24663,\n",
       " 95,\n",
       " 96,\n",
       " 98,\n",
       " 8291,\n",
       " 8292,\n",
       " 8293,\n",
       " 100,\n",
       " 103,\n",
       " 104,\n",
       " 105,\n",
       " 106,\n",
       " 107,\n",
       " 24684,\n",
       " 111,\n",
       " 114,\n",
       " 115,\n",
       " 116,\n",
       " 117,\n",
       " 118,\n",
       " 120,\n",
       " 121,\n",
       " 122,\n",
       " 204922,\n",
       " 16508,\n",
       " 128,\n",
       " 129,\n",
       " 8321,\n",
       " 336004,\n",
       " 134,\n",
       " 8326,\n",
       " 8328,\n",
       " 137,\n",
       " 8329,\n",
       " 16523,\n",
       " 141,\n",
       " 142,\n",
       " 73873,\n",
       " 8338,\n",
       " 146,\n",
       " 8337,\n",
       " 149,\n",
       " 106646,\n",
       " 270487,\n",
       " 152,\n",
       " 41110,\n",
       " 16538,\n",
       " 155,\n",
       " 154,\n",
       " 157,\n",
       " 327833,\n",
       " 8346,\n",
       " 245916,\n",
       " 161,\n",
       " 162,\n",
       " 163,\n",
       " 8355,\n",
       " 165,\n",
       " 8358,\n",
       " 167,\n",
       " 168,\n",
       " 169,\n",
       " 8359,\n",
       " 8363,\n",
       " 172,\n",
       " 24747,\n",
       " 16558,\n",
       " 8367,\n",
       " 254128,\n",
       " 174,\n",
       " 177,\n",
       " 179,\n",
       " 180,\n",
       " 8373,\n",
       " 182,\n",
       " 8374,\n",
       " 184,\n",
       " 16564,\n",
       " 186,\n",
       " 187,\n",
       " 41144,\n",
       " 189,\n",
       " 16577,\n",
       " 41154,\n",
       " 194,\n",
       " 196,\n",
       " 197,\n",
       " 193,\n",
       " 199,\n",
       " 200,\n",
       " 201,\n",
       " 8386,\n",
       " 203,\n",
       " 8390,\n",
       " 205,\n",
       " 207,\n",
       " 73935,\n",
       " 73937,\n",
       " 49365,\n",
       " 214,\n",
       " 215,\n",
       " 8408,\n",
       " 217,\n",
       " 65754,\n",
       " 8409,\n",
       " 219,\n",
       " 8413,\n",
       " 218,\n",
       " 65759,\n",
       " 16608,\n",
       " 223,\n",
       " 226,\n",
       " 24803,\n",
       " 227,\n",
       " 8416,\n",
       " 16614,\n",
       " 231,\n",
       " 16617,\n",
       " 8427,\n",
       " 235,\n",
       " 16620,\n",
       " 238,\n",
       " 16619,\n",
       " 240,\n",
       " 239,\n",
       " 242,\n",
       " 243,\n",
       " 8435,\n",
       " 245,\n",
       " 98549,\n",
       " 248,\n",
       " 16633,\n",
       " 41210,\n",
       " 251,\n",
       " 106747,\n",
       " 253,\n",
       " 254,\n",
       " 252,\n",
       " 41216,\n",
       " 257,\n",
       " 16642,\n",
       " 196867,\n",
       " 8452,\n",
       " 16643,\n",
       " 98566,\n",
       " 261,\n",
       " 8456,\n",
       " 8457,\n",
       " 90369,\n",
       " 16651,\n",
       " 268,\n",
       " 8461,\n",
       " 57612,\n",
       " 16653,\n",
       " 272,\n",
       " 41233,\n",
       " 274,\n",
       " 8467,\n",
       " 277,\n",
       " 8470,\n",
       " 278,\n",
       " 280,\n",
       " 279,\n",
       " 8469,\n",
       " 284,\n",
       " 285,\n",
       " 41248,\n",
       " 289,\n",
       " 288,\n",
       " 291,\n",
       " 49444,\n",
       " 292,\n",
       " 24869,\n",
       " 8487,\n",
       " 296,\n",
       " 8489,\n",
       " 298,\n",
       " 297,\n",
       " 8488,\n",
       " 1687,\n",
       " 302,\n",
       " 1688,\n",
       " 280381,\n",
       " 90414,\n",
       " 306,\n",
       " 16690,\n",
       " 309,\n",
       " 310,\n",
       " 311,\n",
       " 147767,\n",
       " 314,\n",
       " 147773,\n",
       " 50538,\n",
       " 319,\n",
       " 320,\n",
       " 321,\n",
       " 322,\n",
       " 41283,\n",
       " 49471,\n",
       " 49478,\n",
       " 326,\n",
       " 327,\n",
       " 329,\n",
       " 330,\n",
       " 331,\n",
       " 332,\n",
       " 205126,\n",
       " 334,\n",
       " 335,\n",
       " 24913,\n",
       " 338,\n",
       " 33106,\n",
       " 342,\n",
       " 16727,\n",
       " 8536,\n",
       " 345,\n",
       " 346,\n",
       " 348,\n",
       " 106845,\n",
       " 350,\n",
       " 172385,\n",
       " 8545,\n",
       " 9783,\n",
       " 262500,\n",
       " 41317,\n",
       " 74084,\n",
       " 385383,\n",
       " 262504,\n",
       " 172391,\n",
       " 364,\n",
       " 49517,\n",
       " 24940,\n",
       " 49519,\n",
       " 49520,\n",
       " 49521,\n",
       " 49524,\n",
       " 156022,\n",
       " 49527,\n",
       " 49526,\n",
       " 49529,\n",
       " 377,\n",
       " 49530,\n",
       " 380,\n",
       " 24961,\n",
       " 49538,\n",
       " 16769,\n",
       " 388,\n",
       " 33157,\n",
       " 387,\n",
       " 33155,\n",
       " 8584,\n",
       " 393,\n",
       " 392,\n",
       " 8587,\n",
       " 395,\n",
       " 16781,\n",
       " 398,\n",
       " 278927,\n",
       " 8592,\n",
       " 16784,\n",
       " 319888,\n",
       " 400,\n",
       " 262543,\n",
       " 404,\n",
       " 403,\n",
       " 24977,\n",
       " 401,\n",
       " 409,\n",
       " 24985,\n",
       " 411,\n",
       " 408,\n",
       " 414,\n",
       " 415,\n",
       " 83,\n",
       " 205220,\n",
       " 421,\n",
       " 41382,\n",
       " 423,\n",
       " 424,\n",
       " 425,\n",
       " 8617,\n",
       " 8619,\n",
       " 33196,\n",
       " 319910,\n",
       " 8618,\n",
       " 328111,\n",
       " 429,\n",
       " 433,\n",
       " 431,\n",
       " 435,\n",
       " 436,\n",
       " 440,\n",
       " 41402,\n",
       " 33217,\n",
       " 8643,\n",
       " 451,\n",
       " 453,\n",
       " 8645,\n",
       " 454,\n",
       " 57800,\n",
       " 8649,\n",
       " 455,\n",
       " 139715,\n",
       " 462,\n",
       " 8656,\n",
       " 464,\n",
       " 468,\n",
       " 470,\n",
       " 8665,\n",
       " 16858,\n",
       " 16857,\n",
       " 41436,\n",
       " 8669,\n",
       " 473,\n",
       " 479,\n",
       " 41439,\n",
       " 57825,\n",
       " 16866,\n",
       " 480,\n",
       " 8676,\n",
       " 16869,\n",
       " 41446,\n",
       " 16871,\n",
       " 1725,\n",
       " 8681,\n",
       " 489,\n",
       " 25066,\n",
       " 492,\n",
       " 66025,\n",
       " 426469,\n",
       " 8688,\n",
       " 497,\n",
       " 496,\n",
       " 500,\n",
       " 172533,\n",
       " 503,\n",
       " 16888,\n",
       " 504,\n",
       " 8698,\n",
       " 8699,\n",
       " 508,\n",
       " 509,\n",
       " 510,\n",
       " 188927,\n",
       " 512,\n",
       " 507,\n",
       " 41469,\n",
       " 16899,\n",
       " 254470,\n",
       " 41479,\n",
       " 254472,\n",
       " 254473,\n",
       " 522,\n",
       " 205321,\n",
       " 524,\n",
       " 525,\n",
       " 526,\n",
       " 16911,\n",
       " 41488,\n",
       " 115210,\n",
       " 164372,\n",
       " 533,\n",
       " 534,\n",
       " 535,\n",
       " 57876,\n",
       " 25113,\n",
       " 539,\n",
       " 540,\n",
       " 542,\n",
       " 544,\n",
       " 546,\n",
       " 547,\n",
       " 41508,\n",
       " 8741,\n",
       " 550,\n",
       " 549,\n",
       " 8744,\n",
       " 41513,\n",
       " 41515,\n",
       " 25132,\n",
       " 557,\n",
       " 558,\n",
       " 559,\n",
       " 131631,\n",
       " 131634,\n",
       " 563,\n",
       " 562,\n",
       " 568,\n",
       " 573,\n",
       " 576,\n",
       " 577,\n",
       " 49730,\n",
       " 579,\n",
       " 580,\n",
       " 581,\n",
       " 578,\n",
       " 582,\n",
       " 584,\n",
       " 585,\n",
       " 586,\n",
       " 587,\n",
       " 588,\n",
       " 8780,\n",
       " 590,\n",
       " 591,\n",
       " 25166,\n",
       " 593,\n",
       " 594,\n",
       " 66125,\n",
       " 125490,\n",
       " 597,\n",
       " 598,\n",
       " 57943,\n",
       " 595,\n",
       " 601,\n",
       " 602,\n",
       " 603,\n",
       " 604,\n",
       " 605,\n",
       " 82525,\n",
       " 607,\n",
       " 608,\n",
       " 609,\n",
       " 270946,\n",
       " 16995,\n",
       " 612,\n",
       " 25189,\n",
       " 16996,\n",
       " 606,\n",
       " 616,\n",
       " 615,\n",
       " 164457,\n",
       " 619,\n",
       " 617,\n",
       " 25195,\n",
       " 8814,\n",
       " 622,\n",
       " 25196,\n",
       " 621,\n",
       " 8818,\n",
       " 627,\n",
       " 628,\n",
       " 629,\n",
       " 630,\n",
       " 25208,\n",
       " 25209,\n",
       " 634,\n",
       " 49787,\n",
       " 25212,\n",
       " 8831,\n",
       " 640,\n",
       " 639,\n",
       " 8834,\n",
       " 8835,\n",
       " 644,\n",
       " 8836,\n",
       " 8838,\n",
       " 8839,\n",
       " 8840,\n",
       " 13154,\n",
       " 8842,\n",
       " 8843,\n",
       " 652,\n",
       " 650,\n",
       " 8841,\n",
       " 8847,\n",
       " 8848,\n",
       " 8849,\n",
       " 8850,\n",
       " 17043,\n",
       " 660,\n",
       " 17044,\n",
       " 8854,\n",
       " 17047,\n",
       " 664,\n",
       " 663,\n",
       " 658,\n",
       " 8859,\n",
       " 667,\n",
       " 668,\n",
       " 41630,\n",
       " 671,\n",
       " 672,\n",
       " 673,\n",
       " 674,\n",
       " 675,\n",
       " 676,\n",
       " 123553,\n",
       " 8870,\n",
       " 8871,\n",
       " 8869,\n",
       " 8872,\n",
       " 8874,\n",
       " 679,\n",
       " 680,\n",
       " 681,\n",
       " 686,\n",
       " 687,\n",
       " 688,\n",
       " 682,\n",
       " 8879,\n",
       " 691,\n",
       " 8883,\n",
       " 693,\n",
       " 694,\n",
       " 8885,\n",
       " 246449,\n",
       " 692,\n",
       " 698,\n",
       " 699,\n",
       " 49852,\n",
       " 700,\n",
       " 702,\n",
       " 703,\n",
       " 58048,\n",
       " 287424,\n",
       " 704,\n",
       " 707,\n",
       " 708,\n",
       " 709,\n",
       " 710,\n",
       " 711,\n",
       " 328387,\n",
       " 82631,\n",
       " 714,\n",
       " 58051,\n",
       " 385736,\n",
       " 8909,\n",
       " 164558,\n",
       " 713,\n",
       " 361159,\n",
       " 8913,\n",
       " 8914,\n",
       " 352978,\n",
       " 8916,\n",
       " 8920,\n",
       " 74457,\n",
       " 82650,\n",
       " 8922,\n",
       " 17113,\n",
       " 82654,\n",
       " 139998,\n",
       " 459488,\n",
       " 74465,\n",
       " 9916,\n",
       " 25312,\n",
       " 17127,\n",
       " 744,\n",
       " 745,\n",
       " 746,\n",
       " 17130,\n",
       " 328425,\n",
       " 34341,\n",
       " 17134,\n",
       " 747,\n",
       " 752,\n",
       " 8944,\n",
       " 754,\n",
       " 82675,\n",
       " 303858,\n",
       " 755,\n",
       " 17139,\n",
       " 82679,\n",
       " 8952,\n",
       " 8953,\n",
       " 82682,\n",
       " 756,\n",
       " 82684,\n",
       " 765,\n",
       " 766,\n",
       " 82687,\n",
       " 767,\n",
       " 8960,\n",
       " 8961,\n",
       " 82690,\n",
       " 8963,\n",
       " 41733,\n",
       " 271110,\n",
       " 82695,\n",
       " 768,\n",
       " 8966,\n",
       " 8970,\n",
       " 8967,\n",
       " 82700,\n",
       " 82696,\n",
       " 82702,\n",
       " 82703,\n",
       " 205584,\n",
       " 782,\n",
       " 786,\n",
       " 787,\n",
       " 205587,\n",
       " 8978,\n",
       " 788,\n",
       " 8976,\n",
       " 8984,\n",
       " 17170,\n",
       " 794,\n",
       " 795,\n",
       " 49948,\n",
       " 8987,\n",
       " 8988,\n",
       " 17182,\n",
       " 49950,\n",
       " 49953,\n",
       " 802,\n",
       " 17186,\n",
       " 205596,\n",
       " 801,\n",
       " 17187,\n",
       " 807,\n",
       " 808,\n",
       " 809,\n",
       " 810,\n",
       " 58151,\n",
       " 812,\n",
       " 8999,\n",
       " 74536,\n",
       " 9007,\n",
       " 9008,\n",
       " 9009,\n",
       " 818,\n",
       " 819,\n",
       " 820,\n",
       " 817,\n",
       " 9013,\n",
       " 816,\n",
       " 9016,\n",
       " 824,\n",
       " 17202,\n",
       " 9012,\n",
       " 826,\n",
       " 9021,\n",
       " 821,\n",
       " 9023,\n",
       " 394047,\n",
       " 9022,\n",
       " 834,\n",
       " 9026,\n",
       " 9027,\n",
       " 837,\n",
       " 9030,\n",
       " 16448,\n",
       " 9032,\n",
       " 841,\n",
       " 840,\n",
       " 9035,\n",
       " 9036,\n",
       " 844,\n",
       " 846,\n",
       " 9034,\n",
       " 848,\n",
       " 849,\n",
       " 9042,\n",
       " 9043,\n",
       " 850,\n",
       " 853,\n",
       " 854,\n",
       " 855,\n",
       " 9045,\n",
       " 857,\n",
       " 170,\n",
       " 859,\n",
       " 860,\n",
       " 861,\n",
       " 862,\n",
       " 863,\n",
       " 9053,\n",
       " 865,\n",
       " 50014,\n",
       " 866,\n",
       " 864,\n",
       " 869,\n",
       " 9059,\n",
       " 41823,\n",
       " 173,\n",
       " 873,\n",
       " 874,\n",
       " 9067,\n",
       " 33644,\n",
       " 868,\n",
       " 872,\n",
       " 879,\n",
       " 9072,\n",
       " 58224,\n",
       " 881,\n",
       " 9075,\n",
       " 9074,\n",
       " 17264,\n",
       " 25462,\n",
       " 887,\n",
       " 888,\n",
       " 889,\n",
       " 58233,\n",
       " 230266,\n",
       " 176,\n",
       " 17277,\n",
       " 50037,\n",
       " 246655,\n",
       " 9087,\n",
       " 9089,\n",
       " 33667,\n",
       " 9092,\n",
       " 9093,\n",
       " 9095,\n",
       " 9096,\n",
       " 905,\n",
       " 17287,\n",
       " 9099,\n",
       " 9100,\n",
       " 907,\n",
       " 33676,\n",
       " 287625,\n",
       " 9104,\n",
       " 913,\n",
       " 74643,\n",
       " 920,\n",
       " 921,\n",
       " 924,\n",
       " 312221,\n",
       " 926,\n",
       " 927,\n",
       " 928,\n",
       " 925,\n",
       " 33693,\n",
       " 66468,\n",
       " 41894,\n",
       " 935,\n",
       " 345003,\n",
       " 943,\n",
       " 944,\n",
       " 25520,\n",
       " 947,\n",
       " 17332,\n",
       " 948,\n",
       " 950,\n",
       " 951,\n",
       " 254904,\n",
       " 953,\n",
       " 954,\n",
       " 955,\n",
       " 956,\n",
       " 957,\n",
       " 16471,\n",
       " 17339,\n",
       " 91070,\n",
       " 17345,\n",
       " 91076,\n",
       " 295886,\n",
       " 205775,\n",
       " 978,\n",
       " 979,\n",
       " 50135,\n",
       " 985,\n",
       " 987,\n",
       " 990,\n",
       " 17379,\n",
       " 271331,\n",
       " 74725,\n",
       " 295914,\n",
       " 91122,\n",
       " 9208,\n",
       " 1018,\n",
       " 17403,\n",
       " 1024,\n",
       " 361475,\n",
       " 238603,\n",
       " 140300,\n",
       " 238615,\n",
       " 17431,\n",
       " 74777,\n",
       " 1051,\n",
       " 295964,\n",
       " 17436,\n",
       " 361505,\n",
       " 181283,\n",
       " 25636,\n",
       " 9257,\n",
       " 222250,\n",
       " 25643,\n",
       " 9260,\n",
       " 238636,\n",
       " 82990,\n",
       " 66607,\n",
       " 1073,\n",
       " 9266,\n",
       " 42033,\n",
       " 9268,\n",
       " 239563,\n",
       " 9271,\n",
       " 9273,\n",
       " 9275,\n",
       " 9276,\n",
       " 9277,\n",
       " 58428,\n",
       " 9279,\n",
       " 9280,\n",
       " 58431,\n",
       " 1090,\n",
       " 1091,\n",
       " 9281,\n",
       " 9285,\n",
       " 9286,\n",
       " 9282,\n",
       " 9288,\n",
       " 9289,\n",
       " 9290,\n",
       " 9291,\n",
       " 9292,\n",
       " 42057,\n",
       " 9294,\n",
       " 33870,\n",
       " 1103,\n",
       " 9297,\n",
       " 181330,\n",
       " 25678,\n",
       " 402515,\n",
       " 9302,\n",
       " 9303,\n",
       " 9304,\n",
       " 9306,\n",
       " 1116,\n",
       " 239571,\n",
       " 9311,\n",
       " 9312,\n",
       " 9313,\n",
       " 9310,\n",
       " 9315,\n",
       " 1124,\n",
       " 1125,\n",
       " 1123,\n",
       " 25704,\n",
       " 9327,\n",
       " 9331,\n",
       " 33909,\n",
       " 9334,\n",
       " 9335,\n",
       " 9336,\n",
       " 25719,\n",
       " 9339,\n",
       " 58492,\n",
       " 9341,\n",
       " 9342,\n",
       " 42109,\n",
       " 9344,\n",
       " 9348,\n",
       " 9350,\n",
       " 9352,\n",
       " 9353,\n",
       " 132232,\n",
       " 9355,\n",
       " 1164,\n",
       " 1165,\n",
       " 9358,\n",
       " 9357,\n",
       " 9360,\n",
       " 50321,\n",
       " 9361,\n",
       " 9362,\n",
       " 9366,\n",
       " 9367,\n",
       " 9372,\n",
       " 9374,\n",
       " 287903,\n",
       " 296096,\n",
       " 115872,\n",
       " 296098,\n",
       " 296099,\n",
       " 9378,\n",
       " 9381,\n",
       " 25763,\n",
       " 9383,\n",
       " 9384,\n",
       " 25769,\n",
       " 17578,\n",
       " 9387,\n",
       " 50348,\n",
       " 9389,\n",
       " 9390,\n",
       " 17577,\n",
       " 9388,\n",
       " 9392,\n",
       " 91314,\n",
       " 9396,\n",
       " 50357,\n",
       " 9398,\n",
       " 50359,\n",
       " 9400,\n",
       " 25784,\n",
       " 25786,\n",
       " 1213,\n",
       " 9408,\n",
       " 25793,\n",
       " 9414,\n",
       " 9416,\n",
       " 17610,\n",
       " 287948,\n",
       " 42188,\n",
       " 58574,\n",
       " 9422,\n",
       " 9424,\n",
       " 9425,\n",
       " 66767,\n",
       " 9427,\n",
       " 9428,\n",
       " 9429,\n",
       " 17622,\n",
       " 9430,\n",
       " 9433,\n",
       " 9434,\n",
       " 132316,\n",
       " 9437,\n",
       " 1246,\n",
       " 1245,\n",
       " 9440,\n",
       " 9441,\n",
       " 1250,\n",
       " 58595,\n",
       " 9444,\n",
       " 1248,\n",
       " 34016,\n",
       " 9447,\n",
       " 1255,\n",
       " 1257,\n",
       " 9449,\n",
       " 1259,\n",
       " 9452,\n",
       " 50725,\n",
       " ...}"
      ]
     },
     "execution_count": 97,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# collect movie id \n",
    "movies_ids=[]\n",
    "for i in list_geners_movie_id:\n",
    "    movies_ids.append(i[0])\n",
    "movies_ids=set(movies_ids)\n",
    "movies_ids  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>movie_id</th>\n",
       "      <th>genres</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>19995</td>\n",
       "      <td>Action</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>19995</td>\n",
       "      <td>Adventure</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>19995</td>\n",
       "      <td>Fantasy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>19995</td>\n",
       "      <td>Science Fiction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>285</td>\n",
       "      <td>Adventure</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12172</th>\n",
       "      <td>231617</td>\n",
       "      <td>Comedy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12173</th>\n",
       "      <td>231617</td>\n",
       "      <td>Drama</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12174</th>\n",
       "      <td>231617</td>\n",
       "      <td>Romance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12175</th>\n",
       "      <td>231617</td>\n",
       "      <td>TV Movie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12176</th>\n",
       "      <td>25975</td>\n",
       "      <td>Documentary</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>12177 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       movie_id           genres\n",
       "0         19995           Action\n",
       "1         19995        Adventure\n",
       "2         19995          Fantasy\n",
       "3         19995  Science Fiction\n",
       "4           285        Adventure\n",
       "...         ...              ...\n",
       "12172    231617           Comedy\n",
       "12173    231617            Drama\n",
       "12174    231617          Romance\n",
       "12175    231617         TV Movie\n",
       "12176     25975      Documentary\n",
       "\n",
       "[12177 rows x 2 columns]"
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gener_movie_id=pd.DataFrame(list_geners_movie_id,columns=['movie_id','genres'])\n",
    "gener_movie_id"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "metadata": {},
   "outputs": [],
   "source": [
    "movies_with_rating.dropna(inplace=True)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 103,
   "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>movie_id</th>\n",
       "      <th>11</th>\n",
       "      <th>12</th>\n",
       "      <th>14</th>\n",
       "      <th>22</th>\n",
       "      <th>24</th>\n",
       "      <th>28</th>\n",
       "      <th>35</th>\n",
       "      <th>38</th>\n",
       "      <th>58</th>\n",
       "      <th>65</th>\n",
       "      <th>...</th>\n",
       "      <th>357837</th>\n",
       "      <th>362765</th>\n",
       "      <th>367551</th>\n",
       "      <th>367961</th>\n",
       "      <th>370662</th>\n",
       "      <th>376659</th>\n",
       "      <th>385383</th>\n",
       "      <th>385736</th>\n",
       "      <th>394047</th>\n",
       "      <th>426469</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>user</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 1494 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "movie_id  11      12      14      22      24      28      35      38      \\\n",
       "user                                                                       \n",
       "1              3       3       3       0       3       3       1       2   \n",
       "2              0       2       2       1       0       2       2       4   \n",
       "3              1       4       1       1       4       2       2       3   \n",
       "4              0       1       1       2       3       3       1       4   \n",
       "5              3       4       3       4       2       1       3       0   \n",
       "6              0       0       1       1       0       2       4       3   \n",
       "7              2       1       3       0       4       4       4       2   \n",
       "8              3       1       0       4       1       3       4       1   \n",
       "9              0       4       2       1       4       3       3       2   \n",
       "10             2       3       0       0       4       3       4       1   \n",
       "\n",
       "movie_id  58      65      ...  357837  362765  367551  367961  370662  376659  \\\n",
       "user                      ...                                                   \n",
       "1              3       0  ...       4       0       4       3       4       2   \n",
       "2              0       3  ...       2       4       3       2       0       3   \n",
       "3              3       2  ...       0       4       1       4       3       0   \n",
       "4              4       1  ...       4       3       2       1       4       1   \n",
       "5              4       1  ...       3       2       3       1       1       4   \n",
       "6              3       4  ...       2       3       2       4       2       2   \n",
       "7              2       3  ...       4       4       1       1       1       1   \n",
       "8              4       0  ...       0       1       3       0       2       3   \n",
       "9              4       3  ...       0       3       3       2       1       2   \n",
       "10             1       0  ...       3       1       2       3       3       0   \n",
       "\n",
       "movie_id  385383  385736  394047  426469  \n",
       "user                                      \n",
       "1              1       0       2       1  \n",
       "2              3       3       3       3  \n",
       "3              3       0       3       4  \n",
       "4              3       3       3       3  \n",
       "5              1       4       1       3  \n",
       "6              3       2       2       3  \n",
       "7              0       3       1       0  \n",
       "8              3       0       2       1  \n",
       "9              1       3       2       3  \n",
       "10             3       3       4       3  \n",
       "\n",
       "[10 rows x 1494 columns]"
      ]
     },
     "execution_count": 103,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# generate matrix between user and movie id with values as ratings\n",
    "movies_users_df=movies_with_rating.pivot(index='user',columns='movie_id',values='rating')\n",
    "movies_users_df\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 105,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[[11, 1.4],\n",
       " [12, 2.3],\n",
       " [14, 1.6],\n",
       " [22, 1.4],\n",
       " [24, 2.5],\n",
       " [28, 2.6],\n",
       " [35, 2.8],\n",
       " [38, 2.2],\n",
       " [58, 2.8],\n",
       " [65, 1.7],\n",
       " [70, 1.3],\n",
       " [73, 2],\n",
       " [75, 2.5],\n",
       " [77, 2.2],\n",
       " [78, 2.4],\n",
       " [80, 2.5],\n",
       " [85, 1.4],\n",
       " [87, 2],\n",
       " [89, 1.9],\n",
       " [100, 1.5],\n",
       " [105, 2.1],\n",
       " [115, 2.4],\n",
       " [118, 2.5],\n",
       " [120, 2],\n",
       " [121, 2.2],\n",
       " [122, 2.2],\n",
       " [129, 2],\n",
       " [142, 1.3],\n",
       " [149, 2.3],\n",
       " [155, 2.1],\n",
       " [161, 1.8],\n",
       " [163, 2],\n",
       " [165, 1.7],\n",
       " [167, 1.7],\n",
       " [179, 1.7],\n",
       " [182, 2.1],\n",
       " [187, 2.4],\n",
       " [189, 1.9],\n",
       " [194, 2.9],\n",
       " [196, 1.7],\n",
       " [199, 2.1],\n",
       " [205, 1.9],\n",
       " [217, 2.3],\n",
       " [218, 1.6],\n",
       " [219, 2.5],\n",
       " [226, 1.7],\n",
       " [231, 2],\n",
       " [238, 2.4],\n",
       " [242, 1.6],\n",
       " [245, 1.7],\n",
       " [253, 1.2],\n",
       " [272, 1.2],\n",
       " [277, 1.6],\n",
       " [285, 1.8],\n",
       " [297, 1.7],\n",
       " [298, 2.3],\n",
       " [302, 2.2],\n",
       " [310, 2.9],\n",
       " [321, 2.8],\n",
       " [327, 2.1],\n",
       " [329, 2.1],\n",
       " [334, 2],\n",
       " [338, 1.6],\n",
       " [345, 1.7],\n",
       " [348, 1.5],\n",
       " [350, 2.1],\n",
       " [387, 1.9],\n",
       " [388, 2.4],\n",
       " [395, 2.3],\n",
       " [398, 1.9],\n",
       " [408, 2],\n",
       " [423, 3.1],\n",
       " [424, 1.9],\n",
       " [425, 1.8],\n",
       " [429, 2.3],\n",
       " [435, 2.3],\n",
       " [436, 2.1],\n",
       " [440, 1.8],\n",
       " [451, 2.2],\n",
       " [453, 1.2],\n",
       " [454, 2.2],\n",
       " [455, 2],\n",
       " [462, 1.7],\n",
       " [470, 2.3],\n",
       " [473, 1.5],\n",
       " [489, 1.9],\n",
       " [496, 2.1],\n",
       " [497, 2.1],\n",
       " [503, 1.4],\n",
       " [508, 2.4],\n",
       " [509, 1.6],\n",
       " [512, 1.9],\n",
       " [533, 2.3],\n",
       " [534, 1.7],\n",
       " [542, 2.5],\n",
       " [544, 1.7],\n",
       " [546, 2.6],\n",
       " [550, 2],\n",
       " [557, 2],\n",
       " [558, 3.3],\n",
       " [559, 1.7],\n",
       " [578, 1.3],\n",
       " [585, 1.4],\n",
       " [588, 1],\n",
       " [591, 2.1],\n",
       " [594, 1.6],\n",
       " [597, 2.4],\n",
       " [598, 1.7],\n",
       " [601, 1.6],\n",
       " [603, 3.1],\n",
       " [607, 2.4],\n",
       " [608, 2.2],\n",
       " [613, 2.9],\n",
       " [615, 2.6],\n",
       " [627, 2.2],\n",
       " [629, 2.2],\n",
       " [630, 1.9],\n",
       " [640, 1.6],\n",
       " [646, 2.7],\n",
       " [657, 2.6],\n",
       " [658, 1.6],\n",
       " [660, 2.2],\n",
       " [663, 3.1],\n",
       " [667, 1.9],\n",
       " [668, 1.9],\n",
       " [671, 1.6],\n",
       " [674, 1.5],\n",
       " [675, 1.6],\n",
       " [681, 1.7],\n",
       " [682, 2.1],\n",
       " [686, 1.9],\n",
       " [691, 2.5],\n",
       " [693, 1.7],\n",
       " [698, 2],\n",
       " [699, 1.7],\n",
       " [700, 1.4],\n",
       " [704, 1.4],\n",
       " [707, 1.6],\n",
       " [708, 3.1],\n",
       " [709, 2.3],\n",
       " [710, 2.5],\n",
       " [712, 2.5],\n",
       " [714, 2.7],\n",
       " [752, 2.8],\n",
       " [755, 1.1],\n",
       " [756, 1.8],\n",
       " [762, 1.9],\n",
       " [767, 2.1],\n",
       " [769, 1.8],\n",
       " [771, 1.4],\n",
       " [773, 1.8],\n",
       " [790, 1.5],\n",
       " [807, 1.8],\n",
       " [808, 1.2],\n",
       " [809, 1.8],\n",
       " [810, 2],\n",
       " [812, 2.1],\n",
       " [818, 1.5],\n",
       " [834, 1.7],\n",
       " [844, 2.1],\n",
       " [860, 1.4],\n",
       " [863, 1.5],\n",
       " [868, 1.9],\n",
       " [889, 1.6],\n",
       " [920, 2.6],\n",
       " [921, 1.3],\n",
       " [924, 1.3],\n",
       " [948, 2.1],\n",
       " [950, 2],\n",
       " [954, 2],\n",
       " [955, 2.7],\n",
       " [956, 2.1],\n",
       " [957, 2.2],\n",
       " [1024, 1.5],\n",
       " [1091, 2.4],\n",
       " [1103, 2.3],\n",
       " [1124, 2.2],\n",
       " [1125, 2],\n",
       " [1165, 2.3],\n",
       " [1213, 2.7],\n",
       " [1246, 2.6],\n",
       " [1248, 2.2],\n",
       " [1250, 1.6],\n",
       " [1251, 1.9],\n",
       " [1255, 1.2],\n",
       " [1257, 2.2],\n",
       " [1259, 2.3],\n",
       " [1262, 1.7],\n",
       " [1265, 1.7],\n",
       " [1271, 1.8],\n",
       " [1378, 2.3],\n",
       " [1381, 1.6],\n",
       " [1417, 1.9],\n",
       " [1422, 1.6],\n",
       " [1427, 2.3],\n",
       " [1430, 1.5],\n",
       " [1443, 2.1],\n",
       " [1487, 1.9],\n",
       " [1494, 1.8],\n",
       " [1495, 1.8],\n",
       " [1544, 2],\n",
       " [1550, 1.7],\n",
       " [1576, 1.9],\n",
       " [1581, 1.9],\n",
       " [1584, 2.1],\n",
       " [1588, 1.6],\n",
       " [1620, 1.4],\n",
       " [1635, 2],\n",
       " [1640, 1.8],\n",
       " [1646, 3.1],\n",
       " [1648, 2.1],\n",
       " [1656, 2.2],\n",
       " [1667, 2.1],\n",
       " [1669, 2.3],\n",
       " [1683, 1.5],\n",
       " [1690, 1.5],\n",
       " [1696, 1.7],\n",
       " [1717, 2.1],\n",
       " [1726, 2.5],\n",
       " [1729, 1.7],\n",
       " [1735, 2.5],\n",
       " [1771, 2.6],\n",
       " [1781, 1.4],\n",
       " [1819, 2.9],\n",
       " [1832, 2],\n",
       " [1833, 1.4],\n",
       " [1844, 1.4],\n",
       " [1850, 2],\n",
       " [1858, 1.7],\n",
       " [1865, 2.8],\n",
       " [1887, 1.4],\n",
       " [1891, 2.1],\n",
       " [1892, 2.1],\n",
       " [1893, 2.1],\n",
       " [1894, 1.7],\n",
       " [1895, 2.3],\n",
       " [1904, 1.8],\n",
       " [1930, 1.9],\n",
       " [1947, 2.1],\n",
       " [1950, 1.8],\n",
       " [1957, 1.9],\n",
       " [1961, 2.4],\n",
       " [1975, 2.1],\n",
       " [1988, 2.5],\n",
       " [2008, 2.2],\n",
       " [2044, 2.6],\n",
       " [2062, 2],\n",
       " [2080, 2.1],\n",
       " [2135, 1.7],\n",
       " [2142, 2.8],\n",
       " [2196, 2.1],\n",
       " [2252, 2.3],\n",
       " [2255, 1.8],\n",
       " [2268, 1.8],\n",
       " [2270, 1.4],\n",
       " [2292, 2.6],\n",
       " [2300, 2.3],\n",
       " [2309, 2],\n",
       " [2310, 1.7],\n",
       " [2312, 1.9],\n",
       " [2355, 2.4],\n",
       " [2453, 2.5],\n",
       " [2486, 2.5],\n",
       " [2501, 1.1],\n",
       " [2502, 1.9],\n",
       " [2503, 2.8],\n",
       " [2652, 2.2],\n",
       " [2662, 2.4],\n",
       " [2667, 1.6],\n",
       " [2687, 1.5],\n",
       " [2698, 2.8],\n",
       " [2757, 2],\n",
       " [2771, 2],\n",
       " [2787, 2.1],\n",
       " [2959, 1.6],\n",
       " [2976, 2.4],\n",
       " [2977, 3.3],\n",
       " [2989, 1.8],\n",
       " [3021, 2.1],\n",
       " [3131, 1.6],\n",
       " [3170, 1.8],\n",
       " [3291, 2.2],\n",
       " [3509, 1.7],\n",
       " [3536, 3],\n",
       " [3580, 1.5],\n",
       " [3594, 2.5],\n",
       " [3638, 2.1],\n",
       " [3877, 1.1],\n",
       " [3902, 1.5],\n",
       " [3933, 1.4],\n",
       " [3989, 1.8],\n",
       " [4170, 2.4],\n",
       " [4244, 1.5],\n",
       " [4348, 2.6],\n",
       " [4349, 2.4],\n",
       " [4380, 2.8],\n",
       " [4464, 2],\n",
       " [4512, 1.8],\n",
       " [4513, 2],\n",
       " [4523, 1.8],\n",
       " [4550, 1.9],\n",
       " [4566, 2.2],\n",
       " [4614, 1.5],\n",
       " [4638, 2.5],\n",
       " [4657, 1.4],\n",
       " [4688, 2.3],\n",
       " [4723, 2],\n",
       " [4922, 1.4],\n",
       " [4942, 2.2],\n",
       " [4959, 1.3],\n",
       " [4964, 1.8],\n",
       " [4970, 1.8],\n",
       " [4982, 2.6],\n",
       " [5072, 1.2],\n",
       " [5123, 2.1],\n",
       " [5125, 2.2],\n",
       " [5137, 2.1],\n",
       " [5176, 2.3],\n",
       " [5178, 2.1],\n",
       " [5353, 1.7],\n",
       " [5393, 2.3],\n",
       " [5551, 2.5],\n",
       " [5559, 2.4],\n",
       " [5722, 2],\n",
       " [5723, 2.1],\n",
       " [5822, 2.3],\n",
       " [5852, 2.1],\n",
       " [5876, 1.5],\n",
       " [5915, 1.9],\n",
       " [5966, 2.1],\n",
       " [6171, 1.5],\n",
       " [6477, 2.2],\n",
       " [6479, 2.3],\n",
       " [6519, 2.8],\n",
       " [6538, 1.6],\n",
       " [6557, 2.8],\n",
       " [6575, 2.7],\n",
       " [6615, 1],\n",
       " [6639, 2.3],\n",
       " [6933, 1.7],\n",
       " [6957, 1.7],\n",
       " [6961, 3.5],\n",
       " [6973, 2.2],\n",
       " [6978, 1.5],\n",
       " [7191, 2.1],\n",
       " [7220, 2.2],\n",
       " [7278, 1.4],\n",
       " [7304, 1.8],\n",
       " [7326, 1.3],\n",
       " [7347, 1.5],\n",
       " [7350, 1.9],\n",
       " [7446, 2.4],\n",
       " [7451, 2.4],\n",
       " [7459, 2],\n",
       " [7461, 1.2],\n",
       " [7484, 2.5],\n",
       " [7485, 1.5],\n",
       " [7501, 2.2],\n",
       " [7516, 2.5],\n",
       " [7552, 1.5],\n",
       " [7735, 2.2],\n",
       " [7737, 2.5],\n",
       " [7859, 1.8],\n",
       " [7870, 1.9],\n",
       " [7873, 1.7],\n",
       " [7874, 2.2],\n",
       " [7942, 2.8],\n",
       " [7944, 1.3],\n",
       " [7978, 2.1],\n",
       " [7979, 2.1],\n",
       " [7980, 1.7],\n",
       " [8046, 1.4],\n",
       " [8065, 2.6],\n",
       " [8090, 1.9],\n",
       " [8141, 2.6],\n",
       " [8247, 1.7],\n",
       " [8271, 2.4],\n",
       " [8285, 2.1],\n",
       " [8291, 1.5],\n",
       " [8292, 1.9],\n",
       " [8321, 2],\n",
       " [8329, 2.6],\n",
       " [8337, 1.8],\n",
       " [8355, 1.8],\n",
       " [8359, 1.7],\n",
       " [8363, 1.2],\n",
       " [8373, 2.4],\n",
       " [8374, 2.5],\n",
       " [8386, 2.4],\n",
       " [8390, 1.6],\n",
       " [8409, 3.2],\n",
       " [8435, 2.1],\n",
       " [8456, 1.9],\n",
       " [8457, 1.9],\n",
       " [8461, 2.6],\n",
       " [8469, 1.9],\n",
       " [8587, 1.9],\n",
       " [8617, 2.5],\n",
       " [8618, 1.3],\n",
       " [8619, 1.9],\n",
       " [8645, 1.9],\n",
       " [8669, 2.6],\n",
       " [8675, 2.2],\n",
       " [8676, 2.4],\n",
       " [8780, 2.7],\n",
       " [8818, 1],\n",
       " [8871, 2.4],\n",
       " [8909, 2],\n",
       " [8944, 2.9],\n",
       " [8960, 2.4],\n",
       " [8966, 2.3],\n",
       " [8967, 2],\n",
       " [8968, 1.8],\n",
       " [8988, 2],\n",
       " [8999, 1.7],\n",
       " [9022, 2.2],\n",
       " [9030, 1.8],\n",
       " [9072, 3.4],\n",
       " [9257, 2.8],\n",
       " [9268, 2.2],\n",
       " [9297, 2.7],\n",
       " [9334, 2.8],\n",
       " [9353, 2.6],\n",
       " [9381, 2.2],\n",
       " [9400, 1.7],\n",
       " [9408, 2],\n",
       " [9425, 2.1],\n",
       " [9487, 1.8],\n",
       " [9489, 2.1],\n",
       " [9502, 1.4],\n",
       " [9543, 1.5],\n",
       " [9552, 1.9],\n",
       " [9613, 2.8],\n",
       " [9615, 2.2],\n",
       " [9654, 1.8],\n",
       " [9675, 2.2],\n",
       " [9682, 2.5],\n",
       " [9693, 2.3],\n",
       " [9701, 2.3],\n",
       " [9718, 1.7],\n",
       " [9759, 2.2],\n",
       " [9767, 2.2],\n",
       " [9792, 1.6],\n",
       " [9806, 2.2],\n",
       " [9836, 2.4],\n",
       " [9870, 1.7],\n",
       " [9884, 2.2],\n",
       " [9906, 1.8],\n",
       " [9920, 1.8],\n",
       " [9945, 1.9],\n",
       " [9946, 1.9],\n",
       " [9947, 2.1],\n",
       " [9982, 2],\n",
       " [9989, 1.6],\n",
       " [10016, 1.6],\n",
       " [10022, 2.3],\n",
       " [10024, 2.7],\n",
       " [10027, 1.5],\n",
       " [10030, 2.5],\n",
       " [10045, 2.6],\n",
       " [10053, 2.7],\n",
       " [10061, 1.6],\n",
       " [10067, 2.2],\n",
       " [10077, 2.3],\n",
       " [10133, 2.4],\n",
       " [10138, 1.8],\n",
       " [10139, 2.3],\n",
       " [10147, 2.8],\n",
       " [10153, 2.5],\n",
       " [10159, 1.9],\n",
       " [10184, 1.8],\n",
       " [10185, 2.2],\n",
       " [10186, 1.1],\n",
       " [10189, 1.5],\n",
       " [10191, 2.7],\n",
       " [10192, 1.9],\n",
       " [10193, 2.6],\n",
       " [10195, 1.7],\n",
       " [10196, 1.6],\n",
       " [10197, 1.7],\n",
       " [10198, 2.2],\n",
       " [10199, 1.6],\n",
       " [10229, 2.4],\n",
       " [10288, 1.5],\n",
       " [10313, 2.2],\n",
       " [10315, 1],\n",
       " [10316, 1.6],\n",
       " [10317, 2.1],\n",
       " [10358, 1.8],\n",
       " [10386, 2.5],\n",
       " [10483, 2.3],\n",
       " [10521, 2.7],\n",
       " [10523, 1.7],\n",
       " [10527, 1.9],\n",
       " [10528, 1.4],\n",
       " [10589, 1.6],\n",
       " [10625, 1.9],\n",
       " [10634, 1.7],\n",
       " [10637, 1.7],\n",
       " [10661, 1.7],\n",
       " [10664, 2.2],\n",
       " [10681, 2.3],\n",
       " [10748, 2.1],\n",
       " [10764, 2.8],\n",
       " [10865, 2.4],\n",
       " [10877, 2.1],\n",
       " [10947, 2.8],\n",
       " [10982, 1.7],\n",
       " [10985, 1.6],\n",
       " [10991, 2.4],\n",
       " [10992, 1.9],\n",
       " [11036, 2.1],\n",
       " [11056, 2.6],\n",
       " [11156, 2.2],\n",
       " [11199, 1.8],\n",
       " [11247, 2.4],\n",
       " [11260, 2],\n",
       " [11321, 1.9],\n",
       " [11322, 2.5],\n",
       " [11323, 2.3],\n",
       " [11324, 1.6],\n",
       " [11354, 1.6],\n",
       " [11386, 2.2],\n",
       " [11459, 1.5],\n",
       " [11619, 1.6],\n",
       " [11635, 1.8],\n",
       " [11665, 2.4],\n",
       " [11678, 2],\n",
       " [11679, 1.6],\n",
       " [11798, 2],\n",
       " [11802, 1.4],\n",
       " [11812, 2.1],\n",
       " [11908, 2.1],\n",
       " [12113, 1.7],\n",
       " [12155, 2.1],\n",
       " [12162, 1.9],\n",
       " [12163, 1.5],\n",
       " [12177, 2.2],\n",
       " [12247, 1.8],\n",
       " [12281, 2.2],\n",
       " [12289, 1.5],\n",
       " [12405, 1.3],\n",
       " [12569, 2],\n",
       " [12610, 1],\n",
       " [12620, 2.4],\n",
       " [12783, 2.5],\n",
       " [12819, 2.5],\n",
       " [12837, 2.2],\n",
       " [12901, 2.6],\n",
       " [13007, 2],\n",
       " [13051, 2.4],\n",
       " [13053, 2.6],\n",
       " [13056, 2],\n",
       " [13067, 1.7],\n",
       " [13090, 1.6],\n",
       " [13132, 2],\n",
       " [13150, 1.7],\n",
       " [13155, 1.8],\n",
       " [13160, 2.5],\n",
       " [13183, 2.2],\n",
       " [13184, 2.1],\n",
       " [13191, 1.7],\n",
       " [13198, 1.7],\n",
       " [13201, 1.3],\n",
       " [13223, 2.1],\n",
       " [13260, 2.5],\n",
       " [13335, 2.1],\n",
       " [13362, 1.2],\n",
       " [13363, 2.4],\n",
       " [13389, 2.4],\n",
       " [13405, 1.3],\n",
       " [13429, 1.3],\n",
       " [13508, 1.9],\n",
       " [13523, 1.6],\n",
       " [13576, 1.3],\n",
       " [13596, 1.8],\n",
       " [13600, 2.2],\n",
       " [13680, 1.4],\n",
       " [13689, 1.3],\n",
       " [13700, 2.4],\n",
       " [13751, 1.9],\n",
       " [13788, 1.9],\n",
       " [13805, 1.6],\n",
       " [13809, 1.7],\n",
       " [13811, 2.4],\n",
       " [13948, 2.2],\n",
       " [13963, 2.5],\n",
       " [13996, 1.9],\n",
       " [14024, 2.1],\n",
       " [14048, 1.9],\n",
       " [14137, 2.3],\n",
       " [14139, 2.1],\n",
       " [14144, 2.2],\n",
       " [14161, 1.9],\n",
       " [14191, 2.2],\n",
       " [14199, 1.5],\n",
       " [14306, 3],\n",
       " [14337, 1.8],\n",
       " [14435, 1.4],\n",
       " [14438, 2.7],\n",
       " [14442, 2.2],\n",
       " [14451, 1.9],\n",
       " [14536, 2.8],\n",
       " [14560, 1.7],\n",
       " [14745, 1.9],\n",
       " [14758, 2.3],\n",
       " [14836, 2.4],\n",
       " [14869, 2.4],\n",
       " [14914, 1.9],\n",
       " [15005, 1.8],\n",
       " [15092, 2.2],\n",
       " [15158, 1.4],\n",
       " [15512, 1.7],\n",
       " [15648, 2.9],\n",
       " [15907, 2.8],\n",
       " [16353, 1.6],\n",
       " [16523, 2.6],\n",
       " [16538, 2.2],\n",
       " [16558, 1.5],\n",
       " [16564, 2.1],\n",
       " [16577, 1.7],\n",
       " [16614, 1.6],\n",
       " [16617, 2.5],\n",
       " [16866, 1.6],\n",
       " [16869, 2.2],\n",
       " [16871, 2.1],\n",
       " [16899, 1.8],\n",
       " [16995, 2.4],\n",
       " [16996, 2.1],\n",
       " [17047, 2],\n",
       " [17134, 1.8],\n",
       " [17332, 1.6],\n",
       " [17431, 2.9],\n",
       " [17436, 1.6],\n",
       " [17578, 1.6],\n",
       " [17654, 0.9],\n",
       " [17813, 2.6],\n",
       " [17908, 2.1],\n",
       " [17926, 1.9],\n",
       " [17979, 1.3],\n",
       " [18126, 2.5],\n",
       " [18191, 1.6],\n",
       " [18238, 1.8],\n",
       " [18239, 2.2],\n",
       " [18240, 1.8],\n",
       " [18320, 2.2],\n",
       " [18357, 2.6],\n",
       " [18360, 2.4],\n",
       " [18405, 2.4],\n",
       " [18487, 1.3],\n",
       " [18501, 1.1],\n",
       " [18530, 2.2],\n",
       " [18533, 2.4],\n",
       " [18570, 1.7],\n",
       " [18615, 2.2],\n",
       " [18632, 2.6],\n",
       " [18734, 1.8],\n",
       " [18736, 1],\n",
       " [18785, 2.3],\n",
       " [18823, 2],\n",
       " [18925, 0.9],\n",
       " [18947, 1.9],\n",
       " [19265, 2.1],\n",
       " [19457, 1.7],\n",
       " [19585, 2],\n",
       " [19724, 2.7],\n",
       " [19840, 2.1],\n",
       " [19898, 1.8],\n",
       " [19899, 2.3],\n",
       " [19901, 1.6],\n",
       " [19904, 2.2],\n",
       " [19908, 2.5],\n",
       " [19912, 2.7],\n",
       " [19913, 1.3],\n",
       " [19959, 1.7],\n",
       " [19995, 2.6],\n",
       " [20083, 1.7],\n",
       " [20178, 1.6],\n",
       " [20352, 1.7],\n",
       " [20468, 2.7],\n",
       " [20526, 1.8],\n",
       " [20533, 2.3],\n",
       " [20616, 1.8],\n",
       " [20662, 1.8],\n",
       " [20697, 1.8],\n",
       " [20764, 1.7],\n",
       " [20766, 1.3],\n",
       " [20829, 2],\n",
       " [20856, 2.1],\n",
       " [20943, 1.7],\n",
       " [21334, 2.2],\n",
       " [21349, 2.4],\n",
       " [21355, 2.3],\n",
       " [21525, 2.1],\n",
       " [21755, 2.4],\n",
       " [21765, 2],\n",
       " [22051, 1.9],\n",
       " [22074, 2.4],\n",
       " [22327, 2.4],\n",
       " [22538, 1.6],\n",
       " [22787, 2],\n",
       " [22794, 1.4],\n",
       " [22804, 1.7],\n",
       " [22820, 2.6],\n",
       " [22821, 2],\n",
       " [22824, 2.2],\n",
       " [22825, 2],\n",
       " [22832, 2.2],\n",
       " [22881, 1.3],\n",
       " [22894, 2.1],\n",
       " [22897, 0.9],\n",
       " [22907, 2.3],\n",
       " [22947, 2.2],\n",
       " [22949, 2.3],\n",
       " [22954, 1.6],\n",
       " [22970, 2],\n",
       " [22972, 2.3],\n",
       " [23048, 2.3],\n",
       " [23049, 1.9],\n",
       " [23082, 2.8],\n",
       " [23168, 2.3],\n",
       " [23169, 1.4],\n",
       " [23367, 1.8],\n",
       " [23398, 1.7],\n",
       " [23629, 1.3],\n",
       " [23631, 2.1],\n",
       " [23706, 1.5],\n",
       " [23742, 2.6],\n",
       " [23759, 2.2],\n",
       " [23827, 1.9],\n",
       " [24021, 1.9],\n",
       " [24150, 3.1],\n",
       " [24428, 1.8],\n",
       " [24432, 2.3],\n",
       " [24663, 1.9],\n",
       " [24684, 2.8],\n",
       " [24803, 1.4],\n",
       " [25195, 2.6],\n",
       " [25350, 1.3],\n",
       " [25643, 1.6],\n",
       " [25704, 1.7],\n",
       " [25719, 2.5],\n",
       " [25793, 2.2],\n",
       " [25968, 1.7],\n",
       " [26022, 2],\n",
       " [26171, 3],\n",
       " [26320, 2.8],\n",
       " [26388, 2.1],\n",
       " [26389, 1.7],\n",
       " [26428, 2],\n",
       " [26815, 1.5],\n",
       " [26963, 2],\n",
       " [27022, 2.2],\n",
       " [27205, 2.3],\n",
       " [27374, 2.5],\n",
       " [27569, 2.8],\n",
       " [27573, 2.9],\n",
       " [27576, 2.5],\n",
       " [27578, 1.9],\n",
       " [27581, 1.5],\n",
       " [27582, 2],\n",
       " [27585, 1.3],\n",
       " [28089, 2.2],\n",
       " [28355, 2.3],\n",
       " [29406, 1.6],\n",
       " [29426, 2.7],\n",
       " [29917, 2.1],\n",
       " [29963, 1.1],\n",
       " [30596, 1],\n",
       " [31117, 1.6],\n",
       " [31867, 2.7],\n",
       " [32579, 2.2],\n",
       " [32823, 1.7],\n",
       " [32856, 2],\n",
       " [33155, 2.7],\n",
       " [33217, 2],\n",
       " [33511, 2.4],\n",
       " [33870, 2],\n",
       " [33909, 2.7],\n",
       " [34016, 2.3],\n",
       " [34335, 2],\n",
       " [34563, 1.2],\n",
       " [34592, 2.4],\n",
       " [34806, 1.6],\n",
       " [34813, 2.2],\n",
       " [35019, 2.3],\n",
       " [35056, 2.4],\n",
       " [35169, 2],\n",
       " [35688, 1.8],\n",
       " [35791, 1.3],\n",
       " [36046, 1.6],\n",
       " [36047, 2.3],\n",
       " [36419, 2.1],\n",
       " [36557, 1.8],\n",
       " [36586, 0.8],\n",
       " [36643, 1.7],\n",
       " [36647, 1.2],\n",
       " [36648, 1.9],\n",
       " [36669, 1.8],\n",
       " [36670, 1.4],\n",
       " [36691, 1.9],\n",
       " [36811, 2.4],\n",
       " [36825, 1.7],\n",
       " [36970, 1.8],\n",
       " [37003, 1.3],\n",
       " [37056, 2.1],\n",
       " [37232, 2.5],\n",
       " [37414, 1.7],\n",
       " [37495, 2],\n",
       " [37686, 2.1],\n",
       " [37694, 2.3],\n",
       " [37707, 2.6],\n",
       " [37710, 1.5],\n",
       " [37724, 2.5],\n",
       " [37735, 2.1],\n",
       " [37786, 2.2],\n",
       " [37799, 3.2],\n",
       " [37821, 1.8],\n",
       " [37834, 1.1],\n",
       " [37931, 1.9],\n",
       " [37958, 2.3],\n",
       " [38050, 1.1],\n",
       " [38055, 2.3],\n",
       " [38073, 1.6],\n",
       " [38117, 2.2],\n",
       " [38167, 2.2],\n",
       " [38317, 1.9],\n",
       " [38319, 1.9],\n",
       " [38321, 2],\n",
       " [38322, 1.7],\n",
       " [38356, 1.8],\n",
       " [38357, 1.8],\n",
       " [38358, 1.9],\n",
       " [38363, 1.7],\n",
       " [38365, 2.1],\n",
       " [38428, 2],\n",
       " [38448, 2.3],\n",
       " [38579, 2],\n",
       " [38757, 1.3],\n",
       " [38778, 1.7],\n",
       " [38810, 2.3],\n",
       " [38843, 1.9],\n",
       " [39013, 1.9],\n",
       " [39053, 1.7],\n",
       " [39055, 2.1],\n",
       " [39254, 1.5],\n",
       " [39349, 1.7],\n",
       " [39451, 2.1],\n",
       " [39486, 2.7],\n",
       " [39513, 2],\n",
       " [39538, 2.1],\n",
       " [39563, 2],\n",
       " [39691, 1.8],\n",
       " [39781, 0.8],\n",
       " [39806, 2.5],\n",
       " [40264, 1.7],\n",
       " [40805, 2.1],\n",
       " [40807, 3],\n",
       " [41009, 2.7],\n",
       " [41144, 2.1],\n",
       " [41154, 2],\n",
       " [41210, 2.6],\n",
       " [41216, 2.6],\n",
       " [41233, 2.3],\n",
       " [41283, 2.2],\n",
       " [41402, 2.1],\n",
       " [41436, 1.9],\n",
       " [41439, 1.6],\n",
       " [41446, 1.8],\n",
       " [41479, 1.7],\n",
       " [41513, 1.2],\n",
       " [41515, 1],\n",
       " [41630, 1.8],\n",
       " [41733, 2.1],\n",
       " [42057, 2],\n",
       " [42151, 2.3],\n",
       " [42188, 2.2],\n",
       " [42297, 2.1],\n",
       " [42888, 2.4],\n",
       " [43074, 1.7],\n",
       " [43090, 1.6],\n",
       " [43347, 1.7],\n",
       " [43418, 1.5],\n",
       " [43539, 1.9],\n",
       " [43593, 2],\n",
       " [43923, 1.9],\n",
       " [43933, 2.1],\n",
       " [43935, 1.9],\n",
       " [43942, 1.9],\n",
       " [43949, 0.9],\n",
       " [43959, 2.5],\n",
       " [44040, 2.7],\n",
       " [44113, 2],\n",
       " [44147, 2.8],\n",
       " [44214, 1.9],\n",
       " [44264, 1.5],\n",
       " [44564, 2.2],\n",
       " [44603, 2.5],\n",
       " [44639, 2],\n",
       " [44826, 1.6],\n",
       " [44835, 2.4],\n",
       " [44896, 1.8],\n",
       " [44912, 2.2],\n",
       " [44943, 2],\n",
       " [44944, 1.5],\n",
       " [44945, 1.6],\n",
       " [45132, 1.2],\n",
       " [45243, 2.1],\n",
       " [45269, 1.8],\n",
       " [45272, 2.2],\n",
       " [45317, 1.8],\n",
       " [45324, 2.3],\n",
       " [45610, 0.8],\n",
       " [45612, 2.1],\n",
       " [45649, 2.5],\n",
       " [45650, 1.5],\n",
       " [45658, 1.9],\n",
       " [46146, 2.3],\n",
       " [46195, 2.2],\n",
       " [46256, 2.3],\n",
       " [46261, 2],\n",
       " [46332, 2],\n",
       " [46420, 1.4],\n",
       " [46528, 1.9],\n",
       " [46529, 1.7],\n",
       " [46705, 1.8],\n",
       " [46727, 2.3],\n",
       " [46738, 1.8],\n",
       " [46829, 1.8],\n",
       " [47088, 2.1],\n",
       " [47327, 2.2],\n",
       " [47546, 2.1],\n",
       " [47607, 2.6],\n",
       " [47933, 2.7],\n",
       " [47964, 1.6],\n",
       " [48034, 1.6],\n",
       " [48138, 2.6],\n",
       " [48171, 1.7],\n",
       " [48231, 2.8],\n",
       " [48289, 2.7],\n",
       " [48340, 2.6],\n",
       " [48988, 2.6],\n",
       " [49010, 2],\n",
       " [49013, 2.1],\n",
       " [49018, 1.3],\n",
       " [49020, 2.9],\n",
       " [49022, 2.1],\n",
       " [49026, 2.4],\n",
       " [49040, 2.2],\n",
       " [49047, 1.4],\n",
       " [49049, 1.4],\n",
       " [49051, 1.7],\n",
       " [49444, 2.1],\n",
       " [49517, 1.2],\n",
       " [49519, 2.3],\n",
       " [49520, 1.7],\n",
       " [49521, 1.6],\n",
       " [49524, 3],\n",
       " [49526, 2.4],\n",
       " [49527, 1.6],\n",
       " [49529, 2.1],\n",
       " [49530, 1.9],\n",
       " [49538, 2.1],\n",
       " [49730, 1.9],\n",
       " [49787, 2.3],\n",
       " [49950, 2],\n",
       " [50014, 1.9],\n",
       " [50321, 1],\n",
       " [50348, 1.9],\n",
       " [50357, 2.2],\n",
       " [50359, 1.9],\n",
       " [50456, 2.1],\n",
       " [50544, 2.2],\n",
       " [50546, 2.3],\n",
       " [50646, 2],\n",
       " [50647, 2.1],\n",
       " [50698, 2.1],\n",
       " [50725, 2],\n",
       " [50780, 3],\n",
       " [50837, 2],\n",
       " [50839, 2.6],\n",
       " [50848, 1.9],\n",
       " [51052, 1.7],\n",
       " [51162, 1.9],\n",
       " [51497, 2.7],\n",
       " [51540, 2],\n",
       " [51588, 1.8],\n",
       " [51828, 2.3],\n",
       " [51995, 2.7],\n",
       " [52010, 2.1],\n",
       " [52015, 2.3],\n",
       " [52067, 2.1],\n",
       " [52449, 2.3],\n",
       " [52451, 2.3],\n",
       " [52520, 2],\n",
       " [53182, 2.3],\n",
       " [54054, 2.2],\n",
       " [54518, 1.1],\n",
       " [54897, 1.6],\n",
       " [55301, 1.5],\n",
       " ...]"
      ]
     },
     "execution_count": 105,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list_moviesId_avgRating=[]\n",
    "\n",
    "#  collecting movie id with average rating\n",
    "for ids in movies_users_df.columns:\n",
    "    list_moviesId_avgRating.append([ ids , mean( movies_users_df[ids])])\n",
    "list_moviesId_avgRating"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 107,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>movie_id</th>\n",
       "      <th>avg_rating</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>11</td>\n",
       "      <td>1.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>12</td>\n",
       "      <td>2.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>14</td>\n",
       "      <td>1.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>22</td>\n",
       "      <td>1.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>24</td>\n",
       "      <td>2.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1489</th>\n",
       "      <td>376659</td>\n",
       "      <td>1.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1490</th>\n",
       "      <td>385383</td>\n",
       "      <td>2.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1491</th>\n",
       "      <td>385736</td>\n",
       "      <td>2.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1492</th>\n",
       "      <td>394047</td>\n",
       "      <td>2.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1493</th>\n",
       "      <td>426469</td>\n",
       "      <td>2.4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1494 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      movie_id  avg_rating\n",
       "0           11         1.4\n",
       "1           12         2.3\n",
       "2           14         1.6\n",
       "3           22         1.4\n",
       "4           24         2.5\n",
       "...        ...         ...\n",
       "1489    376659         1.8\n",
       "1490    385383         2.1\n",
       "1491    385736         2.1\n",
       "1492    394047         2.3\n",
       "1493    426469         2.4\n",
       "\n",
       "[1494 rows x 2 columns]"
      ]
     },
     "execution_count": 107,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# create a data frame of movie id and average rating\n",
    "movies_usersRating_df=pd.DataFrame(list_moviesId_avgRating,columns=(\"movie_id\",\"avg_rating\"))\n",
    "movies_usersRating_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 109,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>movie_id</th>\n",
       "      <th>genres</th>\n",
       "      <th>avg_rating</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>19995</td>\n",
       "      <td>Action</td>\n",
       "      <td>2.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>19995</td>\n",
       "      <td>Adventure</td>\n",
       "      <td>2.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>19995</td>\n",
       "      <td>Fantasy</td>\n",
       "      <td>2.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>19995</td>\n",
       "      <td>Science Fiction</td>\n",
       "      <td>2.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>285</td>\n",
       "      <td>Adventure</td>\n",
       "      <td>1.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3905</th>\n",
       "      <td>255266</td>\n",
       "      <td>Romance</td>\n",
       "      <td>2.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3906</th>\n",
       "      <td>157185</td>\n",
       "      <td>Horror</td>\n",
       "      <td>1.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3907</th>\n",
       "      <td>14337</td>\n",
       "      <td>Science Fiction</td>\n",
       "      <td>1.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3908</th>\n",
       "      <td>14337</td>\n",
       "      <td>Drama</td>\n",
       "      <td>1.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3909</th>\n",
       "      <td>14337</td>\n",
       "      <td>Thriller</td>\n",
       "      <td>1.8</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3910 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      movie_id           genres  avg_rating\n",
       "0        19995           Action         2.6\n",
       "1        19995        Adventure         2.6\n",
       "2        19995          Fantasy         2.6\n",
       "3        19995  Science Fiction         2.6\n",
       "4          285        Adventure         1.8\n",
       "...        ...              ...         ...\n",
       "3905    255266          Romance         2.3\n",
       "3906    157185           Horror         1.6\n",
       "3907     14337  Science Fiction         1.8\n",
       "3908     14337            Drama         1.8\n",
       "3909     14337         Thriller         1.8\n",
       "\n",
       "[3910 rows x 3 columns]"
      ]
     },
     "execution_count": 109,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# merge average rating with dataframe of genres and movie id\n",
    "movieId_geners_avgRating=gener_movie_id.merge(movies_usersRating_df,on='movie_id')\n",
    "movieId_geners_avgRating"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 114,
   "metadata": {},
   "outputs": [],
   "source": [
    "# remove rows having null values and remove duplicates rows\n",
    "movieId_geners_avgRating.dropna(inplace=True)\n",
    "movieId_geners_avgRating=movieId_geners_avgRating.drop_duplicates()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 117,
   "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>genres</th>\n",
       "      <th>Action</th>\n",
       "      <th>Adventure</th>\n",
       "      <th>Animation</th>\n",
       "      <th>Comedy</th>\n",
       "      <th>Crime</th>\n",
       "      <th>Documentary</th>\n",
       "      <th>Drama</th>\n",
       "      <th>Family</th>\n",
       "      <th>Fantasy</th>\n",
       "      <th>Foreign</th>\n",
       "      <th>History</th>\n",
       "      <th>Horror</th>\n",
       "      <th>Music</th>\n",
       "      <th>Mystery</th>\n",
       "      <th>Romance</th>\n",
       "      <th>Science Fiction</th>\n",
       "      <th>TV Movie</th>\n",
       "      <th>Thriller</th>\n",
       "      <th>War</th>\n",
       "      <th>Western</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>movie_id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1.4</td>\n",
       "      <td>1.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.6</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>1.4</td>\n",
       "      <td>1.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>376659</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.8</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>385383</th>\n",
       "      <td>2.1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>385736</th>\n",
       "      <td>0.0</td>\n",
       "      <td>2.1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>394047</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>426469</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.4</td>\n",
       "      <td>2.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1492 rows × 20 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "genres    Action  Adventure  Animation  Comedy  Crime  Documentary  Drama  \\\n",
       "movie_id                                                                    \n",
       "11           1.4        1.4        0.0     0.0    0.0          0.0    0.0   \n",
       "12           0.0        0.0        2.3     0.0    0.0          0.0    0.0   \n",
       "14           0.0        0.0        0.0     0.0    0.0          0.0    1.6   \n",
       "22           1.4        1.4        0.0     0.0    0.0          0.0    0.0   \n",
       "24           2.5        0.0        0.0     0.0    2.5          0.0    0.0   \n",
       "...          ...        ...        ...     ...    ...          ...    ...   \n",
       "376659       0.0        0.0        0.0     1.8    0.0          0.0    0.0   \n",
       "385383       2.1        0.0        0.0     0.0    0.0          0.0    2.1   \n",
       "385736       0.0        2.1        0.0     0.0    0.0          0.0    0.0   \n",
       "394047       0.0        0.0        0.0     0.0    0.0          0.0    2.3   \n",
       "426469       0.0        0.0        0.0     2.4    0.0          0.0    2.4   \n",
       "\n",
       "genres    Family  Fantasy  Foreign  History  Horror  Music  Mystery  Romance  \\\n",
       "movie_id                                                                       \n",
       "11           0.0      0.0      0.0      0.0     0.0    0.0      0.0      0.0   \n",
       "12           2.3      0.0      0.0      0.0     0.0    0.0      0.0      0.0   \n",
       "14           0.0      0.0      0.0      0.0     0.0    0.0      0.0      0.0   \n",
       "22           0.0      1.4      0.0      0.0     0.0    0.0      0.0      0.0   \n",
       "24           0.0      0.0      0.0      0.0     0.0    0.0      0.0      0.0   \n",
       "...          ...      ...      ...      ...     ...    ...      ...      ...   \n",
       "376659       0.0      0.0      0.0      0.0     0.0    0.0      0.0      0.0   \n",
       "385383       0.0      0.0      0.0      0.0     0.0    0.0      0.0      0.0   \n",
       "385736       0.0      0.0      0.0      0.0     0.0    0.0      0.0      0.0   \n",
       "394047       0.0      0.0      0.0      0.0     0.0    0.0      0.0      0.0   \n",
       "426469       2.4      0.0      0.0      0.0     0.0    0.0      0.0      0.0   \n",
       "\n",
       "genres    Science Fiction  TV Movie  Thriller  War  Western  \n",
       "movie_id                                                     \n",
       "11                    1.4       0.0       0.0  0.0      0.0  \n",
       "12                    0.0       0.0       0.0  0.0      0.0  \n",
       "14                    0.0       0.0       0.0  0.0      0.0  \n",
       "22                    0.0       0.0       0.0  0.0      0.0  \n",
       "24                    0.0       0.0       0.0  0.0      0.0  \n",
       "...                   ...       ...       ...  ...      ...  \n",
       "376659                0.0       0.0       0.0  0.0      0.0  \n",
       "385383                0.0       0.0       0.0  0.0      0.0  \n",
       "385736                0.0       0.0       0.0  0.0      0.0  \n",
       "394047                0.0       0.0       0.0  0.0      0.0  \n",
       "426469                0.0       0.0       0.0  0.0      0.0  \n",
       "\n",
       "[1492 rows x 20 columns]"
      ]
     },
     "execution_count": 117,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# generate matrix between movies id and genres with values as average rating\n",
    "movieId_geners_avgRating_mat=movieId_geners_avgRating.pivot(index='movie_id',columns='genres',values='avg_rating').fillna(0)\n",
    "movieId_geners_avgRating_mat"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 125,
   "metadata": {},
   "outputs": [],
   "source": [
    "# create a file in directory\n",
    "pickle.dump(movieId_geners_avgRating_mat,open('genres_with_movieId.pkl','wb'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 122,
   "metadata": {},
   "outputs": [],
   "source": [
    "genres=list(movieId_geners_avgRating_mat.columns)\n",
    "\n",
    "\n",
    "# create a file in directory\n",
    "pickle.dump(genres,open('genres.pkl','wb'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 126,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[558, 68728, 708, 135397, 68726, 157336]"
      ]
     },
     "execution_count": 126,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#  this function accepts genres name and number of recommend of movies user want and return a list of id by sorting all movie of same genres with reverse order of average ratings\n",
    "def recommend_movies_by_genres(genres_name,no_of_recommendations):\n",
    "    movies_list=movieId_geners_avgRating_mat[genres_name]\n",
    "    movies_list=movies_list.sort_values(ascending=False)\n",
    "    recommend_movies=[]\n",
    "    counter=0\n",
    "    for i in movies_list.index:\n",
    "        if(counter==no_of_recommendations+1):\n",
    "            break\n",
    "        recommend_movies.append(i)\n",
    "        counter=counter+1\n",
    "    return recommend_movies    \n",
    "recommend_movies_by_genres('Adventure',5)"
   ]
  }
 ],
 "metadata": {
  "interpreter": {
   "hash": "0c1c562b786c386f74d2e5e72ff607da117e3591530fbf71a31b6d249885b464"
  },
  "kernelspec": {
   "display_name": "Python 3.9.4 64-bit",
   "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.9.4"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}