03-etl-items.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## ETL del dataset `steam_items`"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "En esta jupyter notebook se desarrolla la extracción, transformación y carga (ETL) del conjunto de datos `steam_items.json.gz`."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Descripción de Columnas en user_items.gz.json\n",
    "\n",
    "| Columna  | Descripción                                | Ejemplo                                                                                        |\n",
    "|----------|--------------------------------------------|-----------------------------------------------------------------------------------------------|\n",
    "| user_id  | Identificador único de usuario             | [76561197970982479, evcentric, maplemage]                                                     |\n",
    "| user_url | URL del perfil del usuario                 | [http://steamcommunity.com/id/evcentric]                                                      |\n",
    "| items    | Items de usuario en formato JSON           | {'item_id': '273350', 'item_name': 'Evolve Stage 2', 'playtime_forever': 58, 'playtime_2weeks': 0} |"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import gzip  # Para trabajar con archivos comprimidos en formato Gzip\n",
    "import json  # Para trabajar con datos en formato JSON\n",
    "import matplotlib.pyplot as plt  # Para crear gráficos y visualizaciones\n",
    "import numpy as np  # Para operaciones matemáticas eficientes y manipulación de arrays\n",
    "import pandas as pd  # Para el análisis y manipulación de datos en forma de DataFrames\n",
    "import pyarrow as pa  # Herramientas para trabajar con datos en formato de flecha (Arrow)\n",
    "import pyarrow.parquet as pq  # Para trabajar con archivos en formato Parquet\n",
    "import seaborn as sns  # Biblioteca de visualización de datos basada en matplotlib\n",
    "import ast # Proporciona funciones para analizar y manipular el árbol de sintaxis abstracta\n",
    "from datetime import datetime, timedelta"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>user_id</th>\n",
       "      <th>items_count</th>\n",
       "      <th>steam_id</th>\n",
       "      <th>user_url</th>\n",
       "      <th>items</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>76561197970982479</td>\n",
       "      <td>277</td>\n",
       "      <td>76561197970982479</td>\n",
       "      <td>http://steamcommunity.com/profiles/76561197970...</td>\n",
       "      <td>[{'item_id': '10', 'item_name': 'Counter-Strik...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>js41637</td>\n",
       "      <td>888</td>\n",
       "      <td>76561198035864385</td>\n",
       "      <td>http://steamcommunity.com/id/js41637</td>\n",
       "      <td>[{'item_id': '10', 'item_name': 'Counter-Strik...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>evcentric</td>\n",
       "      <td>137</td>\n",
       "      <td>76561198007712555</td>\n",
       "      <td>http://steamcommunity.com/id/evcentric</td>\n",
       "      <td>[{'item_id': '1200', 'item_name': 'Red Orchest...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Riot-Punch</td>\n",
       "      <td>328</td>\n",
       "      <td>76561197963445855</td>\n",
       "      <td>http://steamcommunity.com/id/Riot-Punch</td>\n",
       "      <td>[{'item_id': '10', 'item_name': 'Counter-Strik...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>doctr</td>\n",
       "      <td>541</td>\n",
       "      <td>76561198002099482</td>\n",
       "      <td>http://steamcommunity.com/id/doctr</td>\n",
       "      <td>[{'item_id': '300', 'item_name': 'Day of Defea...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88305</th>\n",
       "      <td>76561198323066619</td>\n",
       "      <td>22</td>\n",
       "      <td>76561198323066619</td>\n",
       "      <td>http://steamcommunity.com/profiles/76561198323...</td>\n",
       "      <td>[{'item_id': '413850', 'item_name': 'CS:GO Pla...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88306</th>\n",
       "      <td>76561198326700687</td>\n",
       "      <td>177</td>\n",
       "      <td>76561198326700687</td>\n",
       "      <td>http://steamcommunity.com/profiles/76561198326...</td>\n",
       "      <td>[{'item_id': '11020', 'item_name': 'TrackMania...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88307</th>\n",
       "      <td>XxLaughingJackClown77xX</td>\n",
       "      <td>0</td>\n",
       "      <td>76561198328759259</td>\n",
       "      <td>http://steamcommunity.com/id/XxLaughingJackClo...</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88308</th>\n",
       "      <td>76561198329548331</td>\n",
       "      <td>7</td>\n",
       "      <td>76561198329548331</td>\n",
       "      <td>http://steamcommunity.com/profiles/76561198329...</td>\n",
       "      <td>[{'item_id': '304930', 'item_name': 'Unturned'...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88309</th>\n",
       "      <td>edward_tremethick</td>\n",
       "      <td>0</td>\n",
       "      <td>76561198331598578</td>\n",
       "      <td>http://steamcommunity.com/id/edward_tremethick</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>88310 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                       user_id  items_count           steam_id  \\\n",
       "0            76561197970982479          277  76561197970982479   \n",
       "1                      js41637          888  76561198035864385   \n",
       "2                    evcentric          137  76561198007712555   \n",
       "3                   Riot-Punch          328  76561197963445855   \n",
       "4                        doctr          541  76561198002099482   \n",
       "...                        ...          ...                ...   \n",
       "88305        76561198323066619           22  76561198323066619   \n",
       "88306        76561198326700687          177  76561198326700687   \n",
       "88307  XxLaughingJackClown77xX            0  76561198328759259   \n",
       "88308        76561198329548331            7  76561198329548331   \n",
       "88309        edward_tremethick            0  76561198331598578   \n",
       "\n",
       "                                                user_url  \\\n",
       "0      http://steamcommunity.com/profiles/76561197970...   \n",
       "1                   http://steamcommunity.com/id/js41637   \n",
       "2                 http://steamcommunity.com/id/evcentric   \n",
       "3                http://steamcommunity.com/id/Riot-Punch   \n",
       "4                     http://steamcommunity.com/id/doctr   \n",
       "...                                                  ...   \n",
       "88305  http://steamcommunity.com/profiles/76561198323...   \n",
       "88306  http://steamcommunity.com/profiles/76561198326...   \n",
       "88307  http://steamcommunity.com/id/XxLaughingJackClo...   \n",
       "88308  http://steamcommunity.com/profiles/76561198329...   \n",
       "88309     http://steamcommunity.com/id/edward_tremethick   \n",
       "\n",
       "                                                   items  \n",
       "0      [{'item_id': '10', 'item_name': 'Counter-Strik...  \n",
       "1      [{'item_id': '10', 'item_name': 'Counter-Strik...  \n",
       "2      [{'item_id': '1200', 'item_name': 'Red Orchest...  \n",
       "3      [{'item_id': '10', 'item_name': 'Counter-Strik...  \n",
       "4      [{'item_id': '300', 'item_name': 'Day of Defea...  \n",
       "...                                                  ...  \n",
       "88305  [{'item_id': '413850', 'item_name': 'CS:GO Pla...  \n",
       "88306  [{'item_id': '11020', 'item_name': 'TrackMania...  \n",
       "88307                                                 []  \n",
       "88308  [{'item_id': '304930', 'item_name': 'Unturned'...  \n",
       "88309                                                 []  \n",
       "\n",
       "[88310 rows x 5 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "filas_items = []  # creamos una lista vacía para ir agregando las filas del archivo json\n",
    "with gzip.open(\"data/users_items.json.gz\", 'rt', encoding='utf-8') as file:\n",
    "    for line in file.readlines():\n",
    "        filas_items.append(ast.literal_eval(line))\n",
    "\n",
    "# Se convierte en dataframe\n",
    "items = pd.DataFrame(filas_items)\n",
    "items"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Ahora es necesario observar el número de nulos presentes en el dataset, para un posible imputación o eliminación de datos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "user_id        0.0\n",
       "items_count    0.0\n",
       "steam_id       0.0\n",
       "user_url       0.0\n",
       "items          0.0\n",
       "dtype: float64"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "items.isna().sum().sort_values(ascending= False)/len(items) * 100"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'item_id': '10',\n",
       "  'item_name': 'Counter-Strike',\n",
       "  'playtime_forever': 6,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '20',\n",
       "  'item_name': 'Team Fortress Classic',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '30',\n",
       "  'item_name': 'Day of Defeat',\n",
       "  'playtime_forever': 7,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '40',\n",
       "  'item_name': 'Deathmatch Classic',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '50',\n",
       "  'item_name': 'Half-Life: Opposing Force',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '60',\n",
       "  'item_name': 'Ricochet',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '70',\n",
       "  'item_name': 'Half-Life',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '130',\n",
       "  'item_name': 'Half-Life: Blue Shift',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '300',\n",
       "  'item_name': 'Day of Defeat: Source',\n",
       "  'playtime_forever': 4733,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '240',\n",
       "  'item_name': 'Counter-Strike: Source',\n",
       "  'playtime_forever': 1853,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '3830',\n",
       "  'item_name': 'Psychonauts',\n",
       "  'playtime_forever': 333,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '2630',\n",
       "  'item_name': 'Call of Duty 2',\n",
       "  'playtime_forever': 75,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '3900',\n",
       "  'item_name': \"Sid Meier's Civilization IV\",\n",
       "  'playtime_forever': 338,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '34440',\n",
       "  'item_name': \"Sid Meier's Civilization IV\",\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '3920',\n",
       "  'item_name': \"Sid Meier's Pirates!\",\n",
       "  'playtime_forever': 2,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '6400',\n",
       "  'item_name': 'Joint Task Force',\n",
       "  'playtime_forever': 286,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '6910',\n",
       "  'item_name': 'Deus Ex: Game of the Year Edition',\n",
       "  'playtime_forever': 2685,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '7670',\n",
       "  'item_name': 'BioShock',\n",
       "  'playtime_forever': 633,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '409710',\n",
       "  'item_name': 'BioShock Remastered',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '220',\n",
       "  'item_name': 'Half-Life 2',\n",
       "  'playtime_forever': 696,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '320',\n",
       "  'item_name': 'Half-Life 2: Deathmatch',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '340',\n",
       "  'item_name': 'Half-Life 2: Lost Coast',\n",
       "  'playtime_forever': 37,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '360',\n",
       "  'item_name': 'Half-Life Deathmatch: Source',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '380',\n",
       "  'item_name': 'Half-Life 2: Episode One',\n",
       "  'playtime_forever': 168,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '400',\n",
       "  'item_name': 'Portal',\n",
       "  'playtime_forever': 173,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '420',\n",
       "  'item_name': 'Half-Life 2: Episode Two',\n",
       "  'playtime_forever': 323,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '9340',\n",
       "  'item_name': 'Company of Heroes: Opposing Fronts',\n",
       "  'playtime_forever': 692,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '228200',\n",
       "  'item_name': 'Company of Heroes (New Steam Version)',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '11450',\n",
       "  'item_name': 'Overlord',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '7940',\n",
       "  'item_name': 'Call of Duty 4: Modern Warfare',\n",
       "  'playtime_forever': 1185,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '4700',\n",
       "  'item_name': 'Medieval II: Total War',\n",
       "  'playtime_forever': 477,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '12900',\n",
       "  'item_name': 'Audiosurf',\n",
       "  'playtime_forever': 115,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '13250',\n",
       "  'item_name': 'Unreal Gold',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '16100',\n",
       "  'item_name': 'Virtual Villagers: A New Home',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '15700',\n",
       "  'item_name': \"Oddworld: Abe's Oddysee\",\n",
       "  'playtime_forever': 28,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '15710',\n",
       "  'item_name': \"Oddworld: Abe's Exoddus\",\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '17330',\n",
       "  'item_name': 'Crysis Warhead',\n",
       "  'playtime_forever': 31,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '17340',\n",
       "  'item_name': 'Crysis Wars',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '22000',\n",
       "  'item_name': 'World of Goo',\n",
       "  'playtime_forever': 195,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '500',\n",
       "  'item_name': 'Left 4 Dead',\n",
       "  'playtime_forever': 513,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '4560',\n",
       "  'item_name': 'Company of Heroes',\n",
       "  'playtime_forever': 1061,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '17460',\n",
       "  'item_name': 'Mass Effect',\n",
       "  'playtime_forever': 1613,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '10500',\n",
       "  'item_name': 'Empire: Total War',\n",
       "  'playtime_forever': 186,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '24740',\n",
       "  'item_name': 'Burnout Paradise: The Ultimate Box',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '22200',\n",
       "  'item_name': 'Zeno Clash',\n",
       "  'playtime_forever': 271,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '26800',\n",
       "  'item_name': 'Braid',\n",
       "  'playtime_forever': 445,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '1250',\n",
       "  'item_name': 'Killing Floor',\n",
       "  'playtime_forever': 10006,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '35420',\n",
       "  'item_name': 'Killing Floor Mod: Defence Alliance 2',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '3590',\n",
       "  'item_name': 'Plants vs. Zombies: Game of the Year',\n",
       "  'playtime_forever': 4413,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '8880',\n",
       "  'item_name': 'Freedom Force',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '8890',\n",
       "  'item_name': 'Freedom Force vs. the 3rd Reich',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '23120',\n",
       "  'item_name': 'Droplitz',\n",
       "  'playtime_forever': 53,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '35700',\n",
       "  'item_name': 'Trine',\n",
       "  'playtime_forever': 199,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '10140',\n",
       "  'item_name': '3D Ultra Minigolf Adventures Deluxe',\n",
       "  'playtime_forever': 25,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '35010',\n",
       "  'item_name': 'Batman: Arkham Asylum',\n",
       "  'playtime_forever': 570,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '35140',\n",
       "  'item_name': 'Batman: Arkham Asylum GOTY Edition',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '29180',\n",
       "  'item_name': 'Osmos',\n",
       "  'playtime_forever': 940,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '15520',\n",
       "  'item_name': 'AaAaAA!!! - A Reckless Disregard for Gravity',\n",
       "  'playtime_forever': 110,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '32370',\n",
       "  'item_name': 'STAR WARS™: Knights of the Old Republic™',\n",
       "  'playtime_forever': 5,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '37700',\n",
       "  'item_name': 'Darkest of Days',\n",
       "  'playtime_forever': 782,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '6020',\n",
       "  'item_name': 'STAR WARS™ Jedi Knight: Jedi Academy™',\n",
       "  'playtime_forever': 77,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '24860',\n",
       "  'item_name': 'Battlefield 2',\n",
       "  'playtime_forever': 437,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '39530',\n",
       "  'item_name': 'Painkiller: Black Edition',\n",
       "  'playtime_forever': 503,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '550',\n",
       "  'item_name': 'Left 4 Dead 2',\n",
       "  'playtime_forever': 1474,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '223530',\n",
       "  'item_name': 'Left 4 Dead 2 Beta',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '8980',\n",
       "  'item_name': 'Borderlands',\n",
       "  'playtime_forever': 3061,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '41500',\n",
       "  'item_name': 'Torchlight',\n",
       "  'playtime_forever': 536,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '20900',\n",
       "  'item_name': 'The Witcher: Enhanced Edition',\n",
       "  'playtime_forever': 139,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '10180',\n",
       "  'item_name': 'Call of Duty: Modern Warfare 2',\n",
       "  'playtime_forever': 1886,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '10190',\n",
       "  'item_name': 'Call of Duty: Modern Warfare 2 - Multiplayer',\n",
       "  'playtime_forever': 1784,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '17450',\n",
       "  'item_name': 'Dragon Age: Origins',\n",
       "  'playtime_forever': 4431,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '3170',\n",
       "  'item_name': \"King's Bounty: Armored Princess\",\n",
       "  'playtime_forever': 1021,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '25900',\n",
       "  'item_name': \"King's Bounty: The Legend\",\n",
       "  'playtime_forever': 1389,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '31410',\n",
       "  'item_name': 'Zombie Driver',\n",
       "  'playtime_forever': 95,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '24980',\n",
       "  'item_name': 'Mass Effect 2',\n",
       "  'playtime_forever': 5001,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '8850',\n",
       "  'item_name': 'BioShock 2',\n",
       "  'playtime_forever': 1504,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '409720',\n",
       "  'item_name': 'BioShock 2 Remastered',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '46000',\n",
       "  'item_name': 'Bob Came in Pieces',\n",
       "  'playtime_forever': 11,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '33230',\n",
       "  'item_name': \"Assassin's Creed II\",\n",
       "  'playtime_forever': 1636,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '20820',\n",
       "  'item_name': 'Shatter',\n",
       "  'playtime_forever': 46,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '47700',\n",
       "  'item_name': 'Command and Conquer 4: Tiberian Twilight',\n",
       "  'playtime_forever': 85,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '24960',\n",
       "  'item_name': 'Battlefield: Bad Company 2',\n",
       "  'playtime_forever': 5716,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '43110',\n",
       "  'item_name': 'Metro 2033',\n",
       "  'playtime_forever': 834,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '8190',\n",
       "  'item_name': 'Just Cause 2',\n",
       "  'playtime_forever': 3083,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '49600',\n",
       "  'item_name': 'Beat Hazard',\n",
       "  'playtime_forever': 127,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '31220',\n",
       "  'item_name': 'Sam & Max 301: The Penal Zone',\n",
       "  'playtime_forever': 71,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '31230',\n",
       "  'item_name': 'Sam & Max 302: The Tomb of Sammun-Mak',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '31240',\n",
       "  'item_name': \"Sam & Max 303: They Stole Max's Brain!\",\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '31250',\n",
       "  'item_name': 'Sam & Max 304: Beyond the Alley of the Dolls',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '31260',\n",
       "  'item_name': 'Sam & Max 305: The City that Dares not Sleep',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '21090',\n",
       "  'item_name': 'F.E.A.R.',\n",
       "  'playtime_forever': 585,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '21110',\n",
       "  'item_name': 'F.E.A.R.: Extraction Point',\n",
       "  'playtime_forever': 146,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '21120',\n",
       "  'item_name': 'F.E.A.R.: Perseus Mandate',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '49400',\n",
       "  'item_name': 'Magic: The Gathering - Duels of the Planeswalkers',\n",
       "  'playtime_forever': 32,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '33910',\n",
       "  'item_name': 'Arma 2',\n",
       "  'playtime_forever': 3,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '33930',\n",
       "  'item_name': 'Arma 2: Operation Arrowhead',\n",
       "  'playtime_forever': 3,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '219540',\n",
       "  'item_name': 'Arma 2: Operation Arrowhead Beta (Obsolete)',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '17410',\n",
       "  'item_name': \"Mirror's Edge\",\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '205790',\n",
       "  'item_name': 'Dota 2 Test',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '50130',\n",
       "  'item_name': 'Mafia II',\n",
       "  'playtime_forever': 707,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '62100',\n",
       "  'item_name': 'Chime',\n",
       "  'playtime_forever': 50,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '31280',\n",
       "  'item_name': 'Poker Night at the Inventory',\n",
       "  'playtime_forever': 206,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '57300',\n",
       "  'item_name': 'Amnesia: The Dark Descent',\n",
       "  'playtime_forever': 12,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '21970',\n",
       "  'item_name': 'R.U.S.E',\n",
       "  'playtime_forever': 64,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '8930',\n",
       "  'item_name': \"Sid Meier's Civilization V\",\n",
       "  'playtime_forever': 10345,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '41000',\n",
       "  'item_name': 'Serious Sam HD: The First Encounter',\n",
       "  'playtime_forever': 369,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '41050',\n",
       "  'item_name': 'Serious Sam Classic: The First Encounter',\n",
       "  'playtime_forever': 76,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '41060',\n",
       "  'item_name': 'Serious Sam Classic: The Second Encounter',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '227780',\n",
       "  'item_name': 'Serious Sam Classics: Revolution',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '18040',\n",
       "  'item_name': 'DeathSpank',\n",
       "  'playtime_forever': 594,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '22380',\n",
       "  'item_name': 'Fallout: New Vegas',\n",
       "  'playtime_forever': 43,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '42700',\n",
       "  'item_name': 'Call of Duty: Black Ops',\n",
       "  'playtime_forever': 966,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '42710',\n",
       "  'item_name': 'Call of Duty: Black Ops - Multiplayer',\n",
       "  'playtime_forever': 2452,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '62000',\n",
       "  'item_name': 'Flight Control HD',\n",
       "  'playtime_forever': 25,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '40800',\n",
       "  'item_name': 'Super Meat Boy',\n",
       "  'playtime_forever': 119,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '9500',\n",
       "  'item_name': 'Gish',\n",
       "  'playtime_forever': 6,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '18700',\n",
       "  'item_name': 'And Yet It Moves',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '31270',\n",
       "  'item_name': 'Puzzle Agent',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '58200',\n",
       "  'item_name': 'Jolly Rover',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '70400',\n",
       "  'item_name': \"Recettear: An Item Shop's Tale\",\n",
       "  'playtime_forever': 537,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '41300',\n",
       "  'item_name': 'Altitude',\n",
       "  'playtime_forever': 50,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '41800',\n",
       "  'item_name': 'Gratuitous Space Battles',\n",
       "  'playtime_forever': 149,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '42500',\n",
       "  'item_name': 'DogFighter',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '49900',\n",
       "  'item_name': 'Plain Sight',\n",
       "  'playtime_forever': 23,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '55000',\n",
       "  'item_name': 'Flotilla',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '34330',\n",
       "  'item_name': 'Total War: SHOGUN 2',\n",
       "  'playtime_forever': 1538,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '63200',\n",
       "  'item_name': 'Monday Night Combat',\n",
       "  'playtime_forever': 573,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '99810',\n",
       "  'item_name': 'Bulletstorm',\n",
       "  'playtime_forever': 2,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '620',\n",
       "  'item_name': 'Portal 2',\n",
       "  'playtime_forever': 887,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '42910',\n",
       "  'item_name': 'Magicka',\n",
       "  'playtime_forever': 588,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '15500',\n",
       "  'item_name': 'The Wonderful End of the World',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '15540',\n",
       "  'item_name': '1... 2... 3... KICK IT! (Drop That Beat Like an Ugly Baby)',\n",
       "  'playtime_forever': 4,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '18500',\n",
       "  'item_name': 'Defense Grid: The Awakening',\n",
       "  'playtime_forever': 126,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '26500',\n",
       "  'item_name': 'Cogs',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '35460',\n",
       "  'item_name': 'The Ball',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '38700',\n",
       "  'item_name': 'Toki Tori',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '38720',\n",
       "  'item_name': 'RUSH',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '63700',\n",
       "  'item_name': 'BIT.TRIP BEAT',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '280',\n",
       "  'item_name': 'Half-Life: Source',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '20920',\n",
       "  'item_name': 'The Witcher 2: Assassins of Kings Enhanced Edition',\n",
       "  'playtime_forever': 1343,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '105600',\n",
       "  'item_name': 'Terraria',\n",
       "  'playtime_forever': 772,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '98200',\n",
       "  'item_name': 'Frozen Synapse',\n",
       "  'playtime_forever': 9,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '4500',\n",
       "  'item_name': 'S.T.A.L.K.E.R.: Shadow of Chernobyl',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '4540',\n",
       "  'item_name': 'Titan Quest',\n",
       "  'playtime_forever': 3,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '4550',\n",
       "  'item_name': 'Titan Quest: Immortal Throne',\n",
       "  'playtime_forever': 76,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '9480',\n",
       "  'item_name': 'Saints Row 2',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '15620',\n",
       "  'item_name': 'Warhammer® 40,000™: Dawn of War® II',\n",
       "  'playtime_forever': 2085,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '20500',\n",
       "  'item_name': 'Red Faction: Guerrilla Steam Edition',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '20570',\n",
       "  'item_name': 'Warhammer® 40,000™: Dawn of War® II - Chaos Rising™',\n",
       "  'playtime_forever': 69,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '50620',\n",
       "  'item_name': 'Darksiders',\n",
       "  'playtime_forever': 101,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '55100',\n",
       "  'item_name': 'Homefront',\n",
       "  'playtime_forever': 51,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '55140',\n",
       "  'item_name': 'MX vs. ATV Reflex',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '56400',\n",
       "  'item_name': 'Warhammer® 40,000™: Dawn of War® II – Retribution™',\n",
       "  'playtime_forever': 678,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '475150',\n",
       "  'item_name': 'Titan Quest Anniversary Edition',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '96100',\n",
       "  'item_name': 'Defy Gravity',\n",
       "  'playtime_forever': 9,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '35450',\n",
       "  'item_name': 'Rising Storm/Red Orchestra 2 Multiplayer',\n",
       "  'playtime_forever': 14194,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '236830',\n",
       "  'item_name': 'Red Orchestra 2: Heroes of Stalingrad - Single Player',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '72850',\n",
       "  'item_name': 'The Elder Scrolls V: Skyrim',\n",
       "  'playtime_forever': 2512,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '107100',\n",
       "  'item_name': 'Bastion',\n",
       "  'playtime_forever': 640,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '57690',\n",
       "  'item_name': 'Tropico 4',\n",
       "  'playtime_forever': 1815,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '91310',\n",
       "  'item_name': 'Dead Island',\n",
       "  'playtime_forever': 2078,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '113200',\n",
       "  'item_name': 'The Binding of Isaac',\n",
       "  'playtime_forever': 1494,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '65800',\n",
       "  'item_name': 'Dungeon Defenders',\n",
       "  'playtime_forever': 130,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '9200',\n",
       "  'item_name': 'RAGE',\n",
       "  'playtime_forever': 653,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '41070',\n",
       "  'item_name': 'Serious Sam 3: BFE',\n",
       "  'playtime_forever': 716,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '48950',\n",
       "  'item_name': 'Greed Corp',\n",
       "  'playtime_forever': 72,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '92800',\n",
       "  'item_name': 'SpaceChem',\n",
       "  'playtime_forever': 262,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '104700',\n",
       "  'item_name': 'Super Monday Night Combat',\n",
       "  'playtime_forever': 44,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '203770',\n",
       "  'item_name': 'Crusader Kings II',\n",
       "  'playtime_forever': 18,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '203810',\n",
       "  'item_name': 'Dear Esther',\n",
       "  'playtime_forever': 86,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '110800',\n",
       "  'item_name': 'L.A. Noire',\n",
       "  'playtime_forever': 1204,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '207610',\n",
       "  'item_name': 'The Walking Dead',\n",
       "  'playtime_forever': 798,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '98300',\n",
       "  'item_name': 'Toy Soldiers',\n",
       "  'playtime_forever': 110,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '50300',\n",
       "  'item_name': 'Spec Ops: The Line',\n",
       "  'playtime_forever': 296,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '204300',\n",
       "  'item_name': 'Awesomenauts',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '1700',\n",
       "  'item_name': 'Arx Fatalis',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '205100',\n",
       "  'item_name': 'Dishonored',\n",
       "  'playtime_forever': 1429,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '211120',\n",
       "  'item_name': 'The Political Machine',\n",
       "  'playtime_forever': 1,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '730',\n",
       "  'item_name': 'Counter-Strike: Global Offensive',\n",
       "  'playtime_forever': 23532,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '49520',\n",
       "  'item_name': 'Borderlands 2',\n",
       "  'playtime_forever': 1303,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '200260',\n",
       "  'item_name': 'Batman: Arkham City GOTY',\n",
       "  'playtime_forever': 100,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '212680',\n",
       "  'item_name': 'FTL: Faster Than Light',\n",
       "  'playtime_forever': 500,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '200710',\n",
       "  'item_name': 'Torchlight II',\n",
       "  'playtime_forever': 459,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '219150',\n",
       "  'item_name': 'Hotline Miami',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '215510',\n",
       "  'item_name': 'Rocketbirds: Hardboiled Chicken',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '8870',\n",
       "  'item_name': 'BioShock Infinite',\n",
       "  'playtime_forever': 2084,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '200510',\n",
       "  'item_name': 'XCOM: Enemy Unknown',\n",
       "  'playtime_forever': 3478,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '220240',\n",
       "  'item_name': 'Far Cry® 3',\n",
       "  'playtime_forever': 182,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '218680',\n",
       "  'item_name': 'Scribblenauts Unlimited',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '228280',\n",
       "  'item_name': \"Baldur's Gate: Enhanced Edition\",\n",
       "  'playtime_forever': 905,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '212070',\n",
       "  'item_name': 'Star Conflict',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '218230',\n",
       "  'item_name': 'PlanetSide 2',\n",
       "  'playtime_forever': 51,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '236390',\n",
       "  'item_name': 'War Thunder',\n",
       "  'playtime_forever': 50,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '3483',\n",
       "  'item_name': 'Peggle Extreme',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '203160',\n",
       "  'item_name': 'Tomb Raider',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '227080',\n",
       "  'item_name': 'Papo & Yo',\n",
       "  'playtime_forever': 81,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '233450',\n",
       "  'item_name': 'Prison Architect',\n",
       "  'playtime_forever': 24,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '43160',\n",
       "  'item_name': 'Metro: Last Light',\n",
       "  'playtime_forever': 712,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '219740',\n",
       "  'item_name': \"Don't Starve\",\n",
       "  'playtime_forever': 139,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '322330',\n",
       "  'item_name': \"Don't Starve Together\",\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '222730',\n",
       "  'item_name': 'Reus',\n",
       "  'playtime_forever': 319,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '241600',\n",
       "  'item_name': 'Rogue Legacy',\n",
       "  'playtime_forever': 73,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '238930',\n",
       "  'item_name': '7 Grand Steps, Step 1: What Ancients Begat',\n",
       "  'playtime_forever': 159,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '217140',\n",
       "  'item_name': 'Rise of the Triad',\n",
       "  'playtime_forever': 199,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '39140',\n",
       "  'item_name': 'FINAL FANTASY VII',\n",
       "  'playtime_forever': 2896,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '225080',\n",
       "  'item_name': 'Brothers - A Tale of Two Sons',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '239030',\n",
       "  'item_name': 'Papers, Please',\n",
       "  'playtime_forever': 194,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '248820',\n",
       "  'item_name': 'Risk of Rain',\n",
       "  'playtime_forever': 272,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '239350',\n",
       "  'item_name': 'Spelunky',\n",
       "  'playtime_forever': 458,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '218620',\n",
       "  'item_name': 'PAYDAY 2',\n",
       "  'playtime_forever': 574,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '206420',\n",
       "  'item_name': 'Saints Row IV',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '236850',\n",
       "  'item_name': 'Europa Universalis IV',\n",
       "  'playtime_forever': 89,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '47790',\n",
       "  'item_name': 'Medal of Honor(TM) Single Player',\n",
       "  'playtime_forever': 230,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '47830',\n",
       "  'item_name': 'Medal of Honor(TM) Multiplayer',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '250320',\n",
       "  'item_name': 'The Wolf Among Us',\n",
       "  'playtime_forever': 500,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '250900',\n",
       "  'item_name': 'The Binding of Isaac: Rebirth',\n",
       "  'playtime_forever': 329,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '204450',\n",
       "  'item_name': 'Call of Juarez Gunslinger',\n",
       "  'playtime_forever': 241,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '233270',\n",
       "  'item_name': 'Far Cry® 3 Blood Dragon',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '251990',\n",
       "  'item_name': 'Long Live The Queen',\n",
       "  'playtime_forever': 135,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '253980',\n",
       "  'item_name': 'Enclave',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '236450',\n",
       "  'item_name': 'PAC-MAN Championship Edition DX+',\n",
       "  'playtime_forever': 154,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '242050',\n",
       "  'item_name': \"Assassin's Creed IV Black Flag\",\n",
       "  'playtime_forever': 1377,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '257350',\n",
       "  'item_name': \"Baldur's Gate II: Enhanced Edition\",\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '213670',\n",
       "  'item_name': 'South Park™: The Stick of Truth™',\n",
       "  'playtime_forever': 121,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '238010',\n",
       "  'item_name': \"Deus Ex: Human Revolution - Director's Cut\",\n",
       "  'playtime_forever': 2176,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '245470',\n",
       "  'item_name': 'Democracy 3',\n",
       "  'playtime_forever': 246,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '221910',\n",
       "  'item_name': 'The Stanley Parable',\n",
       "  'playtime_forever': 157,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '260230',\n",
       "  'item_name': 'Valiant Hearts: The Great War™ / Soldats Inconnus : Mémoires de la Grande Guerre™',\n",
       "  'playtime_forever': 467,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '238430',\n",
       "  'item_name': 'Contagion',\n",
       "  'playtime_forever': 77,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '261030',\n",
       "  'item_name': 'The Walking Dead: Season Two',\n",
       "  'playtime_forever': 567,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '261570',\n",
       "  'item_name': 'Ori and the Blind Forest',\n",
       "  'playtime_forever': 39,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '263980',\n",
       "  'item_name': 'Out There Somewhere',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '39150',\n",
       "  'item_name': 'FINAL FANTASY VIII',\n",
       "  'playtime_forever': 15,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '230230',\n",
       "  'item_name': 'Divinity: Original Sin (Classic)',\n",
       "  'playtime_forever': 522,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '373420',\n",
       "  'item_name': 'Divinity: Original Sin Enhanced Edition',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '232790',\n",
       "  'item_name': 'Broken Age',\n",
       "  'playtime_forever': 216,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '237990',\n",
       "  'item_name': 'The Banner Saga',\n",
       "  'playtime_forever': 19,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '273620',\n",
       "  'item_name': 'Freespace 2',\n",
       "  'playtime_forever': 848,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '222880',\n",
       "  'item_name': 'Insurgency',\n",
       "  'playtime_forever': 3031,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '225840',\n",
       "  'item_name': 'Sven Co-op',\n",
       "  'playtime_forever': 26,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '222900',\n",
       "  'item_name': 'Dead Island: Epidemic',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '280220',\n",
       "  'item_name': 'Creeper World 3: Arc Eternal',\n",
       "  'playtime_forever': 941,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '236430',\n",
       "  'item_name': 'DARK SOULS™ II',\n",
       "  'playtime_forever': 592,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '201810',\n",
       "  'item_name': 'Wolfenstein: The New Order',\n",
       "  'playtime_forever': 599,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '294860',\n",
       "  'item_name': 'Valkyria Chronicles™',\n",
       "  'playtime_forever': 1735,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '295690',\n",
       "  'item_name': 'PARTICLE MACE',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '238460',\n",
       "  'item_name': 'BattleBlock Theater',\n",
       "  'playtime_forever': 407,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '237930',\n",
       "  'item_name': 'Transistor',\n",
       "  'playtime_forever': 154,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '301480',\n",
       "  'item_name': 'GEARCRACK Arena',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '303390',\n",
       "  'item_name': 'Dead Bits',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '306660',\n",
       "  'item_name': 'Ultimate General: Gettysburg',\n",
       "  'playtime_forever': 1245,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '316790',\n",
       "  'item_name': 'Grim Fandango Remastered',\n",
       "  'playtime_forever': 42,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '318430',\n",
       "  'item_name': 'Squishy the Suicidal Pig',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '241930',\n",
       "  'item_name': 'Middle-earth: Shadow of Mordor',\n",
       "  'playtime_forever': 889,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '328080',\n",
       "  'item_name': 'Retro-Pixel Castles',\n",
       "  'playtime_forever': 5,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '282070',\n",
       "  'item_name': 'This War of Mine',\n",
       "  'playtime_forever': 3,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '333930',\n",
       "  'item_name': 'Dirty Bomb',\n",
       "  'playtime_forever': 2782,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '334120',\n",
       "  'item_name': 'Armikrog',\n",
       "  'playtime_forever': 109,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '257510',\n",
       "  'item_name': 'The Talos Principle',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '319630',\n",
       "  'item_name': 'Life Is Strange™',\n",
       "  'playtime_forever': 37,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '346010',\n",
       "  'item_name': 'Besiege',\n",
       "  'playtime_forever': 464,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '255710',\n",
       "  'item_name': 'Cities: Skylines',\n",
       "  'playtime_forever': 246,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '232090',\n",
       "  'item_name': 'Killing Floor 2',\n",
       "  'playtime_forever': 6494,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '232150',\n",
       "  'item_name': 'Killing Floor 2 - SDK',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '377160',\n",
       "  'item_name': 'Fallout 4',\n",
       "  'playtime_forever': 2001,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '340170',\n",
       "  'item_name': 'FINAL FANTASY TYPE-0 HD',\n",
       "  'playtime_forever': 170,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '391540',\n",
       "  'item_name': 'Undertale',\n",
       "  'playtime_forever': 395,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '396660',\n",
       "  'item_name': 'Tahira: Echoes of the Astral Empire',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '337000',\n",
       "  'item_name': 'Deus Ex: Mankind Divided™',\n",
       "  'playtime_forever': 1159,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '368230',\n",
       "  'item_name': 'Kingdom: Classic',\n",
       "  'playtime_forever': 83,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '496300',\n",
       "  'item_name': 'Kingdom: New Lands',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '231430',\n",
       "  'item_name': 'Company of Heroes 2',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '289130',\n",
       "  'item_name': 'Endless Legend',\n",
       "  'playtime_forever': 593,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '268500',\n",
       "  'item_name': 'XCOM 2',\n",
       "  'playtime_forever': 1495,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '461640',\n",
       "  'item_name': 'Sins Of The Demon RPG',\n",
       "  'playtime_forever': 0,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '379720',\n",
       "  'item_name': 'DOOM',\n",
       "  'playtime_forever': 793,\n",
       "  'playtime_2weeks': 0},\n",
       " {'item_id': '273350',\n",
       "  'item_name': 'Evolve Stage 2',\n",
       "  'playtime_forever': 58,\n",
       "  'playtime_2weeks': 0}]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Se explora la columna items\n",
    "items['items'][0]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "| Campo             | Descripción                                                      |\n",
    "|-------------------|------------------------------------------------------------------|\n",
    "| user_id           | Identificador único del usuario.                                  |\n",
    "| items_count       | Número entero que indica la cantidad de juegos consumidos por el usuario.  |\n",
    "| steam_id          | Número único para la plataforma Steam.                            |\n",
    "| user_url          | URL del perfil del usuario.                                       |\n",
    "| items             | Lista de uno o más diccionarios que describen los items consumidos por el usuario. Cada diccionario tiene las siguientes claves: |\n",
    "|   - item_id       | Identificador del item (juego).                                   |\n",
    "|   - item_name     | Nombre del contenido consumido (juego).                           |\n",
    "|   - playtime_forever | Tiempo acumulado que el usuario ha jugado al juego.              |\n",
    "|   - playtime_2weeks  | Tiempo acumulado que el usuario ha jugado al juego en las últimas dos semanas. |\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>item_id</th>\n",
       "      <th>item_name</th>\n",
       "      <th>playtime_forever</th>\n",
       "      <th>playtime_2weeks</th>\n",
       "      <th>steam_id</th>\n",
       "      <th>items_count</th>\n",
       "      <th>user_id</th>\n",
       "      <th>user_url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>10</td>\n",
       "      <td>Counter-Strike</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>76561197970982479</td>\n",
       "      <td>277</td>\n",
       "      <td>76561197970982479</td>\n",
       "      <td>http://steamcommunity.com/profiles/76561197970...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20</td>\n",
       "      <td>Team Fortress Classic</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>76561197970982479</td>\n",
       "      <td>277</td>\n",
       "      <td>76561197970982479</td>\n",
       "      <td>http://steamcommunity.com/profiles/76561197970...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>30</td>\n",
       "      <td>Day of Defeat</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>76561197970982479</td>\n",
       "      <td>277</td>\n",
       "      <td>76561197970982479</td>\n",
       "      <td>http://steamcommunity.com/profiles/76561197970...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>40</td>\n",
       "      <td>Deathmatch Classic</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>76561197970982479</td>\n",
       "      <td>277</td>\n",
       "      <td>76561197970982479</td>\n",
       "      <td>http://steamcommunity.com/profiles/76561197970...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>50</td>\n",
       "      <td>Half-Life: Opposing Force</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>76561197970982479</td>\n",
       "      <td>277</td>\n",
       "      <td>76561197970982479</td>\n",
       "      <td>http://steamcommunity.com/profiles/76561197970...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5153204</th>\n",
       "      <td>346330</td>\n",
       "      <td>BrainBread 2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>76561198329548331</td>\n",
       "      <td>7</td>\n",
       "      <td>76561198329548331</td>\n",
       "      <td>http://steamcommunity.com/profiles/76561198329...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5153205</th>\n",
       "      <td>373330</td>\n",
       "      <td>All Is Dust</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>76561198329548331</td>\n",
       "      <td>7</td>\n",
       "      <td>76561198329548331</td>\n",
       "      <td>http://steamcommunity.com/profiles/76561198329...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5153206</th>\n",
       "      <td>388490</td>\n",
       "      <td>One Way To Die: Steam Edition</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>76561198329548331</td>\n",
       "      <td>7</td>\n",
       "      <td>76561198329548331</td>\n",
       "      <td>http://steamcommunity.com/profiles/76561198329...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5153207</th>\n",
       "      <td>521570</td>\n",
       "      <td>You Have 10 Seconds 2</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>76561198329548331</td>\n",
       "      <td>7</td>\n",
       "      <td>76561198329548331</td>\n",
       "      <td>http://steamcommunity.com/profiles/76561198329...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5153208</th>\n",
       "      <td>519140</td>\n",
       "      <td>Minds Eyes</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>76561198329548331</td>\n",
       "      <td>7</td>\n",
       "      <td>76561198329548331</td>\n",
       "      <td>http://steamcommunity.com/profiles/76561198329...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5153209 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        item_id                      item_name  playtime_forever  \\\n",
       "0            10                 Counter-Strike                 6   \n",
       "1            20          Team Fortress Classic                 0   \n",
       "2            30                  Day of Defeat                 7   \n",
       "3            40             Deathmatch Classic                 0   \n",
       "4            50      Half-Life: Opposing Force                 0   \n",
       "...         ...                            ...               ...   \n",
       "5153204  346330                   BrainBread 2                 0   \n",
       "5153205  373330                    All Is Dust                 0   \n",
       "5153206  388490  One Way To Die: Steam Edition                 3   \n",
       "5153207  521570          You Have 10 Seconds 2                 4   \n",
       "5153208  519140                     Minds Eyes                 3   \n",
       "\n",
       "         playtime_2weeks           steam_id items_count            user_id  \\\n",
       "0                      0  76561197970982479         277  76561197970982479   \n",
       "1                      0  76561197970982479         277  76561197970982479   \n",
       "2                      0  76561197970982479         277  76561197970982479   \n",
       "3                      0  76561197970982479         277  76561197970982479   \n",
       "4                      0  76561197970982479         277  76561197970982479   \n",
       "...                  ...                ...         ...                ...   \n",
       "5153204                0  76561198329548331           7  76561198329548331   \n",
       "5153205                0  76561198329548331           7  76561198329548331   \n",
       "5153206                3  76561198329548331           7  76561198329548331   \n",
       "5153207                4  76561198329548331           7  76561198329548331   \n",
       "5153208                3  76561198329548331           7  76561198329548331   \n",
       "\n",
       "                                                  user_url  \n",
       "0        http://steamcommunity.com/profiles/76561197970...  \n",
       "1        http://steamcommunity.com/profiles/76561197970...  \n",
       "2        http://steamcommunity.com/profiles/76561197970...  \n",
       "3        http://steamcommunity.com/profiles/76561197970...  \n",
       "4        http://steamcommunity.com/profiles/76561197970...  \n",
       "...                                                    ...  \n",
       "5153204  http://steamcommunity.com/profiles/76561198329...  \n",
       "5153205  http://steamcommunity.com/profiles/76561198329...  \n",
       "5153206  http://steamcommunity.com/profiles/76561198329...  \n",
       "5153207  http://steamcommunity.com/profiles/76561198329...  \n",
       "5153208  http://steamcommunity.com/profiles/76561198329...  \n",
       "\n",
       "[5153209 rows x 8 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# se normaliza la columna 'items'\n",
    "items_norm = pd.json_normalize(filas_items, record_path=['items'], meta=['steam_id','items_count','user_id', 'user_url'] )\n",
    "items_norm"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>item_id</th>\n",
       "      <th>item_name</th>\n",
       "      <th>playtime_forever</th>\n",
       "      <th>playtime_2weeks</th>\n",
       "      <th>steam_id</th>\n",
       "      <th>items_count</th>\n",
       "      <th>user_id</th>\n",
       "      <th>user_url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>164294</th>\n",
       "      <td>20</td>\n",
       "      <td>Team Fortress Classic</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>76561198084006094</td>\n",
       "      <td>109</td>\n",
       "      <td>Nikiad</td>\n",
       "      <td>http://steamcommunity.com/id/Nikiad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164295</th>\n",
       "      <td>50</td>\n",
       "      <td>Half-Life: Opposing Force</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>76561198084006094</td>\n",
       "      <td>109</td>\n",
       "      <td>Nikiad</td>\n",
       "      <td>http://steamcommunity.com/id/Nikiad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164296</th>\n",
       "      <td>70</td>\n",
       "      <td>Half-Life</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>76561198084006094</td>\n",
       "      <td>109</td>\n",
       "      <td>Nikiad</td>\n",
       "      <td>http://steamcommunity.com/id/Nikiad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164297</th>\n",
       "      <td>130</td>\n",
       "      <td>Half-Life: Blue Shift</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>76561198084006094</td>\n",
       "      <td>109</td>\n",
       "      <td>Nikiad</td>\n",
       "      <td>http://steamcommunity.com/id/Nikiad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164298</th>\n",
       "      <td>220</td>\n",
       "      <td>Half-Life 2</td>\n",
       "      <td>198</td>\n",
       "      <td>0</td>\n",
       "      <td>76561198084006094</td>\n",
       "      <td>109</td>\n",
       "      <td>Nikiad</td>\n",
       "      <td>http://steamcommunity.com/id/Nikiad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4898223</th>\n",
       "      <td>213670</td>\n",
       "      <td>South Park™: The Stick of Truth™</td>\n",
       "      <td>725</td>\n",
       "      <td>0</td>\n",
       "      <td>76561198080057659</td>\n",
       "      <td>39</td>\n",
       "      <td>76561198080057659</td>\n",
       "      <td>http://steamcommunity.com/profiles/76561198080...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4898224</th>\n",
       "      <td>221910</td>\n",
       "      <td>The Stanley Parable</td>\n",
       "      <td>53</td>\n",
       "      <td>0</td>\n",
       "      <td>76561198080057659</td>\n",
       "      <td>39</td>\n",
       "      <td>76561198080057659</td>\n",
       "      <td>http://steamcommunity.com/profiles/76561198080...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4898225</th>\n",
       "      <td>261030</td>\n",
       "      <td>The Walking Dead: Season Two</td>\n",
       "      <td>253</td>\n",
       "      <td>0</td>\n",
       "      <td>76561198080057659</td>\n",
       "      <td>39</td>\n",
       "      <td>76561198080057659</td>\n",
       "      <td>http://steamcommunity.com/profiles/76561198080...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4898226</th>\n",
       "      <td>273110</td>\n",
       "      <td>Counter-Strike Nexon: Zombies</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>76561198080057659</td>\n",
       "      <td>39</td>\n",
       "      <td>76561198080057659</td>\n",
       "      <td>http://steamcommunity.com/profiles/76561198080...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4898227</th>\n",
       "      <td>730</td>\n",
       "      <td>Counter-Strike: Global Offensive</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>76561198080057659</td>\n",
       "      <td>39</td>\n",
       "      <td>76561198080057659</td>\n",
       "      <td>http://steamcommunity.com/profiles/76561198080...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>59104 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        item_id                         item_name  playtime_forever  \\\n",
       "164294       20             Team Fortress Classic                 5   \n",
       "164295       50         Half-Life: Opposing Force                 0   \n",
       "164296       70                         Half-Life                 0   \n",
       "164297      130             Half-Life: Blue Shift                 0   \n",
       "164298      220                       Half-Life 2               198   \n",
       "...         ...                               ...               ...   \n",
       "4898223  213670  South Park™: The Stick of Truth™               725   \n",
       "4898224  221910               The Stanley Parable                53   \n",
       "4898225  261030      The Walking Dead: Season Two               253   \n",
       "4898226  273110     Counter-Strike Nexon: Zombies                 0   \n",
       "4898227     730  Counter-Strike: Global Offensive                 0   \n",
       "\n",
       "         playtime_2weeks           steam_id items_count            user_id  \\\n",
       "164294                 0  76561198084006094         109             Nikiad   \n",
       "164295                 0  76561198084006094         109             Nikiad   \n",
       "164296                 0  76561198084006094         109             Nikiad   \n",
       "164297                 0  76561198084006094         109             Nikiad   \n",
       "164298                 0  76561198084006094         109             Nikiad   \n",
       "...                  ...                ...         ...                ...   \n",
       "4898223                0  76561198080057659          39  76561198080057659   \n",
       "4898224                0  76561198080057659          39  76561198080057659   \n",
       "4898225                0  76561198080057659          39  76561198080057659   \n",
       "4898226                0  76561198080057659          39  76561198080057659   \n",
       "4898227                0  76561198080057659          39  76561198080057659   \n",
       "\n",
       "                                                  user_url  \n",
       "164294                 http://steamcommunity.com/id/Nikiad  \n",
       "164295                 http://steamcommunity.com/id/Nikiad  \n",
       "164296                 http://steamcommunity.com/id/Nikiad  \n",
       "164297                 http://steamcommunity.com/id/Nikiad  \n",
       "164298                 http://steamcommunity.com/id/Nikiad  \n",
       "...                                                    ...  \n",
       "4898223  http://steamcommunity.com/profiles/76561198080...  \n",
       "4898224  http://steamcommunity.com/profiles/76561198080...  \n",
       "4898225  http://steamcommunity.com/profiles/76561198080...  \n",
       "4898226  http://steamcommunity.com/profiles/76561198080...  \n",
       "4898227  http://steamcommunity.com/profiles/76561198080...  \n",
       "\n",
       "[59104 rows x 8 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "duplicados = items_norm.loc[items_norm.duplicated()]\n",
    "duplicados"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>item_id</th>\n",
       "      <th>item_name</th>\n",
       "      <th>playtime_forever</th>\n",
       "      <th>playtime_2weeks</th>\n",
       "      <th>steam_id</th>\n",
       "      <th>items_count</th>\n",
       "      <th>user_id</th>\n",
       "      <th>user_url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>10</td>\n",
       "      <td>Counter-Strike</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>76561197970982479</td>\n",
       "      <td>277</td>\n",
       "      <td>76561197970982479</td>\n",
       "      <td>http://steamcommunity.com/profiles/76561197970...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20</td>\n",
       "      <td>Team Fortress Classic</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>76561197970982479</td>\n",
       "      <td>277</td>\n",
       "      <td>76561197970982479</td>\n",
       "      <td>http://steamcommunity.com/profiles/76561197970...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>30</td>\n",
       "      <td>Day of Defeat</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>76561197970982479</td>\n",
       "      <td>277</td>\n",
       "      <td>76561197970982479</td>\n",
       "      <td>http://steamcommunity.com/profiles/76561197970...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>40</td>\n",
       "      <td>Deathmatch Classic</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>76561197970982479</td>\n",
       "      <td>277</td>\n",
       "      <td>76561197970982479</td>\n",
       "      <td>http://steamcommunity.com/profiles/76561197970...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>50</td>\n",
       "      <td>Half-Life: Opposing Force</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>76561197970982479</td>\n",
       "      <td>277</td>\n",
       "      <td>76561197970982479</td>\n",
       "      <td>http://steamcommunity.com/profiles/76561197970...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5153204</th>\n",
       "      <td>346330</td>\n",
       "      <td>BrainBread 2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>76561198329548331</td>\n",
       "      <td>7</td>\n",
       "      <td>76561198329548331</td>\n",
       "      <td>http://steamcommunity.com/profiles/76561198329...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5153205</th>\n",
       "      <td>373330</td>\n",
       "      <td>All Is Dust</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>76561198329548331</td>\n",
       "      <td>7</td>\n",
       "      <td>76561198329548331</td>\n",
       "      <td>http://steamcommunity.com/profiles/76561198329...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5153206</th>\n",
       "      <td>388490</td>\n",
       "      <td>One Way To Die: Steam Edition</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>76561198329548331</td>\n",
       "      <td>7</td>\n",
       "      <td>76561198329548331</td>\n",
       "      <td>http://steamcommunity.com/profiles/76561198329...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5153207</th>\n",
       "      <td>521570</td>\n",
       "      <td>You Have 10 Seconds 2</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>76561198329548331</td>\n",
       "      <td>7</td>\n",
       "      <td>76561198329548331</td>\n",
       "      <td>http://steamcommunity.com/profiles/76561198329...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5153208</th>\n",
       "      <td>519140</td>\n",
       "      <td>Minds Eyes</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>76561198329548331</td>\n",
       "      <td>7</td>\n",
       "      <td>76561198329548331</td>\n",
       "      <td>http://steamcommunity.com/profiles/76561198329...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5094105 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        item_id                      item_name  playtime_forever  \\\n",
       "0            10                 Counter-Strike                 6   \n",
       "1            20          Team Fortress Classic                 0   \n",
       "2            30                  Day of Defeat                 7   \n",
       "3            40             Deathmatch Classic                 0   \n",
       "4            50      Half-Life: Opposing Force                 0   \n",
       "...         ...                            ...               ...   \n",
       "5153204  346330                   BrainBread 2                 0   \n",
       "5153205  373330                    All Is Dust                 0   \n",
       "5153206  388490  One Way To Die: Steam Edition                 3   \n",
       "5153207  521570          You Have 10 Seconds 2                 4   \n",
       "5153208  519140                     Minds Eyes                 3   \n",
       "\n",
       "         playtime_2weeks           steam_id items_count            user_id  \\\n",
       "0                      0  76561197970982479         277  76561197970982479   \n",
       "1                      0  76561197970982479         277  76561197970982479   \n",
       "2                      0  76561197970982479         277  76561197970982479   \n",
       "3                      0  76561197970982479         277  76561197970982479   \n",
       "4                      0  76561197970982479         277  76561197970982479   \n",
       "...                  ...                ...         ...                ...   \n",
       "5153204                0  76561198329548331           7  76561198329548331   \n",
       "5153205                0  76561198329548331           7  76561198329548331   \n",
       "5153206                3  76561198329548331           7  76561198329548331   \n",
       "5153207                4  76561198329548331           7  76561198329548331   \n",
       "5153208                3  76561198329548331           7  76561198329548331   \n",
       "\n",
       "                                                  user_url  \n",
       "0        http://steamcommunity.com/profiles/76561197970...  \n",
       "1        http://steamcommunity.com/profiles/76561197970...  \n",
       "2        http://steamcommunity.com/profiles/76561197970...  \n",
       "3        http://steamcommunity.com/profiles/76561197970...  \n",
       "4        http://steamcommunity.com/profiles/76561197970...  \n",
       "...                                                    ...  \n",
       "5153204  http://steamcommunity.com/profiles/76561198329...  \n",
       "5153205  http://steamcommunity.com/profiles/76561198329...  \n",
       "5153206  http://steamcommunity.com/profiles/76561198329...  \n",
       "5153207  http://steamcommunity.com/profiles/76561198329...  \n",
       "5153208  http://steamcommunity.com/profiles/76561198329...  \n",
       "\n",
       "[5094105 rows x 8 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "items_norm = items_norm.drop_duplicates(keep='first')\n",
    "items_norm"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['item_id', 'item_name', 'playtime_forever', 'steam_id', 'items_count',\n",
       "       'user_id', 'user_url'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "items_norm = items_norm.drop('playtime_2weeks', axis=1)\n",
    "items_norm.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "playtime_forever\n",
       "0        1847730\n",
       "1         101586\n",
       "2          34391\n",
       "3          31530\n",
       "4          29127\n",
       "          ...   \n",
       "76541          1\n",
       "64676          1\n",
       "53328          1\n",
       "44029          1\n",
       "34753          1\n",
       "Name: count, Length: 48861, dtype: int64"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "items_norm['playtime_forever'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Filtramos y mantenemos solo las filas donde playtime_forever no es igual a 0\n",
    "items_norm = items_norm[items_norm['playtime_forever'] != 0].reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Pasamos el tiempo de juego total a horas\n",
    "items_norm['playtime_forever'] = round(items_norm['playtime_forever']/60,2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 3246375 entries, 0 to 3246374\n",
      "Data columns (total 7 columns):\n",
      " #   Column            Dtype  \n",
      "---  ------            -----  \n",
      " 0   item_id           object \n",
      " 1   item_name         object \n",
      " 2   playtime_forever  float64\n",
      " 3   steam_id          object \n",
      " 4   items_count       object \n",
      " 5   user_id           object \n",
      " 6   user_url          object \n",
      "dtypes: float64(1), object(6)\n",
      "memory usage: 173.4+ MB\n"
     ]
    }
   ],
   "source": [
    "items_norm.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Eliminamos la columna 'usr_url'\n",
    "items_norm = items_norm.drop(['user_url'], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "items_norm.to_csv(\"data/03-users-items.csv\", index=False, encoding=\"utf-8\") "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "items_norm = pd.read_csv(\"data/03-users-items.csv\") # leemos el archivo csv\n",
    "\n",
    "tabla = pa.Table.from_pandas(items_norm) # convertimos el dataframe en una tabla de pyarrow\n",
    "pq.write_table(tabla,\"data/03-users-items.parquet\") # guardamos la tabla en un archivo parquet"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "env",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.12.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}