process.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import urllib.request\n",
    "import os\n",
    "from progressbar import ProgressBar"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "game_data = pd.read_csv(project_path+'data/total_data.csv')\n",
    "game_data.set_index('AppID', inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "29729"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(game_data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      " 54% |######################################                                  |\r"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Game #661700 do not have a header image.\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "100% |########################################################################|\n"
     ]
    }
   ],
   "source": [
    "pbar = ProgressBar()\n",
    "for id in pbar(list(game_data.index)):\n",
    "    if not os.path.exists(project_path+'img/'+str(id)+'.jpg'):\n",
    "        try:\n",
    "            urllib.request.urlretrieve(pre_url+str(id)+post_url, project_path+'img/'+str(id)+'.jpg')\n",
    "        except:\n",
    "            print('Game #%d do not have a header image.' % id)\n",
    "            continue"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Looking in indexes: https://pypi.python.org/simple, https://pypi.apple.com/simple\n",
      "Collecting ProgressBar\n",
      "  Using cached https://files.pythonhosted.org/packages/a3/a6/b8e451f6cff1c99b4747a2f7235aa904d2d49e8e1464e0b798272aa84358/progressbar-2.5.tar.gz\n",
      "Building wheels for collected packages: ProgressBar\n",
      "  Building wheel for ProgressBar (setup.py) ... \u001b[?25ldone\n",
      "\u001b[?25h  Stored in directory: /Users/aaron/Library/Caches/pip/wheels/c0/e9/6b/ea01090205e285175842339aa3b491adeb4015206cda272ff0\n",
      "Successfully built ProgressBar\n",
      "Installing collected packages: ProgressBar\n",
      "Successfully installed ProgressBar-2.5\n"
     ]
    }
   ],
   "source": [
    "!pip3 install ProgressBar"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "games = pd.read_csv(project_path+'nodes_processed.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "games.set_index('id', inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "processed = games.join(game_data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "processed.to_csv(path_or_buf=project_path+'nodes_total_data.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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>img</th>\n",
       "      <th>Name</th>\n",
       "      <th>Positive</th>\n",
       "      <th>Negative</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Current</th>\n",
       "      <th>24h Peak</th>\n",
       "      <th>All-Time Peak</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>585290</th>\n",
       "      <td>585290</td>\n",
       "      <td>Lifeline</td>\n",
       "      <td>75</td>\n",
       "      <td>35</td>\n",
       "      <td>63.78%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>648070</th>\n",
       "      <td>648070</td>\n",
       "      <td>Crisis Action VR</td>\n",
       "      <td>14</td>\n",
       "      <td>10</td>\n",
       "      <td>55.17%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>485490</th>\n",
       "      <td>485490</td>\n",
       "      <td>Dungeon Journey</td>\n",
       "      <td>162</td>\n",
       "      <td>41</td>\n",
       "      <td>73.79%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>932930</th>\n",
       "      <td>932930</td>\n",
       "      <td>Sexy Girls Puzzle</td>\n",
       "      <td>10</td>\n",
       "      <td>9</td>\n",
       "      <td>51.56%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>822650</th>\n",
       "      <td>822650</td>\n",
       "      <td>Typical Nightmare</td>\n",
       "      <td>32</td>\n",
       "      <td>47</td>\n",
       "      <td>43.04%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>692830</th>\n",
       "      <td>692830</td>\n",
       "      <td>Fear Of Nightmares: Madness Descent</td>\n",
       "      <td>12</td>\n",
       "      <td>6</td>\n",
       "      <td>59.80%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>522570</th>\n",
       "      <td>522570</td>\n",
       "      <td>The Last Hope</td>\n",
       "      <td>277</td>\n",
       "      <td>471</td>\n",
       "      <td>38.80%</td>\n",
       "      <td>3</td>\n",
       "      <td>778</td>\n",
       "      <td>2,051</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>761110</th>\n",
       "      <td>761110</td>\n",
       "      <td>Infinity Escape</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>50.00%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>569430</th>\n",
       "      <td>569430</td>\n",
       "      <td>A Demon's Game - Episode 1</td>\n",
       "      <td>27</td>\n",
       "      <td>12</td>\n",
       "      <td>62.90%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>755230</th>\n",
       "      <td>755230</td>\n",
       "      <td>Target speed</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>50.00%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>546980</th>\n",
       "      <td>546980</td>\n",
       "      <td>Midnight Carnival</td>\n",
       "      <td>51</td>\n",
       "      <td>139</td>\n",
       "      <td>31.61%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>355410</th>\n",
       "      <td>355410</td>\n",
       "      <td>Radium</td>\n",
       "      <td>122</td>\n",
       "      <td>28</td>\n",
       "      <td>74.41%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>346800</th>\n",
       "      <td>346800</td>\n",
       "      <td>Damnation City of Death</td>\n",
       "      <td>29</td>\n",
       "      <td>45</td>\n",
       "      <td>42.14%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>976360</th>\n",
       "      <td>976360</td>\n",
       "      <td>Cotrio</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>67.06%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>440450</th>\n",
       "      <td>440450</td>\n",
       "      <td>Escape: Sierra Leone</td>\n",
       "      <td>30</td>\n",
       "      <td>18</td>\n",
       "      <td>58.63%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>937980</th>\n",
       "      <td>937980</td>\n",
       "      <td>Jellyfish Season</td>\n",
       "      <td>40</td>\n",
       "      <td>17</td>\n",
       "      <td>64.23%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>995170</th>\n",
       "      <td>995170</td>\n",
       "      <td>Aim Trainer 3D</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>59.42%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>497350</th>\n",
       "      <td>497350</td>\n",
       "      <td>Conclusion</td>\n",
       "      <td>75</td>\n",
       "      <td>130</td>\n",
       "      <td>39.28%</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>1,973</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>577580</th>\n",
       "      <td>577580</td>\n",
       "      <td>Gladiator: Sword of Vengeance</td>\n",
       "      <td>21</td>\n",
       "      <td>6</td>\n",
       "      <td>67.59%</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>427760</th>\n",
       "      <td>427760</td>\n",
       "      <td>A Chair in a Room: Greenwater</td>\n",
       "      <td>474</td>\n",
       "      <td>67</td>\n",
       "      <td>81.96%</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>445750</th>\n",
       "      <td>445750</td>\n",
       "      <td>Settled</td>\n",
       "      <td>97</td>\n",
       "      <td>12</td>\n",
       "      <td>79.52%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>748730</th>\n",
       "      <td>748730</td>\n",
       "      <td>Seek Not a Lighthouse</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>66.62%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>705300</th>\n",
       "      <td>705300</td>\n",
       "      <td>Suicide Adventures</td>\n",
       "      <td>16</td>\n",
       "      <td>18</td>\n",
       "      <td>48.07%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>514500</th>\n",
       "      <td>514500</td>\n",
       "      <td>Atomic Society</td>\n",
       "      <td>211</td>\n",
       "      <td>70</td>\n",
       "      <td>70.50%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>940130</th>\n",
       "      <td>940130</td>\n",
       "      <td>Red and Blue ~ Cycles of Existence</td>\n",
       "      <td>38</td>\n",
       "      <td>12</td>\n",
       "      <td>68.04%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>687730</th>\n",
       "      <td>687730</td>\n",
       "      <td>My Way VR</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>40.40%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>501440</th>\n",
       "      <td>501440</td>\n",
       "      <td>Stars</td>\n",
       "      <td>11</td>\n",
       "      <td>6</td>\n",
       "      <td>58.55%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1097620</th>\n",
       "      <td>1097620</td>\n",
       "      <td>Fast and Low</td>\n",
       "      <td>16</td>\n",
       "      <td>3</td>\n",
       "      <td>70.33%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>817460</th>\n",
       "      <td>817460</td>\n",
       "      <td>Sea Dogs: Caribbean Tales</td>\n",
       "      <td>26</td>\n",
       "      <td>17</td>\n",
       "      <td>57.12%</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>556280</th>\n",
       "      <td>556280</td>\n",
       "      <td>Neon Prism</td>\n",
       "      <td>164</td>\n",
       "      <td>65</td>\n",
       "      <td>67.41%</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>356</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>631990</th>\n",
       "      <td>631990</td>\n",
       "      <td>Remember, Remember</td>\n",
       "      <td>20</td>\n",
       "      <td>7</td>\n",
       "      <td>65.25%</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>777870</th>\n",
       "      <td>777870</td>\n",
       "      <td>While I Sleep I am Debug</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>74.19%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>865240</th>\n",
       "      <td>865240</td>\n",
       "      <td>Jumpo Joe</td>\n",
       "      <td>22</td>\n",
       "      <td>5</td>\n",
       "      <td>69.94%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>403780</th>\n",
       "      <td>403780</td>\n",
       "      <td>Color Symphony 2</td>\n",
       "      <td>35</td>\n",
       "      <td>2</td>\n",
       "      <td>79.68%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1024780</th>\n",
       "      <td>1024780</td>\n",
       "      <td>Capture the planet: Cute War</td>\n",
       "      <td>4</td>\n",
       "      <td>7</td>\n",
       "      <td>42.82%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>332880</th>\n",
       "      <td>332880</td>\n",
       "      <td>Don't Shoot Yourself!</td>\n",
       "      <td>21</td>\n",
       "      <td>4</td>\n",
       "      <td>71.25%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>501760</th>\n",
       "      <td>501760</td>\n",
       "      <td>Francisca</td>\n",
       "      <td>166</td>\n",
       "      <td>85</td>\n",
       "      <td>63.08%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>722220</th>\n",
       "      <td>722220</td>\n",
       "      <td>Escape from here</td>\n",
       "      <td>10</td>\n",
       "      <td>26</td>\n",
       "      <td>35.27%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>807840</th>\n",
       "      <td>807840</td>\n",
       "      <td>Fuse Balls</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>57.39%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>856110</th>\n",
       "      <td>856110</td>\n",
       "      <td>Antisnake</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>80.00%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>700830</th>\n",
       "      <td>700830</td>\n",
       "      <td>Immersive Poetry</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>71.55%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>341460</th>\n",
       "      <td>341460</td>\n",
       "      <td>Fallen Temple</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>55.69%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>528860</th>\n",
       "      <td>528860</td>\n",
       "      <td>Proxy - Ultimate Hacker</td>\n",
       "      <td>12</td>\n",
       "      <td>1</td>\n",
       "      <td>73.19%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>576500</th>\n",
       "      <td>576500</td>\n",
       "      <td>Evergarden</td>\n",
       "      <td>42</td>\n",
       "      <td>2</td>\n",
       "      <td>81.00%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>330840</th>\n",
       "      <td>330840</td>\n",
       "      <td>Game of Thrones - A Telltale Games Series</td>\n",
       "      <td>8,019</td>\n",
       "      <td>2,440</td>\n",
       "      <td>75.03%</td>\n",
       "      <td>4</td>\n",
       "      <td>16</td>\n",
       "      <td>6,771</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>774321</th>\n",
       "      <td>774321</td>\n",
       "      <td>STARBO</td>\n",
       "      <td>37</td>\n",
       "      <td>31</td>\n",
       "      <td>53.18%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>681750</th>\n",
       "      <td>681750</td>\n",
       "      <td>Voxelaxy</td>\n",
       "      <td>33</td>\n",
       "      <td>15</td>\n",
       "      <td>62.94%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>391100</th>\n",
       "      <td>391100</td>\n",
       "      <td>Frizzy</td>\n",
       "      <td>10</td>\n",
       "      <td>5</td>\n",
       "      <td>59.43%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>670430</th>\n",
       "      <td>670430</td>\n",
       "      <td>Colorless Life</td>\n",
       "      <td>23</td>\n",
       "      <td>14</td>\n",
       "      <td>58.09%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>693280</th>\n",
       "      <td>693280</td>\n",
       "      <td>Zombies Berserk</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>35.92%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>623920</th>\n",
       "      <td>623920</td>\n",
       "      <td>Chicago 1930</td>\n",
       "      <td>32</td>\n",
       "      <td>9</td>\n",
       "      <td>68.94%</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>863750</th>\n",
       "      <td>863750</td>\n",
       "      <td>Krim: The Music Bot</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>64.78%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>296710</th>\n",
       "      <td>296710</td>\n",
       "      <td>Monstrum</td>\n",
       "      <td>1,543</td>\n",
       "      <td>170</td>\n",
       "      <td>85.82%</td>\n",
       "      <td>12</td>\n",
       "      <td>25</td>\n",
       "      <td>244</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>230840</th>\n",
       "      <td>230840</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>764</td>\n",
       "      <td>768</td>\n",
       "      <td>49.88%</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1,444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>211820</th>\n",
       "      <td>211820</td>\n",
       "      <td>Starbound</td>\n",
       "      <td>121,994</td>\n",
       "      <td>8,770</td>\n",
       "      <td>92.05%</td>\n",
       "      <td>3,864</td>\n",
       "      <td>7,093</td>\n",
       "      <td>88,709</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>406920</th>\n",
       "      <td>406920</td>\n",
       "      <td>Monsterland</td>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "      <td>80.30%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>804130</th>\n",
       "      <td>804130</td>\n",
       "      <td>EXIST</td>\n",
       "      <td>32</td>\n",
       "      <td>14</td>\n",
       "      <td>63.43%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499330</th>\n",
       "      <td>499330</td>\n",
       "      <td>Lord Mayor</td>\n",
       "      <td>9</td>\n",
       "      <td>6</td>\n",
       "      <td>55.66%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498620</th>\n",
       "      <td>498620</td>\n",
       "      <td>The Shadowland</td>\n",
       "      <td>20</td>\n",
       "      <td>12</td>\n",
       "      <td>58.14%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>921920</th>\n",
       "      <td>921920</td>\n",
       "      <td>Robikon</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>40.58%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>61 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             img                                       Name Positive Negative  \\\n",
       "id                                                                              \n",
       "585290    585290                                   Lifeline       75       35   \n",
       "648070    648070                           Crisis Action VR       14       10   \n",
       "485490    485490                            Dungeon Journey      162       41   \n",
       "932930    932930                          Sexy Girls Puzzle       10        9   \n",
       "822650    822650                          Typical Nightmare       32       47   \n",
       "692830    692830        Fear Of Nightmares: Madness Descent       12        6   \n",
       "522570    522570                              The Last Hope      277      471   \n",
       "761110    761110                            Infinity Escape        8        8   \n",
       "569430    569430                 A Demon's Game - Episode 1       27       12   \n",
       "755230    755230                               Target speed        3        3   \n",
       "546980    546980                          Midnight Carnival       51      139   \n",
       "355410    355410                                     Radium      122       28   \n",
       "346800    346800                    Damnation City of Death       29       45   \n",
       "976360    976360                                     Cotrio        3        0   \n",
       "440450    440450                       Escape: Sierra Leone       30       18   \n",
       "937980    937980                           Jellyfish Season       40       17   \n",
       "995170    995170                             Aim Trainer 3D        1        0   \n",
       "497350    497350                                 Conclusion       75      130   \n",
       "577580    577580              Gladiator: Sword of Vengeance       21        6   \n",
       "427760    427760              A Chair in a Room: Greenwater      474       67   \n",
       "445750    445750                                    Settled       97       12   \n",
       "748730    748730                      Seek Not a Lighthouse        6        1   \n",
       "705300    705300                         Suicide Adventures       16       18   \n",
       "514500    514500                             Atomic Society      211       70   \n",
       "940130    940130         Red and Blue ~ Cycles of Existence       38       12   \n",
       "687730    687730                                  My Way VR        1        3   \n",
       "501440    501440                                      Stars       11        6   \n",
       "1097620  1097620                               Fast and Low       16        3   \n",
       "817460    817460                  Sea Dogs: Caribbean Tales       26       17   \n",
       "556280    556280                                 Neon Prism      164       65   \n",
       "...          ...                                        ...      ...      ...   \n",
       "631990    631990                         Remember, Remember       20        7   \n",
       "777870    777870                   While I Sleep I am Debug        8        0   \n",
       "865240    865240                                  Jumpo Joe       22        5   \n",
       "403780    403780                           Color Symphony 2       35        2   \n",
       "1024780  1024780               Capture the planet: Cute War        4        7   \n",
       "332880    332880                      Don't Shoot Yourself!       21        4   \n",
       "501760    501760                                  Francisca      166       85   \n",
       "722220    722220                           Escape from here       10       26   \n",
       "807840    807840                                 Fuse Balls        4        2   \n",
       "856110    856110                                  Antisnake       20        0   \n",
       "700830    700830                           Immersive Poetry       10        1   \n",
       "341460    341460                              Fallen Temple        2        1   \n",
       "528860    528860                    Proxy - Ultimate Hacker       12        1   \n",
       "576500    576500                                 Evergarden       42        2   \n",
       "330840    330840  Game of Thrones - A Telltale Games Series    8,019    2,440   \n",
       "774321    774321                                     STARBO       37       31   \n",
       "681750    681750                                   Voxelaxy       33       15   \n",
       "391100    391100                                     Frizzy       10        5   \n",
       "670430    670430                             Colorless Life       23       14   \n",
       "693280    693280                            Zombies Berserk        0        2   \n",
       "623920    623920                               Chicago 1930       32        9   \n",
       "863750    863750                        Krim: The Music Bot        5        1   \n",
       "296710    296710                                   Monstrum    1,543      170   \n",
       "230840    230840                                   Daylight      764      768   \n",
       "211820    211820                                  Starbound  121,994    8,770   \n",
       "406920    406920                                Monsterland       30        1   \n",
       "804130    804130                                      EXIST       32       14   \n",
       "499330    499330                                 Lord Mayor        9        6   \n",
       "498620    498620                             The Shadowland       20       12   \n",
       "921920    921920                                    Robikon        0        1   \n",
       "\n",
       "         Rating Current 24h Peak All-Time Peak  \n",
       "id                                              \n",
       "585290   63.78%     NaN      NaN           NaN  \n",
       "648070   55.17%     NaN      NaN           NaN  \n",
       "485490   73.79%     NaN      NaN           NaN  \n",
       "932930   51.56%     NaN      NaN           NaN  \n",
       "822650   43.04%     NaN      NaN           NaN  \n",
       "692830   59.80%     NaN      NaN           NaN  \n",
       "522570   38.80%       3      778         2,051  \n",
       "761110   50.00%     NaN      NaN           NaN  \n",
       "569430   62.90%     NaN      NaN           NaN  \n",
       "755230   50.00%     NaN      NaN           NaN  \n",
       "546980   31.61%     NaN      NaN           NaN  \n",
       "355410   74.41%     NaN      NaN           NaN  \n",
       "346800   42.14%     NaN      NaN           NaN  \n",
       "976360   67.06%     NaN      NaN           NaN  \n",
       "440450   58.63%     NaN      NaN           NaN  \n",
       "937980   64.23%     NaN      NaN           NaN  \n",
       "995170   59.42%     NaN      NaN           NaN  \n",
       "497350   39.28%       2        5         1,973  \n",
       "577580   67.59%       1        2            22  \n",
       "427760   81.96%       1        4            48  \n",
       "445750   79.52%     NaN      NaN           NaN  \n",
       "748730   66.62%     NaN      NaN           NaN  \n",
       "705300   48.07%     NaN      NaN           NaN  \n",
       "514500   70.50%     NaN      NaN           NaN  \n",
       "940130   68.04%     NaN      NaN           NaN  \n",
       "687730   40.40%     NaN      NaN           NaN  \n",
       "501440   58.55%     NaN      NaN           NaN  \n",
       "1097620  70.33%     NaN      NaN           NaN  \n",
       "817460   57.12%       1        7            25  \n",
       "556280   67.41%       1        3           356  \n",
       "...         ...     ...      ...           ...  \n",
       "631990   65.25%       1        1            12  \n",
       "777870   74.19%     NaN      NaN           NaN  \n",
       "865240   69.94%     NaN      NaN           NaN  \n",
       "403780   79.68%     NaN      NaN           NaN  \n",
       "1024780  42.82%     NaN      NaN           NaN  \n",
       "332880   71.25%     NaN      NaN           NaN  \n",
       "501760   63.08%     NaN      NaN           NaN  \n",
       "722220   35.27%     NaN      NaN           NaN  \n",
       "807840   57.39%     NaN      NaN           NaN  \n",
       "856110   80.00%     NaN      NaN           NaN  \n",
       "700830   71.55%     NaN      NaN           NaN  \n",
       "341460   55.69%     NaN      NaN           NaN  \n",
       "528860   73.19%     NaN      NaN           NaN  \n",
       "576500   81.00%     NaN      NaN           NaN  \n",
       "330840   75.03%       4       16         6,771  \n",
       "774321   53.18%     NaN      NaN           NaN  \n",
       "681750   62.94%     NaN      NaN           NaN  \n",
       "391100   59.43%     NaN      NaN           NaN  \n",
       "670430   58.09%     NaN      NaN           NaN  \n",
       "693280   35.92%     NaN      NaN           NaN  \n",
       "623920   68.94%       1        1            18  \n",
       "863750   64.78%     NaN      NaN           NaN  \n",
       "296710   85.82%      12       25           244  \n",
       "230840   49.88%       1        3         1,444  \n",
       "211820   92.05%   3,864    7,093        88,709  \n",
       "406920   80.30%     NaN      NaN           NaN  \n",
       "804130   63.43%     NaN      NaN           NaN  \n",
       "499330   55.66%     NaN      NaN           NaN  \n",
       "498620   58.14%     NaN      NaN           NaN  \n",
       "921920   40.58%     NaN      NaN           NaN  \n",
       "\n",
       "[61 rows x 8 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "processed"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "--2019-07-22 10:54:21--  https://steamcdn-a.akamaihd.net/steam/apps/812440/header.jpg\n",
      "Resolving steamcdn-a.akamaihd.net... 202.51.247.230, 202.51.247.232\n",
      "Connecting to steamcdn-a.akamaihd.net|202.51.247.230|:443... connected.\n",
      "HTTP request sent, awaiting response... 200 OK\n",
      "Length: 20397 (20K) [image/jpeg]\n",
      "Saving to: ‘header.jpg’\n",
      "\n",
      "header.jpg          100%[===================>]  19.92K  --.-KB/s    in 0.001s  \n",
      "\n",
      "2019-07-22 10:54:22 (27.0 MB/s) - ‘header.jpg’ saved [20397/20397]\n",
      "\n"
     ]
    }
   ],
   "source": [
    "!wget https://steamcdn-a.akamaihd.net/steam/apps/812440/header.jpg"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "!mv header.jpg img/812440.jpg"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}