2017_Prices_Zipcode.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "id                                482761\n",
       "name                              482528\n",
       "host_id                           482761\n",
       "host_name                         481766\n",
       "neighbourhood_group               482761\n",
       "neighbourhood                     482761\n",
       "zipcode                           482761\n",
       "latitude                          482761\n",
       "longitude                         482761\n",
       "room_type                         482761\n",
       "price                             482761\n",
       "minimum_nights                    482761\n",
       "number_of_reviews                 482761\n",
       "last_review                       374395\n",
       "reviews_per_month                 374049\n",
       "calculated_host_listings_count    482761\n",
       "availability_365                  482761\n",
       "year_month                        482761\n",
       "dtype: int64"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "\n",
    "df = pd.read_csv(\"Merged_2017.csv\")\n",
    "df.count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>name</th>\n",
       "      <th>host_id</th>\n",
       "      <th>host_name</th>\n",
       "      <th>neighbourhood_group</th>\n",
       "      <th>neighbourhood</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>room_type</th>\n",
       "      <th>price</th>\n",
       "      <th>minimum_nights</th>\n",
       "      <th>number_of_reviews</th>\n",
       "      <th>last_review</th>\n",
       "      <th>reviews_per_month</th>\n",
       "      <th>calculated_host_listings_count</th>\n",
       "      <th>availability_365</th>\n",
       "      <th>year_month</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>zipcode</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>11211</th>\n",
       "      <td>23909</td>\n",
       "      <td>23888</td>\n",
       "      <td>23909</td>\n",
       "      <td>23863</td>\n",
       "      <td>23909</td>\n",
       "      <td>23909</td>\n",
       "      <td>23909</td>\n",
       "      <td>23909</td>\n",
       "      <td>23909</td>\n",
       "      <td>23909</td>\n",
       "      <td>23909</td>\n",
       "      <td>23909</td>\n",
       "      <td>18585</td>\n",
       "      <td>18565</td>\n",
       "      <td>23909</td>\n",
       "      <td>23909</td>\n",
       "      <td>23909</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11221</th>\n",
       "      <td>17845</td>\n",
       "      <td>17837</td>\n",
       "      <td>17845</td>\n",
       "      <td>17801</td>\n",
       "      <td>17845</td>\n",
       "      <td>17845</td>\n",
       "      <td>17845</td>\n",
       "      <td>17845</td>\n",
       "      <td>17845</td>\n",
       "      <td>17845</td>\n",
       "      <td>17845</td>\n",
       "      <td>17845</td>\n",
       "      <td>14091</td>\n",
       "      <td>14075</td>\n",
       "      <td>17845</td>\n",
       "      <td>17845</td>\n",
       "      <td>17845</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11206</th>\n",
       "      <td>16475</td>\n",
       "      <td>16475</td>\n",
       "      <td>16475</td>\n",
       "      <td>16439</td>\n",
       "      <td>16475</td>\n",
       "      <td>16475</td>\n",
       "      <td>16475</td>\n",
       "      <td>16475</td>\n",
       "      <td>16475</td>\n",
       "      <td>16475</td>\n",
       "      <td>16475</td>\n",
       "      <td>16475</td>\n",
       "      <td>12709</td>\n",
       "      <td>12700</td>\n",
       "      <td>16475</td>\n",
       "      <td>16475</td>\n",
       "      <td>16475</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11216</th>\n",
       "      <td>14574</td>\n",
       "      <td>14574</td>\n",
       "      <td>14574</td>\n",
       "      <td>14543</td>\n",
       "      <td>14574</td>\n",
       "      <td>14574</td>\n",
       "      <td>14574</td>\n",
       "      <td>14574</td>\n",
       "      <td>14574</td>\n",
       "      <td>14574</td>\n",
       "      <td>14574</td>\n",
       "      <td>14574</td>\n",
       "      <td>11437</td>\n",
       "      <td>11430</td>\n",
       "      <td>14574</td>\n",
       "      <td>14574</td>\n",
       "      <td>14574</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10002</th>\n",
       "      <td>14280</td>\n",
       "      <td>14272</td>\n",
       "      <td>14280</td>\n",
       "      <td>14239</td>\n",
       "      <td>14280</td>\n",
       "      <td>14280</td>\n",
       "      <td>14280</td>\n",
       "      <td>14280</td>\n",
       "      <td>14280</td>\n",
       "      <td>14280</td>\n",
       "      <td>14280</td>\n",
       "      <td>14280</td>\n",
       "      <td>11460</td>\n",
       "      <td>11447</td>\n",
       "      <td>14280</td>\n",
       "      <td>14280</td>\n",
       "      <td>14280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10009</th>\n",
       "      <td>14258</td>\n",
       "      <td>14248</td>\n",
       "      <td>14258</td>\n",
       "      <td>14231</td>\n",
       "      <td>14258</td>\n",
       "      <td>14258</td>\n",
       "      <td>14258</td>\n",
       "      <td>14258</td>\n",
       "      <td>14258</td>\n",
       "      <td>14258</td>\n",
       "      <td>14258</td>\n",
       "      <td>14258</td>\n",
       "      <td>11511</td>\n",
       "      <td>11496</td>\n",
       "      <td>14258</td>\n",
       "      <td>14258</td>\n",
       "      <td>14258</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11238</th>\n",
       "      <td>13587</td>\n",
       "      <td>13586</td>\n",
       "      <td>13587</td>\n",
       "      <td>13542</td>\n",
       "      <td>13587</td>\n",
       "      <td>13587</td>\n",
       "      <td>13587</td>\n",
       "      <td>13587</td>\n",
       "      <td>13587</td>\n",
       "      <td>13587</td>\n",
       "      <td>13587</td>\n",
       "      <td>13587</td>\n",
       "      <td>10755</td>\n",
       "      <td>10743</td>\n",
       "      <td>13587</td>\n",
       "      <td>13587</td>\n",
       "      <td>13587</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10003</th>\n",
       "      <td>12998</td>\n",
       "      <td>12987</td>\n",
       "      <td>12998</td>\n",
       "      <td>12973</td>\n",
       "      <td>12998</td>\n",
       "      <td>12998</td>\n",
       "      <td>12998</td>\n",
       "      <td>12998</td>\n",
       "      <td>12998</td>\n",
       "      <td>12998</td>\n",
       "      <td>12998</td>\n",
       "      <td>12998</td>\n",
       "      <td>10240</td>\n",
       "      <td>10234</td>\n",
       "      <td>12998</td>\n",
       "      <td>12998</td>\n",
       "      <td>12998</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11222</th>\n",
       "      <td>12220</td>\n",
       "      <td>12220</td>\n",
       "      <td>12220</td>\n",
       "      <td>12193</td>\n",
       "      <td>12220</td>\n",
       "      <td>12220</td>\n",
       "      <td>12220</td>\n",
       "      <td>12220</td>\n",
       "      <td>12220</td>\n",
       "      <td>12220</td>\n",
       "      <td>12220</td>\n",
       "      <td>12220</td>\n",
       "      <td>9138</td>\n",
       "      <td>9132</td>\n",
       "      <td>12220</td>\n",
       "      <td>12220</td>\n",
       "      <td>12220</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10019</th>\n",
       "      <td>11270</td>\n",
       "      <td>11253</td>\n",
       "      <td>11270</td>\n",
       "      <td>11254</td>\n",
       "      <td>11270</td>\n",
       "      <td>11270</td>\n",
       "      <td>11270</td>\n",
       "      <td>11270</td>\n",
       "      <td>11270</td>\n",
       "      <td>11270</td>\n",
       "      <td>11270</td>\n",
       "      <td>11270</td>\n",
       "      <td>8528</td>\n",
       "      <td>8521</td>\n",
       "      <td>11270</td>\n",
       "      <td>11270</td>\n",
       "      <td>11270</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11237</th>\n",
       "      <td>10983</td>\n",
       "      <td>10983</td>\n",
       "      <td>10983</td>\n",
       "      <td>10955</td>\n",
       "      <td>10983</td>\n",
       "      <td>10983</td>\n",
       "      <td>10983</td>\n",
       "      <td>10983</td>\n",
       "      <td>10983</td>\n",
       "      <td>10983</td>\n",
       "      <td>10983</td>\n",
       "      <td>10983</td>\n",
       "      <td>8168</td>\n",
       "      <td>8155</td>\n",
       "      <td>10983</td>\n",
       "      <td>10983</td>\n",
       "      <td>10983</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10025</th>\n",
       "      <td>10630</td>\n",
       "      <td>10612</td>\n",
       "      <td>10630</td>\n",
       "      <td>10610</td>\n",
       "      <td>10630</td>\n",
       "      <td>10630</td>\n",
       "      <td>10630</td>\n",
       "      <td>10630</td>\n",
       "      <td>10630</td>\n",
       "      <td>10630</td>\n",
       "      <td>10630</td>\n",
       "      <td>10630</td>\n",
       "      <td>7739</td>\n",
       "      <td>7731</td>\n",
       "      <td>10630</td>\n",
       "      <td>10630</td>\n",
       "      <td>10630</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10011</th>\n",
       "      <td>10374</td>\n",
       "      <td>10374</td>\n",
       "      <td>10374</td>\n",
       "      <td>10360</td>\n",
       "      <td>10374</td>\n",
       "      <td>10374</td>\n",
       "      <td>10374</td>\n",
       "      <td>10374</td>\n",
       "      <td>10374</td>\n",
       "      <td>10374</td>\n",
       "      <td>10374</td>\n",
       "      <td>10374</td>\n",
       "      <td>8381</td>\n",
       "      <td>8368</td>\n",
       "      <td>10374</td>\n",
       "      <td>10374</td>\n",
       "      <td>10374</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10031</th>\n",
       "      <td>9323</td>\n",
       "      <td>9322</td>\n",
       "      <td>9323</td>\n",
       "      <td>9304</td>\n",
       "      <td>9323</td>\n",
       "      <td>9323</td>\n",
       "      <td>9323</td>\n",
       "      <td>9323</td>\n",
       "      <td>9323</td>\n",
       "      <td>9323</td>\n",
       "      <td>9323</td>\n",
       "      <td>9323</td>\n",
       "      <td>7227</td>\n",
       "      <td>7222</td>\n",
       "      <td>9323</td>\n",
       "      <td>9323</td>\n",
       "      <td>9323</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10027</th>\n",
       "      <td>9298</td>\n",
       "      <td>9298</td>\n",
       "      <td>9298</td>\n",
       "      <td>9282</td>\n",
       "      <td>9298</td>\n",
       "      <td>9298</td>\n",
       "      <td>9298</td>\n",
       "      <td>9298</td>\n",
       "      <td>9298</td>\n",
       "      <td>9298</td>\n",
       "      <td>9298</td>\n",
       "      <td>9298</td>\n",
       "      <td>7261</td>\n",
       "      <td>7251</td>\n",
       "      <td>9298</td>\n",
       "      <td>9298</td>\n",
       "      <td>9298</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11215</th>\n",
       "      <td>8933</td>\n",
       "      <td>8933</td>\n",
       "      <td>8933</td>\n",
       "      <td>8919</td>\n",
       "      <td>8933</td>\n",
       "      <td>8933</td>\n",
       "      <td>8933</td>\n",
       "      <td>8933</td>\n",
       "      <td>8933</td>\n",
       "      <td>8933</td>\n",
       "      <td>8933</td>\n",
       "      <td>8933</td>\n",
       "      <td>7014</td>\n",
       "      <td>7008</td>\n",
       "      <td>8933</td>\n",
       "      <td>8933</td>\n",
       "      <td>8933</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10036</th>\n",
       "      <td>8660</td>\n",
       "      <td>8660</td>\n",
       "      <td>8660</td>\n",
       "      <td>8640</td>\n",
       "      <td>8660</td>\n",
       "      <td>8660</td>\n",
       "      <td>8660</td>\n",
       "      <td>8660</td>\n",
       "      <td>8660</td>\n",
       "      <td>8660</td>\n",
       "      <td>8660</td>\n",
       "      <td>8660</td>\n",
       "      <td>6930</td>\n",
       "      <td>6924</td>\n",
       "      <td>8660</td>\n",
       "      <td>8660</td>\n",
       "      <td>8660</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10029</th>\n",
       "      <td>8610</td>\n",
       "      <td>8610</td>\n",
       "      <td>8610</td>\n",
       "      <td>8587</td>\n",
       "      <td>8610</td>\n",
       "      <td>8610</td>\n",
       "      <td>8610</td>\n",
       "      <td>8610</td>\n",
       "      <td>8610</td>\n",
       "      <td>8610</td>\n",
       "      <td>8610</td>\n",
       "      <td>8610</td>\n",
       "      <td>7149</td>\n",
       "      <td>7145</td>\n",
       "      <td>8610</td>\n",
       "      <td>8610</td>\n",
       "      <td>8610</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10014</th>\n",
       "      <td>8565</td>\n",
       "      <td>8565</td>\n",
       "      <td>8565</td>\n",
       "      <td>8554</td>\n",
       "      <td>8565</td>\n",
       "      <td>8565</td>\n",
       "      <td>8565</td>\n",
       "      <td>8565</td>\n",
       "      <td>8565</td>\n",
       "      <td>8565</td>\n",
       "      <td>8565</td>\n",
       "      <td>8565</td>\n",
       "      <td>6638</td>\n",
       "      <td>6636</td>\n",
       "      <td>8565</td>\n",
       "      <td>8565</td>\n",
       "      <td>8565</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10012</th>\n",
       "      <td>8532</td>\n",
       "      <td>8524</td>\n",
       "      <td>8532</td>\n",
       "      <td>8520</td>\n",
       "      <td>8532</td>\n",
       "      <td>8532</td>\n",
       "      <td>8532</td>\n",
       "      <td>8532</td>\n",
       "      <td>8532</td>\n",
       "      <td>8532</td>\n",
       "      <td>8532</td>\n",
       "      <td>8532</td>\n",
       "      <td>7007</td>\n",
       "      <td>7000</td>\n",
       "      <td>8532</td>\n",
       "      <td>8532</td>\n",
       "      <td>8532</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11249</th>\n",
       "      <td>8098</td>\n",
       "      <td>8090</td>\n",
       "      <td>8098</td>\n",
       "      <td>8077</td>\n",
       "      <td>8098</td>\n",
       "      <td>8098</td>\n",
       "      <td>8098</td>\n",
       "      <td>8098</td>\n",
       "      <td>8098</td>\n",
       "      <td>8098</td>\n",
       "      <td>8098</td>\n",
       "      <td>8098</td>\n",
       "      <td>6195</td>\n",
       "      <td>6189</td>\n",
       "      <td>8098</td>\n",
       "      <td>8098</td>\n",
       "      <td>8098</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11205</th>\n",
       "      <td>7987</td>\n",
       "      <td>7987</td>\n",
       "      <td>7987</td>\n",
       "      <td>7972</td>\n",
       "      <td>7987</td>\n",
       "      <td>7987</td>\n",
       "      <td>7987</td>\n",
       "      <td>7987</td>\n",
       "      <td>7987</td>\n",
       "      <td>7987</td>\n",
       "      <td>7987</td>\n",
       "      <td>7987</td>\n",
       "      <td>6315</td>\n",
       "      <td>6312</td>\n",
       "      <td>7987</td>\n",
       "      <td>7987</td>\n",
       "      <td>7987</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11233</th>\n",
       "      <td>7726</td>\n",
       "      <td>7726</td>\n",
       "      <td>7726</td>\n",
       "      <td>7714</td>\n",
       "      <td>7726</td>\n",
       "      <td>7726</td>\n",
       "      <td>7726</td>\n",
       "      <td>7726</td>\n",
       "      <td>7726</td>\n",
       "      <td>7726</td>\n",
       "      <td>7726</td>\n",
       "      <td>7726</td>\n",
       "      <td>6380</td>\n",
       "      <td>6372</td>\n",
       "      <td>7726</td>\n",
       "      <td>7726</td>\n",
       "      <td>7726</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10016</th>\n",
       "      <td>7565</td>\n",
       "      <td>7565</td>\n",
       "      <td>7565</td>\n",
       "      <td>7550</td>\n",
       "      <td>7565</td>\n",
       "      <td>7565</td>\n",
       "      <td>7565</td>\n",
       "      <td>7565</td>\n",
       "      <td>7565</td>\n",
       "      <td>7565</td>\n",
       "      <td>7565</td>\n",
       "      <td>7565</td>\n",
       "      <td>5703</td>\n",
       "      <td>5697</td>\n",
       "      <td>7565</td>\n",
       "      <td>7565</td>\n",
       "      <td>7565</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11225</th>\n",
       "      <td>7385</td>\n",
       "      <td>7385</td>\n",
       "      <td>7385</td>\n",
       "      <td>7366</td>\n",
       "      <td>7385</td>\n",
       "      <td>7385</td>\n",
       "      <td>7385</td>\n",
       "      <td>7385</td>\n",
       "      <td>7385</td>\n",
       "      <td>7385</td>\n",
       "      <td>7385</td>\n",
       "      <td>7385</td>\n",
       "      <td>5803</td>\n",
       "      <td>5796</td>\n",
       "      <td>7385</td>\n",
       "      <td>7385</td>\n",
       "      <td>7385</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11226</th>\n",
       "      <td>7323</td>\n",
       "      <td>7323</td>\n",
       "      <td>7323</td>\n",
       "      <td>7313</td>\n",
       "      <td>7323</td>\n",
       "      <td>7323</td>\n",
       "      <td>7323</td>\n",
       "      <td>7323</td>\n",
       "      <td>7323</td>\n",
       "      <td>7323</td>\n",
       "      <td>7323</td>\n",
       "      <td>7323</td>\n",
       "      <td>5588</td>\n",
       "      <td>5585</td>\n",
       "      <td>7323</td>\n",
       "      <td>7323</td>\n",
       "      <td>7323</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11217</th>\n",
       "      <td>6347</td>\n",
       "      <td>6347</td>\n",
       "      <td>6347</td>\n",
       "      <td>6337</td>\n",
       "      <td>6347</td>\n",
       "      <td>6347</td>\n",
       "      <td>6347</td>\n",
       "      <td>6347</td>\n",
       "      <td>6347</td>\n",
       "      <td>6347</td>\n",
       "      <td>6347</td>\n",
       "      <td>6347</td>\n",
       "      <td>5133</td>\n",
       "      <td>5125</td>\n",
       "      <td>6347</td>\n",
       "      <td>6347</td>\n",
       "      <td>6347</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11201</th>\n",
       "      <td>5850</td>\n",
       "      <td>5850</td>\n",
       "      <td>5850</td>\n",
       "      <td>5832</td>\n",
       "      <td>5850</td>\n",
       "      <td>5850</td>\n",
       "      <td>5850</td>\n",
       "      <td>5850</td>\n",
       "      <td>5850</td>\n",
       "      <td>5850</td>\n",
       "      <td>5850</td>\n",
       "      <td>5850</td>\n",
       "      <td>4431</td>\n",
       "      <td>4427</td>\n",
       "      <td>5850</td>\n",
       "      <td>5850</td>\n",
       "      <td>5850</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10032</th>\n",
       "      <td>5493</td>\n",
       "      <td>5493</td>\n",
       "      <td>5493</td>\n",
       "      <td>5476</td>\n",
       "      <td>5493</td>\n",
       "      <td>5493</td>\n",
       "      <td>5493</td>\n",
       "      <td>5493</td>\n",
       "      <td>5493</td>\n",
       "      <td>5493</td>\n",
       "      <td>5493</td>\n",
       "      <td>5493</td>\n",
       "      <td>4170</td>\n",
       "      <td>4168</td>\n",
       "      <td>5493</td>\n",
       "      <td>5493</td>\n",
       "      <td>5493</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10023</th>\n",
       "      <td>5385</td>\n",
       "      <td>5381</td>\n",
       "      <td>5385</td>\n",
       "      <td>5375</td>\n",
       "      <td>5385</td>\n",
       "      <td>5385</td>\n",
       "      <td>5385</td>\n",
       "      <td>5385</td>\n",
       "      <td>5385</td>\n",
       "      <td>5385</td>\n",
       "      <td>5385</td>\n",
       "      <td>5385</td>\n",
       "      <td>4123</td>\n",
       "      <td>4119</td>\n",
       "      <td>5385</td>\n",
       "      <td>5385</td>\n",
       "      <td>5385</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            id   name  host_id  host_name  neighbourhood_group  neighbourhood  \\\n",
       "zipcode                                                                         \n",
       "11211    23909  23888    23909      23863                23909          23909   \n",
       "11221    17845  17837    17845      17801                17845          17845   \n",
       "11206    16475  16475    16475      16439                16475          16475   \n",
       "11216    14574  14574    14574      14543                14574          14574   \n",
       "10002    14280  14272    14280      14239                14280          14280   \n",
       "10009    14258  14248    14258      14231                14258          14258   \n",
       "11238    13587  13586    13587      13542                13587          13587   \n",
       "10003    12998  12987    12998      12973                12998          12998   \n",
       "11222    12220  12220    12220      12193                12220          12220   \n",
       "10019    11270  11253    11270      11254                11270          11270   \n",
       "11237    10983  10983    10983      10955                10983          10983   \n",
       "10025    10630  10612    10630      10610                10630          10630   \n",
       "10011    10374  10374    10374      10360                10374          10374   \n",
       "10031     9323   9322     9323       9304                 9323           9323   \n",
       "10027     9298   9298     9298       9282                 9298           9298   \n",
       "11215     8933   8933     8933       8919                 8933           8933   \n",
       "10036     8660   8660     8660       8640                 8660           8660   \n",
       "10029     8610   8610     8610       8587                 8610           8610   \n",
       "10014     8565   8565     8565       8554                 8565           8565   \n",
       "10012     8532   8524     8532       8520                 8532           8532   \n",
       "11249     8098   8090     8098       8077                 8098           8098   \n",
       "11205     7987   7987     7987       7972                 7987           7987   \n",
       "11233     7726   7726     7726       7714                 7726           7726   \n",
       "10016     7565   7565     7565       7550                 7565           7565   \n",
       "11225     7385   7385     7385       7366                 7385           7385   \n",
       "11226     7323   7323     7323       7313                 7323           7323   \n",
       "11217     6347   6347     6347       6337                 6347           6347   \n",
       "11201     5850   5850     5850       5832                 5850           5850   \n",
       "10032     5493   5493     5493       5476                 5493           5493   \n",
       "10023     5385   5381     5385       5375                 5385           5385   \n",
       "\n",
       "         latitude  longitude  room_type  price  minimum_nights  \\\n",
       "zipcode                                                          \n",
       "11211       23909      23909      23909  23909           23909   \n",
       "11221       17845      17845      17845  17845           17845   \n",
       "11206       16475      16475      16475  16475           16475   \n",
       "11216       14574      14574      14574  14574           14574   \n",
       "10002       14280      14280      14280  14280           14280   \n",
       "10009       14258      14258      14258  14258           14258   \n",
       "11238       13587      13587      13587  13587           13587   \n",
       "10003       12998      12998      12998  12998           12998   \n",
       "11222       12220      12220      12220  12220           12220   \n",
       "10019       11270      11270      11270  11270           11270   \n",
       "11237       10983      10983      10983  10983           10983   \n",
       "10025       10630      10630      10630  10630           10630   \n",
       "10011       10374      10374      10374  10374           10374   \n",
       "10031        9323       9323       9323   9323            9323   \n",
       "10027        9298       9298       9298   9298            9298   \n",
       "11215        8933       8933       8933   8933            8933   \n",
       "10036        8660       8660       8660   8660            8660   \n",
       "10029        8610       8610       8610   8610            8610   \n",
       "10014        8565       8565       8565   8565            8565   \n",
       "10012        8532       8532       8532   8532            8532   \n",
       "11249        8098       8098       8098   8098            8098   \n",
       "11205        7987       7987       7987   7987            7987   \n",
       "11233        7726       7726       7726   7726            7726   \n",
       "10016        7565       7565       7565   7565            7565   \n",
       "11225        7385       7385       7385   7385            7385   \n",
       "11226        7323       7323       7323   7323            7323   \n",
       "11217        6347       6347       6347   6347            6347   \n",
       "11201        5850       5850       5850   5850            5850   \n",
       "10032        5493       5493       5493   5493            5493   \n",
       "10023        5385       5385       5385   5385            5385   \n",
       "\n",
       "         number_of_reviews  last_review  reviews_per_month  \\\n",
       "zipcode                                                      \n",
       "11211                23909        18585              18565   \n",
       "11221                17845        14091              14075   \n",
       "11206                16475        12709              12700   \n",
       "11216                14574        11437              11430   \n",
       "10002                14280        11460              11447   \n",
       "10009                14258        11511              11496   \n",
       "11238                13587        10755              10743   \n",
       "10003                12998        10240              10234   \n",
       "11222                12220         9138               9132   \n",
       "10019                11270         8528               8521   \n",
       "11237                10983         8168               8155   \n",
       "10025                10630         7739               7731   \n",
       "10011                10374         8381               8368   \n",
       "10031                 9323         7227               7222   \n",
       "10027                 9298         7261               7251   \n",
       "11215                 8933         7014               7008   \n",
       "10036                 8660         6930               6924   \n",
       "10029                 8610         7149               7145   \n",
       "10014                 8565         6638               6636   \n",
       "10012                 8532         7007               7000   \n",
       "11249                 8098         6195               6189   \n",
       "11205                 7987         6315               6312   \n",
       "11233                 7726         6380               6372   \n",
       "10016                 7565         5703               5697   \n",
       "11225                 7385         5803               5796   \n",
       "11226                 7323         5588               5585   \n",
       "11217                 6347         5133               5125   \n",
       "11201                 5850         4431               4427   \n",
       "10032                 5493         4170               4168   \n",
       "10023                 5385         4123               4119   \n",
       "\n",
       "         calculated_host_listings_count  availability_365  year_month  \n",
       "zipcode                                                                \n",
       "11211                             23909             23909       23909  \n",
       "11221                             17845             17845       17845  \n",
       "11206                             16475             16475       16475  \n",
       "11216                             14574             14574       14574  \n",
       "10002                             14280             14280       14280  \n",
       "10009                             14258             14258       14258  \n",
       "11238                             13587             13587       13587  \n",
       "10003                             12998             12998       12998  \n",
       "11222                             12220             12220       12220  \n",
       "10019                             11270             11270       11270  \n",
       "11237                             10983             10983       10983  \n",
       "10025                             10630             10630       10630  \n",
       "10011                             10374             10374       10374  \n",
       "10031                              9323              9323        9323  \n",
       "10027                              9298              9298        9298  \n",
       "11215                              8933              8933        8933  \n",
       "10036                              8660              8660        8660  \n",
       "10029                              8610              8610        8610  \n",
       "10014                              8565              8565        8565  \n",
       "10012                              8532              8532        8532  \n",
       "11249                              8098              8098        8098  \n",
       "11205                              7987              7987        7987  \n",
       "11233                              7726              7726        7726  \n",
       "10016                              7565              7565        7565  \n",
       "11225                              7385              7385        7385  \n",
       "11226                              7323              7323        7323  \n",
       "11217                              6347              6347        6347  \n",
       "11201                              5850              5850        5850  \n",
       "10032                              5493              5493        5493  \n",
       "10023                              5385              5385        5385  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "by_zipcode = df.groupby('zipcode').count()\n",
    "by_zipcode = by_zipcode.sort_values('id', ascending=False)\n",
    "by_zipcode.head(30)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": true
   },
   "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>Zip Code</th>\n",
       "      <th>Mean</th>\n",
       "      <th>Median</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>11211</td>\n",
       "      <td>145.759296</td>\n",
       "      <td>113.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>11221</td>\n",
       "      <td>88.334267</td>\n",
       "      <td>69.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>11206</td>\n",
       "      <td>94.821426</td>\n",
       "      <td>75.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>11216</td>\n",
       "      <td>107.358035</td>\n",
       "      <td>85.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>10002</td>\n",
       "      <td>174.141667</td>\n",
       "      <td>129.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>10009</td>\n",
       "      <td>166.544186</td>\n",
       "      <td>135.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>11238</td>\n",
       "      <td>135.210127</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>10003</td>\n",
       "      <td>220.491229</td>\n",
       "      <td>160.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>11222</td>\n",
       "      <td>124.135188</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10019</td>\n",
       "      <td>215.059272</td>\n",
       "      <td>170.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11237</td>\n",
       "      <td>80.728763</td>\n",
       "      <td>65.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>10025</td>\n",
       "      <td>166.183255</td>\n",
       "      <td>110.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>10011</td>\n",
       "      <td>225.691729</td>\n",
       "      <td>195.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>10031</td>\n",
       "      <td>95.558082</td>\n",
       "      <td>75.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>10027</td>\n",
       "      <td>135.229297</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>11215</td>\n",
       "      <td>144.884473</td>\n",
       "      <td>129.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>10036</td>\n",
       "      <td>213.932102</td>\n",
       "      <td>168.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>10029</td>\n",
       "      <td>129.885366</td>\n",
       "      <td>98.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>10014</td>\n",
       "      <td>244.652423</td>\n",
       "      <td>200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>10012</td>\n",
       "      <td>224.176746</td>\n",
       "      <td>185.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>11249</td>\n",
       "      <td>170.654236</td>\n",
       "      <td>135.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>11205</td>\n",
       "      <td>140.440341</td>\n",
       "      <td>99.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>11233</td>\n",
       "      <td>100.719001</td>\n",
       "      <td>80.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>10016</td>\n",
       "      <td>215.009782</td>\n",
       "      <td>170.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>11225</td>\n",
       "      <td>95.294381</td>\n",
       "      <td>80.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>11226</td>\n",
       "      <td>85.103783</td>\n",
       "      <td>69.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>11217</td>\n",
       "      <td>163.994170</td>\n",
       "      <td>130.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>11201</td>\n",
       "      <td>174.439658</td>\n",
       "      <td>145.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>10032</td>\n",
       "      <td>92.665028</td>\n",
       "      <td>70.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>10023</td>\n",
       "      <td>219.792201</td>\n",
       "      <td>182.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Zip Code        Mean  Median\n",
       "0      11211  145.759296   113.0\n",
       "1      11221   88.334267    69.0\n",
       "2      11206   94.821426    75.0\n",
       "3      11216  107.358035    85.0\n",
       "4      10002  174.141667   129.0\n",
       "5      10009  166.544186   135.0\n",
       "6      11238  135.210127   100.0\n",
       "7      10003  220.491229   160.0\n",
       "8      11222  124.135188   100.0\n",
       "9      10019  215.059272   170.0\n",
       "10     11237   80.728763    65.0\n",
       "11     10025  166.183255   110.0\n",
       "12     10011  225.691729   195.0\n",
       "13     10031   95.558082    75.0\n",
       "14     10027  135.229297   100.0\n",
       "15     11215  144.884473   129.0\n",
       "16     10036  213.932102   168.0\n",
       "17     10029  129.885366    98.0\n",
       "18     10014  244.652423   200.0\n",
       "19     10012  224.176746   185.0\n",
       "20     11249  170.654236   135.0\n",
       "21     11205  140.440341    99.0\n",
       "22     11233  100.719001    80.0\n",
       "23     10016  215.009782   170.0\n",
       "24     11225   95.294381    80.0\n",
       "25     11226   85.103783    69.0\n",
       "26     11217  163.994170   130.0\n",
       "27     11201  174.439658   145.0\n",
       "28     10032   92.665028    70.0\n",
       "29     10023  219.792201   182.0"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#2018 zipcodes = [11211,11221,11206,10019,11216,10002,10009,10003,11222,11238]\n",
    "#zipcodes = [11211, 11221, 11206, 11216, 10002, 10009, 11238, 10003, 11222, 10019]\n",
    "\n",
    "zip_list = list(by_zipcode.index.values)\n",
    "zipcodes = zip_list[0:30]\n",
    "means = []\n",
    "medians = []\n",
    "\n",
    "for zipcode in zipcodes:\n",
    "    median = df.loc[df['zipcode']==zipcode]['price'].median()\n",
    "    mean = df.loc[df['zipcode']==zipcode]['price'].mean()\n",
    "    means.append(mean)\n",
    "    medians.append(median)\n",
    "\n",
    "zipcode_prices = pd.DataFrame({\n",
    "    'Zip Code':zipcodes,\n",
    "    'Mean': means,\n",
    "    'Median': medians\n",
    "})\n",
    "zipcode_prices\n",
    "\n",
    "#by_zipcode = df.groupby(['zipcode', 'year_month']).agg({'price':'sum'}).rename(columns = {'price':'Price_Mean'}).reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "zipcode_prices.to_csv('2017_Top30codes', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAABawAAAHwCAYAAABKXSiiAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMi4zLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvIxREBQAAIABJREFUeJzs3XuYpWV5J+rfI4024AkV3EpLyp0xBo0tYAtMjA7iniA0o07UCBg0IRMP0a3OqJNODMaZbGb35PIUnB1ncCRRo+CBJDI2k4G4ZRxPCY1oB8UDMRVoIQqttoq00vjOH+vrtiyrD0B9td7uuu/rqqvW+g7Per5VRVfx67efr1prAQAAAACAabvHtBsAAAAAAIBEYA0AAAAAQCcE1gAAAAAAdEFgDQAAAABAFwTWAAAAAAB0QWANAAAAAEAXBNYAAOzzqmq2qv6vJX7NK6rqXw2Pn1tVly3l6+9KVX2uqk5cotf61ar62BK91n+uqnOW4rXmvOafVNX/s5SvCQCw3AmsAQCWgSHQ/UFVPWje9s9UVauqmel0Nr4hdGxV9bR52988bP/Vu/sarbV3t9Z+8e7WWcjQ461V9d2q+mpVvbGqDthNL49urV0xRi9jqaonDtc3/+OHVXVBkrTWXtRa+/1p9woAwLgE1gAAy8ffJzljx5OqekySg6bXzpL6UpLn73hSVSuSPDvJ302tozvnsa21eyd5SpIzk/zG/AOGa9ontdb+V2vt3nM/kvxSku8meeOU2wMAYAkJrAEAlo93JXnenOfPT/LOuQdU1b2q6vVVdX1VfW0Yw3DQsO/QqvpQVd1cVd8cHq+ac+4VVfX7VfXxqvpOVV02f0X3nGPvVq2qOquq/qGqtlTVa/bi2v9bkidU1aHD86cm2ZTkH+f1dXZVXTv09D+q6qfm7PvnVfWFqtpaVf8pSc3Z92OjMarqD6vqhqr6dlVdVVVPnLPvdVX1vqp653Btn6uqNXtxDWmtfSHJ/0ryc0Ot2ar6raralOTWqloxdzxKVR1QVb9TVX83vNZVVfWwYd/PVtXlVfWNqvpiVf3ynB5PrarPD+d8tapetZu2qqreMrwvX6iqpwwbn11VV8078JVV9Rd7us6hx3cn+c3W2jXDtp3jOarqxKraPFzbLcM1P3fO+QdV1RuG75GtVfWxOd/HTxve828N32dHzTnvmKr69HDd702ycl5fp9XkXyV8q6o+UVWr93QtAADcOQJrAIDl41NJ7ltVR9VkpMRzkvzpvGP+Y5KfSXJ0kn+S5Igkrx323SPJHyf5qSRHJrktyX+ad/6ZSX4tyeFJ7plkV0HnXa5VVY9K8tYkZyV5aJIHJlmV3duW5JIkpw/Pn5efDOufkeR3MlnZe1gmwfCFw74HJbk4ye8meVAmK7OfsJvXuzKT9/ABSd6T5P1VNTf8fFqSi5Lcf+hr/rUvaLj2Jya5es7mM5KsTXL/1tr2eaf8m2H/qUnum+TsJN+rqkOSXD70dvhwzB9V1aOH896e5IWttftkEo7//7tp6/gkX8nkffm9JH9WVQ8YruvhcwPhJL+SyV+c7O4aD0zyviQfaK3N//6c6/8YXvOITP7y5fyqeuSw7/VJHpfk5zP5GvzbJD+sqp/J5Gv6iky+xpcm+W9Vdc+qumeSvxj6e0CS9yd55py+jk1yQZIXZvI991+SXFJV99rd9QAAcOcIrAEAlpcdq6z/eZIvJPnqjh1VVZmMmvjXrbVvtNa+k+Q/ZAh5W2tbWmsXt9a+N+w7N8k/m1f/j1trX2qt3ZZJ6Hj0Qk3czVrPSvKh1tpHW2vfT3JOkh/uxbW/M8nzqup+w2vNX+n7wiT/b2vt2iH4/Q9Jjh5WWZ+a5POttQ+01m5P8ubMW5097/r+dLjG7a21NyS5V5JHzjnkY621S1trd2TyNXnsHnr/dFV9M5OV4v81k7B/h/NaazcM79N8/yrJ77bWvtgmPtta25LktCSzrbU/Hnr8dCaB/LOG825P8qiqum9r7ZvD/l35epI3t9Zub629N8kXk6wdvjbvzSSkzhCGzyT50B6u9Y1JVmQSKu/JOa2177fW/meSDUl+uarukUkw//LW2ldba3e01j4x9POcJBtaa5cPX8fXZzIW5+eTnJDkwDnX8oFM/uJhh99I8l9aa3891HxHku8P5wEAsEj22Tl3AADcJe9K8tEkD8+8FcaZrDg9OMlVk+w6yWTsxQFJUlUHJ3lTJuM0dozWuE9VHTAEr8mPh7jfS3LvhZq4m7UemuSGHTtaa7dW1ZbdXPOO4z5WVYdlskr6Q6212+ZcZzJZ7f2HVfWGua1msoJ3/mu2qrohu1BVr8wkLH5okpbJ6ua541HmX9vKqlqxwArpHY5trV23i3277CPJw7LwnO6fSnJ8VX1rzrYV+dHq52dm8j6tH8aNrGutfXIXr/HV1lqb8/wfMrnuJHlHkgur6nczWRH/viE4XlBVnZ7Jyvpjd3fc4JuttVsXeN0HZTLKY6HrfuhwXJKktfbD4et4RJI7dnEtO/xUkudX1f89Z9s986NrBQBgEVhhDQCwjLTW/iGTmy+emuTP5u2+JZPRHI9urd1/+LjfcAO8JHllJquEj2+t3TfJk4btlTvv7tS6KZMgdnLCJPx+4F6+7p8Orz0/rE8mwe8L51z7/VtrB7XWPrHAa9bc53MN86p/K8kvJzm0tXb/JFtz196nvdF2s++GJD+9i+3/c9613ru19uIkaa1d2Vp7eibjQv4ikxXuu3JE/Xjyf2SSG4c6n0ryg0zGmJyZ3YwDGUaHnJ/krOH7dE8OHUabzH/dWzIZAbPQdd+YSfC84zV3fB2/msnXeKFr2eGGJOfOe88Obq1duBe9AgCwlwTWAADLz68nOWne6tS01n6Y5G1J3lRVhydJVR1RVScPh9wnk0D7W8OM4t+7Gz3cnVofSHJaVf3CMHf432fvf689L5NxKB9dYN9/TvLbO+Y4V9X9qurZw74NSR5dVb9UVSuSvCyTGcoLuU+S7UluTrKiql6byQrrafivSX6/qh5RE6ur6oGZjOX4mZrcvPLA4ePxw3zze1bVc6vqfsPYjG9nsvp4Vw5P8rKhxrOTHJXJbOgd3pnJjO7trbWPLVRgCJ4vTvKHrbVLFzpmF/7d0O8TMxlz8v7h+/iCJG+sqofW5MaT/3SYNf2+JGur6inDrOxXZjLW4xNJPpnJ1+1lNbl55S8lOW7Oa70tyYuq6vjhvTykqtZW1X3uRL8AAOyBwBoAYJlprf1da23jLnb/VpLrknyqqr6d5K/yo9nLb85k3u8tmdzA8S/vRht3uVZr7XNJXpLJDQNvSvLNJJv38txvtNY+PG/sw459f57JTScvGq79miSnDPtuSfLsJOuTbEnyiCQf38XL/I8k/z3JlzIZKbEtux/bMaY3ZhLSXpZJ8Pz2JAcNc8N/MZP55DdmMqLkP2YyazuZjO+YHd6HF2WYQ70Lf53J+3FLJrPInzXMyd7hXZncuHF3N1t8ZiZB97+pqu/O+/jvuzjnHzP52t+Y5N1JXtRa+8Kw71VJ/jaTGdTfGK7tHq21Lw7X8pah33+R5F+01n7QWvtBJjfc/NWh7nMy518hDP/N/EYm4fs3M/nv5Fd3c00AANwFtcDv6gAAAIuiqg7K5MaMx7bWvrxINU9M8qettVWLUQ8AgH5YYQ0AAIzpxUmuXKywGgCA/duKaTcAAADsn6pqNpObTT5jyq0AALCPMBIEAAAAAIAuGAkCAAAAAEAXBNYAAAAAAHRhn55h/aAHPajNzMxMuw0AAAAAAHbjqquuuqW1dtiejtunA+uZmZls3Lhx2m0AAAAAALAbVfUPe3OckSAAAAAAAHRBYA0AAAAAQBcE1gAAAAAAdGGfnmENAAAAALDUbr/99mzevDnbtm2bdivdWblyZVatWpUDDzzwLp0vsAYAAAAAuBM2b96c+9znPpmZmUlVTbudbrTWsmXLlmzevDkPf/jD71INI0EAAAAAAO6Ebdu25YEPfKCwep6qygMf+MC7tfJ8tMC6qh5WVR+pqmur6nNV9fJh++uq6qtV9Znh49Q55/x2VV1XVV+sqpPH6g0AAAAA4O4QVi/s7r4vY66w3p7kla21o5KckOQlVfWoYd+bWmtHDx+XJsmw7/Qkj07y1CR/VFUHjNgfAAAAAMA+qapy1lln7Xy+ffv2HHbYYTnttNOm2NXdN9oM69baTUluGh5/p6quTXLEbk55epKLWmvfT/L3VXVdkuOSfHKsHgEAAAAA7q6ZdRsWtd7s+rV7POaQQw7JNddck9tuuy0HHXRQLr/88hxxxO7i133DksywrqqZJMck+eth00uralNVXVBVhw7bjkhyw5zTNmf3ATcAAAAAwLJ1yimnZMOGSVh+4YUX5owzzti579Zbb83ZZ5+dxz/+8TnmmGPywQ9+MEkyOzubJz7xiTn22GNz7LHH5hOf+ESS5IorrsiJJ56YZz3rWfnZn/3ZPPe5z01rbcmvafTAuqruneTiJK9orX07yVuT/HSSozNZgf2GHYcucPpPvCNV9YKq2lhVG2+++eaRugYAAAAA6Nvpp5+eiy66KNu2bcumTZty/PHH79x37rnn5qSTTsqVV16Zj3zkI3n1q1+dW2+9NYcffnguv/zyfPrTn8573/vevOxlL9t5ztVXX503v/nN+fznP5+vfOUr+fjHP77k1zTaSJAkqaoDMwmr391a+7Mkaa19bc7+tyX50PB0c5KHzTl9VZIb59dsrZ2f5PwkWbNmzdJH/AAAAAAAHVi9enVmZ2dz4YUX5tRTT/2xfZdddlkuueSSvP71r0+SbNu2Lddff30e+tCH5qUvfWk+85nP5IADDsiXvvSlneccd9xxWbVqVZLk6KOPzuzsbH7hF35h6S4oIwbWNbkd5NuTXNtae+Oc7Q8Z5lsnyb9Mcs3w+JIk76mqNyZ5aJJHJPmbsfoDAAAAANjXPe1pT8urXvWqXHHFFdmyZcvO7a21XHzxxXnkIx/5Y8e/7nWvy4Mf/OB89rOfzQ9/+MOsXLly57573eteOx8fcMAB2b59+/gXMM+YI0GekOSsJCdV1WeGj1OT/EFV/W1VbUry5CT/Oklaa59L8r4kn0/yl0le0lq7Y8T+AAAAAAD2aWeffXZe+9rX5jGPecyPbT/55JPzlre8Zecc6quvvjpJsnXr1jzkIQ/JPe5xj7zrXe/KHXf0FcGOtsK6tfaxLDyX+tLdnHNuknPH6gkAAAAAYH+yatWqvPzlL/+J7eecc05e8YpXZPXq1WmtZWZmJh/60Ifym7/5m3nmM5+Z97///Xnyk5+cQw45ZApd71pN406Pi2XNmjVt48aN024DAAAAAFhGrr322hx11FHTbqNbC70/VXVVa23Nns4dcyQIAAAAAADsNYE1AAAAAABdEFgDAAAAANCF0W66CAAAwLhm1m0Ype7s+rWj1AUA2BMrrAEAAAAA6ILAGgAAAACALgisAQAAAAD2MVWVs846a+fz7du357DDDstpp512p+qceOKJ2bhxY5Lk1FNPzbe+9a1F7fPOMsMaAAAAAODueN39Frne1j0ecsghh+Saa67JbbfdloMOOiiXX355jjjiiLv1spdeeundOn8xWGENAAAAALAPOuWUU7Jhw+QmzBdeeGHOOOOMnftuvfXWnH322Xn84x+fY445Jh/84AeTJLfddltOP/30rF69Os95znNy22237TxnZmYmt9xyS5LkGc94Rh73uMfl0Y9+dM4///ydx9z73vfOa17zmjz2sY/NCSeckK997WuLek0CawAAAACAfdDpp5+eiy66KNu2bcumTZty/PHH79x37rnn5qSTTsqVV16Zj3zkI3n1q1+dW2+9NW9961tz8MEHZ9OmTXnNa16Tq666asHaF1xwQa666qps3Lgx5513XrZs2ZJkEoSfcMIJ+exnP5snPelJedvb3rao1ySwBgAAAADYB61evTqzs7O58MILc+qpp/7Yvssuuyzr16/P0UcfnRNPPDHbtm3L9ddfn49+9KP5lV/5lZ3nr169esHa55133s5V1DfccEO+/OUvJ0nuec977pyT/bjHPS6zs7OLek1mWAMAAAAA7KOe9rSn5VWvelWuuOKKnaugk6S1losvvjiPfOQjf+KcqtptzSuuuCJ/9Vd/lU9+8pM5+OCDdwbeSXLggQfuPP+AAw7I9u3bF/FqrLAGAAAAANhnnX322Xnta1+bxzzmMT+2/eSTT85b3vKWtNaSJFdffXWS5ElPelLe/e53J0muueaabNq06Sdqbt26NYceemgOPvjgfOELX8inPvWpka/iRwTWAAAAAAD7qFWrVuXlL3/5T2w/55xzcvvtt2f16tX5uZ/7uZxzzjlJkhe/+MX57ne/m9WrV+cP/uAPctxxx/3EuU996lOzffv2rF69Ouecc05OOOGE0a9jh9qRsO+L1qxZ0zZu3DjtNgAAAKZiZt2GUerOrl87Sl0A2F9ce+21Oeqoo6bdRrcWen+q6qrW2po9nWuFNQAAAAAAXRBYAwAAAADQBYE1AAAAAABdEFgDAAAAANxJ+/K9Acd0d98XgTUAAAAAwJ2wcuXKbNmyRWg9T2stW7ZsycqVK+9yjRWL2A8AAAAAwH5v1apV2bx5c26++eZpt9KdlStXZtWqVXf5fIE1AAAAAMCdcOCBB+bhD3/4tNvYLxkJAgAAAABAFwTWAAAAAAB0QWANAAAAAEAXBNYAAAAAAHRBYA0AAAAAQBcE1gAAAAAAdEFgDQAAAABAFwTWAAAAAAB0QWANAAAAAEAXBNYAAAAAAHRBYA0AAAAAQBcE1gAAAAAAdEFgDQAAAABAF1ZMuwEAAO6amXUbRqk7u37tKHUBAAD2xAprAAAAAAC6YIU1AAAAo/OvQgCAvWGFNQAAAAAAXRBYAwAAAADQBYE1AAAAAABdEFgDAAAAANAFgTUAAAAAAF0QWAMAAAAA0IUV024AgOVhZt2GRa85u37totcEAAAApkdgDQAAAAAwxxiLrhILr/aGkSAAAAAAAHRBYA0AAAAAQBcE1gAAAAAAdEFgDQAAAABAFwTWAAAAAAB0QWANAAAAAEAXBNYAAAAAAHRhxbQbAADuupl1Gxa95uz6tYteEwBgXzLG71iJ37MA9oYV1gAAAAAAdMEKawAAYHRWKwIAsDessAYAAAAAoAsCawAAAAAAuiCwBgAAAACgCwJrAAAAAAC6ILAGAAAAAKALAmsAAAAAALogsAYAAAAAoAsCawAAAAAAuiCwBgAAAACgCwJrAAAAAAC6ILAGAAAAAKALAmsAAAAAALogsAYAAAAAoAsCawAAAAAAuiCwBgAAAACgCwJrAAAAAAC6ILAGAAAAAKALAmsAAAAAALogsAYAAAAAoAujBdZV9bCq+khVXVtVn6uqlw/bH1BVl1fVl4fPhw7bq6rOq6rrqmpTVR07Vm8AAAAAAPRnzBXW25O8srV2VJITkrykqh6VZF2SD7fWHpHkw8PzJDklySOGjxckeeuIvQEAAAAA0JnRAuvW2k2ttU8Pj7+T5NokRyR5epJ3DIe9I8kzhsdPT/LONvGpJPevqoeM1R8AAAAAAH1ZsRQvUlUzSY5J8tdJHtxauymZhNpVdfhw2BFJbphz2uZh203zar0gkxXYOfLII0ftGwAAoGezK88cqfLWkeoCAOze6DddrKp7J7k4yStaa9/e3aELbGs/saG181tra1praw477LDFahMAAAAAgCkbNbCuqgMzCavf3Vr7s2Hz13aM+hg+f33YvjnJw+acvirJjWP2BwAAAABAP0YLrKuqkrw9ybWttTfO2XVJkucPj5+f5INztj+vJk5IsnXH6BAAAAAAAPZ/Y86wfkKSs5L8bVV9Ztj2O0nWJ3lfVf16kuuTPHvYd2mSU5Ncl+R7SX5txN4AAAAAAOjMaIF1a+1jWXgudZI8ZYHjW5KXjNUPAAAAAAB9G/2miwAAAAAAsDcE1gAAAAAAdEFgDQAAAABAF8a86SIAACOaXXnmSJW3jlQXAABg96ywBgAAAACgCwJrAAAAAAC6ILAGAAAAAKALAmsAAAAAALogsAYAAAAAoAsCawAAAAAAuiCwBgAAAACgCwJrAAAAAAC6ILAGAAAAAKALAmsAAAAAALogsAYAAAAAoAsCawAAAAAAuiCwBgAAAACgCwJrAAAAAAC6ILAGAAAAAKALAmsAAAAAALqwYtoNAAAAsP+bXXnmSJW3jlQXAJgGK6wBAAAAAOiCwBoAAAAAgC4IrAEAAAAA6ILAGgAAAACALrjpIgAAAADAHG4WPD1WWAMAAAAA0AWBNQAAAAAAXRBYAwAAAADQBYE1AAAAAABdEFgDAAAAANAFgTUAAAAAAF0QWAMAAAAA0AWBNQAAAAAAXRBYAwAAAADQBYE1AAAAAABdEFgDAAAAANCFFdNuAAAAAAC4a2bWbRil7uz6taPUhT0RWANLYowfoH54AgAAAOxfjAQBAAAAAKALAmsAAAAAALogsAYAAAAAoAsCawAAAAAAuiCwBgAAAACgCyum3QAAAAD0ZGbdhlHqzq5fO0pdANifCKwBYB82u/LMEapuHaEmAMC+Y5zfsRK/ZwHsmZEgAAAAAAB0QWANAAAAAEAXjAQBAABG55/XAwCwN6ywBgAAAACgCwJrAAAAAAC6YCQIwDwz6zYses3Z9WsXvSYwjjH+DEj8OQAAALA3rLAGAAAAAKALAmsAAAAAALogsAYAAAAAoAtmWAMAAADAHO5rAtNjhTUAAAAAAF0QWAMAAAAA0AWBNQAAAAAAXRBYAwAAAADQBYE1AAAAAABdEFgDAAAAANCFFdNuAIDlYXblmSNU3TpCTQAAAGBarLAGAAAAAKALAmsAAAAAALogsAYAAAAAoAsCawAAAAAAuiCwBgAAAACgCwJrAAAAAAC6ILAGAAAAAKALAmsAAAAAALogsAYAAAAAoAsCawAAAAAAuiCwBgAAAACgCwJrAAAAAAC6MFpgXVUXVNXXq+qaOdteV1VfrarPDB+nztn321V1XVV9sapOHqsvAAAAAAD6NOYK6z9J8tQFtr+ptXb08HFpklTVo5KcnuTRwzl/VFUHjNgbAAAAAACdGS2wbq19NMk39vLwpye5qLX2/dba3ye5LslxY/UGAAAAAEB/pjHD+qVVtWkYGXLosO2IJDfMOWbzsA0AAAAAgGViqQPrtyb56SRHJ7kpyRuG7bXAsW2hAlX1gqraWFUbb7755nG6BAAAAABgyS1pYN1a+1pr7Y7W2g+TvC0/GvuxOcnD5hy6KsmNu6hxfmttTWttzWGHHTZuwwAAAAAALJklDayr6iFznv7LJNcMjy9JcnpV3auqHp7kEUn+Zil7AwAAAABgulaMVbiqLkxyYpIHVdXmJL+X5MSqOjqTcR+zSV6YJK21z1XV+5J8Psn2JC9prd0xVm8AAAAAAPRntMC6tXbGApvfvpvjz01y7lj9AAAAAADQt6W+6SIAAAAAACxIYA0AAAAAQBdGGwnC+GbWbVj0mrPr1y56TQAAAACAvSGwBgAAAIB91OzKM0eqvHWkurB7AmsAANhHjfEv7hL/6g4AgOkxwxoAAAAAgC4IrAEAAAAA6ILAGgAAAACALgisAQAAAADogsAaAAAAAIAuCKwBAAAAAOjCimk3AAAAANw1M+s2jFJ3dv3aUeoCwJ5YYQ0AAAAAQBcE1gAAAAAAdEFgDQAAAABAFwTWAAAAAAB0QWANAAAAAEAXBNYAAAAAAHRBYA0AAAAAQBcE1gAAAAAAdGHFtBsA6M3syjNHqLp1hJrJzLoNi15zdv3aRa8JsC8Z48/WxJ+vsC8Z5/fBZKzfCQFgf3KnVlhX1SFjNQIAAAAAwPK2V4F1Vf18VX0+ybXD88dW1R+N2hkAAAAAAMvK3q6wflOSk5NsSZLW2meTPGmspgAAAAAAWH72eiRIa+2GeZvuWOReAAAAAABYxvb2pos3VNXPJ2lVdc8kL8swHgQAAAAAABbD3q6wflGSlyQ5IsnmJEcPzwEAAAAAYFHs1Qrr1totSZ47ci8AAAAAACxje7XCuqreUVX3n/P80Kq6YLy2AAAAAABYbvZ2hvXq1tq3djxprX2zqo4ZqScAAICpmVm3YZS6s+vXjlIXgMU3u/LMkSpvHaku7D/2NrC+R1Ud2lr7ZpJU1QPuxLkAI/2w94MegOXN/0wDALC/2dvQ+Q1JPlFVHxiePzvJueO0BAAAAADAcrS3N118Z1VtTHJSkkryS621z4/aGQAAAAAAy8puA+uqum9r7dvDCJB/TPKeOfse0Fr7xtgNAgAAAACwPOxphfV7kpyW5Kokbc72Gp7/nyP1BQAAAADAMrPbwLq1dlpVVZJ/1lq7fol6AgAAAABgGbrHng5orbUkf74EvQAAAAAAsIztMbAefKqqHj9qJwAAAAAALGt7mmG9w5OTvKiqZpPcmmGGdWtt9ViNAQAAAACwvOxtYH3KqF0AQEdm1m1Y9Jqz69cuek0AAADY3+w2sK6qlUlelOSfJPnbJG9vrW1fisYAAAAAAFhe9jTD+h1J1mQSVp+S5A2jdwQAAAAAwLK0p5Egj2qtPSZJqurtSf5m/JYAAAAAAFiO9rTC+vYdD4wCAQAAAABgTHtaYf3Yqvr28LiSHDQ8rySttXbfUbsDAAAAAGDZ2G1g3Vo7YKkaAQAAAABgedvTSBAAAAAAAFgSAmsAAAAAALogsAYAAAAAoAsCawAAAAAAuiCwBgAAAACgCwJrAAAAAAC6ILAGAAAAAKALAmsAAAAAALogsAYAAAAAoAsCawAAAAAAuiCwBgAAAACgCwJrAAAAAAC6sGLaDXDXza48c4SqW0eoCQAAAACwZ1ZYAwAAAADQBYE1AAAAAABdEFgDAAAAANAFgTUAAAAAAF1w00UAgDnGualx4sbGAAAAe2aFNQAAAAAAXRBYAwAAAADQBYE1AAAAAABdMMMa9mEz6zYses3Z9WsXvSYAAAAA7A0rrAEAAAAA6ILAGgAAAACALgisAQAAAADogsAaAAAAAIAuCKwBAAAAAOiCwBoAAAAAgC4IrAEAAAAA6ILAGgAAAACALowWWFfVBVX19aq6Zs62B1TV5VX15eHzocNZePqnAAAbSUlEQVT2qqrzquq6qtpUVceO1RcAAAAAAH0ac4X1nyR56rxt65J8uLX2iCQfHp4nySlJHjF8vCDJW0fsCwAAAACADq0Yq3Br7aNVNTNv89OTnDg8fkeSK5L81rD9na21luRTVXX/qnpIa+2msfoDAAAAls7Mug2j1J1dv3aUugBMx1LPsH7wjhB6+Hz4sP2IJDfMOW7zsA0AAAAAgGVitBXWd1ItsK0teGDVCzIZG5IjjzxyzJ4Auje78swRqm4doea+xfsKy9s4fwYk/hwAAIA9W+rA+ms7Rn1U1UOSfH3YvjnJw+YctyrJjQsVaK2dn+T8JFmzZs2CoTYAAAAsB/6SDYD9zVKPBLkkyfOHx89P8sE5259XEyck2Wp+NQAAAADA8jLaCuuqujCTGyw+qKo2J/m9JOuTvK+qfj3J9UmePRx+aZJTk1yX5HtJfm2svgAAAHbHilUAgOkZLbBurZ2xi11PWeDYluQlY/UCAAAAAED/lnokCAAAAAAALEhgDQAAAABAF0YbCQIAADvMrNswSt3Z9WtHqQsA+wo/Y4H9jcAa5hnjh70f9AAAAACwZ0aCAAAAAADQBYE1AAAAAABdEFgDAAAAANAFM6wBAAAAgNG5SSh7wwprAAAAAAC6ILAGAAAAAKALAmsAAAAAALogsAYAAAAAoAsCawAAAAAAuiCwBgAAAACgCyum3QDLw8y6DYtec3b92kWvCQAAAABMjxXWAAAAAAB0QWANAAAAAEAXBNYAAAAAAHRBYA0AAAAAQBcE1gAAAAAAdGHFtBsA7rrZlWeOUHXrCDUBAABY7mbWbRil7uz6taPUBabDCmsAAAAAALogsAYAAAAAoAsCawAAAAAAuiCwBgAAAACgCwJrAAAAAAC6ILAGAAAAAKALK6bdAACwPMys27DoNWfXr130mgAAAEyPwBoAAAAY3ezKM0eqvHWkuvsG7yuwvzESBAAAAACALgisAQAAAADogsAaAAAAAIAuCKwBAAAAAOiCwBoAAAAAgC4IrAEAAAAA6ILAGgAAAACALgisAQAAAADowoppNwC9mV155ghVt45QEwD2HeP8fE38jAUAgP2LFdYAAAAAAHRBYA0AAAAAQBcE1gAAAAAAdEFgDQAAAABAFwTWAAAAAAB0QWANAAAAAEAXBNYAAAAAAHRhxbQbAAAAAAD2f7Mrzxyp8taR6jINVlgDAAAAANAFK6xZEuP8DZq/PQMAAIB9hdW1wN6wwhoAAAAAgC4IrAEAAAAA6ILAGgAAAACALgisAQAAAADogsAaAAAAAIAuCKwBAAAAAOjCimk3AAAsD7Mrzxyh6tYRagIAADAtVlgDAAAAANAFgTUAAAAAAF0QWAMAAAAA0AWBNQAAAAAAXRBYAwAAAADQBYE1AAAAAABdEFgDAAAAANAFgTUAAAAAAF0QWAMAAAAA0AWBNQAAAAAAXRBYAwAAAADQBYE1AAAAAABdEFgDAAAAANAFgTUAAAAAAF0QWAMAAAAA0AWBNQAAAAAAXRBYAwAAAADQBYE1AAAAAABdEFgDAAAAANAFgTUAAAAAAF1YMY0XrarZJN9JckeS7a21NVX1gCTvTTKTZDbJL7fWvjmN/gAAAAAAWHrTXGH95Nba0a21NcPzdUk+3Fp7RJIPD88BAAAAAFgmehoJ8vQk7xgevyPJM6bYCwAAAAAAS2xagXVLcllVXVVVLxi2Pbi1dlOSDJ8Pn1JvAAAAAABMwVRmWCd5Qmvtxqo6PMnlVfWFvT1xCLhfkCRHHnnkWP0BAAAAALDEprLCurV24/D560n+PMlxSb5WVQ9JkuHz13dx7vmttTWttTWHHXbYUrUMAAAAAMDIljywrqpDquo+Ox4n+cUk1yS5JMnzh8Oen+SDS90bAAAAAADTM42RIA9O8udVteP139Na+8uqujLJ+6rq15Ncn+TZU+gNAAAAAIApWfLAurX2lSSPXWD7liRPWep+AAAAAADow1RmWAMAAAAAwHwCawAAAAAAuiCwBgAAAACgCwJrAAAAAAC6ILAGAAAAAKALAmsAAAAAALogsAYAAAAAoAsCawAAAAAAuiCwBgAAAACgCwJrAAAAAAC6ILAGAAAAAKALAmsAAAAAALogsAYAAAAAoAsCawAAAAAAuiCwBgAAAACgCwJrAAAAAAC6ILAGAAAAAKALAmsAAAAAALogsAYAAAAAoAsCawAAAAAAuiCwBgAAAACgCwJrAAAAAAC6ILAGAAAAAKALAmsAAAAAALogsAYAAAAAoAsCawAAAAAAuiCwBgAAAACgCwJrAAAAAAC6ILAGAAAAAKALAmsAAAAAALogsAYAAAAAoAsCawAAAAAAuiCwBgAAAACgCwJrAAAAAAC6ILAGAAAAAKALAmsAAAAAALogsAYAAAAAoAsCawAAAAAAuiCwBgAAAACgCwJrAAAAAAC6ILAGAAAAAKALAmsAAAAAALogsAYAAAAAoAsCawAAAAAAuiCwBgAAAACgCwJrAAAAAAC6ILAGAAAAAKALAmsAAAAAALogsAYAAAAAoAsCawAAAAAAuiCwBgAAAACgCwJrAAAAAAC6ILAGAAAAAKALAmsAAAAAALogsAYAAAAAoAsCawAAAAAAuiCwBgAAAACgCwJrAAAAAAC6ILAGAAAAAKALAmsAAAAAALogsAYAAAAAoAsCawAAAAAAuiCwBgAAAACgCwJrAAAAAAC6ILAGAAAAAKALAmsAAAAAALogsAYAAAAAoAsCawAAAAAAuiCwBgAAAACgCwJrAAAAAAC6ILAGAAAAAKALAmsAAAAAALogsAYAAAAAoAsCawAAAAAAuiCwBgAAAACgCwJrAAAAAAC60F1gXVVPraovVtV1VbVu2v0AAAAAALA0ugqsq+qAJP9fklOSPCrJGVX1qOl2BQAAAADAUugqsE5yXJLrWmtfaa39IMlFSZ4+5Z4AAAAAAFgCvQXWRyS5Yc7zzcM2AAD43+3de9AkVX3G8e+DC5SIxgWEgBDWyM1oyW1BTEARuahVIggEKOQmhGACRi0ttaAQg5YCISRiABERJaDITRYXQdEgSBAEXJZd5LJcIisElNKoEIm4v/xxzizN7FzembfPdL/L86mampnunp5nzpw5ffpMT4+ZmZmZma3kFBFNZ1hO0n7AHhFxZL5/MLB9RBxbWeYo4Kh8d3Pg3okHnXnWAX7ZdIgpctYynLUMZy3DWctw1jKctQxnLcNZy3DWMpy1DGctw1nLcNYynLWMmZS1SRtHxCuGLTRrEklGsBTYqHJ/Q+DR6gIRcQ5wziRDzXSSbouIuU3nmApnLcNZy3DWMpy1DGctw1nLcNYynLUMZy3DWctw1jKctQxnLcNZy5hJWWeCtp0S5MfAppJeJWk14ABgXsOZzMzMzMzMzMzMzGwCWnWEdUQ8K+kY4FrgRcB5EbG44VhmZmZmZmZmZmZmNgGtGrAGiIirgaubzrGSmUmnUHHWMpy1DGctw1nLcNYynLUMZy3DWctw1jKctQxnLcNZy3DWMpy1jJmUtfVa9aeLZmZmZmZmZmZmZvbC1bZzWJuZmZmZmZmZmZnZC5QHrGcQSedJekLSosq0/SQtlrRM0tzK9N0k3S7prny9S2XepyU9Iul3Xet/k6Q7JD0rad+ms0paQ9J8Sffkx322rVnzvG3z9CWSPidJlXnHSro3r/OUFmTtWQfyvL+WdHde50U1Z11L0ncl3Z+vZ+fpymW2RNJCSdtUHnNoXv5+SYfmaX3rRtuy5un752Wn9f4PyDpOHbhG0p35cWdLelGevpWkH0laIOk2SdvXnLXOcu35GmrKWWd79aH8mVoo6XuSNh4n55C845TrNZJ+LelbXevfRal9XSTpK5LGOn3YBOrqxbmeLpD0sKQF4+Qcknekcs2fn5tz1oWS9q+s63xJD1Uyb9Vk1jyvXx04Ji8fktYZN2ddWSVtnOvFgly2R1fW1Xd71lDWQXXgxsr7/6ikb9aYs87+4GGSflHJeuQ4OYfkrbMOrCbpHEn3KbXB+zSYc9D7X0vbWmfePK9nO1CZf8Z0Pl+lc0q6UKmPvSg/16o1Zx35s1VZZl7XurbM9eMuSVdJelnTWdVn/0XSiZJ+rufagXe0IGu//sBJub4skPQdSRvUnLXO+iqltvc+ST+V9P6as9bZf61tW1A6a55fch+2zm3s6ZUyvU/Sr1uQtV870HNdNWatpS8wrG40lHVQf+BLSm3ZQkmXSlpzOnlXahHhywy5AG8CtgEWVaa9BtgcuB6YW5m+NbBBvv064OeVeTsA6wO/61r/HOD1wFeBfZvOCqwBvCXfXg24EXh7G7Pm+7cCbwQEfLuS9S3AdcDq+f66Lcjarw5sCvwEmF0o6ynAx/LtjwEn59vvyGWmnO2WPH0t4MF8PTvfnj2obrQw69rAz4BX5OW+Ary1BXXgZflawGXAAfn+dyp19x3A9W0s10GvoYkyHVQnSW3AGvn2+4CLxy3Tuso1z3sr8E7gW5VpqwCPAJvl+/8IHNHGutr1XKcBJzRdrsBmwKb59gbAY8DL8/3zmeb2ahJ1oPJ+zAEeBtZpOivpM9XZhq6Zc3XqS8/tWRvrQNdzXQYc0vBnq19f4DDg83XU1QnVgU8Cn8q3Vxm3zpZ8/6mxba0zb57Xsx3I8+YCF3TXkTblzI9RvnwNeF/NWUf+bOVp7wYu6lrXj4E359vvBU5qOiv9919OBD48nTpaIGu/vuvLKsu8Hzi7xfX1cNL+6yr5fqP7hQzuvx5GTduCCWQtvQ9b2za267mOBc5rQdZ+7UDPdTX12aJPX2BQ3Wgw66B9gmqb9c+d9frS471oOoAvI75haQdyUY/pfRuR/OF5svPhrkzv2XhS0051nVnzvH8F/qaNWUkbo3sq8w4EvpBvfwPYdSbUgdwQH1kqK3AvsH6+vT5wb779BeDA7uWq5dhruUF1oy1Zge2A6yrTDwbObFEdWBW4Ctg/37+2cvtA4KI2luug19B0mQ6qk6TO4k3TKdM6yrVyf2eeP2D9CmBJ5f5OwNVtKNd+73Ne/hFyp7AN5VqZfifPdVbPp6YB65J1oOs5HmaaA9Z1lyvPfQm4Qdf0aQ9Yl64DlWkvBX5FZYdlujkr08f5bBUdsC5dB0if/5e0LWf1/afmtrXuvPRoB4AXAf9BDV8IlczZ9TwfBD5dZ9bK9Cl/tkgDKT8E/qLrdf8Glv+H1EbA3U1mZfD+y4nUNGBdV7lWpvft9wEfB85qa30lDQxu0sZyzfOW91+p/8vLklmL7sNOs74OGrD+T2C3JrMOagemsq7pZB33s5Wn9ewPdteNNmTN03v1BwWcBXy0rrq7sl18SpAXhn2An0TEM00HmYKeWSW9nPQt9fcaSdVbNesrgaWVeUvzNEjfru0k6RZJP5C03YRzwtTrwGbAZpJuUjotxNtqzrFeRDwGkK/XzdNfSdrh7OiUX7/pyxWsG3VlXQJsIWmO0s9/9yLtpEzaCnVA0rXAE8BvgUvz5A8Ap0p6BPgnUse/TrXWgT6vYVLGaa+OIH0LX7dRy7WfXwKrVn72ty+Tr69TrasdOwGPR8T9BbKMXa5Kp9NZDXigMvnT+ed/p0tavS1ZGzByVkkbSVqY558cEY+2NWtHnzoAsDfwvYj4TZHE/Y3SH9yn8lPVEm1ALXUgt7cAJymdbuMSSes1mbOj6/2fVNtaZztwDDCvs76a1d5eKZ0K5GDgmhpzTlX3Z+sk0i9/nu5abhGwZ769H833BwftvwAck9uB8zo/f5+wKfcHOqdfAA4CTqg5R5319dXA/kqn3fu2pE1rzjoVo/RfS28Lhplq1tL7sFMx0piL0ikCXwV8v2iq3kZpB0qqvT/YorGBaqYV+oOSvgz8N7AFcEbNWVcaHrBeyUl6LXAy8LdNZxmmX9Y8yPc14HMR8WAT2br1yKoei0W+nkU6lcEOwEeAb3TOCzUJI9aBWaQjgXYmfbt6bmVnsKR+5TeoXJuqGyNljYhfkU8DQfp50sPAs8XS9dCvDkTEHqRviFcHOucxex/wwYjYiHSk0pcmFbPHtKF1oM9rKG6c9krSe0g/rz51UjkZUn4rzIgI4ADgdEm3knYIJ1ZfR6yrHQeSynyShrVN65N+Rn94RCzLkz9O6pRuRzrFzUdLh+zE6TGtbx1oWN+sEfFIRLwe2AQ4tOZByXGMUwc6Jl5nR+wLXAXMyeV9HelUVpMyah2YBWxI+uXKNsDNpC9bG8sJK77/TbetjNgOKJ0DeD8mvxM9nfbqTOCGiLixxjxDdX+2lP6fYJOIuKLH4u8F/l7S7aRfWvzfxIIy8v7LWaTB1a1IP2U/rXjAilH7AxFxXO67Xkj6smUiMXtMG1ZfVwd+HxFzgS8C59WeaoAR+69NbgtGzdrUPuzArEMcAFwaEX8sk6q3EduBpozVH2zZ2EAnU8/+YEQcTjpVyE+B/VdYgwEesF6pSdoQuIJ0jsTuo3taZUjWc4D7I+JfJp9sRX2yLiXtMHVsCDxamXd5JLcCy4Bp/YnVNLMOshS4MiL+EBEPkX7SUuc3/4/nRrvTeD9Red7qt/ad8us3vaNk3agta0RcFRFviIg3ksq0xJGgPQ2rAxHxe2Ae8K486VDg8nz7EmDsP13so+460Os1FDVOeyVpV+A4YM9Cv3YZtVz7ioibI2KniNgeuIEJ1dcx6mqnY/pu0hdCJYxcrkp/ojUfOD4iflTJ/1jeDjwDfJnmP1tNGjtrPpJmMenI+kmorQ7keWuT3vv5hXNXn3OkvkBEPFlpp74IbFsgVl114EnSUaydwcFLSOedbCzngDZgEm1rXe3A1qTBgCWSHgbWkLSkhTnJ6/gE6bQrH6ox41B9PltvBLbN5fZD0lGf1wNExD0RsXtEbEsaVJnY/tmo+y8R8XhE/DEPsHyR+rdZo2Zdbki/7yLS0aN1qrO+LiWdfxvSa3x9jTkHGrX/OqFtQU9j9LVL78OOm3WQA5j8l9ejjmOUVnd/sE1jAwP7gwD5y4qLqb/NWml4wHollb9RnA98PCJuajrPIIOySvoU8Cek0xQ0rl/W/LOQ30raIR89fQhwZZ79TfIRAJI2I/0c5JdNZR3im6Q/iEPSOqSfV9X57eQ80oAo+frKyvRDlOwA/E8u02uB3SXNVvop4u552iTqRp1Z183Xs4G/A84tlPl5+tUBSWtWNrizSH8WcU+e/Sjw5nx7F+rfoa6lXIe8hmLGaa8kbU06v9meEfEEZYxarn1V6uvqpKOAzy4T+XnPOU5dBdiVdN696k8Z6zRSuUpajbQj8NWIuKS6osrrEOnUQIuoV211YAJGLdcNJb0Ylrejf0XaGW1j1r51INuPdE7T35cODuP1BTp1NduTdPRP3WqpA/nI5atIR9VB+qOzuxvMOagNmETbWks7EBHzI+JPI2JORMwBno6ITdqWE0DSkcAepHOIdv+aoZgB+wRnRcQGudx2BO6LiJ3zYzp1YBXgeCawfR2Ste/+S1c7sDf1b7NGyjqoP6Dnn1ZjT+rvD9a5fV2+X0jqb99Xc9aexuy/TmJbsIJxslJ+H3bkrEMetznpF9g3l8rW4znHGccorbb+4IC60VTWnv2BvNwmnduk05cU34edsaIFJ9L2ZWoX0jdwjwF/IH2TcwSpA7EUeAZ4HLg2L3s88BSwoHJZN887JT9mWb4+MU/fLt9/inTEyuIms5K+nQrSxrEz/cg2Zs3z5pI6cw8An4flf6qyGvDved4dwC4tyNqvDoj0T7V3A3eR/327xqxrk84ndX++XqvyvP+Wy+4unv+Pxu8lnQd6CemnNAyqG23LWln/3fkydpnW+Nlaj/RP9QtJ30yfAczKj9kRuJ30xxC3ANu2sVwHvYYWtlfX5XV0ps8rUAfGKdcbgV8A/5vXs0eefmp+HfcCH2hrXc2POx84ejrlWWe5Au/Jj6++jq3yvO/nZReRtglrtrgOvD/ff5b0Jda5DZfrbrkO3Jmvj6qsv+f2rI11IM+/HnhbgbpaZ1/gM6TP252kP93bogWfrUF1YGPSEcsL87r+rI3vPzW1rZNqB7qea+w/XSydk9ROPVAp7xOa/mxV1jeH5/9p1z+QBijvAz5L3ldouB3ot/9yQX4PFpIGZFb4E7FJZmVw3/Wy/BoWkr7AemWL62tn0PAu0mDllg2X66D+a23bgglkLb0PW9s2Ns87EfjsuBkn2A70XFdTny369AUG1Y0Gs/bsD5AOGr6J5/YJLmQaf8K9sl86FdHMzMzMzMzMzMzMrFE+JYiZmZmZmZmZmZmZtYIHrM3MzMzMzMzMzMysFTxgbWZmZmZmZmZmZmat4AFrMzMzMzMzMzMzM2sFD1ibmZmZmZmZmZmZWSt4wNrMzMzMbAyS9pa0oOuyTNLbJW0g6dIR17empC9IekDSYkk3SHrDCI8/UdKHR38lZmZmZmbtMavpAGZmZmZmM1FEXAFc0bkv6SjgIODaiFgG7DviKs8FHgI2jYhlkv4ceE1dec3MzMzMZgIfYW1mZmZmNk2SNgNOAA7Og81zJC3K8w6TdKWkayTdK+kTPR7/auANwPF5sJuIeDAi5uf5H5K0KF8+UHnccXmd1wGbV9eXn+92STdK2qJoAZiZmZmZ1cRHWJuZmZmZTYOkVYGLgA9HxM/6LLY98DrgaeDHkuZHxG2V+a8FFkTEH3usf1vgcNKAtoBbJP2AdPDJAcDWpH79HcDt+WHnAEdHxP35tCJnArtM75WamZmZmZXnAWszMzMzs+k5CVgcEV8fsMx3I+JJAEmXAzsCtw1YvmpH4IqIeKry+J1IA9ZXRMTTefq8fL0m8JfAJZI661h9pFdkZmZmZtYQD1ibmZmZmY1J0s7APsA2QxaNIfcXA1tKWqVzSpDq04ywXkgD2b+OiK2GZDIzMzMzax2fw9rMzMzMbAySZgNfBg6JiN8OWXw3SWtJejGwF3BTdWZEPEA64vqTyodFS9pU0ruAG4C9JK0h6SXA3sCNefrekl4s6aXAO/O6fgM8JGm/vB5J2rKml21mZmZmVpSPsDYzMzMzG8/RwLrAWZVTbwB8Brila9kfAhcAmwAXdZ2/uuNI4DRgiaSngSeBj0TEHZLOB27Ny50bET8BkHQxsAD4L9IgdsdBOdfxwKrA14E7x3ydZmZmZmYTo4hevyI0MzMzM7M6SDoMmBsRxzSdxczMzMys7XxKEDMzMzMzMzMzMzNrBR9hbWZmZmZmZmZmZmat4COszczMzMzMzMzMzKwVPGBtZmZmZmZmZmZmZq3gAWszMzMzMzMzMzMzawUPWJuZmZmZmZmZmZlZK3jA2szMzMzMzMzMzMxawQPWZmZmZmZmZmZmZtYK/w93lnTB2L2uWwAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 1800x576 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Plot Mean and Median\n",
    "plt.figure(figsize = (25,8));\n",
    "x_axis = np.arange(len(zipcode_prices['Zip Code']));\n",
    "tick_locations = [x for x in x_axis];\n",
    "plt.xticks(tick_locations, zipcode_prices['Zip Code']);\n",
    "plt.bar(x_axis, zipcode_prices['Mean'], label ='Mean',width = 0.5);\n",
    "plt.bar(x_axis, zipcode_prices['Median'], label = 'Median',width = 0.5);\n",
    "plt.legend(loc='best');\n",
    "plt.xlabel('Zip Code');\n",
    "plt.ylabel('Price');\n",
    "plt.title('Mean and Median Prices by Zipcode');"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>name</th>\n",
       "      <th>host_id</th>\n",
       "      <th>host_name</th>\n",
       "      <th>neighbourhood_group</th>\n",
       "      <th>neighbourhood</th>\n",
       "      <th>zipcode</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>room_type</th>\n",
       "      <th>price</th>\n",
       "      <th>minimum_nights</th>\n",
       "      <th>number_of_reviews</th>\n",
       "      <th>last_review</th>\n",
       "      <th>reviews_per_month</th>\n",
       "      <th>calculated_host_listings_count</th>\n",
       "      <th>availability_365</th>\n",
       "      <th>year_month</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3509</th>\n",
       "      <td>2708262</td>\n",
       "      <td>Beautiful 3-Story Townhouse</td>\n",
       "      <td>651125</td>\n",
       "      <td>Fleur</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Bedford-Stuyvesant</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.682107</td>\n",
       "      <td>-73.929733</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>250</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>8/9/2015</td>\n",
       "      <td>0.07</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>201701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5416</th>\n",
       "      <td>3637029</td>\n",
       "      <td>Cozy Wiliamsburg!</td>\n",
       "      <td>18343265</td>\n",
       "      <td>Melissa</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Bushwick</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.699419</td>\n",
       "      <td>-73.912094</td>\n",
       "      <td>Private room</td>\n",
       "      <td>65</td>\n",
       "      <td>4</td>\n",
       "      <td>18</td>\n",
       "      <td>12/22/2015</td>\n",
       "      <td>0.61</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>201701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17723</th>\n",
       "      <td>16242309</td>\n",
       "      <td>Spacious Luxury 1BR Apartment</td>\n",
       "      <td>1309215</td>\n",
       "      <td>Travis</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Greenpoint</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.720040</td>\n",
       "      <td>-73.953397</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>199</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>12/11/2016</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1</td>\n",
       "      <td>63</td>\n",
       "      <td>201701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17732</th>\n",
       "      <td>1156733</td>\n",
       "      <td>Beautiful 1BR in central Wil'burg</td>\n",
       "      <td>6338755</td>\n",
       "      <td>Stephanie</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Greenpoint</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.718978</td>\n",
       "      <td>-73.953360</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>175</td>\n",
       "      <td>4</td>\n",
       "      <td>12</td>\n",
       "      <td>9/16/2016</td>\n",
       "      <td>0.29</td>\n",
       "      <td>1</td>\n",
       "      <td>296</td>\n",
       "      <td>201701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17736</th>\n",
       "      <td>14104369</td>\n",
       "      <td>Bright 1 Bedroom in Central Williamsburg</td>\n",
       "      <td>17775452</td>\n",
       "      <td>Ben</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Greenpoint</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.719256</td>\n",
       "      <td>-73.949536</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>50</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>98</td>\n",
       "      <td>201701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17737</th>\n",
       "      <td>906616</td>\n",
       "      <td>Parkside with City Views + Terrace</td>\n",
       "      <td>2681667</td>\n",
       "      <td>Virginia</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Greenpoint</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.719079</td>\n",
       "      <td>-73.949854</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>229</td>\n",
       "      <td>2</td>\n",
       "      <td>27</td>\n",
       "      <td>10/10/2016</td>\n",
       "      <td>0.58</td>\n",
       "      <td>1</td>\n",
       "      <td>365</td>\n",
       "      <td>201701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17739</th>\n",
       "      <td>16415422</td>\n",
       "      <td>Beautiful entire apartment in Williamsburg, BK</td>\n",
       "      <td>107575736</td>\n",
       "      <td>Valentina</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Greenpoint</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.720125</td>\n",
       "      <td>-73.951459</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>180</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>45</td>\n",
       "      <td>201701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17759</th>\n",
       "      <td>9574823</td>\n",
       "      <td>1 Bedroom Loft in Williamsburg</td>\n",
       "      <td>2699292</td>\n",
       "      <td>Eric</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Greenpoint</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.720663</td>\n",
       "      <td>-73.953079</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>195</td>\n",
       "      <td>3</td>\n",
       "      <td>10</td>\n",
       "      <td>12/10/2016</td>\n",
       "      <td>0.91</td>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>201701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17787</th>\n",
       "      <td>1728625</td>\n",
       "      <td>New Williamsburg 1B With Backyard</td>\n",
       "      <td>9109049</td>\n",
       "      <td>Todd</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Greenpoint</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.719852</td>\n",
       "      <td>-73.940148</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>180</td>\n",
       "      <td>2</td>\n",
       "      <td>17</td>\n",
       "      <td>5/31/2016</td>\n",
       "      <td>0.60</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>201701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17800</th>\n",
       "      <td>11168007</td>\n",
       "      <td>Beautiful Studio in luxury building</td>\n",
       "      <td>6032945</td>\n",
       "      <td>Tabata</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Greenpoint</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.719869</td>\n",
       "      <td>-73.954271</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>110</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>201701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17808</th>\n",
       "      <td>289995</td>\n",
       "      <td>Loft Like w/Garden- Williamsburg Bedford L Stop</td>\n",
       "      <td>1505217</td>\n",
       "      <td>Pia</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Greenpoint</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.719466</td>\n",
       "      <td>-73.952522</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>250</td>\n",
       "      <td>30</td>\n",
       "      <td>32</td>\n",
       "      <td>8/26/2016</td>\n",
       "      <td>0.55</td>\n",
       "      <td>1</td>\n",
       "      <td>365</td>\n",
       "      <td>201701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17821</th>\n",
       "      <td>12874443</td>\n",
       "      <td>Modern Studio Apt in Williamsburg</td>\n",
       "      <td>8534626</td>\n",
       "      <td>Shannon</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Greenpoint</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.720831</td>\n",
       "      <td>-73.954008</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>125</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>9/4/2016</td>\n",
       "      <td>0.28</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>201701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17851</th>\n",
       "      <td>14437299</td>\n",
       "      <td>LUXURY Williamsburg 1 brdm/TERRACE/ McCarren Park</td>\n",
       "      <td>15376430</td>\n",
       "      <td>Wasif</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Greenpoint</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.720263</td>\n",
       "      <td>-73.953617</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>229</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>12/11/2016</td>\n",
       "      <td>0.84</td>\n",
       "      <td>1</td>\n",
       "      <td>364</td>\n",
       "      <td>201701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17858</th>\n",
       "      <td>10040649</td>\n",
       "      <td>Sunny and spacious corner apartment</td>\n",
       "      <td>12435489</td>\n",
       "      <td>Dymphna</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Greenpoint</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.720882</td>\n",
       "      <td>-73.953749</td>\n",
       "      <td>Private room</td>\n",
       "      <td>80</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>12/30/2015</td>\n",
       "      <td>0.08</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>201701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17890</th>\n",
       "      <td>3880985</td>\n",
       "      <td>Perfect Vacation Apt &amp; Location!</td>\n",
       "      <td>6435996</td>\n",
       "      <td>Laura</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Greenpoint</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.719978</td>\n",
       "      <td>-73.954322</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>195</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>1/3/2016</td>\n",
       "      <td>0.11</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>201701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17904</th>\n",
       "      <td>1538077</td>\n",
       "      <td>New Listing!  Terrific Price.</td>\n",
       "      <td>8200820</td>\n",
       "      <td>Valerie</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Greenpoint</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.719383</td>\n",
       "      <td>-73.951359</td>\n",
       "      <td>Private room</td>\n",
       "      <td>50</td>\n",
       "      <td>2</td>\n",
       "      <td>11</td>\n",
       "      <td>2/3/2014</td>\n",
       "      <td>0.28</td>\n",
       "      <td>2</td>\n",
       "      <td>306</td>\n",
       "      <td>201701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17986</th>\n",
       "      <td>14280892</td>\n",
       "      <td>Luxury huge 2 bed apt in heart of N. Williamsburg</td>\n",
       "      <td>19008481</td>\n",
       "      <td>Brooke</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Greenpoint</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.719688</td>\n",
       "      <td>-73.954547</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>249</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>9/18/2016</td>\n",
       "      <td>0.45</td>\n",
       "      <td>1</td>\n",
       "      <td>62</td>\n",
       "      <td>201701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18011</th>\n",
       "      <td>8223230</td>\n",
       "      <td>Bright and Cozy Room Williamsburg</td>\n",
       "      <td>43361668</td>\n",
       "      <td>Lia</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Greenpoint</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.719233</td>\n",
       "      <td>-73.952040</td>\n",
       "      <td>Private room</td>\n",
       "      <td>95</td>\n",
       "      <td>1</td>\n",
       "      <td>13</td>\n",
       "      <td>10/29/2016</td>\n",
       "      <td>0.82</td>\n",
       "      <td>1</td>\n",
       "      <td>365</td>\n",
       "      <td>201701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18044</th>\n",
       "      <td>9609049</td>\n",
       "      <td>Modern Apt in Williamsburg-roofdeck</td>\n",
       "      <td>2816129</td>\n",
       "      <td>Anne-Laure</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Greenpoint</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.719836</td>\n",
       "      <td>-73.953858</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>200</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>9/6/2016</td>\n",
       "      <td>0.56</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>201701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18057</th>\n",
       "      <td>3660983</td>\n",
       "      <td>Amazing LOFT in Prime Williamsburg</td>\n",
       "      <td>8182126</td>\n",
       "      <td>Maggie</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Greenpoint</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.719519</td>\n",
       "      <td>-73.948441</td>\n",
       "      <td>Private room</td>\n",
       "      <td>125</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>5/14/2016</td>\n",
       "      <td>0.13</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>201701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18070</th>\n",
       "      <td>2457182</td>\n",
       "      <td>Beautiful 1-bedroom near everything</td>\n",
       "      <td>285601</td>\n",
       "      <td>Anita</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Greenpoint</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.719425</td>\n",
       "      <td>-73.953369</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>200</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>87</td>\n",
       "      <td>201701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18074</th>\n",
       "      <td>10215758</td>\n",
       "      <td>Modern designer Williamsburg</td>\n",
       "      <td>9100622</td>\n",
       "      <td>Tashi</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Greenpoint</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.720022</td>\n",
       "      <td>-73.951860</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>220</td>\n",
       "      <td>2</td>\n",
       "      <td>31</td>\n",
       "      <td>12/11/2016</td>\n",
       "      <td>2.82</td>\n",
       "      <td>1</td>\n",
       "      <td>124</td>\n",
       "      <td>201701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18091</th>\n",
       "      <td>2485774</td>\n",
       "      <td>PRIME 1br in Williamsburg</td>\n",
       "      <td>12146974</td>\n",
       "      <td>Israel</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Greenpoint</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.721437</td>\n",
       "      <td>-73.939967</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>135</td>\n",
       "      <td>2</td>\n",
       "      <td>129</td>\n",
       "      <td>12/27/2016</td>\n",
       "      <td>3.78</td>\n",
       "      <td>1</td>\n",
       "      <td>355</td>\n",
       "      <td>201701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18095</th>\n",
       "      <td>16296071</td>\n",
       "      <td>Charming, Sunny Studio in Williamsburg</td>\n",
       "      <td>1470458</td>\n",
       "      <td>Ariella</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Greenpoint</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.719733</td>\n",
       "      <td>-73.954071</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>125</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>276</td>\n",
       "      <td>201701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18123</th>\n",
       "      <td>14547982</td>\n",
       "      <td>Modern Room with private bathroom</td>\n",
       "      <td>27427335</td>\n",
       "      <td>Tyler</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Greenpoint</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.719368</td>\n",
       "      <td>-73.953323</td>\n",
       "      <td>Private room</td>\n",
       "      <td>175</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>89</td>\n",
       "      <td>201701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18132</th>\n",
       "      <td>2816152</td>\n",
       "      <td>Bright/Sunny/1block from Bedfordsub</td>\n",
       "      <td>2739024</td>\n",
       "      <td>Jerome</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Greenpoint</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.720200</td>\n",
       "      <td>-73.951913</td>\n",
       "      <td>Private room</td>\n",
       "      <td>150</td>\n",
       "      <td>10</td>\n",
       "      <td>24</td>\n",
       "      <td>6/28/2015</td>\n",
       "      <td>0.81</td>\n",
       "      <td>1</td>\n",
       "      <td>363</td>\n",
       "      <td>201701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18137</th>\n",
       "      <td>455828</td>\n",
       "      <td>Amazing Studio Apartment for you!!!</td>\n",
       "      <td>1831271</td>\n",
       "      <td>Cambria</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Greenpoint</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.719670</td>\n",
       "      <td>-73.954061</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>275</td>\n",
       "      <td>2</td>\n",
       "      <td>19</td>\n",
       "      <td>10/29/2016</td>\n",
       "      <td>0.34</td>\n",
       "      <td>1</td>\n",
       "      <td>336</td>\n",
       "      <td>201701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18161</th>\n",
       "      <td>2026434</td>\n",
       "      <td>Fab Williamsburg Brooklyn Apt.</td>\n",
       "      <td>5772472</td>\n",
       "      <td>Anthony</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Greenpoint</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.720005</td>\n",
       "      <td>-73.954331</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>500</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>201701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18168</th>\n",
       "      <td>1304410</td>\n",
       "      <td>Luxury Apt w Roofdeck on the Park</td>\n",
       "      <td>7091172</td>\n",
       "      <td>Marley</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Greenpoint</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.719912</td>\n",
       "      <td>-73.950177</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>350</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>9/12/2016</td>\n",
       "      <td>0.27</td>\n",
       "      <td>1</td>\n",
       "      <td>365</td>\n",
       "      <td>201701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18193</th>\n",
       "      <td>9753443</td>\n",
       "      <td>Big Studio W/ Prive Patio +Amenity</td>\n",
       "      <td>2147475</td>\n",
       "      <td>Will</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Greenpoint</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.721073</td>\n",
       "      <td>-73.953762</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>159</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1/1/2017</td>\n",
       "      <td>2.00</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>201701</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476370</th>\n",
       "      <td>4729927</td>\n",
       "      <td>1 Bed heart of Lincoln Center</td>\n",
       "      <td>5538997</td>\n",
       "      <td>Lucky1</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Upper West Side</td>\n",
       "      <td>10023</td>\n",
       "      <td>40.777160</td>\n",
       "      <td>-73.978365</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>200</td>\n",
       "      <td>2</td>\n",
       "      <td>10</td>\n",
       "      <td>10/30/2016</td>\n",
       "      <td>0.38</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>201712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476372</th>\n",
       "      <td>21900339</td>\n",
       "      <td>Premium Manhattan Upper West Side Studio</td>\n",
       "      <td>23682172</td>\n",
       "      <td>Vatsala</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Upper West Side</td>\n",
       "      <td>10023</td>\n",
       "      <td>40.780598</td>\n",
       "      <td>-73.982701</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>120</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>201712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476373</th>\n",
       "      <td>18361390</td>\n",
       "      <td>Huge 1-bedroom with lofts near Central Park</td>\n",
       "      <td>127113351</td>\n",
       "      <td>Maria</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Upper West Side</td>\n",
       "      <td>10023</td>\n",
       "      <td>40.778269</td>\n",
       "      <td>-73.976726</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>149</td>\n",
       "      <td>7</td>\n",
       "      <td>2</td>\n",
       "      <td>8/26/2017</td>\n",
       "      <td>0.51</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>201712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476374</th>\n",
       "      <td>15870976</td>\n",
       "      <td>1 Bedroom, Brand New, Ideal UWS Location</td>\n",
       "      <td>8616101</td>\n",
       "      <td>Chris</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Upper West Side</td>\n",
       "      <td>10023</td>\n",
       "      <td>40.781460</td>\n",
       "      <td>-73.979175</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>265</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>11/25/2017</td>\n",
       "      <td>0.69</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>201712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476376</th>\n",
       "      <td>16395200</td>\n",
       "      <td>New, spacious, minimal 1 BR apt in Lincoln Center</td>\n",
       "      <td>33512180</td>\n",
       "      <td>J.</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Upper West Side</td>\n",
       "      <td>10023</td>\n",
       "      <td>40.774258</td>\n",
       "      <td>-73.991456</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>180</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>8/19/2017</td>\n",
       "      <td>0.45</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>201712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476379</th>\n",
       "      <td>4508885</td>\n",
       "      <td>Upper West Apartment Block Away from Central P...</td>\n",
       "      <td>301549</td>\n",
       "      <td>Michelle</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Upper West Side</td>\n",
       "      <td>10023</td>\n",
       "      <td>40.768853</td>\n",
       "      <td>-73.982543</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>180</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>201712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476382</th>\n",
       "      <td>12462634</td>\n",
       "      <td>Sunny and Beautiful UWS 1BDRM</td>\n",
       "      <td>48091946</td>\n",
       "      <td>Alexis</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Upper West Side</td>\n",
       "      <td>10023</td>\n",
       "      <td>40.777753</td>\n",
       "      <td>-73.981687</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>150</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>11/18/2016</td>\n",
       "      <td>0.26</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>201712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476385</th>\n",
       "      <td>20588062</td>\n",
       "      <td>The Columbus - A One Bedroom Apartment</td>\n",
       "      <td>147092207</td>\n",
       "      <td>Fernando</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Upper West Side</td>\n",
       "      <td>10023</td>\n",
       "      <td>40.772304</td>\n",
       "      <td>-73.982223</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>199</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>9/1/2017</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>201712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476387</th>\n",
       "      <td>4597234</td>\n",
       "      <td>GEM 1BR APT, 1 BLOCK FROM PARK IN UWS</td>\n",
       "      <td>6526081</td>\n",
       "      <td>Christian</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Upper West Side</td>\n",
       "      <td>10023</td>\n",
       "      <td>40.779019</td>\n",
       "      <td>-73.979356</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>225</td>\n",
       "      <td>10</td>\n",
       "      <td>5</td>\n",
       "      <td>10/31/2017</td>\n",
       "      <td>0.16</td>\n",
       "      <td>1</td>\n",
       "      <td>238</td>\n",
       "      <td>201712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476391</th>\n",
       "      <td>1058791</td>\n",
       "      <td>Promotional Rate @ Lincoln Center 3 adults</td>\n",
       "      <td>5830010</td>\n",
       "      <td>Alarea</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Upper West Side</td>\n",
       "      <td>10023</td>\n",
       "      <td>40.776309</td>\n",
       "      <td>-73.979891</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>175</td>\n",
       "      <td>5</td>\n",
       "      <td>82</td>\n",
       "      <td>11/19/2017</td>\n",
       "      <td>2.02</td>\n",
       "      <td>1</td>\n",
       "      <td>327</td>\n",
       "      <td>201712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476403</th>\n",
       "      <td>4464620</td>\n",
       "      <td>Steps To Central Park!</td>\n",
       "      <td>22862404</td>\n",
       "      <td>Tanya</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Upper West Side</td>\n",
       "      <td>10023</td>\n",
       "      <td>40.771438</td>\n",
       "      <td>-73.981918</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>255</td>\n",
       "      <td>7</td>\n",
       "      <td>20</td>\n",
       "      <td>11/2/2017</td>\n",
       "      <td>0.54</td>\n",
       "      <td>1</td>\n",
       "      <td>63</td>\n",
       "      <td>201712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476404</th>\n",
       "      <td>19013594</td>\n",
       "      <td>NYC Luxury 2BR+ apartment - 2 week minimum</td>\n",
       "      <td>845488</td>\n",
       "      <td>Paul</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Upper West Side</td>\n",
       "      <td>10023</td>\n",
       "      <td>40.773670</td>\n",
       "      <td>-73.982770</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>500</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>30</td>\n",
       "      <td>201712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476406</th>\n",
       "      <td>9444997</td>\n",
       "      <td>Central Park Room for 2 on the UWS</td>\n",
       "      <td>29417940</td>\n",
       "      <td>Tolley</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Upper West Side</td>\n",
       "      <td>10023</td>\n",
       "      <td>40.778127</td>\n",
       "      <td>-73.975736</td>\n",
       "      <td>Private room</td>\n",
       "      <td>150</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>8/22/2016</td>\n",
       "      <td>0.10</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>201712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476415</th>\n",
       "      <td>14949923</td>\n",
       "      <td>Luxury Apartment one block from Central Park</td>\n",
       "      <td>94087334</td>\n",
       "      <td>Aimee</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Upper West Side</td>\n",
       "      <td>10023</td>\n",
       "      <td>40.777184</td>\n",
       "      <td>-73.980226</td>\n",
       "      <td>Private room</td>\n",
       "      <td>110</td>\n",
       "      <td>1</td>\n",
       "      <td>14</td>\n",
       "      <td>10/28/2017</td>\n",
       "      <td>0.96</td>\n",
       "      <td>1</td>\n",
       "      <td>81</td>\n",
       "      <td>201712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476419</th>\n",
       "      <td>21502428</td>\n",
       "      <td>Private room in spacious apt by Columbus Circle</td>\n",
       "      <td>88381883</td>\n",
       "      <td>Haakim</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Upper West Side</td>\n",
       "      <td>10023</td>\n",
       "      <td>40.768828</td>\n",
       "      <td>-73.983050</td>\n",
       "      <td>Private room</td>\n",
       "      <td>120</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>357</td>\n",
       "      <td>201712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476420</th>\n",
       "      <td>6560165</td>\n",
       "      <td>Large Upper West Side 1 bedroom</td>\n",
       "      <td>23311838</td>\n",
       "      <td>Adrianna</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Upper West Side</td>\n",
       "      <td>10023</td>\n",
       "      <td>40.779095</td>\n",
       "      <td>-73.985647</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>175</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>6/11/2016</td>\n",
       "      <td>0.14</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>201712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476422</th>\n",
       "      <td>13113422</td>\n",
       "      <td>Clean, Open 1 bdrm Upper West- Steps from train</td>\n",
       "      <td>72918560</td>\n",
       "      <td>Lauren</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Upper West Side</td>\n",
       "      <td>10023</td>\n",
       "      <td>40.779950</td>\n",
       "      <td>-73.982205</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>294</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>201712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476424</th>\n",
       "      <td>16259045</td>\n",
       "      <td>Cozy Manhattan Apartment</td>\n",
       "      <td>106317734</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Upper West Side</td>\n",
       "      <td>10023</td>\n",
       "      <td>40.776647</td>\n",
       "      <td>-73.979404</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>290</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1/4/2017</td>\n",
       "      <td>0.09</td>\n",
       "      <td>1</td>\n",
       "      <td>59</td>\n",
       "      <td>201712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476426</th>\n",
       "      <td>11409352</td>\n",
       "      <td>Best location! View of Central Park, Near Subways</td>\n",
       "      <td>58059469</td>\n",
       "      <td>Julia</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Upper West Side</td>\n",
       "      <td>10023</td>\n",
       "      <td>40.769323</td>\n",
       "      <td>-73.983128</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>390</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>8/28/2017</td>\n",
       "      <td>0.16</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>201712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476428</th>\n",
       "      <td>13113181</td>\n",
       "      <td>New Year's Eve across from Central Park fireworks</td>\n",
       "      <td>35148560</td>\n",
       "      <td>Stefani</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Upper West Side</td>\n",
       "      <td>10023</td>\n",
       "      <td>40.779661</td>\n",
       "      <td>-73.974597</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>500</td>\n",
       "      <td>4</td>\n",
       "      <td>30</td>\n",
       "      <td>11/26/2017</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>72</td>\n",
       "      <td>201712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476432</th>\n",
       "      <td>6188014</td>\n",
       "      <td>Spacious 1 BR Near Central Park!</td>\n",
       "      <td>32096696</td>\n",
       "      <td>Matt</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Upper West Side</td>\n",
       "      <td>10023</td>\n",
       "      <td>40.779009</td>\n",
       "      <td>-73.975962</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>220</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>1/3/2016</td>\n",
       "      <td>0.13</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>201712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476437</th>\n",
       "      <td>16390341</td>\n",
       "      <td>A+ Times Square Apt~HUGE Balcony~Panoramic Views</td>\n",
       "      <td>79923778</td>\n",
       "      <td>Michael</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Upper West Side</td>\n",
       "      <td>10023</td>\n",
       "      <td>40.774079</td>\n",
       "      <td>-73.990493</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>699</td>\n",
       "      <td>4</td>\n",
       "      <td>17</td>\n",
       "      <td>7/22/2017</td>\n",
       "      <td>1.53</td>\n",
       "      <td>1</td>\n",
       "      <td>345</td>\n",
       "      <td>201712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476438</th>\n",
       "      <td>2103480</td>\n",
       "      <td>Thanksgiving in Manhattan!</td>\n",
       "      <td>10725397</td>\n",
       "      <td>Andrea</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Upper West Side</td>\n",
       "      <td>10023</td>\n",
       "      <td>40.778222</td>\n",
       "      <td>-73.980161</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>560</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>201712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476440</th>\n",
       "      <td>136528</td>\n",
       "      <td>Heart of UWS  2 bedroom, 1bath</td>\n",
       "      <td>655521</td>\n",
       "      <td>Karen</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Upper West Side</td>\n",
       "      <td>10023</td>\n",
       "      <td>40.777945</td>\n",
       "      <td>-73.977873</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>199</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>4/1/2013</td>\n",
       "      <td>0.09</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>201712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476443</th>\n",
       "      <td>19272890</td>\n",
       "      <td>1 bedroom apt with private terrace on UWS.</td>\n",
       "      <td>134961952</td>\n",
       "      <td>Ilona</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Upper West Side</td>\n",
       "      <td>10023</td>\n",
       "      <td>40.776505</td>\n",
       "      <td>-73.979136</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>230</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>201712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476448</th>\n",
       "      <td>14446717</td>\n",
       "      <td>1 Bedroom Apt, West 69th St, bwtn BWay &amp; Columbus</td>\n",
       "      <td>30045574</td>\n",
       "      <td>Barry</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Upper West Side</td>\n",
       "      <td>10023</td>\n",
       "      <td>40.774453</td>\n",
       "      <td>-73.980022</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>150</td>\n",
       "      <td>26</td>\n",
       "      <td>2</td>\n",
       "      <td>1/27/2017</td>\n",
       "      <td>0.15</td>\n",
       "      <td>1</td>\n",
       "      <td>322</td>\n",
       "      <td>201712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476451</th>\n",
       "      <td>19140493</td>\n",
       "      <td>Apt Near Central Park &amp; Trains to Time Square!</td>\n",
       "      <td>31877311</td>\n",
       "      <td>Maria</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Upper West Side</td>\n",
       "      <td>10023</td>\n",
       "      <td>40.779923</td>\n",
       "      <td>-73.982851</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>195</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>11/14/2017</td>\n",
       "      <td>1.54</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>201712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476452</th>\n",
       "      <td>18616208</td>\n",
       "      <td>For Elegant Events: Parlor w/Kitchen/Dining/Ga...</td>\n",
       "      <td>55017405</td>\n",
       "      <td>Lanie</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Upper West Side</td>\n",
       "      <td>10023</td>\n",
       "      <td>40.779777</td>\n",
       "      <td>-73.975982</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>1500</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>180</td>\n",
       "      <td>201712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476456</th>\n",
       "      <td>4233705</td>\n",
       "      <td>looking for someone to stay 12days</td>\n",
       "      <td>11243583</td>\n",
       "      <td>Joseph</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Upper West Side</td>\n",
       "      <td>10023</td>\n",
       "      <td>40.777152</td>\n",
       "      <td>-73.982347</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>260</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>201712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476459</th>\n",
       "      <td>16231826</td>\n",
       "      <td>Charming Lincoln Center Home near Central Park!!!</td>\n",
       "      <td>13080757</td>\n",
       "      <td>Angelina</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>Upper West Side</td>\n",
       "      <td>10023</td>\n",
       "      <td>40.774724</td>\n",
       "      <td>-73.981559</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>265</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>364</td>\n",
       "      <td>201712</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>314483 rows × 18 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              id                                               name  \\\n",
       "3509     2708262                       Beautiful 3-Story Townhouse    \n",
       "5416     3637029                                  Cozy Wiliamsburg!   \n",
       "17723   16242309                      Spacious Luxury 1BR Apartment   \n",
       "17732    1156733                  Beautiful 1BR in central Wil'burg   \n",
       "17736   14104369           Bright 1 Bedroom in Central Williamsburg   \n",
       "17737     906616                 Parkside with City Views + Terrace   \n",
       "17739   16415422     Beautiful entire apartment in Williamsburg, BK   \n",
       "17759    9574823                     1 Bedroom Loft in Williamsburg   \n",
       "17787    1728625                  New Williamsburg 1B With Backyard   \n",
       "17800   11168007                Beautiful Studio in luxury building   \n",
       "17808     289995    Loft Like w/Garden- Williamsburg Bedford L Stop   \n",
       "17821   12874443                  Modern Studio Apt in Williamsburg   \n",
       "17851   14437299  LUXURY Williamsburg 1 brdm/TERRACE/ McCarren Park   \n",
       "17858   10040649                Sunny and spacious corner apartment   \n",
       "17890    3880985                   Perfect Vacation Apt & Location!   \n",
       "17904    1538077                      New Listing!  Terrific Price.   \n",
       "17986   14280892  Luxury huge 2 bed apt in heart of N. Williamsburg   \n",
       "18011    8223230                  Bright and Cozy Room Williamsburg   \n",
       "18044    9609049                Modern Apt in Williamsburg-roofdeck   \n",
       "18057    3660983                 Amazing LOFT in Prime Williamsburg   \n",
       "18070    2457182                Beautiful 1-bedroom near everything   \n",
       "18074   10215758                       Modern designer Williamsburg   \n",
       "18091    2485774                          PRIME 1br in Williamsburg   \n",
       "18095   16296071             Charming, Sunny Studio in Williamsburg   \n",
       "18123   14547982                  Modern Room with private bathroom   \n",
       "18132    2816152                Bright/Sunny/1block from Bedfordsub   \n",
       "18137     455828                Amazing Studio Apartment for you!!!   \n",
       "18161    2026434                     Fab Williamsburg Brooklyn Apt.   \n",
       "18168    1304410                  Luxury Apt w Roofdeck on the Park   \n",
       "18193    9753443                 Big Studio W/ Prive Patio +Amenity   \n",
       "...          ...                                                ...   \n",
       "476370   4729927                      1 Bed heart of Lincoln Center   \n",
       "476372  21900339           Premium Manhattan Upper West Side Studio   \n",
       "476373  18361390        Huge 1-bedroom with lofts near Central Park   \n",
       "476374  15870976           1 Bedroom, Brand New, Ideal UWS Location   \n",
       "476376  16395200  New, spacious, minimal 1 BR apt in Lincoln Center   \n",
       "476379   4508885  Upper West Apartment Block Away from Central P...   \n",
       "476382  12462634                      Sunny and Beautiful UWS 1BDRM   \n",
       "476385  20588062             The Columbus - A One Bedroom Apartment   \n",
       "476387   4597234              GEM 1BR APT, 1 BLOCK FROM PARK IN UWS   \n",
       "476391   1058791         Promotional Rate @ Lincoln Center 3 adults   \n",
       "476403   4464620                             Steps To Central Park!   \n",
       "476404  19013594         NYC Luxury 2BR+ apartment - 2 week minimum   \n",
       "476406   9444997                 Central Park Room for 2 on the UWS   \n",
       "476415  14949923       Luxury Apartment one block from Central Park   \n",
       "476419  21502428    Private room in spacious apt by Columbus Circle   \n",
       "476420   6560165                    Large Upper West Side 1 bedroom   \n",
       "476422  13113422    Clean, Open 1 bdrm Upper West- Steps from train   \n",
       "476424  16259045                           Cozy Manhattan Apartment   \n",
       "476426  11409352  Best location! View of Central Park, Near Subways   \n",
       "476428  13113181  New Year's Eve across from Central Park fireworks   \n",
       "476432   6188014                   Spacious 1 BR Near Central Park!   \n",
       "476437  16390341   A+ Times Square Apt~HUGE Balcony~Panoramic Views   \n",
       "476438   2103480                         Thanksgiving in Manhattan!   \n",
       "476440    136528                     Heart of UWS  2 bedroom, 1bath   \n",
       "476443  19272890         1 bedroom apt with private terrace on UWS.   \n",
       "476448  14446717  1 Bedroom Apt, West 69th St, bwtn BWay & Columbus   \n",
       "476451  19140493     Apt Near Central Park & Trains to Time Square!   \n",
       "476452  18616208  For Elegant Events: Parlor w/Kitchen/Dining/Ga...   \n",
       "476456   4233705                 looking for someone to stay 12days   \n",
       "476459  16231826  Charming Lincoln Center Home near Central Park!!!   \n",
       "\n",
       "          host_id   host_name neighbourhood_group       neighbourhood  \\\n",
       "3509       651125       Fleur            Brooklyn  Bedford-Stuyvesant   \n",
       "5416     18343265     Melissa            Brooklyn            Bushwick   \n",
       "17723     1309215      Travis            Brooklyn          Greenpoint   \n",
       "17732     6338755   Stephanie            Brooklyn          Greenpoint   \n",
       "17736    17775452         Ben            Brooklyn          Greenpoint   \n",
       "17737     2681667    Virginia            Brooklyn          Greenpoint   \n",
       "17739   107575736   Valentina            Brooklyn          Greenpoint   \n",
       "17759     2699292        Eric            Brooklyn          Greenpoint   \n",
       "17787     9109049        Todd            Brooklyn          Greenpoint   \n",
       "17800     6032945      Tabata            Brooklyn          Greenpoint   \n",
       "17808     1505217         Pia            Brooklyn          Greenpoint   \n",
       "17821     8534626     Shannon            Brooklyn          Greenpoint   \n",
       "17851    15376430       Wasif            Brooklyn          Greenpoint   \n",
       "17858    12435489     Dymphna            Brooklyn          Greenpoint   \n",
       "17890     6435996       Laura            Brooklyn          Greenpoint   \n",
       "17904     8200820     Valerie            Brooklyn          Greenpoint   \n",
       "17986    19008481      Brooke            Brooklyn          Greenpoint   \n",
       "18011    43361668         Lia            Brooklyn          Greenpoint   \n",
       "18044     2816129  Anne-Laure            Brooklyn          Greenpoint   \n",
       "18057     8182126      Maggie            Brooklyn          Greenpoint   \n",
       "18070      285601       Anita            Brooklyn          Greenpoint   \n",
       "18074     9100622       Tashi            Brooklyn          Greenpoint   \n",
       "18091    12146974      Israel            Brooklyn          Greenpoint   \n",
       "18095     1470458     Ariella            Brooklyn          Greenpoint   \n",
       "18123    27427335       Tyler            Brooklyn          Greenpoint   \n",
       "18132     2739024      Jerome            Brooklyn          Greenpoint   \n",
       "18137     1831271     Cambria            Brooklyn          Greenpoint   \n",
       "18161     5772472     Anthony            Brooklyn          Greenpoint   \n",
       "18168     7091172      Marley            Brooklyn          Greenpoint   \n",
       "18193     2147475        Will            Brooklyn          Greenpoint   \n",
       "...           ...         ...                 ...                 ...   \n",
       "476370    5538997      Lucky1           Manhattan     Upper West Side   \n",
       "476372   23682172     Vatsala           Manhattan     Upper West Side   \n",
       "476373  127113351       Maria           Manhattan     Upper West Side   \n",
       "476374    8616101       Chris           Manhattan     Upper West Side   \n",
       "476376   33512180          J.           Manhattan     Upper West Side   \n",
       "476379     301549    Michelle           Manhattan     Upper West Side   \n",
       "476382   48091946      Alexis           Manhattan     Upper West Side   \n",
       "476385  147092207    Fernando           Manhattan     Upper West Side   \n",
       "476387    6526081   Christian           Manhattan     Upper West Side   \n",
       "476391    5830010      Alarea           Manhattan     Upper West Side   \n",
       "476403   22862404       Tanya           Manhattan     Upper West Side   \n",
       "476404     845488        Paul           Manhattan     Upper West Side   \n",
       "476406   29417940      Tolley           Manhattan     Upper West Side   \n",
       "476415   94087334       Aimee           Manhattan     Upper West Side   \n",
       "476419   88381883      Haakim           Manhattan     Upper West Side   \n",
       "476420   23311838    Adrianna           Manhattan     Upper West Side   \n",
       "476422   72918560      Lauren           Manhattan     Upper West Side   \n",
       "476424  106317734         NaN           Manhattan     Upper West Side   \n",
       "476426   58059469       Julia           Manhattan     Upper West Side   \n",
       "476428   35148560     Stefani           Manhattan     Upper West Side   \n",
       "476432   32096696        Matt           Manhattan     Upper West Side   \n",
       "476437   79923778     Michael           Manhattan     Upper West Side   \n",
       "476438   10725397      Andrea           Manhattan     Upper West Side   \n",
       "476440     655521       Karen           Manhattan     Upper West Side   \n",
       "476443  134961952       Ilona           Manhattan     Upper West Side   \n",
       "476448   30045574       Barry           Manhattan     Upper West Side   \n",
       "476451   31877311       Maria           Manhattan     Upper West Side   \n",
       "476452   55017405       Lanie           Manhattan     Upper West Side   \n",
       "476456   11243583      Joseph           Manhattan     Upper West Side   \n",
       "476459   13080757    Angelina           Manhattan     Upper West Side   \n",
       "\n",
       "        zipcode   latitude  longitude        room_type  price  minimum_nights  \\\n",
       "3509      11211  40.682107 -73.929733  Entire home/apt    250               4   \n",
       "5416      11211  40.699419 -73.912094     Private room     65               4   \n",
       "17723     11211  40.720040 -73.953397  Entire home/apt    199               4   \n",
       "17732     11211  40.718978 -73.953360  Entire home/apt    175               4   \n",
       "17736     11211  40.719256 -73.949536  Entire home/apt     50              20   \n",
       "17737     11211  40.719079 -73.949854  Entire home/apt    229               2   \n",
       "17739     11211  40.720125 -73.951459  Entire home/apt    180               3   \n",
       "17759     11211  40.720663 -73.953079  Entire home/apt    195               3   \n",
       "17787     11211  40.719852 -73.940148  Entire home/apt    180               2   \n",
       "17800     11211  40.719869 -73.954271  Entire home/apt    110               3   \n",
       "17808     11211  40.719466 -73.952522  Entire home/apt    250              30   \n",
       "17821     11211  40.720831 -73.954008  Entire home/apt    125               3   \n",
       "17851     11211  40.720263 -73.953617  Entire home/apt    229               2   \n",
       "17858     11211  40.720882 -73.953749     Private room     80               5   \n",
       "17890     11211  40.719978 -73.954322  Entire home/apt    195               2   \n",
       "17904     11211  40.719383 -73.951359     Private room     50               2   \n",
       "17986     11211  40.719688 -73.954547  Entire home/apt    249               2   \n",
       "18011     11211  40.719233 -73.952040     Private room     95               1   \n",
       "18044     11211  40.719836 -73.953858  Entire home/apt    200               3   \n",
       "18057     11211  40.719519 -73.948441     Private room    125               5   \n",
       "18070     11211  40.719425 -73.953369  Entire home/apt    200               5   \n",
       "18074     11211  40.720022 -73.951860  Entire home/apt    220               2   \n",
       "18091     11211  40.721437 -73.939967  Entire home/apt    135               2   \n",
       "18095     11211  40.719733 -73.954071  Entire home/apt    125               2   \n",
       "18123     11211  40.719368 -73.953323     Private room    175               3   \n",
       "18132     11211  40.720200 -73.951913     Private room    150              10   \n",
       "18137     11211  40.719670 -73.954061  Entire home/apt    275               2   \n",
       "18161     11211  40.720005 -73.954331  Entire home/apt    500               5   \n",
       "18168     11211  40.719912 -73.950177  Entire home/apt    350               4   \n",
       "18193     11211  40.721073 -73.953762  Entire home/apt    159               1   \n",
       "...         ...        ...        ...              ...    ...             ...   \n",
       "476370    10023  40.777160 -73.978365  Entire home/apt    200               2   \n",
       "476372    10023  40.780598 -73.982701  Entire home/apt    120               7   \n",
       "476373    10023  40.778269 -73.976726  Entire home/apt    149               7   \n",
       "476374    10023  40.781460 -73.979175  Entire home/apt    265               3   \n",
       "476376    10023  40.774258 -73.991456  Entire home/apt    180               5   \n",
       "476379    10023  40.768853 -73.982543  Entire home/apt    180              14   \n",
       "476382    10023  40.777753 -73.981687  Entire home/apt    150               2   \n",
       "476385    10023  40.772304 -73.982223  Entire home/apt    199               2   \n",
       "476387    10023  40.779019 -73.979356  Entire home/apt    225              10   \n",
       "476391    10023  40.776309 -73.979891  Entire home/apt    175               5   \n",
       "476403    10023  40.771438 -73.981918  Entire home/apt    255               7   \n",
       "476404    10023  40.773670 -73.982770  Entire home/apt    500              14   \n",
       "476406    10023  40.778127 -73.975736     Private room    150               2   \n",
       "476415    10023  40.777184 -73.980226     Private room    110               1   \n",
       "476419    10023  40.768828 -73.983050     Private room    120               3   \n",
       "476420    10023  40.779095 -73.985647  Entire home/apt    175               1   \n",
       "476422    10023  40.779950 -73.982205  Entire home/apt    294              14   \n",
       "476424    10023  40.776647 -73.979404  Entire home/apt    290               4   \n",
       "476426    10023  40.769323 -73.983128  Entire home/apt    390               5   \n",
       "476428    10023  40.779661 -73.974597  Entire home/apt    500               4   \n",
       "476432    10023  40.779009 -73.975962  Entire home/apt    220               1   \n",
       "476437    10023  40.774079 -73.990493  Entire home/apt    699               4   \n",
       "476438    10023  40.778222 -73.980161  Entire home/apt    560               1   \n",
       "476440    10023  40.777945 -73.977873  Entire home/apt    199               2   \n",
       "476443    10023  40.776505 -73.979136  Entire home/apt    230               5   \n",
       "476448    10023  40.774453 -73.980022  Entire home/apt    150              26   \n",
       "476451    10023  40.779923 -73.982851  Entire home/apt    195               1   \n",
       "476452    10023  40.779777 -73.975982  Entire home/apt   1500               1   \n",
       "476456    10023  40.777152 -73.982347  Entire home/apt    260               1   \n",
       "476459    10023  40.774724 -73.981559  Entire home/apt    265               1   \n",
       "\n",
       "        number_of_reviews last_review  reviews_per_month  \\\n",
       "3509                    2    8/9/2015               0.07   \n",
       "5416                   18  12/22/2015               0.61   \n",
       "17723                   1  12/11/2016               1.00   \n",
       "17732                  12   9/16/2016               0.29   \n",
       "17736                   0         NaN                NaN   \n",
       "17737                  27  10/10/2016               0.58   \n",
       "17739                   0         NaN                NaN   \n",
       "17759                  10  12/10/2016               0.91   \n",
       "17787                  17   5/31/2016               0.60   \n",
       "17800                   0         NaN                NaN   \n",
       "17808                  32   8/26/2016               0.55   \n",
       "17821                   2    9/4/2016               0.28   \n",
       "17851                   3  12/11/2016               0.84   \n",
       "17858                   1  12/30/2015               0.08   \n",
       "17890                   3    1/3/2016               0.11   \n",
       "17904                  11    2/3/2014               0.28   \n",
       "17986                   2   9/18/2016               0.45   \n",
       "18011                  13  10/29/2016               0.82   \n",
       "18044                   7    9/6/2016               0.56   \n",
       "18057                   1   5/14/2016               0.13   \n",
       "18070                   0         NaN                NaN   \n",
       "18074                  31  12/11/2016               2.82   \n",
       "18091                 129  12/27/2016               3.78   \n",
       "18095                   0         NaN                NaN   \n",
       "18123                   0         NaN                NaN   \n",
       "18132                  24   6/28/2015               0.81   \n",
       "18137                  19  10/29/2016               0.34   \n",
       "18161                   0         NaN                NaN   \n",
       "18168                   2   9/12/2016               0.27   \n",
       "18193                   2    1/1/2017               2.00   \n",
       "...                   ...         ...                ...   \n",
       "476370                 10  10/30/2016               0.38   \n",
       "476372                  0         NaN                NaN   \n",
       "476373                  2   8/26/2017               0.51   \n",
       "476374                  8  11/25/2017               0.69   \n",
       "476376                  5   8/19/2017               0.45   \n",
       "476379                  0         NaN                NaN   \n",
       "476382                  5  11/18/2016               0.26   \n",
       "476385                  1    9/1/2017                NaN   \n",
       "476387                  5  10/31/2017               0.16   \n",
       "476391                 82  11/19/2017               2.02   \n",
       "476403                 20   11/2/2017               0.54   \n",
       "476404                  0         NaN                NaN   \n",
       "476406                  2   8/22/2016               0.10   \n",
       "476415                 14  10/28/2017               0.96   \n",
       "476419                  0         NaN                NaN   \n",
       "476420                  4   6/11/2016               0.14   \n",
       "476422                  0         NaN                NaN   \n",
       "476424                  1    1/4/2017               0.09   \n",
       "476426                  3   8/28/2017               0.16   \n",
       "476428                 30  11/26/2017                NaN   \n",
       "476432                  4    1/3/2016               0.13   \n",
       "476437                 17   7/22/2017               1.53   \n",
       "476438                  0         NaN                NaN   \n",
       "476440                  7    4/1/2013               0.09   \n",
       "476443                  0         NaN                NaN   \n",
       "476448                  2   1/27/2017               0.15   \n",
       "476451                  9  11/14/2017               1.54   \n",
       "476452                  0         NaN                NaN   \n",
       "476456                  0         NaN                NaN   \n",
       "476459                  0         NaN                NaN   \n",
       "\n",
       "        calculated_host_listings_count  availability_365  year_month  \n",
       "3509                                 1                 0      201701  \n",
       "5416                                 1                 0      201701  \n",
       "17723                                1                63      201701  \n",
       "17732                                1               296      201701  \n",
       "17736                                1                98      201701  \n",
       "17737                                1               365      201701  \n",
       "17739                                1                45      201701  \n",
       "17759                                1                11      201701  \n",
       "17787                                1                 0      201701  \n",
       "17800                                1                 0      201701  \n",
       "17808                                1               365      201701  \n",
       "17821                                1                 0      201701  \n",
       "17851                                1               364      201701  \n",
       "17858                                1                 0      201701  \n",
       "17890                                1                 0      201701  \n",
       "17904                                2               306      201701  \n",
       "17986                                1                62      201701  \n",
       "18011                                1               365      201701  \n",
       "18044                                1                 1      201701  \n",
       "18057                                2                 0      201701  \n",
       "18070                                1                87      201701  \n",
       "18074                                1               124      201701  \n",
       "18091                                1               355      201701  \n",
       "18095                                1               276      201701  \n",
       "18123                                1                89      201701  \n",
       "18132                                1               363      201701  \n",
       "18137                                1               336      201701  \n",
       "18161                                1                 0      201701  \n",
       "18168                                1               365      201701  \n",
       "18193                                1                 2      201701  \n",
       "...                                ...               ...         ...  \n",
       "476370                               1                 1      201712  \n",
       "476372                               1                 9      201712  \n",
       "476373                               1                 1      201712  \n",
       "476374                               1                 4      201712  \n",
       "476376                               1                 0      201712  \n",
       "476379                               1                 0      201712  \n",
       "476382                               1                 0      201712  \n",
       "476385                               1                 7      201712  \n",
       "476387                               1               238      201712  \n",
       "476391                               1               327      201712  \n",
       "476403                               1                63      201712  \n",
       "476404                               1                30      201712  \n",
       "476406                               2                 0      201712  \n",
       "476415                               1                81      201712  \n",
       "476419                               1               357      201712  \n",
       "476420                               1                 0      201712  \n",
       "476422                               1                 0      201712  \n",
       "476424                               1                59      201712  \n",
       "476426                               1                 3      201712  \n",
       "476428                               1                72      201712  \n",
       "476432                               1                 0      201712  \n",
       "476437                               1               345      201712  \n",
       "476438                               1                 0      201712  \n",
       "476440                               1                 0      201712  \n",
       "476443                               1                 0      201712  \n",
       "476448                               1               322      201712  \n",
       "476451                               1                 5      201712  \n",
       "476452                               1               180      201712  \n",
       "476456                               1                 0      201712  \n",
       "476459                               2               364      201712  \n",
       "\n",
       "[314483 rows x 18 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Create Data Frame with specified zipcodes\n",
    "frames = []\n",
    "\n",
    "for zipcode in zipcodes:\n",
    "    one_zip = df.loc[df['zipcode']==zipcode]\n",
    "    frames.append(one_zip)\n",
    "\n",
    "by_zip = pd.concat(frames)\n",
    "by_zip"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "year_month\n",
       "201701    150.800856\n",
       "201702    130.879221\n",
       "201703    149.706457\n",
       "201704    149.437765\n",
       "201705    149.595444\n",
       "201706    150.184099\n",
       "201707    150.496529\n",
       "201708    150.649700\n",
       "201709    151.605723\n",
       "201710    151.728693\n",
       "201711    151.659429\n",
       "201712    150.576400\n",
       "Name: price, dtype: float64"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Find average prices by month\n",
    "by_month = by_zip.groupby('year_month')['price'].mean()\n",
    "by_month"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAmcAAAFNCAYAAABFbcjcAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMi4zLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvIxREBQAAIABJREFUeJzt3Xmc3HWd5/H3p9O5m9zQCSQkEJIACbk63EgSjxEQcHBmVtAZxxlHdNR13ZV1dsYZdXWZw2NcWGd0ZEDF1WR0PNZBBUQTkFNzH5BwJSQhQO6j07k6/dk/vr+iqjtd1VXd9Tuq8no+Hr9Hf39HV326+qh3f7/f3+9n7i4AAABkQ0PaBQAAACCPcAYAAJAhhDMAAIAMIZwBAABkCOEMAAAgQwhnAAAAGUI4A5BJZvZzM/vjtOvICjN7r5k9mnYdAOJHOAOQCDPbbGaHzazVzF4zs2+YWVOx4939Wnf/VpI1lsPMFpiZm9kPu2yfFW1fWoXnmBQ9VmNfHwtA7SGcAUjSDe7eJGmupIsl/XXXAyzI+t+mnZKuMLPRBdv+WNKzKdUDoI5k/Q8ggDrk7i9L+rmkGZJkZkvN7HYze0xSm6Rzo21/lvscM3u/mT1jZgfN7GkzmxttP9PMfmBmO81sk5l9tLvnNLPLzOxVM+tXsO0mM1sTtS8xs2VmdiDq2fvHEl/CMUk/lnRz9Ln9JP0nSd/p8pxXmNlvzWx/9PGKgn1LzexzZvZY9DU9aGZjot2PRB/3RT2Nlxd83hfNbG/0tV5bokYANYpwBiBxZjZB0nWSVhZs/iNJt0o6TdJLXY7/A0mfkfQeScMk3Shpd9TD9h+SVks6S9KbJH3MzN7a9Tnd/UlJhyS9sWDzuyR9N2rfIekOdx8mabKk7/XwZdwb1SNJb5W0XtL2gppHSfqppDsljZb0j5J+2qW37V2S/kTSGZIGSLot2n519HGEuze5+xPR+qWSNkoaI+nzku42M+uhTgA1hnAGIEk/NrN9kh6V9LCkvy3Y9013X+/u7e5+vMvn/Zmkz7v7bz143t1fUhgaPd3dP+vux9z9RUl3KerR6sYiSbdIkpmdphAQF0X7jks6z8zGuHtrFOaKcvfHJY0ys2kKIe3eLoe8TdJz7v7t6GtaJGmDpBsKjvmGuz/r7ocVwuDsUs8p6SV3v8vdT0j6lqRxkpp7+BwANYZwBiBJv+vuI9x9ort/KAolOVtLfN4ESS90s32ipDPNbF9ukfRXKh5YvivpHWY2UNI7JK2IQp4kvU/SVEkboiHI68v4er4t6SOSFkr6UZd9Z6pLD2C0flbB+qsF7TZJRU+Q6Hq8u7dFzZ4+B0CN4UwgAFnhJfZtVRhq7G77JnefUtYTuD9tZi9JuladhzTl7s9JuiUaKn2HpH83s9HufqjEQ35b0vOS7nX3ti4jjNsVwmOhsyXdX06pZRwDoE7RcwagFvyrpNvMrCU6m/M8M5so6TeSDpjZX5jZYDPrZ2YzzOziEo/1XUkfVZjX9f3cRjP7QzM73d07JO2LNp8oVZS7b5I0X9Inu9n9M0lTzexdZtZoZu+UdKGk+8r4endK6pB0bhnHAqgzhDMAmefu35d0u0KwOqhwpuSoaO7VDQpztTZJ2qUQ5IaXeLhFkhZI+pW77yrYfo2k9WbWqnBywM3ufqSM2h519+3dbN8t6XpJH5e0W9InJF3f5TmLPWabwtf7WDRce1lPnwOgfpg7vecAAABZQc8ZAABAhhDOAAAAMoRwBgAAkCGEMwAAgAwhnAEAAGRITV+EdsyYMT5p0qTYn+fQoUMaOnRo7M9TbdSdLOpOFnUni7qTV6u1U3dxy5cv3+Xup/d0XE2Hs0mTJmnZsmWxP8/SpUu1YMGC2J+n2qg7WdSdLOpOFnUnr1Zrp+7iojuU9IhhTQAAgAwhnAEAAGQI4QwAACBDCGcAAAAZQjgDAADIEMIZAABAhhDOAAAAMoRwBgAAkCE1fRFaAADqQnu7dPiwdORIWI4e1aDt26WtW6XGRql//7Dk2o2NUgP9K/WKcAYAQEdHPhgVWwrDUzlLJcefOHFSSZf1VHNDQ+ew1l2AK/WxWscUHtu/v4YcPCjNny+ZxfKtOhUQzgAA9eXIEempp6SHH9b0hx6SBg/uOTgdP5521ZXr6JCOHQtLhlwiSZ/6lPTWt4blzW+WRo5Mu6yaQjgDANS2Q4ekJ56QHn44LE899Xpg6fEO01nR0BBC5KBBYRk4UIfb2jS4sTEEx/b28LGwnWXbtkl33x2Whgbp0kvzYe3ii6V+/dKuMNMIZwCA2nLwoPTYY/kw9tvfhsDSV4XhqNRS7nGVHN948tvxU6VuxO0ees4Kw1p3Aa7Yx7iOOXhQ7UuXqvHQoXytHR0hPD/xhPSZz4RetDe/WbrmmhDWzjqr79+7OkM4AwBk27590q9/HYLYI49IK1Z0O0erk2nTpPnz9czo0bpg/vyeg1P//rU1R8os9D5lsAfqsV/+UvMHD5buv1964IEQnt3zB+zdK33/+2GRpOnT80HtDW8I349THOEMAJAtu3eHEJbrGVu9uvObe3dmzJCuvjpMRL/6amnsWEnSa0uX6oJivU+IhffrJ11xRVg++9nw/XzooRDU7r9feuWVzp+wfn1YvvSlEJbnz8+HtWnTais0VwnhDACQrtde6xzG1q0rfbyZNGtWeBOfPz/0towZk0ytqNzo0dI73xkW9/D9zQW1X/+68wkNhw+H7fffH9bPPjuEtGuukd70Jmn48HS+hoQRzgAAyXr55XwQe/hhaePG0sc3NEhz5+bD2FVXcfZfrTKTLrooLLfdFk7mePjhfFh79tnOx2/ZIt11V1j69ZMuuywf1ubOzeSwbjUQzgAA8dq8OT9f7OGHpRdeKH18Y2M4oy8Xxq64Qho2LJFSkbChQ6XrrguLFH5WHnggLA89FE7+yDlxIpwI8thj4VIdo0dLb3lL/izQceNS+RLiQDgDAFSPewhfhT1jW7aU/pwBA8KlFnJh7PLLw5s2Tj2TJkkf+EBYjh+XnnwyH9aWLet87O7d0uLFYZGkmTPzQe2qq6SBAxMvv1oIZ6W0t0sbN2rksmUSE0oB4GTu0oYNneeMbd9e+nMGDw4BLDd5/9JLwzagUP/+YT7hG94g/a//Je3cKf3iF/mw9tprnY9fsyYsX/iCNGSItHBhPqxNmVJTJxYQzorZvl067zzp8GFdOGyY9PGP19Q3FgBi0dERzqzLBbFHHpF27Cj9OUOHSldeme8Zu/ji0FsGVOL006V3vSssHR0hiOWC2qOPdr4wb1ub9NOfhkWSzjknH9Te+MbMD5MTzooZNy788Th8WP0PHAjd8hMnpl0VAFRf7qbbbW355dChTuvjlyyR7rgjnF23e3fpxxs2LAwr5cLY3LmhFwSoloYGafbssPzFX0itrdKSJfmw9vzznY/ftEn62tfC0tgY5jHmwtqcOZm7iTzhrBiz8AdlyZKwvmIF4QxAstzDZQYKQ1OJAFVyKXVsGfdmPK/UzpEj89cYmz8/XOaiTs+iQ0Y1NUk33BAWKcx7zAW1X/0qhLec9vbQ4/vII9InPxl65H7nd9R89tnSBRdIzc3pfA0FCGeldA1nN92Ubj0AakN7u7RnT5gjs2tX+Bi1J69ZEyYwlxugOjrS/mpOdvrpncPYjBmZ63nAKW7yZOlDHwrLsWPS44/nw9rKlZ2P3blT+s53dIEUzgj9h39Io+JOCGelzJ2bb69YkV4dANLjHkJSN0Gr6Me9e4te0X5CwuWXxSzMCxsypOjySlubxt14YwhjF1zAHFzUjgEDwkl9CxZIf/d34USCBx8MQe3BB8Pvbc5b35pWlZ0QzkohnAH158SJ0KvVNVSVClxHjqRX74ABJUPT60sP4arkMnBgj2Fr49KlGsdZ66gHzc3SH/1RWDo6Qk/aAw9oz49+pFFXXpl2dZIIZ6VNmRL+4B06JL36argfWB1d5A6oC21tlQWtPXt6vk9jX5lJo0aF4b8xYzp9fH7vXp03c2Z5IWvw4DB5GUA8GhqklhappUVrrrhCCzJybbTYfuvN7B5J10va4e4zom2fkfR+Sbk+xL9y959F+/5S0vsknZD0UXd/IK7aytavXzgT5LHHwvqKFdLb3pZuTcCp5tixMLl348Zwa5eNG6WNG3XZ88+Hq4e3tcVfw8CBIWB1E7a63TZqVNEJ8duWLtV59EABKCHOf8m+Kekrku7tsv3L7v7Fwg1mdqGkmyVNl3SmpIfMbKq7n4ixvvLMnUs4A+LmHnqmC8LX62Fs06YwFNnFoL4838iR5YWs3MehQ5ljBSAxsYUzd3/EzCaVefjbJS1296OSNpnZ85IukfRETOWVj3lnQPW0tkrPPdc5fOU+Ft5DrxL9+5ffo5Xr1eKaWwAyLI3JDB8xs/dIWibp4+6+V9JZkp4sOGZbtC19hDOgMidOSC+9dHIA27hRevnl3j3m2WdLU6dK06a9vjy1c6cuveEG6bTT6NUCUFfMY5wYG/Wc3Vcw56xZ0i5JLulzksa5+5+a2T9JesLd/2903N2SfubuP+jmMW+VdKskNTc3tyzO3fA0rq+hvV1XXXed+kW3hXjsxz/W8eHDY33OamltbVVTU1PaZVSMupPV27ob9+/XkK1bNWTbNg3eujW0t2zR4O3b1VB4G5UytQ8dqrYJE9Q2YYIOT5igtvHjQ3v8eHUMOnkQ81R7vdNG3cmr1dqpu7iFCxcud/d5PR2XaM+Zu79+l1Izu0vSfdHqNnW+/M94Sd3eOdfdvy7p65I0b948X5DAxNoDkydr2IYNkqQrhwypmZugL126VEm8PlW1Z4+e/PnPddmVV0rDh9fUhS1r8vVWD3UfPRpug9LdXLCebuHTncZG6dxz8z1gBb1hjWecoWFmKveOd3X5emcYdSevVmun7r5LNJyZ2Th3fyVavUnSuqj9E0nfNbN/VDghYIqk3yRZWymtU6a8Hs60YoX0lrekW1C9WrRI+sM/1GW5K6KbSSNGhDlCI0eGj13bxfZ109OCItylbdu6D2CbN/fuCvXNzd0GMJ1zDvO9AKAHcV5KY5GkBZLGmNk2SZ+WtMDMZisMa26W9AFJcvf1ZvY9SU9Lapf04UycqRk5OGVKfoV5Z/G5447OQcA9XGl9797KH2vw4OKBrlQ7y7117uFiqIW3+OmuXeH+N2zZ0ruLrA4enA9ehQFs6tTwOgIAeiXOszVv6Wbz3SWOv13S7XHV0xetU6fmVwhn8Th+XFq1Kr8+bJh04EDvH+/w4bBs73Z0vLiGhp5764q07fhxad++PgWlkvvb2mK5eGrJ21ObSRMnnjQZX1OnSuPHZzfIAkAN49LTZTh0zjlhrkx7e5h/s38/PQPVtm5dmN8k6Uhzswa9+mp4vfftC1d037s3fCy33YsJ6ZJCz13uMSo0v3fPmA0jRnQOX7kAdt55oYcMAJAYwlkZOgYMkKZPl1avDhtWrQo3/0X1/Pa3rzcPTpsWLjDa2BiuTzVmTGWPlbtRdSVhLtfuS29dEgYOPPkWP921K9j/2MaNuvLtb+dyFACQEYSzcs2dmw9nK1YQzqqtIJwdOP98nd6XxzIL4WPoUGnChJ6PL1TYW1cqzHWzz0+ckDU19RyMKglRXdtFbgnUF8dfe41gBgAZQjgr19y50je+EdrMO6u+Lj1nqelDb93DDz+cmdOwAQC1i9m85eJOAfFpawtzziIHC0/AqBX0PAEAqoRwVq5Zs/JvwBs2hLPoUB2rVuVvbD1tmk7U4JWlAQCoFsJZuYYOlc4/P7Q7OqQ1a9Ktp54UDGnq4ovTqwMAgAwgnFWCoc14EM4AAHgd4awShLN4EM4AAHgd4awShLPq27cv3MNRCmdKzp6dbj0AAKSMcFaJwuBQcEV79EFhyJ0xg6vRAwBOeYSzSowYIU2eHNrt7Z0u/4BeKhzSnDcvvToAAMgIwlmlGNqsLuabAQDQCeGsUoSz6iKcAQDQCeGsUoSz6tmxQ9qyJbQHDQpzzgAAOMURzio1Z06+vXq1dPx4erXUusJes9mzpf7906sFAICMIJxV6vTTpQkTQvvo0XArJ/QOQ5oAAJyEcNYbDG1WB+EMAICTEM56g3DWd+6EMwAAukE46w3CWd9t2SLt3Bnaw4ZJU6emWw8AABlBOOuNwnC2cqXU0ZFeLbWqsNespUVq4EcRAACJcNY748ZJzc2hfeiQ9Nxz6dZTi5Yty7cZ0gQA4HWEs94wY2izr5hvBgBAtwhnvUU4672Ojs49Z9xTEwCA1xHOeotw1nvPPScdOBDaY8ZIEyemWw8AABlCOOutruHMPb1aak3XIU2z9GoBACBjCGe9NXGiNHJkaO/bJ23enGo5NYX5ZgAAFEU46y1OCug9whkAAEURzvqCcFa548fDteFyCGcAAHRCOOsLwlnl1q+XjhwJ7QkT8teLAwAAkghnfVMYzpYv56SAcjCkCQBASYSzvjjvPKmpKbR37pS2b0+3nlrAnQEAACiJcNYXDQ3SnDn5dYY2e0bPGQAAJRHO+op5Z+U7ckRauza/3tKSXi0AAGQU4ayvCGflW7VKam8P7SlTpBEj0q0HAIAMIpz1FeGsfAxpAgDQI8JZX51/vjRoUGhv2ybt2JFuPVlGOAMAoEeEs75qbJRmzcqvF15gFZ0RzgAA6BHhrBoY2uzZgQPSxo2h3a9f57NcAQDA6whn1UA461nhRXqnT5eGDEm3HgAAMopwVg2Es54xpAkAQFkIZ9UwfbrUv39ov/iitHdvuvVkEeEMAICyEM6qYeBAacaM/PqqVenVklXctgkAgLIQzqqFoc3idu6UNm8O7YEDpYsuSrUcAACyjHBWLYSz4gp7zWbPzg8BAwCAkxDOqoVwVlzhfLN589KrAwCAGkA4q5aZM6WG6OXcuFFqbU23nizhZAAAAMpGOKuWIUOkCy4IbXdp9ep068kKd8IZAAAVIJxVE0ObJ9u2TXrttdBuapKmTUu3HgAAMo5wVk2Es5MV9pq1tIRbNwEAgKJiC2dmdo+Z7TCzdd3su83M3MzGROsLzGy/ma2Klk/FVVesCGcnY0gTAICKNMb42N+U9BVJ9xZuNLMJkt4iaUuX43/t7tfHWE/8Zs/Ot9evl44ckQYNSq+eLCCcAQBQkdh6ztz9EUl7utn1ZUmfkORxPXdqhg2TpkwJ7RMnpLVr060nbR0d3BkAAIAKJTrnzMxulPSyu3d3KuPlZrbazH5uZtOTrKuqGNrMe+EFaf/+0B49Wpo0KdVyAACoBeYeXweWmU2SdJ+7zzCzIZKWSPodd99vZpslzXP3XWY2TFKHu7ea2XWS7nD3KUUe81ZJt0pSc3Nzy+LFi2OrP6e1tVVNTU1lHTth0SJN/vrXJUnbr79ez37843GWVlIldcfhjIce0oW33y5J2n3JJVr7D/9Q1uelXXdvUXeyqDtZ1J28Wq2duotbuHDhcnfv+Wrs7h7bImmSpHVR+yJJOyRtjpZ2hXlnY7v5vM2SxvT0+C0tLZ6EJUuWlH/wL37hHq7u5T5vXmw1laOiuuPwsY/lX4u/+ZuyPy31unuJupNF3cmi7uTVau3UXZykZV5GforzhICuIXCtpDNy6116zsZKes3d3cwuURhu3Z1UbVU1Z06+vWaNdPz4qXsvSW7bBABAxeK8lMYiSU9ImmZm28zsfSUO/31J68xstaQ7Jd0cJczaM3q0NHFiaB87Jj39dLr1pKW9vfOcO04GAACgLLH1nLn7LT3sn1TQ/orCZTfqw9y50ksvhfaKFdKsWenWk4ann5YOHw7ts86Sxo1Ltx4AAGoEdwiIA2dscn0zAAB6iXAWB8IZ4QwAgF4inMWhMJytWhUuSHuqIZwBANArhLM4jB2bn2PV1iY9+2y69STtyJFwpmoOZ2oCAFA2wllcTuWhzTVrwtmaknTeedLIkenWAwBADSGcxeVUDmcMaQIA0GuEs7gQzgLCGQAAFSGcxaVrOOvoSK+WpBHOAADoNcJZXCZMCHcLkKQDB6RNm9KtJykHD0rPPBPaDQ2db2cFAAB6RDiLi9mpObS5YkW41bkkXXihNHRouvUAAFBjCGdxOhXDGUOaAAD0CeEsToSz9OoAAKBGEc7i1DWc5Yb76hnhDACAPiGcxencc6Vhw0J71y5p27Z064nbrl35Ex8GDJBmzky3HgAAahDhLE5dz1as96HNZcvy7VmzQkADAAAVIZzF7VSad1YYzhjSBACgVwhncTuVwhnzzQAA6DPCWdwIZwAAoAKEs7hNmyYNHhza27dLr76abj1xefll6ZVXQnvoUOn889OtBwCAGkU4i1u/ftLs2fn1lSvTqyVOhb1mLS3h6wYAABUjnCXhVBjaLAxn8+alVwcAADWOcJaEUy2cMd8MAIBeI5wlod7DmTuX0QAAoEoIZ0m48ML8BVk3b5b27Em1nKp74QVp797QHjUq3BkBAAD0CuEsCQMGSBddlF+vt5MCus43M0uvFgAAahzhLCktLfl2vQ1tMt8MAICqIZwlpZ7nnTHfDACAqiGcJaVew9mJE52/HsIZAAB9UlE4M7OhcRVS9y66KH9h1meflQ4cSLeeannmGenQodA+88ywAACAXisrnJnZFWb2tKRnovVZZvbPsVZWbwYNkqZPz6+vXp1eLdXEfDMAAKqq3J6zL0t6q6TdkuTuqyVdHVdRdasehzYJZwAAVFXZw5ruvrXLphNVrqX+1Xs447ZNAAD0WWOZx201syskuZkNkPRRRUOcqEC9hbOjRzsPzxLOAADos3J7zj4o6cOSzpK0TdLsaB2VmDUrf4HWp5+W2trSraev1qyRjh8P7XPPlUaPTrceAADqQFnhzN13ufu73b3Z3c9w9z90991xF1d3mpqkadNCu6NDWrs23Xr6ivlmAABUXblna37LzEYUrI80s3viK6uO1dPQJuEMAICqK3dYc6a778utuPteSXPiKanO1VM4484AAABUXbnhrMHMRuZWzGyUyj+ZAIXqJZwdOhTmzUlSQ0PnrwsAAPRauQHrS5IeN7N/j9b/QNLt8ZRU5+YUdDiuXSsdOyYNGJBePb21YkWYNydJF1wQ5tMBAIA+K/eEgHsl/Z6k1yTtkPQOd/92nIXVrREjwpmNUjjTcf36dOvpLeabAQAQi5LhzMyGRR9HSXpV0nclfUfSq9E29EY9DG0SzgAAiEVPPWffjT4ul7SsYMmtozcIZwAAoIiSc87c/XozM0nz3X1LQjXVv1oPZ3v2SC+8ENr9+0szZ6ZbDwAAdaTHOWfu7pJ+lEAtp47CkwJWr5ba29OrpTcKL6Exc6Y0cGB6tQAAUGfKvZTGk2bG2FW1nHGGNH58aB8+LG3cmG49lWJIEwCA2JQbzhYqBLQXzGyNma01szVxFlb3anlok3AGAEBsyg1n10o6V9IbJd0g6froI3qLcAYAALpR8oQAMxsk6YOSzpO0VtLd7l5jE6QyqlbD2fbtYZGkIUPCBWgBAEDV9NRz9i1J8xSC2bUKdwpANRSGs5Ur81fbz7rCkwHmzpUauYsXAADV1NM764XufpEkmdndkn4Tf0mniDPPDCcG7NghHTwYLk0xZUraVfWMIU0AAGLVU8/Z8VyD4cwqM6vNoU3CGQAAseopnM0yswPRclDSzFzbzA6U+kQzu8fMdpjZum723WZmbmZjonUzszvN7PnobNC5Jz9iHSoMZ8uXp1dHudwJZwAAxKxkOHP3fu4+LFpOc/fGgvawHh77m5Ku6brRzCZIeoukwjsOXCtpSrTcKumrlXwRNavWes42bQp3B5CkkSOlyZPTrQcAgDpU7qU0Kubuj0ja082uL0v6hCQv2PZ2Sfd68KSkEWY2Lq7aMqNrOHMvfmwWFPaazZsXhmYBAEBVmccYCMxskqT73H1GtH6jpDe5+38xs82S5rn7LjO7T9Lfu/uj0XG/lPQX7n7SzdXN7FaF3jU1Nze3LF68OLb6c1pbW9XU1FT9B3bXlTfeqP6trZKkJxct0pGxY6v28NWue/JXv6oJ3/ueJOmld71Lm97//qo9dqHYXu+YUXeyqDtZ1J28Wq2duotbuHDhcnef1+OB7h7bImmSpHVRe4ikpyQNj9Y3SxoTtX8q6aqCz/ulpJaeHr+lpcWTsGTJkvge/I1vdA99Zu4/+EFVH7rqdV99db7WH/6wuo9dINbXO0bUnSzqThZ1J69Wa6fu4iQt8zLyU2zDmt2YLOkcSaujXrPxklaY2VhJ2yRNKDh2vKTtCdaWnlqZd3biROeTFjgZAACAWCQWztx9rbuf4e6T3H2SQiCb6+6vSvqJpPdEZ21eJmm/u7+SVG2pqpVwtnGjdOhQaI8dK511Vrr1AABQp2ILZ2a2SNITkqaZ2TYze1+Jw38m6UVJz0u6S9KH4qorc7peTiOrJwV0vYQGJwMAABCL2O694+639LB/UkHbJX04rloybcoUqalJam0Ndwt45ZVw94Cs4fpmAAAkIsk5Z+hOQ4M0e3Z+PatDm4QzAAASQTjLgqzPOzt2TFq1Kr8+r+ezgAEAQO8QzrIg6+Fs7doQ0CTpnHOkMWPSrQcAgDpGOMuCrIczhjQBAEgM4SwLLrhAGjQotLdulXbuTLeerghnAAAkhnCWBY2N0syZ+fWVK9OrpTtd76kJAABiQzjLiqwObR46JK1fH9pmUktLuvUAAFDnCGdZkdVwtnKl1NER2uefL512Wrr1AABQ5whnWZHVcLZsWb7NfDMAAGJHOMuKGTPC3DNJeuEFad++dOvJ4WQAAAASRTjLioEDQ0DLKbzoa5oIZwAAJIpwliVZG9rct0967rnQbmyUZs1Ktx4AAE4BhLMsyVo4K5xvNnNm/lpsAAAgNoSzLMlaOGNIEwCAxBHOsmTmTKkh+pZs2BCuMZYmwhkAAIkjnGXJ0KHhWmKS5C6tXp1uPYQzAAASRzjLmqwMbb76qrRtW2gPHixdeGF6tQAAcAohnGVNVsJZYa/ZnDn5a7ABAIBYEc6yJovhjCFNAAASQzjLmtmz8+3166UjR9Kpg9s2AQCQCsJZ1gwfLp13Xmi3t0vr1iVfgzs9ZwAApIRwlkVpD22+9JK0a1doF4ZFAAAQO8JZFqUdzgp7zebNy197DQAAxI533SzKUjhjSBOLT6UDAAAUAklEQVQAgEQRzrJozpx8e80a6fjxZJ+fcAYAQGoIZ1k0Zox09tmhffSo9MwzyT13R4e0fHl+nXAGAECiCGdZldbQ5saN0sGDod3cLI0fn9xzAwAAwllmpRXOup4MYJbccwMAAMJZZmUhnDGkCQBA4ghnWVUYzlatkk6cSOZ5uTMAAACpIpxl1bhx0tixoX3okPTcc/E/5/HjIQjmEM4AAEgc4SzLkh7aXLcufy/PiROl00+P/zkBAEAnhLMsSzqcMd8MAIDUEc6yjHAGAMAph3CWZV3DmXu8z0c4AwAgdYSzLDv7bGnUqNDev1/atCm+52prC3POpHBts5aW+J4LAAAURTjLMrPkhjYLL9cxbZo0bFh8zwUAAIoinGVdUuGMIU0AADKBcJZ1hDMAAE4phLOsS+qkgK731AQAAKkgnGXd5MnSaaeF9s6d0ssvV/859u+Xnn02tBsbpdmzq/8cAACgLISzrGtokObMya/HMbS5fHm+PWOGNHhw9Z8DAACUhXBWC+Ked8Z8MwAAMoNwVgsIZwAAnDIIZ7WAcAYAwCmDcFYLpk3LzwN7+WXptdeq99g7dkhbtoT2oEHS9OnVe2wAAFAxwlktaGyUZs3Kr69cWb3HLuw1mzNH6t+/eo8NAAAqRjirFXENbTKkCQBAphDOagXhDACAUwLhrFbEEc7cCWcAAGRMbOHMzO4xsx1mtq5g2+fMbI2ZrTKzB83szGj7AjPbH21fZWafiquumjV9en4+2KZN0t69fX/MLVvCXQckadgwacqUvj8mAADokzh7zr4p6Zou277g7jPdfbak+yQVhrBfu/vsaPlsjHXVpgEDpIsuyq9X46SAZcvy7ZaWcDcCAACQqtjejd39EUl7umw7ULA6VFJMd/GuU9Ue2mRIEwCAzGlM+gnN7HZJ75G0X9LCgl2Xm9lqSdsl3ebu65OuLfMIZwAA1D1zj6/zyswmSbrP3Wd0s+8vJQ1y90+b2TBJHe7eambXSbrD3budAGVmt0q6VZKam5tbFi9eHFv9Oa2trWpqaor9eXpy2tNPq+XDH5YktU2YoN/ce2/J40vW3dGhq268UY2HDkmSnli0SEfHjq1qvb2Vlde7UtSdLOpOFnUnr1Zrp+7iFi5cuNzd5/V4oLvHtkiaJGldkX0TS+zbLGlMT4/f0tLiSViyZEkiz9Ojtjb3fv3cJXcz9wMHSh5esu4NG8LjSO6nn+7e0VHdWvsgM693hag7WdSdLOpOXq3WTt3FSVrmZeSnRGeAm1lhb9iNkjZE28eamUXtSxTmwu1OsraaMHiwdMEFoe0urV7d+8fqOqQZXn4AAJCy2OacmdkiSQskjTGzbZI+Lek6M5smqUPSS5I+GB3++5L+3MzaJR2WdHOUMNHV3LnSuujqJCtWSFdd1bvHYb4ZAACZFFs4c/dbutl8d5FjvyLpK3HVUlfmzpVyc836clIA4QwAgEziwla1phpnbB4/3vk6aYQzAAAyg3BWa2bPzrefflo6fLjyx1i/XjpyJLTPPls644zq1AYAAPqMcFZrTjtNmjo1tE+ckNaurfwxCu8MMK/nM3oBAEByCGe1qK9Dm8w3AwAgswhntYhwBgBA3SKc1aK+hLMjRzoPhba0VKcmAABQFYSzWjRnTr69dq107Fj5n7tqldTeHtpTp0ojRlS3NgAA0CeEs1o0apQ0aVJoHzsWztosF0OaAABkGuGsVvV2aJNwBgBAphHOahXhDACAukQ4q1W9CWcHDkgbN4Z2v36dL2gLAAAygXBWqwrD2apV4YK0PVm+XMrdT37GDGnIkHhqAwAAvUY4q1XNzdKZZ4b24cP5HrFSGNIEACDzCGe1rNKhTW7bBABA5hHOalml4YyeMwAAMo9wVssqCWc7d0qbN4f2wIHSRRfFVhYAAOg9wlktKwxnK1dKHR3Fjy0c0pw9W+rfP766AABArxHOatn48dKYMaF94ID04ovFj2VIEwCAmkA4q2Vm5Q9tEs4AAKgJhLNaV044cyecAQBQIwhnta6ccLZtm/Taa6F92mnStGnx1wUAAHqFcFbruoaz3B0AChX2mrW0SA182wEAyCrepWvduedKw4eH9u7d0tatJx/DkCYAADWDcFbrzKQ5c/Lr3Q1tEs4AAKgZhLN6UGremXvna5wRzgAAyDTCWT0oFc6ef17avz+0R4+WJk5Mri4AAFAxwlk9KBXOug5pmiVTEwAA6BXCWT2YOlUaMiS0X3klLDnMNwMAoKYQzupBv37hfpk5K1fm24QzAABqCuGsXnQztGknTnQe5iScAQCQeYSzetFNOBuyebN0+HDYNn68NHZs8nUBAICKEM7qRTfh7LQNG/Lb6DUDAKAmEM7qxYUXSgMGhPZLL0m7d2vYxo35/YQzAABqAuGsXvTvL82cmV9fuZKeMwAAahDhrJ4UDm0+/riGbtqUX583L/l6AABAxQhn9aQwnH3rW2pobw/tKVOkESPSqQkAAFSEcFZPCsPZiy/m2/SaAQBQMwhn9eSii8IFabtivhkAADWDcFZPBg2Spk8/eTvhDACAmkE4qzeFQ5uS1NAgzZmTTi0AAKBihLN60zWcTZ8uDR2aTi0AAKBihLN60zWcMaQJAEBNIZzVm1mzJLP8OuEMAICaQjirN01N4VZOOZddll4tAACgYoSzevT5z0vTpmnb7/2eNHt22tUAAIAKEM7q0XXXSRs26PmPfCTtSgAAQIUIZwAAABlCOAMAAMgQwhkAAECGEM4AAAAyJLZwZmb3mNkOM1tXsO1zZrbGzFaZ2YNmdma03czsTjN7Pto/t/gjAwAA1K84e86+KemaLtu+4O4z3X22pPskfSrafq2kKdFyq6SvxlgXAABAZsUWztz9EUl7umw7ULA6VJJH7bdLuteDJyWNMLNxcdUGAACQVY1JP6GZ3S7pPZL2S1oYbT5L0taCw7ZF215JtjoAAIB0mbv3fFRvH9xskqT73H1GN/v+UtIgd/+0mf1U0t+5+6PRvl9K+oS7L+/m825VGPpUc3Nzy+LFi2OrP6e1tVVNTU2xP0+1UXeyqDtZ1J0s6k5erdZO3cUtXLhwubvP6/FAd49tkTRJ0roi+ybm9kn6F0m3FOzbKGlcT4/f0tLiSViyZEkiz1Nt1J0s6k4WdSeLupNXq7VTd3GSlnkZ+SnRYU0zm+Luz0WrN0raELV/IukjZrZY0qWS9rt7j0Oay5cv32VmL8VTbSdjJO1K4HmqjbqTRd3Jou5kUXfyarV26i5uYjkHxRbOzGyRpAWSxpjZNkmflnSdmU2T1CHpJUkfjA7/maTrJD0vqU3Sn5TzHO5+epXL7paZLfNyuiEzhrqTRd3Jou5kUXfyarV26u672MKZu9/Szea7ixzrkj4cVy0AAAC1gjsEAAAAZAjhrDxfT7uAXqLuZFF3sqg7WdSdvFqtnbr7KNZLaQAAAKAy9JwBAABkCOEsYmataddQKTM7Ed1EPrdMKnHsAjO7L7nqitbhZvbtgvVGM9uZhdrKYWY3RV/D+WnXUo5af72l2vzdLNRT/Wa21MwycYZYrf1855jZJ81svZmtif4WXpp2TeUys/Fm9v/M7Dkze8HM7jCzASWO/5iZDUmyxi7P72b2pYL128zsM2nVU66C98v1ZrbazP6bmWU2A2W2MJTlsLvPLlg2p11QGQ5JmmFmg6P1t0h6uZIHMLPEbztW4BZJj0q6uZJPMrN+8ZTToz6/3jil9OrnO01mdrmk6yXNdfeZkt6szrcDzCwzM0k/lPRjd58iaaqkJkm3l/i0j0lKLZxJOirpHWY2JsUaeiP3fjld4e/gdQqX+MokwlkBM2sys1+a2QozW2tmb4+2TzKzZ8zsrih1P1jwZpcpZtbPzL5gZr+N/ov8QMHuYWb2IzN72sy+luJ/DT+X9LaofYukRbkdZnaJmT1uZiujj9Oi7e81s++b2X9IejD5ksPPh6QrJb1P0ZtX1CP5SHevq5m1mtlnzewpSZenUXOkN6/3r81sdsFxj5nZzESrLtC159fMvmJm743am83sfxb83mau16dU/VlR4ue72Ot+nZltMLNHzezOFHtjx0na5e5HJcndd7n7djNrMbOHzWy5mT1gZuOiupea2f+Oft7XmdklKdUtSW+UdMTdvxHVfkLSf5X0p2Y21My+GP1MrzGz/2xmH5V0pqQlZrYkpZrbFSbO/9euO8xsYvQeuib6eLaZDY9+R3N/F4eY2VYz65904TnuvkPhNpAfsaDo+6aZfSL6Hqw2s79PqkbCWWdHJN3k7nMVbsr+peg/G0maIumfotS9T9LvpVRjocGWH9L8UbTtfQp3WLhY0sWS3m9m50T7LpH0cUkXSZos6R2JVxwslnSzmQ2SNFPSUwX7Nki62t3nSPqUpL8t2He5pD929zcmVmlnvyvpfnd/VtIeM5sbbS/2ug5VuEXZpR7dNzYlvXm9/1XSeyXJzKZKGujuaxKruHK7ot/br0q6Le1ialSxn++TRD9L/yLpWne/SlIiFwQv4kFJE8zsWTP7ZzObH73x/x9Jv+/uLZLuUefeqKHufoWkD0X70jJdUqd7SLv7AUlbJP2ZpHMkzYl6BL/j7ndK2i5pobsvTLrYAv8k6d1mNrzL9q9IujdXr6Q73X2/pNWS5kfH3CDpAXc/nli13XD3FxUy0Bkq8r5pZtcq/F5c6u6zJH0+qfoIZ52ZpL81szWSHpJ0lqTmaN8md18VtZcr3Dc0bYXDmjdF235H0nvMbJXCm/BohWApSb9x9xej/84WSboq+ZKl6E1+kkIvzs+67B4u6ftmtk7SlxX+eOX8wt33JFJk925RCDqKPuYutFzsdT0h6QfJlniyXr7e35d0ffQm96eSvplIsb33w+hjVn43a1Gxn+/unC/pRXffFK0vKnFsrNy9VVKLQk/ITkn/JukDkmZI+kX0t/CvJY0v+LRF0ec+ojCiMCLRovNMUneXTDBJV0v6mru3S1LKf/s6iQLkvZI+2mXX5ZK+G7W/rfzfwn+T9M6ofXO0ngW5zpdi75tvlvQNd2+Tkv0epDl3J4verfAfYIu7HzezzZIGRfuOFhx3QlImhzUVftj+s7s/0Gmj2QKd/Ecgzeuo/ETSFxVu8TW6YPvnJC1x95ssnOCwtGDfoYRqO4mZjVYYgphhZi6pn8Lr9zMVf12PRIEtCyp6vd29zcx+Ientkv6TpLQnrLer8z+Tg7rsz/1+nlA2/671VH+qSvx8/0Td123KkOj3bKmkpWa2VuGOM+vdvdh0gqz8LVyvLqMwZjZM0gRJLyrdv9E9+d+SVkj6RoljcvX/RNLfmdkohSD9q5hr65GZnavw92KHir9vXqOUvgf0nHU2XNKOKJgtVJk3KM2YByT9eW4838ymmtnQaN8lUVdtg8J/MWkOtd0j6bPuvrbL9uHKT1h/b6IVlfb7Ct31E919krtPkLRJ4T/DLL2uxfTm9f5XSXdK+m0G/mt/SdKFZjYwGkp5U8r1VCrr9Rf7+Za6r3uDpHMtf4b4O5USM5tmZlMKNs2W9Iyk0y2cLCAz629mhb3w74y2X6UwnLU/sYI7+6WkIWb2nqiefpK+pNBT/aCkD1p0AlQUbCTpoKTTki+1s+hvwvcUhgRzHlf+ZJJ3K/pbGPVu/kbSHZLuS/ufVjM7XdLXJH0lun1ksffNBxXm/w2Jto8q9pjVlsX/MBMX/fAfVRgj/w8zWyZplcIfoFrzrwrDOiui+XI7FcbMJekJSX+vMDfqEUk/6u4BkuDu2xR+Ubv6vKRvmdl/Uwb+uypwi8JrV+gHkv5cGXpdi+nN6+3uy83sgEr/Zxyr3O+mu281s+9JWiPpOUkr06qpEjVUf7Gf73cpvAF3qtvdD5vZhyTdb2a7FN5409Ik6f9EQ5Ptkp5XGOL8uqQ7o1DZqNDTsz76nL1m9rikYQrD9qlwdzezmyT9s5n9jUKHyc8k/ZVCr85USWvM7LikuxTmdH1d0s/N7JWU551JIUh+pGD9o5LuMbP/rvDe8ycF+/5NYbrEgsSq62xwNGzZX+Hn5NuS/jHa1+37prvfb+HEqGVmdkz5703suEOAJDObJekud0/zrB3UoGi4+DZ3vz7tWqrNzM5UGCo63907Uqqhpn83a73+Usysyd1bozezf5L0nLt/Oe26emJmSxV+Z5elXQtQzCk/rGlmH1SYHPrXadcCZEU0zPKUpE+mGMxq+nez1usvw/ujnoj1CsPj/5JyPUDdoOcMAAAgQ075njMAAIAsIZwBAABkCOEMAAAgQwhnAOqWmbmZfbtgvdHMdlov7wNpZiOiS0jk1hf09rEAoBjCGYB6dkjhqve5O3q8RfmL7vbGCIX7MQJAbAhnAOrdzyW9LWrfooL7QJrZKDP7sZmtMbMnzWxmtP0zZnaPmS01sxfNLHcPwb+XNNnMVpnZF6JtTWb272a2wcy+E133CwB6jXAGoN4tlnSzmQ2SNFPh+m05/1PSSnefqXDl73sL9p0v6a2SLpH06ejWLv9D0gvuPtvd/3t03BxJH5N0oaRzJV0Z5xcDoP4RzgDUNXdfo3BrllsUbr9S6CqF27jI3X8laXR0ux9J+qm7H3X3XQo3R24u8hS/cfdt0cV6V0XPBQC9xr01AZwKfiLpiwr39RtdsL27IcjclbmPFmw7oeJ/L8s9DgDKQs8ZgFPBPZI+6+5ru2x/RNK7pdfvk7rL3Q+UeJyDkk6LpUIAiPAfHoC65+7bJN3Rza7PSPqGma2R1Cbpj3t4nN1m9piZrVM40eCn1a4VALi3JgAAQIYwrAkAAJAhhDMAAIAMIZwBAABkCOEMAAAgQwhnAAAAGUI4AwAAyBDCGQAAQIYQzgAAADLk/wPHt9qBQ/qyUQAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 720x360 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Plot averages\n",
    "plt.figure(figsize=(10,5))\n",
    "x_axis = np.arange(len(by_month))\n",
    "tick_locations = [x for x in x_axis]\n",
    "plt.xticks(tick_locations, ['Jan','Feb','Mar','Apr','May','Jun',\n",
    "                            'Jul','Aug','Sep','Oct','Nov','Dec'])\n",
    "plt.plot(x_axis, by_month, color='r', linewidth=3)\n",
    "plt.grid()\n",
    "plt.xlabel('Month')\n",
    "plt.ylabel('Price')\n",
    "plt.title('Price vs Month')\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}