blog_outline.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Tips and tricks"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Filter before merge"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "reviews = pd.read_csv('data/reviews.csv')\n",
    "reviews_summary = pd.read_csv('data/reviews_summary.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "listings = pd.read_csv('data/listings.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "listings = listings.rename(columns={'id':'listing_id'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "listings = listings.sample(frac=0.2, random_state=1337)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "86.6 ms ± 805 µs per loop (mean ± std. dev. of 7 runs, 10 loops each)\n"
     ]
    }
   ],
   "source": [
    "%%timeit\n",
    "listings.merge(reviews_summary, on='listing_id')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "48.7 ms ± 618 µs per loop (mean ± std. dev. of 7 runs, 10 loops each)\n"
     ]
    }
   ],
   "source": [
    "%%timeit\n",
    "reviews_subset = reviews_summary[reviews_summary['listing_id'].isin(listings['listing_id'])]\n",
    "listings.merge(reviews_subset, on='listing_id')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Vectorize operations"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Normalize prize between 0 and 1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "listings.loc[listings['price']==0, 'price'] = 30"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Iterative\n",
    "min_prize = listings['price'].min()\n",
    "max_prize = listings['price'].max()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(8600, 9)"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "max_prize, min_prize"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1.08 s ± 13.3 ms per loop (mean ± std. dev. of 7 runs, 1 loop each)\n"
     ]
    }
   ],
   "source": [
    "%%timeit\n",
    "norm_prizes = np.zeros(len(listings,))\n",
    "for i in range(len(listings)):\n",
    "    norm_prizes[i] = (listings.iloc[i]['price'] - min_prize) / (max_prize - min_prize)\n",
    "listings['norm_price'] = norm_prizes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "3.85 ms ± 12.3 µs per loop (mean ± std. dev. of 7 runs, 100 loops each)\n"
     ]
    }
   ],
   "source": [
    "%%timeit \n",
    "listings['norm_price'] = listings['price'].map(lambda x: (x - min_prize) / (max_prize - min_prize))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "565 µs ± 6.04 µs per loop (mean ± std. dev. of 7 runs, 1000 loops each)\n"
     ]
    }
   ],
   "source": [
    "%%timeit\n",
    "listings['norm_price'] = (listings['price'] - min_prize) / (max_prize - min_prize)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Normalize price per neighbourhood group"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [],
   "source": [
    "grouped_prices_max = listings.groupby('neighbourhood_group', as_index=False).max()\n",
    "grouped_prices_max = grouped_prices_max.rename(columns={'price':'max_price'})[['neighbourhood_group', 'max_price']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {},
   "outputs": [],
   "source": [
    "grouped_prices_min = listings.groupby('neighbourhood_group', as_index=False).min()\n",
    "grouped_prices_min = grouped_prices_min.rename(columns={'price':'min_price'})[['neighbourhood_group', 'min_price']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "metadata": {},
   "outputs": [],
   "source": [
    "listings_groups = listings.merge(grouped_prices_max, on='neighbourhood_group')\n",
    "listings_groups = listings_groups.merge(grouped_prices_min, on='neighbourhood_group')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {},
   "outputs": [],
   "source": [
    "listings_groups['norm_price'] = (listings_groups['price'] - listings_groups['min_price']) / (listings_groups['max_price'] - listings_groups['min_price'])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## using numpy"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Lets say we want to do more advanced calculations for a subset of our data, then it can be faster to convert the data to numpy arrays and loop through them."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "room_type_scores = {'Entire home/apt': 1,\n",
    "                   'Private room': 0.7,\n",
    "                   'Shared room': 0.2}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "6.11 ms ± 79.8 µs per loop (mean ± std. dev. of 7 runs, 100 loops each)\n"
     ]
    }
   ],
   "source": [
    "%%timeit\n",
    "prizes = listings['price'].values\n",
    "nr_reviews = listings['number_of_reviews'].values\n",
    "availability = listings['availability_365'].values\n",
    "minimum_nights = listings['minimum_nights'].values\n",
    "room_types = listings['room_type'].values\n",
    "scores = np.zeros(len(prizes))\n",
    "for i in range(len(prizes)):\n",
    "    if availability[i] == 0:\n",
    "        scores[i] = 0\n",
    "    elif prizes[i] > 100:\n",
    "        scores[i] = 0\n",
    "    elif minimum_nights[i] > 3:\n",
    "        scores[i] = 0\n",
    "    elif nr_reviews[i] < 10:\n",
    "        scores[i] = 0\n",
    "    else:\n",
    "        room_type_score = room_type_scores[room_types[i]]\n",
    "        prize_score = (100 - prizes[i]) / 100\n",
    "        review_score = 1 if nr_reviews[i] > 50 else 0.5\n",
    "        scores[i] = room_type_score * prize_score * review_score\n",
    "listings['score'] = scores\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1.19 s ± 18.8 ms per loop (mean ± std. dev. of 7 runs, 1 loop each)\n"
     ]
    }
   ],
   "source": [
    "%%timeit\n",
    "scores = np.zeros(len(prizes))\n",
    "for i in range(len(prizes)):\n",
    "    row = listings.iloc[i]\n",
    "    if row['availability_365'] == 0:\n",
    "        scores[i] = 0\n",
    "    elif row['price'] > 100:\n",
    "        scores[i] = 0\n",
    "    elif row['minimum_nights'] > 3:\n",
    "        scores[i] = 0\n",
    "    elif row['number_of_reviews'] < 10:\n",
    "        scores[i] = 0\n",
    "    else:\n",
    "        room_type_score = room_type_scores[row['room_type']]\n",
    "        prize_score = (100 - row['price']) / 100\n",
    "        review_score = 1 if row['number_of_reviews'] > 50 else 0.5\n",
    "        scores[i] = room_type_score * prize_score * review_score\n",
    "listings['score'] = scores\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "9.11 ms ± 84.4 µs per loop (mean ± std. dev. of 7 runs, 100 loops each)\n"
     ]
    }
   ],
   "source": [
    "%%timeit \n",
    "listings['room_type_score'] = listings['room_type'].map(lambda x: room_type_scores[x])\n",
    "listings['prize_score'] = (100 - listings['price']) / 100\n",
    "listings['review_score'] = listings['number_of_reviews'].map(lambda x: 1 if x > 50 else 0.5)\n",
    "listings['score'] = listings['room_type_score'] * listings['prize_score'] * listings['review_score']\n",
    "listings.loc[(listings['availability_365'] == 0) | (listings['price'] > 100) | (listings['minimum_nights'] > 3) | (listings['number_of_reviews'] < 10), 'score'] = 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [],
   "source": [
    "def room_score(availability, price, min_nights, nr_reviews, room_type):\n",
    "    if availability== 0:\n",
    "        return 0\n",
    "    elif price > 100:\n",
    "        return 0\n",
    "    elif min_nights > 3:\n",
    "        return 0\n",
    "    elif nr_reviews < 10:\n",
    "        return 0\n",
    "    else:\n",
    "        room_type_score = room_type_scores[room_type]\n",
    "        prize_score = (100 - price) / 100\n",
    "        review_score = 1 if nr_reviews > 50 else 0.5\n",
    "        return room_type_score * prize_score * review_score\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "217 ms ± 1.09 ms per loop (mean ± std. dev. of 7 runs, 1 loop each)\n"
     ]
    }
   ],
   "source": [
    "%%timeit\n",
    "listings['score'] = listings.apply(lambda row: room_score(row['availability_365'], row['price'], row['minimum_nights'], row['number_of_reviews'], row['room_type']), axis=1)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "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>listing_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>score</th>\n",
       "      <th>room_type_score</th>\n",
       "      <th>prize_score</th>\n",
       "      <th>review_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3342</th>\n",
       "      <td>1129012</td>\n",
       "      <td>Sunny apartment no.2 in Berlin city</td>\n",
       "      <td>915430</td>\n",
       "      <td>Andreas</td>\n",
       "      <td>Reinickendorf</td>\n",
       "      <td>Ost 1</td>\n",
       "      <td>52.561471</td>\n",
       "      <td>13.372684</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>18</td>\n",
       "      <td>2</td>\n",
       "      <td>186</td>\n",
       "      <td>2018-11-03</td>\n",
       "      <td>2.91</td>\n",
       "      <td>2</td>\n",
       "      <td>73</td>\n",
       "      <td>0.820</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.82</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2241</th>\n",
       "      <td>22154155</td>\n",
       "      <td>Tiny House in Berlin-Weissensee</td>\n",
       "      <td>161792772</td>\n",
       "      <td>René</td>\n",
       "      <td>Pankow</td>\n",
       "      <td>Weißensee Ost</td>\n",
       "      <td>52.558733</td>\n",
       "      <td>13.475007</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>35</td>\n",
       "      <td>1</td>\n",
       "      <td>56</td>\n",
       "      <td>2018-10-30</td>\n",
       "      <td>7.74</td>\n",
       "      <td>1</td>\n",
       "      <td>205</td>\n",
       "      <td>0.650</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.65</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4359</th>\n",
       "      <td>323260</td>\n",
       "      <td>Apartment in Berlin for 1-3 persons</td>\n",
       "      <td>1654885</td>\n",
       "      <td>Claudius</td>\n",
       "      <td>Neukölln</td>\n",
       "      <td>Neuköllner Mitte/Zentrum</td>\n",
       "      <td>52.483888</td>\n",
       "      <td>13.428707</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>36</td>\n",
       "      <td>3</td>\n",
       "      <td>197</td>\n",
       "      <td>2018-10-27</td>\n",
       "      <td>2.56</td>\n",
       "      <td>11</td>\n",
       "      <td>248</td>\n",
       "      <td>0.640</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.64</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3812</th>\n",
       "      <td>18561176</td>\n",
       "      <td>Cozy Room in comfortable 80qm flat</td>\n",
       "      <td>59073111</td>\n",
       "      <td>Konstantin</td>\n",
       "      <td>Reinickendorf</td>\n",
       "      <td>West 4</td>\n",
       "      <td>52.565287</td>\n",
       "      <td>13.325170</td>\n",
       "      <td>Private room</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>82</td>\n",
       "      <td>2018-10-30</td>\n",
       "      <td>4.60</td>\n",
       "      <td>3</td>\n",
       "      <td>16</td>\n",
       "      <td>0.630</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.90</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3681</th>\n",
       "      <td>18069548</td>\n",
       "      <td>Vacation Rental at Charlotte's in Berlin</td>\n",
       "      <td>91074978</td>\n",
       "      <td>Charlotte</td>\n",
       "      <td>Tempelhof - Schöneberg</td>\n",
       "      <td>Friedenau</td>\n",
       "      <td>52.473107</td>\n",
       "      <td>13.344343</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>38</td>\n",
       "      <td>2</td>\n",
       "      <td>53</td>\n",
       "      <td>2018-11-04</td>\n",
       "      <td>2.89</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0.620</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.62</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1834</th>\n",
       "      <td>12281381</td>\n",
       "      <td>Ideal Room for Couples Close to the City Center</td>\n",
       "      <td>49815862</td>\n",
       "      <td>Jacob</td>\n",
       "      <td>Lichtenberg</td>\n",
       "      <td>Alt-Hohenschönhausen Süd</td>\n",
       "      <td>52.535306</td>\n",
       "      <td>13.475582</td>\n",
       "      <td>Private room</td>\n",
       "      <td>14</td>\n",
       "      <td>3</td>\n",
       "      <td>153</td>\n",
       "      <td>2018-11-01</td>\n",
       "      <td>5.04</td>\n",
       "      <td>2</td>\n",
       "      <td>58</td>\n",
       "      <td>0.602</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.86</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4412</th>\n",
       "      <td>10941636</td>\n",
       "      <td>Family-friendly + near to the party</td>\n",
       "      <td>56732023</td>\n",
       "      <td>Robert &amp; Steffi</td>\n",
       "      <td>Friedrichshain-Kreuzberg</td>\n",
       "      <td>Frankfurter Allee Nord</td>\n",
       "      <td>52.518563</td>\n",
       "      <td>13.468847</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>40</td>\n",
       "      <td>1</td>\n",
       "      <td>125</td>\n",
       "      <td>2018-10-19</td>\n",
       "      <td>3.76</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>0.600</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.60</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2743</th>\n",
       "      <td>11383656</td>\n",
       "      <td>Cozy studio in Prenzlauer Berg 2</td>\n",
       "      <td>59676944</td>\n",
       "      <td>Elena</td>\n",
       "      <td>Pankow</td>\n",
       "      <td>Prenzlauer Berg Süd</td>\n",
       "      <td>52.541630</td>\n",
       "      <td>13.425360</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>40</td>\n",
       "      <td>2</td>\n",
       "      <td>125</td>\n",
       "      <td>2018-10-21</td>\n",
       "      <td>3.97</td>\n",
       "      <td>2</td>\n",
       "      <td>121</td>\n",
       "      <td>0.600</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.60</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>794</th>\n",
       "      <td>11381321</td>\n",
       "      <td>Cozy studio in Prenzlauer Berg</td>\n",
       "      <td>59676944</td>\n",
       "      <td>Elena</td>\n",
       "      <td>Pankow</td>\n",
       "      <td>Helmholtzplatz</td>\n",
       "      <td>52.543037</td>\n",
       "      <td>13.423437</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>40</td>\n",
       "      <td>2</td>\n",
       "      <td>121</td>\n",
       "      <td>2018-10-23</td>\n",
       "      <td>3.75</td>\n",
       "      <td>2</td>\n",
       "      <td>136</td>\n",
       "      <td>0.600</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.60</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1907</th>\n",
       "      <td>17688227</td>\n",
       "      <td>primeflats - City Apartment Prenzlauer Berg 7</td>\n",
       "      <td>1625771</td>\n",
       "      <td>Ben</td>\n",
       "      <td>Pankow</td>\n",
       "      <td>Prenzlauer Berg Nordwest</td>\n",
       "      <td>52.550908</td>\n",
       "      <td>13.404553</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>42</td>\n",
       "      <td>1</td>\n",
       "      <td>60</td>\n",
       "      <td>2018-11-02</td>\n",
       "      <td>3.14</td>\n",
       "      <td>45</td>\n",
       "      <td>121</td>\n",
       "      <td>0.580</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.58</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3981</th>\n",
       "      <td>18941266</td>\n",
       "      <td>Bed and Coffee at the White Lake in Berlin</td>\n",
       "      <td>3861369</td>\n",
       "      <td>Anderš &amp; Fatima</td>\n",
       "      <td>Pankow</td>\n",
       "      <td>Weißensee</td>\n",
       "      <td>52.557100</td>\n",
       "      <td>13.464744</td>\n",
       "      <td>Private room</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>57</td>\n",
       "      <td>2018-11-04</td>\n",
       "      <td>3.33</td>\n",
       "      <td>1</td>\n",
       "      <td>39</td>\n",
       "      <td>0.560</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.80</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2214</th>\n",
       "      <td>2682379</td>\n",
       "      <td>Schnell nach Berlin/S-Grünbergallee</td>\n",
       "      <td>12781649</td>\n",
       "      <td>Dagmar</td>\n",
       "      <td>Treptow - Köpenick</td>\n",
       "      <td>Bohnsdorf</td>\n",
       "      <td>52.398575</td>\n",
       "      <td>13.540094</td>\n",
       "      <td>Private room</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>127</td>\n",
       "      <td>2018-09-16</td>\n",
       "      <td>2.38</td>\n",
       "      <td>4</td>\n",
       "      <td>195</td>\n",
       "      <td>0.560</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.80</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>569</th>\n",
       "      <td>4160025</td>\n",
       "      <td>near by TXL - ruhig &amp; gemütlich</td>\n",
       "      <td>21589042</td>\n",
       "      <td>Cori</td>\n",
       "      <td>Spandau</td>\n",
       "      <td>Siemensstadt</td>\n",
       "      <td>52.542121</td>\n",
       "      <td>13.270085</td>\n",
       "      <td>Private room</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>54</td>\n",
       "      <td>2018-10-17</td>\n",
       "      <td>1.08</td>\n",
       "      <td>1</td>\n",
       "      <td>48</td>\n",
       "      <td>0.560</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.80</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229</th>\n",
       "      <td>12905856</td>\n",
       "      <td>Süßes&amp;helles Zimmer in Berlin-Mitte (U-Bahn Nähe)</td>\n",
       "      <td>70724549</td>\n",
       "      <td>Caroline</td>\n",
       "      <td>Mitte</td>\n",
       "      <td>Osloer Straße</td>\n",
       "      <td>52.558164</td>\n",
       "      <td>13.379885</td>\n",
       "      <td>Private room</td>\n",
       "      <td>21</td>\n",
       "      <td>1</td>\n",
       "      <td>141</td>\n",
       "      <td>2018-10-31</td>\n",
       "      <td>8.25</td>\n",
       "      <td>1</td>\n",
       "      <td>33</td>\n",
       "      <td>0.553</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.79</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3158</th>\n",
       "      <td>23091571</td>\n",
       "      <td>STYLISH LOW COST BERLIN MITTE</td>\n",
       "      <td>95886146</td>\n",
       "      <td>Alcyone</td>\n",
       "      <td>Mitte</td>\n",
       "      <td>Brunnenstr. Süd</td>\n",
       "      <td>52.530346</td>\n",
       "      <td>13.388507</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>45</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>2018-11-02</td>\n",
       "      <td>7.87</td>\n",
       "      <td>4</td>\n",
       "      <td>106</td>\n",
       "      <td>0.550</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.55</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>812</th>\n",
       "      <td>883847</td>\n",
       "      <td>Maximilian´s Apartment for friends :-)</td>\n",
       "      <td>4680255</td>\n",
       "      <td>Maximilian Benedikt</td>\n",
       "      <td>Mitte</td>\n",
       "      <td>Wedding Zentrum</td>\n",
       "      <td>52.548879</td>\n",
       "      <td>13.362741</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>45</td>\n",
       "      <td>3</td>\n",
       "      <td>72</td>\n",
       "      <td>2018-10-09</td>\n",
       "      <td>1.04</td>\n",
       "      <td>1</td>\n",
       "      <td>294</td>\n",
       "      <td>0.550</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.55</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3308</th>\n",
       "      <td>13648211</td>\n",
       "      <td>CHIC &amp; BASIC</td>\n",
       "      <td>1485782</td>\n",
       "      <td>Cristian</td>\n",
       "      <td>Charlottenburg-Wilm.</td>\n",
       "      <td>Düsseldorfer Straße</td>\n",
       "      <td>52.496539</td>\n",
       "      <td>13.332558</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>45</td>\n",
       "      <td>3</td>\n",
       "      <td>54</td>\n",
       "      <td>2018-10-22</td>\n",
       "      <td>1.88</td>\n",
       "      <td>5</td>\n",
       "      <td>280</td>\n",
       "      <td>0.550</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.55</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3398</th>\n",
       "      <td>19382941</td>\n",
       "      <td>Modern Penthouse (2 rooms, 62 m², 4 pers.)</td>\n",
       "      <td>135868382</td>\n",
       "      <td>Jörg</td>\n",
       "      <td>Mitte</td>\n",
       "      <td>Brunnenstr. Nord</td>\n",
       "      <td>52.542560</td>\n",
       "      <td>13.375550</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>45</td>\n",
       "      <td>1</td>\n",
       "      <td>97</td>\n",
       "      <td>2018-10-24</td>\n",
       "      <td>7.31</td>\n",
       "      <td>2</td>\n",
       "      <td>347</td>\n",
       "      <td>0.550</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.55</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2783</th>\n",
       "      <td>564821</td>\n",
       "      <td>Nice 2 Rooms Flat \"Prenzlauer Berg\"</td>\n",
       "      <td>1139408</td>\n",
       "      <td>Romo</td>\n",
       "      <td>Pankow</td>\n",
       "      <td>Prenzlauer Berg Nord</td>\n",
       "      <td>52.546618</td>\n",
       "      <td>13.437788</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>46</td>\n",
       "      <td>2</td>\n",
       "      <td>146</td>\n",
       "      <td>2018-10-23</td>\n",
       "      <td>1.89</td>\n",
       "      <td>2</td>\n",
       "      <td>297</td>\n",
       "      <td>0.540</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.54</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3817</th>\n",
       "      <td>4805605</td>\n",
       "      <td>Room in Lichtenberg-Friederichsain</td>\n",
       "      <td>24513179</td>\n",
       "      <td>Des</td>\n",
       "      <td>Lichtenberg</td>\n",
       "      <td>Frankfurter Allee Süd</td>\n",
       "      <td>52.511968</td>\n",
       "      <td>13.489051</td>\n",
       "      <td>Private room</td>\n",
       "      <td>23</td>\n",
       "      <td>3</td>\n",
       "      <td>87</td>\n",
       "      <td>2018-07-08</td>\n",
       "      <td>1.86</td>\n",
       "      <td>2</td>\n",
       "      <td>37</td>\n",
       "      <td>0.539</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.77</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4047</th>\n",
       "      <td>1274386</td>\n",
       "      <td>Wonderful home sightseeing Spree</td>\n",
       "      <td>6782131</td>\n",
       "      <td>Christian</td>\n",
       "      <td>Charlottenburg-Wilm.</td>\n",
       "      <td>Mierendorffplatz</td>\n",
       "      <td>52.521461</td>\n",
       "      <td>13.303179</td>\n",
       "      <td>Private room</td>\n",
       "      <td>23</td>\n",
       "      <td>1</td>\n",
       "      <td>122</td>\n",
       "      <td>2018-09-21</td>\n",
       "      <td>2.01</td>\n",
       "      <td>3</td>\n",
       "      <td>92</td>\n",
       "      <td>0.539</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.77</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4098</th>\n",
       "      <td>6691656</td>\n",
       "      <td>Room 40qm + 74qm share f 6-8 pers. southwestce...</td>\n",
       "      <td>35024779</td>\n",
       "      <td>Claudio Klaus</td>\n",
       "      <td>Charlottenburg-Wilm.</td>\n",
       "      <td>Volkspark Wilmersdorf</td>\n",
       "      <td>52.488032</td>\n",
       "      <td>13.325617</td>\n",
       "      <td>Private room</td>\n",
       "      <td>24</td>\n",
       "      <td>1</td>\n",
       "      <td>92</td>\n",
       "      <td>2018-11-03</td>\n",
       "      <td>2.44</td>\n",
       "      <td>4</td>\n",
       "      <td>334</td>\n",
       "      <td>0.532</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.76</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2608</th>\n",
       "      <td>18364724</td>\n",
       "      <td>Zimmer in Berlin Mitte. Ladies only.</td>\n",
       "      <td>127146676</td>\n",
       "      <td>Judy</td>\n",
       "      <td>Mitte</td>\n",
       "      <td>Moabit Ost</td>\n",
       "      <td>52.522131</td>\n",
       "      <td>13.354282</td>\n",
       "      <td>Private room</td>\n",
       "      <td>24</td>\n",
       "      <td>1</td>\n",
       "      <td>116</td>\n",
       "      <td>2018-10-24</td>\n",
       "      <td>6.34</td>\n",
       "      <td>1</td>\n",
       "      <td>254</td>\n",
       "      <td>0.532</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.76</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3306</th>\n",
       "      <td>1236282</td>\n",
       "      <td>Cozy room top location in hip &amp; creative Neukölln</td>\n",
       "      <td>4647121</td>\n",
       "      <td>Andres</td>\n",
       "      <td>Neukölln</td>\n",
       "      <td>Reuterstraße</td>\n",
       "      <td>52.487047</td>\n",
       "      <td>13.434452</td>\n",
       "      <td>Private room</td>\n",
       "      <td>25</td>\n",
       "      <td>2</td>\n",
       "      <td>171</td>\n",
       "      <td>2018-10-26</td>\n",
       "      <td>2.67</td>\n",
       "      <td>2</td>\n",
       "      <td>63</td>\n",
       "      <td>0.525</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.75</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1621</th>\n",
       "      <td>23839778</td>\n",
       "      <td>Amazing room near central station #modern #wel...</td>\n",
       "      <td>174755208</td>\n",
       "      <td>Paul</td>\n",
       "      <td>Mitte</td>\n",
       "      <td>Moabit Ost</td>\n",
       "      <td>52.521275</td>\n",
       "      <td>13.354157</td>\n",
       "      <td>Private room</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "      <td>53</td>\n",
       "      <td>2018-11-04</td>\n",
       "      <td>7.13</td>\n",
       "      <td>2</td>\n",
       "      <td>78</td>\n",
       "      <td>0.525</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.75</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1487</th>\n",
       "      <td>187206</td>\n",
       "      <td>cozy room</td>\n",
       "      <td>900521</td>\n",
       "      <td>Angelika-Maria</td>\n",
       "      <td>Mitte</td>\n",
       "      <td>Osloer Straße</td>\n",
       "      <td>52.563345</td>\n",
       "      <td>13.388022</td>\n",
       "      <td>Private room</td>\n",
       "      <td>25</td>\n",
       "      <td>2</td>\n",
       "      <td>224</td>\n",
       "      <td>2018-11-04</td>\n",
       "      <td>2.63</td>\n",
       "      <td>1</td>\n",
       "      <td>322</td>\n",
       "      <td>0.525</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.75</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2488</th>\n",
       "      <td>4062245</td>\n",
       "      <td>*cozy, quiet &amp; central room*</td>\n",
       "      <td>19827864</td>\n",
       "      <td>Dany</td>\n",
       "      <td>Tempelhof - Schöneberg</td>\n",
       "      <td>Schöneberg-Süd</td>\n",
       "      <td>52.480679</td>\n",
       "      <td>13.362490</td>\n",
       "      <td>Private room</td>\n",
       "      <td>25</td>\n",
       "      <td>2</td>\n",
       "      <td>51</td>\n",
       "      <td>2018-09-23</td>\n",
       "      <td>1.04</td>\n",
       "      <td>1</td>\n",
       "      <td>40</td>\n",
       "      <td>0.525</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.75</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>875</th>\n",
       "      <td>16922804</td>\n",
       "      <td>Big, Bright and good located Room in Berlin City!</td>\n",
       "      <td>113030617</td>\n",
       "      <td>Gabriela</td>\n",
       "      <td>Tempelhof - Schöneberg</td>\n",
       "      <td>Schöneberg-Nord</td>\n",
       "      <td>52.497937</td>\n",
       "      <td>13.362255</td>\n",
       "      <td>Private room</td>\n",
       "      <td>25</td>\n",
       "      <td>3</td>\n",
       "      <td>67</td>\n",
       "      <td>2018-10-14</td>\n",
       "      <td>3.11</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>0.525</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.75</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2894</th>\n",
       "      <td>15560206</td>\n",
       "      <td>Cozy sunny room in Neukölln/Kreuzberg</td>\n",
       "      <td>42269561</td>\n",
       "      <td>Jan</td>\n",
       "      <td>Neukölln</td>\n",
       "      <td>Reuterstraße</td>\n",
       "      <td>52.491797</td>\n",
       "      <td>13.428550</td>\n",
       "      <td>Private room</td>\n",
       "      <td>25</td>\n",
       "      <td>2</td>\n",
       "      <td>57</td>\n",
       "      <td>2018-10-31</td>\n",
       "      <td>2.38</td>\n",
       "      <td>2</td>\n",
       "      <td>86</td>\n",
       "      <td>0.525</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.75</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1604</th>\n",
       "      <td>11099159</td>\n",
       "      <td>Clean Room w/ own Bathroom, Centrum</td>\n",
       "      <td>54601187</td>\n",
       "      <td>Uwe</td>\n",
       "      <td>Friedrichshain-Kreuzberg</td>\n",
       "      <td>Frankfurter Allee Nord</td>\n",
       "      <td>52.515070</td>\n",
       "      <td>13.467139</td>\n",
       "      <td>Private room</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "      <td>200</td>\n",
       "      <td>2018-10-16</td>\n",
       "      <td>6.17</td>\n",
       "      <td>7</td>\n",
       "      <td>260</td>\n",
       "      <td>0.525</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.75</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1675</th>\n",
       "      <td>29006479</td>\n",
       "      <td>Shared apartment in Charlottenburg</td>\n",
       "      <td>135196610</td>\n",
       "      <td>Sarah</td>\n",
       "      <td>Charlottenburg-Wilm.</td>\n",
       "      <td>Neue Kantstraße</td>\n",
       "      <td>52.507132</td>\n",
       "      <td>13.289530</td>\n",
       "      <td>Private room</td>\n",
       "      <td>15</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>2018-10-20</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1</td>\n",
       "      <td>67</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.85</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1673</th>\n",
       "      <td>7360351</td>\n",
       "      <td>Kreuzberg=Welcome=Make yourself at home</td>\n",
       "      <td>38563923</td>\n",
       "      <td>Sabine</td>\n",
       "      <td>Friedrichshain-Kreuzberg</td>\n",
       "      <td>nördliche Luisenstadt</td>\n",
       "      <td>52.504074</td>\n",
       "      <td>13.418903</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>120</td>\n",
       "      <td>3</td>\n",
       "      <td>60</td>\n",
       "      <td>2018-11-02</td>\n",
       "      <td>1.50</td>\n",
       "      <td>1</td>\n",
       "      <td>324</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>-0.20</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1643</th>\n",
       "      <td>1799580</td>\n",
       "      <td>Big Sunny Room in Berlin Kreuzberg</td>\n",
       "      <td>9436682</td>\n",
       "      <td>Christina</td>\n",
       "      <td>Friedrichshain-Kreuzberg</td>\n",
       "      <td>südliche Luisenstadt</td>\n",
       "      <td>52.497227</td>\n",
       "      <td>13.436016</td>\n",
       "      <td>Private room</td>\n",
       "      <td>65</td>\n",
       "      <td>3</td>\n",
       "      <td>15</td>\n",
       "      <td>2017-01-02</td>\n",
       "      <td>0.25</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.35</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1644</th>\n",
       "      <td>6970346</td>\n",
       "      <td>2 Raumwhg. im Friedrichshain</td>\n",
       "      <td>11723994</td>\n",
       "      <td>Christian</td>\n",
       "      <td>Friedrichshain-Kreuzberg</td>\n",
       "      <td>Karl-Marx-Allee-Nord</td>\n",
       "      <td>52.521854</td>\n",
       "      <td>13.447621</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>55</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>2016-09-22</td>\n",
       "      <td>0.17</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.45</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1645</th>\n",
       "      <td>19863635</td>\n",
       "      <td>Bright 2 bedroom apartment in Prenzlauer Berg</td>\n",
       "      <td>140494435</td>\n",
       "      <td>Maria</td>\n",
       "      <td>Pankow</td>\n",
       "      <td>Prenzlauer Berg Süd</td>\n",
       "      <td>52.531690</td>\n",
       "      <td>13.436142</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>109</td>\n",
       "      <td>30</td>\n",
       "      <td>42</td>\n",
       "      <td>2018-10-28</td>\n",
       "      <td>2.69</td>\n",
       "      <td>1</td>\n",
       "      <td>207</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>-0.09</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1646</th>\n",
       "      <td>27794640</td>\n",
       "      <td>Flat of freedom in the middle of Prenzlauer Berg</td>\n",
       "      <td>139387787</td>\n",
       "      <td>Dario</td>\n",
       "      <td>Pankow</td>\n",
       "      <td>Prenzlauer Berg Nordwest</td>\n",
       "      <td>52.552963</td>\n",
       "      <td>13.409962</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>50</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2018-08-21</td>\n",
       "      <td>0.38</td>\n",
       "      <td>2</td>\n",
       "      <td>83</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.50</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1647</th>\n",
       "      <td>22244255</td>\n",
       "      <td>Roof top room beside Lafayette (Friedrichstraße)</td>\n",
       "      <td>162542183</td>\n",
       "      <td>Anne</td>\n",
       "      <td>Mitte</td>\n",
       "      <td>Regierungsviertel</td>\n",
       "      <td>52.514036</td>\n",
       "      <td>13.387764</td>\n",
       "      <td>Private room</td>\n",
       "      <td>35</td>\n",
       "      <td>2</td>\n",
       "      <td>21</td>\n",
       "      <td>2018-05-14</td>\n",
       "      <td>2.16</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.65</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1648</th>\n",
       "      <td>26985118</td>\n",
       "      <td>quiet room in big  flat, for professionals only</td>\n",
       "      <td>158600414</td>\n",
       "      <td>Max</td>\n",
       "      <td>Friedrichshain-Kreuzberg</td>\n",
       "      <td>Tempelhofer Vorstadt</td>\n",
       "      <td>52.498197</td>\n",
       "      <td>13.386906</td>\n",
       "      <td>Private room</td>\n",
       "      <td>25</td>\n",
       "      <td>14</td>\n",
       "      <td>2</td>\n",
       "      <td>2018-10-07</td>\n",
       "      <td>0.73</td>\n",
       "      <td>2</td>\n",
       "      <td>32</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.75</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1649</th>\n",
       "      <td>8870766</td>\n",
       "      <td>Bright one bedroom apartment</td>\n",
       "      <td>26073309</td>\n",
       "      <td>Marie</td>\n",
       "      <td>Mitte</td>\n",
       "      <td>Wedding Zentrum</td>\n",
       "      <td>52.549642</td>\n",
       "      <td>13.359687</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>36</td>\n",
       "      <td>2</td>\n",
       "      <td>41</td>\n",
       "      <td>2018-05-20</td>\n",
       "      <td>2.13</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.64</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1651</th>\n",
       "      <td>13585638</td>\n",
       "      <td>Charming flat at the heart of Kreuzberg</td>\n",
       "      <td>16273210</td>\n",
       "      <td>Isadhora</td>\n",
       "      <td>Friedrichshain-Kreuzberg</td>\n",
       "      <td>südliche Luisenstadt</td>\n",
       "      <td>52.493702</td>\n",
       "      <td>13.431392</td>\n",
       "      <td>Private room</td>\n",
       "      <td>35</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.65</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1652</th>\n",
       "      <td>6231989</td>\n",
       "      <td>Perfect sightseeing location Berlin</td>\n",
       "      <td>31019677</td>\n",
       "      <td>Hae-Ok</td>\n",
       "      <td>Mitte</td>\n",
       "      <td>Alexanderplatz</td>\n",
       "      <td>52.521582</td>\n",
       "      <td>13.404417</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>104</td>\n",
       "      <td>3</td>\n",
       "      <td>129</td>\n",
       "      <td>2018-10-22</td>\n",
       "      <td>3.14</td>\n",
       "      <td>2</td>\n",
       "      <td>218</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>-0.04</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1654</th>\n",
       "      <td>3005038</td>\n",
       "      <td>Nice apartment on the lake</td>\n",
       "      <td>15032404</td>\n",
       "      <td>Knuth</td>\n",
       "      <td>Treptow - Köpenick</td>\n",
       "      <td>Friedrichshagen</td>\n",
       "      <td>52.453130</td>\n",
       "      <td>13.627366</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>47</td>\n",
       "      <td>14</td>\n",
       "      <td>1</td>\n",
       "      <td>2014-08-15</td>\n",
       "      <td>0.02</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.53</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1655</th>\n",
       "      <td>7849941</td>\n",
       "      <td>Helles Zimmer am Wasser 3</td>\n",
       "      <td>24064848</td>\n",
       "      <td>Anne</td>\n",
       "      <td>Treptow - Köpenick</td>\n",
       "      <td>Niederschöneweide</td>\n",
       "      <td>52.453982</td>\n",
       "      <td>13.522592</td>\n",
       "      <td>Private room</td>\n",
       "      <td>23</td>\n",
       "      <td>4</td>\n",
       "      <td>74</td>\n",
       "      <td>2018-10-23</td>\n",
       "      <td>1.90</td>\n",
       "      <td>3</td>\n",
       "      <td>84</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.77</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1656</th>\n",
       "      <td>21138745</td>\n",
       "      <td>Elegant room centrally located in schöneberg</td>\n",
       "      <td>43178346</td>\n",
       "      <td>Nora</td>\n",
       "      <td>Mitte</td>\n",
       "      <td>Tiergarten Süd</td>\n",
       "      <td>52.505033</td>\n",
       "      <td>13.346577</td>\n",
       "      <td>Private room</td>\n",
       "      <td>32</td>\n",
       "      <td>2</td>\n",
       "      <td>52</td>\n",
       "      <td>2018-03-30</td>\n",
       "      <td>3.88</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.68</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1657</th>\n",
       "      <td>4822074</td>\n",
       "      <td>Beautiful apartment - best location</td>\n",
       "      <td>11763608</td>\n",
       "      <td>Marie</td>\n",
       "      <td>Friedrichshain-Kreuzberg</td>\n",
       "      <td>Frankfurter Allee Süd FK</td>\n",
       "      <td>52.511800</td>\n",
       "      <td>13.458939</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>45</td>\n",
       "      <td>4</td>\n",
       "      <td>17</td>\n",
       "      <td>2018-08-20</td>\n",
       "      <td>0.36</td>\n",
       "      <td>1</td>\n",
       "      <td>165</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.55</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1658</th>\n",
       "      <td>6499198</td>\n",
       "      <td>Berlin-Charlottenburg 10627</td>\n",
       "      <td>33971648</td>\n",
       "      <td>Britt</td>\n",
       "      <td>Charlottenburg-Wilm.</td>\n",
       "      <td>Schloß Charlottenburg</td>\n",
       "      <td>52.511074</td>\n",
       "      <td>13.300372</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>81</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.19</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1659</th>\n",
       "      <td>26178507</td>\n",
       "      <td>Cozy studio at Potsdamer Platz</td>\n",
       "      <td>10583203</td>\n",
       "      <td>Bruno</td>\n",
       "      <td>Friedrichshain-Kreuzberg</td>\n",
       "      <td>Südliche Friedrichstadt</td>\n",
       "      <td>52.503651</td>\n",
       "      <td>13.375158</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>44</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "      <td>2018-10-31</td>\n",
       "      <td>1.65</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.56</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1660</th>\n",
       "      <td>6553175</td>\n",
       "      <td>4-Zimmer Altbauwohnung, Prenzlauer Berg</td>\n",
       "      <td>33081599</td>\n",
       "      <td>Beate</td>\n",
       "      <td>Pankow</td>\n",
       "      <td>Prenzlauer Berg Nord</td>\n",
       "      <td>52.551951</td>\n",
       "      <td>13.419783</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>87</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>2017-08-20</td>\n",
       "      <td>0.08</td>\n",
       "      <td>1</td>\n",
       "      <td>304</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.13</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1661</th>\n",
       "      <td>24628651</td>\n",
       "      <td>Charming 130qm Apartment in Prenzlauer Berg</td>\n",
       "      <td>186123207</td>\n",
       "      <td>Hannah</td>\n",
       "      <td>Pankow</td>\n",
       "      <td>Helmholtzplatz</td>\n",
       "      <td>52.540739</td>\n",
       "      <td>13.419368</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>140</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>2018-08-04</td>\n",
       "      <td>1.18</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>-0.40</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1662</th>\n",
       "      <td>26523630</td>\n",
       "      <td>Huge, bright room in artists apartment</td>\n",
       "      <td>21859509</td>\n",
       "      <td>Matthew</td>\n",
       "      <td>Neukölln</td>\n",
       "      <td>Rixdorf</td>\n",
       "      <td>52.486813</td>\n",
       "      <td>13.451088</td>\n",
       "      <td>Private room</td>\n",
       "      <td>34</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2018-08-27</td>\n",
       "      <td>0.52</td>\n",
       "      <td>1</td>\n",
       "      <td>33</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.66</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1663</th>\n",
       "      <td>4401036</td>\n",
       "      <td>Sunny Attic Artist Studio</td>\n",
       "      <td>12670142</td>\n",
       "      <td>Maansi</td>\n",
       "      <td>Friedrichshain-Kreuzberg</td>\n",
       "      <td>Frankfurter Allee Süd FK</td>\n",
       "      <td>52.511280</td>\n",
       "      <td>13.467690</td>\n",
       "      <td>Private room</td>\n",
       "      <td>115</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>2017-05-02</td>\n",
       "      <td>0.19</td>\n",
       "      <td>1</td>\n",
       "      <td>284</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.7</td>\n",
       "      <td>-0.15</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1664</th>\n",
       "      <td>7639962</td>\n",
       "      <td>Zimmer direkt am Mauerpark!</td>\n",
       "      <td>36962507</td>\n",
       "      <td>Julia</td>\n",
       "      <td>Pankow</td>\n",
       "      <td>Prenzlauer Berg Nordwest</td>\n",
       "      <td>52.541928</td>\n",
       "      <td>13.410104</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>27</td>\n",
       "      <td>4</td>\n",
       "      <td>7</td>\n",
       "      <td>2017-05-29</td>\n",
       "      <td>0.24</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.73</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1665</th>\n",
       "      <td>6652283</td>\n",
       "      <td>Room (2) in the center of Berlin</td>\n",
       "      <td>8048976</td>\n",
       "      <td>Sonia</td>\n",
       "      <td>Mitte</td>\n",
       "      <td>Brunnenstr. Süd</td>\n",
       "      <td>52.533458</td>\n",
       "      <td>13.395935</td>\n",
       "      <td>Private room</td>\n",
       "      <td>60</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>2016-07-04</td>\n",
       "      <td>0.07</td>\n",
       "      <td>5</td>\n",
       "      <td>129</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1667</th>\n",
       "      <td>25117866</td>\n",
       "      <td>Bright, modern, perfectly equipped Apartment</td>\n",
       "      <td>843072</td>\n",
       "      <td>Inna</td>\n",
       "      <td>Pankow</td>\n",
       "      <td>Weißensee</td>\n",
       "      <td>52.554149</td>\n",
       "      <td>13.429590</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>50</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>94</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.50</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1668</th>\n",
       "      <td>11715593</td>\n",
       "      <td>Gemütliches Zimmer/Cosy Room in Kreuzberg</td>\n",
       "      <td>62288300</td>\n",
       "      <td>Antonia</td>\n",
       "      <td>Friedrichshain-Kreuzberg</td>\n",
       "      <td>nördliche Luisenstadt</td>\n",
       "      <td>52.500629</td>\n",
       "      <td>13.429265</td>\n",
       "      <td>Private room</td>\n",
       "      <td>20</td>\n",
       "      <td>10</td>\n",
       "      <td>9</td>\n",
       "      <td>2018-02-20</td>\n",
       "      <td>0.28</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.80</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1669</th>\n",
       "      <td>3729154</td>\n",
       "      <td>wonderful apartment next to centre</td>\n",
       "      <td>13868464</td>\n",
       "      <td>Bünyamin</td>\n",
       "      <td>Tempelhof - Schöneberg</td>\n",
       "      <td>Tempelhof</td>\n",
       "      <td>52.458034</td>\n",
       "      <td>13.387861</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>99</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2015-09-15</td>\n",
       "      <td>0.05</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1670</th>\n",
       "      <td>10651356</td>\n",
       "      <td>Beautiful room near Main Station</td>\n",
       "      <td>55002456</td>\n",
       "      <td>Gaelle</td>\n",
       "      <td>Mitte</td>\n",
       "      <td>Moabit Ost</td>\n",
       "      <td>52.535793</td>\n",
       "      <td>13.356935</td>\n",
       "      <td>Private room</td>\n",
       "      <td>25</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2016-02-17</td>\n",
       "      <td>0.09</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.75</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1671</th>\n",
       "      <td>23339442</td>\n",
       "      <td>Spacious and quiet apartment near Prenzlauer Berg</td>\n",
       "      <td>8723577</td>\n",
       "      <td>Michaela</td>\n",
       "      <td>Pankow</td>\n",
       "      <td>Blankenburg/Heinersdorf/Märchenland</td>\n",
       "      <td>52.563515</td>\n",
       "      <td>13.427477</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>80</td>\n",
       "      <td>7</td>\n",
       "      <td>6</td>\n",
       "      <td>2018-09-25</td>\n",
       "      <td>0.77</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.20</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1672</th>\n",
       "      <td>28798099</td>\n",
       "      <td>Cozy studio for 1 or 2 in Bergmannstraße-district</td>\n",
       "      <td>3789531</td>\n",
       "      <td>Fulvia</td>\n",
       "      <td>Friedrichshain-Kreuzberg</td>\n",
       "      <td>Tempelhofer Vorstadt</td>\n",
       "      <td>52.490515</td>\n",
       "      <td>13.380739</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>55</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>2018-10-22</td>\n",
       "      <td>3.16</td>\n",
       "      <td>5</td>\n",
       "      <td>287</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.45</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2255</th>\n",
       "      <td>20421098</td>\n",
       "      <td>cosy rooms in the center of Berlin</td>\n",
       "      <td>76289121</td>\n",
       "      <td>Sara</td>\n",
       "      <td>Friedrichshain-Kreuzberg</td>\n",
       "      <td>Tempelhofer Vorstadt</td>\n",
       "      <td>52.492775</td>\n",
       "      <td>13.381960</td>\n",
       "      <td>Private room</td>\n",
       "      <td>50</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2017-09-04</td>\n",
       "      <td>0.07</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.50</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4510 rows × 20 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      listing_id                                               name  \\\n",
       "3342     1129012                Sunny apartment no.2 in Berlin city   \n",
       "2241    22154155                    Tiny House in Berlin-Weissensee   \n",
       "4359      323260                Apartment in Berlin for 1-3 persons   \n",
       "3812    18561176                 Cozy Room in comfortable 80qm flat   \n",
       "3681    18069548           Vacation Rental at Charlotte's in Berlin   \n",
       "1834    12281381    Ideal Room for Couples Close to the City Center   \n",
       "4412    10941636                Family-friendly + near to the party   \n",
       "2743    11383656                   Cozy studio in Prenzlauer Berg 2   \n",
       "794     11381321                     Cozy studio in Prenzlauer Berg   \n",
       "1907    17688227      primeflats - City Apartment Prenzlauer Berg 7   \n",
       "3981    18941266         Bed and Coffee at the White Lake in Berlin   \n",
       "2214     2682379                Schnell nach Berlin/S-Grünbergallee   \n",
       "569      4160025                    near by TXL - ruhig & gemütlich   \n",
       "229     12905856  Süßes&helles Zimmer in Berlin-Mitte (U-Bahn Nähe)   \n",
       "3158    23091571                      STYLISH LOW COST BERLIN MITTE   \n",
       "812       883847             Maximilian´s Apartment for friends :-)   \n",
       "3308    13648211                                       CHIC & BASIC   \n",
       "3398    19382941         Modern Penthouse (2 rooms, 62 m², 4 pers.)   \n",
       "2783      564821                Nice 2 Rooms Flat \"Prenzlauer Berg\"   \n",
       "3817     4805605                 Room in Lichtenberg-Friederichsain   \n",
       "4047     1274386                   Wonderful home sightseeing Spree   \n",
       "4098     6691656  Room 40qm + 74qm share f 6-8 pers. southwestce...   \n",
       "2608    18364724               Zimmer in Berlin Mitte. Ladies only.   \n",
       "3306     1236282  Cozy room top location in hip & creative Neukölln   \n",
       "1621    23839778  Amazing room near central station #modern #wel...   \n",
       "1487      187206                                          cozy room   \n",
       "2488     4062245                       *cozy, quiet & central room*   \n",
       "875     16922804  Big, Bright and good located Room in Berlin City!   \n",
       "2894    15560206              Cozy sunny room in Neukölln/Kreuzberg   \n",
       "1604    11099159                Clean Room w/ own Bathroom, Centrum   \n",
       "...          ...                                                ...   \n",
       "1675    29006479                 Shared apartment in Charlottenburg   \n",
       "1673     7360351            Kreuzberg=Welcome=Make yourself at home   \n",
       "1643     1799580                 Big Sunny Room in Berlin Kreuzberg   \n",
       "1644     6970346                       2 Raumwhg. im Friedrichshain   \n",
       "1645    19863635      Bright 2 bedroom apartment in Prenzlauer Berg   \n",
       "1646    27794640   Flat of freedom in the middle of Prenzlauer Berg   \n",
       "1647    22244255   Roof top room beside Lafayette (Friedrichstraße)   \n",
       "1648    26985118    quiet room in big  flat, for professionals only   \n",
       "1649     8870766                       Bright one bedroom apartment   \n",
       "1651    13585638            Charming flat at the heart of Kreuzberg   \n",
       "1652     6231989                Perfect sightseeing location Berlin   \n",
       "1654     3005038                         Nice apartment on the lake   \n",
       "1655     7849941                          Helles Zimmer am Wasser 3   \n",
       "1656    21138745       Elegant room centrally located in schöneberg   \n",
       "1657     4822074                Beautiful apartment - best location   \n",
       "1658     6499198                        Berlin-Charlottenburg 10627   \n",
       "1659    26178507                     Cozy studio at Potsdamer Platz   \n",
       "1660     6553175            4-Zimmer Altbauwohnung, Prenzlauer Berg   \n",
       "1661    24628651        Charming 130qm Apartment in Prenzlauer Berg   \n",
       "1662    26523630             Huge, bright room in artists apartment   \n",
       "1663     4401036                          Sunny Attic Artist Studio   \n",
       "1664     7639962                        Zimmer direkt am Mauerpark!   \n",
       "1665     6652283                   Room (2) in the center of Berlin   \n",
       "1667    25117866       Bright, modern, perfectly equipped Apartment   \n",
       "1668    11715593          Gemütliches Zimmer/Cosy Room in Kreuzberg   \n",
       "1669     3729154                 wonderful apartment next to centre   \n",
       "1670    10651356                   Beautiful room near Main Station   \n",
       "1671    23339442  Spacious and quiet apartment near Prenzlauer Berg   \n",
       "1672    28798099  Cozy studio for 1 or 2 in Bergmannstraße-district   \n",
       "2255    20421098                 cosy rooms in the center of Berlin   \n",
       "\n",
       "        host_id            host_name       neighbourhood_group  \\\n",
       "3342     915430              Andreas             Reinickendorf   \n",
       "2241  161792772                 René                    Pankow   \n",
       "4359    1654885             Claudius                  Neukölln   \n",
       "3812   59073111           Konstantin             Reinickendorf   \n",
       "3681   91074978            Charlotte    Tempelhof - Schöneberg   \n",
       "1834   49815862                Jacob               Lichtenberg   \n",
       "4412   56732023      Robert & Steffi  Friedrichshain-Kreuzberg   \n",
       "2743   59676944                Elena                    Pankow   \n",
       "794    59676944                Elena                    Pankow   \n",
       "1907    1625771                  Ben                    Pankow   \n",
       "3981    3861369      Anderš & Fatima                    Pankow   \n",
       "2214   12781649               Dagmar        Treptow - Köpenick   \n",
       "569    21589042                 Cori                   Spandau   \n",
       "229    70724549             Caroline                     Mitte   \n",
       "3158   95886146              Alcyone                     Mitte   \n",
       "812     4680255  Maximilian Benedikt                     Mitte   \n",
       "3308    1485782             Cristian      Charlottenburg-Wilm.   \n",
       "3398  135868382                 Jörg                     Mitte   \n",
       "2783    1139408                 Romo                    Pankow   \n",
       "3817   24513179                  Des               Lichtenberg   \n",
       "4047    6782131            Christian      Charlottenburg-Wilm.   \n",
       "4098   35024779        Claudio Klaus      Charlottenburg-Wilm.   \n",
       "2608  127146676                 Judy                     Mitte   \n",
       "3306    4647121               Andres                  Neukölln   \n",
       "1621  174755208                 Paul                     Mitte   \n",
       "1487     900521       Angelika-Maria                     Mitte   \n",
       "2488   19827864                 Dany    Tempelhof - Schöneberg   \n",
       "875   113030617             Gabriela    Tempelhof - Schöneberg   \n",
       "2894   42269561                  Jan                  Neukölln   \n",
       "1604   54601187                  Uwe  Friedrichshain-Kreuzberg   \n",
       "...         ...                  ...                       ...   \n",
       "1675  135196610                Sarah      Charlottenburg-Wilm.   \n",
       "1673   38563923               Sabine  Friedrichshain-Kreuzberg   \n",
       "1643    9436682            Christina  Friedrichshain-Kreuzberg   \n",
       "1644   11723994            Christian  Friedrichshain-Kreuzberg   \n",
       "1645  140494435                Maria                    Pankow   \n",
       "1646  139387787                Dario                    Pankow   \n",
       "1647  162542183                 Anne                     Mitte   \n",
       "1648  158600414                  Max  Friedrichshain-Kreuzberg   \n",
       "1649   26073309                Marie                     Mitte   \n",
       "1651   16273210             Isadhora  Friedrichshain-Kreuzberg   \n",
       "1652   31019677               Hae-Ok                     Mitte   \n",
       "1654   15032404                Knuth        Treptow - Köpenick   \n",
       "1655   24064848                 Anne        Treptow - Köpenick   \n",
       "1656   43178346                 Nora                     Mitte   \n",
       "1657   11763608                Marie  Friedrichshain-Kreuzberg   \n",
       "1658   33971648                Britt      Charlottenburg-Wilm.   \n",
       "1659   10583203                Bruno  Friedrichshain-Kreuzberg   \n",
       "1660   33081599                Beate                    Pankow   \n",
       "1661  186123207               Hannah                    Pankow   \n",
       "1662   21859509              Matthew                  Neukölln   \n",
       "1663   12670142               Maansi  Friedrichshain-Kreuzberg   \n",
       "1664   36962507                Julia                    Pankow   \n",
       "1665    8048976                Sonia                     Mitte   \n",
       "1667     843072                 Inna                    Pankow   \n",
       "1668   62288300              Antonia  Friedrichshain-Kreuzberg   \n",
       "1669   13868464             Bünyamin    Tempelhof - Schöneberg   \n",
       "1670   55002456               Gaelle                     Mitte   \n",
       "1671    8723577             Michaela                    Pankow   \n",
       "1672    3789531               Fulvia  Friedrichshain-Kreuzberg   \n",
       "2255   76289121                 Sara  Friedrichshain-Kreuzberg   \n",
       "\n",
       "                            neighbourhood   latitude  longitude  \\\n",
       "3342                                Ost 1  52.561471  13.372684   \n",
       "2241                        Weißensee Ost  52.558733  13.475007   \n",
       "4359             Neuköllner Mitte/Zentrum  52.483888  13.428707   \n",
       "3812                               West 4  52.565287  13.325170   \n",
       "3681                            Friedenau  52.473107  13.344343   \n",
       "1834             Alt-Hohenschönhausen Süd  52.535306  13.475582   \n",
       "4412               Frankfurter Allee Nord  52.518563  13.468847   \n",
       "2743                  Prenzlauer Berg Süd  52.541630  13.425360   \n",
       "794                        Helmholtzplatz  52.543037  13.423437   \n",
       "1907             Prenzlauer Berg Nordwest  52.550908  13.404553   \n",
       "3981                            Weißensee  52.557100  13.464744   \n",
       "2214                            Bohnsdorf  52.398575  13.540094   \n",
       "569                          Siemensstadt  52.542121  13.270085   \n",
       "229                         Osloer Straße  52.558164  13.379885   \n",
       "3158                      Brunnenstr. Süd  52.530346  13.388507   \n",
       "812                       Wedding Zentrum  52.548879  13.362741   \n",
       "3308                  Düsseldorfer Straße  52.496539  13.332558   \n",
       "3398                     Brunnenstr. Nord  52.542560  13.375550   \n",
       "2783                 Prenzlauer Berg Nord  52.546618  13.437788   \n",
       "3817                Frankfurter Allee Süd  52.511968  13.489051   \n",
       "4047                     Mierendorffplatz  52.521461  13.303179   \n",
       "4098                Volkspark Wilmersdorf  52.488032  13.325617   \n",
       "2608                           Moabit Ost  52.522131  13.354282   \n",
       "3306                         Reuterstraße  52.487047  13.434452   \n",
       "1621                           Moabit Ost  52.521275  13.354157   \n",
       "1487                        Osloer Straße  52.563345  13.388022   \n",
       "2488                       Schöneberg-Süd  52.480679  13.362490   \n",
       "875                       Schöneberg-Nord  52.497937  13.362255   \n",
       "2894                         Reuterstraße  52.491797  13.428550   \n",
       "1604               Frankfurter Allee Nord  52.515070  13.467139   \n",
       "...                                   ...        ...        ...   \n",
       "1675                      Neue Kantstraße  52.507132  13.289530   \n",
       "1673                nördliche Luisenstadt  52.504074  13.418903   \n",
       "1643                 südliche Luisenstadt  52.497227  13.436016   \n",
       "1644                 Karl-Marx-Allee-Nord  52.521854  13.447621   \n",
       "1645                  Prenzlauer Berg Süd  52.531690  13.436142   \n",
       "1646             Prenzlauer Berg Nordwest  52.552963  13.409962   \n",
       "1647                    Regierungsviertel  52.514036  13.387764   \n",
       "1648                 Tempelhofer Vorstadt  52.498197  13.386906   \n",
       "1649                      Wedding Zentrum  52.549642  13.359687   \n",
       "1651                 südliche Luisenstadt  52.493702  13.431392   \n",
       "1652                       Alexanderplatz  52.521582  13.404417   \n",
       "1654                      Friedrichshagen  52.453130  13.627366   \n",
       "1655                    Niederschöneweide  52.453982  13.522592   \n",
       "1656                       Tiergarten Süd  52.505033  13.346577   \n",
       "1657             Frankfurter Allee Süd FK  52.511800  13.458939   \n",
       "1658                Schloß Charlottenburg  52.511074  13.300372   \n",
       "1659              Südliche Friedrichstadt  52.503651  13.375158   \n",
       "1660                 Prenzlauer Berg Nord  52.551951  13.419783   \n",
       "1661                       Helmholtzplatz  52.540739  13.419368   \n",
       "1662                              Rixdorf  52.486813  13.451088   \n",
       "1663             Frankfurter Allee Süd FK  52.511280  13.467690   \n",
       "1664             Prenzlauer Berg Nordwest  52.541928  13.410104   \n",
       "1665                      Brunnenstr. Süd  52.533458  13.395935   \n",
       "1667                            Weißensee  52.554149  13.429590   \n",
       "1668                nördliche Luisenstadt  52.500629  13.429265   \n",
       "1669                            Tempelhof  52.458034  13.387861   \n",
       "1670                           Moabit Ost  52.535793  13.356935   \n",
       "1671  Blankenburg/Heinersdorf/Märchenland  52.563515  13.427477   \n",
       "1672                 Tempelhofer Vorstadt  52.490515  13.380739   \n",
       "2255                 Tempelhofer Vorstadt  52.492775  13.381960   \n",
       "\n",
       "            room_type  price  minimum_nights  number_of_reviews last_review  \\\n",
       "3342  Entire home/apt     18               2                186  2018-11-03   \n",
       "2241  Entire home/apt     35               1                 56  2018-10-30   \n",
       "4359  Entire home/apt     36               3                197  2018-10-27   \n",
       "3812     Private room     10               1                 82  2018-10-30   \n",
       "3681  Entire home/apt     38               2                 53  2018-11-04   \n",
       "1834     Private room     14               3                153  2018-11-01   \n",
       "4412  Entire home/apt     40               1                125  2018-10-19   \n",
       "2743  Entire home/apt     40               2                125  2018-10-21   \n",
       "794   Entire home/apt     40               2                121  2018-10-23   \n",
       "1907  Entire home/apt     42               1                 60  2018-11-02   \n",
       "3981     Private room     20               1                 57  2018-11-04   \n",
       "2214     Private room     20               1                127  2018-09-16   \n",
       "569      Private room     20               1                 54  2018-10-17   \n",
       "229      Private room     21               1                141  2018-10-31   \n",
       "3158  Entire home/apt     45               1                 70  2018-11-02   \n",
       "812   Entire home/apt     45               3                 72  2018-10-09   \n",
       "3308  Entire home/apt     45               3                 54  2018-10-22   \n",
       "3398  Entire home/apt     45               1                 97  2018-10-24   \n",
       "2783  Entire home/apt     46               2                146  2018-10-23   \n",
       "3817     Private room     23               3                 87  2018-07-08   \n",
       "4047     Private room     23               1                122  2018-09-21   \n",
       "4098     Private room     24               1                 92  2018-11-03   \n",
       "2608     Private room     24               1                116  2018-10-24   \n",
       "3306     Private room     25               2                171  2018-10-26   \n",
       "1621     Private room     25               1                 53  2018-11-04   \n",
       "1487     Private room     25               2                224  2018-11-04   \n",
       "2488     Private room     25               2                 51  2018-09-23   \n",
       "875      Private room     25               3                 67  2018-10-14   \n",
       "2894     Private room     25               2                 57  2018-10-31   \n",
       "1604     Private room     25               1                200  2018-10-16   \n",
       "...               ...    ...             ...                ...         ...   \n",
       "1675     Private room     15               5                  1  2018-10-20   \n",
       "1673  Entire home/apt    120               3                 60  2018-11-02   \n",
       "1643     Private room     65               3                 15  2017-01-02   \n",
       "1644  Entire home/apt     55               7                  7  2016-09-22   \n",
       "1645  Entire home/apt    109              30                 42  2018-10-28   \n",
       "1646  Entire home/apt     50               2                  1  2018-08-21   \n",
       "1647     Private room     35               2                 21  2018-05-14   \n",
       "1648     Private room     25              14                  2  2018-10-07   \n",
       "1649  Entire home/apt     36               2                 41  2018-05-20   \n",
       "1651     Private room     35               2                  0         NaN   \n",
       "1652  Entire home/apt    104               3                129  2018-10-22   \n",
       "1654  Entire home/apt     47              14                  1  2014-08-15   \n",
       "1655     Private room     23               4                 74  2018-10-23   \n",
       "1656     Private room     32               2                 52  2018-03-30   \n",
       "1657  Entire home/apt     45               4                 17  2018-08-20   \n",
       "1658  Entire home/apt     81               3                  0         NaN   \n",
       "1659  Entire home/apt     44               6                  5  2018-10-31   \n",
       "1660  Entire home/apt     87               9                  3  2017-08-20   \n",
       "1661  Entire home/apt    140               2                  5  2018-08-04   \n",
       "1662     Private room     34               2                  2  2018-08-27   \n",
       "1663     Private room    115               3                  9  2017-05-02   \n",
       "1664  Entire home/apt     27               4                  7  2017-05-29   \n",
       "1665     Private room     60               3                  3  2016-07-04   \n",
       "1667  Entire home/apt     50               2                  0         NaN   \n",
       "1668     Private room     20              10                  9  2018-02-20   \n",
       "1669  Entire home/apt     99               2                  2  2015-09-15   \n",
       "1670     Private room     25               2                  3  2016-02-17   \n",
       "1671  Entire home/apt     80               7                  6  2018-09-25   \n",
       "1672  Entire home/apt     55               3                  4  2018-10-22   \n",
       "2255     Private room     50               2                  1  2017-09-04   \n",
       "\n",
       "      reviews_per_month  calculated_host_listings_count  availability_365  \\\n",
       "3342               2.91                               2                73   \n",
       "2241               7.74                               1               205   \n",
       "4359               2.56                              11               248   \n",
       "3812               4.60                               3                16   \n",
       "3681               2.89                               1                 1   \n",
       "1834               5.04                               2                58   \n",
       "4412               3.76                               1                10   \n",
       "2743               3.97                               2               121   \n",
       "794                3.75                               2               136   \n",
       "1907               3.14                              45               121   \n",
       "3981               3.33                               1                39   \n",
       "2214               2.38                               4               195   \n",
       "569                1.08                               1                48   \n",
       "229                8.25                               1                33   \n",
       "3158               7.87                               4               106   \n",
       "812                1.04                               1               294   \n",
       "3308               1.88                               5               280   \n",
       "3398               7.31                               2               347   \n",
       "2783               1.89                               2               297   \n",
       "3817               1.86                               2                37   \n",
       "4047               2.01                               3                92   \n",
       "4098               2.44                               4               334   \n",
       "2608               6.34                               1               254   \n",
       "3306               2.67                               2                63   \n",
       "1621               7.13                               2                78   \n",
       "1487               2.63                               1               322   \n",
       "2488               1.04                               1                40   \n",
       "875                3.11                               1                10   \n",
       "2894               2.38                               2                86   \n",
       "1604               6.17                               7               260   \n",
       "...                 ...                             ...               ...   \n",
       "1675               1.00                               1                67   \n",
       "1673               1.50                               1               324   \n",
       "1643               0.25                               1                 0   \n",
       "1644               0.17                               1                 0   \n",
       "1645               2.69                               1               207   \n",
       "1646               0.38                               2                83   \n",
       "1647               2.16                               1                 0   \n",
       "1648               0.73                               2                32   \n",
       "1649               2.13                               1                 0   \n",
       "1651                NaN                               1                 0   \n",
       "1652               3.14                               2               218   \n",
       "1654               0.02                               1                 0   \n",
       "1655               1.90                               3                84   \n",
       "1656               3.88                               1                 0   \n",
       "1657               0.36                               1               165   \n",
       "1658                NaN                               1                 0   \n",
       "1659               1.65                               1                17   \n",
       "1660               0.08                               1               304   \n",
       "1661               1.18                               1                 0   \n",
       "1662               0.52                               1                33   \n",
       "1663               0.19                               1               284   \n",
       "1664               0.24                               2                 0   \n",
       "1665               0.07                               5               129   \n",
       "1667                NaN                               1                94   \n",
       "1668               0.28                               1                 0   \n",
       "1669               0.05                               1                 0   \n",
       "1670               0.09                               1                 0   \n",
       "1671               0.77                               1                 0   \n",
       "1672               3.16                               5               287   \n",
       "2255               0.07                               1                 0   \n",
       "\n",
       "      score  room_type_score  prize_score  review_score  \n",
       "3342  0.820              1.0         0.82           1.0  \n",
       "2241  0.650              1.0         0.65           1.0  \n",
       "4359  0.640              1.0         0.64           1.0  \n",
       "3812  0.630              0.7         0.90           1.0  \n",
       "3681  0.620              1.0         0.62           1.0  \n",
       "1834  0.602              0.7         0.86           1.0  \n",
       "4412  0.600              1.0         0.60           1.0  \n",
       "2743  0.600              1.0         0.60           1.0  \n",
       "794   0.600              1.0         0.60           1.0  \n",
       "1907  0.580              1.0         0.58           1.0  \n",
       "3981  0.560              0.7         0.80           1.0  \n",
       "2214  0.560              0.7         0.80           1.0  \n",
       "569   0.560              0.7         0.80           1.0  \n",
       "229   0.553              0.7         0.79           1.0  \n",
       "3158  0.550              1.0         0.55           1.0  \n",
       "812   0.550              1.0         0.55           1.0  \n",
       "3308  0.550              1.0         0.55           1.0  \n",
       "3398  0.550              1.0         0.55           1.0  \n",
       "2783  0.540              1.0         0.54           1.0  \n",
       "3817  0.539              0.7         0.77           1.0  \n",
       "4047  0.539              0.7         0.77           1.0  \n",
       "4098  0.532              0.7         0.76           1.0  \n",
       "2608  0.532              0.7         0.76           1.0  \n",
       "3306  0.525              0.7         0.75           1.0  \n",
       "1621  0.525              0.7         0.75           1.0  \n",
       "1487  0.525              0.7         0.75           1.0  \n",
       "2488  0.525              0.7         0.75           1.0  \n",
       "875   0.525              0.7         0.75           1.0  \n",
       "2894  0.525              0.7         0.75           1.0  \n",
       "1604  0.525              0.7         0.75           1.0  \n",
       "...     ...              ...          ...           ...  \n",
       "1675  0.000              0.7         0.85           0.5  \n",
       "1673  0.000              1.0        -0.20           1.0  \n",
       "1643  0.000              0.7         0.35           0.5  \n",
       "1644  0.000              1.0         0.45           0.5  \n",
       "1645  0.000              1.0        -0.09           0.5  \n",
       "1646  0.000              1.0         0.50           0.5  \n",
       "1647  0.000              0.7         0.65           0.5  \n",
       "1648  0.000              0.7         0.75           0.5  \n",
       "1649  0.000              1.0         0.64           0.5  \n",
       "1651  0.000              0.7         0.65           0.5  \n",
       "1652  0.000              1.0        -0.04           1.0  \n",
       "1654  0.000              1.0         0.53           0.5  \n",
       "1655  0.000              0.7         0.77           1.0  \n",
       "1656  0.000              0.7         0.68           1.0  \n",
       "1657  0.000              1.0         0.55           0.5  \n",
       "1658  0.000              1.0         0.19           0.5  \n",
       "1659  0.000              1.0         0.56           0.5  \n",
       "1660  0.000              1.0         0.13           0.5  \n",
       "1661  0.000              1.0        -0.40           0.5  \n",
       "1662  0.000              0.7         0.66           0.5  \n",
       "1663  0.000              0.7        -0.15           0.5  \n",
       "1664  0.000              1.0         0.73           0.5  \n",
       "1665  0.000              0.7         0.40           0.5  \n",
       "1667  0.000              1.0         0.50           0.5  \n",
       "1668  0.000              0.7         0.80           0.5  \n",
       "1669  0.000              1.0         0.01           0.5  \n",
       "1670  0.000              0.7         0.75           0.5  \n",
       "1671  0.000              1.0         0.20           0.5  \n",
       "1672  0.000              1.0         0.45           0.5  \n",
       "2255  0.000              0.7         0.50           0.5  \n",
       "\n",
       "[4510 rows x 20 columns]"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "listings.sort_values('score', ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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>listing_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>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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>room_type</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>Entire home/apt</th>\n",
       "      <td>2175</td>\n",
       "      <td>2171</td>\n",
       "      <td>2175</td>\n",
       "      <td>2171</td>\n",
       "      <td>2175</td>\n",
       "      <td>2175</td>\n",
       "      <td>2175</td>\n",
       "      <td>2175</td>\n",
       "      <td>2175</td>\n",
       "      <td>2175</td>\n",
       "      <td>2175</td>\n",
       "      <td>1815</td>\n",
       "      <td>1814</td>\n",
       "      <td>2175</td>\n",
       "      <td>2175</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Private room</th>\n",
       "      <td>2281</td>\n",
       "      <td>2278</td>\n",
       "      <td>2281</td>\n",
       "      <td>2280</td>\n",
       "      <td>2281</td>\n",
       "      <td>2281</td>\n",
       "      <td>2281</td>\n",
       "      <td>2281</td>\n",
       "      <td>2281</td>\n",
       "      <td>2281</td>\n",
       "      <td>2281</td>\n",
       "      <td>1890</td>\n",
       "      <td>1888</td>\n",
       "      <td>2281</td>\n",
       "      <td>2281</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Shared room</th>\n",
       "      <td>54</td>\n",
       "      <td>54</td>\n",
       "      <td>54</td>\n",
       "      <td>54</td>\n",
       "      <td>54</td>\n",
       "      <td>54</td>\n",
       "      <td>54</td>\n",
       "      <td>54</td>\n",
       "      <td>54</td>\n",
       "      <td>54</td>\n",
       "      <td>54</td>\n",
       "      <td>40</td>\n",
       "      <td>40</td>\n",
       "      <td>54</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 listing_id  name  host_id  host_name  neighbourhood_group  \\\n",
       "room_type                                                                    \n",
       "Entire home/apt        2175  2171     2175       2171                 2175   \n",
       "Private room           2281  2278     2281       2280                 2281   \n",
       "Shared room              54    54       54         54                   54   \n",
       "\n",
       "                 neighbourhood  latitude  longitude  price  minimum_nights  \\\n",
       "room_type                                                                    \n",
       "Entire home/apt           2175      2175       2175   2175            2175   \n",
       "Private room              2281      2281       2281   2281            2281   \n",
       "Shared room                 54        54         54     54              54   \n",
       "\n",
       "                 number_of_reviews  last_review  reviews_per_month  \\\n",
       "room_type                                                            \n",
       "Entire home/apt               2175         1815               1814   \n",
       "Private room                  2281         1890               1888   \n",
       "Shared room                     54           40                 40   \n",
       "\n",
       "                 calculated_host_listings_count  availability_365  \n",
       "room_type                                                          \n",
       "Entire home/apt                            2175              2175  \n",
       "Private room                               2281              2281  \n",
       "Shared room                                  54                54  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "listings.groupby('room_type').count()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Indexing"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "blabla = 0"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Memory efficiency"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "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.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}