Collaborativ_Filltering.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 103,
   "metadata": {},
   "outputs": [],
   "source": [
    "# imports\n",
    "\n",
    "import pandas as pd\n",
    "import numpy as np\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 104,
   "metadata": {},
   "outputs": [],
   "source": [
    "# reading movies data\n",
    "df = pd.read_csv('./movies.csv', sep=',')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 105,
   "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>user_id</th>\n",
       "      <th>title</th>\n",
       "      <th>user_rating</th>\n",
       "      <th>genre</th>\n",
       "      <th>release date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>(500) Days of Summer</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Comedy</td>\n",
       "      <td>2009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>12 Rounds</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Action</td>\n",
       "      <td>2009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>127 Hours</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Adventure</td>\n",
       "      <td>2010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>30 Days of Night</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Horror</td>\n",
       "      <td>2007</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>50/50</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Comedy</td>\n",
       "      <td>2011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1</td>\n",
       "      <td>88 Minutes</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Drama</td>\n",
       "      <td>2007</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1</td>\n",
       "      <td>A Serious Man</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Drama</td>\n",
       "      <td>2009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1</td>\n",
       "      <td>A Very Harold and Kumar Christmas</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Comedy</td>\n",
       "      <td>2011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1</td>\n",
       "      <td>Across the Universe</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Romance</td>\n",
       "      <td>2007</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1</td>\n",
       "      <td>Adventureland</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Comedy</td>\n",
       "      <td>2009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1</td>\n",
       "      <td>Alice in Wonderland</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Adventure</td>\n",
       "      <td>2010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1</td>\n",
       "      <td>Aliens in the Attic</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Adventure</td>\n",
       "      <td>2009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1</td>\n",
       "      <td>American Gangster</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Thriller</td>\n",
       "      <td>2007</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1</td>\n",
       "      <td>An Education</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Drama</td>\n",
       "      <td>2009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1</td>\n",
       "      <td>Apollo 18</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Horror</td>\n",
       "      <td>2011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1</td>\n",
       "      <td>Armored</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Action</td>\n",
       "      <td>2009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1</td>\n",
       "      <td>Australia</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Adventure</td>\n",
       "      <td>2008</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2</td>\n",
       "      <td>(500) Days of Summer</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Comedy</td>\n",
       "      <td>2009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2</td>\n",
       "      <td>12 Rounds</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Action</td>\n",
       "      <td>2008</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2</td>\n",
       "      <td>127 Hours</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Comedy</td>\n",
       "      <td>2011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2</td>\n",
       "      <td>17 Again</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Comedy</td>\n",
       "      <td>2009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2</td>\n",
       "      <td>30 Minutes or Less</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Comedy</td>\n",
       "      <td>2008</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2</td>\n",
       "      <td>88 Minutes</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Comedy</td>\n",
       "      <td>2008</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2</td>\n",
       "      <td>A Nightmare on Elm Street</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Action</td>\n",
       "      <td>2007</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2</td>\n",
       "      <td>A Very Harold and Kumar Christmas</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Drama</td>\n",
       "      <td>2010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2</td>\n",
       "      <td>Across the Universe</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Action</td>\n",
       "      <td>2008</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2</td>\n",
       "      <td>Adventureland</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Comedy</td>\n",
       "      <td>2009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2</td>\n",
       "      <td>Alice in Wonderland</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Action</td>\n",
       "      <td>2009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2</td>\n",
       "      <td>Aliens in the Attic</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Comedy</td>\n",
       "      <td>2009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2</td>\n",
       "      <td>All About Steve</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Drama</td>\n",
       "      <td>2010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>2</td>\n",
       "      <td>All Good Things</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Drama</td>\n",
       "      <td>2010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>2</td>\n",
       "      <td>American Gangster</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Action</td>\n",
       "      <td>2011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>2</td>\n",
       "      <td>An Education</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Horror</td>\n",
       "      <td>2009</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    user_id                              title  user_rating      genre  \\\n",
       "0         1              (500) Days of Summer           1.0     Comedy   \n",
       "1         1                         12 Rounds           5.0     Action   \n",
       "2         1                          127 Hours          4.0  Adventure   \n",
       "3         1                   30 Days of Night          2.0     Horror   \n",
       "4         1                              50/50          4.0     Comedy   \n",
       "5         1                         88 Minutes          5.0      Drama   \n",
       "6         1                     A Serious Man           1.0      Drama   \n",
       "7         1  A Very Harold and Kumar Christmas          3.0     Comedy   \n",
       "8         1                Across the Universe          4.0    Romance   \n",
       "9         1                     Adventureland           2.0     Comedy   \n",
       "10        1                Alice in Wonderland          3.0  Adventure   \n",
       "11        1                Aliens in the Attic          4.0  Adventure   \n",
       "12        1                  American Gangster          2.0   Thriller   \n",
       "13        1                       An Education          1.0      Drama   \n",
       "14        1                          Apollo 18          4.0     Horror   \n",
       "15        1                           Armored           2.0     Action   \n",
       "16        1                          Australia          3.0  Adventure   \n",
       "17        2              (500) Days of Summer           2.0     Comedy   \n",
       "18        2                         12 Rounds           1.0     Action   \n",
       "19        2                          127 Hours          NaN     Comedy   \n",
       "20        2                          17 Again           3.0     Comedy   \n",
       "21        2                 30 Minutes or Less          4.0     Comedy   \n",
       "22        2                         88 Minutes          5.0     Comedy   \n",
       "23        2          A Nightmare on Elm Street          1.0     Action   \n",
       "24        2  A Very Harold and Kumar Christmas          3.0      Drama   \n",
       "25        2                Across the Universe          2.0     Action   \n",
       "26        2                     Adventureland           5.0     Comedy   \n",
       "27        2                Alice in Wonderland          1.0     Action   \n",
       "28        2                Aliens in the Attic          4.0     Comedy   \n",
       "29        2                   All About Steve           3.0      Drama   \n",
       "30        2                    All Good Things          1.0      Drama   \n",
       "31        2                  American Gangster          3.0     Action   \n",
       "32        2                       An Education          2.0     Horror   \n",
       "\n",
       "    release date  \n",
       "0           2009  \n",
       "1           2009  \n",
       "2           2010  \n",
       "3           2007  \n",
       "4           2011  \n",
       "5           2007  \n",
       "6           2009  \n",
       "7           2011  \n",
       "8           2007  \n",
       "9           2009  \n",
       "10          2010  \n",
       "11          2009  \n",
       "12          2007  \n",
       "13          2009  \n",
       "14          2011  \n",
       "15          2009  \n",
       "16          2008  \n",
       "17          2009  \n",
       "18          2008  \n",
       "19          2011  \n",
       "20          2009  \n",
       "21          2008  \n",
       "22          2008  \n",
       "23          2007  \n",
       "24          2010  \n",
       "25          2008  \n",
       "26          2009  \n",
       "27          2009  \n",
       "28          2009  \n",
       "29          2010  \n",
       "30          2010  \n",
       "31          2011  \n",
       "32          2009  "
      ]
     },
     "execution_count": 105,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# checking data\n",
    "df.head(33)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 106,
   "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>user_id</th>\n",
       "      <th>user_rating</th>\n",
       "      <th>release date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>142.000000</td>\n",
       "      <td>139.000000</td>\n",
       "      <td>142.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>5.084507</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>2009.161972</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>2.903881</td>\n",
       "      <td>1.302172</td>\n",
       "      <td>1.291749</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2007.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>2.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>2008.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>5.000000</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>2009.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>8.000000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>2010.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>10.000000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>2011.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          user_id  user_rating  release date\n",
       "count  142.000000   139.000000    142.000000\n",
       "mean     5.084507     3.000000   2009.161972\n",
       "std      2.903881     1.302172      1.291749\n",
       "min      1.000000     1.000000   2007.000000\n",
       "25%      2.000000     2.000000   2008.000000\n",
       "50%      5.000000     3.000000   2009.000000\n",
       "75%      8.000000     4.000000   2010.000000\n",
       "max     10.000000     5.000000   2011.000000"
      ]
     },
     "execution_count": 106,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# get some info about the data set\n",
    "df.describe()"
   ]
  },
  {
   "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>user_rating</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>title</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>(500) Days of Summer</th>\n",
       "      <td>2.285714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10,000 B.C.</th>\n",
       "      <td>3.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12 Rounds</th>\n",
       "      <td>3.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127 Hours</th>\n",
       "      <td>3.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17 Again</th>\n",
       "      <td>2.600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27 Dresses</th>\n",
       "      <td>2.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30 Days of Night</th>\n",
       "      <td>2.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30 Minutes or Less</th>\n",
       "      <td>3.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50/50</th>\n",
       "      <td>3.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88 Minutes</th>\n",
       "      <td>3.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>A Dangerous Method</th>\n",
       "      <td>3.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>A Nightmare on Elm Street</th>\n",
       "      <td>1.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>A Serious Man</th>\n",
       "      <td>3.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>A Very Harold and Kumar Christmas</th>\n",
       "      <td>3.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Abduction</th>\n",
       "      <td>3.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Across the Universe</th>\n",
       "      <td>2.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Adventureland</th>\n",
       "      <td>3.800000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Albert Nobbs</th>\n",
       "      <td>2.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Alice in Wonderland</th>\n",
       "      <td>2.857143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Alien vs. Predator -- Requiem</th>\n",
       "      <td>3.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Aliens in the Attic</th>\n",
       "      <td>4.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>All About Steve</th>\n",
       "      <td>2.857143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>All Good Things</th>\n",
       "      <td>2.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Amelia</th>\n",
       "      <td>4.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>American Gangster</th>\n",
       "      <td>3.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>An Education</th>\n",
       "      <td>2.285714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Anonymous</th>\n",
       "      <td>3.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Apollo 18</th>\n",
       "      <td>3.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Appaloosa</th>\n",
       "      <td>3.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Armored</th>\n",
       "      <td>2.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Arthur</th>\n",
       "      <td>3.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Australia</th>\n",
       "      <td>2.600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Avatar</th>\n",
       "      <td>4.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                   user_rating\n",
       "title                                         \n",
       "(500) Days of Summer                  2.285714\n",
       "10,000 B.C.                           3.000000\n",
       "12 Rounds                             3.000000\n",
       "127 Hours                             3.500000\n",
       "17 Again                              2.600000\n",
       "27 Dresses                            2.500000\n",
       "30 Days of Night                      2.500000\n",
       "30 Minutes or Less                    3.666667\n",
       "50/50                                 3.000000\n",
       "88 Minutes                            3.500000\n",
       "A Dangerous Method                    3.000000\n",
       "A Nightmare on Elm Street             1.666667\n",
       "A Serious Man                         3.000000\n",
       "A Very Harold and Kumar Christmas     3.666667\n",
       "Abduction                             3.500000\n",
       "Across the Universe                   2.000000\n",
       "Adventureland                         3.800000\n",
       "Albert Nobbs                          2.666667\n",
       "Alice in Wonderland                   2.857143\n",
       "Alien vs. Predator -- Requiem         3.333333\n",
       "Aliens in the Attic                   4.500000\n",
       "All About Steve                       2.857143\n",
       "All Good Things                       2.333333\n",
       "Amelia                                4.000000\n",
       "American Gangster                     3.000000\n",
       "An Education                          2.285714\n",
       "Anonymous                             3.333333\n",
       "Apollo 18                             3.000000\n",
       "Appaloosa                             3.000000\n",
       "Armored                               2.750000\n",
       "Arthur                                3.750000\n",
       "Australia                             2.600000\n",
       "Avatar                                4.000000"
      ]
     },
     "execution_count": 107,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# get all the mean rating for all titles \n",
    "ratings = pd.DataFrame(df.groupby('title')['user_rating'].mean())\n",
    "ratings.head(33)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 108,
   "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>user_rating</th>\n",
       "      <th>number_of_ratings</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>title</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>(500) Days of Summer</th>\n",
       "      <td>2.285714</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10,000 B.C.</th>\n",
       "      <td>3.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12 Rounds</th>\n",
       "      <td>3.000000</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127 Hours</th>\n",
       "      <td>3.500000</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17 Again</th>\n",
       "      <td>2.600000</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27 Dresses</th>\n",
       "      <td>2.500000</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30 Days of Night</th>\n",
       "      <td>2.500000</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30 Minutes or Less</th>\n",
       "      <td>3.666667</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50/50</th>\n",
       "      <td>3.000000</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88 Minutes</th>\n",
       "      <td>3.500000</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>A Dangerous Method</th>\n",
       "      <td>3.000000</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>A Nightmare on Elm Street</th>\n",
       "      <td>1.666667</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>A Serious Man</th>\n",
       "      <td>3.000000</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>A Very Harold and Kumar Christmas</th>\n",
       "      <td>3.666667</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Abduction</th>\n",
       "      <td>3.500000</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Across the Universe</th>\n",
       "      <td>2.000000</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Adventureland</th>\n",
       "      <td>3.800000</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Albert Nobbs</th>\n",
       "      <td>2.666667</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Alice in Wonderland</th>\n",
       "      <td>2.857143</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Alien vs. Predator -- Requiem</th>\n",
       "      <td>3.333333</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Aliens in the Attic</th>\n",
       "      <td>4.500000</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>All About Steve</th>\n",
       "      <td>2.857143</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>All Good Things</th>\n",
       "      <td>2.333333</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Amelia</th>\n",
       "      <td>4.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>American Gangster</th>\n",
       "      <td>3.000000</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>An Education</th>\n",
       "      <td>2.285714</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Anonymous</th>\n",
       "      <td>3.333333</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Apollo 18</th>\n",
       "      <td>3.000000</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Appaloosa</th>\n",
       "      <td>3.000000</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Armored</th>\n",
       "      <td>2.750000</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Arthur</th>\n",
       "      <td>3.750000</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Australia</th>\n",
       "      <td>2.600000</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Avatar</th>\n",
       "      <td>4.000000</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                   user_rating  number_of_ratings\n",
       "title                                                            \n",
       "(500) Days of Summer                  2.285714                  7\n",
       "10,000 B.C.                           3.000000                  1\n",
       "12 Rounds                             3.000000                  5\n",
       "127 Hours                             3.500000                  4\n",
       "17 Again                              2.600000                  5\n",
       "27 Dresses                            2.500000                  2\n",
       "30 Days of Night                      2.500000                  4\n",
       "30 Minutes or Less                    3.666667                  3\n",
       "50/50                                 3.000000                  5\n",
       "88 Minutes                            3.500000                  6\n",
       "A Dangerous Method                    3.000000                  6\n",
       "A Nightmare on Elm Street             1.666667                  3\n",
       "A Serious Man                         3.000000                  5\n",
       "A Very Harold and Kumar Christmas     3.666667                  3\n",
       "Abduction                             3.500000                  4\n",
       "Across the Universe                   2.000000                  4\n",
       "Adventureland                         3.800000                  5\n",
       "Albert Nobbs                          2.666667                  3\n",
       "Alice in Wonderland                   2.857143                  7\n",
       "Alien vs. Predator -- Requiem         3.333333                  3\n",
       "Aliens in the Attic                   4.500000                  4\n",
       "All About Steve                       2.857143                  7\n",
       "All Good Things                       2.333333                  3\n",
       "Amelia                                4.000000                  1\n",
       "American Gangster                     3.000000                  6\n",
       "An Education                          2.285714                  7\n",
       "Anonymous                             3.333333                  3\n",
       "Apollo 18                             3.000000                  4\n",
       "Appaloosa                             3.000000                  2\n",
       "Armored                               2.750000                  4\n",
       "Arthur                                3.750000                  4\n",
       "Australia                             2.600000                  5\n",
       "Avatar                                4.000000                  4"
      ]
     },
     "execution_count": 108,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# getting how many times a title has been rated \n",
    "ratings['number_of_ratings'] = df.groupby('title')['user_rating'].count()\n",
    "ratings.head(33)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 109,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<seaborn.axisgrid.JointGrid at 0x18626120d30>"
      ]
     },
     "execution_count": 109,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAkAAAAJOCAYAAABfkLhGAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjYuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8o6BhiAAAACXBIWXMAAA9hAAAPYQGoP6dpAAA53ElEQVR4nO3de3hU9YHG8Xcg98uEkCHhYoIoKRdLCBexII1aFXQpT6EUt4gCau1WUbmUfSDeEF0h7nrB2l0qXqBb6rK1CI+yVcQLIKiISEpiAQGBsBqIw2Um94Rk9g83qSEhl8nMnJn5fT/PM89jzjlz5s0vh563Z35zxubxeDwCAAAwSBerAwAAAAQaBQgAABiHAgQAAIxDAQIAAMahAAEAAONQgAAAgHEoQAAAwDgUIAAAYBwKEAAAMA4FCAAAGIcCBAAAjEMBAgAAxomwOgDgK0VFRXI6nVbH8Jvq6mpFR0dbHcNvHA6HMjIyrI4BwBAUIISFoqIiDRw4SJWVFVZH8R+bTfJ4rE7hN7Gxcdq/fx8lCEBAUIAQFpxOpyorK3TF7Ytl73Wx1XF8rrjgIxW+vlLZNy9Uj34DrY7jc+7io9r58hI5nU4KEICAoAAhrNh7XazuGQOsjuFz7uKjkqSE1Iyw/P0AINCYBA0AAIxDAQIAAMahAAEAAONQgAAAgHEoQAAAwDh8CgxA0Ni3b5/VEfyGGz0CwYUCBMByla5Tkmy65ZZbrI7iN9zoEQguFCAAlqutKJXk4UaPAAKGAgQgaHCjRwCBwiRoAABgHAoQAAAwDgUIAAAYhwIEAACMQwECAADGoQABAADjUIAAAIBxKEAAAMA4FCAAAGAcChAAADAOBQgAABiHAgQAAIxDAQIAAMahAAEAAONQgAAAgHEoQAAAwDgUIAAAYBwKEAAAMA4FCAAAGIcCBAAAjEMBAgAAxqEAAQAA40RYHQAATLFv3z6rI/iNw+FQRkaG1TGAdqMAAYCfVbpOSbLplltusTqK38TGxmn//n2UIIQMChAA+FltRakkj7JvXqge/QZaHcfn3MVHtfPlJXI6nRQghAwKEAAESEJqhrpnDLA6BgAxCRoAABiIAgQAAIxDAQIAAMahAAEAAONQgAAAgHH4FJhhioqK5HQ6rY7hc+F8gzkAgO9RgAxSVFSkgQMHqbKywuooflNbXWN1BABACKAAGcTpdKqyskJX3L5Y9l4XWx3Hp4oLPlLh6yt17tw5q6MAAEIABchA9l4Xh93N2NzFR62OAAAIIUyCBgAAxqEAAQAA41CAAACAcShAAADAOBQgAABgHD4Fdp5wvVGgxM0CAQBoQAH6DhNuFChxs0AAAChA3xHONwqUuFkgAAANKEAtCMcbBUrcLBAAgAZMggYAAMahAAEAAONQgAAAgHEoQAAAwDgUIAAAYBw+BQYA8Ilwvdmqw+FQRkaG1THgYxQgAECnVLpOSbLplltusTqKX8TGxmn//n2UoDBDAQIAdEptRakkj7JvXqge/QZaHcen3MVHtfPlJXI6nRSgMEMBAgD4REJqRljeRBbhiUnQAADAOBQgAABgHAoQAAAwDgUIAAAYhwIEAACME9KfAvN4PCotLfXZ/srKyiRJp48d0LnqSp/tN1i4i49JklxfHVRkhM3iNL4Vzr+bxO8X6vj9Qpf7RJGkb88PbrfbZ/tNTEyUzRZeYxVqbB6Px2N1CG+53W4lJSVZHQMAgA5xuVyy2+1WxzBaSBcgX18BClVut1vp6ek6fvw4/6D+H2PSHGPSHGPSHGPSlL/GgytA1gvpt8BsNhv/QL/DbrczHudhTJpjTJpjTJpjTJpiPMIPk6ABAIBxKEAAAMA4FKAwEB0drcWLFys6OtrqKEGDMWmOMWmOMWmOMWmK8QhfIT0JGgAAwBtcAQIAAMahAAEAAONQgAAAgHEoQAAAwDgUIAAAYBwKEAAAMA4FCAAAGCekC5DH45Hb7Ra3MgIAhDvOeb4V0gWotLRUSUlJfCM8ACDscc7zrZAuQAAAAN6gAAEAAONQgAAAgHEoQAAAwDgUIAAAYBwKEAAAMA4FCAAAGIcCBAAAjEMBAgAAxqEAAQAA41CAAACAcShAAADAOBQgAABgHAoQAAAwDgUIAAAYx9ICdPHFF8tmszV7zJ4928pY8JGT7irtL3brkyOntf+EWyfdVVZHChmMHQD4V4SVL75r1y7V1dU1/lxYWKjrr79eU6dOtTAVfKHoVLly1xdox6FTjcvG9k/R0slDlJESb2Gy4MfYAYD/WXoFqEePHurZs2fjY+PGjbr00kt11VVXWRkLnXTSXdXsBC5J2w+d0v3rC7ia0QrGDgACw9IrQN9VU1OjNWvWaP78+bLZbC1uU11drerq6saf3W53oOKhA86U1zQ7gTfYfuiUzpTXKM0eE+BUoYGxA9DgQue8/Px8JSQkBDyPw+FQRkZGwF/XX4KmAG3YsEFnz57VrFmzLrjNsmXLtGTJksCFglfcVec6td5kjB2ABhc651n1LklsbJz2798XNiXI5vF4PFaHkKTx48crKipKb7zxxgW3aakNp6eny+VyyW63ByIm2mF/sVs3PPvBBde/NeeHGtiLv1dLGDsADS50zhtxyyJ17zsgoFncxUe18+Ul2r17t4YPHx7Q1/aXoLgCdOzYMb3zzjt67bXXWt0uOjpa0dHRAUoFbyXHR2ls/xRtb+GtnLH9U5QcH2VBqtDA2AFocKFznr1nhrpnBLYAhaOguA/QqlWrlJqaqgkTJlgdBT6QZo/R0slDNLZ/SpPlDZ9kYg7LhTF2ABAYll8Bqq+v16pVqzRz5kxFRFgeBz6SkRKvp27K1pnyGrmrzskeE6Hk+ChO4O3A2AGA/1neON555x0VFRXp9ttvtzoKfCzNHsNJ20uMHQD4l+UFaNy4cQqSedgAAMAQQTEHCAAAIJAoQAAAwDgUIAAAYBwKEAAAMA4FCAAAGIcCBAAAjEMBAgAAxqEAAQAA41CAAACAcShAAADAOBQgAABgHAoQAAAwDgUIAAAYhwIEAACMQwECAADGoQABAADjUIAAAIBxKEAAAMA4FCAAAGAcChAAADAOBQgAABiHAgQAAIxDAQIAAMahAAEAAONQgAAAgHEoQAAAwDgUIAAAYBwKEAAAMA4FCAAAGIcCBAAAjEMBAgAAxqEAAQAA41CAAACAcShAAADAOBQgAABgHAoQAAAwDgUIAAAYhwIEAACMQwECAADGoQABAADjUIAAAIBxKEAAAMA4FCAAAGAcChAAADAOBQgAABiHAgQAAIxDAQIAAMahAAEAAONQgAAAgHEirA4AAADaz3nsC9We8/h8vxEREYqMjmpxnbv4qM9fz2oUIAAAQkjBq8sted3Y2Dg5HA5LXtsfKEAAAISQQTfOkr1XX5/us9xZrMLXV2rNmjUaNGhQi9s4HA5lZGT49HWtRAECACCE9LxslFIzs326z9NFB1T4+koNGjRIw4cP9+m+gxWToAEAgHEoQAAAwDiWF6CvvvpKt9xyi1JSUhQbG6shQ4bo008/tToWEFZOuqu0v9itT46c1v4Tbp10V1kdyXKuihodLinTnqIzOvxNmVwVNVZHAhBAls4BOnPmjK688kpdc801evPNN9WjRw8dPHhQycnJVsYCwkrRqXLlri/QjkOnGpeN7Z+ipZOHKCMl3sJk1vn6bKUWrturDw46G5flZDqUNyVLvbvFWpgMQKBYegXoiSeeUHp6ulatWqVRo0apX79+GjdunC699FIrYwFh46S7qln5kaTth07p/vUFRl4JclXUNCs/krTtoFOL1u3lShBgCEsL0Ouvv66RI0dq6tSpSk1N1bBhw/TCCy9ccPvq6mq53e4mDwAXdqa8pln5abD90CmdKTfvZO8sq2lWfhpsO+iUs8y8MUFw4pznX5YWoC+//FIrVqxQZmamNm3apLvuukv33Xeffv/737e4/bJly5SUlNT4SE9PD3BiILS4q851an04clfVtrq+tI31QKBwzvMvSwtQfX29hg8frqVLl2rYsGH65S9/qTvvvFO/+93vWtw+NzdXLper8XH8+PEAJwZCiz2m9Wl+ba0PR/aYyFbXJ7axHggUznn+ZWkB6tWrlwYPHtxk2aBBg1RUVNTi9tHR0bLb7U0eAC4sOT5KY/untLhubP8UJce3/L0/4cyREKWczJZv55+T6ZAjwbwxQXDinOdflhagK6+8UgcOHGiy7IsvvlDfvr69xTdgqjR7jJZOHtKsBDV8CizNHmNRMuskxUUpb0pWsxKUk+nQE1OylBRHAQJMYOn173nz5mnMmDFaunSpbrrpJn3yySdauXKlVq5caWUsIKxkpMTrqZuydaa8Ru6qc7LHRCg5PsrI8tOgd7dYPTdtmJxlNSqtqlViTKQcCVGUH8Aglhagyy+/XOvXr1dubq4effRR9evXT8uXL9f06dOtjAWEnTR7jNGFpyVJcRQewGSWz4D88Y9/rB//+MdWxwAAAAax/KswAAAAAo0CBAAAjEMBAgAAxqEAAQAA41CAAACAcShAAADAOBQgAABgHAoQAAAwDgUIAAAYhwIEAACMQwECAADGoQABAADjUIAAAIBxKEAAAMA4FCAAAGAcChAAADAOBQgAABiHAgQAAIxDAQIAAMahAAEAAONQgAAAgHEoQAAAwDgUIAAAYBwKEAAAMA4FCAAAGIcCBAAAjEMBAgAAxqEAAQAA41CAAACAcShAAADAOBQgAABgHAoQAAAwDgUIAAAYhwIEAACMQwECAADGoQABAADjUIAAAIBxKEAAAMA4FCAAAGCcCKsDAACA9nMe+0K15zw+3WdZSZEkad++fT7d73c5HA5lZGT4bf8dZfN4PL4dxQByu91KSkqSy+WS3W63Og4AAH7TcM7zH5sk/1WC2Ng47d+/L2hKEFeAAAAIIYNunCV7r74+329kXKJik1J8vl9Jchcf1c6Xl8jpdFKAAABAx/W8bJRSM7OtjhHymAQNAACMQwECAADGoQABAADjUIAAAIBxKEAAAMA4FCAAAGAcChAAADAOBQgAABiHAgQAAIxDAQIAAMahAAEAAONQgAAAgHEsLUCPPPKIbDZbk8fAgQOtjARDnXRXaX+xW58cOa39J9w66a6yOpJPfX22UvuK3dr55SntL3br67OVVkdCO7gqanS4pEx7is7o8DdlclXUWB0JCBuWfxv8ZZddpnfeeafx54gIyyPBMEWnypW7vkA7Dp1qXDa2f4qWTh6ijJR4C5P5xrFT5bq/hd/v8clD1DcMfr9w9fXZSi1ct1cfHHQ2LsvJdChvSpZ6d4u1MBkQHix/CywiIkI9e/ZsfDgcDqsjwSAn3VXNyo8kbT90SvevLwj5K0Ffn61sVn6kb3+/B9YXcCUoSLkqapqVH0nadtCpRev2ciUI8AHLC9DBgwfVu3dvXXLJJZo+fbqKioouuG11dbXcbneTB9AZZ8prmpWDBtsPndKZ8tA+0bgqa1v9/VyVtQFOhPZwltU0Kz8Nth10ylkW2scl2odznn9ZWoCuuOIKrV69Wm+99ZZWrFihI0eO6Ic//KFKS0tb3H7ZsmVKSkpqfKSnpwc4McKNu+pcp9YHO3cbBae0igIUjNxt/F34u5mBc55/WVqAbrzxRk2dOlVZWVkaP368/vKXv+js2bP605/+1OL2ubm5crlcjY/jx48HODHCjT2m9Tlnba0PdvbYyFbXJ8a0vh7WsLfxd+HvZgbOef5l+Vtg39WtWzd973vf06FDh1pcHx0dLbvd3uQBdEZyfJTG9k9pcd3Y/ilKjo8KcCLfSoqNbPX3S2qjIMEajoQo5WS2PB8yJ9MhR0JoH5doH855/hVUBaisrEyHDx9Wr169rI4CQ6TZY7R08pBmJaHhU2Bp9hiLkvlG726xevwCv9/jk4fwaaIglRQXpbwpWc1KUE6mQ09MyVJSHAUI6Cyvru9XVlbK4/EoLi5OknTs2DGtX79egwcP1rhx49q9nwULFmjixInq27evvv76ay1evFhdu3bVtGnTvIkFeCUjJV5P3ZStM+U1cledkz0mQsnxUSFffhr0TYnXv/5sqFyVtSqtqlViTKSSYiMpP0Gud7dYPTdtmJxlNY1/N0dCFOUH8BGvCtBPfvIT/fSnP9WvfvUrnT17VldccYUiIyPldDr19NNP66677mrXfv73f/9X06ZN06lTp9SjRw+NHTtWH3/8sXr06OFNLMBrafaYsCk8LendLZbCE4KS4ig8gL94VYA+++wzPfPMM5KkP//5z0pLS9OePXu0bt06Pfzww+0uQGvXrvXm5QEAADrFqzlAFRUVSkxMlCS9/fbb+ulPf6ouXbroBz/4gY4dO+bTgAAAAL7mVQHq37+/NmzYoOPHj2vTpk2N835KSkqYpQ4AAIKeVwXo4Ycf1oIFC3TxxRfriiuu0OjRoyV9ezVo2LBhPg0IAADga17NAfrZz36msWPHqri4WEOHDm1cfu2112ry5Mk+CwcAAOAPXt/mtuHLS79r1KhRnQ4EAADgb14VoMmTJ8tmszVbbrPZFBMTo/79++vmm2/WgAEDOh0QAADA17yaA5SUlKT33ntPn332mWw2m2w2m/bs2aP33ntP586d03//939r6NCh2rFjh6/zAgAAdJpXV4B69uypm2++Wb/97W/Vpcu3Haq+vl5z5sxRYmKi1q5dq1/96ldauHChtm/f7tPAAAAAneXVFaCXXnpJc+fObSw/ktSlSxfde++9WrlypWw2m+655x4VFhb6LCgAAICveFWAzp07p/379zdbvn//ftXV1UmSYmJiWpwnBAAAYDWv3gK79dZbdccdd+j+++/X5ZdfLknatWuXli5dqhkzZkiStm7dqssuu8x3SQEAAHzEqwL0zDPPKC0tTf/6r/+qkydPSpLS0tI0b948LVy4UJI0btw43XDDDb5LCgAA4CNeFaCuXbvqgQce0AMPPCC32y1Jzb4CIyMjo/PpAAAA/MDrGyE24Lu/AABAqPFqEvTJkyd16623qnfv3oqIiFDXrl2bPAAAAIKZV1eAZs2apaKiIj300EPq1asXn/YCAAAhxasCtH37dn3wwQfKzs72cRwAAAD/8+otsPT0dHk8Hl9nAQAACAivCtDy5cu1aNEiHT161MdxAAAA/M+rt8D+8R//URUVFbr00ksVFxenyMjIJutPnz7tk3AAAAD+4FUBWr58uY9jAAAABI5XBWjmzJm+zgEAABAw7S5Abre78aaHDXd/vhBujggAAIJZuwtQcnKyiouLlZqaqm7durV47x+PxyObzdb4jfAAAADBqN0F6L333lP37t0lSe+//77fAgEAAPhbuwvQVVdd1fjf/fr1U3p6erOrQB6PR8ePH/ddOgAAAD/w6j5A/fr10zfffNNs+enTp9WvX79OhwIAAPAnrwpQw1yf85WVlSkmJqbToQAAAPypQx+Dnz9/viTJZrPpoYceUlxcXOO6uro67dy5k+8HAwAAQa9DBWjPnj2Svr0CVFBQoKioqMZ1UVFRGjp0qBYsWODbhAAAAD7WoQLU8Omv2267Tc8++yz3+wEAIMCcx75Q7bnQ+kLyspIiSdK+ffv8sn+Hw6GMjIwOPcfmCeGvdXe73UpKSpLL5aKMAQDCWsM5L3TZJPmncsTGxmn//n0dKkFefRWGJH366af605/+pKKiItXU1DRZ99prr3m7WwAA0IpBN86SvVdfq2N0WGRcomKTUny+X3fxUe18eYmcTqf/C9DatWs1Y8YMjR8/Xm+//bbGjRunL774QidPntTkyZO92SUAAGiHnpeNUmpmttUxQp5XH4NfunSpnnnmGb3xxhuKiorSs88+q/379+umm27q8HtwAAAAgeZVATp8+LAmTJgg6dtPf5WXl8tms2nevHlauXKlTwMCAAD4mlcFKDk5WaWlpZKkPn36qLCwUJJ09uxZVVRU+C4dAACAH3g1BygnJ0ebN2/WkCFDNHXqVM2ZM0fvvfeeNm/erGuvvdbXGQEAAHzKqwL029/+VlVVVZKkBx54QJGRkfrwww81ZcoUPfjggz4NCAAA4GsdLkDnzp3Txo0bNX78eElSly5dtGjRIp8HAwAA8JcOzwGKiIjQr371q8YrQAAAAKHGq0nQo0aNUn5+vo+jAAAABIZXc4DuvvtuzZ8/X8ePH9eIESMUHx/fZH1WVpZPwgEAAPiDVwXo5z//uSTpvvvua1xms9nk8Xhks9lUV1fnm3QAAAB+4FUBOnLkiK9zAAAABIxXBahv3/Z9CduECRP04osvqlevXt68DAAAgF94NQm6vbZt26bKykp/vgQAAECH+bUAAQAABCMKEAAAMA4FCAAAGIcCBAAAjEMBAgAAxml3ARo+fLjOnDkjSXr00UdVUVHR5nPuv/9+de/e3ft0AAAAftDuArRv3z6Vl5dLkpYsWaKysrI2n5Obm6tu3bp5HQ4AAMAf2n0jxOzsbN12220aO3asPB6PnnzySSUkJLS47cMPP+yzgAAAAL7W7gK0evVqLV68WBs3bpTNZtObb76piIjmT7fZbF4XoLy8POXm5mrOnDlavny5V/swjauiRs6yGrmramWPjZQjPkpJcVFWx7JUsIxJsOQItizB4qS7SmfKa+SuOid7bISS46KUZo8JeI5g+tsEU5ZgwHiEt3YXoAEDBmjt2rWSpC5duujdd99Vamqqz4Ls2rVLzz//PN8k3wFfn63UwnV79cFBZ+OynEyH8qZkqXe3WAuTWSdYxiRYcgRblmBRdKpcuesLtOPQqcZlY/unaOnkIcpIiQ9YjmD62wRTlmDAeIQ/rz4FVl9f79PyU1ZWpunTp+uFF15QcnKyz/YbzlwVNc3+cUrStoNOLVq3V66KGouSWSdYxiRYcgRblmBx0l3VrPxI0vZDp3T/+gKddFcFJEcw/W2CKUswYDzM4PXH4A8fPqx7771X1113na677jrdd999Onz4sFf7mj17tiZMmKDrrruu1e2qq6vldrubPEzlLKtp9o+zwbaDTjnLzPsHGixjEiw5gi1LsDhTXtOs/DTYfuiUzpRznFiZJRgEy3hwzvMvrwrQpk2bNHjwYH3yySfKyspSVlaWdu7cqcsuu0ybN2/u0L7Wrl2rzz77TMuWLWtz22XLlikpKanxkZ6e7k38sOCuqm11fWkb68NRsIxJsOSQgitLsHBXnevUet/lCJ6/TTBlCQbBMh6c8/zLqwK0aNEizZs3Tzt37tTTTz+tp59+Wjt37tTcuXO1cOHCdu/n+PHjmjNnjv74xz8qJqbtyYe5ublyuVyNj+PHj3sTPyzYYyJbXZ/YxvpwFCxjEiw5pODKEizsMa1PfWxrve9yBM/fJpiyBINgGQ/Oef7lVQHat2+f7rjjjmbLb7/9dv3tb39r9352796tkpISDR8+XBEREYqIiNDWrVv1m9/8RhEREaqrq2uyfXR0tOx2e5OHqRwJUcrJdLS4LifTIUeCeZ9UCJYxCZYcwZYlWCTHR2ls/5QW143tn6LkeI4TK7MEg2AZD855/uVVAerRo4fy8/ObLc/Pz+/Q5Ohrr71WBQUFys/Pb3yMHDlS06dPV35+vrp27epNPCMkxUUpb0pWs3+kOZkOPTEly8iPagbLmARLjmDLEizS7DFaOnlIsxLU8CmwQH0UPpj+NsGUJRgwHmbw6lrvnXfeqV/+8pf68ssvNWbMGEnSjh079MQTT2j+/Pnt3k9iYqK+//3vN1kWHx+vlJSUZsvRXO9usXpu2jA5y2pUWlWrxJhIORLMvk9FsIxJsOQItizBIiMlXk/dlP33+wDFRCg5PvD3AQqmv00wZQkGjEf486oAPfTQQ0pMTNRTTz2l3NxcSVLv3r31yCOP6L777vNpQLQuKY5/kOcLljEJlhxScGUJFmn2GEtufHi+YPrbBFOWYMB4hDevCpDNZtO8efM0b948lZaWSvr2as75duzYoZEjRyo6Orrd+96yZYs3kQAAANrN6/sANUhMTGyx/EjSjTfeqK+++qqzLwEAAOBTnS5ArfF4PP7cPQAAgFf8WoAAAACCEQUIAAAYhwIEAACM49cCZLPZ/Ll7AAAAr3S4AHk8HhUVFamqqqpd2wIAAAQbrwpQ//792/WlbKWlpbrkkku8CgYAAOAvHS5AXbp0UWZmpk6dOuWPPAAAAH7n1RygvLw8/fM//7MKCwt9nQcAAMDvvPoqjBkzZqiiokJDhw5VVFSUYmNjm6w/ffq0T8IBAAD4g1cFaPny5T6OAQAAEDheFaCZM2f6OgcAAEDAeH0foMOHD+vBBx/UtGnTVFJSIkl688039fnnn/ssHAAAgD94VYC2bt2qIUOGaOfOnXrttddUVlYmSfrrX/+qxYsX+zQgAACAr3lVgBYtWqR/+Zd/0ebNmxUVFdW4/Ec/+pE+/vhjn4UDAADwB68KUEFBgSZPntxseWpqqpxOZ6dDAQAA+JNXBahbt24qLi5utnzPnj3q06dPp0MBAAD4k1cF6Oc//7kWLlyoEydOyGazqb6+Xjt27NCCBQs0Y8YMX2cEAADwKa8K0NKlSzVw4EClp6errKxMgwcPVk5OjsaMGaMHH3zQ1xkBAAB8yqv7AEVFRemFF17QQw89pMLCQpWVlWnYsGHKzMz0dT4AAACf86oANcjIyFB6erokyWaz+SQQAAC4MOexL1R7zmN1DJ+LiIhQZHRU2xuex1181LvX8+pZkl566SU988wzOnjwoCQpMzNTc+fO1S9+8QtvdwkAANpQ8OpyqyMEndjYODkcjg49x6sC9PDDD+vpp5/Wvffeq9GjR0uSPvroI82bN09FRUV69NFHvdktAABow6AbZ8neq6/VMXyq3FmswtdXas2aNRo0aFCHn+9wOJSRkdGh59g8Hk+Hr6P16NFDv/nNbzRt2rQmy//rv/5L9957b8DuBeR2u5WUlCSXyyW73R6Q1wQAwAoN57xrFvyHUjOzrY7jU6eLDmjz47dp9+7dGj58eEBe06tPgdXW1mrkyJHNlo8YMULnzp3rdCgAAAB/8qoA3XrrrVqxYkWz5StXrtT06dM7HQoAAMCf2j0HaP78+Y3/bbPZ9OKLL+rtt9/WD37wA0nSzp07VVRUxI0QAQBA0Gt3AdqzZ0+Tn0eMGCFJOnz4sKRvJyA5HA59/vnnPowHAADge+0uQO+//74/cwAAAASMV3OAAAAAQplX9wGqqqrSc889p/fff18lJSWqr69vsv6zzz7zSTgAAAB/8KoA3XHHHXr77bf1s5/9TKNGjeJrMAAAQEjxqgBt3LhRf/nLX3TllVf6Og8AAIDfeTUHqE+fPkpMTPR1FgAAgIDwqgA99dRTWrhwoY4dO+brPAAAAH7n1VtgI0eOVFVVlS655BLFxcUpMjKyyfrTp0/7JBwAAIA/eFWApk2bpq+++kpLly5VWloak6ABAEBI8aoAffjhh/roo480dOhQX+cBAADwO6/mAA0cOFCVlZW+zgIAABAQXhWgvLw8/frXv9aWLVt06tQpud3uJg8AAIBg5tVbYDfccIMk6dprr22y3OPxyGazqa6urvPJAAAA/MSrAsQXowIAgFDmVQG66qqrfJ0DAAAgYLwqQNu2bWt1fU5OjldhAAAAAsGrAnT11Vc3W/bdewExBwgAAAQzrz4FdubMmSaPkpISvfXWW7r88sv19ttv+zojAACAT3l1BSgpKanZsuuvv15RUVGaP3++du/e3elgAAAA/uLVFaALSUtL04EDB3y5SwAAAJ/z6grQ3r17m/zs8XhUXFysvLw8ZWdn+yIXAACA33hVgLKzs2Wz2eTxeJos/8EPfqCXX37ZJ8EAAAD8xasCdOTIkSY/d+nSRT169FBMTIxPQgEAAPiTVwWob9++evfdd/Xuu++qpKRE9fX1TdZzFQgAAAQzrwrQkiVL9Oijj2rkyJHq1atXk3sAAQAABDuvCtDvfvc7rV69Wrfeequv8wAAAPidVx+Dr6mp0ZgxYzr94itWrFBWVpbsdrvsdrtGjx6tN998s9P7BQAAaI1XV4B+8Ytf6JVXXtFDDz3UqRe/6KKLlJeXp8zMTHk8Hv3+97/XT37yE+3Zs0eXXXZZp/bdUa6KGjnLauSuqpU9NlKO+CglxUUFNINJQnW8QzV3qDrprtKZ8hq5q87JHhuh5LgopdmD/8MWoZobMIlXBaiqqkorV67UO++8o6ysLEVGRjZZ//TTT7drPxMnTmzy8+OPP64VK1bo448/DmgB+vpspRau26sPDjobl+VkOpQ3JUu9u8UGLIcpQnW8QzV3qCo6Va7c9QXacehU47Kx/VO0dPIQZaTEW5isdaGaGzCNV2+B7d27V9nZ2erSpYsKCwu1Z8+exkd+fr5XQerq6rR27VqVl5dr9OjRXu3DG66KmmYnNUnadtCpRev2ylVRE7AsJgjV8Q7V3KHqpLuqWYmQpO2HTun+9QU66a6yKFnrQjU3YCKvrgC9//77PgtQUFCg0aNHq6qqSgkJCVq/fr0GDx7c4rbV1dWqrq5u/Nntdnf69Z1lNc1Oag22HXTKWVbDWxw+FKrjHaq5Q9WZ8ppmJaLB9kOndKa8JijfUgrV3AhO/jjn4e98+l1g3hgwYIDy8/O1c+dO3XXXXZo5c6b+9re/tbjtsmXLlJSU1PhIT0/v9Ou7q2pbXV/axnp0TKiOd6jmDlXuqnOdWm+VUM2N4OSPcx7+zvICFBUVpf79+2vEiBFatmyZhg4dqmeffbbFbXNzc+VyuRofx48f7/Tr22MiW12f2MZ6dEyojneo5g5V9pjWL063td4qoZobwckf5zz8neUF6Hz19fVNLvl9V3R0dONH5hseneVIiFJOpqPFdTmZDjkSeFvDl0J1vEM1d6hKjo/S2P4pLa4b2z9FyfHBOd6hmhvByR/nPPydpQUoNzdX27Zt09GjR1VQUKDc3Fxt2bJF06dPD1iGpLgo5U3JanZyy8l06IkpWczr8LFQHe9QzR2q0uwxWjp5SLMy0fBpqmCdRxOquQETWXo9tqSkRDNmzFBxcbGSkpKUlZWlTZs26frrrw9ojt7dYvXctGFyltWotKpWiTGRciRwfxd/CdXxDtXcoSojJV5P3ZT99/vpxEQoOT7476cTqrkB01hagF566SUrX76JpDhOZIEUquMdqrlDVZo9JiSLQ6jmBkwSdHOAAAAA/I0CBAAAjEMBAgAAxqEAAQAA41CAAACAcShAAADAOBQgAABgHAoQAAAwDgUIAAAYhwIEAACMQwECAADGsfS7wAAAQMc4j32h2nOeDj8vIiJCkdHB+V2G7uKjAX9NChAAACGk4NXlVkfwi9jYODkcjoC9HgUIAIAQMujGWbL36tuh55Q7i1X4+kqtWbNGgwYN8lOyznE4HMrIyAjY61GAAAAIIT0vG6XUzOwOPed00QEVvr5SgwYN0vDhw/0TLMQwCRoAABiHAgQAAIxDAQIAAMahAAEAAONQgAAAgHEoQAAAwDgUIAAAYBwKEAAAMA4FCAAAGIcCBAAAjEMBAgAAxqEAAQAA41CAAACAcShAAADAOBQgAABgHAoQAAAwDgUIAAAYhwIEAACMQwECAADGoQABAADjUIAAAIBxKEAAAMA4FCAAAGAcChAAADAOBQgAABiHAgQAAIxDAQIAAMahAAEAAONQgAAAgHEoQAAAwDgUIAAAYBwKEAAAMA4FCAAAGIcCBAAAjEMBAgAAxqEAAQAA41CAAACAcShAAADAOBQgAABgHAoQAAAwjqUFaNmyZbr88suVmJio1NRUTZo0SQcOHLAyEgAAMIClBWjr1q2aPXu2Pv74Y23evFm1tbUaN26cysvLrYyFEOeqqNHhkjLtKTqjw9+UyVVRY3UkyzEmANBUhJUv/tZbbzX5efXq1UpNTdXu3buVk5NjUSqEsq/PVmrhur364KCzcVlOpkN5U7LUu1ushcmsw5gAQHNBNQfI5XJJkrp3725xEoQiV0VNsxO9JG076NSidXuNvOrBmABAyyy9AvRd9fX1mjt3rq688kp9//vfb3Gb6upqVVdXN/7sdrsDFQ8hwFlW0+xE32DbQaecZTVKiosKcCprMSZA6OKc519BcwVo9uzZKiws1Nq1ay+4zbJly5SUlNT4SE9PD2BCBDt3VW2r60vbWB+OGBMgdHHO86+gKED33HOPNm7cqPfff18XXXTRBbfLzc2Vy+VqfBw/fjyAKRHs7DGRra5PbGN9OGJMgNDFOc+/LH0LzOPx6N5779X69eu1ZcsW9evXr9Xto6OjFR0dHaB0CDWOhCjlZDq0rYW3fHIyHXIkmPdWD2MChC7Oef5l6RWg2bNna82aNXrllVeUmJioEydO6MSJE6qsrLQyFkJUUlyU8qZkKSfT0WR5TqZDT0zJMnKuC2MCAC2z9ArQihUrJElXX311k+WrVq3SrFmzAh8IIa93t1g9N22YnGU1Kq2qVWJMpBwJUUaf6BkTAGjO8rfAAF9LiuPkfj7GBACaCopJ0AAAAIFEAQIAAMYJmhshAgCAtjmPfaHacx2bQlJWUuSnNKGLAgQAQAgpeHW5d0+02ZrcWdp0FCAAAELIoBtnyd6rb4eeU+4sVuHrK7mv0HdQgAAACCE9Lxul1MzsDj3ndNEBFb6+0j+BQhSToAEAgHEoQAAAwDgUIAAAYBwKEAAAMA4FCAAAGIcCBAAAjEMBAgAAxqEAAQAA41CAAACAcShAAADAOBQgAABgHAoQAAAwDgUIAAAYhwIEAACMQwECAADGoQABAADjUIAAAIBxKEAAAMA4FCAAAGAcChAAADAOBQgAABiHAgQAAIxDAQIAAMahAAEAAONQgAAAgHEoQAAAwDgUIAAAYBwKEAAAMA4FCAAAGIcCBAAAjEMBAgAAxqEAAQAA41CAAACAcShAAADAOBQgAABgHAoQAAAwDgUIAAAYhwIEAACMQwECAADGoQABAADjUIAAAIBxKEAAAMA4FCAAAGAcChAAADAOBQgAABiHAgQAAIxDAQIAAMahAAEAAONQgAAAgHEsLUDbtm3TxIkT1bt3b9lsNm3YsMHKOAAAwBCWFqDy8nINHTpU//7v/25lDCDsuSpqdLikTHuKzujwN2VyVdRYHQlBiOMEJomw8sVvvPFG3XjjjVZGAMLe12crtXDdXn1w0Nm4LCfTobwpWerdLdbCZAgmHCcwDXOAgDDmqqhpdlKTpG0HnVq0bi//Dx+SOE5gJkuvAHVUdXW1qqurG392u90WpgGCn7OsptlJrcG2g045y2qUFBcV4FQINhwnwelC5zz3iSJFRHfsqpy7+Kgvo4WFkCpAy5Yt05IlS6yOAYQMd1Vtq+tL21gPM3CcBKcLnfN2r8nzan+xsXFyOBydjRU2QqoA5ebmav78+Y0/u91upaenW5gICG72mMhW1ye2sR5m4DgJThc6523dulUJCQkd3p/D4VBGRoYvI4a0kCpA0dHRio6OtjoGEDIcCVHKyXRoWwtvb+RkOuRI4G0NcJwEqwud87Kzs2W32y1IFF4snQRdVlam/Px85efnS5KOHDmi/Px8FRUVWRkLCBtJcVHKm5KlnMyml71zMh16YkoW8zogieMEZrJ5PB6PVS++ZcsWXXPNNc2Wz5w5U6tXr27z+W63W0lJSXK5XLRhoBWuiho5y2pUWlWrxJhIORKiOKmhGY6T4MY5z7csfQvs6quvloX9CzBGUhwnMrSN4wQm4T5AAADAOBQgAABgHAoQAAAwDgUIAAAYhwIEAACMQwECAADGoQABAADjUIAAAIBxKEAAAMA4FCAAAGAcChAAADAOBQgAABiHAgQAAIxj6bfBd1bDN8m73W6LkwAA0H6JiYmy2WxWxzBaSBeg0tJSSVJ6errFSQAAaD+XyyW73W51DKPZPA2XUUJQfX29vv76a+ObtNvtVnp6uo4fP84/qP/HmDTHmDTHmDTHmDTlr/Hw5rzl8XhUWlpq/DnPV0L6ClCXLl100UUXWR0jaNjtdv4H6zyMSXOMSXOMSXOMSVPBMB42m83yDOGESdAAAMA4FCAAAGAcClAYiI6O1uLFixUdHW11lKDBmDTHmDTHmDTHmDTFeISvkJ4EDQAA4A2uAAEAAONQgAAAgHEoQAAAwDgUoCC3bNkyXX755UpMTFRqaqomTZqkAwcOtPm8V199VQMHDlRMTIyGDBmiv/zlLwFIGxjejMnq1atls9maPGJiYgKU2P9WrFihrKysxnuVjB49Wm+++WarzwnnY0Tq+JiE+zFyvry8PNlsNs2dO7fV7cL9OPmu9oyJacdJOKMABbmtW7dq9uzZ+vjjj7V582bV1tZq3LhxKi8vv+BzPvzwQ02bNk133HGH9uzZo0mTJmnSpEkqLCwMYHL/8WZMpG9vZFZcXNz4OHbsWIAS+99FF12kvLw87d69W59++ql+9KMf6Sc/+Yk+//zzFrcP92NE6viYSOF9jHzXrl279PzzzysrK6vV7Uw4Thq0d0wkc46TsOdBSCkpKfFI8mzduvWC29x0002eCRMmNFl2xRVXeP7pn/7J3/Es0Z4xWbVqlScpKSlwoYJAcnKy58UXX2xxnWnHSIPWxsSUY6S0tNSTmZnp2bx5s+eqq67yzJkz54LbmnKcdGRMTDlOTMAVoBDjcrkkSd27d7/gNh999JGuu+66JsvGjx+vjz76yK/ZrNKeMZGksrIy9e3bV+np6W1eCQhldXV1Wrt2rcrLyzV69OgWtzHtGGnPmEhmHCOzZ8/WhAkTmv39W2LKcdKRMZHMOE5MENLfBWaa+vp6zZ07V1deeaW+//3vX3C7EydOKC0trcmytLQ0nThxwt8RA669YzJgwAC9/PLLysrKksvl0pNPPqkxY8bo888/D5vvkysoKNDo0aNVVVWlhIQErV+/XoMHD25xW1OOkY6MiQnHyNq1a/XZZ59p165d7drehOOko2NiwnFiCgpQCJk9e7YKCwu1fft2q6MEjfaOyejRo5v8P/8xY8Zo0KBBev755/XYY4/5O2ZADBgwQPn5+XK5XPrzn/+smTNnauvWrRc84ZugI2MS7sfI8ePHNWfOHG3evJlJu//PmzEJ9+PEJBSgEHHPPfdo48aN2rZtW5v/L6Nnz546efJkk2UnT55Uz549/Rkx4DoyJueLjIzUsGHDdOjQIT+lC7yoqCj1799fkjRixAjt2rVLzz77rJ5//vlm25pyjHRkTM4XbsfI7t27VVJSouHDhzcuq6ur07Zt2/Tb3/5W1dXV6tq1a5PnhPtx4s2YnC/cjhOTMAcoyHk8Ht1zzz1av3693nvvPfXr16/N54wePVrvvvtuk2WbN29ude5DKPFmTM5XV1engoIC9erVyw8Jg0N9fb2qq6tbXBfux8iFtDYm5wu3Y+Taa69VQUGB8vPzGx8jR47U9OnTlZ+f3+KJPtyPE2/G5HzhdpwYxepZ2GjdXXfd5UlKSvJs2bLFU1xc3PioqKho3ObWW2/1LFq0qPHnHTt2eCIiIjxPPvmkZ9++fZ7Fixd7IiMjPQUFBVb8Cj7nzZgsWbLEs2nTJs/hw4c9u3fv9vz85z/3xMTEeD7//HMrfgWfW7RokWfr1q2eI0eOePbu3etZtGiRx2azed5++22Px2PeMeLxdHxMwv0Yacn5n3gy8Tg5X1tjYuJxEq54CyzIrVixQpJ09dVXN1m+atUqzZo1S5JUVFSkLl3+fjFvzJgxeuWVV/Tggw/q/vvvV2ZmpjZs2NDqJOFQ4s2YnDlzRnfeeadOnDih5ORkjRgxQh9++GHYzI8pKSnRjBkzVFxcrKSkJGVlZWnTpk26/vrrJZl3jEgdH5NwP0baw8TjpC0cJ+GLb4MHAADGYQ4QAAAwDgUIAAAYhwIEAACMQwECAADGoQABAADjUIAAAIBxKEAAAMA4FCAAAGAcChAAv7r66qs1d+5cq2MAQBPcCRqAT2zZskXXXHONzpw5o27dujUuP336tCIjI5WYmGhdOAA4D98FBhikrq5ONputyXcbtaWmpkZRUVFev2b37t29fi4A+AtvgQEWu/jii7V8+fImy7Kzs/XII4/I4/HokUceUUZGhqKjo9W7d2/dd999jdtVV1drwYIF6tOnj+Lj43XFFVdoy5YtjetXr16tbt266fXXX9fgwYMVHR2toqKiVvPMmjVLkyZN0uOPP67evXtrwIABkqQ//OEPGjlypBITE9WzZ0/dfPPNKikpkSQdPXpU11xzjSQpOTlZNput8Ytpz38L7OKLL9bSpUt1++23KzExURkZGVq5cmWTDB9++KGys7MVExOjkSNHasOGDbLZbMrPz+/AyALAhVGAgCC2bt06PfPMM3r++ed18OBBbdiwQUOGDGlcf8899+ijjz7S2rVrtXfvXk2dOlU33HCDDh482LhNRUWFnnjiCb344ov6/PPPlZqa2ubrvvvuuzpw4IA2b96sjRs3SpJqa2v12GOP6a9//as2bNigo0ePNpac9PR0rVu3TpJ04MABFRcX69lnn73g/p966imNHDlSe/bs0d1336277rpLBw4ckCS53W5NnDhRQ4YM0WeffabHHntMCxcu7PDYAUBreAsMCGJFRUXq2bOnrrvuOkVGRiojI0OjRo1qXLdq1SoVFRWpd+/ekqQFCxborbfe0qpVq7R06VJJ3xaX//iP/9DQoUPb/brx8fF68cUXm7z1dfvttzf+9yWXXKLf/OY3uvzyy1VWVqaEhITGt7pSU1ObzAFqyT/8wz/o7rvvliQtXLhQzzzzjN5//30NGDBAr7zyimw2m1544QXFxMRo8ODB+uqrr3TnnXe2Oz8AtIUrQEAQmzp1qiorK3XJJZfozjvv1Pr163Xu3DlJUkFBgerq6vS9731PCQkJjY+tW7fq8OHDjfuIiopSVlZWh153yJAhzeb97N69WxMnTlRGRoYSExN11VVXSVKbb6m15Lt5bDabevbs2fh22oEDB5SVlaWYmJjGbRpKHwD4CleAAIt16dJF538Ys7a2VtK3by0dOHBA77zzjjZv3qy7775b//Zv/6atW7eqrKxMXbt21e7du9W1a9cmz09ISGj879jYWNlstg5lio+Pb/JzeXm5xo8fr/Hjx+uPf/yjevTooaKiIo0fP141NTUd2rckRUZGNvnZZrOpvr6+w/sBAG9RgACL9ejRQ8XFxY0/u91uHTlypPHn2NhYTZw4URMnTtTs2bM1cOBAFRQUaNiwYaqrq1NJSYl++MMf+jXj/v37derUKeXl5Sk9PV2S9OmnnzbZpuGKUV1dXadea8CAAVqzZo2qq6sVHR0tSdq1a1en9gkA5+MtMMBiP/rRj/SHP/xBH3zwgQoKCjRz5szGKzqrV6/WSy+9pMLCQn355Zdas2aNYmNj1bdvX33ve9/T9OnTNWPGDL322ms6cuSIPvnkEy1btkz/8z//49OMGRkZioqK0nPPPacvv/xSr7/+uh577LEm2/Tt21c2m00bN27UN998o7KyMq9e6+abb1Z9fb1++ctfat++fdq0aZOefPJJSerwlSwAuBAKEGCx3NxcXXXVVfrxj3+sCRMmaNKkSbr00kslSd26ddMLL7ygK6+8UllZWXrnnXf0xhtvKCUlRZK0atUqzZgxQ7/+9a81YMAATZo0Sbt27VJGRoZPM/bo0UOrV6/Wq6++qsGDBysvL6+xlDTo06ePlixZokWLFiktLU333HOPV69lt9v1xhtvKD8/X9nZ2XrggQf08MMPS1KTeUEA0BncCRpA0PvjH/+o2267TS6XS7GxsVbHARAGmAMEIOj853/+py655BL16dNHf/3rX7Vw4ULddNNNlB8APkMBAgzz3U+Ine/NN9/0+4Tq9jhx4oQefvhhnThxQr169dLUqVP1+OOPWx0LQBjhLTDAMIcOHbrguj59+nCVBYARKEAAAMA4fAoMAAAYhwIEAACMQwECAADGoQABAADjUIAAAIBxKEAAAMA4FCAAAGAcChAAADDO/wFHEzQ8P7kqVQAAAABJRU5ErkJggg==",
      "text/plain": [
       "<Figure size 600x600 with 3 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# plotting the joinplot to show the distribution of ratings and most ratring scores\n",
    "import matplotlib.pyplot as plt\n",
    "\n",
    "%matplotlib inline\n",
    "\n",
    "import seaborn as sns\n",
    "\n",
    "sns.jointplot(x = 'user_rating', y = 'number_of_ratings', data = ratings)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 110,
   "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>title</th>\n",
       "      <th>(500) Days of Summer</th>\n",
       "      <th>10,000 B.C.</th>\n",
       "      <th>12 Rounds</th>\n",
       "      <th>127 Hours</th>\n",
       "      <th>17 Again</th>\n",
       "      <th>27 Dresses</th>\n",
       "      <th>30 Days of Night</th>\n",
       "      <th>30 Minutes or Less</th>\n",
       "      <th>50/50</th>\n",
       "      <th>88 Minutes</th>\n",
       "      <th>...</th>\n",
       "      <th>Amelia</th>\n",
       "      <th>American Gangster</th>\n",
       "      <th>An Education</th>\n",
       "      <th>Anonymous</th>\n",
       "      <th>Apollo 18</th>\n",
       "      <th>Appaloosa</th>\n",
       "      <th>Armored</th>\n",
       "      <th>Arthur</th>\n",
       "      <th>Australia</th>\n",
       "      <th>Avatar</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>user_id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 33 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "title    (500) Days of Summer   10,000 B.C.  12 Rounds   127 Hours  17 Again   \\\n",
       "user_id                                                                         \n",
       "1                          1.0          NaN         5.0        4.0        NaN   \n",
       "2                          2.0          NaN         1.0        NaN        3.0   \n",
       "3                          1.0          NaN         NaN        4.0        3.0   \n",
       "4                          3.0          NaN         4.0        NaN        2.0   \n",
       "5                          3.0          NaN         NaN        4.0        NaN   \n",
       "6                          NaN          3.0         3.0        NaN        NaN   \n",
       "7                          NaN          NaN         2.0        NaN        1.0   \n",
       "8                          3.0          NaN         NaN        2.0        NaN   \n",
       "9                          3.0          NaN         NaN        NaN        NaN   \n",
       "10                         NaN          NaN         NaN        NaN        4.0   \n",
       "\n",
       "title    27 Dresses  30 Days of Night  30 Minutes or Less  50/50  88 Minutes  \\\n",
       "user_id                                                                        \n",
       "1               NaN               2.0                 NaN    4.0         5.0   \n",
       "2               NaN               NaN                 4.0    NaN         5.0   \n",
       "3               2.0               NaN                 3.0    NaN         2.0   \n",
       "4               NaN               NaN                 NaN    3.0         NaN   \n",
       "5               3.0               NaN                 NaN    3.0         NaN   \n",
       "6               NaN               4.0                 NaN    4.0         NaN   \n",
       "7               NaN               NaN                 NaN    NaN         4.0   \n",
       "8               NaN               3.0                 NaN    NaN         4.0   \n",
       "9               NaN               1.0                 NaN    1.0         1.0   \n",
       "10              NaN               NaN                 4.0    NaN         NaN   \n",
       "\n",
       "title    ...  Amelia   American Gangster  An Education  Anonymous  Apollo 18  \\\n",
       "user_id  ...                                                                   \n",
       "1        ...      NaN                2.0           1.0        NaN        4.0   \n",
       "2        ...      NaN                3.0           2.0        NaN        3.0   \n",
       "3        ...      NaN                NaN           4.0        NaN        NaN   \n",
       "4        ...      NaN                NaN           NaN        5.0        NaN   \n",
       "5        ...      NaN                1.0           2.0        1.0        1.0   \n",
       "6        ...      NaN                4.0           NaN        4.0        NaN   \n",
       "7        ...      NaN                NaN           1.0        NaN        NaN   \n",
       "8        ...      4.0                NaN           2.0        NaN        NaN   \n",
       "9        ...      NaN                3.0           4.0        NaN        NaN   \n",
       "10       ...      NaN                5.0           NaN        NaN        4.0   \n",
       "\n",
       "title    Appaloosa  Armored   Arthur  Australia  Avatar   \n",
       "user_id                                                   \n",
       "1              NaN       2.0     NaN        3.0      NaN  \n",
       "2              NaN       4.0     NaN        2.0      4.0  \n",
       "3              5.0       NaN     NaN        1.0      NaN  \n",
       "4              NaN       1.0     NaN        NaN      NaN  \n",
       "5              NaN       NaN     NaN        3.0      NaN  \n",
       "6              NaN       NaN     4.0        4.0      NaN  \n",
       "7              NaN       4.0     NaN        NaN      3.0  \n",
       "8              1.0       NaN     3.0        NaN      NaN  \n",
       "9              NaN       NaN     5.0        NaN      5.0  \n",
       "10             NaN       NaN     3.0        NaN      4.0  \n",
       "\n",
       "[10 rows x 33 columns]"
      ]
     },
     "execution_count": 110,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# creating the user-time interaction matrix \n",
    "# from it we can later create corelations to get our recomendations\n",
    "\n",
    "data_matrix = df.pivot_table(index='user_id', columns='title', values='user_rating')\n",
    "data_matrix.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 111,
   "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>user_rating</th>\n",
       "      <th>number_of_ratings</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>title</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Aliens in the Attic</th>\n",
       "      <td>4.500000</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Avatar</th>\n",
       "      <td>4.000000</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Amelia</th>\n",
       "      <td>4.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Adventureland</th>\n",
       "      <td>3.800000</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Arthur</th>\n",
       "      <td>3.750000</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30 Minutes or Less</th>\n",
       "      <td>3.666667</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>A Very Harold and Kumar Christmas</th>\n",
       "      <td>3.666667</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Abduction</th>\n",
       "      <td>3.500000</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88 Minutes</th>\n",
       "      <td>3.500000</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127 Hours</th>\n",
       "      <td>3.500000</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                   user_rating  number_of_ratings\n",
       "title                                                            \n",
       "Aliens in the Attic                   4.500000                  4\n",
       "Avatar                                4.000000                  4\n",
       "Amelia                                4.000000                  1\n",
       "Adventureland                         3.800000                  5\n",
       "Arthur                                3.750000                  4\n",
       "30 Minutes or Less                    3.666667                  3\n",
       "A Very Harold and Kumar Christmas     3.666667                  3\n",
       "Abduction                             3.500000                  4\n",
       "88 Minutes                            3.500000                  6\n",
       "127 Hours                             3.500000                  4"
      ]
     },
     "execution_count": 111,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# most rated movies list\n",
    "# ratings.sort_values('number_of_ratings', ascending=False).head(10)\n",
    "ratings.sort_values('user_rating', ascending=False).head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 112,
   "metadata": {},
   "outputs": [],
   "source": [
    "# fetch ratings for first in list (Aliens in the Attic)\n",
    "# we would like to recommend similar movies to our users that watched it\n",
    "\n",
    "aliens_user_ratings = data_matrix['Aliens in the Attic']\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 113,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "user_id\n",
       "1     4.0\n",
       "2     4.0\n",
       "3     NaN\n",
       "4     5.0\n",
       "5     5.0\n",
       "6     NaN\n",
       "7     NaN\n",
       "8     NaN\n",
       "9     NaN\n",
       "10    NaN\n",
       "Name: Aliens in the Attic, dtype: float64"
      ]
     },
     "execution_count": 113,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "aliens_user_ratings"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 114,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "d:\\--github\\_playground\\working-with-data\\venv\\lib\\site-packages\\numpy\\lib\\function_base.py:2846: RuntimeWarning: Degrees of freedom <= 0 for slice\n",
      "  c = cov(x, y, rowvar, dtype=dtype)\n",
      "d:\\--github\\_playground\\working-with-data\\venv\\lib\\site-packages\\numpy\\lib\\function_base.py:2705: RuntimeWarning: divide by zero encountered in divide\n",
      "  c *= np.true_divide(1, fact)\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "title\n",
       "(500) Days of Summer     0.904534\n",
       "10,000 B.C.                   NaN\n",
       "12 Rounds                0.277350\n",
       "127 Hours                     NaN\n",
       "17 Again                -1.000000\n",
       "dtype: float64"
      ]
     },
     "execution_count": 114,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# find similar movies to (Aliens in the Attic) using correlation with other movies ratings\n",
    "similar_to_aliens = data_matrix.corrwith(aliens_user_ratings)\n",
    "similar_to_aliens.head()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 115,
   "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>Correlation</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>title</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Aliens in the Attic</th>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>A Nightmare on Elm Street</th>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(500) Days of Summer</th>\n",
       "      <td>0.904534</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Alice in Wonderland</th>\n",
       "      <td>0.845154</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Adventureland</th>\n",
       "      <td>0.500000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                           Correlation\n",
       "title                                 \n",
       "Aliens in the Attic           1.000000\n",
       "A Nightmare on Elm Street     1.000000\n",
       "(500) Days of Summer          0.904534\n",
       "Alice in Wonderland           0.845154\n",
       "Adventureland                 0.500000"
      ]
     },
     "execution_count": 115,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# better display the recommendations\n",
    "corr_aliens = pd.DataFrame(similar_to_aliens, columns = ['Correlation'])\n",
    "corr_aliens.dropna(inplace=True)\n",
    "corr_aliens.sort_values('Correlation', ascending=False).head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 116,
   "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>Correlation</th>\n",
       "      <th>number_of_ratings</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>title</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>(500) Days of Summer</th>\n",
       "      <td>0.904534</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12 Rounds</th>\n",
       "      <td>0.277350</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17 Again</th>\n",
       "      <td>-1.000000</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50/50</th>\n",
       "      <td>-1.000000</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>A Nightmare on Elm Street</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                           Correlation  number_of_ratings\n",
       "title                                                    \n",
       "(500) Days of Summer          0.904534                  7\n",
       "12 Rounds                     0.277350                  5\n",
       "17 Again                     -1.000000                  5\n",
       "50/50                        -1.000000                  5\n",
       "A Nightmare on Elm Street     1.000000                  3"
      ]
     },
     "execution_count": 116,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# set up to refine the recommendations\n",
    "corr_aliens = corr_aliens.join(ratings['number_of_ratings'])\n",
    "\n",
    "corr_aliens.head()"
   ]
  },
  {
   "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></th>\n",
       "      <th>Correlation</th>\n",
       "      <th>number_of_ratings</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>title</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Aliens in the Attic</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>(500) Days of Summer</th>\n",
       "      <td>0.904534</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Alice in Wonderland</th>\n",
       "      <td>0.845154</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Adventureland</th>\n",
       "      <td>0.500000</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>An Education</th>\n",
       "      <td>0.500000</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                       Correlation  number_of_ratings\n",
       "title                                                \n",
       "Aliens in the Attic       1.000000                  4\n",
       "(500) Days of Summer      0.904534                  7\n",
       "Alice in Wonderland       0.845154                  7\n",
       "Adventureland             0.500000                  5\n",
       "An Education              0.500000                  7"
      ]
     },
     "execution_count": 117,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# applying a filter to refine the recommendations\n",
    "corr_aliens[corr_aliens['number_of_ratings'] > 3].sort_values(by='Correlation', ascending=False).head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "venv",
   "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.13"
  },
  "orig_nbformat": 4,
  "vscode": {
   "interpreter": {
    "hash": "573d3ee7a7ea113c87fe39c46ef514d1785239662ea5005c6a097a8b3c9400a7"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}