API_fetch_folium.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": []
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "code",
      "source": [
        "import json\n",
        "import pandas as pd\n",
        "from pandas.io.json import json_normalize\n",
        "import requests\n",
        "import folium\n",
        "from sklearn.cluster import KMeans\n",
        "from tabulate import tabulate\n",
        "\n",
        "# Define your Foursquare API credentials and endpoint URLs\n",
        "API_KEY = '32IpE2MmM_VTAjNlaD9riTY2zAjg0zzfX_lBiINwHAw'\n",
        "VERSION = '20230912'  # Use the specific version date you prefer, e.g., 'YYYYMMDD'\n",
        "\n",
        "# Set up the API request for apartment locations (modify the parameters)\n",
        "location = '13.133521,77.567135'  # Specify the coordinates for your desired location\n",
        "radius = 100000  # Adjust the radius as needed\n",
        "query = 'apartment'  # Customize the query term\n",
        "\n",
        "apartment_url = f'https://discover.search.hereapi.com/v1/discover?in=circle:{location};r={radius}&q={query}&apiKey={API_KEY}'\n",
        "apartment_data = requests.get(apartment_url).json()\n",
        "apartment_df = json_normalize(apartment_data['items'])\n",
        "\n",
        "# Count the number of cafes, department stores, and gyms near each apartment\n",
        "CafeList = []\n",
        "DepList = []\n",
        "GymList = []\n",
        "\n",
        "for lat, lng in zip(apartment_df['position.lat'], apartment_df['position.lng']):\n",
        "    radius = 1000  # Set the radius to 1000 meters\n",
        "    latitude = lat\n",
        "    longitude = lng\n",
        "\n",
        "    for search_query, result_list in [('cafe', CafeList), ('gym', GymList), ('department-store', DepList)]:\n",
        "        url = f'https://discover.search.hereapi.com/v1/discover?in=circle:{latitude},{longitude};r={radius}&q={search_query}&apiKey={API_KEY}'\n",
        "        results = requests.get(url).json()\n",
        "        venues = json_normalize(results['items'])\n",
        "        result_list.append(venues['title'].count())\n",
        "\n",
        "apartment_df['Cafes'] = CafeList\n",
        "apartment_df['Department Stores'] = DepList\n",
        "apartment_df['Gyms'] = GymList\n",
        "\n",
        "# Display the data as a table\n",
        "print(tabulate(apartment_df[['position.lat', 'position.lng', 'Cafes', 'Department Stores', 'Gyms']],\n",
        "               headers='keys', tablefmt='github'))\n",
        "\n",
        "# Run K-means clustering on the dataframe\n",
        "kclusters = 3\n",
        "kmeans = KMeans(n_clusters=kclusters, random_state=0).fit(apartment_df[['position.lat', 'position.lng']])\n",
        "apartment_df['Cluster'] = kmeans.labels_.astype(str)\n",
        "\n",
        "# Plot clustered locations on the map using Folium\n",
        "map_location = folium.Map(location=[19.1334, 72.9133], zoom_start=12)\n",
        "colors = ['green', 'orange', 'red']\n",
        "\n",
        "for lat, lng, cluster in zip(apartment_df['position.lat'], apartment_df['position.lng'], apartment_df['Cluster']):\n",
        "    folium.CircleMarker(\n",
        "        [lat, lng],\n",
        "        fill=True,\n",
        "        fill_opacity=1,\n",
        "        radius=5,\n",
        "        color=colors[int(cluster)],\n",
        "    ).add_to(map_location)\n",
        "\n",
        "# Save the map\n",
        "map_location.save(\"index.html\")\n"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "jSCww9oBhLAm",
        "outputId": "92e619f2-3eb5-496c-fd1b-ad1d85073bdb"
      },
      "execution_count": 2,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            "<ipython-input-2-203d8ea12943>:20: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  apartment_df = json_normalize(apartment_data['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "<ipython-input-2-203d8ea12943>:35: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead.\n",
            "  venues = json_normalize(results['items'])\n",
            "/usr/local/lib/python3.10/dist-packages/sklearn/cluster/_kmeans.py:870: FutureWarning: The default value of `n_init` will change from 10 to 'auto' in 1.4. Set the value of `n_init` explicitly to suppress the warning\n",
            "  warnings.warn(\n"
          ]
        },
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "|    |   position.lat |   position.lng |   Cafes |   Department Stores |   Gyms |\n",
            "|----|----------------|----------------|---------|---------------------|--------|\n",
            "|  0 |        13.0609 |        77.6328 |       1 |                   1 |      1 |\n",
            "|  1 |        12.9952 |        77.6107 |       7 |                   3 |     12 |\n",
            "|  2 |        12.9738 |        77.5484 |       6 |                   6 |     16 |\n",
            "|  3 |        12.9728 |        77.5472 |       5 |                   6 |     17 |\n",
            "|  4 |        12.9723 |        77.5515 |       7 |                   5 |     15 |\n",
            "|  5 |        12.969  |        77.543  |       7 |                   8 |     20 |\n",
            "|  6 |        12.9692 |        77.5408 |       9 |                   7 |     20 |\n",
            "|  7 |        12.9686 |        77.5417 |       7 |                   7 |     20 |\n",
            "|  8 |        12.9681 |        77.5419 |       7 |                   7 |     20 |\n",
            "|  9 |        12.9671 |        77.5428 |       7 |                   6 |     20 |\n",
            "| 10 |        12.9784 |        77.6362 |      17 |                   2 |     20 |\n",
            "| 11 |        12.9644 |        77.5615 |       2 |                   1 |     17 |\n",
            "| 12 |        12.9665 |        77.539  |       8 |                   4 |     20 |\n",
            "| 13 |        12.9643 |        77.5633 |       2 |                   4 |     14 |\n",
            "| 14 |        12.9668 |        77.5367 |       8 |                   3 |     20 |\n",
            "| 15 |        12.9634 |        77.5572 |       2 |                   1 |     17 |\n",
            "| 16 |        12.9652 |        77.5367 |       7 |                   4 |     20 |\n",
            "| 17 |        12.963  |        77.5567 |       3 |                   1 |     16 |\n",
            "| 18 |        12.9628 |        77.5571 |       3 |                   1 |     16 |\n",
            "| 19 |        12.9645 |        77.5399 |       7 |                   4 |     20 |\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "apartment_df.to_csv('apartment_data.csv', index=False)\n"
      ],
      "metadata": {
        "id": "zfLiHHM-hro3"
      },
      "execution_count": 3,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 550
        },
        "id": "VZijC8t5iR2z",
        "outputId": "410a3559-c2a5-4f48-f3ad-493972747d28"
      },
      "execution_count": 4,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                        title  \\\n",
              "0                     Monarch   \n",
              "1           The Turning Point   \n",
              "2                 Mathrukrupa   \n",
              "3           Matrushree Nilaya   \n",
              "4  Lakshmi Ramachandra Nilaya   \n",
              "\n",
              "                                                  id language  \\\n",
              "0  here:pds:place:356tdr4q-6d344f77bbac4d2b92f15c...       en   \n",
              "1  here:pds:place:356tdr1y-e60ca61307424f8ab53e27...       en   \n",
              "2  here:pds:place:356jx7ps-7560eab8dea20f5c34ca52...    en-GB   \n",
              "3  here:pds:place:356jx7ps-b81ab8f7ccb20876122ac0...    en-GB   \n",
              "4  here:pds:place:356jx7ps-dd6b49221d160040427bd0...    en-GB   \n",
              "\n",
              "                                      ontologyId resultType  \\\n",
              "0  here:cm:ontology:apartment_rental_flat_rental      place   \n",
              "1  here:cm:ontology:apartment_rental_flat_rental      place   \n",
              "2  here:cm:ontology:apartment_rental_flat_rental      place   \n",
              "3  here:cm:ontology:apartment_rental_flat_rental      place   \n",
              "4  here:cm:ontology:apartment_rental_flat_rental      place   \n",
              "\n",
              "                                 access  distance  \\\n",
              "0  [{'lat': 13.06086, 'lng': 77.63303}]     10758   \n",
              "1  [{'lat': 12.99513, 'lng': 77.61076}]     16093   \n",
              "2  [{'lat': 12.97379, 'lng': 77.54841}]     17875   \n",
              "3  [{'lat': 12.97284, 'lng': 77.54712}]     17996   \n",
              "4  [{'lat': 12.97229, 'lng': 77.55147}]     18008   \n",
              "\n",
              "                                          categories  \\\n",
              "0  [{'id': '700-7200-0324', 'name': 'Apartment/Fl...   \n",
              "1  [{'id': '700-7200-0324', 'name': 'Apartment/Fl...   \n",
              "2  [{'id': '900-9300-0221', 'name': 'Residential ...   \n",
              "3  [{'id': '900-9300-0221', 'name': 'Residential ...   \n",
              "4  [{'id': '900-9300-0221', 'name': 'Residential ...   \n",
              "\n",
              "                                       address.label address.countryCode  ...  \\\n",
              "0  Monarch, Hegde Nagar Main Road, Railway Men La...                 IND  ...   \n",
              "1  The Turning Point, Saunders Road, Pulakeshi Na...                 IND  ...   \n",
              "2  Mathrukrupa, 3rd Cross Road, Vidyaranyanagar, ...                 IND  ...   \n",
              "3  Matrushree Nilaya, 1st Cross Road, Manuvana, V...                 IND  ...   \n",
              "4  Lakshmi Ramachandra Nilaya, 2nd Cross Road, Ma...                 IND  ...   \n",
              "\n",
              "  position.lng                                   contacts  \\\n",
              "0     77.63279                                        NaN   \n",
              "1     77.61071  [{'phone': [{'value': '+919845031796'}]}]   \n",
              "2     77.54842                                        NaN   \n",
              "3     77.54715                                        NaN   \n",
              "4     77.55147                                        NaN   \n",
              "\n",
              "                                          references openingHours  \\\n",
              "0                                                NaN          NaN   \n",
              "1                                                NaN          NaN   \n",
              "2  [{'supplier': {'id': 'core'}, 'id': '106943647...          NaN   \n",
              "3  [{'supplier': {'id': 'core'}, 'id': '113017170...          NaN   \n",
              "4  [{'supplier': {'id': 'core'}, 'id': '113019769...          NaN   \n",
              "\n",
              "  address.houseNumber payment.methods Cafes Department Stores Gyms  Cluster  \n",
              "0                 NaN             NaN     1                 1    1        2  \n",
              "1                 NaN             NaN     7                 3   12        1  \n",
              "2                 NaN             NaN     6                 6   16        0  \n",
              "3                 NaN             NaN     5                 6   17        0  \n",
              "4                 NaN             NaN     7                 5   15        0  \n",
              "\n",
              "[5 rows x 30 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-885c2f0f-d42f-427a-a853-ba46c9dc89a0\" class=\"colab-df-container\">\n",
              "    <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>title</th>\n",
              "      <th>id</th>\n",
              "      <th>language</th>\n",
              "      <th>ontologyId</th>\n",
              "      <th>resultType</th>\n",
              "      <th>access</th>\n",
              "      <th>distance</th>\n",
              "      <th>categories</th>\n",
              "      <th>address.label</th>\n",
              "      <th>address.countryCode</th>\n",
              "      <th>...</th>\n",
              "      <th>position.lng</th>\n",
              "      <th>contacts</th>\n",
              "      <th>references</th>\n",
              "      <th>openingHours</th>\n",
              "      <th>address.houseNumber</th>\n",
              "      <th>payment.methods</th>\n",
              "      <th>Cafes</th>\n",
              "      <th>Department Stores</th>\n",
              "      <th>Gyms</th>\n",
              "      <th>Cluster</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Monarch</td>\n",
              "      <td>here:pds:place:356tdr4q-6d344f77bbac4d2b92f15c...</td>\n",
              "      <td>en</td>\n",
              "      <td>here:cm:ontology:apartment_rental_flat_rental</td>\n",
              "      <td>place</td>\n",
              "      <td>[{'lat': 13.06086, 'lng': 77.63303}]</td>\n",
              "      <td>10758</td>\n",
              "      <td>[{'id': '700-7200-0324', 'name': 'Apartment/Fl...</td>\n",
              "      <td>Monarch, Hegde Nagar Main Road, Railway Men La...</td>\n",
              "      <td>IND</td>\n",
              "      <td>...</td>\n",
              "      <td>77.63279</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>The Turning Point</td>\n",
              "      <td>here:pds:place:356tdr1y-e60ca61307424f8ab53e27...</td>\n",
              "      <td>en</td>\n",
              "      <td>here:cm:ontology:apartment_rental_flat_rental</td>\n",
              "      <td>place</td>\n",
              "      <td>[{'lat': 12.99513, 'lng': 77.61076}]</td>\n",
              "      <td>16093</td>\n",
              "      <td>[{'id': '700-7200-0324', 'name': 'Apartment/Fl...</td>\n",
              "      <td>The Turning Point, Saunders Road, Pulakeshi Na...</td>\n",
              "      <td>IND</td>\n",
              "      <td>...</td>\n",
              "      <td>77.61071</td>\n",
              "      <td>[{'phone': [{'value': '+919845031796'}]}]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>7</td>\n",
              "      <td>3</td>\n",
              "      <td>12</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Mathrukrupa</td>\n",
              "      <td>here:pds:place:356jx7ps-7560eab8dea20f5c34ca52...</td>\n",
              "      <td>en-GB</td>\n",
              "      <td>here:cm:ontology:apartment_rental_flat_rental</td>\n",
              "      <td>place</td>\n",
              "      <td>[{'lat': 12.97379, 'lng': 77.54841}]</td>\n",
              "      <td>17875</td>\n",
              "      <td>[{'id': '900-9300-0221', 'name': 'Residential ...</td>\n",
              "      <td>Mathrukrupa, 3rd Cross Road, Vidyaranyanagar, ...</td>\n",
              "      <td>IND</td>\n",
              "      <td>...</td>\n",
              "      <td>77.54842</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[{'supplier': {'id': 'core'}, 'id': '106943647...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>16</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Matrushree Nilaya</td>\n",
              "      <td>here:pds:place:356jx7ps-b81ab8f7ccb20876122ac0...</td>\n",
              "      <td>en-GB</td>\n",
              "      <td>here:cm:ontology:apartment_rental_flat_rental</td>\n",
              "      <td>place</td>\n",
              "      <td>[{'lat': 12.97284, 'lng': 77.54712}]</td>\n",
              "      <td>17996</td>\n",
              "      <td>[{'id': '900-9300-0221', 'name': 'Residential ...</td>\n",
              "      <td>Matrushree Nilaya, 1st Cross Road, Manuvana, V...</td>\n",
              "      <td>IND</td>\n",
              "      <td>...</td>\n",
              "      <td>77.54715</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[{'supplier': {'id': 'core'}, 'id': '113017170...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5</td>\n",
              "      <td>6</td>\n",
              "      <td>17</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Lakshmi Ramachandra Nilaya</td>\n",
              "      <td>here:pds:place:356jx7ps-dd6b49221d160040427bd0...</td>\n",
              "      <td>en-GB</td>\n",
              "      <td>here:cm:ontology:apartment_rental_flat_rental</td>\n",
              "      <td>place</td>\n",
              "      <td>[{'lat': 12.97229, 'lng': 77.55147}]</td>\n",
              "      <td>18008</td>\n",
              "      <td>[{'id': '900-9300-0221', 'name': 'Residential ...</td>\n",
              "      <td>Lakshmi Ramachandra Nilaya, 2nd Cross Road, Ma...</td>\n",
              "      <td>IND</td>\n",
              "      <td>...</td>\n",
              "      <td>77.55147</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[{'supplier': {'id': 'core'}, 'id': '113019769...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>7</td>\n",
              "      <td>5</td>\n",
              "      <td>15</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 30 columns</p>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-885c2f0f-d42f-427a-a853-ba46c9dc89a0')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-885c2f0f-d42f-427a-a853-ba46c9dc89a0 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-885c2f0f-d42f-427a-a853-ba46c9dc89a0');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-4af4a36e-c72c-41e9-a84c-664ffb5a84a5\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-4af4a36e-c72c-41e9-a84c-664ffb5a84a5')\"\n",
              "            title=\"Suggest charts.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-4af4a36e-c72c-41e9-a84c-664ffb5a84a5 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 4
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "apartment_df.isnull().sum()\n",
        "#Cafes, department and Gym are non null so we are good :-))"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "KLYVjAHSiUMp",
        "outputId": "5be37e68-69e7-4c47-8bcb-c7d4ef19770b"
      },
      "execution_count": 6,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "title                   0\n",
              "id                      0\n",
              "language                0\n",
              "ontologyId              0\n",
              "resultType              0\n",
              "access                  0\n",
              "distance                0\n",
              "categories              0\n",
              "address.label           0\n",
              "address.countryCode     0\n",
              "address.countryName     0\n",
              "address.stateCode       0\n",
              "address.state           0\n",
              "address.county          0\n",
              "address.city            0\n",
              "address.district        0\n",
              "address.subdistrict     9\n",
              "address.street          2\n",
              "address.postalCode      0\n",
              "position.lat            0\n",
              "position.lng            0\n",
              "contacts               17\n",
              "references              3\n",
              "openingHours           18\n",
              "address.houseNumber    19\n",
              "payment.methods        19\n",
              "Cafes                   0\n",
              "Department Stores       0\n",
              "Gyms                    0\n",
              "Cluster                 0\n",
              "dtype: int64"
            ]
          },
          "metadata": {},
          "execution_count": 6
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [],
      "metadata": {
        "id": "RsVuPGgQjNyO"
      },
      "execution_count": null,
      "outputs": []
    }
  ]
}