Coursera_Cap.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# IMPORT LIBRARIES"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "from bs4 import BeautifulSoup\n",
    "import requests"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Assign the link to a url to be used in Beautiful Soup"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "url = \"https://en.wikipedia.org/wiki/List_of_postal_codes_of_Canada:_M\"\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "G = requests.get(url).text"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "soup = BeautifulSoup(G,'lxml')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<table class=\"wikitable sortable\">\n",
       "<tbody><tr>\n",
       "<th>Postal Code\n",
       "</th>\n",
       "<th>Borough\n",
       "</th>\n",
       "<th>Neighbourhood\n",
       "</th></tr>\n",
       "<tr>\n",
       "<td>M1A\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M2A\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M3A\n",
       "</td>\n",
       "<td>North York\n",
       "</td>\n",
       "<td>Parkwoods\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M4A\n",
       "</td>\n",
       "<td>North York\n",
       "</td>\n",
       "<td>Victoria Village\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M5A\n",
       "</td>\n",
       "<td>Downtown Toronto\n",
       "</td>\n",
       "<td>Regent Park, Harbourfront\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M6A\n",
       "</td>\n",
       "<td>North York\n",
       "</td>\n",
       "<td>Lawrence Manor, Lawrence Heights\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M7A\n",
       "</td>\n",
       "<td>Downtown Toronto\n",
       "</td>\n",
       "<td>Queen's Park, Ontario Provincial Government\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M8A\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M9A\n",
       "</td>\n",
       "<td>Etobicoke\n",
       "</td>\n",
       "<td>Islington Avenue, Humber Valley Village\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M1B\n",
       "</td>\n",
       "<td>Scarborough\n",
       "</td>\n",
       "<td>Malvern, Rouge\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M2B\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M3B\n",
       "</td>\n",
       "<td>North York\n",
       "</td>\n",
       "<td>Don Mills\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M4B\n",
       "</td>\n",
       "<td>East York\n",
       "</td>\n",
       "<td>Parkview Hill, Woodbine Gardens\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M5B\n",
       "</td>\n",
       "<td>Downtown Toronto\n",
       "</td>\n",
       "<td>Garden District, Ryerson\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M6B\n",
       "</td>\n",
       "<td>North York\n",
       "</td>\n",
       "<td>Glencairn\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M7B\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M8B\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M9B\n",
       "</td>\n",
       "<td>Etobicoke\n",
       "</td>\n",
       "<td>West Deane Park, Princess Gardens, Martin Grove, Islington, Cloverdale\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M1C\n",
       "</td>\n",
       "<td>Scarborough\n",
       "</td>\n",
       "<td>Rouge Hill, Port Union, Highland Creek\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M2C\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M3C\n",
       "</td>\n",
       "<td>North York\n",
       "</td>\n",
       "<td>Don Mills\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M4C\n",
       "</td>\n",
       "<td>East York\n",
       "</td>\n",
       "<td>Woodbine Heights\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M5C\n",
       "</td>\n",
       "<td>Downtown Toronto\n",
       "</td>\n",
       "<td>St. James Town\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M6C\n",
       "</td>\n",
       "<td>York\n",
       "</td>\n",
       "<td>Humewood-Cedarvale\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M7C\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M8C\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M9C\n",
       "</td>\n",
       "<td>Etobicoke\n",
       "</td>\n",
       "<td>Eringate, Bloordale Gardens, Old Burnhamthorpe, Markland Wood\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M1E\n",
       "</td>\n",
       "<td>Scarborough\n",
       "</td>\n",
       "<td>Guildwood, Morningside, West Hill\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M2E\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M3E\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M4E\n",
       "</td>\n",
       "<td>East Toronto\n",
       "</td>\n",
       "<td>The Beaches\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M5E\n",
       "</td>\n",
       "<td>Downtown Toronto\n",
       "</td>\n",
       "<td>Berczy Park\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M6E\n",
       "</td>\n",
       "<td>York\n",
       "</td>\n",
       "<td>Caledonia-Fairbanks\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M7E\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M8E\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M9E\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M1G\n",
       "</td>\n",
       "<td>Scarborough\n",
       "</td>\n",
       "<td>Woburn\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M2G\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M3G\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M4G\n",
       "</td>\n",
       "<td>East York\n",
       "</td>\n",
       "<td>Leaside\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M5G\n",
       "</td>\n",
       "<td>Downtown Toronto\n",
       "</td>\n",
       "<td>Central Bay Street\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M6G\n",
       "</td>\n",
       "<td>Downtown Toronto\n",
       "</td>\n",
       "<td>Christie\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M7G\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M8G\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M9G\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M1H\n",
       "</td>\n",
       "<td>Scarborough\n",
       "</td>\n",
       "<td>Cedarbrae\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M2H\n",
       "</td>\n",
       "<td>North York\n",
       "</td>\n",
       "<td>Hillcrest Village\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M3H\n",
       "</td>\n",
       "<td>North York\n",
       "</td>\n",
       "<td>Bathurst Manor, Wilson Heights, Downsview North\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M4H\n",
       "</td>\n",
       "<td>East York\n",
       "</td>\n",
       "<td>Thorncliffe Park\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M5H\n",
       "</td>\n",
       "<td>Downtown Toronto\n",
       "</td>\n",
       "<td>Richmond, Adelaide, King\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M6H\n",
       "</td>\n",
       "<td>West Toronto\n",
       "</td>\n",
       "<td>Dufferin, Dovercourt Village\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M7H\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M8H\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M9H\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M1J\n",
       "</td>\n",
       "<td>Scarborough\n",
       "</td>\n",
       "<td>Scarborough Village\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M2J\n",
       "</td>\n",
       "<td>North York\n",
       "</td>\n",
       "<td>Fairview, Henry Farm, Oriole\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M3J\n",
       "</td>\n",
       "<td>North York\n",
       "</td>\n",
       "<td>Northwood Park, York University\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M4J\n",
       "</td>\n",
       "<td>East York\n",
       "</td>\n",
       "<td>East Toronto, Broadview North (Old East York)\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M5J\n",
       "</td>\n",
       "<td>Downtown Toronto\n",
       "</td>\n",
       "<td>Harbourfront East, Union Station, Toronto Islands\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M6J\n",
       "</td>\n",
       "<td>West Toronto\n",
       "</td>\n",
       "<td>Little Portugal, Trinity\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M7J\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M8J\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M9J\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M1K\n",
       "</td>\n",
       "<td>Scarborough\n",
       "</td>\n",
       "<td>Kennedy Park, Ionview, East Birchmount Park\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M2K\n",
       "</td>\n",
       "<td>North York\n",
       "</td>\n",
       "<td>Bayview Village\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M3K\n",
       "</td>\n",
       "<td>North York\n",
       "</td>\n",
       "<td>Downsview\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M4K\n",
       "</td>\n",
       "<td>East Toronto\n",
       "</td>\n",
       "<td>The Danforth West, Riverdale\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M5K\n",
       "</td>\n",
       "<td>Downtown Toronto\n",
       "</td>\n",
       "<td>Toronto Dominion Centre, Design Exchange\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M6K\n",
       "</td>\n",
       "<td>West Toronto\n",
       "</td>\n",
       "<td>Brockton, Parkdale Village, Exhibition Place\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M7K\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M8K\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M9K\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M1L\n",
       "</td>\n",
       "<td>Scarborough\n",
       "</td>\n",
       "<td>Golden Mile, Clairlea, Oakridge\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M2L\n",
       "</td>\n",
       "<td>North York\n",
       "</td>\n",
       "<td>York Mills, Silver Hills\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M3L\n",
       "</td>\n",
       "<td>North York\n",
       "</td>\n",
       "<td>Downsview\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M4L\n",
       "</td>\n",
       "<td>East Toronto\n",
       "</td>\n",
       "<td>India Bazaar, The Beaches West\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M5L\n",
       "</td>\n",
       "<td>Downtown Toronto\n",
       "</td>\n",
       "<td>Commerce Court, Victoria Hotel\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M6L\n",
       "</td>\n",
       "<td>North York\n",
       "</td>\n",
       "<td>North Park, Maple Leaf Park, Upwood Park\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M7L\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M8L\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M9L\n",
       "</td>\n",
       "<td>North York\n",
       "</td>\n",
       "<td>Humber Summit\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M1M\n",
       "</td>\n",
       "<td>Scarborough\n",
       "</td>\n",
       "<td>Cliffside, Cliffcrest, Scarborough Village West\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M2M\n",
       "</td>\n",
       "<td>North York\n",
       "</td>\n",
       "<td>Willowdale, Newtonbrook\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M3M\n",
       "</td>\n",
       "<td>North York\n",
       "</td>\n",
       "<td>Downsview\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M4M\n",
       "</td>\n",
       "<td>East Toronto\n",
       "</td>\n",
       "<td>Studio District\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M5M\n",
       "</td>\n",
       "<td>North York\n",
       "</td>\n",
       "<td>Bedford Park, Lawrence Manor East\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M6M\n",
       "</td>\n",
       "<td>York\n",
       "</td>\n",
       "<td>Del Ray, Mount Dennis, Keelsdale and Silverthorn\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M7M\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M8M\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M9M\n",
       "</td>\n",
       "<td>North York\n",
       "</td>\n",
       "<td>Humberlea, Emery\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M1N\n",
       "</td>\n",
       "<td>Scarborough\n",
       "</td>\n",
       "<td>Birch Cliff, Cliffside West\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M2N\n",
       "</td>\n",
       "<td>North York\n",
       "</td>\n",
       "<td>Willowdale, Willowdale East\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M3N\n",
       "</td>\n",
       "<td>North York\n",
       "</td>\n",
       "<td>Downsview\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M4N\n",
       "</td>\n",
       "<td>Central Toronto\n",
       "</td>\n",
       "<td>Lawrence Park\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M5N\n",
       "</td>\n",
       "<td>Central Toronto\n",
       "</td>\n",
       "<td>Roselawn\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M6N\n",
       "</td>\n",
       "<td>York\n",
       "</td>\n",
       "<td>Runnymede, The Junction North\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M7N\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M8N\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M9N\n",
       "</td>\n",
       "<td>York\n",
       "</td>\n",
       "<td>Weston\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M1P\n",
       "</td>\n",
       "<td>Scarborough\n",
       "</td>\n",
       "<td>Dorset Park, Wexford Heights, Scarborough Town Centre\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M2P\n",
       "</td>\n",
       "<td>North York\n",
       "</td>\n",
       "<td>York Mills West\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M3P\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M4P\n",
       "</td>\n",
       "<td>Central Toronto\n",
       "</td>\n",
       "<td>Davisville North\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M5P\n",
       "</td>\n",
       "<td>Central Toronto\n",
       "</td>\n",
       "<td>Forest Hill North &amp; West, Forest Hill Road Park\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M6P\n",
       "</td>\n",
       "<td>West Toronto\n",
       "</td>\n",
       "<td>High Park, The Junction South\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M7P\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M8P\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M9P\n",
       "</td>\n",
       "<td>Etobicoke\n",
       "</td>\n",
       "<td>Westmount\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M1R\n",
       "</td>\n",
       "<td>Scarborough\n",
       "</td>\n",
       "<td>Wexford, Maryvale\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M2R\n",
       "</td>\n",
       "<td>North York\n",
       "</td>\n",
       "<td>Willowdale, Willowdale West\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M3R\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M4R\n",
       "</td>\n",
       "<td>Central Toronto\n",
       "</td>\n",
       "<td>North Toronto West,  Lawrence Park\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M5R\n",
       "</td>\n",
       "<td>Central Toronto\n",
       "</td>\n",
       "<td>The Annex, North Midtown, Yorkville\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M6R\n",
       "</td>\n",
       "<td>West Toronto\n",
       "</td>\n",
       "<td>Parkdale, Roncesvalles\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M7R\n",
       "</td>\n",
       "<td>Mississauga\n",
       "</td>\n",
       "<td>Canada Post Gateway Processing Centre\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M8R\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M9R\n",
       "</td>\n",
       "<td>Etobicoke\n",
       "</td>\n",
       "<td>Kingsview Village, St. Phillips, Martin Grove Gardens, Richview Gardens\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M1S\n",
       "</td>\n",
       "<td>Scarborough\n",
       "</td>\n",
       "<td>Agincourt\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M2S\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M3S\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M4S\n",
       "</td>\n",
       "<td>Central Toronto\n",
       "</td>\n",
       "<td>Davisville\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M5S\n",
       "</td>\n",
       "<td>Downtown Toronto\n",
       "</td>\n",
       "<td>University of Toronto, Harbord\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M6S\n",
       "</td>\n",
       "<td>West Toronto\n",
       "</td>\n",
       "<td>Runnymede, Swansea\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M7S\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M8S\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M9S\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M1T\n",
       "</td>\n",
       "<td>Scarborough\n",
       "</td>\n",
       "<td>Clarks Corners, Tam O'Shanter, Sullivan\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M2T\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M3T\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M4T\n",
       "</td>\n",
       "<td>Central Toronto\n",
       "</td>\n",
       "<td>Moore Park, Summerhill East\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M5T\n",
       "</td>\n",
       "<td>Downtown Toronto\n",
       "</td>\n",
       "<td>Kensington Market, Chinatown, Grange Park\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M6T\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M7T\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M8T\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M9T\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M1V\n",
       "</td>\n",
       "<td>Scarborough\n",
       "</td>\n",
       "<td>Milliken, Agincourt North, Steeles East, L'Amoreaux East\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M2V\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M3V\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M4V\n",
       "</td>\n",
       "<td>Central Toronto\n",
       "</td>\n",
       "<td>Summerhill West, Rathnelly, South Hill, Forest Hill SE, Deer Park\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M5V\n",
       "</td>\n",
       "<td>Downtown Toronto\n",
       "</td>\n",
       "<td>CN Tower, King and Spadina, Railway Lands, Harbourfront West, Bathurst Quay, South Niagara, Island airport\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M6V\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M7V\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M8V\n",
       "</td>\n",
       "<td>Etobicoke\n",
       "</td>\n",
       "<td>New Toronto, Mimico South, Humber Bay Shores\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M9V\n",
       "</td>\n",
       "<td>Etobicoke\n",
       "</td>\n",
       "<td>South Steeles, Silverstone, Humbergate, Jamestown, Mount Olive, Beaumond Heights, Thistletown, Albion Gardens\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M1W\n",
       "</td>\n",
       "<td>Scarborough\n",
       "</td>\n",
       "<td>Steeles West, L'Amoreaux West\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M2W\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M3W\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M4W\n",
       "</td>\n",
       "<td>Downtown Toronto\n",
       "</td>\n",
       "<td>Rosedale\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M5W\n",
       "</td>\n",
       "<td>Downtown Toronto\n",
       "</td>\n",
       "<td>Stn A PO Boxes\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M6W\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M7W\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M8W\n",
       "</td>\n",
       "<td>Etobicoke\n",
       "</td>\n",
       "<td>Alderwood, Long Branch\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M9W\n",
       "</td>\n",
       "<td>Etobicoke\n",
       "</td>\n",
       "<td>Northwest, West Humber - Clairville\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M1X\n",
       "</td>\n",
       "<td>Scarborough\n",
       "</td>\n",
       "<td>Upper Rouge\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M2X\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M3X\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M4X\n",
       "</td>\n",
       "<td>Downtown Toronto\n",
       "</td>\n",
       "<td>St. James Town, Cabbagetown\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M5X\n",
       "</td>\n",
       "<td>Downtown Toronto\n",
       "</td>\n",
       "<td>First Canadian Place, Underground city\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M6X\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M7X\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M8X\n",
       "</td>\n",
       "<td>Etobicoke\n",
       "</td>\n",
       "<td>The Kingsway, Montgomery Road, Old Mill North\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M9X\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M1Y\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M2Y\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M3Y\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M4Y\n",
       "</td>\n",
       "<td>Downtown Toronto\n",
       "</td>\n",
       "<td>Church and Wellesley\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M5Y\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M6Y\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M7Y\n",
       "</td>\n",
       "<td>East Toronto\n",
       "</td>\n",
       "<td>Business reply mail Processing Centre, South Central Letter Processing Plant Toronto\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M8Y\n",
       "</td>\n",
       "<td>Etobicoke\n",
       "</td>\n",
       "<td>Old Mill South, King's Mill Park, Sunnylea, Humber Bay, Mimico NE, The Queensway East, Royal York South East, Kingsway Park South East\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M9Y\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M1Z\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M2Z\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M3Z\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M4Z\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M5Z\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M6Z\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M7Z\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M8Z\n",
       "</td>\n",
       "<td>Etobicoke\n",
       "</td>\n",
       "<td>Mimico NW, The Queensway West, South of Bloor, Kingsway Park South West, Royal York South West\n",
       "</td></tr>\n",
       "<tr>\n",
       "<td>M9Z\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td>\n",
       "<td>Not assigned\n",
       "</td></tr></tbody></table>"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Table = soup.find('table',{'class':\"wikitable sortable\"})\n",
    "Table"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Using a For Loop to create the table. Fields has been assigned to the varial Table and the find all function has been used to find all characters within the td range"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "fields = Table.find_all('td')\n",
    "\n",
    "postcode = []\n",
    "borough = []\n",
    "neighborhood = []\n",
    "\n",
    "for i in range(0, len(fields), 3):\n",
    "    postcode.append(fields[i].text.strip())\n",
    "    borough.append(fields[i+1].text.strip())\n",
    "    neighborhood.append(fields[i+2].text.strip())\n",
    "        \n",
    "Df = pd.DataFrame(data=[postcode, borough, neighborhood]).transpose()\n",
    "Df.columns = ['Postcode', 'Borough', 'Neighborhood']\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 180 entries, 0 to 179\n",
      "Data columns (total 3 columns):\n",
      " #   Column        Non-Null Count  Dtype \n",
      "---  ------        --------------  ----- \n",
      " 0   Postcode      180 non-null    object\n",
      " 1   Borough       180 non-null    object\n",
      " 2   Neighborhood  180 non-null    object\n",
      "dtypes: object(3)\n",
      "memory usage: 4.3+ KB\n"
     ]
    }
   ],
   "source": [
    "Df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Postcode</th>\n",
       "      <th>Borough</th>\n",
       "      <th>Neighborhood</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>Regent Park, Harbourfront</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>M6A</td>\n",
       "      <td>North York</td>\n",
       "      <td>Lawrence Manor, Lawrence Heights</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>M7A</td>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>Queen's Park, Ontario Provincial Government</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>M8A</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Not assigned</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>M9A</td>\n",
       "      <td>Etobicoke</td>\n",
       "      <td>Islington Avenue, Humber Valley Village</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>M1B</td>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Malvern, Rouge</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Postcode           Borough                                 Neighborhood\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                    Regent Park, Harbourfront\n",
       "5      M6A        North York             Lawrence Manor, Lawrence Heights\n",
       "6      M7A  Downtown Toronto  Queen's Park, Ontario Provincial Government\n",
       "7      M8A               NaN                                 Not assigned\n",
       "8      M9A         Etobicoke      Islington Avenue, Humber Valley Village\n",
       "9      M1B       Scarborough                               Malvern, Rouge"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Df['Borough'].replace('Not assigned', np.nan, inplace=True)\n",
    "\n",
    "\n",
    "Df.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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>Neighborhood</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>M1A</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>M2A</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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>Regent Park, Harbourfront</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Postcode           Borough               Neighborhood\n",
       "0      M1A               NaN                        NaN\n",
       "1      M2A               NaN                        NaN\n",
       "2      M3A        North York                  Parkwoods\n",
       "3      M4A        North York           Victoria Village\n",
       "4      M5A  Downtown Toronto  Regent Park, Harbourfront"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Df['Neighborhood'].replace('Not assigned', np.nan, inplace=True)\n",
    "\n",
    "Df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<font size=\"4\"> Drop Nan Values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "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>Neighborhood</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>Regent Park, Harbourfront</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>M6A</td>\n",
       "      <td>North York</td>\n",
       "      <td>Lawrence Manor, Lawrence Heights</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>M7A</td>\n",
       "      <td>Downtown Toronto</td>\n",
       "      <td>Queen's Park, Ontario Provincial Government</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Postcode           Borough                                 Neighborhood\n",
       "2      M3A        North York                                    Parkwoods\n",
       "3      M4A        North York                             Victoria Village\n",
       "4      M5A  Downtown Toronto                    Regent Park, Harbourfront\n",
       "5      M6A        North York             Lawrence Manor, Lawrence Heights\n",
       "6      M7A  Downtown Toronto  Queen's Park, Ontario Provincial Government"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Df.dropna(inplace=True)\n",
    "Df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# using join operator to attach different strings together"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [],
   "source": [
    "df1 = Df.groupby(['Postcode', 'Borough'])['Neighborhood'].apply(\",\".join).reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {
    "scrolled": false
   },
   "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>Neighborhood</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>M1B</td>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Malvern, Rouge</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>M1C</td>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Rouge Hill, Port Union, Highland Creek</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>M1E</td>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Guildwood, Morningside, West Hill</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>M1G</td>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Woburn</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>M1H</td>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Cedarbrae</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>M1J</td>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Scarborough Village</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>M1K</td>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Kennedy Park, Ionview, East Birchmount Park</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>M1L</td>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Golden Mile, Clairlea, Oakridge</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>M1M</td>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Cliffside, Cliffcrest, Scarborough Village West</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>M1N</td>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Birch Cliff, Cliffside West</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Postcode      Borough                                     Neighborhood\n",
       "0      M1B  Scarborough                                   Malvern, Rouge\n",
       "1      M1C  Scarborough           Rouge Hill, Port Union, Highland Creek\n",
       "2      M1E  Scarborough                Guildwood, Morningside, West Hill\n",
       "3      M1G  Scarborough                                           Woburn\n",
       "4      M1H  Scarborough                                        Cedarbrae\n",
       "5      M1J  Scarborough                              Scarborough Village\n",
       "6      M1K  Scarborough      Kennedy Park, Ionview, East Birchmount Park\n",
       "7      M1L  Scarborough                  Golden Mile, Clairlea, Oakridge\n",
       "8      M1M  Scarborough  Cliffside, Cliffcrest, Scarborough Village West\n",
       "9      M1N  Scarborough                      Birch Cliff, Cliffside West"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "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>Borough</th>\n",
       "      <th>Neighborhood</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>M1B</td>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Malvern, Rouge</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>M1C</td>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Rouge Hill, Port Union, Highland Creek</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>M1E</td>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Guildwood, Morningside, West Hill</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>M1G</td>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Woburn</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>M1H</td>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Cedarbrae</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Postal Code      Borough                            Neighborhood\n",
       "0         M1B  Scarborough                          Malvern, Rouge\n",
       "1         M1C  Scarborough  Rouge Hill, Port Union, Highland Creek\n",
       "2         M1E  Scarborough       Guildwood, Morningside, West Hill\n",
       "3         M1G  Scarborough                                  Woburn\n",
       "4         M1H  Scarborough                               Cedarbrae"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1= df1.rename({'Postcode':'Postal Code'}, axis=1)\n",
    "df1.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(103, 3)"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "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>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</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",
       "..          ...        ...        ...\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": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "df2= pd.read_csv('Geospatial_Coordinates (1).csv')\n",
    "df2"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Now We're Going To Merge DF1 and DF2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "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>Borough</th>\n",
       "      <th>Neighborhood</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>Scarborough</td>\n",
       "      <td>Malvern, Rouge</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>Scarborough</td>\n",
       "      <td>Rouge Hill, Port Union, Highland Creek</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>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>3</th>\n",
       "      <td>M1G</td>\n",
       "      <td>Scarborough</td>\n",
       "      <td>Woburn</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>Scarborough</td>\n",
       "      <td>Cedarbrae</td>\n",
       "      <td>43.773136</td>\n",
       "      <td>-79.239476</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>M9N</td>\n",
       "      <td>York</td>\n",
       "      <td>Weston</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>Etobicoke</td>\n",
       "      <td>Westmount</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>Etobicoke</td>\n",
       "      <td>Kingsview Village, St. Phillips, Martin Grove ...</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>Etobicoke</td>\n",
       "      <td>South Steeles, Silverstone, Humbergate, Jamest...</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>Etobicoke</td>\n",
       "      <td>Northwest, West Humber - Clairville</td>\n",
       "      <td>43.706748</td>\n",
       "      <td>-79.594054</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>103 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Postal Code      Borough  \\\n",
       "0           M1B  Scarborough   \n",
       "1           M1C  Scarborough   \n",
       "2           M1E  Scarborough   \n",
       "3           M1G  Scarborough   \n",
       "4           M1H  Scarborough   \n",
       "..          ...          ...   \n",
       "98          M9N         York   \n",
       "99          M9P    Etobicoke   \n",
       "100         M9R    Etobicoke   \n",
       "101         M9V    Etobicoke   \n",
       "102         M9W    Etobicoke   \n",
       "\n",
       "                                          Neighborhood   Latitude  Longitude  \n",
       "0                                       Malvern, Rouge  43.806686 -79.194353  \n",
       "1               Rouge Hill, Port Union, Highland Creek  43.784535 -79.160497  \n",
       "2                    Guildwood, Morningside, West Hill  43.763573 -79.188711  \n",
       "3                                               Woburn  43.770992 -79.216917  \n",
       "4                                            Cedarbrae  43.773136 -79.239476  \n",
       "..                                                 ...        ...        ...  \n",
       "98                                              Weston  43.706876 -79.518188  \n",
       "99                                           Westmount  43.696319 -79.532242  \n",
       "100  Kingsview Village, St. Phillips, Martin Grove ...  43.688905 -79.554724  \n",
       "101  South Steeles, Silverstone, Humbergate, Jamest...  43.739416 -79.588437  \n",
       "102                Northwest, West Humber - Clairville  43.706748 -79.594054  \n",
       "\n",
       "[103 rows x 5 columns]"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3= pd.merge(df1,df2,on=\"Postal Code\",how='outer')\n",
    "df3"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}