03-explore.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Verkennen"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import seaborn as sns\n",
    "\n",
    "def missing(df):\n",
    "    return df[df.isna().any(axis='columns')]\n",
    "\n",
    "def movie_url(imdb_id):\n",
    "    return f'https://www.imdb.com/title/tt{imdb_id:07}/'\n",
    "\n",
    "def user_url(twitter_id):\n",
    "    return f'https://twitter.com/i/user/{twitter_id}'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "n_movies = 35611\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>imdb_id</th>\n",
       "      <th>title</th>\n",
       "      <th>year</th>\n",
       "      <th>genres</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>8</td>\n",
       "      <td>Edison Kinetoscopic Record of a Sneeze</td>\n",
       "      <td>1894</td>\n",
       "      <td>[documentary, short]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>10</td>\n",
       "      <td>La sortie des usines Lumière</td>\n",
       "      <td>1895</td>\n",
       "      <td>[documentary, short]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>12</td>\n",
       "      <td>The Arrival of a Train</td>\n",
       "      <td>1896</td>\n",
       "      <td>[documentary, short]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>25</td>\n",
       "      <td>The Oxford and Cambridge University Boat Race</td>\n",
       "      <td>1895</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>91</td>\n",
       "      <td>Le manoir du diable</td>\n",
       "      <td>1896</td>\n",
       "      <td>[short, horror]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   imdb_id                                          title  year  \\\n",
       "0        8         Edison Kinetoscopic Record of a Sneeze  1894   \n",
       "1       10                   La sortie des usines Lumière  1895   \n",
       "2       12                         The Arrival of a Train  1896   \n",
       "3       25  The Oxford and Cambridge University Boat Race  1895   \n",
       "4       91                            Le manoir du diable  1896   \n",
       "\n",
       "                 genres  \n",
       "0  [documentary, short]  \n",
       "1  [documentary, short]  \n",
       "2  [documentary, short]  \n",
       "3                  None  \n",
       "4       [short, horror]  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies = pd.read_parquet('data/movies_clean.parquet')\n",
    "print(f'n_movies = {movies.shape[0]}')\n",
    "movies.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "n_ratings = 857465\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>user_id</th>\n",
       "      <th>imdb_id</th>\n",
       "      <th>rating</th>\n",
       "      <th>date_time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>114508</td>\n",
       "      <td>8</td>\n",
       "      <td>2013-10-05 21:00:50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>208092</td>\n",
       "      <td>5</td>\n",
       "      <td>2020-04-09 21:01:12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>358273</td>\n",
       "      <td>9</td>\n",
       "      <td>2020-01-15 03:10:27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2</td>\n",
       "      <td>10039344</td>\n",
       "      <td>5</td>\n",
       "      <td>2020-01-09 20:50:53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2</td>\n",
       "      <td>6199572</td>\n",
       "      <td>3</td>\n",
       "      <td>2020-05-14 18:54:43</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   user_id   imdb_id  rating           date_time\n",
       "0        1    114508       8 2013-10-05 21:00:50\n",
       "1        2    208092       5 2020-04-09 21:01:12\n",
       "2        2    358273       9 2020-01-15 03:10:27\n",
       "3        2  10039344       5 2020-01-09 20:50:53\n",
       "4        2   6199572       3 2020-05-14 18:54:43"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ratings = pd.read_parquet('data/ratings_clean.parquet')\n",
    "print(f'n_ratings = {ratings.shape[0]}')\n",
    "ratings.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "n_users = 62798\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>user_id</th>\n",
       "      <th>twitter_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>139564917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>522540374</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>475571186</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>215022153</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>349681331</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   user_id  twitter_id\n",
       "0        1   139564917\n",
       "1        2   522540374\n",
       "2        3   475571186\n",
       "3        4   215022153\n",
       "4        5   349681331"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "users = pd.read_parquet('data/users_clean.parquet')\n",
    "print(f'n_users = {users.shape[0]}')\n",
    "users.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Movies"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYQAAAD4CAYAAADsKpHdAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjEsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+j8jraAAAbiUlEQVR4nO3df5DddX3v8eerxNLIloCiOzFJb3CMzoVEaXcncseim0JLtFSwhXtDuQYG7kQZnNHe9EpoO6O9Tm7BinQYKt7YMATxslDQkiumloustJ0AJohuAqKL5OKSTBg0haxCavB1//h+9vawnOyPs+fs7hdej5kz53ve3+/3s6+Tzdn3+f445yvbRERE/NJsB4iIiLkhDSEiIoA0hIiIKNIQIiICSEOIiIhi3mwHaNUJJ5zgpUuXtm28n/70pxxzzDFtG69T6pIT6pO1LjmhPlnrkhNefVl37tz5jO03NJ1pu5a3np4et9O9997b1vE6pS457fpkrUtOuz5Z65LTfvVlBXb4CH9Xs8soIiKAHEOIiIgiDSEiIoA0hIiIKNIQIiICSEOIiIgiDSEiIoA0hIiIKNIQIiICqPFXV0REzKalG+6a8Z+5fsVhLtpwF3uu/N2OjJ8thIiIACbRECQtkXSvpEcl7Zb00VJ/naS7Jf2g3B/fsM4VkoYkPSbpzIZ6j6TBMu9aSSr1oyXdWuoPSFra/qcaERHjmcwWwmFgve1/D5wKXCbpJGADcI/tZcA95TFl3hrgZGA18DlJR5WxrgfWAcvKbXWpXwIcsP0W4BrgqjY8t4iImIIJG4LtfbYfKtMHgUeBRcDZwJay2BbgnDJ9NtBv+5DtJ4AhYKWkhcCxtreXb9y7acw6o2PdDpw+uvUQEREzQ9Xf5kkuXO3KuQ9YDjxp+7iGeQdsHy/pOuB+2zeX+mZgG7AHuNL2GaV+GnC57bMk7QJW2x4u8x4H3mn7mTE/fx3VFgbd3d09/f39LT3pZkZGRujq6mrbeJ1Sl5xQn6x1yQn1yVqXnNB61sGnnu1AmvF1z4f9z8OKRQtaHmPVqlU7bfc2mzfps4wkdQF3AB+z/dw4b+CbzfA49fHWeWnB3gRsAujt7XVfX98EqSdvYGCAdo7XKXXJCfXJWpecUJ+sdckJrWe9aJbOMrp6cB57LujryPiTOstI0muomsGXbH+5lPeX3UCU+6dLfRhY0rD6YmBvqS9uUn/JOpLmAQuAn0z1yUREROsmc5aRgM3Ao7Y/2zBrK3Bhmb4QuLOhvqacOXQi1cHjB23vAw5KOrWMuXbMOqNjnQt8w1PZlxUREdM2mV1G7wI+CAxKerjU/gS4ErhN0iXAk8B5ALZ3S7oNeITqDKXLbL9Y1rsUuBGYT3VcYVupbwa+KGmIastgzTSfV0RETNGEDcH2P9F8Hz/A6UdYZyOwsUl9B9UB6bH1FygNJSIiZkc+qRwREUAaQkREFGkIEREBpCFERESRhhAREUAaQkREFGkIEREBpCFERESRhhAREUAaQkREFGkIEREBpCFERESRhhAREUAaQkREFGkIEREBpCFEREQxmUto3iDpaUm7Gmq3Snq43PaMXklN0lJJzzfM+3zDOj2SBiUNSbq2XEaTcqnNW0v9AUlL2/80IyJiIpPZQrgRWN1YsP2fbJ9i+xTgDuDLDbMfH51n+8MN9euBdVTXWF7WMOYlwAHbbwGuAa5q6ZlERMS0TNgQbN9HdZ3jlynv8v8jcMt4Y0haCBxre7ttAzcB55TZZwNbyvTtwOmjWw8RETFzVP19nmChajfOV20vH1N/N/BZ270Ny+0Gvg88B/yZ7X+U1AtcafuMstxpwOW2zyq7olbbHi7zHgfeafuZJjnWUW1l0N3d3dPf39/Kc25qZGSErq6uto3XKXXJCfXJWpecUJ+sdckJrWcdfOrZDqQZX/d82P88rFi0oOUxVq1atXP0b/ZY81oetXI+L9062Af8mu0fS+oB/k7SyUCzd/yjnWi8eS8t2puATQC9vb3u6+trNffLDAwM0M7xOqUuOaE+WeuSE+qTtS45ofWsF224q/1hJrB+xWGuHpzHngv6OjJ+yw1B0jzg94Ge0ZrtQ8ChMr2zvNt/KzAMLG5YfTGwt0wPA0uA4TLmAo6wiyoiIjpnOqedngF8b3RXD4CkN0g6qky/merg8Q9t7wMOSjq1HB9YC9xZVtsKXFimzwW+4cnsx4qIiLaazGmntwDbgbdJGpZ0SZm1hpcfTH438F1J36E6QPxh26Pv9i8F/gYYAh4HtpX6ZuD1koaA/wpsmMbziYiIFk24y8j2+UeoX9SkdgfVaajNlt8BLG9SfwE4b6IcERHRWfmkckREAGkIERFRpCFERASQhhAREUUaQkREAGkIERFRpCFERASQhhAREUUaQkREAGkIERFRpCFERASQhhAREUUaQkREAGkIERFRpCFERASQhhAREcVkrph2g6SnJe1qqH1S0lOSHi639zXMu0LSkKTHJJ3ZUO+RNFjmXVsupYmkoyXdWuoPSFra3qcYERGTMZkthBuB1U3q19g+pdy+BiDpJKpLa55c1vnc6DWWgeuBdVTXWV7WMOYlwAHbbwGuAa5q8blERMQ0TNgQbN8H/GSi5YqzgX7bh2w/QXX95JWSFgLH2t5u28BNwDkN62wp07cDp49uPURExMyZ8JrK4/iIpLXADmC97QPAIuD+hmWGS+3nZXpsnXL/IwDbhyU9C7weeGbsD5S0jmorg+7ubgYGBqYR/6VGRkbaOl6n1CUn1CdrXXJCfbLWJSe0nnX9isPtDzOB7vnVz+3Uv22rDeF64FOAy/3VwMVAs3f2HqfOBPNeWrQ3AZsAent73dfXN6XQ4xkYGKCd43VKXXJCfbLWJSfUJ2tdckLrWS/acFf7w0xg/YrDXD04jz0X9HVk/JbOMrK93/aLtn8BfAFYWWYNA0saFl0M7C31xU3qL1lH0jxgAZPfRRUREW3SUkMoxwRGfQAYPQNpK7CmnDl0ItXB4wdt7wMOSjq1HB9YC9zZsM6FZfpc4BvlOENERMygCXcZSboF6ANOkDQMfALok3QK1a6dPcCHAGzvlnQb8AhwGLjM9otlqEupzliaD2wrN4DNwBclDVFtGaxpxxOLiIipmbAh2D6/SXnzOMtvBDY2qe8AljepvwCcN1GOiIjorHxSOSIigDSEiIgo0hAiIgJIQ4iIiCINISIigDSEiIgo0hAiIgJIQ4iIiCINISIigDSEiIgo0hAiIgJIQ4iIiCINISIigDSEiIgo0hAiIgJIQ4iIiGLChiDpBklPS9rVUPtLSd+T9F1JX5F0XKkvlfS8pIfL7fMN6/RIGpQ0JOnacilNyuU2by31ByQtbf/TjIiIiUxmC+FGYPWY2t3ActtvB74PXNEw73Hbp5Tbhxvq1wPrqK6zvKxhzEuAA7bfAlwDXDXlZxEREdM2YUOwfR/VtY4ba/9g+3B5eD+weLwxJC0EjrW93baBm4BzyuyzgS1l+nbg9NGth4iImDntOIZwMbCt4fGJkr4t6ZuSTiu1RcBwwzLDpTY670cApck8C7y+DbkiImIKVL1hn2Char/+V20vH1P/U6AX+H3blnQ00GX7x5J6gL8DTgbeBvyF7TPKeqcBH7f9e5J2A2faHi7zHgdW2v5xkxzrqHY70d3d3dPf39/i0365kZERurq62jZep9QlJ9Qna11yQn2y1iUntJ518KlnO5BmfN3zYf/zsGLRgpbHWLVq1U7bvc3mzWt1UEkXAmcBp5fdQNg+BBwq0zvLH/e3Um0RNO5WWgzsLdPDwBJgWNI8YAFjdlGNsr0J2ATQ29vrvr6+VuO/zMDAAO0cr1PqkhPqk7UuOaE+WeuSE1rPetGGu9ofZgLrVxzm6sF57LmgryPjt7TLSNJq4HLg/bZ/1lB/g6SjyvSbqQ4e/9D2PuCgpFPL8YG1wJ1lta3AhWX6XOAbnsxmS0REtNWEWwiSbgH6gBMkDQOfoDqr6Gjg7nL89/5yRtG7gf8u6TDwIvBh26Pv9i+lOmNpPtUxh9HjDpuBL0oaotoyWNOWZxYREVMyYUOwfX6T8uYjLHsHcMcR5u0AljepvwCcN1GOiIjorHxSOSIigDSEiIgo0hAiIgJIQ4iIiCINISIigDSEiIgo0hAiIgJIQ4iIiCINISIigDSEiIgo0hAiIgJIQ4iIiCINISIigDSEiIgo0hAiIgJIQ4iIiCINISIigEk0BEk3SHpa0q6G2usk3S3pB+X++IZ5V0gakvSYpDMb6j2SBsu8a8u1lZF0tKRbS/0BSUvb+xQjImIyJrOFcCOwekxtA3CP7WXAPeUxkk6iuibyyWWdz0k6qqxzPbAOWFZuo2NeAhyw/RbgGuCqVp9MRES0bsKGYPs+4CdjymcDW8r0FuCchnq/7UO2nwCGgJWSFgLH2t5u28BNY9YZHet24PTRrYeIiJg5qv4+T7BQtRvnq7aXl8f/Yvu4hvkHbB8v6Trgfts3l/pmYBuwB7jS9hmlfhpwue2zyq6o1baHy7zHgXfafqZJjnVUWxl0d3f39Pf3t/zExxoZGaGrq6tt43VKXXJCfbLWJSfUJ2tdckLrWQeferYDacbXPR/2Pw8rFi1oeYxVq1bttN3bbN68lkdtrtk7e49TH2+dlxftTcAmgN7eXvf19bUQsbmBgQHaOV6n1CUn1CdrXXJCfbLWJSe0nvWiDXe1P8wE1q84zNWD89hzQV9Hxm/1LKP9ZTcQ5f7pUh8GljQstxjYW+qLm9Rfso6kecACXr6LKiIiOqzVhrAVuLBMXwjc2VBfU84cOpHq4PGDtvcBByWdWo4PrB2zzuhY5wLf8GT2Y0VERFtNuMtI0i1AH3CCpGHgE8CVwG2SLgGeBM4DsL1b0m3AI8Bh4DLbL5ahLqU6Y2k+1XGFbaW+GfiipCGqLYM1bXlmERExJRM2BNvnH2HW6UdYfiOwsUl9B7C8Sf0FSkOJiIjZk08qR0QEkIYQERFFGkJERABpCBERUaQhREQEkIYQERFFGkJERABpCBERUaQhREQEkIYQERFFGkJERABpCBERUaQhREQEkIYQERFFGkJERABpCBERUbTcECS9TdLDDbfnJH1M0iclPdVQf1/DOldIGpL0mKQzG+o9kgbLvGvLZTYjImIGtdwQbD9m+xTbpwA9wM+Ar5TZ14zOs/01AEknUV0e82RgNfA5SUeV5a8H1lFdg3lZmR8RETOoXbuMTgcet/1/x1nmbKDf9iHbTwBDwEpJC4FjbW+3beAm4Jw25YqIiElS9Td4moNINwAP2b5O0ieBi4DngB3AetsHJF0H3G/75rLOZmAbsAe40vYZpX4acLnts5r8nHVUWxJ0d3f39Pf3Tzv7qJGREbq6uto2XqfUJSfUJ2tdckJ9stYlJ7SedfCpZzuQZnzd82H/87Bi0YKWx1i1atVO273N5s1redRC0i8D7weuKKXrgU8BLvdXAxcDzY4LeJz6y4v2JmATQG9vr/v6+qYT/SUGBgZo53idUpecUJ+sdckJ9clal5zQetaLNtzV/jATWL/iMFcPzmPPBX0dGb8du4zeS7V1sB/A9n7bL9r+BfAFYGVZbhhY0rDeYmBvqS9uUo+IiBnUjoZwPnDL6INyTGDUB4BdZXorsEbS0ZJOpDp4/KDtfcBBSaeWs4vWAne2IVdEREzBtHYZSXot8NvAhxrKn5Z0CtVunz2j82zvlnQb8AhwGLjM9otlnUuBG4H5VMcVtk0nV0RETN20GoLtnwGvH1P74DjLbwQ2NqnvAJZPJ0tERExPPqkcERFAGkJERBRpCBERAaQhREREkYYQERFAGkJERBRpCBERAbThu4wiImbT0ml+p9D6FYdn5XuJ5qJsIUREBJCGEBERRRpCREQAaQgREVGkIUREBJCGEBERRRpCREQAaQgREVFMqyFI2iNpUNLDknaU2usk3S3pB+X++Iblr5A0JOkxSWc21HvKOEOSri2X0oyIiBnUji2EVbZPsd1bHm8A7rG9DLinPEbSScAa4GRgNfA5SUeVda4H1lFdZ3lZmR8RETOoE7uMzga2lOktwDkN9X7bh2w/AQwBKyUtBI61vd22gZsa1omIiBmi6m9wiytLTwAHAAP/0/YmSf9i+7iGZQ7YPl7SdcD9tm8u9c3ANmAPcKXtM0r9NOBy22c1+XnrqLYk6O7u7unv7285+1gjIyN0dXW1bbxOqUtOqE/WuuSE+mSdyZyDTz07rfW758P+59sUpsNGs65YtKDlMVatWrWzYY/OS0z3y+3eZXuvpDcCd0v63jjLNjsu4HHqLy/am4BNAL29ve7r65ti3CMbGBigneN1Sl1yQn2y1iUn1CfrTOac7hfTrV9xmKsH6/E9n6NZ91zQ15Hxp7XLyPbecv808BVgJbC/7Aai3D9dFh8GljSsvhjYW+qLm9QjImIGtdwQJB0j6VdHp4HfAXYBW4ELy2IXAneW6a3AGklHSzqR6uDxg7b3AQclnVrOLlrbsE5ERMyQ6WwndQNfKWeIzgP+l+2/l/Qt4DZJlwBPAucB2N4t6TbgEeAwcJntF8tYlwI3AvOpjitsm0auiIhoQcsNwfYPgXc0qf8YOP0I62wENjap7wCWt5olIiKmL59UjogIIA0hIiKKNISIiADSECIiokhDiIgIIA0hIiKKNISIiADSECIiokhDiIgIIA0hIiKKNISIiACmfz2EiAiWjrkmwfoVh6d9nYKYedlCiIgIIA0hIiKKNISIiADSECIiopjOJTSXSLpX0qOSdkv6aKl/UtJTkh4ut/c1rHOFpCFJj0k6s6HeI2mwzLu2XEozIiJm0HTOMjoMrLf9ULm28k5Jd5d519j+TOPCkk4C1gAnA28C/o+kt5bLaF4PrAPuB74GrCaX0YyImFEtbyHY3mf7oTJ9EHgUWDTOKmcD/bYP2X4CGAJWSloIHGt7u20DNwHntJorIiJa05bPIUhaCvw68ADwLuAjktYCO6i2Ig5QNYv7G1YbLrWfl+mx9YiYorGfB4iYClVvyqcxgNQFfBPYaPvLkrqBZwADnwIW2r5Y0l8D223fXNbbTLV76EngL2yfUeqnAR+3/XtNftY6ql1LdHd39/T3908re6ORkRG6urraNl6n1CUn1CdrXXLCxFkHn3p2BtMcWfd82P/8bKeYnDpmXbFoQctjrFq1aqft3mbzprWFIOk1wB3Al2x/GcD2/ob5XwC+Wh4OA0saVl8M7C31xU3qL2N7E7AJoLe31319fdOJ/xIDAwO0c7xOqUtOqE/WuuSEibPOlU8Hr19xmKsH6/FFCHXMuueCvo6MP52zjARsBh61/dmG+sKGxT4A7CrTW4E1ko6WdCKwDHjQ9j7goKRTy5hrgTtbzRUREa2ZTlt8F/BBYFDSw6X2J8D5kk6h2mW0B/gQgO3dkm4DHqE6Q+mycoYRwKXAjcB8qrOLcoZRRMQMa7kh2P4noNnnBb42zjobgY1N6juA5a1miYiI6csnlSMiAkhDiIiIIg0hIiKANISIiCjqcfJtRI108tPCuRJZdFK2ECIiAkhDiIiIIg0hIiKANISIiCjSECIiAshZRvEKNtmzfXLmTkQlWwgREQGkIURERJGGEBERQBpCREQUOagcHZcLv0fUQ7YQIiICmEMNQdJqSY9JGpK0YbbzRES82syJhiDpKOCvgfcCJ1Fdl/mk2U0VEfHqMleOIawEhmz/EEBSP3A28MispnoFmY39+PnAV0S9yPZsZ0DSucBq2/+lPP4g8E7bHxmz3DpgXXn4NuCxNsY4AXimjeN1Sl1yQn2y1iUn1CdrXXLCqy/rv7P9hmYz5soWgprUXtapbG8CNnUkgLTDdm8nxm6nuuSE+mStS06oT9a65IRkbTQnjiEAw8CShseLgb2zlCUi4lVprjSEbwHLJJ0o6ZeBNcDWWc4UEfGqMid2Gdk+LOkjwNeBo4AbbO+e4Rgd2RXVAXXJCfXJWpecUJ+sdckJyfr/zYmDyhERMfvmyi6jiIiYZWkIEREBvIIbgqQbJD0taVdD7RRJ90t6WNIOSStL/TWStkgalPSopCsa1ukp9SFJ10pqdopsu3O+Q9L28nP/t6RjG+ZdUbI8JunMmco51aySflvSzlLfKem35mrWhvm/JmlE0h/PVNYWfv9vL/N2l/m/MhM5p5p1ll9TSyTdW37ubkkfLfXXSbpb0g/K/fEN68zK62qqWTv+urL9irwB7wZ+A9jVUPsH4L1l+n3AQJn+Q6C/TL8W2AMsLY8fBP4D1Wclto2u3+Gc3wLeU6YvBj5Vpk8CvgMcDZwIPA4cNRM5W8j668CbyvRy4KmGdeZU1ob5dwB/C/zxTGWd4r/pPOC7wDvK49fP4d//bL6mFgK/UaZ/Ffh+ee18GthQ6huAq8r0rL2uWsja0dfVK3YLwfZ9wE/GloHRd1sL+LfPOhg4RtI8YD7wr8BzkhYCx9re7upf/CbgnBnI+TbgvjJ9N/AHZfpsqhfZIdtPAEPAypnIOdWstr9te/TfdzfwK5KOnotZASSdA/ywZB2tzbXf/+8A37X9nbLuj22/OEf/TWfzNbXP9kNl+iDwKLCI6vWzpSy2peHnztrraqpZO/26esU2hCP4GPCXkn4EfAYY3Yy9HfgpsA94EviM7Z9Q/WKGG9YfLrVO2wW8v0yfx799aG8R8KMmeWYrJxw5a6M/AL5t+xBzMKukY4DLgT8fs/xc+/2/FbCkr0t6SNLHZzknHDnrnHhNSVpK9a76AaDb9j6o/hADbyyLzYnX1SSzNmr76+rV1hAuBf7I9hLgj4DNpb4SeBF4E9Um43pJb2aSX6nRARcDl0naSbUZ+a+lfqQ8s5UTjpwVAEknA1cBHxotNRljtrP+OXCN7ZExy8+13/884DeBC8r9BySdPos54chZZ/01JamLajfgx2w/N96iR8g0F7OOLt+R19Wc+GDaDLoQ+GiZ/lvgb8r0HwJ/b/vnwNOS/hnoBf6R6ms0Rs3IV2rY/h7V7gEkvRX43TLrSF/xMTwbOWHcrEhaDHwFWGv78VKei1nfCZwr6dPAccAvJL1A9QKda7//b9p+psz7GtU+/ZtnI+cEWWf1NSXpNVS/vy/Z/nIp75e00Pa+sovl6VKf1dfVFLN29HX1attC2Au8p0z/FvCDMv0k8FuqHAOcCnyvbKodlHRqOWK/Friz0yElvbHc/xLwZ8Dny6ytwJqyz/BEYBnw4GzlHC+rpOOAu4ArbP/z6PJzMavt02wvtb0U+Cvgf9i+bg7+/r8OvF3Sa8u++fcAj8zFf1Nm8TVVxt0MPGr7sw2ztlK9KaTc39lQn5XX1VSzdvx11c4j5nPpBtxCtf/y51Td8xKqzeydVGcUPAD0lGW7qLYYdlNdg+G/NYzTS7Wf9HHgOsqnuzuc86NUZxt8H7iy8WcCf1qyPEbDWQSdzjnVrFR/HH4KPNxwe+NczDpmvU/y0rOM5trv/z+X/6e7gE/P4d//bL6mfpNqd8l3G/7vvY/qrKx7qN4I3gO8brZfV1PN2unXVb66IiIigFffLqOIiDiCNISIiADSECIiokhDiIgIIA0hIiKKNISIiADSECIiovh/gxlnwNg6GagAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "movies['year'].hist();"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAZIAAAExCAYAAABWCiS6AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjEsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+j8jraAAAgAElEQVR4nO2debhcVZW33x8zKAGEaAMhBDBCA80gAVERRWzBiRmBFkHEjiIqqO1AazeoTQsq8gkqijIrCII0QWUSEEQSIIEwyNAEQYnQDIqYbgENru+PvYt7bt1z6p5z69a9uanf+zz1VNU+a5/ap+rUXnuvvdbaigiMMcaYkbLMeDfAGGPMxMaKxBhjTFdYkRhjjOkKKxJjjDFdYUVijDGmK6xIjDHGdMVy492AsWattdaKadOmjXczjDFmQjFv3rwnI2Jy2bG+UyTTpk1j7ty5490MY4yZUEj6TdUxm7aMMcZ0hRWJMcaYrrAiMcYY0xVWJMYYY7rCisQYY0xXWJEYY4zpCisSY4wxXWFFYowxpiv6LiDRLP285ZKDh5W5bPezxqAlxvQHnpEYY4zpCisSY4wxXWFFYowxpit6pkgknS7pcUl3FcrOlzQ/Px6SND+XT5P0TOHYtwp1tpF0p6QFkk6SpFy+Yj7fAkk3SZrWq2sxxhhTTS9nJGcCuxYLImK/iNgqIrYCLgJ+VDj8QOtYRHygUH4KMBOYnh+tcx4KPBURLwdOBI7vzWUYY4zpRM8USURcD/yh7FieVbwTOK/TOSStDUyKiNkREcDZwB758O5Ay/XmQmDn1mzFGGPM2DFeaySvAx6LiPsLZRtIuk3SdZJel8vWBRYWZBbmstaxhwEiYjHwNLBm2YdJmilprqS5TzzxxGhehzHG9D3jpUgOYPBs5FFgakRsDXwMOFfSJKBshhH5udOxwYURp0bEjIiYMXly6QZfxhhjRsiYByRKWg7YC9imVRYRzwHP5dfzJD0AvII0A5lSqD4FeCS/XgisByzM51yNClOaMcaY3jEeM5I3AfdGxAsmK0mTJS2bX29IWlT/dUQ8CiyStH1e/zgIuCRXmwW0Qpj3Aa7J6yjGGGPGkF66/54HzAY2lrRQ0qH50P4MXWTfEbhD0u2khfMPRERrdnEY8F1gAfAAcFkuPw1YU9ICkjns0726FmOMMdX0zLQVEQdUlL+npOwikjtwmfxcYPOS8meBfbtrpTHGmG5xZLsxxpiusCIxxhjTFVYkxhhjusKKxBhjTFdYkRhjjOkKKxJjjDFdYUVijDGmK6xIjDHGdIUViTHGmK6wIjHGGNMVViTGGGO6worEGGNMV1iRGGOM6QorEmOMMV1hRWKMMaYrrEiMMcZ0hRWJMcaYrrAiMcYY0xVWJMYYY7qiZ4pE0umSHpd0V6HsGEm/kzQ/P95aOHaUpAWS7pO0S6F8G0l35mMnSVIuX1HS+bn8JknTenUtxhhjqunljORMYNeS8hMjYqv8+CmApE2B/YHNcp1vSlo2y58CzASm50frnIcCT0XEy4ETgeN7dSHGGGOq6ZkiiYjrgT/UFN8d+EFEPBcRDwILgO0krQ1MiojZERHA2cAehTpn5dcXAju3ZivGGGPGjvFYI/mQpDuy6WuNXLYu8HBBZmEuWze/bi8fVCciFgNPA2v2suHGGGOGMtaK5BRgI2Ar4FHghFxeNpOIDuWd6gxB0kxJcyXNfeKJJ5q12BhjTEfGVJFExGMR8XxE/A34DrBdPrQQWK8gOgV4JJdPKSkfVEfScsBqVJjSIuLUiJgRETMmT548WpdjjDGGMVYkec2jxZ5Ay6NrFrB/9sTagLSofnNEPAoskrR9Xv84CLikUOfg/Hof4Jq8jmKMMWYMWa5XJ5Z0HvAGYC1JC4GjgTdI2opkgnoIeD9ARPxK0gXA3cBi4PCIeD6f6jCSB9jKwGX5AXAacI6kBaSZyP69uhZjjDHV9EyRRMQBJcWndZA/Fji2pHwusHlJ+bPAvt200RhjTPc4st0YY0xXWJEYY4zpCisSY4wxXWFFYowxpiusSIwxxnSFFYkxxpiusCIxxhjTFVYkxhhjusKKxBhjTFdYkRhjjOkKKxJjjDFdYUVijDGmK6xIjDHGdIUViTHGmK6wIjHGGNMVViTGGGO6worEGGNMV1iRGGOM6QorEmOMMV1hRWKMMaYreqZIJJ0u6XFJdxXKvizpXkl3SLpY0uq5fJqkZyTNz49vFepsI+lOSQsknSRJuXxFSefn8pskTevVtRhjjKmmlzOSM4Fd28quAjaPiC2A/waOKhx7ICK2yo8PFMpPAWYC0/Ojdc5Dgaci4uXAicDxo38JxhhjhqNniiQirgf+0FZ2ZUQszm/nAFM6nUPS2sCkiJgdEQGcDeyRD+8OnJVfXwjs3JqtGGOMGTvGc43kvcBlhfcbSLpN0nWSXpfL1gUWFmQW5rLWsYcBsnJ6Glizt002xhjTznLj8aGSPgMsBr6fix4FpkbE7yVtA/yXpM2AshlGtE7T4Vj7580kmceYOnVqN003xhjTxpjPSCQdDLwdeFc2VxERz0XE7/PrecADwCtIM5Ci+WsK8Eh+vRBYL59zOWA12kxpLSLi1IiYEREzJk+ePPoXZYwxfcyYKhJJuwKfAnaLiD8XyidLWja/3pC0qP7riHgUWCRp+7z+cRBwSa42Czg4v94HuKalmIwxxowdPTNtSToPeAOwlqSFwNEkL60Vgavyuvic7KG1I/B5SYuB54EPRERrdnEYyQNsZdKaSmtd5TTgHEkLSDOR/Xt1LcYYY6rpmSKJiANKik+rkL0IuKji2Fxg85LyZ4F9u2mjMcaY7nFkuzHGmK6wIjHGGNMVViTGGGO6worEGGNMV1iRGGOM6QorEmOMMV1hRWKMMaYrrEiMMcZ0hRWJMcaYrrAiMcYY0xVWJMYYY7piXPYjMYO565u71ZLb/IOzetwSY4xpjmckxhhjusKKxBhjTFdYkRhjjOkKKxJjjDFdYUVijDGmK2opEklX1ykzxhjTf3R0/5W0ErAKad/1NQDlQ5OAdXrcNmOMMROA4WYk7wfmAZvk59bjEuAbnSpKOl3S45LuKpS9RNJVku7Pz2sUjh0laYGk+yTtUijfRtKd+dhJkpTLV5R0fi6/SdK0ZpdujDFmNOioSCLiaxGxAfAvEbFhRGyQH1tGxNeHOfeZwK5tZZ8Gro6I6cDV+T2SNgX2BzbLdb4padlc5xRgJjA9P1rnPBR4KiJeDpwIHD/s1RpjjBl1akW2R8TJkl4DTCvWiYizO9S5vmSWsDvwhvz6LODnwKdy+Q8i4jngQUkLgO0kPQRMiojZAJLOBvYALst1jsnnuhD4uiRFRNS5JmOMMaNDLUUi6RxgI2A+8HwuDqBSkVTwsoh4FCAiHpX00ly+LjCnILcwl/01v24vb9V5OJ9rsaSngTWBJxu2yRhjTBfUzbU1A9i0h6N9lZRFh/JOdYaeXJpJMo8xderUkbTPGGNMBXXjSO4C/m4UPu8xSWsD5OfHc/lCYL2C3BTgkVw+paR8UB1JywGrAX8o+9CIODUiZkTEjMmTJ4/CZRhjjGlRV5GsBdwt6QpJs1qPEXzeLODg/PpgkvdXq3z/7Im1AWlR/eZsBlskafvsrXVQW53WufYBrvH6iDHGjD11TVvHND2xpPNIC+trSVoIHA0cB1wg6VDgt8C+ABHxK0kXAHcDi4HDI6K1FnMYyQNsZdIi+2W5/DTgnLww/weS15cxxpgxpq7X1nVNTxwRB1Qc2rlC/ljg2JLyucDmJeXPkhWRMcaY8aOu19YiBhayVwCWB/4vIib1qmHGGGMmBnVnJKsW30vaA9iuJy0yxhgzoRhR9t+I+C/gjaPcFmOMMROQuqatvQpvlyHFldhDyhhjTG2vrXcUXi8GHiKlKDHGGNPn1F0jOaTXDTHGGDMxqbux1RRJF+e08I9JukjSlOFrGmOMWdqpu9h+BimSfB1SssRLc5kxxpg+p64imRwRZ0TE4vw4E3DSKmOMMbUVyZOSDpS0bH4cCPy+lw0zxhgzMairSN4LvBP4H+BRUpJEL8AbY4yp7f77BeDgiHgK0t7rwFdICsYYY0wfU3dGskVLiQBExB+ArXvTJGOMMROJuopkGUlrtN7kGUnd2YwxxpilmLrK4ATgRkkXklKjvJOSlO/GGGP6j7qR7WdLmktK1Chgr4i4u6ctM8YYMyGobZ7KisPKwxhjzCBGlEbeGGOMaWFFYowxpiusSIwxxnTFmCsSSRtLml94/EnSkZKOkfS7QvlbC3WOkrRA0n2SdimUbyPpznzsJEka6+sxxph+Z8wVSUTcFxFbRcRWwDbAn4GL8+ETW8ci4qcAkjYF9gc2A3YFvilp2Sx/CjATmJ4fu47hpRhjjGH8TVs7Aw9ExG86yOwO/CAinouIB4EFwHaS1gYmRcTsiAjgbGCP3jfZGGNMkfGOTt8fOK/w/kOSDgLmAh/PaVnWBeYUZBbmsr/m1+3lxphx4p0X3VtL7oK9N+lxS8xYMm4zEkkrALsBP8xFpwAbAVuRMgyf0BItqR4dyss+a6akuZLmPvHEE1212xhjzGDG07T1FuDWiHgMICIei4jnI+JvwHeA7bLcQmC9Qr0pwCO5fEpJ+RAi4tSImBERMyZP9n5cxhgzmoynIjmAglkrr3m02BO4K7+eBewvaUVJG5AW1W+OiEeBRZK2z95aBwGXjE3TjTHGtBiXNRJJqwD/CLy/UPwlSVuRzFMPtY5FxK8kXUBKz7IYODwins91DgPOBFYGLssPY4wxY8i4KJKI+DOwZlvZuzvIH0tJtuGImAtsPuoNNMYYU5vxdv81xhgzwbEiMcYY0xVWJMYYY7rCisQYY0xXWJEYY4zpCisSY4wxXWFFYowxpiusSIwxxnSFFYkxxpiusCIxxhjTFeO9H4kx485bLz5mWJmf7jm8jDH9imckxhhjusKKxBhjTFdYkRhjjOkKKxJjjDFdYUVijDGmK6xIjDHGdIUViTHGmK6wIjHGGNMV46JIJD0k6U5J8yXNzWUvkXSVpPvz8xoF+aMkLZB0n6RdCuXb5PMskHSSJI3H9RhjTD8znpHtO0XEk4X3nwaujojjJH06v/+UpE2B/YHNgHWAn0l6RUQ8D5wCzATmAD8FdgUuG8uLGA9+8Z2315J73T//uMctMcaYJcu0tTtwVn59FrBHofwHEfFcRDwILAC2k7Q2MCkiZkdEAGcX6hhjjBkjxkuRBHClpHmSZuayl0XEowD5+aW5fF3g4ULdhbls3fy6vdwYY8wYMl6mrddGxCOSXgpcJeneDrJl6x7RoXzoCZKymgkwderUpm01xhjTgXGZkUTEI/n5ceBiYDvgsWyuIj8/nsUXAusVqk8BHsnlU0rKyz7v1IiYEREzJk+ePJqXYowxfc+Yz0gkvQhYJiIW5ddvBj4PzAIOBo7Lz5fkKrOAcyV9lbTYPh24OSKel7RI0vbATcBBwMljezVmJBz/g12GlfnU/leMQUuMMaPBeJi2XgZcnD11lwPOjYjLJd0CXCDpUOC3wL4AEfErSRcAdwOLgcOzxxbAYcCZwMokb62l3mPLGGOWNMZckUTEr4EtS8p/D+xcUedY4NiS8rnA5qPdRmOMMfVZktx/jTHGTECsSIwxxnSF92zvAb/7xuG15NY9/Bs9bokxxvQez0iMMcZ0hRWJMcaYrrAiMcYY0xVWJMYYY7rCisQYY0xXWJEYY4zpCisSY4wxXWFFYowxpiusSIwxxnSFFYkxxpiusCIxxhjTFX2Za+uJU75XS27yYQf2uCXGGDPx8YzEGGNMV/TljKTf+Mnpb6kl97b3eoNJY0xzPCMxxhjTFVYkxhhjusKKxBhjTFeMuSKRtJ6kayXdI+lXko7I5cdI+p2k+fnx1kKdoyQtkHSfpF0K5dtIujMfO0mSxvp6jDGm3xmPxfbFwMcj4lZJqwLzJF2Vj50YEV8pCkvaFNgf2AxYB/iZpFdExPPAKcBMYA7wU2BXwCvGxowie11047AyP9r7NWPQErOkMuYzkoh4NCJuza8XAfcA63aosjvwg4h4LiIeBBYA20laG5gUEbMjIoCzgT163HxjjDFtjOsaiaRpwNbATbnoQ5LukHS6pDVy2brAw4VqC3PZuvl1e7kxxpgxZNwUiaQXAxcBR0bEn0hmqo2ArYBHgRNaoiXVo0N52WfNlDRX0twnnnii67YbY4wZYFwCEiUtT1Ii34+IHwFExGOF498BfpzfLgTWK1SfAjySy6eUlA8hIk4FTgWYMWNGqbIxI+fb5+wyvBDw/ndf0eOWGGPGg/Hw2hJwGnBPRHy1UL52QWxP4K78ehawv6QVJW0ATAdujohHgUWSts/nPAi4ZEwuwhhjzAuMx4zktcC7gTslzc9l/wocIGkrknnqIeD9ABHxK0kXAHeTPL4Ozx5bAIcBZwIrk7y17LE1Cpx3Zr0ZxgHv8QzDGDMOiiQibqB8feOnHeocCxxbUj4X2Hz0WmeMMaYpjmw3xhjTFc7+a0yPedtF3x1W5id7v28MWmJMb/CMxBhjTFd4RmJMn7H7hcM7SVyyTz2HC2PAMxJjjDFdYkVijDGmK6xIjDHGdIXXSGrw+Lf+Xy25l37gyB63xBhjljysSIxpyNt+NPzA4id7eVBh+gcrEmOWMN5+4feHlfnxPu8ag5b0nqMvLs2zOoTP7blOj1tiusGKxBgzYTjrR/W2gTh4r8k9bokp4sV2Y4wxXWFFYowxpits2jJmgvOOCy8eVubSffYcg5aYfsWKxBiz1HLZ+U/WknvLfmv1uCVLNzZtGWOM6QorEmOMMV1hRWKMMaYrvEZilniOuGjXYWW+tvflY9ASY0wZnpEYY4zpigk/I5G0K/A1YFnguxFx3Dg3yRgzQZlz5uO15LZ/z0t73JKJxYSekUhaFvgG8BZgU+AASZuOb6uMMaa/mOgzku2ABRHxawBJPwB2B+4e11YZY8wo8NiJ82vJveyjW/W4JZ1RRIxrA7pB0j7ArhHxvvz+3cCrIuJDbXIzgZn57cbAfSWnWwuoF71kect3J78ktcXylq8rv35ElGfDjIgJ+wD2Ja2LtN6/Gzh5hOeaa3nLj4X8ktQWy1u+W/mImNhrJMBCYL3C+ylAvQ0OjDHGjAoTXZHcAkyXtIGkFYD9gVnj3CZjjOkrJvRie0QslvQh4AqS++/pEfGrEZ7uVMtbfozkl6S2WN7y3cpP7MV2Y4wx489EN20ZY4wZZ6xIjDHGdIUViTHGmK7oa0WSU6w0kd+3TlkuX0bSOxuc+yVN2mJ6g6QX1ZRrdO80bEOjeyfXeW2dsi7a9HZJtfqL3P7XjNZnjzUj/P5r9w1jQS/vz9LP6+fFdkkPAhcCZ0TEsGlVJN0aEa8crqxw7PqI2LFmW+4H5gNnAJdFjR8mdxTHAOuTPPAERERsWCIr4F3AhhHxeUlTgb+LiJsrzj03t+XciHhqmHZsEhH3Sir9HiLi1pI6qwAfB6ZGxD9Lmg5sHBE/7vRZTZD0NmAzYKVCWz5fIfsa4LvAiyNiqqQtgfdHxAcr5JveO1/JsrW8CpvcO1m+6b1Z+/fN8t8DXg1cRLqOe4aRnx0Rr67b/lznNcA0Ct6kEXF2hexVwL4R8cf8fg3gBxGxS5vcpUDlfykidqs4f6+//weAOcAvgOuHu4fyAOeZiPibpFcAm5D6ib9WyP8WuBw4H7hmuP5E0udzW26MiP/rJFtav88Vyaqk2JNDSLOz00k345/a5N4CvBV4J+mHaTEJ2DQitqs4/78Bz+Q6L/w4EfGHElkBbwLeS8ohdj5wZkT8d4f23wt8FJgHPF84/+9LZE8B/ga8MSL+Pv/xroyIbSvO/XLS97If0Op0riy7ISWdGhEzJV1bcqqIiDeW1Dk/t/ugiNhc0srA7IgoTRokaS/geOClJIXZUpqTKuS/BawC7ERSEPsAN0fEoRXyN2WZWRGxdS67KyI2r5Cvde8U5N+XZZcjfZfnRcTTZbJZvta9I+nVwGuAI4ETC4cmAXtGxJYV56/9+xbqTAIOyPWicB2LSmQ/B9wB/KjmoOgcYCPSYKp1L0dEfKRC/rbW7zRM2es7fW5EXFdx/rrf/0j7hhWBVwGvA15LUgy3R8SeFfLzsuwaJAU0F/hzRLyrQn5l4B2ke/SVwI9J9+cNFfLvBXYgDRYWMaDgLimTH0LTUPil9QHsCPyOdNOcBby8cGxL4GDgN/m59dgLWKPDOR8sefy6Rlt2ym35I3Ad8OoKuZsaXN+t+fm2QtntNeotA+yW2/Mw8DngJW0y++bnDRu0Z26T9gALgL9vcP472p5fTOooq+RvGsn3M9y9UyK7MXBcvpfOBXbq5t4BXg8cDTyan1uPjwHTR+P3bZNfi6S0HgIuA+4HPlwit4g0cPkr8Kf8/k8dznsPeWBb8zufR5rNtt6v37rHR+PR4PvfEngPzfuG5Uid9qdJnfxs4Nsd5Fv/3w8Dn2y/V4e5ljWAs4Hna8j+HfAR4LfAotrf12h98RPxQQpi3A24GLgt//leRhqZ/neJ7Pd72JY1gSNII42f5BtxOWAG8GBFneOAL+cb8pWtR4XsTfkaWjfk5OFuRGAL0ij3PuAk0gjq48D8Nrlbi881r/dGYOVC3Y1IM4Yq+V82/D5bimEOsA6wInB/B/kLSSP7W4EVgH8hjeC6vnfa6uwO/FfuCD8FXNrpcxrcxxeOoF6t3zfLtq71DuATwEtz+SrAb0bh/v8hsHYD+V1zZ3dOfvwG2KWD/PT8G98N/Lr16LbdhfMv11D+z/k/uR+wZg352/L/fA6wWS67c5g6rwe+SVKCFwB7d5D9bv5PXpzv5e2aXNOEjmwfBe4HrgW+HBE3FsovlDTIPhoRz0taU9IKEfGXOieXtDxwGGnECvBz0qijzK45m/SH2CMiFhbK52YzTRmvys8zik0FhpiSSB3FxcBLJR1L6vA+26Ht80gzotOAT0fEc/nQTSWLuL/PZq0NJA1JURPlduijSTbc9SR9nzS9f09Ve0jfw/mkTrjVFiLiRxXyP5a0OknR3kr6Xr7b4fwfIG2Qti4ph9uVwOEd5GvfOwCSvkrqjK8G/jMG1qaOl1SWjRpJm5P22Smu8QxZM8j3ZiNnjYa/L8DewIkRcX3bZ/85m0Xaz99ak9sgIr4gaT2SoihdkyPNdO6WdDODf9/SNYyIuDyvyW1PMnN+NCI6Zbg9g3TPnUia8R+S67W3+40RcU02pZZ97o/a5O8kr8GkSx4iv0VFew4gmZI+CLxP0o0kU9LVFfJHAEcBF0fEryRtSLr/SslrePNJCuQTMfy6x5qkAckfgT8AT0bE4mHqDHxe1kZ9R/Zq+ExULL5W1Pk2adQ/i8F2069WyH8XWJ5k7oCUnfj5yGnv22QVPfoxsrfN9qQbZGfSH+jq6LBgKmnDyPu81Dj/CqTv5RxgyLVFtR16TQY6gjmdOgJJZ5QUR0QM6cRK6q4IrBQd1iSaMMJ7572kmcefS46t1t42SUcDbyApkp+SNm+7ISL2qTj/CaRR9w8ZfG+WKtqGv++ywBUR8aY68rlO0zW50rWM9ntnJI4dud68iNhG0p0R8Q+57BcR8bo2uc9FxNF17zdJ65d9XqHCbzodl7QJ6bc9kjTLW7lCrvbvleV3bFf6kl4bEb8cpt7fA7uQ1l6XjYgptT6vXxUJgKRrI2KnBvJHl5VHxOcq5G+PtsXO9rKRepXkuquRRlmtEfB1wOfLOsymXjSSjiCN4haRRvJbk0auV3aoMzkinuhw/OSI+HDh/RYM9dIZ0vHljuy4iPhEg/YvC7yt5PxVSv8s4IgY7AV0QpWiqnvvVHV4hfZUdXx3kuzvt0XElpJeRtoy4R0V8o0UbVauezP0+6nyapsFvLuuMlb2WCougJf9H9rqvAxoKZqbI2LIvrcjcezI9X5JWqy+ELiGtCZ0XERsXOd6RhtJFwFbkdb+bgCuJ5ljn62Qv540W74ly/4iIu7scP6mXmRvJ30/O5LWVGbnzzi9zvX0u2nrRklfZ6hnRumfu6UwssdORMT/DnP+5yVtFBEP5HobUvCuynwlP+9FWuj6Xn5/AGlBsxOnA3eRPEYgzXjOyOdq50pJe1PTiwZ4b0R8TdIupPWUQ/K5KxVJJyWSecFkIul0ko3+V6SRKySFOkSRZNNNxw65hEuBZ4E7C+fvxBYtJZI/8ylJW3eQr3vvnNDhHFVmSIBnI7l6Ls7eUo8DQ9y6C597SIfPKeMS4GnSWs1zw8hC/i6V3G6L11vqVQX8NSvzltlnMh1+B6W4jS+TzL8CTpb0iYi4sCgXETPzc+0BYOZI0nrOR4AvkMxbB3doT+1BWpZfxMCAcAWSJeL/osKrkLS+eWtEtPcHpUTEjnnmvy1ppvoTSS+OiEEmTQ148U2W9LHCoUkk01UVbyEpqK9FROOtOPpdkbSCpoqjsMo/d7ZZnwO8JL9/kuS+WhUb8C/AtZJ+TfpzrE/qkAc+LE/dJX0hBvutX5pHIZ3YKCL2Lrz/nKSqvTk/BrwIWCzpWYZxn2XAfvxWUtzA7SozAo+c7SNi0wby8/OouJbpBpjSwT5dxjKS1ogcU5HXHDr9P2rdOyPo8Frcktd4vkPq7P8XqFpfQNIU4GSSsg7SKPeIGLzeVmRKROzaoD0/yY+6NFqTAz4DbNuahWTF8zPSDGIISsF+l0fEIkmfJZlWvxARt5XJR8Qt+eX/0vYfrKDJII2IWLWtfXuQFqyrmA8croH1tOuAb0V1XMgOpBnD64DVSZ5evygRXYHkobgcUGzTn0i/QSkRcXhrRpgHbaUzwkpilLwW+uFB8mrYqfD+DaQAnjLZZUl2xhVJI+8tgRU7nPseCu6zwAbAPcO0ZzawQ+H9a0mxGKNxra3Zx/2kkdyqwLwuz3lr4fVpJD/7Ju1pf5zeQf544M0Nzn9Q/g2+kB/3kkw53X6Pb8zPe5U9OtQ7B/hnUnzBNNKMqdPnXMVAnMpyJMeFqzrInwr8Q8NrWZkUNFpXfhOSw8KHGMZ1mzYPJJJbcqVXEgNu3TuQOtTd6eAOn7+f1Qvv1yCt+1TJl3muDSkb5prmdDj2XdLa6Rvz4wwKu72WyD9P8vLaA1ihxmevP8zxk9ve77hmr1QAABy0SURBVEvyfDuL5Cr8ILBP3Wvt9xkJahD9DLwoIq4tyP1cFSk1IpljdouIE0kuk8PxUeDnefYCqfN4/zB1DgPOytNwkRbT31MmqBJPotzOqlnPoSQb7q8jeeasSb2RXCeKM5qzgNmS/odkWmnNkEpnEdHcdDMHuDg7GvyVYWZgEXG2kifTTll2r+gQbdzA9PF6kk2+bG2j1JSXOYPUSZ5MMmnNV4q2/lqF/OSIKK6TnCnpyJJ2t7yMlgMOyffbsN+/pHeQzLArkLzztiJd725tckVTy+PAecVjURKMm7lc0hUF+f1ITgZVtExCbwNOiYhLJB3TQX6tGGq6fGkH+Wck7RA5gE/Jk+2ZKmEN9vJahuRJ2cmEvG0MXi+6RtLtHeTXJA0UdwQ+IulvpEHjv5UJxzCL/BTMzJnP0mBG2E5fKxJVRD93qPJrpYjXc/L7A0mau4raazCR3Bmnk0ZxAPfGgEtmKRExH9gy29CJiqjqTHGheiXStHseFWa8SPb5B4FXSFqpTGYEFDvB00nmglprGEppIU4BXhYpEn4LYLeI+I+KKieQ/O7vjDzkqsG9wFPk/4WkqRHx2wrZWqaPiDg6PzdShJFcUK8j2cR3Irknb8bg77DIk5IOZKAjPgAYkuEAeHuTdhQ4hnTP/Dy3b76kDUrk5pE60OKgofU+qFjniYhP5DW812bZUyPi4g7t+Z2SF+WbSC7UK9I5d+Dfir+nkrdVp/viA8DZdQZpmeJAYTFpfXP3DvJ11k9fICL+mJX+eqQtxV9DWocZLZaJwaas39MgF2O/e23dERFbFJ5fTFqMfnOF/BqkyN8dSDfX9cAxUZGrqIlniVLuqY+RpqQdc09JOjAivte2mFb8gFLPpLZzrAd8KSIOqDj+PpLv+hSSPXd70giorO3/LyKOVIUHWvuoNde5puxcHdp7HUkZfjvqpTC5AnhLRNRZaEfSh0kzjMdIf+jhRujzoy2dS1lZ4djqJPPZNAZ7SVWlALmatKY1m2S6uSE62KyVcqd9naQ8AX5JWiOpHJlmW/gOpN/sl2UDnILsTRHxKg32wrqj6vvpNfn/sitpoHC/pLVJprpSZxBJu5LMeS134h2BmRFxxTCfU2eQ1hhJO5MGHoPWT4sWjzb5B0iBozeQ7oebomY8W8X5BnlwSfoyyQRfnBHeERGfqnO+vp6RMDBV/bOkdUhauGyUBaTpMMnrY1iyx8qsbNqqwxmk0VyrI1hIWlguS2LYMqetWnKs7shgIVDaCWeOII2G50TETkr+7qVuzgzM0L5ScbyMeyWdS/KuqhNguEpE3Ny23t8pYOpRkqnwsrbzVynZI0iKu2wUX0Yj0wfJTDOH+l5kdwDbkH6jp4E/Krlwl35GHmlXuoq3I+nfSXbx1vd9hqQfdpjh3SXpn4Bl8yDnI6Q1w/bzNnJ3lnRDROygwV5PMLwzyFqkLBAtJQppRln1uY0CGNXmHt2679rN3pJOpsN/rmqgEBFXtwaLuT3DWSCm1x0U1WTQH2kEM8JB9LsiaRT9nM0r/8LQUeWQkXVrjYTBifQ6sVFE7CfpgFz/GancSyoivp1f/izaAoxUkTq87YZfhrT+0ckm+2xEPCsJSStGCgIr9bmPiHn55VxyhtL8mcuSnA3KWJnUwRdnf53WDJ6UtFHrGiTtQ1IWVTyYHyvkx3A8TOqw61I0fUAyiVW6k5ICIktnkGVExEcB8iy55Xr9d1R8n9k08jVSRxmkmcxHozqI7QBg68hxC5KOI/0HqhTJh0meVc+RcoRdQXJKaKeRu3NE7JCfywZFnfgJAyazlUgDwPtI5r8X0NAAxpZr69Rs6qqahdV1j56bn19LCh5tJW7cN9ftxDYM9CVbSiIqsh0DL1cK8qxl2pW0eUTc1eGzh5hII+IiUnbnxvS7aWvF1iggj0BWInWgpTdOXgz7FkOz7ZbeMEpuj6tRY41EKUXCziQTwytzp3leVGQPzXVqBx1JKnZyi4GH2pVQm/zFpA7sSNKf/ylg+Yh4a4c6c4A3RY6vyZ3glRHR9d4UuaM8lWQbfoqkJN5VY1Gx7vlPI40Of0KNGYykDSLiwaLpo1VWIf9Rkuvpj9vOX7r4LOlDJFfPbUjeNK0gtGsq5OcA32DANLE/KZniqyrkLwMOiIEAzNWB70VE6RqKpH0j4ofDlY0USedExLuHK+tQ/5WktP/vbysfaQBjpdm0Qv5akpfgX/P75Un3fqn7t5pnO25q2r2BNIA6k7RVwB/L5AryjbJrt9PvM5LZJP9zsvJ4TtKtrbISFkfEKQ3O3yROpXbuKY0s6Gj1aPP4kXREe9kLjRxIZ31M/pOsRsr22omVohCkGRH/m23Zxc/8ZER8qcokUPVHSofiTUpecstEih+oNEMqeZ18kqEeeVXrMr/Nj7ozmItICTKLtvMLSR1/GX8hzXw/w8B1Vy4+k2ZsXyW5XNfJeaSIOKfw/ntZGVXxHPArpQDDAP4RuEHSSVD6OxxFMrV2LFPDXFUF2mcSy1H9XZad91ZJQ9KvxMgDGG+U9A/RIXq8jXVIpubWwODFuayKGST397oj+Uam3WwunE7almKuUg6zMyLiqooqXwLeEcPsM1NFXyoSSX9HSjewslL0cuvXmUTy4mqXb7k0Xirpg6RAq2FHlU1u3oi4Kiuxlg33iA423JEEHR3M0Onse0rKgMGjwRgImjyH5J1Uxf9JemVrxiVpBkPXDVo36lya0eq4i8nnOnXc3yfNBN9OMkMdDFRG3kdFmpt28lrRZsBqbZ3lJAoKq4SPkdLLd0osWGzPl+vIFbhW0qeBH5AUw36k6OeX5PO136MX50eLn5edVAP7bazbUjKZSZR3ZI3cnSUdBfwr6b/YUsoiKd5Ty9qU6xUHUMuQ7oNO6XkaBTCSnBDeo+S5OKx7NClS/bbCzOf1JE+3Ku4imSo7mWeLNDXtEskJ4bOk/9pJwNbZXP6vJQr9sZEqEehT01Y287yHNCoodmiLSJtJtd/sD1Lu0phelOxImOs1TbNQK/dUQX794Uw7ec3lnxgI3GqxKimBZGkivnYTWV7vuDM6RKNnxXE+yQ4dpBHZfu2mPzXInVXouL/EYBfmSaSspptV1Gsl6XvBs0jSdRHx+gr5WjMYSbuTgsJ2IyXvbLGIlJRxyAJ0rjcL2D9KkjaOBvkebdG6N1v3a1TdozXOuyVpPe3zwL8XDi0Cro0Sj0Wl2J19IuKCBp/zxYg4qoH80QxcZ8vd9qIOZumWZ+YOwBdJjiH/2sH0t35Zeev/pkIWhEKddUgDrXtIA9JHYmjixJZn46qk77VWtuOmpt3clxxCirO5Cjgtz9rWIXlfrp/lWoOh15MUW93s2oPoyxlJRJxFCuTbOy8wDSe/AYBSPqDLsz3838ijmg5Va6dZUIPcUwW+m+3UnbYbvZE0clmLwQuhiygJlBzpCDGzASm541RgTwYWfgcRyRGhrtliY9KsYnUGj3IXkSK/q2ilmnhUKej0EZIrcxW1ZjCRdoy7RNKrI2J2zWuAZAefn0esxT9qLS/AGnyKknszqpNCTid1qO1p6gcpnIi4Hbhd0rkF+/8awHplSiTX+Vs2q9VWJBFxVD7v9Lb2VAXM/pR0n05joB/7NOk/VEajAMbhBmik7QCKA61Sd3mGmrGbeDYW+R2p77iWlKLpT6R7tCp4+uuk9Dr/GgVPv4h4JM9SWhT/U3+mvvPLYKJByP/S9iB5wPwT6Yb899ajg3wxLcP1DJ+WoXaaBeDuEbR/yMZUZWUj/G6+OII6tb8fklKbRVKudVKGlO4S2UH+7aR1nc1Jf755JC+XKvl5xWvIr6/rIP8l0qxoeVKn8iRwYAf5g8seo/FbjfDevIHk3HEHKYbhGOBzHeR/nq/3JaS1pHnAVzvI/xvJw3G9XOcldN558X0k1+in8u/1DGmv8Sr5+0id4Aa5/evTIS0Iycnh28ADpEHJitTcAbPifLe1vb+TpADn5/ebAOd3qN9a6wN4BWmGu3wH+ctJZstPkjYf+zjw8Q7yR5aUHTFa99uQc/fqxBPhkX+c8xv8OLfl5y8C/1R2Q7XJ186FRcPcU7lO+3aj06jYpZDUUd9PcmkcduvTXGdd0lR6x9ZjGPna3w/Nc2fV7rjJec4afpdz8vMVpFHr1sADHeRbHcaepHQvL+mmYxqFe7npvdlSnHcWyn5R4/zvIyscCkq3RP7BkkfljoQ074hvaPj9rJL/A9Pz+7VpkIut5Hy3tr2/pXVfkHPq0SE3V/7vrpL/Yw+T1qsqd2AF7uqmfTXuh0YDo/ZHX5q2CjTNgNo0LUMxFxZ0jjVolHsq8xmSp82gaN0K2UZeGUpxBfuTtiZ9wT2RNNqtosn3swwl+390OPebI+KTkvYkBVPuSxq5fq9dMJrH8AD8R/6dPk7KbzWJlP+silZ6ireS3LT/oA7Jkeuakrqg6b35bF7LuD+boX5Hcv2sYjml6PF3ku67jkQ2BzegdtxS5miljeOupp5Nv1EA4whYqORC/V/AVZKeYiBmpQxFymF3KCmB4pdUnbkbanqRFdZEN9Dg3UpXpTxlTova/68y+l2RNHXxeycpLcNXIuW+WZvBC8Dt3EPqwDciTaefJi3UliVxbJR7Cl6I1p1BUh7zSUFUVdHVTb0y9iRFetfZq6JFk++n6f4fjTpumu8108og8DQpt9VwXCrpXtL3/cG8WF+6KVHmDGps9doFTe/NRvtzkGzxV5BmArfkxd/7OzVI0msY6jxSFXDXtCM+hDRrWZ56a4q1Ahgb0B4ZXuYuf3mn+kpu/O8iJUiFzvuF1PUia7QmWqDp/2sQfem11ULS3cDLSdPuurOAJue/nLQH8q0MDmAcMvJWw9xTuU6TfFhfo4FXhlLA2r4x/OZdI0IpuPMNMXj/j+sib4NaIn8cSQk/Q0oeuDrw46j2urk2v2zd4K3ftioAbQNS9PY0Bnd8nXaoXINkHnxeKV5mUkT8T4Vsra1ex4ImXnOFOp0y95bJNwq4a6v7enJHHBX5pIrf40hQRQBjm8wapDWe4v3Qcm1v9H2UnHtH0hrSLyPi+KyYj6z6fobzIuuWpv+vIfX7XJH0+sepHR0r6ZukH69u7imUUoK38mFtpZwPKyL2K5E9o+QUEdVbsV5E2kOl3XQwKl5Gkg4iBbRdSOrs3wkcG4OD6trrFDvuFwGrtnfcGogvaGWbHeSyHdWR6reT1qkGzQhj6J7hIwq405K31es1wM5RswOQdD9JKZwBXDZcPUn30CzgrmPHXSL7HeDE6JDqv8bnddp69gukEIEHKASQNh3sddG2QdtSN6g30txlHf9fkv4xqoMZ+9u0FRG/UfIrnx4RZ2TzxItH8SOamM6a5p6CZvmwmu7nMYvBcRKjSqT9P+aS3CPr7P+xCmmTpKkkU946JNfg9qSWrQDNjUlK9pJ8/nfQeX3n2Yg4qcPxFq9ncMDdoBkPQwPuWoGdlzDYlPRGOpuSes1tJDfmujtOvoK0/vJe0ja455Nirv67Qr5RwF2h4/41g01VVR33DsDBNUw9rfM3CmAkDWw2qpoRjQGlOfOGI0aeu4wouHNHCvwtBv8eT4pHKaXfZyRHk4ISN46IVygF6/wwIkb0IxbOW9w8aDrpz9EL01ntfFhqvp/HEkXuuOaRtjbeXNLKJDNeVdr2K4G9I2JRfr8q6bctda5Qymw7nbQrZHEGVjUiXolCdtgB8SHZYe8m7Yc9i7SjZrttfcTmkW5oOkNtq7sTaRH2RaTEn5+OHFOjkQfc3UdKA1+r425qTVDzAMaLgMOiyXazo0in2dIw9V7S6fhI7zcVtg8oo69nJKQF5a1JaxhECtZprMlLaLx5kJrvud10ge875KRvue4dSmncq7KH9trLqCm1syNnppKCKFv8hdTpV/EPJGeHN1JvRPxfDKx/PVuQb+dbpN9kQ5IiLJrcgupcWz2l6QxVaYfMA0l7qvwPaT1pFklZ/BBe2H7hK6RrO55kc3/hFLmsirtIpt1aHfcIzM9NAxi/SEp5chc1FOESRNnGYi26ud86zjj6XZH8JSJCUgCoYtvcpoxwjeUMUnruffP7A3PZP9b8zOuGEWm6n0evvYya8pc8C2n9VhvROb33OcDNedYWDMR7VLEnsGEDU0Yt1/FsLjtJ0ikRcVjNc/ccDc6b1eJpYG6k6P12ZpO+090i4neF8rlKO40Cg/KyLV+yvrRyhyb1uuP+Hmlx+y7qeUWeRVJ8tb0oR5kR/deiudv1qNDviuQCJd/71SX9M8n++51xakutPbe7oGnSt5Ujbb6jrBiPkfQLknIZD46mZnZkgIg4NnuetbyiDonqBH2QTDS1R8Q0dB1fkpRIZiWS+2wre+/epPQ8h0raKSLa7713kUb0eypl5gUgIraIiBdmGpIOAz4IbCip6G66KmnXxip63XE/ERGXNpB/suaa2YiQNC0iHmor2zYibslvq7ZUbvIZTVLODMdDHT+rn9dIIHkjkBa4BVzRyTOhx+34GWnvgOKe24dExM6jdP6mSd+WNC+jc0idzDOkNaebomYm3Zrn/znJzHELHUbEY7X+1Wuy19abI6eoz8rhStIMeEhyzryGMWRE337/KAV1rkGaYXy6cGhRJ/u8OiTUHA2UtrY9gJoBjJK+muVmUWPNbATtuZUUIPy7/P71wNejC5fmtvPXDg3I8quQgnGnxjBbfZfW73dFAqC0OVFxlDXmC6AavOd2kAKLPhJpC9XROP+yBbe+ZVqL0CVy50TEuyV9Emi5JH+BtP7ypYiYMxrtaYqkN5I8dV5HsvPOB66Piv1URnD+0k6sxDxTushbkB8V1/FekxXDdpEzUWcFcFNEbFK2sNpyK+1he3rdcX+PNAMblBS1yrlADTfCGkF7tiX9v95BSv74nyTF8vAonb92aECWb+TMMqR+PysSSe8nRew+Q7q5WqPKMV8AlXQWKSCpGKD3lTpeNDXP/1sGcotdExU//JLqZQS0Aum2Ja3ZfIC0re8mo3j+l+XzA9w8Xh47Y4FSao7PkpIxipRe5z9JM+Jjoi1YsemIfgTt6XXH3VUAYy9Qimz/NslZ420R0ckduem5b4mIbZXSrrwqIp6TNL+Dl+PciJhRHERIuj0itqzzef2+RvIvwGajaSLpgi1isB/3H9Q5ZUhTNiaNfg4HTpP0Y1LK+Rva5JZILyNJV5PcTWeT9lXZdjQ7eqUtAr7MQMd6sqRPRMSFo/UZSxIRcZqkn5KimFubHbVSkpRFvDdNSdK0PU13MGzKHEmbxjABjBocbzKEqAhorUvBPbrFKiQnh9OU9mwfLeeCpilnmjqzDKLfFckDpBz8SwLLqLBZTp6RjNrvE2lPggtIDgZrkBbzrqMtv8+S6mVEyhO0DSkt/NPAHyXNjsJeC13yGQrKSSk49WekNaKllW0ZcEZ4ns4dzZa9GNFLOjAivlfVgXfbcReoG8A4Gu7/nRjpfiSNaBgaAA2dWdrpd0VyFMn75iZ6s9lQE07IbRmUMmQ0PyCvA+xHMl3dwsCGW0NYwpQIEfFRAEkvJo2OzyBFTq84Sh+xTNsM5/d0zp47oVHKrbQtaUMvgI9Iek1U71JYa0Q/Alou973uwGtl+Y6aWy6PlBpu+qOGhmbtWJfkZFPWriZbfQ/9rD5fI7mZFPjXnl+pU7xBL9uzKQMpQ64ezT9tHonNJ81KZsXgvc+XeJRSnb+ONCv5DSndyS8i4ppROLdIebbWZcBrbj/Sfhuf6vb8SyLZNXeriPhbfr8sab+KqhQj95CSMPYkwemSgqRPRkrpfjIlQXjdDjI1NAfWC4cYJhdWw89pnLVDDbf6LtLvM5LFEdHRJjqWZMUx2iO+FltGxJ+GF1tiWRn4KmlDpk6BlI2JiJC0FSnKfwfSn/rUiLh4ND9nCWR1oOU8sVonQWqO6EdKHjH/M0M7slFxNmnAp0hbPzxAcpMfVWIEObBGSKOsHRrZVt8v0O+K5FpJMxmacXfcPJNGm+LISiUZRcbJjNeYiPhyjz9iNvDwkjSw6DGtSPJrGfDaqjJrjYVb8yUkJ4qfUdhyYRx4LLt4H0K9fWm6QtJLGRwwOCru/jTP2rF9e+xQE/rdtFVmLxwX999eIamVYfa1pLxZ5+f3+5JG9512AewbstvzK0hms2I23KXKdFNEafOrbUmK5Kao2EtljNpS6Zo6xu34MDkynxSE+8IhRrFvUNrB8wRSFuvHSXvO3xMRI91oq3huAf9GMtX+I2nQ8F7g3Ig4uaLOacAJIzWn97Ui6SfyyPPNEfHX/H554MoxcLucEFQFGk6UAMO6SNok0nYDpZllRysAsCmS/gO4MSJ+Oh6f306vvRaV9r95I/CziNhaKaPyARFRtVV20/PfSjLT1craobTR1qWkhJyN18D6WpEoba40hKjeDnTCkiOZX90y22UX4DkxTilPzPgg6dSImJkHFmUbH43Jxk0l7VpE8uB6DvhroT2jsvi8pFEIALwd2Doi/ibp5ojYbpTO/w3SfjG3DCuc5BcAH2Oo41GtgVS/r5FsW3i9ErAzaXFqqVMkwHEM2MQhbdB0zPg1x4wHhRHvW0kmnB1ICuUXpP1qxqtdq+bYqUFJBpdi/phd2a8Hvi/pcZICHS12At4vqa6p9rcRMeKN7Pp6RtJOzjd0zihGly5RZBfAdwP3kCJqH4mRZwM1ExhJFwB/YiCO5ABg9YiojC3qcXvKkgzeGKOUtHRJQ9IJpAwCy5AyK69G8qw8dJTO33Tjr8ZbfRfp9xlJO38mjYiWOir+qLOp3rjJLN1s3JZH6dpsZhkvjmAgyeBOykkGx7E9vWanHMPzN/I+ORqcdr8rRrC2N5Ktvl+grxVJW96bZUheTReMX4t6Sr/9UU1nbpO0feRszpJeRef9QnrNsxHxrCQkrZgdApa69TsN7NeykZrt19JTouGOme30tSJhcN6bxcBvosPWthOcvvijms5oYD+V5YGDlLJCB8n9tFfBsHVommRwonIucBkN92vpNZJWAg4FNmNwXEutgNB+VyS/BR6NiGcBJK2skp3LlhL65Y9qOvP28W5AGSNIMjghibT/y9OkNakliXOAe4FdSFtrvIu0llqLvl5slzQXeE3kfbolrQD8MiK27VxzYpOTN64GXB719yg3xiylKO9DIumOiNgix5ldUdcdvN9nJMsVO9KI+EtWJks1Y5mB1BgzIWi5Hv9R0uakwMRpdSsvtWmya/JETlUAgKTdgSVhkytjjBlLTs1Byp8l7Y56N3B83cr9btraiORHv24uehh4d0Q8MH6tMsaYsUXSxxnwYG1ld/0jKR/f/GHr97MiaZEjTBURi8a7LcYYM9ZIOpe0f8mluehtpM3vNiHtY/KljvX7WZHkSPajSSm0IW09+/nsWWGMMX2BpCuAvSPif/P7F5O2md6TNCvpmGK+39dITgcWkbacfScpZcQZ49oiY4wZe6YCRQ/OvwLrR8QzFFKmVNHvXlsbRcTehfefkzSsPdAYY5YyzgXmSLokv38HcF7eEGvYQNV+N23NBj4RETfk968FvhIRrx7flhljzNgiaRsGtpq+ISLm1q7b54pkS1LK+NZ+1U8BB0fEqCVPM8aYpZ2+VCSSivtyi7ShDqS8/RERXx37VhljzMSkX9dIVs3PG5My4l5CUigHkjaaMcYYU5O+nJG0kHQlyeVtUX6/KslnetfxbZkxxkwc+t39t93l7S80yC9jjDGmf01bLc4BbpZ0MSk9wJ7k3cqMMcbUo69NWwCSXgm8Lr+9PiJuG8/2GGPMRKPvFYkxxpju6Pc1EmOMMV1iRWKMMaYrrEiMMcZ0hRWJMcaYrrAiMcYY0xX/Hxvcv0pX+XQrAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "ax = sns.countplot(np.concatenate(movies['genres'].dropna().values))\n",
    "ax.set_xticklabels(ax.get_xticklabels(), rotation='90');"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Ratings"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYkAAAD4CAYAAAAZ1BptAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjEsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+j8jraAAAVgUlEQVR4nO3df6zd9X3f8eerOCFWEgg/wpVlo5kMqxs/lh9YjCpTdDdXxU2mwSSQXLHhTpYsIdqlEtNkVmlr/7AUJlFWWEHzRoZhrGDRRrZa0RaZXlWTiKlpSYwhjJvggYuHRyAUR4LG7L0/zueux5f7ub6+PnDPrZ8P6eh8z/t8P5/7efuL8/L3+z33JFWFJElz+amlXoAkaXwZEpKkLkNCktRlSEiSugwJSVLXiqVewGJdeOGFtXbt2kWN/fGPf8wnP/nJ0S5oCdnPeLOf8Xam9fPMM8+8UVWfXeh8yzYk1q5dy/79+xc1dmpqisnJydEuaAnZz3izn/F2pvWT5H+dynxebpIkdRkSkqQuQ0KS1GVISJK6DAlJUpchIUnqMiQkSV2GhCSpy5CQJHUt29+4Ph0H/uJtfnHb7y/Jzz70ja8tyc+VpMXwTEKS1GVISJK6DAlJUpchIUnqWlBIJPlMkseSfC/JC0l+Jsn5SZ5I8lJ7Pm9o/9uTTCd5Mcm1Q/Wrkhxo792dJK1+dpJHW31fkrWjblSSdOoWeibxm8AfVNXfAT4PvABsA/ZW1Tpgb3tNksuATcDlwEbg3iRntXnuA7YC69pjY6tvAd6qqkuBu4A7TrMvSdIInDQkkpwDfAW4H6Cq/qqqfgRcB+xsu+0Erm/b1wGPVNV7VfUyMA1cnWQVcE5VPVVVBTw4a8zMXI8BG2bOMiRJS2chvyfxOeD/AP81yeeBZ4CvAxNVdQSgqo4kuajtvxr49tD4w632k7Y9uz4z5tU21/EkbwMXAG8MLyTJVgZnIkxMTDA1NbWwLmeZWAm3XXl8UWNP12LXPJ9jx459KPMuFfsZb/Yz3kbdz0JCYgXwJeCXq2pfkt+kXVrqmOsMoOapzzfmxELVDmAHwPr162ux/5eD9zy8mzsPLM3vER66aXLkc55p//eLy439jDf7md9C7kkcBg5X1b72+jEGofF6u4REez46tP/FQ+PXAK+1+po56ieMSbICOBd481SbkSSN1klDoqr+N/Bqkp9upQ3A88AeYHOrbQZ2t+09wKb2iaVLGNygfrpdmnonyTXtfsPNs8bMzHUD8GS7byFJWkILvebyy8DDST4O/AD4FwwCZleSLcArwI0AVXUwyS4GQXIcuLWq3m/z3AI8AKwEHm8PGNwUfyjJNIMziE2n2ZckaQQWFBJV9Sywfo63NnT23w5sn6O+H7hijvq7tJCRJI0Pf+NaktRlSEiSugwJSVKXISFJ6jIkJEldhoQkqcuQkCR1GRKSpC5DQpLUZUhIkroMCUlSlyEhSeoyJCRJXYaEJKnLkJAkdRkSkqQuQ0KS1GVISJK6DAlJUpchIUnqMiQkSV2GhCSpy5CQJHUZEpKkrgWFRJJDSQ4keTbJ/lY7P8kTSV5qz+cN7X97kukkLya5dqh+VZtnOsndSdLqZyd5tNX3JVk72jYlSYtxKmcS/7CqvlBV69vrbcDeqloH7G2vSXIZsAm4HNgI3JvkrDbmPmArsK49Nrb6FuCtqroUuAu4Y/EtSZJG5XQuN10H7GzbO4Hrh+qPVNV7VfUyMA1cnWQVcE5VPVVVBTw4a8zMXI8BG2bOMiRJS2fFAvcr4I+SFPCfqmoHMFFVRwCq6kiSi9q+q4FvD4093Go/aduz6zNjXm1zHU/yNnAB8MbwIpJsZXAmwsTEBFNTUwtc/okmVsJtVx5f1NjTtdg1z+fYsWMfyrxLxX7Gm/2Mt1H3s9CQ+HJVvdaC4Ikk35tn37nOAGqe+nxjTiwMwmkHwPr162tycnLeRffc8/Bu7jyw0NZH69BNkyOfc2pqisX+WYwj+xlv9jPeRt3Pgi43VdVr7fko8C3gauD1dgmJ9ny07X4YuHho+BrgtVZfM0f9hDFJVgDnAm+eejuSpFE6aUgk+WSST89sAz8HPAfsATa33TYDu9v2HmBT+8TSJQxuUD/dLk29k+Sadr/h5lljZua6AXiy3beQJC2hhVxzmQC+1e4jrwD+e1X9QZI/BXYl2QK8AtwIUFUHk+wCngeOA7dW1fttrluAB4CVwOPtAXA/8FCSaQZnEJtG0Jsk6TSdNCSq6gfA5+eo/xDY0BmzHdg+R30/cMUc9XdpISNJGh/+xrUkqcuQkCR1GRKSpC5DQpLUZUhIkroMCUlSlyEhSeoyJCRJXYaEJKnLkJAkdRkSkqQuQ0KS1GVISJK6DAlJUpchIUnqMiQkSV2GhCSpy5CQJHUZEpKkLkNCktRlSEiSugwJSVKXISFJ6jIkJEldCw6JJGcl+fMkv9den5/kiSQvtefzhva9Pcl0kheTXDtUvyrJgfbe3UnS6mcnebTV9yVZO7oWJUmLdSpnEl8HXhh6vQ3YW1XrgL3tNUkuAzYBlwMbgXuTnNXG3AdsBda1x8ZW3wK8VVWXAncBdyyqG0nSSC0oJJKsAb4G/Jeh8nXAzra9E7h+qP5IVb1XVS8D08DVSVYB51TVU1VVwIOzxszM9RiwYeYsQ5K0dFYscL//APxr4NNDtYmqOgJQVUeSXNTqq4FvD+13uNV+0rZn12fGvNrmOp7kbeAC4I3hRSTZyuBMhImJCaampha4/BNNrITbrjy+qLGna7Frns+xY8c+lHmXiv2MN/sZb6Pu56QhkeQfA0er6pkkkwuYc64zgJqnPt+YEwtVO4AdAOvXr6/JyYUs54PueXg3dx5YaD6O1qGbJkc+59TUFIv9sxhH9jPe7Ge8jbqfhfwv5ZeBf5Lkq8AngHOS/Dfg9SSr2lnEKuBo2/8wcPHQ+DXAa62+Zo768JjDSVYA5wJvLrInSdKInPSeRFXdXlVrqmotgxvST1bVPwP2AJvbbpuB3W17D7CpfWLpEgY3qJ9ul6beSXJNu99w86wxM3Pd0H7GB84kJEkfrdO55vINYFeSLcArwI0AVXUwyS7geeA4cGtVvd/G3AI8AKwEHm8PgPuBh5JMMziD2HQa65IkjcgphURVTQFTbfuHwIbOftuB7XPU9wNXzFF/lxYykqTx4W9cS5K6DAlJUpchIUnqMiQkSV2GhCSpy5CQJHUZEpKkLkNCktRlSEiSugwJSVKXISFJ6jIkJEldhoQkqcuQkCR1GRKSpC5DQpLUZUhIkroMCUlSlyEhSeoyJCRJXYaEJKnLkJAkdRkSkqQuQ0KS1HXSkEjyiSRPJ/lOkoNJfr3Vz0/yRJKX2vN5Q2NuTzKd5MUk1w7Vr0pyoL13d5K0+tlJHm31fUnWjr5VSdKpWsiZxHvAP6qqzwNfADYmuQbYBuytqnXA3vaaJJcBm4DLgY3AvUnOanPdB2wF1rXHxlbfArxVVZcCdwF3jKA3SdJpOmlI1MCx9vJj7VHAdcDOVt8JXN+2rwMeqar3quplYBq4Oskq4JyqeqqqCnhw1piZuR4DNsycZUiSls6KhezUzgSeAS4Ffquq9iWZqKojAFV1JMlFbffVwLeHhh9utZ+07dn1mTGvtrmOJ3kbuAB4Y9Y6tjI4E2FiYoKpqakFtnmiiZVw25XHFzX2dC12zfM5duzYhzLvUrGf8WY/423U/SwoJKrqfeALST4DfCvJFfPsPtcZQM1Tn2/M7HXsAHYArF+/viYnJ+dbdtc9D+/mzgMLan3kDt00OfI5p6amWOyfxTiyn/FmP+Nt1P2c0qebqupHwBSDewmvt0tItOejbbfDwMVDw9YAr7X6mjnqJ4xJsgI4F3jzVNYmSRq9hXy66bPtDIIkK4GfBb4H7AE2t902A7vb9h5gU/vE0iUMblA/3S5NvZPkmna/4eZZY2bmugF4st23kCQtoYVcc1kF7Gz3JX4K2FVVv5fkKWBXki3AK8CNAFV1MMku4HngOHBru1wFcAvwALASeLw9AO4HHkoyzeAMYtMompMknZ6ThkRVfRf44hz1HwIbOmO2A9vnqO8HPnA/o6repYWMJGl8+BvXkqQuQ0KS1GVISJK6DAlJUpchIUnqMiQkSV2GhCSpy5CQJHUZEpKkLkNCktRlSEiSugwJSVKXISFJ6jIkJEldhoQkqcuQkCR1GRKSpC5DQpLUZUhIkroMCUlSlyEhSeoyJCRJXYaEJKnLkJAkdZ00JJJcnOSPk7yQ5GCSr7f6+UmeSPJSez5vaMztSaaTvJjk2qH6VUkOtPfuTpJWPzvJo62+L8na0bcqSTpVCzmTOA7cVlV/F7gGuDXJZcA2YG9VrQP2tte09zYBlwMbgXuTnNXmug/YCqxrj42tvgV4q6ouBe4C7hhBb5Kk03TSkKiqI1X1Z237HeAFYDVwHbCz7bYTuL5tXwc8UlXvVdXLwDRwdZJVwDlV9VRVFfDgrDEzcz0GbJg5y5AkLZ1TuifRLgN9EdgHTFTVERgECXBR22018OrQsMOttrptz66fMKaqjgNvAxecytokSaO3YqE7JvkU8DvAr1TVX87zD/253qh56vONmb2GrQwuVzExMcHU1NRJVj23iZVw25XHFzX2dC12zfM5duzYhzLvUrGf8WY/423U/SwoJJJ8jEFAPFxVv9vKrydZVVVH2qWko61+GLh4aPga4LVWXzNHfXjM4SQrgHOBN2evo6p2ADsA1q9fX5OTkwtZ/gfc8/Bu7jyw4HwcqUM3TY58zqmpKRb7ZzGO7Ge82c94G3U/C/l0U4D7gReq6jeG3toDbG7bm4HdQ/VN7RNLlzC4Qf10uyT1TpJr2pw3zxozM9cNwJPtvoUkaQkt5J/TXwb+OXAgybOt9m+AbwC7kmwBXgFuBKiqg0l2Ac8z+GTUrVX1fht3C/AAsBJ4vD1gEEIPJZlmcAax6TT7kiSNwElDoqr+B3PfMwDY0BmzHdg+R30/cMUc9XdpISNJGh/+xrUkqcuQkCR1GRKSpC5DQpLUZUhIkroMCUlSlyEhSeoyJCRJXYaEJKnLkJAkdRkSkqQuQ0KS1GVISJK6DAlJUpchIUnqMiQkSV2GhCSpy5CQJHUZEpKkLkNCktRlSEiSugwJSVKXISFJ6jIkJEldJw2JJN9McjTJc0O185M8keSl9nze0Hu3J5lO8mKSa4fqVyU50N67O0la/ewkj7b6viRrR9uiJGmxFnIm8QCwcVZtG7C3qtYBe9trklwGbAIub2PuTXJWG3MfsBVY1x4zc24B3qqqS4G7gDsW24wkabROGhJV9SfAm7PK1wE72/ZO4Pqh+iNV9V5VvQxMA1cnWQWcU1VPVVUBD84aMzPXY8CGmbMMSdLSWuw9iYmqOgLQni9q9dXAq0P7HW611W17dv2EMVV1HHgbuGCR65IkjdCKEc831xlAzVOfb8wHJ0+2MrhkxcTEBFNTU4tYIkyshNuuPL6osadrsWuez7Fjxz6UeZeK/Yw3+xlvo+5nsSHxepJVVXWkXUo62uqHgYuH9lsDvNbqa+aoD485nGQFcC4fvLwFQFXtAHYArF+/viYnJxe1+Hse3s2dB0adjwtz6KbJkc85NTXFYv8sxpH9jDf7GW+j7mexl5v2AJvb9mZg91B9U/vE0iUMblA/3S5JvZPkmna/4eZZY2bmugF4st23kCQtsZP+czrJbwOTwIVJDgP/DvgGsCvJFuAV4EaAqjqYZBfwPHAcuLWq3m9T3cLgk1IrgcfbA+B+4KEk0wzOIDaNpDNJ0mk7aUhU1S903trQ2X87sH2O+n7gijnq79JCRpI0XvyNa0lSlyEhSeoyJCRJXYaEJKnLkJAkdRkSkqQuQ0KS1GVISJK6DAlJUpchIUnqMiQkSV2GhCSpy5CQJHUZEpKkLkNCktRlSEiSugwJSVKXISFJ6jIkJEldhoQkqcuQkCR1GRKSpC5DQpLUZUhIkroMCUlS19iERJKNSV5MMp1k21KvR5I0JiGR5Czgt4CfBy4DfiHJZUu7KknSiqVeQHM1MF1VPwBI8ghwHfD8kq7qQ7B22++PfM7brjzOL55k3kPf+NrIf66kv/nGJSRWA68OvT4M/P3ZOyXZCmxtL48leXGRP+9C4I1Fjh07/3IB/eSOj2gxo/E36vhgP+PuTOvnb53KZOMSEpmjVh8oVO0Adpz2D0v2V9X6051nXNjPeLOf8WY/8xuLexIMzhwuHnq9BnhtidYiSWrGJST+FFiX5JIkHwc2AXuWeE2SdMYbi8tNVXU8yS8BfwicBXyzqg5+iD/ytC9ZjRn7GW/2M97sZx6p+sClf0mSgPG53CRJGkOGhCSp64wLieX49R9JDiU5kOTZJPtb7fwkTyR5qT2fN7T/7a2/F5Ncu3Qr/2tJvpnkaJLnhmqn3EOSq9qfxXSSu5PM9fHpD12nn19L8hftOD2b5KtD741tP0kuTvLHSV5IcjDJ11t9WR6fefpZrsfnE0meTvKd1s+vt/pHc3yq6ox5MLgp/n3gc8DHge8Aly31uhaw7kPAhbNq/x7Y1ra3AXe07ctaX2cDl7R+zxqDHr4CfAl47nR6AJ4GfobB79Y8Dvz8GPXza8C/mmPfse4HWAV8qW1/Gvifbc3L8vjM089yPT4BPtW2PwbsA675qI7PmXYm8f+//qOq/gqY+fqP5eg6YGfb3glcP1R/pKreq6qXgWkGfS+pqvoT4M1Z5VPqIckq4JyqeqoG/8U/ODTmI9Xpp2es+6mqI1X1Z237HeAFBt+CsCyPzzz99Ix7P1VVx9rLj7VH8REdnzMtJOb6+o/5/uMZFwX8UZJnMvhqEoCJqjoCg78UwEWtvpx6PNUeVrft2fVx8ktJvtsuR82c/i+bfpKsBb7I4F+ry/74zOoHlunxSXJWkmeBo8ATVfWRHZ8zLSQW9PUfY+jLVfUlBt+Se2uSr8yz73LtcVivh3Hv7T7gbwNfAI4Ad7b6sugnyaeA3wF+par+cr5d56gth36W7fGpqver6gsMvo3i6iRXzLP7SPs500JiWX79R1W91p6PAt9icPno9Xb6SHs+2nZfTj2eag+H2/bs+lioqtfbX+b/C/xn/voy39j3k+RjDP4H9eGq+t1WXrbHZ65+lvPxmVFVPwKmgI18RMfnTAuJZff1H0k+meTTM9vAzwHPMVj35rbbZmB3294DbEpydpJLgHUMblaNo1PqoZ1Sv5PkmvapjJuHxiy5mb+wzT9lcJxgzPtpP/t+4IWq+o2ht5bl8en1s4yPz2eTfKZtrwR+FvgeH9Xx+ajv1C/1A/gqg087fB/41aVezwLW+zkGn1T4DnBwZs3ABcBe4KX2fP7QmF9t/b3IEn36Z44+fpvBKf5PGPyLZstiegDWM/jL/X3gP9K+NWBM+nkIOAB8t/1FXbUc+gH+AYPLDt8Fnm2Pry7X4zNPP8v1+Pw94M/bup8D/m2rfyTHx6/lkCR1nWmXmyRJp8CQkCR1GRKSpC5DQpLUZUhIkroMCUlSlyEhSer6fwce8hr8TgaAAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "ratings_user = ratings.groupby('user_id')['rating'].count()\n",
    "ratings_user.hist();"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "count    62798.000000\n",
       "mean        13.654336\n",
       "std         48.884962\n",
       "min          1.000000\n",
       "25%          1.000000\n",
       "50%          2.000000\n",
       "75%          8.000000\n",
       "max       2926.000000\n",
       "Name: rating, dtype: float64"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ratings_user.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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_url</th>\n",
       "      <th>n_ratings</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>23252</th>\n",
       "      <td>https://twitter.com/i/user/229985772</td>\n",
       "      <td>2926</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12738</th>\n",
       "      <td>https://twitter.com/i/user/22832104</td>\n",
       "      <td>2075</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36921</th>\n",
       "      <td>https://twitter.com/i/user/363853315</td>\n",
       "      <td>2058</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46669</th>\n",
       "      <td>https://twitter.com/i/user/43349934</td>\n",
       "      <td>1858</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61281</th>\n",
       "      <td>https://twitter.com/i/user/101459318</td>\n",
       "      <td>1606</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                   user_url  n_ratings\n",
       "23252  https://twitter.com/i/user/229985772       2926\n",
       "12738   https://twitter.com/i/user/22832104       2075\n",
       "36921  https://twitter.com/i/user/363853315       2058\n",
       "46669   https://twitter.com/i/user/43349934       1858\n",
       "61281  https://twitter.com/i/user/101459318       1606"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "active_users = (\n",
    "    pd.DataFrame(ratings_user)\n",
    "        .merge(users, 'left', 'user_id')\n",
    "        .drop(columns='user_id')\n",
    "        .sort_values('rating', ascending=False)\n",
    ")\n",
    "active_users = (\n",
    "    active_users\n",
    "        .drop(columns='twitter_id')\n",
    "        .join(active_users['twitter_id'].apply(user_url))\n",
    ")\n",
    "active_users = active_users[['twitter_id', 'rating']]\n",
    "active_users.columns = ['user_url', 'n_ratings']\n",
    "active_users.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYQAAAD4CAYAAADsKpHdAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjEsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+j8jraAAAXIUlEQVR4nO3dfYyd5Znf8e8vNkusEAgvyciyrZpd/Mfy0jhh5LpKu5os6eLQSiYSSI5Q7CqWHCGiJhKVCrtSN1FkKVRykGADqiMiDKUxFgmytQ1tEWQUrcRLTEpiDKFMFjc4trBYCGGiQjG5+se5J3sYjuflzOA5Hn8/0qPzzHWe+5n7msPwm+flHKeqkCTpAws9AUnSYDAQJEmAgSBJagwESRJgIEiSmqULPYF+XXDBBbV69eq+xv7ud7/jQx/60PxOaAEshj7sYXAshj7sYXpPPfXUK1X10V7PnbKBsHr1avbv39/X2NHRUUZGRuZ3QgtgMfRhD4NjMfRhD9NL8n9O9JynjCRJgIEgSWoMBEkSYCBIkhoDQZIEGAiSpGbaQEjywSRPJvlZkoNJvt7qX0vy6yRPt+WqrjE3JxlL8nySK7vqlyc50J67LUla/cwk97f6E0lWz3+rkqSpzOQI4S3gz6vq48BaYEOS9e25W6tqbVt+CJDkYmATcAmwAbgjyZK2/Z3ANmBNWza0+lbgtaq6CLgVuGXurUmSZmPaQKiO8fblGW2Z6h9R2Ajsrqq3qupFYAxYl2Q5cHZVPVadf4ThHuDqrjG72voDwBUTRw+SpJNjRu9Ubn/hPwVcBHy7qp5I8lngy0k2A/uBG6vqNWAF8HjX8MOt9nZbn1ynPb4EUFXHk7wOnA+8Mmke2+gcYTA0NMTo6OjMO+1y7NXXuf2+vX2NnavLVpwzb/saHx/v+2cwKOxhcCyGPuxhbmYUCFX1DrA2yUeAB5NcSuf0zzfoHC18A9gBfBHo9Zd9TVFnmue657ET2AkwPDxc/b69+/b79rLjwMJ8aseh60bmbV++TX8wLIYeYHH0YQ9zM6u7jKrqN8AosKGqXq6qd6rq98B3gHVts8PAqq5hK4Ejrb6yR/1dY5IsBc4BXp1VJ5KkOZnJXUYfbUcGJFkGfAb4RbsmMOFzwDNtfR+wqd05dCGdi8dPVtVR4I0k69v1gc3A3q4xW9r6NcCj5T/2LEkn1UzOmywHdrXrCB8A9lTV3ya5N8laOqd2DgFfAqiqg0n2AM8Cx4Eb2ikngOuBu4FlwENtAbgLuDfJGJ0jg03z0JskaRamDYSq+jnwiR71L0wxZjuwvUd9P3Bpj/qbwLXTzUWS9P7xncqSJMBAkCQ1BoIkCTAQJEmNgSBJAgwESVJjIEiSAANBktQYCJIkwECQJDUGgiQJMBAkSY2BIEkCDARJUmMgSJIAA0GS1BgIkiTAQJAkNQaCJAkwECRJzbSBkOSDSZ5M8rMkB5N8vdXPS/Jwkhfa47ldY25OMpbk+SRXdtUvT3KgPXdbkrT6mUnub/Unkqye/1YlSVOZyRHCW8CfV9XHgbXAhiTrgZuAR6pqDfBI+5okFwObgEuADcAdSZa0fd0JbAPWtGVDq28FXquqi4BbgVvmoTdJ0ixMGwjVMd6+PKMtBWwEdrX6LuDqtr4R2F1Vb1XVi8AYsC7JcuDsqnqsqgq4Z9KYiX09AFwxcfQgSTo5ls5ko/YX/lPARcC3q+qJJENVdRSgqo4m+VjbfAXweNfww632dlufXJ8Y81Lb1/EkrwPnA69Mmsc2OkcYDA0NMTo6OsM2321oGdx42fG+xs5Vv3PuZXx8fF73txDsYXAshj7sYW5mFAhV9Q6wNslHgAeTXDrF5r3+sq8p6lONmTyPncBOgOHh4RoZGZlq2id0+3172XFgRq3Pu0PXjczbvkZHR+n3ZzAo7GFwLIY+7GFuZnWXUVX9Bhilc+7/5XYaiPZ4rG12GFjVNWwlcKTVV/aov2tMkqXAOcCrs5mbJGluZnKX0UfbkQFJlgGfAX4B7AO2tM22AHvb+j5gU7tz6EI6F4+fbKeX3kiyvl0f2DxpzMS+rgEebdcZJEknyUzOmywHdrXrCB8A9lTV3yZ5DNiTZCvwK+BagKo6mGQP8CxwHLihnXICuB64G1gGPNQWgLuAe5OM0Tky2DQfzUmSZm7aQKiqnwOf6FH/B+CKE4zZDmzvUd8PvOf6Q1W9SQsUSdLC8J3KkiTAQJAkNQaCJAkwECRJjYEgSQIMBElSYyBIkgADQZLUGAiSJMBAkCQ1BoIkCTAQJEmNgSBJAgwESVJjIEiSAANBktQYCJIkwECQJDUGgiQJMBAkSY2BIEkCZhAISVYl+VGS55IcTPKVVv9akl8nebotV3WNuTnJWJLnk1zZVb88yYH23G1J0upnJrm/1Z9Isnr+W5UkTWUmRwjHgRur6k+B9cANSS5uz91aVWvb8kOA9twm4BJgA3BHkiVt+zuBbcCatmxo9a3Aa1V1EXArcMvcW5Mkzca0gVBVR6vqp239DeA5YMUUQzYCu6vqrap6ERgD1iVZDpxdVY9VVQH3AFd3jdnV1h8Arpg4epAknRxLZ7NxO5XzCeAJ4FPAl5NsBvbTOYp4jU5YPN417HCrvd3WJ9dpjy8BVNXxJK8D5wOvTPr+2+gcYTA0NMTo6Ohspv8HQ8vgxsuO9zV2rvqdcy/j4+Pzur+FYA+DYzH0YQ9zM+NASHIW8H3gq1X12yR3At8Aqj3uAL4I9PrLvqaoM81z/1io2gnsBBgeHq6RkZGZTv9dbr9vLzsOzCoL582h60bmbV+jo6P0+zMYFPYwOBZDH/YwNzO6yyjJGXTC4L6q+gFAVb1cVe9U1e+B7wDr2uaHgVVdw1cCR1p9ZY/6u8YkWQqcA7zaT0OSpP7M5C6jAHcBz1XVt7rqy7s2+xzwTFvfB2xqdw5dSOfi8ZNVdRR4I8n6ts/NwN6uMVva+jXAo+06gyTpJJnJeZNPAV8ADiR5utX+Evh8krV0Tu0cAr4EUFUHk+wBnqVzh9INVfVOG3c9cDewDHioLdAJnHuTjNE5Mtg0t7YkSbM1bSBU1d/R+xz/D6cYsx3Y3qO+H7i0R/1N4Nrp5iJJev/4TmVJEmAgSJIaA0GSBBgIkqTGQJAkAQaCJKkxECRJgIEgSWoMBEkSYCBIkhoDQZIEGAiSpMZAkCQBBoIkqTEQJEmAgSBJagwESRJgIEiSGgNBkgQYCJKkZtpASLIqyY+SPJfkYJKvtPp5SR5O8kJ7PLdrzM1JxpI8n+TKrvrlSQ60525LklY/M8n9rf5EktXz36okaSozOUI4DtxYVX8KrAduSHIxcBPwSFWtAR5pX9Oe2wRcAmwA7kiypO3rTmAbsKYtG1p9K/BaVV0E3ArcMg+9SZJmYdpAqKqjVfXTtv4G8BywAtgI7Gqb7QKubusbgd1V9VZVvQiMAeuSLAfOrqrHqqqAeyaNmdjXA8AVE0cPkqSTY+lsNm6ncj4BPAEMVdVR6IRGko+1zVYAj3cNO9xqb7f1yfWJMS+1fR1P8jpwPvDKpO+/jc4RBkNDQ4yOjs5m+n8wtAxuvOx4X2Pnqt859zI+Pj6v+1sI9jA4FkMf9jA3Mw6EJGcB3we+WlW/neIP+F5P1BT1qca8u1C1E9gJMDw8XCMjI9PMurfb79vLjgOzysJ5c+i6kXnb1+joKP3+DAaFPQyOxdCHPczNjO4ySnIGnTC4r6p+0Movt9NAtMdjrX4YWNU1fCVwpNVX9qi/a0ySpcA5wKuzbUaS1L+Z3GUU4C7guar6VtdT+4AtbX0LsLervqndOXQhnYvHT7bTS28kWd/2uXnSmIl9XQM82q4zSJJOkpmcN/kU8AXgQJKnW+0vgW8Ce5JsBX4FXAtQVQeT7AGepXOH0g1V9U4bdz1wN7AMeKgt0Amce5OM0Tky2DTHviRJszRtIFTV39H7HD/AFScYsx3Y3qO+H7i0R/1NWqBIkhaG71SWJAEGgiSpMRAkSYCBIElqDARJEmAgSJIaA0GSBBgIkqTGQJAkAQaCJKkxECRJgIEgSWoMBEkSYCBIkhoDQZIEGAiSpMZAkCQBBoIkqTEQJEmAgSBJagwESRIwg0BI8t0kx5I801X7WpJfJ3m6LVd1PXdzkrEkzye5sqt+eZID7bnbkqTVz0xyf6s/kWT1/LYoSZqJmRwh3A1s6FG/tarWtuWHAEkuBjYBl7QxdyRZ0ra/E9gGrGnLxD63Aq9V1UXArcAtffYiSZqDaQOhqn4MvDrD/W0EdlfVW1X1IjAGrEuyHDi7qh6rqgLuAa7uGrOrrT8AXDFx9CBJOnmWzmHsl5NsBvYDN1bVa8AK4PGubQ632tttfXKd9vgSQFUdT/I6cD7wyuRvmGQbnaMMhoaGGB0d7WviQ8vgxsuO9zV2rvqdcy/j4+Pzur+FYA+DYzH0YQ9z028g3Al8A6j2uAP4ItDrL/uaos40z727WLUT2AkwPDxcIyMjs5r0hNvv28uOA3PJwv4dum5k3vY1OjpKvz+DQWEPg2Mx9GEPc9PXXUZV9XJVvVNVvwe+A6xrTx0GVnVtuhI40uore9TfNSbJUuAcZn6KSpI0T/oKhHZNYMLngIk7kPYBm9qdQxfSuXj8ZFUdBd5Isr5dH9gM7O0as6WtXwM82q4zSJJOomnPmyT5HjACXJDkMPDXwEiStXRO7RwCvgRQVQeT7AGeBY4DN1TVO21X19O5Y2kZ8FBbAO4C7k0yRufIYNN8NCZJmp1pA6GqPt+jfNcU228Htveo7wcu7VF/E7h2unlIkt5fvlNZkgQYCJKkxkCQJAEGgiSpMRAkSYCBIElqDARJEmAgSJIaA0GSBBgIkqTGQJAkAQaCJKkxECRJgIEgSWoMBEkSYCBIkhoDQZIEGAiSpMZAkCQBBoIkqZk2EJJ8N8mxJM901c5L8nCSF9rjuV3P3ZxkLMnzSa7sql+e5EB77rYkafUzk9zf6k8kWT2/LUqSZmImRwh3Axsm1W4CHqmqNcAj7WuSXAxsAi5pY+5IsqSNuRPYBqxpy8Q+twKvVdVFwK3ALf02I0nq37SBUFU/Bl6dVN4I7Grru4Cru+q7q+qtqnoRGAPWJVkOnF1Vj1VVAfdMGjOxrweAKyaOHiRJJ0+/1xCGquooQHv8WKuvAF7q2u5wq61o65Pr7xpTVceB14Hz+5yXJKlPS+d5f73+sq8p6lONee/Ok210TjsxNDTE6OhoH1OEoWVw42XH+xo7V/3OuZfx8fF53d9CsIfBsRj6sIe56TcQXk6yvKqOttNBx1r9MLCqa7uVwJFWX9mj3j3mcJKlwDm89xQVAFW1E9gJMDw8XCMjI31N/vb79rLjwHxn4cwcum5k3vY1OjpKvz+DQWEPg2Mx9GEPc9PvKaN9wJa2vgXY21Xf1O4cupDOxeMn22mlN5Ksb9cHNk8aM7Gva4BH23UGSdJJNO2fyUm+B4wAFyQ5DPw18E1gT5KtwK+AawGq6mCSPcCzwHHghqp6p+3qejp3LC0DHmoLwF3AvUnG6BwZbJqXziRJszJtIFTV50/w1BUn2H47sL1HfT9waY/6m7RAkSQtHN+pLEkCDARJUmMgSJIAA0GS1BgIkiTAQJAkNQaCJAkwECRJjYEgSQIMBElSYyBIkgADQZLUGAiSJMBAkCQ1BoIkCTAQJEmNgSBJAgwESVJjIEiSAANBktQYCJIkYI6BkORQkgNJnk6yv9XOS/Jwkhfa47ld29+cZCzJ80mu7Kpf3vYzluS2JJnLvCRJszcfRwifrqq1VTXcvr4JeKSq1gCPtK9JcjGwCbgE2ADckWRJG3MnsA1Y05YN8zAvSdIsvB+njDYCu9r6LuDqrvruqnqrql4ExoB1SZYDZ1fVY1VVwD1dYyRJJ0k6/w/uc3DyIvAaUMB/rqqdSX5TVR/p2ua1qjo3yd8Aj1fVf2n1u4CHgEPAN6vqM63+L4H/UFX/psf320bnSIKhoaHLd+/e3de8j736Oi//376GztllK86Zt32Nj49z1llnzdv+FoI9DI7F0Ic9TO/Tn/70U11ndN5l6Rz3/amqOpLkY8DDSX4xxba9rgvUFPX3Fqt2AjsBhoeHa2RkZJbT7bj9vr3sODDX1vtz6LqRedvX6Ogo/f4MBoU9DI7F0Ic9zM2cThlV1ZH2eAx4EFgHvNxOA9Eej7XNDwOruoavBI60+soedUnSSdR3ICT5UJIPT6wDfwE8A+wDtrTNtgB72/o+YFOSM5NcSOfi8ZNVdRR4I8n6dnfR5q4xkqSTZC7nTYaAB9sdokuB/1pV/z3JT4A9SbYCvwKuBaiqg0n2AM8Cx4Ebquqdtq/rgbuBZXSuKzw0h3lJkvrQdyBU1d8DH+9R/wfgihOM2Q5s71HfD1za71wkSXPnO5UlSYCBIElqDARJEmAgSJIaA0GSBBgIkqTGQJAkAQaCJKkxECRJgIEgSWoMBEkSYCBIkhoDQZIEGAiSpMZAkCQBBoIkqTEQJEmAgSBJagwESRJgIEiSGgNBkgQMUCAk2ZDk+SRjSW5a6PlI0ulm6UJPACDJEuDbwL8CDgM/SbKvqp5d2JnNv9U3/bd529eNlx3n385wf4e++a/n7ftKWpwGIhCAdcBYVf09QJLdwEZg0QXCQpnPIJpPswm12TIEpdkZlEBYAbzU9fVh4J9N3ijJNmBb+3I8yfN9fr8LgFf6HDsw/t0i6OP97CG3vB977emUfx2axdCHPUzvn5zoiUEJhPSo1XsKVTuBnXP+Zsn+qhqe634W2mLowx4Gx2Lowx7mZlAuKh8GVnV9vRI4skBzkaTT0qAEwk+ANUkuTPJHwCZg3wLPSZJOKwNxyqiqjif5MvA/gCXAd6vq4Pv4Led82mlALIY+7GFwLIY+7GEOUvWeU/WSpNPQoJwykiQtMANBkgSchoFwKn1ERpJDSQ4keTrJ/lY7L8nDSV5oj+d2bX9z6+v5JFcu0Jy/m+RYkme6arOec5LLW+9jSW5L0uvW5JPdx9eS/Lq9Hk8nuWqQ+0iyKsmPkjyX5GCSr7T6KfN6TNHDKfNaJPlgkieT/Kz18PVWH7zXoapOm4XOBetfAn8M/BHwM+DihZ7XFPM9BFwwqfafgJva+k3ALW394tbPmcCFrc8lCzDnPwM+CTwzlzkDTwL/nM57VB4CPjsAfXwN+Pc9th3IPoDlwCfb+oeB/93mesq8HlP0cMq8Fu37ndXWzwCeANYP4utwuh0h/OEjMqrq/wETH5FxKtkI7Grru4Cru+q7q+qtqnoRGKPT70lVVT8GXp1UntWckywHzq6qx6rzW3BP15iT4gR9nMhA9lFVR6vqp239DeA5Op8KcMq8HlP0cCKD2ENV1Xj78oy2FAP4OpxugdDrIzKm+o9roRXwP5M8lc7HdgAMVdVR6PyyAB9r9UHubbZzXtHWJ9cHwZeT/LydUpo4xB/4PpKsBj5B56/TU/L1mNQDnEKvRZIlSZ4GjgEPV9VAvg6nWyDM6CMyBsinquqTwGeBG5L82RTbnmq9wYnnPKi93An8CbAWOArsaPWB7iPJWcD3ga9W1W+n2rRHbSD66NHDKfVaVNU7VbWWzqcwrEty6RSbL1gPp1sgnFIfkVFVR9rjMeBBOqeAXm6HjrTHY23zQe5ttnM+3NYn1xdUVb3cfrF/D3yHfzwlN7B9JDmDzv9I76uqH7TyKfV69OrhVHwtAKrqN8AosIEBfB1Ot0A4ZT4iI8mHknx4Yh34C+AZOvPd0jbbAuxt6/uATUnOTHIhsIbOBahBMKs5t8PnN5Ksb3dRbO4as2Amfnmbz9F5PWBA+2jf8y7guar6VtdTp8zrcaIeTqXXIslHk3ykrS8DPgP8gkF8HU7GVfZBWoCr6Nyp8EvgrxZ6PlPM84/p3GnwM+DgxFyB84FHgBfa43ldY/6q9fU8J/munK45fI/OIfzbdP6i2drPnIFhOr/kvwT+hvau+gXu417gAPBzOr+0ywe5D+Bf0Dml8HPg6bZcdSq9HlP0cMq8FsA/Bf5Xm+szwH9s9YF7HfzoCkkScPqdMpIknYCBIEkCDARJUmMgSJIAA0GS1BgIkiTAQJAkNf8faZPCi8paENQAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "ratings_movie = ratings.groupby('imdb_id')['rating'].count()\n",
    "ratings_movie.hist();"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "count    35611.000000\n",
       "mean        24.078655\n",
       "std        111.876631\n",
       "min          1.000000\n",
       "25%          1.000000\n",
       "50%          2.000000\n",
       "75%          7.000000\n",
       "max       3086.000000\n",
       "Name: rating, dtype: float64"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ratings_movie.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>title</th>\n",
       "      <th>movie_url</th>\n",
       "      <th>n_ratings</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>18684</th>\n",
       "      <td>Gravity</td>\n",
       "      <td>https://www.imdb.com/title/tt1454468/</td>\n",
       "      <td>3086</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15592</th>\n",
       "      <td>Interstellar</td>\n",
       "      <td>https://www.imdb.com/title/tt0816692/</td>\n",
       "      <td>2851</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16299</th>\n",
       "      <td>The Wolf of Wall Street</td>\n",
       "      <td>https://www.imdb.com/title/tt0993846/</td>\n",
       "      <td>2787</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15292</th>\n",
       "      <td>Man of Steel</td>\n",
       "      <td>https://www.imdb.com/title/tt0770828/</td>\n",
       "      <td>2670</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33748</th>\n",
       "      <td>Joker</td>\n",
       "      <td>https://www.imdb.com/title/tt7286456/</td>\n",
       "      <td>2595</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         title                              movie_url  \\\n",
       "18684                  Gravity  https://www.imdb.com/title/tt1454468/   \n",
       "15592             Interstellar  https://www.imdb.com/title/tt0816692/   \n",
       "16299  The Wolf of Wall Street  https://www.imdb.com/title/tt0993846/   \n",
       "15292             Man of Steel  https://www.imdb.com/title/tt0770828/   \n",
       "33748                    Joker  https://www.imdb.com/title/tt7286456/   \n",
       "\n",
       "       n_ratings  \n",
       "18684       3086  \n",
       "15592       2851  \n",
       "16299       2787  \n",
       "15292       2670  \n",
       "33748       2595  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "active_movies = (\n",
    "    pd.DataFrame(ratings_movie)\n",
    "        .merge(movies[['imdb_id', 'title']], 'left', 'imdb_id')\n",
    "        .sort_values('rating', ascending=False)\n",
    ")\n",
    "active_movies = (\n",
    "    active_movies\n",
    "        .drop(columns='imdb_id')\n",
    "        .join(active_movies['imdb_id'].apply(movie_url))\n",
    ")\n",
    "active_movies = active_movies[['title', 'imdb_id', 'rating']]\n",
    "active_movies.columns= ['title', 'movie_url', 'n_ratings']\n",
    "active_movies.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYoAAAEJCAYAAACKWmBmAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjEsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+j8jraAAAbgElEQVR4nO3df5BdZZ3n8fdHoiwMEgO0LCawjRLdAdaJk57AruuIFSeJMis4C2OYLcnMxI2yUGqVWzXgbBUuVrZgZpVaagem4iYSWOWHIEN2BSGCP8pdfjWYIYSAaSBCmxgiyYaMCjMJn/3jPNc53dw+3enbt5vQn1fVrT79Pec5zzmhm0+f85x7H9kmIiJiJG+Y6gOIiIjXtgRFREQ0SlBERESjBEVERDRKUERERKMERURENJox1Qcw0Y455hj39vZO9WFERBxUHn744Z/b7mm37nUXFL29vfT390/1YUREHFQk/WSkdbn1FBERjRIUERHRKEERERGNEhQREdEoQREREY0SFBER0ShBERERjRIUERHR6HX3hruImD56L/7WuNtuvfzMCTyS17dcUURERKMERURENBo1KCQdL+m7kjZL2iTpM6V+lKT1kraUr7NqbS6RNCDpSUmLa/X5kjaWdVdJUqkfKummUn9AUm+tzbLSxxZJyyby5CMiYnRjuaLYB3zO9m8CpwMXSjoZuBi4x/Zc4J7yPWXdUuAUYAlwtaRDyr6uAVYAc8trSakvB3bbPgm4Erii7Oso4FLgNGABcGk9kCIiovtGDQrb220/Upb3ApuB2cBZwNqy2Vrg7LJ8FnCj7ZdtPwMMAAskHQccafs+2wauG9amta9bgIXlamMxsN72Ltu7gfX8Y7hERMQkOKAxinJL6D3AA8CxtrdDFSbAW8tms4Hnas0GS212WR5eH9LG9j5gD3B0w74iImKSjDkoJB0B3Ap81vaLTZu2qbmhPt429WNbIalfUv/OnTsbDi0iIg7UmIJC0hupQuJrtr9ZyjvK7STK1+dLfRA4vtZ8DrCt1Oe0qQ9pI2kGMBPY1bCvIWyvst1nu6+np+0ETRERMU5jeepJwGpgs+0v11atA1pPIS0Dbq/Vl5YnmU6kGrR+sNye2ivp9LLP84e1ae3rHODeMo5xF7BI0qwyiL2o1CIiYpKM5Z3Z7wU+DmyUtKHUPg9cDtwsaTnwLHAugO1Nkm4GHqd6YupC2/tLuwuAa4HDgDvLC6ogul7SANWVxNKyr12Svgg8VLa7zPaucZ5rRESMw6hBYfuHtB8rAFg4QpuVwMo29X7g1Db1lyhB02bdGmDNaMcZERHdkXdmR0REowRFREQ0SlBERESjfMx4RHQkH/X9+pcrioiIaJSgiIiIRgmKiIholKCIiIhGCYqIiGiUoIiIiEYJioiIaJSgiIiIRgmKiIholKCIiIhGCYqIiGiUoIiIiEZjmQp1jaTnJT1Wq90kaUN5bW3NfCepV9Kvauv+utZmvqSNkgYkXVWmQ6VMmXpTqT8gqbfWZpmkLeW1jIiImHRj+fTYa4H/DlzXKtj+WGtZ0peAPbXtn7I9r81+rgFWAPcDdwBLqKZCXQ7stn2SpKXAFcDHJB0FXAr0AQYelrTO9u6xn15ERHRq1CsK2z+gmsf6VcpVwR8CNzTtQ9JxwJG277NtqtA5u6w+C1hblm8BFpb9LgbW295VwmE9VbhERMQk6nSM4n3ADttbarUTJf1I0vclva/UZgODtW0GS6217jkA2/uork6OrtfbtImIiEnS6cRF5zH0amI7cILtFyTNB/5G0imA2rR1+TrSuqY2Q0haQXVbixNOOGGMhx4REWMx7isKSTOAPwBuatVsv2z7hbL8MPAU8E6qq4E5teZzgG1leRA4vrbPmVS3un5db9NmCNurbPfZ7uvp6RnvKUVERBud3Hr6IPCE7V/fUpLUI+mQsvx2YC7wtO3twF5Jp5fxh/OB20uzdUDriaZzgHvLOMZdwCJJsyTNAhaVWkRETKJRbz1JugE4AzhG0iBwqe3VwFJePYj9u8BlkvYB+4FP2W4NhF9A9QTVYVRPO91Z6quB6yUNUF1JLAWwvUvSF4GHynaX1fYVERGTZNSgsH3eCPU/blO7Fbh1hO37gVPb1F8Czh2hzRpgzWjHGBER3ZN3ZkdERKMERURENEpQREREowRFREQ0SlBERESjBEVERDRKUERERKMERURENEpQREREowRFREQ0SlBERESjBEVERDRKUERERKMERURENEpQREREowRFREQ0GjUoJK2R9Lykx2q1L0j6qaQN5fXh2rpLJA1IelLS4lp9vqSNZd1VZUpUJB0q6aZSf0BSb63NMklbyqs1XWpEREyisVxRXAssaVO/0va88roDQNLJVFOZnlLaXN2aQxu4BlhBNY/23No+lwO7bZ8EXAlcUfZ1FHApcBqwALi0zJ0dERGTaNSgsP0Dqrmsx+Is4EbbL9t+BhgAFkg6DjjS9n22DVwHnF1rs7Ys3wIsLFcbi4H1tnfZ3g2sp31gRUREF3UyRnGRpEfLranWX/qzgedq2wyW2uyyPLw+pI3tfcAe4OiGfUVExCQab1BcA7wDmAdsB75U6mqzrRvq420zhKQVkvol9e/cubPpuCMi4gCNKyhs77C93/YrwFeoxhCg+qv/+Nqmc4BtpT6nTX1IG0kzgJlUt7pG2le741llu892X09Pz3hOKSIiRjCuoChjDi0fBVpPRK0DlpYnmU6kGrR+0PZ2YK+k08v4w/nA7bU2rSeazgHuLeMYdwGLJM0qt7YWlVpEREyiGaNtIOkG4AzgGEmDVE8inSFpHtWtoK3AJwFsb5J0M/A4sA+40Pb+sqsLqJ6gOgy4s7wAVgPXSxqgupJYWva1S9IXgYfKdpfZHuugekRETJBRg8L2eW3Kqxu2XwmsbFPvB05tU38JOHeEfa0B1ox2jBER0T15Z3ZERDRKUERERKMERURENEpQREREowRFREQ0SlBERESjBEVERDRKUERERKMERURENEpQREREowRFREQ0SlBERESjBEVERDRKUERERKMERURENEpQREREo1GDQtIaSc9LeqxW+0tJT0h6VNJtkt5S6r2SfiVpQ3n9da3NfEkbJQ1IuqpMiUqZNvWmUn9AUm+tzTJJW8prGRERMenGckVxLbBkWG09cKrtdwM/Bi6prXvK9rzy+lStfg2wgmoe7bm1fS4Hdts+CbgSuAJA0lFU066eBiwALi1zZ0dExCQaNShs/4BqLut67W7b+8q39wNzmvYh6TjgSNv32TZwHXB2WX0WsLYs3wIsLFcbi4H1tnfZ3k0VTsMDKyIiumwixij+FLiz9v2Jkn4k6fuS3ldqs4HB2jaDpdZa9xxACZ89wNH1eps2ERExSWZ00ljSnwP7gK+V0nbgBNsvSJoP/I2kUwC1ae7WbkZY19Rm+HGsoLqtxQknnDD2E4iIiFGN+4qiDC7/PvDvyu0kbL9s+4Wy/DDwFPBOqquB+u2pOcC2sjwIHF/2OQOYSXWr69f1Nm2GsL3Kdp/tvp6envGeUkREtDGuoJC0BPgz4CO2f1mr90g6pCy/nWrQ+mnb24G9kk4v4w/nA7eXZuuA1hNN5wD3luC5C1gkaVYZxF5UahERMYlGvfUk6QbgDOAYSYNUTyJdAhwKrC9Pud5fnnD6XeAySfuA/cCnbLcGwi+geoLqMKoxjda4xmrgekkDVFcSSwFs75L0ReChst1ltX1FRMQkGTUobJ/Xprx6hG1vBW4dYV0/cGqb+kvAuSO0WQOsGe0YIyImU+/F3xp3262XnzmBRzI58s7siIholKCIiIhGCYqIiGiUoIiIiEYJioiIaJSgiIiIRgmKiIholKCIiIhGHX0oYES8dky3N4HF5MkVRURENEpQREREowRFREQ0SlBERESjBEVERDRKUERERKMERURENBo1KCStkfS8pMdqtaMkrZe0pXydVVt3iaQBSU9KWlyrz5e0say7qkyJiqRDJd1U6g9I6q21WVb62FLm6I6IiEk2liuKa4Elw2oXA/fYngvcU75H0slUU5meUtpc3ZpDG7gGWEE1j/bc2j6XA7ttnwRcCVxR9nUU1bSrpwELgEvrgRQREZNj1KCw/QOquazrzgLWluW1wNm1+o22X7b9DDAALJB0HHCk7ftsG7huWJvWvm4BFparjcXAetu7bO8G1vPqwIqIiC4b70d4HGt7O4Dt7ZLeWuqzgftr2w2W2j+U5eH1Vpvnyr72SdoDHF2vt2kTETHtdPIxLTD+j2qZ6MFstam5oT7eNkM7lVZI6pfUv3PnzjEdaEREjM14g2JHuZ1E+fp8qQ8Cx9e2mwNsK/U5bepD2kiaAcykutU10r5exfYq2322+3p6esZ5ShER0c54g2Id0HoKaRlwe62+tDzJdCLVoPWD5TbVXkmnl/GH84e1ae3rHODeMo5xF7BI0qwyiL2o1CIiYhKNOkYh6QbgDOAYSYNUTyJdDtwsaTnwLHAugO1Nkm4GHgf2ARfa3l92dQHVE1SHAXeWF8Bq4HpJA1RXEkvLvnZJ+iLwUNnuMtvDB9UjIqLLRg0K2+eNsGrhCNuvBFa2qfcDp7apv0QJmjbr1gBrRjvGiIjonrwzOyIiGiUoIiKiUYIiIiIaJSgiIqJRgiIiIholKCIiolGCIiIiGiUoIiKiUYIiIiIaJSgiIqJRgiIiIholKCIiolGCIiIiGiUoIiKiUYIiIiIaJSgiIqJRgiIiIhqNOygkvUvShtrrRUmflfQFST+t1T9ca3OJpAFJT0paXKvPl7SxrLuqzKtNmXv7plJ/QFJvJycbEREHbtxBYftJ2/NszwPmA78Ebiurr2yts30HgKSTqebDPgVYAlwt6ZCy/TXACmBueS0p9eXAbtsnAVcCV4z3eCMiYnwm6tbTQuAp2z9p2OYs4EbbL9t+BhgAFkg6DjjS9n22DVwHnF1rs7Ys3wIsbF1tRETE5JiooFgK3FD7/iJJj0paI2lWqc0GnqttM1hqs8vy8PqQNrb3AXuAo4d3LmmFpH5J/Tt37pyI84mIiKLjoJD0JuAjwDdK6RrgHcA8YDvwpdambZq7od7UZmjBXmW7z3ZfT0/PARx9RESMZiKuKD4EPGJ7B4DtHbb3234F+AqwoGw3CBxfazcH2Fbqc9rUh7SRNAOYCeyagGOOiIgxmoigOI/abacy5tDyUeCxsrwOWFqeZDqRatD6Qdvbgb2STi/jD+cDt9faLCvL5wD3lnGMiIiYJDM6aSzpcOD3gE/Wyn8haR7VLaKtrXW2N0m6GXgc2AdcaHt/aXMBcC1wGHBneQGsBq6XNEB1JbG0k+ONiIgD11FQ2P4lwwaXbX+8YfuVwMo29X7g1Db1l4BzOznGiIjoTN6ZHRERjRIUERHRKEERERGNEhQREdGoo8HsiBiq9+Jvjbvt1svPnMAjiZg4uaKIiIhGCYqIiGiUoIiIiEYJioiIaJSgiIiIRgmKiIholKCIiIhGCYqIiGiUoIiIiEYJioiIaJSgiIiIRh0FhaStkjZK2iCpv9SOkrRe0pbydVZt+0skDUh6UtLiWn1+2c+ApKvKlKiUaVNvKvUHJPV2crwREXHgJuKK4gO259nuK99fDNxjey5wT/keSSdTTWV6CrAEuFrSIaXNNcAKqnm055b1AMuB3bZPAq4ErpiA442IiAPQjVtPZwFry/Ja4Oxa/UbbL9t+BhgAFkg6DjjS9n22DVw3rE1rX7cAC1tXGxERMTk6DQoDd0t6WNKKUjvW9naA8vWtpT4beK7WdrDUZpfl4fUhbWzvA/YwbI5uAEkrJPVL6t+5c2eHpxQREXWdzkfxXtvbJL0VWC/piYZt210JuKHe1GZowV4FrALo6+t71fqIiBi/jq4obG8rX58HbgMWADvK7STK1+fL5oPA8bXmc4BtpT6nTX1IG0kzgJnArk6OOSIiDsy4g0LSb0h6c2sZWAQ8BqwDlpXNlgG3l+V1wNLyJNOJVIPWD5bbU3slnV7GH84f1qa1r3OAe8s4RkRETJJObj0dC9xWxpZnAF+3/W1JDwE3S1oOPAucC2B7k6SbgceBfcCFtveXfV0AXAscBtxZXgCrgeslDVBdSSzt4HgjImIcxh0Utp8GfqtN/QVg4QhtVgIr29T7gVPb1F+iBE1EREyNvDM7IiIaJSgiIqJRgiIiIholKCIiolGCIiIiGiUoIiKiUYIiIiIaJSgiIqJRgiIiIholKCIiolGCIiIiGiUoIiKiUYIiIiIaJSgiIqJRgiIiIholKCIiolEnU6EeL+m7kjZL2iTpM6X+BUk/lbShvD5ca3OJpAFJT0paXKvPl7SxrLuqTIlKmTb1plJ/QFLv+E81IiLGo5OpUPcBn7P9SJk7+2FJ68u6K23/1/rGkk6mmsr0FOBtwHckvbNMh3oNsAK4H7gDWEI1HepyYLftkyQtBa4APtbBMcc00Xvxt8bdduvlZ07gkUQc/MZ9RWF7u+1HyvJeYDMwu6HJWcCNtl+2/QwwACyQdBxwpO37bBu4Dji71mZtWb4FWNi62oiIiMkxIWMU5ZbQe4AHSukiSY9KWiNpVqnNBp6rNRsstdlleXh9SBvb+4A9wNFt+l8hqV9S/86dOyfilCIioug4KCQdAdwKfNb2i1S3kd4BzAO2A19qbdqmuRvqTW2GFuxVtvts9/X09BzgGURERJOOgkLSG6lC4mu2vwlge4ft/bZfAb4CLCibDwLH15rPAbaV+pw29SFtJM0AZgK7OjnmiIg4MJ089SRgNbDZ9pdr9eNqm30UeKwsrwOWlieZTgTmAg/a3g7slXR62ef5wO21NsvK8jnAvWUcIyIiJkknTz29F/g4sFHShlL7PHCepHlUt4i2Ap8EsL1J0s3A41RPTF1YnngCuAC4FjiM6mmnO0t9NXC9pAGqK4mlHRxvRESMw7iDwvYPaT+GcEdDm5XAyjb1fuDUNvWXgHPHe4wREdG5vDM7IiIaJSgiIqJRgiIiIholKCIiolGCIiIiGnXyeGxEo04+mA/y4XwRrxW5ooiIiEYJioiIaJSgiIiIRhmjmCS5Xx8RB6sExTSQ2d4iohO59RQREY0SFBER0ShBERERjRIUERHRKEERERGNDoqgkLRE0pOSBiRdPNXHExExnbzmg0LSIcBfAR8CTqaaavXkqT2qiIjp4zUfFMACYMD207b/HrgROGuKjykiYtqQ7ak+hkaSzgGW2P5E+f7jwGm2L6ptswJYUb59F/BkB10eA/y8g/YHW79T2fd063cq+845T4++O+n3n9nuabfiYHhnttrUhqSb7VXAqgnpTOq33TcR+zoY+p3Kvqdbv1PZd855evTdrX4PhltPg8Dxte/nANum6FgiIqadgyEoHgLmSjpR0puApcC6KT6miIhp4zV/68n2PkkXAXcBhwBrbG/qYpcTcgvrIOp3Kvuebv1OZd855+nRd1f6fc0PZkdExNQ6GG49RUTEFEpQREREowRFREQ0es0PZneTpH9O9S7v2VTvzdgGrLO9eUoPrIvKOc8GHrD9d7X6Etvf7nLfCwDbfqh8DMsS4Anbd3Sz3zbHcZ3t8yezz9Lvv6b6pIHHbN/dxX5OAzbbflHSYcDFwG8DjwP/xfaeLvb9aeA22891q48R+m09EbnN9nck/RHwr4DNwCrb/9DFvt8BfJTqMf59wBbghm7+O0+2aTuYLenPgPOoPhJksJTnUP2w3Wj78ik6rj+x/dUu7fvTwIVUvzzzgM/Yvr2se8T2b3ej37L/S6k+r2sGsB44Dfge8EHgLtsru9Tv8EepBXwAuBfA9ke60W/p+0HbC8ryv6f6t78NWAT8r279jEnaBPxWeWJwFfBL4BZgYan/QTf6LX3vAX4BPAXcAHzD9s5u9Vfr92tUP1uHA/8POAL4JtU5y/ayLvX7aeDfAN8HPgxsAHZTBcd/sP29bvQ76WxPyxfwY+CNbepvArZM4XE928V9bwSOKMu9QD9VWAD8qMvntZHq8ebDgReBI0v9MODRLvb7CPA/gTOA95ev28vy+7t8zj+qLT8E9JTl3wA2drHfzfXzH7ZuQ7fPmeqW9iJgNbAT+DawDHhzF/t9tHydAewADinfq8s/XxtrfR0OfK8snzAJv1MzgcuBJ4AXymtzqb1lIvuazmMUrwBva1M/rqzrGkmPjvDaCBzbxa4PcbndZHsr1f80PyTpy7T/qJSJtM/2ftu/BJ6y/WI5jl/R3X/vPuBh4M+BPa7+wvuV7e/b/n4X+wV4g6RZko6m+qt2J4DtX1DdouiWxyT9SVn+W0l9AJLeCXTtFkxh26/Yvtv2cqrfsaupbjM+3cV+31BuP72Z6n/YM0v9UOCNXewX/vEW/qGlf2w/Own93kx19XKG7aNtH011tbwb+MZEdjSdxyg+C9wjaQvQup96AnAScNGIrSbGscBiqv+gdQL+bxf7/ZmkebY3ANj+O0m/D6wB/kUX+wX4e0mHl6CY3ypKmkkXg8L2K8CVkr5Rvu5g8n7uZ1KFlABL+qe2fybpCLobzJ8A/puk/0T1AXH3SXqO6uf8E13sF4adl6uxgXXAujJe0i2rqf6yPoTqj4JvSHoaOJ3q9nK3/A/gIUn3A78LXAEgqQfY1cV+AXptX1Ev2P4ZcIWkP53IjqbtGAWApDdQDS7OpvoBHwQesr2/y/2uBr5q+4dt1n3d9h91qd85VH/Z/6zNuvfa/j/d6Lfs/1DbL7epHwMcZ3tjt/oe1t+ZwHttf34y+hvhGA4HjrX9TJf7eTPwdqpgHLS9o5v9lT7fafvH3e5nhL7fBmB7m6S3UI1/PWv7wS73ewrwm1QPKTzRzb6G9Xs38B1gbeu/raRjgT8Gfs/2Byesr+kcFBERBytJs6ieaDsLeGsp76C6grvc9vA7FuPvK0EREfH6MtFPTyYoIiJeZyQ9a/uEidrfdB7Mjog4aEl6dKRVTPDTkwmKiIiD06Q9PZmgiIg4OP1vqjfQbhi+QtL3JrKjjFFERESj6fzO7IiIGIMERURENEpQRHSRpM+Wd2K3vr+jvGs44qCRMYqIDkkS1e/Sqz6zStJWoM/2zyf9wCImSK4oIsZBUq+kzZKupvoo89WS+iVtkvSfyzafpvr01O9K+m6pbZV0TK39V0qbu1sfmifpd8qnCd8n6S8lPTZV5xkBCYqITrwLuM72e4DP2e4D3g28X9K7bV9FNWviB2x/oE37ucBf2T6FarKdf1vqXwU+ZftfAl39gMqIsUhQRIzfT2zfX5b/UNIjVBP3nAKcPIb2z9SegX8Y6C3jF2+23XrD1Ncn9IgjxiFvuIsYv18ASDoR+I/A79jeLela4J+MoX39Y9f3U8321+0JpCIOWK4oIjp3JFVo7CnzAXyotm4vZdazsSgfDb1X0umltHTCjjJinHJFEdEh238r6UfAJqrpPusTQK0C7pS0fYRxinaWA1+R9Avge8CeiTzeiAOVx2MjXmMkHdGa21zSxVQzAH5mig8rprFcUUS89pwp6RKq38+fUE1tGTFlckURERGNMpgdERGNEhQREdEoQREREY0SFBER0ShBERERjRIUERHR6P8DmX3ZPIRn3H8AAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "rating_counts = ratings.groupby('rating')['user_id'].count()\n",
    "rating_counts.plot.bar();"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "rating\n",
       "0     0.000302\n",
       "1     0.011805\n",
       "2     0.010080\n",
       "3     0.016897\n",
       "4     0.030934\n",
       "5     0.075201\n",
       "6     0.130719\n",
       "7     0.224014\n",
       "8     0.241113\n",
       "9     0.141279\n",
       "10    0.117656\n",
       "Name: user_id, dtype: float64"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rating_balance = rating_counts / len(ratings)\n",
    "rating_balance"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "rating\n",
       "0     0.000302\n",
       "1     0.012107\n",
       "2     0.022186\n",
       "3     0.039084\n",
       "4     0.070018\n",
       "5     0.145219\n",
       "6     0.275938\n",
       "7     0.499952\n",
       "8     0.741065\n",
       "9     0.882344\n",
       "10    1.000000\n",
       "Name: user_id, dtype: float64"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rating_balance.cumsum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "count    857465.000000\n",
       "mean          7.311786\n",
       "std           1.854717\n",
       "min           0.000000\n",
       "25%           6.000000\n",
       "50%           8.000000\n",
       "75%           9.000000\n",
       "max          10.000000\n",
       "Name: rating, dtype: float64"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ratings['rating'].describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYoAAAEVCAYAAAD+TqKGAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjEsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+j8jraAAAdaElEQVR4nO3df5TddX3n8efLRDTKJiYw0JhgJy7BNmT9ATFGcFttlKSFNWyFbThasjXbnHLwR7vb7ZJ6Vrp6sge6XbGsQpuVSMhaIBus5OhSzYJIdSEwoDYEpMwxCCORDE3EVEts4LV/fD9Tbi53vjNzJzN3rnk9zrnn3vv+fj/fvAeS+5rP9/u9369sExERMZyXdLqBiIiY2hIUERFRK0ERERG1EhQREVErQREREbWmd7qBo+3EE090b29vp9uIiOgq999//9O2e1ot+5kLit7eXvr6+jrdRkREV5H0veGWZddTRETUSlBEREStBEVERNRKUERERK0ERURE1EpQRERErQRFRETUSlBEREStEYNC0iZJ+yQ92FT/oKRHJO2W9McN9fWS+suyFQ31MyXtKsuulqRSf5mkm0t9p6TehjFrJD1aHmuOxg8cERFjM5pvZl8PfAq4Yagg6R3AKuD1tg9JOqnUFwGrgdOBVwP/V9Jptp8DrgXWAfcA/wdYCdwGrAUO2D5V0mrgSuA3JM0BLgeWAAbul7Td9oHx/9gREZ3Ve9mXJnT7j11x7lHb1ogzCtt3AfubypcAV9g+VNbZV+qrgJtsH7K9B+gHlkqaC8y0fberW+rdAJzfMGZzeb0NWF5mGyuAHbb3l3DYQRUuERExido9RnEa8C/LrqKvSXpzqc8DnmhYb6DU5pXXzfUjxtg+DDwDnFCzrReRtE5Sn6S+wcHBNn+kiIhopd2gmA7MBpYB/xHYWmYBarGua+q0OebIor3R9hLbS3p6Wl78MCIi2tRuUAwAn3flXuB54MRSP6VhvfnAk6U+v0WdxjGSpgOzqHZ1DbetiIiYRO0GxReAXwGQdBpwHPA0sB1YXc5kWgAsBO61vRc4KGlZmXlcDNxatrUdGDqj6QLgjnIc48vAOZJmS5oNnFNqERExiUY860nSjcDbgRMlDVCdibQJ2FROmf0psKZ8uO+WtBV4CDgMXFrOeILqAPj1wAyqs51uK/XrgC2S+qlmEqsBbO+X9HHgvrLex2w3H1SPiIgJNmJQ2L5omEXvG2b9DcCGFvU+YHGL+rPAhcNsaxNVKEVERIfkm9kREVHrZ+5WqBFx7JjIL60dzS+sdbvMKCIiolaCIiIiaiUoIiKiVoIiIiJqJSgiIqJWgiIiImolKCIiolaCIiIiaiUoIiKiVoIiIiJqJSgiIqJWgiIiImolKCIiolaCIiIiaiUoIiKi1ohBIWmTpH3ltqfNy35fkiWd2FBbL6lf0iOSVjTUz5S0qyy7utw7m3J/7ZtLfaek3oYxayQ9Wh5riIiISTeaGcX1wMrmoqRTgHcBjzfUFlHd8/r0MuYaSdPK4muBdcDC8hja5lrggO1TgauAK8u25lDdn/stwFLgckmzx/bjRUTEeI0YFLbvAva3WHQV8AeAG2qrgJtsH7K9B+gHlkqaC8y0fbdtAzcA5zeM2VxebwOWl9nGCmCH7f22DwA7aBFYERExsdo6RiHp3cD3bX+7adE84ImG9wOlNq+8bq4fMcb2YeAZ4ISabbXqZ52kPkl9g4OD7fxIERExjDEHhaRXAB8BPtpqcYuaa+rtjjmyaG+0vcT2kp6enlarREREm9qZUfxzYAHwbUmPAfOBByT9HNVv/ac0rDsfeLLU57eo0zhG0nRgFtWuruG2FRERk2jMQWF7l+2TbPfa7qX6QD/D9g+A7cDqcibTAqqD1vfa3gsclLSsHH+4GLi1bHI7MHRG0wXAHeU4xpeBcyTNLgexzym1iIiYRNNHWkHSjcDbgRMlDQCX276u1bq2d0vaCjwEHAYutf1cWXwJ1RlUM4DbygPgOmCLpH6qmcTqsq39kj4O3FfW+5jtVgfVIyJiAo0YFLYvGmF5b9P7DcCGFuv1AYtb1J8FLhxm25uATSP1GBEREyffzI6IiFoJioiIqJWgiIiIWgmKiIiolaCIiIhaCYqIiKiVoIiIiFoJioiIqJWgiIiIWgmKiIiolaCIiIhaCYqIiKiVoIiIiFojXj02In529V72pQnd/mNXnDuh24/JkRlFRETUSlBEREStEYNC0iZJ+yQ92FD7b5K+I+lvJP2lpFc1LFsvqV/SI5JWNNTPlLSrLLu63BKVctvUm0t9p6TehjFrJD1aHkO3S42IiEk0mhnF9cDKptoOYLHt1wN/C6wHkLSI6lamp5cx10iaVsZcC6yjuo/2woZtrgUO2D4VuAq4smxrDnA58BZgKXB5uXd2RERMohGDwvZdVPeybqx9xfbh8vYeYH55vQq4yfYh23uAfmCppLnATNt32zZwA3B+w5jN5fU2YHmZbawAdtjeb/sAVTg1B1ZEREywo3GM4v3AbeX1POCJhmUDpTavvG6uHzGmhM8zwAk124qIiEk0rqCQ9BHgMPC5oVKL1VxTb3dMcx/rJPVJ6hscHKxvOiIixqTtoCgHl88D3lt2J0H1W/8pDavNB54s9fkt6keMkTQdmEW1q2u4bb2I7Y22l9he0tPT0+6PFBERLbQVFJJWAv8JeLftnzQs2g6sLmcyLaA6aH2v7b3AQUnLyvGHi4FbG8YMndF0AXBHCZ4vA+dIml0OYp9TahERMYlG/Ga2pBuBtwMnShqgOhNpPfAyYEc5y/Ue279je7ekrcBDVLukLrX9XNnUJVRnUM2gOqYxdFzjOmCLpH6qmcRqANv7JX0cuK+s9zHbRxxUj4iIiTdiUNi+qEX5upr1NwAbWtT7gMUt6s8CFw6zrU3AppF6jIiIiZNvZkdERK0ERURE1EpQRERErWP+MuO5zHJERL3MKCIiolaCIiIiaiUoIiKiVoIiIiJqJSgiIqJWgiIiImolKCIiolaCIiIiah3zX7iLGI98YTOOBZlRRERErQRFRETUSlBEREStBEVERNQaMSgkbZK0T9KDDbU5knZIerQ8z25Ytl5Sv6RHJK1oqJ8paVdZdnW5dzbl/to3l/pOSb0NY9aUP+NRSUP31Y6IiEk0mhnF9cDKptplwO22FwK3l/dIWkR1z+vTy5hrJE0rY64F1gELy2Nom2uBA7ZPBa4CrizbmkN1f+63AEuByxsDKSIiJseIQWH7LmB/U3kVsLm83gyc31C/yfYh23uAfmCppLnATNt32zZwQ9OYoW1tA5aX2cYKYIft/bYPADt4cWBFRMQEa/cYxcm29wKU55NKfR7wRMN6A6U2r7xurh8xxvZh4BnghJptvYikdZL6JPUNDg62+SNFREQrR/tgtlrUXFNvd8yRRXuj7SW2l/T09Iyq0YiIGJ12v5n9lKS5tveW3Ur7Sn0AOKVhvfnAk6U+v0W9ccyApOnALKpdXQPA25vG3NlmvzFF5ZvNEVNfuzOK7cDQWUhrgFsb6qvLmUwLqA5a31t2Tx2UtKwcf7i4aczQti4A7ijHMb4MnCNpdjmIfU6pRUTEJBpxRiHpRqrf7E+UNEB1JtIVwFZJa4HHgQsBbO+WtBV4CDgMXGr7ubKpS6jOoJoB3FYeANcBWyT1U80kVpdt7Zf0ceC+st7HbDcfVD/m5TfyiJhoIwaF7YuGWbR8mPU3ABta1PuAxS3qz1KCpsWyTcCmkXqMiIiJk29mR0RErQRFRETUSlBEREStBEVERNRKUERERK0ERURE1EpQRERErQRFRETUSlBEREStBEVERNRKUERERK0ERURE1EpQRERErQRFRETUSlBEREStBEVERNQaV1BI+j1JuyU9KOlGSS+XNEfSDkmPlufZDeuvl9Qv6RFJKxrqZ0raVZZdXW6XSrml6s2lvlNS73j6jYiIsWs7KCTNAz4ELLG9GJhGdRvTy4DbbS8Ebi/vkbSoLD8dWAlcI2la2dy1wDqqe2wvLMsB1gIHbJ8KXAVc2W6/ERHRnvHuepoOzJA0HXgF8CSwCthclm8Gzi+vVwE32T5kew/QDyyVNBeYaftu2wZuaBoztK1twPKh2UZEREyOtoPC9veBPwEeB/YCz9j+CnCy7b1lnb3ASWXIPOCJhk0MlNq88rq5fsQY24eBZ4AT2u05IiLGbjy7nmZT/ca/AHg18EpJ76sb0qLmmnrdmOZe1knqk9Q3ODhY33hERIzJeHY9vRPYY3vQ9j8CnwfOAp4qu5Moz/vK+gPAKQ3j51Ptqhoor5vrR4wpu7dmAfubG7G90fYS20t6enrG8SNFRESz8QTF48AySa8oxw2WAw8D24E1ZZ01wK3l9XZgdTmTaQHVQet7y+6pg5KWle1c3DRmaFsXAHeU4xgRETFJprc70PZOSduAB4DDwDeBjcDxwFZJa6nC5MKy/m5JW4GHyvqX2n6ubO4S4HpgBnBbeQBcB2yR1E81k1jdbr8REdGetoMCwPblwOVN5UNUs4tW628ANrSo9wGLW9SfpQRNRER0Rr6ZHRERtRIUERFRK0ERERG1EhQREVErQREREbUSFBERUStBERERtRIUERFRK0ERERG1EhQREVErQREREbUSFBERUStBERERtRIUERFRK0ERERG1EhQREVErQREREbXGFRSSXiVpm6TvSHpY0lslzZG0Q9Kj5Xl2w/rrJfVLekTSiob6mZJ2lWVXl3tnU+6vfXOp75TUO55+IyJi7MY7o/hT4K9s/wLwBuBh4DLgdtsLgdvLeyQtorrn9enASuAaSdPKdq4F1gELy2Nlqa8FDtg+FbgKuHKc/UZExBi1HRSSZgK/BFwHYPuntn8IrAI2l9U2A+eX16uAm2wfsr0H6AeWSpoLzLR9t20DNzSNGdrWNmD50GwjIiImx3hmFK8FBoHPSvqmpM9IeiVwsu29AOX5pLL+POCJhvEDpTavvG6uHzHG9mHgGeCE5kYkrZPUJ6lvcHBwHD9SREQ0G09QTAfOAK61/Sbgx5TdTMNoNRNwTb1uzJEFe6PtJbaX9PT01HcdERFjMp6gGAAGbO8s77dRBcdTZXcS5Xlfw/qnNIyfDzxZ6vNb1I8YI2k6MAvYP46eIyJijNoOCts/AJ6Q9LpSWg48BGwH1pTaGuDW8no7sLqcybSA6qD1vWX31EFJy8rxh4ubxgxt6wLgjnIcIyIiJsn0cY7/IPA5SccB3wV+iyp8tkpaCzwOXAhge7ekrVRhchi41PZzZTuXANcDM4DbygOqA+VbJPVTzSRWj7PfiIgYo3EFhe1vAUtaLFo+zPobgA0t6n3A4hb1ZylBExERnZFvZkdERK0ERURE1EpQRERErQRFRETUSlBEREStBEVERNRKUERERK0ERURE1EpQRERErQRFRETUSlBEREStBEVERNRKUERERK0ERURE1EpQRERErQRFRETUSlBEREStcQeFpGmSvinpi+X9HEk7JD1anmc3rLteUr+kRyStaKifKWlXWXZ1uXc25f7aN5f6Tkm94+03IiLG5mjMKD4MPNzw/jLgdtsLgdvLeyQtorrn9enASuAaSdPKmGuBdcDC8lhZ6muBA7ZPBa4CrjwK/UZExBiMKygkzQfOBT7TUF4FbC6vNwPnN9Rvsn3I9h6gH1gqaS4w0/bdtg3c0DRmaFvbgOVDs42IiJgc451RfBL4A+D5htrJtvcClOeTSn0e8ETDegOlNq+8bq4fMcb2YeAZ4ITmJiStk9QnqW9wcHCcP1JERDRqOygknQfss33/aIe0qLmmXjfmyIK90fYS20t6enpG2U5ERIzG9HGMPRt4t6RfA14OzJT0v4CnJM21vbfsVtpX1h8ATmkYPx94stTnt6g3jhmQNB2YBewfR88RETFGbc8obK+3Pd92L9VB6jtsvw/YDqwpq60Bbi2vtwOry5lMC6gOWt9bdk8dlLSsHH+4uGnM0LYuKH/Gi2YUERExccYzoxjOFcBWSWuBx4ELAWzvlrQVeAg4DFxq+7ky5hLgemAGcFt5AFwHbJHUTzWTWD0B/UZERI2jEhS27wTuLK//Dlg+zHobgA0t6n3A4hb1ZylBExERnZFvZkdERK0ERURE1EpQRERErQRFRETUSlBEREStBEVERNRKUERERK0ERURE1EpQRERErQRFRETUSlBEREStBEVERNRKUERERK0ERURE1EpQRERErQRFRETUajsoJJ0i6auSHpa0W9KHS32OpB2SHi3PsxvGrJfUL+kRSSsa6mdK2lWWXV1uiUq5berNpb5TUm/7P2pERLRjPDOKw8B/sP2LwDLgUkmLgMuA220vBG4v7ynLVgOnAyuBayRNK9u6FlhHdR/thWU5wFrggO1TgauAK8fRb0REtKHtoLC91/YD5fVB4GFgHrAK2FxW2wycX16vAm6yfcj2HqAfWCppLjDT9t22DdzQNGZoW9uA5UOzjYiImBxH5RhF2SX0JmAncLLtvVCFCXBSWW0e8ETDsIFSm1deN9ePGGP7MPAMcEKLP3+dpD5JfYODg0fjR4qIiGLcQSHpeOAW4Hdt/6hu1RY119TrxhxZsDfaXmJ7SU9Pz0gtR0TEGIwrKCS9lCokPmf786X8VNmdRHneV+oDwCkNw+cDT5b6/Bb1I8ZImg7MAvaPp+eIiBib8Zz1JOA64GHbn2hYtB1YU16vAW5tqK8uZzItoDpofW/ZPXVQ0rKyzYubxgxt6wLgjnIcIyIiJsn0cYw9G/hNYJekb5XaHwJXAFslrQUeBy4EsL1b0lbgIaozpi61/VwZdwlwPTADuK08oAqiLZL6qWYSq8fRb0REtKHtoLD9dVofQwBYPsyYDcCGFvU+YHGL+rOUoImIiM7IN7MjIqJWgiIiImolKCIiolaCIiIiaiUoIiKiVoIiIiJqJSgiIqJWgiIiImolKCIiolaCIiIiaiUoIiKiVoIiIiJqJSgiIqJWgiIiImolKCIiolaCIiIiaiUoIiKiVlcEhaSVkh6R1C/psk73ExFxLJnyQSFpGvBp4FeBRcBFkhZ1tquIiGPHlA8KYCnQb/u7tn8K3ASs6nBPERHHDNnudA+1JF0ArLT978r73wTeYvsDDeusA9aVt68DHpnAlk4Enp7A7U+09N9Z6b+zurn/ie795233tFowfQL/0KNFLWpHpJvtjcDGSWlG6rO9ZDL+rImQ/jsr/XdWN/ffyd67YdfTAHBKw/v5wJMd6iUi4pjTDUFxH7BQ0gJJxwGrge0d7iki4pgx5Xc92T4s6QPAl4FpwCbbuzvY0qTs4ppA6b+z0n9ndXP/Het9yh/MjoiIzuqGXU8REdFBCYqIiKiVoIiIiFoJimOQpJ/rdA8R0T0SFG3q8g/b6zrdwLFM0hc73cN4dfPff0nndbqH8ejEf/sERfu69sPW9rmd7mE8fgY+aH+70w0cBV379x94c6cbGKdJ/2+f02OPAZLeBiy0/VlJPcDxtvd0uq92SZpre2+n+4ipT9LLbB8aqRb1EhSjVC53fjINX1K0/XjnOhodSZcDS4DX2T5N0quB/2377A63dkyQtIema5MB2H5tB9oZE0kzbf9I0pxWy23vn+yexkrSA7bPGKk2lU2Fz54p/83sqUDSB4HLgaeA50vZwOs71tTo/WvgTcADALaflPTPOtvSyCTtosUH7BDb3fDfHqqQHvJy4EKg5QfvFPQXwHnA/VT/Lxov0GlgyoZd2Y8/D5gh6U280PtM4BUda2yMpspnT4JidD5M9Rv533W6kTb81LYlGUDSKzvd0CgNHXC8tDxvKc/vBX4y+e20p8XfmU9K+jrw0U70Mxa2z5Mk4Je7YfbcZAXwb6kuIvqJhvpB4A870VCbpsRnT4JidJ4Anul0E23aKunPgVdJ+m3g/cD/7HBPI7L9PQBJZzftJrtM0jeAj3Wms7GR1LiL4yVUM4wpP6MbUn7J+EvgzE73Mha2NwObJb3H9i2d7mccpsRnT4JidL4L3CnpS8A/HQSz/Ynhh0wNtv9E0ruAH1Hd1Omjtnd0uK2xeKWkt9n+OoCks4BumRUB/PeG14eBx4B/05lW2naPpDfbvq/TjYyV7VsknQucTrXrb6jeFb9oMEU+exIUo/N4eRxXHl2lBEM3hUOjtcAmSbOo9s0+QzUr6gq239HpHo6CdwC/I+kx4MdU+/vdDceJJP0Z1TGJdwCfAS4A7u1oU2MzJT57ctbTGJSDwLb9953uZbQkHeSFg8LHAS8Ffmx7Zue6GjtJM6n+vnZ8Gj4Wkl4GvAfo5cizVqb8b7SSXmP7cUk/32r50O7BqUzS39h+fcPz8cDnbZ/T6d66SWYUoyBpMdXB1Dnl/dPAxR2+L8ao2D5if7ik84GlHWpnzCSdDPxX4NW2f1XSIuCttrvlC1+3Us2C7qdh10GX+AJwhu3vSbrF9ns63VAb/qE8/6ScGr4fWNDBfsZE0ldpfXr1r0xmHwmK0dkI/HvbXwWQ9HaqA8JndbKpOpKm2z7cXLf9BUmXdaKnNl0PfBb4SHn/t8DNdM83g+fbXtnpJtrUeDrslD0VdgRflPQq4I+pwhqqXVDd4vcbXr+canb6on/XEy1BMTqvHAoJANt3dsFppvcCZ0j69Yba0Fk33bS/8UTbWyWth3+64+FznW5qDP6fpH9he1enG2mDh3k95Ul6M/CE7Y+X98cDu4DvAFd1srexsH1/U+kbkr422X0kKEbnu5L+My+cy/8+oFsugfGveOEf+dBZN+/uWDdj92NJJ1B+BknLmAKnC45E0oNUX5CaDvyWpO9S7XrqmgPBwBsk/Yiq5xnlNbzwM0zl41x/DrwTQNIvAVcAHwTeSLWH4ILOtTZ6Td+KH/pFb9IvCpiD2aMgaTbwX4C3Uf0juQv4I9sHOtpYDUkDVF80UtMiw9Q/tVfS7wLfoOr/E8BiYDfQA1xo+9sdbG9Ekg5QfSi11A0HgruZpG/bfkN5/Wlg0PYflfffsj3s/5uppOkSMEO/6H1s6HTxyZIZxSiUQPhQp/sYo2nA8bw4KLrFfOBPgV+g2l2wA7gTuNn20x3sa7T2JAw6alrDcbrlwLqGZVP+c69h19mC8n4N1fGJx4CHJr2fzCiGJ2l73XLbU3YXTrdd+Gw4ko6jmm6fBby1PH5oe1FHGxtBw4yupak+o+t2kj4C/BrwNPAaqrO3LOlUYPNUvyimpAeAd9reX3ad3cQLu85+0fak7jqb8snaYW+l+gr9jcBOuuu3827qtc4Mqgu5zSqPJ6kOSk513T6j62q2N0i6HZgLfMUv/Eb8EqoP3KluWsPVeX8D2FguRXKLpG9NdjOZUdQol/d9F3AR1dUavwTc2A3fn5A0pxsuAz0cSRupLrtwkCqk7wHumcrHhRr9rMzoojPKyRBvLGf5fQdYZ/uuoWW2F09mP7nDXQ3bz9n+K9trgGVAP9V1V6b8byTdHBLFa4CXAT8Avg8MAD/saEdjk5lEjMeNwNck3Ur1pcG/Bii7zib9rL/MKEZQLsFwLtWsohfYDmyy/f1O9nUsKJe4Pp3q+MRZVGc+7Qfutn15J3sbSbfP6KLzyqngQ7vOflxqp1HdofKBSe0lQTE8SZupPpxuA26y/WCHWzomSZoPnE0VFucBJ9h+VWe7ijh2JChqSHqe6mqZcOQ3U7vhC0ddTdKHqILhbOAfqb5TcXd53mX7+ZrhEXEU5aynGrZzDKdzeoFtwO/Z3tvhXiKOaZlRRERErfzGHBERtRIUERFRK8coIo6ScvnzXVR3ETwMbAY+mQPv0e0SFBFHzz8MXZVU0knAX1BddmRKf+cjYiTZ9RQxAWzvo7pi6QdU6ZX015IeKI+zACRtkbRqaJykz0mashebjGNTznqKOEok/b3t45tqB6gulX4QeN72s5IWUl0zbImkX6Y6Bfh8SbOAbwELW93GNqJTsuspYmINXfPppcCnJL0ReA44DcD21yR9uuyq+nXgloRETDUJiogJIum1VKGwj+o4xVPAG6h2+T7bsOoW4L3AauD9k9xmxIgSFBETQFIP8GfAp8oNc2YBA7afL3crm9aw+vXAvcAPuuES9nHsSVBEHD0zyk1lhk6P3cILd7m7huqmMxcCX+WFa4hh+ylJDwNfmOR+I0YlB7MjOkzSK6i+f3GG7Um/10DESHJ6bEQHSXon8B3gfyQkYqrKjCIiImplRhEREbUSFBERUStBERERtRIUERFRK0ERERG1/j9XXpHfLlztjwAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "ax = ratings.groupby(ratings['date_time'].dt.dayofweek)['rating'].count().plot.bar()\n",
    "ax.set_xticklabels(['Mon.', 'Tue.', 'Wed.', 'Thu.', 'Fri.', 'Sat.', 'Sun.'])\n",
    "ax.set_xlabel('Day');"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYQAAAEJCAYAAACUk1DVAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjEsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+j8jraAAAahUlEQVR4nO3df7Rd9Vnn8ffHpMXUFsqPC6UJbRhJ2wU4pRKRsY6txpG46hjGgemtMyWtmcksBttanSVhnFnVGWNh1iyrjMIMUywBbSHiVDLatNLQjuNIk15aJIXAcC0UsqAQgVJQQYPP/LG/V08O55577k1I7k3er7X2Ovs8ez/7fPf59Zzv/nVSVUiS9C2HugGSpPnBgiBJAiwIkqTGgiBJAiwIkqTGgiBJAmDxoW7AXJ1wwgm1fPnyQ90MSVpQ7rjjjj+rqrFB0xZsQVi+fDkTExOHuhmStKAk+dp009xkJEkCRigISd6Y5M6e4ZtJfirJcUluTXJ/uz22J+eyJJNJ7ktyXk/87CQ727Qrk6TFj0pyU4tvT7L8pVhZSdL0ZiwIVXVfVZ1VVWcBZwN/AXwS2ABsq6oVwLZ2nySnA+PAGcBq4Koki9rirgbWAyvasLrF1wFPVdVpwEeAKw7M6kmSRjXbTUargD+tqq8Ba4BNLb4JOL+NrwFurKrnq+oBYBI4J8nJwNFVdXt1F1C6vi9nalk3A6umeg+SpINjtgVhHPhEGz+pqh4FaLcntvhS4OGenN0ttrSN98f3yamqvcDTwPGzbJskaT+MXBCSvBz4UeC3Z5p1QKyGxIfl9LdhfZKJJBN79uyZoRmSpNmYTQ/hh4EvVdVj7f5jbTMQ7fbxFt8NnNKTtwx4pMWXDYjvk5NkMXAM8GR/A6rqmqpaWVUrx8YGHkYrSZqj2RSEd/F3m4sAtgBr2/ha4Jae+Hg7cuhUup3HO9pmpWeSnNv2D1zUlzO1rAuA28o/apCkg2qkE9OSvAL4R8C/7glfDmxOsg54CLgQoKruTrIZuAfYC1xSVS+0nIuB64AlwNY2AFwL3JBkkq5nML4f6yRJh9zyDb8/MP7g5e84yC0Z3UgFoar+gr6dvFX1BN1RR4Pm3whsHBCfAM4cEH+OVlAkSYeGZypLkgALgiSpsSBIkgALgiSpsSBIkgALgiSpsSBIkgALgiSpWbB/oSlJh5vpzm6Gg3OGsz0ESRJgQZAkNRYESRJgQZAkNRYESRJgQZAkNRYESRJgQZAkNRYESRJgQZAkNRYESRJgQZAkNSNd3C7Jq4GPAmcCBfwEcB9wE7AceBD4Z1X1VJv/MmAd8ALw/qr6TIufDVwHLAE+BXygqirJUcD1wNnAE8A7q+rBA7GCkrQ/DvUF5w6mUXsIvwp8uqreBLwZ2AVsALZV1QpgW7tPktOBceAMYDVwVZJFbTlXA+uBFW1Y3eLrgKeq6jTgI8AV+7lekqRZmrEgJDka+D7gWoCq+quq+gawBtjUZtsEnN/G1wA3VtXzVfUAMAmck+Rk4Oiqur2qiq5H0JsztaybgVVJst9rJ0ka2Sg9hL8H7AE+luTLST6a5NuAk6rqUYB2e2KbfynwcE/+7hZb2sb74/vkVNVe4Gng+DmtkSRpTkYpCIuB7wSurqq3AH9O2zw0jUG/7GtIfFjOvgtO1ieZSDKxZ8+e4a2WJM3KKAVhN7C7qra3+zfTFYjH2mYg2u3jPfOf0pO/DHikxZcNiO+Tk2QxcAzwZH9DquqaqlpZVSvHxsZGaLokaVQzFoSq+jrwcJI3ttAq4B5gC7C2xdYCt7TxLcB4kqOSnEq383hH26z0TJJz2/6Bi/pyppZ1AXBb288gSTpIRv1P5fcBv5Xk5cBXgffSFZPNSdYBDwEXAlTV3Uk20xWNvcAlVfVCW87F/N1hp1vbAN0O6xuSTNL1DMb3c70kSbM0UkGoqjuBlQMmrZpm/o3AxgHxCbpzGfrjz9EKiiTp0PBMZUkSYEGQJDUWBEkSYEGQJDUWBEkSYEGQJDUWBEkSYEGQJDUWBEkSYEGQJDUWBEkSYEGQJDUWBEkSMPrlryVJ89TyDb8/7bQHL3/HyMuxhyBJAiwIkqTGgiBJAiwIkqTGgiBJAiwIkqTGgiBJAkYsCEkeTLIzyZ1JJlrsuCS3Jrm/3R7bM/9lSSaT3JfkvJ742W05k0muTJIWPyrJTS2+PcnyA7uakqSZzKaH8P1VdVZVrWz3NwDbqmoFsK3dJ8npwDhwBrAauCrJopZzNbAeWNGG1S2+Dniqqk4DPgJcMfdVkiTNxf5sMloDbGrjm4Dze+I3VtXzVfUAMAmck+Rk4Oiqur2qCri+L2dqWTcDq6Z6D5Kkg2PUglDAHyS5I8n6Fjupqh4FaLcntvhS4OGe3N0ttrSN98f3yamqvcDTwPGzWxVJ0v4Y9VpGb62qR5KcCNya5N4h8w76ZV9D4sNy9l1wV4zWA7zuda8b3mJJ0qyM1EOoqkfa7ePAJ4FzgMfaZiDa7eNt9t3AKT3py4BHWnzZgPg+OUkWA8cATw5oxzVVtbKqVo6NjY3SdEnSiGYsCEm+LcmrpsaBHwK+AmwB1rbZ1gK3tPEtwHg7cuhUup3HO9pmpWeSnNv2D1zUlzO1rAuA29p+BknSQTLKJqOTgE+2fbyLgY9X1aeTfBHYnGQd8BBwIUBV3Z1kM3APsBe4pKpeaMu6GLgOWAJsbQPAtcANSSbpegbjB2DdJEmzMGNBqKqvAm8eEH8CWDVNzkZg44D4BHDmgPhztIIiSS+FA/WfAYczz1SWJAEWBElSY0GQJAEWBElSY0GQJAEWBElSY0GQJAEWBElSY0GQJAEWBElSY0GQJAEWBElSY0GQJAEWBElSY0GQJAEWBElSY0GQJAEWBElSY0GQJAEj/KfyQuH/pUrS/rGHIEkCZlEQkixK8uUkv9fuH5fk1iT3t9tje+a9LMlkkvuSnNcTPzvJzjbtyiRp8aOS3NTi25MsP3CrKEkaxWw2GX0A2AUc3e5vALZV1eVJNrT7lyY5HRgHzgBeC3w2yRuq6gXgamA98AXgU8BqYCuwDniqqk5LMg5cAbxzv9dO0mHHzcMvnZF6CEmWAe8APtoTXgNsauObgPN74jdW1fNV9QAwCZyT5GTg6Kq6vaoKuL4vZ2pZNwOrpnoPkqSDY9RNRr8C/CzwNz2xk6rqUYB2e2KLLwUe7plvd4stbeP98X1yqmov8DRw/MhrIUnabzMWhCQ/AjxeVXeMuMxBv+xrSHxYTn9b1ieZSDKxZ8+eEZsjSRrFKD2EtwI/muRB4EbgB5L8JvBY2wxEu328zb8bOKUnfxnwSIsvGxDfJyfJYuAY4Mn+hlTVNVW1sqpWjo2NjbSCkqTRzFgQquqyqlpWVcvpdhbfVlX/AtgCrG2zrQVuaeNbgPF25NCpwApgR9us9EySc9v+gYv6cqaWdUF7jBf1ECRJL539OTHtcmBzknXAQ8CFAFV1d5LNwD3AXuCSdoQRwMXAdcASuqOLtrb4tcANSSbpegbj+9EuSdIczKogVNXngc+38SeAVdPMtxHYOCA+AZw5IP4craBIkg4Nz1SWJAEWBElSY0GQJAEWBElSY0GQJAGH0f8hSFpYvEjd/HPEF4Tp3pS+ISUdadxkJEkCLAiSpMaCIEkCLAiSpMaCIEkCLAiSpOaIP+xU0v7xfILDhwVhDvwASDocuclIkgTYQ5DU2POVPQRJEmBBkCQ1FgRJEmBBkCQ17lQ+iNxpJ2k+m7GHkORbk+xI8idJ7k7yCy1+XJJbk9zfbo/tybksyWSS+5Kc1xM/O8nONu3KJGnxo5Lc1OLbkyw/8KsqSRpmlB7C88APVNWzSV4G/FGSrcCPAduq6vIkG4ANwKVJTgfGgTOA1wKfTfKGqnoBuBpYD3wB+BSwGtgKrAOeqqrTkowDVwDvPKBrKh0h7IlqrmbsIVTn2Xb3ZW0oYA2wqcU3Aee38TXAjVX1fFU9AEwC5yQ5GTi6qm6vqgKu78uZWtbNwKqp3oMk6eAYaadykkVJ7gQeB26tqu3ASVX1KEC7PbHNvhR4uCd9d4stbeP98X1yqmov8DRw/IB2rE8ykWRiz549o62hJGkkIxWEqnqhqs4CltH92j9zyOyDftnXkPiwnP52XFNVK6tq5djY2EzNliTNwqwOO62qbwCfp9v2/1jbDES7fbzNths4pSdtGfBIiy8bEN8nJ8li4Bjgydm0TZK0f0Y5ymgsyavb+BLgB4F7gS3A2jbbWuCWNr4FGG9HDp0KrAB2tM1KzyQ5t+0fuKgvZ2pZFwC3tf0MkqSDZJSjjE4GNiVZRFdANlfV7yW5HdicZB3wEHAhQFXdnWQzcA+wF7ikHWEEcDFwHbCE7uiirS1+LXBDkkm6nsH4gVi5w4VHjUg6GGYsCFV1F/CWAfEngFXT5GwENg6ITwAv2v9QVc/RCook6dDwTGVpnrJnqIPNaxlJkgALgiSpsSBIkgD3IRzW3AYtaTbsIUiSAHsI0kvOnpoWCnsIkiTAgiBJaiwIkiTAgiBJaiwIkiTAgiBJaiwIkiTA8xCkkXk+gQ53FgS9iF980pHJTUaSJMCCIElqLAiSJMB9CJoHDvY+C/eRSINZEHTA+EUrLWwzbjJKckqSzyXZleTuJB9o8eOS3Jrk/nZ7bE/OZUkmk9yX5Lye+NlJdrZpVyZJix+V5KYW355k+YFfVUnSMKP0EPYCP1NVX0ryKuCOJLcC7wG2VdXlSTYAG4BLk5wOjANnAK8FPpvkDVX1AnA1sB74AvApYDWwFVgHPFVVpyUZB64A3nkgV1SHH3sk0oE1Yw+hqh6tqi+18WeAXcBSYA2wqc22CTi/ja8Bbqyq56vqAWASOCfJycDRVXV7VRVwfV/O1LJuBlZN9R4kSQfHrI4yapty3gJsB06qqkehKxrAiW22pcDDPWm7W2xpG++P75NTVXuBp4HjBzz++iQTSSb27Nkzm6ZLkmYwckFI8krgd4CfqqpvDpt1QKyGxIfl7BuouqaqVlbVyrGxsZmaLEmahZEKQpKX0RWD36qq/9nCj7XNQLTbx1t8N3BKT/oy4JEWXzYgvk9OksXAMcCTs10ZSdLcjXKUUYBrgV1V9cs9k7YAa9v4WuCWnvh4O3LoVGAFsKNtVnomybltmRf15Uwt6wLgtrafQZJ0kIxylNFbgXcDO5Pc2WL/Drgc2JxkHfAQcCFAVd2dZDNwD90RSpe0I4wALgauA5bQHV20tcWvBW5IMknXMxjfz/WSJM3SjAWhqv6Iwdv4AVZNk7MR2DggPgGcOSD+HK2gSJIODa9lJEkCLAiSpMaCIEkCLAiSpMaCIEkCLAiSpMaCIEkCLAiSpMaCIEkCLAiSpMaCIEkCLAiSpMaCIEkCLAiSpMaCIEkCLAiSpMaCIEkCLAiSpMaCIEkCLAiSpMaCIEkCRigISX4jyeNJvtITOy7JrUnub7fH9ky7LMlkkvuSnNcTPzvJzjbtyiRp8aOS3NTi25MsP7CrKEkaxSg9hOuA1X2xDcC2qloBbGv3SXI6MA6c0XKuSrKo5VwNrAdWtGFqmeuAp6rqNOAjwBVzXRlJ0tzNWBCq6g+BJ/vCa4BNbXwTcH5P/Maqer6qHgAmgXOSnAwcXVW3V1UB1/flTC3rZmDVVO9BknTwzHUfwklV9ShAuz2xxZcCD/fMt7vFlrbx/vg+OVW1F3gaOH7QgyZZn2QiycSePXvm2HRJ0iAHeqfyoF/2NSQ+LOfFwaprqmplVa0cGxubYxMlSYPMtSA81jYD0W4fb/HdwCk98y0DHmnxZQPi++QkWQwcw4s3UUmSXmJzLQhbgLVtfC1wS098vB05dCrdzuMdbbPSM0nObfsHLurLmVrWBcBtbT+DJOkgWjzTDEk+AbwdOCHJbuBDwOXA5iTrgIeACwGq6u4km4F7gL3AJVX1QlvUxXRHLC0BtrYB4FrghiSTdD2D8QOyZpKkWZmxIFTVu6aZtGqa+TcCGwfEJ4AzB8SfoxUUSdKh45nKkiTAgiBJaiwIkiTAgiBJaiwIkiTAgiBJaiwIkiTAgiBJaiwIkiTAgiBJaiwIkiTAgiBJaiwIkiTAgiBJaiwIkiTAgiBJaiwIkiTAgiBJaiwIkiTAgiBJaiwIkiRgHhWEJKuT3JdkMsmGQ90eSTrSzIuCkGQR8OvADwOnA+9KcvqhbZUkHVnmRUEAzgEmq+qrVfVXwI3AmkPcJkk6oqSqDnUbSHIBsLqq/mW7/27gu6vqJ/vmWw+sb3ffCNw3zSJPAP5sDk0xz7yXOm8htNG8wzvv9VU1NnBKVR3yAbgQ+GjP/XcD/3U/ljdhnnnzMW8htNG8Izdvvmwy2g2c0nN/GfDIIWqLJB2R5ktB+CKwIsmpSV4OjANbDnGbJOmIsvhQNwCgqvYm+UngM8Ai4Deq6u79WOQ15pk3T/MWQhvNO0Lz5sVOZUnSoTdfNhlJkg4xC4IkCbAgSJKaebFTeX8leRPdmc1LgaI7ZHVLVe16CR9vKbC9qp7tia+uqk8PyTsHqKr6Yrs0x2rg3qr61Cwe+/qqumgObf5eujPCv1JVfzDNPN8N7KqqbyZZAmwAvhO4B/ilqnp6yPLfD3yyqh6eRZumjih7pKo+m+THge8BdgHXVNVfD8n9duCf0B2uvBe4H/jEsDZKGm7B9xCSXEp3qYsAO+gOYQ3wibleJC/Je4dMez9wC/A+4CtJei+x8UtD8j4EXAlcneTDwK8BrwQ2JPm5aXK29A3/C/ixqfszrMOOnvF/1R7vVcCHhjwvvwH8RRv/VeAY4IoW+9iwxwP+E7A9yf9J8m+SDD4Tcl8fA94BfCDJDXQnKG4Hvgv46HRJ7TX4b8C3tnmX0BWG25O8fYTHPWIkOfEgP97xB/PxXkpJjklyeZJ7kzzRhl0t9uo5LnPrkGlHJ/lwkhvaj6PeaVcNyXtNkquT/HqS45P8fJKdSTYnOXlWDZzL2WzzaQD+H/CyAfGXA/fPcZkPDZm2E3hlG18OTAAfaPe/PEPeIuAVwDeBo1t8CXDXNDlfAn4TeDvwtnb7aBt/2wzr8OWe8S8CY23824Cd0+Ts6n3svml3zvR4dD8wfgi4FtgDfBpYC7xqmpy72u1i4DFgUbuf6Z6T3ueyjb8C+Hwbf92w16DNcwxwOXAv8EQbdrXYq+f4ftk6ZNrRwIeBG4Af75t21ZC81wBX01308Xjg59t6bwZOnibnuL7heOBB4FjguCGPtbrv+bkWuAv4OHDSkLzLgRPa+Ergq8Ak8LVh78/2vv73wLfP8nleCXyufSZOAW4Fnm7v77cMyXsl8B+Bu9v8e4AvAO+Z4fE+A1wKvKbvdbkUuHVI3ndOM5wNPDok73fac3o+3XlYvwMcNejz2Jf3abofqBva63Zp+yy8D7hlVs/xXD4A82loH+zXD4i/HrhvSN5d0ww7geeH5N0z4M32aeCXGfKlyb5f0F/umzYwj+4L9oPtjX9Wi311xOflT9oXwfH0ncbe//g98d8G3tvGPwasbONvAL44w+P1F5CXAT8KfALYM03OV+gK97HAM7QvLbpf/ruGPNbOng/KscAdvcucoZ2H7Ycc+Bvggb7hr9vttO+b3nbQ9cx+sX1+Pgj87rDXoWf8c8B39bxfpr10QmvPfwEeouvVfxB47Qjv6R10V0R+F/AwcEGLrwJuH5J3C/Aeuisg/DTwH4AVwCa6TaHT5Q37/hg27QXgtvac9A9/OSTvzr77Pwf8X7rP8LD3Su93y0PDljnjczybmefjQLcdfhLYSncyxjXtwzRJzy+fAXmPAWe1N37vsJxum/Z0ebfRvpx7YouB64EXhuRtB17Rxr+lJ37MsBe7zbOM7sv61/pf8CE5D9L9Ynug3b6mxV853ZukteU64E9be/+65f5v4M0zPN6w3tGSaeIfbMv/GvB+YBvwP+i+8D80ZHkfoPuSvIbuB8FUERsD/nCGdh62H3Lg37b3/nf0xB4Y4b3ypSHtHfYj515gcRv/Qt+0gb3QAY/3D4GrgK+353L9HJ+TYe+/P+m7/8V2+y10+/Cmy/sD4Gfp6SUBJ9EV588OyfsKsGKaaQ8PydtFz3dDi62l69l8bZT1A35x1Ndh4LJmM/N8HdoLey7wT4EL2viiGXKuBb53mmkfH5K3jJ5fl33T3jok76hp4if0foBnaPM7GPKLZsRlvAI4dYZ5XgW8me7X77SbDPpy3jDH9ryW9usQeHV7/c4ZIe+MNu+bZvl4h/WHnL/78fDL7XWcsUdJdy2xnwZ+hq5Ap2fasE1372vP5w/QbdL6FeD7gF8AbhiS96JCSLc5dTXwsSF5t9NtkryQ7kfE+S3+Nob3SP546rMO/GPgMz3Thv0IOJZuH9q9wFPAk+31vILhm+AuAN44zbTzh+T9Z+AHB8RXM2TzN93msFcOiJ8G3DzK5+Jvc2Yzs4PDQh/6PuRP9n3Ijx2St6A+5O2L7wvA10eY90N9w9T+ptcA18+Q+3bgJrp9SDuBT9Fdon7xkJwb5/javZluk99W4E10Bz58g664fs+QvL9Pt7npG8Af0X680PUo3z/DY74J+MH+14IhWx968lYdwLwffike70XLmcsL4+BwOA60TU+HSx7dAQtnzuc2zuc8us2Y9wG/S7cJdk3PtGGb++aa976DmTdwWXN5Eh0cDseBEffPLMS8hdDG+ZbH/h1ROO/zBg2HxYlp0qiS3DXdJLp9CQs2byG0cSHl0e2HfBagqh5s57jcnOT1LXeh572IBUFHmpOA8+h2EvYK3c7HhZy3ENq4kPK+nuSsqroToKqeTfIjdCdwfsdhkPciFgQdaX6Prnt9Z/+EJJ9f4HkLoY0LKe8iusui/K2q2gtclOS/HwZ5L+L/IUiSgMPgWkaSpAPDgiBJAiwI0kiSPNt3/z1Jfu1QtUd6KVgQpEMoyaJD3QZpigVB2k9JXp9kW5K72u3rWvy6JBf0zPdsu317ks8l+TjdSUXSvOBhp9JoliTpPWzxOLrLWUN3Fdrrq2pTkp+g+yOk82dY3jl0l5V44MA3VZobC4I0mr+sqrOm7iR5D90ftgD8A+DH2vgNdBe0m8kOi4HmGzcZSQfe1Mk9e2mfsSSh+zOgKX9+sBslzcSCIO2/PwbG2/g/p7vEMnRXnjy7ja+h+xc5ad6yIEj77/3Ae9tF1N5N949u0P3729uS7AC+G3sFmue8dIUkCbCHIElqLAiSJMCCIElqLAiSJMCCIElqLAiSJMCCIElqLAiSJAD+P0wjxXE6HEIeAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "ax = ratings.groupby(ratings['date_time'].dt.hour)['rating'].count().plot.bar()\n",
    "ax.set_xlabel('Hour');"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>title</th>\n",
       "      <th>year</th>\n",
       "      <th>genres</th>\n",
       "      <th>movie_url</th>\n",
       "      <th>mean_rating</th>\n",
       "      <th>n_ratings</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>30422</th>\n",
       "      <td>MSG 2 the Messenger</td>\n",
       "      <td>2015</td>\n",
       "      <td>[comedy, drama, fantasy, horror]</td>\n",
       "      <td>https://www.imdb.com/title/tt4921860/</td>\n",
       "      <td>10.0</td>\n",
       "      <td>48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31092</th>\n",
       "      <td>Avengers: Age of Ultron Parody</td>\n",
       "      <td>2015</td>\n",
       "      <td>[short, comedy]</td>\n",
       "      <td>https://www.imdb.com/title/tt5262972/</td>\n",
       "      <td>10.0</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33132</th>\n",
       "      <td>Five Minutes</td>\n",
       "      <td>2017</td>\n",
       "      <td>[short, comedy]</td>\n",
       "      <td>https://www.imdb.com/title/tt6662050/</td>\n",
       "      <td>10.0</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25234</th>\n",
       "      <td>Selam</td>\n",
       "      <td>2013</td>\n",
       "      <td>[drama, romance]</td>\n",
       "      <td>https://www.imdb.com/title/tt2737018/</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31935</th>\n",
       "      <td>Let There Be Light</td>\n",
       "      <td>2017</td>\n",
       "      <td>[drama]</td>\n",
       "      <td>https://www.imdb.com/title/tt5804314/</td>\n",
       "      <td>10.0</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22994</th>\n",
       "      <td>Crawl Bitch Crawl</td>\n",
       "      <td>2012</td>\n",
       "      <td>[horror, sci_fi, thriller]</td>\n",
       "      <td>https://www.imdb.com/title/tt2219210/</td>\n",
       "      <td>10.0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24749</th>\n",
       "      <td>Quiet Riot: Well Now You're Here, There's No W...</td>\n",
       "      <td>2014</td>\n",
       "      <td>[documentary, music]</td>\n",
       "      <td>https://www.imdb.com/title/tt2560840/</td>\n",
       "      <td>10.0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18559</th>\n",
       "      <td>Romeo Juliet</td>\n",
       "      <td>2009</td>\n",
       "      <td>[drama]</td>\n",
       "      <td>https://www.imdb.com/title/tt1431149/</td>\n",
       "      <td>10.0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22046</th>\n",
       "      <td>Third Contact</td>\n",
       "      <td>2011</td>\n",
       "      <td>[drama, mystery, sci_fi, thriller]</td>\n",
       "      <td>https://www.imdb.com/title/tt2059318/</td>\n",
       "      <td>10.0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29574</th>\n",
       "      <td>Make Like a Dog</td>\n",
       "      <td>2015</td>\n",
       "      <td>[short, comedy, drama]</td>\n",
       "      <td>https://www.imdb.com/title/tt4448444/</td>\n",
       "      <td>10.0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   title  year  \\\n",
       "30422                                MSG 2 the Messenger  2015   \n",
       "31092                     Avengers: Age of Ultron Parody  2015   \n",
       "33132                                       Five Minutes  2017   \n",
       "25234                                              Selam  2013   \n",
       "31935                                 Let There Be Light  2017   \n",
       "22994                                  Crawl Bitch Crawl  2012   \n",
       "24749  Quiet Riot: Well Now You're Here, There's No W...  2014   \n",
       "18559                                       Romeo Juliet  2009   \n",
       "22046                                      Third Contact  2011   \n",
       "29574                                    Make Like a Dog  2015   \n",
       "\n",
       "                                   genres  \\\n",
       "30422    [comedy, drama, fantasy, horror]   \n",
       "31092                     [short, comedy]   \n",
       "33132                     [short, comedy]   \n",
       "25234                    [drama, romance]   \n",
       "31935                             [drama]   \n",
       "22994          [horror, sci_fi, thriller]   \n",
       "24749                [documentary, music]   \n",
       "18559                             [drama]   \n",
       "22046  [drama, mystery, sci_fi, thriller]   \n",
       "29574              [short, comedy, drama]   \n",
       "\n",
       "                                   movie_url  mean_rating  n_ratings  \n",
       "30422  https://www.imdb.com/title/tt4921860/         10.0         48  \n",
       "31092  https://www.imdb.com/title/tt5262972/         10.0         28  \n",
       "33132  https://www.imdb.com/title/tt6662050/         10.0         22  \n",
       "25234  https://www.imdb.com/title/tt2737018/         10.0         10  \n",
       "31935  https://www.imdb.com/title/tt5804314/         10.0          7  \n",
       "22994  https://www.imdb.com/title/tt2219210/         10.0          6  \n",
       "24749  https://www.imdb.com/title/tt2560840/         10.0          6  \n",
       "18559  https://www.imdb.com/title/tt1431149/         10.0          5  \n",
       "22046  https://www.imdb.com/title/tt2059318/         10.0          5  \n",
       "29574  https://www.imdb.com/title/tt4448444/         10.0          5  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "top_movies = (\n",
    "    pd\n",
    "        .DataFrame(ratings.groupby('imdb_id')['rating'].mean())\n",
    "        .join(ratings.groupby('imdb_id')['rating'].count(),lsuffix='_mean', rsuffix='_count')\n",
    "        .merge(movies, 'left', 'imdb_id')\n",
    "        .sort_values(['rating_mean', 'rating_count'], ascending=False)\n",
    ")\n",
    "top_movies = (\n",
    "    top_movies\n",
    "        .drop(columns='imdb_id')\n",
    "        .join(top_movies['imdb_id'].apply(movie_url))\n",
    ")\n",
    "top_movies = top_movies[['title', 'year', 'genres', 'imdb_id', 'rating_mean', 'rating_count']]\n",
    "top_movies.columns = ['title', 'year', 'genres', 'movie_url', 'mean_rating', 'n_ratings']\n",
    "top_movies.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>title</th>\n",
       "      <th>year</th>\n",
       "      <th>genres</th>\n",
       "      <th>movie_url</th>\n",
       "      <th>mean_rating</th>\n",
       "      <th>n_ratings</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>8607</th>\n",
       "      <td>The Shawshank Redemption</td>\n",
       "      <td>1994</td>\n",
       "      <td>[drama]</td>\n",
       "      <td>https://www.imdb.com/title/tt0111161/</td>\n",
       "      <td>9.404695</td>\n",
       "      <td>1065</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33748</th>\n",
       "      <td>Joker</td>\n",
       "      <td>2019</td>\n",
       "      <td>[crime, drama, thriller]</td>\n",
       "      <td>https://www.imdb.com/title/tt7286456/</td>\n",
       "      <td>9.124855</td>\n",
       "      <td>2595</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29015</th>\n",
       "      <td>Avengers: Endgame</td>\n",
       "      <td>2019</td>\n",
       "      <td>[action, adventure, fantasy, sci_fi]</td>\n",
       "      <td>https://www.imdb.com/title/tt4154796/</td>\n",
       "      <td>9.043665</td>\n",
       "      <td>1397</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15592</th>\n",
       "      <td>Interstellar</td>\n",
       "      <td>2014</td>\n",
       "      <td>[adventure, drama, sci_fi]</td>\n",
       "      <td>https://www.imdb.com/title/tt0816692/</td>\n",
       "      <td>8.829884</td>\n",
       "      <td>2851</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29014</th>\n",
       "      <td>Avengers: Infinity War</td>\n",
       "      <td>2018</td>\n",
       "      <td>[action, adventure, sci_fi]</td>\n",
       "      <td>https://www.imdb.com/title/tt4154756/</td>\n",
       "      <td>8.764346</td>\n",
       "      <td>1307</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22457</th>\n",
       "      <td>Hacksaw Ridge</td>\n",
       "      <td>2016</td>\n",
       "      <td>[biography, drama, history, war]</td>\n",
       "      <td>https://www.imdb.com/title/tt2119532/</td>\n",
       "      <td>8.710291</td>\n",
       "      <td>1681</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24829</th>\n",
       "      <td>Whiplash</td>\n",
       "      <td>2014</td>\n",
       "      <td>[drama, music]</td>\n",
       "      <td>https://www.imdb.com/title/tt2582802/</td>\n",
       "      <td>8.630022</td>\n",
       "      <td>1792</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34692</th>\n",
       "      <td>1917</td>\n",
       "      <td>2019</td>\n",
       "      <td>[drama, war]</td>\n",
       "      <td>https://www.imdb.com/title/tt8579674/</td>\n",
       "      <td>8.606120</td>\n",
       "      <td>1536</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21125</th>\n",
       "      <td>Django Unchained</td>\n",
       "      <td>2012</td>\n",
       "      <td>[drama, western]</td>\n",
       "      <td>https://www.imdb.com/title/tt1853728/</td>\n",
       "      <td>8.590600</td>\n",
       "      <td>1617</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33221</th>\n",
       "      <td>Gisaengchung</td>\n",
       "      <td>2019</td>\n",
       "      <td>[drama]</td>\n",
       "      <td>https://www.imdb.com/title/tt6751668/</td>\n",
       "      <td>8.547860</td>\n",
       "      <td>1285</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                          title  year                                genres  \\\n",
       "8607   The Shawshank Redemption  1994                               [drama]   \n",
       "33748                     Joker  2019              [crime, drama, thriller]   \n",
       "29015         Avengers: Endgame  2019  [action, adventure, fantasy, sci_fi]   \n",
       "15592              Interstellar  2014            [adventure, drama, sci_fi]   \n",
       "29014    Avengers: Infinity War  2018           [action, adventure, sci_fi]   \n",
       "22457             Hacksaw Ridge  2016      [biography, drama, history, war]   \n",
       "24829                  Whiplash  2014                        [drama, music]   \n",
       "34692                      1917  2019                          [drama, war]   \n",
       "21125          Django Unchained  2012                      [drama, western]   \n",
       "33221              Gisaengchung  2019                               [drama]   \n",
       "\n",
       "                                   movie_url  mean_rating  n_ratings  \n",
       "8607   https://www.imdb.com/title/tt0111161/     9.404695       1065  \n",
       "33748  https://www.imdb.com/title/tt7286456/     9.124855       2595  \n",
       "29015  https://www.imdb.com/title/tt4154796/     9.043665       1397  \n",
       "15592  https://www.imdb.com/title/tt0816692/     8.829884       2851  \n",
       "29014  https://www.imdb.com/title/tt4154756/     8.764346       1307  \n",
       "22457  https://www.imdb.com/title/tt2119532/     8.710291       1681  \n",
       "24829  https://www.imdb.com/title/tt2582802/     8.630022       1792  \n",
       "34692  https://www.imdb.com/title/tt8579674/     8.606120       1536  \n",
       "21125  https://www.imdb.com/title/tt1853728/     8.590600       1617  \n",
       "33221  https://www.imdb.com/title/tt6751668/     8.547860       1285  "
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "top_movies[top_movies['n_ratings'] >= 1000].sort_values('mean_rating', ascending=False).head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>title</th>\n",
       "      <th>year</th>\n",
       "      <th>genres</th>\n",
       "      <th>movie_url</th>\n",
       "      <th>mean_rating</th>\n",
       "      <th>n_ratings</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>21590</th>\n",
       "      <td>The Hangover Part III</td>\n",
       "      <td>2013</td>\n",
       "      <td>[adventure, comedy, crime]</td>\n",
       "      <td>https://www.imdb.com/title/tt1951261/</td>\n",
       "      <td>6.081818</td>\n",
       "      <td>1100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25549</th>\n",
       "      <td>Lucy</td>\n",
       "      <td>2014</td>\n",
       "      <td>[action, sci_fi, thriller]</td>\n",
       "      <td>https://www.imdb.com/title/tt2872732/</td>\n",
       "      <td>6.507125</td>\n",
       "      <td>1193</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18319</th>\n",
       "      <td>Suicide Squad</td>\n",
       "      <td>2016</td>\n",
       "      <td>[action, adventure, fantasy, sci_fi]</td>\n",
       "      <td>https://www.imdb.com/title/tt1386697/</td>\n",
       "      <td>6.564557</td>\n",
       "      <td>1580</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15667</th>\n",
       "      <td>Godzilla</td>\n",
       "      <td>2014</td>\n",
       "      <td>[action, adventure, sci_fi, thriller]</td>\n",
       "      <td>https://www.imdb.com/title/tt0831387/</td>\n",
       "      <td>6.669903</td>\n",
       "      <td>1442</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25856</th>\n",
       "      <td>Batman v Superman: Dawn of Justice</td>\n",
       "      <td>2016</td>\n",
       "      <td>[action, adventure, fantasy, sci_fi]</td>\n",
       "      <td>https://www.imdb.com/title/tt2975590/</td>\n",
       "      <td>6.824848</td>\n",
       "      <td>1650</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18549</th>\n",
       "      <td>The Wolverine</td>\n",
       "      <td>2013</td>\n",
       "      <td>[action, adventure, sci_fi]</td>\n",
       "      <td>https://www.imdb.com/title/tt1430132/</td>\n",
       "      <td>6.856841</td>\n",
       "      <td>1418</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18366</th>\n",
       "      <td>It</td>\n",
       "      <td>2017</td>\n",
       "      <td>[horror, thriller]</td>\n",
       "      <td>https://www.imdb.com/title/tt1396484/</td>\n",
       "      <td>6.858114</td>\n",
       "      <td>1177</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19125</th>\n",
       "      <td>Elysium</td>\n",
       "      <td>2013</td>\n",
       "      <td>[action, drama, sci_fi]</td>\n",
       "      <td>https://www.imdb.com/title/tt1535108/</td>\n",
       "      <td>6.920126</td>\n",
       "      <td>1590</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17625</th>\n",
       "      <td>This Is the End</td>\n",
       "      <td>2013</td>\n",
       "      <td>[comedy, fantasy]</td>\n",
       "      <td>https://www.imdb.com/title/tt1245492/</td>\n",
       "      <td>6.977344</td>\n",
       "      <td>1280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18819</th>\n",
       "      <td>Oblivion</td>\n",
       "      <td>2013</td>\n",
       "      <td>[action, adventure, sci_fi]</td>\n",
       "      <td>https://www.imdb.com/title/tt1483013/</td>\n",
       "      <td>7.010017</td>\n",
       "      <td>1797</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    title  year  \\\n",
       "21590               The Hangover Part III  2013   \n",
       "25549                                Lucy  2014   \n",
       "18319                       Suicide Squad  2016   \n",
       "15667                            Godzilla  2014   \n",
       "25856  Batman v Superman: Dawn of Justice  2016   \n",
       "18549                       The Wolverine  2013   \n",
       "18366                                  It  2017   \n",
       "19125                             Elysium  2013   \n",
       "17625                     This Is the End  2013   \n",
       "18819                            Oblivion  2013   \n",
       "\n",
       "                                      genres  \\\n",
       "21590             [adventure, comedy, crime]   \n",
       "25549             [action, sci_fi, thriller]   \n",
       "18319   [action, adventure, fantasy, sci_fi]   \n",
       "15667  [action, adventure, sci_fi, thriller]   \n",
       "25856   [action, adventure, fantasy, sci_fi]   \n",
       "18549            [action, adventure, sci_fi]   \n",
       "18366                     [horror, thriller]   \n",
       "19125                [action, drama, sci_fi]   \n",
       "17625                      [comedy, fantasy]   \n",
       "18819            [action, adventure, sci_fi]   \n",
       "\n",
       "                                   movie_url  mean_rating  n_ratings  \n",
       "21590  https://www.imdb.com/title/tt1951261/     6.081818       1100  \n",
       "25549  https://www.imdb.com/title/tt2872732/     6.507125       1193  \n",
       "18319  https://www.imdb.com/title/tt1386697/     6.564557       1580  \n",
       "15667  https://www.imdb.com/title/tt0831387/     6.669903       1442  \n",
       "25856  https://www.imdb.com/title/tt2975590/     6.824848       1650  \n",
       "18549  https://www.imdb.com/title/tt1430132/     6.856841       1418  \n",
       "18366  https://www.imdb.com/title/tt1396484/     6.858114       1177  \n",
       "19125  https://www.imdb.com/title/tt1535108/     6.920126       1590  \n",
       "17625  https://www.imdb.com/title/tt1245492/     6.977344       1280  \n",
       "18819  https://www.imdb.com/title/tt1483013/     7.010017       1797  "
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "top_movies[top_movies['n_ratings'] >= 1000].sort_values('mean_rating').head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>title</th>\n",
       "      <th>year</th>\n",
       "      <th>genres</th>\n",
       "      <th>movie_url</th>\n",
       "      <th>mean_rating</th>\n",
       "      <th>n_ratings</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>9730</th>\n",
       "      <td>The Thin Red Line</td>\n",
       "      <td>1998</td>\n",
       "      <td>[drama, war]</td>\n",
       "      <td>https://www.imdb.com/title/tt0120863/</td>\n",
       "      <td>3.542969</td>\n",
       "      <td>256</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15420</th>\n",
       "      <td>Scary Movie 5</td>\n",
       "      <td>2013</td>\n",
       "      <td>[comedy]</td>\n",
       "      <td>https://www.imdb.com/title/tt0795461/</td>\n",
       "      <td>3.808081</td>\n",
       "      <td>198</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3599</th>\n",
       "      <td>Where Eagles Dare</td>\n",
       "      <td>1968</td>\n",
       "      <td>[action, adventure, war]</td>\n",
       "      <td>https://www.imdb.com/title/tt0065207/</td>\n",
       "      <td>4.225490</td>\n",
       "      <td>102</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18083</th>\n",
       "      <td>Movie 43</td>\n",
       "      <td>2013</td>\n",
       "      <td>[comedy]</td>\n",
       "      <td>https://www.imdb.com/title/tt1333125/</td>\n",
       "      <td>4.267782</td>\n",
       "      <td>239</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23553</th>\n",
       "      <td>50 tinten grijs</td>\n",
       "      <td>2015</td>\n",
       "      <td>[drama, romance, thriller]</td>\n",
       "      <td>https://www.imdb.com/title/tt2322441/</td>\n",
       "      <td>4.420323</td>\n",
       "      <td>433</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17593</th>\n",
       "      <td>Death Note</td>\n",
       "      <td>2017</td>\n",
       "      <td>[adventure, crime, drama, fantasy, horror, mys...</td>\n",
       "      <td>https://www.imdb.com/title/tt1241317/</td>\n",
       "      <td>4.440000</td>\n",
       "      <td>275</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16542</th>\n",
       "      <td>The Legend of Hercules</td>\n",
       "      <td>2014</td>\n",
       "      <td>[action, adventure, fantasy]</td>\n",
       "      <td>https://www.imdb.com/title/tt1043726/</td>\n",
       "      <td>4.504673</td>\n",
       "      <td>214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15192</th>\n",
       "      <td>Rings</td>\n",
       "      <td>2017</td>\n",
       "      <td>[drama, horror, mystery, romance, thriller]</td>\n",
       "      <td>https://www.imdb.com/title/tt0498381/</td>\n",
       "      <td>4.525862</td>\n",
       "      <td>116</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18910</th>\n",
       "      <td>Fantastic Four</td>\n",
       "      <td>2015</td>\n",
       "      <td>[action, adventure, drama, sci_fi]</td>\n",
       "      <td>https://www.imdb.com/title/tt1502712/</td>\n",
       "      <td>4.535135</td>\n",
       "      <td>370</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19548</th>\n",
       "      <td>Zoolander 2</td>\n",
       "      <td>2016</td>\n",
       "      <td>[comedy]</td>\n",
       "      <td>https://www.imdb.com/title/tt1608290/</td>\n",
       "      <td>4.560241</td>\n",
       "      <td>166</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        title  year  \\\n",
       "9730        The Thin Red Line  1998   \n",
       "15420           Scary Movie 5  2013   \n",
       "3599        Where Eagles Dare  1968   \n",
       "18083                Movie 43  2013   \n",
       "23553         50 tinten grijs  2015   \n",
       "17593              Death Note  2017   \n",
       "16542  The Legend of Hercules  2014   \n",
       "15192                   Rings  2017   \n",
       "18910          Fantastic Four  2015   \n",
       "19548             Zoolander 2  2016   \n",
       "\n",
       "                                                  genres  \\\n",
       "9730                                        [drama, war]   \n",
       "15420                                           [comedy]   \n",
       "3599                            [action, adventure, war]   \n",
       "18083                                           [comedy]   \n",
       "23553                         [drama, romance, thriller]   \n",
       "17593  [adventure, crime, drama, fantasy, horror, mys...   \n",
       "16542                       [action, adventure, fantasy]   \n",
       "15192        [drama, horror, mystery, romance, thriller]   \n",
       "18910                 [action, adventure, drama, sci_fi]   \n",
       "19548                                           [comedy]   \n",
       "\n",
       "                                   movie_url  mean_rating  n_ratings  \n",
       "9730   https://www.imdb.com/title/tt0120863/     3.542969        256  \n",
       "15420  https://www.imdb.com/title/tt0795461/     3.808081        198  \n",
       "3599   https://www.imdb.com/title/tt0065207/     4.225490        102  \n",
       "18083  https://www.imdb.com/title/tt1333125/     4.267782        239  \n",
       "23553  https://www.imdb.com/title/tt2322441/     4.420323        433  \n",
       "17593  https://www.imdb.com/title/tt1241317/     4.440000        275  \n",
       "16542  https://www.imdb.com/title/tt1043726/     4.504673        214  \n",
       "15192  https://www.imdb.com/title/tt0498381/     4.525862        116  \n",
       "18910  https://www.imdb.com/title/tt1502712/     4.535135        370  \n",
       "19548  https://www.imdb.com/title/tt1608290/     4.560241        166  "
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "top_movies[top_movies['n_ratings'] >= 100].sort_values('mean_rating').head(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Conclusies\n",
    "35611 films, 857465 beoordelingen en 62798 gebruikers.\n",
    "\n",
    "## Ratings\n",
    "De gemiddelde gebruiker beoordeeld weinig films ($ \\overline{x} $ = 13,65, s = 48,88 en mediaan = 2). De gemiddelde film wordt weinig beoordeeld ($ \\overline{x} $ = 24,08, s = 111,88 en mediaan = 2). Voor beide zijn uitschieters geen anomalieën. Beoordelingen zijn hoofdzakelijk positief ($ \\overline{x} $ = 7,31, s = 1,85 en mediaan = 8). Kolom `date_time` is vermoedelijk seconden sinds Unix epoch, lokale tijd."
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}