cleaning_final_project_data.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import matplotlib.pyplot as plt\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "import seaborn as sns\n",
    "import calendar\n",
    "from datetime import datetime\n",
    "from pandas import Series\n",
    "from math import ceil\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "steam_data = pd.read_csv('final-project-data-combined.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>App Id</th>\n",
       "      <th>Name</th>\n",
       "      <th>Developers</th>\n",
       "      <th>Publishers</th>\n",
       "      <th>Metascores</th>\n",
       "      <th>Owners</th>\n",
       "      <th>Genres</th>\n",
       "      <th>Tags</th>\n",
       "      <th>Price</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>7</td>\n",
       "      <td>Steam Client</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0Â ..Â 20,000</td>\n",
       "      <td>['']</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>8</td>\n",
       "      <td>winui2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0Â ..Â 20,000</td>\n",
       "      <td>['']</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>10</td>\n",
       "      <td>Counter-Strike</td>\n",
       "      <td>Valve</td>\n",
       "      <td>Valve</td>\n",
       "      <td>88%</td>\n",
       "      <td>10,000,000Â ..Â 20,000,000</td>\n",
       "      <td>['Action']</td>\n",
       "      <td>['Action', 'FPS', 'Multiplayer', 'Shooter', 'C...</td>\n",
       "      <td>$9.99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>20</td>\n",
       "      <td>Team Fortress Classic</td>\n",
       "      <td>Valve</td>\n",
       "      <td>Valve</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2,000,000Â ..Â 5,000,000</td>\n",
       "      <td>['Action']</td>\n",
       "      <td>['Action', 'FPS', 'Multiplayer', 'Classic', 'H...</td>\n",
       "      <td>$4.99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>30</td>\n",
       "      <td>Day of Defeat</td>\n",
       "      <td>Valve</td>\n",
       "      <td>Valve</td>\n",
       "      <td>79%</td>\n",
       "      <td>5,000,000Â ..Â 10,000,000</td>\n",
       "      <td>['Action']</td>\n",
       "      <td>['FPS', 'World War II', 'Multiplayer', 'Shoote...</td>\n",
       "      <td>$4.99</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   App Id                   Name Developers Publishers Metascores  \\\n",
       "0       7           Steam Client        NaN        NaN        NaN   \n",
       "1       8                 winui2        NaN        NaN        NaN   \n",
       "2      10         Counter-Strike      Valve      Valve        88%   \n",
       "3      20  Team Fortress Classic      Valve      Valve        NaN   \n",
       "4      30          Day of Defeat      Valve      Valve        79%   \n",
       "\n",
       "                       Owners      Genres  \\\n",
       "0               0Â ..Â 20,000        ['']   \n",
       "1               0Â ..Â 20,000        ['']   \n",
       "2  10,000,000Â ..Â 20,000,000  ['Action']   \n",
       "3    2,000,000Â ..Â 5,000,000  ['Action']   \n",
       "4   5,000,000Â ..Â 10,000,000  ['Action']   \n",
       "\n",
       "                                                Tags   Price  \n",
       "0                                                NaN  $0.00   \n",
       "1                                                NaN  $0.00   \n",
       "2  ['Action', 'FPS', 'Multiplayer', 'Shooter', 'C...  $9.99   \n",
       "3  ['Action', 'FPS', 'Multiplayer', 'Classic', 'H...  $4.99   \n",
       "4  ['FPS', 'World War II', 'Multiplayer', 'Shoote...  $4.99   "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "steam_data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "#steam_data[\"Genres\"] = \n",
    "steam_data['clean_genres']=steam_data[\"Genres\"].str.replace(' ','_').str.replace(',_', ',')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>App Id</th>\n",
       "      <th>Name</th>\n",
       "      <th>Developers</th>\n",
       "      <th>Publishers</th>\n",
       "      <th>Metascores</th>\n",
       "      <th>Owners</th>\n",
       "      <th>Genres</th>\n",
       "      <th>Tags</th>\n",
       "      <th>Price</th>\n",
       "      <th>clean_genres</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>440</td>\n",
       "      <td>Team Fortress 2</td>\n",
       "      <td>Valve</td>\n",
       "      <td>Valve</td>\n",
       "      <td>92%</td>\n",
       "      <td>50,000,000Â ..Â 100,000,000</td>\n",
       "      <td>['Action', 'Free to Play']</td>\n",
       "      <td>['Free to Play', 'Hero Shooter', 'Multiplayer'...</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>['Action','Free_to_Play']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>570</td>\n",
       "      <td>Dota 2</td>\n",
       "      <td>Valve</td>\n",
       "      <td>Valve</td>\n",
       "      <td>90%</td>\n",
       "      <td>100,000,000Â ..Â 200,000,000</td>\n",
       "      <td>['Action', 'Free to Play', 'Strategy']</td>\n",
       "      <td>['Free to Play', 'MOBA', 'Multiplayer', 'Strat...</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>['Action','Free_to_Play','Strategy']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>730</td>\n",
       "      <td>Counter-Strike: Global Offensive</td>\n",
       "      <td>Valve</td>\n",
       "      <td>Valve</td>\n",
       "      <td>83%</td>\n",
       "      <td>100,000,000Â ..Â 200,000,000</td>\n",
       "      <td>['Action', 'Free to Play']</td>\n",
       "      <td>['FPS', 'Shooter', 'Multiplayer', 'Competitive...</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>['Action','Free_to_Play']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1431</th>\n",
       "      <td>6370</td>\n",
       "      <td>Bloodline Champions</td>\n",
       "      <td>Stunlock Studios</td>\n",
       "      <td>Stunlock Studios</td>\n",
       "      <td>79%</td>\n",
       "      <td>500,000Â ..Â 1,000,000</td>\n",
       "      <td>['Action', 'Free to Play', 'Massively Multipla...</td>\n",
       "      <td>['Free to Play', 'Action', 'MOBA', 'Multiplaye...</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>['Action','Free_to_Play','Massively_Multiplayer']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1563</th>\n",
       "      <td>8500</td>\n",
       "      <td>EVE Online</td>\n",
       "      <td>CCP</td>\n",
       "      <td>CCP</td>\n",
       "      <td>88%</td>\n",
       "      <td>2,000,000Â ..Â 5,000,000</td>\n",
       "      <td>['Action', 'Free to Play', 'Massively Multipla...</td>\n",
       "      <td>['Space', 'Massively Multiplayer', 'Sci-fi', '...</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>['Action','Free_to_Play','Massively_Multiplaye...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95012</th>\n",
       "      <td>1463920</td>\n",
       "      <td>hexceed</td>\n",
       "      <td>ToastieLabs</td>\n",
       "      <td>ToastieLabs</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0Â ..Â 20,000</td>\n",
       "      <td>['Casual', 'Free to Play', 'Indie']</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>['Casual','Free_to_Play','Indie']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95058</th>\n",
       "      <td>1465240</td>\n",
       "      <td>å¤©å¨ä¼ è¯´-å‚²è§†ç‹‚åˆ€</td>\n",
       "      <td>å¤©å¨ä¼ è¯´</td>\n",
       "      <td>å¤©å¨ä¼ è¯´</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0Â ..Â 20,000</td>\n",
       "      <td>['Casual', 'Free to Play', 'Massively Multipla...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>['Casual','Free_to_Play','Massively_Multiplaye...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95077</th>\n",
       "      <td>1465860</td>\n",
       "      <td>*NEW* SCUFFED EPIC BHOP SIMULATOR 2023 (POG CH...</td>\n",
       "      <td>Chris Shanaz</td>\n",
       "      <td>Octo Gaming</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0Â ..Â 20,000</td>\n",
       "      <td>['Casual', 'Free to Play']</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>['Casual','Free_to_Play']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95090</th>\n",
       "      <td>1466660</td>\n",
       "      <td>Project Space Hunter</td>\n",
       "      <td>BigBotNetwork</td>\n",
       "      <td>BigBotNetwork</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0Â ..Â 20,000</td>\n",
       "      <td>['Action', 'Free to Play', 'Early Access']</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>['Action','Free_to_Play','Early_Access']</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95129</th>\n",
       "      <td>1468340</td>\n",
       "      <td>Space Mavericks</td>\n",
       "      <td>Fire Gecko Studio</td>\n",
       "      <td>Fire Gecko Studio</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0Â ..Â 20,000</td>\n",
       "      <td>['Adventure', 'Free to Play', 'Indie', 'RPG', ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>['Adventure','Free_to_Play','Indie','RPG','Str...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>6727 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        App Id                                               Name  \\\n",
       "36         440                                    Team Fortress 2   \n",
       "53         570                                             Dota 2   \n",
       "77         730                   Counter-Strike: Global Offensive   \n",
       "1431      6370                                Bloodline Champions   \n",
       "1563      8500                                         EVE Online   \n",
       "...        ...                                                ...   \n",
       "95012  1463920                                            hexceed   \n",
       "95058  1465240                          å¤©å¨ä¼ è¯´-å‚²è§†ç‹‚åˆ€   \n",
       "95077  1465860  *NEW* SCUFFED EPIC BHOP SIMULATOR 2023 (POG CH...   \n",
       "95090  1466660                               Project Space Hunter   \n",
       "95129  1468340                                    Space Mavericks   \n",
       "\n",
       "              Developers         Publishers Metascores  \\\n",
       "36                 Valve              Valve        92%   \n",
       "53                 Valve              Valve        90%   \n",
       "77                 Valve              Valve        83%   \n",
       "1431    Stunlock Studios   Stunlock Studios        79%   \n",
       "1563                 CCP                CCP        88%   \n",
       "...                  ...                ...        ...   \n",
       "95012        ToastieLabs        ToastieLabs        NaN   \n",
       "95058       å¤©å¨ä¼ è¯´       å¤©å¨ä¼ è¯´        NaN   \n",
       "95077       Chris Shanaz        Octo Gaming        NaN   \n",
       "95090      BigBotNetwork      BigBotNetwork        NaN   \n",
       "95129  Fire Gecko Studio  Fire Gecko Studio        NaN   \n",
       "\n",
       "                             Owners  \\\n",
       "36      50,000,000Â ..Â 100,000,000   \n",
       "53     100,000,000Â ..Â 200,000,000   \n",
       "77     100,000,000Â ..Â 200,000,000   \n",
       "1431         500,000Â ..Â 1,000,000   \n",
       "1563       2,000,000Â ..Â 5,000,000   \n",
       "...                             ...   \n",
       "95012                 0Â ..Â 20,000   \n",
       "95058                 0Â ..Â 20,000   \n",
       "95077                 0Â ..Â 20,000   \n",
       "95090                 0Â ..Â 20,000   \n",
       "95129                 0Â ..Â 20,000   \n",
       "\n",
       "                                                  Genres  \\\n",
       "36                            ['Action', 'Free to Play']   \n",
       "53                ['Action', 'Free to Play', 'Strategy']   \n",
       "77                            ['Action', 'Free to Play']   \n",
       "1431   ['Action', 'Free to Play', 'Massively Multipla...   \n",
       "1563   ['Action', 'Free to Play', 'Massively Multipla...   \n",
       "...                                                  ...   \n",
       "95012                ['Casual', 'Free to Play', 'Indie']   \n",
       "95058  ['Casual', 'Free to Play', 'Massively Multipla...   \n",
       "95077                         ['Casual', 'Free to Play']   \n",
       "95090         ['Action', 'Free to Play', 'Early Access']   \n",
       "95129  ['Adventure', 'Free to Play', 'Indie', 'RPG', ...   \n",
       "\n",
       "                                                    Tags   Price  \\\n",
       "36     ['Free to Play', 'Hero Shooter', 'Multiplayer'...  $0.00    \n",
       "53     ['Free to Play', 'MOBA', 'Multiplayer', 'Strat...  $0.00    \n",
       "77     ['FPS', 'Shooter', 'Multiplayer', 'Competitive...  $0.00    \n",
       "1431   ['Free to Play', 'Action', 'MOBA', 'Multiplaye...  $0.00    \n",
       "1563   ['Space', 'Massively Multiplayer', 'Sci-fi', '...  $0.00    \n",
       "...                                                  ...     ...   \n",
       "95012                                                NaN  $0.00    \n",
       "95058                                                NaN  $0.00    \n",
       "95077                                                NaN  $0.00    \n",
       "95090                                                NaN  $0.00    \n",
       "95129                                                NaN  $0.00    \n",
       "\n",
       "                                            clean_genres  \n",
       "36                             ['Action','Free_to_Play']  \n",
       "53                  ['Action','Free_to_Play','Strategy']  \n",
       "77                             ['Action','Free_to_Play']  \n",
       "1431   ['Action','Free_to_Play','Massively_Multiplayer']  \n",
       "1563   ['Action','Free_to_Play','Massively_Multiplaye...  \n",
       "...                                                  ...  \n",
       "95012                  ['Casual','Free_to_Play','Indie']  \n",
       "95058  ['Casual','Free_to_Play','Massively_Multiplaye...  \n",
       "95077                          ['Casual','Free_to_Play']  \n",
       "95090           ['Action','Free_to_Play','Early_Access']  \n",
       "95129  ['Adventure','Free_to_Play','Indie','RPG','Str...  \n",
       "\n",
       "[6727 rows x 10 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "steam_data[steam_data['clean_genres'].str.contains('Free')==True]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "95244"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(steam_data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'action': 5,\n",
       " 'indie': 19,\n",
       " 'free_to_play': 15,\n",
       " 'strategy': 31,\n",
       " 'adventure': 6,\n",
       " 'rpg': 25,\n",
       " 'racing': 24,\n",
       " 'casual': 9,\n",
       " 'simulation': 28,\n",
       " 'animation_': 7,\n",
       " '_modeling': 3,\n",
       " 'video_production': 34,\n",
       " 'massively_multiplayer': 20,\n",
       " 'sports': 30,\n",
       " 'early_access': 12,\n",
       " 'in_early_access': 18,\n",
       " 'photo_editing': 23,\n",
       " 'utilities': 33,\n",
       " 'design_': 10,\n",
       " '_illustration': 2,\n",
       " 'education': 13,\n",
       " 'game_development': 16,\n",
       " 'software_training': 29,\n",
       " 'web_publishing': 36,\n",
       " 'violent': 35,\n",
       " 'gore': 17,\n",
       " 'audio_production': 8,\n",
       " 'accounting': 4,\n",
       " 'nudity': 22,\n",
       " 'sexual_content': 26,\n",
       " 'documentary': 11,\n",
       " 'episodic': 14,\n",
       " 'movie': 21,\n",
       " 'short': 27,\n",
       " 'tutorial': 32,\n",
       " '360_video': 1,\n",
       " '360_v': 0}"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from sklearn.feature_extraction.text import CountVectorizer\n",
    "genres=steam_data['clean_genres'].dropna().str.replace(\"'\", '').str.replace('[', '').str.replace(']', '')\n",
    "count_vec=CountVectorizer()\n",
    "encoded=count_vec.fit_transform(genres)\n",
    "count_vec.vocabulary_"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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>action</th>\n",
       "      <th>indie</th>\n",
       "      <th>free_to_play</th>\n",
       "      <th>strategy</th>\n",
       "      <th>adventure</th>\n",
       "      <th>rpg</th>\n",
       "      <th>racing</th>\n",
       "      <th>casual</th>\n",
       "      <th>simulation</th>\n",
       "      <th>animation_</th>\n",
       "      <th>...</th>\n",
       "      <th>accounting</th>\n",
       "      <th>nudity</th>\n",
       "      <th>sexual_content</th>\n",
       "      <th>documentary</th>\n",
       "      <th>episodic</th>\n",
       "      <th>movie</th>\n",
       "      <th>short</th>\n",
       "      <th>tutorial</th>\n",
       "      <th>360_video</th>\n",
       "      <th>360_v</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95221</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95222</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95223</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95224</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95225</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>95226 rows × 37 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       action  indie  free_to_play  strategy  adventure  rpg  racing  casual  \\\n",
       "0           0      0             0         0          0    0       0       0   \n",
       "1           0      0             0         0          0    0       0       0   \n",
       "2           0      0             0         0          0    1       0       0   \n",
       "3           0      0             0         0          0    1       0       0   \n",
       "4           0      0             0         0          0    1       0       0   \n",
       "...       ...    ...           ...       ...        ...  ...     ...     ...   \n",
       "95221       0      0             0         0          0    1       0       0   \n",
       "95222       0      0             0         0          0    0       0       0   \n",
       "95223       0      0             0         0          0    0       0       0   \n",
       "95224       0      0             0         0          0    0       0       0   \n",
       "95225       0      0             0         0          0    1       0       0   \n",
       "\n",
       "       simulation  animation_  ...  accounting  nudity  sexual_content  \\\n",
       "0               0           0  ...           0       0               0   \n",
       "1               0           0  ...           0       0               0   \n",
       "2               0           0  ...           0       0               0   \n",
       "3               0           0  ...           0       0               0   \n",
       "4               0           0  ...           0       0               0   \n",
       "...           ...         ...  ...         ...     ...             ...   \n",
       "95221           0           1  ...           0       0               0   \n",
       "95222           0           0  ...           0       0               0   \n",
       "95223           0           0  ...           0       0               0   \n",
       "95224           0           0  ...           0       0               0   \n",
       "95225           0           0  ...           0       0               0   \n",
       "\n",
       "       documentary  episodic  movie  short  tutorial  360_video  360_v  \n",
       "0                0         0      0      0         0          0      0  \n",
       "1                0         0      0      0         0          0      0  \n",
       "2                0         0      0      0         0          0      0  \n",
       "3                0         0      0      0         0          0      0  \n",
       "4                0         0      0      0         0          0      0  \n",
       "...            ...       ...    ...    ...       ...        ...    ...  \n",
       "95221            0         0      0      0         0          0      0  \n",
       "95222            0         0      0      0         0          0      0  \n",
       "95223            0         0      0      0         0          0      0  \n",
       "95224            0         0      0      0         0          0      0  \n",
       "95225            0         0      0      0         0          0      0  \n",
       "\n",
       "[95226 rows x 37 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "encoded_genres= pd.DataFrame(encoded.toarray(), columns=count_vec.vocabulary_)\n",
    "encoded_genres"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[(45293, 'indie'),\n",
       " (31204, 'action'),\n",
       " (23926, 'adventure'),\n",
       " (23602, 'casual'),\n",
       " (16674, 'simulation'),\n",
       " (15878, 'strategy'),\n",
       " (14713, 'rpg'),\n",
       " (6727, 'free_to_play'),\n",
       " (5113, 'early_access'),\n",
       " (3676, 'sports'),\n",
       " (3206, 'massively_multiplayer'),\n",
       " (2861, 'racing'),\n",
       " (2616, 'in_early_access'),\n",
       " (1393, 'design_'),\n",
       " (1393, '_illustration'),\n",
       " (1381, 'violent'),\n",
       " (1168, 'movie'),\n",
       " (1024, 'web_publishing'),\n",
       " (973, 'utilities'),\n",
       " (737, 'gore'),\n",
       " (610, 'animation_'),\n",
       " (610, '_modeling'),\n",
       " (536, 'sexual_content'),\n",
       " (534, 'nudity'),\n",
       " (501, 'education'),\n",
       " (430, 'video_production'),\n",
       " (371, 'audio_production'),\n",
       " (351, 'software_training'),\n",
       " (264, 'episodic'),\n",
       " (246, 'photo_editing'),\n",
       " (223, 'game_development'),\n",
       " (98, 'documentary'),\n",
       " (96, 'tutorial'),\n",
       " (43, 'short'),\n",
       " (21, 'accounting'),\n",
       " (20, '360_video'),\n",
       " (1, '360_v')]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "term_count=zip(encoded.toarray().sum(axis=0), count_vec.get_feature_names())\n",
    "sorted_term_count=sorted(list(term_count), reverse=True)\n",
    "sorted_term_count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'action': 19,\n",
       " 'fps': 165,\n",
       " 'multiplayer': 254,\n",
       " 'shooter': 346,\n",
       " 'classic': 88,\n",
       " 'team': 392,\n",
       " 'based': 48,\n",
       " 'first': 159,\n",
       " 'person': 287,\n",
       " 'competitive': 99,\n",
       " 'tactical': 389,\n",
       " '1990s': 1,\n",
       " 'sports': 372,\n",
       " 'pvp': 311,\n",
       " 'old_school': 272,\n",
       " 'military': 240,\n",
       " 'strategy': 378,\n",
       " 'survival': 385,\n",
       " 'score_attack': 342,\n",
       " '1980s': 0,\n",
       " 'assassin': 37,\n",
       " 'violent': 428,\n",
       " 'hero_shooter': 189,\n",
       " 'class': 87,\n",
       " 'co': 90,\n",
       " 'op': 275,\n",
       " 'fast': 154,\n",
       " 'paced': 281,\n",
       " 'retro': 323,\n",
       " 'online_co': 274,\n",
       " 'mod': 247,\n",
       " 'remake': 320,\n",
       " 'funny': 168,\n",
       " 'world_war_ii': 444,\n",
       " 'war': 435,\n",
       " 'historical': 192,\n",
       " 'singleplayer': 351,\n",
       " 'difficult': 123,\n",
       " 'world_war_i': 443,\n",
       " 'arena_shooter': 35,\n",
       " 'sci': 340,\n",
       " 'fi': 157,\n",
       " 'gore': 177,\n",
       " 'aliens': 26,\n",
       " 'adventure': 24,\n",
       " 'atmospheric': 40,\n",
       " 'story_rich': 377,\n",
       " 'silent_protagonist': 349,\n",
       " 'great_soundtrack': 180,\n",
       " 'puzzle': 309,\n",
       " 'moddable': 248,\n",
       " 'cyberpunk': 111,\n",
       " 'space': 366,\n",
       " 'memes': 238,\n",
       " 'conspiracy': 100,\n",
       " 'psychological_horror': 308,\n",
       " 'platformer': 296,\n",
       " '3d': 6,\n",
       " 'cult_classic': 109,\n",
       " 'anime': 31,\n",
       " 'linear': 218,\n",
       " 'open_world': 277,\n",
       " 'simulation': 350,\n",
       " 'dark': 113,\n",
       " 'masterpiece': 232,\n",
       " 'zombies': 447,\n",
       " 'short': 347,\n",
       " 'dystopian_': 137,\n",
       " 'physics': 292,\n",
       " 'horror': 194,\n",
       " 'sandbox': 338,\n",
       " 'realistic': 317,\n",
       " 'massively_multiplayer': 231,\n",
       " 'comedy': 97,\n",
       " 'futuristic': 169,\n",
       " 'benchmark': 61,\n",
       " 'free_to_play': 166,\n",
       " 'post': 302,\n",
       " 'apocalyptic': 32,\n",
       " 'episodic': 145,\n",
       " 'cinematic': 85,\n",
       " '3d_platformer': 8,\n",
       " 'female_protagonist': 156,\n",
       " 'science': 341,\n",
       " 'dark_humor': 116,\n",
       " 'cartoony': 77,\n",
       " 'trading': 409,\n",
       " 'robots': 326,\n",
       " 'cartoon': 76,\n",
       " 'crafting': 104,\n",
       " 'replay_value': 321,\n",
       " 'survival_horror': 386,\n",
       " 'local_co': 220,\n",
       " 'moba': 246,\n",
       " 'rts': 335,\n",
       " 'tower_defense': 407,\n",
       " 'rpg': 333,\n",
       " 'fantasy': 151,\n",
       " 'character_customization': 81,\n",
       " 'action_rpg': 21,\n",
       " 'level_editor': 214,\n",
       " 'top': 405,\n",
       " 'down': 128,\n",
       " 'down_shooter': 129,\n",
       " 'third_person': 396,\n",
       " 'pve': 310,\n",
       " 'third': 395,\n",
       " 'person_shooter': 288,\n",
       " 'naval': 263,\n",
       " 'indie': 201,\n",
       " 'fighting': 158,\n",
       " 'isometric': 207,\n",
       " 'twin_stick_shooter': 418,\n",
       " 'dark_fantasy': 115,\n",
       " 'swordplay': 387,\n",
       " 'magic': 227,\n",
       " 'stealth': 374,\n",
       " 'multiple_endings': 255,\n",
       " 'medieval': 237,\n",
       " 'hack_and_slash': 183,\n",
       " 'hacking': 184,\n",
       " '2d': 2,\n",
       " 'real': 315,\n",
       " 'time_with_pause': 404,\n",
       " 'experimental': 147,\n",
       " 'addictive': 23,\n",
       " 'rogue': 328,\n",
       " 'like': 217,\n",
       " 'perma_death': 286,\n",
       " 'space_sim': 367,\n",
       " 'economy': 139,\n",
       " 'flight': 161,\n",
       " '4x': 11,\n",
       " 'casual': 78,\n",
       " 'loot': 223,\n",
       " 'crime': 106,\n",
       " 'controller': 101,\n",
       " 'racing': 313,\n",
       " 'time_attack': 399,\n",
       " 'arcade': 33,\n",
       " 'point_': 297,\n",
       " '_click': 14,\n",
       " 'mystery': 257,\n",
       " 'america': 29,\n",
       " 'mechs': 235,\n",
       " 'heist': 187,\n",
       " 'split_screen': 371,\n",
       " 'turn': 416,\n",
       " 'based_strategy': 54,\n",
       " 'grand_strategy': 179,\n",
       " 'education': 140,\n",
       " 'local_multiplayer': 221,\n",
       " 'western': 441,\n",
       " 'steampunk': 376,\n",
       " 'underwater': 421,\n",
       " 'political': 298,\n",
       " 'alternate_history': 27,\n",
       " 'driving': 133,\n",
       " 'mythology': 259,\n",
       " 'tanks': 391,\n",
       " 'base': 46,\n",
       " 'building': 70,\n",
       " 'modern': 249,\n",
       " '2d_fighter': 3,\n",
       " 'martial_arts': 230,\n",
       " 'intentionally_awkward_controls': 203,\n",
       " 'wargame': 436,\n",
       " 'cold_war': 91,\n",
       " 'diplomacy': 125,\n",
       " 'naval_combat': 264,\n",
       " 'submarine': 381,\n",
       " 'gothic': 178,\n",
       " 'underground': 420,\n",
       " 'immersive_sim': 200,\n",
       " 'exploration': 148,\n",
       " 'dungeon_crawler': 134,\n",
       " 'inventory_management': 205,\n",
       " 'animation_': 30,\n",
       " '_modeling': 17,\n",
       " 'video_production': 426,\n",
       " 'software': 360,\n",
       " 'movie': 253,\n",
       " 'time': 398,\n",
       " 'pixel_graphics': 295,\n",
       " 'resource_management': 322,\n",
       " 'tactical_rpg': 390,\n",
       " '5d': 12,\n",
       " 'demons': 119,\n",
       " 'lovecraftian': 226,\n",
       " 'stylized': 380,\n",
       " 'blood': 64,\n",
       " 'shoot_em_up': 345,\n",
       " 'combat': 95,\n",
       " '2d_platformer': 4,\n",
       " 'vampire': 424,\n",
       " 'supernatural': 383,\n",
       " 'immersive': 199,\n",
       " 'bullet_time': 72,\n",
       " 'management': 228,\n",
       " 'family_friendly': 150,\n",
       " 'city_builder': 86,\n",
       " 'destruction': 121,\n",
       " 'politics': 300,\n",
       " 'capitalism': 73,\n",
       " 'combat_racing': 96,\n",
       " 'automobile_sim': 45,\n",
       " 'vehicular_combat': 425,\n",
       " 'music': 256,\n",
       " 'offroad': 271,\n",
       " 'hex_grid': 190,\n",
       " 'based_combat': 49,\n",
       " 'match_3': 233,\n",
       " 'cute': 110,\n",
       " 'clicker': 89,\n",
       " 'colorful': 94,\n",
       " 'relaxing': 319,\n",
       " 'word_game': 442,\n",
       " 'dinosaurs': 124,\n",
       " 'bullet_hell': 71,\n",
       " 'typing': 419,\n",
       " 'hidden_object': 191,\n",
       " 'touch': 406,\n",
       " 'friendly': 167,\n",
       " 'sniper': 355,\n",
       " 'comic_book': 98,\n",
       " 'villain_protagonist': 427,\n",
       " 'parody_': 283,\n",
       " 'god_game': 175,\n",
       " 'mature': 234,\n",
       " 'psychological': 307,\n",
       " 'surreal': 384,\n",
       " 'collectathon': 92,\n",
       " '3d_vision': 9,\n",
       " 'soundtrack': 365,\n",
       " 'pirates': 294,\n",
       " 'sailing': 337,\n",
       " 'choose_your_own_adventure': 84,\n",
       " 'rome': 332,\n",
       " 'card_game': 75,\n",
       " 'gambling': 170,\n",
       " 'based_on_a_novel': 51,\n",
       " 'epic': 144,\n",
       " 'warhammer_40k': 437,\n",
       " 'games_workshop': 173,\n",
       " 'real_time_tactics': 316,\n",
       " 'detective': 122,\n",
       " 'beat_em_up': 59,\n",
       " 'thriller': 397,\n",
       " 'parkour': 282,\n",
       " 'mars': 229,\n",
       " 'choices_matter': 83,\n",
       " 'nudity': 270,\n",
       " 'beautiful': 60,\n",
       " 'lara_croft': 211,\n",
       " 'bowling': 67,\n",
       " 'satire': 339,\n",
       " 'op_campaign': 276,\n",
       " 'based_tactics': 55,\n",
       " 'romance': 331,\n",
       " 'fmv': 162,\n",
       " 'metroidvania': 239,\n",
       " 'side_scroller': 348,\n",
       " 'philisophical': 289,\n",
       " 'voice_control': 430,\n",
       " 'mmorpg': 245,\n",
       " 'walking_simulator': 434,\n",
       " 'experience': 146,\n",
       " 'party': 284,\n",
       " 'based_rpg': 53,\n",
       " 'crpg': 108,\n",
       " 'minimalist': 243,\n",
       " 'procedural_generation': 304,\n",
       " 'trackir': 408,\n",
       " 'ninja': 265,\n",
       " '4_player_local': 10,\n",
       " 'time_travel': 403,\n",
       " 'quick': 312,\n",
       " 'time_events': 400,\n",
       " 'dragons': 130,\n",
       " 'board_game': 66,\n",
       " 'minigames': 242,\n",
       " 'character_action_game': 80,\n",
       " 'spectacle_fighter': 369,\n",
       " 'lego': 212,\n",
       " 'time_management': 401,\n",
       " 'psychedelic': 306,\n",
       " 'rhythm': 324,\n",
       " 'time_manipulation': 402,\n",
       " '6dof': 13,\n",
       " 'unforgiving': 422,\n",
       " 'hand': 185,\n",
       " 'drawn': 132,\n",
       " 'interactive_fiction': 204,\n",
       " 'superhero': 382,\n",
       " 'batman': 57,\n",
       " 'gun_customization': 182,\n",
       " 'mining': 244,\n",
       " 'based_procedural_generation': 52,\n",
       " 'jrpg': 209,\n",
       " 'visual_novel': 429,\n",
       " 'strategy_rpg': 379,\n",
       " 'motocross': 250,\n",
       " 'atv': 41,\n",
       " 'motorbike': 251,\n",
       " 'bikes': 62,\n",
       " 'transhumanism': 413,\n",
       " 'illuminati': 198,\n",
       " 'trains': 412,\n",
       " 'spaceships': 368,\n",
       " 'philosophical': 290,\n",
       " 'looter_shooter': 224,\n",
       " 'nostalgia': 268,\n",
       " 'on': 273,\n",
       " 'rails_shooter': 314,\n",
       " 'mini_golf': 241,\n",
       " 'golf': 176,\n",
       " 'hunting': 196,\n",
       " 'investigation': 206,\n",
       " 'sequel': 343,\n",
       " 'colony_sim': 93,\n",
       " 'lore': 225,\n",
       " 'rich': 325,\n",
       " 'abstract': 18,\n",
       " 'logic': 222,\n",
       " 'mouse_only': 252,\n",
       " 'narration': 260,\n",
       " 'transportation': 414,\n",
       " 'medical_sim': 236,\n",
       " 'noir': 266,\n",
       " 'narrative': 261,\n",
       " 'pinball': 293,\n",
       " 'emotional': 143,\n",
       " 'horses': 195,\n",
       " 'vr': 432,\n",
       " 'early_access': 138,\n",
       " 'farming_sim': 153,\n",
       " 'agriculture': 25,\n",
       " 'farming': 152,\n",
       " 'werewolves': 440,\n",
       " 'well': 439,\n",
       " 'written': 446,\n",
       " 'card_battler': 74,\n",
       " 'deckbuilding': 118,\n",
       " 'political_sim': 299,\n",
       " 'fishing': 160,\n",
       " '3d_fighter': 7,\n",
       " 'ambient': 28,\n",
       " 'conversation': 102,\n",
       " 'drama': 131,\n",
       " 'hentai': 188,\n",
       " 'dog': 127,\n",
       " 'solitaire': 363,\n",
       " 'tabletop': 388,\n",
       " 'life_sim': 216,\n",
       " 'precision_platformer': 303,\n",
       " 'sexual_content': 344,\n",
       " 'action_roguelike': 20,\n",
       " 'nonlinear': 267,\n",
       " 'basketball': 56,\n",
       " 'cats': 79,\n",
       " 'trading_card_game': 410,\n",
       " 'lite': 219,\n",
       " 'runner': 336,\n",
       " 'chess': 82,\n",
       " 'grid': 181,\n",
       " 'based_movement': 50,\n",
       " 'tennis': 393,\n",
       " 'lemmings': 213,\n",
       " 'nature': 262,\n",
       " 'dating_sim': 117,\n",
       " 'lgbtq': 215,\n",
       " 'programming': 305,\n",
       " 'star_wars': 373,\n",
       " 'asynchronous_multiplayer': 39,\n",
       " 'rpgmaker': 334,\n",
       " 'dynamic_narration': 136,\n",
       " 'sokoban': 362,\n",
       " 'kickstarter': 210,\n",
       " 'otome': 279,\n",
       " 'documentary': 126,\n",
       " 'game_development': 171,\n",
       " 'gamemaker': 172,\n",
       " 'dungeons_': 135,\n",
       " '_dragons': 15,\n",
       " 'football': 163,\n",
       " 'soccer': 358,\n",
       " 'utilities': 423,\n",
       " 'party_game': 285,\n",
       " 'automation': 44,\n",
       " 'traditional_roguelike': 411,\n",
       " 'photo_editing': 291,\n",
       " 'design_': 120,\n",
       " '_illustration': 16,\n",
       " 'feature_film': 155,\n",
       " 'open_world_survival_craft': 278,\n",
       " 'creature_collector': 105,\n",
       " 'artificial_intelligence': 36,\n",
       " 'reboot': 318,\n",
       " 'skating': 353,\n",
       " 'roguevania': 330,\n",
       " 'text': 394,\n",
       " 'souls': 364,\n",
       " 'software_training': 361,\n",
       " 'web_publishing': 438,\n",
       " 'audio_production': 42,\n",
       " 'crowdfunded': 107,\n",
       " 'dark_comedy': 114,\n",
       " 'voxel': 431,\n",
       " 'wrestling': 445,\n",
       " 'snow': 356,\n",
       " 'skiing': 354,\n",
       " 'snowboarding': 357,\n",
       " 'outbreak_sim': 280,\n",
       " 'mystery_dungeon': 258,\n",
       " 'archery': 34,\n",
       " 'trivia': 415,\n",
       " 'pool': 301,\n",
       " 'cycling': 112,\n",
       " 'boxing': 68,\n",
       " 'roguelike_deckbuilder': 329,\n",
       " 'vr_only': 433,\n",
       " 'tutorial': 417,\n",
       " 'skateboarding': 352,\n",
       " 'battle_royale': 58,\n",
       " 'steam_machine': 375,\n",
       " 'hockey': 193,\n",
       " 'gaming': 174,\n",
       " 'baseball': 47,\n",
       " 'electronic_music': 142,\n",
       " 'spelling': 370,\n",
       " 'social_deduction': 359,\n",
       " 'nsfw': 269,\n",
       " 'jet': 208,\n",
       " 'action_rts': 22,\n",
       " 'asymmetric_vr': 38,\n",
       " 'hardware': 186,\n",
       " 'idler': 197,\n",
       " 'foreign': 164,\n",
       " 'bmx': 65,\n",
       " 'auto_battler': 43,\n",
       " '360_video': 5,\n",
       " 'electronic': 141,\n",
       " 'faith': 149,\n",
       " 'instrumental_music': 202,\n",
       " 'breathtaking': 69,\n",
       " 'bit_music': 63,\n",
       " 'rock_music': 327,\n",
       " 'cooking': 103}"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "steam_data['clean_tags']=steam_data[\"Tags\"].str.replace(' ','_').str.replace(',_', ',')\n",
    "steam_data\n",
    "from sklearn.feature_extraction.text import CountVectorizer\n",
    "tags=steam_data['clean_tags'].dropna().str.replace(\"'\", '').str.replace('[', '').str.replace(']', '')\n",
    "count_vec=CountVectorizer()\n",
    "encoded_tags=count_vec.fit_transform(tags)\n",
    "count_vec.vocabulary_"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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>action</th>\n",
       "      <th>fps</th>\n",
       "      <th>multiplayer</th>\n",
       "      <th>shooter</th>\n",
       "      <th>classic</th>\n",
       "      <th>team</th>\n",
       "      <th>based</th>\n",
       "      <th>first</th>\n",
       "      <th>person</th>\n",
       "      <th>competitive</th>\n",
       "      <th>...</th>\n",
       "      <th>bmx</th>\n",
       "      <th>auto_battler</th>\n",
       "      <th>360_video</th>\n",
       "      <th>electronic</th>\n",
       "      <th>faith</th>\n",
       "      <th>instrumental_music</th>\n",
       "      <th>breathtaking</th>\n",
       "      <th>bit_music</th>\n",
       "      <th>rock_music</th>\n",
       "      <th>cooking</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56630</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56631</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56632</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56633</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56634</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>56635 rows × 448 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       action  fps  multiplayer  shooter  classic  team  based  first  person  \\\n",
       "0           1    1            0        0        0     0      0      0       0   \n",
       "1           0    1            0        0        0     0      0      0       0   \n",
       "2           0    0            0        0        0     0      0      0       0   \n",
       "3           0    1            0        0        0     0      0      0       0   \n",
       "4           0    1            0        0        0     0      0      0       0   \n",
       "...       ...  ...          ...      ...      ...   ...    ...    ...     ...   \n",
       "56630       0    0            0        0        0     0      0      1       0   \n",
       "56631       0    0            1        0        0     0      0      0       0   \n",
       "56632       0    0            1        1        0     0      0      0       0   \n",
       "56633       0    0            0        0        0     0      1      0       0   \n",
       "56634       0    0            0        0        0     0      0      0       0   \n",
       "\n",
       "       competitive  ...  bmx  auto_battler  360_video  electronic  faith  \\\n",
       "0                0  ...    0             0          0           0      0   \n",
       "1                0  ...    0             0          0           0      0   \n",
       "2                0  ...    0             0          0           0      0   \n",
       "3                0  ...    0             0          0           0      0   \n",
       "4                0  ...    0             0          0           0      0   \n",
       "...            ...  ...  ...           ...        ...         ...    ...   \n",
       "56630            0  ...    0             0          0           0      0   \n",
       "56631            0  ...    0             0          0           0      0   \n",
       "56632            0  ...    0             0          0           0      0   \n",
       "56633            0  ...    0             0          0           0      0   \n",
       "56634            0  ...    0             0          0           0      0   \n",
       "\n",
       "       instrumental_music  breathtaking  bit_music  rock_music  cooking  \n",
       "0                       0             0          0           0        0  \n",
       "1                       0             0          0           0        0  \n",
       "2                       1             1          0           0        0  \n",
       "3                       0             0          0           0        0  \n",
       "4                       0             0          0           0        0  \n",
       "...                   ...           ...        ...         ...      ...  \n",
       "56630                   0             0          0           0        0  \n",
       "56631                   0             0          0           0        0  \n",
       "56632                   0             0          0           0        0  \n",
       "56633                   0             0          0           0        0  \n",
       "56634                   0             0          0           0        0  \n",
       "\n",
       "[56635 rows x 448 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "encoded_tags= pd.DataFrame(encoded_tags.toarray(), columns=count_vec.vocabulary_)\n",
    "encoded_tags"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "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>action_x</th>\n",
       "      <th>fps</th>\n",
       "      <th>multiplayer</th>\n",
       "      <th>shooter</th>\n",
       "      <th>classic</th>\n",
       "      <th>team</th>\n",
       "      <th>based</th>\n",
       "      <th>first</th>\n",
       "      <th>person</th>\n",
       "      <th>competitive</th>\n",
       "      <th>...</th>\n",
       "      <th>accounting</th>\n",
       "      <th>nudity_y</th>\n",
       "      <th>sexual_content_y</th>\n",
       "      <th>documentary_y</th>\n",
       "      <th>episodic_y</th>\n",
       "      <th>movie_y</th>\n",
       "      <th>short_y</th>\n",
       "      <th>tutorial_y</th>\n",
       "      <th>360_video_y</th>\n",
       "      <th>360_v</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56630</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56631</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56632</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56633</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56634</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>56635 rows × 485 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       action_x  fps  multiplayer  shooter  classic  team  based  first  \\\n",
       "0             1    1            0        0        0     0      0      0   \n",
       "1             0    1            0        0        0     0      0      0   \n",
       "2             0    0            0        0        0     0      0      0   \n",
       "3             0    1            0        0        0     0      0      0   \n",
       "4             0    1            0        0        0     0      0      0   \n",
       "...         ...  ...          ...      ...      ...   ...    ...    ...   \n",
       "56630         0    0            0        0        0     0      0      1   \n",
       "56631         0    0            1        0        0     0      0      0   \n",
       "56632         0    0            1        1        0     0      0      0   \n",
       "56633         0    0            0        0        0     0      1      0   \n",
       "56634         0    0            0        0        0     0      0      0   \n",
       "\n",
       "       person  competitive  ...  accounting  nudity_y  sexual_content_y  \\\n",
       "0           0            0  ...           0         0                 0   \n",
       "1           0            0  ...           0         0                 0   \n",
       "2           0            0  ...           0         0                 0   \n",
       "3           0            0  ...           0         0                 0   \n",
       "4           0            0  ...           0         0                 0   \n",
       "...       ...          ...  ...         ...       ...               ...   \n",
       "56630       0            0  ...           0         1                 0   \n",
       "56631       0            0  ...           0         1                 0   \n",
       "56632       0            0  ...           0         0                 0   \n",
       "56633       0            0  ...           0         1                 0   \n",
       "56634       0            0  ...           0         1                 0   \n",
       "\n",
       "       documentary_y  episodic_y  movie_y  short_y  tutorial_y  360_video_y  \\\n",
       "0                  0           0        0        0           0            0   \n",
       "1                  0           0        0        0           0            0   \n",
       "2                  0           0        0        0           0            0   \n",
       "3                  0           0        0        0           0            0   \n",
       "4                  0           0        0        0           0            0   \n",
       "...              ...         ...      ...      ...         ...          ...   \n",
       "56630              0           1        0        0           0            0   \n",
       "56631              0           1        0        0           0            0   \n",
       "56632              0           0        0        0           0            0   \n",
       "56633              0           0        0        0           0            1   \n",
       "56634              0           0        0        0           0            1   \n",
       "\n",
       "       360_v  \n",
       "0          0  \n",
       "1          0  \n",
       "2          0  \n",
       "3          0  \n",
       "4          0  \n",
       "...      ...  \n",
       "56630      0  \n",
       "56631      0  \n",
       "56632      0  \n",
       "56633      0  \n",
       "56634      0  \n",
       "\n",
       "[56635 rows x 485 columns]"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "encoded_merge = encoded_tags.merge(encoded_genres,left_index=True, right_index=True)\n",
    "encoded_merge"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>20,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>20,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>10,000,000</td>\n",
       "      <td>20,000,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2,000,000</td>\n",
       "      <td>5,000,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5,000,000</td>\n",
       "      <td>10,000,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95239</th>\n",
       "      <td>0</td>\n",
       "      <td>20,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95240</th>\n",
       "      <td>0</td>\n",
       "      <td>20,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95241</th>\n",
       "      <td>0</td>\n",
       "      <td>20,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95242</th>\n",
       "      <td>0</td>\n",
       "      <td>20,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95243</th>\n",
       "      <td>0</td>\n",
       "      <td>20,000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>95244 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                0           1\n",
       "0               0      20,000\n",
       "1               0      20,000\n",
       "2      10,000,000  20,000,000\n",
       "3       2,000,000   5,000,000\n",
       "4       5,000,000  10,000,000\n",
       "...           ...         ...\n",
       "95239           0      20,000\n",
       "95240           0      20,000\n",
       "95241           0      20,000\n",
       "95242           0      20,000\n",
       "95243           0      20,000\n",
       "\n",
       "[95244 rows x 2 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new = steam_data[\"Owners\"].str.split(\"Â ..Â \", n = 1, expand = True)\n",
    "steam_data['Owners'].dtypes\n",
    "new"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "steam_data[\"min owners\"] = new[0]\n",
    "steam_data[\"max owners\"] = new[1]\n",
    "steam_data.drop(columns =[\"Owners\"], inplace = True) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>App Id</th>\n",
       "      <th>Name</th>\n",
       "      <th>Developers</th>\n",
       "      <th>Publishers</th>\n",
       "      <th>Metascores</th>\n",
       "      <th>Genres</th>\n",
       "      <th>Tags</th>\n",
       "      <th>Price</th>\n",
       "      <th>clean_genres</th>\n",
       "      <th>clean_tags</th>\n",
       "      <th>min owners</th>\n",
       "      <th>max owners</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>7</td>\n",
       "      <td>Steam Client</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['']</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>['']</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>20,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>8</td>\n",
       "      <td>winui2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['']</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>['']</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>20,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>10</td>\n",
       "      <td>Counter-Strike</td>\n",
       "      <td>Valve</td>\n",
       "      <td>Valve</td>\n",
       "      <td>88%</td>\n",
       "      <td>['Action']</td>\n",
       "      <td>['Action', 'FPS', 'Multiplayer', 'Shooter', 'C...</td>\n",
       "      <td>$9.99</td>\n",
       "      <td>['Action']</td>\n",
       "      <td>['Action','FPS','Multiplayer','Shooter','Class...</td>\n",
       "      <td>10,000,000</td>\n",
       "      <td>20,000,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>20</td>\n",
       "      <td>Team Fortress Classic</td>\n",
       "      <td>Valve</td>\n",
       "      <td>Valve</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Action']</td>\n",
       "      <td>['Action', 'FPS', 'Multiplayer', 'Classic', 'H...</td>\n",
       "      <td>$4.99</td>\n",
       "      <td>['Action']</td>\n",
       "      <td>['Action','FPS','Multiplayer','Classic','Hero_...</td>\n",
       "      <td>2,000,000</td>\n",
       "      <td>5,000,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>30</td>\n",
       "      <td>Day of Defeat</td>\n",
       "      <td>Valve</td>\n",
       "      <td>Valve</td>\n",
       "      <td>79%</td>\n",
       "      <td>['Action']</td>\n",
       "      <td>['FPS', 'World War II', 'Multiplayer', 'Shoote...</td>\n",
       "      <td>$4.99</td>\n",
       "      <td>['Action']</td>\n",
       "      <td>['FPS','World_War_II','Multiplayer','Shooter',...</td>\n",
       "      <td>5,000,000</td>\n",
       "      <td>10,000,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95239</th>\n",
       "      <td>1474820</td>\n",
       "      <td>The Tower Of TigerQiuQiu Tiger Tank 60</td>\n",
       "      <td>TigerQiuQiu</td>\n",
       "      <td>TigerQiuQiu</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Action', 'Casual', 'Indie']</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$0.74</td>\n",
       "      <td>['Action','Casual','Indie']</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>20,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95240</th>\n",
       "      <td>1474960</td>\n",
       "      <td>Der Geisterturm / The Ghost Tower Demo</td>\n",
       "      <td>Graverobber Foundation</td>\n",
       "      <td>Graverobber Foundation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['']</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>['']</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>20,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95241</th>\n",
       "      <td>1475910</td>\n",
       "      <td>DIY Simulator Dedicated Server</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['']</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>['']</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>20,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95242</th>\n",
       "      <td>1476030</td>\n",
       "      <td>OTTI'S QUEST</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['']</td>\n",
       "      <td>NaN</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>['']</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>20,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95243</th>\n",
       "      <td>2028850</td>\n",
       "      <td>Bioshock Infinite: Columbia's Finest</td>\n",
       "      <td>Irrational Games</td>\n",
       "      <td>2K Games</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Action']</td>\n",
       "      <td>['Action', 'FPS', 'Singleplayer']</td>\n",
       "      <td>$4.99</td>\n",
       "      <td>['Action']</td>\n",
       "      <td>['Action','FPS','Singleplayer']</td>\n",
       "      <td>0</td>\n",
       "      <td>20,000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>95244 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        App Id                                    Name  \\\n",
       "0            7                            Steam Client   \n",
       "1            8                                  winui2   \n",
       "2           10                          Counter-Strike   \n",
       "3           20                   Team Fortress Classic   \n",
       "4           30                           Day of Defeat   \n",
       "...        ...                                     ...   \n",
       "95239  1474820  The Tower Of TigerQiuQiu Tiger Tank 60   \n",
       "95240  1474960  Der Geisterturm / The Ghost Tower Demo   \n",
       "95241  1475910          DIY Simulator Dedicated Server   \n",
       "95242  1476030                            OTTI'S QUEST   \n",
       "95243  2028850    Bioshock Infinite: Columbia's Finest   \n",
       "\n",
       "                   Developers              Publishers Metascores  \\\n",
       "0                         NaN                     NaN        NaN   \n",
       "1                         NaN                     NaN        NaN   \n",
       "2                       Valve                   Valve        88%   \n",
       "3                       Valve                   Valve        NaN   \n",
       "4                       Valve                   Valve        79%   \n",
       "...                       ...                     ...        ...   \n",
       "95239             TigerQiuQiu             TigerQiuQiu        NaN   \n",
       "95240  Graverobber Foundation  Graverobber Foundation        NaN   \n",
       "95241                     NaN                     NaN        NaN   \n",
       "95242                     NaN                     NaN        NaN   \n",
       "95243        Irrational Games                2K Games        NaN   \n",
       "\n",
       "                              Genres  \\\n",
       "0                               ['']   \n",
       "1                               ['']   \n",
       "2                         ['Action']   \n",
       "3                         ['Action']   \n",
       "4                         ['Action']   \n",
       "...                              ...   \n",
       "95239  ['Action', 'Casual', 'Indie']   \n",
       "95240                           ['']   \n",
       "95241                           ['']   \n",
       "95242                           ['']   \n",
       "95243                     ['Action']   \n",
       "\n",
       "                                                    Tags   Price  \\\n",
       "0                                                    NaN  $0.00    \n",
       "1                                                    NaN  $0.00    \n",
       "2      ['Action', 'FPS', 'Multiplayer', 'Shooter', 'C...  $9.99    \n",
       "3      ['Action', 'FPS', 'Multiplayer', 'Classic', 'H...  $4.99    \n",
       "4      ['FPS', 'World War II', 'Multiplayer', 'Shoote...  $4.99    \n",
       "...                                                  ...     ...   \n",
       "95239                                                NaN  $0.74    \n",
       "95240                                                NaN  $0.00    \n",
       "95241                                                NaN  $0.00    \n",
       "95242                                                NaN  $0.00    \n",
       "95243                  ['Action', 'FPS', 'Singleplayer']  $4.99    \n",
       "\n",
       "                      clean_genres  \\\n",
       "0                             ['']   \n",
       "1                             ['']   \n",
       "2                       ['Action']   \n",
       "3                       ['Action']   \n",
       "4                       ['Action']   \n",
       "...                            ...   \n",
       "95239  ['Action','Casual','Indie']   \n",
       "95240                         ['']   \n",
       "95241                         ['']   \n",
       "95242                         ['']   \n",
       "95243                   ['Action']   \n",
       "\n",
       "                                              clean_tags  min owners  \\\n",
       "0                                                    NaN           0   \n",
       "1                                                    NaN           0   \n",
       "2      ['Action','FPS','Multiplayer','Shooter','Class...  10,000,000   \n",
       "3      ['Action','FPS','Multiplayer','Classic','Hero_...   2,000,000   \n",
       "4      ['FPS','World_War_II','Multiplayer','Shooter',...   5,000,000   \n",
       "...                                                  ...         ...   \n",
       "95239                                                NaN           0   \n",
       "95240                                                NaN           0   \n",
       "95241                                                NaN           0   \n",
       "95242                                                NaN           0   \n",
       "95243                    ['Action','FPS','Singleplayer']           0   \n",
       "\n",
       "       max owners  \n",
       "0          20,000  \n",
       "1          20,000  \n",
       "2      20,000,000  \n",
       "3       5,000,000  \n",
       "4      10,000,000  \n",
       "...           ...  \n",
       "95239      20,000  \n",
       "95240      20,000  \n",
       "95241      20,000  \n",
       "95242      20,000  \n",
       "95243      20,000  \n",
       "\n",
       "[95244 rows x 12 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "steam_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# new_max = steam_data[\"max\"].str.split(\".\", n = 1, expand = True)\n",
    "# new_max[1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# steam_data[\"max\"] = new_max[1]\n",
    "# steam_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "#  steam_data[\"Genres\"] = steam_data[\"Genres\"].apply(eval)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "steam_data_clean = steam_data.dropna(subset=[\"Genres\", \"Developers\",\"Tags\",\"Metascores\", \"max owners\", \"min owners\",\"clean_genres\",\"clean_tags\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(4005, 12)"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "steam_data_clean.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "App Id           0\n",
       "Name             0\n",
       "Developers       0\n",
       "Publishers      61\n",
       "Metascores       0\n",
       "Genres           0\n",
       "Tags             0\n",
       "Price            0\n",
       "clean_genres     0\n",
       "clean_tags       0\n",
       "min owners       0\n",
       "max owners       0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "steam_data_clean.isna().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "<ipython-input-19-36045a58e141>:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  steam_data_clean[\"min owners\"] = pd.Series(steam_data_clean[\"min owners\"]).str.replace(',', \"\")\n",
      "<ipython-input-19-36045a58e141>:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  steam_data_clean[\"max owners\"] = pd.Series(steam_data_clean[\"max owners\"]).str.replace(',', \"\")\n"
     ]
    },
    {
     "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>App Id</th>\n",
       "      <th>Name</th>\n",
       "      <th>Developers</th>\n",
       "      <th>Publishers</th>\n",
       "      <th>Metascores</th>\n",
       "      <th>Genres</th>\n",
       "      <th>Tags</th>\n",
       "      <th>Price</th>\n",
       "      <th>clean_genres</th>\n",
       "      <th>clean_tags</th>\n",
       "      <th>min owners</th>\n",
       "      <th>max owners</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>10</td>\n",
       "      <td>Counter-Strike</td>\n",
       "      <td>Valve</td>\n",
       "      <td>Valve</td>\n",
       "      <td>88%</td>\n",
       "      <td>['Action']</td>\n",
       "      <td>['Action', 'FPS', 'Multiplayer', 'Shooter', 'C...</td>\n",
       "      <td>$9.99</td>\n",
       "      <td>['Action']</td>\n",
       "      <td>['Action','FPS','Multiplayer','Shooter','Class...</td>\n",
       "      <td>10000000</td>\n",
       "      <td>20000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>30</td>\n",
       "      <td>Day of Defeat</td>\n",
       "      <td>Valve</td>\n",
       "      <td>Valve</td>\n",
       "      <td>79%</td>\n",
       "      <td>['Action']</td>\n",
       "      <td>['FPS', 'World War II', 'Multiplayer', 'Shoote...</td>\n",
       "      <td>$4.99</td>\n",
       "      <td>['Action']</td>\n",
       "      <td>['FPS','World_War_II','Multiplayer','Shooter',...</td>\n",
       "      <td>5000000</td>\n",
       "      <td>10000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>70</td>\n",
       "      <td>Half-Life</td>\n",
       "      <td>Valve</td>\n",
       "      <td>Valve</td>\n",
       "      <td>96%</td>\n",
       "      <td>['Action']</td>\n",
       "      <td>['FPS', 'Classic', 'Action', 'Sci-fi', 'Single...</td>\n",
       "      <td>$9.99</td>\n",
       "      <td>['Action']</td>\n",
       "      <td>['FPS','Classic','Action','Sci-fi','Singleplay...</td>\n",
       "      <td>5000000</td>\n",
       "      <td>10000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>80</td>\n",
       "      <td>Counter-Strike: Condition Zero</td>\n",
       "      <td>Valve</td>\n",
       "      <td>Valve</td>\n",
       "      <td>65%</td>\n",
       "      <td>['Action']</td>\n",
       "      <td>['Action', 'FPS', 'Shooter', 'Multiplayer', 'F...</td>\n",
       "      <td>$9.99</td>\n",
       "      <td>['Action']</td>\n",
       "      <td>['Action','FPS','Shooter','Multiplayer','First...</td>\n",
       "      <td>5000000</td>\n",
       "      <td>10000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>100</td>\n",
       "      <td>Counter-Strike: Condition Zero</td>\n",
       "      <td>Valve</td>\n",
       "      <td>Valve</td>\n",
       "      <td>65%</td>\n",
       "      <td>['Action']</td>\n",
       "      <td>['Action', 'FPS', 'Shooter', 'Multiplayer', 'F...</td>\n",
       "      <td>$9.99</td>\n",
       "      <td>['Action']</td>\n",
       "      <td>['Action','FPS','Shooter','Multiplayer','First...</td>\n",
       "      <td>10000000</td>\n",
       "      <td>20000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83966</th>\n",
       "      <td>1286830</td>\n",
       "      <td>STAR WARS: The Old Republic</td>\n",
       "      <td>BioWare</td>\n",
       "      <td>Electronic Arts</td>\n",
       "      <td>85%</td>\n",
       "      <td>['Free to Play', 'Massively Multiplayer', 'RPG']</td>\n",
       "      <td>['Free to Play', 'MMORPG', 'Multiplayer', 'RPG...</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>['Free_to_Play','Massively_Multiplayer','RPG']</td>\n",
       "      <td>['Free_to_Play','MMORPG','Multiplayer','RPG','...</td>\n",
       "      <td>1000000</td>\n",
       "      <td>2000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85672</th>\n",
       "      <td>1311510</td>\n",
       "      <td>Embracelet</td>\n",
       "      <td>Mattis Folkestad</td>\n",
       "      <td>machineboy</td>\n",
       "      <td>86%</td>\n",
       "      <td>['Adventure', 'Indie']</td>\n",
       "      <td>['Adventure', 'Indie', 'Story Rich', 'Music', ...</td>\n",
       "      <td>$12.99</td>\n",
       "      <td>['Adventure','Indie']</td>\n",
       "      <td>['Adventure','Indie','Story_Rich','Music','Exp...</td>\n",
       "      <td>0</td>\n",
       "      <td>20000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86889</th>\n",
       "      <td>1328660</td>\n",
       "      <td>Need for Speed Hot Pursuit Remastered</td>\n",
       "      <td>Stellar Entertainment Limited</td>\n",
       "      <td>Electronic Arts</td>\n",
       "      <td>74%</td>\n",
       "      <td>['Action', 'Racing']</td>\n",
       "      <td>['Combat Racing', 'Racing', 'Open World', 'Dri...</td>\n",
       "      <td>$29.99</td>\n",
       "      <td>['Action','Racing']</td>\n",
       "      <td>['Combat_Racing','Racing','Open_World','Drivin...</td>\n",
       "      <td>0</td>\n",
       "      <td>20000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87795</th>\n",
       "      <td>1342620</td>\n",
       "      <td>Werewolf: The Apocalypse â€” Heart of the Forest</td>\n",
       "      <td>Different Tales</td>\n",
       "      <td>Walkabout</td>\n",
       "      <td>78%</td>\n",
       "      <td>['Adventure', 'Indie', 'RPG']</td>\n",
       "      <td>['Werewolves', 'Visual Novel', 'RPG', 'Psychol...</td>\n",
       "      <td>$14.99</td>\n",
       "      <td>['Adventure','Indie','RPG']</td>\n",
       "      <td>['Werewolves','Visual_Novel','RPG','Psychologi...</td>\n",
       "      <td>200000</td>\n",
       "      <td>500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88688</th>\n",
       "      <td>1356670</td>\n",
       "      <td>Sakuna: Of Rice and Ruin</td>\n",
       "      <td>Edelweiss</td>\n",
       "      <td>XSEED Games</td>\n",
       "      <td>79%</td>\n",
       "      <td>['Action', 'Indie']</td>\n",
       "      <td>['Action', 'Farming Sim', 'Story Rich', 'Side ...</td>\n",
       "      <td>$39.99</td>\n",
       "      <td>['Action','Indie']</td>\n",
       "      <td>['Action','Farming_Sim','Story_Rich','Side_Scr...</td>\n",
       "      <td>50000</td>\n",
       "      <td>100000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4005 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        App Id                                              Name  \\\n",
       "2           10                                    Counter-Strike   \n",
       "4           30                                     Day of Defeat   \n",
       "8           70                                         Half-Life   \n",
       "9           80                    Counter-Strike: Condition Zero   \n",
       "12         100                    Counter-Strike: Condition Zero   \n",
       "...        ...                                               ...   \n",
       "83966  1286830                       STAR WARS: The Old Republic   \n",
       "85672  1311510                                        Embracelet   \n",
       "86889  1328660             Need for Speed Hot Pursuit Remastered   \n",
       "87795  1342620  Werewolf: The Apocalypse â€” Heart of the Forest   \n",
       "88688  1356670                          Sakuna: Of Rice and Ruin   \n",
       "\n",
       "                          Developers       Publishers Metascores  \\\n",
       "2                              Valve            Valve        88%   \n",
       "4                              Valve            Valve        79%   \n",
       "8                              Valve            Valve        96%   \n",
       "9                              Valve            Valve        65%   \n",
       "12                             Valve            Valve        65%   \n",
       "...                              ...              ...        ...   \n",
       "83966                        BioWare  Electronic Arts        85%   \n",
       "85672               Mattis Folkestad       machineboy        86%   \n",
       "86889  Stellar Entertainment Limited  Electronic Arts        74%   \n",
       "87795                Different Tales        Walkabout        78%   \n",
       "88688                      Edelweiss      XSEED Games        79%   \n",
       "\n",
       "                                                 Genres  \\\n",
       "2                                            ['Action']   \n",
       "4                                            ['Action']   \n",
       "8                                            ['Action']   \n",
       "9                                            ['Action']   \n",
       "12                                           ['Action']   \n",
       "...                                                 ...   \n",
       "83966  ['Free to Play', 'Massively Multiplayer', 'RPG']   \n",
       "85672                            ['Adventure', 'Indie']   \n",
       "86889                              ['Action', 'Racing']   \n",
       "87795                     ['Adventure', 'Indie', 'RPG']   \n",
       "88688                               ['Action', 'Indie']   \n",
       "\n",
       "                                                    Tags    Price  \\\n",
       "2      ['Action', 'FPS', 'Multiplayer', 'Shooter', 'C...   $9.99    \n",
       "4      ['FPS', 'World War II', 'Multiplayer', 'Shoote...   $4.99    \n",
       "8      ['FPS', 'Classic', 'Action', 'Sci-fi', 'Single...   $9.99    \n",
       "9      ['Action', 'FPS', 'Shooter', 'Multiplayer', 'F...   $9.99    \n",
       "12     ['Action', 'FPS', 'Shooter', 'Multiplayer', 'F...   $9.99    \n",
       "...                                                  ...      ...   \n",
       "83966  ['Free to Play', 'MMORPG', 'Multiplayer', 'RPG...   $0.00    \n",
       "85672  ['Adventure', 'Indie', 'Story Rich', 'Music', ...  $12.99    \n",
       "86889  ['Combat Racing', 'Racing', 'Open World', 'Dri...  $29.99    \n",
       "87795  ['Werewolves', 'Visual Novel', 'RPG', 'Psychol...  $14.99    \n",
       "88688  ['Action', 'Farming Sim', 'Story Rich', 'Side ...  $39.99    \n",
       "\n",
       "                                         clean_genres  \\\n",
       "2                                          ['Action']   \n",
       "4                                          ['Action']   \n",
       "8                                          ['Action']   \n",
       "9                                          ['Action']   \n",
       "12                                         ['Action']   \n",
       "...                                               ...   \n",
       "83966  ['Free_to_Play','Massively_Multiplayer','RPG']   \n",
       "85672                           ['Adventure','Indie']   \n",
       "86889                             ['Action','Racing']   \n",
       "87795                     ['Adventure','Indie','RPG']   \n",
       "88688                              ['Action','Indie']   \n",
       "\n",
       "                                              clean_tags min owners max owners  \n",
       "2      ['Action','FPS','Multiplayer','Shooter','Class...   10000000   20000000  \n",
       "4      ['FPS','World_War_II','Multiplayer','Shooter',...    5000000   10000000  \n",
       "8      ['FPS','Classic','Action','Sci-fi','Singleplay...    5000000   10000000  \n",
       "9      ['Action','FPS','Shooter','Multiplayer','First...    5000000   10000000  \n",
       "12     ['Action','FPS','Shooter','Multiplayer','First...   10000000   20000000  \n",
       "...                                                  ...        ...        ...  \n",
       "83966  ['Free_to_Play','MMORPG','Multiplayer','RPG','...    1000000    2000000  \n",
       "85672  ['Adventure','Indie','Story_Rich','Music','Exp...          0      20000  \n",
       "86889  ['Combat_Racing','Racing','Open_World','Drivin...          0      20000  \n",
       "87795  ['Werewolves','Visual_Novel','RPG','Psychologi...     200000     500000  \n",
       "88688  ['Action','Farming_Sim','Story_Rich','Side_Scr...      50000     100000  \n",
       "\n",
       "[4005 rows x 12 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "steam_data_clean[\"min owners\"] = pd.Series(steam_data_clean[\"min owners\"]).str.replace(',', \"\")\n",
    "steam_data_clean.head()\n",
    "steam_data_clean[\"max owners\"] = pd.Series(steam_data_clean[\"max owners\"]).str.replace(',', \"\")\n",
    "steam_data_clean"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "<ipython-input-20-4195f6c63870>:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  steam_data_clean['max owners'] = steam_data_clean['max owners'].astype(int)\n"
     ]
    }
   ],
   "source": [
    "steam_data_clean['max owners'] = steam_data_clean['max owners'].astype(int)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\Badison\\.conda\\New folder\\lib\\site-packages\\pandas\\core\\indexing.py:845: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  self.obj[key] = _infer_fill_value(value)\n",
      "C:\\Users\\Badison\\.conda\\New folder\\lib\\site-packages\\pandas\\core\\indexing.py:966: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  self.obj[item] = s\n"
     ]
    }
   ],
   "source": [
    "steam_data_clean.loc[steam_data_clean[\"max owners\"]>= 200000.0, \"Hit\"] = 1\n",
    "steam_data_clean.loc[steam_data_clean[\"max owners\"]< 200000.0, \"Hit\"] = 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "steam_data_clean_2 = pd.DataFrame(steam_data_clean, columns = ['App Id', 'Name','Developers', 'max owners','Publishers', 'Metascores', 'Price','clean_genres','clean_tags','Hit'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>App Id</th>\n",
       "      <th>Name</th>\n",
       "      <th>Developers</th>\n",
       "      <th>max owners</th>\n",
       "      <th>Publishers</th>\n",
       "      <th>Metascores</th>\n",
       "      <th>Price</th>\n",
       "      <th>clean_genres</th>\n",
       "      <th>clean_tags</th>\n",
       "      <th>Hit</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>10</td>\n",
       "      <td>Counter-Strike</td>\n",
       "      <td>Valve</td>\n",
       "      <td>20000000</td>\n",
       "      <td>Valve</td>\n",
       "      <td>88%</td>\n",
       "      <td>$9.99</td>\n",
       "      <td>['Action']</td>\n",
       "      <td>['Action','FPS','Multiplayer','Shooter','Class...</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>30</td>\n",
       "      <td>Day of Defeat</td>\n",
       "      <td>Valve</td>\n",
       "      <td>10000000</td>\n",
       "      <td>Valve</td>\n",
       "      <td>79%</td>\n",
       "      <td>$4.99</td>\n",
       "      <td>['Action']</td>\n",
       "      <td>['FPS','World_War_II','Multiplayer','Shooter',...</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>70</td>\n",
       "      <td>Half-Life</td>\n",
       "      <td>Valve</td>\n",
       "      <td>10000000</td>\n",
       "      <td>Valve</td>\n",
       "      <td>96%</td>\n",
       "      <td>$9.99</td>\n",
       "      <td>['Action']</td>\n",
       "      <td>['FPS','Classic','Action','Sci-fi','Singleplay...</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>80</td>\n",
       "      <td>Counter-Strike: Condition Zero</td>\n",
       "      <td>Valve</td>\n",
       "      <td>10000000</td>\n",
       "      <td>Valve</td>\n",
       "      <td>65%</td>\n",
       "      <td>$9.99</td>\n",
       "      <td>['Action']</td>\n",
       "      <td>['Action','FPS','Shooter','Multiplayer','First...</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>100</td>\n",
       "      <td>Counter-Strike: Condition Zero</td>\n",
       "      <td>Valve</td>\n",
       "      <td>20000000</td>\n",
       "      <td>Valve</td>\n",
       "      <td>65%</td>\n",
       "      <td>$9.99</td>\n",
       "      <td>['Action']</td>\n",
       "      <td>['Action','FPS','Shooter','Multiplayer','First...</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83966</th>\n",
       "      <td>1286830</td>\n",
       "      <td>STAR WARS: The Old Republic</td>\n",
       "      <td>BioWare</td>\n",
       "      <td>2000000</td>\n",
       "      <td>Electronic Arts</td>\n",
       "      <td>85%</td>\n",
       "      <td>$0.00</td>\n",
       "      <td>['Free_to_Play','Massively_Multiplayer','RPG']</td>\n",
       "      <td>['Free_to_Play','MMORPG','Multiplayer','RPG','...</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85672</th>\n",
       "      <td>1311510</td>\n",
       "      <td>Embracelet</td>\n",
       "      <td>Mattis Folkestad</td>\n",
       "      <td>20000</td>\n",
       "      <td>machineboy</td>\n",
       "      <td>86%</td>\n",
       "      <td>$12.99</td>\n",
       "      <td>['Adventure','Indie']</td>\n",
       "      <td>['Adventure','Indie','Story_Rich','Music','Exp...</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86889</th>\n",
       "      <td>1328660</td>\n",
       "      <td>Need for Speed Hot Pursuit Remastered</td>\n",
       "      <td>Stellar Entertainment Limited</td>\n",
       "      <td>20000</td>\n",
       "      <td>Electronic Arts</td>\n",
       "      <td>74%</td>\n",
       "      <td>$29.99</td>\n",
       "      <td>['Action','Racing']</td>\n",
       "      <td>['Combat_Racing','Racing','Open_World','Drivin...</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87795</th>\n",
       "      <td>1342620</td>\n",
       "      <td>Werewolf: The Apocalypse â€” Heart of the Forest</td>\n",
       "      <td>Different Tales</td>\n",
       "      <td>500000</td>\n",
       "      <td>Walkabout</td>\n",
       "      <td>78%</td>\n",
       "      <td>$14.99</td>\n",
       "      <td>['Adventure','Indie','RPG']</td>\n",
       "      <td>['Werewolves','Visual_Novel','RPG','Psychologi...</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88688</th>\n",
       "      <td>1356670</td>\n",
       "      <td>Sakuna: Of Rice and Ruin</td>\n",
       "      <td>Edelweiss</td>\n",
       "      <td>100000</td>\n",
       "      <td>XSEED Games</td>\n",
       "      <td>79%</td>\n",
       "      <td>$39.99</td>\n",
       "      <td>['Action','Indie']</td>\n",
       "      <td>['Action','Farming_Sim','Story_Rich','Side_Scr...</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4005 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        App Id                                              Name  \\\n",
       "2           10                                    Counter-Strike   \n",
       "4           30                                     Day of Defeat   \n",
       "8           70                                         Half-Life   \n",
       "9           80                    Counter-Strike: Condition Zero   \n",
       "12         100                    Counter-Strike: Condition Zero   \n",
       "...        ...                                               ...   \n",
       "83966  1286830                       STAR WARS: The Old Republic   \n",
       "85672  1311510                                        Embracelet   \n",
       "86889  1328660             Need for Speed Hot Pursuit Remastered   \n",
       "87795  1342620  Werewolf: The Apocalypse â€” Heart of the Forest   \n",
       "88688  1356670                          Sakuna: Of Rice and Ruin   \n",
       "\n",
       "                          Developers  max owners       Publishers Metascores  \\\n",
       "2                              Valve    20000000            Valve        88%   \n",
       "4                              Valve    10000000            Valve        79%   \n",
       "8                              Valve    10000000            Valve        96%   \n",
       "9                              Valve    10000000            Valve        65%   \n",
       "12                             Valve    20000000            Valve        65%   \n",
       "...                              ...         ...              ...        ...   \n",
       "83966                        BioWare     2000000  Electronic Arts        85%   \n",
       "85672               Mattis Folkestad       20000       machineboy        86%   \n",
       "86889  Stellar Entertainment Limited       20000  Electronic Arts        74%   \n",
       "87795                Different Tales      500000        Walkabout        78%   \n",
       "88688                      Edelweiss      100000      XSEED Games        79%   \n",
       "\n",
       "         Price                                    clean_genres  \\\n",
       "2       $9.99                                       ['Action']   \n",
       "4       $4.99                                       ['Action']   \n",
       "8       $9.99                                       ['Action']   \n",
       "9       $9.99                                       ['Action']   \n",
       "12      $9.99                                       ['Action']   \n",
       "...        ...                                             ...   \n",
       "83966   $0.00   ['Free_to_Play','Massively_Multiplayer','RPG']   \n",
       "85672  $12.99                            ['Adventure','Indie']   \n",
       "86889  $29.99                              ['Action','Racing']   \n",
       "87795  $14.99                      ['Adventure','Indie','RPG']   \n",
       "88688  $39.99                               ['Action','Indie']   \n",
       "\n",
       "                                              clean_tags  Hit  \n",
       "2      ['Action','FPS','Multiplayer','Shooter','Class...  1.0  \n",
       "4      ['FPS','World_War_II','Multiplayer','Shooter',...  1.0  \n",
       "8      ['FPS','Classic','Action','Sci-fi','Singleplay...  1.0  \n",
       "9      ['Action','FPS','Shooter','Multiplayer','First...  1.0  \n",
       "12     ['Action','FPS','Shooter','Multiplayer','First...  1.0  \n",
       "...                                                  ...  ...  \n",
       "83966  ['Free_to_Play','MMORPG','Multiplayer','RPG','...  1.0  \n",
       "85672  ['Adventure','Indie','Story_Rich','Music','Exp...  0.0  \n",
       "86889  ['Combat_Racing','Racing','Open_World','Drivin...  0.0  \n",
       "87795  ['Werewolves','Visual_Novel','RPG','Psychologi...  1.0  \n",
       "88688  ['Action','Farming_Sim','Story_Rich','Side_Scr...  0.0  \n",
       "\n",
       "[4005 rows x 10 columns]"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "steam_data_clean_2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "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>App Id</th>\n",
       "      <th>Name</th>\n",
       "      <th>Developers</th>\n",
       "      <th>Publishers</th>\n",
       "      <th>Metascores</th>\n",
       "      <th>Price</th>\n",
       "      <th>clean_genres</th>\n",
       "      <th>clean_tags</th>\n",
       "      <th>Hit</th>\n",
       "      <th>action_x</th>\n",
       "      <th>...</th>\n",
       "      <th>accounting</th>\n",
       "      <th>nudity_y</th>\n",
       "      <th>sexual_content_y</th>\n",
       "      <th>documentary_y</th>\n",
       "      <th>episodic_y</th>\n",
       "      <th>movie_y</th>\n",
       "      <th>short_y</th>\n",
       "      <th>tutorial_y</th>\n",
       "      <th>360_video_y</th>\n",
       "      <th>360_v</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>10</td>\n",
       "      <td>Counter-Strike</td>\n",
       "      <td>Valve</td>\n",
       "      <td>Valve</td>\n",
       "      <td>88%</td>\n",
       "      <td>$9.99</td>\n",
       "      <td>['Action']</td>\n",
       "      <td>['Action','FPS','Multiplayer','Shooter','Class...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>30</td>\n",
       "      <td>Day of Defeat</td>\n",
       "      <td>Valve</td>\n",
       "      <td>Valve</td>\n",
       "      <td>79%</td>\n",
       "      <td>$4.99</td>\n",
       "      <td>['Action']</td>\n",
       "      <td>['FPS','World_War_II','Multiplayer','Shooter',...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>70</td>\n",
       "      <td>Half-Life</td>\n",
       "      <td>Valve</td>\n",
       "      <td>Valve</td>\n",
       "      <td>96%</td>\n",
       "      <td>$9.99</td>\n",
       "      <td>['Action']</td>\n",
       "      <td>['FPS','Classic','Action','Sci-fi','Singleplay...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>80</td>\n",
       "      <td>Counter-Strike: Condition Zero</td>\n",
       "      <td>Valve</td>\n",
       "      <td>Valve</td>\n",
       "      <td>65%</td>\n",
       "      <td>$9.99</td>\n",
       "      <td>['Action']</td>\n",
       "      <td>['Action','FPS','Shooter','Multiplayer','First...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>100</td>\n",
       "      <td>Counter-Strike: Condition Zero</td>\n",
       "      <td>Valve</td>\n",
       "      <td>Valve</td>\n",
       "      <td>65%</td>\n",
       "      <td>$9.99</td>\n",
       "      <td>['Action']</td>\n",
       "      <td>['Action','FPS','Shooter','Multiplayer','First...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56390</th>\n",
       "      <td>785740</td>\n",
       "      <td>This Is the Police 2</td>\n",
       "      <td>Weappy Studio</td>\n",
       "      <td>THQ Nordic</td>\n",
       "      <td>66%</td>\n",
       "      <td>$14.99</td>\n",
       "      <td>['Adventure','Indie','Strategy']</td>\n",
       "      <td>['Strategy','Singleplayer','Story_Rich','Turn-...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56395</th>\n",
       "      <td>785790</td>\n",
       "      <td>WHAT THE GOLF?</td>\n",
       "      <td>Triband</td>\n",
       "      <td>Triband</td>\n",
       "      <td>83%</td>\n",
       "      <td>$19.99</td>\n",
       "      <td>['Action','Adventure','Casual','Indie','Simula...</td>\n",
       "      <td>['Memes','Level_Editor','Comedy','Physics','In...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56453</th>\n",
       "      <td>786580</td>\n",
       "      <td>Gleaner Heights</td>\n",
       "      <td>Emilios Manolidis</td>\n",
       "      <td>Emilios Manolidis</td>\n",
       "      <td>65%</td>\n",
       "      <td>$9.99</td>\n",
       "      <td>['Action','Adventure','Casual','Indie','RPG','...</td>\n",
       "      <td>['Farming_Sim','RPG','Indie','Simulation','Adv...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56523</th>\n",
       "      <td>787480</td>\n",
       "      <td>Phoenix Wright: Ace Attorney Trilogy</td>\n",
       "      <td>CAPCOM Co., Ltd.</td>\n",
       "      <td>CAPCOM Co., Ltd.</td>\n",
       "      <td>80%</td>\n",
       "      <td>$29.99</td>\n",
       "      <td>['Adventure']</td>\n",
       "      <td>['Visual_Novel','Detective','Story_Rich','Grea...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56550</th>\n",
       "      <td>787860</td>\n",
       "      <td>Farming Simulator 19</td>\n",
       "      <td>Giants Software</td>\n",
       "      <td>Focus Home Interactive</td>\n",
       "      <td>73%</td>\n",
       "      <td>$19.99</td>\n",
       "      <td>['Simulation']</td>\n",
       "      <td>['Simulation','Farming_Sim','Multiplayer','Agr...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3689 rows × 494 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       App Id                                  Name         Developers  \\\n",
       "2          10                        Counter-Strike              Valve   \n",
       "4          30                         Day of Defeat              Valve   \n",
       "8          70                             Half-Life              Valve   \n",
       "9          80        Counter-Strike: Condition Zero              Valve   \n",
       "12        100        Counter-Strike: Condition Zero              Valve   \n",
       "...       ...                                   ...                ...   \n",
       "56390  785740                  This Is the Police 2      Weappy Studio   \n",
       "56395  785790                        WHAT THE GOLF?            Triband   \n",
       "56453  786580                       Gleaner Heights  Emilios Manolidis   \n",
       "56523  787480  Phoenix Wright: Ace Attorney Trilogy   CAPCOM Co., Ltd.   \n",
       "56550  787860                  Farming Simulator 19    Giants Software   \n",
       "\n",
       "                   Publishers Metascores    Price  \\\n",
       "2                       Valve        88%   $9.99    \n",
       "4                       Valve        79%   $4.99    \n",
       "8                       Valve        96%   $9.99    \n",
       "9                       Valve        65%   $9.99    \n",
       "12                      Valve        65%   $9.99    \n",
       "...                       ...        ...      ...   \n",
       "56390              THQ Nordic        66%  $14.99    \n",
       "56395                 Triband        83%  $19.99    \n",
       "56453       Emilios Manolidis        65%   $9.99    \n",
       "56523        CAPCOM Co., Ltd.        80%  $29.99    \n",
       "56550  Focus Home Interactive        73%  $19.99    \n",
       "\n",
       "                                            clean_genres  \\\n",
       "2                                             ['Action']   \n",
       "4                                             ['Action']   \n",
       "8                                             ['Action']   \n",
       "9                                             ['Action']   \n",
       "12                                            ['Action']   \n",
       "...                                                  ...   \n",
       "56390                   ['Adventure','Indie','Strategy']   \n",
       "56395  ['Action','Adventure','Casual','Indie','Simula...   \n",
       "56453  ['Action','Adventure','Casual','Indie','RPG','...   \n",
       "56523                                      ['Adventure']   \n",
       "56550                                     ['Simulation']   \n",
       "\n",
       "                                              clean_tags  Hit  action_x  ...  \\\n",
       "2      ['Action','FPS','Multiplayer','Shooter','Class...  1.0         0  ...   \n",
       "4      ['FPS','World_War_II','Multiplayer','Shooter',...  1.0         0  ...   \n",
       "8      ['FPS','Classic','Action','Sci-fi','Singleplay...  1.0         0  ...   \n",
       "9      ['Action','FPS','Shooter','Multiplayer','First...  1.0         0  ...   \n",
       "12     ['Action','FPS','Shooter','Multiplayer','First...  1.0         0  ...   \n",
       "...                                                  ...  ...       ...  ...   \n",
       "56390  ['Strategy','Singleplayer','Story_Rich','Turn-...  1.0         0  ...   \n",
       "56395  ['Memes','Level_Editor','Comedy','Physics','In...  0.0         0  ...   \n",
       "56453  ['Farming_Sim','RPG','Indie','Simulation','Adv...  0.0         0  ...   \n",
       "56523  ['Visual_Novel','Detective','Story_Rich','Grea...  1.0         0  ...   \n",
       "56550  ['Simulation','Farming_Sim','Multiplayer','Agr...  1.0         1  ...   \n",
       "\n",
       "       accounting  nudity_y  sexual_content_y  documentary_y  episodic_y  \\\n",
       "2               0         0                 0              0           0   \n",
       "4               0         0                 0              0           0   \n",
       "8               0         0                 0              0           0   \n",
       "9               0         0                 0              0           0   \n",
       "12              0         0                 0              0           0   \n",
       "...           ...       ...               ...            ...         ...   \n",
       "56390           0         1                 0              0           1   \n",
       "56395           0         0                 0              0           0   \n",
       "56453           0         1                 0              1           0   \n",
       "56523           0         0                 0              0           0   \n",
       "56550           0         1                 0              0           0   \n",
       "\n",
       "       movie_y  short_y  tutorial_y  360_video_y  360_v  \n",
       "2            0        0           0            0      0  \n",
       "4            0        0           0            0      0  \n",
       "8            0        0           0            0      0  \n",
       "9            0        0           0            0      0  \n",
       "12           0        0           0            0      0  \n",
       "...        ...      ...         ...          ...    ...  \n",
       "56390        0        0           0            0      0  \n",
       "56395        0        0           0            0      0  \n",
       "56453        0        0           0            0      0  \n",
       "56523        0        0           0            0      0  \n",
       "56550        0        0           0            0      0  \n",
       "\n",
       "[3689 rows x 494 columns]"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mergedf = steam_data_clean_2.merge(encoded_merge, left_index=True, right_index=True)\n",
    "mergedf"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [],
   "source": [
    "steam_data_clean.to_csv('mergedf2.csv', index = True, header=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# steam_data_clean[\"Genres\"] = steam_data_clean[\"Genres\"].replace(\"'\",\"\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# steam_data_clean.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# stripped_genres = []\n",
    "\n",
    "# for i in steam_data_clean[\"Genres\"]:\n",
    "#     x = i.replace(\"'\",\"\")\n",
    "#     stripped_genres.append(x)\n",
    "    \n",
    "# len(stripped_genres)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# stripped_genres"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# steam_data_clean[\"Genres\"] = stripped_genres"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# steam_data_clean.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# steam_data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# steam_data_clean[\"Genres\"] = steam_data_clean[\"Genres\"].apply(eval)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# genre_dict = {}\n",
    "# for i in steam_data_clean[\"Genres\"]:\n",
    "#     for j in i:\n",
    "#         if j not in genre_dict:\n",
    "#             genre_dict[j] = 1\n",
    "#         else:\n",
    "#             genre_dict[j] += 1\n",
    "# genre_dict"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# genre_explode = steam_data_clean.explode(\"Genres\")\n",
    "# genre_explode"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# steam_data_clean.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# len(steam_data_clean[\"Genres\"].iloc[0].replace(\"[\", \"\").replace(\"]\", \"\").split(\",\"))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# i = 3\n",
    "# stored_data = []\n",
    "# genre_series = []\n",
    "\n",
    "# #for i in range(5):\n",
    "# if len(steam_data_clean[\"Genres\"].iloc[i].replace(\"[\", \"\").replace(\"]\", \"\").split(\",\")) == 1:\n",
    "#     stored_data.append(steam_data_clean.iloc[i, :])\n",
    "#     genre_series.append(steam_data_clean[\"Genres\"].iloc[i].replace(\"[\", \"\").replace(\"]\", \"\").split(\",\")[0])\n",
    "# elif len(steam_data_clean[\"Genres\"].iloc[i].replace(\"[\", \"\").replace(\"]\", \"\").split(\",\")) == 2:\n",
    "#     genre_list = steam_data_clean[\"Genres\"].iloc[i].replace(\"[\", \"\").replace(\"]\", \"\").split(\",\")\n",
    "#     genre_series.append(genre_list[0])\n",
    "#     genre_series.append(genre_list[1])\n",
    "#     stored_data.append(steam_data_clean.iloc[i, :])\n",
    "#     stored_data.append(steam_data_clean.iloc[i, :])\n",
    "# elif len(steam_data_clean[\"Genres\"].iloc[i].replace(\"[\", \"\").replace(\"]\", \"\").split(\",\")) == 3:\n",
    "#     genre_list = steam_data_clean[\"Genres\"].iloc[i].replace(\"[\", \"\").replace(\"]\", \"\").split(\",\")\n",
    "#     genre_series.append(genre_list[0])\n",
    "#     genre_series.append(genre_list[1])\n",
    "#     genre_series.append(genre_list[2])\n",
    "#     stored_data.append(steam_data_clean.iloc[i, :])\n",
    "#     stored_data.append(steam_data_clean.iloc[i, :])\n",
    "#     stored_data.append(steam_data_clean.iloc[i, :])\n",
    "# elif len(steam_data_clean[\"Genres\"].iloc[i].replace(\"[\", \"\").replace(\"]\", \"\").split(\",\")) == 4:\n",
    "#     genre_list = steam_data_clean[\"Genres\"].iloc[i].replace(\"[\", \"\").replace(\"]\", \"\").split(\",\")\n",
    "#     genre_series.append(genre_list[0])\n",
    "#     genre_series.append(genre_list[1])\n",
    "#     genre_series.append(genre_list[2])\n",
    "#     genre_series.append(genre_list[3])\n",
    "#     stored_data.append(steam_data_clean.iloc[i, :])\n",
    "#     stored_data.append(steam_data_clean.iloc[i, :])\n",
    "#     stored_data.append(steam_data_clean.iloc[i, :])\n",
    "#     stored_data.append(steam_data_clean.iloc[i, :])\n",
    "# elif len(steam_data_clean[\"Genres\"].iloc[i].replace(\"[\", \"\").replace(\"]\", \"\").split(\",\")) == 5:\n",
    "#     genre_list = steam_data_clean[\"Genres\"].iloc[i].replace(\"[\", \"\").replace(\"]\", \"\").split(\",\")\n",
    "#     genre_series.append(genre_list[0])\n",
    "#     genre_series.append(genre_list[1])\n",
    "#     genre_series.append(genre_list[2])\n",
    "#     genre_series.append(genre_list[3])\n",
    "#     genre_series.append(genre_list[4])\n",
    "#     stored_data.append(steam_data_clean.iloc[i, :])\n",
    "#     stored_data.append(steam_data_clean.iloc[i, :])\n",
    "#     stored_data.append(steam_data_clean.iloc[i, :])\n",
    "#     stored_data.append(steam_data_clean.iloc[i, :])\n",
    "#     stored_data.append(steam_data_clean.iloc[i, :])\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# stored_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# test = pd.DataFrame(stored_data)\n",
    "\n",
    "# test"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# genre_series"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# # create new dataframe where every column is the same EXCEPT the genres. if there is a game with 2 genres, make 2 rows where \n",
    "# # column is the same except for the genre.\n",
    "\n",
    "# stored_data = []\n",
    "# genre_series = []\n",
    "\n",
    "# for i in range(steam_data_clean.shape[0]):\n",
    "#     if len(steam_data_clean[\"Genres\"].iloc[i].replace(\"[\", \"\").replace(\"]\", \"\").split(\",\")) == 1:\n",
    "#         stored_data.append(steam_data_clean.iloc[i, :])\n",
    "#         genre_series.append(steam_data_clean[\"Genres\"].iloc[i].replace(\"[\", \"\").replace(\"]\", \"\").split(\",\")[0])\n",
    "#     elif len(steam_data_clean[\"Genres\"].iloc[i].replace(\"[\", \"\").replace(\"]\", \"\").split(\",\")) == 2:\n",
    "#         genre_list = steam_data_clean[\"Genres\"].iloc[i].replace(\"[\", \"\").replace(\"]\", \"\").split(\",\")\n",
    "#         genre_series.append(genre_list[0])\n",
    "#         genre_series.append(genre_list[1])\n",
    "#         stored_data.append(steam_data_clean.iloc[i, :])\n",
    "#         stored_data.append(steam_data_clean.iloc[i, :])\n",
    "#     elif len(steam_data_clean[\"Genres\"].iloc[i].replace(\"[\", \"\").replace(\"]\", \"\").split(\",\")) == 3:\n",
    "#         genre_list = steam_data_clean[\"Genres\"].iloc[i].replace(\"[\", \"\").replace(\"]\", \"\").split(\",\")\n",
    "#         genre_series.append(genre_list[0])\n",
    "#         genre_series.append(genre_list[1])\n",
    "#         genre_series.append(genre_list[2])\n",
    "#         stored_data.append(steam_data_clean.iloc[i, :])\n",
    "#         stored_data.append(steam_data_clean.iloc[i, :])\n",
    "#         stored_data.append(steam_data_clean.iloc[i, :])\n",
    "#     elif len(steam_data_clean[\"Genres\"].iloc[i].replace(\"[\", \"\").replace(\"]\", \"\").split(\",\")) == 4:\n",
    "#         genre_list = steam_data_clean[\"Genres\"].iloc[i].replace(\"[\", \"\").replace(\"]\", \"\").split(\",\")\n",
    "#         genre_series.append(genre_list[0])\n",
    "#         genre_series.append(genre_list[1])\n",
    "#         genre_series.append(genre_list[2])\n",
    "#         genre_series.append(genre_list[3])\n",
    "#         stored_data.append(steam_data_clean.iloc[i, :])\n",
    "#         stored_data.append(steam_data_clean.iloc[i, :])\n",
    "#         stored_data.append(steam_data_clean.iloc[i, :])\n",
    "#         stored_data.append(steam_data_clean.iloc[i, :])\n",
    "#     elif len(steam_data_clean[\"Genres\"].iloc[i].replace(\"[\", \"\").replace(\"]\", \"\").split(\",\")) == 5:\n",
    "#         genre_list = steam_data_clean[\"Genres\"].iloc[i].replace(\"[\", \"\").replace(\"]\", \"\").split(\",\")\n",
    "#         genre_series.append(genre_list[0])\n",
    "#         genre_series.append(genre_list[1])\n",
    "#         genre_series.append(genre_list[2])\n",
    "#         genre_series.append(genre_list[3])\n",
    "#         genre_series.append(genre_list[4])\n",
    "#         stored_data.append(steam_data_clean.iloc[i, :])\n",
    "#         stored_data.append(steam_data_clean.iloc[i, :])\n",
    "#         stored_data.append(steam_data_clean.iloc[i, :])\n",
    "#         stored_data.append(steam_data_clean.iloc[i, :])\n",
    "#         stored_data.append(steam_data_clean.iloc[i, :])\n",
    "\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# genre_df = pd.DataFrame(stored_data)\n",
    "\n",
    "# genre_df.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "# genre_df[\"Genres\"] = genre_series\n",
    "\n",
    "# genre_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# # # create new dataframe where every column is the same EXCEPT the genres. if there is a game with 2 genres, make 2 rows where \n",
    "# # # column is the same except for the genre.\n",
    "\n",
    "# stored_data_tags = []\n",
    "# Tags_series = []\n",
    "\n",
    "# for i in range(genre_explode.shape[0]):\n",
    "#     if len(steam_data_clean[\"Tags\"].iloc[i].replace(\"[\", \"\").replace(\"]\", \"\").split(\",\")) == 1:\n",
    "#         stored_data_tags.append(steam_data_clean.iloc[i, :])\n",
    "#         genre_series.append(steam_data_clean[\"Tags\"].iloc[i].replace(\"[\", \"\").replace(\"]\", \"\").split(\",\")[0])\n",
    "#     elif len(steam_data_clean[\"Tags\"].iloc[i].replace(\"[\", \"\").replace(\"]\", \"\").split(\",\")) == 2:\n",
    "#         genre_list = steam_data_clean[\"Tags\"].iloc[i].replace(\"[\", \"\").replace(\"]\", \"\").split(\",\")\n",
    "#         genre_series.append(genre_list[0])\n",
    "#         genre_series.append(genre_list[1])\n",
    "#         stored_data.append(steam_data_clean.iloc[i, :])\n",
    "#         stored_data.append(steam_data_clean.iloc[i, :])\n",
    "#     elif len(steam_data_clean[\"Tags\"].iloc[i].replace(\"[\", \"\").replace(\"]\", \"\").split(\",\")) == 3:\n",
    "#         genre_list = steam_data_clean[\"Tags\"].iloc[i].replace(\"[\", \"\").replace(\"]\", \"\").split(\",\")\n",
    "#         genre_series.append(genre_list[0])\n",
    "#         genre_series.append(genre_list[1])\n",
    "#         genre_series.append(genre_list[2])\n",
    "#         stored_data.append(steam_data_clean.iloc[i, :])\n",
    "#         stored_data.append(steam_data_clean.iloc[i, :])\n",
    "#         stored_data.append(steam_data_clean.iloc[i, :])\n",
    "#     elif len(steam_data_clean[\"Tags\"].iloc[i].replace(\"[\", \"\").replace(\"]\", \"\").split(\",\")) == 4:\n",
    "#         genre_list = steam_data_clean[\"Tags\"].iloc[i].replace(\"[\", \"\").replace(\"]\", \"\").split(\",\")\n",
    "#         genre_series.append(genre_list[0])\n",
    "#         genre_series.append(genre_list[1])\n",
    "#         genre_series.append(genre_list[2])\n",
    "#         genre_series.append(genre_list[3])\n",
    "#         stored_data.append(steam_data_clean.iloc[i, :])\n",
    "#         stored_data.append(steam_data_clean.iloc[i, :])\n",
    "#         stored_data.append(steam_data_clean.iloc[i, :])\n",
    "#         stored_data.append(steam_data_clean.iloc[i, :])\n",
    "#     elif len(steam_data_clean[\"Tags\"].iloc[i].replace(\"[\", \"\").replace(\"]\", \"\").split(\",\")) == 5:\n",
    "#         genre_list = steam_data_clean[\"Tags\"].iloc[i].replace(\"[\", \"\").replace(\"]\", \"\").split(\",\")\n",
    "#         genre_series.append(genre_list[0])\n",
    "#         genre_series.append(genre_list[1])\n",
    "#         genre_series.append(genre_list[2])\n",
    "#         genre_series.append(genre_list[3])\n",
    "#         genre_series.append(genre_list[4])\n",
    "#         stored_data.append(steam_data_clean.iloc[i, :])\n",
    "#         stored_data.append(steam_data_clean.iloc[i, :])\n",
    "#         stored_data.append(steam_data_clean.iloc[i, :])\n",
    "#         stored_data.append(steam_data_clean.iloc[i, :])\n",
    "#         stored_data.append(steam_data_clean.iloc[i, :])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# genre_explode[\"Tags\"] = genre_explode[\"Tags\"].apply(eval)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# tag_dict = {}\n",
    "# for i in genre_explode[\"Tags\"]:\n",
    "#     for j in i:\n",
    "#         if j not in tag_dict:\n",
    "#             tag_dict[j] = 1\n",
    "#         else:\n",
    "#             tag_dict[j] += 1\n",
    "# tag_dict"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# tag_explode = genre_explode.explode(\"Tags\")\n",
    "# tag_explode"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# tag_explode['max owners'] = tag_explode['max owners'].replace(\",\",\"\")\n",
    "# # tag_explode.dtypes\n",
    "# tag_explode.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# x = tag_explode[\"max owners\"].iloc[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# x.replace(\",\", \"\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# tag_explode[\"max owners\"] = pd.Series(tag_explode[\"max owners\"]).str.replace(',', \"\")\n",
    "# tag_explode.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# tag_explode[\"min owners\"] = pd.Series(tag_explode[\"min owners\"]).str.replace(',', \"\")\n",
    "# tag_explode.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# tag_explode"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# own_med = tag_explode[\"max owners\"].median()\n",
    "# own_med\n",
    "# own_max = tag_explode[\"max owners\"].max()\n",
    "# own_max\n",
    "# own_med"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# tag_explode['max owners'] = tag_explode['max owners'].astype(int)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# tag_explode.loc[tag_explode[\"max owners\"]>= 200000.0, \"Hit\"] = 1\n",
    "# tag_explode.loc[tag_explode[\"max owners\"]< 200000.0, \"Hit\"] = 0\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# tag_explode"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# tag_explode.to_csv('final_project_hits.csv', index = False, header=True)\n"
   ]
  }
 ],
 "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.8.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}