Barangay Names.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import string\n",
    "import requests\n",
    "import shapefile as shp\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Importing & Cleaning Data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Description: Reads in the data and stores it in the dataframe \"data\", then removes all punctuations and turns stores the cleaned data into the dataframe \"fix\"\n",
    "\n",
    "To Do: Turn the list of addresses you receive into a csv file and update the name in the read_csv function"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "data = pd.read_csv(\"Sample Input.csv\") #Here!"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "fix = {'stripaddress': data['stripaddress'], 'edit': data['stripaddress']}  \n",
    "fix = pd.DataFrame(fix, columns = ['stripaddress', 'edit']) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "fix['edit'] = [s.translate(string.punctuation) for s in fix['edit']]\n",
    "fix['edit'] = [s.replace(',', ' ').replace('.',' ').replace('#',' ') for s in fix['edit']]\n",
    "fix['lst'] = [s.split() for s in fix['edit']]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Columns for Lat & Long (Run Only Once!)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Description: Creates latitute, longitude, and address columns that will be filled in later from the Google Maps API"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "fix['lat']=np.repeat(None, len(fix['edit']))\n",
    "fix['lng']=np.repeat(None, len(fix['edit']))\n",
    "fix['add']=np.repeat(None, len(fix['edit']))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Importing Shapefiles"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Description: Uploads shapefiles to get coordinates data for each baranggay, and creates a dataframe called \"df\"\n",
    "\n",
    "To Do: Change the address of the baranggay shapefile from '/Users/lorenzoflores/Desktop/LOOKUP-NCR-2ndDistrict-QuezonCity/Barangays.shp' to wherever it is stored on your computer"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "sns.set(style=\"whitegrid\", palette=\"pastel\", color_codes=True)\n",
    "sns.mpl.rc(\"figure\", figsize=(10,6))\n",
    "%matplotlib inline\n",
    "\n",
    "shp_path = '/Users/lorenzoflores/Desktop/LOOKUP-NCR-2ndDistrict-QuezonCity/Barangays.shp' #Here!\n",
    "sf = shp.Reader(shp_path, encoding='latin-1')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "def read_shapefile(sf):\n",
    "    \"\"\"\n",
    "    Read a shapefile into a Pandas dataframe with a 'coords' \n",
    "    column holding the geometry information. This uses the pyshp\n",
    "    package\n",
    "    \"\"\"\n",
    "    fields = [x[0] for x in sf.fields][1:]\n",
    "    records = sf.records()\n",
    "    shps = [s.points for s in sf.shapes()]\n",
    "    df = pd.DataFrame(columns=fields, data=records)\n",
    "    df = df.assign(coords=shps)\n",
    "    return df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Subsetting Shapefiles for Quezon City "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Description: Removes all other baranggay shapefiles from the df dataframe except for the area you choose, in order to reduce run time\n",
    "\n",
    "To Do: Change Metropolitan Manila to whichever province you're working on, run the code below to check the available provinces"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'Metropolitan Manila'}"
      ]
     },
     "execution_count": 73,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Run me to check available provinces!\n",
    "set(df['NAME_1'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = read_shapefile(sf)\n",
    "df = df[df['NAME_1']=='Metropolitan Manila'] #Here!\n",
    "df = df.reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Geotagging from Google Maps (Run Only Once!)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Description: Uses Google Maps to identify coordinates for each address\n",
    "\n",
    "To Do: Input your own Google API key for the geotagging API as it says below"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Now on: 0\n",
      "Now on: 100\n",
      "Now on: 200\n",
      "Error on: 296\n",
      "1141 SANTA RC\n",
      "Now on: 300\n",
      "Now on: 400\n",
      "Now on: 500\n",
      "Now on: 600\n",
      "Error on: 615\n",
      "142 TARLAC ST COMMONWEALTH QUEZON CITY\n",
      "Error on: 659\n",
      "15 BLK 52 PANTOMINA MAYOR ST LAGRO SUBD NOVALICHES QUEZON CITY\n",
      "Now on: 700\n",
      "Error on: 777\n",
      "16-C BLK A STO  NIÑO ST   QUEZON CITY CPO  QUEZON CITY 1100\n",
      "Now on: 800\n",
      "Error on: 867\n",
      "189 EVERLASTING ST PINGKIAN 3 ZN 1 PASONG TAMO QUEZON CITY\n",
      "Now on: 900\n",
      "Error on: 995\n",
      "207 SECOND NORTH 2906 KING SOLOMON ST AREA C\n",
      "Error on: 996\n",
      "207 UNIT 5 ADARNA STREET PUROK 6 COMMONWEALTH QUEZON CITY\n",
      "Now on: 1000\n",
      "Now on: 1100\n",
      "Error on: 1187\n",
      "27 NUPAX CMPD BAGBAG NOVALICHES QUEZON CITY\n",
      "Now on: 1200\n",
      "Now on: 1300\n",
      "Error on: 1358\n",
      "35-D PROJECT 4 ESCOPA I QUEZON CITY NCR\n",
      "Now on: 1400\n",
      "Now on: 1500\n",
      "Now on: 1600\n",
      "Now on: 1700\n",
      "Now on: 1800\n",
      "Now on: 1900\n",
      "Now on: 2000\n",
      "Now on: 2100\n",
      "Now on: 2200\n",
      "Now on: 2300\n",
      "Now on: 2400\n",
      "Error on: 2454\n",
      "B7-L14/16 P1 SILVERCREEK SUBD \n",
      "Error on: 2455\n",
      "B7-L22 PORTICO-I SUBD \n",
      "Now on: 2500\n",
      "Now on: 2600\n",
      "Now on: 2700\n",
      "Error on: 2700\n",
      "BLK 2 LOT 15 KALIGTASAN EXT  HOLY SPIRIT  HOLY SPIRIT  QUEZON CITY   NATIONA CAPITAL REGION\n",
      "Error on: 2718\n",
      "BLK 2 LT 3 TITUS VILLAS TITUS ST WEST FAIRVIEW QUEZON CITY\n",
      "Error on: 2749\n",
      "BLK 2A LOT 33 PALMERA HOMES SUBD NOVALICHES EAST QUEZON CITY\n",
      "Error on: 2792\n",
      "BLK 31 LOT 55 SALUBONG ST LAGRO SUBD NOVALICHES PROPER QUEZON CITY\n",
      "Now on: 2800\n",
      "Error on: 2833\n",
      "BLK 46 LOT 18 TATLONG HARI ST LAGRO NOVALICHES PROPER QUEZON CITY\n",
      "Now on: 2900\n",
      "Error on: 2965\n",
      "BLOCK 28 LOT 2 DIEGO SILANG ST NCE 1 BATASAN HILLS QUEZON CITY\n",
      "Now on: 3000\n",
      "Now on: 3100\n",
      "Now on: 3200\n",
      "Now on: 3300\n",
      "Now on: 3400\n",
      "Now on: 3500\n",
      "Now on: 3600\n",
      "Error on: 3667\n",
      "G-45 ABBEY RD BAGBAG NOVALICHES QUEZON CITY\n",
      "Now on: 3700\n",
      "Now on: 3800\n",
      "Now on: 3900\n",
      "Error on: 3981\n",
      "JOSE ABAD SANTOS ST STA LUCIA NOVALICHES NOVALICHES PROPER QUEZON CITY\n",
      "Now on: 4000\n",
      "Now on: 4100\n",
      "Now on: 4200\n",
      "Now on: 4300\n",
      "Error on: 4397\n",
      "LOT 25 BLK 2 SANTAN ST MALIGAYA NOVALICHES PROPER QUEZON CITY\n",
      "Now on: 4400\n",
      "Now on: 4500\n",
      "Now on: 4600\n",
      "Now on: 4700\n",
      "Now on: 4800\n",
      "Error on: 4890\n",
      "Ñ84-C ROAD 2 PAG-ASA QUEZON CITY\n",
      "Now on: 4900\n",
      "Error on: 4939\n",
      "NIÑO KID  CITY\n",
      "Error on: 4940\n",
      "NIÑO  KID  CITY\n",
      "Error on: 4981\n",
      "OAK EXT WEST FAIRVIEW QUEZON CITY\n",
      "Now on: 5000\n",
      "Now on: 5100\n",
      "Error on: 5185\n",
      "PINK CONDO TIERRA BELLA TANDANG SORA Q C   N/A  N/A  N/A\n",
      "Now on: 5200\n",
      "Now on: 5300\n",
      "Now on: 5400\n",
      "Now on: 5500\n",
      "Now on: 5600\n",
      "Error on: 5644\n",
      "SITIO PALANAS VASRA QUEZON CITY\n",
      "Error on: 5645\n",
      "SITIO PALANAS VASRA QUEZON CITY\n",
      "Now on: 5700\n",
      "Error on: 5741\n",
      "STO NIÑO ST B BAYAN QUEZON CITY\n",
      "Now on: 5800\n",
      "Now on: 5900\n",
      "Error on: 5968\n",
      "UNIT 4 ILANG ILANG ILANG ST \n",
      "Now on: 6000\n",
      "Now on: 6100\n"
     ]
    }
   ],
   "source": [
    "for i in range(len(fix['edit'])):\n",
    "    if i%100==0:\n",
    "        print(\"Now on: \"+str(i))\n",
    "    try:\n",
    "        x = fix['edit'][i]\n",
    "        response = requests.get('https://maps.googleapis.com/maps/api/geocode/json?address='+\n",
    "                                x+',Philippines'+'&key='+\"INSERT YOUR KEY HERE IN THE QUOTATION MARKS\")\n",
    "        resp_json_payload = response.json()\n",
    "        fix['add'][i] = resp_json_payload['results'][0]['formatted_address']\n",
    "        fix['lat'][i] = resp_json_payload['results'][0]['geometry']['location']['lat']\n",
    "        fix['lng'][i] = resp_json_payload['results'][0]['geometry']['location']['lng']\n",
    "    except:\n",
    "        print(\"Error on: \"+str(i))\n",
    "        print(fix['edit'][i])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Baranggay + Address Coordinates Matching"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Description: Identifies the baranggay to which the coordinates of the address belongs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "from shapely.geometry import Point\n",
    "from shapely.geometry.polygon import Polygon"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Turn each baranggay in df into a polygon"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/lorenzoflores/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  This is separate from the ipykernel package so we can avoid doing imports until\n"
     ]
    }
   ],
   "source": [
    "df['poly']=np.repeat(None, len(df['NAME_1']))\n",
    "for i in range(len(df['poly'])):   \n",
    "    df['poly'][i] = Polygon(df.iloc[i,]['coords'])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Turn each address in fix into a point"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [],
   "source": [
    "fix['pt']=np.repeat(None, len(fix['lat']))\n",
    "for i in range(len(fix['lat'])):\n",
    "    if fix['add'][i] is not None:\n",
    "        fix['pt'][i] = Point(fix['lng'][i],fix['lat'][i])\n",
    "    else:\n",
    "        pass"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Create a baranggay name column"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "fix['bgy']=np.repeat(None, len(fix['lat']))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "For each point, check if it belongs to a baranggay"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Now on: 0\n",
      "Check: 4\n",
      "001 LEYTE GROUP 7 PAYATAS QUEZON CITY\n",
      "Check: 11\n",
      "004 ZAMBOANGA ST   BAI COMPOUND  BRGY  VASRA  QUEZON CITY  N/A\n",
      "Check: 93\n",
      "079 GINUNTUANG LANDAS FOREST HILL SANTA MONICA QUEZON CITY\n",
      "Now on: 100\n",
      "Now on: 200\n",
      "Check: 215\n",
      "1064 A CULLEJON LIWANAG BGY 215 TONDO MANILA\n",
      "Check: 218\n",
      "107 SAMPAGUITA EXT PAYATAS QUEZON CITY\n",
      "Check: 235\n",
      "109 LIVERPOOL ST CLASSICA II VISTA REAL QUEZON CITY\n",
      "Check: 287\n",
      "114 CHICO ST QUIRINO 2B PROJEC 2 ALICIA QUEZON CITY\n",
      "Check: 296\n",
      "1141 SANTA RC\n",
      "Now on: 300\n",
      "Check: 307\n",
      "116 BAGUIO CMPD ROAD 20 PROJECT 8 QUEZON CITY\n",
      "Check: 391\n",
      "120 NEW YORK STREET  BRGY  CUBAO  QUEZON CITY  N/A  N/A  N/A\n",
      "Now on: 400\n",
      "Now on: 500\n",
      "Check: 547\n",
      "137 SAINT HERMINE ST  BROOKSIDE BAGONG SILANGAN QUEZON CITY NCR\n",
      "Check: 584\n",
      "13K BLK A STO NIÑO ST SAN ANTONIO SFDM SAN ANTONIO QUEZON CITY\n",
      "Now on: 600\n",
      "Check: 615\n",
      "142 TARLAC ST COMMONWEALTH QUEZON CITY\n",
      "Check: 634\n",
      "146 CAMIA ST SAN ROQUE 2 PAGASA QUEZON CITY\n",
      "Check: 659\n",
      "15 BLK 52 PANTOMINA MAYOR ST LAGRO SUBD NOVALICHES QUEZON CITY\n",
      "Now on: 700\n",
      "Check: 758\n",
      "165 BATINO ST  DUYAN-DUYAN QUEZON CITY NCR\n",
      "Check: 777\n",
      "16-C BLK A STO  NIÑO ST   QUEZON CITY CPO  QUEZON CITY 1100\n",
      "Check: 785\n",
      "17 BLK 43 CELERINA ST PALMERA SPRING II NOVALICHES PROPER QUEZON CITY\n",
      "Now on: 800\n",
      "Check: 867\n",
      "189 EVERLASTING ST PINGKIAN 3 ZN 1 PASONG TAMO QUEZON CITY\n",
      "Check: 869\n",
      "189 TEXAS ST UPPER COMPD PASONG TAMO QUEZON CITY\n",
      "Check: 876\n",
      "18B OZAMIS ST   STA CRUZ  QUEZON CITY\n",
      "Check: 878\n",
      "18C SNT JOSEPH ST MILTON HILLS SUBD NEW ERA (CONSTITUTION HILLS) QUEZON CITY\n",
      "Check: 879\n",
      "18C SNT JOSEPH ST MILTON HILLS SUBD NEW ERA (CONSTITUTION HILLS) QUEZON CITY\n",
      "Now on: 900\n",
      "Check: 906\n",
      "192 FATIMA ST POOK DAGOHOY UP CAMPUS QUEZON CITY\n",
      "Check: 938\n",
      "19C LAGUNA ST RAMON MAGSAYSAY QUEZON CITY\n",
      "Check: 939\n",
      "19C NORTH DIVERSION ROAD UNANG SIGAW BALINTAWAK QUEZON CITY\n",
      "Check: 971\n",
      "201 NEW ORLEANS ST  UPPER BERNARDO PASONG TAMO QUEZON CITY NCR\n",
      "Check: 975\n",
      "202 2ND FLOOR KY BLDG I BANAHAW ST KAUNLARAN QUEZON CITY\n",
      "Check: 977\n",
      "203 BLK 6 DAMAYANG LAGI QUEZON CITY NCR\n",
      "Check: 979\n",
      "203 K CONSEPCION ST SANTOLAN QUEZON CITY\n",
      "Check: 980\n",
      "203 K CONSEPCION ST SANTOLAN QUEZON CITY\n",
      "Check: 995\n",
      "207 SECOND NORTH 2906 KING SOLOMON ST AREA C\n",
      "Check: 996\n",
      "207 UNIT 5 ADARNA STREET PUROK 6 COMMONWEALTH QUEZON CITY\n",
      "Now on: 1000\n",
      "Check: 1042\n",
      "216A WOODRIDGE BLDG SOFIA BELLEVUE MATANDANG BALARA QUEZON CITY\n",
      "Check: 1057\n",
      "22 BLK 2 BRCELONA ST PH 2 VILLA OLYMPIA GULOD QUEZON CITY\n",
      "Now on: 1100\n",
      "Check: 1187\n",
      "27 NUPAX CMPD BAGBAG NOVALICHES QUEZON CITY\n",
      "Check: 1194\n",
      "275 J P RIZAL ST BAGONG SILANGAN QUEZON CITY\n",
      "Now on: 1200\n",
      "Check: 1225\n",
      "293 105 ST SOLDIERS VILLAGE SANTA LUCIA QUEZON CITY\n",
      "Check: 1254\n",
      "3 CADMIUM ST FILINVEST 2 QUEZON CITY\n",
      "Now on: 1300\n",
      "Check: 1358\n",
      "35-D PROJECT 4 ESCOPA I QUEZON CITY NCR\n",
      "Check: 1375\n",
      "373 QUIRINO HI WAY QUEZON CITY\n",
      "Now on: 1400\n",
      "Check: 1410\n",
      "3RD FLOOR 61 SAN ILDEFONSO DRIVE TORNES VILLAGE NAGKAISANG NAYON QUEZON CITY\n",
      "Check: 1457\n",
      "426 INOCENCIO BGY 93 TONDO NCR  CITY OF MANILA\n",
      "Check: 1462\n",
      "42-E KAUNLARAN ST  KAINGIN BUKID APOLONIO SAMSON QUEZON CITY NCR\n",
      "Check: 1487\n",
      "44-A STA  BARBARA ST  BRGY  GULOD NOVA QC  GULOD  NOVALIXHES QUEZON CITY  N/A\n",
      "Now on: 1500\n",
      "Check: 1531\n",
      "4917 13TH ST  STO  NIÑO PQUE   STO NINO  PQUE CITY\n",
      "Check: 1534\n",
      "4985 14TH ST  A  STO  NIÑO PQUE   STO NINO  PQUE CITY\n",
      "Check: 1568\n",
      "504 OFFICERS ROW CAMACHO ST AREVALO AVE CAMP AGUINALDO QUEZON CITY\n",
      "Now on: 1600\n",
      "Check: 1626\n",
      "5-A AREVALO COMPD  GRANTS ST   PROJ  8  SANGANDAAN  QUEZON CITY  N/A\n",
      "Check: 1650\n",
      "607 GEN MALVAR BAGONG SILANGAN QUEZON CITY\n",
      "Check: 1669\n",
      "63 L-1 STO  NINO 1 CSJDM  BULACAN\n",
      "Now on: 1700\n",
      "Check: 1742\n",
      "71 L 5 AB YUAN ST  PHASE 8  NORTH FAIRVIEW  QUEZON CITY  CITY OF MANILA \n",
      "Now on: 1800\n",
      "Now on: 1900\n",
      "Check: 1908\n",
      "9-J L PASCO ST LIBIS QUEZON CITY  N/A  N/A  N/A\n",
      "Check: 1963\n",
      "A MAARALIN STREET EL RIO VISTA  CENTRAL QUEZON CITY\n",
      "Check: 1997\n",
      "A SAN ANTONIO SUBD  DAMONG MALIIT NOVA QC  DAMONG MALIIT  NOVALICHES  QUEZON CITY  N/A\n",
      "Now on: 2000\n",
      "Check: 2009\n",
      "A SOUTH GATE BALARA PANSOL QUEZON CITY\n",
      "Now on: 2100\n",
      "Check: 2100\n",
      "ALLADO ST SAN ANTONIO SUBD DAMONG MALIIT NAGKAISANG NAYON NOVALICHES QUEZON CITY\n",
      "Check: 2176\n",
      "AREA 06 SITIO CABUYAO SAUYO QC\n",
      "Check: 2185\n",
      "AREA 4 BAYANIHAN ST   TALANAY BATASAN HILLS QUEZON CITY NCR\n",
      "Now on: 2200\n",
      "Check: 2222\n",
      "ASTON ST NORTH FAIRVIEW QUEZON CITY\n",
      "Now on: 2300\n",
      "Check: 2309\n",
      "B OZAMIS ST  SANTA CRUZ QUEZON CITY NCR\n",
      "Check: 2313\n",
      "B PAGASA QUEZON CITY\n",
      "Now on: 2400\n",
      "Check: 2441\n",
      "B58 L9 PH12 RIVERSIDE CALOOCAN CITY THIRD DIST \n",
      "Check: 2442\n",
      "B59 BRIMLEY ST FAIRVILLE HOMES NORTH FAIRVIEW QUEZON CITY\n",
      "Check: 2445\n",
      "B59 L41 GRANDRIVERSIDE  PASCAM1  GENTRIAS CAVITE\n",
      "Check: 2451\n",
      "B70 YUAN ST PH8 NORTH FAIRVIEW QUEZON CITY\n",
      "Check: 2454\n",
      "B7-L14/16 P1 SILVERCREEK SUBD \n",
      "Check: 2455\n",
      "B7-L22 PORTICO-I SUBD \n",
      "Now on: 2500\n",
      "Check: 2515\n",
      "BATAAN RD GARCIA HTS LUZON AVE HOLY SPIRIT QUEZON CITY\n",
      "Check: 2525\n",
      "BATINO ST  ALLEY 20  AMIHAN  QUEZON CITY  N/A\n",
      "Check: 2554\n",
      "BGY STO NIÑO MULANAY QUEZON\n",
      "Now on: 2600\n",
      "Check: 2614\n",
      "BLK 1 L 15 GK ROQUE I PASONG TAMO QUEZON CITY\n",
      "Check: 2619\n",
      "BLK 1 LOT 2 QUEENSVILLE SUBD BAGUMBONG BGY 171 CALOOCAN CITY\n",
      "Check: 2635\n",
      "BLK 1 LOT 9 KASIYAHAN ST  BATASAN HILLS QUEZON CITY\n",
      "Check: 2667\n",
      "BLK 13 LOT 15 SOLDIERS HILLS III TALA QUEZON CITY\n",
      "Check: 2673\n",
      "BLK 14 LOT 36 SIEERA VISTA SUBD NOVA QUEZON CITY NCR\n",
      "Check: 2691\n",
      "BLK 1A GALLEY ST BATASAN HILLS QUEZON CITY\n",
      "Now on: 2700\n",
      "Check: 2700\n",
      "BLK 2 LOT 15 KALIGTASAN EXT  HOLY SPIRIT  HOLY SPIRIT  QUEZON CITY   NATIONA CAPITAL REGION\n",
      "Check: 2715\n",
      "BLK 2 LOT 9  TIERRA NOVA 2-C   BAGUMBONG   QUEZON CITY  N/A\n",
      "Check: 2718\n",
      "BLK 2 LT 3 TITUS VILLAS TITUS ST WEST FAIRVIEW QUEZON CITY\n",
      "Check: 2749\n",
      "BLK 2A LOT 33 PALMERA HOMES SUBD NOVALICHES EAST QUEZON CITY\n",
      "Check: 2792\n",
      "BLK 31 LOT 55 SALUBONG ST LAGRO SUBD NOVALICHES PROPER QUEZON CITY\n",
      "Now on: 2800\n",
      "Check: 2823\n",
      "BLK 4 LOT 10 LUKE ST NORTH OLYMPUS NOVALICHES QUEZON CITY\n",
      "Check: 2833\n",
      "BLK 46 LOT 18 TATLONG HARI ST LAGRO NOVALICHES PROPER QUEZON CITY\n",
      "Check: 2835\n",
      "BLK 48 LOT 35 PROJ 4 ESCOPA III QUEZON CITY NCR\n",
      "Check: 2876\n",
      "BLK 70 LOT 35A YUAN ST NORTH FAIRVIEW QUEZON CITY\n",
      "Now on: 2900\n",
      "Check: 2954\n",
      "BLK64 LOT1 GREATER LAGRO QUEZON CITY NCR\n",
      "Check: 2955\n",
      "BLK70 LT15-A YUAN ST PH 8 NORTH FAIRVIEW QUEZON CITY\n",
      "Check: 2965\n",
      "BLOCK 28 LOT 2 DIEGO SILANG ST NCE 1 BATASAN HILLS QUEZON CITY\n",
      "Check: 2967\n",
      "BLOCK 5 LOT 31 VILLA ESPANA 2 TATALON QUEZON CITY NCR\n",
      "Check: 2974\n",
      "BLVD   KIDAPAWAN CITY COT\n",
      "Check: 2982\n",
      "BOLANOS KALIRAYA STREET TATALON QUEZON CITY NCR\n",
      "Now on: 3000\n",
      "Check: 3000\n",
      "BRGY  PURY SAN ANTONIO QUEZON  BRGY  PURY SAN ANTONIO  QUEZON  N/A\n",
      "Check: 3076\n",
      "C T MASCARDO ST VILLA MARIA CLARA PROJ 4 QUEZON CITY\n",
      "Check: 3097\n",
      "CAIRO ST STA RITA VILL PROJ 8 QUEZON CITY\n",
      "Now on: 3100\n",
      "Check: 3121\n",
      "CAMP SECURITY AND ESCORT UNIT OFFICE KIANGAN HALL CAMP CRAME QUEZON CITY\n",
      "Check: 3195\n",
      "CITY PLANNING & DEVT OFFICE 10F QUEZON CITY HALL BLDG ELLIPTICAL RD DILIMAN QUEZON CITY\n",
      "Now on: 3200\n",
      "Check: 3208\n",
      "COL OZAMIS STREET HEROES HILL QUEZON CITY\n",
      "Check: 3224\n",
      "COMPOSTELA ST FILINVEST 2 BATASAN HILLS QUEZON CITY\n",
      "Check: 3226\n",
      "COMPOUND 4 DOOR 5 DOWN MAUBAN ST  MANKESA QOUEZON CITY\n",
      "Now on: 3300\n",
      "Check: 3311\n",
      "D&A VICENTE VILLAGE EXT  BAGONG SILANGAN QUEZON CITY NCR\n",
      "Check: 3348\n",
      "DAO ST 26 QUIRINO 3-A QUEZON CITY\n",
      "Check: 3391\n",
      "DIAMOND ST  NORTHVIEW 1  BATASAN HILLS  QUEZON CITY  N/A\n",
      "Now on: 3400\n",
      "Check: 3485\n",
      "E LLANO ST   SANGADAAN  QUEZON CITY  N/A  N/A  N/A\n",
      "Now on: 3500\n",
      "Check: 3524\n",
      "EMERALD ST NORTHVIEW I BATASAN HILLS QUEZON CITY\n",
      "Check: 3536\n",
      "ERVIE BEN NOBLEZA 1009 AURORA BLVD PROJECT 3 DUYAN-DUYAN QUEZON CITY\n",
      "Check: 3546\n",
      "EUCLID ST COR DALTON PASS ROAD VETERANS VILLAGE HOLY SPIRIT QUEZON CITY\n",
      "Now on: 3600\n",
      "Check: 3667\n",
      "G-45 ABBEY RD BAGBAG NOVALICHES QUEZON CITY\n",
      "Check: 3679\n",
      "GARDENIAN LANE BELLEVUE GRACE VILLAGE QUEZON CITY\n",
      "Check: 3681\n",
      "GARNET ST NORTHVIEW I BATASAN HILLS QUEZON CITY\n",
      "Check: 3682\n",
      "GARNET ST  NORTHVIEW  BATASAN HILLS   BATASAN HILLS  QUEZON CITY  N/A\n",
      "Check: 3683\n",
      "GARNET STREET NORTHVIEW 1  BATASAN HILLS  QUEZON CITY   NATIONA CAPITAL REGION\n",
      "Now on: 3700\n",
      "Check: 3772\n",
      "HARDAWAY CORNER OAKWOOD ST  SERRA MONTE  BATASAN HILLS  QUEZON CITY  N/A\n",
      "Now on: 3800\n",
      "Now on: 3900\n",
      "Check: 3906\n",
      "IPIL-IPIL ST  GROUP 1 PAYATAS QUEZON CITY NCR\n",
      "Check: 3966\n",
      "JALAN BANDAROLO NO 39B PANDANG WEST SUMATRA INDONESIA\n",
      "Check: 3967\n",
      "JAPAN\n",
      "Check: 3981\n",
      "JOSE ABAD SANTOS ST STA LUCIA NOVALICHES NOVALICHES PROPER QUEZON CITY\n",
      "Now on: 4000\n",
      "Check: 4074\n",
      "KALAYAAN ST  BATASAN HILLS QUEZON CITY NCR\n",
      "Now on: 4100\n",
      "Check: 4160\n",
      "KENTUCKY WEST BRGY SAN ANTONIO QUEZON CITY  N/A  N/A  N/A\n",
      "Check: 4162\n",
      "KIANGAN HALL CAMP CRAME QUEZON CITY\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Check: 4186\n",
      "L PASCO ST CORNER DONA YAYANG LIBIS QUEZON CITY\n",
      "Now on: 4200\n",
      "Check: 4213\n",
      "L16 BRIMLEY ST NORTH FAIRVIEW QUEZON CITY\n",
      "Check: 4227\n",
      "L22 KAKAMPI ST  BATASAN HILLS QUEZON CITY NCR\n",
      "Check: 4258\n",
      "L46 B1 SAN MIGUEL REALTY PHASE 1 BRGY FORTUNE MARIKINA\n",
      "Now on: 4300\n",
      "Check: 4367\n",
      "LLANO ST  TS AVE SANGANDAAN   QUEZON CITY\n",
      "Check: 4376\n",
      "LOT 1 BLK 3 UNION VILL BO BAGUMBONG NOVA  QUEZON CITY\n",
      "Check: 4397\n",
      "LOT 25 BLK 2 SANTAN ST MALIGAYA NOVALICHES PROPER QUEZON CITY\n",
      "Now on: 4400\n",
      "Check: 4429\n",
      "LOT 99 LIBIS QUEZON CITY NCR\n",
      "Check: 4430\n",
      "LOT VICENTE CPD BROOKSIDE BGY BAGONG SILANG QUEZON CITY\n",
      "Check: 4461\n",
      "LUCENA ST PROJECT 6 QUEZON CITY\n",
      "Check: 4482\n",
      "MA FATIMA ST DOÑA CARMEN SUBDIVISION CONGRESS PARK FAIRVIEW QUEZON CITY\n",
      "Now on: 4500\n",
      "Now on: 4600\n",
      "Check: 4692\n",
      "MATIN-AO PRK  PAG-ASA  SILWAY 8 POL SO COT   N/A  N/A  N/A\n",
      "Now on: 4700\n",
      "Check: 4731\n",
      "MENDOZA CMPD SAMONTE RD NAGKAISANG NAYON NOVALICHES PROPER QUEZON CITY\n",
      "Check: 4761\n",
      "MOLAVE ST NORTHVIEW II FILINVEST II QUEZON CITY\n",
      "Check: 4764\n",
      "MOLAVE ST  NORTHVIEW 2  BATASAN HILLS  QUEZON CITY   METRO MANILA\n",
      "Now on: 4800\n",
      "Check: 4831\n",
      "Ñ12 SAN JOSE VILLAGE BRGY  BAHAY TORO QC  N/A  N/A  N/A\n",
      "Check: 4890\n",
      "Ñ84-C ROAD 2 PAG-ASA QUEZON CITY\n",
      "Now on: 4900\n",
      "Check: 4903\n",
      "NAMAPA CMPD NORTH FAIRVIEW QUEZON CITY\n",
      "Check: 4905\n",
      "NANGKA ST NORTHVIEW 2 FILINVEST 2 BATASAN HILLS QUEZON CITY\n",
      "Check: 4906\n",
      "NANGKA STREET NORTHVIEW 2 FILINVEST 2 BATASAN HILLS QUEZON CITY\n",
      "Check: 4939\n",
      "NIÑO KID  CITY\n",
      "Check: 4940\n",
      "NIÑO  KID  CITY\n",
      "Check: 4981\n",
      "OAK EXT WEST FAIRVIEW QUEZON CITY\n",
      "Check: 4998\n",
      "OLYMPUS DRIVE SERRA MONTE FILINVEST 2  QUEZON CITY\n",
      "Check: 4999\n",
      "OLYMPUS DRIVE SERRA MONTE VILLAS  MONTE VILLAS  QUEZON CITY   NATIONA CAPITAL REGION\n",
      "Now on: 5000\n",
      "Check: 5000\n",
      "OMBEL ST  ROXAS DISTRICT  QUEZON CITY  N/A  N/A  N/A\n",
      "Check: 5085\n",
      "PALMA STREET FILINVEST II QUEZON CITY\n",
      "Now on: 5100\n",
      "Check: 5119\n",
      "PAWAI ST I DOÑA IMELDA QUEZON CITY\n",
      "Check: 5133\n",
      "PEARL ST NORTHVIEW I FILINVEST II BATASAN HILLS QUEZON CITY\n",
      "Check: 5185\n",
      "PINK CONDO TIERRA BELLA TANDANG SORA Q C   N/A  N/A  N/A\n",
      "Now on: 5200\n",
      "Check: 5238\n",
      "PRK 3  BALIGANG  CAMALIG ALBAY  QUEZON CITY   NATIONA CAPITAL REGION\n",
      "Check: 5273\n",
      "PUROK 9A COUNTRY HILLS LUINAB  ILIGAN CITY\n",
      "Now on: 5300\n",
      "Check: 5339\n",
      "REGINA VIL PHILAND DRIVE TANDANG SORA QUEZON CITY\n",
      "Check: 5345\n",
      "RIVERSIDE 1 DEL NACIA SAUYO QUEZON CITY\n",
      "Check: 5347\n",
      "RIVERSIDE SUBD  BALINTAWAK  N/A  N/A  N/A\n",
      "Now on: 5400\n",
      "Now on: 5500\n",
      "Now on: 5600\n",
      "Check: 5631\n",
      "SITIO GULOD KALAYAAN B BATASAN HILLS QUEZON CITY\n",
      "Check: 5644\n",
      "SITIO PALANAS VASRA QUEZON CITY\n",
      "Check: 5645\n",
      "SITIO PALANAS VASRA QUEZON CITY\n",
      "Check: 5672\n",
      "SOUTH GATE 78-A PANSOL QUEZON CITY NCR\n",
      "Now on: 5700\n",
      "Check: 5706\n",
      "ST  LOUIS COMP  6  BAESA  QUEZON CITY  N/A  N/A  N/A\n",
      "Check: 5715\n",
      "STA CLARA SAINT JAMES SUB NOVALICHES NAGKAISANG NAYON QUEZON CITY\n",
      "Check: 5740\n",
      "STO NIÑO MULANAY QUEZON\n",
      "Check: 5741\n",
      "STO NIÑO ST B BAYAN QUEZON CITY\n",
      "Check: 5753\n",
      "STO TOMAS LIBIS BAGUMBAYAN QUEZON CITY\n",
      "Now on: 5800\n",
      "Check: 5875\n",
      "TURQUOISE ST GEMSVILLE SUBD LAHUG (POB ) CEBU CITY CEBU\n",
      "Now on: 5900\n",
      "Check: 5902\n",
      "UNIT 1 4TH FLR SOLEDAD BLDG 94 BANAWE ST QUEZON CITY\n",
      "Check: 5911\n",
      "UNIT 10A BLDG 3 BLK 3 GOLDMINE INT NOVALICHES NAGKAISANG NAYON QUEZON CITY\n",
      "Check: 5915\n",
      "UNIT 114 APARTELLE BLDG QUIRINO HI WAY PASONG PUTIK QUEZON CITY\n",
      "Check: 5931\n",
      "UNIT 2 MARCELESTER CTR KATIPUNAN AVE COR WEST BERKELEY ST CALIFORNIA VILLAGE SN BARTOLOME NOVALICHES PROPER QUEZON CITY\n",
      "Check: 5937\n",
      "UNIT 22-20 NEOVISTA HOMES BAGUMBONG NOVALICHES PROPER QUEZON CITY\n",
      "Check: 5963\n",
      "UNIT 3D APT VERLAN SANTIAGO ST   PUTOL VISTA VERDE\n",
      "Check: 5967\n",
      "UNIT 4 DELA PAZ APARTMENT RIVERA AVENUE RIVERA VILLAGE JP LAUREL DAVAO CITY\n",
      "Check: 5968\n",
      "UNIT 4 ILANG ILANG ILANG ST \n",
      "Now on: 6000\n",
      "Check: 6021\n",
      "UNIT A202A EC PUEBLO 1 44 KING CHRISTIAN KINGSPOINT NOVALICHES BAGBAG QUEZON CITY\n",
      "Check: 6037\n",
      "UNIT H MELODY TOWNHOMES  LA GUARDIA EXT   LAHUG  CEBU CITY  CEBU PROV \n",
      "Now on: 6100\n",
      "Check: 6103\n",
      "VISAYAS EXTN PINGKIAN 3 ZONE 3 PASONG TAMO QUEZON CITY\n",
      "Check: 6106\n",
      "VISTA HERMOSA   SAN MATEO RIZAL  SAN MATEO RIZAL  QUEZON CITY   NATIONA CAPITAL REGION\n",
      "Check: 6153\n",
      "YANEZA DRIVE SERRA MONTE VILLAS FILINVEST 2 BATASAN HILLS QUEZON CITY\n",
      "Check: 6164\n",
      "ZARAGOSA ST   BRGY  DOÑA IMELDA  QUEZON CITY CPO  QUEZON CITY\n",
      "Check: 6167\n",
      "ZEUS DRIVE SERRA MONTEVILLAS  BRGY  BATASAN HILLS  QUEZON CITY   METRO MANILA\n"
     ]
    }
   ],
   "source": [
    "for i in range(len(fix['edit'])):\n",
    "    if i%100==0:\n",
    "        print(\"Now on: \"+str(i))\n",
    "    if fix['add'][i] is not None:\n",
    "        for j in range(len(df['poly'])):\n",
    "            if fix['pt'][i].within(df['poly'][j]):\n",
    "                fix['bgy'][i] = df['NAME_3'][j]\n",
    "                break\n",
    "    if fix['bgy'][i] is None:\n",
    "        print(\"Check: \"+str(i))\n",
    "        print(fix['edit'][i])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Check the Results – AKA Manual Encoding Part :("
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Keyword Identification (Old Code, Do Not Run)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Description: Some addresses already have the baranggay written in them – so we don't need to search those up. Then, we identify addresses by villages/projects/roads which will hopefully make it easier to classify things."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 109,
   "metadata": {},
   "outputs": [],
   "source": [
    "def nextword(target, source, count):\n",
    "    for i, w in enumerate(source):\n",
    "        if w == target:\n",
    "            try:\n",
    "                return source[i+count]\n",
    "            except:\n",
    "                return ' '\n",
    "\n",
    "key = []\n",
    "entry = []\n",
    "for item in fix['lst']:\n",
    "    keys = set(item).intersection(['BGY','BRGY','VILLAGE','SUBD','HILLS','HOMES','HEIGHTS','HTS','PROJ','PROJECT',\n",
    "                                   'BLDG','CONDO','ST','STR','RD','AVE','STREET','ROAD','AVENUE','DRIVE','SCT',\n",
    "                                   'SCOUT','EXT','EXTN','EXTENSION','APT'])\n",
    "    if len(keys) == 0:\n",
    "        key.append('None')\n",
    "        entry.append(' '.join(item)) \n",
    "    #Baranggay\n",
    "    if 'BGY' in keys:\n",
    "        key.append('Barangay')\n",
    "        entry.append(nextword('BGY',item,1))\n",
    "    elif 'BRGY' in keys:\n",
    "        key.append('Barangay')\n",
    "        entry.append(nextword('BRGY',item,1))\n",
    "    #Village/Subdivision\n",
    "    elif 'VILLAGE' in keys:\n",
    "        key.append('Village')\n",
    "        entry.append(nextword('VILLAGE',item,-1))\n",
    "    elif 'SUBD' in keys:\n",
    "        key.append('Village')\n",
    "        entry.append(nextword('SUBD',item,-1))\n",
    "    elif 'HILLS' in keys:\n",
    "        key.append('Village')\n",
    "        entry.append(nextword('HILLS',item,-1))\n",
    "    elif 'HOMES' in keys:\n",
    "        key.append('Village')\n",
    "        entry.append(nextword('HOMES',item,-1))\n",
    "    elif 'HEIGHTS' in keys:\n",
    "        key.append('Village')\n",
    "        entry.append(nextword('HEIGHTS',item,-1))\n",
    "    elif 'HTS' in keys:\n",
    "        key.append('Village')\n",
    "        entry.append(nextword('HTS',item,-1))\n",
    "    #Project\n",
    "    elif 'PROJ' in keys:\n",
    "        key.append('Project')\n",
    "        entry.append(nextword('PROJ',item,1))\n",
    "    elif 'PROJECT' in keys:\n",
    "        key.append('Project')\n",
    "        entry.append(nextword('PROJECT',item,1))\n",
    "    #Road\n",
    "    elif 'ST' in keys:\n",
    "        key.append('Road')\n",
    "        entry.append(nextword('ST',item,-1))\n",
    "    elif 'RD' in keys:\n",
    "        key.append('Road')\n",
    "        entry.append(nextword('RD',item,-1))\n",
    "    elif 'STR' in keys:\n",
    "        key.append('Road')\n",
    "        entry.append(nextword('STR',item,-1))\n",
    "    elif 'STREET' in keys:\n",
    "        key.append('Road')\n",
    "        entry.append(nextword('STREET',item,-1))\n",
    "    elif 'DRIVE' in keys:\n",
    "        key.append('Road')\n",
    "        entry.append(nextword('DRIVE',item,-1))\n",
    "    elif 'EXT' in keys:\n",
    "        key.append('Road')\n",
    "        entry.append(nextword('EXT',item,-1))\n",
    "    elif 'EXTENSION' in keys:\n",
    "        key.append('Road')\n",
    "        entry.append(nextword('EXTENSION',item,-1))\n",
    "    elif 'EXTN' in keys:\n",
    "        key.append('Road')\n",
    "        entry.append(nextword('EXTN',item,-1))\n",
    "    elif 'SCT' in keys:\n",
    "        key.append('Road')\n",
    "        entry.append(nextword('SCT',item,1))\n",
    "    elif 'SCOUT' in keys:\n",
    "        key.append('Road')\n",
    "        entry.append(nextword('SCOUT',item,1))\n",
    "    \n",
    "    #Building\n",
    "    elif 'BLDG' in keys:\n",
    "        key.append('Building')\n",
    "        entry.append(nextword('BLDG',item,-1))\n",
    "    elif 'CONDO' in keys:\n",
    "        key.append('Building')\n",
    "        entry.append(nextword('CONDO',item,-1))\n",
    "    elif 'APT' in keys:\n",
    "        key.append('Building')\n",
    "        entry.append(nextword('APT',item,-1))\n",
    "    elif 'RESIDENCE' in keys:\n",
    "        key.append('Building')\n",
    "        entry.append(nextword('RESIDENCE',item,-1))\n",
    "    elif 'RESIDENCES' in keys:\n",
    "        key.append('Building')\n",
    "        entry.append(nextword('RESIDENCES',item,-1))\n",
    "\n",
    "    #Avenue\n",
    "    elif 'AVE' in keys:\n",
    "        key.append('Avenue')\n",
    "        entry.append(nextword('AVE',item,-1))\n",
    "    elif 'AVENUE' in keys:\n",
    "        key.append('Avenue')\n",
    "        entry.append(nextword('AVENUE',item,-1))\n",
    "    elif 'ROAD' in keys:\n",
    "        key.append('Avenue')\n",
    "        entry.append(nextword('ROAD',item,-1))\n",
    "    else:\n",
    "        pass\n",
    "\n",
    "fix['key'] = key\n",
    "fix['entry'] = entry"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The list \"l\" contains indices of addresses with no baranggays yet."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 89,
   "metadata": {},
   "outputs": [],
   "source": [
    "l=[i for i,v in enumerate(fix['bgy']) if v == None]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Checking for Baranggays"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Description: Follow the code below to manually encode!"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 135,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/lorenzoflores/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:2: UserWarning: Boolean Series key will be reindexed to match DataFrame index.\n",
      "  \n"
     ]
    },
    {
     "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>stripaddress</th>\n",
       "      <th>edit</th>\n",
       "      <th>lst</th>\n",
       "      <th>lat</th>\n",
       "      <th>lng</th>\n",
       "      <th>add</th>\n",
       "      <th>key</th>\n",
       "      <th>entry</th>\n",
       "      <th>pt</th>\n",
       "      <th>bgy</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>11</td>\n",
       "      <td>004 ZAMBOANGA ST., BAI COMPOUND, BRGY. VASRA, ...</td>\n",
       "      <td>004 ZAMBOANGA ST   BAI COMPOUND  BRGY  VASRA  ...</td>\n",
       "      <td>[004, ZAMBOANGA, ST, BAI, COMPOUND, BRGY, VASR...</td>\n",
       "      <td>6.92144</td>\n",
       "      <td>122.079</td>\n",
       "      <td>Zamboanga, Philippines</td>\n",
       "      <td>Barangay</td>\n",
       "      <td>VASRA</td>\n",
       "      <td>POINT (122.0790267 6.9214424)</td>\n",
       "      <td>Vasra</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>215</td>\n",
       "      <td>1064 A CULLEJON LIWANAG BGY 215 TONDO MANILA</td>\n",
       "      <td>1064 A CULLEJON LIWANAG BGY 215 TONDO MANILA</td>\n",
       "      <td>[1064, A, CULLEJON, LIWANAG, BGY, 215, TONDO, ...</td>\n",
       "      <td>45.6696</td>\n",
       "      <td>9.70363</td>\n",
       "      <td>Il Caravaggio Orio al Serio International Airp...</td>\n",
       "      <td>Barangay</td>\n",
       "      <td>215</td>\n",
       "      <td>POINT (9.7036313 45.66957070000001)</td>\n",
       "      <td>215</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          stripaddress  \\\n",
       "11   004 ZAMBOANGA ST., BAI COMPOUND, BRGY. VASRA, ...   \n",
       "215       1064 A CULLEJON LIWANAG BGY 215 TONDO MANILA   \n",
       "\n",
       "                                                  edit  \\\n",
       "11   004 ZAMBOANGA ST   BAI COMPOUND  BRGY  VASRA  ...   \n",
       "215       1064 A CULLEJON LIWANAG BGY 215 TONDO MANILA   \n",
       "\n",
       "                                                   lst      lat      lng  \\\n",
       "11   [004, ZAMBOANGA, ST, BAI, COMPOUND, BRGY, VASR...  6.92144  122.079   \n",
       "215  [1064, A, CULLEJON, LIWANAG, BGY, 215, TONDO, ...  45.6696  9.70363   \n",
       "\n",
       "                                                   add       key  entry  \\\n",
       "11                              Zamboanga, Philippines  Barangay  VASRA   \n",
       "215  Il Caravaggio Orio al Serio International Airp...  Barangay    215   \n",
       "\n",
       "                                      pt    bgy  \n",
       "11         POINT (122.0790267 6.9214424)  Vasra  \n",
       "215  POINT (9.7036313 45.66957070000001)    215  "
      ]
     },
     "execution_count": 135,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Shows the rows for missing barangays\n",
    "fix.iloc[l,:][fix['key']=='Barangay'].head(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 116,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/lorenzoflores/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:1: UserWarning: Boolean Series key will be reindexed to match DataFrame index.\n",
      "  \"\"\"Entry point for launching an IPython kernel.\n"
     ]
    }
   ],
   "source": [
    "#Gets indices of missing barangays\n",
    "missBrgy = fix.iloc[l,:][fix['key']=='Barangay']\n",
    "missBrgy = missBrgy.index.tolist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Input the list of barangays in \"brgys\"\n",
    "counter = 0\n",
    "brgys = ['Vasra','215','E. Rodriguez','93','Gulod','Santo Nino','171','Pury','San Antonio',\n",
    "         'Fortune','Bagong Silang','Bahay Toro','Dona Imelda','Batasan Hills']\n",
    "for i in missBrgy:\n",
    "    fix['bgy'][i] = brgys[counter]\n",
    "    counter += 1"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Checking for Villages"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 119,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/lorenzoflores/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:1: UserWarning: Boolean Series key will be reindexed to match DataFrame index.\n",
      "  \"\"\"Entry point for launching an IPython kernel.\n"
     ]
    }
   ],
   "source": [
    "missVill = fix.iloc[l,:][fix['key']=='Village']\n",
    "missVill = missVill.index.tolist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 118,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/lorenzoflores/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:1: UserWarning: Boolean Series key will be reindexed to match DataFrame index.\n",
      "  \"\"\"Entry point for launching an IPython kernel.\n"
     ]
    },
    {
     "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>stripaddress</th>\n",
       "      <th>edit</th>\n",
       "      <th>lst</th>\n",
       "      <th>lat</th>\n",
       "      <th>lng</th>\n",
       "      <th>add</th>\n",
       "      <th>key</th>\n",
       "      <th>entry</th>\n",
       "      <th>pt</th>\n",
       "      <th>bgy</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>659</td>\n",
       "      <td>15 BLK 52 PANTOMINA MAYOR ST LAGRO SUBD NOVALI...</td>\n",
       "      <td>15 BLK 52 PANTOMINA MAYOR ST LAGRO SUBD NOVALI...</td>\n",
       "      <td>[15, BLK, 52, PANTOMINA, MAYOR, ST, LAGRO, SUB...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Village</td>\n",
       "      <td>LAGRO</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>878</td>\n",
       "      <td>18C SNT JOSEPH ST MILTON HILLS SUBD NEW ERA (C...</td>\n",
       "      <td>18C SNT JOSEPH ST MILTON HILLS SUBD NEW ERA (C...</td>\n",
       "      <td>[18C, SNT, JOSEPH, ST, MILTON, HILLS, SUBD, NE...</td>\n",
       "      <td>37.9907</td>\n",
       "      <td>-78.4056</td>\n",
       "      <td>Milton Hills, Scottsville, VA 22902, USA</td>\n",
       "      <td>Village</td>\n",
       "      <td>HILLS</td>\n",
       "      <td>POINT (-78.40555139999999 37.9906854)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>879</td>\n",
       "      <td>18C SNT JOSEPH ST MILTON HILLS SUBD NEW ERA (C...</td>\n",
       "      <td>18C SNT JOSEPH ST MILTON HILLS SUBD NEW ERA (C...</td>\n",
       "      <td>[18C, SNT, JOSEPH, ST, MILTON, HILLS, SUBD, NE...</td>\n",
       "      <td>37.9907</td>\n",
       "      <td>-78.4056</td>\n",
       "      <td>Milton Hills, Scottsville, VA 22902, USA</td>\n",
       "      <td>Village</td>\n",
       "      <td>HILLS</td>\n",
       "      <td>POINT (-78.40555139999999 37.9906854)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1225</td>\n",
       "      <td>293 105 ST SOLDIERS VILLAGE SANTA LUCIA QUEZON...</td>\n",
       "      <td>293 105 ST SOLDIERS VILLAGE SANTA LUCIA QUEZON...</td>\n",
       "      <td>[293, 105, ST, SOLDIERS, VILLAGE, SANTA, LUCIA...</td>\n",
       "      <td>14.5767</td>\n",
       "      <td>121.103</td>\n",
       "      <td>205 90 Railroad St, Pasig, 1608 Metro Manila, ...</td>\n",
       "      <td>Village</td>\n",
       "      <td>SOLDIERS</td>\n",
       "      <td>POINT (121.1029383 14.5766815)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1410</td>\n",
       "      <td>3RD FLOOR 61 SAN ILDEFONSO DRIVE TORNES VILLAG...</td>\n",
       "      <td>3RD FLOOR 61 SAN ILDEFONSO DRIVE TORNES VILLAG...</td>\n",
       "      <td>[3RD, FLOOR, 61, SAN, ILDEFONSO, DRIVE, TORNES...</td>\n",
       "      <td>35.892</td>\n",
       "      <td>-106.118</td>\n",
       "      <td>San Ildefonso Pueblo, NM 87506, USA</td>\n",
       "      <td>Village</td>\n",
       "      <td>TORNES</td>\n",
       "      <td>POINT (-106.1183576 35.8919694)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1997</td>\n",
       "      <td>A SAN ANTONIO SUBD. DAMONG MALIIT NOVA QC, DAM...</td>\n",
       "      <td>A SAN ANTONIO SUBD  DAMONG MALIIT NOVA QC  DAM...</td>\n",
       "      <td>[A, SAN, ANTONIO, SUBD, DAMONG, MALIIT, NOVA, ...</td>\n",
       "      <td>29.4241</td>\n",
       "      <td>-98.4936</td>\n",
       "      <td>San Antonio, TX, USA</td>\n",
       "      <td>Village</td>\n",
       "      <td>ANTONIO</td>\n",
       "      <td>POINT (-98.49362819999999 29.4241219)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2100</td>\n",
       "      <td>ALLADO ST SAN ANTONIO SUBD DAMONG MALIIT NAGKA...</td>\n",
       "      <td>ALLADO ST SAN ANTONIO SUBD DAMONG MALIIT NAGKA...</td>\n",
       "      <td>[ALLADO, ST, SAN, ANTONIO, SUBD, DAMONG, MALII...</td>\n",
       "      <td>29.4241</td>\n",
       "      <td>-98.4936</td>\n",
       "      <td>San Antonio, TX, USA</td>\n",
       "      <td>Village</td>\n",
       "      <td>ANTONIO</td>\n",
       "      <td>POINT (-98.49362819999999 29.4241219)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2185</td>\n",
       "      <td>AREA 4 BAYANIHAN ST., TALANAY BATASAN HILLS QU...</td>\n",
       "      <td>AREA 4 BAYANIHAN ST   TALANAY BATASAN HILLS QU...</td>\n",
       "      <td>[AREA, 4, BAYANIHAN, ST, TALANAY, BATASAN, HIL...</td>\n",
       "      <td>14.6798</td>\n",
       "      <td>121.107</td>\n",
       "      <td>Batasan-San Mateo Rd, Quezon City, 1126 Metro ...</td>\n",
       "      <td>Village</td>\n",
       "      <td>BATASAN</td>\n",
       "      <td>POINT (121.1074655 14.6797618)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2442</td>\n",
       "      <td>B59 BRIMLEY ST FAIRVILLE HOMES NORTH FAIRVIEW ...</td>\n",
       "      <td>B59 BRIMLEY ST FAIRVILLE HOMES NORTH FAIRVIEW ...</td>\n",
       "      <td>[B59, BRIMLEY, ST, FAIRVILLE, HOMES, NORTH, FA...</td>\n",
       "      <td>46.4041</td>\n",
       "      <td>-84.5723</td>\n",
       "      <td>Brimley, MI 49715, USA</td>\n",
       "      <td>Village</td>\n",
       "      <td>FAIRVILLE</td>\n",
       "      <td>POINT (-84.5723077 46.4041232)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2454</td>\n",
       "      <td>B7-L14/16 P1 SILVERCREEK SUBD.</td>\n",
       "      <td>B7-L14/16 P1 SILVERCREEK SUBD</td>\n",
       "      <td>[B7-L14/16, P1, SILVERCREEK, SUBD]</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Village</td>\n",
       "      <td>SILVERCREEK</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2455</td>\n",
       "      <td>B7-L22 PORTICO-I SUBD.</td>\n",
       "      <td>B7-L22 PORTICO-I SUBD</td>\n",
       "      <td>[B7-L22, PORTICO-I, SUBD]</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Village</td>\n",
       "      <td>PORTICO-I</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2515</td>\n",
       "      <td>BATAAN RD GARCIA HTS LUZON AVE HOLY SPIRIT QUE...</td>\n",
       "      <td>BATAAN RD GARCIA HTS LUZON AVE HOLY SPIRIT QUE...</td>\n",
       "      <td>[BATAAN, RD, GARCIA, HTS, LUZON, AVE, HOLY, SP...</td>\n",
       "      <td>14.6417</td>\n",
       "      <td>120.482</td>\n",
       "      <td>Bataan, Philippines</td>\n",
       "      <td>Village</td>\n",
       "      <td>GARCIA</td>\n",
       "      <td>POINT (120.4818446 14.6416842)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2635</td>\n",
       "      <td>BLK 1 LOT 9 KASIYAHAN ST, BATASAN HILLS QUEZON...</td>\n",
       "      <td>BLK 1 LOT 9 KASIYAHAN ST  BATASAN HILLS QUEZON...</td>\n",
       "      <td>[BLK, 1, LOT, 9, KASIYAHAN, ST, BATASAN, HILLS...</td>\n",
       "      <td>14.6798</td>\n",
       "      <td>121.107</td>\n",
       "      <td>Batasan-San Mateo Rd, Quezon City, 1126 Metro ...</td>\n",
       "      <td>Village</td>\n",
       "      <td>BATASAN</td>\n",
       "      <td>POINT (121.1074655 14.6797618)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2667</td>\n",
       "      <td>BLK 13 LOT 15 SOLDIERS HILLS III TALA QUEZON CITY</td>\n",
       "      <td>BLK 13 LOT 15 SOLDIERS HILLS III TALA QUEZON CITY</td>\n",
       "      <td>[BLK, 13, LOT, 15, SOLDIERS, HILLS, III, TALA,...</td>\n",
       "      <td>14.7647</td>\n",
       "      <td>121.078</td>\n",
       "      <td>brgy. 180 Blk 5 Lot 32 Ruby street soldiers hi...</td>\n",
       "      <td>Village</td>\n",
       "      <td>SOLDIERS</td>\n",
       "      <td>POINT (121.0782249 14.7646773)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2673</td>\n",
       "      <td>BLK 14 LOT 36 SIEERA VISTA SUBD NOVA QUEZON CI...</td>\n",
       "      <td>BLK 14 LOT 36 SIEERA VISTA SUBD NOVA QUEZON CI...</td>\n",
       "      <td>[BLK, 14, LOT, 36, SIEERA, VISTA, SUBD, NOVA, ...</td>\n",
       "      <td>14.6338</td>\n",
       "      <td>121.127</td>\n",
       "      <td>Antipolo, Rizal, Philippines</td>\n",
       "      <td>Village</td>\n",
       "      <td>VISTA</td>\n",
       "      <td>POINT (121.1270683 14.6338387)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2691</td>\n",
       "      <td>BLK 1A GALLEY ST BATASAN HILLS QUEZON CITY</td>\n",
       "      <td>BLK 1A GALLEY ST BATASAN HILLS QUEZON CITY</td>\n",
       "      <td>[BLK, 1A, GALLEY, ST, BATASAN, HILLS, QUEZON, ...</td>\n",
       "      <td>14.6798</td>\n",
       "      <td>121.107</td>\n",
       "      <td>Batasan-San Mateo Rd, Quezon City, 1126 Metro ...</td>\n",
       "      <td>Village</td>\n",
       "      <td>BATASAN</td>\n",
       "      <td>POINT (121.1074655 14.6797618)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2749</td>\n",
       "      <td>BLK 2A LOT 33 PALMERA HOMES SUBD NOVALICHES EA...</td>\n",
       "      <td>BLK 2A LOT 33 PALMERA HOMES SUBD NOVALICHES EA...</td>\n",
       "      <td>[BLK, 2A, LOT, 33, PALMERA, HOMES, SUBD, NOVAL...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Village</td>\n",
       "      <td>HOMES</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2792</td>\n",
       "      <td>BLK 31 LOT 55 SALUBONG ST LAGRO SUBD NOVALICHE...</td>\n",
       "      <td>BLK 31 LOT 55 SALUBONG ST LAGRO SUBD NOVALICHE...</td>\n",
       "      <td>[BLK, 31, LOT, 55, SALUBONG, ST, LAGRO, SUBD, ...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Village</td>\n",
       "      <td>LAGRO</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2965</td>\n",
       "      <td>BLOCK 28 LOT 2 DIEGO SILANG ST NCE 1 BATASAN H...</td>\n",
       "      <td>BLOCK 28 LOT 2 DIEGO SILANG ST NCE 1 BATASAN H...</td>\n",
       "      <td>[BLOCK, 28, LOT, 2, DIEGO, SILANG, ST, NCE, 1,...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Village</td>\n",
       "      <td>BATASAN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3224</td>\n",
       "      <td>COMPOSTELA ST FILINVEST 2 BATASAN HILLS QUEZON...</td>\n",
       "      <td>COMPOSTELA ST FILINVEST 2 BATASAN HILLS QUEZON...</td>\n",
       "      <td>[COMPOSTELA, ST, FILINVEST, 2, BATASAN, HILLS,...</td>\n",
       "      <td>14.6798</td>\n",
       "      <td>121.107</td>\n",
       "      <td>Batasan-San Mateo Rd, Quezon City, 1126 Metro ...</td>\n",
       "      <td>Village</td>\n",
       "      <td>BATASAN</td>\n",
       "      <td>POINT (121.1074655 14.6797618)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3311</td>\n",
       "      <td>D&amp;A VICENTE VILLAGE EXT. BAGONG SILANGAN QUEZO...</td>\n",
       "      <td>D&amp;A VICENTE VILLAGE EXT  BAGONG SILANGAN QUEZO...</td>\n",
       "      <td>[D&amp;A, VICENTE, VILLAGE, EXT, BAGONG, SILANGAN,...</td>\n",
       "      <td>37.0902</td>\n",
       "      <td>-95.7129</td>\n",
       "      <td>United States</td>\n",
       "      <td>Village</td>\n",
       "      <td>VICENTE</td>\n",
       "      <td>POINT (-95.712891 37.09024)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3391</td>\n",
       "      <td>DIAMOND ST. NORTHVIEW 1, BATASAN HILLS, QUEZON...</td>\n",
       "      <td>DIAMOND ST  NORTHVIEW 1  BATASAN HILLS  QUEZON...</td>\n",
       "      <td>[DIAMOND, ST, NORTHVIEW, 1, BATASAN, HILLS, QU...</td>\n",
       "      <td>14.6798</td>\n",
       "      <td>121.107</td>\n",
       "      <td>Batasan-San Mateo Rd, Quezon City, 1126 Metro ...</td>\n",
       "      <td>Village</td>\n",
       "      <td>BATASAN</td>\n",
       "      <td>POINT (121.1074655 14.6797618)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3524</td>\n",
       "      <td>EMERALD ST NORTHVIEW I BATASAN HILLS QUEZON CITY</td>\n",
       "      <td>EMERALD ST NORTHVIEW I BATASAN HILLS QUEZON CITY</td>\n",
       "      <td>[EMERALD, ST, NORTHVIEW, I, BATASAN, HILLS, QU...</td>\n",
       "      <td>14.6798</td>\n",
       "      <td>121.107</td>\n",
       "      <td>Batasan-San Mateo Rd, Quezon City, 1126 Metro ...</td>\n",
       "      <td>Village</td>\n",
       "      <td>BATASAN</td>\n",
       "      <td>POINT (121.1074655 14.6797618)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3546</td>\n",
       "      <td>EUCLID ST COR DALTON PASS ROAD VETERANS VILLAG...</td>\n",
       "      <td>EUCLID ST COR DALTON PASS ROAD VETERANS VILLAG...</td>\n",
       "      <td>[EUCLID, ST, COR, DALTON, PASS, ROAD, VETERANS...</td>\n",
       "      <td>16.1308</td>\n",
       "      <td>120.936</td>\n",
       "      <td>Dalton Pass, Santa Fe, Nueva Vizcaya, Philippines</td>\n",
       "      <td>Village</td>\n",
       "      <td>VETERANS</td>\n",
       "      <td>POINT (120.9363889 16.1308333)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3679</td>\n",
       "      <td>GARDENIAN LANE BELLEVUE GRACE VILLAGE QUEZON CITY</td>\n",
       "      <td>GARDENIAN LANE BELLEVUE GRACE VILLAGE QUEZON CITY</td>\n",
       "      <td>[GARDENIAN, LANE, BELLEVUE, GRACE, VILLAGE, QU...</td>\n",
       "      <td>47.6101</td>\n",
       "      <td>-122.202</td>\n",
       "      <td>Bellevue, WA, USA</td>\n",
       "      <td>Village</td>\n",
       "      <td>GRACE</td>\n",
       "      <td>POINT (-122.2015159 47.6101497)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3681</td>\n",
       "      <td>GARNET ST NORTHVIEW I BATASAN HILLS QUEZON CITY</td>\n",
       "      <td>GARNET ST NORTHVIEW I BATASAN HILLS QUEZON CITY</td>\n",
       "      <td>[GARNET, ST, NORTHVIEW, I, BATASAN, HILLS, QUE...</td>\n",
       "      <td>14.6798</td>\n",
       "      <td>121.107</td>\n",
       "      <td>Batasan-San Mateo Rd, Quezon City, 1126 Metro ...</td>\n",
       "      <td>Village</td>\n",
       "      <td>BATASAN</td>\n",
       "      <td>POINT (121.1074655 14.6797618)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3682</td>\n",
       "      <td>GARNET ST. NORTHVIEW, BATASAN HILLS,, BATASAN ...</td>\n",
       "      <td>GARNET ST  NORTHVIEW  BATASAN HILLS   BATASAN ...</td>\n",
       "      <td>[GARNET, ST, NORTHVIEW, BATASAN, HILLS, BATASA...</td>\n",
       "      <td>14.6798</td>\n",
       "      <td>121.107</td>\n",
       "      <td>Batasan-San Mateo Rd, Quezon City, 1126 Metro ...</td>\n",
       "      <td>Village</td>\n",
       "      <td>BATASAN</td>\n",
       "      <td>POINT (121.1074655 14.6797618)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3683</td>\n",
       "      <td>GARNET STREET NORTHVIEW 1, BATASAN HILLS, QUEZ...</td>\n",
       "      <td>GARNET STREET NORTHVIEW 1  BATASAN HILLS  QUEZ...</td>\n",
       "      <td>[GARNET, STREET, NORTHVIEW, 1, BATASAN, HILLS,...</td>\n",
       "      <td>14.6798</td>\n",
       "      <td>121.107</td>\n",
       "      <td>Batasan-San Mateo Rd, Quezon City, 1126 Metro ...</td>\n",
       "      <td>Village</td>\n",
       "      <td>BATASAN</td>\n",
       "      <td>POINT (121.1074655 14.6797618)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3772</td>\n",
       "      <td>HARDAWAY CORNER OAKWOOD ST. SERRA MONTE, BATAS...</td>\n",
       "      <td>HARDAWAY CORNER OAKWOOD ST  SERRA MONTE  BATAS...</td>\n",
       "      <td>[HARDAWAY, CORNER, OAKWOOD, ST, SERRA, MONTE, ...</td>\n",
       "      <td>14.6883</td>\n",
       "      <td>121.111</td>\n",
       "      <td>Quezon City, Metro Manila, Philippines</td>\n",
       "      <td>Village</td>\n",
       "      <td>BATASAN</td>\n",
       "      <td>POINT (121.1105313 14.6883058)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4074</td>\n",
       "      <td>KALAYAAN ST. BATASAN HILLS QUEZON CITY NCR</td>\n",
       "      <td>KALAYAAN ST  BATASAN HILLS QUEZON CITY NCR</td>\n",
       "      <td>[KALAYAAN, ST, BATASAN, HILLS, QUEZON, CITY, NCR]</td>\n",
       "      <td>14.6847</td>\n",
       "      <td>121.114</td>\n",
       "      <td>Kalayaan St, Quezon City, Metro Manila, Philip...</td>\n",
       "      <td>Village</td>\n",
       "      <td>BATASAN</td>\n",
       "      <td>POINT (121.1144731 14.6847098)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4227</td>\n",
       "      <td>L22 KAKAMPI ST. BATASAN HILLS QUEZON CITY NCR</td>\n",
       "      <td>L22 KAKAMPI ST  BATASAN HILLS QUEZON CITY NCR</td>\n",
       "      <td>[L22, KAKAMPI, ST, BATASAN, HILLS, QUEZON, CIT...</td>\n",
       "      <td>14.6798</td>\n",
       "      <td>121.107</td>\n",
       "      <td>Batasan-San Mateo Rd, Quezon City, 1126 Metro ...</td>\n",
       "      <td>Village</td>\n",
       "      <td>BATASAN</td>\n",
       "      <td>POINT (121.1074655 14.6797618)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4764</td>\n",
       "      <td>MOLAVE ST. NORTHVIEW 2, BATASAN HILLS, QUEZON ...</td>\n",
       "      <td>MOLAVE ST  NORTHVIEW 2  BATASAN HILLS  QUEZON ...</td>\n",
       "      <td>[MOLAVE, ST, NORTHVIEW, 2, BATASAN, HILLS, QUE...</td>\n",
       "      <td>14.6798</td>\n",
       "      <td>121.107</td>\n",
       "      <td>Batasan-San Mateo Rd, Quezon City, 1126 Metro ...</td>\n",
       "      <td>Village</td>\n",
       "      <td>BATASAN</td>\n",
       "      <td>POINT (121.1074655 14.6797618)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4905</td>\n",
       "      <td>NANGKA ST NORTHVIEW 2 FILINVEST 2 BATASAN HILL...</td>\n",
       "      <td>NANGKA ST NORTHVIEW 2 FILINVEST 2 BATASAN HILL...</td>\n",
       "      <td>[NANGKA, ST, NORTHVIEW, 2, FILINVEST, 2, BATAS...</td>\n",
       "      <td>14.6798</td>\n",
       "      <td>121.107</td>\n",
       "      <td>Batasan-San Mateo Rd, Quezon City, 1126 Metro ...</td>\n",
       "      <td>Village</td>\n",
       "      <td>BATASAN</td>\n",
       "      <td>POINT (121.1074655 14.6797618)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4906</td>\n",
       "      <td>NANGKA STREET NORTHVIEW 2 FILINVEST 2 BATASAN ...</td>\n",
       "      <td>NANGKA STREET NORTHVIEW 2 FILINVEST 2 BATASAN ...</td>\n",
       "      <td>[NANGKA, STREET, NORTHVIEW, 2, FILINVEST, 2, B...</td>\n",
       "      <td>14.6798</td>\n",
       "      <td>121.107</td>\n",
       "      <td>Batasan-San Mateo Rd, Quezon City, 1126 Metro ...</td>\n",
       "      <td>Village</td>\n",
       "      <td>BATASAN</td>\n",
       "      <td>POINT (121.1074655 14.6797618)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5133</td>\n",
       "      <td>PEARL ST NORTHVIEW I FILINVEST II BATASAN HILL...</td>\n",
       "      <td>PEARL ST NORTHVIEW I FILINVEST II BATASAN HILL...</td>\n",
       "      <td>[PEARL, ST, NORTHVIEW, I, FILINVEST, II, BATAS...</td>\n",
       "      <td>14.6798</td>\n",
       "      <td>121.107</td>\n",
       "      <td>Batasan-San Mateo Rd, Quezon City, 1126 Metro ...</td>\n",
       "      <td>Village</td>\n",
       "      <td>BATASAN</td>\n",
       "      <td>POINT (121.1074655 14.6797618)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5273</td>\n",
       "      <td>PUROK 9A COUNTRY HILLS LUINAB, ILIGAN CITY</td>\n",
       "      <td>PUROK 9A COUNTRY HILLS LUINAB  ILIGAN CITY</td>\n",
       "      <td>[PUROK, 9A, COUNTRY, HILLS, LUINAB, ILIGAN, CITY]</td>\n",
       "      <td>8.23776</td>\n",
       "      <td>124.265</td>\n",
       "      <td>Iligan City, Lanao del Norte, Philippines</td>\n",
       "      <td>Village</td>\n",
       "      <td>COUNTRY</td>\n",
       "      <td>POINT (124.2649727 8.237762099999999)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5347</td>\n",
       "      <td>RIVERSIDE SUBD. BALINTAWAK, N/A, N/A, N/A</td>\n",
       "      <td>RIVERSIDE SUBD  BALINTAWAK  N/A  N/A  N/A</td>\n",
       "      <td>[RIVERSIDE, SUBD, BALINTAWAK, N/A, N/A, N/A]</td>\n",
       "      <td>33.9806</td>\n",
       "      <td>-117.375</td>\n",
       "      <td>Riverside, CA, USA</td>\n",
       "      <td>Village</td>\n",
       "      <td>RIVERSIDE</td>\n",
       "      <td>POINT (-117.3754942 33.9806005)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5631</td>\n",
       "      <td>SITIO GULOD KALAYAAN B BATASAN HILLS QUEZON CITY</td>\n",
       "      <td>SITIO GULOD KALAYAAN B BATASAN HILLS QUEZON CITY</td>\n",
       "      <td>[SITIO, GULOD, KALAYAAN, B, BATASAN, HILLS, QU...</td>\n",
       "      <td>14.7776</td>\n",
       "      <td>120.998</td>\n",
       "      <td>Sitio Gulod St, Meycauayan, Bulacan, Philippines</td>\n",
       "      <td>Village</td>\n",
       "      <td>BATASAN</td>\n",
       "      <td>POINT (120.9984454 14.7775863)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5875</td>\n",
       "      <td>TURQUOISE ST GEMSVILLE SUBD LAHUG (POB.) CEBU ...</td>\n",
       "      <td>TURQUOISE ST GEMSVILLE SUBD LAHUG (POB ) CEBU ...</td>\n",
       "      <td>[TURQUOISE, ST, GEMSVILLE, SUBD, LAHUG, (POB, ...</td>\n",
       "      <td>10.3248</td>\n",
       "      <td>123.902</td>\n",
       "      <td>Lahug, Cebu City, 6000 Cebu, Philippines</td>\n",
       "      <td>Village</td>\n",
       "      <td>GEMSVILLE</td>\n",
       "      <td>POINT (123.9018023 10.3248149)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5931</td>\n",
       "      <td>UNIT 2 MARCELESTER CTR KATIPUNAN AVE COR WEST ...</td>\n",
       "      <td>UNIT 2 MARCELESTER CTR KATIPUNAN AVE COR WEST ...</td>\n",
       "      <td>[UNIT, 2, MARCELESTER, CTR, KATIPUNAN, AVE, CO...</td>\n",
       "      <td>37.8744</td>\n",
       "      <td>-122.299</td>\n",
       "      <td>West Berkeley, Berkeley, CA 94710, USA</td>\n",
       "      <td>Village</td>\n",
       "      <td>CALIFORNIA</td>\n",
       "      <td>POINT (-122.2985808 37.8743703)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5937</td>\n",
       "      <td>UNIT 22-20 NEOVISTA HOMES BAGUMBONG NOVALICHES...</td>\n",
       "      <td>UNIT 22-20 NEOVISTA HOMES BAGUMBONG NOVALICHES...</td>\n",
       "      <td>[UNIT, 22-20, NEOVISTA, HOMES, BAGUMBONG, NOVA...</td>\n",
       "      <td>14.7511</td>\n",
       "      <td>121.011</td>\n",
       "      <td>Bagumbong Rd, Caloocan, Metro Manila, Philippines</td>\n",
       "      <td>Village</td>\n",
       "      <td>NEOVISTA</td>\n",
       "      <td>POINT (121.0105596 14.7510655)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5967</td>\n",
       "      <td>UNIT 4 DELA PAZ APARTMENT RIVERA AVENUE RIVERA...</td>\n",
       "      <td>UNIT 4 DELA PAZ APARTMENT RIVERA AVENUE RIVERA...</td>\n",
       "      <td>[UNIT, 4, DELA, PAZ, APARTMENT, RIVERA, AVENUE...</td>\n",
       "      <td>7.09806</td>\n",
       "      <td>125.62</td>\n",
       "      <td>Southern Philippines Medical Center,, J.P. Lau...</td>\n",
       "      <td>Village</td>\n",
       "      <td>RIVERA</td>\n",
       "      <td>POINT (125.619725 7.0980607)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>6153</td>\n",
       "      <td>YANEZA DRIVE SERRA MONTE VILLAS FILINVEST 2 BA...</td>\n",
       "      <td>YANEZA DRIVE SERRA MONTE VILLAS FILINVEST 2 BA...</td>\n",
       "      <td>[YANEZA, DRIVE, SERRA, MONTE, VILLAS, FILINVES...</td>\n",
       "      <td>14.6883</td>\n",
       "      <td>121.111</td>\n",
       "      <td>Quezon City, Metro Manila, Philippines</td>\n",
       "      <td>Village</td>\n",
       "      <td>BATASAN</td>\n",
       "      <td>POINT (121.1105313 14.6883058)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           stripaddress  \\\n",
       "659   15 BLK 52 PANTOMINA MAYOR ST LAGRO SUBD NOVALI...   \n",
       "878   18C SNT JOSEPH ST MILTON HILLS SUBD NEW ERA (C...   \n",
       "879   18C SNT JOSEPH ST MILTON HILLS SUBD NEW ERA (C...   \n",
       "1225  293 105 ST SOLDIERS VILLAGE SANTA LUCIA QUEZON...   \n",
       "1410  3RD FLOOR 61 SAN ILDEFONSO DRIVE TORNES VILLAG...   \n",
       "1997  A SAN ANTONIO SUBD. DAMONG MALIIT NOVA QC, DAM...   \n",
       "2100  ALLADO ST SAN ANTONIO SUBD DAMONG MALIIT NAGKA...   \n",
       "2185  AREA 4 BAYANIHAN ST., TALANAY BATASAN HILLS QU...   \n",
       "2442  B59 BRIMLEY ST FAIRVILLE HOMES NORTH FAIRVIEW ...   \n",
       "2454                     B7-L14/16 P1 SILVERCREEK SUBD.   \n",
       "2455                             B7-L22 PORTICO-I SUBD.   \n",
       "2515  BATAAN RD GARCIA HTS LUZON AVE HOLY SPIRIT QUE...   \n",
       "2635  BLK 1 LOT 9 KASIYAHAN ST, BATASAN HILLS QUEZON...   \n",
       "2667  BLK 13 LOT 15 SOLDIERS HILLS III TALA QUEZON CITY   \n",
       "2673  BLK 14 LOT 36 SIEERA VISTA SUBD NOVA QUEZON CI...   \n",
       "2691         BLK 1A GALLEY ST BATASAN HILLS QUEZON CITY   \n",
       "2749  BLK 2A LOT 33 PALMERA HOMES SUBD NOVALICHES EA...   \n",
       "2792  BLK 31 LOT 55 SALUBONG ST LAGRO SUBD NOVALICHE...   \n",
       "2965  BLOCK 28 LOT 2 DIEGO SILANG ST NCE 1 BATASAN H...   \n",
       "3224  COMPOSTELA ST FILINVEST 2 BATASAN HILLS QUEZON...   \n",
       "3311  D&A VICENTE VILLAGE EXT. BAGONG SILANGAN QUEZO...   \n",
       "3391  DIAMOND ST. NORTHVIEW 1, BATASAN HILLS, QUEZON...   \n",
       "3524   EMERALD ST NORTHVIEW I BATASAN HILLS QUEZON CITY   \n",
       "3546  EUCLID ST COR DALTON PASS ROAD VETERANS VILLAG...   \n",
       "3679  GARDENIAN LANE BELLEVUE GRACE VILLAGE QUEZON CITY   \n",
       "3681    GARNET ST NORTHVIEW I BATASAN HILLS QUEZON CITY   \n",
       "3682  GARNET ST. NORTHVIEW, BATASAN HILLS,, BATASAN ...   \n",
       "3683  GARNET STREET NORTHVIEW 1, BATASAN HILLS, QUEZ...   \n",
       "3772  HARDAWAY CORNER OAKWOOD ST. SERRA MONTE, BATAS...   \n",
       "4074         KALAYAAN ST. BATASAN HILLS QUEZON CITY NCR   \n",
       "4227      L22 KAKAMPI ST. BATASAN HILLS QUEZON CITY NCR   \n",
       "4764  MOLAVE ST. NORTHVIEW 2, BATASAN HILLS, QUEZON ...   \n",
       "4905  NANGKA ST NORTHVIEW 2 FILINVEST 2 BATASAN HILL...   \n",
       "4906  NANGKA STREET NORTHVIEW 2 FILINVEST 2 BATASAN ...   \n",
       "5133  PEARL ST NORTHVIEW I FILINVEST II BATASAN HILL...   \n",
       "5273         PUROK 9A COUNTRY HILLS LUINAB, ILIGAN CITY   \n",
       "5347          RIVERSIDE SUBD. BALINTAWAK, N/A, N/A, N/A   \n",
       "5631   SITIO GULOD KALAYAAN B BATASAN HILLS QUEZON CITY   \n",
       "5875  TURQUOISE ST GEMSVILLE SUBD LAHUG (POB.) CEBU ...   \n",
       "5931  UNIT 2 MARCELESTER CTR KATIPUNAN AVE COR WEST ...   \n",
       "5937  UNIT 22-20 NEOVISTA HOMES BAGUMBONG NOVALICHES...   \n",
       "5967  UNIT 4 DELA PAZ APARTMENT RIVERA AVENUE RIVERA...   \n",
       "6153  YANEZA DRIVE SERRA MONTE VILLAS FILINVEST 2 BA...   \n",
       "\n",
       "                                                   edit  \\\n",
       "659   15 BLK 52 PANTOMINA MAYOR ST LAGRO SUBD NOVALI...   \n",
       "878   18C SNT JOSEPH ST MILTON HILLS SUBD NEW ERA (C...   \n",
       "879   18C SNT JOSEPH ST MILTON HILLS SUBD NEW ERA (C...   \n",
       "1225  293 105 ST SOLDIERS VILLAGE SANTA LUCIA QUEZON...   \n",
       "1410  3RD FLOOR 61 SAN ILDEFONSO DRIVE TORNES VILLAG...   \n",
       "1997  A SAN ANTONIO SUBD  DAMONG MALIIT NOVA QC  DAM...   \n",
       "2100  ALLADO ST SAN ANTONIO SUBD DAMONG MALIIT NAGKA...   \n",
       "2185  AREA 4 BAYANIHAN ST   TALANAY BATASAN HILLS QU...   \n",
       "2442  B59 BRIMLEY ST FAIRVILLE HOMES NORTH FAIRVIEW ...   \n",
       "2454                     B7-L14/16 P1 SILVERCREEK SUBD    \n",
       "2455                             B7-L22 PORTICO-I SUBD    \n",
       "2515  BATAAN RD GARCIA HTS LUZON AVE HOLY SPIRIT QUE...   \n",
       "2635  BLK 1 LOT 9 KASIYAHAN ST  BATASAN HILLS QUEZON...   \n",
       "2667  BLK 13 LOT 15 SOLDIERS HILLS III TALA QUEZON CITY   \n",
       "2673  BLK 14 LOT 36 SIEERA VISTA SUBD NOVA QUEZON CI...   \n",
       "2691         BLK 1A GALLEY ST BATASAN HILLS QUEZON CITY   \n",
       "2749  BLK 2A LOT 33 PALMERA HOMES SUBD NOVALICHES EA...   \n",
       "2792  BLK 31 LOT 55 SALUBONG ST LAGRO SUBD NOVALICHE...   \n",
       "2965  BLOCK 28 LOT 2 DIEGO SILANG ST NCE 1 BATASAN H...   \n",
       "3224  COMPOSTELA ST FILINVEST 2 BATASAN HILLS QUEZON...   \n",
       "3311  D&A VICENTE VILLAGE EXT  BAGONG SILANGAN QUEZO...   \n",
       "3391  DIAMOND ST  NORTHVIEW 1  BATASAN HILLS  QUEZON...   \n",
       "3524   EMERALD ST NORTHVIEW I BATASAN HILLS QUEZON CITY   \n",
       "3546  EUCLID ST COR DALTON PASS ROAD VETERANS VILLAG...   \n",
       "3679  GARDENIAN LANE BELLEVUE GRACE VILLAGE QUEZON CITY   \n",
       "3681    GARNET ST NORTHVIEW I BATASAN HILLS QUEZON CITY   \n",
       "3682  GARNET ST  NORTHVIEW  BATASAN HILLS   BATASAN ...   \n",
       "3683  GARNET STREET NORTHVIEW 1  BATASAN HILLS  QUEZ...   \n",
       "3772  HARDAWAY CORNER OAKWOOD ST  SERRA MONTE  BATAS...   \n",
       "4074         KALAYAAN ST  BATASAN HILLS QUEZON CITY NCR   \n",
       "4227      L22 KAKAMPI ST  BATASAN HILLS QUEZON CITY NCR   \n",
       "4764  MOLAVE ST  NORTHVIEW 2  BATASAN HILLS  QUEZON ...   \n",
       "4905  NANGKA ST NORTHVIEW 2 FILINVEST 2 BATASAN HILL...   \n",
       "4906  NANGKA STREET NORTHVIEW 2 FILINVEST 2 BATASAN ...   \n",
       "5133  PEARL ST NORTHVIEW I FILINVEST II BATASAN HILL...   \n",
       "5273         PUROK 9A COUNTRY HILLS LUINAB  ILIGAN CITY   \n",
       "5347          RIVERSIDE SUBD  BALINTAWAK  N/A  N/A  N/A   \n",
       "5631   SITIO GULOD KALAYAAN B BATASAN HILLS QUEZON CITY   \n",
       "5875  TURQUOISE ST GEMSVILLE SUBD LAHUG (POB ) CEBU ...   \n",
       "5931  UNIT 2 MARCELESTER CTR KATIPUNAN AVE COR WEST ...   \n",
       "5937  UNIT 22-20 NEOVISTA HOMES BAGUMBONG NOVALICHES...   \n",
       "5967  UNIT 4 DELA PAZ APARTMENT RIVERA AVENUE RIVERA...   \n",
       "6153  YANEZA DRIVE SERRA MONTE VILLAS FILINVEST 2 BA...   \n",
       "\n",
       "                                                    lst      lat      lng  \\\n",
       "659   [15, BLK, 52, PANTOMINA, MAYOR, ST, LAGRO, SUB...     None     None   \n",
       "878   [18C, SNT, JOSEPH, ST, MILTON, HILLS, SUBD, NE...  37.9907 -78.4056   \n",
       "879   [18C, SNT, JOSEPH, ST, MILTON, HILLS, SUBD, NE...  37.9907 -78.4056   \n",
       "1225  [293, 105, ST, SOLDIERS, VILLAGE, SANTA, LUCIA...  14.5767  121.103   \n",
       "1410  [3RD, FLOOR, 61, SAN, ILDEFONSO, DRIVE, TORNES...   35.892 -106.118   \n",
       "1997  [A, SAN, ANTONIO, SUBD, DAMONG, MALIIT, NOVA, ...  29.4241 -98.4936   \n",
       "2100  [ALLADO, ST, SAN, ANTONIO, SUBD, DAMONG, MALII...  29.4241 -98.4936   \n",
       "2185  [AREA, 4, BAYANIHAN, ST, TALANAY, BATASAN, HIL...  14.6798  121.107   \n",
       "2442  [B59, BRIMLEY, ST, FAIRVILLE, HOMES, NORTH, FA...  46.4041 -84.5723   \n",
       "2454                 [B7-L14/16, P1, SILVERCREEK, SUBD]     None     None   \n",
       "2455                          [B7-L22, PORTICO-I, SUBD]     None     None   \n",
       "2515  [BATAAN, RD, GARCIA, HTS, LUZON, AVE, HOLY, SP...  14.6417  120.482   \n",
       "2635  [BLK, 1, LOT, 9, KASIYAHAN, ST, BATASAN, HILLS...  14.6798  121.107   \n",
       "2667  [BLK, 13, LOT, 15, SOLDIERS, HILLS, III, TALA,...  14.7647  121.078   \n",
       "2673  [BLK, 14, LOT, 36, SIEERA, VISTA, SUBD, NOVA, ...  14.6338  121.127   \n",
       "2691  [BLK, 1A, GALLEY, ST, BATASAN, HILLS, QUEZON, ...  14.6798  121.107   \n",
       "2749  [BLK, 2A, LOT, 33, PALMERA, HOMES, SUBD, NOVAL...     None     None   \n",
       "2792  [BLK, 31, LOT, 55, SALUBONG, ST, LAGRO, SUBD, ...     None     None   \n",
       "2965  [BLOCK, 28, LOT, 2, DIEGO, SILANG, ST, NCE, 1,...     None     None   \n",
       "3224  [COMPOSTELA, ST, FILINVEST, 2, BATASAN, HILLS,...  14.6798  121.107   \n",
       "3311  [D&A, VICENTE, VILLAGE, EXT, BAGONG, SILANGAN,...  37.0902 -95.7129   \n",
       "3391  [DIAMOND, ST, NORTHVIEW, 1, BATASAN, HILLS, QU...  14.6798  121.107   \n",
       "3524  [EMERALD, ST, NORTHVIEW, I, BATASAN, HILLS, QU...  14.6798  121.107   \n",
       "3546  [EUCLID, ST, COR, DALTON, PASS, ROAD, VETERANS...  16.1308  120.936   \n",
       "3679  [GARDENIAN, LANE, BELLEVUE, GRACE, VILLAGE, QU...  47.6101 -122.202   \n",
       "3681  [GARNET, ST, NORTHVIEW, I, BATASAN, HILLS, QUE...  14.6798  121.107   \n",
       "3682  [GARNET, ST, NORTHVIEW, BATASAN, HILLS, BATASA...  14.6798  121.107   \n",
       "3683  [GARNET, STREET, NORTHVIEW, 1, BATASAN, HILLS,...  14.6798  121.107   \n",
       "3772  [HARDAWAY, CORNER, OAKWOOD, ST, SERRA, MONTE, ...  14.6883  121.111   \n",
       "4074  [KALAYAAN, ST, BATASAN, HILLS, QUEZON, CITY, NCR]  14.6847  121.114   \n",
       "4227  [L22, KAKAMPI, ST, BATASAN, HILLS, QUEZON, CIT...  14.6798  121.107   \n",
       "4764  [MOLAVE, ST, NORTHVIEW, 2, BATASAN, HILLS, QUE...  14.6798  121.107   \n",
       "4905  [NANGKA, ST, NORTHVIEW, 2, FILINVEST, 2, BATAS...  14.6798  121.107   \n",
       "4906  [NANGKA, STREET, NORTHVIEW, 2, FILINVEST, 2, B...  14.6798  121.107   \n",
       "5133  [PEARL, ST, NORTHVIEW, I, FILINVEST, II, BATAS...  14.6798  121.107   \n",
       "5273  [PUROK, 9A, COUNTRY, HILLS, LUINAB, ILIGAN, CITY]  8.23776  124.265   \n",
       "5347       [RIVERSIDE, SUBD, BALINTAWAK, N/A, N/A, N/A]  33.9806 -117.375   \n",
       "5631  [SITIO, GULOD, KALAYAAN, B, BATASAN, HILLS, QU...  14.7776  120.998   \n",
       "5875  [TURQUOISE, ST, GEMSVILLE, SUBD, LAHUG, (POB, ...  10.3248  123.902   \n",
       "5931  [UNIT, 2, MARCELESTER, CTR, KATIPUNAN, AVE, CO...  37.8744 -122.299   \n",
       "5937  [UNIT, 22-20, NEOVISTA, HOMES, BAGUMBONG, NOVA...  14.7511  121.011   \n",
       "5967  [UNIT, 4, DELA, PAZ, APARTMENT, RIVERA, AVENUE...  7.09806   125.62   \n",
       "6153  [YANEZA, DRIVE, SERRA, MONTE, VILLAS, FILINVES...  14.6883  121.111   \n",
       "\n",
       "                                                    add      key        entry  \\\n",
       "659                                                None  Village        LAGRO   \n",
       "878            Milton Hills, Scottsville, VA 22902, USA  Village        HILLS   \n",
       "879            Milton Hills, Scottsville, VA 22902, USA  Village        HILLS   \n",
       "1225  205 90 Railroad St, Pasig, 1608 Metro Manila, ...  Village     SOLDIERS   \n",
       "1410                San Ildefonso Pueblo, NM 87506, USA  Village       TORNES   \n",
       "1997                               San Antonio, TX, USA  Village      ANTONIO   \n",
       "2100                               San Antonio, TX, USA  Village      ANTONIO   \n",
       "2185  Batasan-San Mateo Rd, Quezon City, 1126 Metro ...  Village      BATASAN   \n",
       "2442                             Brimley, MI 49715, USA  Village    FAIRVILLE   \n",
       "2454                                               None  Village  SILVERCREEK   \n",
       "2455                                               None  Village    PORTICO-I   \n",
       "2515                                Bataan, Philippines  Village       GARCIA   \n",
       "2635  Batasan-San Mateo Rd, Quezon City, 1126 Metro ...  Village      BATASAN   \n",
       "2667  brgy. 180 Blk 5 Lot 32 Ruby street soldiers hi...  Village     SOLDIERS   \n",
       "2673                       Antipolo, Rizal, Philippines  Village        VISTA   \n",
       "2691  Batasan-San Mateo Rd, Quezon City, 1126 Metro ...  Village      BATASAN   \n",
       "2749                                               None  Village        HOMES   \n",
       "2792                                               None  Village        LAGRO   \n",
       "2965                                               None  Village      BATASAN   \n",
       "3224  Batasan-San Mateo Rd, Quezon City, 1126 Metro ...  Village      BATASAN   \n",
       "3311                                      United States  Village      VICENTE   \n",
       "3391  Batasan-San Mateo Rd, Quezon City, 1126 Metro ...  Village      BATASAN   \n",
       "3524  Batasan-San Mateo Rd, Quezon City, 1126 Metro ...  Village      BATASAN   \n",
       "3546  Dalton Pass, Santa Fe, Nueva Vizcaya, Philippines  Village     VETERANS   \n",
       "3679                                  Bellevue, WA, USA  Village        GRACE   \n",
       "3681  Batasan-San Mateo Rd, Quezon City, 1126 Metro ...  Village      BATASAN   \n",
       "3682  Batasan-San Mateo Rd, Quezon City, 1126 Metro ...  Village      BATASAN   \n",
       "3683  Batasan-San Mateo Rd, Quezon City, 1126 Metro ...  Village      BATASAN   \n",
       "3772             Quezon City, Metro Manila, Philippines  Village      BATASAN   \n",
       "4074  Kalayaan St, Quezon City, Metro Manila, Philip...  Village      BATASAN   \n",
       "4227  Batasan-San Mateo Rd, Quezon City, 1126 Metro ...  Village      BATASAN   \n",
       "4764  Batasan-San Mateo Rd, Quezon City, 1126 Metro ...  Village      BATASAN   \n",
       "4905  Batasan-San Mateo Rd, Quezon City, 1126 Metro ...  Village      BATASAN   \n",
       "4906  Batasan-San Mateo Rd, Quezon City, 1126 Metro ...  Village      BATASAN   \n",
       "5133  Batasan-San Mateo Rd, Quezon City, 1126 Metro ...  Village      BATASAN   \n",
       "5273          Iligan City, Lanao del Norte, Philippines  Village      COUNTRY   \n",
       "5347                                 Riverside, CA, USA  Village    RIVERSIDE   \n",
       "5631   Sitio Gulod St, Meycauayan, Bulacan, Philippines  Village      BATASAN   \n",
       "5875           Lahug, Cebu City, 6000 Cebu, Philippines  Village    GEMSVILLE   \n",
       "5931             West Berkeley, Berkeley, CA 94710, USA  Village   CALIFORNIA   \n",
       "5937  Bagumbong Rd, Caloocan, Metro Manila, Philippines  Village     NEOVISTA   \n",
       "5967  Southern Philippines Medical Center,, J.P. Lau...  Village       RIVERA   \n",
       "6153             Quezon City, Metro Manila, Philippines  Village      BATASAN   \n",
       "\n",
       "                                         pt   bgy  \n",
       "659                                    None  None  \n",
       "878   POINT (-78.40555139999999 37.9906854)  None  \n",
       "879   POINT (-78.40555139999999 37.9906854)  None  \n",
       "1225         POINT (121.1029383 14.5766815)  None  \n",
       "1410        POINT (-106.1183576 35.8919694)  None  \n",
       "1997  POINT (-98.49362819999999 29.4241219)  None  \n",
       "2100  POINT (-98.49362819999999 29.4241219)  None  \n",
       "2185         POINT (121.1074655 14.6797618)  None  \n",
       "2442         POINT (-84.5723077 46.4041232)  None  \n",
       "2454                                   None  None  \n",
       "2455                                   None  None  \n",
       "2515         POINT (120.4818446 14.6416842)  None  \n",
       "2635         POINT (121.1074655 14.6797618)  None  \n",
       "2667         POINT (121.0782249 14.7646773)  None  \n",
       "2673         POINT (121.1270683 14.6338387)  None  \n",
       "2691         POINT (121.1074655 14.6797618)  None  \n",
       "2749                                   None  None  \n",
       "2792                                   None  None  \n",
       "2965                                   None  None  \n",
       "3224         POINT (121.1074655 14.6797618)  None  \n",
       "3311            POINT (-95.712891 37.09024)  None  \n",
       "3391         POINT (121.1074655 14.6797618)  None  \n",
       "3524         POINT (121.1074655 14.6797618)  None  \n",
       "3546         POINT (120.9363889 16.1308333)  None  \n",
       "3679        POINT (-122.2015159 47.6101497)  None  \n",
       "3681         POINT (121.1074655 14.6797618)  None  \n",
       "3682         POINT (121.1074655 14.6797618)  None  \n",
       "3683         POINT (121.1074655 14.6797618)  None  \n",
       "3772         POINT (121.1105313 14.6883058)  None  \n",
       "4074         POINT (121.1144731 14.6847098)  None  \n",
       "4227         POINT (121.1074655 14.6797618)  None  \n",
       "4764         POINT (121.1074655 14.6797618)  None  \n",
       "4905         POINT (121.1074655 14.6797618)  None  \n",
       "4906         POINT (121.1074655 14.6797618)  None  \n",
       "5133         POINT (121.1074655 14.6797618)  None  \n",
       "5273  POINT (124.2649727 8.237762099999999)  None  \n",
       "5347        POINT (-117.3754942 33.9806005)  None  \n",
       "5631         POINT (120.9984454 14.7775863)  None  \n",
       "5875         POINT (123.9018023 10.3248149)  None  \n",
       "5931        POINT (-122.2985808 37.8743703)  None  \n",
       "5937         POINT (121.0105596 14.7510655)  None  \n",
       "5967           POINT (125.619725 7.0980607)  None  \n",
       "6153         POINT (121.1105313 14.6883058)  None  "
      ]
     },
     "execution_count": 118,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fix.iloc[l,:][fix['key']=='Village']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 129,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'YANEZA DRIVE SERRA MONTE VILLAS FILINVEST 2 BATASAN HILLS QUEZON CITY'"
      ]
     },
     "execution_count": 129,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fix.loc[6153,]['edit']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 130,
   "metadata": {},
   "outputs": [],
   "source": [
    "counter = 0\n",
    "vills = ['Greater Lagro','Culiat','Culiat','Santa Lucia','Nagkaisang Nayon',\n",
    "         'Nagkaisang Nayon','Nagkaisang Nayon','Batasan Hills','Greater Lagro',\n",
    "         'Bocohan','Lumbia','Holy Spirit','Batasan Hills','180','Nagkaisang Nayon',\n",
    "          'Batasan Hills','Santa Monica','Greater Lagro','Nagkaisang Nayon',\n",
    "          'Batasan Hills','Bagong Silangan','Batasan Hills','Batasan Hills',\n",
    "          'Holy Spirit','Balintawak','Batasan Hills','Batasan Hills','Batasan Hills',\n",
    "          'Batasan Hills','Batasan Hills','Batasan Hills','Batasan Hills',\n",
    "          'Batasan Hills','Batasan Hills','Batasan Hills','Luinab','Balintawak',\n",
    "          'Batasan Hills','Lahug','San Bartolome','171','164','Batasan Hills']\n",
    "for i in missVill:\n",
    "    fix['bgy'][i] = vills[counter]\n",
    "    counter += 1"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Checking for Projects"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 131,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/lorenzoflores/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:1: UserWarning: Boolean Series key will be reindexed to match DataFrame index.\n",
      "  \"\"\"Entry point for launching an IPython kernel.\n"
     ]
    }
   ],
   "source": [
    "missProj = fix.iloc[l,:][fix['key']=='Project']\n",
    "missProj = missProj.index.tolist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 132,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/lorenzoflores/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:1: UserWarning: Boolean Series key will be reindexed to match DataFrame index.\n",
      "  \"\"\"Entry point for launching an IPython kernel.\n"
     ]
    },
    {
     "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>stripaddress</th>\n",
       "      <th>edit</th>\n",
       "      <th>lst</th>\n",
       "      <th>lat</th>\n",
       "      <th>lng</th>\n",
       "      <th>add</th>\n",
       "      <th>key</th>\n",
       "      <th>entry</th>\n",
       "      <th>pt</th>\n",
       "      <th>bgy</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>307</td>\n",
       "      <td>116 BAGUIO CMPD ROAD 20 PROJECT 8 QUEZON CITY</td>\n",
       "      <td>116 BAGUIO CMPD ROAD 20 PROJECT 8 QUEZON CITY</td>\n",
       "      <td>[116, BAGUIO, CMPD, ROAD, 20, PROJECT, 8, QUEZ...</td>\n",
       "      <td>16.4023</td>\n",
       "      <td>120.596</td>\n",
       "      <td>Baguio, Benguet, Philippines</td>\n",
       "      <td>Project</td>\n",
       "      <td>8</td>\n",
       "      <td>POINT (120.5960071 16.4023332)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1358</td>\n",
       "      <td>35-D PROJECT 4 ESCOPA I QUEZON CITY NCR</td>\n",
       "      <td>35-D PROJECT 4 ESCOPA I QUEZON CITY NCR</td>\n",
       "      <td>[35-D, PROJECT, 4, ESCOPA, I, QUEZON, CITY, NCR]</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Project</td>\n",
       "      <td>4</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1626</td>\n",
       "      <td>5-A AREVALO COMPD. GRANTS ST., PROJ. 8, SANGAN...</td>\n",
       "      <td>5-A AREVALO COMPD  GRANTS ST   PROJ  8  SANGAN...</td>\n",
       "      <td>[5-A, AREVALO, COMPD, GRANTS, ST, PROJ, 8, SAN...</td>\n",
       "      <td>41.059</td>\n",
       "      <td>-4.71874</td>\n",
       "      <td>05200 Arévalo, Ávila, Spain</td>\n",
       "      <td>Project</td>\n",
       "      <td>8</td>\n",
       "      <td>POINT (-4.7187424 41.058981)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2835</td>\n",
       "      <td>BLK 48 LOT 35 PROJ 4 ESCOPA III QUEZON CITY NCR</td>\n",
       "      <td>BLK 48 LOT 35 PROJ 4 ESCOPA III QUEZON CITY NCR</td>\n",
       "      <td>[BLK, 48, LOT, 35, PROJ, 4, ESCOPA, III, QUEZO...</td>\n",
       "      <td>46.3826</td>\n",
       "      <td>-63.0314</td>\n",
       "      <td>Lot 35, PE, Canada</td>\n",
       "      <td>Project</td>\n",
       "      <td>4</td>\n",
       "      <td>POINT (-63.0314308 46.3826063)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3076</td>\n",
       "      <td>C T MASCARDO ST VILLA MARIA CLARA PROJ 4 QUEZO...</td>\n",
       "      <td>C T MASCARDO ST VILLA MARIA CLARA PROJ 4 QUEZO...</td>\n",
       "      <td>[C, T, MASCARDO, ST, VILLA, MARIA, CLARA, PROJ...</td>\n",
       "      <td>41.6032</td>\n",
       "      <td>-73.0877</td>\n",
       "      <td>Connecticut, USA</td>\n",
       "      <td>Project</td>\n",
       "      <td>4</td>\n",
       "      <td>POINT (-73.087749 41.6032207)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3097</td>\n",
       "      <td>CAIRO ST STA RITA VILL PROJ 8 QUEZON CITY</td>\n",
       "      <td>CAIRO ST STA RITA VILL PROJ 8 QUEZON CITY</td>\n",
       "      <td>[CAIRO, ST, STA, RITA, VILL, PROJ, 8, QUEZON, ...</td>\n",
       "      <td>30.0444</td>\n",
       "      <td>31.2357</td>\n",
       "      <td>Cairo, Cairo Governorate, Egypt</td>\n",
       "      <td>Project</td>\n",
       "      <td>8</td>\n",
       "      <td>POINT (31.2357116 30.0444196)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3536</td>\n",
       "      <td>ERVIE BEN NOBLEZA 1009 AURORA BLVD PROJECT 3 D...</td>\n",
       "      <td>ERVIE BEN NOBLEZA 1009 AURORA BLVD PROJECT 3 D...</td>\n",
       "      <td>[ERVIE, BEN, NOBLEZA, 1009, AURORA, BLVD, PROJ...</td>\n",
       "      <td>54.9655</td>\n",
       "      <td>-5.12506</td>\n",
       "      <td>Ervie, Stranraer DG9 0RB, UK</td>\n",
       "      <td>Project</td>\n",
       "      <td>3</td>\n",
       "      <td>POINT (-5.125062 54.965514)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4461</td>\n",
       "      <td>LUCENA ST PROJECT 6 QUEZON CITY</td>\n",
       "      <td>LUCENA ST PROJECT 6 QUEZON CITY</td>\n",
       "      <td>[LUCENA, ST, PROJECT, 6, QUEZON, CITY]</td>\n",
       "      <td>13.9414</td>\n",
       "      <td>121.623</td>\n",
       "      <td>Lucena, 4301 Quezon, Philippines</td>\n",
       "      <td>Project</td>\n",
       "      <td>6</td>\n",
       "      <td>POINT (121.6234471 13.9413957)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           stripaddress  \\\n",
       "307       116 BAGUIO CMPD ROAD 20 PROJECT 8 QUEZON CITY   \n",
       "1358            35-D PROJECT 4 ESCOPA I QUEZON CITY NCR   \n",
       "1626  5-A AREVALO COMPD. GRANTS ST., PROJ. 8, SANGAN...   \n",
       "2835    BLK 48 LOT 35 PROJ 4 ESCOPA III QUEZON CITY NCR   \n",
       "3076  C T MASCARDO ST VILLA MARIA CLARA PROJ 4 QUEZO...   \n",
       "3097          CAIRO ST STA RITA VILL PROJ 8 QUEZON CITY   \n",
       "3536  ERVIE BEN NOBLEZA 1009 AURORA BLVD PROJECT 3 D...   \n",
       "4461                    LUCENA ST PROJECT 6 QUEZON CITY   \n",
       "\n",
       "                                                   edit  \\\n",
       "307       116 BAGUIO CMPD ROAD 20 PROJECT 8 QUEZON CITY   \n",
       "1358            35-D PROJECT 4 ESCOPA I QUEZON CITY NCR   \n",
       "1626  5-A AREVALO COMPD  GRANTS ST   PROJ  8  SANGAN...   \n",
       "2835    BLK 48 LOT 35 PROJ 4 ESCOPA III QUEZON CITY NCR   \n",
       "3076  C T MASCARDO ST VILLA MARIA CLARA PROJ 4 QUEZO...   \n",
       "3097          CAIRO ST STA RITA VILL PROJ 8 QUEZON CITY   \n",
       "3536  ERVIE BEN NOBLEZA 1009 AURORA BLVD PROJECT 3 D...   \n",
       "4461                    LUCENA ST PROJECT 6 QUEZON CITY   \n",
       "\n",
       "                                                    lst      lat      lng  \\\n",
       "307   [116, BAGUIO, CMPD, ROAD, 20, PROJECT, 8, QUEZ...  16.4023  120.596   \n",
       "1358   [35-D, PROJECT, 4, ESCOPA, I, QUEZON, CITY, NCR]     None     None   \n",
       "1626  [5-A, AREVALO, COMPD, GRANTS, ST, PROJ, 8, SAN...   41.059 -4.71874   \n",
       "2835  [BLK, 48, LOT, 35, PROJ, 4, ESCOPA, III, QUEZO...  46.3826 -63.0314   \n",
       "3076  [C, T, MASCARDO, ST, VILLA, MARIA, CLARA, PROJ...  41.6032 -73.0877   \n",
       "3097  [CAIRO, ST, STA, RITA, VILL, PROJ, 8, QUEZON, ...  30.0444  31.2357   \n",
       "3536  [ERVIE, BEN, NOBLEZA, 1009, AURORA, BLVD, PROJ...  54.9655 -5.12506   \n",
       "4461             [LUCENA, ST, PROJECT, 6, QUEZON, CITY]  13.9414  121.623   \n",
       "\n",
       "                                   add      key entry  \\\n",
       "307       Baguio, Benguet, Philippines  Project     8   \n",
       "1358                              None  Project     4   \n",
       "1626       05200 Arévalo, Ávila, Spain  Project     8   \n",
       "2835                Lot 35, PE, Canada  Project     4   \n",
       "3076                  Connecticut, USA  Project     4   \n",
       "3097   Cairo, Cairo Governorate, Egypt  Project     8   \n",
       "3536      Ervie, Stranraer DG9 0RB, UK  Project     3   \n",
       "4461  Lucena, 4301 Quezon, Philippines  Project     6   \n",
       "\n",
       "                                  pt   bgy  \n",
       "307   POINT (120.5960071 16.4023332)  None  \n",
       "1358                            None  None  \n",
       "1626    POINT (-4.7187424 41.058981)  None  \n",
       "2835  POINT (-63.0314308 46.3826063)  None  \n",
       "3076   POINT (-73.087749 41.6032207)  None  \n",
       "3097   POINT (31.2357116 30.0444196)  None  \n",
       "3536     POINT (-5.125062 54.965514)  None  \n",
       "4461  POINT (121.6234471 13.9413957)  None  "
      ]
     },
     "execution_count": 132,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fix.iloc[l,:][fix['key']=='Project']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 133,
   "metadata": {},
   "outputs": [],
   "source": [
    "counter = 0\n",
    "projs = ['Bahay Toro','Escopa I','Sangandaan','Escopa III','Milagrosa','Bahay Toro',\n",
    "         'Duyan Duyan','Project 6']\n",
    "for i in missProj:\n",
    "    fix['bgy'][i] = projs[counter]\n",
    "    counter += 1"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Checking for Roads"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 136,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/lorenzoflores/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:1: UserWarning: Boolean Series key will be reindexed to match DataFrame index.\n",
      "  \"\"\"Entry point for launching an IPython kernel.\n"
     ]
    }
   ],
   "source": [
    "missRoad = fix.iloc[l,:][fix['key']=='Road']\n",
    "missRoad = missRoad.index.tolist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 160,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/lorenzoflores/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:1: UserWarning: Boolean Series key will be reindexed to match DataFrame index.\n",
      "  \"\"\"Entry point for launching an IPython kernel.\n"
     ]
    },
    {
     "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>stripaddress</th>\n",
       "      <th>edit</th>\n",
       "      <th>lst</th>\n",
       "      <th>lat</th>\n",
       "      <th>lng</th>\n",
       "      <th>add</th>\n",
       "      <th>key</th>\n",
       "      <th>entry</th>\n",
       "      <th>pt</th>\n",
       "      <th>bgy</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>6103</td>\n",
       "      <td>VISAYAS EXTN PINGKIAN 3 ZONE 3 PASONG TAMO QUE...</td>\n",
       "      <td>VISAYAS EXTN PINGKIAN 3 ZONE 3 PASONG TAMO QUE...</td>\n",
       "      <td>[VISAYAS, EXTN, PINGKIAN, 3, ZONE, 3, PASONG, ...</td>\n",
       "      <td>11</td>\n",
       "      <td>123.5</td>\n",
       "      <td>Visayas, Philippines</td>\n",
       "      <td>Road</td>\n",
       "      <td>VISAYAS</td>\n",
       "      <td>POINT (123.5 11)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           stripaddress  \\\n",
       "6103  VISAYAS EXTN PINGKIAN 3 ZONE 3 PASONG TAMO QUE...   \n",
       "\n",
       "                                                   edit  \\\n",
       "6103  VISAYAS EXTN PINGKIAN 3 ZONE 3 PASONG TAMO QUE...   \n",
       "\n",
       "                                                    lst lat    lng  \\\n",
       "6103  [VISAYAS, EXTN, PINGKIAN, 3, ZONE, 3, PASONG, ...  11  123.5   \n",
       "\n",
       "                       add   key    entry                pt   bgy  \n",
       "6103  Visayas, Philippines  Road  VISAYAS  POINT (123.5 11)  None  "
      ]
     },
     "execution_count": 160,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fix.iloc[l,:][fix['key']=='Road'][70:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 159,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'UNIT 3D APT VERLAN SANTIAGO ST   PUTOL VISTA VERDE'"
      ]
     },
     "execution_count": 159,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fix.loc[5963,]['edit']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 161,
   "metadata": {},
   "outputs": [],
   "source": [
    "counter = 0\n",
    "roads = ['Payatas','Batasan Hills','Quirino 2B','Bagong Silangan','San Antonio',\n",
    "         'Batasan Hills','Sauyo','Duyan-Duyan','177','175',\n",
    "         '177','Batasan Hills','Santa Cruz','Payatas','Bago Bantay',\n",
    "         'Don Bosco','Kaunlaran','Santolan','Santolan','Camp Aguinaldo',\n",
    "         'Malanday','Gulod','Bagong Silangan','Bagong Silangan','Balintawak',\n",
    "         'Santo Nino','Santo Nino','Camp Aguinaldo','North Fairview','Libis',\n",
    "         'Central','North Fairview','Santa Cruz','North Fairview','Amihan',\n",
    "         'Holy Spirit','Westt Fairview','Kaligayahan','Greater Lagro','North Fairview',\n",
    "         'North Fairview','Tatalon','Central','Santa Cruz','Manresa',\n",
    "         'Quirino 3A','Llano','Bagbag','Payatas','Santa Lucia',\n",
    "         'Libis','North Fairview','Sangandaan','San Bartolome','Commonwealth',\n",
    "         'Nagkaisang Nayon','Batasan Hills','West Fairview','Batasan Hills','Batasan Hills',\n",
    "         'Roxas','Batasan Hills','Dona Imelda','Tandang Sora','Baesa',\n",
    "         '177','Santa Mesa Heights','Llano','Commonwealth','Lahug',\n",
    "         'Pasong Tamo'\n",
    "        ]\n",
    "for i in missRoad:\n",
    "    fix['bgy'][i] = roads[counter]\n",
    "    counter += 1"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Checking for Buildings"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 162,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/lorenzoflores/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:1: UserWarning: Boolean Series key will be reindexed to match DataFrame index.\n",
      "  \"\"\"Entry point for launching an IPython kernel.\n"
     ]
    }
   ],
   "source": [
    "missBuil = fix.iloc[l,:][fix['key']=='Building']\n",
    "missBuil = missBuil.index.tolist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 163,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/lorenzoflores/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:1: UserWarning: Boolean Series key will be reindexed to match DataFrame index.\n",
      "  \"\"\"Entry point for launching an IPython kernel.\n"
     ]
    },
    {
     "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>stripaddress</th>\n",
       "      <th>edit</th>\n",
       "      <th>lst</th>\n",
       "      <th>lat</th>\n",
       "      <th>lng</th>\n",
       "      <th>add</th>\n",
       "      <th>key</th>\n",
       "      <th>entry</th>\n",
       "      <th>pt</th>\n",
       "      <th>bgy</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>1042</td>\n",
       "      <td>216A WOODRIDGE BLDG SOFIA BELLEVUE MATANDANG B...</td>\n",
       "      <td>216A WOODRIDGE BLDG SOFIA BELLEVUE MATANDANG B...</td>\n",
       "      <td>[216A, WOODRIDGE, BLDG, SOFIA, BELLEVUE, MATAN...</td>\n",
       "      <td>41.747</td>\n",
       "      <td>-88.0503</td>\n",
       "      <td>Woodridge, IL, USA</td>\n",
       "      <td>Building</td>\n",
       "      <td>WOODRIDGE</td>\n",
       "      <td>POINT (-88.0503406 41.7469749)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5185</td>\n",
       "      <td>PINK CONDO TIERRA BELLA TANDANG SORA Q.C., N/A...</td>\n",
       "      <td>PINK CONDO TIERRA BELLA TANDANG SORA Q C   N/A...</td>\n",
       "      <td>[PINK, CONDO, TIERRA, BELLA, TANDANG, SORA, Q,...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Building</td>\n",
       "      <td>PINK</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5911</td>\n",
       "      <td>UNIT 10A BLDG 3 BLK 3 GOLDMINE INT NOVALICHES ...</td>\n",
       "      <td>UNIT 10A BLDG 3 BLK 3 GOLDMINE INT NOVALICHES ...</td>\n",
       "      <td>[UNIT, 10A, BLDG, 3, BLK, 3, GOLDMINE, INT, NO...</td>\n",
       "      <td>14.7625</td>\n",
       "      <td>121.031</td>\n",
       "      <td>Block 3, Caloocan, Metro Manila, Philippines</td>\n",
       "      <td>Building</td>\n",
       "      <td>10A</td>\n",
       "      <td>POINT (121.0307651 14.7625237)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5915</td>\n",
       "      <td>UNIT 114 APARTELLE BLDG QUIRINO HI WAY PASONG ...</td>\n",
       "      <td>UNIT 114 APARTELLE BLDG QUIRINO HI WAY PASONG ...</td>\n",
       "      <td>[UNIT, 114, APARTELLE, BLDG, QUIRINO, HI, WAY,...</td>\n",
       "      <td>14.8138</td>\n",
       "      <td>121.072</td>\n",
       "      <td>Quirino Hwy, San Jose del Monte City, Bulacan,...</td>\n",
       "      <td>Building</td>\n",
       "      <td>APARTELLE</td>\n",
       "      <td>POINT (121.0723104 14.8138076)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           stripaddress  \\\n",
       "1042  216A WOODRIDGE BLDG SOFIA BELLEVUE MATANDANG B...   \n",
       "5185  PINK CONDO TIERRA BELLA TANDANG SORA Q.C., N/A...   \n",
       "5911  UNIT 10A BLDG 3 BLK 3 GOLDMINE INT NOVALICHES ...   \n",
       "5915  UNIT 114 APARTELLE BLDG QUIRINO HI WAY PASONG ...   \n",
       "\n",
       "                                                   edit  \\\n",
       "1042  216A WOODRIDGE BLDG SOFIA BELLEVUE MATANDANG B...   \n",
       "5185  PINK CONDO TIERRA BELLA TANDANG SORA Q C   N/A...   \n",
       "5911  UNIT 10A BLDG 3 BLK 3 GOLDMINE INT NOVALICHES ...   \n",
       "5915  UNIT 114 APARTELLE BLDG QUIRINO HI WAY PASONG ...   \n",
       "\n",
       "                                                    lst      lat      lng  \\\n",
       "1042  [216A, WOODRIDGE, BLDG, SOFIA, BELLEVUE, MATAN...   41.747 -88.0503   \n",
       "5185  [PINK, CONDO, TIERRA, BELLA, TANDANG, SORA, Q,...     None     None   \n",
       "5911  [UNIT, 10A, BLDG, 3, BLK, 3, GOLDMINE, INT, NO...  14.7625  121.031   \n",
       "5915  [UNIT, 114, APARTELLE, BLDG, QUIRINO, HI, WAY,...  14.8138  121.072   \n",
       "\n",
       "                                                    add       key      entry  \\\n",
       "1042                                 Woodridge, IL, USA  Building  WOODRIDGE   \n",
       "5185                                               None  Building       PINK   \n",
       "5911       Block 3, Caloocan, Metro Manila, Philippines  Building        10A   \n",
       "5915  Quirino Hwy, San Jose del Monte City, Bulacan,...  Building  APARTELLE   \n",
       "\n",
       "                                  pt   bgy  \n",
       "1042  POINT (-88.0503406 41.7469749)  None  \n",
       "5185                            None  None  \n",
       "5911  POINT (121.0307651 14.7625237)  None  \n",
       "5915  POINT (121.0723104 14.8138076)  None  "
      ]
     },
     "execution_count": 163,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fix.iloc[l,:][fix['key']=='Building']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 165,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'UNIT 10A BLDG 3 BLK 3 GOLDMINE INT NOVALICHES NAGKAISANG NAYON QUEZON CITY'"
      ]
     },
     "execution_count": 165,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fix.loc[5911,]['edit']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 166,
   "metadata": {},
   "outputs": [],
   "source": [
    "counter = 0\n",
    "builds = ['Matandang Balara','Tandang Sora','Nagkaisang Nayon','Pasong Tamo'\n",
    "        ]\n",
    "for i in missBuil:\n",
    "    fix['bgy'][i] = builds[counter]\n",
    "    counter += 1"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Checking for Avenues"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 167,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/lorenzoflores/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:1: UserWarning: Boolean Series key will be reindexed to match DataFrame index.\n",
      "  \"\"\"Entry point for launching an IPython kernel.\n"
     ]
    }
   ],
   "source": [
    "missAves = fix.iloc[l,:][fix['key']=='Avenue']\n",
    "missAves = missAves.index.tolist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 168,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/lorenzoflores/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:1: UserWarning: Boolean Series key will be reindexed to match DataFrame index.\n",
      "  \"\"\"Entry point for launching an IPython kernel.\n"
     ]
    },
    {
     "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>stripaddress</th>\n",
       "      <th>edit</th>\n",
       "      <th>lst</th>\n",
       "      <th>lat</th>\n",
       "      <th>lng</th>\n",
       "      <th>add</th>\n",
       "      <th>key</th>\n",
       "      <th>entry</th>\n",
       "      <th>pt</th>\n",
       "      <th>bgy</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>939</td>\n",
       "      <td>19C NORTH DIVERSION ROAD UNANG SIGAW BALINTAWA...</td>\n",
       "      <td>19C NORTH DIVERSION ROAD UNANG SIGAW BALINTAWA...</td>\n",
       "      <td>[19C, NORTH, DIVERSION, ROAD, UNANG, SIGAW, BA...</td>\n",
       "      <td>14.725</td>\n",
       "      <td>120.984</td>\n",
       "      <td>19 E1, Valenzuela, 1447 Bulacan, Philippines</td>\n",
       "      <td>Avenue</td>\n",
       "      <td>DIVERSION</td>\n",
       "      <td>POINT (120.984126 14.725003)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4890</td>\n",
       "      <td>Ñ84-C ROAD 2 PAG-ASA QUEZON CITY</td>\n",
       "      <td>Ñ84-C ROAD 2 PAG-ASA QUEZON CITY</td>\n",
       "      <td>[Ñ84-C, ROAD, 2, PAG-ASA, QUEZON, CITY]</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Avenue</td>\n",
       "      <td>Ñ84-C</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           stripaddress  \\\n",
       "939   19C NORTH DIVERSION ROAD UNANG SIGAW BALINTAWA...   \n",
       "4890                   Ñ84-C ROAD 2 PAG-ASA QUEZON CITY   \n",
       "\n",
       "                                                   edit  \\\n",
       "939   19C NORTH DIVERSION ROAD UNANG SIGAW BALINTAWA...   \n",
       "4890                   Ñ84-C ROAD 2 PAG-ASA QUEZON CITY   \n",
       "\n",
       "                                                    lst     lat      lng  \\\n",
       "939   [19C, NORTH, DIVERSION, ROAD, UNANG, SIGAW, BA...  14.725  120.984   \n",
       "4890            [Ñ84-C, ROAD, 2, PAG-ASA, QUEZON, CITY]    None     None   \n",
       "\n",
       "                                               add     key      entry  \\\n",
       "939   19 E1, Valenzuela, 1447 Bulacan, Philippines  Avenue  DIVERSION   \n",
       "4890                                          None  Avenue      Ñ84-C   \n",
       "\n",
       "                                pt   bgy  \n",
       "939   POINT (120.984126 14.725003)  None  \n",
       "4890                          None  None  "
      ]
     },
     "execution_count": 168,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fix.iloc[l,:][fix['key']=='Avenue']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 170,
   "metadata": {},
   "outputs": [],
   "source": [
    "counter = 0\n",
    "aves = ['Balintawak','Bagong Pagasa'\n",
    "        ]\n",
    "for i in missAves:\n",
    "    fix['bgy'][i] = aves[counter]\n",
    "    counter += 1"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Everything Else"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Now we check for all those that still have not been classified, and do it super manually. We first update the list of missing entries 'l'."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 174,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>stripaddress</th>\n",
       "      <th>edit</th>\n",
       "      <th>lst</th>\n",
       "      <th>lat</th>\n",
       "      <th>lng</th>\n",
       "      <th>add</th>\n",
       "      <th>key</th>\n",
       "      <th>entry</th>\n",
       "      <th>pt</th>\n",
       "      <th>bgy</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>001 LEYTE GROUP 7 PAYATAS QUEZON CITY</td>\n",
       "      <td>001 LEYTE GROUP 7 PAYATAS QUEZON CITY</td>\n",
       "      <td>[001, LEYTE, GROUP, 7, PAYATAS, QUEZON, CITY]</td>\n",
       "      <td>11.3497</td>\n",
       "      <td>124.464</td>\n",
       "      <td>Leyte, Philippines</td>\n",
       "      <td>None</td>\n",
       "      <td>001 LEYTE GROUP 7 PAYATAS QUEZON CITY</td>\n",
       "      <td>POINT (124.4641848 11.3496551)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>93</td>\n",
       "      <td>079 GINUNTUANG LANDAS FOREST HILL SANTA MONICA...</td>\n",
       "      <td>079 GINUNTUANG LANDAS FOREST HILL SANTA MONICA...</td>\n",
       "      <td>[079, GINUNTUANG, LANDAS, FOREST, HILL, SANTA,...</td>\n",
       "      <td>50.4738</td>\n",
       "      <td>3.3009</td>\n",
       "      <td>59310 Landas, France</td>\n",
       "      <td>None</td>\n",
       "      <td>079 GINUNTUANG LANDAS FOREST HILL SANTA MONICA...</td>\n",
       "      <td>POINT (3.3008989 50.47381600000001)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>296</td>\n",
       "      <td>1141 SANTA RC</td>\n",
       "      <td>1141 SANTA RC</td>\n",
       "      <td>[1141, SANTA, RC]</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1141 SANTA RC</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>977</td>\n",
       "      <td>203 BLK 6 DAMAYANG LAGI QUEZON CITY NCR</td>\n",
       "      <td>203 BLK 6 DAMAYANG LAGI QUEZON CITY NCR</td>\n",
       "      <td>[203, BLK, 6, DAMAYANG, LAGI, QUEZON, CITY, NCR]</td>\n",
       "      <td>14.7628</td>\n",
       "      <td>121.031</td>\n",
       "      <td>Block 6, Caloocan, Metro Manila, Philippines</td>\n",
       "      <td>None</td>\n",
       "      <td>203 BLK 6 DAMAYANG LAGI QUEZON CITY NCR</td>\n",
       "      <td>POINT (121.0314158 14.7627947)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1187</td>\n",
       "      <td>27 NUPAX CMPD BAGBAG NOVALICHES QUEZON CITY</td>\n",
       "      <td>27 NUPAX CMPD BAGBAG NOVALICHES QUEZON CITY</td>\n",
       "      <td>[27, NUPAX, CMPD, BAGBAG, NOVALICHES, QUEZON, ...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>27 NUPAX CMPD BAGBAG NOVALICHES QUEZON CITY</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1375</td>\n",
       "      <td>373 QUIRINO HI WAY QUEZON CITY</td>\n",
       "      <td>373 QUIRINO HI WAY QUEZON CITY</td>\n",
       "      <td>[373, QUIRINO, HI, WAY, QUEZON, CITY]</td>\n",
       "      <td>14.8138</td>\n",
       "      <td>121.072</td>\n",
       "      <td>Quirino Hwy, San Jose del Monte City, Bulacan,...</td>\n",
       "      <td>None</td>\n",
       "      <td>373 QUIRINO HI WAY QUEZON CITY</td>\n",
       "      <td>POINT (121.0723104 14.8138076)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1650</td>\n",
       "      <td>607 GEN MALVAR BAGONG SILANGAN QUEZON CITY</td>\n",
       "      <td>607 GEN MALVAR BAGONG SILANGAN QUEZON CITY</td>\n",
       "      <td>[607, GEN, MALVAR, BAGONG, SILANGAN, QUEZON, C...</td>\n",
       "      <td>14.6962</td>\n",
       "      <td>121.11</td>\n",
       "      <td>607 Gen. Malvar, Quezon City, Metro Manila, Ph...</td>\n",
       "      <td>None</td>\n",
       "      <td>607 GEN MALVAR BAGONG SILANGAN QUEZON CITY</td>\n",
       "      <td>POINT (121.1104401 14.6961677)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1669</td>\n",
       "      <td>63 L-1 STO. NINO 1 CSJDM, BULACAN</td>\n",
       "      <td>63 L-1 STO  NINO 1 CSJDM  BULACAN</td>\n",
       "      <td>[63, L-1, STO, NINO, 1, CSJDM, BULACAN]</td>\n",
       "      <td>14.8575</td>\n",
       "      <td>121.066</td>\n",
       "      <td>Alley V, San Jose del Monte City, Bulacan, Phi...</td>\n",
       "      <td>None</td>\n",
       "      <td>63 L-1 STO NINO 1 CSJDM BULACAN</td>\n",
       "      <td>POINT (121.06586 14.85751)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2009</td>\n",
       "      <td>A SOUTH GATE BALARA PANSOL QUEZON CITY</td>\n",
       "      <td>A SOUTH GATE BALARA PANSOL QUEZON CITY</td>\n",
       "      <td>[A, SOUTH, GATE, BALARA, PANSOL, QUEZON, CITY]</td>\n",
       "      <td>33.9547</td>\n",
       "      <td>-118.212</td>\n",
       "      <td>South Gate, CA, USA</td>\n",
       "      <td>None</td>\n",
       "      <td>A SOUTH GATE BALARA PANSOL QUEZON CITY</td>\n",
       "      <td>POINT (-118.2120161 33.954737)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2176</td>\n",
       "      <td>AREA 06 SITIO CABUYAO SAUYO QC</td>\n",
       "      <td>AREA 06 SITIO CABUYAO SAUYO QC</td>\n",
       "      <td>[AREA, 06, SITIO, CABUYAO, SAUYO, QC]</td>\n",
       "      <td>14.2471</td>\n",
       "      <td>121.137</td>\n",
       "      <td>Cabuyao, Laguna, Philippines</td>\n",
       "      <td>None</td>\n",
       "      <td>AREA 06 SITIO CABUYAO SAUYO QC</td>\n",
       "      <td>POINT (121.1366715 14.2471423)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2313</td>\n",
       "      <td>B PAGASA QUEZON CITY</td>\n",
       "      <td>B PAGASA QUEZON CITY</td>\n",
       "      <td>[B, PAGASA, QUEZON, CITY]</td>\n",
       "      <td>14.569</td>\n",
       "      <td>121.128</td>\n",
       "      <td>B. Pag-asa, Taytay, Rizal, Philippines</td>\n",
       "      <td>None</td>\n",
       "      <td>B PAGASA QUEZON CITY</td>\n",
       "      <td>POINT (121.1282092 14.5689974)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2441</td>\n",
       "      <td>B58 L9 PH12 RIVERSIDE CALOOCAN CITY THIRD DIST.</td>\n",
       "      <td>B58 L9 PH12 RIVERSIDE CALOOCAN CITY THIRD DIST</td>\n",
       "      <td>[B58, L9, PH12, RIVERSIDE, CALOOCAN, CITY, THI...</td>\n",
       "      <td>33.9806</td>\n",
       "      <td>-117.375</td>\n",
       "      <td>Riverside, CA, USA</td>\n",
       "      <td>None</td>\n",
       "      <td>B58 L9 PH12 RIVERSIDE CALOOCAN CITY THIRD DIST</td>\n",
       "      <td>POINT (-117.3754942 33.9806005)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2445</td>\n",
       "      <td>B59 L41 GRANDRIVERSIDE.,PASCAM1, GENTRIAS,CAVITE</td>\n",
       "      <td>B59 L41 GRANDRIVERSIDE  PASCAM1  GENTRIAS CAVITE</td>\n",
       "      <td>[B59, L41, GRANDRIVERSIDE, PASCAM1, GENTRIAS, ...</td>\n",
       "      <td>14.3735</td>\n",
       "      <td>120.891</td>\n",
       "      <td>General Trias, Cavite, Philippines</td>\n",
       "      <td>None</td>\n",
       "      <td>B59 L41 GRANDRIVERSIDE PASCAM1 GENTRIAS CAVITE</td>\n",
       "      <td>POINT (120.8908015 14.3735271)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2614</td>\n",
       "      <td>BLK 1 L 15 GK ROQUE I PASONG TAMO QUEZON CITY</td>\n",
       "      <td>BLK 1 L 15 GK ROQUE I PASONG TAMO QUEZON CITY</td>\n",
       "      <td>[BLK, 1, L, 15, GK, ROQUE, I, PASONG, TAMO, QU...</td>\n",
       "      <td>12.6679</td>\n",
       "      <td>123.988</td>\n",
       "      <td>Pan-Philippine Hwy, Philippines</td>\n",
       "      <td>None</td>\n",
       "      <td>BLK 1 L 15 GK ROQUE I PASONG TAMO QUEZON CITY</td>\n",
       "      <td>POINT (123.9881642 12.6679167)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2715</td>\n",
       "      <td>BLK 2 LOT 9, TIERRA NOVA 2-C,, BAGUMBONG,, QUE...</td>\n",
       "      <td>BLK 2 LOT 9  TIERRA NOVA 2-C   BAGUMBONG   QUE...</td>\n",
       "      <td>[BLK, 2, LOT, 9, TIERRA, NOVA, 2-C, BAGUMBONG,...</td>\n",
       "      <td>14.7795</td>\n",
       "      <td>121.05</td>\n",
       "      <td>BLK 2, 2 Bagumbong Rd, Caloocan, Metro Manila,...</td>\n",
       "      <td>None</td>\n",
       "      <td>BLK 2 LOT 9 TIERRA NOVA 2-C BAGUMBONG QUEZON C...</td>\n",
       "      <td>POINT (121.0499246 14.779497)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2954</td>\n",
       "      <td>BLK64 LOT1 GREATER LAGRO QUEZON CITY NCR</td>\n",
       "      <td>BLK64 LOT1 GREATER LAGRO QUEZON CITY NCR</td>\n",
       "      <td>[BLK64, LOT1, GREATER, LAGRO, QUEZON, CITY, NCR]</td>\n",
       "      <td>15.4943</td>\n",
       "      <td>120.976</td>\n",
       "      <td>64 Pan-Philippine Hwy, Cabanatuan City, 3100 N...</td>\n",
       "      <td>None</td>\n",
       "      <td>BLK64 LOT1 GREATER LAGRO QUEZON CITY NCR</td>\n",
       "      <td>POINT (120.975776 15.494266)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2967</td>\n",
       "      <td>BLOCK 5 LOT 31 VILLA ESPANA 2 TATALON QUEZON C...</td>\n",
       "      <td>BLOCK 5 LOT 31 VILLA ESPANA 2 TATALON QUEZON C...</td>\n",
       "      <td>[BLOCK, 5, LOT, 31, VILLA, ESPANA, 2, TATALON,...</td>\n",
       "      <td>7.06447</td>\n",
       "      <td>125.613</td>\n",
       "      <td>2 Tatalon, Poblacion District, Quezon City, Me...</td>\n",
       "      <td>None</td>\n",
       "      <td>BLOCK 5 LOT 31 VILLA ESPANA 2 TATALON QUEZON C...</td>\n",
       "      <td>POINT (125.6130403 7.0644724)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2974</td>\n",
       "      <td>BLVD., KIDAPAWAN CITY COT</td>\n",
       "      <td>BLVD   KIDAPAWAN CITY COT</td>\n",
       "      <td>[BLVD, KIDAPAWAN, CITY, COT]</td>\n",
       "      <td>7.01061</td>\n",
       "      <td>125.091</td>\n",
       "      <td>Kidapawan City, Cotabato, Philippines</td>\n",
       "      <td>None</td>\n",
       "      <td>BLVD KIDAPAWAN CITY COT</td>\n",
       "      <td>POINT (125.0911341 7.010606999999999)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3121</td>\n",
       "      <td>CAMP SECURITY AND ESCORT UNIT OFFICE KIANGAN H...</td>\n",
       "      <td>CAMP SECURITY AND ESCORT UNIT OFFICE KIANGAN H...</td>\n",
       "      <td>[CAMP, SECURITY, AND, ESCORT, UNIT, OFFICE, KI...</td>\n",
       "      <td>16.7712</td>\n",
       "      <td>121.099</td>\n",
       "      <td>Kiangan, Ifugao, Philippines</td>\n",
       "      <td>None</td>\n",
       "      <td>CAMP SECURITY AND ESCORT UNIT OFFICE KIANGAN H...</td>\n",
       "      <td>POINT (121.0986722 16.7712337)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3966</td>\n",
       "      <td>JALAN BANDAROLO NO.39B PANDANG WEST SUMATRA IN...</td>\n",
       "      <td>JALAN BANDAROLO NO 39B PANDANG WEST SUMATRA IN...</td>\n",
       "      <td>[JALAN, BANDAROLO, NO, 39B, PANDANG, WEST, SUM...</td>\n",
       "      <td>-0.947083</td>\n",
       "      <td>100.417</td>\n",
       "      <td>Padang, Padang City, West Sumatra, Indonesia</td>\n",
       "      <td>None</td>\n",
       "      <td>JALAN BANDAROLO NO 39B PANDANG WEST SUMATRA IN...</td>\n",
       "      <td>POINT (100.417181 -0.9470831999999999)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3967</td>\n",
       "      <td>JAPAN</td>\n",
       "      <td>JAPAN</td>\n",
       "      <td>[JAPAN]</td>\n",
       "      <td>35.6601</td>\n",
       "      <td>139.736</td>\n",
       "      <td>5-chōme-15-5 Roppongi, Minato City, Tōkyō-to 1...</td>\n",
       "      <td>None</td>\n",
       "      <td>JAPAN</td>\n",
       "      <td>POINT (139.7355368 35.6600806)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4162</td>\n",
       "      <td>KIANGAN HALL CAMP CRAME QUEZON CITY</td>\n",
       "      <td>KIANGAN HALL CAMP CRAME QUEZON CITY</td>\n",
       "      <td>[KIANGAN, HALL, CAMP, CRAME, QUEZON, CITY]</td>\n",
       "      <td>16.7712</td>\n",
       "      <td>121.099</td>\n",
       "      <td>Kiangan, Ifugao, Philippines</td>\n",
       "      <td>None</td>\n",
       "      <td>KIANGAN HALL CAMP CRAME QUEZON CITY</td>\n",
       "      <td>POINT (121.0986722 16.7712337)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4376</td>\n",
       "      <td>LOT 1 BLK 3 UNION VILL BO BAGUMBONG NOVA. QUEZ...</td>\n",
       "      <td>LOT 1 BLK 3 UNION VILL BO BAGUMBONG NOVA  QUEZ...</td>\n",
       "      <td>[LOT, 1, BLK, 3, UNION, VILL, BO, BAGUMBONG, N...</td>\n",
       "      <td>14.7625</td>\n",
       "      <td>121.031</td>\n",
       "      <td>Lot 1 Block 3, Novaliches, Caloocan, Metro Man...</td>\n",
       "      <td>None</td>\n",
       "      <td>LOT 1 BLK 3 UNION VILL BO BAGUMBONG NOVA QUEZO...</td>\n",
       "      <td>POINT (121.0312738 14.7625154)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4429</td>\n",
       "      <td>LOT 99 LIBIS QUEZON CITY NCR</td>\n",
       "      <td>LOT 99 LIBIS QUEZON CITY NCR</td>\n",
       "      <td>[LOT, 99, LIBIS, QUEZON, CITY, NCR]</td>\n",
       "      <td>45.3926</td>\n",
       "      <td>-122.614</td>\n",
       "      <td>18125 SE McLoughlin Blvd, Portland, OR 97267, USA</td>\n",
       "      <td>None</td>\n",
       "      <td>LOT 99 LIBIS QUEZON CITY NCR</td>\n",
       "      <td>POINT (-122.6143937 45.3926291)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4692</td>\n",
       "      <td>MATIN-AO PRK. PAG-ASA, SILWAY 8,POL.SO.COT., N...</td>\n",
       "      <td>MATIN-AO PRK  PAG-ASA  SILWAY 8 POL SO COT   N...</td>\n",
       "      <td>[MATIN-AO, PRK, PAG-ASA, SILWAY, 8, POL, SO, C...</td>\n",
       "      <td>6.18313</td>\n",
       "      <td>125.077</td>\n",
       "      <td>Silway 8, Polomolok, South Cotabato, Philippines</td>\n",
       "      <td>None</td>\n",
       "      <td>MATIN-AO PRK PAG-ASA SILWAY 8 POL SO COT N/A N...</td>\n",
       "      <td>POINT (125.0773548 6.183125299999999)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4903</td>\n",
       "      <td>NAMAPA CMPD NORTH FAIRVIEW QUEZON CITY</td>\n",
       "      <td>NAMAPA CMPD NORTH FAIRVIEW QUEZON CITY</td>\n",
       "      <td>[NAMAPA, CMPD, NORTH, FAIRVIEW, QUEZON, CITY]</td>\n",
       "      <td>-13.7125</td>\n",
       "      <td>39.8322</td>\n",
       "      <td>Namapa, Mozambique</td>\n",
       "      <td>None</td>\n",
       "      <td>NAMAPA CMPD NORTH FAIRVIEW QUEZON CITY</td>\n",
       "      <td>POINT (39.8321879 -13.7124955)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4939</td>\n",
       "      <td>NIÑO KID. CITY</td>\n",
       "      <td>NIÑO KID  CITY</td>\n",
       "      <td>[NIÑO, KID, CITY]</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NIÑO KID CITY</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4940</td>\n",
       "      <td>NIÑO, KID. CITY</td>\n",
       "      <td>NIÑO  KID  CITY</td>\n",
       "      <td>[NIÑO, KID, CITY]</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NIÑO KID CITY</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5238</td>\n",
       "      <td>PRK 3, BALIGANG, CAMALIG ALBAY, QUEZON CITY , ...</td>\n",
       "      <td>PRK 3  BALIGANG  CAMALIG ALBAY  QUEZON CITY   ...</td>\n",
       "      <td>[PRK, 3, BALIGANG, CAMALIG, ALBAY, QUEZON, CIT...</td>\n",
       "      <td>13.1431</td>\n",
       "      <td>123.643</td>\n",
       "      <td>Baligang, Poblacion, Camalig, Albay, Philippines</td>\n",
       "      <td>None</td>\n",
       "      <td>PRK 3 BALIGANG CAMALIG ALBAY QUEZON CITY NATIO...</td>\n",
       "      <td>POINT (123.6427533 13.1430955)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5345</td>\n",
       "      <td>RIVERSIDE 1 DEL NACIA SAUYO QUEZON CITY</td>\n",
       "      <td>RIVERSIDE 1 DEL NACIA SAUYO QUEZON CITY</td>\n",
       "      <td>[RIVERSIDE, 1, DEL, NACIA, SAUYO, QUEZON, CITY]</td>\n",
       "      <td>33.9806</td>\n",
       "      <td>-117.375</td>\n",
       "      <td>Riverside, CA, USA</td>\n",
       "      <td>None</td>\n",
       "      <td>RIVERSIDE 1 DEL NACIA SAUYO QUEZON CITY</td>\n",
       "      <td>POINT (-117.3754942 33.9806005)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5644</td>\n",
       "      <td>SITIO PALANAS VASRA QUEZON CITY</td>\n",
       "      <td>SITIO PALANAS VASRA QUEZON CITY</td>\n",
       "      <td>[SITIO, PALANAS, VASRA, QUEZON, CITY]</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>SITIO PALANAS VASRA QUEZON CITY</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5645</td>\n",
       "      <td>SITIO PALANAS VASRA QUEZON CITY</td>\n",
       "      <td>SITIO PALANAS VASRA QUEZON CITY</td>\n",
       "      <td>[SITIO, PALANAS, VASRA, QUEZON, CITY]</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>SITIO PALANAS VASRA QUEZON CITY</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5672</td>\n",
       "      <td>SOUTH GATE 78-A PANSOL QUEZON CITY NCR</td>\n",
       "      <td>SOUTH GATE 78-A PANSOL QUEZON CITY NCR</td>\n",
       "      <td>[SOUTH, GATE, 78-A, PANSOL, QUEZON, CITY, NCR]</td>\n",
       "      <td>33.9547</td>\n",
       "      <td>-118.212</td>\n",
       "      <td>South Gate, CA, USA</td>\n",
       "      <td>None</td>\n",
       "      <td>SOUTH GATE 78-A PANSOL QUEZON CITY NCR</td>\n",
       "      <td>POINT (-118.2120161 33.954737)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5715</td>\n",
       "      <td>STA CLARA SAINT JAMES SUB NOVALICHES NAGKAISAN...</td>\n",
       "      <td>STA CLARA SAINT JAMES SUB NOVALICHES NAGKAISAN...</td>\n",
       "      <td>[STA, CLARA, SAINT, JAMES, SUB, NOVALICHES, NA...</td>\n",
       "      <td>37.3541</td>\n",
       "      <td>-121.955</td>\n",
       "      <td>Santa Clara, CA, USA</td>\n",
       "      <td>None</td>\n",
       "      <td>STA CLARA SAINT JAMES SUB NOVALICHES NAGKAISAN...</td>\n",
       "      <td>POINT (-121.9552356 37.3541079)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5740</td>\n",
       "      <td>STO NIÑO MULANAY QUEZON</td>\n",
       "      <td>STO NIÑO MULANAY QUEZON</td>\n",
       "      <td>[STO, NIÑO, MULANAY, QUEZON]</td>\n",
       "      <td>13.5461</td>\n",
       "      <td>122.371</td>\n",
       "      <td>Mulanay, Quezon, Philippines</td>\n",
       "      <td>None</td>\n",
       "      <td>STO NIÑO MULANAY QUEZON</td>\n",
       "      <td>POINT (122.3712253 13.5460809)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5753</td>\n",
       "      <td>STO TOMAS LIBIS BAGUMBAYAN QUEZON CITY</td>\n",
       "      <td>STO TOMAS LIBIS BAGUMBAYAN QUEZON CITY</td>\n",
       "      <td>[STO, TOMAS, LIBIS, BAGUMBAYAN, QUEZON, CITY]</td>\n",
       "      <td>14.1262</td>\n",
       "      <td>121.138</td>\n",
       "      <td>Santo Tomas, Batangas, Philippines</td>\n",
       "      <td>None</td>\n",
       "      <td>STO TOMAS LIBIS BAGUMBAYAN QUEZON CITY</td>\n",
       "      <td>POINT (121.1382576 14.1262406)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>6021</td>\n",
       "      <td>UNIT A202A EC PUEBLO 1 44 KING CHRISTIAN KINGS...</td>\n",
       "      <td>UNIT A202A EC PUEBLO 1 44 KING CHRISTIAN KINGS...</td>\n",
       "      <td>[UNIT, A202A, EC, PUEBLO, 1, 44, KING, CHRISTI...</td>\n",
       "      <td>38.2544</td>\n",
       "      <td>-104.609</td>\n",
       "      <td>Pueblo, CO, USA</td>\n",
       "      <td>None</td>\n",
       "      <td>UNIT A202A EC PUEBLO 1 44 KING CHRISTIAN KINGS...</td>\n",
       "      <td>POINT (-104.6091409 38.2544472)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>6106</td>\n",
       "      <td>VISTA HERMOSA , SAN MATEO RIZAL, SAN MATEO RIZ...</td>\n",
       "      <td>VISTA HERMOSA   SAN MATEO RIZAL  SAN MATEO RIZ...</td>\n",
       "      <td>[VISTA, HERMOSA, SAN, MATEO, RIZAL, SAN, MATEO...</td>\n",
       "      <td>14.6815</td>\n",
       "      <td>121.128</td>\n",
       "      <td>Dama De Noche, St, San Mateo, Rizal, Philippines</td>\n",
       "      <td>None</td>\n",
       "      <td>VISTA HERMOSA SAN MATEO RIZAL SAN MATEO RIZAL ...</td>\n",
       "      <td>POINT (121.1282969 14.6815423)</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           stripaddress  \\\n",
       "4                 001 LEYTE GROUP 7 PAYATAS QUEZON CITY   \n",
       "93    079 GINUNTUANG LANDAS FOREST HILL SANTA MONICA...   \n",
       "296                                       1141 SANTA RC   \n",
       "977             203 BLK 6 DAMAYANG LAGI QUEZON CITY NCR   \n",
       "1187        27 NUPAX CMPD BAGBAG NOVALICHES QUEZON CITY   \n",
       "1375                     373 QUIRINO HI WAY QUEZON CITY   \n",
       "1650         607 GEN MALVAR BAGONG SILANGAN QUEZON CITY   \n",
       "1669                  63 L-1 STO. NINO 1 CSJDM, BULACAN   \n",
       "2009             A SOUTH GATE BALARA PANSOL QUEZON CITY   \n",
       "2176                     AREA 06 SITIO CABUYAO SAUYO QC   \n",
       "2313                               B PAGASA QUEZON CITY   \n",
       "2441    B58 L9 PH12 RIVERSIDE CALOOCAN CITY THIRD DIST.   \n",
       "2445   B59 L41 GRANDRIVERSIDE.,PASCAM1, GENTRIAS,CAVITE   \n",
       "2614      BLK 1 L 15 GK ROQUE I PASONG TAMO QUEZON CITY   \n",
       "2715  BLK 2 LOT 9, TIERRA NOVA 2-C,, BAGUMBONG,, QUE...   \n",
       "2954           BLK64 LOT1 GREATER LAGRO QUEZON CITY NCR   \n",
       "2967  BLOCK 5 LOT 31 VILLA ESPANA 2 TATALON QUEZON C...   \n",
       "2974                          BLVD., KIDAPAWAN CITY COT   \n",
       "3121  CAMP SECURITY AND ESCORT UNIT OFFICE KIANGAN H...   \n",
       "3966  JALAN BANDAROLO NO.39B PANDANG WEST SUMATRA IN...   \n",
       "3967                                              JAPAN   \n",
       "4162                KIANGAN HALL CAMP CRAME QUEZON CITY   \n",
       "4376  LOT 1 BLK 3 UNION VILL BO BAGUMBONG NOVA. QUEZ...   \n",
       "4429                       LOT 99 LIBIS QUEZON CITY NCR   \n",
       "4692  MATIN-AO PRK. PAG-ASA, SILWAY 8,POL.SO.COT., N...   \n",
       "4903             NAMAPA CMPD NORTH FAIRVIEW QUEZON CITY   \n",
       "4939                                     NIÑO KID. CITY   \n",
       "4940                                    NIÑO, KID. CITY   \n",
       "5238  PRK 3, BALIGANG, CAMALIG ALBAY, QUEZON CITY , ...   \n",
       "5345            RIVERSIDE 1 DEL NACIA SAUYO QUEZON CITY   \n",
       "5644                    SITIO PALANAS VASRA QUEZON CITY   \n",
       "5645                    SITIO PALANAS VASRA QUEZON CITY   \n",
       "5672             SOUTH GATE 78-A PANSOL QUEZON CITY NCR   \n",
       "5715  STA CLARA SAINT JAMES SUB NOVALICHES NAGKAISAN...   \n",
       "5740                            STO NIÑO MULANAY QUEZON   \n",
       "5753             STO TOMAS LIBIS BAGUMBAYAN QUEZON CITY   \n",
       "6021  UNIT A202A EC PUEBLO 1 44 KING CHRISTIAN KINGS...   \n",
       "6106  VISTA HERMOSA , SAN MATEO RIZAL, SAN MATEO RIZ...   \n",
       "\n",
       "                                                   edit  \\\n",
       "4                 001 LEYTE GROUP 7 PAYATAS QUEZON CITY   \n",
       "93    079 GINUNTUANG LANDAS FOREST HILL SANTA MONICA...   \n",
       "296                                       1141 SANTA RC   \n",
       "977             203 BLK 6 DAMAYANG LAGI QUEZON CITY NCR   \n",
       "1187        27 NUPAX CMPD BAGBAG NOVALICHES QUEZON CITY   \n",
       "1375                     373 QUIRINO HI WAY QUEZON CITY   \n",
       "1650         607 GEN MALVAR BAGONG SILANGAN QUEZON CITY   \n",
       "1669                  63 L-1 STO  NINO 1 CSJDM  BULACAN   \n",
       "2009             A SOUTH GATE BALARA PANSOL QUEZON CITY   \n",
       "2176                     AREA 06 SITIO CABUYAO SAUYO QC   \n",
       "2313                               B PAGASA QUEZON CITY   \n",
       "2441    B58 L9 PH12 RIVERSIDE CALOOCAN CITY THIRD DIST    \n",
       "2445   B59 L41 GRANDRIVERSIDE  PASCAM1  GENTRIAS CAVITE   \n",
       "2614      BLK 1 L 15 GK ROQUE I PASONG TAMO QUEZON CITY   \n",
       "2715  BLK 2 LOT 9  TIERRA NOVA 2-C   BAGUMBONG   QUE...   \n",
       "2954           BLK64 LOT1 GREATER LAGRO QUEZON CITY NCR   \n",
       "2967  BLOCK 5 LOT 31 VILLA ESPANA 2 TATALON QUEZON C...   \n",
       "2974                          BLVD   KIDAPAWAN CITY COT   \n",
       "3121  CAMP SECURITY AND ESCORT UNIT OFFICE KIANGAN H...   \n",
       "3966  JALAN BANDAROLO NO 39B PANDANG WEST SUMATRA IN...   \n",
       "3967                                              JAPAN   \n",
       "4162                KIANGAN HALL CAMP CRAME QUEZON CITY   \n",
       "4376  LOT 1 BLK 3 UNION VILL BO BAGUMBONG NOVA  QUEZ...   \n",
       "4429                       LOT 99 LIBIS QUEZON CITY NCR   \n",
       "4692  MATIN-AO PRK  PAG-ASA  SILWAY 8 POL SO COT   N...   \n",
       "4903             NAMAPA CMPD NORTH FAIRVIEW QUEZON CITY   \n",
       "4939                                     NIÑO KID  CITY   \n",
       "4940                                    NIÑO  KID  CITY   \n",
       "5238  PRK 3  BALIGANG  CAMALIG ALBAY  QUEZON CITY   ...   \n",
       "5345            RIVERSIDE 1 DEL NACIA SAUYO QUEZON CITY   \n",
       "5644                    SITIO PALANAS VASRA QUEZON CITY   \n",
       "5645                    SITIO PALANAS VASRA QUEZON CITY   \n",
       "5672             SOUTH GATE 78-A PANSOL QUEZON CITY NCR   \n",
       "5715  STA CLARA SAINT JAMES SUB NOVALICHES NAGKAISAN...   \n",
       "5740                            STO NIÑO MULANAY QUEZON   \n",
       "5753             STO TOMAS LIBIS BAGUMBAYAN QUEZON CITY   \n",
       "6021  UNIT A202A EC PUEBLO 1 44 KING CHRISTIAN KINGS...   \n",
       "6106  VISTA HERMOSA   SAN MATEO RIZAL  SAN MATEO RIZ...   \n",
       "\n",
       "                                                    lst       lat      lng  \\\n",
       "4         [001, LEYTE, GROUP, 7, PAYATAS, QUEZON, CITY]   11.3497  124.464   \n",
       "93    [079, GINUNTUANG, LANDAS, FOREST, HILL, SANTA,...   50.4738   3.3009   \n",
       "296                                   [1141, SANTA, RC]      None     None   \n",
       "977    [203, BLK, 6, DAMAYANG, LAGI, QUEZON, CITY, NCR]   14.7628  121.031   \n",
       "1187  [27, NUPAX, CMPD, BAGBAG, NOVALICHES, QUEZON, ...      None     None   \n",
       "1375              [373, QUIRINO, HI, WAY, QUEZON, CITY]   14.8138  121.072   \n",
       "1650  [607, GEN, MALVAR, BAGONG, SILANGAN, QUEZON, C...   14.6962   121.11   \n",
       "1669            [63, L-1, STO, NINO, 1, CSJDM, BULACAN]   14.8575  121.066   \n",
       "2009     [A, SOUTH, GATE, BALARA, PANSOL, QUEZON, CITY]   33.9547 -118.212   \n",
       "2176              [AREA, 06, SITIO, CABUYAO, SAUYO, QC]   14.2471  121.137   \n",
       "2313                          [B, PAGASA, QUEZON, CITY]    14.569  121.128   \n",
       "2441  [B58, L9, PH12, RIVERSIDE, CALOOCAN, CITY, THI...   33.9806 -117.375   \n",
       "2445  [B59, L41, GRANDRIVERSIDE, PASCAM1, GENTRIAS, ...   14.3735  120.891   \n",
       "2614  [BLK, 1, L, 15, GK, ROQUE, I, PASONG, TAMO, QU...   12.6679  123.988   \n",
       "2715  [BLK, 2, LOT, 9, TIERRA, NOVA, 2-C, BAGUMBONG,...   14.7795   121.05   \n",
       "2954   [BLK64, LOT1, GREATER, LAGRO, QUEZON, CITY, NCR]   15.4943  120.976   \n",
       "2967  [BLOCK, 5, LOT, 31, VILLA, ESPANA, 2, TATALON,...   7.06447  125.613   \n",
       "2974                       [BLVD, KIDAPAWAN, CITY, COT]   7.01061  125.091   \n",
       "3121  [CAMP, SECURITY, AND, ESCORT, UNIT, OFFICE, KI...   16.7712  121.099   \n",
       "3966  [JALAN, BANDAROLO, NO, 39B, PANDANG, WEST, SUM... -0.947083  100.417   \n",
       "3967                                            [JAPAN]   35.6601  139.736   \n",
       "4162         [KIANGAN, HALL, CAMP, CRAME, QUEZON, CITY]   16.7712  121.099   \n",
       "4376  [LOT, 1, BLK, 3, UNION, VILL, BO, BAGUMBONG, N...   14.7625  121.031   \n",
       "4429                [LOT, 99, LIBIS, QUEZON, CITY, NCR]   45.3926 -122.614   \n",
       "4692  [MATIN-AO, PRK, PAG-ASA, SILWAY, 8, POL, SO, C...   6.18313  125.077   \n",
       "4903      [NAMAPA, CMPD, NORTH, FAIRVIEW, QUEZON, CITY]  -13.7125  39.8322   \n",
       "4939                                  [NIÑO, KID, CITY]      None     None   \n",
       "4940                                  [NIÑO, KID, CITY]      None     None   \n",
       "5238  [PRK, 3, BALIGANG, CAMALIG, ALBAY, QUEZON, CIT...   13.1431  123.643   \n",
       "5345    [RIVERSIDE, 1, DEL, NACIA, SAUYO, QUEZON, CITY]   33.9806 -117.375   \n",
       "5644              [SITIO, PALANAS, VASRA, QUEZON, CITY]      None     None   \n",
       "5645              [SITIO, PALANAS, VASRA, QUEZON, CITY]      None     None   \n",
       "5672     [SOUTH, GATE, 78-A, PANSOL, QUEZON, CITY, NCR]   33.9547 -118.212   \n",
       "5715  [STA, CLARA, SAINT, JAMES, SUB, NOVALICHES, NA...   37.3541 -121.955   \n",
       "5740                       [STO, NIÑO, MULANAY, QUEZON]   13.5461  122.371   \n",
       "5753      [STO, TOMAS, LIBIS, BAGUMBAYAN, QUEZON, CITY]   14.1262  121.138   \n",
       "6021  [UNIT, A202A, EC, PUEBLO, 1, 44, KING, CHRISTI...   38.2544 -104.609   \n",
       "6106  [VISTA, HERMOSA, SAN, MATEO, RIZAL, SAN, MATEO...   14.6815  121.128   \n",
       "\n",
       "                                                    add   key  \\\n",
       "4                                    Leyte, Philippines  None   \n",
       "93                                 59310 Landas, France  None   \n",
       "296                                                None  None   \n",
       "977        Block 6, Caloocan, Metro Manila, Philippines  None   \n",
       "1187                                               None  None   \n",
       "1375  Quirino Hwy, San Jose del Monte City, Bulacan,...  None   \n",
       "1650  607 Gen. Malvar, Quezon City, Metro Manila, Ph...  None   \n",
       "1669  Alley V, San Jose del Monte City, Bulacan, Phi...  None   \n",
       "2009                                South Gate, CA, USA  None   \n",
       "2176                       Cabuyao, Laguna, Philippines  None   \n",
       "2313             B. Pag-asa, Taytay, Rizal, Philippines  None   \n",
       "2441                                 Riverside, CA, USA  None   \n",
       "2445                 General Trias, Cavite, Philippines  None   \n",
       "2614                    Pan-Philippine Hwy, Philippines  None   \n",
       "2715  BLK 2, 2 Bagumbong Rd, Caloocan, Metro Manila,...  None   \n",
       "2954  64 Pan-Philippine Hwy, Cabanatuan City, 3100 N...  None   \n",
       "2967  2 Tatalon, Poblacion District, Quezon City, Me...  None   \n",
       "2974              Kidapawan City, Cotabato, Philippines  None   \n",
       "3121                       Kiangan, Ifugao, Philippines  None   \n",
       "3966       Padang, Padang City, West Sumatra, Indonesia  None   \n",
       "3967  5-chōme-15-5 Roppongi, Minato City, Tōkyō-to 1...  None   \n",
       "4162                       Kiangan, Ifugao, Philippines  None   \n",
       "4376  Lot 1 Block 3, Novaliches, Caloocan, Metro Man...  None   \n",
       "4429  18125 SE McLoughlin Blvd, Portland, OR 97267, USA  None   \n",
       "4692   Silway 8, Polomolok, South Cotabato, Philippines  None   \n",
       "4903                                 Namapa, Mozambique  None   \n",
       "4939                                               None  None   \n",
       "4940                                               None  None   \n",
       "5238   Baligang, Poblacion, Camalig, Albay, Philippines  None   \n",
       "5345                                 Riverside, CA, USA  None   \n",
       "5644                                               None  None   \n",
       "5645                                               None  None   \n",
       "5672                                South Gate, CA, USA  None   \n",
       "5715                               Santa Clara, CA, USA  None   \n",
       "5740                       Mulanay, Quezon, Philippines  None   \n",
       "5753                 Santo Tomas, Batangas, Philippines  None   \n",
       "6021                                    Pueblo, CO, USA  None   \n",
       "6106   Dama De Noche, St, San Mateo, Rizal, Philippines  None   \n",
       "\n",
       "                                                  entry  \\\n",
       "4                 001 LEYTE GROUP 7 PAYATAS QUEZON CITY   \n",
       "93    079 GINUNTUANG LANDAS FOREST HILL SANTA MONICA...   \n",
       "296                                       1141 SANTA RC   \n",
       "977             203 BLK 6 DAMAYANG LAGI QUEZON CITY NCR   \n",
       "1187        27 NUPAX CMPD BAGBAG NOVALICHES QUEZON CITY   \n",
       "1375                     373 QUIRINO HI WAY QUEZON CITY   \n",
       "1650         607 GEN MALVAR BAGONG SILANGAN QUEZON CITY   \n",
       "1669                    63 L-1 STO NINO 1 CSJDM BULACAN   \n",
       "2009             A SOUTH GATE BALARA PANSOL QUEZON CITY   \n",
       "2176                     AREA 06 SITIO CABUYAO SAUYO QC   \n",
       "2313                               B PAGASA QUEZON CITY   \n",
       "2441     B58 L9 PH12 RIVERSIDE CALOOCAN CITY THIRD DIST   \n",
       "2445     B59 L41 GRANDRIVERSIDE PASCAM1 GENTRIAS CAVITE   \n",
       "2614      BLK 1 L 15 GK ROQUE I PASONG TAMO QUEZON CITY   \n",
       "2715  BLK 2 LOT 9 TIERRA NOVA 2-C BAGUMBONG QUEZON C...   \n",
       "2954           BLK64 LOT1 GREATER LAGRO QUEZON CITY NCR   \n",
       "2967  BLOCK 5 LOT 31 VILLA ESPANA 2 TATALON QUEZON C...   \n",
       "2974                            BLVD KIDAPAWAN CITY COT   \n",
       "3121  CAMP SECURITY AND ESCORT UNIT OFFICE KIANGAN H...   \n",
       "3966  JALAN BANDAROLO NO 39B PANDANG WEST SUMATRA IN...   \n",
       "3967                                              JAPAN   \n",
       "4162                KIANGAN HALL CAMP CRAME QUEZON CITY   \n",
       "4376  LOT 1 BLK 3 UNION VILL BO BAGUMBONG NOVA QUEZO...   \n",
       "4429                       LOT 99 LIBIS QUEZON CITY NCR   \n",
       "4692  MATIN-AO PRK PAG-ASA SILWAY 8 POL SO COT N/A N...   \n",
       "4903             NAMAPA CMPD NORTH FAIRVIEW QUEZON CITY   \n",
       "4939                                      NIÑO KID CITY   \n",
       "4940                                      NIÑO KID CITY   \n",
       "5238  PRK 3 BALIGANG CAMALIG ALBAY QUEZON CITY NATIO...   \n",
       "5345            RIVERSIDE 1 DEL NACIA SAUYO QUEZON CITY   \n",
       "5644                    SITIO PALANAS VASRA QUEZON CITY   \n",
       "5645                    SITIO PALANAS VASRA QUEZON CITY   \n",
       "5672             SOUTH GATE 78-A PANSOL QUEZON CITY NCR   \n",
       "5715  STA CLARA SAINT JAMES SUB NOVALICHES NAGKAISAN...   \n",
       "5740                            STO NIÑO MULANAY QUEZON   \n",
       "5753             STO TOMAS LIBIS BAGUMBAYAN QUEZON CITY   \n",
       "6021  UNIT A202A EC PUEBLO 1 44 KING CHRISTIAN KINGS...   \n",
       "6106  VISTA HERMOSA SAN MATEO RIZAL SAN MATEO RIZAL ...   \n",
       "\n",
       "                                          pt   bgy  \n",
       "4             POINT (124.4641848 11.3496551)  None  \n",
       "93       POINT (3.3008989 50.47381600000001)  None  \n",
       "296                                     None  None  \n",
       "977           POINT (121.0314158 14.7627947)  None  \n",
       "1187                                    None  None  \n",
       "1375          POINT (121.0723104 14.8138076)  None  \n",
       "1650          POINT (121.1104401 14.6961677)  None  \n",
       "1669              POINT (121.06586 14.85751)  None  \n",
       "2009          POINT (-118.2120161 33.954737)  None  \n",
       "2176          POINT (121.1366715 14.2471423)  None  \n",
       "2313          POINT (121.1282092 14.5689974)  None  \n",
       "2441         POINT (-117.3754942 33.9806005)  None  \n",
       "2445          POINT (120.8908015 14.3735271)  None  \n",
       "2614          POINT (123.9881642 12.6679167)  None  \n",
       "2715           POINT (121.0499246 14.779497)  None  \n",
       "2954            POINT (120.975776 15.494266)  None  \n",
       "2967           POINT (125.6130403 7.0644724)  None  \n",
       "2974   POINT (125.0911341 7.010606999999999)  None  \n",
       "3121          POINT (121.0986722 16.7712337)  None  \n",
       "3966  POINT (100.417181 -0.9470831999999999)  None  \n",
       "3967          POINT (139.7355368 35.6600806)  None  \n",
       "4162          POINT (121.0986722 16.7712337)  None  \n",
       "4376          POINT (121.0312738 14.7625154)  None  \n",
       "4429         POINT (-122.6143937 45.3926291)  None  \n",
       "4692   POINT (125.0773548 6.183125299999999)  None  \n",
       "4903          POINT (39.8321879 -13.7124955)  None  \n",
       "4939                                    None  None  \n",
       "4940                                    None  None  \n",
       "5238          POINT (123.6427533 13.1430955)  None  \n",
       "5345         POINT (-117.3754942 33.9806005)  None  \n",
       "5644                                    None  None  \n",
       "5645                                    None  None  \n",
       "5672          POINT (-118.2120161 33.954737)  None  \n",
       "5715         POINT (-121.9552356 37.3541079)  None  \n",
       "5740          POINT (122.3712253 13.5460809)  None  \n",
       "5753          POINT (121.1382576 14.1262406)  None  \n",
       "6021         POINT (-104.6091409 38.2544472)  None  \n",
       "6106          POINT (121.1282969 14.6815423)  None  "
      ]
     },
     "execution_count": 174,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "l=[i for i,v in enumerate(fix['bgy']) if v == None]\n",
    "fix.iloc[l,:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 180,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'UNIT A202A EC PUEBLO 1 44 KING CHRISTIAN KINGSPOINT NOVALICHES BAGBAG QUEZON CITY'"
      ]
     },
     "execution_count": 180,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fix.loc[6021,]['edit']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 181,
   "metadata": {},
   "outputs": [],
   "source": [
    "counter = 0\n",
    "missings = ['Payatas','Santa Monica',None,'Damayang Lagi','Bagbag',\n",
    "            'Talipapa','Bagong Silangan',None,'Pansol','Sauyo',\n",
    "            'Bagong Pagasa','178','Pasong Camachile 1','Pasong Tamo','171',\n",
    "            'Greater Lagro','Tatalon',None,'Bagong Lipunan ng Crame',\n",
    "            None,None,'Bagong Lipunan ng Crame','171','Libis',\n",
    "            None,'North Fairview','None','None','Baligang',\n",
    "            'Sauyo','Vasra','Vasra','Pansol','Nagkaisang Nayon',\n",
    "            'Santo Nino','Libis','Bagbag','Bancom Subdivision'\n",
    "        ]\n",
    "for i in l:\n",
    "    fix['bgy'][i] = missings[counter]\n",
    "    counter += 1"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Remove all the words 'barangay' from the barangay names, update the initial dataframe called 'data', then output the final csv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 187,
   "metadata": {},
   "outputs": [],
   "source": [
    "import csv\n",
    "fix['bgy'] = [s.replace('Barangay','') if s is not None else None for s in fix['bgy'] ]\n",
    "data['Barangay'] = fix['bgy']\n",
    "data.to_csv('/Users/lorenzoflores/Desktop/Dengue_Quezon_City_Baranggays.csv')"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}