PUBG Player Recommendation System.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<h1>This is a PUBG player Recommendation System Algorithm</h1>\n",
    "<br>\n",
    "Based on where you land, how you play, how often do you play and many more criteria, you will be given a list of other players who are like you.<br>\n",
    "The data set used is small as it was generated from scartch via a google form. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Dataframe manipulation library\n",
    "import pandas as pd\n",
    "#Math functions, we'll only need the sqrt function so let's import only that\n",
    "from math import sqrt\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<h2>Importing Data</h2>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "df=pd.read_csv(\"C:/Users/Sanyam Srivastava/Desktop/PUBG Gameplay Survey.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Timestamp</th>\n",
       "      <th>NameOrID</th>\n",
       "      <th>RateSkills</th>\n",
       "      <th>GameplayStyle</th>\n",
       "      <th>drop</th>\n",
       "      <th>Language</th>\n",
       "      <th>RankPusher</th>\n",
       "      <th>PlayDays</th>\n",
       "      <th>PlayerType</th>\n",
       "      <th>MapPreference</th>\n",
       "      <th>Driver</th>\n",
       "      <th>camp</th>\n",
       "      <th>snake</th>\n",
       "      <th>bridgecamp</th>\n",
       "      <th>Unnamed: 14</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020/04/30 8:05:17 PM GMT+5:30</td>\n",
       "      <td>MiuSan×</td>\n",
       "      <td>3</td>\n",
       "      <td>Moderate rush</td>\n",
       "      <td>Georgopol;Novo;Military Base;Pochinki;School/A...</td>\n",
       "      <td>English;Hindi</td>\n",
       "      <td>No</td>\n",
       "      <td>Most days</td>\n",
       "      <td>No preference</td>\n",
       "      <td>Erangel</td>\n",
       "      <td>No</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>Started in early 2019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020/04/30 8:32:39 PM GMT+5:30</td>\n",
       "      <td>AZĪlĪSPYDER</td>\n",
       "      <td>4</td>\n",
       "      <td>Mostly rushing</td>\n",
       "      <td>Georgopol;Novo;Military Base;Pochinki;School/A...</td>\n",
       "      <td>English;Hindi</td>\n",
       "      <td>Casual pusher</td>\n",
       "      <td>Everyday</td>\n",
       "      <td>Support;Assault;Sniper</td>\n",
       "      <td>Erangel;Vikendi</td>\n",
       "      <td>No prefernce</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>Since Season 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020/05/07 11:02:04 AM GMT+5:30</td>\n",
       "      <td>AZĪIĪReApEr</td>\n",
       "      <td>4</td>\n",
       "      <td>Moderate rush</td>\n",
       "      <td>Military Base;Pochinki;School/Apartments;Rozho...</td>\n",
       "      <td>English;Hindi</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Everyday</td>\n",
       "      <td>Support;Sniper</td>\n",
       "      <td>Erangel</td>\n",
       "      <td>Yes</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020/05/07 11:02:47 AM GMT+5:30</td>\n",
       "      <td>Sonic</td>\n",
       "      <td>4</td>\n",
       "      <td>Mostly rushing</td>\n",
       "      <td>Georgopol;Novo;Military Base</td>\n",
       "      <td>English</td>\n",
       "      <td>Casual pusher</td>\n",
       "      <td>Most days</td>\n",
       "      <td>Assault;Sniper</td>\n",
       "      <td>Erangel</td>\n",
       "      <td>Yes</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020/05/07 11:06:10 AM GMT+5:30</td>\n",
       "      <td>GodEater</td>\n",
       "      <td>3</td>\n",
       "      <td>Moderate rush</td>\n",
       "      <td>No preference</td>\n",
       "      <td>English;Others</td>\n",
       "      <td>No</td>\n",
       "      <td>Most days</td>\n",
       "      <td>No preference</td>\n",
       "      <td>no preference</td>\n",
       "      <td>No prefernce</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         Timestamp     NameOrID  RateSkills   GameplayStyle  \\\n",
       "0   2020/04/30 8:05:17 PM GMT+5:30      MiuSan×           3   Moderate rush   \n",
       "1   2020/04/30 8:32:39 PM GMT+5:30  AZĪlĪSPYDER           4  Mostly rushing   \n",
       "2  2020/05/07 11:02:04 AM GMT+5:30  AZĪIĪReApEr           4   Moderate rush   \n",
       "3  2020/05/07 11:02:47 AM GMT+5:30        Sonic           4  Mostly rushing   \n",
       "4  2020/05/07 11:06:10 AM GMT+5:30     GodEater           3   Moderate rush   \n",
       "\n",
       "                                                drop        Language  \\\n",
       "0  Georgopol;Novo;Military Base;Pochinki;School/A...   English;Hindi   \n",
       "1  Georgopol;Novo;Military Base;Pochinki;School/A...   English;Hindi   \n",
       "2  Military Base;Pochinki;School/Apartments;Rozho...   English;Hindi   \n",
       "3                       Georgopol;Novo;Military Base         English   \n",
       "4                                      No preference  English;Others   \n",
       "\n",
       "      RankPusher   PlayDays              PlayerType    MapPreference  \\\n",
       "0             No  Most days           No preference          Erangel   \n",
       "1  Casual pusher   Everyday  Support;Assault;Sniper  Erangel;Vikendi   \n",
       "2            Yes   Everyday          Support;Sniper          Erangel   \n",
       "3  Casual pusher  Most days          Assault;Sniper          Erangel   \n",
       "4             No  Most days           No preference    no preference   \n",
       "\n",
       "         Driver  camp  snake  bridgecamp            Unnamed: 14  \n",
       "0            No     2      3           2  Started in early 2019  \n",
       "1  No prefernce     2      1           3         Since Season 1  \n",
       "2           Yes     3      2           4                    NaN  \n",
       "3           Yes     1      2           4                    NaN  \n",
       "4  No prefernce     2      2           1                    NaN  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<h2>Preprocessing</h2>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This dataset contains a few columns which needs to be dropped, like the last field and timestamp as well. They are not needed. <br><br>We will also drop the player type column, this is because we won't be needing a similar kind of player.eg: if you are a support player, you should be recommended an assault. This algo groups based on similarity and this attribute will be not suitable."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>NameOrID</th>\n",
       "      <th>RateSkills</th>\n",
       "      <th>GameplayStyle</th>\n",
       "      <th>drop</th>\n",
       "      <th>Language</th>\n",
       "      <th>RankPusher</th>\n",
       "      <th>PlayDays</th>\n",
       "      <th>MapPreference</th>\n",
       "      <th>Driver</th>\n",
       "      <th>camp</th>\n",
       "      <th>snake</th>\n",
       "      <th>bridgecamp</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>MiuSan×</td>\n",
       "      <td>3</td>\n",
       "      <td>Moderate rush</td>\n",
       "      <td>Georgopol;Novo;Military Base;Pochinki;School/A...</td>\n",
       "      <td>English;Hindi</td>\n",
       "      <td>No</td>\n",
       "      <td>Most days</td>\n",
       "      <td>Erangel</td>\n",
       "      <td>No</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AZĪlĪSPYDER</td>\n",
       "      <td>4</td>\n",
       "      <td>Mostly rushing</td>\n",
       "      <td>Georgopol;Novo;Military Base;Pochinki;School/A...</td>\n",
       "      <td>English;Hindi</td>\n",
       "      <td>Casual pusher</td>\n",
       "      <td>Everyday</td>\n",
       "      <td>Erangel;Vikendi</td>\n",
       "      <td>No prefernce</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AZĪIĪReApEr</td>\n",
       "      <td>4</td>\n",
       "      <td>Moderate rush</td>\n",
       "      <td>Military Base;Pochinki;School/Apartments;Rozho...</td>\n",
       "      <td>English;Hindi</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Everyday</td>\n",
       "      <td>Erangel</td>\n",
       "      <td>Yes</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Sonic</td>\n",
       "      <td>4</td>\n",
       "      <td>Mostly rushing</td>\n",
       "      <td>Georgopol;Novo;Military Base</td>\n",
       "      <td>English</td>\n",
       "      <td>Casual pusher</td>\n",
       "      <td>Most days</td>\n",
       "      <td>Erangel</td>\n",
       "      <td>Yes</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>GodEater</td>\n",
       "      <td>3</td>\n",
       "      <td>Moderate rush</td>\n",
       "      <td>No preference</td>\n",
       "      <td>English;Others</td>\n",
       "      <td>No</td>\n",
       "      <td>Most days</td>\n",
       "      <td>no preference</td>\n",
       "      <td>No prefernce</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      NameOrID  RateSkills   GameplayStyle  \\\n",
       "0      MiuSan×           3   Moderate rush   \n",
       "1  AZĪlĪSPYDER           4  Mostly rushing   \n",
       "2  AZĪIĪReApEr           4   Moderate rush   \n",
       "3        Sonic           4  Mostly rushing   \n",
       "4     GodEater           3   Moderate rush   \n",
       "\n",
       "                                                drop        Language  \\\n",
       "0  Georgopol;Novo;Military Base;Pochinki;School/A...   English;Hindi   \n",
       "1  Georgopol;Novo;Military Base;Pochinki;School/A...   English;Hindi   \n",
       "2  Military Base;Pochinki;School/Apartments;Rozho...   English;Hindi   \n",
       "3                       Georgopol;Novo;Military Base         English   \n",
       "4                                      No preference  English;Others   \n",
       "\n",
       "      RankPusher   PlayDays    MapPreference        Driver  camp  snake  \\\n",
       "0             No  Most days          Erangel            No     2      3   \n",
       "1  Casual pusher   Everyday  Erangel;Vikendi  No prefernce     2      1   \n",
       "2            Yes   Everyday          Erangel           Yes     3      2   \n",
       "3  Casual pusher  Most days          Erangel           Yes     1      2   \n",
       "4             No  Most days    no preference  No prefernce     2      2   \n",
       "\n",
       "   bridgecamp  \n",
       "0           2  \n",
       "1           3  \n",
       "2           4  \n",
       "3           4  \n",
       "4           1  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.drop('Timestamp', axis=1, inplace=True)\n",
    "df.drop('PlayerType', axis=1, inplace=True)\n",
    "df=df.iloc[:,0:12]\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 54 entries, 0 to 53\n",
      "Data columns (total 12 columns):\n",
      " #   Column         Non-Null Count  Dtype \n",
      "---  ------         --------------  ----- \n",
      " 0   NameOrID       54 non-null     object\n",
      " 1   RateSkills     54 non-null     int64 \n",
      " 2   GameplayStyle  54 non-null     object\n",
      " 3   drop           54 non-null     object\n",
      " 4   Language       54 non-null     object\n",
      " 5   RankPusher     54 non-null     object\n",
      " 6   PlayDays       54 non-null     object\n",
      " 7   MapPreference  54 non-null     object\n",
      " 8   Driver         54 non-null     object\n",
      " 9   camp           54 non-null     int64 \n",
      " 10  snake          54 non-null     int64 \n",
      " 11  bridgecamp     54 non-null     int64 \n",
      "dtypes: int64(4), object(8)\n",
      "memory usage: 5.2+ KB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "We need to convert the columns  with multiple inputs into a list of inputs.<br>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Every multi valued attribute is separated by a ; so we simply have to call the split function on ;\n",
    "df['drop'] = df['drop'].str.split(';')\n",
    "df['Language'] = df['Language'].str.split(';')\n",
    "df['MapPreference'] = df['MapPreference'].str.split(';')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>NameOrID</th>\n",
       "      <th>RateSkills</th>\n",
       "      <th>GameplayStyle</th>\n",
       "      <th>drop</th>\n",
       "      <th>Language</th>\n",
       "      <th>RankPusher</th>\n",
       "      <th>PlayDays</th>\n",
       "      <th>MapPreference</th>\n",
       "      <th>Driver</th>\n",
       "      <th>camp</th>\n",
       "      <th>snake</th>\n",
       "      <th>bridgecamp</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>MiuSan×</td>\n",
       "      <td>3</td>\n",
       "      <td>Moderate rush</td>\n",
       "      <td>[Georgopol, Novo, Military Base, Pochinki, Sch...</td>\n",
       "      <td>[English, Hindi]</td>\n",
       "      <td>No</td>\n",
       "      <td>Most days</td>\n",
       "      <td>[Erangel]</td>\n",
       "      <td>No</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AZĪlĪSPYDER</td>\n",
       "      <td>4</td>\n",
       "      <td>Mostly rushing</td>\n",
       "      <td>[Georgopol, Novo, Military Base, Pochinki, Sch...</td>\n",
       "      <td>[English, Hindi]</td>\n",
       "      <td>Casual pusher</td>\n",
       "      <td>Everyday</td>\n",
       "      <td>[Erangel, Vikendi]</td>\n",
       "      <td>No prefernce</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AZĪIĪReApEr</td>\n",
       "      <td>4</td>\n",
       "      <td>Moderate rush</td>\n",
       "      <td>[Military Base, Pochinki, School/Apartments, R...</td>\n",
       "      <td>[English, Hindi]</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Everyday</td>\n",
       "      <td>[Erangel]</td>\n",
       "      <td>Yes</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Sonic</td>\n",
       "      <td>4</td>\n",
       "      <td>Mostly rushing</td>\n",
       "      <td>[Georgopol, Novo, Military Base]</td>\n",
       "      <td>[English]</td>\n",
       "      <td>Casual pusher</td>\n",
       "      <td>Most days</td>\n",
       "      <td>[Erangel]</td>\n",
       "      <td>Yes</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>GodEater</td>\n",
       "      <td>3</td>\n",
       "      <td>Moderate rush</td>\n",
       "      <td>[No preference]</td>\n",
       "      <td>[English, Others]</td>\n",
       "      <td>No</td>\n",
       "      <td>Most days</td>\n",
       "      <td>[no preference]</td>\n",
       "      <td>No prefernce</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      NameOrID  RateSkills   GameplayStyle  \\\n",
       "0      MiuSan×           3   Moderate rush   \n",
       "1  AZĪlĪSPYDER           4  Mostly rushing   \n",
       "2  AZĪIĪReApEr           4   Moderate rush   \n",
       "3        Sonic           4  Mostly rushing   \n",
       "4     GodEater           3   Moderate rush   \n",
       "\n",
       "                                                drop           Language  \\\n",
       "0  [Georgopol, Novo, Military Base, Pochinki, Sch...   [English, Hindi]   \n",
       "1  [Georgopol, Novo, Military Base, Pochinki, Sch...   [English, Hindi]   \n",
       "2  [Military Base, Pochinki, School/Apartments, R...   [English, Hindi]   \n",
       "3                   [Georgopol, Novo, Military Base]          [English]   \n",
       "4                                    [No preference]  [English, Others]   \n",
       "\n",
       "      RankPusher   PlayDays       MapPreference        Driver  camp  snake  \\\n",
       "0             No  Most days           [Erangel]            No     2      3   \n",
       "1  Casual pusher   Everyday  [Erangel, Vikendi]  No prefernce     2      1   \n",
       "2            Yes   Everyday           [Erangel]           Yes     3      2   \n",
       "3  Casual pusher  Most days           [Erangel]           Yes     1      2   \n",
       "4             No  Most days     [no preference]  No prefernce     2      2   \n",
       "\n",
       "   bridgecamp  \n",
       "0           2  \n",
       "1           3  \n",
       "2           4  \n",
       "3           4  \n",
       "4           1  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<h2>Encoding Multi-input columns  </h2><br>Here, we split all the entries of  columns with multiple values seperately. This is just like hot bar encoding. <br> Other than this, we  need to convert Categorical data to numberic and then perform hot bar encoding on them as well.\n",
    "\n",
    "Here, I'm also alloting weightage values to the attributes. Language and map preference are the most important ones so they've value 2. Plane path, which is randomly decided every match has a huge impact on drop locations and this is why it has a weightage of 0.5"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>NameOrID</th>\n",
       "      <th>RateSkills</th>\n",
       "      <th>GameplayStyle</th>\n",
       "      <th>drop</th>\n",
       "      <th>Language</th>\n",
       "      <th>RankPusher</th>\n",
       "      <th>PlayDays</th>\n",
       "      <th>MapPreference</th>\n",
       "      <th>Driver</th>\n",
       "      <th>camp</th>\n",
       "      <th>...</th>\n",
       "      <th>zabaya</th>\n",
       "      <th>vihar</th>\n",
       "      <th>Factory</th>\n",
       "      <th>Mansion</th>\n",
       "      <th>la bendita</th>\n",
       "      <th>krichas</th>\n",
       "      <th>movatra</th>\n",
       "      <th>dino park</th>\n",
       "      <th>Chinese</th>\n",
       "      <th>Urdu</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>MiuSan×</td>\n",
       "      <td>3</td>\n",
       "      <td>Moderate rush</td>\n",
       "      <td>[Georgopol, Novo, Military Base, Pochinki, Sch...</td>\n",
       "      <td>[English, Hindi]</td>\n",
       "      <td>No</td>\n",
       "      <td>Most days</td>\n",
       "      <td>[Erangel]</td>\n",
       "      <td>No</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AZĪlĪSPYDER</td>\n",
       "      <td>4</td>\n",
       "      <td>Mostly rushing</td>\n",
       "      <td>[Georgopol, Novo, Military Base, Pochinki, Sch...</td>\n",
       "      <td>[English, Hindi]</td>\n",
       "      <td>Casual pusher</td>\n",
       "      <td>Everyday</td>\n",
       "      <td>[Erangel, Vikendi]</td>\n",
       "      <td>No prefernce</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AZĪIĪReApEr</td>\n",
       "      <td>4</td>\n",
       "      <td>Moderate rush</td>\n",
       "      <td>[Military Base, Pochinki, School/Apartments, R...</td>\n",
       "      <td>[English, Hindi]</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Everyday</td>\n",
       "      <td>[Erangel]</td>\n",
       "      <td>Yes</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Sonic</td>\n",
       "      <td>4</td>\n",
       "      <td>Mostly rushing</td>\n",
       "      <td>[Georgopol, Novo, Military Base]</td>\n",
       "      <td>[English]</td>\n",
       "      <td>Casual pusher</td>\n",
       "      <td>Most days</td>\n",
       "      <td>[Erangel]</td>\n",
       "      <td>Yes</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>GodEater</td>\n",
       "      <td>3</td>\n",
       "      <td>Moderate rush</td>\n",
       "      <td>[No preference]</td>\n",
       "      <td>[English, Others]</td>\n",
       "      <td>No</td>\n",
       "      <td>Most days</td>\n",
       "      <td>[no preference]</td>\n",
       "      <td>No prefernce</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 66 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      NameOrID  RateSkills   GameplayStyle  \\\n",
       "0      MiuSan×           3   Moderate rush   \n",
       "1  AZĪlĪSPYDER           4  Mostly rushing   \n",
       "2  AZĪIĪReApEr           4   Moderate rush   \n",
       "3        Sonic           4  Mostly rushing   \n",
       "4     GodEater           3   Moderate rush   \n",
       "\n",
       "                                                drop           Language  \\\n",
       "0  [Georgopol, Novo, Military Base, Pochinki, Sch...   [English, Hindi]   \n",
       "1  [Georgopol, Novo, Military Base, Pochinki, Sch...   [English, Hindi]   \n",
       "2  [Military Base, Pochinki, School/Apartments, R...   [English, Hindi]   \n",
       "3                   [Georgopol, Novo, Military Base]          [English]   \n",
       "4                                    [No preference]  [English, Others]   \n",
       "\n",
       "      RankPusher   PlayDays       MapPreference        Driver  camp  ...  \\\n",
       "0             No  Most days           [Erangel]            No     2  ...   \n",
       "1  Casual pusher   Everyday  [Erangel, Vikendi]  No prefernce     2  ...   \n",
       "2            Yes   Everyday           [Erangel]           Yes     3  ...   \n",
       "3  Casual pusher  Most days           [Erangel]           Yes     1  ...   \n",
       "4             No  Most days     [no preference]  No prefernce     2  ...   \n",
       "\n",
       "   zabaya  vihar  Factory  Mansion  la bendita  krichas  movatra  dino park  \\\n",
       "0     0.0    0.0      0.0      0.0         0.0      0.0      0.0        0.0   \n",
       "1     0.0    0.0      0.0      0.0         0.0      0.0      0.0        0.0   \n",
       "2     0.0    0.0      0.0      0.0         0.0      0.0      0.0        0.0   \n",
       "3     0.0    0.0      0.0      0.0         0.0      0.0      0.0        0.0   \n",
       "4     0.0    0.0      0.0      0.0         0.0      0.0      0.0        0.0   \n",
       "\n",
       "   Chinese  Urdu  \n",
       "0      0.0   0.0  \n",
       "1      0.0   0.0  \n",
       "2      0.0   0.0  \n",
       "3      0.0   0.0  \n",
       "4      0.0   0.0  \n",
       "\n",
       "[5 rows x 66 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "for index,row in df.iterrows():\n",
    "    for language in row['Language']:\n",
    "        df.at[index,language]=2\n",
    "    for dr in row['drop']:\n",
    "        df.at[index,dr]=0.5\n",
    "    for map in row['MapPreference']:\n",
    "        df.at[index,map]=1\n",
    "    \n",
    "df=df.fillna(0)\n",
    "df.head()    "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "We delete the initial columns as they are not needed."
   ]
  },
  {
   "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>NameOrID</th>\n",
       "      <th>RateSkills</th>\n",
       "      <th>GameplayStyle</th>\n",
       "      <th>RankPusher</th>\n",
       "      <th>PlayDays</th>\n",
       "      <th>Driver</th>\n",
       "      <th>camp</th>\n",
       "      <th>snake</th>\n",
       "      <th>bridgecamp</th>\n",
       "      <th>English</th>\n",
       "      <th>...</th>\n",
       "      <th>zabaya</th>\n",
       "      <th>vihar</th>\n",
       "      <th>Factory</th>\n",
       "      <th>Mansion</th>\n",
       "      <th>la bendita</th>\n",
       "      <th>krichas</th>\n",
       "      <th>movatra</th>\n",
       "      <th>dino park</th>\n",
       "      <th>Chinese</th>\n",
       "      <th>Urdu</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>MiuSan×</td>\n",
       "      <td>3</td>\n",
       "      <td>Moderate rush</td>\n",
       "      <td>No</td>\n",
       "      <td>Most days</td>\n",
       "      <td>No</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AZĪlĪSPYDER</td>\n",
       "      <td>4</td>\n",
       "      <td>Mostly rushing</td>\n",
       "      <td>Casual pusher</td>\n",
       "      <td>Everyday</td>\n",
       "      <td>No prefernce</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AZĪIĪReApEr</td>\n",
       "      <td>4</td>\n",
       "      <td>Moderate rush</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Everyday</td>\n",
       "      <td>Yes</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Sonic</td>\n",
       "      <td>4</td>\n",
       "      <td>Mostly rushing</td>\n",
       "      <td>Casual pusher</td>\n",
       "      <td>Most days</td>\n",
       "      <td>Yes</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>GodEater</td>\n",
       "      <td>3</td>\n",
       "      <td>Moderate rush</td>\n",
       "      <td>No</td>\n",
       "      <td>Most days</td>\n",
       "      <td>No prefernce</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 63 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      NameOrID  RateSkills   GameplayStyle     RankPusher   PlayDays  \\\n",
       "0      MiuSan×           3   Moderate rush             No  Most days   \n",
       "1  AZĪlĪSPYDER           4  Mostly rushing  Casual pusher   Everyday   \n",
       "2  AZĪIĪReApEr           4   Moderate rush            Yes   Everyday   \n",
       "3        Sonic           4  Mostly rushing  Casual pusher  Most days   \n",
       "4     GodEater           3   Moderate rush             No  Most days   \n",
       "\n",
       "         Driver  camp  snake  bridgecamp  English  ...  zabaya  vihar  \\\n",
       "0            No     2      3           2      2.0  ...     0.0    0.0   \n",
       "1  No prefernce     2      1           3      2.0  ...     0.0    0.0   \n",
       "2           Yes     3      2           4      2.0  ...     0.0    0.0   \n",
       "3           Yes     1      2           4      2.0  ...     0.0    0.0   \n",
       "4  No prefernce     2      2           1      2.0  ...     0.0    0.0   \n",
       "\n",
       "   Factory  Mansion  la bendita  krichas  movatra  dino park  Chinese  Urdu  \n",
       "0      0.0      0.0         0.0      0.0      0.0        0.0      0.0   0.0  \n",
       "1      0.0      0.0         0.0      0.0      0.0        0.0      0.0   0.0  \n",
       "2      0.0      0.0         0.0      0.0      0.0        0.0      0.0   0.0  \n",
       "3      0.0      0.0         0.0      0.0      0.0        0.0      0.0   0.0  \n",
       "4      0.0      0.0         0.0      0.0      0.0        0.0      0.0   0.0  \n",
       "\n",
       "[5 rows x 63 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.drop('MapPreference', axis=1, inplace=True)\n",
    "df.drop('Language', axis=1, inplace=True)\n",
    "df.drop('drop', axis=1, inplace=True)\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['NameOrID', 'RateSkills', 'GameplayStyle', 'RankPusher', 'PlayDays',\n",
       "       'Driver', 'camp', 'snake', 'bridgecamp', 'English', 'Hindi',\n",
       "       'Georgopol', 'Novo', 'Military Base', 'Pochinki', 'School/Apartments',\n",
       "       'Georgopol City', 'Mylta', 'Erangel', 'Rozhok', 'Severny', 'Vikendi',\n",
       "       'Others', 'No preference', 'no preference', 'Mylta Power', 'Prison',\n",
       "       'No mic', 'Paradise Resort', 'ha thin', 'san martin', 'el pozo',\n",
       "       'goroka', 'dobro mesto', 'volnova', 'coal mine', 'cement factory',\n",
       "       'Yasnaya', 'power grid', 'villa', 'port', 'others', 'Boot Camp(sanhok)',\n",
       "       'pecado', 'hacienda del patron', 'Castle(vikendi)', 'cosmodrome',\n",
       "       'Miramar', 'Sanhok', 'Korean', 'los leones', 'Quarry',\n",
       "       'power grid(miramar)', 'zabaya', 'vihar', 'Factory', 'Mansion',\n",
       "       'la bendita', 'krichas', 'movatra', 'dino park', 'Chinese', 'Urdu'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<h2>Encoding Single Input columns</h2><br>We perform hot bar encoding using get_dummies. First count all values of columns with categorical data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Moderate rush            32\n",
      "Safe with little risk     8\n",
      "Mostly rushing            8\n",
      "Always rushing            5\n",
      "Very Safe                 1\n",
      "Name: GameplayStyle, dtype: int64\n",
      "Casual pusher    29\n",
      "Yes              16\n",
      "No                9\n",
      "Name: RankPusher, dtype: int64\n",
      "Everyday     27\n",
      "Most days    20\n",
      "Weekends      5\n",
      "Weekdays      2\n",
      "Name: PlayDays, dtype: int64\n",
      "Yes             31\n",
      "No prefernce    12\n",
      "No              11\n",
      "Name: Driver, dtype: int64\n"
     ]
    }
   ],
   "source": [
    "print(df['GameplayStyle'].value_counts())\n",
    "print(df['RankPusher'].value_counts())\n",
    "print(df['PlayDays'].value_counts())\n",
    "print(df['Driver'].value_counts())"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This is going to create new attributes by spliting one into it's number of unique entries"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "df=pd.get_dummies(df, columns=[\"RankPusher\",\"GameplayStyle\",\"PlayDays\",\"Driver\"],prefix=[\"RankPusher\",\"GameplayStyle\",\"PlayDays\",\"Driver\"])\n",
    "df=pd.get_dummies(df, columns=[\"RateSkills\",\"camp\",\"snake\",\"bridgecamp\"],prefix=[\"RateSkills\",\"camp\",\"snake\",\"bridgecamp\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>NameOrID</th>\n",
       "      <th>English</th>\n",
       "      <th>Hindi</th>\n",
       "      <th>Georgopol</th>\n",
       "      <th>Novo</th>\n",
       "      <th>Military Base</th>\n",
       "      <th>Pochinki</th>\n",
       "      <th>School/Apartments</th>\n",
       "      <th>Georgopol City</th>\n",
       "      <th>Mylta</th>\n",
       "      <th>...</th>\n",
       "      <th>snake_1</th>\n",
       "      <th>snake_2</th>\n",
       "      <th>snake_3</th>\n",
       "      <th>snake_4</th>\n",
       "      <th>snake_5</th>\n",
       "      <th>bridgecamp_1</th>\n",
       "      <th>bridgecamp_2</th>\n",
       "      <th>bridgecamp_3</th>\n",
       "      <th>bridgecamp_4</th>\n",
       "      <th>bridgecamp_5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>MiuSan×</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>...</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>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AZĪlĪSPYDER</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>...</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",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AZĪIĪReApEr</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.5</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>3</th>\n",
       "      <td>Sonic</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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>4</th>\n",
       "      <td>GodEater</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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>1</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>5 rows × 89 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      NameOrID  English  Hindi  Georgopol  Novo  Military Base  Pochinki  \\\n",
       "0      MiuSan×      2.0    2.0        0.5   0.5            0.5       0.5   \n",
       "1  AZĪlĪSPYDER      2.0    2.0        0.5   0.5            0.5       0.5   \n",
       "2  AZĪIĪReApEr      2.0    2.0        0.0   0.0            0.5       0.5   \n",
       "3        Sonic      2.0    0.0        0.5   0.5            0.5       0.0   \n",
       "4     GodEater      2.0    0.0        0.0   0.0            0.0       0.0   \n",
       "\n",
       "   School/Apartments  Georgopol City  Mylta  ...  snake_1  snake_2  snake_3  \\\n",
       "0                0.5             0.5    0.5  ...        0        0        1   \n",
       "1                0.5             0.0    0.5  ...        1        0        0   \n",
       "2                0.5             0.0    0.5  ...        0        1        0   \n",
       "3                0.0             0.0    0.0  ...        0        1        0   \n",
       "4                0.0             0.0    0.0  ...        0        1        0   \n",
       "\n",
       "   snake_4  snake_5  bridgecamp_1  bridgecamp_2  bridgecamp_3  bridgecamp_4  \\\n",
       "0        0        0             0             1             0             0   \n",
       "1        0        0             0             0             1             0   \n",
       "2        0        0             0             0             0             1   \n",
       "3        0        0             0             0             0             1   \n",
       "4        0        0             1             0             0             0   \n",
       "\n",
       "   bridgecamp_5  \n",
       "0             0  \n",
       "1             0  \n",
       "2             0  \n",
       "3             0  \n",
       "4             0  \n",
       "\n",
       "[5 rows x 89 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Index(['NameOrID', 'English', 'Hindi', 'Georgopol', 'Novo', 'Military Base',\n",
      "       'Pochinki', 'School/Apartments', 'Georgopol City', 'Mylta', 'Erangel',\n",
      "       'Rozhok', 'Severny', 'Vikendi', 'Others', 'No preference',\n",
      "       'no preference', 'Mylta Power', 'Prison', 'No mic', 'Paradise Resort',\n",
      "       'ha thin', 'san martin', 'el pozo', 'goroka', 'dobro mesto', 'volnova',\n",
      "       'coal mine', 'cement factory', 'Yasnaya', 'power grid', 'villa', 'port',\n",
      "       'others', 'Boot Camp(sanhok)', 'pecado', 'hacienda del patron',\n",
      "       'Castle(vikendi)', 'cosmodrome', 'Miramar', 'Sanhok', 'Korean',\n",
      "       'los leones', 'Quarry', 'power grid(miramar)', 'zabaya', 'vihar',\n",
      "       'Factory', 'Mansion', 'la bendita', 'krichas', 'movatra', 'dino park',\n",
      "       'Chinese', 'Urdu', 'RankPusher_Casual pusher', 'RankPusher_No',\n",
      "       'RankPusher_Yes', 'GameplayStyle_Always rushing',\n",
      "       'GameplayStyle_Moderate rush', 'GameplayStyle_Mostly rushing',\n",
      "       'GameplayStyle_Safe with little risk', 'GameplayStyle_Very Safe',\n",
      "       'PlayDays_Everyday', 'PlayDays_Most days', 'PlayDays_Weekdays',\n",
      "       'PlayDays_Weekends', 'Driver_No', 'Driver_No prefernce', 'Driver_Yes',\n",
      "       'RateSkills_2', 'RateSkills_3', 'RateSkills_4', 'RateSkills_5',\n",
      "       'camp_1', 'camp_2', 'camp_3', 'camp_4', 'camp_5', 'snake_1', 'snake_2',\n",
      "       'snake_3', 'snake_4', 'snake_5', 'bridgecamp_1', 'bridgecamp_2',\n",
      "       'bridgecamp_3', 'bridgecamp_4', 'bridgecamp_5'],\n",
      "      dtype='object')\n"
     ]
    }
   ],
   "source": [
    "print(df.columns)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Setting index of the dataset to NameOrID because they should be unique entries. "
   ]
  },
  {
   "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>NameOrID</th>\n",
       "      <th>English</th>\n",
       "      <th>Hindi</th>\n",
       "      <th>Georgopol</th>\n",
       "      <th>Novo</th>\n",
       "      <th>Military Base</th>\n",
       "      <th>Pochinki</th>\n",
       "      <th>School/Apartments</th>\n",
       "      <th>Georgopol City</th>\n",
       "      <th>Mylta</th>\n",
       "      <th>...</th>\n",
       "      <th>snake_1</th>\n",
       "      <th>snake_2</th>\n",
       "      <th>snake_3</th>\n",
       "      <th>snake_4</th>\n",
       "      <th>snake_5</th>\n",
       "      <th>bridgecamp_1</th>\n",
       "      <th>bridgecamp_2</th>\n",
       "      <th>bridgecamp_3</th>\n",
       "      <th>bridgecamp_4</th>\n",
       "      <th>bridgecamp_5</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NameOrID</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>MiuSan×</th>\n",
       "      <td>MiuSan×</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>...</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>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AZĪlĪSPYDER</th>\n",
       "      <td>AZĪlĪSPYDER</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>...</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",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AZĪIĪReApEr</th>\n",
       "      <td>AZĪIĪReApEr</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.5</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>Sonic</th>\n",
       "      <td>Sonic</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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>GodEater</th>\n",
       "      <td>GodEater</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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>1</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>5 rows × 89 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                NameOrID  English  Hindi  Georgopol  Novo  Military Base  \\\n",
       "NameOrID                                                                   \n",
       "MiuSan×          MiuSan×      2.0    2.0        0.5   0.5            0.5   \n",
       "AZĪlĪSPYDER  AZĪlĪSPYDER      2.0    2.0        0.5   0.5            0.5   \n",
       "AZĪIĪReApEr  AZĪIĪReApEr      2.0    2.0        0.0   0.0            0.5   \n",
       "Sonic              Sonic      2.0    0.0        0.5   0.5            0.5   \n",
       "GodEater        GodEater      2.0    0.0        0.0   0.0            0.0   \n",
       "\n",
       "             Pochinki  School/Apartments  Georgopol City  Mylta  ...  snake_1  \\\n",
       "NameOrID                                                         ...            \n",
       "MiuSan×           0.5                0.5             0.5    0.5  ...        0   \n",
       "AZĪlĪSPYDER       0.5                0.5             0.0    0.5  ...        1   \n",
       "AZĪIĪReApEr       0.5                0.5             0.0    0.5  ...        0   \n",
       "Sonic             0.0                0.0             0.0    0.0  ...        0   \n",
       "GodEater          0.0                0.0             0.0    0.0  ...        0   \n",
       "\n",
       "             snake_2  snake_3  snake_4  snake_5  bridgecamp_1  bridgecamp_2  \\\n",
       "NameOrID                                                                      \n",
       "MiuSan×            0        1        0        0             0             1   \n",
       "AZĪlĪSPYDER        0        0        0        0             0             0   \n",
       "AZĪIĪReApEr        1        0        0        0             0             0   \n",
       "Sonic              1        0        0        0             0             0   \n",
       "GodEater           1        0        0        0             1             0   \n",
       "\n",
       "             bridgecamp_3  bridgecamp_4  bridgecamp_5  \n",
       "NameOrID                                               \n",
       "MiuSan×                 0             0             0  \n",
       "AZĪlĪSPYDER             1             0             0  \n",
       "AZĪIĪReApEr             0             1             0  \n",
       "Sonic                   0             1             0  \n",
       "GodEater                0             0             0  \n",
       "\n",
       "[5 rows x 89 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df=df.set_index(df['NameOrID'])\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "View all columns along with attributes to confirm that all required entries are numeric."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Index: 54 entries, MiuSan× to 5165613933\n",
      "Data columns (total 89 columns):\n",
      " #   Column                               Non-Null Count  Dtype  \n",
      "---  ------                               --------------  -----  \n",
      " 0   NameOrID                             54 non-null     object \n",
      " 1   English                              54 non-null     float64\n",
      " 2   Hindi                                54 non-null     float64\n",
      " 3   Georgopol                            54 non-null     float64\n",
      " 4   Novo                                 54 non-null     float64\n",
      " 5   Military Base                        54 non-null     float64\n",
      " 6   Pochinki                             54 non-null     float64\n",
      " 7   School/Apartments                    54 non-null     float64\n",
      " 8   Georgopol City                       54 non-null     float64\n",
      " 9   Mylta                                54 non-null     float64\n",
      " 10  Erangel                              54 non-null     float64\n",
      " 11  Rozhok                               54 non-null     float64\n",
      " 12  Severny                              54 non-null     float64\n",
      " 13  Vikendi                              54 non-null     float64\n",
      " 14  Others                               54 non-null     float64\n",
      " 15  No preference                        54 non-null     float64\n",
      " 16  no preference                        54 non-null     float64\n",
      " 17  Mylta Power                          54 non-null     float64\n",
      " 18  Prison                               54 non-null     float64\n",
      " 19  No mic                               54 non-null     float64\n",
      " 20  Paradise Resort                      54 non-null     float64\n",
      " 21  ha thin                              54 non-null     float64\n",
      " 22  san martin                           54 non-null     float64\n",
      " 23  el pozo                              54 non-null     float64\n",
      " 24  goroka                               54 non-null     float64\n",
      " 25  dobro mesto                          54 non-null     float64\n",
      " 26  volnova                              54 non-null     float64\n",
      " 27  coal mine                            54 non-null     float64\n",
      " 28  cement factory                       54 non-null     float64\n",
      " 29  Yasnaya                              54 non-null     float64\n",
      " 30  power grid                           54 non-null     float64\n",
      " 31  villa                                54 non-null     float64\n",
      " 32  port                                 54 non-null     float64\n",
      " 33  others                               54 non-null     float64\n",
      " 34  Boot Camp(sanhok)                    54 non-null     float64\n",
      " 35  pecado                               54 non-null     float64\n",
      " 36  hacienda del patron                  54 non-null     float64\n",
      " 37  Castle(vikendi)                      54 non-null     float64\n",
      " 38  cosmodrome                           54 non-null     float64\n",
      " 39  Miramar                              54 non-null     float64\n",
      " 40  Sanhok                               54 non-null     float64\n",
      " 41  Korean                               54 non-null     float64\n",
      " 42  los leones                           54 non-null     float64\n",
      " 43  Quarry                               54 non-null     float64\n",
      " 44  power grid(miramar)                  54 non-null     float64\n",
      " 45  zabaya                               54 non-null     float64\n",
      " 46  vihar                                54 non-null     float64\n",
      " 47  Factory                              54 non-null     float64\n",
      " 48  Mansion                              54 non-null     float64\n",
      " 49  la bendita                           54 non-null     float64\n",
      " 50  krichas                              54 non-null     float64\n",
      " 51  movatra                              54 non-null     float64\n",
      " 52  dino park                            54 non-null     float64\n",
      " 53  Chinese                              54 non-null     float64\n",
      " 54  Urdu                                 54 non-null     float64\n",
      " 55  RankPusher_Casual pusher             54 non-null     uint8  \n",
      " 56  RankPusher_No                        54 non-null     uint8  \n",
      " 57  RankPusher_Yes                       54 non-null     uint8  \n",
      " 58  GameplayStyle_Always rushing         54 non-null     uint8  \n",
      " 59  GameplayStyle_Moderate rush          54 non-null     uint8  \n",
      " 60  GameplayStyle_Mostly rushing         54 non-null     uint8  \n",
      " 61  GameplayStyle_Safe with little risk  54 non-null     uint8  \n",
      " 62  GameplayStyle_Very Safe              54 non-null     uint8  \n",
      " 63  PlayDays_Everyday                    54 non-null     uint8  \n",
      " 64  PlayDays_Most days                   54 non-null     uint8  \n",
      " 65  PlayDays_Weekdays                    54 non-null     uint8  \n",
      " 66  PlayDays_Weekends                    54 non-null     uint8  \n",
      " 67  Driver_No                            54 non-null     uint8  \n",
      " 68  Driver_No prefernce                  54 non-null     uint8  \n",
      " 69  Driver_Yes                           54 non-null     uint8  \n",
      " 70  RateSkills_2                         54 non-null     uint8  \n",
      " 71  RateSkills_3                         54 non-null     uint8  \n",
      " 72  RateSkills_4                         54 non-null     uint8  \n",
      " 73  RateSkills_5                         54 non-null     uint8  \n",
      " 74  camp_1                               54 non-null     uint8  \n",
      " 75  camp_2                               54 non-null     uint8  \n",
      " 76  camp_3                               54 non-null     uint8  \n",
      " 77  camp_4                               54 non-null     uint8  \n",
      " 78  camp_5                               54 non-null     uint8  \n",
      " 79  snake_1                              54 non-null     uint8  \n",
      " 80  snake_2                              54 non-null     uint8  \n",
      " 81  snake_3                              54 non-null     uint8  \n",
      " 82  snake_4                              54 non-null     uint8  \n",
      " 83  snake_5                              54 non-null     uint8  \n",
      " 84  bridgecamp_1                         54 non-null     uint8  \n",
      " 85  bridgecamp_2                         54 non-null     uint8  \n",
      " 86  bridgecamp_3                         54 non-null     uint8  \n",
      " 87  bridgecamp_4                         54 non-null     uint8  \n",
      " 88  bridgecamp_5                         54 non-null     uint8  \n",
      "dtypes: float64(54), object(1), uint8(34)\n",
      "memory usage: 25.4+ KB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<h2>Recommendation System Algorithm</h2><br>\n",
    "Preprocessing and encoding is complete, we proceed with the methodology which is based on the concept of <b>Context Based Recommendation System.</b><br>\n",
    "This technique attempts to figure out what a user's aspects of gameplay(attributes) is, and then recommends players that are most similar to those aspects"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Select a person from the dataset on whom you want a recomendation made, you can also enter any new data entry, just make sure it's preprocessed like our df dataframe."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "person=df.loc[['AZĪIĪReApEr']]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "We will drop the nameOrID attribute from both the person as well as the df dataframe for computation. Add a column sum which is essentially sum o weightage attributes of the person for which recommendation is to be made,"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "person.drop('NameOrID', axis=1,inplace=True)\n",
    "df.drop('NameOrID',axis=1,inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "English           2.0\n",
       "Hindi             2.0\n",
       "Georgopol         0.0\n",
       "Novo              0.0\n",
       "Military Base     0.5\n",
       "                 ... \n",
       "bridgecamp_2      0.0\n",
       "bridgecamp_3      0.0\n",
       "bridgecamp_4      1.0\n",
       "bridgecamp_5      0.0\n",
       "sum              16.0\n",
       "Name: AZĪIĪReApEr, Length: 89, dtype: float64"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "person['sum']=person.sum(axis=1)\n",
    "a=person.iloc[0,88]\n",
    "person=person.iloc[0,0:]\n",
    "person"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Make a copy of original dataframe. This will help in just changing the index of person and making recommendation again and again easy. Add a column sum to it, which is sum of all attributes of each row"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_copy=df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Now calculate the product of a column of the person with each entry of dataset.<h4>The Concept</h4><br>If attributes are similar, multiplication occurs and a number greater than 0 is the product. If the attribute do not match, the product of them is 0. We do this for all attributes and  then compute sum of all. The more the value of sum, more was the similarity "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_copy=((person*df_copy).sum(axis=1))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Making Recommendation here. We take[1:10] because the 0th index will always be the person himself<br>\n",
    "Note: If you are using a person who is not in the dataset, change [1:10] with [0:10]."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "NameOrID\n",
       "MarcoPolo                  15.75\n",
       "Sin6Rize                   15.50\n",
       "AZĪIĪCYPHER / 510906864    15.00\n",
       "SUNKEE๛HelBoy              14.50\n",
       "chiyachu                   14.00\n",
       "m24969                     13.75\n",
       "69IVEDANT                  13.50\n",
       "AZ | scarley               13.50\n",
       "5650903128                 13.25\n",
       "dtype: float64"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_copy.sort_values(ascending=False)[1:10]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}