rank_based_product_recommendation.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": [],
      "gpuType": "T4",
      "mount_file_id": "1Zin3TuHLmuOAkQ5OkcqRmRT8xRfoE2a4",
      "authorship_tag": "ABX9TyPOktnZK3kaoRgK5pjec7pQ",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    },
    "accelerator": "GPU",
    "gpuClass": "standard"
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/Vaibhav67979/Ecommerce-product-recommendation-system/blob/main/rank_based_product_recommendation.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "#E-commerce Product recommendation System"
      ],
      "metadata": {
        "id": "EdILuyLgml_R"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "##Importing libraries"
      ],
      "metadata": {
        "id": "m-26iTTympFi"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "import warnings\n",
        "warnings.filterwarnings('ignore')\n",
        "\n",
        "import numpy as np\n",
        "import pandas as pd\n",
        "\n",
        "import matplotlib.pyplot as plt\n",
        "import seaborn as sns\n",
        "\n",
        "from sklearn.metrics.pairwise import cosine_similarity\n",
        "\n",
        "from sklearn.metrics import mean_squared_error"
      ],
      "metadata": {
        "id": "2tSOMad1mlsK"
      },
      "execution_count": 24,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "## Importing Dataset"
      ],
      "metadata": {
        "id": "_eRqhkyAmvFJ"
      }
    },
    {
      "cell_type": "code",
      "execution_count": 25,
      "metadata": {
        "id": "mnM0NIFemhh0"
      },
      "outputs": [],
      "source": [
        "#Import the data set\n",
        "df = pd.read_csv('/content/drive/MyDrive/ratings_Electronics.csv', header=None) #There are no headers in the data file\n",
        "\n",
        "df.columns = ['user_id', 'prod_id', 'rating', 'timestamp'] #Adding column names\n",
        "\n",
        "df = df.drop('timestamp', axis=1) #Dropping timestamp\n",
        "\n",
        "df_copy = df.copy(deep=True) #Copying the data to another dataframe"
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "## EDA - Exploratory Data Analysis\n",
        "\n",
        "check for -\n",
        "- shape \n",
        "- datatype\n",
        "- missing values\n",
        "\n",
        "\n",
        "finally get the summary and check\n",
        "- rating distribution.\n",
        "- number of users and products.\n",
        "- Users with highest no of ratings."
      ],
      "metadata": {
        "id": "tbUt2ZCcm2PZ"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "### Shape"
      ],
      "metadata": {
        "id": "P31sJRBKm7Ox"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "rows, columns = df.shape\n",
        "print(\"No of rows = \", rows)\n",
        "print(\"No of columns = \", columns)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "BR0rkn1hm5Ii",
        "outputId": "1efbe11c-73e0-4c53-df41-5fca1797f14c"
      },
      "execution_count": 26,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "No of rows =  7824482\n",
            "No of columns =  3\n"
          ]
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "### Datatypes"
      ],
      "metadata": {
        "id": "BR_AWE5dm-Aw"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df.info()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "VSZphiYsnB7h",
        "outputId": "31e11117-34de-4cc3-bef0-963505be6026"
      },
      "execution_count": 27,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 7824482 entries, 0 to 7824481\n",
            "Data columns (total 3 columns):\n",
            " #   Column   Dtype  \n",
            "---  ------   -----  \n",
            " 0   user_id  object \n",
            " 1   prod_id  object \n",
            " 2   rating   float64\n",
            "dtypes: float64(1), object(2)\n",
            "memory usage: 179.1+ MB\n"
          ]
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "### Missing value analysis"
      ],
      "metadata": {
        "id": "nMpYlCbKm__h"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# Find number of missing values in each column\n",
        "df.isna().sum()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "TmDkgSH-nG-w",
        "outputId": "67275994-578b-4a59-bfc1-d5d0461e6bf5"
      },
      "execution_count": 28,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "user_id    0\n",
              "prod_id    0\n",
              "rating     0\n",
              "dtype: int64"
            ]
          },
          "metadata": {},
          "execution_count": 28
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "### Summary"
      ],
      "metadata": {
        "id": "NuapKpPOnIxg"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# Summary statistics of 'rating' variable\n",
        "df['rating'].describe()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "GykhgQNpnLB4",
        "outputId": "5511d6ee-d528-496c-fa0c-45f02627b747"
      },
      "execution_count": 29,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "count    7.824482e+06\n",
              "mean     4.012337e+00\n",
              "std      1.380910e+00\n",
              "min      1.000000e+00\n",
              "25%      3.000000e+00\n",
              "50%      5.000000e+00\n",
              "75%      5.000000e+00\n",
              "max      5.000000e+00\n",
              "Name: rating, dtype: float64"
            ]
          },
          "metadata": {},
          "execution_count": 29
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "### Rating distribution"
      ],
      "metadata": {
        "id": "qITdLlQenOL5"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "#Create the plot and provide observations\n",
        "\n",
        "plt.figure(figsize = (12,6))\n",
        "df['rating'].value_counts(1).plot(kind='bar')\n",
        "plt.show()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 399
        },
        "id": "UGyEWlm9nN0Y",
        "outputId": "d2ea0d0e-a733-478a-cc8c-ab000812be6a"
      },
      "execution_count": 30,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "<Figure size 1200x600 with 1 Axes>"
            ],
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAA9UAAAIBCAYAAABHkpySAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjcuMSwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/bCgiHAAAACXBIWXMAAA9hAAAPYQGoP6dpAAAh20lEQVR4nO3df2xdhXn44ddOiF0INtCsdpK5eJC1adbWCTHJjAp0rdtsy/ilVgq04MhrI60ZFZO3ask2xR2scgY0pF0ysjIiUCuWlAnUTaEZ1COVKozSOgstpYX+WLCB2Um01qaGOZXt7x+oztdNHHLfJL52/DzSkfC559z7WjoO5+Nz73HJyMjISAAAAAAFKy32AAAAADBViWoAAABIEtUAAACQJKoBAAAgSVQDAABAkqgGAACAJFENAAAASTOLPcDJGB4ejldeeSXOP//8KCkpKfY4AAAAnOVGRkbi1VdfjXnz5kVp6fjXo6dEVL/yyitRU1NT7DEAAACYZrq7u+M3f/M3x318SkT1+eefHxFvfDMVFRVFngYAAICzXX9/f9TU1Iz26HimRFT/6i3fFRUVohoAAIAJ82YfQXajMgAAAEgS1QAAAJAkqgEAACBJVAMAAECSqAYAAIAkUQ0AAABJohoAAACSRDUAAAAkiWoAAABIEtUAAACQJKoBAAAgSVQDAABAkqgGAACAJFENAAAASaIaAAAAkkQ1AAAAJIlqAAAASBLVAAAAkCSqAQAAIGlmsQc429Wu21XsEaadAxtXFnsEAABgmnClGgAAAJJENQAAACSJagAAAEgS1QAAAJAkqgEAACBJVAMAAECSqAYAAIAkUQ0AAABJohoAAACSRDUAAAAkiWoAAABIEtUAAACQJKoBAAAgSVQDAABAkqgGAACAJFENAAAASaIaAAAAkkQ1AAAAJIlqAAAASBLVAAAAkCSqAQAAIElUAwAAQJKoBgAAgCRRDQAAAEmiGgAAAJJENQAAACSJagAAAEgS1QAAAJAkqgEAACBJVAMAAECSqAYAAIAkUQ0AAABJohoAAACSRDUAAAAkiWoAAABIEtUAAACQJKoBAAAgSVQDAABAkqgGAACAJFENAAAASamo3rp1a9TW1kZ5eXksX7489u7dO+62DzzwQJSUlIxZysvL0wMDAADAZFFwVO/cuTNaWlqitbU19u3bF3V1dbFixYo4ePDguPtUVFTE//zP/4wuL7744ikNDQAAAJNBwVG9adOmWLNmTTQ3N8eiRYti27Ztce6558b27dvH3aekpCSqq6tHl6qqqhO+xuDgYPT3949ZAAAAYLIpKKqPHDkSnZ2d0djYePQJSkujsbExOjo6xt3vF7/4RVx88cVRU1MT1113XXz/+98/4eu0tbVFZWXl6FJTU1PImAAAADAhCorqw4cPx9DQ0DFXmquqqqKnp+e4+7zzne+M7du3x9e+9rX4yle+EsPDw3HFFVfESy+9NO7rrF+/Pvr6+kaX7u7uQsYEAACACTHzTL9AQ0NDNDQ0jH59xRVXxLve9a74p3/6p7jjjjuOu09ZWVmUlZWd6dEAAADglBR0pXrOnDkxY8aM6O3tHbO+t7c3qqurT+o5zjnnnFiyZEn8+Mc/LuSlAQAAYNIpKKpnzZoVS5cujfb29tF1w8PD0d7ePuZq9IkMDQ3F9773vZg7d25hkwIAAMAkU/Dbv1taWmL16tVRX18fy5Yti82bN8fAwEA0NzdHRERTU1PMnz8/2traIiLi9ttvj9/93d+NBQsWxM9//vO466674sUXX4xPfvKTp/c7AQAAgAlWcFSvWrUqDh06FBs2bIienp5YvHhx7N69e/TmZV1dXVFaevQC+M9+9rNYs2ZN9PT0xIUXXhhLly6Np556KhYtWnT6vgsAAAAogpKRkZGRYg/xZvr7+6OysjL6+vqioqKi2OMUpHbdrmKPMO0c2Liy2CMAAABT3Ml2aEGfqQYAAACOEtUAAACQJKoBAAAgSVQDAABAkqgGAACAJFENAAAASaIaAAAAkkQ1AAAAJIlqAAAASBLVAAAAkCSqAQAAIElUAwAAQJKoBgAAgCRRDQAAAEmiGgAAAJJENQAAACSJagAAAEgS1QAAAJAkqgEAACBJVAMAAECSqAYAAIAkUQ0AAABJohoAAACSRDUAAAAkiWoAAABIEtUAAACQJKoBAAAgSVQDAABAkqgGAACAJFENAAAASaIaAAAAkkQ1AAAAJIlqAAAASBLVAAAAkCSqAQAAIElUAwAAQJKoBgAAgCRRDQAAAEmiGgAAAJJENQAAACSJagAAAEgS1QAAAJAkqgEAACBJVAMAAECSqAYAAIAkUQ0AAABJohoAAACSRDUAAAAkiWoAAABIEtUAAACQJKoBAAAgSVQDAABAkqgGAACAJFENAAAASaIaAAAAkkQ1AAAAJIlqAAAASBLVAAAAkCSqAQAAIElUAwAAQJKoBgAAgCRRDQAAAEmiGgAAAJJENQAAACSJagAAAEgS1QAAAJAkqgEAACBJVAMAAEBSKqq3bt0atbW1UV5eHsuXL4+9e/ee1H47duyIkpKSuP766zMvCwAAAJNKwVG9c+fOaGlpidbW1ti3b1/U1dXFihUr4uDBgyfc78CBA/EXf/EXceWVV6aHBQAAgMmk4KjetGlTrFmzJpqbm2PRokWxbdu2OPfcc2P79u3j7jM0NBQf//jH42//9m/jkksuOaWBAQAAYLIoKKqPHDkSnZ2d0djYePQJSkujsbExOjo6xt3v9ttvj7e97W3xiU984qReZ3BwMPr7+8csAAAAMNkUFNWHDx+OoaGhqKqqGrO+qqoqenp6jrvPt771rbj//vvjvvvuO+nXaWtri8rKytGlpqamkDEBAABgQpzRu3+/+uqrccstt8R9990Xc+bMOen91q9fH319faNLd3f3GZwSAAAAcmYWsvGcOXNixowZ0dvbO2Z9b29vVFdXH7P9T37ykzhw4EBcc801o+uGh4ffeOGZM+P555+PSy+99Jj9ysrKoqysrJDRAAAAYMIVdKV61qxZsXTp0mhvbx9dNzw8HO3t7dHQ0HDM9gsXLozvfe97sX///tHl2muvjd/7vd+L/fv3e1s3AAAAU1pBV6ojIlpaWmL16tVRX18fy5Yti82bN8fAwEA0NzdHRERTU1PMnz8/2traory8PN797neP2f+CCy6IiDhmPQAAAEw1BUf1qlWr4tChQ7Fhw4bo6emJxYsXx+7du0dvXtbV1RWlpWf0o9oAAAAwKZSMjIyMFHuIN9Pf3x+VlZXR19cXFRUVxR6nILXrdhV7hGnnwMaVxR4BAACY4k62Q11SBgAAgCRRDQAAAEmiGgAAAJJENQAAACSJagAAAEgS1QAAAJAkqgEAACBJVAMAAECSqAYAAIAkUQ0AAABJohoAAACSRDUAAAAkiWoAAABIEtUAAACQJKoBAAAgSVQDAABAkqgGAACAJFENAAAASaIaAAAAkkQ1AAAAJIlqAAAASBLVAAAAkCSqAQAAIElUAwAAQJKoBgAAgCRRDQAAAEmiGgAAAJJENQAAACSJagAAAEgS1QAAAJAkqgEAACBJVAMAAECSqAYAAIAkUQ0AAABJohoAAACSRDUAAAAkiWoAAABIEtUAAACQJKoBAAAgSVQDAABAkqgGAACAJFENAAAASaIaAAAAkkQ1AAAAJIlqAAAASBLVAAAAkCSqAQAAIElUAwAAQJKoBgAAgCRRDQAAAEmiGgAAAJJENQAAACSJagAAAEgS1QAAAJAkqgEAACBJVAMAAECSqAYAAIAkUQ0AAABJohoAAACSRDUAAAAkiWoAAABIEtUAAACQJKoBAAAgSVQDAABAkqgGAACAJFENAAAASaIaAAAAkkQ1AAAAJKWieuvWrVFbWxvl5eWxfPny2Lt377jbPvLII1FfXx8XXHBBnHfeebF48eL48pe/nB4YAAAAJouCo3rnzp3R0tISra2tsW/fvqirq4sVK1bEwYMHj7v9RRddFH/9138dHR0d8d3vfjeam5ujubk5/uM//uOUhwcAAIBiKhkZGRkpZIfly5fH5ZdfHlu2bImIiOHh4aipqYlPf/rTsW7dupN6jssuuyxWrlwZd9xxx0lt39/fH5WVldHX1xcVFRWFjFt0tet2FXuEaefAxpXFHgEAAJjiTrZDC7pSfeTIkejs7IzGxsajT1BaGo2NjdHR0fGm+4+MjER7e3s8//zzcdVVV4273eDgYPT3949ZAAAAYLIpKKoPHz4cQ0NDUVVVNWZ9VVVV9PT0jLtfX19fzJ49O2bNmhUrV66Mf/iHf4gPfehD427f1tYWlZWVo0tNTU0hYwIAAMCEmJC7f59//vmxf//++Pa3vx2f+9znoqWlJfbs2TPu9uvXr4++vr7Rpbu7eyLGBAAAgILMLGTjOXPmxIwZM6K3t3fM+t7e3qiurh53v9LS0liwYEFERCxevDh+8IMfRFtbW7z//e8/7vZlZWVRVlZWyGgAAAAw4Qq6Uj1r1qxYunRptLe3j64bHh6O9vb2aGhoOOnnGR4ejsHBwUJeGgAAACadgq5UR0S0tLTE6tWro76+PpYtWxabN2+OgYGBaG5ujoiIpqammD9/frS1tUXEG5+Prq+vj0svvTQGBwfjscceiy9/+ctx7733nt7vBAAAACZYwVG9atWqOHToUGzYsCF6enpi8eLFsXv37tGbl3V1dUVp6dEL4AMDA7F27dp46aWX4i1veUssXLgwvvKVr8SqVatO33cBAAAARVDw36kuBn+nmkL4O9UAAMCpOiN/pxoAAAA4SlQDAABAkqgGAACAJFENAAAASaIaAAAAkkQ1AAAAJIlqAAAASBLVAAAAkCSqAQAAIElUAwAAQJKoBgAAgCRRDQAAAEmiGgAAAJJENQAAACSJagAAAEgS1QAAAJAkqgEAACBJVAMAAECSqAYAAIAkUQ0AAABJohoAAACSRDUAAAAkiWoAAABIEtUAAACQJKoBAAAgSVQDAABAkqgGAACAJFENAAAASaIaAAAAkkQ1AAAAJIlqAAAASBLVAAAAkCSqAQAAIElUAwAAQJKoBgAAgCRRDQAAAEmiGgAAAJJENQAAACSJagAAAEgS1QAAAJAkqgEAACBJVAMAAECSqAYAAIAkUQ0AAABJohoAAACSRDUAAAAkiWoAAABIEtUAAACQJKoBAAAgSVQDAABAkqgGAACAJFENAAAASaIaAAAAkkQ1AAAAJIlqAAAASBLVAAAAkCSqAQAAIElUAwAAQJKoBgAAgCRRDQAAAEmiGgAAAJJENQAAACSJagAAAEgS1QAAAJAkqgEAACBJVAMAAECSqAYAAIAkUQ0AAABJqajeunVr1NbWRnl5eSxfvjz27t077rb33XdfXHnllXHhhRfGhRdeGI2NjSfcHgAAAKaKgqN6586d0dLSEq2trbFv376oq6uLFStWxMGDB4+7/Z49e+Kmm26KJ598Mjo6OqKmpiY+/OEPx8svv3zKwwMAAEAxlYyMjIwUssPy5cvj8ssvjy1btkRExPDwcNTU1MSnP/3pWLdu3ZvuPzQ0FBdeeGFs2bIlmpqaTuo1+/v7o7KyMvr6+qKioqKQcYuudt2uYo8w7RzYuLLYIwAAAFPcyXZoQVeqjxw5Ep2dndHY2Hj0CUpLo7GxMTo6Ok7qOV577bX45S9/GRdddNG42wwODkZ/f/+YBQAAACabgqL68OHDMTQ0FFVVVWPWV1VVRU9Pz0k9x1/+5V/GvHnzxoT5r2tra4vKysrRpaamppAxAQAAYEJM6N2/N27cGDt27IhHH300ysvLx91u/fr10dfXN7p0d3dP4JQAAABwcmYWsvGcOXNixowZ0dvbO2Z9b29vVFdXn3Dfu+++OzZu3Bjf+MY34r3vfe8Jty0rK4uysrJCRgMAAIAJV9CV6lmzZsXSpUujvb19dN3w8HC0t7dHQ0PDuPvdeeedcccdd8Tu3bujvr4+Py0AAABMIgVdqY6IaGlpidWrV0d9fX0sW7YsNm/eHAMDA9Hc3BwREU1NTTF//vxoa2uLiIi///u/jw0bNsRDDz0UtbW1o5+9nj17dsyePfs0fisAAAAwsQqO6lWrVsWhQ4diw4YN0dPTE4sXL47du3eP3rysq6srSkuPXgC/995748iRI/HRj350zPO0trbGZz/72VObHgAAAIqo4L9TXQz+TjWF8HeqAQCAU3VG/k41AAAAcFTBb/8G+HXekTHxvCMDAGBycKUaAAAAkkQ1AAAAJIlqAAAASBLVAAAAkCSqAQAAIElUAwAAQJKoBgAAgCRRDQAAAEmiGgAAAJJENQAAACSJagAAAEgS1QAAAJAkqgEAACBJVAMAAECSqAYAAIAkUQ0AAABJohoAAACSRDUAAAAkiWoAAABIEtUAAACQJKoBAAAgSVQDAABAkqgGAACAJFENAAAASaIaAAAAkkQ1AAAAJIlqAAAASBLVAAAAkCSqAQAAIElUAwAAQJKoBgAAgCRRDQAAAEmiGgAAAJJENQAAACSJagAAAEgS1QAAAJAkqgEAACBJVAMAAECSqAYAAIAkUQ0AAABJohoAAACSRDUAAAAkiWoAAABIEtUAAACQJKoBAAAgSVQDAABAkqgGAACAJFENAAAASaIaAAAAkkQ1AAAAJIlqAAAASBLVAAAAkCSqAQAAIElUAwAAQJKoBgAAgCRRDQAAAEmiGgAAAJJENQAAACTNLPYAADAV1K7bVewRpp0DG1cWewQAeFOuVAMAAECSqAYAAIAkUQ0AAABJohoAAACSRDUAAAAkiWoAAABIEtUAAACQlIrqrVu3Rm1tbZSXl8fy5ctj79694277/e9/Pz7ykY9EbW1tlJSUxObNm7OzAgAAwKRScFTv3LkzWlpaorW1Nfbt2xd1dXWxYsWKOHjw4HG3f+211+KSSy6JjRs3RnV19SkPDAAAAJNFwVG9adOmWLNmTTQ3N8eiRYti27Ztce6558b27duPu/3ll18ed911V9x4441RVlZ2ygMDAADAZFFQVB85ciQ6OzujsbHx6BOUlkZjY2N0dHSctqEGBwejv79/zAIAAACTTUFRffjw4RgaGoqqqqox66uqqqKnp+e0DdXW1haVlZWjS01NzWl7bgAAADhdJuXdv9evXx99fX2jS3d3d7FHAgAAgGPMLGTjOXPmxIwZM6K3t3fM+t7e3tN6E7KysjKfvwYAAGDSK+hK9axZs2Lp0qXR3t4+um54eDja29ujoaHhtA8HAAAAk1lBV6ojIlpaWmL16tVRX18fy5Yti82bN8fAwEA0NzdHRERTU1PMnz8/2traIuKNm5s999xzo//98ssvx/79+2P27NmxYMGC0/itAAAAwMQqOKpXrVoVhw4dig0bNkRPT08sXrw4du/ePXrzsq6urigtPXoB/JVXXoklS5aMfn333XfH3XffHVdffXXs2bPn1L8DAAAAKJKCozoi4tZbb41bb731uI/9eijX1tbGyMhI5mUAAABgUpuUd/8GAACAqUBUAwAAQJKoBgAAgCRRDQAAAEmiGgAAAJJENQAAACSJagAAAEgS1QAAAJA0s9gDAAAwOdSu21XsEaadAxtXFnsE4BS5Ug0AAABJohoAAACSRDUAAAAkiWoAAABIEtUAAACQJKoBAAAgSVQDAABAkqgGAACAJFENAAAASaIaAAAAkkQ1AAAAJIlqAAAASBLVAAAAkCSqAQAAIElUAwAAQJKoBgAAgCRRDQAAAEkziz0AAADARKldt6vYI0w7BzauLPYIZ5Qr1QAAAJAkqgEAACBJVAMAAECSqAYAAIAkUQ0AAABJohoAAACSRDUAAAAkiWoAAABIEtUAAACQJKoBAAAgSVQDAABAkqgGAACAJFENAAAASaIaAAAAkkQ1AAAAJIlqAAAASBLVAAAAkCSqAQAAIElUAwAAQJKoBgAAgCRRDQAAAEmiGgAAAJJENQAAACSJagAAAEgS1QAAAJAkqgEAACBJVAMAAECSqAYAAIAkUQ0AAABJohoAAACSRDUAAAAkiWoAAABIEtUAAACQJKoBAAAgSVQDAABAkqgGAACAJFENAAAASaIaAAAAkkQ1AAAAJIlqAAAASBLVAAAAkCSqAQAAICkV1Vu3bo3a2tooLy+P5cuXx969e0+4/cMPPxwLFy6M8vLyeM973hOPPfZYalgAAACYTAqO6p07d0ZLS0u0trbGvn37oq6uLlasWBEHDx487vZPPfVU3HTTTfGJT3wi/uu//iuuv/76uP766+PZZ5895eEBAACgmGYWusOmTZtizZo10dzcHBER27Zti127dsX27dtj3bp1x2z/hS98IX7/938/PvOZz0RExB133BFPPPFEbNmyJbZt23bc1xgcHIzBwcHRr/v6+iIior+/v9Bxi2548LVijzDtTMXjZKpznE88x/nEc5xPPMf5xHOcTzzH+cRznE+8qXqc/2rukZGRE284UoDBwcGRGTNmjDz66KNj1jc1NY1ce+21x92npqZm5J577hmzbsOGDSPvfe97x32d1tbWkYiwWCwWi8VisVgsFoulqEt3d/cJO7mgK9WHDx+OoaGhqKqqGrO+qqoqfvjDHx53n56enuNu39PTM+7rrF+/PlpaWka/Hh4ejv/93/+Nt771rVFSUlLIyCT19/dHTU1NdHd3R0VFRbHHgTPCcc504DhnOnCcMx04zifeyMhIvPrqqzFv3rwTblfw278nQllZWZSVlY1Zd8EFFxRnmGmuoqLCDy1nPcc504HjnOnAcc504DifWJWVlW+6TUE3KpszZ07MmDEjent7x6zv7e2N6urq4+5TXV1d0PYAAAAwVRQU1bNmzYqlS5dGe3v76Lrh4eFob2+PhoaG4+7T0NAwZvuIiCeeeGLc7QEAAGCqKPjt3y0tLbF69eqor6+PZcuWxebNm2NgYGD0buBNTU0xf/78aGtri4iI2267La6++ur4/Oc/HytXrowdO3bEd77znfjSl750er8TTquysrJobW095m34cDZxnDMdOM6ZDhznTAeO88mrZGTkze4PfqwtW7bEXXfdFT09PbF48eL44he/GMuXL4+IiPe///1RW1sbDzzwwOj2Dz/8cPzN3/xNHDhwIH77t3877rzzzvjDP/zD0/ZNAAAAQDGkohoAAAAo8DPVAAAAwFGiGgAAAJJENQAAACSJagAAAEgS1QAAAJAkqgEAACBJVAPTwnPPPRdr166NJUuWxNy5c2Pu3LmxZMmSWLt2bTz33HPFHg/OiMHBwRgcHCz2GAAkOHeZOvydaiLijR/aLVu2REdHR/T09ERERHV1dTQ0NMStt94aixYtKvKEkPf1r389rr/++rjssstixYoVUVVVFRERvb298cQTT0RnZ2d87WtfixUrVhR5Ujh1TzzxRNxzzz3R0dER/f39ERFRUVERDQ0N0dLSEo2NjUWeEE6d8xbOds5dphZRjR9aznp1dXVx3XXXxe23337cxz/72c/GI488Et/97ncneDI4vR588MH45Cc/GR/96EeP+ff88ccfj3/913+N+++/P2655ZYiTwp5zluYDpy7TC2iGj+0nPXe8pa3xP79++Od73zncR9//vnnY/HixfH6669P8GRwer3jHe+I2267Lf70T//0uI//4z/+Y9xzzz3xox/9aIIng9PHeQvTgXOXqcVnqokXXnghPv7xj4/7+E033eQEjCmttrY2du3aNe7ju3btiosvvngCJ4Izo6ur64Rv7/7gBz8YL7300gROBKef8xamA+cuU8vMYg9A8f3qh3a834T5oWWqu/322+NjH/tY7NmzJxobG8e8VbC9vT12794dDz30UJGnhFP3O7/zO3H//ffHnXfeedzHt2/f7rOmTHnOW5gOnLtMLd7+TTz88MPxsY99LP7gD/7ghD+0H/nIR4o8KeQ99dRT8cUvfvG4N7W57bbboqGhocgTwqnbs2dP/NEf/VFccsklx/33/Kc//Wns2rUrrrrqqiJPCnnOW5gunLtMHaKaiPBDC3C2OHDgQNx7773x9NNPH/Pv+Z/8yZ9EbW1tcQeE08B5CzCZiGoAAABIcqMyYNr7q7/6q/jjP/7jYo8BAHBSnLtMLqKaN+WHlrPdyy+/HAcOHCj2GHDGrV69Oj7wgQ8Ueww4o5y3MB04d5lc3P2bN/XSSy/5EyyclUZGRqKkpCQefPDBYo8CE2LevHlRWur36ZzdnLcwHTh3mVx8phqYtmbNmhXPPPNMvOtd7yr2KAAATFGuVHOMgYGB+OpXvxo//vGPY+7cuXHTTTfFW9/61mKPBWktLS3HXT80NBQbN24cPb43bdo0kWPBhOvu7o7W1tbYvn17sUeBU/KDH/wgnn766WhoaIiFCxfGD3/4w/jCF74Qg4ODcfPNN/uYA2eF119/PTo7O+Oiiy6KRYsWjXns//7v/+KrX/1qNDU1FWk6/n+uVBOLFi2Kb33rW3HRRRdFd3d3XHXVVfGzn/0s3vGOd8RPfvKTmDlzZjz99NPxW7/1W8UeFVJKS0ujrq4uLrjggjHrv/nNb0Z9fX2cd955UVJSEv/5n/9ZnAFhgjzzzDNx2WWXxdDQULFHgbTdu3fHddddF7Nnz47XXnstHn300Whqaoq6uroYHh6Ob37zm/H4448La6a0F154IT784Q9HV1dXlJSUxPve977YsWNHzJ07NyLe+Lvs8+bN8+/5JCGqidLS0ujp6Ym3ve1tcfPNN8d///d/x2OPPRaVlZXxi1/8Im644Yb4jd/4jXjooYeKPSqkbNy4Mb70pS/FP//zP485yTrnnHPimWeeOea3vzBV/du//dsJH//pT38af/7nf+4kjCntiiuuiA984APxd3/3d7Fjx45Yu3ZtfOpTn4rPfe5zERGxfv366OzsjMcff7zIk0LeDTfcEL/85S/jgQceiJ///OfxZ3/2Z/Hcc8/Fnj174u1vf7uonmRENWOi+tJLL41t27bFhz70odHHn3rqqbjxxhujq6uriFPCqfn2t78dN998c1xzzTXR1tYW55xzjqjmrFNaWholJSVxov+1l5SUOAljSqusrIzOzs5YsGBBDA8PR1lZWezduzeWLFkSERHPPvtsNDY2Rk9PT5Enhbyqqqr4xje+Ee95z3si4o2bq65duzYee+yxePLJJ+O8884T1ZOIW4ASEW+cZEW88fmMX72t5Ffmz58fhw4dKsZYcNpcfvnl0dnZGYcOHYr6+vp49tlnR497OFvMnTs3HnnkkRgeHj7usm/fvmKPCKfFr/79Li0tjfLy8qisrBx97Pzzz4++vr5ijQanxeuvvx4zZx69/VVJSUnce++9cc0118TVV18dL7zwQhGn49eJaiIi4oMf/GBcdtll0d/fH88///yYx1588UU3KuOsMHv27HjwwQdj/fr10djY6Le7nHWWLl0anZ2d4z7+ZlexYSqora2NH/3oR6Nfd3R0xNvf/vbRr7u6uo65QABTzcKFC+M73/nOMeu3bNkS1113XVx77bVFmIrxuPs30draOubr2bNnj/n63//93+PKK6+cyJHgjLrxxhvjfe97X3R2dsbFF19c7HHgtPnMZz4TAwMD4z6+YMGCePLJJydwIjj9PvWpT435pei73/3uMY9//etfd5Myprwbbrgh/uVf/iVuueWWYx7bsmVLDA8Px7Zt24owGcfjM9UAAACQ5O3fAAAAkCSqAQAAIElUAwAAQJKoBgAAgCRRDQAAAEmiGgAAAJJENQAAACT9PxyylOH+bvB2AAAAAElFTkSuQmCC\n"
          },
          "metadata": {}
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "The distribution is skewed to the right. Over 50% of the ratings are 5, followed by a little below 20% with 4 star ratings. And the percentages of ratings keep going down until below 10% of the ratings are 2 stars."
      ],
      "metadata": {
        "id": "EyqB_PZOnbNq"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "### No of unique users and items"
      ],
      "metadata": {
        "id": "_hoBfcSmncDJ"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# Number of unique user id and product id in the data\n",
        "print('Number of unique USERS in Raw data = ', df['user_id'].nunique())\n",
        "print('Number of unique ITEMS in Raw data = ', df['prod_id'].nunique())"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "bTzXXqwrnZKh",
        "outputId": "d612aec9-c5f0-4a80-a360-9439a49770e8"
      },
      "execution_count": 31,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Number of unique USERS in Raw data =  4201696\n",
            "Number of unique ITEMS in Raw data =  476002\n"
          ]
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "### Users with most no of rating"
      ],
      "metadata": {
        "id": "PhOahvbHnkZJ"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# Top 10 users based on rating\n",
        "most_rated = df.groupby('user_id').size().sort_values(ascending=False)[:10]\n",
        "most_rated"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "DZ80koFAngO4",
        "outputId": "0c91b4b4-9621-44bf-8615-233df03313b9"
      },
      "execution_count": 32,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "user_id\n",
              "A5JLAU2ARJ0BO     520\n",
              "ADLVFFE4VBT8      501\n",
              "A3OXHLG6DIBRW8    498\n",
              "A6FIAB28IS79      431\n",
              "A680RUE1FDO8B     406\n",
              "A1ODOGXEYECQQ8    380\n",
              "A36K2N527TXXJN    314\n",
              "A2AY4YUOX2N1BQ    311\n",
              "AWPODHOB4GFWL     308\n",
              "A25C2M3QF9G7OQ    296\n",
              "dtype: int64"
            ]
          },
          "metadata": {},
          "execution_count": 32
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "## Pre-Processing\n",
        "\n",
        "Let's take a subset of the dataset (by only keeping the users who have given 50 or more ratings) to make the dataset less sparse and easy to work with."
      ],
      "metadata": {
        "id": "ekGg2mL5oaNA"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "counts = df['user_id'].value_counts()\n",
        "df_final = df[df['user_id'].isin(counts[counts >= 50].index)]"
      ],
      "metadata": {
        "id": "k3T1weHIodDw"
      },
      "execution_count": 33,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "print('The number of observations in the final data =', len(df_final))\n",
        "print('Number of unique USERS in the final data = ', df_final['user_id'].nunique())\n",
        "print('Number of unique PRODUCTS in the final data = ', df_final['prod_id'].nunique())"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "KDnxTiwUordB",
        "outputId": "5f7a34a9-b59e-484a-ba70-a20e41e0b98c"
      },
      "execution_count": 34,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "The number of observations in the final data = 125871\n",
            "Number of unique USERS in the final data =  1540\n",
            "Number of unique PRODUCTS in the final data =  48190\n"
          ]
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "- The dataframe **df_final has users who have rated 50 or more items**\n",
        "- **We will use df_final to build recommendation systems**"
      ],
      "metadata": {
        "id": "tsmGpFwqocrg"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "### Checking the density of the rating matrix"
      ],
      "metadata": {
        "id": "k6t4Ee-Oo0vD"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "#Creating the interaction matrix of products and users based on ratings and replacing NaN value with 0\n",
        "final_ratings_matrix = df_final.pivot(index = 'user_id', columns ='prod_id', values = 'rating').fillna(0)\n",
        "print('Shape of final_ratings_matrix: ', final_ratings_matrix.shape)\n",
        "\n",
        "#Finding the number of non-zero entries in the interaction matrix \n",
        "given_num_of_ratings = np.count_nonzero(final_ratings_matrix)\n",
        "print('given_num_of_ratings = ', given_num_of_ratings)\n",
        "\n",
        "#Finding the possible number of ratings as per the number of users and products\n",
        "possible_num_of_ratings = final_ratings_matrix.shape[0] * final_ratings_matrix.shape[1]\n",
        "print('possible_num_of_ratings = ', possible_num_of_ratings)\n",
        "\n",
        "#Density of ratings\n",
        "density = (given_num_of_ratings/possible_num_of_ratings)\n",
        "density *= 100\n",
        "print ('density: {:4.2f}%'.format(density))\n",
        "\n",
        "final_ratings_matrix.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 400
        },
        "id": "Q3kGwNuyoxiR",
        "outputId": "269f87b7-d6cd-4251-c1a7-00482cd84120"
      },
      "execution_count": 35,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Shape of final_ratings_matrix:  (1540, 48190)\n",
            "given_num_of_ratings =  125871\n",
            "possible_num_of_ratings =  74212600\n",
            "density: 0.17%\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "prod_id         0594451647  0594481813  0970407998  0972683275  1400501466  \\\n",
              "user_id                                                                      \n",
              "A100UD67AHFODS         0.0         0.0         0.0         0.0         0.0   \n",
              "A100WO06OQR8BQ         0.0         0.0         0.0         0.0         0.0   \n",
              "A105S56ODHGJEK         0.0         0.0         0.0         0.0         0.0   \n",
              "A105TOJ6LTVMBG         0.0         0.0         0.0         0.0         0.0   \n",
              "A10AFVU66A79Y1         0.0         0.0         0.0         0.0         0.0   \n",
              "\n",
              "prod_id         1400501520  1400501776  1400532620  1400532655  140053271X  \\\n",
              "user_id                                                                      \n",
              "A100UD67AHFODS         0.0         0.0         0.0         0.0         0.0   \n",
              "A100WO06OQR8BQ         0.0         0.0         0.0         0.0         0.0   \n",
              "A105S56ODHGJEK         0.0         0.0         0.0         0.0         0.0   \n",
              "A105TOJ6LTVMBG         0.0         0.0         0.0         0.0         0.0   \n",
              "A10AFVU66A79Y1         0.0         0.0         0.0         0.0         0.0   \n",
              "\n",
              "prod_id         ...  B00L5YZCCG  B00L8I6SFY  B00L8QCVL6  B00LA6T0LS  \\\n",
              "user_id         ...                                                   \n",
              "A100UD67AHFODS  ...         0.0         0.0         0.0         0.0   \n",
              "A100WO06OQR8BQ  ...         0.0         0.0         0.0         0.0   \n",
              "A105S56ODHGJEK  ...         0.0         0.0         0.0         0.0   \n",
              "A105TOJ6LTVMBG  ...         0.0         0.0         0.0         0.0   \n",
              "A10AFVU66A79Y1  ...         0.0         0.0         0.0         0.0   \n",
              "\n",
              "prod_id         B00LBZ1Z7K  B00LED02VY  B00LGN7Y3G  B00LGQ6HL8  B00LI4ZZO8  \\\n",
              "user_id                                                                      \n",
              "A100UD67AHFODS         0.0         0.0         0.0         0.0         0.0   \n",
              "A100WO06OQR8BQ         0.0         0.0         0.0         0.0         0.0   \n",
              "A105S56ODHGJEK         0.0         0.0         0.0         0.0         0.0   \n",
              "A105TOJ6LTVMBG         0.0         0.0         0.0         0.0         0.0   \n",
              "A10AFVU66A79Y1         0.0         0.0         0.0         0.0         0.0   \n",
              "\n",
              "prod_id         B00LKG1MC8  \n",
              "user_id                     \n",
              "A100UD67AHFODS         0.0  \n",
              "A100WO06OQR8BQ         0.0  \n",
              "A105S56ODHGJEK         0.0  \n",
              "A105TOJ6LTVMBG         0.0  \n",
              "A10AFVU66A79Y1         0.0  \n",
              "\n",
              "[5 rows x 48190 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-d42fe376-3707-4a05-aea8-130184fa4400\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>prod_id</th>\n",
              "      <th>0594451647</th>\n",
              "      <th>0594481813</th>\n",
              "      <th>0970407998</th>\n",
              "      <th>0972683275</th>\n",
              "      <th>1400501466</th>\n",
              "      <th>1400501520</th>\n",
              "      <th>1400501776</th>\n",
              "      <th>1400532620</th>\n",
              "      <th>1400532655</th>\n",
              "      <th>140053271X</th>\n",
              "      <th>...</th>\n",
              "      <th>B00L5YZCCG</th>\n",
              "      <th>B00L8I6SFY</th>\n",
              "      <th>B00L8QCVL6</th>\n",
              "      <th>B00LA6T0LS</th>\n",
              "      <th>B00LBZ1Z7K</th>\n",
              "      <th>B00LED02VY</th>\n",
              "      <th>B00LGN7Y3G</th>\n",
              "      <th>B00LGQ6HL8</th>\n",
              "      <th>B00LI4ZZO8</th>\n",
              "      <th>B00LKG1MC8</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>user_id</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>A100UD67AHFODS</th>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>A100WO06OQR8BQ</th>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>A105S56ODHGJEK</th>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>A105TOJ6LTVMBG</th>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>A10AFVU66A79Y1</th>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 48190 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-d42fe376-3707-4a05-aea8-130184fa4400')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-d42fe376-3707-4a05-aea8-130184fa4400 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-d42fe376-3707-4a05-aea8-130184fa4400');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 35
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "# Rank Based Recommendation System "
      ],
      "metadata": {
        "id": "7dzfbm7tw1YJ"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "#Calculate the average rating for each product \n",
        "average_rating = df_final.groupby('prod_id').mean()['rating']\n",
        "\n",
        "#Calculate the count of ratings for each product\n",
        "count_rating = df_final.groupby('prod_id').count()['rating']\n",
        "\n",
        "#Create a dataframe with calculated average and count of ratings\n",
        "final_rating = pd.DataFrame({'avg_rating':average_rating, 'rating_count':count_rating})\n",
        "\n",
        "#Sort the dataframe by average of ratings\n",
        "final_rating = final_rating.sort_values(by='avg_rating',ascending=False)\n",
        "\n",
        "final_rating.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 237
        },
        "id": "me4iOm2ow9Yx",
        "outputId": "8c2ba921-f35a-4e1a-8bf1-fb7e3cbdefeb"
      },
      "execution_count": 36,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "            avg_rating  rating_count\n",
              "prod_id                             \n",
              "0594451647         5.0             1\n",
              "B003RRY9RS         5.0             1\n",
              "B003RR95Q8         5.0             1\n",
              "B003RIPMZU         5.0             1\n",
              "B003RFRNYQ         5.0             2"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-f88e885f-a197-4f40-927d-3fc5c185cf74\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>avg_rating</th>\n",
              "      <th>rating_count</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>prod_id</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0594451647</th>\n",
              "      <td>5.0</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>B003RRY9RS</th>\n",
              "      <td>5.0</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>B003RR95Q8</th>\n",
              "      <td>5.0</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>B003RIPMZU</th>\n",
              "      <td>5.0</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>B003RFRNYQ</th>\n",
              "      <td>5.0</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-f88e885f-a197-4f40-927d-3fc5c185cf74')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-f88e885f-a197-4f40-927d-3fc5c185cf74 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-f88e885f-a197-4f40-927d-3fc5c185cf74');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 36
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#defining a function to get the top n products based on highest average rating and minimum interactions\n",
        "def top_n_products(final_rating, n, min_interaction):\n",
        "    \n",
        "    #Finding products with minimum number of interactions\n",
        "    recommendations = final_rating[final_rating['rating_count']>min_interaction]\n",
        "    \n",
        "    #Sorting values w.r.t average rating \n",
        "    recommendations = recommendations.sort_values('avg_rating',ascending=False)\n",
        "    \n",
        "    return recommendations.index[:n]"
      ],
      "metadata": {
        "id": "OhUAXTtgw-8Q"
      },
      "execution_count": 37,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "## Recommending top 5 products with 50 minimum interactions based on popularity"
      ],
      "metadata": {
        "id": "wem_XKyUxGEw"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "list(top_n_products(final_rating, 5, 50))"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "5Tp7b5ByxCl4",
        "outputId": "030923b7-3903-45e1-dbb8-49c91dbeb65a"
      },
      "execution_count": 38,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "['B001TH7GUU', 'B003ES5ZUU', 'B0019EHU8G', 'B006W8U2MU', 'B000QUUFRW']"
            ]
          },
          "metadata": {},
          "execution_count": 38
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "## Recommending top 5 products with 100 minimum interactions based on popularity"
      ],
      "metadata": {
        "id": "1dMFKudcxJW5"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "list(top_n_products(final_rating, 5, 100))"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "-3lUEc76xL_Y",
        "outputId": "a4e4ec84-a9b0-4900-a105-26c073637433"
      },
      "execution_count": 39,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "['B003ES5ZUU', 'B000N99BBC', 'B007WTAJTO', 'B002V88HFE', 'B004CLYEDC']"
            ]
          },
          "metadata": {},
          "execution_count": 39
        }
      ]
    }
  ]
}