Dataset Scraping - Hotel and Flight.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "from selenium import webdriver\n",
    "from selenium.webdriver.common.keys import Keys\n",
    "from time import sleep, strftime\n",
    "from random import randint\n",
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "df=pd.read_csv(r\"C:\\Users\\chiri\\Purwadhika\\Final Project\\dataset_indo.csv\")\n",
    "\n",
    "destination=df[\"Travel Destination\"].values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "df=df.reset_index().drop([\"Unnamed: 0\", \"index\"], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "scrolled": false
   },
   "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>Country Name</th>\n",
       "      <th>Travel Destination</th>\n",
       "      <th>Checking</th>\n",
       "      <th>Things to Do</th>\n",
       "      <th>location</th>\n",
       "      <th>reviewcount</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bintan</td>\n",
       "      <td>Bintan</td>\n",
       "      <td>['Tur (39)', 'Aktivitas Luar Ruangan (30)', 'T...</td>\n",
       "      <td>Bintan Regency, Indonesia</td>\n",
       "      <td>25006</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Seminyak</td>\n",
       "      <td>Seminyak</td>\n",
       "      <td>['Tur (204)', 'Spa &amp; Kebugaran (164)', 'Aktivi...</td>\n",
       "      <td>Kecamatan Kuta, Indonesia</td>\n",
       "      <td>451212</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Bali</td>\n",
       "      <td>Bali</td>\n",
       "      <td>['Tur (5.854)', 'Aktivitas Luar Ruangan (3.740...</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>2998882</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Ubud</td>\n",
       "      <td>Ubud</td>\n",
       "      <td>['Tur (884)', 'Aktivitas Luar Ruangan (525)', ...</td>\n",
       "      <td>Gianyar Regency, Indonesia</td>\n",
       "      <td>610495</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Jakarta</td>\n",
       "      <td>Jakarta</td>\n",
       "      <td>['Tur (168)', 'Tempat Belanja (148)', 'Spa &amp; K...</td>\n",
       "      <td>Jawa, Indonesia</td>\n",
       "      <td>339358</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>321</th>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Toyapakeh</td>\n",
       "      <td>Toyapakeh</td>\n",
       "      <td>['Tur (5)', 'Tur dengan Perahu &amp; Olahraga Air ...</td>\n",
       "      <td>Nusa Penida, Indonesia</td>\n",
       "      <td>742</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>322</th>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Singakerta</td>\n",
       "      <td>Singakerta</td>\n",
       "      <td>['Spa &amp; Kebugaran (2)', 'Tur (2)', 'Kursus &amp; S...</td>\n",
       "      <td>Ubud, Indonesia</td>\n",
       "      <td>2019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>323</th>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Guwang</td>\n",
       "      <td>Guwang</td>\n",
       "      <td>['Wisata Alam &amp; Taman (1)', 'Cocok untuk Pasan...</td>\n",
       "      <td>Sukawati, Indonesia</td>\n",
       "      <td>343</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324</th>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Singapadu Kaler</td>\n",
       "      <td>Singapadu Kaler</td>\n",
       "      <td>['Tur (1)', 'Tur dengan Perahu &amp; Olahraga Air ...</td>\n",
       "      <td>Sukawati, Indonesia</td>\n",
       "      <td>309</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>325</th>\n",
       "      <td>Indonesia</td>\n",
       "      <td>Batu Karas</td>\n",
       "      <td>Batu Karas</td>\n",
       "      <td>['Tur (2)', 'Tur dengan Perahu &amp; Olahraga Air ...</td>\n",
       "      <td>Jawa Barat, Indonesia</td>\n",
       "      <td>206</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>326 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Country Name Travel Destination         Checking  \\\n",
       "0      Indonesia             Bintan           Bintan   \n",
       "1      Indonesia           Seminyak         Seminyak   \n",
       "2      Indonesia               Bali             Bali   \n",
       "3      Indonesia               Ubud             Ubud   \n",
       "4      Indonesia            Jakarta          Jakarta   \n",
       "..           ...                ...              ...   \n",
       "321    Indonesia          Toyapakeh        Toyapakeh   \n",
       "322    Indonesia         Singakerta       Singakerta   \n",
       "323    Indonesia             Guwang           Guwang   \n",
       "324    Indonesia    Singapadu Kaler  Singapadu Kaler   \n",
       "325    Indonesia         Batu Karas       Batu Karas   \n",
       "\n",
       "                                          Things to Do  \\\n",
       "0    ['Tur (39)', 'Aktivitas Luar Ruangan (30)', 'T...   \n",
       "1    ['Tur (204)', 'Spa & Kebugaran (164)', 'Aktivi...   \n",
       "2    ['Tur (5.854)', 'Aktivitas Luar Ruangan (3.740...   \n",
       "3    ['Tur (884)', 'Aktivitas Luar Ruangan (525)', ...   \n",
       "4    ['Tur (168)', 'Tempat Belanja (148)', 'Spa & K...   \n",
       "..                                                 ...   \n",
       "321  ['Tur (5)', 'Tur dengan Perahu & Olahraga Air ...   \n",
       "322  ['Spa & Kebugaran (2)', 'Tur (2)', 'Kursus & S...   \n",
       "323  ['Wisata Alam & Taman (1)', 'Cocok untuk Pasan...   \n",
       "324  ['Tur (1)', 'Tur dengan Perahu & Olahraga Air ...   \n",
       "325  ['Tur (2)', 'Tur dengan Perahu & Olahraga Air ...   \n",
       "\n",
       "                       location  reviewcount  \n",
       "0     Bintan Regency, Indonesia        25006  \n",
       "1     Kecamatan Kuta, Indonesia       451212  \n",
       "2                     Indonesia      2998882  \n",
       "3    Gianyar Regency, Indonesia       610495  \n",
       "4               Jawa, Indonesia       339358  \n",
       "..                          ...          ...  \n",
       "321      Nusa Penida, Indonesia          742  \n",
       "322             Ubud, Indonesia         2019  \n",
       "323         Sukawati, Indonesia          343  \n",
       "324         Sukawati, Indonesia          309  \n",
       "325       Jawa Barat, Indonesia          206  \n",
       "\n",
       "[326 rows x 6 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "homepage = \"https://www.tripadvisor.co.id/Attractions\"\n",
    "path = r\"C:\\Users\\chiri\\Downloads\\chromedriver.exe\"\n",
    "\n",
    "driver = webdriver.Chrome(path)\n",
    "driver.get(homepage)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_destiny=[]\n",
    "df_linkhotel=[]\n",
    "df_besthotel=[]\n",
    "df_linkflight=[]\n",
    "df_bestflight=[]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Mendut\n",
      "https://www.tripadvisor.co.id/Hotels-g3373423-Mendut_Central_Java_Java-Hotels.html\n",
      "Rp 306.908\n",
      "https://www.tripadvisor.co.id/Flights-g3373423-Mendut_Central_Java_Java-Cheap_Discount_Airfares.html\n",
      "d\n",
      "Subagan\n",
      "https://www.tripadvisor.co.id/Hotels-g3198489-Subagan_Karangasem_Bali-Hotels.html\n",
      "Rp 289.256\n",
      "https://www.tripadvisor.co.id/Flights-g3198489-Subagan_Karangasem_Bali-Cheap_Discount_Airfares.html\n",
      "Rp 1.197.735\n",
      "Ambarita\n",
      "https://www.tripadvisor.co.id/Hotels-g3187028-Ambarita_Samosir_Island_North_Sumatra_Sumatra-Hotels.html\n",
      "Rp 257.553\n",
      "https://www.tripadvisor.co.id/Flights-g3187028-Ambarita_Samosir_Island_North_Sumatra_Sumatra-Cheap_Discount_Airfares.html\n",
      "Rp 1.202.149\n",
      "Tetebatu\n",
      "https://www.tripadvisor.co.id/Hotels-g7106676-Tetebatu_Lombok_West_Nusa_Tenggara-Hotels.html\n",
      "Rp 270.000\n",
      "https://www.tripadvisor.co.id/Flights-g7106676-Tetebatu_Lombok_West_Nusa_Tenggara-Cheap_Discount_Airfares.html\n",
      "Rp 1.134.030\n",
      "Tanjungsari\n",
      "https://www.tripadvisor.co.id/Hotels-g3605986-Tanjungsari_Yogyakarta_Region_Java-Hotels.html\n",
      "Rp 498.832\n",
      "https://www.tripadvisor.co.id/Flights-g3605986-Tanjungsari_Yogyakarta_Region_Java-Cheap_Discount_Airfares.html\n",
      "Rp 1.787.500\n",
      "Pujut\n",
      "https://www.tripadvisor.co.id/Hotels-g3607401-Pujut_Lombok_West_Nusa_Tenggara-Hotels.html\n",
      "Rp 1.045.455\n",
      "https://www.tripadvisor.co.id/Flights-g3607401-Pujut_Lombok_West_Nusa_Tenggara-Cheap_Discount_Airfares.html\n",
      "Rp 1.185.947\n",
      "Kuta Selatan\n",
      "https://www.tripadvisor.co.id/Hotels-g12997472-South_Kuta_Bali-Hotels.html\n",
      "Rp 3.437.868\n",
      "https://www.tripadvisor.co.id/Flights-g12997472-South_Kuta_Bali-Cheap_Discount_Airfares.html\n",
      "Rp 1.305.700\n",
      "Kuta Selatan\n",
      "https://www.tripadvisor.co.id/Hotels-g12997472-South_Kuta_Bali-Hotels.html\n",
      "Rp 3.437.868\n",
      "https://www.tripadvisor.co.id/Flights-g12997472-South_Kuta_Bali-Cheap_Discount_Airfares.html\n",
      "Rp 1.305.700\n",
      "Carangsari\n",
      "https://www.tripadvisor.co.id/Hotels-g8456691-Carangsari_Bali-Hotels.html\n",
      "Rp 991.736\n",
      "https://www.tripadvisor.co.id/Flights-g8456691-Carangsari_Bali-Cheap_Discount_Airfares.html\n",
      "Rp 1.197.735\n",
      "Provinsi Bengkulu\n",
      "https://www.tripadvisor.co.id/Hotels-g2323384-Bengkulu_Province_Sumatra-Hotels.html\n",
      "Rp 254.545\n",
      "https://www.tripadvisor.co.id/Flights-g2323384-Bengkulu_Province_Sumatra-Cheap_Discount_Airfares.html\n",
      "Rp 1.075.230\n",
      "Nungnung\n",
      "a\n",
      "Labuhan\n",
      "https://www.tripadvisor.co.id/Hotels-g3320215-Labuhan_Banten_Province_Java-Hotels.html\n",
      "Rp 836.621\n",
      "https://www.tripadvisor.co.id/Flights-g3320215-Labuhan_Banten_Province_Java-Cheap_Discount_Airfares.html\n",
      "d\n",
      "Sembalun Lawang\n",
      "https://www.tripadvisor.co.id/Hotels-g12955895-Sembalun_Lawang_Lombok_West_Nusa_Tenggara-Hotels.html\n",
      "Rp 165.289\n",
      "https://www.tripadvisor.co.id/Flights-g12955895-Sembalun_Lawang_Lombok_West_Nusa_Tenggara-Cheap_Discount_Airfares.html\n",
      "Rp 1.134.030\n",
      "Cihideung\n",
      "https://www.tripadvisor.co.id/Hotels-g13219542-Cihideung_West_Java_Java-Hotels.html\n",
      "Rp 119.884\n",
      "https://www.tripadvisor.co.id/Flights-g13219542-Cihideung_West_Java_Java-Cheap_Discount_Airfares.html\n",
      "d\n",
      "Bedulu\n",
      "https://www.tripadvisor.co.id/Hotels-g11769423-Bedulu_Blahbatuh_Gianyar_Regency_Bali-Hotels.html\n",
      "Rp 225.000\n",
      "https://www.tripadvisor.co.id/Flights-g11769423-Bedulu_Blahbatuh_Gianyar_Regency_Bali-Cheap_Discount_Airfares.html\n",
      "Rp 1.305.700\n",
      "Bangli\n",
      "https://www.tripadvisor.co.id/Hotels-g1025506-Bangli_Bali-Hotels.html\n",
      "Rp 400.000\n",
      "https://www.tripadvisor.co.id/Flights-g1025506-Bangli_Bali-Cheap_Discount_Airfares.html\n",
      "Rp 1.145.870\n",
      "Pulau Kri\n",
      "https://www.tripadvisor.co.id/Hotels-g15024679-Kri_Island_Raja_Ampat_West_Papua-Hotels.html\n",
      "Rp 578.999\n",
      "https://www.tripadvisor.co.id/Flights-g15024679-Kri_Island_Raja_Ampat_West_Papua-Cheap_Discount_Airfares.html\n",
      "d\n",
      "Keliki\n",
      "https://www.tripadvisor.co.id/Hotels-g15239500-Keliki_Gianyar_Gianyar_Regency_Bali-Hotels.html\n",
      "Rp 4.062.500\n",
      "https://www.tripadvisor.co.id/Flights-g15239500-Keliki_Gianyar_Gianyar_Regency_Bali-Cheap_Discount_Airfares.html\n",
      "Rp 1.300.707\n",
      "Dangin Puri\n",
      "https://www.tripadvisor.co.id/Hotels-g15239398-Dangin_Puri_Denpasar_Bali-Hotels.html\n",
      "Rp 1.995.000\n",
      "https://www.tripadvisor.co.id/Flights-g15239398-Dangin_Puri_Denpasar_Bali-Cheap_Discount_Airfares.html\n",
      "Rp 1.145.870\n",
      "Sukasada\n",
      "https://www.tripadvisor.co.id/Hotels-g15212803-Sukasada_Buleleng_Regency_Bali-Hotels.html\n",
      "Rp 400.413\n",
      "https://www.tripadvisor.co.id/Flights-g15212803-Sukasada_Buleleng_Regency_Bali-Cheap_Discount_Airfares.html\n",
      "Rp 1.526.817\n",
      "Toyapakeh\n",
      "https://www.tripadvisor.co.id/Hotels-g14115586-Toyapakeh_Nusa_Penida_Bali-Hotels.html\n",
      "Rp 663.636\n",
      "https://www.tripadvisor.co.id/Flights-g14115586-Toyapakeh_Nusa_Penida_Bali-Cheap_Discount_Airfares.html\n",
      "Rp 1.752.927\n",
      "Singakerta\n",
      "https://www.tripadvisor.co.id/Hotels-g15880600-Singakerta_Ubud_Gianyar_Regency_Bali-Hotels.html\n",
      "Rp 661.107\n",
      "https://www.tripadvisor.co.id/Flights-g15880600-Singakerta_Ubud_Gianyar_Regency_Bali-Cheap_Discount_Airfares.html\n",
      "Rp 1.752.927\n",
      "Guwang\n",
      "a\n",
      "Singapadu Kaler\n",
      "https://www.tripadvisor.co.id/Hotels-g20116867-Singapadu_Kaler_Sukawati_Gianyar_Regency_Bali-Hotels.html\n",
      "Rp 627.097\n",
      "https://www.tripadvisor.co.id/Flights-g20116867-Singapadu_Kaler_Sukawati_Gianyar_Regency_Bali-Cheap_Discount_Airfares.html\n",
      "Rp 1.197.735\n",
      "Batu Karas\n",
      "https://www.tripadvisor.co.id/Hotels-g6677749-Batu_Karas_West_Java_Java-Hotels.html\n",
      "Rp 208.333\n",
      "https://www.tripadvisor.co.id/Flights-g6677749-Batu_Karas_West_Java_Java-Cheap_Discount_Airfares.html\n",
      "d\n"
     ]
    }
   ],
   "source": [
    "for destiny in destination:\n",
    "    df_destiny.append(destiny)\n",
    "    print(destiny)\n",
    "    driver.get(homepage)\n",
    "    sleep(3)\n",
    "    driver.find_element_by_xpath('//*[@id=\"component_1\"]/div/div/form/input[1]').send_keys(destiny)\n",
    "    sleep(2)\n",
    "    driver.find_element_by_class_name('_1dvyiAq4').click()\n",
    "    sleep(2)\n",
    "    \n",
    "    #nyari submenu : Hotel dari list submenu yang ada\n",
    "\n",
    "    driver.find_elements_by_class_name(\"_1T4t-FiN\")\n",
    "    tes=driver.find_elements_by_class_name(\"_1T4t-FiN\")\n",
    "    \n",
    "    #nyari submenu : Hotel dari list submenu yang ada\n",
    "    if len(tes)==0:\n",
    "        print(\"a\")\n",
    "        df_linkhotel.append(np.nan)\n",
    "        df_besthotel.append(np.nan)\n",
    "        df_linkflight.append(np.nan)\n",
    "        df_bestflight.append(np.nan)\n",
    "    \n",
    "    else:\n",
    "        for i in tes:\n",
    "            try:\n",
    "                if (i.text)==\"Hotel\":\n",
    "                    try:\n",
    "                        print(i.get_attribute(\"href\"))\n",
    "                        df_linkhotel.append(i.get_attribute(\"href\"))\n",
    "                        i.click()\n",
    "                        sleep(3)\n",
    "                    except:\n",
    "                        df_linkhotel.append(np.nan)\n",
    "                    \n",
    "                    try:\n",
    "                        print(driver.find_elements_by_class_name(\"price.__resizeWatch\")[0].text)\n",
    "                        df_besthotel.append(driver.find_elements_by_class_name(\"price.__resizeWatch\")[0].text)\n",
    "                    except:                    \n",
    "                        df_besthotel.append(np.nan)\n",
    "                        print(\"b\")\n",
    "\n",
    "                    #navigasi ke tab penerbangan\n",
    "                    try:\n",
    "                        pesawat=driver.find_element_by_id(\"global-nav-flights\")\n",
    "                        print(pesawat.get_attribute(\"href\"))\n",
    "                        df_linkflight.append(pesawat.get_attribute(\"href\"))\n",
    "                        pesawat.click()\n",
    "                        sleep(5)\n",
    "                    except:\n",
    "                        df_linkflight.append(np.nan)\n",
    "                        print(\"c\")\n",
    "\n",
    "                    #Cari Penerbangan\n",
    "                    driver.find_element_by_class_name(\"_1JOGv2rJ._1_M9wxW9._2oWqCEVy._3Ffza2n4._3fiJJkxX\").click()\n",
    "                    sleep(10)\n",
    "\n",
    "                    #ambil harga terendah\n",
    "                    try:\n",
    "                        print(driver.find_elements_by_class_name(\"zEpUay0i\")[0].text)\n",
    "                        df_bestflight.append(driver.find_elements_by_class_name(\"zEpUay0i\")[0].text)              \n",
    "                    except:\n",
    "                        df_bestflight.append(np.nan)\n",
    "                        print(\"d\")\n",
    "\n",
    "            except:\n",
    "                continue"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "25\n",
      "25\n",
      "25\n",
      "25\n",
      "25\n"
     ]
    }
   ],
   "source": [
    "print(len(df_destiny))\n",
    "print(len(df_linkhotel))\n",
    "print(len(df_besthotel))\n",
    "print(len(df_linkflight))\n",
    "print(len(df_bestflight))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 100,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_destiny=df_destiny[0:163]\n",
    "df_linkhotel=df_linkhotel[0:163]\n",
    "df_besthotel=df_besthotel[0:163]\n",
    "df_linkflight=df_linkflight[0:163]\n",
    "df_bestflight=df_bestflight[0:163]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "df=pd.DataFrame()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "df[\"Travel Destination\"]=df_destiny\n",
    "df[\"Hotel Link\"]=df_linkhotel\n",
    "df[\"Hotel Best Deal\"]=df_besthotel\n",
    "df[\"Flight Link\"]=df_linkflight\n",
    "df[\"Flight Best Deal\"]=df_bestflight"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "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>Travel Destination</th>\n",
       "      <th>Hotel Link</th>\n",
       "      <th>Hotel Best Deal</th>\n",
       "      <th>Flight Link</th>\n",
       "      <th>Flight Best Deal</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Mendut</td>\n",
       "      <td>https://www.tripadvisor.co.id/Hotels-g3373423-...</td>\n",
       "      <td>Rp 306.908</td>\n",
       "      <td>https://www.tripadvisor.co.id/Flights-g3373423...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Subagan</td>\n",
       "      <td>https://www.tripadvisor.co.id/Hotels-g3198489-...</td>\n",
       "      <td>Rp 289.256</td>\n",
       "      <td>https://www.tripadvisor.co.id/Flights-g3198489...</td>\n",
       "      <td>Rp 1.197.735</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Ambarita</td>\n",
       "      <td>https://www.tripadvisor.co.id/Hotels-g3187028-...</td>\n",
       "      <td>Rp 257.553</td>\n",
       "      <td>https://www.tripadvisor.co.id/Flights-g3187028...</td>\n",
       "      <td>Rp 1.202.149</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Tetebatu</td>\n",
       "      <td>https://www.tripadvisor.co.id/Hotels-g7106676-...</td>\n",
       "      <td>Rp 270.000</td>\n",
       "      <td>https://www.tripadvisor.co.id/Flights-g7106676...</td>\n",
       "      <td>Rp 1.134.030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Tanjungsari</td>\n",
       "      <td>https://www.tripadvisor.co.id/Hotels-g3605986-...</td>\n",
       "      <td>Rp 498.832</td>\n",
       "      <td>https://www.tripadvisor.co.id/Flights-g3605986...</td>\n",
       "      <td>Rp 1.787.500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Pujut</td>\n",
       "      <td>https://www.tripadvisor.co.id/Hotels-g3607401-...</td>\n",
       "      <td>Rp 1.045.455</td>\n",
       "      <td>https://www.tripadvisor.co.id/Flights-g3607401...</td>\n",
       "      <td>Rp 1.185.947</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Kuta Selatan</td>\n",
       "      <td>https://www.tripadvisor.co.id/Hotels-g12997472...</td>\n",
       "      <td>Rp 3.437.868</td>\n",
       "      <td>https://www.tripadvisor.co.id/Flights-g1299747...</td>\n",
       "      <td>Rp 1.305.700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Kuta Selatan</td>\n",
       "      <td>https://www.tripadvisor.co.id/Hotels-g12997472...</td>\n",
       "      <td>Rp 3.437.868</td>\n",
       "      <td>https://www.tripadvisor.co.id/Flights-g1299747...</td>\n",
       "      <td>Rp 1.305.700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Carangsari</td>\n",
       "      <td>https://www.tripadvisor.co.id/Hotels-g8456691-...</td>\n",
       "      <td>Rp 991.736</td>\n",
       "      <td>https://www.tripadvisor.co.id/Flights-g8456691...</td>\n",
       "      <td>Rp 1.197.735</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Provinsi Bengkulu</td>\n",
       "      <td>https://www.tripadvisor.co.id/Hotels-g2323384-...</td>\n",
       "      <td>Rp 254.545</td>\n",
       "      <td>https://www.tripadvisor.co.id/Flights-g2323384...</td>\n",
       "      <td>Rp 1.075.230</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Nungnung</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Labuhan</td>\n",
       "      <td>https://www.tripadvisor.co.id/Hotels-g3320215-...</td>\n",
       "      <td>Rp 836.621</td>\n",
       "      <td>https://www.tripadvisor.co.id/Flights-g3320215...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Sembalun Lawang</td>\n",
       "      <td>https://www.tripadvisor.co.id/Hotels-g12955895...</td>\n",
       "      <td>Rp 165.289</td>\n",
       "      <td>https://www.tripadvisor.co.id/Flights-g1295589...</td>\n",
       "      <td>Rp 1.134.030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Cihideung</td>\n",
       "      <td>https://www.tripadvisor.co.id/Hotels-g13219542...</td>\n",
       "      <td>Rp 119.884</td>\n",
       "      <td>https://www.tripadvisor.co.id/Flights-g1321954...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Bedulu</td>\n",
       "      <td>https://www.tripadvisor.co.id/Hotels-g11769423...</td>\n",
       "      <td>Rp 225.000</td>\n",
       "      <td>https://www.tripadvisor.co.id/Flights-g1176942...</td>\n",
       "      <td>Rp 1.305.700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Bangli</td>\n",
       "      <td>https://www.tripadvisor.co.id/Hotels-g1025506-...</td>\n",
       "      <td>Rp 400.000</td>\n",
       "      <td>https://www.tripadvisor.co.id/Flights-g1025506...</td>\n",
       "      <td>Rp 1.145.870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Pulau Kri</td>\n",
       "      <td>https://www.tripadvisor.co.id/Hotels-g15024679...</td>\n",
       "      <td>Rp 578.999</td>\n",
       "      <td>https://www.tripadvisor.co.id/Flights-g1502467...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Keliki</td>\n",
       "      <td>https://www.tripadvisor.co.id/Hotels-g15239500...</td>\n",
       "      <td>Rp 4.062.500</td>\n",
       "      <td>https://www.tripadvisor.co.id/Flights-g1523950...</td>\n",
       "      <td>Rp 1.300.707</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Dangin Puri</td>\n",
       "      <td>https://www.tripadvisor.co.id/Hotels-g15239398...</td>\n",
       "      <td>Rp 1.995.000</td>\n",
       "      <td>https://www.tripadvisor.co.id/Flights-g1523939...</td>\n",
       "      <td>Rp 1.145.870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Sukasada</td>\n",
       "      <td>https://www.tripadvisor.co.id/Hotels-g15212803...</td>\n",
       "      <td>Rp 400.413</td>\n",
       "      <td>https://www.tripadvisor.co.id/Flights-g1521280...</td>\n",
       "      <td>Rp 1.526.817</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Toyapakeh</td>\n",
       "      <td>https://www.tripadvisor.co.id/Hotels-g14115586...</td>\n",
       "      <td>Rp 663.636</td>\n",
       "      <td>https://www.tripadvisor.co.id/Flights-g1411558...</td>\n",
       "      <td>Rp 1.752.927</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Singakerta</td>\n",
       "      <td>https://www.tripadvisor.co.id/Hotels-g15880600...</td>\n",
       "      <td>Rp 661.107</td>\n",
       "      <td>https://www.tripadvisor.co.id/Flights-g1588060...</td>\n",
       "      <td>Rp 1.752.927</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Guwang</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Singapadu Kaler</td>\n",
       "      <td>https://www.tripadvisor.co.id/Hotels-g20116867...</td>\n",
       "      <td>Rp 627.097</td>\n",
       "      <td>https://www.tripadvisor.co.id/Flights-g2011686...</td>\n",
       "      <td>Rp 1.197.735</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Batu Karas</td>\n",
       "      <td>https://www.tripadvisor.co.id/Hotels-g6677749-...</td>\n",
       "      <td>Rp 208.333</td>\n",
       "      <td>https://www.tripadvisor.co.id/Flights-g6677749...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Travel Destination                                         Hotel Link  \\\n",
       "0              Mendut  https://www.tripadvisor.co.id/Hotels-g3373423-...   \n",
       "1             Subagan  https://www.tripadvisor.co.id/Hotels-g3198489-...   \n",
       "2            Ambarita  https://www.tripadvisor.co.id/Hotels-g3187028-...   \n",
       "3            Tetebatu  https://www.tripadvisor.co.id/Hotels-g7106676-...   \n",
       "4         Tanjungsari  https://www.tripadvisor.co.id/Hotels-g3605986-...   \n",
       "5               Pujut  https://www.tripadvisor.co.id/Hotels-g3607401-...   \n",
       "6        Kuta Selatan  https://www.tripadvisor.co.id/Hotels-g12997472...   \n",
       "7        Kuta Selatan  https://www.tripadvisor.co.id/Hotels-g12997472...   \n",
       "8          Carangsari  https://www.tripadvisor.co.id/Hotels-g8456691-...   \n",
       "9   Provinsi Bengkulu  https://www.tripadvisor.co.id/Hotels-g2323384-...   \n",
       "10           Nungnung                                                NaN   \n",
       "11            Labuhan  https://www.tripadvisor.co.id/Hotels-g3320215-...   \n",
       "12    Sembalun Lawang  https://www.tripadvisor.co.id/Hotels-g12955895...   \n",
       "13          Cihideung  https://www.tripadvisor.co.id/Hotels-g13219542...   \n",
       "14             Bedulu  https://www.tripadvisor.co.id/Hotels-g11769423...   \n",
       "15             Bangli  https://www.tripadvisor.co.id/Hotels-g1025506-...   \n",
       "16          Pulau Kri  https://www.tripadvisor.co.id/Hotels-g15024679...   \n",
       "17             Keliki  https://www.tripadvisor.co.id/Hotels-g15239500...   \n",
       "18        Dangin Puri  https://www.tripadvisor.co.id/Hotels-g15239398...   \n",
       "19           Sukasada  https://www.tripadvisor.co.id/Hotels-g15212803...   \n",
       "20          Toyapakeh  https://www.tripadvisor.co.id/Hotels-g14115586...   \n",
       "21         Singakerta  https://www.tripadvisor.co.id/Hotels-g15880600...   \n",
       "22             Guwang                                                NaN   \n",
       "23    Singapadu Kaler  https://www.tripadvisor.co.id/Hotels-g20116867...   \n",
       "24         Batu Karas  https://www.tripadvisor.co.id/Hotels-g6677749-...   \n",
       "\n",
       "   Hotel Best Deal                                        Flight Link  \\\n",
       "0       Rp 306.908  https://www.tripadvisor.co.id/Flights-g3373423...   \n",
       "1       Rp 289.256  https://www.tripadvisor.co.id/Flights-g3198489...   \n",
       "2       Rp 257.553  https://www.tripadvisor.co.id/Flights-g3187028...   \n",
       "3       Rp 270.000  https://www.tripadvisor.co.id/Flights-g7106676...   \n",
       "4       Rp 498.832  https://www.tripadvisor.co.id/Flights-g3605986...   \n",
       "5     Rp 1.045.455  https://www.tripadvisor.co.id/Flights-g3607401...   \n",
       "6     Rp 3.437.868  https://www.tripadvisor.co.id/Flights-g1299747...   \n",
       "7     Rp 3.437.868  https://www.tripadvisor.co.id/Flights-g1299747...   \n",
       "8       Rp 991.736  https://www.tripadvisor.co.id/Flights-g8456691...   \n",
       "9       Rp 254.545  https://www.tripadvisor.co.id/Flights-g2323384...   \n",
       "10             NaN                                                NaN   \n",
       "11      Rp 836.621  https://www.tripadvisor.co.id/Flights-g3320215...   \n",
       "12      Rp 165.289  https://www.tripadvisor.co.id/Flights-g1295589...   \n",
       "13      Rp 119.884  https://www.tripadvisor.co.id/Flights-g1321954...   \n",
       "14      Rp 225.000  https://www.tripadvisor.co.id/Flights-g1176942...   \n",
       "15      Rp 400.000  https://www.tripadvisor.co.id/Flights-g1025506...   \n",
       "16      Rp 578.999  https://www.tripadvisor.co.id/Flights-g1502467...   \n",
       "17    Rp 4.062.500  https://www.tripadvisor.co.id/Flights-g1523950...   \n",
       "18    Rp 1.995.000  https://www.tripadvisor.co.id/Flights-g1523939...   \n",
       "19      Rp 400.413  https://www.tripadvisor.co.id/Flights-g1521280...   \n",
       "20      Rp 663.636  https://www.tripadvisor.co.id/Flights-g1411558...   \n",
       "21      Rp 661.107  https://www.tripadvisor.co.id/Flights-g1588060...   \n",
       "22             NaN                                                NaN   \n",
       "23      Rp 627.097  https://www.tripadvisor.co.id/Flights-g2011686...   \n",
       "24      Rp 208.333  https://www.tripadvisor.co.id/Flights-g6677749...   \n",
       "\n",
       "   Flight Best Deal  \n",
       "0               NaN  \n",
       "1      Rp 1.197.735  \n",
       "2      Rp 1.202.149  \n",
       "3      Rp 1.134.030  \n",
       "4      Rp 1.787.500  \n",
       "5      Rp 1.185.947  \n",
       "6      Rp 1.305.700  \n",
       "7      Rp 1.305.700  \n",
       "8      Rp 1.197.735  \n",
       "9      Rp 1.075.230  \n",
       "10              NaN  \n",
       "11              NaN  \n",
       "12     Rp 1.134.030  \n",
       "13              NaN  \n",
       "14     Rp 1.305.700  \n",
       "15     Rp 1.145.870  \n",
       "16              NaN  \n",
       "17     Rp 1.300.707  \n",
       "18     Rp 1.145.870  \n",
       "19     Rp 1.526.817  \n",
       "20     Rp 1.752.927  \n",
       "21     Rp 1.752.927  \n",
       "22              NaN  \n",
       "23     Rp 1.197.735  \n",
       "24              NaN  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv(\"dataaset_tahap3_4.csv\", index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "df1=pd.read_csv(\"dataaset_tahap3.csv\")\n",
    "df2=pd.read_csv(\"dataaset_tahap3_2.csv\")\n",
    "df3=pd.read_csv(\"dataaset_tahap3_3.csv\")\n",
    "df4=pd.read_csv(\"dataaset_tahap3_4.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "cek=pd.concat([df1, df2, df3, df4])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {
    "collapsed": 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>Travel Destination</th>\n",
       "      <th>Hotel Link</th>\n",
       "      <th>Hotel Best Deal</th>\n",
       "      <th>Flight Link</th>\n",
       "      <th>Flight Best Deal</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Bintan</td>\n",
       "      <td>https://www.tripadvisor.co.id/Hotels-g297718-B...</td>\n",
       "      <td>Rp 1.740.182</td>\n",
       "      <td>https://www.tripadvisor.co.id/Flights-g297718-...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Seminyak</td>\n",
       "      <td>https://www.tripadvisor.co.id/Hotels-g469404-S...</td>\n",
       "      <td>Rp 2.331.874</td>\n",
       "      <td>https://www.tripadvisor.co.id/Flights-g469404-...</td>\n",
       "      <td>Rp 1.305.700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Bali</td>\n",
       "      <td>https://www.tripadvisor.co.id/Hotels-g294226-B...</td>\n",
       "      <td>Rp 656.190</td>\n",
       "      <td>https://www.tripadvisor.co.id/Flights-g294226-...</td>\n",
       "      <td>Rp 1.145.870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Ubud</td>\n",
       "      <td>https://www.tripadvisor.co.id/Hotels-g297701-U...</td>\n",
       "      <td>Rp 2.865.927</td>\n",
       "      <td>https://www.tripadvisor.co.id/Flights-g297701-...</td>\n",
       "      <td>Rp 1.145.870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Jakarta</td>\n",
       "      <td>https://www.tripadvisor.co.id/Hotels-g294229-J...</td>\n",
       "      <td>Rp 360.563</td>\n",
       "      <td>https://www.tripadvisor.co.id/Flights-g294229-...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Toyapakeh</td>\n",
       "      <td>https://www.tripadvisor.co.id/Hotels-g14115586...</td>\n",
       "      <td>Rp 663.636</td>\n",
       "      <td>https://www.tripadvisor.co.id/Flights-g1411558...</td>\n",
       "      <td>Rp 1.752.927</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Singakerta</td>\n",
       "      <td>https://www.tripadvisor.co.id/Hotels-g15880600...</td>\n",
       "      <td>Rp 661.107</td>\n",
       "      <td>https://www.tripadvisor.co.id/Flights-g1588060...</td>\n",
       "      <td>Rp 1.752.927</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Guwang</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Singapadu Kaler</td>\n",
       "      <td>https://www.tripadvisor.co.id/Hotels-g20116867...</td>\n",
       "      <td>Rp 627.097</td>\n",
       "      <td>https://www.tripadvisor.co.id/Flights-g2011686...</td>\n",
       "      <td>Rp 1.197.735</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Batu Karas</td>\n",
       "      <td>https://www.tripadvisor.co.id/Hotels-g6677749-...</td>\n",
       "      <td>Rp 208.333</td>\n",
       "      <td>https://www.tripadvisor.co.id/Flights-g6677749...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>376 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Travel Destination                                         Hotel Link  \\\n",
       "0              Bintan  https://www.tripadvisor.co.id/Hotels-g297718-B...   \n",
       "1            Seminyak  https://www.tripadvisor.co.id/Hotels-g469404-S...   \n",
       "2                Bali  https://www.tripadvisor.co.id/Hotels-g294226-B...   \n",
       "3                Ubud  https://www.tripadvisor.co.id/Hotels-g297701-U...   \n",
       "4             Jakarta  https://www.tripadvisor.co.id/Hotels-g294229-J...   \n",
       "..                ...                                                ...   \n",
       "20          Toyapakeh  https://www.tripadvisor.co.id/Hotels-g14115586...   \n",
       "21         Singakerta  https://www.tripadvisor.co.id/Hotels-g15880600...   \n",
       "22             Guwang                                                NaN   \n",
       "23    Singapadu Kaler  https://www.tripadvisor.co.id/Hotels-g20116867...   \n",
       "24         Batu Karas  https://www.tripadvisor.co.id/Hotels-g6677749-...   \n",
       "\n",
       "   Hotel Best Deal                                        Flight Link  \\\n",
       "0     Rp 1.740.182  https://www.tripadvisor.co.id/Flights-g297718-...   \n",
       "1     Rp 2.331.874  https://www.tripadvisor.co.id/Flights-g469404-...   \n",
       "2       Rp 656.190  https://www.tripadvisor.co.id/Flights-g294226-...   \n",
       "3     Rp 2.865.927  https://www.tripadvisor.co.id/Flights-g297701-...   \n",
       "4       Rp 360.563  https://www.tripadvisor.co.id/Flights-g294229-...   \n",
       "..             ...                                                ...   \n",
       "20      Rp 663.636  https://www.tripadvisor.co.id/Flights-g1411558...   \n",
       "21      Rp 661.107  https://www.tripadvisor.co.id/Flights-g1588060...   \n",
       "22             NaN                                                NaN   \n",
       "23      Rp 627.097  https://www.tripadvisor.co.id/Flights-g2011686...   \n",
       "24      Rp 208.333  https://www.tripadvisor.co.id/Flights-g6677749...   \n",
       "\n",
       "   Flight Best Deal  \n",
       "0               NaN  \n",
       "1      Rp 1.305.700  \n",
       "2      Rp 1.145.870  \n",
       "3      Rp 1.145.870  \n",
       "4               NaN  \n",
       "..              ...  \n",
       "20     Rp 1.752.927  \n",
       "21     Rp 1.752.927  \n",
       "22              NaN  \n",
       "23     Rp 1.197.735  \n",
       "24              NaN  \n",
       "\n",
       "[376 rows x 5 columns]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cek"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "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>Travel Destination</th>\n",
       "      <th>Hotel Link</th>\n",
       "      <th>Hotel Best Deal</th>\n",
       "      <th>Flight Link</th>\n",
       "      <th>Flight Best Deal</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [Travel Destination, Hotel Link, Hotel Best Deal, Flight Link, Flight Best Deal]\n",
       "Index: []"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cek[cek.duplicated()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "cek=cek.drop_duplicates()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [],
   "source": [
    "cek.to_csv(\"datasetindo_hotel_flight.csv\")"
   ]
  },
  {
   "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"
  },
  "varInspector": {
   "cols": {
    "lenName": 16,
    "lenType": 16,
    "lenVar": 40
   },
   "kernels_config": {
    "python": {
     "delete_cmd_postfix": "",
     "delete_cmd_prefix": "del ",
     "library": "var_list.py",
     "varRefreshCmd": "print(var_dic_list())"
    },
    "r": {
     "delete_cmd_postfix": ") ",
     "delete_cmd_prefix": "rm(",
     "library": "var_list.r",
     "varRefreshCmd": "cat(var_dic_list()) "
    }
   },
   "types_to_exclude": [
    "module",
    "function",
    "builtin_function_or_method",
    "instance",
    "_Feature"
   ],
   "window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}