Coursera_Capstone_Project_Week4.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Table of contents\n",
    "1. <a href=\"#item1\">Introduction</a>\n",
    "2. <a href=\"#item2\">Objective</a>  \n",
    "3. <a href=\"#item3\">Data</a>  \n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 1. Introduction"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This is the capstone project of the Applied Data Science Course from Coursera.                                                    In this project we had to think about an own problem that could be solved using data from internet sources as well as from the foursquare database.\n",
    "\n",
    "Since I live in Stuttgart and the rents are pretty high in some areas in Stuttgart, I thought about looking into some characteristics that influence the rent. \n",
    "\n",
    "**Stakeholders**: This could also be interesting for city planners. The politician don't want the rents to soar in some areas, so nearly nobody can afford them. With this project, the city planners can see what makes the rents rise and can maybe take action if necessary."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 2. Objective\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The goal of this project is to figure out what circumstances have an big impact on the rent and what are just incidental.\n",
    "Therefore we will look for online sources with data regarding the population and other relevant factors in the different areas.\n",
    "The foursquare database will be used to get information about local venues. Statistical methods will then be used to find dependencies between the extracted features and the rent.\n",
    "\n",
    "The final objective is a set of features, that mainly influence the rent."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 3. Data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The data section will cover following:\n",
    "\n",
    "**1. First we will get the current rents per square meter for each borough.**\n",
    "\n",
    "**2. Second we will extract the postcodes together with coordiantes for each borough. **\n",
    "\n",
    "**3. Third we will get some data offered by the city of Stuttgart about the differen boroughs**\n",
    "\n",
    "**4. Then we will use the foursquare database to get the venues in the boroughs. We will try to cluster them so they can be used for the analysis later on.**\n",
    "\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**1. Getting the rents**\n",
    "\n",
    "The current rents for each borough are taken from following website: https://www.wohnungsboerse.net/mietspiegel-Stuttgart/972\n",
    "\n",
    "To process it more easily, I put the data into an excel file."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Borough</th>\n",
       "      <th>rent (€/m²)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Bad Cannstatt</td>\n",
       "      <td>16.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Birkach</td>\n",
       "      <td>14.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Botnang</td>\n",
       "      <td>14.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Degerloch</td>\n",
       "      <td>18.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Dürrlewang</td>\n",
       "      <td>20.64</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         Borough  rent (€/m²) \n",
       "0  Bad Cannstatt         16.34\n",
       "1        Birkach         14.87\n",
       "2        Botnang         14.04\n",
       "3      Degerloch         18.89\n",
       "4     Dürrlewang         20.64"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "\n",
    "#read the excel file into a data frame\n",
    "rents = pd.read_excel(\"Stg_rent_by_borough.xlsx\", sheet_name = \"Tabelle1\")\n",
    "# rename the rent column\n",
    "rents.rename(columns = {\"€ / m2\":\"rent (€/m²) \"},inplace = True)\n",
    "rents.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "** 2. Getting the postcodes**\n",
    "\n",
    "Next we need the postcodes for the different boroughs.\n",
    "I'll extract them from the following website using webscraping: https://www.suche-postleitzahl.org/stuttgart-plz-70173-70629.608e"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "from bs4 import BeautifulSoup\n",
    "import requests\n",
    "\n",
    "#get the html code from the respective website\n",
    "page = requests.get('https://www.suche-postleitzahl.org/stuttgart-plz-70173-70629.608e').text\n",
    "#store the html file in the soup variable with the lxml parser\n",
    "soup = BeautifulSoup(page, 'lxml')\n",
    "# extract the section from the soup with the respective table\n",
    "soup_part = soup.find('section', id='ortsteile')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Stadtteil', 'Postleitzahl']"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# initialize an empty list for the headers of the data frame\n",
    "columns_headers = []\n",
    "# search for all entries in the first row of the table (the headings)\n",
    "for tr in soup_part.find_all('tr')[0].find_all('th'):\n",
    "    columns_headers.append(tr.text)\n",
    "columns_headers"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "# initialize two empty lists for the column values\n",
    "values_column1 = []\n",
    "values_column2 = []\n",
    "# loop through the table to get all the entries for the columns\n",
    "for td in soup_part.find_all('td')[::2]:\n",
    "    values_column1.append(td.text.strip())\n",
    "for td in soup_part.find_all('td')[1::2]:\n",
    "    values_column2.append(td.text)    \n",
    "  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "# We have to switch \"Stuttgart-Mitte\" to just \"Mitte\" and so on, so it matches the names in the previous Data Frame\n",
    "for i,val in enumerate(values_column1):\n",
    "    if val.startswith('Stuttgart-'):\n",
    "        val = val[10:]\n",
    "        values_column1[i] = val"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "** 2. Getting the coordinates**\n",
    "\n",
    "Apparently, they also have the coordinates saved on the website, so I'll extract those as well"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "# initialize two empty list for the longitude and latitude\n",
    "values_column3 = []\n",
    "values_column4 = []\n",
    "# loop thorugh the tabel and get the coordiantes\n",
    "for td in soup_part.find_all('td')[::2]:\n",
    "    values_column3.append(td['data-lat'])                            \n",
    "for td in soup_part.find_all('td')[::2]:\n",
    "    values_column4.append(td['data-lon'])\n",
    "\n",
    "#add the column names to the column_headers\n",
    "columns_headers.append('latitude')\n",
    "columns_headers.append('longitude')\n",
    "\n",
    "#converting the extracted strings to float values\n",
    "values_column3 = list(map(float,values_column3))\n",
    "values_column4 = list(map(float,values_column4))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Borough</th>\n",
       "      <th>Postcode</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Asemwald</td>\n",
       "      <td>70599</td>\n",
       "      <td>48.72498</td>\n",
       "      <td>9.19134</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Bad Cannstatt</td>\n",
       "      <td>70191, 70372, 70374, 70376, 70378</td>\n",
       "      <td>48.80322</td>\n",
       "      <td>9.21746</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Bergheim</td>\n",
       "      <td>70499</td>\n",
       "      <td>48.80154954</td>\n",
       "      <td>9.08995271</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Birkach</td>\n",
       "      <td>70599</td>\n",
       "      <td>48.7193</td>\n",
       "      <td>9.208</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Botnang</td>\n",
       "      <td>70195</td>\n",
       "      <td>48.7789874</td>\n",
       "      <td>9.12889838</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         Borough                           Postcode     latitude   longitude\n",
       "0       Asemwald                              70599     48.72498     9.19134\n",
       "1  Bad Cannstatt  70191, 70372, 70374, 70376, 70378     48.80322     9.21746\n",
       "2       Bergheim                              70499  48.80154954  9.08995271\n",
       "3        Birkach                              70599      48.7193       9.208\n",
       "4        Botnang                              70195   48.7789874  9.12889838"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#create a data frame\n",
    "df_values = np.array([values_column1,values_column2,values_column3, values_column4]).transpose()\n",
    "postcodes = pd.DataFrame(data = df_values, columns = columns_headers)\n",
    "#change german to english\n",
    "postcodes.rename(columns = {\"Stadtteil\":\"Borough\",\"Postleitzahl\":\"Postcode\"}, inplace = True)\n",
    "postcodes.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**3. Getting data about the boroughs**\n",
    "\n",
    "Now I will extract some more Data. Following website provides an excel file with loads of statstics: https://statistik.stuttgart.de/statistiken/statistikatlas/atlas/atlas.html?indikator=i0&select=00\n",
    "\n",
    "You also can find it in my repository: https://github.com/dennis31197/Coursera_Capstone/blob/master/Stg_statistics_borough.xlsx"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Borough</th>\n",
       "      <th>residents per km²</th>\n",
       "      <th>sport and leisure area (m²/resident)</th>\n",
       "      <th>Average age</th>\n",
       "      <th>amount of non-german residents (%)</th>\n",
       "      <th>amount of married residents (%)</th>\n",
       "      <th>residents per household</th>\n",
       "      <th>living area per flat</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Mitte</td>\n",
       "      <td>6473</td>\n",
       "      <td>16.6</td>\n",
       "      <td>38.7</td>\n",
       "      <td>32.1</td>\n",
       "      <td>30.6</td>\n",
       "      <td>1.52</td>\n",
       "      <td>72.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Nord</td>\n",
       "      <td>4823</td>\n",
       "      <td>36.3</td>\n",
       "      <td>41.3</td>\n",
       "      <td>26.1</td>\n",
       "      <td>43.4</td>\n",
       "      <td>1.81</td>\n",
       "      <td>82.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Ost</td>\n",
       "      <td>7718</td>\n",
       "      <td>18.7</td>\n",
       "      <td>41.3</td>\n",
       "      <td>28.4</td>\n",
       "      <td>41.0</td>\n",
       "      <td>1.73</td>\n",
       "      <td>73.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Süd</td>\n",
       "      <td>9321</td>\n",
       "      <td>10.4</td>\n",
       "      <td>40.3</td>\n",
       "      <td>24.3</td>\n",
       "      <td>38.9</td>\n",
       "      <td>1.68</td>\n",
       "      <td>75.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>West</td>\n",
       "      <td>12729</td>\n",
       "      <td>4.5</td>\n",
       "      <td>40.4</td>\n",
       "      <td>20.7</td>\n",
       "      <td>36.0</td>\n",
       "      <td>1.63</td>\n",
       "      <td>75.7</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Borough  residents per km²  sport and leisure area (m²/resident)  \\\n",
       "0   Mitte               6473                                  16.6   \n",
       "1    Nord               4823                                  36.3   \n",
       "2     Ost               7718                                  18.7   \n",
       "3     Süd               9321                                  10.4   \n",
       "4    West              12729                                   4.5   \n",
       "\n",
       "   Average age  amount of non-german residents (%)  \\\n",
       "0         38.7                                32.1   \n",
       "1         41.3                                26.1   \n",
       "2         41.3                                28.4   \n",
       "3         40.3                                24.3   \n",
       "4         40.4                                20.7   \n",
       "\n",
       "   amount of married residents (%)  residents per household  \\\n",
       "0                             30.6                     1.52   \n",
       "1                             43.4                     1.81   \n",
       "2                             41.0                     1.73   \n",
       "3                             38.9                     1.68   \n",
       "4                             36.0                     1.63   \n",
       "\n",
       "   living area per flat  \n",
       "0                  72.7  \n",
       "1                  82.6  \n",
       "2                  73.5  \n",
       "3                  75.8  \n",
       "4                  75.7  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "statistics = pd.read_excel(\"Stg_statistics_borough.xlsx\", sheet_name = \"Tabelle1\")\n",
    "statistics.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Borough</th>\n",
       "      <th>rent (€/m²)</th>\n",
       "      <th>Postcode</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>residents per km²</th>\n",
       "      <th>sport and leisure area (m²/resident)</th>\n",
       "      <th>Average age</th>\n",
       "      <th>amount of non-german residents (%)</th>\n",
       "      <th>amount of married residents (%)</th>\n",
       "      <th>residents per household</th>\n",
       "      <th>living area per flat</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Bad Cannstatt</td>\n",
       "      <td>16.34</td>\n",
       "      <td>70191, 70372, 70374, 70376, 70378</td>\n",
       "      <td>48.803220</td>\n",
       "      <td>9.217460</td>\n",
       "      <td>5745</td>\n",
       "      <td>32.3</td>\n",
       "      <td>40.9</td>\n",
       "      <td>31.7</td>\n",
       "      <td>46.9</td>\n",
       "      <td>1.88</td>\n",
       "      <td>74.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Birkach</td>\n",
       "      <td>14.87</td>\n",
       "      <td>70599</td>\n",
       "      <td>48.719300</td>\n",
       "      <td>9.208000</td>\n",
       "      <td>5945</td>\n",
       "      <td>14.0</td>\n",
       "      <td>43.1</td>\n",
       "      <td>19.6</td>\n",
       "      <td>44.7</td>\n",
       "      <td>1.86</td>\n",
       "      <td>78.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Botnang</td>\n",
       "      <td>14.04</td>\n",
       "      <td>70195</td>\n",
       "      <td>48.778987</td>\n",
       "      <td>9.128898</td>\n",
       "      <td>6987</td>\n",
       "      <td>16.3</td>\n",
       "      <td>45.6</td>\n",
       "      <td>17.3</td>\n",
       "      <td>52.6</td>\n",
       "      <td>1.93</td>\n",
       "      <td>86.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Degerloch</td>\n",
       "      <td>18.89</td>\n",
       "      <td>70597</td>\n",
       "      <td>48.746795</td>\n",
       "      <td>9.170746</td>\n",
       "      <td>4526</td>\n",
       "      <td>30.4</td>\n",
       "      <td>44.7</td>\n",
       "      <td>18.4</td>\n",
       "      <td>49.1</td>\n",
       "      <td>1.87</td>\n",
       "      <td>87.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Feuerbach</td>\n",
       "      <td>14.81</td>\n",
       "      <td>70192, 70469, 70499</td>\n",
       "      <td>48.811301</td>\n",
       "      <td>9.159111</td>\n",
       "      <td>5321</td>\n",
       "      <td>13.1</td>\n",
       "      <td>42.3</td>\n",
       "      <td>28.9</td>\n",
       "      <td>49.4</td>\n",
       "      <td>1.90</td>\n",
       "      <td>79.6</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         Borough  rent (€/m²)                            Postcode   latitude  \\\n",
       "0  Bad Cannstatt         16.34  70191, 70372, 70374, 70376, 70378  48.803220   \n",
       "1        Birkach         14.87                              70599  48.719300   \n",
       "2        Botnang         14.04                              70195  48.778987   \n",
       "3      Degerloch         18.89                              70597  48.746795   \n",
       "4      Feuerbach         14.81                70192, 70469, 70499  48.811301   \n",
       "\n",
       "   longitude  residents per km²  sport and leisure area (m²/resident)  \\\n",
       "0   9.217460               5745                                  32.3   \n",
       "1   9.208000               5945                                  14.0   \n",
       "2   9.128898               6987                                  16.3   \n",
       "3   9.170746               4526                                  30.4   \n",
       "4   9.159111               5321                                  13.1   \n",
       "\n",
       "   Average age  amount of non-german residents (%)  \\\n",
       "0         40.9                                31.7   \n",
       "1         43.1                                19.6   \n",
       "2         45.6                                17.3   \n",
       "3         44.7                                18.4   \n",
       "4         42.3                                28.9   \n",
       "\n",
       "   amount of married residents (%)  residents per household  \\\n",
       "0                             46.9                     1.88   \n",
       "1                             44.7                     1.86   \n",
       "2                             52.6                     1.93   \n",
       "3                             49.1                     1.87   \n",
       "4                             49.4                     1.90   \n",
       "\n",
       "   living area per flat  \n",
       "0                  74.4  \n",
       "1                  78.8  \n",
       "2                  86.4  \n",
       "3                  87.4  \n",
       "4                  79.6  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_merge1 = pd.merge(rents,postcodes, how = 'inner', on='Borough')\n",
    "Bouroughs_S = pd.merge(df_merge1, statistics, how = 'inner', on = 'Borough')\n",
    "\n",
    "#change to data type of the coordinates to floats\n",
    "Bouroughs_S['longitude'] = Bouroughs_S['longitude'].astype(dtype='float64')\n",
    "Bouroughs_S['latitude'] = Bouroughs_S['latitude'].astype(dtype='float64')\n",
    "\n",
    "Bouroughs_S.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div style=\"width:100%;\"><div style=\"position:relative;width:100%;height:0;padding-bottom:60%;\"><iframe src=\"data:text/html;charset=utf-8;base64,PCFET0NUWVBFIGh0bWw+CjxoZWFkPiAgICAKICAgIDxtZXRhIGh0dHAtZXF1aXY9ImNvbnRlbnQtdHlwZSIgY29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PVVURi04IiAvPgogICAgPHNjcmlwdD5MX1BSRUZFUl9DQU5WQVM9ZmFsc2U7IExfTk9fVE9VQ0g9ZmFsc2U7IExfRElTQUJMRV8zRD1mYWxzZTs8L3NjcmlwdD4KICAgIDxzY3JpcHQgc3JjPSJodHRwczovL2Nkbi5qc2RlbGl2ci5uZXQvbnBtL2xlYWZsZXRAMS4zLjQvZGlzdC9sZWFmbGV0LmpzIj48L3NjcmlwdD4KICAgIDxzY3JpcHQgc3JjPSJodHRwczovL2FqYXguZ29vZ2xlYXBpcy5jb20vYWpheC9saWJzL2pxdWVyeS8xLjExLjEvanF1ZXJ5Lm1pbi5qcyI+PC9zY3JpcHQ+CiAgICA8c2NyaXB0IHNyYz0iaHR0cHM6Ly9tYXhjZG4uYm9vdHN0cmFwY2RuLmNvbS9ib290c3RyYXAvMy4yLjAvanMvYm9vdHN0cmFwLm1pbi5qcyI+PC9zY3JpcHQ+CiAgICA8c2NyaXB0IHNyYz0iaHR0cHM6Ly9jZG5qcy5jbG91ZGZsYXJlLmNvbS9hamF4L2xpYnMvTGVhZmxldC5hd2Vzb21lLW1hcmtlcnMvMi4wLjIvbGVhZmxldC5hd2Vzb21lLW1hcmtlcnMuanMiPjwvc2NyaXB0PgogICAgPGxpbmsgcmVsPSJzdHlsZXNoZWV0IiBocmVmPSJodHRwczovL2Nkbi5qc2RlbGl2ci5uZXQvbnBtL2xlYWZsZXRAMS4zLjQvZGlzdC9sZWFmbGV0LmNzcyIvPgogICAgPGxpbmsgcmVsPSJzdHlsZXNoZWV0IiBocmVmPSJodHRwczovL21heGNkbi5ib290c3RyYXBjZG4uY29tL2Jvb3RzdHJhcC8zLjIuMC9jc3MvYm9vdHN0cmFwLm1pbi5jc3MiLz4KICAgIDxsaW5rIHJlbD0ic3R5bGVzaGVldCIgaHJlZj0iaHR0cHM6Ly9tYXhjZG4uYm9vdHN0cmFwY2RuLmNvbS9ib290c3RyYXAvMy4yLjAvY3NzL2Jvb3RzdHJhcC10aGVtZS5taW4uY3NzIi8+CiAgICA8bGluayByZWw9InN0eWxlc2hlZXQiIGhyZWY9Imh0dHBzOi8vbWF4Y2RuLmJvb3RzdHJhcGNkbi5jb20vZm9udC1hd2Vzb21lLzQuNi4zL2Nzcy9mb250LWF3ZXNvbWUubWluLmNzcyIvPgogICAgPGxpbmsgcmVsPSJzdHlsZXNoZWV0IiBocmVmPSJodHRwczovL2NkbmpzLmNsb3VkZmxhcmUuY29tL2FqYXgvbGlicy9MZWFmbGV0LmF3ZXNvbWUtbWFya2Vycy8yLjAuMi9sZWFmbGV0LmF3ZXNvbWUtbWFya2Vycy5jc3MiLz4KICAgIDxsaW5rIHJlbD0ic3R5bGVzaGVldCIgaHJlZj0iaHR0cHM6Ly9yYXdjZG4uZ2l0aGFjay5jb20vcHl0aG9uLXZpc3VhbGl6YXRpb24vZm9saXVtL21hc3Rlci9mb2xpdW0vdGVtcGxhdGVzL2xlYWZsZXQuYXdlc29tZS5yb3RhdGUuY3NzIi8+CiAgICA8c3R5bGU+aHRtbCwgYm9keSB7d2lkdGg6IDEwMCU7aGVpZ2h0OiAxMDAlO21hcmdpbjogMDtwYWRkaW5nOiAwO308L3N0eWxlPgogICAgPHN0eWxlPiNtYXAge3Bvc2l0aW9uOmFic29sdXRlO3RvcDowO2JvdHRvbTowO3JpZ2h0OjA7bGVmdDowO308L3N0eWxlPgogICAgCiAgICA8bWV0YSBuYW1lPSJ2aWV3cG9ydCIgY29udGVudD0id2lkdGg9ZGV2aWNlLXdpZHRoLAogICAgICAgIGluaXRpYWwtc2NhbGU9MS4wLCBtYXhpbXVtLXNjYWxlPTEuMCwgdXNlci1zY2FsYWJsZT1ubyIgLz4KICAgIDxzdHlsZT4jbWFwXzdlOGUyN2U1MGU4MzQxNjI5MDZlNTVkZGQzMjNiZDE1IHsKICAgICAgICBwb3NpdGlvbjogcmVsYXRpdmU7CiAgICAgICAgd2lkdGg6IDEwMC4wJTsKICAgICAgICBoZWlnaHQ6IDEwMC4wJTsKICAgICAgICBsZWZ0OiAwLjAlOwogICAgICAgIHRvcDogMC4wJTsKICAgICAgICB9CiAgICA8L3N0eWxlPgo8L2hlYWQ+Cjxib2R5PiAgICAKICAgIAogICAgPGRpdiBjbGFzcz0iZm9saXVtLW1hcCIgaWQ9Im1hcF83ZThlMjdlNTBlODM0MTYyOTA2ZTU1ZGRkMzIzYmQxNSIgPjwvZGl2Pgo8L2JvZHk+CjxzY3JpcHQ+ICAgIAogICAgCiAgICAKICAgICAgICB2YXIgYm91bmRzID0gbnVsbDsKICAgIAoKICAgIHZhciBtYXBfN2U4ZTI3ZTUwZTgzNDE2MjkwNmU1NWRkZDMyM2JkMTUgPSBMLm1hcCgKICAgICAgICAnbWFwXzdlOGUyN2U1MGU4MzQxNjI5MDZlNTVkZGQzMjNiZDE1JywgewogICAgICAgIGNlbnRlcjogWzQ4LjcyNDk4LCA5LjE5MTM0XSwKICAgICAgICB6b29tOiAxMSwKICAgICAgICBtYXhCb3VuZHM6IGJvdW5kcywKICAgICAgICBsYXllcnM6IFtdLAogICAgICAgIHdvcmxkQ29weUp1bXA6IGZhbHNlLAogICAgICAgIGNyczogTC5DUlMuRVBTRzM4NTcsCiAgICAgICAgem9vbUNvbnRyb2w6IHRydWUsCiAgICAgICAgfSk7CgogICAgCiAgICAKICAgIHZhciB0aWxlX2xheWVyXzQzY2UyMzQyNTVmZjQ1MDFhNjUxNTY4YTZiYmVkODlkID0gTC50aWxlTGF5ZXIoCiAgICAgICAgJ2h0dHBzOi8ve3N9LnRpbGUub3BlbnN0cmVldG1hcC5vcmcve3p9L3t4fS97eX0ucG5nJywKICAgICAgICB7CiAgICAgICAgImF0dHJpYnV0aW9uIjogbnVsbCwKICAgICAgICAiZGV0ZWN0UmV0aW5hIjogZmFsc2UsCiAgICAgICAgIm1heE5hdGl2ZVpvb20iOiAxOCwKICAgICAgICAibWF4Wm9vbSI6IDE4LAogICAgICAgICJtaW5ab29tIjogMCwKICAgICAgICAibm9XcmFwIjogZmFsc2UsCiAgICAgICAgIm9wYWNpdHkiOiAxLAogICAgICAgICJzdWJkb21haW5zIjogImFiYyIsCiAgICAgICAgInRtcyI6IGZhbHNlCn0pLmFkZFRvKG1hcF83ZThlMjdlNTBlODM0MTYyOTA2ZTU1ZGRkMzIzYmQxNSk7CiAgICAKICAgICAgICAgICAgdmFyIGNpcmNsZV9tYXJrZXJfYjQ4MzJkMjc4OGNhNGMyZmI3MzhiMDM2MzA4NmE0ODkgPSBMLmNpcmNsZU1hcmtlcigKICAgICAgICAgICAgICAgIFs0OC44MDMyMiwgOS4yMTc0Nl0sCiAgICAgICAgICAgICAgICB7CiAgImJ1YmJsaW5nTW91c2VFdmVudHMiOiB0cnVlLAogICJjb2xvciI6ICJibHVlIiwKICAiZGFzaEFycmF5IjogbnVsbCwKICAiZGFzaE9mZnNldCI6IG51bGwsCiAgImZpbGwiOiB0cnVlLAogICJmaWxsQ29sb3IiOiAiIzMxODZjYyIsCiAgImZpbGxPcGFjaXR5IjogMC43LAogICJmaWxsUnVsZSI6ICJldmVub2RkIiwKICAibGluZUNhcCI6ICJyb3VuZCIsCiAgImxpbmVKb2luIjogInJvdW5kIiwKICAib3BhY2l0eSI6IDEuMCwKICAicmFkaXVzIjogNSwKICAic3Ryb2tlIjogdHJ1ZSwKICAid2VpZ2h0IjogMwp9CiAgICAgICAgICAgICAgICApCiAgICAgICAgICAgICAgICAuYWRkVG8obWFwXzdlOGUyN2U1MGU4MzQxNjI5MDZlNTVkZGQzMjNiZDE1KTsKICAgICAgICAgICAgCiAgICAKICAgICAgICAgICAgdmFyIHBvcHVwXzEwN2M5ZGFhYTlhNTRhZDJiNzYzNzdjZTUxZTE3NjI5ID0gTC5wb3B1cCh7bWF4V2lkdGg6ICczMDAnCiAgICAgICAgICAgIAogICAgICAgICAgICB9KTsKCiAgICAgICAgICAgIAogICAgICAgICAgICAgICAgdmFyIGh0bWxfNTk5MDIwOTEzNmE3NDM3MTlhYjFjZDlkMDg4ZmEyNzQgPSAkKGA8ZGl2IGlkPSJodG1sXzU5OTAyMDkxMzZhNzQzNzE5YWIxY2Q5ZDA4OGZhMjc0IiBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij5CYWQgQ2FubnN0YXR0PC9kaXY+YClbMF07CiAgICAgICAgICAgICAgICBwb3B1cF8xMDdjOWRhYWE5YTU0YWQyYjc2Mzc3Y2U1MWUxNzYyOS5zZXRDb250ZW50KGh0bWxfNTk5MDIwOTEzNmE3NDM3MTlhYjFjZDlkMDg4ZmEyNzQpOwogICAgICAgICAgICAKCiAgICAgICAgICAgIGNpcmNsZV9tYXJrZXJfYjQ4MzJkMjc4OGNhNGMyZmI3MzhiMDM2MzA4NmE0ODkuYmluZFBvcHVwKHBvcHVwXzEwN2M5ZGFhYTlhNTRhZDJiNzYzNzdjZTUxZTE3NjI5KQogICAgICAgICAgICA7CgogICAgICAgICAgICAKICAgICAgICAKICAgIAogICAgICAgICAgICB2YXIgY2lyY2xlX21hcmtlcl81NDE4Y2UxOWM5YWI0ZDMwYTk4NWM3YzVlMzY1MWM0MiA9IEwuY2lyY2xlTWFya2VyKAogICAgICAgICAgICAgICAgWzQ4LjcxOTMsIDkuMjA4XSwKICAgICAgICAgICAgICAgIHsKICAiYnViYmxpbmdNb3VzZUV2ZW50cyI6IHRydWUsCiAgImNvbG9yIjogImJsdWUiLAogICJkYXNoQXJyYXkiOiBudWxsLAogICJkYXNoT2Zmc2V0IjogbnVsbCwKICAiZmlsbCI6IHRydWUsCiAgImZpbGxDb2xvciI6ICIjMzE4NmNjIiwKICAiZmlsbE9wYWNpdHkiOiAwLjcsCiAgImZpbGxSdWxlIjogImV2ZW5vZGQiLAogICJsaW5lQ2FwIjogInJvdW5kIiwKICAibGluZUpvaW4iOiAicm91bmQiLAogICJvcGFjaXR5IjogMS4wLAogICJyYWRpdXMiOiA1LAogICJzdHJva2UiOiB0cnVlLAogICJ3ZWlnaHQiOiAzCn0KICAgICAgICAgICAgICAgICkKICAgICAgICAgICAgICAgIC5hZGRUbyhtYXBfN2U4ZTI3ZTUwZTgzNDE2MjkwNmU1NWRkZDMyM2JkMTUpOwogICAgICAgICAgICAKICAgIAogICAgICAgICAgICB2YXIgcG9wdXBfZTQ4M2JlZjRkZjZkNDJkZTgyMjI0OGVhZGYyMDA1OTAgPSBMLnBvcHVwKHttYXhXaWR0aDogJzMwMCcKICAgICAgICAgICAgCiAgICAgICAgICAgIH0pOwoKICAgICAgICAgICAgCiAgICAgICAgICAgICAgICB2YXIgaHRtbF8wMGRhMTBkYzY3MDU0NWM3YWQwMDU5NDVmY2UxZWJiNCA9ICQoYDxkaXYgaWQ9Imh0bWxfMDBkYTEwZGM2NzA1NDVjN2FkMDA1OTQ1ZmNlMWViYjQiIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPkJpcmthY2g8L2Rpdj5gKVswXTsKICAgICAgICAgICAgICAgIHBvcHVwX2U0ODNiZWY0ZGY2ZDQyZGU4MjIyNDhlYWRmMjAwNTkwLnNldENvbnRlbnQoaHRtbF8wMGRhMTBkYzY3MDU0NWM3YWQwMDU5NDVmY2UxZWJiNCk7CiAgICAgICAgICAgIAoKICAgICAgICAgICAgY2lyY2xlX21hcmtlcl81NDE4Y2UxOWM5YWI0ZDMwYTk4NWM3YzVlMzY1MWM0Mi5iaW5kUG9wdXAocG9wdXBfZTQ4M2JlZjRkZjZkNDJkZTgyMjI0OGVhZGYyMDA1OTApCiAgICAgICAgICAgIDsKCiAgICAgICAgICAgIAogICAgICAgIAogICAgCiAgICAgICAgICAgIHZhciBjaXJjbGVfbWFya2VyXzdkZmRkNjU1ZTdjZDQwOTFhZGIxMmE4Y2I5NzUxNDM2ID0gTC5jaXJjbGVNYXJrZXIoCiAgICAgICAgICAgICAgICBbNDguNzc4OTg3NCwgOS4xMjg4OTgzOF0sCiAgICAgICAgICAgICAgICB7CiAgImJ1YmJsaW5nTW91c2VFdmVudHMiOiB0cnVlLAogICJjb2xvciI6ICJibHVlIiwKICAiZGFzaEFycmF5IjogbnVsbCwKICAiZGFzaE9mZnNldCI6IG51bGwsCiAgImZpbGwiOiB0cnVlLAogICJmaWxsQ29sb3IiOiAiIzMxODZjYyIsCiAgImZpbGxPcGFjaXR5IjogMC43LAogICJmaWxsUnVsZSI6ICJldmVub2RkIiwKICAibGluZUNhcCI6ICJyb3VuZCIsCiAgImxpbmVKb2luIjogInJvdW5kIiwKICAib3BhY2l0eSI6IDEuMCwKICAicmFkaXVzIjogNSwKICAic3Ryb2tlIjogdHJ1ZSwKICAid2VpZ2h0IjogMwp9CiAgICAgICAgICAgICAgICApCiAgICAgICAgICAgICAgICAuYWRkVG8obWFwXzdlOGUyN2U1MGU4MzQxNjI5MDZlNTVkZGQzMjNiZDE1KTsKICAgICAgICAgICAgCiAgICAKICAgICAgICAgICAgdmFyIHBvcHVwX2U5NzUyZDY5OWM3MTRjN2M4NjFkZTllNWM5YzVjMTA1ID0gTC5wb3B1cCh7bWF4V2lkdGg6ICczMDAnCiAgICAgICAgICAgIAogICAgICAgICAgICB9KTsKCiAgICAgICAgICAgIAogICAgICAgICAgICAgICAgdmFyIGh0bWxfZTg0YjQ4ODc0MjE0NDY2MDgyYTgyODNmOWEwNDJlOTEgPSAkKGA8ZGl2IGlkPSJodG1sX2U4NGI0ODg3NDIxNDQ2NjA4MmE4MjgzZjlhMDQyZTkxIiBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij5Cb3RuYW5nPC9kaXY+YClbMF07CiAgICAgICAgICAgICAgICBwb3B1cF9lOTc1MmQ2OTljNzE0YzdjODYxZGU5ZTVjOWM1YzEwNS5zZXRDb250ZW50KGh0bWxfZTg0YjQ4ODc0MjE0NDY2MDgyYTgyODNmOWEwNDJlOTEpOwogICAgICAgICAgICAKCiAgICAgICAgICAgIGNpcmNsZV9tYXJrZXJfN2RmZGQ2NTVlN2NkNDA5MWFkYjEyYThjYjk3NTE0MzYuYmluZFBvcHVwKHBvcHVwX2U5NzUyZDY5OWM3MTRjN2M4NjFkZTllNWM5YzVjMTA1KQogICAgICAgICAgICA7CgogICAgICAgICAgICAKICAgICAgICAKICAgIAogICAgICAgICAgICB2YXIgY2lyY2xlX21hcmtlcl8wNDhlMjQ5ZDI5MjU0NjYxOGQwOGZhMWI1ZWNlYTZjMSA9IEwuY2lyY2xlTWFya2VyKAogICAgICAgICAgICAgICAgWzQ4Ljc0Njc5NDc1LCA5LjE3MDc0NjIxXSwKICAgICAgICAgICAgICAgIHsKICAiYnViYmxpbmdNb3VzZUV2ZW50cyI6IHRydWUsCiAgImNvbG9yIjogImJsdWUiLAogICJkYXNoQXJyYXkiOiBudWxsLAogICJkYXNoT2Zmc2V0IjogbnVsbCwKICAiZmlsbCI6IHRydWUsCiAgImZpbGxDb2xvciI6ICIjMzE4NmNjIiwKICAiZmlsbE9wYWNpdHkiOiAwLjcsCiAgImZpbGxSdWxlIjogImV2ZW5vZGQiLAogICJsaW5lQ2FwIjogInJvdW5kIiwKICAibGluZUpvaW4iOiAicm91bmQiLAogICJvcGFjaXR5IjogMS4wLAogICJyYWRpdXMiOiA1LAogICJzdHJva2UiOiB0cnVlLAogICJ3ZWlnaHQiOiAzCn0KICAgICAgICAgICAgICAgICkKICAgICAgICAgICAgICAgIC5hZGRUbyhtYXBfN2U4ZTI3ZTUwZTgzNDE2MjkwNmU1NWRkZDMyM2JkMTUpOwogICAgICAgICAgICAKICAgIAogICAgICAgICAgICB2YXIgcG9wdXBfMGI0YzE5ZmU3MmY3NDRmMDllNDRlN2Y4MDIwOTgxOGYgPSBMLnBvcHVwKHttYXhXaWR0aDogJzMwMCcKICAgICAgICAgICAgCiAgICAgICAgICAgIH0pOwoKICAgICAgICAgICAgCiAgICAgICAgICAgICAgICB2YXIgaHRtbF81NzY4MjUxMjkxMDQ0Y2QyYWFlYjQyYjkwODU3OWQyMCA9ICQoYDxkaXYgaWQ9Imh0bWxfNTc2ODI1MTI5MTA0NGNkMmFhZWI0MmI5MDg1NzlkMjAiIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPkRlZ2VybG9jaDwvZGl2PmApWzBdOwogICAgICAgICAgICAgICAgcG9wdXBfMGI0YzE5ZmU3MmY3NDRmMDllNDRlN2Y4MDIwOTgxOGYuc2V0Q29udGVudChodG1sXzU3NjgyNTEyOTEwNDRjZDJhYWViNDJiOTA4NTc5ZDIwKTsKICAgICAgICAgICAgCgogICAgICAgICAgICBjaXJjbGVfbWFya2VyXzA0OGUyNDlkMjkyNTQ2NjE4ZDA4ZmExYjVlY2VhNmMxLmJpbmRQb3B1cChwb3B1cF8wYjRjMTlmZTcyZjc0NGYwOWU0NGU3ZjgwMjA5ODE4ZikKICAgICAgICAgICAgOwoKICAgICAgICAgICAgCiAgICAgICAgCiAgICAKICAgICAgICAgICAgdmFyIGNpcmNsZV9tYXJrZXJfNzAxNDYxZjcwZDExNDZmNGFmMTg3YzNkYzc4ZTBkZGMgPSBMLmNpcmNsZU1hcmtlcigKICAgICAgICAgICAgICAgIFs0OC44MTEzMDA3MiwgOS4xNTkxMTA3OF0sCiAgICAgICAgICAgICAgICB7CiAgImJ1YmJsaW5nTW91c2VFdmVudHMiOiB0cnVlLAogICJjb2xvciI6ICJibHVlIiwKICAiZGFzaEFycmF5IjogbnVsbCwKICAiZGFzaE9mZnNldCI6IG51bGwsCiAgImZpbGwiOiB0cnVlLAogICJmaWxsQ29sb3IiOiAiIzMxODZjYyIsCiAgImZpbGxPcGFjaXR5IjogMC43LAogICJmaWxsUnVsZSI6ICJldmVub2RkIiwKICAibGluZUNhcCI6ICJyb3VuZCIsCiAgImxpbmVKb2luIjogInJvdW5kIiwKICAib3BhY2l0eSI6IDEuMCwKICAicmFkaXVzIjogNSwKICAic3Ryb2tlIjogdHJ1ZSwKICAid2VpZ2h0IjogMwp9CiAgICAgICAgICAgICAgICApCiAgICAgICAgICAgICAgICAuYWRkVG8obWFwXzdlOGUyN2U1MGU4MzQxNjI5MDZlNTVkZGQzMjNiZDE1KTsKICAgICAgICAgICAgCiAgICAKICAgICAgICAgICAgdmFyIHBvcHVwXzdjYTI2YmQ3NjgzYTQ5MzI5NmI0Mjg5MDM5Yjg3NTcxID0gTC5wb3B1cCh7bWF4V2lkdGg6ICczMDAnCiAgICAgICAgICAgIAogICAgICAgICAgICB9KTsKCiAgICAgICAgICAgIAogICAgICAgICAgICAgICAgdmFyIGh0bWxfN2JhYjc0MjU3NmIwNDYxZDkwZDAzM2VjNDgyYzliNTYgPSAkKGA8ZGl2IGlkPSJodG1sXzdiYWI3NDI1NzZiMDQ2MWQ5MGQwMzNlYzQ4MmM5YjU2IiBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij5GZXVlcmJhY2g8L2Rpdj5gKVswXTsKICAgICAgICAgICAgICAgIHBvcHVwXzdjYTI2YmQ3NjgzYTQ5MzI5NmI0Mjg5MDM5Yjg3NTcxLnNldENvbnRlbnQoaHRtbF83YmFiNzQyNTc2YjA0NjFkOTBkMDMzZWM0ODJjOWI1Nik7CiAgICAgICAgICAgIAoKICAgICAgICAgICAgY2lyY2xlX21hcmtlcl83MDE0NjFmNzBkMTE0NmY0YWYxODdjM2RjNzhlMGRkYy5iaW5kUG9wdXAocG9wdXBfN2NhMjZiZDc2ODNhNDkzMjk2YjQyODkwMzliODc1NzEpCiAgICAgICAgICAgIDsKCiAgICAgICAgICAgIAogICAgICAgIAogICAgCiAgICAgICAgICAgIHZhciBjaXJjbGVfbWFya2VyX2Q0OTc4ODRhMjJkZDQ3NDZhNTllM2UyZDVhYjc4ZGQxID0gTC5jaXJjbGVNYXJrZXIoCiAgICAgICAgICAgICAgICBbNDguNzU4MDQxODksIDkuMjUzNzQ5ODVdLAogICAgICAgICAgICAgICAgewogICJidWJibGluZ01vdXNlRXZlbnRzIjogdHJ1ZSwKICAiY29sb3IiOiAiYmx1ZSIsCiAgImRhc2hBcnJheSI6IG51bGwsCiAgImRhc2hPZmZzZXQiOiBudWxsLAogICJmaWxsIjogdHJ1ZSwKICAiZmlsbENvbG9yIjogIiMzMTg2Y2MiLAogICJmaWxsT3BhY2l0eSI6IDAuNywKICAiZmlsbFJ1bGUiOiAiZXZlbm9kZCIsCiAgImxpbmVDYXAiOiAicm91bmQiLAogICJsaW5lSm9pbiI6ICJyb3VuZCIsCiAgIm9wYWNpdHkiOiAxLjAsCiAgInJhZGl1cyI6IDUsCiAgInN0cm9rZSI6IHRydWUsCiAgIndlaWdodCI6IDMKfQogICAgICAgICAgICAgICAgKQogICAgICAgICAgICAgICAgLmFkZFRvKG1hcF83ZThlMjdlNTBlODM0MTYyOTA2ZTU1ZGRkMzIzYmQxNSk7CiAgICAgICAgICAgIAogICAgCiAgICAgICAgICAgIHZhciBwb3B1cF81ZDk1NzZmNGJhM2Y0NTVmYjA2OTkyNGQ2ZTE2YzgyNyA9IEwucG9wdXAoe21heFdpZHRoOiAnMzAwJwogICAgICAgICAgICAKICAgICAgICAgICAgfSk7CgogICAgICAgICAgICAKICAgICAgICAgICAgICAgIHZhciBodG1sX2E5ODVmNmE3Mzk4ZTQyNzFhZTY5MzlhYTg1NjMxMmFhID0gJChgPGRpdiBpZD0iaHRtbF9hOTg1ZjZhNzM5OGU0MjcxYWU2OTM5YWE4NTYzMTJhYSIgc3R5bGU9IndpZHRoOiAxMDAuMCU7IGhlaWdodDogMTAwLjAlOyI+SGVkZWxmaW5nZW48L2Rpdj5gKVswXTsKICAgICAgICAgICAgICAgIHBvcHVwXzVkOTU3NmY0YmEzZjQ1NWZiMDY5OTI0ZDZlMTZjODI3LnNldENvbnRlbnQoaHRtbF9hOTg1ZjZhNzM5OGU0MjcxYWU2OTM5YWE4NTYzMTJhYSk7CiAgICAgICAgICAgIAoKICAgICAgICAgICAgY2lyY2xlX21hcmtlcl9kNDk3ODg0YTIyZGQ0NzQ2YTU5ZTNlMmQ1YWI3OGRkMS5iaW5kUG9wdXAocG9wdXBfNWQ5NTc2ZjRiYTNmNDU1ZmIwNjk5MjRkNmUxNmM4MjcpCiAgICAgICAgICAgIDsKCiAgICAgICAgICAgIAogICAgICAgIAogICAgCiAgICAgICAgICAgIHZhciBjaXJjbGVfbWFya2VyXzgyNjljZDc1Y2M1MzRiMWI5YTJjNDRmNDJiZWVjNjYxID0gTC5jaXJjbGVNYXJrZXIoCiAgICAgICAgICAgICAgICBbNDguNzc3NzAwNjUsIDkuMTc5MjE2NjJdLAogICAgICAgICAgICAgICAgewogICJidWJibGluZ01vdXNlRXZlbnRzIjogdHJ1ZSwKICAiY29sb3IiOiAiYmx1ZSIsCiAgImRhc2hBcnJheSI6IG51bGwsCiAgImRhc2hPZmZzZXQiOiBudWxsLAogICJmaWxsIjogdHJ1ZSwKICAiZmlsbENvbG9yIjogIiMzMTg2Y2MiLAogICJmaWxsT3BhY2l0eSI6IDAuNywKICAiZmlsbFJ1bGUiOiAiZXZlbm9kZCIsCiAgImxpbmVDYXAiOiAicm91bmQiLAogICJsaW5lSm9pbiI6ICJyb3VuZCIsCiAgIm9wYWNpdHkiOiAxLjAsCiAgInJhZGl1cyI6IDUsCiAgInN0cm9rZSI6IHRydWUsCiAgIndlaWdodCI6IDMKfQogICAgICAgICAgICAgICAgKQogICAgICAgICAgICAgICAgLmFkZFRvKG1hcF83ZThlMjdlNTBlODM0MTYyOTA2ZTU1ZGRkMzIzYmQxNSk7CiAgICAgICAgICAgIAogICAgCiAgICAgICAgICAgIHZhciBwb3B1cF8yMWVlNjE3OWVkYmM0ZDI5YjQ4ZTQ2YWY5MWY4NGQ0OCA9IEwucG9wdXAoe21heFdpZHRoOiAnMzAwJwogICAgICAgICAgICAKICAgICAgICAgICAgfSk7CgogICAgICAgICAgICAKICAgICAgICAgICAgICAgIHZhciBodG1sX2MxNWFlMGJhNmVmMjRjNjE5OTg5NmM5YzM3MmI3MWJkID0gJChgPGRpdiBpZD0iaHRtbF9jMTVhZTBiYTZlZjI0YzYxOTk4OTZjOWMzNzJiNzFiZCIgc3R5bGU9IndpZHRoOiAxMDAuMCU7IGhlaWdodDogMTAwLjAlOyI+TWl0dGU8L2Rpdj5gKVswXTsKICAgICAgICAgICAgICAgIHBvcHVwXzIxZWU2MTc5ZWRiYzRkMjliNDhlNDZhZjkxZjg0ZDQ4LnNldENvbnRlbnQoaHRtbF9jMTVhZTBiYTZlZjI0YzYxOTk4OTZjOWMzNzJiNzFiZCk7CiAgICAgICAgICAgIAoKICAgICAgICAgICAgY2lyY2xlX21hcmtlcl84MjY5Y2Q3NWNjNTM0YjFiOWEyYzQ0ZjQyYmVlYzY2MS5iaW5kUG9wdXAocG9wdXBfMjFlZTYxNzllZGJjNGQyOWI0OGU0NmFmOTFmODRkNDgpCiAgICAgICAgICAgIDsKCiAgICAgICAgICAgIAogICAgICAgIAogICAgCiAgICAgICAgICAgIHZhciBjaXJjbGVfbWFya2VyXzRkOGYyNGY5ZTRmODRhMGViM2JjNmFkZDM2N2U5ZGEwID0gTC5jaXJjbGVNYXJrZXIoCiAgICAgICAgICAgICAgICBbNDguNzI1NjMwNTcsIDkuMTQ2NTE1MTNdLAogICAgICAgICAgICAgICAgewogICJidWJibGluZ01vdXNlRXZlbnRzIjogdHJ1ZSwKICAiY29sb3IiOiAiYmx1ZSIsCiAgImRhc2hBcnJheSI6IG51bGwsCiAgImRhc2hPZmZzZXQiOiBudWxsLAogICJmaWxsIjogdHJ1ZSwKICAiZmlsbENvbG9yIjogIiMzMTg2Y2MiLAogICJmaWxsT3BhY2l0eSI6IDAuNywKICAiZmlsbFJ1bGUiOiAiZXZlbm9kZCIsCiAgImxpbmVDYXAiOiAicm91bmQiLAogICJsaW5lSm9pbiI6ICJyb3VuZCIsCiAgIm9wYWNpdHkiOiAxLjAsCiAgInJhZGl1cyI6IDUsCiAgInN0cm9rZSI6IHRydWUsCiAgIndlaWdodCI6IDMKfQogICAgICAgICAgICAgICAgKQogICAgICAgICAgICAgICAgLmFkZFRvKG1hcF83ZThlMjdlNTBlODM0MTYyOTA2ZTU1ZGRkMzIzYmQxNSk7CiAgICAgICAgICAgIAogICAgCiAgICAgICAgICAgIHZhciBwb3B1cF9lNzg1ZDViZTViMzc0YjcyYTZlODFiNWZlMDI4YmEwMyA9IEwucG9wdXAoe21heFdpZHRoOiAnMzAwJwogICAgICAgICAgICAKICAgICAgICAgICAgfSk7CgogICAgICAgICAgICAKICAgICAgICAgICAgICAgIHZhciBodG1sXzMxOGFkMmIyYTE4NjQzMzg4YWRkNmIzYTlkYmU2NmFiID0gJChgPGRpdiBpZD0iaHRtbF8zMThhZDJiMmExODY0MzM4OGFkZDZiM2E5ZGJlNjZhYiIgc3R5bGU9IndpZHRoOiAxMDAuMCU7IGhlaWdodDogMTAwLjAlOyI+TcO2aHJpbmdlbjwvZGl2PmApWzBdOwogICAgICAgICAgICAgICAgcG9wdXBfZTc4NWQ1YmU1YjM3NGI3MmE2ZTgxYjVmZTAyOGJhMDMuc2V0Q29udGVudChodG1sXzMxOGFkMmIyYTE4NjQzMzg4YWRkNmIzYTlkYmU2NmFiKTsKICAgICAgICAgICAgCgogICAgICAgICAgICBjaXJjbGVfbWFya2VyXzRkOGYyNGY5ZTRmODRhMGViM2JjNmFkZDM2N2U5ZGEwLmJpbmRQb3B1cChwb3B1cF9lNzg1ZDViZTViMzc0YjcyYTZlODFiNWZlMDI4YmEwMykKICAgICAgICAgICAgOwoKICAgICAgICAgICAgCiAgICAgICAgCiAgICAKICAgICAgICAgICAgdmFyIGNpcmNsZV9tYXJrZXJfN2ZiNTE0NjJhYTQ3NGY2M2IxY2NkNTFkZjM0Yzg1MWYgPSBMLmNpcmNsZU1hcmtlcigKICAgICAgICAgICAgICAgIFs0OC44NDIzNzE2OCwgOS4yMjk5NjQwMl0sCiAgICAgICAgICAgICAgICB7CiAgImJ1YmJsaW5nTW91c2VFdmVudHMiOiB0cnVlLAogICJjb2xvciI6ICJibHVlIiwKICAiZGFzaEFycmF5IjogbnVsbCwKICAiZGFzaE9mZnNldCI6IG51bGwsCiAgImZpbGwiOiB0cnVlLAogICJmaWxsQ29sb3IiOiAiIzMxODZjYyIsCiAgImZpbGxPcGFjaXR5IjogMC43LAogICJmaWxsUnVsZSI6ICJldmVub2RkIiwKICAibGluZUNhcCI6ICJyb3VuZCIsCiAgImxpbmVKb2luIjogInJvdW5kIiwKICAib3BhY2l0eSI6IDEuMCwKICAicmFkaXVzIjogNSwKICAic3Ryb2tlIjogdHJ1ZSwKICAid2VpZ2h0IjogMwp9CiAgICAgICAgICAgICAgICApCiAgICAgICAgICAgICAgICAuYWRkVG8obWFwXzdlOGUyN2U1MGU4MzQxNjI5MDZlNTVkZGQzMjNiZDE1KTsKICAgICAgICAgICAgCiAgICAKICAgICAgICAgICAgdmFyIHBvcHVwX2M0N2QxZGE0ZjRkMjQ4ZTFiYmM3MjNmOWIzYTc4NWI0ID0gTC5wb3B1cCh7bWF4V2lkdGg6ICczMDAnCiAgICAgICAgICAgIAogICAgICAgICAgICB9KTsKCiAgICAgICAgICAgIAogICAgICAgICAgICAgICAgdmFyIGh0bWxfMjE1ZGJkM2NlMDU3NGU0MGE0N2I4MGM3YzZlMTUzMzQgPSAkKGA8ZGl2IGlkPSJodG1sXzIxNWRiZDNjZTA1NzRlNDBhNDdiODBjN2M2ZTE1MzM0IiBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij5Nw7xobGhhdXNlbjwvZGl2PmApWzBdOwogICAgICAgICAgICAgICAgcG9wdXBfYzQ3ZDFkYTRmNGQyNDhlMWJiYzcyM2Y5YjNhNzg1YjQuc2V0Q29udGVudChodG1sXzIxNWRiZDNjZTA1NzRlNDBhNDdiODBjN2M2ZTE1MzM0KTsKICAgICAgICAgICAgCgogICAgICAgICAgICBjaXJjbGVfbWFya2VyXzdmYjUxNDYyYWE0NzRmNjNiMWNjZDUxZGYzNGM4NTFmLmJpbmRQb3B1cChwb3B1cF9jNDdkMWRhNGY0ZDI0OGUxYmJjNzIzZjliM2E3ODViNCkKICAgICAgICAgICAgOwoKICAgICAgICAgICAgCiAgICAgICAgCiAgICAKICAgICAgICAgICAgdmFyIGNpcmNsZV9tYXJrZXJfNjZlZmU3M2M3MmYyNGFmMjkxZDJjYjE3YmY0N2MyNTYgPSBMLmNpcmNsZU1hcmtlcigKICAgICAgICAgICAgICAgIFs0OC44MjMwMDMxNSwgOS4yMTc4MjQzNF0sCiAgICAgICAgICAgICAgICB7CiAgImJ1YmJsaW5nTW91c2VFdmVudHMiOiB0cnVlLAogICJjb2xvciI6ICJibHVlIiwKICAiZGFzaEFycmF5IjogbnVsbCwKICAiZGFzaE9mZnNldCI6IG51bGwsCiAgImZpbGwiOiB0cnVlLAogICJmaWxsQ29sb3IiOiAiIzMxODZjYyIsCiAgImZpbGxPcGFjaXR5IjogMC43LAogICJmaWxsUnVsZSI6ICJldmVub2RkIiwKICAibGluZUNhcCI6ICJyb3VuZCIsCiAgImxpbmVKb2luIjogInJvdW5kIiwKICAib3BhY2l0eSI6IDEuMCwKICAicmFkaXVzIjogNSwKICAic3Ryb2tlIjogdHJ1ZSwKICAid2VpZ2h0IjogMwp9CiAgICAgICAgICAgICAgICApCiAgICAgICAgICAgICAgICAuYWRkVG8obWFwXzdlOGUyN2U1MGU4MzQxNjI5MDZlNTVkZGQzMjNiZDE1KTsKICAgICAgICAgICAgCiAgICAKICAgICAgICAgICAgdmFyIHBvcHVwXzNiM2Y2OTBkMzFjYTQ5Zjc5YjIwZjRjYzlhNzFkNGMzID0gTC5wb3B1cCh7bWF4V2lkdGg6ICczMDAnCiAgICAgICAgICAgIAogICAgICAgICAgICB9KTsKCiAgICAgICAgICAgIAogICAgICAgICAgICAgICAgdmFyIGh0bWxfNTE0N2I2YmNkOTBmNDM2MDhjMjE3OGFiNjhkMWRmMjQgPSAkKGA8ZGl2IGlkPSJodG1sXzUxNDdiNmJjZDkwZjQzNjA4YzIxNzhhYjY4ZDFkZjI0IiBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij5Nw7xuc3RlcjwvZGl2PmApWzBdOwogICAgICAgICAgICAgICAgcG9wdXBfM2IzZjY5MGQzMWNhNDlmNzliMjBmNGNjOWE3MWQ0YzMuc2V0Q29udGVudChodG1sXzUxNDdiNmJjZDkwZjQzNjA4YzIxNzhhYjY4ZDFkZjI0KTsKICAgICAgICAgICAgCgogICAgICAgICAgICBjaXJjbGVfbWFya2VyXzY2ZWZlNzNjNzJmMjRhZjI5MWQyY2IxN2JmNDdjMjU2LmJpbmRQb3B1cChwb3B1cF8zYjNmNjkwZDMxY2E0OWY3OWIyMGY0Y2M5YTcxZDRjMykKICAgICAgICAgICAgOwoKICAgICAgICAgICAgCiAgICAgICAgCiAgICAKICAgICAgICAgICAgdmFyIGNpcmNsZV9tYXJrZXJfYTJjZmNhOWI5MTA0NGJiYTk2ZDgzZjU0YTI2ZjZhOTQgPSBMLmNpcmNsZU1hcmtlcigKICAgICAgICAgICAgICAgIFs0OC43OTk0NzE4OCwgOS4xNzU0NjE1M10sCiAgICAgICAgICAgICAgICB7CiAgImJ1YmJsaW5nTW91c2VFdmVudHMiOiB0cnVlLAogICJjb2xvciI6ICJibHVlIiwKICAiZGFzaEFycmF5IjogbnVsbCwKICAiZGFzaE9mZnNldCI6IG51bGwsCiAgImZpbGwiOiB0cnVlLAogICJmaWxsQ29sb3IiOiAiIzMxODZjYyIsCiAgImZpbGxPcGFjaXR5IjogMC43LAogICJmaWxsUnVsZSI6ICJldmVub2RkIiwKICAibGluZUNhcCI6ICJyb3VuZCIsCiAgImxpbmVKb2luIjogInJvdW5kIiwKICAib3BhY2l0eSI6IDEuMCwKICAicmFkaXVzIjogNSwKICAic3Ryb2tlIjogdHJ1ZSwKICAid2VpZ2h0IjogMwp9CiAgICAgICAgICAgICAgICApCiAgICAgICAgICAgICAgICAuYWRkVG8obWFwXzdlOGUyN2U1MGU4MzQxNjI5MDZlNTVkZGQzMjNiZDE1KTsKICAgICAgICAgICAgCiAgICAKICAgICAgICAgICAgdmFyIHBvcHVwXzVjOThkZGNjNzM5ZjQyNTQ4N2MyMWMwYjdiZDNkYTg0ID0gTC5wb3B1cCh7bWF4V2lkdGg6ICczMDAnCiAgICAgICAgICAgIAogICAgICAgICAgICB9KTsKCiAgICAgICAgICAgIAogICAgICAgICAgICAgICAgdmFyIGh0bWxfMjRiNDUzZWE2NDlhNGYxYzgwNTU3MTNhM2M1OTRiNGEgPSAkKGA8ZGl2IGlkPSJodG1sXzI0YjQ1M2VhNjQ5YTRmMWM4MDU1NzEzYTNjNTk0YjRhIiBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij5Ob3JkPC9kaXY+YClbMF07CiAgICAgICAgICAgICAgICBwb3B1cF81Yzk4ZGRjYzczOWY0MjU0ODdjMjFjMGI3YmQzZGE4NC5zZXRDb250ZW50KGh0bWxfMjRiNDUzZWE2NDlhNGYxYzgwNTU3MTNhM2M1OTRiNGEpOwogICAgICAgICAgICAKCiAgICAgICAgICAgIGNpcmNsZV9tYXJrZXJfYTJjZmNhOWI5MTA0NGJiYTk2ZDgzZjU0YTI2ZjZhOTQuYmluZFBvcHVwKHBvcHVwXzVjOThkZGNjNzM5ZjQyNTQ4N2MyMWMwYjdiZDNkYTg0KQogICAgICAgICAgICA7CgogICAgICAgICAgICAKICAgICAgICAKICAgIAogICAgICAgICAgICB2YXIgY2lyY2xlX21hcmtlcl9hNTE5ZTk4ZmJmNTE0NjQ0ODkzMTE5YTY3MjcyN2ZmOSA9IEwuY2lyY2xlTWFya2VyKAogICAgICAgICAgICAgICAgWzQ4Ljc2NDIwOTA3LCA5LjI2NjkzNTU5XSwKICAgICAgICAgICAgICAgIHsKICAiYnViYmxpbmdNb3VzZUV2ZW50cyI6IHRydWUsCiAgImNvbG9yIjogImJsdWUiLAogICJkYXNoQXJyYXkiOiBudWxsLAogICJkYXNoT2Zmc2V0IjogbnVsbCwKICAiZmlsbCI6IHRydWUsCiAgImZpbGxDb2xvciI6ICIjMzE4NmNjIiwKICAiZmlsbE9wYWNpdHkiOiAwLjcsCiAgImZpbGxSdWxlIjogImV2ZW5vZGQiLAogICJsaW5lQ2FwIjogInJvdW5kIiwKICAibGluZUpvaW4iOiAicm91bmQiLAogICJvcGFjaXR5IjogMS4wLAogICJyYWRpdXMiOiA1LAogICJzdHJva2UiOiB0cnVlLAogICJ3ZWlnaHQiOiAzCn0KICAgICAgICAgICAgICAgICkKICAgICAgICAgICAgICAgIC5hZGRUbyhtYXBfN2U4ZTI3ZTUwZTgzNDE2MjkwNmU1NWRkZDMyM2JkMTUpOwogICAgICAgICAgICAKICAgIAogICAgICAgICAgICB2YXIgcG9wdXBfOTkwNTNjOGE3MzA4NDZjMmE4MDk4NTQyYzA1MjU3YjggPSBMLnBvcHVwKHttYXhXaWR0aDogJzMwMCcKICAgICAgICAgICAgCiAgICAgICAgICAgIH0pOwoKICAgICAgICAgICAgCiAgICAgICAgICAgICAgICB2YXIgaHRtbF9hNDdkM2Q3ODJhYmY0ZTdkYThjMmIwYjE0ZDAwMTA5NyA9ICQoYDxkaXYgaWQ9Imh0bWxfYTQ3ZDNkNzgyYWJmNGU3ZGE4YzJiMGIxNGQwMDEwOTciIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPk9iZXJ0w7xya2hlaW08L2Rpdj5gKVswXTsKICAgICAgICAgICAgICAgIHBvcHVwXzk5MDUzYzhhNzMwODQ2YzJhODA5ODU0MmMwNTI1N2I4LnNldENvbnRlbnQoaHRtbF9hNDdkM2Q3ODJhYmY0ZTdkYThjMmIwYjE0ZDAwMTA5Nyk7CiAgICAgICAgICAgIAoKICAgICAgICAgICAgY2lyY2xlX21hcmtlcl9hNTE5ZTk4ZmJmNTE0NjQ0ODkzMTE5YTY3MjcyN2ZmOS5iaW5kUG9wdXAocG9wdXBfOTkwNTNjOGE3MzA4NDZjMmE4MDk4NTQyYzA1MjU3YjgpCiAgICAgICAgICAgIDsKCiAgICAgICAgICAgIAogICAgICAgIAogICAgCiAgICAgICAgICAgIHZhciBjaXJjbGVfbWFya2VyX2JkODM2OGE5NzJkNjRhMWNhNjRhNDg1MDQ4NjBlY2Y2ID0gTC5jaXJjbGVNYXJrZXIoCiAgICAgICAgICAgICAgICBbNDguNzgxMDg3MTIsIDkuMjA3OTA1NTNdLAogICAgICAgICAgICAgICAgewogICJidWJibGluZ01vdXNlRXZlbnRzIjogdHJ1ZSwKICAiY29sb3IiOiAiYmx1ZSIsCiAgImRhc2hBcnJheSI6IG51bGwsCiAgImRhc2hPZmZzZXQiOiBudWxsLAogICJmaWxsIjogdHJ1ZSwKICAiZmlsbENvbG9yIjogIiMzMTg2Y2MiLAogICJmaWxsT3BhY2l0eSI6IDAuNywKICAiZmlsbFJ1bGUiOiAiZXZlbm9kZCIsCiAgImxpbmVDYXAiOiAicm91bmQiLAogICJsaW5lSm9pbiI6ICJyb3VuZCIsCiAgIm9wYWNpdHkiOiAxLjAsCiAgInJhZGl1cyI6IDUsCiAgInN0cm9rZSI6IHRydWUsCiAgIndlaWdodCI6IDMKfQogICAgICAgICAgICAgICAgKQogICAgICAgICAgICAgICAgLmFkZFRvKG1hcF83ZThlMjdlNTBlODM0MTYyOTA2ZTU1ZGRkMzIzYmQxNSk7CiAgICAgICAgICAgIAogICAgCiAgICAgICAgICAgIHZhciBwb3B1cF8yNTc0OTA5ODg3MjE0YjEyYjk0YTJhZjIwYTExZTRlNCA9IEwucG9wdXAoe21heFdpZHRoOiAnMzAwJwogICAgICAgICAgICAKICAgICAgICAgICAgfSk7CgogICAgICAgICAgICAKICAgICAgICAgICAgICAgIHZhciBodG1sXzNhZWQ2MDkwODc3ZjRhODk4ODYyNTI4NjM0ZDlkNDE2ID0gJChgPGRpdiBpZD0iaHRtbF8zYWVkNjA5MDg3N2Y0YTg5ODg2MjUyODYzNGQ5ZDQxNiIgc3R5bGU9IndpZHRoOiAxMDAuMCU7IGhlaWdodDogMTAwLjAlOyI+T3N0PC9kaXY+YClbMF07CiAgICAgICAgICAgICAgICBwb3B1cF8yNTc0OTA5ODg3MjE0YjEyYjk0YTJhZjIwYTExZTRlNC5zZXRDb250ZW50KGh0bWxfM2FlZDYwOTA4NzdmNGE4OTg4NjI1Mjg2MzRkOWQ0MTYpOwogICAgICAgICAgICAKCiAgICAgICAgICAgIGNpcmNsZV9tYXJrZXJfYmQ4MzY4YTk3MmQ2NGExY2E2NGE0ODUwNDg2MGVjZjYuYmluZFBvcHVwKHBvcHVwXzI1NzQ5MDk4ODcyMTRiMTJiOTRhMmFmMjBhMTFlNGU0KQogICAgICAgICAgICA7CgogICAgICAgICAgICAKICAgICAgICAKICAgIAogICAgICAgICAgICB2YXIgY2lyY2xlX21hcmtlcl83MDU3Y2EzOWMyZTU0NTMxODc1ZDc2MWQxMzBkMTgwMSA9IEwuY2lyY2xlTWFya2VyKAogICAgICAgICAgICAgICAgWzQ4LjcwMDg3MTEyLCA5LjIxMzA1MDAxXSwKICAgICAgICAgICAgICAgIHsKICAiYnViYmxpbmdNb3VzZUV2ZW50cyI6IHRydWUsCiAgImNvbG9yIjogImJsdWUiLAogICJkYXNoQXJyYXkiOiBudWxsLAogICJkYXNoT2Zmc2V0IjogbnVsbCwKICAiZmlsbCI6IHRydWUsCiAgImZpbGxDb2xvciI6ICIjMzE4NmNjIiwKICAiZmlsbE9wYWNpdHkiOiAwLjcsCiAgImZpbGxSdWxlIjogImV2ZW5vZGQiLAogICJsaW5lQ2FwIjogInJvdW5kIiwKICAibGluZUpvaW4iOiAicm91bmQiLAogICJvcGFjaXR5IjogMS4wLAogICJyYWRpdXMiOiA1LAogICJzdHJva2UiOiB0cnVlLAogICJ3ZWlnaHQiOiAzCn0KICAgICAgICAgICAgICAgICkKICAgICAgICAgICAgICAgIC5hZGRUbyhtYXBfN2U4ZTI3ZTUwZTgzNDE2MjkwNmU1NWRkZDMyM2JkMTUpOwogICAgICAgICAgICAKICAgIAogICAgICAgICAgICB2YXIgcG9wdXBfN2JlNGQ4YjI3YmI5NGI3Yjg2MTNlOWM5ZmNmYjY1MDUgPSBMLnBvcHVwKHttYXhXaWR0aDogJzMwMCcKICAgICAgICAgICAgCiAgICAgICAgICAgIH0pOwoKICAgICAgICAgICAgCiAgICAgICAgICAgICAgICB2YXIgaHRtbF85NDdjMDk2YWU5NTI0NzM2OWU3ZWUyYzlhN2M3Y2EyMyA9ICQoYDxkaXYgaWQ9Imh0bWxfOTQ3YzA5NmFlOTUyNDczNjllN2VlMmM5YTdjN2NhMjMiIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPlBsaWVuaW5nZW48L2Rpdj5gKVswXTsKICAgICAgICAgICAgICAgIHBvcHVwXzdiZTRkOGIyN2JiOTRiN2I4NjEzZTljOWZjZmI2NTA1LnNldENvbnRlbnQoaHRtbF85NDdjMDk2YWU5NTI0NzM2OWU3ZWUyYzlhN2M3Y2EyMyk7CiAgICAgICAgICAgIAoKICAgICAgICAgICAgY2lyY2xlX21hcmtlcl83MDU3Y2EzOWMyZTU0NTMxODc1ZDc2MWQxMzBkMTgwMS5iaW5kUG9wdXAocG9wdXBfN2JlNGQ4YjI3YmI5NGI3Yjg2MTNlOWM5ZmNmYjY1MDUpCiAgICAgICAgICAgIDsKCiAgICAgICAgICAgIAogICAgICAgIAogICAgCiAgICAgICAgICAgIHZhciBjaXJjbGVfbWFya2VyX2RiZDZhMjliZTc3MTQ4NzU4NDIzMzU5NGY2M2QwYjY5ID0gTC5jaXJjbGVNYXJrZXIoCiAgICAgICAgICAgICAgICBbNDguNzQ0ODk2OTksIDkuMjEyNDE0MzJdLAogICAgICAgICAgICAgICAgewogICJidWJibGluZ01vdXNlRXZlbnRzIjogdHJ1ZSwKICAiY29sb3IiOiAiYmx1ZSIsCiAgImRhc2hBcnJheSI6IG51bGwsCiAgImRhc2hPZmZzZXQiOiBudWxsLAogICJmaWxsIjogdHJ1ZSwKICAiZmlsbENvbG9yIjogIiMzMTg2Y2MiLAogICJmaWxsT3BhY2l0eSI6IDAuNywKICAiZmlsbFJ1bGUiOiAiZXZlbm9kZCIsCiAgImxpbmVDYXAiOiAicm91bmQiLAogICJsaW5lSm9pbiI6ICJyb3VuZCIsCiAgIm9wYWNpdHkiOiAxLjAsCiAgInJhZGl1cyI6IDUsCiAgInN0cm9rZSI6IHRydWUsCiAgIndlaWdodCI6IDMKfQogICAgICAgICAgICAgICAgKQogICAgICAgICAgICAgICAgLmFkZFRvKG1hcF83ZThlMjdlNTBlODM0MTYyOTA2ZTU1ZGRkMzIzYmQxNSk7CiAgICAgICAgICAgIAogICAgCiAgICAgICAgICAgIHZhciBwb3B1cF8wYTEzMTNiNjMzNTQ0OGFhYmRmYWE1ODJmYTQxNThlYSA9IEwucG9wdXAoe21heFdpZHRoOiAnMzAwJwogICAgICAgICAgICAKICAgICAgICAgICAgfSk7CgogICAgICAgICAgICAKICAgICAgICAgICAgICAgIHZhciBodG1sXzA5M2JkZWRkMjBlODQ0ZTdhOTAzYzNmMzBiYjgyMWVjID0gJChgPGRpdiBpZD0iaHRtbF8wOTNiZGVkZDIwZTg0NGU3YTkwM2MzZjMwYmI4MjFlYyIgc3R5bGU9IndpZHRoOiAxMDAuMCU7IGhlaWdodDogMTAwLjAlOyI+U2lsbGVuYnVjaDwvZGl2PmApWzBdOwogICAgICAgICAgICAgICAgcG9wdXBfMGExMzEzYjYzMzU0NDhhYWJkZmFhNTgyZmE0MTU4ZWEuc2V0Q29udGVudChodG1sXzA5M2JkZWRkMjBlODQ0ZTdhOTAzYzNmMzBiYjgyMWVjKTsKICAgICAgICAgICAgCgogICAgICAgICAgICBjaXJjbGVfbWFya2VyX2RiZDZhMjliZTc3MTQ4NzU4NDIzMzU5NGY2M2QwYjY5LmJpbmRQb3B1cChwb3B1cF8wYTEzMTNiNjMzNTQ0OGFhYmRmYWE1ODJmYTQxNThlYSkKICAgICAgICAgICAgOwoKICAgICAgICAgICAgCiAgICAgICAgCiAgICAKICAgICAgICAgICAgdmFyIGNpcmNsZV9tYXJrZXJfYmFlN2E2YTcyZGI0NDVmNWJmYzNmNjllNDg3NTZmMzAgPSBMLmNpcmNsZU1hcmtlcigKICAgICAgICAgICAgICAgIFs0OC44NDcyNzE3OCwgOS4xNTY3ODI2M10sCiAgICAgICAgICAgICAgICB7CiAgImJ1YmJsaW5nTW91c2VFdmVudHMiOiB0cnVlLAogICJjb2xvciI6ICJibHVlIiwKICAiZGFzaEFycmF5IjogbnVsbCwKICAiZGFzaE9mZnNldCI6IG51bGwsCiAgImZpbGwiOiB0cnVlLAogICJmaWxsQ29sb3IiOiAiIzMxODZjYyIsCiAgImZpbGxPcGFjaXR5IjogMC43LAogICJmaWxsUnVsZSI6ICJldmVub2RkIiwKICAibGluZUNhcCI6ICJyb3VuZCIsCiAgImxpbmVKb2luIjogInJvdW5kIiwKICAib3BhY2l0eSI6IDEuMCwKICAicmFkaXVzIjogNSwKICAic3Ryb2tlIjogdHJ1ZSwKICAid2VpZ2h0IjogMwp9CiAgICAgICAgICAgICAgICApCiAgICAgICAgICAgICAgICAuYWRkVG8obWFwXzdlOGUyN2U1MGU4MzQxNjI5MDZlNTVkZGQzMjNiZDE1KTsKICAgICAgICAgICAgCiAgICAKICAgICAgICAgICAgdmFyIHBvcHVwX2UwY2NhY2Q1OWVjOTQ5MTU4MWJlYzM3MmNjYTA0YmMzID0gTC5wb3B1cCh7bWF4V2lkdGg6ICczMDAnCiAgICAgICAgICAgIAogICAgICAgICAgICB9KTsKCiAgICAgICAgICAgIAogICAgICAgICAgICAgICAgdmFyIGh0bWxfMmYyYzE4ZWEzZjIwNDIwMDkxYTE1NzM5ZmJkMjYwMDcgPSAkKGA8ZGl2IGlkPSJodG1sXzJmMmMxOGVhM2YyMDQyMDA5MWExNTczOWZiZDI2MDA3IiBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij5TdGFtbWhlaW08L2Rpdj5gKVswXTsKICAgICAgICAgICAgICAgIHBvcHVwX2UwY2NhY2Q1OWVjOTQ5MTU4MWJlYzM3MmNjYTA0YmMzLnNldENvbnRlbnQoaHRtbF8yZjJjMThlYTNmMjA0MjAwOTFhMTU3MzlmYmQyNjAwNyk7CiAgICAgICAgICAgIAoKICAgICAgICAgICAgY2lyY2xlX21hcmtlcl9iYWU3YTZhNzJkYjQ0NWY1YmZjM2Y2OWU0ODc1NmYzMC5iaW5kUG9wdXAocG9wdXBfZTBjY2FjZDU5ZWM5NDkxNTgxYmVjMzcyY2NhMDRiYzMpCiAgICAgICAgICAgIDsKCiAgICAgICAgICAgIAogICAgICAgIAogICAgCiAgICAgICAgICAgIHZhciBjaXJjbGVfbWFya2VyXzMxMjYyMWNlMDM1NTRiZTM4OWIzODJjYjRjZWZlN2Y1ID0gTC5jaXJjbGVNYXJrZXIoCiAgICAgICAgICAgICAgICBbNDguNzYzNjIyMDgsIDkuMTY4MDA0OTldLAogICAgICAgICAgICAgICAgewogICJidWJibGluZ01vdXNlRXZlbnRzIjogdHJ1ZSwKICAiY29sb3IiOiAiYmx1ZSIsCiAgImRhc2hBcnJheSI6IG51bGwsCiAgImRhc2hPZmZzZXQiOiBudWxsLAogICJmaWxsIjogdHJ1ZSwKICAiZmlsbENvbG9yIjogIiMzMTg2Y2MiLAogICJmaWxsT3BhY2l0eSI6IDAuNywKICAiZmlsbFJ1bGUiOiAiZXZlbm9kZCIsCiAgImxpbmVDYXAiOiAicm91bmQiLAogICJsaW5lSm9pbiI6ICJyb3VuZCIsCiAgIm9wYWNpdHkiOiAxLjAsCiAgInJhZGl1cyI6IDUsCiAgInN0cm9rZSI6IHRydWUsCiAgIndlaWdodCI6IDMKfQogICAgICAgICAgICAgICAgKQogICAgICAgICAgICAgICAgLmFkZFRvKG1hcF83ZThlMjdlNTBlODM0MTYyOTA2ZTU1ZGRkMzIzYmQxNSk7CiAgICAgICAgICAgIAogICAgCiAgICAgICAgICAgIHZhciBwb3B1cF84MGQ5OWU2NDhhYzU0NTljOTllNmUzZGVmMTk1YzIwYiA9IEwucG9wdXAoe21heFdpZHRoOiAnMzAwJwogICAgICAgICAgICAKICAgICAgICAgICAgfSk7CgogICAgICAgICAgICAKICAgICAgICAgICAgICAgIHZhciBodG1sXzk0OTEzYWJmMzc3MDQ5MjNiNDdkNWU5OTk1ZTE4NmU4ID0gJChgPGRpdiBpZD0iaHRtbF85NDkxM2FiZjM3NzA0OTIzYjQ3ZDVlOTk5NWUxODZlOCIgc3R5bGU9IndpZHRoOiAxMDAuMCU7IGhlaWdodDogMTAwLjAlOyI+U8O8ZDwvZGl2PmApWzBdOwogICAgICAgICAgICAgICAgcG9wdXBfODBkOTllNjQ4YWM1NDU5Yzk5ZTZlM2RlZjE5NWMyMGIuc2V0Q29udGVudChodG1sXzk0OTEzYWJmMzc3MDQ5MjNiNDdkNWU5OTk1ZTE4NmU4KTsKICAgICAgICAgICAgCgogICAgICAgICAgICBjaXJjbGVfbWFya2VyXzMxMjYyMWNlMDM1NTRiZTM4OWIzODJjYjRjZWZlN2Y1LmJpbmRQb3B1cChwb3B1cF84MGQ5OWU2NDhhYzU0NTljOTllNmUzZGVmMTk1YzIwYikKICAgICAgICAgICAgOwoKICAgICAgICAgICAgCiAgICAgICAgCiAgICAKICAgICAgICAgICAgdmFyIGNpcmNsZV9tYXJrZXJfMGFlYTM1OGU2NGQyNDIxZDhkOGNlOTAzNjE3M2MwYTMgPSBMLmNpcmNsZU1hcmtlcigKICAgICAgICAgICAgICAgIFs0OC43NzkzOTc0NSwgOS4yNDg3ODI0XSwKICAgICAgICAgICAgICAgIHsKICAiYnViYmxpbmdNb3VzZUV2ZW50cyI6IHRydWUsCiAgImNvbG9yIjogImJsdWUiLAogICJkYXNoQXJyYXkiOiBudWxsLAogICJkYXNoT2Zmc2V0IjogbnVsbCwKICAiZmlsbCI6IHRydWUsCiAgImZpbGxDb2xvciI6ICIjMzE4NmNjIiwKICAiZmlsbE9wYWNpdHkiOiAwLjcsCiAgImZpbGxSdWxlIjogImV2ZW5vZGQiLAogICJsaW5lQ2FwIjogInJvdW5kIiwKICAibGluZUpvaW4iOiAicm91bmQiLAogICJvcGFjaXR5IjogMS4wLAogICJyYWRpdXMiOiA1LAogICJzdHJva2UiOiB0cnVlLAogICJ3ZWlnaHQiOiAzCn0KICAgICAgICAgICAgICAgICkKICAgICAgICAgICAgICAgIC5hZGRUbyhtYXBfN2U4ZTI3ZTUwZTgzNDE2MjkwNmU1NWRkZDMyM2JkMTUpOwogICAgICAgICAgICAKICAgIAogICAgICAgICAgICB2YXIgcG9wdXBfZjQ1MTNmMWUyMGQ2NDRkMTk4MDJmZWNiZWEyOTgwNmIgPSBMLnBvcHVwKHttYXhXaWR0aDogJzMwMCcKICAgICAgICAgICAgCiAgICAgICAgICAgIH0pOwoKICAgICAgICAgICAgCiAgICAgICAgICAgICAgICB2YXIgaHRtbF9kMDBhMzIxNzAzMzc0NGUwYmM1YzQxM2IzN2M3ZTk4ZiA9ICQoYDxkaXYgaWQ9Imh0bWxfZDAwYTMyMTcwMzM3NDRlMGJjNWM0MTNiMzdjN2U5OGYiIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPlVudGVydMO8cmtoZWltPC9kaXY+YClbMF07CiAgICAgICAgICAgICAgICBwb3B1cF9mNDUxM2YxZTIwZDY0NGQxOTgwMmZlY2JlYTI5ODA2Yi5zZXRDb250ZW50KGh0bWxfZDAwYTMyMTcwMzM3NDRlMGJjNWM0MTNiMzdjN2U5OGYpOwogICAgICAgICAgICAKCiAgICAgICAgICAgIGNpcmNsZV9tYXJrZXJfMGFlYTM1OGU2NGQyNDIxZDhkOGNlOTAzNjE3M2MwYTMuYmluZFBvcHVwKHBvcHVwX2Y0NTEzZjFlMjBkNjQ0ZDE5ODAyZmVjYmVhMjk4MDZiKQogICAgICAgICAgICA7CgogICAgICAgICAgICAKICAgICAgICAKICAgIAogICAgICAgICAgICB2YXIgY2lyY2xlX21hcmtlcl8yZjg0MDUwM2ViOTc0MWFiYmU5ZDY4OTdlNmE3NTg3MCA9IEwuY2lyY2xlTWFya2VyKAogICAgICAgICAgICAgICAgWzQ4LjcyOTgxMzE3LCA5LjEwOTcyNTk1XSwKICAgICAgICAgICAgICAgIHsKICAiYnViYmxpbmdNb3VzZUV2ZW50cyI6IHRydWUsCiAgImNvbG9yIjogImJsdWUiLAogICJkYXNoQXJyYXkiOiBudWxsLAogICJkYXNoT2Zmc2V0IjogbnVsbCwKICAiZmlsbCI6IHRydWUsCiAgImZpbGxDb2xvciI6ICIjMzE4NmNjIiwKICAiZmlsbE9wYWNpdHkiOiAwLjcsCiAgImZpbGxSdWxlIjogImV2ZW5vZGQiLAogICJsaW5lQ2FwIjogInJvdW5kIiwKICAibGluZUpvaW4iOiAicm91bmQiLAogICJvcGFjaXR5IjogMS4wLAogICJyYWRpdXMiOiA1LAogICJzdHJva2UiOiB0cnVlLAogICJ3ZWlnaHQiOiAzCn0KICAgICAgICAgICAgICAgICkKICAgICAgICAgICAgICAgIC5hZGRUbyhtYXBfN2U4ZTI3ZTUwZTgzNDE2MjkwNmU1NWRkZDMyM2JkMTUpOwogICAgICAgICAgICAKICAgIAogICAgICAgICAgICB2YXIgcG9wdXBfZTE5ZDZlM2QyZDAyNGQ0ODg0Nzg5ZmQ3NzA2NDI4NmYgPSBMLnBvcHVwKHttYXhXaWR0aDogJzMwMCcKICAgICAgICAgICAgCiAgICAgICAgICAgIH0pOwoKICAgICAgICAgICAgCiAgICAgICAgICAgICAgICB2YXIgaHRtbF83YTg0YTRjY2QwNmQ0M2M1OTc5NDgxNGRlNmEwYzliZiA9ICQoYDxkaXYgaWQ9Imh0bWxfN2E4NGE0Y2NkMDZkNDNjNTk3OTQ4MTRkZTZhMGM5YmYiIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPlZhaWhpbmdlbjwvZGl2PmApWzBdOwogICAgICAgICAgICAgICAgcG9wdXBfZTE5ZDZlM2QyZDAyNGQ0ODg0Nzg5ZmQ3NzA2NDI4NmYuc2V0Q29udGVudChodG1sXzdhODRhNGNjZDA2ZDQzYzU5Nzk0ODE0ZGU2YTBjOWJmKTsKICAgICAgICAgICAgCgogICAgICAgICAgICBjaXJjbGVfbWFya2VyXzJmODQwNTAzZWI5NzQxYWJiZTlkNjg5N2U2YTc1ODcwLmJpbmRQb3B1cChwb3B1cF9lMTlkNmUzZDJkMDI0ZDQ4ODQ3ODlmZDc3MDY0Mjg2ZikKICAgICAgICAgICAgOwoKICAgICAgICAgICAgCiAgICAgICAgCiAgICAKICAgICAgICAgICAgdmFyIGNpcmNsZV9tYXJrZXJfN2VhOWY5ZmVkZjNiNGJiYmEyMzQ4YTlmZjViYTQ5MzUgPSBMLmNpcmNsZU1hcmtlcigKICAgICAgICAgICAgICAgIFs0OC43NzIwNTQ4NSwgOS4yNDUxMTg1XSwKICAgICAgICAgICAgICAgIHsKICAiYnViYmxpbmdNb3VzZUV2ZW50cyI6IHRydWUsCiAgImNvbG9yIjogImJsdWUiLAogICJkYXNoQXJyYXkiOiBudWxsLAogICJkYXNoT2Zmc2V0IjogbnVsbCwKICAiZmlsbCI6IHRydWUsCiAgImZpbGxDb2xvciI6ICIjMzE4NmNjIiwKICAiZmlsbE9wYWNpdHkiOiAwLjcsCiAgImZpbGxSdWxlIjogImV2ZW5vZGQiLAogICJsaW5lQ2FwIjogInJvdW5kIiwKICAibGluZUpvaW4iOiAicm91bmQiLAogICJvcGFjaXR5IjogMS4wLAogICJyYWRpdXMiOiA1LAogICJzdHJva2UiOiB0cnVlLAogICJ3ZWlnaHQiOiAzCn0KICAgICAgICAgICAgICAgICkKICAgICAgICAgICAgICAgIC5hZGRUbyhtYXBfN2U4ZTI3ZTUwZTgzNDE2MjkwNmU1NWRkZDMyM2JkMTUpOwogICAgICAgICAgICAKICAgIAogICAgICAgICAgICB2YXIgcG9wdXBfZDY2MjA5YTU4MmIxNGUxZjhiMDI1ZTRlOTIwN2EzMTkgPSBMLnBvcHVwKHttYXhXaWR0aDogJzMwMCcKICAgICAgICAgICAgCiAgICAgICAgICAgIH0pOwoKICAgICAgICAgICAgCiAgICAgICAgICAgICAgICB2YXIgaHRtbF81MjFmOTYxZDczZTY0YWQ3YmUwMzAyMzRiNTI1YjIzZSA9ICQoYDxkaXYgaWQ9Imh0bWxfNTIxZjk2MWQ3M2U2NGFkN2JlMDMwMjM0YjUyNWIyM2UiIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPldhbmdlbjwvZGl2PmApWzBdOwogICAgICAgICAgICAgICAgcG9wdXBfZDY2MjA5YTU4MmIxNGUxZjhiMDI1ZTRlOTIwN2EzMTkuc2V0Q29udGVudChodG1sXzUyMWY5NjFkNzNlNjRhZDdiZTAzMDIzNGI1MjViMjNlKTsKICAgICAgICAgICAgCgogICAgICAgICAgICBjaXJjbGVfbWFya2VyXzdlYTlmOWZlZGYzYjRiYmJhMjM0OGE5ZmY1YmE0OTM1LmJpbmRQb3B1cChwb3B1cF9kNjYyMDlhNTgyYjE0ZTFmOGIwMjVlNGU5MjA3YTMxOSkKICAgICAgICAgICAgOwoKICAgICAgICAgICAgCiAgICAgICAgCiAgICAKICAgICAgICAgICAgdmFyIGNpcmNsZV9tYXJrZXJfNDM4NWYxNTFjYjNjNGU0OGFjODRjMzE3MDVmYTY0MjkgPSBMLmNpcmNsZU1hcmtlcigKICAgICAgICAgICAgICAgIFs0OC44MTM2OTIyOSwgOS4xMTE2NjI1MV0sCiAgICAgICAgICAgICAgICB7CiAgImJ1YmJsaW5nTW91c2VFdmVudHMiOiB0cnVlLAogICJjb2xvciI6ICJibHVlIiwKICAiZGFzaEFycmF5IjogbnVsbCwKICAiZGFzaE9mZnNldCI6IG51bGwsCiAgImZpbGwiOiB0cnVlLAogICJmaWxsQ29sb3IiOiAiIzMxODZjYyIsCiAgImZpbGxPcGFjaXR5IjogMC43LAogICJmaWxsUnVsZSI6ICJldmVub2RkIiwKICAibGluZUNhcCI6ICJyb3VuZCIsCiAgImxpbmVKb2luIjogInJvdW5kIiwKICAib3BhY2l0eSI6IDEuMCwKICAicmFkaXVzIjogNSwKICAic3Ryb2tlIjogdHJ1ZSwKICAid2VpZ2h0IjogMwp9CiAgICAgICAgICAgICAgICApCiAgICAgICAgICAgICAgICAuYWRkVG8obWFwXzdlOGUyN2U1MGU4MzQxNjI5MDZlNTVkZGQzMjNiZDE1KTsKICAgICAgICAgICAgCiAgICAKICAgICAgICAgICAgdmFyIHBvcHVwX2QyOWY4OWE5MTc2NzQ2NmJhOTcwZTY1M2UwYjg0NzIwID0gTC5wb3B1cCh7bWF4V2lkdGg6ICczMDAnCiAgICAgICAgICAgIAogICAgICAgICAgICB9KTsKCiAgICAgICAgICAgIAogICAgICAgICAgICAgICAgdmFyIGh0bWxfMTc1MDQ5ODc0YTMzNDk3Mzg1Y2VjNWRlZGNmYWY0Y2QgPSAkKGA8ZGl2IGlkPSJodG1sXzE3NTA0OTg3NGEzMzQ5NzM4NWNlYzVkZWRjZmFmNGNkIiBzdHlsZT0id2lkdGg6IDEwMC4wJTsgaGVpZ2h0OiAxMDAuMCU7Ij5XZWlsaW1kb3JmPC9kaXY+YClbMF07CiAgICAgICAgICAgICAgICBwb3B1cF9kMjlmODlhOTE3Njc0NjZiYTk3MGU2NTNlMGI4NDcyMC5zZXRDb250ZW50KGh0bWxfMTc1MDQ5ODc0YTMzNDk3Mzg1Y2VjNWRlZGNmYWY0Y2QpOwogICAgICAgICAgICAKCiAgICAgICAgICAgIGNpcmNsZV9tYXJrZXJfNDM4NWYxNTFjYjNjNGU0OGFjODRjMzE3MDVmYTY0MjkuYmluZFBvcHVwKHBvcHVwX2QyOWY4OWE5MTc2NzQ2NmJhOTcwZTY1M2UwYjg0NzIwKQogICAgICAgICAgICA7CgogICAgICAgICAgICAKICAgICAgICAKICAgIAogICAgICAgICAgICB2YXIgY2lyY2xlX21hcmtlcl80YzYyZmE3MmMxNmU0NGUzYmE2NDY4ODMyZDJlMzFjYSA9IEwuY2lyY2xlTWFya2VyKAogICAgICAgICAgICAgICAgWzQ4Ljc3NTA0MjIyLCA5LjE1NTk3Nzk2XSwKICAgICAgICAgICAgICAgIHsKICAiYnViYmxpbmdNb3VzZUV2ZW50cyI6IHRydWUsCiAgImNvbG9yIjogImJsdWUiLAogICJkYXNoQXJyYXkiOiBudWxsLAogICJkYXNoT2Zmc2V0IjogbnVsbCwKICAiZmlsbCI6IHRydWUsCiAgImZpbGxDb2xvciI6ICIjMzE4NmNjIiwKICAiZmlsbE9wYWNpdHkiOiAwLjcsCiAgImZpbGxSdWxlIjogImV2ZW5vZGQiLAogICJsaW5lQ2FwIjogInJvdW5kIiwKICAibGluZUpvaW4iOiAicm91bmQiLAogICJvcGFjaXR5IjogMS4wLAogICJyYWRpdXMiOiA1LAogICJzdHJva2UiOiB0cnVlLAogICJ3ZWlnaHQiOiAzCn0KICAgICAgICAgICAgICAgICkKICAgICAgICAgICAgICAgIC5hZGRUbyhtYXBfN2U4ZTI3ZTUwZTgzNDE2MjkwNmU1NWRkZDMyM2JkMTUpOwogICAgICAgICAgICAKICAgIAogICAgICAgICAgICB2YXIgcG9wdXBfNTc1ODI0MDE4NmRiNDZiOGI0ZDljOTNiMmM1Y2ZhODEgPSBMLnBvcHVwKHttYXhXaWR0aDogJzMwMCcKICAgICAgICAgICAgCiAgICAgICAgICAgIH0pOwoKICAgICAgICAgICAgCiAgICAgICAgICAgICAgICB2YXIgaHRtbF8xMTRjZTJhZmMwNDQ0MzI3YjVkYThjZWI0Yjg2NTg1ZSA9ICQoYDxkaXYgaWQ9Imh0bWxfMTE0Y2UyYWZjMDQ0NDMyN2I1ZGE4Y2ViNGI4NjU4NWUiIHN0eWxlPSJ3aWR0aDogMTAwLjAlOyBoZWlnaHQ6IDEwMC4wJTsiPldlc3Q8L2Rpdj5gKVswXTsKICAgICAgICAgICAgICAgIHBvcHVwXzU3NTgyNDAxODZkYjQ2YjhiNGQ5YzkzYjJjNWNmYTgxLnNldENvbnRlbnQoaHRtbF8xMTRjZTJhZmMwNDQ0MzI3YjVkYThjZWI0Yjg2NTg1ZSk7CiAgICAgICAgICAgIAoKICAgICAgICAgICAgY2lyY2xlX21hcmtlcl80YzYyZmE3MmMxNmU0NGUzYmE2NDY4ODMyZDJlMzFjYS5iaW5kUG9wdXAocG9wdXBfNTc1ODI0MDE4NmRiNDZiOGI0ZDljOTNiMmM1Y2ZhODEpCiAgICAgICAgICAgIDsKCiAgICAgICAgICAgIAogICAgICAgIAogICAgCiAgICAgICAgICAgIHZhciBjaXJjbGVfbWFya2VyXzQxZGJjN2EzNTQ2NzQzOWFhZTkxYTJmZDUzN2MzMjY1ID0gTC5jaXJjbGVNYXJrZXIoCiAgICAgICAgICAgICAgICBbNDguODMyMzY1MjUsIDkuMTY5NzQzMDZdLAogICAgICAgICAgICAgICAgewogICJidWJibGluZ01vdXNlRXZlbnRzIjogdHJ1ZSwKICAiY29sb3IiOiAiYmx1ZSIsCiAgImRhc2hBcnJheSI6IG51bGwsCiAgImRhc2hPZmZzZXQiOiBudWxsLAogICJmaWxsIjogdHJ1ZSwKICAiZmlsbENvbG9yIjogIiMzMTg2Y2MiLAogICJmaWxsT3BhY2l0eSI6IDAuNywKICAiZmlsbFJ1bGUiOiAiZXZlbm9kZCIsCiAgImxpbmVDYXAiOiAicm91bmQiLAogICJsaW5lSm9pbiI6ICJyb3VuZCIsCiAgIm9wYWNpdHkiOiAxLjAsCiAgInJhZGl1cyI6IDUsCiAgInN0cm9rZSI6IHRydWUsCiAgIndlaWdodCI6IDMKfQogICAgICAgICAgICAgICAgKQogICAgICAgICAgICAgICAgLmFkZFRvKG1hcF83ZThlMjdlNTBlODM0MTYyOTA2ZTU1ZGRkMzIzYmQxNSk7CiAgICAgICAgICAgIAogICAgCiAgICAgICAgICAgIHZhciBwb3B1cF82M2U2N2E3ODM4OGU0MGYxYWY0Yzk3ZDQ3YjY4ODJmMSA9IEwucG9wdXAoe21heFdpZHRoOiAnMzAwJwogICAgICAgICAgICAKICAgICAgICAgICAgfSk7CgogICAgICAgICAgICAKICAgICAgICAgICAgICAgIHZhciBodG1sXzRlNmNjNGRhM2NhODQ5NDU4MGFkYWQ4ZjRmZjNkYzRlID0gJChgPGRpdiBpZD0iaHRtbF80ZTZjYzRkYTNjYTg0OTQ1ODBhZGFkOGY0ZmYzZGM0ZSIgc3R5bGU9IndpZHRoOiAxMDAuMCU7IGhlaWdodDogMTAwLjAlOyI+WnVmZmVuaGF1c2VuPC9kaXY+YClbMF07CiAgICAgICAgICAgICAgICBwb3B1cF82M2U2N2E3ODM4OGU0MGYxYWY0Yzk3ZDQ3YjY4ODJmMS5zZXRDb250ZW50KGh0bWxfNGU2Y2M0ZGEzY2E4NDk0NTgwYWRhZDhmNGZmM2RjNGUpOwogICAgICAgICAgICAKCiAgICAgICAgICAgIGNpcmNsZV9tYXJrZXJfNDFkYmM3YTM1NDY3NDM5YWFlOTFhMmZkNTM3YzMyNjUuYmluZFBvcHVwKHBvcHVwXzYzZTY3YTc4Mzg4ZTQwZjFhZjRjOTdkNDdiNjg4MmYxKQogICAgICAgICAgICA7CgogICAgICAgICAgICAKICAgICAgICAKPC9zY3JpcHQ+\" style=\"position:absolute;width:100%;height:100%;left:0;top:0;border:none !important;\" allowfullscreen webkitallowfullscreen mozallowfullscreen></iframe></div></div>"
      ],
      "text/plain": [
       "<folium.folium.Map at 0x1bb9deb5cf8>"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import folium\n",
    "\n",
    "# create map of Stuttgart using latitude and longitude values\n",
    "map_stuttgart = folium.Map(location=[values_column3[0], values_column4[0]], zoom_start=11)\n",
    "\n",
    "# add markers to map\n",
    "for lat, lng, label in zip(Bouroughs_S['latitude'], Bouroughs_S['longitude'], Bouroughs_S['Borough']):\n",
    "    label = folium.Popup(label, parse_html=True)\n",
    "    folium.CircleMarker(\n",
    "        [lat, lng],\n",
    "        radius=5,\n",
    "        popup=label,\n",
    "        color='blue',\n",
    "        fill=True,\n",
    "        fill_color='#3186cc',\n",
    "        fill_opacity=0.7).add_to(map_stuttgart)  \n",
    "    \n",
    "map_stuttgart"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**4. Getting data from foursquare**\n",
    "\n",
    "Now it's time to get some data from Foursquare, that could influence the rents.                                                       \n",
    "Number of restaurants, parks, shooping location, tram stations.                                                                 Therefore, I let's get the top 100 venues in a radius of 3km around the coordinates for each bourough\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 200,
   "metadata": {},
   "outputs": [],
   "source": [
    "from pandas.io.json import json_normalize\n",
    "CLIENT_ID = 'WDZVSRMBUM4GRNNKUTSV0AWYLLMHLNHZUGZDIOE25V5MLE1F' \n",
    "CLIENT_SECRET = 'WD4NYWRDESXQLLL21JGE1NASVBZVMURHWRTEAPOP1LP5SJMK' \n",
    "VERSION = '20180604'\n",
    "LIMIT = 150\n",
    "radius = 3000"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 201,
   "metadata": {},
   "outputs": [],
   "source": [
    "def venues_categories(venue_request):\n",
    "    '''\n",
    "    returns a list with the categories with all the venues of the json file\n",
    "    '''\n",
    "    #determine how many venues are in the file\n",
    "    amount_venues = len(venue_request['response']['groups'][0]['items'])\n",
    "    #initiate empty list\n",
    "    category_list = []\n",
    "    #loop through the file and append the short names of the category to the list\n",
    "    for i in range(0,amount_venues):\n",
    "        category_list.append(venue_request['response']['groups'][0]['items'][i]['venue']['categories'][0]['shortName'])\n",
    "        \n",
    "    return category_list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 202,
   "metadata": {},
   "outputs": [],
   "source": [
    "number_boroughs = len(Bouroughs_S['Borough'])\n",
    "categories_list = []\n",
    "for i in range(0, number_boroughs):\n",
    "    # loop thourgh all the boroughs in our dataset and save latitude and longitude\n",
    "    latitude = Bouroughs_S.loc[i,'latitude']\n",
    "    longitude = Bouroughs_S.loc[i,'longitude']\n",
    "\n",
    "    #get the url for the call\n",
    "    url = 'https://api.foursquare.com/v2/venues/explore?&client_id={}&client_secret={}&v={}&ll={},{}&radius={}&limit={}'.format(\n",
    "        CLIENT_ID, \n",
    "        CLIENT_SECRET, \n",
    "        VERSION, \n",
    "        latitude, \n",
    "        longitude, \n",
    "        radius, \n",
    "        LIMIT)\n",
    "    \n",
    "    #make the call\n",
    "    results = requests.get(url).json()\n",
    "    \n",
    "    #save the categories of the venues into a list, the index of the borough in our data frame is also the same index in this list\n",
    "    categories_list.append(venues_categories(results))\n",
    "    "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Now we can expolore the different categories in the different boroughs and try to cluster and condense them"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 203,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Concert Hall',\n",
       " 'Gastropub',\n",
       " 'Hardware',\n",
       " 'Museum',\n",
       " 'Restaurant',\n",
       " 'Lounge',\n",
       " 'German',\n",
       " 'Burgers',\n",
       " 'Park',\n",
       " 'Deli / Bodega',\n",
       " 'German',\n",
       " 'Soccer',\n",
       " 'Hotel',\n",
       " 'Racetrack',\n",
       " 'Concert Hall',\n",
       " 'Soccer Field',\n",
       " 'Bakery',\n",
       " 'Middle Eastern',\n",
       " 'History Museum',\n",
       " 'Restaurant',\n",
       " 'Hotel',\n",
       " 'Bakery',\n",
       " 'Gym',\n",
       " 'Hotel',\n",
       " 'Vineyard',\n",
       " 'Fried Chicken',\n",
       " 'German',\n",
       " 'Bakery',\n",
       " 'Greek',\n",
       " 'Pool',\n",
       " 'Sporting Goods',\n",
       " 'Wine Shop',\n",
       " 'Pool',\n",
       " 'Park',\n",
       " 'German',\n",
       " 'Pub',\n",
       " 'German',\n",
       " 'Grocery Store',\n",
       " 'Italian',\n",
       " 'Lounge',\n",
       " 'Supermarket',\n",
       " 'Museum',\n",
       " 'Gym',\n",
       " 'Sports Bar',\n",
       " 'Event Space',\n",
       " 'Schnitzel',\n",
       " 'Hotel',\n",
       " 'Supermarket',\n",
       " 'Supermarket',\n",
       " 'German',\n",
       " 'Fried Chicken',\n",
       " 'Hotel',\n",
       " 'Stadium',\n",
       " 'Hardware',\n",
       " 'Fast Food',\n",
       " 'Fast Food',\n",
       " 'Chinese',\n",
       " 'Harbor / Marina',\n",
       " 'Supermarket',\n",
       " 'Soccer Field',\n",
       " 'Hotel',\n",
       " 'Bakery',\n",
       " 'Music Venue',\n",
       " 'German Pop-Up Restaurant']"
      ]
     },
     "execution_count": 203,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "categories_list[19]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "After looking into it, I want to extract the following features:\n",
    "1. Restaurants\n",
    "2. Sport Activities\n",
    "3. Leisure Activities\n",
    "4. Tram stopps\n",
    "5. Shopping\n",
    "\n",
    "Therefore I will create a list with the most common category names for these features"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 204,
   "metadata": {},
   "outputs": [],
   "source": [
    "restaurants = \"restaurants,german,greek,swabian,spanish,french,food & drink,japanese,african,korean,turkish,vietnamese,sushi,italien,beer garden,thai,chinese,burgers,mediterranean,steakhouse,fast food\".split(\",\")\n",
    "sports = \"gym,athletics & sports,gym / fitness,climbing gym,soccer field,soccer,sports club\".split(\",\")\n",
    "leisure =  \"garden,pool,park,history museum,art museum,castle,mountain,playground,zoo exhibit,forest,movie theater,garden center,theater,hookah bar,museum,zoo,café,pub,nightclub,concert hall,exhibit\".split(\",\")\n",
    "transport = \"train station,metro,tram,bus station,bus stop\".split(\",\")\n",
    "shopping =\"supermarket,grocery store,drugstore,bakery,mall\".split(\",\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 205,
   "metadata": {},
   "outputs": [],
   "source": [
    "# initialize some empty lists\n",
    "number_restaurants = []\n",
    "number_sports = []\n",
    "number_leisure = []\n",
    "number_transport = []\n",
    "number_shopping = []\n",
    "\n",
    "for i in range(0,number_boroughs):\n",
    "    #initialize counters\n",
    "    restaurant_count = 0\n",
    "    sports_count = 0\n",
    "    leisure_count = 0\n",
    "    transport_count = 0\n",
    "    shopping_count = 0\n",
    "    \n",
    "    #loop through all values for one borough and increase the counter if a venue falls into one of the features\n",
    "    for j in range(0,len(categories_list[i])):\n",
    "        if categories_list[i][j].lower() in restaurants:\n",
    "            restaurant_count += 1 \n",
    "        elif categories_list[i][j].lower() in sports:\n",
    "            sports_count += 1\n",
    "        elif categories_list[i][j].lower() in leisure:\n",
    "            leisure_count += 1\n",
    "        elif categories_list[i][j].lower() in transport:\n",
    "            transport_count +=1\n",
    "        elif categories_list[i][j].lower() in shopping:\n",
    "            shopping_count +=1\n",
    "        else: pass\n",
    "    #fill the list with the counters              \n",
    "    number_restaurants.append(restaurant_count)\n",
    "    number_sports.append(sports_count)\n",
    "    number_leisure.append(leisure_count)\n",
    "    number_transport.append(transport_count)\n",
    "    number_shopping.append(shopping_count)\n",
    "\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 206,
   "metadata": {},
   "outputs": [],
   "source": [
    "#adding the newe data to our data frame\n",
    "Bouroughs_S[\"number of restaurants\"] = number_restaurants\n",
    "Bouroughs_S[\"number of sports\"] = number_sports\n",
    "Bouroughs_S[\"number of leisure\"] = number_leisure\n",
    "Bouroughs_S[\"number of transport\"] = number_transport\n",
    "Bouroughs_S[\"number of shopping\"] = number_shopping"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 207,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Borough</th>\n",
       "      <th>rent (€/m²)</th>\n",
       "      <th>Postcode</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>residents per km²</th>\n",
       "      <th>sport and leisure area (m²/resident)</th>\n",
       "      <th>Average age</th>\n",
       "      <th>amount of non-german residents (%)</th>\n",
       "      <th>amount of married residents (%)</th>\n",
       "      <th>residents per household</th>\n",
       "      <th>living area per flat</th>\n",
       "      <th>number of restaurants</th>\n",
       "      <th>number of sports</th>\n",
       "      <th>number of leisure</th>\n",
       "      <th>number of transport</th>\n",
       "      <th>number of shopping</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Bad Cannstatt</td>\n",
       "      <td>16.34</td>\n",
       "      <td>70191, 70372, 70374, 70376, 70378</td>\n",
       "      <td>48.803220</td>\n",
       "      <td>9.217460</td>\n",
       "      <td>5745</td>\n",
       "      <td>32.3</td>\n",
       "      <td>40.9</td>\n",
       "      <td>31.7</td>\n",
       "      <td>46.9</td>\n",
       "      <td>1.88</td>\n",
       "      <td>74.4</td>\n",
       "      <td>16</td>\n",
       "      <td>4</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Birkach</td>\n",
       "      <td>14.87</td>\n",
       "      <td>70599</td>\n",
       "      <td>48.719300</td>\n",
       "      <td>9.208000</td>\n",
       "      <td>5945</td>\n",
       "      <td>14.0</td>\n",
       "      <td>43.1</td>\n",
       "      <td>19.6</td>\n",
       "      <td>44.7</td>\n",
       "      <td>1.86</td>\n",
       "      <td>78.8</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Botnang</td>\n",
       "      <td>14.04</td>\n",
       "      <td>70195</td>\n",
       "      <td>48.778987</td>\n",
       "      <td>9.128898</td>\n",
       "      <td>6987</td>\n",
       "      <td>16.3</td>\n",
       "      <td>45.6</td>\n",
       "      <td>17.3</td>\n",
       "      <td>52.6</td>\n",
       "      <td>1.93</td>\n",
       "      <td>86.4</td>\n",
       "      <td>12</td>\n",
       "      <td>3</td>\n",
       "      <td>11</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Degerloch</td>\n",
       "      <td>18.89</td>\n",
       "      <td>70597</td>\n",
       "      <td>48.746795</td>\n",
       "      <td>9.170746</td>\n",
       "      <td>4526</td>\n",
       "      <td>30.4</td>\n",
       "      <td>44.7</td>\n",
       "      <td>18.4</td>\n",
       "      <td>49.1</td>\n",
       "      <td>1.87</td>\n",
       "      <td>87.4</td>\n",
       "      <td>26</td>\n",
       "      <td>7</td>\n",
       "      <td>17</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Feuerbach</td>\n",
       "      <td>14.81</td>\n",
       "      <td>70192, 70469, 70499</td>\n",
       "      <td>48.811301</td>\n",
       "      <td>9.159111</td>\n",
       "      <td>5321</td>\n",
       "      <td>13.1</td>\n",
       "      <td>42.3</td>\n",
       "      <td>28.9</td>\n",
       "      <td>49.4</td>\n",
       "      <td>1.90</td>\n",
       "      <td>79.6</td>\n",
       "      <td>15</td>\n",
       "      <td>2</td>\n",
       "      <td>12</td>\n",
       "      <td>2</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         Borough  rent (€/m²)                            Postcode   latitude  \\\n",
       "0  Bad Cannstatt         16.34  70191, 70372, 70374, 70376, 70378  48.803220   \n",
       "1        Birkach         14.87                              70599  48.719300   \n",
       "2        Botnang         14.04                              70195  48.778987   \n",
       "3      Degerloch         18.89                              70597  48.746795   \n",
       "4      Feuerbach         14.81                70192, 70469, 70499  48.811301   \n",
       "\n",
       "   longitude  residents per km²  sport and leisure area (m²/resident)  \\\n",
       "0   9.217460               5745                                  32.3   \n",
       "1   9.208000               5945                                  14.0   \n",
       "2   9.128898               6987                                  16.3   \n",
       "3   9.170746               4526                                  30.4   \n",
       "4   9.159111               5321                                  13.1   \n",
       "\n",
       "   Average age  amount of non-german residents (%)  \\\n",
       "0         40.9                                31.7   \n",
       "1         43.1                                19.6   \n",
       "2         45.6                                17.3   \n",
       "3         44.7                                18.4   \n",
       "4         42.3                                28.9   \n",
       "\n",
       "   amount of married residents (%)  residents per household  \\\n",
       "0                             46.9                     1.88   \n",
       "1                             44.7                     1.86   \n",
       "2                             52.6                     1.93   \n",
       "3                             49.1                     1.87   \n",
       "4                             49.4                     1.90   \n",
       "\n",
       "   living area per flat  number of restaurants  number of sports  \\\n",
       "0                  74.4                     16                 4   \n",
       "1                  78.8                      2                 0   \n",
       "2                  86.4                     12                 3   \n",
       "3                  87.4                     26                 7   \n",
       "4                  79.6                     15                 2   \n",
       "\n",
       "   number of leisure  number of transport  number of shopping  \n",
       "0                 30                    0                   8  \n",
       "1                  5                    1                   5  \n",
       "2                 11                    2                   4  \n",
       "3                 17                    1                   4  \n",
       "4                 12                    2                  13  "
      ]
     },
     "execution_count": 207,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Bouroughs_S.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}