places_preprocess.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "df2698ff",
   "metadata": {},
   "source": [
    "## Places data Preprocessing and Recommendation System"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "1e3c9ae6",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "ea514d5e",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv(\"D:\\Linearloop Internship\\Project - Travel\\Project_datasets\\Review_db.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "6afa414a",
   "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>City</th>\n",
       "      <th>Place</th>\n",
       "      <th>Review</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Name</th>\n",
       "      <th>Date</th>\n",
       "      <th>Raw_Review</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Aamby Valley City</td>\n",
       "      <td>19 Degree North</td>\n",
       "      <td>aamby valley beautiful place clear blue skies ...</td>\n",
       "      <td>5</td>\n",
       "      <td>Anonymous</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Aamby valley is a beautiful place with its cle...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Aamby Valley City</td>\n",
       "      <td>19 Degree North</td>\n",
       "      <td>executed obt akshay thanx team thoroughly enjo...</td>\n",
       "      <td>4</td>\n",
       "      <td>Anonymous</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Very well executed obt by Akshay.... Thanx as ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Aamby Valley City</td>\n",
       "      <td>19 Degree North</td>\n",
       "      <td>awesome experience atv tracts obstacles mainta...</td>\n",
       "      <td>5</td>\n",
       "      <td>Anonymous</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Awesome experience at the ATV\\nTracts and obst...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Aamby Valley City</td>\n",
       "      <td>19 Degree North</td>\n",
       "      <td>visited aamby valley yesterday short excursion...</td>\n",
       "      <td>4</td>\n",
       "      <td>Anonymous</td>\n",
       "      <td>NaN</td>\n",
       "      <td>we visited the Aamby Valley yesterday for shor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Aamby Valley City</td>\n",
       "      <td>19 Degree North</td>\n",
       "      <td>far mumbai place finest adventure places visit...</td>\n",
       "      <td>5</td>\n",
       "      <td>Anonymous</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Not far from Mumbai, this place is one of the ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                City            Place  \\\n",
       "0  Aamby Valley City  19 Degree North   \n",
       "1  Aamby Valley City  19 Degree North   \n",
       "2  Aamby Valley City  19 Degree North   \n",
       "3  Aamby Valley City  19 Degree North   \n",
       "4  Aamby Valley City  19 Degree North   \n",
       "\n",
       "                                              Review  Rating       Name  Date  \\\n",
       "0  aamby valley beautiful place clear blue skies ...       5  Anonymous   NaN   \n",
       "1  executed obt akshay thanx team thoroughly enjo...       4  Anonymous   NaN   \n",
       "2  awesome experience atv tracts obstacles mainta...       5  Anonymous   NaN   \n",
       "3  visited aamby valley yesterday short excursion...       4  Anonymous   NaN   \n",
       "4  far mumbai place finest adventure places visit...       5  Anonymous   NaN   \n",
       "\n",
       "                                          Raw_Review  \n",
       "0  Aamby valley is a beautiful place with its cle...  \n",
       "1  Very well executed obt by Akshay.... Thanx as ...  \n",
       "2  Awesome experience at the ATV\\nTracts and obst...  \n",
       "3  we visited the Aamby Valley yesterday for shor...  \n",
       "4  Not far from Mumbai, this place is one of the ...  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "0d5bce81",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 1482466 entries, 0 to 1482465\n",
      "Data columns (total 7 columns):\n",
      " #   Column      Non-Null Count    Dtype  \n",
      "---  ------      --------------    -----  \n",
      " 0   City        1482466 non-null  object \n",
      " 1   Place       1482466 non-null  object \n",
      " 2   Review      1482466 non-null  object \n",
      " 3   Rating      1482466 non-null  int64  \n",
      " 4   Name        1482466 non-null  object \n",
      " 5   Date        0 non-null        float64\n",
      " 6   Raw_Review  1482466 non-null  object \n",
      "dtypes: float64(1), int64(1), object(5)\n",
      "memory usage: 79.2+ MB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "7522b37f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "City                0\n",
       "Place               0\n",
       "Review              0\n",
       "Rating              0\n",
       "Name                0\n",
       "Date          1482466\n",
       "Raw_Review          0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "49fd65a0",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.drop(columns=['Review','Name','Date'],inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "fdc35899",
   "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>City</th>\n",
       "      <th>Place</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Raw_Review</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Aamby Valley City</td>\n",
       "      <td>19 Degree North</td>\n",
       "      <td>5</td>\n",
       "      <td>Aamby valley is a beautiful place with its cle...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Aamby Valley City</td>\n",
       "      <td>19 Degree North</td>\n",
       "      <td>4</td>\n",
       "      <td>Very well executed obt by Akshay.... Thanx as ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Aamby Valley City</td>\n",
       "      <td>19 Degree North</td>\n",
       "      <td>5</td>\n",
       "      <td>Awesome experience at the ATV\\nTracts and obst...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Aamby Valley City</td>\n",
       "      <td>19 Degree North</td>\n",
       "      <td>4</td>\n",
       "      <td>we visited the Aamby Valley yesterday for shor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Aamby Valley City</td>\n",
       "      <td>19 Degree North</td>\n",
       "      <td>5</td>\n",
       "      <td>Not far from Mumbai, this place is one of the ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                City            Place  Rating  \\\n",
       "0  Aamby Valley City  19 Degree North       5   \n",
       "1  Aamby Valley City  19 Degree North       4   \n",
       "2  Aamby Valley City  19 Degree North       5   \n",
       "3  Aamby Valley City  19 Degree North       4   \n",
       "4  Aamby Valley City  19 Degree North       5   \n",
       "\n",
       "                                          Raw_Review  \n",
       "0  Aamby valley is a beautiful place with its cle...  \n",
       "1  Very well executed obt by Akshay.... Thanx as ...  \n",
       "2  Awesome experience at the ATV\\nTracts and obst...  \n",
       "3  we visited the Aamby Valley yesterday for shor...  \n",
       "4  Not far from Mumbai, this place is one of the ...  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "f8fba788",
   "metadata": {},
   "outputs": [],
   "source": [
    "average_reviews = df.groupby('Place')['Rating'].mean().reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "349d6bf6",
   "metadata": {},
   "outputs": [],
   "source": [
    "average_reviews['Rating'] = average_reviews['Rating'].round(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "ad9eb1f1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Place</th>\n",
       "      <th>Rating</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1 MG Lido Mall</td>\n",
       "      <td>4.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>10 Acres Mall</td>\n",
       "      <td>3.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1008 Lingam Temple</td>\n",
       "      <td>4.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>101 Ft. Hanuman Idol</td>\n",
       "      <td>4.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>108 Feet Height Statue Of Basaveshwara</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14489</th>\n",
       "      <td>osian camel and jeep safari</td>\n",
       "      <td>4.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14490</th>\n",
       "      <td>shree jayadurgaparameshwari Temple</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14491</th>\n",
       "      <td>tour2sundarban</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14492</th>\n",
       "      <td>unseen_uttrakhand</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14493</th>\n",
       "      <td>vijay laxmi Handicrafts</td>\n",
       "      <td>4.3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>14494 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        Place  Rating\n",
       "0                              1 MG Lido Mall     4.3\n",
       "1                               10 Acres Mall     3.2\n",
       "2                          1008 Lingam Temple     4.3\n",
       "3                        101 Ft. Hanuman Idol     4.5\n",
       "4      108 Feet Height Statue Of Basaveshwara     4.0\n",
       "...                                       ...     ...\n",
       "14489             osian camel and jeep safari     4.6\n",
       "14490      shree jayadurgaparameshwari Temple     5.0\n",
       "14491                          tour2sundarban     5.0\n",
       "14492                       unseen_uttrakhand     4.0\n",
       "14493                 vijay laxmi Handicrafts     4.3\n",
       "\n",
       "[14494 rows x 2 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "average_reviews"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "9f58079a",
   "metadata": {},
   "outputs": [],
   "source": [
    "sorted_reviews = df.sort_values(by='Rating', ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "82f403c6",
   "metadata": {},
   "outputs": [],
   "source": [
    "first_high_rated_reviews = sorted_reviews.drop_duplicates(subset='Place', keep='first')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "9d86eee5",
   "metadata": {},
   "outputs": [],
   "source": [
    "merged_reviews = pd.merge(average_reviews, first_high_rated_reviews, on='Place', suffixes=('_avg', '_first_high_rated'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "59460c77",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Place</th>\n",
       "      <th>Rating_avg</th>\n",
       "      <th>City</th>\n",
       "      <th>Rating_first_high_rated</th>\n",
       "      <th>Raw_Review</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1 MG Lido Mall</td>\n",
       "      <td>4.3</td>\n",
       "      <td>Bengaluru</td>\n",
       "      <td>5</td>\n",
       "      <td>Spent the Sunday at the 4th floor play area fo...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>10 Acres Mall</td>\n",
       "      <td>3.2</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>5</td>\n",
       "      <td>10 Acres Mall or Ahmedabad City Mall spans acr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1008 Lingam Temple</td>\n",
       "      <td>4.3</td>\n",
       "      <td>Salem</td>\n",
       "      <td>5</td>\n",
       "      <td>1008 shiv lingas in one spot and name a good, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>101 Ft. Hanuman Idol</td>\n",
       "      <td>4.5</td>\n",
       "      <td>Chhindwara</td>\n",
       "      <td>5</td>\n",
       "      <td>This is a good place to visit with the kids. T...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>108 Feet Height Statue Of Basaveshwara</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Bidar</td>\n",
       "      <td>5</td>\n",
       "      <td>It's really a very beautiful place to have goo...</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>14489</th>\n",
       "      <td>osian camel and jeep safari</td>\n",
       "      <td>4.6</td>\n",
       "      <td>Osian</td>\n",
       "      <td>5</td>\n",
       "      <td>jodhpurs to osian 63 km really desert experien...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14490</th>\n",
       "      <td>shree jayadurgaparameshwari Temple</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Udupi</td>\n",
       "      <td>5</td>\n",
       "      <td>This is an amazing temple located at Kini Mulk...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14491</th>\n",
       "      <td>tour2sundarban</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Canning</td>\n",
       "      <td>5</td>\n",
       "      <td>Very helpful tour in economic budget... Highly...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14492</th>\n",
       "      <td>unseen_uttrakhand</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Tanakpur</td>\n",
       "      <td>4</td>\n",
       "      <td>nice trip with unseen uttrakhand its really ve...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14493</th>\n",
       "      <td>vijay laxmi Handicrafts</td>\n",
       "      <td>4.3</td>\n",
       "      <td>Barmer</td>\n",
       "      <td>5</td>\n",
       "      <td>A place to visit, love and appreciate the Art....</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>14494 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        Place  Rating_avg        City  \\\n",
       "0                              1 MG Lido Mall         4.3   Bengaluru   \n",
       "1                               10 Acres Mall         3.2   Ahmedabad   \n",
       "2                          1008 Lingam Temple         4.3       Salem   \n",
       "3                        101 Ft. Hanuman Idol         4.5  Chhindwara   \n",
       "4      108 Feet Height Statue Of Basaveshwara         4.0       Bidar   \n",
       "...                                       ...         ...         ...   \n",
       "14489             osian camel and jeep safari         4.6       Osian   \n",
       "14490      shree jayadurgaparameshwari Temple         5.0       Udupi   \n",
       "14491                          tour2sundarban         5.0     Canning   \n",
       "14492                       unseen_uttrakhand         4.0    Tanakpur   \n",
       "14493                 vijay laxmi Handicrafts         4.3      Barmer   \n",
       "\n",
       "       Rating_first_high_rated  \\\n",
       "0                            5   \n",
       "1                            5   \n",
       "2                            5   \n",
       "3                            5   \n",
       "4                            5   \n",
       "...                        ...   \n",
       "14489                        5   \n",
       "14490                        5   \n",
       "14491                        5   \n",
       "14492                        4   \n",
       "14493                        5   \n",
       "\n",
       "                                              Raw_Review  \n",
       "0      Spent the Sunday at the 4th floor play area fo...  \n",
       "1      10 Acres Mall or Ahmedabad City Mall spans acr...  \n",
       "2      1008 shiv lingas in one spot and name a good, ...  \n",
       "3      This is a good place to visit with the kids. T...  \n",
       "4      It's really a very beautiful place to have goo...  \n",
       "...                                                  ...  \n",
       "14489  jodhpurs to osian 63 km really desert experien...  \n",
       "14490  This is an amazing temple located at Kini Mulk...  \n",
       "14491  Very helpful tour in economic budget... Highly...  \n",
       "14492  nice trip with unseen uttrakhand its really ve...  \n",
       "14493  A place to visit, love and appreciate the Art....  \n",
       "\n",
       "[14494 rows x 5 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged_reviews"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "89896d4a",
   "metadata": {},
   "outputs": [],
   "source": [
    "main_df = merged_reviews[['Place','City','Rating_avg','Raw_Review']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "faa47e9e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Place</th>\n",
       "      <th>City</th>\n",
       "      <th>Rating_avg</th>\n",
       "      <th>Raw_Review</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1 MG Lido Mall</td>\n",
       "      <td>Bengaluru</td>\n",
       "      <td>4.3</td>\n",
       "      <td>Spent the Sunday at the 4th floor play area fo...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>10 Acres Mall</td>\n",
       "      <td>Ahmedabad</td>\n",
       "      <td>3.2</td>\n",
       "      <td>10 Acres Mall or Ahmedabad City Mall spans acr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1008 Lingam Temple</td>\n",
       "      <td>Salem</td>\n",
       "      <td>4.3</td>\n",
       "      <td>1008 shiv lingas in one spot and name a good, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>101 Ft. Hanuman Idol</td>\n",
       "      <td>Chhindwara</td>\n",
       "      <td>4.5</td>\n",
       "      <td>This is a good place to visit with the kids. T...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>108 Feet Height Statue Of Basaveshwara</td>\n",
       "      <td>Bidar</td>\n",
       "      <td>4.0</td>\n",
       "      <td>It's really a very beautiful place to have goo...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14489</th>\n",
       "      <td>osian camel and jeep safari</td>\n",
       "      <td>Osian</td>\n",
       "      <td>4.6</td>\n",
       "      <td>jodhpurs to osian 63 km really desert experien...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14490</th>\n",
       "      <td>shree jayadurgaparameshwari Temple</td>\n",
       "      <td>Udupi</td>\n",
       "      <td>5.0</td>\n",
       "      <td>This is an amazing temple located at Kini Mulk...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14491</th>\n",
       "      <td>tour2sundarban</td>\n",
       "      <td>Canning</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Very helpful tour in economic budget... Highly...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14492</th>\n",
       "      <td>unseen_uttrakhand</td>\n",
       "      <td>Tanakpur</td>\n",
       "      <td>4.0</td>\n",
       "      <td>nice trip with unseen uttrakhand its really ve...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14493</th>\n",
       "      <td>vijay laxmi Handicrafts</td>\n",
       "      <td>Barmer</td>\n",
       "      <td>4.3</td>\n",
       "      <td>A place to visit, love and appreciate the Art....</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>14494 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        Place        City  Rating_avg  \\\n",
       "0                              1 MG Lido Mall   Bengaluru         4.3   \n",
       "1                               10 Acres Mall   Ahmedabad         3.2   \n",
       "2                          1008 Lingam Temple       Salem         4.3   \n",
       "3                        101 Ft. Hanuman Idol  Chhindwara         4.5   \n",
       "4      108 Feet Height Statue Of Basaveshwara       Bidar         4.0   \n",
       "...                                       ...         ...         ...   \n",
       "14489             osian camel and jeep safari       Osian         4.6   \n",
       "14490      shree jayadurgaparameshwari Temple       Udupi         5.0   \n",
       "14491                          tour2sundarban     Canning         5.0   \n",
       "14492                       unseen_uttrakhand    Tanakpur         4.0   \n",
       "14493                 vijay laxmi Handicrafts      Barmer         4.3   \n",
       "\n",
       "                                              Raw_Review  \n",
       "0      Spent the Sunday at the 4th floor play area fo...  \n",
       "1      10 Acres Mall or Ahmedabad City Mall spans acr...  \n",
       "2      1008 shiv lingas in one spot and name a good, ...  \n",
       "3      This is a good place to visit with the kids. T...  \n",
       "4      It's really a very beautiful place to have goo...  \n",
       "...                                                  ...  \n",
       "14489  jodhpurs to osian 63 km really desert experien...  \n",
       "14490  This is an amazing temple located at Kini Mulk...  \n",
       "14491  Very helpful tour in economic budget... Highly...  \n",
       "14492  nice trip with unseen uttrakhand its really ve...  \n",
       "14493  A place to visit, love and appreciate the Art....  \n",
       "\n",
       "[14494 rows x 4 columns]"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "main_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "id": "ab736f80",
   "metadata": {},
   "outputs": [],
   "source": [
    "main_df['Data'] = main_df['Place'] + main_df['Description']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "30910687",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Bengaluru', 'Ahmedabad', 'Salem', ..., 'Sonmarg', 'Etmadpur',\n",
       "       'Tanakpur'], dtype=object)"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "main_df.City.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "676e601f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1763"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "main_df.City.nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "fc1c02a5",
   "metadata": {},
   "outputs": [],
   "source": [
    "change_c = {\n",
    "    'Rating_avg' : 'Rating',\n",
    "    'Raw_Review' : 'Description'\n",
    "}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "bacc1fb7",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\Admin\\AppData\\Local\\Temp\\ipykernel_33752\\1264517634.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  main_df.rename(columns=change_c, inplace=True)\n"
     ]
    }
   ],
   "source": [
    "main_df.rename(columns=change_c, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "id": "08e88438",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Place</th>\n",
       "      <th>City</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Description</th>\n",
       "      <th>Data</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1 mg lido mall</td>\n",
       "      <td>bengaluru</td>\n",
       "      <td>4.3</td>\n",
       "      <td>spent the sunday at the 4th floor play area fo...</td>\n",
       "      <td>1 mg lido mallspent the sunday at the 4th floo...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>10 acres mall</td>\n",
       "      <td>ahmedabad</td>\n",
       "      <td>3.2</td>\n",
       "      <td>10 acres mall or ahmedabad city mall spans acr...</td>\n",
       "      <td>10 acres mall10 acres mall or ahmedabad city m...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1008 lingam temple</td>\n",
       "      <td>salem</td>\n",
       "      <td>4.3</td>\n",
       "      <td>1008 shiv lingas in one spot and name a good, ...</td>\n",
       "      <td>1008 lingam temple1008 shiv lingas in one spot...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>101 ft. hanuman idol</td>\n",
       "      <td>chhindwara</td>\n",
       "      <td>4.5</td>\n",
       "      <td>this is a good place to visit with the kids. t...</td>\n",
       "      <td>101 ft. hanuman idolthis is a good place to vi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>108 feet height statue of basaveshwara</td>\n",
       "      <td>bidar</td>\n",
       "      <td>4.0</td>\n",
       "      <td>it's really a very beautiful place to have goo...</td>\n",
       "      <td>108 feet height statue of basaveshwarait's rea...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    Place        City  Rating  \\\n",
       "0                          1 mg lido mall   bengaluru     4.3   \n",
       "1                           10 acres mall   ahmedabad     3.2   \n",
       "2                      1008 lingam temple       salem     4.3   \n",
       "3                    101 ft. hanuman idol  chhindwara     4.5   \n",
       "4  108 feet height statue of basaveshwara       bidar     4.0   \n",
       "\n",
       "                                         Description  \\\n",
       "0  spent the sunday at the 4th floor play area fo...   \n",
       "1  10 acres mall or ahmedabad city mall spans acr...   \n",
       "2  1008 shiv lingas in one spot and name a good, ...   \n",
       "3  this is a good place to visit with the kids. t...   \n",
       "4  it's really a very beautiful place to have goo...   \n",
       "\n",
       "                                                Data  \n",
       "0  1 mg lido mallspent the sunday at the 4th floo...  \n",
       "1  10 acres mall10 acres mall or ahmedabad city m...  \n",
       "2  1008 lingam temple1008 shiv lingas in one spot...  \n",
       "3  101 ft. hanuman idolthis is a good place to vi...  \n",
       "4  108 feet height statue of basaveshwarait's rea...  "
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "main_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "3edc041e",
   "metadata": {},
   "outputs": [],
   "source": [
    "def citybased(city):\n",
    "    main_df['City'] = main_df['City'].str.lower()\n",
    "    citybase = main_df[main_df['City'] == city.lower()]\n",
    "    citybase = citybase.sort_values(by='Rating', ascending=False)\n",
    "    if(citybase.empty==0):\n",
    "        hname = citybase[['Place','City','Rating','Description']]\n",
    "        return hname.head(10)\n",
    "    else:\n",
    "        print('No Places to visit!')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "id": "b95014ed",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\Admin\\AppData\\Local\\Temp\\ipykernel_33752\\395657.py:2: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  main_df['City'] = main_df['City'].str.lower()\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Place</th>\n",
       "      <th>City</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>10460</th>\n",
       "      <td>Rozy Falls</td>\n",
       "      <td>manali</td>\n",
       "      <td>4.6</td>\n",
       "      <td>this place is beautiful.\\nthe stream of water ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7592</th>\n",
       "      <td>Manali Picnic Spot and Camps</td>\n",
       "      <td>manali</td>\n",
       "      <td>4.6</td>\n",
       "      <td>Manal is a beautiful hill station in himachal ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14435</th>\n",
       "      <td>Zana Falls</td>\n",
       "      <td>manali</td>\n",
       "      <td>4.4</td>\n",
       "      <td>Awesome waterfall with tables and chairs just ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>680</th>\n",
       "      <td>Arjun Gufa</td>\n",
       "      <td>manali</td>\n",
       "      <td>4.4</td>\n",
       "      <td>historic and mythological place..normal cave l...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1341</th>\n",
       "      <td>Beas River</td>\n",
       "      <td>manali</td>\n",
       "      <td>4.4</td>\n",
       "      <td>Manali is situated in the bank of beas river.....</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5107</th>\n",
       "      <td>International Roerich Memorial Trust</td>\n",
       "      <td>manali</td>\n",
       "      <td>4.4</td>\n",
       "      <td>This place haveing older equipment and past us...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4774</th>\n",
       "      <td>Himvalley Manali Amusement &amp; Culture Park</td>\n",
       "      <td>manali</td>\n",
       "      <td>4.4</td>\n",
       "      <td>Very Nice Place. We have enjoyed the Bhangra &amp;...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5496</th>\n",
       "      <td>Jogini Waterfall</td>\n",
       "      <td>manali</td>\n",
       "      <td>4.3</td>\n",
       "      <td>A must visit place in manali. The waterfall's ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7673</th>\n",
       "      <td>Manikaran Gurudwara</td>\n",
       "      <td>manali</td>\n",
       "      <td>4.3</td>\n",
       "      <td>Beautiful place\\nFree food\\nFree beverages \\nP...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10197</th>\n",
       "      <td>Rani Nala</td>\n",
       "      <td>manali</td>\n",
       "      <td>4.3</td>\n",
       "      <td>One of the nice things in and around Rohtang P...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           Place    City  Rating  \\\n",
       "10460                                 Rozy Falls  manali     4.6   \n",
       "7592                Manali Picnic Spot and Camps  manali     4.6   \n",
       "14435                                 Zana Falls  manali     4.4   \n",
       "680                                   Arjun Gufa  manali     4.4   \n",
       "1341                                  Beas River  manali     4.4   \n",
       "5107        International Roerich Memorial Trust  manali     4.4   \n",
       "4774   Himvalley Manali Amusement & Culture Park  manali     4.4   \n",
       "5496                            Jogini Waterfall  manali     4.3   \n",
       "7673                         Manikaran Gurudwara  manali     4.3   \n",
       "10197                                  Rani Nala  manali     4.3   \n",
       "\n",
       "                                             Description  \n",
       "10460  this place is beautiful.\\nthe stream of water ...  \n",
       "7592   Manal is a beautiful hill station in himachal ...  \n",
       "14435  Awesome waterfall with tables and chairs just ...  \n",
       "680    historic and mythological place..normal cave l...  \n",
       "1341   Manali is situated in the bank of beas river.....  \n",
       "5107   This place haveing older equipment and past us...  \n",
       "4774   Very Nice Place. We have enjoyed the Bhangra &...  \n",
       "5496   A must visit place in manali. The waterfall's ...  \n",
       "7673   Beautiful place\\nFree food\\nFree beverages \\nP...  \n",
       "10197  One of the nice things in and around Rohtang P...  "
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "citybased('Manali')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "470035fa",
   "metadata": {},
   "outputs": [],
   "source": [
    "import nltk\n",
    "from nltk.tokenize import word_tokenize\n",
    "from nltk.stem import WordNetLemmatizer\n",
    "from nltk.corpus import stopwords"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "id": "dde0675f",
   "metadata": {},
   "outputs": [],
   "source": [
    "def requirementbased(city, attractions):\n",
    "    main_df['Place'] = main_df['Place'].str.lower()\n",
    "    main_df['Data'] = main_df['Data'].str.lower()\n",
    "    attractions = attractions.lower()\n",
    "    attractions_token = word_tokenize(attractions)\n",
    "    sw = stopwords.words('english')\n",
    "    lemm = WordNetLemmatizer()\n",
    "    f1_set = {w for w in attractions_token if not w in sw}\n",
    "    f_set = set()\n",
    "    for se in f1_set:\n",
    "        f_set.add(lemm.lemmatize(se))\n",
    "    reqbased = main_df[main_df['City'] == city.lower()]\n",
    "    if reqbased.empty:\n",
    "        print(\"No attractions data found for this city.\")\n",
    "        return None\n",
    "    reqbased = reqbased.sort_values(by='Rating', ascending=False).reset_index(drop=True)\n",
    "    cos = []\n",
    "\n",
    "    for i in range(reqbased.shape[0]):\n",
    "        temp_tokens = word_tokenize(reqbased['Data'][i])\n",
    "        temp1_set = {w for w in temp_tokens if not w in sw}\n",
    "        temp_set = set()\n",
    "        for se in temp1_set:\n",
    "            temp_set.add(lemm.lemmatize(se))\n",
    "        revector = temp_set.intersection(f_set)\n",
    "        cos.append(len(revector))\n",
    "    reqbased['Similarity'] = cos\n",
    "    reqbased = reqbased.sort_values(by='Similarity', ascending=False).reset_index(drop=True)\n",
    "    return reqbased[['Place', 'City', 'Rating', 'Description', 'Similarity']].head(10)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "id": "d9986a14",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Place</th>\n",
       "      <th>City</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Description</th>\n",
       "      <th>Similarity</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>himalaya nyingmapa buddhist temple</td>\n",
       "      <td>manali</td>\n",
       "      <td>4.2</td>\n",
       "      <td>himalayan nyingmapa gompa is a buddhist monast...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>gadhan thekchhokling gompa monastery</td>\n",
       "      <td>manali</td>\n",
       "      <td>4.3</td>\n",
       "      <td>i visited the monastery twice as it was at a w...</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>rozy falls</td>\n",
       "      <td>manali</td>\n",
       "      <td>4.6</td>\n",
       "      <td>this place is beautiful.\\nthe stream of water ...</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>rahala falls</td>\n",
       "      <td>manali</td>\n",
       "      <td>4.1</td>\n",
       "      <td>we went rafting. we enjoyed it fully. the fall...</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>lamadugh trek</td>\n",
       "      <td>manali</td>\n",
       "      <td>4.2</td>\n",
       "      <td>this place is famous for treak and we treak fr...</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>jana waterfall</td>\n",
       "      <td>manali</td>\n",
       "      <td>4.2</td>\n",
       "      <td>the fall is not so great,  but the path that l...</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>jamula temple</td>\n",
       "      <td>manali</td>\n",
       "      <td>4.2</td>\n",
       "      <td>you need to trek to reach the temple which is ...</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>beas kund</td>\n",
       "      <td>manali</td>\n",
       "      <td>4.2</td>\n",
       "      <td>being a student of tourism ,my learning has ta...</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>pandoh dam</td>\n",
       "      <td>manali</td>\n",
       "      <td>4.1</td>\n",
       "      <td>on the way to manali the dam offers great sigh...</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>gulaba</td>\n",
       "      <td>manali</td>\n",
       "      <td>4.1</td>\n",
       "      <td>the views all around gulaba camp are absolutel...</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  Place    City  Rating  \\\n",
       "0    himalaya nyingmapa buddhist temple  manali     4.2   \n",
       "1  gadhan thekchhokling gompa monastery  manali     4.3   \n",
       "2                            rozy falls  manali     4.6   \n",
       "3                          rahala falls  manali     4.1   \n",
       "4                         lamadugh trek  manali     4.2   \n",
       "5                        jana waterfall  manali     4.2   \n",
       "6                         jamula temple  manali     4.2   \n",
       "7                             beas kund  manali     4.2   \n",
       "8                            pandoh dam  manali     4.1   \n",
       "9                                gulaba  manali     4.1   \n",
       "\n",
       "                                         Description  Similarity  \n",
       "0  himalayan nyingmapa gompa is a buddhist monast...           1  \n",
       "1  i visited the monastery twice as it was at a w...           1  \n",
       "2  this place is beautiful.\\nthe stream of water ...           0  \n",
       "3  we went rafting. we enjoyed it fully. the fall...           0  \n",
       "4  this place is famous for treak and we treak fr...           0  \n",
       "5  the fall is not so great,  but the path that l...           0  \n",
       "6  you need to trek to reach the temple which is ...           0  \n",
       "7  being a student of tourism ,my learning has ta...           0  \n",
       "8  on the way to manali the dam offers great sigh...           0  \n",
       "9  the views all around gulaba camp are absolutel...           0  "
      ]
     },
     "execution_count": 67,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "requirementbased('manali','monastery')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "id": "578c7ba5",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pickle\n",
    "\n",
    "\n",
    "with open('places_dataframe.pkl', 'wb') as f:\n",
    "    pickle.dump(main_df, f)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "c59c855d",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}