{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Geolocation" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "##### Imports" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n", "import numpy as np\n", "import time\n", "\n", "from geopy.geocoders import Nominatim\n", "from geopy.exc import GeocoderTimedOut" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "##### Paths" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [], "source": [ "filepath = 'Z:/Open_data_sets/Montreal_open_data/evaluation_fonciere/uniteevaluationfonciere.csv'" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Note: Download the data file from the Montreal Open Data Portal here:\n", " http://donnees.ville.montreal.qc.ca/dataset/unites-evaluation-fonciere/resource/2b9dfc3d-91d3-48de-b32c-a2a6d9417079" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
ID_UEVCIVIQUE_DEBUTCIVIQUE_FINNOM_RUESUITE_DEBUTMUNICIPALITEETAGE_HORS_SOLNOMBRE_LOGEMENTANNEE_CONSTRUCTIONCODE_UTILISATIONLIBELLE_UTILISATIONCATEGORIE_UEFMATRICULE83SUPERFICIE_TERRAINSUPERFICIE_BATIMENTNO_ARROND_ILE_CUM
248297104137514511451rue Notre-Dame Ouest (MTL+MTO)150NaN1.01600.01000LogementCondominium9939-50-9334-9-001-000154.04210.0REM19
384551310952562176221avenue Christophe-Colomb (MTL)NaN503.03.01600.01000LogementRégulier9744-11-0803-8-000-0000266.0400.0REM24
4078755008965105105chemin du Bord-du-Lac-Lakeshore (PCL)NaN201.01.01680.01000LogementRégulier8133-06-6979-7-000-00001610.0128.0REM99
189754079228915rue Sainte-Anne (SAB)NaN232.04.01684.01000LogementRégulier6929-93-1711-0-000-00001122.0478.0REM99
4318441091085445445rue Saint-Paul Est (MTL)NaN502.02.01690.01000LogementRégulier0041-71-7694-8-000-0000292.0237.0REM19
279461505129550405040boulevard Saint-Joseph (LCH)NaN501.01.01700.01000LogementRégulier8833-20-1805-5-000-0000832.0120.0REM27
45279640849341701317013boulevard Gouin Ouest (MTL+PFD+ROX+SGV)NaN501.01.01700.01000LogementRégulier7536-29-0731-5-000-00004044.0150.0REM32
218190104038117501758rue Beaudry (MTL)NaN50NaN5.01700.01000LogementRégulier0042-12-2067-4-000-0000225.0548.0REM19
4047740690086666rue Allan-Point (DVL)NaN61.01.01700.01000LogementRégulier8433-71-7409-2-000-00006800.0197.0REM99
996904085029174174rue Beaulieu (SGV)NaN501.02.01700.01000LogementRégulier7537-20-6926-2-000-0000856.0138.0REM32
11401650774282012220122chemin Lakeshore (BDU+SAB)NaN21.01.01703.01000LogementRégulier7330-23-7609-7-000-00003677.0179.0REM99
341043209117355555555rue Jarry Est (ANJ+MTL+SLN)NaN502.01.01709.01000LogementRégulier9749-75-6473-8-000-00001115.0224.0REM14
4620271091061161163rue Saint-Paul Est (MTL)NaN502.01.01710.01000LogementRégulier0040-68-6703-6-000-0000220.0282.0REM19
398659505078654305430boulevard Saint-Joseph (LCH)NaN501.01.01710.01000LogementRégulier8733-82-2343-8-000-0000772.0136.0REM27
176137506028350105010boulevard Saint-Joseph (LCH)NaN502.01.01720.01000LogementRégulier8832-29-5190-1-000-00002053.0294.0REM27
231302208315365236527boulevard Gouin Est (MTL+MTN)NaN501.03.01721.01000LogementRégulier9553-09-4374-5-000-00002358.0143.0REM16
3238405104020405417rue de Bonsecours (MTL)NaN504.02.01725.05833Auberge ou gîte touristique (Hôtel à caractère...Régulier0041-71-6139-5-000-00001244.01364.0REM19
26351450931661953019530boulevard Gouin Ouest (MTL+PFD+ROX+SGV)NaN501.02.01729.01000LogementRégulier7235-56-5614-0-000-000010641.0104.0REM31
1127320530911293012930boulevard Gouin Est (MTL+MTN)NaN501.01.01732.01000LogementRégulier0361-48-3806-2-000-00001380.0107.0REM33
19978940819291999219992chemin Lakeshore (BDU+SAB)NaN21.01.01735.01000LogementRégulier7330-74-5594-6-000-00005208.0222.0REM99
145423407305522croissant Elliot (DVL)NaN61.01.01737.01000LogementRégulier8733-42-8631-4-000-00001288.0164.0REM99
477115209119562556255rue Jarry Est (ANJ+MTL+SLN)NaN501.01.01750.01000LogementRégulier9850-23-4636-8-000-00001557.0171.0REM14
454387305230019471947boulevard Gouin Est (MTL+MTN)NaN501.01.01750.01000LogementRégulier9248-20-9242-3-000-0000988.067.0REM23
25664221551264443e Avenue (PAT)NaN501.01.01752.01000LogementRégulier0558-41-1633-8-000-00001932.0154.0REM33
1688512810517991799chemin du Bord-du-Lac (IBZ)NaN501.01.01758.01000LogementRégulier7239-19-1381-0-000-00002491.0NaNREM32
3109392077106242458e Avenue (PAT)NaN501.01.01760.01000LogementRégulier0559-42-4568-9-000-00002340.0236.0REM33
1552507453442514251boulevard Gouin Est (MTL+MTN)NaN50NaNNaN1762.04990Autres transports, communications et services ...Régulier9351-61-0101-6-000-00006977.0NaNREM16
3995165055776897897boulevard Saint-Joseph (LCH)NaN502.01.01765.01000LogementRégulier9132-34-3111-3-000-0000593.0358.0REM27
4791862042020101064e Avenue (PAT)NaN501.01.01765.01000LogementRégulier0559-47-8645-0-000-0000907.0106.0REM33
10724150643631313rue Thompson (BCF)NaN31.01.01765.01000LogementRégulier7530-16-2501-0-000-00002022.0234.0REM99
...................................................
50950651020879999999999rue Daoust (SAB)NaN23NaNNaNNaN9100Espace de terrain non aménagé et non exploité ...Régulier7132-55-1151-8-000-000011373.0NaNREM99
509687308325111331133rue Jacques-Casault (MTL)NaN501.01.0NaN1000LogementCondominium9445-68-6642-8-001-000555.0198.0REM23
509782404114715171517rue Baxter (LSL)NaN501.01.0NaN1000LogementCondominium9633-22-6323-3-001-0002131.0249.0REM17
51041952435619999999999boulevard Mc Millan (DVL)NaN6NaNNaNNaN9100Espace de terrain non aménagé et non exploité ...Régulier8534-97-1487-4-000-0000251.0NaNREM99
51042640499079999999999rue Maria (LSL)NaN50NaNNaNNaN4112Aiguillage et cour de triage de chemins de ferRégulier9232-60-9933-7-000-000031569.0NaNREM17
51043840164999999999999avenue Ambassador (PCL)NaN20NaNNaNNaN9100Espace de terrain non aménagé et non exploité ...Régulier7934-56-2019-3-000-000020301.0NaNREM99
510629520797551245124rue Michel-David (SLN)NaN50NaNNaNNaN9100Espace de terrain non aménagé et non exploité ...Régulier9550-81-4864-0-000-0000309.0NaNREM14
5107114001260200200avenue de la Pointe-Claire (PCL)NaN20NaNNaNNaN6242CimetièreRégulier7833-48-1563-2-000-000023764.0NaNREM99
510796500281922672267rue Parthenais (MTL)NaN503.01.0NaN1000LogementCondominium0043-15-1804-2-002-0001194.01927.0REM19
5110834129230440440avenue Roy (DVL)NaN63.042.0NaN1000LogementRégulier8534-31-2455-9-000-00003071.0NaNREM99
511091413503821802180rue Patricia (SLR)NaN502.01.0NaN1000LogementRégulier8942-14-1660-6-000-0000189.0NaNREM15
5111604095995104104rue Viking (DDO)NaN52.01.0NaN1000LogementCondominium7837-84-4763-1-001-0093245.089.0REM99
511168509964299289928rue Paul-Comtois (MTL)NaN502.01.0NaN1000LogementCondominium9144-70-8798-1-003-0001209.0NaNREM23
51144250639079999999999rue Marie-Victorin (MTL+MTN)NaN50NaNNaNNaN9100Espace de terrain non aménagé et non exploité ...Régulier9652-49-3099-5-000-0000877.0NaNREM16
51160341254119999999999montée Sainte-Marie (SAB)NaN23NaNNaNNaN9100Espace de terrain non aménagé et non exploité ...Régulier7232-43-8376-8-000-000092573.0NaNREM99
51184340756239999999999Evergreen Drive (BCF)NaN3NaNNaNNaN9100Espace de terrain non aménagé et non exploité ...Régulier7733-40-7928-0-000-0000294.0NaNREM99
511922305290785208520avenue André-Grasset (MTL)NaN501.01.0NaN1000LogementCondominium9446-80-4005-3-001-000551.0200.0REM23
512018101332466326636rue Beaulieu (MTL)NaN502.04.0NaN1000LogementRégulier9734-47-1613-5-000-0000343.0273.0REM20
512074305255886868686rue Joseph-Quintal (MTL)NaN501.01.0NaN1000LogementCondominium9446-60-1943-0-001-000980.0206.0REM23
51210440853129999999999avenue Pacific (SAB+SNV)NaN22NaNNaNNaN9100Espace de terrain non aménagé et non exploité ...Régulier6930-32-5687-4-000-00001400.0NaNREM99
512173208636848504850boulevard Métropolitain Est (ANJ+MTE+MTL+SLN)NaN50NaNNaNNaN6000Immeuble à bureauxRégulier9748-55-8558-8-000-00003914.0NaNREM14
512244104270537143714avenue Henri-Julien (MTL)NaN501.01.0NaN1000LogementCondominium9941-19-3760-2-001-000142.0483.0REM21
512268100078645554555rue Hutchison (MTL+OUT)NaN501.01.0NaN1000LogementCondominium9741-78-2378-4-001-000187.0453.0REM21
51232951532749999999999rue Saint-Pierre (IBZ)NaN50NaNNaNNaN9100Espace de terrain non aménagé et non exploité ...Régulier7638-08-0797-4-000-00003253.0NaNREM32
51234010103439999999999Lansdowne Ridge (WMT)NaN29NaNNaNNaN9100Espace de terrain non aménagé et non exploité ...Régulier9538-57-5035-1-000-0000121.0NaNREM99
512825105838866836683rue Briand (MTL)NaN501.01.0NaN1000LogementCondominium9734-56-4154-8-001-000267.0126.0REM20
51285730396441616côte du Vésinet (OUT)NaN50NaNNaNNaN1990Autres immeubles résidentielsRégulier9641-96-0189-1-000-0000348.0NaNREM05
512896305244385588558rue Joseph-Quintal (MTL)NaN501.01.0NaN1000LogementCondominium9445-79-6453-7-001-0002101.0529.0REM23
51294030354109999999999rue Globert (MTL)NaN50NaNNaNNaN9100Espace de terrain non aménagé et non exploité ...Régulier9438-71-7197-1-000-0000251.0NaNREM34
513152524355268376837avenue De Chateaubriand (MTL)NaN50NaN1.0NaN1000LogementCondominium9644-22-8451-7-006-0001107.0NaNREM24
\n", "

353850 rows × 16 columns

\n", "
" ], "text/plain": [ " ID_UEV CIVIQUE_DEBUT CIVIQUE_FIN \\\n", "248297 1041375 1451 1451 \n", "384551 3109525 6217 6221 \n", "407875 5008965 105 105 \n", "18975 4079228 9 15 \n", "431844 1091085 445 445 \n", "279461 5051295 5040 5040 \n", "452796 4084934 17013 17013 \n", "218190 1040381 1750 1758 \n", "40477 4069008 66 66 \n", "99690 4085029 174 174 \n", "114016 5077428 20122 20122 \n", "341043 2091173 5555 5555 \n", "462027 1091061 161 163 \n", "398659 5050786 5430 5430 \n", "176137 5060283 5010 5010 \n", "231302 2083153 6523 6527 \n", "323840 5104020 405 417 \n", "263514 5093166 19530 19530 \n", "11273 2053091 12930 12930 \n", "199789 4081929 19992 19992 \n", "145423 4073055 2 2 \n", "477115 2091195 6255 6255 \n", "454387 3052300 1947 1947 \n", "256642 2155126 4 4 \n", "1688 5128105 1799 1799 \n", "310939 2077106 24 24 \n", "1552 5074534 4251 4251 \n", "399516 5055776 897 897 \n", "479186 2042020 10 10 \n", "107241 5064363 13 13 \n", "... ... ... ... \n", "509506 5102087 99999 99999 \n", "509687 3083251 1133 1133 \n", "509782 4041147 1517 1517 \n", "510419 5243561 99999 99999 \n", "510426 4049907 99999 99999 \n", "510438 4016499 99999 99999 \n", "510629 5207975 5124 5124 \n", "510711 4001260 200 200 \n", "510796 5002819 2267 2267 \n", "511083 4129230 440 440 \n", "511091 4135038 2180 2180 \n", "511160 4095995 104 104 \n", "511168 5099642 9928 9928 \n", "511442 5063907 99999 99999 \n", "511603 4125411 99999 99999 \n", "511843 4075623 99999 99999 \n", "511922 3052907 8520 8520 \n", "512018 1013324 6632 6636 \n", "512074 3052558 8686 8686 \n", "512104 4085312 99999 99999 \n", "512173 2086368 4850 4850 \n", "512244 1042705 3714 3714 \n", "512268 1000786 4555 4555 \n", "512329 5153274 99999 99999 \n", "512340 1010343 99999 99999 \n", "512825 1058388 6683 6683 \n", "512857 3039644 16 16 \n", "512896 3052443 8558 8558 \n", "512940 3035410 99999 99999 \n", "513152 5243552 6837 6837 \n", "\n", " NOM_RUE SUITE_DEBUT \\\n", "248297 rue Notre-Dame Ouest (MTL+MTO) 1 \n", "384551 avenue Christophe-Colomb (MTL) NaN \n", "407875 chemin du Bord-du-Lac-Lakeshore (PCL) NaN \n", "18975 rue Sainte-Anne (SAB) NaN \n", "431844 rue Saint-Paul Est (MTL) NaN \n", "279461 boulevard Saint-Joseph (LCH) NaN \n", "452796 boulevard Gouin Ouest (MTL+PFD+ROX+SGV) NaN \n", "218190 rue Beaudry (MTL) NaN \n", "40477 rue Allan-Point (DVL) NaN \n", "99690 rue Beaulieu (SGV) NaN \n", "114016 chemin Lakeshore (BDU+SAB) NaN \n", "341043 rue Jarry Est (ANJ+MTL+SLN) NaN \n", "462027 rue Saint-Paul Est (MTL) NaN \n", "398659 boulevard Saint-Joseph (LCH) NaN \n", "176137 boulevard Saint-Joseph (LCH) NaN \n", "231302 boulevard Gouin Est (MTL+MTN) NaN \n", "323840 rue de Bonsecours (MTL) NaN \n", "263514 boulevard Gouin Ouest (MTL+PFD+ROX+SGV) NaN \n", "11273 boulevard Gouin Est (MTL+MTN) NaN \n", "199789 chemin Lakeshore (BDU+SAB) NaN \n", "145423 croissant Elliot (DVL) NaN \n", "477115 rue Jarry Est (ANJ+MTL+SLN) NaN \n", "454387 boulevard Gouin Est (MTL+MTN) NaN \n", "256642 43e Avenue (PAT) NaN \n", "1688 chemin du Bord-du-Lac (IBZ) NaN \n", "310939 58e Avenue (PAT) NaN \n", "1552 boulevard Gouin Est (MTL+MTN) NaN \n", "399516 boulevard Saint-Joseph (LCH) NaN \n", "479186 64e Avenue (PAT) NaN \n", "107241 rue Thompson (BCF) NaN \n", "... ... ... \n", "509506 rue Daoust (SAB) NaN \n", "509687 rue Jacques-Casault (MTL) NaN \n", "509782 rue Baxter (LSL) NaN \n", "510419 boulevard Mc Millan (DVL) NaN \n", "510426 rue Maria (LSL) NaN \n", "510438 avenue Ambassador (PCL) NaN \n", "510629 rue Michel-David (SLN) NaN \n", "510711 avenue de la Pointe-Claire (PCL) NaN \n", "510796 rue Parthenais (MTL) NaN \n", "511083 avenue Roy (DVL) NaN \n", "511091 rue Patricia (SLR) NaN \n", "511160 rue Viking (DDO) NaN \n", "511168 rue Paul-Comtois (MTL) NaN \n", "511442 rue Marie-Victorin (MTL+MTN) NaN \n", "511603 montée Sainte-Marie (SAB) NaN \n", "511843 Evergreen Drive (BCF) NaN \n", "511922 avenue André-Grasset (MTL) NaN \n", "512018 rue Beaulieu (MTL) NaN \n", "512074 rue Joseph-Quintal (MTL) NaN \n", "512104 avenue Pacific (SAB+SNV) NaN \n", "512173 boulevard Métropolitain Est (ANJ+MTE+MTL+SLN) NaN \n", "512244 avenue Henri-Julien (MTL) NaN \n", "512268 rue Hutchison (MTL+OUT) NaN \n", "512329 rue Saint-Pierre (IBZ) NaN \n", "512340 Lansdowne Ridge (WMT) NaN \n", "512825 rue Briand (MTL) NaN \n", "512857 côte du Vésinet (OUT) NaN \n", "512896 rue Joseph-Quintal (MTL) NaN \n", "512940 rue Globert (MTL) NaN \n", "513152 avenue De Chateaubriand (MTL) NaN \n", "\n", " MUNICIPALITE ETAGE_HORS_SOL NOMBRE_LOGEMENT ANNEE_CONSTRUCTION \\\n", "248297 50 NaN 1.0 1600.0 \n", "384551 50 3.0 3.0 1600.0 \n", "407875 20 1.0 1.0 1680.0 \n", "18975 23 2.0 4.0 1684.0 \n", "431844 50 2.0 2.0 1690.0 \n", "279461 50 1.0 1.0 1700.0 \n", "452796 50 1.0 1.0 1700.0 \n", "218190 50 NaN 5.0 1700.0 \n", "40477 6 1.0 1.0 1700.0 \n", "99690 50 1.0 2.0 1700.0 \n", "114016 2 1.0 1.0 1703.0 \n", "341043 50 2.0 1.0 1709.0 \n", "462027 50 2.0 1.0 1710.0 \n", "398659 50 1.0 1.0 1710.0 \n", "176137 50 2.0 1.0 1720.0 \n", "231302 50 1.0 3.0 1721.0 \n", "323840 50 4.0 2.0 1725.0 \n", "263514 50 1.0 2.0 1729.0 \n", "11273 50 1.0 1.0 1732.0 \n", "199789 2 1.0 1.0 1735.0 \n", "145423 6 1.0 1.0 1737.0 \n", "477115 50 1.0 1.0 1750.0 \n", "454387 50 1.0 1.0 1750.0 \n", "256642 50 1.0 1.0 1752.0 \n", "1688 50 1.0 1.0 1758.0 \n", "310939 50 1.0 1.0 1760.0 \n", "1552 50 NaN NaN 1762.0 \n", "399516 50 2.0 1.0 1765.0 \n", "479186 50 1.0 1.0 1765.0 \n", "107241 3 1.0 1.0 1765.0 \n", "... ... ... ... ... \n", "509506 23 NaN NaN NaN \n", "509687 50 1.0 1.0 NaN \n", "509782 50 1.0 1.0 NaN \n", "510419 6 NaN NaN NaN \n", "510426 50 NaN NaN NaN \n", "510438 20 NaN NaN NaN \n", "510629 50 NaN NaN NaN \n", "510711 20 NaN NaN NaN \n", "510796 50 3.0 1.0 NaN \n", "511083 6 3.0 42.0 NaN \n", "511091 50 2.0 1.0 NaN \n", "511160 5 2.0 1.0 NaN \n", "511168 50 2.0 1.0 NaN \n", "511442 50 NaN NaN NaN \n", "511603 23 NaN NaN NaN \n", "511843 3 NaN NaN NaN \n", "511922 50 1.0 1.0 NaN \n", "512018 50 2.0 4.0 NaN \n", "512074 50 1.0 1.0 NaN \n", "512104 22 NaN NaN NaN \n", "512173 50 NaN NaN NaN \n", "512244 50 1.0 1.0 NaN \n", "512268 50 1.0 1.0 NaN \n", "512329 50 NaN NaN NaN \n", "512340 29 NaN NaN NaN \n", "512825 50 1.0 1.0 NaN \n", "512857 50 NaN NaN NaN \n", "512896 50 1.0 1.0 NaN \n", "512940 50 NaN NaN NaN \n", "513152 50 NaN 1.0 NaN \n", "\n", " CODE_UTILISATION LIBELLE_UTILISATION \\\n", "248297 1000 Logement \n", "384551 1000 Logement \n", "407875 1000 Logement \n", "18975 1000 Logement \n", "431844 1000 Logement \n", "279461 1000 Logement \n", "452796 1000 Logement \n", "218190 1000 Logement \n", "40477 1000 Logement \n", "99690 1000 Logement \n", "114016 1000 Logement \n", "341043 1000 Logement \n", "462027 1000 Logement \n", "398659 1000 Logement \n", "176137 1000 Logement \n", "231302 1000 Logement \n", "323840 5833 Auberge ou gîte touristique (Hôtel à caractère... \n", "263514 1000 Logement \n", "11273 1000 Logement \n", "199789 1000 Logement \n", "145423 1000 Logement \n", "477115 1000 Logement \n", "454387 1000 Logement \n", "256642 1000 Logement \n", "1688 1000 Logement \n", "310939 1000 Logement \n", "1552 4990 Autres transports, communications et services ... \n", "399516 1000 Logement \n", "479186 1000 Logement \n", "107241 1000 Logement \n", "... ... ... \n", "509506 9100 Espace de terrain non aménagé et non exploité ... \n", "509687 1000 Logement \n", "509782 1000 Logement \n", "510419 9100 Espace de terrain non aménagé et non exploité ... \n", "510426 4112 Aiguillage et cour de triage de chemins de fer \n", "510438 9100 Espace de terrain non aménagé et non exploité ... \n", "510629 9100 Espace de terrain non aménagé et non exploité ... \n", "510711 6242 Cimetière \n", "510796 1000 Logement \n", "511083 1000 Logement \n", "511091 1000 Logement \n", "511160 1000 Logement \n", "511168 1000 Logement \n", "511442 9100 Espace de terrain non aménagé et non exploité ... \n", "511603 9100 Espace de terrain non aménagé et non exploité ... \n", "511843 9100 Espace de terrain non aménagé et non exploité ... \n", "511922 1000 Logement \n", "512018 1000 Logement \n", "512074 1000 Logement \n", "512104 9100 Espace de terrain non aménagé et non exploité ... \n", "512173 6000 Immeuble à bureaux \n", "512244 1000 Logement \n", "512268 1000 Logement \n", "512329 9100 Espace de terrain non aménagé et non exploité ... \n", "512340 9100 Espace de terrain non aménagé et non exploité ... \n", "512825 1000 Logement \n", "512857 1990 Autres immeubles résidentiels \n", "512896 1000 Logement \n", "512940 9100 Espace de terrain non aménagé et non exploité ... \n", "513152 1000 Logement \n", "\n", " CATEGORIE_UEF MATRICULE83 SUPERFICIE_TERRAIN \\\n", "248297 Condominium 9939-50-9334-9-001-0001 54.0 \n", "384551 Régulier 9744-11-0803-8-000-0000 266.0 \n", "407875 Régulier 8133-06-6979-7-000-0000 1610.0 \n", "18975 Régulier 6929-93-1711-0-000-0000 1122.0 \n", "431844 Régulier 0041-71-7694-8-000-0000 292.0 \n", "279461 Régulier 8833-20-1805-5-000-0000 832.0 \n", "452796 Régulier 7536-29-0731-5-000-0000 4044.0 \n", "218190 Régulier 0042-12-2067-4-000-0000 225.0 \n", "40477 Régulier 8433-71-7409-2-000-0000 6800.0 \n", "99690 Régulier 7537-20-6926-2-000-0000 856.0 \n", "114016 Régulier 7330-23-7609-7-000-0000 3677.0 \n", "341043 Régulier 9749-75-6473-8-000-0000 1115.0 \n", "462027 Régulier 0040-68-6703-6-000-0000 220.0 \n", "398659 Régulier 8733-82-2343-8-000-0000 772.0 \n", "176137 Régulier 8832-29-5190-1-000-0000 2053.0 \n", "231302 Régulier 9553-09-4374-5-000-0000 2358.0 \n", "323840 Régulier 0041-71-6139-5-000-0000 1244.0 \n", "263514 Régulier 7235-56-5614-0-000-0000 10641.0 \n", "11273 Régulier 0361-48-3806-2-000-0000 1380.0 \n", "199789 Régulier 7330-74-5594-6-000-0000 5208.0 \n", "145423 Régulier 8733-42-8631-4-000-0000 1288.0 \n", "477115 Régulier 9850-23-4636-8-000-0000 1557.0 \n", "454387 Régulier 9248-20-9242-3-000-0000 988.0 \n", "256642 Régulier 0558-41-1633-8-000-0000 1932.0 \n", "1688 Régulier 7239-19-1381-0-000-0000 2491.0 \n", "310939 Régulier 0559-42-4568-9-000-0000 2340.0 \n", "1552 Régulier 9351-61-0101-6-000-0000 6977.0 \n", "399516 Régulier 9132-34-3111-3-000-0000 593.0 \n", "479186 Régulier 0559-47-8645-0-000-0000 907.0 \n", "107241 Régulier 7530-16-2501-0-000-0000 2022.0 \n", "... ... ... ... \n", "509506 Régulier 7132-55-1151-8-000-0000 11373.0 \n", "509687 Condominium 9445-68-6642-8-001-0005 55.0 \n", "509782 Condominium 9633-22-6323-3-001-0002 131.0 \n", "510419 Régulier 8534-97-1487-4-000-0000 251.0 \n", "510426 Régulier 9232-60-9933-7-000-0000 31569.0 \n", "510438 Régulier 7934-56-2019-3-000-0000 20301.0 \n", "510629 Régulier 9550-81-4864-0-000-0000 309.0 \n", "510711 Régulier 7833-48-1563-2-000-0000 23764.0 \n", "510796 Condominium 0043-15-1804-2-002-0001 194.0 \n", "511083 Régulier 8534-31-2455-9-000-0000 3071.0 \n", "511091 Régulier 8942-14-1660-6-000-0000 189.0 \n", "511160 Condominium 7837-84-4763-1-001-0093 245.0 \n", "511168 Condominium 9144-70-8798-1-003-0001 209.0 \n", "511442 Régulier 9652-49-3099-5-000-0000 877.0 \n", "511603 Régulier 7232-43-8376-8-000-0000 92573.0 \n", "511843 Régulier 7733-40-7928-0-000-0000 294.0 \n", "511922 Condominium 9446-80-4005-3-001-0005 51.0 \n", "512018 Régulier 9734-47-1613-5-000-0000 343.0 \n", "512074 Condominium 9446-60-1943-0-001-0009 80.0 \n", "512104 Régulier 6930-32-5687-4-000-0000 1400.0 \n", "512173 Régulier 9748-55-8558-8-000-0000 3914.0 \n", "512244 Condominium 9941-19-3760-2-001-0001 42.0 \n", "512268 Condominium 9741-78-2378-4-001-0001 87.0 \n", "512329 Régulier 7638-08-0797-4-000-0000 3253.0 \n", "512340 Régulier 9538-57-5035-1-000-0000 121.0 \n", "512825 Condominium 9734-56-4154-8-001-0002 67.0 \n", "512857 Régulier 9641-96-0189-1-000-0000 348.0 \n", "512896 Condominium 9445-79-6453-7-001-0002 101.0 \n", "512940 Régulier 9438-71-7197-1-000-0000 251.0 \n", "513152 Condominium 9644-22-8451-7-006-0001 107.0 \n", "\n", " SUPERFICIE_BATIMENT NO_ARROND_ILE_CUM \n", "248297 4210.0 REM19 \n", "384551 400.0 REM24 \n", "407875 128.0 REM99 \n", "18975 478.0 REM99 \n", "431844 237.0 REM19 \n", "279461 120.0 REM27 \n", "452796 150.0 REM32 \n", "218190 548.0 REM19 \n", "40477 197.0 REM99 \n", "99690 138.0 REM32 \n", "114016 179.0 REM99 \n", "341043 224.0 REM14 \n", "462027 282.0 REM19 \n", "398659 136.0 REM27 \n", "176137 294.0 REM27 \n", "231302 143.0 REM16 \n", "323840 1364.0 REM19 \n", "263514 104.0 REM31 \n", "11273 107.0 REM33 \n", "199789 222.0 REM99 \n", "145423 164.0 REM99 \n", "477115 171.0 REM14 \n", "454387 67.0 REM23 \n", "256642 154.0 REM33 \n", "1688 NaN REM32 \n", "310939 236.0 REM33 \n", "1552 NaN REM16 \n", "399516 358.0 REM27 \n", "479186 106.0 REM33 \n", "107241 234.0 REM99 \n", "... ... ... \n", "509506 NaN REM99 \n", "509687 198.0 REM23 \n", "509782 249.0 REM17 \n", "510419 NaN REM99 \n", "510426 NaN REM17 \n", "510438 NaN REM99 \n", "510629 NaN REM14 \n", "510711 NaN REM99 \n", "510796 1927.0 REM19 \n", "511083 NaN REM99 \n", "511091 NaN REM15 \n", "511160 89.0 REM99 \n", "511168 NaN REM23 \n", "511442 NaN REM16 \n", "511603 NaN REM99 \n", "511843 NaN REM99 \n", "511922 200.0 REM23 \n", "512018 273.0 REM20 \n", "512074 206.0 REM23 \n", "512104 NaN REM99 \n", "512173 NaN REM14 \n", "512244 483.0 REM21 \n", "512268 453.0 REM21 \n", "512329 NaN REM32 \n", "512340 NaN REM99 \n", "512825 126.0 REM20 \n", "512857 NaN REM05 \n", "512896 529.0 REM23 \n", "512940 NaN REM34 \n", "513152 NaN REM24 \n", "\n", "[353850 rows x 16 columns]" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "# Load as dataframe\n", "df = pd.read_csv(filepath, sep = ',') #+|\\t+|\\s+\\t+|\\t+\\s+') \n", "df.sort_values(by='ANNEE_CONSTRUCTION', inplace=True)\n", "df.drop_duplicates(subset=['CIVIQUE_DEBUT', 'NOM_RUE'], inplace=True)\n", "display(df)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "##### Define a subset (Rosemont) - skip this to process entire dataframe" ] }, { "cell_type": "code", "execution_count": 5, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "24202\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
ID_UEVCIVIQUE_DEBUTCIVIQUE_FINNOM_RUESUITE_DEBUTMUNICIPALITEETAGE_HORS_SOLNOMBRE_LOGEMENTANNEE_CONSTRUCTIONCODE_UTILISATIONLIBELLE_UTILISATIONCATEGORIE_UEFMATRICULE83SUPERFICIE_TERRAINSUPERFICIE_BATIMENTNO_ARROND_ILE_CUM
384551310952562176221avenue Christophe-Colomb (MTL)NaN503.03.01600.01000LogementRégulier9744-11-0803-8-000-0000266.0400.0REM24
46185250056996450645238e Avenue (MTL)NaN501.02.01770.01000LogementRégulier9947-29-4444-8-000-0000892.0222.0REM24
228598301063065096511rue Saint-André (MTL)NaN502.02.01800.01000LogementRégulier9644-70-5299-2-000-000088.0171.0REM24
296078201104739103910rue de Bellechasse (MTL)NaN503.014.01800.01000LogementRégulier9846-76-8655-0-000-0000429.01068.0REM24
433347201023624332435rue Holt (MTL)NaN501.0NaN1850.03999Autres industries de produits manufacturésRégulier9844-29-3777-1-000-0000401.0331.0REM24
8358820319565784578618e Avenue (MTL)NaN502.02.01860.01000LogementRégulier9846-84-6401-5-000-0000232.0151.0REM24
319948301019164056407rue Saint-Hubert (MTL)NaN502.01.01890.01000LogementRégulier9644-70-8432-6-000-0000205.0352.0REM24
100166307916065066508rue Clark (MTL)NaN502.02.01890.01000LogementRégulier9643-13-7652-2-000-0000204.0140.0REM24
41082520340906209620923e Avenue (MTL)NaN502.01.01890.01000LogementRégulier9846-89-8544-9-000-0000202.0123.0REM24
256000300991464066416rue Saint-Hubert (MTL)NaN50NaN3.01890.01000LogementRégulier9643-79-6189-7-000-0000526.0836.0REM24
348869201903859265930boulevard Saint-Michel (MTL+MTN)NaN502.03.01894.01000LogementRégulier9845-49-4633-0-000-0000371.0212.0REM24
361761308069565516553rue Alma (MTL)NaN502.02.01895.01000LogementRégulier9643-46-1680-9-000-0000211.0155.0REM24
179375300888162946296rue De Saint-Vallier (MTL)NaN502.02.01895.01000LogementRégulier9643-77-6969-6-000-0000232.0187.0REM24
145100300923459615961rue De Saint-Vallier (MTL)NaN502.01.01895.01000LogementRégulier9643-96-8987-6-000-0000232.0141.0REM24
1221773081424207207avenue Mozart Est (MTL)NaN501.0NaN1895.05010Immeuble commercialRégulier9543-89-7456-0-000-0000221.0230.0REM24
185380512241267296731rue Drolet (MTL)NaN503.02.01898.01000LogementRégulier9643-29-3936-9-000-0000252.0NaNREM24
212334300975759895991avenue De Chateaubriand (MTL)NaN502.02.01898.01000LogementRégulier9743-07-6446-0-000-0000256.0167.0REM24
1943602018141541754199e Avenue (MTL)NaN502.02.01898.01000LogementRégulier9845-95-9078-6-000-0000181.0171.0REM24
256531512241167336735rue Drolet (MTL)NaN502.02.01898.01000LogementRégulier9643-29-3340-4-000-0000261.0NaNREM24
507909310989258005808rue Saint-Hubert (MTL)NaN502.02.01899.01000LogementRégulier9743-26-3086-7-000-0000509.0586.0REM24
2289602016936513051325e Avenue (MTL)NaN502.02.01900.01000LogementRégulier9945-11-3482-1-000-0000181.0170.0REM24
506401308041262816283avenue De Gaspé (MTL)NaN502.02.01900.01000LogementRégulier9643-54-9190-5-000-0000169.0164.0REM24
182092300928558135815rue De Saint-Vallier (MTL)NaN502.02.01900.01000LogementRégulier9743-15-5083-5-000-0000233.0172.0REM24
17612301032659575959rue Saint-Hubert (MTL)NaN502.02.01900.01000LogementRégulier9743-08-9928-2-000-0000202.0333.0REM24
428611300916265376539rue De Saint-Vallier (MTL)NaN502.02.01900.01000LogementRégulier9643-59-9145-8-000-0000232.0186.0REM24
16714307920963736375rue Clark (MTL)NaN502.02.01900.01000LogementRégulier9643-32-5293-7-000-0000195.0192.0REM24
428598301096558585862avenue Christophe-Colomb (MTL)NaN502.03.01900.01000LogementRégulier9743-29-9508-8-000-0000291.0191.0REM24
405273300965265316535avenue De Chateaubriand (MTL)NaN503.03.01900.01000LogementRégulier9644-60-6604-3-000-0000256.0251.0REM24
429489307968569756977boulevard Saint-Laurent (MTL)NaN503.0NaN1900.05010Immeuble commercialRégulier9543-87-0639-2-000-0000247.0560.0REM24
506397307980562736275rue Saint-Dominique (MTL)NaN502.02.01900.01000LogementRégulier9643-53-6249-4-000-0000150.0159.0REM24
...................................................
419799301014266256627rue Saint-Hubert (MTL)NaN50NaNNaNNaN5010Immeuble commercialRégulier9644-51-9359-0-000-0000251.0NaNREM24
424160215576755215521place De Jumonville (MTL)NaN50NaN1.0NaN1000LogementCondominium0048-62-2274-8-001-002493.0175.0REM24
42560950668429999999999rue du Canadien-Pacifique (MTL)NaN50NaNNaNNaN9100Espace de terrain non aménagé et non exploité ...Régulier9945-82-6122-1-000-00001911.0NaNREM24
426109300898167446744rue De Saint-Vallier (MTL)NaN502.02.0NaN1000LogementRégulier9644-30-0769-3-000-0000242.0156.0REM24
42779950197476287628721e Avenue (MTL)NaN503.01.0NaN1000LogementCondominium9846-68-9461-9-002-0001162.0172.0REM24
429730520012951005100rue Molson (MTL)NaN50NaNNaNNaN1990Autres immeubles résidentielsRégulier9944-07-9035-2-000-00002580.0NaNREM24
433752215553956155615place De Jumonville (MTL)NaN50NaN1.0NaN1000LogementCondominium0048-61-3547-8-001-002995.0NaNREM24
435695308037360406042avenue De Gaspé (MTL)NaN50NaNNaNNaN6379Autres entreposagesRégulier9643-73-8702-8-000-000012302.0NaNREM24
438403513577764196419rue D'Iberville (MTL)NaN50NaN6.0NaN1000LogementCondominium9745-64-8252-6-001-0010171.0NaNREM24
446249215577555235523place De Jumonville (MTL)NaN50NaN1.0NaN1000LogementCondominium0048-62-2274-8-001-002687.0175.0REM24
446672215577955335533place De Jumonville (MTL)NaN50NaN1.0NaN1000LogementCondominium0048-62-2274-8-001-002788.0175.0REM24
449903215553756055605place De Jumonville (MTL)NaN50NaN1.0NaN1000LogementCondominium0048-61-3547-8-001-002895.0186.0REM24
452896518618559415941rue Marquette (MTL)NaN502.01.0NaN1000LogementCondominium9744-55-8838-3-001-000742.0NaNREM24
453297201059052225222boulevard Rosemont (MTL)NaN50NaNNaNNaN7432Piscine intérieure et activités connexesRégulier9947-99-8034-6-000-000021105.0NaNREM24
457783304484370527056rue Saint-Hubert (MTL)NaN50NaN1.0NaN1000LogementRégulier9644-04-6540-7-000-0000253.0NaNREM24
464687306561768436845avenue Papineau (MTL)NaN50NaNNaNNaN7611Parc pour la récréation en généralRégulier9645-81-6018-9-000-00008628.0NaNREM24
464811513869722752275rue Dandurand (MTL)NaN50NaNNaNNaN6376Centre de distribution ou d'expédition de marc...Régulier9844-27-8961-0-000-00003294.0NaNREM24
465613202147356015601place De Jumonville (MTL)NaN50NaN1.0NaN1000LogementCondominium0048-61-3547-8-001-0003109.0186.0REM24
471497300992665346536rue Saint-Hubert (MTL)NaN50NaNNaNNaN5010Immeuble commercialRégulier9644-60-7147-2-000-0000511.0NaNREM24
47395220308475740574015e Avenue (MTL)NaN50NaNNaNNaN7239Autres aménagements publics pour différentes a...Régulier9846-81-0555-0-000-00001709.0NaNREM24
477027301019463916395rue Saint-Hubert (MTL)NaN50NaNNaNNaN5010Immeuble commercialRégulier9644-70-9723-7-000-0000205.0NaNREM24
477968300997066706674rue Saint-Hubert (MTL)NaN50NaN1.0NaN1000LogementRégulier9644-51-0157-7-000-0000253.0NaNREM24
481148301006668776881rue Saint-Hubert (MTL)NaN502.0NaNNaN5010Immeuble commercialRégulier9644-23-9153-6-000-0000238.0NaNREM24
484189301014066296631rue Saint-Hubert (MTL)NaN50NaNNaNNaN5010Immeuble commercialRégulier9644-51-8763-4-000-0000251.0NaNREM24
489091215552456135613place De Jumonville (MTL)NaN50NaN1.0NaN1000LogementCondominium0048-61-3547-8-001-0027102.0186.0REM24
496015304482571127116rue Saint-Hubert (MTL)NaN50NaNNaNNaN5010Immeuble commercialRégulier9544-94-9486-3-000-0000253.0NaNREM24
49643851309719999999999rue André-Laurendeau (MTL)NaN50NaNNaNNaN9100Espace de terrain non aménagé et non exploité ...Régulier9944-97-0684-7-000-000034.0NaNREM24
498877301004268986898rue Saint-Hubert (MTL)NaN50NaNNaNNaN5010Immeuble commercialRégulier9644-23-5019-3-000-0000253.0NaNREM24
502932301094259275927rue Boyer (MTL)NaN50NaNNaNNaN6812École élémentaireRégulier9743-29-0714-1-000-00001570.0NaNREM24
513152524355268376837avenue De Chateaubriand (MTL)NaN50NaN1.0NaN1000LogementCondominium9644-22-8451-7-006-0001107.0NaNREM24
\n", "

24202 rows × 16 columns

\n", "
" ], "text/plain": [ " ID_UEV CIVIQUE_DEBUT CIVIQUE_FIN \\\n", "384551 3109525 6217 6221 \n", "461852 5005699 6450 6452 \n", "228598 3010630 6509 6511 \n", "296078 2011047 3910 3910 \n", "433347 2010236 2433 2435 \n", "83588 2031956 5784 5786 \n", "319948 3010191 6405 6407 \n", "100166 3079160 6506 6508 \n", "410825 2034090 6209 6209 \n", "256000 3009914 6406 6416 \n", "348869 2019038 5926 5930 \n", "361761 3080695 6551 6553 \n", "179375 3008881 6294 6296 \n", "145100 3009234 5961 5961 \n", "122177 3081424 207 207 \n", "185380 5122412 6729 6731 \n", "212334 3009757 5989 5991 \n", "194360 2018141 5417 5419 \n", "256531 5122411 6733 6735 \n", "507909 3109892 5800 5808 \n", "228960 2016936 5130 5132 \n", "506401 3080412 6281 6283 \n", "182092 3009285 5813 5815 \n", "17612 3010326 5957 5959 \n", "428611 3009162 6537 6539 \n", "16714 3079209 6373 6375 \n", "428598 3010965 5858 5862 \n", "405273 3009652 6531 6535 \n", "429489 3079685 6975 6977 \n", "506397 3079805 6273 6275 \n", "... ... ... ... \n", "419799 3010142 6625 6627 \n", "424160 2155767 5521 5521 \n", "425609 5066842 99999 99999 \n", "426109 3008981 6744 6744 \n", "427799 5019747 6287 6287 \n", "429730 5200129 5100 5100 \n", "433752 2155539 5615 5615 \n", "435695 3080373 6040 6042 \n", "438403 5135777 6419 6419 \n", "446249 2155775 5523 5523 \n", "446672 2155779 5533 5533 \n", "449903 2155537 5605 5605 \n", "452896 5186185 5941 5941 \n", "453297 2010590 5222 5222 \n", "457783 3044843 7052 7056 \n", "464687 3065617 6843 6845 \n", "464811 5138697 2275 2275 \n", "465613 2021473 5601 5601 \n", "471497 3009926 6534 6536 \n", "473952 2030847 5740 5740 \n", "477027 3010194 6391 6395 \n", "477968 3009970 6670 6674 \n", "481148 3010066 6877 6881 \n", "484189 3010140 6629 6631 \n", "489091 2155524 5613 5613 \n", "496015 3044825 7112 7116 \n", "496438 5130971 99999 99999 \n", "498877 3010042 6898 6898 \n", "502932 3010942 5927 5927 \n", "513152 5243552 6837 6837 \n", "\n", " NOM_RUE SUITE_DEBUT MUNICIPALITE \\\n", "384551 avenue Christophe-Colomb (MTL) NaN 50 \n", "461852 38e Avenue (MTL) NaN 50 \n", "228598 rue Saint-André (MTL) NaN 50 \n", "296078 rue de Bellechasse (MTL) NaN 50 \n", "433347 rue Holt (MTL) NaN 50 \n", "83588 18e Avenue (MTL) NaN 50 \n", "319948 rue Saint-Hubert (MTL) NaN 50 \n", "100166 rue Clark (MTL) NaN 50 \n", "410825 23e Avenue (MTL) NaN 50 \n", "256000 rue Saint-Hubert (MTL) NaN 50 \n", "348869 boulevard Saint-Michel (MTL+MTN) NaN 50 \n", "361761 rue Alma (MTL) NaN 50 \n", "179375 rue De Saint-Vallier (MTL) NaN 50 \n", "145100 rue De Saint-Vallier (MTL) NaN 50 \n", "122177 avenue Mozart Est (MTL) NaN 50 \n", "185380 rue Drolet (MTL) NaN 50 \n", "212334 avenue De Chateaubriand (MTL) NaN 50 \n", "194360 9e Avenue (MTL) NaN 50 \n", "256531 rue Drolet (MTL) NaN 50 \n", "507909 rue Saint-Hubert (MTL) NaN 50 \n", "228960 5e Avenue (MTL) NaN 50 \n", "506401 avenue De Gaspé (MTL) NaN 50 \n", "182092 rue De Saint-Vallier (MTL) NaN 50 \n", "17612 rue Saint-Hubert (MTL) NaN 50 \n", "428611 rue De Saint-Vallier (MTL) NaN 50 \n", "16714 rue Clark (MTL) NaN 50 \n", "428598 avenue Christophe-Colomb (MTL) NaN 50 \n", "405273 avenue De Chateaubriand (MTL) NaN 50 \n", "429489 boulevard Saint-Laurent (MTL) NaN 50 \n", "506397 rue Saint-Dominique (MTL) NaN 50 \n", "... ... ... ... \n", "419799 rue Saint-Hubert (MTL) NaN 50 \n", "424160 place De Jumonville (MTL) NaN 50 \n", "425609 rue du Canadien-Pacifique (MTL) NaN 50 \n", "426109 rue De Saint-Vallier (MTL) NaN 50 \n", "427799 21e Avenue (MTL) NaN 50 \n", "429730 rue Molson (MTL) NaN 50 \n", "433752 place De Jumonville (MTL) NaN 50 \n", "435695 avenue De Gaspé (MTL) NaN 50 \n", "438403 rue D'Iberville (MTL) NaN 50 \n", "446249 place De Jumonville (MTL) NaN 50 \n", "446672 place De Jumonville (MTL) NaN 50 \n", "449903 place De Jumonville (MTL) NaN 50 \n", "452896 rue Marquette (MTL) NaN 50 \n", "453297 boulevard Rosemont (MTL) NaN 50 \n", "457783 rue Saint-Hubert (MTL) NaN 50 \n", "464687 avenue Papineau (MTL) NaN 50 \n", "464811 rue Dandurand (MTL) NaN 50 \n", "465613 place De Jumonville (MTL) NaN 50 \n", "471497 rue Saint-Hubert (MTL) NaN 50 \n", "473952 15e Avenue (MTL) NaN 50 \n", "477027 rue Saint-Hubert (MTL) NaN 50 \n", "477968 rue Saint-Hubert (MTL) NaN 50 \n", "481148 rue Saint-Hubert (MTL) NaN 50 \n", "484189 rue Saint-Hubert (MTL) NaN 50 \n", "489091 place De Jumonville (MTL) NaN 50 \n", "496015 rue Saint-Hubert (MTL) NaN 50 \n", "496438 rue André-Laurendeau (MTL) NaN 50 \n", "498877 rue Saint-Hubert (MTL) NaN 50 \n", "502932 rue Boyer (MTL) NaN 50 \n", "513152 avenue De Chateaubriand (MTL) NaN 50 \n", "\n", " ETAGE_HORS_SOL NOMBRE_LOGEMENT ANNEE_CONSTRUCTION CODE_UTILISATION \\\n", "384551 3.0 3.0 1600.0 1000 \n", "461852 1.0 2.0 1770.0 1000 \n", "228598 2.0 2.0 1800.0 1000 \n", "296078 3.0 14.0 1800.0 1000 \n", "433347 1.0 NaN 1850.0 3999 \n", "83588 2.0 2.0 1860.0 1000 \n", "319948 2.0 1.0 1890.0 1000 \n", "100166 2.0 2.0 1890.0 1000 \n", "410825 2.0 1.0 1890.0 1000 \n", "256000 NaN 3.0 1890.0 1000 \n", "348869 2.0 3.0 1894.0 1000 \n", "361761 2.0 2.0 1895.0 1000 \n", "179375 2.0 2.0 1895.0 1000 \n", "145100 2.0 1.0 1895.0 1000 \n", "122177 1.0 NaN 1895.0 5010 \n", "185380 3.0 2.0 1898.0 1000 \n", "212334 2.0 2.0 1898.0 1000 \n", "194360 2.0 2.0 1898.0 1000 \n", "256531 2.0 2.0 1898.0 1000 \n", "507909 2.0 2.0 1899.0 1000 \n", "228960 2.0 2.0 1900.0 1000 \n", "506401 2.0 2.0 1900.0 1000 \n", "182092 2.0 2.0 1900.0 1000 \n", "17612 2.0 2.0 1900.0 1000 \n", "428611 2.0 2.0 1900.0 1000 \n", "16714 2.0 2.0 1900.0 1000 \n", "428598 2.0 3.0 1900.0 1000 \n", "405273 3.0 3.0 1900.0 1000 \n", "429489 3.0 NaN 1900.0 5010 \n", "506397 2.0 2.0 1900.0 1000 \n", "... ... ... ... ... \n", "419799 NaN NaN NaN 5010 \n", "424160 NaN 1.0 NaN 1000 \n", "425609 NaN NaN NaN 9100 \n", "426109 2.0 2.0 NaN 1000 \n", "427799 3.0 1.0 NaN 1000 \n", "429730 NaN NaN NaN 1990 \n", "433752 NaN 1.0 NaN 1000 \n", "435695 NaN NaN NaN 6379 \n", "438403 NaN 6.0 NaN 1000 \n", "446249 NaN 1.0 NaN 1000 \n", "446672 NaN 1.0 NaN 1000 \n", "449903 NaN 1.0 NaN 1000 \n", "452896 2.0 1.0 NaN 1000 \n", "453297 NaN NaN NaN 7432 \n", "457783 NaN 1.0 NaN 1000 \n", "464687 NaN NaN NaN 7611 \n", "464811 NaN NaN NaN 6376 \n", "465613 NaN 1.0 NaN 1000 \n", "471497 NaN NaN NaN 5010 \n", "473952 NaN NaN NaN 7239 \n", "477027 NaN NaN NaN 5010 \n", "477968 NaN 1.0 NaN 1000 \n", "481148 2.0 NaN NaN 5010 \n", "484189 NaN NaN NaN 5010 \n", "489091 NaN 1.0 NaN 1000 \n", "496015 NaN NaN NaN 5010 \n", "496438 NaN NaN NaN 9100 \n", "498877 NaN NaN NaN 5010 \n", "502932 NaN NaN NaN 6812 \n", "513152 NaN 1.0 NaN 1000 \n", "\n", " LIBELLE_UTILISATION CATEGORIE_UEF \\\n", "384551 Logement Régulier \n", "461852 Logement Régulier \n", "228598 Logement Régulier \n", "296078 Logement Régulier \n", "433347 Autres industries de produits manufacturés Régulier \n", "83588 Logement Régulier \n", "319948 Logement Régulier \n", "100166 Logement Régulier \n", "410825 Logement Régulier \n", "256000 Logement Régulier \n", "348869 Logement Régulier \n", "361761 Logement Régulier \n", "179375 Logement Régulier \n", "145100 Logement Régulier \n", "122177 Immeuble commercial Régulier \n", "185380 Logement Régulier \n", "212334 Logement Régulier \n", "194360 Logement Régulier \n", "256531 Logement Régulier \n", "507909 Logement Régulier \n", "228960 Logement Régulier \n", "506401 Logement Régulier \n", "182092 Logement Régulier \n", "17612 Logement Régulier \n", "428611 Logement Régulier \n", "16714 Logement Régulier \n", "428598 Logement Régulier \n", "405273 Logement Régulier \n", "429489 Immeuble commercial Régulier \n", "506397 Logement Régulier \n", "... ... ... \n", "419799 Immeuble commercial Régulier \n", "424160 Logement Condominium \n", "425609 Espace de terrain non aménagé et non exploité ... Régulier \n", "426109 Logement Régulier \n", "427799 Logement Condominium \n", "429730 Autres immeubles résidentiels Régulier \n", "433752 Logement Condominium \n", "435695 Autres entreposages Régulier \n", "438403 Logement Condominium \n", "446249 Logement Condominium \n", "446672 Logement Condominium \n", "449903 Logement Condominium \n", "452896 Logement Condominium \n", "453297 Piscine intérieure et activités connexes Régulier \n", "457783 Logement Régulier \n", "464687 Parc pour la récréation en général Régulier \n", "464811 Centre de distribution ou d'expédition de marc... Régulier \n", "465613 Logement Condominium \n", "471497 Immeuble commercial Régulier \n", "473952 Autres aménagements publics pour différentes a... Régulier \n", "477027 Immeuble commercial Régulier \n", "477968 Logement Régulier \n", "481148 Immeuble commercial Régulier \n", "484189 Immeuble commercial Régulier \n", "489091 Logement Condominium \n", "496015 Immeuble commercial Régulier \n", "496438 Espace de terrain non aménagé et non exploité ... Régulier \n", "498877 Immeuble commercial Régulier \n", "502932 École élémentaire Régulier \n", "513152 Logement Condominium \n", "\n", " MATRICULE83 SUPERFICIE_TERRAIN SUPERFICIE_BATIMENT \\\n", "384551 9744-11-0803-8-000-0000 266.0 400.0 \n", "461852 9947-29-4444-8-000-0000 892.0 222.0 \n", "228598 9644-70-5299-2-000-0000 88.0 171.0 \n", "296078 9846-76-8655-0-000-0000 429.0 1068.0 \n", "433347 9844-29-3777-1-000-0000 401.0 331.0 \n", "83588 9846-84-6401-5-000-0000 232.0 151.0 \n", "319948 9644-70-8432-6-000-0000 205.0 352.0 \n", "100166 9643-13-7652-2-000-0000 204.0 140.0 \n", "410825 9846-89-8544-9-000-0000 202.0 123.0 \n", "256000 9643-79-6189-7-000-0000 526.0 836.0 \n", "348869 9845-49-4633-0-000-0000 371.0 212.0 \n", "361761 9643-46-1680-9-000-0000 211.0 155.0 \n", "179375 9643-77-6969-6-000-0000 232.0 187.0 \n", "145100 9643-96-8987-6-000-0000 232.0 141.0 \n", "122177 9543-89-7456-0-000-0000 221.0 230.0 \n", "185380 9643-29-3936-9-000-0000 252.0 NaN \n", "212334 9743-07-6446-0-000-0000 256.0 167.0 \n", "194360 9845-95-9078-6-000-0000 181.0 171.0 \n", "256531 9643-29-3340-4-000-0000 261.0 NaN \n", "507909 9743-26-3086-7-000-0000 509.0 586.0 \n", "228960 9945-11-3482-1-000-0000 181.0 170.0 \n", "506401 9643-54-9190-5-000-0000 169.0 164.0 \n", "182092 9743-15-5083-5-000-0000 233.0 172.0 \n", "17612 9743-08-9928-2-000-0000 202.0 333.0 \n", "428611 9643-59-9145-8-000-0000 232.0 186.0 \n", "16714 9643-32-5293-7-000-0000 195.0 192.0 \n", "428598 9743-29-9508-8-000-0000 291.0 191.0 \n", "405273 9644-60-6604-3-000-0000 256.0 251.0 \n", "429489 9543-87-0639-2-000-0000 247.0 560.0 \n", "506397 9643-53-6249-4-000-0000 150.0 159.0 \n", "... ... ... ... \n", "419799 9644-51-9359-0-000-0000 251.0 NaN \n", "424160 0048-62-2274-8-001-0024 93.0 175.0 \n", "425609 9945-82-6122-1-000-0000 1911.0 NaN \n", "426109 9644-30-0769-3-000-0000 242.0 156.0 \n", "427799 9846-68-9461-9-002-0001 162.0 172.0 \n", "429730 9944-07-9035-2-000-0000 2580.0 NaN \n", "433752 0048-61-3547-8-001-0029 95.0 NaN \n", "435695 9643-73-8702-8-000-0000 12302.0 NaN \n", "438403 9745-64-8252-6-001-0010 171.0 NaN \n", "446249 0048-62-2274-8-001-0026 87.0 175.0 \n", "446672 0048-62-2274-8-001-0027 88.0 175.0 \n", "449903 0048-61-3547-8-001-0028 95.0 186.0 \n", "452896 9744-55-8838-3-001-0007 42.0 NaN \n", "453297 9947-99-8034-6-000-0000 21105.0 NaN \n", "457783 9644-04-6540-7-000-0000 253.0 NaN \n", "464687 9645-81-6018-9-000-0000 8628.0 NaN \n", "464811 9844-27-8961-0-000-0000 3294.0 NaN \n", "465613 0048-61-3547-8-001-0003 109.0 186.0 \n", "471497 9644-60-7147-2-000-0000 511.0 NaN \n", "473952 9846-81-0555-0-000-0000 1709.0 NaN \n", "477027 9644-70-9723-7-000-0000 205.0 NaN \n", "477968 9644-51-0157-7-000-0000 253.0 NaN \n", "481148 9644-23-9153-6-000-0000 238.0 NaN \n", "484189 9644-51-8763-4-000-0000 251.0 NaN \n", "489091 0048-61-3547-8-001-0027 102.0 186.0 \n", "496015 9544-94-9486-3-000-0000 253.0 NaN \n", "496438 9944-97-0684-7-000-0000 34.0 NaN \n", "498877 9644-23-5019-3-000-0000 253.0 NaN \n", "502932 9743-29-0714-1-000-0000 1570.0 NaN \n", "513152 9644-22-8451-7-006-0001 107.0 NaN \n", "\n", " NO_ARROND_ILE_CUM \n", "384551 REM24 \n", "461852 REM24 \n", "228598 REM24 \n", "296078 REM24 \n", "433347 REM24 \n", "83588 REM24 \n", "319948 REM24 \n", "100166 REM24 \n", "410825 REM24 \n", "256000 REM24 \n", "348869 REM24 \n", "361761 REM24 \n", "179375 REM24 \n", "145100 REM24 \n", "122177 REM24 \n", "185380 REM24 \n", "212334 REM24 \n", "194360 REM24 \n", "256531 REM24 \n", "507909 REM24 \n", "228960 REM24 \n", "506401 REM24 \n", "182092 REM24 \n", "17612 REM24 \n", "428611 REM24 \n", "16714 REM24 \n", "428598 REM24 \n", "405273 REM24 \n", "429489 REM24 \n", "506397 REM24 \n", "... ... \n", "419799 REM24 \n", "424160 REM24 \n", "425609 REM24 \n", "426109 REM24 \n", "427799 REM24 \n", "429730 REM24 \n", "433752 REM24 \n", "435695 REM24 \n", "438403 REM24 \n", "446249 REM24 \n", "446672 REM24 \n", "449903 REM24 \n", "452896 REM24 \n", "453297 REM24 \n", "457783 REM24 \n", "464687 REM24 \n", "464811 REM24 \n", "465613 REM24 \n", "471497 REM24 \n", "473952 REM24 \n", "477027 REM24 \n", "477968 REM24 \n", "481148 REM24 \n", "484189 REM24 \n", "489091 REM24 \n", "496015 REM24 \n", "496438 REM24 \n", "498877 REM24 \n", "502932 REM24 \n", "513152 REM24 \n", "\n", "[24202 rows x 16 columns]" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "df = df.loc[df['NO_ARROND_ILE_CUM'] == \"REM24\"]\n", "print(len(df))\n", "display(df)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "##### Run the geolocator on the list of addresses" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "0 0 6217 avenue Christophe-Colomb [ -73.59864732 45.53662994 1600. 400. ]\n", "1 0 6217 avenue Christophe-Colomb [ -73.57153973 45.57164746 1770. 222. ]\n", "2 0 6217 avenue Christophe-Colomb [ -73.6031863 45.5368444 1800. 171. ]\n", "3 0 6217 avenue Christophe-Colomb [ -73.5771697 45.5598532 1800. 1068. ]\n", "4 0 6217 avenue Christophe-Colomb [ -73.58395337 45.54454671 1850. 331. ]\n", "5 0 6217 avenue Christophe-Colomb [ -73.57589659 45.55760134 1860. 151. ]\n", "6 0 6217 avenue Christophe-Colomb [ -73.60270686 45.53606679 1890. 352. ]\n", "7 0 6217 avenue Christophe-Colomb [ -73.6101503 45.5300675 1890. 140. ]\n", "8 0 6217 avenue Christophe-Colomb [ -73.5754868 45.5622206 1890. 123. ]\n", "9 0 6217 avenue Christophe-Colomb [ -73.6025014 45.5362344 1890. 836. ]\n", "10 0 6217 avenue Christophe-Colomb [ -73.58139779 45.5534969 1894. 212. ]\n", "11 0 6217 avenue Christophe-Colomb [ -73.60722802 45.53286279 1895. 155. ]\n", "12 0 6217 avenue Christophe-Colomb [ -73.60276384 45.5339423 1895. 187. ]\n", "13 0 6217 avenue Christophe-Colomb [ -73.60008454 45.532941 1895. 141. ]\n", "14 0 6217 avenue Christophe-Colomb [ -73.61415673 45.53535156 1895. 230. ]\n", "15 0 6217 avenue Christophe-Colomb [ -73.60967593 45.53514532 1898. nan]\n", "16 0 6217 avenue Christophe-Colomb [ -73.599299 45.533448 1898. 167. ]\n", "17 0 6217 avenue Christophe-Colomb [ -73.57424357 45.5499536 1898. 171. ]\n", "18 0 6217 avenue Christophe-Colomb [ -73.60973774 45.53517292 1898. nan]\n", "19 0 6217 avenue Christophe-Colomb [ -73.5967758 45.5331622 1899. 586. ]\n", "20 0 6217 avenue Christophe-Colomb [ -73.5721456 45.5465051 1900. 170. ]\n", "21 0 6217 avenue Christophe-Colomb [ -73.6171224 45.5369169 1900. 164. ]\n", "22 0 6217 avenue Christophe-Colomb [ -73.59804571 45.53200721 1900. 172. ]\n", "23 0 6217 avenue Christophe-Colomb [ -73.59870613 45.53425223 1900. 333. ]\n", "24 0 6217 avenue Christophe-Colomb [ -73.6044068 45.534891 1900. 186. ]\n", "25 0 6217 avenue Christophe-Colomb [ -73.60821591 45.52941526 1900. 192. ]\n", "26 0 6217 avenue Christophe-Colomb [ -73.59589021 45.53519494 1900. 191. ]\n", "27 0 6217 avenue Christophe-Colomb [ -73.60424288 45.53577773 1900. 251. ]\n", "28 0 6217 avenue Christophe-Colomb [ -73.61519141 45.53337286 1900. 560. ]\n", "29 0 6217 avenue Christophe-Colomb [ -73.60489194 45.529601 1900. 159. ]\n", "30 0 6217 avenue Christophe-Colomb [ -73.59916003 45.53325582 1900. 191. ]\n", "31 0 6217 avenue Christophe-Colomb [ -73.60518038 45.53233746 1900. 298. ]\n", "32 0 6217 avenue Christophe-Colomb [ -73.59442421 45.53315925 1900. 139. ]\n", "33 0 6217 avenue Christophe-Colomb [ -73.59903973 45.53505218 1900. nan]\n", "34 0 6217 avenue Christophe-Colomb [ -73.60979954 45.53520052 1900. 140. ]\n", "35 0 6217 avenue Christophe-Colomb [ -73.60960239 45.54043648 1900. 98. ]\n", "36 0 6217 avenue Christophe-Colomb [ -73.60281378 45.5349226 1900. nan]\n", "37 0 6217 avenue Christophe-Colomb [ -73.6110685 45.53685489 1900. 422. ]\n", "38 0 6217 avenue Christophe-Colomb [ -73.60230538 45.53373672 1900. 323. ]\n", "39 0 6217 avenue Christophe-Colomb [ -73.6064464 45.5280175 1900. 154. ]\n", "40 0 6217 avenue Christophe-Colomb [ -73.61236374 45.53377708 1900. 123. ]\n", "41 0 6217 avenue Christophe-Colomb [ -73.6171224 45.5369169 1900. 128. ]\n", "42 0 6217 avenue Christophe-Colomb [ -73.60772779 45.53713105 1900. 198. ]\n", "43 0 6217 avenue Christophe-Colomb [ -73.5977287 45.5236418 1900. 147. ]\n", "44 0 6217 avenue Christophe-Colomb [ -73.60854269 45.52955637 1900. 232. ]\n", "45 0 6217 avenue Christophe-Colomb [ -73.60792032 45.53721868 1900. 88. ]\n", "46 0 6217 avenue Christophe-Colomb [ -73.60181498 45.53651896 1900. 315. ]\n", "47 0 6217 avenue Christophe-Colomb [ -73.6093919 45.53717236 1900. 130. ]\n", "48 0 6217 avenue Christophe-Colomb [ -73.6100627 45.53747825 1900. 146. ]\n", "49 0 6217 avenue Christophe-Colomb [ -73.60080089 45.53326909 1900. nan]\n", "50 0 6217 avenue Christophe-Colomb [ -73.59939189 45.53435311 1900. 258. ]\n", "51 0 6217 avenue Christophe-Colomb [ -73.60933223 45.53786131 1900. 227. ]\n", "52 0 6217 avenue Christophe-Colomb [ -73.60617246 45.5290544 1900. 229. ]\n", "53 0 6217 avenue Christophe-Colomb [ -73.61326108 45.53143028 1900. 187. ]\n", "54 0 6217 avenue Christophe-Colomb [ -73.60511748 45.53521682 1900. 163. ]\n", "55 0 6217 avenue Christophe-Colomb [ -73.6133655 45.53875539 1900. 184. ]\n", "56 0 6217 avenue Christophe-Colomb [ -73.59634138 45.53386756 1900. 214. ]\n", "57 0 6217 avenue Christophe-Colomb [ -73.60863725 45.53682823 1900. nan]\n", "58 0 6217 avenue Christophe-Colomb [ -73.59968072 45.5381746 1900. 183. ]\n", "59 0 6217 avenue Christophe-Colomb [ -73.60702254 45.52964926 1900. 210. ]\n", "60 0 6217 avenue Christophe-Colomb [ -73.60106622 45.53617067 1900. 139. ]\n", "61 0 6217 avenue Christophe-Colomb [ -73.60920705 45.53041807 1900. 660. ]\n", "62 0 6217 avenue Christophe-Colomb [ -73.6090979 45.5335944 1900. 81. ]\n", "63 0 6217 avenue Christophe-Colomb [ -73.59854773 45.53498353 1900. nan]\n", "64 0 6217 avenue Christophe-Colomb [ -73.59836685 45.53194266 1900. 175. ]\n", "65 0 6217 avenue Christophe-Colomb [ -73.6058589 45.5289123 1900. 348. ]\n", "66 0 6217 avenue Christophe-Colomb [ -73.59809792 45.53397533 1900. 166. ]\n", "67 0 6217 avenue Christophe-Colomb [ -73.60881881 45.53762762 1900. 201. ]\n", "68 0 6217 avenue Christophe-Colomb [ -73.6171224 45.5369169 1900. 158. ]\n", "69 0 6217 avenue Christophe-Colomb [ -73.59871797 45.5330522 1900. 205. ]\n", "70 0 6217 avenue Christophe-Colomb [ -73.60218231 45.53582923 1900. 216. ]\n", "71 0 6217 avenue Christophe-Colomb [ -73.60263668 45.53582414 1900. 339. ]\n", "72 0 6217 avenue Christophe-Colomb [ -73.60276156 45.53489894 1900. nan]\n", "73 0 6217 avenue Christophe-Colomb [ -73.60329307 45.53633146 1900. 315. ]\n", "74 0 6217 avenue Christophe-Colomb [ -73.6171224 45.5369169 1900. 184. ]\n", "75 0 6217 avenue Christophe-Colomb [ -73.59897057 45.53437261 1900. 395. ]\n", "76 0 6217 avenue Christophe-Colomb [ -73.59475181 45.53249604 1900. 156. ]\n", "77 0 6217 avenue Christophe-Colomb [ -73.60870664 45.53664848 1900. 205. ]\n", "78 0 6217 avenue Christophe-Colomb [ -73.60226514 45.53586674 1900. 403. ]\n", "79 0 6217 avenue Christophe-Colomb [ -73.60872254 45.53758381 1900. 170. ]\n", "80 0 6217 avenue Christophe-Colomb [ -73.60665531 45.53202571 1900. nan]\n", "81 0 6217 avenue Christophe-Colomb [ -73.59138261 45.54090765 1900. 320. ]\n", "82 0 6217 avenue Christophe-Colomb [ -73.6021308 45.53386878 1900. 198. ]\n", "83 0 6217 avenue Christophe-Colomb [ -73.60027817 45.53377088 1900. 158. ]\n", "84 0 6217 avenue Christophe-Colomb [ -73.6090979 45.5335944 1900. 82. ]\n", "85 0 6217 avenue Christophe-Colomb [ -73.60698909 45.53927979 1900. 187. ]\n", "86 0 6217 avenue Christophe-Colomb [ -73.6086652 45.53684097 1900. nan]\n", "87 0 6217 avenue Christophe-Colomb [ -73.57186012 45.5485664 1900. 138. ]\n" ] }, { "name": "stdout", "output_type": "stream", "text": [ "88 0 6217 avenue Christophe-Colomb [ -73.610798 45.52929838 1900. 171. ]\n", "89 0 6217 avenue Christophe-Colomb [ -73.60932663 45.52990823 1900. 71. ]\n", "90 0 6217 avenue Christophe-Colomb [ -73.59578691 45.53356588 1900. 185. ]\n", "91 0 6217 avenue Christophe-Colomb [ -73.6171224 45.5369169 1900. 166. ]\n", "92 0 6217 avenue Christophe-Colomb [ -73.60927419 45.53236864 1900. 138. ]\n", "93 0 6217 avenue Christophe-Colomb [ -73.60052537 45.5331429 1900. 276. ]\n", "94 0 6217 avenue Christophe-Colomb [ -73.6125699 45.5383994 1900. 225. ]\n", "95 0 6217 avenue Christophe-Colomb [ -73.59845585 45.533927 1900. 182. ]\n", "96 0 6217 avenue Christophe-Colomb [ -73.6090979 45.5335944 1900. 139. ]\n", "97 0 6217 avenue Christophe-Colomb [ -73.59831326 45.53473324 1900. 147. ]\n", "98 0 6217 avenue Christophe-Colomb [ -73.6040507 45.5349387 1900. 740. ]\n", "99 0 6217 avenue Christophe-Colomb [ -73.6171224 45.5369169 1900. 309. ]\n", "100 0 6217 avenue Christophe-Colomb [ -73.60667544 45.53200404 1900. nan]\n", "101 0 6217 avenue Christophe-Colomb [ -73.6056717 45.53525919 1900. 197. ]\n", "102 0 6217 avenue Christophe-Colomb [ -73.59443611 45.53235382 1900. 187. ]\n", "103 0 6217 avenue Christophe-Colomb [ -73.60923596 45.53781749 1900. 320. ]\n", "104 0 6217 avenue Christophe-Colomb [ -73.60796645 45.53652234 1900. 186. ]\n", "105 0 6217 avenue Christophe-Colomb [ -73.61617754 45.52876117 1900. 253. ]\n", "106 0 6217 avenue Christophe-Colomb [ -73.60905323 45.53034919 1900. 736. ]\n", "107 0 6217 avenue Christophe-Colomb [ -73.61486586 45.52869392 1900. 166. ]\n", "108 0 6217 avenue Christophe-Colomb [ -73.60903608 45.53679871 1900. 220. ]\n", "109 0 6217 avenue Christophe-Colomb [ -73.61081735 45.53782238 1900. 207. ]\n", "110 0 6217 avenue Christophe-Colomb [ -73.60717935 45.5295092 1900. 246. ]\n", "111 0 6217 avenue Christophe-Colomb [ -73.5977287 45.5236418 1900. 127. ]\n", "112 0 6217 avenue Christophe-Colomb [ -73.60473439 45.5357876 1900. 285. ]\n", "113 0 6217 avenue Christophe-Colomb [ -73.6064464 45.5280175 1900. 221. ]\n", "114 0 6217 avenue Christophe-Colomb [ -73.60176696 45.53630931 1900. 139. ]\n", "115 0 6217 avenue Christophe-Colomb [ -73.60322231 45.53414789 1900. 177. ]\n", "116 0 6217 avenue Christophe-Colomb [ -73.6171224 45.5369169 1900. 169. ]\n", "117 0 6217 avenue Christophe-Colomb [ -73.6033883 45.5357867 1900. 307. ]\n", "118 0 6217 avenue Christophe-Colomb [ -73.61267781 45.53421573 1900. 134. ]\n", "119 0 6217 avenue Christophe-Colomb [ -73.6090979 45.5335944 1900. 139. ]\n", "120 0 6217 avenue Christophe-Colomb [ -73.59964371 45.5327391 1900. 195. ]\n", "121 0 6217 avenue Christophe-Colomb [ -73.60377123 45.53169631 1900. 159. ]\n", "122 0 6217 avenue Christophe-Colomb [ -73.60330982 45.53514737 1900. 195. ]\n", "123 0 6217 avenue Christophe-Colomb [ -73.6041286 45.5347973 1900. 298. ]\n", "124 0 6217 avenue Christophe-Colomb [ -73.59972637 45.53277696 1900. 188. ]\n", "125 0 6217 avenue Christophe-Colomb [ -73.6148502 45.53234613 1900. 165. ]\n", "126 0 6217 avenue Christophe-Colomb [ -73.59449644 45.53319162 1900. 86. ]\n", "127 0 6217 avenue Christophe-Colomb [ -73.6090979 45.5335944 1900. nan]\n", "128 0 6217 avenue Christophe-Colomb [ -73.6090979 45.5335944 1900. 247. ]\n", "129 0 6217 avenue Christophe-Colomb [ -73.59947207 45.53339956 1900. 218. ]\n", "130 0 6217 avenue Christophe-Colomb [ -73.61273568 45.53548442 1900. 177. ]\n", "131 0 6217 avenue Christophe-Colomb [ -73.60291843 45.535181 1900. 155. ]\n", "132 0 6217 avenue Christophe-Colomb [ -73.60458229 45.53002517 1900. 129. ]\n", "133 0 6217 avenue Christophe-Colomb [ -73.60196071 45.53474704 1900. 177. ]\n", "134 0 6217 avenue Christophe-Colomb [ -73.5974266 45.5336541 1900. 200. ]\n", "135 0 6217 avenue Christophe-Colomb [ -73.60373998 45.53869123 1900. 179. ]\n", "136 0 6217 avenue Christophe-Colomb [ -73.60713658 45.53806264 1900. nan]\n", "137 0 6217 avenue Christophe-Colomb [ -73.59582041 45.53516392 1900. 169. ]\n", "138 0 6217 avenue Christophe-Colomb [ -73.60544696 45.53859644 1900. 231. ]\n", "139 0 6217 avenue Christophe-Colomb [ -73.61174951 45.53078301 1900. 154. ]\n", "140 0 6217 avenue Christophe-Colomb [ -73.5977287 45.5236418 1900. 171. ]\n", "141 0 6217 avenue Christophe-Colomb [ -73.6171224 45.5369169 1900. 150. ]\n", "142 0 6217 avenue Christophe-Colomb [ -73.60830718 45.53760607 1900. 167. ]\n", "143 0 6217 avenue Christophe-Colomb [ -73.61286725 45.53874261 1900. 162. ]\n", "144 0 6217 avenue Christophe-Colomb [ -73.60142852 45.5363392 1900. 127. ]\n", "145 0 6217 avenue Christophe-Colomb [ -73.61065584 45.53753735 1900. 101. ]\n", "146 0 6217 avenue Christophe-Colomb [ -73.6171224 45.5369169 1900. 309. ]\n", "147 0 6217 avenue Christophe-Colomb [ -73.60814965 45.52939024 1900. 160. ]\n", "148 0 6217 avenue Christophe-Colomb [ -73.6095577 45.53703658 1900. 211. ]\n", "149 0 6217 avenue Christophe-Colomb [ -73.60307485 45.5350409 1900. 206. ]\n", "150 0 6217 avenue Christophe-Colomb [ -73.6008035 45.5340117 1900. 155. ]\n", "151 0 6217 avenue Christophe-Colomb [ -73.60586765 45.53556075 1900. 172. ]\n", "152 0 6217 avenue Christophe-Colomb [ -73.61019092 45.53278522 1900. 213. ]\n", "153 0 6217 avenue Christophe-Colomb [ -73.60582858 45.53263238 1900. 241. ]\n", "154 0 6217 avenue Christophe-Colomb [ -73.61141207 45.53879969 1900. 163. ]\n", "155 0 6217 avenue Christophe-Colomb [ -73.6171224 45.5369169 1900. 167. ]\n", "156 0 6217 avenue Christophe-Colomb [ -73.59797584 45.53370849 1900. 151. ]\n", "157 0 6217 avenue Christophe-Colomb [ -73.60267788 45.53390376 1900. 193. ]\n", "158 0 6217 avenue Christophe-Colomb [ -73.60562972 45.53639852 1900. 184. ]\n", "159 0 6217 avenue Christophe-Colomb [ -73.6090979 45.5335944 1900. 188. ]\n", "160 0 6217 avenue Christophe-Colomb [ -73.61406082 45.53407246 1900. 211. ]\n", "161 0 6217 avenue Christophe-Colomb [ -73.60766361 45.53710184 1900. 206. ]\n", "162 0 6217 avenue Christophe-Colomb [ -73.59832792 45.53287253 1900. 197. ]\n", "163 0 6217 avenue Christophe-Colomb [ -73.60382404 45.53441771 1900. 377. ]\n", "164 0 6217 avenue Christophe-Colomb [ -73.60391001 45.53445626 1900. 233. ]\n", "165 0 6217 avenue Christophe-Colomb [ -73.60203837 45.53478222 1900. 209. ]\n", "166 0 6217 avenue Christophe-Colomb [ -73.60813011 45.53638558 1900. 199. ]\n", "167 0 6217 avenue Christophe-Colomb [ -73.6090979 45.5335944 1900. 185. ]\n", "168 0 6217 avenue Christophe-Colomb [ -73.60315139 45.53528656 1900. 279. ]\n", "169 0 6217 avenue Christophe-Colomb [ -73.59525483 45.53332641 1900. 170. ]\n", "170 0 6217 avenue Christophe-Colomb [ -73.60970144 45.53824065 1900. 168. ]\n", "171 0 6217 avenue Christophe-Colomb [ -73.60259192 45.53386521 1900. 179. ]\n", "172 0 6217 avenue Christophe-Colomb [ -73.60001814 45.5336511 1900. 186. ]\n", "173 0 6217 avenue Christophe-Colomb [ -73.61014641 45.53844318 1900. 168. ]\n", "174 0 6217 avenue Christophe-Colomb [ -73.5750277 45.55018856 1900. 211. ]\n" ] }, { "name": "stdout", "output_type": "stream", "text": [ "175 0 6217 avenue Christophe-Colomb [ -73.60551231 45.53539783 1900. 198. ]\n", "176 0 6217 avenue Christophe-Colomb [ -73.61150252 45.5388395 1900. 156. ]\n", "177 0 6217 avenue Christophe-Colomb [ -73.6087519 45.53334613 1900. 169. ]\n", "178 0 6217 avenue Christophe-Colomb [ -73.59914778 45.53251196 1900. 203. ]\n", "179 0 6217 avenue Christophe-Colomb [ -73.6171224 45.5369169 1900. 354. ]\n", "180 0 6217 avenue Christophe-Colomb [ -73.61165719 45.53820117 1900. 177. ]\n", "181 0 6217 avenue Christophe-Colomb [ -73.60299608 45.53521618 1900. 199. ]\n", "182 0 6217 avenue Christophe-Colomb [ -73.60917233 45.53232235 1900. 209. ]\n", "183 0 6217 avenue Christophe-Colomb [ -73.60305038 45.53407079 1900. 283. ]\n", "184 0 6217 avenue Christophe-Colomb [ -73.59856195 45.53298033 1900. 188. ]\n", "185 0 6217 avenue Christophe-Colomb [ -73.60121114 45.53623808 1900. 143. ]\n", "186 0 6217 avenue Christophe-Colomb [ -73.60669963 45.53915175 1900. 205. ]\n", "187 0 6217 avenue Christophe-Colomb [ -73.59836934 45.5331036 1900. 321. ]\n", "188 0 6217 avenue Christophe-Colomb [ -73.611532 45.54005456 1900. 340. ]\n", "189 0 6217 avenue Christophe-Colomb [ -73.59980902 45.53281481 1900. 175. ]\n", "190 0 6217 avenue Christophe-Colomb [ -73.5940678 45.5321879 1900. 160. ]\n", "191 0 6217 avenue Christophe-Colomb [ -73.6171224 45.5369169 1900. nan]\n", "192 0 6217 avenue Christophe-Colomb [ -73.60541671 45.53609302 1900. 219. ]\n", "193 0 6217 avenue Christophe-Colomb [ -73.6090979 45.5335944 1900. 165. ]\n", "194 0 6217 avenue Christophe-Colomb [ -73.6117353 45.53916057 1900. 201. ]\n", "195 0 6217 avenue Christophe-Colomb [ -73.61710037 45.53067894 1900. 161. ]\n", "196 0 6217 avenue Christophe-Colomb [ -73.60721463 45.54152006 1900. 183. ]\n", "197 0 6217 avenue Christophe-Colomb [ -73.57495715 45.54777255 1900. 334. ]\n", "198 0 6217 avenue Christophe-Colomb [ -73.60869315 45.53685372 1900. nan]\n", "199 0 6217 avenue Christophe-Colomb [ -73.60213345 45.53365962 1900. 179. ]\n", "200 0 6217 avenue Christophe-Colomb [ -73.60207614 45.53363393 1900. 206. ]\n", "201 0 6217 avenue Christophe-Colomb [ -73.6131843 45.5268847 1900. nan]\n", "202 0 6217 avenue Christophe-Colomb [ -73.61281083 45.53942374 1900. 196. ]\n", "203 0 6217 avenue Christophe-Colomb [ -73.60243078 45.53594176 1900. 337. ]\n", "204 0 6217 avenue Christophe-Colomb [ -73.59906568 45.53506357 1900. nan]\n", "205 0 6217 avenue Christophe-Colomb [ -73.61019862 45.53825564 1900. 197. ]\n", "206 0 6217 avenue Christophe-Colomb [ -73.60297042 45.53499358 1900. 218. ]\n", "207 0 6217 avenue Christophe-Colomb [ -73.60268645 45.53411795 1900. 201. ]\n", "208 0 6217 avenue Christophe-Colomb [ -73.60090793 45.53405902 1900. 193. ]\n", "209 0 6217 avenue Christophe-Colomb [ -73.61642088 45.53286239 1900. 116. ]\n", "210 0 6217 avenue Christophe-Colomb [ -73.60901314 45.53203888 1900. 167. ]\n", "211 0 6217 avenue Christophe-Colomb [ -73.6000276 45.53568756 1900. 105. ]\n", "212 0 6217 avenue Christophe-Colomb [ -73.60586516 45.53534789 1900. 271. ]\n", "213 0 6217 avenue Christophe-Colomb [ -73.60496932 45.53610291 1900. 355. ]\n", "214 0 6217 avenue Christophe-Colomb [ -73.61322839 45.53463907 1900. 188. ]\n", "215 0 6217 avenue Christophe-Colomb [ -73.6059849 45.5322846 1900. 609. ]\n", "216 0 6217 avenue Christophe-Colomb [ -73.60729624 45.53289389 1900. 135. ]\n", "217 0 6217 avenue Christophe-Colomb [ -73.60682828 45.53920866 1900. 151. ]\n", "218 0 6217 avenue Christophe-Colomb [ -73.6096126 45.53706162 1900. 99. ]\n", "219 0 6217 avenue Christophe-Colomb [ -73.61139078 45.53455186 1900. 211. ]\n", "220 0 6217 avenue Christophe-Colomb [ -73.60260782 45.53504025 1900. 209. ]\n", "221 0 6217 avenue Christophe-Colomb [ -73.60221941 45.53369817 1900. 212. ]\n", "222 0 6217 avenue Christophe-Colomb [ -73.60116082 45.53536662 1900. 156. ]\n", "223 0 6217 avenue Christophe-Colomb [ -73.60098625 45.53409451 1900. 193. ]\n", "224 0 6217 avenue Christophe-Colomb [ -73.60021866 45.53395547 1900. 193. ]\n", "225 0 6217 avenue Christophe-Colomb [ -73.6107078 45.5293948 1900. 172. ]\n", "226 0 6217 avenue Christophe-Colomb [ -73.6092242 45.53709589 1900. 187. ]\n", "227 0 6217 avenue Christophe-Colomb [ -73.60555317 45.53615411 1900. 323. ]\n", "228 0 6217 avenue Christophe-Colomb [ -73.60498309 45.5322477 1900. 200. ]\n", "229 0 6217 avenue Christophe-Colomb [ -73.5755152 45.54731662 1900. 396. ]\n", "230 0 6217 avenue Christophe-Colomb [ -73.60691441 45.53053648 1900. 130. ]\n", "231 0 6217 avenue Christophe-Colomb [ -73.6101735 45.5336801 1900. 319. ]\n", "232 0 6217 avenue Christophe-Colomb [ -73.61139792 45.53333579 1900. 176. ]\n", "233 0 6217 avenue Christophe-Colomb [ -73.6065745 45.53567311 1900. 236. ]\n", "234 0 6217 avenue Christophe-Colomb [ -73.59790384 45.53367571 1900. 195. ]\n", "235 0 6217 avenue Christophe-Colomb [ -73.59570408 45.53511223 1900. 237. ]\n", "236 0 6217 avenue Christophe-Colomb [ -73.6171224 45.5369169 1900. 178. ]\n", "237 0 6217 avenue Christophe-Colomb [ -73.59759183 45.53353368 1900. 210. ]\n", "238 0 6217 avenue Christophe-Colomb [ -73.6036459 45.53080896 1900. 187. ]\n", "239 0 6217 avenue Christophe-Colomb [ -73.60039036 45.53719523 1900. 253. ]\n", "240 0 6217 avenue Christophe-Colomb [ -73.60802947 45.53159187 1900. 175. ]\n", "241 0 6217 avenue Christophe-Colomb [ -73.6153447 45.5334419 1900. 457. ]\n", "242 0 6217 avenue Christophe-Colomb [ -73.60322904 45.53532174 1900. 239. ]\n", "243 0 6217 avenue Christophe-Colomb [ -73.60713715 45.53323243 1900. 136. ]\n", "244 0 6217 avenue Christophe-Colomb [ -73.61375955 45.53250237 1900. 266. ]\n", "245 0 6217 avenue Christophe-Colomb [ -73.60809974 45.5316238 1900. 158. ]\n", "246 0 6217 avenue Christophe-Colomb [ -73.61321783 45.53161766 1900. 155. ]\n", "247 0 6217 avenue Christophe-Colomb [ -73.60718711 45.53595398 1900. nan]\n", "248 0 6217 avenue Christophe-Colomb [ -73.619246 45.5457004 1900. 157. ]\n", "249 0 6217 avenue Christophe-Colomb [ -73.60820024 45.53372105 1900. nan]\n", "250 0 6217 avenue Christophe-Colomb [ -73.59906513 45.53247411 1900. 234. ]\n", "251 0 6217 avenue Christophe-Colomb [ -73.60454589 45.53000861 1900. 129. ]\n", "252 0 6217 avenue Christophe-Colomb [ -73.6171224 45.5369169 1900. 160. ]\n", "253 0 6217 avenue Christophe-Colomb [ -73.60077334 45.53325647 1900. nan]\n", "254 0 6217 avenue Christophe-Colomb [ -73.60946985 45.53224642 1900. 190. ]\n", "255 0 6217 avenue Christophe-Colomb [ -73.60551049 45.53518528 1900. 180. ]\n", "256 0 6217 avenue Christophe-Colomb [ -73.60806986 45.53749805 1900. 175. ]\n", "257 0 6217 avenue Christophe-Colomb [ -73.61119264 45.53303051 1900. 158. ]\n", "258 0 6217 avenue Christophe-Colomb [ -73.61201605 45.53090226 1900. 122. ]\n", "259 0 6217 avenue Christophe-Colomb [ -73.59823464 45.53188211 1900. 139. ]\n" ] } ], "source": [ "geolocator = Nominatim()\n", "geolocator = Nominatim(format_string=\"%s, Montreal QC\")\n", "array = np.empty([len(df),4])\n", "name_list = []\n", "j = 0;\n", "for i in range (0,len(df)):\n", " loc_str = str(df.iloc[i]['CIVIQUE_DEBUT']) + ' ' + str(df.iloc[i]['NOM_RUE'])\n", " loc_str = loc_str[:loc_str.find('(')]\n", " \n", "# # A few cases of exceptional spelling that need to be addressed\n", "# if 'croissant' in loc_str:\n", "# loc_str = loc_str.replace('croissant', 'cres')\n", "# if \" l' \" in loc_str:\n", "# loc_str = loc_str.replace(\"l' \", \"l'\")\n", " \n", " try:\n", "# print(loc_str)\n", " time.sleep(1)\n", " location = geolocator.geocode(loc_str, timeout=10)\n", " except GeocoderTimedOut as e:\n", " print(\"Error: geocode failed on input %s \"%(loc_str))\n", " if location is not None:\n", " array[j,0] = location.longitude\n", " array[j,1] = location.latitude\n", " array[j,2] = df.iloc[i]['ANNEE_CONSTRUCTION']\n", " array[j,3] = df.iloc[i]['SUPERFICIE_BATIMENT']\n", " name_list.append(loc_str)\n", " print(str(i),str(j),name_list[j], array[j,:])\n", "# else: \n", "# print(\"Skipping: i= \" + str(i) + \", address: \" + loc_str)\n", "# j = j - 1 # Stop us from advancing j if an address is skipped.\n", "# j = j + 1" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "Python 3", "language": "python", "name": "python3" }, "varInspector": { "cols": { "lenName": 16, "lenType": 16, "lenVar": 40 }, "kernels_config": { "python": { "delete_cmd_postfix": "", "delete_cmd_prefix": "del ", "library": "var_list.py", "varRefreshCmd": "print(var_dic_list())" }, "r": { "delete_cmd_postfix": ") ", "delete_cmd_prefix": "rm(", "library": "var_list.r", "varRefreshCmd": "cat(var_dic_list()) " } }, "types_to_exclude": [ "module", "function", "builtin_function_or_method", "instance", "_Feature" ], "window_display": false } }, "nbformat": 4, "nbformat_minor": 2 }