{ "nbformat": 4, "nbformat_minor": 0, "metadata": { "colab": { "provenance": [] }, "kernelspec": { "name": "python3", "display_name": "Python 3" }, "language_info": { "name": "python" } }, "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 206 }, "id": "WEQcMPxX2Wfm", "outputId": "f85fe99e-53a8-45f4-9382-6960df6fd020" }, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " user_id item_id rating timestamp\n", "0 0 50 5 881250949\n", "1 0 172 5 881250949\n", "2 0 133 1 881250949\n", "3 196 242 3 881250949\n", "4 186 302 3 891717742" ], "text/html": [ "\n", "
\n", "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
user_iditem_idratingtimestamp
00505881250949
101725881250949
201331881250949
31962423881250949
41863023891717742
\n", "
\n", "
\n", "\n", "
\n", " \n", "\n", " \n", "\n", " \n", "
\n", "\n", "\n", "
\n", " \n", "\n", "\n", "\n", " \n", "
\n", "\n", "
\n", "
\n" ], "application/vnd.google.colaboratory.intrinsic+json": { "type": "dataframe", "variable_name": "df" } }, "metadata": {}, "execution_count": 1 } ], "source": [ "import pandas as pd\n", "\n", "column_names = ['user_id', 'item_id', 'rating', 'timestamp']\n", "\n", "path = '/content/file (2).tsv'\n", "\n", "df = pd.read_csv(path, sep='\\t', names=column_names)\n", "\n", "df.head()" ] }, { "cell_type": "code", "source": [ "movie_titles = pd.read_csv('/content/Movie_Id_Titles (2).csv')\n", "movie_titles.head()" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 206 }, "id": "_h0PJiH-23Z6", "outputId": "00c5e194-daed-4726-b0f5-d050b99655c1" }, "execution_count": 2, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " item_id title\n", "0 1 Toy Story (1995)\n", "1 2 GoldenEye (1995)\n", "2 3 Four Rooms (1995)\n", "3 4 Get Shorty (1995)\n", "4 5 Copycat (1995)" ], "text/html": [ "\n", "
\n", "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
item_idtitle
01Toy Story (1995)
12GoldenEye (1995)
23Four Rooms (1995)
34Get Shorty (1995)
45Copycat (1995)
\n", "
\n", "
\n", "\n", "
\n", " \n", "\n", " \n", "\n", " \n", "
\n", "\n", "\n", "
\n", " \n", "\n", "\n", "\n", " \n", "
\n", "\n", "
\n", "
\n" ], "application/vnd.google.colaboratory.intrinsic+json": { "type": "dataframe", "variable_name": "movie_titles", "summary": "{\n \"name\": \"movie_titles\",\n \"rows\": 1682,\n \"fields\": [\n {\n \"column\": \"item_id\",\n \"properties\": {\n \"dtype\": \"number\",\n \"std\": 485,\n \"min\": 1,\n \"max\": 1682,\n \"num_unique_values\": 1682,\n \"samples\": [\n 1394,\n 744,\n 1606\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"title\",\n \"properties\": {\n \"dtype\": \"string\",\n \"num_unique_values\": 1664,\n \"samples\": [\n \"Madame Butterfly (1995)\",\n \"Wrong Trousers, The (1993)\",\n \"Breaking the Waves (1996)\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n }\n ]\n}" } }, "metadata": {}, "execution_count": 2 } ] }, { "cell_type": "code", "source": [ "data = pd.merge(df, movie_titles, on='item_id')\n", "data.head()" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 206 }, "id": "y3te73Rh27m7", "outputId": "0b7a2d86-7d18-43a1-ef4c-9460a36a3c75" }, "execution_count": 3, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " user_id item_id rating timestamp title\n", "0 0 50 5 881250949 Star Wars (1977)\n", "1 0 172 5 881250949 Empire Strikes Back, The (1980)\n", "2 0 133 1 881250949 Gone with the Wind (1939)\n", "3 196 242 3 881250949 Kolya (1996)\n", "4 186 302 3 891717742 L.A. Confidential (1997)" ], "text/html": [ "\n", "
\n", "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
user_iditem_idratingtimestamptitle
00505881250949Star Wars (1977)
101725881250949Empire Strikes Back, The (1980)
201331881250949Gone with the Wind (1939)
31962423881250949Kolya (1996)
41863023891717742L.A. Confidential (1997)
\n", "
\n", "
\n", "\n", "
\n", " \n", "\n", " \n", "\n", " \n", "
\n", "\n", "\n", "
\n", " \n", "\n", "\n", "\n", " \n", "
\n", "\n", "
\n", "
\n" ], "application/vnd.google.colaboratory.intrinsic+json": { "type": "dataframe", "variable_name": "data" } }, "metadata": {}, "execution_count": 3 } ] }, { "cell_type": "code", "source": [ "data.groupby('title')['rating'].mean().sort_values(ascending=False).head()" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 272 }, "id": "b2yC5LIT27py", "outputId": "34238193-e205-4373-8704-5e6e57ae4fea" }, "execution_count": 4, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ "title\n", "Aiqing wansui (1994) 5.0\n", "Entertaining Angels: The Dorothy Day Story (1996) 5.0\n", "Santa with Muscles (1996) 5.0\n", "Prefontaine (1997) 5.0\n", "They Made Me a Criminal (1939) 5.0\n", "Name: rating, dtype: float64" ], "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
rating
title
Aiqing wansui (1994)5.0
Entertaining Angels: The Dorothy Day Story (1996)5.0
Santa with Muscles (1996)5.0
Prefontaine (1997)5.0
They Made Me a Criminal (1939)5.0
\n", "

" ] }, "metadata": {}, "execution_count": 4 } ] }, { "cell_type": "code", "source": [ "data.groupby('title')['rating'].count().sort_values(ascending=False).head()" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 272 }, "id": "qGZWRA-J27ta", "outputId": "75ebdb8a-f02f-43e7-b82f-23be1ca6f3bd" }, "execution_count": 5, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ "title\n", "Star Wars (1977) 584\n", "Contact (1997) 509\n", "Fargo (1996) 508\n", "Return of the Jedi (1983) 507\n", "Liar Liar (1997) 485\n", "Name: rating, dtype: int64" ], "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
rating
title
Star Wars (1977)584
Contact (1997)509
Fargo (1996)508
Return of the Jedi (1983)507
Liar Liar (1997)485
\n", "

" ] }, "metadata": {}, "execution_count": 5 } ] }, { "cell_type": "code", "source": [ "ratings = pd.DataFrame(data.groupby('title')['rating'].mean())\n", "\n", "ratings['num of ratings'] = pd.DataFrame(data.groupby('title')['rating'].count())\n", "\n", "ratings.head()" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 237 }, "id": "Y0Pofn_G3EjG", "outputId": "edce2127-d74b-49f5-ab48-bc7ba4fab91c" }, "execution_count": 6, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " rating num of ratings\n", "title \n", "'Til There Was You (1997) 2.333333 9\n", "1-900 (1994) 2.600000 5\n", "101 Dalmatians (1996) 2.908257 109\n", "12 Angry Men (1957) 4.344000 125\n", "187 (1997) 3.024390 41" ], "text/html": [ "\n", "
\n", "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
ratingnum of ratings
title
'Til There Was You (1997)2.3333339
1-900 (1994)2.6000005
101 Dalmatians (1996)2.908257109
12 Angry Men (1957)4.344000125
187 (1997)3.02439041
\n", "
\n", "
\n", "\n", "
\n", " \n", "\n", " \n", "\n", " \n", "
\n", "\n", "\n", "
\n", " \n", "\n", "\n", "\n", " \n", "
\n", "\n", "
\n", "
\n" ], "application/vnd.google.colaboratory.intrinsic+json": { "type": "dataframe", "variable_name": "ratings", "summary": "{\n \"name\": \"ratings\",\n \"rows\": 1664,\n \"fields\": [\n {\n \"column\": \"title\",\n \"properties\": {\n \"dtype\": \"string\",\n \"num_unique_values\": 1664,\n \"samples\": [\n \"Tainted (1998)\",\n \"Big Bully (1996)\",\n \"Boys, Les (1997)\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"rating\",\n \"properties\": {\n \"dtype\": \"number\",\n \"std\": 0.7804112593703875,\n \"min\": 1.0,\n \"max\": 5.0,\n \"num_unique_values\": 896,\n \"samples\": [\n 3.143835616438356,\n 2.125,\n 4.23121387283237\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"num of ratings\",\n \"properties\": {\n \"dtype\": \"number\",\n \"std\": 80,\n \"min\": 1,\n \"max\": 584,\n \"num_unique_values\": 273,\n \"samples\": [\n 32,\n 24,\n 86\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n }\n ]\n}" } }, "metadata": {}, "execution_count": 6 } ] }, { "cell_type": "code", "source": [ "import matplotlib.pyplot as plt\n", "import seaborn as sns\n", "\n", "sns.set_style('white')\n", "%matplotlib inline" ], "metadata": { "id": "As2sTBmA3HGa" }, "execution_count": 7, "outputs": [] }, { "cell_type": "code", "source": [ "plt.figure(figsize =(10, 4))\n", "\n", "ratings['num of ratings'].hist(bins = 70)" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 385 }, "id": "4mpUIOLq3KC1", "outputId": "b5f7534e-df60-4a73-c18b-03c08a1c5d49" }, "execution_count": 8, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ "" ] }, "metadata": {}, "execution_count": 8 }, { "output_type": "display_data", "data": { "text/plain": [ "
" ], "image/png": "iVBORw0KGgoAAAANSUhEUgAAAz8AAAFfCAYAAABgPnIwAAAAOnRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjEwLjAsIGh0dHBzOi8vbWF0cGxvdGxpYi5vcmcvlHJYcgAAAAlwSFlzAAAPYQAAD2EBqD+naQAAKJVJREFUeJzt3X9wVfWd//EXuSQx4SZRkiAGukqJSYghyY06mHjbrF3X/lB3NrBbdLO1dRjBrRBG+eWyahKIIay6G3CsWKQMIjSTKcUZobZjp8gsS1zsTNIE6kRuWatuanNzLYT8+ObHzf3+weSOFwXuSW5yyfk8HzOZ4Z7zPvd8PnkTzYtzzudOCwQCAQEAAACAzcVEewAAAAAAMBkIPwAAAACMQPgBAAAAYATCDwAAAAAjEH4AAAAAGIHwAwAAAMAIhB8AAAAARpge7QGMxcjIiDo7OzVjxgxNmzYt2sMBAAAAECWBQEC9vb2aNWuWYmIuf21nSoafzs5OlZaWRnsYAAAAAK4SR48e1ezZsy9bMyXDz4wZMyRdmKDT6YzaOPx+v1pbW5Wfny+HwxG1cWDi0GP7o8f2R4/tjx7bG/21v/H2uKenR6WlpcGMcDlTMvyM3urmdDqjHn4SExPldDr5YbQpemx/9Nj+6LH90WN7o7/2F6keh/M4DAseAAAAADAC4QcAAACAEQg/AAAAAIxA+AEAAABgBMIPAAAAACMQfgAAAAAYgfADAAAAwAiEHwAAAABGIPwAAAAAMALhBwAAAIARCD8AAAAAjED4AQAAAGAEws84xcbGStPC+zb6RwITPBoAAAAAlzI92gOY6qZPny5HzDStbmiWp7PnknWZs5za9oBrEkcGAAAA4PMIPxHi6ezRqY7uaA8DAAAAwCVw2xsAAAAAIxB+AAAAABiB8AMAAADACIQfAAAAAEawFH5efPFFZWdnh3x961vfCu4fGBhQdXW1Fi1aJJfLpVWrVqmrqyvkPTo6OrR8+XIVFBSouLhYW7du1fDwcGRmAwAAAACXYHm1t5tvvlm7d+8OvnY4HME/19bW6ujRo6qvr1dSUpI2b96slStXqqGhQZLk9/u1YsUKpaWlqaGhQZ2dndqwYYNiY2P1xBNPRGA6AAAAAPDlLN/25nA4lJ6eHvyaOXOmJOn8+fM6cOCAnnzySRUXFysvL0+1tbVqbm5WS0uLJOnYsWPyeDx67rnntGDBApWWlmr16tXat2+fBgcHIzoxAAAAAPg8y1d+/vjHP8rtdis+Pl6FhYVas2aNMjIydPLkSQ0NDamkpCRYO3/+fGVkZKilpUWFhYVqaWlRVlaW0tLSgjVut1tVVVXyeDzKzc21NBa/3y+/3291ChEzlnNHc7ywbrRf9M2+6LH90WP7o8f2Rn/tb7w9tnKcpfCTn5+vLVu2aN68efJ6vXrppZdUXl6uN998U11dXYqNjVVycnLIMampqfJ6vZKkrq6ukOAjKfh6tMaK1tZWJSYmWj4ukhISEizVt7e3q7+/f4JGg4nS1tYW7SFggtFj+6PH9keP7Y3+2t9Ye9zX1xd2raXwU1paGvxzTk6OCgoKdNddd+mtt97SNddcY+WtIiI/P19Op3PSzzvK7/fL4/FYOiY7O3uCRoOJ4Pf71dbWpoULF4Y83wb7oMf2R4/tjx7bG/21v/H2uKenJ+xay7e9fV5ycrJuuukmffTRRyopKdHQ0JC6u7tDrv74fD6lp6dLunCVp7W1NeQ9RleDG62xwuFwTLkfgqk2XlwwFf+uwRp6bH/02P7osb3RX/sba4+tHDOuz/np7e3Vxx9/rPT0dOXl5Sk2NlZNTU3B/WfOnFFHR4cKCwslSYWFhfrggw/k8/mCNcePH5fT6VRmZuZ4hgIAAAAAl2Xpys/WrVt11113KSMjQ52dnXrxxRcVExOj++67T0lJSVqyZInq6uqUkpIip9OpmpoauVyuYPhxu93KzMzU+vXrtW7dOnm9XtXX16u8vFxxcXETMT8AAAAAkGQx/Hz66ad64okndPbsWc2cOVO33nqrGhsbg8tdb9y4UTExMaqoqNDg4KDcbrcqKyuDxzscDu3YsUNVVVVaunSpEhISVFZWpoqKisjOCgAAAAAuYin8/Od//udl98fHx6uysjIk8Fxszpw52rlzp5XTAgAAAMC4jeuZHwAAAACYKgg/AAAAAIxA+AEAAABgBMIPAAAAACMQfgAAAAAYgfADAAAAwAiEHwAAAABGIPwAAAAAMALhBwAAAIARCD8AAAAAjED4AQAAAGAEwg8AAAAAIxB+AAAAABiB8AMAAADACIQfAAAAAEYg/AAAAAAwAuEHAAAAgBEIPwAAAACMQPgBAAAAYATCDwAAAAAjEH4AAAAAGIHwAwAAAMAIhB8AAAAARiD8AAAAADAC4QcAAACAEQg/AAAAAIxA+AEAAABgBMIPAAAAACMQfgAAAAAYgfADAAAAwAiEHwAAAABGIPwAAAAAMALhBwAAAIARCD8AAAAAjED4AQAAAGAEwg8AAAAAIxB+AAAAABiB8AMAAADACIQfAAAAAEYg/AAAAAAwAuEHAAAAgBEIPwAAAACMQPgBAAAAYATCDwAAAAAjEH4AAAAAGIHwAwAAAMAI4wo/P/7xj5Wdna1nn302uG1gYEDV1dVatGiRXC6XVq1apa6urpDjOjo6tHz5chUUFKi4uFhbt27V8PDweIYCAAAAAJc15vDT2tqqhoYGZWdnh2yvra3VkSNHVF9fr71796qzs1MrV64M7vf7/VqxYoWGhobU0NCguro6HTx4UNu3bx/7LAAAAADgCsYUfnp7e7Vu3TrV1NQoJSUluP38+fM6cOCAnnzySRUXFysvL0+1tbVqbm5WS0uLJOnYsWPyeDx67rnntGDBApWWlmr16tXat2+fBgcHIzIpAAAAALjY9LEctGnTJpWWlqqkpEQvv/xycPvJkyc1NDSkkpKS4Lb58+crIyNDLS0tKiwsVEtLi7KyspSWlhascbvdqqqqksfjUW5ubtjj8Pv98vv9Y5lCRIzl3NEcL6wb7Rd9sy96bH/02P7osb3RX/sbb4+tHGc5/Bw+fFi///3v9bOf/ewL+7q6uhQbG6vk5OSQ7ampqfJ6vcGazwcfScHXozXham1tVWJioqVjIi0hIcFSfXt7u/r7+ydoNJgobW1t0R4CJhg9tj96bH/02N7or/2Ntcd9fX1h11oKP3/605/07LPP6ic/+Yni4+MtDyzS8vPz5XQ6o3Z+v98vj8dj6ZiLn5HC1c3v96utrU0LFy6Uw+GI9nAwAeix/dFj+6PH9kZ/7W+8Pe7p6Qm71lL4OXXqlHw+nxYvXhzc5vf79d5772nfvn3atWuXhoaG1N3dHXL1x+fzKT09XdKFqzytra0h7zu6GtxoTbgcDseU+yGYauPFBVPx7xqsocf2R4/tjx7bG/21v7H22MoxlsLPHXfcoTfffDNk27/+67/qq1/9qh555BHdcMMNio2NVVNTk775zW9Kks6cOaOOjg4VFhZKkgoLC7Vjxw75fD6lpqZKko4fPy6n06nMzEwrwwEAAACAsFkKP06nU1lZWSHbEhMTde211wa3L1myRHV1dUpJSZHT6VRNTY1cLlcw/LjdbmVmZmr9+vVat26dvF6v6uvrVV5erri4uMjMCgAAAAAuMqbV3i5n48aNiomJUUVFhQYHB+V2u1VZWRnc73A4tGPHDlVVVWnp0qVKSEhQWVmZKioqIj0UAAAAAAgad/jZu3dvyOv4+HhVVlaGBJ6LzZkzRzt37hzvqQEAAAAgbGP6kFMAAAAAmGoIPwAAAACMQPgBAAAAYATCDwAAAAAjEH4AAAAAGIHwAwAAAMAIhB8AAAAARiD8AAAAADAC4QcAAACAEQg/AAAAAIxA+AEAAABgBMIPAAAAACMQfgAAAAAYgfADAAAAwAiEHwAAAABGIPwAAAAAMALhBwAAAIARCD8AAAAAjED4AQAAAGAEwg8AAAAAIxB+AAAAABiB8AMAAADACIQfAAAAAEYg/AAAAAAwAuEHAAAAgBEIPwAAAACMQPgBAAAAYATCDwAAAAAjEH4AAAAAGIHwAwAAAMAIhB8AAAAARiD8AAAAADAC4QcAAACAEQg/AAAAAIxA+AEAAABgBMIPAAAAACMQfgAAAAAYgfADAAAAwAiEHwAAAABGIPwAAAAAMALhBwAAAIARCD8AAAAAjED4AQAAAGAEwg8AAAAAIxB+AAAAABjBUvjZv3+/7r//fhUVFamoqEhLly7V0aNHg/sHBgZUXV2tRYsWyeVyadWqVerq6gp5j46ODi1fvlwFBQUqLi7W1q1bNTw8HJnZAAAAAMAlWAo/s2fP1tq1a/Xzn/9cBw4c0B133KHHHntMp0+fliTV1tbqyJEjqq+v1969e9XZ2amVK1cGj/f7/VqxYoWGhobU0NCguro6HTx4UNu3b4/srAAAAADgIpbCzze+8Q2Vlpbqpptu0rx58/T4448rMTFRLS0tOn/+vA4cOKAnn3xSxcXFysvLU21trZqbm9XS0iJJOnbsmDwej5577jktWLBApaWlWr16tfbt26fBwcGJmB8AAAAASJKmj/VAv9+vX/7yl+rr65PL5dLJkyc1NDSkkpKSYM38+fOVkZGhlpYWFRYWqqWlRVlZWUpLSwvWuN1uVVVVyePxKDc31/IY/H7/WKcwbmM5dzTHC+tG+0Xf7Ise2x89tj96bG/01/7G22Mrx1kOP+3t7XrggQc0MDCgxMREvfTSS8rMzNT777+v2NhYJScnh9SnpqbK6/VKkrq6ukKCj6Tg69EaK1pbW5WYmGj5uEhKSEiwVN/e3q7+/v4JGg0mSltbW7SHgAlGj+2PHtsfPbY3+mt/Y+1xX19f2LWWw8+8efP0xhtv6Pz58/rVr36lDRs26PXXX7f6NhGRn58vp9MZlXNLF1Kmx+OxdEx2dvYEjQYTwe/3q62tTQsXLpTD4Yj2cDAB6LH90WP7o8f2Rn/tb7w97unpCbvWcviJi4vTjTfeKEnKy8tTW1ubXnvtNX3729/W0NCQuru7Q67++Hw+paenS7pwlae1tTXk/UZXgxutscLhcEy5H4KpNl5cMBX/rsEaemx/9Nj+6LG90V/7G2uPrRwz7s/5GRkZ0eDgoPLy8hQbG6umpqbgvjNnzqijo0OFhYWSpMLCQn3wwQfy+XzBmuPHj8vpdCozM3O8QwEAAACAS7J05eeFF17Q17/+dd1www3q7e3VoUOHdOLECe3atUtJSUlasmSJ6urqlJKSIqfTqZqaGrlcrmD4cbvdyszM1Pr167Vu3Tp5vV7V19ervLxccXFxEzE/AAAAAJBkMfz4fD5t2LBBnZ2dSkpKUnZ2tnbt2qU777xTkrRx40bFxMSooqJCg4ODcrvdqqysDB7vcDi0Y8cOVVVVaenSpUpISFBZWZkqKioiOysAAAAAuIil8FNbW3vZ/fHx8aqsrAwJPBebM2eOdu7caeW0AAAAADBu437mBwAAAACmAsIPAAAAACMQfgAAAAAYgfADAAAAwAiEHwAAAABGIPwAAAAAMALhBwAAAIARCD8AAAAAjED4AQAAAGAEwg8AAAAAIxB+AAAAABiB8AMAAADACIQfAAAAAEYg/AAAAAAwAuEHAAAAgBEIPwAAAACMQPgBAAAAYATCDwAAAAAjEH4AAAAAGIHwAwAAAMAIhB8AAAAARiD8AAAAADAC4QcAAACAEQg/AAAAAIxA+AEAAABgBMIPAAAAACMQfgAAAAAYgfADAAAAwAiEHwAAAABGIPwAAAAAMALhBwAAAIARCD8AAAAAjED4AQAAAGAEwg8AAAAAIxB+AAAAABiB8AMAAADACIQfAAAAAEYg/AAAAAAwAuEHAAAAgBEIPwAAAACMQPgBAAAAYATCDwAAAAAjEH4AAAAAGIHwAwAAAMAIhB8AAAAARiD8AAAAADCCpfDzyiuvaMmSJXK5XCouLtYPf/hDnTlzJqRmYGBA1dXVWrRokVwul1atWqWurq6Qmo6ODi1fvlwFBQUqLi7W1q1bNTw8PP7ZAAAAAMAlWAo/J06cUHl5uRobG7V7924NDw9r2bJl6uvrC9bU1tbqyJEjqq+v1969e9XZ2amVK1cG9/v9fq1YsUJDQ0NqaGhQXV2dDh48qO3bt0duVgAAAABwkelWinft2hXyuq6uTsXFxTp16pRuv/12nT9/XgcOHNDzzz+v4uJiSRfC0He+8x21tLSosLBQx44dk8fj0e7du5WWlqYFCxZo9erVev7557Vy5UrFxcWFPR6/3y+/329lChE1lnNHc7ywbrRf9M2+6LH90WP7o8f2Rn/tb7w9tnKcpfBzsfPnz0uSUlJSJEknT57U0NCQSkpKgjXz589XRkZGMPy0tLQoKytLaWlpwRq3262qqip5PB7l5uaGff7W1lYlJiaOZwrjlpCQYKm+vb1d/f39EzQaTJS2trZoDwETjB7bHz22P3psb/TX/sba48/fhXYlYw4/IyMjqq2tVVFRkbKysiRJXV1dio2NVXJyckhtamqqvF5vsObzwUdS8PVoTbjy8/PldDrHOoVx8/v98ng8lo7Jzs6eoNFgIvj9frW1tWnhwoVyOBzRHg4mAD22P3psf/TY3uiv/Y23xz09PWHXjjn8VFdX6/Tp09q/f/9Y32LcHA7HlPshmGrjxQVT8e8arKHH9keP7Y8e2xv9tb+x9tjKMWNa6nrTpk165513tGfPHs2ePTu4PS0tTUNDQ+ru7g6p9/l8Sk9PD9ZcvPrb6OvRGgAAAACINEvhJxAIaNOmTXr77be1Z88efeUrXwnZn5eXp9jYWDU1NQW3nTlzRh0dHSosLJQkFRYW6oMPPpDP5wvWHD9+XE6nU5mZmeOYCgAAAABcmqXb3qqrq3Xo0CH96Ec/0owZM4LP6CQlJemaa65RUlKSlixZorq6OqWkpMjpdKqmpkYulysYftxutzIzM7V+/XqtW7dOXq9X9fX1Ki8vt7TSGwAAAABYYSn8/PSnP5Ukfe973wvZvmXLFi1evFiStHHjRsXExKiiokKDg4Nyu92qrKwM1jocDu3YsUNVVVVaunSpEhISVFZWpoqKivHOBQAAAAAuyVL4aW9vv2JNfHy8KisrQwLPxebMmaOdO3daOTUAAAAAjMuYFjwAAAAAgKmG8AMAAADACIQfAAAAAEYg/AAAAAAwAuEHAAAAgBEIPwAAAACMQPgBAAAAYATCDwAAAAAjEH4AAAAAGIHwM0nSnfHyjwTCqg23DgAAAED4pkd7AKZITpguR8w0rW5olqez55J1mbOc2vaAaxJHBgAAAJiB8DPJPJ09OtXRHe1hAAAAAMbhtjcAAAAARiD8AAAAADAC4QcAAACAEQg/AAAAAIxA+AEAAABgBMIPAAAAACMQfgAAAAAYgfADAAAAwAiEHwAAAABGIPwAAAAAMALhBwAAAIARCD8AAAAAjED4AQAAAGAEwg8AAAAAIxB+AAAAABiB8AMAAADACIQfAAAAAEYg/AAAAAAwAuEHAAAAgBEIPwAAAACMQPgBAAAAYATCDwAAAAAjEH4AAAAAGIHwAwAAAMAIhJ+rTLozXv6RQNj1VmoBAAAAk02P9gAQKjlhuhwx07S6oVmezp7L1mbOcmrbA65JGhkAAAAwtRF+rlKezh6d6uiO9jAAAAAA2+C2NwAAAABGIPwAAAAAMALhBwAAAIARCD8AAAAAjED4AQAAAGAEwg8AAAAAI1gOP++9954effRRud1uZWdn69e//nXI/kAgoG3btsntdis/P18/+MEP9OGHH4bUnD17VmvWrFFRUZFuu+02bdy4Ub29veOaCAAAAABcjuXw09fXp+zsbFVWVn7p/p07d2rv3r2qqqpSY2OjEhIStGzZMg0MDARr1q5dK4/Ho927d2vHjh367W9/q2eeeWbsswAAAACAK7AcfkpLS/X444/rb//2b7+wLxAI6LXXXtO//Mu/6O6771ZOTo7+/d//XZ2dncErRH/4wx/0X//1X6qpqVFBQYFuu+02PfXUUzp8+LD+/Oc/j39GBkl3xss/EgirNtw6AAAAwK6mR/LNPvnkE3m9XpWUlAS3JSUlqaCgQM3Nzbr33nvV3Nys5ORkLVy4MFhTUlKimJgYtba2fmmouhS/3y+/3x/JKVgSzXNLUnLCdDlipml1Q7M8nT2XrMuc5dS2B1xRH+9UNPo943tnX/TY/uix/dFje6O/9jfeHls5LqLhx+v1SpJSU1NDtqempqqrq0uS1NXVpZkzZ4YOYvp0paSkBI8PV2trqxITE8cx4vFLSEiI6vklydPZo1Md3Vesa29vV39//ySMyH7a2tqiPQRMMHpsf/TY/uixvdFf+xtrj/v6+sKujWj4mWz5+flyOp1RO7/f75fH44na+a3Kzs6O9hCmHL/fr7a2Ni1cuFAOhyPaw8EEoMf2R4/tjx7bG/21v/H2uKfn0ndAXSyi4Sc9PV2S5PP5NGvWrOB2n8+nnJwcSVJaWpo+++yzkOOGh4d17ty54PHhcjgc/BBYwPdq7Pi7Zn/02P7osf3RY3ujv/Y31h5bOSain/Mzd+5cpaenq6mpKbitp6dHv/vd7+RyuSRJLpdL3d3dOnnyZLDm3Xff1cjIiPLz8yM5HAAAAAAIsnzlp7e3Vx999FHw9SeffKL3339fKSkpysjI0EMPPaSXX35ZN954o+bOnatt27Zp1qxZuvvuuyVJ8+fP19e+9jU9/fTTqq6u1tDQkDZv3qx7771X119/feRmBgAAAACfYzn8nDx5Ug899FDw9ZYtWyRJZWVlqqur0yOPPKL+/n4988wz6u7u1q233qpXX31V8fHxwWOef/55bd68Wd///vcVExOje+65R0899VQEpgMAAAAAX85y+Fm0aJHa29svuX/atGlavXq1Vq9efcmaa6+9Vi+88ILVUwMAAADAmEX0mR8AAAAAuFoRfgAAAAAYgfADAAAAwAiEHwAAAABGIPwghH8kENE6AAAA4GphebU32JsjZppWNzTL09lzyZrMWU5te8A1iaMCAAAAxo/wgy/wdPboVEd3tIcBAAAARBS3vQEAAAAwAuEHAAAAgBEIPwZId8azQAEAAACMxzM/BkhOmB7WQgZ/nZ2udd/MmcSRAQAAAJOH8GOQKy1kMD99xiSOBgAAAJhc3PYGAAAAwAiEHwAAAABGIPwAAAAAMALhBwAAAIARCD8AAAAAjED4gWVWPjco0nUAAADAWLHUNSyz+rlBV6rLnOXUtgdcEzFUAAAAIIjwgzEL93ODrlQHAAAATAZuewMAAABgBMIPAAAAACMQfgAAAAAYgfADAAAAwAiEH0TdRCydDQAAAFyM1d4QdeEunc2S2AAAABgPwg+uGiyJDQAAgInEbW+wJW6jAwAAwMW48oMpY/TZIEfMtCvWchsdAAAALkb4wZQR7rNBf52drnXfzOE2OgAAAIQg/GDKuVKomZ8+YxJHAwAAgKmCZ34AAAAAGIHwAwAAAMAIhB/gKsaqdQAAAJHDMz/AFSQkJETt3KxaBwAAEDmEHxgrnKWzHQ6HcnNzLV2BCWcp7nDrJD78FQAAIFIIPzCW1aWzI3kFxsp57WIigiEAAIAVhB8YL9yls69UZ+VDWK2c1y64hQ8AAEQb4QeIEKtXkkzELXwAACCaCD9AhJl2RQcAAGCqYKlrwCBX+9LZo7cOhoPlvQEAgFVc+QGmOCvPGoVzW97tN12np++7JezzR3KBgnBvHeTZIAAAMBaEH2CKs/qsUTi35YXzfp9/z0g/58SzQYi0aH5eFwDg6kH4AWwi0s8ahRNAwl0J72p/zikpKUmaFt5dwJFespulvccv0p/XBQCwL8IPAFsL5xfjrKwsSZr0z3KK5u17dgpnV/v3GgBw9SD8AJhyIv2cU7i3BFoVyc+GinSd3QIDt0oCAMIR1fCzb98+7dq1S16vVzk5OXr66aeVn58fzSEBmAIm4jmncFj9INsrCXceVhahiGbYC4eV799UuOoEAJhaohZ+fvGLX2jLli2qrq5WQUGB9uzZo2XLlumXv/ylUlNTozUsAFPIZD9rNFEfZBupRSiiGfYiecVJmlpXnQAAU0fUws/u3bv13e9+V0uWLJEkVVdX65133tGBAwe0fPnyyx4bCFx4aPXcuXPy+/0TPtZL8fv96uvrU09Pj25KjtHIYOwla69PUETrJuI9qaPOSt1UGONE1Q3/vz6NDPZfsm6wf2L+uzDZ57155nT19/Vqxzt/UMe5S5/35llO/dOiG8O+SnOleUiSMyZe57rPh/2eV5pL4ezw3y9atyL6RwJSYOSKdZoWE9n3izQL44vUPEZGRjQyMqLu7m7FxEThIwyv9p5E2iTPd2RkRA6HQz29vXKE0V/bfJ8NMvo79blz5+RwOCwf39Nz4R/URjPC5UwLhFMVYYODgyosLNT27dt19913B7dv2LBB3d3devnlly97/KeffqrS0tKJHiYAAACAKeLo0aOaPXv2ZWuicuXnL3/5i/x+/xdub0tNTdWZM2euePysWbN09OhRzZgxQ9OmcT84AAAAYKpAIKDe3l7NmjXrirVTcrW3mJiYK6Y6AAAAAGZISkoKqy4KN8ZK1113nRwOh3w+X8h2n8+ntLS0aAwJAAAAgM1FJfzExcXplltuUVNTU3DbyMiImpqa5HKxug8AAACAyIvabW8PP/ywNmzYoLy8POXn52vPnj3q7+/X4sWLozUkAAAAADYWtfDzne98R5999pm2b98ur9erBQsW6NVXX+W2NwAAAAATIipLXQMAAADAZIvKMz8AAAAAMNkIPwAAAACMQPgBAAAAYATCDwAAAAAjEH7GYd++ffrGN76hhQsX6h//8R/V2toa7SEhDO+9954effRRud1uZWdn69e//nXI/kAgoG3btsntdis/P18/+MEP9OGHH4bUnD17VmvWrFFRUZFuu+02bdy4Ub29vZM4C1zOK6+8oiVLlsjlcqm4uFg//OEPdebMmZCagYEBVVdXa9GiRXK5XFq1apW6urpCajo6OrR8+XIVFBSouLhYW7du1fDw8GROBZewf/9+3X///SoqKlJRUZGWLl2qo0ePBvfTX3v58Y9/rOzsbD377LPBbfR4anvxxReVnZ0d8vWtb30ruJ/+2sOf//xnrV27VosWLVJ+fr7uv/9+tbW1BfdH43cuws8Y/eIXv9CWLVv02GOP6eDBg8rJydGyZcvk8/miPTRcQV9fn7Kzs1VZWfml+3fu3Km9e/eqqqpKjY2NSkhI0LJlyzQwMBCsWbt2rTwej3bv3q0dO3bot7/9rZ555pnJmgKu4MSJEyovL1djY6N2796t4eFhLVu2TH19fcGa2tpaHTlyRPX19dq7d686Ozu1cuXK4H6/368VK1ZoaGhIDQ0Nqqur08GDB7V9+/ZoTAkXmT17ttauXauf//znOnDggO644w499thjOn36tCT6ayetra1qaGhQdnZ2yHZ6PPXdfPPNOnbsWPBr//79wX30d+o7d+6cHnzwQcXGxmrnzp06fPiwNmzYoJSUlGBNVH7nCmBM/uEf/iFQXV0dfO33+wNutzvwyiuvRHFUsCorKyvw9ttvB1+PjIwE7rzzzsCrr74a3Nbd3R3Iy8sLHDp0KBAIBAIejyeQlZUVaG1tDdYcPXo0kJ2dHfj0008nb/AIm8/nC2RlZQVOnDgRCAQu9PSWW24JvPXWW8Ga0b42NzcHAoFA4J133gnk5OQEvF5vsGb//v2BoqKiwMDAwKSOH+G5/fbbA42NjfTXRnp6egL33HNP4L//+78D//zP/xyoqakJBAL8DNvB9u3bA3/3d3/3pfvorz0899xzgQcffPCS+6P1OxdXfsZgcHBQp06dUklJSXBbTEyMSkpK1NzcHMWRYbw++eQTeb3ekN4mJSWpoKAg2Nvm5mYlJydr4cKFwZqSkhLFxMRw6+NV6vz585IU/NemkydPamhoKKTP8+fPV0ZGhlpaWiRJLS0tysrKCvngZbfbrZ6eHnk8nskbPK7I7/fr8OHD6uvrk8vlor82smnTJpWWlob0UuJn2C7++Mc/yu1262/+5m+0Zs0adXR0SKK/dvGb3/xGeXl5qqioUHFxsf7+7/9ejY2Nwf3R+p1r+hjnY7S//OUv8vv9Sk1NDdmempr6hecKMLV4vV5J+tLejt5r3NXVpZkzZ4bsnz59ulJSUoLH4+oxMjKi2tpaFRUVKSsrS9KFHsbGxio5OTmkNjU1NdjDrq6ukP+pSgq+ps9Xh/b2dj3wwAMaGBhQYmKiXnrpJWVmZur999+nvzZw+PBh/f73v9fPfvazL+zjZ3jqy8/P15YtWzRv3jx5vV699NJLKi8v15tvvkl/beLjjz/WT3/6Uz388MN69NFH1dbWppqaGsXGxqqsrCxqv3MRfgDYWnV1tU6fPh1yLznsYd68eXrjjTd0/vx5/epXv9KGDRv0+uuvR3tYiIA//elPevbZZ/WTn/xE8fHx0R4OJkBpaWnwzzk5OSooKNBdd92lt956S9dcc00UR4ZICQQCysvL0xNPPCFJys3N1enTp9XQ0KCysrKojYvb3sbguuuuk8Ph+MLiBj6f7wv/CoGpJT09XZIu29u0tDR99tlnIfuHh4d17ty54PG4OmzatEnvvPOO9uzZo9mzZwe3p6WlaWhoSN3d3SH1Pp8v2MO0tLQvrCw0+po+Xx3i4uJ04403Ki8vT2vWrFFOTo5ee+01+msDp06dks/n0+LFi5Wbm6vc3FydOHFCe/fuVW5uLj22oeTkZN1000366KOP6K9NpKena/78+SHbvvrVrwZvb4zW71yEnzGIi4vTLbfcoqampuC2kZERNTU1yeVyRXFkGK+5c+cqPT09pLc9PT363e9+F+yty+VSd3e3Tp48Gax59913NTIyovz8/EkfM74oEAho06ZNevvtt7Vnzx595StfCdmfl5en2NjYkD6fOXNGHR0dKiwslCQVFhbqgw8+CPmP8vHjx+V0OpWZmTkp84A1IyMjGhwcpL82cMcdd+jNN9/UG2+8EfzKy8vT/fffH/wzPbaX3t5effzxx0pPT6e/NlFUVKT//d//Ddn24Ycfas6cOZKi9zsXt72N0cMPP6wNGzYoLy9P+fn52rNnj/r7+7V48eJoDw1X0Nvbq48++ij4+pNPPtH777+vlJQUZWRk6KGHHtLLL7+sG2+8UXPnztW2bds0a9Ys3X333ZIuPHT5ta99TU8//bSqq6s1NDSkzZs3695779X1118frWnhc6qrq3Xo0CH96Ec/0owZM4L3BSclJemaa65RUlKSlixZorq6OqWkpMjpdKqmpkYulyv4P1a3263MzEytX79e69atk9frVX19vcrLyxUXFxfF2UGSXnjhBX3961/XDTfcoN7eXh06dEgnTpzQrl276K8NOJ3O4DN6oxITE3XttdcGt9PjqW3r1q266667lJGRoc7OTr344ouKiYnRfffdx8+wTXz/+9/Xgw8+qB07dujb3/62Wltb1djYqE2bNkmSpk2bFpXfuaYFAoFAxGZpmNdff127du2S1+vVggUL9NRTT6mgoCDaw8IV/M///I8eeuihL2wvKytTXV2dAoGAtm/frsbGRnV3d+vWW29VZWWl5s2bF6w9e/asNm/erN/85jeKiYnRPffco6eeekozZsyYzKngEi7+PJBRW7ZsCf4DxcDAgOrq6nT48GENDg7K7XarsrIy5DL6//3f/6mqqkonTpxQQkKCysrKtGbNGk2fzr8bRdvGjRv17rvvqrOzU0lJScrOztYjjzyiO++8UxL9taPvfe97ysnJ0b/9279JosdT3eOPP6733ntPZ8+e1cyZM3Xrrbfq8ccf11/91V9Jor92ceTIEf3Hf/yHPvzwQ82dO1cPP/ywvvvd7wb3R+N3LsIPAAAAACPwzA8AAAAAIxB+AAAAABiB8AMAAADACIQfAAAAAEYg/AAAAAAwAuEHAAAAgBEIPwAAAACMQPgBAAAAYATCDwAAAAAjEH4AAAAAGIHwAwAAAMAI/x+k0HIb89fnlgAAAABJRU5ErkJggg==\n" }, "metadata": {} } ] }, { "cell_type": "code", "source": [ "plt.figure(figsize =(10, 4))\n", "\n", "ratings['rating'].hist(bins = 70)" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 385 }, "id": "RYJeA4Y93MmF", "outputId": "bcd521ec-3ff9-4c84-a764-9d083999ea99" }, "execution_count": 9, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ "" ] }, "metadata": {}, "execution_count": 9 }, { "output_type": "display_data", "data": { "text/plain": [ "
" ], "image/png": "iVBORw0KGgoAAAANSUhEUgAAAz8AAAFfCAYAAABgPnIwAAAAOnRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjEwLjAsIGh0dHBzOi8vbWF0cGxvdGxpYi5vcmcvlHJYcgAAAAlwSFlzAAAPYQAAD2EBqD+naQAAKkJJREFUeJzt3X9wVPW9//FXskSasCHW/IByw6CCLEaykNAOkhtvpMUflWKLjC1er1HLyIXqNV6h0ov8MICEUnCMlQLll4I/mFStM4jakemV6dxCpS2YgDYXRKtMrPnhlbBJhLi73z/8sm2AJOck5+w5u+f5mHHGnP1sznvf+8myrz3nfDYlGo1GBQAAAABJLtXpAgAAAAAgHgg/AAAAADyB8AMAAADAEwg/AAAAADyB8AMAAADAEwg/AAAAADyB8AMAAADAEwY4XUBfRCIRNTY2atCgQUpJSXG6HAAAAAAOiUajamtrU15enlJTez62k5Dhp7GxUWVlZU6XAQAAAMAl9u7dq6FDh/Y4JiHDz6BBgyR9+QD9fr+jtYTDYdXW1ioYDMrn8zlaSzKiv/aiv/ajx/aiv/aiv/aiv/aiv/ZyU39DoZDKyspiGaEnCRl+zp7q5vf7XRF+MjIy5Pf7HX/ikxH9tRf9tR89thf9tRf9tRf9tRf9tZcb+2vkchgWPAAAAADgCYQfAAAAAJ5A+AEAAADgCYQfAAAAAJ5A+AEAAADgCYQfAAAAAJ5A+AEAAADgCYQfAAAAAJ5A+AEAAADgCYQfAAAAAJ5A+AEAAADgCYQfAEBCS0tLc7oEAECCIPwAABLalQVXyefz9TouHInGoRoAgJsNcLoAAAD6I22ATxU7D+pYY6jbMaPy/KqeWRTHqgAAbkT4AQAkvGONIR1paHW6DACAy3HaGwAAAABPIPwAAAAA8ATCDwAAAABPIPwAAAAA8ATCDwAAAABPIPwAAAAA8ATCDwAAAABPIPwAAAAA8ATCDwAAAABPMB1+Dhw4oDlz5qi0tFSBQEB79uyJ3dbZ2amf/exnmjZtmsaPH6/S0lI99NBD+uSTT7r8js8++0zz5s1TcXGxvv71r2vhwoVqa2vr/6MBAAAAgG6YDj/t7e0KBAJaunTpebd9/vnneueddzR37ly99NJLevLJJ/X+++9r7ty5XcbNnz9fx44d07Zt27Rhwwb98Y9/1JIlS/r+KAAAAACgFwPM3qGsrExlZWUXvC0zM1Pbtm3rsm3x4sW69dZb1dDQoGHDhum9997T7373O73wwgsqLCyUJC1atEizZ8/WQw89pCFDhvThYQAAAABAz0yHH7NCoZBSUlI0ePBgSdLBgwc1ePDgWPCRpJKSEqWmpqq2tlbXXXed4d8dDocVDoctr9mMs/t3uo5kRX/tRX/tR4/tFYlE5PP5DI/neTCH+Wsv+msv+msvN/XXTA22hp/Tp09rzZo1mjp1qvx+vySpublZl1xySdciBgxQVlaWmpqaTP3+2tpaZWRkWFZvf9TV1TldQlKjv/aiv/ajx/ZIT09XQUGB4fH19fXq6OiwsaLkxPy1F/21F/21lxv6297ebnisbeGns7NTFRUVikajqqystGUfwWAwFqqcEg6HVVdXp8LCQlOfPsIY+msv+ms/emyvSCRianwgELCpkuTE/LUX/bUX/bWXm/obCoUMj7Ul/HR2duqBBx5QQ0ODnn766S4BJScnR59++mmX8V988YVOnjyp3NxcU/vx+XyON/ssN9WSjOivveiv/eixO/Ac9A3z11701170115u6K+Z/Vv+PT9ng89f//pXPfXUU/rqV7/a5faioiK1trbq8OHDsW379+9XJBJRMBi0uhwAAAAAkNSHIz9tbW368MMPYz+fOHFC7777rrKyspSbm6v7779f77zzjjZu3KhwOBy7jicrK0sXXXSRRo4cqWuuuUaLFy9WZWWlOjs7tXz5ck2dOpWV3gAAAADYxnT4OXz4sMrLy2M/V1VVSZKmT5+u++67T7/97W8lSd/97ne73G/79u2aOHGiJGnNmjVavny57rzzTqWmpur666/XokWL+vwgAAAAAKA3psPPxIkTVV9f3+3tPd121sUXX6y1a9ea3TUAAAAA9Jnl1/wAAAAAgBsRfgAAAAB4AuEHAAAAgCcQfgAAAAB4AuEHAAAAgCcQfgAAAAB4AuEHAAAAgCcQfgAAAAB4AuEHAAAAgCcQfgAAAAB4AuEHAAAAgCcQfgAAAAB4AuEHAAAAgCcQfgAAAAB4AuEHAAAAgCcQfgAAAAB4AuEHAAAAgCcQfgAAAAB4AuEHAAAAgCcQfgAAAAB4AuEHAAAAgCcQfgAAAAB4AuEHAAAAgCcQfgAAAAB4AuEHAAAAgCcQfgAAAAB4AuEHAAAAgCcQfgAAAAB4AuEHAAAAgCcQfgAAAAB4AuEHAAAAgCcQfgAAAAB4AuEHAAAAgCcQfgAAAAB4AuEHAAAAgCcQfgAAAAB4gunwc+DAAc2ZM0elpaUKBALas2dPl9uj0aiqq6tVWlqqYDCou+66Sx988EGXMZ999pnmzZun4uJiff3rX9fChQvV1tbWrwcCAAAAAD0xHX7a29sVCAS0dOnSC96+adMm7dixQ4888ohqamqUnp6uWbNm6fTp07Ex8+fP17Fjx7Rt2zZt2LBBf/zjH7VkyZK+PwoAAAAA6MUAs3coKytTWVnZBW+LRqPavn275s6dqylTpkiSVq9erZKSEu3Zs0dTp07Ve++9p9/97nd64YUXVFhYKElatGiRZs+erYceekhDhgwxXEs4HFY4HDb7ECx1dv9O15Gs6K+96K/96LG9IpGIfD6f4fE8D+Ywf+1Ff+1Ff+3lpv6aqcF0+OnJiRMn1NTUpJKSkti2zMxMjRs3TgcPHtTUqVN18OBBDR48OBZ8JKmkpESpqamqra3VddddZ3h/tbW1ysjIsPIh9FldXZ3TJSQ1+msv+ms/emyP9PR0FRQUGB5fX1+vjo4OGytKTsxfe9Ffe9Ffe7mhv+3t7YbHWhp+mpqaJEnZ2dldtmdnZ6u5uVmS1NzcrEsuuaRrEQMGKCsrK3Z/o4LBoPx+fz8q7r9wOKy6ujoVFhaa+vQRxtBfe9Ff+9Fje0UiEVPjA4GATZUkJ+avveivveivvdzU31AoZHispeEn3nw+n+PNPstNtSQj+msv+ms/euwOPAd9w/y1F/21F/21lxv6a2b/li51nZubK0lqaWnpsr2lpUU5OTmSpJycHH366addbv/iiy908uTJ2P0BAAAAwGqWhp/8/Hzl5uZq3759sW2hUEhvv/22ioqKJElFRUVqbW3V4cOHY2P279+vSCSiYDBoZTkAAAAAEGP6tLe2tjZ9+OGHsZ9PnDihd999V1lZWRo2bJjKy8u1fv16jRgxQvn5+aqurlZeXl5s9beRI0fqmmuu0eLFi1VZWanOzk4tX75cU6dONbXSGwAAAACYYTr8HD58WOXl5bGfq6qqJEnTp0/XqlWrdM8996ijo0NLlixRa2urJkyYoM2bN2vgwIGx+6xZs0bLly/XnXfeqdTUVF1//fVatGiRBQ8HAAAAAC7MdPiZOHGi6uvru709JSVFFRUVqqio6HbMxRdfrLVr15rdNQAAAAD0maXX/AAAAACAWxF+AAAAAHgC4QcAAACAJxB+AAAAAHgC4QcAAACAJxB+AAAAAHgC4QcAAACAJxB+AAAAAHgC4QcAAACAJxB+AAAAAHgC4QcAAACAJxB+AAAAAHgC4QcAAACAJxB+AAAAAHgC4QcAAACAJxB+AAAAAHgC4QcAAACAJxB+AAAAAHgC4QcAAACAJxB+AAAAAHgC4QcAAACAJxB+AAAAAHgC4QcAAACAJxB+AAAAAHgC4QcAAACAJxB+AAAAAHgC4QcAAACAJxB+AAAAAHgC4QcAAACAJxB+AAAAAHgC4QcAAACAJxB+AAAAAHgC4QcAAACAJxB+AAAAAHgC4QcAAACAJ1gefsLhsB5//HF985vfVDAY1JQpU7Ru3TpFo9HYmGg0qurqapWWlioYDOquu+7SBx98YHUpAAAAABBjefjZtGmTnn/+eS1ZskSvvvqq5s+fr82bN2vHjh1dxuzYsUOPPPKIampqlJ6erlmzZun06dNWlwMAAAAAkmwIPwcPHtS3vvUtXXvttcrPz9eNN96o0tJS1dbWSvryqM/27ds1d+5cTZkyRWPGjNHq1avV2NioPXv2WF0OAAAAAEiSBlj9C4uKilRTU6P3339fl112mf7yl7/oT3/6k37yk59Ikk6cOKGmpiaVlJTE7pOZmalx48bp4MGDmjp1quF9hcNhhcNhqx+CKWf373QdyYr+2ov+2o8e2ysSicjn8xkez/NgDvPXXvTXXvTXXm7qr5kaLA8/s2fPVigU0re//W35fD6Fw2H953/+p26++WZJUlNTkyQpOzu7y/2ys7PV3Nxsal+1tbXKyMiwpvB+qqurc7qEpEZ/7UV/7UeP7ZGenq6CggLD4+vr69XR0WFjRcmJ+Wsv+msv+msvN/S3vb3d8FjLw89rr72mXbt2ae3atRo1apTeffddVVVVKS8vT9OnT7d0X8FgUH6/39LfaVY4HFZdXZ0KCwtNffoIY+ivveiv/eixvSKRiKnxgUDApkqSE/PXXvTXXvTXXm7qbygUMjzW8vCzevVqzZ49O3b6WiAQUENDgzZu3Kjp06crNzdXktTS0qK8vLzY/VpaWjRmzBhT+/L5fI43+yw31ZKM6K+96K/96LE78Bz0DfPXXvTXXvTXXm7or5n9W77gweeff66UlJTzCjq71HV+fr5yc3O1b9++2O2hUEhvv/22ioqKrC4HAAAAACTZcORn8uTJ2rBhg4YNGxY77W3btm2aMWOGJCklJUXl5eVav369RowYofz8fFVXVysvL09TpkyxuhwAAAAAkGRD+Fm0aJGqq6tVWVkZO7XtBz/4ge69997YmHvuuUcdHR1asmSJWltbNWHCBG3evFkDBw60uhwAAAAAkGRD+PH7/Xr44Yf18MMPdzsmJSVFFRUVqqiosHr3AAAAAHBBll/zAwAAAABuRPgBAAAA4AmEHwAAAACeQPgBAAAA4AmEHwAAAACeQPgBAAAA4AmEHwAAAACeQPgBAAAA4AmEHwAAAACeQPgBAAAA4AmEHwAAAACeQPgBAAAA4AmEHwAAAACeQPgBAAAA4AmEHwAAAACeQPgBAAAA4AmEHwAAAACeQPixQFpamtMlAAAAAOgF4ccCVxZcJZ/P1+u4cCQah2oAAAAAXMgApwtIBmkDfKrYeVDHGkPdjhmV51f1zKI4VgUAAADgHxF+LHKsMaQjDa1OlwEAAACgG5z2BgAAAMATCD8AAAAAPIHwAwAAAMATCD8AAAAAPIHwAwAAAMATCD8AAAAAPIHwAwAAAMATCD8AAAAOSU9Pd7oEwFMIPwAAAHEQjkS7/Ozz+VRQUCCfz9fjOADWGeB0AQAAAF7gS01Rxc6DOtYY6nbMqDy/qmcWxbEqwFsIPwAAAHFyrDGkIw2tTpcBeBanvQEA8A+MnnLEqUkAkHg48gMAwD/g1CQASF6EHwAAzsGpSQCQnGw57e2TTz7R/PnzNXHiRAWDQU2bNk11dXWx26PRqKqrq1VaWqpgMKi77rpLH3zwgR2lAAAAAIAkG8LPyZMnddtttyktLU2bNm3S7t27tWDBAmVlZcXGbNq0STt27NAjjzyimpoapaena9asWTp9+rTV5QAAAACAJBtOe9u0aZOGDh2qqqqq2Lbhw4fH/j8ajWr79u2aO3eupkyZIklavXq1SkpKtGfPHk2dOtXqkgAAAADA+vDz29/+VqWlpbr//vt14MABDRkyRP/6r/+q73//+5KkEydOqKmpSSUlJbH7ZGZmaty4cTp48KCp8BMOhxUOh61+CKZEIpHzvpysJ07Xm2jO9ou+2YP+2o8e28uO12Be0/+O+Wst5lZ8MX/t5ab+mqnB8vDz0Ucf6fnnn9fdd9+tOXPmqK6uTitWrFBaWpqmT5+upqYmSVJ2dnaX+2VnZ6u5udnUvmpra5WRkWFZ7X2Rnp6ugoICw+Pr6+vV0dFhY0XJ6R+vGYP16K/96LE9rH4N5jX9wpi//cfccg7z115u6G97e7vhsZaHn2g0qrFjx+rBBx+UJBUUFOjo0aPauXOnpk+fbum+gsGg/H6/pb/TrEgkYmp8IBCwqZLkFA6HVVdXp8LCQlOfmMEY+ms/emwvp1+Dk/01PRKJ6OjRo7riiiuUmspXA8ZTss+teOD1115u6m8o1P1XE5zL8vCTm5urkSNHdtl2+eWX6ze/+U3sdklqaWlRXl5ebExLS4vGjBljal8+n8/xZpuVaPW6RSI+14mE/tqPHruD1c9BMjyn4UhUvtSUC97m8/liRyt6GgfrJcPccgtef+3lhv6a2b/l4ae4uFjvv/9+l20ffPCB/umf/kmSlJ+fr9zcXO3bt09XXnmlpC/T2ttvv63bbrvN6nIAAEAP+FJXAF5iefi58847ddttt2nDhg369re/rdraWtXU1GjZsmWSpJSUFJWXl2v9+vUaMWKE8vPzVV1drby8vNjqbwAAIH74UlcAXmF5+AkGg3ryySf12GOPad26dcrPz9fChQt18803x8bcc8896ujo0JIlS9Ta2qoJEyZo8+bNGjhwoNXlAAAAAIAkG8KPJE2ePFmTJ0/u9vaUlBRVVFSooqLCjt0DAAAAwHlYugUAABcIR6KWjgMAnM+WIz8AAMAcFh4AAPsRfgAAcAkWHgAAe3HaGwAAAABPIPwAAAAA8ATCDwAAAABPIPwAAAAA8ATCDwAAAABPIPwAAAAA8ATCDwAASYgvQwWA8/E9P4DHpaenO10CABsY+dLUawO5+vENY+JYFQA4i/ADeEg4EpUvNSX2s8/nU0FBQa/jACSm3r40dWTuoDhW05XR1xlejwBYifADeIiRT4JH5flVPbMojlUB8CJejwA4gfADeExvnwQDQLzwegQg3ljwAAAAAIAnEH4AAAAAeALhBwAAAIAnEH4AAAAAeALhBwAAWIYvVwXgZqz2BgAALMOXqwJwM8IPAACwlJu/XBWAt3HaGwAAAABPIPwAAAAA8ATCDwAAAABPIPwAAAAA8ATCDwAAJuX6Bxpe0pmln92H5w7wLlZ7AwCbpaenO10CLDY4fYChJZ1H5flVPbMojpXBCJ47wLsIPwBgg3AkKl9qinw+nwoKCnodF29G9+tUfYmityWdzx4hoof2M9vn3p47AMmJ8AMANnD7J8tury9ZGD1CxJd+9p+RPkv0GvA6wg8A2MTtnyy7vb5kwpd+xoeROU2vAW9jwQMAAAAAnkD4AQAAAOAJhB8ASCIszQsAQPe45gcAkggX1wMA0D3CDwAkGS6uh9VYshtAsrA9/Pzyl7/U2rVrVV5erocffliSdPr0aa1atUqvvvqqzpw5o9LSUi1dulQ5OTl2lwMAAExiyW4AycLW8FNbW6udO3cqEAh02b5y5Urt3btXjz/+uDIzM7V8+XLdd9992rlzp53lAACAfuCoIoBEZ9uCB21tbfrxj3+sFStWKCsrK7b91KlTevHFF/WTn/xEkyZN0tixY7Vy5UodPHhQhw4dsqscAAAAAB5n25GfZcuWqaysTCUlJVq/fn1s++HDh9XZ2amSkpLYtpEjR2rYsGE6dOiQxo8fb3gf4XBY4XDYyrJNi0Qi8vl8hsc7XW+iOdsv+mYN5mr8ONVrM/s1ys1zwY7XYDt6aLVkeRxGOfl4nfr7dPPfXaLgPYS93NRfMzXYEn52796td955Ry+88MJ5tzU3NystLU2DBw/usj07O1tNTU2m9lNbW6uMjIx+1dpf6enpKigoMDy+vr5eHR0dNlaUnOrq6pwuIeExV+PHqV6b3a9Rbp4LRh9z7IL9JAkEvT0nds0Fpzj5eJ36+3Tz312i4T2EvdzQ3/b2dsNjLQ8/H3/8sR599FFt3bpVAwcOtPrXdxEMBuX3+23dR28ikYip8ede/4SehcNh1dXVqbCwMGnetCQK5mr8uL3Xbq7P6Gtwsl2w7+bnxA5OPl6n9u2159gOvIewl5v6Gwp1/7p+LsvDz5EjR9TS0qJbbrklti0cDuvAgQN69tlntWXLFnV2dqq1tbXL0Z+Wlhbl5uaa2pfP53O82WYlWr1ukYjPdaKj3/Hj9l67vT4zkuWC/WR6Toxw8vE6tW+vPcd24j2EvdzQXzP7tzz8XH311dq1a1eXbf/1X/+lyy+/XPfcc4++9rWvKS0tTfv27dMNN9wgSTp+/LgaGhpMXe8DAAAAAGZYHn78fr9Gjx7dZVtGRoYuvvji2PYZM2Zo1apVysrKkt/v14oVK1RUVET4AQAAAGAb27/k9EIWLlyo1NRU3X///V2+5BQA4B6xRQJSU3oda3QcAABOikv42bFjR5efBw4cqKVLlxJ4AMDFjC4SMCrPr+qZRXGsDACAvnHkyA8AIHH0tkgAAACJItXpAgAAAAAgHgg/AIB+OXttkBFGxwGSubkFAEZw2hsAoF+4Ngh2SbYvpwXgPMIPAMASXBsEu7j9y2lZ7RBIHIQfAACAfuDoFJA4CD8AAAD95PajUwC+xIIHACDjF+Jz8TXgDSy2ACQnjvwAgIydtsIF+4B3sNgCkJwIPwDw/3HBPoBzcTobkFw47Q0AAACAJxB+AABxYfYaCq63OB/XoQBA/3DaGwAgLoxeQyFxfVV3uA4FAPqH8AMAiCuureo/rkMBgL7htDcAAAAAnkD4AQAAAOAJhB8AAAAAnkD4AQAAAOAJhB8AAAAAnkD4AQAAAOAJhB8AAAAAnkD4AQAAAOAJhB8AAAAAnkD4AYAEEI5EnS4BgMsYfV3g9QP4uwFOFwAA6J0vNUUVOw/qWGOo2zHXBnL14xvGxLEqAE4y8rowKs+v6plFcawKcDfCDwBXCUei8qWmWDYumRxrDOlIQ2u3t4/MHRTHagC4QW+vCwC6IvwAcBU+yQQAAHYh/ABwHT7JBAAAdmDBAwAAAACeQPgBAAAA4AmEHwAAAJfI9Q9kaWrARlzzAwAA4BKD0wewtD1gI8IPAACAy7C0PWAPTnsDAAAA4AmEHwAAAACeYHn42bhxo2bMmKGioiJNmjRJP/rRj3T8+PEuY06fPq3KykpNnDhRRUVF+o//+A81NzdbXQoAAAAAxFgeft566y3dfvvtqqmp0bZt2/TFF19o1qxZam9vj41ZuXKl/vu//1uPP/64duzYocbGRt13331WlwIAAAAAMZYveLBly5YuP69atUqTJk3SkSNH9I1vfEOnTp3Siy++qDVr1mjSpEmSvgxDN910kw4dOqTx48dbXRIAuNLZJW19qSlOlwIAgCfYvtrbqVOnJElZWVmSpMOHD6uzs1MlJSWxMSNHjtSwYcNMh59wOKxwOGxpvWZFIhH5fD7D452uN9Gc7Rd9s0YizFWnarR6v0Z+H0va9q63Xpt9DQa8yov/jvIewl5u6q+ZGmwNP5FIRCtXrlRxcbFGjx4tSWpublZaWpoGDx7cZWx2draamppM/f7a2lplZGRYVm9fpKenq6CgwPD4+vp6dXR02FhRcqqrq3O6hISXCHPVqRqN7jd2pMbiN9ssadu93p5js3MG8Covv//gPYS93NDff7y8pje2hp/KykodPXpUzz33nC2/PxgMyu/32/K7jYpEIqbGBwIBmypJTuFwWHV1dSosLOTT3ThLhLka7xo5UhN/vT3HZl+DAa9KhNd0q/Eewl5u6m8o1P2/yeeyLfwsW7ZMb775pp555hkNHTo0tj0nJ0ednZ1qbW3tcvSnpaVFubm5pvbh8/kcb7ZZiVavWyTic53orO63Hde2ODUnOFITP/zdA9bw8t8S7yHs5Yb+mtm/5eEnGo1q+fLleuONN7Rjxw4NHz68y+1jx45VWlqa9u3bpxtuuEGSdPz4cTU0NLDYAZDEOGICAACcZnn4qays1CuvvKJf/OIXGjRoUOw6nszMTH3lK19RZmamZsyYoVWrVikrK0t+v18rVqxQUVER4QdIchwxAQAATrI8/Dz//POSpDvuuKPL9qqqKt1yyy2SpIULFyo1NVX333+/zpw5o9LSUi1dutTqUgAAAAAgxvLwU19f3+uYgQMHaunSpQQeAAAAAHGT6nQBAGCncCTqdAkAAMAlbP+SUwBwEgstAACAswg/AJIeCy0AAACJ094AAAAAeAThBwAAAIAnEH4AJJxc/0AWMgAAixl9XeX1F4mMa34AJJzB6QNYyAAALGbkdXVUnl/VM4viWBVgLcIPgITFQgYA0LOzR8p9qSmGxvf2ugokOsIPAABAkuJIOdAV4QcAACDJcaQc+BILHgAAAADwBMIPAAAAAE8g/AAAXMfocuY+ny8O1QAAkgXX/MD10tPTnS4BQJxxkTYAwA6EH7hCd8tw+nw+FRQU9DoOQHLiIm3AXcwsnc2/2XAjwg9cgS9WAwDA/YweleXfbG9IS0tzugTTCD9wDb5YDQCAxMC/2cnNyFE7n8+nKwuuilNF1iH8AAAAAIgxc3QvHA7HsbL+I/wADuB8aQAA4GbJenSP8AM4gPOlAQAA4o/wAzgkWT9RAQAAcCu+5BQAAACAJxB+AAAAAHgC4QeeFo5ELR1npbNfJGeEE/W5Yd8AAABmcM0PPM3NCw8kyhfJGanx2kCufnzDmDhWBQAAcD7CDzzP7QsP9Fbf2SNETi6J3VuNI3MHxbEaAACACyP8AAnO6BEijr4AAACvI/wASYKjLwAAdJWenu50CXAZFjwAAACApexYtMfsOJ/Pp4KCAvl8vn79PiQXjvwAAADAUnYs2mPmFG+3LxYE5xB+0IXRC+edvsC+N1bWZ2ZBAbf3BQCAeLJ6USGjp3i7fTEjOIfwgy4SYWllI6xcACBRlpwGAABAzwg/OE+yfFpi9QIAibDktBWS5XEAAACci/ADWCRZlpw2+jgk9z8WAACAf0T4ASyWLEtOGzkCmCiPBQAAQGKpa89gOUcAAOA2ZpbEBqzg6JGfZ599Vlu2bFFTU5PGjBmjxYsXKxgMOllS0kqG07EAAEBySZZTxpE4HAs/r776qqqqqlRZWalx48bp6aef1qxZs/T6668rOzvbqbJcwczF5mbGOnE6FhfOAwCA3rj5lHG+7iK5OBZ+tm3bpu9///uaMWOGJKmyslJvvvmmXnzxRc2ePbvH+0ajXx4ePXnypMLhsO219iQSiSgtLU2XDk5V5Exat+MuHZyqUChkqF6fz6cNb76nhpMdPY4blpWuOdeONPw7e6txSLoUCoXi/lgK87N064Thlu/XqsfLuO65vUbGJea4RKiRcYk5LhFqZFx8xln9XsbMe7JEYOR91NkednZ2KjXV2StpQqEvjxqezQg9SYkaGWWxM2fOaPz48XriiSc0ZcqU2PYFCxaotbVV69ev7/H+f/vb31RWVmZ3mQAAAAASxN69ezV06NAexzhy5Of//u//FA6Hzzu9LTs7W8ePH+/1/nl5edq7d68GDRqklBQOLwIAAABeFY1G1dbWpry8vF7HJuRS16mpqb2mOgAAAADekJmZaWicIyfoffWrX5XP51NLS0uX7S0tLcrJyXGiJAAAAABJzpHwc9FFF+mqq67Svn37YtsikYj27dunoqIiJ0oCAAAAkOQcO+3t7rvv1oIFCzR27FgFg0E9/fTT6ujo0C233OJUSQAAAACSmGPh56abbtKnn36qJ554Qk1NTbryyiu1efNmTnsDAAAAYAtHlroGAAAAgHhz9huJAAAAACBOCD8AAAAAPIHwAwAAAMATCD8AAAAAPIHw04sDBw5ozpw5Ki0tVSAQ0J49e3q9zx/+8AdNnz5dY8eO1XXXXaeXXnopDpUmJrP9/cMf/qBAIHDef01NTXGqOLFs3LhRM2bMUFFRkSZNmqQf/ehHOn78eK/3e+2113TjjTeqsLBQ06ZN0969e+NQbeLpS39feuml8+ZvYWFhnCpOLM8995ymTZum4uJiFRcX6wc/+EGvc5G5a5zZ/jJ3++6Xv/ylAoGAHn300R7HMX/7zkiPmcPG/fznPz+vVzfeeGOP90mU+evYUteJor29XYFAQDNmzNB9993X6/iPPvpI//7v/66ZM2dqzZo12rdvnxYtWqTc3Fxdc801cag4sZjt71mvv/66/H5/7Ofs7Gw7ykt4b731lm6//XYVFhYqHA7rscce06xZs7R7925lZGRc8D5//vOfNW/ePD344IOaPHmydu3apXvvvVcvvfSSRo8eHedH4G596a8k+f1+vf7667GfU1JS4lFuwhk6dKjmz5+vESNGKBqN6uWXX9a9996rX//617riiivOG8/cNcdsfyXmbl/U1tZq586dCgQCPY5j/vad0R5LzGEzrrjiCm3bti32s8/n63ZsQs3fKAwbPXp09I033uhxzOrVq6NTp07tsu2BBx6I/vCHP7SztKRgpL/79++Pjh49Onry5Mk4VZVcWlpaoqNHj46+9dZb3Y6pqKiIzp49u8u2W2+9Nbp48WK7y0t4Rvr74osvRidMmBDHqpLLN77xjWhNTc0Fb2Pu9l9P/WXumhcKhaLXX3999H/+53+i//Zv/xZdsWJFt2OZv31jpsfMYeOeeOKJ6M0332x4fCLNX057s9ihQ4c0adKkLttKS0t16NAhZwpKUt/73vdUWlqqu+++W3/605+cLidhnDp1SpKUlZXV7RjmcN8Z6a/05RHPyZMnq6ysTHPnztXRo0fjUV5CC4fD2r17t9rb21VUVHTBMczdvjPSX4m5a9ayZctUVlamkpKSXscyf/vGTI8l5rAZf/3rX1VaWqpvfetbmjdvnhoaGrodm0jzl9PeLNbc3KycnJwu23JychQKhfT555/rK1/5ikOVJYfc3FxVVlZq7NixOnPmjH71q1+pvLxcNTU1uuqqq5wuz9UikYhWrlyp4uLiHg9BX2gOZ2dnq7m52e4SE5rR/l522WVauXKlAoGATp06pa1bt2rmzJnavXu3hg4dGseKE0N9fb1mzpyp06dPKyMjQ+vWrdOoUaMuOJa5a56Z/jJ3zdm9e7feeecdvfDCC4bGM3/NM9tj5rBxwWBQVVVVuuyyy9TU1KR169bp9ttv165du7pcdnBWIs1fwg8SyuWXX67LL7889nNxcbE++ugjPfXUU/rZz37mYGXuV1lZqaNHj+q5555zupSkZLS/RUVFXT5ZLyoq0k033aSdO3fqgQcesLnKxHPZZZfp5Zdf1qlTp/Sb3/xGCxYs0DPPPNPtG3SYY6a/zF3jPv74Yz366KPaunWrBg4c6HQ5SakvPWYOG1dWVhb7/zFjxmjcuHGaPHmyXnvtNd16660OVtZ/hB+L5eTknJdym5ub5ff7Oepjk8LCQv35z392ugxXW7Zsmd58800988wzvX66daE53NLSct4nOvg7M/09V1pamq688kp9+OGHNlWX2C666CKNGDFCkjR27FjV1dVp+/btWrZs2XljmbvmmenvuZi73Tty5IhaWlp0yy23xLaFw2EdOHBAzz77rOrq6s67eJz5a05fenwu5rBxgwcP1qWXXtptrxJp/nLNj8XGjx+v/fv3d9n2+9//XuPHj3emIA/4y1/+otzcXKfLcKVoNKply5bpjTfe0NNPP63hw4f3eh/msHF96e+5wuGw/vd//5c5bFAkEtGZM2cueBtzt/966u+5mLvdu/rqq7Vr1y69/PLLsf/Gjh2radOm6eWXX77gm3Lmrzl96fG5mMPGtbW16aOPPuq2V4k0fzny04u2trYuKffEiRN69913lZWVpWHDhmnt2rX65JNPtHr1aknSzJkz9eyzz2r16tWaMWOG9u/fr9dee00bN2506iG4mtn+PvXUU8rPz9cVV1yh06dP61e/+pX279+vrVu3OvUQXK2yslKvvPKKfvGLX2jQoEGx70PKzMyMHYl86KGHNGTIEM2bN0+SVF5erjvuuENbt25VWVmZXn31VR0+fNjQJ8Fe05f+Pvnkkxo/frxGjBih1tZWbdmyRQ0NDQl/GoEd1q5dq3/5l3/R1772NbW1temVV17RW2+9pS1btkhi7vaX2f4yd43z+/3nXfuXkZGhiy++OLad+ds/fekxc9i4n/70p5o8ebKGDRumxsZG/fznP1dqaqq+853vSErs+Uv46cXhw4dVXl4e+7mqqkqSNH36dK1atUpNTU36+OOPY7cPHz5cGzduVFVVlbZv366hQ4dqxYoVfMdPN8z2t7OzUz/96U/1ySefKD09XaNHj9a2bdt09dVXx732RPD8889Lku64444u26uqqmKnCnz88cdKTf37QeDi4mKtWbNGjz/+uB577DFdeumlWrdunfvW6XeBvvS3tbVVixcvVlNTk7KysnTVVVdp586dXMNyAS0tLVqwYIEaGxuVmZmpQCCgLVu26J//+Z8lMXf7y2x/mbvWYv7ajzncd3/729/04IMP6rPPPtMll1yiCRMmqKamRpdccomkxJ6/KdFoNOp0EQAAAABgN675AQAAAOAJhB8AAAAAnkD4AQAAAOAJhB8AAAAAnkD4AQAAAOAJhB8AAAAAnkD4AQAAAOAJhB8AAAAAnkD4AQAAAOAJhB8AAAAAnkD4AQAAAOAJ/w/QFJ814RAdfQAAAABJRU5ErkJggg==\n" }, "metadata": {} } ] }, { "cell_type": "code", "source": [ "moviemat = data.pivot_table(index ='user_id',\n", " columns ='title', values ='rating')\n", "\n", "moviemat.head()\n", "\n", "ratings.sort_values('num of ratings', ascending = False).head(10)" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 394 }, "id": "ZnTocXz03P37", "outputId": "15b33728-9ebe-434f-e0e0-96e5d4869f53" }, "execution_count": 10, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " rating num of ratings\n", "title \n", "Star Wars (1977) 4.359589 584\n", "Contact (1997) 3.803536 509\n", "Fargo (1996) 4.155512 508\n", "Return of the Jedi (1983) 4.007890 507\n", "Liar Liar (1997) 3.156701 485\n", "English Patient, The (1996) 3.656965 481\n", "Scream (1996) 3.441423 478\n", "Toy Story (1995) 3.878319 452\n", "Air Force One (1997) 3.631090 431\n", "Independence Day (ID4) (1996) 3.438228 429" ], "text/html": [ "\n", "
\n", "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
ratingnum of ratings
title
Star Wars (1977)4.359589584
Contact (1997)3.803536509
Fargo (1996)4.155512508
Return of the Jedi (1983)4.007890507
Liar Liar (1997)3.156701485
English Patient, The (1996)3.656965481
Scream (1996)3.441423478
Toy Story (1995)3.878319452
Air Force One (1997)3.631090431
Independence Day (ID4) (1996)3.438228429
\n", "
\n", "
\n", "\n", "
\n", " \n", "\n", " \n", "\n", " \n", "
\n", "\n", "\n", "
\n", " \n", "\n", "\n", "\n", " \n", "
\n", "\n", "
\n", "
\n" ], "application/vnd.google.colaboratory.intrinsic+json": { "type": "dataframe", "summary": "{\n \"name\": \"ratings\",\n \"rows\": 10,\n \"fields\": [\n {\n \"column\": \"title\",\n \"properties\": {\n \"dtype\": \"string\",\n \"num_unique_values\": 10,\n \"samples\": [\n \"Air Force One (1997)\",\n \"Contact (1997)\",\n \"English Patient, The (1996)\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"rating\",\n \"properties\": {\n \"dtype\": \"number\",\n \"std\": 0.3634727729966799,\n \"min\": 3.156701030927835,\n \"max\": 4.359589041095891,\n \"num_unique_values\": 10,\n \"samples\": [\n 3.6310904872389793,\n 3.8035363457760316,\n 3.656964656964657\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"num of ratings\",\n \"properties\": {\n \"dtype\": \"number\",\n \"std\": 45,\n \"min\": 429,\n \"max\": 584,\n \"num_unique_values\": 10,\n \"samples\": [\n 431,\n 509,\n 481\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n }\n ]\n}" } }, "metadata": {}, "execution_count": 10 } ] }, { "cell_type": "code", "source": [ "starwars_user_ratings = moviemat['Star Wars (1977)']\n", "liarliar_user_ratings = moviemat['Liar Liar (1997)']\n", "\n", "starwars_user_ratings.head()" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 272 }, "id": "l_4Nw6503SqG", "outputId": "cf11fc39-f4f9-4400-ac44-826bdd4c3792" }, "execution_count": 11, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ "user_id\n", "0 5.0\n", "1 5.0\n", "2 5.0\n", "3 NaN\n", "4 5.0\n", "Name: Star Wars (1977), dtype: float64" ], "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Star Wars (1977)
user_id
05.0
15.0
25.0
3NaN
45.0
\n", "

