dummies_csv.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Importación de bibliotecas necesarias\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import pickle"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Carga de los datos desde archivos CSV\n",
    "df_games = pd.read_csv('dataset\\df_games_limpio.csv')\n",
    "df_userdata = pd.read_csv('datasetAPI\\df_user_data.csv')\n",
    "df_items = pd.read_csv('dataset\\df_items_limpio.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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>user_url</th>\n",
       "      <th>items_count</th>\n",
       "      <th>steam_id</th>\n",
       "      <th>item_id</th>\n",
       "      <th>item_name</th>\n",
       "      <th>playtime_forever</th>\n",
       "      <th>playtime_2weeks</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>76561197970982479</td>\n",
       "      <td>http://steamcommunity.com/profiles/76561197970...</td>\n",
       "      <td>277</td>\n",
       "      <td>76561197970982479</td>\n",
       "      <td>10</td>\n",
       "      <td>counter-strike</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>76561197970982479</td>\n",
       "      <td>http://steamcommunity.com/profiles/76561197970...</td>\n",
       "      <td>277</td>\n",
       "      <td>76561197970982479</td>\n",
       "      <td>20</td>\n",
       "      <td>team fortress classic</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>76561197970982479</td>\n",
       "      <td>http://steamcommunity.com/profiles/76561197970...</td>\n",
       "      <td>277</td>\n",
       "      <td>76561197970982479</td>\n",
       "      <td>30</td>\n",
       "      <td>day of defeat</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>76561197970982479</td>\n",
       "      <td>http://steamcommunity.com/profiles/76561197970...</td>\n",
       "      <td>277</td>\n",
       "      <td>76561197970982479</td>\n",
       "      <td>40</td>\n",
       "      <td>deathmatch classic</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>76561197970982479</td>\n",
       "      <td>http://steamcommunity.com/profiles/76561197970...</td>\n",
       "      <td>277</td>\n",
       "      <td>76561197970982479</td>\n",
       "      <td>50</td>\n",
       "      <td>half-life: opposing force</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             user_id                                           user_url  \\\n",
       "0  76561197970982479  http://steamcommunity.com/profiles/76561197970...   \n",
       "1  76561197970982479  http://steamcommunity.com/profiles/76561197970...   \n",
       "2  76561197970982479  http://steamcommunity.com/profiles/76561197970...   \n",
       "3  76561197970982479  http://steamcommunity.com/profiles/76561197970...   \n",
       "4  76561197970982479  http://steamcommunity.com/profiles/76561197970...   \n",
       "\n",
       "   items_count           steam_id  item_id                  item_name  \\\n",
       "0          277  76561197970982479       10             counter-strike   \n",
       "1          277  76561197970982479       20      team fortress classic   \n",
       "2          277  76561197970982479       30              day of defeat   \n",
       "3          277  76561197970982479       40         deathmatch classic   \n",
       "4          277  76561197970982479       50  half-life: opposing force   \n",
       "\n",
       "   playtime_forever  playtime_2weeks  \n",
       "0                 6                0  \n",
       "1                 0                0  \n",
       "2                 7                0  \n",
       "3                 0                0  \n",
       "4                 0                0  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_items.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "# crear un dataframe que relaciona cada juego con el tiempo total que han invertido sus jugadores en el\n",
    "df_most_played=df_items[['item_id','playtime_forever']].groupby('item_id').sum().reset_index()\n",
    "df_most_played.to_csv('datasetAPI\\most_played_games.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Creación de un diccionario que mapea ID de juegos a géneros\n",
    "id_to_genre = df_games.dropna(subset='id').set_index('id')['genres'].to_dict()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Guardar el diccionario con pickle\n",
    "with open('datasetAPI\\id_to_genre_dict', 'wb') as archivo:\n",
    "    pickle.dump(id_to_genre, archivo)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Función para obtener los géneros de un juego a partir de su ID\n",
    "def get_genres(id):\n",
    "    return id_to_genre.get(id, [])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "id_to_game = df_games.dropna(subset='id').set_index('id')['app_name'].to_dict()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Guardar el diccionario con pickle\n",
    "with open('datasetAPI\\id_to_game_dict', 'wb') as archivo:\n",
    "    pickle.dump(id_to_game, archivo)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Inicialización de una lista para almacenar todos los géneros\n",
    "generos = []"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Iteración a través de los valores de género en el diccionario\n",
    "for value in id_to_genre.values():\n",
    "    # Utiliza la función eval para convertir la cadena de géneros en una lista de Python\n",
    "    generos.extend(eval(value))\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Obtención de la lista de géneros únicos eliminando duplicados\n",
    "generos_unicos=list(set(generos))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['parkour',\n",
       " 'space',\n",
       " 'conspiracy',\n",
       " 'fishing',\n",
       " 'world war ii',\n",
       " 'remake',\n",
       " 'fantasy',\n",
       " 'economy',\n",
       " 'dystopian',\n",
       " 'local co-op',\n",
       " 'time attack',\n",
       " 'trackir',\n",
       " '6dof',\n",
       " 'nudity',\n",
       " 'gamemaker',\n",
       " 'voice control',\n",
       " 'rhythm',\n",
       " 'military',\n",
       " 'linear',\n",
       " 'class-based',\n",
       " 'philisophical',\n",
       " 'psychological',\n",
       " 'relaxing',\n",
       " 'real time tactics',\n",
       " 'dark comedy',\n",
       " 'basketball',\n",
       " 'word game',\n",
       " 'heist',\n",
       " 'western',\n",
       " 'arcade',\n",
       " 'dynamic narration',\n",
       " 'martial arts',\n",
       " 'quick-time events',\n",
       " 'psychedelic',\n",
       " 'top-down shooter',\n",
       " 'exploration',\n",
       " 'casual',\n",
       " 'flight',\n",
       " 'hand-drawn',\n",
       " 'noir',\n",
       " 'choose your own adventure',\n",
       " 'based on a novel',\n",
       " 'third-person shooter',\n",
       " 'dungeon crawler',\n",
       " 'crime',\n",
       " 'horses',\n",
       " 'mars',\n",
       " 'spectacle fighter',\n",
       " 'grand strategy',\n",
       " \"shoot 'em up\",\n",
       " 'competitive',\n",
       " '2d',\n",
       " 'chess',\n",
       " 'steampunk',\n",
       " 'jrpg',\n",
       " 'trading card game',\n",
       " 'fps',\n",
       " 'grid-based movement',\n",
       " 'survival',\n",
       " 'pixel graphics',\n",
       " 'foreign',\n",
       " 'hunting',\n",
       " 'cycling',\n",
       " 'space sim',\n",
       " 'surreal',\n",
       " 'feature film',\n",
       " 'lemmings',\n",
       " 'bullet time',\n",
       " 'sniper',\n",
       " 'abstract',\n",
       " 'demons',\n",
       " 'golf',\n",
       " 'side scroller',\n",
       " 'star wars',\n",
       " 'silent protagonist',\n",
       " 'touch-friendly',\n",
       " 'multiplayer',\n",
       " 'loot',\n",
       " 'tower defense',\n",
       " 'inventory management',\n",
       " 'politics',\n",
       " 'cult classic',\n",
       " 'multiple endings',\n",
       " 'co-op',\n",
       " 'hardware',\n",
       " 'cartoon',\n",
       " 'kickstarter',\n",
       " 'text-based',\n",
       " 'visual novel',\n",
       " 'tanks',\n",
       " 'underwater',\n",
       " 'tactical',\n",
       " 'female protagonist',\n",
       " 'political',\n",
       " 'cartoony',\n",
       " 'world war i',\n",
       " 'mod',\n",
       " 'swordplay',\n",
       " 'soundtrack',\n",
       " 'strategy rpg',\n",
       " 'turn-based strategy',\n",
       " 'fmv',\n",
       " 'free to play',\n",
       " 'moddable',\n",
       " 'mechs',\n",
       " 'singleplayer',\n",
       " 'tutorial',\n",
       " 'post-apocalyptic',\n",
       " 'minimalist',\n",
       " 'turn-based tactics',\n",
       " 'turn-based',\n",
       " 'programming',\n",
       " 'perma death',\n",
       " 'rpgmaker',\n",
       " 'level editor',\n",
       " 'team-based',\n",
       " 'physics',\n",
       " 'investigation',\n",
       " 'moba',\n",
       " 'football',\n",
       " 'board game',\n",
       " 'gore',\n",
       " 'early access',\n",
       " 'batman',\n",
       " 'capitalism',\n",
       " 'story rich',\n",
       " 'god game',\n",
       " 'classic',\n",
       " 'online co-op',\n",
       " 'lore-rich',\n",
       " 'crafting',\n",
       " 'villain protagonist',\n",
       " 'rts',\n",
       " 'local multiplayer',\n",
       " '3d vision',\n",
       " 'tactical rpg',\n",
       " 'base building',\n",
       " 'violent',\n",
       " 'blood',\n",
       " 'party-based rpg',\n",
       " 'war',\n",
       " 'time manipulation',\n",
       " 'puzzle-platformer',\n",
       " 'retro',\n",
       " 'typing',\n",
       " 'procedural generation',\n",
       " 'wargame',\n",
       " 'nsfw',\n",
       " 'indie',\n",
       " 'rome',\n",
       " 'clicker',\n",
       " 'bowling',\n",
       " 'realistic',\n",
       " 'movie',\n",
       " 'mining',\n",
       " 'turn-based combat',\n",
       " 'agriculture',\n",
       " 'zombies',\n",
       " 'mini golf',\n",
       " 'runner',\n",
       " 'photo editing',\n",
       " 'game development',\n",
       " 'pirates',\n",
       " 'illuminati',\n",
       " 'simulation',\n",
       " 'first-person',\n",
       " 'design & illustration',\n",
       " 'cold war',\n",
       " 'fast-paced',\n",
       " 'crpg',\n",
       " 'magic',\n",
       " 'action-adventure',\n",
       " 'funny',\n",
       " 'animation & modeling',\n",
       " 'alternate history',\n",
       " 'pinball',\n",
       " 'driving',\n",
       " 'asynchronous multiplayer',\n",
       " 'family friendly',\n",
       " 'satire',\n",
       " 'wrestling',\n",
       " 'difficult',\n",
       " 'mouse only',\n",
       " 'twin stick shooter',\n",
       " 'hack and slash',\n",
       " 'episodic',\n",
       " 'metroidvania',\n",
       " 'real-time',\n",
       " 'dinosaurs',\n",
       " \"beat 'em up\",\n",
       " 'isometric',\n",
       " 'romance',\n",
       " 'sci-fi',\n",
       " 'destruction',\n",
       " 'america',\n",
       " 'controller',\n",
       " 'action',\n",
       " 'offroad',\n",
       " 'pool',\n",
       " 'split screen',\n",
       " 'shooter',\n",
       " 'racing',\n",
       " 'gothic',\n",
       " 'third person',\n",
       " 'management',\n",
       " 'warhammer 40k',\n",
       " 'crowdfunded',\n",
       " 'voxel',\n",
       " 'documentary',\n",
       " 'medieval',\n",
       " 'score attack',\n",
       " 'software training',\n",
       " 'choices matter',\n",
       " 'mystery',\n",
       " 'pve',\n",
       " 'sexual content',\n",
       " 'faith',\n",
       " 'point & click',\n",
       " 'lovecraftian',\n",
       " 'interactive fiction',\n",
       " 'trains',\n",
       " 'open world',\n",
       " 'sandbox',\n",
       " 'cute',\n",
       " 'intentionally awkward controls',\n",
       " 'replay value',\n",
       " 'dark',\n",
       " '4x',\n",
       " 'mystery dungeon',\n",
       " 'gaming',\n",
       " \"1990's\",\n",
       " 'hacking',\n",
       " 'lego',\n",
       " 'utilities',\n",
       " 'horror',\n",
       " 'rogue-like',\n",
       " 'spelling',\n",
       " 'werewolves',\n",
       " 'real-time with pause',\n",
       " 'survival horror',\n",
       " 'detective',\n",
       " 'bullet hell',\n",
       " 'steam machine',\n",
       " 'benchmark',\n",
       " 'massively multiplayer',\n",
       " 'historical',\n",
       " '4 player local',\n",
       " 'modern',\n",
       " 'vr',\n",
       " 'soccer',\n",
       " 'cinematic',\n",
       " 'nonlinear',\n",
       " 'bikes',\n",
       " 'sokoban',\n",
       " 'narration',\n",
       " 'software',\n",
       " 'supernatural',\n",
       " 'drama',\n",
       " 'character customization',\n",
       " 'dark fantasy',\n",
       " 'hex grid',\n",
       " 'fighting',\n",
       " 'superhero',\n",
       " 'strategy',\n",
       " 'vampire',\n",
       " 'resource management',\n",
       " 'rogue-lite',\n",
       " 'sailing',\n",
       " 'great soundtrack',\n",
       " 'short',\n",
       " 'science',\n",
       " 'time travel',\n",
       " 'stylized',\n",
       " 'adventure',\n",
       " 'video production',\n",
       " 'assassin',\n",
       " '1980s',\n",
       " 'robots',\n",
       " 'comedy',\n",
       " 'naval',\n",
       " 'music-based procedural generation',\n",
       " 'mythology',\n",
       " 'anime',\n",
       " 'parody',\n",
       " 'diplomacy',\n",
       " 'mature',\n",
       " 'education',\n",
       " 'on-rails shooter',\n",
       " 'gun customization',\n",
       " '360 video',\n",
       " 'character action game',\n",
       " 'experience',\n",
       " 'games workshop',\n",
       " 'action rpg',\n",
       " 'puzzle',\n",
       " 'colorful',\n",
       " 'e-sports',\n",
       " '2d fighter',\n",
       " 'mmorpg',\n",
       " 'atmospheric',\n",
       " 'music',\n",
       " 'otome',\n",
       " 'futuristic',\n",
       " 'web publishing',\n",
       " 'match 3',\n",
       " 'dating sim',\n",
       " 'pvp',\n",
       " 'city builder',\n",
       " 'transhumanism',\n",
       " 'dark humor',\n",
       " 'hidden object',\n",
       " 'dragons',\n",
       " 'gambling',\n",
       " 'ninja',\n",
       " 'underground',\n",
       " 'rpg',\n",
       " 'platformer',\n",
       " 'building',\n",
       " 'memes',\n",
       " '3d platformer',\n",
       " 'aliens',\n",
       " 'top-down',\n",
       " 'psychological horror',\n",
       " 'thriller',\n",
       " 'stealth',\n",
       " 'experimental',\n",
       " '2.5d',\n",
       " 'lara croft',\n",
       " 'comic book',\n",
       " 'trading',\n",
       " 'card game',\n",
       " 'co-op campaign',\n",
       " 'arena shooter',\n",
       " 'audio production',\n",
       " 'artificial intelligence',\n",
       " 'sports',\n",
       " 'conversation',\n",
       " 'cyberpunk',\n",
       " 'walking simulator']"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "generos_unicos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Función para convertir géneros en variables dummies en una fila del DataFrame\n",
    "def generos_to_dummies(row):\n",
    "    generos = row['genre']\n",
    "    generos_dict = {genero: 1 if genero in generos else 0 for genero in generos_unicos}\n",
    "    return pd.Series(generos_dict)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Creación de un DataFrame de usuarios e ítems con variables dummies para géneros\n",
    "df_user_items=df_items[['user_id', 'item_id']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\ARTUROS\\AppData\\Local\\Temp\\ipykernel_5088\\490258693.py:2: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  df_user_items['genre']=df_user_items['item_id'].apply(get_genres)\n"
     ]
    }
   ],
   "source": [
    "# Agrega una columna 'genre' al DataFrame de usuarios e ítems\n",
    "df_user_items['genre']=df_user_items['item_id'].apply(get_genres)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Aplicación de la función generos_to_dummies a cada fila del DataFrame\n",
    "df_generos_dummies =df_user_items.apply(generos_to_dummies, axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 229,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Concatenación de los DataFrames de usuarios e ítems y variables dummies\n",
    "df_user_items = pd.concat([df_user_items, df_generos_dummies], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Eliminación de la columna 'item_id' del DataFrame\n",
    "df_user_items=df_user_items.drop('item_id', axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 234,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Agrupación de datos por 'user_id' y cálculo del promedio para obtener preferencias promedio por usuario\n",
    "df_user_items=df_user_items.groupby('user_id').mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 237,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Guardado del DataFrame resultante en un archivo CSV\n",
    "df_user_items.to_csv('dataset/df_user_dummies.csv', index=False)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.4"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}