Mean_Median_Prices.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 33,
   "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>Date</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>10018</th>\n",
       "      <td>3917</td>\n",
       "      <td>3917</td>\n",
       "      <td>3917</td>\n",
       "      <td>3909</td>\n",
       "      <td>3917</td>\n",
       "      <td>3917</td>\n",
       "      <td>3917</td>\n",
       "      <td>3917</td>\n",
       "      <td>3917</td>\n",
       "      <td>3917</td>\n",
       "      <td>3917</td>\n",
       "      <td>3917</td>\n",
       "      <td>3004</td>\n",
       "      <td>3001</td>\n",
       "      <td>3917</td>\n",
       "      <td>3917</td>\n",
       "      <td>3917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11218</th>\n",
       "      <td>4007</td>\n",
       "      <td>4007</td>\n",
       "      <td>4007</td>\n",
       "      <td>4006</td>\n",
       "      <td>4007</td>\n",
       "      <td>4007</td>\n",
       "      <td>4007</td>\n",
       "      <td>4007</td>\n",
       "      <td>4007</td>\n",
       "      <td>4007</td>\n",
       "      <td>4007</td>\n",
       "      <td>4007</td>\n",
       "      <td>3159</td>\n",
       "      <td>3158</td>\n",
       "      <td>4007</td>\n",
       "      <td>4007</td>\n",
       "      <td>4007</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10035</th>\n",
       "      <td>4110</td>\n",
       "      <td>4110</td>\n",
       "      <td>4110</td>\n",
       "      <td>4107</td>\n",
       "      <td>4110</td>\n",
       "      <td>4110</td>\n",
       "      <td>4110</td>\n",
       "      <td>4110</td>\n",
       "      <td>4110</td>\n",
       "      <td>4110</td>\n",
       "      <td>4110</td>\n",
       "      <td>4110</td>\n",
       "      <td>3236</td>\n",
       "      <td>3235</td>\n",
       "      <td>4110</td>\n",
       "      <td>4110</td>\n",
       "      <td>4110</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11101</th>\n",
       "      <td>4373</td>\n",
       "      <td>4373</td>\n",
       "      <td>4373</td>\n",
       "      <td>4371</td>\n",
       "      <td>4373</td>\n",
       "      <td>4373</td>\n",
       "      <td>4373</td>\n",
       "      <td>4373</td>\n",
       "      <td>4373</td>\n",
       "      <td>4373</td>\n",
       "      <td>4373</td>\n",
       "      <td>4373</td>\n",
       "      <td>3572</td>\n",
       "      <td>3571</td>\n",
       "      <td>4373</td>\n",
       "      <td>4373</td>\n",
       "      <td>4373</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10017</th>\n",
       "      <td>4399</td>\n",
       "      <td>4399</td>\n",
       "      <td>4399</td>\n",
       "      <td>4393</td>\n",
       "      <td>4399</td>\n",
       "      <td>4399</td>\n",
       "      <td>4399</td>\n",
       "      <td>4399</td>\n",
       "      <td>4399</td>\n",
       "      <td>4399</td>\n",
       "      <td>4399</td>\n",
       "      <td>4399</td>\n",
       "      <td>2823</td>\n",
       "      <td>2821</td>\n",
       "      <td>4399</td>\n",
       "      <td>4399</td>\n",
       "      <td>4399</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10010</th>\n",
       "      <td>4480</td>\n",
       "      <td>4480</td>\n",
       "      <td>4480</td>\n",
       "      <td>4472</td>\n",
       "      <td>4480</td>\n",
       "      <td>4480</td>\n",
       "      <td>4480</td>\n",
       "      <td>4480</td>\n",
       "      <td>4480</td>\n",
       "      <td>4480</td>\n",
       "      <td>4480</td>\n",
       "      <td>4480</td>\n",
       "      <td>3343</td>\n",
       "      <td>3341</td>\n",
       "      <td>4480</td>\n",
       "      <td>4480</td>\n",
       "      <td>4480</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10030</th>\n",
       "      <td>4526</td>\n",
       "      <td>4526</td>\n",
       "      <td>4526</td>\n",
       "      <td>4522</td>\n",
       "      <td>4526</td>\n",
       "      <td>4526</td>\n",
       "      <td>4526</td>\n",
       "      <td>4526</td>\n",
       "      <td>4526</td>\n",
       "      <td>4526</td>\n",
       "      <td>4526</td>\n",
       "      <td>4526</td>\n",
       "      <td>3875</td>\n",
       "      <td>3874</td>\n",
       "      <td>4526</td>\n",
       "      <td>4526</td>\n",
       "      <td>4526</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11106</th>\n",
       "      <td>4543</td>\n",
       "      <td>4543</td>\n",
       "      <td>4543</td>\n",
       "      <td>4533</td>\n",
       "      <td>4543</td>\n",
       "      <td>4543</td>\n",
       "      <td>4543</td>\n",
       "      <td>4543</td>\n",
       "      <td>4543</td>\n",
       "      <td>4543</td>\n",
       "      <td>4543</td>\n",
       "      <td>4543</td>\n",
       "      <td>3663</td>\n",
       "      <td>3660</td>\n",
       "      <td>4543</td>\n",
       "      <td>4543</td>\n",
       "      <td>4543</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11231</th>\n",
       "      <td>4603</td>\n",
       "      <td>4603</td>\n",
       "      <td>4603</td>\n",
       "      <td>4601</td>\n",
       "      <td>4603</td>\n",
       "      <td>4603</td>\n",
       "      <td>4603</td>\n",
       "      <td>4603</td>\n",
       "      <td>4603</td>\n",
       "      <td>4603</td>\n",
       "      <td>4603</td>\n",
       "      <td>4603</td>\n",
       "      <td>3734</td>\n",
       "      <td>3730</td>\n",
       "      <td>4603</td>\n",
       "      <td>4603</td>\n",
       "      <td>4603</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11103</th>\n",
       "      <td>4704</td>\n",
       "      <td>4700</td>\n",
       "      <td>4704</td>\n",
       "      <td>4697</td>\n",
       "      <td>4704</td>\n",
       "      <td>4704</td>\n",
       "      <td>4704</td>\n",
       "      <td>4704</td>\n",
       "      <td>4704</td>\n",
       "      <td>4704</td>\n",
       "      <td>4704</td>\n",
       "      <td>4704</td>\n",
       "      <td>3668</td>\n",
       "      <td>3662</td>\n",
       "      <td>4704</td>\n",
       "      <td>4704</td>\n",
       "      <td>4704</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10028</th>\n",
       "      <td>5261</td>\n",
       "      <td>5259</td>\n",
       "      <td>5261</td>\n",
       "      <td>5259</td>\n",
       "      <td>5261</td>\n",
       "      <td>5261</td>\n",
       "      <td>5261</td>\n",
       "      <td>5261</td>\n",
       "      <td>5261</td>\n",
       "      <td>5261</td>\n",
       "      <td>5261</td>\n",
       "      <td>5261</td>\n",
       "      <td>4053</td>\n",
       "      <td>4045</td>\n",
       "      <td>5261</td>\n",
       "      <td>5261</td>\n",
       "      <td>5261</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11385</th>\n",
       "      <td>5276</td>\n",
       "      <td>5276</td>\n",
       "      <td>5276</td>\n",
       "      <td>5273</td>\n",
       "      <td>5276</td>\n",
       "      <td>5276</td>\n",
       "      <td>5276</td>\n",
       "      <td>5276</td>\n",
       "      <td>5276</td>\n",
       "      <td>5276</td>\n",
       "      <td>5276</td>\n",
       "      <td>5276</td>\n",
       "      <td>4003</td>\n",
       "      <td>3998</td>\n",
       "      <td>5276</td>\n",
       "      <td>5276</td>\n",
       "      <td>5276</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10022</th>\n",
       "      <td>5393</td>\n",
       "      <td>5393</td>\n",
       "      <td>5393</td>\n",
       "      <td>5386</td>\n",
       "      <td>5393</td>\n",
       "      <td>5393</td>\n",
       "      <td>5393</td>\n",
       "      <td>5393</td>\n",
       "      <td>5393</td>\n",
       "      <td>5393</td>\n",
       "      <td>5393</td>\n",
       "      <td>5393</td>\n",
       "      <td>3974</td>\n",
       "      <td>3971</td>\n",
       "      <td>5393</td>\n",
       "      <td>5393</td>\n",
       "      <td>5393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10128</th>\n",
       "      <td>5644</td>\n",
       "      <td>5644</td>\n",
       "      <td>5644</td>\n",
       "      <td>5638</td>\n",
       "      <td>5644</td>\n",
       "      <td>5644</td>\n",
       "      <td>5644</td>\n",
       "      <td>5644</td>\n",
       "      <td>5644</td>\n",
       "      <td>5644</td>\n",
       "      <td>5644</td>\n",
       "      <td>5644</td>\n",
       "      <td>4389</td>\n",
       "      <td>4384</td>\n",
       "      <td>5644</td>\n",
       "      <td>5644</td>\n",
       "      <td>5644</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11207</th>\n",
       "      <td>5741</td>\n",
       "      <td>5741</td>\n",
       "      <td>5741</td>\n",
       "      <td>5738</td>\n",
       "      <td>5741</td>\n",
       "      <td>5741</td>\n",
       "      <td>5741</td>\n",
       "      <td>5741</td>\n",
       "      <td>5741</td>\n",
       "      <td>5741</td>\n",
       "      <td>5741</td>\n",
       "      <td>5741</td>\n",
       "      <td>4637</td>\n",
       "      <td>4633</td>\n",
       "      <td>5741</td>\n",
       "      <td>5741</td>\n",
       "      <td>5741</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10013</th>\n",
       "      <td>6093</td>\n",
       "      <td>6093</td>\n",
       "      <td>6093</td>\n",
       "      <td>6086</td>\n",
       "      <td>6093</td>\n",
       "      <td>6093</td>\n",
       "      <td>6093</td>\n",
       "      <td>6093</td>\n",
       "      <td>6093</td>\n",
       "      <td>6093</td>\n",
       "      <td>6093</td>\n",
       "      <td>6093</td>\n",
       "      <td>4608</td>\n",
       "      <td>4602</td>\n",
       "      <td>6093</td>\n",
       "      <td>6093</td>\n",
       "      <td>6093</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10001</th>\n",
       "      <td>6172</td>\n",
       "      <td>6172</td>\n",
       "      <td>6172</td>\n",
       "      <td>6168</td>\n",
       "      <td>6172</td>\n",
       "      <td>6172</td>\n",
       "      <td>6172</td>\n",
       "      <td>6172</td>\n",
       "      <td>6172</td>\n",
       "      <td>6172</td>\n",
       "      <td>6172</td>\n",
       "      <td>6172</td>\n",
       "      <td>4676</td>\n",
       "      <td>4672</td>\n",
       "      <td>6172</td>\n",
       "      <td>6172</td>\n",
       "      <td>6172</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11201</th>\n",
       "      <td>6263</td>\n",
       "      <td>6263</td>\n",
       "      <td>6263</td>\n",
       "      <td>6260</td>\n",
       "      <td>6263</td>\n",
       "      <td>6263</td>\n",
       "      <td>6263</td>\n",
       "      <td>6263</td>\n",
       "      <td>6263</td>\n",
       "      <td>6263</td>\n",
       "      <td>6263</td>\n",
       "      <td>6263</td>\n",
       "      <td>4780</td>\n",
       "      <td>4778</td>\n",
       "      <td>6263</td>\n",
       "      <td>6263</td>\n",
       "      <td>6263</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10032</th>\n",
       "      <td>6344</td>\n",
       "      <td>6344</td>\n",
       "      <td>6344</td>\n",
       "      <td>6328</td>\n",
       "      <td>6344</td>\n",
       "      <td>6344</td>\n",
       "      <td>6344</td>\n",
       "      <td>6344</td>\n",
       "      <td>6344</td>\n",
       "      <td>6344</td>\n",
       "      <td>6344</td>\n",
       "      <td>6344</td>\n",
       "      <td>4942</td>\n",
       "      <td>4941</td>\n",
       "      <td>6344</td>\n",
       "      <td>6344</td>\n",
       "      <td>6344</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10026</th>\n",
       "      <td>6374</td>\n",
       "      <td>6362</td>\n",
       "      <td>6374</td>\n",
       "      <td>6368</td>\n",
       "      <td>6374</td>\n",
       "      <td>6374</td>\n",
       "      <td>6374</td>\n",
       "      <td>6374</td>\n",
       "      <td>6374</td>\n",
       "      <td>6374</td>\n",
       "      <td>6374</td>\n",
       "      <td>6374</td>\n",
       "      <td>5362</td>\n",
       "      <td>5356</td>\n",
       "      <td>6374</td>\n",
       "      <td>6374</td>\n",
       "      <td>6374</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10024</th>\n",
       "      <td>6386</td>\n",
       "      <td>6386</td>\n",
       "      <td>6386</td>\n",
       "      <td>6375</td>\n",
       "      <td>6386</td>\n",
       "      <td>6386</td>\n",
       "      <td>6386</td>\n",
       "      <td>6386</td>\n",
       "      <td>6386</td>\n",
       "      <td>6386</td>\n",
       "      <td>6386</td>\n",
       "      <td>6386</td>\n",
       "      <td>5088</td>\n",
       "      <td>5086</td>\n",
       "      <td>6386</td>\n",
       "      <td>6386</td>\n",
       "      <td>6386</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10023</th>\n",
       "      <td>6389</td>\n",
       "      <td>6386</td>\n",
       "      <td>6389</td>\n",
       "      <td>6386</td>\n",
       "      <td>6389</td>\n",
       "      <td>6389</td>\n",
       "      <td>6389</td>\n",
       "      <td>6389</td>\n",
       "      <td>6389</td>\n",
       "      <td>6389</td>\n",
       "      <td>6389</td>\n",
       "      <td>6389</td>\n",
       "      <td>4897</td>\n",
       "      <td>4895</td>\n",
       "      <td>6389</td>\n",
       "      <td>6389</td>\n",
       "      <td>6389</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11213</th>\n",
       "      <td>6482</td>\n",
       "      <td>6482</td>\n",
       "      <td>6482</td>\n",
       "      <td>6471</td>\n",
       "      <td>6482</td>\n",
       "      <td>6482</td>\n",
       "      <td>6482</td>\n",
       "      <td>6482</td>\n",
       "      <td>6482</td>\n",
       "      <td>6482</td>\n",
       "      <td>6482</td>\n",
       "      <td>6482</td>\n",
       "      <td>5073</td>\n",
       "      <td>5070</td>\n",
       "      <td>6482</td>\n",
       "      <td>6482</td>\n",
       "      <td>6482</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11217</th>\n",
       "      <td>7225</td>\n",
       "      <td>7225</td>\n",
       "      <td>7225</td>\n",
       "      <td>7217</td>\n",
       "      <td>7225</td>\n",
       "      <td>7225</td>\n",
       "      <td>7225</td>\n",
       "      <td>7225</td>\n",
       "      <td>7225</td>\n",
       "      <td>7225</td>\n",
       "      <td>7225</td>\n",
       "      <td>7225</td>\n",
       "      <td>5888</td>\n",
       "      <td>5882</td>\n",
       "      <td>7225</td>\n",
       "      <td>7225</td>\n",
       "      <td>7225</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11225</th>\n",
       "      <td>7938</td>\n",
       "      <td>7938</td>\n",
       "      <td>7938</td>\n",
       "      <td>7932</td>\n",
       "      <td>7938</td>\n",
       "      <td>7938</td>\n",
       "      <td>7938</td>\n",
       "      <td>7938</td>\n",
       "      <td>7938</td>\n",
       "      <td>7938</td>\n",
       "      <td>7938</td>\n",
       "      <td>7938</td>\n",
       "      <td>6333</td>\n",
       "      <td>6329</td>\n",
       "      <td>7938</td>\n",
       "      <td>7938</td>\n",
       "      <td>7938</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11226</th>\n",
       "      <td>8368</td>\n",
       "      <td>8368</td>\n",
       "      <td>8368</td>\n",
       "      <td>8363</td>\n",
       "      <td>8368</td>\n",
       "      <td>8368</td>\n",
       "      <td>8368</td>\n",
       "      <td>8368</td>\n",
       "      <td>8368</td>\n",
       "      <td>8368</td>\n",
       "      <td>8368</td>\n",
       "      <td>8368</td>\n",
       "      <td>6653</td>\n",
       "      <td>6646</td>\n",
       "      <td>8368</td>\n",
       "      <td>8368</td>\n",
       "      <td>8368</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11205</th>\n",
       "      <td>8986</td>\n",
       "      <td>8986</td>\n",
       "      <td>8986</td>\n",
       "      <td>8980</td>\n",
       "      <td>8986</td>\n",
       "      <td>8986</td>\n",
       "      <td>8986</td>\n",
       "      <td>8986</td>\n",
       "      <td>8986</td>\n",
       "      <td>8986</td>\n",
       "      <td>8986</td>\n",
       "      <td>8986</td>\n",
       "      <td>7208</td>\n",
       "      <td>7204</td>\n",
       "      <td>8986</td>\n",
       "      <td>8986</td>\n",
       "      <td>8986</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10029</th>\n",
       "      <td>9387</td>\n",
       "      <td>9387</td>\n",
       "      <td>9387</td>\n",
       "      <td>9374</td>\n",
       "      <td>9387</td>\n",
       "      <td>9387</td>\n",
       "      <td>9387</td>\n",
       "      <td>9387</td>\n",
       "      <td>9387</td>\n",
       "      <td>9387</td>\n",
       "      <td>9387</td>\n",
       "      <td>9387</td>\n",
       "      <td>7975</td>\n",
       "      <td>7968</td>\n",
       "      <td>9387</td>\n",
       "      <td>9387</td>\n",
       "      <td>9387</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10014</th>\n",
       "      <td>9556</td>\n",
       "      <td>9556</td>\n",
       "      <td>9556</td>\n",
       "      <td>9554</td>\n",
       "      <td>9556</td>\n",
       "      <td>9556</td>\n",
       "      <td>9556</td>\n",
       "      <td>9556</td>\n",
       "      <td>9556</td>\n",
       "      <td>9556</td>\n",
       "      <td>9556</td>\n",
       "      <td>9556</td>\n",
       "      <td>7642</td>\n",
       "      <td>7638</td>\n",
       "      <td>9556</td>\n",
       "      <td>9556</td>\n",
       "      <td>9556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10012</th>\n",
       "      <td>9830</td>\n",
       "      <td>9818</td>\n",
       "      <td>9830</td>\n",
       "      <td>9825</td>\n",
       "      <td>9830</td>\n",
       "      <td>9830</td>\n",
       "      <td>9830</td>\n",
       "      <td>9830</td>\n",
       "      <td>9830</td>\n",
       "      <td>9830</td>\n",
       "      <td>9830</td>\n",
       "      <td>9830</td>\n",
       "      <td>7821</td>\n",
       "      <td>7817</td>\n",
       "      <td>9830</td>\n",
       "      <td>9830</td>\n",
       "      <td>9830</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11233</th>\n",
       "      <td>10034</td>\n",
       "      <td>10034</td>\n",
       "      <td>10034</td>\n",
       "      <td>10026</td>\n",
       "      <td>10034</td>\n",
       "      <td>10034</td>\n",
       "      <td>10034</td>\n",
       "      <td>10034</td>\n",
       "      <td>10034</td>\n",
       "      <td>10034</td>\n",
       "      <td>10034</td>\n",
       "      <td>10034</td>\n",
       "      <td>8503</td>\n",
       "      <td>8498</td>\n",
       "      <td>10034</td>\n",
       "      <td>10034</td>\n",
       "      <td>10034</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11249</th>\n",
       "      <td>10095</td>\n",
       "      <td>10087</td>\n",
       "      <td>10095</td>\n",
       "      <td>10065</td>\n",
       "      <td>10095</td>\n",
       "      <td>10095</td>\n",
       "      <td>10095</td>\n",
       "      <td>10095</td>\n",
       "      <td>10095</td>\n",
       "      <td>10095</td>\n",
       "      <td>10095</td>\n",
       "      <td>10095</td>\n",
       "      <td>7921</td>\n",
       "      <td>7914</td>\n",
       "      <td>10095</td>\n",
       "      <td>10095</td>\n",
       "      <td>10095</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10011</th>\n",
       "      <td>10663</td>\n",
       "      <td>10663</td>\n",
       "      <td>10663</td>\n",
       "      <td>10660</td>\n",
       "      <td>10663</td>\n",
       "      <td>10663</td>\n",
       "      <td>10663</td>\n",
       "      <td>10663</td>\n",
       "      <td>10663</td>\n",
       "      <td>10663</td>\n",
       "      <td>10663</td>\n",
       "      <td>10663</td>\n",
       "      <td>8652</td>\n",
       "      <td>8647</td>\n",
       "      <td>10663</td>\n",
       "      <td>10663</td>\n",
       "      <td>10663</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10031</th>\n",
       "      <td>10718</td>\n",
       "      <td>10718</td>\n",
       "      <td>10718</td>\n",
       "      <td>10710</td>\n",
       "      <td>10718</td>\n",
       "      <td>10718</td>\n",
       "      <td>10718</td>\n",
       "      <td>10718</td>\n",
       "      <td>10718</td>\n",
       "      <td>10718</td>\n",
       "      <td>10718</td>\n",
       "      <td>10718</td>\n",
       "      <td>8532</td>\n",
       "      <td>8524</td>\n",
       "      <td>10718</td>\n",
       "      <td>10718</td>\n",
       "      <td>10718</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10016</th>\n",
       "      <td>10730</td>\n",
       "      <td>10730</td>\n",
       "      <td>10730</td>\n",
       "      <td>10723</td>\n",
       "      <td>10730</td>\n",
       "      <td>10730</td>\n",
       "      <td>10730</td>\n",
       "      <td>10730</td>\n",
       "      <td>10730</td>\n",
       "      <td>10730</td>\n",
       "      <td>10730</td>\n",
       "      <td>10730</td>\n",
       "      <td>7838</td>\n",
       "      <td>7835</td>\n",
       "      <td>10730</td>\n",
       "      <td>10730</td>\n",
       "      <td>10730</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10027</th>\n",
       "      <td>10773</td>\n",
       "      <td>10773</td>\n",
       "      <td>10773</td>\n",
       "      <td>10763</td>\n",
       "      <td>10773</td>\n",
       "      <td>10773</td>\n",
       "      <td>10773</td>\n",
       "      <td>10773</td>\n",
       "      <td>10773</td>\n",
       "      <td>10773</td>\n",
       "      <td>10773</td>\n",
       "      <td>10773</td>\n",
       "      <td>8686</td>\n",
       "      <td>8676</td>\n",
       "      <td>10773</td>\n",
       "      <td>10773</td>\n",
       "      <td>10773</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11215</th>\n",
       "      <td>11134</td>\n",
       "      <td>11134</td>\n",
       "      <td>11134</td>\n",
       "      <td>11126</td>\n",
       "      <td>11134</td>\n",
       "      <td>11134</td>\n",
       "      <td>11134</td>\n",
       "      <td>11134</td>\n",
       "      <td>11134</td>\n",
       "      <td>11134</td>\n",
       "      <td>11134</td>\n",
       "      <td>11134</td>\n",
       "      <td>9015</td>\n",
       "      <td>9008</td>\n",
       "      <td>11134</td>\n",
       "      <td>11134</td>\n",
       "      <td>11134</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10036</th>\n",
       "      <td>11161</td>\n",
       "      <td>11161</td>\n",
       "      <td>11161</td>\n",
       "      <td>11155</td>\n",
       "      <td>11161</td>\n",
       "      <td>11161</td>\n",
       "      <td>11161</td>\n",
       "      <td>11161</td>\n",
       "      <td>11161</td>\n",
       "      <td>11161</td>\n",
       "      <td>11161</td>\n",
       "      <td>11161</td>\n",
       "      <td>8676</td>\n",
       "      <td>8674</td>\n",
       "      <td>11161</td>\n",
       "      <td>11161</td>\n",
       "      <td>11161</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11237</th>\n",
       "      <td>12892</td>\n",
       "      <td>12891</td>\n",
       "      <td>12892</td>\n",
       "      <td>12881</td>\n",
       "      <td>12892</td>\n",
       "      <td>12892</td>\n",
       "      <td>12892</td>\n",
       "      <td>12892</td>\n",
       "      <td>12892</td>\n",
       "      <td>12892</td>\n",
       "      <td>12892</td>\n",
       "      <td>12892</td>\n",
       "      <td>9945</td>\n",
       "      <td>9938</td>\n",
       "      <td>12892</td>\n",
       "      <td>12892</td>\n",
       "      <td>12892</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10025</th>\n",
       "      <td>13206</td>\n",
       "      <td>13183</td>\n",
       "      <td>13206</td>\n",
       "      <td>13197</td>\n",
       "      <td>13206</td>\n",
       "      <td>13206</td>\n",
       "      <td>13206</td>\n",
       "      <td>13206</td>\n",
       "      <td>13206</td>\n",
       "      <td>13206</td>\n",
       "      <td>13206</td>\n",
       "      <td>13206</td>\n",
       "      <td>9706</td>\n",
       "      <td>9698</td>\n",
       "      <td>13206</td>\n",
       "      <td>13206</td>\n",
       "      <td>13206</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11222</th>\n",
       "      <td>13760</td>\n",
       "      <td>13756</td>\n",
       "      <td>13760</td>\n",
       "      <td>13749</td>\n",
       "      <td>13760</td>\n",
       "      <td>13760</td>\n",
       "      <td>13760</td>\n",
       "      <td>13760</td>\n",
       "      <td>13760</td>\n",
       "      <td>13760</td>\n",
       "      <td>13760</td>\n",
       "      <td>13760</td>\n",
       "      <td>10601</td>\n",
       "      <td>10590</td>\n",
       "      <td>13760</td>\n",
       "      <td>13760</td>\n",
       "      <td>13760</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10003</th>\n",
       "      <td>14217</td>\n",
       "      <td>14193</td>\n",
       "      <td>14217</td>\n",
       "      <td>14208</td>\n",
       "      <td>14217</td>\n",
       "      <td>14217</td>\n",
       "      <td>14217</td>\n",
       "      <td>14217</td>\n",
       "      <td>14217</td>\n",
       "      <td>14217</td>\n",
       "      <td>14217</td>\n",
       "      <td>14217</td>\n",
       "      <td>11086</td>\n",
       "      <td>11078</td>\n",
       "      <td>14217</td>\n",
       "      <td>14217</td>\n",
       "      <td>14217</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11238</th>\n",
       "      <td>14689</td>\n",
       "      <td>14689</td>\n",
       "      <td>14689</td>\n",
       "      <td>14662</td>\n",
       "      <td>14689</td>\n",
       "      <td>14689</td>\n",
       "      <td>14689</td>\n",
       "      <td>14689</td>\n",
       "      <td>14689</td>\n",
       "      <td>14689</td>\n",
       "      <td>14689</td>\n",
       "      <td>14689</td>\n",
       "      <td>11997</td>\n",
       "      <td>11986</td>\n",
       "      <td>14689</td>\n",
       "      <td>14689</td>\n",
       "      <td>14689</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10009</th>\n",
       "      <td>14926</td>\n",
       "      <td>14926</td>\n",
       "      <td>14926</td>\n",
       "      <td>14915</td>\n",
       "      <td>14926</td>\n",
       "      <td>14926</td>\n",
       "      <td>14926</td>\n",
       "      <td>14926</td>\n",
       "      <td>14926</td>\n",
       "      <td>14926</td>\n",
       "      <td>14926</td>\n",
       "      <td>14926</td>\n",
       "      <td>12284</td>\n",
       "      <td>12276</td>\n",
       "      <td>14926</td>\n",
       "      <td>14926</td>\n",
       "      <td>14926</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10019</th>\n",
       "      <td>15162</td>\n",
       "      <td>15124</td>\n",
       "      <td>15162</td>\n",
       "      <td>15151</td>\n",
       "      <td>15162</td>\n",
       "      <td>15162</td>\n",
       "      <td>15162</td>\n",
       "      <td>15162</td>\n",
       "      <td>15162</td>\n",
       "      <td>15162</td>\n",
       "      <td>15162</td>\n",
       "      <td>15162</td>\n",
       "      <td>11157</td>\n",
       "      <td>11149</td>\n",
       "      <td>15162</td>\n",
       "      <td>15162</td>\n",
       "      <td>15162</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10002</th>\n",
       "      <td>16058</td>\n",
       "      <td>16046</td>\n",
       "      <td>16058</td>\n",
       "      <td>16040</td>\n",
       "      <td>16058</td>\n",
       "      <td>16058</td>\n",
       "      <td>16058</td>\n",
       "      <td>16058</td>\n",
       "      <td>16058</td>\n",
       "      <td>16058</td>\n",
       "      <td>16058</td>\n",
       "      <td>16058</td>\n",
       "      <td>13146</td>\n",
       "      <td>13136</td>\n",
       "      <td>16058</td>\n",
       "      <td>16058</td>\n",
       "      <td>16058</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11216</th>\n",
       "      <td>16506</td>\n",
       "      <td>16506</td>\n",
       "      <td>16506</td>\n",
       "      <td>16485</td>\n",
       "      <td>16506</td>\n",
       "      <td>16506</td>\n",
       "      <td>16506</td>\n",
       "      <td>16506</td>\n",
       "      <td>16506</td>\n",
       "      <td>16506</td>\n",
       "      <td>16506</td>\n",
       "      <td>16506</td>\n",
       "      <td>13207</td>\n",
       "      <td>13201</td>\n",
       "      <td>16506</td>\n",
       "      <td>16506</td>\n",
       "      <td>16506</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11206</th>\n",
       "      <td>18448</td>\n",
       "      <td>18437</td>\n",
       "      <td>18448</td>\n",
       "      <td>18418</td>\n",
       "      <td>18448</td>\n",
       "      <td>18448</td>\n",
       "      <td>18448</td>\n",
       "      <td>18448</td>\n",
       "      <td>18448</td>\n",
       "      <td>18448</td>\n",
       "      <td>18448</td>\n",
       "      <td>18448</td>\n",
       "      <td>14455</td>\n",
       "      <td>14444</td>\n",
       "      <td>18448</td>\n",
       "      <td>18448</td>\n",
       "      <td>18448</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11221</th>\n",
       "      <td>21723</td>\n",
       "      <td>21711</td>\n",
       "      <td>21723</td>\n",
       "      <td>21712</td>\n",
       "      <td>21723</td>\n",
       "      <td>21723</td>\n",
       "      <td>21723</td>\n",
       "      <td>21723</td>\n",
       "      <td>21723</td>\n",
       "      <td>21723</td>\n",
       "      <td>21723</td>\n",
       "      <td>21723</td>\n",
       "      <td>17723</td>\n",
       "      <td>17711</td>\n",
       "      <td>21723</td>\n",
       "      <td>21723</td>\n",
       "      <td>21723</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11211</th>\n",
       "      <td>28747</td>\n",
       "      <td>28711</td>\n",
       "      <td>28747</td>\n",
       "      <td>28704</td>\n",
       "      <td>28747</td>\n",
       "      <td>28747</td>\n",
       "      <td>28747</td>\n",
       "      <td>28747</td>\n",
       "      <td>28747</td>\n",
       "      <td>28747</td>\n",
       "      <td>28747</td>\n",
       "      <td>28747</td>\n",
       "      <td>22994</td>\n",
       "      <td>22973</td>\n",
       "      <td>28747</td>\n",
       "      <td>28747</td>\n",
       "      <td>28747</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            id   name  host_id  host_name  neighbourhood_group  neighbourhood  \\\n",
       "zipcode                                                                         \n",
       "10018     3917   3917     3917       3909                 3917           3917   \n",
       "11218     4007   4007     4007       4006                 4007           4007   \n",
       "10035     4110   4110     4110       4107                 4110           4110   \n",
       "11101     4373   4373     4373       4371                 4373           4373   \n",
       "10017     4399   4399     4399       4393                 4399           4399   \n",
       "10010     4480   4480     4480       4472                 4480           4480   \n",
       "10030     4526   4526     4526       4522                 4526           4526   \n",
       "11106     4543   4543     4543       4533                 4543           4543   \n",
       "11231     4603   4603     4603       4601                 4603           4603   \n",
       "11103     4704   4700     4704       4697                 4704           4704   \n",
       "10028     5261   5259     5261       5259                 5261           5261   \n",
       "11385     5276   5276     5276       5273                 5276           5276   \n",
       "10022     5393   5393     5393       5386                 5393           5393   \n",
       "10128     5644   5644     5644       5638                 5644           5644   \n",
       "11207     5741   5741     5741       5738                 5741           5741   \n",
       "10013     6093   6093     6093       6086                 6093           6093   \n",
       "10001     6172   6172     6172       6168                 6172           6172   \n",
       "11201     6263   6263     6263       6260                 6263           6263   \n",
       "10032     6344   6344     6344       6328                 6344           6344   \n",
       "10026     6374   6362     6374       6368                 6374           6374   \n",
       "10024     6386   6386     6386       6375                 6386           6386   \n",
       "10023     6389   6386     6389       6386                 6389           6389   \n",
       "11213     6482   6482     6482       6471                 6482           6482   \n",
       "11217     7225   7225     7225       7217                 7225           7225   \n",
       "11225     7938   7938     7938       7932                 7938           7938   \n",
       "11226     8368   8368     8368       8363                 8368           8368   \n",
       "11205     8986   8986     8986       8980                 8986           8986   \n",
       "10029     9387   9387     9387       9374                 9387           9387   \n",
       "10014     9556   9556     9556       9554                 9556           9556   \n",
       "10012     9830   9818     9830       9825                 9830           9830   \n",
       "11233    10034  10034    10034      10026                10034          10034   \n",
       "11249    10095  10087    10095      10065                10095          10095   \n",
       "10011    10663  10663    10663      10660                10663          10663   \n",
       "10031    10718  10718    10718      10710                10718          10718   \n",
       "10016    10730  10730    10730      10723                10730          10730   \n",
       "10027    10773  10773    10773      10763                10773          10773   \n",
       "11215    11134  11134    11134      11126                11134          11134   \n",
       "10036    11161  11161    11161      11155                11161          11161   \n",
       "11237    12892  12891    12892      12881                12892          12892   \n",
       "10025    13206  13183    13206      13197                13206          13206   \n",
       "11222    13760  13756    13760      13749                13760          13760   \n",
       "10003    14217  14193    14217      14208                14217          14217   \n",
       "11238    14689  14689    14689      14662                14689          14689   \n",
       "10009    14926  14926    14926      14915                14926          14926   \n",
       "10019    15162  15124    15162      15151                15162          15162   \n",
       "10002    16058  16046    16058      16040                16058          16058   \n",
       "11216    16506  16506    16506      16485                16506          16506   \n",
       "11206    18448  18437    18448      18418                18448          18448   \n",
       "11221    21723  21711    21723      21712                21723          21723   \n",
       "11211    28747  28711    28747      28704                28747          28747   \n",
       "\n",
       "         latitude  longitude  room_type  price  minimum_nights  \\\n",
       "zipcode                                                          \n",
       "10018        3917       3917       3917   3917            3917   \n",
       "11218        4007       4007       4007   4007            4007   \n",
       "10035        4110       4110       4110   4110            4110   \n",
       "11101        4373       4373       4373   4373            4373   \n",
       "10017        4399       4399       4399   4399            4399   \n",
       "10010        4480       4480       4480   4480            4480   \n",
       "10030        4526       4526       4526   4526            4526   \n",
       "11106        4543       4543       4543   4543            4543   \n",
       "11231        4603       4603       4603   4603            4603   \n",
       "11103        4704       4704       4704   4704            4704   \n",
       "10028        5261       5261       5261   5261            5261   \n",
       "11385        5276       5276       5276   5276            5276   \n",
       "10022        5393       5393       5393   5393            5393   \n",
       "10128        5644       5644       5644   5644            5644   \n",
       "11207        5741       5741       5741   5741            5741   \n",
       "10013        6093       6093       6093   6093            6093   \n",
       "10001        6172       6172       6172   6172            6172   \n",
       "11201        6263       6263       6263   6263            6263   \n",
       "10032        6344       6344       6344   6344            6344   \n",
       "10026        6374       6374       6374   6374            6374   \n",
       "10024        6386       6386       6386   6386            6386   \n",
       "10023        6389       6389       6389   6389            6389   \n",
       "11213        6482       6482       6482   6482            6482   \n",
       "11217        7225       7225       7225   7225            7225   \n",
       "11225        7938       7938       7938   7938            7938   \n",
       "11226        8368       8368       8368   8368            8368   \n",
       "11205        8986       8986       8986   8986            8986   \n",
       "10029        9387       9387       9387   9387            9387   \n",
       "10014        9556       9556       9556   9556            9556   \n",
       "10012        9830       9830       9830   9830            9830   \n",
       "11233       10034      10034      10034  10034           10034   \n",
       "11249       10095      10095      10095  10095           10095   \n",
       "10011       10663      10663      10663  10663           10663   \n",
       "10031       10718      10718      10718  10718           10718   \n",
       "10016       10730      10730      10730  10730           10730   \n",
       "10027       10773      10773      10773  10773           10773   \n",
       "11215       11134      11134      11134  11134           11134   \n",
       "10036       11161      11161      11161  11161           11161   \n",
       "11237       12892      12892      12892  12892           12892   \n",
       "10025       13206      13206      13206  13206           13206   \n",
       "11222       13760      13760      13760  13760           13760   \n",
       "10003       14217      14217      14217  14217           14217   \n",
       "11238       14689      14689      14689  14689           14689   \n",
       "10009       14926      14926      14926  14926           14926   \n",
       "10019       15162      15162      15162  15162           15162   \n",
       "10002       16058      16058      16058  16058           16058   \n",
       "11216       16506      16506      16506  16506           16506   \n",
       "11206       18448      18448      18448  18448           18448   \n",
       "11221       21723      21723      21723  21723           21723   \n",
       "11211       28747      28747      28747  28747           28747   \n",
       "\n",
       "         number_of_reviews  last_review  reviews_per_month  \\\n",
       "zipcode                                                      \n",
       "10018                 3917         3004               3001   \n",
       "11218                 4007         3159               3158   \n",
       "10035                 4110         3236               3235   \n",
       "11101                 4373         3572               3571   \n",
       "10017                 4399         2823               2821   \n",
       "10010                 4480         3343               3341   \n",
       "10030                 4526         3875               3874   \n",
       "11106                 4543         3663               3660   \n",
       "11231                 4603         3734               3730   \n",
       "11103                 4704         3668               3662   \n",
       "10028                 5261         4053               4045   \n",
       "11385                 5276         4003               3998   \n",
       "10022                 5393         3974               3971   \n",
       "10128                 5644         4389               4384   \n",
       "11207                 5741         4637               4633   \n",
       "10013                 6093         4608               4602   \n",
       "10001                 6172         4676               4672   \n",
       "11201                 6263         4780               4778   \n",
       "10032                 6344         4942               4941   \n",
       "10026                 6374         5362               5356   \n",
       "10024                 6386         5088               5086   \n",
       "10023                 6389         4897               4895   \n",
       "11213                 6482         5073               5070   \n",
       "11217                 7225         5888               5882   \n",
       "11225                 7938         6333               6329   \n",
       "11226                 8368         6653               6646   \n",
       "11205                 8986         7208               7204   \n",
       "10029                 9387         7975               7968   \n",
       "10014                 9556         7642               7638   \n",
       "10012                 9830         7821               7817   \n",
       "11233                10034         8503               8498   \n",
       "11249                10095         7921               7914   \n",
       "10011                10663         8652               8647   \n",
       "10031                10718         8532               8524   \n",
       "10016                10730         7838               7835   \n",
       "10027                10773         8686               8676   \n",
       "11215                11134         9015               9008   \n",
       "10036                11161         8676               8674   \n",
       "11237                12892         9945               9938   \n",
       "10025                13206         9706               9698   \n",
       "11222                13760        10601              10590   \n",
       "10003                14217        11086              11078   \n",
       "11238                14689        11997              11986   \n",
       "10009                14926        12284              12276   \n",
       "10019                15162        11157              11149   \n",
       "10002                16058        13146              13136   \n",
       "11216                16506        13207              13201   \n",
       "11206                18448        14455              14444   \n",
       "11221                21723        17723              17711   \n",
       "11211                28747        22994              22973   \n",
       "\n",
       "         calculated_host_listings_count  availability_365   Date  \n",
       "zipcode                                                           \n",
       "10018                              3917              3917   3917  \n",
       "11218                              4007              4007   4007  \n",
       "10035                              4110              4110   4110  \n",
       "11101                              4373              4373   4373  \n",
       "10017                              4399              4399   4399  \n",
       "10010                              4480              4480   4480  \n",
       "10030                              4526              4526   4526  \n",
       "11106                              4543              4543   4543  \n",
       "11231                              4603              4603   4603  \n",
       "11103                              4704              4704   4704  \n",
       "10028                              5261              5261   5261  \n",
       "11385                              5276              5276   5276  \n",
       "10022                              5393              5393   5393  \n",
       "10128                              5644              5644   5644  \n",
       "11207                              5741              5741   5741  \n",
       "10013                              6093              6093   6093  \n",
       "10001                              6172              6172   6172  \n",
       "11201                              6263              6263   6263  \n",
       "10032                              6344              6344   6344  \n",
       "10026                              6374              6374   6374  \n",
       "10024                              6386              6386   6386  \n",
       "10023                              6389              6389   6389  \n",
       "11213                              6482              6482   6482  \n",
       "11217                              7225              7225   7225  \n",
       "11225                              7938              7938   7938  \n",
       "11226                              8368              8368   8368  \n",
       "11205                              8986              8986   8986  \n",
       "10029                              9387              9387   9387  \n",
       "10014                              9556              9556   9556  \n",
       "10012                              9830              9830   9830  \n",
       "11233                             10034             10034  10034  \n",
       "11249                             10095             10095  10095  \n",
       "10011                             10663             10663  10663  \n",
       "10031                             10718             10718  10718  \n",
       "10016                             10730             10730  10730  \n",
       "10027                             10773             10773  10773  \n",
       "11215                             11134             11134  11134  \n",
       "10036                             11161             11161  11161  \n",
       "11237                             12892             12892  12892  \n",
       "10025                             13206             13206  13206  \n",
       "11222                             13760             13760  13760  \n",
       "10003                             14217             14217  14217  \n",
       "11238                             14689             14689  14689  \n",
       "10009                             14926             14926  14926  \n",
       "10019                             15162             15162  15162  \n",
       "10002                             16058             16058  16058  \n",
       "11216                             16506             16506  16506  \n",
       "11206                             18448             18448  18448  \n",
       "11221                             21723             21723  21723  \n",
       "11211                             28747             28747  28747  "
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "file_input = '2018_Listings.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.tail(50)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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>146.840053</td>\n",
       "      <td>110.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>11221</td>\n",
       "      <td>87.629931</td>\n",
       "      <td>68.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>11206</td>\n",
       "      <td>96.825835</td>\n",
       "      <td>75.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>10019</td>\n",
       "      <td>228.574660</td>\n",
       "      <td>180.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>11216</td>\n",
       "      <td>110.636435</td>\n",
       "      <td>85.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>10002</td>\n",
       "      <td>171.128160</td>\n",
       "      <td>130.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>10009</td>\n",
       "      <td>170.691880</td>\n",
       "      <td>140.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>10003</td>\n",
       "      <td>223.038827</td>\n",
       "      <td>169.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>11222</td>\n",
       "      <td>135.671584</td>\n",
       "      <td>109.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>11238</td>\n",
       "      <td>137.844509</td>\n",
       "      <td>105.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Zip Code        Mean  Median\n",
       "0     11211  146.840053   110.0\n",
       "1     11221   87.629931    68.0\n",
       "2     11206   96.825835    75.0\n",
       "3     10019  228.574660   180.0\n",
       "4     11216  110.636435    85.0\n",
       "5     10002  171.128160   130.0\n",
       "6     10009  170.691880   140.0\n",
       "7     10003  223.038827   169.0\n",
       "8     11222  135.671584   109.5\n",
       "9     11238  137.844509   105.0"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "zipcodes = [11211,11221,11206,10019,11216,10002,10009,10003,11222,11238]\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"
   ]
  },
  {
   "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
}