" ] }, "metadata": {}, "execution_count": 11 } ] }, { "cell_type": "code", "source": [ "similar_to_starwars = moviemat.corrwith(starwars_user_ratings)\n", "similar_to_liarliar = moviemat.corrwith(liarliar_user_ratings)\n", "\n", "corr_starwars = pd.DataFrame(similar_to_starwars, columns =['Correlation'])\n", "corr_starwars.dropna(inplace = True)\n", "\n", "corr_starwars.head()" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 411 }, "id": "WyTduzi63VJp", "outputId": "cbab7b89-73c3-4db8-8610-a4426c28f4c6" }, "execution_count": 12, "outputs": [ { "output_type": "stream", "name": "stderr", "text": [ "/usr/local/lib/python3.11/dist-packages/numpy/lib/_function_base_impl.py:2922: RuntimeWarning: invalid value encountered in divide\n", " c /= stddev[:, None]\n", "/usr/local/lib/python3.11/dist-packages/numpy/lib/_function_base_impl.py:2923: RuntimeWarning: invalid value encountered in divide\n", " c /= stddev[None, :]\n", "/usr/local/lib/python3.11/dist-packages/numpy/lib/_function_base_impl.py:2914: RuntimeWarning: Degrees of freedom <= 0 for slice\n", " c = cov(x, y, rowvar, dtype=dtype)\n", "/usr/local/lib/python3.11/dist-packages/numpy/lib/_function_base_impl.py:2773: RuntimeWarning: divide by zero encountered in divide\n", " c *= np.true_divide(1, fact)\n", "/usr/local/lib/python3.11/dist-packages/numpy/lib/_function_base_impl.py:2773: RuntimeWarning: invalid value encountered in multiply\n", " c *= np.true_divide(1, fact)\n" ] }, { "output_type": "execute_result", "data": { "text/plain": [ " Correlation\n", "title \n", "'Til There Was You (1997) 0.872872\n", "1-900 (1994) -0.645497\n", "101 Dalmatians (1996) 0.211132\n", "12 Angry Men (1957) 0.184289\n", "187 (1997) 0.027398" ], "text/html": [ "\n", "
\n", "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Correlation
title
'Til There Was You (1997)0.872872
1-900 (1994)-0.645497
101 Dalmatians (1996)0.211132
12 Angry Men (1957)0.184289
187 (1997)0.027398
\n", "
\n", "
\n", "\n", "
\n", " \n", "\n", " \n", "\n", " \n", "
\n", "\n", "\n", "
\n", " \n", "\n", "\n", "\n", " \n", "
\n", "\n", "
\n", "
\n" ], "application/vnd.google.colaboratory.intrinsic+json": { "type": "dataframe", "variable_name": "corr_starwars", "summary": "{\n \"name\": \"corr_starwars\",\n \"rows\": 1410,\n \"fields\": [\n {\n \"column\": \"title\",\n \"properties\": {\n \"dtype\": \"string\",\n \"num_unique_values\": 1410,\n \"samples\": [\n \"Devil's Own, The (1997)\",\n \"Mrs. Brown (Her Majesty, Mrs. Brown) (1997)\",\n \"Twelve Monkeys (1995)\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"Correlation\",\n \"properties\": {\n \"dtype\": \"number\",\n \"std\": 0.34891626352680527,\n \"min\": -1.0,\n \"max\": 1.0,\n \"num_unique_values\": 1297,\n \"samples\": [\n -0.03935907890476189,\n 0.146131137657269,\n -0.3535533905932736\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n }\n ]\n}" } }, "metadata": {}, "execution_count": 12 } ] }, { "cell_type": "code", "source": [ "corr_starwars.sort_values('Correlation', ascending = False).head(10)\n", "corr_starwars = corr_starwars.join(ratings['num of ratings'])\n", "\n", "corr_starwars.head()\n", "\n", "corr_starwars[corr_starwars['num of ratings']>100].sort_values('Correlation', ascending = False).head()" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 237 }, "id": "NcnfMZsC3YVe", "outputId": "6ea043b7-6fb1-4ad5-8627-0b56c2499d5a" }, "execution_count": 13, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " Correlation \\\n", "title \n", "Star Wars (1977) 1.000000 \n", "Empire Strikes Back, The (1980) 0.748353 \n", "Return of the Jedi (1983) 0.672556 \n", "Raiders of the Lost Ark (1981) 0.536117 \n", "Austin Powers: International Man of Mystery (1997) 0.377433 \n", "\n", " num of ratings \n", "title \n", "Star Wars (1977) 584 \n", "Empire Strikes Back, The (1980) 368 \n", "Return of the Jedi (1983) 507 \n", "Raiders of the Lost Ark (1981) 420 \n", "Austin Powers: International Man of Mystery (1997) 130 " ], "text/html": [ "\n", "
\n", "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Correlationnum of ratings
title
Star Wars (1977)1.000000584
Empire Strikes Back, The (1980)0.748353368
Return of the Jedi (1983)0.672556507
Raiders of the Lost Ark (1981)0.536117420
Austin Powers: International Man of Mystery (1997)0.377433130
\n", "
\n", "
\n", "\n", "
\n", " \n", "\n", " \n", "\n", " \n", "
\n", "\n", "\n", "
\n", " \n", "\n", "\n", "\n", " \n", "
\n", "\n", "
\n", "
\n" ], "application/vnd.google.colaboratory.intrinsic+json": { "type": "dataframe", "summary": "{\n \"name\": \"corr_starwars[corr_starwars['num of ratings']>100]\",\n \"rows\": 5,\n \"fields\": [\n {\n \"column\": \"title\",\n \"properties\": {\n \"dtype\": \"string\",\n \"num_unique_values\": 5,\n \"samples\": [\n \"Empire Strikes Back, The (1980)\",\n \"Austin Powers: International Man of Mystery (1997)\",\n \"Return of the Jedi (1983)\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"Correlation\",\n \"properties\": {\n \"dtype\": \"number\",\n \"std\": 0.23372930794970798,\n \"min\": 0.37743279047354783,\n \"max\": 1.0,\n \"num_unique_values\": 5,\n \"samples\": [\n 0.7483526074187072,\n 0.37743279047354783,\n 0.6725558558876046\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"num of ratings\",\n \"properties\": {\n \"dtype\": \"number\",\n \"std\": 172,\n \"min\": 130,\n \"max\": 584,\n \"num_unique_values\": 5,\n \"samples\": [\n 368,\n 130,\n 507\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n }\n ]\n}" } }, "metadata": {}, "execution_count": 13 } ] }, { "cell_type": "code", "source": [ "corr_liarliar = pd.DataFrame(similar_to_liarliar, columns =['Correlation'])\n", "corr_liarliar.dropna(inplace = True)\n", "\n", "corr_liarliar = corr_liarliar.join(ratings['num of ratings'])\n", "corr_liarliar[corr_liarliar['num of ratings']>100].sort_values('Correlation', ascending = False).head()" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 237 }, "id": "CTpnfxdK3a2X", "outputId": "59a1ada9-90b0-4045-b434-539ec2d979bb" }, "execution_count": 14, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " Correlation num of ratings\n", "title \n", "Liar Liar (1997) 1.000000 485\n", "Batman Forever (1995) 0.516968 114\n", "Mask, The (1994) 0.484650 129\n", "Down Periscope (1996) 0.472681 101\n", "Con Air (1997) 0.469828 137" ], "text/html": [ "\n", "
\n", "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Correlationnum of ratings
title
Liar Liar (1997)1.000000485
Batman Forever (1995)0.516968114
Mask, The (1994)0.484650129
Down Periscope (1996)0.472681101
Con Air (1997)0.469828137
\n", "
\n", "
\n", "\n", "
\n", " \n", "\n", " \n", "\n", " \n", "
\n", "\n", "\n", "
\n", " \n", "\n", "\n", "\n", " \n", "
\n", "\n", "
\n", "
\n" ], "application/vnd.google.colaboratory.intrinsic+json": { "type": "dataframe", "summary": "{\n \"name\": \"corr_liarliar[corr_liarliar['num of ratings']>100]\",\n \"rows\": 5,\n \"fields\": [\n {\n \"column\": \"title\",\n \"properties\": {\n \"dtype\": \"string\",\n \"num_unique_values\": 5,\n \"samples\": [\n \"Batman Forever (1995)\",\n \"Con Air (1997)\",\n \"Mask, The (1994)\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"Correlation\",\n \"properties\": {\n \"dtype\": \"number\",\n \"std\": 0.23061363245609817,\n \"min\": 0.4698281816093665,\n \"max\": 1.0,\n \"num_unique_values\": 5,\n \"samples\": [\n 0.5169676561521606,\n 0.4698281816093665,\n 0.48464981659605655\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"num of ratings\",\n \"properties\": {\n \"dtype\": \"number\",\n \"std\": 163,\n \"min\": 101,\n \"max\": 485,\n \"num_unique_values\": 5,\n \"samples\": [\n 114,\n 137,\n 129\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n }\n ]\n}" } }, "metadata": {}, "execution_count": 14 } ] } ] }