Data_Cleaning.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Mumbai',\n",
       " 'Bangalore',\n",
       " 'Hyderabad.csv',\n",
       " 'Delhi.csv',\n",
       " '.DS_Store',\n",
       " 'Chennai.csv',\n",
       " 'Mumbai.csv',\n",
       " 'Data_Cleaning.ipynb',\n",
       " 'Hyderabad',\n",
       " 'Chennai',\n",
       " 'Final_Dataset.csv',\n",
       " 'Delhi',\n",
       " 'Data_Understanding.ipynb',\n",
       " 'Bangalore.csv',\n",
       " 'Final_Dataset.ipynb',\n",
       " '.ipynb_checkpoints']"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import os\n",
    "os.listdir()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "df=pd.read_csv('Final_Dataset.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>Name</th>\n",
       "      <th>Original_price</th>\n",
       "      <th>Offer</th>\n",
       "      <th>Final_price</th>\n",
       "      <th>Distance</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Number of Rating</th>\n",
       "      <th>Summary</th>\n",
       "      <th>Location</th>\n",
       "      <th>City</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>14180</td>\n",
       "      <td>14180</td>\n",
       "      <td>14180</td>\n",
       "      <td>14180</td>\n",
       "      <td>14180</td>\n",
       "      <td>14180</td>\n",
       "      <td>12901</td>\n",
       "      <td>12901</td>\n",
       "      <td>14180</td>\n",
       "      <td>14180</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>unique</th>\n",
       "      <td>2195</td>\n",
       "      <td>1460</td>\n",
       "      <td>39</td>\n",
       "      <td>1231</td>\n",
       "      <td>199</td>\n",
       "      <td>43</td>\n",
       "      <td>1002</td>\n",
       "      <td>5</td>\n",
       "      <td>100</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>top</th>\n",
       "      <td>Capital O 2083 Hotel Blessings Deluxe</td>\n",
       "      <td>₹1777</td>\n",
       "      <td>32% off</td>\n",
       "      <td>₹1010</td>\n",
       "      <td>4.4 km</td>\n",
       "      <td>NEW</td>\n",
       "      <td>(164 Ratings)</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Mahipalpur</td>\n",
       "      <td>Delhi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>freq</th>\n",
       "      <td>30</td>\n",
       "      <td>675</td>\n",
       "      <td>11272</td>\n",
       "      <td>1082</td>\n",
       "      <td>202</td>\n",
       "      <td>1279</td>\n",
       "      <td>83</td>\n",
       "      <td>5999</td>\n",
       "      <td>340</td>\n",
       "      <td>4280</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                         Name Original_price    Offer  \\\n",
       "count                                   14180          14180    14180   \n",
       "unique                                   2195           1460       39   \n",
       "top     Capital O 2083 Hotel Blessings Deluxe          ₹1777  32% off   \n",
       "freq                                       30            675    11272   \n",
       "\n",
       "       Final_price Distance Rating Number of Rating    Summary    Location  \\\n",
       "count        14180    14180  14180            12901      12901       14180   \n",
       "unique        1231      199     43             1002          5         100   \n",
       "top          ₹1010   4.4 km    NEW    (164 Ratings)  Very Good  Mahipalpur   \n",
       "freq          1082      202   1279               83       5999         340   \n",
       "\n",
       "         City  \n",
       "count   14180  \n",
       "unique      5  \n",
       "top     Delhi  \n",
       "freq     4280  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>Name</th>\n",
       "      <th>Original_price</th>\n",
       "      <th>Offer</th>\n",
       "      <th>Final_price</th>\n",
       "      <th>Distance</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Number of Rating</th>\n",
       "      <th>Summary</th>\n",
       "      <th>Location</th>\n",
       "      <th>City</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>14180</td>\n",
       "      <td>14180</td>\n",
       "      <td>14180</td>\n",
       "      <td>14180</td>\n",
       "      <td>14180</td>\n",
       "      <td>14180</td>\n",
       "      <td>12901</td>\n",
       "      <td>12901</td>\n",
       "      <td>14180</td>\n",
       "      <td>14180</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>unique</th>\n",
       "      <td>2195</td>\n",
       "      <td>1460</td>\n",
       "      <td>39</td>\n",
       "      <td>1231</td>\n",
       "      <td>199</td>\n",
       "      <td>43</td>\n",
       "      <td>1002</td>\n",
       "      <td>5</td>\n",
       "      <td>100</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>top</th>\n",
       "      <td>Capital O 2083 Hotel Blessings Deluxe</td>\n",
       "      <td>₹1777</td>\n",
       "      <td>32% off</td>\n",
       "      <td>₹1010</td>\n",
       "      <td>4.4 km</td>\n",
       "      <td>NEW</td>\n",
       "      <td>(164 Ratings)</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Mahipalpur</td>\n",
       "      <td>Delhi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>freq</th>\n",
       "      <td>30</td>\n",
       "      <td>675</td>\n",
       "      <td>11272</td>\n",
       "      <td>1082</td>\n",
       "      <td>202</td>\n",
       "      <td>1279</td>\n",
       "      <td>83</td>\n",
       "      <td>5999</td>\n",
       "      <td>340</td>\n",
       "      <td>4280</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                         Name Original_price    Offer  \\\n",
       "count                                   14180          14180    14180   \n",
       "unique                                   2195           1460       39   \n",
       "top     Capital O 2083 Hotel Blessings Deluxe          ₹1777  32% off   \n",
       "freq                                       30            675    11272   \n",
       "\n",
       "       Final_price Distance Rating Number of Rating    Summary    Location  \\\n",
       "count        14180    14180  14180            12901      12901       14180   \n",
       "unique        1231      199     43             1002          5         100   \n",
       "top          ₹1010   4.4 km    NEW    (164 Ratings)  Very Good  Mahipalpur   \n",
       "freq          1082      202   1279               83       5999         340   \n",
       "\n",
       "         City  \n",
       "count   14180  \n",
       "unique      5  \n",
       "top     Delhi  \n",
       "freq     4280  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.describe(include='all')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "NEW     1279\n",
       "4.2     1057\n",
       "4.1     1038\n",
       "4.3      942\n",
       "4.0      878\n",
       "3.9      803\n",
       "4.4      734\n",
       "3.8      672\n",
       "4.5      655\n",
       "3.6      594\n",
       "3.7      516\n",
       "4.6      463\n",
       "4.4      399\n",
       "3.5      378\n",
       "4.3      277\n",
       "3.3      273\n",
       "4.5      267\n",
       "4.2      249\n",
       "4        234\n",
       "3.4      219\n",
       "4.7      204\n",
       "4.8      179\n",
       "4.1      179\n",
       "3.9      175\n",
       "3.2      174\n",
       "4.6      164\n",
       "3.6      146\n",
       "3.8      135\n",
       "3.1      133\n",
       "3.7      121\n",
       "3.0      113\n",
       "4.7      100\n",
       "3.4       73\n",
       "3.2       69\n",
       "4.8       57\n",
       "5.0       55\n",
       "3.3       49\n",
       "3.1       44\n",
       "3.5       29\n",
       "4.9       26\n",
       "4.0       12\n",
       "4.9        8\n",
       "3          8\n",
       "Name: Rating, dtype: int64"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Rating'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1279"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Number of Rating'].isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1279"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Summary'].isnull().sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "- We can see that there are 14180 hotels in the list.\n",
    "- We can also understand that number of ratings and summary is missing for every 'NEW' Hotel."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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>Name</th>\n",
       "      <th>Original_price</th>\n",
       "      <th>Offer</th>\n",
       "      <th>Final_price</th>\n",
       "      <th>Distance</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Number of Rating</th>\n",
       "      <th>Summary</th>\n",
       "      <th>Location</th>\n",
       "      <th>City</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>OYO 22085 Raj Banjara White House</td>\n",
       "      <td>₹2459</td>\n",
       "      <td>32% off</td>\n",
       "      <td>₹1677</td>\n",
       "      <td>1.7 km</td>\n",
       "      <td>4.4</td>\n",
       "      <td>(201 Ratings)</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Collection O 42514 Venkat Nagar</td>\n",
       "      <td>₹3158</td>\n",
       "      <td>32% off</td>\n",
       "      <td>₹2153</td>\n",
       "      <td>1.6 km</td>\n",
       "      <td>4.4</td>\n",
       "      <td>(879 Ratings)</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Capital O 44354 Jubilee Banjara Suites</td>\n",
       "      <td>₹1778</td>\n",
       "      <td>32% off</td>\n",
       "      <td>₹1213</td>\n",
       "      <td>1.1 km</td>\n",
       "      <td>4.4</td>\n",
       "      <td>(1258 Ratings)</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>OYO 35487 Hotel Meena Grand</td>\n",
       "      <td>₹2090</td>\n",
       "      <td>32% off</td>\n",
       "      <td>₹1425</td>\n",
       "      <td>4.0 km</td>\n",
       "      <td>4</td>\n",
       "      <td>(575 Ratings)</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>OYO 16018 Rainbow Saphire</td>\n",
       "      <td>₹2607</td>\n",
       "      <td>32% off</td>\n",
       "      <td>₹1777</td>\n",
       "      <td>4.6 km</td>\n",
       "      <td>4.7</td>\n",
       "      <td>(978 Ratings)</td>\n",
       "      <td>Excellent</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                     Name Original_price    Offer Final_price  \\\n",
       "0       OYO 22085 Raj Banjara White House          ₹2459  32% off       ₹1677   \n",
       "1         Collection O 42514 Venkat Nagar          ₹3158  32% off       ₹2153   \n",
       "2  Capital O 44354 Jubilee Banjara Suites          ₹1778  32% off       ₹1213   \n",
       "3             OYO 35487 Hotel Meena Grand          ₹2090  32% off       ₹1425   \n",
       "4               OYO 16018 Rainbow Saphire          ₹2607  32% off       ₹1777   \n",
       "\n",
       "  Distance Rating Number of Rating    Summary       Location       City  \n",
       "0   1.7 km    4.4    (201 Ratings)  Very Good  Banjara Hills  Hyderabad  \n",
       "1   1.6 km    4.4    (879 Ratings)  Very Good  Banjara Hills  Hyderabad  \n",
       "2   1.1 km    4.4   (1258 Ratings)  Very Good  Banjara Hills  Hyderabad  \n",
       "3   4.0 km      4    (575 Ratings)  Very Good  Banjara Hills  Hyderabad  \n",
       "4   4.6 km    4.7    (978 Ratings)  Excellent  Banjara Hills  Hyderabad  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(14180, 10)"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Name', 'Original_price', 'Offer', 'Final_price', 'Distance', 'Rating',\n",
       "       'Number of Rating', 'Summary', 'Location', 'City'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 14180 entries, 0 to 14179\n",
      "Data columns (total 10 columns):\n",
      "Name                14180 non-null object\n",
      "Original_price      14180 non-null object\n",
      "Offer               14180 non-null object\n",
      "Final_price         14180 non-null object\n",
      "Distance            14180 non-null object\n",
      "Rating              14180 non-null object\n",
      "Number of Rating    12901 non-null object\n",
      "Summary             12901 non-null object\n",
      "Location            14180 non-null object\n",
      "City                14180 non-null object\n",
      "dtypes: object(10)\n",
      "memory usage: 1.1+ MB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Name                object\n",
       "Original_price      object\n",
       "Offer               object\n",
       "Final_price         object\n",
       "Distance            object\n",
       "Rating              object\n",
       "Number of Rating    object\n",
       "Summary             object\n",
       "Location            object\n",
       "City                object\n",
       "dtype: object"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Name                   0\n",
       "Original_price         0\n",
       "Offer                  0\n",
       "Final_price            0\n",
       "Distance               0\n",
       "Rating                 0\n",
       "Number of Rating    1279\n",
       "Summary             1279\n",
       "Location               0\n",
       "City                   0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0        False\n",
       "1        False\n",
       "2        False\n",
       "3        False\n",
       "4        False\n",
       "5        False\n",
       "6        False\n",
       "7        False\n",
       "8        False\n",
       "9        False\n",
       "10       False\n",
       "11       False\n",
       "12        True\n",
       "13       False\n",
       "14       False\n",
       "15       False\n",
       "16       False\n",
       "17       False\n",
       "18       False\n",
       "19       False\n",
       "20       False\n",
       "21       False\n",
       "22       False\n",
       "23       False\n",
       "24       False\n",
       "25       False\n",
       "26       False\n",
       "27       False\n",
       "28       False\n",
       "29       False\n",
       "         ...  \n",
       "14150    False\n",
       "14151     True\n",
       "14152    False\n",
       "14153    False\n",
       "14154    False\n",
       "14155    False\n",
       "14156    False\n",
       "14157    False\n",
       "14158    False\n",
       "14159     True\n",
       "14160    False\n",
       "14161    False\n",
       "14162     True\n",
       "14163    False\n",
       "14164    False\n",
       "14165     True\n",
       "14166     True\n",
       "14167    False\n",
       "14168    False\n",
       "14169    False\n",
       "14170    False\n",
       "14171    False\n",
       "14172     True\n",
       "14173    False\n",
       "14174    False\n",
       "14175    False\n",
       "14176    False\n",
       "14177    False\n",
       "14178    False\n",
       "14179    False\n",
       "Length: 14180, dtype: bool"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.isnull().any(axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1279"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.isnull().any(axis=1).sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['Number of Rating'].fillna('(0 Ratings)',inplace=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "- We have replaced evey null value in the number of ratings by 0, to maintain the authenticity in the data."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['Summary'].fillna('Yet to be summarised',inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 14180 entries, 0 to 14179\n",
      "Data columns (total 10 columns):\n",
      "Name                14180 non-null object\n",
      "Original_price      14180 non-null object\n",
      "Offer               14180 non-null object\n",
      "Final_price         14180 non-null object\n",
      "Distance            14180 non-null object\n",
      "Rating              14180 non-null object\n",
      "Number of Rating    14180 non-null object\n",
      "Summary             14180 non-null object\n",
      "Location            14180 non-null object\n",
      "City                14180 non-null object\n",
      "dtypes: object(10)\n",
      "memory usage: 1.1+ MB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Name                0\n",
       "Original_price      0\n",
       "Offer               0\n",
       "Final_price         0\n",
       "Distance            0\n",
       "Rating              0\n",
       "Number of Rating    0\n",
       "Summary             0\n",
       "Location            0\n",
       "City                0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.isnull().any(axis=1).sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(0 Ratings)       1279\n",
       "(164 Ratings)       83\n",
       "(279 Ratings)       74\n",
       "(1 Ratings)         71\n",
       "(283 Ratings)       65\n",
       "(114 Ratings)       63\n",
       "(108 Ratings)       61\n",
       "(21 Ratings)        56\n",
       "(33 Ratings)        55\n",
       "(271 Ratings)       51\n",
       "(143 Ratings)       50\n",
       "(161 Ratings)       50\n",
       "(221 Ratings)       50\n",
       "(559 Ratings)       49\n",
       "(79 Ratings)        49\n",
       "(168 Ratings)       47\n",
       "(252 Ratings)       47\n",
       "(152 Ratings)       46\n",
       "(340 Ratings)       45\n",
       "(306 Ratings)       44\n",
       "(294 Ratings)       44\n",
       "(286 Ratings)       44\n",
       "(159 Ratings)       44\n",
       "(81 Ratings)        44\n",
       "(116 Ratings)       43\n",
       "(121 Ratings)       43\n",
       "(266 Ratings)       43\n",
       "(349 Ratings)       42\n",
       "(228 Ratings)       42\n",
       "(134 Ratings)       42\n",
       "                  ... \n",
       "(5926 Ratings)       1\n",
       "(5773 Ratings)       1\n",
       "(1425 Ratings)       1\n",
       "(1252 Ratings)       1\n",
       "(1973 Ratings)       1\n",
       "(2805 Ratings)       1\n",
       "(1893 Ratings)       1\n",
       "(1848 Ratings)       1\n",
       "(1535 Ratings)       1\n",
       "(85 Ratings)         1\n",
       "(2577 Ratings)       1\n",
       "(565 Ratings)        1\n",
       "(491 Ratings)        1\n",
       "(1113 Ratings)       1\n",
       "(1112 Ratings)       1\n",
       "(481 Ratings)        1\n",
       "(155 Ratings)        1\n",
       "(4550 Ratings)       1\n",
       "(1157 Ratings)       1\n",
       "(387 Ratings)        1\n",
       "(1670 Ratings)       1\n",
       "(10 Ratings)         1\n",
       "(714 Ratings)        1\n",
       "(520 Ratings)        1\n",
       "(819 Ratings)        1\n",
       "(3759 Ratings)       1\n",
       "(358 Ratings)        1\n",
       "(1992 Ratings)       1\n",
       "(823 Ratings)        1\n",
       "(557 Ratings)        1\n",
       "Name: Number of Rating, Length: 1003, dtype: int64"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Number of Rating'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Very Good               5999\n",
       "Good                    3569\n",
       "Excellent               2089\n",
       "Yet to be summarised    1279\n",
       "Fair                    1155\n",
       "Fabulous                  89\n",
       "Name: Summary, dtype: int64"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Summary'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "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>Name</th>\n",
       "      <th>Original_price</th>\n",
       "      <th>Offer</th>\n",
       "      <th>Final_price</th>\n",
       "      <th>Distance</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Number of Rating</th>\n",
       "      <th>Summary</th>\n",
       "      <th>Location</th>\n",
       "      <th>City</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>14180</td>\n",
       "      <td>14180</td>\n",
       "      <td>14180</td>\n",
       "      <td>14180</td>\n",
       "      <td>14180</td>\n",
       "      <td>14180</td>\n",
       "      <td>14180</td>\n",
       "      <td>14180</td>\n",
       "      <td>14180</td>\n",
       "      <td>14180</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>unique</th>\n",
       "      <td>2195</td>\n",
       "      <td>1460</td>\n",
       "      <td>39</td>\n",
       "      <td>1231</td>\n",
       "      <td>199</td>\n",
       "      <td>43</td>\n",
       "      <td>1003</td>\n",
       "      <td>6</td>\n",
       "      <td>100</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>top</th>\n",
       "      <td>Capital O 2083 Hotel Blessings Deluxe</td>\n",
       "      <td>₹1777</td>\n",
       "      <td>32% off</td>\n",
       "      <td>₹1010</td>\n",
       "      <td>4.4 km</td>\n",
       "      <td>NEW</td>\n",
       "      <td>(0 Ratings)</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Mahipalpur</td>\n",
       "      <td>Delhi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>freq</th>\n",
       "      <td>30</td>\n",
       "      <td>675</td>\n",
       "      <td>11272</td>\n",
       "      <td>1082</td>\n",
       "      <td>202</td>\n",
       "      <td>1279</td>\n",
       "      <td>1279</td>\n",
       "      <td>5999</td>\n",
       "      <td>340</td>\n",
       "      <td>4280</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                         Name Original_price    Offer  \\\n",
       "count                                   14180          14180    14180   \n",
       "unique                                   2195           1460       39   \n",
       "top     Capital O 2083 Hotel Blessings Deluxe          ₹1777  32% off   \n",
       "freq                                       30            675    11272   \n",
       "\n",
       "       Final_price Distance Rating Number of Rating    Summary    Location  \\\n",
       "count        14180    14180  14180            14180      14180       14180   \n",
       "unique        1231      199     43             1003          6         100   \n",
       "top          ₹1010   4.4 km    NEW      (0 Ratings)  Very Good  Mahipalpur   \n",
       "freq          1082      202   1279             1279       5999         340   \n",
       "\n",
       "         City  \n",
       "count   14180  \n",
       "unique      5  \n",
       "top     Delhi  \n",
       "freq     4280  "
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.describe()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "- We can see that '₹' is causing a problem in the Original_price and Final_price to convert the data type from object to float\n",
    "- Also '% off' will not let us convert the Offer from object to float.  \n",
    "- 'km' in the Distance will not let us convert Distance into float\n",
    "- 'NEW' in Rating will not lets us convert the data from object to float for better analyses.\n",
    "- 'ratings' in Number of Rating will not let us convert the data from object to float.\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Removing '₹'from Original_price and Final_price\n",
    "df['Original_price']=df['Original_price'].str[1:]\n",
    "df['Final_price']=df['Final_price'].str[1:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "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>Name</th>\n",
       "      <th>Original_price</th>\n",
       "      <th>Offer</th>\n",
       "      <th>Final_price</th>\n",
       "      <th>Distance</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Number of Rating</th>\n",
       "      <th>Summary</th>\n",
       "      <th>Location</th>\n",
       "      <th>City</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>OYO 22085 Raj Banjara White House</td>\n",
       "      <td>2459</td>\n",
       "      <td>32% off</td>\n",
       "      <td>1677</td>\n",
       "      <td>1.7 km</td>\n",
       "      <td>4.4</td>\n",
       "      <td>(201 Ratings)</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Collection O 42514 Venkat Nagar</td>\n",
       "      <td>3158</td>\n",
       "      <td>32% off</td>\n",
       "      <td>2153</td>\n",
       "      <td>1.6 km</td>\n",
       "      <td>4.4</td>\n",
       "      <td>(879 Ratings)</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Capital O 44354 Jubilee Banjara Suites</td>\n",
       "      <td>1778</td>\n",
       "      <td>32% off</td>\n",
       "      <td>1213</td>\n",
       "      <td>1.1 km</td>\n",
       "      <td>4.4</td>\n",
       "      <td>(1258 Ratings)</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>OYO 35487 Hotel Meena Grand</td>\n",
       "      <td>2090</td>\n",
       "      <td>32% off</td>\n",
       "      <td>1425</td>\n",
       "      <td>4.0 km</td>\n",
       "      <td>4</td>\n",
       "      <td>(575 Ratings)</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>OYO 16018 Rainbow Saphire</td>\n",
       "      <td>2607</td>\n",
       "      <td>32% off</td>\n",
       "      <td>1777</td>\n",
       "      <td>4.6 km</td>\n",
       "      <td>4.7</td>\n",
       "      <td>(978 Ratings)</td>\n",
       "      <td>Excellent</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                     Name Original_price    Offer Final_price  \\\n",
       "0       OYO 22085 Raj Banjara White House           2459  32% off        1677   \n",
       "1         Collection O 42514 Venkat Nagar           3158  32% off        2153   \n",
       "2  Capital O 44354 Jubilee Banjara Suites           1778  32% off        1213   \n",
       "3             OYO 35487 Hotel Meena Grand           2090  32% off        1425   \n",
       "4               OYO 16018 Rainbow Saphire           2607  32% off        1777   \n",
       "\n",
       "  Distance Rating Number of Rating    Summary       Location       City  \n",
       "0   1.7 km    4.4    (201 Ratings)  Very Good  Banjara Hills  Hyderabad  \n",
       "1   1.6 km    4.4    (879 Ratings)  Very Good  Banjara Hills  Hyderabad  \n",
       "2   1.1 km    4.4   (1258 Ratings)  Very Good  Banjara Hills  Hyderabad  \n",
       "3   4.0 km      4    (575 Ratings)  Very Good  Banjara Hills  Hyderabad  \n",
       "4   4.6 km    4.7    (978 Ratings)  Excellent  Banjara Hills  Hyderabad  "
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Removing '% off' from offer\n",
    "df['Offer']=df['Offer'].str[:2]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "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>Name</th>\n",
       "      <th>Original_price</th>\n",
       "      <th>Offer</th>\n",
       "      <th>Final_price</th>\n",
       "      <th>Distance</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Number of Rating</th>\n",
       "      <th>Summary</th>\n",
       "      <th>Location</th>\n",
       "      <th>City</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>OYO 22085 Raj Banjara White House</td>\n",
       "      <td>2459</td>\n",
       "      <td>32</td>\n",
       "      <td>1677</td>\n",
       "      <td>1.7 km</td>\n",
       "      <td>4.4</td>\n",
       "      <td>(201 Ratings)</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Collection O 42514 Venkat Nagar</td>\n",
       "      <td>3158</td>\n",
       "      <td>32</td>\n",
       "      <td>2153</td>\n",
       "      <td>1.6 km</td>\n",
       "      <td>4.4</td>\n",
       "      <td>(879 Ratings)</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Capital O 44354 Jubilee Banjara Suites</td>\n",
       "      <td>1778</td>\n",
       "      <td>32</td>\n",
       "      <td>1213</td>\n",
       "      <td>1.1 km</td>\n",
       "      <td>4.4</td>\n",
       "      <td>(1258 Ratings)</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>OYO 35487 Hotel Meena Grand</td>\n",
       "      <td>2090</td>\n",
       "      <td>32</td>\n",
       "      <td>1425</td>\n",
       "      <td>4.0 km</td>\n",
       "      <td>4</td>\n",
       "      <td>(575 Ratings)</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>OYO 16018 Rainbow Saphire</td>\n",
       "      <td>2607</td>\n",
       "      <td>32</td>\n",
       "      <td>1777</td>\n",
       "      <td>4.6 km</td>\n",
       "      <td>4.7</td>\n",
       "      <td>(978 Ratings)</td>\n",
       "      <td>Excellent</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                     Name Original_price Offer Final_price  \\\n",
       "0       OYO 22085 Raj Banjara White House           2459    32        1677   \n",
       "1         Collection O 42514 Venkat Nagar           3158    32        2153   \n",
       "2  Capital O 44354 Jubilee Banjara Suites           1778    32        1213   \n",
       "3             OYO 35487 Hotel Meena Grand           2090    32        1425   \n",
       "4               OYO 16018 Rainbow Saphire           2607    32        1777   \n",
       "\n",
       "  Distance Rating Number of Rating    Summary       Location       City  \n",
       "0   1.7 km    4.4    (201 Ratings)  Very Good  Banjara Hills  Hyderabad  \n",
       "1   1.6 km    4.4    (879 Ratings)  Very Good  Banjara Hills  Hyderabad  \n",
       "2   1.1 km    4.4   (1258 Ratings)  Very Good  Banjara Hills  Hyderabad  \n",
       "3   4.0 km      4    (575 Ratings)  Very Good  Banjara Hills  Hyderabad  \n",
       "4   4.6 km    4.7    (978 Ratings)  Excellent  Banjara Hills  Hyderabad  "
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Removing 'km' from Distance\n",
    "df['Distance']=df['Distance'].str[:3]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "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>Name</th>\n",
       "      <th>Original_price</th>\n",
       "      <th>Offer</th>\n",
       "      <th>Final_price</th>\n",
       "      <th>Distance</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Number of Rating</th>\n",
       "      <th>Summary</th>\n",
       "      <th>Location</th>\n",
       "      <th>City</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>OYO 22085 Raj Banjara White House</td>\n",
       "      <td>2459</td>\n",
       "      <td>32</td>\n",
       "      <td>1677</td>\n",
       "      <td>1.7</td>\n",
       "      <td>4.4</td>\n",
       "      <td>(201 Ratings)</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Collection O 42514 Venkat Nagar</td>\n",
       "      <td>3158</td>\n",
       "      <td>32</td>\n",
       "      <td>2153</td>\n",
       "      <td>1.6</td>\n",
       "      <td>4.4</td>\n",
       "      <td>(879 Ratings)</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Capital O 44354 Jubilee Banjara Suites</td>\n",
       "      <td>1778</td>\n",
       "      <td>32</td>\n",
       "      <td>1213</td>\n",
       "      <td>1.1</td>\n",
       "      <td>4.4</td>\n",
       "      <td>(1258 Ratings)</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>OYO 35487 Hotel Meena Grand</td>\n",
       "      <td>2090</td>\n",
       "      <td>32</td>\n",
       "      <td>1425</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4</td>\n",
       "      <td>(575 Ratings)</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>OYO 16018 Rainbow Saphire</td>\n",
       "      <td>2607</td>\n",
       "      <td>32</td>\n",
       "      <td>1777</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4.7</td>\n",
       "      <td>(978 Ratings)</td>\n",
       "      <td>Excellent</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                     Name Original_price Offer Final_price  \\\n",
       "0       OYO 22085 Raj Banjara White House           2459    32        1677   \n",
       "1         Collection O 42514 Venkat Nagar           3158    32        2153   \n",
       "2  Capital O 44354 Jubilee Banjara Suites           1778    32        1213   \n",
       "3             OYO 35487 Hotel Meena Grand           2090    32        1425   \n",
       "4               OYO 16018 Rainbow Saphire           2607    32        1777   \n",
       "\n",
       "  Distance Rating Number of Rating    Summary       Location       City  \n",
       "0      1.7    4.4    (201 Ratings)  Very Good  Banjara Hills  Hyderabad  \n",
       "1      1.6    4.4    (879 Ratings)  Very Good  Banjara Hills  Hyderabad  \n",
       "2      1.1    4.4   (1258 Ratings)  Very Good  Banjara Hills  Hyderabad  \n",
       "3      4.0      4    (575 Ratings)  Very Good  Banjara Hills  Hyderabad  \n",
       "4      4.6    4.7    (978 Ratings)  Excellent  Banjara Hills  Hyderabad  "
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Replacing 'NEW' with 0 for better analyses\n",
    "df['Rating'].replace('NEW','0.0',inplace=True)"
   ]
  },
  {
   "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>Name</th>\n",
       "      <th>Original_price</th>\n",
       "      <th>Offer</th>\n",
       "      <th>Final_price</th>\n",
       "      <th>Distance</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Number of Rating</th>\n",
       "      <th>Summary</th>\n",
       "      <th>Location</th>\n",
       "      <th>City</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>OYO 22085 Raj Banjara White House</td>\n",
       "      <td>2459</td>\n",
       "      <td>32</td>\n",
       "      <td>1677</td>\n",
       "      <td>1.7</td>\n",
       "      <td>4.4</td>\n",
       "      <td>(201 Ratings)</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Collection O 42514 Venkat Nagar</td>\n",
       "      <td>3158</td>\n",
       "      <td>32</td>\n",
       "      <td>2153</td>\n",
       "      <td>1.6</td>\n",
       "      <td>4.4</td>\n",
       "      <td>(879 Ratings)</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Capital O 44354 Jubilee Banjara Suites</td>\n",
       "      <td>1778</td>\n",
       "      <td>32</td>\n",
       "      <td>1213</td>\n",
       "      <td>1.1</td>\n",
       "      <td>4.4</td>\n",
       "      <td>(1258 Ratings)</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>OYO 35487 Hotel Meena Grand</td>\n",
       "      <td>2090</td>\n",
       "      <td>32</td>\n",
       "      <td>1425</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4</td>\n",
       "      <td>(575 Ratings)</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>OYO 16018 Rainbow Saphire</td>\n",
       "      <td>2607</td>\n",
       "      <td>32</td>\n",
       "      <td>1777</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4.7</td>\n",
       "      <td>(978 Ratings)</td>\n",
       "      <td>Excellent</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Collection O 46198 New Sree Krishna</td>\n",
       "      <td>3964</td>\n",
       "      <td>32</td>\n",
       "      <td>2703</td>\n",
       "      <td>6.1</td>\n",
       "      <td>3.9</td>\n",
       "      <td>(989 Ratings)</td>\n",
       "      <td>Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>OYO 14224 Happy Guest house</td>\n",
       "      <td>2373</td>\n",
       "      <td>32</td>\n",
       "      <td>1618</td>\n",
       "      <td>1.8</td>\n",
       "      <td>4.6</td>\n",
       "      <td>(448 Ratings)</td>\n",
       "      <td>Excellent</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>OYO 62547 Dream Connect Stays</td>\n",
       "      <td>1941</td>\n",
       "      <td>32</td>\n",
       "      <td>1324</td>\n",
       "      <td>0.6</td>\n",
       "      <td>4.3</td>\n",
       "      <td>(267 Ratings)</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>OYO 11376 Golden Park</td>\n",
       "      <td>2205</td>\n",
       "      <td>45</td>\n",
       "      <td>1212</td>\n",
       "      <td>5.3</td>\n",
       "      <td>4.4</td>\n",
       "      <td>(1570 Ratings)</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>OYO 11316 Athithi Inn</td>\n",
       "      <td>2178</td>\n",
       "      <td>38</td>\n",
       "      <td>1348</td>\n",
       "      <td>4.8</td>\n",
       "      <td>3.3</td>\n",
       "      <td>(697 Ratings)</td>\n",
       "      <td>Fair</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>OYO 10272 Hotel Ruma</td>\n",
       "      <td>1777</td>\n",
       "      <td>32</td>\n",
       "      <td>1212</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.2</td>\n",
       "      <td>(488 Ratings)</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>OYO 18725 Sr Grand</td>\n",
       "      <td>1910</td>\n",
       "      <td>32</td>\n",
       "      <td>1303</td>\n",
       "      <td>3.3</td>\n",
       "      <td>4.4</td>\n",
       "      <td>(294 Ratings)</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>OYO 18302 Pride Banjara</td>\n",
       "      <td>2260</td>\n",
       "      <td>32</td>\n",
       "      <td>1541</td>\n",
       "      <td>1.1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>(0 Ratings)</td>\n",
       "      <td>Yet to be summarised</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>OYO 983 Hotel Surya Residency</td>\n",
       "      <td>2811</td>\n",
       "      <td>32</td>\n",
       "      <td>1917</td>\n",
       "      <td>3.2</td>\n",
       "      <td>4.2</td>\n",
       "      <td>(264 Ratings)</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Capital O 46832 Gaayatri Residency Deluxe</td>\n",
       "      <td>2098</td>\n",
       "      <td>32</td>\n",
       "      <td>1431</td>\n",
       "      <td>4.1</td>\n",
       "      <td>4.8</td>\n",
       "      <td>(644 Ratings)</td>\n",
       "      <td>Excellent</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                         Name Original_price Offer  \\\n",
       "0           OYO 22085 Raj Banjara White House           2459    32   \n",
       "1             Collection O 42514 Venkat Nagar           3158    32   \n",
       "2      Capital O 44354 Jubilee Banjara Suites           1778    32   \n",
       "3                 OYO 35487 Hotel Meena Grand           2090    32   \n",
       "4                   OYO 16018 Rainbow Saphire           2607    32   \n",
       "5         Collection O 46198 New Sree Krishna           3964    32   \n",
       "6                 OYO 14224 Happy Guest house           2373    32   \n",
       "7               OYO 62547 Dream Connect Stays           1941    32   \n",
       "8                       OYO 11376 Golden Park           2205    45   \n",
       "9                       OYO 11316 Athithi Inn           2178    38   \n",
       "10                       OYO 10272 Hotel Ruma           1777    32   \n",
       "11                         OYO 18725 Sr Grand           1910    32   \n",
       "12                    OYO 18302 Pride Banjara           2260    32   \n",
       "13              OYO 983 Hotel Surya Residency           2811    32   \n",
       "14  Capital O 46832 Gaayatri Residency Deluxe           2098    32   \n",
       "\n",
       "   Final_price Distance Rating Number of Rating               Summary  \\\n",
       "0         1677      1.7    4.4    (201 Ratings)             Very Good   \n",
       "1         2153      1.6    4.4    (879 Ratings)             Very Good   \n",
       "2         1213      1.1    4.4   (1258 Ratings)             Very Good   \n",
       "3         1425      4.0      4    (575 Ratings)             Very Good   \n",
       "4         1777      4.6    4.7    (978 Ratings)             Excellent   \n",
       "5         2703      6.1    3.9    (989 Ratings)                  Good   \n",
       "6         1618      1.8    4.6    (448 Ratings)             Excellent   \n",
       "7         1324      0.6    4.3    (267 Ratings)             Very Good   \n",
       "8         1212      5.3    4.4   (1570 Ratings)             Very Good   \n",
       "9         1348      4.8    3.3    (697 Ratings)                  Fair   \n",
       "10        1212      4.2    4.2    (488 Ratings)             Very Good   \n",
       "11        1303      3.3    4.4    (294 Ratings)             Very Good   \n",
       "12        1541      1.1    0.0      (0 Ratings)  Yet to be summarised   \n",
       "13        1917      3.2    4.2    (264 Ratings)             Very Good   \n",
       "14        1431      4.1    4.8    (644 Ratings)             Excellent   \n",
       "\n",
       "         Location       City  \n",
       "0   Banjara Hills  Hyderabad  \n",
       "1   Banjara Hills  Hyderabad  \n",
       "2   Banjara Hills  Hyderabad  \n",
       "3   Banjara Hills  Hyderabad  \n",
       "4   Banjara Hills  Hyderabad  \n",
       "5   Banjara Hills  Hyderabad  \n",
       "6   Banjara Hills  Hyderabad  \n",
       "7   Banjara Hills  Hyderabad  \n",
       "8   Banjara Hills  Hyderabad  \n",
       "9   Banjara Hills  Hyderabad  \n",
       "10  Banjara Hills  Hyderabad  \n",
       "11  Banjara Hills  Hyderabad  \n",
       "12  Banjara Hills  Hyderabad  \n",
       "13  Banjara Hills  Hyderabad  \n",
       "14  Banjara Hills  Hyderabad  "
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(15)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Removing () and ratings from Number of Rating\n",
    "df['Number of Rating']=df['Number of Rating'].str[1:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "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>Name</th>\n",
       "      <th>Original_price</th>\n",
       "      <th>Offer</th>\n",
       "      <th>Final_price</th>\n",
       "      <th>Distance</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Number of Rating</th>\n",
       "      <th>Summary</th>\n",
       "      <th>Location</th>\n",
       "      <th>City</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>OYO 22085 Raj Banjara White House</td>\n",
       "      <td>2459</td>\n",
       "      <td>32</td>\n",
       "      <td>1677</td>\n",
       "      <td>1.7</td>\n",
       "      <td>4.4</td>\n",
       "      <td>201 Ratings)</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Collection O 42514 Venkat Nagar</td>\n",
       "      <td>3158</td>\n",
       "      <td>32</td>\n",
       "      <td>2153</td>\n",
       "      <td>1.6</td>\n",
       "      <td>4.4</td>\n",
       "      <td>879 Ratings)</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Capital O 44354 Jubilee Banjara Suites</td>\n",
       "      <td>1778</td>\n",
       "      <td>32</td>\n",
       "      <td>1213</td>\n",
       "      <td>1.1</td>\n",
       "      <td>4.4</td>\n",
       "      <td>1258 Ratings)</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>OYO 35487 Hotel Meena Grand</td>\n",
       "      <td>2090</td>\n",
       "      <td>32</td>\n",
       "      <td>1425</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4</td>\n",
       "      <td>575 Ratings)</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>OYO 16018 Rainbow Saphire</td>\n",
       "      <td>2607</td>\n",
       "      <td>32</td>\n",
       "      <td>1777</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4.7</td>\n",
       "      <td>978 Ratings)</td>\n",
       "      <td>Excellent</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                     Name Original_price Offer Final_price  \\\n",
       "0       OYO 22085 Raj Banjara White House           2459    32        1677   \n",
       "1         Collection O 42514 Venkat Nagar           3158    32        2153   \n",
       "2  Capital O 44354 Jubilee Banjara Suites           1778    32        1213   \n",
       "3             OYO 35487 Hotel Meena Grand           2090    32        1425   \n",
       "4               OYO 16018 Rainbow Saphire           2607    32        1777   \n",
       "\n",
       "  Distance Rating Number of Rating    Summary       Location       City  \n",
       "0      1.7    4.4     201 Ratings)  Very Good  Banjara Hills  Hyderabad  \n",
       "1      1.6    4.4     879 Ratings)  Very Good  Banjara Hills  Hyderabad  \n",
       "2      1.1    4.4    1258 Ratings)  Very Good  Banjara Hills  Hyderabad  \n",
       "3      4.0      4     575 Ratings)  Very Good  Banjara Hills  Hyderabad  \n",
       "4      4.6    4.7     978 Ratings)  Excellent  Banjara Hills  Hyderabad  "
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['Number of Rating']=df['Number of Rating'].str[:-8]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "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>Name</th>\n",
       "      <th>Original_price</th>\n",
       "      <th>Offer</th>\n",
       "      <th>Final_price</th>\n",
       "      <th>Distance</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Number of Rating</th>\n",
       "      <th>Summary</th>\n",
       "      <th>Location</th>\n",
       "      <th>City</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>OYO 22085 Raj Banjara White House</td>\n",
       "      <td>2459</td>\n",
       "      <td>32</td>\n",
       "      <td>1677</td>\n",
       "      <td>1.7</td>\n",
       "      <td>4.4</td>\n",
       "      <td>201</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Collection O 42514 Venkat Nagar</td>\n",
       "      <td>3158</td>\n",
       "      <td>32</td>\n",
       "      <td>2153</td>\n",
       "      <td>1.6</td>\n",
       "      <td>4.4</td>\n",
       "      <td>879</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Capital O 44354 Jubilee Banjara Suites</td>\n",
       "      <td>1778</td>\n",
       "      <td>32</td>\n",
       "      <td>1213</td>\n",
       "      <td>1.1</td>\n",
       "      <td>4.4</td>\n",
       "      <td>1258</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>OYO 35487 Hotel Meena Grand</td>\n",
       "      <td>2090</td>\n",
       "      <td>32</td>\n",
       "      <td>1425</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4</td>\n",
       "      <td>575</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>OYO 16018 Rainbow Saphire</td>\n",
       "      <td>2607</td>\n",
       "      <td>32</td>\n",
       "      <td>1777</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4.7</td>\n",
       "      <td>978</td>\n",
       "      <td>Excellent</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                     Name Original_price Offer Final_price  \\\n",
       "0       OYO 22085 Raj Banjara White House           2459    32        1677   \n",
       "1         Collection O 42514 Venkat Nagar           3158    32        2153   \n",
       "2  Capital O 44354 Jubilee Banjara Suites           1778    32        1213   \n",
       "3             OYO 35487 Hotel Meena Grand           2090    32        1425   \n",
       "4               OYO 16018 Rainbow Saphire           2607    32        1777   \n",
       "\n",
       "  Distance Rating Number of Rating    Summary       Location       City  \n",
       "0      1.7    4.4             201   Very Good  Banjara Hills  Hyderabad  \n",
       "1      1.6    4.4             879   Very Good  Banjara Hills  Hyderabad  \n",
       "2      1.1    4.4            1258   Very Good  Banjara Hills  Hyderabad  \n",
       "3      4.0      4             575   Very Good  Banjara Hills  Hyderabad  \n",
       "4      4.6    4.7             978   Excellent  Banjara Hills  Hyderabad  "
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.rename(columns={'Number of Rating':'Number_of_Rating'},inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Name                object\n",
       "Original_price      object\n",
       "Offer               object\n",
       "Final_price         object\n",
       "Distance            object\n",
       "Rating              object\n",
       "Number_of_Rating    object\n",
       "Summary             object\n",
       "Location            object\n",
       "City                object\n",
       "dtype: object"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['Original_price']=df['Original_price'].astype(float)\n",
    "df['Offer']=df['Offer'].astype(float)\n",
    "df['Final_price']=df['Final_price'].astype(float)\n",
    "df['Distance']=df['Distance'].astype(float)\n",
    "df['Rating']=df['Rating'].astype(float)\n",
    "df['Number_of_Rating']=df['Number_of_Rating'].astype(float)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Name                 object\n",
       "Original_price      float64\n",
       "Offer               float64\n",
       "Final_price         float64\n",
       "Distance            float64\n",
       "Rating              float64\n",
       "Number_of_Rating    float64\n",
       "Summary              object\n",
       "Location             object\n",
       "City                 object\n",
       "dtype: object"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.drop_duplicates(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(11982, 10)"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "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>Original_price</th>\n",
       "      <th>Offer</th>\n",
       "      <th>Final_price</th>\n",
       "      <th>Distance</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Number_of_Rating</th>\n",
       "      <th>Summary</th>\n",
       "      <th>Location</th>\n",
       "      <th>City</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Name</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>OYO 22085 Raj Banjara White House</th>\n",
       "      <td>2459.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>1677.0</td>\n",
       "      <td>1.7</td>\n",
       "      <td>4.4</td>\n",
       "      <td>201.0</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Collection O 42514 Venkat Nagar</th>\n",
       "      <td>3158.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>2153.0</td>\n",
       "      <td>1.6</td>\n",
       "      <td>4.4</td>\n",
       "      <td>879.0</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Capital O 44354 Jubilee Banjara Suites</th>\n",
       "      <td>1778.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>1213.0</td>\n",
       "      <td>1.1</td>\n",
       "      <td>4.4</td>\n",
       "      <td>1258.0</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 35487 Hotel Meena Grand</th>\n",
       "      <td>2090.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>1425.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>575.0</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 16018 Rainbow Saphire</th>\n",
       "      <td>2607.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>1777.0</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4.7</td>\n",
       "      <td>978.0</td>\n",
       "      <td>Excellent</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Collection O 46198 New Sree Krishna</th>\n",
       "      <td>3964.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>2703.0</td>\n",
       "      <td>6.1</td>\n",
       "      <td>3.9</td>\n",
       "      <td>989.0</td>\n",
       "      <td>Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 14224 Happy Guest house</th>\n",
       "      <td>2373.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>1618.0</td>\n",
       "      <td>1.8</td>\n",
       "      <td>4.6</td>\n",
       "      <td>448.0</td>\n",
       "      <td>Excellent</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 62547 Dream Connect Stays</th>\n",
       "      <td>1941.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>1324.0</td>\n",
       "      <td>0.6</td>\n",
       "      <td>4.3</td>\n",
       "      <td>267.0</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 11376 Golden Park</th>\n",
       "      <td>2205.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>1212.0</td>\n",
       "      <td>5.3</td>\n",
       "      <td>4.4</td>\n",
       "      <td>1570.0</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 11316 Athithi Inn</th>\n",
       "      <td>2178.0</td>\n",
       "      <td>38.0</td>\n",
       "      <td>1348.0</td>\n",
       "      <td>4.8</td>\n",
       "      <td>3.3</td>\n",
       "      <td>697.0</td>\n",
       "      <td>Fair</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 10272 Hotel Ruma</th>\n",
       "      <td>1777.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>1212.0</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.2</td>\n",
       "      <td>488.0</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 18725 Sr Grand</th>\n",
       "      <td>1910.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>1303.0</td>\n",
       "      <td>3.3</td>\n",
       "      <td>4.4</td>\n",
       "      <td>294.0</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 18302 Pride Banjara</th>\n",
       "      <td>2260.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>1541.0</td>\n",
       "      <td>1.1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Yet to be summarised</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 983 Hotel Surya Residency</th>\n",
       "      <td>2811.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>1917.0</td>\n",
       "      <td>3.2</td>\n",
       "      <td>4.2</td>\n",
       "      <td>264.0</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Capital O 46832 Gaayatri Residency Deluxe</th>\n",
       "      <td>2098.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>1431.0</td>\n",
       "      <td>4.1</td>\n",
       "      <td>4.8</td>\n",
       "      <td>644.0</td>\n",
       "      <td>Excellent</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 4025 Hotel Meredian Orchid</th>\n",
       "      <td>1865.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>1212.0</td>\n",
       "      <td>2.7</td>\n",
       "      <td>4.1</td>\n",
       "      <td>558.0</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO Townhouse 045 Lakdi ka Pul</th>\n",
       "      <td>5129.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>3497.0</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.3</td>\n",
       "      <td>1934.0</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 41751 Hotel Sabharwal</th>\n",
       "      <td>1416.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>966.0</td>\n",
       "      <td>7.2</td>\n",
       "      <td>4.2</td>\n",
       "      <td>786.0</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 47332 Hotel Dolphin</th>\n",
       "      <td>2509.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>1711.0</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.4</td>\n",
       "      <td>279.0</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 30744 The  Gate</th>\n",
       "      <td>2140.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>1459.0</td>\n",
       "      <td>3.4</td>\n",
       "      <td>4.3</td>\n",
       "      <td>440.0</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 37906 New Asian Lodge</th>\n",
       "      <td>2420.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>1650.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3.2</td>\n",
       "      <td>349.0</td>\n",
       "      <td>Fair</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 26562 Dazzle Stays</th>\n",
       "      <td>1730.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>1010.0</td>\n",
       "      <td>6.7</td>\n",
       "      <td>3.9</td>\n",
       "      <td>371.0</td>\n",
       "      <td>Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SilverKey Executive Stays 27773 IAS Colony</th>\n",
       "      <td>1639.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>991.0</td>\n",
       "      <td>2.9</td>\n",
       "      <td>3.8</td>\n",
       "      <td>2195.0</td>\n",
       "      <td>Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 1410 Country Club Begumpet</th>\n",
       "      <td>4417.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>3012.0</td>\n",
       "      <td>5.9</td>\n",
       "      <td>3.6</td>\n",
       "      <td>366.0</td>\n",
       "      <td>Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 22907 Hotel Holiday Deluxe</th>\n",
       "      <td>2407.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>1642.0</td>\n",
       "      <td>5.9</td>\n",
       "      <td>4.5</td>\n",
       "      <td>393.0</td>\n",
       "      <td>Excellent</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 47727 S Grand</th>\n",
       "      <td>1427.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>973.0</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4.4</td>\n",
       "      <td>360.0</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Capital O 6422 Luxor Park</th>\n",
       "      <td>2737.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>1867.0</td>\n",
       "      <td>7.1</td>\n",
       "      <td>4.5</td>\n",
       "      <td>1914.0</td>\n",
       "      <td>Excellent</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 9302 Hotel Baseraa Inn</th>\n",
       "      <td>2081.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>1419.0</td>\n",
       "      <td>6.8</td>\n",
       "      <td>4.5</td>\n",
       "      <td>170.0</td>\n",
       "      <td>Excellent</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 8941 Hotel Golden Leaves</th>\n",
       "      <td>2449.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>1670.0</td>\n",
       "      <td>6.7</td>\n",
       "      <td>4.4</td>\n",
       "      <td>728.0</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO Flagship 14348 Apollo Hospital</th>\n",
       "      <td>2746.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>1525.0</td>\n",
       "      <td>3.6</td>\n",
       "      <td>4.3</td>\n",
       "      <td>1422.0</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Banjara Hills</td>\n",
       "      <td>Hyderabad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 46744 Hotel Yash</th>\n",
       "      <td>1481.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>1010.0</td>\n",
       "      <td>8.5</td>\n",
       "      <td>4.3</td>\n",
       "      <td>161.0</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Nehru Place</td>\n",
       "      <td>Delhi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 62553 Suvee Palace</th>\n",
       "      <td>1294.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>883.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Yet to be summarised</td>\n",
       "      <td>Nehru Place</td>\n",
       "      <td>Delhi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 61639 Red Carmine</th>\n",
       "      <td>1777.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>1212.0</td>\n",
       "      <td>8.9</td>\n",
       "      <td>4.6</td>\n",
       "      <td>104.0</td>\n",
       "      <td>Excellent</td>\n",
       "      <td>Nehru Place</td>\n",
       "      <td>Delhi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 44324 Comfort Stay Near Saket Metro</th>\n",
       "      <td>2989.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>2038.0</td>\n",
       "      <td>8.7</td>\n",
       "      <td>4.6</td>\n",
       "      <td>878.0</td>\n",
       "      <td>Excellent</td>\n",
       "      <td>Nehru Place</td>\n",
       "      <td>Delhi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO Home Luxe 30142 Fabulous Farmstay</th>\n",
       "      <td>2548.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>1299.0</td>\n",
       "      <td>9.2</td>\n",
       "      <td>4.6</td>\n",
       "      <td>535.0</td>\n",
       "      <td>Excellent</td>\n",
       "      <td>Nehru Place</td>\n",
       "      <td>Delhi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 22321 Nitin Palace Guest House</th>\n",
       "      <td>2822.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>1924.0</td>\n",
       "      <td>6.8</td>\n",
       "      <td>4.7</td>\n",
       "      <td>279.0</td>\n",
       "      <td>Excellent</td>\n",
       "      <td>Nehru Place</td>\n",
       "      <td>Delhi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO Townhouse 002 Green Park</th>\n",
       "      <td>7806.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>5323.0</td>\n",
       "      <td>7.3</td>\n",
       "      <td>4.8</td>\n",
       "      <td>1390.0</td>\n",
       "      <td>Excellent</td>\n",
       "      <td>Nehru Place</td>\n",
       "      <td>Delhi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Capital O 7075 The Oakland Plaza Hotel Deluxe</th>\n",
       "      <td>3078.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>2099.0</td>\n",
       "      <td>1.6</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1025.0</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Nehru Place</td>\n",
       "      <td>Delhi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 14789 Kempinski Wide</th>\n",
       "      <td>3534.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>2349.0</td>\n",
       "      <td>3.2</td>\n",
       "      <td>4.3</td>\n",
       "      <td>195.0</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Nehru Place</td>\n",
       "      <td>Delhi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 63837 Ambica Inn</th>\n",
       "      <td>2729.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>1861.0</td>\n",
       "      <td>5.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Yet to be summarised</td>\n",
       "      <td>Nehru Place</td>\n",
       "      <td>Delhi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 37512 Spacious Stay Saket Metro</th>\n",
       "      <td>1981.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>1351.0</td>\n",
       "      <td>6.8</td>\n",
       "      <td>4.0</td>\n",
       "      <td>413.0</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Nehru Place</td>\n",
       "      <td>Delhi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 60334 Skp Bed &amp; Breakfast</th>\n",
       "      <td>2225.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>1517.0</td>\n",
       "      <td>8.2</td>\n",
       "      <td>3.4</td>\n",
       "      <td>114.0</td>\n",
       "      <td>Fair</td>\n",
       "      <td>Nehru Place</td>\n",
       "      <td>Delhi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 64271 Singh Hotel 2</th>\n",
       "      <td>1140.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>778.0</td>\n",
       "      <td>6.1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Yet to be summarised</td>\n",
       "      <td>Nehru Place</td>\n",
       "      <td>Delhi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 37055 M R Residency Saver</th>\n",
       "      <td>1481.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>1010.0</td>\n",
       "      <td>8.7</td>\n",
       "      <td>4.4</td>\n",
       "      <td>541.0</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Nehru Place</td>\n",
       "      <td>Delhi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Capital O 712 Defence Colony Deluxe</th>\n",
       "      <td>3738.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>2549.0</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.2</td>\n",
       "      <td>723.0</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Nehru Place</td>\n",
       "      <td>Delhi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO Home 47965 Cozy Stay Ignou Road Saket</th>\n",
       "      <td>2720.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>1855.0</td>\n",
       "      <td>6.3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Yet to be summarised</td>\n",
       "      <td>Nehru Place</td>\n",
       "      <td>Delhi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO Home 47964 Comfortable  Stay Ignou Road Saket</th>\n",
       "      <td>2720.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>1855.0</td>\n",
       "      <td>6.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Yet to be summarised</td>\n",
       "      <td>Nehru Place</td>\n",
       "      <td>Delhi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 44400 Retreat Inn</th>\n",
       "      <td>1878.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>1281.0</td>\n",
       "      <td>8.6</td>\n",
       "      <td>3.7</td>\n",
       "      <td>315.0</td>\n",
       "      <td>Good</td>\n",
       "      <td>Nehru Place</td>\n",
       "      <td>Delhi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO Flagship 36485 Smg Heritage Nehru Enclave</th>\n",
       "      <td>1777.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>1212.0</td>\n",
       "      <td>8.8</td>\n",
       "      <td>3.8</td>\n",
       "      <td>3842.0</td>\n",
       "      <td>Good</td>\n",
       "      <td>Nehru Place</td>\n",
       "      <td>Delhi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Capital O 39462 Westyard Hotel</th>\n",
       "      <td>2863.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>1952.0</td>\n",
       "      <td>5.6</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2104.0</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Nehru Place</td>\n",
       "      <td>Delhi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 40657 Aastha</th>\n",
       "      <td>1372.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>936.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>332.0</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Nehru Place</td>\n",
       "      <td>Delhi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 14765 Amar Villa</th>\n",
       "      <td>4239.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>6.7</td>\n",
       "      <td>3.8</td>\n",
       "      <td>126.0</td>\n",
       "      <td>Good</td>\n",
       "      <td>Nehru Place</td>\n",
       "      <td>Delhi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 7304 Stay Jangpura</th>\n",
       "      <td>2843.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>1939.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Yet to be summarised</td>\n",
       "      <td>Nehru Place</td>\n",
       "      <td>Delhi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 9536 Bee For Home Stay</th>\n",
       "      <td>5011.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>1899.0</td>\n",
       "      <td>7.3</td>\n",
       "      <td>4.2</td>\n",
       "      <td>47.0</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Nehru Place</td>\n",
       "      <td>Delhi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 543 La Ola Boutique Hotel</th>\n",
       "      <td>2766.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>1886.0</td>\n",
       "      <td>1.5</td>\n",
       "      <td>4.2</td>\n",
       "      <td>143.0</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Nehru Place</td>\n",
       "      <td>Delhi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 472 Hotel Sareen</th>\n",
       "      <td>2389.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>1552.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.7</td>\n",
       "      <td>90.0</td>\n",
       "      <td>Good</td>\n",
       "      <td>Nehru Place</td>\n",
       "      <td>Delhi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 43002 The Royal Town Deluxe</th>\n",
       "      <td>4522.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>3083.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.6</td>\n",
       "      <td>114.0</td>\n",
       "      <td>Good</td>\n",
       "      <td>Nehru Place</td>\n",
       "      <td>Delhi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 48664 Gour White House</th>\n",
       "      <td>2526.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>1723.0</td>\n",
       "      <td>2.8</td>\n",
       "      <td>4.3</td>\n",
       "      <td>245.0</td>\n",
       "      <td>Very Good</td>\n",
       "      <td>Nehru Place</td>\n",
       "      <td>Delhi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 12532 Imperial Inn Deluxe</th>\n",
       "      <td>7544.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>5144.0</td>\n",
       "      <td>1.3</td>\n",
       "      <td>4.8</td>\n",
       "      <td>271.0</td>\n",
       "      <td>Excellent</td>\n",
       "      <td>Nehru Place</td>\n",
       "      <td>Delhi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OYO 13235 The Golden Door</th>\n",
       "      <td>6855.0</td>\n",
       "      <td>32.0</td>\n",
       "      <td>4674.0</td>\n",
       "      <td>2.8</td>\n",
       "      <td>4.5</td>\n",
       "      <td>173.0</td>\n",
       "      <td>Excellent</td>\n",
       "      <td>Nehru Place</td>\n",
       "      <td>Delhi</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>11982 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   Original_price  Offer  \\\n",
       "Name                                                                       \n",
       "OYO 22085 Raj Banjara White House                          2459.0   32.0   \n",
       "Collection O 42514 Venkat Nagar                            3158.0   32.0   \n",
       "Capital O 44354 Jubilee Banjara Suites                     1778.0   32.0   \n",
       "OYO 35487 Hotel Meena Grand                                2090.0   32.0   \n",
       "OYO 16018 Rainbow Saphire                                  2607.0   32.0   \n",
       "Collection O 46198 New Sree Krishna                        3964.0   32.0   \n",
       "OYO 14224 Happy Guest house                                2373.0   32.0   \n",
       "OYO 62547 Dream Connect Stays                              1941.0   32.0   \n",
       "OYO 11376 Golden Park                                      2205.0   45.0   \n",
       "OYO 11316 Athithi Inn                                      2178.0   38.0   \n",
       "OYO 10272 Hotel Ruma                                       1777.0   32.0   \n",
       "OYO 18725 Sr Grand                                         1910.0   32.0   \n",
       "OYO 18302 Pride Banjara                                    2260.0   32.0   \n",
       "OYO 983 Hotel Surya Residency                              2811.0   32.0   \n",
       "Capital O 46832 Gaayatri Residency Deluxe                  2098.0   32.0   \n",
       "OYO 4025 Hotel Meredian Orchid                             1865.0   35.0   \n",
       "OYO Townhouse 045 Lakdi ka Pul                             5129.0   32.0   \n",
       "OYO 41751 Hotel Sabharwal                                  1416.0   32.0   \n",
       "OYO 47332 Hotel Dolphin                                    2509.0   32.0   \n",
       "OYO 30744 The  Gate                                        2140.0   32.0   \n",
       "OYO 37906 New Asian Lodge                                  2420.0   32.0   \n",
       "OYO 26562 Dazzle Stays                                     1730.0   42.0   \n",
       "SilverKey Executive Stays 27773 IAS Colony                 1639.0   40.0   \n",
       "OYO 1410 Country Club Begumpet                             4417.0   32.0   \n",
       "OYO 22907 Hotel Holiday Deluxe                             2407.0   32.0   \n",
       "OYO 47727 S Grand                                          1427.0   32.0   \n",
       "Capital O 6422 Luxor Park                                  2737.0   32.0   \n",
       "OYO 9302 Hotel Baseraa Inn                                 2081.0   32.0   \n",
       "OYO 8941 Hotel Golden Leaves                               2449.0   32.0   \n",
       "OYO Flagship 14348 Apollo Hospital                         2746.0   44.0   \n",
       "...                                                           ...    ...   \n",
       "OYO 46744 Hotel Yash                                       1481.0   32.0   \n",
       "OYO 62553 Suvee Palace                                     1294.0   32.0   \n",
       "OYO 61639 Red Carmine                                      1777.0   32.0   \n",
       "OYO 44324 Comfort Stay Near Saket Metro                    2989.0   32.0   \n",
       "OYO Home Luxe 30142 Fabulous Farmstay                      2548.0   49.0   \n",
       "OYO 22321 Nitin Palace Guest House                         2822.0   32.0   \n",
       "OYO Townhouse 002 Green Park                               7806.0   32.0   \n",
       "Capital O 7075 The Oakland Plaza Hotel Deluxe              3078.0   32.0   \n",
       "OYO 14789 Kempinski Wide                                   3534.0   34.0   \n",
       "OYO 63837 Ambica Inn                                       2729.0   32.0   \n",
       "OYO 37512 Spacious Stay Saket Metro                        1981.0   32.0   \n",
       "OYO 60334 Skp Bed & Breakfast                              2225.0   32.0   \n",
       "OYO 64271 Singh Hotel 2                                    1140.0   32.0   \n",
       "OYO 37055 M R Residency Saver                              1481.0   32.0   \n",
       "Capital O 712 Defence Colony Deluxe                        3738.0   32.0   \n",
       "OYO Home 47965 Cozy Stay Ignou Road Saket                  2720.0   32.0   \n",
       "OYO Home 47964 Comfortable  Stay Ignou Road Saket          2720.0   32.0   \n",
       "OYO 44400 Retreat Inn                                      1878.0   32.0   \n",
       "OYO Flagship 36485 Smg Heritage Nehru Enclave              1777.0   32.0   \n",
       "Capital O 39462 Westyard Hotel                             2863.0   32.0   \n",
       "OYO 40657 Aastha                                           1372.0   32.0   \n",
       "OYO 14765 Amar Villa                                       4239.0   53.0   \n",
       "OYO 7304 Stay Jangpura                                     2843.0   32.0   \n",
       "OYO 9536 Bee For Home Stay                                 5011.0   62.0   \n",
       "OYO 543 La Ola Boutique Hotel                              2766.0   32.0   \n",
       "OYO 472 Hotel Sareen                                       2389.0   35.0   \n",
       "OYO 43002 The Royal Town Deluxe                            4522.0   32.0   \n",
       "OYO 48664 Gour White House                                 2526.0   32.0   \n",
       "OYO 12532 Imperial Inn Deluxe                              7544.0   32.0   \n",
       "OYO 13235 The Golden Door                                  6855.0   32.0   \n",
       "\n",
       "                                                   Final_price  Distance  \\\n",
       "Name                                                                       \n",
       "OYO 22085 Raj Banjara White House                       1677.0       1.7   \n",
       "Collection O 42514 Venkat Nagar                         2153.0       1.6   \n",
       "Capital O 44354 Jubilee Banjara Suites                  1213.0       1.1   \n",
       "OYO 35487 Hotel Meena Grand                             1425.0       4.0   \n",
       "OYO 16018 Rainbow Saphire                               1777.0       4.6   \n",
       "Collection O 46198 New Sree Krishna                     2703.0       6.1   \n",
       "OYO 14224 Happy Guest house                             1618.0       1.8   \n",
       "OYO 62547 Dream Connect Stays                           1324.0       0.6   \n",
       "OYO 11376 Golden Park                                   1212.0       5.3   \n",
       "OYO 11316 Athithi Inn                                   1348.0       4.8   \n",
       "OYO 10272 Hotel Ruma                                    1212.0       4.2   \n",
       "OYO 18725 Sr Grand                                      1303.0       3.3   \n",
       "OYO 18302 Pride Banjara                                 1541.0       1.1   \n",
       "OYO 983 Hotel Surya Residency                           1917.0       3.2   \n",
       "Capital O 46832 Gaayatri Residency Deluxe               1431.0       4.1   \n",
       "OYO 4025 Hotel Meredian Orchid                          1212.0       2.7   \n",
       "OYO Townhouse 045 Lakdi ka Pul                          3497.0       4.4   \n",
       "OYO 41751 Hotel Sabharwal                                966.0       7.2   \n",
       "OYO 47332 Hotel Dolphin                                 1711.0       4.2   \n",
       "OYO 30744 The  Gate                                     1459.0       3.4   \n",
       "OYO 37906 New Asian Lodge                               1650.0       4.0   \n",
       "OYO 26562 Dazzle Stays                                  1010.0       6.7   \n",
       "SilverKey Executive Stays 27773 IAS Colony               991.0       2.9   \n",
       "OYO 1410 Country Club Begumpet                          3012.0       5.9   \n",
       "OYO 22907 Hotel Holiday Deluxe                          1642.0       5.9   \n",
       "OYO 47727 S Grand                                        973.0       4.6   \n",
       "Capital O 6422 Luxor Park                               1867.0       7.1   \n",
       "OYO 9302 Hotel Baseraa Inn                              1419.0       6.8   \n",
       "OYO 8941 Hotel Golden Leaves                            1670.0       6.7   \n",
       "OYO Flagship 14348 Apollo Hospital                      1525.0       3.6   \n",
       "...                                                        ...       ...   \n",
       "OYO 46744 Hotel Yash                                    1010.0       8.5   \n",
       "OYO 62553 Suvee Palace                                   883.0       8.0   \n",
       "OYO 61639 Red Carmine                                   1212.0       8.9   \n",
       "OYO 44324 Comfort Stay Near Saket Metro                 2038.0       8.7   \n",
       "OYO Home Luxe 30142 Fabulous Farmstay                   1299.0       9.2   \n",
       "OYO 22321 Nitin Palace Guest House                      1924.0       6.8   \n",
       "OYO Townhouse 002 Green Park                            5323.0       7.3   \n",
       "Capital O 7075 The Oakland Plaza Hotel Deluxe           2099.0       1.6   \n",
       "OYO 14789 Kempinski Wide                                2349.0       3.2   \n",
       "OYO 63837 Ambica Inn                                    1861.0       5.4   \n",
       "OYO 37512 Spacious Stay Saket Metro                     1351.0       6.8   \n",
       "OYO 60334 Skp Bed & Breakfast                           1517.0       8.2   \n",
       "OYO 64271 Singh Hotel 2                                  778.0       6.1   \n",
       "OYO 37055 M R Residency Saver                           1010.0       8.7   \n",
       "Capital O 712 Defence Colony Deluxe                     2549.0       4.2   \n",
       "OYO Home 47965 Cozy Stay Ignou Road Saket               1855.0       6.3   \n",
       "OYO Home 47964 Comfortable  Stay Ignou Road Saket       1855.0       6.4   \n",
       "OYO 44400 Retreat Inn                                   1281.0       8.6   \n",
       "OYO Flagship 36485 Smg Heritage Nehru Enclave           1212.0       8.8   \n",
       "Capital O 39462 Westyard Hotel                          1952.0       5.6   \n",
       "OYO 40657 Aastha                                         936.0      10.0   \n",
       "OYO 14765 Amar Villa                                    2010.0       6.7   \n",
       "OYO 7304 Stay Jangpura                                  1939.0       7.0   \n",
       "OYO 9536 Bee For Home Stay                              1899.0       7.3   \n",
       "OYO 543 La Ola Boutique Hotel                           1886.0       1.5   \n",
       "OYO 472 Hotel Sareen                                    1552.0       2.0   \n",
       "OYO 43002 The Royal Town Deluxe                         3083.0       1.0   \n",
       "OYO 48664 Gour White House                              1723.0       2.8   \n",
       "OYO 12532 Imperial Inn Deluxe                           5144.0       1.3   \n",
       "OYO 13235 The Golden Door                               4674.0       2.8   \n",
       "\n",
       "                                                   Rating  Number_of_Rating  \\\n",
       "Name                                                                          \n",
       "OYO 22085 Raj Banjara White House                     4.4             201.0   \n",
       "Collection O 42514 Venkat Nagar                       4.4             879.0   \n",
       "Capital O 44354 Jubilee Banjara Suites                4.4            1258.0   \n",
       "OYO 35487 Hotel Meena Grand                           4.0             575.0   \n",
       "OYO 16018 Rainbow Saphire                             4.7             978.0   \n",
       "Collection O 46198 New Sree Krishna                   3.9             989.0   \n",
       "OYO 14224 Happy Guest house                           4.6             448.0   \n",
       "OYO 62547 Dream Connect Stays                         4.3             267.0   \n",
       "OYO 11376 Golden Park                                 4.4            1570.0   \n",
       "OYO 11316 Athithi Inn                                 3.3             697.0   \n",
       "OYO 10272 Hotel Ruma                                  4.2             488.0   \n",
       "OYO 18725 Sr Grand                                    4.4             294.0   \n",
       "OYO 18302 Pride Banjara                               0.0               0.0   \n",
       "OYO 983 Hotel Surya Residency                         4.2             264.0   \n",
       "Capital O 46832 Gaayatri Residency Deluxe             4.8             644.0   \n",
       "OYO 4025 Hotel Meredian Orchid                        4.1             558.0   \n",
       "OYO Townhouse 045 Lakdi ka Pul                        4.3            1934.0   \n",
       "OYO 41751 Hotel Sabharwal                             4.2             786.0   \n",
       "OYO 47332 Hotel Dolphin                               4.4             279.0   \n",
       "OYO 30744 The  Gate                                   4.3             440.0   \n",
       "OYO 37906 New Asian Lodge                             3.2             349.0   \n",
       "OYO 26562 Dazzle Stays                                3.9             371.0   \n",
       "SilverKey Executive Stays 27773 IAS Colony            3.8            2195.0   \n",
       "OYO 1410 Country Club Begumpet                        3.6             366.0   \n",
       "OYO 22907 Hotel Holiday Deluxe                        4.5             393.0   \n",
       "OYO 47727 S Grand                                     4.4             360.0   \n",
       "Capital O 6422 Luxor Park                             4.5            1914.0   \n",
       "OYO 9302 Hotel Baseraa Inn                            4.5             170.0   \n",
       "OYO 8941 Hotel Golden Leaves                          4.4             728.0   \n",
       "OYO Flagship 14348 Apollo Hospital                    4.3            1422.0   \n",
       "...                                                   ...               ...   \n",
       "OYO 46744 Hotel Yash                                  4.3             161.0   \n",
       "OYO 62553 Suvee Palace                                0.0               0.0   \n",
       "OYO 61639 Red Carmine                                 4.6             104.0   \n",
       "OYO 44324 Comfort Stay Near Saket Metro               4.6             878.0   \n",
       "OYO Home Luxe 30142 Fabulous Farmstay                 4.6             535.0   \n",
       "OYO 22321 Nitin Palace Guest House                    4.7             279.0   \n",
       "OYO Townhouse 002 Green Park                          4.8            1390.0   \n",
       "Capital O 7075 The Oakland Plaza Hotel Deluxe         4.0            1025.0   \n",
       "OYO 14789 Kempinski Wide                              4.3             195.0   \n",
       "OYO 63837 Ambica Inn                                  0.0               0.0   \n",
       "OYO 37512 Spacious Stay Saket Metro                   4.0             413.0   \n",
       "OYO 60334 Skp Bed & Breakfast                         3.4             114.0   \n",
       "OYO 64271 Singh Hotel 2                               0.0               0.0   \n",
       "OYO 37055 M R Residency Saver                         4.4             541.0   \n",
       "Capital O 712 Defence Colony Deluxe                   4.2             723.0   \n",
       "OYO Home 47965 Cozy Stay Ignou Road Saket             0.0               0.0   \n",
       "OYO Home 47964 Comfortable  Stay Ignou Road Saket     0.0               0.0   \n",
       "OYO 44400 Retreat Inn                                 3.7             315.0   \n",
       "OYO Flagship 36485 Smg Heritage Nehru Enclave         3.8            3842.0   \n",
       "Capital O 39462 Westyard Hotel                        4.0            2104.0   \n",
       "OYO 40657 Aastha                                      4.0             332.0   \n",
       "OYO 14765 Amar Villa                                  3.8             126.0   \n",
       "OYO 7304 Stay Jangpura                                0.0               0.0   \n",
       "OYO 9536 Bee For Home Stay                            4.2              47.0   \n",
       "OYO 543 La Ola Boutique Hotel                         4.2             143.0   \n",
       "OYO 472 Hotel Sareen                                  3.7              90.0   \n",
       "OYO 43002 The Royal Town Deluxe                       3.6             114.0   \n",
       "OYO 48664 Gour White House                            4.3             245.0   \n",
       "OYO 12532 Imperial Inn Deluxe                         4.8             271.0   \n",
       "OYO 13235 The Golden Door                             4.5             173.0   \n",
       "\n",
       "                                                                Summary  \\\n",
       "Name                                                                      \n",
       "OYO 22085 Raj Banjara White House                             Very Good   \n",
       "Collection O 42514 Venkat Nagar                               Very Good   \n",
       "Capital O 44354 Jubilee Banjara Suites                        Very Good   \n",
       "OYO 35487 Hotel Meena Grand                                   Very Good   \n",
       "OYO 16018 Rainbow Saphire                                     Excellent   \n",
       "Collection O 46198 New Sree Krishna                                Good   \n",
       "OYO 14224 Happy Guest house                                   Excellent   \n",
       "OYO 62547 Dream Connect Stays                                 Very Good   \n",
       "OYO 11376 Golden Park                                         Very Good   \n",
       "OYO 11316 Athithi Inn                                              Fair   \n",
       "OYO 10272 Hotel Ruma                                          Very Good   \n",
       "OYO 18725 Sr Grand                                            Very Good   \n",
       "OYO 18302 Pride Banjara                            Yet to be summarised   \n",
       "OYO 983 Hotel Surya Residency                                 Very Good   \n",
       "Capital O 46832 Gaayatri Residency Deluxe                     Excellent   \n",
       "OYO 4025 Hotel Meredian Orchid                                Very Good   \n",
       "OYO Townhouse 045 Lakdi ka Pul                                Very Good   \n",
       "OYO 41751 Hotel Sabharwal                                     Very Good   \n",
       "OYO 47332 Hotel Dolphin                                       Very Good   \n",
       "OYO 30744 The  Gate                                           Very Good   \n",
       "OYO 37906 New Asian Lodge                                          Fair   \n",
       "OYO 26562 Dazzle Stays                                             Good   \n",
       "SilverKey Executive Stays 27773 IAS Colony                         Good   \n",
       "OYO 1410 Country Club Begumpet                                     Good   \n",
       "OYO 22907 Hotel Holiday Deluxe                                Excellent   \n",
       "OYO 47727 S Grand                                             Very Good   \n",
       "Capital O 6422 Luxor Park                                     Excellent   \n",
       "OYO 9302 Hotel Baseraa Inn                                    Excellent   \n",
       "OYO 8941 Hotel Golden Leaves                                  Very Good   \n",
       "OYO Flagship 14348 Apollo Hospital                            Very Good   \n",
       "...                                                                 ...   \n",
       "OYO 46744 Hotel Yash                                          Very Good   \n",
       "OYO 62553 Suvee Palace                             Yet to be summarised   \n",
       "OYO 61639 Red Carmine                                         Excellent   \n",
       "OYO 44324 Comfort Stay Near Saket Metro                       Excellent   \n",
       "OYO Home Luxe 30142 Fabulous Farmstay                         Excellent   \n",
       "OYO 22321 Nitin Palace Guest House                            Excellent   \n",
       "OYO Townhouse 002 Green Park                                  Excellent   \n",
       "Capital O 7075 The Oakland Plaza Hotel Deluxe                 Very Good   \n",
       "OYO 14789 Kempinski Wide                                      Very Good   \n",
       "OYO 63837 Ambica Inn                               Yet to be summarised   \n",
       "OYO 37512 Spacious Stay Saket Metro                           Very Good   \n",
       "OYO 60334 Skp Bed & Breakfast                                      Fair   \n",
       "OYO 64271 Singh Hotel 2                            Yet to be summarised   \n",
       "OYO 37055 M R Residency Saver                                 Very Good   \n",
       "Capital O 712 Defence Colony Deluxe                           Very Good   \n",
       "OYO Home 47965 Cozy Stay Ignou Road Saket          Yet to be summarised   \n",
       "OYO Home 47964 Comfortable  Stay Ignou Road Saket  Yet to be summarised   \n",
       "OYO 44400 Retreat Inn                                              Good   \n",
       "OYO Flagship 36485 Smg Heritage Nehru Enclave                      Good   \n",
       "Capital O 39462 Westyard Hotel                                Very Good   \n",
       "OYO 40657 Aastha                                              Very Good   \n",
       "OYO 14765 Amar Villa                                               Good   \n",
       "OYO 7304 Stay Jangpura                             Yet to be summarised   \n",
       "OYO 9536 Bee For Home Stay                                    Very Good   \n",
       "OYO 543 La Ola Boutique Hotel                                 Very Good   \n",
       "OYO 472 Hotel Sareen                                               Good   \n",
       "OYO 43002 The Royal Town Deluxe                                    Good   \n",
       "OYO 48664 Gour White House                                    Very Good   \n",
       "OYO 12532 Imperial Inn Deluxe                                 Excellent   \n",
       "OYO 13235 The Golden Door                                     Excellent   \n",
       "\n",
       "                                                        Location       City  \n",
       "Name                                                                         \n",
       "OYO 22085 Raj Banjara White House                  Banjara Hills  Hyderabad  \n",
       "Collection O 42514 Venkat Nagar                    Banjara Hills  Hyderabad  \n",
       "Capital O 44354 Jubilee Banjara Suites             Banjara Hills  Hyderabad  \n",
       "OYO 35487 Hotel Meena Grand                        Banjara Hills  Hyderabad  \n",
       "OYO 16018 Rainbow Saphire                          Banjara Hills  Hyderabad  \n",
       "Collection O 46198 New Sree Krishna                Banjara Hills  Hyderabad  \n",
       "OYO 14224 Happy Guest house                        Banjara Hills  Hyderabad  \n",
       "OYO 62547 Dream Connect Stays                      Banjara Hills  Hyderabad  \n",
       "OYO 11376 Golden Park                              Banjara Hills  Hyderabad  \n",
       "OYO 11316 Athithi Inn                              Banjara Hills  Hyderabad  \n",
       "OYO 10272 Hotel Ruma                               Banjara Hills  Hyderabad  \n",
       "OYO 18725 Sr Grand                                 Banjara Hills  Hyderabad  \n",
       "OYO 18302 Pride Banjara                            Banjara Hills  Hyderabad  \n",
       "OYO 983 Hotel Surya Residency                      Banjara Hills  Hyderabad  \n",
       "Capital O 46832 Gaayatri Residency Deluxe          Banjara Hills  Hyderabad  \n",
       "OYO 4025 Hotel Meredian Orchid                     Banjara Hills  Hyderabad  \n",
       "OYO Townhouse 045 Lakdi ka Pul                     Banjara Hills  Hyderabad  \n",
       "OYO 41751 Hotel Sabharwal                          Banjara Hills  Hyderabad  \n",
       "OYO 47332 Hotel Dolphin                            Banjara Hills  Hyderabad  \n",
       "OYO 30744 The  Gate                                Banjara Hills  Hyderabad  \n",
       "OYO 37906 New Asian Lodge                          Banjara Hills  Hyderabad  \n",
       "OYO 26562 Dazzle Stays                             Banjara Hills  Hyderabad  \n",
       "SilverKey Executive Stays 27773 IAS Colony         Banjara Hills  Hyderabad  \n",
       "OYO 1410 Country Club Begumpet                     Banjara Hills  Hyderabad  \n",
       "OYO 22907 Hotel Holiday Deluxe                     Banjara Hills  Hyderabad  \n",
       "OYO 47727 S Grand                                  Banjara Hills  Hyderabad  \n",
       "Capital O 6422 Luxor Park                          Banjara Hills  Hyderabad  \n",
       "OYO 9302 Hotel Baseraa Inn                         Banjara Hills  Hyderabad  \n",
       "OYO 8941 Hotel Golden Leaves                       Banjara Hills  Hyderabad  \n",
       "OYO Flagship 14348 Apollo Hospital                 Banjara Hills  Hyderabad  \n",
       "...                                                          ...        ...  \n",
       "OYO 46744 Hotel Yash                                 Nehru Place      Delhi  \n",
       "OYO 62553 Suvee Palace                               Nehru Place      Delhi  \n",
       "OYO 61639 Red Carmine                                Nehru Place      Delhi  \n",
       "OYO 44324 Comfort Stay Near Saket Metro              Nehru Place      Delhi  \n",
       "OYO Home Luxe 30142 Fabulous Farmstay                Nehru Place      Delhi  \n",
       "OYO 22321 Nitin Palace Guest House                   Nehru Place      Delhi  \n",
       "OYO Townhouse 002 Green Park                         Nehru Place      Delhi  \n",
       "Capital O 7075 The Oakland Plaza Hotel Deluxe        Nehru Place      Delhi  \n",
       "OYO 14789 Kempinski Wide                             Nehru Place      Delhi  \n",
       "OYO 63837 Ambica Inn                                 Nehru Place      Delhi  \n",
       "OYO 37512 Spacious Stay Saket Metro                  Nehru Place      Delhi  \n",
       "OYO 60334 Skp Bed & Breakfast                        Nehru Place      Delhi  \n",
       "OYO 64271 Singh Hotel 2                              Nehru Place      Delhi  \n",
       "OYO 37055 M R Residency Saver                        Nehru Place      Delhi  \n",
       "Capital O 712 Defence Colony Deluxe                  Nehru Place      Delhi  \n",
       "OYO Home 47965 Cozy Stay Ignou Road Saket            Nehru Place      Delhi  \n",
       "OYO Home 47964 Comfortable  Stay Ignou Road Saket    Nehru Place      Delhi  \n",
       "OYO 44400 Retreat Inn                                Nehru Place      Delhi  \n",
       "OYO Flagship 36485 Smg Heritage Nehru Enclave        Nehru Place      Delhi  \n",
       "Capital O 39462 Westyard Hotel                       Nehru Place      Delhi  \n",
       "OYO 40657 Aastha                                     Nehru Place      Delhi  \n",
       "OYO 14765 Amar Villa                                 Nehru Place      Delhi  \n",
       "OYO 7304 Stay Jangpura                               Nehru Place      Delhi  \n",
       "OYO 9536 Bee For Home Stay                           Nehru Place      Delhi  \n",
       "OYO 543 La Ola Boutique Hotel                        Nehru Place      Delhi  \n",
       "OYO 472 Hotel Sareen                                 Nehru Place      Delhi  \n",
       "OYO 43002 The Royal Town Deluxe                      Nehru Place      Delhi  \n",
       "OYO 48664 Gour White House                           Nehru Place      Delhi  \n",
       "OYO 12532 Imperial Inn Deluxe                        Nehru Place      Delhi  \n",
       "OYO 13235 The Golden Door                            Nehru Place      Delhi  \n",
       "\n",
       "[11982 rows x 9 columns]"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.set_index('Name')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv('Cleaned_data.csv',index=False,header=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}