contentbasedrecommendation.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import string\n",
    "from sklearn.metrics.pairwise import cosine_similarity"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(515738, 17)"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "hotelDF = pd.read_csv('Hotel_Reviews.csv')\n",
    "hotelDF.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Hotel_Address', 'Average_Score', 'Hotel_Name', 'Tags'], dtype='object')"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#removing unwanted columns as we need hotel name, hotel address, tags and average score for recommendation system\n",
    "unwanted_columns = ['Additional_Number_of_Scoring', 'Review_Date', 'Reviewer_Score',\n",
    "       'Reviewer_Nationality',\n",
    "       'Negative_Review', 'Review_Total_Negative_Word_Counts',\n",
    "       'Total_Number_of_Reviews', 'Positive_Review',\n",
    "       'Review_Total_Positive_Word_Counts',\n",
    "       'Total_Number_of_Reviews_Reviewer_Has_Given','days_since_review', 'lat', 'lng']\n",
    "\n",
    "hotelDF.drop(columns=unwanted_columns, inplace=True)\n",
    "\n",
    "hotelDF.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "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>Hotel_Address</th>\n",
       "      <th>Average_Score</th>\n",
       "      <th>Hotel_Name</th>\n",
       "      <th>Tags</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>s Gravesandestraat 55 Oost 1092 AA Amsterdam ...</td>\n",
       "      <td>7.7</td>\n",
       "      <td>Hotel Arena</td>\n",
       "      <td>[' Leisure trip ', ' Couple ', ' Duplex Double...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>s Gravesandestraat 55 Oost 1092 AA Amsterdam ...</td>\n",
       "      <td>7.7</td>\n",
       "      <td>Hotel Arena</td>\n",
       "      <td>[' Leisure trip ', ' Couple ', ' Duplex Double...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>s Gravesandestraat 55 Oost 1092 AA Amsterdam ...</td>\n",
       "      <td>7.7</td>\n",
       "      <td>Hotel Arena</td>\n",
       "      <td>[' Leisure trip ', ' Family with young childre...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>s Gravesandestraat 55 Oost 1092 AA Amsterdam ...</td>\n",
       "      <td>7.7</td>\n",
       "      <td>Hotel Arena</td>\n",
       "      <td>[' Leisure trip ', ' Solo traveler ', ' Duplex...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>s Gravesandestraat 55 Oost 1092 AA Amsterdam ...</td>\n",
       "      <td>7.7</td>\n",
       "      <td>Hotel Arena</td>\n",
       "      <td>[' Leisure trip ', ' Couple ', ' Suite ', ' St...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       Hotel_Address  Average_Score  \\\n",
       "0   s Gravesandestraat 55 Oost 1092 AA Amsterdam ...            7.7   \n",
       "1   s Gravesandestraat 55 Oost 1092 AA Amsterdam ...            7.7   \n",
       "2   s Gravesandestraat 55 Oost 1092 AA Amsterdam ...            7.7   \n",
       "3   s Gravesandestraat 55 Oost 1092 AA Amsterdam ...            7.7   \n",
       "4   s Gravesandestraat 55 Oost 1092 AA Amsterdam ...            7.7   \n",
       "\n",
       "    Hotel_Name                                               Tags  \n",
       "0  Hotel Arena  [' Leisure trip ', ' Couple ', ' Duplex Double...  \n",
       "1  Hotel Arena  [' Leisure trip ', ' Couple ', ' Duplex Double...  \n",
       "2  Hotel Arena  [' Leisure trip ', ' Family with young childre...  \n",
       "3  Hotel Arena  [' Leisure trip ', ' Solo traveler ', ' Duplex...  \n",
       "4  Hotel Arena  [' Leisure trip ', ' Couple ', ' Suite ', ' St...  "
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "hotelDF.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Hotel_Name       0\n",
      "Tags             0\n",
      "Hotel_Address    0\n",
      "Average_Score    0\n",
      "dtype: int64\n"
     ]
    }
   ],
   "source": [
    "hotelDF = hotelDF.groupby('Hotel_Name').agg({'Tags': ','.join, 'Hotel_Address': 'first', 'Average_Score': 'first'}).reset_index()\n",
    "\n",
    "null_counts_all = hotelDF.isnull().sum()\n",
    "print(null_counts_all)\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The above output shows there are no null values in the dataframe."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [],
   "source": [
    "#converting the dataframe to pickeformat since it is faster to read and can handle complex nested structures\n",
    "hotelDF.to_pickle('hotelDF.pkl')\n",
    "#next we work on the pickle file"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "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>Hotel_Name</th>\n",
       "      <th>Tags</th>\n",
       "      <th>Hotel_Address</th>\n",
       "      <th>Average_Score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>11 Cadogan Gardens</td>\n",
       "      <td>[' Leisure trip ', ' Couple ', ' Superior Quee...</td>\n",
       "      <td>11 Cadogan Gardens Sloane Square Kensington an...</td>\n",
       "      <td>8.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1K Hotel</td>\n",
       "      <td>[' Leisure trip ', ' Couple ', ' Superior M Do...</td>\n",
       "      <td>13 Boulevard Du Temple 3rd arr 75003 Paris France</td>\n",
       "      <td>7.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>25hours Hotel beim MuseumsQuartier</td>\n",
       "      <td>[' Leisure trip ', ' Solo traveler ', ' Standa...</td>\n",
       "      <td>Lerchenfelder Stra e 1 3 07 Neubau 1070 Vienna...</td>\n",
       "      <td>8.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>41</td>\n",
       "      <td>[' Leisure trip ', ' Couple ', ' Executive Kin...</td>\n",
       "      <td>41 Buckingham Palace Road Westminster Borough ...</td>\n",
       "      <td>9.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>45 Park Lane Dorchester Collection</td>\n",
       "      <td>[' Leisure trip ', ' Solo traveler ', ' Execut...</td>\n",
       "      <td>45 Park Lane Westminster Borough London W1K 1P...</td>\n",
       "      <td>9.4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                           Hotel_Name  \\\n",
       "0                  11 Cadogan Gardens   \n",
       "1                            1K Hotel   \n",
       "2  25hours Hotel beim MuseumsQuartier   \n",
       "3                                  41   \n",
       "4  45 Park Lane Dorchester Collection   \n",
       "\n",
       "                                                Tags  \\\n",
       "0  [' Leisure trip ', ' Couple ', ' Superior Quee...   \n",
       "1  [' Leisure trip ', ' Couple ', ' Superior M Do...   \n",
       "2  [' Leisure trip ', ' Solo traveler ', ' Standa...   \n",
       "3  [' Leisure trip ', ' Couple ', ' Executive Kin...   \n",
       "4  [' Leisure trip ', ' Solo traveler ', ' Execut...   \n",
       "\n",
       "                                       Hotel_Address  Average_Score  \n",
       "0  11 Cadogan Gardens Sloane Square Kensington an...            8.7  \n",
       "1  13 Boulevard Du Temple 3rd arr 75003 Paris France            7.7  \n",
       "2  Lerchenfelder Stra e 1 3 07 Neubau 1070 Vienna...            8.8  \n",
       "3  41 Buckingham Palace Road Westminster Borough ...            9.6  \n",
       "4  45 Park Lane Westminster Borough London W1K 1P...            9.4  "
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "hotel_df = pd.read_pickle('hotelDF.pkl')\n",
    "hotel_df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Preprocessing the tags column to extract attributes as features that can be used to calculate similarity between hotels.\n",
    "Extracting tags stored as string into a new column which contains a set of meaningful tags\n",
    "removing some unnecessary tags such as submitted from a mobile device, which are not useful to help us create a recommender engine\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [],
   "source": [
    "exclude = set(string.punctuation)\n",
    "def removespaces(hoteltags):\n",
    "    new_tags = []\n",
    "    newtags = \"\"\n",
    "    for tag in hoteltags[1:][:-1].split(\",\"):\n",
    "        tag_without_spaces = \"\".join(character for character in tag.lower() if character not in exclude).replace(' ','')\n",
    "        new_tags.append(tag_without_spaces)\n",
    "    \n",
    "    new_tags.remove('submittedfromamobiledevice')\n",
    "    newtags = ','.join(new_tags)\n",
    "    return newtags\n",
    "\n",
    "hotel_df['new_tags'] = hotel_df['Tags'].map(removespaces)\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.feature_extraction.text import TfidfVectorizer\n",
    "\n",
    "tfidf_vectorizer = TfidfVectorizer()\n",
    "tfidf_matrix = tfidf_vectorizer.fit_transform(hotel_df['new_tags'])\n",
    "\n",
    "tfidf_df = pd.DataFrame(tfidf_matrix.toarray(), columns=tfidf_vectorizer.get_feature_names_out(), index=hotel_df[\"Hotel_Name\"])\n",
    "\n",
    "top_tags = tfidf_df.apply(lambda row: row.nlargest(10).index.tolist(), axis=1).to_frame()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                                                                                    0\n",
      "Hotel_Name                                                                           \n",
      "11 Cadogan Gardens                  [superiorqueenroom, deluxekingroom, leisuretri...\n",
      "1K Hotel                            [superiormdoubleroom, deluxeldoubleroom, leisu...\n",
      "25hours Hotel beim MuseumsQuartier  [superiordoubleroomwithcityview, standarddoubl...\n",
      "41                                  [executivekingroomwithloungeaccess, leisuretri...\n",
      "45 Park Lane Dorchester Collection  [superiorkingroom, executivequeenroom, parkvie...\n",
      "...                                                                               ...\n",
      "citizenM London Bankside            [doubleroom, leisuretrip, couple, submittedfro...\n",
      "citizenM London Shoreditch          [doubleroom, leisuretrip, stayed1night, submit...\n",
      "citizenM Tower of London            [doubleroom, leisuretrip, submittedfromamobile...\n",
      "every hotel Piccadilly              [standarddoubleroom, leisuretrip, deluxekingro...\n",
      "pentahotel Vienna                   [pentastandardroom, pentaplusroom, leisuretrip...\n",
      "\n",
      "[1492 rows x 1 columns]\n"
     ]
    }
   ],
   "source": [
    "print(top_tags)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [],
   "source": [
    "hotel_df = pd.merge(hotel_df, top_tags, on='Hotel_Name')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [],
   "source": [
    "hotel_df.head()\n",
    "hotel_df.rename(columns={0: \"Top_10_Tags\"}, inplace=True)\n",
    "hotel_df.drop(columns='Tags', inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "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>Hotel_Name</th>\n",
       "      <th>Hotel_Address</th>\n",
       "      <th>Average_Score</th>\n",
       "      <th>new_tags</th>\n",
       "      <th>Top_10_Tags</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>11 Cadogan Gardens</td>\n",
       "      <td>11 Cadogan Gardens Sloane Square Kensington an...</td>\n",
       "      <td>8.7</td>\n",
       "      <td>leisuretrip,couple,superiorqueenroom,stayed1ni...</td>\n",
       "      <td>[superiorqueenroom, deluxekingroom, leisuretri...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1K Hotel</td>\n",
       "      <td>13 Boulevard Du Temple 3rd arr 75003 Paris France</td>\n",
       "      <td>7.7</td>\n",
       "      <td>leisuretrip,couple,superiormdoubleroom,stayed2...</td>\n",
       "      <td>[superiormdoubleroom, deluxeldoubleroom, leisu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>25hours Hotel beim MuseumsQuartier</td>\n",
       "      <td>Lerchenfelder Stra e 1 3 07 Neubau 1070 Vienna...</td>\n",
       "      <td>8.8</td>\n",
       "      <td>leisuretrip,solotraveler,standarddoubleroom,st...</td>\n",
       "      <td>[superiordoubleroomwithcityview, standarddoubl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>41</td>\n",
       "      <td>41 Buckingham Palace Road Westminster Borough ...</td>\n",
       "      <td>9.6</td>\n",
       "      <td>leisuretrip,couple,executivekingroomwithlounge...</td>\n",
       "      <td>[executivekingroomwithloungeaccess, leisuretri...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>45 Park Lane Dorchester Collection</td>\n",
       "      <td>45 Park Lane Westminster Borough London W1K 1P...</td>\n",
       "      <td>9.4</td>\n",
       "      <td>leisuretrip,solotraveler,executivequeenroom,st...</td>\n",
       "      <td>[superiorkingroom, executivequeenroom, parkvie...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                           Hotel_Name  \\\n",
       "0                  11 Cadogan Gardens   \n",
       "1                            1K Hotel   \n",
       "2  25hours Hotel beim MuseumsQuartier   \n",
       "3                                  41   \n",
       "4  45 Park Lane Dorchester Collection   \n",
       "\n",
       "                                       Hotel_Address  Average_Score  \\\n",
       "0  11 Cadogan Gardens Sloane Square Kensington an...            8.7   \n",
       "1  13 Boulevard Du Temple 3rd arr 75003 Paris France            7.7   \n",
       "2  Lerchenfelder Stra e 1 3 07 Neubau 1070 Vienna...            8.8   \n",
       "3  41 Buckingham Palace Road Westminster Borough ...            9.6   \n",
       "4  45 Park Lane Westminster Borough London W1K 1P...            9.4   \n",
       "\n",
       "                                            new_tags  \\\n",
       "0  leisuretrip,couple,superiorqueenroom,stayed1ni...   \n",
       "1  leisuretrip,couple,superiormdoubleroom,stayed2...   \n",
       "2  leisuretrip,solotraveler,standarddoubleroom,st...   \n",
       "3  leisuretrip,couple,executivekingroomwithlounge...   \n",
       "4  leisuretrip,solotraveler,executivequeenroom,st...   \n",
       "\n",
       "                                         Top_10_Tags  \n",
       "0  [superiorqueenroom, deluxekingroom, leisuretri...  \n",
       "1  [superiormdoubleroom, deluxeldoubleroom, leisu...  \n",
       "2  [superiordoubleroomwithcityview, standarddoubl...  \n",
       "3  [executivekingroomwithloungeaccess, leisuretri...  \n",
       "4  [superiorkingroom, executivequeenroom, parkvie...  "
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "hotel_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [],
   "source": [
    "tag_list = []\n",
    "\n",
    "def get_tag_elements(tag_string):\n",
    "    global tag_list\n",
    "    tag_list.extend(tag_string)\n",
    "    return True\n",
    "\n",
    "for i in hotel_df['Top_10_Tags']:\n",
    "    get_tag_elements(i)\n",
    "\n",
    "tag_set = set(tag_list)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in tag_list:\n",
    "    hotel_df[i] = 0"
   ]
  },
  {
   "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>Hotel_Name</th>\n",
       "      <th>Hotel_Address</th>\n",
       "      <th>Average_Score</th>\n",
       "      <th>new_tags</th>\n",
       "      <th>Top_10_Tags</th>\n",
       "      <th>superiorqueenroom</th>\n",
       "      <th>deluxekingroom</th>\n",
       "      <th>leisuretrip</th>\n",
       "      <th>submittedfromamobiledevice</th>\n",
       "      <th>couple</th>\n",
       "      <th>...</th>\n",
       "      <th>largetripleroom</th>\n",
       "      <th>superiordoubleroomwithfreepoolaccess</th>\n",
       "      <th>superiortwinroomwithfreepoolaccess</th>\n",
       "      <th>specialofferdoubleortwinroomwithparking</th>\n",
       "      <th>artkingroom</th>\n",
       "      <th>artroomwithiconicview</th>\n",
       "      <th>arttwinroom</th>\n",
       "      <th>pentastandardroom</th>\n",
       "      <th>pentaplusroom</th>\n",
       "      <th>pentajuniorsuite</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>11 Cadogan Gardens</td>\n",
       "      <td>11 Cadogan Gardens Sloane Square Kensington an...</td>\n",
       "      <td>8.7</td>\n",
       "      <td>leisuretrip,couple,superiorqueenroom,stayed1ni...</td>\n",
       "      <td>[superiorqueenroom, deluxekingroom, leisuretri...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1K Hotel</td>\n",
       "      <td>13 Boulevard Du Temple 3rd arr 75003 Paris France</td>\n",
       "      <td>7.7</td>\n",
       "      <td>leisuretrip,couple,superiormdoubleroom,stayed2...</td>\n",
       "      <td>[superiormdoubleroom, deluxeldoubleroom, leisu...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>25hours Hotel beim MuseumsQuartier</td>\n",
       "      <td>Lerchenfelder Stra e 1 3 07 Neubau 1070 Vienna...</td>\n",
       "      <td>8.8</td>\n",
       "      <td>leisuretrip,solotraveler,standarddoubleroom,st...</td>\n",
       "      <td>[superiordoubleroomwithcityview, standarddoubl...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>41</td>\n",
       "      <td>41 Buckingham Palace Road Westminster Borough ...</td>\n",
       "      <td>9.6</td>\n",
       "      <td>leisuretrip,couple,executivekingroomwithlounge...</td>\n",
       "      <td>[executivekingroomwithloungeaccess, leisuretri...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>45 Park Lane Dorchester Collection</td>\n",
       "      <td>45 Park Lane Westminster Borough London W1K 1P...</td>\n",
       "      <td>9.4</td>\n",
       "      <td>leisuretrip,solotraveler,executivequeenroom,st...</td>\n",
       "      <td>[superiorkingroom, executivequeenroom, parkvie...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 1641 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                           Hotel_Name  \\\n",
       "0                  11 Cadogan Gardens   \n",
       "1                            1K Hotel   \n",
       "2  25hours Hotel beim MuseumsQuartier   \n",
       "3                                  41   \n",
       "4  45 Park Lane Dorchester Collection   \n",
       "\n",
       "                                       Hotel_Address  Average_Score  \\\n",
       "0  11 Cadogan Gardens Sloane Square Kensington an...            8.7   \n",
       "1  13 Boulevard Du Temple 3rd arr 75003 Paris France            7.7   \n",
       "2  Lerchenfelder Stra e 1 3 07 Neubau 1070 Vienna...            8.8   \n",
       "3  41 Buckingham Palace Road Westminster Borough ...            9.6   \n",
       "4  45 Park Lane Westminster Borough London W1K 1P...            9.4   \n",
       "\n",
       "                                            new_tags  \\\n",
       "0  leisuretrip,couple,superiorqueenroom,stayed1ni...   \n",
       "1  leisuretrip,couple,superiormdoubleroom,stayed2...   \n",
       "2  leisuretrip,solotraveler,standarddoubleroom,st...   \n",
       "3  leisuretrip,couple,executivekingroomwithlounge...   \n",
       "4  leisuretrip,solotraveler,executivequeenroom,st...   \n",
       "\n",
       "                                         Top_10_Tags  superiorqueenroom  \\\n",
       "0  [superiorqueenroom, deluxekingroom, leisuretri...                  0   \n",
       "1  [superiormdoubleroom, deluxeldoubleroom, leisu...                  0   \n",
       "2  [superiordoubleroomwithcityview, standarddoubl...                  0   \n",
       "3  [executivekingroomwithloungeaccess, leisuretri...                  0   \n",
       "4  [superiorkingroom, executivequeenroom, parkvie...                  0   \n",
       "\n",
       "   deluxekingroom  leisuretrip  submittedfromamobiledevice  couple  ...  \\\n",
       "0               0            0                           0       0  ...   \n",
       "1               0            0                           0       0  ...   \n",
       "2               0            0                           0       0  ...   \n",
       "3               0            0                           0       0  ...   \n",
       "4               0            0                           0       0  ...   \n",
       "\n",
       "   largetripleroom  superiordoubleroomwithfreepoolaccess  \\\n",
       "0                0                                     0   \n",
       "1                0                                     0   \n",
       "2                0                                     0   \n",
       "3                0                                     0   \n",
       "4                0                                     0   \n",
       "\n",
       "   superiortwinroomwithfreepoolaccess  \\\n",
       "0                                   0   \n",
       "1                                   0   \n",
       "2                                   0   \n",
       "3                                   0   \n",
       "4                                   0   \n",
       "\n",
       "   specialofferdoubleortwinroomwithparking  artkingroom  \\\n",
       "0                                        0            0   \n",
       "1                                        0            0   \n",
       "2                                        0            0   \n",
       "3                                        0            0   \n",
       "4                                        0            0   \n",
       "\n",
       "   artroomwithiconicview  arttwinroom  pentastandardroom  pentaplusroom  \\\n",
       "0                      0            0                  0              0   \n",
       "1                      0            0                  0              0   \n",
       "2                      0            0                  0              0   \n",
       "3                      0            0                  0              0   \n",
       "4                      0            0                  0              0   \n",
       "\n",
       "   pentajuniorsuite  \n",
       "0                 0  \n",
       "1                 0  \n",
       "2                 0  \n",
       "3                 0  \n",
       "4                 0  \n",
       "\n",
       "[5 rows x 1641 columns]"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "hotel_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                                            Top_10_Tags\n",
      "0     [superiorqueenroom, deluxekingroom, leisuretri...\n",
      "1     [superiormdoubleroom, deluxeldoubleroom, leisu...\n",
      "2     [superiordoubleroomwithcityview, standarddoubl...\n",
      "3     [executivekingroomwithloungeaccess, leisuretri...\n",
      "4     [superiorkingroom, executivequeenroom, parkvie...\n",
      "...                                                 ...\n",
      "1487  [doubleroom, leisuretrip, couple, submittedfro...\n",
      "1488  [doubleroom, leisuretrip, stayed1night, submit...\n",
      "1489  [doubleroom, leisuretrip, submittedfromamobile...\n",
      "1490  [standarddoubleroom, leisuretrip, deluxekingro...\n",
      "1491  [pentastandardroom, pentaplusroom, leisuretrip...\n",
      "\n",
      "[1492 rows x 1 columns]\n"
     ]
    }
   ],
   "source": [
    "only_top_10_tags=pd.DataFrame(hotel_df.Top_10_Tags.loc[:])\n",
    "\n",
    "print(only_top_10_tags)\n",
    "\n",
    "for index, row in only_top_10_tags.iterrows():\n",
    "    top10tagset = set(row['Top_10_Tags'])\n",
    "    \n",
    "    for tag in top10tagset:\n",
    "        #set corresponding column to 1\n",
    "        if tag in tag_set:\n",
    "            hotel_df.loc[index,tag]=1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "#swap the position of avg score column and top10tags column\n",
    "\n",
    "cols = list(hotel_df.columns)\n",
    "avgscore_index, top10tags_index = cols.index('Average_Score'), cols.index('Top_10_Tags')\n",
    "cols[avgscore_index], cols[top10tags_index] = cols[top10tags_index], cols[avgscore_index]\n",
    "\n",
    "hotel_df = hotel_df[cols]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "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>Hotel_Name</th>\n",
       "      <th>Hotel_Address</th>\n",
       "      <th>Top_10_Tags</th>\n",
       "      <th>new_tags</th>\n",
       "      <th>Average_Score</th>\n",
       "      <th>superiorqueenroom</th>\n",
       "      <th>deluxekingroom</th>\n",
       "      <th>leisuretrip</th>\n",
       "      <th>submittedfromamobiledevice</th>\n",
       "      <th>couple</th>\n",
       "      <th>...</th>\n",
       "      <th>largetripleroom</th>\n",
       "      <th>superiordoubleroomwithfreepoolaccess</th>\n",
       "      <th>superiortwinroomwithfreepoolaccess</th>\n",
       "      <th>specialofferdoubleortwinroomwithparking</th>\n",
       "      <th>artkingroom</th>\n",
       "      <th>artroomwithiconicview</th>\n",
       "      <th>arttwinroom</th>\n",
       "      <th>pentastandardroom</th>\n",
       "      <th>pentaplusroom</th>\n",
       "      <th>pentajuniorsuite</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>11 Cadogan Gardens</td>\n",
       "      <td>11 Cadogan Gardens Sloane Square Kensington an...</td>\n",
       "      <td>[superiorqueenroom, deluxekingroom, leisuretri...</td>\n",
       "      <td>leisuretrip,couple,superiorqueenroom,stayed1ni...</td>\n",
       "      <td>8.7</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1K Hotel</td>\n",
       "      <td>13 Boulevard Du Temple 3rd arr 75003 Paris France</td>\n",
       "      <td>[superiormdoubleroom, deluxeldoubleroom, leisu...</td>\n",
       "      <td>leisuretrip,couple,superiormdoubleroom,stayed2...</td>\n",
       "      <td>7.7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>25hours Hotel beim MuseumsQuartier</td>\n",
       "      <td>Lerchenfelder Stra e 1 3 07 Neubau 1070 Vienna...</td>\n",
       "      <td>[superiordoubleroomwithcityview, standarddoubl...</td>\n",
       "      <td>leisuretrip,solotraveler,standarddoubleroom,st...</td>\n",
       "      <td>8.8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>41</td>\n",
       "      <td>41 Buckingham Palace Road Westminster Borough ...</td>\n",
       "      <td>[executivekingroomwithloungeaccess, leisuretri...</td>\n",
       "      <td>leisuretrip,couple,executivekingroomwithlounge...</td>\n",
       "      <td>9.6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>45 Park Lane Dorchester Collection</td>\n",
       "      <td>45 Park Lane Westminster Borough London W1K 1P...</td>\n",
       "      <td>[superiorkingroom, executivequeenroom, parkvie...</td>\n",
       "      <td>leisuretrip,solotraveler,executivequeenroom,st...</td>\n",
       "      <td>9.4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 1641 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                           Hotel_Name  \\\n",
       "0                  11 Cadogan Gardens   \n",
       "1                            1K Hotel   \n",
       "2  25hours Hotel beim MuseumsQuartier   \n",
       "3                                  41   \n",
       "4  45 Park Lane Dorchester Collection   \n",
       "\n",
       "                                       Hotel_Address  \\\n",
       "0  11 Cadogan Gardens Sloane Square Kensington an...   \n",
       "1  13 Boulevard Du Temple 3rd arr 75003 Paris France   \n",
       "2  Lerchenfelder Stra e 1 3 07 Neubau 1070 Vienna...   \n",
       "3  41 Buckingham Palace Road Westminster Borough ...   \n",
       "4  45 Park Lane Westminster Borough London W1K 1P...   \n",
       "\n",
       "                                         Top_10_Tags  \\\n",
       "0  [superiorqueenroom, deluxekingroom, leisuretri...   \n",
       "1  [superiormdoubleroom, deluxeldoubleroom, leisu...   \n",
       "2  [superiordoubleroomwithcityview, standarddoubl...   \n",
       "3  [executivekingroomwithloungeaccess, leisuretri...   \n",
       "4  [superiorkingroom, executivequeenroom, parkvie...   \n",
       "\n",
       "                                            new_tags  Average_Score  \\\n",
       "0  leisuretrip,couple,superiorqueenroom,stayed1ni...            8.7   \n",
       "1  leisuretrip,couple,superiormdoubleroom,stayed2...            7.7   \n",
       "2  leisuretrip,solotraveler,standarddoubleroom,st...            8.8   \n",
       "3  leisuretrip,couple,executivekingroomwithlounge...            9.6   \n",
       "4  leisuretrip,solotraveler,executivequeenroom,st...            9.4   \n",
       "\n",
       "   superiorqueenroom  deluxekingroom  leisuretrip  submittedfromamobiledevice  \\\n",
       "0                  1               1            1                           1   \n",
       "1                  0               0            1                           1   \n",
       "2                  0               0            1                           1   \n",
       "3                  0               0            1                           1   \n",
       "4                  0               0            1                           1   \n",
       "\n",
       "   couple  ...  largetripleroom  superiordoubleroomwithfreepoolaccess  \\\n",
       "0       1  ...                0                                     0   \n",
       "1       1  ...                0                                     0   \n",
       "2       1  ...                0                                     0   \n",
       "3       1  ...                0                                     0   \n",
       "4       1  ...                0                                     0   \n",
       "\n",
       "   superiortwinroomwithfreepoolaccess  \\\n",
       "0                                   0   \n",
       "1                                   0   \n",
       "2                                   0   \n",
       "3                                   0   \n",
       "4                                   0   \n",
       "\n",
       "   specialofferdoubleortwinroomwithparking  artkingroom  \\\n",
       "0                                        0            0   \n",
       "1                                        0            0   \n",
       "2                                        0            0   \n",
       "3                                        0            0   \n",
       "4                                        0            0   \n",
       "\n",
       "   artroomwithiconicview  arttwinroom  pentastandardroom  pentaplusroom  \\\n",
       "0                      0            0                  0              0   \n",
       "1                      0            0                  0              0   \n",
       "2                      0            0                  0              0   \n",
       "3                      0            0                  0              0   \n",
       "4                      0            0                  0              0   \n",
       "\n",
       "   pentajuniorsuite  \n",
       "0                 0  \n",
       "1                 0  \n",
       "2                 0  \n",
       "3                 0  \n",
       "4                 0  \n",
       "\n",
       "[5 rows x 1641 columns]"
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "hotel_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [],
   "source": [
    "similarityDF = pd.DataFrame(cosine_similarity(hotel_df.iloc[:, 4:], hotel_df.iloc[:,4:]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "          0         1         2         3         4         5         6     \\\n",
      "0     1.000000  0.960224  0.942230  0.956785  0.956139  0.939756  0.953783   \n",
      "1     0.960224  1.000000  0.934765  0.949904  0.949425  0.932638  0.947612   \n",
      "2     0.942230  0.934765  1.000000  0.957320  0.945876  0.928398  0.942818   \n",
      "3     0.956785  0.949904  0.957320  1.000000  0.960077  0.944010  0.957320   \n",
      "4     0.956139  0.949425  0.945876  0.960077  1.000000  0.943199  0.945876   \n",
      "...        ...       ...       ...       ...       ...       ...       ...   \n",
      "1487  0.966259  0.961065  0.955542  0.969059  0.968552  0.941848  0.955542   \n",
      "1488  0.966259  0.961065  0.955542  0.969059  0.968552  0.941848  0.955542   \n",
      "1489  0.966259  0.961065  0.955542  0.969059  0.968552  0.941848  0.955542   \n",
      "1490  0.965336  0.947612  0.965691  0.967900  0.956659  0.940313  0.954254   \n",
      "1491  0.952326  0.946453  0.952771  0.966552  0.955028  0.938568  0.952771   \n",
      "\n",
      "          7         8         9     ...      1482      1483      1484  \\\n",
      "0     0.953783  0.930678  0.912757  ...  0.942787  0.937604  0.936824   \n",
      "1     0.947612  0.921918  0.903137  ...  0.935239  0.930768  0.930086   \n",
      "2     0.942818  0.942818  0.925838  ...  0.932059  0.938136  0.937347   \n",
      "3     0.957320  0.946739  0.930274  ...  0.947356  0.953030  0.952301   \n",
      "4     0.945876  0.945876  0.929288  ...  0.957156  0.952480  0.940046   \n",
      "...        ...       ...       ...  ...       ...       ...       ...   \n",
      "1487  0.955542  0.944441  0.927662  ...  0.956016  0.951537  0.950852   \n",
      "1488  0.955542  0.944441  0.927662  ...  0.956016  0.951537  0.950852   \n",
      "1489  0.955542  0.944441  0.927662  ...  0.956016  0.951537  0.950852   \n",
      "1490  0.954254  0.942818  0.925838  ...  0.943382  0.950435  0.949779   \n",
      "1491  0.952771  0.940979  0.923787  ...  0.941520  0.949149  0.948523   \n",
      "\n",
      "          1485      1486      1487      1488      1489      1490      1491  \n",
      "0     0.954645  0.964624  0.966259  0.966259  0.966259  0.965336  0.952326  \n",
      "1     0.948285  0.959971  0.961065  0.961065  0.961065  0.947612  0.946453  \n",
      "2     0.955133  0.953289  0.955542  0.955542  0.955542  0.965691  0.952771  \n",
      "3     0.968692  0.967024  0.969059  0.969059  0.969059  0.967900  0.966552  \n",
      "4     0.957631  0.966600  0.968552  0.968552  0.968552  0.956659  0.955028  \n",
      "...        ...       ...       ...       ...       ...       ...       ...  \n",
      "1487  0.967350  0.999840  1.000000  1.000000  1.000000  0.966643  0.965428  \n",
      "1488  0.967350  0.999840  1.000000  1.000000  1.000000  0.966643  0.965428  \n",
      "1489  0.967350  0.999840  1.000000  1.000000  1.000000  0.966643  0.965428  \n",
      "1490  0.966343  0.964960  0.966643  0.966643  0.966643  1.000000  0.964562  \n",
      "1491  0.965157  0.963892  0.965428  0.965428  0.965428  0.964562  1.000000  \n",
      "\n",
      "[1492 rows x 1492 columns]\n"
     ]
    }
   ],
   "source": [
    "print(similarityDF)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [],
   "source": [
    "def new_recommended_hotels(name, cosine_similarity):\n",
    "    recommended_hotels = []\n",
    "    hotel_index = hotel_df[(hotel_df.Hotel_Name == name)].index[0]\n",
    "\n",
    "    similarity_scores = similarityDF[hotel_index]\n",
    "    sorted_scores = similarity_scores.sort_values(ascending=False)\n",
    "\n",
    "    top_index = list(sorted_scores.index)\n",
    "\n",
    "    for i in range(1,11):\n",
    "        recommended_hotels.append(hotel_df[hotel_df.index == top_index[i]]['Hotel_Name'].values[0])\n",
    "    return recommended_hotels"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Mercer Hotel Barcelona',\n",
       " 'The Wittmore Adults Only',\n",
       " 'The Guesthouse Vienna',\n",
       " 'H tel D Aubusson',\n",
       " 'Mill sime H tel',\n",
       " 'Maison Souquet',\n",
       " 'The Harmonie Vienna',\n",
       " 'Grand H tel Du Palais Royal',\n",
       " 'Primero Primera',\n",
       " 'Residence Henri IV']"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new_recommended_hotels('Hotel Arena',cosine_similarity)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Hotels recommended to a user who liked  The Wittmore Adults Only\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "['Milestone Hotel Kensington',\n",
       " 'Claridge s',\n",
       " 'The Ritz London',\n",
       " 'Hotel du Collectionneur Arc de Triomphe',\n",
       " 'Mercer Hotel Barcelona',\n",
       " 'Corinthia Hotel London',\n",
       " 'The Guesthouse Vienna',\n",
       " 'Lansbury Heritage Hotel',\n",
       " 'H tel D Aubusson',\n",
       " 'Mill sime H tel']"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "hotel_input = input('Enter name of hotel: ')\n",
    "print('Hotels recommended to a user who liked ', hotel_input)\n",
    "new_recommended_hotels(hotel_input,cosine_similarity)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}