airbnb eda.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 42,
   "id": "c90c2139",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pymongo \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "398bfa46",
   "metadata": {},
   "outputs": [],
   "source": [
    "client = pymongo.MongoClient(\"mongodb+srv://ahmedhyder:iamahs894@cluster1.hgaiz.mongodb.net/?retryWrites=true&w=majority&appName=Cluster1\")\n",
    "db = client['zen']\n",
    "collection = db['airbnb']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "a1d855f2",
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "cursor = collection.find()\n",
    "data = pd.DataFrame(list(cursor))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "b50c8032",
   "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>listing_url</th>\n",
       "      <th>name</th>\n",
       "      <th>summary</th>\n",
       "      <th>space</th>\n",
       "      <th>description</th>\n",
       "      <th>neighborhood_overview</th>\n",
       "      <th>notes</th>\n",
       "      <th>transit</th>\n",
       "      <th>access</th>\n",
       "      <th>...</th>\n",
       "      <th>guests_included</th>\n",
       "      <th>images</th>\n",
       "      <th>host</th>\n",
       "      <th>address</th>\n",
       "      <th>availability</th>\n",
       "      <th>review_scores</th>\n",
       "      <th>reviews</th>\n",
       "      <th>weekly_price</th>\n",
       "      <th>monthly_price</th>\n",
       "      <th>reviews_per_month</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1003530</td>\n",
       "      <td>https://www.airbnb.com/rooms/1003530</td>\n",
       "      <td>New York City - Upper West Side Apt</td>\n",
       "      <td></td>\n",
       "      <td>Murphy bed, optional second bedroom available....</td>\n",
       "      <td>Murphy bed, optional second bedroom available....</td>\n",
       "      <td>Great neighborhood - many terrific restaurants...</td>\n",
       "      <td>My cat, Samantha, are in and out during the su...</td>\n",
       "      <td>Conveniently located near 1, 2, 3, B &amp; C subwa...</td>\n",
       "      <td>New York City!</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>{'thumbnail_url': '', 'medium_url': '', 'pictu...</td>\n",
       "      <td>{'host_id': '454250', 'host_url': 'https://www...</td>\n",
       "      <td>{'street': 'New York, NY, United States', 'sub...</td>\n",
       "      <td>{'availability_30': 0, 'availability_60': 0, '...</td>\n",
       "      <td>{'review_scores_accuracy': 10, 'review_scores_...</td>\n",
       "      <td>[{'_id': '4351675', 'date': '2013-04-29 04:00:...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>10133554</td>\n",
       "      <td>https://www.airbnb.com/rooms/10133554</td>\n",
       "      <td>Double and triple rooms Blue mosque</td>\n",
       "      <td></td>\n",
       "      <td>We are on the central city  Blue mosque 5 minu...</td>\n",
       "      <td>We are on the central city  Blue mosque 5 minu...</td>\n",
       "      <td>Cankurtaran mahallesi akbıyık caddesi no 22 Su...</td>\n",
       "      <td></td>\n",
       "      <td>Tram 5 minutes  metro 10 minutes  Bus 10 minutes</td>\n",
       "      <td>We have bathroom,wc,İnternet in rooms and unde...</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>{'thumbnail_url': '', 'medium_url': '', 'pictu...</td>\n",
       "      <td>{'host_id': '52004703', 'host_url': 'https://w...</td>\n",
       "      <td>{'street': 'Fatih , İstanbul, Turkey', 'suburb...</td>\n",
       "      <td>{'availability_30': 30, 'availability_60': 60,...</td>\n",
       "      <td>{'review_scores_accuracy': 9, 'review_scores_c...</td>\n",
       "      <td>[{'_id': '149469150', 'date': '2017-05-04 04:0...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>10059872</td>\n",
       "      <td>https://www.airbnb.com/rooms/10059872</td>\n",
       "      <td>Soho Cozy, Spacious and Convenient</td>\n",
       "      <td>Clean, fully furnish, Spacious 1 bedroom flat ...</td>\n",
       "      <td></td>\n",
       "      <td>Clean, fully furnish, Spacious 1 bedroom flat ...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>{'thumbnail_url': '', 'medium_url': '', 'pictu...</td>\n",
       "      <td>{'host_id': '51624384', 'host_url': 'https://w...</td>\n",
       "      <td>{'street': 'Hong Kong, Hong Kong Island, Hong ...</td>\n",
       "      <td>{'availability_30': 0, 'availability_60': 0, '...</td>\n",
       "      <td>{'review_scores_accuracy': 10, 'review_scores_...</td>\n",
       "      <td>[{'_id': '56904633', 'date': '2015-12-19 05:00...</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>10084023</td>\n",
       "      <td>https://www.airbnb.com/rooms/10084023</td>\n",
       "      <td>City center private room with bed</td>\n",
       "      <td>House is located 5mins walk from Sham Shui Po ...</td>\n",
       "      <td>The house is old fashion type, and paint the w...</td>\n",
       "      <td>House is located 5mins walk from Sham Shui Po ...</td>\n",
       "      <td>Cheapest food, electronic device, clothing and...</td>\n",
       "      <td>Deposit of $1000 will be charged and will retu...</td>\n",
       "      <td>Close to 3 different MTR Station, Sham shui Po...</td>\n",
       "      <td>Living Room , Kitchen and Toilet, All cooking ...</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>{'thumbnail_url': '', 'medium_url': '', 'pictu...</td>\n",
       "      <td>{'host_id': '51744313', 'host_url': 'https://w...</td>\n",
       "      <td>{'street': 'Hong Kong , 九龍, Hong Kong', 'subur...</td>\n",
       "      <td>{'availability_30': 14, 'availability_60': 24,...</td>\n",
       "      <td>{'review_scores_accuracy': 10, 'review_scores_...</td>\n",
       "      <td>[{'_id': '57191745', 'date': '2015-12-22 05:00...</td>\n",
       "      <td>1350.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>10091713</td>\n",
       "      <td>https://www.airbnb.com/rooms/10091713</td>\n",
       "      <td>Surry Hills Studio - Your Perfect Base in Sydney</td>\n",
       "      <td>This spacious, light filled studio has everyth...</td>\n",
       "      <td>Comfortable studio with a great layout. The ba...</td>\n",
       "      <td>This spacious, light filled studio has everyth...</td>\n",
       "      <td>Surry Hills is a vibrant eclectic community an...</td>\n",
       "      <td>WiFi, Apple TV with Netflix App (for use with ...</td>\n",
       "      <td>Travel Card 'Opal' travel cards work on all Sy...</td>\n",
       "      <td>You have full use of the entire studio and com...</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>{'thumbnail_url': '', 'medium_url': '', 'pictu...</td>\n",
       "      <td>{'host_id': '13764143', 'host_url': 'https://w...</td>\n",
       "      <td>{'street': 'Surry Hills, NSW, Australia', 'sub...</td>\n",
       "      <td>{'availability_30': 0, 'availability_60': 0, '...</td>\n",
       "      <td>{'review_scores_accuracy': 10, 'review_scores_...</td>\n",
       "      <td>[{'_id': '123549502', 'date': '2016-12-29 05:0...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5550</th>\n",
       "      <td>9985696</td>\n",
       "      <td>https://www.airbnb.com/rooms/9985696</td>\n",
       "      <td>Kadıköy-Altıyol</td>\n",
       "      <td>Kadıköy merkezde 2+1 dairem vardır.Çok kalabal...</td>\n",
       "      <td></td>\n",
       "      <td>Kadıköy merkezde 2+1 dairem vardır.Çok kalabal...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>{'thumbnail_url': '', 'medium_url': '', 'pictu...</td>\n",
       "      <td>{'host_id': '51303748', 'host_url': 'https://w...</td>\n",
       "      <td>{'street': 'Kadıköy, İstanbul, Turkey', 'subur...</td>\n",
       "      <td>{'availability_30': 30, 'availability_60': 60,...</td>\n",
       "      <td>{}</td>\n",
       "      <td>[]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5551</th>\n",
       "      <td>9993190</td>\n",
       "      <td>https://www.airbnb.com/rooms/9993190</td>\n",
       "      <td>Just Steps from the Ocean at Premier Platinum ...</td>\n",
       "      <td>Relax Hawaiian Style in Gated Community on Oce...</td>\n",
       "      <td>***NOTE: THE OCEAN INFINITY POOL (\"POOL 1\"0 WI...</td>\n",
       "      <td>Relax Hawaiian Style in Gated Community on Oce...</td>\n",
       "      <td>Location: Located at the south end of Lahaina ...</td>\n",
       "      <td>Puamana Resort requires a $10/day resort fee w...</td>\n",
       "      <td>You can walk to most attractions within Lahain...</td>\n",
       "      <td>Guests will have access to the 3 pools in the ...</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>{'thumbnail_url': '', 'medium_url': '', 'pictu...</td>\n",
       "      <td>{'host_id': '51013381', 'host_url': 'https://w...</td>\n",
       "      <td>{'street': 'Lahaina, HI, United States', 'subu...</td>\n",
       "      <td>{'availability_30': 0, 'availability_60': 8, '...</td>\n",
       "      <td>{'review_scores_accuracy': 10, 'review_scores_...</td>\n",
       "      <td>[{'_id': '68762225', 'date': '2016-04-06 04:00...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5552</th>\n",
       "      <td>9887054</td>\n",
       "      <td>https://www.airbnb.com/rooms/9887054</td>\n",
       "      <td>Quarry Bay fully furnished studio C</td>\n",
       "      <td>Newly renovated studio flat with full furniture.</td>\n",
       "      <td></td>\n",
       "      <td>Newly renovated studio flat with full furniture.</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>{'thumbnail_url': '', 'medium_url': '', 'pictu...</td>\n",
       "      <td>{'host_id': '31386255', 'host_url': 'https://w...</td>\n",
       "      <td>{'street': 'Hong Kong, Hong Kong Island, Hong ...</td>\n",
       "      <td>{'availability_30': 18, 'availability_60': 48,...</td>\n",
       "      <td>{'review_scores_accuracy': 10, 'review_scores_...</td>\n",
       "      <td>[{'_id': '105800033', 'date': '2016-10-02 04:0...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5553</th>\n",
       "      <td>9907907</td>\n",
       "      <td>https://www.airbnb.com/rooms/9907907</td>\n",
       "      <td>Large double room in Bondi</td>\n",
       "      <td>A bright large double room is available in a b...</td>\n",
       "      <td></td>\n",
       "      <td>A bright large double room is available in a b...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>The flat is exactly half way between the shops...</td>\n",
       "      <td>Guests will have access to the full residence,...</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>{'thumbnail_url': '', 'medium_url': '', 'pictu...</td>\n",
       "      <td>{'host_id': '47615848', 'host_url': 'https://w...</td>\n",
       "      <td>{'street': 'Bondi Beach, NSW, Australia', 'sub...</td>\n",
       "      <td>{'availability_30': 0, 'availability_60': 0, '...</td>\n",
       "      <td>{}</td>\n",
       "      <td>[]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5554</th>\n",
       "      <td>9936016</td>\n",
       "      <td>https://www.airbnb.com/rooms/9936016</td>\n",
       "      <td>Alugo Apartamento na Tijuca</td>\n",
       "      <td>Apartamento amplo que acomoda 6 pessoas. Um qu...</td>\n",
       "      <td></td>\n",
       "      <td>Apartamento amplo que acomoda 6 pessoas. Um qu...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>{'thumbnail_url': '', 'medium_url': '', 'pictu...</td>\n",
       "      <td>{'host_id': '47092481', 'host_url': 'https://w...</td>\n",
       "      <td>{'street': 'Rio de Janeiro, Rio de Janeiro, Br...</td>\n",
       "      <td>{'availability_30': 0, 'availability_60': 0, '...</td>\n",
       "      <td>{}</td>\n",
       "      <td>[]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5555 rows × 42 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           _id                            listing_url  \\\n",
       "0      1003530   https://www.airbnb.com/rooms/1003530   \n",
       "1     10133554  https://www.airbnb.com/rooms/10133554   \n",
       "2     10059872  https://www.airbnb.com/rooms/10059872   \n",
       "3     10084023  https://www.airbnb.com/rooms/10084023   \n",
       "4     10091713  https://www.airbnb.com/rooms/10091713   \n",
       "...        ...                                    ...   \n",
       "5550   9985696   https://www.airbnb.com/rooms/9985696   \n",
       "5551   9993190   https://www.airbnb.com/rooms/9993190   \n",
       "5552   9887054   https://www.airbnb.com/rooms/9887054   \n",
       "5553   9907907   https://www.airbnb.com/rooms/9907907   \n",
       "5554   9936016   https://www.airbnb.com/rooms/9936016   \n",
       "\n",
       "                                                   name  \\\n",
       "0                   New York City - Upper West Side Apt   \n",
       "1                   Double and triple rooms Blue mosque   \n",
       "2                    Soho Cozy, Spacious and Convenient   \n",
       "3                     City center private room with bed   \n",
       "4      Surry Hills Studio - Your Perfect Base in Sydney   \n",
       "...                                                 ...   \n",
       "5550                                    Kadıköy-Altıyol   \n",
       "5551  Just Steps from the Ocean at Premier Platinum ...   \n",
       "5552                Quarry Bay fully furnished studio C   \n",
       "5553                         Large double room in Bondi   \n",
       "5554                        Alugo Apartamento na Tijuca   \n",
       "\n",
       "                                                summary  \\\n",
       "0                                                         \n",
       "1                                                         \n",
       "2     Clean, fully furnish, Spacious 1 bedroom flat ...   \n",
       "3     House is located 5mins walk from Sham Shui Po ...   \n",
       "4     This spacious, light filled studio has everyth...   \n",
       "...                                                 ...   \n",
       "5550  Kadıköy merkezde 2+1 dairem vardır.Çok kalabal...   \n",
       "5551  Relax Hawaiian Style in Gated Community on Oce...   \n",
       "5552   Newly renovated studio flat with full furniture.   \n",
       "5553  A bright large double room is available in a b...   \n",
       "5554  Apartamento amplo que acomoda 6 pessoas. Um qu...   \n",
       "\n",
       "                                                  space  \\\n",
       "0     Murphy bed, optional second bedroom available....   \n",
       "1     We are on the central city  Blue mosque 5 minu...   \n",
       "2                                                         \n",
       "3     The house is old fashion type, and paint the w...   \n",
       "4     Comfortable studio with a great layout. The ba...   \n",
       "...                                                 ...   \n",
       "5550                                                      \n",
       "5551  ***NOTE: THE OCEAN INFINITY POOL (\"POOL 1\"0 WI...   \n",
       "5552                                                      \n",
       "5553                                                      \n",
       "5554                                                      \n",
       "\n",
       "                                            description  \\\n",
       "0     Murphy bed, optional second bedroom available....   \n",
       "1     We are on the central city  Blue mosque 5 minu...   \n",
       "2     Clean, fully furnish, Spacious 1 bedroom flat ...   \n",
       "3     House is located 5mins walk from Sham Shui Po ...   \n",
       "4     This spacious, light filled studio has everyth...   \n",
       "...                                                 ...   \n",
       "5550  Kadıköy merkezde 2+1 dairem vardır.Çok kalabal...   \n",
       "5551  Relax Hawaiian Style in Gated Community on Oce...   \n",
       "5552   Newly renovated studio flat with full furniture.   \n",
       "5553  A bright large double room is available in a b...   \n",
       "5554  Apartamento amplo que acomoda 6 pessoas. Um qu...   \n",
       "\n",
       "                                  neighborhood_overview  \\\n",
       "0     Great neighborhood - many terrific restaurants...   \n",
       "1     Cankurtaran mahallesi akbıyık caddesi no 22 Su...   \n",
       "2                                                         \n",
       "3     Cheapest food, electronic device, clothing and...   \n",
       "4     Surry Hills is a vibrant eclectic community an...   \n",
       "...                                                 ...   \n",
       "5550                                                      \n",
       "5551  Location: Located at the south end of Lahaina ...   \n",
       "5552                                                      \n",
       "5553                                                      \n",
       "5554                                                      \n",
       "\n",
       "                                                  notes  \\\n",
       "0     My cat, Samantha, are in and out during the su...   \n",
       "1                                                         \n",
       "2                                                         \n",
       "3     Deposit of $1000 will be charged and will retu...   \n",
       "4     WiFi, Apple TV with Netflix App (for use with ...   \n",
       "...                                                 ...   \n",
       "5550                                                      \n",
       "5551  Puamana Resort requires a $10/day resort fee w...   \n",
       "5552                                                      \n",
       "5553                                                      \n",
       "5554                                                      \n",
       "\n",
       "                                                transit  \\\n",
       "0     Conveniently located near 1, 2, 3, B & C subwa...   \n",
       "1      Tram 5 minutes  metro 10 minutes  Bus 10 minutes   \n",
       "2                                                         \n",
       "3     Close to 3 different MTR Station, Sham shui Po...   \n",
       "4     Travel Card 'Opal' travel cards work on all Sy...   \n",
       "...                                                 ...   \n",
       "5550                                                      \n",
       "5551  You can walk to most attractions within Lahain...   \n",
       "5552                                                      \n",
       "5553  The flat is exactly half way between the shops...   \n",
       "5554                                                      \n",
       "\n",
       "                                                 access  ... guests_included  \\\n",
       "0                                        New York City!  ...               1   \n",
       "1     We have bathroom,wc,İnternet in rooms and unde...  ...               1   \n",
       "2                                                        ...               1   \n",
       "3     Living Room , Kitchen and Toilet, All cooking ...  ...               1   \n",
       "4     You have full use of the entire studio and com...  ...               1   \n",
       "...                                                 ...  ...             ...   \n",
       "5550                                                     ...               1   \n",
       "5551  Guests will have access to the 3 pools in the ...  ...               1   \n",
       "5552                                                     ...               2   \n",
       "5553  Guests will have access to the full residence,...  ...               2   \n",
       "5554                                                     ...               1   \n",
       "\n",
       "                                                 images  \\\n",
       "0     {'thumbnail_url': '', 'medium_url': '', 'pictu...   \n",
       "1     {'thumbnail_url': '', 'medium_url': '', 'pictu...   \n",
       "2     {'thumbnail_url': '', 'medium_url': '', 'pictu...   \n",
       "3     {'thumbnail_url': '', 'medium_url': '', 'pictu...   \n",
       "4     {'thumbnail_url': '', 'medium_url': '', 'pictu...   \n",
       "...                                                 ...   \n",
       "5550  {'thumbnail_url': '', 'medium_url': '', 'pictu...   \n",
       "5551  {'thumbnail_url': '', 'medium_url': '', 'pictu...   \n",
       "5552  {'thumbnail_url': '', 'medium_url': '', 'pictu...   \n",
       "5553  {'thumbnail_url': '', 'medium_url': '', 'pictu...   \n",
       "5554  {'thumbnail_url': '', 'medium_url': '', 'pictu...   \n",
       "\n",
       "                                                   host  \\\n",
       "0     {'host_id': '454250', 'host_url': 'https://www...   \n",
       "1     {'host_id': '52004703', 'host_url': 'https://w...   \n",
       "2     {'host_id': '51624384', 'host_url': 'https://w...   \n",
       "3     {'host_id': '51744313', 'host_url': 'https://w...   \n",
       "4     {'host_id': '13764143', 'host_url': 'https://w...   \n",
       "...                                                 ...   \n",
       "5550  {'host_id': '51303748', 'host_url': 'https://w...   \n",
       "5551  {'host_id': '51013381', 'host_url': 'https://w...   \n",
       "5552  {'host_id': '31386255', 'host_url': 'https://w...   \n",
       "5553  {'host_id': '47615848', 'host_url': 'https://w...   \n",
       "5554  {'host_id': '47092481', 'host_url': 'https://w...   \n",
       "\n",
       "                                                address  \\\n",
       "0     {'street': 'New York, NY, United States', 'sub...   \n",
       "1     {'street': 'Fatih , İstanbul, Turkey', 'suburb...   \n",
       "2     {'street': 'Hong Kong, Hong Kong Island, Hong ...   \n",
       "3     {'street': 'Hong Kong , 九龍, Hong Kong', 'subur...   \n",
       "4     {'street': 'Surry Hills, NSW, Australia', 'sub...   \n",
       "...                                                 ...   \n",
       "5550  {'street': 'Kadıköy, İstanbul, Turkey', 'subur...   \n",
       "5551  {'street': 'Lahaina, HI, United States', 'subu...   \n",
       "5552  {'street': 'Hong Kong, Hong Kong Island, Hong ...   \n",
       "5553  {'street': 'Bondi Beach, NSW, Australia', 'sub...   \n",
       "5554  {'street': 'Rio de Janeiro, Rio de Janeiro, Br...   \n",
       "\n",
       "                                           availability  \\\n",
       "0     {'availability_30': 0, 'availability_60': 0, '...   \n",
       "1     {'availability_30': 30, 'availability_60': 60,...   \n",
       "2     {'availability_30': 0, 'availability_60': 0, '...   \n",
       "3     {'availability_30': 14, 'availability_60': 24,...   \n",
       "4     {'availability_30': 0, 'availability_60': 0, '...   \n",
       "...                                                 ...   \n",
       "5550  {'availability_30': 30, 'availability_60': 60,...   \n",
       "5551  {'availability_30': 0, 'availability_60': 8, '...   \n",
       "5552  {'availability_30': 18, 'availability_60': 48,...   \n",
       "5553  {'availability_30': 0, 'availability_60': 0, '...   \n",
       "5554  {'availability_30': 0, 'availability_60': 0, '...   \n",
       "\n",
       "                                          review_scores  \\\n",
       "0     {'review_scores_accuracy': 10, 'review_scores_...   \n",
       "1     {'review_scores_accuracy': 9, 'review_scores_c...   \n",
       "2     {'review_scores_accuracy': 10, 'review_scores_...   \n",
       "3     {'review_scores_accuracy': 10, 'review_scores_...   \n",
       "4     {'review_scores_accuracy': 10, 'review_scores_...   \n",
       "...                                                 ...   \n",
       "5550                                                 {}   \n",
       "5551  {'review_scores_accuracy': 10, 'review_scores_...   \n",
       "5552  {'review_scores_accuracy': 10, 'review_scores_...   \n",
       "5553                                                 {}   \n",
       "5554                                                 {}   \n",
       "\n",
       "                                                reviews weekly_price  \\\n",
       "0     [{'_id': '4351675', 'date': '2013-04-29 04:00:...          NaN   \n",
       "1     [{'_id': '149469150', 'date': '2017-05-04 04:0...          NaN   \n",
       "2     [{'_id': '56904633', 'date': '2015-12-19 05:00...       5000.0   \n",
       "3     [{'_id': '57191745', 'date': '2015-12-22 05:00...       1350.0   \n",
       "4     [{'_id': '123549502', 'date': '2016-12-29 05:0...          NaN   \n",
       "...                                                 ...          ...   \n",
       "5550                                                 []          NaN   \n",
       "5551  [{'_id': '68762225', 'date': '2016-04-06 04:00...          NaN   \n",
       "5552  [{'_id': '105800033', 'date': '2016-10-02 04:0...          NaN   \n",
       "5553                                                 []          NaN   \n",
       "5554                                                 []          NaN   \n",
       "\n",
       "     monthly_price reviews_per_month  \n",
       "0              NaN               NaN  \n",
       "1              NaN               NaN  \n",
       "2              NaN               NaN  \n",
       "3           5000.0               NaN  \n",
       "4              NaN               NaN  \n",
       "...            ...               ...  \n",
       "5550           NaN               NaN  \n",
       "5551           NaN               NaN  \n",
       "5552           NaN               NaN  \n",
       "5553           NaN               NaN  \n",
       "5554           NaN               NaN  \n",
       "\n",
       "[5555 rows x 42 columns]"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "id": "0bd965b3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['_id', 'listing_url', 'name', 'summary', 'space', 'description',\n",
       "       'neighborhood_overview', 'notes', 'transit', 'access', 'interaction',\n",
       "       'house_rules', 'property_type', 'room_type', 'bed_type',\n",
       "       'minimum_nights', 'maximum_nights', 'cancellation_policy',\n",
       "       'last_scraped', 'calendar_last_scraped', 'first_review', 'last_review',\n",
       "       'accommodates', 'bedrooms', 'beds', 'number_of_reviews', 'bathrooms',\n",
       "       'amenities', 'price', 'security_deposit', 'cleaning_fee',\n",
       "       'extra_people', 'guests_included', 'images', 'host', 'address',\n",
       "       'availability', 'review_scores', 'reviews', 'weekly_price',\n",
       "       'monthly_price', 'reviews_per_month'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "b94b2efb",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "_id                                                                1003530\n",
       "listing_url                           https://www.airbnb.com/rooms/1003530\n",
       "name                                   New York City - Upper West Side Apt\n",
       "summary                                                                   \n",
       "space                    Murphy bed, optional second bedroom available....\n",
       "description              Murphy bed, optional second bedroom available....\n",
       "neighborhood_overview    Great neighborhood - many terrific restaurants...\n",
       "notes                    My cat, Samantha, are in and out during the su...\n",
       "transit                  Conveniently located near 1, 2, 3, B & C subwa...\n",
       "access                                                      New York City!\n",
       "interaction                                                               \n",
       "house_rules              No smoking is permitted in the apartment. All ...\n",
       "property_type                                                    Apartment\n",
       "room_type                                                     Private room\n",
       "bed_type                                                          Real Bed\n",
       "minimum_nights                                                          12\n",
       "maximum_nights                                                         360\n",
       "cancellation_policy                            strict_14_with_grace_period\n",
       "last_scraped                                           2019-03-07 05:00:00\n",
       "calendar_last_scraped                                  2019-03-07 05:00:00\n",
       "first_review                                           2013-04-29 04:00:00\n",
       "last_review                                            2018-08-12 04:00:00\n",
       "accommodates                                                             2\n",
       "bedrooms                                                               1.0\n",
       "beds                                                                   1.0\n",
       "number_of_reviews                                                       70\n",
       "bathrooms                                                              1.0\n",
       "amenities                [Internet, Wifi, Air conditioning, Kitchen, El...\n",
       "price                                                                  135\n",
       "security_deposit                                                       0.0\n",
       "cleaning_fee                                                         135.0\n",
       "extra_people                                                             0\n",
       "guests_included                                                          1\n",
       "images                   {'thumbnail_url': '', 'medium_url': '', 'pictu...\n",
       "host                     {'host_id': '454250', 'host_url': 'https://www...\n",
       "address                  {'street': 'New York, NY, United States', 'sub...\n",
       "availability             {'availability_30': 0, 'availability_60': 0, '...\n",
       "review_scores            {'review_scores_accuracy': 10, 'review_scores_...\n",
       "reviews                  [{'_id': '4351675', 'date': '2013-04-29 04:00:...\n",
       "weekly_price                                                           NaN\n",
       "monthly_price                                                          NaN\n",
       "reviews_per_month                                                      NaN\n",
       "Name: 0, dtype: object"
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.loc[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "id": "fced227b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "_id                         0\n",
       "listing_url                 0\n",
       "name                        0\n",
       "summary                     0\n",
       "space                       0\n",
       "description                 0\n",
       "neighborhood_overview       0\n",
       "notes                       0\n",
       "transit                     0\n",
       "access                      0\n",
       "interaction                 0\n",
       "house_rules                 0\n",
       "property_type               0\n",
       "room_type                   0\n",
       "bed_type                    0\n",
       "minimum_nights              0\n",
       "maximum_nights              0\n",
       "cancellation_policy         0\n",
       "last_scraped                0\n",
       "calendar_last_scraped       0\n",
       "first_review             1388\n",
       "last_review              1388\n",
       "accommodates                0\n",
       "bedrooms                    5\n",
       "beds                       13\n",
       "number_of_reviews           0\n",
       "bathrooms                  10\n",
       "amenities                   0\n",
       "price                       0\n",
       "security_deposit         2084\n",
       "cleaning_fee             1531\n",
       "extra_people                0\n",
       "guests_included             0\n",
       "images                      0\n",
       "host                        0\n",
       "address                     0\n",
       "availability                0\n",
       "review_scores               0\n",
       "reviews                     0\n",
       "weekly_price             4841\n",
       "monthly_price            4899\n",
       "reviews_per_month        5461\n",
       "dtype: int64"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "629628a0",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0       2013-04-29 04:00:00\n",
       "1       2017-05-04 04:00:00\n",
       "2       2015-12-19 05:00:00\n",
       "3       2015-12-22 05:00:00\n",
       "4       2016-12-29 05:00:00\n",
       "               ...         \n",
       "5550                    NaN\n",
       "5551    2016-04-06 04:00:00\n",
       "5552    2016-10-02 04:00:00\n",
       "5553                    NaN\n",
       "5554                    NaN\n",
       "Name: first_review, Length: 5555, dtype: object"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['first_review'] #forward fill"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "id": "375d7331",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['first_review'].fillna(method = 'ffill', inplace = True)\n",
    "data['first_review'].isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "id": "e737909b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0       2018-08-12 04:00:00\n",
       "1       2018-05-07 04:00:00\n",
       "2       2018-03-27 04:00:00\n",
       "3       2019-03-01 05:00:00\n",
       "4       2018-03-18 04:00:00\n",
       "               ...         \n",
       "5550                    NaN\n",
       "5551    2018-08-20 04:00:00\n",
       "5552    2017-01-01 05:00:00\n",
       "5553                    NaN\n",
       "5554                    NaN\n",
       "Name: last_review, Length: 5555, dtype: object"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['last_review'] #bckward fill"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "id": "06118ee4",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['last_review'].fillna(method = 'ffill', inplace = True)\n",
    "data['last_review'].isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "id": "9adc6a76",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0       1.0\n",
       "1       1.0\n",
       "2       1.0\n",
       "3       1.0\n",
       "4       0.0\n",
       "       ... \n",
       "5550    2.0\n",
       "5551    2.0\n",
       "5552    1.0\n",
       "5553    1.0\n",
       "5554    1.0\n",
       "Name: bedrooms, Length: 5555, dtype: float64"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['bedrooms'] #mode"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "id": "909117f9",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    1.0\n",
       "Name: bedrooms, dtype: float64"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['bedrooms'].mode()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "id": "47a87288",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['bedrooms'].fillna( data['bedrooms'].mode()[0], inplace = True)\n",
    "data['bedrooms'].isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "id": "b94be84d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0       1.0\n",
       "1       2.0\n",
       "2       2.0\n",
       "3       1.0\n",
       "4       1.0\n",
       "       ... \n",
       "5550    3.0\n",
       "5551    4.0\n",
       "5552    1.0\n",
       "5553    1.0\n",
       "5554    2.0\n",
       "Name: beds, Length: 5555, dtype: float64"
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['beds'] #mode"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "id": "abdc1a5f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    1.0\n",
       "Name: beds, dtype: float64"
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['beds'].mode()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "id": "cc69c48f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['beds'].fillna(data['beds'].mode()[0], inplace = True)\n",
    "data['beds'].isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "a3affcdd",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "id": "43eb4945",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0       1.0\n",
       "1       1.0\n",
       "2       1.0\n",
       "3       1.0\n",
       "4       1.0\n",
       "       ... \n",
       "5550    1.0\n",
       "5551    2.0\n",
       "5552    1.0\n",
       "5553    1.0\n",
       "5554    2.0\n",
       "Name: bathrooms, Length: 5555, dtype: float64"
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['bathrooms'] #mode"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "id": "fab841d0",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    1.0\n",
       "Name: bathrooms, dtype: float64"
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['bathrooms'].mode()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "id": "a2046842",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['bathrooms'].fillna(data['bathrooms'].mode()[0], inplace = True)\n",
    "data['bathrooms'].isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "id": "20440fc2",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0          0.0\n",
       "1          NaN\n",
       "2          NaN\n",
       "3          0.0\n",
       "4        300.0\n",
       "         ...  \n",
       "5550       NaN\n",
       "5551     200.0\n",
       "5552    3000.0\n",
       "5553       NaN\n",
       "5554       NaN\n",
       "Name: security_deposit, Length: 5555, dtype: float64"
      ]
     },
     "execution_count": 62,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['security_deposit'] #mean"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "id": "ed1a0a71",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2084"
      ]
     },
     "execution_count": 63,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['security_deposit'].isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "id": "37d9de54",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "509.43"
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['security_deposit'].mean().round(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "id": "793dfb0a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 65,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['security_deposit'].fillna(data['security_deposit'].mean().round(2), inplace = True)\n",
    "data['security_deposit'].isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "id": "54a1771e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0       135.0\n",
       "1         NaN\n",
       "2         NaN\n",
       "3        50.0\n",
       "4        50.0\n",
       "        ...  \n",
       "5550      NaN\n",
       "5551    315.0\n",
       "5552      NaN\n",
       "5553     50.0\n",
       "5554      NaN\n",
       "Name: cleaning_fee, Length: 5555, dtype: float64"
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['cleaning_fee']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "id": "9fddae4b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "94.07"
      ]
     },
     "execution_count": 67,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['cleaning_fee'].mean().round(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "id": "4911d86d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 68,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['cleaning_fee'].fillna(data['cleaning_fee'].mean().round(), inplace = True)\n",
    "data['cleaning_fee'].isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "id": "127c7292",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0          NaN\n",
       "1          NaN\n",
       "2       5000.0\n",
       "3       1350.0\n",
       "4          NaN\n",
       "         ...  \n",
       "5550       NaN\n",
       "5551       NaN\n",
       "5552       NaN\n",
       "5553       NaN\n",
       "5554       NaN\n",
       "Name: weekly_price, Length: 5555, dtype: float64"
      ]
     },
     "execution_count": 69,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['weekly_price']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "id": "dc7079ca",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    600.0\n",
       "Name: weekly_price, dtype: float64"
      ]
     },
     "execution_count": 70,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['weekly_price'].mode()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "id": "7c2ad044",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 71,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['weekly_price'].fillna(data['weekly_price'].mode()[0], inplace = True)\n",
    "data['weekly_price'].isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "id": "7127ad07",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0          NaN\n",
       "1          NaN\n",
       "2          NaN\n",
       "3       5000.0\n",
       "4          NaN\n",
       "         ...  \n",
       "5550       NaN\n",
       "5551       NaN\n",
       "5552       NaN\n",
       "5553       NaN\n",
       "5554       NaN\n",
       "Name: monthly_price, Length: 5555, dtype: float64"
      ]
     },
     "execution_count": 72,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['monthly_price']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "id": "3914be6c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    3000.0\n",
       "Name: monthly_price, dtype: float64"
      ]
     },
     "execution_count": 73,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['monthly_price'].mode()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "id": "7dea7c67",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 74,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['monthly_price'].fillna(data['monthly_price'].mode()[0], inplace = True)\n",
    "data['monthly_price'].isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "id": "f33b56fb",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    1.0\n",
       "Name: reviews_per_month, dtype: float64"
      ]
     },
     "execution_count": 75,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['reviews_per_month'].mode()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "id": "5442bab6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 76,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['reviews_per_month'].fillna(data['reviews_per_month'].mode()[0], inplace = True)\n",
    "data['reviews_per_month'].isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "id": "4941dbdb",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0       {'availability_30': 0, 'availability_60': 0, '...\n",
       "1       {'availability_30': 30, 'availability_60': 60,...\n",
       "2       {'availability_30': 0, 'availability_60': 0, '...\n",
       "3       {'availability_30': 14, 'availability_60': 24,...\n",
       "4       {'availability_30': 0, 'availability_60': 0, '...\n",
       "                              ...                        \n",
       "5550    {'availability_30': 30, 'availability_60': 60,...\n",
       "5551    {'availability_30': 0, 'availability_60': 8, '...\n",
       "5552    {'availability_30': 18, 'availability_60': 48,...\n",
       "5553    {'availability_30': 0, 'availability_60': 0, '...\n",
       "5554    {'availability_30': 0, 'availability_60': 0, '...\n",
       "Name: availability, Length: 5555, dtype: object"
      ]
     },
     "execution_count": 77,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['availability']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "id": "aeee4de6",
   "metadata": {},
   "outputs": [],
   "source": [
    "if 'address' in data.columns:\n",
    "     data['coordinates'] = data['address'].apply(lambda x: x.get('location', {}).get('coordinates', None) if isinstance(x, dict) else None)\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "id": "9fe2451a",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 5555 entries, 0 to 5554\n",
      "Data columns (total 43 columns):\n",
      " #   Column                 Non-Null Count  Dtype  \n",
      "---  ------                 --------------  -----  \n",
      " 0   _id                    5555 non-null   object \n",
      " 1   listing_url            5555 non-null   object \n",
      " 2   name                   5555 non-null   object \n",
      " 3   summary                5555 non-null   object \n",
      " 4   space                  5555 non-null   object \n",
      " 5   description            5555 non-null   object \n",
      " 6   neighborhood_overview  5555 non-null   object \n",
      " 7   notes                  5555 non-null   object \n",
      " 8   transit                5555 non-null   object \n",
      " 9   access                 5555 non-null   object \n",
      " 10  interaction            5555 non-null   object \n",
      " 11  house_rules            5555 non-null   object \n",
      " 12  property_type          5555 non-null   object \n",
      " 13  room_type              5555 non-null   object \n",
      " 14  bed_type               5555 non-null   object \n",
      " 15  minimum_nights         5555 non-null   object \n",
      " 16  maximum_nights         5555 non-null   object \n",
      " 17  cancellation_policy    5555 non-null   object \n",
      " 18  last_scraped           5555 non-null   object \n",
      " 19  calendar_last_scraped  5555 non-null   object \n",
      " 20  first_review           5555 non-null   object \n",
      " 21  last_review            5555 non-null   object \n",
      " 22  accommodates           5555 non-null   int64  \n",
      " 23  bedrooms               5555 non-null   float64\n",
      " 24  beds                   5555 non-null   float64\n",
      " 25  number_of_reviews      5555 non-null   int64  \n",
      " 26  bathrooms              5555 non-null   float64\n",
      " 27  amenities              5555 non-null   object \n",
      " 28  price                  5555 non-null   int64  \n",
      " 29  security_deposit       5555 non-null   float64\n",
      " 30  cleaning_fee           5555 non-null   float64\n",
      " 31  extra_people           5555 non-null   int64  \n",
      " 32  guests_included        5555 non-null   int64  \n",
      " 33  images                 5555 non-null   object \n",
      " 34  host                   5555 non-null   object \n",
      " 35  address                5555 non-null   object \n",
      " 36  availability           5555 non-null   object \n",
      " 37  review_scores          5555 non-null   object \n",
      " 38  reviews                5555 non-null   object \n",
      " 39  weekly_price           5555 non-null   float64\n",
      " 40  monthly_price          5555 non-null   float64\n",
      " 41  reviews_per_month      5555 non-null   float64\n",
      " 42  coordinates            5555 non-null   object \n",
      "dtypes: float64(8), int64(5), object(30)\n",
      "memory usage: 1.8+ MB\n"
     ]
    }
   ],
   "source": [
    "data.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "id": "ceeb6e56",
   "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>listing_url</th>\n",
       "      <th>name</th>\n",
       "      <th>summary</th>\n",
       "      <th>space</th>\n",
       "      <th>description</th>\n",
       "      <th>neighborhood_overview</th>\n",
       "      <th>notes</th>\n",
       "      <th>transit</th>\n",
       "      <th>access</th>\n",
       "      <th>...</th>\n",
       "      <th>review_scores</th>\n",
       "      <th>reviews</th>\n",
       "      <th>weekly_price</th>\n",
       "      <th>monthly_price</th>\n",
       "      <th>reviews_per_month</th>\n",
       "      <th>coordinates</th>\n",
       "      <th>availability_30</th>\n",
       "      <th>availability_60</th>\n",
       "      <th>availability_90</th>\n",
       "      <th>availability_365</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1003530</td>\n",
       "      <td>https://www.airbnb.com/rooms/1003530</td>\n",
       "      <td>New York City - Upper West Side Apt</td>\n",
       "      <td></td>\n",
       "      <td>Murphy bed, optional second bedroom available....</td>\n",
       "      <td>Murphy bed, optional second bedroom available....</td>\n",
       "      <td>Great neighborhood - many terrific restaurants...</td>\n",
       "      <td>My cat, Samantha, are in and out during the su...</td>\n",
       "      <td>Conveniently located near 1, 2, 3, B &amp; C subwa...</td>\n",
       "      <td>New York City!</td>\n",
       "      <td>...</td>\n",
       "      <td>{'review_scores_accuracy': 10, 'review_scores_...</td>\n",
       "      <td>[{'_id': '4351675', 'date': '2013-04-29 04:00:...</td>\n",
       "      <td>600.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[-73.96523, 40.79962]</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>10133554</td>\n",
       "      <td>https://www.airbnb.com/rooms/10133554</td>\n",
       "      <td>Double and triple rooms Blue mosque</td>\n",
       "      <td></td>\n",
       "      <td>We are on the central city  Blue mosque 5 minu...</td>\n",
       "      <td>We are on the central city  Blue mosque 5 minu...</td>\n",
       "      <td>Cankurtaran mahallesi akbıyık caddesi no 22 Su...</td>\n",
       "      <td></td>\n",
       "      <td>Tram 5 minutes  metro 10 minutes  Bus 10 minutes</td>\n",
       "      <td>We have bathroom,wc,İnternet in rooms and unde...</td>\n",
       "      <td>...</td>\n",
       "      <td>{'review_scores_accuracy': 9, 'review_scores_c...</td>\n",
       "      <td>[{'_id': '149469150', 'date': '2017-05-04 04:0...</td>\n",
       "      <td>600.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[28.98009, 41.0062]</td>\n",
       "      <td>30</td>\n",
       "      <td>60</td>\n",
       "      <td>90</td>\n",
       "      <td>365</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>10059872</td>\n",
       "      <td>https://www.airbnb.com/rooms/10059872</td>\n",
       "      <td>Soho Cozy, Spacious and Convenient</td>\n",
       "      <td>Clean, fully furnish, Spacious 1 bedroom flat ...</td>\n",
       "      <td></td>\n",
       "      <td>Clean, fully furnish, Spacious 1 bedroom flat ...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>{'review_scores_accuracy': 10, 'review_scores_...</td>\n",
       "      <td>[{'_id': '56904633', 'date': '2015-12-19 05:00...</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[114.15027, 22.28158]</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>10084023</td>\n",
       "      <td>https://www.airbnb.com/rooms/10084023</td>\n",
       "      <td>City center private room with bed</td>\n",
       "      <td>House is located 5mins walk from Sham Shui Po ...</td>\n",
       "      <td>The house is old fashion type, and paint the w...</td>\n",
       "      <td>House is located 5mins walk from Sham Shui Po ...</td>\n",
       "      <td>Cheapest food, electronic device, clothing and...</td>\n",
       "      <td>Deposit of $1000 will be charged and will retu...</td>\n",
       "      <td>Close to 3 different MTR Station, Sham shui Po...</td>\n",
       "      <td>Living Room , Kitchen and Toilet, All cooking ...</td>\n",
       "      <td>...</td>\n",
       "      <td>{'review_scores_accuracy': 10, 'review_scores_...</td>\n",
       "      <td>[{'_id': '57191745', 'date': '2015-12-22 05:00...</td>\n",
       "      <td>1350.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[114.1669, 22.3314]</td>\n",
       "      <td>14</td>\n",
       "      <td>24</td>\n",
       "      <td>40</td>\n",
       "      <td>220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>10091713</td>\n",
       "      <td>https://www.airbnb.com/rooms/10091713</td>\n",
       "      <td>Surry Hills Studio - Your Perfect Base in Sydney</td>\n",
       "      <td>This spacious, light filled studio has everyth...</td>\n",
       "      <td>Comfortable studio with a great layout. The ba...</td>\n",
       "      <td>This spacious, light filled studio has everyth...</td>\n",
       "      <td>Surry Hills is a vibrant eclectic community an...</td>\n",
       "      <td>WiFi, Apple TV with Netflix App (for use with ...</td>\n",
       "      <td>Travel Card 'Opal' travel cards work on all Sy...</td>\n",
       "      <td>You have full use of the entire studio and com...</td>\n",
       "      <td>...</td>\n",
       "      <td>{'review_scores_accuracy': 10, 'review_scores_...</td>\n",
       "      <td>[{'_id': '123549502', 'date': '2016-12-29 05:0...</td>\n",
       "      <td>600.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[151.21554, -33.88029]</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</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",
       "      <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>5550</th>\n",
       "      <td>9985696</td>\n",
       "      <td>https://www.airbnb.com/rooms/9985696</td>\n",
       "      <td>Kadıköy-Altıyol</td>\n",
       "      <td>Kadıköy merkezde 2+1 dairem vardır.Çok kalabal...</td>\n",
       "      <td></td>\n",
       "      <td>Kadıköy merkezde 2+1 dairem vardır.Çok kalabal...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>{}</td>\n",
       "      <td>[]</td>\n",
       "      <td>600.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[29.03079, 40.98563]</td>\n",
       "      <td>30</td>\n",
       "      <td>60</td>\n",
       "      <td>90</td>\n",
       "      <td>365</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5551</th>\n",
       "      <td>9993190</td>\n",
       "      <td>https://www.airbnb.com/rooms/9993190</td>\n",
       "      <td>Just Steps from the Ocean at Premier Platinum ...</td>\n",
       "      <td>Relax Hawaiian Style in Gated Community on Oce...</td>\n",
       "      <td>***NOTE: THE OCEAN INFINITY POOL (\"POOL 1\"0 WI...</td>\n",
       "      <td>Relax Hawaiian Style in Gated Community on Oce...</td>\n",
       "      <td>Location: Located at the south end of Lahaina ...</td>\n",
       "      <td>Puamana Resort requires a $10/day resort fee w...</td>\n",
       "      <td>You can walk to most attractions within Lahain...</td>\n",
       "      <td>Guests will have access to the 3 pools in the ...</td>\n",
       "      <td>...</td>\n",
       "      <td>{'review_scores_accuracy': 10, 'review_scores_...</td>\n",
       "      <td>[{'_id': '68762225', 'date': '2016-04-06 04:00...</td>\n",
       "      <td>600.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[-156.66752, 20.85894]</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>31</td>\n",
       "      <td>258</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5552</th>\n",
       "      <td>9887054</td>\n",
       "      <td>https://www.airbnb.com/rooms/9887054</td>\n",
       "      <td>Quarry Bay fully furnished studio C</td>\n",
       "      <td>Newly renovated studio flat with full furniture.</td>\n",
       "      <td></td>\n",
       "      <td>Newly renovated studio flat with full furniture.</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>{'review_scores_accuracy': 10, 'review_scores_...</td>\n",
       "      <td>[{'_id': '105800033', 'date': '2016-10-02 04:0...</td>\n",
       "      <td>600.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[114.20722, 22.29157]</td>\n",
       "      <td>18</td>\n",
       "      <td>48</td>\n",
       "      <td>78</td>\n",
       "      <td>353</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5553</th>\n",
       "      <td>9907907</td>\n",
       "      <td>https://www.airbnb.com/rooms/9907907</td>\n",
       "      <td>Large double room in Bondi</td>\n",
       "      <td>A bright large double room is available in a b...</td>\n",
       "      <td></td>\n",
       "      <td>A bright large double room is available in a b...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>The flat is exactly half way between the shops...</td>\n",
       "      <td>Guests will have access to the full residence,...</td>\n",
       "      <td>...</td>\n",
       "      <td>{}</td>\n",
       "      <td>[]</td>\n",
       "      <td>600.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[151.26542, -33.89298]</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5554</th>\n",
       "      <td>9936016</td>\n",
       "      <td>https://www.airbnb.com/rooms/9936016</td>\n",
       "      <td>Alugo Apartamento na Tijuca</td>\n",
       "      <td>Apartamento amplo que acomoda 6 pessoas. Um qu...</td>\n",
       "      <td></td>\n",
       "      <td>Apartamento amplo que acomoda 6 pessoas. Um qu...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>{}</td>\n",
       "      <td>[]</td>\n",
       "      <td>600.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[-43.173761316748546, -22.90833634089244]</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5555 rows × 47 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           _id                            listing_url  \\\n",
       "0      1003530   https://www.airbnb.com/rooms/1003530   \n",
       "1     10133554  https://www.airbnb.com/rooms/10133554   \n",
       "2     10059872  https://www.airbnb.com/rooms/10059872   \n",
       "3     10084023  https://www.airbnb.com/rooms/10084023   \n",
       "4     10091713  https://www.airbnb.com/rooms/10091713   \n",
       "...        ...                                    ...   \n",
       "5550   9985696   https://www.airbnb.com/rooms/9985696   \n",
       "5551   9993190   https://www.airbnb.com/rooms/9993190   \n",
       "5552   9887054   https://www.airbnb.com/rooms/9887054   \n",
       "5553   9907907   https://www.airbnb.com/rooms/9907907   \n",
       "5554   9936016   https://www.airbnb.com/rooms/9936016   \n",
       "\n",
       "                                                   name  \\\n",
       "0                   New York City - Upper West Side Apt   \n",
       "1                   Double and triple rooms Blue mosque   \n",
       "2                    Soho Cozy, Spacious and Convenient   \n",
       "3                     City center private room with bed   \n",
       "4      Surry Hills Studio - Your Perfect Base in Sydney   \n",
       "...                                                 ...   \n",
       "5550                                    Kadıköy-Altıyol   \n",
       "5551  Just Steps from the Ocean at Premier Platinum ...   \n",
       "5552                Quarry Bay fully furnished studio C   \n",
       "5553                         Large double room in Bondi   \n",
       "5554                        Alugo Apartamento na Tijuca   \n",
       "\n",
       "                                                summary  \\\n",
       "0                                                         \n",
       "1                                                         \n",
       "2     Clean, fully furnish, Spacious 1 bedroom flat ...   \n",
       "3     House is located 5mins walk from Sham Shui Po ...   \n",
       "4     This spacious, light filled studio has everyth...   \n",
       "...                                                 ...   \n",
       "5550  Kadıköy merkezde 2+1 dairem vardır.Çok kalabal...   \n",
       "5551  Relax Hawaiian Style in Gated Community on Oce...   \n",
       "5552   Newly renovated studio flat with full furniture.   \n",
       "5553  A bright large double room is available in a b...   \n",
       "5554  Apartamento amplo que acomoda 6 pessoas. Um qu...   \n",
       "\n",
       "                                                  space  \\\n",
       "0     Murphy bed, optional second bedroom available....   \n",
       "1     We are on the central city  Blue mosque 5 minu...   \n",
       "2                                                         \n",
       "3     The house is old fashion type, and paint the w...   \n",
       "4     Comfortable studio with a great layout. The ba...   \n",
       "...                                                 ...   \n",
       "5550                                                      \n",
       "5551  ***NOTE: THE OCEAN INFINITY POOL (\"POOL 1\"0 WI...   \n",
       "5552                                                      \n",
       "5553                                                      \n",
       "5554                                                      \n",
       "\n",
       "                                            description  \\\n",
       "0     Murphy bed, optional second bedroom available....   \n",
       "1     We are on the central city  Blue mosque 5 minu...   \n",
       "2     Clean, fully furnish, Spacious 1 bedroom flat ...   \n",
       "3     House is located 5mins walk from Sham Shui Po ...   \n",
       "4     This spacious, light filled studio has everyth...   \n",
       "...                                                 ...   \n",
       "5550  Kadıköy merkezde 2+1 dairem vardır.Çok kalabal...   \n",
       "5551  Relax Hawaiian Style in Gated Community on Oce...   \n",
       "5552   Newly renovated studio flat with full furniture.   \n",
       "5553  A bright large double room is available in a b...   \n",
       "5554  Apartamento amplo que acomoda 6 pessoas. Um qu...   \n",
       "\n",
       "                                  neighborhood_overview  \\\n",
       "0     Great neighborhood - many terrific restaurants...   \n",
       "1     Cankurtaran mahallesi akbıyık caddesi no 22 Su...   \n",
       "2                                                         \n",
       "3     Cheapest food, electronic device, clothing and...   \n",
       "4     Surry Hills is a vibrant eclectic community an...   \n",
       "...                                                 ...   \n",
       "5550                                                      \n",
       "5551  Location: Located at the south end of Lahaina ...   \n",
       "5552                                                      \n",
       "5553                                                      \n",
       "5554                                                      \n",
       "\n",
       "                                                  notes  \\\n",
       "0     My cat, Samantha, are in and out during the su...   \n",
       "1                                                         \n",
       "2                                                         \n",
       "3     Deposit of $1000 will be charged and will retu...   \n",
       "4     WiFi, Apple TV with Netflix App (for use with ...   \n",
       "...                                                 ...   \n",
       "5550                                                      \n",
       "5551  Puamana Resort requires a $10/day resort fee w...   \n",
       "5552                                                      \n",
       "5553                                                      \n",
       "5554                                                      \n",
       "\n",
       "                                                transit  \\\n",
       "0     Conveniently located near 1, 2, 3, B & C subwa...   \n",
       "1      Tram 5 minutes  metro 10 minutes  Bus 10 minutes   \n",
       "2                                                         \n",
       "3     Close to 3 different MTR Station, Sham shui Po...   \n",
       "4     Travel Card 'Opal' travel cards work on all Sy...   \n",
       "...                                                 ...   \n",
       "5550                                                      \n",
       "5551  You can walk to most attractions within Lahain...   \n",
       "5552                                                      \n",
       "5553  The flat is exactly half way between the shops...   \n",
       "5554                                                      \n",
       "\n",
       "                                                 access  ...  \\\n",
       "0                                        New York City!  ...   \n",
       "1     We have bathroom,wc,İnternet in rooms and unde...  ...   \n",
       "2                                                        ...   \n",
       "3     Living Room , Kitchen and Toilet, All cooking ...  ...   \n",
       "4     You have full use of the entire studio and com...  ...   \n",
       "...                                                 ...  ...   \n",
       "5550                                                     ...   \n",
       "5551  Guests will have access to the 3 pools in the ...  ...   \n",
       "5552                                                     ...   \n",
       "5553  Guests will have access to the full residence,...  ...   \n",
       "5554                                                     ...   \n",
       "\n",
       "                                          review_scores  \\\n",
       "0     {'review_scores_accuracy': 10, 'review_scores_...   \n",
       "1     {'review_scores_accuracy': 9, 'review_scores_c...   \n",
       "2     {'review_scores_accuracy': 10, 'review_scores_...   \n",
       "3     {'review_scores_accuracy': 10, 'review_scores_...   \n",
       "4     {'review_scores_accuracy': 10, 'review_scores_...   \n",
       "...                                                 ...   \n",
       "5550                                                 {}   \n",
       "5551  {'review_scores_accuracy': 10, 'review_scores_...   \n",
       "5552  {'review_scores_accuracy': 10, 'review_scores_...   \n",
       "5553                                                 {}   \n",
       "5554                                                 {}   \n",
       "\n",
       "                                                reviews weekly_price  \\\n",
       "0     [{'_id': '4351675', 'date': '2013-04-29 04:00:...        600.0   \n",
       "1     [{'_id': '149469150', 'date': '2017-05-04 04:0...        600.0   \n",
       "2     [{'_id': '56904633', 'date': '2015-12-19 05:00...       5000.0   \n",
       "3     [{'_id': '57191745', 'date': '2015-12-22 05:00...       1350.0   \n",
       "4     [{'_id': '123549502', 'date': '2016-12-29 05:0...        600.0   \n",
       "...                                                 ...          ...   \n",
       "5550                                                 []        600.0   \n",
       "5551  [{'_id': '68762225', 'date': '2016-04-06 04:00...        600.0   \n",
       "5552  [{'_id': '105800033', 'date': '2016-10-02 04:0...        600.0   \n",
       "5553                                                 []        600.0   \n",
       "5554                                                 []        600.0   \n",
       "\n",
       "     monthly_price reviews_per_month  \\\n",
       "0           3000.0               1.0   \n",
       "1           3000.0               1.0   \n",
       "2           3000.0               1.0   \n",
       "3           5000.0               1.0   \n",
       "4           3000.0               1.0   \n",
       "...            ...               ...   \n",
       "5550        3000.0               1.0   \n",
       "5551        3000.0               1.0   \n",
       "5552        3000.0               1.0   \n",
       "5553        3000.0               1.0   \n",
       "5554        3000.0               1.0   \n",
       "\n",
       "                                    coordinates availability_30  \\\n",
       "0                         [-73.96523, 40.79962]               0   \n",
       "1                           [28.98009, 41.0062]              30   \n",
       "2                         [114.15027, 22.28158]               0   \n",
       "3                           [114.1669, 22.3314]              14   \n",
       "4                        [151.21554, -33.88029]               0   \n",
       "...                                         ...             ...   \n",
       "5550                       [29.03079, 40.98563]              30   \n",
       "5551                     [-156.66752, 20.85894]               0   \n",
       "5552                      [114.20722, 22.29157]              18   \n",
       "5553                     [151.26542, -33.89298]               0   \n",
       "5554  [-43.173761316748546, -22.90833634089244]               0   \n",
       "\n",
       "     availability_60 availability_90 availability_365  \n",
       "0                  0               0               93  \n",
       "1                 60              90              365  \n",
       "2                  0               0                0  \n",
       "3                 24              40              220  \n",
       "4                  0               0                0  \n",
       "...              ...             ...              ...  \n",
       "5550              60              90              365  \n",
       "5551               8              31              258  \n",
       "5552              48              78              353  \n",
       "5553               0               0                0  \n",
       "5554               0               0                0  \n",
       "\n",
       "[5555 rows x 47 columns]"
      ]
     },
     "execution_count": 80,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "if 'availability' in data.columns:\n",
    "    data['availability_30'] = data['availability'].apply(lambda x: x.get('availability_30', {}))\n",
    "    data['availability_60'] = data['availability'].apply(lambda x: x.get('availability_60', {}))\n",
    "    data['availability_90'] = data['availability'].apply(lambda x: x.get('availability_90', {}))\n",
    "    data['availability_365'] = data['availability'].apply(lambda x: x.get('availability_365', {}))\n",
    "else:\n",
    "    data['availability_30'] = None\n",
    "    data['availability_60'] = None\n",
    "    data['availability_90'] = None\n",
    "    data['availability_365'] = None\n",
    "\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "id": "614705ca",
   "metadata": {},
   "outputs": [],
   "source": [
    "data = data[data['coordinates'].apply(lambda x: isinstance(x, list) and len(x) == 2)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "id": "d8cb68be",
   "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>listing_url</th>\n",
       "      <th>name</th>\n",
       "      <th>summary</th>\n",
       "      <th>space</th>\n",
       "      <th>description</th>\n",
       "      <th>neighborhood_overview</th>\n",
       "      <th>notes</th>\n",
       "      <th>transit</th>\n",
       "      <th>access</th>\n",
       "      <th>...</th>\n",
       "      <th>review_scores</th>\n",
       "      <th>reviews</th>\n",
       "      <th>weekly_price</th>\n",
       "      <th>monthly_price</th>\n",
       "      <th>reviews_per_month</th>\n",
       "      <th>coordinates</th>\n",
       "      <th>availability_30</th>\n",
       "      <th>availability_60</th>\n",
       "      <th>availability_90</th>\n",
       "      <th>availability_365</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1003530</td>\n",
       "      <td>https://www.airbnb.com/rooms/1003530</td>\n",
       "      <td>New York City - Upper West Side Apt</td>\n",
       "      <td></td>\n",
       "      <td>Murphy bed, optional second bedroom available....</td>\n",
       "      <td>Murphy bed, optional second bedroom available....</td>\n",
       "      <td>Great neighborhood - many terrific restaurants...</td>\n",
       "      <td>My cat, Samantha, are in and out during the su...</td>\n",
       "      <td>Conveniently located near 1, 2, 3, B &amp; C subwa...</td>\n",
       "      <td>New York City!</td>\n",
       "      <td>...</td>\n",
       "      <td>{'review_scores_accuracy': 10, 'review_scores_...</td>\n",
       "      <td>[{'_id': '4351675', 'date': '2013-04-29 04:00:...</td>\n",
       "      <td>600.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[-73.96523, 40.79962]</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>10133554</td>\n",
       "      <td>https://www.airbnb.com/rooms/10133554</td>\n",
       "      <td>Double and triple rooms Blue mosque</td>\n",
       "      <td></td>\n",
       "      <td>We are on the central city  Blue mosque 5 minu...</td>\n",
       "      <td>We are on the central city  Blue mosque 5 minu...</td>\n",
       "      <td>Cankurtaran mahallesi akbıyık caddesi no 22 Su...</td>\n",
       "      <td></td>\n",
       "      <td>Tram 5 minutes  metro 10 minutes  Bus 10 minutes</td>\n",
       "      <td>We have bathroom,wc,İnternet in rooms and unde...</td>\n",
       "      <td>...</td>\n",
       "      <td>{'review_scores_accuracy': 9, 'review_scores_c...</td>\n",
       "      <td>[{'_id': '149469150', 'date': '2017-05-04 04:0...</td>\n",
       "      <td>600.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[28.98009, 41.0062]</td>\n",
       "      <td>30</td>\n",
       "      <td>60</td>\n",
       "      <td>90</td>\n",
       "      <td>365</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>10059872</td>\n",
       "      <td>https://www.airbnb.com/rooms/10059872</td>\n",
       "      <td>Soho Cozy, Spacious and Convenient</td>\n",
       "      <td>Clean, fully furnish, Spacious 1 bedroom flat ...</td>\n",
       "      <td></td>\n",
       "      <td>Clean, fully furnish, Spacious 1 bedroom flat ...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>{'review_scores_accuracy': 10, 'review_scores_...</td>\n",
       "      <td>[{'_id': '56904633', 'date': '2015-12-19 05:00...</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[114.15027, 22.28158]</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>10084023</td>\n",
       "      <td>https://www.airbnb.com/rooms/10084023</td>\n",
       "      <td>City center private room with bed</td>\n",
       "      <td>House is located 5mins walk from Sham Shui Po ...</td>\n",
       "      <td>The house is old fashion type, and paint the w...</td>\n",
       "      <td>House is located 5mins walk from Sham Shui Po ...</td>\n",
       "      <td>Cheapest food, electronic device, clothing and...</td>\n",
       "      <td>Deposit of $1000 will be charged and will retu...</td>\n",
       "      <td>Close to 3 different MTR Station, Sham shui Po...</td>\n",
       "      <td>Living Room , Kitchen and Toilet, All cooking ...</td>\n",
       "      <td>...</td>\n",
       "      <td>{'review_scores_accuracy': 10, 'review_scores_...</td>\n",
       "      <td>[{'_id': '57191745', 'date': '2015-12-22 05:00...</td>\n",
       "      <td>1350.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[114.1669, 22.3314]</td>\n",
       "      <td>14</td>\n",
       "      <td>24</td>\n",
       "      <td>40</td>\n",
       "      <td>220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>10091713</td>\n",
       "      <td>https://www.airbnb.com/rooms/10091713</td>\n",
       "      <td>Surry Hills Studio - Your Perfect Base in Sydney</td>\n",
       "      <td>This spacious, light filled studio has everyth...</td>\n",
       "      <td>Comfortable studio with a great layout. The ba...</td>\n",
       "      <td>This spacious, light filled studio has everyth...</td>\n",
       "      <td>Surry Hills is a vibrant eclectic community an...</td>\n",
       "      <td>WiFi, Apple TV with Netflix App (for use with ...</td>\n",
       "      <td>Travel Card 'Opal' travel cards work on all Sy...</td>\n",
       "      <td>You have full use of the entire studio and com...</td>\n",
       "      <td>...</td>\n",
       "      <td>{'review_scores_accuracy': 10, 'review_scores_...</td>\n",
       "      <td>[{'_id': '123549502', 'date': '2016-12-29 05:0...</td>\n",
       "      <td>600.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[151.21554, -33.88029]</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</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",
       "      <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>5550</th>\n",
       "      <td>9985696</td>\n",
       "      <td>https://www.airbnb.com/rooms/9985696</td>\n",
       "      <td>Kadıköy-Altıyol</td>\n",
       "      <td>Kadıköy merkezde 2+1 dairem vardır.Çok kalabal...</td>\n",
       "      <td></td>\n",
       "      <td>Kadıköy merkezde 2+1 dairem vardır.Çok kalabal...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>{}</td>\n",
       "      <td>[]</td>\n",
       "      <td>600.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[29.03079, 40.98563]</td>\n",
       "      <td>30</td>\n",
       "      <td>60</td>\n",
       "      <td>90</td>\n",
       "      <td>365</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5551</th>\n",
       "      <td>9993190</td>\n",
       "      <td>https://www.airbnb.com/rooms/9993190</td>\n",
       "      <td>Just Steps from the Ocean at Premier Platinum ...</td>\n",
       "      <td>Relax Hawaiian Style in Gated Community on Oce...</td>\n",
       "      <td>***NOTE: THE OCEAN INFINITY POOL (\"POOL 1\"0 WI...</td>\n",
       "      <td>Relax Hawaiian Style in Gated Community on Oce...</td>\n",
       "      <td>Location: Located at the south end of Lahaina ...</td>\n",
       "      <td>Puamana Resort requires a $10/day resort fee w...</td>\n",
       "      <td>You can walk to most attractions within Lahain...</td>\n",
       "      <td>Guests will have access to the 3 pools in the ...</td>\n",
       "      <td>...</td>\n",
       "      <td>{'review_scores_accuracy': 10, 'review_scores_...</td>\n",
       "      <td>[{'_id': '68762225', 'date': '2016-04-06 04:00...</td>\n",
       "      <td>600.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[-156.66752, 20.85894]</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>31</td>\n",
       "      <td>258</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5552</th>\n",
       "      <td>9887054</td>\n",
       "      <td>https://www.airbnb.com/rooms/9887054</td>\n",
       "      <td>Quarry Bay fully furnished studio C</td>\n",
       "      <td>Newly renovated studio flat with full furniture.</td>\n",
       "      <td></td>\n",
       "      <td>Newly renovated studio flat with full furniture.</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>{'review_scores_accuracy': 10, 'review_scores_...</td>\n",
       "      <td>[{'_id': '105800033', 'date': '2016-10-02 04:0...</td>\n",
       "      <td>600.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[114.20722, 22.29157]</td>\n",
       "      <td>18</td>\n",
       "      <td>48</td>\n",
       "      <td>78</td>\n",
       "      <td>353</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5553</th>\n",
       "      <td>9907907</td>\n",
       "      <td>https://www.airbnb.com/rooms/9907907</td>\n",
       "      <td>Large double room in Bondi</td>\n",
       "      <td>A bright large double room is available in a b...</td>\n",
       "      <td></td>\n",
       "      <td>A bright large double room is available in a b...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>The flat is exactly half way between the shops...</td>\n",
       "      <td>Guests will have access to the full residence,...</td>\n",
       "      <td>...</td>\n",
       "      <td>{}</td>\n",
       "      <td>[]</td>\n",
       "      <td>600.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[151.26542, -33.89298]</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5554</th>\n",
       "      <td>9936016</td>\n",
       "      <td>https://www.airbnb.com/rooms/9936016</td>\n",
       "      <td>Alugo Apartamento na Tijuca</td>\n",
       "      <td>Apartamento amplo que acomoda 6 pessoas. Um qu...</td>\n",
       "      <td></td>\n",
       "      <td>Apartamento amplo que acomoda 6 pessoas. Um qu...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>{}</td>\n",
       "      <td>[]</td>\n",
       "      <td>600.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[-43.173761316748546, -22.90833634089244]</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5555 rows × 47 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           _id                            listing_url  \\\n",
       "0      1003530   https://www.airbnb.com/rooms/1003530   \n",
       "1     10133554  https://www.airbnb.com/rooms/10133554   \n",
       "2     10059872  https://www.airbnb.com/rooms/10059872   \n",
       "3     10084023  https://www.airbnb.com/rooms/10084023   \n",
       "4     10091713  https://www.airbnb.com/rooms/10091713   \n",
       "...        ...                                    ...   \n",
       "5550   9985696   https://www.airbnb.com/rooms/9985696   \n",
       "5551   9993190   https://www.airbnb.com/rooms/9993190   \n",
       "5552   9887054   https://www.airbnb.com/rooms/9887054   \n",
       "5553   9907907   https://www.airbnb.com/rooms/9907907   \n",
       "5554   9936016   https://www.airbnb.com/rooms/9936016   \n",
       "\n",
       "                                                   name  \\\n",
       "0                   New York City - Upper West Side Apt   \n",
       "1                   Double and triple rooms Blue mosque   \n",
       "2                    Soho Cozy, Spacious and Convenient   \n",
       "3                     City center private room with bed   \n",
       "4      Surry Hills Studio - Your Perfect Base in Sydney   \n",
       "...                                                 ...   \n",
       "5550                                    Kadıköy-Altıyol   \n",
       "5551  Just Steps from the Ocean at Premier Platinum ...   \n",
       "5552                Quarry Bay fully furnished studio C   \n",
       "5553                         Large double room in Bondi   \n",
       "5554                        Alugo Apartamento na Tijuca   \n",
       "\n",
       "                                                summary  \\\n",
       "0                                                         \n",
       "1                                                         \n",
       "2     Clean, fully furnish, Spacious 1 bedroom flat ...   \n",
       "3     House is located 5mins walk from Sham Shui Po ...   \n",
       "4     This spacious, light filled studio has everyth...   \n",
       "...                                                 ...   \n",
       "5550  Kadıköy merkezde 2+1 dairem vardır.Çok kalabal...   \n",
       "5551  Relax Hawaiian Style in Gated Community on Oce...   \n",
       "5552   Newly renovated studio flat with full furniture.   \n",
       "5553  A bright large double room is available in a b...   \n",
       "5554  Apartamento amplo que acomoda 6 pessoas. Um qu...   \n",
       "\n",
       "                                                  space  \\\n",
       "0     Murphy bed, optional second bedroom available....   \n",
       "1     We are on the central city  Blue mosque 5 minu...   \n",
       "2                                                         \n",
       "3     The house is old fashion type, and paint the w...   \n",
       "4     Comfortable studio with a great layout. The ba...   \n",
       "...                                                 ...   \n",
       "5550                                                      \n",
       "5551  ***NOTE: THE OCEAN INFINITY POOL (\"POOL 1\"0 WI...   \n",
       "5552                                                      \n",
       "5553                                                      \n",
       "5554                                                      \n",
       "\n",
       "                                            description  \\\n",
       "0     Murphy bed, optional second bedroom available....   \n",
       "1     We are on the central city  Blue mosque 5 minu...   \n",
       "2     Clean, fully furnish, Spacious 1 bedroom flat ...   \n",
       "3     House is located 5mins walk from Sham Shui Po ...   \n",
       "4     This spacious, light filled studio has everyth...   \n",
       "...                                                 ...   \n",
       "5550  Kadıköy merkezde 2+1 dairem vardır.Çok kalabal...   \n",
       "5551  Relax Hawaiian Style in Gated Community on Oce...   \n",
       "5552   Newly renovated studio flat with full furniture.   \n",
       "5553  A bright large double room is available in a b...   \n",
       "5554  Apartamento amplo que acomoda 6 pessoas. Um qu...   \n",
       "\n",
       "                                  neighborhood_overview  \\\n",
       "0     Great neighborhood - many terrific restaurants...   \n",
       "1     Cankurtaran mahallesi akbıyık caddesi no 22 Su...   \n",
       "2                                                         \n",
       "3     Cheapest food, electronic device, clothing and...   \n",
       "4     Surry Hills is a vibrant eclectic community an...   \n",
       "...                                                 ...   \n",
       "5550                                                      \n",
       "5551  Location: Located at the south end of Lahaina ...   \n",
       "5552                                                      \n",
       "5553                                                      \n",
       "5554                                                      \n",
       "\n",
       "                                                  notes  \\\n",
       "0     My cat, Samantha, are in and out during the su...   \n",
       "1                                                         \n",
       "2                                                         \n",
       "3     Deposit of $1000 will be charged and will retu...   \n",
       "4     WiFi, Apple TV with Netflix App (for use with ...   \n",
       "...                                                 ...   \n",
       "5550                                                      \n",
       "5551  Puamana Resort requires a $10/day resort fee w...   \n",
       "5552                                                      \n",
       "5553                                                      \n",
       "5554                                                      \n",
       "\n",
       "                                                transit  \\\n",
       "0     Conveniently located near 1, 2, 3, B & C subwa...   \n",
       "1      Tram 5 minutes  metro 10 minutes  Bus 10 minutes   \n",
       "2                                                         \n",
       "3     Close to 3 different MTR Station, Sham shui Po...   \n",
       "4     Travel Card 'Opal' travel cards work on all Sy...   \n",
       "...                                                 ...   \n",
       "5550                                                      \n",
       "5551  You can walk to most attractions within Lahain...   \n",
       "5552                                                      \n",
       "5553  The flat is exactly half way between the shops...   \n",
       "5554                                                      \n",
       "\n",
       "                                                 access  ...  \\\n",
       "0                                        New York City!  ...   \n",
       "1     We have bathroom,wc,İnternet in rooms and unde...  ...   \n",
       "2                                                        ...   \n",
       "3     Living Room , Kitchen and Toilet, All cooking ...  ...   \n",
       "4     You have full use of the entire studio and com...  ...   \n",
       "...                                                 ...  ...   \n",
       "5550                                                     ...   \n",
       "5551  Guests will have access to the 3 pools in the ...  ...   \n",
       "5552                                                     ...   \n",
       "5553  Guests will have access to the full residence,...  ...   \n",
       "5554                                                     ...   \n",
       "\n",
       "                                          review_scores  \\\n",
       "0     {'review_scores_accuracy': 10, 'review_scores_...   \n",
       "1     {'review_scores_accuracy': 9, 'review_scores_c...   \n",
       "2     {'review_scores_accuracy': 10, 'review_scores_...   \n",
       "3     {'review_scores_accuracy': 10, 'review_scores_...   \n",
       "4     {'review_scores_accuracy': 10, 'review_scores_...   \n",
       "...                                                 ...   \n",
       "5550                                                 {}   \n",
       "5551  {'review_scores_accuracy': 10, 'review_scores_...   \n",
       "5552  {'review_scores_accuracy': 10, 'review_scores_...   \n",
       "5553                                                 {}   \n",
       "5554                                                 {}   \n",
       "\n",
       "                                                reviews weekly_price  \\\n",
       "0     [{'_id': '4351675', 'date': '2013-04-29 04:00:...        600.0   \n",
       "1     [{'_id': '149469150', 'date': '2017-05-04 04:0...        600.0   \n",
       "2     [{'_id': '56904633', 'date': '2015-12-19 05:00...       5000.0   \n",
       "3     [{'_id': '57191745', 'date': '2015-12-22 05:00...       1350.0   \n",
       "4     [{'_id': '123549502', 'date': '2016-12-29 05:0...        600.0   \n",
       "...                                                 ...          ...   \n",
       "5550                                                 []        600.0   \n",
       "5551  [{'_id': '68762225', 'date': '2016-04-06 04:00...        600.0   \n",
       "5552  [{'_id': '105800033', 'date': '2016-10-02 04:0...        600.0   \n",
       "5553                                                 []        600.0   \n",
       "5554                                                 []        600.0   \n",
       "\n",
       "     monthly_price reviews_per_month  \\\n",
       "0           3000.0               1.0   \n",
       "1           3000.0               1.0   \n",
       "2           3000.0               1.0   \n",
       "3           5000.0               1.0   \n",
       "4           3000.0               1.0   \n",
       "...            ...               ...   \n",
       "5550        3000.0               1.0   \n",
       "5551        3000.0               1.0   \n",
       "5552        3000.0               1.0   \n",
       "5553        3000.0               1.0   \n",
       "5554        3000.0               1.0   \n",
       "\n",
       "                                    coordinates availability_30  \\\n",
       "0                         [-73.96523, 40.79962]               0   \n",
       "1                           [28.98009, 41.0062]              30   \n",
       "2                         [114.15027, 22.28158]               0   \n",
       "3                           [114.1669, 22.3314]              14   \n",
       "4                        [151.21554, -33.88029]               0   \n",
       "...                                         ...             ...   \n",
       "5550                       [29.03079, 40.98563]              30   \n",
       "5551                     [-156.66752, 20.85894]               0   \n",
       "5552                      [114.20722, 22.29157]              18   \n",
       "5553                     [151.26542, -33.89298]               0   \n",
       "5554  [-43.173761316748546, -22.90833634089244]               0   \n",
       "\n",
       "     availability_60 availability_90 availability_365  \n",
       "0                  0               0               93  \n",
       "1                 60              90              365  \n",
       "2                  0               0                0  \n",
       "3                 24              40              220  \n",
       "4                  0               0                0  \n",
       "...              ...             ...              ...  \n",
       "5550              60              90              365  \n",
       "5551               8              31              258  \n",
       "5552              48              78              353  \n",
       "5553               0               0                0  \n",
       "5554               0               0                0  \n",
       "\n",
       "[5555 rows x 47 columns]"
      ]
     },
     "execution_count": 82,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "id": "6791af19",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "count     5555.000000\n",
       "mean       278.766157\n",
       "std        842.215531\n",
       "min          9.000000\n",
       "25%         70.000000\n",
       "50%        129.000000\n",
       "75%        280.000000\n",
       "max      48842.000000\n",
       "Name: price, dtype: float64"
      ]
     },
     "execution_count": 83,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['price'].describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "id": "1613f8d4",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "count    5555.000000\n",
       "mean       11.816202\n",
       "std        11.686113\n",
       "min         0.000000\n",
       "25%         0.000000\n",
       "50%         8.000000\n",
       "75%        24.000000\n",
       "max        30.000000\n",
       "Name: availability_30, dtype: float64"
      ]
     },
     "execution_count": 84,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['availability_30'].describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 85,
   "id": "dfe1ce52",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    0\n",
       "Name: availability_30, dtype: int64"
      ]
     },
     "execution_count": 85,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['availability_30'].mode()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "id": "9f886843",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "count    5555.000000\n",
       "mean       26.451305\n",
       "std        23.476011\n",
       "min         0.000000\n",
       "25%         0.000000\n",
       "50%        23.000000\n",
       "75%        52.000000\n",
       "max        60.000000\n",
       "Name: availability_60, dtype: float64"
      ]
     },
     "execution_count": 86,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['availability_60'].describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "id": "a46cd6bb",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    0\n",
       "Name: availability_60, dtype: int64"
      ]
     },
     "execution_count": 87,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['availability_60'].mode()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 88,
   "id": "90cb309b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "count    5555.000000\n",
       "mean       42.758056\n",
       "std        35.226897\n",
       "min         0.000000\n",
       "25%         0.000000\n",
       "50%        43.000000\n",
       "75%        80.000000\n",
       "max        90.000000\n",
       "Name: availability_90, dtype: float64"
      ]
     },
     "execution_count": 88,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['availability_90'].describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 89,
   "id": "63b0f49d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    0\n",
       "Name: availability_90, dtype: int64"
      ]
     },
     "execution_count": 89,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['availability_90'].mode()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 90,
   "id": "aa96b64c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "count    5555.000000\n",
       "mean      173.105671\n",
       "std       139.841893\n",
       "min         0.000000\n",
       "25%        17.000000\n",
       "50%       171.000000\n",
       "75%       317.000000\n",
       "max       365.000000\n",
       "Name: availability_365, dtype: float64"
      ]
     },
     "execution_count": 90,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['availability_365'].describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "id": "bc290ef0",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    0\n",
       "Name: availability_365, dtype: int64"
      ]
     },
     "execution_count": 91,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['availability_365'].mode()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "9ddf0cf6",
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import folium\n",
    "\n",
    "os.makedirs(os.path.dirname('visualizations/airbnb_map.html'), exist_ok=True)\n",
    "    \n",
    "\n",
    "    # Calculate mean latitude and longitude\n",
    "mean_lat = data['coordinates'].apply(lambda x: x[1]).mean()\n",
    "mean_lon = data['coordinates'].apply(lambda x: x[0]).mean()\n",
    "\n",
    "    # Create the map\n",
    "m = folium.Map(location=[mean_lat, mean_lon], zoom_start=12)\n",
    "    \n",
    "    # Add markers for each listing\n",
    "for _, row in data.iterrows():\n",
    "    folium.CircleMarker(\n",
    "    location=(row['coordinates'][1], row['coordinates'][0]),\n",
    "    radius=5,\n",
    "    color='blue',\n",
    "    fill=True,\n",
    "    fill_color='blue'\n",
    "    ).add_to(m)\n",
    "    \n",
    "    # Save the map as an HTML file\n",
    "m.save('visualizations/airbnb_map.html')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 111,
   "id": "fe60ce45",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAA14AAAIjCAYAAAATE8pZAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjcuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8pXeV/AAAACXBIWXMAAA9hAAAPYQGoP6dpAABkPUlEQVR4nO3deXgUVdrG4ac7SWchJGFLQiSECMgmqKBiRkCUDBEjbjiKoiCiCAYVUFHUQQYXFGVVBB2VoMKw+CkyIEskLIOsIsgqgiJBIQkKIazZur4/oAuaAIaQ0NWd331dfc2k6nT1W+kahodT5y2bYRiGAAAAAADlxu7pAgAAAADA1xG8AAAAAKCcEbwAAAAAoJwRvAAAAACgnBG8AAAAAKCcEbwAAAAAoJwRvAAAAACgnBG8AAAAAKCcEbwAAAAAoJwRvADgLwwePFg2m+2ifFbbtm3Vtm1b8+dFixbJZrPp888/vyif/9BDD6lOnToX5bNK69ChQ3rkkUcUHR0tm82mvn37lslxz+d7/vXXX2Wz2fT222+XyWeX1zHPxGazafDgwWVyLFfNqampZXK8i+1i/m8bAAheACqU1NRU2Ww28xUUFKSYmBglJSVpzJgxOnjwYJl8zu7duzV48GCtW7euTI5XlqxcW0m8/vrrSk1NVe/evfXpp5/qwQcf/Mv3FBUVKSYmRjabTXPmzLkIVV585RnSJ0+erFGjRpX5cS+E63xdr4CAAF166aXq2rWrfvnlF0+XBwDF+Hu6AADwhCFDhig+Pl4FBQXKzMzUokWL1LdvX40YMUIzZ85Us2bNzLEvvfSSnn/++fM6/u7du/Wvf/1LderU0ZVXXlni982fP/+8Pqc0zlXbv//9bzmdznKv4UKkp6fruuuu08svv3xe79mzZ4/q1KmjSZMmqUOHDsXGlOZ79kZHjx6Vv//5/d//5MmTtXHjxmKzi3FxcTp69KgCAgLKsMLz8+STT+qaa65RQUGBvv/+e33wwQeaPXu2NmzYoJiYmHO+t6J85wCsgeAFoELq0KGDrr76avPngQMHKj09Xbfeeqtuu+02bdmyRcHBwZIkf3//8/6L6vk6cuSIQkJC5HA4yvVz/oon/wJdUtnZ2WrcuPF5veezzz5T8+bN1a1bN73wwgs6fPiwKlWq5DamJN+z0+lUfn7+eddsJUFBQWV2LNessSe1bt1ad999tySpe/fuuuyyy/Tkk09q4sSJGjhw4Bnf4/r+L8b/tgHAhVsNAeCEm266Sf/85z+1c+dOffbZZ+b2M60DSUtLU6tWrRQREaHQ0FA1aNBAL7zwgqTjt0Bdc801ko7/RdB1K5RrHUzbtm11+eWXa82aNWrTpo1CQkLM956+xsulqKhIL7zwgqKjo1WpUiXddttt2rVrl9uYOnXq6KGHHir23lOP+Ve1nWmN1+HDh/X0008rNjZWgYGBatCggd5++20ZhuE2zmazqU+fPpoxY4Yuv/xyBQYGqkmTJpo7d+6Zf+Gnyc7OVo8ePRQVFaWgoCBdccUVmjhxornfdWvZjh07NHv2bLP2X3/99ZzHPXr0qL788kt17txZ99xzj44ePaqvvvqq2Lgzfc+uc5o0aZKaNGmiwMDAYuczcuRIxcXFKTg4WDfccIM2btzotv+hhx5SaGiofv/9d91xxx0KDQ1VjRo19Mwzz6ioqOiMNf/VMS/E6Wu8Dh48qL59+6pOnToKDAxUZGSk/v73v+v777+XdPz6mT17tnbu3Gn+zl3XyJnWeJ3P+f7555968MEHFRYWpoiICHXr1k0//PDDBa0bu+mmmyRJO3bskHTye928ebPuv/9+ValSRa1atXLbd7rPPvtM1157rUJCQlSlShW1adOm2Gz0nDlz1Lp1a1WqVEmVK1dWcnKyNm3a5DYmMzNT3bt3V61atRQYGKiaNWvq9ttv/8trFoBv4p95AOAUDz74oF544QXNnz9fjz766BnHbNq0SbfeequaNWumIUOGKDAwUNu3b9e3334rSWrUqJGGDBmiQYMGqWfPnmrdurUk6W9/+5t5jD///FMdOnRQ586d9cADDygqKuqcdb322muy2Wx67rnnlJ2drVGjRikxMVHr1q0zZ+ZKoiS1ncowDN12221auHChevTooSuvvFLz5s3Ts88+q99//10jR450G7906VJ98cUXevzxx1W5cmWNGTNGnTp1UkZGhqpVq3bWuo4ePaq2bdtq+/bt6tOnj+Lj4zV9+nQ99NBDysnJ0VNPPaVGjRrp008/Vb9+/VSrVi09/fTTkqQaNWqc85xnzpypQ4cOqXPnzoqOjlbbtm01adIk3X///SX6naWnp2vatGnq06ePqlev7hZMP/nkEx08eFApKSk6duyYRo8erZtuukkbNmxw+06LioqUlJSkli1b6u2339Y333yj4cOHq27duurdu7fb55X0mGWlV69e+vzzz9WnTx81btxYf/75p5YuXaotW7aoefPmevHFF3XgwAH99ttv5vcdGhp6zmOW5HydTqc6duyoVatWqXfv3mrYsKG++uordevW7YLO5+eff5akYtfbP/7xD9WvX1+vv/56sX80ONW//vUvDR48WH/72980ZMgQORwOrVy5Uunp6Wrfvr0k6dNPP1W3bt2UlJSkN998U0eOHNG4cePUqlUrrV271rxGOnXqpE2bNumJJ55QnTp1lJ2drbS0NGVkZFi+iQ2AcmAAQAUyYcIEQ5KxevXqs44JDw83rrrqKvPnl19+2Tj1j8uRI0cakoy9e/ee9RirV682JBkTJkwotu+GG24wJBnjx48/474bbrjB/HnhwoWGJOOSSy4xcnNzze3Tpk0zJBmjR482t8XFxRndunX7y2Oeq7Zu3boZcXFx5s8zZswwJBmvvvqq27i7777bsNlsxvbt281tkgyHw+G27YcffjAkGe+8806xzzrVqFGjDEnGZ599Zm7Lz883EhISjNDQULdzj4uLM5KTk895vFPdeuutxvXXX2/+/MEHHxj+/v5Gdna227jTv2fXOdntdmPTpk1u23fs2GFIMoKDg43ffvvN3L5y5UpDktGvXz9zW7du3QxJxpAhQ9yOcdVVVxktWrQo1THPxHWtTJ8+/ZzjJBkvv/yy+XN4eLiRkpJyzvckJye7XRen13zqtVTS8/2///s/Q5IxatQoc1tRUZFx0003nfX6PJXrfD/++GNj7969xu7du43Zs2cbderUMWw2m/m/cdf3et999xU7xunf+bZt2wy73W7ceeedRlFRkdtYp9NpGIZhHDx40IiIiDAeffRRt/2ZmZlGeHi4uX3//v2GJOOtt94653kAqDi41RAAThMaGnrO7oYRERGSpK+++qrUjSgCAwPVvXv3Eo/v2rWrKleubP589913q2bNmvr6669L9fkl9fXXX8vPz09PPvmk2/ann35ahmEU6xCYmJiounXrmj83a9ZMYWFhf9ll7uuvv1Z0dLTuu+8+c1tAQICefPJJHTp0SIsXLy5V/X/++afmzZvndtxOnTrJZrNp2rRpJTrGDTfccNY1ZXfccYcuueQS8+drr71WLVu2POP30qtXL7efW7dufcbfy/kcsyxERERo5cqV2r17d5ke96/Od+7cuQoICHCbWbbb7UpJSTmvz3n44YdVo0YNxcTEKDk5WYcPH9bEiRPd1nCeqZ4zmTFjhpxOpwYNGiS73f2vSK5bEtPS0pSTk6P77rtPf/zxh/ny8/NTy5YttXDhQklScHCwHA6HFi1apP3795/XOQHwTQQvADjNoUOH3ELO6e69915df/31euSRRxQVFaXOnTtr2rRp5xXCLrnkkvNqpFG/fn23n202m+rVq1fua0V27typmJiYYr+PRo0amftPVbt27WLHqFKlyl/+xXPnzp2qX79+sb/snu1zSmrq1KkqKCjQVVddpe3bt2v79u3at2+fWrZsqUmTJpXoGPHx8Wfdd/r3IkmXXXZZse8lKCio2C2RZ/u9lPSYZWXYsGHauHGjYmNjde2112rw4MEX3I69JOe7c+dO1axZUyEhIW7j6tWrd16fNWjQIKWlpSk9PV3r16/X7t27z/iIgXN9jy4///yz7Hb7OZu3bNu2TdLxtWQ1atRwe82fP1/Z2dmSjv/jyptvvqk5c+YoKipKbdq00bBhw5SZmXle5wfAd7DGCwBO8dtvv+nAgQPn/MtfcHCwlixZooULF2r27NmaO3eupk6dqptuuknz58+Xn5/fX37O+azLKqmzPQi2qKioRDWVhbN9jnGONTXlyRWurr/++jPu/+WXX3TppZee8xhl8V1drN9/adxzzz1q3bq1vvzyS82fP19vvfWW3nzzTX3xxRdnbLtfEhfzfJs2barExMS/HFdW/5tz/QPLp59+qujo6GL7T+2S2LdvX3Xs2FEzZszQvHnz9M9//lNDhw5Venq6rrrqqjKpB4D3YMYLAE7x6aefSpKSkpLOOc5ut6tdu3YaMWKENm/erNdee03p6enmbUZnC0Gl5fpXdhfDMLR9+3a3BfpVqlRRTk5OsfeePlt0PrXFxcVp9+7dxW69/PHHH839ZSEuLk7btm0rNmt4IZ+zY8cOLVu2TH369NH06dPdXlOnTpXD4dDkyZMvqO7TvxdJ+umnny6ocUJ5HPOv1KxZU48//rhmzJihHTt2qFq1anrttdfM/WV9PUvHv9M9e/boyJEjbtu3b99e5p9VUnXr1pXT6dTmzZvPOUaSIiMjlZiYWOx1elfSunXr6umnn9b8+fO1ceNG5efna/jw4eV5GgAsiuAFACekp6frlVdeUXx8vLp06XLWcfv27Su2zfUg4ry8PEkynxF1piBUGq5Ody6ff/659uzZ4zYjUbduXa1YscLtOVOzZs0q1nb+fGq75ZZbVFRUpHfffddt+8iRI2Wz2Uo9I3Kmz8nMzNTUqVPNbYWFhXrnnXcUGhqqG2644byP6ZrtGjBggO6++2631z333KMbbrihxLcbns2MGTP0+++/mz+vWrVKK1euvKDfS3kc82yKiop04MABt22RkZGKiYkxr2Xp+DVz+rgLlZSUpIKCAv373/82tzmdTo0dO7ZMP+d83HHHHbLb7RoyZEixfwRwzdomJSUpLCxMr7/+ugoKCoodY+/evZKOP5vv2LFjbvvq1q2rypUru/1uAVQc3GoIoEKaM2eOfvzxRxUWFiorK0vp6elKS0tTXFycZs6cec6Hwg4ZMkRLlixRcnKy4uLilJ2drffee0+1atUynw9Ut25dRUREaPz48apcubIqVaqkli1blmidyZlUrVpVrVq1Uvfu3ZWVlaVRo0apXr16bo0JHnnkEX3++ee6+eabdc899+jnn3/WZ5995tbs4nxr69ixo2688Ua9+OKL+vXXX3XFFVdo/vz5+uqrr9S3b99ixy6tnj176v3339dDDz2kNWvWqE6dOvr888/17bffatSoUedcc3c2kyZN0pVXXqnY2Ngz7r/tttv0xBNP6Pvvv1fz5s1LVXe9evXUqlUr9e7dW3l5eRo1apSqVaumAQMGlOp4ZXHM//u//zNnCk/VrVu3Yr+LgwcPqlatWrr77rt1xRVXKDQ0VN98841Wr17tNivTokULTZ06Vf3799c111yj0NBQdezYsdTnKB0POddee62efvppbd++XQ0bNtTMmTPNf9goj1m2v1KvXj29+OKLeuWVV9S6dWvdddddCgwM1OrVqxUTE6OhQ4cqLCxM48aN04MPPqjmzZurc+fOqlGjhjIyMjR79mxdf/31evfdd/XTTz+pXbt2uueee9S4cWP5+/vryy+/VFZWljp37nzRzw2A5xG8AFRIgwYNkiQ5HA5VrVpVTZs21ahRo9S9e/e//Ev+bbfdpl9//VUff/yx/vjjD1WvXl033HCD/vWvfyk8PFzS8Y58EydO1MCBA9WrVy8VFhZqwoQJpQ5eL7zwgtavX6+hQ4fq4MGDateund577z23xgRJSUkaPny4RowYob59++rqq6/WrFmzzOdduZxPbXa7XTNnztSgQYM0depUTZgwQXXq1NFbb71V7LgXIjg4WIsWLdLzzz+viRMnKjc3Vw0aNNCECRPO+FDov/L999/rxx9/1D//+c+zjunYsaOeeOIJffbZZ6UOXl27dpXdbteoUaOUnZ2ta6+9Vu+++65q1qxZquOVxTGnTJlyxu1t27YtFrxCQkL0+OOPa/78+friiy/kdDpVr149vffee27PF3v88ce1bt06TZgwwXy484UGLz8/P82ePVtPPfWUJk6cKLvdrjvvvFMvv/yyrr/++nP+40d5GjJkiOLj4/XOO+/oxRdfVEhIiJo1a+bWsOP+++9XTEyM3njjDb311lvKy8vTJZdcotatW5vdSmNjY3XfffdpwYIF+vTTT+Xv76+GDRtq2rRp6tSpk0fODYBn2QxPrXgGAAA4zYwZM3TnnXdq6dKlZ22KAgDeiOAFAAA84ujRo27dBouKitS+fXt99913yszMLJfunwDgKdxqCAAAPOKJJ57Q0aNHlZCQoLy8PH3xxRdatmyZXn/9dUIXAJ/DjBcAAPCIyZMna/jw4dq+fbuOHTumevXqqXfv3urTp4+nSwOAMkfwAgAAAIByxnO8AAAAAKCcEbwAAAAAoJzRXKMEnE6ndu/ercqVK3vkgY4AAAAArMEwDB08eFAxMTGy20s+j0XwKoHdu3cXe+gkAAAAgIpr165dqlWrVonHE7xKoHLlypKO/3LDwsI8XA0AAAAAT8nNzVVsbKyZEUqK4FUCrtsLw8LCCF4AAAAAznsJEs01AAAAAKCcEbwAAAAAoJwRvAAAAACgnBG8AAAAAKCcEbwAAAAAoJwRvAAAAACgnBG8AAAAAKCcEbwAAAAAoJwRvAAAAACgnBG8AAAAAKCcEbwAAAAAoJwRvAAAAACgnBG8AAAAAKCcEbwAAAAAoJwRvAAAAACgnBG8AAAAAKCcEbwAAAAAoJz5e7oAnJ/dOUe14fcDqlbJoavrVPV0OQAAAABKgBkvLzNr/W499ukaTVy+09OlAAAAACghgpeXqV01RJK0a98RD1cCAAAAoKQIXl4mluAFAAAAeB2Cl5dxBa8/D+frcF6hh6sBAAAAUBIELy8TFhSgiJAASdKu/cx6AQAAAN6A4OWFXOu8Mv4keAEAAADegODlhVy3G2awzgsAAADwCgQvLxRbhQYbAAAAgDcheHkhs6X8/qMergQAAABASRC8vFBtbjUEAAAAvArBywvFVg2WdPxWQ6fT8HA1AAAAAP4KwcsLxUQEy26T8gqd2nsoz9PlAAAAAPgLBC8vFOBnV0zEyVkvAAAAANZG8PJSrPMCAAAAvAfBy0u5WsoTvAAAAADrI3h5qdrVXM/yoqU8AAAAYHUELy8VW5WHKAMAAADeguDlpVjjBQAAAHgPgpeXiq1yvKthZu4xHSso8nA1AAAAAM6F4OWlqlZyqJLDT5L0ew7rvAAAAAArI3h5KZvNZq7z4nZDAAAAwNo8GryKior0z3/+U/Hx8QoODlbdunX1yiuvyDAMc4xhGBo0aJBq1qyp4OBgJSYmatu2bW7H2bdvn7p06aKwsDBFRESoR48eOnTokNuY9evXq3Xr1goKClJsbKyGDRt2Uc6xPNFgAwAAAPAOHg1eb775psaNG6d3331XW7Zs0Ztvvqlhw4bpnXfeMccMGzZMY8aM0fjx47Vy5UpVqlRJSUlJOnbsmDmmS5cu2rRpk9LS0jRr1iwtWbJEPXv2NPfn5uaqffv2iouL05o1a/TWW29p8ODB+uCDDy7q+ZY1s8HGnwQvAAAAwMr8Pfnhy5Yt0+23367k5GRJUp06dfSf//xHq1atknR8tmvUqFF66aWXdPvtt0uSPvnkE0VFRWnGjBnq3LmztmzZorlz52r16tW6+uqrJUnvvPOObrnlFr399tuKiYnRpEmTlJ+fr48//lgOh0NNmjTRunXrNGLECLeA5m1cwWvXfoIXAAAAYGUenfH629/+pgULFuinn36SJP3www9aunSpOnToIEnasWOHMjMzlZiYaL4nPDxcLVu21PLlyyVJy5cvV0REhBm6JCkxMVF2u10rV640x7Rp00YOh8Mck5SUpK1bt2r//v3F6srLy1Nubq7by4pOtpSnuQYAAABgZR6d8Xr++eeVm5urhg0bys/PT0VFRXrttdfUpUsXSVJmZqYkKSoqyu19UVFR5r7MzExFRka67ff391fVqlXdxsTHxxc7hmtflSpV3PYNHTpU//rXv8roLMtPbNXjLeV37TsiwzBks9k8XBEAAACAM/HojNe0adM0adIkTZ48Wd9//70mTpyot99+WxMnTvRkWRo4cKAOHDhgvnbt2uXRes6mVpXjM16H8gqVc6TAw9UAAAAAOBuPzng9++yzev7559W5c2dJUtOmTbVz504NHTpU3bp1U3R0tCQpKytLNWvWNN+XlZWlK6+8UpIUHR2t7Oxst+MWFhZq37595vujo6OVlZXlNsb1s2vMqQIDAxUYGFg2J1mOggL8VKNyoPYezNPvOUdVpZLjr98EAAAA4KLz6IzXkSNHZLe7l+Dn5yen0ylJio+PV3R0tBYsWGDuz83N1cqVK5WQkCBJSkhIUE5OjtasWWOOSU9Pl9PpVMuWLc0xS5YsUUHByVmhtLQ0NWjQoNhtht4mOOD4Q5TzCp0ergQAAADA2Xg0eHXs2FGvvfaaZs+erV9//VVffvmlRowYoTvvvFPS8YcE9+3bV6+++qpmzpypDRs2qGvXroqJidEdd9whSWrUqJFuvvlmPfroo1q1apW+/fZb9enTR507d1ZMTIwk6f7775fD4VCPHj20adMmTZ06VaNHj1b//v09deplxs9+fF2X85RnnwEAAACwFo/eavjOO+/on//8px5//HFlZ2crJiZGjz32mAYNGmSOGTBggA4fPqyePXsqJydHrVq10ty5cxUUFGSOmTRpkvr06aN27drJbrerU6dOGjNmjLk/PDxc8+fPV0pKilq0aKHq1atr0KBBXt1K3uVE7lKRk+AFAAAAWJXNMJgq+Su5ubkKDw/XgQMHFBYW5uly3LQfuVg/ZR3S5Eda6m/1qnu6HAAAAMCnlTYbePRWQ1w4+4kW8kXkZwAAAMCyCF5ezrXGq5BbDQEAAADLInh5OX9Xcw2CFwAAAGBZBC8vZz8RvGiuAQAAAFgXwcvL+dloJw8AAABYHcHLy52c8fJwIQAAAADOiuDl5fzoaggAAABYHsHLy/nRXAMAAACwPIKXl7PTTh4AAACwPIKXl6OdPAAAAGB9BC8vZ2eNFwAAAGB5BC8v53fiG+Q5XgAAAIB1Eby8nNlcgxkvAAAAwLIIXl7OvNWQGS8AAADAsgheXs7PTvACAAAArI7g5eX8mPECAAAALI/g5eXMGS/WeAEAAACWRfDycn48xwsAAACwPIKXl7Oba7w8XAgAAACAsyJ4eTk/HqAMAAAAWB7By8txqyEAAABgfQQvL+d6jlchwQsAAACwLIKXl/P3OzHjxa2GAAAAgGURvLycned4AQAAAJZH8PJyfie+QYIXAAAAYF0ELy/n6mrIrYYAAACAdRG8vNzJ53gRvAAAAACrInh5OWa8AAAAAOsjeHk514xXYRHBCwAAALAqgpeX83fdasiMFwAAAGBZBC8v53cieDlZ4wUAAABYFsHLy5nP8SJ3AQAAAJZF8PJyzHgBAAAA1kfw8nK0kwcAAACsj+Dl5Vzt5AsJXgAAAIBlEby8nN+Jb5DneAEAAADWRfDycn72418htxoCAAAA1kXw8nLMeAEAAADWR/DycmY7eWa8AAAAAMsieHk5P7oaAgAAAJZH8PJyrq6G3GoIAAAAWJdHg1edOnVks9mKvVJSUiRJx44dU0pKiqpVq6bQ0FB16tRJWVlZbsfIyMhQcnKyQkJCFBkZqWeffVaFhYVuYxYtWqTmzZsrMDBQ9erVU2pq6sU6xXLneo4X7eQBAAAA6/Jo8Fq9erX27NljvtLS0iRJ//jHPyRJ/fr103//+19Nnz5dixcv1u7du3XXXXeZ7y8qKlJycrLy8/O1bNkyTZw4UampqRo0aJA5ZseOHUpOTtaNN96odevWqW/fvnrkkUc0b968i3uy5cSc8SJ4AQAAAJZlMwzr3KPWt29fzZo1S9u2bVNubq5q1KihyZMn6+6775Yk/fjjj2rUqJGWL1+u6667TnPmzNGtt96q3bt3KyoqSpI0fvx4Pffcc9q7d68cDoeee+45zZ49Wxs3bjQ/p3PnzsrJydHcuXNLVFdubq7Cw8N14MABhYWFlf2JX4CFW7PVfcJqXX5JmGY90drT5QAAAAA+rbTZwDJrvPLz8/XZZ5/p4Ycfls1m05o1a1RQUKDExERzTMOGDVW7dm0tX75ckrR8+XI1bdrUDF2SlJSUpNzcXG3atMkcc+oxXGNcxziTvLw85ebmur2sys/saujhQgAAAACclWWC14wZM5STk6OHHnpIkpSZmSmHw6GIiAi3cVFRUcrMzDTHnBq6XPtd+841Jjc3V0ePHj1jLUOHDlV4eLj5io2NvdDTKzeurobcaggAAABYl2WC10cffaQOHTooJibG06Vo4MCBOnDggPnatWuXp0s6K/M5Xta5YxQAAADAafw9XYAk7dy5U998842++OILc1t0dLTy8/OVk5PjNuuVlZWl6Ohoc8yqVavcjuXqenjqmNM7IWZlZSksLEzBwcFnrCcwMFCBgYEXfF4XAzNeAAAAgPVZYsZrwoQJioyMVHJysrmtRYsWCggI0IIFC8xtW7duVUZGhhISEiRJCQkJ2rBhg7Kzs80xaWlpCgsLU+PGjc0xpx7DNcZ1DG/nd+IbpJ08AAAAYF0eD15Op1MTJkxQt27d5O9/cgIuPDxcPXr0UP/+/bVw4UKtWbNG3bt3V0JCgq677jpJUvv27dW4cWM9+OCD+uGHHzRv3jy99NJLSklJMWesevXqpV9++UUDBgzQjz/+qPfee0/Tpk1Tv379PHK+Zc281ZDgBQAAAFiWx281/Oabb5SRkaGHH3642L6RI0fKbrerU6dOysvLU1JSkt577z1zv5+fn2bNmqXevXsrISFBlSpVUrdu3TRkyBBzTHx8vGbPnq1+/fpp9OjRqlWrlj788EMlJSVdlPMrb/7249nZyRovAAAAwLIs9Rwvq7Lyc7w27T6g5DFLFVk5UKteTPzrNwAAAAAoNa9/jhdKx2yuQX4GAAAALIvg5eX8WOMFAAAAWB7By8vZT8x40dUQAAAAsC6Cl5dzzXjxHC8AAADAugheXs61xquINV4AAACAZRG8vJzZXMPp4UIAAAAAnBXBy8sx4wUAAABYH8HLy9npaggAAABYHsHLy7lmvCQabAAAAABWRfDycq6uhhIt5QEAAACrInh5Ofsp36CTdV4AAACAJRG8vJz/KcmLdV4AAACANRG8vNypM150NgQAAACsieDl5U5d40VzDQAAAMCaCF5e7tSuhtxqCAAAAFgTwcvL2Ww2uSa9uNUQAAAAsCaClw/w4yHKAAAAgKURvHyA3U7wAgAAAKyM4OUD/E8EL6fTw4UAAAAAOCOClw8wbzVkjRcAAABgSQQvH8CthgAAAIC1Ebx8gKulvJMZLwAAAMCSCF4+wH7iVsPCIoIXAAAAYEUELx/gd+JbZMYLAAAAsCaClw/gOV4AAACAtRG8fICfH10NAQAAACsjePkA14yXkxkvAAAAwJIIXj6AdvIAAACAtRG8fAAPUAYAAACsjeDlA/yY8QIAAAAsjeDlA+x0NQQAAAAsjeDlA1wzXjzHCwAAALAmgpcPOHmroYcLAQAAAHBGBC8fwBovAAAAwNoIXj7AfI4XtxoCAAAAlkTw8gH2E99iITNeAAAAgCURvHyA2VyD4AUAAABYEsHLB9BOHgAAALA2gpcP8Hc112CNFwAAAGBJBC8fwK2GAAAAgLURvHyAeashM14AAACAJXk8eP3+++964IEHVK1aNQUHB6tp06b67rvvzP2GYWjQoEGqWbOmgoODlZiYqG3btrkdY9++ferSpYvCwsIUERGhHj166NChQ25j1q9fr9atWysoKEixsbEaNmzYRTm/i4EZLwAAAMDaPBq89u/fr+uvv14BAQGaM2eONm/erOHDh6tKlSrmmGHDhmnMmDEaP368Vq5cqUqVKikpKUnHjh0zx3Tp0kWbNm1SWlqaZs2apSVLlqhnz57m/tzcXLVv315xcXFas2aN3nrrLQ0ePFgffPDBRT3f8mI/EbxoJw8AAABYk78nP/zNN99UbGysJkyYYG6Lj483/7thGBo1apReeukl3X777ZKkTz75RFFRUZoxY4Y6d+6sLVu2aO7cuVq9erWuvvpqSdI777yjW265RW+//bZiYmI0adIk5efn6+OPP5bD4VCTJk20bt06jRgxwi2geSs/uhoCAAAAlubRGa+ZM2fq6quv1j/+8Q9FRkbqqquu0r///W9z/44dO5SZmanExERzW3h4uFq2bKnly5dLkpYvX66IiAgzdElSYmKi7Ha7Vq5caY5p06aNHA6HOSYpKUlbt27V/v37i9WVl5en3Nxct5eVmbcassYLAAAAsCSPBq9ffvlF48aNU/369TVv3jz17t1bTz75pCZOnChJyszMlCRFRUW5vS8qKsrcl5mZqcjISLf9/v7+qlq1qtuYMx3j1M841dChQxUeHm6+YmNjy+Bsy48reBU5PVwIAAAAgDPyaPByOp1q3ry5Xn/9dV111VXq2bOnHn30UY0fP96TZWngwIE6cOCA+dq1a5dH6/krrlsNmfECAAAArMmjwatmzZpq3Lix27ZGjRopIyNDkhQdHS1JysrKchuTlZVl7ouOjlZ2drbb/sLCQu3bt89tzJmOcepnnCowMFBhYWFuLyuz21njBQAAAFiZR4PX9ddfr61bt7pt++mnnxQXFyfpeKON6OhoLViwwNyfm5urlStXKiEhQZKUkJCgnJwcrVmzxhyTnp4up9Opli1bmmOWLFmigoICc0xaWpoaNGjg1kHRW/md+BYJXgAAAIA1eTR49evXTytWrNDrr7+u7du3a/Lkyfrggw+UkpIiSbLZbOrbt69effVVzZw5Uxs2bFDXrl0VExOjO+64Q9LxGbKbb75Zjz76qFatWqVvv/1Wffr0UefOnRUTEyNJuv/+++VwONSjRw9t2rRJU6dO1ejRo9W/f39PnXqZoqshAAAAYG0ebSd/zTXX6Msvv9TAgQM1ZMgQxcfHa9SoUerSpYs5ZsCAATp8+LB69uypnJwctWrVSnPnzlVQUJA5ZtKkSerTp4/atWsnu92uTp06acyYMeb+8PBwzZ8/XykpKWrRooWqV6+uQYMG+UQreemUWw1Z4wUAAABYks0w+Nv6X8nNzVV4eLgOHDhgyfVer87arA+X7tBjbS7VwFsaebocAAAAwGeVNht49FZDlA0/P241BAAAAKyM4OUDzDVeTF4CAAAAlkTw8gGuByg7mfECAAAALIng5QPsJ2a8CgleAAAAgCURvHyAOePFrYYAAACAJRG8fIAreNFcAwAAALAmgpcPsJsPUPZwIQAAAADOiODlA/y51RAAAACwNIKXD7BzqyEAAABgaQQvH3Di+ck8xwsAAACwKIKXDzCbaxQRvAAAAAArInj5APNWQ2a8AAAAAEsiePkAvxNdDZ2s8QIAAAAsieDlA5jxAgAAAKyN4OUD/OlqCAAAAFgawcsH+PEcLwAAAMDSCF4+wG5jxgsAAACwMoKXD/DjVkMAAADA0ghePoAZLwAAAMDaCF4+wJzxIncBAAAAlkTw8gGuroY8xwsAAACwJoKXD7CzxgsAAACwNIKXD/Cz0U4eAAAAsDKClw+wn/gWC5nxAgAAACyJ4OUDzBkvghcAAABgSQQvH3CyqyHBCwAAALAigpcPoLkGAAAAYG0ELx9AO3kAAADA2vw9XQBKJyMjQ3/88Yck6Zf9BZKkY/n5+v7778/5vurVq6t27drlXh8AAACAkwheXigjI0MNGzXS0SNHJEkBNeoo5uF3tXfvn2rR4pZzvjc4JEQ/btlC+AIAAAAuIoKXF/rjjz909MgRdXnuLUXVrqvcfJvSMqXgsAj1H/vFWd+XlfGzJr35rP744w+CFwAAAHAREby8WFTtuqpVv4n2Hc6XMnfKZvdTrfqXebosAAAAAKehuYYPOPEYL9FNHgAAALAmgpcPsLseoEzyAgAAACyJ4OUDzBkvz5YBAAAA4CwIXj7AruPJy2DGCwAAALAkgpcPcM148fxkAAAAwJoIXj7AFbwkZr0AAAAAKyJ4+QD7KcmLWS8AAADAeghePoAZLwAAAMDaCF4+wKaTyYvYBQAAAFhPqYLXL7/8UiYfPnjwYNlsNrdXw4YNzf3Hjh1TSkqKqlWrptDQUHXq1ElZWVlux8jIyFBycrJCQkIUGRmpZ599VoWFhW5jFi1apObNmyswMFD16tVTampqmdRvFfZTZrx4lhcAAABgPaUKXvXq1dONN96ozz77TMeOHbugApo0aaI9e/aYr6VLl5r7+vXrp//+97+aPn26Fi9erN27d+uuu+4y9xcVFSk5OVn5+flatmyZJk6cqNTUVA0aNMgcs2PHDiUnJ+vGG2/UunXr1LdvXz3yyCOaN2/eBdVtJbZT7jUkdwEAAADWU6rg9f3336tZs2bq37+/oqOj9dhjj2nVqlWlKsDf31/R0dHmq3r16pKkAwcO6KOPPtKIESN00003qUWLFpowYYKWLVumFStWSJLmz5+vzZs367PPPtOVV16pDh066JVXXtHYsWOVn58vSRo/frzi4+M1fPhwNWrUSH369NHdd9+tkSNHlqpeK2LGCwAAALC2UgWvK6+8UqNHj9bu3bv18ccfa8+ePWrVqpUuv/xyjRgxQnv37i3xsbZt26aYmBhdeuml6tKlizIyMiRJa9asUUFBgRITE82xDRs2VO3atbV8+XJJ0vLly9W0aVNFRUWZY5KSkpSbm6tNmzaZY049hmuM6xhnkpeXp9zcXLeXlTHjBQAAAFjbBTXX8Pf311133aXp06frzTff1Pbt2/XMM88oNjZWXbt21Z49e875/pYtWyo1NVVz587VuHHjtGPHDrVu3VoHDx5UZmamHA6HIiIi3N4TFRWlzMxMSVJmZqZb6HLtd+0715jc3FwdPXr0jHUNHTpU4eHh5is2NrbEvxNPcWUvghcAAABgPRcUvL777js9/vjjqlmzpkaMGKFnnnlGP//8s9LS0rR7927dfvvt53x/hw4d9I9//EPNmjVTUlKSvv76a+Xk5GjatGkXUtYFGzhwoA4cOGC+du3a5dF6SsJ+orOhk76GAAAAgOX4l+ZNI0aM0IQJE7R161bdcsst+uSTT3TLLbfIbj+e4+Lj45Wamqo6deqc13EjIiJ02WWXafv27fr73/+u/Px85eTkuM16ZWVlKTo6WpIUHR1dbG2Zq+vhqWNO74SYlZWlsLAwBQcHn7GOwMBABQYGnlftnmazSTKY8QIAAACsqFQzXuPGjdP999+vnTt3asaMGbr11lvN0OUSGRmpjz766LyOe+jQIf3888+qWbOmWrRooYCAAC1YsMDcv3XrVmVkZCghIUGSlJCQoA0bNig7O9sck5aWprCwMDVu3Ngcc+oxXGNcx/AV9hP3GvIAZQAAAMB6SjXjtW3btr8c43A41K1bt3OOeeaZZ9SxY0fFxcVp9+7devnll+Xn56f77rtP4eHh6tGjh/r376+qVasqLCxMTzzxhBISEnTddddJktq3b6/GjRvrwQcf1LBhw5SZmamXXnpJKSkp5oxVr1699O6772rAgAF6+OGHlZ6ermnTpmn27NmlOXXLYo0XAAAAYF2lCl4TJkxQaGio/vGPf7htnz59uo4cOfKXgcvlt99+03333ac///xTNWrUUKtWrbRixQrVqFFDkjRy5EjZ7XZ16tRJeXl5SkpK0nvvvWe+38/PT7NmzVLv3r2VkJCgSpUqqVu3bhoyZIg5Jj4+XrNnz1a/fv00evRo1apVSx9++KGSkpJKc+qW5QpetJMHAAAArKdUwWvo0KF6//33i22PjIxUz549Sxy8pkyZcs79QUFBGjt2rMaOHXvWMXFxcfr666/PeZy2bdtq7dq1JarJW9lczTXIXQAAAIDllGqNV0ZGhuLj44ttj4uLM5/DhYvL9RBlg66GAAAAgOWUKnhFRkZq/fr1xbb/8MMPqlat2gUXhfNnM5treLgQAAAAAMWUKnjdd999evLJJ7Vw4UIVFRWpqKhI6enpeuqpp9S5c+eyrhElYKe5BgAAAGBZpVrj9corr+jXX39Vu3bt5O9//BBOp1Ndu3bV66+/XqYFomRcM1401wAAAACsp1TBy+FwaOrUqXrllVf0ww8/KDg4WE2bNlVcXFxZ14cSop08AAAAYF2lCl4ul112mS677LKyqgUXwC5mvAAAAACrKlXwKioqUmpqqhYsWKDs7Gw5nU63/enp6WVSHErOnPHybBkAAAAAzqBUweupp55SamqqkpOTdfnll5vri+A5J281JHoBAAAAVlOq4DVlyhRNmzZNt9xyS1nXg1Ky23iAMgAAAGBVpWon73A4VK9evbKuBReAGS8AAADAukoVvJ5++mmNHj2av+RbiGvGi28EAAAAsJ5S3Wq4dOlSLVy4UHPmzFGTJk0UEBDgtv+LL74ok+JQcq5Vdk7uNQQAAAAsp1TBKyIiQnfeeWdZ14ILYGPGCwAAALCsUgWvCRMmlHUduECuNV48xwsAAACwnlKt8ZKkwsJCffPNN3r//fd18OBBSdLu3bt16NChMisOJWeu8SJ3AQAAAJZTqhmvnTt36uabb1ZGRoby8vL097//XZUrV9abb76pvLw8jR8/vqzrxF842dXQs3UAAAAAKK5UM15PPfWUrr76au3fv1/BwcHm9jvvvFMLFiwos+JQcuZzvFjlBQAAAFhOqWa8/ve//2nZsmVyOBxu2+vUqaPff/+9TArD+XF1NWTGCwAAALCeUs14OZ1OFRUVFdv+22+/qXLlyhdcFM4fzTUAAAAA6ypV8Grfvr1GjRpl/myz2XTo0CG9/PLLuuWWW8qqNpwHmmsAAAAA1lWqWw2HDx+upKQkNW7cWMeOHdP999+vbdu2qXr16vrPf/5T1jWiBE421yB5AQAAAFZTquBVq1Yt/fDDD5oyZYrWr1+vQ4cOqUePHurSpYtbsw1cPDZmvAAAAADLKlXwkiR/f3898MADZVkLLoDrnlG6GgIAAADWU6rg9cknn5xzf9euXUtVDEqPGS8AAADAukoVvJ566im3nwsKCnTkyBE5HA6FhIQQvDzAzgOUAQAAAMsqVVfD/fv3u70OHTqkrVu3qlWrVjTX8BDXjBft5AEAAADrKVXwOpP69evrjTfeKDYbhovDxowXAAAAYFllFryk4w03du/eXZaHRAnZxYwXAAAAYFWlWuM1c+ZMt58Nw9CePXv07rvv6vrrry+TwnB+zBkvz5YBAAAA4AxKFbzuuOMOt59tNptq1Kihm266ScOHDy+LunCe7GZXQ6IXAAAAYDWlCl5Op7Os68AFcs14OcldAAAAgOWU6RoveM7J5hokLwAAAMBqSjXj1b9//xKPHTFiRGk+AufpZDt5DxcCAAAAoJhSBa+1a9dq7dq1KigoUIMGDSRJP/30k/z8/NS8eXNznCsMoPy5pi6Z8QIAAACsp1TBq2PHjqpcubImTpyoKlWqSDr+UOXu3burdevWevrpp8u0SPw1V8gldgEAAADWU6o1XsOHD9fQoUPN0CVJVapU0auvvkpXQw852VyD6AUAAABYTamCV25urvbu3Vts+969e3Xw4MELLgrn72Q7eQ8XAgAAAKCYUgWvO++8U927d9cXX3yh3377Tb/99pv+7//+Tz169NBdd91V1jWiBE52NfRsHQAAAACKK9Uar/Hjx+uZZ57R/fffr4KCguMH8vdXjx499NZbb5VpgSgZu9nVkOQFAAAAWE2pgldISIjee+89vfXWW/r5558lSXXr1lWlSpXKtDiUnKt/JLkLAAAAsJ4LeoDynj17tGfPHtWvX1+VKlWilbkHmbca0tcQAAAAsJxSBa8///xT7dq102WXXaZbbrlFe/bskST16NGj1K3k33jjDdlsNvXt29fcduzYMaWkpKhatWoKDQ1Vp06dlJWV5fa+jIwMJScnKyQkRJGRkXr22WdVWFjoNmbRokVq3ry5AgMDVa9ePaWmppaqRiuz8wBlAAAAwLJKFbz69eungIAAZWRkKCQkxNx+7733au7cued9vNWrV+v9999Xs2bNin3Of//7X02fPl2LFy/W7t273Zp3FBUVKTk5Wfn5+Vq2bJkmTpyo1NRUDRo0yByzY8cOJScn68Ybb9S6devUt29fPfLII5o3b14pzty6TjbXIHkBAAAAVlOq4DV//ny9+eabqlWrltv2+vXra+fOned1rEOHDqlLly7697//7fZcsAMHDuijjz7SiBEjdNNNN6lFixaaMGGCli1bphUrVph1bN68WZ999pmuvPJKdejQQa+88orGjh2r/Px8SccbgcTHx2v48OFq1KiR+vTpo7vvvlsjR44szalbFu3kAQAAAOsqVfA6fPiw20yXy759+xQYGHhex0pJSVFycrISExPdtq9Zs0YFBQVu2xs2bKjatWtr+fLlkqTly5eradOmioqKMsckJSUpNzdXmzZtMsecfuykpCTzGGeSl5en3Nxct5fVmQ9QZo0XAAAAYDmlCl6tW7fWJ598Yv5ss9nkdDo1bNgw3XjjjSU+zpQpU/T9999r6NChxfZlZmbK4XAoIiLCbXtUVJQyMzPNMaeGLtd+175zjcnNzdXRo0fPWNfQoUMVHh5uvmJjY0t8Tp5iO9HX0HB6uBAAAAAAxZSqnfywYcPUrl07fffdd8rPz9eAAQO0adMm7du3T99++22JjrFr1y499dRTSktLU1BQUGnKKDcDBw5U//79zZ9zc3MtH77szHgBAAAAllWqGa/LL79cP/30k1q1aqXbb79dhw8f1l133aW1a9eqbt26JTrGmjVrlJ2drebNm8vf31/+/v5avHixxowZI39/f0VFRSk/P185OTlu78vKylJ0dLQkKTo6uliXQ9fPfzUmLCxMwcHBZ6wtMDBQYWFhbi+rs7HGCwAAALCs857xKigo0M0336zx48frxRdfLPUHt2vXThs2bHDb1r17dzVs2FDPPfecYmNjFRAQoAULFqhTp06SpK1btyojI0MJCQmSpISEBL322mvKzs5WZGSkJCktLU1hYWFq3LixOebrr792+5y0tDTzGL7iZFdDz9YBAAAAoLjzDl4BAQFav379BX9w5cqVdfnll7ttq1SpkqpVq2Zu79Gjh/r376+qVasqLCxMTzzxhBISEnTddddJktq3b6/GjRvrwQcf1LBhw5SZmamXXnpJKSkpZpOPXr166d1339WAAQP08MMPKz09XdOmTdPs2bMv+BysxGyuQfICAAAALKdUtxo+8MAD+uijj8q6lmJGjhypW2+9VZ06dVKbNm0UHR2tL774wtzv5+enWbNmyc/PTwkJCXrggQfUtWtXDRkyxBwTHx+v2bNnKy0tTVdccYWGDx+uDz/8UElJSeVe/8VktpP3cB0AAAAAiitVc43CwkJ9/PHH+uabb9SiRQtVqlTJbf+IESNKVcyiRYvcfg4KCtLYsWM1duzYs74nLi6u2K2Ep2vbtq3Wrl1bqpq8xYkJL2a8AAAAAAs6r+D1yy+/qE6dOtq4caOaN28uSfrpp5/cxriaPODi4gHKAAAAgHWdV/CqX7++9uzZo4ULF0qS7r33Xo0ZM6bYc7Jw8Z1srkHyAgAAAKzmvNZ4nf6X+jlz5ujw4cNlWhBKxzXT6CR3AQAAAJZTquYaLsyuWIedGS8AAADAss4reNlstmJruFjTZQ020dUQAAAAsKrzWuNlGIYeeugh8xlZx44dU69evYp1NTy15TsuDjsPUAYAAAAs67yCV7du3dx+fuCBB8q0GJTeyTVeJC8AAADAas4reE2YMKG86sAFsjHjBQAAAFjWBTXXgHXYmfECAAAALIvg5SOY8QIAAACsi+DlI1y9JQ36GgIAAACWQ/DyEXYeoAwAAABYFsHLR9h4gDIAAABgWQQvH8GMFwAAAGBdBC8f4Zrxkpj1AgAAAKyG4OUjbKckL3IXAAAAYC0ELx9x6hfppLMhAAAAYCkELx/BjBcAAABgXQQvH2F3W+PluToAAAAAFEfw8hGnzng5SV4AAACApRC8fISNGS8AAADAsghePuKU3MWMFwAAAGAxBC8fYbPZzPBF7AIAAACsheDlQ1y3G/IAZQAAAMBaCF4+xNVgg9wFAAAAWAvBy4e4WsqzxgsAAACwFoKXD2HGCwAAALAmgpcPcX2ZzHgBAAAA1kLw8iHmjJeH6wAAAADgjuDlQ052NfRsHQAAAADcEbx8iP1E8uJWQwAAAMBaCF4+hBkvAAAAwJoIXj7Ebq7xInkBAAAAVkLw8iEnJrzkdHq0DAAAAACnIXj5EPNWQ2a8AAAAAEshePmQk801PFwIAAAAADcELx9ysrkGyQsAAACwEoKXDzEfoEzuAgAAACyF4OVDzOYarPECAAAALIXg5UPszHgBAAAAlkTw8iGuNV5OkhcAAABgKR4NXuPGjVOzZs0UFhamsLAwJSQkaM6cOeb+Y8eOKSUlRdWqVVNoaKg6deqkrKwst2NkZGQoOTlZISEhioyM1LPPPqvCwkK3MYsWLVLz5s0VGBioevXqKTU19WKc3kXHjBcAAABgTR4NXrVq1dIbb7yhNWvW6LvvvtNNN92k22+/XZs2bZIk9evXT//97381ffp0LV68WLt379Zdd91lvr+oqEjJycnKz8/XsmXLNHHiRKWmpmrQoEHmmB07dig5OVk33nij1q1bp759++qRRx7RvHnzLvr5lreTXQ09WwcAAAAAd/6e/PCOHTu6/fzaa69p3LhxWrFihWrVqqWPPvpIkydP1k033SRJmjBhgho1aqQVK1bouuuu0/z587V582Z98803ioqK0pVXXqlXXnlFzz33nAYPHiyHw6Hx48crPj5ew4cPlyQ1atRIS5cu1ciRI5WUlHTRz7k80U4eAAAAsCbLrPEqKirSlClTdPjwYSUkJGjNmjUqKChQYmKiOaZhw4aqXbu2li9fLklavny5mjZtqqioKHNMUlKScnNzzVmz5cuXux3DNcZ1jDPJy8tTbm6u28sb2E/0NXR6uA4AAAAA7jwevDZs2KDQ0FAFBgaqV69e+vLLL9W4cWNlZmbK4XAoIiLCbXxUVJQyMzMlSZmZmW6hy7Xfte9cY3Jzc3X06NEz1jR06FCFh4ebr9jY2LI41XLHjBcAAABgTR4PXg0aNNC6deu0cuVK9e7dW926ddPmzZs9WtPAgQN14MAB87Vr1y6P1lNSruYaTnIXAAAAYCkeXeMlSQ6HQ/Xq1ZMktWjRQqtXr9bo0aN17733Kj8/Xzk5OW6zXllZWYqOjpYkRUdHa9WqVW7Hc3U9PHXM6Z0Qs7KyFBYWpuDg4DPWFBgYqMDAwDI5v4uJGS8AAADAmjw+43U6p9OpvLw8tWjRQgEBAVqwYIG5b+vWrcrIyFBCQoIkKSEhQRs2bFB2drY5Ji0tTWFhYWrcuLE55tRjuMa4juFLbLSTBwAAACzJozNeAwcOVIcOHVS7dm0dPHhQkydP1qJFizRv3jyFh4erR48e6t+/v6pWraqwsDA98cQTSkhI0HXXXSdJat++vRo3bqwHH3xQw4YNU2Zmpl566SWlpKSYM1a9evXSu+++qwEDBujhhx9Wenq6pk2bptmzZ3vy1MuFK0XzAGUAAADAWjwavLKzs9W1a1ft2bNH4eHhatasmebNm6e///3vkqSRI0fKbrerU6dOysvLU1JSkt577z3z/X5+fpo1a5Z69+6thIQEVapUSd26ddOQIUPMMfHx8Zo9e7b69eun0aNHq1atWvrwww99rpW8dMqMl4frAAAAAODOo8Hro48+Ouf+oKAgjR07VmPHjj3rmLi4OH399dfnPE7btm21du3aUtXoTXiAMgAAAGBNllvjhdI72dWQ5AUAAABYCcHLhzDjBQAAAFgTwcuHuIIXM14AAACAtRC8fIhdtJMHAAAArIjg5UPMWw3pawgAAABYCsHLh9jM5hoeLgQAAACAG4KXD7GbzTVIXgAAAICVELx8CDNeAAAAgDURvHwIM14AAACANRG8fIiNroYAAACAJRG8fIj5HC+6GgIAAACWQvDyIXYbM14AAACAFRG8fIj5HC+CFwAAAGApBC8fYqO5BgAAAGBJBC8fYqedPAAAAGBJBC8fcmLCixkvAAAAwGIIXj7EnPHycB0AAAAA3BG8fAhrvAAAAABrInj5EBvt5AEAAABLInj5EPMByiQvAAAAwFIIXj7ELma8AAAAACsiePkQu2vGSyQvAAAAwEoIXj6ENV4AAACANRG8fIg548UTlAEAAABLIXj5EH+/419nIcELAAAAsBSClw9xnAhe+UU8QhkAAACwEoKXDwnwO36vYQHBCwAAALAUgpcPCfA//nUWFHKrIQAAAGAlBC8f4rrVsKDIKYPWhgAAAIBlELx8SMCJ4GWIBhsAAACAlRC8fIj/iTVeEuu8AAAAACshePkQu80mf7urwQYzXgAAAIBVELx8jONEg438Qma8AAAAAKsgePmYgFMabAAAAACwBoKXj+FZXgAAAID1ELx8jGvGK5/gBQAAAFgGwcvHnHyWF801AAAAAKsgePmYgBPNNQporgEAAABYBsHLx7jWeHGrIQAAAGAdBC8f46CrIQAAAGA5BC8fE8AaLwAAAMByPBq8hg4dqmuuuUaVK1dWZGSk7rjjDm3dutVtzLFjx5SSkqJq1aopNDRUnTp1UlZWltuYjIwMJScnKyQkRJGRkXr22WdVWFjoNmbRokVq3ry5AgMDVa9ePaWmppb36XkEz/ECAAAArMejwWvx4sVKSUnRihUrlJaWpoKCArVv316HDx82x/Tr10///e9/NX36dC1evFi7d+/WXXfdZe4vKipScnKy8vPztWzZMk2cOFGpqakaNGiQOWbHjh1KTk7WjTfeqHXr1qlv37565JFHNG/evIt6vheDg+YaAAAAgOX4e/LD586d6/ZzamqqIiMjtWbNGrVp00YHDhzQRx99pMmTJ+umm26SJE2YMEGNGjXSihUrdN1112n+/PnavHmzvvnmG0VFRenKK6/UK6+8oueee06DBw+Ww+HQ+PHjFR8fr+HDh0uSGjVqpKVLl2rkyJFKSkq66OddnmiuAQAAAFiPpdZ4HThwQJJUtWpVSdKaNWtUUFCgxMREc0zDhg1Vu3ZtLV++XJK0fPlyNW3aVFFRUeaYpKQk5ebmatOmTeaYU4/hGuM6xuny8vKUm5vr9vIWrPECAAAArMcywcvpdKpv3766/vrrdfnll0uSMjMz5XA4FBER4TY2KipKmZmZ5phTQ5drv2vfucbk5ubq6NGjxWoZOnSowsPDzVdsbGyZnOPFwBovAAAAwHosE7xSUlK0ceNGTZkyxdOlaODAgTpw4ID52rVrl6dLKjFXO3luNQQAAACsw6NrvFz69OmjWbNmacmSJapVq5a5PTo6Wvn5+crJyXGb9crKylJ0dLQ5ZtWqVW7Hc3U9PHXM6Z0Qs7KyFBYWpuDg4GL1BAYGKjAwsEzO7WIL8D++xosZLwAAAMA6PDrjZRiG+vTpoy+//FLp6emKj49329+iRQsFBARowYIF5ratW7cqIyNDCQkJkqSEhARt2LBB2dnZ5pi0tDSFhYWpcePG5phTj+Ea4zqGLzFvNSxkjRcAAABgFR6d8UpJSdHkyZP11VdfqXLlyuaarPDwcAUHBys8PFw9evRQ//79VbVqVYWFhemJJ55QQkKCrrvuOklS+/bt1bhxYz344IMaNmyYMjMz9dJLLyklJcWcterVq5feffddDRgwQA8//LDS09M1bdo0zZ4922PnXl4cp6zxMgxDNpvNwxUBAAAA8OiM17hx43TgwAG1bdtWNWvWNF9Tp041x4wcOVK33nqrOnXqpDZt2ig6OlpffPGFud/Pz0+zZs2Sn5+fEhIS9MADD6hr164aMmSIOSY+Pl6zZ89WWlqarrjiCg0fPlwffvihz7WSl07OeBmSCp3MegEAAABW4NEZL8P462AQFBSksWPHauzYsWcdExcXp6+//vqcx2nbtq3Wrl173jV6G9dzvKTjs16uIAYAAADAc/hbuY+x2Wxm+OJZXgAAAIA1ELx8kGuWK7+QzoYAAACAFRC8fBAPUQYAAACsheDlg07eakjwAgAAAKyA4OWDzFsNCV4AAACAJRC8fJDD33WrIc01AAAAACsgePkgc40XzTUAAAAASyB4+SDXGi9uNQQAAACsgeDlgxx0NQQAAAAsheDlg062k2eNFwAAAGAFBC8fFODPjBcAAABgJQQvH+SguQYAAABgKQQvH0RzDQAAAMBaCF4+iDVeAAAAgLUQvHxQAF0NAQAAAEshePkg1xovbjUEAAAArIHg5YMC/I+v8WLGCwAAALAGgpcPMm81LGSNFwAAAGAFBC8f5DhljZdhEL4AAAAATyN4+SDXjJchqdBJ8AIAAAA8jeDlg1zP8ZJY5wUAAABYAcHLB9lsNjN88SwvAAAAwPMIXj7KdbthfiEzXgAAAICnEbx8FA9RBgAAAKyD4OWjHAQvAAAAwDIIXj7KtcYrn+AFAAAAeBzBy0cF+LtmvGiuAQAAAHgawctHmWu8aK4BAAAAeBzBy0dxqyEAAABgHQQvH0VzDQAAAMA6CF4+6mQ7edZ4AQAAAJ5G8PJRJ5trMOMFAAAAeBrBy0c5aK4BAAAAWAbBy0fRXAMAAACwDoKXj3KwxgsAAACwDIKXjwqgqyEAAABgGQQvH+UKXtxqCAAAAHgewctHBfgfX+PFjBcAAADgeQQvH2XealjIGi8AAADA0whePspxyhovwyB8AQAAAJ5E8PJRrhkvQ1Khk+AFAAAAeJJHg9eSJUvUsWNHxcTEyGazacaMGW77DcPQoEGDVLNmTQUHBysxMVHbtm1zG7Nv3z516dJFYWFhioiIUI8ePXTo0CG3MevXr1fr1q0VFBSk2NhYDRs2rLxPzeNcz/GSWOcFAAAAeJpHg9fhw4d1xRVXaOzYsWfcP2zYMI0ZM0bjx4/XypUrValSJSUlJenYsWPmmC5dumjTpk1KS0vTrFmztGTJEvXs2dPcn5ubq/bt2ysuLk5r1qzRW2+9pcGDB+uDDz4o9/PzJJvNZoYvnuUFAAAAeJa/Jz+8Q4cO6tChwxn3GYahUaNG6aWXXtLtt98uSfrkk08UFRWlGTNmqHPnztqyZYvmzp2r1atX6+qrr5YkvfPOO7rlllv09ttvKyYmRpMmTVJ+fr4+/vhjORwONWnSROvWrdOIESPcApovCvCzq6CoSPmFzHgBAAAAnmTZNV47duxQZmamEhMTzW3h4eFq2bKlli9fLklavny5IiIizNAlSYmJibLb7Vq5cqU5pk2bNnI4HOaYpKQkbd26Vfv37z/jZ+fl5Sk3N9ft5Y14iDIAAABgDZYNXpmZmZKkqKgot+1RUVHmvszMTEVGRrrt9/f3V9WqVd3GnOkYp37G6YYOHarw8HDzFRsbe+En5AEOHqIMAAAAWIJlg5cnDRw4UAcOHDBfu3bt8nRJpRIS6CdJOnSs0MOVAAAAABWbZYNXdHS0JCkrK8tte1ZWlrkvOjpa2dnZbvsLCwu1b98+tzFnOsapn3G6wMBAhYWFub28UURwgCQp52iBhysBAAAAKjbLBq/4+HhFR0drwYIF5rbc3FytXLlSCQkJkqSEhATl5ORozZo15pj09HQ5nU61bNnSHLNkyRIVFJwMH2lpaWrQoIGqVKlykc7GMyJCjq9ryzmS7+FKAAAAgIrNo8Hr0KFDWrdundatWyfpeEONdevWKSMjQzabTX379tWrr76qmTNnasOGDeratatiYmJ0xx13SJIaNWqkm2++WY8++qhWrVqlb7/9Vn369FHnzp0VExMjSbr//vvlcDjUo0cPbdq0SVOnTtXo0aPVv39/D531xRN+YsbrADNeAAAAgEd5tJ38d999pxtvvNH82RWGunXrptTUVA0YMECHDx9Wz549lZOTo1atWmnu3LkKCgoy3zNp0iT16dNH7dq1k91uV6dOnTRmzBhzf3h4uObPn6+UlBS1aNFC1atX16BBg3y+lbwkRYScDF6GwbO8AAAAAE/xaPBq27btOQOBzWbTkCFDNGTIkLOOqVq1qiZPnnzOz2nWrJn+97//lbpObxUWFCCbjj9A+Uh+kafLAQAAACosy67xwoXzs9tUOeh4tqbBBgAAAOA5BC8fF+663fAIwQsAAADwFIKXj4sIPtHZ8CidDQEAAABPIXj5uAg6GwIAAAAeR/Dyca5bDXO41RAAAADwGIKXj3PNeOUcLRAd5QEAAADPIHj5ONdDlPMLncp3ergYAAAAoIIiePk4fz+7QgOPt5Q/XGjzcDUAAABAxUTwqgBcs16HCF4AAACARxC8KoCIEw02Dhd6uBAAAACggiJ4VQDmjFcBM14AAACAJxC8KoAIbjUEAAAAPIrgVQFEhDgk0VwDAAAA8BSCVwXgutUwz2mTzRHs4WoAAACAiofgVQE4/O0KDvCTJPlH1PRwNQAAAEDFQ/CqIFydDQOqELwAAACAi43gVUG4Gmz4V4nxcCUAAABAxUPwqiDCmfECAAAAPIbgVUFEBB/vbMiMFwAAAHDxEbwqiKqVjgcvR1RdFRQZHq4GAAAAqFgIXhVE9VCHguyG7I5g/fhHvqfLAQAAACoUglcFYbPZFBXslCStzczzcDUAAABAxULwqkCigo7fYvg9wQsAAAC4qAheFUhkkFOGs0gZBwq158BRT5cDAAAAVBgErwok0E/K37NNkrTkp70ergYAAACoOAheFczRHWskSYu2ErwAAACAi4XgVcEc/eV48Fq67Q8VFDk9XA0AAABQMRC8Kpj8zO2q7LDpYF6h1u3K8XQ5AAAAQIVA8KpoDKeujA6UJC3amu3hYgAAAICKgeBVAbmC12IabAAAAAAXBcGrArrqRPDa+Huu9h7kmV4AAABAeSN4VUARQX66/JIwSdJ/f9jt4WoAAAAA30fwqqA6X1NbkjR24XYdyiv0cDUAAACAbyN4VVD3XhOr+OqV9OfhfP17yS+eLgcAAADwaQSvCirAz65nkxpIkj783y+s9QIAAADKkb+nC8DFt2XLFklSlGGoXtUAbd9XoEFTl+nR5uFnfU/16tVVu3bti1UiAAAA4FMIXhVI7r7j7eMfeOABc1tg7aaKvm+ovt6aqw+fvV+FOZlnfG9wSIh+3LKF8AUAAACUAsGrAjl6KFeSlPzYi2rQrIW5fWm2U1nH/HXVUx/ommqFCvJzf19Wxs+a9Oaz+uOPPwheAAAAQCkQvCqgajFxqlW/iflzu+g8TVmdoexjds3PDNTVdaqqeWyE/P1YAggAAACUBYIXVKNyoDo1r6XFP+1V9sE8Lf/5T63/LUe1IkJULdQhHbXJHlTZ02UCAAAAXovgBUlSTESwOl8Tq61ZB7Xs5z918FihtmYdlLIkKUCX9P5YUzcdVMPLCxXi4LIBAAAAzkeFupds7NixqlOnjoKCgtSyZUutWrXK0yVZis1mU8PoMHW9Lk63XRGjv9WtpgZRlRXqb8juCNbUTYfU9q1FmrIqQzv+OKzDPHgZAAAAKJEKM3UxdepU9e/fX+PHj1fLli01atQoJSUlaevWrYqMjPR0eZbi72dXfPVKiq9eSZK066c/9f67I3TZ3c8q+2Cenv9igzk2yN+mKkF2VQn2U0SQXRGBx7N8kSEVOg1VDgnWZbE1dElEsGIighURHKBKgf6qFOiv0EB/+dltHjlHAAAA4GKqMMFrxIgRevTRR9W9e3dJ0vjx4zV79mx9/PHHev755z1cnbUd3L9XR35cqnVDV6hy846qfEV7+VWuLrsjWMcKDe05VKQ9h4rO8u6j0qZ9Zz22w08K9rcrOMCmsEC7IoLsqhLkp2A/pwL8/eWKZTabzP9uSDpSYOhwvlOHC5wyJAX62RRgtyksNFiX1Kii8OAAhQUFyG6z6Uh+oY4UFOlofpGOnHgdzT8+Wxca5K/QwACFBvopwM8uP7vNfNltNvnbbbLbbfKzndwuSfmFTuUVOpVfWHTiP4//XGQYCvCzK9D/1JefHP52Ofztupgx0zDrLNKxAqeOFRyv1fWfgf52hQUHqHKQvyo5/I//jm022U78viXJdqLiIsNQYZFThU5DRU73/15QZKjIefxnp9OQ05CchiFJCnH4KTTQX6FBAQr0t5vHPZ3tLL+Zs4+veAxPF1DODB8/QcPHv0Hf//58m+HrX6AP8/WvzpChgkJDeUVO5RUUKb/Iqbtb1FJk5SBPl1YqFSJ45efna82aNRo4cKC5zW63KzExUcuXLy82Pi8vT3l5eebPBw4ckCTl5uaWf7ElcOjQIUnSb9s2Ke/okRK/LyvjZ0lS5q8/6edKISV+36+b10qSrmnfSbXi60v6Xcr7XUV5dhXIXwW2ABXY/JWvABXa/CUZshmGDu/fq99+2Sp7aHX5h1WXX+VqsgeGyO4Ikc0vQJJ07MRrv6TdJa7or/xWZkcCAACAdTStEaCg2CoercGVCc73Hy1sRgX4Z47du3frkksu0bJly5SQkGBuHzBggBYvXqyVK1e6jR88eLD+9a9/XewyAQAAAHiJXbt2qVatWiUeXyFmvM7XwIED1b9/f/Nnp9Opffv2qVq1arKd7d6niyg3N1exsbHatWuXwsLCPF0OvAzXDy4E1w8uBNcPLhTXEC5EWV0/hmHo4MGDiomJOa/3VYjgVb16dfn5+SkrK8tte1ZWlqKjo4uNDwwMVGBgoNu2iIiI8iyxVMLCwvhDB6XG9YMLwfWDC8H1gwvFNYQLURbXT3h4+Hm/p0K0k3c4HGrRooUWLFhgbnM6nVqwYIHbrYcAAAAAUB4qxIyXJPXv31/dunXT1VdfrWuvvVajRo3S4cOHzS6HAAAAAFBeKkzwuvfee7V3714NGjRImZmZuvLKKzV37lxFRUV5urTzFhgYqJdffrnY7ZBASXD94EJw/eBCcP3gQnEN4UJ4+vqpEF0NAQAAAMCTKsQaLwAAAADwJIIXAAAAAJQzghcAAAAAlDOCFwAAAACUM4KXlxk7dqzq1KmjoKAgtWzZUqtWrfJ0SShnS5YsUceOHRUTEyObzaYZM2a47TcMQ4MGDVLNmjUVHBysxMREbdu2zW3Mvn371KVLF4WFhSkiIkI9evTQoUOH3MasX79erVu3VlBQkGJjYzVs2LBitUyfPl0NGzZUUFCQmjZtqq+//rrMzxdla+jQobrmmmtUuXJlRUZG6o477tDWrVvdxhw7dkwpKSmqVq2aQkND1alTp2IPnM/IyFBycrJCQkIUGRmpZ599VoWFhW5jFi1apObNmyswMFD16tVTampqsXr4M8z7jBs3Ts2aNTMfOJqQkKA5c+aY+7l+UFJvvPGGbDab+vbta27j+sG5DB48WDabze3VsGFDc7/XXT8GvMaUKVMMh8NhfPzxx8amTZuMRx991IiIiDCysrI8XRrK0ddff228+OKLxhdffGFIMr788ku3/W+88YYRHh5uzJgxw/jhhx+M2267zYiPjzeOHj1qjrn55puNK664wlixYoXxv//9z6hXr55x3333mfsPHDhgREVFGV26dDE2btxo/Oc//zGCg4ON999/3xzz7bffGn5+fsawYcOMzZs3Gy+99JIREBBgbNiwodx/Byi9pKQkY8KECcbGjRuNdevWGbfccotRu3Zt49ChQ+aYXr16GbGxscaCBQuM7777zrjuuuuMv/3tb+b+wsJC4/LLLzcSExONtWvXGl9//bVRvXp1Y+DAgeaYX375xQgJCTH69+9vbN682XjnnXcMPz8/Y+7cueYY/gzzTjNnzjRmz55t/PTTT8bWrVuNF154wQgICDA2btxoGAbXD0pm1apVRp06dYxmzZoZTz31lLmd6wfn8vLLLxtNmjQx9uzZY7727t1r7ve264fg5UWuvfZaIyUlxfy5qKjIiImJMYYOHerBqnAxnR68nE6nER0dbbz11lvmtpycHCMwMND4z3/+YxiGYWzevNmQZKxevdocM2fOHMNmsxm///67YRiG8d577xlVqlQx8vLyzDHPPfec0aBBA/Pne+65x0hOTnarp2XLlsZjjz1WpueI8pWdnW1IMhYvXmwYxvHrJSAgwJg+fbo5ZsuWLYYkY/ny5YZhHA//drvdyMzMNMeMGzfOCAsLM6+ZAQMGGE2aNHH7rHvvvddISkoyf+bPMN9RpUoV48MPP+T6QYkcPHjQqF+/vpGWlmbccMMNZvDi+sFfefnll40rrrjijPu88frhVkMvkZ+frzVr1igxMdHcZrfblZiYqOXLl3uwMnjSjh07lJmZ6XZdhIeHq2XLluZ1sXz5ckVEROjqq682xyQmJsput2vlypXmmDZt2sjhcJhjkpKStHXrVu3fv98cc+rnuMZw/XmXAwcOSJKqVq0qSVqzZo0KCgrcvtuGDRuqdu3abtdQ06ZN3R44n5SUpNzcXG3atMkcc67rgz/DfENRUZGmTJmiw4cPKyEhgesHJZKSkqLk5ORi3zHXD0pi27ZtiomJ0aWXXqouXbooIyNDkndePwQvL/HHH3+oqKjI7cKRpKioKGVmZnqoKnia67s/13WRmZmpyMhIt/3+/v6qWrWq25gzHePUzzjbGK4/7+F0OtW3b19df/31uvzyyyUd/14dDociIiLcxp5+DZX2+sjNzdXRo0f5M8zLbdiwQaGhoQoMDFSvXr305ZdfqnHjxlw/+EtTpkzR999/r6FDhxbbx/WDv9KyZUulpqZq7ty5GjdunHbs2KHWrVvr4MGDXnn9+J/XaACA10pJSdHGjRu1dOlST5cCL9OgQQOtW7dOBw4c0Oeff65u3bpp8eLFni4LFrdr1y499dRTSktLU1BQkKfLgRfq0KGD+d+bNWumli1bKi4uTtOmTVNwcLAHKysdZry8RPXq1eXn51esU0tWVpaio6M9VBU8zfXdn+u6iI6OVnZ2ttv+wsJC7du3z23MmY5x6mecbQzXn3fo06ePZs2apYULF6pWrVrm9ujoaOXn5ysnJ8dt/OnXUGmvj7CwMAUHB/NnmJdzOByqV6+eWrRooaFDh+qKK67Q6NGjuX5wTmvWrFF2draaN28uf39/+fv7a/HixRozZoz8/f0VFRXF9YPzEhERocsuu0zbt2/3yj9/CF5ewuFwqEWLFlqwYIG5zel0asGCBUpISPBgZfCk+Ph4RUdHu10Xubm5WrlypXldJCQkKCcnR2vWrDHHpKeny+l0qmXLluaYJUuWqKCgwByTlpamBg0aqEqVKuaYUz/HNYbrz9oMw1CfPn305ZdfKj09XfHx8W77W7RooYCAALfvduvWrcrIyHC7hjZs2OAW4NPS0hQWFqbGjRubY851ffBnmG9xOp3Ky8vj+sE5tWvXThs2bNC6devM19VXX60uXbqY/53rB+fj0KFD+vnnn1WzZk3v/PPnvFpxwKOmTJliBAYGGqmpqcbmzZuNnj17GhEREW6dWuB7Dh48aKxdu9ZYu3atIckYMWKEsXbtWmPnzp2GYRxvJx8REWF89dVXxvr1643bb7/9jO3kr7rqKmPlypXG0qVLjfr167u1k8/JyTGioqKMBx980Ni4caMxZcoUIyQkpFg7eX9/f+Ptt982tmzZYrz88su0k/cCvXv3NsLDw41Fixa5teM9cuSIOaZXr15G7dq1jfT0dOO7774zEhISjISEBHO/qx1v+/btjXXr1hlz5841atSoccZ2vM8++6yxZcsWY+zYsWdsx8ufYd7n+eefNxYvXmzs2LHDWL9+vfH8888bNpvNmD9/vmEYXD84P6d2NTQMrh+c29NPP20sWrTI2LFjh/Htt98aiYmJRvXq1Y3s7GzDMLzv+iF4eZl33nnHqF27tuFwOIxrr73WWLFihadLQjlbuHChIanYq1u3boZhHG8p/89//tOIiooyAgMDjXbt2hlbt251O8aff/5p3HfffUZoaKgRFhZmdO/e3Th48KDbmB9++MFo1aqVERgYaFxyySXGG2+8UayWadOmGZdddpnhcDiMJk2aGLNnzy6380bZONO1I8mYMGGCOebo0aPG448/blSpUsUICQkx7rzzTmPPnj1ux/n111+NDh06GMHBwUb16tWNp59+2igoKHAbs3DhQuPKK680HA6Hcemll7p9hgt/hnmfhx9+2IiLizMcDodRo0YNo127dmboMgyuH5yf04MX1w/O5d577zVq1qxpOBwO45JLLjHuvfdeY/v27eZ+b7t+bIZhGOc3RwYAAAAAOB+s8QIAAACAckbwAgAAAIByRvACAAAAgHJG8AIAAACAckbwAgAAAIByRvACAAAAgHJG8AIAAACAckbwAgAAAIByRvACAFRIderU0ahRo8r9c9q0aaPJkycX275o0SKlpqYW2/7HH38oMjJSv/32W7nXBgC4eAheAACv9tBDD8lms8lms8nhcKhevXoaMmSICgsLz/m+1atXq2fPnuVa28yZM5WVlaXOnTuX+D3Vq1dX165d9fLLL5djZQCAi43gBQDwejfffLP27Nmjbdu26emnn9bgwYP11ltvnXFsfn6+JKlGjRoKCQkp17rGjBmj7t27y24/+X+369at09///nd16tRJTzzxhJo2barBgwe7va979+6aNGmS9u3bV671AQAuHoIXAMDrBQYGKjo6WnFxcerdu7cSExM1c+ZMScdnxO644w699tpriomJUYMGDSQVv9UwJydHjz32mKKiohQUFKTLL79cs2bNMvcvXbpUrVu3VnBwsGJjY/Xkk0/q8OHDZ61p7969Sk9PV8eOHc1thmHo9ttvV3BwsIYOHaoBAwbo9ddfV3BwsNt7mzRpopiYGH355Zdl8esBAFiAv6cLAACgrAUHB+vPP/80f16wYIHCwsKUlpZ2xvFOp1MdOnTQwYMH9dlnn6lu3bravHmz/Pz8JEk///yzbr75Zr366qv6+OOPtXfvXvXp00d9+vTRhAkTznjMpUuXKiQkRI0aNTK3/fnnn8rIyNDkyZNVUFAgh8Ohjh07uoUzl2uvvVb/+9//1KNHjwv5VQAALILgBQDwGYZhaMGCBZo3b56eeOIJc3ulSpX04YcfyuFwnPF933zzjVatWqUtW7bosssukyRdeuml5v6hQ4eqS5cu6tu3rySpfv36GjNmjG644QaNGzdOQUFBxY65c+dORUVFud1mWL16dTVo0ECvvPKKbr75ZkVERJz1XGJiYrR27drzOX0AgIVxqyEAwOvNmjVLoaGhCgoKUocOHXTvvfe6rZtq2rTpWUOXdHzdVa1atczQdboffvhBqampCg0NNV9JSUlyOp3asWPHGd9z9OjRMwayefPmKSoqSq+//rp69eqldu3aKT09vdi44OBgHTly5C/OHADgLZjxAgB4vRtvvFHjxo2Tw+FQTEyM/P3d/++tUqVK53z/6WusTnfo0CE99thjevLJJ4vtq1279hnfU716de3fv7/Y9ri4OE2cOFGLFi3SwoULdejQId18881au3atmjRpYo7bt2+fatSocc66AADeg+AFAPB6lSpVUr169Ur9/mbNmum3337TTz/9dMZZr+bNm2vz5s3n9RlXXXWVMjMztX//flWpUuWMY+Lj4/XQQw8pNTVVK1ascAteGzduVNu2bc/7XAAA1sSthgCACu+GG25QmzZt1KlTJ6WlpWnHjh2aM2eO5s6dK0l67rnntGzZMvXp00fr1q3Ttm3b9NVXX6lPnz5nPeZVV12l6tWr69tvvzW37d69W/3799f69euVl5enI0eO6P3331dOTo6uuuoqc9yRI0e0Zs0atW/fvvxOGgBwUTHjBQCApP/7v//TM888o/vuu0+HDx9WvXr19MYbb0g6PiO2ePFivfjii2rdurUMw1DdunV17733nvV4fn5+5vO4br31VklSWFiYCgsLdffddysjI0OGYejSSy/VhAkT1Lx5c/O9X331lWrXrq3WrVuX70kDAC4am2EYhqeLAADAF2VmZqpJkyb6/vvvFRcX57Zv0aJF+vXXX/XQQw8Ve991112nJ598Uvfff/9FqhQAUN641RAAgHISHR2tjz76SBkZGSV+zx9//KG77rpL9913XzlWBgC42JjxAgAAAIByxowXAAAAAJQzghcAAAAAlDOCFwAAAACUM4IXAAAAAJQzghcAAAAAlDOCFwAAAACUM4IXAAAAAJQzghcAAAAAlDOCFwAAAACUs/8HVJj1WLEvcAEAAAAASUVORK5CYII=",
      "text/plain": [
       "<Figure size 1000x600 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "\n",
    "plt.figure(figsize=(10, 6))\n",
    "sns.histplot(data['price'], bins=50, kde=True)\n",
    "plt.title('Distribution of Airbnb Listing Prices')\n",
    "plt.xlabel('Price ($)')\n",
    "plt.ylabel('Frequency')\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 93,
   "id": "8e52759d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['_id', 'listing_url', 'name', 'summary', 'space', 'description',\n",
       "       'neighborhood_overview', 'notes', 'transit', 'access', 'interaction',\n",
       "       'house_rules', 'property_type', 'room_type', 'bed_type',\n",
       "       'minimum_nights', 'maximum_nights', 'cancellation_policy',\n",
       "       'last_scraped', 'calendar_last_scraped', 'first_review', 'last_review',\n",
       "       'accommodates', 'bedrooms', 'beds', 'number_of_reviews', 'bathrooms',\n",
       "       'amenities', 'price', 'security_deposit', 'cleaning_fee',\n",
       "       'extra_people', 'guests_included', 'images', 'host', 'address',\n",
       "       'availability', 'review_scores', 'reviews', 'weekly_price',\n",
       "       'monthly_price', 'reviews_per_month', 'coordinates', 'availability_30',\n",
       "       'availability_60', 'availability_90', 'availability_365'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 93,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "feea7028",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "81638a1d",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}