Outlier Exercise Feature engineering .ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "5c3eecce",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "11f8e310",
   "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>id</th>\n",
       "      <th>name</th>\n",
       "      <th>host_id</th>\n",
       "      <th>host_name</th>\n",
       "      <th>neighbourhood_group</th>\n",
       "      <th>neighbourhood</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>room_type</th>\n",
       "      <th>price</th>\n",
       "      <th>minimum_nights</th>\n",
       "      <th>number_of_reviews</th>\n",
       "      <th>last_review</th>\n",
       "      <th>reviews_per_month</th>\n",
       "      <th>calculated_host_listings_count</th>\n",
       "      <th>availability_365</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2539</td>\n",
       "      <td>Clean &amp; quiet apt home by the park</td>\n",
       "      <td>2787</td>\n",
       "      <td>John</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Kensington</td>\n",
       "      <td>40.64749</td>\n",
       "      <td>-73.97237</td>\n",
       "      <td>Private room</td>\n",
       "      <td>149</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>2018-10-19</td>\n",
       "      <td>0.21</td>\n",
       "      <td>6</td>\n",
       "      <td>365</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2595</td>\n",
       "      <td>Skylit Midtown Castle</td>\n",
       "      <td>2845</td>\n",
       "      <td>Jennifer</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Midtown</td>\n",
       "      <td>40.75362</td>\n",
       "      <td>-73.98377</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>225</td>\n",
       "      <td>1</td>\n",
       "      <td>45</td>\n",
       "      <td>2019-05-21</td>\n",
       "      <td>0.38</td>\n",
       "      <td>2</td>\n",
       "      <td>355</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3647</td>\n",
       "      <td>THE VILLAGE OF HARLEM....NEW YORK !</td>\n",
       "      <td>4632</td>\n",
       "      <td>Elisabeth</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Harlem</td>\n",
       "      <td>40.80902</td>\n",
       "      <td>-73.94190</td>\n",
       "      <td>Private room</td>\n",
       "      <td>150</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>365</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3831</td>\n",
       "      <td>Cozy Entire Floor of Brownstone</td>\n",
       "      <td>4869</td>\n",
       "      <td>LisaRoxanne</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Clinton Hill</td>\n",
       "      <td>40.68514</td>\n",
       "      <td>-73.95976</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>89</td>\n",
       "      <td>1</td>\n",
       "      <td>270</td>\n",
       "      <td>2019-07-05</td>\n",
       "      <td>4.64</td>\n",
       "      <td>1</td>\n",
       "      <td>194</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5022</td>\n",
       "      <td>Entire Apt: Spacious Studio/Loft by central park</td>\n",
       "      <td>7192</td>\n",
       "      <td>Laura</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>East Harlem</td>\n",
       "      <td>40.79851</td>\n",
       "      <td>-73.94399</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>80</td>\n",
       "      <td>10</td>\n",
       "      <td>9</td>\n",
       "      <td>2018-11-19</td>\n",
       "      <td>0.10</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     id                                              name  host_id  \\\n",
       "0  2539                Clean & quiet apt home by the park     2787   \n",
       "1  2595                             Skylit Midtown Castle     2845   \n",
       "2  3647               THE VILLAGE OF HARLEM....NEW YORK !     4632   \n",
       "3  3831                   Cozy Entire Floor of Brownstone     4869   \n",
       "4  5022  Entire Apt: Spacious Studio/Loft by central park     7192   \n",
       "\n",
       "     host_name neighbourhood_group neighbourhood  latitude  longitude  \\\n",
       "0         John            Brooklyn    Kensington  40.64749  -73.97237   \n",
       "1     Jennifer           Manhattan       Midtown  40.75362  -73.98377   \n",
       "2    Elisabeth           Manhattan        Harlem  40.80902  -73.94190   \n",
       "3  LisaRoxanne            Brooklyn  Clinton Hill  40.68514  -73.95976   \n",
       "4        Laura           Manhattan   East Harlem  40.79851  -73.94399   \n",
       "\n",
       "         room_type  price  minimum_nights  number_of_reviews last_review  \\\n",
       "0     Private room    149               1                  9  2018-10-19   \n",
       "1  Entire home/apt    225               1                 45  2019-05-21   \n",
       "2     Private room    150               3                  0         NaN   \n",
       "3  Entire home/apt     89               1                270  2019-07-05   \n",
       "4  Entire home/apt     80              10                  9  2018-11-19   \n",
       "\n",
       "   reviews_per_month  calculated_host_listings_count  availability_365  \n",
       "0               0.21                               6               365  \n",
       "1               0.38                               2               355  \n",
       "2                NaN                               1               365  \n",
       "3               4.64                               1               194  \n",
       "4               0.10                               1                 0  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv(\"airbnb.csv\")\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "741d3bdc",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(48895, 16)"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "0e654912",
   "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>id</th>\n",
       "      <th>host_id</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>price</th>\n",
       "      <th>minimum_nights</th>\n",
       "      <th>number_of_reviews</th>\n",
       "      <th>reviews_per_month</th>\n",
       "      <th>calculated_host_listings_count</th>\n",
       "      <th>availability_365</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>4.889500e+04</td>\n",
       "      <td>4.889500e+04</td>\n",
       "      <td>48895.000000</td>\n",
       "      <td>48895.000000</td>\n",
       "      <td>48895.000000</td>\n",
       "      <td>48895.000000</td>\n",
       "      <td>48895.000000</td>\n",
       "      <td>38843.000000</td>\n",
       "      <td>48895.000000</td>\n",
       "      <td>48895.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>1.901714e+07</td>\n",
       "      <td>6.762001e+07</td>\n",
       "      <td>40.728949</td>\n",
       "      <td>-73.952170</td>\n",
       "      <td>152.720687</td>\n",
       "      <td>7.029962</td>\n",
       "      <td>23.274466</td>\n",
       "      <td>1.373221</td>\n",
       "      <td>7.143982</td>\n",
       "      <td>112.781327</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>1.098311e+07</td>\n",
       "      <td>7.861097e+07</td>\n",
       "      <td>0.054530</td>\n",
       "      <td>0.046157</td>\n",
       "      <td>240.154170</td>\n",
       "      <td>20.510550</td>\n",
       "      <td>44.550582</td>\n",
       "      <td>1.680442</td>\n",
       "      <td>32.952519</td>\n",
       "      <td>131.622289</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>2.539000e+03</td>\n",
       "      <td>2.438000e+03</td>\n",
       "      <td>40.499790</td>\n",
       "      <td>-74.244420</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.010000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>9.471945e+06</td>\n",
       "      <td>7.822033e+06</td>\n",
       "      <td>40.690100</td>\n",
       "      <td>-73.983070</td>\n",
       "      <td>69.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.190000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>1.967728e+07</td>\n",
       "      <td>3.079382e+07</td>\n",
       "      <td>40.723070</td>\n",
       "      <td>-73.955680</td>\n",
       "      <td>106.000000</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>0.720000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>45.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>2.915218e+07</td>\n",
       "      <td>1.074344e+08</td>\n",
       "      <td>40.763115</td>\n",
       "      <td>-73.936275</td>\n",
       "      <td>175.000000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>24.000000</td>\n",
       "      <td>2.020000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>227.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>3.648724e+07</td>\n",
       "      <td>2.743213e+08</td>\n",
       "      <td>40.913060</td>\n",
       "      <td>-73.712990</td>\n",
       "      <td>10000.000000</td>\n",
       "      <td>1250.000000</td>\n",
       "      <td>629.000000</td>\n",
       "      <td>58.500000</td>\n",
       "      <td>327.000000</td>\n",
       "      <td>365.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 id       host_id      latitude     longitude         price  \\\n",
       "count  4.889500e+04  4.889500e+04  48895.000000  48895.000000  48895.000000   \n",
       "mean   1.901714e+07  6.762001e+07     40.728949    -73.952170    152.720687   \n",
       "std    1.098311e+07  7.861097e+07      0.054530      0.046157    240.154170   \n",
       "min    2.539000e+03  2.438000e+03     40.499790    -74.244420      0.000000   \n",
       "25%    9.471945e+06  7.822033e+06     40.690100    -73.983070     69.000000   \n",
       "50%    1.967728e+07  3.079382e+07     40.723070    -73.955680    106.000000   \n",
       "75%    2.915218e+07  1.074344e+08     40.763115    -73.936275    175.000000   \n",
       "max    3.648724e+07  2.743213e+08     40.913060    -73.712990  10000.000000   \n",
       "\n",
       "       minimum_nights  number_of_reviews  reviews_per_month  \\\n",
       "count    48895.000000       48895.000000       38843.000000   \n",
       "mean         7.029962          23.274466           1.373221   \n",
       "std         20.510550          44.550582           1.680442   \n",
       "min          1.000000           0.000000           0.010000   \n",
       "25%          1.000000           1.000000           0.190000   \n",
       "50%          3.000000           5.000000           0.720000   \n",
       "75%          5.000000          24.000000           2.020000   \n",
       "max       1250.000000         629.000000          58.500000   \n",
       "\n",
       "       calculated_host_listings_count  availability_365  \n",
       "count                    48895.000000      48895.000000  \n",
       "mean                         7.143982        112.781327  \n",
       "std                         32.952519        131.622289  \n",
       "min                          1.000000          0.000000  \n",
       "25%                          1.000000          0.000000  \n",
       "50%                          1.000000         45.000000  \n",
       "75%                          2.000000        227.000000  \n",
       "max                        327.000000        365.000000  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "b43cc7a4",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(30.0, 3000.0)"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "min_thresold, max_thresold = df.price.quantile([0.01,0.999])\n",
    "min_thresold, max_thresold"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "99002bb8",
   "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>id</th>\n",
       "      <th>name</th>\n",
       "      <th>host_id</th>\n",
       "      <th>host_name</th>\n",
       "      <th>neighbourhood_group</th>\n",
       "      <th>neighbourhood</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>room_type</th>\n",
       "      <th>price</th>\n",
       "      <th>minimum_nights</th>\n",
       "      <th>number_of_reviews</th>\n",
       "      <th>last_review</th>\n",
       "      <th>reviews_per_month</th>\n",
       "      <th>calculated_host_listings_count</th>\n",
       "      <th>availability_365</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>957</th>\n",
       "      <td>375249</td>\n",
       "      <td>Enjoy Staten Island Hospitality</td>\n",
       "      <td>1887999</td>\n",
       "      <td>Rimma &amp; Jim</td>\n",
       "      <td>Staten Island</td>\n",
       "      <td>Graniteville</td>\n",
       "      <td>40.62109</td>\n",
       "      <td>-74.16534</td>\n",
       "      <td>Private room</td>\n",
       "      <td>20</td>\n",
       "      <td>3</td>\n",
       "      <td>80</td>\n",
       "      <td>2019-05-26</td>\n",
       "      <td>0.92</td>\n",
       "      <td>1</td>\n",
       "      <td>226</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2675</th>\n",
       "      <td>1428154</td>\n",
       "      <td>Central, Peaceful Semi-Private Room</td>\n",
       "      <td>5912572</td>\n",
       "      <td>Tangier</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Flatbush</td>\n",
       "      <td>40.63899</td>\n",
       "      <td>-73.95177</td>\n",
       "      <td>Shared room</td>\n",
       "      <td>29</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>2014-10-20</td>\n",
       "      <td>0.07</td>\n",
       "      <td>1</td>\n",
       "      <td>321</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2860</th>\n",
       "      <td>1620248</td>\n",
       "      <td>Large furnished 2 bedrooms- - 30 days Minimum</td>\n",
       "      <td>2196224</td>\n",
       "      <td>Sally</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>East Village</td>\n",
       "      <td>40.73051</td>\n",
       "      <td>-73.98140</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>10</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>137</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3020</th>\n",
       "      <td>1767037</td>\n",
       "      <td>Small Cozy Room Wifi &amp; AC near JFK</td>\n",
       "      <td>9284163</td>\n",
       "      <td>Antonio</td>\n",
       "      <td>Queens</td>\n",
       "      <td>Woodhaven</td>\n",
       "      <td>40.68968</td>\n",
       "      <td>-73.85219</td>\n",
       "      <td>Private room</td>\n",
       "      <td>29</td>\n",
       "      <td>2</td>\n",
       "      <td>386</td>\n",
       "      <td>2019-06-19</td>\n",
       "      <td>5.53</td>\n",
       "      <td>3</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3918</th>\n",
       "      <td>2431607</td>\n",
       "      <td>Bright, Airy Room Share for 2</td>\n",
       "      <td>4973668</td>\n",
       "      <td>Gloria</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Bedford-Stuyvesant</td>\n",
       "      <td>40.68642</td>\n",
       "      <td>-73.93440</td>\n",
       "      <td>Shared room</td>\n",
       "      <td>25</td>\n",
       "      <td>5</td>\n",
       "      <td>76</td>\n",
       "      <td>2019-06-06</td>\n",
       "      <td>1.22</td>\n",
       "      <td>3</td>\n",
       "      <td>258</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48486</th>\n",
       "      <td>36280646</td>\n",
       "      <td>Cable and wfi, L/G included.</td>\n",
       "      <td>272872092</td>\n",
       "      <td>Chris</td>\n",
       "      <td>Queens</td>\n",
       "      <td>Forest Hills</td>\n",
       "      <td>40.73657</td>\n",
       "      <td>-73.85088</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>16</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-07-07</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1</td>\n",
       "      <td>322</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48647</th>\n",
       "      <td>36354776</td>\n",
       "      <td>Cozy bedroom in diverse neighborhood near JFK</td>\n",
       "      <td>273393150</td>\n",
       "      <td>Liza</td>\n",
       "      <td>Queens</td>\n",
       "      <td>Richmond Hill</td>\n",
       "      <td>40.68639</td>\n",
       "      <td>-73.81847</td>\n",
       "      <td>Private room</td>\n",
       "      <td>28</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48832</th>\n",
       "      <td>36450814</td>\n",
       "      <td>FLATBUSH HANG OUT AND GO</td>\n",
       "      <td>267223765</td>\n",
       "      <td>Jarmel</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Flatbush</td>\n",
       "      <td>40.64922</td>\n",
       "      <td>-73.96078</td>\n",
       "      <td>Shared room</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>363</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48867</th>\n",
       "      <td>36473044</td>\n",
       "      <td>The place you were dreaming for.(only for guys)</td>\n",
       "      <td>261338177</td>\n",
       "      <td>Diana</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Gravesend</td>\n",
       "      <td>40.59080</td>\n",
       "      <td>-73.97116</td>\n",
       "      <td>Shared room</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6</td>\n",
       "      <td>338</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48868</th>\n",
       "      <td>36473253</td>\n",
       "      <td>Heaven for you(only for guy)</td>\n",
       "      <td>261338177</td>\n",
       "      <td>Diana</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Gravesend</td>\n",
       "      <td>40.59118</td>\n",
       "      <td>-73.97119</td>\n",
       "      <td>Shared room</td>\n",
       "      <td>25</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6</td>\n",
       "      <td>365</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>404 rows × 16 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             id                                             name    host_id  \\\n",
       "957      375249                  Enjoy Staten Island Hospitality    1887999   \n",
       "2675    1428154              Central, Peaceful Semi-Private Room    5912572   \n",
       "2860    1620248    Large furnished 2 bedrooms- - 30 days Minimum    2196224   \n",
       "3020    1767037               Small Cozy Room Wifi & AC near JFK    9284163   \n",
       "3918    2431607                    Bright, Airy Room Share for 2    4973668   \n",
       "...         ...                                              ...        ...   \n",
       "48486  36280646                     Cable and wfi, L/G included.  272872092   \n",
       "48647  36354776    Cozy bedroom in diverse neighborhood near JFK  273393150   \n",
       "48832  36450814                         FLATBUSH HANG OUT AND GO  267223765   \n",
       "48867  36473044  The place you were dreaming for.(only for guys)  261338177   \n",
       "48868  36473253                     Heaven for you(only for guy)  261338177   \n",
       "\n",
       "         host_name neighbourhood_group       neighbourhood  latitude  \\\n",
       "957    Rimma & Jim       Staten Island        Graniteville  40.62109   \n",
       "2675       Tangier            Brooklyn            Flatbush  40.63899   \n",
       "2860         Sally           Manhattan        East Village  40.73051   \n",
       "3020       Antonio              Queens           Woodhaven  40.68968   \n",
       "3918        Gloria            Brooklyn  Bedford-Stuyvesant  40.68642   \n",
       "...            ...                 ...                 ...       ...   \n",
       "48486        Chris              Queens        Forest Hills  40.73657   \n",
       "48647         Liza              Queens       Richmond Hill  40.68639   \n",
       "48832       Jarmel            Brooklyn            Flatbush  40.64922   \n",
       "48867        Diana            Brooklyn           Gravesend  40.59080   \n",
       "48868        Diana            Brooklyn           Gravesend  40.59118   \n",
       "\n",
       "       longitude        room_type  price  minimum_nights  number_of_reviews  \\\n",
       "957    -74.16534     Private room     20               3                 80   \n",
       "2675   -73.95177      Shared room     29               2                  5   \n",
       "2860   -73.98140  Entire home/apt     10              30                  0   \n",
       "3020   -73.85219     Private room     29               2                386   \n",
       "3918   -73.93440      Shared room     25               5                 76   \n",
       "...          ...              ...    ...             ...                ...   \n",
       "48486  -73.85088  Entire home/apt     16               9                  1   \n",
       "48647  -73.81847     Private room     28               2                  0   \n",
       "48832  -73.96078      Shared room     20               1                  0   \n",
       "48867  -73.97116      Shared room     25               1                  0   \n",
       "48868  -73.97119      Shared room     25               7                  0   \n",
       "\n",
       "      last_review  reviews_per_month  calculated_host_listings_count  \\\n",
       "957    2019-05-26               0.92                               1   \n",
       "2675   2014-10-20               0.07                               1   \n",
       "2860          NaN                NaN                               4   \n",
       "3020   2019-06-19               5.53                               3   \n",
       "3918   2019-06-06               1.22                               3   \n",
       "...           ...                ...                             ...   \n",
       "48486  2019-07-07               1.00                               1   \n",
       "48647         NaN                NaN                               1   \n",
       "48832         NaN                NaN                               3   \n",
       "48867         NaN                NaN                               6   \n",
       "48868         NaN                NaN                               6   \n",
       "\n",
       "       availability_365  \n",
       "957                 226  \n",
       "2675                321  \n",
       "2860                137  \n",
       "3020                 50  \n",
       "3918                258  \n",
       "...                 ...  \n",
       "48486               322  \n",
       "48647                24  \n",
       "48832               363  \n",
       "48867               338  \n",
       "48868               365  \n",
       "\n",
       "[404 rows x 16 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df.price < min_thresold]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "886f467b",
   "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>id</th>\n",
       "      <th>name</th>\n",
       "      <th>host_id</th>\n",
       "      <th>host_name</th>\n",
       "      <th>neighbourhood_group</th>\n",
       "      <th>neighbourhood</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>room_type</th>\n",
       "      <th>price</th>\n",
       "      <th>minimum_nights</th>\n",
       "      <th>number_of_reviews</th>\n",
       "      <th>last_review</th>\n",
       "      <th>reviews_per_month</th>\n",
       "      <th>calculated_host_listings_count</th>\n",
       "      <th>availability_365</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1862</th>\n",
       "      <td>826690</td>\n",
       "      <td>Sunny, Family-Friendly 2 Bedroom</td>\n",
       "      <td>4289240</td>\n",
       "      <td>Lucy</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Prospect Heights</td>\n",
       "      <td>40.67919</td>\n",
       "      <td>-73.97191</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>4000</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2698</th>\n",
       "      <td>1448703</td>\n",
       "      <td>Beautiful 1 Bedroom in Nolita/Soho</td>\n",
       "      <td>213266</td>\n",
       "      <td>Jessica</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Nolita</td>\n",
       "      <td>40.72193</td>\n",
       "      <td>-73.99379</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>5000</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2013-09-28</td>\n",
       "      <td>0.03</td>\n",
       "      <td>1</td>\n",
       "      <td>365</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3537</th>\n",
       "      <td>2110145</td>\n",
       "      <td>UWS 1BR w/backyard + block from CP</td>\n",
       "      <td>2151325</td>\n",
       "      <td>Jay And Liz</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Upper West Side</td>\n",
       "      <td>40.77782</td>\n",
       "      <td>-73.97848</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>6000</td>\n",
       "      <td>14</td>\n",
       "      <td>17</td>\n",
       "      <td>2015-02-17</td>\n",
       "      <td>0.27</td>\n",
       "      <td>1</td>\n",
       "      <td>359</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3695</th>\n",
       "      <td>2224896</td>\n",
       "      <td>NYC SuperBowl Wk 5 Bdrs River View</td>\n",
       "      <td>11353904</td>\n",
       "      <td>Todd</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Upper West Side</td>\n",
       "      <td>40.79476</td>\n",
       "      <td>-73.97299</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>4000</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3720</th>\n",
       "      <td>2243699</td>\n",
       "      <td>SuperBowl Penthouse Loft 3,000 sqft</td>\n",
       "      <td>1483320</td>\n",
       "      <td>Omri</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Little Italy</td>\n",
       "      <td>40.71895</td>\n",
       "      <td>-73.99793</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>5250</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3774</th>\n",
       "      <td>2271504</td>\n",
       "      <td>SUPER BOWL Brooklyn Duplex Apt!!</td>\n",
       "      <td>11598359</td>\n",
       "      <td>Jonathan</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Clinton Hill</td>\n",
       "      <td>40.68766</td>\n",
       "      <td>-73.96439</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>6500</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3788</th>\n",
       "      <td>2281142</td>\n",
       "      <td>Prime NYC Location for Super Bowl</td>\n",
       "      <td>1427243</td>\n",
       "      <td>Jordana</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>East Village</td>\n",
       "      <td>40.73323</td>\n",
       "      <td>-73.98859</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>3750</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4345</th>\n",
       "      <td>2919330</td>\n",
       "      <td>NearWilliamsburg bridge 11211 BK</td>\n",
       "      <td>14908606</td>\n",
       "      <td>Bianca</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Bedford-Stuyvesant</td>\n",
       "      <td>40.69572</td>\n",
       "      <td>-73.95731</td>\n",
       "      <td>Private room</td>\n",
       "      <td>5000</td>\n",
       "      <td>6</td>\n",
       "      <td>10</td>\n",
       "      <td>2016-01-02</td>\n",
       "      <td>0.16</td>\n",
       "      <td>1</td>\n",
       "      <td>363</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4376</th>\n",
       "      <td>2952861</td>\n",
       "      <td>Photography Location</td>\n",
       "      <td>1177497</td>\n",
       "      <td>Jessica</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Clinton Hill</td>\n",
       "      <td>40.69127</td>\n",
       "      <td>-73.96563</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>4500</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>2018-12-29</td>\n",
       "      <td>0.09</td>\n",
       "      <td>11</td>\n",
       "      <td>365</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4377</th>\n",
       "      <td>2953058</td>\n",
       "      <td>Film Location</td>\n",
       "      <td>1177497</td>\n",
       "      <td>Jessica</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Clinton Hill</td>\n",
       "      <td>40.69137</td>\n",
       "      <td>-73.96723</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>8000</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2016-09-15</td>\n",
       "      <td>0.03</td>\n",
       "      <td>11</td>\n",
       "      <td>365</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6530</th>\n",
       "      <td>4737930</td>\n",
       "      <td>Spanish Harlem Apt</td>\n",
       "      <td>1235070</td>\n",
       "      <td>Olson</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>East Harlem</td>\n",
       "      <td>40.79264</td>\n",
       "      <td>-73.93898</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>9999</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>2015-01-02</td>\n",
       "      <td>0.02</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9151</th>\n",
       "      <td>7003697</td>\n",
       "      <td>Furnished room in Astoria apartment</td>\n",
       "      <td>20582832</td>\n",
       "      <td>Kathrine</td>\n",
       "      <td>Queens</td>\n",
       "      <td>Astoria</td>\n",
       "      <td>40.76810</td>\n",
       "      <td>-73.91651</td>\n",
       "      <td>Private room</td>\n",
       "      <td>10000</td>\n",
       "      <td>100</td>\n",
       "      <td>2</td>\n",
       "      <td>2016-02-13</td>\n",
       "      <td>0.04</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12342</th>\n",
       "      <td>9528920</td>\n",
       "      <td>Quiet, Clean, Lit @ LES &amp; Chinatown</td>\n",
       "      <td>3906464</td>\n",
       "      <td>Amy</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Lower East Side</td>\n",
       "      <td>40.71355</td>\n",
       "      <td>-73.98507</td>\n",
       "      <td>Private room</td>\n",
       "      <td>9999</td>\n",
       "      <td>99</td>\n",
       "      <td>6</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>0.14</td>\n",
       "      <td>1</td>\n",
       "      <td>83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15560</th>\n",
       "      <td>12520066</td>\n",
       "      <td>Luxury townhouse Greenwich Village</td>\n",
       "      <td>66240032</td>\n",
       "      <td>Linda</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Greenwich Village</td>\n",
       "      <td>40.73046</td>\n",
       "      <td>-73.99562</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>6000</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17665</th>\n",
       "      <td>13882394</td>\n",
       "      <td>VIP Duplex Townhouse with Private Garden!!!</td>\n",
       "      <td>49186997</td>\n",
       "      <td>Joseph</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Greenwich Village</td>\n",
       "      <td>40.73305</td>\n",
       "      <td>-73.99373</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>3800</td>\n",
       "      <td>30</td>\n",
       "      <td>2</td>\n",
       "      <td>2017-01-27</td>\n",
       "      <td>0.06</td>\n",
       "      <td>1</td>\n",
       "      <td>180</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17692</th>\n",
       "      <td>13894339</td>\n",
       "      <td>Luxury 1 bedroom apt. -stunning Manhattan views</td>\n",
       "      <td>5143901</td>\n",
       "      <td>Erin</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Greenpoint</td>\n",
       "      <td>40.73260</td>\n",
       "      <td>-73.95739</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>10000</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>2017-07-27</td>\n",
       "      <td>0.16</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21821</th>\n",
       "      <td>17537893</td>\n",
       "      <td>The Otheroom Bar/Event/Filming Space -read det...</td>\n",
       "      <td>18037301</td>\n",
       "      <td>James</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>West Village</td>\n",
       "      <td>40.73571</td>\n",
       "      <td>-74.00780</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>4000</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>173</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22353</th>\n",
       "      <td>18051877</td>\n",
       "      <td>Victorian Film location</td>\n",
       "      <td>2675644</td>\n",
       "      <td>Alissa</td>\n",
       "      <td>Staten Island</td>\n",
       "      <td>Randall Manor</td>\n",
       "      <td>40.63952</td>\n",
       "      <td>-74.09730</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>5000</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>344</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25825</th>\n",
       "      <td>20654227</td>\n",
       "      <td>Fulton 2</td>\n",
       "      <td>100069033</td>\n",
       "      <td>Sarah-2</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Cypress Hills</td>\n",
       "      <td>40.68185</td>\n",
       "      <td>-73.88128</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>5000</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>2018-01-03</td>\n",
       "      <td>0.18</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25901</th>\n",
       "      <td>20692563</td>\n",
       "      <td>Greenwich Village Townhome with Private Garden!</td>\n",
       "      <td>147814925</td>\n",
       "      <td>Lloyd</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Greenwich Village</td>\n",
       "      <td>40.73300</td>\n",
       "      <td>-73.99413</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>3900</td>\n",
       "      <td>30</td>\n",
       "      <td>7</td>\n",
       "      <td>2018-03-13</td>\n",
       "      <td>0.32</td>\n",
       "      <td>1</td>\n",
       "      <td>180</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26739</th>\n",
       "      <td>21238053</td>\n",
       "      <td>Broadway 1</td>\n",
       "      <td>153497815</td>\n",
       "      <td>Sarah-B</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Bedford-Stuyvesant</td>\n",
       "      <td>40.68742</td>\n",
       "      <td>-73.91957</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>5000</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>2017-12-09</td>\n",
       "      <td>0.38</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28946</th>\n",
       "      <td>22296097</td>\n",
       "      <td>Chelsea Gallery Space for events and exhibitions</td>\n",
       "      <td>3750764</td>\n",
       "      <td>Kevin</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Chelsea</td>\n",
       "      <td>40.74913</td>\n",
       "      <td>-74.00373</td>\n",
       "      <td>Private room</td>\n",
       "      <td>3210</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6</td>\n",
       "      <td>364</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28947</th>\n",
       "      <td>22296197</td>\n",
       "      <td>Chelsea Gallery for events, exhibitions, fashion</td>\n",
       "      <td>3750764</td>\n",
       "      <td>Kevin</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Chelsea</td>\n",
       "      <td>40.74888</td>\n",
       "      <td>-74.00481</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>4160</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6</td>\n",
       "      <td>364</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29238</th>\n",
       "      <td>22436899</td>\n",
       "      <td>1-BR Lincoln Center</td>\n",
       "      <td>72390391</td>\n",
       "      <td>Jelena</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Upper West Side</td>\n",
       "      <td>40.77213</td>\n",
       "      <td>-73.98665</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>10000</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29662</th>\n",
       "      <td>22779726</td>\n",
       "      <td>East 72nd Townhouse by (Hidden by Airbnb)</td>\n",
       "      <td>156158778</td>\n",
       "      <td>Sally</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Upper East Side</td>\n",
       "      <td>40.76824</td>\n",
       "      <td>-73.95989</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>7703</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12</td>\n",
       "      <td>146</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29663</th>\n",
       "      <td>22779746</td>\n",
       "      <td>East 7th Street III by (Hidden by Airbnb)</td>\n",
       "      <td>156158778</td>\n",
       "      <td>Sally</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>East Village</td>\n",
       "      <td>40.72779</td>\n",
       "      <td>-73.98644</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>3518</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12</td>\n",
       "      <td>215</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29664</th>\n",
       "      <td>22780103</td>\n",
       "      <td>Park Avenue Mansion by (Hidden by Airbnb)</td>\n",
       "      <td>156158778</td>\n",
       "      <td>Sally</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Upper East Side</td>\n",
       "      <td>40.78517</td>\n",
       "      <td>-73.95270</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>6419</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12</td>\n",
       "      <td>45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30268</th>\n",
       "      <td>23377410</td>\n",
       "      <td>Beautiful/Spacious 1 bed luxury flat-TriBeCa/Soho</td>\n",
       "      <td>18128455</td>\n",
       "      <td>Rum</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Tribeca</td>\n",
       "      <td>40.72197</td>\n",
       "      <td>-74.00633</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>8500</td>\n",
       "      <td>30</td>\n",
       "      <td>2</td>\n",
       "      <td>2018-09-18</td>\n",
       "      <td>0.18</td>\n",
       "      <td>1</td>\n",
       "      <td>251</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34851</th>\n",
       "      <td>27629043</td>\n",
       "      <td>A Night at Anchor Aboard Yacht Ventura</td>\n",
       "      <td>45863742</td>\n",
       "      <td>James</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Battery Park City</td>\n",
       "      <td>40.71364</td>\n",
       "      <td>-74.01758</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>3750</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>365</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37194</th>\n",
       "      <td>29547314</td>\n",
       "      <td>Apartment New York \\nHell’s Kitchens</td>\n",
       "      <td>35303743</td>\n",
       "      <td>Patricia</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Upper West Side</td>\n",
       "      <td>40.76835</td>\n",
       "      <td>-73.98367</td>\n",
       "      <td>Private room</td>\n",
       "      <td>6500</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37864</th>\n",
       "      <td>29964348</td>\n",
       "      <td>NYC HOLIDAY!!!!   April 15- May 15</td>\n",
       "      <td>2039658</td>\n",
       "      <td>Pam</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Upper East Side</td>\n",
       "      <td>40.76519</td>\n",
       "      <td>-73.96874</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>3600</td>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>358</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38000</th>\n",
       "      <td>30035166</td>\n",
       "      <td>4-Floor Unique Event Space 50P Cap. - #10299B</td>\n",
       "      <td>172611460</td>\n",
       "      <td>Rasmus</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Harlem</td>\n",
       "      <td>40.82511</td>\n",
       "      <td>-73.94961</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>5000</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2019-02-23</td>\n",
       "      <td>0.38</td>\n",
       "      <td>2</td>\n",
       "      <td>150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39243</th>\n",
       "      <td>30589636</td>\n",
       "      <td>Furnished 1000sq large 2bed + office in Harlem</td>\n",
       "      <td>229458601</td>\n",
       "      <td>Kay</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Harlem</td>\n",
       "      <td>40.81315</td>\n",
       "      <td>-73.95110</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>3200</td>\n",
       "      <td>90</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>365</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40433</th>\n",
       "      <td>31340283</td>\n",
       "      <td>2br - The Heart of NYC: Manhattans Lower East ...</td>\n",
       "      <td>4382127</td>\n",
       "      <td>Matt</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Lower East Side</td>\n",
       "      <td>40.71980</td>\n",
       "      <td>-73.98566</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>9999</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>365</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41216</th>\n",
       "      <td>32054910</td>\n",
       "      <td>West 88th Street by (Hidden by Airbnb)</td>\n",
       "      <td>156158778</td>\n",
       "      <td>Sally</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Upper West Side</td>\n",
       "      <td>40.78742</td>\n",
       "      <td>-73.97011</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>3512</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12</td>\n",
       "      <td>124</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42523</th>\n",
       "      <td>33007610</td>\n",
       "      <td>70' Luxury MotorYacht on the Hudson</td>\n",
       "      <td>7407743</td>\n",
       "      <td>Jack</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Battery Park City</td>\n",
       "      <td>40.71162</td>\n",
       "      <td>-74.01693</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>7500</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>364</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42542</th>\n",
       "      <td>33029434</td>\n",
       "      <td>West 84th Street by (Hidden by Airbnb)</td>\n",
       "      <td>156158778</td>\n",
       "      <td>Sally</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Upper West Side</td>\n",
       "      <td>40.78545</td>\n",
       "      <td>-73.97123</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>3613</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-06-15</td>\n",
       "      <td>1.00</td>\n",
       "      <td>12</td>\n",
       "      <td>158</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42736</th>\n",
       "      <td>33171891</td>\n",
       "      <td>30 days minimum Time square West Midtown apart...</td>\n",
       "      <td>177396569</td>\n",
       "      <td>Yanina</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Hell's Kitchen</td>\n",
       "      <td>40.76043</td>\n",
       "      <td>-73.99132</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>4100</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>180</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43009</th>\n",
       "      <td>33397385</td>\n",
       "      <td>Midtown Manhattan great location (Gramacy park)</td>\n",
       "      <td>16105313</td>\n",
       "      <td>Debra</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Midtown</td>\n",
       "      <td>40.74482</td>\n",
       "      <td>-73.98367</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>5100</td>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "      <td>2019-06-22</td>\n",
       "      <td>1.00</td>\n",
       "      <td>2</td>\n",
       "      <td>343</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43670</th>\n",
       "      <td>33796251</td>\n",
       "      <td>Beautiful private Brooklyn room with kitchenette</td>\n",
       "      <td>8748976</td>\n",
       "      <td>Jeffrey</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Bedford-Stuyvesant</td>\n",
       "      <td>40.68807</td>\n",
       "      <td>-73.95426</td>\n",
       "      <td>Private room</td>\n",
       "      <td>4200</td>\n",
       "      <td>114</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>347</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44034</th>\n",
       "      <td>33998396</td>\n",
       "      <td>3000 sq ft daylight photo studio</td>\n",
       "      <td>3750764</td>\n",
       "      <td>Kevin</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Chelsea</td>\n",
       "      <td>40.75060</td>\n",
       "      <td>-74.00388</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>6800</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6</td>\n",
       "      <td>364</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45666</th>\n",
       "      <td>34895693</td>\n",
       "      <td>Gem of east Flatbush</td>\n",
       "      <td>262534951</td>\n",
       "      <td>Sandra</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>East Flatbush</td>\n",
       "      <td>40.65724</td>\n",
       "      <td>-73.92450</td>\n",
       "      <td>Private room</td>\n",
       "      <td>7500</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>2019-07-07</td>\n",
       "      <td>6.15</td>\n",
       "      <td>2</td>\n",
       "      <td>179</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45867</th>\n",
       "      <td>34981637</td>\n",
       "      <td>bay ridge &amp; sunset park furnished apartment</td>\n",
       "      <td>263564234</td>\n",
       "      <td>Nony</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Bay Ridge</td>\n",
       "      <td>40.63087</td>\n",
       "      <td>-74.02006</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>4200</td>\n",
       "      <td>60</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46614</th>\n",
       "      <td>35345358</td>\n",
       "      <td>Northside Williamsburg Stunner</td>\n",
       "      <td>956324</td>\n",
       "      <td>Alex</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Williamsburg</td>\n",
       "      <td>40.71705</td>\n",
       "      <td>-73.96470</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>4500</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>365</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48043</th>\n",
       "      <td>36056808</td>\n",
       "      <td>Luxury TriBeCa Apartment at an amazing price</td>\n",
       "      <td>271248669</td>\n",
       "      <td>Jenny</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Tribeca</td>\n",
       "      <td>40.71206</td>\n",
       "      <td>-74.00999</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>6500</td>\n",
       "      <td>180</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>365</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             id                                               name    host_id  \\\n",
       "1862     826690                   Sunny, Family-Friendly 2 Bedroom    4289240   \n",
       "2698    1448703                Beautiful 1 Bedroom in Nolita/Soho      213266   \n",
       "3537    2110145                 UWS 1BR w/backyard + block from CP    2151325   \n",
       "3695    2224896                NYC SuperBowl Wk 5 Bdrs River View    11353904   \n",
       "3720    2243699                SuperBowl Penthouse Loft 3,000 sqft    1483320   \n",
       "3774    2271504                   SUPER BOWL Brooklyn Duplex Apt!!   11598359   \n",
       "3788    2281142                 Prime NYC Location for Super Bowl     1427243   \n",
       "4345    2919330                   NearWilliamsburg bridge 11211 BK   14908606   \n",
       "4376    2952861                               Photography Location    1177497   \n",
       "4377    2953058                                      Film Location    1177497   \n",
       "6530    4737930                                 Spanish Harlem Apt    1235070   \n",
       "9151    7003697                Furnished room in Astoria apartment   20582832   \n",
       "12342   9528920                Quiet, Clean, Lit @ LES & Chinatown    3906464   \n",
       "15560  12520066                 Luxury townhouse Greenwich Village   66240032   \n",
       "17665  13882394        VIP Duplex Townhouse with Private Garden!!!   49186997   \n",
       "17692  13894339    Luxury 1 bedroom apt. -stunning Manhattan views    5143901   \n",
       "21821  17537893  The Otheroom Bar/Event/Filming Space -read det...   18037301   \n",
       "22353  18051877                            Victorian Film location    2675644   \n",
       "25825  20654227                                           Fulton 2  100069033   \n",
       "25901  20692563    Greenwich Village Townhome with Private Garden!  147814925   \n",
       "26739  21238053                                         Broadway 1  153497815   \n",
       "28946  22296097   Chelsea Gallery Space for events and exhibitions    3750764   \n",
       "28947  22296197   Chelsea Gallery for events, exhibitions, fashion    3750764   \n",
       "29238  22436899                                1-BR Lincoln Center   72390391   \n",
       "29662  22779726          East 72nd Townhouse by (Hidden by Airbnb)  156158778   \n",
       "29663  22779746          East 7th Street III by (Hidden by Airbnb)  156158778   \n",
       "29664  22780103          Park Avenue Mansion by (Hidden by Airbnb)  156158778   \n",
       "30268  23377410  Beautiful/Spacious 1 bed luxury flat-TriBeCa/Soho   18128455   \n",
       "34851  27629043             A Night at Anchor Aboard Yacht Ventura   45863742   \n",
       "37194  29547314               Apartment New York \\nHell’s Kitchens   35303743   \n",
       "37864  29964348                 NYC HOLIDAY!!!!   April 15- May 15    2039658   \n",
       "38000  30035166      4-Floor Unique Event Space 50P Cap. - #10299B  172611460   \n",
       "39243  30589636     Furnished 1000sq large 2bed + office in Harlem  229458601   \n",
       "40433  31340283  2br - The Heart of NYC: Manhattans Lower East ...    4382127   \n",
       "41216  32054910             West 88th Street by (Hidden by Airbnb)  156158778   \n",
       "42523  33007610                70' Luxury MotorYacht on the Hudson    7407743   \n",
       "42542  33029434             West 84th Street by (Hidden by Airbnb)  156158778   \n",
       "42736  33171891  30 days minimum Time square West Midtown apart...  177396569   \n",
       "43009  33397385    Midtown Manhattan great location (Gramacy park)   16105313   \n",
       "43670  33796251   Beautiful private Brooklyn room with kitchenette    8748976   \n",
       "44034  33998396                   3000 sq ft daylight photo studio    3750764   \n",
       "45666  34895693                               Gem of east Flatbush  262534951   \n",
       "45867  34981637        bay ridge & sunset park furnished apartment  263564234   \n",
       "46614  35345358                     Northside Williamsburg Stunner     956324   \n",
       "48043  36056808       Luxury TriBeCa Apartment at an amazing price  271248669   \n",
       "\n",
       "         host_name neighbourhood_group       neighbourhood  latitude  \\\n",
       "1862          Lucy            Brooklyn    Prospect Heights  40.67919   \n",
       "2698       Jessica           Manhattan              Nolita  40.72193   \n",
       "3537   Jay And Liz           Manhattan     Upper West Side  40.77782   \n",
       "3695          Todd           Manhattan     Upper West Side  40.79476   \n",
       "3720          Omri           Manhattan        Little Italy  40.71895   \n",
       "3774      Jonathan            Brooklyn        Clinton Hill  40.68766   \n",
       "3788       Jordana           Manhattan        East Village  40.73323   \n",
       "4345        Bianca            Brooklyn  Bedford-Stuyvesant  40.69572   \n",
       "4376       Jessica            Brooklyn        Clinton Hill  40.69127   \n",
       "4377       Jessica            Brooklyn        Clinton Hill  40.69137   \n",
       "6530         Olson           Manhattan         East Harlem  40.79264   \n",
       "9151      Kathrine              Queens             Astoria  40.76810   \n",
       "12342          Amy           Manhattan     Lower East Side  40.71355   \n",
       "15560        Linda           Manhattan   Greenwich Village  40.73046   \n",
       "17665       Joseph           Manhattan   Greenwich Village  40.73305   \n",
       "17692         Erin            Brooklyn          Greenpoint  40.73260   \n",
       "21821        James           Manhattan        West Village  40.73571   \n",
       "22353       Alissa       Staten Island       Randall Manor  40.63952   \n",
       "25825      Sarah-2            Brooklyn       Cypress Hills  40.68185   \n",
       "25901        Lloyd           Manhattan   Greenwich Village  40.73300   \n",
       "26739      Sarah-B            Brooklyn  Bedford-Stuyvesant  40.68742   \n",
       "28946        Kevin           Manhattan             Chelsea  40.74913   \n",
       "28947        Kevin           Manhattan             Chelsea  40.74888   \n",
       "29238       Jelena           Manhattan     Upper West Side  40.77213   \n",
       "29662        Sally           Manhattan     Upper East Side  40.76824   \n",
       "29663        Sally           Manhattan        East Village  40.72779   \n",
       "29664        Sally           Manhattan     Upper East Side  40.78517   \n",
       "30268          Rum           Manhattan             Tribeca  40.72197   \n",
       "34851        James           Manhattan   Battery Park City  40.71364   \n",
       "37194     Patricia           Manhattan     Upper West Side  40.76835   \n",
       "37864          Pam           Manhattan     Upper East Side  40.76519   \n",
       "38000       Rasmus           Manhattan              Harlem  40.82511   \n",
       "39243          Kay           Manhattan              Harlem  40.81315   \n",
       "40433         Matt           Manhattan     Lower East Side  40.71980   \n",
       "41216        Sally           Manhattan     Upper West Side  40.78742   \n",
       "42523         Jack           Manhattan   Battery Park City  40.71162   \n",
       "42542        Sally           Manhattan     Upper West Side  40.78545   \n",
       "42736       Yanina           Manhattan      Hell's Kitchen  40.76043   \n",
       "43009        Debra           Manhattan             Midtown  40.74482   \n",
       "43670      Jeffrey            Brooklyn  Bedford-Stuyvesant  40.68807   \n",
       "44034        Kevin           Manhattan             Chelsea  40.75060   \n",
       "45666       Sandra            Brooklyn       East Flatbush  40.65724   \n",
       "45867         Nony            Brooklyn           Bay Ridge  40.63087   \n",
       "46614         Alex            Brooklyn        Williamsburg  40.71705   \n",
       "48043        Jenny           Manhattan             Tribeca  40.71206   \n",
       "\n",
       "       longitude        room_type  price  minimum_nights  number_of_reviews  \\\n",
       "1862   -73.97191  Entire home/apt   4000               4                  0   \n",
       "2698   -73.99379  Entire home/apt   5000               1                  2   \n",
       "3537   -73.97848  Entire home/apt   6000              14                 17   \n",
       "3695   -73.97299  Entire home/apt   4000               1                  0   \n",
       "3720   -73.99793  Entire home/apt   5250               1                  0   \n",
       "3774   -73.96439  Entire home/apt   6500               1                  0   \n",
       "3788   -73.98859  Entire home/apt   3750               1                  0   \n",
       "4345   -73.95731     Private room   5000               6                 10   \n",
       "4376   -73.96563  Entire home/apt   4500               1                  5   \n",
       "4377   -73.96723  Entire home/apt   8000               1                  1   \n",
       "6530   -73.93898  Entire home/apt   9999               5                  1   \n",
       "9151   -73.91651     Private room  10000             100                  2   \n",
       "12342  -73.98507     Private room   9999              99                  6   \n",
       "15560  -73.99562  Entire home/apt   6000               1                  0   \n",
       "17665  -73.99373  Entire home/apt   3800              30                  2   \n",
       "17692  -73.95739  Entire home/apt  10000               5                  5   \n",
       "21821  -74.00780  Entire home/apt   4000               1                  0   \n",
       "22353  -74.09730  Entire home/apt   5000               1                  0   \n",
       "25825  -73.88128  Entire home/apt   5000               2                  4   \n",
       "25901  -73.99413  Entire home/apt   3900              30                  7   \n",
       "26739  -73.91957  Entire home/apt   5000               2                  8   \n",
       "28946  -74.00373     Private room   3210               1                  0   \n",
       "28947  -74.00481  Entire home/apt   4160               1                  0   \n",
       "29238  -73.98665  Entire home/apt  10000              30                  0   \n",
       "29662  -73.95989  Entire home/apt   7703               1                  0   \n",
       "29663  -73.98644  Entire home/apt   3518               1                  0   \n",
       "29664  -73.95270  Entire home/apt   6419               1                  0   \n",
       "30268  -74.00633  Entire home/apt   8500              30                  2   \n",
       "34851  -74.01758  Entire home/apt   3750               1                  0   \n",
       "37194  -73.98367     Private room   6500              30                  0   \n",
       "37864  -73.96874  Entire home/apt   3600              31                  0   \n",
       "38000  -73.94961  Entire home/apt   5000               1                  2   \n",
       "39243  -73.95110  Entire home/apt   3200              90                  0   \n",
       "40433  -73.98566  Entire home/apt   9999              30                  0   \n",
       "41216  -73.97011  Entire home/apt   3512               1                  0   \n",
       "42523  -74.01693  Entire home/apt   7500               1                  0   \n",
       "42542  -73.97123  Entire home/apt   3613               1                  1   \n",
       "42736  -73.99132  Entire home/apt   4100              30                  0   \n",
       "43009  -73.98367  Entire home/apt   5100              30                  1   \n",
       "43670  -73.95426     Private room   4200             114                  0   \n",
       "44034  -74.00388  Entire home/apt   6800               1                  0   \n",
       "45666  -73.92450     Private room   7500               1                  8   \n",
       "45867  -74.02006  Entire home/apt   4200              60                  0   \n",
       "46614  -73.96470  Entire home/apt   4500              30                  0   \n",
       "48043  -74.00999  Entire home/apt   6500             180                  0   \n",
       "\n",
       "      last_review  reviews_per_month  calculated_host_listings_count  \\\n",
       "1862          NaN                NaN                               1   \n",
       "2698   2013-09-28               0.03                               1   \n",
       "3537   2015-02-17               0.27                               1   \n",
       "3695          NaN                NaN                               1   \n",
       "3720          NaN                NaN                               1   \n",
       "3774          NaN                NaN                               1   \n",
       "3788          NaN                NaN                               1   \n",
       "4345   2016-01-02               0.16                               1   \n",
       "4376   2018-12-29               0.09                              11   \n",
       "4377   2016-09-15               0.03                              11   \n",
       "6530   2015-01-02               0.02                               1   \n",
       "9151   2016-02-13               0.04                               1   \n",
       "12342  2016-01-01               0.14                               1   \n",
       "15560         NaN                NaN                               1   \n",
       "17665  2017-01-27               0.06                               1   \n",
       "17692  2017-07-27               0.16                               1   \n",
       "21821         NaN                NaN                               1   \n",
       "22353         NaN                NaN                               1   \n",
       "25825  2018-01-03               0.18                               1   \n",
       "25901  2018-03-13               0.32                               1   \n",
       "26739  2017-12-09               0.38                               1   \n",
       "28946         NaN                NaN                               6   \n",
       "28947         NaN                NaN                               6   \n",
       "29238         NaN                NaN                               1   \n",
       "29662         NaN                NaN                              12   \n",
       "29663         NaN                NaN                              12   \n",
       "29664         NaN                NaN                              12   \n",
       "30268  2018-09-18               0.18                               1   \n",
       "34851         NaN                NaN                               1   \n",
       "37194         NaN                NaN                               1   \n",
       "37864         NaN                NaN                               1   \n",
       "38000  2019-02-23               0.38                               2   \n",
       "39243         NaN                NaN                               1   \n",
       "40433         NaN                NaN                               1   \n",
       "41216         NaN                NaN                              12   \n",
       "42523         NaN                NaN                               1   \n",
       "42542  2019-06-15               1.00                              12   \n",
       "42736         NaN                NaN                               3   \n",
       "43009  2019-06-22               1.00                               2   \n",
       "43670         NaN                NaN                               1   \n",
       "44034         NaN                NaN                               6   \n",
       "45666  2019-07-07               6.15                               2   \n",
       "45867         NaN                NaN                               1   \n",
       "46614         NaN                NaN                               1   \n",
       "48043         NaN                NaN                               1   \n",
       "\n",
       "       availability_365  \n",
       "1862                 83  \n",
       "2698                365  \n",
       "3537                359  \n",
       "3695                  0  \n",
       "3720                  0  \n",
       "3774                  0  \n",
       "3788                  0  \n",
       "4345                363  \n",
       "4376                365  \n",
       "4377                365  \n",
       "6530                  0  \n",
       "9151                  0  \n",
       "12342                83  \n",
       "15560                 0  \n",
       "17665               180  \n",
       "17692                 0  \n",
       "21821               173  \n",
       "22353               344  \n",
       "25825                 0  \n",
       "25901               180  \n",
       "26739                 0  \n",
       "28946               364  \n",
       "28947               364  \n",
       "29238                83  \n",
       "29662               146  \n",
       "29663               215  \n",
       "29664                45  \n",
       "30268               251  \n",
       "34851               365  \n",
       "37194                97  \n",
       "37864               358  \n",
       "38000               150  \n",
       "39243               365  \n",
       "40433               365  \n",
       "41216               124  \n",
       "42523               364  \n",
       "42542               158  \n",
       "42736               180  \n",
       "43009               343  \n",
       "43670               347  \n",
       "44034               364  \n",
       "45666               179  \n",
       "45867                90  \n",
       "46614               365  \n",
       "48043               365  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df.price > max_thresold]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "2ad02881",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(48183, 16)"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2 = df[(df.price > min_thresold) & (df.price < max_thresold)]\n",
    "df2.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "a650b739",
   "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>id</th>\n",
       "      <th>name</th>\n",
       "      <th>host_id</th>\n",
       "      <th>host_name</th>\n",
       "      <th>neighbourhood_group</th>\n",
       "      <th>neighbourhood</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>room_type</th>\n",
       "      <th>price</th>\n",
       "      <th>minimum_nights</th>\n",
       "      <th>number_of_reviews</th>\n",
       "      <th>last_review</th>\n",
       "      <th>reviews_per_month</th>\n",
       "      <th>calculated_host_listings_count</th>\n",
       "      <th>availability_365</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2539</td>\n",
       "      <td>Clean &amp; quiet apt home by the park</td>\n",
       "      <td>2787</td>\n",
       "      <td>John</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Kensington</td>\n",
       "      <td>40.64749</td>\n",
       "      <td>-73.97237</td>\n",
       "      <td>Private room</td>\n",
       "      <td>149</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>2018-10-19</td>\n",
       "      <td>0.21</td>\n",
       "      <td>6</td>\n",
       "      <td>365</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2595</td>\n",
       "      <td>Skylit Midtown Castle</td>\n",
       "      <td>2845</td>\n",
       "      <td>Jennifer</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Midtown</td>\n",
       "      <td>40.75362</td>\n",
       "      <td>-73.98377</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>225</td>\n",
       "      <td>1</td>\n",
       "      <td>45</td>\n",
       "      <td>2019-05-21</td>\n",
       "      <td>0.38</td>\n",
       "      <td>2</td>\n",
       "      <td>355</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3647</td>\n",
       "      <td>THE VILLAGE OF HARLEM....NEW YORK !</td>\n",
       "      <td>4632</td>\n",
       "      <td>Elisabeth</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Harlem</td>\n",
       "      <td>40.80902</td>\n",
       "      <td>-73.94190</td>\n",
       "      <td>Private room</td>\n",
       "      <td>150</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>365</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3831</td>\n",
       "      <td>Cozy Entire Floor of Brownstone</td>\n",
       "      <td>4869</td>\n",
       "      <td>LisaRoxanne</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Clinton Hill</td>\n",
       "      <td>40.68514</td>\n",
       "      <td>-73.95976</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>89</td>\n",
       "      <td>1</td>\n",
       "      <td>270</td>\n",
       "      <td>2019-07-05</td>\n",
       "      <td>4.64</td>\n",
       "      <td>1</td>\n",
       "      <td>194</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5022</td>\n",
       "      <td>Entire Apt: Spacious Studio/Loft by central park</td>\n",
       "      <td>7192</td>\n",
       "      <td>Laura</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>East Harlem</td>\n",
       "      <td>40.79851</td>\n",
       "      <td>-73.94399</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>80</td>\n",
       "      <td>10</td>\n",
       "      <td>9</td>\n",
       "      <td>2018-11-19</td>\n",
       "      <td>0.10</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     id                                              name  host_id  \\\n",
       "0  2539                Clean & quiet apt home by the park     2787   \n",
       "1  2595                             Skylit Midtown Castle     2845   \n",
       "2  3647               THE VILLAGE OF HARLEM....NEW YORK !     4632   \n",
       "3  3831                   Cozy Entire Floor of Brownstone     4869   \n",
       "4  5022  Entire Apt: Spacious Studio/Loft by central park     7192   \n",
       "\n",
       "     host_name neighbourhood_group neighbourhood  latitude  longitude  \\\n",
       "0         John            Brooklyn    Kensington  40.64749  -73.97237   \n",
       "1     Jennifer           Manhattan       Midtown  40.75362  -73.98377   \n",
       "2    Elisabeth           Manhattan        Harlem  40.80902  -73.94190   \n",
       "3  LisaRoxanne            Brooklyn  Clinton Hill  40.68514  -73.95976   \n",
       "4        Laura           Manhattan   East Harlem  40.79851  -73.94399   \n",
       "\n",
       "         room_type  price  minimum_nights  number_of_reviews last_review  \\\n",
       "0     Private room    149               1                  9  2018-10-19   \n",
       "1  Entire home/apt    225               1                 45  2019-05-21   \n",
       "2     Private room    150               3                  0         NaN   \n",
       "3  Entire home/apt     89               1                270  2019-07-05   \n",
       "4  Entire home/apt     80              10                  9  2018-11-19   \n",
       "\n",
       "   reviews_per_month  calculated_host_listings_count  availability_365  \n",
       "0               0.21                               6               365  \n",
       "1               0.38                               2               355  \n",
       "2                NaN                               1               365  \n",
       "3               4.64                               1               194  \n",
       "4               0.10                               1                 0  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "d5e6ef9d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "count    48183.000000\n",
       "mean       148.772036\n",
       "std        153.594795\n",
       "min         31.000000\n",
       "25%         70.000000\n",
       "50%        110.000000\n",
       "75%        179.000000\n",
       "max       2999.000000\n",
       "Name: price, dtype: float64"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2.price.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "3bb37e1e",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Outlier indices: (array([], dtype=int64),)\n"
     ]
    }
   ],
   "source": [
    "import numpy as np\n",
    "\n",
    "def detect_outliers_zscore(data, threshold=3):\n",
    "    mean = np.mean(data)\n",
    "    std = np.std(data)\n",
    "    z_scores = (data - mean) / std\n",
    "    outliers = np.where(np.abs(z_scores) > threshold)\n",
    "    return outliers\n",
    "\n",
    "# Example usage\n",
    "data = np.array([148.772036, 153.594795, 31.000000, 70.000000, 110.000000, 179.000000, 2999.000000])\n",
    "outliers = detect_outliers_zscore(data)\n",
    "print(\"Outlier indices:\", outliers)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}