Preparation-donnees.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<img src=\"http://naonedia.fr/wp-content/uploads/2018/10/logoNaonedia.png\" style=\"height:100px\">\n",
    "<h1>\n",
    "    <center>Expérience Logement</center>\n",
    "    <center>-</center>\n",
    "    <center>Préparations des données</center>\n",
    "</h1>\n",
    "\n",
    "\n",
    "<h3> Introduction </h3>\n",
    "\n",
    "Dans ce dernier notebook, nous allons voir comment finaliser notre jeux de données, à la fin nous obtiendrons un jeux de données prêt à l'emploi.\n",
    "Celui pourra être ensuite utilisé dans un réseaux de neurones.\n",
    "\n",
    "\n",
    "<h3>Informations</h3>\n",
    "\n",
    "Il est fortement conseillé d'utiliser Python3.x\n",
    "Si vous ne disposez pas de toutes les librairies requises , il suffit de l'installer en utilisant la commande suivante.\n",
    "<br>\n",
    "<code>pip3 install ....</code>\n",
    "\n",
    "<h3>Authors:</h3>\n",
    "<cite>Thibault Brocherieux - Ippon Technologies</cite>\n",
    "\n",
    "## Import des librairies requises"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "from os import path\n",
    "import json\n",
    "from shapely.geometry import shape, Point\n",
    "\n",
    "import plotly.offline as py\n",
    "import plotly.figure_factory as ff\n",
    "import plotly.graph_objs as go"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Chargement du jeux de données à finaliser"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>date_mutation</th>\n",
       "      <th>valeur_fonciere</th>\n",
       "      <th>code_postal</th>\n",
       "      <th>nom_commune</th>\n",
       "      <th>surface_carrez</th>\n",
       "      <th>type_local</th>\n",
       "      <th>surface_reelle_bati</th>\n",
       "      <th>nombre_pieces_principales</th>\n",
       "      <th>surface_terrain</th>\n",
       "      <th>mois</th>\n",
       "      <th>...</th>\n",
       "      <th>0-3-taux_epargne</th>\n",
       "      <th>0-3-taux_epargne_financier</th>\n",
       "      <th>0-4-rdb</th>\n",
       "      <th>0-4-rdb_uc</th>\n",
       "      <th>0-4-pa_rdb</th>\n",
       "      <th>0-4-pa_rdb_uc</th>\n",
       "      <th>0-4-taux_epargne</th>\n",
       "      <th>0-4-taux_epargne_financier</th>\n",
       "      <th>longitude</th>\n",
       "      <th>latitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2014-01-02</td>\n",
       "      <td>107000.0</td>\n",
       "      <td>44800</td>\n",
       "      <td>ST-HERBLAIN</td>\n",
       "      <td>45.80</td>\n",
       "      <td>Appartement</td>\n",
       "      <td>46.0</td>\n",
       "      <td>2</td>\n",
       "      <td>46.0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>177111.631901</td>\n",
       "      <td>1320.383769</td>\n",
       "      <td>149.129082</td>\n",
       "      <td>133.560584</td>\n",
       "      <td>122.508389</td>\n",
       "      <td>109.783356</td>\n",
       "      <td>201021.702207</td>\n",
       "      <td>1371.878736</td>\n",
       "      <td>-1.644254</td>\n",
       "      <td>47.207462</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2014-01-02</td>\n",
       "      <td>111500.0</td>\n",
       "      <td>44000</td>\n",
       "      <td>NANTES</td>\n",
       "      <td>44.31</td>\n",
       "      <td>Appartement</td>\n",
       "      <td>17.0</td>\n",
       "      <td>1</td>\n",
       "      <td>17.0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>177111.631901</td>\n",
       "      <td>1320.383769</td>\n",
       "      <td>149.129082</td>\n",
       "      <td>133.560584</td>\n",
       "      <td>122.508389</td>\n",
       "      <td>109.783356</td>\n",
       "      <td>201021.702207</td>\n",
       "      <td>1371.878736</td>\n",
       "      <td>-1.548747</td>\n",
       "      <td>47.220961</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2014-01-02</td>\n",
       "      <td>111500.0</td>\n",
       "      <td>44000</td>\n",
       "      <td>NANTES</td>\n",
       "      <td>44.31</td>\n",
       "      <td>Appartement</td>\n",
       "      <td>45.0</td>\n",
       "      <td>2</td>\n",
       "      <td>45.0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>177111.631901</td>\n",
       "      <td>1320.383769</td>\n",
       "      <td>149.129082</td>\n",
       "      <td>133.560584</td>\n",
       "      <td>122.508389</td>\n",
       "      <td>109.783356</td>\n",
       "      <td>201021.702207</td>\n",
       "      <td>1371.878736</td>\n",
       "      <td>-1.548747</td>\n",
       "      <td>47.220961</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2014-01-02</td>\n",
       "      <td>130000.0</td>\n",
       "      <td>44300</td>\n",
       "      <td>NANTES</td>\n",
       "      <td>49.76</td>\n",
       "      <td>Appartement</td>\n",
       "      <td>50.0</td>\n",
       "      <td>2</td>\n",
       "      <td>50.0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>177111.631901</td>\n",
       "      <td>1320.383769</td>\n",
       "      <td>149.129082</td>\n",
       "      <td>133.560584</td>\n",
       "      <td>122.508389</td>\n",
       "      <td>109.783356</td>\n",
       "      <td>201021.702207</td>\n",
       "      <td>1371.878736</td>\n",
       "      <td>-1.566879</td>\n",
       "      <td>47.234022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2014-01-02</td>\n",
       "      <td>190000.0</td>\n",
       "      <td>44300</td>\n",
       "      <td>NANTES</td>\n",
       "      <td>63.31</td>\n",
       "      <td>Appartement</td>\n",
       "      <td>62.0</td>\n",
       "      <td>3</td>\n",
       "      <td>62.0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>177111.631901</td>\n",
       "      <td>1320.383769</td>\n",
       "      <td>149.129082</td>\n",
       "      <td>133.560584</td>\n",
       "      <td>122.508389</td>\n",
       "      <td>109.783356</td>\n",
       "      <td>201021.702207</td>\n",
       "      <td>1371.878736</td>\n",
       "      <td>-1.545120</td>\n",
       "      <td>47.251066</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 177 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  date_mutation  valeur_fonciere  code_postal  nom_commune  surface_carrez  \\\n",
       "0    2014-01-02         107000.0        44800  ST-HERBLAIN           45.80   \n",
       "1    2014-01-02         111500.0        44000       NANTES           44.31   \n",
       "2    2014-01-02         111500.0        44000       NANTES           44.31   \n",
       "3    2014-01-02         130000.0        44300       NANTES           49.76   \n",
       "4    2014-01-02         190000.0        44300       NANTES           63.31   \n",
       "\n",
       "    type_local  surface_reelle_bati  nombre_pieces_principales  \\\n",
       "0  Appartement                 46.0                          2   \n",
       "1  Appartement                 17.0                          1   \n",
       "2  Appartement                 45.0                          2   \n",
       "3  Appartement                 50.0                          2   \n",
       "4  Appartement                 62.0                          3   \n",
       "\n",
       "   surface_terrain  mois  ...  0-3-taux_epargne  0-3-taux_epargne_financier  \\\n",
       "0             46.0     1  ...     177111.631901                 1320.383769   \n",
       "1             17.0     1  ...     177111.631901                 1320.383769   \n",
       "2             45.0     1  ...     177111.631901                 1320.383769   \n",
       "3             50.0     1  ...     177111.631901                 1320.383769   \n",
       "4             62.0     1  ...     177111.631901                 1320.383769   \n",
       "\n",
       "      0-4-rdb  0-4-rdb_uc  0-4-pa_rdb  0-4-pa_rdb_uc  0-4-taux_epargne  \\\n",
       "0  149.129082  133.560584  122.508389     109.783356     201021.702207   \n",
       "1  149.129082  133.560584  122.508389     109.783356     201021.702207   \n",
       "2  149.129082  133.560584  122.508389     109.783356     201021.702207   \n",
       "3  149.129082  133.560584  122.508389     109.783356     201021.702207   \n",
       "4  149.129082  133.560584  122.508389     109.783356     201021.702207   \n",
       "\n",
       "   0-4-taux_epargne_financier  longitude   latitude  \n",
       "0                 1371.878736  -1.644254  47.207462  \n",
       "1                 1371.878736  -1.548747  47.220961  \n",
       "2                 1371.878736  -1.548747  47.220961  \n",
       "3                 1371.878736  -1.566879  47.234022  \n",
       "4                 1371.878736  -1.545120  47.251066  \n",
       "\n",
       "[5 rows x 177 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('data/datasets/origin_enriched_v3_lonlat.csv', delimiter=',', header=0)\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Nous commencons par regarder si notre jeux de données a des données manquantes.\n",
    "Le code ci-dessous nous permet de fournir le nom des colonnes possédant un/des valeur(s) manquantes."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "[i for i in df.columns if df[i].isnull().any()]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Dans notre cas nous ne possédons aucunes données manquantes. Nous allons maintenant regarder les types de données."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[dtype('float64'), dtype('int64'), dtype('O')]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(set(df.dtypes))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Suppresion des geolocalisation dupliqué et des données aberrantes\n",
    "\n",
    "On fixe un minimum de 1600 € au m².  \n",
    "On récupère les biens compris entre 50 000€ et 1 000 000€.  \n",
    "On ne récupère que les biens ayant une taille supérieur à 25m².  \n",
    "On supprime les biens dupliqués (Même longitude, latitude, date de vente, surface\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = df.loc[(df['valeur_fonciere'] > df['surface_reelle_bati'] * 1600) & (df['valeur_fonciere'] > 50000) & (df['valeur_fonciere'] < 1000000) & (df['surface_reelle_bati'] > 25)]\n",
    "dfToDrop = df[df.duplicated(subset=['longitude','latitude','date_mutation','surface_reelle_bati'], keep=False)]\n",
    "df = pd.concat([df, dfToDrop, dfToDrop]).drop_duplicates(keep=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "scrolled": true
   },
   "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>date_mutation</th>\n",
       "      <th>valeur_fonciere</th>\n",
       "      <th>code_postal</th>\n",
       "      <th>nom_commune</th>\n",
       "      <th>surface_carrez</th>\n",
       "      <th>type_local</th>\n",
       "      <th>surface_reelle_bati</th>\n",
       "      <th>nombre_pieces_principales</th>\n",
       "      <th>surface_terrain</th>\n",
       "      <th>mois</th>\n",
       "      <th>...</th>\n",
       "      <th>0-3-taux_epargne</th>\n",
       "      <th>0-3-taux_epargne_financier</th>\n",
       "      <th>0-4-rdb</th>\n",
       "      <th>0-4-rdb_uc</th>\n",
       "      <th>0-4-pa_rdb</th>\n",
       "      <th>0-4-pa_rdb_uc</th>\n",
       "      <th>0-4-taux_epargne</th>\n",
       "      <th>0-4-taux_epargne_financier</th>\n",
       "      <th>longitude</th>\n",
       "      <th>latitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2014-01-02</td>\n",
       "      <td>107000.00</td>\n",
       "      <td>44800</td>\n",
       "      <td>ST-HERBLAIN</td>\n",
       "      <td>45.80</td>\n",
       "      <td>Appartement</td>\n",
       "      <td>46.0</td>\n",
       "      <td>2</td>\n",
       "      <td>46.0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.771116e+05</td>\n",
       "      <td>1320.383769</td>\n",
       "      <td>149.129082</td>\n",
       "      <td>133.560584</td>\n",
       "      <td>122.508389</td>\n",
       "      <td>109.783356</td>\n",
       "      <td>2.010217e+05</td>\n",
       "      <td>1371.878736</td>\n",
       "      <td>-1.644254</td>\n",
       "      <td>47.207462</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2014-01-02</td>\n",
       "      <td>111500.00</td>\n",
       "      <td>44000</td>\n",
       "      <td>NANTES</td>\n",
       "      <td>44.31</td>\n",
       "      <td>Appartement</td>\n",
       "      <td>45.0</td>\n",
       "      <td>2</td>\n",
       "      <td>45.0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.771116e+05</td>\n",
       "      <td>1320.383769</td>\n",
       "      <td>149.129082</td>\n",
       "      <td>133.560584</td>\n",
       "      <td>122.508389</td>\n",
       "      <td>109.783356</td>\n",
       "      <td>2.010217e+05</td>\n",
       "      <td>1371.878736</td>\n",
       "      <td>-1.548747</td>\n",
       "      <td>47.220961</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2014-01-02</td>\n",
       "      <td>130000.00</td>\n",
       "      <td>44300</td>\n",
       "      <td>NANTES</td>\n",
       "      <td>49.76</td>\n",
       "      <td>Appartement</td>\n",
       "      <td>50.0</td>\n",
       "      <td>2</td>\n",
       "      <td>50.0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.771116e+05</td>\n",
       "      <td>1320.383769</td>\n",
       "      <td>149.129082</td>\n",
       "      <td>133.560584</td>\n",
       "      <td>122.508389</td>\n",
       "      <td>109.783356</td>\n",
       "      <td>2.010217e+05</td>\n",
       "      <td>1371.878736</td>\n",
       "      <td>-1.566879</td>\n",
       "      <td>47.234022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2014-01-02</td>\n",
       "      <td>190000.00</td>\n",
       "      <td>44300</td>\n",
       "      <td>NANTES</td>\n",
       "      <td>63.31</td>\n",
       "      <td>Appartement</td>\n",
       "      <td>62.0</td>\n",
       "      <td>3</td>\n",
       "      <td>62.0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.771116e+05</td>\n",
       "      <td>1320.383769</td>\n",
       "      <td>149.129082</td>\n",
       "      <td>133.560584</td>\n",
       "      <td>122.508389</td>\n",
       "      <td>109.783356</td>\n",
       "      <td>2.010217e+05</td>\n",
       "      <td>1371.878736</td>\n",
       "      <td>-1.545120</td>\n",
       "      <td>47.251066</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2014-01-02</td>\n",
       "      <td>194400.00</td>\n",
       "      <td>44100</td>\n",
       "      <td>NANTES</td>\n",
       "      <td>84.00</td>\n",
       "      <td>Appartement</td>\n",
       "      <td>84.0</td>\n",
       "      <td>4</td>\n",
       "      <td>84.0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.771116e+05</td>\n",
       "      <td>1320.383769</td>\n",
       "      <td>149.129082</td>\n",
       "      <td>133.560584</td>\n",
       "      <td>122.508389</td>\n",
       "      <td>109.783356</td>\n",
       "      <td>2.010217e+05</td>\n",
       "      <td>1371.878736</td>\n",
       "      <td>-1.603261</td>\n",
       "      <td>47.209692</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2014-01-02</td>\n",
       "      <td>335000.00</td>\n",
       "      <td>44300</td>\n",
       "      <td>NANTES</td>\n",
       "      <td>118.00</td>\n",
       "      <td>Maison</td>\n",
       "      <td>118.0</td>\n",
       "      <td>5</td>\n",
       "      <td>562.0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.771116e+05</td>\n",
       "      <td>1320.383769</td>\n",
       "      <td>149.129082</td>\n",
       "      <td>133.560584</td>\n",
       "      <td>122.508389</td>\n",
       "      <td>109.783356</td>\n",
       "      <td>2.010217e+05</td>\n",
       "      <td>1371.878736</td>\n",
       "      <td>-1.506824</td>\n",
       "      <td>47.231122</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2014-01-03</td>\n",
       "      <td>84950.00</td>\n",
       "      <td>44400</td>\n",
       "      <td>REZE</td>\n",
       "      <td>50.00</td>\n",
       "      <td>Appartement</td>\n",
       "      <td>50.0</td>\n",
       "      <td>2</td>\n",
       "      <td>50.0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.771116e+05</td>\n",
       "      <td>1320.383769</td>\n",
       "      <td>149.129082</td>\n",
       "      <td>133.560584</td>\n",
       "      <td>122.508389</td>\n",
       "      <td>109.783356</td>\n",
       "      <td>2.010217e+05</td>\n",
       "      <td>1371.878736</td>\n",
       "      <td>-1.547729</td>\n",
       "      <td>47.189657</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2014-01-03</td>\n",
       "      <td>94500.00</td>\n",
       "      <td>44000</td>\n",
       "      <td>NANTES</td>\n",
       "      <td>39.02</td>\n",
       "      <td>Appartement</td>\n",
       "      <td>39.0</td>\n",
       "      <td>2</td>\n",
       "      <td>39.0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.771116e+05</td>\n",
       "      <td>1320.383769</td>\n",
       "      <td>149.129082</td>\n",
       "      <td>133.560584</td>\n",
       "      <td>122.508389</td>\n",
       "      <td>109.783356</td>\n",
       "      <td>2.010217e+05</td>\n",
       "      <td>1371.878736</td>\n",
       "      <td>-1.550883</td>\n",
       "      <td>47.224574</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2014-01-03</td>\n",
       "      <td>96500.00</td>\n",
       "      <td>44300</td>\n",
       "      <td>NANTES</td>\n",
       "      <td>33.00</td>\n",
       "      <td>Maison</td>\n",
       "      <td>33.0</td>\n",
       "      <td>1</td>\n",
       "      <td>464.0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.771116e+05</td>\n",
       "      <td>1320.383769</td>\n",
       "      <td>149.129082</td>\n",
       "      <td>133.560584</td>\n",
       "      <td>122.508389</td>\n",
       "      <td>109.783356</td>\n",
       "      <td>2.010217e+05</td>\n",
       "      <td>1371.878736</td>\n",
       "      <td>-1.542793</td>\n",
       "      <td>47.254146</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2014-01-03</td>\n",
       "      <td>96500.00</td>\n",
       "      <td>44300</td>\n",
       "      <td>NANTES</td>\n",
       "      <td>47.00</td>\n",
       "      <td>Maison</td>\n",
       "      <td>47.0</td>\n",
       "      <td>2</td>\n",
       "      <td>464.0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.771116e+05</td>\n",
       "      <td>1320.383769</td>\n",
       "      <td>149.129082</td>\n",
       "      <td>133.560584</td>\n",
       "      <td>122.508389</td>\n",
       "      <td>109.783356</td>\n",
       "      <td>2.010217e+05</td>\n",
       "      <td>1371.878736</td>\n",
       "      <td>-1.542793</td>\n",
       "      <td>47.254146</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2014-01-03</td>\n",
       "      <td>113500.00</td>\n",
       "      <td>44120</td>\n",
       "      <td>VERTOU</td>\n",
       "      <td>56.00</td>\n",
       "      <td>Maison</td>\n",
       "      <td>56.0</td>\n",
       "      <td>4</td>\n",
       "      <td>62.0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.771116e+05</td>\n",
       "      <td>1320.383769</td>\n",
       "      <td>149.129082</td>\n",
       "      <td>133.560584</td>\n",
       "      <td>122.508389</td>\n",
       "      <td>109.783356</td>\n",
       "      <td>2.010217e+05</td>\n",
       "      <td>1371.878736</td>\n",
       "      <td>-1.482974</td>\n",
       "      <td>47.162898</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2014-01-03</td>\n",
       "      <td>130000.00</td>\n",
       "      <td>44300</td>\n",
       "      <td>NANTES</td>\n",
       "      <td>47.00</td>\n",
       "      <td>Maison</td>\n",
       "      <td>47.0</td>\n",
       "      <td>2</td>\n",
       "      <td>345.0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.771116e+05</td>\n",
       "      <td>1320.383769</td>\n",
       "      <td>149.129082</td>\n",
       "      <td>133.560584</td>\n",
       "      <td>122.508389</td>\n",
       "      <td>109.783356</td>\n",
       "      <td>2.010217e+05</td>\n",
       "      <td>1371.878736</td>\n",
       "      <td>-1.519796</td>\n",
       "      <td>47.259671</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2014-01-03</td>\n",
       "      <td>160000.00</td>\n",
       "      <td>44230</td>\n",
       "      <td>ST-SEBASTIEN</td>\n",
       "      <td>68.00</td>\n",
       "      <td>Maison</td>\n",
       "      <td>68.0</td>\n",
       "      <td>4</td>\n",
       "      <td>434.0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.771116e+05</td>\n",
       "      <td>1320.383769</td>\n",
       "      <td>149.129082</td>\n",
       "      <td>133.560584</td>\n",
       "      <td>122.508389</td>\n",
       "      <td>109.783356</td>\n",
       "      <td>2.010217e+05</td>\n",
       "      <td>1371.878736</td>\n",
       "      <td>-1.487932</td>\n",
       "      <td>47.198380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2014-01-03</td>\n",
       "      <td>200000.00</td>\n",
       "      <td>44800</td>\n",
       "      <td>ST-HERBLAIN</td>\n",
       "      <td>85.00</td>\n",
       "      <td>Maison</td>\n",
       "      <td>85.0</td>\n",
       "      <td>5</td>\n",
       "      <td>501.0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.771116e+05</td>\n",
       "      <td>1320.383769</td>\n",
       "      <td>149.129082</td>\n",
       "      <td>133.560584</td>\n",
       "      <td>122.508389</td>\n",
       "      <td>109.783356</td>\n",
       "      <td>2.010217e+05</td>\n",
       "      <td>1371.878736</td>\n",
       "      <td>-1.653568</td>\n",
       "      <td>47.215420</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2014-01-03</td>\n",
       "      <td>205000.00</td>\n",
       "      <td>44840</td>\n",
       "      <td>LES-SORINIERES</td>\n",
       "      <td>83.00</td>\n",
       "      <td>Maison</td>\n",
       "      <td>83.0</td>\n",
       "      <td>5</td>\n",
       "      <td>510.0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.771116e+05</td>\n",
       "      <td>1320.383769</td>\n",
       "      <td>149.129082</td>\n",
       "      <td>133.560584</td>\n",
       "      <td>122.508389</td>\n",
       "      <td>109.783356</td>\n",
       "      <td>2.010217e+05</td>\n",
       "      <td>1371.878736</td>\n",
       "      <td>-1.516486</td>\n",
       "      <td>47.157784</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2014-01-03</td>\n",
       "      <td>217000.00</td>\n",
       "      <td>44120</td>\n",
       "      <td>VERTOU</td>\n",
       "      <td>109.00</td>\n",
       "      <td>Maison</td>\n",
       "      <td>109.0</td>\n",
       "      <td>4</td>\n",
       "      <td>303.0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.771116e+05</td>\n",
       "      <td>1320.383769</td>\n",
       "      <td>149.129082</td>\n",
       "      <td>133.560584</td>\n",
       "      <td>122.508389</td>\n",
       "      <td>109.783356</td>\n",
       "      <td>2.010217e+05</td>\n",
       "      <td>1371.878736</td>\n",
       "      <td>-1.471515</td>\n",
       "      <td>47.161284</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2014-01-03</td>\n",
       "      <td>217500.00</td>\n",
       "      <td>44240</td>\n",
       "      <td>LA-CHAPELLE-SUR-ERDRE</td>\n",
       "      <td>71.00</td>\n",
       "      <td>Maison</td>\n",
       "      <td>71.0</td>\n",
       "      <td>3</td>\n",
       "      <td>362.0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.771116e+05</td>\n",
       "      <td>1320.383769</td>\n",
       "      <td>149.129082</td>\n",
       "      <td>133.560584</td>\n",
       "      <td>122.508389</td>\n",
       "      <td>109.783356</td>\n",
       "      <td>2.010217e+05</td>\n",
       "      <td>1371.878736</td>\n",
       "      <td>-1.565130</td>\n",
       "      <td>47.303804</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2014-01-03</td>\n",
       "      <td>240000.00</td>\n",
       "      <td>44400</td>\n",
       "      <td>REZE</td>\n",
       "      <td>98.00</td>\n",
       "      <td>Maison</td>\n",
       "      <td>98.0</td>\n",
       "      <td>5</td>\n",
       "      <td>214.0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.771116e+05</td>\n",
       "      <td>1320.383769</td>\n",
       "      <td>149.129082</td>\n",
       "      <td>133.560584</td>\n",
       "      <td>122.508389</td>\n",
       "      <td>109.783356</td>\n",
       "      <td>2.010217e+05</td>\n",
       "      <td>1371.878736</td>\n",
       "      <td>-1.532043</td>\n",
       "      <td>47.179874</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2014-01-03</td>\n",
       "      <td>280253.00</td>\n",
       "      <td>44300</td>\n",
       "      <td>NANTES</td>\n",
       "      <td>91.00</td>\n",
       "      <td>Maison</td>\n",
       "      <td>91.0</td>\n",
       "      <td>4</td>\n",
       "      <td>410.0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.771116e+05</td>\n",
       "      <td>1320.383769</td>\n",
       "      <td>149.129082</td>\n",
       "      <td>133.560584</td>\n",
       "      <td>122.508389</td>\n",
       "      <td>109.783356</td>\n",
       "      <td>2.010217e+05</td>\n",
       "      <td>1371.878736</td>\n",
       "      <td>-1.520990</td>\n",
       "      <td>47.224271</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2014-01-03</td>\n",
       "      <td>510000.00</td>\n",
       "      <td>44000</td>\n",
       "      <td>NANTES</td>\n",
       "      <td>99.67</td>\n",
       "      <td>Appartement</td>\n",
       "      <td>123.0</td>\n",
       "      <td>4</td>\n",
       "      <td>123.0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.771116e+05</td>\n",
       "      <td>1320.383769</td>\n",
       "      <td>149.129082</td>\n",
       "      <td>133.560584</td>\n",
       "      <td>122.508389</td>\n",
       "      <td>109.783356</td>\n",
       "      <td>2.010217e+05</td>\n",
       "      <td>1371.878736</td>\n",
       "      <td>-1.553465</td>\n",
       "      <td>47.222619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2014-01-06</td>\n",
       "      <td>150000.00</td>\n",
       "      <td>44000</td>\n",
       "      <td>NANTES</td>\n",
       "      <td>69.59</td>\n",
       "      <td>Appartement</td>\n",
       "      <td>70.0</td>\n",
       "      <td>2</td>\n",
       "      <td>70.0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.771116e+05</td>\n",
       "      <td>1320.383769</td>\n",
       "      <td>149.129082</td>\n",
       "      <td>133.560584</td>\n",
       "      <td>122.508389</td>\n",
       "      <td>109.783356</td>\n",
       "      <td>2.010217e+05</td>\n",
       "      <td>1371.878736</td>\n",
       "      <td>-1.543143</td>\n",
       "      <td>47.218242</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2014-01-06</td>\n",
       "      <td>155633.89</td>\n",
       "      <td>44300</td>\n",
       "      <td>NANTES</td>\n",
       "      <td>65.44</td>\n",
       "      <td>Appartement</td>\n",
       "      <td>66.0</td>\n",
       "      <td>3</td>\n",
       "      <td>66.0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.771116e+05</td>\n",
       "      <td>1320.383769</td>\n",
       "      <td>149.129082</td>\n",
       "      <td>133.560584</td>\n",
       "      <td>122.508389</td>\n",
       "      <td>109.783356</td>\n",
       "      <td>2.010217e+05</td>\n",
       "      <td>1371.878736</td>\n",
       "      <td>-1.514441</td>\n",
       "      <td>47.261420</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2014-01-06</td>\n",
       "      <td>165000.00</td>\n",
       "      <td>44300</td>\n",
       "      <td>NANTES</td>\n",
       "      <td>92.00</td>\n",
       "      <td>Maison</td>\n",
       "      <td>92.0</td>\n",
       "      <td>4</td>\n",
       "      <td>270.0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.771116e+05</td>\n",
       "      <td>1320.383769</td>\n",
       "      <td>149.129082</td>\n",
       "      <td>133.560584</td>\n",
       "      <td>122.508389</td>\n",
       "      <td>109.783356</td>\n",
       "      <td>2.010217e+05</td>\n",
       "      <td>1371.878736</td>\n",
       "      <td>-1.571497</td>\n",
       "      <td>47.258307</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>2014-01-06</td>\n",
       "      <td>175000.00</td>\n",
       "      <td>44000</td>\n",
       "      <td>NANTES</td>\n",
       "      <td>47.06</td>\n",
       "      <td>Appartement</td>\n",
       "      <td>46.0</td>\n",
       "      <td>2</td>\n",
       "      <td>46.0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.771116e+05</td>\n",
       "      <td>1320.383769</td>\n",
       "      <td>149.129082</td>\n",
       "      <td>133.560584</td>\n",
       "      <td>122.508389</td>\n",
       "      <td>109.783356</td>\n",
       "      <td>2.010217e+05</td>\n",
       "      <td>1371.878736</td>\n",
       "      <td>-1.558753</td>\n",
       "      <td>47.210422</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>2014-01-06</td>\n",
       "      <td>175799.56</td>\n",
       "      <td>44470</td>\n",
       "      <td>THOUARE-SUR-LOIRE</td>\n",
       "      <td>80.00</td>\n",
       "      <td>Maison</td>\n",
       "      <td>80.0</td>\n",
       "      <td>4</td>\n",
       "      <td>220.0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.771116e+05</td>\n",
       "      <td>1320.383769</td>\n",
       "      <td>149.129082</td>\n",
       "      <td>133.560584</td>\n",
       "      <td>122.508389</td>\n",
       "      <td>109.783356</td>\n",
       "      <td>2.010217e+05</td>\n",
       "      <td>1371.878736</td>\n",
       "      <td>-1.451994</td>\n",
       "      <td>47.268623</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>2014-01-06</td>\n",
       "      <td>178500.00</td>\n",
       "      <td>44100</td>\n",
       "      <td>NANTES</td>\n",
       "      <td>70.00</td>\n",
       "      <td>Appartement</td>\n",
       "      <td>69.0</td>\n",
       "      <td>3</td>\n",
       "      <td>69.0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.771116e+05</td>\n",
       "      <td>1320.383769</td>\n",
       "      <td>149.129082</td>\n",
       "      <td>133.560584</td>\n",
       "      <td>122.508389</td>\n",
       "      <td>109.783356</td>\n",
       "      <td>2.010217e+05</td>\n",
       "      <td>1371.878736</td>\n",
       "      <td>-1.571382</td>\n",
       "      <td>47.213657</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>2014-01-06</td>\n",
       "      <td>202000.00</td>\n",
       "      <td>44220</td>\n",
       "      <td>COUERON</td>\n",
       "      <td>57.00</td>\n",
       "      <td>Maison</td>\n",
       "      <td>57.0</td>\n",
       "      <td>3</td>\n",
       "      <td>207.0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.771116e+05</td>\n",
       "      <td>1320.383769</td>\n",
       "      <td>149.129082</td>\n",
       "      <td>133.560584</td>\n",
       "      <td>122.508389</td>\n",
       "      <td>109.783356</td>\n",
       "      <td>2.010217e+05</td>\n",
       "      <td>1371.878736</td>\n",
       "      <td>-1.717755</td>\n",
       "      <td>47.211733</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>2014-01-06</td>\n",
       "      <td>227500.00</td>\n",
       "      <td>44220</td>\n",
       "      <td>COUERON</td>\n",
       "      <td>115.00</td>\n",
       "      <td>Maison</td>\n",
       "      <td>115.0</td>\n",
       "      <td>5</td>\n",
       "      <td>141.0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.771116e+05</td>\n",
       "      <td>1320.383769</td>\n",
       "      <td>149.129082</td>\n",
       "      <td>133.560584</td>\n",
       "      <td>122.508389</td>\n",
       "      <td>109.783356</td>\n",
       "      <td>2.010217e+05</td>\n",
       "      <td>1371.878736</td>\n",
       "      <td>-1.733970</td>\n",
       "      <td>47.221695</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>2014-01-06</td>\n",
       "      <td>230000.00</td>\n",
       "      <td>44300</td>\n",
       "      <td>NANTES</td>\n",
       "      <td>99.00</td>\n",
       "      <td>Maison</td>\n",
       "      <td>99.0</td>\n",
       "      <td>4</td>\n",
       "      <td>269.0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.771116e+05</td>\n",
       "      <td>1320.383769</td>\n",
       "      <td>149.129082</td>\n",
       "      <td>133.560584</td>\n",
       "      <td>122.508389</td>\n",
       "      <td>109.783356</td>\n",
       "      <td>2.010217e+05</td>\n",
       "      <td>1371.878736</td>\n",
       "      <td>-1.502877</td>\n",
       "      <td>47.232062</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>2014-01-06</td>\n",
       "      <td>250000.00</td>\n",
       "      <td>44700</td>\n",
       "      <td>ORVAULT</td>\n",
       "      <td>133.00</td>\n",
       "      <td>Maison</td>\n",
       "      <td>133.0</td>\n",
       "      <td>4</td>\n",
       "      <td>1138.0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1.771116e+05</td>\n",
       "      <td>1320.383769</td>\n",
       "      <td>149.129082</td>\n",
       "      <td>133.560584</td>\n",
       "      <td>122.508389</td>\n",
       "      <td>109.783356</td>\n",
       "      <td>2.010217e+05</td>\n",
       "      <td>1371.878736</td>\n",
       "      <td>-1.631874</td>\n",
       "      <td>47.291903</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38824</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>240800.00</td>\n",
       "      <td>44400</td>\n",
       "      <td>REZE</td>\n",
       "      <td>51.28</td>\n",
       "      <td>Appartement</td>\n",
       "      <td>50.0</td>\n",
       "      <td>2</td>\n",
       "      <td>50.0</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>2.195759e+06</td>\n",
       "      <td>3078.882462</td>\n",
       "      <td>164.589540</td>\n",
       "      <td>143.211753</td>\n",
       "      <td>130.704605</td>\n",
       "      <td>113.789493</td>\n",
       "      <td>2.509752e+06</td>\n",
       "      <td>3202.037760</td>\n",
       "      <td>-1.530768</td>\n",
       "      <td>47.182496</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38827</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>245000.00</td>\n",
       "      <td>44830</td>\n",
       "      <td>BOUAYE</td>\n",
       "      <td>79.00</td>\n",
       "      <td>Maison</td>\n",
       "      <td>79.0</td>\n",
       "      <td>4</td>\n",
       "      <td>299.0</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>2.195759e+06</td>\n",
       "      <td>3078.882462</td>\n",
       "      <td>164.589540</td>\n",
       "      <td>143.211753</td>\n",
       "      <td>130.704605</td>\n",
       "      <td>113.789493</td>\n",
       "      <td>2.509752e+06</td>\n",
       "      <td>3202.037760</td>\n",
       "      <td>-1.699466</td>\n",
       "      <td>47.142184</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38828</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>265000.00</td>\n",
       "      <td>44200</td>\n",
       "      <td>NANTES</td>\n",
       "      <td>90.00</td>\n",
       "      <td>Maison</td>\n",
       "      <td>90.0</td>\n",
       "      <td>4</td>\n",
       "      <td>309.0</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>2.195759e+06</td>\n",
       "      <td>3078.882462</td>\n",
       "      <td>164.589540</td>\n",
       "      <td>143.211753</td>\n",
       "      <td>130.704605</td>\n",
       "      <td>113.789493</td>\n",
       "      <td>2.509752e+06</td>\n",
       "      <td>3202.037760</td>\n",
       "      <td>-1.522933</td>\n",
       "      <td>47.190900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38829</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>265000.00</td>\n",
       "      <td>44880</td>\n",
       "      <td>SAUTRON</td>\n",
       "      <td>95.00</td>\n",
       "      <td>Maison</td>\n",
       "      <td>95.0</td>\n",
       "      <td>5</td>\n",
       "      <td>375.0</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>2.195759e+06</td>\n",
       "      <td>3078.882462</td>\n",
       "      <td>164.589540</td>\n",
       "      <td>143.211753</td>\n",
       "      <td>130.704605</td>\n",
       "      <td>113.789493</td>\n",
       "      <td>2.509752e+06</td>\n",
       "      <td>3202.037760</td>\n",
       "      <td>-1.671069</td>\n",
       "      <td>47.265153</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38830</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>300000.00</td>\n",
       "      <td>44980</td>\n",
       "      <td>SAINTE-LUCE-SUR-LOIRE</td>\n",
       "      <td>104.00</td>\n",
       "      <td>Maison</td>\n",
       "      <td>104.0</td>\n",
       "      <td>6</td>\n",
       "      <td>583.0</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>2.195759e+06</td>\n",
       "      <td>3078.882462</td>\n",
       "      <td>164.589540</td>\n",
       "      <td>143.211753</td>\n",
       "      <td>130.704605</td>\n",
       "      <td>113.789493</td>\n",
       "      <td>2.509752e+06</td>\n",
       "      <td>3202.037760</td>\n",
       "      <td>-1.483356</td>\n",
       "      <td>47.251378</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38831</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>310000.00</td>\n",
       "      <td>44700</td>\n",
       "      <td>ORVAULT</td>\n",
       "      <td>113.45</td>\n",
       "      <td>Maison</td>\n",
       "      <td>113.0</td>\n",
       "      <td>5</td>\n",
       "      <td>113.0</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>2.195759e+06</td>\n",
       "      <td>3078.882462</td>\n",
       "      <td>164.589540</td>\n",
       "      <td>143.211753</td>\n",
       "      <td>130.704605</td>\n",
       "      <td>113.789493</td>\n",
       "      <td>2.509752e+06</td>\n",
       "      <td>3202.037760</td>\n",
       "      <td>-1.627580</td>\n",
       "      <td>47.274046</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38832</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>320000.00</td>\n",
       "      <td>44400</td>\n",
       "      <td>REZE</td>\n",
       "      <td>79.00</td>\n",
       "      <td>Maison</td>\n",
       "      <td>79.0</td>\n",
       "      <td>5</td>\n",
       "      <td>358.0</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>2.195759e+06</td>\n",
       "      <td>3078.882462</td>\n",
       "      <td>164.589540</td>\n",
       "      <td>143.211753</td>\n",
       "      <td>130.704605</td>\n",
       "      <td>113.789493</td>\n",
       "      <td>2.509752e+06</td>\n",
       "      <td>3202.037760</td>\n",
       "      <td>-1.563090</td>\n",
       "      <td>47.181085</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38833</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>335000.00</td>\n",
       "      <td>44400</td>\n",
       "      <td>REZE</td>\n",
       "      <td>99.00</td>\n",
       "      <td>Maison</td>\n",
       "      <td>99.0</td>\n",
       "      <td>4</td>\n",
       "      <td>645.0</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>2.195759e+06</td>\n",
       "      <td>3078.882462</td>\n",
       "      <td>164.589540</td>\n",
       "      <td>143.211753</td>\n",
       "      <td>130.704605</td>\n",
       "      <td>113.789493</td>\n",
       "      <td>2.509752e+06</td>\n",
       "      <td>3202.037760</td>\n",
       "      <td>-1.533341</td>\n",
       "      <td>47.171400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38834</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>345000.00</td>\n",
       "      <td>44300</td>\n",
       "      <td>NANTES</td>\n",
       "      <td>110.00</td>\n",
       "      <td>Maison</td>\n",
       "      <td>110.0</td>\n",
       "      <td>5</td>\n",
       "      <td>110.0</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>2.195759e+06</td>\n",
       "      <td>3078.882462</td>\n",
       "      <td>164.589540</td>\n",
       "      <td>143.211753</td>\n",
       "      <td>130.704605</td>\n",
       "      <td>113.789493</td>\n",
       "      <td>2.509752e+06</td>\n",
       "      <td>3202.037760</td>\n",
       "      <td>-1.521315</td>\n",
       "      <td>47.291517</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38835</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>350000.00</td>\n",
       "      <td>44000</td>\n",
       "      <td>NANTES</td>\n",
       "      <td>60.00</td>\n",
       "      <td>Maison</td>\n",
       "      <td>60.0</td>\n",
       "      <td>3</td>\n",
       "      <td>132.0</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>2.195759e+06</td>\n",
       "      <td>3078.882462</td>\n",
       "      <td>164.589540</td>\n",
       "      <td>143.211753</td>\n",
       "      <td>130.704605</td>\n",
       "      <td>113.789493</td>\n",
       "      <td>2.509752e+06</td>\n",
       "      <td>3202.037760</td>\n",
       "      <td>-1.552665</td>\n",
       "      <td>47.234600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38836</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>352500.00</td>\n",
       "      <td>44300</td>\n",
       "      <td>NANTES</td>\n",
       "      <td>116.00</td>\n",
       "      <td>Maison</td>\n",
       "      <td>116.0</td>\n",
       "      <td>7</td>\n",
       "      <td>358.0</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>2.195759e+06</td>\n",
       "      <td>3078.882462</td>\n",
       "      <td>164.589540</td>\n",
       "      <td>143.211753</td>\n",
       "      <td>130.704605</td>\n",
       "      <td>113.789493</td>\n",
       "      <td>2.509752e+06</td>\n",
       "      <td>3202.037760</td>\n",
       "      <td>-1.517323</td>\n",
       "      <td>47.265547</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38837</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>360000.00</td>\n",
       "      <td>44300</td>\n",
       "      <td>NANTES</td>\n",
       "      <td>79.00</td>\n",
       "      <td>Maison</td>\n",
       "      <td>79.0</td>\n",
       "      <td>4</td>\n",
       "      <td>686.0</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>2.195759e+06</td>\n",
       "      <td>3078.882462</td>\n",
       "      <td>164.589540</td>\n",
       "      <td>143.211753</td>\n",
       "      <td>130.704605</td>\n",
       "      <td>113.789493</td>\n",
       "      <td>2.509752e+06</td>\n",
       "      <td>3202.037760</td>\n",
       "      <td>-1.560343</td>\n",
       "      <td>47.254603</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38838</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>370000.00</td>\n",
       "      <td>44100</td>\n",
       "      <td>NANTES</td>\n",
       "      <td>90.00</td>\n",
       "      <td>Maison</td>\n",
       "      <td>90.0</td>\n",
       "      <td>4</td>\n",
       "      <td>259.0</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>2.195759e+06</td>\n",
       "      <td>3078.882462</td>\n",
       "      <td>164.589540</td>\n",
       "      <td>143.211753</td>\n",
       "      <td>130.704605</td>\n",
       "      <td>113.789493</td>\n",
       "      <td>2.509752e+06</td>\n",
       "      <td>3202.037760</td>\n",
       "      <td>-1.584551</td>\n",
       "      <td>47.208913</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38839</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>395000.00</td>\n",
       "      <td>44800</td>\n",
       "      <td>ST-HERBLAIN</td>\n",
       "      <td>114.00</td>\n",
       "      <td>Maison</td>\n",
       "      <td>114.0</td>\n",
       "      <td>5</td>\n",
       "      <td>459.0</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>2.195759e+06</td>\n",
       "      <td>3078.882462</td>\n",
       "      <td>164.589540</td>\n",
       "      <td>143.211753</td>\n",
       "      <td>130.704605</td>\n",
       "      <td>113.789493</td>\n",
       "      <td>2.509752e+06</td>\n",
       "      <td>3202.037760</td>\n",
       "      <td>-1.641245</td>\n",
       "      <td>47.213643</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38840</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>407850.00</td>\n",
       "      <td>44400</td>\n",
       "      <td>REZE</td>\n",
       "      <td>149.00</td>\n",
       "      <td>Maison</td>\n",
       "      <td>149.0</td>\n",
       "      <td>4</td>\n",
       "      <td>128.0</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>2.195759e+06</td>\n",
       "      <td>3078.882462</td>\n",
       "      <td>164.589540</td>\n",
       "      <td>143.211753</td>\n",
       "      <td>130.704605</td>\n",
       "      <td>113.789493</td>\n",
       "      <td>2.509752e+06</td>\n",
       "      <td>3202.037760</td>\n",
       "      <td>-1.542202</td>\n",
       "      <td>47.167045</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38841</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>450000.00</td>\n",
       "      <td>44115</td>\n",
       "      <td>BASSE-GOULAINE</td>\n",
       "      <td>100.00</td>\n",
       "      <td>Maison</td>\n",
       "      <td>100.0</td>\n",
       "      <td>5</td>\n",
       "      <td>2284.0</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>2.195759e+06</td>\n",
       "      <td>3078.882462</td>\n",
       "      <td>164.589540</td>\n",
       "      <td>143.211753</td>\n",
       "      <td>130.704605</td>\n",
       "      <td>113.789493</td>\n",
       "      <td>2.509752e+06</td>\n",
       "      <td>3202.037760</td>\n",
       "      <td>-1.460025</td>\n",
       "      <td>47.188107</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38842</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>463000.00</td>\n",
       "      <td>44120</td>\n",
       "      <td>VERTOU</td>\n",
       "      <td>114.00</td>\n",
       "      <td>Maison</td>\n",
       "      <td>114.0</td>\n",
       "      <td>5</td>\n",
       "      <td>732.0</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>2.195759e+06</td>\n",
       "      <td>3078.882462</td>\n",
       "      <td>164.589540</td>\n",
       "      <td>143.211753</td>\n",
       "      <td>130.704605</td>\n",
       "      <td>113.789493</td>\n",
       "      <td>2.509752e+06</td>\n",
       "      <td>3202.037760</td>\n",
       "      <td>-1.470469</td>\n",
       "      <td>47.184245</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38843</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>480000.00</td>\n",
       "      <td>44300</td>\n",
       "      <td>NANTES</td>\n",
       "      <td>123.00</td>\n",
       "      <td>Maison</td>\n",
       "      <td>123.0</td>\n",
       "      <td>6</td>\n",
       "      <td>123.0</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>2.195759e+06</td>\n",
       "      <td>3078.882462</td>\n",
       "      <td>164.589540</td>\n",
       "      <td>143.211753</td>\n",
       "      <td>130.704605</td>\n",
       "      <td>113.789493</td>\n",
       "      <td>2.509752e+06</td>\n",
       "      <td>3202.037760</td>\n",
       "      <td>-1.527843</td>\n",
       "      <td>47.233590</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38844</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>540500.00</td>\n",
       "      <td>44000</td>\n",
       "      <td>NANTES</td>\n",
       "      <td>130.00</td>\n",
       "      <td>Maison</td>\n",
       "      <td>130.0</td>\n",
       "      <td>6</td>\n",
       "      <td>119.0</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>2.195759e+06</td>\n",
       "      <td>3078.882462</td>\n",
       "      <td>164.589540</td>\n",
       "      <td>143.211753</td>\n",
       "      <td>130.704605</td>\n",
       "      <td>113.789493</td>\n",
       "      <td>2.509752e+06</td>\n",
       "      <td>3202.037760</td>\n",
       "      <td>-1.537851</td>\n",
       "      <td>47.224717</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38847</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>550000.00</td>\n",
       "      <td>44200</td>\n",
       "      <td>NANTES</td>\n",
       "      <td>45.00</td>\n",
       "      <td>Appartement</td>\n",
       "      <td>45.0</td>\n",
       "      <td>2</td>\n",
       "      <td>140.0</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>2.195759e+06</td>\n",
       "      <td>3078.882462</td>\n",
       "      <td>164.589540</td>\n",
       "      <td>143.211753</td>\n",
       "      <td>130.704605</td>\n",
       "      <td>113.789493</td>\n",
       "      <td>2.509752e+06</td>\n",
       "      <td>3202.037760</td>\n",
       "      <td>-1.555181</td>\n",
       "      <td>47.206629</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38848</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>575000.00</td>\n",
       "      <td>44300</td>\n",
       "      <td>NANTES</td>\n",
       "      <td>124.00</td>\n",
       "      <td>Maison</td>\n",
       "      <td>124.0</td>\n",
       "      <td>6</td>\n",
       "      <td>747.0</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>2.195759e+06</td>\n",
       "      <td>3078.882462</td>\n",
       "      <td>164.589540</td>\n",
       "      <td>143.211753</td>\n",
       "      <td>130.704605</td>\n",
       "      <td>113.789493</td>\n",
       "      <td>2.509752e+06</td>\n",
       "      <td>3202.037760</td>\n",
       "      <td>-1.531380</td>\n",
       "      <td>47.243563</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38849</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>600000.00</td>\n",
       "      <td>44300</td>\n",
       "      <td>NANTES</td>\n",
       "      <td>240.00</td>\n",
       "      <td>Maison</td>\n",
       "      <td>240.0</td>\n",
       "      <td>9</td>\n",
       "      <td>546.0</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>2.195759e+06</td>\n",
       "      <td>3078.882462</td>\n",
       "      <td>164.589540</td>\n",
       "      <td>143.211753</td>\n",
       "      <td>130.704605</td>\n",
       "      <td>113.789493</td>\n",
       "      <td>2.509752e+06</td>\n",
       "      <td>3202.037760</td>\n",
       "      <td>-1.574157</td>\n",
       "      <td>47.237685</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38854</th>\n",
       "      <td>2018-12-29</td>\n",
       "      <td>435000.00</td>\n",
       "      <td>44240</td>\n",
       "      <td>LA-CHAPELLE-SUR-ERDRE</td>\n",
       "      <td>89.00</td>\n",
       "      <td>Maison</td>\n",
       "      <td>89.0</td>\n",
       "      <td>4</td>\n",
       "      <td>486.0</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>2.195759e+06</td>\n",
       "      <td>3078.882462</td>\n",
       "      <td>164.589540</td>\n",
       "      <td>143.211753</td>\n",
       "      <td>130.704605</td>\n",
       "      <td>113.789493</td>\n",
       "      <td>2.509752e+06</td>\n",
       "      <td>3202.037760</td>\n",
       "      <td>-1.547252</td>\n",
       "      <td>47.302716</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38855</th>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>114000.00</td>\n",
       "      <td>44400</td>\n",
       "      <td>REZE</td>\n",
       "      <td>39.00</td>\n",
       "      <td>Appartement</td>\n",
       "      <td>39.0</td>\n",
       "      <td>2</td>\n",
       "      <td>39.0</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>2.195759e+06</td>\n",
       "      <td>3078.882462</td>\n",
       "      <td>164.589540</td>\n",
       "      <td>143.211753</td>\n",
       "      <td>130.704605</td>\n",
       "      <td>113.789493</td>\n",
       "      <td>2.509752e+06</td>\n",
       "      <td>3202.037760</td>\n",
       "      <td>-1.542768</td>\n",
       "      <td>47.183780</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38856</th>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>169200.00</td>\n",
       "      <td>44300</td>\n",
       "      <td>NANTES</td>\n",
       "      <td>63.00</td>\n",
       "      <td>Appartement</td>\n",
       "      <td>63.0</td>\n",
       "      <td>3</td>\n",
       "      <td>63.0</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>2.195759e+06</td>\n",
       "      <td>3078.882462</td>\n",
       "      <td>164.589540</td>\n",
       "      <td>143.211753</td>\n",
       "      <td>130.704605</td>\n",
       "      <td>113.789493</td>\n",
       "      <td>2.509752e+06</td>\n",
       "      <td>3202.037760</td>\n",
       "      <td>-1.508005</td>\n",
       "      <td>47.241917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38857</th>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>195000.00</td>\n",
       "      <td>44100</td>\n",
       "      <td>NANTES</td>\n",
       "      <td>40.00</td>\n",
       "      <td>Appartement</td>\n",
       "      <td>40.0</td>\n",
       "      <td>2</td>\n",
       "      <td>158.0</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>2.195759e+06</td>\n",
       "      <td>3078.882462</td>\n",
       "      <td>164.589540</td>\n",
       "      <td>143.211753</td>\n",
       "      <td>130.704605</td>\n",
       "      <td>113.789493</td>\n",
       "      <td>2.509752e+06</td>\n",
       "      <td>3202.037760</td>\n",
       "      <td>-1.577960</td>\n",
       "      <td>47.213966</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38858</th>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>195000.00</td>\n",
       "      <td>44100</td>\n",
       "      <td>NANTES</td>\n",
       "      <td>45.00</td>\n",
       "      <td>Appartement</td>\n",
       "      <td>45.0</td>\n",
       "      <td>1</td>\n",
       "      <td>158.0</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>2.195759e+06</td>\n",
       "      <td>3078.882462</td>\n",
       "      <td>164.589540</td>\n",
       "      <td>143.211753</td>\n",
       "      <td>130.704605</td>\n",
       "      <td>113.789493</td>\n",
       "      <td>2.509752e+06</td>\n",
       "      <td>3202.037760</td>\n",
       "      <td>-1.577960</td>\n",
       "      <td>47.213966</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38859</th>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>355000.00</td>\n",
       "      <td>44300</td>\n",
       "      <td>NANTES</td>\n",
       "      <td>102.00</td>\n",
       "      <td>Maison</td>\n",
       "      <td>102.0</td>\n",
       "      <td>6</td>\n",
       "      <td>287.0</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>2.195759e+06</td>\n",
       "      <td>3078.882462</td>\n",
       "      <td>164.589540</td>\n",
       "      <td>143.211753</td>\n",
       "      <td>130.704605</td>\n",
       "      <td>113.789493</td>\n",
       "      <td>2.509752e+06</td>\n",
       "      <td>3202.037760</td>\n",
       "      <td>-1.517638</td>\n",
       "      <td>47.246452</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38861</th>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>375000.00</td>\n",
       "      <td>44200</td>\n",
       "      <td>NANTES</td>\n",
       "      <td>89.75</td>\n",
       "      <td>Appartement</td>\n",
       "      <td>70.0</td>\n",
       "      <td>3</td>\n",
       "      <td>70.0</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>2.195759e+06</td>\n",
       "      <td>3078.882462</td>\n",
       "      <td>164.589540</td>\n",
       "      <td>143.211753</td>\n",
       "      <td>130.704605</td>\n",
       "      <td>113.789493</td>\n",
       "      <td>2.509752e+06</td>\n",
       "      <td>3202.037760</td>\n",
       "      <td>-1.546697</td>\n",
       "      <td>47.205517</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38862</th>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>576000.00</td>\n",
       "      <td>44300</td>\n",
       "      <td>NANTES</td>\n",
       "      <td>95.00</td>\n",
       "      <td>Maison</td>\n",
       "      <td>95.0</td>\n",
       "      <td>5</td>\n",
       "      <td>162.0</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>2.195759e+06</td>\n",
       "      <td>3078.882462</td>\n",
       "      <td>164.589540</td>\n",
       "      <td>143.211753</td>\n",
       "      <td>130.704605</td>\n",
       "      <td>113.789493</td>\n",
       "      <td>2.509752e+06</td>\n",
       "      <td>3202.037760</td>\n",
       "      <td>-1.566589</td>\n",
       "      <td>47.237513</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>30102 rows × 177 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      date_mutation  valeur_fonciere  code_postal  nom_commune  \\\n",
       "0        2014-01-02         107000.0        44800  ST-HERBLAIN   \n",
       "2        2014-01-02         111500.0        44000       NANTES   \n",
       "3        2014-01-02         130000.0        44300       NANTES   \n",
       "4        2014-01-02         190000.0        44300       NANTES   \n",
       "5        2014-01-02         194400.0        44100       NANTES   \n",
       "...             ...              ...          ...          ...   \n",
       "38857    2018-12-31         195000.0        44100       NANTES   \n",
       "38858    2018-12-31         195000.0        44100       NANTES   \n",
       "38859    2018-12-31         355000.0        44300       NANTES   \n",
       "38861    2018-12-31         375000.0        44200       NANTES   \n",
       "38862    2018-12-31         576000.0        44300       NANTES   \n",
       "\n",
       "       surface_carrez   type_local  surface_reelle_bati  \\\n",
       "0               45.80  Appartement                 46.0   \n",
       "2               44.31  Appartement                 45.0   \n",
       "3               49.76  Appartement                 50.0   \n",
       "4               63.31  Appartement                 62.0   \n",
       "5               84.00  Appartement                 84.0   \n",
       "...               ...          ...                  ...   \n",
       "38857           40.00  Appartement                 40.0   \n",
       "38858           45.00  Appartement                 45.0   \n",
       "38859          102.00       Maison                102.0   \n",
       "38861           89.75  Appartement                 70.0   \n",
       "38862           95.00       Maison                 95.0   \n",
       "\n",
       "       nombre_pieces_principales  surface_terrain  mois  ...  \\\n",
       "0                              2             46.0     1  ...   \n",
       "2                              2             45.0     1  ...   \n",
       "3                              2             50.0     1  ...   \n",
       "4                              3             62.0     1  ...   \n",
       "5                              4             84.0     1  ...   \n",
       "...                          ...              ...   ...  ...   \n",
       "38857                          2            158.0    12  ...   \n",
       "38858                          1            158.0    12  ...   \n",
       "38859                          6            287.0    12  ...   \n",
       "38861                          3             70.0    12  ...   \n",
       "38862                          5            162.0    12  ...   \n",
       "\n",
       "       0-3-taux_epargne  0-3-taux_epargne_financier     0-4-rdb  0-4-rdb_uc  \\\n",
       "0          1.771116e+05                 1320.383769  149.129082  133.560584   \n",
       "2          1.771116e+05                 1320.383769  149.129082  133.560584   \n",
       "3          1.771116e+05                 1320.383769  149.129082  133.560584   \n",
       "4          1.771116e+05                 1320.383769  149.129082  133.560584   \n",
       "5          1.771116e+05                 1320.383769  149.129082  133.560584   \n",
       "...                 ...                         ...         ...         ...   \n",
       "38857      2.195759e+06                 3078.882462  164.589540  143.211753   \n",
       "38858      2.195759e+06                 3078.882462  164.589540  143.211753   \n",
       "38859      2.195759e+06                 3078.882462  164.589540  143.211753   \n",
       "38861      2.195759e+06                 3078.882462  164.589540  143.211753   \n",
       "38862      2.195759e+06                 3078.882462  164.589540  143.211753   \n",
       "\n",
       "       0-4-pa_rdb  0-4-pa_rdb_uc  0-4-taux_epargne  \\\n",
       "0      122.508389     109.783356      2.010217e+05   \n",
       "2      122.508389     109.783356      2.010217e+05   \n",
       "3      122.508389     109.783356      2.010217e+05   \n",
       "4      122.508389     109.783356      2.010217e+05   \n",
       "5      122.508389     109.783356      2.010217e+05   \n",
       "...           ...            ...               ...   \n",
       "38857  130.704605     113.789493      2.509752e+06   \n",
       "38858  130.704605     113.789493      2.509752e+06   \n",
       "38859  130.704605     113.789493      2.509752e+06   \n",
       "38861  130.704605     113.789493      2.509752e+06   \n",
       "38862  130.704605     113.789493      2.509752e+06   \n",
       "\n",
       "       0-4-taux_epargne_financier  longitude   latitude  \n",
       "0                     1371.878736  -1.644254  47.207462  \n",
       "2                     1371.878736  -1.548747  47.220961  \n",
       "3                     1371.878736  -1.566879  47.234022  \n",
       "4                     1371.878736  -1.545120  47.251066  \n",
       "5                     1371.878736  -1.603261  47.209692  \n",
       "...                           ...        ...        ...  \n",
       "38857                 3202.037760  -1.577960  47.213966  \n",
       "38858                 3202.037760  -1.577960  47.213966  \n",
       "38859                 3202.037760  -1.517638  47.246452  \n",
       "38861                 3202.037760  -1.546697  47.205517  \n",
       "38862                 3202.037760  -1.566589  47.237513  \n",
       "\n",
       "[30102 rows x 177 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "# load GeoJSON file containing sectors\n",
    "with open('./data/maps/nantes.geojson') as f:\n",
    "    nantes_metropolis_geojson = json.load(f)\n",
    "\n",
    "\n",
    "def checkNameAndPostalCode(longitude, latitude, postal_code, town_name):\n",
    "    # construct point based on lon/lat returned by geocoder\n",
    "    point = Point(longitude, latitude)\n",
    "\n",
    "    # check each polygon to see if it contains the point\n",
    "    for feature in nantes_metropolis_geojson['features']:\n",
    "        polygon = shape(feature['geometry'])\n",
    "        if polygon.contains(point):\n",
    "            if feature['properties']['code_postal'] == postal_code:\n",
    "                if feature['properties']['nom'] == town_name:\n",
    "                    return (True, \"OK\")\n",
    "                else:\n",
    "                    return (False, \"coordinate != town_name\")\n",
    "            else:\n",
    "                return (False, \"coordinate != postal_code\")\n",
    "    \n",
    "    return (False, \"not found\", longitude, latitude, postal_code, town_name)\n",
    "\n",
    "def checkDatasetLocation(dataset):\n",
    "    ok = 0\n",
    "    error = 0\n",
    "    not_found_error = 0\n",
    "    postal_code_error = 0\n",
    "    town_name_error = 0\n",
    "\n",
    "    town_list = []\n",
    "    postal_list = []\n",
    "    for i, row in dataset.iterrows():\n",
    "        response = checkNameAndPostalCode(row['longitude'], row['latitude'], row['code_postal'], row['nom_commune'])\n",
    "        \n",
    "        if not response[0]:\n",
    "            if response[1] == \"coordinate != town_name\":\n",
    "                town_name_error += 1\n",
    "                town_list.append(i)\n",
    "            elif response[1] == \"coordinate != postal_code\":\n",
    "                postal_code_error += 1\n",
    "                postal_list.append(i)\n",
    "            else:\n",
    "                not_found_error += 1\n",
    "                res.append(response[2:])\n",
    "\n",
    "            error += 1\n",
    "        else:\n",
    "            ok += 1\n",
    "    \n",
    "    print(\"Town error : {}\".format(town_name_error))\n",
    "    print(\"Postal error : {}\".format(postal_code_error))\n",
    "    print(\"Not found error : {}\".format(not_found_error))\n",
    "    print(\"Total error : {}\".format(error))\n",
    "    print(\"Ok : {}\".format(ok))\n",
    "    \n",
    "    return town_list, postal_list\n",
    "\n",
    "\n",
    "def fixNameAndPostalCode(dataset):\n",
    "    df = dataset.copy()\n",
    "\n",
    "    for i, row in dataset.iterrows():\n",
    "        # construct point based on lon/lat returned by geocoder\n",
    "        point = Point(row['longitude'], row['latitude'])\n",
    "        \n",
    "        for feature in nantes_metropolis_geojson['features']:\n",
    "            polygon = shape(feature['geometry'])\n",
    "            if polygon.contains(point):\n",
    "                df.loc[i,'code_postal'] = feature['properties']['code_postal']\n",
    "                df.loc[i,'nom_commune'] = feature['properties']['nom']\n",
    "    return df\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(True, 'OK')\n",
      "(False, 'coordinate != town_name')\n"
     ]
    }
   ],
   "source": [
    "print(checkNameAndPostalCode(df.iloc[0]['longitude'], df.iloc[0]['latitude'], df.iloc[0]['code_postal'], df.iloc[0]['nom_commune']))\n",
    "print(checkNameAndPostalCode(df.iloc[1]['longitude'], df.iloc[1]['latitude'], df.iloc[1]['code_postal'], df.iloc[1]['nom_commune']))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Town error : 12761\n",
      "Postal error : 1237\n",
      "Not found error : 0\n",
      "Total error : 13998\n",
      "Ok : 16104\n"
     ]
    }
   ],
   "source": [
    "index_town_list, index_postal_list = checkDatasetLocation(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "NANTES    12761\n",
       "Name: nom_commune, dtype: int64"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df.index.isin(index_town_list)]['nom_commune'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "NANTES    1237\n",
       "Name: nom_commune, dtype: int64"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df.index.isin(index_postal_list)]['nom_commune'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = fixNameAndPostalCode(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Town error : 0\n",
      "Postal error : 0\n",
      "Not found error : 0\n",
      "Total error : 0\n",
      "Ok : 30102\n"
     ]
    }
   ],
   "source": [
    "index_town_list, index_postal_list = checkDatasetLocation(df)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Encodage des colonnes"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Nous ne disposons que de 3 types, nous allons regarder de plus proche le type 'O'. Nous allons sélectionner toutes les colonnes concernées."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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>date_mutation</th>\n",
       "      <th>nom_commune</th>\n",
       "      <th>type_local</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2014-01-02</td>\n",
       "      <td>ST-HERBLAIN</td>\n",
       "      <td>Appartement</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2014-01-02</td>\n",
       "      <td>MALAKOFF-SAINT_DONATIEN</td>\n",
       "      <td>Appartement</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2014-01-02</td>\n",
       "      <td>BREIL-BARBERIE</td>\n",
       "      <td>Appartement</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2014-01-02</td>\n",
       "      <td>NANTES_NORD</td>\n",
       "      <td>Appartement</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2014-01-02</td>\n",
       "      <td>BELLEVUE-CHANTENAY-SAINTE_ANNE</td>\n",
       "      <td>Appartement</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2014-01-02</td>\n",
       "      <td>DOULON-BOTTIERE</td>\n",
       "      <td>Maison</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2014-01-03</td>\n",
       "      <td>REZE</td>\n",
       "      <td>Appartement</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2014-01-03</td>\n",
       "      <td>MALAKOFF-SAINT_DONATIEN</td>\n",
       "      <td>Appartement</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2014-01-03</td>\n",
       "      <td>NANTES_NORD</td>\n",
       "      <td>Maison</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2014-01-03</td>\n",
       "      <td>NANTES_NORD</td>\n",
       "      <td>Maison</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2014-01-03</td>\n",
       "      <td>VERTOU</td>\n",
       "      <td>Maison</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2014-01-03</td>\n",
       "      <td>NANTES_ERDRE</td>\n",
       "      <td>Maison</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2014-01-03</td>\n",
       "      <td>ST-SEBASTIEN</td>\n",
       "      <td>Maison</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2014-01-03</td>\n",
       "      <td>ST-HERBLAIN</td>\n",
       "      <td>Maison</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2014-01-03</td>\n",
       "      <td>LES-SORINIERES</td>\n",
       "      <td>Maison</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2014-01-03</td>\n",
       "      <td>VERTOU</td>\n",
       "      <td>Maison</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2014-01-03</td>\n",
       "      <td>LA-CHAPELLE-SUR-ERDRE</td>\n",
       "      <td>Maison</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2014-01-03</td>\n",
       "      <td>REZE</td>\n",
       "      <td>Maison</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2014-01-03</td>\n",
       "      <td>MALAKOFF-SAINT_DONATIEN</td>\n",
       "      <td>Maison</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2014-01-03</td>\n",
       "      <td>HAUTS_PAVES-SAINT_FELIX</td>\n",
       "      <td>Appartement</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2014-01-06</td>\n",
       "      <td>MALAKOFF-SAINT_DONATIEN</td>\n",
       "      <td>Appartement</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2014-01-06</td>\n",
       "      <td>NANTES_ERDRE</td>\n",
       "      <td>Appartement</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2014-01-06</td>\n",
       "      <td>NANTES_NORD</td>\n",
       "      <td>Maison</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>2014-01-06</td>\n",
       "      <td>CENTRE_VILLE</td>\n",
       "      <td>Appartement</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>2014-01-06</td>\n",
       "      <td>THOUARE-SUR-LOIRE</td>\n",
       "      <td>Maison</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>2014-01-06</td>\n",
       "      <td>CENTRE_VILLE</td>\n",
       "      <td>Appartement</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>2014-01-06</td>\n",
       "      <td>COUERON</td>\n",
       "      <td>Maison</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>2014-01-06</td>\n",
       "      <td>COUERON</td>\n",
       "      <td>Maison</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>2014-01-06</td>\n",
       "      <td>DOULON-BOTTIERE</td>\n",
       "      <td>Maison</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>2014-01-06</td>\n",
       "      <td>ORVAULT</td>\n",
       "      <td>Maison</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38824</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>REZE</td>\n",
       "      <td>Appartement</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38827</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>BOUAYE</td>\n",
       "      <td>Maison</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38828</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>NANTES_SUD</td>\n",
       "      <td>Maison</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38829</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>SAUTRON</td>\n",
       "      <td>Maison</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38830</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>SAINTE-LUCE-SUR-LOIRE</td>\n",
       "      <td>Maison</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38831</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>ORVAULT</td>\n",
       "      <td>Maison</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38832</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>REZE</td>\n",
       "      <td>Maison</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38833</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>REZE</td>\n",
       "      <td>Maison</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38834</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>NANTES_ERDRE</td>\n",
       "      <td>Maison</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38835</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>HAUTS_PAVES-SAINT_FELIX</td>\n",
       "      <td>Maison</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38836</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>NANTES_ERDRE</td>\n",
       "      <td>Maison</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38837</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>NANTES_NORD</td>\n",
       "      <td>Maison</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38838</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>DERVALLIERES-ZOLA</td>\n",
       "      <td>Maison</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38839</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>ST-HERBLAIN</td>\n",
       "      <td>Maison</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38840</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>REZE</td>\n",
       "      <td>Maison</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38841</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>BASSE-GOULAINE</td>\n",
       "      <td>Maison</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38842</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>VERTOU</td>\n",
       "      <td>Maison</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38843</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>DOULON-BOTTIERE</td>\n",
       "      <td>Maison</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38844</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>MALAKOFF-SAINT_DONATIEN</td>\n",
       "      <td>Maison</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38847</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>ILE_DE_NANTES</td>\n",
       "      <td>Appartement</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38848</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>NANTES_ERDRE</td>\n",
       "      <td>Maison</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38849</th>\n",
       "      <td>2018-12-28</td>\n",
       "      <td>BREIL-BARBERIE</td>\n",
       "      <td>Maison</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38854</th>\n",
       "      <td>2018-12-29</td>\n",
       "      <td>LA-CHAPELLE-SUR-ERDRE</td>\n",
       "      <td>Maison</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38855</th>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>REZE</td>\n",
       "      <td>Appartement</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38856</th>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>DOULON-BOTTIERE</td>\n",
       "      <td>Appartement</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38857</th>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>DERVALLIERES-ZOLA</td>\n",
       "      <td>Appartement</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38858</th>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>DERVALLIERES-ZOLA</td>\n",
       "      <td>Appartement</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38859</th>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>DOULON-BOTTIERE</td>\n",
       "      <td>Maison</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38861</th>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>ILE_DE_NANTES</td>\n",
       "      <td>Appartement</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38862</th>\n",
       "      <td>2018-12-31</td>\n",
       "      <td>BREIL-BARBERIE</td>\n",
       "      <td>Maison</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>30102 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      date_mutation                     nom_commune   type_local\n",
       "0        2014-01-02                     ST-HERBLAIN  Appartement\n",
       "2        2014-01-02         MALAKOFF-SAINT_DONATIEN  Appartement\n",
       "3        2014-01-02                  BREIL-BARBERIE  Appartement\n",
       "4        2014-01-02                     NANTES_NORD  Appartement\n",
       "5        2014-01-02  BELLEVUE-CHANTENAY-SAINTE_ANNE  Appartement\n",
       "...             ...                             ...          ...\n",
       "38857    2018-12-31               DERVALLIERES-ZOLA  Appartement\n",
       "38858    2018-12-31               DERVALLIERES-ZOLA  Appartement\n",
       "38859    2018-12-31                 DOULON-BOTTIERE       Maison\n",
       "38861    2018-12-31                   ILE_DE_NANTES  Appartement\n",
       "38862    2018-12-31                  BREIL-BARBERIE       Maison\n",
       "\n",
       "[30102 rows x 3 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.select_dtypes(exclude=['float64', 'int64'])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Nous ne nécessitons pas de la colonne `date_mutation`, nous avons déjà isolé l'année et le mois dans d'autres colonnes. Il nous suffit donc d'encoder les colonnes `nom_commune` et `type_local`. En faisant attentention au début, on peut aussi remarquer la colonne `code_postal`, celle-ci doit aussi être encodé."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Dropping date_mutation columns\n",
    "df.drop('date_mutation', axis = 1, inplace=True)\n",
    "\n",
    "# One hot encoding `nom_commune` column\n",
    "one_hot = pd.get_dummies(df['nom_commune'])\n",
    "df.drop('nom_commune', axis = 1, inplace=True)\n",
    "df = df.join(one_hot)\n",
    "\n",
    "# One hot encoding `type_local` column\n",
    "one_hot = pd.get_dummies(df['type_local'])\n",
    "df.drop('type_local', axis = 1, inplace=True)\n",
    "df = df.join(one_hot)\n",
    "\n",
    "# One hot encoding `type_local` column\n",
    "one_hot = pd.get_dummies(df['code_postal'])\n",
    "df.drop('code_postal', axis = 1, inplace=True)\n",
    "df = df.join(one_hot)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "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>valeur_fonciere</th>\n",
       "      <th>surface_carrez</th>\n",
       "      <th>surface_reelle_bati</th>\n",
       "      <th>nombre_pieces_principales</th>\n",
       "      <th>surface_terrain</th>\n",
       "      <th>mois</th>\n",
       "      <th>annee</th>\n",
       "      <th>mois_sin</th>\n",
       "      <th>mois_cos</th>\n",
       "      <th>foot/vie_courante/townhall</th>\n",
       "      <th>...</th>\n",
       "      <th>44620</th>\n",
       "      <th>44640</th>\n",
       "      <th>44700</th>\n",
       "      <th>44710</th>\n",
       "      <th>44800</th>\n",
       "      <th>44830</th>\n",
       "      <th>44840</th>\n",
       "      <th>44860</th>\n",
       "      <th>44880</th>\n",
       "      <th>44980</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>107000.0</td>\n",
       "      <td>45.80</td>\n",
       "      <td>46.0</td>\n",
       "      <td>2</td>\n",
       "      <td>46.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2014</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.866025</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>111500.0</td>\n",
       "      <td>44.31</td>\n",
       "      <td>45.0</td>\n",
       "      <td>2</td>\n",
       "      <td>45.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2014</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.866025</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>130000.0</td>\n",
       "      <td>49.76</td>\n",
       "      <td>50.0</td>\n",
       "      <td>2</td>\n",
       "      <td>50.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2014</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.866025</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>190000.0</td>\n",
       "      <td>63.31</td>\n",
       "      <td>62.0</td>\n",
       "      <td>3</td>\n",
       "      <td>62.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2014</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.866025</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>194400.0</td>\n",
       "      <td>84.00</td>\n",
       "      <td>84.0</td>\n",
       "      <td>4</td>\n",
       "      <td>84.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2014</td>\n",
       "      <td>0.5</td>\n",
       "      <td>0.866025</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 232 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   valeur_fonciere  surface_carrez  surface_reelle_bati  \\\n",
       "0         107000.0           45.80                 46.0   \n",
       "2         111500.0           44.31                 45.0   \n",
       "3         130000.0           49.76                 50.0   \n",
       "4         190000.0           63.31                 62.0   \n",
       "5         194400.0           84.00                 84.0   \n",
       "\n",
       "   nombre_pieces_principales  surface_terrain  mois  annee  mois_sin  \\\n",
       "0                          2             46.0     1   2014       0.5   \n",
       "2                          2             45.0     1   2014       0.5   \n",
       "3                          2             50.0     1   2014       0.5   \n",
       "4                          3             62.0     1   2014       0.5   \n",
       "5                          4             84.0     1   2014       0.5   \n",
       "\n",
       "   mois_cos  foot/vie_courante/townhall  ...  44620  44640  44700  44710  \\\n",
       "0  0.866025                         1.0  ...      0      0      0      0   \n",
       "2  0.866025                         2.0  ...      0      0      0      0   \n",
       "3  0.866025                         0.0  ...      0      0      0      0   \n",
       "4  0.866025                         0.0  ...      0      0      0      0   \n",
       "5  0.866025                         1.0  ...      0      0      0      0   \n",
       "\n",
       "   44800  44830  44840  44860  44880  44980  \n",
       "0      1      0      0      0      0      0  \n",
       "2      0      0      0      0      0      0  \n",
       "3      0      0      0      0      0      0  \n",
       "4      0      0      0      0      0      0  \n",
       "5      0      0      0      0      0      0  \n",
       "\n",
       "[5 rows x 232 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv('data/datasets/dataset_ready_v2_lonlat.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.drop(['longitude','latitude','mois'], axis=1).to_csv('data/datasets/dataset_ready_v2.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}