{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": []
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "retRenUTV_zY"
      },
      "outputs": [],
      "source": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 206
        },
        "id": "66a5bb7c",
        "outputId": "43d093be-b202-481e-f42e-4e75f331c4d4"
      },
      "source": [
        "import pandas as pd\n",
        "project_df_config = pd.read_csv('/content/ProjectConfiguration.csv', sep=',', on_bad_lines='skip')\n",
        "display(project_df_config.head())"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "   id                          projectId                   propertyCategory  \\\n",
              "0  cmf53kkzz000ivcu89r5399s4   cmf53kkzy000fvcu8tx8jwjmr   RESIDENTIAL        \n",
              "1  cmf53kl00000kvcu86ivy65di   cmf53kkzy000fvcu8tx8jwjmr   RESIDENTIAL        \n",
              "2  cmf5r6hv20004vxpt0l657blu   cmf5r6hv00001vxptnfichhfl   RESIDENTIAL        \n",
              "3  cmfawdrnq000avc18qcvaxzi9   cmfawdrno0007vc18l0fm0z2j   RESIDENTIAL        \n",
              "4  cmfawdrnr000dvc188hupv4yy   cmfawdrno0007vc18l0fm0z2j   RESIDENTIAL        \n",
              "\n",
              "    type          customBHK  \n",
              "0   1BHK                     \n",
              "1   2BHK                     \n",
              "2   2BHK               2BHK  \n",
              "3   1BHK               1BHK  \n",
              "4   3BHK               3BHK  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-236cbcab-b2c8-426b-a276-266c57c8e388\" 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>id</th>\n",
              "      <th>projectId</th>\n",
              "      <th>propertyCategory</th>\n",
              "      <th>type</th>\n",
              "      <th>customBHK</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>cmf53kkzz000ivcu89r5399s4</td>\n",
              "      <td>cmf53kkzy000fvcu8tx8jwjmr</td>\n",
              "      <td>RESIDENTIAL</td>\n",
              "      <td>1BHK</td>\n",
              "      <td></td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>cmf53kl00000kvcu86ivy65di</td>\n",
              "      <td>cmf53kkzy000fvcu8tx8jwjmr</td>\n",
              "      <td>RESIDENTIAL</td>\n",
              "      <td>2BHK</td>\n",
              "      <td></td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>cmf5r6hv20004vxpt0l657blu</td>\n",
              "      <td>cmf5r6hv00001vxptnfichhfl</td>\n",
              "      <td>RESIDENTIAL</td>\n",
              "      <td>2BHK</td>\n",
              "      <td>2BHK</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>cmfawdrnq000avc18qcvaxzi9</td>\n",
              "      <td>cmfawdrno0007vc18l0fm0z2j</td>\n",
              "      <td>RESIDENTIAL</td>\n",
              "      <td>1BHK</td>\n",
              "      <td>1BHK</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>cmfawdrnr000dvc188hupv4yy</td>\n",
              "      <td>cmfawdrno0007vc18l0fm0z2j</td>\n",
              "      <td>RESIDENTIAL</td>\n",
              "      <td>3BHK</td>\n",
              "      <td>3BHK</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-236cbcab-b2c8-426b-a276-266c57c8e388')\"\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-236cbcab-b2c8-426b-a276-266c57c8e388 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-236cbcab-b2c8-426b-a276-266c57c8e388');\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-7efb52c6-b836-479d-aaa4-9549b258d50b\">\n",
              "      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-7efb52c6-b836-479d-aaa4-9549b258d50b')\"\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-7efb52c6-b836-479d-aaa4-9549b258d50b button');\n",
              "          quickchartButtonEl.style.display =\n",
              "            google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "        })();\n",
              "      </script>\n",
              "    </div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "summary": "{\n  \"name\": \"display(project_df_config\",\n  \"rows\": 5,\n  \"fields\": [\n    {\n      \"column\": \"id                       \",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 5,\n        \"samples\": [\n          \"cmf53kl00000kvcu86ivy65di\",\n          \"cmfawdrnr000dvc188hupv4yy\",\n          \"cmf5r6hv20004vxpt0l657blu\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \" projectId                \",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 3,\n        \"samples\": [\n          \" cmf53kkzy000fvcu8tx8jwjmr\",\n          \" cmf5r6hv00001vxptnfichhfl\",\n          \" cmfawdrno0007vc18l0fm0z2j\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \" propertyCategory\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 1,\n        \"samples\": [\n          \" RESIDENTIAL     \"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \" type        \",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 3,\n        \"samples\": [\n          \" 1BHK        \"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \" customBHK\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 4,\n        \"samples\": [\n          \" 2BHK\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"
            }
          },
          "metadata": {}
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "project_df_config_var = pd.read_csv('/content/ProjectConfigurationVariant.csv', sep=',', on_bad_lines='skip')\n",
        "display(project_df_config_var.head())"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 313
        },
        "id": "t4eD2J_oWxQA",
        "outputId": "adbbc6e4-4464-4733-e227-ca88b4604888"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "   id                          \"configurationId\"             \"bathrooms\"  \\\n",
              "0  cmf5r6hv20005vxpt3yfnl2qp   \"cmf5r6hv20004vxpt0l657blu\"   \"12\"          \n",
              "1  cmf5r6hv20006vxptcx3lmm05   \"cmf5r6hv20004vxpt0l657blu\"   \"3\"           \n",
              "2  cmfawdrnq000bvc188680qjyx   \"cmfawdrnq000avc18qcvaxzi9\"   \"1\"           \n",
              "3  cmfawdrnr000cvc1897rpsu1b   \"cmfawdrnq000avc18qcvaxzi9\"   \"1\"           \n",
              "4  cmfawdrnr000evc18jwvlery4   \"cmfawdrnr000dvc188hupv4yy\"   \"3\"           \n",
              "\n",
              "    \"privateBathrooms\"   \"publicBathrooms\"   \"balcony\"   \"furnishedType\"   \\\n",
              "0                                            \"3\"         \"UNFURNISHED\"      \n",
              "1                                            \"2\"         \"UNFURNISHED\"      \n",
              "2                                            \"1\"         \"UNFURNISHED\"      \n",
              "3                                            \"1\"         \"UNFURNISHED\"      \n",
              "4                                            \"2\"         \"UNFURNISHED\"      \n",
              "\n",
              "   \"furnishingType\"                                                             \\\n",
              "0   \"[]\"                                         ...                             \n",
              "1   \"[]\"                                         ...                             \n",
              "2   \"[]\"                                         ...                             \n",
              "3   \"[]\"                                         ...                             \n",
              "4   \"[]\"                                         ...                             \n",
              "\n",
              "    \"lift\"    \"ageOfProperty\"   \"parkingType\"   \"listingType\"  \\\n",
              "0   \"false\"                                     \"Sell\"          \n",
              "1   \"false\"                                     \"Sell\"          \n",
              "2   \"false\"                                     \"Sell\"          \n",
              "3   \"false\"                                     \"Sell\"          \n",
              "4   \"false\"                                     \"Sell\"          \n",
              "\n",
              "   \"floorPlanImage\"                                                                           \\\n",
              "0   \"https://pub-d28896f69c604ec5aa743cb0397740d9...                                           \n",
              "1   \"https://pub-d28896f69c604ec5aa743cb0397740d9...                                           \n",
              "2   \"https://pub-d28896f69c604ec5aa743cb0397740d9...                                           \n",
              "3   \"https://pub-d28896f69c604ec5aa743cb0397740d9...                                           \n",
              "4   \"https://pub-d28896f69c604ec5aa743cb0397740d9...                                           \n",
              "\n",
              "    \"carpetArea\"   \"price\"      \\\n",
              "0   \"972\"          \"120000000\"   \n",
              "1   \"188.73\"       \"210000000\"   \n",
              "2   \"426.57\"       \"13000000\"    \n",
              "3   \"460.8\"        \"15000000\"    \n",
              "4   \"893.08\"       \"29000000\"    \n",
              "\n",
              "   \"propertyImages\"                                                                                                                                                                           \\\n",
              "0   \"[\"\"https://pub-d28896f69c604ec5aa743cb039774...                                                                                                                                           \n",
              "1   \"[\"\"https://pub-d28896f69c604ec5aa743cb039774...                                                                                                                                           \n",
              "2   \"[\"\"https://pub-d28896f69c604ec5aa743cb039774...                                                                                                                                           \n",
              "3   \"[\"\"https://pub-d28896f69c604ec5aa743cb039774...                                                                                                                                           \n",
              "4   \"[\"\"https://pub-d28896f69c604ec5aa743cb039774...                                                                                                                                           \n",
              "\n",
              "    \"maintenanceCharges\"   \"aboutProperty\"              \\\n",
              "0   \"faded \"               \"about property \"             \n",
              "1                          \"fsdaffdsafsfdddsa\"           \n",
              "2                          \"na\"                          \n",
              "3                          \"na\"                          \n",
              "4                          \"na\"                          \n",
              "\n",
              "    \"createdAt\"                               \"updatedAt\"  \n",
              "0   \"2025-09-04 18:42:08.748\"   \"2025-09-04 18:42:08.748\"  \n",
              "1   \"2025-09-04 18:42:08.748\"   \"2025-09-04 18:42:08.748\"  \n",
              "2   \"2025-09-08 09:06:36.995\"   \"2025-09-08 09:06:36.995\"  \n",
              "3   \"2025-09-08 09:06:36.995\"   \"2025-09-08 09:06:36.995\"  \n",
              "4   \"2025-09-08 09:06:36.995\"   \"2025-09-08 09:06:36.995\"  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-3eccd1d8-3d5c-47a2-8062-19b857c5924a\" 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>id</th>\n",
              "      <th>\"configurationId\"</th>\n",
              "      <th>\"bathrooms\"</th>\n",
              "      <th>\"privateBathrooms\"</th>\n",
              "      <th>\"publicBathrooms\"</th>\n",
              "      <th>\"balcony\"</th>\n",
              "      <th>\"furnishedType\"</th>\n",
              "      <th>\"furnishingType\"</th>\n",
              "      <th>\"lift\"</th>\n",
              "      <th>\"ageOfProperty\"</th>\n",
              "      <th>\"parkingType\"</th>\n",
              "      <th>\"listingType\"</th>\n",
              "      <th>\"floorPlanImage\"</th>\n",
              "      <th>\"carpetArea\"</th>\n",
              "      <th>\"price\"</th>\n",
              "      <th>\"propertyImages\"</th>\n",
              "      <th>\"maintenanceCharges\"</th>\n",
              "      <th>\"aboutProperty\"</th>\n",
              "      <th>\"createdAt\"</th>\n",
              "      <th>\"updatedAt\"</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>cmf5r6hv20005vxpt3yfnl2qp</td>\n",
              "      <td>\"cmf5r6hv20004vxpt0l657blu\"</td>\n",
              "      <td>\"12\"</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>\"3\"</td>\n",
              "      <td>\"UNFURNISHED\"</td>\n",
              "      <td>\"[]\"                                         ...</td>\n",
              "      <td>\"false\"</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>\"Sell\"</td>\n",
              "      <td>\"https://pub-d28896f69c604ec5aa743cb0397740d9...</td>\n",
              "      <td>\"972\"</td>\n",
              "      <td>\"120000000\"</td>\n",
              "      <td>\"[\"\"https://pub-d28896f69c604ec5aa743cb039774...</td>\n",
              "      <td>\"faded \"</td>\n",
              "      <td>\"about property \"</td>\n",
              "      <td>\"2025-09-04 18:42:08.748\"</td>\n",
              "      <td>\"2025-09-04 18:42:08.748\"</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>cmf5r6hv20006vxptcx3lmm05</td>\n",
              "      <td>\"cmf5r6hv20004vxpt0l657blu\"</td>\n",
              "      <td>\"3\"</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>\"2\"</td>\n",
              "      <td>\"UNFURNISHED\"</td>\n",
              "      <td>\"[]\"                                         ...</td>\n",
              "      <td>\"false\"</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>\"Sell\"</td>\n",
              "      <td>\"https://pub-d28896f69c604ec5aa743cb0397740d9...</td>\n",
              "      <td>\"188.73\"</td>\n",
              "      <td>\"210000000\"</td>\n",
              "      <td>\"[\"\"https://pub-d28896f69c604ec5aa743cb039774...</td>\n",
              "      <td></td>\n",
              "      <td>\"fsdaffdsafsfdddsa\"</td>\n",
              "      <td>\"2025-09-04 18:42:08.748\"</td>\n",
              "      <td>\"2025-09-04 18:42:08.748\"</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>cmfawdrnq000bvc188680qjyx</td>\n",
              "      <td>\"cmfawdrnq000avc18qcvaxzi9\"</td>\n",
              "      <td>\"1\"</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>\"1\"</td>\n",
              "      <td>\"UNFURNISHED\"</td>\n",
              "      <td>\"[]\"                                         ...</td>\n",
              "      <td>\"false\"</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>\"Sell\"</td>\n",
              "      <td>\"https://pub-d28896f69c604ec5aa743cb0397740d9...</td>\n",
              "      <td>\"426.57\"</td>\n",
              "      <td>\"13000000\"</td>\n",
              "      <td>\"[\"\"https://pub-d28896f69c604ec5aa743cb039774...</td>\n",
              "      <td></td>\n",
              "      <td>\"na\"</td>\n",
              "      <td>\"2025-09-08 09:06:36.995\"</td>\n",
              "      <td>\"2025-09-08 09:06:36.995\"</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>cmfawdrnr000cvc1897rpsu1b</td>\n",
              "      <td>\"cmfawdrnq000avc18qcvaxzi9\"</td>\n",
              "      <td>\"1\"</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>\"1\"</td>\n",
              "      <td>\"UNFURNISHED\"</td>\n",
              "      <td>\"[]\"                                         ...</td>\n",
              "      <td>\"false\"</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>\"Sell\"</td>\n",
              "      <td>\"https://pub-d28896f69c604ec5aa743cb0397740d9...</td>\n",
              "      <td>\"460.8\"</td>\n",
              "      <td>\"15000000\"</td>\n",
              "      <td>\"[\"\"https://pub-d28896f69c604ec5aa743cb039774...</td>\n",
              "      <td></td>\n",
              "      <td>\"na\"</td>\n",
              "      <td>\"2025-09-08 09:06:36.995\"</td>\n",
              "      <td>\"2025-09-08 09:06:36.995\"</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>cmfawdrnr000evc18jwvlery4</td>\n",
              "      <td>\"cmfawdrnr000dvc188hupv4yy\"</td>\n",
              "      <td>\"3\"</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>\"2\"</td>\n",
              "      <td>\"UNFURNISHED\"</td>\n",
              "      <td>\"[]\"                                         ...</td>\n",
              "      <td>\"false\"</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>\"Sell\"</td>\n",
              "      <td>\"https://pub-d28896f69c604ec5aa743cb0397740d9...</td>\n",
              "      <td>\"893.08\"</td>\n",
              "      <td>\"29000000\"</td>\n",
              "      <td>\"[\"\"https://pub-d28896f69c604ec5aa743cb039774...</td>\n",
              "      <td></td>\n",
              "      <td>\"na\"</td>\n",
              "      <td>\"2025-09-08 09:06:36.995\"</td>\n",
              "      <td>\"2025-09-08 09:06:36.995\"</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-3eccd1d8-3d5c-47a2-8062-19b857c5924a')\"\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-3eccd1d8-3d5c-47a2-8062-19b857c5924a 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-3eccd1d8-3d5c-47a2-8062-19b857c5924a');\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-50b8038f-937e-410a-b7be-5277bd821bb0\">\n",
              "      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-50b8038f-937e-410a-b7be-5277bd821bb0')\"\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-50b8038f-937e-410a-b7be-5277bd821bb0 button');\n",
              "          quickchartButtonEl.style.display =\n",
              "            google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "        })();\n",
              "      </script>\n",
              "    </div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "summary": "{\n  \"name\": \"display(project_df_config_var\",\n  \"rows\": 5,\n  \"fields\": [\n    {\n      \"column\": \"id                       \",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 5,\n        \"samples\": [\n          \"cmf5r6hv20006vxptcx3lmm05\",\n          \"cmfawdrnr000evc18jwvlery4\",\n          \"cmfawdrnq000bvc188680qjyx\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \" \\\"configurationId\\\"          \",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 3,\n        \"samples\": [\n          \" \\\"cmf5r6hv20004vxpt0l657blu\\\"\",\n          \" \\\"cmfawdrnq000avc18qcvaxzi9\\\"\",\n          \" \\\"cmfawdrnr000dvc188hupv4yy\\\"\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \" \\\"bathrooms\\\"\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 3,\n        \"samples\": [\n          \" \\\"12\\\"       \",\n          \" \\\"3\\\"        \",\n          \" \\\"1\\\"        \"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \" \\\"privateBathrooms\\\"\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 1,\n        \"samples\": [\n          \"                   \"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \" \\\"publicBathrooms\\\"\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 1,\n        \"samples\": [\n          \"                  \"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \" \\\"balcony\\\"\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 3,\n        \"samples\": [\n          \" \\\"3\\\"      \"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \" \\\"furnishedType\\\" \",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 1,\n        \"samples\": [\n          \" \\\"UNFURNISHED\\\"   \"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \" \\\"furnishingType\\\"                                                           \",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 1,\n        \"samples\": [\n          \" \\\"[]\\\"                                                                       \"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \" \\\"lift\\\" \",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 1,\n        \"samples\": [\n          \" \\\"false\\\"\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \" \\\"ageOfProperty\\\"\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 1,\n        \"samples\": [\n          \"                \"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \" \\\"parkingType\\\"\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 1,\n        \"samples\": [\n          \"              \"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \" \\\"listingType\\\"\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 1,\n        \"samples\": [\n          \" \\\"Sell\\\"       \"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \" \\\"floorPlanImage\\\"                                                                         \",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 5,\n        \"samples\": [\n          \" \\\"https://pub-d28896f69c604ec5aa743cb0397740d9.r2.dev/1757011238542-2d39a8b06669406b.jpg\\\" \"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \" \\\"carpetArea\\\"\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 5,\n        \"samples\": [\n          \" \\\"188.73\\\"    \"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \" \\\"price\\\"    \",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 5,\n        \"samples\": [\n          \" \\\"210000000\\\"\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \" \\\"propertyImages\\\"                                                                                                                                                                         \",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 5,\n        \"samples\": [\n          \" \\\"[\\\"\\\"https://pub-d28896f69c604ec5aa743cb0397740d9.r2.dev/1757011238542-bd3d1a40c2d7fadb.jpg\\\"\\\"]\\\"                                                                                           \"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \" \\\"maintenanceCharges\\\"\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 2,\n        \"samples\": [\n          \"                     \"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \" \\\"aboutProperty\\\"            \",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 3,\n        \"samples\": [\n          \" \\\"about property \\\"          \"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \" \\\"createdAt\\\"              \",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 2,\n        \"samples\": [\n          \" \\\"2025-09-08 09:06:36.995\\\"\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \" \\\"updatedAt\\\"\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 2,\n        \"samples\": [\n          \" \\\"2025-09-08 09:06:36.995\\\"\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"
            }
          },
          "metadata": {}
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Clean up column names by removing quotes and spaces\n",
        "project_df_config_var.columns = project_df_config_var.columns.str.replace('\"', '').str.strip()\n",
        "project_df_config.columns = project_df_config.columns.str.strip()\n",
        "\n",
        "# Perform the left merge\n",
        "merged_config_df = pd.merge(project_df_config_var, project_df_config, left_on='configurationId', right_on='id', how='left')\n",
        "\n",
        "# Display the first few rows of the merged dataframe\n",
        "display(merged_config_df.head())"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 342
        },
        "id": "pcPvJV8gZCjt",
        "outputId": "c8f97191-b8e3-4c7a-b47f-ac0f5c049706"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "                        id_x               configurationId     bathrooms  \\\n",
              "0  cmf5r6hv20005vxpt3yfnl2qp   \"cmf5r6hv20004vxpt0l657blu\"   \"12\"          \n",
              "1  cmf5r6hv20006vxptcx3lmm05   \"cmf5r6hv20004vxpt0l657blu\"   \"3\"           \n",
              "2  cmfawdrnq000bvc188680qjyx   \"cmfawdrnq000avc18qcvaxzi9\"   \"1\"           \n",
              "3  cmfawdrnr000cvc1897rpsu1b   \"cmfawdrnq000avc18qcvaxzi9\"   \"1\"           \n",
              "4  cmfawdrnr000evc18jwvlery4   \"cmfawdrnr000dvc188hupv4yy\"   \"3\"           \n",
              "\n",
              "      privateBathrooms     publicBathrooms     balcony      furnishedType  \\\n",
              "0                                            \"3\"         \"UNFURNISHED\"      \n",
              "1                                            \"2\"         \"UNFURNISHED\"      \n",
              "2                                            \"1\"         \"UNFURNISHED\"      \n",
              "3                                            \"1\"         \"UNFURNISHED\"      \n",
              "4                                            \"2\"         \"UNFURNISHED\"      \n",
              "\n",
              "                                      furnishingType      lift  \\\n",
              "0   \"[]\"                                         ...   \"false\"   \n",
              "1   \"[]\"                                         ...   \"false\"   \n",
              "2   \"[]\"                                         ...   \"false\"   \n",
              "3   \"[]\"                                         ...   \"false\"   \n",
              "4   \"[]\"                                         ...   \"false\"   \n",
              "\n",
              "      ageOfProperty  ...                                     propertyImages  \\\n",
              "0                    ...   \"[\"\"https://pub-d28896f69c604ec5aa743cb039774...   \n",
              "1                    ...   \"[\"\"https://pub-d28896f69c604ec5aa743cb039774...   \n",
              "2                    ...   \"[\"\"https://pub-d28896f69c604ec5aa743cb039774...   \n",
              "3                    ...   \"[\"\"https://pub-d28896f69c604ec5aa743cb039774...   \n",
              "4                    ...   \"[\"\"https://pub-d28896f69c604ec5aa743cb039774...   \n",
              "\n",
              "      maintenanceCharges                 aboutProperty  \\\n",
              "0   \"faded \"               \"about property \"             \n",
              "1                          \"fsdaffdsafsfdddsa\"           \n",
              "2                          \"na\"                          \n",
              "3                          \"na\"                          \n",
              "4                          \"na\"                          \n",
              "\n",
              "                    createdAt                   updatedAt id_y projectId  \\\n",
              "0   \"2025-09-04 18:42:08.748\"   \"2025-09-04 18:42:08.748\"  NaN       NaN   \n",
              "1   \"2025-09-04 18:42:08.748\"   \"2025-09-04 18:42:08.748\"  NaN       NaN   \n",
              "2   \"2025-09-08 09:06:36.995\"   \"2025-09-08 09:06:36.995\"  NaN       NaN   \n",
              "3   \"2025-09-08 09:06:36.995\"   \"2025-09-08 09:06:36.995\"  NaN       NaN   \n",
              "4   \"2025-09-08 09:06:36.995\"   \"2025-09-08 09:06:36.995\"  NaN       NaN   \n",
              "\n",
              "  propertyCategory type customBHK  \n",
              "0              NaN  NaN       NaN  \n",
              "1              NaN  NaN       NaN  \n",
              "2              NaN  NaN       NaN  \n",
              "3              NaN  NaN       NaN  \n",
              "4              NaN  NaN       NaN  \n",
              "\n",
              "[5 rows x 25 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-83f82480-1acd-431a-a030-0cb3efd789b3\" 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>id_x</th>\n",
              "      <th>configurationId</th>\n",
              "      <th>bathrooms</th>\n",
              "      <th>privateBathrooms</th>\n",
              "      <th>publicBathrooms</th>\n",
              "      <th>balcony</th>\n",
              "      <th>furnishedType</th>\n",
              "      <th>furnishingType</th>\n",
              "      <th>lift</th>\n",
              "      <th>ageOfProperty</th>\n",
              "      <th>...</th>\n",
              "      <th>propertyImages</th>\n",
              "      <th>maintenanceCharges</th>\n",
              "      <th>aboutProperty</th>\n",
              "      <th>createdAt</th>\n",
              "      <th>updatedAt</th>\n",
              "      <th>id_y</th>\n",
              "      <th>projectId</th>\n",
              "      <th>propertyCategory</th>\n",
              "      <th>type</th>\n",
              "      <th>customBHK</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>cmf5r6hv20005vxpt3yfnl2qp</td>\n",
              "      <td>\"cmf5r6hv20004vxpt0l657blu\"</td>\n",
              "      <td>\"12\"</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>\"3\"</td>\n",
              "      <td>\"UNFURNISHED\"</td>\n",
              "      <td>\"[]\"                                         ...</td>\n",
              "      <td>\"false\"</td>\n",
              "      <td></td>\n",
              "      <td>...</td>\n",
              "      <td>\"[\"\"https://pub-d28896f69c604ec5aa743cb039774...</td>\n",
              "      <td>\"faded \"</td>\n",
              "      <td>\"about property \"</td>\n",
              "      <td>\"2025-09-04 18:42:08.748\"</td>\n",
              "      <td>\"2025-09-04 18:42:08.748\"</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>cmf5r6hv20006vxptcx3lmm05</td>\n",
              "      <td>\"cmf5r6hv20004vxpt0l657blu\"</td>\n",
              "      <td>\"3\"</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>\"2\"</td>\n",
              "      <td>\"UNFURNISHED\"</td>\n",
              "      <td>\"[]\"                                         ...</td>\n",
              "      <td>\"false\"</td>\n",
              "      <td></td>\n",
              "      <td>...</td>\n",
              "      <td>\"[\"\"https://pub-d28896f69c604ec5aa743cb039774...</td>\n",
              "      <td></td>\n",
              "      <td>\"fsdaffdsafsfdddsa\"</td>\n",
              "      <td>\"2025-09-04 18:42:08.748\"</td>\n",
              "      <td>\"2025-09-04 18:42:08.748\"</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>cmfawdrnq000bvc188680qjyx</td>\n",
              "      <td>\"cmfawdrnq000avc18qcvaxzi9\"</td>\n",
              "      <td>\"1\"</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>\"1\"</td>\n",
              "      <td>\"UNFURNISHED\"</td>\n",
              "      <td>\"[]\"                                         ...</td>\n",
              "      <td>\"false\"</td>\n",
              "      <td></td>\n",
              "      <td>...</td>\n",
              "      <td>\"[\"\"https://pub-d28896f69c604ec5aa743cb039774...</td>\n",
              "      <td></td>\n",
              "      <td>\"na\"</td>\n",
              "      <td>\"2025-09-08 09:06:36.995\"</td>\n",
              "      <td>\"2025-09-08 09:06:36.995\"</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>cmfawdrnr000cvc1897rpsu1b</td>\n",
              "      <td>\"cmfawdrnq000avc18qcvaxzi9\"</td>\n",
              "      <td>\"1\"</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>\"1\"</td>\n",
              "      <td>\"UNFURNISHED\"</td>\n",
              "      <td>\"[]\"                                         ...</td>\n",
              "      <td>\"false\"</td>\n",
              "      <td></td>\n",
              "      <td>...</td>\n",
              "      <td>\"[\"\"https://pub-d28896f69c604ec5aa743cb039774...</td>\n",
              "      <td></td>\n",
              "      <td>\"na\"</td>\n",
              "      <td>\"2025-09-08 09:06:36.995\"</td>\n",
              "      <td>\"2025-09-08 09:06:36.995\"</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>cmfawdrnr000evc18jwvlery4</td>\n",
              "      <td>\"cmfawdrnr000dvc188hupv4yy\"</td>\n",
              "      <td>\"3\"</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>\"2\"</td>\n",
              "      <td>\"UNFURNISHED\"</td>\n",
              "      <td>\"[]\"                                         ...</td>\n",
              "      <td>\"false\"</td>\n",
              "      <td></td>\n",
              "      <td>...</td>\n",
              "      <td>\"[\"\"https://pub-d28896f69c604ec5aa743cb039774...</td>\n",
              "      <td></td>\n",
              "      <td>\"na\"</td>\n",
              "      <td>\"2025-09-08 09:06:36.995\"</td>\n",
              "      <td>\"2025-09-08 09:06:36.995\"</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 25 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-83f82480-1acd-431a-a030-0cb3efd789b3')\"\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-83f82480-1acd-431a-a030-0cb3efd789b3 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-83f82480-1acd-431a-a030-0cb3efd789b3');\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-fa1c0a35-09d2-45f3-84e1-3c7f404865fd\">\n",
              "      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-fa1c0a35-09d2-45f3-84e1-3c7f404865fd')\"\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-fa1c0a35-09d2-45f3-84e1-3c7f404865fd button');\n",
              "          quickchartButtonEl.style.display =\n",
              "            google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "        })();\n",
              "      </script>\n",
              "    </div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe"
            }
          },
          "metadata": {}
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "f230f8e3",
        "outputId": "1299b902-56f1-4c77-d96a-8a5a4f36cd72"
      },
      "source": [
        "print(f\"The merged_config_df has {merged_config_df.shape[0]} rows and {merged_config_df.shape[1]} columns.\")"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "The merged_config_df has 78 rows and 25 columns.\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "merged_config_df.to_csv('final_merged_data100.csv', index=False)"
      ],
      "metadata": {
        "id": "hDr5uJqvbg2Y"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "project_adr_df = pd.read_csv('/content/ProjectAddress.csv', sep=',', on_bad_lines='skip')\n",
        "display(project_adr_df.head())"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 310
        },
        "id": "kkdwonEdcbgf",
        "outputId": "b3cd5648-6818-4ac8-8b16-c1e383cf98af"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "   id                          projectId                  \\\n",
              "0  cmf53kl01000nvcu8ibut7fka   cmf53kkzy000fvcu8tx8jwjmr   \n",
              "1  cmfc6pq1n000cvca0gpdjstzf   cmfc6pq1k0001vca0ikzb258m   \n",
              "2  cmfc79ip8001lvca0o1ls6fuz   cmfc79ip5001cvca0qht6o44p   \n",
              "3  cmfcccifw004vvca0mvtcgxos   cmfcccifs004nvca0b7im3r5a   \n",
              "4  cmff8swbn0007vxp7bhj7cmqv   cmff8swbm0001vxp7pe3neibi   \n",
              "\n",
              "    landmark                                 \\\n",
              "0   Babys school                              \n",
              "1   JBCN International School Mulund          \n",
              "2   JBCN International School Parel           \n",
              "3   Lodha Xperia Mall                         \n",
              "4   sdfgb                                     \n",
              "\n",
              "   fullAddress                                                                                                                                     \\\n",
              "0   Mumbai chembur                               ...                                                                                                \n",
              "1   Prataprao Gujar Rd Neelam Nagar Mulund East M...                                                                                                \n",
              "2   AVENUE 15 Ramesh Barrel Supplying Company K.T...                                                                                                \n",
              "3   64C5+C63 Dombivli East Dombivli Maharashtra 4...                                                                                                \n",
              "4   asdfgh                                       ...                                                                                                \n",
              "\n",
              "    pincode  \n",
              "0    411017  \n",
              "1    400081  \n",
              "2    400015  \n",
              "3    421201  \n",
              "4    123456  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-26fcfdd0-618f-4134-b6d8-f04d97a19871\" 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>id</th>\n",
              "      <th>projectId</th>\n",
              "      <th>landmark</th>\n",
              "      <th>fullAddress</th>\n",
              "      <th>pincode</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>cmf53kl01000nvcu8ibut7fka</td>\n",
              "      <td>cmf53kkzy000fvcu8tx8jwjmr</td>\n",
              "      <td>Babys school</td>\n",
              "      <td>Mumbai chembur                               ...</td>\n",
              "      <td>411017</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>cmfc6pq1n000cvca0gpdjstzf</td>\n",
              "      <td>cmfc6pq1k0001vca0ikzb258m</td>\n",
              "      <td>JBCN International School Mulund</td>\n",
              "      <td>Prataprao Gujar Rd Neelam Nagar Mulund East M...</td>\n",
              "      <td>400081</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>cmfc79ip8001lvca0o1ls6fuz</td>\n",
              "      <td>cmfc79ip5001cvca0qht6o44p</td>\n",
              "      <td>JBCN International School Parel</td>\n",
              "      <td>AVENUE 15 Ramesh Barrel Supplying Company K.T...</td>\n",
              "      <td>400015</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>cmfcccifw004vvca0mvtcgxos</td>\n",
              "      <td>cmfcccifs004nvca0b7im3r5a</td>\n",
              "      <td>Lodha Xperia Mall</td>\n",
              "      <td>64C5+C63 Dombivli East Dombivli Maharashtra 4...</td>\n",
              "      <td>421201</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>cmff8swbn0007vxp7bhj7cmqv</td>\n",
              "      <td>cmff8swbm0001vxp7pe3neibi</td>\n",
              "      <td>sdfgb</td>\n",
              "      <td>asdfgh                                       ...</td>\n",
              "      <td>123456</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-26fcfdd0-618f-4134-b6d8-f04d97a19871')\"\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-26fcfdd0-618f-4134-b6d8-f04d97a19871 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-26fcfdd0-618f-4134-b6d8-f04d97a19871');\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-828585da-a101-4c4c-9d22-673548d59f30\">\n",
              "      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-828585da-a101-4c4c-9d22-673548d59f30')\"\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-828585da-a101-4c4c-9d22-673548d59f30 button');\n",
              "          quickchartButtonEl.style.display =\n",
              "            google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "        })();\n",
              "      </script>\n",
              "    </div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "summary": "{\n  \"name\": \"display(project_adr_df\",\n  \"rows\": 5,\n  \"fields\": [\n    {\n      \"column\": \"id                       \",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 5,\n        \"samples\": [\n          \"cmfc6pq1n000cvca0gpdjstzf\",\n          \"cmff8swbn0007vxp7bhj7cmqv\",\n          \"cmfc79ip8001lvca0o1ls6fuz\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \" projectId                \",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 5,\n        \"samples\": [\n          \" cmfc6pq1k0001vca0ikzb258m\",\n          \" cmff8swbm0001vxp7pe3neibi\",\n          \" cmfc79ip5001cvca0qht6o44p\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \" landmark                               \",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 5,\n        \"samples\": [\n          \" JBCN International School Mulund       \",\n          \" sdfgb                                  \",\n          \" JBCN International School Parel        \"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \" fullAddress                                                                                                                                   \",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 5,\n        \"samples\": [\n          \" Prataprao Gujar Rd Neelam Nagar Mulund East Mumbai Maharashtra 400081                                                                         \",\n          \" asdfgh                                                                                                                                        \",\n          \" AVENUE 15 Ramesh Barrel Supplying Company K.T.Gupta Wadi S.P.Murai Rd behind Sewri Road Sewri W Maharashtra 400015                            \"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \" pincode\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 127590,\n        \"min\": 123456,\n        \"max\": 421201,\n        \"num_unique_values\": 5,\n        \"samples\": [\n          400081,\n          123456,\n          400015\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"
            }
          },
          "metadata": {}
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "d3c5cc71",
        "outputId": "bf2b1a0b-b8b0-4744-85a0-48cd3c29bfa2"
      },
      "source": [
        "print(\"Columns in merged_config_df:\", merged_config_df.columns)\n",
        "print(\"Columns in project_adr_df:\", project_adr_df.columns)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Columns in merged_config_df: Index(['id_x', 'configurationId', 'bathrooms', 'privateBathrooms',\n",
            "       'publicBathrooms', 'balcony', 'furnishedType', 'furnishingType', 'lift',\n",
            "       'ageOfProperty', 'parkingType', 'listingType', 'floorPlanImage',\n",
            "       'carpetArea', 'price', 'propertyImages', 'maintenanceCharges',\n",
            "       'aboutProperty', 'createdAt', 'updatedAt', 'id_y', 'projectId',\n",
            "       'propertyCategory', 'type', 'customBHK'],\n",
            "      dtype='object')\n",
            "Columns in project_adr_df: Index(['id                       ', ' projectId                ',\n",
            "       ' landmark                               ',\n",
            "       ' fullAddress                                                                                                                                   ',\n",
            "       ' pincode'],\n",
            "      dtype='object')\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 342
        },
        "id": "91c5028d",
        "outputId": "5c9b438d-1134-4f93-c67c-3d9113abf76e"
      },
      "source": [
        "# Clean up column names by removing quotes and spaces\n",
        "merged_config_df.columns = merged_config_df.columns.str.strip()\n",
        "project_adr_df.columns = project_adr_df.columns.str.strip()\n",
        "\n",
        "# Perform the left merge\n",
        "final_merged_df = pd.merge(merged_config_df, project_adr_df, on='projectId', how='left')\n",
        "\n",
        "# Display the first few rows of the merged dataframe\n",
        "display(final_merged_df.head())"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "                        id_x               configurationId     bathrooms  \\\n",
              "0  cmf5r6hv20005vxpt3yfnl2qp   \"cmf5r6hv20004vxpt0l657blu\"   \"12\"          \n",
              "1  cmf5r6hv20006vxptcx3lmm05   \"cmf5r6hv20004vxpt0l657blu\"   \"3\"           \n",
              "2  cmfawdrnq000bvc188680qjyx   \"cmfawdrnq000avc18qcvaxzi9\"   \"1\"           \n",
              "3  cmfawdrnr000cvc1897rpsu1b   \"cmfawdrnq000avc18qcvaxzi9\"   \"1\"           \n",
              "4  cmfawdrnr000evc18jwvlery4   \"cmfawdrnr000dvc188hupv4yy\"   \"3\"           \n",
              "\n",
              "      privateBathrooms     publicBathrooms     balcony      furnishedType  \\\n",
              "0                                            \"3\"         \"UNFURNISHED\"      \n",
              "1                                            \"2\"         \"UNFURNISHED\"      \n",
              "2                                            \"1\"         \"UNFURNISHED\"      \n",
              "3                                            \"1\"         \"UNFURNISHED\"      \n",
              "4                                            \"2\"         \"UNFURNISHED\"      \n",
              "\n",
              "                                      furnishingType      lift  \\\n",
              "0   \"[]\"                                         ...   \"false\"   \n",
              "1   \"[]\"                                         ...   \"false\"   \n",
              "2   \"[]\"                                         ...   \"false\"   \n",
              "3   \"[]\"                                         ...   \"false\"   \n",
              "4   \"[]\"                                         ...   \"false\"   \n",
              "\n",
              "      ageOfProperty  ...                   updatedAt id_y projectId  \\\n",
              "0                    ...   \"2025-09-04 18:42:08.748\"  NaN       NaN   \n",
              "1                    ...   \"2025-09-04 18:42:08.748\"  NaN       NaN   \n",
              "2                    ...   \"2025-09-08 09:06:36.995\"  NaN       NaN   \n",
              "3                    ...   \"2025-09-08 09:06:36.995\"  NaN       NaN   \n",
              "4                    ...   \"2025-09-08 09:06:36.995\"  NaN       NaN   \n",
              "\n",
              "  propertyCategory type customBHK   id landmark fullAddress pincode  \n",
              "0              NaN  NaN       NaN  NaN      NaN         NaN     NaN  \n",
              "1              NaN  NaN       NaN  NaN      NaN         NaN     NaN  \n",
              "2              NaN  NaN       NaN  NaN      NaN         NaN     NaN  \n",
              "3              NaN  NaN       NaN  NaN      NaN         NaN     NaN  \n",
              "4              NaN  NaN       NaN  NaN      NaN         NaN     NaN  \n",
              "\n",
              "[5 rows x 29 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-e685d22f-b866-451c-9d47-9e566458929c\" 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>id_x</th>\n",
              "      <th>configurationId</th>\n",
              "      <th>bathrooms</th>\n",
              "      <th>privateBathrooms</th>\n",
              "      <th>publicBathrooms</th>\n",
              "      <th>balcony</th>\n",
              "      <th>furnishedType</th>\n",
              "      <th>furnishingType</th>\n",
              "      <th>lift</th>\n",
              "      <th>ageOfProperty</th>\n",
              "      <th>...</th>\n",
              "      <th>updatedAt</th>\n",
              "      <th>id_y</th>\n",
              "      <th>projectId</th>\n",
              "      <th>propertyCategory</th>\n",
              "      <th>type</th>\n",
              "      <th>customBHK</th>\n",
              "      <th>id</th>\n",
              "      <th>landmark</th>\n",
              "      <th>fullAddress</th>\n",
              "      <th>pincode</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>cmf5r6hv20005vxpt3yfnl2qp</td>\n",
              "      <td>\"cmf5r6hv20004vxpt0l657blu\"</td>\n",
              "      <td>\"12\"</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>\"3\"</td>\n",
              "      <td>\"UNFURNISHED\"</td>\n",
              "      <td>\"[]\"                                         ...</td>\n",
              "      <td>\"false\"</td>\n",
              "      <td></td>\n",
              "      <td>...</td>\n",
              "      <td>\"2025-09-04 18:42:08.748\"</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>cmf5r6hv20006vxptcx3lmm05</td>\n",
              "      <td>\"cmf5r6hv20004vxpt0l657blu\"</td>\n",
              "      <td>\"3\"</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>\"2\"</td>\n",
              "      <td>\"UNFURNISHED\"</td>\n",
              "      <td>\"[]\"                                         ...</td>\n",
              "      <td>\"false\"</td>\n",
              "      <td></td>\n",
              "      <td>...</td>\n",
              "      <td>\"2025-09-04 18:42:08.748\"</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>cmfawdrnq000bvc188680qjyx</td>\n",
              "      <td>\"cmfawdrnq000avc18qcvaxzi9\"</td>\n",
              "      <td>\"1\"</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>\"1\"</td>\n",
              "      <td>\"UNFURNISHED\"</td>\n",
              "      <td>\"[]\"                                         ...</td>\n",
              "      <td>\"false\"</td>\n",
              "      <td></td>\n",
              "      <td>...</td>\n",
              "      <td>\"2025-09-08 09:06:36.995\"</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>cmfawdrnr000cvc1897rpsu1b</td>\n",
              "      <td>\"cmfawdrnq000avc18qcvaxzi9\"</td>\n",
              "      <td>\"1\"</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>\"1\"</td>\n",
              "      <td>\"UNFURNISHED\"</td>\n",
              "      <td>\"[]\"                                         ...</td>\n",
              "      <td>\"false\"</td>\n",
              "      <td></td>\n",
              "      <td>...</td>\n",
              "      <td>\"2025-09-08 09:06:36.995\"</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>cmfawdrnr000evc18jwvlery4</td>\n",
              "      <td>\"cmfawdrnr000dvc188hupv4yy\"</td>\n",
              "      <td>\"3\"</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>\"2\"</td>\n",
              "      <td>\"UNFURNISHED\"</td>\n",
              "      <td>\"[]\"                                         ...</td>\n",
              "      <td>\"false\"</td>\n",
              "      <td></td>\n",
              "      <td>...</td>\n",
              "      <td>\"2025-09-08 09:06:36.995\"</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 29 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-e685d22f-b866-451c-9d47-9e566458929c')\"\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-e685d22f-b866-451c-9d47-9e566458929c 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-e685d22f-b866-451c-9d47-9e566458929c');\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-d59ceaf5-30bd-449d-aa59-a2c3b69cb34a\">\n",
              "      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-d59ceaf5-30bd-449d-aa59-a2c3b69cb34a')\"\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-d59ceaf5-30bd-449d-aa59-a2c3b69cb34a button');\n",
              "          quickchartButtonEl.style.display =\n",
              "            google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "        })();\n",
              "      </script>\n",
              "    </div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe"
            }
          },
          "metadata": {}
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "print(f\"The final_merged_df has {final_merged_df.shape[0]} rows and {final_merged_df.shape[1]} columns.\")"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "r9-uyxyMfqoz",
        "outputId": "67e7116b-02b4-43ad-9149-fbae9ce23efd"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "The final_merged_df has 78 rows and 29 columns.\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "final_merged_df.to_csv('final_merged_data200.csv', index=False)"
      ],
      "metadata": {
        "id": "l4SW0LqJgX9C"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "project_df = pd.read_csv('/content/project.csv', sep=',', on_bad_lines='skip')\n",
        "display(project_df_config_var.head())"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 313
        },
        "id": "o_GW3ua-cqC-",
        "outputId": "5f6e7769-8734-46e1-c758-2a58ff937310"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "                          id               configurationId     bathrooms  \\\n",
              "0  cmf5r6hv20005vxpt3yfnl2qp   \"cmf5r6hv20004vxpt0l657blu\"   \"12\"          \n",
              "1  cmf5r6hv20006vxptcx3lmm05   \"cmf5r6hv20004vxpt0l657blu\"   \"3\"           \n",
              "2  cmfawdrnq000bvc188680qjyx   \"cmfawdrnq000avc18qcvaxzi9\"   \"1\"           \n",
              "3  cmfawdrnr000cvc1897rpsu1b   \"cmfawdrnq000avc18qcvaxzi9\"   \"1\"           \n",
              "4  cmfawdrnr000evc18jwvlery4   \"cmfawdrnr000dvc188hupv4yy\"   \"3\"           \n",
              "\n",
              "      privateBathrooms     publicBathrooms     balcony      furnishedType  \\\n",
              "0                                            \"3\"         \"UNFURNISHED\"      \n",
              "1                                            \"2\"         \"UNFURNISHED\"      \n",
              "2                                            \"1\"         \"UNFURNISHED\"      \n",
              "3                                            \"1\"         \"UNFURNISHED\"      \n",
              "4                                            \"2\"         \"UNFURNISHED\"      \n",
              "\n",
              "                                      furnishingType      lift  \\\n",
              "0   \"[]\"                                         ...   \"false\"   \n",
              "1   \"[]\"                                         ...   \"false\"   \n",
              "2   \"[]\"                                         ...   \"false\"   \n",
              "3   \"[]\"                                         ...   \"false\"   \n",
              "4   \"[]\"                                         ...   \"false\"   \n",
              "\n",
              "      ageOfProperty     parkingType     listingType  \\\n",
              "0                                     \"Sell\"          \n",
              "1                                     \"Sell\"          \n",
              "2                                     \"Sell\"          \n",
              "3                                     \"Sell\"          \n",
              "4                                     \"Sell\"          \n",
              "\n",
              "                                      floorPlanImage     carpetArea  \\\n",
              "0   \"https://pub-d28896f69c604ec5aa743cb0397740d9...   \"972\"          \n",
              "1   \"https://pub-d28896f69c604ec5aa743cb0397740d9...   \"188.73\"       \n",
              "2   \"https://pub-d28896f69c604ec5aa743cb0397740d9...   \"426.57\"       \n",
              "3   \"https://pub-d28896f69c604ec5aa743cb0397740d9...   \"460.8\"        \n",
              "4   \"https://pub-d28896f69c604ec5aa743cb0397740d9...   \"893.08\"       \n",
              "\n",
              "          price                                     propertyImages  \\\n",
              "0   \"120000000\"   \"[\"\"https://pub-d28896f69c604ec5aa743cb039774...   \n",
              "1   \"210000000\"   \"[\"\"https://pub-d28896f69c604ec5aa743cb039774...   \n",
              "2   \"13000000\"    \"[\"\"https://pub-d28896f69c604ec5aa743cb039774...   \n",
              "3   \"15000000\"    \"[\"\"https://pub-d28896f69c604ec5aa743cb039774...   \n",
              "4   \"29000000\"    \"[\"\"https://pub-d28896f69c604ec5aa743cb039774...   \n",
              "\n",
              "      maintenanceCharges                 aboutProperty  \\\n",
              "0   \"faded \"               \"about property \"             \n",
              "1                          \"fsdaffdsafsfdddsa\"           \n",
              "2                          \"na\"                          \n",
              "3                          \"na\"                          \n",
              "4                          \"na\"                          \n",
              "\n",
              "                    createdAt                   updatedAt  \n",
              "0   \"2025-09-04 18:42:08.748\"   \"2025-09-04 18:42:08.748\"  \n",
              "1   \"2025-09-04 18:42:08.748\"   \"2025-09-04 18:42:08.748\"  \n",
              "2   \"2025-09-08 09:06:36.995\"   \"2025-09-08 09:06:36.995\"  \n",
              "3   \"2025-09-08 09:06:36.995\"   \"2025-09-08 09:06:36.995\"  \n",
              "4   \"2025-09-08 09:06:36.995\"   \"2025-09-08 09:06:36.995\"  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-61a79eda-6292-418e-babe-65d72a38c39a\" 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>id</th>\n",
              "      <th>configurationId</th>\n",
              "      <th>bathrooms</th>\n",
              "      <th>privateBathrooms</th>\n",
              "      <th>publicBathrooms</th>\n",
              "      <th>balcony</th>\n",
              "      <th>furnishedType</th>\n",
              "      <th>furnishingType</th>\n",
              "      <th>lift</th>\n",
              "      <th>ageOfProperty</th>\n",
              "      <th>parkingType</th>\n",
              "      <th>listingType</th>\n",
              "      <th>floorPlanImage</th>\n",
              "      <th>carpetArea</th>\n",
              "      <th>price</th>\n",
              "      <th>propertyImages</th>\n",
              "      <th>maintenanceCharges</th>\n",
              "      <th>aboutProperty</th>\n",
              "      <th>createdAt</th>\n",
              "      <th>updatedAt</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>cmf5r6hv20005vxpt3yfnl2qp</td>\n",
              "      <td>\"cmf5r6hv20004vxpt0l657blu\"</td>\n",
              "      <td>\"12\"</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>\"3\"</td>\n",
              "      <td>\"UNFURNISHED\"</td>\n",
              "      <td>\"[]\"                                         ...</td>\n",
              "      <td>\"false\"</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>\"Sell\"</td>\n",
              "      <td>\"https://pub-d28896f69c604ec5aa743cb0397740d9...</td>\n",
              "      <td>\"972\"</td>\n",
              "      <td>\"120000000\"</td>\n",
              "      <td>\"[\"\"https://pub-d28896f69c604ec5aa743cb039774...</td>\n",
              "      <td>\"faded \"</td>\n",
              "      <td>\"about property \"</td>\n",
              "      <td>\"2025-09-04 18:42:08.748\"</td>\n",
              "      <td>\"2025-09-04 18:42:08.748\"</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>cmf5r6hv20006vxptcx3lmm05</td>\n",
              "      <td>\"cmf5r6hv20004vxpt0l657blu\"</td>\n",
              "      <td>\"3\"</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>\"2\"</td>\n",
              "      <td>\"UNFURNISHED\"</td>\n",
              "      <td>\"[]\"                                         ...</td>\n",
              "      <td>\"false\"</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>\"Sell\"</td>\n",
              "      <td>\"https://pub-d28896f69c604ec5aa743cb0397740d9...</td>\n",
              "      <td>\"188.73\"</td>\n",
              "      <td>\"210000000\"</td>\n",
              "      <td>\"[\"\"https://pub-d28896f69c604ec5aa743cb039774...</td>\n",
              "      <td></td>\n",
              "      <td>\"fsdaffdsafsfdddsa\"</td>\n",
              "      <td>\"2025-09-04 18:42:08.748\"</td>\n",
              "      <td>\"2025-09-04 18:42:08.748\"</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>cmfawdrnq000bvc188680qjyx</td>\n",
              "      <td>\"cmfawdrnq000avc18qcvaxzi9\"</td>\n",
              "      <td>\"1\"</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>\"1\"</td>\n",
              "      <td>\"UNFURNISHED\"</td>\n",
              "      <td>\"[]\"                                         ...</td>\n",
              "      <td>\"false\"</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>\"Sell\"</td>\n",
              "      <td>\"https://pub-d28896f69c604ec5aa743cb0397740d9...</td>\n",
              "      <td>\"426.57\"</td>\n",
              "      <td>\"13000000\"</td>\n",
              "      <td>\"[\"\"https://pub-d28896f69c604ec5aa743cb039774...</td>\n",
              "      <td></td>\n",
              "      <td>\"na\"</td>\n",
              "      <td>\"2025-09-08 09:06:36.995\"</td>\n",
              "      <td>\"2025-09-08 09:06:36.995\"</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>cmfawdrnr000cvc1897rpsu1b</td>\n",
              "      <td>\"cmfawdrnq000avc18qcvaxzi9\"</td>\n",
              "      <td>\"1\"</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>\"1\"</td>\n",
              "      <td>\"UNFURNISHED\"</td>\n",
              "      <td>\"[]\"                                         ...</td>\n",
              "      <td>\"false\"</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>\"Sell\"</td>\n",
              "      <td>\"https://pub-d28896f69c604ec5aa743cb0397740d9...</td>\n",
              "      <td>\"460.8\"</td>\n",
              "      <td>\"15000000\"</td>\n",
              "      <td>\"[\"\"https://pub-d28896f69c604ec5aa743cb039774...</td>\n",
              "      <td></td>\n",
              "      <td>\"na\"</td>\n",
              "      <td>\"2025-09-08 09:06:36.995\"</td>\n",
              "      <td>\"2025-09-08 09:06:36.995\"</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>cmfawdrnr000evc18jwvlery4</td>\n",
              "      <td>\"cmfawdrnr000dvc188hupv4yy\"</td>\n",
              "      <td>\"3\"</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>\"2\"</td>\n",
              "      <td>\"UNFURNISHED\"</td>\n",
              "      <td>\"[]\"                                         ...</td>\n",
              "      <td>\"false\"</td>\n",
              "      <td></td>\n",
              "      <td></td>\n",
              "      <td>\"Sell\"</td>\n",
              "      <td>\"https://pub-d28896f69c604ec5aa743cb0397740d9...</td>\n",
              "      <td>\"893.08\"</td>\n",
              "      <td>\"29000000\"</td>\n",
              "      <td>\"[\"\"https://pub-d28896f69c604ec5aa743cb039774...</td>\n",
              "      <td></td>\n",
              "      <td>\"na\"</td>\n",
              "      <td>\"2025-09-08 09:06:36.995\"</td>\n",
              "      <td>\"2025-09-08 09:06:36.995\"</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-61a79eda-6292-418e-babe-65d72a38c39a')\"\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-61a79eda-6292-418e-babe-65d72a38c39a 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-61a79eda-6292-418e-babe-65d72a38c39a');\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-ff523b95-3852-4d42-bd92-9bcc3df6594c\">\n",
              "      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-ff523b95-3852-4d42-bd92-9bcc3df6594c')\"\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-ff523b95-3852-4d42-bd92-9bcc3df6594c button');\n",
              "          quickchartButtonEl.style.display =\n",
              "            google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "        })();\n",
              "      </script>\n",
              "    </div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "summary": "{\n  \"name\": \"display(project_df_config_var\",\n  \"rows\": 5,\n  \"fields\": [\n    {\n      \"column\": \"id\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 5,\n        \"samples\": [\n          \"cmf5r6hv20006vxptcx3lmm05\",\n          \"cmfawdrnr000evc18jwvlery4\",\n          \"cmfawdrnq000bvc188680qjyx\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"configurationId\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 3,\n        \"samples\": [\n          \" \\\"cmf5r6hv20004vxpt0l657blu\\\"\",\n          \" \\\"cmfawdrnq000avc18qcvaxzi9\\\"\",\n          \" \\\"cmfawdrnr000dvc188hupv4yy\\\"\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"bathrooms\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 3,\n        \"samples\": [\n          \" \\\"12\\\"       \",\n          \" \\\"3\\\"        \",\n          \" \\\"1\\\"        \"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"privateBathrooms\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 1,\n        \"samples\": [\n          \"                   \"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"publicBathrooms\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 1,\n        \"samples\": [\n          \"                  \"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"balcony\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 3,\n        \"samples\": [\n          \" \\\"3\\\"      \"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"furnishedType\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 1,\n        \"samples\": [\n          \" \\\"UNFURNISHED\\\"   \"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"furnishingType\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 1,\n        \"samples\": [\n          \" \\\"[]\\\"                                                                       \"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"lift\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 1,\n        \"samples\": [\n          \" \\\"false\\\"\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"ageOfProperty\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 1,\n        \"samples\": [\n          \"                \"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"parkingType\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 1,\n        \"samples\": [\n          \"              \"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"listingType\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 1,\n        \"samples\": [\n          \" \\\"Sell\\\"       \"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"floorPlanImage\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 5,\n        \"samples\": [\n          \" \\\"https://pub-d28896f69c604ec5aa743cb0397740d9.r2.dev/1757011238542-2d39a8b06669406b.jpg\\\" \"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"carpetArea\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 5,\n        \"samples\": [\n          \" \\\"188.73\\\"    \"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"price\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 5,\n        \"samples\": [\n          \" \\\"210000000\\\"\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"propertyImages\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 5,\n        \"samples\": [\n          \" \\\"[\\\"\\\"https://pub-d28896f69c604ec5aa743cb0397740d9.r2.dev/1757011238542-bd3d1a40c2d7fadb.jpg\\\"\\\"]\\\"                                                                                           \"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"maintenanceCharges\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 2,\n        \"samples\": [\n          \"                     \"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"aboutProperty\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 3,\n        \"samples\": [\n          \" \\\"about property \\\"          \"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"createdAt\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 2,\n        \"samples\": [\n          \" \\\"2025-09-08 09:06:36.995\\\"\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"updatedAt\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 2,\n        \"samples\": [\n          \" \\\"2025-09-08 09:06:36.995\\\"\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"
            }
          },
          "metadata": {}
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [],
      "metadata": {
        "id": "giZvUiPMdIQB"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [],
      "metadata": {
        "id": "9U3IJrNeijE9"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [],
      "metadata": {
        "id": "WjLvmDQ8ijBd"
      },
      "execution_count": null,
      "outputs": []
    }
  ]
}