Rent data for Glasgow.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Python practise file\n",
    "\n",
    "## Use pandas, filter and explore Zoopla data on mean rent and number of adverts by local authority\n",
    "\n",
    "### Source for Zoopla data: UBDC http://ubdc.gla.ac.uk/dataset/zoopla-property-data/resource/b3523cc0-104c-4f79-affa-ba8c2ecb004d "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import glob"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Import csv files"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "metadata": {},
   "outputs": [],
   "source": [
    "rent_by_la = pd.read_csv(r\"C:\\Users\\johan\\Zoopla\\rentbyla.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "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>authority_code</th>\n",
       "      <th>authority_name</th>\n",
       "      <th>year</th>\n",
       "      <th>quarter</th>\n",
       "      <th>mean_rent_per_month</th>\n",
       "      <th>median_rent_per_month</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>E06000001</td>\n",
       "      <td>Hartlepool</td>\n",
       "      <td>2011</td>\n",
       "      <td>4</td>\n",
       "      <td>517.837838</td>\n",
       "      <td>450.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>E06000001</td>\n",
       "      <td>Hartlepool</td>\n",
       "      <td>2012</td>\n",
       "      <td>4</td>\n",
       "      <td>524.358209</td>\n",
       "      <td>477.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>E06000001</td>\n",
       "      <td>Hartlepool</td>\n",
       "      <td>2012</td>\n",
       "      <td>3</td>\n",
       "      <td>491.654206</td>\n",
       "      <td>450.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>E06000001</td>\n",
       "      <td>Hartlepool</td>\n",
       "      <td>2012</td>\n",
       "      <td>2</td>\n",
       "      <td>492.138889</td>\n",
       "      <td>450.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>E06000001</td>\n",
       "      <td>Hartlepool</td>\n",
       "      <td>2012</td>\n",
       "      <td>1</td>\n",
       "      <td>455.589744</td>\n",
       "      <td>464.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  authority_code authority_name  year  quarter  mean_rent_per_month  \\\n",
       "0      E06000001     Hartlepool  2011        4           517.837838   \n",
       "1      E06000001     Hartlepool  2012        4           524.358209   \n",
       "2      E06000001     Hartlepool  2012        3           491.654206   \n",
       "3      E06000001     Hartlepool  2012        2           492.138889   \n",
       "4      E06000001     Hartlepool  2012        1           455.589744   \n",
       "\n",
       "   median_rent_per_month  \n",
       "0                  450.0  \n",
       "1                  477.5  \n",
       "2                  450.0  \n",
       "3                  450.0  \n",
       "4                  464.0  "
      ]
     },
     "execution_count": 74,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rent_by_la.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "metadata": {},
   "outputs": [],
   "source": [
    "num_adverts = pd.read_csv(r\"C:\\Users\\johan\\Zoopla\\countofnumberadverts.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "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>authority_code</th>\n",
       "      <th>authority_name</th>\n",
       "      <th>year</th>\n",
       "      <th>quarter</th>\n",
       "      <th>num_adverts</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>E06000001</td>\n",
       "      <td>Hartlepool</td>\n",
       "      <td>2011</td>\n",
       "      <td>4</td>\n",
       "      <td>74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>E06000001</td>\n",
       "      <td>Hartlepool</td>\n",
       "      <td>2012</td>\n",
       "      <td>2</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>E06000001</td>\n",
       "      <td>Hartlepool</td>\n",
       "      <td>2012</td>\n",
       "      <td>3</td>\n",
       "      <td>107</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>E06000001</td>\n",
       "      <td>Hartlepool</td>\n",
       "      <td>2012</td>\n",
       "      <td>4</td>\n",
       "      <td>67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>E06000001</td>\n",
       "      <td>Hartlepool</td>\n",
       "      <td>2012</td>\n",
       "      <td>1</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  authority_code authority_name  year  quarter  num_adverts\n",
       "0      E06000001     Hartlepool  2011        4           74\n",
       "1      E06000001     Hartlepool  2012        2           72\n",
       "2      E06000001     Hartlepool  2012        3          107\n",
       "3      E06000001     Hartlepool  2012        4           67\n",
       "4      E06000001     Hartlepool  2012        1           39"
      ]
     },
     "execution_count": 76,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "num_adverts.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Merge csv files\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 137,
   "metadata": {},
   "outputs": [],
   "source": [
    "# \n",
    "Zoopla_Rent = rent_by_la.merge(num_adverts, how= 'left', on=['authority_code', 'year', 'quarter'], \n",
    "                             indicator = (True), validate=('1:m'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 138,
   "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>authority_code</th>\n",
       "      <th>authority_name_x</th>\n",
       "      <th>year</th>\n",
       "      <th>quarter</th>\n",
       "      <th>mean_rent_per_month</th>\n",
       "      <th>median_rent_per_month</th>\n",
       "      <th>authority_name_y</th>\n",
       "      <th>num_adverts</th>\n",
       "      <th>_merge</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>E06000001</td>\n",
       "      <td>Hartlepool</td>\n",
       "      <td>2011</td>\n",
       "      <td>4</td>\n",
       "      <td>517.837838</td>\n",
       "      <td>450.0</td>\n",
       "      <td>Hartlepool</td>\n",
       "      <td>74</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>E06000001</td>\n",
       "      <td>Hartlepool</td>\n",
       "      <td>2012</td>\n",
       "      <td>4</td>\n",
       "      <td>524.358209</td>\n",
       "      <td>477.5</td>\n",
       "      <td>Hartlepool</td>\n",
       "      <td>67</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>E06000001</td>\n",
       "      <td>Hartlepool</td>\n",
       "      <td>2012</td>\n",
       "      <td>3</td>\n",
       "      <td>491.654206</td>\n",
       "      <td>450.0</td>\n",
       "      <td>Hartlepool</td>\n",
       "      <td>107</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>E06000001</td>\n",
       "      <td>Hartlepool</td>\n",
       "      <td>2012</td>\n",
       "      <td>2</td>\n",
       "      <td>492.138889</td>\n",
       "      <td>450.0</td>\n",
       "      <td>Hartlepool</td>\n",
       "      <td>72</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>E06000001</td>\n",
       "      <td>Hartlepool</td>\n",
       "      <td>2012</td>\n",
       "      <td>1</td>\n",
       "      <td>455.589744</td>\n",
       "      <td>464.0</td>\n",
       "      <td>Hartlepool</td>\n",
       "      <td>39</td>\n",
       "      <td>both</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8861</th>\n",
       "      <td>W06000024</td>\n",
       "      <td>Merthyr Tydfil</td>\n",
       "      <td>2015</td>\n",
       "      <td>4</td>\n",
       "      <td>456.739130</td>\n",
       "      <td>445.0</td>\n",
       "      <td>Merthyr Tydfil</td>\n",
       "      <td>46</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8862</th>\n",
       "      <td>W06000024</td>\n",
       "      <td>Merthyr Tydfil</td>\n",
       "      <td>2016</td>\n",
       "      <td>4</td>\n",
       "      <td>461.764706</td>\n",
       "      <td>450.0</td>\n",
       "      <td>Merthyr Tydfil</td>\n",
       "      <td>34</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8863</th>\n",
       "      <td>W06000024</td>\n",
       "      <td>Merthyr Tydfil</td>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>448.133333</td>\n",
       "      <td>450.0</td>\n",
       "      <td>Merthyr Tydfil</td>\n",
       "      <td>30</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8864</th>\n",
       "      <td>W06000024</td>\n",
       "      <td>Merthyr Tydfil</td>\n",
       "      <td>2016</td>\n",
       "      <td>3</td>\n",
       "      <td>453.125000</td>\n",
       "      <td>450.0</td>\n",
       "      <td>Merthyr Tydfil</td>\n",
       "      <td>48</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8865</th>\n",
       "      <td>W06000024</td>\n",
       "      <td>Merthyr Tydfil</td>\n",
       "      <td>2016</td>\n",
       "      <td>2</td>\n",
       "      <td>473.333333</td>\n",
       "      <td>450.0</td>\n",
       "      <td>Merthyr Tydfil</td>\n",
       "      <td>39</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8866 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     authority_code authority_name_x  year  quarter  mean_rent_per_month  \\\n",
       "0         E06000001       Hartlepool  2011        4           517.837838   \n",
       "1         E06000001       Hartlepool  2012        4           524.358209   \n",
       "2         E06000001       Hartlepool  2012        3           491.654206   \n",
       "3         E06000001       Hartlepool  2012        2           492.138889   \n",
       "4         E06000001       Hartlepool  2012        1           455.589744   \n",
       "...             ...              ...   ...      ...                  ...   \n",
       "8861      W06000024   Merthyr Tydfil  2015        4           456.739130   \n",
       "8862      W06000024   Merthyr Tydfil  2016        4           461.764706   \n",
       "8863      W06000024   Merthyr Tydfil  2016        1           448.133333   \n",
       "8864      W06000024   Merthyr Tydfil  2016        3           453.125000   \n",
       "8865      W06000024   Merthyr Tydfil  2016        2           473.333333   \n",
       "\n",
       "      median_rent_per_month authority_name_y  num_adverts _merge  \n",
       "0                     450.0       Hartlepool           74   both  \n",
       "1                     477.5       Hartlepool           67   both  \n",
       "2                     450.0       Hartlepool          107   both  \n",
       "3                     450.0       Hartlepool           72   both  \n",
       "4                     464.0       Hartlepool           39   both  \n",
       "...                     ...              ...          ...    ...  \n",
       "8861                  445.0   Merthyr Tydfil           46   both  \n",
       "8862                  450.0   Merthyr Tydfil           34   both  \n",
       "8863                  450.0   Merthyr Tydfil           30   both  \n",
       "8864                  450.0   Merthyr Tydfil           48   both  \n",
       "8865                  450.0   Merthyr Tydfil           39   both  \n",
       "\n",
       "[8866 rows x 9 columns]"
      ]
     },
     "execution_count": 138,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Zoopla_Rent"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 151,
   "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>authority_code</th>\n",
       "      <th>authority_name_x</th>\n",
       "      <th>year</th>\n",
       "      <th>quarter</th>\n",
       "      <th>mean_rent_per_month</th>\n",
       "      <th>median_rent_per_month</th>\n",
       "      <th>authority_name_y</th>\n",
       "      <th>num_adverts</th>\n",
       "      <th>_merge</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>E06000001</td>\n",
       "      <td>Hartlepool</td>\n",
       "      <td>2011</td>\n",
       "      <td>4</td>\n",
       "      <td>517.837838</td>\n",
       "      <td>450.0</td>\n",
       "      <td>Hartlepool</td>\n",
       "      <td>74</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>E06000001</td>\n",
       "      <td>Hartlepool</td>\n",
       "      <td>2016</td>\n",
       "      <td>2</td>\n",
       "      <td>469.837696</td>\n",
       "      <td>450.0</td>\n",
       "      <td>Hartlepool</td>\n",
       "      <td>191</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>E06000001</td>\n",
       "      <td>Hartlepool</td>\n",
       "      <td>2016</td>\n",
       "      <td>4</td>\n",
       "      <td>481.822785</td>\n",
       "      <td>470.0</td>\n",
       "      <td>Hartlepool</td>\n",
       "      <td>79</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>E06000001</td>\n",
       "      <td>Hartlepool</td>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>445.181818</td>\n",
       "      <td>433.0</td>\n",
       "      <td>Hartlepool</td>\n",
       "      <td>154</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>E06000001</td>\n",
       "      <td>Hartlepool</td>\n",
       "      <td>2016</td>\n",
       "      <td>3</td>\n",
       "      <td>469.081482</td>\n",
       "      <td>457.0</td>\n",
       "      <td>Hartlepool</td>\n",
       "      <td>135</td>\n",
       "      <td>both</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>E06000009</td>\n",
       "      <td>Blackpool</td>\n",
       "      <td>2011</td>\n",
       "      <td>1</td>\n",
       "      <td>554.395349</td>\n",
       "      <td>542.0</td>\n",
       "      <td>Blackpool</td>\n",
       "      <td>129</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>E06000009</td>\n",
       "      <td>Blackpool</td>\n",
       "      <td>2011</td>\n",
       "      <td>2</td>\n",
       "      <td>527.559783</td>\n",
       "      <td>524.0</td>\n",
       "      <td>Blackpool</td>\n",
       "      <td>184</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>202</th>\n",
       "      <td>E06000010</td>\n",
       "      <td>Kingston upon Hull, City of</td>\n",
       "      <td>2011</td>\n",
       "      <td>2</td>\n",
       "      <td>462.530275</td>\n",
       "      <td>446.0</td>\n",
       "      <td>Kingston upon Hull, City of</td>\n",
       "      <td>545</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203</th>\n",
       "      <td>E06000010</td>\n",
       "      <td>Kingston upon Hull, City of</td>\n",
       "      <td>2011</td>\n",
       "      <td>1</td>\n",
       "      <td>471.699627</td>\n",
       "      <td>446.0</td>\n",
       "      <td>Kingston upon Hull, City of</td>\n",
       "      <td>536</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229</th>\n",
       "      <td>E06000011</td>\n",
       "      <td>East Riding of Yorkshire</td>\n",
       "      <td>2011</td>\n",
       "      <td>1</td>\n",
       "      <td>550.199446</td>\n",
       "      <td>498.0</td>\n",
       "      <td>East Riding of Yorkshire</td>\n",
       "      <td>361</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>120 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    authority_code             authority_name_x  year  quarter  \\\n",
       "0        E06000001                   Hartlepool  2011        4   \n",
       "20       E06000001                   Hartlepool  2016        2   \n",
       "19       E06000001                   Hartlepool  2016        4   \n",
       "18       E06000001                   Hartlepool  2016        1   \n",
       "17       E06000001                   Hartlepool  2016        3   \n",
       "..             ...                          ...   ...      ...   \n",
       "181      E06000009                    Blackpool  2011        1   \n",
       "180      E06000009                    Blackpool  2011        2   \n",
       "202      E06000010  Kingston upon Hull, City of  2011        2   \n",
       "203      E06000010  Kingston upon Hull, City of  2011        1   \n",
       "229      E06000011     East Riding of Yorkshire  2011        1   \n",
       "\n",
       "     mean_rent_per_month  median_rent_per_month             authority_name_y  \\\n",
       "0             517.837838                  450.0                   Hartlepool   \n",
       "20            469.837696                  450.0                   Hartlepool   \n",
       "19            481.822785                  470.0                   Hartlepool   \n",
       "18            445.181818                  433.0                   Hartlepool   \n",
       "17            469.081482                  457.0                   Hartlepool   \n",
       "..                   ...                    ...                          ...   \n",
       "181           554.395349                  542.0                    Blackpool   \n",
       "180           527.559783                  524.0                    Blackpool   \n",
       "202           462.530275                  446.0  Kingston upon Hull, City of   \n",
       "203           471.699627                  446.0  Kingston upon Hull, City of   \n",
       "229           550.199446                  498.0     East Riding of Yorkshire   \n",
       "\n",
       "     num_adverts _merge  \n",
       "0             74   both  \n",
       "20           191   both  \n",
       "19            79   both  \n",
       "18           154   both  \n",
       "17           135   both  \n",
       "..           ...    ...  \n",
       "181          129   both  \n",
       "180          184   both  \n",
       "202          545   both  \n",
       "203          536   both  \n",
       "229          361   both  \n",
       "\n",
       "[120 rows x 9 columns]"
      ]
     },
     "execution_count": 151,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# did the merge do what we want? look at year and quarter\n",
    "\n",
    "rentdata = Zoopla_Rent.sort_values('authority_code').groupby(['year', 'quarter'])\n",
    "rentdata.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 152,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['authority_code' 'authority_name_x' 'year' 'quarter'\n",
      " 'mean_rent_per_month' 'median_rent_per_month' 'authority_name_y'\n",
      " 'num_adverts' '_merge']\n"
     ]
    }
   ],
   "source": [
    "# what variables \n",
    "\n",
    "print(Zoopla_Rent.columns.values)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "\n",
    "#### Slice only data from Glasgow"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 153,
   "metadata": {},
   "outputs": [],
   "source": [
    "glasgow = Zoopla_Rent[Zoopla_Rent.authority_name_y == 'Glasgow City']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 154,
   "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>authority_code</th>\n",
       "      <th>authority_name_x</th>\n",
       "      <th>year</th>\n",
       "      <th>quarter</th>\n",
       "      <th>mean_rent_per_month</th>\n",
       "      <th>median_rent_per_month</th>\n",
       "      <th>authority_name_y</th>\n",
       "      <th>num_adverts</th>\n",
       "      <th>_merge</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>8330</th>\n",
       "      <td>S12000046</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>2011</td>\n",
       "      <td>2</td>\n",
       "      <td>582.192308</td>\n",
       "      <td>559.0</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>52</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8331</th>\n",
       "      <td>S12000046</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>2011</td>\n",
       "      <td>1</td>\n",
       "      <td>587.500000</td>\n",
       "      <td>524.0</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>52</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8332</th>\n",
       "      <td>S12000046</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>2011</td>\n",
       "      <td>4</td>\n",
       "      <td>635.152632</td>\n",
       "      <td>575.0</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>190</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8333</th>\n",
       "      <td>S12000046</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>2011</td>\n",
       "      <td>3</td>\n",
       "      <td>593.172840</td>\n",
       "      <td>546.0</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>162</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8334</th>\n",
       "      <td>S12000046</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>2012</td>\n",
       "      <td>4</td>\n",
       "      <td>574.802013</td>\n",
       "      <td>525.0</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>596</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     authority_code authority_name_x  year  quarter  mean_rent_per_month  \\\n",
       "8330      S12000046     Glasgow City  2011        2           582.192308   \n",
       "8331      S12000046     Glasgow City  2011        1           587.500000   \n",
       "8332      S12000046     Glasgow City  2011        4           635.152632   \n",
       "8333      S12000046     Glasgow City  2011        3           593.172840   \n",
       "8334      S12000046     Glasgow City  2012        4           574.802013   \n",
       "\n",
       "      median_rent_per_month authority_name_y  num_adverts _merge  \n",
       "8330                  559.0     Glasgow City           52   both  \n",
       "8331                  524.0     Glasgow City           52   both  \n",
       "8332                  575.0     Glasgow City          190   both  \n",
       "8333                  546.0     Glasgow City          162   both  \n",
       "8334                  525.0     Glasgow City          596   both  "
      ]
     },
     "execution_count": 154,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "glasgow.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Describe data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 155,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(24, 9)"
      ]
     },
     "execution_count": 155,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "glasgow.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 156,
   "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>year</th>\n",
       "      <th>quarter</th>\n",
       "      <th>mean_rent_per_month</th>\n",
       "      <th>median_rent_per_month</th>\n",
       "      <th>num_adverts</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>24.000000</td>\n",
       "      <td>24.00000</td>\n",
       "      <td>24.000000</td>\n",
       "      <td>24.000000</td>\n",
       "      <td>24.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>2013.500000</td>\n",
       "      <td>2.50000</td>\n",
       "      <td>637.570040</td>\n",
       "      <td>561.291667</td>\n",
       "      <td>598.416667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>1.744557</td>\n",
       "      <td>1.14208</td>\n",
       "      <td>57.774324</td>\n",
       "      <td>27.815353</td>\n",
       "      <td>338.694670</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>2011.000000</td>\n",
       "      <td>1.00000</td>\n",
       "      <td>569.500000</td>\n",
       "      <td>524.000000</td>\n",
       "      <td>52.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>2012.000000</td>\n",
       "      <td>1.75000</td>\n",
       "      <td>587.820833</td>\n",
       "      <td>546.000000</td>\n",
       "      <td>459.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>2013.500000</td>\n",
       "      <td>2.50000</td>\n",
       "      <td>642.839136</td>\n",
       "      <td>550.000000</td>\n",
       "      <td>640.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>2015.000000</td>\n",
       "      <td>3.25000</td>\n",
       "      <td>673.157388</td>\n",
       "      <td>578.750000</td>\n",
       "      <td>739.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>2016.000000</td>\n",
       "      <td>4.00000</td>\n",
       "      <td>798.225150</td>\n",
       "      <td>625.000000</td>\n",
       "      <td>1670.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              year   quarter  mean_rent_per_month  median_rent_per_month  \\\n",
       "count    24.000000  24.00000            24.000000              24.000000   \n",
       "mean   2013.500000   2.50000           637.570040             561.291667   \n",
       "std       1.744557   1.14208            57.774324              27.815353   \n",
       "min    2011.000000   1.00000           569.500000             524.000000   \n",
       "25%    2012.000000   1.75000           587.820833             546.000000   \n",
       "50%    2013.500000   2.50000           642.839136             550.000000   \n",
       "75%    2015.000000   3.25000           673.157388             578.750000   \n",
       "max    2016.000000   4.00000           798.225150             625.000000   \n",
       "\n",
       "       num_adverts  \n",
       "count    24.000000  \n",
       "mean    598.416667  \n",
       "std     338.694670  \n",
       "min      52.000000  \n",
       "25%     459.500000  \n",
       "50%     640.000000  \n",
       "75%     739.000000  \n",
       "max    1670.000000  "
      ]
     },
     "execution_count": 156,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "glasgow.describe()\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### What was the mean rent in Glasgow for each year?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 157,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "579.804631    1\n",
       "720.591331    1\n",
       "569.500000    1\n",
       "582.192308    1\n",
       "650.525641    1\n",
       "602.323671    1\n",
       "798.225150    1\n",
       "669.294953    1\n",
       "589.099415    1\n",
       "635.152632    1\n",
       "658.844622    1\n",
       "683.308229    1\n",
       "670.680342    1\n",
       "599.418342    1\n",
       "574.154689    1\n",
       "574.802013    1\n",
       "587.927778    1\n",
       "680.588525    1\n",
       "593.172840    1\n",
       "652.748634    1\n",
       "682.918587    1\n",
       "696.966250    1\n",
       "661.940389    1\n",
       "587.500000    1\n",
       "Name: mean_rent_per_month, dtype: int64"
      ]
     },
     "execution_count": 157,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "glasgow['mean_rent_per_month'].value_counts()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 158,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "authority_code           0\n",
       "authority_name_x         0\n",
       "year                     0\n",
       "quarter                  0\n",
       "mean_rent_per_month      0\n",
       "median_rent_per_month    0\n",
       "authority_name_y         0\n",
       "num_adverts              0\n",
       "_merge                   0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 158,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# how many missings\n",
    " \n",
    "glasgow.isna().sum()\n",
    "\n",
    "# no missing data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 159,
   "metadata": {},
   "outputs": [],
   "source": [
    "# sort values by year\n",
    "\n",
    "glasgow_by_year = glasgow.sort_values('year', ascending = False).groupby(['year', 'quarter'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 160,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>authority_code</th>\n",
       "      <th>authority_name_x</th>\n",
       "      <th>year</th>\n",
       "      <th>quarter</th>\n",
       "      <th>mean_rent_per_month</th>\n",
       "      <th>median_rent_per_month</th>\n",
       "      <th>authority_name_y</th>\n",
       "      <th>num_adverts</th>\n",
       "      <th>_merge</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>8353</th>\n",
       "      <td>S12000046</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>2016</td>\n",
       "      <td>3</td>\n",
       "      <td>696.966250</td>\n",
       "      <td>625.0</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>800</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8352</th>\n",
       "      <td>S12000046</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>2016</td>\n",
       "      <td>2</td>\n",
       "      <td>683.308229</td>\n",
       "      <td>600.0</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>717</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8351</th>\n",
       "      <td>S12000046</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>2016</td>\n",
       "      <td>4</td>\n",
       "      <td>652.748634</td>\n",
       "      <td>595.0</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>549</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8350</th>\n",
       "      <td>S12000046</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>682.918587</td>\n",
       "      <td>595.0</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>651</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8349</th>\n",
       "      <td>S12000046</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>2015</td>\n",
       "      <td>2</td>\n",
       "      <td>669.294953</td>\n",
       "      <td>590.0</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>634</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8348</th>\n",
       "      <td>S12000046</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>2015</td>\n",
       "      <td>3</td>\n",
       "      <td>680.588525</td>\n",
       "      <td>600.0</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>610</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8347</th>\n",
       "      <td>S12000046</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>2015</td>\n",
       "      <td>1</td>\n",
       "      <td>670.680342</td>\n",
       "      <td>550.0</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>585</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8346</th>\n",
       "      <td>S12000046</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>2015</td>\n",
       "      <td>4</td>\n",
       "      <td>658.844622</td>\n",
       "      <td>575.0</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>502</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8343</th>\n",
       "      <td>S12000046</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>2014</td>\n",
       "      <td>1</td>\n",
       "      <td>720.591331</td>\n",
       "      <td>550.0</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>646</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8345</th>\n",
       "      <td>S12000046</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>2014</td>\n",
       "      <td>3</td>\n",
       "      <td>661.940389</td>\n",
       "      <td>575.0</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>822</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8344</th>\n",
       "      <td>S12000046</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>2014</td>\n",
       "      <td>2</td>\n",
       "      <td>798.225150</td>\n",
       "      <td>550.0</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>1670</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8342</th>\n",
       "      <td>S12000046</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>2014</td>\n",
       "      <td>4</td>\n",
       "      <td>650.525641</td>\n",
       "      <td>550.0</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>702</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8341</th>\n",
       "      <td>S12000046</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>2013</td>\n",
       "      <td>4</td>\n",
       "      <td>579.804631</td>\n",
       "      <td>525.0</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>691</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8340</th>\n",
       "      <td>S12000046</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>2013</td>\n",
       "      <td>1</td>\n",
       "      <td>574.154689</td>\n",
       "      <td>525.0</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>821</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8339</th>\n",
       "      <td>S12000046</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>2013</td>\n",
       "      <td>2</td>\n",
       "      <td>599.418342</td>\n",
       "      <td>550.0</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>796</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8338</th>\n",
       "      <td>S12000046</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>2013</td>\n",
       "      <td>3</td>\n",
       "      <td>587.927778</td>\n",
       "      <td>545.0</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>720</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8337</th>\n",
       "      <td>S12000046</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>2012</td>\n",
       "      <td>3</td>\n",
       "      <td>589.099415</td>\n",
       "      <td>546.0</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>855</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8336</th>\n",
       "      <td>S12000046</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>2012</td>\n",
       "      <td>2</td>\n",
       "      <td>569.500000</td>\n",
       "      <td>546.0</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>332</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8335</th>\n",
       "      <td>S12000046</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>2012</td>\n",
       "      <td>1</td>\n",
       "      <td>602.323671</td>\n",
       "      <td>550.0</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>207</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8334</th>\n",
       "      <td>S12000046</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>2012</td>\n",
       "      <td>4</td>\n",
       "      <td>574.802013</td>\n",
       "      <td>525.0</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>596</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8331</th>\n",
       "      <td>S12000046</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>2011</td>\n",
       "      <td>1</td>\n",
       "      <td>587.500000</td>\n",
       "      <td>524.0</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>52</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8333</th>\n",
       "      <td>S12000046</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>2011</td>\n",
       "      <td>3</td>\n",
       "      <td>593.172840</td>\n",
       "      <td>546.0</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>162</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8332</th>\n",
       "      <td>S12000046</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>2011</td>\n",
       "      <td>4</td>\n",
       "      <td>635.152632</td>\n",
       "      <td>575.0</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>190</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8330</th>\n",
       "      <td>S12000046</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>2011</td>\n",
       "      <td>2</td>\n",
       "      <td>582.192308</td>\n",
       "      <td>559.0</td>\n",
       "      <td>Glasgow City</td>\n",
       "      <td>52</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     authority_code authority_name_x  year  quarter  mean_rent_per_month  \\\n",
       "8353      S12000046     Glasgow City  2016        3           696.966250   \n",
       "8352      S12000046     Glasgow City  2016        2           683.308229   \n",
       "8351      S12000046     Glasgow City  2016        4           652.748634   \n",
       "8350      S12000046     Glasgow City  2016        1           682.918587   \n",
       "8349      S12000046     Glasgow City  2015        2           669.294953   \n",
       "8348      S12000046     Glasgow City  2015        3           680.588525   \n",
       "8347      S12000046     Glasgow City  2015        1           670.680342   \n",
       "8346      S12000046     Glasgow City  2015        4           658.844622   \n",
       "8343      S12000046     Glasgow City  2014        1           720.591331   \n",
       "8345      S12000046     Glasgow City  2014        3           661.940389   \n",
       "8344      S12000046     Glasgow City  2014        2           798.225150   \n",
       "8342      S12000046     Glasgow City  2014        4           650.525641   \n",
       "8341      S12000046     Glasgow City  2013        4           579.804631   \n",
       "8340      S12000046     Glasgow City  2013        1           574.154689   \n",
       "8339      S12000046     Glasgow City  2013        2           599.418342   \n",
       "8338      S12000046     Glasgow City  2013        3           587.927778   \n",
       "8337      S12000046     Glasgow City  2012        3           589.099415   \n",
       "8336      S12000046     Glasgow City  2012        2           569.500000   \n",
       "8335      S12000046     Glasgow City  2012        1           602.323671   \n",
       "8334      S12000046     Glasgow City  2012        4           574.802013   \n",
       "8331      S12000046     Glasgow City  2011        1           587.500000   \n",
       "8333      S12000046     Glasgow City  2011        3           593.172840   \n",
       "8332      S12000046     Glasgow City  2011        4           635.152632   \n",
       "8330      S12000046     Glasgow City  2011        2           582.192308   \n",
       "\n",
       "      median_rent_per_month authority_name_y  num_adverts _merge  \n",
       "8353                  625.0     Glasgow City          800   both  \n",
       "8352                  600.0     Glasgow City          717   both  \n",
       "8351                  595.0     Glasgow City          549   both  \n",
       "8350                  595.0     Glasgow City          651   both  \n",
       "8349                  590.0     Glasgow City          634   both  \n",
       "8348                  600.0     Glasgow City          610   both  \n",
       "8347                  550.0     Glasgow City          585   both  \n",
       "8346                  575.0     Glasgow City          502   both  \n",
       "8343                  550.0     Glasgow City          646   both  \n",
       "8345                  575.0     Glasgow City          822   both  \n",
       "8344                  550.0     Glasgow City         1670   both  \n",
       "8342                  550.0     Glasgow City          702   both  \n",
       "8341                  525.0     Glasgow City          691   both  \n",
       "8340                  525.0     Glasgow City          821   both  \n",
       "8339                  550.0     Glasgow City          796   both  \n",
       "8338                  545.0     Glasgow City          720   both  \n",
       "8337                  546.0     Glasgow City          855   both  \n",
       "8336                  546.0     Glasgow City          332   both  \n",
       "8335                  550.0     Glasgow City          207   both  \n",
       "8334                  525.0     Glasgow City          596   both  \n",
       "8331                  524.0     Glasgow City           52   both  \n",
       "8333                  546.0     Glasgow City          162   both  \n",
       "8332                  575.0     Glasgow City          190   both  \n",
       "8330                  559.0     Glasgow City           52   both  "
      ]
     },
     "execution_count": 160,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "glasgow_by_year.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Calculate mean rent per year\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 161,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "579.804631    1\n",
       "696.966250    1\n",
       "682.918587    1\n",
       "652.748634    1\n",
       "593.172840    1\n",
       "680.588525    1\n",
       "587.927778    1\n",
       "574.802013    1\n",
       "574.154689    1\n",
       "599.418342    1\n",
       "670.680342    1\n",
       "683.308229    1\n",
       "658.844622    1\n",
       "635.152632    1\n",
       "589.099415    1\n",
       "669.294953    1\n",
       "798.225150    1\n",
       "602.323671    1\n",
       "650.525641    1\n",
       "582.192308    1\n",
       "569.500000    1\n",
       "720.591331    1\n",
       "661.940389    1\n",
       "587.500000    1\n",
       "Name: mean_rent_per_month, dtype: int64"
      ]
     },
     "execution_count": 161,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "glasgow['mean_rent_per_month'].value_counts().sort_values()\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Get mean rent by year \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 165,
   "metadata": {},
   "outputs": [],
   "source": [
    "gla_year_rent = glasgow.groupby(['year']).mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 166,
   "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>quarter</th>\n",
       "      <th>mean_rent_per_month</th>\n",
       "      <th>median_rent_per_month</th>\n",
       "      <th>num_adverts</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>year</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2011</th>\n",
       "      <td>2.5</td>\n",
       "      <td>599.504445</td>\n",
       "      <td>551.00</td>\n",
       "      <td>114.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012</th>\n",
       "      <td>2.5</td>\n",
       "      <td>583.931275</td>\n",
       "      <td>541.75</td>\n",
       "      <td>497.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013</th>\n",
       "      <td>2.5</td>\n",
       "      <td>585.326360</td>\n",
       "      <td>536.25</td>\n",
       "      <td>757.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014</th>\n",
       "      <td>2.5</td>\n",
       "      <td>707.820628</td>\n",
       "      <td>556.25</td>\n",
       "      <td>960.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015</th>\n",
       "      <td>2.5</td>\n",
       "      <td>669.852110</td>\n",
       "      <td>578.75</td>\n",
       "      <td>582.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016</th>\n",
       "      <td>2.5</td>\n",
       "      <td>678.985425</td>\n",
       "      <td>603.75</td>\n",
       "      <td>679.25</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      quarter  mean_rent_per_month  median_rent_per_month  num_adverts\n",
       "year                                                                  \n",
       "2011      2.5           599.504445                 551.00       114.00\n",
       "2012      2.5           583.931275                 541.75       497.50\n",
       "2013      2.5           585.326360                 536.25       757.00\n",
       "2014      2.5           707.820628                 556.25       960.00\n",
       "2015      2.5           669.852110                 578.75       582.75\n",
       "2016      2.5           678.985425                 603.75       679.25"
      ]
     },
     "execution_count": 166,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gla_year_rent"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 237,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "year\n",
       "2011    599.504445\n",
       "2012    583.931275\n",
       "2013    585.326360\n",
       "2014    707.820628\n",
       "2015    669.852110\n",
       "2016    678.985425\n",
       "Name: mean_rent_per_month, dtype: float64"
      ]
     },
     "execution_count": 237,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gla_year_rent['mean_rent_per_month']\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Graph mean rent by year\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 246,
   "metadata": {},
   "outputs": [],
   "source": [
    "# sort descending by year first\n",
    "\n",
    "year_mean = gla_year_rent.sort_values('year', ascending = False)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 247,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:title={'center':'Yearly Average Rent'}, ylabel='year'>"
      ]
     },
     "execution_count": 247,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYsAAAEICAYAAACuxNj9AAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8vihELAAAACXBIWXMAAAsTAAALEwEAmpwYAAAZCklEQVR4nO3df7DddX3n8efLgCAgAQqGmLCkdhjZjCjYbMXBVSrVVXQFd63VrZp2UfqDLcmKtdHdqXZ2naVdZGrHjhVLNVPxBwIKo60VI26XlkYuGA0kumANBZoQEUmotMiP9/7x/Vw9Xu/N95Lcc8/J5fmYOXO/38/nez/nfW5O7ut+vp9zzjdVhSRJe/KkURcgSRp/hoUkqZdhIUnqZVhIknoZFpKkXoaFJKmXYaEnjCSnJ7lr1HVI+yPDQiOX5KNJPjyl7UVJvptk6ajqmk6SLyf5XpKDRl3Lvkry7iQPJ/mnJPcn+dskz5+jsb+c5M1zMZbGg2GhcbAGeHmSlwAkORj4EHBBVW2fiztIcsAcjLEC+LdAAa/a1/GmGX+fa9wLn6yqw4CjgeuAT42gBu0HDAuNXFV9F/gt4JIkhwLvAr5VVR9Jcmr7i/f+JF9Lcvrk9yX51SRbkzyQ5O+T/NpA3+lJ7kryO0l2AFNnLr+d5MopbX+U5H17KPVNwN8BHwFWt+85qNX2rIFxjknyz0me1vZfmWTTwF/vzx44dlur8evA95MckGRdkm+1x7UlyasHjl+U5L1J7k3y7ST/JUlNBk2SxUkuTbI9yd1J/meSRbP4N3gEuAxYluSYvrGS/EqS65Nc1GZa307y8tb3HrpQfX+btby/7/61H6gqb97G4gZcCVwDfBc4DljWts+k+8PmJW3/mHb8K4CfAQK8CHgQeG7rOx14BPh94CDgKa3trta/FPg+cETbPwDYCfzsHuq7HfhN4GeBh4Elrf3PgPcMHHce8Pm2fUob93nAIrqQ2QYc1Pq3AZva431Ka/tF4OntMf9Sq3Np6/t1YAuwHDgS+CLdTOeA1v9p4IPAocDTgK8AvzbD43k38NG2/WTgQuDe2YwF/Er7GbylPa7fAP4RSOv/MvDmUT+nvM3h/89RF+DN2+QNWAL8E7Cm7f8O8OdTjvkrYPUM3/+Zge89HfgBcPBA/w/Dou3/JfCWtv1KYMseantB++V4dNv/BvBf2/Yv0M2EJo/9G+BNbfsDwP+YMtY3gRe17W3Af+75uWwCzmrbXxr85d/uu+jCbgnw0GTotP7XA9fNMO6728/ofuBRuiA+feDfYsaxWljcPtB3SKvj2LZvWCywm6ehNDaq6h66v2xvbU3HA7/YTt/cn+R+ul/aSwGSvDzJ3yW5r/WdSXfufdJ3qupf9nCX64E3tO03AH++h2NXA1+oqnvb/sdaG3Tn+g9J8ry2rnEy3V/lk4/hgimP4Ti6mcOkOwfvKMmbBk5b3Q88a+BxPX3K8YPbxwMHAtsHvveDdLOCmVxeVUfQhcMtdLOm2Y61Y3Kjqh5sm4ft4b60HxvFgpo0W3fSzSzeMrWjvRrpSrp1hKur6uEkn6E7JTWp7yOVPwN8oK03vBJ4+3QHJXkK8FpgUVv/gO7U1hFJnlNVX0tyOd1f3vcAn62qBwYew3uq6j17qOOHdSY5nm5x/wzghqp6NMmmgce1ne4U1KTjBrbvpJsNHF3dGsSsVdW9Sc4FJpJ8bF/GmhxyL75HY8yZhcbZR4F/n+TftYXdg9vC9XK6c+wHAd8BHmmLqy99PIO3WccVdLOEr1TVP8xw6Nl0p2lW0s0aTgb+NfB/6cKKNsYvAb/ctid9CPj1NutIkkOTvCLJU2e4r0PpftF+B7pFfLqZxaTLgTVJliU5gu5U3eTj2Q58AXhvksOTPCnJzyR5Ud/Pon3/N+lO8719X8eiC81nzPJY7QcMC42tqroTOAt4J90vzzuB3wae1P5yP5/ul+f3gP9Etzj+eK0HTqL/FNSHq+ofqmrH5A14P/DLSQ6oqo10C9FPp1sLmXwME3SLwO9vdd5Od75/pse8BXgvcAPdL9yT6NZAJn2I7pf414GvAn9Bt5D/aOt/E12Qbmn3dwXttN0s/W/g3PZKrn0Z633Aa9orpf7ocdy/xtTkKxekJ6Qk/4pusfrYqto96noerzaj+pOqOn7UtWhhc2ahJ6wkTwLeCnxifwmKJE9JcmZ7P8YyuvekfLrv+6R95cxCT0jp3vx3D3AH8LJ2ymvsJTkE+D/AicA/A5+je7nwfhF22n8ZFpKkXp6GkiT1WrDvszj66KNrxYoVoy5DkvYbN910071Vdcx0fQs2LFasWMHExMSoy5Ck/UaSO2bq8zSUJKmXYSFJ6mVYSJJ6GRaSpF6GhSSpl2EhSeplWEiSei3Y91lsvnsXK9Z9btRlSNqPbLvwFaMuYWw5s5Ak9TIsJEm9DAtJUi/DQpLUy7CQJPUaWlgkOS7JdUm2JLk1yZrWflSSa5Pc1r4e2dpPTHJDkoeSvG3KWH+WZGeSW4ZVryRpZsOcWTwCXFBVK4FTgfOSrATWARuq6gRgQ9sHuA84H7homrE+ArxsiLVKkvZgaGFRVdur6ua2/QCwFVgGnAWsb4etB85ux+ysqhuBh6cZ66/pwkSSNALzsmaRZAVwCrARWFJV21vXDmDJHN7PuUkmkkw8+uCuuRpWkp7whh4WSQ4DrgTWVtXuwb6qKqDm6r6q6pKqWlVVqxYdsniuhpWkJ7yhhkWSA+mC4rKquqo135NkaetfCuwcZg2SpH03zFdDBbgU2FpVFw90XQOsbturgauHVYMkaW4Mc2ZxGvBG4MVJNrXbmcCFwEuS3Ab8QtsnybFJ7gLeCvz3JHclObz1fRy4AXhmaz9niHVLkqYY2qfOVtX1QGboPmOa43cAy2cY6/VzWJok6XHyHdySpF6GhSSpl2EhSeplWEiSei3Yy6qetGwxE14iUZLmhDMLSVIvw0KS1MuwkCT1MiwkSb0MC0lSL8NCktTLsJAk9TIsJEm9DAtJUi/DQpLUy7CQJPUyLCRJvQwLSVIvw0KS1MuwkCT1MiwkSb0MC0lSrwV7pbzNd+9ixbrPjboMSWNmm1fQ3CvOLCRJvQwLSVIvw0KS1MuwkCT1MiwkSb2GFhZJjktyXZItSW5Nsqa1H5Xk2iS3ta9HtvYTk9yQ5KEkb+sbR5I0f4Y5s3gEuKCqVgKnAuclWQmsAzZU1QnAhrYPcB9wPnDRLMeRJM2ToYVFVW2vqpvb9gPAVmAZcBawvh22Hji7HbOzqm4EHp7lOJKkeTIvaxZJVgCnABuBJVW1vXXtAJbs5TjT9Z+bZCLJxKMP7tqnmiVJPzL0sEhyGHAlsLaqdg/2VVUBta/jDIx3SVWtqqpViw5ZvI+VS5ImDTUskhxI9wv+sqq6qjXfk2Rp618K7NzLcSRJ82SYr4YKcCmwtaouHui6BljdtlcDV+/lOJKkeTLMDxI8DXgjsDnJptb2TuBC4PIk5wB3AK8FSHIsMAEcDjyWZC2wEnj2dONU1V8MsXZJ0oChhUVVXQ9khu4zpjl+B7B8mmP3NI4kaR74Dm5JUi/DQpLUy7CQJPVasFfKO2nZYia8IpYkzQlnFpKkXoaFJKmXYSFJ6mVYSJJ6GRaSpF6GhSSpl2EhSeplWEiSehkWkqRehoUkqZdhIUnqZVhIknoZFpKkXoaFJKmXYSFJ6mVYSJJ6GRaSpF4L9kp5m+/exYp1nxt1GZLGzDavoLlXnFlIknoZFpKkXoaFJKmXYSFJ6mVYSJJ6DS0skhyX5LokW5LcmmRNaz8qybVJbmtfj2ztJya5IclDSd42MM7BSb6S5GttnN8bVs2SpOkNc2bxCHBBVa0ETgXOS7ISWAdsqKoTgA1tH+A+4HzgoinjPAS8uKqeA5wMvCzJqUOsW5I0xdDCoqq2V9XNbfsBYCuwDDgLWN8OWw+c3Y7ZWVU3Ag9PGaeq6p/a7oHtVsOqW5L0k+ZlzSLJCuAUYCOwpKq2t64dwJJZfP+iJJuAncC1VbVxhuPOTTKRZOLRB3fNSe2SpHkIiySHAVcCa6tq92BfVRWzmCVU1aNVdTKwHPi5JM+a4bhLqmpVVa1adMjifS9ekgQMOSySHEgXFJdV1VWt+Z4kS1v/UrrZwqxU1f3AdcDL5rhUSdIeDPPVUAEuBbZW1cUDXdcAq9v2auDqnnGOSXJE234K8BLgG3NesCRpRsP8IMHTgDcCm9t6A8A7gQuBy5OcA9wBvBYgybHABHA48FiStcBKYCmwPskiunC7vKo+O8S6JUlTDC0squp6IDN0nzHN8Tvo1iSm+jrd4rgkaUR8B7ckqZdhIUnqZVhIknrtcc0iyZOAU6vqb+epnjlz0rLFTHhFLEmaE3ucWVTVY8Afz1MtkqQxNZvTUBuS/Mf2vglJ0hPQbMLi14BPAQ8l2Z3kgSS7+75JkrRw9L7PoqqeOh+FSJLG16zelNcuUHQCcPBkW1X99bCKkiSNl96wSPJmYA3du6s30V3I6AbgxUOtTJI0NmazZrEG+DfAHVX183QfvXH/MIuSJI2X2YTFv1TVvwAkOaiqvgE8c7hlSZLGyWzWLO5qHxH+GeDaJN+j+7RYSdITxGxeDfXqtvnuJNcBi4HPD7UqSdJYme2roV4AnFBVH05yDLAM+PZQK5MkjY3eNYsk7wJ+B3hHazoQ+Ogwi5IkjZfZLHC/GngV8H2AqvpHwDfqSdITyGzC4gdVVUABJDl0uCVJksbNbMLi8iQfBI5I8hbgi8CHhluWJGmczGaB+wd0AbGb7v0Vv1tV1w61KknSWJnNzOJpwP8CjqcLjS8OtSJJ0thJtxzRc1B3LYuXAr8KrAIuBy6tqm8Nt7y9d9DSE2rp6j8cdRmSNG+27ePVQZPcVFWrpuub1TW42wL3jnZ7BDgSuCLJH+xTZZKk/cJsPnV2DfAm4F7gT4HfrqqH2/W5bwPePtwSJUmjNpsF7qOA/1BVP/Z5UFX1WJJXDqcsSdI4mc1nQ71rD31b57YcSdI4mtWahSTpiW1oYZHkuCTXJdmS5Na29kGSo5Jcm+S29vXI1n5ikhuSPJTkbdOMtyjJV5N8dlg1S5KmN8yZxSPABVW1ku5SrOclWQmsAzZU1QnAhrYPcB9wPnDRDOOtATztJUkjMLSwqKrtVXVz236A7hf9MuAsYH07bD1wdjtmZ1XdCDw8dawky4FX0L0aS5I0z+ZlzSLJCrprd28EllTV9ta1A1gyiyH+kO4luo/13M+5SSaSTDz64K69L1iS9GOGHhZJDgOuBNZW1e7BvsFPs93D978S2FlVN/XdV1VdUlWrqmrVokMW70vZkqQBQw2LJAfSBcVlVXVVa74nydLWvxTY2TPMacCrkmwDPgG8OIkXX5KkeTTMV0MFuBTYWlUXD3RdA6xu26uBq/c0TlW9o6qWV9UK4HXAl6rqDUMoWZI0g1ldg3svnQa8EdicZFNreydwId01Ms4B7gBeC5DkWGACOBx4LMlaYOXUU1eSpPk3tLCoquuBzNB9xjTH7wCW94z5ZeDL+1qbJOnx8R3ckqRehoUkqZdhIUnqNcwF7pE6adliJvbxqlGSpI4zC0lSL8NCktTLsJAk9TIsJEm9DAtJUi/DQpLUy7CQJPUyLCRJvQwLSVIvw0KS1MuwkCT1MiwkSb0MC0lSL8NCktTLsJAk9TIsJEm9DAtJUq8Fe6W8zXfvYsW6z426DEmalW1jfmVPZxaSpF6GhSSpl2EhSeplWEiSehkWkqReQwuLJMcluS7JliS3JlnT2o9Kcm2S29rXI1v7iUluSPJQkrdNGWtbks1JNiWZGFbNkqTpDXNm8QhwQVWtBE4FzkuyElgHbKiqE4ANbR/gPuB84KIZxvv5qjq5qlYNsWZJ0jSGFhZVtb2qbm7bDwBbgWXAWcD6dth64Ox2zM6quhF4eFg1SZL2zrysWSRZAZwCbASWVNX21rUDWDKLIQr4QpKbkpy7h/s5N8lEkolHH9y1r2VLkpqhv4M7yWHAlcDaqtqd5Id9VVVJahbDvKCq7k7yNODaJN+oqr+eelBVXQJcAnDQ0hNmM64kaRaGOrNIciBdUFxWVVe15nuSLG39S4GdfeNU1d3t607g08DPDadiSdJ0hvlqqACXAlur6uKBrmuA1W17NXB1zziHJnnq5DbwUuCWua9YkjSTYZ6GOg14I7A5yabW9k7gQuDyJOcAdwCvBUhyLDABHA48lmQtsBI4Gvh0O311APCxqvr8EOuWJE0xtLCoquuBzNB9xjTH7wCWT3PsbuA5c1iaJOlx8h3ckqRehoUkqZdhIUnqZVhIknot2MuqnrRsMRNjfplCSdpfOLOQJPUyLCRJvQwLSVIvw0KS1MuwkCT1MiwkSb0MC0lSL8NCktTLsJAk9TIsJEm9DAtJUi/DQpLUy7CQJPUyLCRJvQwLSVIvw0KS1MuwkCT1WrBXytt89y5WrPvcqMuQpL2ybcyu9OnMQpLUy7CQJPUyLCRJvQwLSVIvw0KS1GtoYZHkuCTXJdmS5NYka1r7UUmuTXJb+3pkaz8xyQ1JHkrytiljHZHkiiTfSLI1yfOHVbck6ScNc2bxCHBBVa0ETgXOS7ISWAdsqKoTgA1tH+A+4HzgomnGeh/w+ao6EXgOsHWIdUuSphhaWFTV9qq6uW0/QPcLfhlwFrC+HbYeOLsds7OqbgQeHhwnyWLghcCl7bgfVNX9w6pbkvST5mXNIskK4BRgI7Ckqra3rh3Akp5v/2ngO8CHk3w1yZ8mOXSG+zk3yUSSiUcf3DVH1UuShh4WSQ4DrgTWVtXuwb6qKqB6hjgAeC7wgao6Bfg+Pzp19WOq6pKqWlVVqxYdsnjfi5ckAUMOiyQH0gXFZVV1VWu+J8nS1r8U2NkzzF3AXVW1se1fQRcekqR5MsxXQ4VunWFrVV080HUNsLptrwau3tM4VbUDuDPJM1vTGcCWOS5XkrQHw/wgwdOANwKbk2xqbe8ELgQuT3IOcAfwWoAkxwITwOHAY0nWAivbqavfAi5L8mTg74FfHWLdkqQphhYWVXU9kBm6z5jm+B3A8hnG2gSsmrPiJEmPi+/gliT1MiwkSb0MC0lSrwV7pbyTli1mYsyuNCVJ+ytnFpKkXoaFJKmXYSFJ6mVYSJJ6GRaSpF6GhSSpl2EhSeplWEiSeqW7/tDCk+QB4JujruNxOhq4d9RFPE7WPD+seX480Ws+vqqOma5jwb6DG/hmVe1Xn1SbZMKah8+a54c1z4/5qtnTUJKkXoaFJKnXQg6LS0ZdwF6w5vlhzfPDmufHvNS8YBe4JUlzZyHPLCRJc8SwkCT1WnBhkeRlSb6Z5PYk60Zdz6Qkf5ZkZ5JbBtqOSnJtktva1yNbe5L8UXsMX0/y3BHVfFyS65JsSXJrkjXjXneSg5N8JcnXWs2/19p/OsnGVtsnkzy5tR/U9m9v/Svmu+aB2hcl+WqSz+4PNSfZlmRzkk1JJlrb2D43Wh1HJLkiyTeSbE3y/HGuOckz28938rY7ydqR1FxVC+YGLAK+BTwDeDLwNWDlqOtqtb0QeC5wy0DbHwDr2vY64Pfb9pnAXwIBTgU2jqjmpcBz2/ZTgf8HrBznutt9H9a2DwQ2tlouB17X2v8E+I22/ZvAn7Tt1wGfHOFz5K3Ax4DPtv2xrhnYBhw9pW1snxutjvXAm9v2k4Ejxr3mgdoXATuA40dR88ge+JB+mM8H/mpg/x3AO0Zd10A9K6aExTeBpW17Kd0bCQE+CLx+uuNGXP/VwEv2l7qBQ4CbgefRvcP1gKnPE+CvgOe37QPacRlBrcuBDcCLgc+2/+zjXvN0YTG2zw1gMfDtqT+rca55Sp0vBf5mVDUvtNNQy4A7B/bvam3jaklVbW/bO4AlbXvsHkc71XEK3V/qY113O52zCdgJXEs327y/qh6Zpq4f1tz6dwE/Na8Fd/4QeDvwWNv/Kca/5gK+kOSmJOe2tnF+bvw08B3gw+10358mOZTxrnnQ64CPt+15r3mhhcV+q7o/A8bydcxJDgOuBNZW1e7BvnGsu6oeraqT6f5a/zngxNFWtGdJXgnsrKqbRl3L4/SCqnou8HLgvCQvHOwcw+fGAXSngj9QVacA36c7hfNDY1gzAG296lXAp6b2zVfNCy0s7gaOG9hf3trG1T1JlgK0rztb+9g8jiQH0gXFZVV1VWse+7oBqup+4Dq6UzhHJJn8LLTBun5Yc+tfDHx3fivlNOBVSbYBn6A7FfU+xrtmquru9nUn8Gm6YB7n58ZdwF1VtbHtX0EXHuNc86SXAzdX1T1tf95rXmhhcSNwQnsVyZPppm3XjLimPbkGWN22V9OtCUy2v6m9suFUYNfAlHPeJAlwKbC1qi4e6BrbupMck+SItv0UujWWrXSh8ZoZap58LK8BvtT+Ups3VfWOqlpeVSvonrNfqqpfZoxrTnJokqdObtOdT7+FMX5uVNUO4M4kz2xNZwBbxrnmAa/nR6egYBQ1j2qxZoiLQGfSvWrnW8B/G3U9A3V9HNgOPEz3F845dOeZNwC3AV8EjmrHBvjj9hg2A6tGVPML6Ka3Xwc2tduZ41w38Gzgq63mW4Dfbe3PAL4C3E43lT+otR/c9m9v/c8Y8fPkdH70aqixrbnV9rV2u3Xy/9o4PzdaHScDE+358RngyP2g5kPpZo6LB9rmvWY/7kOS1GuhnYaSJA2BYSFJ6mVYSJJ6GRaSpF6GhSSpl2EhSeplWEiSev1/mkTBIn1UJNAAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "year_mean_rent = year_mean['mean_rent_per_month']\n",
    "\n",
    "year_mean_rent.plot.barh(x= 'Year', y = '£', title = 'Yearly Average Rent')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}