cleanup exploration.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "69e428c0-c0ff-4a84-9ecc-c3a4a89abb5c",
   "metadata": {},
   "outputs": [],
   "source": [
    "import json\n",
    "\n",
    "buildings = None\n",
    "\n",
    "with open('buildings.json') as f:\n",
    "    buildings = json.load(f)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "7da71e43-c911-4692-a661-44617547147b",
   "metadata": {},
   "outputs": [],
   "source": [
    "# tl;dr go through each of the entries\n",
    "# and create one with \"BUILDINGS\"\n",
    "collection_by_address = dict()\n",
    "\n",
    "def full_address(entry):\n",
    "    return (entry['BLK_NO'], entry['ROAD_NAME'], entry['POSTAL'])\n",
    "\n",
    "for b in buildings:\n",
    "    same_address = collection_by_address.setdefault(full_address(b), [])\n",
    "    same_address.append(b)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "4b949a1e-688a-478e-a5f1-b04deaee0923",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "([(('21', 'PARK STREET', '018925'),\n",
       "   ['DBS MARINA BAY MRT STATION',\n",
       "    'MARINA BAY MRT STATION',\n",
       "    'MARINA BAY MRT STATION (NS27)',\n",
       "    'OCBC MARINA BAY MRT',\n",
       "    'UOB MARINA BAY MRT STATION'])],\n",
       " 5985)"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "buildings_by_address = [\n",
    "    (k, [v['BUILDING'] for v in vs])\n",
    "    for k, vs in collection_by_address.items()\n",
    "]\n",
    "buildings_by_address[0]\n",
    "address_with_multiple_buildings = list(filter(lambda x: len(x[1]) > 1, buildings_by_address))\n",
    "address_with_multiple_buildings[0:1], len(address_with_multiple_buildings)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "cd253fc6-9b99-4829-82c6-83bcca0d2711",
   "metadata": {},
   "outputs": [],
   "source": [
    "from collections import Counter\n",
    "import re\n",
    "\n",
    "def transform(name):\n",
    "    name = re.sub('\\\\bMRT STATION', 'MRT', name)\n",
    "    name = re.sub('^THE\\\\b', '', name)\n",
    "    return name\n",
    "\n",
    "NAUGHTY_NAMES = [\n",
    "    '\\\\bKINDERGARTEN\\\\b',\n",
    "    '\\\\bPRESCHOOL\\\\b',\n",
    "    '^DBS\\\\b',\n",
    "    '^UOB\\\\b',\n",
    "    '^CITIBANK\\\\b',\n",
    "    '^OCBC\\\\b',\n",
    "    '^MAYBANK\\\\b',\n",
    "    '^STANDARD CHARTERED BANK\\\\b',\n",
    "    '\\\\bMONTESSORI\\\\b',\n",
    "    '\\\\bPTE\\\\b',\n",
    "    '\\\\bLTD\\\\b',\n",
    "    '\\\\bSKOOL\\\\b',\n",
    "    '\\\\bSTUDENT CARE\\\\b',\n",
    "    '\\\\bNASCANS\\\\b',\n",
    "    '\\\\bCHILD CARE CENTRE\\\\b',\n",
    "]\n",
    "\n",
    "def estimate_weight(name):\n",
    "    # If a building name ends with \"XX BUILDING\" it is probably the building name?\n",
    "    if re.search('\\\\bBUILDING$', name):\n",
    "        return 50\n",
    "    # Annoyingly, Onemap includes all the kindergartens\n",
    "    # and ATMs, *past and present*. Give these entries much less weight\n",
    "    if any([re.search(n, name) for n in NAUGHTY_NAMES]):\n",
    "        return 1\n",
    "    return 10\n",
    "\n",
    "\n",
    "def best_building_names(building_names):\n",
    "    ctr = Counter()\n",
    "\n",
    "    if len(building_names) <= 1:\n",
    "        return building_names\n",
    "\n",
    "    # Drop station IDs in \"STATION (EW1)\" --\n",
    "    # most ATM landmarks don't include the station ID, so the\n",
    "    # station ID prevents the station name from being selected as the\n",
    "    # most canonical entry\n",
    "    building_names = [\n",
    "        re.sub(' STATION \\\\([A-Z]{2}[0-9]{1,2}( / [A-Z]{2}[0-9]{1,2})*\\\\)$', ' STATION', name)\n",
    "        for name in building_names\n",
    "    ]\n",
    "    \n",
    "    # Try to find the most \"general\" building name, i.e.\n",
    "    # the name that can be embedded in most other names,\n",
    "    # after discounting \"THE\"\n",
    "    for s in building_names:\n",
    "        for t in building_names:\n",
    "            if transform(s) in t:\n",
    "                ctr.update({s: estimate_weight(s)})\n",
    "            elif transform(t) in s:\n",
    "                ctr.update({t: estimate_weight(t)})\n",
    "\n",
    "    # No embeddings...\n",
    "    if len(ctr) <= 1:\n",
    "        return building_names\n",
    "\n",
    "    # If tied, return all\n",
    "    top_two = ctr.most_common(2)\n",
    "    if top_two[1][1] == top_two[0][1]:\n",
    "        return sorted(building_names, key=lambda x: len(x))\n",
    "    else:\n",
    "        return [top_two[0][0]]\n",
    "\n",
    "def cleanup(n):\n",
    "    if 'NIL' in n:\n",
    "        return []\n",
    "    if 'MULTI STOREY CAR PARK' in n:\n",
    "        return []\n",
    "    if 'HDB PUBLIC SHELTERS' in n:\n",
    "        return []\n",
    "    if any([re.search('^HDB-', i) for i in n]):\n",
    "        return []\n",
    "    if any([re.search('MARKET (AND|&) (HAWKER|FOOD) CENTRE', i) for i in n]):\n",
    "        return []\n",
    "    # return n\n",
    "    return best_building_names(n)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "100c8203-3c34-45d7-8f2c-034e8a4681d0",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "([(('8', 'MARINA VIEW', '018960'),\n",
       "   ['DBS ASIA SQUARE',\n",
       "    'ASIA SQUARE TOWER 1',\n",
       "    'CONSULATE OF THE REPUBLIC OF SLOVENIA',\n",
       "    'CONSULATE OF SAINT VINCENT AND THE GRENADINES']),\n",
       "  (('12', 'MARINA VIEW', '018961'),\n",
       "   ['ASIA SQUARE TOWER 2', 'THE WESTIN SINGAPORE'])],\n",
       " 992)"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "buildings_by_address = [\n",
    "    (k, cleanup([v['BUILDING'] for v in vs]))\n",
    "    for k, vs in collection_by_address.items()\n",
    "]\n",
    "buildings_by_address[0]\n",
    "address_with_multiple_buildings = list(filter(lambda x: len(x[1]) > 1, buildings_by_address))\n",
    "address_with_multiple_buildings[0:2], len(address_with_multiple_buildings)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "fd21bb59-68e4-41a9-9edb-c39b92d3c16f",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Here, I tried fetching the list of ATMs from Onemap\n",
    "# and using that data to clean the Onemap postcode entries.\n",
    "# The effectiveness is only around 80% (500+ OCBC ATMs -> 100+ OCBC ATMs)\n",
    "import json\n",
    "\n",
    "ocbc = None\n",
    "\n",
    "with open('./ocbc-atms.json') as f:\n",
    "    ocbc = json.load(f)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "e5229853-bdfa-4d6d-92d3-b5eeb641fd34",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['OCBC 112 KATONG',\n",
       " 'OCBC 313@SOMERSET',\n",
       " 'OCBC 7-4 DEPTFORD ROAD',\n",
       " 'OCBC ADMIRALTY MRT STATION',\n",
       " 'OCBC ADMIRALTY PLACE',\n",
       " 'OCBC ALEXANDRA ROAD - FAIRPRICE',\n",
       " 'OCBC ALEXANDRA VILLAGE BRANCH',\n",
       " 'OCBC ALJUNIED AVENUE 2 - FAIRPRICE',\n",
       " 'OCBC ALJUNIED BRANCH',\n",
       " 'OCBC ALJUNIED MRT STATION',\n",
       " 'OCBC AMARA HOTEL - FAIRPRICE',\n",
       " 'OCBC AMK HUB',\n",
       " 'OCBC AMOY STREET FOOD CENTRE',\n",
       " 'OCBC ANG MO KIO AVENUE 1',\n",
       " 'OCBC ANG MO KIO AVENUE 1 - 7-ELEVEN',\n",
       " 'OCBC ANG MO KIO AVENUE 1 - FAIRPRICE',\n",
       " 'OCBC ANG MO KIO AVENUE 10',\n",
       " 'OCBC ANG MO KIO AVENUE 10 - 7-ELEVEN',\n",
       " 'OCBC ANG MO KIO AVENUE 10 - CHEERS',\n",
       " 'OCBC ANG MO KIO AVENUE 3',\n",
       " 'OCBC ANG MO KIO AVENUE 3 - ESSO STATION',\n",
       " 'OCBC ANG MO KIO AVENUE 6 - FAIRPRICE',\n",
       " 'OCBC ANG MO KIO AVENUE 8 - NANYANG POLYTECHNIC',\n",
       " 'OCBC ANG MO KIO BRANCH',\n",
       " 'OCBC ANG MO KIO BUS INTERCHANGE',\n",
       " 'OCBC ANG MO KIO CENTRAL',\n",
       " 'OCBC ANG MO KIO CENTRAL BRANCH',\n",
       " 'OCBC ANG MO KIO MRT STATION',\n",
       " 'OCBC ASIA SQUARE TOWER 1',\n",
       " 'OCBC BALESTIER BRANCH',\n",
       " 'OCBC BALESTIER ROAD - CALTEX STATION',\n",
       " 'OCBC BALESTIER ROAD - CHEERS',\n",
       " 'OCBC BANK OF SINGAPORE',\n",
       " 'OCBC BEACH ROAD - CALTEX STATION',\n",
       " 'OCBC BEAUTY WORLD MRT STATION',\n",
       " 'OCBC BEDOK BRANCH',\n",
       " 'OCBC BEDOK BUS INTERCHANGE',\n",
       " 'OCBC BEDOK BUS INTERCHANGE EHUB',\n",
       " 'OCBC BEDOK MALL - FAIRPRICE',\n",
       " 'OCBC BEDOK NORTH',\n",
       " 'OCBC BEDOK NORTH BRANCH',\n",
       " 'OCBC BEDOK NORTH STREET 1 - FAIRPRICE',\n",
       " 'OCBC BEDOK NORTH STREET 4 - FAIRPRICE',\n",
       " 'OCBC BEDOK RESERVOIR ROAD - 7-ELEVEN',\n",
       " 'OCBC BEDOK RESERVOIR ROAD - FAIRPRICE',\n",
       " 'OCBC BEDOK RESERVOIR ROAD - MCDONALDS',\n",
       " 'OCBC BENOI - FAIRPRICE',\n",
       " 'OCBC BIG BOX',\n",
       " 'OCBC BISHAN BRANCH',\n",
       " 'OCBC BISHAN MRT STATION',\n",
       " 'OCBC BISHAN STREET 11',\n",
       " 'OCBC BISHAN STREET 13 -FAIRPRICE',\n",
       " 'OCBC BISHAN STREET 22',\n",
       " 'OCBC BISHAN STREET 24 - FAIRPRICE',\n",
       " 'OCBC BOON KENG MRT STATION',\n",
       " 'OCBC BOON LAY BUS INTERCHANGE',\n",
       " 'OCBC BOON LAY MRT STATION',\n",
       " 'OCBC BOON LAY SHOPPING CENTRE',\n",
       " 'OCBC BOTANIC GARDENS MRT STATION',\n",
       " 'OCBC BRADDELL MRT STATION',\n",
       " 'OCBC BRAS BASAH COMPLEX',\n",
       " 'OCBC BRAS BASAH MRT STATION',\n",
       " 'OCBC BUANGKOK MRT STATION',\n",
       " 'OCBC BUGIS MRT STATION',\n",
       " 'OCBC BUGIS+',\n",
       " 'OCBC BUKIT BATOK BRANCH',\n",
       " 'OCBC BUKIT BATOK CENTRAL',\n",
       " 'OCBC BUKIT BATOK EAST AVE 3 - CALTEX STATION',\n",
       " 'OCBC BUKIT BATOK EAST AVENUE 3',\n",
       " 'OCBC BUKIT BATOK EAST AVENUE 3 - FAIRPRICE',\n",
       " 'OCBC BUKIT BATOK MRT STATION',\n",
       " 'OCBC BUKIT BATOK STREET 11 - CHEERS',\n",
       " 'OCBC BUKIT BATOK WEST AVE 7 - FAIRPRICE',\n",
       " 'OCBC BUKIT BATOK WEST AVE 8 - FAIRPRICE',\n",
       " 'OCBC BUKIT BATOK WEST AVENUE 6 - 7-ELEVEN',\n",
       " 'OCBC BUKIT BATOK WEST AVENUE 8',\n",
       " 'OCBC BUKIT GOMBAK MRT STATION',\n",
       " 'OCBC BUKIT MERAH CENTRAL - FAIRPRICE',\n",
       " 'OCBC BUKIT PANJANG BRANCH',\n",
       " 'OCBC BUKIT PANJANG MRT STATION',\n",
       " 'OCBC BUKIT PANJANG PLAZA',\n",
       " 'OCBC BUKIT PANJANG RING ROAD - 7-ELEVEN',\n",
       " 'OCBC BUKIT PANJANG RING ROAD - FAIRPRICE',\n",
       " 'OCBC BUKIT TIMAH BRANCH',\n",
       " 'OCBC BUKIT TIMAH PLAZA',\n",
       " 'OCBC BUKIT TIMAH ROAD - ESSO STATION',\n",
       " 'OCBC BUKIT TIMAH ROAD - FAIRPRICE',\n",
       " 'OCBC BUONA VISTA MRT STATION',\n",
       " 'OCBC BUONA VISTA MRT STATION (CIRCLE LINE)',\n",
       " 'OCBC CAMBRIDGE ROAD - FAIRPRICE',\n",
       " 'OCBC CANBERRA ROAD - FAIRPRICE',\n",
       " 'OCBC CAUSEWAY POINT BRANCH',\n",
       " 'OCBC CENTRE BRANCH',\n",
       " 'OCBC CENTURY SQUARE - FAIRPRICE',\n",
       " 'OCBC CHAI CHEE AVENUE - FAIRPRICE',\n",
       " 'OCBC CHAI CHEE ROAD - PRIME SUPERMARKET',\n",
       " 'OCBC CHANGI AIRPORT TERMINAL 1',\n",
       " 'OCBC CHANGI AIRPORT TERMINAL 2',\n",
       " 'OCBC CHANGI AIRPORT TERMINAL 3',\n",
       " 'OCBC CHANGI BUSINESS PARK - FAIRPRICE',\n",
       " 'OCBC CHANGI CITY POINT',\n",
       " 'OCBC CHANGI GENERAL HOSPITAL',\n",
       " 'OCBC CHANGI ROAD - 7-ELEVEN',\n",
       " 'OCBC CHANGI VILLAGE ROAD - 7-ELEVEN',\n",
       " 'OCBC CHEVRON HOUSE',\n",
       " 'OCBC CHINATOWN MRT STATION',\n",
       " 'OCBC CHINATOWN POINT - FAIRPRICE',\n",
       " 'OCBC CHINESE GARDEN MRT STATION',\n",
       " 'OCBC CHOA CHU KANG BRANCH',\n",
       " 'OCBC CHOA CHU KANG BUS INTERCHANGE',\n",
       " 'OCBC CHOA CHU KANG MRT STATION',\n",
       " 'OCBC CINELEISURE ORCHARD',\n",
       " 'OCBC CIRCUIT ROAD - FAIRPRICE',\n",
       " 'OCBC CITY HALL MRT STATION',\n",
       " 'OCBC CITY PLAZA',\n",
       " 'OCBC CITY SQUARE MALL',\n",
       " 'OCBC CITY SQUARE MALL BRANCH',\n",
       " 'OCBC CLARKE QUAY MRT STATION',\n",
       " 'OCBC CLEMENTI AVENUE 2 - FAIRPRICE',\n",
       " 'OCBC CLEMENTI AVENUE 3 - FAIRPRICE',\n",
       " 'OCBC CLEMENTI AVENUE 5',\n",
       " 'OCBC CLEMENTI BRANCH',\n",
       " 'OCBC CLEMENTI BUS INTERCHANGE',\n",
       " 'OCBC CLEMENTI MRT STATION',\n",
       " 'OCBC CLEMENTI ROAD - NGEE ANN POLYTECHNIC',\n",
       " 'OCBC CLEMENTI STREET 11 - 7-ELEVEN',\n",
       " 'OCBC CLEMENTI WEST STREET 2 - 7-ELEVEN',\n",
       " 'OCBC COLEMAN BRANCH',\n",
       " 'OCBC COMMONWEALTH MRT STATION',\n",
       " 'OCBC COMPASS ONE BRANCH',\n",
       " 'OCBC COMPASS POINT BRANCH',\n",
       " 'OCBC COMPASSVALE LINK - FAIRPRICE',\n",
       " 'OCBC DAKOTA MRT STATION',\n",
       " 'OCBC DAWSON PLACE',\n",
       " 'OCBC DEPOT HEIGHTS SHOPPING CENTRE',\n",
       " 'OCBC DHOBY GHAUT MRT STATION',\n",
       " 'OCBC DOVER CRESCENT - FAIRPRICE',\n",
       " 'OCBC DOVER MRT STATION',\n",
       " 'OCBC DOWNTOWN EAST',\n",
       " 'OCBC DUNEARN ROAD - CALTEX STATION',\n",
       " 'OCBC EAST COAST BRANCH',\n",
       " 'OCBC EAST COAST ROAD - 7-ELEVEN',\n",
       " 'OCBC EAST COAST ROAD - CALTEX STATION',\n",
       " 'OCBC EAST COAST ROAD - ESSO STATION',\n",
       " 'OCBC EAST COAST ROAD - FAIRPRICE',\n",
       " 'OCBC EASTPOINT MALL - FAIRPRICE',\n",
       " 'OCBC ENG HOON STREET - CHEERS',\n",
       " 'OCBC ESPLANADE MALL',\n",
       " 'OCBC ESPLANADE MRT STATION',\n",
       " 'OCBC EUNOS CRESCENT - 7-ELEVEN',\n",
       " 'OCBC EUNOS CRESCENT - FAIRPRICE',\n",
       " 'OCBC EUNOS MRT STATION',\n",
       " 'OCBC EXPO DRIVE - SINGAPORE EXPO',\n",
       " 'OCBC FAIRPRICE',\n",
       " 'OCBC FAJAR SHOPPING CENTRE',\n",
       " 'OCBC FAR EAST PLAZA',\n",
       " 'OCBC FOCH ROAD - CHEERS',\n",
       " 'OCBC FORTUNE CENTRE',\n",
       " 'OCBC FORUM THE SHOPPING MALL',\n",
       " 'OCBC FRANKEL - ESSO STATION',\n",
       " 'OCBC FRENCH ROAD - FAIRPRICE',\n",
       " 'OCBC GARDENS BY THE BAY - THE CANOPY',\n",
       " 'OCBC GEYLANG BAHRU',\n",
       " 'OCBC GEYLANG BRANCH',\n",
       " 'OCBC GEYLANG ROAD - 7-ELEVEN',\n",
       " 'OCBC GEYLANG ROAD - FAIRPRICE',\n",
       " 'OCBC GOLDEN MILE COMPLEX',\n",
       " 'OCBC GOLDEN MILE FOOD CENTRE',\n",
       " 'OCBC GREAT EASTERN CENTRE',\n",
       " 'OCBC GREAT WORLD CITY',\n",
       " 'OCBC GREENRIDGE SHOPPING CENTRE',\n",
       " 'OCBC GREENWICH V',\n",
       " 'OCBC GUARDIAN PHAMARCY',\n",
       " 'OCBC HARBOURFRONT BRANCH',\n",
       " 'OCBC HARBOURFRONT BUS INTERCHANGE',\n",
       " 'OCBC HARBOURFRONT MRT STATION',\n",
       " 'OCBC HARBOURFRONT MRT STATION (CIRCLE LINE)',\n",
       " 'OCBC HAVELOCK ROAD - FAIRPRICE',\n",
       " 'OCBC HAW PAR VILLA MRT STATION',\n",
       " 'OCBC HEARTLAND MALL',\n",
       " 'OCBC HILLION MALL - FAIRPRICE',\n",
       " 'OCBC HOLLAND DRIVE - FAIRPRICE',\n",
       " 'OCBC HOLLAND ROAD - CALTEX STATION',\n",
       " 'OCBC HOLLAND VILLAGE BRANCH',\n",
       " 'OCBC HOLLAND VILLAGE MRT STATION',\n",
       " 'OCBC HOUGANG AVENUE 1 - 7-ELEVEN',\n",
       " 'OCBC HOUGANG AVENUE 10 - FAIRPRICE',\n",
       " 'OCBC HOUGANG AVENUE 3 - CHEERS',\n",
       " 'OCBC HOUGANG AVENUE 4 - FAIRPRICE',\n",
       " 'OCBC HOUGANG AVENUE 8 - CHEERS',\n",
       " 'OCBC HOUGANG BRANCH',\n",
       " 'OCBC HOUGANG CAPEVIEW - FAIRPRICE',\n",
       " 'OCBC HOUGANG CENTRAL - CHEERS',\n",
       " 'OCBC HOUGANG GREEN SHOPPING MALL',\n",
       " 'OCBC HOUGANG MALL BRANCH',\n",
       " 'OCBC HOUGANG MRT STATION',\n",
       " 'OCBC HOUGANG STREET 21 - FAIRPRICE',\n",
       " 'OCBC HOUGANG STREET 61',\n",
       " 'OCBC HOUGANG STREET 91 - FAIRPRICE',\n",
       " 'OCBC IKEA BUILDING',\n",
       " 'OCBC IMM BUILDING',\n",
       " 'OCBC INTERNATIONAL PLAZA',\n",
       " 'OCBC ION ORCHARD',\n",
       " 'OCBC ION ORCHARD BRANCH',\n",
       " 'OCBC JALAN BESAR BRANCH',\n",
       " 'OCBC JALAN BUKIT MERAH - FAIRPRICE',\n",
       " 'OCBC JALAN KAYU - FAIRPRICE',\n",
       " 'OCBC JALAN SULTAN BRANCH',\n",
       " 'OCBC JALAN TIGA - FAIRPRICE',\n",
       " 'OCBC JCUBE - FAIRPRICE',\n",
       " 'OCBC JELITA SHOPPING CENTRE',\n",
       " 'OCBC JEM',\n",
       " 'OCBC JOO CHIAT BRANCH',\n",
       " 'OCBC JOO CHIAT ROAD - FAIRPRICE',\n",
       " 'OCBC JOO KOON BUS INTERCHANGE',\n",
       " 'OCBC JOO KOON MRT STATION',\n",
       " 'OCBC JUNCTION 8 SHOPPING CENTRE',\n",
       " 'OCBC JURONG BRANCH',\n",
       " 'OCBC JURONG EAST BRANCH',\n",
       " 'OCBC JURONG EAST MRT STATION',\n",
       " 'OCBC JURONG EAST STREET 24 - 7-ELEVEN',\n",
       " 'OCBC JURONG EAST STREET 24 - FAIRPRICE',\n",
       " 'OCBC JURONG EAST STREET 31 - FAIRPRICE',\n",
       " 'OCBC JURONG EAST TEMPORARY BUS INTERCHANGE',\n",
       " 'OCBC JURONG GATEWAY ROAD - 7-ELEVEN',\n",
       " 'OCBC JURONG GATEWAY ROAD - FAIRPRICE',\n",
       " 'OCBC JURONG POINT BRANCH',\n",
       " 'OCBC JURONG POINT SHOPPING CENTRE',\n",
       " 'OCBC JURONG WEST BRANCH',\n",
       " 'OCBC JURONG WEST ST 92',\n",
       " 'OCBC JURONG WEST ST 93 - CALTEX STATION',\n",
       " 'OCBC JURONG WEST STREET 41',\n",
       " 'OCBC JURONG WEST STREET 41 - FAIRPRICE',\n",
       " 'OCBC JURONG WEST STREET 51 - 7-ELEVEN',\n",
       " 'OCBC JURONG WEST STREET 75 - PRIME SUPERMARKET',\n",
       " 'OCBC JURONG WEST STREET 91',\n",
       " 'OCBC KALLANG BAHRU - FAIRPRICE',\n",
       " 'OCBC KALLANG BRANCH',\n",
       " 'OCBC KALLANG WAVE',\n",
       " 'OCBC KALLANG WAVE BRANCH',\n",
       " 'OCBC KATONG BRANCH',\n",
       " 'OCBC KATONG V - FAIRPRICE',\n",
       " 'OCBC KEMBANGAN MRT STATION',\n",
       " 'OCBC KENSINGTON PARK - 7-ELEVEN',\n",
       " 'OCBC KENT RIDGE MRT STATION',\n",
       " 'OCBC KHATIB BRANCH',\n",
       " 'OCBC KHATIB MRT STATION',\n",
       " 'OCBC KILLINEY ROAD - FAIRPRICE',\n",
       " 'OCBC KIM KEAT AVENUE',\n",
       " 'OCBC KIM TIAN ROAD - FAIRPRICE',\n",
       " \"OCBC KK WOMEN'S AND CHILDREN'S HOSPITAL\",\n",
       " 'OCBC KOVAN MRT STATION',\n",
       " 'OCBC KRANJI MRT STATION',\n",
       " 'OCBC LAKESIDE MRT STATION',\n",
       " 'OCBC LAVENDER MRT STATION',\n",
       " 'OCBC LAVENDER STREET - ESSO STATION',\n",
       " 'OCBC LENGKOK BAHRU - FAIRPRICE',\n",
       " 'OCBC LENGKONG TIGA - FAIRPRICE',\n",
       " 'OCBC LIANG COURT SHOPPING CENTRE',\n",
       " 'OCBC LIMBANG SHOPPING CENTRE',\n",
       " 'OCBC LITTLE INDIA ARCADE - 7-ELEVEN',\n",
       " 'OCBC LITTLE INDIA MRT STATION',\n",
       " 'OCBC LORONG CHUAN - CALTEX STATION',\n",
       " 'OCBC LORONG CHUAN - ESSO STATION',\n",
       " 'OCBC LORONG CHUAN MRT STATION',\n",
       " 'OCBC LORONG LIMAU - FAIRPRICE',\n",
       " 'OCBC LORONG MOMBONG - 7-ELEVEN',\n",
       " 'OCBC LOT 1 SHOPPERS MALL',\n",
       " 'OCBC LOYANG POINT',\n",
       " 'OCBC LUCKY PLAZA',\n",
       " 'OCBC MACPHERSON MALL - FAIRPRICE',\n",
       " 'OCBC MACPHERSON MRT STATION',\n",
       " 'OCBC MACPHERSON ROAD - CALTEX STATION',\n",
       " 'OCBC MAPLETREE 18 - FAIRPRICE',\n",
       " 'OCBC MARINA BAY FINANCIAL CENTRE BRANCH',\n",
       " 'OCBC MARINA BAY MRT STATION',\n",
       " 'OCBC MARINA BAY SANDS',\n",
       " 'OCBC MARINA SQUARE',\n",
       " 'OCBC MARINE PARADE CENTRAL',\n",
       " 'OCBC MARINE PARADE CENTRAL - FAIRPRICE',\n",
       " 'OCBC MARINE PARADE EHUB',\n",
       " 'OCBC MARITIME SQUARE',\n",
       " 'OCBC MARSILING LANE',\n",
       " 'OCBC MARYMOUNT MRT STATION',\n",
       " 'OCBC MAXWELL HAWKER CENTRE',\n",
       " 'OCBC MINDEF - BUKIT BATOK CAMP',\n",
       " 'OCBC MINDEF - DEPOT ROAD CAMP',\n",
       " 'OCBC MOUNT ALVERNIA HOSPITAL',\n",
       " 'OCBC MOUNT ELIZABETH MEDICAL CENTRE',\n",
       " 'OCBC MOUNTBATTEN MRT STATION',\n",
       " 'OCBC MOUNTBATTEN SQUARE',\n",
       " 'OCBC NANYANG TECHNOLOGICAL UNIVERSITY',\n",
       " 'OCBC NATIONAL UNIVERSITY HOSPITAL',\n",
       " 'OCBC NATIONAL UNIVERSITY OF SINGAPORE',\n",
       " 'OCBC NEW BRIDGE CENTRE',\n",
       " 'OCBC NEW BRIDGE ROAD - CHEERS',\n",
       " 'OCBC NEW UPPER CHANGI ROAD',\n",
       " 'OCBC NEW UPPER CHANGI ROAD - FAIRPRICE',\n",
       " 'OCBC NEW WORLD CENTRE',\n",
       " 'OCBC NEWTON FOOD CENTRE',\n",
       " 'OCBC NEWTON MRT STATION',\n",
       " 'OCBC NEX',\n",
       " 'OCBC NEX BRANCH',\n",
       " 'OCBC NG TENG FONG HOSPITAL',\n",
       " 'OCBC NGEE ANN CITY',\n",
       " 'OCBC NICOLL HIGHWAY MRT STATION',\n",
       " 'OCBC NORTH BRANCH',\n",
       " 'OCBC NORTHPOINT',\n",
       " 'OCBC NORTHPOINT BRANCH',\n",
       " 'OCBC NOVENA MRT STATION',\n",
       " 'OCBC NTU BRANCH',\n",
       " 'OCBC NTU FRANK STORE',\n",
       " 'OCBC NUH - FAIRPRICE',\n",
       " 'OCBC NUS',\n",
       " 'OCBC NUS FRANK STORE',\n",
       " 'OCBC NUS UNIVERSITY TOWN - CHEERS',\n",
       " 'OCBC ONAN ROAD - CHEERS',\n",
       " 'OCBC ONE-NORTH MRT STATION',\n",
       " 'OCBC ORCHARD MRT STATION',\n",
       " 'OCBC ORCHARD POINT BRANCH',\n",
       " 'OCBC ORCHARDGATEWAY',\n",
       " 'OCBC ORCHARDGATEWAY BRANCH',\n",
       " 'OCBC ORCHID COUNTRY CLUB - FAIRPRICE',\n",
       " 'OCBC OUR TAMPINES HUB - FAIRPRICE',\n",
       " 'OCBC OUTRAM PARK MRT STATION (NEL)',\n",
       " 'OCBC PARAGON',\n",
       " 'OCBC PARCO BUGIS JUNCTION',\n",
       " 'OCBC PARKLANE SHOPPING MALL',\n",
       " 'OCBC PARKWAY PARADE',\n",
       " 'OCBC PASIR RIS BUS INTERCHANGE',\n",
       " 'OCBC PASIR RIS DRIVE 4 - GIANT',\n",
       " 'OCBC PASIR RIS DRIVE 6 - 7-ELEVEN',\n",
       " 'OCBC PASIR RIS MRT STATION',\n",
       " 'OCBC PASIR RIS WEST PLAZA',\n",
       " 'OCBC PASIR RIS WEST PLAZA - FAIRPRICE',\n",
       " 'OCBC PAYA LEBAR MRT STATION',\n",
       " 'OCBC PAYA LEBAR MRT STATION (CIRCLE LINE)',\n",
       " 'OCBC PAYA LEBAR SQUARE',\n",
       " 'OCBC PENINSULA PLAZA',\n",
       " \"OCBC PEOPLE'S PARK CENTRE\",\n",
       " \"OCBC PEOPLE'S PARK COMPLEX\",\n",
       " 'OCBC PEOPLES PARK BRANCH',\n",
       " 'OCBC PEOPLES PARK FOOD CENTRE',\n",
       " 'OCBC PIONEER MALL',\n",
       " 'OCBC PIONEER MRT STATION',\n",
       " 'OCBC PIONEER ROAD - ESSO STATION',\n",
       " 'OCBC PLAZA SINGAPURA',\n",
       " 'OCBC POTONG PASIR - FAIRPRICE',\n",
       " 'OCBC POTONG PASIR MRT STATION',\n",
       " 'OCBC PROMENADE MRT STATION',\n",
       " 'OCBC PUNGGOL BUS INTERCHANGE',\n",
       " 'OCBC PUNGGOL DRIVE - FAIRPRICE',\n",
       " 'OCBC PUNGGOL FIELD',\n",
       " 'OCBC PUNGGOL MRT STATION',\n",
       " 'OCBC PUNGGOL PLAZA',\n",
       " 'OCBC PUNGGOL PLAZA BRANCH',\n",
       " 'OCBC PUNGGOL WATERWAY TERRACE - FAIRPRICE',\n",
       " 'OCBC QUEENSTOWN MRT STATION',\n",
       " 'OCBC QUEENSWAY SHOPPING CENTRE',\n",
       " 'OCBC RAFFLES CITY SHOPPING CENTRE',\n",
       " 'OCBC RAFFLES PLACE MRT STATION',\n",
       " 'OCBC REPUBLIC POLYTECHNIC',\n",
       " 'OCBC RESORTS WORLD AT SENTOSA',\n",
       " 'OCBC RIVER VALLEY ROAD - 7-ELEVEN',\n",
       " 'OCBC RIVER VALLEY ROAD - FAIRPRICE',\n",
       " 'OCBC RIVERVALE MALL',\n",
       " 'OCBC RIVERVALE PLAZA',\n",
       " 'OCBC ROBINSON ROAD BRANCH',\n",
       " 'OCBC ROCHOR MRT STATION',\n",
       " 'OCBC SCOTTS SQUARE',\n",
       " 'OCBC SELETAR MALL - FAIRPRICE',\n",
       " 'OCBC SEMBAWANG MRT STATION',\n",
       " 'OCBC SEMBAWANG SHOPPING CENTRE',\n",
       " 'OCBC SEMBAWANG WAY - FAIRPRICE',\n",
       " 'OCBC SENG POH ROAD - 7-ELEVEN',\n",
       " 'OCBC SENGKANG BUS INTERCHANGE',\n",
       " 'OCBC SENGKANG EAST AVE - FAIRPRICE',\n",
       " 'OCBC SENGKANG MRT STATION',\n",
       " 'OCBC SENGKANG SQUARE - KOPITIAM SQUARE',\n",
       " 'OCBC SENJA ROAD - FAIRPRICE',\n",
       " 'OCBC SENTOSA',\n",
       " 'OCBC SENTOSA COVE',\n",
       " 'OCBC SERANGOON AVENUE 3 - 7-ELEVEN',\n",
       " 'OCBC SERANGOON BUS INTERCHANGE',\n",
       " 'OCBC SERANGOON CENTRAL DRIVE - FAIRPRICE',\n",
       " 'OCBC SERANGOON GARDEN BRANCH',\n",
       " 'OCBC SERANGOON MRT STATION',\n",
       " 'OCBC SERANGOON NORTH AVENUE 1 - FAIRPRICE',\n",
       " 'OCBC SERANGOON NORTH AVENUE 5 - SHENG SIONG',\n",
       " 'OCBC SERANGOON ROAD - 7-ELEVEN',\n",
       " 'OCBC SHAW CENTRE',\n",
       " 'OCBC SHAW PLAZA - TWIN HEIGHTS',\n",
       " 'OCBC SHUN LI INDUSTRIAL PARK',\n",
       " 'OCBC SILAT AVE - FAIRPRICE',\n",
       " 'OCBC SIM LIM SQUARE',\n",
       " 'OCBC SIM LIM TOWER',\n",
       " 'OCBC SIMEI MRT STATION',\n",
       " 'OCBC SIMEI STREET 3',\n",
       " 'OCBC SIMS PLACE',\n",
       " 'OCBC SINGAPORE GENERAL HOSPITAL',\n",
       " 'OCBC SINGAPORE INSTITUTE OF MANAGEMENT',\n",
       " 'OCBC SINGAPORE POLYTECHNIC',\n",
       " 'OCBC SINGAPORE POLYTECHNIC BRANCH (FRANK)',\n",
       " 'OCBC SINGAPORE POLYTECHNIC FRANK STORE',\n",
       " 'OCBC SINGAPORE PRESS HOLDINGS',\n",
       " 'OCBC SINGAPORE UNIVERSITY OF TECHNOLOGY AND DESIGN',\n",
       " 'OCBC SIXTH AVENUE - 7-ELEVEN',\n",
       " 'OCBC SIXTH AVENUE BRANCH',\n",
       " 'OCBC SMU BRANCH',\n",
       " 'OCBC SOMERSET MRT STATION EHUB',\n",
       " 'OCBC SOUTH BRIDGE ROAD - FOOK HAI BUILDING',\n",
       " 'OCBC SOUTH WOODLANDS DRIVE - FAIRPRICE',\n",
       " 'OCBC SQUARE 2 - FAIRPRICE',\n",
       " 'OCBC STADIUM STATION',\n",
       " 'OCBC STAMFORD ROAD - CHEERS',\n",
       " 'OCBC STIRLING ROAD - FAIRPRICE',\n",
       " 'OCBC SUN PLAZA - FAIRPRICE',\n",
       " 'OCBC SUN PLAZA BRANCH',\n",
       " 'OCBC SUNSHINE PLACE',\n",
       " 'OCBC SUNTEC CITY',\n",
       " 'OCBC SUNTEC CITY BRANCH',\n",
       " 'OCBC TAI SENG MRT STATION',\n",
       " 'OCBC TAMAN JURONG SHOPPING CENTRE',\n",
       " 'OCBC TAMPINES 1',\n",
       " 'OCBC TAMPINES AVE 8 - CALTEX STATION',\n",
       " 'OCBC TAMPINES AVENUE 1 - CHEERS',\n",
       " 'OCBC TAMPINES BRANCH',\n",
       " 'OCBC TAMPINES BUS INTERCHANGE',\n",
       " 'OCBC TAMPINES CENTRAL 1',\n",
       " 'OCBC TAMPINES CENTRAL COMMUNITY CENTRE',\n",
       " 'OCBC TAMPINES CENTRE TWO',\n",
       " 'OCBC TAMPINES MALL',\n",
       " 'OCBC TAMPINES MART',\n",
       " 'OCBC TAMPINES MRT STATION',\n",
       " 'OCBC TAMPINES SOUTH BRANCH',\n",
       " 'OCBC TAMPINES STREET 11 - 7-ELEVEN',\n",
       " 'OCBC TAMPINES STREET 11 - FAIRPRICE',\n",
       " 'OCBC TAMPINES STREET 21',\n",
       " 'OCBC TAMPINES STREET 44',\n",
       " 'OCBC TAMPINES STREET 81 - PRIME SUPERMARKET',\n",
       " 'OCBC TAN TOCK SENG HOSPITAL',\n",
       " 'OCBC TANAH MERAH FERRY TERMINAL',\n",
       " 'OCBC TANAH MERAH MRT STATION',\n",
       " 'OCBC TANG PLAZA',\n",
       " 'OCBC TANGJONG PAGAR PLAZA',\n",
       " 'OCBC TANGLIN MALL',\n",
       " 'OCBC TANJONG KATONG ROAD - 7-ELEVEN',\n",
       " 'OCBC TANJONG PAGAR MRT STATION',\n",
       " 'OCBC TANJONG PAGAR PLAZA - 7-ELEVEN',\n",
       " 'OCBC TANJONG PAGAR ROAD',\n",
       " 'OCBC TEBAN GARDENS ROAD',\n",
       " 'OCBC TEBAN PLACE',\n",
       " 'OCBC TECK WHYE LANE - FAIRPRICE',\n",
       " 'OCBC TELOK BLANGAH MRT STATION',\n",
       " 'OCBC TELOK BLANGAH STREET 32 - FAIRPRICE',\n",
       " 'OCBC THE CATHAY',\n",
       " 'OCBC THE CENTRAL',\n",
       " 'OCBC THE CENTREPOINT',\n",
       " 'OCBC THE CLEMENTI MALL',\n",
       " 'OCBC THE SIGNATURE',\n",
       " 'OCBC THE STAR VISTA',\n",
       " 'OCBC THOMSON BRANCH',\n",
       " 'OCBC THOMSON PLAZA',\n",
       " 'OCBC TIONG BAHRU MRT STATION',\n",
       " 'OCBC TIONG BAHRU PLAZA BRANCH',\n",
       " 'OCBC TOA PAYOH BUS INTERCHANGE',\n",
       " 'OCBC TOA PAYOH CENTRAL BRANCH',\n",
       " 'OCBC TOA PAYOH LORONG 1',\n",
       " 'OCBC TOA PAYOH LORONG 1 - 7-ELEVEN',\n",
       " 'OCBC TOA PAYOH LORONG 2 - ESSO STATION',\n",
       " 'OCBC TOA PAYOH LORONG 4 - FAIRPRICE',\n",
       " 'OCBC TOA PAYOH LORONG 6 - 7-ELEVEN',\n",
       " 'OCBC TOA PAYOH LORONG 6 - FAIRPRICE',\n",
       " 'OCBC TOA PAYOH LORONG 8',\n",
       " 'OCBC TOA PAYOH MRT STATION',\n",
       " 'OCBC TOA PAYOH MRT STATION EHUB',\n",
       " 'OCBC TOWNER ROAD - 7-ELEVEN',\n",
       " 'OCBC UBI AVENUE 1 - GIANT',\n",
       " 'OCBC UBI BUSINESS BANKING CENTRE',\n",
       " 'OCBC UNITED SQUARE BRANCH',\n",
       " 'OCBC UPPER ALJUNIED ROAD - PRIME SUPERMARKET',\n",
       " 'OCBC UPPER BOON KENG ROAD',\n",
       " 'OCBC UPPER BOON KENG ROAD - FAIRPRICE',\n",
       " 'OCBC UPPER BUKIT TIMAH ROAD - ESSO STATION',\n",
       " 'OCBC UPPER SERANGOON ROAD - CALTEX STATION',\n",
       " 'OCBC UPPER THOMSON ROAD - 7-ELEVEN',\n",
       " 'OCBC UPPER THOMSON ROAD - ESSO STATION',\n",
       " 'OCBC V HOTEL',\n",
       " 'OCBC VISTA POINT',\n",
       " 'OCBC VIVOCITY FRANK STORE',\n",
       " 'OCBC WATERWAY POINT - FAIRPRICE',\n",
       " 'OCBC WATERWAY POINT BRANCH',\n",
       " 'OCBC WEST COAST DRIVE - 7-ELEVEN',\n",
       " 'OCBC WEST COAST DRIVE - FAIRPRICE',\n",
       " 'OCBC WEST COAST PLAZA',\n",
       " 'OCBC WESTGATE',\n",
       " 'OCBC WHITE SANDS',\n",
       " 'OCBC WHITE SANDS BRANCH',\n",
       " 'OCBC WISMA ATRIA',\n",
       " 'OCBC WOODLANDS AVE 1 - FAIRPRICE<BR>',\n",
       " 'OCBC WOODLANDS AVENUE 1 - FAIRPRICE',\n",
       " 'OCBC WOODLANDS AVENUE 3 - FAIRPRICE',\n",
       " 'OCBC WOODLANDS BRANCH',\n",
       " 'OCBC WOODLANDS CENTRE ROAD',\n",
       " 'OCBC WOODLANDS DRIVE 50 - FAIRPRICE',\n",
       " 'OCBC WOODLANDS MART',\n",
       " 'OCBC WOODLANDS MRT STATION',\n",
       " 'OCBC WOODLANDS NORTH PLAZA',\n",
       " 'OCBC WOODLANDS TEMPORARY BUS INTERCHANGE',\n",
       " 'OCBC YEW TEE MRT STATION',\n",
       " 'OCBC YEW TEE SQUARE',\n",
       " 'OCBC YISHUN AVENUE 5 - 7-ELEVEN',\n",
       " 'OCBC YISHUN BRANCH',\n",
       " 'OCBC YISHUN CENTRAL - CHEERS',\n",
       " 'OCBC YISHUN MRT STATION',\n",
       " 'OCBC YISHUN RING ROAD',\n",
       " 'OCBC YISHUN RING ROAD - 7-ELEVEN',\n",
       " 'OCBC YISHUN RING ROAD - CALTEX STATION',\n",
       " 'OCBC YISHUN RING ROAD - FAIRPRICE',\n",
       " 'OCBC YISHUN STREET 22 - 7-ELEVEN',\n",
       " 'OCBC YISHUN STREET 72',\n",
       " 'OCBC YISHUN TEMP BUS INTERCHANGE',\n",
       " 'OCBC YUAN CHING ROAD - SHENG SIONG SUPERMARKET',\n",
       " 'OCBC YUNG KUANG ROAD - FAIRPRICE',\n",
       " 'OCBC ZHONGSHAN PARK - FAIRPRICE']"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import re\n",
    "\n",
    "def maybe_add_ocbc(n):\n",
    "    if re.search('^OCBC ', n):\n",
    "        return n.upper().strip()\n",
    "    return ('OCBC ' + n.upper()).strip()\n",
    "\n",
    "ocbc_addresses = set([\n",
    "    maybe_add_ocbc(o['landmark']) for o in ocbc['nearby_ocbc_atms']\n",
    "])\n",
    "sorted(ocbc_addresses)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "796103ef-b434-4b97-b4b2-14bb31a24f42",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['OCBC 313@SOMERSET',\n",
       " 'OCBC 7-4 DEPTFORD ROAD',\n",
       " 'OCBC ADMIRALTY MRT',\n",
       " 'OCBC ADMIRALTY PLACE',\n",
       " 'OCBC ALEXANDRA RD - FAIRPRICE',\n",
       " 'OCBC ALJUNIED AVE 2 - FAIRPRICE',\n",
       " 'OCBC ALJUNIED MRT',\n",
       " 'OCBC AMARA HOTEL - FAIRPRICE',\n",
       " 'OCBC AMK HUB',\n",
       " 'OCBC AMOY STREET FOOD CENTRE',\n",
       " 'OCBC ANG MO KIO AVE 1',\n",
       " 'OCBC ANG MO KIO AVE 1 - 7 ELEVEN',\n",
       " 'OCBC ANG MO KIO AVE 1 - FAIRPRICE',\n",
       " 'OCBC ANG MO KIO AVE 10',\n",
       " 'OCBC ANG MO KIO AVE 10 - 7 ELEVEN',\n",
       " 'OCBC ANG MO KIO AVE 10 - CHEERS',\n",
       " 'OCBC ANG MO KIO AVE 3',\n",
       " 'OCBC ANG MO KIO AVE 3 - ESSO STATION',\n",
       " 'OCBC ANG MO KIO AVE 6 - FAIRPRICE',\n",
       " 'OCBC ANG MO KIO AVE 8 - NANYANG POLYTECHNIC',\n",
       " 'OCBC ANG MO KIO BRANCH',\n",
       " 'OCBC ANG MO KIO BUS INTERCHANGE',\n",
       " 'OCBC ANG MO KIO MRT STATION',\n",
       " 'OCBC ASIA SQUARE TOWER 1',\n",
       " 'OCBC BALESTIER ROAD - CALTEX STATION',\n",
       " 'OCBC BALESTIER ROAD - CHEERS',\n",
       " 'OCBC BANK OF SINGAPORE',\n",
       " 'OCBC BEACH ROAD - CALTEX STATION',\n",
       " 'OCBC BEAUTY WORLD MRT STATION',\n",
       " 'OCBC BEDOK BRANCH',\n",
       " 'OCBC BEDOK BUS INTERCHANGE',\n",
       " 'OCBC BEDOK MALL - FAIRPRICE',\n",
       " 'OCBC BEDOK NORTH',\n",
       " 'OCBC BEDOK NORTH BRANCH',\n",
       " 'OCBC BEDOK NORTH ST 1 - FAIRPRICE',\n",
       " 'OCBC BEDOK NORTH ST 4 - FAIRPRICE',\n",
       " 'OCBC BEDOK RESERVOIR RD - 7 ELEVEN',\n",
       " 'OCBC BEDOK RESERVOIR RD - FAIRPRICE',\n",
       " 'OCBC BEDOK RESERVOIR RD - MCDONALDS',\n",
       " 'OCBC BENDEMEER ROAD - FAIRPRICE',\n",
       " 'OCBC BENOI RD- FAIRPRICE',\n",
       " 'OCBC BISHAN MRT STATION',\n",
       " 'OCBC BISHAN ST 13 - FAIRPRICE',\n",
       " 'OCBC BISHAN ST 22',\n",
       " 'OCBC BISHAN ST 24 - FAIRPRICE',\n",
       " 'OCBC BISHAN STREET 11',\n",
       " 'OCBC BOON KENG MRT',\n",
       " 'OCBC BOON LAY BUS INTERCHANGE',\n",
       " 'OCBC BOON LAY MRT STATION',\n",
       " 'OCBC BOON LAY SHOPPING CENTRE',\n",
       " 'OCBC BOON LAY SHOPPING CENTRE FAIRPRICE',\n",
       " 'OCBC BOTANIC GARDENS MRT STATION',\n",
       " 'OCBC BRADDELL MRT STATION',\n",
       " 'OCBC BRAS BASAH COMPLEX',\n",
       " 'OCBC BRAS BASAH MRT STATION',\n",
       " 'OCBC BUANGKOK MRT STATION',\n",
       " 'OCBC BUGIS MRT STATION',\n",
       " 'OCBC BUGIS+',\n",
       " 'OCBC BUKIT BATOK BUSINESS BANKING CENTRE',\n",
       " 'OCBC BUKIT BATOK CENTRAL - 7-ELEVEN',\n",
       " 'OCBC BUKIT BATOK CENTRAL - BT BATOK BRANCH',\n",
       " 'OCBC BUKIT BATOK EAST AVE 3 - FAIRPRICE',\n",
       " 'OCBC BUKIT BATOK MRT',\n",
       " 'OCBC BUKIT BATOK MRT STATION - FAIRPRICE',\n",
       " 'OCBC BUKIT BATOK ST 11 - CHEERS',\n",
       " 'OCBC BUKIT BATOK WEST AVE 6 - 7 ELEVEN',\n",
       " 'OCBC BUKIT BATOK WEST AVE 7 - FAIRPRICE',\n",
       " 'OCBC BUKIT BATOK WEST AVE 8',\n",
       " 'OCBC BUKIT BATOK WEST AVE 8 - FAIRPRICE',\n",
       " 'OCBC BUKIT GOMBAK MRT STATION',\n",
       " 'OCBC BUKIT MERAH CENTRAL - FAIRPRICE',\n",
       " 'OCBC BUKIT PANJANG BRANCH',\n",
       " 'OCBC BUKIT PANJANG BUS INTERCHANGE',\n",
       " 'OCBC BUKIT PANJANG MRT STATION',\n",
       " 'OCBC BUKIT PANJANG PLAZA',\n",
       " 'OCBC BUKIT PANJANG RING RD - 7 ELEVEN',\n",
       " 'OCBC BUKIT TIMAH - SINOPEC STATION',\n",
       " 'OCBC BUKIT TIMAH BRANCH',\n",
       " 'OCBC BUKIT TIMAH PLAZA - FAIRPRICE',\n",
       " 'OCBC BUKIT TIMAH RD - FAIRPRICE',\n",
       " 'OCBC BUKIT TIMAH ROAD - ESSO STATION',\n",
       " 'OCBC BUONA VISTA MRT STATION',\n",
       " 'OCBC BUONA VISTA MRT STATION (CIRCLE LINE)',\n",
       " 'OCBC CAMBRIDGE ROAD - FAIRPRICE',\n",
       " 'OCBC CAMPUS',\n",
       " 'OCBC CANBERRA ROAD - FAIRPRICE',\n",
       " 'OCBC CAUSEWAY POINT BRANCH',\n",
       " 'OCBC CENTRE',\n",
       " 'OCBC CHAI CHEE AVENUE - FAIRPRICE',\n",
       " 'OCBC CHAI CHEE ROAD - PRIME SUPERMARKET',\n",
       " 'OCBC CHANGI AIRPORT TERMINAL 1 - ARRIVAL HALL CENTRAL',\n",
       " 'OCBC CHANGI AIRPORT TERMINAL 1 - DEPARTURE HALL',\n",
       " 'OCBC CHANGI AIRPORT TERMINAL 1 - DEPARTURE TRANSIT EAST',\n",
       " 'OCBC CHANGI AIRPORT TERMINAL 2 - ARRIVAL HALL NORTH',\n",
       " 'OCBC CHANGI AIRPORT TERMINAL 2 - ARRIVAL HALL SOUTH',\n",
       " 'OCBC CHANGI AIRPORT TERMINAL 2 - DEPARTURE/CHECK-IN HALL NORTH',\n",
       " 'OCBC CHANGI AIRPORT TERMINAL 2 - DEPARTURE/TRANSIT LOUNGE SOUTH',\n",
       " 'OCBC CHANGI AIRPORT TERMINAL 2 - DEPARTURE/TRANSIT NORTH',\n",
       " 'OCBC CHANGI AIRPORT TERMINAL 3 - ARRIVAL HALL NORTH',\n",
       " 'OCBC CHANGI AIRPORT TERMINAL 3 - BASEMENT 2 SOUTH (IN FRONT OF FOODCOURT)',\n",
       " 'OCBC CHANGI AIRPORT TERMINAL 3 - DEPARTURE CHECK-IN HALL NORTH',\n",
       " 'OCBC CHANGI AIRPORT TERMINAL 3 - DEPARTURE CHECK-IN HALL SOUTH',\n",
       " 'OCBC CHANGI AIRPORT TERMINAL 3 - DEPARTURE TRANSIT SOUTH CENTRAL',\n",
       " 'OCBC CHANGI AIRPORT TERMINAL 4 - ARRIVAL HALL',\n",
       " 'OCBC CHANGI AIRPORT TERMINAL 4 - DEPARTURE HALL',\n",
       " 'OCBC CHANGI AIRPORT TERMINAL 4 - DEPARTURE TRANSIT',\n",
       " 'OCBC CHANGI AIRPORT TERMINAL 4 - LEVEL 2 NEAR FOOD COURT',\n",
       " 'OCBC CHANGI BUSINESS PARK - FAIRPRICE',\n",
       " 'OCBC CHANGI CITY POINT - FAIRPRICE',\n",
       " 'OCBC CHANGI GENERAL HOSPITAL',\n",
       " 'OCBC CHANGI ROAD - 7 ELEVEN',\n",
       " 'OCBC CHANGI VILLAGE ROAD - 7 ELEVEN',\n",
       " 'OCBC CHINATOWN MRT STATION',\n",
       " 'OCBC CHINATOWN POINT - FAIRPRICE',\n",
       " 'OCBC CHINESE GARDEN MRT STATION',\n",
       " 'OCBC CHOA CHU KANG BRANCH',\n",
       " 'OCBC CHOA CHU KANG MRT STATION',\n",
       " 'OCBC CINELEISURE ORCHARD',\n",
       " 'OCBC CIRCUIT ROAD - FAIRPRICE',\n",
       " 'OCBC CITY HALL MRT STATION',\n",
       " 'OCBC CITY PLAZA',\n",
       " 'OCBC CITY SQUARE MALL - BRANCH',\n",
       " 'OCBC CITY SQUARE MALL - FAIRPRICE',\n",
       " 'OCBC CLARKE QUAY MRT STATION',\n",
       " 'OCBC CLEMENTI AVENUE 2 -FAIRPRICE',\n",
       " 'OCBC CLEMENTI AVENUE 3 - FAIRPRICE',\n",
       " 'OCBC CLEMENTI AVENUE 5',\n",
       " 'OCBC CLEMENTI BUS INTERCHANGE',\n",
       " 'OCBC CLEMENTI MRT STATION',\n",
       " 'OCBC CLEMENTI ST 11 - 7 ELEVEN',\n",
       " 'OCBC CLEMENTI WEST ST 2',\n",
       " 'OCBC COMMONWEALTH MRT STATION',\n",
       " 'OCBC COMPASS ONE BRANCH',\n",
       " 'OCBC COMPASSVALE LINK - FAIRPRICE',\n",
       " 'OCBC DAKOTA MRT STATION',\n",
       " 'OCBC DAWSON PLACE',\n",
       " 'OCBC DEPOT HEIGHTS SHOPPING CENTRE',\n",
       " 'OCBC DHOBY GHAUT MRT STATION',\n",
       " 'OCBC DOVER CRESCENT - FAIRPRICE',\n",
       " 'OCBC DOVER MRT STATION',\n",
       " 'OCBC DOWNTOWN EAST - FAIRPRICE',\n",
       " 'OCBC DOWNTOWN EAST - MARKET SQUARE@DOWNTOWN EAST',\n",
       " 'OCBC DUNEARN ROAD - CALTEX STATION',\n",
       " 'OCBC EAST COAST ROAD - 7 ELEVEN',\n",
       " 'OCBC EAST COAST ROAD - CALTEX STATION',\n",
       " 'OCBC EAST COAST ROAD - ESSO STATION',\n",
       " 'OCBC EAST COAST ROAD - FAIRPRICE',\n",
       " 'OCBC EASTPOINT MALL - FAIRPRICE',\n",
       " 'OCBC ENG HOON ST - CHEERS',\n",
       " 'OCBC ESPLANADE MALL',\n",
       " 'OCBC ESPLANADE MRT STATION',\n",
       " 'OCBC EUNOS CRESCENT - 7 ELEVEN',\n",
       " 'OCBC EUNOS CRESCENT - FAIRPRICE',\n",
       " 'OCBC EUNOS MRT STATION',\n",
       " 'OCBC EXPO DRIVE - SINGAPORE EXPO',\n",
       " 'OCBC FAJAR SHOPPING CENTRE',\n",
       " 'OCBC FAR EAST PLAZA',\n",
       " 'OCBC FOCH ROAD - CHEERS',\n",
       " 'OCBC FORTUNE CENTRE',\n",
       " 'OCBC FORUM THE SHOPPING MALL',\n",
       " 'OCBC FRANKEL - ESSO STATION',\n",
       " 'OCBC FRENCH ROAD - FAIRPRICE',\n",
       " 'OCBC GARDENS BY THE BAY - THE CANOPY',\n",
       " 'OCBC GEYLANG BAHRU',\n",
       " 'OCBC GEYLANG ROAD - 7 ELEVEN',\n",
       " 'OCBC GHIM MOH LINK - FAIRPRICE',\n",
       " 'OCBC GOLDEN MILE COMPLEX',\n",
       " 'OCBC GOLDEN MILE FOOD CENTRE',\n",
       " 'OCBC GREAT EASTERN CENTRE',\n",
       " 'OCBC GREENRIDGE SHOPPING CENTRE',\n",
       " 'OCBC GREENWICH V',\n",
       " 'OCBC GUARDIAN PHARMACY',\n",
       " 'OCBC HARBOURFRONT BUS INTERCHANGE',\n",
       " 'OCBC HARBOURFRONT MRT STATION',\n",
       " 'OCBC HARBOURFRONT MRT STATION (CIRCLE LINE)',\n",
       " 'OCBC HAVELOCK ROAD - FAIRPRICE',\n",
       " 'OCBC HAW PAR VILLA MRT STATION',\n",
       " 'OCBC HEARTLAND MALL',\n",
       " 'OCBC HILLION MALL - FAIRPRICE',\n",
       " 'OCBC HOLLAND DRIVE - FAIRPRICE',\n",
       " 'OCBC HOLLAND ROAD - CALTEX STATION',\n",
       " 'OCBC HOLLAND VILAGE MRT STATION',\n",
       " 'OCBC HOLLAND VILLAGE BRANCH',\n",
       " 'OCBC HOUGANG AVE 1 - 7 ELEVEN',\n",
       " 'OCBC HOUGANG AVE 10 - FAIRPRICE',\n",
       " 'OCBC HOUGANG AVE 3 - CHEERS',\n",
       " 'OCBC HOUGANG AVE 4 - FAIRPRICE',\n",
       " 'OCBC HOUGANG AVE 8 - CHEERS',\n",
       " 'OCBC HOUGANG BRANCH',\n",
       " 'OCBC HOUGANG CAPEVIEW - FAIRPRICE',\n",
       " 'OCBC HOUGANG CENTRAL - CHEERS',\n",
       " 'OCBC HOUGANG GREEN SHOPPING MALL',\n",
       " 'OCBC HOUGANG MALL BRANCH',\n",
       " 'OCBC HOUGANG MRT STATION',\n",
       " 'OCBC HOUGANG ST 21 - FAIRPRICE',\n",
       " 'OCBC HOUGANG ST 61',\n",
       " 'OCBC HOUGANG ST 91 - FAIRPRICE',\n",
       " 'OCBC IKEA BUILDING',\n",
       " 'OCBC IKEA BUILDING',\n",
       " 'OCBC IMM BUILDING - NEAR FOOD KIOSK SECTION',\n",
       " 'OCBC IMM BUILDING - NEAR GIANT SUPERMARKET',\n",
       " 'OCBC INTERNATIONAL PLAZA',\n",
       " 'OCBC ION ORCHARD',\n",
       " 'OCBC ION ORCHARD BRANCH',\n",
       " 'OCBC JALAN BUKIT MERAH - FAIRPRICE',\n",
       " 'OCBC JALAN KAYU - FAIRPRICE',\n",
       " 'OCBC JALAN TIGA - FAIRPRICE',\n",
       " 'OCBC JCUBE - FAIRPRICE',\n",
       " 'OCBC JEM - FAIRPRICE',\n",
       " 'OCBC JEM - JURONG EAST BRANCH',\n",
       " 'OCBC JOO CHIAT ROAD - FAIRPRICE',\n",
       " 'OCBC JOO KOON BUS INTERCHANGE',\n",
       " 'OCBC JOO KOON MRT STATION',\n",
       " 'OCBC JUNCTION 10',\n",
       " 'OCBC JUNCTION 8 SHOPPING CENTRE',\n",
       " 'OCBC JURONG BRANCH',\n",
       " 'OCBC JURONG EAST MRT',\n",
       " 'OCBC JURONG EAST ST 24 - 7 ELEVEN',\n",
       " 'OCBC JURONG EAST ST 24 - FAIRPRICE',\n",
       " 'OCBC JURONG EAST ST 31 - FAIRPRICE',\n",
       " 'OCBC JURONG EAST TEMPORARY BUS INTERCHANGE',\n",
       " 'OCBC JURONG GATEWAY ROAD - 7 ELEVEN',\n",
       " 'OCBC JURONG GATEWAY ROAD - FAIRPRICE',\n",
       " 'OCBC JURONG POINT SHOPPING CENTRE',\n",
       " 'OCBC JURONG POINT SHOPPING CENTRE',\n",
       " 'OCBC JURONG WEST BRANCH',\n",
       " 'OCBC JURONG WEST ST 41',\n",
       " 'OCBC JURONG WEST ST 41 - FAIRPRICE',\n",
       " 'OCBC JURONG WEST ST 51 - 7 ELEVEN',\n",
       " 'OCBC JURONG WEST ST 75 - PRIME SUPERMARKET',\n",
       " 'OCBC JURONG WEST ST 91',\n",
       " 'OCBC JURONG WEST ST 92',\n",
       " 'OCBC KALLANG BAHRU - FAIRPRICE',\n",
       " 'OCBC KALLANG WAVE',\n",
       " 'OCBC KATONG V - FAIRPRICE',\n",
       " 'OCBC KEMBANGAN MRT',\n",
       " 'OCBC KENSINGTON PARK - 7 ELEVEN',\n",
       " 'OCBC KENT RIDGE MRT',\n",
       " 'OCBC KHATIB MRT',\n",
       " 'OCBC KILLINEY ROAD - FAIRPRICE',\n",
       " 'OCBC KIM KEAT AVENUE',\n",
       " 'OCBC KIM TIAN ROAD - FAIRPRICE',\n",
       " \"OCBC KK WOMEN'S AND CHILDREN'S HOSPITAL\",\n",
       " 'OCBC KOVAN MRT',\n",
       " 'OCBC KRANJI MRT',\n",
       " 'OCBC LAKESIDE MRT',\n",
       " 'OCBC LAVENDER MRT',\n",
       " 'OCBC LAVENDER STREET - ESSO STATION',\n",
       " 'OCBC LENGKOK BAHRU - FAIRPRICE',\n",
       " 'OCBC LENGKONG TIGA - FAIRPRICE',\n",
       " 'OCBC LIANG COURT SHOPPING CENTRE',\n",
       " 'OCBC LIMBANG SHOPPING CENTRE',\n",
       " 'OCBC LITTLE INDIA ARCADE - 7 ELEVEN',\n",
       " 'OCBC LITTLE INDIA MRT',\n",
       " 'OCBC LORONG CHUAN - ESSO STATION',\n",
       " 'OCBC LORONG CHUAN MRT',\n",
       " 'OCBC LORONG LIMAU - FAIRPRICE',\n",
       " 'OCBC LORONG MOMBONG - 7 ELEVEN',\n",
       " 'OCBC LOT 1 SHOPPERS MALL',\n",
       " 'OCBC LOYANG POINT',\n",
       " 'OCBC LUCKY PLAZA',\n",
       " 'OCBC MACPHERSON MALL - FAIRPRICE',\n",
       " 'OCBC MACPHERSON MRT',\n",
       " 'OCBC MARINA BAY FINANCIAL CENTRE BRANCH',\n",
       " 'OCBC MARINA BAY LINK MALL',\n",
       " 'OCBC MARINA BAY MRT',\n",
       " 'OCBC MARINA BAY SANDS',\n",
       " 'OCBC MARINA SQUARE',\n",
       " 'OCBC MARINE PARADE CENTRAL',\n",
       " 'OCBC MARINE PARADE CENTRAL - FAIRPRICE',\n",
       " 'OCBC MARITIME SQUARE',\n",
       " 'OCBC MARSILING LANE',\n",
       " 'OCBC MARYMOUNT MRT',\n",
       " 'OCBC MAXWELL HAWKER CENTRE',\n",
       " 'OCBC MINDEF - BUKIT BATOK CAMP',\n",
       " 'OCBC MINDEF - DEPOT ROAD CAMP',\n",
       " 'OCBC MOUNBATTEN MRT',\n",
       " 'OCBC MOUNBATTEN SQUARE',\n",
       " 'OCBC MOUNT ALVERNIA HOSPITAL',\n",
       " 'OCBC MOUNT ELIZABETH MEDICAL CENTRE',\n",
       " 'OCBC NANYANG TECHNOLOGICAL UNIVERSITY',\n",
       " 'OCBC NATIONAL UNIVERSITY HOSPITAL',\n",
       " 'OCBC NATIONAL UNIVERSITY OF SINGAPORE',\n",
       " 'OCBC NEW BRIDGE CENTRE',\n",
       " 'OCBC NEW BRIDGE ROAD - CHEERS',\n",
       " 'OCBC NEW UPPER CHANGI ROAD',\n",
       " 'OCBC NEW UPPER CHANGI ROAD - FAIRPRICE',\n",
       " 'OCBC NEW WORLD CENTRE',\n",
       " 'OCBC NEWTON FOOD CENTRE',\n",
       " 'OCBC NEWTON MRT STATION',\n",
       " 'OCBC NEX',\n",
       " 'OCBC NG TENG FONG HOSPITAL',\n",
       " 'OCBC NGEE ANN CITY',\n",
       " 'OCBC NICOLL HIGHWAY MRT',\n",
       " 'OCBC NORTH BRACH',\n",
       " 'OCBC NOVENA MRT',\n",
       " 'OCBC NUH - FAIRPRICE',\n",
       " 'OCBC NUS',\n",
       " 'OCBC NUS',\n",
       " 'OCBC NUS',\n",
       " 'OCBC NUS',\n",
       " 'OCBC NUS',\n",
       " 'OCBC NUS',\n",
       " 'OCBC NUS UNIVERSITY TOWN - CHEERS',\n",
       " 'OCBC NUS UNIVERSITY TOWN - CHEERS',\n",
       " 'OCBC OCBC CENTRE BRANCH',\n",
       " 'OCBC OCBC TAMPINES CENTRE TWO',\n",
       " 'OCBC ONAN ROAD - CHEERS',\n",
       " 'OCBC ONE - NORTH MRT',\n",
       " 'OCBC ORCHARD MRT',\n",
       " 'OCBC ORCHARDGATEWAY BRANCH',\n",
       " 'OCBC ORCHID COUNTRY CLUB - FAIRPRICE',\n",
       " 'OCBC OUR TAMPINES HUB - FAIRPRICE',\n",
       " 'OCBC OUTRAM PARK MRT',\n",
       " 'OCBC PARAGON',\n",
       " 'OCBC PARCO BUGIS JUNCTION',\n",
       " 'OCBC PARKLANE SHOPPING MALL',\n",
       " 'OCBC PARKWAY PARADE',\n",
       " 'OCBC PASIR RIS BUS INTERCHANGE',\n",
       " 'OCBC PASIR RIS DRIVE 4 - GIANT',\n",
       " 'OCBC PASIR RIS DRIVE 6 - 7 ELEVEN',\n",
       " 'OCBC PASIR RIS MRT',\n",
       " 'OCBC PASIR RIS WEST PLAZA',\n",
       " 'OCBC PASIR RIS WEST PLAZA - FAIRPRICE',\n",
       " 'OCBC PAYA LEBAR MRT',\n",
       " 'OCBC PAYA LEBAR MRT CC',\n",
       " 'OCBC PAYA LEBAR SQUARE',\n",
       " 'OCBC PENINSULA PLAZA',\n",
       " \"OCBC PEOPLE'S PARK CENTRE\",\n",
       " \"OCBC PEOPLE'S PARK COMPLEX\",\n",
       " 'OCBC PIONEER MALL',\n",
       " 'OCBC PIONEER MRT',\n",
       " 'OCBC PIONEER ROAD - ESSO STATION',\n",
       " 'OCBC PLAZA SINGAPURA',\n",
       " 'OCBC POTONG PASIR - FAIRPRICE',\n",
       " 'OCBC POTONG PASIR MRT',\n",
       " 'OCBC PROMENADE MRT',\n",
       " 'OCBC PUNGGOL BUS INTERCHANGE',\n",
       " 'OCBC PUNGGOL DRIVE - FAIRPRICE',\n",
       " 'OCBC PUNGGOL FIELD',\n",
       " 'OCBC PUNGGOL MRT',\n",
       " 'OCBC PUNGGOL PLAZA',\n",
       " 'OCBC PUNGGOL WATERWAY TERRACE - FAIRPRICE',\n",
       " 'OCBC QUEENSTOWN MRT',\n",
       " 'OCBC QUEENSWAY SHOPPING CENTRE',\n",
       " 'OCBC RAFFLES CITY SHOPPING CENTRE',\n",
       " 'OCBC RAFFLES PLACE MRT',\n",
       " 'OCBC REPUBLIC POLYTECHNIC',\n",
       " 'OCBC RESORT WORLD AT SENTOSA',\n",
       " 'OCBC RIVER VALLEY ROAD - 7 ELEVEN',\n",
       " 'OCBC RIVER VALLEY ROAD - FAIRPRICE',\n",
       " 'OCBC RIVERVALE MALL',\n",
       " 'OCBC RIVERVALE PLAZA',\n",
       " 'OCBC ROCHER MRT',\n",
       " 'OCBC SCOTTS SQUARE',\n",
       " 'OCBC SELETAR MALL - FAIRPRICE',\n",
       " 'OCBC SEMBAWANG MRT',\n",
       " 'OCBC SEMBAWANG SHOPPING CENTRE',\n",
       " 'OCBC SEMBAWANG WAY - FAIRPRICE',\n",
       " 'OCBC SENG POH ROAD - 7 ELEVEN',\n",
       " 'OCBC SENGKANG BUS INTERCHANGE',\n",
       " 'OCBC SENJA ROAD - FAIRPRICE',\n",
       " 'OCBC SENTOSA',\n",
       " 'OCBC SENTOSA COVE',\n",
       " 'OCBC SERANGGON CENTRAL DRIVE - FAIRPRICE',\n",
       " 'OCBC SERANGGOON GARDEN BRANCH',\n",
       " 'OCBC SERANGOON AVE 3 - 7 ELEVEN',\n",
       " 'OCBC SERANGOON BUS INTERCHANGE',\n",
       " 'OCBC SERANGOON MRT',\n",
       " 'OCBC SERANGOON NORTH AVE 1 - FAIRPRICE',\n",
       " 'OCBC SERANGOON NORTH AVE 5 - SHENG SIONG',\n",
       " 'OCBC SERANGOON ROAD - 7 ELEVEN',\n",
       " 'OCBC SHAW CENTRE',\n",
       " 'OCBC SHAW PLAZA - TWIN HEIGHTS',\n",
       " 'OCBC SHUN LI INDUSTRIAL PARK',\n",
       " 'OCBC SILAT AVE - FAIRPRICE',\n",
       " 'OCBC SIM LIM SQUARE',\n",
       " 'OCBC SIM LIM TOWER',\n",
       " 'OCBC SIMEI MRT',\n",
       " 'OCBC SIMET STREET 3',\n",
       " 'OCBC SIMS PLACE',\n",
       " 'OCBC SINGAPORE GENERAL HOSPITAL',\n",
       " 'OCBC SINGAPORE INSTITUTE OF MANAGEMENT',\n",
       " 'OCBC SINGAPORE POLYTECHNIC',\n",
       " 'OCBC SINGAPORE POLYTECHNIC FRANK STORE',\n",
       " 'OCBC SINGAPORE PRESS HOLDINGS',\n",
       " 'OCBC SINGAPORE UNIVERSITY OF TECHNOLOGY AND DESIGN',\n",
       " 'OCBC SIXTH AVENUE - 7 ELEVEN',\n",
       " 'OCBC SIXTHAVENUE BRANCH',\n",
       " 'OCBC SMU BRANCH',\n",
       " 'OCBC SOUTH BRIDGE ROAD - FOOK HAI BULDING',\n",
       " 'OCBC SOUTH WOODLANDS DRIVE - FAIRPRICE',\n",
       " 'OCBC SQUARE 2 - FAIRPRICE',\n",
       " 'OCBC STADIUM STATION',\n",
       " 'OCBC STAMFORD ROAD - CHEERS',\n",
       " 'OCBC STIRLING ROAD - FAIRPRICE',\n",
       " 'OCBC SUN PLAZA - FAIRPRICE',\n",
       " 'OCBC SUN PLAZA BRANCH',\n",
       " 'OCBC SUNSHINE PLACE',\n",
       " 'OCBC SUNTECT CITY',\n",
       " 'OCBC TAI SENG MRT',\n",
       " 'OCBC TAMAN JURONG SHOPPING CENTRE',\n",
       " 'OCBC TAMPINES 1',\n",
       " 'OCBC TAMPINES AVE 1 - CHEERS',\n",
       " 'OCBC TAMPINES BRANCH',\n",
       " 'OCBC TAMPINES BUS INTERCHANGE',\n",
       " 'OCBC TAMPINES CENTRAL 1',\n",
       " 'OCBC TAMPINES CENTRAL COUMMUNITY CENTRE',\n",
       " 'OCBC TAMPINES CENTRE TWO',\n",
       " 'OCBC TAMPINES MRT',\n",
       " 'OCBC TAMPINES STREE 11 - FAIRPRICE',\n",
       " 'OCBC TAMPINES STREET 11 - 7 ELEVEN',\n",
       " 'OCBC TAMPINES STREET 11 - FAIRPRICE',\n",
       " 'OCBC TAMPINES STREET 21',\n",
       " 'OCBC TAMPINES STREET 21',\n",
       " 'OCBC TAMPINES STREET 44',\n",
       " 'OCBC TAMPINES STREET 81 - PRIME SUPERMARKET',\n",
       " 'OCBC TAN TOCK SENG HOSPITAL',\n",
       " 'OCBC TANAH MERAH FERRY TERMINAL',\n",
       " 'OCBC TANAH MERAH MRT',\n",
       " 'OCBC TANG PLAZA',\n",
       " 'OCBC TANGJONG PAGAR PLAZA',\n",
       " 'OCBC TANGLIN MALL',\n",
       " 'OCBC TANJONG KATONG ROAD - 7 ELEVEN',\n",
       " 'OCBC TANJONG PAGAR MRT',\n",
       " 'OCBC TANJONG PAGAR PLAZA - 7 ELEVEN',\n",
       " 'OCBC TANJONG PAGAR ROAD',\n",
       " 'OCBC TEBAN GARDENS ROAD',\n",
       " 'OCBC TEBAN PLACE',\n",
       " 'OCBC TECK WHYE LANE - FAIRPRICE',\n",
       " 'OCBC TELOK BLANGAH MRT',\n",
       " 'OCBC TELOK BLANGAH STREET 32 - FAIRPRICE',\n",
       " 'OCBC THE CATHAY',\n",
       " 'OCBC THE CENTRAL',\n",
       " 'OCBC THE CENTREPOINT',\n",
       " 'OCBC THE CLEMENTI MALL',\n",
       " 'OCBC THE SIGNATURE',\n",
       " 'OCBC THE STAR VISTA',\n",
       " 'OCBC THOMSON BRANCH',\n",
       " 'OCBC THOMSON PLAZA',\n",
       " 'OCBC TIONG BAHRU MRT',\n",
       " 'OCBC TIONG BAHRU PLAZA BRANCH',\n",
       " 'OCBC TOA PAYOH BUS INTERCHANGE',\n",
       " 'OCBC TOA PAYOH CENTRAL BRANCH',\n",
       " 'OCBC TOA PAYOH LORONG 1',\n",
       " 'OCBC TOA PAYOH LORONG 1 - 7 ELEVEN',\n",
       " 'OCBC TOA PAYOH LORONG 2 - ESSO STATION',\n",
       " 'OCBC TOA PAYOH LORONG 4 - FAIRPRICE',\n",
       " 'OCBC TOA PAYOH LORONG 6 - 7 ELEVEN',\n",
       " 'OCBC TOA PAYOH LORONG 6 - FAIRPRICE',\n",
       " 'OCBC TOA PAYOH LORONG 8',\n",
       " 'OCBC TOA PAYOH MRT',\n",
       " 'OCBC TOWNER ROAD - 7 ELEVEN',\n",
       " 'OCBC UBI AVENUE 1 - GIANT',\n",
       " 'OCBC UBI BUSINESS BANKING CENTRE',\n",
       " 'OCBC UPPER ALJUNIED ROAD - PRIME SUPERMARKET',\n",
       " 'OCBC UPPER BOON KENG ROAD',\n",
       " 'OCBC UPPER BOON KENG ROAD - FAIRPRICE',\n",
       " 'OCBC UPPER THOMSON ROAD - 7 ELEVEN',\n",
       " 'OCBC UPPER THOMSON ROAD - 7 ELEVEN',\n",
       " 'OCBC UPPER THOMSON ROAD - ESSO STATION',\n",
       " 'OCBC V HOTEL',\n",
       " 'OCBC VISTA POINT',\n",
       " 'OCBC VIVOCITY FRANK STORE',\n",
       " 'OCBC WATERWAY POINT - FAIRPRICE',\n",
       " 'OCBC WATERWAY POINT BRANCH',\n",
       " 'OCBC WEST COAST DRIVE - 7 ELEVEN',\n",
       " 'OCBC WEST COAST DRIVE - FAIRPRICE',\n",
       " 'OCBC WEST COAST PLAZA',\n",
       " 'OCBC WESTGATE',\n",
       " 'OCBC WHITE SANDS',\n",
       " 'OCBC WISMA ATRIA',\n",
       " 'OCBC WOODLANDS AVE 1 - FAIRPRICE',\n",
       " 'OCBC WOODLANDS AVE 3 - FAIRPRICE',\n",
       " 'OCBC WOODLANDS BRANCH',\n",
       " 'OCBC WOODLANDS DRIVE 50 - FAIRPRICE',\n",
       " 'OCBC WOODLANDS MART',\n",
       " 'OCBC WOODLANDS MRT',\n",
       " 'OCBC WOODLANDS NORTH PLAZA',\n",
       " 'OCBC WOODLANDS TEMPORARY BUS INTERCHANGE',\n",
       " 'OCBC YEW TEE MRT',\n",
       " 'OCBC YEW TEE SQAURE',\n",
       " 'OCBC YISHUN AVE 5 - 7 ELEVEN',\n",
       " 'OCBC YISHUN CENTRAL - CHEERS',\n",
       " 'OCBC YISHUN MRT',\n",
       " 'OCBC YISHUN RING ROAD',\n",
       " 'OCBC YISHUN RING ROAD',\n",
       " 'OCBC YISHUN RING ROAD',\n",
       " 'OCBC YISHUN RING ROAD - 7 ELEVEN',\n",
       " 'OCBC YISHUN RING ROAD - CALTEX STATION',\n",
       " 'OCBC YISHUN RING ROAD - FAIRPRICE',\n",
       " 'OCBC YISHUN RING ROAD - FAIRPRICE',\n",
       " 'OCBC YISHUN ST 22 - 7 ELEVEN',\n",
       " 'OCBC YISHUN STREET 72',\n",
       " 'OCBC YISHUN TEMP BUS INTERCHANGE',\n",
       " 'OCBC YUAN CHING ROAD - SHENG SIONG SUPERMARKET',\n",
       " 'OCBC YUNG KUANG ROAD - FAIRPRICE',\n",
       " 'OCBC ZHONGSHAN PARK - FAIRPRICE']"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import re\n",
    "\n",
    "ocbc_atms = sorted([\n",
    "    b\n",
    "    for a in address_with_multiple_buildings\n",
    "    for b in a[1]\n",
    "    if re.search('^OCBC ', b)\n",
    "])\n",
    "ocbc_atms"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "a2e75d42-0f70-4bb8-8ccf-4a0bcfca3499",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(525, 485, 220)"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(set(ocbc_addresses)), len(set(ocbc_atms)), len(set(ocbc_addresses) - set(ocbc_atms))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "id": "340e8c16-adf1-4ec1-ab40-03def16a724d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<re.Match object; span=(0, 16), match='BEDOK SOUTH MRT '>"
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import re\n",
    "\n",
    "def strings_match(s1, s2, allowed_substitutions):\n",
    "    map_of_substitutions = {\n",
    "        ' ': '[^A-Za-z0-9]*',\n",
    "        '-': '[^A-Za-z0-9]*',\n",
    "    }\n",
    "    \n",
    "    for ls in allowed_substitutions:\n",
    "        for word in ls:\n",
    "            if word:\n",
    "                map_of_substitutions[word] = '(' + '|'.join([re.escape(w) for w in ls]) + ')'\n",
    "    \n",
    "    parts = re.split(\"\\\\b\", s1)\n",
    "\n",
    "    final_re = []\n",
    "    for p in parts:\n",
    "        if p in map_of_substitutions:\n",
    "            final_re.append(map_of_substitutions[p])\n",
    "        else:\n",
    "            final_re.append(re.escape(p))\n",
    "\n",
    "    # print(''.join(final_re))\n",
    "    return re.search('^' + ''.join(final_re) + '$', s2)\n",
    "\n",
    "STANDARD_SUBSTITUTIONS = [\n",
    "    ['ST', 'STREET'],\n",
    "    ['RD', 'ROAD'],\n",
    "    ['AVE', 'AVENUE'],\n",
    "    ['STATION', ''],\n",
    "]\n",
    "\n",
    "strings_match('BEDOK SOUTH MRT STATION', 'BEDOK SOUTH MRT ', STANDARD_SUBSTITUTIONS)\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "id": "8e396c4a-fb3d-4180-bb31-5e27882348a3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "102"
      ]
     },
     "execution_count": 63,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(set([\n",
    "    a\n",
    "    for a in ocbc_addresses\n",
    "    if not any([strings_match(a, b, STANDARD_SUBSTITUTIONS) for b in ocbc_atms])\n",
    "]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "51fbb6da-b9ff-45a0-946c-83bf7bdc99e8",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.10"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}