Q2.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "69d7e8ef",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib as mpl\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "import os\n",
    "from collections import Counter\n",
    "%matplotlib inline\n",
    "from sklearn.linear_model import LogisticRegression\n",
    "\n",
    "import sklearn\n",
    "from sklearn import linear_model, metrics, preprocessing\n",
    "from sklearn.preprocessing import StandardScaler, MinMaxScaler\n",
    "from sklearn.linear_model import LinearRegression\n",
    "from sklearn.metrics import r2_score, f1_score\n",
    "from sklearn.preprocessing import LabelEncoder\n",
    "from sklearn.model_selection import train_test_split\n",
    "\n",
    "pd.options.mode.chained_assignment = None"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "963cfde6",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_florentin=pd.read_csv(\"df_florentinEDA.cvs\")\n",
    "df_hagush_hagadol=pd.read_csv(\"df_hagush_hagadol1EDA.cvs\")\n",
    "df_kiryat_shalom=pd.read_csv(\"df_kiryat_shalomEDA.cvs\")\n",
    "df_neve_shaanan=pd.read_csv(\"df_neve_shaananEDA.cvs\")\n",
    "df_north_star=pd.read_csv(\"df_north_starEDA.cvs\")\n",
    "df_neve_ofer=pd.read_csv(\"df_neve_oferEDA.cvs\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "c9a1e655",
   "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>neighborhood num</th>\n",
       "      <th>Average_rent</th>\n",
       "      <th>School_grade</th>\n",
       "      <th>Socio_economic</th>\n",
       "      <th>Cleanliness_Maintenance</th>\n",
       "      <th>Kindergarten</th>\n",
       "      <th>Parking</th>\n",
       "      <th>Public_Transport</th>\n",
       "      <th>Feeling_confident</th>\n",
       "      <th>Gardens</th>\n",
       "      <th>Recreation_and_leisure</th>\n",
       "      <th>Shopping</th>\n",
       "      <th>Pedestrian_comfort</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>10500</td>\n",
       "      <td>4.50</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.4</td>\n",
       "      <td>3.7</td>\n",
       "      <td>3.5</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.2</td>\n",
       "      <td>2.9</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>6050</td>\n",
       "      <td>1.75</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2.9</td>\n",
       "      <td>4.1</td>\n",
       "      <td>3.5</td>\n",
       "      <td>2.1</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.2</td>\n",
       "      <td>3.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>4450</td>\n",
       "      <td>2.25</td>\n",
       "      <td>1.5</td>\n",
       "      <td>3.9</td>\n",
       "      <td>4.3</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.6</td>\n",
       "      <td>2.2</td>\n",
       "      <td>3.1</td>\n",
       "      <td>4.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>10500</td>\n",
       "      <td>5.00</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.1</td>\n",
       "      <td>4.5</td>\n",
       "      <td>3.8</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4.5</td>\n",
       "      <td>3.1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>6200</td>\n",
       "      <td>3.85</td>\n",
       "      <td>1.5</td>\n",
       "      <td>4.1</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.3</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.8</td>\n",
       "      <td>2.9</td>\n",
       "      <td>3.3</td>\n",
       "      <td>4.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>5000</td>\n",
       "      <td>2.50</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.6</td>\n",
       "      <td>2.8</td>\n",
       "      <td>3.6</td>\n",
       "      <td>4.6</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.7</td>\n",
       "      <td>2.7</td>\n",
       "      <td>2.8</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   neighborhood num  Average_rent  School_grade  Socio_economic  \\\n",
       "0                 1         10500          4.50             4.5   \n",
       "1                 2          6050          1.75             2.5   \n",
       "2                 3          4450          2.25             1.5   \n",
       "3                 4         10500          5.00             4.5   \n",
       "4                 5          6200          3.85             1.5   \n",
       "5                 6          5000          2.50             2.0   \n",
       "\n",
       "   Cleanliness_Maintenance  Kindergarten  Parking  Public_Transport  \\\n",
       "0                      4.4           4.4      3.7               3.5   \n",
       "1                      2.0           2.3      2.9               4.1   \n",
       "2                      3.9           4.3      4.6               4.5   \n",
       "3                      4.5           4.1      4.5               3.8   \n",
       "4                      4.1           4.2      4.3               4.2   \n",
       "5                      2.6           2.8      3.6               4.6   \n",
       "\n",
       "   Feeling_confident  Gardens  Recreation_and_leisure  Shopping  \\\n",
       "0                4.7      4.2                     2.9       3.1   \n",
       "1                3.5      2.1                     4.5       4.2   \n",
       "2                4.0      4.6                     2.2       3.1   \n",
       "3                4.6      4.5                     3.1       3.0   \n",
       "4                4.7      4.8                     2.9       3.3   \n",
       "5                2.8      2.7                     2.7       2.8   \n",
       "\n",
       "   Pedestrian_comfort  \n",
       "0                 3.7  \n",
       "1                 3.8  \n",
       "2                 4.7  \n",
       "3                 4.3  \n",
       "4                 4.7  \n",
       "5                 4.0  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_info=pd.read_csv(\"DF_infoVis.csv\")      \n",
    "df_info.drop('Unnamed: 0',axis=1,inplace=True)\n",
    "df_info"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "ae965cf2",
   "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>adress</th>\n",
       "      <th>square</th>\n",
       "      <th>price for meter</th>\n",
       "      <th>number of rooms</th>\n",
       "      <th>floor</th>\n",
       "      <th>year of build</th>\n",
       "      <th>total price</th>\n",
       "      <th>Day</th>\n",
       "      <th>Month</th>\n",
       "      <th>Year</th>\n",
       "      <th>School_grade</th>\n",
       "      <th>Kindergarten</th>\n",
       "      <th>Feeling_confident</th>\n",
       "      <th>Gardens</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>147.0</td>\n",
       "      <td>40816.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>2019</td>\n",
       "      <td>5999952.0</td>\n",
       "      <td>5</td>\n",
       "      <td>10</td>\n",
       "      <td>2021</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>112.0</td>\n",
       "      <td>39732.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2015</td>\n",
       "      <td>4449984.0</td>\n",
       "      <td>18</td>\n",
       "      <td>8</td>\n",
       "      <td>2021</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>88.0</td>\n",
       "      <td>46590.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2016</td>\n",
       "      <td>4099920.0</td>\n",
       "      <td>10</td>\n",
       "      <td>8</td>\n",
       "      <td>2021</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>88.0</td>\n",
       "      <td>46590.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1980</td>\n",
       "      <td>4099920.0</td>\n",
       "      <td>9</td>\n",
       "      <td>8</td>\n",
       "      <td>2021</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>98.0</td>\n",
       "      <td>40816.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2009</td>\n",
       "      <td>3999968.0</td>\n",
       "      <td>9</td>\n",
       "      <td>8</td>\n",
       "      <td>2021</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.2</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>905</th>\n",
       "      <td>1</td>\n",
       "      <td>80.0</td>\n",
       "      <td>21000.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2008</td>\n",
       "      <td>1680000.0</td>\n",
       "      <td>21</td>\n",
       "      <td>8</td>\n",
       "      <td>2008</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>906</th>\n",
       "      <td>1</td>\n",
       "      <td>80.0</td>\n",
       "      <td>20625.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2008</td>\n",
       "      <td>1650000.0</td>\n",
       "      <td>21</td>\n",
       "      <td>8</td>\n",
       "      <td>2008</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>907</th>\n",
       "      <td>1</td>\n",
       "      <td>130.0</td>\n",
       "      <td>18076.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2008</td>\n",
       "      <td>2349880.0</td>\n",
       "      <td>21</td>\n",
       "      <td>8</td>\n",
       "      <td>2008</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>908</th>\n",
       "      <td>1</td>\n",
       "      <td>80.0</td>\n",
       "      <td>17000.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2008</td>\n",
       "      <td>1360000.0</td>\n",
       "      <td>20</td>\n",
       "      <td>8</td>\n",
       "      <td>2008</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>909</th>\n",
       "      <td>1</td>\n",
       "      <td>109.0</td>\n",
       "      <td>20311.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1999</td>\n",
       "      <td>2213899.0</td>\n",
       "      <td>19</td>\n",
       "      <td>8</td>\n",
       "      <td>2008</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>910 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     adress  square  price for meter  number of rooms  floor  year of build  \\\n",
       "0         1   147.0          40816.0              5.0    7.0           2019   \n",
       "1         1   112.0          39732.0              4.0    2.0           2015   \n",
       "2         1    88.0          46590.0              3.0    1.0           2016   \n",
       "3         1    88.0          46590.0              3.0    1.0           1980   \n",
       "4         1    98.0          40816.0              4.0    5.0           2009   \n",
       "..      ...     ...              ...              ...    ...            ...   \n",
       "905       1    80.0          21000.0              3.0    0.0           2008   \n",
       "906       1    80.0          20625.0              3.0    1.0           2008   \n",
       "907       1   130.0          18076.0              5.0    1.0           2008   \n",
       "908       1    80.0          17000.0              3.0    0.0           2008   \n",
       "909       1   109.0          20311.0              5.0    5.0           1999   \n",
       "\n",
       "     total price  Day  Month  Year  School_grade  Kindergarten  \\\n",
       "0      5999952.0    5     10  2021           4.5           4.4   \n",
       "1      4449984.0   18      8  2021           4.5           4.4   \n",
       "2      4099920.0   10      8  2021           4.5           4.4   \n",
       "3      4099920.0    9      8  2021           4.5           4.4   \n",
       "4      3999968.0    9      8  2021           4.5           4.4   \n",
       "..           ...  ...    ...   ...           ...           ...   \n",
       "905    1680000.0   21      8  2008           4.5           4.4   \n",
       "906    1650000.0   21      8  2008           4.5           4.4   \n",
       "907    2349880.0   21      8  2008           4.5           4.4   \n",
       "908    1360000.0   20      8  2008           4.5           4.4   \n",
       "909    2213899.0   19      8  2008           4.5           4.4   \n",
       "\n",
       "     Feeling_confident  Gardens  \n",
       "0                  4.7      4.2  \n",
       "1                  4.7      4.2  \n",
       "2                  4.7      4.2  \n",
       "3                  4.7      4.2  \n",
       "4                  4.7      4.2  \n",
       "..                 ...      ...  \n",
       "905                4.7      4.2  \n",
       "906                4.7      4.2  \n",
       "907                4.7      4.2  \n",
       "908                4.7      4.2  \n",
       "909                4.7      4.2  \n",
       "\n",
       "[910 rows x 14 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_hagush_hagadol.drop('Unnamed: 0',axis=1,inplace=True)\n",
    "df_hagush_hagadol['School_grade']=4.5\n",
    "df_hagush_hagadol['Kindergarten']=4.4\n",
    "df_hagush_hagadol['Feeling_confident']=4.7\n",
    "df_hagush_hagadol['Gardens']=4.2\n",
    "\n",
    "\n",
    "df_hagush_hagadol"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "be20dc20",
   "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>adress</th>\n",
       "      <th>square</th>\n",
       "      <th>price for meter</th>\n",
       "      <th>number of rooms</th>\n",
       "      <th>floor</th>\n",
       "      <th>year of build</th>\n",
       "      <th>total price</th>\n",
       "      <th>Day</th>\n",
       "      <th>Month</th>\n",
       "      <th>Year</th>\n",
       "      <th>School_grade</th>\n",
       "      <th>Kindergarten</th>\n",
       "      <th>Feeling_confident</th>\n",
       "      <th>Gardens</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2</td>\n",
       "      <td>43.0</td>\n",
       "      <td>56744.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3</td>\n",
       "      <td>2010</td>\n",
       "      <td>2439992.0</td>\n",
       "      <td>26</td>\n",
       "      <td>10</td>\n",
       "      <td>2021</td>\n",
       "      <td>1.75</td>\n",
       "      <td>2.3</td>\n",
       "      <td>3.5</td>\n",
       "      <td>2.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>79.0</td>\n",
       "      <td>15097.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>18</td>\n",
       "      <td>2015</td>\n",
       "      <td>1192663.0</td>\n",
       "      <td>19</td>\n",
       "      <td>10</td>\n",
       "      <td>2021</td>\n",
       "      <td>1.75</td>\n",
       "      <td>2.3</td>\n",
       "      <td>3.5</td>\n",
       "      <td>2.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>100.0</td>\n",
       "      <td>33000.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2015</td>\n",
       "      <td>3300000.0</td>\n",
       "      <td>19</td>\n",
       "      <td>10</td>\n",
       "      <td>2021</td>\n",
       "      <td>1.75</td>\n",
       "      <td>2.3</td>\n",
       "      <td>3.5</td>\n",
       "      <td>2.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2</td>\n",
       "      <td>122.0</td>\n",
       "      <td>29136.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2021</td>\n",
       "      <td>3554592.0</td>\n",
       "      <td>11</td>\n",
       "      <td>10</td>\n",
       "      <td>2021</td>\n",
       "      <td>1.75</td>\n",
       "      <td>2.3</td>\n",
       "      <td>3.5</td>\n",
       "      <td>2.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2</td>\n",
       "      <td>60.0</td>\n",
       "      <td>41333.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2</td>\n",
       "      <td>1940</td>\n",
       "      <td>2479980.0</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>2021</td>\n",
       "      <td>1.75</td>\n",
       "      <td>2.3</td>\n",
       "      <td>3.5</td>\n",
       "      <td>2.1</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>969</th>\n",
       "      <td>2</td>\n",
       "      <td>37.0</td>\n",
       "      <td>32432.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "      <td>1989</td>\n",
       "      <td>1199984.0</td>\n",
       "      <td>16</td>\n",
       "      <td>12</td>\n",
       "      <td>2014</td>\n",
       "      <td>1.75</td>\n",
       "      <td>2.3</td>\n",
       "      <td>3.5</td>\n",
       "      <td>2.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>970</th>\n",
       "      <td>2</td>\n",
       "      <td>69.0</td>\n",
       "      <td>35869.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6</td>\n",
       "      <td>1930</td>\n",
       "      <td>2474961.0</td>\n",
       "      <td>15</td>\n",
       "      <td>12</td>\n",
       "      <td>2014</td>\n",
       "      <td>1.75</td>\n",
       "      <td>2.3</td>\n",
       "      <td>3.5</td>\n",
       "      <td>2.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>971</th>\n",
       "      <td>2</td>\n",
       "      <td>47.0</td>\n",
       "      <td>24329.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2014</td>\n",
       "      <td>1143463.0</td>\n",
       "      <td>14</td>\n",
       "      <td>12</td>\n",
       "      <td>2014</td>\n",
       "      <td>1.75</td>\n",
       "      <td>2.3</td>\n",
       "      <td>3.5</td>\n",
       "      <td>2.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>972</th>\n",
       "      <td>2</td>\n",
       "      <td>38.0</td>\n",
       "      <td>30263.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2014</td>\n",
       "      <td>1149994.0</td>\n",
       "      <td>14</td>\n",
       "      <td>12</td>\n",
       "      <td>2014</td>\n",
       "      <td>1.75</td>\n",
       "      <td>2.3</td>\n",
       "      <td>3.5</td>\n",
       "      <td>2.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>973</th>\n",
       "      <td>2</td>\n",
       "      <td>139.0</td>\n",
       "      <td>23165.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3</td>\n",
       "      <td>2015</td>\n",
       "      <td>3219935.0</td>\n",
       "      <td>14</td>\n",
       "      <td>12</td>\n",
       "      <td>2014</td>\n",
       "      <td>1.75</td>\n",
       "      <td>2.3</td>\n",
       "      <td>3.5</td>\n",
       "      <td>2.1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>974 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     adress  square  price for meter  number of rooms  floor  year of build  \\\n",
       "0         2    43.0          56744.0              2.0      3           2010   \n",
       "1         2    79.0          15097.0              3.0     18           2015   \n",
       "2         2   100.0          33000.0              4.0      1           2015   \n",
       "3         2   122.0          29136.0              5.0      1           2021   \n",
       "4         2    60.0          41333.0              3.0      2           1940   \n",
       "..      ...     ...              ...              ...    ...            ...   \n",
       "969       2    37.0          32432.0              2.0      2           1989   \n",
       "970       2    69.0          35869.0              3.0      6           1930   \n",
       "971       2    47.0          24329.0              2.0      1           2014   \n",
       "972       2    38.0          30263.0              2.0      2           2014   \n",
       "973       2   139.0          23165.0              5.0      3           2015   \n",
       "\n",
       "     total price  Day  Month  Year  School_grade  Kindergarten  \\\n",
       "0      2439992.0   26     10  2021          1.75           2.3   \n",
       "1      1192663.0   19     10  2021          1.75           2.3   \n",
       "2      3300000.0   19     10  2021          1.75           2.3   \n",
       "3      3554592.0   11     10  2021          1.75           2.3   \n",
       "4      2479980.0    1     10  2021          1.75           2.3   \n",
       "..           ...  ...    ...   ...           ...           ...   \n",
       "969    1199984.0   16     12  2014          1.75           2.3   \n",
       "970    2474961.0   15     12  2014          1.75           2.3   \n",
       "971    1143463.0   14     12  2014          1.75           2.3   \n",
       "972    1149994.0   14     12  2014          1.75           2.3   \n",
       "973    3219935.0   14     12  2014          1.75           2.3   \n",
       "\n",
       "     Feeling_confident  Gardens  \n",
       "0                  3.5      2.1  \n",
       "1                  3.5      2.1  \n",
       "2                  3.5      2.1  \n",
       "3                  3.5      2.1  \n",
       "4                  3.5      2.1  \n",
       "..                 ...      ...  \n",
       "969                3.5      2.1  \n",
       "970                3.5      2.1  \n",
       "971                3.5      2.1  \n",
       "972                3.5      2.1  \n",
       "973                3.5      2.1  \n",
       "\n",
       "[974 rows x 14 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_florentin.drop('Unnamed: 0',axis=1,inplace=True)\n",
    "df_florentin['School_grade']=1.75\n",
    "df_florentin['Kindergarten']=2.3\n",
    "df_florentin['Feeling_confident']=3.5\n",
    "df_florentin['Gardens']=2.1\n",
    "df_florentin"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "46e0aae0",
   "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>adress</th>\n",
       "      <th>square</th>\n",
       "      <th>price for meter</th>\n",
       "      <th>number of rooms</th>\n",
       "      <th>floor</th>\n",
       "      <th>year of build</th>\n",
       "      <th>total price</th>\n",
       "      <th>Day</th>\n",
       "      <th>Month</th>\n",
       "      <th>Year</th>\n",
       "      <th>School_grade</th>\n",
       "      <th>Kindergarten</th>\n",
       "      <th>Feeling_confident</th>\n",
       "      <th>Gardens</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3</td>\n",
       "      <td>143.0</td>\n",
       "      <td>22867.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2019</td>\n",
       "      <td>3269981.0</td>\n",
       "      <td>26</td>\n",
       "      <td>10</td>\n",
       "      <td>2021</td>\n",
       "      <td>2.25</td>\n",
       "      <td>4.3</td>\n",
       "      <td>4</td>\n",
       "      <td>4.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3</td>\n",
       "      <td>63.0</td>\n",
       "      <td>38095.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>8</td>\n",
       "      <td>2021</td>\n",
       "      <td>2399985.0</td>\n",
       "      <td>25</td>\n",
       "      <td>10</td>\n",
       "      <td>2021</td>\n",
       "      <td>2.25</td>\n",
       "      <td>4.3</td>\n",
       "      <td>4</td>\n",
       "      <td>4.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>104.0</td>\n",
       "      <td>25836.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>13</td>\n",
       "      <td>2019</td>\n",
       "      <td>2686944.0</td>\n",
       "      <td>18</td>\n",
       "      <td>10</td>\n",
       "      <td>2021</td>\n",
       "      <td>2.25</td>\n",
       "      <td>4.3</td>\n",
       "      <td>4</td>\n",
       "      <td>4.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>82.0</td>\n",
       "      <td>31341.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>7</td>\n",
       "      <td>2021</td>\n",
       "      <td>2569962.0</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>2021</td>\n",
       "      <td>2.25</td>\n",
       "      <td>4.3</td>\n",
       "      <td>4</td>\n",
       "      <td>4.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3</td>\n",
       "      <td>81.0</td>\n",
       "      <td>32098.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>9</td>\n",
       "      <td>2021</td>\n",
       "      <td>2599938.0</td>\n",
       "      <td>25</td>\n",
       "      <td>8</td>\n",
       "      <td>2021</td>\n",
       "      <td>2.25</td>\n",
       "      <td>4.3</td>\n",
       "      <td>4</td>\n",
       "      <td>4.6</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>967</th>\n",
       "      <td>3</td>\n",
       "      <td>63.0</td>\n",
       "      <td>7038.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4</td>\n",
       "      <td>1990</td>\n",
       "      <td>443394.0</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>2008</td>\n",
       "      <td>2.25</td>\n",
       "      <td>4.3</td>\n",
       "      <td>4</td>\n",
       "      <td>4.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>968</th>\n",
       "      <td>3</td>\n",
       "      <td>65.0</td>\n",
       "      <td>6705.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2</td>\n",
       "      <td>1972</td>\n",
       "      <td>435825.0</td>\n",
       "      <td>14</td>\n",
       "      <td>1</td>\n",
       "      <td>2008</td>\n",
       "      <td>2.25</td>\n",
       "      <td>4.3</td>\n",
       "      <td>4</td>\n",
       "      <td>4.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>969</th>\n",
       "      <td>3</td>\n",
       "      <td>90.0</td>\n",
       "      <td>6111.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1974</td>\n",
       "      <td>549990.0</td>\n",
       "      <td>14</td>\n",
       "      <td>1</td>\n",
       "      <td>2008</td>\n",
       "      <td>2.25</td>\n",
       "      <td>4.3</td>\n",
       "      <td>4</td>\n",
       "      <td>4.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>970</th>\n",
       "      <td>3</td>\n",
       "      <td>100.0</td>\n",
       "      <td>9000.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5</td>\n",
       "      <td>1992</td>\n",
       "      <td>900000.0</td>\n",
       "      <td>13</td>\n",
       "      <td>1</td>\n",
       "      <td>2008</td>\n",
       "      <td>2.25</td>\n",
       "      <td>4.3</td>\n",
       "      <td>4</td>\n",
       "      <td>4.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>971</th>\n",
       "      <td>3</td>\n",
       "      <td>75.0</td>\n",
       "      <td>6000.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2</td>\n",
       "      <td>1970</td>\n",
       "      <td>450000.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2008</td>\n",
       "      <td>2.25</td>\n",
       "      <td>4.3</td>\n",
       "      <td>4</td>\n",
       "      <td>4.6</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>972 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     adress  square  price for meter  number of rooms  floor  year of build  \\\n",
       "0         3   143.0          22867.0              6.0      2           2019   \n",
       "1         3    63.0          38095.0              3.0      8           2021   \n",
       "2         3   104.0          25836.0              4.0     13           2019   \n",
       "3         3    82.0          31341.0              3.0      7           2021   \n",
       "4         3    81.0          32098.0              3.0      9           2021   \n",
       "..      ...     ...              ...              ...    ...            ...   \n",
       "967       3    63.0           7038.0              3.0      4           1990   \n",
       "968       3    65.0           6705.0              3.0      2           1972   \n",
       "969       3    90.0           6111.0              3.0      1           1974   \n",
       "970       3   100.0           9000.0              4.0      5           1992   \n",
       "971       3    75.0           6000.0              3.0      2           1970   \n",
       "\n",
       "     total price  Day  Month  Year  School_grade  Kindergarten  \\\n",
       "0      3269981.0   26     10  2021          2.25           4.3   \n",
       "1      2399985.0   25     10  2021          2.25           4.3   \n",
       "2      2686944.0   18     10  2021          2.25           4.3   \n",
       "3      2569962.0    9      9  2021          2.25           4.3   \n",
       "4      2599938.0   25      8  2021          2.25           4.3   \n",
       "..           ...  ...    ...   ...           ...           ...   \n",
       "967     443394.0   15      1  2008          2.25           4.3   \n",
       "968     435825.0   14      1  2008          2.25           4.3   \n",
       "969     549990.0   14      1  2008          2.25           4.3   \n",
       "970     900000.0   13      1  2008          2.25           4.3   \n",
       "971     450000.0    1      1  2008          2.25           4.3   \n",
       "\n",
       "     Feeling_confident  Gardens  \n",
       "0                    4      4.6  \n",
       "1                    4      4.6  \n",
       "2                    4      4.6  \n",
       "3                    4      4.6  \n",
       "4                    4      4.6  \n",
       "..                 ...      ...  \n",
       "967                  4      4.6  \n",
       "968                  4      4.6  \n",
       "969                  4      4.6  \n",
       "970                  4      4.6  \n",
       "971                  4      4.6  \n",
       "\n",
       "[972 rows x 14 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_neve_ofer.drop('Unnamed: 0',axis=1,inplace=True)\n",
    "df_neve_ofer['School_grade']=2.25\n",
    "df_neve_ofer['Kindergarten']=4.3\n",
    "df_neve_ofer['Feeling_confident']=4\n",
    "df_neve_ofer['Gardens']=4.6\n",
    "df_neve_ofer"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "a90eea69",
   "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>adress</th>\n",
       "      <th>square</th>\n",
       "      <th>price for meter</th>\n",
       "      <th>number of rooms</th>\n",
       "      <th>floor</th>\n",
       "      <th>year of build</th>\n",
       "      <th>total price</th>\n",
       "      <th>Day</th>\n",
       "      <th>Month</th>\n",
       "      <th>Year</th>\n",
       "      <th>School_grade</th>\n",
       "      <th>Kindergarten</th>\n",
       "      <th>Feeling_confident</th>\n",
       "      <th>Gardens</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4</td>\n",
       "      <td>103.0</td>\n",
       "      <td>56240.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>7</td>\n",
       "      <td>2021</td>\n",
       "      <td>5792720.0</td>\n",
       "      <td>13</td>\n",
       "      <td>9</td>\n",
       "      <td>2021</td>\n",
       "      <td>5</td>\n",
       "      <td>4.1</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4</td>\n",
       "      <td>125.0</td>\n",
       "      <td>37280.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>7</td>\n",
       "      <td>1980</td>\n",
       "      <td>4660000.0</td>\n",
       "      <td>23</td>\n",
       "      <td>8</td>\n",
       "      <td>2021</td>\n",
       "      <td>5</td>\n",
       "      <td>4.1</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4</td>\n",
       "      <td>103.0</td>\n",
       "      <td>54050.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3</td>\n",
       "      <td>2021</td>\n",
       "      <td>5567150.0</td>\n",
       "      <td>22</td>\n",
       "      <td>7</td>\n",
       "      <td>2021</td>\n",
       "      <td>5</td>\n",
       "      <td>4.1</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>75.0</td>\n",
       "      <td>58561.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>9</td>\n",
       "      <td>2021</td>\n",
       "      <td>4392075.0</td>\n",
       "      <td>21</td>\n",
       "      <td>7</td>\n",
       "      <td>2021</td>\n",
       "      <td>5</td>\n",
       "      <td>4.1</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>75.0</td>\n",
       "      <td>54666.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2021</td>\n",
       "      <td>4099950.0</td>\n",
       "      <td>13</td>\n",
       "      <td>7</td>\n",
       "      <td>2021</td>\n",
       "      <td>5</td>\n",
       "      <td>4.1</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4.5</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>892</th>\n",
       "      <td>4</td>\n",
       "      <td>130.0</td>\n",
       "      <td>48961.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>12</td>\n",
       "      <td>2008</td>\n",
       "      <td>6364930.0</td>\n",
       "      <td>11</td>\n",
       "      <td>9</td>\n",
       "      <td>2008</td>\n",
       "      <td>5</td>\n",
       "      <td>4.1</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>893</th>\n",
       "      <td>4</td>\n",
       "      <td>116.0</td>\n",
       "      <td>19827.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2008</td>\n",
       "      <td>2299932.0</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>2008</td>\n",
       "      <td>5</td>\n",
       "      <td>4.1</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>894</th>\n",
       "      <td>4</td>\n",
       "      <td>136.0</td>\n",
       "      <td>21382.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2</td>\n",
       "      <td>1999</td>\n",
       "      <td>2907952.0</td>\n",
       "      <td>2</td>\n",
       "      <td>9</td>\n",
       "      <td>2008</td>\n",
       "      <td>5</td>\n",
       "      <td>4.1</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>895</th>\n",
       "      <td>4</td>\n",
       "      <td>100.0</td>\n",
       "      <td>16000.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2</td>\n",
       "      <td>1990</td>\n",
       "      <td>1600000.0</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>2008</td>\n",
       "      <td>5</td>\n",
       "      <td>4.1</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>896</th>\n",
       "      <td>4</td>\n",
       "      <td>145.0</td>\n",
       "      <td>18448.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1980</td>\n",
       "      <td>2674960.0</td>\n",
       "      <td>27</td>\n",
       "      <td>8</td>\n",
       "      <td>2008</td>\n",
       "      <td>5</td>\n",
       "      <td>4.1</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4.5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>897 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     adress  square  price for meter  number of rooms  floor  year of build  \\\n",
       "0         4   103.0          56240.0              4.0      7           2021   \n",
       "1         4   125.0          37280.0              4.0      7           1980   \n",
       "2         4   103.0          54050.0              4.0      3           2021   \n",
       "3         4    75.0          58561.0              3.0      9           2021   \n",
       "4         4    75.0          54666.0              3.0      2           2021   \n",
       "..      ...     ...              ...              ...    ...            ...   \n",
       "892       4   130.0          48961.0              5.0     12           2008   \n",
       "893       4   116.0          19827.0              5.0      2           2008   \n",
       "894       4   136.0          21382.0              4.0      2           1999   \n",
       "895       4   100.0          16000.0              4.0      2           1990   \n",
       "896       4   145.0          18448.0              4.0      0           1980   \n",
       "\n",
       "     total price  Day  Month  Year  School_grade  Kindergarten  \\\n",
       "0      5792720.0   13      9  2021             5           4.1   \n",
       "1      4660000.0   23      8  2021             5           4.1   \n",
       "2      5567150.0   22      7  2021             5           4.1   \n",
       "3      4392075.0   21      7  2021             5           4.1   \n",
       "4      4099950.0   13      7  2021             5           4.1   \n",
       "..           ...  ...    ...   ...           ...           ...   \n",
       "892    6364930.0   11      9  2008             5           4.1   \n",
       "893    2299932.0    9      9  2008             5           4.1   \n",
       "894    2907952.0    2      9  2008             5           4.1   \n",
       "895    1600000.0    1      9  2008             5           4.1   \n",
       "896    2674960.0   27      8  2008             5           4.1   \n",
       "\n",
       "     Feeling_confident  Gardens  \n",
       "0                  4.6      4.5  \n",
       "1                  4.6      4.5  \n",
       "2                  4.6      4.5  \n",
       "3                  4.6      4.5  \n",
       "4                  4.6      4.5  \n",
       "..                 ...      ...  \n",
       "892                4.6      4.5  \n",
       "893                4.6      4.5  \n",
       "894                4.6      4.5  \n",
       "895                4.6      4.5  \n",
       "896                4.6      4.5  \n",
       "\n",
       "[897 rows x 14 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_north_star.drop('Unnamed: 0',axis=1,inplace=True)\n",
    "df_north_star['School_grade']=5\n",
    "df_north_star['Kindergarten']=4.1\n",
    "df_north_star['Feeling_confident']=4.6\n",
    "df_north_star['Gardens']=4.5\n",
    "df_north_star"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "cefa797e",
   "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>adress</th>\n",
       "      <th>square</th>\n",
       "      <th>price for meter</th>\n",
       "      <th>number of rooms</th>\n",
       "      <th>floor</th>\n",
       "      <th>year of build</th>\n",
       "      <th>total price</th>\n",
       "      <th>Day</th>\n",
       "      <th>Month</th>\n",
       "      <th>Year</th>\n",
       "      <th>School_grade</th>\n",
       "      <th>Kindergarten</th>\n",
       "      <th>Feeling_confident</th>\n",
       "      <th>Gardens</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>5</td>\n",
       "      <td>79.0</td>\n",
       "      <td>15097.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>18</td>\n",
       "      <td>2008</td>\n",
       "      <td>1192663.0</td>\n",
       "      <td>20</td>\n",
       "      <td>10</td>\n",
       "      <td>2021</td>\n",
       "      <td>3.85</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>5</td>\n",
       "      <td>82.0</td>\n",
       "      <td>24634.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5</td>\n",
       "      <td>2021</td>\n",
       "      <td>2019988.0</td>\n",
       "      <td>22</td>\n",
       "      <td>8</td>\n",
       "      <td>2021</td>\n",
       "      <td>3.85</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>5</td>\n",
       "      <td>92.0</td>\n",
       "      <td>20869.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4</td>\n",
       "      <td>2021</td>\n",
       "      <td>1919948.0</td>\n",
       "      <td>22</td>\n",
       "      <td>8</td>\n",
       "      <td>2021</td>\n",
       "      <td>3.85</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>5</td>\n",
       "      <td>105.0</td>\n",
       "      <td>29714.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>7</td>\n",
       "      <td>2018</td>\n",
       "      <td>3119970.0</td>\n",
       "      <td>9</td>\n",
       "      <td>8</td>\n",
       "      <td>2021</td>\n",
       "      <td>3.85</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>71.0</td>\n",
       "      <td>42859.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1950</td>\n",
       "      <td>3042989.0</td>\n",
       "      <td>6</td>\n",
       "      <td>8</td>\n",
       "      <td>2021</td>\n",
       "      <td>3.85</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.8</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>970</th>\n",
       "      <td>5</td>\n",
       "      <td>120.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1960</td>\n",
       "      <td>1200000.0</td>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "      <td>2008</td>\n",
       "      <td>3.85</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>971</th>\n",
       "      <td>5</td>\n",
       "      <td>86.0</td>\n",
       "      <td>11279.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4</td>\n",
       "      <td>2000</td>\n",
       "      <td>969994.0</td>\n",
       "      <td>7</td>\n",
       "      <td>9</td>\n",
       "      <td>2008</td>\n",
       "      <td>3.85</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>972</th>\n",
       "      <td>5</td>\n",
       "      <td>56.0</td>\n",
       "      <td>8571.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4</td>\n",
       "      <td>1999</td>\n",
       "      <td>479976.0</td>\n",
       "      <td>5</td>\n",
       "      <td>9</td>\n",
       "      <td>2008</td>\n",
       "      <td>3.85</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>973</th>\n",
       "      <td>5</td>\n",
       "      <td>59.0</td>\n",
       "      <td>7627.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3</td>\n",
       "      <td>1955</td>\n",
       "      <td>449993.0</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>2008</td>\n",
       "      <td>3.85</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>974</th>\n",
       "      <td>5</td>\n",
       "      <td>86.0</td>\n",
       "      <td>11395.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2001</td>\n",
       "      <td>979970.0</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>2008</td>\n",
       "      <td>3.85</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4.8</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>975 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     adress  square  price for meter  number of rooms  floor  year of build  \\\n",
       "0         5    79.0          15097.0              3.0     18           2008   \n",
       "1         5    82.0          24634.0              3.0      5           2021   \n",
       "2         5    92.0          20869.0              4.0      4           2021   \n",
       "3         5   105.0          29714.0              4.0      7           2018   \n",
       "4         5    71.0          42859.0              3.0      1           1950   \n",
       "..      ...     ...              ...              ...    ...            ...   \n",
       "970       5   120.0          10000.0              6.0      0           1960   \n",
       "971       5    86.0          11279.0              4.0      4           2000   \n",
       "972       5    56.0           8571.0              3.0      4           1999   \n",
       "973       5    59.0           7627.0              3.0      3           1955   \n",
       "974       5    86.0          11395.0              4.0      1           2001   \n",
       "\n",
       "     total price  Day  Month  Year  School_grade  Kindergarten  \\\n",
       "0      1192663.0   20     10  2021          3.85           4.2   \n",
       "1      2019988.0   22      8  2021          3.85           4.2   \n",
       "2      1919948.0   22      8  2021          3.85           4.2   \n",
       "3      3119970.0    9      8  2021          3.85           4.2   \n",
       "4      3042989.0    6      8  2021          3.85           4.2   \n",
       "..           ...  ...    ...   ...           ...           ...   \n",
       "970    1200000.0    8      9  2008          3.85           4.2   \n",
       "971     969994.0    7      9  2008          3.85           4.2   \n",
       "972     479976.0    5      9  2008          3.85           4.2   \n",
       "973     449993.0    3      9  2008          3.85           4.2   \n",
       "974     979970.0    1      9  2008          3.85           4.2   \n",
       "\n",
       "     Feeling_confident  Gardens  \n",
       "0                  4.7      4.8  \n",
       "1                  4.7      4.8  \n",
       "2                  4.7      4.8  \n",
       "3                  4.7      4.8  \n",
       "4                  4.7      4.8  \n",
       "..                 ...      ...  \n",
       "970                4.7      4.8  \n",
       "971                4.7      4.8  \n",
       "972                4.7      4.8  \n",
       "973                4.7      4.8  \n",
       "974                4.7      4.8  \n",
       "\n",
       "[975 rows x 14 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_kiryat_shalom.drop('Unnamed: 0',axis=1,inplace=True)\n",
    "df_kiryat_shalom['School_grade']=3.85\n",
    "df_kiryat_shalom['Kindergarten']=4.2\n",
    "df_kiryat_shalom['Feeling_confident']=4.7\n",
    "df_kiryat_shalom['Gardens']=4.8\n",
    "df_kiryat_shalom"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "ab507957",
   "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>adress</th>\n",
       "      <th>square</th>\n",
       "      <th>price for meter</th>\n",
       "      <th>number of rooms</th>\n",
       "      <th>floor</th>\n",
       "      <th>year of build</th>\n",
       "      <th>total price</th>\n",
       "      <th>Day</th>\n",
       "      <th>Month</th>\n",
       "      <th>Year</th>\n",
       "      <th>School_grade</th>\n",
       "      <th>Kindergarten</th>\n",
       "      <th>Feeling_confident</th>\n",
       "      <th>Gardens</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>6</td>\n",
       "      <td>80.0</td>\n",
       "      <td>41125.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6</td>\n",
       "      <td>2023</td>\n",
       "      <td>3290000.0</td>\n",
       "      <td>28</td>\n",
       "      <td>10</td>\n",
       "      <td>2021</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>6</td>\n",
       "      <td>119.0</td>\n",
       "      <td>44957.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>12</td>\n",
       "      <td>2018</td>\n",
       "      <td>5349883.0</td>\n",
       "      <td>5</td>\n",
       "      <td>10</td>\n",
       "      <td>2021</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>6</td>\n",
       "      <td>103.0</td>\n",
       "      <td>45631.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2018</td>\n",
       "      <td>4699993.0</td>\n",
       "      <td>5</td>\n",
       "      <td>10</td>\n",
       "      <td>2021</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>6</td>\n",
       "      <td>67.0</td>\n",
       "      <td>26119.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2013</td>\n",
       "      <td>1749973.0</td>\n",
       "      <td>3</td>\n",
       "      <td>10</td>\n",
       "      <td>2021</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>6</td>\n",
       "      <td>53.0</td>\n",
       "      <td>40094.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2012</td>\n",
       "      <td>2124982.0</td>\n",
       "      <td>3</td>\n",
       "      <td>10</td>\n",
       "      <td>2021</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.7</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>979</th>\n",
       "      <td>6</td>\n",
       "      <td>50.0</td>\n",
       "      <td>22948.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4</td>\n",
       "      <td>2016</td>\n",
       "      <td>1147400.0</td>\n",
       "      <td>16</td>\n",
       "      <td>12</td>\n",
       "      <td>2014</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>980</th>\n",
       "      <td>6</td>\n",
       "      <td>50.0</td>\n",
       "      <td>22439.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2016</td>\n",
       "      <td>1121950.0</td>\n",
       "      <td>16</td>\n",
       "      <td>12</td>\n",
       "      <td>2014</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>981</th>\n",
       "      <td>6</td>\n",
       "      <td>76.0</td>\n",
       "      <td>14736.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3</td>\n",
       "      <td>1958</td>\n",
       "      <td>1119936.0</td>\n",
       "      <td>16</td>\n",
       "      <td>12</td>\n",
       "      <td>2014</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>982</th>\n",
       "      <td>6</td>\n",
       "      <td>60.0</td>\n",
       "      <td>7333.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1960</td>\n",
       "      <td>439980.0</td>\n",
       "      <td>16</td>\n",
       "      <td>12</td>\n",
       "      <td>2014</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>983</th>\n",
       "      <td>6</td>\n",
       "      <td>56.0</td>\n",
       "      <td>17142.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1961</td>\n",
       "      <td>959952.0</td>\n",
       "      <td>15</td>\n",
       "      <td>12</td>\n",
       "      <td>2014</td>\n",
       "      <td>2.5</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.8</td>\n",
       "      <td>2.7</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>984 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     adress  square  price for meter  number of rooms  floor  year of build  \\\n",
       "0         6    80.0          41125.0              3.0      6           2023   \n",
       "1         6   119.0          44957.0              5.0     12           2018   \n",
       "2         6   103.0          45631.0              4.0      1           2018   \n",
       "3         6    67.0          26119.0              3.0      2           2013   \n",
       "4         6    53.0          40094.0              2.0      2           2012   \n",
       "..      ...     ...              ...              ...    ...            ...   \n",
       "979       6    50.0          22948.0              2.0      4           2016   \n",
       "980       6    50.0          22439.0              2.0      2           2016   \n",
       "981       6    76.0          14736.0              3.0      3           1958   \n",
       "982       6    60.0           7333.0              3.0      0           1960   \n",
       "983       6    56.0          17142.0              4.0      1           1961   \n",
       "\n",
       "     total price  Day  Month  Year  School_grade  Kindergarten  \\\n",
       "0      3290000.0   28     10  2021           2.5           2.8   \n",
       "1      5349883.0    5     10  2021           2.5           2.8   \n",
       "2      4699993.0    5     10  2021           2.5           2.8   \n",
       "3      1749973.0    3     10  2021           2.5           2.8   \n",
       "4      2124982.0    3     10  2021           2.5           2.8   \n",
       "..           ...  ...    ...   ...           ...           ...   \n",
       "979    1147400.0   16     12  2014           2.5           2.8   \n",
       "980    1121950.0   16     12  2014           2.5           2.8   \n",
       "981    1119936.0   16     12  2014           2.5           2.8   \n",
       "982     439980.0   16     12  2014           2.5           2.8   \n",
       "983     959952.0   15     12  2014           2.5           2.8   \n",
       "\n",
       "     Feeling_confident  Gardens  \n",
       "0                  2.8      2.7  \n",
       "1                  2.8      2.7  \n",
       "2                  2.8      2.7  \n",
       "3                  2.8      2.7  \n",
       "4                  2.8      2.7  \n",
       "..                 ...      ...  \n",
       "979                2.8      2.7  \n",
       "980                2.8      2.7  \n",
       "981                2.8      2.7  \n",
       "982                2.8      2.7  \n",
       "983                2.8      2.7  \n",
       "\n",
       "[984 rows x 14 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_neve_shaanan.drop('Unnamed: 0',axis=1,inplace=True)\n",
    "df_neve_shaanan['School_grade']=2.5\n",
    "df_neve_shaanan['Kindergarten']=2.8\n",
    "df_neve_shaanan['Feeling_confident']=2.8\n",
    "df_neve_shaanan['Gardens']=2.7\n",
    "df_neve_shaanan"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "bbc8e99e",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfQ1=pd.concat([df_hagush_hagadol, df_florentin, df_neve_ofer, df_north_star, df_kiryat_shalom, df_neve_shaanan], axis=0)\n",
    "\n",
    "#dfQ1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "beff090f",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfQ1['fam']=0\n",
    "for i in range (5712):\n",
    "    if(dfQ1.iloc[i, 13] <3 or dfQ1.iloc[i, 12]<3 or dfQ1.iloc[i, 11]<2.5 or dfQ1.iloc[i, 10]<2.45):\n",
    "        dfQ1.iloc[i, 14] = 0\n",
    "    else:\n",
    "        dfQ1.iloc[i, 14] = 1\n",
    "#dfQ1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "46c2987f",
   "metadata": {},
   "outputs": [],
   "source": [
    "X = dfQ1.drop(['fam'], axis=1)\n",
    "y = dfQ1['fam']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "f5431b86",
   "metadata": {},
   "outputs": [],
   "source": [
    "xtrain, xtest, ytrain, ytest = train_test_split(X, y, test_size=0.2, random_state=0)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "a4797e33",
   "metadata": {},
   "outputs": [],
   "source": [
    "clf = LogisticRegression(solver='lbfgs', max_iter=20000) # max_iter is the number of itrations it takes for all centroids to converge\n",
    "clf.fit(xtrain, ytrain)\n",
    "\n",
    "y_pred = clf.predict(xtest)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "300eeca0",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Accuracy is: 0.7891513560804899\n"
     ]
    }
   ],
   "source": [
    "print(\"Accuracy is:\",metrics.accuracy_score(ytest, y_pred))\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "4d8c8ddb",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "eec3c71b",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}