House_price_model.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "89097904",
   "metadata": {},
   "source": [
    "# House price prediction using Linear Regression"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "635fc7b6",
   "metadata": {},
   "source": [
    "Basic feature engineering steps has been done by using Excel."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "c5494a99",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "from sklearn.preprocessing import StandardScaler\n",
    "from sklearn.linear_model import LinearRegression\n",
    "from sklearn.model_selection import train_test_split\n",
    "from sklearn.metrics import mean_squared_error"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "c608c38c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>title</th>\n",
       "      <th>beds</th>\n",
       "      <th>bath</th>\n",
       "      <th>area_sqft</th>\n",
       "      <th>address</th>\n",
       "      <th>type</th>\n",
       "      <th>purpose</th>\n",
       "      <th>flooPlan</th>\n",
       "      <th>url</th>\n",
       "      <th>lastUpdated</th>\n",
       "      <th>price</th>\n",
       "      <th>beds x bath</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Eminent Apartment Of 2200 Sq Ft Is Vacant For ...</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>2200.0</td>\n",
       "      <td>Block A, Bashundhara R-A, Dhaka</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>For Rent</td>\n",
       "      <td>https://images-cdn.bproperty.com/thumbnails/10...</td>\n",
       "      <td>https://www.bproperty.com/en/property/details-...</td>\n",
       "      <td>13-Aug-22</td>\n",
       "      <td>50 Thousand</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Apartment Ready To Rent In South Khulshi, Near...</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>1400.0</td>\n",
       "      <td>South Khulshi, Khulshi, Chattogram</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>For Rent</td>\n",
       "      <td>https://images-cdn.bproperty.com/thumbnails/44...</td>\n",
       "      <td>https://www.bproperty.com/en/property/details-...</td>\n",
       "      <td>25-Jan-22</td>\n",
       "      <td>30 Thousand</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Smartly priced 1950 SQ FT apartment, that you ...</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>1950.0</td>\n",
       "      <td>Block F, Bashundhara R-A, Dhaka</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>For Rent</td>\n",
       "      <td>https://images-cdn.bproperty.com/thumbnails/11...</td>\n",
       "      <td>https://www.bproperty.com/en/property/details-...</td>\n",
       "      <td>22-Feb-23</td>\n",
       "      <td>30 Thousand</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2000 Sq Ft Residential Apartment Is Up For Ren...</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>Sector 9, Uttara, Dhaka</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>For Rent</td>\n",
       "      <td>https://images-cdn.bproperty.com/thumbnails/14...</td>\n",
       "      <td>https://www.bproperty.com/en/property/details-...</td>\n",
       "      <td>28-Oct-21</td>\n",
       "      <td>35 Thousand</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Strongly Structured This 1650 Sq. ft Apartment...</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>1650.0</td>\n",
       "      <td>Block I, Bashundhara R-A, Dhaka</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>For Rent</td>\n",
       "      <td>https://images-cdn.bproperty.com/thumbnails/10...</td>\n",
       "      <td>https://www.bproperty.com/en/property/details-...</td>\n",
       "      <td>19-Feb-23</td>\n",
       "      <td>25 Thousand</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7552</th>\n",
       "      <td>Picture Yourself, Residing In This Well Constr...</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>3600.0</td>\n",
       "      <td>Sector 3, Uttara, Dhaka</td>\n",
       "      <td>Duplex</td>\n",
       "      <td>For Rent</td>\n",
       "      <td>https://images-cdn.bproperty.com/thumbnails/15...</td>\n",
       "      <td>https://www.bproperty.com/en/property/details-...</td>\n",
       "      <td>7-Feb-23</td>\n",
       "      <td>80 Thousand</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7553</th>\n",
       "      <td>Flat For Rent In Uttara Sector 13 Near Lubana ...</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>900.0</td>\n",
       "      <td>Sector 13, Uttara, Dhaka</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>For Rent</td>\n",
       "      <td>https://images-cdn.bproperty.com/thumbnails/15...</td>\n",
       "      <td>https://www.bproperty.com/en/property/details-...</td>\n",
       "      <td>9-Feb-22</td>\n",
       "      <td>19 Thousand</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7554</th>\n",
       "      <td>1000 SQ FT flat for rent in Uttara Sector 13 n...</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>Sector 13, Uttara, Dhaka</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>For Rent</td>\n",
       "      <td>https://images-cdn.bproperty.com/thumbnails/12...</td>\n",
       "      <td>https://www.bproperty.com/en/property/details-...</td>\n",
       "      <td>14-Feb-22</td>\n",
       "      <td>22 Thousand</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7555</th>\n",
       "      <td>Well Planned Apartment For Rent In Gulshan 1 N...</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>3600.0</td>\n",
       "      <td>Gulshan 1, Gulshan, Dhaka</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>For Rent</td>\n",
       "      <td>https://images-cdn.bproperty.com/thumbnails/30...</td>\n",
       "      <td>https://www.bproperty.com/en/property/details-...</td>\n",
       "      <td>7-Feb-23</td>\n",
       "      <td>1.75 Lakh</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7556</th>\n",
       "      <td>An Apartment Is Ready For Rent At Baridhara DO...</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>2600.0</td>\n",
       "      <td>Baridhara DOHS, Dhaka</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>For Rent</td>\n",
       "      <td>https://images-cdn.bproperty.com/thumbnails/15...</td>\n",
       "      <td>https://www.bproperty.com/en/property/details-...</td>\n",
       "      <td>22-Nov-21</td>\n",
       "      <td>90 Thousand</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7557 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                  title  beds  bath  \\\n",
       "0     Eminent Apartment Of 2200 Sq Ft Is Vacant For ...     3     4   \n",
       "1     Apartment Ready To Rent In South Khulshi, Near...     3     4   \n",
       "2     Smartly priced 1950 SQ FT apartment, that you ...     3     4   \n",
       "3     2000 Sq Ft Residential Apartment Is Up For Ren...     3     3   \n",
       "4     Strongly Structured This 1650 Sq. ft Apartment...     3     4   \n",
       "...                                                 ...   ...   ...   \n",
       "7552  Picture Yourself, Residing In This Well Constr...     4     4   \n",
       "7553  Flat For Rent In Uttara Sector 13 Near Lubana ...     3     2   \n",
       "7554  1000 SQ FT flat for rent in Uttara Sector 13 n...     2     2   \n",
       "7555  Well Planned Apartment For Rent In Gulshan 1 N...     3     4   \n",
       "7556  An Apartment Is Ready For Rent At Baridhara DO...     4     4   \n",
       "\n",
       "      area_sqft                             address       type   purpose  \\\n",
       "0        2200.0     Block A, Bashundhara R-A, Dhaka  Apartment  For Rent   \n",
       "1        1400.0  South Khulshi, Khulshi, Chattogram  Apartment  For Rent   \n",
       "2        1950.0     Block F, Bashundhara R-A, Dhaka  Apartment  For Rent   \n",
       "3        2000.0             Sector 9, Uttara, Dhaka  Apartment  For Rent   \n",
       "4        1650.0     Block I, Bashundhara R-A, Dhaka  Apartment  For Rent   \n",
       "...         ...                                 ...        ...       ...   \n",
       "7552     3600.0             Sector 3, Uttara, Dhaka     Duplex  For Rent   \n",
       "7553      900.0            Sector 13, Uttara, Dhaka  Apartment  For Rent   \n",
       "7554     1000.0            Sector 13, Uttara, Dhaka  Apartment  For Rent   \n",
       "7555     3600.0           Gulshan 1, Gulshan, Dhaka  Apartment  For Rent   \n",
       "7556     2600.0               Baridhara DOHS, Dhaka  Apartment  For Rent   \n",
       "\n",
       "                                               flooPlan  \\\n",
       "0     https://images-cdn.bproperty.com/thumbnails/10...   \n",
       "1     https://images-cdn.bproperty.com/thumbnails/44...   \n",
       "2     https://images-cdn.bproperty.com/thumbnails/11...   \n",
       "3     https://images-cdn.bproperty.com/thumbnails/14...   \n",
       "4     https://images-cdn.bproperty.com/thumbnails/10...   \n",
       "...                                                 ...   \n",
       "7552  https://images-cdn.bproperty.com/thumbnails/15...   \n",
       "7553  https://images-cdn.bproperty.com/thumbnails/15...   \n",
       "7554  https://images-cdn.bproperty.com/thumbnails/12...   \n",
       "7555  https://images-cdn.bproperty.com/thumbnails/30...   \n",
       "7556  https://images-cdn.bproperty.com/thumbnails/15...   \n",
       "\n",
       "                                                    url lastUpdated  \\\n",
       "0     https://www.bproperty.com/en/property/details-...   13-Aug-22   \n",
       "1     https://www.bproperty.com/en/property/details-...   25-Jan-22   \n",
       "2     https://www.bproperty.com/en/property/details-...   22-Feb-23   \n",
       "3     https://www.bproperty.com/en/property/details-...   28-Oct-21   \n",
       "4     https://www.bproperty.com/en/property/details-...   19-Feb-23   \n",
       "...                                                 ...         ...   \n",
       "7552  https://www.bproperty.com/en/property/details-...    7-Feb-23   \n",
       "7553  https://www.bproperty.com/en/property/details-...    9-Feb-22   \n",
       "7554  https://www.bproperty.com/en/property/details-...   14-Feb-22   \n",
       "7555  https://www.bproperty.com/en/property/details-...    7-Feb-23   \n",
       "7556  https://www.bproperty.com/en/property/details-...   22-Nov-21   \n",
       "\n",
       "            price  beds x bath  \n",
       "0     50 Thousand           12  \n",
       "1     30 Thousand           12  \n",
       "2     30 Thousand           12  \n",
       "3     35 Thousand            9  \n",
       "4     25 Thousand           12  \n",
       "...           ...          ...  \n",
       "7552  80 Thousand           16  \n",
       "7553  19 Thousand            6  \n",
       "7554  22 Thousand            4  \n",
       "7555    1.75 Lakh           12  \n",
       "7556  90 Thousand           16  \n",
       "\n",
       "[7557 rows x 12 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('property_listing_data_in_Bangladesh.csv')\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "5a1dc2d7",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>beds x bath</th>\n",
       "      <th>area_sqft</th>\n",
       "      <th>address</th>\n",
       "      <th>type</th>\n",
       "      <th>price</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>12</td>\n",
       "      <td>2200.0</td>\n",
       "      <td>Block A, Bashundhara R-A, Dhaka</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>50 Thousand</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>12</td>\n",
       "      <td>1400.0</td>\n",
       "      <td>South Khulshi, Khulshi, Chattogram</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>30 Thousand</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>12</td>\n",
       "      <td>1950.0</td>\n",
       "      <td>Block F, Bashundhara R-A, Dhaka</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>30 Thousand</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>9</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>Sector 9, Uttara, Dhaka</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>35 Thousand</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>12</td>\n",
       "      <td>1650.0</td>\n",
       "      <td>Block I, Bashundhara R-A, Dhaka</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>25 Thousand</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7552</th>\n",
       "      <td>16</td>\n",
       "      <td>3600.0</td>\n",
       "      <td>Sector 3, Uttara, Dhaka</td>\n",
       "      <td>Duplex</td>\n",
       "      <td>80 Thousand</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7553</th>\n",
       "      <td>6</td>\n",
       "      <td>900.0</td>\n",
       "      <td>Sector 13, Uttara, Dhaka</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>19 Thousand</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7554</th>\n",
       "      <td>4</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>Sector 13, Uttara, Dhaka</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>22 Thousand</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7555</th>\n",
       "      <td>12</td>\n",
       "      <td>3600.0</td>\n",
       "      <td>Gulshan 1, Gulshan, Dhaka</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>1.75 Lakh</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7556</th>\n",
       "      <td>16</td>\n",
       "      <td>2600.0</td>\n",
       "      <td>Baridhara DOHS, Dhaka</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>90 Thousand</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7557 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      beds x bath  area_sqft                             address       type  \\\n",
       "0              12     2200.0     Block A, Bashundhara R-A, Dhaka  Apartment   \n",
       "1              12     1400.0  South Khulshi, Khulshi, Chattogram  Apartment   \n",
       "2              12     1950.0     Block F, Bashundhara R-A, Dhaka  Apartment   \n",
       "3               9     2000.0             Sector 9, Uttara, Dhaka  Apartment   \n",
       "4              12     1650.0     Block I, Bashundhara R-A, Dhaka  Apartment   \n",
       "...           ...        ...                                 ...        ...   \n",
       "7552           16     3600.0             Sector 3, Uttara, Dhaka     Duplex   \n",
       "7553            6      900.0            Sector 13, Uttara, Dhaka  Apartment   \n",
       "7554            4     1000.0            Sector 13, Uttara, Dhaka  Apartment   \n",
       "7555           12     3600.0           Gulshan 1, Gulshan, Dhaka  Apartment   \n",
       "7556           16     2600.0               Baridhara DOHS, Dhaka  Apartment   \n",
       "\n",
       "            price  \n",
       "0     50 Thousand  \n",
       "1     30 Thousand  \n",
       "2     30 Thousand  \n",
       "3     35 Thousand  \n",
       "4     25 Thousand  \n",
       "...           ...  \n",
       "7552  80 Thousand  \n",
       "7553  19 Thousand  \n",
       "7554  22 Thousand  \n",
       "7555    1.75 Lakh  \n",
       "7556  90 Thousand  \n",
       "\n",
       "[7557 rows x 5 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Specify the columns to keep\n",
    "columns_to_keep = ['beds x bath','area_sqft','address', 'type', 'price']\n",
    "df = df[columns_to_keep]\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "5d856f01",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\ahs95\\AppData\\Local\\Temp\\ipykernel_12508\\3541976426.py:11: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  df['price'] = df['price'].apply(convert_price_to_number)\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>beds x bath</th>\n",
       "      <th>area_sqft</th>\n",
       "      <th>address</th>\n",
       "      <th>type</th>\n",
       "      <th>price</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>12</td>\n",
       "      <td>2200.0</td>\n",
       "      <td>Block A, Bashundhara R-A, Dhaka</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>50000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>12</td>\n",
       "      <td>1400.0</td>\n",
       "      <td>South Khulshi, Khulshi, Chattogram</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>30000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>12</td>\n",
       "      <td>1950.0</td>\n",
       "      <td>Block F, Bashundhara R-A, Dhaka</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>30000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>9</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>Sector 9, Uttara, Dhaka</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>35000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>12</td>\n",
       "      <td>1650.0</td>\n",
       "      <td>Block I, Bashundhara R-A, Dhaka</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>25000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7552</th>\n",
       "      <td>16</td>\n",
       "      <td>3600.0</td>\n",
       "      <td>Sector 3, Uttara, Dhaka</td>\n",
       "      <td>Duplex</td>\n",
       "      <td>80000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7553</th>\n",
       "      <td>6</td>\n",
       "      <td>900.0</td>\n",
       "      <td>Sector 13, Uttara, Dhaka</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>19000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7554</th>\n",
       "      <td>4</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>Sector 13, Uttara, Dhaka</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>22000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7555</th>\n",
       "      <td>12</td>\n",
       "      <td>3600.0</td>\n",
       "      <td>Gulshan 1, Gulshan, Dhaka</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>175000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7556</th>\n",
       "      <td>16</td>\n",
       "      <td>2600.0</td>\n",
       "      <td>Baridhara DOHS, Dhaka</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>90000.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7557 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      beds x bath  area_sqft                             address       type  \\\n",
       "0              12     2200.0     Block A, Bashundhara R-A, Dhaka  Apartment   \n",
       "1              12     1400.0  South Khulshi, Khulshi, Chattogram  Apartment   \n",
       "2              12     1950.0     Block F, Bashundhara R-A, Dhaka  Apartment   \n",
       "3               9     2000.0             Sector 9, Uttara, Dhaka  Apartment   \n",
       "4              12     1650.0     Block I, Bashundhara R-A, Dhaka  Apartment   \n",
       "...           ...        ...                                 ...        ...   \n",
       "7552           16     3600.0             Sector 3, Uttara, Dhaka     Duplex   \n",
       "7553            6      900.0            Sector 13, Uttara, Dhaka  Apartment   \n",
       "7554            4     1000.0            Sector 13, Uttara, Dhaka  Apartment   \n",
       "7555           12     3600.0           Gulshan 1, Gulshan, Dhaka  Apartment   \n",
       "7556           16     2600.0               Baridhara DOHS, Dhaka  Apartment   \n",
       "\n",
       "         price  \n",
       "0      50000.0  \n",
       "1      30000.0  \n",
       "2      30000.0  \n",
       "3      35000.0  \n",
       "4      25000.0  \n",
       "...        ...  \n",
       "7552   80000.0  \n",
       "7553   19000.0  \n",
       "7554   22000.0  \n",
       "7555  175000.0  \n",
       "7556   90000.0  \n",
       "\n",
       "[7557 rows x 5 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Define a function to convert the string value to a numerical value\n",
    "def convert_price_to_number(price):\n",
    "    if 'Thousand' in price:\n",
    "        return float(price.replace('Thousand', '')) * 1000\n",
    "    elif 'Lakh' in price:\n",
    "        return float(price.replace('Lakh', '')) * 100000\n",
    "    else:\n",
    "        return float(price)\n",
    "\n",
    "# Apply the function to the 'Price' column to convert it to numerical values\n",
    "df['price'] = df['price'].apply(convert_price_to_number)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "2c8d788c",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\ahs95\\AppData\\Local\\Temp\\ipykernel_12508\\797509333.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  df['area_sqft'] = scaler.fit_transform(df[['area_sqft']])\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>beds x bath</th>\n",
       "      <th>area_sqft</th>\n",
       "      <th>address</th>\n",
       "      <th>type</th>\n",
       "      <th>price</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>12</td>\n",
       "      <td>0.865455</td>\n",
       "      <td>Block A, Bashundhara R-A, Dhaka</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>50000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>12</td>\n",
       "      <td>0.029241</td>\n",
       "      <td>South Khulshi, Khulshi, Chattogram</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>30000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>12</td>\n",
       "      <td>0.604138</td>\n",
       "      <td>Block F, Bashundhara R-A, Dhaka</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>30000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>9</td>\n",
       "      <td>0.656402</td>\n",
       "      <td>Sector 9, Uttara, Dhaka</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>35000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>12</td>\n",
       "      <td>0.290558</td>\n",
       "      <td>Block I, Bashundhara R-A, Dhaka</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>25000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7552</th>\n",
       "      <td>16</td>\n",
       "      <td>2.328830</td>\n",
       "      <td>Sector 3, Uttara, Dhaka</td>\n",
       "      <td>Duplex</td>\n",
       "      <td>80000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7553</th>\n",
       "      <td>6</td>\n",
       "      <td>-0.493392</td>\n",
       "      <td>Sector 13, Uttara, Dhaka</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>19000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7554</th>\n",
       "      <td>4</td>\n",
       "      <td>-0.388866</td>\n",
       "      <td>Sector 13, Uttara, Dhaka</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>22000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7555</th>\n",
       "      <td>12</td>\n",
       "      <td>2.328830</td>\n",
       "      <td>Gulshan 1, Gulshan, Dhaka</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>175000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7556</th>\n",
       "      <td>16</td>\n",
       "      <td>1.283562</td>\n",
       "      <td>Baridhara DOHS, Dhaka</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>90000.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7557 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      beds x bath  area_sqft                             address       type  \\\n",
       "0              12   0.865455     Block A, Bashundhara R-A, Dhaka  Apartment   \n",
       "1              12   0.029241  South Khulshi, Khulshi, Chattogram  Apartment   \n",
       "2              12   0.604138     Block F, Bashundhara R-A, Dhaka  Apartment   \n",
       "3               9   0.656402             Sector 9, Uttara, Dhaka  Apartment   \n",
       "4              12   0.290558     Block I, Bashundhara R-A, Dhaka  Apartment   \n",
       "...           ...        ...                                 ...        ...   \n",
       "7552           16   2.328830             Sector 3, Uttara, Dhaka     Duplex   \n",
       "7553            6  -0.493392            Sector 13, Uttara, Dhaka  Apartment   \n",
       "7554            4  -0.388866            Sector 13, Uttara, Dhaka  Apartment   \n",
       "7555           12   2.328830           Gulshan 1, Gulshan, Dhaka  Apartment   \n",
       "7556           16   1.283562               Baridhara DOHS, Dhaka  Apartment   \n",
       "\n",
       "         price  \n",
       "0      50000.0  \n",
       "1      30000.0  \n",
       "2      30000.0  \n",
       "3      35000.0  \n",
       "4      25000.0  \n",
       "...        ...  \n",
       "7552   80000.0  \n",
       "7553   19000.0  \n",
       "7554   22000.0  \n",
       "7555  175000.0  \n",
       "7556   90000.0  \n",
       "\n",
       "[7557 rows x 5 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#feature_scaling\n",
    "scaler = StandardScaler()\n",
    "df['area_sqft'] = scaler.fit_transform(df[['area_sqft']])\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "98eab7e1",
   "metadata": {},
   "outputs": [],
   "source": [
    "encoded_col = ['address', 'type']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "2e842a2e",
   "metadata": {},
   "outputs": [],
   "source": [
    "#performing_one_hot_encoding\n",
    "df = pd.get_dummies(data = df,\n",
    "                         prefix = encoded_col,\n",
    "                         columns = encoded_col) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "334a56eb",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>beds x bath</th>\n",
       "      <th>area_sqft</th>\n",
       "      <th>price</th>\n",
       "      <th>address_1 No. South Pahartali Ward, Hathazari, Chattogram</th>\n",
       "      <th>address_10 No. North Kattali Ward, Chattogram</th>\n",
       "      <th>address_11 No. South Kattali Ward, Chattogram</th>\n",
       "      <th>address_12 No. Sarai Para Ward, Double Mooring, Chattogram</th>\n",
       "      <th>address_14 No. Lalkhan Bazaar Ward, Lal Khan Bazaar, Chattogram</th>\n",
       "      <th>address_15 No. Bagmoniram Ward, Chattogram</th>\n",
       "      <th>address_16 No. Chawk Bazaar Ward, Chattogram</th>\n",
       "      <th>...</th>\n",
       "      <th>address_West Rampura, Rampura, Dhaka</th>\n",
       "      <th>address_West Shahid Nagar, Oxygen, Bayazid, Chattogram</th>\n",
       "      <th>address_West Shewrapara, Mirpur, Dhaka</th>\n",
       "      <th>address_Zafrabad, Dhaka</th>\n",
       "      <th>address_Zafrabad, Hazaribag, Dhaka</th>\n",
       "      <th>address_Zakir Hossain Housing Society, South Khulshi, Khulshi, Chattogram</th>\n",
       "      <th>address_aziz Moholla, Mohammadpur, Dhaka</th>\n",
       "      <th>type_Apartment</th>\n",
       "      <th>type_Building</th>\n",
       "      <th>type_Duplex</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>12</td>\n",
       "      <td>0.865455</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>12</td>\n",
       "      <td>0.029241</td>\n",
       "      <td>30000.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>12</td>\n",
       "      <td>0.604138</td>\n",
       "      <td>30000.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>9</td>\n",
       "      <td>0.656402</td>\n",
       "      <td>35000.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>12</td>\n",
       "      <td>0.290558</td>\n",
       "      <td>25000.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7552</th>\n",
       "      <td>16</td>\n",
       "      <td>2.328830</td>\n",
       "      <td>80000.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7553</th>\n",
       "      <td>6</td>\n",
       "      <td>-0.493392</td>\n",
       "      <td>19000.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7554</th>\n",
       "      <td>4</td>\n",
       "      <td>-0.388866</td>\n",
       "      <td>22000.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7555</th>\n",
       "      <td>12</td>\n",
       "      <td>2.328830</td>\n",
       "      <td>175000.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7556</th>\n",
       "      <td>16</td>\n",
       "      <td>1.283562</td>\n",
       "      <td>90000.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7557 rows × 683 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      beds x bath  area_sqft     price  \\\n",
       "0              12   0.865455   50000.0   \n",
       "1              12   0.029241   30000.0   \n",
       "2              12   0.604138   30000.0   \n",
       "3               9   0.656402   35000.0   \n",
       "4              12   0.290558   25000.0   \n",
       "...           ...        ...       ...   \n",
       "7552           16   2.328830   80000.0   \n",
       "7553            6  -0.493392   19000.0   \n",
       "7554            4  -0.388866   22000.0   \n",
       "7555           12   2.328830  175000.0   \n",
       "7556           16   1.283562   90000.0   \n",
       "\n",
       "      address_1 No. South Pahartali Ward, Hathazari, Chattogram  \\\n",
       "0                                                     0           \n",
       "1                                                     0           \n",
       "2                                                     0           \n",
       "3                                                     0           \n",
       "4                                                     0           \n",
       "...                                                 ...           \n",
       "7552                                                  0           \n",
       "7553                                                  0           \n",
       "7554                                                  0           \n",
       "7555                                                  0           \n",
       "7556                                                  0           \n",
       "\n",
       "      address_10 No. North Kattali Ward, Chattogram  \\\n",
       "0                                                 0   \n",
       "1                                                 0   \n",
       "2                                                 0   \n",
       "3                                                 0   \n",
       "4                                                 0   \n",
       "...                                             ...   \n",
       "7552                                              0   \n",
       "7553                                              0   \n",
       "7554                                              0   \n",
       "7555                                              0   \n",
       "7556                                              0   \n",
       "\n",
       "      address_11 No. South Kattali Ward, Chattogram  \\\n",
       "0                                                 0   \n",
       "1                                                 0   \n",
       "2                                                 0   \n",
       "3                                                 0   \n",
       "4                                                 0   \n",
       "...                                             ...   \n",
       "7552                                              0   \n",
       "7553                                              0   \n",
       "7554                                              0   \n",
       "7555                                              0   \n",
       "7556                                              0   \n",
       "\n",
       "      address_12 No. Sarai Para Ward, Double Mooring, Chattogram  \\\n",
       "0                                                     0            \n",
       "1                                                     0            \n",
       "2                                                     0            \n",
       "3                                                     0            \n",
       "4                                                     0            \n",
       "...                                                 ...            \n",
       "7552                                                  0            \n",
       "7553                                                  0            \n",
       "7554                                                  0            \n",
       "7555                                                  0            \n",
       "7556                                                  0            \n",
       "\n",
       "      address_14 No. Lalkhan Bazaar Ward, Lal Khan Bazaar, Chattogram  \\\n",
       "0                                                     0                 \n",
       "1                                                     0                 \n",
       "2                                                     0                 \n",
       "3                                                     0                 \n",
       "4                                                     0                 \n",
       "...                                                 ...                 \n",
       "7552                                                  0                 \n",
       "7553                                                  0                 \n",
       "7554                                                  0                 \n",
       "7555                                                  0                 \n",
       "7556                                                  0                 \n",
       "\n",
       "      address_15 No. Bagmoniram Ward, Chattogram  \\\n",
       "0                                              0   \n",
       "1                                              0   \n",
       "2                                              0   \n",
       "3                                              0   \n",
       "4                                              0   \n",
       "...                                          ...   \n",
       "7552                                           0   \n",
       "7553                                           0   \n",
       "7554                                           0   \n",
       "7555                                           0   \n",
       "7556                                           0   \n",
       "\n",
       "      address_16 No. Chawk Bazaar Ward, Chattogram  ...  \\\n",
       "0                                                0  ...   \n",
       "1                                                0  ...   \n",
       "2                                                0  ...   \n",
       "3                                                0  ...   \n",
       "4                                                0  ...   \n",
       "...                                            ...  ...   \n",
       "7552                                             0  ...   \n",
       "7553                                             0  ...   \n",
       "7554                                             0  ...   \n",
       "7555                                             0  ...   \n",
       "7556                                             0  ...   \n",
       "\n",
       "      address_West Rampura, Rampura, Dhaka  \\\n",
       "0                                        0   \n",
       "1                                        0   \n",
       "2                                        0   \n",
       "3                                        0   \n",
       "4                                        0   \n",
       "...                                    ...   \n",
       "7552                                     0   \n",
       "7553                                     0   \n",
       "7554                                     0   \n",
       "7555                                     0   \n",
       "7556                                     0   \n",
       "\n",
       "      address_West Shahid Nagar, Oxygen, Bayazid, Chattogram  \\\n",
       "0                                                     0        \n",
       "1                                                     0        \n",
       "2                                                     0        \n",
       "3                                                     0        \n",
       "4                                                     0        \n",
       "...                                                 ...        \n",
       "7552                                                  0        \n",
       "7553                                                  0        \n",
       "7554                                                  0        \n",
       "7555                                                  0        \n",
       "7556                                                  0        \n",
       "\n",
       "      address_West Shewrapara, Mirpur, Dhaka  address_Zafrabad, Dhaka  \\\n",
       "0                                          0                        0   \n",
       "1                                          0                        0   \n",
       "2                                          0                        0   \n",
       "3                                          0                        0   \n",
       "4                                          0                        0   \n",
       "...                                      ...                      ...   \n",
       "7552                                       0                        0   \n",
       "7553                                       0                        0   \n",
       "7554                                       0                        0   \n",
       "7555                                       0                        0   \n",
       "7556                                       0                        0   \n",
       "\n",
       "      address_Zafrabad, Hazaribag, Dhaka  \\\n",
       "0                                      0   \n",
       "1                                      0   \n",
       "2                                      0   \n",
       "3                                      0   \n",
       "4                                      0   \n",
       "...                                  ...   \n",
       "7552                                   0   \n",
       "7553                                   0   \n",
       "7554                                   0   \n",
       "7555                                   0   \n",
       "7556                                   0   \n",
       "\n",
       "      address_Zakir Hossain Housing Society, South Khulshi, Khulshi, Chattogram  \\\n",
       "0                                                     0                           \n",
       "1                                                     0                           \n",
       "2                                                     0                           \n",
       "3                                                     0                           \n",
       "4                                                     0                           \n",
       "...                                                 ...                           \n",
       "7552                                                  0                           \n",
       "7553                                                  0                           \n",
       "7554                                                  0                           \n",
       "7555                                                  0                           \n",
       "7556                                                  0                           \n",
       "\n",
       "      address_aziz Moholla, Mohammadpur, Dhaka  type_Apartment  type_Building  \\\n",
       "0                                            0               1              0   \n",
       "1                                            0               1              0   \n",
       "2                                            0               1              0   \n",
       "3                                            0               1              0   \n",
       "4                                            0               1              0   \n",
       "...                                        ...             ...            ...   \n",
       "7552                                         0               0              0   \n",
       "7553                                         0               1              0   \n",
       "7554                                         0               1              0   \n",
       "7555                                         0               1              0   \n",
       "7556                                         0               1              0   \n",
       "\n",
       "      type_Duplex  \n",
       "0               0  \n",
       "1               0  \n",
       "2               0  \n",
       "3               0  \n",
       "4               0  \n",
       "...           ...  \n",
       "7552            1  \n",
       "7553            0  \n",
       "7554            0  \n",
       "7555            0  \n",
       "7556            0  \n",
       "\n",
       "[7557 rows x 683 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "bed151ac",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Train set shape: (4534, 683)\n",
      "Validation set shape: (1511, 683)\n",
      "Test set shape: (1512, 683)\n"
     ]
    }
   ],
   "source": [
    "# Split the dataset into train, validation, and test sets\n",
    "train_df, remaining_df = train_test_split(df, test_size=0.4, random_state=42)\n",
    "validation_df, test_df = train_test_split(remaining_df, test_size=0.5, random_state=42)\n",
    "\n",
    "# Print the shapes of the resulting DataFrames\n",
    "print(\"Train set shape:\", train_df.shape)\n",
    "print(\"Validation set shape:\", validation_df.shape)\n",
    "print(\"Test set shape:\", test_df.shape) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "626f6e73",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Define the features and target variables for training and validation\n",
    "train_X = train_df\n",
    "train_y = train_df['price']\n",
    "validation_X = validation_df\n",
    "validation_y = validation_df['price']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "80adba50",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Train set MSE: 1.7150910779094587e-20\n",
      "Validation set MSE: 2.1109103809240273e-08\n"
     ]
    }
   ],
   "source": [
    "# Initialize and fit the linear regression model\n",
    "model = LinearRegression()\n",
    "model.fit(train_X, train_y)\n",
    "\n",
    "# Make predictions on training and validation sets\n",
    "train_predictions = model.predict(train_X)\n",
    "validation_predictions = model.predict(validation_X)\n",
    "\n",
    "# Calculate the mean squared error for training and validation sets\n",
    "train_mse = mean_squared_error(train_y, train_predictions)\n",
    "validation_mse = mean_squared_error(validation_y, validation_predictions)\n",
    "\n",
    "# Print the mean squared error\n",
    "print(\"Train set MSE:\", train_mse)\n",
    "print(\"Validation set MSE:\", validation_mse)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "eb838fbc",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Mean Squared Error (MSE) - Test Set: 2.126449941250084e-21\n"
     ]
    }
   ],
   "source": [
    "test_X = test_df\n",
    "test_y = test_df['price']\n",
    "model.fit(test_X, test_y)\n",
    "test_predictions = model.predict(test_X)\n",
    "mse_test = mean_squared_error(test_y, test_predictions)\n",
    "print(\"Mean Squared Error (MSE) - Test Set:\", mse_test)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.16"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}