Explore_incomplete_address.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "billion-election",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-03-20T01:05:58.203143Z",
     "start_time": "2021-03-20T01:05:57.700489Z"
    }
   },
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "from tqdm import tqdm"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "organized-logistics",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-03-20T01:06:00.874995Z",
     "start_time": "2021-03-20T01:06:00.381316Z"
    }
   },
   "outputs": [],
   "source": [
    "raw_df = pd.read_csv('data/train.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "supposed-chorus",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-03-20T01:06:01.827447Z",
     "start_time": "2021-03-20T01:06:01.805506Z"
    }
   },
   "outputs": [],
   "source": [
    "df = raw_df.copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "biological-stone",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-03-20T01:06:02.486684Z",
     "start_time": "2021-03-20T01:06:02.453772Z"
    },
    "scrolled": true
   },
   "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>id</th>\n",
       "      <th>raw_address</th>\n",
       "      <th>POI/street</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>jl kapuk timur delta sili iii lippo cika 11 a ...</td>\n",
       "      <td>/jl kapuk timur delta sili iii lippo cika</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>aye, jati sampurna</td>\n",
       "      <td>/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>setu siung 119 rt 5 1 13880 cipayung</td>\n",
       "      <td>/siung</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>toko dita, kertosono</td>\n",
       "      <td>toko dita/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>jl. orde baru</td>\n",
       "      <td>/jl. orde baru</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299995</th>\n",
       "      <td>299995</td>\n",
       "      <td>jend ahmad yani 331 kertasari ciamis</td>\n",
       "      <td>/jend ahmad yani</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299996</th>\n",
       "      <td>299996</td>\n",
       "      <td>raya cila kko, cilandak timur kel.</td>\n",
       "      <td>/raya cila kko</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299997</th>\n",
       "      <td>299997</td>\n",
       "      <td>tanjung gusta jl. yaya 2 no 17</td>\n",
       "      <td>/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299998</th>\n",
       "      <td>299998</td>\n",
       "      <td>jalan cipadu jaya taman asri gang bijaksana 3 ...</td>\n",
       "      <td>taman asri/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299999</th>\n",
       "      <td>299999</td>\n",
       "      <td>jaya maspion permata blok beryl b2  no.58</td>\n",
       "      <td>jaya maspion permata/</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>300000 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            id                                        raw_address  \\\n",
       "0            0  jl kapuk timur delta sili iii lippo cika 11 a ...   \n",
       "1            1                                 aye, jati sampurna   \n",
       "2            2               setu siung 119 rt 5 1 13880 cipayung   \n",
       "3            3                               toko dita, kertosono   \n",
       "4            4                                      jl. orde baru   \n",
       "...        ...                                                ...   \n",
       "299995  299995               jend ahmad yani 331 kertasari ciamis   \n",
       "299996  299996                 raya cila kko, cilandak timur kel.   \n",
       "299997  299997                     tanjung gusta jl. yaya 2 no 17   \n",
       "299998  299998  jalan cipadu jaya taman asri gang bijaksana 3 ...   \n",
       "299999  299999          jaya maspion permata blok beryl b2  no.58   \n",
       "\n",
       "                                       POI/street  \n",
       "0       /jl kapuk timur delta sili iii lippo cika  \n",
       "1                                               /  \n",
       "2                                          /siung  \n",
       "3                                      toko dita/  \n",
       "4                                  /jl. orde baru  \n",
       "...                                           ...  \n",
       "299995                           /jend ahmad yani  \n",
       "299996                             /raya cila kko  \n",
       "299997                                          /  \n",
       "299998                                taman asri/  \n",
       "299999                      jaya maspion permata/  \n",
       "\n",
       "[300000 rows x 3 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "effective-summary",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-03-20T01:06:08.106649Z",
     "start_time": "2021-03-20T01:06:06.761249Z"
    }
   },
   "outputs": [],
   "source": [
    "df['POI'] = df['POI/street'].str.split('/', expand = True)[0]\n",
    "df['street'] = df['POI/street'].str.split('/', expand = True)[1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "south-climate",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-03-20T01:06:08.735966Z",
     "start_time": "2021-03-20T01:06:08.710035Z"
    }
   },
   "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>id</th>\n",
       "      <th>raw_address</th>\n",
       "      <th>POI/street</th>\n",
       "      <th>POI</th>\n",
       "      <th>street</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>jl kapuk timur delta sili iii lippo cika 11 a ...</td>\n",
       "      <td>/jl kapuk timur delta sili iii lippo cika</td>\n",
       "      <td></td>\n",
       "      <td>jl kapuk timur delta sili iii lippo cika</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>aye, jati sampurna</td>\n",
       "      <td>/</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>setu siung 119 rt 5 1 13880 cipayung</td>\n",
       "      <td>/siung</td>\n",
       "      <td></td>\n",
       "      <td>siung</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>toko dita, kertosono</td>\n",
       "      <td>toko dita/</td>\n",
       "      <td>toko dita</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>jl. orde baru</td>\n",
       "      <td>/jl. orde baru</td>\n",
       "      <td></td>\n",
       "      <td>jl. orde baru</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299995</th>\n",
       "      <td>299995</td>\n",
       "      <td>jend ahmad yani 331 kertasari ciamis</td>\n",
       "      <td>/jend ahmad yani</td>\n",
       "      <td></td>\n",
       "      <td>jend ahmad yani</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299996</th>\n",
       "      <td>299996</td>\n",
       "      <td>raya cila kko, cilandak timur kel.</td>\n",
       "      <td>/raya cila kko</td>\n",
       "      <td></td>\n",
       "      <td>raya cila kko</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299997</th>\n",
       "      <td>299997</td>\n",
       "      <td>tanjung gusta jl. yaya 2 no 17</td>\n",
       "      <td>/</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299998</th>\n",
       "      <td>299998</td>\n",
       "      <td>jalan cipadu jaya taman asri gang bijaksana 3 ...</td>\n",
       "      <td>taman asri/</td>\n",
       "      <td>taman asri</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299999</th>\n",
       "      <td>299999</td>\n",
       "      <td>jaya maspion permata blok beryl b2  no.58</td>\n",
       "      <td>jaya maspion permata/</td>\n",
       "      <td>jaya maspion permata</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>300000 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            id                                        raw_address  \\\n",
       "0            0  jl kapuk timur delta sili iii lippo cika 11 a ...   \n",
       "1            1                                 aye, jati sampurna   \n",
       "2            2               setu siung 119 rt 5 1 13880 cipayung   \n",
       "3            3                               toko dita, kertosono   \n",
       "4            4                                      jl. orde baru   \n",
       "...        ...                                                ...   \n",
       "299995  299995               jend ahmad yani 331 kertasari ciamis   \n",
       "299996  299996                 raya cila kko, cilandak timur kel.   \n",
       "299997  299997                     tanjung gusta jl. yaya 2 no 17   \n",
       "299998  299998  jalan cipadu jaya taman asri gang bijaksana 3 ...   \n",
       "299999  299999          jaya maspion permata blok beryl b2  no.58   \n",
       "\n",
       "                                       POI/street                   POI  \\\n",
       "0       /jl kapuk timur delta sili iii lippo cika                         \n",
       "1                                               /                         \n",
       "2                                          /siung                         \n",
       "3                                      toko dita/             toko dita   \n",
       "4                                  /jl. orde baru                         \n",
       "...                                           ...                   ...   \n",
       "299995                           /jend ahmad yani                         \n",
       "299996                             /raya cila kko                         \n",
       "299997                                          /                         \n",
       "299998                                taman asri/            taman asri   \n",
       "299999                      jaya maspion permata/  jaya maspion permata   \n",
       "\n",
       "                                          street  \n",
       "0       jl kapuk timur delta sili iii lippo cika  \n",
       "1                                                 \n",
       "2                                          siung  \n",
       "3                                                 \n",
       "4                                  jl. orde baru  \n",
       "...                                          ...  \n",
       "299995                           jend ahmad yani  \n",
       "299996                             raya cila kko  \n",
       "299997                                            \n",
       "299998                                            \n",
       "299999                                            \n",
       "\n",
       "[300000 rows x 5 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "statewide-tyler",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-03-20T01:06:10.422454Z",
     "start_time": "2021-03-20T01:06:09.829042Z"
    }
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "100%|██████████████████████████████████████████████████████████████████████| 300000/300000 [00:00<00:00, 526800.40it/s]\n"
     ]
    }
   ],
   "source": [
    "# create new column for boolean value which tells which row has incomplete address\n",
    "flags = []\n",
    "for row in tqdm(df.itertuples(index = False), total = len(df)):\n",
    "    flags.append(row[1].find(row[3]) == -1 or row[1].find(row[4]) == -1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "suitable-chance",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-03-20T01:06:13.877212Z",
     "start_time": "2021-03-20T01:06:13.842306Z"
    }
   },
   "outputs": [],
   "source": [
    "df['POI/street not exact in raw_address'] = flags"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "finite-maldives",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-03-20T01:06:14.506528Z",
     "start_time": "2021-03-20T01:06:14.420759Z"
    }
   },
   "outputs": [],
   "source": [
    "incomplete_address = df[df['POI/street not exact in raw_address']==True].drop(['id','POI','street','POI/street not exact in raw_address'], axis = 1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "ranking-flight",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-03-20T01:06:15.274474Z",
     "start_time": "2021-03-20T01:06:15.254528Z"
    },
    "scrolled": true
   },
   "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>raw_address</th>\n",
       "      <th>POI/street</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>cikahuripan sd neg boj 02 klap boj, no 5 16877</td>\n",
       "      <td>sd negeri bojong 02/klap boj</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>yaya atohar,</td>\n",
       "      <td>yayasan atohariyah/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>toko bang ajs,</td>\n",
       "      <td>toko bangunan ajs/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>mar tabl metro iringmulyo metro timur</td>\n",
       "      <td>markaz tabligh metro/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>sd neg 12 anggrek</td>\n",
       "      <td>sd negeri 12 anggrek/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>rumah makan pela, raya jomb,</td>\n",
       "      <td>rumah makan pelangi/raya jomb</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>cak 11 nagasari karawang barat</td>\n",
       "      <td>/cakrad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>rnd prin, gang pinak, sukarame</td>\n",
       "      <td>rnd printing/gang pinak</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>pp minhajutt, kh abdul manan, sumberberas muncar</td>\n",
       "      <td>pp minhajutthollab/kh abdul manan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>tk islam daruss,</td>\n",
       "      <td>tk islam darussalam/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>kemb jepun, no 192 bint jaya ud, rw 1 bongkaran pabean cantikan</td>\n",
       "      <td>bintang jaya ud/kemb jepun</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>simpang tiga kah nasu no 112 28284 bukit raya</td>\n",
       "      <td>/kaharu nasu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>cau terr, gal,</td>\n",
       "      <td>causal terrace/gal</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>kedai tenun jep senn, kota bumi, kebon melati</td>\n",
       "      <td>kedai tenun jepara sennaart/kota bumi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>cv. hin oto kenc, sido ii, q 29</td>\n",
       "      <td>cv. hingdi oto kencana/sido ii</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>ahmad dah iv kukusan beji</td>\n",
       "      <td>/ahmad dahlan iv</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>caval pizz, dip ukur, lebak gede coblong</td>\n",
       "      <td>cavallino pizzaria/dip ukur</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>grey,</td>\n",
       "      <td>grey101/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>mangla rege no h1 3 cimekar kel. cileunyi</td>\n",
       "      <td>/manglayang rege</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>beng las deny, mendalanwangi</td>\n",
       "      <td>bengkel las deny/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>cipinang besar selatan lintas ibadah, cipi jaya 1a no 3 rw 7 13410 jatinegara</td>\n",
       "      <td>lintas ibadah/cipinang jaya 1a</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>ber nadah agung</td>\n",
       "      <td>berkat nadah agung/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>sd bust islamiah, andi pang petta panakkukang</td>\n",
       "      <td>sd bustanul islamiah/andi pang petta</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>sd neg palumbungan 1, perum wirasana purbalingga</td>\n",
       "      <td>sd negeri palumbungan 1/perum wirasana</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>ujung harapan, no 48a pd. karya warga mand cimb, bahagia</td>\n",
       "      <td>pd. karya warga mandiri cimb/ujung harapan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>prim warna dan rekan kembang jeruk iv, tlogosari kulon</td>\n",
       "      <td>primaadi warna dan rekan/kembang jeruk iv</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>alun - alun kuli nusan, kar</td>\n",
       "      <td>alun - alun kuliner nusantara/kar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>kantor bupati tapa sela serma lian kos, wek ii padang sidempuan utara (padangsidimpuan)</td>\n",
       "      <td>kantor bupati tapanuli selatan/serma lian kos</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>smk karya pemban, pon,</td>\n",
       "      <td>smk karya pembangunan/pon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>taman mer, 13 electr laun system, 2 meruya utara</td>\n",
       "      <td>electrolux laundry system/taman meruya</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>lelly bout, sum mekar babakan babakan ciparay</td>\n",
       "      <td>lelly boutique/sum mekar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>pasi redjeki, man kerto v, mojo</td>\n",
       "      <td>pasifik redjeki/man kertoarjo v</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187</th>\n",
       "      <td>stati accessories roxy mas, cideng gambir</td>\n",
       "      <td>station88 accessories/roxy mas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>kan desa sumber wangi tps 1, sumber wangi</td>\n",
       "      <td>kantor desa sumber wangi tps 1/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>190</th>\n",
       "      <td>pang rambut asgar raya kp utan setu, 32 cibitung</td>\n",
       "      <td>pangkas rambut asgar/raya kp utan setu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>192</th>\n",
       "      <td>aempe pluit bat raya pt, soek hatta, no 732 mekar mulya cinambo</td>\n",
       "      <td>aempe pluit bataco raya pt/soek hatta</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194</th>\n",
       "      <td>tk 42 zahra, par</td>\n",
       "      <td>tk 42 zahra/parigi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>notaris dan ppat emmy halim, sh., mand utara</td>\n",
       "      <td>notaris dan ppat emmy halim, sh.mkn/mand utara</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199</th>\n",
       "      <td>beng spesia ac mobil ac rio, ling sala,</td>\n",
       "      <td>bengkel spesialist ac mobil ac rio/ling sala</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203</th>\n",
       "      <td>pahl no 6 dpc federasi lome sbsi,</td>\n",
       "      <td>dpc federasi lomenik sbsi/pahlawan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>205</th>\n",
       "      <td>ged bersau, pen 1</td>\n",
       "      <td>gedung bersaudara/pen 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>207</th>\n",
       "      <td>mie dan nasi gor pak doey, yos suda,</td>\n",
       "      <td>mie dan nasi goreng pak doey/yos sudarso</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>220</th>\n",
       "      <td>war sahabat raya bukit tingg</td>\n",
       "      <td>warung sahabat/raya bukit tingg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>221</th>\n",
       "      <td>waro bakso bunda pampangan, pampangan</td>\n",
       "      <td>waroeng bakso bunda pampangan/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225</th>\n",
       "      <td>duren tiga graha mamp 2nd floor raya mamp prap 100 rt 2 1 pancoran</td>\n",
       "      <td>graha mampang, 2nd floor raya/mamp prap</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>227</th>\n",
       "      <td>wisnu elektr, raya maja ranca, bojongloa rancaekek</td>\n",
       "      <td>wisnu elektronika/raya maja ranca</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>237</th>\n",
       "      <td>headmost bkl, putri gad cemp,</td>\n",
       "      <td>headmost bkl/putri gad cempaka</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241</th>\n",
       "      <td>sayur segar dan semb ibu sur parangt, brontokusuman mantrijeron</td>\n",
       "      <td>sayur segar dan sembako ibu sur/parangtritis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>242</th>\n",
       "      <td>kan desa sumur musuk boyolali</td>\n",
       "      <td>kantor desa sumur musuk boyolali/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>251</th>\n",
       "      <td>rumah cuci ria cemp besar, mawar banjarmasin tengah</td>\n",
       "      <td>rumah cuci rianda/cemp besar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>252</th>\n",
       "      <td>ba terp an nur, lemahwungkuk</td>\n",
       "      <td>ba terpadu an nur/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>255</th>\n",
       "      <td>kan bupati asa mekar baru</td>\n",
       "      <td>kantor bupati asahan/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>259</th>\n",
       "      <td>raya pon benda, war nasi cipunjur,</td>\n",
       "      <td>warung nasi cipunjur/raya pon benda</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>265</th>\n",
       "      <td>tb. kenc, pulau sula</td>\n",
       "      <td>tb. kencana/pulau sula</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>266</th>\n",
       "      <td>t-sh design store, vete cilacap selatan</td>\n",
       "      <td>t-shirt design store/vete</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>275</th>\n",
       "      <td>she bea hair and spa, dr. soet, no 19c sungai bangkong pontianak kota</td>\n",
       "      <td>she beauty hair and spa/dr. soet</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>287</th>\n",
       "      <td>jaja polet dan vari, k h abdul halim majalengka kulon majalengka</td>\n",
       "      <td>jaja polet dan variasi/k h abdul halim</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>288</th>\n",
       "      <td>indocar</td>\n",
       "      <td>indocarpenter/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289</th>\n",
       "      <td>puskesmas mekar, prof. dr. ir. sut, mekar sari rangkasbitung</td>\n",
       "      <td>puskesmas mekarsari/prof. dr. ir. sut</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>297</th>\n",
       "      <td>toko tyana modi, klepu kranggan</td>\n",
       "      <td>toko tyana modiste/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>302</th>\n",
       "      <td>jaya makh konsu, adonis samad, panarung pahandut</td>\n",
       "      <td>jaya makhasi konsultan/adonis samad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>306</th>\n",
       "      <td>west union, hus sast, no 194 rw 8</td>\n",
       "      <td>/hus sastran</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>308</th>\n",
       "      <td>al barokah serv motor, stas ker api</td>\n",
       "      <td>al barokah service motor/stas ker api</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>315</th>\n",
       "      <td>pab dolomit maros, tenrigangkae mandai</td>\n",
       "      <td>pabrik dolomit maros/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>317</th>\n",
       "      <td>pulori, no ar1 7 gamisalila hijab store, jaka setia</td>\n",
       "      <td>gamisalila hijab store/puloriburit</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>323</th>\n",
       "      <td>kawat pena batu, tanah merdeka,</td>\n",
       "      <td>kawat penahan batu/tanah merdeka</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>326</th>\n",
       "      <td>kedai lup 22, tol waru jua rw 9</td>\n",
       "      <td>kedai lupita 22/tol waru jua</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>327</th>\n",
       "      <td>kar utara banyumanik</td>\n",
       "      <td>/karang utara</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>328</th>\n",
       "      <td>rumah makan citra panyileukan komp bumi panyileukan, cipadung kidul panyileukan</td>\n",
       "      <td>rumah makan citra panyileukan/komplek bumi panyileukan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>331</th>\n",
       "      <td>mush pare plosoklaten</td>\n",
       "      <td>musholla/pare</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>342</th>\n",
       "      <td>cosmat kejak</td>\n",
       "      <td>cosmaterial/kejak</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>346</th>\n",
       "      <td>lom vape store, sriwi mataram</td>\n",
       "      <td>lombok vape store/sriwi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>347</th>\n",
       "      <td>sam ratul, k'kini kor &amp; indonesian restoran, ranowangko</td>\n",
       "      <td>k'kini korean &amp; indonesian restoran/sam ratul</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>357</th>\n",
       "      <td>chat terasutra bogor, pajaj indah ii,</td>\n",
       "      <td>chatime terasutra bogor/pajaj indah ii</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>363</th>\n",
       "      <td>maka d5, cipu 1, kebayoran lama</td>\n",
       "      <td>makaroni d5/cipu 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>366</th>\n",
       "      <td>dpc asosiasi kontraktor lis, kolo sugi,</td>\n",
       "      <td>dpc asosiasi kontraktor listri/kolo sugi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>370</th>\n",
       "      <td>ad sandi cakra prat pt, pulau karam, kampung pondok</td>\n",
       "      <td>ad sandi cakra pratama. pt/pulau karam</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>372</th>\n",
       "      <td>slta kart, budi kemul, kampung pelita</td>\n",
       "      <td>slta kartini/budi kemul</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>386</th>\n",
       "      <td>nur cho,</td>\n",
       "      <td>nur cholis/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>387</th>\n",
       "      <td>dony batu, bek barat rawa bunga</td>\n",
       "      <td>dony baturaja/bek barat</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>392</th>\n",
       "      <td>segar hara, bukit tung</td>\n",
       "      <td>segar harapan/bukit tung</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393</th>\n",
       "      <td>miftahul jan,</td>\n",
       "      <td>miftahul jannah/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>394</th>\n",
       "      <td>arni souv, porong</td>\n",
       "      <td>arni souvenir/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>399</th>\n",
       "      <td>sekretariat uppkh kecamatan suko jend gatot subr,</td>\n",
       "      <td>sekretariat uppkh kecamatan sukodono/jend gatot subroto</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>405</th>\n",
       "      <td>toko coun handphone raya kalija, kalijati</td>\n",
       "      <td>toko counter handphone/raya kalijati-p</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>411</th>\n",
       "      <td>cleine appa, simo gun i sawahan</td>\n",
       "      <td>cleine apparel/simo gun i</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>424</th>\n",
       "      <td>kan upk,</td>\n",
       "      <td>kantor upk/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>436</th>\n",
       "      <td>taman chem jati, pangkalanjati cinere</td>\n",
       "      <td>taman chempuck/jati</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>440</th>\n",
       "      <td>ayam penyet, r. wol mongin, bahu</td>\n",
       "      <td>ayam penyet/r. wol monginsidi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>444</th>\n",
       "      <td>war fikri, maulana yusuf,</td>\n",
       "      <td>warteg fikri/maulana yusuf</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>446</th>\n",
       "      <td>sd neg ngembeh i, maysend h. soem, ngembeh</td>\n",
       "      <td>sd negeri ngembeh i/maysend h. soem</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>459</th>\n",
       "      <td>votw co store, waturen, panjer</td>\n",
       "      <td>votw co store/waturenggong</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>468</th>\n",
       "      <td>dok wahi no 46 noyontaan rw 6 pekalongan timur</td>\n",
       "      <td>/dok wahidin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>469</th>\n",
       "      <td>maxime ren kam sragen-,</td>\n",
       "      <td>maxime rental kamera/sragen-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473</th>\n",
       "      <td>toko wad, peta no 54 bojongloa kaler</td>\n",
       "      <td>toko wadomi/peta</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>490</th>\n",
       "      <td>sem 1, no 278 toi pertamina,</td>\n",
       "      <td>toilet pertamina/sem 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>492</th>\n",
       "      <td>edow cof, ngunut ngunut</td>\n",
       "      <td>edow coffee/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>494</th>\n",
       "      <td>balige fash,</td>\n",
       "      <td>balige fashion/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>495</th>\n",
       "      <td>bag resort,</td>\n",
       "      <td>baguna resort/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>496</th>\n",
       "      <td>toko sol, moch toha muka</td>\n",
       "      <td>toko soleha/moch toha</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                                 raw_address  \\\n",
       "10                                            cikahuripan sd neg boj 02 klap boj, no 5 16877   \n",
       "11                                                                              yaya atohar,   \n",
       "20                                                                            toko bang ajs,   \n",
       "40                                                     mar tabl metro iringmulyo metro timur   \n",
       "44                                                                         sd neg 12 anggrek   \n",
       "48                                                              rumah makan pela, raya jomb,   \n",
       "69                                                            cak 11 nagasari karawang barat   \n",
       "74                                                            rnd prin, gang pinak, sukarame   \n",
       "76                                          pp minhajutt, kh abdul manan, sumberberas muncar   \n",
       "77                                                                          tk islam daruss,   \n",
       "79                           kemb jepun, no 192 bint jaya ud, rw 1 bongkaran pabean cantikan   \n",
       "86                                             simpang tiga kah nasu no 112 28284 bukit raya   \n",
       "95                                                                            cau terr, gal,   \n",
       "100                                            kedai tenun jep senn, kota bumi, kebon melati   \n",
       "110                                                          cv. hin oto kenc, sido ii, q 29   \n",
       "117                                                                ahmad dah iv kukusan beji   \n",
       "118                                                 caval pizz, dip ukur, lebak gede coblong   \n",
       "128                                                                                    grey,   \n",
       "130                                                mangla rege no h1 3 cimekar kel. cileunyi   \n",
       "134                                                             beng las deny, mendalanwangi   \n",
       "135            cipinang besar selatan lintas ibadah, cipi jaya 1a no 3 rw 7 13410 jatinegara   \n",
       "137                                                                          ber nadah agung   \n",
       "138                                            sd bust islamiah, andi pang petta panakkukang   \n",
       "144                                         sd neg palumbungan 1, perum wirasana purbalingga   \n",
       "152                                 ujung harapan, no 48a pd. karya warga mand cimb, bahagia   \n",
       "155                                   prim warna dan rekan kembang jeruk iv, tlogosari kulon   \n",
       "157                                                              alun - alun kuli nusan, kar   \n",
       "161  kantor bupati tapa sela serma lian kos, wek ii padang sidempuan utara (padangsidimpuan)   \n",
       "166                                                                   smk karya pemban, pon,   \n",
       "169                                         taman mer, 13 electr laun system, 2 meruya utara   \n",
       "181                                            lelly bout, sum mekar babakan babakan ciparay   \n",
       "184                                                          pasi redjeki, man kerto v, mojo   \n",
       "187                                                stati accessories roxy mas, cideng gambir   \n",
       "188                                                kan desa sumber wangi tps 1, sumber wangi   \n",
       "190                                         pang rambut asgar raya kp utan setu, 32 cibitung   \n",
       "192                          aempe pluit bat raya pt, soek hatta, no 732 mekar mulya cinambo   \n",
       "194                                                                         tk 42 zahra, par   \n",
       "198                                             notaris dan ppat emmy halim, sh., mand utara   \n",
       "199                                                  beng spesia ac mobil ac rio, ling sala,   \n",
       "203                                                        pahl no 6 dpc federasi lome sbsi,   \n",
       "205                                                                        ged bersau, pen 1   \n",
       "207                                                     mie dan nasi gor pak doey, yos suda,   \n",
       "220                                                             war sahabat raya bukit tingg   \n",
       "221                                                    waro bakso bunda pampangan, pampangan   \n",
       "225                       duren tiga graha mamp 2nd floor raya mamp prap 100 rt 2 1 pancoran   \n",
       "227                                       wisnu elektr, raya maja ranca, bojongloa rancaekek   \n",
       "237                                                            headmost bkl, putri gad cemp,   \n",
       "241                          sayur segar dan semb ibu sur parangt, brontokusuman mantrijeron   \n",
       "242                                                            kan desa sumur musuk boyolali   \n",
       "251                                      rumah cuci ria cemp besar, mawar banjarmasin tengah   \n",
       "252                                                             ba terp an nur, lemahwungkuk   \n",
       "255                                                                kan bupati asa mekar baru   \n",
       "259                                                       raya pon benda, war nasi cipunjur,   \n",
       "265                                                                     tb. kenc, pulau sula   \n",
       "266                                                  t-sh design store, vete cilacap selatan   \n",
       "275                    she bea hair and spa, dr. soet, no 19c sungai bangkong pontianak kota   \n",
       "287                         jaja polet dan vari, k h abdul halim majalengka kulon majalengka   \n",
       "288                                                                                  indocar   \n",
       "289                             puskesmas mekar, prof. dr. ir. sut, mekar sari rangkasbitung   \n",
       "297                                                          toko tyana modi, klepu kranggan   \n",
       "302                                         jaya makh konsu, adonis samad, panarung pahandut   \n",
       "306                                                        west union, hus sast, no 194 rw 8   \n",
       "308                                                      al barokah serv motor, stas ker api   \n",
       "315                                                   pab dolomit maros, tenrigangkae mandai   \n",
       "317                                      pulori, no ar1 7 gamisalila hijab store, jaka setia   \n",
       "323                                                          kawat pena batu, tanah merdeka,   \n",
       "326                                                          kedai lup 22, tol waru jua rw 9   \n",
       "327                                                                     kar utara banyumanik   \n",
       "328          rumah makan citra panyileukan komp bumi panyileukan, cipadung kidul panyileukan   \n",
       "331                                                                    mush pare plosoklaten   \n",
       "342                                                                             cosmat kejak   \n",
       "346                                                            lom vape store, sriwi mataram   \n",
       "347                                  sam ratul, k'kini kor & indonesian restoran, ranowangko   \n",
       "357                                                    chat terasutra bogor, pajaj indah ii,   \n",
       "363                                                          maka d5, cipu 1, kebayoran lama   \n",
       "366                                                  dpc asosiasi kontraktor lis, kolo sugi,   \n",
       "370                                      ad sandi cakra prat pt, pulau karam, kampung pondok   \n",
       "372                                                    slta kart, budi kemul, kampung pelita   \n",
       "386                                                                                 nur cho,   \n",
       "387                                                          dony batu, bek barat rawa bunga   \n",
       "392                                                                   segar hara, bukit tung   \n",
       "393                                                                            miftahul jan,   \n",
       "394                                                                        arni souv, porong   \n",
       "399                                        sekretariat uppkh kecamatan suko jend gatot subr,   \n",
       "405                                                toko coun handphone raya kalija, kalijati   \n",
       "411                                                          cleine appa, simo gun i sawahan   \n",
       "424                                                                                 kan upk,   \n",
       "436                                                    taman chem jati, pangkalanjati cinere   \n",
       "440                                                         ayam penyet, r. wol mongin, bahu   \n",
       "444                                                                war fikri, maulana yusuf,   \n",
       "446                                               sd neg ngembeh i, maysend h. soem, ngembeh   \n",
       "459                                                           votw co store, waturen, panjer   \n",
       "468                                           dok wahi no 46 noyontaan rw 6 pekalongan timur   \n",
       "469                                                                  maxime ren kam sragen-,   \n",
       "473                                                     toko wad, peta no 54 bojongloa kaler   \n",
       "490                                                             sem 1, no 278 toi pertamina,   \n",
       "492                                                                  edow cof, ngunut ngunut   \n",
       "494                                                                             balige fash,   \n",
       "495                                                                              bag resort,   \n",
       "496                                                                 toko sol, moch toha muka   \n",
       "\n",
       "                                                  POI/street  \n",
       "10                              sd negeri bojong 02/klap boj  \n",
       "11                                       yayasan atohariyah/  \n",
       "20                                        toko bangunan ajs/  \n",
       "40                                     markaz tabligh metro/  \n",
       "44                                     sd negeri 12 anggrek/  \n",
       "48                             rumah makan pelangi/raya jomb  \n",
       "69                                                   /cakrad  \n",
       "74                                   rnd printing/gang pinak  \n",
       "76                         pp minhajutthollab/kh abdul manan  \n",
       "77                                      tk islam darussalam/  \n",
       "79                                bintang jaya ud/kemb jepun  \n",
       "86                                              /kaharu nasu  \n",
       "95                                        causal terrace/gal  \n",
       "100                    kedai tenun jepara sennaart/kota bumi  \n",
       "110                           cv. hingdi oto kencana/sido ii  \n",
       "117                                         /ahmad dahlan iv  \n",
       "118                              cavallino pizzaria/dip ukur  \n",
       "128                                                 grey101/  \n",
       "130                                         /manglayang rege  \n",
       "134                                        bengkel las deny/  \n",
       "135                           lintas ibadah/cipinang jaya 1a  \n",
       "137                                      berkat nadah agung/  \n",
       "138                     sd bustanul islamiah/andi pang petta  \n",
       "144                   sd negeri palumbungan 1/perum wirasana  \n",
       "152               pd. karya warga mandiri cimb/ujung harapan  \n",
       "155                primaadi warna dan rekan/kembang jeruk iv  \n",
       "157                        alun - alun kuliner nusantara/kar  \n",
       "161            kantor bupati tapanuli selatan/serma lian kos  \n",
       "166                                smk karya pembangunan/pon  \n",
       "169                   electrolux laundry system/taman meruya  \n",
       "181                                 lelly boutique/sum mekar  \n",
       "184                          pasifik redjeki/man kertoarjo v  \n",
       "187                           station88 accessories/roxy mas  \n",
       "188                          kantor desa sumber wangi tps 1/  \n",
       "190                   pangkas rambut asgar/raya kp utan setu  \n",
       "192                    aempe pluit bataco raya pt/soek hatta  \n",
       "194                                       tk 42 zahra/parigi  \n",
       "198           notaris dan ppat emmy halim, sh.mkn/mand utara  \n",
       "199             bengkel spesialist ac mobil ac rio/ling sala  \n",
       "203                       dpc federasi lomenik sbsi/pahlawan  \n",
       "205                                  gedung bersaudara/pen 1  \n",
       "207                 mie dan nasi goreng pak doey/yos sudarso  \n",
       "220                          warung sahabat/raya bukit tingg  \n",
       "221                           waroeng bakso bunda pampangan/  \n",
       "225                  graha mampang, 2nd floor raya/mamp prap  \n",
       "227                        wisnu elektronika/raya maja ranca  \n",
       "237                           headmost bkl/putri gad cempaka  \n",
       "241             sayur segar dan sembako ibu sur/parangtritis  \n",
       "242                        kantor desa sumur musuk boyolali/  \n",
       "251                             rumah cuci rianda/cemp besar  \n",
       "252                                       ba terpadu an nur/  \n",
       "255                                    kantor bupati asahan/  \n",
       "259                      warung nasi cipunjur/raya pon benda  \n",
       "265                                   tb. kencana/pulau sula  \n",
       "266                                t-shirt design store/vete  \n",
       "275                         she beauty hair and spa/dr. soet  \n",
       "287                   jaja polet dan variasi/k h abdul halim  \n",
       "288                                           indocarpenter/  \n",
       "289                    puskesmas mekarsari/prof. dr. ir. sut  \n",
       "297                                      toko tyana modiste/  \n",
       "302                      jaya makhasi konsultan/adonis samad  \n",
       "306                                             /hus sastran  \n",
       "308                    al barokah service motor/stas ker api  \n",
       "315                                    pabrik dolomit maros/  \n",
       "317                       gamisalila hijab store/puloriburit  \n",
       "323                         kawat penahan batu/tanah merdeka  \n",
       "326                             kedai lupita 22/tol waru jua  \n",
       "327                                            /karang utara  \n",
       "328   rumah makan citra panyileukan/komplek bumi panyileukan  \n",
       "331                                            musholla/pare  \n",
       "342                                        cosmaterial/kejak  \n",
       "346                                  lombok vape store/sriwi  \n",
       "347            k'kini korean & indonesian restoran/sam ratul  \n",
       "357                   chatime terasutra bogor/pajaj indah ii  \n",
       "363                                       makaroni d5/cipu 1  \n",
       "366                 dpc asosiasi kontraktor listri/kolo sugi  \n",
       "370                   ad sandi cakra pratama. pt/pulau karam  \n",
       "372                                  slta kartini/budi kemul  \n",
       "386                                              nur cholis/  \n",
       "387                                  dony baturaja/bek barat  \n",
       "392                                 segar harapan/bukit tung  \n",
       "393                                         miftahul jannah/  \n",
       "394                                           arni souvenir/  \n",
       "399  sekretariat uppkh kecamatan sukodono/jend gatot subroto  \n",
       "405                   toko counter handphone/raya kalijati-p  \n",
       "411                                cleine apparel/simo gun i  \n",
       "424                                              kantor upk/  \n",
       "436                                      taman chempuck/jati  \n",
       "440                            ayam penyet/r. wol monginsidi  \n",
       "444                               warteg fikri/maulana yusuf  \n",
       "446                      sd negeri ngembeh i/maysend h. soem  \n",
       "459                               votw co store/waturenggong  \n",
       "468                                             /dok wahidin  \n",
       "469                             maxime rental kamera/sragen-  \n",
       "473                                         toko wadomi/peta  \n",
       "490                                   toilet pertamina/sem 1  \n",
       "492                                             edow coffee/  \n",
       "494                                          balige fashion/  \n",
       "495                                           baguna resort/  \n",
       "496                                    toko soleha/moch toha  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# all rows with incomplete address\n",
    "pd.set_option('display.max_rows', 100)\n",
    "pd.set_option('max_colwidth', 400)\n",
    "incomplete_address.head(100)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "satisfied-friendly",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-03-20T01:06:21.781115Z",
     "start_time": "2021-03-20T01:06:21.533777Z"
    }
   },
   "outputs": [],
   "source": [
    "all_poi = np.unique(df['POI'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "suitable-question",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-03-20T01:06:22.993871Z",
     "start_time": "2021-03-20T01:06:22.980905Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "True"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "'sd negeri bojong 02' in all_poi"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "detected-defensive",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-03-20T01:06:24.713270Z",
     "start_time": "2021-03-20T01:06:24.346253Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "95123"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(np.unique(df['street']))"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "pleased-synthetic",
   "metadata": {},
   "source": [
    "## Experiments"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "corresponding-astronomy",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-03-20T01:09:11.504097Z",
     "start_time": "2021-03-20T01:09:10.817933Z"
    }
   },
   "outputs": [],
   "source": [
    "from fast_autocomplete import AutoComplete"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "european-theater",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-03-20T01:09:26.602706Z",
     "start_time": "2021-03-20T01:09:26.573783Z"
    }
   },
   "outputs": [],
   "source": [
    "all_poi = sorted(all_poi)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "instant-system",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-03-20T01:10:39.835794Z",
     "start_time": "2021-03-20T01:10:39.773959Z"
    }
   },
   "outputs": [],
   "source": [
    "all_poi_dict = dict()\n",
    "for poi in all_poi:\n",
    "    all_poi_dict[poi] = {}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "later-quality",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-03-20T01:12:32.791646Z",
     "start_time": "2021-03-20T01:12:32.753747Z"
    },
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'': {},\n",
       " '\"taman pemuda\"': {},\n",
       " '# jagakarsa': {},\n",
       " '# jakarta': {},\n",
       " '# jatirahayu': {},\n",
       " '# kali malang': {},\n",
       " '# pasar rebo': {},\n",
       " \"'arina cell & laundry\": {},\n",
       " '(depan': {},\n",
       " '(masuk kampus stkip)': {},\n",
       " '(pintu belakang)': {},\n",
       " '01 \"kantor': {},\n",
       " '02 mart': {},\n",
       " '07 cell': {},\n",
       " '0ncez shop': {},\n",
       " '1 stations': {},\n",
       " '1.4.6 kids': {},\n",
       " \"10 ten's\": {},\n",
       " '100) lotte mart': {},\n",
       " '1001 cctv': {},\n",
       " '117 rental mobil': {},\n",
       " '126 cellular': {},\n",
       " '16 car wash': {},\n",
       " '17 mie ayam bengkel': {},\n",
       " '18 elektronik': {},\n",
       " '182 cell': {},\n",
       " '19 distro box': {},\n",
       " '1999 cell': {},\n",
       " '1a crispy puff': {},\n",
       " '1ciganjur': {},\n",
       " '1mt tutup jam 20:00 wib, warung bu, kp tonggoh rt02 01 desa gunung sari kecamatan citeureup': {},\n",
       " '1perumahan bukit waringin': {},\n",
       " '1st floor, b 110 - trans studio mall bandung': {},\n",
       " '1st home citraland': {},\n",
       " '2 diva': {},\n",
       " '2 serangkai cell': {},\n",
       " '2 tang finest tea': {},\n",
       " '2 x 11 kayu tanam': {},\n",
       " '20 fit': {},\n",
       " '2016 florist semarang': {},\n",
       " '21 cell': {},\n",
       " '21 cinema': {},\n",
       " '21 cineplex': {},\n",
       " '21 express': {},\n",
       " '21 tk sulaeman': {},\n",
       " '212 laundry': {},\n",
       " '212 mart': {},\n",
       " '212 mart jatiasih': {},\n",
       " '216 store': {},\n",
       " '22 twenty two salon': {},\n",
       " '23 maticshop dan sabrina cell': {},\n",
       " '28 cellular': {},\n",
       " '28 dyva hotel': {},\n",
       " '29 cell-ho': {},\n",
       " '29 electronik': {},\n",
       " '29coffeeshop': {},\n",
       " '2b logistics': {},\n",
       " '2l salon and makeup': {},\n",
       " '2m 2mb patokan masuk dr': {},\n",
       " '2m buka 24 jam': {},\n",
       " '2nd floor gedung multy purpose uin sunan kalijaga': {},\n",
       " '2nr autoworks': {},\n",
       " '2nti cybergame': {},\n",
       " '2r computer': {},\n",
       " '2r motor service': {},\n",
       " '2rparty.com': {},\n",
       " '2t net': {},\n",
       " '3 d cell': {},\n",
       " '3 diva': {},\n",
       " '3 g resort': {},\n",
       " '3 in 1': {},\n",
       " '3 jaya ban': {},\n",
       " '3 jaya palstik': {},\n",
       " '3 key salon and spa': {},\n",
       " '3 princess ocean view hotel': {},\n",
       " '3 putra': {},\n",
       " '3 putri ps toko kebutuhan ternak': {},\n",
       " '3 r aluminium': {},\n",
       " '3 saudara ponsel': {},\n",
       " '33 cell': {},\n",
       " '33 rumah makan': {},\n",
       " '33 toko': {},\n",
       " '33 truly': {},\n",
       " '333 computer': {},\n",
       " '35 net': {},\n",
       " '35 nett': {},\n",
       " '354 laundry kiloan pdk kelapa': {},\n",
       " '36 motor': {},\n",
       " '369 billyard': {},\n",
       " '389 cellular': {},\n",
       " '38th floor, pacific century place': {},\n",
       " '39 motor. pd': {},\n",
       " '3d baby print': {},\n",
       " '3d balloon -ho': {},\n",
       " '3d studio foto': {},\n",
       " '3d3n frozen food': {},\n",
       " '3f laundry': {},\n",
       " '3g cell': {},\n",
       " '3g power': {},\n",
       " '3guitar solo': {},\n",
       " '3i networks': {},\n",
       " '3m cuci motor': {},\n",
       " '3net': {},\n",
       " '3r parris': {},\n",
       " '3rd-4th floor gedung sekolah pascasarjana ugm': {},\n",
       " '3s group': {},\n",
       " '3s house bali': {},\n",
       " '3second': {},\n",
       " '3second margocity': {},\n",
       " '4 bulan ustad hamzah': {},\n",
       " '4 sekawan car wash': {},\n",
       " '41 toko': {},\n",
       " '44 car wash': {},\n",
       " '44 trans': {},\n",
       " '45': {},\n",
       " '45 auto cafe & resto': {},\n",
       " '45 fitnes': {},\n",
       " '45 gudang': {},\n",
       " '45 residence': {},\n",
       " '45 toko': {},\n",
       " '459 street coffeeshop & cafe': {},\n",
       " '45hefa ponsel ii': {},\n",
       " '46 net': {},\n",
       " '48 cell': {},\n",
       " '49 english course': {},\n",
       " '4g cell': {},\n",
       " '4g cellular': {},\n",
       " '4g centre': {},\n",
       " '4g gemstone': {},\n",
       " '4x parts': {},\n",
       " '5 photo': {},\n",
       " '5 yogya-solo': {},\n",
       " '51 belakang, bidan dwi dan madrasah asyiratul umaru': {},\n",
       " '527 studio music': {},\n",
       " '531 - hokben rk jt pdg': {},\n",
       " '547 cell': {},\n",
       " '555': {},\n",
       " '555 kamboja depot': {},\n",
       " '5578 cell': {},\n",
       " '565 laundry': {},\n",
       " '57 computer': {},\n",
       " '57 jaya furniture': {},\n",
       " '5758 cell': {},\n",
       " '5758 parfume colection': {},\n",
       " '5758 tour and rent car': {},\n",
       " '58 mapan': {},\n",
       " '59 ponsel': {},\n",
       " '6 komplek kimia farma ii': {},\n",
       " '60 toko': {},\n",
       " '628 tini': {},\n",
       " '63': {},\n",
       " '66 toko': {},\n",
       " '666 cell': {},\n",
       " '671 toko': {},\n",
       " '68 computer': {},\n",
       " '68 vapor bar n resto': {},\n",
       " '699 mobil': {},\n",
       " '7 camera purwokerto': {},\n",
       " '7 eleven': {},\n",
       " '7 lines holiday cirebon': {},\n",
       " '7-eleven': {},\n",
       " '70 dusun krajan kidul': {},\n",
       " '73photoworks': {},\n",
       " '752 driving golf': {},\n",
       " '76 cafe': {},\n",
       " '77 electronic toko': {},\n",
       " '77 toko': {},\n",
       " '77 variasi': {},\n",
       " '78 fhoto copy': {},\n",
       " '79 cold ac spesialis': {},\n",
       " '7dials coffee': {},\n",
       " '7flowers': {},\n",
       " '7r bu reni': {},\n",
       " '7th floor mandiri building': {},\n",
       " '8 babadan': {},\n",
       " '8 blok oj': {},\n",
       " '8 istana profil': {},\n",
       " '8 perum mustika karang satria': {},\n",
       " '81 cellular': {},\n",
       " '83 cell': {},\n",
       " '838 frozen food': {},\n",
       " '86 cell': {},\n",
       " '86 studio': {},\n",
       " '86 vape corner': {},\n",
       " '87 cuci sepatu tas helm jacket jayapura': {},\n",
       " '88': {},\n",
       " '88 auto care-ho': {},\n",
       " '88 cell': {},\n",
       " '88 fashion': {},\n",
       " '88 motor': {},\n",
       " '888 phone cell': {},\n",
       " '88th street': {},\n",
       " '8oss mobil': {},\n",
       " '8treasures jakarta': {},\n",
       " '8war.net': {},\n",
       " '9 kuda mas': {},\n",
       " '91 coffee shop': {},\n",
       " '91 toko tas import-ho': {},\n",
       " '91net': {},\n",
       " '928 art dan antique': {},\n",
       " '929 gordyn': {},\n",
       " '96shop': {},\n",
       " '99 aluminium': {},\n",
       " '99 cling': {},\n",
       " '99 games': {},\n",
       " '99 laundry dan chem': {},\n",
       " '99 perus': {},\n",
       " '99 security professional system. pt': {},\n",
       " '999 erna cake': {},\n",
       " '99ers coffee': {},\n",
       " '99studioart - kado ilustrasi wajah': {},\n",
       " '@lobby hotel sheraton': {},\n",
       " '@niek homestay dan gallery': {},\n",
       " 'a & k': {},\n",
       " 'a atalanta': {},\n",
       " 'a bangkol': {},\n",
       " 'a belakang': {},\n",
       " 'a boutique': {},\n",
       " 'a bun tailor': {},\n",
       " 'a cell': {},\n",
       " 'a chafid': {},\n",
       " 'a collection': {},\n",
       " 'a dan b auto repair': {},\n",
       " 'a dan m snack coffee': {},\n",
       " 'a dan r jaya': {},\n",
       " 'a dan t cell': {},\n",
       " 'a four': {},\n",
       " 'a k tehnik listrik': {},\n",
       " 'a kadir toko': {},\n",
       " 'a kasoem cikini optika': {},\n",
       " 'a kasoem hearing centre': {},\n",
       " 'a kasoem optical': {},\n",
       " 'a kasoem optikal': {},\n",
       " 'a konveksi house': {},\n",
       " 'a ngop pujasera': {},\n",
       " 'a r i barbershop': {},\n",
       " 'a to z bar, wine, brasserie': {},\n",
       " 'a tong dinamo': {},\n",
       " 'a villa ubud bali by uhm': {},\n",
       " 'a x perfume': {},\n",
       " 'a&a property citraland': {},\n",
       " 'a&e collection': {},\n",
       " 'a&w': {},\n",
       " 'a&w leather seat': {},\n",
       " 'a&wan jaya motor': {},\n",
       " \"a'a gym\": {},\n",
       " \"a'siek ngopi\": {},\n",
       " 'a+coffee - es kopi rumahan': {},\n",
       " 'a- huang shop': {},\n",
       " 'a-yang': {},\n",
       " 'a-yong': {},\n",
       " 'a. azis': {},\n",
       " 'a. berkah pasti jaya': {},\n",
       " 'a. efendi': {},\n",
       " 'a. kasoem cikini': {},\n",
       " 'a. nasution': {},\n",
       " 'a. suriani': {},\n",
       " 'a.a. ngurah sutama': {},\n",
       " 'a.a.a. busana tradisional dan tata rias bali': {},\n",
       " 'a.j. central asia raya. pt': {},\n",
       " 'a.n purnomo': {},\n",
       " 'a.p.o distrik': {},\n",
       " 'a.s vape': {},\n",
       " 'a1 crispy fried chicken': {},\n",
       " 'a1 toko': {},\n",
       " 'a2 laundry': {},\n",
       " 'a3 cell': {},\n",
       " 'a6, perkantoran': {},\n",
       " 'a8 jasa setrika uap': {},\n",
       " 'a_dewe ban': {},\n",
       " 'aa ac': {},\n",
       " 'aa agen bus citra adi lancar': {},\n",
       " 'aa agen telor': {},\n",
       " 'aa bakery': {},\n",
       " 'aa bonsai': {},\n",
       " 'aa busana': {},\n",
       " 'aa cell': {},\n",
       " 'aa cv': {},\n",
       " 'aa decoration': {},\n",
       " 'aa decoration ud': {},\n",
       " 'aa florest': {},\n",
       " 'aa gordyn': {},\n",
       " 'aa ikat kasep': {},\n",
       " 'aa jayatex toko': {},\n",
       " 'aa mart mini market': {},\n",
       " 'aa parabot collection': {},\n",
       " 'aa photoworks studio': {},\n",
       " 'aa racing': {},\n",
       " 'aa studio foto': {},\n",
       " 'aa tenda': {},\n",
       " 'aa toko': {},\n",
       " 'aa travel': {},\n",
       " 'aa ud': {},\n",
       " 'aab cell': {},\n",
       " 'aad maheri': {},\n",
       " 'aad surya': {},\n",
       " 'aafil jaya': {},\n",
       " 'aal printing': {},\n",
       " 'aam sport': {},\n",
       " 'aamirah florist': {},\n",
       " 'aan bengkel mobil': {},\n",
       " 'aan bersaudara': {},\n",
       " 'aan cell': {},\n",
       " 'aan kopi 2': {},\n",
       " 'aan s': {},\n",
       " 'aan seluler': {},\n",
       " 'aan servis tv': {},\n",
       " 'aan suharno': {},\n",
       " 'aan waroeng and caffe': {},\n",
       " 'aang warung': {},\n",
       " 'aanugrah adi sembako': {},\n",
       " 'aarcpulau tidung': {},\n",
       " 'aaron playstation 3': {},\n",
       " 'aat cellular': {},\n",
       " 'ab cell': {},\n",
       " 'ab cellular kandangan': {},\n",
       " 'ab computer': {},\n",
       " 'ab ponsel': {},\n",
       " 'ab pro lighting dan studio record': {},\n",
       " 'ab q-lap car wash': {},\n",
       " 'ab sat 16': {},\n",
       " 'ab skatepark': {},\n",
       " 'ab surf skate clothing': {},\n",
       " 'aba ama': {},\n",
       " 'aba firdaus collection': {},\n",
       " 'aba penginapan': {},\n",
       " 'ababil tour and travel': {},\n",
       " 'abacus distribution systems indonesia, pt': {},\n",
       " 'abad dua satu eng cons cv': {},\n",
       " 'abadi': {},\n",
       " 'abadi 1': {},\n",
       " 'abadi 2': {},\n",
       " 'abadi bahagia citra pt': {},\n",
       " 'abadi bakso': {},\n",
       " 'abadi cellular': {},\n",
       " 'abadi collection': {},\n",
       " 'abadi diesel': {},\n",
       " 'abadi furniture': {},\n",
       " 'abadi game': {},\n",
       " 'abadi genteng': {},\n",
       " 'abadi genteng jatiwangi': {},\n",
       " 'abadi gypsum': {},\n",
       " 'abadi hotel yogyakarta': {},\n",
       " 'abadi interior': {},\n",
       " 'abadi jaya': {},\n",
       " 'abadi jaya 2': {},\n",
       " 'abadi jaya foto copy': {},\n",
       " 'abadi jaya listrik-ho': {},\n",
       " 'abadi jaya motor': {},\n",
       " 'abadi jaya perabot': {},\n",
       " 'abadi jaya toko': {},\n",
       " 'abadi juice': {},\n",
       " 'abadi karunia sound system dan genset': {},\n",
       " 'abadi manunggal jaya': {},\n",
       " 'abadi minang': {},\n",
       " 'abadi motor': {},\n",
       " 'abadi mukti pt': {},\n",
       " 'abadi music': {},\n",
       " 'abadi photo studio': {},\n",
       " 'abadi pt': {},\n",
       " 'abadi purwa citra': {},\n",
       " 'abadi smilynks pt': {},\n",
       " 'abadi susu': {},\n",
       " 'abadi tehnik': {},\n",
       " 'abadi toko': {},\n",
       " 'abadi tour': {},\n",
       " 'abadi ud': {},\n",
       " 'abadi. cv': {},\n",
       " 'abadi. ud': {},\n",
       " 'abaditour pekalongan': {},\n",
       " 'abah anang': {},\n",
       " 'abah faim': {},\n",
       " 'abah liong': {},\n",
       " 'abah meubel': {},\n",
       " 'abah net': {},\n",
       " 'abah udin': {},\n",
       " 'abang': {},\n",
       " 'abang adek': {},\n",
       " 'abang ban motor': {},\n",
       " 'abang cell': {},\n",
       " 'abas': {},\n",
       " 'abas arloji': {},\n",
       " 'abas baru cell': {},\n",
       " 'abason baby product industry. pt': {},\n",
       " 'abata fotokopi': {},\n",
       " 'abay net': {},\n",
       " 'abbasy': {},\n",
       " 'abbel': {},\n",
       " 'abbussalam': {},\n",
       " 'abby muslim shop': {},\n",
       " 'abc': {},\n",
       " 'abc contractor. cv': {},\n",
       " 'abc energy': {},\n",
       " 'abc galery': {},\n",
       " 'abc school': {},\n",
       " 'abd haris': {},\n",
       " 'abd. hadi': {},\n",
       " 'abd. rauf dg madang': {},\n",
       " 'abd. razaq': {},\n",
       " 'abdee fishing team 86': {},\n",
       " 'abdi agung distributor atk harga termurah': {},\n",
       " 'abdi cell': {},\n",
       " 'abdi medicca bumbak': {},\n",
       " 'abdi tour and travel': {},\n",
       " 'abdrochim servis': {},\n",
       " 'abdul ajid': {},\n",
       " 'abdul basir latuconsina & partners': {},\n",
       " 'abdul ghany motor': {},\n",
       " 'abdul goni': {},\n",
       " 'abdul hadi': {},\n",
       " 'abdul hafiz': {},\n",
       " 'abdul hakim keliat, s.h. & rekan': {},\n",
       " 'abdul haris': {},\n",
       " 'abdul holil': {},\n",
       " 'abdul jalil layangan': {},\n",
       " 'abdul kadir': {},\n",
       " 'abdul karim': {},\n",
       " 'abdul kohar': {},\n",
       " \"abdul ma'at\": {},\n",
       " 'abdul manan': {},\n",
       " 'abdul qodir and partners law firm': {},\n",
       " 'abdul rahman tuhepaly, s.h. & partners': {},\n",
       " 'abdul roni': {},\n",
       " 'abdul wachit servis lampu gundi': {},\n",
       " 'abdul wahab': {},\n",
       " 'abdul wahid': {},\n",
       " 'abdullah ali bin tamim': {},\n",
       " 'abdullah books store': {},\n",
       " 'abdullah cell': {},\n",
       " 'abdullah furniture': {},\n",
       " 'abdullah thalib sh': {},\n",
       " 'abe celluler': {},\n",
       " 'abe chicken cirebon': {},\n",
       " 'abe cw': {},\n",
       " 'abe food station': {},\n",
       " 'abellatin salon dan beauty care': {},\n",
       " 'abeng fashion': {},\n",
       " 'abeng toko': {},\n",
       " 'abeta cell': {},\n",
       " 'abez zone': {},\n",
       " 'abg': {},\n",
       " 'abg sound system lighting': {},\n",
       " 'abg tailor': {},\n",
       " 'abhiseka computer': {},\n",
       " 'abi gorden dan wallpaper': {},\n",
       " 'abi jaya teknik': {},\n",
       " 'abi ponsel': {},\n",
       " 'abi shoes sport': {},\n",
       " 'abi zaen olshop': {},\n",
       " 'abid mesin': {},\n",
       " 'abidin': {},\n",
       " 'abidzar': {},\n",
       " 'abidzar led': {},\n",
       " 'abidzar parfum & laundry': {},\n",
       " 'abie cellular': {},\n",
       " 'abiee collection': {},\n",
       " 'abiel baby shop': {},\n",
       " 'abigoes laundry': {},\n",
       " 'abik': {},\n",
       " 'abika kebab': {},\n",
       " 'abil aksesoris': {},\n",
       " 'abil collection': {},\n",
       " 'abil kids': {},\n",
       " 'abil net': {},\n",
       " 'abim cell': {},\n",
       " 'abimanyu playstation': {},\n",
       " 'abion motor 3': {},\n",
       " 'abipina': {},\n",
       " 'abis': {},\n",
       " 'abitextile': {},\n",
       " 'abiyan olshop': {},\n",
       " 'abizar bird fram': {},\n",
       " 'abizhar': {},\n",
       " 'aboe laundry': {},\n",
       " 'abon ikan kerupuk ikan katebi aisyah': {},\n",
       " 'above padalarang train bridge': {},\n",
       " 'aboysnack': {},\n",
       " 'abpromosindo it event': {},\n",
       " 'abqary style': {},\n",
       " 'abr foto copy piccolo': {},\n",
       " 'abraham godjaja toko': {},\n",
       " 'abrakadabra art bnb': {},\n",
       " 'abrar reffil parfum praja': {},\n",
       " 'abrenx brenx village': {},\n",
       " 'abs bikers shop & mewa warkop': {},\n",
       " 'abs plaza auto': {},\n",
       " 'absolut catering': {},\n",
       " 'absolute badminton': {},\n",
       " 'absyar': {},\n",
       " 'abu homestay': {},\n",
       " 'abu husin2': {},\n",
       " 'abu kazzam collection': {},\n",
       " 'abu nimah sejahtera utama. pt': {},\n",
       " 'abu rifa': {},\n",
       " 'abu tailor': {},\n",
       " \"abu ya'amin\": {},\n",
       " 'abu zonera': {},\n",
       " 'abuba': {},\n",
       " 'abuba steak hrpn indah': {},\n",
       " 'abuhasdha & co ltd. pt': {},\n",
       " 'aby net': {},\n",
       " 'aby phone cell': {},\n",
       " 'abz guest house': {},\n",
       " 'ac cell': {},\n",
       " 'ac jaya mobil': {},\n",
       " 'ac kuesek': {},\n",
       " 'ac laly': {},\n",
       " 'ac merah putih': {},\n",
       " 'ac mobil': {},\n",
       " 'ac mobil 2000': {},\n",
       " 'ac mobil era raflesia': {},\n",
       " 'ac mobil pkc g2': {},\n",
       " 'ac mobil rafi': {},\n",
       " 'ac mubil': {},\n",
       " 'ac refrigeration part toko': {},\n",
       " 'ac rumah': {},\n",
       " 'ac sejuk denso': {},\n",
       " 'aca on line shop': {},\n",
       " 'acacia garden': {},\n",
       " 'acai': {},\n",
       " 'acak mandiri furniture': {},\n",
       " 'acasia fashion': {},\n",
       " 'acc': {},\n",
       " 'acc astra credit leasing': {},\n",
       " 'acc furniture': {},\n",
       " 'acc hape ku': {},\n",
       " 'acc hp': {},\n",
       " 'acc jaya jakarta': {},\n",
       " 'acc motor': {},\n",
       " 'acc tailor': {},\n",
       " 'acca kappa': {},\n",
       " 'accacia salon': {},\n",
       " 'accelera dsw tyres': {},\n",
       " 'accesories 28': {},\n",
       " 'accesories hp': {},\n",
       " 'access consulting': {},\n",
       " 'access net': {},\n",
       " 'accessories bycycle shop omkbike': {},\n",
       " 'accessories mobil autofal': {},\n",
       " 'accessories motor': {},\n",
       " 'accu brasil': {},\n",
       " 'accu empat putri': {},\n",
       " 'accu zr': {},\n",
       " 'accurate business centre': {},\n",
       " 'accurate jaya computer': {},\n",
       " 'accustic indah': {},\n",
       " 'ace': {},\n",
       " 'ace aswaer': {},\n",
       " 'ace computer champion': {},\n",
       " 'ace education': {},\n",
       " 'ace hardware': {},\n",
       " 'ace hardware - mutiara taman palem': {},\n",
       " 'ace hardware home center': {},\n",
       " 'ace hardware home center - living plaza bekasi': {},\n",
       " 'ace hardware indonesia': {},\n",
       " 'ace hardware indonesia pt': {},\n",
       " 'ace hardware kelapa gading': {},\n",
       " 'aceh coffee outlet': {},\n",
       " 'aceh inti timber co ltd pt': {},\n",
       " 'aceh mulia rumah makan': {},\n",
       " 'aceh rasa utama lingke': {},\n",
       " 'aceh toys gallery': {},\n",
       " 'acen': {},\n",
       " 'aceng cell': {},\n",
       " 'aceng collection': {},\n",
       " 'acep': {},\n",
       " 'acep distributor resmi nasa': {},\n",
       " 'acer': {},\n",
       " 'acer center': {},\n",
       " 'aces smartphone service': {},\n",
       " 'ach. fudali': {},\n",
       " 'ach. sumedi': {},\n",
       " 'acha': {},\n",
       " 'achilles': {},\n",
       " 'achilles service shocbreaker': {},\n",
       " 'achmad': {},\n",
       " 'achmad ardhi rozak': {},\n",
       " 'achmad aulia rachma': {},\n",
       " 'achmad faudzy house': {},\n",
       " 'achmad rasyid hisbullah dan jerry': {},\n",
       " 'achonk photo': {},\n",
       " 'achterhuis guest house semarang': {},\n",
       " 'aci bakmi singkawang': {},\n",
       " 'aci international indonesia': {},\n",
       " 'aciak salon': {},\n",
       " 'acien pok pia': {},\n",
       " 'acik motor': {},\n",
       " 'acil bungas': {},\n",
       " 'acil wadai': {},\n",
       " 'acing': {},\n",
       " 'aciwi shop': {},\n",
       " 'acochem indonesia': {},\n",
       " 'acong': {},\n",
       " 'acong kodok goreng': {},\n",
       " 'acong perkasa': {},\n",
       " 'aconk jaya gypsum': {},\n",
       " 'acp cargo': {},\n",
       " 'acropora cottage': {},\n",
       " 'acs seat covers': {},\n",
       " 'act kantor cabang sulawesi selatan': {},\n",
       " 'active 1 cell': {},\n",
       " 'active indonesia': {},\n",
       " 'actual computer': {},\n",
       " 'acu pindang': {},\n",
       " 'acuan': {},\n",
       " 'acun': {},\n",
       " 'acun toko': {},\n",
       " 'ad': {},\n",
       " 'ad cell': {},\n",
       " 'ad computer': {},\n",
       " 'ad elekttonik servis kulkas frmesin cuci freezer': {},\n",
       " 'ad pet shop': {},\n",
       " 'ad premiere office park': {},\n",
       " 'ad sandi cakra pratama. pt': {},\n",
       " 'ada': {},\n",
       " 'ada atr cell': {},\n",
       " 'ada baru city walk area parkir lantai dasar': {},\n",
       " 'ada cell': {},\n",
       " 'ada collections': {},\n",
       " 'ada espresso bar': {},\n",
       " 'ada fashion': {},\n",
       " 'ada guest house': {},\n",
       " 'ada meubel': {},\n",
       " 'ada project': {},\n",
       " 'ada telecom': {},\n",
       " 'adail elektro': {},\n",
       " 'adam': {},\n",
       " 'adam aquarium': {},\n",
       " 'adam baharu cv': {},\n",
       " 'adam barbershop': {},\n",
       " 'adam kere bambu': {},\n",
       " 'adam kerudung': {},\n",
       " 'adam minimarket': {},\n",
       " 'adam mobil cv': {},\n",
       " 'adam ponsel': {},\n",
       " 'adam ridwan cakes': {},\n",
       " 'adam salad buah': {},\n",
       " 'adam swalayan': {},\n",
       " 'adam wiratama': {},\n",
       " 'adamsyaerra cake mart': {},\n",
       " 'adara kosmetik': {},\n",
       " 'adarasa': {},\n",
       " 'adau putra network': {},\n",
       " 'addict': {},\n",
       " 'addin art': {},\n",
       " 'addin toys suruh salatiga': {},\n",
       " 'ade': {},\n",
       " 'ade ayu': {},\n",
       " 'ade bird': {},\n",
       " 'ade collection': {},\n",
       " 'ade f': {},\n",
       " 'ade florist': {},\n",
       " 'ade hadifah': {},\n",
       " 'ade kurniati': {},\n",
       " 'ade laundry': {},\n",
       " 'ade modifikasi': {},\n",
       " 'ade pompa. cv': {},\n",
       " 'ade ponsel': {},\n",
       " 'ade print scan': {},\n",
       " 'ade ray - celebrity fitness': {},\n",
       " 'ade ruminat': {},\n",
       " 'ade tehnik konstruksi. cv': {},\n",
       " \"ade' jeans\": {},\n",
       " 'adec cell': {},\n",
       " 'adeeva cake': {},\n",
       " \"adek's saloon\": {},\n",
       " 'adel buah': {},\n",
       " 'adel parfume': {},\n",
       " 'adel ponsel': {},\n",
       " 'adel salon': {},\n",
       " 'adel studio musik bulian': {},\n",
       " 'adelia 2': {},\n",
       " 'adelia salon': {},\n",
       " 'adelia tour & travel': {},\n",
       " 'adella armah toko': {},\n",
       " 'adem ayem': {},\n",
       " 'aden resi': {},\n",
       " 'adennan meubel': {},\n",
       " 'aderio rental rental mobil bangka': {},\n",
       " 'aderlina marpaung & partners': {},\n",
       " 'ades alfindo putrasetia pt': {},\n",
       " 'ades water indonesia pt': {},\n",
       " 'adetex pusat grosir pakaian': {},\n",
       " 'adf': {},\n",
       " 'adfa cell': {},\n",
       " 'adha ponsel': {},\n",
       " 'adhe herwindo at home': {},\n",
       " 'adhe toko': {},\n",
       " 'adhellia laundry': {},\n",
       " 'adhi': {},\n",
       " 'adhi metalindo pt': {},\n",
       " 'adhi putragraha sentosa pt': {},\n",
       " 'adhi semesta teknik. cv': {},\n",
       " 'adhi warna photo': {},\n",
       " 'adhie tailor': {},\n",
       " 'adhiim freid chicken': {},\n",
       " 'adhika darma sejati pt': {},\n",
       " 'adhika swara pt': {},\n",
       " 'adhisti spa': {},\n",
       " 'adhiswara radio': {},\n",
       " 'adhitya andrebina agung. pt': {},\n",
       " 'adhitya chandra export': {},\n",
       " 'adhye n friend studio': {},\n",
       " 'adi': {},\n",
       " 'adi ari villa': {},\n",
       " 'adi beton perkasa 2': {},\n",
       " 'adi computer': {},\n",
       " 'adi daya solusi': {},\n",
       " 'adi dental': {},\n",
       " 'adi foto digital': {},\n",
       " 'adi garage nouvo parts': {},\n",
       " 'adi glass': {},\n",
       " 'adi gordyn': {},\n",
       " 'adi gunawansyah sh and partners': {},\n",
       " 'adi halalmart': {},\n",
       " 'adi jaya': {},\n",
       " 'adi jaya abadi. cv': {},\n",
       " 'adi jaya bengkel': {},\n",
       " 'adi jaya electro': {},\n",
       " 'adi jaya elektronik': {},\n",
       " 'adi jaya meubel': {},\n",
       " 'adi jaya motor': {},\n",
       " 'adi jaya ponsel': {},\n",
       " 'adi jaya putra': {},\n",
       " 'adi jaya sarana. cv': {},\n",
       " 'adi kartika utama': {},\n",
       " 'adi karya': {},\n",
       " 'adi luhung abadi pt': {},\n",
       " 'adi makmur sentosa. pt': {},\n",
       " 'adi mandiri': {},\n",
       " 'adi mandiri sakti. pt': {},\n",
       " 'adi motor': {},\n",
       " 'adi multi sarana pt': {},\n",
       " 'adi mustika meubel': {},\n",
       " 'adi oli toko': {},\n",
       " 'adi pasee jaya': {},\n",
       " 'adi perkasa anugrah pt': {},\n",
       " 'adi photo': {},\n",
       " 'adi praya cv': {},\n",
       " 'adi putra bengkel mitra bersaudara': {},\n",
       " 'adi putra motor ud': {},\n",
       " 'adi putra. cv': {},\n",
       " 'adi roso': {},\n",
       " 'adi sablon': {},\n",
       " 'adi salon': {},\n",
       " 'adi sarana armada. pt': {},\n",
       " 'adi surya abadi. cv': {},\n",
       " 'adi surya. cv': {},\n",
       " 'adi teknik. cv': {},\n",
       " 'adi toko': {},\n",
       " 'adi trans logistics pt': {},\n",
       " 'adi wiraguna usaha tama. pt': {},\n",
       " 'adiantum agency': {},\n",
       " 'adibba rental ps3 dan ps2': {},\n",
       " 'adicell': {},\n",
       " 'adicipta': {},\n",
       " 'adidas': {},\n",
       " 'adidas cuci motor': {},\n",
       " 'adidas grand indonesia': {},\n",
       " 'adidas toko': {},\n",
       " 'adidaya': {},\n",
       " 'adiguna shipyard pt': {},\n",
       " 'adijaya gypsum': {},\n",
       " 'adijaya motor bengkel': {},\n",
       " 'adijaya trading cv': {},\n",
       " 'adika cell': {},\n",
       " 'adikarma & rekan': {},\n",
       " 'adikuarta perdana. pt': {},\n",
       " 'adil': {},\n",
       " 'adil bahagia furniture': {},\n",
       " 'adil collection': {},\n",
       " 'adinda collection supplier hijab stuff': {},\n",
       " 'adinegoro': {},\n",
       " 'adinuansa wiraswasta gemilang pt': {},\n",
       " 'adiona sejahtera advertising': {},\n",
       " 'adioro soetojo dr, drg ms spkg': {},\n",
       " 'adiprabu gallery': {},\n",
       " 'adiputra ud': {},\n",
       " 'adira club member': {},\n",
       " 'adira dinamika': {},\n",
       " 'adira dinamika multi finance pt tbk': {},\n",
       " 'adira dinamika multifinance': {},\n",
       " 'adira faces of indonesia': {},\n",
       " 'adira finance': {},\n",
       " 'adira finance kabanjahe': {},\n",
       " 'adira finance,tbk, pt': {},\n",
       " 'adira kredit': {},\n",
       " 'adira motor': {},\n",
       " 'adira quantum multifinance. pt': {},\n",
       " 'adira tebet mobil': {},\n",
       " 'adiral pt': {},\n",
       " 'adirand multi millenia pt': {},\n",
       " 'adirasa': {},\n",
       " 'adisa accesories': {},\n",
       " 'adisarana purwakrida': {},\n",
       " 'adisra': {},\n",
       " 'aditama': {},\n",
       " 'aditama dan napuri': {},\n",
       " 'aditania primakarsa perdana pt': {},\n",
       " 'aditya aquarium toko ikan hias': {},\n",
       " 'aditya cell': {},\n",
       " 'aditya collection': {},\n",
       " 'aditya doorsmeer': {},\n",
       " 'aditya hotel': {},\n",
       " 'aditya laundry': {},\n",
       " 'aditya motor': {},\n",
       " 'aditya pt': {},\n",
       " 'aditya rias pengantin': {},\n",
       " 'aditya sablon': {},\n",
       " 'aditya salon': {},\n",
       " 'aditya shop': {},\n",
       " 'aditya tours & rent car': {},\n",
       " 'aditya ukir 2': {},\n",
       " 'aditya vape shop': {},\n",
       " 'aditya wijaya': {},\n",
       " 'adiwiyata': {},\n",
       " 'adiyasa': {},\n",
       " 'adiz souvenir': {},\n",
       " 'adiza photography': {},\n",
       " 'adjiz & yani salon': {},\n",
       " 'adlan electronic': {},\n",
       " 'adli hakim apriliawan cv': {},\n",
       " 'adly putri cell': {},\n",
       " 'adman perobot': {},\n",
       " 'admedika': {},\n",
       " 'administrasi, pembangunan setda': {},\n",
       " 'admore corp. pt': {},\n",
       " 'adna ud': {},\n",
       " 'adnan arminareka tour dan travel': {},\n",
       " 'adnan jaya tailor': {},\n",
       " 'adnan ppob': {},\n",
       " 'adnan tax consultant': {},\n",
       " 'adnyani collection': {},\n",
       " 'adorableprojects': {},\n",
       " 'adp sinar makmur': {},\n",
       " 'adr variasi': {},\n",
       " 'adreena hijab': {},\n",
       " 'adrem aneka rasa mbak dewi': {},\n",
       " 'adres jaya motor aksesoris': {},\n",
       " 'adri putra tour travel & umroh': {},\n",
       " 'adrian armando': {},\n",
       " 'adrian cell': {},\n",
       " 'adrinusa esatama pt': {},\n",
       " 'adsindo tama': {},\n",
       " 'adtyjln': {},\n",
       " 'aduen card ii': {},\n",
       " 'aduma jaya toko': {},\n",
       " 'advance': {},\n",
       " 'advance festival city link': {},\n",
       " 'advanced computer training center': {},\n",
       " 'adventist aviation indonesia office': {},\n",
       " 'adventure house': {},\n",
       " 'adventure travel': {},\n",
       " 'adventures summerland': {},\n",
       " 'advertising & digital printing idalia': {},\n",
       " 'advertising dan tech yoben': {},\n",
       " 'advertising zeefa': {},\n",
       " 'advocat agnes margono, s.h': {},\n",
       " 'advokat & konsultan hukum rony na sh': {},\n",
       " 'advokat & konsultan hukum yoyo caryonih, sh & rekan': {},\n",
       " 'advokat & penasehat hukum moh ridwan sh': {},\n",
       " 'advokat & penasihat hukum lutfi sanaki & rekan': {},\n",
       " 'advokat & pengacara watiran, s.h., m.h.': {},\n",
       " 'advokat antoni silo dan associates': {},\n",
       " 'advokat gunarto, s.h. & rekan': {},\n",
       " 'advokat h yusrizal ghazali,s.h.,m.h': {},\n",
       " 'advokat lbh indonesia': {},\n",
       " 'advokat meina i.n simanungkalit, sh': {},\n",
       " 'advokat misrullani, sh & rekan': {},\n",
       " 'advokat pengacara & penasehat hukum charles s': {},\n",
       " 'advokat sm law office': {},\n",
       " 'advokat zahir rusyad, sh. m. hum': {},\n",
       " 'adwaya paint': {},\n",
       " 'ady cell': {},\n",
       " 'ady clothing.wadi olshop': {},\n",
       " 'ady jaya motor': {},\n",
       " 'ady salon': {},\n",
       " 'adyar perkasa .pt': {},\n",
       " 'adyastha motor': {},\n",
       " 'adyfara': {},\n",
       " 'adzikra': {},\n",
       " 'adzkia cell': {},\n",
       " 'adzkia fotokopi & percetakan': {},\n",
       " 'adzkia kids wear': {},\n",
       " 'adzkiya': {},\n",
       " 'adzkiya advertising': {},\n",
       " 'ae gypsum': {},\n",
       " 'aedelia cell': {},\n",
       " 'aeini salon': {},\n",
       " 'aek kanopan': {},\n",
       " 'aek pancur kel.': {},\n",
       " 'aempe pluit bataco raya pt': {},\n",
       " 'aemtobe premiere': {},\n",
       " 'aeno': {},\n",
       " 'aeobah': {},\n",
       " 'aeon mall 3rd floor': {},\n",
       " 'aeps': {},\n",
       " 'aerialrows': {},\n",
       " 'aerin gorden': {},\n",
       " 'aero': {},\n",
       " 'aero boutique': {},\n",
       " 'aerofood acs building': {},\n",
       " 'aeroland residence': {},\n",
       " 'aeropolis apartemen': {},\n",
       " 'aeropolis complex': {},\n",
       " 'aesthetic specialist dental klinik': {},\n",
       " 'aesthetic studio': {},\n",
       " 'aestia & co': {},\n",
       " 'afan cell': {},\n",
       " 'afan net': {},\n",
       " 'afandy florist': {},\n",
       " 'afar': {},\n",
       " 'afara wedding': {},\n",
       " 'afat surajati': {},\n",
       " 'afc fried chicken': {},\n",
       " 'afda travel': {},\n",
       " 'afdal': {},\n",
       " 'afdar': {},\n",
       " 'afdema nusantara, pt': {},\n",
       " 'afdil fashion': {},\n",
       " 'afdilla': {},\n",
       " 'afe net dan de c afe coffee': {},\n",
       " 'afen image nathaniel global toko': {},\n",
       " 'afendi kupi': {},\n",
       " 'affal jaya ss': {},\n",
       " 'affan': {},\n",
       " 'affansa phone service': {},\n",
       " 'affi farma pt': {},\n",
       " 'affordable tour & activities in bali': {},\n",
       " 'afgan nada entertaiment': {},\n",
       " 'afi group (amanah fadhilah insani)': {},\n",
       " 'afi jaya 2': {},\n",
       " 'afi laundry': {},\n",
       " 'afi ristiyana': {},\n",
       " 'afiat bestari santosa pt': {},\n",
       " 'afie collection olshop': {},\n",
       " 'afie foto': {},\n",
       " 'afif crc jaya': {},\n",
       " 'afif pulsa': {},\n",
       " 'afif shoes': {},\n",
       " 'afifa': {},\n",
       " 'afifa cell': {},\n",
       " 'afifah': {},\n",
       " 'afifah computer': {},\n",
       " 'afifah khoirunnisah': {},\n",
       " 'afifah laundry': {},\n",
       " 'afiffa cell': {},\n",
       " 'afika jus buah dan bubble drink': {},\n",
       " 'afiliasi shop': {},\n",
       " 'afiq': {},\n",
       " 'afiq tailor': {},\n",
       " 'afit motor': {},\n",
       " 'afit tailor': {},\n",
       " 'afiza collection': {},\n",
       " 'afizah salon': {},\n",
       " 'afkar butik': {},\n",
       " 'afla bio fresh': {},\n",
       " 'aflah laundry': {},\n",
       " 'aflah moeslim collection': {},\n",
       " 'afnan collection': {},\n",
       " 'afninar': {},\n",
       " 'afo': {},\n",
       " 'afphotography': {},\n",
       " 'afrakids gorontalo': {},\n",
       " 'afri. cv': {},\n",
       " 'afrian motor': {},\n",
       " 'afrianto': {},\n",
       " 'afriman': {},\n",
       " 'afriza collection': {},\n",
       " 'afs hijab store': {},\n",
       " 'afterall store': {},\n",
       " 'afui kin ci pan': {},\n",
       " 'afzacom': {},\n",
       " 'ag air gunung': {},\n",
       " 'ag fried chicken': {},\n",
       " 'ag glass': {},\n",
       " 'ag jeans': {},\n",
       " 'ag kaca aluminium & kayu': {},\n",
       " 'ag servis': {},\n",
       " 'ag steak & ribs': {},\n",
       " 'ag textil toko': {},\n",
       " 'ag. cellular': {},\n",
       " 'agadipa. pt': {},\n",
       " 'againt street shop': {},\n",
       " 'agam benoa cargo. pt': {},\n",
       " 'agam creative computer': {},\n",
       " 'aganio optik': {},\n",
       " 'agape church samarinda': {},\n",
       " 'agape regenci': {},\n",
       " 'agarista': {},\n",
       " 'agashi cell': {},\n",
       " 'agatis meubel': {},\n",
       " 'agatos jatiasih': {},\n",
       " 'agave laundry': {},\n",
       " 'age bakti purnama pt': {},\n",
       " 'agen & grosir sancu bogor': {},\n",
       " 'agen accesories dan mainan': {},\n",
       " 'agen afrakids': {},\n",
       " 'agen ahad - net internasional': {},\n",
       " 'agen air axology': {},\n",
       " ...}"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "all_poi_dict"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "dynamic-capability",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-03-20T01:11:30.922144Z",
     "start_time": "2021-03-20T01:11:28.549492Z"
    }
   },
   "outputs": [],
   "source": [
    "autocomplete = AutoComplete(words=all_poi_dict)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "negative-tennis",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-03-20T01:15:35.901385Z",
     "start_time": "2021-03-20T01:15:35.841546Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[['electra'], ['electra jaya']]"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "autocomplete.search(word='electr laun system')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "working-canvas",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-03-18T09:52:18.312363Z",
     "start_time": "2021-03-18T09:52:18.306379Z"
    }
   },
   "outputs": [],
   "source": [
    "from fuzzywuzzy import process\n",
    "from fuzzywuzzy import fuzz"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "id": "limited-point",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-03-18T14:47:30.135878Z",
     "start_time": "2021-03-18T14:47:30.122913Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "9"
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "'LnwZa/JomLnwKing'.find('Lnw', 'LnwZa/JomLnwKing'.find('/'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "id": "motivated-browser",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-03-18T12:15:36.157879Z",
     "start_time": "2021-03-18T12:15:36.136958Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "True"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "'yayasan atohariyah' in all_poi"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "id": "assumed-referral",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-03-18T16:32:45.279237Z",
     "start_time": "2021-03-18T16:32:45.252334Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "93412"
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(all_poi)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "id": "filled-music",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-03-18T12:15:05.948407Z",
     "start_time": "2021-03-18T12:14:25.325563Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[('toha', 90), ('ay ay', 86), ('hari', 77), ('yahya', 76), ('yayak', 76)]"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "process.extract('yaya atohar', choices = all_poi, limit = 5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "id": "social-lemon",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-03-18T16:40:15.569505Z",
     "start_time": "2021-03-18T16:40:15.555542Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "73"
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fuzz.ratio('yaya atohar,','yayasan atohariyah')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "id": "tender-commercial",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-03-18T16:40:11.973300Z",
     "start_time": "2021-03-18T16:40:11.964322Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "50"
      ]
     },
     "execution_count": 63,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fuzz.ratio('yaya atohar,','toha')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "compound-artwork",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-03-18T09:56:49.154985Z",
     "start_time": "2021-03-18T09:54:29.076385Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "('02 mart', 86)"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "process.extractOne('cikahuripan sd neg boj 02 klap boj, no 5 16877', all_poi)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "raising-football",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-03-18T12:06:11.252851Z",
     "start_time": "2021-03-18T12:06:05.657988Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Collecting geopy\n",
      "  Downloading geopy-2.1.0-py3-none-any.whl (112 kB)\n",
      "Collecting geographiclib<2,>=1.49\n",
      "  Downloading geographiclib-1.50-py3-none-any.whl (38 kB)\n",
      "Installing collected packages: geographiclib, geopy\n",
      "Successfully installed geographiclib-1.50 geopy-2.1.0\n"
     ]
    }
   ],
   "source": [
    "!pip install geopy"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "silent-robinson",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-03-18T12:06:37.107754Z",
     "start_time": "2021-03-18T12:06:36.802768Z"
    }
   },
   "outputs": [],
   "source": [
    "from geopy.geocoders import Nominatim"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "id": "cheap-encyclopedia",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-03-18T12:08:58.252323Z",
     "start_time": "2021-03-18T12:08:57.377887Z"
    }
   },
   "outputs": [
    {
     "ename": "AttributeError",
     "evalue": "'NoneType' object has no attribute 'address'",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mAttributeError\u001b[0m                            Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-50-a3a03c6e88e4>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[0;32m      1\u001b[0m \u001b[0mgeolocator\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mNominatim\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0muser_agent\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;34m\"my-app\"\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m      2\u001b[0m \u001b[0mlocation\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mgeolocator\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mgeocode\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m\"cikahuripan sd neg boj 02 klap boj\"\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m----> 3\u001b[1;33m \u001b[0mprint\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mlocation\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0maddress\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;31mAttributeError\u001b[0m: 'NoneType' object has no attribute 'address'"
     ]
    }
   ],
   "source": [
    "geolocator = Nominatim(user_agent=\"my-app\")\n",
    "location = geolocator.geocode(\"cikahuripan sd neg boj 02 klap boj\")\n",
    "print(location.address)"
   ]
  }
 ],
 "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.8.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}