pip install geocoder

import numpy as np # library to handle data in a vectorized manner

import pandas as pd # library for data analsysis
pd.set_option('display.max_columns', None)
pd.set_option('display.max_rows', None)

import json # library to handle JSON files
from bs4 import BeautifulSoup

import geocoder # import geocoder

#!conda install -c conda-forge geopy --yes # uncomment this line if you haven't completed the Foursquare API lab
from geopy.geocoders import Nominatim # convert an address into latitude and longitude values

import requests # library to handle requests
from pandas.io.json import json_normalize # tranform JSON file into a pandas dataframe

# Matplotlib and associated plotting modules
import matplotlib.cm as cm
import matplotlib.colors as colors

# import k-means from clustering stage
from sklearn.cluster import KMeans

!conda install -c conda-forge folium=0.5.0 --yes # uncomment this line if you haven't completed the Foursquare API lab
import folium # map rendering library


print('Libraries imported.')

url= 'https://cocl.us/Geospatial_data'
postal_code=pd.read_csv(url)
postal_code.head()

!wget -q -O 'canada_data.json' https://en.wikipedia.org/w/index.php?title=List_of_postal_codes_of_Canada:_M&oldid=947772202
print('Data downloaded!')
req = requests.get("https://en.wikipedia.org/wiki/List_of_postal_codes_of_Canada:_M")
soup = BeautifulSoup(req.content,'lxml')
table = soup.find_all('table')[0]
df = pd.read_html(str(table))
neighborhood_row=pd.DataFrame(df[0])
canada_neighborhood = neighborhood_row[neighborhood_row['Borough'] != 'Not assigned'].reset_index(drop=True)
canada_neighborhood['Neighborhood']= canada_neighborhood.Neighborhood.str.replace('Regent Park / Harbourfront','Regent Park , Harbourfront')
canada_neighborhood.replace(canada_neighborhood['Neighborhood']== 'NaN', canada_neighborhood['Borough'])

canada_neighborhood.head()

canada_merged = canada_neighborhood.merge(postal_code, left_on='Postal code', right_on='Postal Code',how='inner')

canada_merged.head()
canada_merged.drop('Postal Code',axis=1)