saw.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Loading Module and Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "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>type</th>\n",
       "      <th>name</th>\n",
       "      <th>travel_advisor_ranking</th>\n",
       "      <th>rating</th>\n",
       "      <th>total_review</th>\n",
       "      <th>total_awards</th>\n",
       "      <th>price_level</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>RESTAURANT</td>\n",
       "      <td>Kepitu Restaurant</td>\n",
       "      <td>53</td>\n",
       "      <td>5.0</td>\n",
       "      <td>697</td>\n",
       "      <td>6</td>\n",
       "      <td>2.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>RESTAURANT</td>\n",
       "      <td>ShamanaMama restaurant</td>\n",
       "      <td>55</td>\n",
       "      <td>5.0</td>\n",
       "      <td>136</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>RESTAURANT</td>\n",
       "      <td>Tarabelle Donuts, Coffee &amp; Eats</td>\n",
       "      <td>54</td>\n",
       "      <td>5.0</td>\n",
       "      <td>142</td>\n",
       "      <td>3</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>RESTAURANT</td>\n",
       "      <td>Taco Fiesta</td>\n",
       "      <td>51</td>\n",
       "      <td>5.0</td>\n",
       "      <td>161</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>RESTAURANT</td>\n",
       "      <td>Raja Bali Restaurant Nusadua</td>\n",
       "      <td>60</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1150</td>\n",
       "      <td>2</td>\n",
       "      <td>2.5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         type                             name  travel_advisor_ranking  \\\n",
       "0  RESTAURANT                Kepitu Restaurant                      53   \n",
       "1  RESTAURANT           ShamanaMama restaurant                      55   \n",
       "2  RESTAURANT  Tarabelle Donuts, Coffee & Eats                      54   \n",
       "3  RESTAURANT                      Taco Fiesta                      51   \n",
       "4  RESTAURANT     Raja Bali Restaurant Nusadua                      60   \n",
       "\n",
       "   rating  total_review  total_awards  price_level  \n",
       "0     5.0           697             6          2.5  \n",
       "1     5.0           136             1          1.0  \n",
       "2     5.0           142             3          1.0  \n",
       "3     5.0           161             1          1.0  \n",
       "4     5.0          1150             2          2.5  "
      ]
     },
     "execution_count": 72,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "## Loading Module\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "\n",
    "df = pd.read_json('./hotel_review_dataset.json')\n",
    "df.head(5)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Normalization"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "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>type</th>\n",
       "      <th>name</th>\n",
       "      <th>travel_advisor_ranking</th>\n",
       "      <th>rating</th>\n",
       "      <th>total_review</th>\n",
       "      <th>total_awards</th>\n",
       "      <th>price_level</th>\n",
       "      <th>n_travel_advisor_ranking</th>\n",
       "      <th>n_rating</th>\n",
       "      <th>n_total_review</th>\n",
       "      <th>n_total_awards</th>\n",
       "      <th>n_price_level</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>RESTAURANT</td>\n",
       "      <td>Kepitu Restaurant</td>\n",
       "      <td>53</td>\n",
       "      <td>5.0</td>\n",
       "      <td>697</td>\n",
       "      <td>6</td>\n",
       "      <td>2.5</td>\n",
       "      <td>0.018868</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.051337</td>\n",
       "      <td>0.545455</td>\n",
       "      <td>0.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>RESTAURANT</td>\n",
       "      <td>ShamanaMama restaurant</td>\n",
       "      <td>55</td>\n",
       "      <td>5.0</td>\n",
       "      <td>136</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.018182</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.010017</td>\n",
       "      <td>0.090909</td>\n",
       "      <td>0.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>RESTAURANT</td>\n",
       "      <td>Tarabelle Donuts, Coffee &amp; Eats</td>\n",
       "      <td>54</td>\n",
       "      <td>5.0</td>\n",
       "      <td>142</td>\n",
       "      <td>3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.018519</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.010459</td>\n",
       "      <td>0.272727</td>\n",
       "      <td>0.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>RESTAURANT</td>\n",
       "      <td>Taco Fiesta</td>\n",
       "      <td>51</td>\n",
       "      <td>5.0</td>\n",
       "      <td>161</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.019608</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.011858</td>\n",
       "      <td>0.090909</td>\n",
       "      <td>0.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>RESTAURANT</td>\n",
       "      <td>Raja Bali Restaurant Nusadua</td>\n",
       "      <td>60</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1150</td>\n",
       "      <td>2</td>\n",
       "      <td>2.5</td>\n",
       "      <td>0.016667</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.084702</td>\n",
       "      <td>0.181818</td>\n",
       "      <td>0.04</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>95</th>\n",
       "      <td>RESTAURANT</td>\n",
       "      <td>Chops! Meat &amp; Gin</td>\n",
       "      <td>308</td>\n",
       "      <td>5.0</td>\n",
       "      <td>145</td>\n",
       "      <td>1</td>\n",
       "      <td>2.5</td>\n",
       "      <td>0.003247</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.010680</td>\n",
       "      <td>0.090909</td>\n",
       "      <td>0.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>RESTAURANT</td>\n",
       "      <td>The Coffee Club - Legian</td>\n",
       "      <td>227</td>\n",
       "      <td>4.5</td>\n",
       "      <td>295</td>\n",
       "      <td>0</td>\n",
       "      <td>2.5</td>\n",
       "      <td>0.004405</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.021728</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>RESTAURANT</td>\n",
       "      <td>Warung Nia</td>\n",
       "      <td>224</td>\n",
       "      <td>4.5</td>\n",
       "      <td>2377</td>\n",
       "      <td>4</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.004464</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.175075</td>\n",
       "      <td>0.363636</td>\n",
       "      <td>0.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>RESTAURANT</td>\n",
       "      <td>Mana Uluwatu</td>\n",
       "      <td>226</td>\n",
       "      <td>5.0</td>\n",
       "      <td>471</td>\n",
       "      <td>1</td>\n",
       "      <td>2.5</td>\n",
       "      <td>0.004425</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.034691</td>\n",
       "      <td>0.090909</td>\n",
       "      <td>0.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>RESTAURANT</td>\n",
       "      <td>Warung Chef Bagus</td>\n",
       "      <td>222</td>\n",
       "      <td>4.5</td>\n",
       "      <td>976</td>\n",
       "      <td>2</td>\n",
       "      <td>2.5</td>\n",
       "      <td>0.004505</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.071886</td>\n",
       "      <td>0.181818</td>\n",
       "      <td>0.04</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>100 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          type                             name  travel_advisor_ranking  \\\n",
       "0   RESTAURANT                Kepitu Restaurant                      53   \n",
       "1   RESTAURANT           ShamanaMama restaurant                      55   \n",
       "2   RESTAURANT  Tarabelle Donuts, Coffee & Eats                      54   \n",
       "3   RESTAURANT                      Taco Fiesta                      51   \n",
       "4   RESTAURANT     Raja Bali Restaurant Nusadua                      60   \n",
       "..         ...                              ...                     ...   \n",
       "95  RESTAURANT                Chops! Meat & Gin                     308   \n",
       "96  RESTAURANT         The Coffee Club - Legian                     227   \n",
       "97  RESTAURANT                       Warung Nia                     224   \n",
       "98  RESTAURANT                     Mana Uluwatu                     226   \n",
       "99  RESTAURANT                Warung Chef Bagus                     222   \n",
       "\n",
       "    rating  total_review  total_awards  price_level  n_travel_advisor_ranking  \\\n",
       "0      5.0           697             6          2.5                  0.018868   \n",
       "1      5.0           136             1          1.0                  0.018182   \n",
       "2      5.0           142             3          1.0                  0.018519   \n",
       "3      5.0           161             1          1.0                  0.019608   \n",
       "4      5.0          1150             2          2.5                  0.016667   \n",
       "..     ...           ...           ...          ...                       ...   \n",
       "95     5.0           145             1          2.5                  0.003247   \n",
       "96     4.5           295             0          2.5                  0.004405   \n",
       "97     4.5          2377             4          1.0                  0.004464   \n",
       "98     5.0           471             1          2.5                  0.004425   \n",
       "99     4.5           976             2          2.5                  0.004505   \n",
       "\n",
       "    n_rating  n_total_review  n_total_awards  n_price_level  \n",
       "0        1.0        0.051337        0.545455           0.04  \n",
       "1        1.0        0.010017        0.090909           0.10  \n",
       "2        1.0        0.010459        0.272727           0.10  \n",
       "3        1.0        0.011858        0.090909           0.10  \n",
       "4        1.0        0.084702        0.181818           0.04  \n",
       "..       ...             ...             ...            ...  \n",
       "95       1.0        0.010680        0.090909           0.04  \n",
       "96       0.9        0.021728        0.000000           0.04  \n",
       "97       0.9        0.175075        0.363636           0.10  \n",
       "98       1.0        0.034691        0.090909           0.04  \n",
       "99       0.9        0.071886        0.181818           0.04  \n",
       "\n",
       "[100 rows x 12 columns]"
      ]
     },
     "execution_count": 73,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "## Travel Advisor Ranking [Cost]\n",
    "df['n_travel_advisor_ranking'] = df['travel_advisor_ranking'].apply(lambda x:np.min(df['travel_advisor_ranking'])/x )\n",
    "## Rating [Benefit]\n",
    "df['n_rating'] = df['rating'].apply(lambda x:x / np.max(df['rating']))\n",
    "## Total Review [Benefit]\n",
    "df['n_total_review'] = df['total_review'].apply(lambda x:x / np.max(df['total_review']))\n",
    "## Total Awards [Benefit]\n",
    "df['n_total_awards'] = df['total_awards'].apply(lambda x:x / np.max(df['total_awards']))\n",
    "## Price Level [Cost]\n",
    "df['n_price_level'] = df['price_level'].apply(lambda x:np.min(df['price_level']) / x)\n",
    "df.head(100)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## SAW Calculation\n",
    "Weight distribution\n",
    "\n",
    "| travel_advisor_ranking `Cost`| rating `Benefit` | total_review `Benefit` | total_awards `Benefit` | price_level `Cost` |\n",
    "|---|---|---|---|---|\n",
    "| 15 % | 25 % | 15 % | 20 % | 25 % |  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "metadata": {},
   "outputs": [],
   "source": [
    "## Parsing Weight Distribution to Code\n",
    "weight = {}\n",
    "weight['travel_advisor_ranking'] = 0.15\n",
    "weight['rating'] = 0.25\n",
    "weight['total_review'] = 0.15\n",
    "weight['total_awards'] = 0.20\n",
    "weight['price_level'] = 0.25"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "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>type</th>\n",
       "      <th>name</th>\n",
       "      <th>travel_advisor_ranking</th>\n",
       "      <th>rating</th>\n",
       "      <th>total_review</th>\n",
       "      <th>total_awards</th>\n",
       "      <th>price_level</th>\n",
       "      <th>n_travel_advisor_ranking</th>\n",
       "      <th>n_rating</th>\n",
       "      <th>n_total_review</th>\n",
       "      <th>n_total_awards</th>\n",
       "      <th>n_price_level</th>\n",
       "      <th>saw_travel_advisor_ranking</th>\n",
       "      <th>saw_rating</th>\n",
       "      <th>saw_total_review</th>\n",
       "      <th>saw_total_awards</th>\n",
       "      <th>saw_price_level</th>\n",
       "      <th>saw</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>RESTAURANT</td>\n",
       "      <td>Kepitu Restaurant</td>\n",
       "      <td>53</td>\n",
       "      <td>5.0</td>\n",
       "      <td>697</td>\n",
       "      <td>6</td>\n",
       "      <td>2.5</td>\n",
       "      <td>0.018868</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.051337</td>\n",
       "      <td>0.545455</td>\n",
       "      <td>0.04</td>\n",
       "      <td>0.002830</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.007701</td>\n",
       "      <td>0.109091</td>\n",
       "      <td>0.010</td>\n",
       "      <td>0.379622</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>RESTAURANT</td>\n",
       "      <td>ShamanaMama restaurant</td>\n",
       "      <td>55</td>\n",
       "      <td>5.0</td>\n",
       "      <td>136</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.018182</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.010017</td>\n",
       "      <td>0.090909</td>\n",
       "      <td>0.10</td>\n",
       "      <td>0.002727</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.001503</td>\n",
       "      <td>0.018182</td>\n",
       "      <td>0.025</td>\n",
       "      <td>0.297412</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>RESTAURANT</td>\n",
       "      <td>Tarabelle Donuts, Coffee &amp; Eats</td>\n",
       "      <td>54</td>\n",
       "      <td>5.0</td>\n",
       "      <td>142</td>\n",
       "      <td>3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.018519</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.010459</td>\n",
       "      <td>0.272727</td>\n",
       "      <td>0.10</td>\n",
       "      <td>0.002778</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.001569</td>\n",
       "      <td>0.054545</td>\n",
       "      <td>0.025</td>\n",
       "      <td>0.333892</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>RESTAURANT</td>\n",
       "      <td>Taco Fiesta</td>\n",
       "      <td>51</td>\n",
       "      <td>5.0</td>\n",
       "      <td>161</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.019608</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.011858</td>\n",
       "      <td>0.090909</td>\n",
       "      <td>0.10</td>\n",
       "      <td>0.002941</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.001779</td>\n",
       "      <td>0.018182</td>\n",
       "      <td>0.025</td>\n",
       "      <td>0.297902</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>RESTAURANT</td>\n",
       "      <td>Raja Bali Restaurant Nusadua</td>\n",
       "      <td>60</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1150</td>\n",
       "      <td>2</td>\n",
       "      <td>2.5</td>\n",
       "      <td>0.016667</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.084702</td>\n",
       "      <td>0.181818</td>\n",
       "      <td>0.04</td>\n",
       "      <td>0.002500</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.012705</td>\n",
       "      <td>0.036364</td>\n",
       "      <td>0.010</td>\n",
       "      <td>0.311569</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         type                             name  travel_advisor_ranking  \\\n",
       "0  RESTAURANT                Kepitu Restaurant                      53   \n",
       "1  RESTAURANT           ShamanaMama restaurant                      55   \n",
       "2  RESTAURANT  Tarabelle Donuts, Coffee & Eats                      54   \n",
       "3  RESTAURANT                      Taco Fiesta                      51   \n",
       "4  RESTAURANT     Raja Bali Restaurant Nusadua                      60   \n",
       "\n",
       "   rating  total_review  total_awards  price_level  n_travel_advisor_ranking  \\\n",
       "0     5.0           697             6          2.5                  0.018868   \n",
       "1     5.0           136             1          1.0                  0.018182   \n",
       "2     5.0           142             3          1.0                  0.018519   \n",
       "3     5.0           161             1          1.0                  0.019608   \n",
       "4     5.0          1150             2          2.5                  0.016667   \n",
       "\n",
       "   n_rating  n_total_review  n_total_awards  n_price_level  \\\n",
       "0       1.0        0.051337        0.545455           0.04   \n",
       "1       1.0        0.010017        0.090909           0.10   \n",
       "2       1.0        0.010459        0.272727           0.10   \n",
       "3       1.0        0.011858        0.090909           0.10   \n",
       "4       1.0        0.084702        0.181818           0.04   \n",
       "\n",
       "   saw_travel_advisor_ranking  saw_rating  saw_total_review  saw_total_awards  \\\n",
       "0                    0.002830        0.25          0.007701          0.109091   \n",
       "1                    0.002727        0.25          0.001503          0.018182   \n",
       "2                    0.002778        0.25          0.001569          0.054545   \n",
       "3                    0.002941        0.25          0.001779          0.018182   \n",
       "4                    0.002500        0.25          0.012705          0.036364   \n",
       "\n",
       "   saw_price_level       saw  \n",
       "0            0.010  0.379622  \n",
       "1            0.025  0.297412  \n",
       "2            0.025  0.333892  \n",
       "3            0.025  0.297902  \n",
       "4            0.010  0.311569  "
      ]
     },
     "execution_count": 75,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['saw_travel_advisor_ranking'] = df['n_travel_advisor_ranking'].apply(lambda x : x * weight['travel_advisor_ranking'])\n",
    "df['saw_rating'] = df['n_rating'].apply(lambda x : x * weight['rating'])\n",
    "df['saw_total_review'] = df['n_total_review'].apply(lambda x : x * weight['total_review'])\n",
    "df['saw_total_awards'] = df['n_total_awards'].apply(lambda x : x * weight['total_awards'])\n",
    "df['saw_price_level'] = df['n_price_level'].apply(lambda x : x * weight['price_level'])\n",
    "df['saw'] = df['saw_travel_advisor_ranking'] + df['saw_rating'] + df['saw_total_review'] + df['saw_total_awards'] +df['saw_price_level']\n",
    "df.head(5)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Data Representing"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "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>name</th>\n",
       "      <th>travel_advisor_ranking</th>\n",
       "      <th>rating</th>\n",
       "      <th>total_review</th>\n",
       "      <th>total_awards</th>\n",
       "      <th>price_level</th>\n",
       "      <th>saw</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>701</th>\n",
       "      <td>KU DE TA</td>\n",
       "      <td>945</td>\n",
       "      <td>4.0</td>\n",
       "      <td>10499</td>\n",
       "      <td>11</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.522403</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Velvet Ubud</td>\n",
       "      <td>6</td>\n",
       "      <td>4.5</td>\n",
       "      <td>111</td>\n",
       "      <td>1</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.519408</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>533</th>\n",
       "      <td>Grazing on the Green</td>\n",
       "      <td>31</td>\n",
       "      <td>5.0</td>\n",
       "      <td>153</td>\n",
       "      <td>0</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.506529</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>662</th>\n",
       "      <td>La Lucciola</td>\n",
       "      <td>542</td>\n",
       "      <td>4.5</td>\n",
       "      <td>7952</td>\n",
       "      <td>10</td>\n",
       "      <td>2.5</td>\n",
       "      <td>0.504949</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>852</th>\n",
       "      <td>Melali Ubud Restaurant</td>\n",
       "      <td>811</td>\n",
       "      <td>5.0</td>\n",
       "      <td>78</td>\n",
       "      <td>0</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.501047</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>963</th>\n",
       "      <td>Bridges Bali</td>\n",
       "      <td>343</td>\n",
       "      <td>4.5</td>\n",
       "      <td>6203</td>\n",
       "      <td>11</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.500219</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>396</th>\n",
       "      <td>Taco Casa</td>\n",
       "      <td>461</td>\n",
       "      <td>4.5</td>\n",
       "      <td>3442</td>\n",
       "      <td>11</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.488353</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>841</th>\n",
       "      <td>Ultimo Italian Restaurant</td>\n",
       "      <td>892</td>\n",
       "      <td>4.5</td>\n",
       "      <td>6397</td>\n",
       "      <td>10</td>\n",
       "      <td>2.5</td>\n",
       "      <td>0.487661</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>696</th>\n",
       "      <td>Massimo - Italian Restaurant</td>\n",
       "      <td>703</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4464</td>\n",
       "      <td>11</td>\n",
       "      <td>2.5</td>\n",
       "      <td>0.484532</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>891</th>\n",
       "      <td>CHANDI</td>\n",
       "      <td>500</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4467</td>\n",
       "      <td>10</td>\n",
       "      <td>2.5</td>\n",
       "      <td>0.466470</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                             name  travel_advisor_ranking  rating  \\\n",
       "701                      KU DE TA                     945     4.0   \n",
       "24                    Velvet Ubud                       6     4.5   \n",
       "533          Grazing on the Green                      31     5.0   \n",
       "662                   La Lucciola                     542     4.5   \n",
       "852        Melali Ubud Restaurant                     811     5.0   \n",
       "963                  Bridges Bali                     343     4.5   \n",
       "396                     Taco Casa                     461     4.5   \n",
       "841     Ultimo Italian Restaurant                     892     4.5   \n",
       "696  Massimo - Italian Restaurant                     703     4.5   \n",
       "891                        CHANDI                     500     4.5   \n",
       "\n",
       "     total_review  total_awards  price_level       saw  \n",
       "701         10499            11          4.0  0.522403  \n",
       "24            111             1          0.1  0.519408  \n",
       "533           153             0          0.1  0.506529  \n",
       "662          7952            10          2.5  0.504949  \n",
       "852            78             0          0.1  0.501047  \n",
       "963          6203            11          4.0  0.500219  \n",
       "396          3442            11          1.0  0.488353  \n",
       "841          6397            10          2.5  0.487661  \n",
       "696          4464            11          2.5  0.484532  \n",
       "891          4467            10          2.5  0.466470  "
      ]
     },
     "execution_count": 76,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[['name','travel_advisor_ranking','rating','total_review','total_awards','price_level','saw']].sort_values(by=['saw'],ascending=False).head(10)"
   ]
  }
 ],
 "metadata": {
  "interpreter": {
   "hash": "89228e29b4d6213ee2b498cbaeb6a7887ce2a930e84453dbbf8c53e89bb5016f"
  },
  "kernelspec": {
   "display_name": "Python 3.7.0 64-bit ('venv': venv)",
   "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.0"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}