rental_market.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# **Tourist Rental Market Analysis**"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Focus**: Find the types of properties that have the best potential for vacation rentals."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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",
       "      <th>number_of_reviews_ltm</th>\n",
       "      <th>license</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>21853</td>\n",
       "      <td>Bright and airy room</td>\n",
       "      <td>83531</td>\n",
       "      <td>Abdel</td>\n",
       "      <td>Latina</td>\n",
       "      <td>Cármenes</td>\n",
       "      <td>40.40381</td>\n",
       "      <td>-3.74130</td>\n",
       "      <td>Private room</td>\n",
       "      <td>31.0</td>\n",
       "      <td>4</td>\n",
       "      <td>33</td>\n",
       "      <td>2018-07-15</td>\n",
       "      <td>0.28</td>\n",
       "      <td>2</td>\n",
       "      <td>83</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>24805</td>\n",
       "      <td>Gran Via Studio Madrid</td>\n",
       "      <td>346366726</td>\n",
       "      <td>Alvaro</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Universidad</td>\n",
       "      <td>40.42183</td>\n",
       "      <td>-3.70529</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>104.0</td>\n",
       "      <td>5</td>\n",
       "      <td>43</td>\n",
       "      <td>2024-06-01</td>\n",
       "      <td>0.37</td>\n",
       "      <td>1</td>\n",
       "      <td>113</td>\n",
       "      <td>13</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>40718</td>\n",
       "      <td>COZY APARTMENT CIBELES-GRAN VIA-PTA DEL SOL-CH...</td>\n",
       "      <td>34217435</td>\n",
       "      <td>Luis</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Justicia</td>\n",
       "      <td>40.41969</td>\n",
       "      <td>-3.69736</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>114.0</td>\n",
       "      <td>2</td>\n",
       "      <td>150</td>\n",
       "      <td>2024-05-30</td>\n",
       "      <td>0.89</td>\n",
       "      <td>15</td>\n",
       "      <td>310</td>\n",
       "      <td>20</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>40916</td>\n",
       "      <td>Holiday Apartment Madrid Center</td>\n",
       "      <td>130907</td>\n",
       "      <td>Dana</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Universidad</td>\n",
       "      <td>40.42247</td>\n",
       "      <td>-3.70577</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5</td>\n",
       "      <td>49</td>\n",
       "      <td>2021-12-11</td>\n",
       "      <td>0.30</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>30320</td>\n",
       "      <td>Great Vacational Apartments</td>\n",
       "      <td>130907</td>\n",
       "      <td>Dana</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Sol</td>\n",
       "      <td>40.41476</td>\n",
       "      <td>-3.70418</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5</td>\n",
       "      <td>172</td>\n",
       "      <td>2022-09-26</td>\n",
       "      <td>1.01</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      id                                               name    host_id  \\\n",
       "0  21853                               Bright and airy room      83531   \n",
       "1  24805                             Gran Via Studio Madrid  346366726   \n",
       "2  40718  COZY APARTMENT CIBELES-GRAN VIA-PTA DEL SOL-CH...   34217435   \n",
       "3  40916                    Holiday Apartment Madrid Center     130907   \n",
       "4  30320                        Great Vacational Apartments     130907   \n",
       "\n",
       "  host_name neighbourhood_group neighbourhood  latitude  longitude  \\\n",
       "0     Abdel              Latina      Cármenes  40.40381   -3.74130   \n",
       "1    Alvaro              Centro   Universidad  40.42183   -3.70529   \n",
       "2      Luis              Centro      Justicia  40.41969   -3.69736   \n",
       "3      Dana              Centro   Universidad  40.42247   -3.70577   \n",
       "4      Dana              Centro           Sol  40.41476   -3.70418   \n",
       "\n",
       "         room_type  price  minimum_nights  number_of_reviews last_review  \\\n",
       "0     Private room   31.0               4                 33  2018-07-15   \n",
       "1  Entire home/apt  104.0               5                 43  2024-06-01   \n",
       "2  Entire home/apt  114.0               2                150  2024-05-30   \n",
       "3  Entire home/apt    NaN               5                 49  2021-12-11   \n",
       "4  Entire home/apt    NaN               5                172  2022-09-26   \n",
       "\n",
       "   reviews_per_month  calculated_host_listings_count  availability_365  \\\n",
       "0               0.28                               2                83   \n",
       "1               0.37                               1               113   \n",
       "2               0.89                              15               310   \n",
       "3               0.30                               3                 0   \n",
       "4               1.01                               3                 0   \n",
       "\n",
       "   number_of_reviews_ltm license  \n",
       "0                      0     NaN  \n",
       "1                     13     NaN  \n",
       "2                     20     NaN  \n",
       "3                      0     NaN  \n",
       "4                      0     NaN  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "listings = pd.read_csv(\"Data/listings.csv\")\n",
    "listings.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 26924 entries, 0 to 26923\n",
      "Data columns (total 18 columns):\n",
      " #   Column                          Non-Null Count  Dtype  \n",
      "---  ------                          --------------  -----  \n",
      " 0   id                              26924 non-null  int64  \n",
      " 1   name                            26924 non-null  object \n",
      " 2   host_id                         26924 non-null  int64  \n",
      " 3   host_name                       26920 non-null  object \n",
      " 4   neighbourhood_group             26924 non-null  object \n",
      " 5   neighbourhood                   26924 non-null  object \n",
      " 6   latitude                        26924 non-null  float64\n",
      " 7   longitude                       26924 non-null  float64\n",
      " 8   room_type                       26924 non-null  object \n",
      " 9   price                           21620 non-null  float64\n",
      " 10  minimum_nights                  26924 non-null  int64  \n",
      " 11  number_of_reviews               26924 non-null  int64  \n",
      " 12  last_review                     21068 non-null  object \n",
      " 13  reviews_per_month               21068 non-null  float64\n",
      " 14  calculated_host_listings_count  26924 non-null  int64  \n",
      " 15  availability_365                26924 non-null  int64  \n",
      " 16  number_of_reviews_ltm           26924 non-null  int64  \n",
      " 17  license                         2742 non-null   object \n",
      "dtypes: float64(4), int64(7), object(7)\n",
      "memory usage: 3.7+ MB\n"
     ]
    }
   ],
   "source": [
    "listings.info()"
   ]
  },
  {
   "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>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",
       "      <th>number_of_reviews_ltm</th>\n",
       "      <th>license</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>21853</td>\n",
       "      <td>Bright and airy room</td>\n",
       "      <td>83531</td>\n",
       "      <td>Abdel</td>\n",
       "      <td>Latina</td>\n",
       "      <td>Cármenes</td>\n",
       "      <td>40.40381</td>\n",
       "      <td>-3.74130</td>\n",
       "      <td>Private room</td>\n",
       "      <td>31.0</td>\n",
       "      <td>4</td>\n",
       "      <td>33</td>\n",
       "      <td>2018-07-15</td>\n",
       "      <td>0.28</td>\n",
       "      <td>2</td>\n",
       "      <td>83</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>24805</td>\n",
       "      <td>Gran Via Studio Madrid</td>\n",
       "      <td>346366726</td>\n",
       "      <td>Alvaro</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Universidad</td>\n",
       "      <td>40.42183</td>\n",
       "      <td>-3.70529</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>104.0</td>\n",
       "      <td>5</td>\n",
       "      <td>43</td>\n",
       "      <td>2024-06-01</td>\n",
       "      <td>0.37</td>\n",
       "      <td>1</td>\n",
       "      <td>113</td>\n",
       "      <td>13</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>40718</td>\n",
       "      <td>COZY APARTMENT CIBELES-GRAN VIA-PTA DEL SOL-CH...</td>\n",
       "      <td>34217435</td>\n",
       "      <td>Luis</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Justicia</td>\n",
       "      <td>40.41969</td>\n",
       "      <td>-3.69736</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>114.0</td>\n",
       "      <td>2</td>\n",
       "      <td>150</td>\n",
       "      <td>2024-05-30</td>\n",
       "      <td>0.89</td>\n",
       "      <td>15</td>\n",
       "      <td>310</td>\n",
       "      <td>20</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>40916</td>\n",
       "      <td>Holiday Apartment Madrid Center</td>\n",
       "      <td>130907</td>\n",
       "      <td>Dana</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Universidad</td>\n",
       "      <td>40.42247</td>\n",
       "      <td>-3.70577</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5</td>\n",
       "      <td>49</td>\n",
       "      <td>2021-12-11</td>\n",
       "      <td>0.30</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>30320</td>\n",
       "      <td>Great Vacational Apartments</td>\n",
       "      <td>130907</td>\n",
       "      <td>Dana</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Sol</td>\n",
       "      <td>40.41476</td>\n",
       "      <td>-3.70418</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5</td>\n",
       "      <td>172</td>\n",
       "      <td>2022-09-26</td>\n",
       "      <td>1.01</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      id                                               name    host_id  \\\n",
       "0  21853                               Bright and airy room      83531   \n",
       "1  24805                             Gran Via Studio Madrid  346366726   \n",
       "2  40718  COZY APARTMENT CIBELES-GRAN VIA-PTA DEL SOL-CH...   34217435   \n",
       "3  40916                    Holiday Apartment Madrid Center     130907   \n",
       "4  30320                        Great Vacational Apartments     130907   \n",
       "\n",
       "  host_name neighbourhood_group neighbourhood  latitude  longitude  \\\n",
       "0     Abdel              Latina      Cármenes  40.40381   -3.74130   \n",
       "1    Alvaro              Centro   Universidad  40.42183   -3.70529   \n",
       "2      Luis              Centro      Justicia  40.41969   -3.69736   \n",
       "3      Dana              Centro   Universidad  40.42247   -3.70577   \n",
       "4      Dana              Centro           Sol  40.41476   -3.70418   \n",
       "\n",
       "         room_type  price  minimum_nights  number_of_reviews last_review  \\\n",
       "0     Private room   31.0               4                 33  2018-07-15   \n",
       "1  Entire home/apt  104.0               5                 43  2024-06-01   \n",
       "2  Entire home/apt  114.0               2                150  2024-05-30   \n",
       "3  Entire home/apt    NaN               5                 49  2021-12-11   \n",
       "4  Entire home/apt    NaN               5                172  2022-09-26   \n",
       "\n",
       "   reviews_per_month  calculated_host_listings_count  availability_365  \\\n",
       "0               0.28                               2                83   \n",
       "1               0.37                               1               113   \n",
       "2               0.89                              15               310   \n",
       "3               0.30                               3                 0   \n",
       "4               1.01                               3                 0   \n",
       "\n",
       "   number_of_reviews_ltm license  \n",
       "0                      0     NaN  \n",
       "1                     13     NaN  \n",
       "2                     20     NaN  \n",
       "3                      0     NaN  \n",
       "4                      0     NaN  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "listings_det = pd.read_csv('Data/listings.csv.gz', compression='gzip')\n",
    "listings.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 26924 entries, 0 to 26923\n",
      "Data columns (total 75 columns):\n",
      " #   Column                                        Non-Null Count  Dtype  \n",
      "---  ------                                        --------------  -----  \n",
      " 0   id                                            26924 non-null  int64  \n",
      " 1   listing_url                                   26924 non-null  object \n",
      " 2   scrape_id                                     26924 non-null  int64  \n",
      " 3   last_scraped                                  26924 non-null  object \n",
      " 4   source                                        26924 non-null  object \n",
      " 5   name                                          26924 non-null  object \n",
      " 6   description                                   25958 non-null  object \n",
      " 7   neighborhood_overview                         13306 non-null  object \n",
      " 8   picture_url                                   26922 non-null  object \n",
      " 9   host_id                                       26924 non-null  int64  \n",
      " 10  host_url                                      26924 non-null  object \n",
      " 11  host_name                                     26920 non-null  object \n",
      " 12  host_since                                    26920 non-null  object \n",
      " 13  host_location                                 18508 non-null  object \n",
      " 14  host_about                                    12979 non-null  object \n",
      " 15  host_response_time                            22009 non-null  object \n",
      " 16  host_response_rate                            22009 non-null  object \n",
      " 17  host_acceptance_rate                          22907 non-null  object \n",
      " 18  host_is_superhost                             26769 non-null  object \n",
      " 19  host_thumbnail_url                            26920 non-null  object \n",
      " 20  host_picture_url                              26920 non-null  object \n",
      " 21  host_neighbourhood                            9720 non-null   object \n",
      " 22  host_listings_count                           26920 non-null  float64\n",
      " 23  host_total_listings_count                     26920 non-null  float64\n",
      " 24  host_verifications                            26920 non-null  object \n",
      " 25  host_has_profile_pic                          26920 non-null  object \n",
      " 26  host_identity_verified                        26920 non-null  object \n",
      " 27  neighbourhood                                 13306 non-null  object \n",
      " 28  neighbourhood_cleansed                        26924 non-null  object \n",
      " 29  neighbourhood_group_cleansed                  26924 non-null  object \n",
      " 30  latitude                                      26924 non-null  float64\n",
      " 31  longitude                                     26924 non-null  float64\n",
      " 32  property_type                                 26924 non-null  object \n",
      " 33  room_type                                     26924 non-null  object \n",
      " 34  accommodates                                  26924 non-null  int64  \n",
      " 35  bathrooms                                     21598 non-null  float64\n",
      " 36  bathrooms_text                                26888 non-null  object \n",
      " 37  bedrooms                                      24712 non-null  float64\n",
      " 38  beds                                          21565 non-null  float64\n",
      " 39  amenities                                     26924 non-null  object \n",
      " 40  price                                         21620 non-null  object \n",
      " 41  minimum_nights                                26924 non-null  int64  \n",
      " 42  maximum_nights                                26924 non-null  int64  \n",
      " 43  minimum_minimum_nights                        26924 non-null  int64  \n",
      " 44  maximum_minimum_nights                        26924 non-null  int64  \n",
      " 45  minimum_maximum_nights                        26924 non-null  int64  \n",
      " 46  maximum_maximum_nights                        26924 non-null  int64  \n",
      " 47  minimum_nights_avg_ntm                        26924 non-null  float64\n",
      " 48  maximum_nights_avg_ntm                        26924 non-null  float64\n",
      " 49  calendar_updated                              0 non-null      float64\n",
      " 50  has_availability                              25388 non-null  object \n",
      " 51  availability_30                               26924 non-null  int64  \n",
      " 52  availability_60                               26924 non-null  int64  \n",
      " 53  availability_90                               26924 non-null  int64  \n",
      " 54  availability_365                              26924 non-null  int64  \n",
      " 55  calendar_last_scraped                         26924 non-null  object \n",
      " 56  number_of_reviews                             26924 non-null  int64  \n",
      " 57  number_of_reviews_ltm                         26924 non-null  int64  \n",
      " 58  number_of_reviews_l30d                        26924 non-null  int64  \n",
      " 59  first_review                                  21068 non-null  object \n",
      " 60  last_review                                   21068 non-null  object \n",
      " 61  review_scores_rating                          21068 non-null  float64\n",
      " 62  review_scores_accuracy                        21027 non-null  float64\n",
      " 63  review_scores_cleanliness                     21026 non-null  float64\n",
      " 64  review_scores_checkin                         21026 non-null  float64\n",
      " 65  review_scores_communication                   21027 non-null  float64\n",
      " 66  review_scores_location                        21024 non-null  float64\n",
      " 67  review_scores_value                           21023 non-null  float64\n",
      " 68  license                                       2742 non-null   object \n",
      " 69  instant_bookable                              26924 non-null  object \n",
      " 70  calculated_host_listings_count                26924 non-null  int64  \n",
      " 71  calculated_host_listings_count_entire_homes   26924 non-null  int64  \n",
      " 72  calculated_host_listings_count_private_rooms  26924 non-null  int64  \n",
      " 73  calculated_host_listings_count_shared_rooms   26924 non-null  int64  \n",
      " 74  reviews_per_month                             21068 non-null  float64\n",
      "dtypes: float64(18), int64(21), object(36)\n",
      "memory usage: 15.4+ MB\n"
     ]
    }
   ],
   "source": [
    "listings_det.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Reviews"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "   listing_id        date\n",
      "0       21853  2014-10-10\n",
      "1       21853  2014-10-13\n",
      "2       21853  2014-11-09\n",
      "3       21853  2014-11-11\n",
      "4       21853  2014-11-16\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 1189990 entries, 0 to 1189989\n",
      "Data columns (total 2 columns):\n",
      " #   Column      Non-Null Count    Dtype \n",
      "---  ------      --------------    ----- \n",
      " 0   listing_id  1189990 non-null  int64 \n",
      " 1   date        1189990 non-null  object\n",
      "dtypes: int64(1), object(1)\n",
      "memory usage: 18.2+ MB\n",
      "None\n"
     ]
    }
   ],
   "source": [
    "reviews = pd.read_csv('Data/reviews.csv')\n",
    "print(reviews.head())\n",
    "print(reviews.info())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "import sqlalchemy as sa\n",
    "import pyodbc\n",
    "import pandas as pd\n",
    "from sqlalchemy.engine import URL"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Datos cargados exitosamente en SQL Server.\n"
     ]
    }
   ],
   "source": [
    "# Configuración de la conexión\n",
    "server = \"DESKTOP-KF977R7\"  # Reemplace con el nombre de su servidor\n",
    "database = \"RentalMKT\"  # Reemplace con el nombre de su base de datos\n",
    "\n",
    "# URL conexion with Windows authentication\n",
    "connection_url = URL.create(\n",
    "    \"mssql+pyodbc\",\n",
    "    username=\"\",  \n",
    "    password=\"\",  \n",
    "    host=server,\n",
    "    database=database,\n",
    "    query={\n",
    "        \"driver\": \"ODBC Driver 17 for SQL Server\",\n",
    "        \"TrustServerCertificate\": \"yes\",\n",
    "        \"authentication\": \"ActiveDirectoryIntegrated\",\n",
    "    },\n",
    ")\n",
    "\n",
    "engine = sa.create_engine(connection_url)\n",
    "\n",
    "#listings.to_sql('listings', con=engine, if_exists='replace', index=False)\n",
    "#listings_det.to_sql('listings_det', con=engine, if_exists='replace', index=False)\n",
    "\n",
    "print(\"Datos cargados exitosamente en SQL Server.\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sqlalchemy import inspect"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['listings', 'listings_det']\n"
     ]
    }
   ],
   "source": [
    "insp = inspect(engine)\n",
    "tables = insp.get_table_names()\n",
    "print(tables)\n",
    "\n",
    "listings = pd.read_sql('listings', engine)\n",
    "listings_det = pd.read_sql('listings_det', engine)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "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>table__cell</th>\n",
       "      <th>table__cell 2</th>\n",
       "      <th>table__cell 3</th>\n",
       "      <th>table__cell 4</th>\n",
       "      <th>table__cell 5</th>\n",
       "      <th>table__cell 6</th>\n",
       "      <th>table__cell 7</th>\n",
       "      <th>icon-elbow</th>\n",
       "      <th>icon-elbow href</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Madrid</td>\n",
       "      <td>4.622 €/m2</td>\n",
       "      <td>+ 2,4 %</td>\n",
       "      <td>+ 5,1 %</td>\n",
       "      <td>+ 15,5 %</td>\n",
       "      <td>4.622 €/m2 jul 2024</td>\n",
       "      <td>0,0 %</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NaN</td>\n",
       "      <td>4.957 €/m2</td>\n",
       "      <td>+ 2,2 %</td>\n",
       "      <td>+ 7,1 %</td>\n",
       "      <td>+ 11,4 %</td>\n",
       "      <td>4.957 €/m2 jul 2024</td>\n",
       "      <td>0,0 %</td>\n",
       "      <td>Arganzuela</td>\n",
       "      <td>https://www.idealista.com/sala-de-prensa/infor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NaN</td>\n",
       "      <td>3.727 €/m2</td>\n",
       "      <td>+ 1,1 %</td>\n",
       "      <td>+ 3,3 %</td>\n",
       "      <td>+ 6,4 %</td>\n",
       "      <td>3.727 €/m2 jul 2024</td>\n",
       "      <td>0,0 %</td>\n",
       "      <td>Barajas</td>\n",
       "      <td>https://www.idealista.com/sala-de-prensa/infor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>- 14,0 %</td>\n",
       "      <td>2.730 €/m2</td>\n",
       "      <td>+ 0,7 %</td>\n",
       "      <td>+ 4,0 %</td>\n",
       "      <td>+ 11,3 %</td>\n",
       "      <td>3.173 €/m2 jun 2007</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Carabanchel</td>\n",
       "      <td>https://www.idealista.com/sala-de-prensa/infor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0,0 %</td>\n",
       "      <td>6.223 €/m2</td>\n",
       "      <td>+ 0,9 %</td>\n",
       "      <td>+ 16,1 %</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0,0 %</td>\n",
       "      <td>6.223 €/m2 jul 2024</td>\n",
       "      <td>Centro</td>\n",
       "      <td>https://www.idealista.com/sala-de-prensa/infor...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  table__cell table__cell 2 table__cell 3 table__cell 4 table__cell 5  \\\n",
       "0      Madrid    4.622 €/m2       + 2,4 %       + 5,1 %      + 15,5 %   \n",
       "1         NaN    4.957 €/m2       + 2,2 %       + 7,1 %      + 11,4 %   \n",
       "2         NaN    3.727 €/m2       + 1,1 %       + 3,3 %       + 6,4 %   \n",
       "3    - 14,0 %    2.730 €/m2       + 0,7 %       + 4,0 %      + 11,3 %   \n",
       "4       0,0 %    6.223 €/m2       + 0,9 %      + 16,1 %           NaN   \n",
       "\n",
       "         table__cell 6        table__cell 7   icon-elbow  \\\n",
       "0  4.622 €/m2 jul 2024                0,0 %          NaN   \n",
       "1  4.957 €/m2 jul 2024                0,0 %   Arganzuela   \n",
       "2  3.727 €/m2 jul 2024                0,0 %      Barajas   \n",
       "3  3.173 €/m2 jun 2007                  NaN  Carabanchel   \n",
       "4                0,0 %  6.223 €/m2 jul 2024       Centro   \n",
       "\n",
       "                                     icon-elbow href  \n",
       "0                                                NaN  \n",
       "1  https://www.idealista.com/sala-de-prensa/infor...  \n",
       "2  https://www.idealista.com/sala-de-prensa/infor...  \n",
       "3  https://www.idealista.com/sala-de-prensa/infor...  \n",
       "4  https://www.idealista.com/sala-de-prensa/infor...  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "price_df = pd.read_csv('Data/precios_idealista.csv')\n",
    "price_df.head()"
   ]
  },
  {
   "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>price_m2</th>\n",
       "      <th>district</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4622</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4957</td>\n",
       "      <td>Arganzuela</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3727</td>\n",
       "      <td>Barajas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2730</td>\n",
       "      <td>Carabanchel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>6223</td>\n",
       "      <td>Centro</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6389</td>\n",
       "      <td>Chamartín</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6848</td>\n",
       "      <td>Chamberí</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>3752</td>\n",
       "      <td>Ciudad Lineal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>4036</td>\n",
       "      <td>Fuencarral</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>4420</td>\n",
       "      <td>Hortaleza</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2824</td>\n",
       "      <td>Latina</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>4904</td>\n",
       "      <td>Moncloa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>3150</td>\n",
       "      <td>Moratalaz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2375</td>\n",
       "      <td>Puente de Vallecas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>5780</td>\n",
       "      <td>Retiro</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>7990</td>\n",
       "      <td>Salamanca</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>3027</td>\n",
       "      <td>San Blas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>4600</td>\n",
       "      <td>Tetuán</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2558</td>\n",
       "      <td>Usera</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2989</td>\n",
       "      <td>Vicálvaro</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2873</td>\n",
       "      <td>Villa de Vallecas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2090</td>\n",
       "      <td>Villaverde</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    price_m2            district\n",
       "0       4622                 NaN\n",
       "1       4957          Arganzuela\n",
       "2       3727             Barajas\n",
       "3       2730         Carabanchel\n",
       "4       6223              Centro\n",
       "5       6389           Chamartín\n",
       "6       6848            Chamberí\n",
       "7       3752       Ciudad Lineal\n",
       "8       4036          Fuencarral\n",
       "9       4420           Hortaleza\n",
       "10      2824              Latina\n",
       "11      4904             Moncloa\n",
       "12      3150           Moratalaz\n",
       "13      2375  Puente de Vallecas\n",
       "14      5780              Retiro\n",
       "15      7990           Salamanca\n",
       "16      3027            San Blas\n",
       "17      4600              Tetuán\n",
       "18      2558               Usera\n",
       "19      2989           Vicálvaro\n",
       "20      2873   Villa de Vallecas\n",
       "21      2090          Villaverde"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "price_m2 = price_df[['table__cell 2','icon-elbow']]\\\n",
    "    .rename(\n",
    "        columns={'table__cell 2': 'price_m2','icon-elbow':'district'}\n",
    "    )\n",
    "price_m2['price_m2'] = price_m2.price_m2.str.split(expand = True)[0].str.replace('.','',regex=False).astype('int')\n",
    "price_m2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [],
   "source": [
    "to_eliminate = [\n",
    "    'id',\n",
    "    'host_name',\n",
    "    'number_of_reviews',\n",
    "    'last_review',\n",
    "    'reviews_per_month',\n",
    "    'number_of_reviews_ltm',\n",
    "    'license'\n",
    "]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>host_id</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>calculated_host_listings_count</th>\n",
       "      <th>availability_365</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Bright and airy room</td>\n",
       "      <td>83531</td>\n",
       "      <td>Latina</td>\n",
       "      <td>Cármenes</td>\n",
       "      <td>40.403810</td>\n",
       "      <td>-3.741300</td>\n",
       "      <td>Private room</td>\n",
       "      <td>31.0</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Gran Via Studio Madrid</td>\n",
       "      <td>346366726</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Universidad</td>\n",
       "      <td>40.421830</td>\n",
       "      <td>-3.705290</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>104.0</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>113</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>COZY APARTMENT CIBELES-GRAN VIA-PTA DEL SOL-CH...</td>\n",
       "      <td>34217435</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Justicia</td>\n",
       "      <td>40.419690</td>\n",
       "      <td>-3.697360</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>114.0</td>\n",
       "      <td>2</td>\n",
       "      <td>15</td>\n",
       "      <td>310</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Holiday Apartment Madrid Center</td>\n",
       "      <td>130907</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Universidad</td>\n",
       "      <td>40.422470</td>\n",
       "      <td>-3.705770</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Great Vacational Apartments</td>\n",
       "      <td>130907</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Sol</td>\n",
       "      <td>40.414760</td>\n",
       "      <td>-3.704180</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26919</th>\n",
       "      <td>Cozy studio in Chamberí</td>\n",
       "      <td>528979463</td>\n",
       "      <td>Chamberí</td>\n",
       "      <td>Gaztambide</td>\n",
       "      <td>40.433240</td>\n",
       "      <td>-3.712420</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>146.0</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26920</th>\n",
       "      <td>habitación cálida</td>\n",
       "      <td>583336078</td>\n",
       "      <td>Puente de Vallecas</td>\n",
       "      <td>Numancia</td>\n",
       "      <td>40.398327</td>\n",
       "      <td>-3.654305</td>\n",
       "      <td>Private room</td>\n",
       "      <td>36.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>269</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26921</th>\n",
       "      <td>Alojamiento céntrico</td>\n",
       "      <td>490492827</td>\n",
       "      <td>Chamberí</td>\n",
       "      <td>Arapiles</td>\n",
       "      <td>40.432800</td>\n",
       "      <td>-3.710090</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>70.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>265</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26922</th>\n",
       "      <td>Costa Golf Resort by Interhome</td>\n",
       "      <td>185902866</td>\n",
       "      <td>Moncloa - Aravaca</td>\n",
       "      <td>Ciudad Universitaria</td>\n",
       "      <td>40.464301</td>\n",
       "      <td>-3.749881</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>107.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>273</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26923</th>\n",
       "      <td>Farmacia VI</td>\n",
       "      <td>438136382</td>\n",
       "      <td>Centro</td>\n",
       "      <td>Justicia</td>\n",
       "      <td>40.423020</td>\n",
       "      <td>-3.700170</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>120.0</td>\n",
       "      <td>1</td>\n",
       "      <td>156</td>\n",
       "      <td>135</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>26924 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                    name    host_id  \\\n",
       "0                                   Bright and airy room      83531   \n",
       "1                                 Gran Via Studio Madrid  346366726   \n",
       "2      COZY APARTMENT CIBELES-GRAN VIA-PTA DEL SOL-CH...   34217435   \n",
       "3                        Holiday Apartment Madrid Center     130907   \n",
       "4                            Great Vacational Apartments     130907   \n",
       "...                                                  ...        ...   \n",
       "26919                            Cozy studio in Chamberí  528979463   \n",
       "26920                                  habitación cálida  583336078   \n",
       "26921                               Alojamiento céntrico  490492827   \n",
       "26922                     Costa Golf Resort by Interhome  185902866   \n",
       "26923                                        Farmacia VI  438136382   \n",
       "\n",
       "      neighbourhood_group         neighbourhood   latitude  longitude  \\\n",
       "0                  Latina              Cármenes  40.403810  -3.741300   \n",
       "1                  Centro           Universidad  40.421830  -3.705290   \n",
       "2                  Centro              Justicia  40.419690  -3.697360   \n",
       "3                  Centro           Universidad  40.422470  -3.705770   \n",
       "4                  Centro                   Sol  40.414760  -3.704180   \n",
       "...                   ...                   ...        ...        ...   \n",
       "26919            Chamberí            Gaztambide  40.433240  -3.712420   \n",
       "26920  Puente de Vallecas              Numancia  40.398327  -3.654305   \n",
       "26921            Chamberí              Arapiles  40.432800  -3.710090   \n",
       "26922   Moncloa - Aravaca  Ciudad Universitaria  40.464301  -3.749881   \n",
       "26923              Centro              Justicia  40.423020  -3.700170   \n",
       "\n",
       "             room_type  price  minimum_nights  calculated_host_listings_count  \\\n",
       "0         Private room   31.0               4                               2   \n",
       "1      Entire home/apt  104.0               5                               1   \n",
       "2      Entire home/apt  114.0               2                              15   \n",
       "3      Entire home/apt    NaN               5                               3   \n",
       "4      Entire home/apt    NaN               5                               3   \n",
       "...                ...    ...             ...                             ...   \n",
       "26919  Entire home/apt  146.0               1                               3   \n",
       "26920     Private room   36.0               1                               1   \n",
       "26921  Entire home/apt   70.0               1                               1   \n",
       "26922  Entire home/apt  107.0               1                               1   \n",
       "26923  Entire home/apt  120.0               1                             156   \n",
       "\n",
       "       availability_365  \n",
       "0                    83  \n",
       "1                   113  \n",
       "2                   310  \n",
       "3                     0  \n",
       "4                     0  \n",
       "...                 ...  \n",
       "26919                46  \n",
       "26920               269  \n",
       "26921               265  \n",
       "26922               273  \n",
       "26923               135  \n",
       "\n",
       "[26924 rows x 11 columns]"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "listings.drop(columns=to_eliminate, inplace=True)\n",
    "listings"
   ]
  },
  {
   "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.12.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}