Coursera_Capstone_Project - 2 .ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "# Segmenting and Clustering Neighborhoods in Toronto"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Part - 1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'table0': [('Postcode',), ('M1A', 'Not assigned', 'Not assigned'), ('M2A', 'Not assigned', 'Not assigned'), ('M3A', 'North York', 'Parkwoods'), ('M4A', 'North York', 'Victoria Village'), ('M5A', 'Downtown Toronto', 'Harbourfront'), ('M5A', 'Downtown Toronto', 'Regent Park'), ('M6A', 'North York', 'Lawrence Heights'), ('M6A', 'North York', 'Lawrence Manor'), ('M7A', \"Queen's Park\", 'Not assigned'), ('M8A', 'Not assigned', 'Not assigned'), ('M9A', 'Etobicoke', 'Islington Avenue'), ('M1B', 'Scarborough', 'Rouge'), ('M1B', 'Scarborough', 'Malvern'), ('M2B', 'Not assigned', 'Not assigned'), ('M3B', 'North York', 'Don Mills North'), ('M4B', 'East York', 'Woodbine Gardens'), ('M4B', 'East York', 'Parkview Hill'), ('M5B', 'Downtown Toronto', 'Ryerson'), ('M5B', 'Downtown Toronto', 'Garden District'), ('M6B', 'North York', 'Glencairn'), ('M7B', 'Not assigned', 'Not assigned'), ('M8B', 'Not assigned', 'Not assigned'), ('M9B', 'Etobicoke', 'Cloverdale'), ('M9B', 'Etobicoke', 'Islington'), ('M9B', 'Etobicoke', 'Martin Grove'), ('M9B', 'Etobicoke', 'Princess Gardens'), ('M9B', 'Etobicoke', 'West Deane Park'), ('M1C', 'Scarborough', 'Highland Creek'), ('M1C', 'Scarborough', 'Rouge Hill'), ('M1C', 'Scarborough', 'Port Union'), ('M2C', 'Not assigned', 'Not assigned'), ('M3C', 'North York', 'Flemingdon Park'), ('M3C', 'North York', 'Don Mills South'), ('M4C', 'East York', 'Woodbine Heights'), ('M5C', 'Downtown Toronto', 'St. James Town'), ('M6C', 'York', 'Humewood-Cedarvale'), ('M7C', 'Not assigned', 'Not assigned'), ('M8C', 'Not assigned', 'Not assigned'), ('M9C', 'Etobicoke', 'Bloordale Gardens'), ('M9C', 'Etobicoke', 'Eringate'), ('M9C', 'Etobicoke', 'Markland Wood'), ('M9C', 'Etobicoke', 'Old Burnhamthorpe'), ('M1E', 'Scarborough', 'Guildwood'), ('M1E', 'Scarborough', 'Morningside'), ('M1E', 'Scarborough', 'West Hill'), ('M2E', 'Not assigned', 'Not assigned'), ('M3E', 'Not assigned', 'Not assigned'), ('M4E', 'East Toronto', 'The Beaches'), ('M5E', 'Downtown Toronto', 'Berczy Park'), ('M6E', 'York', 'Caledonia-Fairbanks'), ('M7E', 'Not assigned', 'Not assigned'), ('M8E', 'Not assigned', 'Not assigned'), ('M9E', 'Not assigned', 'Not assigned'), ('M1G', 'Scarborough', 'Woburn'), ('M2G', 'Not assigned', 'Not assigned'), ('M3G', 'Not assigned', 'Not assigned'), ('M4G', 'East York', 'Leaside'), ('M5G', 'Downtown Toronto', 'Central Bay Street'), ('M6G', 'Downtown Toronto', 'Christie'), ('M7G', 'Not assigned', 'Not assigned'), ('M8G', 'Not assigned', 'Not assigned'), ('M9G', 'Not assigned', 'Not assigned'), ('M1H', 'Scarborough', 'Cedarbrae'), ('M2H', 'North York', 'Hillcrest Village'), ('M3H', 'North York', 'Bathurst Manor'), ('M3H', 'North York', 'Downsview North'), ('M3H', 'North York', 'Wilson Heights'), ('M4H', 'East York', 'Thorncliffe Park'), ('M5H', 'Downtown Toronto', 'Adelaide'), ('M5H', 'Downtown Toronto', 'King'), ('M5H', 'Downtown Toronto', 'Richmond'), ('M6H', 'West Toronto', 'Dovercourt Village'), ('M6H', 'West Toronto', 'Dufferin'), ('M7H', 'Not assigned', 'Not assigned'), ('M8H', 'Not assigned', 'Not assigned'), ('M9H', 'Not assigned', 'Not assigned'), ('M1J', 'Scarborough', 'Scarborough Village'), ('M2J', 'North York', 'Fairview'), ('M2J', 'North York', 'Henry Farm'), ('M2J', 'North York', 'Oriole'), ('M3J', 'North York', 'Northwood Park'), ('M3J', 'North York', 'York University'), ('M4J', 'East York', 'East Toronto'), ('M5J', 'Downtown Toronto', 'Harbourfront East'), ('M5J', 'Downtown Toronto', 'Toronto Islands'), ('M5J', 'Downtown Toronto', 'Union Station'), ('M6J', 'West Toronto', 'Little Portugal'), ('M6J', 'West Toronto', 'Trinity'), ('M7J', 'Not assigned', 'Not assigned'), ('M8J', 'Not assigned', 'Not assigned'), ('M9J', 'Not assigned', 'Not assigned'), ('M1K', 'Scarborough', 'East Birchmount Park'), ('M1K', 'Scarborough', 'Ionview'), ('M1K', 'Scarborough', 'Kennedy Park'), ('M2K', 'North York', 'Bayview Village'), ('M3K', 'North York', 'CFB Toronto'), ('M3K', 'North York', 'Downsview East'), ('M4K', 'East Toronto', 'The Danforth West'), ('M4K', 'East Toronto', 'Riverdale'), ('M5K', 'Downtown Toronto', 'Design Exchange'), ('M5K', 'Downtown Toronto', 'Toronto Dominion Centre'), ('M6K', 'West Toronto', 'Brockton'), ('M6K', 'West Toronto', 'Exhibition Place'), ('M6K', 'West Toronto', 'Parkdale Village'), ('M7K', 'Not assigned', 'Not assigned'), ('M8K', 'Not assigned', 'Not assigned'), ('M9K', 'Not assigned', 'Not assigned'), ('M1L', 'Scarborough', 'Clairlea'), ('M1L', 'Scarborough', 'Golden Mile'), ('M1L', 'Scarborough', 'Oakridge'), ('M2L', 'North York', 'Silver Hills'), ('M2L', 'North York', 'York Mills'), ('M3L', 'North York', 'Downsview West'), ('M4L', 'East Toronto', 'The Beaches West'), ('M4L', 'East Toronto', 'India Bazaar'), ('M5L', 'Downtown Toronto', 'Commerce Court'), ('M5L', 'Downtown Toronto', 'Victoria Hotel'), ('M6L', 'North York', 'Downsview'), ('M6L', 'North York', 'North Park'), ('M6L', 'North York', 'Upwood Park'), ('M7L', 'Not assigned', 'Not assigned'), ('M8L', 'Not assigned', 'Not assigned'), ('M9L', 'North York', 'Humber Summit'), ('M1M', 'Scarborough', 'Cliffcrest'), ('M1M', 'Scarborough', 'Cliffside'), ('M1M', 'Scarborough', 'Scarborough Village West'), ('M2M', 'North York', 'Newtonbrook'), ('M2M', 'North York', 'Willowdale'), ('M3M', 'North York', 'Downsview Central'), ('M4M', 'East Toronto', 'Studio District'), ('M5M', 'North York', 'Bedford Park'), ('M5M', 'North York', 'Lawrence Manor East'), ('M6M', 'York', 'Del Ray'), ('M6M', 'York', 'Keelesdale'), ('M6M', 'York', 'Mount Dennis'), ('M6M', 'York', 'Silverthorn'), ('M7M', 'Not assigned', 'Not assigned'), ('M8M', 'Not assigned', 'Not assigned'), ('M9M', 'North York', 'Emery'), ('M9M', 'North York', 'Humberlea'), ('M1N', 'Scarborough', 'Birch Cliff'), ('M1N', 'Scarborough', 'Cliffside West'), ('M2N', 'North York', 'Willowdale South'), ('M3N', 'North York', 'Downsview Northwest'), ('M4N', 'Central Toronto', 'Lawrence Park'), ('M5N', 'Central Toronto', 'Roselawn'), ('M6N', 'York', 'The Junction North'), ('M6N', 'York', 'Runnymede'), ('M7N', 'Not assigned', 'Not assigned'), ('M8N', 'Not assigned', 'Not assigned'), ('M9N', 'York', 'Weston'), ('M1P', 'Scarborough', 'Dorset Park'), ('M1P', 'Scarborough', 'Scarborough Town Centre'), ('M1P', 'Scarborough', 'Wexford Heights'), ('M2P', 'North York', 'York Mills West'), ('M3P', 'Not assigned', 'Not assigned'), ('M4P', 'Central Toronto', 'Davisville North'), ('M5P', 'Central Toronto', 'Forest Hill North'), ('M5P', 'Central Toronto', 'Forest Hill West'), ('M6P', 'West Toronto', 'High Park'), ('M6P', 'West Toronto', 'The Junction South'), ('M7P', 'Not assigned', 'Not assigned'), ('M8P', 'Not assigned', 'Not assigned'), ('M9P', 'Etobicoke', 'Westmount'), ('M1R', 'Scarborough', 'Maryvale'), ('M1R', 'Scarborough', 'Wexford'), ('M2R', 'North York', 'Willowdale West'), ('M3R', 'Not assigned', 'Not assigned'), ('M4R', 'Central Toronto', 'North Toronto West'), ('M5R', 'Central Toronto', 'The Annex'), ('M5R', 'Central Toronto', 'North Midtown'), ('M5R', 'Central Toronto', 'Yorkville'), ('M6R', 'West Toronto', 'Parkdale'), ('M6R', 'West Toronto', 'Roncesvalles'), ('M7R', 'Mississauga', 'Canada Post Gateway Processing Centre'), ('M8R', 'Not assigned', 'Not assigned'), ('M9R', 'Etobicoke', 'Kingsview Village'), ('M9R', 'Etobicoke', 'Martin Grove Gardens'), ('M9R', 'Etobicoke', 'Richview Gardens'), ('M9R', 'Etobicoke', 'St. Phillips'), ('M1S', 'Scarborough', 'Agincourt'), ('M2S', 'Not assigned', 'Not assigned'), ('M3S', 'Not assigned', 'Not assigned'), ('M4S', 'Central Toronto', 'Davisville'), ('M5S', 'Downtown Toronto', 'Harbord'), ('M5S', 'Downtown Toronto', 'University of Toronto'), ('M6S', 'West Toronto', 'Runnymede'), ('M6S', 'West Toronto', 'Swansea'), ('M7S', 'Not assigned', 'Not assigned'), ('M8S', 'Not assigned', 'Not assigned'), ('M9S', 'Not assigned', 'Not assigned'), ('M1T', 'Scarborough', 'Clarks Corners'), ('M1T', 'Scarborough', 'Sullivan'), ('M1T', 'Scarborough', \"Tam O'Shanter\"), ('M2T', 'Not assigned', 'Not assigned'), ('M3T', 'Not assigned', 'Not assigned'), ('M4T', 'Central Toronto', 'Moore Park'), ('M4T', 'Central Toronto', 'Summerhill East'), ('M5T', 'Downtown Toronto', 'Chinatown'), ('M5T', 'Downtown Toronto', 'Grange Park'), ('M5T', 'Downtown Toronto', 'Kensington Market'), ('M6T', 'Not assigned', 'Not assigned'), ('M7T', 'Not assigned', 'Not assigned'), ('M8T', 'Not assigned', 'Not assigned'), ('M9T', 'Not assigned', 'Not assigned'), ('M1V', 'Scarborough', 'Agincourt North'), ('M1V', 'Scarborough', \"L'Amoreaux East\"), ('M1V', 'Scarborough', 'Milliken'), ('M1V', 'Scarborough', 'Steeles East'), ('M2V', 'Not assigned', 'Not assigned'), ('M3V', 'Not assigned', 'Not assigned'), ('M4V', 'Central Toronto', 'Deer Park'), ('M4V', 'Central Toronto', 'Forest Hill SE'), ('M4V', 'Central Toronto', 'Rathnelly'), ('M4V', 'Central Toronto', 'South Hill'), ('M4V', 'Central Toronto', 'Summerhill West'), ('M5V', 'Downtown Toronto', 'CN Tower'), ('M5V', 'Downtown Toronto', 'Bathurst Quay'), ('M5V', 'Downtown Toronto', 'Island airport'), ('M5V', 'Downtown Toronto', 'Harbourfront West'), ('M5V', 'Downtown Toronto', 'King and Spadina'), ('M5V', 'Downtown Toronto', 'Railway Lands'), ('M5V', 'Downtown Toronto', 'South Niagara'), ('M6V', 'Not assigned', 'Not assigned'), ('M7V', 'Not assigned', 'Not assigned'), ('M8V', 'Etobicoke', 'Humber Bay Shores'), ('M8V', 'Etobicoke', 'Mimico South'), ('M8V', 'Etobicoke', 'New Toronto'), ('M9V', 'Etobicoke', 'Albion Gardens'), ('M9V', 'Etobicoke', 'Beaumond Heights'), ('M9V', 'Etobicoke', 'Humbergate'), ('M9V', 'Etobicoke', 'Jamestown'), ('M9V', 'Etobicoke', 'Mount Olive'), ('M9V', 'Etobicoke', 'Silverstone'), ('M9V', 'Etobicoke', 'South Steeles'), ('M9V', 'Etobicoke', 'Thistletown'), ('M1W', 'Scarborough', \"L'Amoreaux West\"), ('M2W', 'Not assigned', 'Not assigned'), ('M3W', 'Not assigned', 'Not assigned'), ('M4W', 'Downtown Toronto', 'Rosedale'), ('M5W', 'Downtown Toronto', 'Stn A PO Boxes 25 The Esplanade'), ('M6W', 'Not assigned', 'Not assigned'), ('M7W', 'Not assigned', 'Not assigned'), ('M8W', 'Etobicoke', 'Alderwood'), ('M8W', 'Etobicoke', 'Long Branch'), ('M9W', 'Etobicoke', 'Northwest'), ('M1X', 'Scarborough', 'Upper Rouge'), ('M2X', 'Not assigned', 'Not assigned'), ('M3X', 'Not assigned', 'Not assigned'), ('M4X', 'Downtown Toronto', 'Cabbagetown'), ('M4X', 'Downtown Toronto', 'St. James Town'), ('M5X', 'Downtown Toronto', 'First Canadian Place'), ('M5X', 'Downtown Toronto', 'Underground city'), ('M6X', 'Not assigned', 'Not assigned'), ('M7X', 'Not assigned', 'Not assigned'), ('M8X', 'Etobicoke', 'The Kingsway'), ('M8X', 'Etobicoke', 'Montgomery Road'), ('M8X', 'Etobicoke', 'Old Mill North'), ('M9X', 'Not assigned', 'Not assigned'), ('M1Y', 'Not assigned', 'Not assigned'), ('M2Y', 'Not assigned', 'Not assigned'), ('M3Y', 'Not assigned', 'Not assigned'), ('M4Y', 'Downtown Toronto', 'Church and Wellesley'), ('M5Y', 'Not assigned', 'Not assigned'), ('M6Y', 'Not assigned', 'Not assigned'), ('M7Y', 'East Toronto', 'Business Reply Mail Processing Centre 969 Eastern'), ('M8Y', 'Etobicoke', 'Humber Bay'), ('M8Y', 'Etobicoke', \"King's Mill Park\"), ('M8Y', 'Etobicoke', 'Kingsway Park South East'), ('M8Y', 'Etobicoke', 'Mimico NE'), ('M8Y', 'Etobicoke', 'Old Mill South'), ('M8Y', 'Etobicoke', 'The Queensway East'), ('M8Y', 'Etobicoke', 'Royal York South East'), ('M8Y', 'Etobicoke', 'Sunnylea'), ('M9Y', 'Not assigned', 'Not assigned'), ('M1Z', 'Not assigned', 'Not assigned'), ('M2Z', 'Not assigned', 'Not assigned'), ('M3Z', 'Not assigned', 'Not assigned'), ('M4Z', 'Not assigned', 'Not assigned'), ('M5Z', 'Not assigned', 'Not assigned'), ('M6Z', 'Not assigned', 'Not assigned'), ('M7Z', 'Not assigned', 'Not assigned'), ('M8Z', 'Etobicoke', 'Kingsway Park South West'), ('M8Z', 'Etobicoke', 'Mimico NW'), ('M8Z', 'Etobicoke', 'The Queensway West'), ('M8Z', 'Etobicoke', 'Royal York South West'), ('M8Z', 'Etobicoke', 'South of Bloor'), ('M9Z', 'Not assigned', 'Not assigned')], 'table1': [('',)], 'table2': [('Canadian postal codes', '', ''), ('NL\\n\\nNS\\n\\nPE\\n\\nNB\\n\\nQC\\n\\nON\\n\\nMB\\n\\nSK\\n\\nAB\\n\\nBC\\n\\nNU/NT\\n\\nYT\\n\\n\\nA\\n\\nB\\n\\nC\\n\\nE\\n\\nG\\n\\nH\\n\\nJ\\n\\nK\\n\\nL\\n\\nM\\n\\nN\\n\\nP\\n\\nR\\n\\nS\\n\\nT\\n\\nV\\n\\nX\\n\\nY', 'NL', 'NS', 'PE', 'NB', 'QC', 'ON', 'MB', 'SK', 'AB', 'BC', 'NU/NT', 'YT', 'A', 'B', 'C', 'E', 'G', 'H', 'J', 'K', 'L', 'M', 'N', 'P', 'R', 'S', 'T', 'V', 'X', 'Y'), ('NL', 'NS', 'PE', 'NB', 'QC', 'ON', 'MB', 'SK', 'AB', 'BC', 'NU/NT', 'YT'), ('A', 'B', 'C', 'E', 'G', 'H', 'J', 'K', 'L', 'M', 'N', 'P', 'R', 'S', 'T', 'V', 'X', 'Y')], 'table3': [('NL', 'NS', 'PE', 'NB', 'QC', 'ON', 'MB', 'SK', 'AB', 'BC', 'NU/NT', 'YT'), ('A', 'B', 'C', 'E', 'G', 'H', 'J', 'K', 'L', 'M', 'N', 'P', 'R', 'S', 'T', 'V', 'X', 'Y')]}\n"
     ]
    }
   ],
   "source": [
    "from bs4 import BeautifulSoup\n",
    "\n",
    "import requests\n",
    "\n",
    "page = requests.get(\"https://en.wikipedia.org/wiki/List_of_postal_codes_of_Canada:_M\")\n",
    "soup = BeautifulSoup(page.content, 'html.parser')\n",
    "dados = {}\n",
    "for k, body in enumerate(soup.findAll('tbody')):\n",
    "    dados['table' + str(k)] = []\n",
    "    for tr in body.find_all('tr'):\n",
    "        tmp = tuple()\n",
    "        th = tr.find('th')\n",
    "        if th:\n",
    "            th = tr.find('th').text.strip()\n",
    "            tmp += (th,)\n",
    "        for td in tr.find_all('td'):\n",
    "            tmp += (td.text.strip(),)\n",
    "        dados['table' + str(k)].append(tmp)\n",
    "print(dados)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "289"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "table = dados['table0']  \n",
    "len(table)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [],
   "source": [
    "# define the dataframe columns\n",
    "column_names = ['Postcode', 'Borough', 'Neighbourhood'] \n",
    "\n",
    "# instantiate the dataframe\n",
    "df_coloumns = pd.DataFrame(columns=column_names)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_coloumns\n",
    "postcode = []\n",
    "borough = []\n",
    "neighbourhood = []"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [],
   "source": [
    "for ls in table:\n",
    "    postcode.append(ls)\n",
    "        "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [],
   "source": [
    "postcode1 = postcode[1:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [],
   "source": [
    "tb1 = []\n",
    "tb2 = []\n",
    "tb3 = []\n",
    "\n",
    "for el1,el2,el3 in postcode1:\n",
    "    tb1.append(el1)\n",
    "    tb2.append(el2)\n",
    "    tb3.append(el3)\n",
    "    \n",
    "    \n",
    "        "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "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>Postcode</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>283</th>\n",
       "      <td>M8Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284</th>\n",
       "      <td>M8Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>285</th>\n",
       "      <td>M8Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>286</th>\n",
       "      <td>M8Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>287</th>\n",
       "      <td>M9Z</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Postcode\n",
       "283      M8Z\n",
       "284      M8Z\n",
       "285      M8Z\n",
       "286      M8Z\n",
       "287      M9Z"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.DataFrame(np.array([tb1]).T)\n",
    "df.columns =['Postcode']\n",
    "df.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['Borough'] = tb2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['Neighbourhood'] = tb3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [
    {
     "ename": "TypeError",
     "evalue": "'Series' objects are mutable, thus they cannot be hashed",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mTypeError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-53-7ebc960ce6e6>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mdf\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0msort_index\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mdf\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'Postcode'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[0;32m/opt/conda/envs/Python36/lib/python3.6/site-packages/pandas/core/frame.py\u001b[0m in \u001b[0;36msort_index\u001b[0;34m(self, axis, level, ascending, inplace, kind, na_position, sort_remaining, by)\u001b[0m\n\u001b[1;32m   4754\u001b[0m                                     inplace=inplace)\n\u001b[1;32m   4755\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 4756\u001b[0;31m         \u001b[0maxis\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_get_axis_number\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0maxis\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   4757\u001b[0m         \u001b[0mlabels\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_get_axis\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0maxis\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   4758\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/opt/conda/envs/Python36/lib/python3.6/site-packages/pandas/core/generic.py\u001b[0m in \u001b[0;36m_get_axis_number\u001b[0;34m(cls, axis)\u001b[0m\n\u001b[1;32m    349\u001b[0m     \u001b[0;34m@\u001b[0m\u001b[0mclassmethod\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    350\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0m_get_axis_number\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mcls\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0maxis\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 351\u001b[0;31m         \u001b[0maxis\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mcls\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_AXIS_ALIASES\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0maxis\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0maxis\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    352\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0mis_integer\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0maxis\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    353\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0maxis\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mcls\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_AXIS_NAMES\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/opt/conda/envs/Python36/lib/python3.6/site-packages/pandas/core/generic.py\u001b[0m in \u001b[0;36m__hash__\u001b[0;34m(self)\u001b[0m\n\u001b[1;32m   1815\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0m__hash__\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1816\u001b[0m         raise TypeError('{0!r} objects are mutable, thus they cannot be'\n\u001b[0;32m-> 1817\u001b[0;31m                         ' hashed'.format(self.__class__.__name__))\n\u001b[0m\u001b[1;32m   1818\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1819\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0m__iter__\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mTypeError\u001b[0m: 'Series' objects are mutable, thus they cannot be hashed"
     ]
    }
   ],
   "source": [
    "df.sort_index(df['Postcode'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "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>Postcode</th>\n",
       "      <th>Borough</th>\n",
       "      <th>Neighbourhood</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>M1A</td>\n",
       "      <td>Not assigned</td>\n",
       "      <td>Not assigned</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>M1B</td>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Malvern</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>M1B</td>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Rouge</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>M1C</td>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Highland Creek</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>M1C</td>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Rouge Hill</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Postcode       Borough   Neighbourhood\n",
       "0       M1A  Not assigned    Not assigned\n",
       "12      M1B   Scarborough         Malvern\n",
       "11      M1B   Scarborough           Rouge\n",
       "27      M1C   Scarborough  Highland Creek\n",
       "28      M1C   Scarborough      Rouge Hill"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.sort_values(['Postcode'], ascending=[True]).head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['Borough'].replace('Not assigned',np.NaN,inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "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>Postcode</th>\n",
       "      <th>Borough</th>\n",
       "      <th>Neighbourhood</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>M1A</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Not assigned</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>M2A</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Not assigned</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>M3A</td>\n",
       "      <td>North York</td>\n",
       "      <td>Parkwoods</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>M4A</td>\n",
       "      <td>North York</td>\n",
       "      <td>Victoria Village</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>M5A</td>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>Harbourfront</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Postcode           Borough     Neighbourhood\n",
       "0      M1A               NaN      Not assigned\n",
       "1      M2A               NaN      Not assigned\n",
       "2      M3A        North York         Parkwoods\n",
       "3      M4A        North York  Victoria Village\n",
       "4      M5A  Downtown Toronto      Harbourfront"
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.dropna(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [],
   "source": [
    "Neigh = df['Neighbourhood']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [],
   "source": [
    "Neigh[8] = \"Queen's Park\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2           Parkwoods\n",
       "3    Victoria Village\n",
       "4        Harbourfront\n",
       "5         Regent Park\n",
       "6    Lawrence Heights\n",
       "Name: Neighbourhood, dtype: object"
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Neigh.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "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>Postcode</th>\n",
       "      <th>Borough</th>\n",
       "      <th>Neighbourhood</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>M3A</td>\n",
       "      <td>North York</td>\n",
       "      <td>Parkwoods</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>M4A</td>\n",
       "      <td>North York</td>\n",
       "      <td>Victoria Village</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>M5A</td>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>Harbourfront</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>M5A</td>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>Regent Park</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>M6A</td>\n",
       "      <td>North York</td>\n",
       "      <td>Lawrence Heights</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>M6A</td>\n",
       "      <td>North York</td>\n",
       "      <td>Lawrence Manor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>M7A</td>\n",
       "      <td>Queen's Park</td>\n",
       "      <td>Queen's Park</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>M9A</td>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>Islington Avenue</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>M1B</td>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Rouge</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>M1B</td>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Malvern</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>M3B</td>\n",
       "      <td>North York</td>\n",
       "      <td>Don Mills North</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>M4B</td>\n",
       "      <td>East York</td>\n",
       "      <td>Woodbine Gardens</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>M4B</td>\n",
       "      <td>East York</td>\n",
       "      <td>Parkview Hill</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>M5B</td>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>Ryerson</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>M5B</td>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>Garden District</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>M6B</td>\n",
       "      <td>North York</td>\n",
       "      <td>Glencairn</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>M9B</td>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>Cloverdale</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>M9B</td>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>Islington</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>M9B</td>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>Martin Grove</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>M9B</td>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>Princess Gardens</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>M9B</td>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>West Deane Park</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>M1C</td>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Highland Creek</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>M1C</td>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Rouge Hill</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>M1C</td>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Port Union</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>M3C</td>\n",
       "      <td>North York</td>\n",
       "      <td>Flemingdon Park</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>M3C</td>\n",
       "      <td>North York</td>\n",
       "      <td>Don Mills South</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>M4C</td>\n",
       "      <td>East York</td>\n",
       "      <td>Woodbine Heights</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>M5C</td>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>St. James Town</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>M6C</td>\n",
       "      <td>York</td>\n",
       "      <td>Humewood-Cedarvale</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>M9C</td>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>Bloordale Gardens</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>235</th>\n",
       "      <td>M9V</td>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>Thistletown</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>236</th>\n",
       "      <td>M1W</td>\n",
       "      <td>Scarborough</td>\n",
       "      <td>L'Amoreaux West</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239</th>\n",
       "      <td>M4W</td>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>Rosedale</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>240</th>\n",
       "      <td>M5W</td>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>Stn A PO Boxes 25 The Esplanade</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243</th>\n",
       "      <td>M8W</td>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>Alderwood</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>244</th>\n",
       "      <td>M8W</td>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>Long Branch</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>245</th>\n",
       "      <td>M9W</td>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>Northwest</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>246</th>\n",
       "      <td>M1X</td>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Upper Rouge</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>249</th>\n",
       "      <td>M4X</td>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>Cabbagetown</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>250</th>\n",
       "      <td>M4X</td>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>St. James Town</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>251</th>\n",
       "      <td>M5X</td>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>First Canadian Place</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>252</th>\n",
       "      <td>M5X</td>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>Underground city</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>255</th>\n",
       "      <td>M8X</td>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>The Kingsway</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256</th>\n",
       "      <td>M8X</td>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>Montgomery Road</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>257</th>\n",
       "      <td>M8X</td>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>Old Mill North</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>262</th>\n",
       "      <td>M4Y</td>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>Church and Wellesley</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>265</th>\n",
       "      <td>M7Y</td>\n",
       "      <td>East Toronto</td>\n",
       "      <td>Business Reply Mail Processing Centre 969 Eastern</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>266</th>\n",
       "      <td>M8Y</td>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>Humber Bay</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>267</th>\n",
       "      <td>M8Y</td>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>King's Mill Park</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>268</th>\n",
       "      <td>M8Y</td>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>Kingsway Park South East</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>269</th>\n",
       "      <td>M8Y</td>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>Mimico NE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>270</th>\n",
       "      <td>M8Y</td>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>Old Mill South</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271</th>\n",
       "      <td>M8Y</td>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>The Queensway East</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272</th>\n",
       "      <td>M8Y</td>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>Royal York South East</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>273</th>\n",
       "      <td>M8Y</td>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>Sunnylea</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282</th>\n",
       "      <td>M8Z</td>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>Kingsway Park South West</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>283</th>\n",
       "      <td>M8Z</td>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>Mimico NW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284</th>\n",
       "      <td>M8Z</td>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>The Queensway West</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>285</th>\n",
       "      <td>M8Z</td>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>Royal York South West</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>286</th>\n",
       "      <td>M8Z</td>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>South of Bloor</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>211 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Postcode           Borough  \\\n",
       "2        M3A        North York   \n",
       "3        M4A        North York   \n",
       "4        M5A  Downtown Toronto   \n",
       "5        M5A  Downtown Toronto   \n",
       "6        M6A        North York   \n",
       "7        M6A        North York   \n",
       "8        M7A      Queen's Park   \n",
       "10       M9A         Etobicoke   \n",
       "11       M1B       Scarborough   \n",
       "12       M1B       Scarborough   \n",
       "14       M3B        North York   \n",
       "15       M4B         East York   \n",
       "16       M4B         East York   \n",
       "17       M5B  Downtown Toronto   \n",
       "18       M5B  Downtown Toronto   \n",
       "19       M6B        North York   \n",
       "22       M9B         Etobicoke   \n",
       "23       M9B         Etobicoke   \n",
       "24       M9B         Etobicoke   \n",
       "25       M9B         Etobicoke   \n",
       "26       M9B         Etobicoke   \n",
       "27       M1C       Scarborough   \n",
       "28       M1C       Scarborough   \n",
       "29       M1C       Scarborough   \n",
       "31       M3C        North York   \n",
       "32       M3C        North York   \n",
       "33       M4C         East York   \n",
       "34       M5C  Downtown Toronto   \n",
       "35       M6C              York   \n",
       "38       M9C         Etobicoke   \n",
       "..       ...               ...   \n",
       "235      M9V         Etobicoke   \n",
       "236      M1W       Scarborough   \n",
       "239      M4W  Downtown Toronto   \n",
       "240      M5W  Downtown Toronto   \n",
       "243      M8W         Etobicoke   \n",
       "244      M8W         Etobicoke   \n",
       "245      M9W         Etobicoke   \n",
       "246      M1X       Scarborough   \n",
       "249      M4X  Downtown Toronto   \n",
       "250      M4X  Downtown Toronto   \n",
       "251      M5X  Downtown Toronto   \n",
       "252      M5X  Downtown Toronto   \n",
       "255      M8X         Etobicoke   \n",
       "256      M8X         Etobicoke   \n",
       "257      M8X         Etobicoke   \n",
       "262      M4Y  Downtown Toronto   \n",
       "265      M7Y      East Toronto   \n",
       "266      M8Y         Etobicoke   \n",
       "267      M8Y         Etobicoke   \n",
       "268      M8Y         Etobicoke   \n",
       "269      M8Y         Etobicoke   \n",
       "270      M8Y         Etobicoke   \n",
       "271      M8Y         Etobicoke   \n",
       "272      M8Y         Etobicoke   \n",
       "273      M8Y         Etobicoke   \n",
       "282      M8Z         Etobicoke   \n",
       "283      M8Z         Etobicoke   \n",
       "284      M8Z         Etobicoke   \n",
       "285      M8Z         Etobicoke   \n",
       "286      M8Z         Etobicoke   \n",
       "\n",
       "                                         Neighbourhood  \n",
       "2                                            Parkwoods  \n",
       "3                                     Victoria Village  \n",
       "4                                         Harbourfront  \n",
       "5                                          Regent Park  \n",
       "6                                     Lawrence Heights  \n",
       "7                                       Lawrence Manor  \n",
       "8                                         Queen's Park  \n",
       "10                                    Islington Avenue  \n",
       "11                                               Rouge  \n",
       "12                                             Malvern  \n",
       "14                                     Don Mills North  \n",
       "15                                    Woodbine Gardens  \n",
       "16                                       Parkview Hill  \n",
       "17                                             Ryerson  \n",
       "18                                     Garden District  \n",
       "19                                           Glencairn  \n",
       "22                                          Cloverdale  \n",
       "23                                           Islington  \n",
       "24                                        Martin Grove  \n",
       "25                                    Princess Gardens  \n",
       "26                                     West Deane Park  \n",
       "27                                      Highland Creek  \n",
       "28                                          Rouge Hill  \n",
       "29                                          Port Union  \n",
       "31                                     Flemingdon Park  \n",
       "32                                     Don Mills South  \n",
       "33                                    Woodbine Heights  \n",
       "34                                      St. James Town  \n",
       "35                                  Humewood-Cedarvale  \n",
       "38                                   Bloordale Gardens  \n",
       "..                                                 ...  \n",
       "235                                        Thistletown  \n",
       "236                                    L'Amoreaux West  \n",
       "239                                           Rosedale  \n",
       "240                    Stn A PO Boxes 25 The Esplanade  \n",
       "243                                          Alderwood  \n",
       "244                                        Long Branch  \n",
       "245                                          Northwest  \n",
       "246                                        Upper Rouge  \n",
       "249                                        Cabbagetown  \n",
       "250                                     St. James Town  \n",
       "251                               First Canadian Place  \n",
       "252                                   Underground city  \n",
       "255                                       The Kingsway  \n",
       "256                                    Montgomery Road  \n",
       "257                                     Old Mill North  \n",
       "262                               Church and Wellesley  \n",
       "265  Business Reply Mail Processing Centre 969 Eastern  \n",
       "266                                         Humber Bay  \n",
       "267                                   King's Mill Park  \n",
       "268                           Kingsway Park South East  \n",
       "269                                          Mimico NE  \n",
       "270                                     Old Mill South  \n",
       "271                                 The Queensway East  \n",
       "272                              Royal York South East  \n",
       "273                                           Sunnylea  \n",
       "282                           Kingsway Park South West  \n",
       "283                                          Mimico NW  \n",
       "284                                 The Queensway West  \n",
       "285                              Royal York South West  \n",
       "286                                     South of Bloor  \n",
       "\n",
       "[211 rows x 3 columns]"
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = df.reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {},
   "outputs": [],
   "source": [
    "years_dict = dict()\n",
    "for i in range(len(df)):\n",
    "    if df.loc[i,\"Postcode\"] in years_dict:\n",
    "        years_dict[df.loc[i,'Postcode']].append(df.loc[i,'Neighbourhood'])\n",
    "    else:\n",
    "        years_dict[df.loc[i,'Postcode']] = [df.loc[i,'Neighbourhood']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "metadata": {},
   "outputs": [],
   "source": [
    "tb4 = []\n",
    "tb5 = []\n",
    "for k,v in years_dict.items():\n",
    "    tb4.append(k)\n",
    "    tb5.append(v)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {},
   "outputs": [],
   "source": [
    "tb6 = []\n",
    "s=''\n",
    "c=0\n",
    "for i in tb5:\n",
    "    l_n = len(i)\n",
    "    if l_n >1:\n",
    "        for j in i:\n",
    "            c+=1\n",
    "            if l_n == c:\n",
    "                s+=j\n",
    "            else:\n",
    "                s+=j+','\n",
    "        tb6.append(s)\n",
    "        s=''\n",
    "        c=0\n",
    "    else:\n",
    "        tb6.append(i[0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "metadata": {},
   "outputs": [],
   "source": [
    "sec_col = {}\n",
    "for i in range(len(df)):\n",
    "    if df.loc[i,\"Postcode\"] in sec_col:\n",
    "        continue\n",
    "    else:\n",
    "        sec_col[df.loc[i,'Postcode']] = df.loc[i,'Borough']\n",
    "        "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "tb7 = []\n",
    "for k,v in sec_col.items():\n",
    "    tb7.append(v)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "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>Postcode</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>M3A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>M4A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>M5A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>M6A</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>M7A</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Postcode\n",
       "0      M3A\n",
       "1      M4A\n",
       "2      M5A\n",
       "3      M6A\n",
       "4      M7A"
      ]
     },
     "execution_count": 68,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_df = pd.DataFrame({'Postcode':tb4})\n",
    "final_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "metadata": {},
   "outputs": [],
   "source": [
    "final_df['Borough'] = tb7"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "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>Postcode</th>\n",
       "      <th>Borough</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>M3A</td>\n",
       "      <td>North York</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>M4A</td>\n",
       "      <td>North York</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>M5A</td>\n",
       "      <td>Downtown Toronto</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>M6A</td>\n",
       "      <td>North York</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>M7A</td>\n",
       "      <td>Queen's Park</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Postcode           Borough\n",
       "0      M3A        North York\n",
       "1      M4A        North York\n",
       "2      M5A  Downtown Toronto\n",
       "3      M6A        North York\n",
       "4      M7A      Queen's Park"
      ]
     },
     "execution_count": 70,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "metadata": {},
   "outputs": [],
   "source": [
    "final_df['Neighbourhood'] = tb6"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "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>Postcode</th>\n",
       "      <th>Borough</th>\n",
       "      <th>Neighbourhood</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>M3A</td>\n",
       "      <td>North York</td>\n",
       "      <td>Parkwoods</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>M4A</td>\n",
       "      <td>North York</td>\n",
       "      <td>Victoria Village</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>M5A</td>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>Harbourfront,Regent Park</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>M6A</td>\n",
       "      <td>North York</td>\n",
       "      <td>Lawrence Heights,Lawrence Manor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>M7A</td>\n",
       "      <td>Queen's Park</td>\n",
       "      <td>Queen's Park</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>M9A</td>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>Islington Avenue</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>M1B</td>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Rouge,Malvern</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>M3B</td>\n",
       "      <td>North York</td>\n",
       "      <td>Don Mills North</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>M4B</td>\n",
       "      <td>East York</td>\n",
       "      <td>Woodbine Gardens,Parkview Hill</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>M5B</td>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>Ryerson,Garden District</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>M6B</td>\n",
       "      <td>North York</td>\n",
       "      <td>Glencairn</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>M9B</td>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>Cloverdale,Islington,Martin Grove,Princess Gar...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>M1C</td>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Highland Creek,Rouge Hill,Port Union</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>M3C</td>\n",
       "      <td>North York</td>\n",
       "      <td>Flemingdon Park,Don Mills South</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>M4C</td>\n",
       "      <td>East York</td>\n",
       "      <td>Woodbine Heights</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>M5C</td>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>St. James Town</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>M6C</td>\n",
       "      <td>York</td>\n",
       "      <td>Humewood-Cedarvale</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>M9C</td>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>Bloordale Gardens,Eringate,Markland Wood,Old B...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>M1E</td>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Guildwood,Morningside,West Hill</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>M4E</td>\n",
       "      <td>East Toronto</td>\n",
       "      <td>The Beaches</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>M5E</td>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>Berczy Park</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>M6E</td>\n",
       "      <td>York</td>\n",
       "      <td>Caledonia-Fairbanks</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>M1G</td>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Woburn</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>M4G</td>\n",
       "      <td>East York</td>\n",
       "      <td>Leaside</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>M5G</td>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>Central Bay Street</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>M6G</td>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>Christie</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>M1H</td>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Cedarbrae</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>M2H</td>\n",
       "      <td>North York</td>\n",
       "      <td>Hillcrest Village</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>M3H</td>\n",
       "      <td>North York</td>\n",
       "      <td>Bathurst Manor,Downsview North,Wilson Heights</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>M4H</td>\n",
       "      <td>East York</td>\n",
       "      <td>Thorncliffe Park</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>M4R</td>\n",
       "      <td>Central Toronto</td>\n",
       "      <td>North Toronto West</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>M5R</td>\n",
       "      <td>Central Toronto</td>\n",
       "      <td>The Annex,North Midtown,Yorkville</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>M6R</td>\n",
       "      <td>West Toronto</td>\n",
       "      <td>Parkdale,Roncesvalles</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>M7R</td>\n",
       "      <td>Mississauga</td>\n",
       "      <td>Canada Post Gateway Processing Centre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>M9R</td>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>Kingsview Village,Martin Grove Gardens,Richvie...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>M1S</td>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Agincourt</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>M4S</td>\n",
       "      <td>Central Toronto</td>\n",
       "      <td>Davisville</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>M5S</td>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>Harbord,University of Toronto</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>M6S</td>\n",
       "      <td>West Toronto</td>\n",
       "      <td>Runnymede,Swansea</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>M1T</td>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Clarks Corners,Sullivan,Tam O'Shanter</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>M4T</td>\n",
       "      <td>Central Toronto</td>\n",
       "      <td>Moore Park,Summerhill East</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>M5T</td>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>Chinatown,Grange Park,Kensington Market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>M1V</td>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Agincourt North,L'Amoreaux East,Milliken,Steel...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>M4V</td>\n",
       "      <td>Central Toronto</td>\n",
       "      <td>Deer Park,Forest Hill SE,Rathnelly,South Hill,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>M5V</td>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>CN Tower,Bathurst Quay,Island airport,Harbourf...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>M8V</td>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>Humber Bay Shores,Mimico South,New Toronto</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>M9V</td>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>Albion Gardens,Beaumond Heights,Humbergate,Jam...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>M1W</td>\n",
       "      <td>Scarborough</td>\n",
       "      <td>L'Amoreaux West</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>M4W</td>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>Rosedale</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>M5W</td>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>Stn A PO Boxes 25 The Esplanade</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>M8W</td>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>Alderwood,Long Branch</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>M9W</td>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>Northwest</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>M1X</td>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Upper Rouge</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>M4X</td>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>Cabbagetown,St. James Town</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>M5X</td>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>First Canadian Place,Underground city</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>M8X</td>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>The Kingsway,Montgomery Road,Old Mill North</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>M4Y</td>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>Church and Wellesley</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>M7Y</td>\n",
       "      <td>East Toronto</td>\n",
       "      <td>Business Reply Mail Processing Centre 969 Eastern</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>M8Y</td>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>Humber Bay,King's Mill Park,Kingsway Park Sout...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>M8Z</td>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>Kingsway Park South West,Mimico NW,The Queensw...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>103 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Postcode           Borough  \\\n",
       "0        M3A        North York   \n",
       "1        M4A        North York   \n",
       "2        M5A  Downtown Toronto   \n",
       "3        M6A        North York   \n",
       "4        M7A      Queen's Park   \n",
       "5        M9A         Etobicoke   \n",
       "6        M1B       Scarborough   \n",
       "7        M3B        North York   \n",
       "8        M4B         East York   \n",
       "9        M5B  Downtown Toronto   \n",
       "10       M6B        North York   \n",
       "11       M9B         Etobicoke   \n",
       "12       M1C       Scarborough   \n",
       "13       M3C        North York   \n",
       "14       M4C         East York   \n",
       "15       M5C  Downtown Toronto   \n",
       "16       M6C              York   \n",
       "17       M9C         Etobicoke   \n",
       "18       M1E       Scarborough   \n",
       "19       M4E      East Toronto   \n",
       "20       M5E  Downtown Toronto   \n",
       "21       M6E              York   \n",
       "22       M1G       Scarborough   \n",
       "23       M4G         East York   \n",
       "24       M5G  Downtown Toronto   \n",
       "25       M6G  Downtown Toronto   \n",
       "26       M1H       Scarborough   \n",
       "27       M2H        North York   \n",
       "28       M3H        North York   \n",
       "29       M4H         East York   \n",
       "..       ...               ...   \n",
       "73       M4R   Central Toronto   \n",
       "74       M5R   Central Toronto   \n",
       "75       M6R      West Toronto   \n",
       "76       M7R       Mississauga   \n",
       "77       M9R         Etobicoke   \n",
       "78       M1S       Scarborough   \n",
       "79       M4S   Central Toronto   \n",
       "80       M5S  Downtown Toronto   \n",
       "81       M6S      West Toronto   \n",
       "82       M1T       Scarborough   \n",
       "83       M4T   Central Toronto   \n",
       "84       M5T  Downtown Toronto   \n",
       "85       M1V       Scarborough   \n",
       "86       M4V   Central Toronto   \n",
       "87       M5V  Downtown Toronto   \n",
       "88       M8V         Etobicoke   \n",
       "89       M9V         Etobicoke   \n",
       "90       M1W       Scarborough   \n",
       "91       M4W  Downtown Toronto   \n",
       "92       M5W  Downtown Toronto   \n",
       "93       M8W         Etobicoke   \n",
       "94       M9W         Etobicoke   \n",
       "95       M1X       Scarborough   \n",
       "96       M4X  Downtown Toronto   \n",
       "97       M5X  Downtown Toronto   \n",
       "98       M8X         Etobicoke   \n",
       "99       M4Y  Downtown Toronto   \n",
       "100      M7Y      East Toronto   \n",
       "101      M8Y         Etobicoke   \n",
       "102      M8Z         Etobicoke   \n",
       "\n",
       "                                         Neighbourhood  \n",
       "0                                            Parkwoods  \n",
       "1                                     Victoria Village  \n",
       "2                             Harbourfront,Regent Park  \n",
       "3                      Lawrence Heights,Lawrence Manor  \n",
       "4                                         Queen's Park  \n",
       "5                                     Islington Avenue  \n",
       "6                                        Rouge,Malvern  \n",
       "7                                      Don Mills North  \n",
       "8                       Woodbine Gardens,Parkview Hill  \n",
       "9                              Ryerson,Garden District  \n",
       "10                                           Glencairn  \n",
       "11   Cloverdale,Islington,Martin Grove,Princess Gar...  \n",
       "12                Highland Creek,Rouge Hill,Port Union  \n",
       "13                     Flemingdon Park,Don Mills South  \n",
       "14                                    Woodbine Heights  \n",
       "15                                      St. James Town  \n",
       "16                                  Humewood-Cedarvale  \n",
       "17   Bloordale Gardens,Eringate,Markland Wood,Old B...  \n",
       "18                     Guildwood,Morningside,West Hill  \n",
       "19                                         The Beaches  \n",
       "20                                         Berczy Park  \n",
       "21                                 Caledonia-Fairbanks  \n",
       "22                                              Woburn  \n",
       "23                                             Leaside  \n",
       "24                                  Central Bay Street  \n",
       "25                                            Christie  \n",
       "26                                           Cedarbrae  \n",
       "27                                   Hillcrest Village  \n",
       "28       Bathurst Manor,Downsview North,Wilson Heights  \n",
       "29                                    Thorncliffe Park  \n",
       "..                                                 ...  \n",
       "73                                  North Toronto West  \n",
       "74                   The Annex,North Midtown,Yorkville  \n",
       "75                               Parkdale,Roncesvalles  \n",
       "76               Canada Post Gateway Processing Centre  \n",
       "77   Kingsview Village,Martin Grove Gardens,Richvie...  \n",
       "78                                           Agincourt  \n",
       "79                                          Davisville  \n",
       "80                       Harbord,University of Toronto  \n",
       "81                                   Runnymede,Swansea  \n",
       "82               Clarks Corners,Sullivan,Tam O'Shanter  \n",
       "83                          Moore Park,Summerhill East  \n",
       "84             Chinatown,Grange Park,Kensington Market  \n",
       "85   Agincourt North,L'Amoreaux East,Milliken,Steel...  \n",
       "86   Deer Park,Forest Hill SE,Rathnelly,South Hill,...  \n",
       "87   CN Tower,Bathurst Quay,Island airport,Harbourf...  \n",
       "88          Humber Bay Shores,Mimico South,New Toronto  \n",
       "89   Albion Gardens,Beaumond Heights,Humbergate,Jam...  \n",
       "90                                     L'Amoreaux West  \n",
       "91                                            Rosedale  \n",
       "92                     Stn A PO Boxes 25 The Esplanade  \n",
       "93                               Alderwood,Long Branch  \n",
       "94                                           Northwest  \n",
       "95                                         Upper Rouge  \n",
       "96                          Cabbagetown,St. James Town  \n",
       "97               First Canadian Place,Underground city  \n",
       "98         The Kingsway,Montgomery Road,Old Mill North  \n",
       "99                                Church and Wellesley  \n",
       "100  Business Reply Mail Processing Centre 969 Eastern  \n",
       "101  Humber Bay,King's Mill Park,Kingsway Park Sout...  \n",
       "102  Kingsway Park South West,Mimico NW,The Queensw...  \n",
       "\n",
       "[103 rows x 3 columns]"
      ]
     },
     "execution_count": 72,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "# @hidden_cell\n",
    "# The following code contains the credentials for a file in your IBM Cloud Object Storage.\n",
    "# You might want to remove those credentials before you share your notebook.\n",
    "credentials_1 = {\n",
    "    'IAM_SERVICE_ID': 'iam-ServiceId-52f69326-138e-4250-ac76-335f1f5a8c7d',\n",
    "    'IBM_API_KEY_ID': '5WTeASmt5_GwRRhRibGVpJqvT-tGeb6LDnVgDDXFXCkF',\n",
    "    'ENDPOINT': 'https://s3.eu-geo.objectstorage.service.networklayer.com',\n",
    "    'IBM_AUTH_ENDPOINT': 'https://iam.eu-gb.bluemix.net/oidc/token',\n",
    "    'BUCKET': 'courseracapstoneproject-donotdelete-pr-lovoontba8n5gj',\n",
    "    'FILE': 'Geospatial_Coordinates.csv'\n",
    "}\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Postal Code</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>M1B</td>\n",
       "      <td>43.806686</td>\n",
       "      <td>-79.194353</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>M1C</td>\n",
       "      <td>43.784535</td>\n",
       "      <td>-79.160497</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>M1E</td>\n",
       "      <td>43.763573</td>\n",
       "      <td>-79.188711</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>M1G</td>\n",
       "      <td>43.770992</td>\n",
       "      <td>-79.216917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>M1H</td>\n",
       "      <td>43.773136</td>\n",
       "      <td>-79.239476</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Postal Code   Latitude  Longitude\n",
       "0         M1B  43.806686 -79.194353\n",
       "1         M1C  43.784535 -79.160497\n",
       "2         M1E  43.763573 -79.188711\n",
       "3         M1G  43.770992 -79.216917\n",
       "4         M1H  43.773136 -79.239476"
      ]
     },
     "execution_count": 74,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "import types\n",
    "import pandas as pd\n",
    "from botocore.client import Config\n",
    "import ibm_boto3\n",
    "\n",
    "def __iter__(self): return 0\n",
    "\n",
    "# @hidden_cell\n",
    "# The following code accesses a file in your IBM Cloud Object Storage. It includes your credentials.\n",
    "# You might want to remove those credentials before you share the notebook.\n",
    "client_0a7faf2d576d4d0e985305b42aae4ce7 = ibm_boto3.client(service_name='s3',\n",
    "    ibm_api_key_id='5WTeASmt5_GwRRhRibGVpJqvT-tGeb6LDnVgDDXFXCkF',\n",
    "    ibm_auth_endpoint=\"https://iam.eu-gb.bluemix.net/oidc/token\",\n",
    "    config=Config(signature_version='oauth'),\n",
    "    endpoint_url='https://s3.eu-geo.objectstorage.service.networklayer.com')\n",
    "\n",
    "body = client_0a7faf2d576d4d0e985305b42aae4ce7.get_object(Bucket='courseracapstoneproject-donotdelete-pr-lovoontba8n5gj',Key='Geospatial_Coordinates.csv')['Body']\n",
    "# add missing __iter__ method, so pandas accepts body as file-like object\n",
    "if not hasattr(body, \"__iter__\"): body.__iter__ = types.MethodType( __iter__, body )\n",
    "\n",
    "df_data = pd.read_csv(body)\n",
    "df_data.head()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "# @hidden_cell\n",
    "# The following code contains the credentials for a file in your IBM Cloud Object Storage.\n",
    "# You might want to remove those credentials before you share your notebook.\n",
    "credentials_2 = {\n",
    "    'IAM_SERVICE_ID': 'iam-ServiceId-52f69326-138e-4250-ac76-335f1f5a8c7d',\n",
    "    'IBM_API_KEY_ID': '5WTeASmt5_GwRRhRibGVpJqvT-tGeb6LDnVgDDXFXCkF',\n",
    "    'ENDPOINT': 'https://s3.eu-geo.objectstorage.service.networklayer.com',\n",
    "    'IBM_AUTH_ENDPOINT': 'https://iam.eu-gb.bluemix.net/oidc/token',\n",
    "    'BUCKET': 'courseracapstoneproject-donotdelete-pr-lovoontba8n5gj',\n",
    "    'FILE': 'Geospatial_Coordinates.csv'\n",
    "}\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Postal Code</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>M1B</td>\n",
       "      <td>43.806686</td>\n",
       "      <td>-79.194353</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>M1C</td>\n",
       "      <td>43.784535</td>\n",
       "      <td>-79.160497</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>M1E</td>\n",
       "      <td>43.763573</td>\n",
       "      <td>-79.188711</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>M1G</td>\n",
       "      <td>43.770992</td>\n",
       "      <td>-79.216917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>M1H</td>\n",
       "      <td>43.773136</td>\n",
       "      <td>-79.239476</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Postal Code   Latitude  Longitude\n",
       "0         M1B  43.806686 -79.194353\n",
       "1         M1C  43.784535 -79.160497\n",
       "2         M1E  43.763573 -79.188711\n",
       "3         M1G  43.770992 -79.216917\n",
       "4         M1H  43.773136 -79.239476"
      ]
     },
     "execution_count": 76,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "body = client_0a7faf2d576d4d0e985305b42aae4ce7.get_object(Bucket='courseracapstoneproject-donotdelete-pr-lovoontba8n5gj',Key='Geospatial_Coordinates.csv')['Body']\n",
    "# add missing __iter__ method, so pandas accepts body as file-like object\n",
    "if not hasattr(body, \"__iter__\"): body.__iter__ = types.MethodType( __iter__, body )\n",
    "\n",
    "df_data = pd.read_csv(body)\n",
    "df_data.head()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "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>Postal Code</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>M1B</td>\n",
       "      <td>43.806686</td>\n",
       "      <td>-79.194353</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>M1C</td>\n",
       "      <td>43.784535</td>\n",
       "      <td>-79.160497</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>M1E</td>\n",
       "      <td>43.763573</td>\n",
       "      <td>-79.188711</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>M1G</td>\n",
       "      <td>43.770992</td>\n",
       "      <td>-79.216917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>M1H</td>\n",
       "      <td>43.773136</td>\n",
       "      <td>-79.239476</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>M1J</td>\n",
       "      <td>43.744734</td>\n",
       "      <td>-79.239476</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>M1K</td>\n",
       "      <td>43.727929</td>\n",
       "      <td>-79.262029</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>M1L</td>\n",
       "      <td>43.711112</td>\n",
       "      <td>-79.284577</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>M1M</td>\n",
       "      <td>43.716316</td>\n",
       "      <td>-79.239476</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>M1N</td>\n",
       "      <td>43.692657</td>\n",
       "      <td>-79.264848</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>M1P</td>\n",
       "      <td>43.757410</td>\n",
       "      <td>-79.273304</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>M1R</td>\n",
       "      <td>43.750072</td>\n",
       "      <td>-79.295849</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>M1S</td>\n",
       "      <td>43.794200</td>\n",
       "      <td>-79.262029</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>M1T</td>\n",
       "      <td>43.781638</td>\n",
       "      <td>-79.304302</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>M1V</td>\n",
       "      <td>43.815252</td>\n",
       "      <td>-79.284577</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>M1W</td>\n",
       "      <td>43.799525</td>\n",
       "      <td>-79.318389</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>M1X</td>\n",
       "      <td>43.836125</td>\n",
       "      <td>-79.205636</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>M2H</td>\n",
       "      <td>43.803762</td>\n",
       "      <td>-79.363452</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>M2J</td>\n",
       "      <td>43.778517</td>\n",
       "      <td>-79.346556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>M2K</td>\n",
       "      <td>43.786947</td>\n",
       "      <td>-79.385975</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>M2L</td>\n",
       "      <td>43.757490</td>\n",
       "      <td>-79.374714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>M2M</td>\n",
       "      <td>43.789053</td>\n",
       "      <td>-79.408493</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>M2N</td>\n",
       "      <td>43.770120</td>\n",
       "      <td>-79.408493</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>M2P</td>\n",
       "      <td>43.752758</td>\n",
       "      <td>-79.400049</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>M2R</td>\n",
       "      <td>43.782736</td>\n",
       "      <td>-79.442259</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>M3A</td>\n",
       "      <td>43.753259</td>\n",
       "      <td>-79.329656</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>M3B</td>\n",
       "      <td>43.745906</td>\n",
       "      <td>-79.352188</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>M3C</td>\n",
       "      <td>43.725900</td>\n",
       "      <td>-79.340923</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>M3H</td>\n",
       "      <td>43.754328</td>\n",
       "      <td>-79.442259</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>M3J</td>\n",
       "      <td>43.767980</td>\n",
       "      <td>-79.487262</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>M6C</td>\n",
       "      <td>43.693781</td>\n",
       "      <td>-79.428191</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>M6E</td>\n",
       "      <td>43.689026</td>\n",
       "      <td>-79.453512</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>M6G</td>\n",
       "      <td>43.669542</td>\n",
       "      <td>-79.422564</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>M6H</td>\n",
       "      <td>43.669005</td>\n",
       "      <td>-79.442259</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>M6J</td>\n",
       "      <td>43.647927</td>\n",
       "      <td>-79.419750</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>M6K</td>\n",
       "      <td>43.636847</td>\n",
       "      <td>-79.428191</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>M6L</td>\n",
       "      <td>43.713756</td>\n",
       "      <td>-79.490074</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>M6M</td>\n",
       "      <td>43.691116</td>\n",
       "      <td>-79.476013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>M6N</td>\n",
       "      <td>43.673185</td>\n",
       "      <td>-79.487262</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>M6P</td>\n",
       "      <td>43.661608</td>\n",
       "      <td>-79.464763</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>M6R</td>\n",
       "      <td>43.648960</td>\n",
       "      <td>-79.456325</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>M6S</td>\n",
       "      <td>43.651571</td>\n",
       "      <td>-79.484450</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>M7A</td>\n",
       "      <td>43.662301</td>\n",
       "      <td>-79.389494</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>M7R</td>\n",
       "      <td>43.636966</td>\n",
       "      <td>-79.615819</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>M7Y</td>\n",
       "      <td>43.662744</td>\n",
       "      <td>-79.321558</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>M8V</td>\n",
       "      <td>43.605647</td>\n",
       "      <td>-79.501321</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>M8W</td>\n",
       "      <td>43.602414</td>\n",
       "      <td>-79.543484</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>M8X</td>\n",
       "      <td>43.653654</td>\n",
       "      <td>-79.506944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>M8Y</td>\n",
       "      <td>43.636258</td>\n",
       "      <td>-79.498509</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>M8Z</td>\n",
       "      <td>43.628841</td>\n",
       "      <td>-79.520999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>M9A</td>\n",
       "      <td>43.667856</td>\n",
       "      <td>-79.532242</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>M9B</td>\n",
       "      <td>43.650943</td>\n",
       "      <td>-79.554724</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>M9C</td>\n",
       "      <td>43.643515</td>\n",
       "      <td>-79.577201</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>M9L</td>\n",
       "      <td>43.756303</td>\n",
       "      <td>-79.565963</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>M9M</td>\n",
       "      <td>43.724766</td>\n",
       "      <td>-79.532242</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>M9N</td>\n",
       "      <td>43.706876</td>\n",
       "      <td>-79.518188</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>M9P</td>\n",
       "      <td>43.696319</td>\n",
       "      <td>-79.532242</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>M9R</td>\n",
       "      <td>43.688905</td>\n",
       "      <td>-79.554724</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>M9V</td>\n",
       "      <td>43.739416</td>\n",
       "      <td>-79.588437</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>M9W</td>\n",
       "      <td>43.706748</td>\n",
       "      <td>-79.594054</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>103 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Postal Code   Latitude  Longitude\n",
       "0           M1B  43.806686 -79.194353\n",
       "1           M1C  43.784535 -79.160497\n",
       "2           M1E  43.763573 -79.188711\n",
       "3           M1G  43.770992 -79.216917\n",
       "4           M1H  43.773136 -79.239476\n",
       "5           M1J  43.744734 -79.239476\n",
       "6           M1K  43.727929 -79.262029\n",
       "7           M1L  43.711112 -79.284577\n",
       "8           M1M  43.716316 -79.239476\n",
       "9           M1N  43.692657 -79.264848\n",
       "10          M1P  43.757410 -79.273304\n",
       "11          M1R  43.750072 -79.295849\n",
       "12          M1S  43.794200 -79.262029\n",
       "13          M1T  43.781638 -79.304302\n",
       "14          M1V  43.815252 -79.284577\n",
       "15          M1W  43.799525 -79.318389\n",
       "16          M1X  43.836125 -79.205636\n",
       "17          M2H  43.803762 -79.363452\n",
       "18          M2J  43.778517 -79.346556\n",
       "19          M2K  43.786947 -79.385975\n",
       "20          M2L  43.757490 -79.374714\n",
       "21          M2M  43.789053 -79.408493\n",
       "22          M2N  43.770120 -79.408493\n",
       "23          M2P  43.752758 -79.400049\n",
       "24          M2R  43.782736 -79.442259\n",
       "25          M3A  43.753259 -79.329656\n",
       "26          M3B  43.745906 -79.352188\n",
       "27          M3C  43.725900 -79.340923\n",
       "28          M3H  43.754328 -79.442259\n",
       "29          M3J  43.767980 -79.487262\n",
       "..          ...        ...        ...\n",
       "73          M6C  43.693781 -79.428191\n",
       "74          M6E  43.689026 -79.453512\n",
       "75          M6G  43.669542 -79.422564\n",
       "76          M6H  43.669005 -79.442259\n",
       "77          M6J  43.647927 -79.419750\n",
       "78          M6K  43.636847 -79.428191\n",
       "79          M6L  43.713756 -79.490074\n",
       "80          M6M  43.691116 -79.476013\n",
       "81          M6N  43.673185 -79.487262\n",
       "82          M6P  43.661608 -79.464763\n",
       "83          M6R  43.648960 -79.456325\n",
       "84          M6S  43.651571 -79.484450\n",
       "85          M7A  43.662301 -79.389494\n",
       "86          M7R  43.636966 -79.615819\n",
       "87          M7Y  43.662744 -79.321558\n",
       "88          M8V  43.605647 -79.501321\n",
       "89          M8W  43.602414 -79.543484\n",
       "90          M8X  43.653654 -79.506944\n",
       "91          M8Y  43.636258 -79.498509\n",
       "92          M8Z  43.628841 -79.520999\n",
       "93          M9A  43.667856 -79.532242\n",
       "94          M9B  43.650943 -79.554724\n",
       "95          M9C  43.643515 -79.577201\n",
       "96          M9L  43.756303 -79.565963\n",
       "97          M9M  43.724766 -79.532242\n",
       "98          M9N  43.706876 -79.518188\n",
       "99          M9P  43.696319 -79.532242\n",
       "100         M9R  43.688905 -79.554724\n",
       "101         M9V  43.739416 -79.588437\n",
       "102         M9W  43.706748 -79.594054\n",
       "\n",
       "[103 rows x 3 columns]"
      ]
     },
     "execution_count": 77,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_data.sort_values('Postal Code')\n",
    "    \n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "metadata": {},
   "outputs": [],
   "source": [
    "toronto_df_temp = final_df.set_index('Postcode')\n",
    "coors_temp = df_data.set_index('Postal Code')\n",
    "toronto_df_coors = pd.concat([toronto_df_temp, coors_temp], axis=1, join='inner')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "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>Neighbourhood</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>M3A</th>\n",
       "      <td>North York</td>\n",
       "      <td>Parkwoods</td>\n",
       "      <td>43.753259</td>\n",
       "      <td>-79.329656</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M4A</th>\n",
       "      <td>North York</td>\n",
       "      <td>Victoria Village</td>\n",
       "      <td>43.725882</td>\n",
       "      <td>-79.315572</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M5A</th>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>Harbourfront,Regent Park</td>\n",
       "      <td>43.654260</td>\n",
       "      <td>-79.360636</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M6A</th>\n",
       "      <td>North York</td>\n",
       "      <td>Lawrence Heights,Lawrence Manor</td>\n",
       "      <td>43.718518</td>\n",
       "      <td>-79.464763</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M7A</th>\n",
       "      <td>Queen's Park</td>\n",
       "      <td>Queen's Park</td>\n",
       "      <td>43.662301</td>\n",
       "      <td>-79.389494</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M9A</th>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>Islington Avenue</td>\n",
       "      <td>43.667856</td>\n",
       "      <td>-79.532242</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M1B</th>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Rouge,Malvern</td>\n",
       "      <td>43.806686</td>\n",
       "      <td>-79.194353</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M3B</th>\n",
       "      <td>North York</td>\n",
       "      <td>Don Mills North</td>\n",
       "      <td>43.745906</td>\n",
       "      <td>-79.352188</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M4B</th>\n",
       "      <td>East York</td>\n",
       "      <td>Woodbine Gardens,Parkview Hill</td>\n",
       "      <td>43.706397</td>\n",
       "      <td>-79.309937</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M5B</th>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>Ryerson,Garden District</td>\n",
       "      <td>43.657162</td>\n",
       "      <td>-79.378937</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M6B</th>\n",
       "      <td>North York</td>\n",
       "      <td>Glencairn</td>\n",
       "      <td>43.709577</td>\n",
       "      <td>-79.445073</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M9B</th>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>Cloverdale,Islington,Martin Grove,Princess Gar...</td>\n",
       "      <td>43.650943</td>\n",
       "      <td>-79.554724</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M1C</th>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Highland Creek,Rouge Hill,Port Union</td>\n",
       "      <td>43.784535</td>\n",
       "      <td>-79.160497</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M3C</th>\n",
       "      <td>North York</td>\n",
       "      <td>Flemingdon Park,Don Mills South</td>\n",
       "      <td>43.725900</td>\n",
       "      <td>-79.340923</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M4C</th>\n",
       "      <td>East York</td>\n",
       "      <td>Woodbine Heights</td>\n",
       "      <td>43.695344</td>\n",
       "      <td>-79.318389</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M5C</th>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>St. James Town</td>\n",
       "      <td>43.651494</td>\n",
       "      <td>-79.375418</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M6C</th>\n",
       "      <td>York</td>\n",
       "      <td>Humewood-Cedarvale</td>\n",
       "      <td>43.693781</td>\n",
       "      <td>-79.428191</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M9C</th>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>Bloordale Gardens,Eringate,Markland Wood,Old B...</td>\n",
       "      <td>43.643515</td>\n",
       "      <td>-79.577201</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M1E</th>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Guildwood,Morningside,West Hill</td>\n",
       "      <td>43.763573</td>\n",
       "      <td>-79.188711</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M4E</th>\n",
       "      <td>East Toronto</td>\n",
       "      <td>The Beaches</td>\n",
       "      <td>43.676357</td>\n",
       "      <td>-79.293031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M5E</th>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>Berczy Park</td>\n",
       "      <td>43.644771</td>\n",
       "      <td>-79.373306</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M6E</th>\n",
       "      <td>York</td>\n",
       "      <td>Caledonia-Fairbanks</td>\n",
       "      <td>43.689026</td>\n",
       "      <td>-79.453512</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M1G</th>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Woburn</td>\n",
       "      <td>43.770992</td>\n",
       "      <td>-79.216917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M4G</th>\n",
       "      <td>East York</td>\n",
       "      <td>Leaside</td>\n",
       "      <td>43.709060</td>\n",
       "      <td>-79.363452</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M5G</th>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>Central Bay Street</td>\n",
       "      <td>43.657952</td>\n",
       "      <td>-79.387383</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M6G</th>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>Christie</td>\n",
       "      <td>43.669542</td>\n",
       "      <td>-79.422564</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M1H</th>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Cedarbrae</td>\n",
       "      <td>43.773136</td>\n",
       "      <td>-79.239476</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M2H</th>\n",
       "      <td>North York</td>\n",
       "      <td>Hillcrest Village</td>\n",
       "      <td>43.803762</td>\n",
       "      <td>-79.363452</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M3H</th>\n",
       "      <td>North York</td>\n",
       "      <td>Bathurst Manor,Downsview North,Wilson Heights</td>\n",
       "      <td>43.754328</td>\n",
       "      <td>-79.442259</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M4H</th>\n",
       "      <td>East York</td>\n",
       "      <td>Thorncliffe Park</td>\n",
       "      <td>43.705369</td>\n",
       "      <td>-79.349372</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M4R</th>\n",
       "      <td>Central Toronto</td>\n",
       "      <td>North Toronto West</td>\n",
       "      <td>43.715383</td>\n",
       "      <td>-79.405678</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M5R</th>\n",
       "      <td>Central Toronto</td>\n",
       "      <td>The Annex,North Midtown,Yorkville</td>\n",
       "      <td>43.672710</td>\n",
       "      <td>-79.405678</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M6R</th>\n",
       "      <td>West Toronto</td>\n",
       "      <td>Parkdale,Roncesvalles</td>\n",
       "      <td>43.648960</td>\n",
       "      <td>-79.456325</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M7R</th>\n",
       "      <td>Mississauga</td>\n",
       "      <td>Canada Post Gateway Processing Centre</td>\n",
       "      <td>43.636966</td>\n",
       "      <td>-79.615819</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M9R</th>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>Kingsview Village,Martin Grove Gardens,Richvie...</td>\n",
       "      <td>43.688905</td>\n",
       "      <td>-79.554724</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M1S</th>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Agincourt</td>\n",
       "      <td>43.794200</td>\n",
       "      <td>-79.262029</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M4S</th>\n",
       "      <td>Central Toronto</td>\n",
       "      <td>Davisville</td>\n",
       "      <td>43.704324</td>\n",
       "      <td>-79.388790</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M5S</th>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>Harbord,University of Toronto</td>\n",
       "      <td>43.662696</td>\n",
       "      <td>-79.400049</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M6S</th>\n",
       "      <td>West Toronto</td>\n",
       "      <td>Runnymede,Swansea</td>\n",
       "      <td>43.651571</td>\n",
       "      <td>-79.484450</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M1T</th>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Clarks Corners,Sullivan,Tam O'Shanter</td>\n",
       "      <td>43.781638</td>\n",
       "      <td>-79.304302</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M4T</th>\n",
       "      <td>Central Toronto</td>\n",
       "      <td>Moore Park,Summerhill East</td>\n",
       "      <td>43.689574</td>\n",
       "      <td>-79.383160</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M5T</th>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>Chinatown,Grange Park,Kensington Market</td>\n",
       "      <td>43.653206</td>\n",
       "      <td>-79.400049</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M1V</th>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Agincourt North,L'Amoreaux East,Milliken,Steel...</td>\n",
       "      <td>43.815252</td>\n",
       "      <td>-79.284577</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M4V</th>\n",
       "      <td>Central Toronto</td>\n",
       "      <td>Deer Park,Forest Hill SE,Rathnelly,South Hill,...</td>\n",
       "      <td>43.686412</td>\n",
       "      <td>-79.400049</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M5V</th>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>CN Tower,Bathurst Quay,Island airport,Harbourf...</td>\n",
       "      <td>43.628947</td>\n",
       "      <td>-79.394420</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M8V</th>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>Humber Bay Shores,Mimico South,New Toronto</td>\n",
       "      <td>43.605647</td>\n",
       "      <td>-79.501321</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M9V</th>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>Albion Gardens,Beaumond Heights,Humbergate,Jam...</td>\n",
       "      <td>43.739416</td>\n",
       "      <td>-79.588437</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M1W</th>\n",
       "      <td>Scarborough</td>\n",
       "      <td>L'Amoreaux West</td>\n",
       "      <td>43.799525</td>\n",
       "      <td>-79.318389</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M4W</th>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>Rosedale</td>\n",
       "      <td>43.679563</td>\n",
       "      <td>-79.377529</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M5W</th>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>Stn A PO Boxes 25 The Esplanade</td>\n",
       "      <td>43.646435</td>\n",
       "      <td>-79.374846</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M8W</th>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>Alderwood,Long Branch</td>\n",
       "      <td>43.602414</td>\n",
       "      <td>-79.543484</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M9W</th>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>Northwest</td>\n",
       "      <td>43.706748</td>\n",
       "      <td>-79.594054</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M1X</th>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Upper Rouge</td>\n",
       "      <td>43.836125</td>\n",
       "      <td>-79.205636</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M4X</th>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>Cabbagetown,St. James Town</td>\n",
       "      <td>43.667967</td>\n",
       "      <td>-79.367675</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M5X</th>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>First Canadian Place,Underground city</td>\n",
       "      <td>43.648429</td>\n",
       "      <td>-79.382280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M8X</th>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>The Kingsway,Montgomery Road,Old Mill North</td>\n",
       "      <td>43.653654</td>\n",
       "      <td>-79.506944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M4Y</th>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>Church and Wellesley</td>\n",
       "      <td>43.665860</td>\n",
       "      <td>-79.383160</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M7Y</th>\n",
       "      <td>East Toronto</td>\n",
       "      <td>Business Reply Mail Processing Centre 969 Eastern</td>\n",
       "      <td>43.662744</td>\n",
       "      <td>-79.321558</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M8Y</th>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>Humber Bay,King's Mill Park,Kingsway Park Sout...</td>\n",
       "      <td>43.636258</td>\n",
       "      <td>-79.498509</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>M8Z</th>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>Kingsway Park South West,Mimico NW,The Queensw...</td>\n",
       "      <td>43.628841</td>\n",
       "      <td>-79.520999</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>103 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              Borough                                      Neighbourhood  \\\n",
       "M3A        North York                                          Parkwoods   \n",
       "M4A        North York                                   Victoria Village   \n",
       "M5A  Downtown Toronto                           Harbourfront,Regent Park   \n",
       "M6A        North York                    Lawrence Heights,Lawrence Manor   \n",
       "M7A      Queen's Park                                       Queen's Park   \n",
       "M9A         Etobicoke                                   Islington Avenue   \n",
       "M1B       Scarborough                                      Rouge,Malvern   \n",
       "M3B        North York                                    Don Mills North   \n",
       "M4B         East York                     Woodbine Gardens,Parkview Hill   \n",
       "M5B  Downtown Toronto                            Ryerson,Garden District   \n",
       "M6B        North York                                          Glencairn   \n",
       "M9B         Etobicoke  Cloverdale,Islington,Martin Grove,Princess Gar...   \n",
       "M1C       Scarborough               Highland Creek,Rouge Hill,Port Union   \n",
       "M3C        North York                    Flemingdon Park,Don Mills South   \n",
       "M4C         East York                                   Woodbine Heights   \n",
       "M5C  Downtown Toronto                                     St. James Town   \n",
       "M6C              York                                 Humewood-Cedarvale   \n",
       "M9C         Etobicoke  Bloordale Gardens,Eringate,Markland Wood,Old B...   \n",
       "M1E       Scarborough                    Guildwood,Morningside,West Hill   \n",
       "M4E      East Toronto                                        The Beaches   \n",
       "M5E  Downtown Toronto                                        Berczy Park   \n",
       "M6E              York                                Caledonia-Fairbanks   \n",
       "M1G       Scarborough                                             Woburn   \n",
       "M4G         East York                                            Leaside   \n",
       "M5G  Downtown Toronto                                 Central Bay Street   \n",
       "M6G  Downtown Toronto                                           Christie   \n",
       "M1H       Scarborough                                          Cedarbrae   \n",
       "M2H        North York                                  Hillcrest Village   \n",
       "M3H        North York      Bathurst Manor,Downsview North,Wilson Heights   \n",
       "M4H         East York                                   Thorncliffe Park   \n",
       "..                ...                                                ...   \n",
       "M4R   Central Toronto                                 North Toronto West   \n",
       "M5R   Central Toronto                  The Annex,North Midtown,Yorkville   \n",
       "M6R      West Toronto                              Parkdale,Roncesvalles   \n",
       "M7R       Mississauga              Canada Post Gateway Processing Centre   \n",
       "M9R         Etobicoke  Kingsview Village,Martin Grove Gardens,Richvie...   \n",
       "M1S       Scarborough                                          Agincourt   \n",
       "M4S   Central Toronto                                         Davisville   \n",
       "M5S  Downtown Toronto                      Harbord,University of Toronto   \n",
       "M6S      West Toronto                                  Runnymede,Swansea   \n",
       "M1T       Scarborough              Clarks Corners,Sullivan,Tam O'Shanter   \n",
       "M4T   Central Toronto                         Moore Park,Summerhill East   \n",
       "M5T  Downtown Toronto            Chinatown,Grange Park,Kensington Market   \n",
       "M1V       Scarborough  Agincourt North,L'Amoreaux East,Milliken,Steel...   \n",
       "M4V   Central Toronto  Deer Park,Forest Hill SE,Rathnelly,South Hill,...   \n",
       "M5V  Downtown Toronto  CN Tower,Bathurst Quay,Island airport,Harbourf...   \n",
       "M8V         Etobicoke         Humber Bay Shores,Mimico South,New Toronto   \n",
       "M9V         Etobicoke  Albion Gardens,Beaumond Heights,Humbergate,Jam...   \n",
       "M1W       Scarborough                                    L'Amoreaux West   \n",
       "M4W  Downtown Toronto                                           Rosedale   \n",
       "M5W  Downtown Toronto                    Stn A PO Boxes 25 The Esplanade   \n",
       "M8W         Etobicoke                              Alderwood,Long Branch   \n",
       "M9W         Etobicoke                                          Northwest   \n",
       "M1X       Scarborough                                        Upper Rouge   \n",
       "M4X  Downtown Toronto                         Cabbagetown,St. James Town   \n",
       "M5X  Downtown Toronto              First Canadian Place,Underground city   \n",
       "M8X         Etobicoke        The Kingsway,Montgomery Road,Old Mill North   \n",
       "M4Y  Downtown Toronto                               Church and Wellesley   \n",
       "M7Y      East Toronto  Business Reply Mail Processing Centre 969 Eastern   \n",
       "M8Y         Etobicoke  Humber Bay,King's Mill Park,Kingsway Park Sout...   \n",
       "M8Z         Etobicoke  Kingsway Park South West,Mimico NW,The Queensw...   \n",
       "\n",
       "      Latitude  Longitude  \n",
       "M3A  43.753259 -79.329656  \n",
       "M4A  43.725882 -79.315572  \n",
       "M5A  43.654260 -79.360636  \n",
       "M6A  43.718518 -79.464763  \n",
       "M7A  43.662301 -79.389494  \n",
       "M9A  43.667856 -79.532242  \n",
       "M1B  43.806686 -79.194353  \n",
       "M3B  43.745906 -79.352188  \n",
       "M4B  43.706397 -79.309937  \n",
       "M5B  43.657162 -79.378937  \n",
       "M6B  43.709577 -79.445073  \n",
       "M9B  43.650943 -79.554724  \n",
       "M1C  43.784535 -79.160497  \n",
       "M3C  43.725900 -79.340923  \n",
       "M4C  43.695344 -79.318389  \n",
       "M5C  43.651494 -79.375418  \n",
       "M6C  43.693781 -79.428191  \n",
       "M9C  43.643515 -79.577201  \n",
       "M1E  43.763573 -79.188711  \n",
       "M4E  43.676357 -79.293031  \n",
       "M5E  43.644771 -79.373306  \n",
       "M6E  43.689026 -79.453512  \n",
       "M1G  43.770992 -79.216917  \n",
       "M4G  43.709060 -79.363452  \n",
       "M5G  43.657952 -79.387383  \n",
       "M6G  43.669542 -79.422564  \n",
       "M1H  43.773136 -79.239476  \n",
       "M2H  43.803762 -79.363452  \n",
       "M3H  43.754328 -79.442259  \n",
       "M4H  43.705369 -79.349372  \n",
       "..         ...        ...  \n",
       "M4R  43.715383 -79.405678  \n",
       "M5R  43.672710 -79.405678  \n",
       "M6R  43.648960 -79.456325  \n",
       "M7R  43.636966 -79.615819  \n",
       "M9R  43.688905 -79.554724  \n",
       "M1S  43.794200 -79.262029  \n",
       "M4S  43.704324 -79.388790  \n",
       "M5S  43.662696 -79.400049  \n",
       "M6S  43.651571 -79.484450  \n",
       "M1T  43.781638 -79.304302  \n",
       "M4T  43.689574 -79.383160  \n",
       "M5T  43.653206 -79.400049  \n",
       "M1V  43.815252 -79.284577  \n",
       "M4V  43.686412 -79.400049  \n",
       "M5V  43.628947 -79.394420  \n",
       "M8V  43.605647 -79.501321  \n",
       "M9V  43.739416 -79.588437  \n",
       "M1W  43.799525 -79.318389  \n",
       "M4W  43.679563 -79.377529  \n",
       "M5W  43.646435 -79.374846  \n",
       "M8W  43.602414 -79.543484  \n",
       "M9W  43.706748 -79.594054  \n",
       "M1X  43.836125 -79.205636  \n",
       "M4X  43.667967 -79.367675  \n",
       "M5X  43.648429 -79.382280  \n",
       "M8X  43.653654 -79.506944  \n",
       "M4Y  43.665860 -79.383160  \n",
       "M7Y  43.662744 -79.321558  \n",
       "M8Y  43.636258 -79.498509  \n",
       "M8Z  43.628841 -79.520999  \n",
       "\n",
       "[103 rows x 4 columns]"
      ]
     },
     "execution_count": 79,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "toronto_df_coors"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "metadata": {},
   "outputs": [
    {
     "ename": "ModuleNotFoundError",
     "evalue": "No module named 'folium'",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mModuleNotFoundError\u001b[0m                       Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-81-fb675a065b4c>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0;32mimport\u001b[0m \u001b[0mfolium\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      2\u001b[0m \u001b[0;32mfrom\u001b[0m \u001b[0mgeopy\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mgeocoders\u001b[0m \u001b[0;32mimport\u001b[0m \u001b[0mNominatim\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      3\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      4\u001b[0m \u001b[0mlatitude\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;36m43.6532\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      5\u001b[0m \u001b[0mlongitude\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;34m-\u001b[0m\u001b[0;36m79.3832\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mModuleNotFoundError\u001b[0m: No module named 'folium'"
     ]
    }
   ],
   "source": [
    "import folium\n",
    "from geopy.geocoders import Nominatim\n",
    "\n",
    "latitude = 43.6532\n",
    "longitude = -79.3832\n",
    "\n",
    "map_toronto = folium.Map(location=[latitude, longitude], zoom_start=10)\n",
    "\n",
    "# add markers to map\n",
    "for lat, lng, borough, neighborhood in zip(toronto_df_coors['Latitude'], toronto_df_coors['Longitude'], toronto_df_coors['Borough'], toronto_df_coors['Neighborhood']):\n",
    "    label = '{}, {}'.format(neighborhood, 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,\n",
    "        parse_html=False).add_to(map_toronto)  \n",
    "    \n",
    "map_toronto"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Solving environment: done\n",
      "\n",
      "# All requested packages already installed.\n",
      "\n"
     ]
    }
   ],
   "source": [
    "!conda install -c conda-forge geopy --yes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "CLIENT_ID = 'GMUUC2GUMFOORGUE1X1RP5TDHGBFHG05QV0RBE5G3DIWIMVG' # your Foursquare ID\n",
    "CLIENT_SECRET = 'AKKTWEFY02L5UQCS0P2KKNHOLPQQT1AZWPQMIWSO0AMJ2EI0' # No peeking at my secret key\n",
    "VERSION = '20180605' # Foursquare API version"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "metadata": {},
   "outputs": [],
   "source": [
    "def getNearbyVenues(names, latitudes, longitudes, radius=500): #This function was built by the Coursera lab\n",
    "    \n",
    "    venues_list=[]\n",
    "    for name, lat, lng in zip(names, latitudes, longitudes):\n",
    "        print(name)\n",
    "            \n",
    "        # create the API request URL\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",
    "            lat, \n",
    "            lng, \n",
    "            radius, \n",
    "            LIMIT)\n",
    "            \n",
    "        # make the GET request\n",
    "        results = requests.get(url).json()[\"response\"]['groups'][0]['items']\n",
    "        \n",
    "        # return only relevant information for each nearby venue\n",
    "        venues_list.append([(\n",
    "            name, \n",
    "            lat, \n",
    "            lng, \n",
    "            v['venue']['name'], \n",
    "            v['venue']['location']['lat'], \n",
    "            v['venue']['location']['lng'],  \n",
    "            v['venue']['categories'][0]['name']) for v in results])\n",
    "\n",
    "    nearby_venues = pd.DataFrame([item for venue_list in venues_list for item in venue_list])\n",
    "    nearby_venues.columns = ['Neighborhood', \n",
    "                  'Neighborhood Latitude', \n",
    "                  'Neighborhood Longitude', \n",
    "                  'Venue', \n",
    "                  'Venue Latitude', \n",
    "                  'Venue Longitude', \n",
    "                  'Venue Category']\n",
    "    \n",
    "    return(nearby_venues)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Parkwoods\n",
      "Victoria Village\n",
      "Harbourfront,Regent Park\n",
      "Lawrence Heights,Lawrence Manor\n",
      "Queen's Park\n",
      "Islington Avenue\n",
      "Rouge,Malvern\n",
      "Don Mills North\n",
      "Woodbine Gardens,Parkview Hill\n",
      "Ryerson,Garden District\n",
      "Glencairn\n",
      "Cloverdale,Islington,Martin Grove,Princess Gardens,West Deane Park\n",
      "Highland Creek,Rouge Hill,Port Union\n",
      "Flemingdon Park,Don Mills South\n",
      "Woodbine Heights\n",
      "St. James Town\n",
      "Humewood-Cedarvale\n",
      "Bloordale Gardens,Eringate,Markland Wood,Old Burnhamthorpe\n",
      "Guildwood,Morningside,West Hill\n",
      "The Beaches\n",
      "Berczy Park\n",
      "Caledonia-Fairbanks\n",
      "Woburn\n",
      "Leaside\n",
      "Central Bay Street\n",
      "Christie\n",
      "Cedarbrae\n",
      "Hillcrest Village\n",
      "Bathurst Manor,Downsview North,Wilson Heights\n",
      "Thorncliffe Park\n",
      "Adelaide,King,Richmond\n",
      "Dovercourt Village,Dufferin\n",
      "Scarborough Village\n",
      "Fairview,Henry Farm,Oriole\n",
      "Northwood Park,York University\n",
      "East Toronto\n",
      "Harbourfront East,Toronto Islands,Union Station\n",
      "Little Portugal,Trinity\n",
      "East Birchmount Park,Ionview,Kennedy Park\n",
      "Bayview Village\n",
      "CFB Toronto,Downsview East\n",
      "The Danforth West,Riverdale\n",
      "Design Exchange,Toronto Dominion Centre\n",
      "Brockton,Exhibition Place,Parkdale Village\n",
      "Clairlea,Golden Mile,Oakridge\n",
      "Silver Hills,York Mills\n",
      "Downsview West\n",
      "The Beaches West,India Bazaar\n",
      "Commerce Court,Victoria Hotel\n",
      "Downsview,North Park,Upwood Park\n",
      "Humber Summit\n",
      "Cliffcrest,Cliffside,Scarborough Village West\n",
      "Newtonbrook,Willowdale\n",
      "Downsview Central\n",
      "Studio District\n",
      "Bedford Park,Lawrence Manor East\n",
      "Del Ray,Keelesdale,Mount Dennis,Silverthorn\n",
      "Emery,Humberlea\n",
      "Birch Cliff,Cliffside West\n",
      "Willowdale South\n",
      "Downsview Northwest\n",
      "Lawrence Park\n",
      "Roselawn\n",
      "The Junction North,Runnymede\n",
      "Weston\n",
      "Dorset Park,Scarborough Town Centre,Wexford Heights\n",
      "York Mills West\n",
      "Davisville North\n",
      "Forest Hill North,Forest Hill West\n",
      "High Park,The Junction South\n",
      "Westmount\n",
      "Maryvale,Wexford\n",
      "Willowdale West\n",
      "North Toronto West\n",
      "The Annex,North Midtown,Yorkville\n",
      "Parkdale,Roncesvalles\n",
      "Canada Post Gateway Processing Centre\n",
      "Kingsview Village,Martin Grove Gardens,Richview Gardens,St. Phillips\n",
      "Agincourt\n",
      "Davisville\n",
      "Harbord,University of Toronto\n",
      "Runnymede,Swansea\n",
      "Clarks Corners,Sullivan,Tam O'Shanter\n",
      "Moore Park,Summerhill East\n",
      "Chinatown,Grange Park,Kensington Market\n",
      "Agincourt North,L'Amoreaux East,Milliken,Steeles East\n",
      "Deer Park,Forest Hill SE,Rathnelly,South Hill,Summerhill West\n",
      "CN Tower,Bathurst Quay,Island airport,Harbourfront West,King and Spadina,Railway Lands,South Niagara\n",
      "Humber Bay Shores,Mimico South,New Toronto\n",
      "Albion Gardens,Beaumond Heights,Humbergate,Jamestown,Mount Olive,Silverstone,South Steeles,Thistletown\n",
      "L'Amoreaux West\n",
      "Rosedale\n",
      "Stn A PO Boxes 25 The Esplanade\n",
      "Alderwood,Long Branch\n",
      "Northwest\n",
      "Upper Rouge\n",
      "Cabbagetown,St. James Town\n",
      "First Canadian Place,Underground city\n",
      "The Kingsway,Montgomery Road,Old Mill North\n",
      "Church and Wellesley\n",
      "Business Reply Mail Processing Centre 969 Eastern\n",
      "Humber Bay,King's Mill Park,Kingsway Park South East,Mimico NE,Old Mill South,The Queensway East,Royal York South East,Sunnylea\n",
      "Kingsway Park South West,Mimico NW,The Queensway West,Royal York South West,South of Bloor\n"
     ]
    }
   ],
   "source": [
    "LIMIT = 500\n",
    "toronto_venues = getNearbyVenues(names=toronto_df_coors['Neighbourhood'],\n",
    "                                   latitudes=toronto_df_coors['Latitude'],\n",
    "                                   longitudes=toronto_df_coors['Longitude']\n",
    "                                  )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "There are 275 uniques categories.\n"
     ]
    }
   ],
   "source": [
    "print('There are {} uniques categories.'.format(len(toronto_venues['Venue Category'].unique())))\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 88,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(2268, 275)"
      ]
     },
     "execution_count": 88,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Start the clustering analysis with one-hot encoding for pre-processing\n",
    "# one hot encoding\n",
    "toronto_onehot = pd.get_dummies(toronto_venues[['Venue Category']], prefix=\"\", prefix_sep=\"\")\n",
    "\n",
    "# add neighborhood column back to dataframe\n",
    "toronto_onehot['Neighborhood'] = toronto_venues['Neighborhood'] \n",
    "\n",
    "# move neighborhood column to the first column\n",
    "fixed_columns = [toronto_onehot.columns[-1]] + list(toronto_onehot.columns[:-1])\n",
    "toronto_onehot = toronto_onehot[fixed_columns]\n",
    "\n",
    "toronto_onehot.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 89,
   "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>Neighborhood</th>\n",
       "      <th>Yoga Studio</th>\n",
       "      <th>Accessories Store</th>\n",
       "      <th>Afghan Restaurant</th>\n",
       "      <th>Airport</th>\n",
       "      <th>Airport Food Court</th>\n",
       "      <th>Airport Gate</th>\n",
       "      <th>Airport Lounge</th>\n",
       "      <th>Airport Service</th>\n",
       "      <th>Airport Terminal</th>\n",
       "      <th>...</th>\n",
       "      <th>Trail</th>\n",
       "      <th>Train Station</th>\n",
       "      <th>Vegetarian / Vegan Restaurant</th>\n",
       "      <th>Video Game Store</th>\n",
       "      <th>Video Store</th>\n",
       "      <th>Vietnamese Restaurant</th>\n",
       "      <th>Warehouse Store</th>\n",
       "      <th>Wine Bar</th>\n",
       "      <th>Wings Joint</th>\n",
       "      <th>Women's Store</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Adelaide,King,Richmond</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.020000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.010000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Agincourt</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Agincourt North,L'Amoreaux East,Milliken,Steel...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Albion Gardens,Beaumond Heights,Humbergate,Jam...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Alderwood,Long Branch</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Bathurst Manor,Downsview North,Wilson Heights</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.052632</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Bayview Village</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Bedford Park,Lawrence Manor East</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Berczy Park</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.017544</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Birch Cliff,Cliffside West</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Bloordale Gardens,Eringate,Markland Wood,Old B...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Brockton,Exhibition Place,Parkdale Village</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Business Reply Mail Processing Centre 969 Eastern</td>\n",
       "      <td>0.052632</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>CFB Toronto,Downsview East</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.5000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>CN Tower,Bathurst Quay,Island airport,Harbourf...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0625</td>\n",
       "      <td>0.0625</td>\n",
       "      <td>0.0625</td>\n",
       "      <td>0.125</td>\n",
       "      <td>0.125</td>\n",
       "      <td>0.125</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Cabbagetown,St. James Town</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Caledonia-Fairbanks</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Canada Post Gateway Processing Centre</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Cedarbrae</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Central Bay Street</td>\n",
       "      <td>0.011628</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.011628</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.011628</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Chinatown,Grange Park,Kensington Market</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.060000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.040000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.010000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Christie</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Church and Wellesley</td>\n",
       "      <td>0.011111</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.011111</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.011111</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.011111</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.011111</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Clairlea,Golden Mile,Oakridge</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Clarks Corners,Sullivan,Tam O'Shanter</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Cliffcrest,Cliffside,Scarborough Village West</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Cloverdale,Islington,Martin Grove,Princess Gar...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Commerce Court,Victoria Hotel</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.020000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.010000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Davisville</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Davisville North</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>Northwest</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>Northwood Park,York University</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>Parkdale,Roncesvalles</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>Parkwoods</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>Queen's Park</td>\n",
       "      <td>0.024390</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.024390</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>Rosedale</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.200000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>Roselawn</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>Rouge,Malvern</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>Runnymede,Swansea</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.027027</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>Ryerson,Garden District</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.010000</td>\n",
       "      <td>0.010000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.010000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.010000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>Scarborough Village</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>St. James Town</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.010000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.010000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>Stn A PO Boxes 25 The Esplanade</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.010204</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>Studio District</td>\n",
       "      <td>0.026316</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>The Annex,North Midtown,Yorkville</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.041667</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>The Beaches</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.200000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>The Beaches West,India Bazaar</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>The Danforth West,Riverdale</td>\n",
       "      <td>0.022727</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.022727</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>The Junction North,Runnymede</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>The Kingsway,Montgomery Road,Old Mill North</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>Thorncliffe Park</td>\n",
       "      <td>0.055556</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.055556</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>Victoria Village</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>Westmount</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>Weston</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>Willowdale South</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.027778</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>Willowdale West</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>Woburn</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>Woodbine Gardens,Parkview Hill</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>Woodbine Heights</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.111111</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>York Mills West</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>100 rows × 275 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                         Neighborhood  Yoga Studio  \\\n",
       "0                              Adelaide,King,Richmond     0.000000   \n",
       "1                                           Agincourt     0.000000   \n",
       "2   Agincourt North,L'Amoreaux East,Milliken,Steel...     0.000000   \n",
       "3   Albion Gardens,Beaumond Heights,Humbergate,Jam...     0.000000   \n",
       "4                               Alderwood,Long Branch     0.000000   \n",
       "5       Bathurst Manor,Downsview North,Wilson Heights     0.000000   \n",
       "6                                     Bayview Village     0.000000   \n",
       "7                    Bedford Park,Lawrence Manor East     0.000000   \n",
       "8                                         Berczy Park     0.000000   \n",
       "9                          Birch Cliff,Cliffside West     0.000000   \n",
       "10  Bloordale Gardens,Eringate,Markland Wood,Old B...     0.000000   \n",
       "11         Brockton,Exhibition Place,Parkdale Village     0.000000   \n",
       "12  Business Reply Mail Processing Centre 969 Eastern     0.052632   \n",
       "13                         CFB Toronto,Downsview East     0.000000   \n",
       "14  CN Tower,Bathurst Quay,Island airport,Harbourf...     0.000000   \n",
       "15                         Cabbagetown,St. James Town     0.000000   \n",
       "16                                Caledonia-Fairbanks     0.000000   \n",
       "17              Canada Post Gateway Processing Centre     0.000000   \n",
       "18                                          Cedarbrae     0.000000   \n",
       "19                                 Central Bay Street     0.011628   \n",
       "20            Chinatown,Grange Park,Kensington Market     0.000000   \n",
       "21                                           Christie     0.000000   \n",
       "22                               Church and Wellesley     0.011111   \n",
       "23                      Clairlea,Golden Mile,Oakridge     0.000000   \n",
       "24              Clarks Corners,Sullivan,Tam O'Shanter     0.000000   \n",
       "25      Cliffcrest,Cliffside,Scarborough Village West     0.000000   \n",
       "26  Cloverdale,Islington,Martin Grove,Princess Gar...     0.000000   \n",
       "27                      Commerce Court,Victoria Hotel     0.000000   \n",
       "28                                         Davisville     0.000000   \n",
       "29                                   Davisville North     0.000000   \n",
       "..                                                ...          ...   \n",
       "70                                          Northwest     0.000000   \n",
       "71                     Northwood Park,York University     0.000000   \n",
       "72                              Parkdale,Roncesvalles     0.000000   \n",
       "73                                          Parkwoods     0.000000   \n",
       "74                                       Queen's Park     0.024390   \n",
       "75                                           Rosedale     0.000000   \n",
       "76                                           Roselawn     0.000000   \n",
       "77                                      Rouge,Malvern     0.000000   \n",
       "78                                  Runnymede,Swansea     0.000000   \n",
       "79                            Ryerson,Garden District     0.000000   \n",
       "80                                Scarborough Village     0.000000   \n",
       "81                                     St. James Town     0.000000   \n",
       "82                    Stn A PO Boxes 25 The Esplanade     0.000000   \n",
       "83                                    Studio District     0.026316   \n",
       "84                  The Annex,North Midtown,Yorkville     0.000000   \n",
       "85                                        The Beaches     0.000000   \n",
       "86                      The Beaches West,India Bazaar     0.000000   \n",
       "87                        The Danforth West,Riverdale     0.022727   \n",
       "88                       The Junction North,Runnymede     0.000000   \n",
       "89        The Kingsway,Montgomery Road,Old Mill North     0.000000   \n",
       "90                                   Thorncliffe Park     0.055556   \n",
       "91                                   Victoria Village     0.000000   \n",
       "92                                          Westmount     0.000000   \n",
       "93                                             Weston     0.000000   \n",
       "94                                   Willowdale South     0.000000   \n",
       "95                                    Willowdale West     0.000000   \n",
       "96                                             Woburn     0.000000   \n",
       "97                     Woodbine Gardens,Parkview Hill     0.000000   \n",
       "98                                   Woodbine Heights     0.000000   \n",
       "99                                    York Mills West     0.000000   \n",
       "\n",
       "    Accessories Store  Afghan Restaurant  Airport  Airport Food Court  \\\n",
       "0                 0.0           0.000000   0.0000              0.0000   \n",
       "1                 0.0           0.000000   0.0000              0.0000   \n",
       "2                 0.0           0.000000   0.0000              0.0000   \n",
       "3                 0.0           0.000000   0.0000              0.0000   \n",
       "4                 0.0           0.000000   0.0000              0.0000   \n",
       "5                 0.0           0.000000   0.0000              0.0000   \n",
       "6                 0.0           0.000000   0.0000              0.0000   \n",
       "7                 0.0           0.000000   0.0000              0.0000   \n",
       "8                 0.0           0.000000   0.0000              0.0000   \n",
       "9                 0.0           0.000000   0.0000              0.0000   \n",
       "10                0.0           0.000000   0.0000              0.0000   \n",
       "11                0.0           0.000000   0.0000              0.0000   \n",
       "12                0.0           0.000000   0.0000              0.0000   \n",
       "13                0.0           0.000000   0.5000              0.0000   \n",
       "14                0.0           0.000000   0.0625              0.0625   \n",
       "15                0.0           0.000000   0.0000              0.0000   \n",
       "16                0.0           0.000000   0.0000              0.0000   \n",
       "17                0.0           0.000000   0.0000              0.0000   \n",
       "18                0.0           0.000000   0.0000              0.0000   \n",
       "19                0.0           0.000000   0.0000              0.0000   \n",
       "20                0.0           0.000000   0.0000              0.0000   \n",
       "21                0.0           0.000000   0.0000              0.0000   \n",
       "22                0.0           0.011111   0.0000              0.0000   \n",
       "23                0.0           0.000000   0.0000              0.0000   \n",
       "24                0.0           0.000000   0.0000              0.0000   \n",
       "25                0.0           0.000000   0.0000              0.0000   \n",
       "26                0.0           0.000000   0.0000              0.0000   \n",
       "27                0.0           0.000000   0.0000              0.0000   \n",
       "28                0.0           0.000000   0.0000              0.0000   \n",
       "29                0.0           0.000000   0.0000              0.0000   \n",
       "..                ...                ...      ...                 ...   \n",
       "70                0.0           0.000000   0.0000              0.0000   \n",
       "71                0.0           0.000000   0.0000              0.0000   \n",
       "72                0.0           0.000000   0.0000              0.0000   \n",
       "73                0.0           0.000000   0.0000              0.0000   \n",
       "74                0.0           0.000000   0.0000              0.0000   \n",
       "75                0.0           0.000000   0.0000              0.0000   \n",
       "76                0.0           0.000000   0.0000              0.0000   \n",
       "77                0.0           0.000000   0.0000              0.0000   \n",
       "78                0.0           0.000000   0.0000              0.0000   \n",
       "79                0.0           0.000000   0.0000              0.0000   \n",
       "80                0.0           0.000000   0.0000              0.0000   \n",
       "81                0.0           0.000000   0.0000              0.0000   \n",
       "82                0.0           0.000000   0.0000              0.0000   \n",
       "83                0.0           0.000000   0.0000              0.0000   \n",
       "84                0.0           0.000000   0.0000              0.0000   \n",
       "85                0.0           0.000000   0.0000              0.0000   \n",
       "86                0.0           0.000000   0.0000              0.0000   \n",
       "87                0.0           0.000000   0.0000              0.0000   \n",
       "88                0.0           0.000000   0.0000              0.0000   \n",
       "89                0.0           0.000000   0.0000              0.0000   \n",
       "90                0.0           0.000000   0.0000              0.0000   \n",
       "91                0.0           0.000000   0.0000              0.0000   \n",
       "92                0.0           0.000000   0.0000              0.0000   \n",
       "93                0.0           0.000000   0.0000              0.0000   \n",
       "94                0.0           0.000000   0.0000              0.0000   \n",
       "95                0.0           0.000000   0.0000              0.0000   \n",
       "96                0.0           0.000000   0.0000              0.0000   \n",
       "97                0.0           0.000000   0.0000              0.0000   \n",
       "98                0.0           0.000000   0.0000              0.0000   \n",
       "99                0.0           0.000000   0.0000              0.0000   \n",
       "\n",
       "    Airport Gate  Airport Lounge  Airport Service  Airport Terminal  ...  \\\n",
       "0         0.0000           0.000            0.000             0.000  ...   \n",
       "1         0.0000           0.000            0.000             0.000  ...   \n",
       "2         0.0000           0.000            0.000             0.000  ...   \n",
       "3         0.0000           0.000            0.000             0.000  ...   \n",
       "4         0.0000           0.000            0.000             0.000  ...   \n",
       "5         0.0000           0.000            0.000             0.000  ...   \n",
       "6         0.0000           0.000            0.000             0.000  ...   \n",
       "7         0.0000           0.000            0.000             0.000  ...   \n",
       "8         0.0000           0.000            0.000             0.000  ...   \n",
       "9         0.0000           0.000            0.000             0.000  ...   \n",
       "10        0.0000           0.000            0.000             0.000  ...   \n",
       "11        0.0000           0.000            0.000             0.000  ...   \n",
       "12        0.0000           0.000            0.000             0.000  ...   \n",
       "13        0.0000           0.000            0.000             0.000  ...   \n",
       "14        0.0625           0.125            0.125             0.125  ...   \n",
       "15        0.0000           0.000            0.000             0.000  ...   \n",
       "16        0.0000           0.000            0.000             0.000  ...   \n",
       "17        0.0000           0.000            0.000             0.000  ...   \n",
       "18        0.0000           0.000            0.000             0.000  ...   \n",
       "19        0.0000           0.000            0.000             0.000  ...   \n",
       "20        0.0000           0.000            0.000             0.000  ...   \n",
       "21        0.0000           0.000            0.000             0.000  ...   \n",
       "22        0.0000           0.000            0.000             0.000  ...   \n",
       "23        0.0000           0.000            0.000             0.000  ...   \n",
       "24        0.0000           0.000            0.000             0.000  ...   \n",
       "25        0.0000           0.000            0.000             0.000  ...   \n",
       "26        0.0000           0.000            0.000             0.000  ...   \n",
       "27        0.0000           0.000            0.000             0.000  ...   \n",
       "28        0.0000           0.000            0.000             0.000  ...   \n",
       "29        0.0000           0.000            0.000             0.000  ...   \n",
       "..           ...             ...              ...               ...  ...   \n",
       "70        0.0000           0.000            0.000             0.000  ...   \n",
       "71        0.0000           0.000            0.000             0.000  ...   \n",
       "72        0.0000           0.000            0.000             0.000  ...   \n",
       "73        0.0000           0.000            0.000             0.000  ...   \n",
       "74        0.0000           0.000            0.000             0.000  ...   \n",
       "75        0.0000           0.000            0.000             0.000  ...   \n",
       "76        0.0000           0.000            0.000             0.000  ...   \n",
       "77        0.0000           0.000            0.000             0.000  ...   \n",
       "78        0.0000           0.000            0.000             0.000  ...   \n",
       "79        0.0000           0.000            0.000             0.000  ...   \n",
       "80        0.0000           0.000            0.000             0.000  ...   \n",
       "81        0.0000           0.000            0.000             0.000  ...   \n",
       "82        0.0000           0.000            0.000             0.000  ...   \n",
       "83        0.0000           0.000            0.000             0.000  ...   \n",
       "84        0.0000           0.000            0.000             0.000  ...   \n",
       "85        0.0000           0.000            0.000             0.000  ...   \n",
       "86        0.0000           0.000            0.000             0.000  ...   \n",
       "87        0.0000           0.000            0.000             0.000  ...   \n",
       "88        0.0000           0.000            0.000             0.000  ...   \n",
       "89        0.0000           0.000            0.000             0.000  ...   \n",
       "90        0.0000           0.000            0.000             0.000  ...   \n",
       "91        0.0000           0.000            0.000             0.000  ...   \n",
       "92        0.0000           0.000            0.000             0.000  ...   \n",
       "93        0.0000           0.000            0.000             0.000  ...   \n",
       "94        0.0000           0.000            0.000             0.000  ...   \n",
       "95        0.0000           0.000            0.000             0.000  ...   \n",
       "96        0.0000           0.000            0.000             0.000  ...   \n",
       "97        0.0000           0.000            0.000             0.000  ...   \n",
       "98        0.0000           0.000            0.000             0.000  ...   \n",
       "99        0.0000           0.000            0.000             0.000  ...   \n",
       "\n",
       "       Trail  Train Station  Vegetarian / Vegan Restaurant  Video Game Store  \\\n",
       "0   0.000000            0.0                       0.020000          0.000000   \n",
       "1   0.000000            0.0                       0.000000          0.000000   \n",
       "2   0.000000            0.0                       0.000000          0.000000   \n",
       "3   0.000000            0.0                       0.000000          0.000000   \n",
       "4   0.000000            0.0                       0.000000          0.000000   \n",
       "5   0.000000            0.0                       0.000000          0.000000   \n",
       "6   0.000000            0.0                       0.000000          0.000000   \n",
       "7   0.000000            0.0                       0.000000          0.000000   \n",
       "8   0.000000            0.0                       0.017544          0.000000   \n",
       "9   0.000000            0.0                       0.000000          0.000000   \n",
       "10  0.000000            0.0                       0.000000          0.000000   \n",
       "11  0.000000            0.0                       0.000000          0.000000   \n",
       "12  0.000000            0.0                       0.000000          0.000000   \n",
       "13  0.000000            0.0                       0.000000          0.000000   \n",
       "14  0.000000            0.0                       0.000000          0.000000   \n",
       "15  0.000000            0.0                       0.000000          0.000000   \n",
       "16  0.000000            0.0                       0.000000          0.000000   \n",
       "17  0.000000            0.0                       0.000000          0.000000   \n",
       "18  0.000000            0.0                       0.000000          0.000000   \n",
       "19  0.000000            0.0                       0.011628          0.000000   \n",
       "20  0.000000            0.0                       0.060000          0.000000   \n",
       "21  0.000000            0.0                       0.000000          0.000000   \n",
       "22  0.000000            0.0                       0.000000          0.011111   \n",
       "23  0.000000            0.0                       0.000000          0.000000   \n",
       "24  0.000000            0.0                       0.000000          0.000000   \n",
       "25  0.000000            0.0                       0.000000          0.000000   \n",
       "26  0.000000            0.0                       0.000000          0.000000   \n",
       "27  0.000000            0.0                       0.020000          0.000000   \n",
       "28  0.000000            0.0                       0.000000          0.000000   \n",
       "29  0.000000            0.0                       0.000000          0.000000   \n",
       "..       ...            ...                            ...               ...   \n",
       "70  0.000000            0.0                       0.000000          0.000000   \n",
       "71  0.000000            0.0                       0.000000          0.000000   \n",
       "72  0.000000            0.0                       0.000000          0.000000   \n",
       "73  0.000000            0.0                       0.000000          0.000000   \n",
       "74  0.000000            0.0                       0.000000          0.000000   \n",
       "75  0.200000            0.0                       0.000000          0.000000   \n",
       "76  0.000000            0.0                       0.000000          0.000000   \n",
       "77  0.000000            0.0                       0.000000          0.000000   \n",
       "78  0.000000            0.0                       0.027027          0.000000   \n",
       "79  0.000000            0.0                       0.010000          0.010000   \n",
       "80  0.000000            0.0                       0.000000          0.000000   \n",
       "81  0.000000            0.0                       0.010000          0.000000   \n",
       "82  0.000000            0.0                       0.010204          0.000000   \n",
       "83  0.000000            0.0                       0.000000          0.000000   \n",
       "84  0.000000            0.0                       0.041667          0.000000   \n",
       "85  0.200000            0.0                       0.000000          0.000000   \n",
       "86  0.000000            0.0                       0.000000          0.000000   \n",
       "87  0.022727            0.0                       0.000000          0.000000   \n",
       "88  0.000000            0.0                       0.000000          0.000000   \n",
       "89  0.000000            0.0                       0.000000          0.000000   \n",
       "90  0.000000            0.0                       0.000000          0.000000   \n",
       "91  0.000000            0.0                       0.000000          0.000000   \n",
       "92  0.000000            0.0                       0.000000          0.000000   \n",
       "93  0.000000            0.0                       0.000000          0.000000   \n",
       "94  0.000000            0.0                       0.000000          0.000000   \n",
       "95  0.000000            0.0                       0.000000          0.000000   \n",
       "96  0.000000            0.0                       0.000000          0.000000   \n",
       "97  0.000000            0.0                       0.000000          0.000000   \n",
       "98  0.000000            0.0                       0.000000          0.000000   \n",
       "99  0.000000            0.0                       0.000000          0.000000   \n",
       "\n",
       "    Video Store  Vietnamese Restaurant  Warehouse Store  Wine Bar  \\\n",
       "0      0.000000               0.000000         0.000000  0.010000   \n",
       "1      0.000000               0.000000         0.000000  0.000000   \n",
       "2      0.000000               0.000000         0.000000  0.000000   \n",
       "3      0.000000               0.000000         0.000000  0.000000   \n",
       "4      0.000000               0.000000         0.000000  0.000000   \n",
       "5      0.052632               0.000000         0.000000  0.000000   \n",
       "6      0.000000               0.000000         0.000000  0.000000   \n",
       "7      0.000000               0.000000         0.000000  0.000000   \n",
       "8      0.000000               0.000000         0.000000  0.000000   \n",
       "9      0.000000               0.000000         0.000000  0.000000   \n",
       "10     0.000000               0.000000         0.000000  0.000000   \n",
       "11     0.000000               0.000000         0.000000  0.000000   \n",
       "12     0.000000               0.000000         0.000000  0.000000   \n",
       "13     0.000000               0.000000         0.000000  0.000000   \n",
       "14     0.000000               0.000000         0.000000  0.000000   \n",
       "15     0.000000               0.000000         0.000000  0.000000   \n",
       "16     0.000000               0.000000         0.000000  0.000000   \n",
       "17     0.000000               0.000000         0.000000  0.000000   \n",
       "18     0.000000               0.000000         0.000000  0.000000   \n",
       "19     0.000000               0.000000         0.000000  0.011628   \n",
       "20     0.000000               0.040000         0.000000  0.010000   \n",
       "21     0.000000               0.000000         0.000000  0.000000   \n",
       "22     0.000000               0.011111         0.000000  0.000000   \n",
       "23     0.000000               0.000000         0.000000  0.000000   \n",
       "24     0.000000               0.000000         0.000000  0.000000   \n",
       "25     0.000000               0.000000         0.000000  0.000000   \n",
       "26     0.000000               0.000000         0.000000  0.000000   \n",
       "27     0.000000               0.000000         0.000000  0.010000   \n",
       "28     0.000000               0.000000         0.000000  0.000000   \n",
       "29     0.000000               0.000000         0.000000  0.000000   \n",
       "..          ...                    ...              ...       ...   \n",
       "70     0.000000               0.000000         0.000000  0.000000   \n",
       "71     0.000000               0.000000         0.000000  0.000000   \n",
       "72     0.000000               0.000000         0.000000  0.000000   \n",
       "73     0.000000               0.000000         0.000000  0.000000   \n",
       "74     0.000000               0.000000         0.000000  0.000000   \n",
       "75     0.000000               0.000000         0.000000  0.000000   \n",
       "76     0.000000               0.000000         0.000000  0.000000   \n",
       "77     0.000000               0.000000         0.000000  0.000000   \n",
       "78     0.000000               0.000000         0.000000  0.000000   \n",
       "79     0.000000               0.010000         0.000000  0.010000   \n",
       "80     0.000000               0.000000         0.000000  0.000000   \n",
       "81     0.000000               0.000000         0.000000  0.010000   \n",
       "82     0.000000               0.000000         0.000000  0.000000   \n",
       "83     0.000000               0.000000         0.000000  0.000000   \n",
       "84     0.000000               0.000000         0.000000  0.000000   \n",
       "85     0.000000               0.000000         0.000000  0.000000   \n",
       "86     0.000000               0.000000         0.000000  0.000000   \n",
       "87     0.000000               0.000000         0.000000  0.000000   \n",
       "88     0.000000               0.000000         0.000000  0.000000   \n",
       "89     0.000000               0.000000         0.000000  0.000000   \n",
       "90     0.000000               0.000000         0.055556  0.000000   \n",
       "91     0.000000               0.000000         0.000000  0.000000   \n",
       "92     0.000000               0.000000         0.000000  0.000000   \n",
       "93     0.000000               0.000000         0.000000  0.000000   \n",
       "94     0.000000               0.027778         0.000000  0.000000   \n",
       "95     0.000000               0.000000         0.000000  0.000000   \n",
       "96     0.000000               0.000000         0.000000  0.000000   \n",
       "97     0.000000               0.000000         0.000000  0.000000   \n",
       "98     0.111111               0.000000         0.000000  0.000000   \n",
       "99     0.000000               0.000000         0.000000  0.000000   \n",
       "\n",
       "    Wings Joint  Women's Store  \n",
       "0      0.000000            0.0  \n",
       "1      0.000000            0.0  \n",
       "2      0.000000            0.0  \n",
       "3      0.000000            0.0  \n",
       "4      0.000000            0.0  \n",
       "5      0.000000            0.0  \n",
       "6      0.000000            0.0  \n",
       "7      0.000000            0.0  \n",
       "8      0.000000            0.0  \n",
       "9      0.000000            0.0  \n",
       "10     0.000000            0.0  \n",
       "11     0.000000            0.0  \n",
       "12     0.000000            0.0  \n",
       "13     0.000000            0.0  \n",
       "14     0.000000            0.0  \n",
       "15     0.000000            0.0  \n",
       "16     0.000000            0.2  \n",
       "17     0.000000            0.0  \n",
       "18     0.000000            0.0  \n",
       "19     0.000000            0.0  \n",
       "20     0.000000            0.0  \n",
       "21     0.000000            0.0  \n",
       "22     0.011111            0.0  \n",
       "23     0.000000            0.0  \n",
       "24     0.000000            0.0  \n",
       "25     0.000000            0.0  \n",
       "26     0.000000            0.0  \n",
       "27     0.000000            0.0  \n",
       "28     0.000000            0.0  \n",
       "29     0.000000            0.0  \n",
       "..          ...            ...  \n",
       "70     0.000000            0.0  \n",
       "71     0.000000            0.0  \n",
       "72     0.000000            0.0  \n",
       "73     0.000000            0.0  \n",
       "74     0.024390            0.0  \n",
       "75     0.000000            0.0  \n",
       "76     0.000000            0.0  \n",
       "77     0.000000            0.0  \n",
       "78     0.000000            0.0  \n",
       "79     0.000000            0.0  \n",
       "80     0.000000            0.0  \n",
       "81     0.000000            0.0  \n",
       "82     0.000000            0.0  \n",
       "83     0.000000            0.0  \n",
       "84     0.000000            0.0  \n",
       "85     0.000000            0.0  \n",
       "86     0.000000            0.0  \n",
       "87     0.000000            0.0  \n",
       "88     0.000000            0.0  \n",
       "89     0.000000            0.0  \n",
       "90     0.000000            0.0  \n",
       "91     0.000000            0.0  \n",
       "92     0.000000            0.0  \n",
       "93     0.000000            0.0  \n",
       "94     0.000000            0.0  \n",
       "95     0.000000            0.0  \n",
       "96     0.000000            0.0  \n",
       "97     0.000000            0.0  \n",
       "98     0.000000            0.0  \n",
       "99     0.000000            0.0  \n",
       "\n",
       "[100 rows x 275 columns]"
      ]
     },
     "execution_count": 89,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "toronto_grouped = toronto_onehot.groupby('Neighborhood').mean().reset_index()\n",
    "toronto_grouped"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "----Adelaide,King,Richmond----\n",
      "            venue  freq\n",
      "0     Coffee Shop  0.08\n",
      "1            Café  0.05\n",
      "2      Steakhouse  0.04\n",
      "3             Bar  0.04\n",
      "4  Cosmetics Shop  0.03\n",
      "\n",
      "\n",
      "----Agincourt----\n",
      "            venue  freq\n",
      "0          Lounge  0.25\n",
      "1  Breakfast Spot  0.25\n",
      "2    Skating Rink  0.25\n",
      "3  Clothing Store  0.25\n",
      "4     Yoga Studio  0.00\n",
      "\n",
      "\n",
      "----Agincourt North,L'Amoreaux East,Milliken,Steeles East----\n",
      "                 venue  freq\n",
      "0           Playground   0.5\n",
      "1                 Park   0.5\n",
      "2          Yoga Studio   0.0\n",
      "3   Mexican Restaurant   0.0\n",
      "4  Monument / Landmark   0.0\n",
      "\n",
      "\n",
      "----Albion Gardens,Beaumond Heights,Humbergate,Jamestown,Mount Olive,Silverstone,South Steeles,Thistletown----\n",
      "                  venue  freq\n",
      "0           Pizza Place   0.2\n",
      "1         Grocery Store   0.2\n",
      "2              Pharmacy   0.1\n",
      "3  Fast Food Restaurant   0.1\n",
      "4        Sandwich Place   0.1\n",
      "\n",
      "\n",
      "----Alderwood,Long Branch----\n",
      "          venue  freq\n",
      "0   Pizza Place  0.22\n",
      "1  Skating Rink  0.11\n",
      "2   Coffee Shop  0.11\n",
      "3          Pool  0.11\n",
      "4           Pub  0.11\n",
      "\n",
      "\n",
      "----Bathurst Manor,Downsview North,Wilson Heights----\n",
      "                       venue  freq\n",
      "0                Coffee Shop  0.11\n",
      "1           Sushi Restaurant  0.05\n",
      "2  Middle Eastern Restaurant  0.05\n",
      "3         Frozen Yogurt Shop  0.05\n",
      "4        Fried Chicken Joint  0.05\n",
      "\n",
      "\n",
      "----Bayview Village----\n",
      "                 venue  freq\n",
      "0                 Café  0.25\n",
      "1  Japanese Restaurant  0.25\n",
      "2                 Bank  0.25\n",
      "3   Chinese Restaurant  0.25\n",
      "4        Movie Theater  0.00\n",
      "\n",
      "\n",
      "----Bedford Park,Lawrence Manor East----\n",
      "                     venue  freq\n",
      "0       Italian Restaurant  0.09\n",
      "1              Coffee Shop  0.09\n",
      "2  Comfort Food Restaurant  0.04\n",
      "3         Greek Restaurant  0.04\n",
      "4               Restaurant  0.04\n",
      "\n",
      "\n",
      "----Berczy Park----\n",
      "                venue  freq\n",
      "0         Coffee Shop  0.07\n",
      "1        Cocktail Bar  0.05\n",
      "2  Italian Restaurant  0.04\n",
      "3            Beer Bar  0.04\n",
      "4                Café  0.04\n",
      "\n",
      "\n",
      "----Birch Cliff,Cliffside West----\n",
      "                   venue  freq\n",
      "0        College Stadium  0.25\n",
      "1           Skating Rink  0.25\n",
      "2  General Entertainment  0.25\n",
      "3                   Café  0.25\n",
      "4            Men's Store  0.00\n",
      "\n",
      "\n",
      "----Bloordale Gardens,Eringate,Markland Wood,Old Burnhamthorpe----\n",
      "          venue  freq\n",
      "0          Café  0.17\n",
      "1   Coffee Shop  0.17\n",
      "2    Beer Store  0.17\n",
      "3  Liquor Store  0.17\n",
      "4   Pizza Place  0.17\n",
      "\n",
      "\n",
      "----Brockton,Exhibition Place,Parkdale Village----\n",
      "            venue  freq\n",
      "0  Breakfast Spot  0.10\n",
      "1            Café  0.10\n",
      "2     Coffee Shop  0.10\n",
      "3          Bakery  0.05\n",
      "4   Grocery Store  0.05\n",
      "\n",
      "\n",
      "----Business Reply Mail Processing Centre 969 Eastern----\n",
      "                venue  freq\n",
      "0  Light Rail Station  0.11\n",
      "1         Yoga Studio  0.05\n",
      "2       Auto Workshop  0.05\n",
      "3          Skate Park  0.05\n",
      "4       Burrito Place  0.05\n",
      "\n",
      "\n",
      "----CFB Toronto,Downsview East----\n",
      "                 venue  freq\n",
      "0              Airport   0.5\n",
      "1                 Park   0.5\n",
      "2          Yoga Studio   0.0\n",
      "3   Mexican Restaurant   0.0\n",
      "4  Monument / Landmark   0.0\n",
      "\n",
      "\n",
      "----CN Tower,Bathurst Quay,Island airport,Harbourfront West,King and Spadina,Railway Lands,South Niagara----\n",
      "              venue  freq\n",
      "0  Airport Terminal  0.12\n",
      "1    Airport Lounge  0.12\n",
      "2   Airport Service  0.12\n",
      "3               Bar  0.06\n",
      "4  Sculpture Garden  0.06\n",
      "\n",
      "\n",
      "----Cabbagetown,St. James Town----\n",
      "                venue  freq\n",
      "0         Coffee Shop  0.09\n",
      "1                Café  0.07\n",
      "2  Italian Restaurant  0.05\n",
      "3              Bakery  0.05\n",
      "4         Pizza Place  0.05\n",
      "\n",
      "\n",
      "----Caledonia-Fairbanks----\n",
      "                   venue  freq\n",
      "0                   Park   0.4\n",
      "1          Women's Store   0.2\n",
      "2   Fast Food Restaurant   0.2\n",
      "3                 Market   0.2\n",
      "4  Performing Arts Venue   0.0\n",
      "\n",
      "\n",
      "----Canada Post Gateway Processing Centre----\n",
      "                      venue  freq\n",
      "0               Coffee Shop  0.18\n",
      "1                     Hotel  0.18\n",
      "2             Burrito Place  0.09\n",
      "3  Mediterranean Restaurant  0.09\n",
      "4            Sandwich Place  0.09\n",
      "\n",
      "\n",
      "----Cedarbrae----\n",
      "                  venue  freq\n",
      "0  Caribbean Restaurant  0.14\n",
      "1      Hakka Restaurant  0.14\n",
      "2    Athletics & Sports  0.14\n",
      "3       Thai Restaurant  0.14\n",
      "4   Fried Chicken Joint  0.14\n",
      "\n",
      "\n",
      "----Central Bay Street----\n",
      "                       venue  freq\n",
      "0                Coffee Shop  0.14\n",
      "1  Middle Eastern Restaurant  0.05\n",
      "2                       Café  0.05\n",
      "3         Italian Restaurant  0.05\n",
      "4             Ice Cream Shop  0.03\n",
      "\n",
      "\n",
      "----Chinatown,Grange Park,Kensington Market----\n",
      "                           venue  freq\n",
      "0                           Café  0.07\n",
      "1  Vegetarian / Vegan Restaurant  0.06\n",
      "2                            Bar  0.05\n",
      "3            Dumpling Restaurant  0.04\n",
      "4             Mexican Restaurant  0.04\n",
      "\n",
      "\n",
      "----Christie----\n",
      "               venue  freq\n",
      "0      Grocery Store  0.19\n",
      "1               Café  0.19\n",
      "2               Park  0.12\n",
      "3         Baby Store  0.06\n",
      "4  Convenience Store  0.06\n",
      "\n",
      "\n",
      "----Church and Wellesley----\n",
      "                 venue  freq\n",
      "0          Coffee Shop  0.09\n",
      "1  Japanese Restaurant  0.06\n",
      "2              Gay Bar  0.06\n",
      "3     Sushi Restaurant  0.04\n",
      "4           Restaurant  0.03\n",
      "\n",
      "\n",
      "----Clairlea,Golden Mile,Oakridge----\n",
      "                  venue  freq\n",
      "0                Bakery   0.2\n",
      "1              Bus Line   0.2\n",
      "2          Soccer Field   0.1\n",
      "3          Intersection   0.1\n",
      "4  Fast Food Restaurant   0.1\n",
      "\n",
      "\n",
      "----Clarks Corners,Sullivan,Tam O'Shanter----\n",
      "                  venue  freq\n",
      "0           Pizza Place  0.17\n",
      "1              Pharmacy  0.08\n",
      "2          Noodle House  0.08\n",
      "3  Fast Food Restaurant  0.08\n",
      "4         Shopping Mall  0.08\n",
      "\n",
      "\n",
      "----Cliffcrest,Cliffside,Scarborough Village West----\n",
      "                 venue  freq\n",
      "0  American Restaurant  0.33\n",
      "1                Motel  0.33\n",
      "2        Movie Theater  0.33\n",
      "3       Massage Studio  0.00\n",
      "4       Medical Center  0.00\n",
      "\n",
      "\n",
      "----Cloverdale,Islington,Martin Grove,Princess Gardens,West Deane Park----\n",
      "                             venue  freq\n",
      "0                             Bank   1.0\n",
      "1                      Yoga Studio   0.0\n",
      "2        Middle Eastern Restaurant   0.0\n",
      "3              Monument / Landmark   0.0\n",
      "4  Molecular Gastronomy Restaurant   0.0\n",
      "\n",
      "\n",
      "----Commerce Court,Victoria Hotel----\n",
      "                 venue  freq\n",
      "0          Coffee Shop  0.11\n",
      "1                 Café  0.06\n",
      "2                Hotel  0.06\n",
      "3           Restaurant  0.05\n",
      "4  American Restaurant  0.04\n",
      "\n",
      "\n",
      "----Davisville----\n",
      "            venue  freq\n",
      "0     Pizza Place  0.14\n",
      "1  Sandwich Place  0.08\n",
      "2    Dessert Shop  0.08\n",
      "3     Coffee Shop  0.06\n",
      "4            Café  0.06\n",
      "\n",
      "\n",
      "----Davisville North----\n",
      "               venue  freq\n",
      "0  Food & Drink Shop  0.12\n",
      "1     Sandwich Place  0.12\n",
      "2     Breakfast Spot  0.12\n",
      "3               Park  0.12\n",
      "4                Gym  0.12\n",
      "\n",
      "\n",
      "----Deer Park,Forest Hill SE,Rathnelly,South Hill,Summerhill West----\n",
      "                     venue  freq\n",
      "0              Coffee Shop  0.12\n",
      "1                      Pub  0.12\n",
      "2  Health & Beauty Service  0.06\n",
      "3             Liquor Store  0.06\n",
      "4       Light Rail Station  0.06\n",
      "\n",
      "\n",
      "----Del Ray,Keelesdale,Mount Dennis,Silverthorn----\n",
      "                  venue  freq\n",
      "0  Fast Food Restaurant   0.4\n",
      "1            Restaurant   0.2\n",
      "2        Sandwich Place   0.2\n",
      "3                   Bar   0.2\n",
      "4           Yoga Studio   0.0\n",
      "\n",
      "\n",
      "----Design Exchange,Toronto Dominion Centre----\n",
      "         venue  freq\n",
      "0  Coffee Shop  0.12\n",
      "1         Café  0.08\n",
      "2        Hotel  0.06\n",
      "3   Restaurant  0.05\n",
      "4       Bakery  0.03\n",
      "\n",
      "\n",
      "----Don Mills North----\n",
      "                  venue  freq\n",
      "0                  Café   0.2\n",
      "1  Caribbean Restaurant   0.2\n",
      "2  Gym / Fitness Center   0.2\n",
      "3      Basketball Court   0.2\n",
      "4   Japanese Restaurant   0.2\n",
      "\n",
      "\n",
      "----Dorset Park,Scarborough Town Centre,Wexford Heights----\n",
      "                       venue  freq\n",
      "0          Indian Restaurant  0.33\n",
      "1  Latin American Restaurant  0.17\n",
      "2                  Pet Store  0.17\n",
      "3      Vietnamese Restaurant  0.17\n",
      "4         Chinese Restaurant  0.17\n",
      "\n",
      "\n",
      "----Dovercourt Village,Dufferin----\n",
      "         venue  freq\n",
      "0       Bakery  0.13\n",
      "1  Supermarket  0.13\n",
      "2     Pharmacy  0.13\n",
      "3      Brewery  0.07\n",
      "4          Bar  0.07\n",
      "\n",
      "\n",
      "----Downsview Central----\n",
      "                             venue  freq\n",
      "0                       Food Truck  0.33\n",
      "1                     Home Service  0.33\n",
      "2                   Baseball Field  0.33\n",
      "3               Mexican Restaurant  0.00\n",
      "4  Molecular Gastronomy Restaurant  0.00\n",
      "\n",
      "\n",
      "----Downsview Northwest----\n",
      "                venue  freq\n",
      "0      Discount Store  0.25\n",
      "1  Athletics & Sports  0.25\n",
      "2        Liquor Store  0.25\n",
      "3       Grocery Store  0.25\n",
      "4  Miscellaneous Shop  0.00\n",
      "\n",
      "\n",
      "----Downsview West----\n",
      "           venue  freq\n",
      "0  Grocery Store  0.33\n",
      "1  Shopping Mall  0.17\n",
      "2           Bank  0.17\n",
      "3           Park  0.17\n",
      "4          Hotel  0.17\n",
      "\n",
      "\n",
      "----Downsview,North Park,Upwood Park----\n",
      "                        venue  freq\n",
      "0                      Bakery  0.25\n",
      "1  Construction & Landscaping  0.25\n",
      "2                        Park  0.25\n",
      "3               Deli / Bodega  0.25\n",
      "4                 Yoga Studio  0.00\n",
      "\n",
      "\n",
      "----East Birchmount Park,Ionview,Kennedy Park----\n",
      "               venue  freq\n",
      "0     Discount Store   0.4\n",
      "1        Bus Station   0.2\n",
      "2   Department Store   0.2\n",
      "3        Coffee Shop   0.2\n",
      "4  Mobile Phone Shop   0.0\n",
      "\n",
      "\n",
      "----East Toronto----\n",
      "                       venue  freq\n",
      "0                Coffee Shop  0.33\n",
      "1          Convenience Store  0.33\n",
      "2                       Park  0.33\n",
      "3                Yoga Studio  0.00\n",
      "4  Middle Eastern Restaurant  0.00\n",
      "\n",
      "\n",
      "----Emery,Humberlea----\n",
      "                             venue  freq\n",
      "0           Furniture / Home Store   0.5\n",
      "1                   Baseball Field   0.5\n",
      "2                      Yoga Studio   0.0\n",
      "3        Middle Eastern Restaurant   0.0\n",
      "4  Molecular Gastronomy Restaurant   0.0\n",
      "\n",
      "\n",
      "----Fairview,Henry Farm,Oriole----\n",
      "                  venue  freq\n",
      "0        Clothing Store  0.15\n",
      "1           Coffee Shop  0.08\n",
      "2  Fast Food Restaurant  0.08\n",
      "3         Women's Store  0.03\n",
      "4                Bakery  0.03\n",
      "\n",
      "\n",
      "----First Canadian Place,Underground city----\n",
      "         venue  freq\n",
      "0  Coffee Shop  0.10\n",
      "1         Café  0.08\n",
      "2        Hotel  0.05\n",
      "3   Steakhouse  0.04\n",
      "4   Restaurant  0.04\n",
      "\n",
      "\n",
      "----Flemingdon Park,Don Mills South----\n",
      "              venue  freq\n",
      "0               Gym  0.09\n",
      "1       Coffee Shop  0.09\n",
      "2  Asian Restaurant  0.09\n",
      "3        Beer Store  0.09\n",
      "4         Bike Shop  0.04\n",
      "\n",
      "\n",
      "----Forest Hill North,Forest Hill West----\n",
      "              venue  freq\n",
      "0             Trail  0.25\n",
      "1              Park  0.25\n",
      "2  Sushi Restaurant  0.25\n",
      "3     Jewelry Store  0.25\n",
      "4       Yoga Studio  0.00\n",
      "\n",
      "\n",
      "----Glencairn----\n",
      "                       venue  freq\n",
      "0                Pizza Place  0.25\n",
      "1        Japanese Restaurant  0.25\n",
      "2                       Park  0.25\n",
      "3                        Pub  0.25\n",
      "4  Middle Eastern Restaurant  0.00\n",
      "\n",
      "\n",
      "----Guildwood,Morningside,West Hill----\n",
      "                 venue  freq\n",
      "0          Pizza Place  0.14\n",
      "1  Rental Car Location  0.14\n",
      "2       Medical Center  0.14\n",
      "3       Breakfast Spot  0.14\n",
      "4   Mexican Restaurant  0.14\n",
      "\n",
      "\n",
      "----Harbord,University of Toronto----\n",
      "            venue  freq\n",
      "0            Café  0.14\n",
      "1             Bar  0.06\n",
      "2       Bookstore  0.06\n",
      "3  Sandwich Place  0.06\n",
      "4          Bakery  0.06\n",
      "\n",
      "\n",
      "----Harbourfront East,Toronto Islands,Union Station----\n",
      "         venue  freq\n",
      "0  Coffee Shop  0.13\n",
      "1     Aquarium  0.05\n",
      "2        Hotel  0.05\n",
      "3         Café  0.04\n",
      "4      Brewery  0.03\n",
      "\n",
      "\n",
      "----Harbourfront,Regent Park----\n",
      "         venue  freq\n",
      "0  Coffee Shop  0.18\n",
      "1         Café  0.06\n",
      "2         Park  0.06\n",
      "3       Bakery  0.06\n",
      "4          Pub  0.06\n",
      "\n",
      "\n",
      "----High Park,The Junction South----\n",
      "                venue  freq\n",
      "0  Mexican Restaurant  0.08\n",
      "1                Café  0.08\n",
      "2           Bookstore  0.04\n",
      "3     Thai Restaurant  0.04\n",
      "4         Flea Market  0.04\n",
      "\n",
      "\n",
      "----Highland Creek,Rouge Hill,Port Union----\n",
      "                        venue  freq\n",
      "0  Construction & Landscaping   0.5\n",
      "1                         Bar   0.5\n",
      "2                 Yoga Studio   0.0\n",
      "3   Middle Eastern Restaurant   0.0\n",
      "4         Monument / Landmark   0.0\n",
      "\n",
      "\n",
      "----Hillcrest Village----\n",
      "                      venue  freq\n",
      "0               Golf Course  0.25\n",
      "1                   Dog Run  0.25\n",
      "2  Mediterranean Restaurant  0.25\n",
      "3                      Pool  0.25\n",
      "4               Yoga Studio  0.00\n",
      "\n",
      "\n",
      "----Humber Bay Shores,Mimico South,New Toronto----\n",
      "            venue  freq\n",
      "0       Pet Store  0.08\n",
      "1             Gym  0.08\n",
      "2            Café  0.08\n",
      "3      Restaurant  0.08\n",
      "4  Sandwich Place  0.08\n",
      "\n",
      "\n",
      "----Humber Bay,King's Mill Park,Kingsway Park South East,Mimico NE,Old Mill South,The Queensway East,Royal York South East,Sunnylea----\n",
      "                       venue  freq\n",
      "0                       Pool   0.5\n",
      "1             Baseball Field   0.5\n",
      "2                Yoga Studio   0.0\n",
      "3  Middle Eastern Restaurant   0.0\n",
      "4        Monument / Landmark   0.0\n",
      "\n",
      "\n",
      "----Humber Summit----\n",
      "                             venue  freq\n",
      "0                      Pizza Place   0.5\n",
      "1               Italian Restaurant   0.5\n",
      "2        Middle Eastern Restaurant   0.0\n",
      "3              Monument / Landmark   0.0\n",
      "4  Molecular Gastronomy Restaurant   0.0\n",
      "\n",
      "\n",
      "----Humewood-Cedarvale----\n",
      "                 venue  freq\n",
      "0                Trail  0.33\n",
      "1                Field  0.33\n",
      "2         Hockey Arena  0.33\n",
      "3          Yoga Studio  0.00\n",
      "4  Monument / Landmark  0.00\n",
      "\n",
      "\n",
      "----Kingsview Village,Martin Grove Gardens,Richview Gardens,St. Phillips----\n",
      "                       venue  freq\n",
      "0                Pizza Place  0.25\n",
      "1                   Bus Line  0.25\n",
      "2                       Park  0.25\n",
      "3          Mobile Phone Shop  0.25\n",
      "4  Middle Eastern Restaurant  0.00\n",
      "\n",
      "\n",
      "----Kingsway Park South West,Mimico NW,The Queensway West,Royal York South West,South of Bloor----\n",
      "               venue  freq\n",
      "0  Convenience Store  0.08\n",
      "1      Burrito Place  0.08\n",
      "2             Bakery  0.08\n",
      "3     Discount Store  0.08\n",
      "4      Tanning Salon  0.08\n",
      "\n",
      "\n",
      "----L'Amoreaux West----\n",
      "                  venue  freq\n",
      "0  Fast Food Restaurant  0.21\n",
      "1           Coffee Shop  0.14\n",
      "2    Chinese Restaurant  0.14\n",
      "3           Pizza Place  0.07\n",
      "4        Breakfast Spot  0.07\n",
      "\n",
      "\n",
      "----Lawrence Heights,Lawrence Manor----\n",
      "                    venue  freq\n",
      "0          Clothing Store  0.27\n",
      "1  Furniture / Home Store  0.20\n",
      "2     Sporting Goods Shop  0.07\n",
      "3                Boutique  0.07\n",
      "4      Miscellaneous Shop  0.07\n",
      "\n",
      "\n",
      "----Lawrence Park----\n",
      "                       venue  freq\n",
      "0                   Bus Line  0.33\n",
      "1                Swim School  0.33\n",
      "2                       Park  0.33\n",
      "3                Yoga Studio  0.00\n",
      "4  Middle Eastern Restaurant  0.00\n",
      "\n",
      "\n",
      "----Leaside----\n",
      "                    venue  freq\n",
      "0             Coffee Shop  0.12\n",
      "1     Sporting Goods Shop  0.09\n",
      "2            Burger Joint  0.06\n",
      "3  Furniture / Home Store  0.06\n",
      "4              Sports Bar  0.03\n",
      "\n",
      "\n",
      "----Little Portugal,Trinity----\n",
      "              venue  freq\n",
      "0               Bar  0.12\n",
      "1  Asian Restaurant  0.05\n",
      "2       Coffee Shop  0.05\n",
      "3              Café  0.03\n",
      "4       Men's Store  0.03\n",
      "\n",
      "\n",
      "----Maryvale,Wexford----\n",
      "                       venue  freq\n",
      "0  Middle Eastern Restaurant  0.25\n",
      "1                     Bakery  0.25\n",
      "2             Breakfast Spot  0.25\n",
      "3                 Smoke Shop  0.25\n",
      "4                Yoga Studio  0.00\n",
      "\n",
      "\n",
      "----Moore Park,Summerhill East----\n",
      "                       venue  freq\n",
      "0                 Restaurant  0.25\n",
      "1                 Playground  0.25\n",
      "2                        Gym  0.25\n",
      "3               Tennis Court  0.25\n",
      "4  Middle Eastern Restaurant  0.00\n",
      "\n",
      "\n",
      "----Newtonbrook,Willowdale----\n",
      "                             venue  freq\n",
      "0                        Piano Bar   1.0\n",
      "1                      Yoga Studio   0.0\n",
      "2               Mexican Restaurant   0.0\n",
      "3              Monument / Landmark   0.0\n",
      "4  Molecular Gastronomy Restaurant   0.0\n",
      "\n",
      "\n",
      "----North Toronto West----\n",
      "                 venue  freq\n",
      "0          Coffee Shop  0.09\n",
      "1  Sporting Goods Shop  0.09\n",
      "2       Clothing Store  0.09\n",
      "3          Yoga Studio  0.05\n",
      "4   Mexican Restaurant  0.05\n",
      "\n",
      "\n",
      "----Northwest----\n",
      "                 venue  freq\n",
      "0  Rental Car Location  0.33\n",
      "1                  Bar  0.33\n",
      "2            Drugstore  0.33\n",
      "3          Yoga Studio  0.00\n",
      "4        Movie Theater  0.00\n",
      "\n",
      "\n",
      "----Northwood Park,York University----\n",
      "                  venue  freq\n",
      "0        Massage Studio   0.2\n",
      "1  Caribbean Restaurant   0.2\n",
      "2                   Bar   0.2\n",
      "3    Falafel Restaurant   0.2\n",
      "4           Coffee Shop   0.2\n",
      "\n",
      "\n",
      "----Parkdale,Roncesvalles----\n",
      "            venue  freq\n",
      "0  Breakfast Spot  0.13\n",
      "1       Gift Shop  0.13\n",
      "2         Dog Run  0.07\n",
      "3    Dessert Shop  0.07\n",
      "4   Movie Theater  0.07\n",
      "\n",
      "\n",
      "----Parkwoods----\n",
      "                             venue  freq\n",
      "0                             Park   0.5\n",
      "1                Food & Drink Shop   0.5\n",
      "2                      Yoga Studio   0.0\n",
      "3               Mexican Restaurant   0.0\n",
      "4  Molecular Gastronomy Restaurant   0.0\n",
      "\n",
      "\n",
      "----Queen's Park----\n",
      "          venue  freq\n",
      "0   Coffee Shop  0.24\n",
      "1           Gym  0.05\n",
      "2          Park  0.05\n",
      "3         Diner  0.05\n",
      "4  Burger Joint  0.05\n",
      "\n",
      "\n",
      "----Rosedale----\n",
      "         venue  freq\n",
      "0         Park   0.4\n",
      "1   Playground   0.2\n",
      "2     Building   0.2\n",
      "3        Trail   0.2\n",
      "4  Yoga Studio   0.0\n",
      "\n",
      "\n",
      "----Roselawn----\n",
      "                     venue  freq\n",
      "0  Health & Beauty Service  0.33\n",
      "1           Ice Cream Shop  0.33\n",
      "2                   Garden  0.33\n",
      "3       Persian Restaurant  0.00\n",
      "4    Performing Arts Venue  0.00\n",
      "\n",
      "\n",
      "----Rouge,Malvern----\n",
      "                             venue  freq\n",
      "0             Fast Food Restaurant   1.0\n",
      "1                      Yoga Studio   0.0\n",
      "2               Mexican Restaurant   0.0\n",
      "3              Monument / Landmark   0.0\n",
      "4  Molecular Gastronomy Restaurant   0.0\n",
      "\n",
      "\n",
      "----Runnymede,Swansea----\n",
      "                venue  freq\n",
      "0         Coffee Shop  0.08\n",
      "1                Café  0.08\n",
      "2    Sushi Restaurant  0.05\n",
      "3         Pizza Place  0.05\n",
      "4  Italian Restaurant  0.05\n",
      "\n",
      "\n",
      "----Ryerson,Garden District----\n",
      "                       venue  freq\n",
      "0             Clothing Store  0.08\n",
      "1                Coffee Shop  0.08\n",
      "2                       Café  0.03\n",
      "3             Cosmetics Shop  0.03\n",
      "4  Middle Eastern Restaurant  0.03\n",
      "\n",
      "\n",
      "----Scarborough Village----\n",
      "                             venue  freq\n",
      "0                       Playground   1.0\n",
      "1                      Yoga Studio   0.0\n",
      "2               Mexican Restaurant   0.0\n",
      "3              Monument / Landmark   0.0\n",
      "4  Molecular Gastronomy Restaurant   0.0\n",
      "\n",
      "\n",
      "----St. James Town----\n",
      "                venue  freq\n",
      "0         Coffee Shop  0.07\n",
      "1                Café  0.06\n",
      "2          Restaurant  0.05\n",
      "3               Hotel  0.05\n",
      "4  Italian Restaurant  0.04\n",
      "\n",
      "\n",
      "----Stn A PO Boxes 25 The Esplanade----\n",
      "                venue  freq\n",
      "0         Coffee Shop  0.11\n",
      "1  Italian Restaurant  0.04\n",
      "2          Restaurant  0.04\n",
      "3                Café  0.04\n",
      "4  Seafood Restaurant  0.03\n",
      "\n",
      "\n",
      "----Studio District----\n",
      "                 venue  freq\n",
      "0                 Café  0.11\n",
      "1          Coffee Shop  0.08\n",
      "2  American Restaurant  0.05\n",
      "3               Bakery  0.05\n",
      "4   Italian Restaurant  0.05\n",
      "\n",
      "\n",
      "----The Annex,North Midtown,Yorkville----\n",
      "            venue  freq\n",
      "0     Coffee Shop  0.12\n",
      "1            Café  0.12\n",
      "2  Sandwich Place  0.12\n",
      "3     Pizza Place  0.08\n",
      "4  History Museum  0.04\n",
      "\n",
      "\n",
      "----The Beaches----\n",
      "                             venue  freq\n",
      "0                Health Food Store   0.2\n",
      "1                            Trail   0.2\n",
      "2             Other Great Outdoors   0.2\n",
      "3                              Pub   0.2\n",
      "4  Molecular Gastronomy Restaurant   0.0\n",
      "\n",
      "\n",
      "----The Beaches West,India Bazaar----\n",
      "            venue  freq\n",
      "0     Pizza Place  0.08\n",
      "1            Park  0.08\n",
      "2  Sandwich Place  0.08\n",
      "3   Movie Theater  0.04\n",
      "4             Pub  0.04\n",
      "\n",
      "\n",
      "----The Danforth West,Riverdale----\n",
      "                    venue  freq\n",
      "0        Greek Restaurant  0.20\n",
      "1             Coffee Shop  0.09\n",
      "2      Italian Restaurant  0.07\n",
      "3          Ice Cream Shop  0.05\n",
      "4  Furniture / Home Store  0.05\n",
      "\n",
      "\n",
      "----The Junction North,Runnymede----\n",
      "                       venue  freq\n",
      "0                Pizza Place  0.25\n",
      "1                   Bus Line  0.25\n",
      "2          Convenience Store  0.25\n",
      "3              Grocery Store  0.25\n",
      "4  Middle Eastern Restaurant  0.00\n",
      "\n",
      "\n",
      "----The Kingsway,Montgomery Road,Old Mill North----\n",
      "                venue  freq\n",
      "0               River  0.33\n",
      "1                Park  0.33\n",
      "2          Smoke Shop  0.33\n",
      "3         Yoga Studio  0.00\n",
      "4  Mexican Restaurant  0.00\n",
      "\n",
      "\n",
      "----Thorncliffe Park----\n",
      "               venue  freq\n",
      "0  Indian Restaurant  0.11\n",
      "1     Sandwich Place  0.11\n",
      "2       Burger Joint  0.11\n",
      "3        Yoga Studio  0.06\n",
      "4        Pizza Place  0.06\n",
      "\n",
      "\n",
      "----Victoria Village----\n",
      "                      venue  freq\n",
      "0              Intersection  0.25\n",
      "1              Hockey Arena  0.25\n",
      "2               Coffee Shop  0.25\n",
      "3     Portuguese Restaurant  0.25\n",
      "4  Mediterranean Restaurant  0.00\n",
      "\n",
      "\n",
      "----Westmount----\n",
      "                       venue  freq\n",
      "0                Pizza Place  0.25\n",
      "1  Middle Eastern Restaurant  0.12\n",
      "2               Intersection  0.12\n",
      "3             Sandwich Place  0.12\n",
      "4         Chinese Restaurant  0.12\n",
      "\n",
      "\n",
      "----Weston----\n",
      "                             venue  freq\n",
      "0                             Park   1.0\n",
      "1                      Yoga Studio   0.0\n",
      "2                    Metro Station   0.0\n",
      "3  Molecular Gastronomy Restaurant   0.0\n",
      "4       Modern European Restaurant   0.0\n",
      "\n",
      "\n",
      "----Willowdale South----\n",
      "              venue  freq\n",
      "0  Ramen Restaurant  0.08\n",
      "1       Coffee Shop  0.08\n",
      "2        Restaurant  0.06\n",
      "3              Café  0.06\n",
      "4       Pizza Place  0.06\n",
      "\n",
      "\n",
      "----Willowdale West----\n",
      "            venue  freq\n",
      "0     Pizza Place  0.14\n",
      "1   Grocery Store  0.14\n",
      "2         Butcher  0.14\n",
      "3     Coffee Shop  0.14\n",
      "4  Discount Store  0.14\n",
      "\n",
      "\n",
      "----Woburn----\n",
      "                venue  freq\n",
      "0         Coffee Shop  0.67\n",
      "1   Korean Restaurant  0.33\n",
      "2         Yoga Studio  0.00\n",
      "3  Miscellaneous Shop  0.00\n",
      "4               Motel  0.00\n",
      "\n",
      "\n",
      "----Woodbine Gardens,Parkview Hill----\n",
      "                  venue  freq\n",
      "0           Pizza Place  0.18\n",
      "1  Fast Food Restaurant  0.18\n",
      "2  Gym / Fitness Center  0.09\n",
      "3                  Café  0.09\n",
      "4                  Bank  0.09\n",
      "\n",
      "\n",
      "----Woodbine Heights----\n",
      "            venue  freq\n",
      "0     Curling Ice  0.11\n",
      "1        Pharmacy  0.11\n",
      "2        Bus Stop  0.11\n",
      "3  Cosmetics Shop  0.11\n",
      "4            Park  0.11\n",
      "\n",
      "\n",
      "----York Mills West----\n",
      "                venue  freq\n",
      "0                Bank  0.33\n",
      "1   Convenience Store  0.33\n",
      "2                Park  0.33\n",
      "3         Yoga Studio  0.00\n",
      "4  Mexican Restaurant  0.00\n",
      "\n",
      "\n"
     ]
    }
   ],
   "source": [
    "#Show the top 5 most frequent venues in our neighborhood analysis\n",
    "num_top_venues = 5\n",
    "\n",
    "for hood in toronto_grouped['Neighborhood']:\n",
    "    print(\"----\"+hood+\"----\")\n",
    "    temp = toronto_grouped[toronto_grouped['Neighborhood'] == hood].T.reset_index()\n",
    "    temp.columns = ['venue','freq']\n",
    "    temp = temp.iloc[1:]\n",
    "    temp['freq'] = temp['freq'].astype(float)\n",
    "    temp = temp.round({'freq': 2})\n",
    "    print(temp.sort_values('freq', ascending=False).reset_index(drop=True).head(num_top_venues))\n",
    "    print('\\n')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Create a function that sorts the venues by frequency\n",
    "def return_most_common_venues(row, num_top_venues):\n",
    "    row_categories = row.iloc[1:]\n",
    "    row_categories_sorted = row_categories.sort_values(ascending=False)\n",
    "    \n",
    "    return row_categories_sorted.index.values[0:num_top_venues]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 100,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(100, 11)"
      ]
     },
     "execution_count": 100,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "num_top_venues = 10\n",
    "\n",
    "indicators = ['st', 'nd', 'rd']\n",
    "\n",
    "# create columns according to number of top venues\n",
    "columns = ['Neighborhood']\n",
    "for ind in np.arange(num_top_venues):\n",
    "    try:\n",
    "        columns.append('{}{} Most Common Venue'.format(ind+1, indicators[ind]))\n",
    "    except:\n",
    "        columns.append('{}th Most Common Venue'.format(ind+1))\n",
    "\n",
    "# create a new dataframe\n",
    "neighborhoods_venues_sorted = pd.DataFrame(columns=columns)\n",
    "neighborhoods_venues_sorted['Neighborhood'] = toronto_grouped['Neighborhood']\n",
    "\n",
    "for ind in np.arange(toronto_grouped.shape[0]):\n",
    "    neighborhoods_venues_sorted.iloc[ind, 1:] = return_most_common_venues(toronto_grouped.iloc[ind, :], num_top_venues)\n",
    "\n",
    "neighborhoods_venues_sorted.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 102,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([0, 0, 2, 0, 0, 0, 0, 0, 0, 0], dtype=int32)"
      ]
     },
     "execution_count": 102,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# set number of clusters\n",
    "kclusters = 5\n",
    "from sklearn.cluster import KMeans\n",
    "toronto_grouped_clustering = toronto_grouped.drop('Neighborhood', 1)\n",
    "\n",
    "# run k-means clustering\n",
    "kmeans = KMeans(n_clusters=kclusters, random_state=0).fit(toronto_grouped_clustering)\n",
    "\n",
    "# check cluster labels generated for each row in the dataframe\n",
    "kmeans.labels_[:10]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "toronto_merged = df\n",
    "\n",
    "# add clustering labels\n",
    "toronto_merged['Cluster Labels'] = kmeans.labels_\n",
    "\n",
    "# merge toronto_grouped with toronto_data to add latitude/longitude for each neighborhood\n",
    "#toronto_merged = toronto_merged.join(neighborhoods_venues_sorted.set_index('Neighborhood'), on='Neighborhood')\n",
    "\n",
    "toronto_merged.head() # check the last columns!"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# create map\n",
    "import folium\n",
    "map_clusters = folium.Map(location=[latitude, longitude], zoom_start=11)\n",
    "\n",
    "# set color scheme for the clusters\n",
    "x = np.arange(kclusters)\n",
    "ys = [i+x+(i*x)**2 for i in range(kclusters)]\n",
    "colors_array = cm.rainbow(np.linspace(0, 1, len(ys)))\n",
    "rainbow = [colors.rgb2hex(i) for i in colors_array]\n",
    "\n",
    "# add markers to the map\n",
    "markers_colors = []\n",
    "for lat, lon, poi, cluster in zip(toronto_merged['Latitude'], toronto_merged['Longitude'], toronto_merged['Neighborhood'], toronto_merged['Cluster Labels']):\n",
    "    label = folium.Popup(str(poi) + ' Cluster ' + str(cluster), parse_html=True)\n",
    "    folium.CircleMarker(\n",
    "        [lat, lon],\n",
    "        radius=5,\n",
    "        popup=label,\n",
    "        color=rainbow[cluster-1],\n",
    "        fill=True,\n",
    "        fill_color=rainbow[cluster-1],\n",
    "        fill_opacity=0.7).add_to(map_clusters)\n",
    "       "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3.6",
   "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.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}