model_training.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "df6003ac",
   "metadata": {},
   "source": [
    "## Data preparation"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a33aee1d",
   "metadata": {},
   "source": [
    "### Load curated dataset"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "531cafca",
   "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>sq_mt_built</th>\n",
       "      <th>n_rooms</th>\n",
       "      <th>n_bathrooms</th>\n",
       "      <th>has_lift</th>\n",
       "      <th>has_parking</th>\n",
       "      <th>is_exterior</th>\n",
       "      <th>floor</th>\n",
       "      <th>energy_certificate</th>\n",
       "      <th>neighborhood</th>\n",
       "      <th>house_type</th>\n",
       "      <th>rent_price</th>\n",
       "      <th>buy_price</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>7066</th>\n",
       "      <td>147</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>0</td>\n",
       "      <td>unknown</td>\n",
       "      <td>Peñagrande</td>\n",
       "      <td>duplex</td>\n",
       "      <td>2047</td>\n",
       "      <td>665000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3037</th>\n",
       "      <td>92</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>1</td>\n",
       "      <td>unknown</td>\n",
       "      <td>Berruguete</td>\n",
       "      <td>flat</td>\n",
       "      <td>1148</td>\n",
       "      <td>280000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13870</th>\n",
       "      <td>123</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>1</td>\n",
       "      <td>good</td>\n",
       "      <td>Chueca-Justicia</td>\n",
       "      <td>flat</td>\n",
       "      <td>1873</td>\n",
       "      <td>590000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13507</th>\n",
       "      <td>156</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>5</td>\n",
       "      <td>bad</td>\n",
       "      <td>Puerta Bonita</td>\n",
       "      <td>attic</td>\n",
       "      <td>1299</td>\n",
       "      <td>340000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11792</th>\n",
       "      <td>100</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>3</td>\n",
       "      <td>unknown</td>\n",
       "      <td>Ciudad Jardín</td>\n",
       "      <td>flat</td>\n",
       "      <td>1576</td>\n",
       "      <td>460000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       sq_mt_built  n_rooms  n_bathrooms  has_lift  has_parking  is_exterior  \\\n",
       "7066           147        3            2      True         True         True   \n",
       "3037            92        3            2      True         True         True   \n",
       "13870          123        2            2      True        False         True   \n",
       "13507          156        3            2      True         True         True   \n",
       "11792          100        4            2      True        False         True   \n",
       "\n",
       "      floor energy_certificate     neighborhood house_type  rent_price  \\\n",
       "7066      0            unknown       Peñagrande     duplex        2047   \n",
       "3037      1            unknown       Berruguete       flat        1148   \n",
       "13870     1               good  Chueca-Justicia       flat        1873   \n",
       "13507     5                bad    Puerta Bonita      attic        1299   \n",
       "11792     3            unknown    Ciudad Jardín       flat        1576   \n",
       "\n",
       "       buy_price  \n",
       "7066      665000  \n",
       "3037      280000  \n",
       "13870     590000  \n",
       "13507     340000  \n",
       "11792     460000  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "pd.set_option(\"display.max_columns\", None)\n",
    "pd.set_option(\"display.max_colwidth\", 200)\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sn\n",
    "\n",
    "madrid_df = pd.read_csv(\"data/clean_madrid_houses.csv\")\n",
    "df = madrid_df.copy()\n",
    "\n",
    "display(df.sample(5))"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b5c8ed73",
   "metadata": {},
   "source": [
    "### Split data and targets"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "3cedfce9",
   "metadata": {},
   "outputs": [],
   "source": [
    "y_buy = df['buy_price']\n",
    "y_rent = df['rent_price']\n",
    "X = df.drop(['buy_price', 'rent_price'], axis='columns')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "fe5c2ae2",
   "metadata": {},
   "source": [
    "### Create dummies"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "8e576bbe-afe8-4b36-8096-a4d659eb25b5",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['3', '4', '1', '0', '2', '7', '5', '6', 'other', '8', '9'],\n",
       "      dtype=object)"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/plain": [
       "array(['good', 'unknown', 'bad'], dtype=object)"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/plain": [
       "array(['San Cristóbal', 'Los Ángeles', 'San Andrés', 'Los Rosales',\n",
       "       'Butarque', 'Valdebernardo - Valderribas', 'Ambroz',\n",
       "       'Casco Histórico de Vicálvaro', 'El Cañaveral - Los Berrocales',\n",
       "       'Ensanche de Vallecas - La Gavia', 'Casco Histórico de Vallecas',\n",
       "       'Santa Eugenia', 'Orcasitas', 'San Fermín', 'Moscardó',\n",
       "       'Pradolongo', 'Almendrales', 'Zofío', '12 de Octubre-Orcasur',\n",
       "       'Cuzco-Castillejos', 'Cuatro Caminos', 'Bellas Vistas',\n",
       "       'Berruguete', 'Valdeacederas', 'Ventilla-Almenara', 'Niño Jesús',\n",
       "       'Ibiza', 'Adelfas', 'Pacífico', 'Jerónimos', 'Estrella',\n",
       "       'Palomeras sureste', 'Palomeras Bajas', 'San Diego', 'Numancia',\n",
       "       'Entrevías', 'Portazgo', 'Aravaca', 'Argüelles', 'Casa de Campo',\n",
       "       'Ciudad Universitaria', 'Valdemarín', 'Valdezarza', 'Fontarrón',\n",
       "       'Vinateros', 'Marroquina', 'Media Legua', 'Puerta del Ángel',\n",
       "       'Aluche', 'Lucero', 'Los Cármenes', 'Águilas', 'Campamento',\n",
       "       'El Plantío', 'Las Tablas', 'Montecarmelo', 'La Paz', 'Pilar',\n",
       "       'Fuentelarreina', 'Peñagrande', 'Tres Olivos - Valverde',\n",
       "       'Mirasierra', 'Arroyo del Fresno', 'Sanchinarro',\n",
       "       'Conde Orgaz-Piovera', 'Palomas', 'Virgen del Cortijo - Manoteras',\n",
       "       'Valdebebas - Valdefuentes', 'Pinar del Rey', 'Canillas',\n",
       "       'Apóstol Santiago', 'Gaztambide', 'Nuevos Ministerios-Ríos Rosas',\n",
       "       'Almagro', 'Trafalgar', 'Arapiles', 'Vallehermoso', 'Ventas',\n",
       "       'Pueblo Nuevo', 'Quintana', 'San Juan Bautista', 'Colina',\n",
       "       'Costillares', 'Concepción', 'San Pascual', 'El Viso',\n",
       "       'Nueva España', 'Castilla', 'Bernabéu-Hispanoamérica',\n",
       "       'Prosperidad', 'Ciudad Jardín', 'Lavapiés-Embajadores', 'Opañel',\n",
       "       'Comillas', 'Abrantes', 'San Isidro', 'Vista Alegre',\n",
       "       'Pau de Carabanchel', 'Puerta Bonita', 'Buena Vista',\n",
       "       'Huertas-Cortes', 'Malasaña-Universidad', 'Chueca-Justicia',\n",
       "       'Palacio', 'Sol', 'Recoletos', 'Goya', 'Lista', 'Castellana',\n",
       "       'Guindalera', 'Fuente del Berro', 'Imperial', 'Chopera', 'Acacias',\n",
       "       'Palos de Moguer', 'Legazpi', 'Delicias', 'Alameda de Osuna',\n",
       "       'Casco Histórico de Barajas', 'Campo de las Naciones-Corralejos',\n",
       "       'Timón'], dtype=object)"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/plain": [
       "array(['flat', 'duplex', 'attic'], dtype=object)"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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>sq_mt_built</th>\n",
       "      <th>n_rooms</th>\n",
       "      <th>n_bathrooms</th>\n",
       "      <th>has_lift</th>\n",
       "      <th>has_parking</th>\n",
       "      <th>is_exterior</th>\n",
       "      <th>floor_0</th>\n",
       "      <th>floor_1</th>\n",
       "      <th>floor_2</th>\n",
       "      <th>floor_3</th>\n",
       "      <th>floor_4</th>\n",
       "      <th>floor_5</th>\n",
       "      <th>floor_6</th>\n",
       "      <th>floor_7</th>\n",
       "      <th>floor_8</th>\n",
       "      <th>floor_9</th>\n",
       "      <th>energy_bad</th>\n",
       "      <th>energy_good</th>\n",
       "      <th>htype_duplex</th>\n",
       "      <th>htype_flat</th>\n",
       "      <th>nbhood_12 de Octubre-Orcasur</th>\n",
       "      <th>nbhood_Acacias</th>\n",
       "      <th>nbhood_Adelfas</th>\n",
       "      <th>nbhood_Alameda de Osuna</th>\n",
       "      <th>nbhood_Almagro</th>\n",
       "      <th>nbhood_Almendrales</th>\n",
       "      <th>nbhood_Aluche</th>\n",
       "      <th>nbhood_Ambroz</th>\n",
       "      <th>nbhood_Apóstol Santiago</th>\n",
       "      <th>nbhood_Arapiles</th>\n",
       "      <th>nbhood_Aravaca</th>\n",
       "      <th>nbhood_Argüelles</th>\n",
       "      <th>nbhood_Arroyo del Fresno</th>\n",
       "      <th>nbhood_Bellas Vistas</th>\n",
       "      <th>nbhood_Bernabéu-Hispanoamérica</th>\n",
       "      <th>nbhood_Berruguete</th>\n",
       "      <th>nbhood_Buena Vista</th>\n",
       "      <th>nbhood_Butarque</th>\n",
       "      <th>nbhood_Campamento</th>\n",
       "      <th>nbhood_Campo de las Naciones-Corralejos</th>\n",
       "      <th>nbhood_Canillas</th>\n",
       "      <th>nbhood_Casa de Campo</th>\n",
       "      <th>nbhood_Casco Histórico de Barajas</th>\n",
       "      <th>nbhood_Casco Histórico de Vallecas</th>\n",
       "      <th>nbhood_Casco Histórico de Vicálvaro</th>\n",
       "      <th>nbhood_Castellana</th>\n",
       "      <th>nbhood_Castilla</th>\n",
       "      <th>nbhood_Chopera</th>\n",
       "      <th>nbhood_Chueca-Justicia</th>\n",
       "      <th>nbhood_Ciudad Jardín</th>\n",
       "      <th>nbhood_Ciudad Universitaria</th>\n",
       "      <th>nbhood_Colina</th>\n",
       "      <th>nbhood_Comillas</th>\n",
       "      <th>nbhood_Concepción</th>\n",
       "      <th>nbhood_Conde Orgaz-Piovera</th>\n",
       "      <th>nbhood_Costillares</th>\n",
       "      <th>nbhood_Cuatro Caminos</th>\n",
       "      <th>nbhood_Cuzco-Castillejos</th>\n",
       "      <th>nbhood_Delicias</th>\n",
       "      <th>nbhood_El Cañaveral - Los Berrocales</th>\n",
       "      <th>nbhood_El Plantío</th>\n",
       "      <th>nbhood_El Viso</th>\n",
       "      <th>nbhood_Ensanche de Vallecas - La Gavia</th>\n",
       "      <th>nbhood_Entrevías</th>\n",
       "      <th>nbhood_Estrella</th>\n",
       "      <th>nbhood_Fontarrón</th>\n",
       "      <th>nbhood_Fuente del Berro</th>\n",
       "      <th>nbhood_Fuentelarreina</th>\n",
       "      <th>nbhood_Gaztambide</th>\n",
       "      <th>nbhood_Goya</th>\n",
       "      <th>nbhood_Guindalera</th>\n",
       "      <th>nbhood_Huertas-Cortes</th>\n",
       "      <th>nbhood_Ibiza</th>\n",
       "      <th>nbhood_Imperial</th>\n",
       "      <th>nbhood_Jerónimos</th>\n",
       "      <th>nbhood_La Paz</th>\n",
       "      <th>nbhood_Las Tablas</th>\n",
       "      <th>nbhood_Lavapiés-Embajadores</th>\n",
       "      <th>nbhood_Legazpi</th>\n",
       "      <th>nbhood_Lista</th>\n",
       "      <th>nbhood_Los Cármenes</th>\n",
       "      <th>nbhood_Los Rosales</th>\n",
       "      <th>nbhood_Los Ángeles</th>\n",
       "      <th>nbhood_Lucero</th>\n",
       "      <th>nbhood_Malasaña-Universidad</th>\n",
       "      <th>nbhood_Marroquina</th>\n",
       "      <th>nbhood_Media Legua</th>\n",
       "      <th>nbhood_Mirasierra</th>\n",
       "      <th>nbhood_Montecarmelo</th>\n",
       "      <th>nbhood_Moscardó</th>\n",
       "      <th>nbhood_Niño Jesús</th>\n",
       "      <th>nbhood_Nueva España</th>\n",
       "      <th>nbhood_Nuevos Ministerios-Ríos Rosas</th>\n",
       "      <th>nbhood_Numancia</th>\n",
       "      <th>nbhood_Opañel</th>\n",
       "      <th>nbhood_Orcasitas</th>\n",
       "      <th>nbhood_Pacífico</th>\n",
       "      <th>nbhood_Palacio</th>\n",
       "      <th>nbhood_Palomas</th>\n",
       "      <th>nbhood_Palomeras Bajas</th>\n",
       "      <th>nbhood_Palomeras sureste</th>\n",
       "      <th>nbhood_Palos de Moguer</th>\n",
       "      <th>nbhood_Pau de Carabanchel</th>\n",
       "      <th>nbhood_Peñagrande</th>\n",
       "      <th>nbhood_Pilar</th>\n",
       "      <th>nbhood_Pinar del Rey</th>\n",
       "      <th>nbhood_Portazgo</th>\n",
       "      <th>nbhood_Pradolongo</th>\n",
       "      <th>nbhood_Prosperidad</th>\n",
       "      <th>nbhood_Pueblo Nuevo</th>\n",
       "      <th>nbhood_Puerta Bonita</th>\n",
       "      <th>nbhood_Puerta del Ángel</th>\n",
       "      <th>nbhood_Quintana</th>\n",
       "      <th>nbhood_Recoletos</th>\n",
       "      <th>nbhood_San Andrés</th>\n",
       "      <th>nbhood_San Cristóbal</th>\n",
       "      <th>nbhood_San Diego</th>\n",
       "      <th>nbhood_San Fermín</th>\n",
       "      <th>nbhood_San Isidro</th>\n",
       "      <th>nbhood_San Juan Bautista</th>\n",
       "      <th>nbhood_San Pascual</th>\n",
       "      <th>nbhood_Sanchinarro</th>\n",
       "      <th>nbhood_Santa Eugenia</th>\n",
       "      <th>nbhood_Sol</th>\n",
       "      <th>nbhood_Timón</th>\n",
       "      <th>nbhood_Trafalgar</th>\n",
       "      <th>nbhood_Tres Olivos - Valverde</th>\n",
       "      <th>nbhood_Valdeacederas</th>\n",
       "      <th>nbhood_Valdebebas - Valdefuentes</th>\n",
       "      <th>nbhood_Valdebernardo - Valderribas</th>\n",
       "      <th>nbhood_Valdemarín</th>\n",
       "      <th>nbhood_Valdezarza</th>\n",
       "      <th>nbhood_Vallehermoso</th>\n",
       "      <th>nbhood_Ventas</th>\n",
       "      <th>nbhood_Ventilla-Almenara</th>\n",
       "      <th>nbhood_Vinateros</th>\n",
       "      <th>nbhood_Virgen del Cortijo - Manoteras</th>\n",
       "      <th>nbhood_Vista Alegre</th>\n",
       "      <th>nbhood_Zofío</th>\n",
       "      <th>nbhood_Águilas</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>64</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</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",
       "      <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>1</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>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>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>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>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>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>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>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>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>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>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",
       "      <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>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>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>70</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</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",
       "      <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",
       "      <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>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>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>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>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>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>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",
       "      <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>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>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>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>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>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>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>94</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</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>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</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>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>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>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>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>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>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>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>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>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>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",
       "      <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>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>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>64</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</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>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</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>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>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>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>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>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>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>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>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>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>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",
       "      <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>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>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>108</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</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",
       "      <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",
       "      <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>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>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>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>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>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>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",
       "      <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>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>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>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>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>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>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",
       "      <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",
       "      <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",
       "      <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",
       "      <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",
       "      <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",
       "      <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>17321</th>\n",
       "      <td>88</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</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>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</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>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>0</td>\n",
       "      <td>1</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>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>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>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>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>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>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>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>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>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>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>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17322</th>\n",
       "      <td>99</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</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>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</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>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>0</td>\n",
       "      <td>1</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>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>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>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>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>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>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>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>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>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>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>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17323</th>\n",
       "      <td>78</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</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",
       "      <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>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>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>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</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>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>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>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>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>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>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>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>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>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>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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17324</th>\n",
       "      <td>96</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</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",
       "      <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",
       "      <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>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",
       "      <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>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>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>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>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>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>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>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>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>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>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>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17325</th>\n",
       "      <td>175</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</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",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</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>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>0</td>\n",
       "      <td>1</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>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>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>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>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>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>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>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>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>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>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>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>17326 rows × 140 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       sq_mt_built  n_rooms  n_bathrooms  has_lift  has_parking  is_exterior  \\\n",
       "0               64        2            1         0            0            1   \n",
       "1               70        3            1         1            0            1   \n",
       "2               94        2            2         1            0            1   \n",
       "3               64        2            1         1            0            1   \n",
       "4              108        2            2         1            1            1   \n",
       "...            ...      ...          ...       ...          ...          ...   \n",
       "17321           88        2            2         1            1            1   \n",
       "17322           99        2            2         1            1            1   \n",
       "17323           78        2            2         1            1            1   \n",
       "17324           96        2            2         1            1            1   \n",
       "17325          175        4            2         0            1            1   \n",
       "\n",
       "       floor_0  floor_1  floor_2  floor_3  floor_4  floor_5  floor_6  floor_7  \\\n",
       "0            0        0        0        1        0        0        0        0   \n",
       "1            0        0        0        0        1        0        0        0   \n",
       "2            0        1        0        0        0        0        0        0   \n",
       "3            1        0        0        0        0        0        0        0   \n",
       "4            0        0        0        0        1        0        0        0   \n",
       "...        ...      ...      ...      ...      ...      ...      ...      ...   \n",
       "17321        0        1        0        0        0        0        0        0   \n",
       "17322        0        1        0        0        0        0        0        0   \n",
       "17323        0        0        0        0        1        0        0        0   \n",
       "17324        0        0        0        1        0        0        0        0   \n",
       "17325        1        0        0        0        0        0        0        0   \n",
       "\n",
       "       floor_8  floor_9  energy_bad  energy_good  htype_duplex  htype_flat  \\\n",
       "0            0        0           0            1             0           1   \n",
       "1            0        0           0            0             0           1   \n",
       "2            0        0           0            0             0           1   \n",
       "3            0        0           0            0             0           1   \n",
       "4            0        0           0            0             0           1   \n",
       "...        ...      ...         ...          ...           ...         ...   \n",
       "17321        0        0           0            0             0           1   \n",
       "17322        0        0           0            0             0           1   \n",
       "17323        0        0           0            0             0           0   \n",
       "17324        0        0           0            0             0           1   \n",
       "17325        0        0           1            0             0           1   \n",
       "\n",
       "       nbhood_12 de Octubre-Orcasur  nbhood_Acacias  nbhood_Adelfas  \\\n",
       "0                                 0               0               0   \n",
       "1                                 0               0               0   \n",
       "2                                 0               0               0   \n",
       "3                                 0               0               0   \n",
       "4                                 0               0               0   \n",
       "...                             ...             ...             ...   \n",
       "17321                             0               0               0   \n",
       "17322                             0               0               0   \n",
       "17323                             0               0               0   \n",
       "17324                             0               0               0   \n",
       "17325                             0               0               0   \n",
       "\n",
       "       nbhood_Alameda de Osuna  nbhood_Almagro  nbhood_Almendrales  \\\n",
       "0                            0               0                   0   \n",
       "1                            0               0                   0   \n",
       "2                            0               0                   0   \n",
       "3                            0               0                   0   \n",
       "4                            0               0                   0   \n",
       "...                        ...             ...                 ...   \n",
       "17321                        0               0                   0   \n",
       "17322                        0               0                   0   \n",
       "17323                        0               0                   0   \n",
       "17324                        0               0                   0   \n",
       "17325                        0               0                   0   \n",
       "\n",
       "       nbhood_Aluche  nbhood_Ambroz  nbhood_Apóstol Santiago  nbhood_Arapiles  \\\n",
       "0                  0              0                        0                0   \n",
       "1                  0              0                        0                0   \n",
       "2                  0              0                        0                0   \n",
       "3                  0              0                        0                0   \n",
       "4                  0              0                        0                0   \n",
       "...              ...            ...                      ...              ...   \n",
       "17321              0              0                        0                0   \n",
       "17322              0              0                        0                0   \n",
       "17323              0              0                        0                0   \n",
       "17324              0              0                        0                0   \n",
       "17325              0              0                        0                0   \n",
       "\n",
       "       nbhood_Aravaca  nbhood_Argüelles  nbhood_Arroyo del Fresno  \\\n",
       "0                   0                 0                         0   \n",
       "1                   0                 0                         0   \n",
       "2                   0                 0                         0   \n",
       "3                   0                 0                         0   \n",
       "4                   0                 0                         0   \n",
       "...               ...               ...                       ...   \n",
       "17321               0                 0                         0   \n",
       "17322               0                 0                         0   \n",
       "17323               0                 0                         0   \n",
       "17324               0                 0                         0   \n",
       "17325               0                 0                         0   \n",
       "\n",
       "       nbhood_Bellas Vistas  nbhood_Bernabéu-Hispanoamérica  \\\n",
       "0                         0                               0   \n",
       "1                         0                               0   \n",
       "2                         0                               0   \n",
       "3                         0                               0   \n",
       "4                         0                               0   \n",
       "...                     ...                             ...   \n",
       "17321                     0                               0   \n",
       "17322                     0                               0   \n",
       "17323                     0                               0   \n",
       "17324                     0                               0   \n",
       "17325                     0                               0   \n",
       "\n",
       "       nbhood_Berruguete  nbhood_Buena Vista  nbhood_Butarque  \\\n",
       "0                      0                   0                0   \n",
       "1                      0                   0                0   \n",
       "2                      0                   0                0   \n",
       "3                      0                   0                0   \n",
       "4                      0                   0                0   \n",
       "...                  ...                 ...              ...   \n",
       "17321                  0                   0                0   \n",
       "17322                  0                   0                0   \n",
       "17323                  0                   0                0   \n",
       "17324                  0                   0                0   \n",
       "17325                  0                   0                0   \n",
       "\n",
       "       nbhood_Campamento  nbhood_Campo de las Naciones-Corralejos  \\\n",
       "0                      0                                        0   \n",
       "1                      0                                        0   \n",
       "2                      0                                        0   \n",
       "3                      0                                        0   \n",
       "4                      0                                        0   \n",
       "...                  ...                                      ...   \n",
       "17321                  0                                        1   \n",
       "17322                  0                                        1   \n",
       "17323                  0                                        0   \n",
       "17324                  0                                        1   \n",
       "17325                  0                                        1   \n",
       "\n",
       "       nbhood_Canillas  nbhood_Casa de Campo  \\\n",
       "0                    0                     0   \n",
       "1                    0                     0   \n",
       "2                    0                     0   \n",
       "3                    0                     0   \n",
       "4                    0                     0   \n",
       "...                ...                   ...   \n",
       "17321                0                     0   \n",
       "17322                0                     0   \n",
       "17323                0                     0   \n",
       "17324                0                     0   \n",
       "17325                0                     0   \n",
       "\n",
       "       nbhood_Casco Histórico de Barajas  nbhood_Casco Histórico de Vallecas  \\\n",
       "0                                      0                                   0   \n",
       "1                                      0                                   0   \n",
       "2                                      0                                   0   \n",
       "3                                      0                                   0   \n",
       "4                                      0                                   0   \n",
       "...                                  ...                                 ...   \n",
       "17321                                  0                                   0   \n",
       "17322                                  0                                   0   \n",
       "17323                                  1                                   0   \n",
       "17324                                  0                                   0   \n",
       "17325                                  0                                   0   \n",
       "\n",
       "       nbhood_Casco Histórico de Vicálvaro  nbhood_Castellana  \\\n",
       "0                                        0                  0   \n",
       "1                                        0                  0   \n",
       "2                                        0                  0   \n",
       "3                                        0                  0   \n",
       "4                                        0                  0   \n",
       "...                                    ...                ...   \n",
       "17321                                    0                  0   \n",
       "17322                                    0                  0   \n",
       "17323                                    0                  0   \n",
       "17324                                    0                  0   \n",
       "17325                                    0                  0   \n",
       "\n",
       "       nbhood_Castilla  nbhood_Chopera  nbhood_Chueca-Justicia  \\\n",
       "0                    0               0                       0   \n",
       "1                    0               0                       0   \n",
       "2                    0               0                       0   \n",
       "3                    0               0                       0   \n",
       "4                    0               0                       0   \n",
       "...                ...             ...                     ...   \n",
       "17321                0               0                       0   \n",
       "17322                0               0                       0   \n",
       "17323                0               0                       0   \n",
       "17324                0               0                       0   \n",
       "17325                0               0                       0   \n",
       "\n",
       "       nbhood_Ciudad Jardín  nbhood_Ciudad Universitaria  nbhood_Colina  \\\n",
       "0                         0                            0              0   \n",
       "1                         0                            0              0   \n",
       "2                         0                            0              0   \n",
       "3                         0                            0              0   \n",
       "4                         0                            0              0   \n",
       "...                     ...                          ...            ...   \n",
       "17321                     0                            0              0   \n",
       "17322                     0                            0              0   \n",
       "17323                     0                            0              0   \n",
       "17324                     0                            0              0   \n",
       "17325                     0                            0              0   \n",
       "\n",
       "       nbhood_Comillas  nbhood_Concepción  nbhood_Conde Orgaz-Piovera  \\\n",
       "0                    0                  0                           0   \n",
       "1                    0                  0                           0   \n",
       "2                    0                  0                           0   \n",
       "3                    0                  0                           0   \n",
       "4                    0                  0                           0   \n",
       "...                ...                ...                         ...   \n",
       "17321                0                  0                           0   \n",
       "17322                0                  0                           0   \n",
       "17323                0                  0                           0   \n",
       "17324                0                  0                           0   \n",
       "17325                0                  0                           0   \n",
       "\n",
       "       nbhood_Costillares  nbhood_Cuatro Caminos  nbhood_Cuzco-Castillejos  \\\n",
       "0                       0                      0                         0   \n",
       "1                       0                      0                         0   \n",
       "2                       0                      0                         0   \n",
       "3                       0                      0                         0   \n",
       "4                       0                      0                         0   \n",
       "...                   ...                    ...                       ...   \n",
       "17321                   0                      0                         0   \n",
       "17322                   0                      0                         0   \n",
       "17323                   0                      0                         0   \n",
       "17324                   0                      0                         0   \n",
       "17325                   0                      0                         0   \n",
       "\n",
       "       nbhood_Delicias  nbhood_El Cañaveral - Los Berrocales  \\\n",
       "0                    0                                     0   \n",
       "1                    0                                     0   \n",
       "2                    0                                     0   \n",
       "3                    0                                     0   \n",
       "4                    0                                     0   \n",
       "...                ...                                   ...   \n",
       "17321                0                                     0   \n",
       "17322                0                                     0   \n",
       "17323                0                                     0   \n",
       "17324                0                                     0   \n",
       "17325                0                                     0   \n",
       "\n",
       "       nbhood_El Plantío  nbhood_El Viso  \\\n",
       "0                      0               0   \n",
       "1                      0               0   \n",
       "2                      0               0   \n",
       "3                      0               0   \n",
       "4                      0               0   \n",
       "...                  ...             ...   \n",
       "17321                  0               0   \n",
       "17322                  0               0   \n",
       "17323                  0               0   \n",
       "17324                  0               0   \n",
       "17325                  0               0   \n",
       "\n",
       "       nbhood_Ensanche de Vallecas - La Gavia  nbhood_Entrevías  \\\n",
       "0                                           0                 0   \n",
       "1                                           0                 0   \n",
       "2                                           0                 0   \n",
       "3                                           0                 0   \n",
       "4                                           0                 0   \n",
       "...                                       ...               ...   \n",
       "17321                                       0                 0   \n",
       "17322                                       0                 0   \n",
       "17323                                       0                 0   \n",
       "17324                                       0                 0   \n",
       "17325                                       0                 0   \n",
       "\n",
       "       nbhood_Estrella  nbhood_Fontarrón  nbhood_Fuente del Berro  \\\n",
       "0                    0                 0                        0   \n",
       "1                    0                 0                        0   \n",
       "2                    0                 0                        0   \n",
       "3                    0                 0                        0   \n",
       "4                    0                 0                        0   \n",
       "...                ...               ...                      ...   \n",
       "17321                0                 0                        0   \n",
       "17322                0                 0                        0   \n",
       "17323                0                 0                        0   \n",
       "17324                0                 0                        0   \n",
       "17325                0                 0                        0   \n",
       "\n",
       "       nbhood_Fuentelarreina  nbhood_Gaztambide  nbhood_Goya  \\\n",
       "0                          0                  0            0   \n",
       "1                          0                  0            0   \n",
       "2                          0                  0            0   \n",
       "3                          0                  0            0   \n",
       "4                          0                  0            0   \n",
       "...                      ...                ...          ...   \n",
       "17321                      0                  0            0   \n",
       "17322                      0                  0            0   \n",
       "17323                      0                  0            0   \n",
       "17324                      0                  0            0   \n",
       "17325                      0                  0            0   \n",
       "\n",
       "       nbhood_Guindalera  nbhood_Huertas-Cortes  nbhood_Ibiza  \\\n",
       "0                      0                      0             0   \n",
       "1                      0                      0             0   \n",
       "2                      0                      0             0   \n",
       "3                      0                      0             0   \n",
       "4                      0                      0             0   \n",
       "...                  ...                    ...           ...   \n",
       "17321                  0                      0             0   \n",
       "17322                  0                      0             0   \n",
       "17323                  0                      0             0   \n",
       "17324                  0                      0             0   \n",
       "17325                  0                      0             0   \n",
       "\n",
       "       nbhood_Imperial  nbhood_Jerónimos  nbhood_La Paz  nbhood_Las Tablas  \\\n",
       "0                    0                 0              0                  0   \n",
       "1                    0                 0              0                  0   \n",
       "2                    0                 0              0                  0   \n",
       "3                    0                 0              0                  0   \n",
       "4                    0                 0              0                  0   \n",
       "...                ...               ...            ...                ...   \n",
       "17321                0                 0              0                  0   \n",
       "17322                0                 0              0                  0   \n",
       "17323                0                 0              0                  0   \n",
       "17324                0                 0              0                  0   \n",
       "17325                0                 0              0                  0   \n",
       "\n",
       "       nbhood_Lavapiés-Embajadores  nbhood_Legazpi  nbhood_Lista  \\\n",
       "0                                0               0             0   \n",
       "1                                0               0             0   \n",
       "2                                0               0             0   \n",
       "3                                0               0             0   \n",
       "4                                0               0             0   \n",
       "...                            ...             ...           ...   \n",
       "17321                            0               0             0   \n",
       "17322                            0               0             0   \n",
       "17323                            0               0             0   \n",
       "17324                            0               0             0   \n",
       "17325                            0               0             0   \n",
       "\n",
       "       nbhood_Los Cármenes  nbhood_Los Rosales  nbhood_Los Ángeles  \\\n",
       "0                        0                   0                   0   \n",
       "1                        0                   0                   1   \n",
       "2                        0                   0                   0   \n",
       "3                        0                   0                   0   \n",
       "4                        0                   1                   0   \n",
       "...                    ...                 ...                 ...   \n",
       "17321                    0                   0                   0   \n",
       "17322                    0                   0                   0   \n",
       "17323                    0                   0                   0   \n",
       "17324                    0                   0                   0   \n",
       "17325                    0                   0                   0   \n",
       "\n",
       "       nbhood_Lucero  nbhood_Malasaña-Universidad  nbhood_Marroquina  \\\n",
       "0                  0                            0                  0   \n",
       "1                  0                            0                  0   \n",
       "2                  0                            0                  0   \n",
       "3                  0                            0                  0   \n",
       "4                  0                            0                  0   \n",
       "...              ...                          ...                ...   \n",
       "17321              0                            0                  0   \n",
       "17322              0                            0                  0   \n",
       "17323              0                            0                  0   \n",
       "17324              0                            0                  0   \n",
       "17325              0                            0                  0   \n",
       "\n",
       "       nbhood_Media Legua  nbhood_Mirasierra  nbhood_Montecarmelo  \\\n",
       "0                       0                  0                    0   \n",
       "1                       0                  0                    0   \n",
       "2                       0                  0                    0   \n",
       "3                       0                  0                    0   \n",
       "4                       0                  0                    0   \n",
       "...                   ...                ...                  ...   \n",
       "17321                   0                  0                    0   \n",
       "17322                   0                  0                    0   \n",
       "17323                   0                  0                    0   \n",
       "17324                   0                  0                    0   \n",
       "17325                   0                  0                    0   \n",
       "\n",
       "       nbhood_Moscardó  nbhood_Niño Jesús  nbhood_Nueva España  \\\n",
       "0                    0                  0                    0   \n",
       "1                    0                  0                    0   \n",
       "2                    0                  0                    0   \n",
       "3                    0                  0                    0   \n",
       "4                    0                  0                    0   \n",
       "...                ...                ...                  ...   \n",
       "17321                0                  0                    0   \n",
       "17322                0                  0                    0   \n",
       "17323                0                  0                    0   \n",
       "17324                0                  0                    0   \n",
       "17325                0                  0                    0   \n",
       "\n",
       "       nbhood_Nuevos Ministerios-Ríos Rosas  nbhood_Numancia  nbhood_Opañel  \\\n",
       "0                                         0                0              0   \n",
       "1                                         0                0              0   \n",
       "2                                         0                0              0   \n",
       "3                                         0                0              0   \n",
       "4                                         0                0              0   \n",
       "...                                     ...              ...            ...   \n",
       "17321                                     0                0              0   \n",
       "17322                                     0                0              0   \n",
       "17323                                     0                0              0   \n",
       "17324                                     0                0              0   \n",
       "17325                                     0                0              0   \n",
       "\n",
       "       nbhood_Orcasitas  nbhood_Pacífico  nbhood_Palacio  nbhood_Palomas  \\\n",
       "0                     0                0               0               0   \n",
       "1                     0                0               0               0   \n",
       "2                     0                0               0               0   \n",
       "3                     0                0               0               0   \n",
       "4                     0                0               0               0   \n",
       "...                 ...              ...             ...             ...   \n",
       "17321                 0                0               0               0   \n",
       "17322                 0                0               0               0   \n",
       "17323                 0                0               0               0   \n",
       "17324                 0                0               0               0   \n",
       "17325                 0                0               0               0   \n",
       "\n",
       "       nbhood_Palomeras Bajas  nbhood_Palomeras sureste  \\\n",
       "0                           0                         0   \n",
       "1                           0                         0   \n",
       "2                           0                         0   \n",
       "3                           0                         0   \n",
       "4                           0                         0   \n",
       "...                       ...                       ...   \n",
       "17321                       0                         0   \n",
       "17322                       0                         0   \n",
       "17323                       0                         0   \n",
       "17324                       0                         0   \n",
       "17325                       0                         0   \n",
       "\n",
       "       nbhood_Palos de Moguer  nbhood_Pau de Carabanchel  nbhood_Peñagrande  \\\n",
       "0                           0                          0                  0   \n",
       "1                           0                          0                  0   \n",
       "2                           0                          0                  0   \n",
       "3                           0                          0                  0   \n",
       "4                           0                          0                  0   \n",
       "...                       ...                        ...                ...   \n",
       "17321                       0                          0                  0   \n",
       "17322                       0                          0                  0   \n",
       "17323                       0                          0                  0   \n",
       "17324                       0                          0                  0   \n",
       "17325                       0                          0                  0   \n",
       "\n",
       "       nbhood_Pilar  nbhood_Pinar del Rey  nbhood_Portazgo  nbhood_Pradolongo  \\\n",
       "0                 0                     0                0                  0   \n",
       "1                 0                     0                0                  0   \n",
       "2                 0                     0                0                  0   \n",
       "3                 0                     0                0                  0   \n",
       "4                 0                     0                0                  0   \n",
       "...             ...                   ...              ...                ...   \n",
       "17321             0                     0                0                  0   \n",
       "17322             0                     0                0                  0   \n",
       "17323             0                     0                0                  0   \n",
       "17324             0                     0                0                  0   \n",
       "17325             0                     0                0                  0   \n",
       "\n",
       "       nbhood_Prosperidad  nbhood_Pueblo Nuevo  nbhood_Puerta Bonita  \\\n",
       "0                       0                    0                     0   \n",
       "1                       0                    0                     0   \n",
       "2                       0                    0                     0   \n",
       "3                       0                    0                     0   \n",
       "4                       0                    0                     0   \n",
       "...                   ...                  ...                   ...   \n",
       "17321                   0                    0                     0   \n",
       "17322                   0                    0                     0   \n",
       "17323                   0                    0                     0   \n",
       "17324                   0                    0                     0   \n",
       "17325                   0                    0                     0   \n",
       "\n",
       "       nbhood_Puerta del Ángel  nbhood_Quintana  nbhood_Recoletos  \\\n",
       "0                            0                0                 0   \n",
       "1                            0                0                 0   \n",
       "2                            0                0                 0   \n",
       "3                            0                0                 0   \n",
       "4                            0                0                 0   \n",
       "...                        ...              ...               ...   \n",
       "17321                        0                0                 0   \n",
       "17322                        0                0                 0   \n",
       "17323                        0                0                 0   \n",
       "17324                        0                0                 0   \n",
       "17325                        0                0                 0   \n",
       "\n",
       "       nbhood_San Andrés  nbhood_San Cristóbal  nbhood_San Diego  \\\n",
       "0                      0                     1                 0   \n",
       "1                      0                     0                 0   \n",
       "2                      1                     0                 0   \n",
       "3                      1                     0                 0   \n",
       "4                      0                     0                 0   \n",
       "...                  ...                   ...               ...   \n",
       "17321                  0                     0                 0   \n",
       "17322                  0                     0                 0   \n",
       "17323                  0                     0                 0   \n",
       "17324                  0                     0                 0   \n",
       "17325                  0                     0                 0   \n",
       "\n",
       "       nbhood_San Fermín  nbhood_San Isidro  nbhood_San Juan Bautista  \\\n",
       "0                      0                  0                         0   \n",
       "1                      0                  0                         0   \n",
       "2                      0                  0                         0   \n",
       "3                      0                  0                         0   \n",
       "4                      0                  0                         0   \n",
       "...                  ...                ...                       ...   \n",
       "17321                  0                  0                         0   \n",
       "17322                  0                  0                         0   \n",
       "17323                  0                  0                         0   \n",
       "17324                  0                  0                         0   \n",
       "17325                  0                  0                         0   \n",
       "\n",
       "       nbhood_San Pascual  nbhood_Sanchinarro  nbhood_Santa Eugenia  \\\n",
       "0                       0                   0                     0   \n",
       "1                       0                   0                     0   \n",
       "2                       0                   0                     0   \n",
       "3                       0                   0                     0   \n",
       "4                       0                   0                     0   \n",
       "...                   ...                 ...                   ...   \n",
       "17321                   0                   0                     0   \n",
       "17322                   0                   0                     0   \n",
       "17323                   0                   0                     0   \n",
       "17324                   0                   0                     0   \n",
       "17325                   0                   0                     0   \n",
       "\n",
       "       nbhood_Sol  nbhood_Timón  nbhood_Trafalgar  \\\n",
       "0               0             0                 0   \n",
       "1               0             0                 0   \n",
       "2               0             0                 0   \n",
       "3               0             0                 0   \n",
       "4               0             0                 0   \n",
       "...           ...           ...               ...   \n",
       "17321           0             0                 0   \n",
       "17322           0             0                 0   \n",
       "17323           0             0                 0   \n",
       "17324           0             0                 0   \n",
       "17325           0             0                 0   \n",
       "\n",
       "       nbhood_Tres Olivos - Valverde  nbhood_Valdeacederas  \\\n",
       "0                                  0                     0   \n",
       "1                                  0                     0   \n",
       "2                                  0                     0   \n",
       "3                                  0                     0   \n",
       "4                                  0                     0   \n",
       "...                              ...                   ...   \n",
       "17321                              0                     0   \n",
       "17322                              0                     0   \n",
       "17323                              0                     0   \n",
       "17324                              0                     0   \n",
       "17325                              0                     0   \n",
       "\n",
       "       nbhood_Valdebebas - Valdefuentes  nbhood_Valdebernardo - Valderribas  \\\n",
       "0                                     0                                   0   \n",
       "1                                     0                                   0   \n",
       "2                                     0                                   0   \n",
       "3                                     0                                   0   \n",
       "4                                     0                                   0   \n",
       "...                                 ...                                 ...   \n",
       "17321                                 0                                   0   \n",
       "17322                                 0                                   0   \n",
       "17323                                 0                                   0   \n",
       "17324                                 0                                   0   \n",
       "17325                                 0                                   0   \n",
       "\n",
       "       nbhood_Valdemarín  nbhood_Valdezarza  nbhood_Vallehermoso  \\\n",
       "0                      0                  0                    0   \n",
       "1                      0                  0                    0   \n",
       "2                      0                  0                    0   \n",
       "3                      0                  0                    0   \n",
       "4                      0                  0                    0   \n",
       "...                  ...                ...                  ...   \n",
       "17321                  0                  0                    0   \n",
       "17322                  0                  0                    0   \n",
       "17323                  0                  0                    0   \n",
       "17324                  0                  0                    0   \n",
       "17325                  0                  0                    0   \n",
       "\n",
       "       nbhood_Ventas  nbhood_Ventilla-Almenara  nbhood_Vinateros  \\\n",
       "0                  0                         0                 0   \n",
       "1                  0                         0                 0   \n",
       "2                  0                         0                 0   \n",
       "3                  0                         0                 0   \n",
       "4                  0                         0                 0   \n",
       "...              ...                       ...               ...   \n",
       "17321              0                         0                 0   \n",
       "17322              0                         0                 0   \n",
       "17323              0                         0                 0   \n",
       "17324              0                         0                 0   \n",
       "17325              0                         0                 0   \n",
       "\n",
       "       nbhood_Virgen del Cortijo - Manoteras  nbhood_Vista Alegre  \\\n",
       "0                                          0                    0   \n",
       "1                                          0                    0   \n",
       "2                                          0                    0   \n",
       "3                                          0                    0   \n",
       "4                                          0                    0   \n",
       "...                                      ...                  ...   \n",
       "17321                                      0                    0   \n",
       "17322                                      0                    0   \n",
       "17323                                      0                    0   \n",
       "17324                                      0                    0   \n",
       "17325                                      0                    0   \n",
       "\n",
       "       nbhood_Zofío  nbhood_Águilas  \n",
       "0                 0               0  \n",
       "1                 0               0  \n",
       "2                 0               0  \n",
       "3                 0               0  \n",
       "4                 0               0  \n",
       "...             ...             ...  \n",
       "17321             0               0  \n",
       "17322             0               0  \n",
       "17323             0               0  \n",
       "17324             0               0  \n",
       "17325             0               0  \n",
       "\n",
       "[17326 rows x 140 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/plain": [
       "sq_mt_built                              int64\n",
       "n_rooms                                  int64\n",
       "n_bathrooms                              int64\n",
       "has_lift                                 uint8\n",
       "has_parking                              uint8\n",
       "                                         ...  \n",
       "nbhood_Vinateros                         uint8\n",
       "nbhood_Virgen del Cortijo - Manoteras    uint8\n",
       "nbhood_Vista Alegre                      uint8\n",
       "nbhood_Zofío                             uint8\n",
       "nbhood_Águilas                           uint8\n",
       "Length: 140, dtype: object"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "display(X['floor'].unique())\n",
    "floor_dummies = pd.get_dummies(X['floor'], prefix='floor').drop('floor_other', axis='columns')\n",
    "\n",
    "display(X['energy_certificate'].unique())\n",
    "energy_dummies = pd.get_dummies(X['energy_certificate'], prefix='energy').drop('energy_unknown', axis='columns')\n",
    "\n",
    "display(X['neighborhood'].unique())\n",
    "neighborhood_dummies = pd.get_dummies(X['neighborhood'], prefix='nbhood').drop('nbhood_Abrantes', axis='columns')\n",
    "\n",
    "display(X['house_type'].unique())\n",
    "house_dummies = pd.get_dummies(X['house_type'], prefix='htype').drop('htype_attic', axis='columns')\n",
    "\n",
    "X = X.drop(['floor', 'energy_certificate', 'neighborhood', 'house_type'], axis='columns')\n",
    "X = pd.concat([X, floor_dummies, energy_dummies, house_dummies, neighborhood_dummies], axis='columns')\n",
    "\n",
    "X['has_lift'] = X['has_lift'].astype('uint8')\n",
    "X['has_parking'] = X['has_parking'].astype('uint8')\n",
    "X['is_exterior'] = X['is_exterior'].astype('uint8')\n",
    "\n",
    "display(X)\n",
    "display(X.dtypes)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "165205b6-fabd-4d6a-8d59-39c27f50895b",
   "metadata": {},
   "outputs": [],
   "source": [
    "import json\n",
    "\n",
    "with open(\"data/cols.json\", 'w') as f:\n",
    "    json.dump(list(X.columns), f, ensure_ascii=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a5e9cd5c",
   "metadata": {
    "tags": []
   },
   "source": [
    "## Select best model"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "795dc2d9",
   "metadata": {},
   "source": [
    "### Import models"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "964d51ca",
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.linear_model import LinearRegression\n",
    "from sklearn.linear_model import SGDRegressor\n",
    "from sklearn.kernel_ridge import KernelRidge\n",
    "from sklearn.linear_model import ElasticNet\n",
    "from sklearn.linear_model import BayesianRidge\n",
    "from sklearn.ensemble import GradientBoostingRegressor\n",
    "from sklearn.svm import SVR"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a3588669",
   "metadata": {},
   "source": [
    "### Perform GridSearchCV"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "86d21a71-bda6-4f7c-b35f-51e91fc103b5",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "from sklearn.model_selection import GridSearchCV, KFold\n",
    "import traceback\n",
    "\n",
    "model_params = {\n",
    "    'linear_regression': {\n",
    "        'model': LinearRegression(),\n",
    "        'params': {}\n",
    "    },\n",
    "    'sgd_reg': {\n",
    "        'model': SGDRegressor(),\n",
    "        'params': {\n",
    "            'alpha': np.logspace(-4, -2, 3),\n",
    "            'eta0': np.logspace(-5, -3, 3)\n",
    "        }\n",
    "    },\n",
    "    'kernel_ridge': {\n",
    "        'model': KernelRidge(),\n",
    "        'params': {\n",
    "            'alpha': np.logspace(-3, -1, 3),\n",
    "            'kernel': ['rbf']\n",
    "        }\n",
    "    },\n",
    "    'elastic_net': {\n",
    "        'model': ElasticNet(),\n",
    "        'params': {\n",
    "            'alpha': np.logspace(-5, -2, 4),\n",
    "            'l1_ratio': np.linspace(0, 1, 5),\n",
    "            'selection': ['cyclic']\n",
    "        }\n",
    "    },\n",
    "    'bayesian_ridge': {\n",
    "        'model': BayesianRidge(),\n",
    "        'params': {\n",
    "            'alpha_1': np.logspace(-6, -5, 2),\n",
    "            'alpha_2': np.logspace(-7, -6, 2),\n",
    "            'lambda_1': np.logspace(-7, -6, 2),\n",
    "            'lambda_2': np.logspace(-7, -6, 2)\n",
    "        }\n",
    "    },\n",
    "    'gb_reg': {\n",
    "        'model': GradientBoostingRegressor(),\n",
    "        'params': {\n",
    "            'learning_rate': [0.05, 0.09, 0.5, 0.9],\n",
    "            'max_depth': [5, 10, 20],\n",
    "            'min_samples_split': [4, 16],\n",
    "            'min_samples_leaf': [2, 4]\n",
    "        }\n",
    "    },\n",
    "    'svm': {\n",
    "        'model': SVR(),\n",
    "        'params': {\n",
    "            'kernel': ['linear', 'poly'],\n",
    "            'gamma': ['scale', 'auto'],\n",
    "            'C': np.logspace(0, 1, 2)\n",
    "        }\n",
    "    }\n",
    "}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "4f1d1683-eaa9-45a9-8de3-7cc225113964",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "scores_buy = []\n",
    "for model, attrs in model_params.items():\n",
    "    try:\n",
    "        reg = GridSearchCV(attrs['model'], attrs['params'], cv=KFold(shuffle=True), verbose=10)\n",
    "        reg.fit(X, y_buy)\n",
    "        scores_buy.append({\n",
    "            'model': model,\n",
    "            'best_score': reg.best_score_,\n",
    "            'best_params': reg.best_params_\n",
    "        })\n",
    "\n",
    "    except KeyboardInterrupt:\n",
    "        print(f\"Ctrl+C detected during algorithm: {model}\")\n",
    "        break\n",
    "\n",
    "    except Exception:\n",
    "        print(f\"Exception during algorithm: {model}\")\n",
    "        print(traceback.format_exc())\n",
    "        continue\n",
    "\n",
    "result_buy = pd.DataFrame(scores_buy, columns=['model', 'best_score', 'best_params'])\n",
    "display(result_buy)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f6abafd0-6beb-4fd5-b9bf-728baa73f40f",
   "metadata": {},
   "outputs": [],
   "source": [
    "scores_rent = []\n",
    "for model, attrs in model_params.items():\n",
    "    try:\n",
    "        reg = GridSearchCV(attrs['model'], attrs['params'], cv=KFold(shuffle=True), verbose=10)\n",
    "        reg.fit(X, y_rent)\n",
    "        scores_rent.append({\n",
    "            'model': model,\n",
    "            'best_score': reg.best_score_,\n",
    "            'best_params': reg.best_params_\n",
    "        })\n",
    "    \n",
    "    except KeyboardInterrupt:\n",
    "        print(f\"Ctrl+C detected during algorithm: {model}\")\n",
    "        break\n",
    "        \n",
    "    except Exception:\n",
    "        print(f\"Exception during algorithm: {model}\")\n",
    "        print(traceback.format_exc())\n",
    "        continue\n",
    "    \n",
    "result_rent = pd.DataFrame(scores_rent, columns=['model', 'best_score', 'best_params'])\n",
    "display(result_rent)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9cddf3bb-d883-4fa4-8411-72b2e9980521",
   "metadata": {
    "tags": []
   },
   "source": [
    "### Results of the GridSearchCV"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "04d4dce6-cc30-4e33-9358-07f55967788b",
   "metadata": {},
   "source": [
    "* **`buy_price`**:\n",
    "    * Best score: 0.91\n",
    "    * Best model: GradientBoostingRegressor\n",
    "    * Best parameters:\n",
    "        * `learning_rate`: 0.5\n",
    "        * `max_depth`: 5\n",
    "        * `min_samples_leaf`: 4\n",
    "        * `min_samples_split`: 16\n",
    "\n",
    "\n",
    "* **`rent_price`**:\n",
    "    * Best score: 0.88\n",
    "    * Best model: GradientBoostingRegressor\n",
    "    * Best parameters:\n",
    "        * `learning_rate`: 0.09\n",
    "        * `max_depth`: 20\n",
    "        * `min_samples_leaf`: 4\n",
    "        * `min_samples_split`: 16"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "542e9b9e-854b-4b89-8a35-177eedfa29ba",
   "metadata": {},
   "source": [
    "## Train best model"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "6025397e-cc37-4263-9c79-f57cbd72a896",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Buy price model score: 0.905\n",
      "Rent price model score: 0.878\n",
      "Saved model to data/reg_buy_price.joblib\n",
      "Saved model to data/reg_rent_price.joblib\n"
     ]
    }
   ],
   "source": [
    "from sklearn.model_selection import cross_val_score, KFold\n",
    "import joblib\n",
    "\n",
    "buy_model = GradientBoostingRegressor(learning_rate=0.5, max_depth=5, min_samples_split=16, min_samples_leaf=4)\n",
    "rent_model = GradientBoostingRegressor(learning_rate=0.09, max_depth=20, min_samples_split=16, min_samples_leaf=4)\n",
    "\n",
    "buy_scores = cross_val_score(buy_model, X, y_buy, cv=KFold(shuffle=True))\n",
    "print(f\"Buy price model score: {sum(buy_scores) / len(buy_scores):.3f}\")\n",
    "rent_scores = cross_val_score(rent_model, X, y_rent, cv=KFold(shuffle=True))\n",
    "print(f\"Rent price model score: {sum(rent_scores) / len(rent_scores):.3f}\")\n",
    "\n",
    "buy_model.fit(X, y_buy)\n",
    "rent_model.fit(X, y_rent)\n",
    "\n",
    "joblib.dump(buy_model, \"data/reg_buy_price.joblib\")\n",
    "print(\"Saved model to data/reg_buy_price.joblib\")\n",
    "joblib.dump(rent_model, \"data/reg_rent_price.joblib\")\n",
    "print(\"Saved model to data/reg_rent_price.joblib\")"
   ]
  }
 ],
 "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.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}