code.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "b469c36b",
   "metadata": {
    "papermill": {
     "duration": 0.021656,
     "end_time": "2023-07-22T11:56:09.361438",
     "exception": false,
     "start_time": "2023-07-22T11:56:09.339782",
     "status": "completed"
    },
    "tags": []
   },
   "source": [
    "# **Import**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "dbd79ac8",
   "metadata": {
    "_cell_guid": "b1076dfc-b9ad-4769-8c92-a6c4dae69d19",
    "_uuid": "8f2839f25d086af736a60e9eeb907d3b93b6e0e5",
    "execution": {
     "iopub.execute_input": "2023-07-22T11:56:07.570330Z",
     "iopub.status.busy": "2023-07-22T11:56:07.569801Z",
     "iopub.status.idle": "2023-07-22T11:56:07.592303Z",
     "shell.execute_reply": "2023-07-22T11:56:07.591129Z"
    },
    "papermill": {
     "duration": 0.050213,
     "end_time": "2023-07-22T11:56:07.594664",
     "exception": false,
     "start_time": "2023-07-22T11:56:07.544451",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd \n",
    "\n",
    "import os\n",
    "for dirname, _, filenames in os.walk('/kaggle/input'):\n",
    "    for filename in filenames:\n",
    "        print(os.path.join(dirname, filename))\n",
    "\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b38d7f74",
   "metadata": {},
   "source": [
    "# **Data**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "612dbc5c",
   "metadata": {},
   "outputs": [],
   "source": [
    "destination_rating = pd.read_csv('data/tourism_rating.csv')\n",
    "destination = pd.read_csv('data/tourism_with_id.csv')\n",
    "user = pd.read_csv('data/user.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "3d1fd40f",
   "metadata": {},
   "outputs": [],
   "source": [
    "destination = destination[destination['City']=='Jakarta']\n",
    "destination = destination.drop(destination.columns[[11, 12]], axis=1)\n",
    "destination = destination.drop(destination.columns[[7]], axis=1)\n",
    "destination_rating = pd.merge(destination_rating, destination[['Place_Id']], how='right', on='Place_Id')\n",
    "user = pd.merge(user, destination_rating[['User_Id']], how='right', on='User_Id').drop_duplicates().sort_values('User_Id')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0f20aa82",
   "metadata": {
    "papermill": {
     "duration": 0.026494,
     "end_time": "2023-07-22T11:56:11.685304",
     "exception": false,
     "start_time": "2023-07-22T11:56:11.658810",
     "status": "completed"
    },
    "tags": []
   },
   "source": [
    "# ***Univariate Exploratory Data Analysis*** **(UEDA)**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "0861785b",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2023-07-22T11:56:11.796622Z",
     "iopub.status.busy": "2023-07-22T11:56:11.796189Z",
     "iopub.status.idle": "2023-07-22T11:56:11.827013Z",
     "shell.execute_reply": "2023-07-22T11:56:11.825711Z"
    },
    "papermill": {
     "duration": 0.061393,
     "end_time": "2023-07-22T11:56:11.829610",
     "exception": false,
     "start_time": "2023-07-22T11:56:11.768217",
     "status": "completed"
    },
    "tags": []
   },
   "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>Place_Id</th>\n",
       "      <th>Price</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Lat</th>\n",
       "      <th>Long</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>84.00</td>\n",
       "      <td>84.00</td>\n",
       "      <td>84.00</td>\n",
       "      <td>84.00</td>\n",
       "      <td>84.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>42.50</td>\n",
       "      <td>45130.95</td>\n",
       "      <td>4.49</td>\n",
       "      <td>-6.09</td>\n",
       "      <td>106.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>24.39</td>\n",
       "      <td>115657.34</td>\n",
       "      <td>0.20</td>\n",
       "      <td>0.80</td>\n",
       "      <td>0.32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>1.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>4.00</td>\n",
       "      <td>-6.38</td>\n",
       "      <td>103.93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>21.75</td>\n",
       "      <td>0.00</td>\n",
       "      <td>4.40</td>\n",
       "      <td>-6.21</td>\n",
       "      <td>106.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>42.50</td>\n",
       "      <td>4500.00</td>\n",
       "      <td>4.50</td>\n",
       "      <td>-6.18</td>\n",
       "      <td>106.82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>63.25</td>\n",
       "      <td>25000.00</td>\n",
       "      <td>4.60</td>\n",
       "      <td>-6.13</td>\n",
       "      <td>106.84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>84.00</td>\n",
       "      <td>900000.00</td>\n",
       "      <td>5.00</td>\n",
       "      <td>1.08</td>\n",
       "      <td>106.96</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Place_Id      Price Rating    Lat    Long\n",
       "count    84.00      84.00  84.00  84.00   84.00\n",
       "mean     42.50   45130.95   4.49  -6.09  106.78\n",
       "std      24.39  115657.34   0.20   0.80    0.32\n",
       "min       1.00       0.00   4.00  -6.38  103.93\n",
       "25%      21.75       0.00   4.40  -6.21  106.81\n",
       "50%      42.50    4500.00   4.50  -6.18  106.82\n",
       "75%      63.25   25000.00   4.60  -6.13  106.84\n",
       "max      84.00  900000.00   5.00   1.08  106.96"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "destination.describe().apply(lambda s: s.apply('{0:.2f}'.format))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "0e20124a",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2023-07-22T11:56:12.446035Z",
     "iopub.status.busy": "2023-07-22T11:56:12.445427Z",
     "iopub.status.idle": "2023-07-22T11:56:12.451539Z",
     "shell.execute_reply": "2023-07-22T11:56:12.450723Z"
    },
    "papermill": {
     "duration": 0.038166,
     "end_time": "2023-07-22T11:56:12.453985",
     "exception": false,
     "start_time": "2023-07-22T11:56:12.415819",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Terdapat 84 Tempat Wisata di DKI Jakarta\n",
      "Terdiri dari 6 Kategori Wisata yaitu\n",
      "Kategori Wisata  : ['Budaya' 'Taman Hiburan' 'Cagar Alam' 'Bahari' 'Pusat Perbelanjaan'\n",
      " 'Tempat Ibadah']\n"
     ]
    }
   ],
   "source": [
    "print(f\"Terdapat {destination['Place_Name'].nunique()} Tempat Wisata di DKI Jakarta\")\n",
    "print(f\"Terdiri dari {destination['Category'].nunique()} Kategori Wisata yaitu\")\n",
    "print('Kategori Wisata  :', destination['Category'].unique())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "3814f2fd",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2023-07-22T11:56:12.570988Z",
     "iopub.status.busy": "2023-07-22T11:56:12.569702Z",
     "iopub.status.idle": "2023-07-22T11:56:13.068418Z",
     "shell.execute_reply": "2023-07-22T11:56:13.067283Z"
    },
    "papermill": {
     "duration": 0.531131,
     "end_time": "2023-07-22T11:56:13.070991",
     "exception": false,
     "start_time": "2023-07-22T11:56:12.539860",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Jumlah Tempat Wisata dengan Kategori Budaya : 32\n",
      "Jumlah Tempat Wisata dengan Kategori Taman Hiburan : 27\n",
      "Jumlah Tempat Wisata dengan Kategori Pusat Perbelanjaan : 10\n",
      "Jumlah Tempat Wisata dengan Kategori Bahari : 8\n",
      "Jumlah Tempat Wisata dengan Kategori Cagar Alam : 4\n",
      "Jumlah Tempat Wisata dengan Kategori Tempat Ibadah : 3\n"
     ]
    }
   ],
   "source": [
    "columns_category_type = destination['Category'].unique().tolist()\n",
    "\n",
    "for label, count in destination['Category'].value_counts().items():\n",
    "    print(\"Jumlah Tempat Wisata dengan Kategori\", label, \":\", count)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "6d4c0013",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2023-07-22T11:56:13.192091Z",
     "iopub.status.busy": "2023-07-22T11:56:13.191698Z",
     "iopub.status.idle": "2023-07-22T11:56:13.215424Z",
     "shell.execute_reply": "2023-07-22T11:56:13.213980Z"
    },
    "papermill": {
     "duration": 0.057635,
     "end_time": "2023-07-22T11:56:13.218160",
     "exception": false,
     "start_time": "2023-07-22T11:56:13.160525",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>User_Id</th>\n",
       "      <th>Place_Id</th>\n",
       "      <th>Place_Ratings</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>1920.00</td>\n",
       "      <td>1920.00</td>\n",
       "      <td>1920.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>150.45</td>\n",
       "      <td>42.62</td>\n",
       "      <td>3.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>86.93</td>\n",
       "      <td>23.95</td>\n",
       "      <td>1.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>1.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>74.00</td>\n",
       "      <td>22.75</td>\n",
       "      <td>2.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>150.00</td>\n",
       "      <td>42.00</td>\n",
       "      <td>3.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>224.25</td>\n",
       "      <td>63.00</td>\n",
       "      <td>4.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>300.00</td>\n",
       "      <td>84.00</td>\n",
       "      <td>5.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       User_Id Place_Id Place_Ratings\n",
       "count  1920.00  1920.00       1920.00\n",
       "mean    150.45    42.62          3.01\n",
       "std      86.93    23.95          1.38\n",
       "min       1.00     1.00          1.00\n",
       "25%      74.00    22.75          2.00\n",
       "50%     150.00    42.00          3.00\n",
       "75%     224.25    63.00          4.00\n",
       "max     300.00    84.00          5.00"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "destination_rating.describe().apply(lambda s: s.apply('{0:.2f}'.format))"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "87534c2a",
   "metadata": {
    "papermill": {
     "duration": 0.029932,
     "end_time": "2023-07-22T11:56:13.538632",
     "exception": false,
     "start_time": "2023-07-22T11:56:13.508700",
     "status": "completed"
    },
    "tags": []
   },
   "source": [
    "# ***Multivariate Exploratory Data Analysis*** **(MEDA)**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "20d7a4ba",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2023-07-22T11:56:13.661710Z",
     "iopub.status.busy": "2023-07-22T11:56:13.661284Z",
     "iopub.status.idle": "2023-07-22T11:56:13.746507Z",
     "shell.execute_reply": "2023-07-22T11:56:13.745531Z"
    },
    "papermill": {
     "duration": 0.119184,
     "end_time": "2023-07-22T11:56:13.748910",
     "exception": false,
     "start_time": "2023-07-22T11:56:13.629726",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [],
   "source": [
    "Kategori_Biaya = destination.groupby('Category').agg({'Price': 'mean'})\n",
    "Kategori_Biaya = Kategori_Biaya.reset_index()\n",
    "Kategori_Biaya = Kategori_Biaya.rename(columns={'Price': 'Mean Price'})\n",
    "Kategori_Biaya = Kategori_Biaya.sort_values(by='Mean Price', ascending=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "229dd358",
   "metadata": {
    "papermill": {
     "duration": 0.034736,
     "end_time": "2023-07-22T11:56:15.682313",
     "exception": false,
     "start_time": "2023-07-22T11:56:15.647577",
     "status": "completed"
    },
    "tags": []
   },
   "source": [
    "# **Modelling - Content Based Filtering**"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6d42c48f",
   "metadata": {
    "papermill": {
     "duration": 0.033268,
     "end_time": "2023-07-22T11:56:15.819183",
     "exception": false,
     "start_time": "2023-07-22T11:56:15.785915",
     "status": "completed"
    },
    "tags": []
   },
   "source": [
    "TF-IDF"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "682f69c2",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2023-07-22T11:56:15.890435Z",
     "iopub.status.busy": "2023-07-22T11:56:15.889195Z",
     "iopub.status.idle": "2023-07-22T11:56:16.098248Z",
     "shell.execute_reply": "2023-07-22T11:56:16.097044Z"
    },
    "papermill": {
     "duration": 0.247463,
     "end_time": "2023-07-22T11:56:16.100694",
     "exception": false,
     "start_time": "2023-07-22T11:56:15.853231",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['alam', 'bahari', 'budaya', 'cagar', 'hiburan', 'ibadah',\n",
       "       'perbelanjaan', 'pusat', 'taman', 'tempat'], dtype=object)"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from sklearn.feature_extraction.text import TfidfVectorizer\n",
    "\n",
    "tf = TfidfVectorizer()\n",
    "tf.fit(destination['Category'])\n",
    "tf.get_feature_names_out()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "bc08be28",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2023-07-22T11:56:16.309217Z",
     "iopub.status.busy": "2023-07-22T11:56:16.308754Z",
     "iopub.status.idle": "2023-07-22T11:56:16.327613Z",
     "shell.execute_reply": "2023-07-22T11:56:16.326426Z"
    },
    "papermill": {
     "duration": 0.056995,
     "end_time": "2023-07-22T11:56:16.330114",
     "exception": false,
     "start_time": "2023-07-22T11:56:16.273119",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [],
   "source": [
    "tfidf_matrix = tf.fit_transform(destination['Category'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "6319a238",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2023-07-22T11:56:16.402040Z",
     "iopub.status.busy": "2023-07-22T11:56:16.401292Z",
     "iopub.status.idle": "2023-07-22T11:56:16.418982Z",
     "shell.execute_reply": "2023-07-22T11:56:16.417887Z"
    },
    "papermill": {
     "duration": 0.058766,
     "end_time": "2023-07-22T11:56:16.422883",
     "exception": false,
     "start_time": "2023-07-22T11:56:16.364117",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "matrix([[0.        , 0.        , 1.        , 0.        , 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.        , 0.        , 1.        , 0.        , 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.        , 0.        , 0.        , 0.        , 0.70710678,\n",
       "         0.        , 0.        , 0.        , 0.70710678, 0.        ],\n",
       "        [0.        , 0.        , 0.        , 0.        , 0.70710678,\n",
       "         0.        , 0.        , 0.        , 0.70710678, 0.        ],\n",
       "        [0.        , 0.        , 0.        , 0.        , 0.70710678,\n",
       "         0.        , 0.        , 0.        , 0.70710678, 0.        ],\n",
       "        [0.        , 0.        , 0.        , 0.        , 0.70710678,\n",
       "         0.        , 0.        , 0.        , 0.70710678, 0.        ],\n",
       "        [0.70710678, 0.        , 0.        , 0.70710678, 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.        , 0.        , 0.        , 0.        , 0.70710678,\n",
       "         0.        , 0.        , 0.        , 0.70710678, 0.        ],\n",
       "        [0.        , 1.        , 0.        , 0.        , 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.        , 1.        , 0.        , 0.        , 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.        , 1.        , 0.        , 0.        , 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.        , 1.        , 0.        , 0.        , 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.        , 1.        , 0.        , 0.        , 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.        , 1.        , 0.        , 0.        , 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "         0.        , 0.70710678, 0.70710678, 0.        , 0.        ],\n",
       "        [0.        , 0.        , 1.        , 0.        , 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.        , 0.        , 1.        , 0.        , 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.        , 0.        , 1.        , 0.        , 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.        , 0.        , 0.        , 0.        , 0.70710678,\n",
       "         0.        , 0.        , 0.        , 0.70710678, 0.        ],\n",
       "        [0.        , 0.        , 1.        , 0.        , 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.        , 0.        , 1.        , 0.        , 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "         0.70710678, 0.        , 0.        , 0.        , 0.70710678],\n",
       "        [0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "         0.70710678, 0.        , 0.        , 0.        , 0.70710678],\n",
       "        [0.        , 0.        , 1.        , 0.        , 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "         0.        , 0.70710678, 0.70710678, 0.        , 0.        ],\n",
       "        [0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "         0.        , 0.70710678, 0.70710678, 0.        , 0.        ],\n",
       "        [0.        , 0.        , 0.        , 0.        , 0.70710678,\n",
       "         0.        , 0.        , 0.        , 0.70710678, 0.        ],\n",
       "        [0.        , 0.        , 0.        , 0.        , 0.70710678,\n",
       "         0.        , 0.        , 0.        , 0.70710678, 0.        ],\n",
       "        [0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "         0.        , 0.70710678, 0.70710678, 0.        , 0.        ],\n",
       "        [0.        , 0.        , 0.        , 0.        , 0.70710678,\n",
       "         0.        , 0.        , 0.        , 0.70710678, 0.        ],\n",
       "        [0.70710678, 0.        , 0.        , 0.70710678, 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.        , 0.        , 1.        , 0.        , 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.        , 0.        , 0.        , 0.        , 0.70710678,\n",
       "         0.        , 0.        , 0.        , 0.70710678, 0.        ],\n",
       "        [0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "         0.        , 0.70710678, 0.70710678, 0.        , 0.        ],\n",
       "        [0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "         0.        , 0.70710678, 0.70710678, 0.        , 0.        ],\n",
       "        [0.        , 0.        , 0.        , 0.        , 0.70710678,\n",
       "         0.        , 0.        , 0.        , 0.70710678, 0.        ],\n",
       "        [0.        , 0.        , 0.        , 0.        , 0.70710678,\n",
       "         0.        , 0.        , 0.        , 0.70710678, 0.        ],\n",
       "        [0.        , 0.        , 1.        , 0.        , 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.        , 0.        , 1.        , 0.        , 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.        , 0.        , 1.        , 0.        , 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.        , 0.        , 1.        , 0.        , 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.        , 0.        , 1.        , 0.        , 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.        , 0.        , 0.        , 0.        , 0.70710678,\n",
       "         0.        , 0.        , 0.        , 0.70710678, 0.        ],\n",
       "        [0.        , 0.        , 1.        , 0.        , 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.        , 0.        , 0.        , 0.        , 0.70710678,\n",
       "         0.        , 0.        , 0.        , 0.70710678, 0.        ],\n",
       "        [0.        , 1.        , 0.        , 0.        , 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.        , 0.        , 0.        , 0.        , 0.70710678,\n",
       "         0.        , 0.        , 0.        , 0.70710678, 0.        ],\n",
       "        [0.        , 0.        , 1.        , 0.        , 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.        , 0.        , 1.        , 0.        , 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.        , 0.        , 1.        , 0.        , 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.        , 0.        , 0.        , 0.        , 0.70710678,\n",
       "         0.        , 0.        , 0.        , 0.70710678, 0.        ],\n",
       "        [0.        , 0.        , 1.        , 0.        , 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.        , 0.        , 1.        , 0.        , 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.        , 0.        , 0.        , 0.        , 0.70710678,\n",
       "         0.        , 0.        , 0.        , 0.70710678, 0.        ],\n",
       "        [0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "         0.70710678, 0.        , 0.        , 0.        , 0.70710678],\n",
       "        [0.        , 1.        , 0.        , 0.        , 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.        , 0.        , 0.        , 0.        , 0.70710678,\n",
       "         0.        , 0.        , 0.        , 0.70710678, 0.        ],\n",
       "        [0.        , 0.        , 0.        , 0.        , 0.70710678,\n",
       "         0.        , 0.        , 0.        , 0.70710678, 0.        ],\n",
       "        [0.        , 0.        , 1.        , 0.        , 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.        , 0.        , 1.        , 0.        , 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.        , 0.        , 1.        , 0.        , 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.        , 0.        , 0.        , 0.        , 0.70710678,\n",
       "         0.        , 0.        , 0.        , 0.70710678, 0.        ],\n",
       "        [0.        , 0.        , 1.        , 0.        , 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.        , 0.        , 1.        , 0.        , 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.        , 0.        , 1.        , 0.        , 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.        , 0.        , 1.        , 0.        , 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.70710678, 0.        , 0.        , 0.70710678, 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "         0.        , 0.70710678, 0.70710678, 0.        , 0.        ],\n",
       "        [0.        , 0.        , 1.        , 0.        , 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.        , 0.        , 1.        , 0.        , 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.70710678, 0.        , 0.        , 0.70710678, 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.        , 0.        , 0.        , 0.        , 0.70710678,\n",
       "         0.        , 0.        , 0.        , 0.70710678, 0.        ],\n",
       "        [0.        , 0.        , 1.        , 0.        , 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.        , 0.        , 1.        , 0.        , 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.        , 0.        , 0.        , 0.        , 0.70710678,\n",
       "         0.        , 0.        , 0.        , 0.70710678, 0.        ],\n",
       "        [0.        , 0.        , 0.        , 0.        , 0.70710678,\n",
       "         0.        , 0.        , 0.        , 0.70710678, 0.        ],\n",
       "        [0.        , 0.        , 0.        , 0.        , 0.70710678,\n",
       "         0.        , 0.        , 0.        , 0.70710678, 0.        ],\n",
       "        [0.        , 0.        , 0.        , 0.        , 0.70710678,\n",
       "         0.        , 0.        , 0.        , 0.70710678, 0.        ],\n",
       "        [0.        , 0.        , 0.        , 0.        , 0.70710678,\n",
       "         0.        , 0.        , 0.        , 0.70710678, 0.        ],\n",
       "        [0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "         0.        , 0.70710678, 0.70710678, 0.        , 0.        ],\n",
       "        [0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "         0.        , 0.70710678, 0.70710678, 0.        , 0.        ],\n",
       "        [0.        , 0.        , 1.        , 0.        , 0.        ,\n",
       "         0.        , 0.        , 0.        , 0.        , 0.        ],\n",
       "        [0.        , 0.        , 0.        , 0.        , 0.70710678,\n",
       "         0.        , 0.        , 0.        , 0.70710678, 0.        ],\n",
       "        [0.        , 0.        , 0.        , 0.        , 0.        ,\n",
       "         0.        , 0.70710678, 0.70710678, 0.        , 0.        ]])"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tfidf_matrix.todense()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "7fea05e6",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2023-07-22T11:56:16.562136Z",
     "iopub.status.busy": "2023-07-22T11:56:16.561276Z",
     "iopub.status.idle": "2023-07-22T11:56:16.588749Z",
     "shell.execute_reply": "2023-07-22T11:56:16.587519Z"
    },
    "papermill": {
     "duration": 0.065722,
     "end_time": "2023-07-22T11:56:16.591296",
     "exception": false,
     "start_time": "2023-07-22T11:56:16.525574",
     "status": "completed"
    },
    "tags": []
   },
   "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>alam</th>\n",
       "      <th>bahari</th>\n",
       "      <th>budaya</th>\n",
       "      <th>cagar</th>\n",
       "      <th>hiburan</th>\n",
       "      <th>ibadah</th>\n",
       "      <th>perbelanjaan</th>\n",
       "      <th>pusat</th>\n",
       "      <th>taman</th>\n",
       "      <th>tempat</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Place_Name</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>Pelabuhan Marina</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Museum Layang-layang</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Freedom Library</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Museum Basoeki Abdullah</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Waterboom PIK (Pantai Indah Kapuk)</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.707107</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.707107</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Atlantis Water Adventure</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.707107</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.707107</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Istana Negara Republik Indonesia</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pulau Pari</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Museum Wayang</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Wisata Alam Mangrove Angke</th>\n",
       "      <td>0.707107</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.707107</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        alam  bahari  budaya     cagar  \\\n",
       "Place_Name                                                               \n",
       "Pelabuhan Marina                    0.000000     1.0     0.0  0.000000   \n",
       "Museum Layang-layang                0.000000     0.0     1.0  0.000000   \n",
       "Freedom Library                     0.000000     0.0     1.0  0.000000   \n",
       "Museum Basoeki Abdullah             0.000000     0.0     1.0  0.000000   \n",
       "Waterboom PIK (Pantai Indah Kapuk)  0.000000     0.0     0.0  0.000000   \n",
       "Atlantis Water Adventure            0.000000     0.0     0.0  0.000000   \n",
       "Istana Negara Republik Indonesia    0.000000     0.0     1.0  0.000000   \n",
       "Pulau Pari                          0.000000     1.0     0.0  0.000000   \n",
       "Museum Wayang                       0.000000     0.0     1.0  0.000000   \n",
       "Wisata Alam Mangrove Angke          0.707107     0.0     0.0  0.707107   \n",
       "\n",
       "                                     hiburan  ibadah  perbelanjaan  pusat  \\\n",
       "Place_Name                                                                  \n",
       "Pelabuhan Marina                    0.000000     0.0           0.0    0.0   \n",
       "Museum Layang-layang                0.000000     0.0           0.0    0.0   \n",
       "Freedom Library                     0.000000     0.0           0.0    0.0   \n",
       "Museum Basoeki Abdullah             0.000000     0.0           0.0    0.0   \n",
       "Waterboom PIK (Pantai Indah Kapuk)  0.707107     0.0           0.0    0.0   \n",
       "Atlantis Water Adventure            0.707107     0.0           0.0    0.0   \n",
       "Istana Negara Republik Indonesia    0.000000     0.0           0.0    0.0   \n",
       "Pulau Pari                          0.000000     0.0           0.0    0.0   \n",
       "Museum Wayang                       0.000000     0.0           0.0    0.0   \n",
       "Wisata Alam Mangrove Angke          0.000000     0.0           0.0    0.0   \n",
       "\n",
       "                                       taman  tempat  \n",
       "Place_Name                                            \n",
       "Pelabuhan Marina                    0.000000     0.0  \n",
       "Museum Layang-layang                0.000000     0.0  \n",
       "Freedom Library                     0.000000     0.0  \n",
       "Museum Basoeki Abdullah             0.000000     0.0  \n",
       "Waterboom PIK (Pantai Indah Kapuk)  0.707107     0.0  \n",
       "Atlantis Water Adventure            0.707107     0.0  \n",
       "Istana Negara Republik Indonesia    0.000000     0.0  \n",
       "Pulau Pari                          0.000000     0.0  \n",
       "Museum Wayang                       0.000000     0.0  \n",
       "Wisata Alam Mangrove Angke          0.000000     0.0  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame(\n",
    "    tfidf_matrix.todense(),\n",
    "    columns=tf.get_feature_names_out(),\n",
    "    index=destination.Place_Name\n",
    ").sample(10, axis=0)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "db2e3d92",
   "metadata": {
    "papermill": {
     "duration": 0.034758,
     "end_time": "2023-07-22T11:56:16.661374",
     "exception": false,
     "start_time": "2023-07-22T11:56:16.626616",
     "status": "completed"
    },
    "tags": []
   },
   "source": [
    "Cosine Similarity"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "4e3aa124",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2023-07-22T11:56:16.733804Z",
     "iopub.status.busy": "2023-07-22T11:56:16.733167Z",
     "iopub.status.idle": "2023-07-22T11:56:16.856027Z",
     "shell.execute_reply": "2023-07-22T11:56:16.854847Z"
    },
    "papermill": {
     "duration": 0.161975,
     "end_time": "2023-07-22T11:56:16.858436",
     "exception": false,
     "start_time": "2023-07-22T11:56:16.696461",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [],
   "source": [
    "from sklearn.metrics.pairwise import cosine_similarity\n",
    "\n",
    "cosine_sim = cosine_similarity(tfidf_matrix)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "e23c5d70",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2023-07-22T11:56:17.004364Z",
     "iopub.status.busy": "2023-07-22T11:56:17.003919Z",
     "iopub.status.idle": "2023-07-22T11:56:17.176455Z",
     "shell.execute_reply": "2023-07-22T11:56:17.175127Z"
    },
    "papermill": {
     "duration": 0.215531,
     "end_time": "2023-07-22T11:56:17.181870",
     "exception": false,
     "start_time": "2023-07-22T11:56:16.966339",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [],
   "source": [
    "cosine_sim_df = pd.DataFrame(\n",
    "    cosine_sim, index=destination.Place_Name, columns=destination.Place_Name)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "40e4e703",
   "metadata": {
    "papermill": {
     "duration": 0.038051,
     "end_time": "2023-07-22T11:56:17.258548",
     "exception": false,
     "start_time": "2023-07-22T11:56:17.220497",
     "status": "completed"
    },
    "tags": []
   },
   "source": [
    "Implementasi Sistem Recommendasi"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "db2f642c",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2023-07-22T11:56:17.338479Z",
     "iopub.status.busy": "2023-07-22T11:56:17.338072Z",
     "iopub.status.idle": "2023-07-22T11:56:17.346883Z",
     "shell.execute_reply": "2023-07-22T11:56:17.345525Z"
    },
    "papermill": {
     "duration": 0.051418,
     "end_time": "2023-07-22T11:56:17.349421",
     "exception": false,
     "start_time": "2023-07-22T11:56:17.298003",
     "status": "completed"
    },
    "tags": []
   },
   "outputs": [],
   "source": [
    "def destination_recommendations(place_name, similarity_data=cosine_sim_df, items=destination[['Place_Name', 'Category', 'Rating', 'Price']], k=10):\n",
    "    index = similarity_data.loc[:,place_name].to_numpy().argpartition(range(-1, -k, -1))\n",
    "    closest = similarity_data.columns[index[-1:-(k+2):-1]]\n",
    "    closest = closest.drop(place_name, errors='ignore')\n",
    "    return pd.DataFrame(closest).merge(items).head(k)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "2c84cac5",
   "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>Place_Id</th>\n",
       "      <th>Place_Name</th>\n",
       "      <th>Description</th>\n",
       "      <th>Category</th>\n",
       "      <th>City</th>\n",
       "      <th>Price</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Coordinate</th>\n",
       "      <th>Lat</th>\n",
       "      <th>Long</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Monumen Nasional</td>\n",
       "      <td>Monumen Nasional atau yang populer disingkat d...</td>\n",
       "      <td>Budaya</td>\n",
       "      <td>Jakarta</td>\n",
       "      <td>20000</td>\n",
       "      <td>4.6</td>\n",
       "      <td>{'lat': -6.1753924, 'lng': 106.8271528}</td>\n",
       "      <td>-6.175392</td>\n",
       "      <td>106.827153</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Kota Tua</td>\n",
       "      <td>Kota tua di Jakarta, yang juga bernama Kota Tu...</td>\n",
       "      <td>Budaya</td>\n",
       "      <td>Jakarta</td>\n",
       "      <td>0</td>\n",
       "      <td>4.6</td>\n",
       "      <td>{'lat': -6.137644799999999, 'lng': 106.8171245}</td>\n",
       "      <td>-6.137645</td>\n",
       "      <td>106.817125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Dunia Fantasi</td>\n",
       "      <td>Dunia Fantasi atau disebut juga Dufan adalah t...</td>\n",
       "      <td>Taman Hiburan</td>\n",
       "      <td>Jakarta</td>\n",
       "      <td>270000</td>\n",
       "      <td>4.6</td>\n",
       "      <td>{'lat': -6.125312399999999, 'lng': 106.8335377}</td>\n",
       "      <td>-6.125312</td>\n",
       "      <td>106.833538</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Taman Mini Indonesia Indah (TMII)</td>\n",
       "      <td>Taman Mini Indonesia Indah merupakan suatu kaw...</td>\n",
       "      <td>Taman Hiburan</td>\n",
       "      <td>Jakarta</td>\n",
       "      <td>10000</td>\n",
       "      <td>4.5</td>\n",
       "      <td>{'lat': -6.302445899999999, 'lng': 106.8951559}</td>\n",
       "      <td>-6.302446</td>\n",
       "      <td>106.895156</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Atlantis Water Adventure</td>\n",
       "      <td>Atlantis Water Adventure atau dikenal dengan A...</td>\n",
       "      <td>Taman Hiburan</td>\n",
       "      <td>Jakarta</td>\n",
       "      <td>94000</td>\n",
       "      <td>4.5</td>\n",
       "      <td>{'lat': -6.12419, 'lng': 106.839134}</td>\n",
       "      <td>-6.124190</td>\n",
       "      <td>106.839134</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>80</td>\n",
       "      <td>Plaza Indonesia</td>\n",
       "      <td>Plaza Indonesia diresmikan pada awal tahun 199...</td>\n",
       "      <td>Pusat Perbelanjaan</td>\n",
       "      <td>Jakarta</td>\n",
       "      <td>0</td>\n",
       "      <td>4.7</td>\n",
       "      <td>{'lat': -6.193925900000002, 'lng': 106.8222158}</td>\n",
       "      <td>-6.193926</td>\n",
       "      <td>106.822216</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>81</td>\n",
       "      <td>Mall Thamrin City</td>\n",
       "      <td>Thamrin City atau Thamrin City Mall merupakan ...</td>\n",
       "      <td>Pusat Perbelanjaan</td>\n",
       "      <td>Jakarta</td>\n",
       "      <td>0</td>\n",
       "      <td>4.4</td>\n",
       "      <td>{'lat': -6.1946096, 'lng': 106.817905}</td>\n",
       "      <td>-6.194610</td>\n",
       "      <td>106.817905</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>82</td>\n",
       "      <td>Museum Satria Mandala</td>\n",
       "      <td>Museum Satria Mandala adalah museum sejarah pe...</td>\n",
       "      <td>Budaya</td>\n",
       "      <td>Jakarta</td>\n",
       "      <td>5000</td>\n",
       "      <td>4.5</td>\n",
       "      <td>{'lat': -6.231698499999999, 'lng': 106.8185425}</td>\n",
       "      <td>-6.231699</td>\n",
       "      <td>106.818543</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>83</td>\n",
       "      <td>Alive Museum Ancol</td>\n",
       "      <td>Museum kini tidak hanya menawarkan benda – ben...</td>\n",
       "      <td>Taman Hiburan</td>\n",
       "      <td>Jakarta</td>\n",
       "      <td>200000</td>\n",
       "      <td>4.3</td>\n",
       "      <td>{'lat': -6.117534399999999, 'lng': 106.857313}</td>\n",
       "      <td>-6.117534</td>\n",
       "      <td>106.857313</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>84</td>\n",
       "      <td>Kawasan Kuliner BSM</td>\n",
       "      <td>Tidak seperti Pecenongan, Kawasan Kuliner BSM ...</td>\n",
       "      <td>Pusat Perbelanjaan</td>\n",
       "      <td>Jakarta</td>\n",
       "      <td>0</td>\n",
       "      <td>4.6</td>\n",
       "      <td>{'lat': -6.184258799999999, 'lng': 106.824033}</td>\n",
       "      <td>-6.184259</td>\n",
       "      <td>106.824033</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>84 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Place_Id                         Place_Name  \\\n",
       "0          1                   Monumen Nasional   \n",
       "1          2                           Kota Tua   \n",
       "2          3                      Dunia Fantasi   \n",
       "3          4  Taman Mini Indonesia Indah (TMII)   \n",
       "4          5           Atlantis Water Adventure   \n",
       "..       ...                                ...   \n",
       "79        80                    Plaza Indonesia   \n",
       "80        81                  Mall Thamrin City   \n",
       "81        82              Museum Satria Mandala   \n",
       "82        83                 Alive Museum Ancol   \n",
       "83        84                Kawasan Kuliner BSM   \n",
       "\n",
       "                                          Description            Category  \\\n",
       "0   Monumen Nasional atau yang populer disingkat d...              Budaya   \n",
       "1   Kota tua di Jakarta, yang juga bernama Kota Tu...              Budaya   \n",
       "2   Dunia Fantasi atau disebut juga Dufan adalah t...       Taman Hiburan   \n",
       "3   Taman Mini Indonesia Indah merupakan suatu kaw...       Taman Hiburan   \n",
       "4   Atlantis Water Adventure atau dikenal dengan A...       Taman Hiburan   \n",
       "..                                                ...                 ...   \n",
       "79  Plaza Indonesia diresmikan pada awal tahun 199...  Pusat Perbelanjaan   \n",
       "80  Thamrin City atau Thamrin City Mall merupakan ...  Pusat Perbelanjaan   \n",
       "81  Museum Satria Mandala adalah museum sejarah pe...              Budaya   \n",
       "82  Museum kini tidak hanya menawarkan benda – ben...       Taman Hiburan   \n",
       "83  Tidak seperti Pecenongan, Kawasan Kuliner BSM ...  Pusat Perbelanjaan   \n",
       "\n",
       "       City   Price  Rating                                       Coordinate  \\\n",
       "0   Jakarta   20000     4.6          {'lat': -6.1753924, 'lng': 106.8271528}   \n",
       "1   Jakarta       0     4.6  {'lat': -6.137644799999999, 'lng': 106.8171245}   \n",
       "2   Jakarta  270000     4.6  {'lat': -6.125312399999999, 'lng': 106.8335377}   \n",
       "3   Jakarta   10000     4.5  {'lat': -6.302445899999999, 'lng': 106.8951559}   \n",
       "4   Jakarta   94000     4.5             {'lat': -6.12419, 'lng': 106.839134}   \n",
       "..      ...     ...     ...                                              ...   \n",
       "79  Jakarta       0     4.7  {'lat': -6.193925900000002, 'lng': 106.8222158}   \n",
       "80  Jakarta       0     4.4           {'lat': -6.1946096, 'lng': 106.817905}   \n",
       "81  Jakarta    5000     4.5  {'lat': -6.231698499999999, 'lng': 106.8185425}   \n",
       "82  Jakarta  200000     4.3   {'lat': -6.117534399999999, 'lng': 106.857313}   \n",
       "83  Jakarta       0     4.6   {'lat': -6.184258799999999, 'lng': 106.824033}   \n",
       "\n",
       "         Lat        Long  \n",
       "0  -6.175392  106.827153  \n",
       "1  -6.137645  106.817125  \n",
       "2  -6.125312  106.833538  \n",
       "3  -6.302446  106.895156  \n",
       "4  -6.124190  106.839134  \n",
       "..       ...         ...  \n",
       "79 -6.193926  106.822216  \n",
       "80 -6.194610  106.817905  \n",
       "81 -6.231699  106.818543  \n",
       "82 -6.117534  106.857313  \n",
       "83 -6.184259  106.824033  \n",
       "\n",
       "[84 rows x 10 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "jakarta = destination[destination['City'] == 'Jakarta']\n",
    "# jakarta = jakarta[['Place_Id','Place_Name','Category','Rating','Price']]\n",
    "jakarta"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "dbbb8502",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2023-07-22T11:56:17.755691Z",
     "iopub.status.busy": "2023-07-22T11:56:17.755285Z",
     "iopub.status.idle": "2023-07-22T11:56:17.773676Z",
     "shell.execute_reply": "2023-07-22T11:56:17.772289Z"
    },
    "papermill": {
     "duration": 0.062904,
     "end_time": "2023-07-22T11:56:17.776083",
     "exception": false,
     "start_time": "2023-07-22T11:56:17.713179",
     "status": "completed"
    },
    "tags": []
   },
   "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>Place_Name</th>\n",
       "      <th>Category</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Price</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>The Escape Hunt</td>\n",
       "      <td>Taman Hiburan</td>\n",
       "      <td>4.4</td>\n",
       "      <td>70000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Wisata Agro Edukatif Istana Susu Cibugary</td>\n",
       "      <td>Taman Hiburan</td>\n",
       "      <td>4.5</td>\n",
       "      <td>35000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Jakarta Aquarium dan Safari</td>\n",
       "      <td>Taman Hiburan</td>\n",
       "      <td>4.6</td>\n",
       "      <td>185000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Taman Legenda Keong Emas</td>\n",
       "      <td>Taman Hiburan</td>\n",
       "      <td>4.5</td>\n",
       "      <td>30000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Taman Menteng</td>\n",
       "      <td>Taman Hiburan</td>\n",
       "      <td>4.5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Taman Suropati</td>\n",
       "      <td>Taman Hiburan</td>\n",
       "      <td>4.6</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Skyrink - Mall Taman Anggrek</td>\n",
       "      <td>Taman Hiburan</td>\n",
       "      <td>4.5</td>\n",
       "      <td>110000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Sea World</td>\n",
       "      <td>Taman Hiburan</td>\n",
       "      <td>4.5</td>\n",
       "      <td>115000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Taman Lapangan Banteng</td>\n",
       "      <td>Taman Hiburan</td>\n",
       "      <td>4.7</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Taman Situ Lembang</td>\n",
       "      <td>Taman Hiburan</td>\n",
       "      <td>4.5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  Place_Name       Category  Rating   Price\n",
       "0                            The Escape Hunt  Taman Hiburan     4.4   70000\n",
       "1  Wisata Agro Edukatif Istana Susu Cibugary  Taman Hiburan     4.5   35000\n",
       "2                Jakarta Aquarium dan Safari  Taman Hiburan     4.6  185000\n",
       "3                   Taman Legenda Keong Emas  Taman Hiburan     4.5   30000\n",
       "4                              Taman Menteng  Taman Hiburan     4.5       0\n",
       "5                             Taman Suropati  Taman Hiburan     4.6       0\n",
       "6               Skyrink - Mall Taman Anggrek  Taman Hiburan     4.5  110000\n",
       "7                                  Sea World  Taman Hiburan     4.5  115000\n",
       "8                     Taman Lapangan Banteng  Taman Hiburan     4.7       0\n",
       "9                         Taman Situ Lembang  Taman Hiburan     4.5       0"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# ten_place = input('Masukkan Nama Tempat')\n",
    "# destination_recommendations(ten_place)\n",
    "\n",
    "destination_recommendations('Kidzania')"
   ]
  }
 ],
 "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.10.6"
  },
  "papermill": {
   "default_parameters": {},
   "duration": 23.744937,
   "end_time": "2023-07-22T11:56:18.917490",
   "environment_variables": {},
   "exception": null,
   "input_path": "__notebook__.ipynb",
   "output_path": "__notebook__.ipynb",
   "parameters": {},
   "start_time": "2023-07-22T11:55:55.172553",
   "version": "2.4.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}