Peer-graded Assignment Part 2.ipynb

{
    "nbformat_minor": 1, 
    "cells": [
        {
            "source": "# Peer-graded Assignment: Part 2", 
            "cell_type": "markdown", 
            "metadata": {
                "collapsed": true
            }
        }, 
        {
            "source": "### Importing the libraries needed", 
            "cell_type": "markdown", 
            "metadata": {}
        }, 
        {
            "execution_count": 76, 
            "cell_type": "code", 
            "metadata": {}, 
            "outputs": [], 
            "source": "import pandas as pd # library for data analsysis\nimport requests as request # library to handle requests\npd.set_option('display.max_columns', None)\npd.set_option('display.max_rows', None)"
        }, 
        {
            "source": "### Adding BeautifulSoup library for grabbing the text from the website", 
            "cell_type": "markdown", 
            "metadata": {}
        }, 
        {
            "execution_count": 69, 
            "cell_type": "code", 
            "metadata": {}, 
            "outputs": [
                {
                    "output_type": "stream", 
                    "name": "stdout", 
                    "text": "Requirement not upgraded as not directly required: beautifulsoup4 in /opt/conda/envs/DSX-Python35/lib/python3.5/site-packages\nRequirement not upgraded as not directly required: lxml in /opt/conda/envs/DSX-Python35/lib/python3.5/site-packages\n"
                }
            ], 
            "source": "!pip install beautifulsoup4\n!pip install lxml\nfrom bs4 import BeautifulSoup"
        }, 
        {
            "source": "### Grabbing the text from the website and adding it into an array for later use", 
            "cell_type": "markdown", 
            "metadata": {}
        }, 
        {
            "execution_count": 70, 
            "cell_type": "code", 
            "metadata": {}, 
            "outputs": [], 
            "source": "wikipedia_link = \"https://en.wikipedia.org/wiki/List_of_postal_codes_of_Canada:_M\"\nsource = request.get(wikipedia_link).text\nsoup = BeautifulSoup(source, 'lxml')\ntable = soup.find('table')\n\nrows = []\nfor row in table.findAll('tr'):\n    for cell in row.findAll('td'):\n        pincode = cell.p.b.text\n        for index, details in enumerate(cell.findAll('a')):\n            if index == 0:\n                borough = details.string\n                neighborhood = ''\n            elif index == 1:\n                neighborhood = details.string\n            else:\n                neighborhood = neighborhood + ', ' + details.string\n            if (index == len(cell.findAll('a')) - 1):\n                if index == 0:\n                    neighborhood = borough\n                try: \n                    row = [pincode, borough, neighborhood]\n                    rows.append(row)\n                except:\n                    pass"
        }, 
        {
            "source": "### Initializing a dataframe 'neighborhood_df' and adding the data from the rows array", 
            "cell_type": "markdown", 
            "metadata": {}
        }, 
        {
            "execution_count": 71, 
            "cell_type": "code", 
            "metadata": {}, 
            "outputs": [
                {
                    "execution_count": 71, 
                    "metadata": {}, 
                    "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>PostalCode</th>\n      <th>Borough</th>\n      <th>Neighborhood</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>Regent Park, Harbourfront</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>M6A</td>\n      <td>North York</td>\n      <td>Lawrence Manor, Lawrence Heights</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  </tbody>\n</table>\n</div>", 
                        "text/plain": "  PostalCode           Borough                      Neighborhood\n0        M3A        North York                         Parkwoods\n1        M4A        North York                  Victoria Village\n2        M5A  Downtown Toronto         Regent Park, Harbourfront\n3        M6A        North York  Lawrence Manor, Lawrence Heights\n4        M7A      Queen's Park                      Queen's Park"
                    }, 
                    "output_type": "execute_result"
                }
            ], 
            "source": "column_names = ['PostalCode', 'Borough', 'Neighborhood'] \n\n# instantiate the dataframe\nneighborhood_df = pd.DataFrame(rows, columns=column_names)\nneighborhood_df.head()"
        }, 
        {
            "execution_count": 72, 
            "cell_type": "code", 
            "metadata": {}, 
            "outputs": [
                {
                    "execution_count": 72, 
                    "metadata": {}, 
                    "data": {
                        "text/plain": "(101, 3)"
                    }, 
                    "output_type": "execute_result"
                }
            ], 
            "source": "neighborhood_df.shape"
        }, 
        {
            "execution_count": 73, 
            "cell_type": "code", 
            "metadata": {}, 
            "outputs": [], 
            "source": "# The code was removed by Watson Studio for sharing."
        }, 
        {
            "source": "### Performed Google API call to convert address tp latitude and longitude", 
            "cell_type": "markdown", 
            "metadata": {}
        }, 
        {
            "execution_count": 74, 
            "cell_type": "code", 
            "metadata": {}, 
            "outputs": [], 
            "source": "for index, row in neighborhood_df.iterrows():\n    url = 'https://maps.googleapis.com/maps/api/geocode/json?key={}&address={}'.format(API_key, str(str(row['Neighborhood']) + \" \" + str(row['Borough']) + \" \" + str(row['PostalCode'])).replace(\" \", \"%20\") )\n    response = request.get(url).json() # get response\n    geographical_data = response['results'][0]['geometry']['location'] # get geographical coordinates\n    latitude = geographical_data['lat']\n    longitude = geographical_data['lng']\n    neighborhood_df.loc[index,'Latitude'] = latitude \n    neighborhood_df.loc[index,'Longitude'] = longitude "
        }, 
        {
            "execution_count": 78, 
            "cell_type": "code", 
            "metadata": {}, 
            "outputs": [
                {
                    "execution_count": 78, 
                    "metadata": {}, 
                    "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>PostalCode</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>M3A</td>\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>1</th>\n      <td>M4A</td>\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>2</th>\n      <td>M5A</td>\n      <td>Downtown Toronto</td>\n      <td>Regent Park, Harbourfront</td>\n      <td>43.659343</td>\n      <td>-79.365525</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>M6A</td>\n      <td>North York</td>\n      <td>Lawrence Manor, Lawrence Heights</td>\n      <td>43.722774</td>\n      <td>-79.450928</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      <td>43.662843</td>\n      <td>-79.389638</td>\n    </tr>\n    <tr>\n      <th>5</th>\n      <td>M9A</td>\n      <td>Etobicoke</td>\n      <td>Islington Avenue</td>\n      <td>43.680233</td>\n      <td>-79.539081</td>\n    </tr>\n    <tr>\n      <th>6</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>7</th>\n      <td>M3B</td>\n      <td>North York</td>\n      <td>Don Mills</td>\n      <td>43.745906</td>\n      <td>-79.352188</td>\n    </tr>\n    <tr>\n      <th>8</th>\n      <td>M4B</td>\n      <td>East York</td>\n      <td>Parkview Hill, Woodbine Gardens</td>\n      <td>43.706139</td>\n      <td>-79.325415</td>\n    </tr>\n    <tr>\n      <th>9</th>\n      <td>M5B</td>\n      <td>Downtown Toronto</td>\n      <td>Garden District, Ryerson</td>\n      <td>43.657658</td>\n      <td>-79.378802</td>\n    </tr>\n    <tr>\n      <th>10</th>\n      <td>M6B</td>\n      <td>North York</td>\n      <td>North York</td>\n      <td>43.761538</td>\n      <td>-79.411079</td>\n    </tr>\n    <tr>\n      <th>11</th>\n      <td>M9B</td>\n      <td>Etobicoke</td>\n      <td>West Deane Park, Princess Gardens, Martin Grov...</td>\n      <td>43.721323</td>\n      <td>-79.584571</td>\n    </tr>\n    <tr>\n      <th>12</th>\n      <td>M1C</td>\n      <td>Scarborough</td>\n      <td>Rouge Hill, Port Union, Highland Creek</td>\n      <td>43.780707</td>\n      <td>-79.130264</td>\n    </tr>\n    <tr>\n      <th>13</th>\n      <td>M3C</td>\n      <td>North York</td>\n      <td>Don Mills, Flemingdon Park</td>\n      <td>43.715718</td>\n      <td>-79.337017</td>\n    </tr>\n    <tr>\n      <th>14</th>\n      <td>M4C</td>\n      <td>East York</td>\n      <td>Woodbine Heights</td>\n      <td>43.693328</td>\n      <td>-79.316064</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      <td>43.668195</td>\n      <td>-79.373771</td>\n    </tr>\n    <tr>\n      <th>16</th>\n      <td>M6C</td>\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>17</th>\n      <td>M9C</td>\n      <td>Etobicoke</td>\n      <td>Markland Wood</td>\n      <td>43.632036</td>\n      <td>-79.575140</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      <td>43.753240</td>\n      <td>-79.179809</td>\n    </tr>\n    <tr>\n      <th>19</th>\n      <td>M4E</td>\n      <td>The Beaches</td>\n      <td>The Beaches</td>\n      <td>43.676357</td>\n      <td>-79.293031</td>\n    </tr>\n    <tr>\n      <th>20</th>\n      <td>M5E</td>\n      <td>Downtown Toronto</td>\n      <td>Downtown Toronto</td>\n      <td>43.644771</td>\n      <td>-79.373306</td>\n    </tr>\n    <tr>\n      <th>21</th>\n      <td>M6E</td>\n      <td>York</td>\n      <td>Caledonia-Fairbanks</td>\n      <td>43.686916</td>\n      <td>-79.456325</td>\n    </tr>\n    <tr>\n      <th>22</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>23</th>\n      <td>M4G</td>\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>24</th>\n      <td>M5G</td>\n      <td>Downtown Toronto</td>\n      <td>Bay Street</td>\n      <td>43.655854</td>\n      <td>-79.383778</td>\n    </tr>\n    <tr>\n      <th>25</th>\n      <td>M6G</td>\n      <td>Downtown Toronto</td>\n      <td>Downtown Toronto</td>\n      <td>43.669542</td>\n      <td>-79.422564</td>\n    </tr>\n    <tr>\n      <th>26</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>27</th>\n      <td>M2H</td>\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>28</th>\n      <td>M3H</td>\n      <td>North York</td>\n      <td>Bathurst Manor, Wilson Heights, Downsview</td>\n      <td>43.748145</td>\n      <td>-79.454649</td>\n    </tr>\n    <tr>\n      <th>29</th>\n      <td>M4H</td>\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>30</th>\n      <td>M5H</td>\n      <td>Downtown Toronto</td>\n      <td>Richmond, King</td>\n      <td>43.648918</td>\n      <td>-79.378169</td>\n    </tr>\n    <tr>\n      <th>31</th>\n      <td>M6H</td>\n      <td>Dufferin</td>\n      <td>Dovercourt Village</td>\n      <td>43.660854</td>\n      <td>-79.429393</td>\n    </tr>\n    <tr>\n      <th>32</th>\n      <td>M1J</td>\n      <td>Scarborough</td>\n      <td>Scarborough Village</td>\n      <td>43.744734</td>\n      <td>-79.239476</td>\n    </tr>\n    <tr>\n      <th>33</th>\n      <td>M2J</td>\n      <td>North York</td>\n      <td>Henry Farm</td>\n      <td>43.771782</td>\n      <td>-79.352086</td>\n    </tr>\n    <tr>\n      <th>34</th>\n      <td>M3J</td>\n      <td>North York</td>\n      <td>Northwood Park, York University</td>\n      <td>43.773454</td>\n      <td>-79.501868</td>\n    </tr>\n    <tr>\n      <th>35</th>\n      <td>M4J</td>\n      <td>East York</td>\n      <td>The Danforth</td>\n      <td>43.685347</td>\n      <td>-79.338106</td>\n    </tr>\n    <tr>\n      <th>36</th>\n      <td>M5J</td>\n      <td>Downtown Toronto</td>\n      <td>Harbourfront, Union Station, Toronto Islands</td>\n      <td>43.638702</td>\n      <td>-79.385741</td>\n    </tr>\n    <tr>\n      <th>37</th>\n      <td>M6J</td>\n      <td>Little Portugal</td>\n      <td>Trinity</td>\n      <td>43.647927</td>\n      <td>-79.419750</td>\n    </tr>\n    <tr>\n      <th>38</th>\n      <td>M1K</td>\n      <td>Scarborough</td>\n      <td>Kennedy Park, Ionview, Birchmount Park</td>\n      <td>43.730886</td>\n      <td>-79.278118</td>\n    </tr>\n    <tr>\n      <th>39</th>\n      <td>M2K</td>\n      <td>North York</td>\n      <td>Bayview Village</td>\n      <td>43.786947</td>\n      <td>-79.385975</td>\n    </tr>\n    <tr>\n      <th>40</th>\n      <td>M3K</td>\n      <td>North York</td>\n      <td>Downsview, CFB Toronto</td>\n      <td>43.743649</td>\n      <td>-79.465901</td>\n    </tr>\n    <tr>\n      <th>41</th>\n      <td>M4K</td>\n      <td>The Danforth</td>\n      <td>Riverdale</td>\n      <td>43.679557</td>\n      <td>-79.352188</td>\n    </tr>\n    <tr>\n      <th>42</th>\n      <td>M5K</td>\n      <td>Downtown Toronto</td>\n      <td>Toronto Dominion Centre, Design Exchange</td>\n      <td>43.647693</td>\n      <td>-79.380330</td>\n    </tr>\n    <tr>\n      <th>43</th>\n      <td>M6K</td>\n      <td>Brockton</td>\n      <td>Parkdale Village, Exhibition Place</td>\n      <td>43.636847</td>\n      <td>-79.428191</td>\n    </tr>\n    <tr>\n      <th>44</th>\n      <td>M1L</td>\n      <td>Scarborough</td>\n      <td>Golden Mile, Clairlea, Oakridge</td>\n      <td>43.718496</td>\n      <td>-79.291427</td>\n    </tr>\n    <tr>\n      <th>45</th>\n      <td>M2L</td>\n      <td>North York</td>\n      <td>York Mills</td>\n      <td>43.757490</td>\n      <td>-79.374714</td>\n    </tr>\n    <tr>\n      <th>46</th>\n      <td>M3L</td>\n      <td>North York</td>\n      <td>Downsview</td>\n      <td>43.739015</td>\n      <td>-79.506944</td>\n    </tr>\n    <tr>\n      <th>47</th>\n      <td>M4L</td>\n      <td>India Bazaar</td>\n      <td>The Beaches</td>\n      <td>43.672341</td>\n      <td>-79.322543</td>\n    </tr>\n    <tr>\n      <th>48</th>\n      <td>M5L</td>\n      <td>Downtown Toronto</td>\n      <td>Commerce Court, Victoria Hotel</td>\n      <td>43.647906</td>\n      <td>-79.378065</td>\n    </tr>\n    <tr>\n      <th>49</th>\n      <td>M6L</td>\n      <td>North York</td>\n      <td>Maple Leaf Park</td>\n      <td>43.715895</td>\n      <td>-79.493079</td>\n    </tr>\n    <tr>\n      <th>50</th>\n      <td>M9L</td>\n      <td>North York</td>\n      <td>Humber Summit</td>\n      <td>43.756303</td>\n      <td>-79.565963</td>\n    </tr>\n    <tr>\n      <th>51</th>\n      <td>M1M</td>\n      <td>Scarborough</td>\n      <td>Cliffside, Cliffcrest, Scarborough Village</td>\n      <td>43.712217</td>\n      <td>-79.244001</td>\n    </tr>\n    <tr>\n      <th>52</th>\n      <td>M2M</td>\n      <td>North York</td>\n      <td>Newtonbrook</td>\n      <td>43.789053</td>\n      <td>-79.408493</td>\n    </tr>\n    <tr>\n      <th>53</th>\n      <td>M3M</td>\n      <td>North York</td>\n      <td>Downsview</td>\n      <td>43.728496</td>\n      <td>-79.495697</td>\n    </tr>\n    <tr>\n      <th>54</th>\n      <td>M5M</td>\n      <td>North York</td>\n      <td>Bedford Park, Lawrence Manor</td>\n      <td>43.733283</td>\n      <td>-79.419750</td>\n    </tr>\n    <tr>\n      <th>55</th>\n      <td>M6M</td>\n      <td>York</td>\n      <td>Mount Dennis, Keelsdale and Silverthorn</td>\n      <td>43.687907</td>\n      <td>-79.484485</td>\n    </tr>\n    <tr>\n      <th>56</th>\n      <td>M9M</td>\n      <td>North York</td>\n      <td>Humberlea, Emery</td>\n      <td>43.748514</td>\n      <td>-79.538591</td>\n    </tr>\n    <tr>\n      <th>57</th>\n      <td>M1N</td>\n      <td>Scarborough</td>\n      <td>Birch Cliff, Cliffside</td>\n      <td>43.704466</td>\n      <td>-79.247048</td>\n    </tr>\n    <tr>\n      <th>58</th>\n      <td>M2N</td>\n      <td>North York</td>\n      <td>Willowdale</td>\n      <td>43.770120</td>\n      <td>-79.408493</td>\n    </tr>\n    <tr>\n      <th>59</th>\n      <td>M3N</td>\n      <td>North York</td>\n      <td>Downsview</td>\n      <td>43.761631</td>\n      <td>-79.520999</td>\n    </tr>\n    <tr>\n      <th>60</th>\n      <td>M4N</td>\n      <td>Lawrence Park</td>\n      <td>Lawrence Park</td>\n      <td>43.723282</td>\n      <td>-79.388790</td>\n    </tr>\n    <tr>\n      <th>61</th>\n      <td>M6N</td>\n      <td>York</td>\n      <td>Runnymede, The Junction</td>\n      <td>43.665260</td>\n      <td>-79.481982</td>\n    </tr>\n    <tr>\n      <th>62</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>63</th>\n      <td>M1P</td>\n      <td>Scarborough</td>\n      <td>Dorset Park, Wexford Heights, Scarborough Town...</td>\n      <td>43.754001</td>\n      <td>-79.282117</td>\n    </tr>\n    <tr>\n      <th>64</th>\n      <td>M2P</td>\n      <td>North York</td>\n      <td>York Mills</td>\n      <td>43.752758</td>\n      <td>-79.400049</td>\n    </tr>\n    <tr>\n      <th>65</th>\n      <td>M4P</td>\n      <td>Davisville</td>\n      <td>Davisville</td>\n      <td>43.712751</td>\n      <td>-79.390197</td>\n    </tr>\n    <tr>\n      <th>66</th>\n      <td>M5P</td>\n      <td>Forest Hill</td>\n      <td>Forest Hill</td>\n      <td>43.686103</td>\n      <td>-79.412204</td>\n    </tr>\n    <tr>\n      <th>67</th>\n      <td>M6P</td>\n      <td>High Park</td>\n      <td>The Junction</td>\n      <td>43.665588</td>\n      <td>-79.470055</td>\n    </tr>\n    <tr>\n      <th>68</th>\n      <td>M9P</td>\n      <td>Etobicoke</td>\n      <td>Etobicoke</td>\n      <td>43.696319</td>\n      <td>-79.532242</td>\n    </tr>\n    <tr>\n      <th>69</th>\n      <td>M1R</td>\n      <td>Scarborough</td>\n      <td>Wexford, Maryvale</td>\n      <td>43.750071</td>\n      <td>-79.295849</td>\n    </tr>\n    <tr>\n      <th>70</th>\n      <td>M2R</td>\n      <td>North York</td>\n      <td>Willowdale</td>\n      <td>43.782736</td>\n      <td>-79.442259</td>\n    </tr>\n    <tr>\n      <th>71</th>\n      <td>M4R</td>\n      <td>North Toronto</td>\n      <td>North Toronto</td>\n      <td>43.715383</td>\n      <td>-79.405678</td>\n    </tr>\n    <tr>\n      <th>72</th>\n      <td>M5R</td>\n      <td>The Annex</td>\n      <td>North Midtown, Yorkville</td>\n      <td>43.670749</td>\n      <td>-79.393040</td>\n    </tr>\n    <tr>\n      <th>73</th>\n      <td>M6R</td>\n      <td>Parkdale</td>\n      <td>Roncesvalles</td>\n      <td>43.648960</td>\n      <td>-79.456325</td>\n    </tr>\n    <tr>\n      <th>74</th>\n      <td>M7R</td>\n      <td>Mississauga</td>\n      <td>Mississauga</td>\n      <td>43.636966</td>\n      <td>-79.615819</td>\n    </tr>\n    <tr>\n      <th>75</th>\n      <td>M9R</td>\n      <td>Etobicoke</td>\n      <td>Kingsview Village</td>\n      <td>43.700504</td>\n      <td>-79.551914</td>\n    </tr>\n    <tr>\n      <th>76</th>\n      <td>M1S</td>\n      <td>Scarborough</td>\n      <td>Agincourt</td>\n      <td>43.794200</td>\n      <td>-79.262029</td>\n    </tr>\n    <tr>\n      <th>77</th>\n      <td>M4S</td>\n      <td>Davisville</td>\n      <td>Davisville</td>\n      <td>43.704324</td>\n      <td>-79.388790</td>\n    </tr>\n    <tr>\n      <th>78</th>\n      <td>M5S</td>\n      <td>Downtown Toronto</td>\n      <td>University of Toronto</td>\n      <td>43.662892</td>\n      <td>-79.395656</td>\n    </tr>\n    <tr>\n      <th>79</th>\n      <td>M6S</td>\n      <td>Runnymede</td>\n      <td>Swansea</td>\n      <td>43.648787</td>\n      <td>-79.475330</td>\n    </tr>\n    <tr>\n      <th>80</th>\n      <td>M1T</td>\n      <td>Scarborough</td>\n      <td>Tam O'Shanter, Sullivan</td>\n      <td>43.781638</td>\n      <td>-79.304302</td>\n    </tr>\n    <tr>\n      <th>81</th>\n      <td>M4T</td>\n      <td>Moore Park</td>\n      <td>Summerhill</td>\n      <td>43.684518</td>\n      <td>-79.386836</td>\n    </tr>\n    <tr>\n      <th>82</th>\n      <td>M5T</td>\n      <td>Downtown Toronto</td>\n      <td>Kensington Market, Chinatown, Grange Park</td>\n      <td>43.650883</td>\n      <td>-79.397226</td>\n    </tr>\n    <tr>\n      <th>83</th>\n      <td>M1V</td>\n      <td>Scarborough</td>\n      <td>Milliken, Agincourt North, Steeles, L'Amoreaux</td>\n      <td>43.828550</td>\n      <td>-79.285955</td>\n    </tr>\n    <tr>\n      <th>84</th>\n      <td>M4V</td>\n      <td>Summerhill</td>\n      <td>Rathnelly, South Hill, Forest Hill, Deer Park</td>\n      <td>43.678751</td>\n      <td>-79.400992</td>\n    </tr>\n    <tr>\n      <th>85</th>\n      <td>M5V</td>\n      <td>Downtown Toronto</td>\n      <td>CN Tower, King and Spadina, Railway Lands, Har...</td>\n      <td>43.642566</td>\n      <td>-79.387057</td>\n    </tr>\n    <tr>\n      <th>86</th>\n      <td>M8V</td>\n      <td>Etobicoke</td>\n      <td>New Toronto, Mimico</td>\n      <td>43.600778</td>\n      <td>-79.505257</td>\n    </tr>\n    <tr>\n      <th>87</th>\n      <td>M9V</td>\n      <td>Etobicoke</td>\n      <td>South Steeles, Silverstone, Jamestown, Mount O...</td>\n      <td>43.749774</td>\n      <td>-79.594787</td>\n    </tr>\n    <tr>\n      <th>88</th>\n      <td>M1W</td>\n      <td>Scarborough</td>\n      <td>Steeles, L'Amoreaux</td>\n      <td>43.810961</td>\n      <td>-79.361480</td>\n    </tr>\n    <tr>\n      <th>89</th>\n      <td>M4W</td>\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>90</th>\n      <td>M5W</td>\n      <td>Downtown Toronto</td>\n      <td>Downtown Toronto</td>\n      <td>43.646435</td>\n      <td>-79.374846</td>\n    </tr>\n    <tr>\n      <th>91</th>\n      <td>M8W</td>\n      <td>Etobicoke</td>\n      <td>Alderwood, Long Branch</td>\n      <td>43.601580</td>\n      <td>-79.555103</td>\n    </tr>\n    <tr>\n      <th>92</th>\n      <td>M9W</td>\n      <td>Etobicoke</td>\n      <td>Clairville, Humberwood, Woodbine Downs, Rexdal...</td>\n      <td>43.738116</td>\n      <td>-79.607332</td>\n    </tr>\n    <tr>\n      <th>93</th>\n      <td>M1X</td>\n      <td>Scarborough</td>\n      <td>Upper Rouge</td>\n      <td>43.809571</td>\n      <td>-79.187170</td>\n    </tr>\n    <tr>\n      <th>94</th>\n      <td>M4X</td>\n      <td>Downtown Toronto</td>\n      <td>St. James Town, Cabbagetown</td>\n      <td>43.665752</td>\n      <td>-79.368692</td>\n    </tr>\n    <tr>\n      <th>95</th>\n      <td>M5X</td>\n      <td>Downtown Toronto</td>\n      <td>First Canadian Place, Underground city</td>\n      <td>43.648636</td>\n      <td>-79.381744</td>\n    </tr>\n    <tr>\n      <th>96</th>\n      <td>M8X</td>\n      <td>Etobicoke</td>\n      <td>The Kingsway, Old Mill</td>\n      <td>43.652092</td>\n      <td>-79.490074</td>\n    </tr>\n    <tr>\n      <th>97</th>\n      <td>M4Y</td>\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>98</th>\n      <td>M7Y</td>\n      <td>Business reply mail</td>\n      <td>Business reply mail</td>\n      <td>43.662744</td>\n      <td>-79.321558</td>\n    </tr>\n    <tr>\n      <th>99</th>\n      <td>M8Y</td>\n      <td>Etobicoke</td>\n      <td>Old Mill, Sunnylea, Humber Bay, Mimico, The Qu...</td>\n      <td>43.651100</td>\n      <td>-79.493825</td>\n    </tr>\n    <tr>\n      <th>100</th>\n      <td>M8Z</td>\n      <td>Etobicoke</td>\n      <td>Mimico, The Queensway</td>\n      <td>43.619999</td>\n      <td>-79.528761</td>\n    </tr>\n  </tbody>\n</table>\n</div>", 
                        "text/plain": "    PostalCode              Borough  \\\n0          M3A           North York   \n1          M4A           North York   \n2          M5A     Downtown Toronto   \n3          M6A           North York   \n4          M7A         Queen's Park   \n5          M9A            Etobicoke   \n6          M1B          Scarborough   \n7          M3B           North York   \n8          M4B            East York   \n9          M5B     Downtown Toronto   \n10         M6B           North York   \n11         M9B            Etobicoke   \n12         M1C          Scarborough   \n13         M3C           North York   \n14         M4C            East York   \n15         M5C     Downtown Toronto   \n16         M6C                 York   \n17         M9C            Etobicoke   \n18         M1E          Scarborough   \n19         M4E          The Beaches   \n20         M5E     Downtown Toronto   \n21         M6E                 York   \n22         M1G          Scarborough   \n23         M4G            East York   \n24         M5G     Downtown Toronto   \n25         M6G     Downtown Toronto   \n26         M1H          Scarborough   \n27         M2H           North York   \n28         M3H           North York   \n29         M4H            East York   \n30         M5H     Downtown Toronto   \n31         M6H             Dufferin   \n32         M1J          Scarborough   \n33         M2J           North York   \n34         M3J           North York   \n35         M4J            East York   \n36         M5J     Downtown Toronto   \n37         M6J      Little Portugal   \n38         M1K          Scarborough   \n39         M2K           North York   \n40         M3K           North York   \n41         M4K         The Danforth   \n42         M5K     Downtown Toronto   \n43         M6K             Brockton   \n44         M1L          Scarborough   \n45         M2L           North York   \n46         M3L           North York   \n47         M4L         India Bazaar   \n48         M5L     Downtown Toronto   \n49         M6L           North York   \n50         M9L           North York   \n51         M1M          Scarborough   \n52         M2M           North York   \n53         M3M           North York   \n54         M5M           North York   \n55         M6M                 York   \n56         M9M           North York   \n57         M1N          Scarborough   \n58         M2N           North York   \n59         M3N           North York   \n60         M4N        Lawrence Park   \n61         M6N                 York   \n62         M9N                 York   \n63         M1P          Scarborough   \n64         M2P           North York   \n65         M4P           Davisville   \n66         M5P          Forest Hill   \n67         M6P            High Park   \n68         M9P            Etobicoke   \n69         M1R          Scarborough   \n70         M2R           North York   \n71         M4R        North Toronto   \n72         M5R            The Annex   \n73         M6R             Parkdale   \n74         M7R          Mississauga   \n75         M9R            Etobicoke   \n76         M1S          Scarborough   \n77         M4S           Davisville   \n78         M5S     Downtown Toronto   \n79         M6S            Runnymede   \n80         M1T          Scarborough   \n81         M4T           Moore Park   \n82         M5T     Downtown Toronto   \n83         M1V          Scarborough   \n84         M4V           Summerhill   \n85         M5V     Downtown Toronto   \n86         M8V            Etobicoke   \n87         M9V            Etobicoke   \n88         M1W          Scarborough   \n89         M4W     Downtown Toronto   \n90         M5W     Downtown Toronto   \n91         M8W            Etobicoke   \n92         M9W            Etobicoke   \n93         M1X          Scarborough   \n94         M4X     Downtown Toronto   \n95         M5X     Downtown Toronto   \n96         M8X            Etobicoke   \n97         M4Y     Downtown Toronto   \n98         M7Y  Business reply mail   \n99         M8Y            Etobicoke   \n100        M8Z            Etobicoke   \n\n                                          Neighborhood   Latitude  Longitude  \n0                                            Parkwoods  43.753259 -79.329656  \n1                                     Victoria Village  43.725882 -79.315572  \n2                            Regent Park, Harbourfront  43.659343 -79.365525  \n3                     Lawrence Manor, Lawrence Heights  43.722774 -79.450928  \n4                                         Queen's Park  43.662843 -79.389638  \n5                                     Islington Avenue  43.680233 -79.539081  \n6                                       Malvern, Rouge  43.806686 -79.194353  \n7                                            Don Mills  43.745906 -79.352188  \n8                      Parkview Hill, Woodbine Gardens  43.706139 -79.325415  \n9                             Garden District, Ryerson  43.657658 -79.378802  \n10                                          North York  43.761538 -79.411079  \n11   West Deane Park, Princess Gardens, Martin Grov...  43.721323 -79.584571  \n12              Rouge Hill, Port Union, Highland Creek  43.780707 -79.130264  \n13                          Don Mills, Flemingdon Park  43.715718 -79.337017  \n14                                    Woodbine Heights  43.693328 -79.316064  \n15                                      St. James Town  43.668195 -79.373771  \n16                                  Humewood-Cedarvale  43.693781 -79.428191  \n17                                       Markland Wood  43.632036 -79.575140  \n18                   Guildwood, Morningside, West Hill  43.753240 -79.179809  \n19                                         The Beaches  43.676357 -79.293031  \n20                                    Downtown Toronto  43.644771 -79.373306  \n21                                 Caledonia-Fairbanks  43.686916 -79.456325  \n22                                              Woburn  43.770992 -79.216917  \n23                                             Leaside  43.709060 -79.363452  \n24                                          Bay Street  43.655854 -79.383778  \n25                                    Downtown Toronto  43.669542 -79.422564  \n26                                           Cedarbrae  43.773136 -79.239476  \n27                                   Hillcrest Village  43.803762 -79.363452  \n28           Bathurst Manor, Wilson Heights, Downsview  43.748145 -79.454649  \n29                                    Thorncliffe Park  43.705369 -79.349372  \n30                                      Richmond, King  43.648918 -79.378169  \n31                                  Dovercourt Village  43.660854 -79.429393  \n32                                 Scarborough Village  43.744734 -79.239476  \n33                                          Henry Farm  43.771782 -79.352086  \n34                     Northwood Park, York University  43.773454 -79.501868  \n35                                        The Danforth  43.685347 -79.338106  \n36        Harbourfront, Union Station, Toronto Islands  43.638702 -79.385741  \n37                                             Trinity  43.647927 -79.419750  \n38              Kennedy Park, Ionview, Birchmount Park  43.730886 -79.278118  \n39                                     Bayview Village  43.786947 -79.385975  \n40                              Downsview, CFB Toronto  43.743649 -79.465901  \n41                                           Riverdale  43.679557 -79.352188  \n42            Toronto Dominion Centre, Design Exchange  43.647693 -79.380330  \n43                  Parkdale Village, Exhibition Place  43.636847 -79.428191  \n44                     Golden Mile, Clairlea, Oakridge  43.718496 -79.291427  \n45                                          York Mills  43.757490 -79.374714  \n46                                           Downsview  43.739015 -79.506944  \n47                                         The Beaches  43.672341 -79.322543  \n48                      Commerce Court, Victoria Hotel  43.647906 -79.378065  \n49                                     Maple Leaf Park  43.715895 -79.493079  \n50                                       Humber Summit  43.756303 -79.565963  \n51          Cliffside, Cliffcrest, Scarborough Village  43.712217 -79.244001  \n52                                         Newtonbrook  43.789053 -79.408493  \n53                                           Downsview  43.728496 -79.495697  \n54                        Bedford Park, Lawrence Manor  43.733283 -79.419750  \n55             Mount Dennis, Keelsdale and Silverthorn  43.687907 -79.484485  \n56                                    Humberlea, Emery  43.748514 -79.538591  \n57                              Birch Cliff, Cliffside  43.704466 -79.247048  \n58                                          Willowdale  43.770120 -79.408493  \n59                                           Downsview  43.761631 -79.520999  \n60                                       Lawrence Park  43.723282 -79.388790  \n61                             Runnymede, The Junction  43.665260 -79.481982  \n62                                              Weston  43.706876 -79.518188  \n63   Dorset Park, Wexford Heights, Scarborough Town...  43.754001 -79.282117  \n64                                          York Mills  43.752758 -79.400049  \n65                                          Davisville  43.712751 -79.390197  \n66                                         Forest Hill  43.686103 -79.412204  \n67                                        The Junction  43.665588 -79.470055  \n68                                           Etobicoke  43.696319 -79.532242  \n69                                   Wexford, Maryvale  43.750071 -79.295849  \n70                                          Willowdale  43.782736 -79.442259  \n71                                       North Toronto  43.715383 -79.405678  \n72                            North Midtown, Yorkville  43.670749 -79.393040  \n73                                        Roncesvalles  43.648960 -79.456325  \n74                                         Mississauga  43.636966 -79.615819  \n75                                   Kingsview Village  43.700504 -79.551914  \n76                                           Agincourt  43.794200 -79.262029  \n77                                          Davisville  43.704324 -79.388790  \n78                               University of Toronto  43.662892 -79.395656  \n79                                             Swansea  43.648787 -79.475330  \n80                             Tam O'Shanter, Sullivan  43.781638 -79.304302  \n81                                          Summerhill  43.684518 -79.386836  \n82           Kensington Market, Chinatown, Grange Park  43.650883 -79.397226  \n83      Milliken, Agincourt North, Steeles, L'Amoreaux  43.828550 -79.285955  \n84       Rathnelly, South Hill, Forest Hill, Deer Park  43.678751 -79.400992  \n85   CN Tower, King and Spadina, Railway Lands, Har...  43.642566 -79.387057  \n86                                 New Toronto, Mimico  43.600778 -79.505257  \n87   South Steeles, Silverstone, Jamestown, Mount O...  43.749774 -79.594787  \n88                                 Steeles, L'Amoreaux  43.810961 -79.361480  \n89                                            Rosedale  43.679563 -79.377529  \n90                                    Downtown Toronto  43.646435 -79.374846  \n91                              Alderwood, Long Branch  43.601580 -79.555103  \n92   Clairville, Humberwood, Woodbine Downs, Rexdal...  43.738116 -79.607332  \n93                                         Upper Rouge  43.809571 -79.187170  \n94                         St. James Town, Cabbagetown  43.665752 -79.368692  \n95              First Canadian Place, Underground city  43.648636 -79.381744  \n96                              The Kingsway, Old Mill  43.652092 -79.490074  \n97                                Church and Wellesley  43.665860 -79.383160  \n98                                 Business reply mail  43.662744 -79.321558  \n99   Old Mill, Sunnylea, Humber Bay, Mimico, The Qu...  43.651100 -79.493825  \n100                              Mimico, The Queensway  43.619999 -79.528761  "
                    }, 
                    "output_type": "execute_result"
                }
            ], 
            "source": "neighborhood_df.head(101)"
        }
    ], 
    "metadata": {
        "kernelspec": {
            "display_name": "Python 3.5", 
            "name": "python3", 
            "language": "python"
        }, 
        "language_info": {
            "mimetype": "text/x-python", 
            "nbconvert_exporter": "python", 
            "version": "3.5.5", 
            "name": "python", 
            "file_extension": ".py", 
            "pygments_lexer": "ipython3", 
            "codemirror_mode": {
                "version": 3, 
                "name": "ipython"
            }
        }
    }, 
    "nbformat": 4
}