AddressAPI Usage.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "18c7e070-2907-473a-8f4e-00b49716079b",
   "metadata": {},
   "outputs": [],
   "source": [
    "from address_resolver import AddressAPI\n",
    "import concurrent.futures\n",
    "from multiprocessing.pool import ThreadPool"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "65d51bea-2268-46ba-9533-ae0e3bbb4e6a",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Regex API\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "{'city': 'Hatay',\n",
       " 'distinct': 'ANTAKYA',\n",
       " 'neighbourhood': 'cebrail mah',\n",
       " 'excessData': {'street_road': 'cumhuriyet caddesi',\n",
       "  'complex': '',\n",
       "  'apartment': 'seçkinler apt',\n",
       "  'part': '',\n",
       "  'block': '',\n",
       "  'floor': '',\n",
       "  'apartment_no': '',\n",
       "  'phone': ''},\n",
       " 'originalText': 'Hatay ANTAKYA cebrail mah cumhuriyet caddesi seçkinler apt a 3',\n",
       " 'address': 'Hatay ANTAKYA cebrail mah cumhuriyet caddesi seçkinler apt',\n",
       " 'ws': 0.7142857142857143,\n",
       " 'entry_id': 1}"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "OpenAI API\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "{'city': 'Hatay',\n",
       " 'distinct': 'Antakya',\n",
       " 'neighbourhood': 'Cebrail Mahallesi',\n",
       " 'street': 'Cumhuriyet Caddesi',\n",
       " 'no': '3',\n",
       " 'tel': '',\n",
       " 'name_surname': '',\n",
       " 'address': 'Antakya, Cebrail Mahallesi, Cumhuriyet Caddesi, Seçkinler Apt. No:3',\n",
       " 'entry_id': 1}"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Google Geocode API\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "{'address': 'Hatay ANTAKYA cebrail mah cumhuriyet caddesi seçkinler apt a 3',\n",
       " 'latitude': 36.2033813,\n",
       " 'longitude': 36.1588396,\n",
       " 'northeast_lat': 36.20469882989271,\n",
       " 'northeast_lng': 36.16017122989272,\n",
       " 'southwest_lat': 36.20199917010727,\n",
       " 'southwest_lng': 36.15747157010728,\n",
       " 'formatted_address': 'Cebrail Mah.Cumhuriyet Cad.Seçkinler Apt Altı, No:10/4, 31040 Antakya/Hatay, Türkiye',\n",
       " 'is_resolved': True,\n",
       " 'entry_id': 1}"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "import os\n",
    "from dotenv import load_dotenv\n",
    "load_dotenv('.env')\n",
    "GOOGLE_API_KEY = os.getenv(\"GOOGLE_API_KEY\")\n",
    "OPENAI_API_KEY = os.getenv(\"OPENAI_API_KEY\")\n",
    "NER_API_KEY = os.getenv(\"NER_API_KEY\")\n",
    "\n",
    "address_api = AddressAPI(GOOGLE_API_KEY, OPENAI_API_KEY, NER_API_KEY)\n",
    "address_text = 'Hatay ANTAKYA cebrail mah cumhuriyet caddesi seçkinler apt a 3'\n",
    "\n",
    "print(\"Regex API\")\n",
    "display(address_api.regex_api_request(address_text, entry_id=1))\n",
    "\n",
    "print(\"OpenAI API\")\n",
    "display(address_api.openai_api_request(address_text, entry_id=1))\n",
    "\n",
    "print(\"Google Geocode API\")\n",
    "display(address_api.google_geocode_api_request(address_text, entry_id=1))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "3539f4be-033a-496a-a7f6-90280668e07b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>entry_id</th>\n",
       "      <th>raw_text</th>\n",
       "      <th>channel</th>\n",
       "      <th>metadata</th>\n",
       "      <th>timestamp</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>COCUK KAYIP⚠️⚠️⚠️\\n \\nGOKTURK CADDESI\\nNO:46, ...</td>\n",
       "      <td>Twitter</td>\n",
       "      <td>{\"user_id\": \"1507064701351600130\", \"screen_nam...</td>\n",
       "      <td>2023-02-08 02:57:06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>NERDE BU AFAD</td>\n",
       "      <td>Twitter</td>\n",
       "      <td>{\"user_id\": \"1521470073822720002\", \"screen_nam...</td>\n",
       "      <td>2023-02-08 02:57:05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>Adıyaman ve ilçeleri enkaz altında. Ulaşılması...</td>\n",
       "      <td>Twitter</td>\n",
       "      <td>{\"user_id\": \"1492278858380464131\", \"screen_nam...</td>\n",
       "      <td>2023-02-08 03:03:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>Cebrail Mah. Cumhuriyet Cad. Seçkinler Apt. A ...</td>\n",
       "      <td>Twitter</td>\n",
       "      <td>{\"user_id\": \"1583974494837903361\", \"screen_nam...</td>\n",
       "      <td>2023-02-08 03:03:33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>@bengidemem Betül Ekici ve ailesi\\n\\nŞehit Abd...</td>\n",
       "      <td>Twitter</td>\n",
       "      <td>{\"user_id\": \"2767389526\", \"screen_name\": \"Kork...</td>\n",
       "      <td>2023-02-08 02:57:05</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>95</th>\n",
       "      <td>95</td>\n",
       "      <td>Hissedilen herşeye cümle kurulmuyor</td>\n",
       "      <td>Twitter</td>\n",
       "      <td>{\"user_id\": \"1312111525897830401\", \"screen_nam...</td>\n",
       "      <td>2023-02-08 02:56:45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>96</td>\n",
       "      <td>Turunçlu Bel Yeşilyayla Kent Sitesi Sani Akar ...</td>\n",
       "      <td>Twitter</td>\n",
       "      <td>{\"user_id\": \"4846569496\", \"screen_name\": \"no c...</td>\n",
       "      <td>2023-02-08 02:56:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>97</td>\n",
       "      <td>Kahramanmaraş şazibey mahallesi Ebrar sitesi Z...</td>\n",
       "      <td>Twitter</td>\n",
       "      <td>{\"user_id\": \"1482457785719791623\", \"screen_nam...</td>\n",
       "      <td>2023-02-08 02:56:45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>98</td>\n",
       "      <td>@haluklevent Bahçelievler mahallesi Atatürk bu...</td>\n",
       "      <td>Twitter</td>\n",
       "      <td>{\"user_id\": \"1301628422674886667\", \"screen_nam...</td>\n",
       "      <td>2023-02-08 02:56:45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>99</td>\n",
       "      <td>@ayiogluayi0 Arkadaşımız Şeyma Zencir, annesi ...</td>\n",
       "      <td>Twitter</td>\n",
       "      <td>{\"user_id\": \"1510364388401815552\", \"screen_nam...</td>\n",
       "      <td>2023-02-08 02:56:47</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>100 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    entry_id                                           raw_text  channel  \\\n",
       "0          0  COCUK KAYIP⚠️⚠️⚠️\\n \\nGOKTURK CADDESI\\nNO:46, ...  Twitter   \n",
       "1          1                                      NERDE BU AFAD  Twitter   \n",
       "2          2  Adıyaman ve ilçeleri enkaz altında. Ulaşılması...  Twitter   \n",
       "3          3  Cebrail Mah. Cumhuriyet Cad. Seçkinler Apt. A ...  Twitter   \n",
       "4          4  @bengidemem Betül Ekici ve ailesi\\n\\nŞehit Abd...  Twitter   \n",
       "..       ...                                                ...      ...   \n",
       "95        95                Hissedilen herşeye cümle kurulmuyor  Twitter   \n",
       "96        96  Turunçlu Bel Yeşilyayla Kent Sitesi Sani Akar ...  Twitter   \n",
       "97        97  Kahramanmaraş şazibey mahallesi Ebrar sitesi Z...  Twitter   \n",
       "98        98  @haluklevent Bahçelievler mahallesi Atatürk bu...  Twitter   \n",
       "99        99  @ayiogluayi0 Arkadaşımız Şeyma Zencir, annesi ...  Twitter   \n",
       "\n",
       "                                             metadata            timestamp  \n",
       "0   {\"user_id\": \"1507064701351600130\", \"screen_nam...  2023-02-08 02:57:06  \n",
       "1   {\"user_id\": \"1521470073822720002\", \"screen_nam...  2023-02-08 02:57:05  \n",
       "2   {\"user_id\": \"1492278858380464131\", \"screen_nam...  2023-02-08 03:03:34  \n",
       "3   {\"user_id\": \"1583974494837903361\", \"screen_nam...  2023-02-08 03:03:33  \n",
       "4   {\"user_id\": \"2767389526\", \"screen_name\": \"Kork...  2023-02-08 02:57:05  \n",
       "..                                                ...                  ...  \n",
       "95  {\"user_id\": \"1312111525897830401\", \"screen_nam...  2023-02-08 02:56:45  \n",
       "96  {\"user_id\": \"4846569496\", \"screen_name\": \"no c...  2023-02-08 02:56:44  \n",
       "97  {\"user_id\": \"1482457785719791623\", \"screen_nam...  2023-02-08 02:56:45  \n",
       "98  {\"user_id\": \"1301628422674886667\", \"screen_nam...  2023-02-08 02:56:45  \n",
       "99  {\"user_id\": \"1510364388401815552\", \"screen_nam...  2023-02-08 02:56:47  \n",
       "\n",
       "[100 rows x 5 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "sample_df = pd.read_csv('../data_for_regex_v2.csv')\n",
    "\n",
    "address_df = pd.DataFrame()\n",
    "address_df['entry_id'] = range(0,100)\n",
    "address_df['raw_text'] = sample_df.full_text.values[:100]\n",
    "address_df['channel'] = 'Twitter'\n",
    "address_df['metadata'] = sample_df[sample_df.extra_parameters.isnull()==False][:100].extra_parameters.values\n",
    "address_df['timestamp'] = address_df['metadata'].apply(lambda x: eval(x)['created_at'])\n",
    "address_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "1904d85b-d4ed-4658-b3e4-6276e0442706",
   "metadata": {},
   "outputs": [],
   "source": [
    "def pipeline(address_df):\n",
    "    regex_results = pd.DataFrame([address_api.regex_api_request(raw_text, entry_id) for raw_text, entry_id in zip(address_df.raw_text.values, address_df.entry_id.values)])\n",
    "    regex_to_geocode = regex_results[regex_results.ws >= 0.7]\n",
    "    del regex_results\n",
    "\n",
    "    # Ner Process\n",
    "    address_df = address_df[~address_df.entry_id.isin(regex_to_geocode.entry_id.values)]\n",
    "    with ThreadPool(60) as executor:\n",
    "        ner_results = executor.map(lambda p: address_api.ner_api_request(*p) , zip(address_df.raw_text.values, address_df.entry_id.values))\n",
    "    ner_results = pd.DataFrame(ner_results)\n",
    "    ner_to_geocode = ner_results[ner_results.ws >= 0.5]\n",
    "    del ner_results\n",
    "\n",
    "    geocode_data = pd.concat([regex_to_geocode[['address', 'entry_id']], ner_to_geocode[['address', 'entry_id']]], axis=0)\n",
    "    del regex_to_geocode, ner_to_geocode\n",
    "        \n",
    "    with ThreadPool(60) as executor:\n",
    "        geocode_data = executor.map(lambda p: address_api.google_geocode_api_request(*p) , zip(geocode_data.address.values, geocode_data.entry_id.values))\n",
    "    \n",
    "    geocode_data = pd.DataFrame(geocode_data)  \n",
    "    return geocode_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "f08ee239-ef66-4599-ba6b-9407b6398ed5",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>address</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>northeast_lat</th>\n",
       "      <th>northeast_lng</th>\n",
       "      <th>southwest_lat</th>\n",
       "      <th>southwest_lng</th>\n",
       "      <th>formatted_address</th>\n",
       "      <th>is_resolved</th>\n",
       "      <th>entry_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Hatay ANTAKYA cebrail mah cumhuriyet caddesi s...</td>\n",
       "      <td>36.203044</td>\n",
       "      <td>36.159812</td>\n",
       "      <td>36.204362</td>\n",
       "      <td>36.161141</td>\n",
       "      <td>36.201662</td>\n",
       "      <td>36.158441</td>\n",
       "      <td>Cebrail, Cumhuriyet Cd. No:2, 31030 Antakya/Ha...</td>\n",
       "      <td>True</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Kahramanmaraş ONİKİŞUBAT şazibey mahallesi 640...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td></td>\n",
       "      <td>False</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Hatay ANTAKYA ürgenpaşa mah ekinci yol buket apt</td>\n",
       "      <td>36.236263</td>\n",
       "      <td>36.142416</td>\n",
       "      <td>36.237503</td>\n",
       "      <td>36.143913</td>\n",
       "      <td>36.234804</td>\n",
       "      <td>36.141213</td>\n",
       "      <td>Ekinci, Çevre Yolu, 31180 Antakya/Hatay, Türkiye</td>\n",
       "      <td>True</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Hatay İSKENDERUN çay mahallesi atatürk bulvar ...</td>\n",
       "      <td>36.584673</td>\n",
       "      <td>36.175616</td>\n",
       "      <td>36.585950</td>\n",
       "      <td>36.177033</td>\n",
       "      <td>36.583250</td>\n",
       "      <td>36.174333</td>\n",
       "      <td>SAKARYA MAHALLESİ 278.SOKAK BİLGİ APARTMANI NO...</td>\n",
       "      <td>True</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Hatay ANTAKYA odabaşı mahallesi 6 sokak zeytun...</td>\n",
       "      <td>36.223085</td>\n",
       "      <td>36.161904</td>\n",
       "      <td>36.224475</td>\n",
       "      <td>36.163206</td>\n",
       "      <td>36.221775</td>\n",
       "      <td>36.160506</td>\n",
       "      <td>Odabaşı, 6. Sk., Antakya/Hatay, Türkiye</td>\n",
       "      <td>True</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>Osmaniye  Düziçi  Esenevler mahallesi  Palmiy...</td>\n",
       "      <td>41.009770</td>\n",
       "      <td>29.092240</td>\n",
       "      <td>41.011099</td>\n",
       "      <td>29.093583</td>\n",
       "      <td>41.008400</td>\n",
       "      <td>29.090883</td>\n",
       "      <td>Esenevler, 34762 Ümraniye/İstanbul, Türkiye</td>\n",
       "      <td>True</td>\n",
       "      <td>86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>KAHRAMANMARAS  oniki subat malik ejder mahall...</td>\n",
       "      <td>37.568597</td>\n",
       "      <td>36.899007</td>\n",
       "      <td>37.573493</td>\n",
       "      <td>36.901854</td>\n",
       "      <td>37.563132</td>\n",
       "      <td>36.893305</td>\n",
       "      <td>Malik Ejder, 46040 Onikişubat/Kahramanmaraş, T...</td>\n",
       "      <td>True</td>\n",
       "      <td>87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>YAVUZ SELİM MAHALLESİ  605 SOKAK  MERKEZ  ADI...</td>\n",
       "      <td>37.764263</td>\n",
       "      <td>38.268468</td>\n",
       "      <td>37.768286</td>\n",
       "      <td>38.272721</td>\n",
       "      <td>37.761858</td>\n",
       "      <td>38.263856</td>\n",
       "      <td>Yavuz Selim, 02040 Adıyaman Merkez/Adıyaman, T...</td>\n",
       "      <td>True</td>\n",
       "      <td>92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>Altınova mah.  136046 sok.  onikişubat  kahra...</td>\n",
       "      <td>37.589509</td>\n",
       "      <td>36.855659</td>\n",
       "      <td>37.590921</td>\n",
       "      <td>36.857081</td>\n",
       "      <td>37.588221</td>\n",
       "      <td>36.854382</td>\n",
       "      <td>Yirmi İki Gün Mahallesi 91039. Sokak Dora Park...</td>\n",
       "      <td>True</td>\n",
       "      <td>94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>Kahramanmaraş  Kahramanmaras  şazibey mahalle...</td>\n",
       "      <td>37.597325</td>\n",
       "      <td>36.893673</td>\n",
       "      <td>37.598622</td>\n",
       "      <td>36.895044</td>\n",
       "      <td>37.595923</td>\n",
       "      <td>36.892344</td>\n",
       "      <td>Hürriyet, 17. Sk. No:14, 46050 Kahramanmaraş M...</td>\n",
       "      <td>True</td>\n",
       "      <td>97</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>67 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              address   latitude  longitude  \\\n",
       "0   Hatay ANTAKYA cebrail mah cumhuriyet caddesi s...  36.203044  36.159812   \n",
       "1   Kahramanmaraş ONİKİŞUBAT şazibey mahallesi 640...   0.000000   0.000000   \n",
       "2    Hatay ANTAKYA ürgenpaşa mah ekinci yol buket apt  36.236263  36.142416   \n",
       "3   Hatay İSKENDERUN çay mahallesi atatürk bulvar ...  36.584673  36.175616   \n",
       "4   Hatay ANTAKYA odabaşı mahallesi 6 sokak zeytun...  36.223085  36.161904   \n",
       "..                                                ...        ...        ...   \n",
       "62   Osmaniye  Düziçi  Esenevler mahallesi  Palmiy...  41.009770  29.092240   \n",
       "63   KAHRAMANMARAS  oniki subat malik ejder mahall...  37.568597  36.899007   \n",
       "64   YAVUZ SELİM MAHALLESİ  605 SOKAK  MERKEZ  ADI...  37.764263  38.268468   \n",
       "65   Altınova mah.  136046 sok.  onikişubat  kahra...  37.589509  36.855659   \n",
       "66   Kahramanmaraş  Kahramanmaras  şazibey mahalle...  37.597325  36.893673   \n",
       "\n",
       "    northeast_lat  northeast_lng  southwest_lat  southwest_lng  \\\n",
       "0       36.204362      36.161141      36.201662      36.158441   \n",
       "1        0.000000       0.000000       0.000000       0.000000   \n",
       "2       36.237503      36.143913      36.234804      36.141213   \n",
       "3       36.585950      36.177033      36.583250      36.174333   \n",
       "4       36.224475      36.163206      36.221775      36.160506   \n",
       "..            ...            ...            ...            ...   \n",
       "62      41.011099      29.093583      41.008400      29.090883   \n",
       "63      37.573493      36.901854      37.563132      36.893305   \n",
       "64      37.768286      38.272721      37.761858      38.263856   \n",
       "65      37.590921      36.857081      37.588221      36.854382   \n",
       "66      37.598622      36.895044      37.595923      36.892344   \n",
       "\n",
       "                                    formatted_address  is_resolved  entry_id  \n",
       "0   Cebrail, Cumhuriyet Cd. No:2, 31030 Antakya/Ha...         True         3  \n",
       "1                                                            False         8  \n",
       "2    Ekinci, Çevre Yolu, 31180 Antakya/Hatay, Türkiye         True        10  \n",
       "3   SAKARYA MAHALLESİ 278.SOKAK BİLGİ APARTMANI NO...         True        12  \n",
       "4             Odabaşı, 6. Sk., Antakya/Hatay, Türkiye         True        13  \n",
       "..                                                ...          ...       ...  \n",
       "62        Esenevler, 34762 Ümraniye/İstanbul, Türkiye         True        86  \n",
       "63  Malik Ejder, 46040 Onikişubat/Kahramanmaraş, T...         True        87  \n",
       "64  Yavuz Selim, 02040 Adıyaman Merkez/Adıyaman, T...         True        92  \n",
       "65  Yirmi İki Gün Mahallesi 91039. Sokak Dora Park...         True        94  \n",
       "66  Hürriyet, 17. Sk. No:14, 46050 Kahramanmaraş M...         True        97  \n",
       "\n",
       "[67 rows x 10 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "geocode_data = pipeline(address_df)\n",
    "geocode_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "288efde6-24d9-4b01-9c17-63acd84a0f91",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}