Unit_4_Challenge_Tier_3.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "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"
    },
    "colab": {
      "name": "Unit 4 Challenge - Tier 3.ipynb",
      "provenance": [],
      "collapsed_sections": [],
      "include_colab_link": true
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/Sidharth1999/London-Housing-Case-Study/blob/main/Unit_4_Challenge_Tier_3.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "Tia3MP1SJpgj"
      },
      "source": [
        "# Springboard Data Science Career Track Unit 4 Challenge - Tier 3 Complete\n",
        "\n",
        "## Objectives\n",
        "Hey! Great job getting through those challenging DataCamp courses. You're learning a lot in a short span of time. \n",
        "\n",
        "In this notebook, you're going to apply the skills you've been learning, bridging the gap between the controlled environment of DataCamp and the *slightly* messier work that data scientists do with actual datasets!\n",
        "\n",
        "Here’s the mystery we’re going to solve: ***which boroughs of London have seen the greatest increase in housing prices, on average, over the last two decades?***\n",
        "\n",
        "\n",
        "A borough is just a fancy word for district. You may be familiar with the five boroughs of New York… well, there are 32 boroughs within Greater London [(here's some info for the curious)](https://en.wikipedia.org/wiki/London_boroughs). Some of them are more desirable areas to live in, and the data will reflect that with a greater rise in housing prices.\n",
        "\n",
        "***This is the Tier 3 notebook, which means it's not filled in at all: we'll just give you the skeleton of a project, the brief and the data. It's up to you to play around with it and see what you can find out! Good luck! If you struggle, feel free to look at easier tiers for help; but try to dip in and out of them, as the more independent work you do, the better it is for your learning!***\n",
        "\n",
        "This challenge will make use of only what you learned in the following DataCamp courses: \n",
        "- Prework courses (Introduction to Python for Data Science, Intermediate Python for Data Science)\n",
        "- Data Types for Data Science\n",
        "- Python Data Science Toolbox (Part One) \n",
        "- pandas Foundations\n",
        "- Manipulating DataFrames with pandas\n",
        "- Merging DataFrames with pandas\n",
        "\n",
        "Of the tools, techniques and concepts in the above DataCamp courses, this challenge should require the application of the following: \n",
        "- **pandas**\n",
        "    - **data ingestion and inspection** (pandas Foundations, Module One) \n",
        "    - **exploratory data analysis** (pandas Foundations, Module Two)\n",
        "    - **tidying and cleaning** (Manipulating DataFrames with pandas, Module Three) \n",
        "    - **transforming DataFrames** (Manipulating DataFrames with pandas, Module One)\n",
        "    - **subsetting DataFrames with lists** (Manipulating DataFrames with pandas, Module One) \n",
        "    - **filtering DataFrames** (Manipulating DataFrames with pandas, Module One) \n",
        "    - **grouping data** (Manipulating DataFrames with pandas, Module Four) \n",
        "    - **melting data** (Manipulating DataFrames with pandas, Module Three) \n",
        "    - **advanced indexing** (Manipulating DataFrames with pandas, Module Four) \n",
        "- **matplotlib** (Intermediate Python for Data Science, Module One)\n",
        "- **fundamental data types** (Data Types for Data Science, Module One) \n",
        "- **dictionaries** (Intermediate Python for Data Science, Module Two)\n",
        "- **handling dates and times** (Data Types for Data Science, Module Four)\n",
        "- **function definition** (Python Data Science Toolbox - Part One, Module One)\n",
        "- **default arguments, variable length, and scope** (Python Data Science Toolbox - Part One, Module Two) \n",
        "- **lambda functions and error handling** (Python Data Science Toolbox - Part One, Module Four) "
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "Ipgd2nV8Jpgl"
      },
      "source": [
        "## The Data Science Pipeline\n",
        "\n",
        "This is Tier Three, so we'll get you started. But after that, it's all in your hands! When you feel done with your investigations, look back over what you've accomplished, and prepare a quick presentation of your findings for the next mentor meeting. \n",
        "\n",
        "Data Science is magical. In this case study, you'll get to apply some complex machine learning algorithms. But as  [David Spiegelhalter](https://www.youtube.com/watch?v=oUs1uvsz0Ok) reminds us, there is no substitute for simply **taking a really, really good look at the data.** Sometimes, this is all we need to answer our question.\n",
        "\n",
        "Data Science projects generally adhere to the four stages of Data Science Pipeline:\n",
        "1. Sourcing and loading \n",
        "2. Cleaning, transforming, and visualizing \n",
        "3. Modeling \n",
        "4. Evaluating and concluding \n"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "zswDqbefJpgm"
      },
      "source": [
        "### 1. Sourcing and Loading \n",
        "\n",
        "Any Data Science project kicks off by importing  ***pandas***. The documentation of this wonderful library can be found [here](https://pandas.pydata.org/). As you've seen, pandas is conveniently connected to the [Numpy](http://www.numpy.org/) and [Matplotlib](https://matplotlib.org/) libraries. \n",
        "\n",
        "***Hint:*** This part of the data science pipeline will test those skills you acquired in the pandas Foundations course, Module One. "
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "aEau5nEvJpgm"
      },
      "source": [
        "#### 1.1. Importing Libraries"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "7Bt_Q_oPJpgn"
      },
      "source": [
        "# Let's import the pandas, numpy libraries as pd, and np respectively. \n",
        "import pandas as pd\n",
        "import numpy as np\n",
        "\n",
        "# Load the pyplot collection of functions from matplotlib, as plt \n",
        "import matplotlib.pyplot as plt"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "koUrawxsJpgq"
      },
      "source": [
        "#### 1.2.  Loading the data\n",
        "Your data comes from the [London Datastore](https://data.london.gov.uk/): a free, open-source data-sharing portal for London-oriented datasets. "
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "AiLiD4v3Jpgr"
      },
      "source": [
        "# First, make a variable called url_LondonHousePrices, and assign it the following link, enclosed in quotation-marks as a string:\n",
        "# https://data.london.gov.uk/download/uk-house-price-index/70ac0766-8902-4eb5-aab5-01951aaed773/UK%20House%20price%20index.xls\n",
        "\n",
        "url_LondonHousePrices = \"https://data.london.gov.uk/download/uk-house-price-index/70ac0766-8902-4eb5-aab5-01951aaed773/UK%20House%20price%20index.xls\"\n",
        "\n",
        "# The dataset we're interested in contains the Average prices of the houses, and is actually on a particular sheet of the Excel file. \n",
        "# As a result, we need to specify the sheet name in the read_excel() method.\n",
        "# Put this data into a variable called properties.  \n",
        "properties = pd.read_excel(url_LondonHousePrices, sheet_name='Average price', index_col= None)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "POukEJXgJpgu"
      },
      "source": [
        "### 2. Cleaning, transforming, and visualizing\n",
        "This second stage is arguably the most important part of any Data Science project. The first thing to do is take a proper look at the data. Cleaning forms the majority of this stage, and can be done both before or after Transformation.\n",
        "\n",
        "The end goal of data cleaning is to have tidy data. When data is tidy: \n",
        "\n",
        "1. Each variable has a column.\n",
        "2. Each observation forms a row.\n",
        "\n",
        "Keep the end goal in mind as you move through this process, every step will take you closer. \n",
        "\n",
        "\n",
        "\n",
        "***Hint:*** This part of the data science pipeline should test those skills you acquired in: \n",
        "- Intermediate Python for data science, all modules.\n",
        "- pandas Foundations, all modules. \n",
        "- Manipulating DataFrames with pandas, all modules.\n",
        "- Data Types for Data Science, Module Four.\n",
        "- Python Data Science Toolbox - Part One, all modules"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "Te0Q548tnzZa"
      },
      "source": [
        "**2.1. Exploring your data** \n",
        "\n",
        "Think about your pandas functions for checking out a dataframe. "
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Rxirxw_qoAJa",
        "outputId": "318dfc7f-f9b4-4b18-8c8a-4307224a5993",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 386
        }
      },
      "source": [
        "properties.head()\n"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Unnamed: 0</th>\n",
              "      <th>City of London</th>\n",
              "      <th>Barking &amp; Dagenham</th>\n",
              "      <th>Barnet</th>\n",
              "      <th>Bexley</th>\n",
              "      <th>Brent</th>\n",
              "      <th>Bromley</th>\n",
              "      <th>Camden</th>\n",
              "      <th>Croydon</th>\n",
              "      <th>Ealing</th>\n",
              "      <th>Enfield</th>\n",
              "      <th>Greenwich</th>\n",
              "      <th>Hackney</th>\n",
              "      <th>Hammersmith &amp; Fulham</th>\n",
              "      <th>Haringey</th>\n",
              "      <th>Harrow</th>\n",
              "      <th>Havering</th>\n",
              "      <th>Hillingdon</th>\n",
              "      <th>Hounslow</th>\n",
              "      <th>Islington</th>\n",
              "      <th>Kensington &amp; Chelsea</th>\n",
              "      <th>Kingston upon Thames</th>\n",
              "      <th>Lambeth</th>\n",
              "      <th>Lewisham</th>\n",
              "      <th>Merton</th>\n",
              "      <th>Newham</th>\n",
              "      <th>Redbridge</th>\n",
              "      <th>Richmond upon Thames</th>\n",
              "      <th>Southwark</th>\n",
              "      <th>Sutton</th>\n",
              "      <th>Tower Hamlets</th>\n",
              "      <th>Waltham Forest</th>\n",
              "      <th>Wandsworth</th>\n",
              "      <th>Westminster</th>\n",
              "      <th>Unnamed: 34</th>\n",
              "      <th>Inner London</th>\n",
              "      <th>Outer London</th>\n",
              "      <th>Unnamed: 37</th>\n",
              "      <th>NORTH EAST</th>\n",
              "      <th>NORTH WEST</th>\n",
              "      <th>YORKS &amp; THE HUMBER</th>\n",
              "      <th>EAST MIDLANDS</th>\n",
              "      <th>WEST MIDLANDS</th>\n",
              "      <th>EAST OF ENGLAND</th>\n",
              "      <th>LONDON</th>\n",
              "      <th>SOUTH EAST</th>\n",
              "      <th>SOUTH WEST</th>\n",
              "      <th>Unnamed: 47</th>\n",
              "      <th>England</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>NaT</td>\n",
              "      <td>E09000001</td>\n",
              "      <td>E09000002</td>\n",
              "      <td>E09000003</td>\n",
              "      <td>E09000004</td>\n",
              "      <td>E09000005</td>\n",
              "      <td>E09000006</td>\n",
              "      <td>E09000007</td>\n",
              "      <td>E09000008</td>\n",
              "      <td>E09000009</td>\n",
              "      <td>E09000010</td>\n",
              "      <td>E09000011</td>\n",
              "      <td>E09000012</td>\n",
              "      <td>E09000013</td>\n",
              "      <td>E09000014</td>\n",
              "      <td>E09000015</td>\n",
              "      <td>E09000016</td>\n",
              "      <td>E09000017</td>\n",
              "      <td>E09000018</td>\n",
              "      <td>E09000019</td>\n",
              "      <td>E09000020</td>\n",
              "      <td>E09000021</td>\n",
              "      <td>E09000022</td>\n",
              "      <td>E09000023</td>\n",
              "      <td>E09000024</td>\n",
              "      <td>E09000025</td>\n",
              "      <td>E09000026</td>\n",
              "      <td>E09000027</td>\n",
              "      <td>E09000028</td>\n",
              "      <td>E09000029</td>\n",
              "      <td>E09000030</td>\n",
              "      <td>E09000031</td>\n",
              "      <td>E09000032</td>\n",
              "      <td>E09000033</td>\n",
              "      <td>NaN</td>\n",
              "      <td>E13000001</td>\n",
              "      <td>E13000002</td>\n",
              "      <td>NaN</td>\n",
              "      <td>E12000001</td>\n",
              "      <td>E12000002</td>\n",
              "      <td>E12000003</td>\n",
              "      <td>E12000004</td>\n",
              "      <td>E12000005</td>\n",
              "      <td>E12000006</td>\n",
              "      <td>E12000007</td>\n",
              "      <td>E12000008</td>\n",
              "      <td>E12000009</td>\n",
              "      <td>NaN</td>\n",
              "      <td>E92000001</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1995-01-01</td>\n",
              "      <td>91449</td>\n",
              "      <td>50460.2</td>\n",
              "      <td>93284.5</td>\n",
              "      <td>64958.1</td>\n",
              "      <td>71306.6</td>\n",
              "      <td>81671.5</td>\n",
              "      <td>120933</td>\n",
              "      <td>69158.2</td>\n",
              "      <td>79885.9</td>\n",
              "      <td>72514.7</td>\n",
              "      <td>62300.1</td>\n",
              "      <td>61296.5</td>\n",
              "      <td>124903</td>\n",
              "      <td>76287.6</td>\n",
              "      <td>84769.5</td>\n",
              "      <td>68000.1</td>\n",
              "      <td>73834.8</td>\n",
              "      <td>72231.7</td>\n",
              "      <td>92516.5</td>\n",
              "      <td>182695</td>\n",
              "      <td>80875.8</td>\n",
              "      <td>67771</td>\n",
              "      <td>60491.3</td>\n",
              "      <td>82070.6</td>\n",
              "      <td>53539.3</td>\n",
              "      <td>72189.6</td>\n",
              "      <td>109326</td>\n",
              "      <td>67885.2</td>\n",
              "      <td>71537</td>\n",
              "      <td>59865.2</td>\n",
              "      <td>61319.4</td>\n",
              "      <td>88559</td>\n",
              "      <td>133025</td>\n",
              "      <td>NaN</td>\n",
              "      <td>78252</td>\n",
              "      <td>72958.8</td>\n",
              "      <td>NaN</td>\n",
              "      <td>42076.4</td>\n",
              "      <td>43958.5</td>\n",
              "      <td>44803.4</td>\n",
              "      <td>45544.5</td>\n",
              "      <td>48527.5</td>\n",
              "      <td>56701.6</td>\n",
              "      <td>74435.8</td>\n",
              "      <td>64018.9</td>\n",
              "      <td>54705.2</td>\n",
              "      <td>NaN</td>\n",
              "      <td>53202.8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>1995-02-01</td>\n",
              "      <td>82202.8</td>\n",
              "      <td>51085.8</td>\n",
              "      <td>93190.2</td>\n",
              "      <td>64787.9</td>\n",
              "      <td>72022.3</td>\n",
              "      <td>81657.6</td>\n",
              "      <td>119509</td>\n",
              "      <td>68951.1</td>\n",
              "      <td>80897.1</td>\n",
              "      <td>73155.2</td>\n",
              "      <td>60993.3</td>\n",
              "      <td>63187.1</td>\n",
              "      <td>122088</td>\n",
              "      <td>78901.2</td>\n",
              "      <td>83396.1</td>\n",
              "      <td>69393.5</td>\n",
              "      <td>75031.1</td>\n",
              "      <td>71051.6</td>\n",
              "      <td>94342.4</td>\n",
              "      <td>182345</td>\n",
              "      <td>81230.1</td>\n",
              "      <td>65381.5</td>\n",
              "      <td>60869.3</td>\n",
              "      <td>79982.7</td>\n",
              "      <td>53153.9</td>\n",
              "      <td>72141.6</td>\n",
              "      <td>111103</td>\n",
              "      <td>64799.1</td>\n",
              "      <td>70893.2</td>\n",
              "      <td>62318.5</td>\n",
              "      <td>60252.1</td>\n",
              "      <td>88641</td>\n",
              "      <td>131468</td>\n",
              "      <td>NaN</td>\n",
              "      <td>75885.7</td>\n",
              "      <td>72937.9</td>\n",
              "      <td>NaN</td>\n",
              "      <td>42572</td>\n",
              "      <td>43925.4</td>\n",
              "      <td>44528.8</td>\n",
              "      <td>46051.6</td>\n",
              "      <td>49341.3</td>\n",
              "      <td>56593.6</td>\n",
              "      <td>72777.9</td>\n",
              "      <td>63715</td>\n",
              "      <td>54356.1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>53096.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>1995-03-01</td>\n",
              "      <td>79120.7</td>\n",
              "      <td>51269</td>\n",
              "      <td>92247.5</td>\n",
              "      <td>64367.5</td>\n",
              "      <td>72015.8</td>\n",
              "      <td>81449.3</td>\n",
              "      <td>120282</td>\n",
              "      <td>68712.4</td>\n",
              "      <td>81379.9</td>\n",
              "      <td>72190.4</td>\n",
              "      <td>61377.8</td>\n",
              "      <td>63593.3</td>\n",
              "      <td>120636</td>\n",
              "      <td>78521.9</td>\n",
              "      <td>83416.2</td>\n",
              "      <td>69368</td>\n",
              "      <td>74188.7</td>\n",
              "      <td>72098</td>\n",
              "      <td>93465.9</td>\n",
              "      <td>182879</td>\n",
              "      <td>81111.5</td>\n",
              "      <td>66336.5</td>\n",
              "      <td>60288</td>\n",
              "      <td>80661.7</td>\n",
              "      <td>53458.3</td>\n",
              "      <td>72501.4</td>\n",
              "      <td>107325</td>\n",
              "      <td>65763.3</td>\n",
              "      <td>70306.8</td>\n",
              "      <td>63938.7</td>\n",
              "      <td>60871.1</td>\n",
              "      <td>87124.8</td>\n",
              "      <td>132260</td>\n",
              "      <td>NaN</td>\n",
              "      <td>76591.6</td>\n",
              "      <td>72714.5</td>\n",
              "      <td>NaN</td>\n",
              "      <td>42369.7</td>\n",
              "      <td>44434.9</td>\n",
              "      <td>45200.5</td>\n",
              "      <td>45383.8</td>\n",
              "      <td>49442.2</td>\n",
              "      <td>56171.2</td>\n",
              "      <td>73896.8</td>\n",
              "      <td>64113.6</td>\n",
              "      <td>53583.1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>53201.3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>1995-04-01</td>\n",
              "      <td>77101.2</td>\n",
              "      <td>53133.5</td>\n",
              "      <td>90762.9</td>\n",
              "      <td>64277.7</td>\n",
              "      <td>72965.6</td>\n",
              "      <td>81124.4</td>\n",
              "      <td>120098</td>\n",
              "      <td>68610</td>\n",
              "      <td>82188.9</td>\n",
              "      <td>71442.9</td>\n",
              "      <td>61927.7</td>\n",
              "      <td>65139.6</td>\n",
              "      <td>121425</td>\n",
              "      <td>79545.6</td>\n",
              "      <td>83567.9</td>\n",
              "      <td>69444.3</td>\n",
              "      <td>73911.4</td>\n",
              "      <td>71890.3</td>\n",
              "      <td>93344.5</td>\n",
              "      <td>184177</td>\n",
              "      <td>81672.8</td>\n",
              "      <td>66388.8</td>\n",
              "      <td>59471</td>\n",
              "      <td>79990.5</td>\n",
              "      <td>54479.8</td>\n",
              "      <td>72228.6</td>\n",
              "      <td>106875</td>\n",
              "      <td>63073.6</td>\n",
              "      <td>69411.9</td>\n",
              "      <td>66233.2</td>\n",
              "      <td>60971.4</td>\n",
              "      <td>87026</td>\n",
              "      <td>133370</td>\n",
              "      <td>NaN</td>\n",
              "      <td>76851.6</td>\n",
              "      <td>72591.9</td>\n",
              "      <td>NaN</td>\n",
              "      <td>42095.8</td>\n",
              "      <td>44267.8</td>\n",
              "      <td>45614.3</td>\n",
              "      <td>46124.2</td>\n",
              "      <td>49455.9</td>\n",
              "      <td>56567.9</td>\n",
              "      <td>74455.3</td>\n",
              "      <td>64623.2</td>\n",
              "      <td>54786</td>\n",
              "      <td>NaN</td>\n",
              "      <td>53590.9</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "  Unnamed: 0 City of London  ... Unnamed: 47    England\n",
              "0        NaT      E09000001  ...         NaN  E92000001\n",
              "1 1995-01-01          91449  ...         NaN    53202.8\n",
              "2 1995-02-01        82202.8  ...         NaN    53096.2\n",
              "3 1995-03-01        79120.7  ...         NaN    53201.3\n",
              "4 1995-04-01        77101.2  ...         NaN    53590.9\n",
              "\n",
              "[5 rows x 49 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 5
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "tE9Sqt9-oAta"
      },
      "source": [
        "**2.2. Cleaning the data**\n",
        "\n",
        "You might find you need to transpose your dataframe, check out what its row indexes are, and reset the index. You  also might find you need to assign the values of the first row to your column headings  . (Hint: recall the .columns feature of DataFrames, as well as the iloc[] method).\n",
        "\n",
        "Don't be afraid to use StackOverflow for help  with this."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "cdAu1A3YoH_r",
        "outputId": "0906a0a7-a321-4dbd-8939-468dd646839a",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 381
        }
      },
      "source": [
        "properties = properties.transpose()\n",
        "properties.columns = properties.iloc[0]\n",
        "properties = properties.iloc[1:]\n",
        "properties = properties.reset_index()\n",
        "properties.head()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Unnamed: 0</th>\n",
              "      <th>index</th>\n",
              "      <th>NaN</th>\n",
              "      <th>1995-01-01 00:00:00</th>\n",
              "      <th>1995-02-01 00:00:00</th>\n",
              "      <th>1995-03-01 00:00:00</th>\n",
              "      <th>1995-04-01 00:00:00</th>\n",
              "      <th>1995-05-01 00:00:00</th>\n",
              "      <th>1995-06-01 00:00:00</th>\n",
              "      <th>1995-07-01 00:00:00</th>\n",
              "      <th>1995-08-01 00:00:00</th>\n",
              "      <th>1995-09-01 00:00:00</th>\n",
              "      <th>1995-10-01 00:00:00</th>\n",
              "      <th>1995-11-01 00:00:00</th>\n",
              "      <th>1995-12-01 00:00:00</th>\n",
              "      <th>1996-01-01 00:00:00</th>\n",
              "      <th>1996-02-01 00:00:00</th>\n",
              "      <th>1996-03-01 00:00:00</th>\n",
              "      <th>1996-04-01 00:00:00</th>\n",
              "      <th>1996-05-01 00:00:00</th>\n",
              "      <th>1996-06-01 00:00:00</th>\n",
              "      <th>1996-07-01 00:00:00</th>\n",
              "      <th>1996-08-01 00:00:00</th>\n",
              "      <th>1996-09-01 00:00:00</th>\n",
              "      <th>1996-10-01 00:00:00</th>\n",
              "      <th>1996-11-01 00:00:00</th>\n",
              "      <th>1996-12-01 00:00:00</th>\n",
              "      <th>1997-01-01 00:00:00</th>\n",
              "      <th>1997-02-01 00:00:00</th>\n",
              "      <th>1997-03-01 00:00:00</th>\n",
              "      <th>1997-04-01 00:00:00</th>\n",
              "      <th>1997-05-01 00:00:00</th>\n",
              "      <th>1997-06-01 00:00:00</th>\n",
              "      <th>1997-07-01 00:00:00</th>\n",
              "      <th>1997-08-01 00:00:00</th>\n",
              "      <th>1997-09-01 00:00:00</th>\n",
              "      <th>1997-10-01 00:00:00</th>\n",
              "      <th>1997-11-01 00:00:00</th>\n",
              "      <th>1997-12-01 00:00:00</th>\n",
              "      <th>1998-01-01 00:00:00</th>\n",
              "      <th>1998-02-01 00:00:00</th>\n",
              "      <th>...</th>\n",
              "      <th>2017-05-01 00:00:00</th>\n",
              "      <th>2017-06-01 00:00:00</th>\n",
              "      <th>2017-07-01 00:00:00</th>\n",
              "      <th>2017-08-01 00:00:00</th>\n",
              "      <th>2017-09-01 00:00:00</th>\n",
              "      <th>2017-10-01 00:00:00</th>\n",
              "      <th>2017-11-01 00:00:00</th>\n",
              "      <th>2017-12-01 00:00:00</th>\n",
              "      <th>2018-01-01 00:00:00</th>\n",
              "      <th>2018-02-01 00:00:00</th>\n",
              "      <th>2018-03-01 00:00:00</th>\n",
              "      <th>2018-04-01 00:00:00</th>\n",
              "      <th>2018-05-01 00:00:00</th>\n",
              "      <th>2018-06-01 00:00:00</th>\n",
              "      <th>2018-07-01 00:00:00</th>\n",
              "      <th>2018-08-01 00:00:00</th>\n",
              "      <th>2018-09-01 00:00:00</th>\n",
              "      <th>2018-10-01 00:00:00</th>\n",
              "      <th>2018-11-01 00:00:00</th>\n",
              "      <th>2018-12-01 00:00:00</th>\n",
              "      <th>2019-01-01 00:00:00</th>\n",
              "      <th>2019-02-01 00:00:00</th>\n",
              "      <th>2019-03-01 00:00:00</th>\n",
              "      <th>2019-04-01 00:00:00</th>\n",
              "      <th>2019-05-01 00:00:00</th>\n",
              "      <th>2019-06-01 00:00:00</th>\n",
              "      <th>2019-07-01 00:00:00</th>\n",
              "      <th>2019-08-01 00:00:00</th>\n",
              "      <th>2019-09-01 00:00:00</th>\n",
              "      <th>2019-10-01 00:00:00</th>\n",
              "      <th>2019-11-01 00:00:00</th>\n",
              "      <th>2019-12-01 00:00:00</th>\n",
              "      <th>2020-01-01 00:00:00</th>\n",
              "      <th>2020-02-01 00:00:00</th>\n",
              "      <th>2020-03-01 00:00:00</th>\n",
              "      <th>2020-04-01 00:00:00</th>\n",
              "      <th>2020-05-01 00:00:00</th>\n",
              "      <th>2020-06-01 00:00:00</th>\n",
              "      <th>2020-07-01 00:00:00</th>\n",
              "      <th>2020-08-01 00:00:00</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>City of London</td>\n",
              "      <td>E09000001</td>\n",
              "      <td>91449</td>\n",
              "      <td>82202.8</td>\n",
              "      <td>79120.7</td>\n",
              "      <td>77101.2</td>\n",
              "      <td>84409.1</td>\n",
              "      <td>94900.5</td>\n",
              "      <td>110128</td>\n",
              "      <td>112329</td>\n",
              "      <td>104473</td>\n",
              "      <td>108038</td>\n",
              "      <td>117636</td>\n",
              "      <td>127232</td>\n",
              "      <td>108999</td>\n",
              "      <td>93356.7</td>\n",
              "      <td>93706.7</td>\n",
              "      <td>120543</td>\n",
              "      <td>112050</td>\n",
              "      <td>114226</td>\n",
              "      <td>97546.7</td>\n",
              "      <td>114179</td>\n",
              "      <td>108138</td>\n",
              "      <td>98934.2</td>\n",
              "      <td>99706.8</td>\n",
              "      <td>106427</td>\n",
              "      <td>116343</td>\n",
              "      <td>111142</td>\n",
              "      <td>107488</td>\n",
              "      <td>108480</td>\n",
              "      <td>115453</td>\n",
              "      <td>118317</td>\n",
              "      <td>117034</td>\n",
              "      <td>113585</td>\n",
              "      <td>115159</td>\n",
              "      <td>121251</td>\n",
              "      <td>131074</td>\n",
              "      <td>130035</td>\n",
              "      <td>124382</td>\n",
              "      <td>143829</td>\n",
              "      <td>...</td>\n",
              "      <td>939912</td>\n",
              "      <td>930979</td>\n",
              "      <td>854798</td>\n",
              "      <td>847422</td>\n",
              "      <td>836674</td>\n",
              "      <td>818477</td>\n",
              "      <td>790159</td>\n",
              "      <td>778002</td>\n",
              "      <td>802129</td>\n",
              "      <td>783266</td>\n",
              "      <td>740799</td>\n",
              "      <td>732351</td>\n",
              "      <td>796399</td>\n",
              "      <td>789278</td>\n",
              "      <td>809697</td>\n",
              "      <td>784144</td>\n",
              "      <td>800875</td>\n",
              "      <td>802869</td>\n",
              "      <td>764207</td>\n",
              "      <td>811694</td>\n",
              "      <td>865636</td>\n",
              "      <td>894520</td>\n",
              "      <td>853451</td>\n",
              "      <td>738797</td>\n",
              "      <td>719218</td>\n",
              "      <td>761526</td>\n",
              "      <td>756407</td>\n",
              "      <td>813770</td>\n",
              "      <td>810455</td>\n",
              "      <td>826227</td>\n",
              "      <td>776894</td>\n",
              "      <td>737275</td>\n",
              "      <td>747611</td>\n",
              "      <td>777640</td>\n",
              "      <td>844989</td>\n",
              "      <td>867841</td>\n",
              "      <td>899831</td>\n",
              "      <td>938833</td>\n",
              "      <td>852151</td>\n",
              "      <td>814665</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Barking &amp; Dagenham</td>\n",
              "      <td>E09000002</td>\n",
              "      <td>50460.2</td>\n",
              "      <td>51085.8</td>\n",
              "      <td>51269</td>\n",
              "      <td>53133.5</td>\n",
              "      <td>53042.2</td>\n",
              "      <td>53700.3</td>\n",
              "      <td>52113.1</td>\n",
              "      <td>52232.2</td>\n",
              "      <td>51471.6</td>\n",
              "      <td>51513.8</td>\n",
              "      <td>50848.7</td>\n",
              "      <td>50945.2</td>\n",
              "      <td>50828.1</td>\n",
              "      <td>51440.7</td>\n",
              "      <td>51907.1</td>\n",
              "      <td>51724</td>\n",
              "      <td>51735.7</td>\n",
              "      <td>50761.4</td>\n",
              "      <td>50621.1</td>\n",
              "      <td>51104.7</td>\n",
              "      <td>51892.7</td>\n",
              "      <td>52533.2</td>\n",
              "      <td>52216</td>\n",
              "      <td>53853.5</td>\n",
              "      <td>54459</td>\n",
              "      <td>55451.5</td>\n",
              "      <td>55004.8</td>\n",
              "      <td>55279.9</td>\n",
              "      <td>54936.9</td>\n",
              "      <td>55286.7</td>\n",
              "      <td>55658.9</td>\n",
              "      <td>56506.7</td>\n",
              "      <td>56306.3</td>\n",
              "      <td>57200.2</td>\n",
              "      <td>57575.3</td>\n",
              "      <td>58025</td>\n",
              "      <td>57559</td>\n",
              "      <td>57360.3</td>\n",
              "      <td>...</td>\n",
              "      <td>286018</td>\n",
              "      <td>289569</td>\n",
              "      <td>291727</td>\n",
              "      <td>290965</td>\n",
              "      <td>292519</td>\n",
              "      <td>293390</td>\n",
              "      <td>293796</td>\n",
              "      <td>292915</td>\n",
              "      <td>291548</td>\n",
              "      <td>292777</td>\n",
              "      <td>291723</td>\n",
              "      <td>291184</td>\n",
              "      <td>290239</td>\n",
              "      <td>294236</td>\n",
              "      <td>294953</td>\n",
              "      <td>295908</td>\n",
              "      <td>296424</td>\n",
              "      <td>299648</td>\n",
              "      <td>302606</td>\n",
              "      <td>301114</td>\n",
              "      <td>297181</td>\n",
              "      <td>293839</td>\n",
              "      <td>294065</td>\n",
              "      <td>295498</td>\n",
              "      <td>295092</td>\n",
              "      <td>293889</td>\n",
              "      <td>297426</td>\n",
              "      <td>299421</td>\n",
              "      <td>304778</td>\n",
              "      <td>304579</td>\n",
              "      <td>306390</td>\n",
              "      <td>301283</td>\n",
              "      <td>303653</td>\n",
              "      <td>304265</td>\n",
              "      <td>304099</td>\n",
              "      <td>283139</td>\n",
              "      <td>295744</td>\n",
              "      <td>300595</td>\n",
              "      <td>304223</td>\n",
              "      <td>302395</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Barnet</td>\n",
              "      <td>E09000003</td>\n",
              "      <td>93284.5</td>\n",
              "      <td>93190.2</td>\n",
              "      <td>92247.5</td>\n",
              "      <td>90762.9</td>\n",
              "      <td>90258</td>\n",
              "      <td>90107.2</td>\n",
              "      <td>91441.2</td>\n",
              "      <td>92361.3</td>\n",
              "      <td>93273.1</td>\n",
              "      <td>92567.4</td>\n",
              "      <td>90883.2</td>\n",
              "      <td>91133.9</td>\n",
              "      <td>91111</td>\n",
              "      <td>92429.5</td>\n",
              "      <td>91409.8</td>\n",
              "      <td>92394.2</td>\n",
              "      <td>91058.9</td>\n",
              "      <td>91978.2</td>\n",
              "      <td>92444.1</td>\n",
              "      <td>95516</td>\n",
              "      <td>97489.9</td>\n",
              "      <td>97844.5</td>\n",
              "      <td>97155</td>\n",
              "      <td>97174.3</td>\n",
              "      <td>98558.8</td>\n",
              "      <td>100076</td>\n",
              "      <td>101130</td>\n",
              "      <td>101201</td>\n",
              "      <td>103287</td>\n",
              "      <td>104609</td>\n",
              "      <td>107235</td>\n",
              "      <td>108730</td>\n",
              "      <td>112380</td>\n",
              "      <td>114515</td>\n",
              "      <td>115356</td>\n",
              "      <td>115521</td>\n",
              "      <td>115902</td>\n",
              "      <td>116995</td>\n",
              "      <td>...</td>\n",
              "      <td>544994</td>\n",
              "      <td>531344</td>\n",
              "      <td>527928</td>\n",
              "      <td>526223</td>\n",
              "      <td>537986</td>\n",
              "      <td>544090</td>\n",
              "      <td>541563</td>\n",
              "      <td>538718</td>\n",
              "      <td>531832</td>\n",
              "      <td>531736</td>\n",
              "      <td>538120</td>\n",
              "      <td>541502</td>\n",
              "      <td>533088</td>\n",
              "      <td>524702</td>\n",
              "      <td>523397</td>\n",
              "      <td>533715</td>\n",
              "      <td>534951</td>\n",
              "      <td>537284</td>\n",
              "      <td>535060</td>\n",
              "      <td>533810</td>\n",
              "      <td>528639</td>\n",
              "      <td>523679</td>\n",
              "      <td>516531</td>\n",
              "      <td>512343</td>\n",
              "      <td>503911</td>\n",
              "      <td>512694</td>\n",
              "      <td>514668</td>\n",
              "      <td>528577</td>\n",
              "      <td>526670</td>\n",
              "      <td>525678</td>\n",
              "      <td>522639</td>\n",
              "      <td>519306</td>\n",
              "      <td>518542</td>\n",
              "      <td>519121</td>\n",
              "      <td>527747</td>\n",
              "      <td>526553</td>\n",
              "      <td>532503</td>\n",
              "      <td>519064</td>\n",
              "      <td>524400</td>\n",
              "      <td>522846</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Bexley</td>\n",
              "      <td>E09000004</td>\n",
              "      <td>64958.1</td>\n",
              "      <td>64787.9</td>\n",
              "      <td>64367.5</td>\n",
              "      <td>64277.7</td>\n",
              "      <td>63997.1</td>\n",
              "      <td>64252.3</td>\n",
              "      <td>63722.7</td>\n",
              "      <td>64432.6</td>\n",
              "      <td>64509.5</td>\n",
              "      <td>64529.9</td>\n",
              "      <td>63846</td>\n",
              "      <td>63816.9</td>\n",
              "      <td>63996</td>\n",
              "      <td>64503.7</td>\n",
              "      <td>64788</td>\n",
              "      <td>65285.9</td>\n",
              "      <td>65080.7</td>\n",
              "      <td>65119.8</td>\n",
              "      <td>65150.6</td>\n",
              "      <td>65960.2</td>\n",
              "      <td>66500.6</td>\n",
              "      <td>66659.3</td>\n",
              "      <td>66353.8</td>\n",
              "      <td>66486.4</td>\n",
              "      <td>67350.6</td>\n",
              "      <td>67981.2</td>\n",
              "      <td>67823.8</td>\n",
              "      <td>68470.5</td>\n",
              "      <td>69353.5</td>\n",
              "      <td>70764.1</td>\n",
              "      <td>71129.8</td>\n",
              "      <td>72140.7</td>\n",
              "      <td>72830.3</td>\n",
              "      <td>73378.8</td>\n",
              "      <td>73619.6</td>\n",
              "      <td>74630.1</td>\n",
              "      <td>76863.5</td>\n",
              "      <td>78064.9</td>\n",
              "      <td>...</td>\n",
              "      <td>333651</td>\n",
              "      <td>336980</td>\n",
              "      <td>344041</td>\n",
              "      <td>344517</td>\n",
              "      <td>339808</td>\n",
              "      <td>335705</td>\n",
              "      <td>336239</td>\n",
              "      <td>340598</td>\n",
              "      <td>342096</td>\n",
              "      <td>341254</td>\n",
              "      <td>339632</td>\n",
              "      <td>338476</td>\n",
              "      <td>336410</td>\n",
              "      <td>341480</td>\n",
              "      <td>345693</td>\n",
              "      <td>347531</td>\n",
              "      <td>346151</td>\n",
              "      <td>344681</td>\n",
              "      <td>344172</td>\n",
              "      <td>343667</td>\n",
              "      <td>338708</td>\n",
              "      <td>339186</td>\n",
              "      <td>336680</td>\n",
              "      <td>339330</td>\n",
              "      <td>336981</td>\n",
              "      <td>339324</td>\n",
              "      <td>338346</td>\n",
              "      <td>337523</td>\n",
              "      <td>333340</td>\n",
              "      <td>332920</td>\n",
              "      <td>333657</td>\n",
              "      <td>336302</td>\n",
              "      <td>334765</td>\n",
              "      <td>337760</td>\n",
              "      <td>339215</td>\n",
              "      <td>346840</td>\n",
              "      <td>339408</td>\n",
              "      <td>341611</td>\n",
              "      <td>344964</td>\n",
              "      <td>350938</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Brent</td>\n",
              "      <td>E09000005</td>\n",
              "      <td>71306.6</td>\n",
              "      <td>72022.3</td>\n",
              "      <td>72015.8</td>\n",
              "      <td>72965.6</td>\n",
              "      <td>73704</td>\n",
              "      <td>74310.5</td>\n",
              "      <td>74127</td>\n",
              "      <td>73547</td>\n",
              "      <td>73789.5</td>\n",
              "      <td>73264.1</td>\n",
              "      <td>72782</td>\n",
              "      <td>72523.7</td>\n",
              "      <td>72806.3</td>\n",
              "      <td>73084.1</td>\n",
              "      <td>72779.8</td>\n",
              "      <td>72369.7</td>\n",
              "      <td>72994.8</td>\n",
              "      <td>73497.6</td>\n",
              "      <td>75551.2</td>\n",
              "      <td>76913.7</td>\n",
              "      <td>78667.1</td>\n",
              "      <td>77990.9</td>\n",
              "      <td>77914.2</td>\n",
              "      <td>78261.6</td>\n",
              "      <td>79664</td>\n",
              "      <td>81213.2</td>\n",
              "      <td>82321.9</td>\n",
              "      <td>82771</td>\n",
              "      <td>82729.7</td>\n",
              "      <td>83876.3</td>\n",
              "      <td>87636.9</td>\n",
              "      <td>90164</td>\n",
              "      <td>91472.6</td>\n",
              "      <td>92208.2</td>\n",
              "      <td>92895.5</td>\n",
              "      <td>94035.6</td>\n",
              "      <td>93746</td>\n",
              "      <td>95171.5</td>\n",
              "      <td>...</td>\n",
              "      <td>490062</td>\n",
              "      <td>492335</td>\n",
              "      <td>491003</td>\n",
              "      <td>498192</td>\n",
              "      <td>490673</td>\n",
              "      <td>489039</td>\n",
              "      <td>485285</td>\n",
              "      <td>494515</td>\n",
              "      <td>493882</td>\n",
              "      <td>493621</td>\n",
              "      <td>482967</td>\n",
              "      <td>485434</td>\n",
              "      <td>480836</td>\n",
              "      <td>492743</td>\n",
              "      <td>505028</td>\n",
              "      <td>519754</td>\n",
              "      <td>510930</td>\n",
              "      <td>493489</td>\n",
              "      <td>479104</td>\n",
              "      <td>476356</td>\n",
              "      <td>479106</td>\n",
              "      <td>478494</td>\n",
              "      <td>475430</td>\n",
              "      <td>486253</td>\n",
              "      <td>481803</td>\n",
              "      <td>474821</td>\n",
              "      <td>473849</td>\n",
              "      <td>488784</td>\n",
              "      <td>501533</td>\n",
              "      <td>494770</td>\n",
              "      <td>432188</td>\n",
              "      <td>427126</td>\n",
              "      <td>423161</td>\n",
              "      <td>467145</td>\n",
              "      <td>461398</td>\n",
              "      <td>494455</td>\n",
              "      <td>466574</td>\n",
              "      <td>487237</td>\n",
              "      <td>481094</td>\n",
              "      <td>487949</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 310 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "Unnamed: 0               index  ... 2020-08-01 00:00:00\n",
              "0               City of London  ...              814665\n",
              "1           Barking & Dagenham  ...              302395\n",
              "2                       Barnet  ...              522846\n",
              "3                       Bexley  ...              350938\n",
              "4                        Brent  ...              487949\n",
              "\n",
              "[5 rows x 310 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 47
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "o1uLbJAsoIjK"
      },
      "source": [
        "**2.3. Cleaning the data (part 2)**\n",
        "\n",
        "You might we have to **rename** a couple columns. How do you do this? The clue's pretty bold..."
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "GKkmn1AnoVZS",
        "outputId": "96399a36-7f43-43ff-a274-04f3a3d45224",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 381
        }
      },
      "source": [
        "properties.rename(columns={'index': 'Borough', properties.columns[1]: 'Entry'}, inplace=True)\n",
        "properties.columns.name = '' #I didnt know what Unnamed : 0 meant so I removed it\n",
        "properties.head()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Borough</th>\n",
              "      <th>Entry</th>\n",
              "      <th>1995-01-01 00:00:00</th>\n",
              "      <th>1995-02-01 00:00:00</th>\n",
              "      <th>1995-03-01 00:00:00</th>\n",
              "      <th>1995-04-01 00:00:00</th>\n",
              "      <th>1995-05-01 00:00:00</th>\n",
              "      <th>1995-06-01 00:00:00</th>\n",
              "      <th>1995-07-01 00:00:00</th>\n",
              "      <th>1995-08-01 00:00:00</th>\n",
              "      <th>1995-09-01 00:00:00</th>\n",
              "      <th>1995-10-01 00:00:00</th>\n",
              "      <th>1995-11-01 00:00:00</th>\n",
              "      <th>1995-12-01 00:00:00</th>\n",
              "      <th>1996-01-01 00:00:00</th>\n",
              "      <th>1996-02-01 00:00:00</th>\n",
              "      <th>1996-03-01 00:00:00</th>\n",
              "      <th>1996-04-01 00:00:00</th>\n",
              "      <th>1996-05-01 00:00:00</th>\n",
              "      <th>1996-06-01 00:00:00</th>\n",
              "      <th>1996-07-01 00:00:00</th>\n",
              "      <th>1996-08-01 00:00:00</th>\n",
              "      <th>1996-09-01 00:00:00</th>\n",
              "      <th>1996-10-01 00:00:00</th>\n",
              "      <th>1996-11-01 00:00:00</th>\n",
              "      <th>1996-12-01 00:00:00</th>\n",
              "      <th>1997-01-01 00:00:00</th>\n",
              "      <th>1997-02-01 00:00:00</th>\n",
              "      <th>1997-03-01 00:00:00</th>\n",
              "      <th>1997-04-01 00:00:00</th>\n",
              "      <th>1997-05-01 00:00:00</th>\n",
              "      <th>1997-06-01 00:00:00</th>\n",
              "      <th>1997-07-01 00:00:00</th>\n",
              "      <th>1997-08-01 00:00:00</th>\n",
              "      <th>1997-09-01 00:00:00</th>\n",
              "      <th>1997-10-01 00:00:00</th>\n",
              "      <th>1997-11-01 00:00:00</th>\n",
              "      <th>1997-12-01 00:00:00</th>\n",
              "      <th>1998-01-01 00:00:00</th>\n",
              "      <th>1998-02-01 00:00:00</th>\n",
              "      <th>...</th>\n",
              "      <th>2017-05-01 00:00:00</th>\n",
              "      <th>2017-06-01 00:00:00</th>\n",
              "      <th>2017-07-01 00:00:00</th>\n",
              "      <th>2017-08-01 00:00:00</th>\n",
              "      <th>2017-09-01 00:00:00</th>\n",
              "      <th>2017-10-01 00:00:00</th>\n",
              "      <th>2017-11-01 00:00:00</th>\n",
              "      <th>2017-12-01 00:00:00</th>\n",
              "      <th>2018-01-01 00:00:00</th>\n",
              "      <th>2018-02-01 00:00:00</th>\n",
              "      <th>2018-03-01 00:00:00</th>\n",
              "      <th>2018-04-01 00:00:00</th>\n",
              "      <th>2018-05-01 00:00:00</th>\n",
              "      <th>2018-06-01 00:00:00</th>\n",
              "      <th>2018-07-01 00:00:00</th>\n",
              "      <th>2018-08-01 00:00:00</th>\n",
              "      <th>2018-09-01 00:00:00</th>\n",
              "      <th>2018-10-01 00:00:00</th>\n",
              "      <th>2018-11-01 00:00:00</th>\n",
              "      <th>2018-12-01 00:00:00</th>\n",
              "      <th>2019-01-01 00:00:00</th>\n",
              "      <th>2019-02-01 00:00:00</th>\n",
              "      <th>2019-03-01 00:00:00</th>\n",
              "      <th>2019-04-01 00:00:00</th>\n",
              "      <th>2019-05-01 00:00:00</th>\n",
              "      <th>2019-06-01 00:00:00</th>\n",
              "      <th>2019-07-01 00:00:00</th>\n",
              "      <th>2019-08-01 00:00:00</th>\n",
              "      <th>2019-09-01 00:00:00</th>\n",
              "      <th>2019-10-01 00:00:00</th>\n",
              "      <th>2019-11-01 00:00:00</th>\n",
              "      <th>2019-12-01 00:00:00</th>\n",
              "      <th>2020-01-01 00:00:00</th>\n",
              "      <th>2020-02-01 00:00:00</th>\n",
              "      <th>2020-03-01 00:00:00</th>\n",
              "      <th>2020-04-01 00:00:00</th>\n",
              "      <th>2020-05-01 00:00:00</th>\n",
              "      <th>2020-06-01 00:00:00</th>\n",
              "      <th>2020-07-01 00:00:00</th>\n",
              "      <th>2020-08-01 00:00:00</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>City of London</td>\n",
              "      <td>E09000001</td>\n",
              "      <td>91449</td>\n",
              "      <td>82202.8</td>\n",
              "      <td>79120.7</td>\n",
              "      <td>77101.2</td>\n",
              "      <td>84409.1</td>\n",
              "      <td>94900.5</td>\n",
              "      <td>110128</td>\n",
              "      <td>112329</td>\n",
              "      <td>104473</td>\n",
              "      <td>108038</td>\n",
              "      <td>117636</td>\n",
              "      <td>127232</td>\n",
              "      <td>108999</td>\n",
              "      <td>93356.7</td>\n",
              "      <td>93706.7</td>\n",
              "      <td>120543</td>\n",
              "      <td>112050</td>\n",
              "      <td>114226</td>\n",
              "      <td>97546.7</td>\n",
              "      <td>114179</td>\n",
              "      <td>108138</td>\n",
              "      <td>98934.2</td>\n",
              "      <td>99706.8</td>\n",
              "      <td>106427</td>\n",
              "      <td>116343</td>\n",
              "      <td>111142</td>\n",
              "      <td>107488</td>\n",
              "      <td>108480</td>\n",
              "      <td>115453</td>\n",
              "      <td>118317</td>\n",
              "      <td>117034</td>\n",
              "      <td>113585</td>\n",
              "      <td>115159</td>\n",
              "      <td>121251</td>\n",
              "      <td>131074</td>\n",
              "      <td>130035</td>\n",
              "      <td>124382</td>\n",
              "      <td>143829</td>\n",
              "      <td>...</td>\n",
              "      <td>939912</td>\n",
              "      <td>930979</td>\n",
              "      <td>854798</td>\n",
              "      <td>847422</td>\n",
              "      <td>836674</td>\n",
              "      <td>818477</td>\n",
              "      <td>790159</td>\n",
              "      <td>778002</td>\n",
              "      <td>802129</td>\n",
              "      <td>783266</td>\n",
              "      <td>740799</td>\n",
              "      <td>732351</td>\n",
              "      <td>796399</td>\n",
              "      <td>789278</td>\n",
              "      <td>809697</td>\n",
              "      <td>784144</td>\n",
              "      <td>800875</td>\n",
              "      <td>802869</td>\n",
              "      <td>764207</td>\n",
              "      <td>811694</td>\n",
              "      <td>865636</td>\n",
              "      <td>894520</td>\n",
              "      <td>853451</td>\n",
              "      <td>738797</td>\n",
              "      <td>719218</td>\n",
              "      <td>761526</td>\n",
              "      <td>756407</td>\n",
              "      <td>813770</td>\n",
              "      <td>810455</td>\n",
              "      <td>826227</td>\n",
              "      <td>776894</td>\n",
              "      <td>737275</td>\n",
              "      <td>747611</td>\n",
              "      <td>777640</td>\n",
              "      <td>844989</td>\n",
              "      <td>867841</td>\n",
              "      <td>899831</td>\n",
              "      <td>938833</td>\n",
              "      <td>852151</td>\n",
              "      <td>814665</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Barking &amp; Dagenham</td>\n",
              "      <td>E09000002</td>\n",
              "      <td>50460.2</td>\n",
              "      <td>51085.8</td>\n",
              "      <td>51269</td>\n",
              "      <td>53133.5</td>\n",
              "      <td>53042.2</td>\n",
              "      <td>53700.3</td>\n",
              "      <td>52113.1</td>\n",
              "      <td>52232.2</td>\n",
              "      <td>51471.6</td>\n",
              "      <td>51513.8</td>\n",
              "      <td>50848.7</td>\n",
              "      <td>50945.2</td>\n",
              "      <td>50828.1</td>\n",
              "      <td>51440.7</td>\n",
              "      <td>51907.1</td>\n",
              "      <td>51724</td>\n",
              "      <td>51735.7</td>\n",
              "      <td>50761.4</td>\n",
              "      <td>50621.1</td>\n",
              "      <td>51104.7</td>\n",
              "      <td>51892.7</td>\n",
              "      <td>52533.2</td>\n",
              "      <td>52216</td>\n",
              "      <td>53853.5</td>\n",
              "      <td>54459</td>\n",
              "      <td>55451.5</td>\n",
              "      <td>55004.8</td>\n",
              "      <td>55279.9</td>\n",
              "      <td>54936.9</td>\n",
              "      <td>55286.7</td>\n",
              "      <td>55658.9</td>\n",
              "      <td>56506.7</td>\n",
              "      <td>56306.3</td>\n",
              "      <td>57200.2</td>\n",
              "      <td>57575.3</td>\n",
              "      <td>58025</td>\n",
              "      <td>57559</td>\n",
              "      <td>57360.3</td>\n",
              "      <td>...</td>\n",
              "      <td>286018</td>\n",
              "      <td>289569</td>\n",
              "      <td>291727</td>\n",
              "      <td>290965</td>\n",
              "      <td>292519</td>\n",
              "      <td>293390</td>\n",
              "      <td>293796</td>\n",
              "      <td>292915</td>\n",
              "      <td>291548</td>\n",
              "      <td>292777</td>\n",
              "      <td>291723</td>\n",
              "      <td>291184</td>\n",
              "      <td>290239</td>\n",
              "      <td>294236</td>\n",
              "      <td>294953</td>\n",
              "      <td>295908</td>\n",
              "      <td>296424</td>\n",
              "      <td>299648</td>\n",
              "      <td>302606</td>\n",
              "      <td>301114</td>\n",
              "      <td>297181</td>\n",
              "      <td>293839</td>\n",
              "      <td>294065</td>\n",
              "      <td>295498</td>\n",
              "      <td>295092</td>\n",
              "      <td>293889</td>\n",
              "      <td>297426</td>\n",
              "      <td>299421</td>\n",
              "      <td>304778</td>\n",
              "      <td>304579</td>\n",
              "      <td>306390</td>\n",
              "      <td>301283</td>\n",
              "      <td>303653</td>\n",
              "      <td>304265</td>\n",
              "      <td>304099</td>\n",
              "      <td>283139</td>\n",
              "      <td>295744</td>\n",
              "      <td>300595</td>\n",
              "      <td>304223</td>\n",
              "      <td>302395</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Barnet</td>\n",
              "      <td>E09000003</td>\n",
              "      <td>93284.5</td>\n",
              "      <td>93190.2</td>\n",
              "      <td>92247.5</td>\n",
              "      <td>90762.9</td>\n",
              "      <td>90258</td>\n",
              "      <td>90107.2</td>\n",
              "      <td>91441.2</td>\n",
              "      <td>92361.3</td>\n",
              "      <td>93273.1</td>\n",
              "      <td>92567.4</td>\n",
              "      <td>90883.2</td>\n",
              "      <td>91133.9</td>\n",
              "      <td>91111</td>\n",
              "      <td>92429.5</td>\n",
              "      <td>91409.8</td>\n",
              "      <td>92394.2</td>\n",
              "      <td>91058.9</td>\n",
              "      <td>91978.2</td>\n",
              "      <td>92444.1</td>\n",
              "      <td>95516</td>\n",
              "      <td>97489.9</td>\n",
              "      <td>97844.5</td>\n",
              "      <td>97155</td>\n",
              "      <td>97174.3</td>\n",
              "      <td>98558.8</td>\n",
              "      <td>100076</td>\n",
              "      <td>101130</td>\n",
              "      <td>101201</td>\n",
              "      <td>103287</td>\n",
              "      <td>104609</td>\n",
              "      <td>107235</td>\n",
              "      <td>108730</td>\n",
              "      <td>112380</td>\n",
              "      <td>114515</td>\n",
              "      <td>115356</td>\n",
              "      <td>115521</td>\n",
              "      <td>115902</td>\n",
              "      <td>116995</td>\n",
              "      <td>...</td>\n",
              "      <td>544994</td>\n",
              "      <td>531344</td>\n",
              "      <td>527928</td>\n",
              "      <td>526223</td>\n",
              "      <td>537986</td>\n",
              "      <td>544090</td>\n",
              "      <td>541563</td>\n",
              "      <td>538718</td>\n",
              "      <td>531832</td>\n",
              "      <td>531736</td>\n",
              "      <td>538120</td>\n",
              "      <td>541502</td>\n",
              "      <td>533088</td>\n",
              "      <td>524702</td>\n",
              "      <td>523397</td>\n",
              "      <td>533715</td>\n",
              "      <td>534951</td>\n",
              "      <td>537284</td>\n",
              "      <td>535060</td>\n",
              "      <td>533810</td>\n",
              "      <td>528639</td>\n",
              "      <td>523679</td>\n",
              "      <td>516531</td>\n",
              "      <td>512343</td>\n",
              "      <td>503911</td>\n",
              "      <td>512694</td>\n",
              "      <td>514668</td>\n",
              "      <td>528577</td>\n",
              "      <td>526670</td>\n",
              "      <td>525678</td>\n",
              "      <td>522639</td>\n",
              "      <td>519306</td>\n",
              "      <td>518542</td>\n",
              "      <td>519121</td>\n",
              "      <td>527747</td>\n",
              "      <td>526553</td>\n",
              "      <td>532503</td>\n",
              "      <td>519064</td>\n",
              "      <td>524400</td>\n",
              "      <td>522846</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Bexley</td>\n",
              "      <td>E09000004</td>\n",
              "      <td>64958.1</td>\n",
              "      <td>64787.9</td>\n",
              "      <td>64367.5</td>\n",
              "      <td>64277.7</td>\n",
              "      <td>63997.1</td>\n",
              "      <td>64252.3</td>\n",
              "      <td>63722.7</td>\n",
              "      <td>64432.6</td>\n",
              "      <td>64509.5</td>\n",
              "      <td>64529.9</td>\n",
              "      <td>63846</td>\n",
              "      <td>63816.9</td>\n",
              "      <td>63996</td>\n",
              "      <td>64503.7</td>\n",
              "      <td>64788</td>\n",
              "      <td>65285.9</td>\n",
              "      <td>65080.7</td>\n",
              "      <td>65119.8</td>\n",
              "      <td>65150.6</td>\n",
              "      <td>65960.2</td>\n",
              "      <td>66500.6</td>\n",
              "      <td>66659.3</td>\n",
              "      <td>66353.8</td>\n",
              "      <td>66486.4</td>\n",
              "      <td>67350.6</td>\n",
              "      <td>67981.2</td>\n",
              "      <td>67823.8</td>\n",
              "      <td>68470.5</td>\n",
              "      <td>69353.5</td>\n",
              "      <td>70764.1</td>\n",
              "      <td>71129.8</td>\n",
              "      <td>72140.7</td>\n",
              "      <td>72830.3</td>\n",
              "      <td>73378.8</td>\n",
              "      <td>73619.6</td>\n",
              "      <td>74630.1</td>\n",
              "      <td>76863.5</td>\n",
              "      <td>78064.9</td>\n",
              "      <td>...</td>\n",
              "      <td>333651</td>\n",
              "      <td>336980</td>\n",
              "      <td>344041</td>\n",
              "      <td>344517</td>\n",
              "      <td>339808</td>\n",
              "      <td>335705</td>\n",
              "      <td>336239</td>\n",
              "      <td>340598</td>\n",
              "      <td>342096</td>\n",
              "      <td>341254</td>\n",
              "      <td>339632</td>\n",
              "      <td>338476</td>\n",
              "      <td>336410</td>\n",
              "      <td>341480</td>\n",
              "      <td>345693</td>\n",
              "      <td>347531</td>\n",
              "      <td>346151</td>\n",
              "      <td>344681</td>\n",
              "      <td>344172</td>\n",
              "      <td>343667</td>\n",
              "      <td>338708</td>\n",
              "      <td>339186</td>\n",
              "      <td>336680</td>\n",
              "      <td>339330</td>\n",
              "      <td>336981</td>\n",
              "      <td>339324</td>\n",
              "      <td>338346</td>\n",
              "      <td>337523</td>\n",
              "      <td>333340</td>\n",
              "      <td>332920</td>\n",
              "      <td>333657</td>\n",
              "      <td>336302</td>\n",
              "      <td>334765</td>\n",
              "      <td>337760</td>\n",
              "      <td>339215</td>\n",
              "      <td>346840</td>\n",
              "      <td>339408</td>\n",
              "      <td>341611</td>\n",
              "      <td>344964</td>\n",
              "      <td>350938</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Brent</td>\n",
              "      <td>E09000005</td>\n",
              "      <td>71306.6</td>\n",
              "      <td>72022.3</td>\n",
              "      <td>72015.8</td>\n",
              "      <td>72965.6</td>\n",
              "      <td>73704</td>\n",
              "      <td>74310.5</td>\n",
              "      <td>74127</td>\n",
              "      <td>73547</td>\n",
              "      <td>73789.5</td>\n",
              "      <td>73264.1</td>\n",
              "      <td>72782</td>\n",
              "      <td>72523.7</td>\n",
              "      <td>72806.3</td>\n",
              "      <td>73084.1</td>\n",
              "      <td>72779.8</td>\n",
              "      <td>72369.7</td>\n",
              "      <td>72994.8</td>\n",
              "      <td>73497.6</td>\n",
              "      <td>75551.2</td>\n",
              "      <td>76913.7</td>\n",
              "      <td>78667.1</td>\n",
              "      <td>77990.9</td>\n",
              "      <td>77914.2</td>\n",
              "      <td>78261.6</td>\n",
              "      <td>79664</td>\n",
              "      <td>81213.2</td>\n",
              "      <td>82321.9</td>\n",
              "      <td>82771</td>\n",
              "      <td>82729.7</td>\n",
              "      <td>83876.3</td>\n",
              "      <td>87636.9</td>\n",
              "      <td>90164</td>\n",
              "      <td>91472.6</td>\n",
              "      <td>92208.2</td>\n",
              "      <td>92895.5</td>\n",
              "      <td>94035.6</td>\n",
              "      <td>93746</td>\n",
              "      <td>95171.5</td>\n",
              "      <td>...</td>\n",
              "      <td>490062</td>\n",
              "      <td>492335</td>\n",
              "      <td>491003</td>\n",
              "      <td>498192</td>\n",
              "      <td>490673</td>\n",
              "      <td>489039</td>\n",
              "      <td>485285</td>\n",
              "      <td>494515</td>\n",
              "      <td>493882</td>\n",
              "      <td>493621</td>\n",
              "      <td>482967</td>\n",
              "      <td>485434</td>\n",
              "      <td>480836</td>\n",
              "      <td>492743</td>\n",
              "      <td>505028</td>\n",
              "      <td>519754</td>\n",
              "      <td>510930</td>\n",
              "      <td>493489</td>\n",
              "      <td>479104</td>\n",
              "      <td>476356</td>\n",
              "      <td>479106</td>\n",
              "      <td>478494</td>\n",
              "      <td>475430</td>\n",
              "      <td>486253</td>\n",
              "      <td>481803</td>\n",
              "      <td>474821</td>\n",
              "      <td>473849</td>\n",
              "      <td>488784</td>\n",
              "      <td>501533</td>\n",
              "      <td>494770</td>\n",
              "      <td>432188</td>\n",
              "      <td>427126</td>\n",
              "      <td>423161</td>\n",
              "      <td>467145</td>\n",
              "      <td>461398</td>\n",
              "      <td>494455</td>\n",
              "      <td>466574</td>\n",
              "      <td>487237</td>\n",
              "      <td>481094</td>\n",
              "      <td>487949</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 310 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "              Borough      Entry  ... 2020-07-01 00:00:00 2020-08-01 00:00:00\n",
              "0      City of London  E09000001  ...              852151              814665\n",
              "1  Barking & Dagenham  E09000002  ...              304223              302395\n",
              "2              Barnet  E09000003  ...              524400              522846\n",
              "3              Bexley  E09000004  ...              344964              350938\n",
              "4               Brent  E09000005  ...              481094              487949\n",
              "\n",
              "[5 rows x 310 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 54
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "jy8BzXHmoWEw"
      },
      "source": [
        "**2.4.Transforming the data**\n",
        "\n",
        "Remember what Wes McKinney said about tidy data? \n",
        "\n",
        "You might need to **melt** your DataFrame here. "
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "S2wM0qLuo2Zt"
      },
      "source": [
        "properties = pd.melt(properties, id_vars=['Entry', 'Borough'], var_name='Year/Month', value_name='Housing Price')\n"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "7kIsgAo7o3mf"
      },
      "source": [
        "Remember to make sure your column data types are all correct. Average prices, for example, should be floating point numbers... "
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ZcR4IHbcpOaq",
        "outputId": "2bb95894-fb24-4417-8871-763c10a92f96",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 204
        }
      },
      "source": [
        "properties['Housing Price'] = pd.to_numeric(properties['Housing Price'])\n",
        "properties.dtypes\n",
        "properties.head()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Entry</th>\n",
              "      <th>Borough</th>\n",
              "      <th>Year/Month</th>\n",
              "      <th>Housing Price</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>E09000001</td>\n",
              "      <td>City of London</td>\n",
              "      <td>1995-01-01</td>\n",
              "      <td>91448.98487</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>E09000002</td>\n",
              "      <td>Barking &amp; Dagenham</td>\n",
              "      <td>1995-01-01</td>\n",
              "      <td>50460.22660</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>E09000003</td>\n",
              "      <td>Barnet</td>\n",
              "      <td>1995-01-01</td>\n",
              "      <td>93284.51832</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>E09000004</td>\n",
              "      <td>Bexley</td>\n",
              "      <td>1995-01-01</td>\n",
              "      <td>64958.09036</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>E09000005</td>\n",
              "      <td>Brent</td>\n",
              "      <td>1995-01-01</td>\n",
              "      <td>71306.56698</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "       Entry             Borough Year/Month  Housing Price\n",
              "0  E09000001      City of London 1995-01-01    91448.98487\n",
              "1  E09000002  Barking & Dagenham 1995-01-01    50460.22660\n",
              "2  E09000003              Barnet 1995-01-01    93284.51832\n",
              "3  E09000004              Bexley 1995-01-01    64958.09036\n",
              "4  E09000005               Brent 1995-01-01    71306.56698"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 68
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "knLUXHLypOtw"
      },
      "source": [
        "**2.5. Cleaning the data (part 3)**\n",
        "\n",
        "Do we have an equal number of observations in the ID, Average Price, Month, and London Borough columns? Remember that there are only 32 London Boroughs. How many entries do you have in that column? \n",
        "\n",
        "Check out the contents of the London Borough column, and if you find null values, get rid of them however you see fit. "
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "BnvTW5a3p0fC",
        "outputId": "34733df5-fc50-46e1-a99d-9454eca645f3",
        "colab": {
          "base_uri": "https://localhost:8080/"
        }
      },
      "source": [
        "properties.dropna(inplace=True)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Entry            13860\n",
              "Borough          13860\n",
              "Year/Month       13860\n",
              "Housing Price    13860\n",
              "dtype: int64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 78
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "PGEx6mJsp6dG"
      },
      "source": [
        "**2.6. Visualizing the data**\n",
        "\n",
        "To visualize the data, why not subset on a particular London Borough? Maybe do a line plot of Month against Average Price?"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "nAg5pT9cqHAR",
        "outputId": "9491307e-f068-40d9-82a7-56d4c5f2e519",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 295
        }
      },
      "source": [
        "brent_df = properties[properties['Borough'] == 'Brent']\n",
        "brent_df.plot(x='Year/Month', y='Housing Price')\n",
        "plt.ylabel('Housing Price')\n",
        "plt.title('Brent Housing Price Fluctuations')\n",
        "plt.show()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAZcAAAEWCAYAAACqitpwAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nOzdd3xV9f348dc7OyQhIYSVBAgyZYSNgnugYq1Y664KDqytq7Wto+2vVq2tdvt1VSuIuK04UHFvBWQTpswACQGyCNnrvn9/nJN4CUlIwr25Ge/n43EfufdzxudzDof7vp9xPkdUFWOMMcaXggJdAGOMMR2PBRdjjDE+Z8HFGGOMz1lwMcYY43MWXIwxxvicBRdjjDE+Z8HFmCYSkSIROaYNlOM/IvL/WjG/z0Xk+tbKr6Va+7yYxllwMY0SkXQRKXW/WPNF5F0R6evn/M5sZPmpIpJRT7rfvwBVNVpVt/t6vyLyRxGpdM/xARFZJCKTGynHjap6vx/LUPO6w4f7r/ff7Sj2N1NEvvZO88d5MS1nwcU0xQ9VNRroA+wDHmloRREJbrVSdSyvuOe4B/A18LqISN2V/Hx+X3EDaM3rr37My3RwFlxMk6lqGfAaMLwmTUTmisgTIrJQRIqB00QkUUTmi0i2iOwQkVu91v+jiLwqIvNEpFBE1ovIBHfZc0A/4O2j/eUsIrNEZKuI5InIAhFJdNNTRERFJMRr3dpaj4gMEpEvRKRARHJE5BWv9VREBnkd92NuTa5QRL4VkYFe654lIt+5+3nc3ecRa1aqWgk8C/QGujdwfueKyJ+88pouIqtF5KCIbBORc9z0WBGZLSJZIpIpIn862uDk/vs97/X5kPMpIvEi8oyI7HFrum+KSBTwHpDoVStKrOc4DqndiMhd7vEUisgGEfmRm34s8B9gck1tz02vu796rwF3mYrIjSKyxa0tPlYTzBu7BkzTWXAxTSYiXYBLgSV1Fl0BPADEAIuAt4E1QBJwBvALETnba/3zgZeBOGAB8CiAql4F7MKtKbX0l7OInA78BbgEp7a1082vKe4HPgS6Ack0UksDLgPuddfdinMOEJEEnCB8N9Ad+A6Y0sSyhwMzgd2qmuMme5/fr+usPwmYB/wG53yeDKS7i+cCVcAgYCxwFuDvvpPngC7ACKAn8C9VLQamAXu8akV7mrCvbcBJQCzOeX5eRPqo6kbgRmCxu6+4uhs28Ro4D5gIpLrr1VyjzbkGTAMsuJimeNP9dVgATAX+Vmf5W6r6jap6gFFAD1W9T1Ur3D6K/+J8Edf4WlUXqmo1zpfR6GaWJ9H9tVn7Ak70Wv4TYI6qrlTVcpwv+ckiktKEfVcC/YFEVS1T1a8bWfcNVV2qqlXAC8AYN/1cYL2qvu4u+z9g7xHyvcQ9jt3AeOBHXstqz69be/R2Hc6xfuQuz1TVTSLSyy3HL1S1WFX3A//i0H+Hesvg9UpsZN3DiEgfnCByo6rmq2qlqn7RnH14U9X/qeoe97heAbYAk5q4eVOugQdV9YCq7gI+4/t/v+ZcA6YBFlxMU1zg/jqMAG4GvhCR3l7Ld3u970+dL3/gt0Avr3W8v2hLgAjvZqom2KOqcd4vDv1Fn4jzSxUAVS0CcnFqUkdyByDAUrfJ7tpG1q17HNFe+deeE3Vmhz1SZ/ar7rH0VNXTVXWF17LdDW4FfXF+4dfVHwgFsrz+HZ7EqU0cqQw1r6bULuqWJU9V85u5Xb1E5Gq3ua+m/COBhCZu3pRroKF/v+ZcA6YBzfkPbTo5t6bxuog8iVNTeK1mkddqu4Edqjq4pdkcRRFr7MH5cgXAbfPvDmQCxW5yF+Cg+742UKrqXmCWu92JwMci8qWqbm1G/lk4zSk1+Yv35xZo7JzsBgY2kF4OJLi1J18pxjl3Ner+yIgXkThVPVBnu/qOocF9iUh/nBrvGTjNX9UishrnS7+h/Xlr7BpolI+ugU7Pai6mycQxHactemMDqy0FCkXkThGJFJFgERkpIhObmM0+4GjvJXkJuEZExrh9GH8GvlXVdFXNxvmCudIt27V4fTmLyMUiUhMI8nG+xDzNzP9dYJSIXODWyG7i0C9hX5qNc6xniEiQiCSJyDBVzcLpN/iHiHR1lw0UkVOOMr/VwMki0k9EYnGamwBw83wPeFxEuolIqIic7C7ehzNAIbbOvs51BwH0Bn7htSwK59xnA4jINTg1lxr7gGQRCWugnA1eA0c6QB9dA52eBRfTFG+LSBHOL/0HgBmqur6+Fd3azXk47dc7gBzgaZxO2ab4C/B7tynk1y0prKp+DPw/YD5OLWIgh/Y1zMLpAM/F6Xhe5LVsIvCte7wLgNuae2+L2xF/MfBXN4/hwHKcmoRPqepS4Bqc/pQC4Au+/8V+NRAGbMD5knwNp3P7aPL7CHgFSANWAO/UWeUqnD6LTcB+3IChqptwvvC3e/XnPIcz8CMdJxDWjspS1Q3AP4DFOIFkFPCNVz6fAuuBvSKSQx1NuAYac9TXgAGxh4UZ418iEoTT5/ITVf0s0OUxpjVYzcUYPxCRs0Ukzm2S+S1OX0HdIdzGdFgWXIzxj8k4o7hygB/ijLgrDWyRjGk91ixmjDHG56zmYowxxufsPhdXQkKCpqSkBLoYxhjTrqxYsSJHVXvUTbfg4kpJSWH58uWBLoYxxrQrIrKzvnRrFjPGGONzFlyMMcb4nAUXY4wxPmd9Lo2orKwkIyODsrK6s5ybQIuIiCA5OZnQ0NBAF8UYUw8LLo3IyMggJiaGlJQU5PAnzpoAUVVyc3PJyMhgwIABgS6OMaYe1izWiLKyMrp3726BpY0REbp37241SmPaMAsuR2CBpW2yfxdj2jYLLsYY04GUVVbz0tJdVHsCO7WXBZc2Ljo6+pDPc+fO5eabb/ZpHueeey4HDtR9cGDzpaenExkZyZgxYxg+fDg33ngjHs/hz1jas2cPF1100VHnZ4w53Afr93L362v5dNP+gJbDgoth4cKFxMXF+WRfAwcOZPXq1aSlpbFhwwbefPPNQ5ZXVVWRmJjIa6+91sAejDFH47u9hQB8uTk7oOWw4NKOpaenc/rpp5OamsoZZ5zBrl27AJg5c+YhX941tZ+srCxOPvlkxowZw8iRI/nqq68AZ+qbnJwc0tPTOfbYY5k1axYjRozgrLPOorTUmSV+2bJlpKamMmbMGH7zm98wcuRIGhMSEsKUKVPYunUrc+fO5fzzz+f000/njDPOID09vXb76upqfv3rXzNy5EhSU1N55JFHAFixYgWnnHIK48eP5+yzzyYrK8u3J8+YDmrzviIAPt+8n0DOem9DkZvo3rfXs2HPQZ/uc3hiV+754YhG1yktLWXMmDG1n/Py8jj//PMBuOWWW5gxYwYzZsxgzpw53HrrrYfVFLy9+OKLnH322fzud7+jurqakpKSw9bZsmULL730Ev/973+55JJLmD9/PldeeSXXXHMN//3vf5k8eTJ33XXXEY+tpKSETz75hPvuu499+/axcuVK0tLSiI+PJz09vXa9p556ivT0dFavXk1ISAh5eXlUVlZyyy238NZbb9GjRw9eeeUVfve73zFnzpwj5mtMZ7dlfyGhwcLuvFLSc0sYkBAVkHJYcGnjIiMjWb16de3nuXPn1k6wuXjxYl5//XUArrrqKu64445G9zVx4kSuvfZaKisrueCCCw4JWjUGDBhQmz5+/HjS09M5cOAAhYWFTJ48GYArrriCd96p++h0x7Zt2xgzZgwiwvTp05k2bRpz585l6tSpxMfHH7b+xx9/zI033khIiHMpxsfHs27dOtatW8fUqVMBp3bTp89RPfrdmE6htKKaXXklnDuyD++uzSIt44AFl7buSDWMtiQkJKS2I93j8VBRUQHAySefzJdffsm7777LzJkzuf3227n66qsP2TY8PLz2fXBwcG2zWFPV9LnUFRXV9AtcVRkxYgSLFy9uVt7GdHbbsotQhTOH92ThuizScw5vnWgtfu1zEZF0EVkrIqtFZLmbFi8iH4nIFvdvNzddROT/RGSriKSJyDiv/cxw198iIjO80se7+9/qbiuN5dHRTJkyhZdffhmAF154gZNOOglw+lBWrFgBwIIFC6isrARg586d9OrVi1mzZnH99dezcuXKJuUTFxdHTEwM3377LUBtnr4wdepUnnzySaqqqgCn2W/o0KFkZ2fXBpfKykrWr1/vszyNCaRt2UVc9tRiFm/L9fm+N+9zOvNHJcXSp2sE6bnFPs+jqVqjQ/80VR2jqhPcz3cBn6jqYOAT9zPANGCw+7oBeAKcQAHcAxwHTALu8QoWTwCzvLY75wh5dCiPPPIIzzzzDKmpqTz33HM8/PDDAMyaNYsvvviC0aNHs3jx4tpaw+eff87o0aMZO3Ysr7zyCrfddluT85o9ezazZs1izJgxFBcXExsb65NjuP766+nXrx+pqamMHj2aF198kbCwMF577TXuvPNORo8ezZgxY1i0aJFP8jMm0B79dCtLtudx1exvWb+nwKf7XptZQGRoMCndo0hJiGpWcFFV3lqdSVF5lW8Ko6p+ewHpQEKdtO+APu77PsB37vsngcvrrgdcDjzplf6km9YH2OSVXrteQ3k09ho/frzWtWHDhsPSOqvCwsLa93/5y1/01ltvDWBpHPbvY9qbzPwSHXj3u3rrSyu1/53v6H8+3+rT/f/48W/0oie+UVXVu+an6dj7PmzythuzCrT/ne/oPz7Y1Kw8geVaz3eqv2suCnwoIitE5AY3rZeq1owr3Qv0ct8nAbu9ts1w0xpLz6gnvbE8DiEiN4jIchFZnp0d2DHhbd277757yBDm3//+94EukjHtzttr9lDlUX591lCSu0WSltl4zeXz7/ZzwoOfkltUfsR9V1V7WLengFFJzj1rKd27kFdcQUFpZZPKtjbDKcvrqzLx+ODufn936J+oqpki0hP4SEQ2eS9UVRURvw7EbiwPVX0KeApgwoQJgZ0roY279NJLufTSSwNdDGPaHVVl1e4DlFZUs3h7LgN7RNE3vgupybG1X+gNeX7JLjIPlPL++r385Lj+AHy7PZfw0GCG9oohMiy4dt2t2UWUVXpITXaarPt3d5rDd+YWk5p85Juk17u3WmTkl7J8Zz6TBhw6urOovIqducWMSGxak7hfay6qmun+3Q+8gdNnsk9E+gC4f2vmKMgE+nptnuymNZaeXE86jeTRkmNo6abGj+zfxbQXD7y7kQsfX8TVc5ayZHsukwd2B2BUUhy78ko4UFJx2Da780p4e80evtjsfHW9t3YvANmF5Vz+3yVc8Ng3HPuH9/nr+9//Xk/b7QSqmuBSMwR5R07T+l3W7yng2D5dAViWnnfY8ucW7+RHjy+irLK6SfvzW3ARkSgRial5D5wFrAMWADUjvmYAb7nvFwBXu6PGjgcK3KatD4CzRKSb25F/FvCBu+ygiBzvjhK7us6+6sujWSIiIsjNzbUvsjZG3ee5REREBLooxjRq38Ey5i3eyZnH9iJIoKzSw+RjEoDvg8C6zENvzl61K5/pj33DLS+torJaOXFQAou357Jhz0G+2ZqDR+HuacMYmdSV99btrd0uLfMAMeEhpLg1lv7duxAksHV/0RHL6fEo6/ccZFJKN0KChNKKwwPI3oJSKqo85BUfHgzr489msV7AG+7o4BDgRVV9X0SWAa+KyHXATuASd/2FwLnAVqAEuAZAVfNE5H5gmbvefapaE1Z/DswFIoH33BfAgw3k0SzJyclkZGRg/TFtT82TKI1py/775XaqPB7+cN5wHv88jFeX7+a4Y5zmpppawqa9BzlxsBNwZn+9gz8v3EjvrhHcN30EuUUVXDguiQsfX8T0x75mYI9ounUJZdZJx6DAg+9tIqeonITocNIyChiZFEtQkPM4iojQYFISomrnGmvMjtxiSiqqGZEUS2RoMCX1BJf8EqfvJqeonMjQYLpGhvLXDzYdtl4NvwUXVd0OjK4nPRc4o550BW5qYF9zgMPm/lDV5cBhk1w1lEdzhYaG2pMOjTEt8s3WHOZ8s4OLxifTr3sX/t95w7l4Ql8Sop0blbt1CSUmIoRdec6Njou35fKndzdwxrBe/OPi0cR2+f4R3h/+8mQu/s9iNu0t5AepfQgKEib0d+7IeHvNHiamxLMx6yDXnnjo99XQXjFszDp82qovNmezaGsOd00bhoiw2Q1Ax/buSkRYMKX1NH3lu81381dk8Ozindx02kCe/GJ7g8dvE1caY4wPVVR5UFX+uGA9AxKiamf3iAoPYXz/7+/nFhH6d+/CzlwnuPxxwXpSukfx8GVjDgksAN2jw/nrRakEBwlnDOsJwCi3We3etzcw/bFvqKxWUpMO7bgf2juGnXklh/WTzP1mB09+uZ2PNzp9Opv3FSECg3pGExkaXG+/Sk1w+XJLDgCPfbaNmPCG6ycWXIwxxkfKq6qZ8uAnPPrpVrbsL+LCcclENfIF3D8+il15JWQVlPLdvkJ+cly/BtefkBLPt789gwvGOHdchIcEc5LbnFbTL1zTj1NjaK8YVA/td/F4lBU78wH4y3sb8XiULfsLSe4WSWRYMJGhwfX2ueQXO81iu/O+n1Jm2qjeDR6bzS1mjDE+smVfETlFFTzxxTYAxvZtfAhwv+5d+HDDXr7a7NQGThiU0Oj6NU1qNZ64cjwhQcK9b2/gqy3ZJHeLPGT5kN4xAGzYc5DtOcVk5pcyrHcMB8uqOGlwAl9tyWFpeh5b9xcxpKezbkPNYjWj2qrce2BiI0O54rj+/K2BslpwMcYYH6l5LEdJRTUi3zddNaR/fBcqq5X/rdhNQnQYQ3vFNCu/aLeW86cLRlJWWY07gOqQ/feNj+S+dzYcNq3LXdOGsWLnYuavyGB7djGnDO0BQGRo0GHBpaLKQ7FXbeakwQk8d91xjZbNmsWMMcZHvOcKG9wzmpiI0EbWdmouAMvS85k8MKF2pFdzBQdJvc1pIcFBPDNzIuEhQZw1vBfv3HIi0eEhxEeFMbxPV84e0Zv/rcigotpTW3Opr8+l7r04ibGH1pDqYzUXY4zxkfV7DjI6OZat+4sO6bxvSM1d9AA3nnKMX8o0qGcM39x1OuEhQYgIz147iYOllYgI1580gIVrsyiv8tTWsrqEhbA7/9BHbdQMQw4S8CgkdbPgYowxraKkooqNWQe5aHwyD12USs+YI9/k26drBCcP6cGFY5OaPK1KS0SEfj9NjHfQG5EYy/p7zyaroIy+8V1q163boV8zUqxffBfSc0tIirPgYowxfrf/YBnn/t9XFFdUM3lgAsN6d23SdkFBwrxrJ/m5dI0LCQ6qDSwAkWFBhzSL5RSVs86dYHNQzxjSc0tItOBijDH+t2RHHjlFFTx2xTjOGdnw8Nz2IDL00NFiVz79LZvcmyyH94nh4437avuKGmPBxRhjjtKGPQcJDRamDq/36R7tSk1wUVVEpDawAMw8YQBj+3drUrOYjRYzxpgWWrwtl1P+9hlfbclmcM8YwkLa/1dqRFgwqlBe5QGcRybXiI8K47ShPZu0H6u5GGNMC326aV/t9C0Xje8YE6lGup3/ZZXVRIQGU1xRRWxkKDec3LzRbO0/zBpjTICs8XrY14jEpnXit3U1waWm36WwrIppI3tz02mDmrUfCy7GGNMC1R5lXWYBPWOcKVnqzuvVXtU83bJm2v2isipiIprfyGXNYsYY0wLbs4soqajm3vNH0L97FOP6HfmmyfagtuZSUU1ltYfSymqiwxufaaA+FlyMMaYFaprExvSNY3Az5wRry2pqLmWV1RS785G1pOZizWLGGNMCH6zfS0J0OMf0iA50UXzKu8+lsMwJLtEWXIwxxv/2F5bx6ab9/Hh8EsEtnGyyrYrwaharCS5dLbgYY4z/zV+RSbVHuXh830AXxedqmsVKK6trp+m3PhdjjPGTVbvyiYkIITEuktlfb+eEQd0Z1LNjNYnBofe5FJY5syG3pFnMgosxxhyBqnLj8ysIDQ7i/NGJ5BRV8OTUIYEull/UBJeSiu9rLjYU2Rhj/GBnbgn7DpYD8Pjn2zgvtQ/j+8cHuFT+4d0sVtPnElPPg8iOxIKLMcYcwdIdeQCcNrQH0RGh/P3i1ACXyH+ch4pBWUU1gjNY4UhP1KyPBRdjjDmCpel5xEeFMWfmxMOeU9/RiAiRocEUlFZSrUpwkBAR2vyxXzZazBhjGqGqLN6Wy8SUbh0+sNQ4/pjuLFizh70F5cREhLTouC24GGNMIxZvyyXzQClTh7fvh4A1x82nDyK/pJL5KzOIbkF/C1hwMcaYRj23ZCdxXUI5L7VPoIvSasb168ZpQ3sA309g2VwWXIwxpo5duSVcNftbHv54Cx+s38ulE/vW3rneWdx7/kgA8oorWrS9degbY4yX8qpqbn5pJWkZBXy1JYchvaK59fTBgS5Wq+vXvQvPzJxIeAufrmnBxRhjvLy1ag9pGQX885LR7D1YxvmjE4lqYb9De3fasKY90rg+nfOMGWNMA15bmcExCVH8aGxSpxkd5g/W52KM6fT+t3w3V83+lq37C1m6I48fj0+2wHKUrOZijOn0Zn+9g017C/nRY4sICwniR2OTAl2kds9qLsaYTm1bdhGb9hbSJzaCkspqHrl8LIlxkYEuVrtnNRdjTKf25qpMAF772RSCRegdGxHgEnUMfq+5iEiwiKwSkXfczwNE5FsR2Soir4hImJse7n7e6i5P8drH3W76dyJytlf6OW7aVhG5yyu93jyMMcbbW6szefSzrZw1vBdJcZEWWHyoNZrFbgM2en1+CPiXqg4C8oHr3PTrgHw3/V/ueojIcOAyYARwDvC4G7CCgceAacBw4HJ33cbyMMYYANZlFvCb/6UxKSWehy8bG+jidDh+DS4ikgz8AHja/SzA6cBr7irPAhe476e7n3GXn+GuPx14WVXLVXUHsBWY5L62qup2Va0AXgamHyEPY4wB4HdvrCU+Kownrhxf+wwT4zv+rrn8G7gD8LifuwMHVLXK/ZwB1AzLSAJ2A7jLC9z1a9PrbNNQemN5HEJEbhCR5SKyPDs7u6XHaIxpZ3KLylmTUcBVk/sTH2Wt5v7gt+AiIucB+1V1hb/yOFqq+pSqTlDVCT169Ah0cYwxreRb9+Ffkwd2D3BJOi5/jhY7AThfRM4FIoCuwMNAnIiEuDWLZCDTXT8T6AtkiEgIEAvkeqXX8N6mvvTcRvIwxhgWbcshOjyE1KTYQBelw/JbzUVV71bVZFVNwemQ/1RVfwJ8BlzkrjYDeMt9v8D9jLv8U1VVN/0ydzTZAGAwsBRYBgx2R4aFuXkscLdpKA9jjKl9+FdIsN3q5y+BOLN3AreLyFac/pHZbvpsoLubfjtwF4CqrgdeBTYA7wM3qWq1Wyu5GfgAZzTaq+66jeVhjOnkCkoq2ZZdzISU+EAXpUNrlZsoVfVz4HP3/XackV511ykDLm5g+weAB+pJXwgsrCe93jyMMSYt8wAAo5PjAlySjs3qhMaYTiUtowCAUcnW3+JPFlyMMZ3Kmt0HOCYhitjI0EAXpUOz4GKM6VTWZBwg1WotfmfBxRjTaew7WMa+g+WkWn+L31lwMcZ0Gmt2u535fa3m4m8WXIwxnUZaRgHBQcLwPhZc/M2CizGm01iTcYAhvWJsospWYMHFGNMpqCppGQWMts78VnHEmyhFpBfwZyBRVae5z0yZrKp217sxps2rqvbwyab9bMw6SEFpJZMG2J35raEpd+jPBZ4Bfud+3gy8gk2pYoxpB15cuos/vOXMDDVtZG8uGFPvEziMjzUluCSo6qsicjc4z1oRkWo/l8sYY45K5oFSFqZlMW9JOqnJsdx4ykBOH9aToCAJdNE6haYEl2IR6Q4ogIgcj/MgL2OMabPue3s9H6zfB8DvfzCcs0f0DnCJOpemBJfbcaa9Hygi3wA9+H46e2OMaXO2ZRfx4YZ9XDqhL5MGxDP12F6BLlKnc8TgoqorReQUYCggwHeqWun3khljTAsUllXym/+tITwkiN+cM5SE6PBAF6lTOuJQZBG5CYhW1fWqug6IFpGf+79oxhjTfL97Yx1pGQX865IxFlgCqCn3ucxS1QM1H1Q1H5jlvyIZY0zL7M4r4Z20PVx74gCmjeoT6OJ0ak0JLsEiUju8QkSCgTD/FckYY1pm3uJ0RISZU1ICXZROrykd+u8Dr4jIk+7nn7ppxhjTpnyyaT+nDOlBYlxkoIvS6TUluNyJE1B+5n7+CHjabyUyxpgWKCipZHt2MT8elxzoohiaNlrMAzzhvowxpk1ak+F0DY/pa89qaQsaDC4i8qqqXiIia3FvoPSmqql+LZkxxjTD6t0HEMGeMtlGNFZzuc39e15rFMQYY1rK41EWb8tlUI9oYiJCA10cQyPBRVWz3JFhc1X1tFYskzHGsHhbLl0jQxiReOSayC0vr2Lx9lx+eeaQViiZaYpGhyKrajXgERGrZxpjWo2qctvLq7jHnc24Mat3H+DdtCxuPm0Qt54xqBVKZ5qiKaPFioC1IvIRUFyTqKq3+q1UxphObXdeKfsLy8kvqaC0orrRJ0c+880OYsJDuPHUgXjdkmcCrCnB5XX3ZYwxrWJZeh4AldXKql35TBmUUO96zy3Zydtr9nDNCQOIDm/K15lpLY3+a4jIBTizIK9V1Q9ap0jGmM5u+c48osNDKKmoYsmOvNrg8m5aFve/s4Hfn3csYcFB/L8313HGsJ786izra2lrGhuK/DgwAlgE3C8ik1T1/lYrmTGm01qens/ElG5kF5XzycZ9/PLMwew9WMZdr6dRVlnNzS+uQgRGJnXliSvHExbSlJmsTGtqrOZyMjBaVatFpAvwFWDBxRjjV/nFFWzZX8QFY5PoERPOHa+l8dbqPazfU0BZZTULbz2JZen5LN2Ryy/OHGKBpY1qLLhUuKPFUNUSsZ4yY0wrWLEzH4CJKfFM6N+N55fs5KH3NxESLEwZmMDgXjEM7hXDFcf1C3BJTWMaC/nDRCTNfa31+rxWRNJaq4DGmM5l2c48QoOF1ORYgoKEX581lKyCMnbnldqjituRxmoux7ZaKYwxxrU8PZ9RSbFEhDrDj08anMCYvnGsyTjAmcN7Brh0pqkau91f9NYAACAASURBVEN/Z2sWxBhjyiqrWZtRwDUnpNSmiQh/uyiVtZkF9IyJCFzhTLNYT5gxJiAWbc1h5jNLKamoqk1bm1lARbWH8f27HbLu4F4xXGhT6bcrFlyMMa3i0037+HJzNjtyilmXWcDcRel8/l02j3+2rTbA1Nw8WTe4mPbHb7e0ikgE8CUQ7ubzmqreIyIDgJeB7sAK4CpVrRCRcGAeMB7IBS5V1XR3X3cD1wHVwK01N3SKyDnAw0Aw8LSqPuim15uHv47VGNO4vOIKfv7CSsoqPYQECaHBQShKWHAQj362lcc/38rbt5zI8vR8BvaIont0eKCLbI7SEWsuNaPD6ry+EpF/iUj3RjYtB05X1dHAGOAcETkeeAj4l6oOAvJxggbu33w3/V/ueojIcOAynBs6zwEeF5Fgd8bmx4BpwHDgcnddGsnDmHahsKySB97dwO68kto0VUX1sEcr1S5ry55dlE5ZpYeLxidz/uhEqjweyio9/P2S0dx6+iBEhHfSslixM5+JKfGBLq7xgabUXN7DqTG86H6+DOgC7AXmAj+sbyN1rvYi92Oo+1LgdOAKN/1Z4I84T7mc7r4HeA141L23ZjrwsqqWAztEZCswyV1vq6puBxCRl4HpIrKxkTyMaRf+vHATLy3dxaa9hfzizMEkxXXhZy+sYPPeQk4a3IO7pg0jJSEKcKamv2P+Gp74yXhGJrXOBOavLNuFKpw3OrHBOb3WZhQQGiLMW7yTV5ft5sxje/L3i0cD0Cs2ggWr93DuyN6EjE5kWXo+z3yzg7JKDyc0MI+YaV+aElzOVNVxXp/XishKVR0nIlc2tqFbu1gBDMKpZWwDDqhqTQ9eBpDkvk8CdgOoapWIFOA0ayUBS7x2673N7jrpx7nbNJRH3fLdANwA0K+f3ZBl2oavt+Tw0tJdDOkVzVdbcvhqSw4hQUKVR7lgTCIfbdjHl1uya59dMndROpkHSvnXR5uZPXOi38v3wfq93Dl/LQBPfLGNZ6+ZVBvoary9Zg+3vLQKgJAg4fJJ/bh96vfzf91x9lB+NXUIIcFO48nU4b1YvD2XY/t05dxRffx+DMb/mhJcgt15xZYCiMhEnD4OgKqGN6t9HswYEYkD3gCGHU1hfU1VnwKeApgwYULbblcwnUJReRV3zk/jmIQo3vj5CTz62VaS4iJ5c1UmUwYlcPvUIWQVlPLT51bwwMKNAESGBnPOiN68v34vT36xjWtPHEBosH/G6pRUVPHb19cyMqkrd5w9jNteXsUlTy5m/s+m0De+CwA5ReX84a11jE6O5fJJ/ZgyMIF+3bscsh8RIST4+0k/zh3Vh+e/3cm9548gOMgmA+kImhJcrgfmiEg0IMBB4HoRiQL+0pRMVPWAiHwGTAbiRCTErVkkA5nuaplAXyBDREKAWJyO/Zr0Gt7b1Jee20gexrRp81dkkHmglP/dOJmo8BDuPMf5PXbl8f1r1+kTG8n8n00hI7+U+KgwQoIEjyqF5ZX85b1NhIcEMfOEAX4p3+srM8ktruA/V41nYko8L98wmYv/s4iL/7OYB388ilOH9uQPb62juLyav188msG9Ypq0396xEXz6q1P9UmYTGEf8eaOqy1R1FE6n/GhVTVXVpaparKqvNrSdiPRwayyISCQwFdgIfAZc5K42A3jLfb/A/Yy7/FO332YBcJmIhLujwAYDS4FlwGARGSAiYTh9QQvcbRrKw5g2beHaLIb0ij5ip3ZocBADEqKIjQwlKjyEmIhQXrj+ePrGR7LUHc7ra9UeZe6idEYlxTLBHSo8tHcML846npiIEK57djl3vLaGhWv3ctuZg5scWEzHdMSaiztE+MdAChBSM3+lqt53hE37AM+6/S5BwKuq+o6IbABeFpE/AauA2e76s4Hn3A77PJxggaquF5FXgQ04zXA31UyoKSI3Ax/gNNPNUdWaZ6Le2UAexrRZ2YXlLEvP4+bTB7d4H2P6dmO5D4NLVbWHZxfv5NNN+4gICWbr/iIeu2LcIU98HJkUy5s3ncCPn1jEq8sz+MGoPvz05GN8VgbTPjWlWewtoACnY768qTtW1TRgbD3p2/l+tJd3ehlwcQP7egB4oJ70hcDCpuZhTFv24Ya9eBSmjWz55Ixj+8bx9po97C0oo3fs0U+VMuebHfx54Sb6xEaQVVDGdScO4Aeph3e4R4WHMO+6SSzZnsd5o/oQZP0mnV5Tgkuyqp7j95IY08m9v24vKd27MKx3y5uTxvaLA2D17nzOiT26UVdlldX896sdnDgogeeum8T2nGKOqTMqzFvPmAjOH514VHmajqMpQ0oWicgov5fEmE7sQEkFi7flcs7IPoc0OTXX8MSuhIcE8eWWnKMu0xurMskuLOdnpw5ERBjYI/qoymY6l6YElxOBFSLynT3PxRjfKyyr5N8fb6HKo0fVJAYQHhLMD0cn8uaqTA6WVbZ4P9Ue5ckvtpGaHMuUgY1NxGFM/ZrSLDbN76UwphP79f/W8MH6fZx5bE9Sk4/+DvuZU1J4bUUG/1uewXUntmxI8nvrskjPLeGJn4yz2oppkQZrLiLS1X1b2MDLGHOUtmUX8eGGfdx82iCenjHRJ1/kI5NiGZHYlYVrs1q0fVllNQ+9v4nBPaM5y578aFqosZrLi8B5OKPEFOcGyhoK2FhDY45CZbWHv76/idDgIGZ6PRzLF84Y1pNHP9tKfnEF3aLCmrzdip15/OPDzezOK+XFWcfZ3fKmxRqsuajqee7fAap6jPu35mWBxZijdOdraXywfh+3Tx1Cgo+nmD9tWE88Cl9uya5N83iUPQdKG9xm/8EyrnlmGZv3FXHXtGFMGWgTSJqWa8qU+ye4U70gIleKyD9FxGZ5NOYoHCipYMGaPcycksKNpwz0+f5Tk+OIjwrjs037a9Pue2cDp/79c/YXlh22fklFFbe/uobyKg+v/vR4v5TJdC5NGS32BFAiIqOBX+HMbPycX0tlTAf30YZ9VHmUC8fVO2H3UQsOEk4d0oMvNmdT7VE+2biPuYvSqajyHBJwalw7dxmLtuVw//SRHNMj2i9lMp1LU0aLVamqish04FFVnS0i9vAtY1ogp6icWfOWk55TTFJcJKP8+PyVU4f15PVVmdz79npe+HYXw3rHcLC0kgVr9hAeEsy5o/qw72AZZZXVLNmex13ThnHJxL5H3rExTdCU4FLoPmb4SuBkEQnCefCXMaYZ1mUWcOf8NLbuL6JffBcundjXr8N8Tx6cQJDAvMU7mXxMd/47YwJ//+A75i5K55utuXy8cR/vrs2q7e+5YIx/alGmc2pKcLkU56mO16nqXre/5W/+LZYxHct3ewu54LFviAoP4Ykrx3H6sF5+zzOuSxgTU+LZll3E/10+lujwEK44rh9b9hdSXF7NO2nOUOXswnLG9YvzyVxkxtQ4YnBR1b3AP70+7wLm+bNQxnQ0zy5OJzhI+Pj2U+gR49uRYY155PKxVHq0Ns8hvWJ44frj2byvkJlzlnLntGE8uyidqyentFqZTOfQlCn3C3HuawEIw2kSK1LV1nlYtzHt1LL0PN5clUlcl1DeWJnJ9DGJrRpYAHp2rb82MqRXDN/cdToiwnRrDjN+0JSaS+0UreI0EE8HjvdnoYxp715dvps756cRERJMWVU1XSNCubaFU7H4i03rYvypKX0utdynPL4pIvcAd/mnSMa0b7vzSvjjgvUcP6A7T8+YQJewYPsiN51OU5rFLvT6GARMAA6/C8uYTiY9p5hl6Xl8t7eQk4f0YGRSLJv2HuQPbzkPRP3bxalEhTfr95sxHUZTrvwfer2vAtJxmsaMaddUtck1ispqD499tpX31+3lp6ccQ2xkKNc/uxyPQpDA01/vQARUITYylNkzJpLcrYufj8CYtqspfS7XtEZBjGkt5VXV/O6NdSzamsPcaycxpNeRn/z4l4WbmPPNDhJjI/jlK2sQgaG9Ynj0irEkxXVh7qJ0Kqs9pCbHMiIxttU77o1pa5rSLJYMPAKc4CZ9Bdymqhn+LJgx/lBV7eGmF1bx8cZ9xESEcNlTS3jox6kM6hnNyp35nDAo4bD7PXbmFvPcknQundCXv1w4igVr9vD6qkzu+eFwBrpTpfzsVJuLyxhvTWkWewZn+v2L3c9XumlT/VUoY/zlofc38fHGfdx7/ghOGpzAjc+vYNa85bXLw0OCeOjHqZyX2ocgEQrLqrjt5dUEBwm3nzWEoCDhgrFJXDDWhu8a0xhxBoA1soLIalUdc6S09m7ChAm6fPnyI69o2q2Vu/L58ROLuGJSPx740SjAeTDWxxv3UVBaydBeMfztg+9YvjOfiJAggoOEimoPHg88csVYzrYHZxlzGBFZoaoT6qY3peaSKyJXAi+5ny8Hcn1ZOGP8rdqj/O6NdfTuGsHd5x5bmx4RGsx5qYm1n+fMnMid89OIDg9BRIgIDeJHY5NITY4LRLGNabeaElyuxelz+RfOnfqLAOvkN+3K/BUZbMw6WDvHVkOiwkN49IpxrVgyYzqmpowW2wmc3wplMcYvsgpKeej9TYztF8cPU/sEujjGdAoNBhcReYTv5xQ7jKre6pcSGeMjqsoz36Tz/JKdlFVW87eLUu1OeWNaSWM1F+/e7XuBe/xcFmN8pqi8ijlf7+CfH23m2D5defzK8QzqeeT7WYwxvtFgcFHVZ2vei8gvvD8b0xa9k7aH+97ewKikWD77bj8ehfNS+/DI5WOtxmJMK2vqxEeNj1c2JkAqqz3kF1cQERbMA+9upKLaw9L0PK6enMLYfnGcPaK3BRZjAsBm1TPt1tIdedz+6moy8ktr016+4XiOP6Z7AEtljIHGO/S9HxLWRUQO1izCmX2/q78LZ0xDcorKuf7ZZcRHhfGH84ZTXF5FfHSYBRZj2ojG+lys99O0SarKvW9voLSymqdnTGRQz+hAF8kYU0dQoAtgTFPtzC2mqtrDH95az9tr9nDr6YMtsBjTRlmfi2kXXl22mzvmp9G7awR7D5bx05OP4ebTBwW6WMaYBlhwMW3al5uzuemFlRSWVzE6OZaM/FJuOm0gvz5rqI0CM6YN81twEZG+wDygF87AgKdU9WERiQdeAVJwnmp5iarmi/NN8TBwLlACzFTVle6+ZgC/d3f9p5p7bkRkPDAXiAQW4jxnRhvKw1/HavyjpKKKu19fS0JMOLecMYgrjutPlD2P3ph2wZ99LlXAr1R1OHA8cJOIDAfuAj5R1cHAJ+5ngGnAYPd1A/AEgBso7gGOAyYB94hIN3ebJ4BZXtud46Y3lIdpR/707kYyD5Ty14tSueHkgbUzFRtj2j6/BRdVzaqpeahqIbARSAKmAzV3+z8LXOC+nw7MU8cSIE5E+gBnAx+pap5b+/gIOMdd1lVVl6jzUJp5dfZVXx6mnXhrdSYvfruLn55yDBNT4gNdHGNMM7XKaDERSQHGAt8CvVQ1y120F6fZDJzAs9trsww3rbH0jHrSaSSPuuW6QUSWi8jy7Ozs5h+Y8Yvt2UX89vW1jO/fjV+fNTTQxTHGtIDfg4uIRAPzgV+o6kHvZW6Nw69TyzSWh6o+paoTVHVCjx49/FkM0wz3LFhPSHAQj1w+ltBgGy1vTHvk1/+5IhKKE1heUNXX3eR9bpMW7t/9bnom0Ndr82Q3rbH05HrSG8vDtHErdubx1ZYcfn7qQBLjIgNdHGNMC/ktuLijv2YDG1X1n16LFgAz3PczgLe80q8Wx/FAgdu09QFwloh0czvyzwI+cJcdFJHj3byurrOv+vIwbZiq8vcPNhMfFcZVk/sHujjGmKPgz/tcTgCuAtaKyGo37bfAg8CrInIdsBO4xF22EGcY8lacocjXAKhqnojcDyxz17tPVfPc9z/n+6HI77kvGsnDtGEfrN/L4u253D99BF3C7BYsY9ozcbokzIQJE3T58uVHXtH4hcejnPnPLwgNDuLdW08kxPpajGkXRGSFqk6om27/g02b8PHGfWzPKebm0wdZYDGmA7D/xaZNePrrHSTFRTJtZO9AF8UY4wMWXEzA7cotYemOPK44rp/VWozpIOx/sgm4t1Y7I8inj0kMcEmMMb5iwcUEVGW1h9dXZTJpQDzJ3boEujjGGB+x4GICpqraw98//I4dOcVce8KAQBfHGONDdjOBaXXrMgu4c34a6TnFFFdUc/H4ZM6xjnxjOhQLLqZVbc8uYsacpYQGB3HxhL5MTInn7BH1zitqjGnHLLiYVrMrt4SrZi8F4IVZxzGwR3SAS2SM8RcLLsavMg+U8thnW1m/5yDbs4sQ4MVZx1tgMaaDs+Bi/Gb9ngKunr2UwvIqxvWL47gB3fnDecPp191GhRnT0VlwMX6x50ApV89eSnhIEK/eeJLVVIzpZGwosvG5HTnFzHxmKeVVHuZdZ30rxnRGVnMxPlNZ7eH+dzbw8tLddAkP5smrxjOopwUWYzojCy7GJyqrPfz+jXW8snw3l0/qx61nDKJPrD1J0pjOyoKLaZaconIOlFTW1kh255XwxBfb+HJzNhn5pdx02kB+c/awAJfSGBNoFlxMk2UVlHLRE4vJPFBKYmwEXSNDycgvpdqjTBwQzx9/OIIzju0Z6GIaY9oACy6mSfKKK7jy6W8pKK3kV1OHsCOnmKLyKob1juFXZw2lb7wNLzbGfM+Ci2nU0h15PLsonSXbcykqr2LetZM47pjugS6WMaaNs+BiGvTq8t3c8Voa8VFhnDw4gcsn9bPAYoxpEgsupl6fbtrHnfPTOGlwAk9dNYHIsOBAF8kY047YTZTmMFv2FXLrS6sZkdjVAosxpkUsuJhDFJRUcv285USEBltgMca0mAUXc4h/fbyZ3XklPHnVOBLj7CZIY0zLWHAxtbZnF/H8kp1cOrEv4/vHB7o4xph2zIKLAZzmsBueW0FkWDC/PHNIoItjjGnnLLgYVJXbX13NztxinrpqAj27RgS6SMaYds6GIndy6zILePTTrXyyaT9//OFwJg+0+1iMMUfPgksntv9gGVfPWUpVtYdZJw1gxpSUQBfJGNNBWHDppA6UVPCzF1ZSUlHFO7ecyKCeMYEukjGmA7Hg0gkVlFZy6ZNL2JFTzMOXjbHAYozxOQsunUxVtYcbn1vB9pwinpk5iRMHJwS6SMaYDsiCSyfz+OfbWLw9l79fPNoCizHGb2wocieyclc+D3+yhQvGJHLR+ORAF8cY04FZzaWDUlVeW5HB22lZXDaxL1HhIfz+zbX07hrBfReMDHTxjDEdnN+Ci4jMAc4D9qvqSDctHngFSAHSgUtUNV9EBHgYOBcoAWaq6kp3mxnA793d/klVn3XTxwNzgUhgIXCbqmpDefjrOAPN41GWpeexaW8hu/JKCAsJYlduCV9szqaovIqosGC+3JwNQEJ0GE9dPYGuEaEBLrUxpqPzZ81lLvAoMM8r7S7gE1V9UETucj/fCUwDBruv44AngOPcQHEPMAFQYIWILHCDxRPALOBbnOByDvBeI3l0KEu25/LYZ1vZmHWQnKIKACJCg6j2KJGhwZw/JpEJ/bvxg9Q+rEjPp7SymikDE2yWY2NMq/BbcFHVL0UkpU7ydOBU9/2zwOc4X/zTgXmqqsASEYkTkT7uuh+pah6AiHwEnCMinwNdVXWJmz4PuAAnuDSUR4eQW1TO799cx3vr9pIYG8EpQ3py8pAEpgxMICE6jMpqRQRCg7/vTpsyyDrujTGtq7X7XHqpapb7fi/Qy32fBOz2Wi/DTWssPaOe9MbyOIyI3ADcANCvX7/mHkur25FTzHVzl5F5oJRfTR3CrJOPISL00JpIWIgEqHTGGPO9gHXou/0jGsg8VPUp4CmACRMm+LUsRyPzQCnPLd7Js4vSCQ8N4sVZx9mU+MaYNq21g8s+Eemjqllus9d+Nz0T6Ou1XrKblsn3TVw16Z+76cn1rN9YHu1GeVU1S7bn8fySnWQVlLJlXxFVHuXMY3vyx/NH0CfWHuJljGnbWju4LABmAA+6f9/ySr9ZRF7G6dAvcIPDB8CfRaSbu95ZwN2qmiciB0XkeJwO/auBR46QR5u3Yc9BHv1sC59/l01JRTXxUWGMTIpl+piu3HrGYJK7dQl0EY0xpkn8ORT5JZxaR4KIZOCM+noQeFVErgN2Ape4qy/EGYa8FWco8jUAbhC5H1jmrndfTec+8HO+H4r8nvuikTzatHfS9nDby6uJDg/hwnFJnDa0JycMSjisT8UYY9oDcQZomQkTJujy5csDkveKnXlc8uQSxvWL4+mrJxLbxe5DMca0DyKyQlUn1E23O/QDrKCkkt+8lkbvrhHMmTmRGLvB0RjTAVhwaWUVVR5eWrqLd9L2sOdAGXnFFZRXVfPstZMssBhjOgwLLn5UVe0hOEgQEVSVhWv38tcPNrEzt4SRSV057ph4YsJDuGxSP47t0zXQxTXGGJ+x4OIH1R7lmW928LcPviMhOpzEuAiyCsrIyC9laK8YnrlmIqcO6YEzpZoxxnQ8FlwaUF5Vzd6CMuKjwprVXLV+TwG/fGU1m/cVcerQHnQJCya/uJLRyXHcdsZgLhyXTHCQBRVjTMdmwcVV7VG2ZRexZvcB3knL4putOZRXeQBIioukotrDgIQoUpNi6d+9CyUV1WQVlBEcJKR070JQkLBy5wEWrs0iNjKUJ34yjnNG9rbaiTGmU7KhyK7wPoO1z4x/A5AYG8FZI3ozPLEr+w+WsXlfEeEhQWzNLmLDnoO1QScqLJhqVcoqnc/xUWFMGdidP5w3nJ5dIwJ2LMYY01psKPIR9IwJ59+XjqFvfBfG9o0jqIGmq2qPkltUTkRYMF0jQvF4lH2FZVRUeegX38VqKsYYgwWXWr26RnDB2KQjrhccJIfUSoKCxOb6MsaYOoKOvIoxxhjTPBZcjDHG+JwFF2OMMT5nwcUYY4zPWXAxxhjjcxZcjDHG+JwFF2OMMT5nwcUYY4zP2fQvLhEpALY0c7NYoKCNbpMA5LRCPq21TUu362jnwc5B652DlubVlrfxx7XQX1V7HJaqqvZyAuxTHWyb5W24bM3exs6DnYPWPgft4Jja7LWgqtYs5uXtDrZNS7T147HzYOegpdu0VFs+prZ8LVizWEclIsu1nplKOxs7D3YOwM5BjdY8D1Zz6bieCnQB2gg7D3YOwM5BjVY7D1ZzMcYY43NWczHGGONzFlyMMcb4nAWXdkRE5ojIfhFZ55U2WkQWi8haEXlbRLq66WEi8oybvkZETvXa5lIRSROR9SLyUAAOpcVEpK+IfCYiG9zy3+amx4vIRyKyxf3bzU0XEfk/EdnqHvO4OvvrKiIZIvJoII6nJXx5DkTkIRFZ574uDdQxtUQLzsMw9/9KuYj8up79BYvIKhF5p7WPpaV8eQ5E5Db3OlgvIr846sK1ZPyyvQLzAk4GxgHrvNKWAae4768F7nff3wQ8477vCazA+THRHdgF9HCXPQucEehja8Y56AOMc9/HAJuB4cBfgbvc9LuAh9z35wLvAQIcD3xbZ38PAy8Cjwb62Fr7HAA/AD7CeSJtlHstdQ308fnxPPQEJgIPAL+uZ3+3u9fCO4E+ttY+B8BIYB3Qxb0ePgYGHU3ZrObSjqjql0BeneQhwJfu+4+AH7vvhwOfutvtBw4AE4BjgC2qmu2u97HXNm2eqmap6kr3fSGwEUgCpuMESty/F7jvpwPz1LEEiBORPgAiMh7oBXzYiodw1Hx4DoYDX6pqlaoWA2nAOa14KEeluedBVfer6jKgsu6+RCQZJ9g+3QpF9xkfnoNjcX50lKhqFfAFcOHRlM2CS/u3HudCArgY6Ou+XwOcLyIhIjIAGO8u2woMFZEUEQnBuej60g6JSAowFvgW6KWqWe6ivThBA5z/aLu9NssAkkQkCPgHcFjzSHtyNOcA5xo5R0S6iEgCcBod+1pozL+BOwCPP8rXGo7yHKwDThKR7iLSBae2e1TXggWX9u9a4OcisgKnWlzhps/B+RJZjvMfZxFQrar5wM+AV4CvgHSgupXLfNREJBqYD/xCVQ96L1Onnn+kMfY/Bxaqaoafiuh3R3sOVPVDYCHOtfESsJhOeC2IyHnAflVd4b9S+pcProWNwEM4tfj3gdUc5bUQcjQbm8BT1U3AWQAiMgSnao9btf1lzXoisginPRZVfRt3SgcRuYF29oUiIqE4/5FeUNXX3eR9ItJHVbPcJp/9bnomh/4CS3bTJuP8Uvs5EA2EiUiRqt7VOkdxdHx0DlDVB3Da3xGRF3GvkfaimeehISfg1PLPBSKAriLyvKpe6b+S+46PzgGqOhuY7e7zzzg/TlvMai7tnIj0dP8GAb8H/uN+7iIiUe77qUCVqm6os003nF/w7aadWUQE5z/ARlX9p9eiBcAM9/0M4C2v9KvdEVPHAwVuO/VPVLWfqqbgNI3Na0eBxSfnwB0d1d3dZyqQSjvqf2rBeaiXqt6tqsnutXAZ8Gk7Ciw+OQfuvmq+F/rh9Le8eFSF8/doBnv5dGTIS0AWTmdcBnAdcBvOr83NwIN8P+tCCvAdTgffxzjTYnvvZ4P7uizQx9XMc3AiThU/Dafqvhqnfbg78AnOYxM+BuLd9QV4DNgGrAUm1LPPmbSv0WI+OQc4v9JrroMlwJhAH5ufz0Nv9//NQZwBLhnUGR0HnEr7Gi3ms3OA00y+Aacv7qhHkNr0L8YYY3zOmsWMMcb4nAUXY4wxPmfBxRhjjM9ZcDHGGONzFlyMMcb4nAUXY5rJvV/kaxGZ5pV2sYi874N9/0dEThCRuSJSIiIxXsv+LSLqTtXSkn3PFJFEr8/pLd2XMUdiwcWYZlJn/P6NwD9FJMKdeuPPODNRN5s7x1uN43HuOQFnHrjp7jpBwOm4d9a30Ewg8UgrGeMLFlyMaQFVXYczhc6dwB+A5+H/t3f/oFEEURzHvw+xOBttbMVGiVioKTwQhVgESadooyJiYSmKlZBGsbQT/EcsIiIYlAh2WqgQe/4JLAAAAitJREFUbA48o0HEgAQbRbHToIK5n8XMxs1qiMYNJPj7wMLtzOzecMW+m132PfojopVrghRBYW1EjEREO2/bcntPbr9LenGNiNgAjEsq0vHcBIoaKz3AY+B7MYeIOBk/a7GcKH3fy4gYyHU57kdEIyL2kbJi34iI0Yho5NMcy/Mai4iuhfq97P/j4GI2f2eAA0Af6W33B5K2krILn8vpdz4AvZK6SYHifOn4buC4pPV5v4+UNLAwDqzOaXr2k4INMF0u4AjQJK12jkbElty9DrggaSPpLey9km6TkpgelLRZ0pc89mOe2yWWeIZoW1wcXMzmSakGyhBwHegFTkXEKPCIFGzWAMuBgYgYA26RaqgUWpImSvu7mBlcAIZJ+a6apPQche3AHUmTkj7ncTty34Sk0fz5CSkV0GyG/3Cc2V9xVmSzf9PJW5BWCK/KnRFxGngPbCL9mfta6p4sjVsBrJL0tnL+IdKF/5qkTspTOKdvpc9TQGO2gaWxU/h6YDXyysWsHvdIzy8CoHSLaiXwTlIHOAQsm+X4ncDDaqOkN0A/cLHSNQLsLmW/3sPMlc3vfCLV/DFbcA4uZvU4S7oF9jwiXuR9SEHhcEQ8A7oorVYqqs9bpkm6Iul1pa0NDAItUuXBq5KezjHHQeBy5YG+2YJwVmSzRSAi2kBT0i/13c2WIgcXMzOrnW+LmZlZ7RxczMysdg4uZmZWOwcXMzOrnYOLmZnVzsHFzMxq9wNfLcYHLW6RJwAAAABJRU5ErkJggg==\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "aWTPqSJeqHnC"
      },
      "source": [
        "To limit the number of data points you have, you might want to extract the year from every month value your *Month* column. \n",
        "\n",
        "To this end, you *could* apply a ***lambda function***. Your logic could work as follows:\n",
        "1. look through the `Month` column\n",
        "2. extract the year from each individual value in that column \n",
        "3. store that corresponding year as separate column. \n",
        "\n",
        "Whether you go ahead with this is up to you. Just so long as you answer our initial brief: which boroughs of London have seen the greatest house price increase, on average, over the past two decades? "
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "e0DF92cyqnu8",
        "outputId": "3a10317d-7bbf-475d-e0e1-5b3c9b59643d",
        "colab": {
          "base_uri": "https://localhost:8080/"
        }
      },
      "source": [
        "brent_df[brent_df['Year/Month'].dt.year == 1998]['Housing Price'].mean()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "100692.59041666666"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 88
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "2knuTxAEqoJ4"
      },
      "source": [
        "**3. Modeling**\n",
        "\n",
        "Consider creating a function that will calculate a ratio of house prices, comparing the price of a house in 2018 to the price in 1998.\n",
        "\n",
        "Consider calling this function create_price_ratio.\n",
        "\n",
        "You'd want this function to:\n",
        "1. Take a filter of dfg, specifically where this filter constrains the London_Borough, as an argument. For example, one admissible argument should be: dfg[dfg['London_Borough']=='Camden'].\n",
        "2. Get the Average Price for that Borough, for the years 1998 and 2018.\n",
        "4. Calculate the ratio of the Average Price for 1998 divided by the Average Price for 2018.\n",
        "5. Return that ratio.\n",
        "\n",
        "Once you've written this function, you ultimately want to use it to iterate through all the unique London_Boroughs and work out the ratio capturing the difference of house prices between 1998 and 2018.\n",
        "\n",
        "Bear in mind: you don't have to write a function like this if you don't want to. If you can solve the brief otherwise, then great! \n",
        "\n",
        "***Hint***: This section should test the skills you acquired in:\n",
        "- Python Data Science Toolbox - Part One, all modules"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "cKTyr437UgDa",
        "outputId": "cb9c669f-4561-4ada-b1d7-18d754c003fc",
        "colab": {
          "base_uri": "https://localhost:8080/"
        }
      },
      "source": [
        "def create_price_ratio(df, borough) :\n",
        "  df_borough = df[df['Borough'] == borough]\n",
        "  avg_1998 = df_borough[df_borough['Year/Month'].dt.year == 1998]['Housing Price'].mean()\n",
        "  avg_2018 = df_borough[df_borough['Year/Month'].dt.year == 2018]['Housing Price'].mean()\n",
        "  return avg_2018/avg_1998\n",
        "\n",
        "def find_highest(df, borough) :\n",
        "  df_borough = df[df['Borough'] == borough]\n",
        "  max_2018 = df_borough[df_borough['Year/Month'].dt.year == 2018]['Housing Price'].max()\n",
        "  return max_2018\n",
        "\n",
        "boroughs = properties['Borough'].unique()\n",
        "results = []\n",
        "for borough in boroughs :\n",
        "  results.append((str(borough), create_price_ratio(properties, borough), find_highest(properties, borough)))\n",
        "sorted_results1 = sorted(results, key = lambda x : x[1], reverse=True)\n",
        "sorted_results2 = sorted(results, key = lambda x : x[2], reverse=True)\n",
        "for i in range(5) : \n",
        "  print(sorted_results1[i])\n",
        "for i in range(5) : \n",
        "  print(sorted_results2[i])"
      ],
      "execution_count": 96,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "('Hackney', 6.198285561008662, 553833.342)\n",
            "('Waltham Forest', 5.83475580932281, 447630.02054)\n",
            "('Southwark', 5.516485302379376, 518698.9561)\n",
            "('Lewisham', 5.449221041059685, 417893.16032)\n",
            "('Westminster', 5.353565392605413, 1117407.525)\n",
            "('Kensington & Chelsea', 5.082465066092464, 1463377.921)\n",
            "('Westminster', 5.353565392605413, 1117407.525)\n",
            "('Camden', 4.935353408884261, 875078.3856)\n",
            "('City of London', 5.301620377587609, 811694.19218)\n",
            "('Hammersmith & Fulham', 4.137798101936229, 738746.25027)\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "NzYUI7FxJpgv"
      },
      "source": [
        "### 4. Conclusion\n",
        "What can you conclude? Type out your conclusion below. \n",
        "\n",
        "Look back at your notebook. Think about how you might summarize what you have done, and prepare a quick presentation on it to your mentor at your next meeting. \n",
        "\n",
        "We hope you enjoyed this practical project. It should have consolidated your data hygiene and pandas skills by looking at a real-world problem involving just the kind of dataset you might encounter as a budding data scientist. Congratulations, and looking forward to seeing you at the next step in the course! \n",
        "\n",
        "Conclusion :\n",
        "\n",
        "The data analysis done on the housing prices for London Boroughs from 1998 to 2018 suggests that these 5 Borough's have had the greatest increase in housing prices over this time period :\n",
        "\n",
        "1)Hackney (620% increase)\n",
        "\n",
        "2)Waltham Forest (583% increase)\n",
        "\n",
        "3)Southwark (552% increase)\n",
        "\n",
        "4)Lewisham (545% increase)\n",
        "\n",
        "5)Westminster (536% increase)\n",
        "\n"
      ]
    }
  ]
}