07-modelo_recomendacion.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Modelo de recomendación de juegos"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Importaciones"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "\n",
    "import scipy as sp\n",
    "from sklearn.metrics.pairwise import cosine_similarity\n",
    "import operator\n",
    "\n",
    "import pyarrow as pa\n",
    "import pyarrow.parquet as pq"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Datos a utilizar"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Se leen los datos que se prepararon luego del EDA y se convierten en dataframe para ser utilizados por el modelo."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "modelo = pd.read_parquet('data/10-modelo-recomend.parquet')\n",
    "item_similar = pd.read_parquet('data/13-item-similar.parquet')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "El primer paso es crear un dataframe que contiene los 'user_id' como índices, los juegos ('item_name') como columnas y como valores los ´rating'."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th>item_name</th>\n",
       "      <th>! That Bastard Is Trying To Steal Our Gold !</th>\n",
       "      <th>0RBITALIS</th>\n",
       "      <th>10,000,000</th>\n",
       "      <th>100% Orange Juice</th>\n",
       "      <th>1001 Spikes</th>\n",
       "      <th>12 Labours of Hercules</th>\n",
       "      <th>12 Labours of Hercules II: The Cretan Bull</th>\n",
       "      <th>12 is Better Than 6</th>\n",
       "      <th>140</th>\n",
       "      <th>16bit Trader</th>\n",
       "      <th>...</th>\n",
       "      <th>inMomentum</th>\n",
       "      <th>klocki</th>\n",
       "      <th>liteCam Game: 100 FPS Game Capture</th>\n",
       "      <th>oO</th>\n",
       "      <th>planetarian ~the reverie of a little planet~</th>\n",
       "      <th>resident evil 4 / biohazard 4</th>\n",
       "      <th>sZone-Online</th>\n",
       "      <th>the static speaks my name</th>\n",
       "      <th>theHunter</th>\n",
       "      <th>theHunter: Primal</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>--000--</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>--ace--</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>--ionex--</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>-2SV-vuLB-Kg</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>-Azsael-</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zuzuga2003</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zv_odd</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zvanik</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zwanzigdrei</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zzoptimuszz</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>21134 rows × 2814 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "item_name     ! That Bastard Is Trying To Steal Our Gold !  0RBITALIS  \\\n",
       "user_id                                                                 \n",
       "--000--                                                NaN        NaN   \n",
       "--ace--                                                NaN        NaN   \n",
       "--ionex--                                              NaN        NaN   \n",
       "-2SV-vuLB-Kg                                           NaN        NaN   \n",
       "-Azsael-                                               NaN        NaN   \n",
       "...                                                    ...        ...   \n",
       "zuzuga2003                                             NaN        NaN   \n",
       "zv_odd                                                 NaN        NaN   \n",
       "zvanik                                                 NaN        NaN   \n",
       "zwanzigdrei                                            NaN        NaN   \n",
       "zzoptimuszz                                            NaN        NaN   \n",
       "\n",
       "item_name     10,000,000  100% Orange Juice  1001 Spikes  \\\n",
       "user_id                                                    \n",
       "--000--              NaN                NaN          NaN   \n",
       "--ace--              NaN                NaN          NaN   \n",
       "--ionex--            NaN                NaN          NaN   \n",
       "-2SV-vuLB-Kg         NaN                NaN          NaN   \n",
       "-Azsael-             NaN                NaN          NaN   \n",
       "...                  ...                ...          ...   \n",
       "zuzuga2003           NaN                NaN          NaN   \n",
       "zv_odd               NaN                NaN          NaN   \n",
       "zvanik               NaN                NaN          NaN   \n",
       "zwanzigdrei          NaN                NaN          NaN   \n",
       "zzoptimuszz          NaN                NaN          NaN   \n",
       "\n",
       "item_name     12 Labours of Hercules  \\\n",
       "user_id                                \n",
       "--000--                          NaN   \n",
       "--ace--                          NaN   \n",
       "--ionex--                        NaN   \n",
       "-2SV-vuLB-Kg                     NaN   \n",
       "-Azsael-                         NaN   \n",
       "...                              ...   \n",
       "zuzuga2003                       NaN   \n",
       "zv_odd                           NaN   \n",
       "zvanik                           NaN   \n",
       "zwanzigdrei                      NaN   \n",
       "zzoptimuszz                      NaN   \n",
       "\n",
       "item_name     12 Labours of Hercules II: The Cretan Bull  12 is Better Than 6  \\\n",
       "user_id                                                                         \n",
       "--000--                                              NaN                  NaN   \n",
       "--ace--                                              NaN                  NaN   \n",
       "--ionex--                                            NaN                  NaN   \n",
       "-2SV-vuLB-Kg                                         NaN                  NaN   \n",
       "-Azsael-                                             NaN                  NaN   \n",
       "...                                                  ...                  ...   \n",
       "zuzuga2003                                           NaN                  NaN   \n",
       "zv_odd                                               NaN                  NaN   \n",
       "zvanik                                               NaN                  NaN   \n",
       "zwanzigdrei                                          NaN                  NaN   \n",
       "zzoptimuszz                                          NaN                  NaN   \n",
       "\n",
       "item_name     140  16bit Trader  ...  inMomentum  klocki  \\\n",
       "user_id                          ...                       \n",
       "--000--       NaN           NaN  ...         NaN     NaN   \n",
       "--ace--       NaN           NaN  ...         NaN     NaN   \n",
       "--ionex--     NaN           NaN  ...         NaN     NaN   \n",
       "-2SV-vuLB-Kg  NaN           NaN  ...         NaN     NaN   \n",
       "-Azsael-      NaN           NaN  ...         NaN     NaN   \n",
       "...           ...           ...  ...         ...     ...   \n",
       "zuzuga2003    NaN           NaN  ...         NaN     NaN   \n",
       "zv_odd        NaN           NaN  ...         NaN     NaN   \n",
       "zvanik        NaN           NaN  ...         NaN     NaN   \n",
       "zwanzigdrei   NaN           NaN  ...         NaN     NaN   \n",
       "zzoptimuszz   NaN           NaN  ...         NaN     NaN   \n",
       "\n",
       "item_name     liteCam Game: 100 FPS Game Capture  oO  \\\n",
       "user_id                                                \n",
       "--000--                                      NaN NaN   \n",
       "--ace--                                      NaN NaN   \n",
       "--ionex--                                    NaN NaN   \n",
       "-2SV-vuLB-Kg                                 NaN NaN   \n",
       "-Azsael-                                     NaN NaN   \n",
       "...                                          ...  ..   \n",
       "zuzuga2003                                   NaN NaN   \n",
       "zv_odd                                       NaN NaN   \n",
       "zvanik                                       NaN NaN   \n",
       "zwanzigdrei                                  NaN NaN   \n",
       "zzoptimuszz                                  NaN NaN   \n",
       "\n",
       "item_name     planetarian ~the reverie of a little planet~  \\\n",
       "user_id                                                      \n",
       "--000--                                                NaN   \n",
       "--ace--                                                NaN   \n",
       "--ionex--                                              NaN   \n",
       "-2SV-vuLB-Kg                                           NaN   \n",
       "-Azsael-                                               NaN   \n",
       "...                                                    ...   \n",
       "zuzuga2003                                             NaN   \n",
       "zv_odd                                                 NaN   \n",
       "zvanik                                                 NaN   \n",
       "zwanzigdrei                                            NaN   \n",
       "zzoptimuszz                                            NaN   \n",
       "\n",
       "item_name     resident evil 4 / biohazard 4  sZone-Online  \\\n",
       "user_id                                                     \n",
       "--000--                                 NaN           NaN   \n",
       "--ace--                                 NaN           NaN   \n",
       "--ionex--                               NaN           NaN   \n",
       "-2SV-vuLB-Kg                            NaN           NaN   \n",
       "-Azsael-                                NaN           NaN   \n",
       "...                                     ...           ...   \n",
       "zuzuga2003                              NaN           NaN   \n",
       "zv_odd                                  NaN           NaN   \n",
       "zvanik                                  NaN           NaN   \n",
       "zwanzigdrei                             NaN           NaN   \n",
       "zzoptimuszz                             NaN           NaN   \n",
       "\n",
       "item_name     the static speaks my name  theHunter  theHunter: Primal  \n",
       "user_id                                                                \n",
       "--000--                             NaN        NaN                NaN  \n",
       "--ace--                             NaN        NaN                NaN  \n",
       "--ionex--                           NaN        NaN                NaN  \n",
       "-2SV-vuLB-Kg                        NaN        NaN                NaN  \n",
       "-Azsael-                            NaN        NaN                NaN  \n",
       "...                                 ...        ...                ...  \n",
       "zuzuga2003                          NaN        NaN                NaN  \n",
       "zv_odd                              NaN        NaN                NaN  \n",
       "zvanik                              NaN        NaN                NaN  \n",
       "zwanzigdrei                         NaN        NaN                NaN  \n",
       "zzoptimuszz                         NaN        NaN                NaN  \n",
       "\n",
       "[21134 rows x 2814 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "piv = modelo.pivot_table(index=['user_id'], columns=['item_name'], values='rating')\n",
    "piv"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "A continuación, se normalizan los valores del dataframe `piv` restar la media de las calificaciones de un usuario y luego dividir por la diferencia entre el valor máximo y mínimo de las calificaciones. Esto ajusta las calificaciones de un usuario de manera que estén centradas en cero y escaladas en función de su variabilidad. A los usuarios que solo han dado una calificación o han calificado todos los juegos de la misma manera serán eliminados durante este proceso de normalización. Esto se debe a que estos usuarios no aportan información útil para el modelo de recomendación si todas sus calificaciones son iguales o si solo tienen una calificación."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th>user_id</th>\n",
       "      <th>--000--</th>\n",
       "      <th>-Beave-</th>\n",
       "      <th>-I_AM_EPIC-</th>\n",
       "      <th>-SEVEN-</th>\n",
       "      <th>-Thyme-</th>\n",
       "      <th>-kainey9777</th>\n",
       "      <th>00000000000000000001227</th>\n",
       "      <th>00690069006900</th>\n",
       "      <th>03092002</th>\n",
       "      <th>04061993</th>\n",
       "      <th>...</th>\n",
       "      <th>zomgCoBfAce</th>\n",
       "      <th>zoom-the-flash</th>\n",
       "      <th>zoozles</th>\n",
       "      <th>zourock</th>\n",
       "      <th>zrustz16</th>\n",
       "      <th>zsharoarkbr</th>\n",
       "      <th>zuzuga2003</th>\n",
       "      <th>zvanik</th>\n",
       "      <th>zwanzigdrei</th>\n",
       "      <th>zzoptimuszz</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>item_name</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>! That Bastard Is Trying To Steal Our Gold !</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>0RBITALIS</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>10,000,000</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>100% Orange Juice</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>1001 Spikes</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>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>resident evil 4 / biohazard 4</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>sZone-Online</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>the static speaks my name</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>theHunter</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>theHunter: Primal</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>2814 rows × 6855 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "user_id                                       --000--  -Beave-  -I_AM_EPIC-  \\\n",
       "item_name                                                                     \n",
       "! That Bastard Is Trying To Steal Our Gold !      0.0      0.0          0.0   \n",
       "0RBITALIS                                         0.0      0.0          0.0   \n",
       "10,000,000                                        0.0      0.0          0.0   \n",
       "100% Orange Juice                                 0.0      0.0          0.0   \n",
       "1001 Spikes                                       0.0      0.0          0.0   \n",
       "...                                               ...      ...          ...   \n",
       "resident evil 4 / biohazard 4                     0.0      0.0          0.0   \n",
       "sZone-Online                                      0.0      0.0          0.0   \n",
       "the static speaks my name                         0.0      0.0          0.0   \n",
       "theHunter                                         0.0      0.0          0.0   \n",
       "theHunter: Primal                                 0.0      0.0          0.0   \n",
       "\n",
       "user_id                                       -SEVEN-  -Thyme-  -kainey9777  \\\n",
       "item_name                                                                     \n",
       "! That Bastard Is Trying To Steal Our Gold !      0.0      0.0          0.0   \n",
       "0RBITALIS                                         0.0      0.0          0.0   \n",
       "10,000,000                                        0.0      0.0          0.0   \n",
       "100% Orange Juice                                 0.0      0.0          0.0   \n",
       "1001 Spikes                                       0.0      0.0          0.0   \n",
       "...                                               ...      ...          ...   \n",
       "resident evil 4 / biohazard 4                     0.0      0.0          0.0   \n",
       "sZone-Online                                      0.0      0.0          0.0   \n",
       "the static speaks my name                         0.0      0.0          0.0   \n",
       "theHunter                                         0.0      0.0          0.0   \n",
       "theHunter: Primal                                 0.0      0.0          0.0   \n",
       "\n",
       "user_id                                       00000000000000000001227  \\\n",
       "item_name                                                               \n",
       "! That Bastard Is Trying To Steal Our Gold !                      0.0   \n",
       "0RBITALIS                                                         0.0   \n",
       "10,000,000                                                        0.0   \n",
       "100% Orange Juice                                                 0.0   \n",
       "1001 Spikes                                                       0.0   \n",
       "...                                                               ...   \n",
       "resident evil 4 / biohazard 4                                     0.0   \n",
       "sZone-Online                                                      0.0   \n",
       "the static speaks my name                                         0.0   \n",
       "theHunter                                                         0.0   \n",
       "theHunter: Primal                                                 0.0   \n",
       "\n",
       "user_id                                       00690069006900  03092002  \\\n",
       "item_name                                                                \n",
       "! That Bastard Is Trying To Steal Our Gold !             0.0       0.0   \n",
       "0RBITALIS                                                0.0       0.0   \n",
       "10,000,000                                               0.0       0.0   \n",
       "100% Orange Juice                                        0.0       0.0   \n",
       "1001 Spikes                                              0.0       0.0   \n",
       "...                                                      ...       ...   \n",
       "resident evil 4 / biohazard 4                            0.0       0.0   \n",
       "sZone-Online                                             0.0       0.0   \n",
       "the static speaks my name                                0.0       0.0   \n",
       "theHunter                                                0.0       0.0   \n",
       "theHunter: Primal                                        0.0       0.0   \n",
       "\n",
       "user_id                                       04061993  ...  zomgCoBfAce  \\\n",
       "item_name                                               ...                \n",
       "! That Bastard Is Trying To Steal Our Gold !       0.0  ...          0.0   \n",
       "0RBITALIS                                          0.0  ...          0.0   \n",
       "10,000,000                                         0.0  ...          0.0   \n",
       "100% Orange Juice                                  0.0  ...          0.0   \n",
       "1001 Spikes                                        0.0  ...          0.0   \n",
       "...                                                ...  ...          ...   \n",
       "resident evil 4 / biohazard 4                      0.0  ...          0.0   \n",
       "sZone-Online                                       0.0  ...          0.0   \n",
       "the static speaks my name                          0.0  ...          0.0   \n",
       "theHunter                                          0.0  ...          0.0   \n",
       "theHunter: Primal                                  0.0  ...          0.0   \n",
       "\n",
       "user_id                                       zoom-the-flash  zoozles  \\\n",
       "item_name                                                               \n",
       "! That Bastard Is Trying To Steal Our Gold !             0.0      0.0   \n",
       "0RBITALIS                                                0.0      0.0   \n",
       "10,000,000                                               0.0      0.0   \n",
       "100% Orange Juice                                        0.0      0.0   \n",
       "1001 Spikes                                              0.0      0.0   \n",
       "...                                                      ...      ...   \n",
       "resident evil 4 / biohazard 4                            0.0      0.0   \n",
       "sZone-Online                                             0.0      0.0   \n",
       "the static speaks my name                                0.0      0.0   \n",
       "theHunter                                                0.0      0.0   \n",
       "theHunter: Primal                                        0.0      0.0   \n",
       "\n",
       "user_id                                       zourock  zrustz16  zsharoarkbr  \\\n",
       "item_name                                                                      \n",
       "! That Bastard Is Trying To Steal Our Gold !      0.0       0.0          0.0   \n",
       "0RBITALIS                                         0.0       0.0          0.0   \n",
       "10,000,000                                        0.0       0.0          0.0   \n",
       "100% Orange Juice                                 0.0       0.0          0.0   \n",
       "1001 Spikes                                       0.0       0.0          0.0   \n",
       "...                                               ...       ...          ...   \n",
       "resident evil 4 / biohazard 4                     0.0       0.0          0.0   \n",
       "sZone-Online                                      0.0       0.0          0.0   \n",
       "the static speaks my name                         0.0       0.0          0.0   \n",
       "theHunter                                         0.0       0.0          0.0   \n",
       "theHunter: Primal                                 0.0       0.0          0.0   \n",
       "\n",
       "user_id                                       zuzuga2003  zvanik  zwanzigdrei  \\\n",
       "item_name                                                                       \n",
       "! That Bastard Is Trying To Steal Our Gold !         0.0     0.0          0.0   \n",
       "0RBITALIS                                            0.0     0.0          0.0   \n",
       "10,000,000                                           0.0     0.0          0.0   \n",
       "100% Orange Juice                                    0.0     0.0          0.0   \n",
       "1001 Spikes                                          0.0     0.0          0.0   \n",
       "...                                                  ...     ...          ...   \n",
       "resident evil 4 / biohazard 4                        0.0     0.0          0.0   \n",
       "sZone-Online                                         0.0     0.0          0.0   \n",
       "the static speaks my name                            0.0     0.0          0.0   \n",
       "theHunter                                            0.0     0.0          0.0   \n",
       "theHunter: Primal                                    0.0     0.0          0.0   \n",
       "\n",
       "user_id                                       zzoptimuszz  \n",
       "item_name                                                  \n",
       "! That Bastard Is Trying To Steal Our Gold !          0.0  \n",
       "0RBITALIS                                             0.0  \n",
       "10,000,000                                            0.0  \n",
       "100% Orange Juice                                     0.0  \n",
       "1001 Spikes                                           0.0  \n",
       "...                                                   ...  \n",
       "resident evil 4 / biohazard 4                         0.0  \n",
       "sZone-Online                                          0.0  \n",
       "the static speaks my name                             0.0  \n",
       "theHunter                                             0.0  \n",
       "theHunter: Primal                                     0.0  \n",
       "\n",
       "[2814 rows x 6855 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Normalización del dataframe 'piv'\n",
    "piv_norm = piv.apply(lambda x: (x-np.mean(x))/(np.max(x)-np.min(x)), axis=1)\n",
    "# Se borran las columnas que contienen solo cero o no tienen rating, se rellenan los vacíos con 0 y se hace la transpuesta\n",
    "piv_norm.fillna(0, inplace=True)\n",
    "piv_norm = piv_norm.T\n",
    "piv_norm = piv_norm.loc[:, (piv_norm != 0).any(axis=0)]\n",
    "piv_norm"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "A los datos de esta matriz normalizada se los convierte a un formato de matriz dispersa (sparse matrix) para reducir la memoria utilizada y mejorar la eficiencia en el manejo de grandes conjuntos de datos, especialmente cuando la mayoría de los valores en la matriz son ceros. La matriz dispersa es un tipo de estructura de datos que almacena solo los valores distintos de cero junto con su ubicación en la matriz, en lugar de almacenar todos los valores de la matriz, incluso los ceros."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<2814x6855 sparse matrix of type '<class 'numpy.float64'>'\n",
       "\twith 24199 stored elements in Compressed Sparse Row format>"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "piv_sparse = sp.sparse.csr_matrix(piv_norm.values)\n",
    "piv_sparse"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Ahora, se crean dos matrices de similitud utilizando la similitud del coseno para medir la similitud entre los juegos (item_similarity) y entre los usuarios (user_similarity).\n",
    "\n",
    "La similitud del coseno es una medida comúnmente utilizada para evaluar la similitud entre dos vectores en un espacio multidimensional. En el contexto de sistemas de recomendación y análisis de datos, la similitud del coseno se utiliza para determinar cuán similares son dos conjuntos de datos o elementos, y se calcula utilizando el coseno del ángulo entre los vectores que representan esos datos o elementos."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "item_similarity = cosine_similarity(piv_sparse)\n",
    "user_similarity = cosine_similarity(piv_sparse.T)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Para estructurar y organizar los resultados de manera más accesible y comprensible se insertan las matrices anteriores en un Dataframe."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "#item similarity dataframe\n",
    "item_similar = pd.DataFrame(item_similarity, index = piv_norm.index, columns = piv_norm.index)\n",
    "#user similarity dataframe\n",
    "user_similar = pd.DataFrame(user_similarity, index = piv_norm.columns, columns = piv_norm.columns)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Función de recomendación según un juego"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Ahora, conociendo la relación entre los distintos juegos, se puede proponer una función que realice una recomendación de 5 juegos en función de un juego dado, teniendo en cuenta los valores mas altos de similitud del coseno. Esta función toma un nombre de un juego como entrada, luego ordena la columna correspondiente a ese juego en la matriz de similitud entre elementos (`item_similar`) de manera descendente, de modo que los juegos más similares aparezcan en la parte superior. Posteriormente selecciona los 5 juegos más similares (excluyendo el propio juego que se pasó como entrada), itera a través de estos juegos similares y, finalmente, imprime una lista de juegos similares al juego especificado."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "def top_game(game):\n",
    "    '''\n",
    "    Muestra una lista de juegos similares a un juego dado.\n",
    "\n",
    "    Args:\n",
    "        game (str): El nombre del juego para el cual se desean encontrar juegos similares.\n",
    "\n",
    "    Returns:\n",
    "        None: Esta función imprime una lista de juegos 5 similares al dado.\n",
    "\n",
    "    '''\n",
    "    count = 1\n",
    "    print('Similar games to {} include:\\n'.format(game))\n",
    "    for item in item_similar.sort_values(by = game, ascending = False).index[1:6]:\n",
    "        print('No. {}: {}'.format(count, item))\n",
    "        count +=1  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Similar games to Counter-Strike include:\n",
      "\n",
      "No. 1: Tap Heroes\n",
      "No. 2: Counter-Strike: Condition Zero\n",
      "No. 3: S.T.A.L.K.E.R.: Call of Pripyat\n",
      "No. 4: World of Soccer online\n",
      "No. 5: Hearts of Iron III\n"
     ]
    }
   ],
   "source": [
    "# ejemplo\n",
    "top_game('Counter-Strike')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Similar games to Age of Empires II: HD Edition include:\n",
      "\n",
      "No. 1: Farnham Fables\n",
      "No. 2: Trials Evolution Gold Edition\n",
      "No. 3: Brütal Legend\n",
      "No. 4: Serious Sam HD: The First Encounter\n",
      "No. 5: Darkest Dungeon\n"
     ]
    }
   ],
   "source": [
    "# ejemplo\n",
    "top_game('Age of Empires II: HD Edition')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Función de recomendación según un usuario"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "La siguiente función tiene la finalidad de mostrar una lista de usuarios más similares a un usuario dado, junto con sus valores de similitud. Primero, ordena la matriz de similitud entre usuarios (`user_similar`) en orden descendente según la similitud con el usuario dado ('user_id'), luego toma los 5 usuarios más similares (excluyendo el propio usuario) y almacena sus nombres y valores de similitud en las listas sim_users y sim_values. Finalmente, combina los nombres de usuario y los valores de similitud en una lista de tuplas utilizando la función zip y los imprime.\n",
    "\n",
    "Esto es útil en sistemas de recomendación para mostrar a un usuario los usuarios más similares en función de sus calificaciones pasadas, lo que puede ayudar en la generación de recomendaciones personalizadas."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "def top_users(user):\n",
    "    '''\n",
    "    Muestra una lista de los usuarios más similares a un usuario dado y sus valores de similitud.\n",
    "\n",
    "    Args:\n",
    "        user (str): El nombre o identificador del usuario para el cual se desean encontrar usuarios similares.\n",
    "\n",
    "    Returns:\n",
    "        None: Esta función imprime la lista de usuarios similares y sus valores de similitud en la consola.\n",
    "\n",
    "    '''\n",
    "    # Verifica si el usuario está presente en las columnas de piv_norm (si no está, devuelve un mensaje)\n",
    "    if user not in piv_norm.columns:\n",
    "        return('No data available on user {}'.format(user))\n",
    "    \n",
    "    print('Most Similar Users:\\n')\n",
    "    # Ordena los usuarios por similitud descendente y toma los 5 usuarios más similares (excluyendo el propio 'user')\n",
    "    sim_values = user_similar.sort_values(by=user, ascending=False).loc[:,user].tolist()[1:6]\n",
    "    sim_users = user_similar.sort_values(by=user, ascending=False).index[1:11]\n",
    "    # Combina los nombres de usuario y los valores de similitud en una lista de tuplas\n",
    "    zipped = zip(sim_users, sim_values,)\n",
    "    \n",
    "    # Itera a través de las tuplas y muestra los usuarios similares y sus valores de similitu\n",
    "    for user, sim in zipped:\n",
    "        print('User #{0}, Similarity value: {1:.2f}'.format(user, sim)) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Most Similar Users:\n",
      "\n",
      "User #haloslayer1, Similarity value: 0.85\n",
      "User #76561198112249349, Similarity value: 0.85\n",
      "User #123123718417671290, Similarity value: 0.79\n",
      "User #DeNo64, Similarity value: 0.75\n",
      "User #tsunamitad, Similarity value: 0.75\n"
     ]
    }
   ],
   "source": [
    "# ejemplo\n",
    "top_users('76561198028042361')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "En esta función, se generar una lista de 5 juegos recomendados para un usuario en función de las calificaciones de usuarios similares. Los juegos que son más frecuentemente recomendados por usuarios similares se consideran como las principales recomendaciones para ese usuario."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "def similar_user_recs(user):\n",
    "    '''\n",
    "    Genera una lista de los juegos más recomendados para un usuario, basándose en las calificaciones de usuarios similares.\n",
    "\n",
    "    Args:\n",
    "        user (str): El nombre o identificador del usuario para el cual se desean generar recomendaciones.\n",
    "\n",
    "    Returns:\n",
    "        list: Una lista de los juegos más recomendados para el usuario basado en la calificación de usuarios similares.\n",
    "\n",
    "    '''\n",
    "    # Verifica si el usuario está presente en las columnas de piv_norm (si no está, devuelve un mensaje)\n",
    "    if user not in piv_norm.columns:\n",
    "        return('No data available on user {}'.format(user))\n",
    "    \n",
    "    # Obtiene los usuarios más similares al usuario dado\n",
    "    sim_users = user_similar.sort_values(by=user, ascending=False).index[1:11]\n",
    "    \n",
    "    best = []  # Lista para almacenar los juegos mejor calificados por usuarios similares\n",
    "    most_common = {}  # Diccionario para contar cuántas veces se recomienda cada juego\n",
    "    \n",
    "    # Para cada usuario similar, encuentra el juego mejor calificado y lo agrega a la lista 'best'\n",
    "    for i in sim_users:\n",
    "        max_score = piv_norm.loc[:, i].max()\n",
    "        best.append(piv_norm[piv_norm.loc[:, i]==max_score].index.tolist())\n",
    "    \n",
    "    # Cuenta cuántas veces se recomienda cada juego\n",
    "    for i in range(len(best)):\n",
    "        for j in best[i]:\n",
    "            if j in most_common:\n",
    "                most_common[j] += 1\n",
    "            else:\n",
    "                most_common[j] = 1\n",
    "    \n",
    "    # Ordena los juegos por la frecuencia de recomendación en orden descendente\n",
    "    sorted_list = sorted(most_common.items(), key=operator.itemgetter(1), reverse=True)\n",
    "    \n",
    "    # Devuelve los 5 juegos más recomendados\n",
    "    return sorted_list[:5]  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[('Call of Duty: World at War', 10),\n",
       " ('Yet Another Zombie Defense', 1),\n",
       " ('Call of Duty: Black Ops', 1),\n",
       " ('Team Fortress Classic', 1),\n",
       " ('They Bleed Pixels', 1)]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# ejemplo\n",
    "similar_user_recs('sharks003')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[('Call of Duty: World at War', 10),\n",
       " ('Yet Another Zombie Defense', 1),\n",
       " ('Call of Duty: Black Ops', 1),\n",
       " ('Company of Heroes 2', 1)]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# ejemplo\n",
    "similar_user_recs('ilovehamstersandbunnies')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Carga de las matrices para recomendar en la API"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Para poder utilizar las funciones **top_users** y **similar_user_recs** es necesario consumir las matrices **piv_norm** y **user_sim_df**. Por ello, se guardan, en este caso, en formato parquet los que permite una compresión y codificación eficiente."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Se guardaron correctamente\n"
     ]
    }
   ],
   "source": [
    "pq.write_table(pa.Table.from_pandas(piv_norm), 'data/11-piv-norm.parquet')\n",
    "pq.write_table(pa.Table.from_pandas(user_similar), 'data/12-user-similar.parquet')\n",
    "pq.write_table(pa.Table.from_pandas(item_similar), 'data/13-item-similar.parquet')\n",
    "print('Se guardaron correctamente')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "def recomendacionJuego(juego):\n",
    "  '''\n",
    "  Esta función muestra una lista de juegos similares a un juego dado.\n",
    "\n",
    "  Parameters:\n",
    "  ----------\n",
    "  juego (str): El nombre del juego para el cual se desean encontrar juegos similares.\n",
    "\n",
    "  Returns:\n",
    "  ----------\n",
    "  juegos_similares: Esta función imprime una lista de juegos 5 similares al dado.\n",
    "\n",
    "  Pasos:\n",
    "  ----------\n",
    "  \n",
    "Verificamos si el juego está en el DataFrame de similitud\n",
    "Obtenemos la lista de juegos similares y mostrarlos\n",
    "Imprimimos la lista de juegos similares\n",
    "\n",
    "  '''\n",
    "\n",
    "  # Paso 1\n",
    "  if juego not in item_similar.index:\n",
    "      print(f'No se encontraron juegos similares para {juego}.')\n",
    "      return\n",
    "\n",
    "  # Paso 2\n",
    "  similar_juegos = item_similar.sort_values(by=juego, ascending=False).index[1:6]  # Mostrar siempre los primeros 5\n",
    "\n",
    "  # Paso 3\n",
    "  juegos_similares = [item for item in similar_juegos]\n",
    "\n",
    "  return juegos_similares\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Tap Heroes',\n",
       " 'Counter-Strike: Condition Zero',\n",
       " 'S.T.A.L.K.E.R.: Call of Pripyat',\n",
       " 'World of Soccer online',\n",
       " 'Hearts of Iron III']"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "recomendacion_juego('Age of Empires II: HD Edition')"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "mlenv",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.12.1"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}