ETL_Games.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "c1c4d59a",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "4b16a3e1",
   "metadata": {},
   "outputs": [],
   "source": [
    "juegos= pd.read_json(\"games.json\", lines= True) #Abrimos e archivo json"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "ca16be79",
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "juego=juego.drop(['user_id','steam_id','items','items_count'], axis=1) #Tenemos un par de columnas que no son de esta tabla asi que las eliminamos "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "3f7f80c2",
   "metadata": {},
   "outputs": [],
   "source": [
    "juego = juego.dropna(how='all') #Debido a las tablas que habian antes quedaron muchos registros en NaN asi que los eliminamos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "6df87d4a",
   "metadata": {},
   "outputs": [],
   "source": [
    "juego.to_csv('juego_limpio.csv') #Lo transormamos a csv para que sea mas facil la carga"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "f1b209e3",
   "metadata": {},
   "outputs": [],
   "source": [
    "juego=pd.read_csv('juego_limpio.csv',low_memory=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "f15a8a4d",
   "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>publisher</th>\n",
       "      <th>genres</th>\n",
       "      <th>app_name</th>\n",
       "      <th>title</th>\n",
       "      <th>url</th>\n",
       "      <th>release_date</th>\n",
       "      <th>tags</th>\n",
       "      <th>reviews_url</th>\n",
       "      <th>discount_price</th>\n",
       "      <th>specs</th>\n",
       "      <th>price</th>\n",
       "      <th>early_access</th>\n",
       "      <th>id</th>\n",
       "      <th>metascore</th>\n",
       "      <th>developer</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Kotoshiro</td>\n",
       "      <td>['Action', 'Casual', 'Indie', 'Simulation', 'S...</td>\n",
       "      <td>Lost Summoner Kitty</td>\n",
       "      <td>Lost Summoner Kitty</td>\n",
       "      <td>http://store.steampowered.com/app/761140/Lost_...</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>['Strategy', 'Action', 'Indie', 'Casual', 'Sim...</td>\n",
       "      <td>http://steamcommunity.com/app/761140/reviews/?...</td>\n",
       "      <td>4.49</td>\n",
       "      <td>['Single-player']</td>\n",
       "      <td>4.99</td>\n",
       "      <td>False</td>\n",
       "      <td>761140.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kotoshiro</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Making Fun, Inc.</td>\n",
       "      <td>['Free to Play', 'Indie', 'RPG', 'Strategy']</td>\n",
       "      <td>Ironbound</td>\n",
       "      <td>Ironbound</td>\n",
       "      <td>http://store.steampowered.com/app/643980/Ironb...</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>['Free to Play', 'Strategy', 'Indie', 'RPG', '...</td>\n",
       "      <td>http://steamcommunity.com/app/643980/reviews/?...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Single-player', 'Multi-player', 'Online Mult...</td>\n",
       "      <td>Free To Play</td>\n",
       "      <td>False</td>\n",
       "      <td>643980.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Secret Level SRL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Poolians.com</td>\n",
       "      <td>['Casual', 'Free to Play', 'Indie', 'Simulatio...</td>\n",
       "      <td>Real Pool 3D - Poolians</td>\n",
       "      <td>Real Pool 3D - Poolians</td>\n",
       "      <td>http://store.steampowered.com/app/670290/Real_...</td>\n",
       "      <td>2017-07-24</td>\n",
       "      <td>['Free to Play', 'Simulation', 'Sports', 'Casu...</td>\n",
       "      <td>http://steamcommunity.com/app/670290/reviews/?...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Single-player', 'Multi-player', 'Online Mult...</td>\n",
       "      <td>Free to Play</td>\n",
       "      <td>False</td>\n",
       "      <td>670290.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Poolians.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>彼岸领域</td>\n",
       "      <td>['Action', 'Adventure', 'Casual']</td>\n",
       "      <td>弹炸人2222</td>\n",
       "      <td>弹炸人2222</td>\n",
       "      <td>http://store.steampowered.com/app/767400/2222/</td>\n",
       "      <td>2017-12-07</td>\n",
       "      <td>['Action', 'Adventure', 'Casual']</td>\n",
       "      <td>http://steamcommunity.com/app/767400/reviews/?...</td>\n",
       "      <td>0.83</td>\n",
       "      <td>['Single-player']</td>\n",
       "      <td>0.99</td>\n",
       "      <td>False</td>\n",
       "      <td>767400.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>彼岸领域</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Log Challenge</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://store.steampowered.com/app/773570/Log_C...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Action', 'Indie', 'Casual', 'Sports']</td>\n",
       "      <td>http://steamcommunity.com/app/773570/reviews/?...</td>\n",
       "      <td>1.79</td>\n",
       "      <td>['Single-player', 'Full controller support', '...</td>\n",
       "      <td>2.99</td>\n",
       "      <td>False</td>\n",
       "      <td>773570.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          publisher                                             genres  \\\n",
       "0         Kotoshiro  ['Action', 'Casual', 'Indie', 'Simulation', 'S...   \n",
       "1  Making Fun, Inc.       ['Free to Play', 'Indie', 'RPG', 'Strategy']   \n",
       "2      Poolians.com  ['Casual', 'Free to Play', 'Indie', 'Simulatio...   \n",
       "3              彼岸领域                  ['Action', 'Adventure', 'Casual']   \n",
       "4               NaN                                                NaN   \n",
       "\n",
       "                  app_name                    title  \\\n",
       "0      Lost Summoner Kitty      Lost Summoner Kitty   \n",
       "1                Ironbound                Ironbound   \n",
       "2  Real Pool 3D - Poolians  Real Pool 3D - Poolians   \n",
       "3                  弹炸人2222                  弹炸人2222   \n",
       "4            Log Challenge                      NaN   \n",
       "\n",
       "                                                 url release_date  \\\n",
       "0  http://store.steampowered.com/app/761140/Lost_...   2018-01-04   \n",
       "1  http://store.steampowered.com/app/643980/Ironb...   2018-01-04   \n",
       "2  http://store.steampowered.com/app/670290/Real_...   2017-07-24   \n",
       "3     http://store.steampowered.com/app/767400/2222/   2017-12-07   \n",
       "4  http://store.steampowered.com/app/773570/Log_C...          NaN   \n",
       "\n",
       "                                                tags  \\\n",
       "0  ['Strategy', 'Action', 'Indie', 'Casual', 'Sim...   \n",
       "1  ['Free to Play', 'Strategy', 'Indie', 'RPG', '...   \n",
       "2  ['Free to Play', 'Simulation', 'Sports', 'Casu...   \n",
       "3                  ['Action', 'Adventure', 'Casual']   \n",
       "4            ['Action', 'Indie', 'Casual', 'Sports']   \n",
       "\n",
       "                                         reviews_url  discount_price  \\\n",
       "0  http://steamcommunity.com/app/761140/reviews/?...            4.49   \n",
       "1  http://steamcommunity.com/app/643980/reviews/?...             NaN   \n",
       "2  http://steamcommunity.com/app/670290/reviews/?...             NaN   \n",
       "3  http://steamcommunity.com/app/767400/reviews/?...            0.83   \n",
       "4  http://steamcommunity.com/app/773570/reviews/?...            1.79   \n",
       "\n",
       "                                               specs         price  \\\n",
       "0                                  ['Single-player']          4.99   \n",
       "1  ['Single-player', 'Multi-player', 'Online Mult...  Free To Play   \n",
       "2  ['Single-player', 'Multi-player', 'Online Mult...  Free to Play   \n",
       "3                                  ['Single-player']          0.99   \n",
       "4  ['Single-player', 'Full controller support', '...          2.99   \n",
       "\n",
       "   early_access        id  metascore         developer  \n",
       "0         False  761140.0        NaN         Kotoshiro  \n",
       "1         False  643980.0        NaN  Secret Level SRL  \n",
       "2         False  670290.0        NaN      Poolians.com  \n",
       "3         False  767400.0        NaN              彼岸领域  \n",
       "4         False  773570.0        NaN               NaN  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "juego.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ca967f07",
   "metadata": {},
   "source": [
    "Aqui comenzamos a desanidar la columna generos que es la que nos va a servir para los endpoints de la API"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "0274d200",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(32135, 15)"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "juego.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "1a3ed20e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "\"['Free to Play', 'Indie', 'RPG', 'Strategy']\""
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "juego['genres'][1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "f98f080d",
   "metadata": {},
   "outputs": [],
   "source": [
    "juego['genres']= juego['genres'].str.split(',') #Separamos los generos dentro del registro"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "d3d0ef9c",
   "metadata": {},
   "outputs": [],
   "source": [
    "juego=juego.explode('genres', ignore_index=True) #Hacemos que se multipliquen los registros y en vez de quedar un registro con 2 o mas generos queda un registro del juego por cada genero"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "fa00e03d",
   "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>publisher</th>\n",
       "      <th>genres</th>\n",
       "      <th>app_name</th>\n",
       "      <th>title</th>\n",
       "      <th>url</th>\n",
       "      <th>release_date</th>\n",
       "      <th>tags</th>\n",
       "      <th>reviews_url</th>\n",
       "      <th>discount_price</th>\n",
       "      <th>specs</th>\n",
       "      <th>price</th>\n",
       "      <th>early_access</th>\n",
       "      <th>id</th>\n",
       "      <th>metascore</th>\n",
       "      <th>developer</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Kotoshiro</td>\n",
       "      <td>['Action'</td>\n",
       "      <td>Lost Summoner Kitty</td>\n",
       "      <td>Lost Summoner Kitty</td>\n",
       "      <td>http://store.steampowered.com/app/761140/Lost_...</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>['Strategy', 'Action', 'Indie', 'Casual', 'Sim...</td>\n",
       "      <td>http://steamcommunity.com/app/761140/reviews/?...</td>\n",
       "      <td>4.49</td>\n",
       "      <td>['Single-player']</td>\n",
       "      <td>4.99</td>\n",
       "      <td>False</td>\n",
       "      <td>761140.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kotoshiro</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Kotoshiro</td>\n",
       "      <td>'Casual'</td>\n",
       "      <td>Lost Summoner Kitty</td>\n",
       "      <td>Lost Summoner Kitty</td>\n",
       "      <td>http://store.steampowered.com/app/761140/Lost_...</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>['Strategy', 'Action', 'Indie', 'Casual', 'Sim...</td>\n",
       "      <td>http://steamcommunity.com/app/761140/reviews/?...</td>\n",
       "      <td>4.49</td>\n",
       "      <td>['Single-player']</td>\n",
       "      <td>4.99</td>\n",
       "      <td>False</td>\n",
       "      <td>761140.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kotoshiro</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Kotoshiro</td>\n",
       "      <td>'Indie'</td>\n",
       "      <td>Lost Summoner Kitty</td>\n",
       "      <td>Lost Summoner Kitty</td>\n",
       "      <td>http://store.steampowered.com/app/761140/Lost_...</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>['Strategy', 'Action', 'Indie', 'Casual', 'Sim...</td>\n",
       "      <td>http://steamcommunity.com/app/761140/reviews/?...</td>\n",
       "      <td>4.49</td>\n",
       "      <td>['Single-player']</td>\n",
       "      <td>4.99</td>\n",
       "      <td>False</td>\n",
       "      <td>761140.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kotoshiro</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Kotoshiro</td>\n",
       "      <td>'Simulation'</td>\n",
       "      <td>Lost Summoner Kitty</td>\n",
       "      <td>Lost Summoner Kitty</td>\n",
       "      <td>http://store.steampowered.com/app/761140/Lost_...</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>['Strategy', 'Action', 'Indie', 'Casual', 'Sim...</td>\n",
       "      <td>http://steamcommunity.com/app/761140/reviews/?...</td>\n",
       "      <td>4.49</td>\n",
       "      <td>['Single-player']</td>\n",
       "      <td>4.99</td>\n",
       "      <td>False</td>\n",
       "      <td>761140.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kotoshiro</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Kotoshiro</td>\n",
       "      <td>'Strategy']</td>\n",
       "      <td>Lost Summoner Kitty</td>\n",
       "      <td>Lost Summoner Kitty</td>\n",
       "      <td>http://store.steampowered.com/app/761140/Lost_...</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>['Strategy', 'Action', 'Indie', 'Casual', 'Sim...</td>\n",
       "      <td>http://steamcommunity.com/app/761140/reviews/?...</td>\n",
       "      <td>4.49</td>\n",
       "      <td>['Single-player']</td>\n",
       "      <td>4.99</td>\n",
       "      <td>False</td>\n",
       "      <td>761140.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kotoshiro</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Making Fun, Inc.</td>\n",
       "      <td>['Free to Play'</td>\n",
       "      <td>Ironbound</td>\n",
       "      <td>Ironbound</td>\n",
       "      <td>http://store.steampowered.com/app/643980/Ironb...</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>['Free to Play', 'Strategy', 'Indie', 'RPG', '...</td>\n",
       "      <td>http://steamcommunity.com/app/643980/reviews/?...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Single-player', 'Multi-player', 'Online Mult...</td>\n",
       "      <td>Free To Play</td>\n",
       "      <td>False</td>\n",
       "      <td>643980.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Secret Level SRL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Making Fun, Inc.</td>\n",
       "      <td>'Indie'</td>\n",
       "      <td>Ironbound</td>\n",
       "      <td>Ironbound</td>\n",
       "      <td>http://store.steampowered.com/app/643980/Ironb...</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>['Free to Play', 'Strategy', 'Indie', 'RPG', '...</td>\n",
       "      <td>http://steamcommunity.com/app/643980/reviews/?...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Single-player', 'Multi-player', 'Online Mult...</td>\n",
       "      <td>Free To Play</td>\n",
       "      <td>False</td>\n",
       "      <td>643980.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Secret Level SRL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Making Fun, Inc.</td>\n",
       "      <td>'RPG'</td>\n",
       "      <td>Ironbound</td>\n",
       "      <td>Ironbound</td>\n",
       "      <td>http://store.steampowered.com/app/643980/Ironb...</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>['Free to Play', 'Strategy', 'Indie', 'RPG', '...</td>\n",
       "      <td>http://steamcommunity.com/app/643980/reviews/?...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Single-player', 'Multi-player', 'Online Mult...</td>\n",
       "      <td>Free To Play</td>\n",
       "      <td>False</td>\n",
       "      <td>643980.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Secret Level SRL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Making Fun, Inc.</td>\n",
       "      <td>'Strategy']</td>\n",
       "      <td>Ironbound</td>\n",
       "      <td>Ironbound</td>\n",
       "      <td>http://store.steampowered.com/app/643980/Ironb...</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>['Free to Play', 'Strategy', 'Indie', 'RPG', '...</td>\n",
       "      <td>http://steamcommunity.com/app/643980/reviews/?...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Single-player', 'Multi-player', 'Online Mult...</td>\n",
       "      <td>Free To Play</td>\n",
       "      <td>False</td>\n",
       "      <td>643980.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Secret Level SRL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Poolians.com</td>\n",
       "      <td>['Casual'</td>\n",
       "      <td>Real Pool 3D - Poolians</td>\n",
       "      <td>Real Pool 3D - Poolians</td>\n",
       "      <td>http://store.steampowered.com/app/670290/Real_...</td>\n",
       "      <td>2017-07-24</td>\n",
       "      <td>['Free to Play', 'Simulation', 'Sports', 'Casu...</td>\n",
       "      <td>http://steamcommunity.com/app/670290/reviews/?...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Single-player', 'Multi-player', 'Online Mult...</td>\n",
       "      <td>Free to Play</td>\n",
       "      <td>False</td>\n",
       "      <td>670290.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Poolians.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Poolians.com</td>\n",
       "      <td>'Free to Play'</td>\n",
       "      <td>Real Pool 3D - Poolians</td>\n",
       "      <td>Real Pool 3D - Poolians</td>\n",
       "      <td>http://store.steampowered.com/app/670290/Real_...</td>\n",
       "      <td>2017-07-24</td>\n",
       "      <td>['Free to Play', 'Simulation', 'Sports', 'Casu...</td>\n",
       "      <td>http://steamcommunity.com/app/670290/reviews/?...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Single-player', 'Multi-player', 'Online Mult...</td>\n",
       "      <td>Free to Play</td>\n",
       "      <td>False</td>\n",
       "      <td>670290.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Poolians.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Poolians.com</td>\n",
       "      <td>'Indie'</td>\n",
       "      <td>Real Pool 3D - Poolians</td>\n",
       "      <td>Real Pool 3D - Poolians</td>\n",
       "      <td>http://store.steampowered.com/app/670290/Real_...</td>\n",
       "      <td>2017-07-24</td>\n",
       "      <td>['Free to Play', 'Simulation', 'Sports', 'Casu...</td>\n",
       "      <td>http://steamcommunity.com/app/670290/reviews/?...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Single-player', 'Multi-player', 'Online Mult...</td>\n",
       "      <td>Free to Play</td>\n",
       "      <td>False</td>\n",
       "      <td>670290.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Poolians.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Poolians.com</td>\n",
       "      <td>'Simulation'</td>\n",
       "      <td>Real Pool 3D - Poolians</td>\n",
       "      <td>Real Pool 3D - Poolians</td>\n",
       "      <td>http://store.steampowered.com/app/670290/Real_...</td>\n",
       "      <td>2017-07-24</td>\n",
       "      <td>['Free to Play', 'Simulation', 'Sports', 'Casu...</td>\n",
       "      <td>http://steamcommunity.com/app/670290/reviews/?...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Single-player', 'Multi-player', 'Online Mult...</td>\n",
       "      <td>Free to Play</td>\n",
       "      <td>False</td>\n",
       "      <td>670290.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Poolians.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Poolians.com</td>\n",
       "      <td>'Sports']</td>\n",
       "      <td>Real Pool 3D - Poolians</td>\n",
       "      <td>Real Pool 3D - Poolians</td>\n",
       "      <td>http://store.steampowered.com/app/670290/Real_...</td>\n",
       "      <td>2017-07-24</td>\n",
       "      <td>['Free to Play', 'Simulation', 'Sports', 'Casu...</td>\n",
       "      <td>http://steamcommunity.com/app/670290/reviews/?...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Single-player', 'Multi-player', 'Online Mult...</td>\n",
       "      <td>Free to Play</td>\n",
       "      <td>False</td>\n",
       "      <td>670290.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Poolians.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>彼岸领域</td>\n",
       "      <td>['Action'</td>\n",
       "      <td>弹炸人2222</td>\n",
       "      <td>弹炸人2222</td>\n",
       "      <td>http://store.steampowered.com/app/767400/2222/</td>\n",
       "      <td>2017-12-07</td>\n",
       "      <td>['Action', 'Adventure', 'Casual']</td>\n",
       "      <td>http://steamcommunity.com/app/767400/reviews/?...</td>\n",
       "      <td>0.83</td>\n",
       "      <td>['Single-player']</td>\n",
       "      <td>0.99</td>\n",
       "      <td>False</td>\n",
       "      <td>767400.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>彼岸领域</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>彼岸领域</td>\n",
       "      <td>'Adventure'</td>\n",
       "      <td>弹炸人2222</td>\n",
       "      <td>弹炸人2222</td>\n",
       "      <td>http://store.steampowered.com/app/767400/2222/</td>\n",
       "      <td>2017-12-07</td>\n",
       "      <td>['Action', 'Adventure', 'Casual']</td>\n",
       "      <td>http://steamcommunity.com/app/767400/reviews/?...</td>\n",
       "      <td>0.83</td>\n",
       "      <td>['Single-player']</td>\n",
       "      <td>0.99</td>\n",
       "      <td>False</td>\n",
       "      <td>767400.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>彼岸领域</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>彼岸领域</td>\n",
       "      <td>'Casual']</td>\n",
       "      <td>弹炸人2222</td>\n",
       "      <td>弹炸人2222</td>\n",
       "      <td>http://store.steampowered.com/app/767400/2222/</td>\n",
       "      <td>2017-12-07</td>\n",
       "      <td>['Action', 'Adventure', 'Casual']</td>\n",
       "      <td>http://steamcommunity.com/app/767400/reviews/?...</td>\n",
       "      <td>0.83</td>\n",
       "      <td>['Single-player']</td>\n",
       "      <td>0.99</td>\n",
       "      <td>False</td>\n",
       "      <td>767400.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>彼岸领域</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Log Challenge</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://store.steampowered.com/app/773570/Log_C...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Action', 'Indie', 'Casual', 'Sports']</td>\n",
       "      <td>http://steamcommunity.com/app/773570/reviews/?...</td>\n",
       "      <td>1.79</td>\n",
       "      <td>['Single-player', 'Full controller support', '...</td>\n",
       "      <td>2.99</td>\n",
       "      <td>False</td>\n",
       "      <td>773570.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Trickjump Games Ltd</td>\n",
       "      <td>['Action'</td>\n",
       "      <td>Battle Royale Trainer</td>\n",
       "      <td>Battle Royale Trainer</td>\n",
       "      <td>http://store.steampowered.com/app/772540/Battl...</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>['Action', 'Adventure', 'Simulation', 'FPS', '...</td>\n",
       "      <td>http://steamcommunity.com/app/772540/reviews/?...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Single-player', 'Steam Achievements']</td>\n",
       "      <td>3.99</td>\n",
       "      <td>False</td>\n",
       "      <td>772540.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Trickjump Games Ltd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Trickjump Games Ltd</td>\n",
       "      <td>'Adventure'</td>\n",
       "      <td>Battle Royale Trainer</td>\n",
       "      <td>Battle Royale Trainer</td>\n",
       "      <td>http://store.steampowered.com/app/772540/Battl...</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>['Action', 'Adventure', 'Simulation', 'FPS', '...</td>\n",
       "      <td>http://steamcommunity.com/app/772540/reviews/?...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Single-player', 'Steam Achievements']</td>\n",
       "      <td>3.99</td>\n",
       "      <td>False</td>\n",
       "      <td>772540.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Trickjump Games Ltd</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              publisher           genres                 app_name  \\\n",
       "0             Kotoshiro        ['Action'      Lost Summoner Kitty   \n",
       "1             Kotoshiro         'Casual'      Lost Summoner Kitty   \n",
       "2             Kotoshiro          'Indie'      Lost Summoner Kitty   \n",
       "3             Kotoshiro     'Simulation'      Lost Summoner Kitty   \n",
       "4             Kotoshiro      'Strategy']      Lost Summoner Kitty   \n",
       "5      Making Fun, Inc.  ['Free to Play'                Ironbound   \n",
       "6      Making Fun, Inc.          'Indie'                Ironbound   \n",
       "7      Making Fun, Inc.            'RPG'                Ironbound   \n",
       "8      Making Fun, Inc.      'Strategy']                Ironbound   \n",
       "9          Poolians.com        ['Casual'  Real Pool 3D - Poolians   \n",
       "10         Poolians.com   'Free to Play'  Real Pool 3D - Poolians   \n",
       "11         Poolians.com          'Indie'  Real Pool 3D - Poolians   \n",
       "12         Poolians.com     'Simulation'  Real Pool 3D - Poolians   \n",
       "13         Poolians.com        'Sports']  Real Pool 3D - Poolians   \n",
       "14                 彼岸领域        ['Action'                  弹炸人2222   \n",
       "15                 彼岸领域      'Adventure'                  弹炸人2222   \n",
       "16                 彼岸领域        'Casual']                  弹炸人2222   \n",
       "17                  NaN              NaN            Log Challenge   \n",
       "18  Trickjump Games Ltd        ['Action'    Battle Royale Trainer   \n",
       "19  Trickjump Games Ltd      'Adventure'    Battle Royale Trainer   \n",
       "\n",
       "                      title  \\\n",
       "0       Lost Summoner Kitty   \n",
       "1       Lost Summoner Kitty   \n",
       "2       Lost Summoner Kitty   \n",
       "3       Lost Summoner Kitty   \n",
       "4       Lost Summoner Kitty   \n",
       "5                 Ironbound   \n",
       "6                 Ironbound   \n",
       "7                 Ironbound   \n",
       "8                 Ironbound   \n",
       "9   Real Pool 3D - Poolians   \n",
       "10  Real Pool 3D - Poolians   \n",
       "11  Real Pool 3D - Poolians   \n",
       "12  Real Pool 3D - Poolians   \n",
       "13  Real Pool 3D - Poolians   \n",
       "14                  弹炸人2222   \n",
       "15                  弹炸人2222   \n",
       "16                  弹炸人2222   \n",
       "17                      NaN   \n",
       "18    Battle Royale Trainer   \n",
       "19    Battle Royale Trainer   \n",
       "\n",
       "                                                  url release_date  \\\n",
       "0   http://store.steampowered.com/app/761140/Lost_...   2018-01-04   \n",
       "1   http://store.steampowered.com/app/761140/Lost_...   2018-01-04   \n",
       "2   http://store.steampowered.com/app/761140/Lost_...   2018-01-04   \n",
       "3   http://store.steampowered.com/app/761140/Lost_...   2018-01-04   \n",
       "4   http://store.steampowered.com/app/761140/Lost_...   2018-01-04   \n",
       "5   http://store.steampowered.com/app/643980/Ironb...   2018-01-04   \n",
       "6   http://store.steampowered.com/app/643980/Ironb...   2018-01-04   \n",
       "7   http://store.steampowered.com/app/643980/Ironb...   2018-01-04   \n",
       "8   http://store.steampowered.com/app/643980/Ironb...   2018-01-04   \n",
       "9   http://store.steampowered.com/app/670290/Real_...   2017-07-24   \n",
       "10  http://store.steampowered.com/app/670290/Real_...   2017-07-24   \n",
       "11  http://store.steampowered.com/app/670290/Real_...   2017-07-24   \n",
       "12  http://store.steampowered.com/app/670290/Real_...   2017-07-24   \n",
       "13  http://store.steampowered.com/app/670290/Real_...   2017-07-24   \n",
       "14     http://store.steampowered.com/app/767400/2222/   2017-12-07   \n",
       "15     http://store.steampowered.com/app/767400/2222/   2017-12-07   \n",
       "16     http://store.steampowered.com/app/767400/2222/   2017-12-07   \n",
       "17  http://store.steampowered.com/app/773570/Log_C...          NaN   \n",
       "18  http://store.steampowered.com/app/772540/Battl...   2018-01-04   \n",
       "19  http://store.steampowered.com/app/772540/Battl...   2018-01-04   \n",
       "\n",
       "                                                 tags  \\\n",
       "0   ['Strategy', 'Action', 'Indie', 'Casual', 'Sim...   \n",
       "1   ['Strategy', 'Action', 'Indie', 'Casual', 'Sim...   \n",
       "2   ['Strategy', 'Action', 'Indie', 'Casual', 'Sim...   \n",
       "3   ['Strategy', 'Action', 'Indie', 'Casual', 'Sim...   \n",
       "4   ['Strategy', 'Action', 'Indie', 'Casual', 'Sim...   \n",
       "5   ['Free to Play', 'Strategy', 'Indie', 'RPG', '...   \n",
       "6   ['Free to Play', 'Strategy', 'Indie', 'RPG', '...   \n",
       "7   ['Free to Play', 'Strategy', 'Indie', 'RPG', '...   \n",
       "8   ['Free to Play', 'Strategy', 'Indie', 'RPG', '...   \n",
       "9   ['Free to Play', 'Simulation', 'Sports', 'Casu...   \n",
       "10  ['Free to Play', 'Simulation', 'Sports', 'Casu...   \n",
       "11  ['Free to Play', 'Simulation', 'Sports', 'Casu...   \n",
       "12  ['Free to Play', 'Simulation', 'Sports', 'Casu...   \n",
       "13  ['Free to Play', 'Simulation', 'Sports', 'Casu...   \n",
       "14                  ['Action', 'Adventure', 'Casual']   \n",
       "15                  ['Action', 'Adventure', 'Casual']   \n",
       "16                  ['Action', 'Adventure', 'Casual']   \n",
       "17            ['Action', 'Indie', 'Casual', 'Sports']   \n",
       "18  ['Action', 'Adventure', 'Simulation', 'FPS', '...   \n",
       "19  ['Action', 'Adventure', 'Simulation', 'FPS', '...   \n",
       "\n",
       "                                          reviews_url  discount_price  \\\n",
       "0   http://steamcommunity.com/app/761140/reviews/?...            4.49   \n",
       "1   http://steamcommunity.com/app/761140/reviews/?...            4.49   \n",
       "2   http://steamcommunity.com/app/761140/reviews/?...            4.49   \n",
       "3   http://steamcommunity.com/app/761140/reviews/?...            4.49   \n",
       "4   http://steamcommunity.com/app/761140/reviews/?...            4.49   \n",
       "5   http://steamcommunity.com/app/643980/reviews/?...             NaN   \n",
       "6   http://steamcommunity.com/app/643980/reviews/?...             NaN   \n",
       "7   http://steamcommunity.com/app/643980/reviews/?...             NaN   \n",
       "8   http://steamcommunity.com/app/643980/reviews/?...             NaN   \n",
       "9   http://steamcommunity.com/app/670290/reviews/?...             NaN   \n",
       "10  http://steamcommunity.com/app/670290/reviews/?...             NaN   \n",
       "11  http://steamcommunity.com/app/670290/reviews/?...             NaN   \n",
       "12  http://steamcommunity.com/app/670290/reviews/?...             NaN   \n",
       "13  http://steamcommunity.com/app/670290/reviews/?...             NaN   \n",
       "14  http://steamcommunity.com/app/767400/reviews/?...            0.83   \n",
       "15  http://steamcommunity.com/app/767400/reviews/?...            0.83   \n",
       "16  http://steamcommunity.com/app/767400/reviews/?...            0.83   \n",
       "17  http://steamcommunity.com/app/773570/reviews/?...            1.79   \n",
       "18  http://steamcommunity.com/app/772540/reviews/?...             NaN   \n",
       "19  http://steamcommunity.com/app/772540/reviews/?...             NaN   \n",
       "\n",
       "                                                specs         price  \\\n",
       "0                                   ['Single-player']          4.99   \n",
       "1                                   ['Single-player']          4.99   \n",
       "2                                   ['Single-player']          4.99   \n",
       "3                                   ['Single-player']          4.99   \n",
       "4                                   ['Single-player']          4.99   \n",
       "5   ['Single-player', 'Multi-player', 'Online Mult...  Free To Play   \n",
       "6   ['Single-player', 'Multi-player', 'Online Mult...  Free To Play   \n",
       "7   ['Single-player', 'Multi-player', 'Online Mult...  Free To Play   \n",
       "8   ['Single-player', 'Multi-player', 'Online Mult...  Free To Play   \n",
       "9   ['Single-player', 'Multi-player', 'Online Mult...  Free to Play   \n",
       "10  ['Single-player', 'Multi-player', 'Online Mult...  Free to Play   \n",
       "11  ['Single-player', 'Multi-player', 'Online Mult...  Free to Play   \n",
       "12  ['Single-player', 'Multi-player', 'Online Mult...  Free to Play   \n",
       "13  ['Single-player', 'Multi-player', 'Online Mult...  Free to Play   \n",
       "14                                  ['Single-player']          0.99   \n",
       "15                                  ['Single-player']          0.99   \n",
       "16                                  ['Single-player']          0.99   \n",
       "17  ['Single-player', 'Full controller support', '...          2.99   \n",
       "18            ['Single-player', 'Steam Achievements']          3.99   \n",
       "19            ['Single-player', 'Steam Achievements']          3.99   \n",
       "\n",
       "    early_access        id  metascore            developer  \n",
       "0          False  761140.0        NaN            Kotoshiro  \n",
       "1          False  761140.0        NaN            Kotoshiro  \n",
       "2          False  761140.0        NaN            Kotoshiro  \n",
       "3          False  761140.0        NaN            Kotoshiro  \n",
       "4          False  761140.0        NaN            Kotoshiro  \n",
       "5          False  643980.0        NaN     Secret Level SRL  \n",
       "6          False  643980.0        NaN     Secret Level SRL  \n",
       "7          False  643980.0        NaN     Secret Level SRL  \n",
       "8          False  643980.0        NaN     Secret Level SRL  \n",
       "9          False  670290.0        NaN         Poolians.com  \n",
       "10         False  670290.0        NaN         Poolians.com  \n",
       "11         False  670290.0        NaN         Poolians.com  \n",
       "12         False  670290.0        NaN         Poolians.com  \n",
       "13         False  670290.0        NaN         Poolians.com  \n",
       "14         False  767400.0        NaN                 彼岸领域  \n",
       "15         False  767400.0        NaN                 彼岸领域  \n",
       "16         False  767400.0        NaN                 彼岸领域  \n",
       "17         False  773570.0        NaN                  NaN  \n",
       "18         False  772540.0        NaN  Trickjump Games Ltd  \n",
       "19         False  772540.0        NaN  Trickjump Games Ltd  "
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "juego.head(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "bb1d6c29",
   "metadata": {},
   "outputs": [],
   "source": [
    "juego['genres'] = juego['genres'].str.replace(\"[\", \" \") #Aqui comenzamos a limpiar los textos una vez ya estan separados"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "748b20da",
   "metadata": {},
   "outputs": [],
   "source": [
    "juego['genres'] = juego['genres'].str.replace(\"]\", \" \")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "aef097dd",
   "metadata": {},
   "outputs": [],
   "source": [
    "juego['genres'] = juego['genres'].str.replace(\",\", \" \")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "c59757c8",
   "metadata": {},
   "outputs": [],
   "source": [
    "columnas_a_eliminar = ['url', 'tags', 'reviews_url','discount_price','specs','price','early_access','metascore','developer']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "253dbe53",
   "metadata": {},
   "outputs": [],
   "source": [
    "juego = juego.drop(columnas_a_eliminar, axis=1) #Eliminamos las columnas que no me interesan"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "17ba4193",
   "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>publisher</th>\n",
       "      <th>genres</th>\n",
       "      <th>app_name</th>\n",
       "      <th>title</th>\n",
       "      <th>release_date</th>\n",
       "      <th>id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Kotoshiro</td>\n",
       "      <td>'Action'</td>\n",
       "      <td>Lost Summoner Kitty</td>\n",
       "      <td>Lost Summoner Kitty</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>761140.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Kotoshiro</td>\n",
       "      <td>'Casual'</td>\n",
       "      <td>Lost Summoner Kitty</td>\n",
       "      <td>Lost Summoner Kitty</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>761140.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Kotoshiro</td>\n",
       "      <td>'Indie'</td>\n",
       "      <td>Lost Summoner Kitty</td>\n",
       "      <td>Lost Summoner Kitty</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>761140.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Kotoshiro</td>\n",
       "      <td>'Simulation'</td>\n",
       "      <td>Lost Summoner Kitty</td>\n",
       "      <td>Lost Summoner Kitty</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>761140.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Kotoshiro</td>\n",
       "      <td>'Strategy'</td>\n",
       "      <td>Lost Summoner Kitty</td>\n",
       "      <td>Lost Summoner Kitty</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>761140.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Making Fun, Inc.</td>\n",
       "      <td>'Free to Play'</td>\n",
       "      <td>Ironbound</td>\n",
       "      <td>Ironbound</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>643980.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Making Fun, Inc.</td>\n",
       "      <td>'Indie'</td>\n",
       "      <td>Ironbound</td>\n",
       "      <td>Ironbound</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>643980.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Making Fun, Inc.</td>\n",
       "      <td>'RPG'</td>\n",
       "      <td>Ironbound</td>\n",
       "      <td>Ironbound</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>643980.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Making Fun, Inc.</td>\n",
       "      <td>'Strategy'</td>\n",
       "      <td>Ironbound</td>\n",
       "      <td>Ironbound</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>643980.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Poolians.com</td>\n",
       "      <td>'Casual'</td>\n",
       "      <td>Real Pool 3D - Poolians</td>\n",
       "      <td>Real Pool 3D - Poolians</td>\n",
       "      <td>2017-07-24</td>\n",
       "      <td>670290.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Poolians.com</td>\n",
       "      <td>'Free to Play'</td>\n",
       "      <td>Real Pool 3D - Poolians</td>\n",
       "      <td>Real Pool 3D - Poolians</td>\n",
       "      <td>2017-07-24</td>\n",
       "      <td>670290.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Poolians.com</td>\n",
       "      <td>'Indie'</td>\n",
       "      <td>Real Pool 3D - Poolians</td>\n",
       "      <td>Real Pool 3D - Poolians</td>\n",
       "      <td>2017-07-24</td>\n",
       "      <td>670290.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Poolians.com</td>\n",
       "      <td>'Simulation'</td>\n",
       "      <td>Real Pool 3D - Poolians</td>\n",
       "      <td>Real Pool 3D - Poolians</td>\n",
       "      <td>2017-07-24</td>\n",
       "      <td>670290.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Poolians.com</td>\n",
       "      <td>'Sports'</td>\n",
       "      <td>Real Pool 3D - Poolians</td>\n",
       "      <td>Real Pool 3D - Poolians</td>\n",
       "      <td>2017-07-24</td>\n",
       "      <td>670290.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>彼岸领域</td>\n",
       "      <td>'Action'</td>\n",
       "      <td>弹炸人2222</td>\n",
       "      <td>弹炸人2222</td>\n",
       "      <td>2017-12-07</td>\n",
       "      <td>767400.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>彼岸领域</td>\n",
       "      <td>'Adventure'</td>\n",
       "      <td>弹炸人2222</td>\n",
       "      <td>弹炸人2222</td>\n",
       "      <td>2017-12-07</td>\n",
       "      <td>767400.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>彼岸领域</td>\n",
       "      <td>'Casual'</td>\n",
       "      <td>弹炸人2222</td>\n",
       "      <td>弹炸人2222</td>\n",
       "      <td>2017-12-07</td>\n",
       "      <td>767400.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Log Challenge</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>773570.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Trickjump Games Ltd</td>\n",
       "      <td>'Action'</td>\n",
       "      <td>Battle Royale Trainer</td>\n",
       "      <td>Battle Royale Trainer</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>772540.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Trickjump Games Ltd</td>\n",
       "      <td>'Adventure'</td>\n",
       "      <td>Battle Royale Trainer</td>\n",
       "      <td>Battle Royale Trainer</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>772540.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              publisher           genres                 app_name  \\\n",
       "0             Kotoshiro         'Action'      Lost Summoner Kitty   \n",
       "1             Kotoshiro         'Casual'      Lost Summoner Kitty   \n",
       "2             Kotoshiro          'Indie'      Lost Summoner Kitty   \n",
       "3             Kotoshiro     'Simulation'      Lost Summoner Kitty   \n",
       "4             Kotoshiro      'Strategy'       Lost Summoner Kitty   \n",
       "5      Making Fun, Inc.   'Free to Play'                Ironbound   \n",
       "6      Making Fun, Inc.          'Indie'                Ironbound   \n",
       "7      Making Fun, Inc.            'RPG'                Ironbound   \n",
       "8      Making Fun, Inc.      'Strategy'                 Ironbound   \n",
       "9          Poolians.com         'Casual'  Real Pool 3D - Poolians   \n",
       "10         Poolians.com   'Free to Play'  Real Pool 3D - Poolians   \n",
       "11         Poolians.com          'Indie'  Real Pool 3D - Poolians   \n",
       "12         Poolians.com     'Simulation'  Real Pool 3D - Poolians   \n",
       "13         Poolians.com        'Sports'   Real Pool 3D - Poolians   \n",
       "14                 彼岸领域         'Action'                  弹炸人2222   \n",
       "15                 彼岸领域      'Adventure'                  弹炸人2222   \n",
       "16                 彼岸领域        'Casual'                   弹炸人2222   \n",
       "17                  NaN              NaN            Log Challenge   \n",
       "18  Trickjump Games Ltd         'Action'    Battle Royale Trainer   \n",
       "19  Trickjump Games Ltd      'Adventure'    Battle Royale Trainer   \n",
       "\n",
       "                      title release_date        id  \n",
       "0       Lost Summoner Kitty   2018-01-04  761140.0  \n",
       "1       Lost Summoner Kitty   2018-01-04  761140.0  \n",
       "2       Lost Summoner Kitty   2018-01-04  761140.0  \n",
       "3       Lost Summoner Kitty   2018-01-04  761140.0  \n",
       "4       Lost Summoner Kitty   2018-01-04  761140.0  \n",
       "5                 Ironbound   2018-01-04  643980.0  \n",
       "6                 Ironbound   2018-01-04  643980.0  \n",
       "7                 Ironbound   2018-01-04  643980.0  \n",
       "8                 Ironbound   2018-01-04  643980.0  \n",
       "9   Real Pool 3D - Poolians   2017-07-24  670290.0  \n",
       "10  Real Pool 3D - Poolians   2017-07-24  670290.0  \n",
       "11  Real Pool 3D - Poolians   2017-07-24  670290.0  \n",
       "12  Real Pool 3D - Poolians   2017-07-24  670290.0  \n",
       "13  Real Pool 3D - Poolians   2017-07-24  670290.0  \n",
       "14                  弹炸人2222   2017-12-07  767400.0  \n",
       "15                  弹炸人2222   2017-12-07  767400.0  \n",
       "16                  弹炸人2222   2017-12-07  767400.0  \n",
       "17                      NaN          NaN  773570.0  \n",
       "18    Battle Royale Trainer   2018-01-04  772540.0  \n",
       "19    Battle Royale Trainer   2018-01-04  772540.0  "
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "juego.head(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "e67c3de8",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "numpy.float64"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(juego['id'][0]) #vemos el tipo de dato de la columna juego esta en tipo float pero nosotros lo queremos tipo int"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "d21e86cf",
   "metadata": {},
   "outputs": [],
   "source": [
    "juego['id'] = juego['id'].astype(str) #Lo pasamos a string"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "7953c41d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "str"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(juego['id'][0]) #Revisamos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "7e2c655a",
   "metadata": {},
   "outputs": [],
   "source": [
    "juego['id'] = juego['id'].str.replace(\".\", \"\") #Quitamos la coma"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "a2d0a096",
   "metadata": {},
   "outputs": [],
   "source": [
    "juego['id'] = juego['id'].str.slice(stop=-1) #Borramos el ultimo caracter de todos los registros, al estar en tipo float queda.0 y cuando sacamos la coma queda ese 0 de mas por eso lo sacamos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "1493e831",
   "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>publisher</th>\n",
       "      <th>genres</th>\n",
       "      <th>app_name</th>\n",
       "      <th>title</th>\n",
       "      <th>release_date</th>\n",
       "      <th>id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Kotoshiro</td>\n",
       "      <td>'Action'</td>\n",
       "      <td>Lost Summoner Kitty</td>\n",
       "      <td>Lost Summoner Kitty</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>761140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Kotoshiro</td>\n",
       "      <td>'Casual'</td>\n",
       "      <td>Lost Summoner Kitty</td>\n",
       "      <td>Lost Summoner Kitty</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>761140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Kotoshiro</td>\n",
       "      <td>'Indie'</td>\n",
       "      <td>Lost Summoner Kitty</td>\n",
       "      <td>Lost Summoner Kitty</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>761140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Kotoshiro</td>\n",
       "      <td>'Simulation'</td>\n",
       "      <td>Lost Summoner Kitty</td>\n",
       "      <td>Lost Summoner Kitty</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>761140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Kotoshiro</td>\n",
       "      <td>'Strategy'</td>\n",
       "      <td>Lost Summoner Kitty</td>\n",
       "      <td>Lost Summoner Kitty</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>761140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Making Fun, Inc.</td>\n",
       "      <td>'Free to Play'</td>\n",
       "      <td>Ironbound</td>\n",
       "      <td>Ironbound</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>643980</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Making Fun, Inc.</td>\n",
       "      <td>'Indie'</td>\n",
       "      <td>Ironbound</td>\n",
       "      <td>Ironbound</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>643980</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Making Fun, Inc.</td>\n",
       "      <td>'RPG'</td>\n",
       "      <td>Ironbound</td>\n",
       "      <td>Ironbound</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>643980</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Making Fun, Inc.</td>\n",
       "      <td>'Strategy'</td>\n",
       "      <td>Ironbound</td>\n",
       "      <td>Ironbound</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>643980</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Poolians.com</td>\n",
       "      <td>'Casual'</td>\n",
       "      <td>Real Pool 3D - Poolians</td>\n",
       "      <td>Real Pool 3D - Poolians</td>\n",
       "      <td>2017-07-24</td>\n",
       "      <td>670290</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Poolians.com</td>\n",
       "      <td>'Free to Play'</td>\n",
       "      <td>Real Pool 3D - Poolians</td>\n",
       "      <td>Real Pool 3D - Poolians</td>\n",
       "      <td>2017-07-24</td>\n",
       "      <td>670290</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Poolians.com</td>\n",
       "      <td>'Indie'</td>\n",
       "      <td>Real Pool 3D - Poolians</td>\n",
       "      <td>Real Pool 3D - Poolians</td>\n",
       "      <td>2017-07-24</td>\n",
       "      <td>670290</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Poolians.com</td>\n",
       "      <td>'Simulation'</td>\n",
       "      <td>Real Pool 3D - Poolians</td>\n",
       "      <td>Real Pool 3D - Poolians</td>\n",
       "      <td>2017-07-24</td>\n",
       "      <td>670290</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Poolians.com</td>\n",
       "      <td>'Sports'</td>\n",
       "      <td>Real Pool 3D - Poolians</td>\n",
       "      <td>Real Pool 3D - Poolians</td>\n",
       "      <td>2017-07-24</td>\n",
       "      <td>670290</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>彼岸领域</td>\n",
       "      <td>'Action'</td>\n",
       "      <td>弹炸人2222</td>\n",
       "      <td>弹炸人2222</td>\n",
       "      <td>2017-12-07</td>\n",
       "      <td>767400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>彼岸领域</td>\n",
       "      <td>'Adventure'</td>\n",
       "      <td>弹炸人2222</td>\n",
       "      <td>弹炸人2222</td>\n",
       "      <td>2017-12-07</td>\n",
       "      <td>767400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>彼岸领域</td>\n",
       "      <td>'Casual'</td>\n",
       "      <td>弹炸人2222</td>\n",
       "      <td>弹炸人2222</td>\n",
       "      <td>2017-12-07</td>\n",
       "      <td>767400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Log Challenge</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>773570</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Trickjump Games Ltd</td>\n",
       "      <td>'Action'</td>\n",
       "      <td>Battle Royale Trainer</td>\n",
       "      <td>Battle Royale Trainer</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>772540</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Trickjump Games Ltd</td>\n",
       "      <td>'Adventure'</td>\n",
       "      <td>Battle Royale Trainer</td>\n",
       "      <td>Battle Royale Trainer</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>772540</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              publisher           genres                 app_name  \\\n",
       "0             Kotoshiro         'Action'      Lost Summoner Kitty   \n",
       "1             Kotoshiro         'Casual'      Lost Summoner Kitty   \n",
       "2             Kotoshiro          'Indie'      Lost Summoner Kitty   \n",
       "3             Kotoshiro     'Simulation'      Lost Summoner Kitty   \n",
       "4             Kotoshiro      'Strategy'       Lost Summoner Kitty   \n",
       "5      Making Fun, Inc.   'Free to Play'                Ironbound   \n",
       "6      Making Fun, Inc.          'Indie'                Ironbound   \n",
       "7      Making Fun, Inc.            'RPG'                Ironbound   \n",
       "8      Making Fun, Inc.      'Strategy'                 Ironbound   \n",
       "9          Poolians.com         'Casual'  Real Pool 3D - Poolians   \n",
       "10         Poolians.com   'Free to Play'  Real Pool 3D - Poolians   \n",
       "11         Poolians.com          'Indie'  Real Pool 3D - Poolians   \n",
       "12         Poolians.com     'Simulation'  Real Pool 3D - Poolians   \n",
       "13         Poolians.com        'Sports'   Real Pool 3D - Poolians   \n",
       "14                 彼岸领域         'Action'                  弹炸人2222   \n",
       "15                 彼岸领域      'Adventure'                  弹炸人2222   \n",
       "16                 彼岸领域        'Casual'                   弹炸人2222   \n",
       "17                  NaN              NaN            Log Challenge   \n",
       "18  Trickjump Games Ltd         'Action'    Battle Royale Trainer   \n",
       "19  Trickjump Games Ltd      'Adventure'    Battle Royale Trainer   \n",
       "\n",
       "                      title release_date      id  \n",
       "0       Lost Summoner Kitty   2018-01-04  761140  \n",
       "1       Lost Summoner Kitty   2018-01-04  761140  \n",
       "2       Lost Summoner Kitty   2018-01-04  761140  \n",
       "3       Lost Summoner Kitty   2018-01-04  761140  \n",
       "4       Lost Summoner Kitty   2018-01-04  761140  \n",
       "5                 Ironbound   2018-01-04  643980  \n",
       "6                 Ironbound   2018-01-04  643980  \n",
       "7                 Ironbound   2018-01-04  643980  \n",
       "8                 Ironbound   2018-01-04  643980  \n",
       "9   Real Pool 3D - Poolians   2017-07-24  670290  \n",
       "10  Real Pool 3D - Poolians   2017-07-24  670290  \n",
       "11  Real Pool 3D - Poolians   2017-07-24  670290  \n",
       "12  Real Pool 3D - Poolians   2017-07-24  670290  \n",
       "13  Real Pool 3D - Poolians   2017-07-24  670290  \n",
       "14                  弹炸人2222   2017-12-07  767400  \n",
       "15                  弹炸人2222   2017-12-07  767400  \n",
       "16                  弹炸人2222   2017-12-07  767400  \n",
       "17                      NaN          NaN  773570  \n",
       "18    Battle Royale Trainer   2018-01-04  772540  \n",
       "19    Battle Royale Trainer   2018-01-04  772540  "
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "juego.head(20) #Reviamos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "id": "85287af6",
   "metadata": {},
   "outputs": [],
   "source": [
    "juego.to_csv('juego_funciones.csv') #Guarmaos los cambios en csv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "ed5df8aa",
   "metadata": {},
   "outputs": [],
   "source": [
    "juego=pd.read_csv('juego_funciones.csv').drop('Unnamed: 0', axis=1)#Borramos la columna de los indices que se genera cuando guardamos un csv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "0fa7df2d",
   "metadata": {},
   "outputs": [],
   "source": [
    "juego.drop('app_name', axis=1, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "714fc06c",
   "metadata": {},
   "outputs": [],
   "source": [
    "juego['id'] = juego['id'].replace('na', pd.NA) #Reemplazamos los strings na por valores nulos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "id": "e5ff0878",
   "metadata": {},
   "outputs": [],
   "source": [
    "juego['id'] = juego['id'].fillna(0) #Cambiamos los valores nulos por 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "id": "b79cab7c",
   "metadata": {},
   "outputs": [],
   "source": [
    "juego['id'] = juego['id'].astype(int) #Convertimos la columna a int"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "id": "b86671ba",
   "metadata": {},
   "outputs": [],
   "source": [
    "juego.to_csv('juego_funciones.csv') #Guardamos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "id": "7181649c",
   "metadata": {},
   "outputs": [],
   "source": [
    "juego['release_date'] = pd.to_datetime(juego['release_date'], format='%Y-%m-%d', errors='coerce').dt.date #En estas dos lineas de codigo cambiamos la fecha de tipo string a date"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "id": "dbaeea44",
   "metadata": {},
   "outputs": [],
   "source": [
    "juego['release_date'] = pd.to_datetime(juego['release_date'], format='%Y-%m-%d').dt.date"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "id": "ef523096",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "datetime.date"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(juego['release_date'][0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "id": "39e72b26",
   "metadata": {},
   "outputs": [],
   "source": [
    "juego['genres'] = juego['genres'].str.replace(\"'\", \" \")#Terminamos de limpiar lo que nos quedo de la columna de generos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "id": "892b188e",
   "metadata": {},
   "outputs": [],
   "source": [
    "juego['genres'] = juego['genres'].str.strip() #Teniamos un error con los espacios al final de las palabras asi que los eliminamos porque en las funciones no tomaba bien los registros"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "a9a8b621",
   "metadata": {},
   "outputs": [],
   "source": [
    "juego.to_csv('juego_funciones.csv',index=False) #Guardamos"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c7692b16",
   "metadata": {},
   "source": [
    "aqui hago un etl para tener un csv de juegos que me sirva para mis modelos de Machine Learning"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "2c827cd1",
   "metadata": {},
   "outputs": [],
   "source": [
    "juego=pd.read_csv('juego_limpio.csv',low_memory=False) #Abrimos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "0e90e1fe",
   "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>publisher</th>\n",
       "      <th>genres</th>\n",
       "      <th>app_name</th>\n",
       "      <th>title</th>\n",
       "      <th>url</th>\n",
       "      <th>release_date</th>\n",
       "      <th>tags</th>\n",
       "      <th>reviews_url</th>\n",
       "      <th>discount_price</th>\n",
       "      <th>specs</th>\n",
       "      <th>price</th>\n",
       "      <th>early_access</th>\n",
       "      <th>id</th>\n",
       "      <th>metascore</th>\n",
       "      <th>developer</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Kotoshiro</td>\n",
       "      <td>['Action', 'Casual', 'Indie', 'Simulation', 'S...</td>\n",
       "      <td>Lost Summoner Kitty</td>\n",
       "      <td>Lost Summoner Kitty</td>\n",
       "      <td>http://store.steampowered.com/app/761140/Lost_...</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>['Strategy', 'Action', 'Indie', 'Casual', 'Sim...</td>\n",
       "      <td>http://steamcommunity.com/app/761140/reviews/?...</td>\n",
       "      <td>4.49</td>\n",
       "      <td>['Single-player']</td>\n",
       "      <td>4.99</td>\n",
       "      <td>False</td>\n",
       "      <td>761140.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kotoshiro</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Making Fun, Inc.</td>\n",
       "      <td>['Free to Play', 'Indie', 'RPG', 'Strategy']</td>\n",
       "      <td>Ironbound</td>\n",
       "      <td>Ironbound</td>\n",
       "      <td>http://store.steampowered.com/app/643980/Ironb...</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>['Free to Play', 'Strategy', 'Indie', 'RPG', '...</td>\n",
       "      <td>http://steamcommunity.com/app/643980/reviews/?...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Single-player', 'Multi-player', 'Online Mult...</td>\n",
       "      <td>Free To Play</td>\n",
       "      <td>False</td>\n",
       "      <td>643980.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Secret Level SRL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Poolians.com</td>\n",
       "      <td>['Casual', 'Free to Play', 'Indie', 'Simulatio...</td>\n",
       "      <td>Real Pool 3D - Poolians</td>\n",
       "      <td>Real Pool 3D - Poolians</td>\n",
       "      <td>http://store.steampowered.com/app/670290/Real_...</td>\n",
       "      <td>2017-07-24</td>\n",
       "      <td>['Free to Play', 'Simulation', 'Sports', 'Casu...</td>\n",
       "      <td>http://steamcommunity.com/app/670290/reviews/?...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Single-player', 'Multi-player', 'Online Mult...</td>\n",
       "      <td>Free to Play</td>\n",
       "      <td>False</td>\n",
       "      <td>670290.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Poolians.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>彼岸领域</td>\n",
       "      <td>['Action', 'Adventure', 'Casual']</td>\n",
       "      <td>弹炸人2222</td>\n",
       "      <td>弹炸人2222</td>\n",
       "      <td>http://store.steampowered.com/app/767400/2222/</td>\n",
       "      <td>2017-12-07</td>\n",
       "      <td>['Action', 'Adventure', 'Casual']</td>\n",
       "      <td>http://steamcommunity.com/app/767400/reviews/?...</td>\n",
       "      <td>0.83</td>\n",
       "      <td>['Single-player']</td>\n",
       "      <td>0.99</td>\n",
       "      <td>False</td>\n",
       "      <td>767400.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>彼岸领域</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Log Challenge</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://store.steampowered.com/app/773570/Log_C...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Action', 'Indie', 'Casual', 'Sports']</td>\n",
       "      <td>http://steamcommunity.com/app/773570/reviews/?...</td>\n",
       "      <td>1.79</td>\n",
       "      <td>['Single-player', 'Full controller support', '...</td>\n",
       "      <td>2.99</td>\n",
       "      <td>False</td>\n",
       "      <td>773570.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Trickjump Games Ltd</td>\n",
       "      <td>['Action', 'Adventure', 'Simulation']</td>\n",
       "      <td>Battle Royale Trainer</td>\n",
       "      <td>Battle Royale Trainer</td>\n",
       "      <td>http://store.steampowered.com/app/772540/Battl...</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>['Action', 'Adventure', 'Simulation', 'FPS', '...</td>\n",
       "      <td>http://steamcommunity.com/app/772540/reviews/?...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Single-player', 'Steam Achievements']</td>\n",
       "      <td>3.99</td>\n",
       "      <td>False</td>\n",
       "      <td>772540.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Trickjump Games Ltd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>NaN</td>\n",
       "      <td>['Free to Play', 'Indie', 'Simulation', 'Sports']</td>\n",
       "      <td>SNOW - All Access Basic Pass</td>\n",
       "      <td>SNOW - All Access Basic Pass</td>\n",
       "      <td>http://store.steampowered.com/app/774276/SNOW_...</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>['Free to Play', 'Indie', 'Simulation', 'Sports']</td>\n",
       "      <td>http://steamcommunity.com/app/774276/reviews/?...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Single-player', 'Multi-player', 'Online Mult...</td>\n",
       "      <td>9.99</td>\n",
       "      <td>False</td>\n",
       "      <td>774276.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Poppermost Productions</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Poppermost Productions</td>\n",
       "      <td>['Free to Play', 'Indie', 'Simulation', 'Sports']</td>\n",
       "      <td>SNOW - All Access Pro Pass</td>\n",
       "      <td>SNOW - All Access Pro Pass</td>\n",
       "      <td>http://store.steampowered.com/app/774277/SNOW_...</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>['Free to Play', 'Indie', 'Simulation', 'Sports']</td>\n",
       "      <td>http://steamcommunity.com/app/774277/reviews/?...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Single-player', 'Multi-player', 'Online Mult...</td>\n",
       "      <td>18.99</td>\n",
       "      <td>False</td>\n",
       "      <td>774277.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Poppermost Productions</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Poppermost Productions</td>\n",
       "      <td>['Free to Play', 'Indie', 'Simulation', 'Sports']</td>\n",
       "      <td>SNOW - All Access Legend Pass</td>\n",
       "      <td>SNOW - All Access Legend Pass</td>\n",
       "      <td>http://store.steampowered.com/app/774278/SNOW_...</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>['Free to Play', 'Indie', 'Simulation', 'Sports']</td>\n",
       "      <td>http://steamcommunity.com/app/774278/reviews/?...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Single-player', 'Multi-player', 'Online Mult...</td>\n",
       "      <td>29.99</td>\n",
       "      <td>False</td>\n",
       "      <td>774278.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Poppermost Productions</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>RewindApp</td>\n",
       "      <td>['Casual', 'Indie', 'Racing', 'Simulation']</td>\n",
       "      <td>Race</td>\n",
       "      <td>Race</td>\n",
       "      <td>http://store.steampowered.com/app/768800/Race/</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>['Indie', 'Casual', 'Simulation', 'Racing']</td>\n",
       "      <td>http://steamcommunity.com/app/768800/reviews/?...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Single-player', 'Multi-player', 'Partial Con...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>768800.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RewindApp</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Qucheza</td>\n",
       "      <td>['Action', 'Indie', 'Simulation', 'Early Access']</td>\n",
       "      <td>Uncanny Islands</td>\n",
       "      <td>Uncanny Islands</td>\n",
       "      <td>http://store.steampowered.com/app/768570/Uncan...</td>\n",
       "      <td>Soon..</td>\n",
       "      <td>['Early Access', 'Action', 'Indie', 'Simulatio...</td>\n",
       "      <td>http://steamcommunity.com/app/768570/reviews/?...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Single-player']</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>768570.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Qucheza</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Icarus Six Sixty Six</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://store.steampowered.com/app/724910/Icaru...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Casual']</td>\n",
       "      <td>http://steamcommunity.com/app/724910/reviews/?...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Single-player', 'HTC Vive', 'Tracked Motion ...</td>\n",
       "      <td>Free</td>\n",
       "      <td>False</td>\n",
       "      <td>724910.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Stegalosaurus Game Development</td>\n",
       "      <td>['Action', 'Adventure', 'Casual', 'Indie', 'RPG']</td>\n",
       "      <td>Army of Tentacles: (Not) A Cthulhu Dating Sim:...</td>\n",
       "      <td>Army of Tentacles: (Not) A Cthulhu Dating Sim:...</td>\n",
       "      <td>http://store.steampowered.com/app/770380/Army_...</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>['Action', 'Adventure', 'RPG', 'Indie', 'Casual']</td>\n",
       "      <td>http://steamcommunity.com/app/770380/reviews/?...</td>\n",
       "      <td>8.79</td>\n",
       "      <td>['Single-player', 'Steam Achievements']</td>\n",
       "      <td>10.99</td>\n",
       "      <td>False</td>\n",
       "      <td>770380.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Stegalosaurus Game Development</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Copperpick Studio</td>\n",
       "      <td>['Casual', 'Indie']</td>\n",
       "      <td>Beach Rules</td>\n",
       "      <td>Beach Rules</td>\n",
       "      <td>http://store.steampowered.com/app/768880/Beach...</td>\n",
       "      <td>2018-01-04</td>\n",
       "      <td>['Casual', 'Indie', 'Pixel Graphics', 'Cute', ...</td>\n",
       "      <td>http://steamcommunity.com/app/768880/reviews/?...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Single-player']</td>\n",
       "      <td>3.99</td>\n",
       "      <td>False</td>\n",
       "      <td>768880.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Copperpick Studio</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Ghulam Jewel</td>\n",
       "      <td>['Casual', 'Indie', 'Simulation']</td>\n",
       "      <td>Planetarium 2 - Zen Odyssey</td>\n",
       "      <td>Planetarium 2 - Zen Odyssey</td>\n",
       "      <td>http://store.steampowered.com/app/765320/Plane...</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>['Indie', 'Casual', 'Simulation']</td>\n",
       "      <td>http://steamcommunity.com/app/765320/reviews/?...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Single-player']</td>\n",
       "      <td>2.99</td>\n",
       "      <td>False</td>\n",
       "      <td>765320.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Ghulam Jewel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Apillo</td>\n",
       "      <td>['Adventure', 'Casual', 'Indie', 'Simulation',...</td>\n",
       "      <td>The first thrust of God</td>\n",
       "      <td>The first thrust of God</td>\n",
       "      <td>http://store.steampowered.com/app/773650/The_f...</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>['Strategy', 'Adventure', 'Indie', 'Casual', '...</td>\n",
       "      <td>http://steamcommunity.com/app/773650/reviews/?...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Single-player', 'Steam Achievements', 'Steam...</td>\n",
       "      <td>1.59</td>\n",
       "      <td>False</td>\n",
       "      <td>773650.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Apillo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Poppermost Productions</td>\n",
       "      <td>['Free to Play', 'Indie', 'Simulation', 'Sports']</td>\n",
       "      <td>SNOW - Starter Pack</td>\n",
       "      <td>SNOW - Starter Pack</td>\n",
       "      <td>http://store.steampowered.com/app/774271/SNOW_...</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>['Free to Play', 'Indie', 'Simulation', 'Sports']</td>\n",
       "      <td>http://steamcommunity.com/app/774271/reviews/?...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Single-player', 'Multi-player', 'Online Mult...</td>\n",
       "      <td>14.99</td>\n",
       "      <td>False</td>\n",
       "      <td>774271.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Poppermost Productions</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Apillo</td>\n",
       "      <td>['Adventure', 'Casual', 'Indie', 'Simulation',...</td>\n",
       "      <td>The first thrust of God - All Aircrafts</td>\n",
       "      <td>The first thrust of God - All Aircrafts</td>\n",
       "      <td>http://store.steampowered.com/app/773690/The_f...</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>['Strategy', 'Adventure', 'Indie', 'Casual', '...</td>\n",
       "      <td>http://steamcommunity.com/app/773690/reviews/?...</td>\n",
       "      <td>1.59</td>\n",
       "      <td>['Single-player', 'Downloadable Content', 'Ste...</td>\n",
       "      <td>1.99</td>\n",
       "      <td>False</td>\n",
       "      <td>773690.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Apillo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Poppermost Productions</td>\n",
       "      <td>['Free to Play', 'Indie', 'Simulation', 'Sports']</td>\n",
       "      <td>SNOW - Lifetime Pack</td>\n",
       "      <td>SNOW - Lifetime Pack</td>\n",
       "      <td>http://store.steampowered.com/app/774279/SNOW_...</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>['Free to Play', 'Indie', 'Simulation', 'Sports']</td>\n",
       "      <td>http://steamcommunity.com/app/774279/reviews/?...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Single-player', 'Multi-player', 'Online Mult...</td>\n",
       "      <td>59.99</td>\n",
       "      <td>False</td>\n",
       "      <td>774279.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Poppermost Productions</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>After Life VR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://store.steampowered.com/app/772590/After...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Early Access', 'Indie', 'VR']</td>\n",
       "      <td>http://steamcommunity.com/app/772590/reviews/?...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Single-player', 'HTC Vive', 'Tracked Motion ...</td>\n",
       "      <td>4.99</td>\n",
       "      <td>True</td>\n",
       "      <td>772590.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kitty Hawk</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://store.steampowered.com/app/640250/Kitty...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Early Access', 'Action', 'Adventure', 'Indie...</td>\n",
       "      <td>http://steamcommunity.com/app/640250/reviews/?...</td>\n",
       "      <td>1.97</td>\n",
       "      <td>['Single-player', 'Steam Leaderboards', 'HTC V...</td>\n",
       "      <td>2.99</td>\n",
       "      <td>True</td>\n",
       "      <td>640250.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Tero Lunkka</td>\n",
       "      <td>['Action', 'Adventure', 'Indie']</td>\n",
       "      <td>The Warrior Of Treasures</td>\n",
       "      <td>The Warrior Of Treasures</td>\n",
       "      <td>http://store.steampowered.com/app/768060/The_W...</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>['Action', 'Adventure', 'Indie']</td>\n",
       "      <td>http://steamcommunity.com/app/768060/reviews/?...</td>\n",
       "      <td>0.59</td>\n",
       "      <td>['Single-player']</td>\n",
       "      <td>0.99</td>\n",
       "      <td>False</td>\n",
       "      <td>768060.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tero Lunkka</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Mortars VR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://store.steampowered.com/app/711440/Morta...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Early Access', 'Strategy', 'Action', 'Indie'...</td>\n",
       "      <td>http://steamcommunity.com/app/711440/reviews/?...</td>\n",
       "      <td>0.89</td>\n",
       "      <td>['Single-player', 'Multi-player', 'Online Mult...</td>\n",
       "      <td>0.99</td>\n",
       "      <td>True</td>\n",
       "      <td>711440.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>FrozenPepper</td>\n",
       "      <td>['Racing', 'Simulation', 'Sports']</td>\n",
       "      <td>RC Plane 3 - Canyon Scenario</td>\n",
       "      <td>RC Plane 3 - Canyon Scenario</td>\n",
       "      <td>http://store.steampowered.com/app/775880/RC_Pl...</td>\n",
       "      <td>2017-12-22</td>\n",
       "      <td>['Simulation', 'Racing', 'Sports']</td>\n",
       "      <td>http://steamcommunity.com/app/775880/reviews/?...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Single-player', 'Downloadable Content', 'Ste...</td>\n",
       "      <td>2.99</td>\n",
       "      <td>False</td>\n",
       "      <td>775880.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FrozenPepper</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>FrozenPepper</td>\n",
       "      <td>['Racing', 'Simulation', 'Sports']</td>\n",
       "      <td>RC Plane 3 - F-53B</td>\n",
       "      <td>RC Plane 3 - F-53B</td>\n",
       "      <td>http://store.steampowered.com/app/775881/RC_Pl...</td>\n",
       "      <td>2017-12-23</td>\n",
       "      <td>['Simulation', 'Racing', 'Sports']</td>\n",
       "      <td>http://steamcommunity.com/app/775881/reviews/?...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Single-player', 'Cross-Platform Multiplayer'...</td>\n",
       "      <td>2.99</td>\n",
       "      <td>False</td>\n",
       "      <td>775881.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FrozenPepper</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Casey Labrack</td>\n",
       "      <td>['Action', 'Indie']</td>\n",
       "      <td>DinoBlaster</td>\n",
       "      <td>DinoBlaster</td>\n",
       "      <td>http://store.steampowered.com/app/653960/DinoB...</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>['Indie', 'Action']</td>\n",
       "      <td>http://steamcommunity.com/app/653960/reviews/?...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Single-player', 'Local Co-op', 'Shared/Split...</td>\n",
       "      <td>4.99</td>\n",
       "      <td>False</td>\n",
       "      <td>653960.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Casey Labrack</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Robotpencil Presents: Understanding 3D for Con...</td>\n",
       "      <td>Robotpencil Presents: Understanding 3D for Con...</td>\n",
       "      <td>http://store.steampowered.com/app/777910/Robot...</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>['Design &amp; Illustration', 'Tutorial']</td>\n",
       "      <td>http://steamcommunity.com/app/777910/reviews/?...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.99</td>\n",
       "      <td>False</td>\n",
       "      <td>777910.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Stainless Games Ltd</td>\n",
       "      <td>['Action', 'Indie', 'Racing']</td>\n",
       "      <td>Carmageddon Max Pack</td>\n",
       "      <td>Carmageddon Max Pack</td>\n",
       "      <td>http://store.steampowered.com/app/282010/Carma...</td>\n",
       "      <td>1997-06-30</td>\n",
       "      <td>['Racing', 'Action', 'Classic', 'Indie', 'Gore...</td>\n",
       "      <td>http://steamcommunity.com/app/282010/reviews/?...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Single-player', 'Multi-player', 'Steam Tradi...</td>\n",
       "      <td>9.99</td>\n",
       "      <td>False</td>\n",
       "      <td>282010.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Stainless Games Ltd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Valve</td>\n",
       "      <td>['Action']</td>\n",
       "      <td>Half-Life</td>\n",
       "      <td>Half-Life</td>\n",
       "      <td>http://store.steampowered.com/app/70/HalfLife/</td>\n",
       "      <td>1998-11-08</td>\n",
       "      <td>['FPS', 'Classic', 'Action', 'Sci-fi', 'Single...</td>\n",
       "      <td>http://steamcommunity.com/app/70/reviews/?brow...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Single-player', 'Multi-player', 'Valve Anti-...</td>\n",
       "      <td>9.99</td>\n",
       "      <td>False</td>\n",
       "      <td>70.0</td>\n",
       "      <td>96.0</td>\n",
       "      <td>Valve</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>dev4play</td>\n",
       "      <td>['Action', 'Indie', 'RPG']</td>\n",
       "      <td>Fallen Mage</td>\n",
       "      <td>Fallen Mage</td>\n",
       "      <td>http://store.steampowered.com/app/752360/Falle...</td>\n",
       "      <td>2016-11-25</td>\n",
       "      <td>['Action', 'RPG', 'Indie']</td>\n",
       "      <td>http://steamcommunity.com/app/752360/reviews/?...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Single-player']</td>\n",
       "      <td>1.99</td>\n",
       "      <td>False</td>\n",
       "      <td>752360.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>dev4play</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         publisher  \\\n",
       "0                        Kotoshiro   \n",
       "1                 Making Fun, Inc.   \n",
       "2                     Poolians.com   \n",
       "3                             彼岸领域   \n",
       "4                              NaN   \n",
       "5              Trickjump Games Ltd   \n",
       "6                              NaN   \n",
       "7           Poppermost Productions   \n",
       "8           Poppermost Productions   \n",
       "9                        RewindApp   \n",
       "10                         Qucheza   \n",
       "11                             NaN   \n",
       "12  Stegalosaurus Game Development   \n",
       "13               Copperpick Studio   \n",
       "14                    Ghulam Jewel   \n",
       "15                          Apillo   \n",
       "16          Poppermost Productions   \n",
       "17                          Apillo   \n",
       "18          Poppermost Productions   \n",
       "19                             NaN   \n",
       "20                             NaN   \n",
       "21                     Tero Lunkka   \n",
       "22                             NaN   \n",
       "23                    FrozenPepper   \n",
       "24                    FrozenPepper   \n",
       "25                   Casey Labrack   \n",
       "26                             NaN   \n",
       "27             Stainless Games Ltd   \n",
       "28                           Valve   \n",
       "29                        dev4play   \n",
       "\n",
       "                                               genres  \\\n",
       "0   ['Action', 'Casual', 'Indie', 'Simulation', 'S...   \n",
       "1        ['Free to Play', 'Indie', 'RPG', 'Strategy']   \n",
       "2   ['Casual', 'Free to Play', 'Indie', 'Simulatio...   \n",
       "3                   ['Action', 'Adventure', 'Casual']   \n",
       "4                                                 NaN   \n",
       "5               ['Action', 'Adventure', 'Simulation']   \n",
       "6   ['Free to Play', 'Indie', 'Simulation', 'Sports']   \n",
       "7   ['Free to Play', 'Indie', 'Simulation', 'Sports']   \n",
       "8   ['Free to Play', 'Indie', 'Simulation', 'Sports']   \n",
       "9         ['Casual', 'Indie', 'Racing', 'Simulation']   \n",
       "10  ['Action', 'Indie', 'Simulation', 'Early Access']   \n",
       "11                                                NaN   \n",
       "12  ['Action', 'Adventure', 'Casual', 'Indie', 'RPG']   \n",
       "13                                ['Casual', 'Indie']   \n",
       "14                  ['Casual', 'Indie', 'Simulation']   \n",
       "15  ['Adventure', 'Casual', 'Indie', 'Simulation',...   \n",
       "16  ['Free to Play', 'Indie', 'Simulation', 'Sports']   \n",
       "17  ['Adventure', 'Casual', 'Indie', 'Simulation',...   \n",
       "18  ['Free to Play', 'Indie', 'Simulation', 'Sports']   \n",
       "19                                                NaN   \n",
       "20                                                NaN   \n",
       "21                   ['Action', 'Adventure', 'Indie']   \n",
       "22                                                NaN   \n",
       "23                 ['Racing', 'Simulation', 'Sports']   \n",
       "24                 ['Racing', 'Simulation', 'Sports']   \n",
       "25                                ['Action', 'Indie']   \n",
       "26                                                NaN   \n",
       "27                      ['Action', 'Indie', 'Racing']   \n",
       "28                                         ['Action']   \n",
       "29                         ['Action', 'Indie', 'RPG']   \n",
       "\n",
       "                                             app_name  \\\n",
       "0                                 Lost Summoner Kitty   \n",
       "1                                           Ironbound   \n",
       "2                             Real Pool 3D - Poolians   \n",
       "3                                             弹炸人2222   \n",
       "4                                       Log Challenge   \n",
       "5                               Battle Royale Trainer   \n",
       "6                        SNOW - All Access Basic Pass   \n",
       "7                          SNOW - All Access Pro Pass   \n",
       "8                       SNOW - All Access Legend Pass   \n",
       "9                                                Race   \n",
       "10                                    Uncanny Islands   \n",
       "11                               Icarus Six Sixty Six   \n",
       "12  Army of Tentacles: (Not) A Cthulhu Dating Sim:...   \n",
       "13                                        Beach Rules   \n",
       "14                        Planetarium 2 - Zen Odyssey   \n",
       "15                            The first thrust of God   \n",
       "16                                SNOW - Starter Pack   \n",
       "17            The first thrust of God - All Aircrafts   \n",
       "18                               SNOW - Lifetime Pack   \n",
       "19                                      After Life VR   \n",
       "20                                         Kitty Hawk   \n",
       "21                           The Warrior Of Treasures   \n",
       "22                                         Mortars VR   \n",
       "23                       RC Plane 3 - Canyon Scenario   \n",
       "24                                 RC Plane 3 - F-53B   \n",
       "25                                        DinoBlaster   \n",
       "26  Robotpencil Presents: Understanding 3D for Con...   \n",
       "27                               Carmageddon Max Pack   \n",
       "28                                          Half-Life   \n",
       "29                                        Fallen Mage   \n",
       "\n",
       "                                                title  \\\n",
       "0                                 Lost Summoner Kitty   \n",
       "1                                           Ironbound   \n",
       "2                             Real Pool 3D - Poolians   \n",
       "3                                             弹炸人2222   \n",
       "4                                                 NaN   \n",
       "5                               Battle Royale Trainer   \n",
       "6                        SNOW - All Access Basic Pass   \n",
       "7                          SNOW - All Access Pro Pass   \n",
       "8                       SNOW - All Access Legend Pass   \n",
       "9                                                Race   \n",
       "10                                    Uncanny Islands   \n",
       "11                                                NaN   \n",
       "12  Army of Tentacles: (Not) A Cthulhu Dating Sim:...   \n",
       "13                                        Beach Rules   \n",
       "14                        Planetarium 2 - Zen Odyssey   \n",
       "15                            The first thrust of God   \n",
       "16                                SNOW - Starter Pack   \n",
       "17            The first thrust of God - All Aircrafts   \n",
       "18                               SNOW - Lifetime Pack   \n",
       "19                                                NaN   \n",
       "20                                                NaN   \n",
       "21                           The Warrior Of Treasures   \n",
       "22                                                NaN   \n",
       "23                       RC Plane 3 - Canyon Scenario   \n",
       "24                                 RC Plane 3 - F-53B   \n",
       "25                                        DinoBlaster   \n",
       "26  Robotpencil Presents: Understanding 3D for Con...   \n",
       "27                               Carmageddon Max Pack   \n",
       "28                                          Half-Life   \n",
       "29                                        Fallen Mage   \n",
       "\n",
       "                                                  url release_date  \\\n",
       "0   http://store.steampowered.com/app/761140/Lost_...   2018-01-04   \n",
       "1   http://store.steampowered.com/app/643980/Ironb...   2018-01-04   \n",
       "2   http://store.steampowered.com/app/670290/Real_...   2017-07-24   \n",
       "3      http://store.steampowered.com/app/767400/2222/   2017-12-07   \n",
       "4   http://store.steampowered.com/app/773570/Log_C...          NaN   \n",
       "5   http://store.steampowered.com/app/772540/Battl...   2018-01-04   \n",
       "6   http://store.steampowered.com/app/774276/SNOW_...   2018-01-04   \n",
       "7   http://store.steampowered.com/app/774277/SNOW_...   2018-01-04   \n",
       "8   http://store.steampowered.com/app/774278/SNOW_...   2018-01-04   \n",
       "9      http://store.steampowered.com/app/768800/Race/   2018-01-04   \n",
       "10  http://store.steampowered.com/app/768570/Uncan...       Soon..   \n",
       "11  http://store.steampowered.com/app/724910/Icaru...          NaN   \n",
       "12  http://store.steampowered.com/app/770380/Army_...   2018-01-04   \n",
       "13  http://store.steampowered.com/app/768880/Beach...   2018-01-04   \n",
       "14  http://store.steampowered.com/app/765320/Plane...   2018-01-03   \n",
       "15  http://store.steampowered.com/app/773650/The_f...   2018-01-03   \n",
       "16  http://store.steampowered.com/app/774271/SNOW_...   2018-01-03   \n",
       "17  http://store.steampowered.com/app/773690/The_f...   2018-01-03   \n",
       "18  http://store.steampowered.com/app/774279/SNOW_...   2018-01-03   \n",
       "19  http://store.steampowered.com/app/772590/After...          NaN   \n",
       "20  http://store.steampowered.com/app/640250/Kitty...          NaN   \n",
       "21  http://store.steampowered.com/app/768060/The_W...   2018-01-03   \n",
       "22  http://store.steampowered.com/app/711440/Morta...          NaN   \n",
       "23  http://store.steampowered.com/app/775880/RC_Pl...   2017-12-22   \n",
       "24  http://store.steampowered.com/app/775881/RC_Pl...   2017-12-23   \n",
       "25  http://store.steampowered.com/app/653960/DinoB...   2018-01-03   \n",
       "26  http://store.steampowered.com/app/777910/Robot...   2018-01-03   \n",
       "27  http://store.steampowered.com/app/282010/Carma...   1997-06-30   \n",
       "28     http://store.steampowered.com/app/70/HalfLife/   1998-11-08   \n",
       "29  http://store.steampowered.com/app/752360/Falle...   2016-11-25   \n",
       "\n",
       "                                                 tags  \\\n",
       "0   ['Strategy', 'Action', 'Indie', 'Casual', 'Sim...   \n",
       "1   ['Free to Play', 'Strategy', 'Indie', 'RPG', '...   \n",
       "2   ['Free to Play', 'Simulation', 'Sports', 'Casu...   \n",
       "3                   ['Action', 'Adventure', 'Casual']   \n",
       "4             ['Action', 'Indie', 'Casual', 'Sports']   \n",
       "5   ['Action', 'Adventure', 'Simulation', 'FPS', '...   \n",
       "6   ['Free to Play', 'Indie', 'Simulation', 'Sports']   \n",
       "7   ['Free to Play', 'Indie', 'Simulation', 'Sports']   \n",
       "8   ['Free to Play', 'Indie', 'Simulation', 'Sports']   \n",
       "9         ['Indie', 'Casual', 'Simulation', 'Racing']   \n",
       "10  ['Early Access', 'Action', 'Indie', 'Simulatio...   \n",
       "11                                         ['Casual']   \n",
       "12  ['Action', 'Adventure', 'RPG', 'Indie', 'Casual']   \n",
       "13  ['Casual', 'Indie', 'Pixel Graphics', 'Cute', ...   \n",
       "14                  ['Indie', 'Casual', 'Simulation']   \n",
       "15  ['Strategy', 'Adventure', 'Indie', 'Casual', '...   \n",
       "16  ['Free to Play', 'Indie', 'Simulation', 'Sports']   \n",
       "17  ['Strategy', 'Adventure', 'Indie', 'Casual', '...   \n",
       "18  ['Free to Play', 'Indie', 'Simulation', 'Sports']   \n",
       "19                    ['Early Access', 'Indie', 'VR']   \n",
       "20  ['Early Access', 'Action', 'Adventure', 'Indie...   \n",
       "21                   ['Action', 'Adventure', 'Indie']   \n",
       "22  ['Early Access', 'Strategy', 'Action', 'Indie'...   \n",
       "23                 ['Simulation', 'Racing', 'Sports']   \n",
       "24                 ['Simulation', 'Racing', 'Sports']   \n",
       "25                                ['Indie', 'Action']   \n",
       "26              ['Design & Illustration', 'Tutorial']   \n",
       "27  ['Racing', 'Action', 'Classic', 'Indie', 'Gore...   \n",
       "28  ['FPS', 'Classic', 'Action', 'Sci-fi', 'Single...   \n",
       "29                         ['Action', 'RPG', 'Indie']   \n",
       "\n",
       "                                          reviews_url  discount_price  \\\n",
       "0   http://steamcommunity.com/app/761140/reviews/?...            4.49   \n",
       "1   http://steamcommunity.com/app/643980/reviews/?...             NaN   \n",
       "2   http://steamcommunity.com/app/670290/reviews/?...             NaN   \n",
       "3   http://steamcommunity.com/app/767400/reviews/?...            0.83   \n",
       "4   http://steamcommunity.com/app/773570/reviews/?...            1.79   \n",
       "5   http://steamcommunity.com/app/772540/reviews/?...             NaN   \n",
       "6   http://steamcommunity.com/app/774276/reviews/?...             NaN   \n",
       "7   http://steamcommunity.com/app/774277/reviews/?...             NaN   \n",
       "8   http://steamcommunity.com/app/774278/reviews/?...             NaN   \n",
       "9   http://steamcommunity.com/app/768800/reviews/?...             NaN   \n",
       "10  http://steamcommunity.com/app/768570/reviews/?...             NaN   \n",
       "11  http://steamcommunity.com/app/724910/reviews/?...             NaN   \n",
       "12  http://steamcommunity.com/app/770380/reviews/?...            8.79   \n",
       "13  http://steamcommunity.com/app/768880/reviews/?...             NaN   \n",
       "14  http://steamcommunity.com/app/765320/reviews/?...             NaN   \n",
       "15  http://steamcommunity.com/app/773650/reviews/?...             NaN   \n",
       "16  http://steamcommunity.com/app/774271/reviews/?...             NaN   \n",
       "17  http://steamcommunity.com/app/773690/reviews/?...            1.59   \n",
       "18  http://steamcommunity.com/app/774279/reviews/?...             NaN   \n",
       "19  http://steamcommunity.com/app/772590/reviews/?...             NaN   \n",
       "20  http://steamcommunity.com/app/640250/reviews/?...            1.97   \n",
       "21  http://steamcommunity.com/app/768060/reviews/?...            0.59   \n",
       "22  http://steamcommunity.com/app/711440/reviews/?...            0.89   \n",
       "23  http://steamcommunity.com/app/775880/reviews/?...             NaN   \n",
       "24  http://steamcommunity.com/app/775881/reviews/?...             NaN   \n",
       "25  http://steamcommunity.com/app/653960/reviews/?...             NaN   \n",
       "26  http://steamcommunity.com/app/777910/reviews/?...             NaN   \n",
       "27  http://steamcommunity.com/app/282010/reviews/?...             NaN   \n",
       "28  http://steamcommunity.com/app/70/reviews/?brow...             NaN   \n",
       "29  http://steamcommunity.com/app/752360/reviews/?...             NaN   \n",
       "\n",
       "                                                specs         price  \\\n",
       "0                                   ['Single-player']          4.99   \n",
       "1   ['Single-player', 'Multi-player', 'Online Mult...  Free To Play   \n",
       "2   ['Single-player', 'Multi-player', 'Online Mult...  Free to Play   \n",
       "3                                   ['Single-player']          0.99   \n",
       "4   ['Single-player', 'Full controller support', '...          2.99   \n",
       "5             ['Single-player', 'Steam Achievements']          3.99   \n",
       "6   ['Single-player', 'Multi-player', 'Online Mult...          9.99   \n",
       "7   ['Single-player', 'Multi-player', 'Online Mult...         18.99   \n",
       "8   ['Single-player', 'Multi-player', 'Online Mult...         29.99   \n",
       "9   ['Single-player', 'Multi-player', 'Partial Con...           NaN   \n",
       "10                                  ['Single-player']           NaN   \n",
       "11  ['Single-player', 'HTC Vive', 'Tracked Motion ...          Free   \n",
       "12            ['Single-player', 'Steam Achievements']         10.99   \n",
       "13                                  ['Single-player']          3.99   \n",
       "14                                  ['Single-player']          2.99   \n",
       "15  ['Single-player', 'Steam Achievements', 'Steam...          1.59   \n",
       "16  ['Single-player', 'Multi-player', 'Online Mult...         14.99   \n",
       "17  ['Single-player', 'Downloadable Content', 'Ste...          1.99   \n",
       "18  ['Single-player', 'Multi-player', 'Online Mult...         59.99   \n",
       "19  ['Single-player', 'HTC Vive', 'Tracked Motion ...          4.99   \n",
       "20  ['Single-player', 'Steam Leaderboards', 'HTC V...          2.99   \n",
       "21                                  ['Single-player']          0.99   \n",
       "22  ['Single-player', 'Multi-player', 'Online Mult...          0.99   \n",
       "23  ['Single-player', 'Downloadable Content', 'Ste...          2.99   \n",
       "24  ['Single-player', 'Cross-Platform Multiplayer'...          2.99   \n",
       "25  ['Single-player', 'Local Co-op', 'Shared/Split...          4.99   \n",
       "26                                                NaN          4.99   \n",
       "27  ['Single-player', 'Multi-player', 'Steam Tradi...          9.99   \n",
       "28  ['Single-player', 'Multi-player', 'Valve Anti-...          9.99   \n",
       "29                                  ['Single-player']          1.99   \n",
       "\n",
       "    early_access        id  metascore                       developer  \n",
       "0          False  761140.0        NaN                       Kotoshiro  \n",
       "1          False  643980.0        NaN                Secret Level SRL  \n",
       "2          False  670290.0        NaN                    Poolians.com  \n",
       "3          False  767400.0        NaN                            彼岸领域  \n",
       "4          False  773570.0        NaN                             NaN  \n",
       "5          False  772540.0        NaN             Trickjump Games Ltd  \n",
       "6          False  774276.0        NaN          Poppermost Productions  \n",
       "7          False  774277.0        NaN          Poppermost Productions  \n",
       "8          False  774278.0        NaN          Poppermost Productions  \n",
       "9          False  768800.0        NaN                       RewindApp  \n",
       "10          True  768570.0        NaN                         Qucheza  \n",
       "11         False  724910.0        NaN                             NaN  \n",
       "12         False  770380.0        NaN  Stegalosaurus Game Development  \n",
       "13         False  768880.0        NaN               Copperpick Studio  \n",
       "14         False  765320.0        NaN                    Ghulam Jewel  \n",
       "15         False  773650.0        NaN                          Apillo  \n",
       "16         False  774271.0        NaN          Poppermost Productions  \n",
       "17         False  773690.0        NaN                          Apillo  \n",
       "18         False  774279.0        NaN          Poppermost Productions  \n",
       "19          True  772590.0        NaN                             NaN  \n",
       "20          True  640250.0        NaN                             NaN  \n",
       "21         False  768060.0        NaN                     Tero Lunkka  \n",
       "22          True  711440.0        NaN                             NaN  \n",
       "23         False  775880.0        NaN                    FrozenPepper  \n",
       "24         False  775881.0        NaN                    FrozenPepper  \n",
       "25         False  653960.0        NaN                   Casey Labrack  \n",
       "26         False  777910.0        NaN                             NaN  \n",
       "27         False  282010.0        NaN             Stainless Games Ltd  \n",
       "28         False      70.0       96.0                           Valve  \n",
       "29         False  752360.0        NaN                        dev4play  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "juego.head(30)#Revisamos a ver que tenemos, que necesitamos y que no"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "fd059afa",
   "metadata": {},
   "outputs": [],
   "source": [
    "columnas_a_eliminar = ['url', 'app_name', 'reviews_url','metascore','publisher','release_date','discount_price', 'tags','specs', 'developer','price','early_access']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "4f61ceb8",
   "metadata": {},
   "outputs": [],
   "source": [
    "juego = juego.drop(columnas_a_eliminar, axis=1) #Eliminamos las columnas que no necesitamos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "ca39481a",
   "metadata": {
    "scrolled": true
   },
   "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>genres</th>\n",
       "      <th>title</th>\n",
       "      <th>id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>['Action', 'Casual', 'Indie', 'Simulation', 'S...</td>\n",
       "      <td>Lost Summoner Kitty</td>\n",
       "      <td>761140.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>['Free to Play', 'Indie', 'RPG', 'Strategy']</td>\n",
       "      <td>Ironbound</td>\n",
       "      <td>643980.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>['Casual', 'Free to Play', 'Indie', 'Simulatio...</td>\n",
       "      <td>Real Pool 3D - Poolians</td>\n",
       "      <td>670290.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>['Action', 'Adventure', 'Casual']</td>\n",
       "      <td>弹炸人2222</td>\n",
       "      <td>767400.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>773570.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              genres                    title  \\\n",
       "0  ['Action', 'Casual', 'Indie', 'Simulation', 'S...      Lost Summoner Kitty   \n",
       "1       ['Free to Play', 'Indie', 'RPG', 'Strategy']                Ironbound   \n",
       "2  ['Casual', 'Free to Play', 'Indie', 'Simulatio...  Real Pool 3D - Poolians   \n",
       "3                  ['Action', 'Adventure', 'Casual']                  弹炸人2222   \n",
       "4                                                NaN                      NaN   \n",
       "\n",
       "         id  \n",
       "0  761140.0  \n",
       "1  643980.0  \n",
       "2  670290.0  \n",
       "3  767400.0  \n",
       "4  773570.0  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "juego.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "5c9cca64",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "numpy.float64"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(juego['id'][0]) #Hacemos la transformacion de id de tipo float a entero, la misma que realizamos anteriormente para el otro csv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "aa1adc7b",
   "metadata": {},
   "outputs": [],
   "source": [
    "juego['id'] = juego['id'].astype(str)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "5f601fba",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "str"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(juego['id'][0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "6ac0f0ff",
   "metadata": {},
   "outputs": [],
   "source": [
    "juego['id'] = juego['id'].str.replace(\".\", \"\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "283c3e7d",
   "metadata": {},
   "outputs": [],
   "source": [
    "juego['id'] = juego['id'].str.slice(stop=-1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "1fbfe07d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'761140'"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "juego['id'][0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "291addf5",
   "metadata": {},
   "outputs": [],
   "source": [
    "juego['id'] = juego['id'].replace('na', 0)\n",
    "juego['id'] = juego['id'].astype(int)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "9188d0fc",
   "metadata": {},
   "outputs": [],
   "source": [
    "aux= juego.head(4000)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "7e384565",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(32135, 3)"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "juego.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "79788381",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(4000, 3)"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "aux.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "e4301033",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\Andy\\AppData\\Local\\Temp\\ipykernel_4732\\2028637536.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\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",
      "  aux.dropna(subset=['genres'], inplace=True)\n"
     ]
    }
   ],
   "source": [
    "aux.dropna(subset=['genres'], inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "62dc311e",
   "metadata": {},
   "outputs": [],
   "source": [
    "aux.to_csv('juego_ml.csv', index=False) #Guardamos el csv que usaremos en el modelo de recomendacion"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "99759c56",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "colab": {
   "provenance": []
  },
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}