JupyterNotebooks/5 modelo ML.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Modelo de recomendación de juegos\n",
    "\n",
    "# El siguiente modelo de recomendación propone una lista de 5 juegos ingresando el nombre de un juego. Este modelo tiene una relación ítem-ítem, ya que toma un juego y en base a que tan similar es ese juego con el resto de los juegos se recomiendan similares."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\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": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>user_id</th>\n",
       "      <th>item_name</th>\n",
       "      <th>rating</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>76561197970982479</td>\n",
       "      <td>Killing Floor</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>evcentric</td>\n",
       "      <td>Risk of Rain</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>doctr</td>\n",
       "      <td>The Wolf Among Us</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>maplemage</td>\n",
       "      <td>Dark Souls: Prepare to Die Edition</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Wackky</td>\n",
       "      <td>LEGO® MARVEL Super Heroes</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44200</th>\n",
       "      <td>76561198107177722</td>\n",
       "      <td>BattleBlock Theater</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44201</th>\n",
       "      <td>kushikushigani</td>\n",
       "      <td>LEGO® Worlds</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44202</th>\n",
       "      <td>76561198111410893</td>\n",
       "      <td>Unturned</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44203</th>\n",
       "      <td>zaza147</td>\n",
       "      <td>Fistful of Frags</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44204</th>\n",
       "      <td>lifeonhigh</td>\n",
       "      <td>Trove</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>44205 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 user_id                           item_name  rating\n",
       "0      76561197970982479                       Killing Floor       3\n",
       "1              evcentric                        Risk of Rain       5\n",
       "2                  doctr                   The Wolf Among Us       5\n",
       "3              maplemage  Dark Souls: Prepare to Die Edition       3\n",
       "4                 Wackky           LEGO® MARVEL Super Heroes       1\n",
       "...                  ...                                 ...     ...\n",
       "44200  76561198107177722                 BattleBlock Theater       5\n",
       "44201     kushikushigani                        LEGO® Worlds       3\n",
       "44202  76561198111410893                            Unturned       3\n",
       "44203            zaza147                    Fistful of Frags       5\n",
       "44204         lifeonhigh                               Trove       3\n",
       "\n",
       "[44205 rows x 3 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv(\"C:\\\\Users\\\\cquir\\\\OneDrive\\\\Escritorio\\\\Data Science SH\\\\Proyecto Individual 1\\\\bases de datos\\\\df_recomendacion\")\n",
    "df"
   ]
  },
  {
   "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>21168 rows × 2813 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",
       "[21168 rows x 2813 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Creamos un df que contiene los 'user_id' como indices, los juegos ('item_name') como columnas y como valores los ´rating'.\n",
    "piv = df.pivot_table(index=['user_id'], columns=['item_name'], values='rating')\n",
    "piv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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>zombi_anon</th>\n",
       "      <th>zomgCoBfAce</th>\n",
       "      <th>zoom-the-flash</th>\n",
       "      <th>zoozles</th>\n",
       "      <th>zourock</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>2813 rows × 6963 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  ...  zombi_anon  \\\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                                       zomgCoBfAce  zoom-the-flash  \\\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                                       zoozles  zourock  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",
       "[2813 rows x 6963 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Normalizamos los valores del df piv. Esta normalización consiste en una transformación de los datos para que los mismos estén en un rango común (ya que muchas veces los datos están en escalas u ordenes de magnitud muy diferentes), y así no haya predominancia o preponderancia de un tipo de dato sobre el otro. Así, se estandarizan y se reduce el impacto de las diferencias de escala y la magnitud de atributos de los mismos.\n",
    "# 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.\n",
    "\n",
    "# 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",
    "\n",
    "# Se borran las columnas que contienen solo cero o no tienen rating, se rellenan los vacios con 0 y se hace la transpues\n",
    "piv_norm = piv_norm.fillna(0)\n",
    "piv_norm = piv_norm.T\n",
    "piv_norm = piv_norm.loc[:, (piv_norm!=0).any(axis=0)]   #La finalidad de este script es eliminar las columnas que estan completamente llenas de ceros\n",
    "piv_norm"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<2813x6963 sparse matrix of type '<class 'numpy.float64'>'\n",
       "\twith 25039 stored elements in Compressed Sparse Row format>"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# A estos datos se les convierte a un formato de matriz dispersa para reducir la memoria de uso y mejorar la eficiencia en el manejo de grandes conjuntos de datos. Esto, ya que la matriz dispersa 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.\n",
    "piv_sparse = sp.sparse.csr_matrix(piv_norm.values)\n",
    "piv_sparse"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Creamos una matriz de similitud utilizando la similitud del coseno para medir la similitud entre juegos (item_similarity). Esta similitud es usada para determinar cuán similares son dos conjuntos de datos o elementos.\n",
    "item_similarity = cosine_similarity(piv_sparse)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th>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>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>1.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>1.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>1.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>1.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>1.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>1.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>1.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>1.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2813 rows × 2813 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "item_name                                     ! That Bastard Is Trying To Steal Our Gold !  \\\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",
       "item_name                                     0RBITALIS  10,000,000  \\\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         1.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",
       "item_name                                     100% Orange Juice  1001 Spikes  \\\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                                           1.0          0.0   \n",
       "1001 Spikes                                                 0.0          1.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",
       "item_name                                     12 Labours of Hercules  \\\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",
       "item_name                                     12 Labours of Hercules II: The Cretan Bull  \\\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",
       "item_name                                     12 is Better Than 6  140  \\\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",
       "item_name                                     16bit Trader  ...  inMomentum  \\\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",
       "item_name                                     klocki  \\\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",
       "item_name                                     liteCam Game: 100 FPS Game Capture  \\\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",
       "item_name                                      oO  \\\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",
       "item_name                                     planetarian ~the reverie of a little planet~  \\\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",
       "item_name                                     resident evil 4 / biohazard 4  \\\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                                           1.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",
       "item_name                                     sZone-Online  \\\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                                           1.0   \n",
       "the static speaks my name                              0.0   \n",
       "theHunter                                              0.0   \n",
       "theHunter: Primal                                      0.0   \n",
       "\n",
       "item_name                                     the static speaks my name  \\\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                                           1.0   \n",
       "theHunter                                                           0.0   \n",
       "theHunter: Primal                                                   0.0   \n",
       "\n",
       "item_name                                     theHunter  theHunter: Primal  \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                                           1.0                0.0  \n",
       "theHunter: Primal                                   0.0                1.0  \n",
       "\n",
       "[2813 rows x 2813 columns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Para estructurar y organizar los resultados de manera más accesible y comprensible se insertan las matrices anteriores en un Dataframe.\n",
    "item_sim_df = pd.DataFrame(item_similarity, index = piv_norm.index, columns = piv_norm.index)\n",
    "item_sim_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Función de recomendación según un juego\n",
    "\n",
    "# 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_sim_df) 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.\n",
    "\n",
    "def top_game(game):\n",
    "    count = 1\n",
    "    print('juegos similares a {} incluyen:\\n'.format(game))\n",
    "    for item in item_sim_df.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": [
      "juegos similares a Unreal Gold incluyen:\n",
      "\n",
      "No. 1: Killing Floor\n",
      "No. 2: ! That Bastard Is Trying To Steal Our Gold !\n",
      "No. 3: Retrovirus\n",
      "No. 4: Resident Evil Revelations / Biohazard Revelations\n",
      "No. 5: Resident Evil Revelations 2 / Biohazard Revelations 2\n"
     ]
    }
   ],
   "source": [
    "top_game('Unreal Gold') "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "pq.write_table(pa.Table.from_pandas(piv_norm), 'C:\\\\Users\\\\cquir\\\\OneDrive\\\\Escritorio\\\\Data Science SH\\\\Proyecto Individual 1\\\\bases de datos\\\\piv_norm.parquet')\n",
    "pq.write_table(pa.Table.from_pandas(item_sim_df), 'C:\\\\Users\\\\cquir\\\\OneDrive\\\\Escritorio\\\\Data Science SH\\\\Proyecto Individual 1\\\\bases de datos\\\\item_sim_df.parquet')"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": ".venv",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}