3-4 TOUR_RECOMMEND_GRADE.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 관광지 추천점수 산정 \n",
    "\n",
    "\n",
    "1. 관광지 추천점수 산정 로직 (5점 척도)\n",
    "- eco_rate : 바람지도/푸른컵 등 친환경 사업 여부 1 or 0\n",
    "- co2_rate : 건물에 대한 탄소 배출량 스케일\n",
    "- review_rate : 네이버 블로그 수 스케일\n",
    "- cluster_rate : 구역의 특성과 일치하는 정도\n",
    "- dist_rate : 선별된 F&B와의 거리\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import folium\n",
    "import numpy as np\n",
    "import os\n",
    "import random\n",
    "import re\n",
    "\n",
    "import warnings\n",
    "warnings.filterwarnings(action='ignore')\n",
    "\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "import plotly.express as px\n",
    "\n",
    "from haversine import haversine\n",
    "from sklearn.preprocessing import minmax_scale\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "data = pd.read_csv('data/관광지_유사도.csv', encoding='utf-8-sig') "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>cluster</th>\n",
       "      <th>CL_NM</th>\n",
       "      <th>CAT_PRE</th>\n",
       "      <th>name_PRE</th>\n",
       "      <th>lon</th>\n",
       "      <th>lat</th>\n",
       "      <th>price</th>\n",
       "      <th>blog_review_num_list</th>\n",
       "      <th>co2_max</th>\n",
       "      <th>similarity</th>\n",
       "      <th>type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>테마관광지</td>\n",
       "      <td>테마파크/공연/전시</td>\n",
       "      <td>감귤박물관</td>\n",
       "      <td>126.607428</td>\n",
       "      <td>33.271593</td>\n",
       "      <td>0.0</td>\n",
       "      <td>886.0</td>\n",
       "      <td>0.023639</td>\n",
       "      <td>0.403927</td>\n",
       "      <td>관광지</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4</td>\n",
       "      <td>공연전시</td>\n",
       "      <td>테마파크/공연/전시</td>\n",
       "      <td>건강과성박물관</td>\n",
       "      <td>126.346584</td>\n",
       "      <td>33.254847</td>\n",
       "      <td>0.0</td>\n",
       "      <td>542.0</td>\n",
       "      <td>0.507125</td>\n",
       "      <td>0.501137</td>\n",
       "      <td>관광지</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>공연전시</td>\n",
       "      <td>테마파크/공연/전시</td>\n",
       "      <td>고흐의정원</td>\n",
       "      <td>126.844086</td>\n",
       "      <td>33.373409</td>\n",
       "      <td>0.0</td>\n",
       "      <td>373.0</td>\n",
       "      <td>0.021090</td>\n",
       "      <td>0.290487</td>\n",
       "      <td>관광지</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>레저관광</td>\n",
       "      <td>레저/체험</td>\n",
       "      <td>김녕요트투어</td>\n",
       "      <td>126.737260</td>\n",
       "      <td>33.558248</td>\n",
       "      <td>0.0</td>\n",
       "      <td>490.0</td>\n",
       "      <td>0.282392</td>\n",
       "      <td>0.268219</td>\n",
       "      <td>관광지</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3</td>\n",
       "      <td>공연전시</td>\n",
       "      <td>테마파크/공연/전시</td>\n",
       "      <td>노형수퍼마켙</td>\n",
       "      <td>126.455168</td>\n",
       "      <td>33.464942</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2161.0</td>\n",
       "      <td>0.403384</td>\n",
       "      <td>0.508015</td>\n",
       "      <td>관광지</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>874</th>\n",
       "      <td>5</td>\n",
       "      <td>쇼핑</td>\n",
       "      <td>시장</td>\n",
       "      <td>한림민속오일시장</td>\n",
       "      <td>126.274504</td>\n",
       "      <td>33.419832</td>\n",
       "      <td>0.0</td>\n",
       "      <td>336.0</td>\n",
       "      <td>0.305565</td>\n",
       "      <td>0.137163</td>\n",
       "      <td>관광지</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>875</th>\n",
       "      <td>5</td>\n",
       "      <td>쇼핑</td>\n",
       "      <td>특산물</td>\n",
       "      <td>한마음한라봉</td>\n",
       "      <td>126.318030</td>\n",
       "      <td>33.466498</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.878523</td>\n",
       "      <td>0.152665</td>\n",
       "      <td>관광지</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>876</th>\n",
       "      <td>3</td>\n",
       "      <td>쇼핑</td>\n",
       "      <td>시장</td>\n",
       "      <td>함덕민속오일시장</td>\n",
       "      <td>126.667961</td>\n",
       "      <td>33.540253</td>\n",
       "      <td>0.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>0.024546</td>\n",
       "      <td>0.244736</td>\n",
       "      <td>관광지</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>877</th>\n",
       "      <td>5</td>\n",
       "      <td>쇼핑</td>\n",
       "      <td>특산물</td>\n",
       "      <td>현승이네농장</td>\n",
       "      <td>126.378786</td>\n",
       "      <td>33.463614</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.878523</td>\n",
       "      <td>0.126018</td>\n",
       "      <td>관광지</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>878</th>\n",
       "      <td>3</td>\n",
       "      <td>쇼핑</td>\n",
       "      <td>시장</td>\n",
       "      <td>화북종합시장</td>\n",
       "      <td>126.566377</td>\n",
       "      <td>33.521807</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.345273</td>\n",
       "      <td>0.224000</td>\n",
       "      <td>관광지</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>879 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     cluster  CL_NM     CAT_PRE  name_PRE         lon        lat  price  \\\n",
       "0          0  테마관광지  테마파크/공연/전시     감귤박물관  126.607428  33.271593    0.0   \n",
       "1          4   공연전시  테마파크/공연/전시   건강과성박물관  126.346584  33.254847    0.0   \n",
       "2          1   공연전시  테마파크/공연/전시     고흐의정원  126.844086  33.373409    0.0   \n",
       "3          1   레저관광       레저/체험    김녕요트투어  126.737260  33.558248    0.0   \n",
       "4          3   공연전시  테마파크/공연/전시    노형수퍼마켙  126.455168  33.464942    0.0   \n",
       "..       ...    ...         ...       ...         ...        ...    ...   \n",
       "874        5     쇼핑          시장  한림민속오일시장  126.274504  33.419832    0.0   \n",
       "875        5     쇼핑         특산물    한마음한라봉  126.318030  33.466498    0.0   \n",
       "876        3     쇼핑          시장  함덕민속오일시장  126.667961  33.540253    0.0   \n",
       "877        5     쇼핑         특산물    현승이네농장  126.378786  33.463614    0.0   \n",
       "878        3     쇼핑          시장    화북종합시장  126.566377  33.521807    0.0   \n",
       "\n",
       "     blog_review_num_list   co2_max  similarity type  \n",
       "0                   886.0  0.023639    0.403927  관광지  \n",
       "1                   542.0  0.507125    0.501137  관광지  \n",
       "2                   373.0  0.021090    0.290487  관광지  \n",
       "3                   490.0  0.282392    0.268219  관광지  \n",
       "4                  2161.0  0.403384    0.508015  관광지  \n",
       "..                    ...       ...         ...  ...  \n",
       "874                 336.0  0.305565    0.137163  관광지  \n",
       "875                   0.0  0.878523    0.152665  관광지  \n",
       "876                  54.0  0.024546    0.244736  관광지  \n",
       "877                   1.0  0.878523    0.126018  관광지  \n",
       "878                   6.0  0.345273    0.224000  관광지  \n",
       "\n",
       "[879 rows x 11 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "category = pd.read_csv('data/관광지_구역배정.csv', encoding='utf-8-sig') \n",
    "category = category[['name_PRE','CL_NM','CAT_PRE','PREICE_MAX']]\n",
    "category.columns = ['name_PRE','CL_NM','CAT_PRE','price']\n",
    "category.price[category.price.isna()] = 0\n",
    "\n",
    "data = pd.merge(left=data, right=category, how=\"left\", on = \"name_PRE\")\n",
    "data = data[['cluster', 'CL_NM', 'CAT_PRE','name_PRE', 'lon', 'lat','price','blog_review_num_list','co2_max', 'similarity']]\n",
    "data['type'] = \"관광지\"\n",
    "data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "heading_collapsed": true
   },
   "source": [
    "## 1. eco_rate : 친환경 사업 여부"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "hidden": true
   },
   "outputs": [],
   "source": [
    "baram = pd.read_csv('data/제주바람지도.csv', encoding='utf-8-sig')\n",
    "bluecup = pd.read_csv('data/제주푸른컵지도.csv', encoding='utf-8-sig')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "hidden": true
   },
   "outputs": [],
   "source": [
    "# 이름 전처리용\n",
    "def name_preprocessing(name):\n",
    "    name = name.replace(' (', '(').replace(') ', ')').strip()\n",
    "    name = name.replace('(주)','').replace(\"·\",\".\").lower()\n",
    "    name = re.sub('[\\(\\)㈜!@#$%^&*{}|:;\\'\\\"/><,~`+=_ ]','', name)\n",
    "    name = re.sub('[\\[.\\]]','',name)\n",
    "    return name.strip()\n",
    "\n",
    "#주소 전처리용\n",
    "def addr_preprocessing(addr):\n",
    "    addr = re.sub('제주 서귀포시','제주특별자치도 서귀포시',addr)\n",
    "    addr = re.sub('제주 제주시','제주특별자치도 제주시',addr)\n",
    "\n",
    "    while (addr.split()[-1][-1].isdigit() == False) : #상세주소 제거\n",
    "        if len(addr.split()) <= 3 : break\n",
    "            \n",
    "        addr = \" \".join(addr.split()[0:-1]) #하나빼기\n",
    "\n",
    "    addr = \"\".join(addr.split()) #공백다 없애기\n",
    "    return addr.strip() #앞뒤정리"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "hidden": 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>장소 이름</th>\n",
       "      <th>전화번호</th>\n",
       "      <th>인스타그램</th>\n",
       "      <th>상세설명</th>\n",
       "      <th>분류</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>용머리해안 기후변화홍보관</td>\n",
       "      <td>064.792.6077</td>\n",
       "      <td>NaN</td>\n",
       "      <td>기후변화에 따른 해수면 상승 현상 체감하기</td>\n",
       "      <td>환경교육&amp;체험</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>㈜푸른바이크쉐어링 자전거 학교 'BY 100'</td>\n",
       "      <td>064.721.0333</td>\n",
       "      <td>NaN</td>\n",
       "      <td>자전거 이용 문화 확산을 위한 교육부터 숙박 체험까지</td>\n",
       "      <td>환경교육&amp;체험</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>제주물사랑홍보관</td>\n",
       "      <td>064.710.4098</td>\n",
       "      <td>NaN</td>\n",
       "      <td>제주도 물의 역사, 문화, 순환과정 살펴보기</td>\n",
       "      <td>환경교육&amp;체험</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3R+센터 에코체험센터</td>\n",
       "      <td>064.722.9401</td>\n",
       "      <td>NaN</td>\n",
       "      <td>자원절약과 폐기물 자원화의 소중함 배우기</td>\n",
       "      <td>환경교육&amp;체험</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>CFI에너지미래관</td>\n",
       "      <td>064.720.7490</td>\n",
       "      <td>NaN</td>\n",
       "      <td>제주의 청정에너지를 오감으로 체험하기</td>\n",
       "      <td>환경교육&amp;체험</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>57</th>\n",
       "      <td>카페스물다섯</td>\n",
       "      <td>064.748.3334</td>\n",
       "      <td>25__twentyfive</td>\n",
       "      <td>에너지 소통 공감 카페에서 기후위기에 대해 생각해 봐요</td>\n",
       "      <td>제로플라스틱 실천</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>제주민박 소로소로</td>\n",
       "      <td>010.3679.9938</td>\n",
       "      <td>sorosoro_jeju</td>\n",
       "      <td>다양한 다회용 어메니티가 준비되어 있어요</td>\n",
       "      <td>제로플라스틱 실천</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>한라서적타운</td>\n",
       "      <td>064.722.7722</td>\n",
       "      <td>hallabooktown</td>\n",
       "      <td>서점 안에 제로웨이스트 소개 코너가 있어요</td>\n",
       "      <td>제로플라스틱 실천</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>수놀음알뜰가게 요디</td>\n",
       "      <td>064.752.5382</td>\n",
       "      <td>NaN</td>\n",
       "      <td>쓰지 않는 물건은 기증하고, 자원 재순환을 실천해요</td>\n",
       "      <td>제로플라스틱 실천</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>제주재사용나눔가게&amp;착한자전거</td>\n",
       "      <td>064.725.8219</td>\n",
       "      <td>jeju_reuse_store</td>\n",
       "      <td>쓰지 않는 물건은 기증하고, 자원 재순환을 실천해요</td>\n",
       "      <td>제로플라스틱 실천</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>62 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                        장소 이름           전화번호             인스타그램  \\\n",
       "0               용머리해안 기후변화홍보관   064.792.6077               NaN   \n",
       "1   ㈜푸른바이크쉐어링 자전거 학교 'BY 100'   064.721.0333               NaN   \n",
       "2                    제주물사랑홍보관   064.710.4098               NaN   \n",
       "3                3R+센터 에코체험센터   064.722.9401               NaN   \n",
       "4                   CFI에너지미래관   064.720.7490               NaN   \n",
       "..                        ...            ...               ...   \n",
       "57                     카페스물다섯   064.748.3334    25__twentyfive   \n",
       "58                  제주민박 소로소로  010.3679.9938     sorosoro_jeju   \n",
       "59                     한라서적타운   064.722.7722     hallabooktown   \n",
       "60                 수놀음알뜰가게 요디   064.752.5382               NaN   \n",
       "61            제주재사용나눔가게&착한자전거   064.725.8219  jeju_reuse_store   \n",
       "\n",
       "                              상세설명         분류  \n",
       "0          기후변화에 따른 해수면 상승 현상 체감하기    환경교육&체험  \n",
       "1    자전거 이용 문화 확산을 위한 교육부터 숙박 체험까지    환경교육&체험  \n",
       "2         제주도 물의 역사, 문화, 순환과정 살펴보기    환경교육&체험  \n",
       "3           자원절약과 폐기물 자원화의 소중함 배우기    환경교육&체험  \n",
       "4             제주의 청정에너지를 오감으로 체험하기    환경교육&체험  \n",
       "..                             ...        ...  \n",
       "57  에너지 소통 공감 카페에서 기후위기에 대해 생각해 봐요  제로플라스틱 실천  \n",
       "58          다양한 다회용 어메니티가 준비되어 있어요  제로플라스틱 실천  \n",
       "59         서점 안에 제로웨이스트 소개 코너가 있어요  제로플라스틱 실천  \n",
       "60    쓰지 않는 물건은 기증하고, 자원 재순환을 실천해요  제로플라스틱 실천  \n",
       "61    쓰지 않는 물건은 기증하고, 자원 재순환을 실천해요  제로플라스틱 실천  \n",
       "\n",
       "[62 rows x 5 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "baram"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "hidden": true
   },
   "outputs": [],
   "source": [
    "baram.columns = ['area_name', 'tel', 'instagram', 'detail', 'category']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "hidden": 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>cluster</th>\n",
       "      <th>CL_NM</th>\n",
       "      <th>CAT_PRE</th>\n",
       "      <th>name_PRE</th>\n",
       "      <th>lon</th>\n",
       "      <th>lat</th>\n",
       "      <th>price</th>\n",
       "      <th>blog_review_num_list</th>\n",
       "      <th>co2_max</th>\n",
       "      <th>similarity</th>\n",
       "      <th>type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>테마관광지</td>\n",
       "      <td>테마파크/공연/전시</td>\n",
       "      <td>감귤박물관</td>\n",
       "      <td>126.607428</td>\n",
       "      <td>33.271593</td>\n",
       "      <td>0.0</td>\n",
       "      <td>886.0</td>\n",
       "      <td>0.023639</td>\n",
       "      <td>0.403927</td>\n",
       "      <td>관광지</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4</td>\n",
       "      <td>공연전시</td>\n",
       "      <td>테마파크/공연/전시</td>\n",
       "      <td>건강과성박물관</td>\n",
       "      <td>126.346584</td>\n",
       "      <td>33.254847</td>\n",
       "      <td>0.0</td>\n",
       "      <td>542.0</td>\n",
       "      <td>0.507125</td>\n",
       "      <td>0.501137</td>\n",
       "      <td>관광지</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>공연전시</td>\n",
       "      <td>테마파크/공연/전시</td>\n",
       "      <td>고흐의정원</td>\n",
       "      <td>126.844086</td>\n",
       "      <td>33.373409</td>\n",
       "      <td>0.0</td>\n",
       "      <td>373.0</td>\n",
       "      <td>0.021090</td>\n",
       "      <td>0.290487</td>\n",
       "      <td>관광지</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>레저관광</td>\n",
       "      <td>레저/체험</td>\n",
       "      <td>김녕요트투어</td>\n",
       "      <td>126.737260</td>\n",
       "      <td>33.558248</td>\n",
       "      <td>0.0</td>\n",
       "      <td>490.0</td>\n",
       "      <td>0.282392</td>\n",
       "      <td>0.268219</td>\n",
       "      <td>관광지</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3</td>\n",
       "      <td>공연전시</td>\n",
       "      <td>테마파크/공연/전시</td>\n",
       "      <td>노형수퍼마켙</td>\n",
       "      <td>126.455168</td>\n",
       "      <td>33.464942</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2161.0</td>\n",
       "      <td>0.403384</td>\n",
       "      <td>0.508015</td>\n",
       "      <td>관광지</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>874</th>\n",
       "      <td>5</td>\n",
       "      <td>쇼핑</td>\n",
       "      <td>시장</td>\n",
       "      <td>한림민속오일시장</td>\n",
       "      <td>126.274504</td>\n",
       "      <td>33.419832</td>\n",
       "      <td>0.0</td>\n",
       "      <td>336.0</td>\n",
       "      <td>0.305565</td>\n",
       "      <td>0.137163</td>\n",
       "      <td>관광지</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>875</th>\n",
       "      <td>5</td>\n",
       "      <td>쇼핑</td>\n",
       "      <td>특산물</td>\n",
       "      <td>한마음한라봉</td>\n",
       "      <td>126.318030</td>\n",
       "      <td>33.466498</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.878523</td>\n",
       "      <td>0.152665</td>\n",
       "      <td>관광지</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>876</th>\n",
       "      <td>3</td>\n",
       "      <td>쇼핑</td>\n",
       "      <td>시장</td>\n",
       "      <td>함덕민속오일시장</td>\n",
       "      <td>126.667961</td>\n",
       "      <td>33.540253</td>\n",
       "      <td>0.0</td>\n",
       "      <td>54.0</td>\n",
       "      <td>0.024546</td>\n",
       "      <td>0.244736</td>\n",
       "      <td>관광지</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>877</th>\n",
       "      <td>5</td>\n",
       "      <td>쇼핑</td>\n",
       "      <td>특산물</td>\n",
       "      <td>현승이네농장</td>\n",
       "      <td>126.378786</td>\n",
       "      <td>33.463614</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.878523</td>\n",
       "      <td>0.126018</td>\n",
       "      <td>관광지</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>878</th>\n",
       "      <td>3</td>\n",
       "      <td>쇼핑</td>\n",
       "      <td>시장</td>\n",
       "      <td>화북종합시장</td>\n",
       "      <td>126.566377</td>\n",
       "      <td>33.521807</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.345273</td>\n",
       "      <td>0.224000</td>\n",
       "      <td>관광지</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>879 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     cluster  CL_NM     CAT_PRE  name_PRE         lon        lat  price  \\\n",
       "0          0  테마관광지  테마파크/공연/전시     감귤박물관  126.607428  33.271593    0.0   \n",
       "1          4   공연전시  테마파크/공연/전시   건강과성박물관  126.346584  33.254847    0.0   \n",
       "2          1   공연전시  테마파크/공연/전시     고흐의정원  126.844086  33.373409    0.0   \n",
       "3          1   레저관광       레저/체험    김녕요트투어  126.737260  33.558248    0.0   \n",
       "4          3   공연전시  테마파크/공연/전시    노형수퍼마켙  126.455168  33.464942    0.0   \n",
       "..       ...    ...         ...       ...         ...        ...    ...   \n",
       "874        5     쇼핑          시장  한림민속오일시장  126.274504  33.419832    0.0   \n",
       "875        5     쇼핑         특산물    한마음한라봉  126.318030  33.466498    0.0   \n",
       "876        3     쇼핑          시장  함덕민속오일시장  126.667961  33.540253    0.0   \n",
       "877        5     쇼핑         특산물    현승이네농장  126.378786  33.463614    0.0   \n",
       "878        3     쇼핑          시장    화북종합시장  126.566377  33.521807    0.0   \n",
       "\n",
       "     blog_review_num_list   co2_max  similarity type  \n",
       "0                   886.0  0.023639    0.403927  관광지  \n",
       "1                   542.0  0.507125    0.501137  관광지  \n",
       "2                   373.0  0.021090    0.290487  관광지  \n",
       "3                   490.0  0.282392    0.268219  관광지  \n",
       "4                  2161.0  0.403384    0.508015  관광지  \n",
       "..                    ...       ...         ...  ...  \n",
       "874                 336.0  0.305565    0.137163  관광지  \n",
       "875                   0.0  0.878523    0.152665  관광지  \n",
       "876                  54.0  0.024546    0.244736  관광지  \n",
       "877                   1.0  0.878523    0.126018  관광지  \n",
       "878                   6.0  0.345273    0.224000  관광지  \n",
       "\n",
       "[879 rows x 11 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "hidden": true,
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "eco_list = []\n",
    "        \n",
    "#이름이 일치하는 경우\n",
    "name_list = list(map(lambda x : name_preprocessing(x), baram['area_name']))\n",
    "set(eco_list).union(set(data[data['name_PRE'].isin(name_list)].index))\n",
    "\n",
    "#포함되는 경우\n",
    "for i in range(0, len(name_list)) :\n",
    "    idx = data[data['name_PRE'].str.contains(name_list[i])].index\n",
    "    if len(idx) >0 :\n",
    "        eco_list.append(idx.values[0])\n",
    "\n",
    "for i in range(0, len(data)) :\n",
    "    if len(baram[baram['area_name'].str.contains(data.name_PRE[i])]) >0 : \n",
    "        eco_list.append(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "hidden": true,
    "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>이름</th>\n",
       "      <th>설명</th>\n",
       "      <th>분류</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>그레이그로브</td>\n",
       "      <td>푸른컵 10% 할인</td>\n",
       "      <td>푸른컵 카페</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>까페 제주동네</td>\n",
       "      <td>푸른컵 500원 할인</td>\n",
       "      <td>푸른컵 카페</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>돌랑돌랑상점 제주공항점</td>\n",
       "      <td>푸른컵 20% 할인</td>\n",
       "      <td>푸른컵 카페</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>더 리트리브</td>\n",
       "      <td>푸른컵 20% 할인</td>\n",
       "      <td>푸른컵 카페</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>라임오렌지카페앤플라워</td>\n",
       "      <td>푸른컵 500원 할인</td>\n",
       "      <td>푸른컵 카페</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             이름           설명      분류\n",
       "0        그레이그로브   푸른컵 10% 할인  푸른컵 카페\n",
       "1       까페 제주동네  푸른컵 500원 할인  푸른컵 카페\n",
       "2  돌랑돌랑상점 제주공항점   푸른컵 20% 할인  푸른컵 카페\n",
       "3        더 리트리브   푸른컵 20% 할인  푸른컵 카페\n",
       "4   라임오렌지카페앤플라워  푸른컵 500원 할인  푸른컵 카페"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bluecup.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "hidden": true
   },
   "outputs": [],
   "source": [
    "#이름이 일치하는 경우\n",
    "name_list = list(map(lambda x : name_preprocessing(x), bluecup['이름']))\n",
    "set(eco_list).union(set(data[data['name_PRE'].isin(name_list)].index))\n",
    "\n",
    "# 초함되는 경우\n",
    "for i in range(0, len(name_list)) :\n",
    "    idx = data[data['name_PRE'].str.contains(name_list[i])].index\n",
    "    if len(idx) >0 :\n",
    "        eco_list.append(idx.values[0])\n",
    "\n",
    "for i in range(0, len(data)) :\n",
    "    if len(bluecup[bluecup['이름'].str.contains(data.name_PRE[i])]) >0 : \n",
    "        eco_list.append(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "hidden": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[250, 827, 23, 250, 827, 856, 311, 311, 311]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "eco_list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "hidden": true,
    "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>cluster</th>\n",
       "      <th>CL_NM</th>\n",
       "      <th>CAT_PRE</th>\n",
       "      <th>name_PRE</th>\n",
       "      <th>lon</th>\n",
       "      <th>lat</th>\n",
       "      <th>price</th>\n",
       "      <th>blog_review_num_list</th>\n",
       "      <th>co2_max</th>\n",
       "      <th>similarity</th>\n",
       "      <th>type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>4</td>\n",
       "      <td>자연</td>\n",
       "      <td>자연</td>\n",
       "      <td>용머리해안</td>\n",
       "      <td>126.314631</td>\n",
       "      <td>33.233482</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4825.0</td>\n",
       "      <td>0.005309</td>\n",
       "      <td>0.139690</td>\n",
       "      <td>관광지</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>311</th>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>레저/체험</td>\n",
       "      <td>빠우사</td>\n",
       "      <td>126.711909</td>\n",
       "      <td>33.457740</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.007189</td>\n",
       "      <td>0.089769</td>\n",
       "      <td>관광지</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>856</th>\n",
       "      <td>3</td>\n",
       "      <td>쇼핑</td>\n",
       "      <td>특산물</td>\n",
       "      <td>이제주숍</td>\n",
       "      <td>126.540713</td>\n",
       "      <td>33.499434</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>1.241532</td>\n",
       "      <td>0.168371</td>\n",
       "      <td>관광지</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>250</th>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>레저/체험</td>\n",
       "      <td>물뫼힐링팜</td>\n",
       "      <td>126.396556</td>\n",
       "      <td>33.464249</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.366539</td>\n",
       "      <td>0.147966</td>\n",
       "      <td>관광지</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>827</th>\n",
       "      <td>5</td>\n",
       "      <td>쇼핑</td>\n",
       "      <td>기념품/소품</td>\n",
       "      <td>베리제주</td>\n",
       "      <td>126.336327</td>\n",
       "      <td>33.466620</td>\n",
       "      <td>0.0</td>\n",
       "      <td>431.0</td>\n",
       "      <td>0.118939</td>\n",
       "      <td>0.257585</td>\n",
       "      <td>관광지</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     cluster CL_NM CAT_PRE name_PRE         lon        lat  price  \\\n",
       "23         4    자연      자연    용머리해안  126.314631  33.233482    0.0   \n",
       "311        1   NaN   레저/체험      빠우사  126.711909  33.457740    0.0   \n",
       "856        3    쇼핑     특산물     이제주숍  126.540713  33.499434    0.0   \n",
       "250        5   NaN   레저/체험    물뫼힐링팜  126.396556  33.464249    0.0   \n",
       "827        5    쇼핑  기념품/소품     베리제주  126.336327  33.466620    0.0   \n",
       "\n",
       "     blog_review_num_list   co2_max  similarity type  \n",
       "23                 4825.0  0.005309    0.139690  관광지  \n",
       "311                   8.0  0.007189    0.089769  관광지  \n",
       "856                  16.0  1.241532    0.168371  관광지  \n",
       "250                  15.0  0.366539    0.147966  관광지  \n",
       "827                 431.0  0.118939    0.257585  관광지  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#중복제거 및 처리\n",
    "eco_list = set(eco_list)\n",
    "data.iloc[list(eco_list)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "hidden": true
   },
   "outputs": [],
   "source": [
    "data['eco_YN'] = 0\n",
    "data['eco_YN'].iloc[list(eco_list)] = 1"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "heading_collapsed": true
   },
   "source": [
    "## 2. co2_rate : 건물에 대한 탄소배출량 스케일 점수"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "hidden": true
   },
   "outputs": [],
   "source": [
    "data['co2_rate'] = (1 - minmax_scale(data['co2_max'],copy=True)).tolist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "hidden": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "666    0.000000\n",
       "426    0.557412\n",
       "367    0.557412\n",
       "624    0.734474\n",
       "862    0.772791\n",
       "         ...   \n",
       "690    0.999996\n",
       "216    1.000000\n",
       "513    1.000000\n",
       "361    1.000000\n",
       "154    1.000000\n",
       "Name: co2_rate, Length: 879, dtype: float64"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['co2_rate'].sort_values()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "hidden": true,
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:xlabel='co2_rate', ylabel='Density'>"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAX4AAAEHCAYAAACp9y31AAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuNCwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8QVMy6AAAACXBIWXMAAAsTAAALEwEAmpwYAAAdZ0lEQVR4nO3dfXRcd33n8fdnRho92HIS24pxHhwDmxCy0DhBDbChS0qgTVNKCIVtIYEsm13TLWxh29OSsj0tnNJz0i4Udk9bioEcTMpDgaQkUJrFdQlZCiQ4EBzniQQI2STGTyHIlmSNZua7f8wdWZb1MJLmztXofl7n6MzMfZj7vXr4zk/f+7u/nyICMzPLj0LWAZiZWXs58ZuZ5YwTv5lZzjjxm5nljBO/mVnOdGUdQDPWr18fmzdvzjoMM7OOcvfddx+MiMHpyzsi8W/evJldu3ZlHYaZWUeR9OOZlrvUY2aWM078ZmY5k3ril1SU9F1JX0per5W0Q9LDyeMpacdgZmbHtKPF/3bggSmvrwN2RsTZwM7ktZmZtUmqiV/SGcCvAh+dsvgKYHvyfDvw6jRjMDOz46Xd4v8g8AdAbcqyDRGxFyB5PHWmHSVtlbRL0q4DBw6kHKaZWX6klvglvRLYHxF3L2b/iNgWEUMRMTQ4eEI3VDMzW6Q0+/FfDLxK0uVAL7BG0t8B+yRtjIi9kjYC+1OMwczMpkmtxR8RfxgRZ0TEZuA3gX+JiKuBW4Frks2uAW5JKwYzMztRFnfuXg98VtK1wGPA6zKIwcysLT5152MzLn/DCze1OZJj2pL4I+J24Pbk+SHg0nYc18zMTuQ7d83McsaJ38wsZ5z4zcxyxonfzCxnnPjNzHLGid/MLGec+M3McsaJ38wsZ5z4zcxyxonfzCxnnPjNzHLGid/MLGec+M3McsaJ38wsZ5z4zcxyxonfzCxnnPjNzHImtcQvqVfSXZK+J+k+Se9Jlr9b0hOS7km+Lk8rBjMzO1GaUy+OAy+LiCOSuoGvS/qnZN0HIuJ9KR7bzMxmkVrij4gAjiQvu5OvSOt4ZmbWnFRr/JKKku4B9gM7IuLOZNXbJO2WdIOkU2bZd6ukXZJ2HThwIM0wzcxyJdXEHxHViNgCnAFcJOl5wIeAZwNbgL3A+2fZd1tEDEXE0ODgYJphmpnlSlt69UTE08DtwGURsS/5QKgBHwEuakcMZmZWl2avnkFJJyfP+4CXAw9K2jhlsyuBPWnFYGZmJ0qzV89GYLukIvUPmM9GxJck3ShpC/ULvY8Cb0kxBjMzmybNXj27gQtmWP7GtI5pZmbz8527ZmY548RvZpYzTvxmZjnjxG9mljNO/GZmOePEb2aWM078ZmY548RvZpYzTvxmZjnjxG9mljNO/GZmOePEb2aWM078ZmY548RvZpYzTvxmZjnjxG9mljNO/GZmOZPmnLu9ku6S9D1J90l6T7J8raQdkh5OHk9JKwYzMztRmi3+ceBlEXE+sAW4TNKLgOuAnRFxNrAzeW1mZm2SWuKPuiPJy+7kK4ArgO3J8u3Aq9OKwczMTpRqjV9SUdI9wH5gR0TcCWyIiL0AyeOpacZgZmbHSzXxR0Q1IrYAZwAXSXpes/tK2ippl6RdBw4cSC1GM7O8aUuvnoh4GrgduAzYJ2kjQPK4f5Z9tkXEUEQMDQ4OtiNMM7NcSLNXz6Ckk5PnfcDLgQeBW4Frks2uAW5JKwYzMztRV4rvvRHYLqlI/QPmsxHxJUnfBD4r6VrgMeB1KcZgZmbTpJb4I2I3cMEMyw8Bl6Z1XDMzm5vv3DUzyxknfjOznHHiNzPLGSd+M7OcceI3M8sZJ34zs5xx4jcza4OIYHyimnUYgBO/mVnqahHc/J0nuP62B5mo1rIOx4nfzCxtt+35CXc/9lPGKzVGxitZh+PEb2aWploE//rIQU7u6wZgZDz7co8Tv5lZisbKVQI4c20/ACNlt/jNzFa0sXK9hT840APAqBO/mdnKNpr05Fm/ugS41GNmtuKNJS38tf0lCnKpx8xsxRtNSj39PV30lbrc4jczW+kmE3+pyKpS0TV+M7OVbmyiioDe7iKrerrcj9/MbKUbLVfp7S5SkFhVKjJSXsGlHklnSvqqpAck3Sfp7cnyd0t6QtI9ydflacVgZpa1sXKF/lIRqNf5l0OLP83J1ivA70XEdyQNAHdL2pGs+0BEvC/FY5uZLQuj5Sp9SeJfVepirFylFpFpTGlOtr4X2Js8PyzpAeD0tI5nZrYcjU1UJ1v8q3qKBMdu6spKW2r8kjYDFwB3JoveJmm3pBsknTLLPlsl7ZK068CBA+0I08ys5UbLVfq6j7X4Ifu+/KknfkmrgZuAd0TEMPAh4NnAFur/Ebx/pv0iYltEDEXE0ODgYNphmpmlYqxcpT9J+P099Q+ArPvyp5r4JXVTT/qfjIibASJiX0RUI6IGfAS4KM0YzMyyUq0FRyeOr/FD9uP1pNmrR8DHgAci4i+nLN84ZbMrgT1pxWBmlqXhsQkCptT4k8SfcYs/zV49FwNvBO6VdE+y7F3A6yVtAQJ4FHhLijGYmWXm6bEJgMkaf+MDIOsaf5q9er4OaIZVX07rmGZmy8nTo2WAyRp/d7FAqauQeV9+37lrZpaSp0frLf5GSx+gt6vAeCXbeXebSvySbpL0q5L8QWFm1qSnx+ot/r4pib/UKYmfehfMNwAPS7pe0rkpxmRmtiJMtvi7j0/8E9UOSPwR8c8RcRVwIfULsjskfUPSm5Mum2ZmNk0j8fdObfEXix3T4kfSOuA/Av8Z+C7wv6h/EOyYYzczs9w6Ml6h1FWgoGP9XEpdopxx4m+qV4+km4FzgRuBX0vG4QH4e0m70grOzKyTjZYr9HQd374udRX56chERhHVNdud86MRcVw3TEk9ETEeEUMpxGVm1vFGxquUiscn/p5igXIn1PiB986w7JutDMTMbKWZucVfWN6lHknPoD6Ucp+kCzh2Q9YaoD/l2MzMOtrIeJVSpyV+4JepX9A9A/jLKcsPUx9+wczMZjFSrsyY+KsRlCu1E9a1y5yJPyK2A9sl/XpE3NSmmMzMVoSR8crkcA0NjZr/WPnE/wbaZb5Sz9UR8XfAZkm/O3391FE3zczseKPlKif3l45b1qj5j5QrnNSfzW1Q85V6ViWPq9MOxMxspRkZP7HU0528znJM/vlKPR9OHt/TnnDMzFaGiGC0XKVnhu6cUP9vICvNDtL2F5LWSOqWtFPSQUlXpx2cmVmnGq/UqNRixou7kO30i81eWfilZL7cVwKPA+cAv59aVGZmHa7Rop+pH399fXalnmYTf+MKxOXApyPiqZTiMTNbERqTrZS6isctb/TqGVnupR7gi5IeBIaAnZIGgaNz7SDpTElflfSApPskvT1ZvlbSDkkPJ4+nLO0UzMyWn0aLf7ZSz9hyb/FHxHXAi4GhiJgARoAr5tmtAvxeRDwXeBHwVknnAdcBOyPibGBn8trMbEVpzKs7vdTTk/wHkGWNfyFz7j6Xen/+qft8YraNkxE89ybPD0t6gPrwD1cAlySbbQduB965gDjMzJa9yVJPcXp3zvrIN8u2O2eDpBuBZwP3AI2PqWCOxD9t/83ABcCdwIbGsM4RsVfSqbPssxXYCrBp06ZmDmNmtmw0WvQ93ccn/q5CgaKUaXfOZlv8Q8B5ERELPYCk1cBNwDsiYlhTJiSYS0RsA7YBDA0NLfi4ZmZZarTop7f4oV7nX/b9+IE9wDMW+ubJtIw3AZ+MiJuTxfskbUzWbwT2L/R9zcyWu5FZLu42ljVKQVlotsW/Hrhf0l3AeGNhRLxqth1Ub9p/DHhg2pg+twLXANcnj7csNGgzs+VudLxxcbd4wrpSMdsWf7OJ/92LeO+LgTcC90q6J1n2LuoJ/7OSrgUeA163iPc2M1vWRsYrSNBdPLG8XS/1LPMWf0R8TdJZwNkR8c+S+oETP8aO3+frHJu4ZbpLFxammVlnGSlXWVXqYqbrmqWuwvK/gUvSfwE+D3w4WXQ68IWUYjIz63ij5Qr9pZnbxz0Zt/ibvbj7Vuqlm2GAiHgYmLEbppmZ1btzruqZuajSXSww2gGDtI1HRLnxIrmJy10szcxmMX+Lf/kn/q9Jehf1SddfAXwO+GJ6YZmZdbYj4xVWlWZu8ddr/Mu/1HMdcAC4F3gL8GXgj9IKysys042Wq6zqmbnF3+jOuYh7Ylui2V49NUlfAL4QEQfSDcnMrPONjFc4c23/jOtKXQWqtaBcrc3Yzz9tc7b4VfduSQeBB4GHJB2Q9MftCc/MrDONlqusmqXGPzkZS0YXeOcr9byDem+en4+IdRGxFnghcLGk/552cGZmnWpkvEL/LDX+xlDNWdX550v8bwJeHxE/aiyIiB8CVyfrzMxsmoio38A1S42/O+MJ1+dL/N0RcXD6wqTO3z3D9mZmuTdeqVGtxaz9+Hu6lnfiLy9ynZlZbjUS+uzdOev/CYxmNELnfL16zpc0PMNyAb0pxGNm1vEaQy73l4pMVE/sslmarPFn0+KfM/FHRPv7GZmZdbjJFn9PF0+PTpywvjRZ41+eF3fNzGyBjkxp8c+ktMxr/GZmtkCNlvzqeS7uZjULlxO/mVmLNSZan60f/3LvzmlmZgvUaPHP1o+/WFCmA7Wllvgl3SBpv6Q9U5a9W9ITku5Jvi5P6/hmZllp9NaZrcUPsKpUZGwFtvg/Dlw2w/IPRMSW5OvLKR7fzCwTjdr9bC1+qH8ojCzTsXoWLSLuAJ5K6/3NzJar0WSi9b7uuRJ/MVfdOd8maXdSCjolg+ObmaVqronWG/p7unJzcfdDwLOBLcBe4P2zbShpq6RdknYdOOApAMysc8w17WLDqry0+CNiX0RUI6IGfAS4aI5tt0XEUEQMDQ4Oti9IM7Mlmmui9YYVWeOfiaSNU15eCeyZbVszs05VH4t/7hZ/ljX+pqZeXAxJnwYuAdZLehz4E+ASSVuAAB6lPn+vmdmKMlKuzNviX9VTzKzGn1rij4jXz7D4Y2kdz8xsuRgtV1m3qjTnNv2l/FzcNTNb8UbGK/TP1+IvFRkpV4g4cdjmtDnxm5m12FwTrTf0lbqIgKMTtTZFdYwTv5lZix2ZY6L1hsZdvVlc4HXiNzNroYhgtFyddUjmhsYHQxZ1fid+M7MWaky03j/HOD3AZCkoixE6nfjNzFpovonWG/pKjVKPW/xmZh1tZJ5pFxsa/fxHM7h714nfzKyFRiYnYZmvxu9Sj5nZitAYf6eZsXrAvXrMzDre5LSLTYzOWd/epR4zs44230TrDf2u8ZuZrQzzTbTe0JidyzV+M7MOd6xXz9wt/mJB9HYXXOoxM+t0I0kin+/OXaj39ffFXTOzDteYaL23e/702t9TzGQWLid+M7MWGilX6e8uzjnResPqnm6OjLvFb2bW0Q4fnWCgt7upbQd6ujhy1InfzKyjDY9VOKmvucS/ureLw+MTKUd0otQSv6QbJO2XtGfKsrWSdkh6OHk8Ja3jm5llYfjoBGv6mpvVdvUKbPF/HLhs2rLrgJ0RcTawM3ltZrZiDB+dYE2TpZ7VvV0rq8YfEXcAT01bfAWwPXm+HXh1Wsc3M8vCz8YmWNNkqWegt4vDK6zFP5MNEbEXIHk8dbYNJW2VtEvSrgMHDrQtQDOzpRgeq7Cmt7lSz0BPF+OVGuVKe+fdXbYXdyNiW0QMRcTQ4OBg1uGYmc2rVgsOH22+xd+4yWukzeWedif+fZI2AiSP+9t8fDOz1IyUK9SCBdT469u1u9zT7sR/K3BN8vwa4JY2H9/MLDXDSQJvujtn0uJvd5fONLtzfhr4JvAcSY9Luha4HniFpIeBVySvzcxWhOGxegJvtjvnQHItoN1dOpuLbhEi4vWzrLo0rWOamWVpMvE3W+pJWvzt7tKZWuI3M8ubL+3eC8C//uAQjx4anXf71b3ZJP5l26vHzKzTjCVDMjcmWZlPo9Sz0i/umpmtWGMT9cTfzJDMAAM9+ejVY2a2Yh2dTPzNtfh7uwsUC+LISunVY2aWN0cnqvR0FSg0MRY/gKRMBmpz4jcza5GxiVrT9f2G1T1dHPbFXTOzznR0otp0madhoNctfjOzjjW2iMS/uqf9I3Q68ZuZtcjRiSp9TfboachiTH4nfjOzFllMi3+gt/0Trjvxm5m1yNGJKn0ll3rMzHKhVgvGJ2qLu7jrfvxmZp3n8HiFoPnhGhpW93RxdKLGRLV9s3A58ZuZtcBPR8oAiyr1QHuHZnbiNzNrgX3DR4Hmh2RuyGKETid+M7MW2Hd4HKDpidYbGrN1PT3avjq/E7+ZWQvsT1r8Awts8a9fXQLg0Mh4y2OaTSYTsUh6FDgMVIFKRAxlEYeZWavsGz5Kd1FND8ncsG5VDwCHjpTTCGtGWc7A9YsRcTDD45uZtcy+4XEGertRkyNzNqxLWvwHj7Svxe9Sj5lZC+wbPrrg+j7Ue/WUugocGmlfiz+rxB/AVyTdLWlrRjGYmbXM/sPjC67vQ31M/sHVPW1t8WdV6rk4Ip6UdCqwQ9KDEXHH1A2SD4StAJs2bcoiRjOzpkQE+4aPctqZJy9q/3WrS22t8WfS4o+IJ5PH/cA/ABfNsM22iBiKiKHBwcF2h2hm1rQj4xVGy1XW9C28xQ+wblWprb162p74Ja2SNNB4DvwSsKfdcZiZtcq+4XrSHlhEjR9g/eoeDh5e2b16NgD/kFz57gI+FRG3ZRCHmVlLLLYPf8O61T0cGhknIhbcK2gx2p74I+KHwPntPq6ZWVr2HV7ccA0N61eXmKgGw0crk3fypsndOc3Mlmj/8OKGa2ho9OU/1KaePU78ZmZLtG94nFWlIj0LHJK5Yf3q5O7dNvXld+I3M1uix54a5bST+xa9f2PYhoOH3eI3M+sID+wd5rkb1yx6/8ZAbQfd4jczW/6eHi3zxNNjnHfa4hP/Katc4zcz6xj37x0G4LwltPi7iwVO6e9u2927TvxmZktw/5P1xL+UUg/U+/IfcI3fzGz5u3/vMKcO9DA40LOk99m8rp8fHRxpUVRzc+I3M1uC+58cXlJ9v+GcDQP84MARypVaC6KamxO/mdkijVeqPLL/yJLq+w3nbBigUgsePZR+q9+J38xskb7z46ep1ILnn37Skt/rnA0DADz0k8NLfq/5OPGbmS3Szd95nFWlIi99ztKHjn/W4CqKBfH9fU78ZmbL0mi5wpfv3cvlz99If2np4132dhfZvK7fLX4zs+XqK/ftY6Rc5ddfcEbL3vOcDQM8vP9Iy95vNk78ZmYLVK7U2HbHDzlzbR8XbV7bsvc9Z8MAjx4a4ehEtWXvOZOs5tw1M+tYb7nxbu7fO8zVL9zEZ779/1r2vs95xgARcN+TP+MFZ7XuA2U6t/jNzBbgtj0/4Wvf38+Fm07mvNOW3ptnqov/zXr6uov8fQs/TGbixG9m1oRqLfjY13/Eb3/ybk4/uY9X/txpLT/GSX3dXHnh6dxyz5P8NMWROjNJ/JIuk/SQpEckXZdFDGZmzShXaty2Zy+v+dA3+NMv3c/Lzj2Va1/yLHoXOenKfN704rMYr9RaWkKaru01fklF4K+BVwCPA9+WdGtE3N/uWCKCSi2o1oKJao2CRKmrQFdBbZnw2PKnUq0xOlFldLzKSLnCWLnKyHiFYkGs6etmTW83A71d9JeKHfM7GNH4GwomajWKEsWCKEh0FUShoMntpv69BdBdKFAsiO7izH9ztdqxfWoRdBVFqVg4btuJam3y+zkyXmEk+Z4eGa8wWq5QrtT/truK9ZiKBVFUPa6ixNFKlSNH69sfGa8c93z/4XH2PPEzRstVNp7Uywd/YwtXbDmNT9+VXlI+9xlr+IWz1/O+rzxEd1Fc+5Jntvx3IYuLuxcBjySTriPpM8AVQMsT/wd2fJ+bv/s4lWr9l7JSqyXPa5O/TDOR6sOk9hQLlLoKdBcLdHfVf2nyIGb+thDMsmKufWbfZY73muM4Czx+fZ9FxD37281xrNn3qtSC0XK16XFYigUx0NtFb1cRCQSTf/xS8sWx1424GufaiHF6rBHHvhuT20zf57j1M6+rRTBRqU0m+/l+zgXBLH9ux51zV/KBUa3V/15n26e7KLqLBSrVoFxt7dg2pWKBnu4CPV1F+ktFzj/jZM7ZsJqzNwwwWq6mmvQb/vqqC/mDz+3mvf/4ABvW9PJr57e2rJRF4j8dmPqdexx44fSNJG0FtiYvj0h6KOW41gMHUz5G1nyOK4PPcQW4qslzfNWfL+kwZ820MIvEP1Oz+YTP9YjYBmxLP5w6SbsiYqhdx8uCz3Fl8DmuDFmeYxYXdx8Hzpzy+gzgyQziMDPLpSwS/7eBsyU9U1IJ+E3g1gziMDPLpbaXeiKiIultwP8BisANEXFfu+OYQdvKShnyOa4MPseVIbNz1Fw9KMzMbOXxnbtmZjnjxG9mljO5SvzzDRWhuv+drN8t6cIs4lyKJs7xquTcdkv6hqTzs4hzKZod8kPSz0uqSnptO+NrlWbOU9Ilku6RdJ+kr7U7xqVq4vf1JElflPS95BzfnEWciyXpBkn7Je2ZZX02OScicvFF/ULyD4BnASXge8B507a5HPgn6vcavAi4M+u4UzjHfweckjz/lZV4jlO2+xfgy8Brs447pZ/lydTveN+UvD4167hTOMd3AX+ePB8EngJKWce+gHP898CFwJ5Z1meSc/LU4p8cKiIiykBjqIiprgA+EXXfAk6WtLHdgS7BvOcYEd+IiJ8mL79F/T6KTtLMzxHgvwE3AfvbGVwLNXOebwBujojHACKi0861mXMMYED18SpWU0/8lfaGuXgRcQf1mGeTSc7JU+KfaaiI0xexzXK20Pivpd7a6CTznqOk04Ergb9tY1yt1szP8hzgFEm3S7pb0pvaFl1rNHOOfwU8l/pNnvcCb4+I1g7Ok61Mck6eZuBqZqiIpoaTWMaajl/SL1JP/C9JNaLWa+YcPwi8MyKqnTLC5QyaOc8u4AXApUAf8E1J34qI76cdXIs0c46/DNwDvAx4NrBD0v+NiOGUY2uXTHJOnhJ/M0NFdPpwEk3FL+nngI8CvxIRh9oUW6s0c45DwGeSpL8euFxSJSK+0JYIW6PZ39eDETECjEi6Azgf6JTE38w5vhm4PuoF8Uck/Qg4F7irPSGmLpOck6dSTzNDRdwKvCm50v4i4GcRsbfdgS7BvOcoaRNwM/DGDmoZTjXvOUbEMyNic0RsBj4P/HaHJX1o7vf1FuAXJHVJ6qc+yu0DbY5zKZo5x8eo/0eDpA3Ac4AftjXKdGWSc3LT4o9ZhoqQ9FvJ+r+l3gPkcuARYJR6a6NjNHmOfwysA/4maRFXooNGQWzyHDteM+cZEQ9Iug3YDdSAj0bEjN0Gl6Mmf5Z/Cnxc0r3UyyLvjIiOGa5Z0qeBS4D1kh4H/gTohmxzjodsMDPLmTyVeszMDCd+M7PcceI3M8sZJ34zs5xx4jczyxknfjOznHHiN5uBpN+VdH8yVO5OSWe16H3f1Yr3MVsK9+M3m0EyltGdETEq6b8Cl0TEbzSxXzEiqnOsPxIRq1sZq9lCucVvuSLpTUkr/nuSbpR0VtKib7TsNwFExFcjYjTZbc7hq5PJUL4q6VPUR5BE0heSETPvk7Q1WXY90JdMnPLJZNnVku5Kln1YUjHN8zcDt/gtRyT9W+rjFF0cEQclrQW2A5+PiO2S/hPwqoh49bT9/gr4SUS8d5b3vQT4R+B5EfGjZNnaiHhKUh/1MWleGhGHprb4JT0X+AvgNRExIelvgG9FxCdaf/Zmx+RmrB4z6kP7fr4x1kuSmF8MvCZZfyP1RDxJ0tXUR/t86TzvfVcj6Sd+R9KVyfMzgbOB6SOhXkp9WOVvJ+Mm9dG5E8dYB3HitzwR8491Prle0suB/0G9tT4+z34jU/a7BHg58OLkGsHtQO8s8WyPiD+cN3KzFnKN3/JkJ/AfJK2DejkG+Ab14YABrgK+nqy7APgw9dLPQlvhJwE/TZL+udTnUm2YkNQ9JZ7XSjq1EU+reg+ZzcUtfsuNZMjfPwO+JqkKfBf4HeAGSb8PHODYsLj/k/ocr59LyjCPRcSrmjzUbcBvSdoNPET94nDDNmC3pO9ExFWS/gj4iqQCMAG8Ffjxkk7UbB6+uGtmljMu9ZiZ5YxLPWZNkvR86j1/phqPiBdmEY/ZYrnUY2aWMy71mJnljBO/mVnOOPGbmeWME7+ZWc78f+H+Ykfm+zOuAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "import seaborn as sns\n",
    "sns.distplot(data['co2_rate'])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "heading_collapsed": true
   },
   "source": [
    "## 3. review_rate : 네이버 블로그 수"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "hidden": true
   },
   "outputs": [],
   "source": [
    "data['review_rate'] = minmax_scale(data['blog_review_num_list'],copy=True).tolist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "hidden": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "648    0.000000\n",
       "27     0.000000\n",
       "493    0.000000\n",
       "492    0.000000\n",
       "849    0.000000\n",
       "         ...   \n",
       "784    0.861742\n",
       "360    0.922018\n",
       "771    0.922018\n",
       "22     0.977789\n",
       "373    1.000000\n",
       "Name: review_rate, Length: 879, dtype: float64"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['review_rate'].sort_values()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {
    "hidden": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:xlabel='review_rate', ylabel='Density'>"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAX4AAAEHCAYAAACp9y31AAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuNCwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8QVMy6AAAACXBIWXMAAAsTAAALEwEAmpwYAAAcb0lEQVR4nO3deZhddZ3n8fen1qSyJ1VZyEJFSGIihBCKRdAIIoi4oI/a0+CCyhC7Xem2HRnGGbWnnxlcunt0urVF4RGcbmwFRGxBjChENCyVEEIgQEIgC2Sp7BupSlV95497AkWlKnUqqXNvVZ3P63nqufee9fvL8jnn/uqc31FEYGZm+VFW6gLMzKy4HPxmZjnj4DczyxkHv5lZzjj4zcxypqLUBaRRW1sb9fX1pS7DzGxAWbp06baIqOs8fUAEf319PY2NjaUuw8xsQJG0rqvp7uoxM8sZB7+ZWc44+M3McsbBb2aWMw5+M7OccfCbmeWMg9/MLGcc/GZmOePgNzPLmQFx525/9m8Prz9i2hVnTytBJWZm6fiM38wsZxz8ZmY54+A3M8sZB7+ZWc44+M3Mciaz4Jc0RNIjkh6X9KSkryXTx0paJGl18jomqxrMzOxIWZ7xNwNvjYjTgHnAJZLOAa4F7ouIGcB9yWczMyuSzII/CvYlHyuTnwAuA25Opt8MvDerGszM7EiZ9vFLKpe0HNgKLIqIh4EJEbEJIHkd3826CyU1SmpsamrKskwzs1zJNPgjoi0i5gFTgLMkndKLdW+IiIaIaKirO+JZwWZmdoyKclVPROwC7gcuAbZImgSQvG4tRg1mZlaQ5VU9dZJGJ++HAm8DngbuAq5MFrsS+EVWNZiZ2ZGyHKRtEnCzpHIKB5ifRsR/SFoC/FTSVcB64IMZ1mBmZp1kFvwRsQI4vYvp24ELs9qvmZkdne/cNTPLGQe/mVnOOPjNzHLGwW9mljMOfjOznHHwm5nljIPfzCxnHPxmZjnj4DczyxkHv5lZzjj4zcxyxsFvZpYzDn4zs5xx8JuZ5YyD38wsZxz8ZmY54+A3M8sZB7+ZWc44+M3McsbBb2aWMw5+M7OccfCbmeWMg9/MLGcc/GZmOZNZ8EuaKun3klZJelLS55PpX5X0oqTlyc+lWdVgZmZHqshw263AFyJimaQRwFJJi5J5/xgR38pw32Zm1o3Mgj8iNgGbkvd7Ja0CJme1PzMzS6coffyS6oHTgYeTSZ+RtELSTZLGdLPOQkmNkhqbmpqKUaaZWS5kHvyShgO3A9dExB7ge8BJwDwK3wj+vqv1IuKGiGiIiIa6urqsyzQzy41Mg19SJYXQ/9eIuAMgIrZERFtEtAM/AM7KsgYzM3utLK/qEXAjsCoi/qHD9EkdFnsfsDKrGszM7EhZXtVzHvAR4AlJy5Np1wGXS5oHBPAC8MkMazAzs06yvKrnQUBdzLo7q32amVnPfOeumVnOOPjNzHLGwW9mljMOfjOznHHwm5nljIPfzCxnHPxmZjnj4DczyxkHv5lZzjj4zcxyxsFvZpYzDn4zs5xx8JuZ5YyD38wsZxz8ZmY54+A3M8sZB7+ZWc44+M3McsbBb2aWMw5+M7OccfCbmeWMg9/MLGcc/GZmOePgNzPLmcyCX9JUSb+XtErSk5I+n0wfK2mRpNXJ65isajAzsyNlecbfCnwhImYD5wCfljQHuBa4LyJmAPcln83MrEgyC/6I2BQRy5L3e4FVwGTgMuDmZLGbgfdmVYOZmR2pKH38kuqB04GHgQkRsQkKBwdgfDfrLJTUKKmxqampGGWameVC5sEvaThwO3BNROxJu15E3BARDRHRUFdXl12BZmY5k2nwS6qkEPr/GhF3JJO3SJqUzJ8EbM2yBjMze60sr+oRcCOwKiL+ocOsu4Ark/dXAr/IqgYzMztSRYbbPg/4CPCEpOXJtOuA64GfSroKWA98MMMazMysk8yCPyIeBNTN7Auz2q+ZmR2d79w1M8uZVMEv6XZJ75TkA4WZ2QCXNsi/B1wBrJZ0vaTXZ1iTmZllKFXwR8RvI+JDwHzgBWCRpD9J+nhyyaaZmQ0QqbtuJI0DPgb8Z+Ax4NsUDgSLMqnMzMwykeqqHkl3AK8Hfgy8+/CQC8C/S2rMqjgzM+t7aS/n/GFE3N1xgqTqiGiOiIYM6jIzs4yk7er5uy6mLenLQszMrDiOesYvaSKFoZSHSjqdV2/IGgnUZFybmZlloKeunrdT+IXuFKDjeDt7KQy/YGZmA8xRgz8ibgZulvT+iLi9SDWZmVmGeurq+XBE/D+gXtJfd57fadRNMzMbAHrq6hmWvA7PuhAzMyuOnrp6vp+8fq045ZiZWdbSDtL2DUkjJVVKuk/SNkkfzro4MzPre2mv4784eV7uu4CNwEzgi5lVZWZmmUkb/IcHYrsUuDUidmRUj5mZZSztkA2/lPQ08DLwKUl1wMHsyjIzs6ykHZb5WuCNQENEHAL2A5dlWZiZmWWjN8/cnU3hev6O69zSx/WYmVnG0g7L/GPgJGA50JZMDhz8ZmYDTtoz/gZgTkRElsWYmVn20l7VsxKYmGUhZmZWHGnP+GuBpyQ9AjQfnhgR78mkKjMzy0za4P9qbzcs6SYKN3xtjYhTkmlfBa4GmpLFruv8ZC8zM8tW2ss5HwBeACqT948Cy3pY7UfAJV1M/8eImJf8OPTNzIos7Vg9VwO3Ad9PJk0G7jzaOhGxGPAdvmZm/UzaX+5+GjgP2AMQEauB8ce4z89IWiHpJkljultI0kJJjZIam5qaulvMzMx6KW3wN0dEy+EPyU1cx3Jp5/co3A8wD9gE/H13C0bEDRHREBENdXV1x7ArMzPrStrgf0DSdRQeun4R8DPgl73dWURsiYi2iGgHfgCc1dttmJnZ8Ukb/NdSuBLnCeCTwN3Al3u7M0mTOnx8H4X7A8zMrIhSXc4ZEe2S7gTujIhUHe6SbgXOB2olbQS+ApwvaR6FbqIXKBxEzMysiHp62LooBPZnACWT2oD/GxF/e7R1I+LyLibfeKyFmplZ3+ipq+caClfznBkR4yJiLHA2cJ6kv8q6ODMz63s9Bf9Hgcsj4vnDEyJiLfDhZJ6ZmQ0wPQV/ZURs6zwx6eev7GJ5MzPr53oK/pZjnGdmZv1UT1f1nCZpTxfTBQzJoB4zM8vYUYM/IsqLVYiZmRVH2hu4zMxskHDwm5nljIPfzCxnHPxmZjnj4DczyxkHv5lZzjj4zcxyxsFvZpYzDn4zs5xx8JuZ5YyD38wsZxz8ZmY54+A3M8sZB7+ZWc44+M3McsbBb2aWMw5+M7OccfCbmeVMZsEv6SZJWyWt7DBtrKRFklYnr2Oy2r+ZmXUtyzP+HwGXdJp2LXBfRMwA7ks+m5lZEWUW/BGxGNjRafJlwM3J+5uB92a1fzMz61qx+/gnRMQmgOR1fHcLSlooqVFSY1NTU9EKNDMb7PrtL3cj4oaIaIiIhrq6ulKXY2Y2aFQUeX9bJE2KiE2SJgFbi7z/PhcR/HHNNl7YfoAzThzDrIkjSl2SmdlRFfuM/y7gyuT9lcAvirz/PtXeHty2dCN3r9zMmqZ9/Pihdfx21ZZSl2VmdlRZXs55K7AEmCVpo6SrgOuBiyStBi5KPg9Yd6/cxGMbdnHBrDq+/M7ZzJs6msXPNrFq055Sl2Zm1q3Munoi4vJuZl2Y1T6Lqb09+KffraF2eDUXzp5AmcS7Tp3E6i17+a93PMHPP3UukkpdppnZEfrtL3f7u0WrtvD05r1cMKuOsiTga6oruGjORJZv2MXSdTtLXKGZWdcc/Mfox0vWMWXMUOZOGf2a6fOmjmZ4dQW3PrKhNIWZmfXAwX8Mdh1oYcna7bz7tBMoL3ttd05VRRnvmXcCv3riJXa/fKhEFZqZdc/BfwwWPbWFtvbgkjdM7HL+5WdO4+Chdu5a/mKRKzMz65mD/xjc++RmThg1hLlTRnU5/9Qpozh5/HDuWbm5yJWZmfXMwd9L+5pbWbx6G28/ZeJRr9q5eM4EHn5+B7sPuLvHzPoXB38vPbx2Oy2t7Vw0e8JRl7tozgTa2oPfPeMbusysf3Hw99KfnttOVUUZ8088+qMETpsymvEjqln0lIPfzPoXB38vLXluO2dMG8OQyvKjLldWJt42ZwL3P9NEc2tbkaozM+uZg78Xdu5v4alNe3jjSeNSLf/WWeM50NJG4wu+mcvM+g8Hfy88/Px2AM5NGfxvPGkcleVi8bN+noCZ9R8O/l5Y8tx2hlaWH3G3bneGVVdwxoljeMDBb2b9iIO/Fx55YSdnnDiGqor0f2wLZtbx9Oa9bN1zMMPKzMzSc/CntK+5lWc27+nxap7OFswoPD1s8eptWZRlZtZrDv6UVmzYRXvA/Gmje7XenEkjqR1e5X5+M+s3HPwpHR5m+fSpvTvjLysTC2bU8eCabbS3RxalmZn1ioM/pWXrdzJj/HBG1VT2et0FM+vYsb+FlS/tzqAyM7PecfCnEBE8tmEX86f17mz/sDfNqAXggWfc3WNmpefgT2Httv3sOnCI+SeOPqb1a4dXc8rkkSxe7eA3s9Jz8KdwuH//WM/4oXB1z7L1u9hz0KN1mllpOfhTeGz9TkYOqeCkuuHHvI0FM+toaw/+tGZ7H1ZmZtZ7Dv4Ulq3bxenTxlBW1v34+z2ZP20Mw6rK3d1jZiXn4O/BnoOHeHbr3uPq5oHCs3jPPbmWxc82EeHLOs2sdBz8PVi+fhcRcEYv79jtyoKZdWzc+TLPb9vfB5WZmR2bilLsVNILwF6gDWiNiIZS1JHGsvU7keC0qV0/X7c33nJ4+IZnm3jdcfy+wMzseJQk+BMXRES/H8Bm2fpdzJowghFD0t+49W8Prz9i2hVnT2PauBrqx9WwePU2Pnbe9L4s08wsNXf1HEV7e/DY+p2cfpz9+x0tmFnHkue2+6lcZlYypQr+AH4jaamkhV0tIGmhpEZJjU1NpbkSZk3TPvYebO2T/v3DFsyo4+VDfiqXmZVOqYL/vIiYD7wD+LSkBZ0XiIgbIqIhIhrq6uqKXyGw7JUbt0b32Tb9VC4zK7WSBH9EvJS8bgV+DpxVijp6smz9TsbUVDK9dlifbXNYdQUNJ471U7nMrGSKHvyShkkacfg9cDGwsth1pLFsfWFgNunYb9zqyuGncm3e7adymVnxleKMfwLwoKTHgUeAX0XEr0tQx1HtPnCINVv39fqJW2lcNGc8APc+ubnPt21m1pOiX84ZEWuB04q9395atiF58Eof9u8fdvL4EcyaMIJfrdjElefW9/n2zcyOxpdzduPhtTuoLFevn7iV1jvnTuLRdTvc3WNmRefg78ZDa7dz2pTRDK0qz2T7l546iQi4Z+WmTLZvZtYdB38X9je38sSLuzn7dWMz28fJ44fz+okjuPOxFzPbh5lZVxz8XWhct5O29uDs6eMy3c8HG6by+MbdrNq0J9P9mJl1VMqxevqth9dup7xMfXrHblfj97zv9Ml8/Z6n+fdHN/DV97yhz/ZlZnY0PuPvwkNrt3Pq5FEMq872uDh2WBUXv2ECP3/sRQ4e8tg9ZlYcDv5Odh1oYfmGXbx5Rm1R9nf5WdPY/fIhfrHcff1mVhwO/k7+sHob7QHnzyrO+EDnnjSON5wwku8/sJa2dj+Zy8yy5+Dv5P5nmhg1tJJ5GV2/35kkPnX+yazdtt938ppZUTj4O2hvDx54tok3z6il/DgerN5bl5wykem1w/jOfat91m9mmXPwd/DUpj1s29fM+bPGF3W/5WXiby6exdOb9/KTR4+8+sfMrC85+Dv49crNlAneMrP44/9feupEzpo+lm/d+wy7Dxwq+v7NLD8c/ImI4K7HX+Lck2qpG1Fd9P1L4ivvnsPeg61cd+cTRLjLx8yy4eBPPL5xN+t3HOA9p51QshrecMIo/uqimfxqxSZ+1rixZHWY2eDm4E/88vGXqCwXbz9lYknr+Iu3nMS5J43jy3euZMlz20tai5kNTg5+oKW1nbsef4m3zBzPqKGVJa2lvEx890PzOXFcDQtvaWTpOj+U3cz6loMf+I8VL9G0t5kPnzOt1KUAMLqmiluuOouxw6u44gcP8cvHXyp1SWY2iOR+kLaI4MYHn+fk8cOLfjVPVwO3XXF24eAzadRQ7vjLc1n446V89tbHuP+ZJr78ztmMGVZV1BrNbPDJ/Rn/krXbefKlPXzivOl9/lD14zVueDW3Xn0On3vrydy5/EUWfPP3fOe+1ezY31Lq0sxsANNAuGywoaEhGhsb+3y7be3BZf/8IE17m3ngixcwpLL3T9vq6qw9C5v3HOQ3T27m6c17qSgTMyeM4OPn1XPh7AmM9bcAM+uCpKUR0dB5eq67en7auIGVL+7h238+75hCv5gmjhzCR99Yz5Y9B3nk+R08tWkPX7xtBWWCWRNHMm/qKOZOGc367QeoHV79mkdGHu4+MjODHAf/+u0HuP6epzlr+tiSXrvfWxNGDuHdp53Au+ZOYu6U0fx21RaWrd/J3U9s5tZHNryy3LDqCuqGV1E3opr9za1Mrx1GfW0NU8fWUF3Rvw9yZpatXAb/vuZWrr6l0HX0jffP7Xd9+2lI4tQpozh1yiig8EvqddsPcOODz9O0t5lt+5pp2tvMky/t4dEXdnZYD04YNZT62hrqxw2jftwwThxXw/TaYUwdW9Pvv/mY2fHLXfBv2XOQq29pZPXWvdzyibOprx1W6pL6hCTqa4cxe9JIZk967bwDza1s39/C9v3NbNvXwo79LexvbuNXT2xiV4dxgSSYNHII9bXDOHHcMOrH1VBfWzg4TBtb85ruIzMbuEoS/JIuAb4NlAM/jIjrs95na1s7ty/byDfvfZYDLa18/yMNvKlIT9nKStpfLNdUV1BTXcHUsTVHzDvQ0sqO/S1s29fC5NFDWbd9Py9sLzwboPPVQ6OGVjJ2WBVnTx/LicnBoG5ENbXDq6gdUc2I6opef3tqbWunpa2dltZ2mltffW1tb6dMokyFg9rh92USQyrLGVpVzpCKMirKc39hmlmvFT34JZUD/wxcBGwEHpV0V0Q81df72rDjAEvX7aRx3Q5+vXIL2/Y1c/q00fyv953K7Ekj+3p3A1JNVQU1VRVMGVM4KNSNqKahfiwAL7e0FQ4K+5vZvq+FHck3ht+u2sK2fUdeUlpVUcaI6gqqKsqoqiijuqKMyvIyWtviNeG+v7mV1vZ22tqD4338QGV5ciBIDgZDK8sZUllOTdVrp9VUlTOkqpyayooO78uprix75aACHQ80hW9AkhCFA87hY5oovH/lEKdXpyUfC+t1WEbJ9o9YpsP8jtvoatoRn49nu0dZRh3a9Or8rtfhNbXxyoFfXWz3NesdbZ0B2PU60JTijP8sYE1ErAWQ9BPgMqDPg/+79z/HrY+sZ2hlOefPquP986dw4ezx/oeV0tCqciZXDWXymKFHzDt4qI2dB1rY19zKvoOt7G9uZeq4GvY3t9J8qHAW33yonUNt7VSUi6qKcirLRXVFGc9vO0BFmQo/5aKirIzyDu8rykRZ8iCciCACgsJrewSH2oJDbe3JT+Ggcqi1ndb2oCU5sOzc38Kh5NvEobbC9ENthWVs4Oh8cDimbXR4397N5etl3Wz/WHd7+IDX8Zvq4YPaq59fff/KCUfZkQfLb7x/Lme/btyxFdKNUgT/ZGBDh88bgbM7LyRpIbAw+bhP0jPHs9OngX85ng10rxbYls2mi24wtQUGV3sGU1tgcLUn07ac81+Oa/UTu5pYiuDv6hh6xGE4Im4Absi+nOMjqbGrGyQGosHUFhhc7RlMbYHB1Z6B2JZS/GZsIzC1w+cpgEchMzMrklIE/6PADEnTJVUBfw7cVYI6zMxyqehdPRHRKukzwL0ULue8KSKeLHYdfajfd0f1wmBqCwyu9gymtsDgas+Aa8uAGKTNzMz6ju9+MTPLGQe/mVnOOPhTkHSJpGckrZF0bRfzJek7yfwVkuaXos60UrTnQ0k7Vkj6k6TTSlFnGj21pcNyZ0pqk/SBYtbXW2naI+l8ScslPSnpgWLXmFaKf2ejJP1S0uNJWz5eijrTkHSTpK2SVnYzf0BlQHJnpH+6+6HwC+jngNcBVcDjwJxOy1wK3EPhHoVzgIdLXfdxtudcYEzy/h39tT1p2tJhud8BdwMfKHXdx/l3M5rCXe7Tks/jS133cbTlOuDryfs6YAdQVerau2nPAmA+sLKb+QMmAyLCZ/wpvDLERES0AIeHmOjoMuCWKHgIGC1pUucN9RM9tici/hQRh8dyfojCvRb9UZq/G4DPArcDW4tZ3DFI054rgDsiYj1ARPTXNqVpSwAjVBiPYTiF4G8tbpnpRMRiCvV1ZyBlgIM/ha6GmJh8DMv0F72t9SoKZzL9UY9tkTQZeB+ZjdjRp9L83cwExki6X9JSSR8tWnW9k6Yt/wTMpnAD5xPA5yOivTjl9bmBlAH5G4//GKQZYiLVMBT9ROpaJV1AIfjflGlFxy5NW/4P8KWIaBsAg/OlaU8FcAZwITAUWCLpoYh4NuvieilNW94OLAfeCpwELJL0h4jYk3FtWRhIGeDgTyHNEBMDaRiKVLVKmgv8EHhHRGwvUm29laYtDcBPktCvBS6V1BoRdxalwt5J+29tW0TsB/ZLWgycBvS34E/Tlo8D10ehk3yNpOeB1wOPFKfEPjWQMsBdPSmkGWLiLuCjyW/2zwF2R8SmYheaUo/tkTQNuAP4SD88k+yox7ZExPSIqI+IeuA24FP9NPQh3b+1XwBvllQhqYbCyLarilxnGmnasp7CNxckTQBmAWuLWmXfGUgZ4DP+nkQ3Q0xI+otk/r9QuFrkUmANcIDCmUy/lLI9/wMYB3w3OVNujX44+mDKtgwYadoTEask/RpYAbRTeIJdl5cYllLKv5v/CfxI0hMUukq+FBH9cqhmSbcC5wO1kjYCXwEqYeBlAHjIBjOz3HFXj5lZzjj4zcxyxsFvZpYzDn4zs5xx8JuZ5YyD38wsZxz8ZglJJ0i6rcQ1XJPcmGWWGV/Hb4NWMuqj+tPAXz3VJOkFoKG/3shkg4PP+G1QkVQvaZWk7wLLgP8u6dHk4RhfS5b5uqRPdVjnq5K+kKy7MplWLumbHdb9ZDL9u5Lek7z/uaSbkvdXSfq7lDVNlfQ9SY3JA0gO1/U54ATg95J+n0y7WNISScsk/UzS8Gz+5CxPHPw2GM0CbgG+RGFo3LOAecAZkhZQGBv+P3VY/s+An3XaxlUUxls5EzgTuFrSdGAx8OZkmcnAnOT9m4A/9FRTRJweEeuA/5YMgzEXeIukuRHxHQoDe10QERdIqgW+DLwtIuYDjcBf9+6PwuxIHqvHBqN1EfGQpG8BFwOPJdOHAzMi4kZJ4yWdQOHJTzsjYr2k+g7buBiYq1cf1TgKmEEh3K+RNIfCk7DGJA/ceCPwuZ5q6vD5zyQtpPB/cBKFA8iKTuuck0z/YzJmUhWwJPWfglk3HPw2GO1PXgX874j4fhfL3AZ8AJhI4RtAZwI+GxH3HjFDGgNcQuHsfyyFbwz7ImJvippIvjn8DXBmROyU9CNgSDc1LIqIy4+yXbNec1ePDWb3Ap843C8uabKk8cm8n1AYKvgDFA4CXa37l5Iqk3VnShqWzFsCXEMh+P9AIcSP1s3T2UgKB4LdyXDE7+gwby8wInn/EHCepJOTGmokzezFfsy65DN+G7Qi4jeSZlN4ShXAPuDDwNZkiOARwIvdjJv+Q6AeWJZcidMEvDeZ9wfg4ohYI2kdhbP+1MEfEY9Legx4ksL483/sMPsG4B5Jm5J+/o8Bt0qqTuZ/mf730BUbYHw5p5lZzrirx8wsZ9zVY9ZHJI0D7uti1oX9+LnFlkPu6jEzyxl39ZiZ5YyD38wsZxz8ZmY54+A3M8uZ/w97cYPNeyyX/gAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "sns.distplot(data['review_rate'])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 4. dist_rate : 선정된 F&B와의 접근성"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "heading_collapsed": true
   },
   "source": [
    "#### 4-(1) F&B 클러스터 정보 병합"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {
    "hidden": true
   },
   "outputs": [],
   "source": [
    "# FB 데이터 클러스터 정보 병합\n",
    "FB = pd.read_csv('data/F&B추천점수.csv')\n",
    "cluster_info = pd.read_csv(\"data/데이터_제주구역배정.csv\")\n",
    "fb_cluster = cluster_info[cluster_info['type']==\"fnb\"].reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {
    "hidden": true
   },
   "outputs": [],
   "source": [
    "FB = pd.merge(FB, fb_cluster[['AREA_NM_PRE', 'cluster']], how=\"left\", on = \"AREA_NM_PRE\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {
    "hidden": true
   },
   "outputs": [],
   "source": [
    "# 클러스터0\n",
    "cluster0 = FB[FB['cluster']== 0].sort_values('rec_score', ascending=False)\n",
    "\n",
    "# 식당\n",
    "food0 = cluster0[cluster0.category != \"카페/디저트\"].head(8).reset_index(drop=True)\n",
    "# 카페/디저트 \n",
    "cafe0 = cluster0[(cluster0.category == \"카페/디저트\")].head(4).reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {
    "hidden": true
   },
   "outputs": [],
   "source": [
    "cluster0_final = pd.concat([food0, cafe0])\n",
    "cluster0_final = cluster0_final.reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {
    "hidden": true
   },
   "outputs": [],
   "source": [
    "# 클러스터 1\n",
    "cluster1 = FB[FB['cluster']== 1].sort_values('rec_score', ascending=False)\n",
    "\n",
    "# 식당\n",
    "food1 = cluster1[cluster1.category != \"카페/디저트\"].head(8).reset_index(drop=True)\n",
    "# 카페/디저트 \n",
    "cafe1 = cluster1[(cluster1.category == \"카페/디저트\")].head(4).reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {
    "hidden": true
   },
   "outputs": [],
   "source": [
    "cluster1_final = pd.concat([food1, cafe1])\n",
    "cluster1_final = cluster1_final.reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {
    "hidden": true
   },
   "outputs": [],
   "source": [
    "# 클러스터3\n",
    "cluster3 = FB[FB['cluster']== 3].sort_values('rec_score', ascending=False)\n",
    "\n",
    "# 식당\n",
    "food3 = cluster3[cluster3.category != \"카페/디저트\"].head(10).reset_index(drop=True)\n",
    "\n",
    "# 카페/디저트 \n",
    "cafe3 = cluster3[(cluster3.category == \"카페/디저트\")].head(4).reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {
    "hidden": true
   },
   "outputs": [],
   "source": [
    "cluster3_final = pd.concat([food3, cafe3])\n",
    "cluster3_final = cluster3_final.reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {
    "hidden": true
   },
   "outputs": [],
   "source": [
    "# 클러스터4\n",
    "cluster4 = FB[FB['cluster']== 4].sort_values('rec_score', ascending=False)\n",
    "\n",
    "# 식당\n",
    "food4 = cluster4[cluster4.category != \"카페/디저트\"].head(8).reset_index(drop=True)\n",
    "\n",
    "# 카페/디저트 \n",
    "cafe4 = cluster4[(cluster4.category == \"카페/디저트\")].head(4).reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {
    "hidden": true
   },
   "outputs": [],
   "source": [
    "cluster4_final = pd.concat([food4, cafe4])\n",
    "cluster4_final = cluster4_final.reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {
    "hidden": true
   },
   "outputs": [],
   "source": [
    "# 클러스터5 \n",
    "cluster5 = FB[FB['cluster']== 5].sort_values('rec_score', ascending=False)\n",
    "\n",
    "# 식당\n",
    "food5 = cluster5[cluster5.category != \"카페/디저트\"].head(8).reset_index(drop=True)\n",
    "# 카페/디저트 \n",
    "cafe5 = cluster5[(cluster5.category == \"카페/디저트\")].head(6).reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {
    "hidden": true
   },
   "outputs": [],
   "source": [
    "cluster5_final = pd.concat([food5, cafe5])\n",
    "cluster5_final = cluster5_final.reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "heading_collapsed": true
   },
   "source": [
    "#### 4-(2) 관광지별로 동일 구역 내 F&B와의 거리 계산"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {
    "hidden": true
   },
   "outputs": [],
   "source": [
    "#클러스터별로 나누기\n",
    "data0 = data[data.cluster==0].reset_index(drop=True)\n",
    "data1 = data[data.cluster==1].reset_index(drop=True)\n",
    "data3 = data[data.cluster==3].reset_index(drop=True)\n",
    "data4 = data[data.cluster==4].reset_index(drop=True)\n",
    "data5 = data[data.cluster==5].reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {
    "hidden": true
   },
   "outputs": [],
   "source": [
    "# F&B선별 데이터\n",
    "fnb0 = cluster0_final\n",
    "fnb1 = cluster1_final\n",
    "fnb3 = cluster3_final\n",
    "fnb4 = cluster4_final\n",
    "fnb5 = cluster5_final"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {
    "hidden": true,
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "#계산할 관광지 후보\n",
    "def calcuate_dist(data,fnb):\n",
    "    calcul_df = data[['name_PRE','lat','lon']]\n",
    "    \n",
    "    for i in range(0,len(fnb)):\n",
    "        target = tuple(fnb[['lat','lon']].iloc[i])\n",
    "        dist_list = []\n",
    "    \n",
    "        for j in range(0,len(calcul_df)):\n",
    "            distance = haversine(target, tuple(calcul_df.iloc[j,1:3]), unit = 'km')\n",
    "            dist_list.append(distance)\n",
    "        calcul_df[f'{i}'] = dist_list\n",
    "    #거리 최소값 계산\n",
    "    calcul_df['dist_min'] = calcul_df.iloc[:,3:].min(axis=1)\n",
    "\n",
    "    # 4km 이하인 거리는 모두 같은것(4km)으로 간주\n",
    "    calcul_df['dist_min'][calcul_df['dist_min'] <= 4] = 4\n",
    "\n",
    "    # Normalization > 점수부여\n",
    "    data['dist_score'] = (1 - minmax_scale(calcul_df['dist_min'], copy=True)).tolist()\n",
    "\n",
    "    return(data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {
    "hidden": true
   },
   "outputs": [],
   "source": [
    "data0 = calcuate_dist(data0,fnb0)\n",
    "data1 = calcuate_dist(data1,fnb1)\n",
    "data3 = calcuate_dist(data3,fnb3)\n",
    "data4 = calcuate_dist(data4,fnb4)\n",
    "data5 = calcuate_dist(data5,fnb5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {
    "hidden": 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>cluster</th>\n",
       "      <th>CL_NM</th>\n",
       "      <th>CAT_PRE</th>\n",
       "      <th>name_PRE</th>\n",
       "      <th>lon</th>\n",
       "      <th>lat</th>\n",
       "      <th>price</th>\n",
       "      <th>blog_review_num_list</th>\n",
       "      <th>co2_max</th>\n",
       "      <th>similarity</th>\n",
       "      <th>type</th>\n",
       "      <th>eco_YN</th>\n",
       "      <th>co2_rate</th>\n",
       "      <th>review_rate</th>\n",
       "      <th>dist_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>테마관광지</td>\n",
       "      <td>테마파크/공연/전시</td>\n",
       "      <td>감귤박물관</td>\n",
       "      <td>126.607428</td>\n",
       "      <td>33.271593</td>\n",
       "      <td>0.0</td>\n",
       "      <td>886.0</td>\n",
       "      <td>0.023639</td>\n",
       "      <td>0.403927</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.999024</td>\n",
       "      <td>0.071302</td>\n",
       "      <td>0.530609</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>자연</td>\n",
       "      <td>자연</td>\n",
       "      <td>상효원</td>\n",
       "      <td>126.586009</td>\n",
       "      <td>33.307217</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1129.0</td>\n",
       "      <td>0.310905</td>\n",
       "      <td>0.200666</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.987169</td>\n",
       "      <td>0.090858</td>\n",
       "      <td>0.546059</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>자연</td>\n",
       "      <td>자연</td>\n",
       "      <td>정방폭포</td>\n",
       "      <td>126.573050</td>\n",
       "      <td>33.244748</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4427.0</td>\n",
       "      <td>0.092272</td>\n",
       "      <td>0.423816</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.996192</td>\n",
       "      <td>0.356269</td>\n",
       "      <td>0.668634</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0</td>\n",
       "      <td>자연</td>\n",
       "      <td>자연</td>\n",
       "      <td>천지연폭포</td>\n",
       "      <td>126.559551</td>\n",
       "      <td>33.244717</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5849.0</td>\n",
       "      <td>0.285718</td>\n",
       "      <td>0.357876</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.988209</td>\n",
       "      <td>0.470707</td>\n",
       "      <td>0.716300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0</td>\n",
       "      <td>키즈</td>\n",
       "      <td>테마파크/공연/전시</td>\n",
       "      <td>코코몽에코파크</td>\n",
       "      <td>126.708208</td>\n",
       "      <td>33.275160</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1035.0</td>\n",
       "      <td>0.012029</td>\n",
       "      <td>0.247351</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.999504</td>\n",
       "      <td>0.083293</td>\n",
       "      <td>0.178004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>0</td>\n",
       "      <td>쇼핑</td>\n",
       "      <td>시장</td>\n",
       "      <td>서귀포매일올레시장</td>\n",
       "      <td>126.563231</td>\n",
       "      <td>33.250149</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8349.0</td>\n",
       "      <td>1.124130</td>\n",
       "      <td>0.147991</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.953608</td>\n",
       "      <td>0.671898</td>\n",
       "      <td>0.701053</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>0</td>\n",
       "      <td>쇼핑</td>\n",
       "      <td>시장</td>\n",
       "      <td>서귀포향토오일시장</td>\n",
       "      <td>126.572486</td>\n",
       "      <td>33.266877</td>\n",
       "      <td>0.0</td>\n",
       "      <td>873.0</td>\n",
       "      <td>0.218796</td>\n",
       "      <td>0.136813</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.990970</td>\n",
       "      <td>0.070256</td>\n",
       "      <td>0.655377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>0</td>\n",
       "      <td>쇼핑</td>\n",
       "      <td>공방</td>\n",
       "      <td>아름낭</td>\n",
       "      <td>126.494643</td>\n",
       "      <td>33.258169</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.006108</td>\n",
       "      <td>0.150061</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.999748</td>\n",
       "      <td>0.000724</td>\n",
       "      <td>0.928442</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>0</td>\n",
       "      <td>쇼핑</td>\n",
       "      <td>기념품/소품</td>\n",
       "      <td>연필가게</td>\n",
       "      <td>126.744499</td>\n",
       "      <td>33.286167</td>\n",
       "      <td>0.0</td>\n",
       "      <td>114.0</td>\n",
       "      <td>0.009931</td>\n",
       "      <td>0.168674</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.999590</td>\n",
       "      <td>0.009174</td>\n",
       "      <td>0.043416</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>0</td>\n",
       "      <td>쇼핑</td>\n",
       "      <td>특산물</td>\n",
       "      <td>올레바다</td>\n",
       "      <td>126.511170</td>\n",
       "      <td>33.237147</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.878523</td>\n",
       "      <td>0.123634</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.963744</td>\n",
       "      <td>0.000080</td>\n",
       "      <td>0.888787</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>135 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     cluster  CL_NM     CAT_PRE   name_PRE         lon        lat  price  \\\n",
       "0          0  테마관광지  테마파크/공연/전시      감귤박물관  126.607428  33.271593    0.0   \n",
       "1          0     자연          자연        상효원  126.586009  33.307217    0.0   \n",
       "2          0     자연          자연       정방폭포  126.573050  33.244748    0.0   \n",
       "3          0     자연          자연      천지연폭포  126.559551  33.244717    0.0   \n",
       "4          0     키즈  테마파크/공연/전시    코코몽에코파크  126.708208  33.275160    0.0   \n",
       "..       ...    ...         ...        ...         ...        ...    ...   \n",
       "130        0     쇼핑          시장  서귀포매일올레시장  126.563231  33.250149    0.0   \n",
       "131        0     쇼핑          시장  서귀포향토오일시장  126.572486  33.266877    0.0   \n",
       "132        0     쇼핑          공방        아름낭  126.494643  33.258169    0.0   \n",
       "133        0     쇼핑      기념품/소품       연필가게  126.744499  33.286167    0.0   \n",
       "134        0     쇼핑         특산물       올레바다  126.511170  33.237147    0.0   \n",
       "\n",
       "     blog_review_num_list   co2_max  similarity type  eco_YN  co2_rate  \\\n",
       "0                   886.0  0.023639    0.403927  관광지       0  0.999024   \n",
       "1                  1129.0  0.310905    0.200666  관광지       0  0.987169   \n",
       "2                  4427.0  0.092272    0.423816  관광지       0  0.996192   \n",
       "3                  5849.0  0.285718    0.357876  관광지       0  0.988209   \n",
       "4                  1035.0  0.012029    0.247351  관광지       0  0.999504   \n",
       "..                    ...       ...         ...  ...     ...       ...   \n",
       "130                8349.0  1.124130    0.147991  관광지       0  0.953608   \n",
       "131                 873.0  0.218796    0.136813  관광지       0  0.990970   \n",
       "132                   9.0  0.006108    0.150061  관광지       0  0.999748   \n",
       "133                 114.0  0.009931    0.168674  관광지       0  0.999590   \n",
       "134                   1.0  0.878523    0.123634  관광지       0  0.963744   \n",
       "\n",
       "     review_rate  dist_score  \n",
       "0       0.071302    0.530609  \n",
       "1       0.090858    0.546059  \n",
       "2       0.356269    0.668634  \n",
       "3       0.470707    0.716300  \n",
       "4       0.083293    0.178004  \n",
       "..           ...         ...  \n",
       "130     0.671898    0.701053  \n",
       "131     0.070256    0.655377  \n",
       "132     0.000724    0.928442  \n",
       "133     0.009174    0.043416  \n",
       "134     0.000080    0.888787  \n",
       "\n",
       "[135 rows x 15 columns]"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data0"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 5.유사도 점수 \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0      0.403927\n",
       "1      0.501137\n",
       "2      0.290487\n",
       "3      0.268219\n",
       "4      0.508015\n",
       "         ...   \n",
       "874    0.137163\n",
       "875    0.152665\n",
       "876    0.244736\n",
       "877    0.126018\n",
       "878    0.224000\n",
       "Name: similarity, Length: 879, dtype: float64"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['similarity']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 6. 관광지 최종 점수 산정"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "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>cluster</th>\n",
       "      <th>CL_NM</th>\n",
       "      <th>CAT_PRE</th>\n",
       "      <th>name_PRE</th>\n",
       "      <th>lon</th>\n",
       "      <th>lat</th>\n",
       "      <th>price</th>\n",
       "      <th>blog_review_num_list</th>\n",
       "      <th>co2_max</th>\n",
       "      <th>similarity</th>\n",
       "      <th>type</th>\n",
       "      <th>eco_YN</th>\n",
       "      <th>co2_rate</th>\n",
       "      <th>review_rate</th>\n",
       "      <th>dist_score</th>\n",
       "      <th>total_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>자연</td>\n",
       "      <td>엉또폭포</td>\n",
       "      <td>126.491918</td>\n",
       "      <td>33.258821</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1864.0</td>\n",
       "      <td>0.032606</td>\n",
       "      <td>0.456621</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.998654</td>\n",
       "      <td>0.150008</td>\n",
       "      <td>0.936069</td>\n",
       "      <td>2.541352</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0</td>\n",
       "      <td>자연</td>\n",
       "      <td>자연</td>\n",
       "      <td>천지연폭포</td>\n",
       "      <td>126.559551</td>\n",
       "      <td>33.244717</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5849.0</td>\n",
       "      <td>0.285718</td>\n",
       "      <td>0.357876</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.988209</td>\n",
       "      <td>0.470707</td>\n",
       "      <td>0.716300</td>\n",
       "      <td>2.533091</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>0</td>\n",
       "      <td>쇼핑</td>\n",
       "      <td>시장</td>\n",
       "      <td>서귀포매일올레시장</td>\n",
       "      <td>126.563231</td>\n",
       "      <td>33.250149</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8349.0</td>\n",
       "      <td>1.124130</td>\n",
       "      <td>0.147991</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.953608</td>\n",
       "      <td>0.671898</td>\n",
       "      <td>0.701053</td>\n",
       "      <td>2.474549</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>레저/체험</td>\n",
       "      <td>영실기암</td>\n",
       "      <td>126.466023</td>\n",
       "      <td>33.278536</td>\n",
       "      <td>0.0</td>\n",
       "      <td>111.0</td>\n",
       "      <td>0.366539</td>\n",
       "      <td>0.505567</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.984873</td>\n",
       "      <td>0.008933</td>\n",
       "      <td>0.947879</td>\n",
       "      <td>2.447252</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>자연</td>\n",
       "      <td>자연</td>\n",
       "      <td>정방폭포</td>\n",
       "      <td>126.573050</td>\n",
       "      <td>33.244748</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4427.0</td>\n",
       "      <td>0.092272</td>\n",
       "      <td>0.423816</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.996192</td>\n",
       "      <td>0.356269</td>\n",
       "      <td>0.668634</td>\n",
       "      <td>2.444911</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>테마파크/공연/전시</td>\n",
       "      <td>법화사지</td>\n",
       "      <td>126.457602</td>\n",
       "      <td>33.265327</td>\n",
       "      <td>0.0</td>\n",
       "      <td>201.0</td>\n",
       "      <td>0.579984</td>\n",
       "      <td>0.421622</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.976064</td>\n",
       "      <td>0.016176</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.413862</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>자연</td>\n",
       "      <td>서건도</td>\n",
       "      <td>126.498486</td>\n",
       "      <td>33.230077</td>\n",
       "      <td>0.0</td>\n",
       "      <td>199.0</td>\n",
       "      <td>0.310905</td>\n",
       "      <td>0.448216</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.987169</td>\n",
       "      <td>0.016015</td>\n",
       "      <td>0.931768</td>\n",
       "      <td>2.383168</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>테마파크/공연/전시</td>\n",
       "      <td>외돌개</td>\n",
       "      <td>126.545664</td>\n",
       "      <td>33.240077</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2785.0</td>\n",
       "      <td>0.579984</td>\n",
       "      <td>0.402874</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.976064</td>\n",
       "      <td>0.224127</td>\n",
       "      <td>0.766464</td>\n",
       "      <td>2.369529</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     cluster CL_NM     CAT_PRE   name_PRE         lon        lat  price  \\\n",
       "79         0   NaN          자연       엉또폭포  126.491918  33.258821    0.0   \n",
       "3          0    자연          자연      천지연폭포  126.559551  33.244717    0.0   \n",
       "130        0    쇼핑          시장  서귀포매일올레시장  126.563231  33.250149    0.0   \n",
       "80         0   NaN       레저/체험       영실기암  126.466023  33.278536    0.0   \n",
       "2          0    자연          자연       정방폭포  126.573050  33.244748    0.0   \n",
       "42         0   NaN  테마파크/공연/전시       법화사지  126.457602  33.265327    0.0   \n",
       "50         0   NaN          자연        서건도  126.498486  33.230077    0.0   \n",
       "86         0   NaN  테마파크/공연/전시        외돌개  126.545664  33.240077    0.0   \n",
       "\n",
       "     blog_review_num_list   co2_max  similarity type  eco_YN  co2_rate  \\\n",
       "79                 1864.0  0.032606    0.456621  관광지       0  0.998654   \n",
       "3                  5849.0  0.285718    0.357876  관광지       0  0.988209   \n",
       "130                8349.0  1.124130    0.147991  관광지       0  0.953608   \n",
       "80                  111.0  0.366539    0.505567  관광지       0  0.984873   \n",
       "2                  4427.0  0.092272    0.423816  관광지       0  0.996192   \n",
       "42                  201.0  0.579984    0.421622  관광지       0  0.976064   \n",
       "50                  199.0  0.310905    0.448216  관광지       0  0.987169   \n",
       "86                 2785.0  0.579984    0.402874  관광지       0  0.976064   \n",
       "\n",
       "     review_rate  dist_score  total_score  \n",
       "79      0.150008    0.936069     2.541352  \n",
       "3       0.470707    0.716300     2.533091  \n",
       "130     0.671898    0.701053     2.474549  \n",
       "80      0.008933    0.947879     2.447252  \n",
       "2       0.356269    0.668634     2.444911  \n",
       "42      0.016176    1.000000     2.413862  \n",
       "50      0.016015    0.931768     2.383168  \n",
       "86      0.224127    0.766464     2.369529  "
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data0['total_score'] = data0[[ 'eco_YN', 'review_rate', 'co2_rate','dist_score', 'similarity']].sum(axis=1)\n",
    "data0.sort_values(['total_score'],ascending = False )[:8]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "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>cluster</th>\n",
       "      <th>CL_NM</th>\n",
       "      <th>CAT_PRE</th>\n",
       "      <th>name_PRE</th>\n",
       "      <th>lon</th>\n",
       "      <th>lat</th>\n",
       "      <th>price</th>\n",
       "      <th>blog_review_num_list</th>\n",
       "      <th>co2_max</th>\n",
       "      <th>similarity</th>\n",
       "      <th>type</th>\n",
       "      <th>eco_YN</th>\n",
       "      <th>co2_rate</th>\n",
       "      <th>review_rate</th>\n",
       "      <th>dist_score</th>\n",
       "      <th>total_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>성산일출봉</td>\n",
       "      <td>126.936801</td>\n",
       "      <td>33.462234</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12426.0</td>\n",
       "      <td>0.342912</td>\n",
       "      <td>0.437417</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.985848</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>3.423265</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>테마파크/공연/전시</td>\n",
       "      <td>아쿠아플라넷제주</td>\n",
       "      <td>126.927796</td>\n",
       "      <td>33.432977</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9545.0</td>\n",
       "      <td>0.579984</td>\n",
       "      <td>0.286518</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.976064</td>\n",
       "      <td>0.768147</td>\n",
       "      <td>0.849852</td>\n",
       "      <td>2.880582</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>자연</td>\n",
       "      <td>자연</td>\n",
       "      <td>비자림</td>\n",
       "      <td>126.811461</td>\n",
       "      <td>33.491097</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6956.0</td>\n",
       "      <td>0.244067</td>\n",
       "      <td>0.323949</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.989927</td>\n",
       "      <td>0.559794</td>\n",
       "      <td>0.916615</td>\n",
       "      <td>2.790286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>자연</td>\n",
       "      <td>용눈이오름</td>\n",
       "      <td>126.852054</td>\n",
       "      <td>33.522527</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4008.0</td>\n",
       "      <td>0.310905</td>\n",
       "      <td>0.477971</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.987169</td>\n",
       "      <td>0.322549</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.787690</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>자연</td>\n",
       "      <td>월정리해변</td>\n",
       "      <td>126.798641</td>\n",
       "      <td>33.555113</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6302.0</td>\n",
       "      <td>0.310905</td>\n",
       "      <td>0.288039</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.987169</td>\n",
       "      <td>0.507162</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.782371</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>레저/체험</td>\n",
       "      <td>빠우사</td>\n",
       "      <td>126.711909</td>\n",
       "      <td>33.457740</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.007189</td>\n",
       "      <td>0.089769</td>\n",
       "      <td>관광지</td>\n",
       "      <td>1</td>\n",
       "      <td>0.999703</td>\n",
       "      <td>0.000644</td>\n",
       "      <td>0.668498</td>\n",
       "      <td>2.758614</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>자연</td>\n",
       "      <td>광치기해변</td>\n",
       "      <td>126.922403</td>\n",
       "      <td>33.437021</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3897.0</td>\n",
       "      <td>0.055903</td>\n",
       "      <td>0.472380</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.997693</td>\n",
       "      <td>0.313617</td>\n",
       "      <td>0.864717</td>\n",
       "      <td>2.648407</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>자연</td>\n",
       "      <td>김녕해수욕장</td>\n",
       "      <td>126.736551</td>\n",
       "      <td>33.557208</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4278.0</td>\n",
       "      <td>0.011501</td>\n",
       "      <td>0.265265</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.999525</td>\n",
       "      <td>0.344278</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.609068</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>다랑쉬오름</td>\n",
       "      <td>126.862444</td>\n",
       "      <td>33.521649</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1656.0</td>\n",
       "      <td>0.011491</td>\n",
       "      <td>0.424788</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.999526</td>\n",
       "      <td>0.133269</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.557583</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>자연</td>\n",
       "      <td>자연</td>\n",
       "      <td>만장굴</td>\n",
       "      <td>126.771616</td>\n",
       "      <td>33.528377</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3030.0</td>\n",
       "      <td>0.310905</td>\n",
       "      <td>0.312514</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.987169</td>\n",
       "      <td>0.243844</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.543527</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     cluster CL_NM     CAT_PRE  name_PRE         lon        lat  price  \\\n",
       "84         1   NaN         NaN     성산일출봉  126.936801  33.462234    NaN   \n",
       "110        1   NaN  테마파크/공연/전시  아쿠아플라넷제주  126.927796  33.432977    0.0   \n",
       "4          1    자연          자연       비자림  126.811461  33.491097    0.0   \n",
       "120        1   NaN          자연     용눈이오름  126.852054  33.522527    0.0   \n",
       "130        1   NaN          자연     월정리해변  126.798641  33.555113    0.0   \n",
       "76         1   NaN       레저/체험       빠우사  126.711909  33.457740    0.0   \n",
       "18         1   NaN          자연     광치기해변  126.922403  33.437021    0.0   \n",
       "32         1   NaN          자연    김녕해수욕장  126.736551  33.557208    0.0   \n",
       "41         1   NaN         NaN     다랑쉬오름  126.862444  33.521649    NaN   \n",
       "2          1    자연          자연       만장굴  126.771616  33.528377    0.0   \n",
       "\n",
       "     blog_review_num_list   co2_max  similarity type  eco_YN  co2_rate  \\\n",
       "84                12426.0  0.342912    0.437417  관광지       0  0.985848   \n",
       "110                9545.0  0.579984    0.286518  관광지       0  0.976064   \n",
       "4                  6956.0  0.244067    0.323949  관광지       0  0.989927   \n",
       "120                4008.0  0.310905    0.477971  관광지       0  0.987169   \n",
       "130                6302.0  0.310905    0.288039  관광지       0  0.987169   \n",
       "76                    8.0  0.007189    0.089769  관광지       1  0.999703   \n",
       "18                 3897.0  0.055903    0.472380  관광지       0  0.997693   \n",
       "32                 4278.0  0.011501    0.265265  관광지       0  0.999525   \n",
       "41                 1656.0  0.011491    0.424788  관광지       0  0.999526   \n",
       "2                  3030.0  0.310905    0.312514  관광지       0  0.987169   \n",
       "\n",
       "     review_rate  dist_score  total_score  \n",
       "84      1.000000    1.000000     3.423265  \n",
       "110     0.768147    0.849852     2.880582  \n",
       "4       0.559794    0.916615     2.790286  \n",
       "120     0.322549    1.000000     2.787690  \n",
       "130     0.507162    1.000000     2.782371  \n",
       "76      0.000644    0.668498     2.758614  \n",
       "18      0.313617    0.864717     2.648407  \n",
       "32      0.344278    1.000000     2.609068  \n",
       "41      0.133269    1.000000     2.557583  \n",
       "2       0.243844    1.000000     2.543527  "
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data1['total_score'] = data1[[ 'eco_YN', 'review_rate', 'co2_rate','dist_score', 'similarity']].sum(axis=1)\n",
    "data1.sort_values(['total_score'],ascending = False )[:10]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "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>cluster</th>\n",
       "      <th>CL_NM</th>\n",
       "      <th>CAT_PRE</th>\n",
       "      <th>name_PRE</th>\n",
       "      <th>lon</th>\n",
       "      <th>lat</th>\n",
       "      <th>price</th>\n",
       "      <th>blog_review_num_list</th>\n",
       "      <th>co2_max</th>\n",
       "      <th>similarity</th>\n",
       "      <th>type</th>\n",
       "      <th>eco_YN</th>\n",
       "      <th>co2_rate</th>\n",
       "      <th>review_rate</th>\n",
       "      <th>dist_score</th>\n",
       "      <th>total_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>229</th>\n",
       "      <td>3</td>\n",
       "      <td>쇼핑</td>\n",
       "      <td>특산물</td>\n",
       "      <td>이제주숍</td>\n",
       "      <td>126.540713</td>\n",
       "      <td>33.499434</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>1.241532</td>\n",
       "      <td>0.168371</td>\n",
       "      <td>관광지</td>\n",
       "      <td>1</td>\n",
       "      <td>0.948763</td>\n",
       "      <td>0.001288</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>3.118421</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203</th>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>자연</td>\n",
       "      <td>함덕해수욕장</td>\n",
       "      <td>126.668710</td>\n",
       "      <td>33.543702</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11457.0</td>\n",
       "      <td>0.445751</td>\n",
       "      <td>0.254322</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.981604</td>\n",
       "      <td>0.922018</td>\n",
       "      <td>0.929035</td>\n",
       "      <td>3.086979</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>자연</td>\n",
       "      <td>서우봉</td>\n",
       "      <td>126.677541</td>\n",
       "      <td>33.545364</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11457.0</td>\n",
       "      <td>0.310905</td>\n",
       "      <td>0.185174</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.987169</td>\n",
       "      <td>0.922018</td>\n",
       "      <td>0.912060</td>\n",
       "      <td>3.006422</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>자연</td>\n",
       "      <td>이호테우해수욕장</td>\n",
       "      <td>126.455893</td>\n",
       "      <td>33.496197</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7482.0</td>\n",
       "      <td>0.026778</td>\n",
       "      <td>0.284239</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.998895</td>\n",
       "      <td>0.602125</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.885259</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213</th>\n",
       "      <td>3</td>\n",
       "      <td>쇼핑</td>\n",
       "      <td>시장</td>\n",
       "      <td>동문재래시장</td>\n",
       "      <td>126.526018</td>\n",
       "      <td>33.511590</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5171.0</td>\n",
       "      <td>0.148547</td>\n",
       "      <td>0.290710</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.993870</td>\n",
       "      <td>0.416144</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.700723</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212</th>\n",
       "      <td>3</td>\n",
       "      <td>쇼핑</td>\n",
       "      <td>시장</td>\n",
       "      <td>동문시장</td>\n",
       "      <td>126.528320</td>\n",
       "      <td>33.512797</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5171.0</td>\n",
       "      <td>0.332903</td>\n",
       "      <td>0.292173</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.986261</td>\n",
       "      <td>0.416144</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.694578</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3</td>\n",
       "      <td>공연전시</td>\n",
       "      <td>테마파크/공연/전시</td>\n",
       "      <td>노형수퍼마켙</td>\n",
       "      <td>126.455168</td>\n",
       "      <td>33.464942</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2161.0</td>\n",
       "      <td>0.403384</td>\n",
       "      <td>0.508015</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.983353</td>\n",
       "      <td>0.173910</td>\n",
       "      <td>0.996166</td>\n",
       "      <td>2.661444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199</th>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>자연</td>\n",
       "      <td>한라수목원</td>\n",
       "      <td>126.493244</td>\n",
       "      <td>33.469587</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2528.0</td>\n",
       "      <td>0.038668</td>\n",
       "      <td>0.458861</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.998404</td>\n",
       "      <td>0.203444</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.660709</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     cluster CL_NM     CAT_PRE  name_PRE         lon        lat  price  \\\n",
       "229        3    쇼핑         특산물      이제주숍  126.540713  33.499434    0.0   \n",
       "203        3   NaN          자연    함덕해수욕장  126.668710  33.543702    0.0   \n",
       "84         3   NaN          자연       서우봉  126.677541  33.545364    0.0   \n",
       "128        3   NaN          자연  이호테우해수욕장  126.455893  33.496197    0.0   \n",
       "213        3    쇼핑          시장    동문재래시장  126.526018  33.511590    0.0   \n",
       "212        3    쇼핑          시장      동문시장  126.528320  33.512797    0.0   \n",
       "0          3  공연전시  테마파크/공연/전시    노형수퍼마켙  126.455168  33.464942    0.0   \n",
       "199        3   NaN          자연     한라수목원  126.493244  33.469587    0.0   \n",
       "\n",
       "     blog_review_num_list   co2_max  similarity type  eco_YN  co2_rate  \\\n",
       "229                  16.0  1.241532    0.168371  관광지       1  0.948763   \n",
       "203               11457.0  0.445751    0.254322  관광지       0  0.981604   \n",
       "84                11457.0  0.310905    0.185174  관광지       0  0.987169   \n",
       "128                7482.0  0.026778    0.284239  관광지       0  0.998895   \n",
       "213                5171.0  0.148547    0.290710  관광지       0  0.993870   \n",
       "212                5171.0  0.332903    0.292173  관광지       0  0.986261   \n",
       "0                  2161.0  0.403384    0.508015  관광지       0  0.983353   \n",
       "199                2528.0  0.038668    0.458861  관광지       0  0.998404   \n",
       "\n",
       "     review_rate  dist_score  total_score  \n",
       "229     0.001288    1.000000     3.118421  \n",
       "203     0.922018    0.929035     3.086979  \n",
       "84      0.922018    0.912060     3.006422  \n",
       "128     0.602125    1.000000     2.885259  \n",
       "213     0.416144    1.000000     2.700723  \n",
       "212     0.416144    1.000000     2.694578  \n",
       "0       0.173910    0.996166     2.661444  \n",
       "199     0.203444    1.000000     2.660709  "
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data3['total_score'] = data3[[ 'eco_YN', 'review_rate', 'co2_rate','dist_score', 'similarity']].sum(axis=1)\n",
    "data3.sort_values(['total_score'],ascending = False )[:8]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "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>cluster</th>\n",
       "      <th>CL_NM</th>\n",
       "      <th>CAT_PRE</th>\n",
       "      <th>name_PRE</th>\n",
       "      <th>lon</th>\n",
       "      <th>lat</th>\n",
       "      <th>price</th>\n",
       "      <th>blog_review_num_list</th>\n",
       "      <th>co2_max</th>\n",
       "      <th>similarity</th>\n",
       "      <th>type</th>\n",
       "      <th>eco_YN</th>\n",
       "      <th>co2_rate</th>\n",
       "      <th>review_rate</th>\n",
       "      <th>dist_score</th>\n",
       "      <th>total_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>4</td>\n",
       "      <td>테마관광지</td>\n",
       "      <td>테마파크/공연/전시</td>\n",
       "      <td>오설록티뮤지엄</td>\n",
       "      <td>126.289492</td>\n",
       "      <td>33.305924</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12150.0</td>\n",
       "      <td>0.579984</td>\n",
       "      <td>0.514570</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.976064</td>\n",
       "      <td>0.977789</td>\n",
       "      <td>0.860480</td>\n",
       "      <td>3.328902</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>4</td>\n",
       "      <td>자연</td>\n",
       "      <td>자연</td>\n",
       "      <td>용머리해안</td>\n",
       "      <td>126.314631</td>\n",
       "      <td>33.233482</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4825.0</td>\n",
       "      <td>0.005309</td>\n",
       "      <td>0.139690</td>\n",
       "      <td>관광지</td>\n",
       "      <td>1</td>\n",
       "      <td>0.999781</td>\n",
       "      <td>0.388299</td>\n",
       "      <td>0.532287</td>\n",
       "      <td>3.060057</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>4</td>\n",
       "      <td>테마파크</td>\n",
       "      <td>자연</td>\n",
       "      <td>카멜리아힐</td>\n",
       "      <td>126.368365</td>\n",
       "      <td>33.290140</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9932.0</td>\n",
       "      <td>0.170725</td>\n",
       "      <td>0.479790</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.992954</td>\n",
       "      <td>0.799292</td>\n",
       "      <td>0.776417</td>\n",
       "      <td>3.048453</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>4</td>\n",
       "      <td>테마관광지</td>\n",
       "      <td>테마파크/공연/전시</td>\n",
       "      <td>제주유리의성</td>\n",
       "      <td>126.273662</td>\n",
       "      <td>33.314634</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2154.0</td>\n",
       "      <td>1.294855</td>\n",
       "      <td>0.529019</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.946562</td>\n",
       "      <td>0.173346</td>\n",
       "      <td>0.898872</td>\n",
       "      <td>2.547799</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>테마파크/공연/전시</td>\n",
       "      <td>제주항공우주박물관</td>\n",
       "      <td>126.299662</td>\n",
       "      <td>33.304207</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2552.0</td>\n",
       "      <td>0.579984</td>\n",
       "      <td>0.477731</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.976064</td>\n",
       "      <td>0.205376</td>\n",
       "      <td>0.852704</td>\n",
       "      <td>2.511875</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>테마파크/공연/전시</td>\n",
       "      <td>세계자동차피아노박물관</td>\n",
       "      <td>126.349010</td>\n",
       "      <td>33.282942</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3329.0</td>\n",
       "      <td>0.018790</td>\n",
       "      <td>0.493337</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.999225</td>\n",
       "      <td>0.267906</td>\n",
       "      <td>0.749763</td>\n",
       "      <td>2.510231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>4</td>\n",
       "      <td>공연전시</td>\n",
       "      <td>테마파크/공연/전시</td>\n",
       "      <td>헬로키티아일랜드</td>\n",
       "      <td>126.352081</td>\n",
       "      <td>33.290100</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2436.0</td>\n",
       "      <td>0.606763</td>\n",
       "      <td>0.529560</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.974959</td>\n",
       "      <td>0.196041</td>\n",
       "      <td>0.781227</td>\n",
       "      <td>2.481787</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>테마파크/공연/전시</td>\n",
       "      <td>본태박물관</td>\n",
       "      <td>126.392568</td>\n",
       "      <td>33.303955</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1933.0</td>\n",
       "      <td>0.505897</td>\n",
       "      <td>0.487227</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.979122</td>\n",
       "      <td>0.155561</td>\n",
       "      <td>0.828704</td>\n",
       "      <td>2.450613</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>테마파크/공연/전시</td>\n",
       "      <td>토이파크</td>\n",
       "      <td>126.345363</td>\n",
       "      <td>33.318960</td>\n",
       "      <td>0.0</td>\n",
       "      <td>209.0</td>\n",
       "      <td>0.084316</td>\n",
       "      <td>0.511035</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.996520</td>\n",
       "      <td>0.016820</td>\n",
       "      <td>0.913071</td>\n",
       "      <td>2.437446</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>테마관광지</td>\n",
       "      <td>테마파크/공연/전시</td>\n",
       "      <td>소인국테마파크</td>\n",
       "      <td>126.322195</td>\n",
       "      <td>33.290645</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1655.0</td>\n",
       "      <td>0.066130</td>\n",
       "      <td>0.486114</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.997271</td>\n",
       "      <td>0.133188</td>\n",
       "      <td>0.789663</td>\n",
       "      <td>2.406237</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     cluster  CL_NM     CAT_PRE     name_PRE         lon        lat  price  \\\n",
       "7          4  테마관광지  테마파크/공연/전시      오설록티뮤지엄  126.289492  33.305924    0.0   \n",
       "8          4     자연          자연        용머리해안  126.314631  33.233482    0.0   \n",
       "14         4   테마파크          자연        카멜리아힐  126.368365  33.290140    0.0   \n",
       "11         4  테마관광지  테마파크/공연/전시       제주유리의성  126.273662  33.314634    0.0   \n",
       "122        4    NaN  테마파크/공연/전시    제주항공우주박물관  126.299662  33.304207    0.0   \n",
       "78         4    NaN  테마파크/공연/전시  세계자동차피아노박물관  126.349010  33.282942    0.0   \n",
       "17         4   공연전시  테마파크/공연/전시     헬로키티아일랜드  126.352081  33.290100    0.0   \n",
       "65         4    NaN  테마파크/공연/전시        본태박물관  126.392568  33.303955    0.0   \n",
       "144        4    NaN  테마파크/공연/전시         토이파크  126.345363  33.318960    0.0   \n",
       "3          4  테마관광지  테마파크/공연/전시      소인국테마파크  126.322195  33.290645    0.0   \n",
       "\n",
       "     blog_review_num_list   co2_max  similarity type  eco_YN  co2_rate  \\\n",
       "7                 12150.0  0.579984    0.514570  관광지       0  0.976064   \n",
       "8                  4825.0  0.005309    0.139690  관광지       1  0.999781   \n",
       "14                 9932.0  0.170725    0.479790  관광지       0  0.992954   \n",
       "11                 2154.0  1.294855    0.529019  관광지       0  0.946562   \n",
       "122                2552.0  0.579984    0.477731  관광지       0  0.976064   \n",
       "78                 3329.0  0.018790    0.493337  관광지       0  0.999225   \n",
       "17                 2436.0  0.606763    0.529560  관광지       0  0.974959   \n",
       "65                 1933.0  0.505897    0.487227  관광지       0  0.979122   \n",
       "144                 209.0  0.084316    0.511035  관광지       0  0.996520   \n",
       "3                  1655.0  0.066130    0.486114  관광지       0  0.997271   \n",
       "\n",
       "     review_rate  dist_score  total_score  \n",
       "7       0.977789    0.860480     3.328902  \n",
       "8       0.388299    0.532287     3.060057  \n",
       "14      0.799292    0.776417     3.048453  \n",
       "11      0.173346    0.898872     2.547799  \n",
       "122     0.205376    0.852704     2.511875  \n",
       "78      0.267906    0.749763     2.510231  \n",
       "17      0.196041    0.781227     2.481787  \n",
       "65      0.155561    0.828704     2.450613  \n",
       "144     0.016820    0.913071     2.437446  \n",
       "3       0.133188    0.789663     2.406237  "
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data4['total_score'] = data4[[ 'eco_YN', 'review_rate', 'co2_rate','dist_score', 'similarity']].sum(axis=1)\n",
    "data4.sort_values(['total_score'],ascending = False )[:10]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "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>cluster</th>\n",
       "      <th>CL_NM</th>\n",
       "      <th>CAT_PRE</th>\n",
       "      <th>name_PRE</th>\n",
       "      <th>lon</th>\n",
       "      <th>lat</th>\n",
       "      <th>price</th>\n",
       "      <th>blog_review_num_list</th>\n",
       "      <th>co2_max</th>\n",
       "      <th>similarity</th>\n",
       "      <th>type</th>\n",
       "      <th>eco_YN</th>\n",
       "      <th>co2_rate</th>\n",
       "      <th>review_rate</th>\n",
       "      <th>dist_score</th>\n",
       "      <th>total_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>5</td>\n",
       "      <td>쇼핑</td>\n",
       "      <td>기념품/소품</td>\n",
       "      <td>베리제주</td>\n",
       "      <td>126.336327</td>\n",
       "      <td>33.466620</td>\n",
       "      <td>0.0</td>\n",
       "      <td>431.0</td>\n",
       "      <td>0.118939</td>\n",
       "      <td>0.257585</td>\n",
       "      <td>관광지</td>\n",
       "      <td>1</td>\n",
       "      <td>0.995091</td>\n",
       "      <td>0.034685</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>3.287361</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>자연</td>\n",
       "      <td>협재해수욕장</td>\n",
       "      <td>126.239432</td>\n",
       "      <td>33.393748</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10708.0</td>\n",
       "      <td>0.310905</td>\n",
       "      <td>0.399303</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.987169</td>\n",
       "      <td>0.861742</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>3.248214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>레저/체험</td>\n",
       "      <td>물뫼힐링팜</td>\n",
       "      <td>126.396556</td>\n",
       "      <td>33.464249</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.366539</td>\n",
       "      <td>0.147966</td>\n",
       "      <td>관광지</td>\n",
       "      <td>1</td>\n",
       "      <td>0.984873</td>\n",
       "      <td>0.001207</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>3.134046</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>자연</td>\n",
       "      <td>곽지해수욕장</td>\n",
       "      <td>126.328973</td>\n",
       "      <td>33.462191</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4790.0</td>\n",
       "      <td>0.310905</td>\n",
       "      <td>0.399303</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.987169</td>\n",
       "      <td>0.385482</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.771955</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>자연</td>\n",
       "      <td>금능해수욕장</td>\n",
       "      <td>126.236205</td>\n",
       "      <td>33.390401</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4601.0</td>\n",
       "      <td>0.058375</td>\n",
       "      <td>0.385068</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.997591</td>\n",
       "      <td>0.370272</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.752931</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>자연</td>\n",
       "      <td>수월봉</td>\n",
       "      <td>126.163419</td>\n",
       "      <td>33.294765</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1993.0</td>\n",
       "      <td>0.310905</td>\n",
       "      <td>0.508712</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.987169</td>\n",
       "      <td>0.160390</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.656270</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>테마파크/공연/전시</td>\n",
       "      <td>신창풍차해안도로</td>\n",
       "      <td>126.173909</td>\n",
       "      <td>33.343429</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3043.0</td>\n",
       "      <td>0.579984</td>\n",
       "      <td>0.383931</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.976064</td>\n",
       "      <td>0.244890</td>\n",
       "      <td>0.947761</td>\n",
       "      <td>2.552647</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>5</td>\n",
       "      <td>자연</td>\n",
       "      <td>자연</td>\n",
       "      <td>생각하는정원</td>\n",
       "      <td>126.255005</td>\n",
       "      <td>33.325584</td>\n",
       "      <td>0.0</td>\n",
       "      <td>972.0</td>\n",
       "      <td>0.592651</td>\n",
       "      <td>0.478092</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.975542</td>\n",
       "      <td>0.078223</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.531857</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>테마관광지</td>\n",
       "      <td>자연</td>\n",
       "      <td>한림공원</td>\n",
       "      <td>126.239691</td>\n",
       "      <td>33.390225</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3805.0</td>\n",
       "      <td>0.866233</td>\n",
       "      <td>0.234355</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.964251</td>\n",
       "      <td>0.306213</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.504819</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>5</td>\n",
       "      <td>테마파크</td>\n",
       "      <td>테마파크/공연/전시</td>\n",
       "      <td>더마파크</td>\n",
       "      <td>126.241505</td>\n",
       "      <td>33.355539</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1051.0</td>\n",
       "      <td>0.579984</td>\n",
       "      <td>0.423124</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.976064</td>\n",
       "      <td>0.084581</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.483769</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     cluster  CL_NM     CAT_PRE  name_PRE         lon        lat  price  \\\n",
       "134        5     쇼핑      기념품/소품      베리제주  126.336327  33.466620    0.0   \n",
       "127        5    NaN          자연    협재해수욕장  126.239432  33.393748    0.0   \n",
       "45         5    NaN       레저/체험     물뫼힐링팜  126.396556  33.464249    0.0   \n",
       "11         5    NaN          자연    곽지해수욕장  126.328973  33.462191    0.0   \n",
       "18         5    NaN          자연    금능해수욕장  126.236205  33.390401    0.0   \n",
       "60         5    NaN          자연       수월봉  126.163419  33.294765    0.0   \n",
       "66         5    NaN  테마파크/공연/전시  신창풍차해안도로  126.173909  33.343429    0.0   \n",
       "2          5     자연          자연    생각하는정원  126.255005  33.325584    0.0   \n",
       "5          5  테마관광지          자연      한림공원  126.239691  33.390225    0.0   \n",
       "0          5   테마파크  테마파크/공연/전시      더마파크  126.241505  33.355539    0.0   \n",
       "\n",
       "     blog_review_num_list   co2_max  similarity type  eco_YN  co2_rate  \\\n",
       "134                 431.0  0.118939    0.257585  관광지       1  0.995091   \n",
       "127               10708.0  0.310905    0.399303  관광지       0  0.987169   \n",
       "45                   15.0  0.366539    0.147966  관광지       1  0.984873   \n",
       "11                 4790.0  0.310905    0.399303  관광지       0  0.987169   \n",
       "18                 4601.0  0.058375    0.385068  관광지       0  0.997591   \n",
       "60                 1993.0  0.310905    0.508712  관광지       0  0.987169   \n",
       "66                 3043.0  0.579984    0.383931  관광지       0  0.976064   \n",
       "2                   972.0  0.592651    0.478092  관광지       0  0.975542   \n",
       "5                  3805.0  0.866233    0.234355  관광지       0  0.964251   \n",
       "0                  1051.0  0.579984    0.423124  관광지       0  0.976064   \n",
       "\n",
       "     review_rate  dist_score  total_score  \n",
       "134     0.034685    1.000000     3.287361  \n",
       "127     0.861742    1.000000     3.248214  \n",
       "45      0.001207    1.000000     3.134046  \n",
       "11      0.385482    1.000000     2.771955  \n",
       "18      0.370272    1.000000     2.752931  \n",
       "60      0.160390    1.000000     2.656270  \n",
       "66      0.244890    0.947761     2.552647  \n",
       "2       0.078223    1.000000     2.531857  \n",
       "5       0.306213    1.000000     2.504819  \n",
       "0       0.084581    1.000000     2.483769  "
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data5['total_score'] = data5[[ 'eco_YN', 'review_rate', 'co2_rate','dist_score', 'similarity']].sum(axis=1)\n",
    "data5.sort_values(['total_score'],ascending = False )[:10]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "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>cluster</th>\n",
       "      <th>CL_NM</th>\n",
       "      <th>CAT_PRE</th>\n",
       "      <th>name_PRE</th>\n",
       "      <th>lon</th>\n",
       "      <th>lat</th>\n",
       "      <th>price</th>\n",
       "      <th>blog_review_num_list</th>\n",
       "      <th>co2_max</th>\n",
       "      <th>similarity</th>\n",
       "      <th>type</th>\n",
       "      <th>eco_YN</th>\n",
       "      <th>co2_rate</th>\n",
       "      <th>review_rate</th>\n",
       "      <th>dist_score</th>\n",
       "      <th>total_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>자연</td>\n",
       "      <td>엉또폭포</td>\n",
       "      <td>126.491918</td>\n",
       "      <td>33.258821</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1864.0</td>\n",
       "      <td>0.032606</td>\n",
       "      <td>0.456621</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.998654</td>\n",
       "      <td>0.150008</td>\n",
       "      <td>0.936069</td>\n",
       "      <td>2.541352</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0</td>\n",
       "      <td>자연</td>\n",
       "      <td>자연</td>\n",
       "      <td>천지연폭포</td>\n",
       "      <td>126.559551</td>\n",
       "      <td>33.244717</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5849.0</td>\n",
       "      <td>0.285718</td>\n",
       "      <td>0.357876</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.988209</td>\n",
       "      <td>0.470707</td>\n",
       "      <td>0.716300</td>\n",
       "      <td>2.533091</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>0</td>\n",
       "      <td>쇼핑</td>\n",
       "      <td>시장</td>\n",
       "      <td>서귀포매일올레시장</td>\n",
       "      <td>126.563231</td>\n",
       "      <td>33.250149</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8349.0</td>\n",
       "      <td>1.124130</td>\n",
       "      <td>0.147991</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.953608</td>\n",
       "      <td>0.671898</td>\n",
       "      <td>0.701053</td>\n",
       "      <td>2.474549</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>레저/체험</td>\n",
       "      <td>영실기암</td>\n",
       "      <td>126.466023</td>\n",
       "      <td>33.278536</td>\n",
       "      <td>0.0</td>\n",
       "      <td>111.0</td>\n",
       "      <td>0.366539</td>\n",
       "      <td>0.505567</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.984873</td>\n",
       "      <td>0.008933</td>\n",
       "      <td>0.947879</td>\n",
       "      <td>2.447252</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>자연</td>\n",
       "      <td>자연</td>\n",
       "      <td>정방폭포</td>\n",
       "      <td>126.573050</td>\n",
       "      <td>33.244748</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4427.0</td>\n",
       "      <td>0.092272</td>\n",
       "      <td>0.423816</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.996192</td>\n",
       "      <td>0.356269</td>\n",
       "      <td>0.668634</td>\n",
       "      <td>2.444911</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>테마파크/공연/전시</td>\n",
       "      <td>법화사지</td>\n",
       "      <td>126.457602</td>\n",
       "      <td>33.265327</td>\n",
       "      <td>0.0</td>\n",
       "      <td>201.0</td>\n",
       "      <td>0.579984</td>\n",
       "      <td>0.421622</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.976064</td>\n",
       "      <td>0.016176</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.413862</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>자연</td>\n",
       "      <td>서건도</td>\n",
       "      <td>126.498486</td>\n",
       "      <td>33.230077</td>\n",
       "      <td>0.0</td>\n",
       "      <td>199.0</td>\n",
       "      <td>0.310905</td>\n",
       "      <td>0.448216</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.987169</td>\n",
       "      <td>0.016015</td>\n",
       "      <td>0.931768</td>\n",
       "      <td>2.383168</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>테마파크/공연/전시</td>\n",
       "      <td>외돌개</td>\n",
       "      <td>126.545664</td>\n",
       "      <td>33.240077</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2785.0</td>\n",
       "      <td>0.579984</td>\n",
       "      <td>0.402874</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.976064</td>\n",
       "      <td>0.224127</td>\n",
       "      <td>0.766464</td>\n",
       "      <td>2.369529</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>성산일출봉</td>\n",
       "      <td>126.936801</td>\n",
       "      <td>33.462234</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12426.0</td>\n",
       "      <td>0.342912</td>\n",
       "      <td>0.437417</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.985848</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>3.423265</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>테마파크/공연/전시</td>\n",
       "      <td>아쿠아플라넷제주</td>\n",
       "      <td>126.927796</td>\n",
       "      <td>33.432977</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9545.0</td>\n",
       "      <td>0.579984</td>\n",
       "      <td>0.286518</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.976064</td>\n",
       "      <td>0.768147</td>\n",
       "      <td>0.849852</td>\n",
       "      <td>2.880582</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>자연</td>\n",
       "      <td>자연</td>\n",
       "      <td>비자림</td>\n",
       "      <td>126.811461</td>\n",
       "      <td>33.491097</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6956.0</td>\n",
       "      <td>0.244067</td>\n",
       "      <td>0.323949</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.989927</td>\n",
       "      <td>0.559794</td>\n",
       "      <td>0.916615</td>\n",
       "      <td>2.790286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>자연</td>\n",
       "      <td>용눈이오름</td>\n",
       "      <td>126.852054</td>\n",
       "      <td>33.522527</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4008.0</td>\n",
       "      <td>0.310905</td>\n",
       "      <td>0.477971</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.987169</td>\n",
       "      <td>0.322549</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.787690</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>자연</td>\n",
       "      <td>월정리해변</td>\n",
       "      <td>126.798641</td>\n",
       "      <td>33.555113</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6302.0</td>\n",
       "      <td>0.310905</td>\n",
       "      <td>0.288039</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.987169</td>\n",
       "      <td>0.507162</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.782371</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>레저/체험</td>\n",
       "      <td>빠우사</td>\n",
       "      <td>126.711909</td>\n",
       "      <td>33.457740</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.007189</td>\n",
       "      <td>0.089769</td>\n",
       "      <td>관광지</td>\n",
       "      <td>1</td>\n",
       "      <td>0.999703</td>\n",
       "      <td>0.000644</td>\n",
       "      <td>0.668498</td>\n",
       "      <td>2.758614</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>자연</td>\n",
       "      <td>광치기해변</td>\n",
       "      <td>126.922403</td>\n",
       "      <td>33.437021</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3897.0</td>\n",
       "      <td>0.055903</td>\n",
       "      <td>0.472380</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.997693</td>\n",
       "      <td>0.313617</td>\n",
       "      <td>0.864717</td>\n",
       "      <td>2.648407</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>자연</td>\n",
       "      <td>김녕해수욕장</td>\n",
       "      <td>126.736551</td>\n",
       "      <td>33.557208</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4278.0</td>\n",
       "      <td>0.011501</td>\n",
       "      <td>0.265265</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.999525</td>\n",
       "      <td>0.344278</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.609068</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>다랑쉬오름</td>\n",
       "      <td>126.862444</td>\n",
       "      <td>33.521649</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1656.0</td>\n",
       "      <td>0.011491</td>\n",
       "      <td>0.424788</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.999526</td>\n",
       "      <td>0.133269</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.557583</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>자연</td>\n",
       "      <td>자연</td>\n",
       "      <td>만장굴</td>\n",
       "      <td>126.771616</td>\n",
       "      <td>33.528377</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3030.0</td>\n",
       "      <td>0.310905</td>\n",
       "      <td>0.312514</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.987169</td>\n",
       "      <td>0.243844</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.543527</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229</th>\n",
       "      <td>3</td>\n",
       "      <td>쇼핑</td>\n",
       "      <td>특산물</td>\n",
       "      <td>이제주숍</td>\n",
       "      <td>126.540713</td>\n",
       "      <td>33.499434</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>1.241532</td>\n",
       "      <td>0.168371</td>\n",
       "      <td>관광지</td>\n",
       "      <td>1</td>\n",
       "      <td>0.948763</td>\n",
       "      <td>0.001288</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>3.118421</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203</th>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>자연</td>\n",
       "      <td>함덕해수욕장</td>\n",
       "      <td>126.668710</td>\n",
       "      <td>33.543702</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11457.0</td>\n",
       "      <td>0.445751</td>\n",
       "      <td>0.254322</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.981604</td>\n",
       "      <td>0.922018</td>\n",
       "      <td>0.929035</td>\n",
       "      <td>3.086979</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>자연</td>\n",
       "      <td>서우봉</td>\n",
       "      <td>126.677541</td>\n",
       "      <td>33.545364</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11457.0</td>\n",
       "      <td>0.310905</td>\n",
       "      <td>0.185174</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.987169</td>\n",
       "      <td>0.922018</td>\n",
       "      <td>0.912060</td>\n",
       "      <td>3.006422</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>자연</td>\n",
       "      <td>이호테우해수욕장</td>\n",
       "      <td>126.455893</td>\n",
       "      <td>33.496197</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7482.0</td>\n",
       "      <td>0.026778</td>\n",
       "      <td>0.284239</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.998895</td>\n",
       "      <td>0.602125</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.885259</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213</th>\n",
       "      <td>3</td>\n",
       "      <td>쇼핑</td>\n",
       "      <td>시장</td>\n",
       "      <td>동문재래시장</td>\n",
       "      <td>126.526018</td>\n",
       "      <td>33.511590</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5171.0</td>\n",
       "      <td>0.148547</td>\n",
       "      <td>0.290710</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.993870</td>\n",
       "      <td>0.416144</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.700723</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212</th>\n",
       "      <td>3</td>\n",
       "      <td>쇼핑</td>\n",
       "      <td>시장</td>\n",
       "      <td>동문시장</td>\n",
       "      <td>126.528320</td>\n",
       "      <td>33.512797</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5171.0</td>\n",
       "      <td>0.332903</td>\n",
       "      <td>0.292173</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.986261</td>\n",
       "      <td>0.416144</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.694578</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3</td>\n",
       "      <td>공연전시</td>\n",
       "      <td>테마파크/공연/전시</td>\n",
       "      <td>노형수퍼마켙</td>\n",
       "      <td>126.455168</td>\n",
       "      <td>33.464942</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2161.0</td>\n",
       "      <td>0.403384</td>\n",
       "      <td>0.508015</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.983353</td>\n",
       "      <td>0.173910</td>\n",
       "      <td>0.996166</td>\n",
       "      <td>2.661444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199</th>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>자연</td>\n",
       "      <td>한라수목원</td>\n",
       "      <td>126.493244</td>\n",
       "      <td>33.469587</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2528.0</td>\n",
       "      <td>0.038668</td>\n",
       "      <td>0.458861</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.998404</td>\n",
       "      <td>0.203444</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.660709</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>4</td>\n",
       "      <td>테마관광지</td>\n",
       "      <td>테마파크/공연/전시</td>\n",
       "      <td>오설록티뮤지엄</td>\n",
       "      <td>126.289492</td>\n",
       "      <td>33.305924</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12150.0</td>\n",
       "      <td>0.579984</td>\n",
       "      <td>0.514570</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.976064</td>\n",
       "      <td>0.977789</td>\n",
       "      <td>0.860480</td>\n",
       "      <td>3.328902</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>4</td>\n",
       "      <td>자연</td>\n",
       "      <td>자연</td>\n",
       "      <td>용머리해안</td>\n",
       "      <td>126.314631</td>\n",
       "      <td>33.233482</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4825.0</td>\n",
       "      <td>0.005309</td>\n",
       "      <td>0.139690</td>\n",
       "      <td>관광지</td>\n",
       "      <td>1</td>\n",
       "      <td>0.999781</td>\n",
       "      <td>0.388299</td>\n",
       "      <td>0.532287</td>\n",
       "      <td>3.060057</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>4</td>\n",
       "      <td>테마파크</td>\n",
       "      <td>자연</td>\n",
       "      <td>카멜리아힐</td>\n",
       "      <td>126.368365</td>\n",
       "      <td>33.290140</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9932.0</td>\n",
       "      <td>0.170725</td>\n",
       "      <td>0.479790</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.992954</td>\n",
       "      <td>0.799292</td>\n",
       "      <td>0.776417</td>\n",
       "      <td>3.048453</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>4</td>\n",
       "      <td>테마관광지</td>\n",
       "      <td>테마파크/공연/전시</td>\n",
       "      <td>제주유리의성</td>\n",
       "      <td>126.273662</td>\n",
       "      <td>33.314634</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2154.0</td>\n",
       "      <td>1.294855</td>\n",
       "      <td>0.529019</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.946562</td>\n",
       "      <td>0.173346</td>\n",
       "      <td>0.898872</td>\n",
       "      <td>2.547799</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>테마파크/공연/전시</td>\n",
       "      <td>제주항공우주박물관</td>\n",
       "      <td>126.299662</td>\n",
       "      <td>33.304207</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2552.0</td>\n",
       "      <td>0.579984</td>\n",
       "      <td>0.477731</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.976064</td>\n",
       "      <td>0.205376</td>\n",
       "      <td>0.852704</td>\n",
       "      <td>2.511875</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>테마파크/공연/전시</td>\n",
       "      <td>세계자동차피아노박물관</td>\n",
       "      <td>126.349010</td>\n",
       "      <td>33.282942</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3329.0</td>\n",
       "      <td>0.018790</td>\n",
       "      <td>0.493337</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.999225</td>\n",
       "      <td>0.267906</td>\n",
       "      <td>0.749763</td>\n",
       "      <td>2.510231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>4</td>\n",
       "      <td>공연전시</td>\n",
       "      <td>테마파크/공연/전시</td>\n",
       "      <td>헬로키티아일랜드</td>\n",
       "      <td>126.352081</td>\n",
       "      <td>33.290100</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2436.0</td>\n",
       "      <td>0.606763</td>\n",
       "      <td>0.529560</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.974959</td>\n",
       "      <td>0.196041</td>\n",
       "      <td>0.781227</td>\n",
       "      <td>2.481787</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>테마파크/공연/전시</td>\n",
       "      <td>본태박물관</td>\n",
       "      <td>126.392568</td>\n",
       "      <td>33.303955</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1933.0</td>\n",
       "      <td>0.505897</td>\n",
       "      <td>0.487227</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.979122</td>\n",
       "      <td>0.155561</td>\n",
       "      <td>0.828704</td>\n",
       "      <td>2.450613</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>테마파크/공연/전시</td>\n",
       "      <td>토이파크</td>\n",
       "      <td>126.345363</td>\n",
       "      <td>33.318960</td>\n",
       "      <td>0.0</td>\n",
       "      <td>209.0</td>\n",
       "      <td>0.084316</td>\n",
       "      <td>0.511035</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.996520</td>\n",
       "      <td>0.016820</td>\n",
       "      <td>0.913071</td>\n",
       "      <td>2.437446</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>테마관광지</td>\n",
       "      <td>테마파크/공연/전시</td>\n",
       "      <td>소인국테마파크</td>\n",
       "      <td>126.322195</td>\n",
       "      <td>33.290645</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1655.0</td>\n",
       "      <td>0.066130</td>\n",
       "      <td>0.486114</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.997271</td>\n",
       "      <td>0.133188</td>\n",
       "      <td>0.789663</td>\n",
       "      <td>2.406237</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>5</td>\n",
       "      <td>쇼핑</td>\n",
       "      <td>기념품/소품</td>\n",
       "      <td>베리제주</td>\n",
       "      <td>126.336327</td>\n",
       "      <td>33.466620</td>\n",
       "      <td>0.0</td>\n",
       "      <td>431.0</td>\n",
       "      <td>0.118939</td>\n",
       "      <td>0.257585</td>\n",
       "      <td>관광지</td>\n",
       "      <td>1</td>\n",
       "      <td>0.995091</td>\n",
       "      <td>0.034685</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>3.287361</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>자연</td>\n",
       "      <td>협재해수욕장</td>\n",
       "      <td>126.239432</td>\n",
       "      <td>33.393748</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10708.0</td>\n",
       "      <td>0.310905</td>\n",
       "      <td>0.399303</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.987169</td>\n",
       "      <td>0.861742</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>3.248214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>레저/체험</td>\n",
       "      <td>물뫼힐링팜</td>\n",
       "      <td>126.396556</td>\n",
       "      <td>33.464249</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.366539</td>\n",
       "      <td>0.147966</td>\n",
       "      <td>관광지</td>\n",
       "      <td>1</td>\n",
       "      <td>0.984873</td>\n",
       "      <td>0.001207</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>3.134046</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>자연</td>\n",
       "      <td>곽지해수욕장</td>\n",
       "      <td>126.328973</td>\n",
       "      <td>33.462191</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4790.0</td>\n",
       "      <td>0.310905</td>\n",
       "      <td>0.399303</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.987169</td>\n",
       "      <td>0.385482</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.771955</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>자연</td>\n",
       "      <td>금능해수욕장</td>\n",
       "      <td>126.236205</td>\n",
       "      <td>33.390401</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4601.0</td>\n",
       "      <td>0.058375</td>\n",
       "      <td>0.385068</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.997591</td>\n",
       "      <td>0.370272</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.752931</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>자연</td>\n",
       "      <td>수월봉</td>\n",
       "      <td>126.163419</td>\n",
       "      <td>33.294765</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1993.0</td>\n",
       "      <td>0.310905</td>\n",
       "      <td>0.508712</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.987169</td>\n",
       "      <td>0.160390</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.656270</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>테마파크/공연/전시</td>\n",
       "      <td>신창풍차해안도로</td>\n",
       "      <td>126.173909</td>\n",
       "      <td>33.343429</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3043.0</td>\n",
       "      <td>0.579984</td>\n",
       "      <td>0.383931</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.976064</td>\n",
       "      <td>0.244890</td>\n",
       "      <td>0.947761</td>\n",
       "      <td>2.552647</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>5</td>\n",
       "      <td>자연</td>\n",
       "      <td>자연</td>\n",
       "      <td>생각하는정원</td>\n",
       "      <td>126.255005</td>\n",
       "      <td>33.325584</td>\n",
       "      <td>0.0</td>\n",
       "      <td>972.0</td>\n",
       "      <td>0.592651</td>\n",
       "      <td>0.478092</td>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>0.975542</td>\n",
       "      <td>0.078223</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.531857</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     cluster  CL_NM     CAT_PRE     name_PRE         lon        lat  price  \\\n",
       "79         0    NaN          자연         엉또폭포  126.491918  33.258821    0.0   \n",
       "3          0     자연          자연        천지연폭포  126.559551  33.244717    0.0   \n",
       "130        0     쇼핑          시장    서귀포매일올레시장  126.563231  33.250149    0.0   \n",
       "80         0    NaN       레저/체험         영실기암  126.466023  33.278536    0.0   \n",
       "2          0     자연          자연         정방폭포  126.573050  33.244748    0.0   \n",
       "42         0    NaN  테마파크/공연/전시         법화사지  126.457602  33.265327    0.0   \n",
       "50         0    NaN          자연          서건도  126.498486  33.230077    0.0   \n",
       "86         0    NaN  테마파크/공연/전시          외돌개  126.545664  33.240077    0.0   \n",
       "84         1    NaN         NaN        성산일출봉  126.936801  33.462234    NaN   \n",
       "110        1    NaN  테마파크/공연/전시     아쿠아플라넷제주  126.927796  33.432977    0.0   \n",
       "4          1     자연          자연          비자림  126.811461  33.491097    0.0   \n",
       "120        1    NaN          자연        용눈이오름  126.852054  33.522527    0.0   \n",
       "130        1    NaN          자연        월정리해변  126.798641  33.555113    0.0   \n",
       "76         1    NaN       레저/체험          빠우사  126.711909  33.457740    0.0   \n",
       "18         1    NaN          자연        광치기해변  126.922403  33.437021    0.0   \n",
       "32         1    NaN          자연       김녕해수욕장  126.736551  33.557208    0.0   \n",
       "41         1    NaN         NaN        다랑쉬오름  126.862444  33.521649    NaN   \n",
       "2          1     자연          자연          만장굴  126.771616  33.528377    0.0   \n",
       "229        3     쇼핑         특산물         이제주숍  126.540713  33.499434    0.0   \n",
       "203        3    NaN          자연       함덕해수욕장  126.668710  33.543702    0.0   \n",
       "84         3    NaN          자연          서우봉  126.677541  33.545364    0.0   \n",
       "128        3    NaN          자연     이호테우해수욕장  126.455893  33.496197    0.0   \n",
       "213        3     쇼핑          시장       동문재래시장  126.526018  33.511590    0.0   \n",
       "212        3     쇼핑          시장         동문시장  126.528320  33.512797    0.0   \n",
       "0          3   공연전시  테마파크/공연/전시       노형수퍼마켙  126.455168  33.464942    0.0   \n",
       "199        3    NaN          자연        한라수목원  126.493244  33.469587    0.0   \n",
       "7          4  테마관광지  테마파크/공연/전시      오설록티뮤지엄  126.289492  33.305924    0.0   \n",
       "8          4     자연          자연        용머리해안  126.314631  33.233482    0.0   \n",
       "14         4   테마파크          자연        카멜리아힐  126.368365  33.290140    0.0   \n",
       "11         4  테마관광지  테마파크/공연/전시       제주유리의성  126.273662  33.314634    0.0   \n",
       "122        4    NaN  테마파크/공연/전시    제주항공우주박물관  126.299662  33.304207    0.0   \n",
       "78         4    NaN  테마파크/공연/전시  세계자동차피아노박물관  126.349010  33.282942    0.0   \n",
       "17         4   공연전시  테마파크/공연/전시     헬로키티아일랜드  126.352081  33.290100    0.0   \n",
       "65         4    NaN  테마파크/공연/전시        본태박물관  126.392568  33.303955    0.0   \n",
       "144        4    NaN  테마파크/공연/전시         토이파크  126.345363  33.318960    0.0   \n",
       "3          4  테마관광지  테마파크/공연/전시      소인국테마파크  126.322195  33.290645    0.0   \n",
       "134        5     쇼핑      기념품/소품         베리제주  126.336327  33.466620    0.0   \n",
       "127        5    NaN          자연       협재해수욕장  126.239432  33.393748    0.0   \n",
       "45         5    NaN       레저/체험        물뫼힐링팜  126.396556  33.464249    0.0   \n",
       "11         5    NaN          자연       곽지해수욕장  126.328973  33.462191    0.0   \n",
       "18         5    NaN          자연       금능해수욕장  126.236205  33.390401    0.0   \n",
       "60         5    NaN          자연          수월봉  126.163419  33.294765    0.0   \n",
       "66         5    NaN  테마파크/공연/전시     신창풍차해안도로  126.173909  33.343429    0.0   \n",
       "2          5     자연          자연       생각하는정원  126.255005  33.325584    0.0   \n",
       "\n",
       "     blog_review_num_list   co2_max  similarity type  eco_YN  co2_rate  \\\n",
       "79                 1864.0  0.032606    0.456621  관광지       0  0.998654   \n",
       "3                  5849.0  0.285718    0.357876  관광지       0  0.988209   \n",
       "130                8349.0  1.124130    0.147991  관광지       0  0.953608   \n",
       "80                  111.0  0.366539    0.505567  관광지       0  0.984873   \n",
       "2                  4427.0  0.092272    0.423816  관광지       0  0.996192   \n",
       "42                  201.0  0.579984    0.421622  관광지       0  0.976064   \n",
       "50                  199.0  0.310905    0.448216  관광지       0  0.987169   \n",
       "86                 2785.0  0.579984    0.402874  관광지       0  0.976064   \n",
       "84                12426.0  0.342912    0.437417  관광지       0  0.985848   \n",
       "110                9545.0  0.579984    0.286518  관광지       0  0.976064   \n",
       "4                  6956.0  0.244067    0.323949  관광지       0  0.989927   \n",
       "120                4008.0  0.310905    0.477971  관광지       0  0.987169   \n",
       "130                6302.0  0.310905    0.288039  관광지       0  0.987169   \n",
       "76                    8.0  0.007189    0.089769  관광지       1  0.999703   \n",
       "18                 3897.0  0.055903    0.472380  관광지       0  0.997693   \n",
       "32                 4278.0  0.011501    0.265265  관광지       0  0.999525   \n",
       "41                 1656.0  0.011491    0.424788  관광지       0  0.999526   \n",
       "2                  3030.0  0.310905    0.312514  관광지       0  0.987169   \n",
       "229                  16.0  1.241532    0.168371  관광지       1  0.948763   \n",
       "203               11457.0  0.445751    0.254322  관광지       0  0.981604   \n",
       "84                11457.0  0.310905    0.185174  관광지       0  0.987169   \n",
       "128                7482.0  0.026778    0.284239  관광지       0  0.998895   \n",
       "213                5171.0  0.148547    0.290710  관광지       0  0.993870   \n",
       "212                5171.0  0.332903    0.292173  관광지       0  0.986261   \n",
       "0                  2161.0  0.403384    0.508015  관광지       0  0.983353   \n",
       "199                2528.0  0.038668    0.458861  관광지       0  0.998404   \n",
       "7                 12150.0  0.579984    0.514570  관광지       0  0.976064   \n",
       "8                  4825.0  0.005309    0.139690  관광지       1  0.999781   \n",
       "14                 9932.0  0.170725    0.479790  관광지       0  0.992954   \n",
       "11                 2154.0  1.294855    0.529019  관광지       0  0.946562   \n",
       "122                2552.0  0.579984    0.477731  관광지       0  0.976064   \n",
       "78                 3329.0  0.018790    0.493337  관광지       0  0.999225   \n",
       "17                 2436.0  0.606763    0.529560  관광지       0  0.974959   \n",
       "65                 1933.0  0.505897    0.487227  관광지       0  0.979122   \n",
       "144                 209.0  0.084316    0.511035  관광지       0  0.996520   \n",
       "3                  1655.0  0.066130    0.486114  관광지       0  0.997271   \n",
       "134                 431.0  0.118939    0.257585  관광지       1  0.995091   \n",
       "127               10708.0  0.310905    0.399303  관광지       0  0.987169   \n",
       "45                   15.0  0.366539    0.147966  관광지       1  0.984873   \n",
       "11                 4790.0  0.310905    0.399303  관광지       0  0.987169   \n",
       "18                 4601.0  0.058375    0.385068  관광지       0  0.997591   \n",
       "60                 1993.0  0.310905    0.508712  관광지       0  0.987169   \n",
       "66                 3043.0  0.579984    0.383931  관광지       0  0.976064   \n",
       "2                   972.0  0.592651    0.478092  관광지       0  0.975542   \n",
       "\n",
       "     review_rate  dist_score  total_score  \n",
       "79      0.150008    0.936069     2.541352  \n",
       "3       0.470707    0.716300     2.533091  \n",
       "130     0.671898    0.701053     2.474549  \n",
       "80      0.008933    0.947879     2.447252  \n",
       "2       0.356269    0.668634     2.444911  \n",
       "42      0.016176    1.000000     2.413862  \n",
       "50      0.016015    0.931768     2.383168  \n",
       "86      0.224127    0.766464     2.369529  \n",
       "84      1.000000    1.000000     3.423265  \n",
       "110     0.768147    0.849852     2.880582  \n",
       "4       0.559794    0.916615     2.790286  \n",
       "120     0.322549    1.000000     2.787690  \n",
       "130     0.507162    1.000000     2.782371  \n",
       "76      0.000644    0.668498     2.758614  \n",
       "18      0.313617    0.864717     2.648407  \n",
       "32      0.344278    1.000000     2.609068  \n",
       "41      0.133269    1.000000     2.557583  \n",
       "2       0.243844    1.000000     2.543527  \n",
       "229     0.001288    1.000000     3.118421  \n",
       "203     0.922018    0.929035     3.086979  \n",
       "84      0.922018    0.912060     3.006422  \n",
       "128     0.602125    1.000000     2.885259  \n",
       "213     0.416144    1.000000     2.700723  \n",
       "212     0.416144    1.000000     2.694578  \n",
       "0       0.173910    0.996166     2.661444  \n",
       "199     0.203444    1.000000     2.660709  \n",
       "7       0.977789    0.860480     3.328902  \n",
       "8       0.388299    0.532287     3.060057  \n",
       "14      0.799292    0.776417     3.048453  \n",
       "11      0.173346    0.898872     2.547799  \n",
       "122     0.205376    0.852704     2.511875  \n",
       "78      0.267906    0.749763     2.510231  \n",
       "17      0.196041    0.781227     2.481787  \n",
       "65      0.155561    0.828704     2.450613  \n",
       "144     0.016820    0.913071     2.437446  \n",
       "3       0.133188    0.789663     2.406237  \n",
       "134     0.034685    1.000000     3.287361  \n",
       "127     0.861742    1.000000     3.248214  \n",
       "45      0.001207    1.000000     3.134046  \n",
       "11      0.385482    1.000000     2.771955  \n",
       "18      0.370272    1.000000     2.752931  \n",
       "60      0.160390    1.000000     2.656270  \n",
       "66      0.244890    0.947761     2.552647  \n",
       "2       0.078223    1.000000     2.531857  "
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "all_visits = pd.concat([\n",
    "    data0.sort_values(['total_score'],ascending = False )[:8],\n",
    "    data1.sort_values(['total_score'],ascending = False )[:10],\n",
    "    data3.sort_values(['total_score'],ascending = False )[:8],\n",
    "    data4.sort_values(['total_score'],ascending = False )[:10],\n",
    "    data5.sort_values(['total_score'],ascending = False )[:8]\n",
    "])\n",
    "all_visits"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(44, 16)"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "all_visits.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "fnb0['cluster'] = 0\n",
    "fnb1['cluster'] = 1\n",
    "fnb3['cluster'] = 3\n",
    "fnb4['cluster'] = 4\n",
    "fnb5['cluster'] = 5\n",
    "\n",
    "fnb0['type'] = \"F&B\"\n",
    "fnb1['type'] = \"F&B\"\n",
    "fnb3['type'] = \"F&B\"\n",
    "fnb4['type'] = \"F&B\"\n",
    "fnb5['type'] = \"F&B\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "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>type</th>\n",
       "      <th>cluster</th>\n",
       "      <th>category</th>\n",
       "      <th>AREA_NM_PRE</th>\n",
       "      <th>lon</th>\n",
       "      <th>lat</th>\n",
       "      <th>price</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>자연</td>\n",
       "      <td>엉또폭포</td>\n",
       "      <td>126.491918</td>\n",
       "      <td>33.258821</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>자연</td>\n",
       "      <td>천지연폭포</td>\n",
       "      <td>126.559551</td>\n",
       "      <td>33.244717</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>시장</td>\n",
       "      <td>서귀포매일올레시장</td>\n",
       "      <td>126.563231</td>\n",
       "      <td>33.250149</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>레저/체험</td>\n",
       "      <td>영실기암</td>\n",
       "      <td>126.466023</td>\n",
       "      <td>33.278536</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>관광지</td>\n",
       "      <td>0</td>\n",
       "      <td>자연</td>\n",
       "      <td>정방폭포</td>\n",
       "      <td>126.573050</td>\n",
       "      <td>33.244748</td>\n",
       "      <td>0.000000</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>F&amp;B</td>\n",
       "      <td>5</td>\n",
       "      <td>카페/디저트</td>\n",
       "      <td>그루브</td>\n",
       "      <td>126.240040</td>\n",
       "      <td>33.393738</td>\n",
       "      <td>10375.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>F&amp;B</td>\n",
       "      <td>5</td>\n",
       "      <td>카페/디저트</td>\n",
       "      <td>제레미</td>\n",
       "      <td>126.318550</td>\n",
       "      <td>33.464450</td>\n",
       "      <td>6750.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>F&amp;B</td>\n",
       "      <td>5</td>\n",
       "      <td>카페/디저트</td>\n",
       "      <td>제주돌창고</td>\n",
       "      <td>126.233569</td>\n",
       "      <td>33.337093</td>\n",
       "      <td>8250.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>F&amp;B</td>\n",
       "      <td>5</td>\n",
       "      <td>카페/디저트</td>\n",
       "      <td>몽상드애월</td>\n",
       "      <td>126.309245</td>\n",
       "      <td>33.462925</td>\n",
       "      <td>7935.538339</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>F&amp;B</td>\n",
       "      <td>5</td>\n",
       "      <td>카페/디저트</td>\n",
       "      <td>애월더선셋</td>\n",
       "      <td>126.308883</td>\n",
       "      <td>33.456133</td>\n",
       "      <td>23028.883685</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>99 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    type  cluster category AREA_NM_PRE         lon        lat         price\n",
       "79   관광지        0       자연        엉또폭포  126.491918  33.258821      0.000000\n",
       "3    관광지        0       자연       천지연폭포  126.559551  33.244717      0.000000\n",
       "130  관광지        0       시장   서귀포매일올레시장  126.563231  33.250149      0.000000\n",
       "80   관광지        0    레저/체험        영실기암  126.466023  33.278536      0.000000\n",
       "2    관광지        0       자연        정방폭포  126.573050  33.244748      0.000000\n",
       "..   ...      ...      ...         ...         ...        ...           ...\n",
       "9    F&B        5   카페/디저트         그루브  126.240040  33.393738  10375.000000\n",
       "10   F&B        5   카페/디저트         제레미  126.318550  33.464450   6750.000000\n",
       "11   F&B        5   카페/디저트       제주돌창고  126.233569  33.337093   8250.000000\n",
       "12   F&B        5   카페/디저트       몽상드애월  126.309245  33.462925   7935.538339\n",
       "13   F&B        5   카페/디저트       애월더선셋  126.308883  33.456133  23028.883685\n",
       "\n",
       "[99 rows x 7 columns]"
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "all_visits.columns = ['cluster', 'CL_NM', 'category', 'AREA_NM_PRE', 'lon', 'lat','price',\n",
    "       'blog_review_num_list', 'co2_max', 'similarity', 'type', 'eco_YN', 'co2_rate',\n",
    "       'review_rate', 'dist_score', 'total_score']\n",
    "\n",
    "final = pd.concat([\n",
    "    all_visits[['type','cluster', 'category', 'AREA_NM_PRE', 'lon', 'lat','price']],\n",
    "    fnb0[['type','cluster','category','AREA_NM_PRE','lon','lat','price']],\n",
    "    fnb1[['type','cluster','category','AREA_NM_PRE','lon','lat','price']],\n",
    "    fnb3[['type','cluster','category','AREA_NM_PRE','lon','lat','price']],\n",
    "    fnb4[['type','cluster','category','AREA_NM_PRE','lon','lat','price']],\n",
    "    fnb5[['type','cluster','category','AREA_NM_PRE','lon','lat','price']]\n",
    "])\n",
    "final"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [],
   "source": [
    "final.to_csv('data/관광지F&B추천FINAL.csv', encoding='utf-8-sig', index=False) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "hide_input": false,
  "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.9.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}