2015 Prices by Zipcode and Month.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>name</th>\n",
       "      <th>host_id</th>\n",
       "      <th>host_name</th>\n",
       "      <th>neighbourhood_group</th>\n",
       "      <th>neighbourhood</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>room_type</th>\n",
       "      <th>price</th>\n",
       "      <th>minimum_nights</th>\n",
       "      <th>number_of_reviews</th>\n",
       "      <th>last_review</th>\n",
       "      <th>reviews_per_month</th>\n",
       "      <th>calculated_host_listings_count</th>\n",
       "      <th>availability_365</th>\n",
       "      <th>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>12503</td>\n",
       "      <td>12503</td>\n",
       "      <td>12503</td>\n",
       "      <td>9496</td>\n",
       "      <td>12500</td>\n",
       "      <td>12500</td>\n",
       "      <td>12503</td>\n",
       "      <td>12503</td>\n",
       "      <td>12503</td>\n",
       "      <td>12503</td>\n",
       "      <td>12503</td>\n",
       "      <td>12503</td>\n",
       "      <td>9941</td>\n",
       "      <td>9941</td>\n",
       "      <td>12503</td>\n",
       "      <td>12502</td>\n",
       "      <td>12503</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10002</th>\n",
       "      <td>9224</td>\n",
       "      <td>9224</td>\n",
       "      <td>9224</td>\n",
       "      <td>9094</td>\n",
       "      <td>9221</td>\n",
       "      <td>9221</td>\n",
       "      <td>9224</td>\n",
       "      <td>9224</td>\n",
       "      <td>9224</td>\n",
       "      <td>9224</td>\n",
       "      <td>9224</td>\n",
       "      <td>9224</td>\n",
       "      <td>7340</td>\n",
       "      <td>7340</td>\n",
       "      <td>9224</td>\n",
       "      <td>9224</td>\n",
       "      <td>9224</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10009</th>\n",
       "      <td>9081</td>\n",
       "      <td>9081</td>\n",
       "      <td>9081</td>\n",
       "      <td>8794</td>\n",
       "      <td>9080</td>\n",
       "      <td>9080</td>\n",
       "      <td>9081</td>\n",
       "      <td>9081</td>\n",
       "      <td>9081</td>\n",
       "      <td>9081</td>\n",
       "      <td>9081</td>\n",
       "      <td>9081</td>\n",
       "      <td>7046</td>\n",
       "      <td>7046</td>\n",
       "      <td>9081</td>\n",
       "      <td>9081</td>\n",
       "      <td>9081</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10003</th>\n",
       "      <td>8404</td>\n",
       "      <td>8404</td>\n",
       "      <td>8404</td>\n",
       "      <td>7764</td>\n",
       "      <td>8403</td>\n",
       "      <td>8403</td>\n",
       "      <td>8404</td>\n",
       "      <td>8404</td>\n",
       "      <td>8404</td>\n",
       "      <td>8404</td>\n",
       "      <td>8404</td>\n",
       "      <td>8404</td>\n",
       "      <td>6520</td>\n",
       "      <td>6520</td>\n",
       "      <td>8404</td>\n",
       "      <td>8404</td>\n",
       "      <td>8404</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11206</th>\n",
       "      <td>7572</td>\n",
       "      <td>7572</td>\n",
       "      <td>7572</td>\n",
       "      <td>6201</td>\n",
       "      <td>7572</td>\n",
       "      <td>7572</td>\n",
       "      <td>7572</td>\n",
       "      <td>7572</td>\n",
       "      <td>7572</td>\n",
       "      <td>7572</td>\n",
       "      <td>7572</td>\n",
       "      <td>7572</td>\n",
       "      <td>5698</td>\n",
       "      <td>5698</td>\n",
       "      <td>7572</td>\n",
       "      <td>7572</td>\n",
       "      <td>7572</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11238</th>\n",
       "      <td>7128</td>\n",
       "      <td>7128</td>\n",
       "      <td>7128</td>\n",
       "      <td>7024</td>\n",
       "      <td>7119</td>\n",
       "      <td>7119</td>\n",
       "      <td>7128</td>\n",
       "      <td>7128</td>\n",
       "      <td>7128</td>\n",
       "      <td>7128</td>\n",
       "      <td>7128</td>\n",
       "      <td>7128</td>\n",
       "      <td>5430</td>\n",
       "      <td>5430</td>\n",
       "      <td>7128</td>\n",
       "      <td>7128</td>\n",
       "      <td>7128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11221</th>\n",
       "      <td>6615</td>\n",
       "      <td>6615</td>\n",
       "      <td>6615</td>\n",
       "      <td>5985</td>\n",
       "      <td>6615</td>\n",
       "      <td>6615</td>\n",
       "      <td>6615</td>\n",
       "      <td>6615</td>\n",
       "      <td>6615</td>\n",
       "      <td>6615</td>\n",
       "      <td>6615</td>\n",
       "      <td>6615</td>\n",
       "      <td>4789</td>\n",
       "      <td>4789</td>\n",
       "      <td>6615</td>\n",
       "      <td>6615</td>\n",
       "      <td>6615</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10011</th>\n",
       "      <td>6488</td>\n",
       "      <td>6488</td>\n",
       "      <td>6488</td>\n",
       "      <td>6429</td>\n",
       "      <td>6487</td>\n",
       "      <td>6487</td>\n",
       "      <td>6488</td>\n",
       "      <td>6488</td>\n",
       "      <td>6488</td>\n",
       "      <td>6488</td>\n",
       "      <td>6488</td>\n",
       "      <td>6488</td>\n",
       "      <td>5017</td>\n",
       "      <td>5017</td>\n",
       "      <td>6488</td>\n",
       "      <td>6488</td>\n",
       "      <td>6488</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11216</th>\n",
       "      <td>6283</td>\n",
       "      <td>6283</td>\n",
       "      <td>6283</td>\n",
       "      <td>5524</td>\n",
       "      <td>6283</td>\n",
       "      <td>6283</td>\n",
       "      <td>6283</td>\n",
       "      <td>6283</td>\n",
       "      <td>6283</td>\n",
       "      <td>6283</td>\n",
       "      <td>6283</td>\n",
       "      <td>6283</td>\n",
       "      <td>4776</td>\n",
       "      <td>4776</td>\n",
       "      <td>6283</td>\n",
       "      <td>6283</td>\n",
       "      <td>6283</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10014</th>\n",
       "      <td>6076</td>\n",
       "      <td>6076</td>\n",
       "      <td>6076</td>\n",
       "      <td>6007</td>\n",
       "      <td>6071</td>\n",
       "      <td>6071</td>\n",
       "      <td>6076</td>\n",
       "      <td>6076</td>\n",
       "      <td>6076</td>\n",
       "      <td>6076</td>\n",
       "      <td>6076</td>\n",
       "      <td>6076</td>\n",
       "      <td>4572</td>\n",
       "      <td>4572</td>\n",
       "      <td>6076</td>\n",
       "      <td>6076</td>\n",
       "      <td>6076</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            id   name  host_id  host_name  neighbourhood_group  neighbourhood  \\\n",
       "zipcode                                                                         \n",
       "11211    12503  12503    12503       9496                12500          12500   \n",
       "10002     9224   9224     9224       9094                 9221           9221   \n",
       "10009     9081   9081     9081       8794                 9080           9080   \n",
       "10003     8404   8404     8404       7764                 8403           8403   \n",
       "11206     7572   7572     7572       6201                 7572           7572   \n",
       "11238     7128   7128     7128       7024                 7119           7119   \n",
       "11221     6615   6615     6615       5985                 6615           6615   \n",
       "10011     6488   6488     6488       6429                 6487           6487   \n",
       "11216     6283   6283     6283       5524                 6283           6283   \n",
       "10014     6076   6076     6076       6007                 6071           6071   \n",
       "\n",
       "         latitude  longitude  room_type  price  minimum_nights  \\\n",
       "zipcode                                                          \n",
       "11211       12503      12503      12503  12503           12503   \n",
       "10002        9224       9224       9224   9224            9224   \n",
       "10009        9081       9081       9081   9081            9081   \n",
       "10003        8404       8404       8404   8404            8404   \n",
       "11206        7572       7572       7572   7572            7572   \n",
       "11238        7128       7128       7128   7128            7128   \n",
       "11221        6615       6615       6615   6615            6615   \n",
       "10011        6488       6488       6488   6488            6488   \n",
       "11216        6283       6283       6283   6283            6283   \n",
       "10014        6076       6076       6076   6076            6076   \n",
       "\n",
       "         number_of_reviews  last_review  reviews_per_month  \\\n",
       "zipcode                                                      \n",
       "11211                12503         9941               9941   \n",
       "10002                 9224         7340               7340   \n",
       "10009                 9081         7046               7046   \n",
       "10003                 8404         6520               6520   \n",
       "11206                 7572         5698               5698   \n",
       "11238                 7128         5430               5430   \n",
       "11221                 6615         4789               4789   \n",
       "10011                 6488         5017               5017   \n",
       "11216                 6283         4776               4776   \n",
       "10014                 6076         4572               4572   \n",
       "\n",
       "         calculated_host_listings_count  availability_365  year_month  \n",
       "zipcode                                                                \n",
       "11211                             12503             12502       12503  \n",
       "10002                              9224              9224        9224  \n",
       "10009                              9081              9081        9081  \n",
       "10003                              8404              8404        8404  \n",
       "11206                              7572              7572        7572  \n",
       "11238                              7128              7128        7128  \n",
       "11221                              6615              6615        6615  \n",
       "10011                              6488              6488        6488  \n",
       "11216                              6283              6283        6283  \n",
       "10014                              6076              6076        6076  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import numpy as np\n",
    "\n",
    "file_input = 'Master Data 2015.csv'\n",
    "listings = pd.read_csv(file_input)\n",
    "listings['zipcode'] = pd.to_numeric(listings['zipcode'])\n",
    "by_zipcode = listings.groupby('zipcode').count()\n",
    "by_zipcode = by_zipcode.sort_values('id', ascending=False)\n",
    "by_zipcode.head(10)"
   ]
  },
  {
   "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>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>150.991682</td>\n",
       "      <td>129.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>10002</td>\n",
       "      <td>182.400477</td>\n",
       "      <td>150.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>10009</td>\n",
       "      <td>177.778549</td>\n",
       "      <td>150.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>10003</td>\n",
       "      <td>220.328891</td>\n",
       "      <td>180.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>11206</td>\n",
       "      <td>102.391970</td>\n",
       "      <td>80.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>11238</td>\n",
       "      <td>144.082211</td>\n",
       "      <td>120.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>11221</td>\n",
       "      <td>95.713076</td>\n",
       "      <td>75.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>10011</td>\n",
       "      <td>242.854346</td>\n",
       "      <td>200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>11216</td>\n",
       "      <td>111.900207</td>\n",
       "      <td>90.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10014</td>\n",
       "      <td>252.500823</td>\n",
       "      <td>210.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>10019</td>\n",
       "      <td>229.525049</td>\n",
       "      <td>189.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>10025</td>\n",
       "      <td>183.937929</td>\n",
       "      <td>145.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>10012</td>\n",
       "      <td>255.219760</td>\n",
       "      <td>200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>11222</td>\n",
       "      <td>140.432536</td>\n",
       "      <td>120.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>11237</td>\n",
       "      <td>91.916442</td>\n",
       "      <td>75.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>10036</td>\n",
       "      <td>218.437125</td>\n",
       "      <td>175.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>10016</td>\n",
       "      <td>237.572914</td>\n",
       "      <td>185.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>11215</td>\n",
       "      <td>162.932613</td>\n",
       "      <td>139.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>11249</td>\n",
       "      <td>176.330328</td>\n",
       "      <td>140.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>10031</td>\n",
       "      <td>104.395633</td>\n",
       "      <td>80.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>10027</td>\n",
       "      <td>128.709048</td>\n",
       "      <td>110.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>11205</td>\n",
       "      <td>165.375414</td>\n",
       "      <td>115.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>10029</td>\n",
       "      <td>126.461440</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>11217</td>\n",
       "      <td>165.974973</td>\n",
       "      <td>140.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>10023</td>\n",
       "      <td>234.262821</td>\n",
       "      <td>190.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>10024</td>\n",
       "      <td>205.716110</td>\n",
       "      <td>175.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>11201</td>\n",
       "      <td>180.651959</td>\n",
       "      <td>155.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>10128</td>\n",
       "      <td>184.365154</td>\n",
       "      <td>150.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>11226</td>\n",
       "      <td>92.680582</td>\n",
       "      <td>75.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>10013</td>\n",
       "      <td>294.459468</td>\n",
       "      <td>185.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Zip Code        Mean  Median\n",
       "0      11211  150.991682   129.0\n",
       "1      10002  182.400477   150.0\n",
       "2      10009  177.778549   150.0\n",
       "3      10003  220.328891   180.0\n",
       "4      11206  102.391970    80.0\n",
       "5      11238  144.082211   120.0\n",
       "6      11221   95.713076    75.0\n",
       "7      10011  242.854346   200.0\n",
       "8      11216  111.900207    90.0\n",
       "9      10014  252.500823   210.0\n",
       "10     10019  229.525049   189.0\n",
       "11     10025  183.937929   145.0\n",
       "12     10012  255.219760   200.0\n",
       "13     11222  140.432536   120.0\n",
       "14     11237   91.916442    75.0\n",
       "15     10036  218.437125   175.0\n",
       "16     10016  237.572914   185.0\n",
       "17     11215  162.932613   139.0\n",
       "18     11249  176.330328   140.0\n",
       "19     10031  104.395633    80.0\n",
       "20     10027  128.709048   110.0\n",
       "21     11205  165.375414   115.0\n",
       "22     10029  126.461440   100.0\n",
       "23     11217  165.974973   140.0\n",
       "24     10023  234.262821   190.0\n",
       "25     10024  205.716110   175.0\n",
       "26     11201  180.651959   155.0\n",
       "27     10128  184.365154   150.0\n",
       "28     11226   92.680582    75.0\n",
       "29     10013  294.459468   185.0"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "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 = listings.loc[listings['zipcode']==zipcode]['price'].median()\n",
    "    mean = listings.loc[listings['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"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Text(0.5,1,'Mean and Median Prices by Zipcode')"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAmcAAAFNCAYAAABFbcjcAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMi4zLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvIxREBQAAIABJREFUeJzt3Xm8XXV97//XmzFMyhS8QMDQiohgZAiQVqEUWxmkglUqaAFFi2PVW/EWqyD3Z3mUep0KbWlRuaJVEIsKFapEf6aOKAlDDKCCeoQIZYiAGogS+Nw/1jphczjnJIGz91nn5PV8PPZj773Gz3ev7H3e+a4pVYUkSZK6Yb3JLkCSJEmPMpxJkiR1iOFMkiSpQwxnkiRJHWI4kyRJ6hDDmSRJUocYziRNiCRDSf5owOtckOS17etXJrlykOsfS5Ibkhw8oHW9Ksk3B7Suf0ly2iDW1bPOjyf520GuU5pshjNpQNrw8tsk244Yfl2SSjJ7cirrv/YPbCV58YjhH26Hv+rJrqOqPlVVL3yyyxlNW+PyJL9O8vMkH0yy/ji17FFVC/pRS78kObBt38jHI0nOB6iq11fVeye7Vmm6M5xJg/VT4LjhN0meA2wyeeUM1I+AE4ffJNkAOAb48aRVtHaeW1WbAy8AXgH8xcgJ2jZNSVX1jaravPcB/Cnwa+CDk1yetE4xnEmD9UnghJ73JwKf6J0gycZJ3p/k1iR3truSNmnHbZXki0nuTnJv+3pWz7wLkrw3ybeS/CrJlSN76nqmfVLLSnJ8kp8lWZbkXWvQ9v8Anpdkq/b9YcBi4L9H1HVSkpvamr6c5Ok94/44yQ+S3J/kH4H0jHvM7r0k/5DktiS/TLIoyYE9485IcnGST7RtuyHJ3DVoA1X1A+AbwJ7tsoaS/HWSxcDyJBv07uJNsn6Sv0ny43Zdi5Ls1I57VpL5SX6R5IdJ/qynxiOS3NjO8/Mkp4xTVpKc034uP0jygnbgMUkWjZjw7Um+sLp2tjV+CnhjVS1ph63axZjk4CRL27bd07b5lT3zb5LkA+2/kfuTfLPn3/GL28/8vvbf2e498+2d5Jq23Z8BZoyo68g0vc33Jfl2kjmra4s01RjOpMG6CnhKkt3T7BZ7OfBvI6b5e+CZwF7AM4AdgdPbcesB/xd4OrAz8CDwjyPmfwXwamA7YCNgrD/qT3hZSZ4NnAscD+wAbAPMYnwrgMuAY9v3J/D4YHo08Dc0PTYzaULQhe24bYFLgHcD29L0uD1vnPVdTfMZbg18Gvhskt4/9C8GLgK2bOsa2fZRtW0/ELi2Z/BxwIuALatq5YhZ/qodfwTwFOAk4IEkmwHz29q2a6f55yR7tPN9DHhdVW1BEwT//3HKOgD4Cc3n8h7gc0m2btu1S2/4Af6c5j8J47VxQ+Bi4N+rauS/z17/o13njjT/0TgvyW7tuPcD+wK/T7MN/hfwSJJn0mzTt9Fs4yuA/0iyUZKNgC+09W0NfBZ4aU9d+wDnA6+j+Tf3r8BlSTYerz3SlFNVPnz4GMADGAL+iCZc/B1Nz9F8YAOggNk0PUHLgd/tme/3gJ+Oscy9gHt73i8A3t3z/o3Al9awvjVeFk1YvKhn3GbAb4E/GmPZHwf+Fng+8B3gqcCdNLt0vwm8qp3uP4HX9My3HvAATYA8AbiqZ1yApcBr2/evAr45Tvvupdk1CXAG8JWecc8GHhxn3gJ+2S7jx21b1uvZrieNtq3b1z8EjhplmS8HvjFi2L8C72lf30oTQp6ymu32KuB2ID3Dvgcc374+Fzizfb1H24aNV7PMc2jC7cYjhn8c+Nv29cHASmCznvEXA6e12+3B4c97xDJOAy4esY1/3i7voFHa8u2edZ4LvHfE8n4I/EE/v7s+fAz6MWWPj5CmsE8CXwd2YUTPEU1PwqbAouTRPXbA+gBJNgU+RBPshncPbpFk/ap6uH3fu5vwAWDz0Yp4ksvaAbhteERVLU+ybJw2D0/3zSQzaQLqF6vqwZ52QhPC/iHJB3pLpemZGbnOSnIbY0jyduC17XxF02vVu4t3ZNtmJNmgHt/zNWyfqrpljHFj1gHsxOjH1T0dOCDJfT3DNuDRXq2X0nxOZ7W7TE+tqu+MsY6fV1X1vP8ZTbsBLgAuTPJump7Oi6vqN2MVm+RYmh7TfcabrnVvVS0fZb3b0uyOHK3dO7TTAVBVj7TbcUfg4THaMuzpwIlJ/rJn2EY82lZpWnC3pjRgVfUzmhMDjgA+N2L0PTQ9DntU1Zbt46nVHJwN8HZgN+CAqnoKTU8D9Bx7tRaezLLuoAkdzQxN0NtmDdf7b+26RwZTaELO63ravmVVbVJV3x5lnel936s9vuyvgT8DtqqqLYH7eWKf05qoccbdBvzuGMP/a0RbN6+qNwBU1dVVdRTNLs8v0PRKjWXHPDbl7kzTA0VVXUXTq3kgTegac5dmu/vzPJpet5+NNV2PrdrdsyPXew/NbuzR2n07TcgaXufwdvw5zTYerS3DbqPpBez9zDatqgvXoFZpyjCcSZPjNcAhI3odqKpHgI8AH0qyHUCSHZMc2k6yBU14u689pug9T6KGJ7OsfweOTPL89jih/481/z05G/hjmt7Dkf4FeOfwcVdJnprkmHbc5cAeSf40zVmRb6E55mk0W9Dscrsb2CDJ6TQ9Z5Pho8B7k+yaxpwk2wBfBJ6Z5sSKDdvHfu3xiBuluW7bU6vqIZpdqg+Ps47tgLe0yzgG2J3mWK5hn6A5pm5lVY16TbQ2ZF0C/ENVXTHaNGP43229BwJHAp9t/x2fD3wwyQ5pTor4vfbYsIuBFyV5QXts29uB39DsvvwOzXZ7S5oTK/4U2L9nXR8BXp/kgPaz3CzJi5JssRb1Sp1nOJMmQVX9uKoWjjH6r4FbgKuS/BL4Ck0PF8CHaY7Tuofm5IIvPYkynvCyquoG4E00B7PfQXMc09I1nPcXVfXVEbuuhsd9nuaEiIvati8BDm/H3UNz6Y2zgGXArsC3xljNl2mOX/sRzW6xFYy/67GfPkgTSK6kCVkfAzapql8BL6Q5QeJ2mt2sfw8MH9x+PDDUfg6vpzmQfyzfpfk87gHOBF5WVb27mT9Jc1LBeCcCvJQm1P1VHn+ts/8cY57/ptn2t9Oc2fn6as5mhebkke/THLv2i7Zt61XVD9u2nNPW+yfAn1TVb6vqtzQng7yqXe7L6eldbr8zf0ETNO+l+Z68apw2SVNSRvl9lCRNI+0lLO6iOY7s5gla5sHAv1XV6s7SlbSW7DmTpOnvDcDVExXMJPWXZ2tK0jSWZIjmRIijJ7kUSWvI3ZqSJEkd4m5NSZKkDjGcSZIkdciUPuZs2223rdmzZ092GZIkSau1aNGie6pq5uqmm9LhbPbs2SxcONaloiRJkrojyZrcecPdmpIkSV1iOJMkSeoQw5kkSVKHTOljzkbz0EMPsXTpUlasWDHZpXTSjBkzmDVrFhtuuOFklyJJkkYx7cLZ0qVL2WKLLZg9ezZJJrucTqkqli1bxtKlS9lll10muxxJkjSKabdbc8WKFWyzzTYGs1EkYZtttrFXUZKkDpt24QwwmI3Dz0aSpG6bluFssiXh+OOPX/V+5cqVzJw5kyOPPHISq5IkSVPBtDvmbKTZp14+ocsbOutFq51ms802Y8mSJTz44INssskmzJ8/nx133HFC65AkSdOTPWd9cvjhh3P55U0wvPDCCznuuONWjVu+fDknnXQS++23H3vvvTeXXnopAENDQxx44IHss88+7LPPPnz7298GYMGCBRx88MG87GUv41nPehavfOUrqarBN0qSJPVd38JZkp2SfC3JTUluSPLWdvgZSX6e5Lr2cUTPPO9MckuSHyY5tF+1DcKxxx7LRRddxIoVK1i8eDEHHHDAqnFnnnkmhxxyCFdffTVf+9rXeMc73sHy5cvZbrvtmD9/Ptdccw2f+cxneMtb3rJqnmuvvZYPf/jD3HjjjfzkJz/hW9/61mQ0S5Ik9Vk/d2uuBN5eVdck2QJYlGR+O+5DVfX+3omTPBs4FtgD2AH4SpJnVtXDfayxb+bMmcPQ0BAXXnghRxxxxGPGXXnllVx22WW8//3NR7BixQpuvfVWdthhB9785jdz3XXXsf766/OjH/1o1Tz7778/s2bNAmCvvfZiaGiI5z//+YNrkCRJAzbRhyaNZ00OWxqUvoWzqroDuKN9/askNwHjHXh1FHBRVf0G+GmSW4D9ge/0q8Z+e/GLX8wpp5zCggULWLZs2arhVcUll1zCbrvt9pjpzzjjDJ72tKdx/fXX88gjjzBjxoxV4zbeeONVr9dff31WrlzZ/wZIkqSBG8gxZ0lmA3sD320HvTnJ4iTnJ9mqHbYjcFvPbEsZP8x13kknncTpp5/Oc57znMcMP/TQQznnnHNWHTd27bXXAnD//fez/fbbs9566/HJT36Shx+ekp2GkiTpSeh7OEuyOXAJ8Laq+iVwLvC7wF40PWsfGJ50lNkfd9R7kpOTLEyy8O677+5T1RNj1qxZvPWtb33c8NNOO42HHnqIOXPmsOeee3LaaacB8MY3vpELLriAefPm8aMf/YjNNtts0CVLkqRJln6e9ZdkQ+CLwJer6oOjjJ8NfLGq9kzyToCq+rt23JeBM6pqzN2ac+fOrYULFz5m2E033cTuu+8+YW2YjvyMJElTwXQ75izJoqqau7rp+nm2ZoCPATf1BrMk2/dM9hJgSfv6MuDYJBsn2QXYFfhev+qTJEnqon6erfk84Hjg+0mua4f9DXBckr1odlkOAa8DqKobklwM3EhzpuebpuqZmpIkSU9UP8/W/CajH0d2xTjznAmc2a+aJEmSus47BEiSJHWI4UySJKlDpv2NzyVJ6jXdzgDU9GPPWR8k4fjjj1/1fuXKlcycOZMjjzxyrZZz8MEHM3ypkCOOOIL77rtvQuuUJEndM/17zs546gQv7/7VTrLZZpuxZMkSHnzwQTbZZBPmz5/Pjjs+uZsdXHHFmOdRSJKkacSesz45/PDDufzypuv8wgsv5Ljjjls1bvny5Zx00knst99+7L333lx66aUAPPjggxx77LHMmTOHl7/85Tz44IOr5pk9ezb33HMPAEcffTT77rsve+yxB+edd96qaTbffHPe9a538dznPpd58+Zx5513DqKpkiRpAhnO+uTYY4/loosuYsWKFSxevJgDDjhg1bgzzzyTQw45hKuvvpqvfe1rvOMd72D58uWce+65bLrppixevJh3vetdLFq0aNRln3/++SxatIiFCxdy9tlnr7qp+vLly5k3bx7XX389Bx10EB/5yEcG0lZJkjRxDGd9MmfOHIaGhrjwwgs54ogjHjPuyiuv5KyzzmKvvfbi4IMPZsWKFdx66618/etf58///M9XzT9nzpxRl3322Wev6h277bbbuPnmmwHYaKONVh3Xtu+++zI0NNS/BkqSpL6Y/secTaIXv/jFnHLKKSxYsGBV7xZAVXHJJZew2267PW6e5q5XY1uwYAFf+cpX+M53vsOmm266KtwBbLjhhqvmX3/99Vm5cuUEtkaSJA2CPWd9dNJJJ3H66afznOc85zHDDz30UM455xyGbzp/7bXXAnDQQQfxqU99CoAlS5awePHixy3z/vvvZ6uttmLTTTflBz/4AVdddVWfWyFJkgbJcNZHs2bN4q1vfevjhp922mk89NBDzJkzhz333JPTTjsNgDe84Q38+te/Zs6cObzvfe9j//33f9y8hx12GCtXrmTOnDmcdtppzJs3r+/tkCRJg5Ph3pupaO7cuTV8HbBhN910E7vvvvskVTQ1+BlJWpd5EdqpY7ptqySLqmru6qaz50ySJKlDDGeSJEkdYjiTJEnqkGkZzqbycXT95mcjSVK3TbtwNmPGDJYtW2YIGUVVsWzZMmbMmDHZpUiSpDFMu4vQzpo1i6VLl3L33XdPdimdNGPGDGbNmjXZZUiSpDFMu3C24YYbsssuu0x2GZIkSU/ItNutKUmSNJUZziRJkjrEcCZJktQhhjNJkqQOMZxJkiR1iOFMkiSpQ6bdpTSk6Wb2qZcPZD1DZ71oIOuRJI3PnjNJkqQOMZxJkiR1iOFMkiSpQwxnkiRJHWI4kyRJ6hDDmSRJUocYziRJkjrEcCZJktQhhjNJkqQOMZxJkiR1iLdvkiRJnTQ04xUDXNv9A1zX+Ow5kyRJ6hDDmSRJUocYziRJkjrEcCZJktQhhjNJkqQO6Vs4S7JTkq8luSnJDUne2g7fOsn8JDe3z1u1w5Pk7CS3JFmcZJ9+1SZJktRV/ew5Wwm8vap2B+YBb0rybOBU4KtVtSvw1fY9wOHAru3jZODcPtYmSZLUSX0LZ1V1R1Vd077+FXATsCNwFHBBO9kFwNHt66OAT1TjKmDLJNv3qz5JkqQuGsgxZ0lmA3sD3wWeVlV3QBPggO3ayXYEbuuZbWk7TJIkaZ3R9zsEJNkcuAR4W1X9MsmYk44yrEZZ3sk0uz3ZeeedJ6pMSdI6Yl296rymjr72nCXZkCaYfaqqPtcOvnN4d2X7fFc7fCmwU8/ss4DbRy6zqs6rqrlVNXfmzJn9K16SJGkS9PNszQAfA26qqg/2jLoMOLF9fSJwac/wE9qzNucB9w/v/pQkSVpX9HO35vOA44HvJ7muHfY3wFnAxUleA9wKHNOOuwI4ArgFeAB4dR9rkyRJ6qS+hbOq+iajH0cG8IJRpi/gTf2qR5IkaSrwDgGSJEkdYjiTJEnqEMOZJElShxjOJEmSOsRwJkmS1CGGM0mSpA4xnEmSJHWI4UySJKlDDGeSJEkdYjiTJEnqEMOZJElShxjOJEmSOsRwJkmS1CEbTHYBmhyzT718YOsaOutFA1uXJElTnT1nkiRJHWLPmdRxQzNeMaA13T+g9UiSxmPPmSRJUocYziRJkjrE3ZqaNjzJQZI0HdhzJkmS1CGGM0mSpA4xnEmSJHWI4UySJKlDDGeSJEkdYjiTJEnqEMOZJElShxjOJEmSOsRwJkmS1CGGM0mSpA4xnEmSJHWI4UySJKlDDGeSJEkdYjiTJEnqEMOZJElShxjOJEmSOsRwJkmS1CGGM0mSpA4xnEmSJHWI4UySJKlDDGeSJEkdYjiTJEnqEMOZJElSh/QtnCU5P8ldSZb0DDsjyc+TXNc+jugZ984ktyT5YZJD+1WXJElSl/Wz5+zjwGGjDP9QVe3VPq4ASPJs4Fhgj3aef06yfh9rkyRJ6qS+hbOq+jrwizWc/Cjgoqr6TVX9FLgF2L9ftUmSJHXVBpOwzjcnOQFYCLy9qu4FdgSu6plmaTusE2afevlA1jN01osGsh5JktRdgw5n5wLvBap9/gBwEpBRpq3RFpDkZOBkgJ133rk/Va4Dhma8YoBru38ga5mObZIkrXsGerZmVd1ZVQ9X1SPAR3h01+VSYKeeSWcBt4+xjPOqam5VzZ05c2Z/C5YkSRqwgYazJNv3vH0JMHwm52XAsUk2TrILsCvwvUHWJkmS1AV9262Z5ELgYGDbJEuB9wAHJ9mLZpflEPA6gKq6IcnFwI3ASuBNVfVwv2qTJEnqqr6Fs6o6bpTBHxtn+jOBM/tVjyRJ0lTgHQIkSZI6ZDIupSFJ05KX3ZE0Edaq5yzJZv0qRJIkSWsYzpL8fpIbgZva989N8s99rUySJGkdtKY9Zx8CDgWWAVTV9cBB/SpKkiRpXbXGuzWr6rYRg7zUhSRJ0gRb0xMCbkvy+0Al2Qh4C+0uTkmSJE2cNe05ez3wJpqbkS8F9mrfS5IkaQKtUc9ZVd0DvLLPtUiSJK3z1vRszQuSbNnzfqsk5/evLEmSpHXTmu7WnFNV9w2/qap7gb37U5IkSdK6a03D2XpJthp+k2RrvLuAJEnShFvTgPUB4NtJ/r19fwzepFySJGnCrekJAZ9IshA4BAjwp1V1Y18rkyRJWgeNG86SPKWqftnuxvxv4NM947auql/0u0BJkqR1yep6zj4NHAksAqpneNr3v9OnuiRJktZJ44azqjoySYA/qKpbB1STJEnSOmu1x5xVVSX5PLDvAOrppKEZrxjQmu4f0HokSVJXremlNK5Ksl9fK5EkSdIaX0rjD4HXJxkCltMec1ZVc/pVmCRJ0rpoTcPZ4X2tQpIkScDqL6UxA3g98Azg+8DHqmrlIAqTJElaF63umLMLgLk0wexwmjsFSJIkqU9Wt1vz2VX1HIAkHwO+1/+SJEmS1l2r6zl7aPiFuzMlSZL6b3U9Z89N8sv2dYBN2vfDZ2s+pa/VSZIkrWNWd4eA9QdViCRNdV6wWtJEWNOL0EqSJGkADGeSJEkdYjiTJEnqEMOZJElShxjOJEmSOsRwJkmS1CGGM0mSpA5Z3UVoJUnSFDD71MsHsp6hs140kPWsy+w5kyRJ6hDDmSRJUocYziRJkjrEcCZJktQhhjNJkqQOMZxJkiR1iOFMkiSpQ/oWzpKcn+SuJEt6hm2dZH6Sm9vnrdrhSXJ2kluSLE6yT7/qkiRJ6rJ+9px9HDhsxLBTga9W1a7AV9v3AIcDu7aPk4Fz+1iXJElSZ/XtDgFV9fUks0cMPgo4uH19AbAA+Ot2+CeqqoCrkmyZZPuquqNf9UmaPIO6kjl4NXNJU8+gjzl72nDgap+3a4fvCNzWM93SdpgkSdI6pSsnBGSUYTXqhMnJSRYmWXj33Xf3uSxJkqTBGnQ4uzPJ9gDt813t8KXATj3TzQJuH20BVXVeVc2tqrkzZ87sa7GSJEmDNuhwdhlwYvv6RODSnuEntGdtzgPu93gzSZK0LurbCQFJLqQ5+H/bJEuB9wBnARcneQ1wK3BMO/kVwBHALcADwKv7VZckSVKX9fNszePGGPWCUaYt4E39qkWSJGmq6Fs4kyRNfV72RBq8rpytKUmSJAxnkiRJnWI4kyRJ6hDDmSRJUocYziRJkjrEszUlSZoGhma8YkBrun9A61l32XMmSZLUIYYzSZKkDjGcSZIkdYjhTJIkqUMMZ5IkSR1iOJMkSeoQw5kkSVKHGM4kSZI6xHAmSZLUId4hQNLADe5K5uDVzCVNNfacSZIkdYjhTJIkqUMMZ5IkSR1iOJMkSeoQTwiQJI3JkzekwbPnTJIkqUMMZ5IkSR1iOJMkSeoQw5kkSVKHGM4kSZI6xHAmSZLUIYYzSZKkDjGcSZIkdYjhTJIkqUMMZ5IkSR1iOJMkSeoQw5kkSVKHGM4kSZI6xHAmSZLUIYYzSZKkDjGcSZIkdYjhTJIkqUMMZ5IkSR1iOJMkSeoQw5kkSVKHGM4kSZI6ZIPJWGmSIeBXwMPAyqqam2Rr4DPAbGAI+LOquncy6pMkSZosk9lz9odVtVdVzW3fnwp8tap2Bb7avpckSVqndGm35lHABe3rC4CjJ7EWSZKkSTFZ4ayAK5MsSnJyO+xpVXUHQPu83STVJkmSNGkm5Zgz4HlVdXuS7YD5SX6wpjO2Ye5kgJ133rlf9UmSJE2KSek5q6rb2+e7gM8D+wN3JtkeoH2+a4x5z6uquVU1d+bMmYMqWZIkaSAGHs6SbJZki+HXwAuBJcBlwIntZCcClw66NkmSpMk2Gbs1nwZ8Psnw+j9dVV9KcjVwcZLXALcCx0xCbZIkSZNq4OGsqn4CPHeU4cuAFwy6HkmSpC7p0qU0JEmS1nmGM0mSpA4xnEmSJHWI4UySJKlDDGeSJEkdYjiTJEnqEMOZJElShxjOJEmSOsRwJkmS1CGGM0mSpA4xnEmSJHWI4UySJKlDDGeSJEkdYjiTJEnqEMOZJElShxjOJEmSOsRwJkmS1CGGM0mSpA4xnEmSJHWI4UySJKlDDGeSJEkdYjiTJEnqEMOZJElShxjOJEmSOsRwJkmS1CGGM0mSpA4xnEmSJHWI4UySJKlDDGeSJEkdYjiTJEnqEMOZJElShxjOJEmSOsRwJkmS1CGGM0mSpA4xnEmSJHWI4UySJKlDDGeSJEkdYjiTJEnqEMOZJElShxjOJEmSOsRwJkmS1CGGM0mSpA7pXDhLcliSHya5Jcmpk12PJEnSIHUqnCVZH/gn4HDg2cBxSZ49uVVJkiQNTqfCGbA/cEtV/aSqfgtcBBw1yTVJkiQNTNfC2Y7AbT3vl7bDJEmS1gmpqsmuYZUkxwCHVtVr2/fHA/tX1V/2THMycHL7djfghwMvdM1sC9wz2UVMsOnYJpie7ZqObYLp2S7bNHVMx3bZpsF6elXNXN1EGwyikrWwFNip5/0s4PbeCarqPOC8QRb1RCRZWFVzJ7uOiTQd2wTTs13TsU0wPdtlm6aO6dgu29RNXduteTWwa5JdkmwEHAtcNsk1SZIkDUynes6qamWSNwNfBtYHzq+qGya5LEmSpIHpVDgDqKorgCsmu44J0Pldr0/AdGwTTM92Tcc2wfRsl22aOqZju2xTB3XqhABJkqR1XdeOOZMkSVqnGc7GkeT8JHclWdIz7JgkNyR5JMncnuF/nGRRku+3z4f0jDszyW1Jfj1i+QcluSbJyiQvG0yrxmzX1knmJ7m5fd6qHZ4kZ7e301qcZJ+eeU5sp785yYntsE2TXJ7kB+3ndNZUb1M7/OXttDcked8g2jSgdn0pyfVtu/6lvUvHZLTpiXyv9m2H39K2Oz3j/jLNbeAGsr0msE2jbo8keyW5Ksl1SRYm2X8qtGm834NM/d+/LyW5L8kXRyz/ze30lWTbSWzThP2tasf9WZIb22V+uv+t6v+26hl/zmhtnlRV5WOMB3AQsA+wpGfY7jTXV1sAzO0ZvjewQ/t6T+DnPePmAdsDvx6x/NnAHOATwMsmuV3vA05tX58K/H37+gjgP4G07fhuO3xr4Cft81bt662ATYE/bKfZCPgGcPgUb9M2wK3AzHa6C4AXTPVt1Y57Svsc4BLg2Cn0vfoe8Htt7f85/O8M+EPgK8DG7fvtplCbRt0ewJU97TsCWDAV2sQ4vwdM4d+/dtwLgD8Bvjhi+Xu3bRsCtp3ENk3k36pdgWt59Hej79+pQWyrdtxc4JMj2zzZD3vOxlFVXwd+MWLYTVX1uAvfVtW1VTV8TbYbgBlJNm7HXVVVd4wyz1BVLQYemfjqxzZau2huk3VB+/oC4Oie4Z+oxlXAlkm2Bw4F5lfVL6rqXmA+cFhVPVBVX2vX81uu36/jAAAGx0lEQVTgGprr1fVVP9sE/A7wo6q6u53/K8BL+9eaR/W5XVTVL9t5N6D549n3g1An4nvVtuspVfWdan5hP8Gjn8MbgLOq6jftMu7qV1t66pyo34qxtkcBT2lfP5UR13/sh4lo03i/B1P894+q+irwq1GWf21VDfWj9rH0+28V8BfAP7W/HwP5TrXr6eu2anum/w/wv/pQ/pNiOOuPlwLXDv9xmCKeNvylbJ+3a4ePdUut1d5qK8mWNP9b+Wqfal6diWrTLcCzksxOsgHNj0HvxZIHbUK3VZIvA3fR/Hj9e//KftJ6v1c70rRjWG+bngkcmOS7Sf4ryX4DrnNtPO63Yozt8Tbg/yS5DXg/8M5BF7oWRv3968DvwXjW9js1Xazp36pnAs9M8q129/phA6htLBO5rd4MXDZGIJ1UhrMJlmQP4O+B1012LRMkowyrcYY3MzUh5kLg7Kr6SZ9qe6LWqk3t/xbfAHyGZrfMELCyb9U9cU9oW1XVoTS7MjYGDhll2kk3yvdqvDZtQLP7dh7wDuDiJKNNP6nG+q0YY3u8AfifVbUT8D+Bjw2w1DU2Vps6/nswnnG/O1PZWv6t2oBm1+bBwHHAR9uw3SVrta2S7AAcA5zTt4qeBMPZBEoyC/g8cEJV/Xiy61lLdw53AbfPw93WY91Sa3W32joPuLmqPty3ildvwtpUVf9RVQdU1e/R3M/15j7XPp6J3lZU1Qqau3Ec1aean7AxvldLeezu8t42LQU+1+7e+B7NbrOBHJi9plb3WzHK9jgR+Fz7+rNA308IWFuraVMXfg/Gs7bfqSntCfytWgpcWlUPVdVPaX4Dd+1njeOYqG21N/AM4JYkQ8CmSW6Z+HKfGMPZBGn/F3E58M6q+tZk1/MEXEbzB4D2+dKe4Se0Z8LMA+5vu4C/DLwwyVbt2TIvbIeR5G9pjot52yAbMIqJbNN27fNWwBuBjw6uGY8zIe1KsnnPj9wGNAfU/mCQDVmdsb5Xbbt+lWRe2yt2Ao9+Dl+g7XFK8kyaY7c6cxPksdq0mu1xO/AH7etDmNz/HDzOeL9/Hfo9GM/afqemrCf4t+oLNCfakOYM1GfSnFg0GSZkW1XV5VX1P6pqdlXNBh6oqmf0s/C1Uh04K6GrD5pu+DuAh2hS+WuAl7SvfwPcCXy5nfbdwHLgup7HdvXo2SVLaf4HvxQ4ox2+X/t+ObAMuGES27UNzbEgN7fPW7fTBvgn4MfA93nsWT8n0RyPdQvw6nbYLJqu5Jt6PofXTuU29Sz/xvbR9zMaB7StnkZzP9vFNAcGnwNsMIW+V3OBJW17/5FHL6q9EfBv7bhrgEOmQpvG2x7A84FFwPXAd4F9p0ibxvw9YOr//n0DuBt4sF3Ooe3wt7TvV9KE6o9OhW3Vjhvrb1WAD9L8/n2fAf0G9ntbjVhXp87W9A4BkiRJHeJuTUmSpA4xnEmSJHWI4UySJKlDDGeSJEkdYjiTJEnqEMOZpCkryUuSXDfi8UiSw5PskGStbkfVXmvsX5P8OMkNSb6e5IC1mP+MJKesfUsk6VEbTHYBkvREVdXnaa50DkCSk4FX0lzT6RHgZWu5yI8CPwV2rapHkvwOsPtE1StJa8KeM0nTQns3gNOB49tgNTvJknbcq5JcmuRLSX6Y5D2jzP+7wAHAu9tgR1X9pKoub8f/VZIl7eNtPfO9q13mV4DdepfXrm9Rkm8keVZfPwBJ04Y9Z5KmvCQbAp8GTqmqW8eYbH9gT+AB4Ookl1fVwp7xewDXVdXDoyx/X+DVNOEtwHeT/BfNf3CPpblP3wY0dyRY1M52HvD6qrq53TX6z3T0xvKSusVwJmk6eC/N7X8uGmea+VW1DCDJ52huibRwnOl7PR/4fFUt75n/QJpw9vmqeqAdfln7vDnw+8Bnm1t/ArDxWrVI0jrLcCZpSktyMPBSYJ/VTDryXnUj398APDfJesO7NXtXsxbLhSa03VdVe62mJkl6HI85kzRlJdkK+L/ACVX1q9VM/sdJtk6yCXA08K3ekVX1Y5qetP+dtrsrya5JjgK+DhydZNMkm9HcVPob7fCXJNkkyRbAn7TL+iXw0yTHtMtJkudOULMlTXP2nEmayl4PbAec27P7EODvgO+OmPabwCeBZwCfHnG82bDXAh8AbknyALAMeEdVXZPk48D32uk+WlXXAiT5DHAd8DOawDbslW1d7wY2BC4Crn+C7ZS0DknVaD3ykjR9JHkVMLeq3jzZtUjS6rhbU5IkqUPsOZMkSeoQe84kSZI6xHAmSZLUIYYzSZKkDjGcSZIkdYjhTJIkqUMMZ5IkSR3y/wAFdoVmK8sZ9QAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 720x360 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Plot Mean and Median\n",
    "plt.figure(figsize = (10,5))\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": 37,
   "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>44</th>\n",
       "      <td>1692262</td>\n",
       "      <td>Open Design Williamsburg Loft</td>\n",
       "      <td>8939428</td>\n",
       "      <td>Margo &amp; Dave</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.710927</td>\n",
       "      <td>-73.969512</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>269</td>\n",
       "      <td>2</td>\n",
       "      <td>58</td>\n",
       "      <td>4/6/2015</td>\n",
       "      <td>3.20</td>\n",
       "      <td>1</td>\n",
       "      <td>262.0</td>\n",
       "      <td>201505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>2454713</td>\n",
       "      <td>Sunny, Spacious 1BR apt- City views</td>\n",
       "      <td>9166868</td>\n",
       "      <td>Tom And Anna</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.713027</td>\n",
       "      <td>-73.968905</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>210</td>\n",
       "      <td>2</td>\n",
       "      <td>18</td>\n",
       "      <td>4/28/2015</td>\n",
       "      <td>1.40</td>\n",
       "      <td>1</td>\n",
       "      <td>102.0</td>\n",
       "      <td>201505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>2756733</td>\n",
       "      <td>BEAUTIFUL PRIVATE ROOM IN BROOKLYN</td>\n",
       "      <td>1711182</td>\n",
       "      <td>Allon</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Williamsburg</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.712475</td>\n",
       "      <td>-73.945975</td>\n",
       "      <td>Private room</td>\n",
       "      <td>70</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>7/4/2014</td>\n",
       "      <td>0.60</td>\n",
       "      <td>1</td>\n",
       "      <td>118.0</td>\n",
       "      <td>201505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>4623894</td>\n",
       "      <td>Huge Room in S. Williamsburg</td>\n",
       "      <td>23948611</td>\n",
       "      <td>Hannah</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Williamsburg</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.709796</td>\n",
       "      <td>-73.954458</td>\n",
       "      <td>Private room</td>\n",
       "      <td>80</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>151.0</td>\n",
       "      <td>201505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>3767695</td>\n",
       "      <td>Huge S. Williamsburg Apt</td>\n",
       "      <td>19303055</td>\n",
       "      <td>Greg</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Williamsburg</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.709601</td>\n",
       "      <td>-73.953077</td>\n",
       "      <td>Private room</td>\n",
       "      <td>200</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>10/5/2014</td>\n",
       "      <td>0.10</td>\n",
       "      <td>1</td>\n",
       "      <td>365.0</td>\n",
       "      <td>201505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213</th>\n",
       "      <td>3993141</td>\n",
       "      <td>Great Room in Cozy Williamsburg Apt</td>\n",
       "      <td>20699508</td>\n",
       "      <td>Brent</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Williamsburg</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.709200</td>\n",
       "      <td>-73.955836</td>\n",
       "      <td>Private room</td>\n",
       "      <td>40</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>117.0</td>\n",
       "      <td>201505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>290</th>\n",
       "      <td>1925224</td>\n",
       "      <td>Beautiful, large, charming spot</td>\n",
       "      <td>9946315</td>\n",
       "      <td>Susan</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Williamsburg</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.717577</td>\n",
       "      <td>-73.954302</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>190</td>\n",
       "      <td>6</td>\n",
       "      <td>11</td>\n",
       "      <td>1/12/2015</td>\n",
       "      <td>0.60</td>\n",
       "      <td>1</td>\n",
       "      <td>119.0</td>\n",
       "      <td>201505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300</th>\n",
       "      <td>4668531</td>\n",
       "      <td>Amazing 1BR with private terrace</td>\n",
       "      <td>756577</td>\n",
       "      <td>Jason</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Williamsburg</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.717988</td>\n",
       "      <td>-73.951638</td>\n",
       "      <td>Entire home/apt</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>132.0</td>\n",
       "      <td>201505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>328</th>\n",
       "      <td>2537745</td>\n",
       "      <td>Sweet Lil Williamsburg One Bedroom</td>\n",
       "      <td>4106281</td>\n",
       "      <td>Ginnie</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Williamsburg</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.711894</td>\n",
       "      <td>-73.954685</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>126</td>\n",
       "      <td>1</td>\n",
       "      <td>59</td>\n",
       "      <td>4/28/2015</td>\n",
       "      <td>4.40</td>\n",
       "      <td>1</td>\n",
       "      <td>324.0</td>\n",
       "      <td>201505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>363</th>\n",
       "      <td>5038425</td>\n",
       "      <td>Sunny room in Williamsburg</td>\n",
       "      <td>2163758</td>\n",
       "      <td>Leslie</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Williamsburg</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.715368</td>\n",
       "      <td>-73.937843</td>\n",
       "      <td>Private room</td>\n",
       "      <td>60</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>4/9/2015</td>\n",
       "      <td>3.40</td>\n",
       "      <td>1</td>\n",
       "      <td>303.0</td>\n",
       "      <td>201505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>366</th>\n",
       "      <td>3223379</td>\n",
       "      <td>Modern 1 Bdr in Williamsburg</td>\n",
       "      <td>1299702</td>\n",
       "      <td>Laura</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Williamsburg</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.708266</td>\n",
       "      <td>-73.952366</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>175</td>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>1/1/2015</td>\n",
       "      <td>1.30</td>\n",
       "      <td>1</td>\n",
       "      <td>118.0</td>\n",
       "      <td>201505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>434</th>\n",
       "      <td>626171</td>\n",
       "      <td>Williamsburg Waterfront</td>\n",
       "      <td>3107764</td>\n",
       "      <td>Godric</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Williamsburg</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.719700</td>\n",
       "      <td>-73.962628</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>195</td>\n",
       "      <td>3</td>\n",
       "      <td>30</td>\n",
       "      <td>12/8/2013</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1</td>\n",
       "      <td>120.0</td>\n",
       "      <td>201505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>436</th>\n",
       "      <td>571471</td>\n",
       "      <td>Sunny Southside Williamsburg!</td>\n",
       "      <td>2812516</td>\n",
       "      <td>Freda</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Williamsburg</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.710078</td>\n",
       "      <td>-73.955845</td>\n",
       "      <td>Private room</td>\n",
       "      <td>65</td>\n",
       "      <td>2</td>\n",
       "      <td>18</td>\n",
       "      <td>3/21/2015</td>\n",
       "      <td>0.50</td>\n",
       "      <td>1</td>\n",
       "      <td>218.0</td>\n",
       "      <td>201505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>484</th>\n",
       "      <td>5480038</td>\n",
       "      <td>Large Private Room in Williamsburg!</td>\n",
       "      <td>27590887</td>\n",
       "      <td>Matthew</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Williamsburg</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.712033</td>\n",
       "      <td>-73.941860</td>\n",
       "      <td>Private room</td>\n",
       "      <td>90</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>365.0</td>\n",
       "      <td>201505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>504</th>\n",
       "      <td>413504</td>\n",
       "      <td>Perfect NYC/Williamsburg Location</td>\n",
       "      <td>1286417</td>\n",
       "      <td>Omri</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Williamsburg</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.713480</td>\n",
       "      <td>-73.944471</td>\n",
       "      <td>Private room</td>\n",
       "      <td>109</td>\n",
       "      <td>3</td>\n",
       "      <td>58</td>\n",
       "      <td>5/1/2015</td>\n",
       "      <td>1.60</td>\n",
       "      <td>1</td>\n",
       "      <td>332.0</td>\n",
       "      <td>201505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>505</th>\n",
       "      <td>324000</td>\n",
       "      <td>Sunny WILLIAMSBURG. Home Sweet Home</td>\n",
       "      <td>1586138</td>\n",
       "      <td>Javier</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Williamsburg</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.711682</td>\n",
       "      <td>-73.962394</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>200</td>\n",
       "      <td>3</td>\n",
       "      <td>86</td>\n",
       "      <td>4/16/2015</td>\n",
       "      <td>2.30</td>\n",
       "      <td>1</td>\n",
       "      <td>193.0</td>\n",
       "      <td>201505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>523</th>\n",
       "      <td>4853265</td>\n",
       "      <td>$100/day sublet off Graham stop L</td>\n",
       "      <td>24968374</td>\n",
       "      <td>Renee</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Williamsburg</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.717531</td>\n",
       "      <td>-73.942024</td>\n",
       "      <td>Private room</td>\n",
       "      <td>120</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>365.0</td>\n",
       "      <td>201505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>525</th>\n",
       "      <td>860172</td>\n",
       "      <td>Lux 1br w Private Roofdeck in WBerg</td>\n",
       "      <td>4504958</td>\n",
       "      <td>Michael</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Williamsburg</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.714858</td>\n",
       "      <td>-73.960017</td>\n",
       "      <td>Private room</td>\n",
       "      <td>119</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>360.0</td>\n",
       "      <td>201505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>526</th>\n",
       "      <td>789056</td>\n",
       "      <td>Big room. Big apt. Best corner.</td>\n",
       "      <td>728635</td>\n",
       "      <td>Simon</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Williamsburg</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.712965</td>\n",
       "      <td>-73.962208</td>\n",
       "      <td>Private room</td>\n",
       "      <td>110</td>\n",
       "      <td>2</td>\n",
       "      <td>26</td>\n",
       "      <td>2/10/2015</td>\n",
       "      <td>0.90</td>\n",
       "      <td>1</td>\n",
       "      <td>94.0</td>\n",
       "      <td>201505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>554</th>\n",
       "      <td>294717</td>\n",
       "      <td>Modern apartment w/ gorgeous view</td>\n",
       "      <td>1523610</td>\n",
       "      <td>Marissa</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Williamsburg</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.710946</td>\n",
       "      <td>-73.952387</td>\n",
       "      <td>Private room</td>\n",
       "      <td>125</td>\n",
       "      <td>3</td>\n",
       "      <td>15</td>\n",
       "      <td>4/6/2015</td>\n",
       "      <td>0.40</td>\n",
       "      <td>1</td>\n",
       "      <td>296.0</td>\n",
       "      <td>201505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>584</th>\n",
       "      <td>3730959</td>\n",
       "      <td>Private room Williamsburg</td>\n",
       "      <td>19059852</td>\n",
       "      <td>Timothy</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Williamsburg</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.711691</td>\n",
       "      <td>-73.958611</td>\n",
       "      <td>Private room</td>\n",
       "      <td>200</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>365.0</td>\n",
       "      <td>201505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>620</th>\n",
       "      <td>908469</td>\n",
       "      <td>LOVELY 1BD IN NEW BUILDING</td>\n",
       "      <td>1466713</td>\n",
       "      <td>M &amp; G</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Williamsburg</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.713155</td>\n",
       "      <td>-73.941935</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>180</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>1/5/2015</td>\n",
       "      <td>0.30</td>\n",
       "      <td>1</td>\n",
       "      <td>147.0</td>\n",
       "      <td>201505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>629</th>\n",
       "      <td>532749</td>\n",
       "      <td>Airy and Bright Loft -Williamsburg</td>\n",
       "      <td>2617850</td>\n",
       "      <td>Matthew</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Williamsburg</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.713130</td>\n",
       "      <td>-73.957613</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>199</td>\n",
       "      <td>7</td>\n",
       "      <td>27</td>\n",
       "      <td>4/19/2015</td>\n",
       "      <td>0.80</td>\n",
       "      <td>1</td>\n",
       "      <td>228.0</td>\n",
       "      <td>201505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>642</th>\n",
       "      <td>803071</td>\n",
       "      <td>Amazing Williamsburg Loft</td>\n",
       "      <td>1402744</td>\n",
       "      <td>Eric</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Williamsburg</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.720325</td>\n",
       "      <td>-73.962237</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>220</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>1/6/2015</td>\n",
       "      <td>0.20</td>\n",
       "      <td>1</td>\n",
       "      <td>321.0</td>\n",
       "      <td>201505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>651</th>\n",
       "      <td>834968</td>\n",
       "      <td>3br w/ Private Roof Steps to Subway</td>\n",
       "      <td>1896642</td>\n",
       "      <td>Jay</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Williamsburg</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.716994</td>\n",
       "      <td>-73.958170</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>238.0</td>\n",
       "      <td>201505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>736</th>\n",
       "      <td>3710571</td>\n",
       "      <td>Large private room in Williamsburg</td>\n",
       "      <td>15310524</td>\n",
       "      <td>Adam</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Williamsburg</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.714147</td>\n",
       "      <td>-73.949299</td>\n",
       "      <td>Private room</td>\n",
       "      <td>129</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>9/14/2014</td>\n",
       "      <td>0.50</td>\n",
       "      <td>1</td>\n",
       "      <td>190.0</td>\n",
       "      <td>201505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>749</th>\n",
       "      <td>595321</td>\n",
       "      <td>ARTIST HEAVEN in WILLIAMSBURG</td>\n",
       "      <td>898980</td>\n",
       "      <td>Kelly</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Williamsburg</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.713164</td>\n",
       "      <td>-73.945319</td>\n",
       "      <td>Private room</td>\n",
       "      <td>107</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>9/1/2014</td>\n",
       "      <td>0.20</td>\n",
       "      <td>1</td>\n",
       "      <td>363.0</td>\n",
       "      <td>201505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>766</th>\n",
       "      <td>5432178</td>\n",
       "      <td>Great Space in Williamsburg's Heart</td>\n",
       "      <td>28000421</td>\n",
       "      <td>Luca</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Williamsburg</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.715514</td>\n",
       "      <td>-73.943604</td>\n",
       "      <td>Private room</td>\n",
       "      <td>100</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>43.0</td>\n",
       "      <td>201505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>848</th>\n",
       "      <td>862835</td>\n",
       "      <td>Sunny,quiet Williamsburg loft</td>\n",
       "      <td>4523490</td>\n",
       "      <td>Andrew</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Williamsburg</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.719729</td>\n",
       "      <td>-73.960626</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>145</td>\n",
       "      <td>4</td>\n",
       "      <td>63</td>\n",
       "      <td>4/7/2015</td>\n",
       "      <td>2.20</td>\n",
       "      <td>2</td>\n",
       "      <td>335.0</td>\n",
       "      <td>201505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>850</th>\n",
       "      <td>1165755</td>\n",
       "      <td>Williamsburg Garden Apartment</td>\n",
       "      <td>5017190</td>\n",
       "      <td>Olivia And Andre</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>Williamsburg</td>\n",
       "      <td>11211</td>\n",
       "      <td>40.715595</td>\n",
       "      <td>-73.951929</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>225</td>\n",
       "      <td>3</td>\n",
       "      <td>12</td>\n",
       "      <td>3/3/2015</td>\n",
       "      <td>0.60</td>\n",
       "      <td>2</td>\n",
       "      <td>160.0</td>\n",
       "      <td>201505</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>241046</th>\n",
       "      <td>8149078</td>\n",
       "      <td>Hell's Kitchen private bdrm+bath</td>\n",
       "      <td>815144</td>\n",
       "      <td>Beena</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>West Village</td>\n",
       "      <td>10014</td>\n",
       "      <td>40.732152</td>\n",
       "      <td>-74.009523</td>\n",
       "      <td>Private room</td>\n",
       "      <td>100</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>13.0</td>\n",
       "      <td>201510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241048</th>\n",
       "      <td>2755951</td>\n",
       "      <td>Lovely Duplex in W Vill Townhouse</td>\n",
       "      <td>14097358</td>\n",
       "      <td>Peter</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>West Village</td>\n",
       "      <td>10014</td>\n",
       "      <td>40.736884</td>\n",
       "      <td>-74.003542</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>286</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>328.0</td>\n",
       "      <td>201510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241049</th>\n",
       "      <td>7583901</td>\n",
       "      <td>Gorgeous 1 bedroom apt West Village</td>\n",
       "      <td>23299199</td>\n",
       "      <td>Marine</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>West Village</td>\n",
       "      <td>10014</td>\n",
       "      <td>40.734535</td>\n",
       "      <td>-74.006565</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>254</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>39.0</td>\n",
       "      <td>201510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241050</th>\n",
       "      <td>4738894</td>\n",
       "      <td>Dreamy Apt in Historic West Village</td>\n",
       "      <td>17017924</td>\n",
       "      <td>Sherene</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>West Village</td>\n",
       "      <td>10014</td>\n",
       "      <td>40.734445</td>\n",
       "      <td>-74.001364</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>160</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>5/25/2015</td>\n",
       "      <td>0.60</td>\n",
       "      <td>1</td>\n",
       "      <td>272.0</td>\n",
       "      <td>201510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241051</th>\n",
       "      <td>3916062</td>\n",
       "      <td>Fabulous Modern WV Studio with View</td>\n",
       "      <td>4912341</td>\n",
       "      <td>Orit</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>West Village</td>\n",
       "      <td>10014</td>\n",
       "      <td>40.737118</td>\n",
       "      <td>-74.009175</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>145</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>201510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241052</th>\n",
       "      <td>4786340</td>\n",
       "      <td>Luxurious Modern West Village Loft</td>\n",
       "      <td>24673896</td>\n",
       "      <td>Jun</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>West Village</td>\n",
       "      <td>10014</td>\n",
       "      <td>40.729935</td>\n",
       "      <td>-74.009786</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>143</td>\n",
       "      <td>10</td>\n",
       "      <td>2</td>\n",
       "      <td>2/3/2015</td>\n",
       "      <td>0.22</td>\n",
       "      <td>1</td>\n",
       "      <td>309.0</td>\n",
       "      <td>201510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241053</th>\n",
       "      <td>3282726</td>\n",
       "      <td>3 BD West Village - w/ Patio!</td>\n",
       "      <td>3763774</td>\n",
       "      <td>Adam</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>West Village</td>\n",
       "      <td>10014</td>\n",
       "      <td>40.734210</td>\n",
       "      <td>-74.005216</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>399</td>\n",
       "      <td>1</td>\n",
       "      <td>43</td>\n",
       "      <td>9/21/2015</td>\n",
       "      <td>3.04</td>\n",
       "      <td>2</td>\n",
       "      <td>330.0</td>\n",
       "      <td>201510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241054</th>\n",
       "      <td>6776521</td>\n",
       "      <td>West Village Gem, 2 beds for 4 ppl</td>\n",
       "      <td>24289989</td>\n",
       "      <td>Amit</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>West Village</td>\n",
       "      <td>10014</td>\n",
       "      <td>40.733624</td>\n",
       "      <td>-74.005774</td>\n",
       "      <td>Private room</td>\n",
       "      <td>450</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>365.0</td>\n",
       "      <td>201510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241055</th>\n",
       "      <td>4701007</td>\n",
       "      <td>1BR in Sunny West Village 2BR</td>\n",
       "      <td>8827966</td>\n",
       "      <td>Caitlin</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>West Village</td>\n",
       "      <td>10014</td>\n",
       "      <td>40.732742</td>\n",
       "      <td>-74.003961</td>\n",
       "      <td>Private room</td>\n",
       "      <td>235</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>5/19/2015</td>\n",
       "      <td>0.33</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>201510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241056</th>\n",
       "      <td>2254731</td>\n",
       "      <td>Unique 3BD w/ Private Patio &amp; Brick</td>\n",
       "      <td>11513199</td>\n",
       "      <td>Harris Neuberg</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>West Village</td>\n",
       "      <td>10014</td>\n",
       "      <td>40.740916</td>\n",
       "      <td>-74.005687</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>2500</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>365.0</td>\n",
       "      <td>201510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241057</th>\n",
       "      <td>6054489</td>\n",
       "      <td>1BR in the heart of West Village</td>\n",
       "      <td>4219564</td>\n",
       "      <td>Samina</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>West Village</td>\n",
       "      <td>10014</td>\n",
       "      <td>40.731192</td>\n",
       "      <td>-74.002062</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>280</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>9/26/2015</td>\n",
       "      <td>1.35</td>\n",
       "      <td>1</td>\n",
       "      <td>214.0</td>\n",
       "      <td>201510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241058</th>\n",
       "      <td>288043</td>\n",
       "      <td>West Village/Meat Packing Apt.</td>\n",
       "      <td>1497569</td>\n",
       "      <td>Alex</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>West Village</td>\n",
       "      <td>10014</td>\n",
       "      <td>40.738906</td>\n",
       "      <td>-74.008600</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>212</td>\n",
       "      <td>2</td>\n",
       "      <td>18</td>\n",
       "      <td>9/1/2015</td>\n",
       "      <td>0.58</td>\n",
       "      <td>1</td>\n",
       "      <td>324.0</td>\n",
       "      <td>201510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241059</th>\n",
       "      <td>1751967</td>\n",
       "      <td>BEST 1BR HISTORIC WEST VILLAGE</td>\n",
       "      <td>9215977</td>\n",
       "      <td>Kevin</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>West Village</td>\n",
       "      <td>10014</td>\n",
       "      <td>40.731149</td>\n",
       "      <td>-74.003724</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>249</td>\n",
       "      <td>2</td>\n",
       "      <td>10</td>\n",
       "      <td>9/11/2015</td>\n",
       "      <td>0.57</td>\n",
       "      <td>1</td>\n",
       "      <td>333.0</td>\n",
       "      <td>201510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241061</th>\n",
       "      <td>6049152</td>\n",
       "      <td>Charming West Village Apartment!</td>\n",
       "      <td>19068554</td>\n",
       "      <td>Jennifer</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>West Village</td>\n",
       "      <td>10014</td>\n",
       "      <td>40.733272</td>\n",
       "      <td>-74.001725</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>250</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>141.0</td>\n",
       "      <td>201510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241063</th>\n",
       "      <td>7895928</td>\n",
       "      <td>Super cute/quintessential WV duplex</td>\n",
       "      <td>15181918</td>\n",
       "      <td>Jen</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>West Village</td>\n",
       "      <td>10014</td>\n",
       "      <td>40.734030</td>\n",
       "      <td>-74.007992</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>400</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>9/17/2015</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1</td>\n",
       "      <td>358.0</td>\n",
       "      <td>201510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241064</th>\n",
       "      <td>927075</td>\n",
       "      <td>Your NY Autumn Journey begins here!</td>\n",
       "      <td>4988480</td>\n",
       "      <td>Paul</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>West Village</td>\n",
       "      <td>10014</td>\n",
       "      <td>40.728997</td>\n",
       "      <td>-74.003712</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>238</td>\n",
       "      <td>2</td>\n",
       "      <td>30</td>\n",
       "      <td>9/21/2015</td>\n",
       "      <td>1.16</td>\n",
       "      <td>1</td>\n",
       "      <td>153.0</td>\n",
       "      <td>201510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241065</th>\n",
       "      <td>5050068</td>\n",
       "      <td>Bright &amp; beautiful Studio(elevator)</td>\n",
       "      <td>7851936</td>\n",
       "      <td>Samantha</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>West Village</td>\n",
       "      <td>10014</td>\n",
       "      <td>40.732546</td>\n",
       "      <td>-74.002285</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>200</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>7/12/2015</td>\n",
       "      <td>0.50</td>\n",
       "      <td>1</td>\n",
       "      <td>160.0</td>\n",
       "      <td>201510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241066</th>\n",
       "      <td>6822910</td>\n",
       "      <td>Clean, Charming West Village Studio</td>\n",
       "      <td>2984131</td>\n",
       "      <td>Tara</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>West Village</td>\n",
       "      <td>10014</td>\n",
       "      <td>40.733105</td>\n",
       "      <td>-74.005039</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>150</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>9/21/2015</td>\n",
       "      <td>2.90</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>201510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241068</th>\n",
       "      <td>1056118</td>\n",
       "      <td>West Village garden apartment</td>\n",
       "      <td>4846642</td>\n",
       "      <td>Donna</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>West Village</td>\n",
       "      <td>10014</td>\n",
       "      <td>40.735065</td>\n",
       "      <td>-74.000209</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>251</td>\n",
       "      <td>7</td>\n",
       "      <td>11</td>\n",
       "      <td>7/14/2015</td>\n",
       "      <td>0.41</td>\n",
       "      <td>1</td>\n",
       "      <td>331.0</td>\n",
       "      <td>201510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241070</th>\n",
       "      <td>7082338</td>\n",
       "      <td>Private Suite - West Village Duplex</td>\n",
       "      <td>7106750</td>\n",
       "      <td>Alecia</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>West Village</td>\n",
       "      <td>10014</td>\n",
       "      <td>40.734634</td>\n",
       "      <td>-74.001542</td>\n",
       "      <td>Private room</td>\n",
       "      <td>195</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>9/17/2015</td>\n",
       "      <td>1.36</td>\n",
       "      <td>2</td>\n",
       "      <td>340.0</td>\n",
       "      <td>201510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241071</th>\n",
       "      <td>8653771</td>\n",
       "      <td>Studio in the West Village</td>\n",
       "      <td>24693820</td>\n",
       "      <td>Jacqueline</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>West Village</td>\n",
       "      <td>10014</td>\n",
       "      <td>40.733654</td>\n",
       "      <td>-74.003628</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>200</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>360.0</td>\n",
       "      <td>201510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241072</th>\n",
       "      <td>528615</td>\n",
       "      <td>West Village Haven</td>\n",
       "      <td>2597207</td>\n",
       "      <td>John</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>West Village</td>\n",
       "      <td>10014</td>\n",
       "      <td>40.731179</td>\n",
       "      <td>-74.001731</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>300</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>5/23/2015</td>\n",
       "      <td>0.23</td>\n",
       "      <td>1</td>\n",
       "      <td>363.0</td>\n",
       "      <td>201510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241073</th>\n",
       "      <td>1580988</td>\n",
       "      <td>Gorgeous West Village 1BR</td>\n",
       "      <td>6716713</td>\n",
       "      <td>Daniel</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>West Village</td>\n",
       "      <td>10014</td>\n",
       "      <td>40.730318</td>\n",
       "      <td>-74.007962</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>185</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>245.0</td>\n",
       "      <td>201510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241074</th>\n",
       "      <td>4204999</td>\n",
       "      <td>Amazing West Village Gem!!</td>\n",
       "      <td>16390508</td>\n",
       "      <td>Sasha</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>West Village</td>\n",
       "      <td>10014</td>\n",
       "      <td>40.733793</td>\n",
       "      <td>-74.005673</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>199</td>\n",
       "      <td>1</td>\n",
       "      <td>34</td>\n",
       "      <td>9/25/2015</td>\n",
       "      <td>2.89</td>\n",
       "      <td>2</td>\n",
       "      <td>343.0</td>\n",
       "      <td>201510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241075</th>\n",
       "      <td>5114275</td>\n",
       "      <td>Charming West Village Studio</td>\n",
       "      <td>26425904</td>\n",
       "      <td>Alyson</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>West Village</td>\n",
       "      <td>10014</td>\n",
       "      <td>40.733509</td>\n",
       "      <td>-74.005836</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>225</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>9/30/2015</td>\n",
       "      <td>1.21</td>\n",
       "      <td>1</td>\n",
       "      <td>347.0</td>\n",
       "      <td>201510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241076</th>\n",
       "      <td>8588060</td>\n",
       "      <td>Charming studio in NYC's W. Village</td>\n",
       "      <td>45197243</td>\n",
       "      <td>Sarah</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>West Village</td>\n",
       "      <td>10014</td>\n",
       "      <td>40.738633</td>\n",
       "      <td>-74.004170</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>185</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>257.0</td>\n",
       "      <td>201510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241077</th>\n",
       "      <td>8404594</td>\n",
       "      <td>West Village Luxury, Best Location!</td>\n",
       "      <td>3262206</td>\n",
       "      <td>Emily</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>West Village</td>\n",
       "      <td>10014</td>\n",
       "      <td>40.734907</td>\n",
       "      <td>-74.004595</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>275</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>202.0</td>\n",
       "      <td>201510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241078</th>\n",
       "      <td>6434126</td>\n",
       "      <td>Lovely West Village (Rooftop &amp; Gym)</td>\n",
       "      <td>33585032</td>\n",
       "      <td>Monte</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>West Village</td>\n",
       "      <td>10014</td>\n",
       "      <td>40.736366</td>\n",
       "      <td>-74.004819</td>\n",
       "      <td>Private room</td>\n",
       "      <td>150</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>111.0</td>\n",
       "      <td>201510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241079</th>\n",
       "      <td>6301851</td>\n",
       "      <td>West Village Studio w/Private Patio</td>\n",
       "      <td>7973869</td>\n",
       "      <td>Michael</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>West Village</td>\n",
       "      <td>10014</td>\n",
       "      <td>40.730256</td>\n",
       "      <td>-74.002020</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>250</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>5/17/2015</td>\n",
       "      <td>0.22</td>\n",
       "      <td>1</td>\n",
       "      <td>259.0</td>\n",
       "      <td>201510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241080</th>\n",
       "      <td>2894701</td>\n",
       "      <td>Bedroom in cozy west village apt</td>\n",
       "      <td>14554858</td>\n",
       "      <td>Kate</td>\n",
       "      <td>Manhattan</td>\n",
       "      <td>West Village</td>\n",
       "      <td>10014</td>\n",
       "      <td>40.729748</td>\n",
       "      <td>-74.003846</td>\n",
       "      <td>Private room</td>\n",
       "      <td>180</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>364.0</td>\n",
       "      <td>201510</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>79374 rows × 18 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             id                                 name   host_id  \\\n",
       "44      1692262        Open Design Williamsburg Loft   8939428   \n",
       "105     2454713  Sunny, Spacious 1BR apt- City views   9166868   \n",
       "183     2756733   BEAUTIFUL PRIVATE ROOM IN BROOKLYN   1711182   \n",
       "184     4623894         Huge Room in S. Williamsburg  23948611   \n",
       "185     3767695             Huge S. Williamsburg Apt  19303055   \n",
       "213     3993141  Great Room in Cozy Williamsburg Apt  20699508   \n",
       "290     1925224      Beautiful, large, charming spot   9946315   \n",
       "300     4668531     Amazing 1BR with private terrace    756577   \n",
       "328     2537745   Sweet Lil Williamsburg One Bedroom   4106281   \n",
       "363     5038425           Sunny room in Williamsburg   2163758   \n",
       "366     3223379         Modern 1 Bdr in Williamsburg   1299702   \n",
       "434      626171              Williamsburg Waterfront   3107764   \n",
       "436      571471       Sunny Southside Williamsburg!    2812516   \n",
       "484     5480038  Large Private Room in Williamsburg!  27590887   \n",
       "504      413504    Perfect NYC/Williamsburg Location   1286417   \n",
       "505      324000  Sunny WILLIAMSBURG. Home Sweet Home   1586138   \n",
       "523     4853265    $100/day sublet off Graham stop L  24968374   \n",
       "525      860172  Lux 1br w Private Roofdeck in WBerg   4504958   \n",
       "526      789056      Big room. Big apt. Best corner.    728635   \n",
       "554      294717    Modern apartment w/ gorgeous view   1523610   \n",
       "584     3730959           Private room Williamsburg   19059852   \n",
       "620      908469          LOVELY 1BD IN NEW BUILDING    1466713   \n",
       "629      532749   Airy and Bright Loft -Williamsburg   2617850   \n",
       "642      803071           Amazing Williamsburg Loft    1402744   \n",
       "651      834968  3br w/ Private Roof Steps to Subway   1896642   \n",
       "736     3710571   Large private room in Williamsburg  15310524   \n",
       "749      595321        ARTIST HEAVEN in WILLIAMSBURG    898980   \n",
       "766     5432178  Great Space in Williamsburg's Heart  28000421   \n",
       "848      862835       Sunny,quiet Williamsburg loft    4523490   \n",
       "850     1165755        Williamsburg Garden Apartment   5017190   \n",
       "...         ...                                  ...       ...   \n",
       "241046  8149078     Hell's Kitchen private bdrm+bath    815144   \n",
       "241048  2755951   Lovely Duplex in W Vill Townhouse   14097358   \n",
       "241049  7583901  Gorgeous 1 bedroom apt West Village  23299199   \n",
       "241050  4738894  Dreamy Apt in Historic West Village  17017924   \n",
       "241051  3916062  Fabulous Modern WV Studio with View   4912341   \n",
       "241052  4786340   Luxurious Modern West Village Loft  24673896   \n",
       "241053  3282726        3 BD West Village - w/ Patio!   3763774   \n",
       "241054  6776521   West Village Gem, 2 beds for 4 ppl  24289989   \n",
       "241055  4701007        1BR in Sunny West Village 2BR   8827966   \n",
       "241056  2254731  Unique 3BD w/ Private Patio & Brick  11513199   \n",
       "241057  6054489     1BR in the heart of West Village   4219564   \n",
       "241058   288043       West Village/Meat Packing Apt.   1497569   \n",
       "241059  1751967       BEST 1BR HISTORIC WEST VILLAGE   9215977   \n",
       "241061  6049152     Charming West Village Apartment!  19068554   \n",
       "241063  7895928  Super cute/quintessential WV duplex  15181918   \n",
       "241064   927075  Your NY Autumn Journey begins here!   4988480   \n",
       "241065  5050068  Bright & beautiful Studio(elevator)   7851936   \n",
       "241066  6822910  Clean, Charming West Village Studio   2984131   \n",
       "241068  1056118        West Village garden apartment   4846642   \n",
       "241070  7082338  Private Suite - West Village Duplex   7106750   \n",
       "241071  8653771           Studio in the West Village  24693820   \n",
       "241072   528615                   West Village Haven   2597207   \n",
       "241073  1580988            Gorgeous West Village 1BR   6716713   \n",
       "241074  4204999           Amazing West Village Gem!!  16390508   \n",
       "241075  5114275        Charming West Village Studio   26425904   \n",
       "241076  8588060  Charming studio in NYC's W. Village  45197243   \n",
       "241077  8404594  West Village Luxury, Best Location!   3262206   \n",
       "241078  6434126  Lovely West Village (Rooftop & Gym)  33585032   \n",
       "241079  6301851  West Village Studio w/Private Patio   7973869   \n",
       "241080  2894701     Bedroom in cozy west village apt  14554858   \n",
       "\n",
       "               host_name neighbourhood_group neighbourhood  zipcode  \\\n",
       "44          Margo & Dave                 NaN           NaN    11211   \n",
       "105         Tom And Anna                 NaN           NaN    11211   \n",
       "183                Allon            Brooklyn  Williamsburg    11211   \n",
       "184               Hannah            Brooklyn  Williamsburg    11211   \n",
       "185                 Greg            Brooklyn  Williamsburg    11211   \n",
       "213                Brent            Brooklyn  Williamsburg    11211   \n",
       "290                Susan            Brooklyn  Williamsburg    11211   \n",
       "300                Jason            Brooklyn  Williamsburg    11211   \n",
       "328               Ginnie            Brooklyn  Williamsburg    11211   \n",
       "363               Leslie            Brooklyn  Williamsburg    11211   \n",
       "366                Laura            Brooklyn  Williamsburg    11211   \n",
       "434               Godric            Brooklyn  Williamsburg    11211   \n",
       "436                Freda            Brooklyn  Williamsburg    11211   \n",
       "484              Matthew            Brooklyn  Williamsburg    11211   \n",
       "504                 Omri            Brooklyn  Williamsburg    11211   \n",
       "505               Javier            Brooklyn  Williamsburg    11211   \n",
       "523                Renee            Brooklyn  Williamsburg    11211   \n",
       "525              Michael            Brooklyn  Williamsburg    11211   \n",
       "526                Simon            Brooklyn  Williamsburg    11211   \n",
       "554              Marissa            Brooklyn  Williamsburg    11211   \n",
       "584              Timothy            Brooklyn  Williamsburg    11211   \n",
       "620                M & G            Brooklyn  Williamsburg    11211   \n",
       "629              Matthew            Brooklyn  Williamsburg    11211   \n",
       "642                 Eric            Brooklyn  Williamsburg    11211   \n",
       "651                  Jay            Brooklyn  Williamsburg    11211   \n",
       "736                 Adam            Brooklyn  Williamsburg    11211   \n",
       "749                Kelly            Brooklyn  Williamsburg    11211   \n",
       "766                 Luca            Brooklyn  Williamsburg    11211   \n",
       "848               Andrew            Brooklyn  Williamsburg    11211   \n",
       "850     Olivia And Andre            Brooklyn  Williamsburg    11211   \n",
       "...                  ...                 ...           ...      ...   \n",
       "241046             Beena           Manhattan  West Village    10014   \n",
       "241048             Peter           Manhattan  West Village    10014   \n",
       "241049            Marine           Manhattan  West Village    10014   \n",
       "241050           Sherene           Manhattan  West Village    10014   \n",
       "241051              Orit           Manhattan  West Village    10014   \n",
       "241052               Jun           Manhattan  West Village    10014   \n",
       "241053              Adam           Manhattan  West Village    10014   \n",
       "241054              Amit           Manhattan  West Village    10014   \n",
       "241055           Caitlin           Manhattan  West Village    10014   \n",
       "241056    Harris Neuberg           Manhattan  West Village    10014   \n",
       "241057            Samina           Manhattan  West Village    10014   \n",
       "241058              Alex           Manhattan  West Village    10014   \n",
       "241059             Kevin           Manhattan  West Village    10014   \n",
       "241061          Jennifer           Manhattan  West Village    10014   \n",
       "241063               Jen           Manhattan  West Village    10014   \n",
       "241064              Paul           Manhattan  West Village    10014   \n",
       "241065          Samantha           Manhattan  West Village    10014   \n",
       "241066              Tara           Manhattan  West Village    10014   \n",
       "241068             Donna           Manhattan  West Village    10014   \n",
       "241070            Alecia           Manhattan  West Village    10014   \n",
       "241071        Jacqueline           Manhattan  West Village    10014   \n",
       "241072              John           Manhattan  West Village    10014   \n",
       "241073            Daniel           Manhattan  West Village    10014   \n",
       "241074             Sasha           Manhattan  West Village    10014   \n",
       "241075            Alyson           Manhattan  West Village    10014   \n",
       "241076             Sarah           Manhattan  West Village    10014   \n",
       "241077             Emily           Manhattan  West Village    10014   \n",
       "241078             Monte           Manhattan  West Village    10014   \n",
       "241079           Michael           Manhattan  West Village    10014   \n",
       "241080              Kate           Manhattan  West Village    10014   \n",
       "\n",
       "         latitude  longitude        room_type  price  minimum_nights  \\\n",
       "44      40.710927 -73.969512  Entire home/apt    269               2   \n",
       "105     40.713027 -73.968905  Entire home/apt    210               2   \n",
       "183     40.712475 -73.945975     Private room     70               1   \n",
       "184     40.709796 -73.954458     Private room     80               1   \n",
       "185     40.709601 -73.953077     Private room    200               4   \n",
       "213     40.709200 -73.955836     Private room     40               1   \n",
       "290     40.717577 -73.954302  Entire home/apt    190               6   \n",
       "300     40.717988 -73.951638  Entire home/apt    175               3   \n",
       "328     40.711894 -73.954685  Entire home/apt    126               1   \n",
       "363     40.715368 -73.937843     Private room     60               1   \n",
       "366     40.708266 -73.952366  Entire home/apt    175               1   \n",
       "434     40.719700 -73.962628  Entire home/apt    195               3   \n",
       "436     40.710078 -73.955845     Private room     65               2   \n",
       "484     40.712033 -73.941860     Private room     90               1   \n",
       "504     40.713480 -73.944471     Private room    109               3   \n",
       "505     40.711682 -73.962394  Entire home/apt    200               3   \n",
       "523     40.717531 -73.942024     Private room    120               1   \n",
       "525     40.714858 -73.960017     Private room    119               2   \n",
       "526     40.712965 -73.962208     Private room    110               2   \n",
       "554     40.710946 -73.952387     Private room    125               3   \n",
       "584     40.711691 -73.958611     Private room    200               1   \n",
       "620     40.713155 -73.941935  Entire home/apt    180               3   \n",
       "629     40.713130 -73.957613  Entire home/apt    199               7   \n",
       "642     40.720325 -73.962237  Entire home/apt    220               3   \n",
       "651     40.716994 -73.958170  Entire home/apt    500               5   \n",
       "736     40.714147 -73.949299     Private room    129               1   \n",
       "749     40.713164 -73.945319     Private room    107               3   \n",
       "766     40.715514 -73.943604     Private room    100               1   \n",
       "848     40.719729 -73.960626  Entire home/apt    145               4   \n",
       "850     40.715595 -73.951929  Entire home/apt    225               3   \n",
       "...           ...        ...              ...    ...             ...   \n",
       "241046  40.732152 -74.009523     Private room    100               3   \n",
       "241048  40.736884 -74.003542  Entire home/apt    286              14   \n",
       "241049  40.734535 -74.006565  Entire home/apt    254               1   \n",
       "241050  40.734445 -74.001364  Entire home/apt    160               2   \n",
       "241051  40.737118 -74.009175  Entire home/apt    145               4   \n",
       "241052  40.729935 -74.009786  Entire home/apt    143              10   \n",
       "241053  40.734210 -74.005216  Entire home/apt    399               1   \n",
       "241054  40.733624 -74.005774     Private room    450               1   \n",
       "241055  40.732742 -74.003961     Private room    235               3   \n",
       "241056  40.740916 -74.005687  Entire home/apt   2500               1   \n",
       "241057  40.731192 -74.002062  Entire home/apt    280               2   \n",
       "241058  40.738906 -74.008600  Entire home/apt    212               2   \n",
       "241059  40.731149 -74.003724  Entire home/apt    249               2   \n",
       "241061  40.733272 -74.001725  Entire home/apt    250               7   \n",
       "241063  40.734030 -74.007992  Entire home/apt    400               1   \n",
       "241064  40.728997 -74.003712  Entire home/apt    238               2   \n",
       "241065  40.732546 -74.002285  Entire home/apt    200               3   \n",
       "241066  40.733105 -74.005039  Entire home/apt    150               2   \n",
       "241068  40.735065 -74.000209  Entire home/apt    251               7   \n",
       "241070  40.734634 -74.001542     Private room    195               2   \n",
       "241071  40.733654 -74.003628  Entire home/apt    200               1   \n",
       "241072  40.731179 -74.001731  Entire home/apt    300               2   \n",
       "241073  40.730318 -74.007962  Entire home/apt    185               6   \n",
       "241074  40.733793 -74.005673  Entire home/apt    199               1   \n",
       "241075  40.733509 -74.005836  Entire home/apt    225               1   \n",
       "241076  40.738633 -74.004170  Entire home/apt    185               2   \n",
       "241077  40.734907 -74.004595  Entire home/apt    275               2   \n",
       "241078  40.736366 -74.004819     Private room    150               1   \n",
       "241079  40.730256 -74.002020  Entire home/apt    250               5   \n",
       "241080  40.729748 -74.003846     Private room    180               1   \n",
       "\n",
       "        number_of_reviews last_review  reviews_per_month  \\\n",
       "44                     58    4/6/2015               3.20   \n",
       "105                    18   4/28/2015               1.40   \n",
       "183                     7    7/4/2014               0.60   \n",
       "184                     0         NaN                NaN   \n",
       "185                     1   10/5/2014               0.10   \n",
       "213                     0         NaN                NaN   \n",
       "290                    11   1/12/2015               0.60   \n",
       "300                     0         NaN                NaN   \n",
       "328                    59   4/28/2015               4.40   \n",
       "363                     5    4/9/2015               3.40   \n",
       "366                    11    1/1/2015               1.30   \n",
       "434                    30   12/8/2013               1.00   \n",
       "436                    18   3/21/2015               0.50   \n",
       "484                     0         NaN                NaN   \n",
       "504                    58    5/1/2015               1.60   \n",
       "505                    86   4/16/2015               2.30   \n",
       "523                     0         NaN                NaN   \n",
       "525                     0         NaN                NaN   \n",
       "526                    26   2/10/2015               0.90   \n",
       "554                    15    4/6/2015               0.40   \n",
       "584                     0         NaN                NaN   \n",
       "620                     8    1/5/2015               0.30   \n",
       "629                    27   4/19/2015               0.80   \n",
       "642                     6    1/6/2015               0.20   \n",
       "651                     0         NaN                NaN   \n",
       "736                     4   9/14/2014               0.50   \n",
       "749                     2    9/1/2014               0.20   \n",
       "766                     0         NaN                NaN   \n",
       "848                    63    4/7/2015               2.20   \n",
       "850                    12    3/3/2015               0.60   \n",
       "...                   ...         ...                ...   \n",
       "241046                  0         NaN                NaN   \n",
       "241048                  0         NaN                NaN   \n",
       "241049                  0         NaN                NaN   \n",
       "241050                  3   5/25/2015               0.60   \n",
       "241051                  0         NaN                NaN   \n",
       "241052                  2    2/3/2015               0.22   \n",
       "241053                 43   9/21/2015               3.04   \n",
       "241054                  0         NaN                NaN   \n",
       "241055                  3   5/19/2015               0.33   \n",
       "241056                  0         NaN                NaN   \n",
       "241057                  7   9/26/2015               1.35   \n",
       "241058                 18    9/1/2015               0.58   \n",
       "241059                 10   9/11/2015               0.57   \n",
       "241061                  0         NaN                NaN   \n",
       "241063                  1   9/17/2015               1.00   \n",
       "241064                 30   9/21/2015               1.16   \n",
       "241065                  2   7/12/2015               0.50   \n",
       "241066                  6   9/21/2015               2.90   \n",
       "241068                 11   7/14/2015               0.41   \n",
       "241070                  3   9/17/2015               1.36   \n",
       "241071                  0         NaN                NaN   \n",
       "241072                  1   5/23/2015               0.23   \n",
       "241073                  0         NaN                NaN   \n",
       "241074                 34   9/25/2015               2.89   \n",
       "241075                  7   9/30/2015               1.21   \n",
       "241076                  0         NaN                NaN   \n",
       "241077                  0         NaN                NaN   \n",
       "241078                  0         NaN                NaN   \n",
       "241079                  1   5/17/2015               0.22   \n",
       "241080                  0         NaN                NaN   \n",
       "\n",
       "        calculated_host_listings_count  availability_365  year_month  \n",
       "44                                   1             262.0      201505  \n",
       "105                                  1             102.0      201505  \n",
       "183                                  1             118.0      201505  \n",
       "184                                  1             151.0      201505  \n",
       "185                                  1             365.0      201505  \n",
       "213                                  1             117.0      201505  \n",
       "290                                  1             119.0      201505  \n",
       "300                                  1             132.0      201505  \n",
       "328                                  1             324.0      201505  \n",
       "363                                  1             303.0      201505  \n",
       "366                                  1             118.0      201505  \n",
       "434                                  1             120.0      201505  \n",
       "436                                  1             218.0      201505  \n",
       "484                                  1             365.0      201505  \n",
       "504                                  1             332.0      201505  \n",
       "505                                  1             193.0      201505  \n",
       "523                                  1             365.0      201505  \n",
       "525                                  1             360.0      201505  \n",
       "526                                  1              94.0      201505  \n",
       "554                                  1             296.0      201505  \n",
       "584                                  1             365.0      201505  \n",
       "620                                  1             147.0      201505  \n",
       "629                                  1             228.0      201505  \n",
       "642                                  1             321.0      201505  \n",
       "651                                  1             238.0      201505  \n",
       "736                                  1             190.0      201505  \n",
       "749                                  1             363.0      201505  \n",
       "766                                  1              43.0      201505  \n",
       "848                                  2             335.0      201505  \n",
       "850                                  2             160.0      201505  \n",
       "...                                ...               ...         ...  \n",
       "241046                               1              13.0      201510  \n",
       "241048                               1             328.0      201510  \n",
       "241049                               1              39.0      201510  \n",
       "241050                               1             272.0      201510  \n",
       "241051                               1               0.0      201510  \n",
       "241052                               1             309.0      201510  \n",
       "241053                               2             330.0      201510  \n",
       "241054                               3             365.0      201510  \n",
       "241055                               1               0.0      201510  \n",
       "241056                               1             365.0      201510  \n",
       "241057                               1             214.0      201510  \n",
       "241058                               1             324.0      201510  \n",
       "241059                               1             333.0      201510  \n",
       "241061                               2             141.0      201510  \n",
       "241063                               1             358.0      201510  \n",
       "241064                               1             153.0      201510  \n",
       "241065                               1             160.0      201510  \n",
       "241066                               1               0.0      201510  \n",
       "241068                               1             331.0      201510  \n",
       "241070                               2             340.0      201510  \n",
       "241071                               1             360.0      201510  \n",
       "241072                               1             363.0      201510  \n",
       "241073                               1             245.0      201510  \n",
       "241074                               2             343.0      201510  \n",
       "241075                               1             347.0      201510  \n",
       "241076                               1             257.0      201510  \n",
       "241077                               1             202.0      201510  \n",
       "241078                               1             111.0      201510  \n",
       "241079                               1             259.0      201510  \n",
       "241080                               2             364.0      201510  \n",
       "\n",
       "[79374 rows x 18 columns]"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Create Data Frame with specified zipcodes\n",
    "frames = []\n",
    "\n",
    "for zipcode in zipcodes:\n",
    "    one_zip = listings.loc[listings['zipcode']==zipcode]\n",
    "    frames.append(one_zip)\n",
    "\n",
    "by_zip = pd.concat(frames)\n",
    "by_zip"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>count</th>\n",
       "      <th>mean</th>\n",
       "      <th>std</th>\n",
       "      <th>min</th>\n",
       "      <th>25%</th>\n",
       "      <th>50%</th>\n",
       "      <th>75%</th>\n",
       "      <th>max</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>year_month</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>201505</th>\n",
       "      <td>8923.0</td>\n",
       "      <td>172.626471</td>\n",
       "      <td>190.900931</td>\n",
       "      <td>10.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>140.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>6500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>201506</th>\n",
       "      <td>9044.0</td>\n",
       "      <td>172.455661</td>\n",
       "      <td>174.964736</td>\n",
       "      <td>16.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>145.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>6500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>201508</th>\n",
       "      <td>9963.0</td>\n",
       "      <td>166.117736</td>\n",
       "      <td>166.001524</td>\n",
       "      <td>10.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>139.0</td>\n",
       "      <td>199.0</td>\n",
       "      <td>6500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>201509</th>\n",
       "      <td>9897.0</td>\n",
       "      <td>167.404769</td>\n",
       "      <td>170.256753</td>\n",
       "      <td>20.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>140.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>6500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>201510</th>\n",
       "      <td>9776.0</td>\n",
       "      <td>168.963687</td>\n",
       "      <td>161.159099</td>\n",
       "      <td>25.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>140.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>6500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>201511</th>\n",
       "      <td>20698.0</td>\n",
       "      <td>165.897188</td>\n",
       "      <td>157.696932</td>\n",
       "      <td>15.0</td>\n",
       "      <td>89.0</td>\n",
       "      <td>139.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>6500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>201512</th>\n",
       "      <td>11073.0</td>\n",
       "      <td>161.413980</td>\n",
       "      <td>153.400942</td>\n",
       "      <td>15.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>130.0</td>\n",
       "      <td>199.0</td>\n",
       "      <td>6500.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              count        mean         std   min   25%    50%    75%     max\n",
       "year_month                                                                   \n",
       "201505       8923.0  172.626471  190.900931  10.0  90.0  140.0  200.0  6500.0\n",
       "201506       9044.0  172.455661  174.964736  16.0  90.0  145.0  200.0  6500.0\n",
       "201508       9963.0  166.117736  166.001524  10.0  89.0  139.0  199.0  6500.0\n",
       "201509       9897.0  167.404769  170.256753  20.0  89.0  140.0  200.0  6500.0\n",
       "201510       9776.0  168.963687  161.159099  25.0  90.0  140.0  200.0  6500.0\n",
       "201511      20698.0  165.897188  157.696932  15.0  89.0  139.0  200.0  6500.0\n",
       "201512      11073.0  161.413980  153.400942  15.0  85.0  130.0  199.0  6500.0"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Find average prices by month\n",
    "by_month = by_zip.groupby('year_month')['price'].describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAnQAAAFNCAYAAACJ9PI3AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMi4zLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvIxREBQAAIABJREFUeJzt3XeYXGXd//H3Nxsg9FAjPSBBH0BEDE0sQVEp+kPxUUAUpAWlCiiggFRBkC69RAGl6WPhUYpcyMoDAhIQ6UJIwEAoAWIglJBs7t8f91lmsuwmm2Rmz5zd9+u65ppz33PmnO/c2cx+9tRIKSFJkqTqGlR2AZIkSVowBjpJkqSKM9BJkiRVnIFOkiSp4gx0kiRJFWegkyRJqjgDnaR+IyJujIjdyq6jVUTEtyLijrLrkNR8BjpJLSsino6ItyJiWkS8GBE/j4glepo/pbRNSunyvqyxNyJiVESkiPhtl/4PF/3tDVjH8GJZgxd0WZKqx0AnqdV9MaW0BLARsDFwVNcZImv177PJwMciYrm6vt2AJ0qqR1I/0upfgJIEQErpOeBGYH2AiGiPiB9HxJ3Am8BaRd9ene+JiL0j4rGIeD0iHo2IjYr+lSPifyJickRMiIgDu1tnRGwWES9ERFtd35cj4sFiepOIGBsRrxVbEM+Yw0d4B/g9sFPx3jbga8CvuqzzYxFxb0RMLZ4/Vvdae0ScEBF3Fp/pzxGxfPHy7cXzf4otmpvXve+0iJhSfNZt5lCjpIoy0EmqhIhYDdgW+Edd9zeB0cCSwDNd5v8qcCywK7AU8P+AV4otef8L/BNYBfgM8N2I+HzXdaaU7gbeAD5d1/114Kpi+mzg7JTSUsD7gevm8jGuKOoB+DzwCDCpruZlgT8B5wDLAWcAf+qyVe/rwO7AisDCwPeK/k8Wz0NTSkuklO4q2psC/wKWB04FLouImEudkirGQCep1f0+Iv4D3AH8FTip7rVfpJQeSSnNTCnN6PK+vYBTU0r3pmxcSukZ8m7bFVJKx6eU3kkpjQcuodhy1o2rgZ0BImJJcqi8unhtBrB2RCyfUppWBMAepZT+BiwbER8gB7srusyyHfBkSunK4jNdDTwOfLFunp+nlJ5IKb1FDpAbzmmdwDMppUtSSh3A5cBKwLC5vEdSxRjoJLW6L6WUhqaU1kgp7VsEmU4T5/C+1YCnuulfA1g5Iv7T+QB+SM8h5ypgh4hYBNgBuL8IhgB7AusAjxe7R7/Qi89zJbA/sCXwuy6vrUyXLY1Fe5W69gt1028CPZ4k0nX+lNKbxeTc3iOpYjwbSlKVpTm8NpG8G7S7/gkppRG9WkFKj0bEM8A2zL67lZTSk8DOxW7cHYDfRMRyKaU35rDIK4FxwBUppTe77P2cRA6c9VYHbupNqb2YR1I/5RY6Sf3VpcD3IuKjxVmwa0fEGsDfgdci4vCIWDQi2iJi/YjYeA7Lugo4kHyc2q87OyPiGxGxQkppFvCfortjTkWllCYAnwKO7OblG4B1IuLrETE4InYE1gX+2IvPOxmYBazVi3kl9TMGOkn9Ukrp18CPyWHsdfIZpssWx5J9kXzs2QTgZXL4W3oOi7saGAX8JaX0cl3/1sAjETGNfILETimlt3tR2x0ppUnd9L8CfAE4FHgFOAz4Qpd19rTMN8mf985iV/Jmc3uPpP4jUnIrvSRJUpW5hU6SJKniDHSSJEkVZ6CTJEmqOAOdJElSxRnoJEmSKm7AXVh4+eWXT8OHD2/qOt544w0WX3zxpq5joHFMG8vxbDzHtLEcz8ZzTBurr8bzvvvuezmltMLc5htwgW748OGMHTu2qetob29n1KhRTV3HQOOYNpbj2XiOaWM5no3nmDZWX41ncaeauXKXqyRJUsUZ6CRJkirOQCdJklRxBjpJkqSKM9BJkiRVnIFOkiSp4gx0kiRJFWegkyRJqjgDnSRJ/d3rrxMzZpRdhZrIQCdJUn/2i1/AMsuw8Z57wnPPlV2NmsRAJ0lSf/XUU7DvvtDRwWITJ8Iuu0BHR9lVqQkMdJIk9Ucpwd57w1tv1fr++lc48cTyalLTGOgkSeqPLrsMbrvtvf3HH5+DnfoVA50kSf3Nc8/BoYfW2oceyn8+/OE8PWtW3vX68svl1KamMNBJktSfpJSPm3vttdxee2044QQePfJIWG653Pfcc7D77nle9QtNC3QRsVpE3BYRj0XEIxFxUNG/bETcEhFPFs/LFP0REedExLiIeDAiNqpb1m7F/E9GxG51/R+NiIeK95wTEdGszyNJUiX8+tdw/fW19qWXwqKL8s4KK8Dll9f6//hHOPvsvq9PTdHMLXQzgUNTSv8FbAbsFxHrAkcAt6aURgC3Fm2AbYARxWM0cAHkAAgcA2wKbAIc0xkCi3lG171v6yZ+HkmSWtsrr8ABB9Ta++wDn/pUrb3ddnDwwbX2YYfBfff1XX1qmqYFupTS8yml+4vp14HHgFWA7YHOPxEuB75UTG8PXJGyu4GhEbES8HnglpTSqymlKcAtwNbFa0ullO5KKSXgirplSZI08BxyCLz0Up5eZRU45ZT3znPyyfDRj+bpGTNgxx1ru2dVWX1yDF1EDAc+AtwDDEspPQ859AErFrOtAkyse9uzRd+c+p/tpl+SpIHnppvgiitq7QsugKWXfu98iywC11wDSy6Z2089Bd/5jsfTVdzgZq8gIpYA/gf4bkrptTkc5tbdC2k++rurYTR51yzDhg2jvb19LlUvmGnTpjV9HQONY9pYjmfjOaaN5XjOm7Y332TjPfZgSNF+8dOf5rEll4S6Mew6pisedBDrdl6T7qqreHzVVXlhm236rOaqa7Wf0aYGuohYiBzmfpVS+m3R/WJErJRSer7YbVpsG+ZZYLW6t68KTCr6R3Xpby/6V+1m/vdIKV0MXAwwcuTINGrUqO5ma5j29naavY6BxjFtLMez8RzTxnI859EBB8CLL+bp5ZZj2DXXMGyFFWab5T1jOmoUTJoEY8YA8MFzz+WD3/oW/Nd/9UnJVddqP6PNPMs1gMuAx1JKZ9S9dD3QeabqbsAf6vp3Lc523QyYWuySvRn4XEQsU5wM8Tng5uK11yNis2Jdu9YtS5KkgeGOO+C882rtc86BLmGuR+ecAx/8YJ5+803YaafZ7yyhymjmMXRbAN8EPh0RDxSPbYGfAJ+NiCeBzxZtgBuA8cA44BJgX4CU0qvACcC9xeP4og/gO8ClxXueAm5s4ueRJKm1vP027LVX7fi37baDnXfu/fsXXxyuvTYfVwfw4IOzX5BYldG0Xa4ppTvo/jg3gM90M38C9uthWWOAMd30jwXWX4AyJUmqrhNOgH/9K08vuWQ+EWJeL8m6wQZw1ln5xAjIy/jMZ+ArX2lsrWoq7xQhSVIVPfDA7JclOfVUWG21nuefk332mT3A7bknPP30ApWnvmWgkySpambOhD32gI6O3P7kJ2H06PlfXkS+o8Qaa+T21Kl51+2MGQteq/qEgU6SpKo5/XT4xz/y9JAhcMklMGgBf6UPHZqvT9fWltt33w0/+tGCLVN9xkAnSVKVPPEEHHNMrX3ssbDOOo1Z9mabwY9/XGv/5Cfw5z83ZtlqKgOdJElVMWtWPqt1+vTc3mijxp+V+v3vw2c/W2t/85vwwguNXYcazkAnSVJVXHwx/N//5em2NrjsMhjc4AtWDBoEV14Jw4bl9ksvwa675jCplmWgkySpCiZOhMMOq7UPPxw23LA56xo2DH75y9olUG65JZ9Fq5ZloJMkqdWllK8T9/rruf2BD8DRRzd3nVttBUccUWsfdRTcdVdz16n5ZqCTJKnVXX01/OlPeToi72odMqT56z3uONh88zzd0ZEvZTJlSvPXq3lmoJMkqZVNngwHHlhr77cfbLFF36x7oYVymBw6NLefeWb2W42pZRjoJElqZQcdBK+8kqdXXx1OOqlv17/GGnmLYKff/hYuvLBva9BcGegkSWpV//u/eQtZp4suyvds7Ws77AD77ltrH3wwPPhg39ehHhnoJElqRVOn5hMhOu26K2y9dXn1nH46bLBBnp4+HXbcEd54o7x6NBsDnSRJrejww+G55/L0iivCGWeUW8+QIXDttbDYYrn9+ONwwAHl1qR3GegkSWo17e1592qnn/0MlluutHLe9cEPwnnn1do//zn86lfl1aN3GegkSWolb74Je+9da2+/PXz1q+XV09Vuu8Euu9Ta3/42jBtXXj0CDHSSJLWWY4+tBaSll4bzz6/dsaEVRMAFF8Daa+f2tGn5eLrO+8uqFAY6SZJaxdix+eSDTqedBiuvXF49PVlyyXw83UIL5fb9989+Vwn1OQOdJEmtYMYM2HNPmDUrt7fcMrdb1UYbwU9/WmufdVa+zIpKYaCTJKkVnHpq7dpuiy4Kl1zSWrtau3PggfCFL9Tau+8Ozz5bXj0DmIFOkqSyPfYYHH98rX3iifD+95dXT29F5DNdV1klt195JZ8wMXNmuXUNQAY6SZLK1NGRd62+805ub7JJvt1XVSy/PFx1FQwqIsXtt+dAqj5loJMkqUznnw933ZWnF1oo3ze1ra3cmubVJz8JxxxTa59wQr6WnvqMgU6SpLI8/TT84Ae19g9/COuvX1o5C+TII2HUqDw9a1be9Tp5cqklDSQGOkmSypAS7LNP7X6o6603e7irmra2fNeI5ZfP7UmT4Fvfyp9TTWegkySpDFdcAX/+c56OyLtaF1mk3JoW1Morwy9+UWvfcEO+nImazkAnSVJfe+EFOPjgWvugg2DTTcurp5G22w4OOaTWPvzwfMFkNZWBTpKkvnbAATBlSp4ePrz/nRV68skwcmSenjEDdtoJXnut3Jr6OQOdJEl96Xe/g9/8pta+5BJYfPHy6mmGhReGa67JtwgDeOqpfLygx9M1jYFOkqS+MmUK7Ltvrb3HHrDVVuXV00zvfz9cfHGtfc01+SLEagoDnSRJfeX738/HzwG8731w2mnl1tNsO+00+/1o998/3xVDDWegkySpL9x6az6TtdP558Myy5RXT1855xz4r//K02+9BV/7Wn5WQxnoJElqtjfegL33rrX/+7/hy18ur56+tNhicO21MGRIbj/88OxnwaohDHSSJDXb0UfDhAl5epll4Gc/K7eevvahD81+PboLL5z9xBAtMAOdJEnNdPfds4eZM8/Mx88NNKNH5y2TnfbaqxZytcAMdJIkNcv06fmkgM7LdXzuc7DrruXWVJaIfImW4cNze+pU2HnnfJ06LTADnSRJzXLyyfDoo3l68cXhootysBmohg6Fq6+GwYNz+5578u5oLTADnSRJzfDQQ3DSSbX2SSfVtk4NZJttBj/+ca19yim1e9pqvhnoJElqtI6OvKu1c3fi5pvDfvuVW1Mr+d734POfr7W/+c3a9fk0Xwx0kiQ12tlnw7335umFF4ZLL4W2tnJraiWDBsEVV9RODnnpJfjGN2DWrHLrqjADnSRJjfTUU3DUUbX20UfDuuuWV0+rWnFFuPLK2jGFt96ad79qvhjoJElqlJTy5Tk674SwwQZw2GHl1tTKttoKfvCDWvvoo+Fvfyuvngoz0EmS1ChjxsBf/pKnBw3Kt/paeOFya2p1xx0HW2yRpzs68qVMXn213JoqyEAnSVIjTJoEhx5aax96KIwcWV49VTF4MFx1Vb6kCcC//50vOtx57T71ioFOkqQFlRLsu2++WC7A2mvDsceWWlKlrL563rrZ6Xe/gwsuKK+eCjLQSZK0oH7zG/jDH2rtSy7JN6VX7335y7Nf2uWQQ+Cf/yyvnoox0EmStCBeeQX237/W3mcfGDWqtHIq7bTT4MMfztPTp8OOO8K0aeXWVBEGOkmSFsQhh+TrqAGssoqX3lgQQ4bAtdfm26QB/OtfcMAB5dZUEQY6SZLm10035QvkdrrgAlh66fLq6Q8+8AE477xa+xe/gF/+srRyqsJAJ0nS/Hj99bx7tdNOO8EXv1hePf3JrrvmO0d0+s534Mkny6unAgx0kiTNjx/+MF9iA2C55fLtvtQYEXD++TBiRG5Pm5aPp5s+vdy6WljTAl1EjImIlyLi4bq+YyPiuYh4oHhsW/faDyJiXET8KyI+X9e/ddE3LiKOqOtfMyLuiYgnI+LaiPDKjZKkvnHHHbPvFjz77HwrKzXOkkvCNdfULsz8j3/A4YeXW1MLa+YWul8AW3fTf2ZKacPicQNARKwL7ASsV7zn/Ihoi4g24DxgG2BdYOdiXoBTimWNAKYAezbxs0iSlL399uwXvt12W/j618utqb/aaCP46U9r7bPPhuuvL6+eFta0QJdSuh3o7b07tgeuSSlNTylNAMYBmxSPcSml8Smld4BrgO0jIoBPA78p3n858KWGfgBJkrpzwgn57EuAJZaACy+s3WBejXfAAfD//l+tvfvuMHFiefW0qMElrHP/iNgVGAscmlKaAqwC3F03z7NFH8DELv2bAssB/0kpzexm/veIiNHAaIBhw4bR3t7egI/Rs2nTpjV9HQONY9pYjmfjOaaN1arjucS4cWx0yinvbg15Yq+9mPTUU/DUU6XW1RutOqa9MXiPPRh5110MmTwZXn2V/3zhC/zzjDNIbW2l1dRq49nXge4C4AQgFc+nA3sA3f1pk+h+C2Kaw/zdSildDFwMMHLkyDSqyRd8bG9vp9nrGGgc08ZyPBvPMW2slhzPmTPz/Vk7OnL7E59gndNPZ51B1Ti/sCXHdF4su2y+YPOsWQx98EE+dfvtcNxxpZXTauPZpz+FKaUXU0odKaVZwCXkXaqQt7CtVjfrqsCkOfS/DAyNiMFd+iVJao4zzoD778/TiywCl14KFQlz/cInPjH7/XFPOAFuu620clpNn/4kRsRKdc0vA51nwF4P7BQRi0TEmsAI4O/AvcCI4ozWhcknTlyfUkrAbcB/F+/fDai7iZ4kSQ30xBNwzDG19nHHwTrrlFfPQPXDH8KWW+bplGCXXWDy5HJrahHNvGzJ1cBdwAci4tmI2BM4NSIeiogHgS2BgwFSSo8A1wGPAjcB+xVb8mYC+wM3A48B1xXzAhwOHBIR48jH1F3WrM8iSRrAZs2CvffOZ7dCPvPy0EPLrWmgamvLd41Yfvncfv552G23/G80wDXtGLqU0s7ddPcYulJKPwZ+3E3/DcAN3fSPp7bLVpKk5rj4Yrj99jzd1gaXXQaDyzinUACsvDJcfjlst11u33gjnHVWvqfuAObOf0mSejJxIhx2WK192GGw4Ybl1aNs221n30p6xBFw773l1dMCDHSSJHUnpXwP0ddfz+111oEf/ajcmlRz0kmw8cZ5esaMfC/dqVPLralEBjpJkrpz9dXwpz/V2pddBkOGlFePZrfwwvnWYEstldvjx8M++9Tu4DHAGOgkSepq8mQ48MBae7/94OMfL68edW+ttfIxjp2uvRbGjCmvnhIZ6CRJ6uqgg+CVV/L0aqvBySeXW496tuOO+SzkTgccAI880vP8/ZSBTpKkev/7v3l3a6eLLoIllyyvHs3dWWfBuuvm6bfeyiHvrbfKramPGegkSeo0dWo+EaLTN78J22xTXj3qncUWy7tbO49xfOQROPjgcmvqYwY6SZI6HXEEPPdcnl5hBTjzzHLrUe+tvz6cfXatfdFF8Otfl1dPHzPQSZIE8Ne/woUX1trnngvLLVdePZp3e+8NX/tarb3XXjBhQnn19CEDnSRJb72Vf/l32n57+OpXy6tH8ycin/U6fHhuv/Zavj7djBmlltUXDHSSJB17LIwbl6eXXhrOPz+HA1XP0kvn69N13p7t73+Ho44qt6Y+YKCTJA1sY8fCaafV2j/9ab5fqKpr003znSQ6nXoq3HRTefX0AQOdJGngmjED9twTZs3K7S23nH3Xq6rr0ENh661r7V13heefL6+eJjPQSZIGrlNPhQcfzNOLLpqPv3JXa/8waBBcfjm87325PXkyfOMb0NFRbl1NYqCTJA1Mjz0Gxx9fa59wAqy9dnn1qPFWXBF++ctaSP/LX+CUU8qtqUkMdJKkgaejI+9qfeed3N5443y7L/U/n/kMHHlkrf2jH8Gdd5ZXT5MY6CRJA8/558Ndd+XpwYPhsstqZ0Wq/znmGNhiizzd0QE77wyvvlpuTQ1moJMkDSxPPw0/+EGt/cMfwoc+VFo56gODB8NVV8Eyy+T2xIl5C21K5dbVQAY6SdLAkRLssw+88UZur7tuDnTq/1ZfHcaMqbV///u8pbafMNBJkgaOK6+EP/85T0fkXa2LLFJuTeo7X/oSHHBArX3IIfDAA+XV00AGOknSwPDii/Dd79baBx0Em21WXj0qx6mnwoYb5ul33oEdd4Rp08qtqQEMdJKkgeGAA2DKlDw9fDiceGKp5agkQ4bAtdfC4ovn9hNPwP77l1tTAxjoJEn93+9+B7/+da19ySW1X+gaeNZZBy64oNa+/PK8O77CDHSSpP5tyhTYd99ae/fdYautyqtHreGb38y3A+v0ne/krXUVZaCTJPVv3/8+vPBCnn7f++D008utR63jvPNgxIg8/cYb+Xi66dPLrWk+GegkSf3XrbfmM1k7nXde7Vpk0hJLwHXXwcIL5/YDD8Bhh5Vb03wy0EmS+qc33oC99661v/IV2GGH8upRa9pww9m32p5zDvzhD+XVM58MdJKk/unoo2HChDw9dCice2659ah17bcfbL99rb377vluEhVioJMk9T933w1nnVVrn3lmPn5O6k5EvovEaqvl9pQp8PWvw8yZ5dY1Dwx0kqT+Zfr02e/T+dnPwm67lVuTWt+yy+b7vba15fYdd8Dxx5db0zww0EmS+peTT4ZHH83Tiy8OF1+ct8BIc/Pxj8Nxx9XaJ54If/lLefXMAwOdJKn/ePhhOOmkWvukk/JdIaTeOuII+PSn83RKsMsu8NJL5dbUCwY6SVL/0NGRd7XOmJHbm2+eD3aX5kVbG/zyl7DCCrn9wgvwrW/BrFmlljU3BjpJUv9wzjnw97/n6YUXhksvrR0PJc2LlVaCK66otW+8MZ9Y08IMdJKk6hs/Ho48stY+6ihYd93y6lH1bb11vstIpyOOqP3B0IIMdJKkakspX0D4rbdy+0MfgsMPL7cm9Q8nngibbJKnZ86EnXaCqVPLrakHBjpJUrWNGVM7E3HQoHyrr85bOUkLYuGF4eqrYamlcnvCBBg9unZJnBZioJMkVdekSXDoobX2IYfAxhuXV4/6n7XWysdjdrruutnbLcJAJ0mqppRg331ru8De//7ZryEmNcpXv5q3zHU68EAW67ytXIuYp0AXEYs3qxBJkubJb34z+03UL7kEFlusvHrUv515Jqy3Xp5++23WO/54ePPNcmuq06tAFxEfi4hHgceK9ocj4vymViZJUk9eeQX237/WHj0attyyvHrU/y22GFx7LSy6KACLP/00HHxwuTXV6e0WujOBzwOvAKSU/gl8sllFSZI0R4ccUrt6/8orw6mnlluPBob11svXO+x08cVw333l1VOn17tcU0oTu3R1NLgWSZLm7qabZr/o64UXwtJLl1ePBpY994Qdd2TGEkvA//wPfPSjZVcEwOBezjcxIj4GpIhYGDiQYverJEl95vXXYZ99au2ddoIvfrG8ejTwRMBFFzH2xhvZfIcdyq7mXb3dQvdtYD9gFeBZYMOiLUlS3znySPj3v/P0csvB2WeXW48GpqWXZvr73ld2FbPp1Ra6lNLLwC5NrkWSpJ7deSece26tfdZZsOKK5dUjtZDenuV6eUQMrWsvExFjmleWJEl13n4b9tqrdoX+bbaBXdzOIHXq7S7XDVJK/+lspJSmAB9pTkmSJHVx4onw+ON5eokl8okQEeXWJLWQ3ga6QRGxTGcjIpal9ydUSJI0/x54AE45pdY+5RRYffXy6pFaUG9D2enA3yLiN0X7q8CPm1OSJEmFmTPzZSJmzsztj38cvv3tcmuSWlCvttCllK4AvgK8CLwE7JBSunJO74mIMRHxUkQ8XNe3bETcEhFPFs/LFP0REedExLiIeDAiNqp7z27F/E9GxG51/R+NiIeK95wT4bZ3Sep3zjgD7r8/Ty+ySL4p+iBvQy51Ncf/FRGxVPG8LPACcBXwK+CFom9OfgFs3aXvCODWlNII4NaiDbANMKJ4jAYuqFvvMcCmwCbAMXW7fi8o5u18X9d1SZKq7Ikn4Jhjau1jj4UPfKC0cqRWNrc/c64qnu8DxtY9Ots9SindDrzapXt74PJi+nLgS3X9V6TsbmBoRKxEvt3YLSmlV4sTMW4Bti5eWyqldFdKKQFX1C1LklR1s2bB3nvns1sBPvIROPTQcmuSWtgcj6FLKX2h2JX5qZTSvxuwvmEppeeLZT8fEZ0XEFoFqL+12LNF35z6n+2mXxLkSzu8/DJMmADjx+fnzsf48WwxeTIsvDC0teXdV53P9dO97Zuf91RhOfO47CHPPw8TJ8LgwbDQQrM/Dx6c51evrfzHP8Ltt+dGWxtcdlkeT0ndmutJESmlFBG/A5p5s7Lujn9L89Hf/cIjRpN3zzJs2DDa29vno8TemzZtWtPXMdA4pu/V9tZbDHn++Xcfi77wQm36+edp69yy0Q1/LTbeZnN5PUWQ2tryY/Dg2nTxmFXf183r9X2z5vL6/Mw7a27Lql9md/PWvb6glxNZ5KWXGHnhhe+2n9lxRyZMnQp+BywQv0cbq9XGs7dnud4dERunlO5dwPW9GBErFVvnViKfYAF5C9tqdfOtCkwq+kd16W8v+lftZv5upZQuBi4GGDlyZBo1alRPszZEe3s7zV7HQDMgx3TGjHyLoy5b196dnjy57Ao1DyIlYubMfLbm9Olll9NcbW21LZPdba2c2/Qzz8Bbb+VlrbMOa1x2GWsMGVLuZ+oHBuT3aBO12nj2NtBtCXw7Ip4G3iBvIUsppQ3mcX3XA7sBPyme/1DXv39EXEM+AWJqEfpuBk6qOxHic8APUkqvRsTrEbEZcA+wK/CzeaxFKldK8MIL3Ye1CRPy7rtZs+Z/+UsuCWuumR9rrVWbXnNN7hw3ji0+9rG8/FmzoKNj9udm9lV12XNaX0cHb73xBou2teXANnNmDuSdzzNmNO7npgqKMWlIcL30UjDMSXPV20C3zbwBUG31AAASOElEQVQuOCKuJm9dWz4iniWfrfoT4LqI2BP4N/l6dgA3ANsC44A3gd0BiuB2AtC5ZfD4lFLniRbfIZ9JuyhwY/GQWsvUqT0HtgkTagd8z4+FFoI11ug2sLHWWrDssj3u+poxeTKssML8r1vvcc/c/lqfNasW8roGvq59Zb++IMvs6GjcoB5yCHziE41bntSPzTHQRcQQ4NvA2sBDwGUppZm9WXBKaeceXvpMN/MmYL8eljMGeM99Y1NKY4H1e1OL1DTTp+fdQ92FtfHjYcqUBVv+yit3H9bWXDO/5oH21TFoUL6O2iKLlF1Jc6VUC3gLEBjvHz+ejfbfv+xPI1XG3LbQXQ7MAP6PvJVuXeCgZhcltYxZs2DSpG7PFGXChPxa6vF8nLkbOrTnwLbGGu5qUvVE5K3HC3hG6mvt7d6rVZoHcwt066aUPgQQEZcBf29+SVIfSglefbX7rWsTJuStb++8M//LHzIEhg/vPrCtuWYOdJIkLaC5Bbp3j+RNKc307lqqpDffhKef7vlYttdem/9lDxoEq67a48kHvO993qZIktR0cwt0H46Izt92ASxatDvPcl2qqdVJvTFzJjz7bM8nHrzwwoItf/nlew5sq6+eL9ArSVKJ5nanCI+4VvlSYqEpU+Cee7o/lm3ixBzq5tdii/Uc2NZcM1/+Q5KkFtbby5aolaWULxVQ9qUOmvX622+zxYJcz6qtLW9J6+nyHius4MHXkqRKM9A10t/+BjffzJpPPQU33NB3IWhBtk71F8OG9Xy26Kqr5qvPS5LUT/lbrpHuvhuOP541yq6jH5q52GIMHjGi+8A2fHjebSpJ0gBloGukMrcCDRo0f/dMXNDXG7msObx+x733MmrLLcsbX0mSWpiBrpE23RSOOYbxzz7LWiNG9F0wamvr/5fG8Bg3SZJ6ZKBrpE03hU035d/t7aw1p3s6SpIkNVA/36wjSZLU/xnoJEmSKs5AJ0mSVHEGOkmSpIoz0EmSJFWcgU6SJKniDHSSJEkVZ6CTJEmqOAOdJElSxRnoJEmSKs5AJ0mSVHEGOkmSpIoz0EmSJFWcgU6SJKniDHSSJEkVZ6CTJEmqOAOdJElSxRnoJEmSKs5AJ0mSVHEGOkmSpIoz0EmSJFWcgU6SJKniDHSSJEkVZ6CTJEmqOAOdJElSxUVKqewa+tTIkSPT2LFjm7eCiOYtW5IktZYm56iIuC+lNHJu87mFTpIkqeIMdJIkSRVnoGu0lGi/7ba8CdZHwx6OqePZ6g/H1PFs9Ydj2qTxbBEGOkmSpIoz0EmSJFWcgU6SJKniDHSSJEkVZ6CTJEmqOAOdJElSxRnoJEmSKs5AJ0mSVHEGOkmSpIoz0EmSJFWcgU6SJKniSgl0EfF0RDwUEQ9ExNiib9mIuCUiniyelyn6IyLOiYhxEfFgRGxUt5zdivmfjIjdyvgskiRJZStzC92WKaUNU0oji/YRwK0ppRHArUUbYBtgRPEYDVwAOQACxwCbApsAx3SGQEmSpIGklXa5bg9cXkxfDnyprv+KlN0NDI2IlYDPA7eklF5NKU0BbgG27uuiJUmSylZWoEvAnyPivogYXfQNSyk9D1A8r1j0rwJMrHvvs0VfT/2SJEkDyuCS1rtFSmlSRKwI3BIRj89h3uimL82h/70LyKFxNMCwYcNob2+fx3LnzbRp05q+joHGMW0sx7PxHNPGcjwbzzFtrFYbz1ICXUppUvH8UkT8jnwM3IsRsVJK6flil+pLxezPAqvVvX1VYFLRP6pLf3sP67sYuBhg5MiRadSoUd3N1jDt7e00ex0DjWPaWI5n4zmmjeV4Np5j2litNp59vss1IhaPiCU7p4HPAQ8D1wOdZ6ruBvyhmL4e2LU423UzYGqxS/Zm4HMRsUxxMsTnij5JkqQBpYwtdMOA30VE5/qvSindFBH3AtdFxJ7Av4GvFvPfAGwLjAPeBHYHSCm9GhEnAPcW8x2fUnq17z6GJElSa+jzQJdSGg98uJv+V4DPdNOfgP16WNYYYEyja5QkSaqSVrpsiSRJkuaDgU6SJKniDHSSJEkVZ6CTJEmqOAOdJElSxRnoJEmSKs5AJ0mSVHEGOkmSpIoz0EmSJFWcgU6SJKniDHSSJEkVZ6CTJEmqOAOdJElSxRnoJEmSKs5AJ0mSVHEGOkmSpIoz0EmSJFWcgU6SJKniDHSSJEkVZ6CTJEmqOAOdJElSxRnoJEmSKs5AJ0mSVHEGOkmSpIoz0EmSJFWcgU6SJKniDHSSJEkVZ6CTJEmqOAOdJElSxRnoJEmSKs5AJ0mSVHEGOkmSpIoz0EmSJFWcgU6SJKniDHSSJEkVZ6CTJEmqOAOdJElSxRnoJEmSKs5AJ0mSVHEGOkmSpIoz0EmSJFWcgU6SJKniDHSSJEkVZ6CTJEmqOAOdJElSxRnoJEmSKs5AJ0mSVHEGOkmSpIoz0EmSJFWcgU6SJKniBpddQL9y551w++2sPn483HVX7ovIj87pTt31dZ1/bn29WWarr7uX86/w6KPw4ou8R0+1zWm+nubpzXKapY/Xt/zDD8OUKX23wpT6bl1lrI9iTF95pc/X2185no1Xypj29XdpH65z+YcfhpkzYaut+mR9c1P5QBcRWwNnA23ApSmln5RWzDe+AU8/zVqlFdB/rVd2Af3M+mUX0A85po3leDaeY9pY6wMMGgQdHWWXAlR8l2tEtAHnAdsA6wI7R8S6pRX08sulrVqSJPWxWbPKruBdlQ50wCbAuJTS+JTSO8A1wPalVVPCbh5JkqSqB7pVgIl17WeLvnJsumlpq5YkSX1sUOvEqKofQ9fdkY/v2UwWEaOB0QDDhg2jvb29KcWs/KEPsdY995BSIuZyUGbqzcH8vTyw8z3L6u69rbqsXi5vVkoMmtt8XbeQdrPFNHqzFbW7eZq4rF4tp8HLSrNmEd18EaWeTh7pZuy7nbeHf6Omz9uLk14WeN56RX99rbNSYlBvv9x789l7Mf8CL3teDx6f28/B/C67m3k7Ojpoa2vrec9HXf+7P/cNnHe2/0vNmre7GrurtUHz9vi7yb1L8yWlxNurrMI/m5Qp5lWkCv9DRsTmwLEppc8X7R8ApJRO7uk9I0eOTGPHjm1qXe3t7YwaNaqp6xhoHNPGcjwbzzFtLMez8RzTxuqr8YyI+1JKI+c2X+tsK5w/9wIjImLNiFgY2Am4vuSaJEmS+lSld7mmlGZGxP7AzeTLloxJKT1SclmSJEl9qtKBDiCldANwQ9l1SJIklaXqu1wlSZIGPAOdJElSxRnoJEmSKs5AJ0mSVHEGOkmSpIoz0EmSJFWcgU6SJKniKn3rr/kREZOBZ5q8muWBl5u8joHGMW0sx7PxHNPGcjwbzzFtrL4azzVSSivMbaYBF+j6QkSM7c1919R7jmljOZ6N55g2luPZeI5pY7XaeLrLVZIkqeIMdJIkSRVnoGuOi8suoB9yTBvL8Ww8x7SxHM/Gc0wbq6XG02PoJEmSKs4tdJIkSRVnoJtHEZEi4sq69uCImBwRfyyzrv4gIqaVXUN/ERFfLn5WP1h2Lf1FRBwZEY9ExIMR8UBEbFp2TVUXEatGxB8i4smIeCoizo6Ihecw/3cjYrG+rLEqiv/vp9e1vxcRx5ZYUuVFREfxf/2RiPhnRBwSES2bm1q2sBb2BrB+RCxatD8LPFdiPVJ3dgbuAHYqu5D+ICI2B74AbJRS2gDYCphYblXVFhEB/Bb4fUppBLAOsATw4zm87buAga5704EdImL5sgvpR95KKW2YUlqP/Lt+W+CYkmvqkYFu/twIbFdM7wxc3flCRGwSEX+LiH8Uzx8o+v8vIjasm+/OiNigT6uugIgYVb+1MyLOjYhvFdNPR8RxEXF/RDzk1qfuRcQSwBbAnhSBbi7jum1EPB4Rd0TEOW5t7tZKwMsppekAKaWXU0qTIuKjEfHXiLgvIm6OiJUAIqI9Is4qvgMejohNSq2+NX0aeDul9HOAlFIHcDCwR0QsHhGnFf/PH4yIAyLiQGBl4LaIuK3EulvVTPJB+gd3fSEi1oiIW4uxvDUiVo+IpYvv1EHFPItFxMSIWKivC6+ClNJLwGhg/8jaIuKnEXFvMa77dM4bEYcVP7v/jIif9FWNBrr5cw2wU0QMATYA7ql77XHgkymljwA/Ak4q+i8FvgUQEesAi6SUHuyzivuPl1NKGwEXAN8ru5gW9SXgppTSE8CrEbFRTzMWP8MXAduklD4OzPVq5APUn4HVIuKJiDg/Ij5V/OL7GfDfKaWPAmOYfevS4imljwH7Fq9pdusB99V3pJReA/4N7AWsCXyk2CL6q5TSOcAkYMuU0pZ9XWxFnAfsEhFLd+k/F7iicyyBc1JKU4F/Ap8q5vkicHNKaUafVVsxKaXx5Ny0IvkP5qkppY2BjYG9I2LNiNiG/B28aUrpw8CpfVWfgW4+FEFsOHnr3A1dXl4a+HVEPAycSf7SAvg18IXil8AewC/6pNj+57fF833kfwO9187kPzoonneew7wfBManlCYU7avnMO+AlVKaBnyU/Bf6ZOBaYB9gfeCWiHgAOApYte5tVxfvvR1YKiKG9mnRrS+A7i6zEMAngQtTSjMBUkqv9mVhVVUE4iuAA7u8tDlwVTF9JfDxYvpaYMdieqeirTmL4vlzwK7F//17gOWAEeTDMX6eUnoT+vZnd3Bfragfuh44DRhF/ofsdAJwW0rpyxExHGgHSCm9GRG3ANsDXwNa5nYhLWYms/+hMaTL69OL5w78+X2PiFiOvCtr/YhIQBv5l+b1dD+ugXql2CXYDrRHxEPAfsAjKaXNe3rLXNoD3SPAV+o7ImIpYDVgPI7X/DoLuB/4+Rzm6Rzb64GTI2JZ8h8sf2lybZUWEWuRf/e8RP7uPCCldHOXebampJ9dt9DNvzHA8Smlh7r0L03tJIlvdXntUuAc4F7/4uzRM8C6EbFIsdvgM2UXVDH/Td61skZKaXhKaTWgc+tbd+P6OLBW8ccH1P5aV52I+EBEjKjr2hB4DFihOGGCiFgoItarm2fHov/j5F0zU/us4Gq4FVgsInYFiIg24HTy3os/A9+OiMHFa8sW73kdWLLvS62O4nfLdeRdgp3+Ru0EqV3IJ0x1bnn+O3A28MfijxZ1IyJWAC4Ezk35Ar43A9/pPOYwItaJiMXJP7t7RHE2dt3PbtO5hWM+pZSeJf8n6OpU4PKIOIQuf+2klO6LiNeY819OA1LxxT09pTQxIq4DHgSeBP5RbmWVszPQ9SDc/wG+Tv6Sn21cU0pvRcS+wE0R8TL5y13vtQTws2K36UxgHHn368XAOUVIHkzeOvJI8Z4pEfE3YCnyYRaqk1JKEfFl4PyIOJq8geEG4IfkrSDrAA9GxAzgEvJxYBcDN0bE8x5HN0enA/vXtQ8ExkTE98mHDOxe99q15EOCRvVZddWxaLFLdSHy//srgTOK1y4lH/Zzf0QEeVy/lFK6KfIJkGMj4h1qP9NN550i+lBErEzeZfPBlNKskstpKRHxYeCSlJJnA/axiFgipTSt+FI6D3gypXRm2XVVWUS0A99LKY0tuxZJA4O7XPtIsVvhHuBIw9zsIuLb5APIjyq7lgFq7+Kv0EfIhwxcVHI9kqR55BY6SZKkinMLnSRJUsUZ6CRJkirOQCdJklRxBjpJKkREiogr69qDI2Ly/N7fNiKGFpeF6WyPmt9lSdKcGOgkqeYN8l02Fi3an6V2ofD5MZR8L1dJaioDnSTN7kZgu2J6Z+rubxsRy0bE7yPiwYi4OyI2KPqPjYgxEdEeEeMjovNemj8B3h8RD0TET4u+JSLiNxHxeET8qrj+nyQtEAOdJM3uGmCniBgCbEC+fmSn44B/pJQ2IF/9/Yq61z4IfB7YBDimuCXQEcBTKaUNU0rfL+b7CPBdYF1gLWCLZn4YSQODgU6S6qSUHiTf0mdn8m176n2cfPsfUkp/AZYrbvsF8KeU0vSU0svkm3cP62EVf08pPVtcYPyBYl2StEC8l6skvdf1wGnk+1suV9ff3e7RzquzT6/r66Dn79fezidJveYWOkl6rzHA8Smlh7r03w7sAvmMVeDllNJrc1jO68CSTalQkur4l6EkdZFSehY4u5uXjgV+HhEPAm8Cu81lOa9ExJ0R8TD5ZIs/NbpWSQLv5SpJklR57nKVJEmqOAOdJElSxRnoJEmSKs5AJ0mSVHEGOkmSpIoz0EmSJFWcgU6SJKniDHSSJEkV9/8BF0eIUjInpXAAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 720x360 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "\n",
    "# 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, ['May','Jun','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
}