Fichiers.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "markdown",
   "source": [
    "## Paris"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%% md\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\arceb\\AppData\\Local\\Temp\\ipykernel_29028\\2847866414.py:1: DtypeWarning: Columns (11,12) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  dfd = pd.read_csv(r'C:\\Users\\arceb\\PycharmProjects\\pythonProject/MGP.csv', index_col = 0)\n"
     ]
    },
    {
     "data": {
      "text/plain": "            Numéro Unique  RM Moyennes  \\\n0      111031350487375056       2267.0   \n1      1110517673443GDPUB       2439.0   \n2      1110616406245GDPUB       3081.0   \n3      1110717734339GDPUB       1900.0   \n4      111091362060710037       1580.0   \n...                   ...          ...   \n36133  1111217844990AL010       1397.0   \n36134  1111217846410GDPUB       2336.0   \n36135  1111217847711AL004        956.0   \n36136  175031108722200002       1804.0   \n36137  175050327042800002       1855.0   \n\n       Ressources imposables mensuelles moyennes (RI)  \\\n0                                              2267.0   \n1                                              2439.0   \n2                                              3081.0   \n3                                              1900.0   \n4                                              1580.0   \n...                                               ...   \n36133                                          1213.0   \n36134                                          2336.0   \n36135                                           956.0   \n36136                                          1804.0   \n36137                                          1855.0   \n\n       Prestations familiales et sociales mensuelles moyennes (PFS)  Ri + PFS  \\\n0                                                    0.0               2267.0   \n1                                                    0.0               2439.0   \n2                                                    0.0               3081.0   \n3                                                    0.0               1900.0   \n4                                                    0.0               1580.0   \n...                                                  ...                  ...   \n36133                                              184.0               1397.0   \n36134                                                0.0               2336.0   \n36135                                                0.0                956.0   \n36136                                                0.0               1804.0   \n36137                                                0.0               1855.0   \n\n                           région Date création demande Date de la radiation  \\\n0      Provence-Alpes-Côte d'Azur            2013-03-19           2018-07-11   \n1      Provence-Alpes-Côte d'Azur            2017-05-16           2018-02-15   \n2      Provence-Alpes-Côte d'Azur            2016-06-23           2018-07-20   \n3      Provence-Alpes-Côte d'Azur            2017-07-31           2018-01-09   \n4      Provence-Alpes-Côte d'Azur            2013-09-06           2018-09-05   \n...                           ...                   ...                  ...   \n36133                    Picardie            2017-12-20           2018-05-04   \n36134                    Picardie            2017-12-24           2018-02-16   \n36135                    Picardie            2017-12-29           2018-03-28   \n36136                    Picardie            2011-03-16           2018-01-31   \n36137                    Picardie            2003-05-21           2018-10-11   \n\n       Age demandeur Situation familiale  ... Code Géographique  \\\n0                 47         Célibataire  ...             75120   \n1                 34         Célibataire  ...             92035   \n2                 42           Marié (e)  ...             92019   \n3                 36         Célibataire  ...             93010   \n4                 26         Célibataire  ...             92012   \n...              ...                 ...  ...               ...   \n36133             24           Pacsé (e)  ...             75118   \n36134             26        Concubin (e)  ...             75115   \n36135             45         Célibataire  ...             94017   \n36136             53         Divorcé (e)  ...             75118   \n36137             46         Célibataire  ...             75114   \n\n      Région du logement attribué Type du logement attribué  Est en QPV  \\\n0                   Ile-de-France                        T2         Non   \n1                   Ile-de-France                        T2         Non   \n2                   Ile-de-France                        T3         Non   \n3                   Ile-de-France                        T2         Non   \n4                   Ile-de-France                        T2         Non   \n...                           ...                       ...         ...   \n36133               Ile-de-France                        T3         Non   \n36134               Ile-de-France                        T3         Non   \n36135               Ile-de-France                        T1         Oui   \n36136               Ile-de-France                        T3         Non   \n36137               Ile-de-France                        T1         Non   \n\n      Surface du logement attribué    Statut DALO  \\\n0                               35  Non renseigné   \n1                               53  Non renseigné   \n2                               70  Non renseigné   \n3                               53  Non renseigné   \n4                               57   Actif relogé   \n...                            ...            ...   \n36133                           65  Non renseigné   \n36134                           56  Non renseigné   \n36135                           42  Non renseigné   \n36136                           49  Non renseigné   \n36137                           33  Non renseigné   \n\n      Date de la décision DALO\\n\\n  Accompagnement social  Diagnostic social  \\\n0                              NaN                    Non                Non   \n1                              NaN                    Non                Non   \n2                              NaN                    Non                Non   \n3                              NaN                    Non                Non   \n4                       2016-04-13                    Non                Non   \n...                            ...                    ...                ...   \n36133                          NaN                    Non                Non   \n36134                          NaN                    Non                Non   \n36135                          NaN                    Non                Non   \n36136                          NaN                    Non                Non   \n36137                          NaN                    Non                Non   \n\n                                            Réservataire  \n0      Contingent des collectivités territoriales, de...  \n1                                        Hors contingent  \n2                        Contingent autres réservataires  \n3      Contingent préfet fonctionnaires et agents pub...  \n4                                        Action Logement  \n...                                                  ...  \n36133                                    Action Logement  \n36134  Contingent des collectivités territoriales, de...  \n36135                                    Action Logement  \n36136  Contingent des collectivités territoriales, de...  \n36137                    Contingent autres réservataires  \n\n[36138 rows x 42 columns]",
      "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>Numéro Unique</th>\n      <th>RM Moyennes</th>\n      <th>Ressources imposables mensuelles moyennes (RI)</th>\n      <th>Prestations familiales et sociales mensuelles moyennes (PFS)</th>\n      <th>Ri + PFS</th>\n      <th>région</th>\n      <th>Date création demande</th>\n      <th>Date de la radiation</th>\n      <th>Age demandeur</th>\n      <th>Situation familiale</th>\n      <th>...</th>\n      <th>Code Géographique</th>\n      <th>Région du logement attribué</th>\n      <th>Type du logement attribué</th>\n      <th>Est en QPV</th>\n      <th>Surface du logement attribué</th>\n      <th>Statut DALO</th>\n      <th>Date de la décision DALO\\n\\n</th>\n      <th>Accompagnement social</th>\n      <th>Diagnostic social</th>\n      <th>Réservataire</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>111031350487375056</td>\n      <td>2267.0</td>\n      <td>2267.0</td>\n      <td>0.0</td>\n      <td>2267.0</td>\n      <td>Provence-Alpes-Côte d'Azur</td>\n      <td>2013-03-19</td>\n      <td>2018-07-11</td>\n      <td>47</td>\n      <td>Célibataire</td>\n      <td>...</td>\n      <td>75120</td>\n      <td>Ile-de-France</td>\n      <td>T2</td>\n      <td>Non</td>\n      <td>35</td>\n      <td>Non renseigné</td>\n      <td>NaN</td>\n      <td>Non</td>\n      <td>Non</td>\n      <td>Contingent des collectivités territoriales, de...</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>1110517673443GDPUB</td>\n      <td>2439.0</td>\n      <td>2439.0</td>\n      <td>0.0</td>\n      <td>2439.0</td>\n      <td>Provence-Alpes-Côte d'Azur</td>\n      <td>2017-05-16</td>\n      <td>2018-02-15</td>\n      <td>34</td>\n      <td>Célibataire</td>\n      <td>...</td>\n      <td>92035</td>\n      <td>Ile-de-France</td>\n      <td>T2</td>\n      <td>Non</td>\n      <td>53</td>\n      <td>Non renseigné</td>\n      <td>NaN</td>\n      <td>Non</td>\n      <td>Non</td>\n      <td>Hors contingent</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>1110616406245GDPUB</td>\n      <td>3081.0</td>\n      <td>3081.0</td>\n      <td>0.0</td>\n      <td>3081.0</td>\n      <td>Provence-Alpes-Côte d'Azur</td>\n      <td>2016-06-23</td>\n      <td>2018-07-20</td>\n      <td>42</td>\n      <td>Marié (e)</td>\n      <td>...</td>\n      <td>92019</td>\n      <td>Ile-de-France</td>\n      <td>T3</td>\n      <td>Non</td>\n      <td>70</td>\n      <td>Non renseigné</td>\n      <td>NaN</td>\n      <td>Non</td>\n      <td>Non</td>\n      <td>Contingent autres réservataires</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>1110717734339GDPUB</td>\n      <td>1900.0</td>\n      <td>1900.0</td>\n      <td>0.0</td>\n      <td>1900.0</td>\n      <td>Provence-Alpes-Côte d'Azur</td>\n      <td>2017-07-31</td>\n      <td>2018-01-09</td>\n      <td>36</td>\n      <td>Célibataire</td>\n      <td>...</td>\n      <td>93010</td>\n      <td>Ile-de-France</td>\n      <td>T2</td>\n      <td>Non</td>\n      <td>53</td>\n      <td>Non renseigné</td>\n      <td>NaN</td>\n      <td>Non</td>\n      <td>Non</td>\n      <td>Contingent préfet fonctionnaires et agents pub...</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>111091362060710037</td>\n      <td>1580.0</td>\n      <td>1580.0</td>\n      <td>0.0</td>\n      <td>1580.0</td>\n      <td>Provence-Alpes-Côte d'Azur</td>\n      <td>2013-09-06</td>\n      <td>2018-09-05</td>\n      <td>26</td>\n      <td>Célibataire</td>\n      <td>...</td>\n      <td>92012</td>\n      <td>Ile-de-France</td>\n      <td>T2</td>\n      <td>Non</td>\n      <td>57</td>\n      <td>Actif relogé</td>\n      <td>2016-04-13</td>\n      <td>Non</td>\n      <td>Non</td>\n      <td>Action Logement</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>36133</th>\n      <td>1111217844990AL010</td>\n      <td>1397.0</td>\n      <td>1213.0</td>\n      <td>184.0</td>\n      <td>1397.0</td>\n      <td>Picardie</td>\n      <td>2017-12-20</td>\n      <td>2018-05-04</td>\n      <td>24</td>\n      <td>Pacsé (e)</td>\n      <td>...</td>\n      <td>75118</td>\n      <td>Ile-de-France</td>\n      <td>T3</td>\n      <td>Non</td>\n      <td>65</td>\n      <td>Non renseigné</td>\n      <td>NaN</td>\n      <td>Non</td>\n      <td>Non</td>\n      <td>Action Logement</td>\n    </tr>\n    <tr>\n      <th>36134</th>\n      <td>1111217846410GDPUB</td>\n      <td>2336.0</td>\n      <td>2336.0</td>\n      <td>0.0</td>\n      <td>2336.0</td>\n      <td>Picardie</td>\n      <td>2017-12-24</td>\n      <td>2018-02-16</td>\n      <td>26</td>\n      <td>Concubin (e)</td>\n      <td>...</td>\n      <td>75115</td>\n      <td>Ile-de-France</td>\n      <td>T3</td>\n      <td>Non</td>\n      <td>56</td>\n      <td>Non renseigné</td>\n      <td>NaN</td>\n      <td>Non</td>\n      <td>Non</td>\n      <td>Contingent des collectivités territoriales, de...</td>\n    </tr>\n    <tr>\n      <th>36135</th>\n      <td>1111217847711AL004</td>\n      <td>956.0</td>\n      <td>956.0</td>\n      <td>0.0</td>\n      <td>956.0</td>\n      <td>Picardie</td>\n      <td>2017-12-29</td>\n      <td>2018-03-28</td>\n      <td>45</td>\n      <td>Célibataire</td>\n      <td>...</td>\n      <td>94017</td>\n      <td>Ile-de-France</td>\n      <td>T1</td>\n      <td>Oui</td>\n      <td>42</td>\n      <td>Non renseigné</td>\n      <td>NaN</td>\n      <td>Non</td>\n      <td>Non</td>\n      <td>Action Logement</td>\n    </tr>\n    <tr>\n      <th>36136</th>\n      <td>175031108722200002</td>\n      <td>1804.0</td>\n      <td>1804.0</td>\n      <td>0.0</td>\n      <td>1804.0</td>\n      <td>Picardie</td>\n      <td>2011-03-16</td>\n      <td>2018-01-31</td>\n      <td>53</td>\n      <td>Divorcé (e)</td>\n      <td>...</td>\n      <td>75118</td>\n      <td>Ile-de-France</td>\n      <td>T3</td>\n      <td>Non</td>\n      <td>49</td>\n      <td>Non renseigné</td>\n      <td>NaN</td>\n      <td>Non</td>\n      <td>Non</td>\n      <td>Contingent des collectivités territoriales, de...</td>\n    </tr>\n    <tr>\n      <th>36137</th>\n      <td>175050327042800002</td>\n      <td>1855.0</td>\n      <td>1855.0</td>\n      <td>0.0</td>\n      <td>1855.0</td>\n      <td>Picardie</td>\n      <td>2003-05-21</td>\n      <td>2018-10-11</td>\n      <td>46</td>\n      <td>Célibataire</td>\n      <td>...</td>\n      <td>75114</td>\n      <td>Ile-de-France</td>\n      <td>T1</td>\n      <td>Non</td>\n      <td>33</td>\n      <td>Non renseigné</td>\n      <td>NaN</td>\n      <td>Non</td>\n      <td>Non</td>\n      <td>Contingent autres réservataires</td>\n    </tr>\n  </tbody>\n</table>\n<p>36138 rows × 42 columns</p>\n</div>"
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfd = pd.read_csv(r'C:\\Users\\arceb\\PycharmProjects\\pythonProject/MGP.csv', index_col = 0)\n",
    "dfd=dfd.rename(columns={'Code de la commune attribuée': 'Code Géographique'})\n",
    "dfd"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "outputs": [],
   "source": [
    "#df['Code Géographique']=df['Code Géographique'].astype(str)\n",
    "dfd['Code Géographique']=dfd['Code Géographique'].astype(int)"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "outputs": [
    {
     "data": {
      "text/plain": "            Numéro Unique  RM Moyennes  \\\n0      111031350487375056       2267.0   \n1      1110517673443GDPUB       2439.0   \n2      1110616406245GDPUB       3081.0   \n3      1110717734339GDPUB       1900.0   \n4      111091362060710037       1580.0   \n...                   ...          ...   \n36133  1111217844990AL010       1397.0   \n36134  1111217846410GDPUB       2336.0   \n36135  1111217847711AL004        956.0   \n36136  175031108722200002       1804.0   \n36137  175050327042800002       1855.0   \n\n       Ressources imposables mensuelles moyennes (RI)  \\\n0                                              2267.0   \n1                                              2439.0   \n2                                              3081.0   \n3                                              1900.0   \n4                                              1580.0   \n...                                               ...   \n36133                                          1213.0   \n36134                                          2336.0   \n36135                                           956.0   \n36136                                          1804.0   \n36137                                          1855.0   \n\n       Prestations familiales et sociales mensuelles moyennes (PFS)  Ri + PFS  \\\n0                                                    0.0               2267.0   \n1                                                    0.0               2439.0   \n2                                                    0.0               3081.0   \n3                                                    0.0               1900.0   \n4                                                    0.0               1580.0   \n...                                                  ...                  ...   \n36133                                              184.0               1397.0   \n36134                                                0.0               2336.0   \n36135                                                0.0                956.0   \n36136                                                0.0               1804.0   \n36137                                                0.0               1855.0   \n\n                           région Date création demande Date de la radiation  \\\n0      Provence-Alpes-Côte d'Azur            2013-03-19           2018-07-11   \n1      Provence-Alpes-Côte d'Azur            2017-05-16           2018-02-15   \n2      Provence-Alpes-Côte d'Azur            2016-06-23           2018-07-20   \n3      Provence-Alpes-Côte d'Azur            2017-07-31           2018-01-09   \n4      Provence-Alpes-Côte d'Azur            2013-09-06           2018-09-05   \n...                           ...                   ...                  ...   \n36133                    Picardie            2017-12-20           2018-05-04   \n36134                    Picardie            2017-12-24           2018-02-16   \n36135                    Picardie            2017-12-29           2018-03-28   \n36136                    Picardie            2011-03-16           2018-01-31   \n36137                    Picardie            2003-05-21           2018-10-11   \n\n       Age demandeur Situation familiale  ... Code Géographique  \\\n0                 47         Célibataire  ...             75056   \n1                 34         Célibataire  ...             92035   \n2                 42           Marié (e)  ...             92019   \n3                 36         Célibataire  ...             93010   \n4                 26         Célibataire  ...             92012   \n...              ...                 ...  ...               ...   \n36133             24           Pacsé (e)  ...             75056   \n36134             26        Concubin (e)  ...             75056   \n36135             45         Célibataire  ...             94017   \n36136             53         Divorcé (e)  ...             75056   \n36137             46         Célibataire  ...             75056   \n\n      Région du logement attribué Type du logement attribué  Est en QPV  \\\n0                   Ile-de-France                        T2         Non   \n1                   Ile-de-France                        T2         Non   \n2                   Ile-de-France                        T3         Non   \n3                   Ile-de-France                        T2         Non   \n4                   Ile-de-France                        T2         Non   \n...                           ...                       ...         ...   \n36133               Ile-de-France                        T3         Non   \n36134               Ile-de-France                        T3         Non   \n36135               Ile-de-France                        T1         Oui   \n36136               Ile-de-France                        T3         Non   \n36137               Ile-de-France                        T1         Non   \n\n      Surface du logement attribué    Statut DALO  \\\n0                               35  Non renseigné   \n1                               53  Non renseigné   \n2                               70  Non renseigné   \n3                               53  Non renseigné   \n4                               57   Actif relogé   \n...                            ...            ...   \n36133                           65  Non renseigné   \n36134                           56  Non renseigné   \n36135                           42  Non renseigné   \n36136                           49  Non renseigné   \n36137                           33  Non renseigné   \n\n      Date de la décision DALO\\n\\n  Accompagnement social  Diagnostic social  \\\n0                              NaN                    Non                Non   \n1                              NaN                    Non                Non   \n2                              NaN                    Non                Non   \n3                              NaN                    Non                Non   \n4                       2016-04-13                    Non                Non   \n...                            ...                    ...                ...   \n36133                          NaN                    Non                Non   \n36134                          NaN                    Non                Non   \n36135                          NaN                    Non                Non   \n36136                          NaN                    Non                Non   \n36137                          NaN                    Non                Non   \n\n                                            Réservataire  \n0      Contingent des collectivités territoriales, de...  \n1                                        Hors contingent  \n2                        Contingent autres réservataires  \n3      Contingent préfet fonctionnaires et agents pub...  \n4                                        Action Logement  \n...                                                  ...  \n36133                                    Action Logement  \n36134  Contingent des collectivités territoriales, de...  \n36135                                    Action Logement  \n36136  Contingent des collectivités territoriales, de...  \n36137                    Contingent autres réservataires  \n\n[36138 rows x 42 columns]",
      "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>Numéro Unique</th>\n      <th>RM Moyennes</th>\n      <th>Ressources imposables mensuelles moyennes (RI)</th>\n      <th>Prestations familiales et sociales mensuelles moyennes (PFS)</th>\n      <th>Ri + PFS</th>\n      <th>région</th>\n      <th>Date création demande</th>\n      <th>Date de la radiation</th>\n      <th>Age demandeur</th>\n      <th>Situation familiale</th>\n      <th>...</th>\n      <th>Code Géographique</th>\n      <th>Région du logement attribué</th>\n      <th>Type du logement attribué</th>\n      <th>Est en QPV</th>\n      <th>Surface du logement attribué</th>\n      <th>Statut DALO</th>\n      <th>Date de la décision DALO\\n\\n</th>\n      <th>Accompagnement social</th>\n      <th>Diagnostic social</th>\n      <th>Réservataire</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>111031350487375056</td>\n      <td>2267.0</td>\n      <td>2267.0</td>\n      <td>0.0</td>\n      <td>2267.0</td>\n      <td>Provence-Alpes-Côte d'Azur</td>\n      <td>2013-03-19</td>\n      <td>2018-07-11</td>\n      <td>47</td>\n      <td>Célibataire</td>\n      <td>...</td>\n      <td>75056</td>\n      <td>Ile-de-France</td>\n      <td>T2</td>\n      <td>Non</td>\n      <td>35</td>\n      <td>Non renseigné</td>\n      <td>NaN</td>\n      <td>Non</td>\n      <td>Non</td>\n      <td>Contingent des collectivités territoriales, de...</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>1110517673443GDPUB</td>\n      <td>2439.0</td>\n      <td>2439.0</td>\n      <td>0.0</td>\n      <td>2439.0</td>\n      <td>Provence-Alpes-Côte d'Azur</td>\n      <td>2017-05-16</td>\n      <td>2018-02-15</td>\n      <td>34</td>\n      <td>Célibataire</td>\n      <td>...</td>\n      <td>92035</td>\n      <td>Ile-de-France</td>\n      <td>T2</td>\n      <td>Non</td>\n      <td>53</td>\n      <td>Non renseigné</td>\n      <td>NaN</td>\n      <td>Non</td>\n      <td>Non</td>\n      <td>Hors contingent</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>1110616406245GDPUB</td>\n      <td>3081.0</td>\n      <td>3081.0</td>\n      <td>0.0</td>\n      <td>3081.0</td>\n      <td>Provence-Alpes-Côte d'Azur</td>\n      <td>2016-06-23</td>\n      <td>2018-07-20</td>\n      <td>42</td>\n      <td>Marié (e)</td>\n      <td>...</td>\n      <td>92019</td>\n      <td>Ile-de-France</td>\n      <td>T3</td>\n      <td>Non</td>\n      <td>70</td>\n      <td>Non renseigné</td>\n      <td>NaN</td>\n      <td>Non</td>\n      <td>Non</td>\n      <td>Contingent autres réservataires</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>1110717734339GDPUB</td>\n      <td>1900.0</td>\n      <td>1900.0</td>\n      <td>0.0</td>\n      <td>1900.0</td>\n      <td>Provence-Alpes-Côte d'Azur</td>\n      <td>2017-07-31</td>\n      <td>2018-01-09</td>\n      <td>36</td>\n      <td>Célibataire</td>\n      <td>...</td>\n      <td>93010</td>\n      <td>Ile-de-France</td>\n      <td>T2</td>\n      <td>Non</td>\n      <td>53</td>\n      <td>Non renseigné</td>\n      <td>NaN</td>\n      <td>Non</td>\n      <td>Non</td>\n      <td>Contingent préfet fonctionnaires et agents pub...</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>111091362060710037</td>\n      <td>1580.0</td>\n      <td>1580.0</td>\n      <td>0.0</td>\n      <td>1580.0</td>\n      <td>Provence-Alpes-Côte d'Azur</td>\n      <td>2013-09-06</td>\n      <td>2018-09-05</td>\n      <td>26</td>\n      <td>Célibataire</td>\n      <td>...</td>\n      <td>92012</td>\n      <td>Ile-de-France</td>\n      <td>T2</td>\n      <td>Non</td>\n      <td>57</td>\n      <td>Actif relogé</td>\n      <td>2016-04-13</td>\n      <td>Non</td>\n      <td>Non</td>\n      <td>Action Logement</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>36133</th>\n      <td>1111217844990AL010</td>\n      <td>1397.0</td>\n      <td>1213.0</td>\n      <td>184.0</td>\n      <td>1397.0</td>\n      <td>Picardie</td>\n      <td>2017-12-20</td>\n      <td>2018-05-04</td>\n      <td>24</td>\n      <td>Pacsé (e)</td>\n      <td>...</td>\n      <td>75056</td>\n      <td>Ile-de-France</td>\n      <td>T3</td>\n      <td>Non</td>\n      <td>65</td>\n      <td>Non renseigné</td>\n      <td>NaN</td>\n      <td>Non</td>\n      <td>Non</td>\n      <td>Action Logement</td>\n    </tr>\n    <tr>\n      <th>36134</th>\n      <td>1111217846410GDPUB</td>\n      <td>2336.0</td>\n      <td>2336.0</td>\n      <td>0.0</td>\n      <td>2336.0</td>\n      <td>Picardie</td>\n      <td>2017-12-24</td>\n      <td>2018-02-16</td>\n      <td>26</td>\n      <td>Concubin (e)</td>\n      <td>...</td>\n      <td>75056</td>\n      <td>Ile-de-France</td>\n      <td>T3</td>\n      <td>Non</td>\n      <td>56</td>\n      <td>Non renseigné</td>\n      <td>NaN</td>\n      <td>Non</td>\n      <td>Non</td>\n      <td>Contingent des collectivités territoriales, de...</td>\n    </tr>\n    <tr>\n      <th>36135</th>\n      <td>1111217847711AL004</td>\n      <td>956.0</td>\n      <td>956.0</td>\n      <td>0.0</td>\n      <td>956.0</td>\n      <td>Picardie</td>\n      <td>2017-12-29</td>\n      <td>2018-03-28</td>\n      <td>45</td>\n      <td>Célibataire</td>\n      <td>...</td>\n      <td>94017</td>\n      <td>Ile-de-France</td>\n      <td>T1</td>\n      <td>Oui</td>\n      <td>42</td>\n      <td>Non renseigné</td>\n      <td>NaN</td>\n      <td>Non</td>\n      <td>Non</td>\n      <td>Action Logement</td>\n    </tr>\n    <tr>\n      <th>36136</th>\n      <td>175031108722200002</td>\n      <td>1804.0</td>\n      <td>1804.0</td>\n      <td>0.0</td>\n      <td>1804.0</td>\n      <td>Picardie</td>\n      <td>2011-03-16</td>\n      <td>2018-01-31</td>\n      <td>53</td>\n      <td>Divorcé (e)</td>\n      <td>...</td>\n      <td>75056</td>\n      <td>Ile-de-France</td>\n      <td>T3</td>\n      <td>Non</td>\n      <td>49</td>\n      <td>Non renseigné</td>\n      <td>NaN</td>\n      <td>Non</td>\n      <td>Non</td>\n      <td>Contingent des collectivités territoriales, de...</td>\n    </tr>\n    <tr>\n      <th>36137</th>\n      <td>175050327042800002</td>\n      <td>1855.0</td>\n      <td>1855.0</td>\n      <td>0.0</td>\n      <td>1855.0</td>\n      <td>Picardie</td>\n      <td>2003-05-21</td>\n      <td>2018-10-11</td>\n      <td>46</td>\n      <td>Célibataire</td>\n      <td>...</td>\n      <td>75056</td>\n      <td>Ile-de-France</td>\n      <td>T1</td>\n      <td>Non</td>\n      <td>33</td>\n      <td>Non renseigné</td>\n      <td>NaN</td>\n      <td>Non</td>\n      <td>Non</td>\n      <td>Contingent autres réservataires</td>\n    </tr>\n  </tbody>\n</table>\n<p>36138 rows × 42 columns</p>\n</div>"
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def code(commune):\n",
    "    if commune>74999 and commune<=75999 :\n",
    "        return 75056\n",
    "    else :\n",
    "        return commune\n",
    "\n",
    "\n",
    "dfd['Code Géographique'] = dfd['Code Géographique'].apply(code)\n",
    "dfd"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "outputs": [
    {
     "data": {
      "text/plain": "      Code Géographique    Libellé de la commune  \\\n0                 01001  L'Abergement-Clémenciat   \n1                 01002    L'Abergement-de-Varey   \n2                 01004        Ambérieu-en-Bugey   \n3                 01005      Ambérieux-en-Dombes   \n4                 01006                  Ambléon   \n...                 ...                      ...   \n36676             97613            M'Tsangamouji   \n36677             97614                 Ouangani   \n36678             97615                 Pamandzi   \n36679             97616                     Sada   \n36680             97617                 Tsingoni   \n\n      Zonage I/II/III\\nArrêté du 17 mars 1978 relatif au classement des communes par zones geographiques  \n0                                                     03                                                  \n1                                                     03                                                  \n2                                                     03                                                  \n3                                                     03                                                  \n4                                                     03                                                  \n...                                                  ...                                                  \n36676                                                 02                                                  \n36677                                                 02                                                  \n36678                                                 02                                                  \n36679                                                 02                                                  \n36680                                                 02                                                  \n\n[36681 rows x 3 columns]",
      "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>Code Géographique</th>\n      <th>Libellé de la commune</th>\n      <th>Zonage I/II/III\\nArrêté du 17 mars 1978 relatif au classement des communes par zones geographiques</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>01001</td>\n      <td>L'Abergement-Clémenciat</td>\n      <td>03</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>01002</td>\n      <td>L'Abergement-de-Varey</td>\n      <td>03</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>01004</td>\n      <td>Ambérieu-en-Bugey</td>\n      <td>03</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>01005</td>\n      <td>Ambérieux-en-Dombes</td>\n      <td>03</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>01006</td>\n      <td>Ambléon</td>\n      <td>03</td>\n    </tr>\n    <tr>\n      <th>...</th>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n    </tr>\n    <tr>\n      <th>36676</th>\n      <td>97613</td>\n      <td>M'Tsangamouji</td>\n      <td>02</td>\n    </tr>\n    <tr>\n      <th>36677</th>\n      <td>97614</td>\n      <td>Ouangani</td>\n      <td>02</td>\n    </tr>\n    <tr>\n      <th>36678</th>\n      <td>97615</td>\n      <td>Pamandzi</td>\n      <td>02</td>\n    </tr>\n    <tr>\n      <th>36679</th>\n      <td>97616</td>\n      <td>Sada</td>\n      <td>02</td>\n    </tr>\n    <tr>\n      <th>36680</th>\n      <td>97617</td>\n      <td>Tsingoni</td>\n      <td>02</td>\n    </tr>\n  </tbody>\n</table>\n<p>36681 rows × 3 columns</p>\n</div>"
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.DataFrame(pd.read_excel(r'C:\\Users\\arceb\\PycharmProjects\\pythonProject/DGALN.xls'))\n",
    "df"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "outputs": [
    {
     "data": {
      "text/plain": "      Code Géographique Libellé de la commune  \\\n11155             2A001                   Afa   \n\n      Zonage I/II/III\\nArrêté du 17 mars 1978 relatif au classement des communes par zones geographiques  \n11155                                                 02                                                  ",
      "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>Code Géographique</th>\n      <th>Libellé de la commune</th>\n      <th>Zonage I/II/III\\nArrêté du 17 mars 1978 relatif au classement des communes par zones geographiques</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>11155</th>\n      <td>2A001</td>\n      <td>Afa</td>\n      <td>02</td>\n    </tr>\n  </tbody>\n</table>\n</div>"
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Code Géographique']=='2A001']"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "outputs": [],
   "source": [
    "df['Code Géographique']=df['Code Géographique'].astype(str)\n",
    "dfd['Code Géographique']=dfd['Code Géographique'].astype(str)"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "outputs": [
    {
     "data": {
      "text/plain": "            Numéro Unique  RM Moyennes  \\\n0      111031350487375056       2267.0   \n1      175011216304700002       2906.0   \n2      1110817739596GDPUB       1928.0   \n3      1110316287749GDPUB       3898.0   \n4      1110717722671GDPUB       2050.0   \n...                   ...          ...   \n36133  111121784583377211        818.0   \n36134  111011595714575056       1871.0   \n36135  1110716425125GDPUB       1700.0   \n36136  111111782563593048       1750.0   \n36137  111081486572291027       1680.0   \n\n       Ressources imposables mensuelles moyennes (RI)  \\\n0                                              2267.0   \n1                                              2906.0   \n2                                              1928.0   \n3                                              3898.0   \n4                                              2050.0   \n...                                               ...   \n36133                                             0.0   \n36134                                          1686.0   \n36135                                          1700.0   \n36136                                          1027.0   \n36137                                          1570.0   \n\n       Prestations familiales et sociales mensuelles moyennes (PFS)  Ri + PFS  \\\n0                                                    0.0               2267.0   \n1                                                    0.0               2906.0   \n2                                                    0.0               1928.0   \n3                                                    0.0               3898.0   \n4                                                    0.0               2050.0   \n...                                                  ...                  ...   \n36133                                              818.0                818.0   \n36134                                              185.0               1871.0   \n36135                                                0.0               1700.0   \n36136                                              723.0               1750.0   \n36137                                              110.0               1680.0   \n\n                           région Date création demande Date de la radiation  \\\n0      Provence-Alpes-Côte d'Azur            2013-03-19           2018-07-11   \n1      Provence-Alpes-Côte d'Azur            2012-01-23           2018-03-31   \n2                          Alsace            2017-08-07           2018-01-11   \n3      Provence-Alpes-Côte d'Azur            2016-03-01           2018-01-22   \n4      Provence-Alpes-Côte d'Azur            2017-07-13           2018-04-26   \n...                           ...                   ...                  ...   \n36133               Ile-de-France            2017-12-26           2018-08-31   \n36134               Ile-de-France            2015-01-14           2018-02-06   \n36135               Ile-de-France            2016-07-20           2018-07-05   \n36136               Ile-de-France            2017-11-28           2018-10-18   \n36137               Ile-de-France            2014-08-27           2018-04-10   \n\n       Age demandeur Situation familiale  ... Type du logement attribué  \\\n0                 47         Célibataire  ...                        T2   \n1                 30         Célibataire  ...                        T1   \n2                 25         Célibataire  ...                        T1   \n3                 37           Marié (e)  ...                        T4   \n4                 27         Célibataire  ...                        T1   \n...              ...                 ...  ...                       ...   \n36133             41        Concubin (e)  ...                        T3   \n36134             37           Marié (e)  ...                        T3   \n36135             29         Célibataire  ...                        T2   \n36136             43        Concubin (e)  ...                        T4   \n36137             40         Célibataire  ...                        T3   \n\n        Est en QPV Surface du logement attribué    Statut DALO  \\\n0              Non                           35  Non renseigné   \n1              Non                           42  Non renseigné   \n2              Non                           30  Non renseigné   \n3      Ne sait pas                           81  Non renseigné   \n4              Non                           23  Non renseigné   \n...            ...                          ...            ...   \n36133          Non                           62  Non renseigné   \n36134          Non                           64  Non renseigné   \n36135          Non                           48  Non renseigné   \n36136          Non                           86  Non renseigné   \n36137          Non                           61  Non renseigné   \n\n      Date de la décision DALO\\n\\n Accompagnement social Diagnostic social  \\\n0                              NaN                   Non               Non   \n1                              NaN                   Non               Non   \n2                              NaN                   Non               Non   \n3                              NaN                   Non               Non   \n4                              NaN                   Non               Non   \n...                            ...                   ...               ...   \n36133                          NaN                   Non               Non   \n36134                          NaN                   Non               Non   \n36135                          NaN                   Non               Non   \n36136                          NaN                   Non               Non   \n36137                          NaN                   Non               Non   \n\n                                            Réservataire  \\\n0      Contingent des collectivités territoriales, de...   \n1      Contingent des collectivités territoriales, de...   \n2      Contingent préfet fonctionnaires et agents pub...   \n3      Contingent préfet fonctionnaires et agents pub...   \n4                        Contingent autres réservataires   \n...                                                  ...   \n36133  Contingent des collectivités territoriales, de...   \n36134                                    Action Logement   \n36135                                    Action Logement   \n36136  Contingent préfet fonctionnaires et agents pub...   \n36137                                    Action Logement   \n\n       Libellé de la commune  \\\n0                      Paris   \n1                      Paris   \n2                      Paris   \n3                      Paris   \n4                      Paris   \n...                      ...   \n36133                Périgny   \n36134                Périgny   \n36135                Périgny   \n36136                Périgny   \n36137                Périgny   \n\n       Zonage I/II/III\\nArrêté du 17 mars 1978 relatif au classement des communes par zones geographiques  \n0                                                 01 bis                                                   \n1                                                 01 bis                                                   \n2                                                 01 bis                                                   \n3                                                 01 bis                                                   \n4                                                 01 bis                                                   \n...                                                  ...                                                   \n36133                                                 01                                                   \n36134                                                 01                                                   \n36135                                                 01                                                   \n36136                                                 01                                                   \n36137                                                 01                                                   \n\n[36138 rows x 44 columns]",
      "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>Numéro Unique</th>\n      <th>RM Moyennes</th>\n      <th>Ressources imposables mensuelles moyennes (RI)</th>\n      <th>Prestations familiales et sociales mensuelles moyennes (PFS)</th>\n      <th>Ri + PFS</th>\n      <th>région</th>\n      <th>Date création demande</th>\n      <th>Date de la radiation</th>\n      <th>Age demandeur</th>\n      <th>Situation familiale</th>\n      <th>...</th>\n      <th>Type du logement attribué</th>\n      <th>Est en QPV</th>\n      <th>Surface du logement attribué</th>\n      <th>Statut DALO</th>\n      <th>Date de la décision DALO\\n\\n</th>\n      <th>Accompagnement social</th>\n      <th>Diagnostic social</th>\n      <th>Réservataire</th>\n      <th>Libellé de la commune</th>\n      <th>Zonage I/II/III\\nArrêté du 17 mars 1978 relatif au classement des communes par zones geographiques</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>111031350487375056</td>\n      <td>2267.0</td>\n      <td>2267.0</td>\n      <td>0.0</td>\n      <td>2267.0</td>\n      <td>Provence-Alpes-Côte d'Azur</td>\n      <td>2013-03-19</td>\n      <td>2018-07-11</td>\n      <td>47</td>\n      <td>Célibataire</td>\n      <td>...</td>\n      <td>T2</td>\n      <td>Non</td>\n      <td>35</td>\n      <td>Non renseigné</td>\n      <td>NaN</td>\n      <td>Non</td>\n      <td>Non</td>\n      <td>Contingent des collectivités territoriales, de...</td>\n      <td>Paris</td>\n      <td>01 bis</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>175011216304700002</td>\n      <td>2906.0</td>\n      <td>2906.0</td>\n      <td>0.0</td>\n      <td>2906.0</td>\n      <td>Provence-Alpes-Côte d'Azur</td>\n      <td>2012-01-23</td>\n      <td>2018-03-31</td>\n      <td>30</td>\n      <td>Célibataire</td>\n      <td>...</td>\n      <td>T1</td>\n      <td>Non</td>\n      <td>42</td>\n      <td>Non renseigné</td>\n      <td>NaN</td>\n      <td>Non</td>\n      <td>Non</td>\n      <td>Contingent des collectivités territoriales, de...</td>\n      <td>Paris</td>\n      <td>01 bis</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>1110817739596GDPUB</td>\n      <td>1928.0</td>\n      <td>1928.0</td>\n      <td>0.0</td>\n      <td>1928.0</td>\n      <td>Alsace</td>\n      <td>2017-08-07</td>\n      <td>2018-01-11</td>\n      <td>25</td>\n      <td>Célibataire</td>\n      <td>...</td>\n      <td>T1</td>\n      <td>Non</td>\n      <td>30</td>\n      <td>Non renseigné</td>\n      <td>NaN</td>\n      <td>Non</td>\n      <td>Non</td>\n      <td>Contingent préfet fonctionnaires et agents pub...</td>\n      <td>Paris</td>\n      <td>01 bis</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>1110316287749GDPUB</td>\n      <td>3898.0</td>\n      <td>3898.0</td>\n      <td>0.0</td>\n      <td>3898.0</td>\n      <td>Provence-Alpes-Côte d'Azur</td>\n      <td>2016-03-01</td>\n      <td>2018-01-22</td>\n      <td>37</td>\n      <td>Marié (e)</td>\n      <td>...</td>\n      <td>T4</td>\n      <td>Ne sait pas</td>\n      <td>81</td>\n      <td>Non renseigné</td>\n      <td>NaN</td>\n      <td>Non</td>\n      <td>Non</td>\n      <td>Contingent préfet fonctionnaires et agents pub...</td>\n      <td>Paris</td>\n      <td>01 bis</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>1110717722671GDPUB</td>\n      <td>2050.0</td>\n      <td>2050.0</td>\n      <td>0.0</td>\n      <td>2050.0</td>\n      <td>Provence-Alpes-Côte d'Azur</td>\n      <td>2017-07-13</td>\n      <td>2018-04-26</td>\n      <td>27</td>\n      <td>Célibataire</td>\n      <td>...</td>\n      <td>T1</td>\n      <td>Non</td>\n      <td>23</td>\n      <td>Non renseigné</td>\n      <td>NaN</td>\n      <td>Non</td>\n      <td>Non</td>\n      <td>Contingent autres réservataires</td>\n      <td>Paris</td>\n      <td>01 bis</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>36133</th>\n      <td>111121784583377211</td>\n      <td>818.0</td>\n      <td>0.0</td>\n      <td>818.0</td>\n      <td>818.0</td>\n      <td>Ile-de-France</td>\n      <td>2017-12-26</td>\n      <td>2018-08-31</td>\n      <td>41</td>\n      <td>Concubin (e)</td>\n      <td>...</td>\n      <td>T3</td>\n      <td>Non</td>\n      <td>62</td>\n      <td>Non renseigné</td>\n      <td>NaN</td>\n      <td>Non</td>\n      <td>Non</td>\n      <td>Contingent des collectivités territoriales, de...</td>\n      <td>Périgny</td>\n      <td>01</td>\n    </tr>\n    <tr>\n      <th>36134</th>\n      <td>111011595714575056</td>\n      <td>1871.0</td>\n      <td>1686.0</td>\n      <td>185.0</td>\n      <td>1871.0</td>\n      <td>Ile-de-France</td>\n      <td>2015-01-14</td>\n      <td>2018-02-06</td>\n      <td>37</td>\n      <td>Marié (e)</td>\n      <td>...</td>\n      <td>T3</td>\n      <td>Non</td>\n      <td>64</td>\n      <td>Non renseigné</td>\n      <td>NaN</td>\n      <td>Non</td>\n      <td>Non</td>\n      <td>Action Logement</td>\n      <td>Périgny</td>\n      <td>01</td>\n    </tr>\n    <tr>\n      <th>36135</th>\n      <td>1110716425125GDPUB</td>\n      <td>1700.0</td>\n      <td>1700.0</td>\n      <td>0.0</td>\n      <td>1700.0</td>\n      <td>Ile-de-France</td>\n      <td>2016-07-20</td>\n      <td>2018-07-05</td>\n      <td>29</td>\n      <td>Célibataire</td>\n      <td>...</td>\n      <td>T2</td>\n      <td>Non</td>\n      <td>48</td>\n      <td>Non renseigné</td>\n      <td>NaN</td>\n      <td>Non</td>\n      <td>Non</td>\n      <td>Action Logement</td>\n      <td>Périgny</td>\n      <td>01</td>\n    </tr>\n    <tr>\n      <th>36136</th>\n      <td>111111782563593048</td>\n      <td>1750.0</td>\n      <td>1027.0</td>\n      <td>723.0</td>\n      <td>1750.0</td>\n      <td>Ile-de-France</td>\n      <td>2017-11-28</td>\n      <td>2018-10-18</td>\n      <td>43</td>\n      <td>Concubin (e)</td>\n      <td>...</td>\n      <td>T4</td>\n      <td>Non</td>\n      <td>86</td>\n      <td>Non renseigné</td>\n      <td>NaN</td>\n      <td>Non</td>\n      <td>Non</td>\n      <td>Contingent préfet fonctionnaires et agents pub...</td>\n      <td>Périgny</td>\n      <td>01</td>\n    </tr>\n    <tr>\n      <th>36137</th>\n      <td>111081486572291027</td>\n      <td>1680.0</td>\n      <td>1570.0</td>\n      <td>110.0</td>\n      <td>1680.0</td>\n      <td>Ile-de-France</td>\n      <td>2014-08-27</td>\n      <td>2018-04-10</td>\n      <td>40</td>\n      <td>Célibataire</td>\n      <td>...</td>\n      <td>T3</td>\n      <td>Non</td>\n      <td>61</td>\n      <td>Non renseigné</td>\n      <td>NaN</td>\n      <td>Non</td>\n      <td>Non</td>\n      <td>Action Logement</td>\n      <td>Périgny</td>\n      <td>01</td>\n    </tr>\n  </tbody>\n</table>\n<p>36138 rows × 44 columns</p>\n</div>"
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "base= dfd.merge(df, on='Code Géographique', how='inner')\n",
    "base"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "outputs": [],
   "source": [
    "file_name = 'MGP_final.csv'\n",
    "base.to_csv(file_name)"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "markdown",
   "source": [
    "## Lyon"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%% md\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\arceb\\AppData\\Local\\Temp\\ipykernel_40984\\3604640403.py:1: DtypeWarning: Columns (10,11) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  dfd = pd.read_csv(r'C:\\Users\\arceb\\PycharmProjects\\pythonProject/Lyon.csv', index_col = 0)\n"
     ]
    },
    {
     "data": {
      "text/plain": "            Numéro Unique  RM Moyennes  \\\n0      069011102052311161        809.0   \n1      069011614196011128        524.0   \n2      069011614446911204       2180.0   \n3      0690117045253GDPUB       1467.0   \n4      0690117046129FCR69        828.0   \n...                   ...          ...   \n62064  0691216041995GDPUB       2089.0   \n62065  0691216042374FCR69       1176.0   \n62066  0691216042650GDPUB        962.0   \n62067  0691217089529FCR69       1057.0   \n62068  0691217090418FCR69       1340.0   \n\n       Ressources imposables mensuelles moyennes (RI)  \\\n0                                               700.0   \n1                                                 0.0   \n2                                              2050.0   \n3                                              1467.0   \n4                                               236.0   \n...                                               ...   \n62064                                          2089.0   \n62065                                           844.0   \n62066                                             0.0   \n62067                                          1057.0   \n62068                                             0.0   \n\n       Prestations familiales et sociales mensuelles moyennes (PFS)  Ri + PFS  \\\n0                                                  109.0                809.0   \n1                                                  524.0                524.0   \n2                                                  130.0               2180.0   \n3                                                    0.0               1467.0   \n4                                                  592.0                828.0   \n...                                                  ...                  ...   \n62064                                                0.0               2089.0   \n62065                                              332.0               1176.0   \n62066                                              962.0                962.0   \n62067                                                0.0               1057.0   \n62068                                             1340.0               1340.0   \n\n                 région Date création demande  Age demandeur  \\\n0                Alsace            2011-01-18           53.0   \n1                Alsace            2016-01-07           33.0   \n2                Alsace            2016-01-25           46.0   \n3                Alsace            2017-01-13           44.0   \n4                Alsace            2017-01-19           47.0   \n...                 ...                   ...            ...   \n62064  Pays de la Loire            2016-12-16           32.0   \n62065  Poitou-Charentes            2016-12-20           35.0   \n62066          Picardie            2016-12-21           35.0   \n62067  Pays de la Loire            2017-12-05           27.0   \n62068          Picardie            2017-12-13           33.0   \n\n      Situation familiale Code département logement actuel  ...  \\\n0             Célibataire                             68.0  ...   \n1             Célibataire                             67.0  ...   \n2              Séparé (e)                             67.0  ...   \n3             Divorcé (e)                             68.0  ...   \n4               Marié (e)                             67.0  ...   \n...                   ...                              ...  ...   \n62064           Marié (e)                             44.0  ...   \n62065         Célibataire                             86.0  ...   \n62066           Marié (e)                              2.0  ...   \n62067         Célibataire                             44.0  ...   \n62068        Concubin (e)                             60.0  ...   \n\n      Ressources mensuelles du foyer RFR du foyer, année n-1  \\\n0                              809.0                     NaN   \n1                              524.0                     0.0   \n2                             2180.0                  9958.0   \n3                             1467.0                     NaN   \n4                              828.0                     NaN   \n...                              ...                     ...   \n62064                         2089.0                 11479.0   \n62065                         1176.0                     NaN   \n62066                          962.0                     0.0   \n62067                         1057.0                     NaN   \n62068                         1340.0                     NaN   \n\n      RFR du foyer, année n-2 Code Géographique  Commune logement souhaité  \\\n0                         0.0             69290               Saint-Priest   \n1                         0.0             69152              Pierre-Bénite   \n2                     12426.0             69383   Lyon - 3e arrondissement   \n3                         NaN             69266               Villeurbanne   \n4                         0.0             69388   Lyon - 8e arrondissement   \n...                       ...               ...                        ...   \n62064                     0.0             69266               Villeurbanne   \n62065                     NaN             69123                       Lyon   \n62066                     0.0             69123                       Lyon   \n62067                 11980.0             69387   Lyon - 7e arrondissement   \n62068                  4414.0             69266               Villeurbanne   \n\n       Montant maxi (loyer+charges) supportable  Sexe demandeur\\n  \\\n0                                         500.0                 F   \n1                                         350.0                 M   \n2                                         650.0                 F   \n3                                         600.0                 F   \n4                                         600.0                 F   \n...                                         ...               ...   \n62064                                     500.0                 M   \n62065                                     550.0                 F   \n62066                                     600.0                 M   \n62067                                     550.0                 M   \n62068                                     475.0                 F   \n\n      Nationalité demandeur\\n Autre logement dé\\ntenu demandeur\\n  \\\n0       Hors Union Européenne                                 Non   \n1                   Française                                 Non   \n2                   Française                                 Non   \n3                   Française                                 Non   \n4                   Française                                 Non   \n...                       ...                                 ...   \n62064               Française                                 Non   \n62065               Française                                 Non   \n62066   Hors Union Européenne                                 Non   \n62067               Française                                 Non   \n62068   Hors Union Européenne                                 Non   \n\n      Nb de personnes handicapees  \n0                             0.0  \n1                             0.0  \n2                             0.0  \n3                             0.0  \n4                             0.0  \n...                           ...  \n62064                         0.0  \n62065                         0.0  \n62066                         0.0  \n62067                         0.0  \n62068                         0.0  \n\n[62069 rows x 31 columns]",
      "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>Numéro Unique</th>\n      <th>RM Moyennes</th>\n      <th>Ressources imposables mensuelles moyennes (RI)</th>\n      <th>Prestations familiales et sociales mensuelles moyennes (PFS)</th>\n      <th>Ri + PFS</th>\n      <th>région</th>\n      <th>Date création demande</th>\n      <th>Age demandeur</th>\n      <th>Situation familiale</th>\n      <th>Code département logement actuel</th>\n      <th>...</th>\n      <th>Ressources mensuelles du foyer</th>\n      <th>RFR du foyer, année n-1</th>\n      <th>RFR du foyer, année n-2</th>\n      <th>Code Géographique</th>\n      <th>Commune logement souhaité</th>\n      <th>Montant maxi (loyer+charges) supportable</th>\n      <th>Sexe demandeur\\n</th>\n      <th>Nationalité demandeur\\n</th>\n      <th>Autre logement dé\\ntenu demandeur\\n</th>\n      <th>Nb de personnes handicapees</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>069011102052311161</td>\n      <td>809.0</td>\n      <td>700.0</td>\n      <td>109.0</td>\n      <td>809.0</td>\n      <td>Alsace</td>\n      <td>2011-01-18</td>\n      <td>53.0</td>\n      <td>Célibataire</td>\n      <td>68.0</td>\n      <td>...</td>\n      <td>809.0</td>\n      <td>NaN</td>\n      <td>0.0</td>\n      <td>69290</td>\n      <td>Saint-Priest</td>\n      <td>500.0</td>\n      <td>F</td>\n      <td>Hors Union Européenne</td>\n      <td>Non</td>\n      <td>0.0</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>069011614196011128</td>\n      <td>524.0</td>\n      <td>0.0</td>\n      <td>524.0</td>\n      <td>524.0</td>\n      <td>Alsace</td>\n      <td>2016-01-07</td>\n      <td>33.0</td>\n      <td>Célibataire</td>\n      <td>67.0</td>\n      <td>...</td>\n      <td>524.0</td>\n      <td>0.0</td>\n      <td>0.0</td>\n      <td>69152</td>\n      <td>Pierre-Bénite</td>\n      <td>350.0</td>\n      <td>M</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>069011614446911204</td>\n      <td>2180.0</td>\n      <td>2050.0</td>\n      <td>130.0</td>\n      <td>2180.0</td>\n      <td>Alsace</td>\n      <td>2016-01-25</td>\n      <td>46.0</td>\n      <td>Séparé (e)</td>\n      <td>67.0</td>\n      <td>...</td>\n      <td>2180.0</td>\n      <td>9958.0</td>\n      <td>12426.0</td>\n      <td>69383</td>\n      <td>Lyon - 3e arrondissement</td>\n      <td>650.0</td>\n      <td>F</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>0690117045253GDPUB</td>\n      <td>1467.0</td>\n      <td>1467.0</td>\n      <td>0.0</td>\n      <td>1467.0</td>\n      <td>Alsace</td>\n      <td>2017-01-13</td>\n      <td>44.0</td>\n      <td>Divorcé (e)</td>\n      <td>68.0</td>\n      <td>...</td>\n      <td>1467.0</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>69266</td>\n      <td>Villeurbanne</td>\n      <td>600.0</td>\n      <td>F</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>0690117046129FCR69</td>\n      <td>828.0</td>\n      <td>236.0</td>\n      <td>592.0</td>\n      <td>828.0</td>\n      <td>Alsace</td>\n      <td>2017-01-19</td>\n      <td>47.0</td>\n      <td>Marié (e)</td>\n      <td>67.0</td>\n      <td>...</td>\n      <td>828.0</td>\n      <td>NaN</td>\n      <td>0.0</td>\n      <td>69388</td>\n      <td>Lyon - 8e arrondissement</td>\n      <td>600.0</td>\n      <td>F</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n    </tr>\n    <tr>\n      <th>...</th>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n    </tr>\n    <tr>\n      <th>62064</th>\n      <td>0691216041995GDPUB</td>\n      <td>2089.0</td>\n      <td>2089.0</td>\n      <td>0.0</td>\n      <td>2089.0</td>\n      <td>Pays de la Loire</td>\n      <td>2016-12-16</td>\n      <td>32.0</td>\n      <td>Marié (e)</td>\n      <td>44.0</td>\n      <td>...</td>\n      <td>2089.0</td>\n      <td>11479.0</td>\n      <td>0.0</td>\n      <td>69266</td>\n      <td>Villeurbanne</td>\n      <td>500.0</td>\n      <td>M</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n    </tr>\n    <tr>\n      <th>62065</th>\n      <td>0691216042374FCR69</td>\n      <td>1176.0</td>\n      <td>844.0</td>\n      <td>332.0</td>\n      <td>1176.0</td>\n      <td>Poitou-Charentes</td>\n      <td>2016-12-20</td>\n      <td>35.0</td>\n      <td>Célibataire</td>\n      <td>86.0</td>\n      <td>...</td>\n      <td>1176.0</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>69123</td>\n      <td>Lyon</td>\n      <td>550.0</td>\n      <td>F</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n    </tr>\n    <tr>\n      <th>62066</th>\n      <td>0691216042650GDPUB</td>\n      <td>962.0</td>\n      <td>0.0</td>\n      <td>962.0</td>\n      <td>962.0</td>\n      <td>Picardie</td>\n      <td>2016-12-21</td>\n      <td>35.0</td>\n      <td>Marié (e)</td>\n      <td>2.0</td>\n      <td>...</td>\n      <td>962.0</td>\n      <td>0.0</td>\n      <td>0.0</td>\n      <td>69123</td>\n      <td>Lyon</td>\n      <td>600.0</td>\n      <td>M</td>\n      <td>Hors Union Européenne</td>\n      <td>Non</td>\n      <td>0.0</td>\n    </tr>\n    <tr>\n      <th>62067</th>\n      <td>0691217089529FCR69</td>\n      <td>1057.0</td>\n      <td>1057.0</td>\n      <td>0.0</td>\n      <td>1057.0</td>\n      <td>Pays de la Loire</td>\n      <td>2017-12-05</td>\n      <td>27.0</td>\n      <td>Célibataire</td>\n      <td>44.0</td>\n      <td>...</td>\n      <td>1057.0</td>\n      <td>NaN</td>\n      <td>11980.0</td>\n      <td>69387</td>\n      <td>Lyon - 7e arrondissement</td>\n      <td>550.0</td>\n      <td>M</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n    </tr>\n    <tr>\n      <th>62068</th>\n      <td>0691217090418FCR69</td>\n      <td>1340.0</td>\n      <td>0.0</td>\n      <td>1340.0</td>\n      <td>1340.0</td>\n      <td>Picardie</td>\n      <td>2017-12-13</td>\n      <td>33.0</td>\n      <td>Concubin (e)</td>\n      <td>60.0</td>\n      <td>...</td>\n      <td>1340.0</td>\n      <td>NaN</td>\n      <td>4414.0</td>\n      <td>69266</td>\n      <td>Villeurbanne</td>\n      <td>475.0</td>\n      <td>F</td>\n      <td>Hors Union Européenne</td>\n      <td>Non</td>\n      <td>0.0</td>\n    </tr>\n  </tbody>\n</table>\n<p>62069 rows × 31 columns</p>\n</div>"
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfd = pd.read_csv(r'C:\\Users\\arceb\\PycharmProjects\\pythonProject/Lyon.csv', index_col = 0)\n",
    "dfd=dfd.rename(columns={'Code INSEE commune logt souhaité': 'Code Géographique'})\n",
    "dfd"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "outputs": [],
   "source": [
    "dfd['Code Géographique']=dfd['Code Géographique'].astype(int)"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "outputs": [
    {
     "data": {
      "text/plain": "            Numéro Unique  RM Moyennes  \\\n0      069011102052311161        809.0   \n1      069011614196011128        524.0   \n2      069011614446911204       2180.0   \n3      0690117045253GDPUB       1467.0   \n4      0690117046129FCR69        828.0   \n...                   ...          ...   \n62064  0691216041995GDPUB       2089.0   \n62065  0691216042374FCR69       1176.0   \n62066  0691216042650GDPUB        962.0   \n62067  0691217089529FCR69       1057.0   \n62068  0691217090418FCR69       1340.0   \n\n       Ressources imposables mensuelles moyennes (RI)  \\\n0                                               700.0   \n1                                                 0.0   \n2                                              2050.0   \n3                                              1467.0   \n4                                               236.0   \n...                                               ...   \n62064                                          2089.0   \n62065                                           844.0   \n62066                                             0.0   \n62067                                          1057.0   \n62068                                             0.0   \n\n       Prestations familiales et sociales mensuelles moyennes (PFS)  Ri + PFS  \\\n0                                                  109.0                809.0   \n1                                                  524.0                524.0   \n2                                                  130.0               2180.0   \n3                                                    0.0               1467.0   \n4                                                  592.0                828.0   \n...                                                  ...                  ...   \n62064                                                0.0               2089.0   \n62065                                              332.0               1176.0   \n62066                                              962.0                962.0   \n62067                                                0.0               1057.0   \n62068                                             1340.0               1340.0   \n\n                 région Date création demande  Age demandeur  \\\n0                Alsace            2011-01-18           53.0   \n1                Alsace            2016-01-07           33.0   \n2                Alsace            2016-01-25           46.0   \n3                Alsace            2017-01-13           44.0   \n4                Alsace            2017-01-19           47.0   \n...                 ...                   ...            ...   \n62064  Pays de la Loire            2016-12-16           32.0   \n62065  Poitou-Charentes            2016-12-20           35.0   \n62066          Picardie            2016-12-21           35.0   \n62067  Pays de la Loire            2017-12-05           27.0   \n62068          Picardie            2017-12-13           33.0   \n\n      Situation familiale Code département logement actuel  ...  \\\n0             Célibataire                             68.0  ...   \n1             Célibataire                             67.0  ...   \n2              Séparé (e)                             67.0  ...   \n3             Divorcé (e)                             68.0  ...   \n4               Marié (e)                             67.0  ...   \n...                   ...                              ...  ...   \n62064           Marié (e)                             44.0  ...   \n62065         Célibataire                             86.0  ...   \n62066           Marié (e)                              2.0  ...   \n62067         Célibataire                             44.0  ...   \n62068        Concubin (e)                             60.0  ...   \n\n      Ressources mensuelles du foyer RFR du foyer, année n-1  \\\n0                              809.0                     NaN   \n1                              524.0                     0.0   \n2                             2180.0                  9958.0   \n3                             1467.0                     NaN   \n4                              828.0                     NaN   \n...                              ...                     ...   \n62064                         2089.0                 11479.0   \n62065                         1176.0                     NaN   \n62066                          962.0                     0.0   \n62067                         1057.0                     NaN   \n62068                         1340.0                     NaN   \n\n      RFR du foyer, année n-2 Code Géographique  Commune logement souhaité  \\\n0                         0.0             69290               Saint-Priest   \n1                         0.0             69152              Pierre-Bénite   \n2                     12426.0             69123   Lyon - 3e arrondissement   \n3                         NaN             69266               Villeurbanne   \n4                         0.0             69123   Lyon - 8e arrondissement   \n...                       ...               ...                        ...   \n62064                     0.0             69266               Villeurbanne   \n62065                     NaN             69123                       Lyon   \n62066                     0.0             69123                       Lyon   \n62067                 11980.0             69123   Lyon - 7e arrondissement   \n62068                  4414.0             69266               Villeurbanne   \n\n       Montant maxi (loyer+charges) supportable  Sexe demandeur\\n  \\\n0                                         500.0                 F   \n1                                         350.0                 M   \n2                                         650.0                 F   \n3                                         600.0                 F   \n4                                         600.0                 F   \n...                                         ...               ...   \n62064                                     500.0                 M   \n62065                                     550.0                 F   \n62066                                     600.0                 M   \n62067                                     550.0                 M   \n62068                                     475.0                 F   \n\n      Nationalité demandeur\\n Autre logement dé\\ntenu demandeur\\n  \\\n0       Hors Union Européenne                                 Non   \n1                   Française                                 Non   \n2                   Française                                 Non   \n3                   Française                                 Non   \n4                   Française                                 Non   \n...                       ...                                 ...   \n62064               Française                                 Non   \n62065               Française                                 Non   \n62066   Hors Union Européenne                                 Non   \n62067               Française                                 Non   \n62068   Hors Union Européenne                                 Non   \n\n      Nb de personnes handicapees  \n0                             0.0  \n1                             0.0  \n2                             0.0  \n3                             0.0  \n4                             0.0  \n...                           ...  \n62064                         0.0  \n62065                         0.0  \n62066                         0.0  \n62067                         0.0  \n62068                         0.0  \n\n[62069 rows x 31 columns]",
      "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>Numéro Unique</th>\n      <th>RM Moyennes</th>\n      <th>Ressources imposables mensuelles moyennes (RI)</th>\n      <th>Prestations familiales et sociales mensuelles moyennes (PFS)</th>\n      <th>Ri + PFS</th>\n      <th>région</th>\n      <th>Date création demande</th>\n      <th>Age demandeur</th>\n      <th>Situation familiale</th>\n      <th>Code département logement actuel</th>\n      <th>...</th>\n      <th>Ressources mensuelles du foyer</th>\n      <th>RFR du foyer, année n-1</th>\n      <th>RFR du foyer, année n-2</th>\n      <th>Code Géographique</th>\n      <th>Commune logement souhaité</th>\n      <th>Montant maxi (loyer+charges) supportable</th>\n      <th>Sexe demandeur\\n</th>\n      <th>Nationalité demandeur\\n</th>\n      <th>Autre logement dé\\ntenu demandeur\\n</th>\n      <th>Nb de personnes handicapees</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>069011102052311161</td>\n      <td>809.0</td>\n      <td>700.0</td>\n      <td>109.0</td>\n      <td>809.0</td>\n      <td>Alsace</td>\n      <td>2011-01-18</td>\n      <td>53.0</td>\n      <td>Célibataire</td>\n      <td>68.0</td>\n      <td>...</td>\n      <td>809.0</td>\n      <td>NaN</td>\n      <td>0.0</td>\n      <td>69290</td>\n      <td>Saint-Priest</td>\n      <td>500.0</td>\n      <td>F</td>\n      <td>Hors Union Européenne</td>\n      <td>Non</td>\n      <td>0.0</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>069011614196011128</td>\n      <td>524.0</td>\n      <td>0.0</td>\n      <td>524.0</td>\n      <td>524.0</td>\n      <td>Alsace</td>\n      <td>2016-01-07</td>\n      <td>33.0</td>\n      <td>Célibataire</td>\n      <td>67.0</td>\n      <td>...</td>\n      <td>524.0</td>\n      <td>0.0</td>\n      <td>0.0</td>\n      <td>69152</td>\n      <td>Pierre-Bénite</td>\n      <td>350.0</td>\n      <td>M</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>069011614446911204</td>\n      <td>2180.0</td>\n      <td>2050.0</td>\n      <td>130.0</td>\n      <td>2180.0</td>\n      <td>Alsace</td>\n      <td>2016-01-25</td>\n      <td>46.0</td>\n      <td>Séparé (e)</td>\n      <td>67.0</td>\n      <td>...</td>\n      <td>2180.0</td>\n      <td>9958.0</td>\n      <td>12426.0</td>\n      <td>69123</td>\n      <td>Lyon - 3e arrondissement</td>\n      <td>650.0</td>\n      <td>F</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>0690117045253GDPUB</td>\n      <td>1467.0</td>\n      <td>1467.0</td>\n      <td>0.0</td>\n      <td>1467.0</td>\n      <td>Alsace</td>\n      <td>2017-01-13</td>\n      <td>44.0</td>\n      <td>Divorcé (e)</td>\n      <td>68.0</td>\n      <td>...</td>\n      <td>1467.0</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>69266</td>\n      <td>Villeurbanne</td>\n      <td>600.0</td>\n      <td>F</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>0690117046129FCR69</td>\n      <td>828.0</td>\n      <td>236.0</td>\n      <td>592.0</td>\n      <td>828.0</td>\n      <td>Alsace</td>\n      <td>2017-01-19</td>\n      <td>47.0</td>\n      <td>Marié (e)</td>\n      <td>67.0</td>\n      <td>...</td>\n      <td>828.0</td>\n      <td>NaN</td>\n      <td>0.0</td>\n      <td>69123</td>\n      <td>Lyon - 8e arrondissement</td>\n      <td>600.0</td>\n      <td>F</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n    </tr>\n    <tr>\n      <th>...</th>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n    </tr>\n    <tr>\n      <th>62064</th>\n      <td>0691216041995GDPUB</td>\n      <td>2089.0</td>\n      <td>2089.0</td>\n      <td>0.0</td>\n      <td>2089.0</td>\n      <td>Pays de la Loire</td>\n      <td>2016-12-16</td>\n      <td>32.0</td>\n      <td>Marié (e)</td>\n      <td>44.0</td>\n      <td>...</td>\n      <td>2089.0</td>\n      <td>11479.0</td>\n      <td>0.0</td>\n      <td>69266</td>\n      <td>Villeurbanne</td>\n      <td>500.0</td>\n      <td>M</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n    </tr>\n    <tr>\n      <th>62065</th>\n      <td>0691216042374FCR69</td>\n      <td>1176.0</td>\n      <td>844.0</td>\n      <td>332.0</td>\n      <td>1176.0</td>\n      <td>Poitou-Charentes</td>\n      <td>2016-12-20</td>\n      <td>35.0</td>\n      <td>Célibataire</td>\n      <td>86.0</td>\n      <td>...</td>\n      <td>1176.0</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>69123</td>\n      <td>Lyon</td>\n      <td>550.0</td>\n      <td>F</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n    </tr>\n    <tr>\n      <th>62066</th>\n      <td>0691216042650GDPUB</td>\n      <td>962.0</td>\n      <td>0.0</td>\n      <td>962.0</td>\n      <td>962.0</td>\n      <td>Picardie</td>\n      <td>2016-12-21</td>\n      <td>35.0</td>\n      <td>Marié (e)</td>\n      <td>2.0</td>\n      <td>...</td>\n      <td>962.0</td>\n      <td>0.0</td>\n      <td>0.0</td>\n      <td>69123</td>\n      <td>Lyon</td>\n      <td>600.0</td>\n      <td>M</td>\n      <td>Hors Union Européenne</td>\n      <td>Non</td>\n      <td>0.0</td>\n    </tr>\n    <tr>\n      <th>62067</th>\n      <td>0691217089529FCR69</td>\n      <td>1057.0</td>\n      <td>1057.0</td>\n      <td>0.0</td>\n      <td>1057.0</td>\n      <td>Pays de la Loire</td>\n      <td>2017-12-05</td>\n      <td>27.0</td>\n      <td>Célibataire</td>\n      <td>44.0</td>\n      <td>...</td>\n      <td>1057.0</td>\n      <td>NaN</td>\n      <td>11980.0</td>\n      <td>69123</td>\n      <td>Lyon - 7e arrondissement</td>\n      <td>550.0</td>\n      <td>M</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n    </tr>\n    <tr>\n      <th>62068</th>\n      <td>0691217090418FCR69</td>\n      <td>1340.0</td>\n      <td>0.0</td>\n      <td>1340.0</td>\n      <td>1340.0</td>\n      <td>Picardie</td>\n      <td>2017-12-13</td>\n      <td>33.0</td>\n      <td>Concubin (e)</td>\n      <td>60.0</td>\n      <td>...</td>\n      <td>1340.0</td>\n      <td>NaN</td>\n      <td>4414.0</td>\n      <td>69266</td>\n      <td>Villeurbanne</td>\n      <td>475.0</td>\n      <td>F</td>\n      <td>Hors Union Européenne</td>\n      <td>Non</td>\n      <td>0.0</td>\n    </tr>\n  </tbody>\n</table>\n<p>62069 rows × 31 columns</p>\n</div>"
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def code1(commune):\n",
    "    if commune>=69381 and commune<=69389 :\n",
    "        return 69123\n",
    "    else :\n",
    "        return commune\n",
    "\n",
    "\n",
    "dfd['Code Géographique'] = dfd['Code Géographique'].apply(code1)\n",
    "dfd"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "outputs": [
    {
     "data": {
      "text/plain": "            Numéro Unique  RM Moyennes  \\\n0      069011102052311161        809.0   \n1      0690316005792FCR69       1163.0   \n2      0690417063596FCR69       1462.0   \n3      0690617067986GDPUB       1283.0   \n4      0690517064998GDPUB       1800.0   \n...                   ...          ...   \n62064  0691215001738FCR69       1384.0   \n62065  0691217089044FCR69       1400.0   \n62066  0690717069962GDPUB       1900.0   \n62067  0690817073543AL003       1650.0   \n62068  069121513858311189       1226.0   \n\n       Ressources imposables mensuelles moyennes (RI)  \\\n0                                               700.0   \n1                                              1163.0   \n2                                              1462.0   \n3                                              1100.0   \n4                                              1800.0   \n...                                               ...   \n62064                                          1200.0   \n62065                                          1400.0   \n62066                                          1900.0   \n62067                                          1650.0   \n62068                                          1300.0   \n\n       Prestations familiales et sociales mensuelles moyennes (PFS)  Ri + PFS  \\\n0                                                  109.0                809.0   \n1                                                    0.0               1163.0   \n2                                                    0.0               1462.0   \n3                                                  183.0               1283.0   \n4                                                    0.0               1800.0   \n...                                                  ...                  ...   \n62064                                              184.0               1384.0   \n62065                                                0.0               1400.0   \n62066                                                0.0               1900.0   \n62067                                                0.0               1650.0   \n62068                                                1.0               1301.0   \n\n                           région Date création demande  Age demandeur  \\\n0                          Alsace            2011-01-18           53.0   \n1      Provence-Alpes-Côte d'Azur            2016-03-14           36.0   \n2      Provence-Alpes-Côte d'Azur            2017-04-04           68.0   \n3      Provence-Alpes-Côte d'Azur            2017-06-18           35.0   \n4                   Ile-de-France            2017-05-24           51.0   \n...                           ...                   ...            ...   \n62064                 Rhône-Alpes            2015-12-28           32.0   \n62065                 Rhône-Alpes            2017-12-04           37.0   \n62066            Poitou-Charentes            2017-07-03           36.0   \n62067                 Rhône-Alpes            2017-08-02           37.0   \n62068                 Rhône-Alpes            2015-11-30           54.0   \n\n      Situation familiale Code département logement actuel  ...  \\\n0             Célibataire                             68.0  ...   \n1               Marié (e)                             84.0  ...   \n2             Divorcé (e)                             83.0  ...   \n3               Marié (e)                             84.0  ...   \n4               Marié (e)                             91.0  ...   \n...                   ...                              ...  ...   \n62064        Concubin (e)                             69.0  ...   \n62065           Pacsé (e)                             69.0  ...   \n62066           Marié (e)                             17.0  ...   \n62067           Marié (e)                             69.0  ...   \n62068           Marié (e)                             69.0  ...   \n\n      RFR du foyer, année n-2 Code Géographique Commune logement souhaité  \\\n0                         0.0             69290              Saint-Priest   \n1                         NaN             69290              Saint-Priest   \n2                         NaN             69290              Saint-Priest   \n3                     12435.0             69290              Saint-Priest   \n4                     21000.0             69290              Saint-Priest   \n...                       ...               ...                       ...   \n62064                 15780.0             69153   Poleymieux-au-Mont-d'Or   \n62065                 14358.0             69153   Poleymieux-au-Mont-d'Or   \n62066                 23924.0             69153   Poleymieux-au-Mont-d'Or   \n62067                 41209.0             69071        Curis-au-Mont-d'Or   \n62068                 10433.0             69071        Curis-au-Mont-d'Or   \n\n      Montant maxi (loyer+charges) supportable  Sexe demandeur\\n  \\\n0                                        500.0                 F   \n1                                          0.0                 F   \n2                                        350.0                 F   \n3                                        550.0                 M   \n4                                        700.0                 M   \n...                                        ...               ...   \n62064                                    900.0                 F   \n62065                                    600.0                 F   \n62066                                   1100.0                 M   \n62067                                      0.0                 F   \n62068                                    300.0                 M   \n\n       Nationalité demandeur\\n  Autre logement dé\\ntenu demandeur\\n  \\\n0        Hors Union Européenne                                  Non   \n1                    Française                                  Oui   \n2                    Française                                  Non   \n3                    Française                                  Non   \n4        Hors Union Européenne                                  Non   \n...                        ...                                  ...   \n62064                Française                                  Non   \n62065                Française                                  Non   \n62066                Française                                  Non   \n62067                Française                                  Non   \n62068                Française                                  Non   \n\n      Nb de personnes handicapees    Libellé de la commune  \\\n0                             0.0             Saint-Priest   \n1                             0.0             Saint-Priest   \n2                             0.0             Saint-Priest   \n3                             0.0             Saint-Priest   \n4                             0.0             Saint-Priest   \n...                           ...                      ...   \n62064                         0.0  Poleymieux-au-Mont-d'Or   \n62065                         0.0  Poleymieux-au-Mont-d'Or   \n62066                         0.0  Poleymieux-au-Mont-d'Or   \n62067                         0.0       Curis-au-Mont-d'Or   \n62068                         0.0       Curis-au-Mont-d'Or   \n\n      Zonage I/II/III\\nArrêté du 17 mars 1978 relatif au classement des communes par zones geographiques  \n0                                                     02                                                  \n1                                                     02                                                  \n2                                                     02                                                  \n3                                                     02                                                  \n4                                                     02                                                  \n...                                                  ...                                                  \n62064                                                 02                                                  \n62065                                                 02                                                  \n62066                                                 02                                                  \n62067                                                 02                                                  \n62068                                                 02                                                  \n\n[62069 rows x 33 columns]",
      "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>Numéro Unique</th>\n      <th>RM Moyennes</th>\n      <th>Ressources imposables mensuelles moyennes (RI)</th>\n      <th>Prestations familiales et sociales mensuelles moyennes (PFS)</th>\n      <th>Ri + PFS</th>\n      <th>région</th>\n      <th>Date création demande</th>\n      <th>Age demandeur</th>\n      <th>Situation familiale</th>\n      <th>Code département logement actuel</th>\n      <th>...</th>\n      <th>RFR du foyer, année n-2</th>\n      <th>Code Géographique</th>\n      <th>Commune logement souhaité</th>\n      <th>Montant maxi (loyer+charges) supportable</th>\n      <th>Sexe demandeur\\n</th>\n      <th>Nationalité demandeur\\n</th>\n      <th>Autre logement dé\\ntenu demandeur\\n</th>\n      <th>Nb de personnes handicapees</th>\n      <th>Libellé de la commune</th>\n      <th>Zonage I/II/III\\nArrêté du 17 mars 1978 relatif au classement des communes par zones geographiques</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>069011102052311161</td>\n      <td>809.0</td>\n      <td>700.0</td>\n      <td>109.0</td>\n      <td>809.0</td>\n      <td>Alsace</td>\n      <td>2011-01-18</td>\n      <td>53.0</td>\n      <td>Célibataire</td>\n      <td>68.0</td>\n      <td>...</td>\n      <td>0.0</td>\n      <td>69290</td>\n      <td>Saint-Priest</td>\n      <td>500.0</td>\n      <td>F</td>\n      <td>Hors Union Européenne</td>\n      <td>Non</td>\n      <td>0.0</td>\n      <td>Saint-Priest</td>\n      <td>02</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>0690316005792FCR69</td>\n      <td>1163.0</td>\n      <td>1163.0</td>\n      <td>0.0</td>\n      <td>1163.0</td>\n      <td>Provence-Alpes-Côte d'Azur</td>\n      <td>2016-03-14</td>\n      <td>36.0</td>\n      <td>Marié (e)</td>\n      <td>84.0</td>\n      <td>...</td>\n      <td>NaN</td>\n      <td>69290</td>\n      <td>Saint-Priest</td>\n      <td>0.0</td>\n      <td>F</td>\n      <td>Française</td>\n      <td>Oui</td>\n      <td>0.0</td>\n      <td>Saint-Priest</td>\n      <td>02</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>0690417063596FCR69</td>\n      <td>1462.0</td>\n      <td>1462.0</td>\n      <td>0.0</td>\n      <td>1462.0</td>\n      <td>Provence-Alpes-Côte d'Azur</td>\n      <td>2017-04-04</td>\n      <td>68.0</td>\n      <td>Divorcé (e)</td>\n      <td>83.0</td>\n      <td>...</td>\n      <td>NaN</td>\n      <td>69290</td>\n      <td>Saint-Priest</td>\n      <td>350.0</td>\n      <td>F</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n      <td>Saint-Priest</td>\n      <td>02</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>0690617067986GDPUB</td>\n      <td>1283.0</td>\n      <td>1100.0</td>\n      <td>183.0</td>\n      <td>1283.0</td>\n      <td>Provence-Alpes-Côte d'Azur</td>\n      <td>2017-06-18</td>\n      <td>35.0</td>\n      <td>Marié (e)</td>\n      <td>84.0</td>\n      <td>...</td>\n      <td>12435.0</td>\n      <td>69290</td>\n      <td>Saint-Priest</td>\n      <td>550.0</td>\n      <td>M</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n      <td>Saint-Priest</td>\n      <td>02</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>0690517064998GDPUB</td>\n      <td>1800.0</td>\n      <td>1800.0</td>\n      <td>0.0</td>\n      <td>1800.0</td>\n      <td>Ile-de-France</td>\n      <td>2017-05-24</td>\n      <td>51.0</td>\n      <td>Marié (e)</td>\n      <td>91.0</td>\n      <td>...</td>\n      <td>21000.0</td>\n      <td>69290</td>\n      <td>Saint-Priest</td>\n      <td>700.0</td>\n      <td>M</td>\n      <td>Hors Union Européenne</td>\n      <td>Non</td>\n      <td>0.0</td>\n      <td>Saint-Priest</td>\n      <td>02</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>62064</th>\n      <td>0691215001738FCR69</td>\n      <td>1384.0</td>\n      <td>1200.0</td>\n      <td>184.0</td>\n      <td>1384.0</td>\n      <td>Rhône-Alpes</td>\n      <td>2015-12-28</td>\n      <td>32.0</td>\n      <td>Concubin (e)</td>\n      <td>69.0</td>\n      <td>...</td>\n      <td>15780.0</td>\n      <td>69153</td>\n      <td>Poleymieux-au-Mont-d'Or</td>\n      <td>900.0</td>\n      <td>F</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n      <td>Poleymieux-au-Mont-d'Or</td>\n      <td>02</td>\n    </tr>\n    <tr>\n      <th>62065</th>\n      <td>0691217089044FCR69</td>\n      <td>1400.0</td>\n      <td>1400.0</td>\n      <td>0.0</td>\n      <td>1400.0</td>\n      <td>Rhône-Alpes</td>\n      <td>2017-12-04</td>\n      <td>37.0</td>\n      <td>Pacsé (e)</td>\n      <td>69.0</td>\n      <td>...</td>\n      <td>14358.0</td>\n      <td>69153</td>\n      <td>Poleymieux-au-Mont-d'Or</td>\n      <td>600.0</td>\n      <td>F</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n      <td>Poleymieux-au-Mont-d'Or</td>\n      <td>02</td>\n    </tr>\n    <tr>\n      <th>62066</th>\n      <td>0690717069962GDPUB</td>\n      <td>1900.0</td>\n      <td>1900.0</td>\n      <td>0.0</td>\n      <td>1900.0</td>\n      <td>Poitou-Charentes</td>\n      <td>2017-07-03</td>\n      <td>36.0</td>\n      <td>Marié (e)</td>\n      <td>17.0</td>\n      <td>...</td>\n      <td>23924.0</td>\n      <td>69153</td>\n      <td>Poleymieux-au-Mont-d'Or</td>\n      <td>1100.0</td>\n      <td>M</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n      <td>Poleymieux-au-Mont-d'Or</td>\n      <td>02</td>\n    </tr>\n    <tr>\n      <th>62067</th>\n      <td>0690817073543AL003</td>\n      <td>1650.0</td>\n      <td>1650.0</td>\n      <td>0.0</td>\n      <td>1650.0</td>\n      <td>Rhône-Alpes</td>\n      <td>2017-08-02</td>\n      <td>37.0</td>\n      <td>Marié (e)</td>\n      <td>69.0</td>\n      <td>...</td>\n      <td>41209.0</td>\n      <td>69071</td>\n      <td>Curis-au-Mont-d'Or</td>\n      <td>0.0</td>\n      <td>F</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n      <td>Curis-au-Mont-d'Or</td>\n      <td>02</td>\n    </tr>\n    <tr>\n      <th>62068</th>\n      <td>069121513858311189</td>\n      <td>1226.0</td>\n      <td>1300.0</td>\n      <td>1.0</td>\n      <td>1301.0</td>\n      <td>Rhône-Alpes</td>\n      <td>2015-11-30</td>\n      <td>54.0</td>\n      <td>Marié (e)</td>\n      <td>69.0</td>\n      <td>...</td>\n      <td>10433.0</td>\n      <td>69071</td>\n      <td>Curis-au-Mont-d'Or</td>\n      <td>300.0</td>\n      <td>M</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n      <td>Curis-au-Mont-d'Or</td>\n      <td>02</td>\n    </tr>\n  </tbody>\n</table>\n<p>62069 rows × 33 columns</p>\n</div>"
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfd['Code Géographique']=dfd['Code Géographique'].astype(str)\n",
    "base= dfd.merge(df, on='Code Géographique', how='inner')\n",
    "base"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "outputs": [],
   "source": [
    "file_name = 'Lyon_final.csv'\n",
    "base.to_csv(file_name)"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "markdown",
   "source": [
    "## Marseille"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%% md\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\arceb\\AppData\\Local\\Temp\\ipykernel_40984\\2202805944.py:1: DtypeWarning: Columns (10,11) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  dfd = pd.read_csv(r'C:\\Users\\arceb\\PycharmProjects\\pythonProject/Marseille.csv', index_col = 0)\n"
     ]
    },
    {
     "data": {
      "text/plain": "            Numéro Unique  RM Moyennes  \\\n0      013011204268411400        830.0   \n1      013011204496911379        690.0   \n2      013011308057313103        598.0   \n3      013011412161111378        972.0   \n4      013011412266011378       1889.0   \n...                   ...          ...   \n74613  0131217301997GDPUB       1162.0   \n74614  0131217302048GDPUB        545.0   \n74615  0131217312848AL002       1486.0   \n74616  084021706603611409       1485.0   \n74617  0840717070307GDPUB          0.0   \n\n       Ressources imposables mensuelles moyennes (RI)  \\\n0                                               830.0   \n1                                               690.0   \n2                                                 0.0   \n3                                               972.0   \n4                                              1209.0   \n...                                               ...   \n74613                                          1162.0   \n74614                                             0.0   \n74615                                          1636.0   \n74616                                             0.0   \n74617                                             0.0   \n\n       Prestations familiales et sociales mensuelles moyennes (PFS)  Ri + PFS  \\\n0                                                    0.0                830.0   \n1                                                    0.0                690.0   \n2                                                  598.0                598.0   \n3                                                    0.0                972.0   \n4                                                  680.0               1889.0   \n...                                                  ...                  ...   \n74613                                                0.0               1162.0   \n74614                                              545.0                545.0   \n74615                                                0.0               1636.0   \n74616                                             1485.0               1485.0   \n74617                                                0.0                  0.0   \n\n                           région Date création demande  Age demandeur  \\\n0      Provence-Alpes-Côte d'Azur            2012-01-06           67.0   \n1      Provence-Alpes-Côte d'Azur            2012-01-26           55.0   \n2      Provence-Alpes-Côte d'Azur            2013-01-08           41.0   \n3      Provence-Alpes-Côte d'Azur            2014-01-16           77.0   \n4      Provence-Alpes-Côte d'Azur            2014-01-25           40.0   \n...                           ...                   ...            ...   \n74613            Poitou-Charentes            2017-12-26           74.0   \n74614            Pays de la Loire            2017-12-27           27.0   \n74615                    Picardie            2017-12-22           43.0   \n74616            Poitou-Charentes            2017-02-10           38.0   \n74617                    Picardie            2017-07-14           25.0   \n\n      Situation familiale Code département logement actuel  ...  \\\n0             Célibataire                              4.0  ...   \n1              Séparé (e)                              6.0  ...   \n2             Célibataire                              4.0  ...   \n3               Marié (e)                              5.0  ...   \n4               Marié (e)                              6.0  ...   \n...                   ...                              ...  ...   \n74613          Séparé (e)                             79.0  ...   \n74614         Célibataire                             72.0  ...   \n74615         Divorcé (e)                              2.0  ...   \n74616        Concubin (e)                             16.0  ...   \n74617         Célibataire                              2.0  ...   \n\n      Ressources mensuelles du foyer RFR du foyer, année n-1  \\\n0                              830.0                     0.0   \n1                              690.0                  8247.0   \n2                              598.0                     0.0   \n3                             2185.0                 26233.0   \n4                             1889.0                 10393.0   \n...                              ...                     ...   \n74613                         1162.0                 11553.0   \n74614                          545.0                     0.0   \n74615                         1486.0                     NaN   \n74616                         1485.0                     NaN   \n74617                            0.0                     0.0   \n\n      RFR du foyer, année n-2 Code Géographique  Commune logement souhaité  \\\n0                         0.0             13054                  Marignane   \n1                      8120.0             13001            Aix-en-Provence   \n2                         0.0             13103          Salon-de-Provence   \n3                     26209.0             13081                     Rognac   \n4                      9214.0             13002                    Allauch   \n...                       ...               ...                        ...   \n74613                 11553.0             13055                  Marseille   \n74614                     0.0             13001            Aix-en-Provence   \n74615                 24073.0             13117                  Vitrolles   \n74616                     2.0             84089                    Pertuis   \n74617                     0.0             84089                    Pertuis   \n\n       Montant maxi (loyer+charges) supportable  Sexe demandeur\\n  \\\n0                                         400.0                 M   \n1                                         550.0                 F   \n2                                           0.0                 F   \n3                                         550.0                 F   \n4                                        1000.0                 M   \n...                                         ...               ...   \n74613                                     450.0                 F   \n74614                                     400.0                 M   \n74615                                     445.0                 M   \n74616                                     600.0                 F   \n74617                                     500.0                 F   \n\n      Nationalité demandeur\\n Autre logement dé\\ntenu demandeur\\n  \\\n0                   Française                                 Non   \n1                   Française                                 Non   \n2                   Française                                 Non   \n3                   Française                                 Non   \n4                   Française                                 Non   \n...                       ...                                 ...   \n74613               Française                                 Non   \n74614               Française                                 Non   \n74615               Française                                 Non   \n74616               Française                                 Non   \n74617               Française                                 Non   \n\n      Nb de personnes handicapees  \n0                             0.0  \n1                             0.0  \n2                             0.0  \n3                             0.0  \n4                             0.0  \n...                           ...  \n74613                         0.0  \n74614                         0.0  \n74615                         0.0  \n74616                         0.0  \n74617                         0.0  \n\n[74618 rows x 31 columns]",
      "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>Numéro Unique</th>\n      <th>RM Moyennes</th>\n      <th>Ressources imposables mensuelles moyennes (RI)</th>\n      <th>Prestations familiales et sociales mensuelles moyennes (PFS)</th>\n      <th>Ri + PFS</th>\n      <th>région</th>\n      <th>Date création demande</th>\n      <th>Age demandeur</th>\n      <th>Situation familiale</th>\n      <th>Code département logement actuel</th>\n      <th>...</th>\n      <th>Ressources mensuelles du foyer</th>\n      <th>RFR du foyer, année n-1</th>\n      <th>RFR du foyer, année n-2</th>\n      <th>Code Géographique</th>\n      <th>Commune logement souhaité</th>\n      <th>Montant maxi (loyer+charges) supportable</th>\n      <th>Sexe demandeur\\n</th>\n      <th>Nationalité demandeur\\n</th>\n      <th>Autre logement dé\\ntenu demandeur\\n</th>\n      <th>Nb de personnes handicapees</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>013011204268411400</td>\n      <td>830.0</td>\n      <td>830.0</td>\n      <td>0.0</td>\n      <td>830.0</td>\n      <td>Provence-Alpes-Côte d'Azur</td>\n      <td>2012-01-06</td>\n      <td>67.0</td>\n      <td>Célibataire</td>\n      <td>4.0</td>\n      <td>...</td>\n      <td>830.0</td>\n      <td>0.0</td>\n      <td>0.0</td>\n      <td>13054</td>\n      <td>Marignane</td>\n      <td>400.0</td>\n      <td>M</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>013011204496911379</td>\n      <td>690.0</td>\n      <td>690.0</td>\n      <td>0.0</td>\n      <td>690.0</td>\n      <td>Provence-Alpes-Côte d'Azur</td>\n      <td>2012-01-26</td>\n      <td>55.0</td>\n      <td>Séparé (e)</td>\n      <td>6.0</td>\n      <td>...</td>\n      <td>690.0</td>\n      <td>8247.0</td>\n      <td>8120.0</td>\n      <td>13001</td>\n      <td>Aix-en-Provence</td>\n      <td>550.0</td>\n      <td>F</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>013011308057313103</td>\n      <td>598.0</td>\n      <td>0.0</td>\n      <td>598.0</td>\n      <td>598.0</td>\n      <td>Provence-Alpes-Côte d'Azur</td>\n      <td>2013-01-08</td>\n      <td>41.0</td>\n      <td>Célibataire</td>\n      <td>4.0</td>\n      <td>...</td>\n      <td>598.0</td>\n      <td>0.0</td>\n      <td>0.0</td>\n      <td>13103</td>\n      <td>Salon-de-Provence</td>\n      <td>0.0</td>\n      <td>F</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>013011412161111378</td>\n      <td>972.0</td>\n      <td>972.0</td>\n      <td>0.0</td>\n      <td>972.0</td>\n      <td>Provence-Alpes-Côte d'Azur</td>\n      <td>2014-01-16</td>\n      <td>77.0</td>\n      <td>Marié (e)</td>\n      <td>5.0</td>\n      <td>...</td>\n      <td>2185.0</td>\n      <td>26233.0</td>\n      <td>26209.0</td>\n      <td>13081</td>\n      <td>Rognac</td>\n      <td>550.0</td>\n      <td>F</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>013011412266011378</td>\n      <td>1889.0</td>\n      <td>1209.0</td>\n      <td>680.0</td>\n      <td>1889.0</td>\n      <td>Provence-Alpes-Côte d'Azur</td>\n      <td>2014-01-25</td>\n      <td>40.0</td>\n      <td>Marié (e)</td>\n      <td>6.0</td>\n      <td>...</td>\n      <td>1889.0</td>\n      <td>10393.0</td>\n      <td>9214.0</td>\n      <td>13002</td>\n      <td>Allauch</td>\n      <td>1000.0</td>\n      <td>M</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n    </tr>\n    <tr>\n      <th>...</th>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n    </tr>\n    <tr>\n      <th>74613</th>\n      <td>0131217301997GDPUB</td>\n      <td>1162.0</td>\n      <td>1162.0</td>\n      <td>0.0</td>\n      <td>1162.0</td>\n      <td>Poitou-Charentes</td>\n      <td>2017-12-26</td>\n      <td>74.0</td>\n      <td>Séparé (e)</td>\n      <td>79.0</td>\n      <td>...</td>\n      <td>1162.0</td>\n      <td>11553.0</td>\n      <td>11553.0</td>\n      <td>13055</td>\n      <td>Marseille</td>\n      <td>450.0</td>\n      <td>F</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n    </tr>\n    <tr>\n      <th>74614</th>\n      <td>0131217302048GDPUB</td>\n      <td>545.0</td>\n      <td>0.0</td>\n      <td>545.0</td>\n      <td>545.0</td>\n      <td>Pays de la Loire</td>\n      <td>2017-12-27</td>\n      <td>27.0</td>\n      <td>Célibataire</td>\n      <td>72.0</td>\n      <td>...</td>\n      <td>545.0</td>\n      <td>0.0</td>\n      <td>0.0</td>\n      <td>13001</td>\n      <td>Aix-en-Provence</td>\n      <td>400.0</td>\n      <td>M</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n    </tr>\n    <tr>\n      <th>74615</th>\n      <td>0131217312848AL002</td>\n      <td>1486.0</td>\n      <td>1636.0</td>\n      <td>0.0</td>\n      <td>1636.0</td>\n      <td>Picardie</td>\n      <td>2017-12-22</td>\n      <td>43.0</td>\n      <td>Divorcé (e)</td>\n      <td>2.0</td>\n      <td>...</td>\n      <td>1486.0</td>\n      <td>NaN</td>\n      <td>24073.0</td>\n      <td>13117</td>\n      <td>Vitrolles</td>\n      <td>445.0</td>\n      <td>M</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n    </tr>\n    <tr>\n      <th>74616</th>\n      <td>084021706603611409</td>\n      <td>1485.0</td>\n      <td>0.0</td>\n      <td>1485.0</td>\n      <td>1485.0</td>\n      <td>Poitou-Charentes</td>\n      <td>2017-02-10</td>\n      <td>38.0</td>\n      <td>Concubin (e)</td>\n      <td>16.0</td>\n      <td>...</td>\n      <td>1485.0</td>\n      <td>NaN</td>\n      <td>2.0</td>\n      <td>84089</td>\n      <td>Pertuis</td>\n      <td>600.0</td>\n      <td>F</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n    </tr>\n    <tr>\n      <th>74617</th>\n      <td>0840717070307GDPUB</td>\n      <td>0.0</td>\n      <td>0.0</td>\n      <td>0.0</td>\n      <td>0.0</td>\n      <td>Picardie</td>\n      <td>2017-07-14</td>\n      <td>25.0</td>\n      <td>Célibataire</td>\n      <td>2.0</td>\n      <td>...</td>\n      <td>0.0</td>\n      <td>0.0</td>\n      <td>0.0</td>\n      <td>84089</td>\n      <td>Pertuis</td>\n      <td>500.0</td>\n      <td>F</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n    </tr>\n  </tbody>\n</table>\n<p>74618 rows × 31 columns</p>\n</div>"
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfd = pd.read_csv(r'C:\\Users\\arceb\\PycharmProjects\\pythonProject/Marseille.csv', index_col = 0)\n",
    "dfd=dfd.rename(columns={'Code INSEE commune logt souhaité': 'Code Géographique'})\n",
    "dfd"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "outputs": [],
   "source": [
    "dfd['Code Géographique']=dfd['Code Géographique'].astype(int)"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "outputs": [
    {
     "data": {
      "text/plain": "            Numéro Unique  RM Moyennes  \\\n0      013011204268411400        830.0   \n1      013011204496911379        690.0   \n2      013011308057313103        598.0   \n3      013011412161111378        972.0   \n4      013011412266011378       1889.0   \n...                   ...          ...   \n74613  0131217301997GDPUB       1162.0   \n74614  0131217302048GDPUB        545.0   \n74615  0131217312848AL002       1486.0   \n74616  084021706603611409       1485.0   \n74617  0840717070307GDPUB          0.0   \n\n       Ressources imposables mensuelles moyennes (RI)  \\\n0                                               830.0   \n1                                               690.0   \n2                                                 0.0   \n3                                               972.0   \n4                                              1209.0   \n...                                               ...   \n74613                                          1162.0   \n74614                                             0.0   \n74615                                          1636.0   \n74616                                             0.0   \n74617                                             0.0   \n\n       Prestations familiales et sociales mensuelles moyennes (PFS)  Ri + PFS  \\\n0                                                    0.0                830.0   \n1                                                    0.0                690.0   \n2                                                  598.0                598.0   \n3                                                    0.0                972.0   \n4                                                  680.0               1889.0   \n...                                                  ...                  ...   \n74613                                                0.0               1162.0   \n74614                                              545.0                545.0   \n74615                                                0.0               1636.0   \n74616                                             1485.0               1485.0   \n74617                                                0.0                  0.0   \n\n                           région Date création demande  Age demandeur  \\\n0      Provence-Alpes-Côte d'Azur            2012-01-06           67.0   \n1      Provence-Alpes-Côte d'Azur            2012-01-26           55.0   \n2      Provence-Alpes-Côte d'Azur            2013-01-08           41.0   \n3      Provence-Alpes-Côte d'Azur            2014-01-16           77.0   \n4      Provence-Alpes-Côte d'Azur            2014-01-25           40.0   \n...                           ...                   ...            ...   \n74613            Poitou-Charentes            2017-12-26           74.0   \n74614            Pays de la Loire            2017-12-27           27.0   \n74615                    Picardie            2017-12-22           43.0   \n74616            Poitou-Charentes            2017-02-10           38.0   \n74617                    Picardie            2017-07-14           25.0   \n\n      Situation familiale Code département logement actuel  ...  \\\n0             Célibataire                              4.0  ...   \n1              Séparé (e)                              6.0  ...   \n2             Célibataire                              4.0  ...   \n3               Marié (e)                              5.0  ...   \n4               Marié (e)                              6.0  ...   \n...                   ...                              ...  ...   \n74613          Séparé (e)                             79.0  ...   \n74614         Célibataire                             72.0  ...   \n74615         Divorcé (e)                              2.0  ...   \n74616        Concubin (e)                             16.0  ...   \n74617         Célibataire                              2.0  ...   \n\n      Ressources mensuelles du foyer RFR du foyer, année n-1  \\\n0                              830.0                     0.0   \n1                              690.0                  8247.0   \n2                              598.0                     0.0   \n3                             2185.0                 26233.0   \n4                             1889.0                 10393.0   \n...                              ...                     ...   \n74613                         1162.0                 11553.0   \n74614                          545.0                     0.0   \n74615                         1486.0                     NaN   \n74616                         1485.0                     NaN   \n74617                            0.0                     0.0   \n\n      RFR du foyer, année n-2 Code Géographique  Commune logement souhaité  \\\n0                         0.0             13054                  Marignane   \n1                      8120.0             13001            Aix-en-Provence   \n2                         0.0             13103          Salon-de-Provence   \n3                     26209.0             13081                     Rognac   \n4                      9214.0             13002                    Allauch   \n...                       ...               ...                        ...   \n74613                 11553.0             13055                  Marseille   \n74614                     0.0             13001            Aix-en-Provence   \n74615                 24073.0             13117                  Vitrolles   \n74616                     2.0             84089                    Pertuis   \n74617                     0.0             84089                    Pertuis   \n\n       Montant maxi (loyer+charges) supportable  Sexe demandeur\\n  \\\n0                                         400.0                 M   \n1                                         550.0                 F   \n2                                           0.0                 F   \n3                                         550.0                 F   \n4                                        1000.0                 M   \n...                                         ...               ...   \n74613                                     450.0                 F   \n74614                                     400.0                 M   \n74615                                     445.0                 M   \n74616                                     600.0                 F   \n74617                                     500.0                 F   \n\n      Nationalité demandeur\\n Autre logement dé\\ntenu demandeur\\n  \\\n0                   Française                                 Non   \n1                   Française                                 Non   \n2                   Française                                 Non   \n3                   Française                                 Non   \n4                   Française                                 Non   \n...                       ...                                 ...   \n74613               Française                                 Non   \n74614               Française                                 Non   \n74615               Française                                 Non   \n74616               Française                                 Non   \n74617               Française                                 Non   \n\n      Nb de personnes handicapees  \n0                             0.0  \n1                             0.0  \n2                             0.0  \n3                             0.0  \n4                             0.0  \n...                           ...  \n74613                         0.0  \n74614                         0.0  \n74615                         0.0  \n74616                         0.0  \n74617                         0.0  \n\n[74618 rows x 31 columns]",
      "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>Numéro Unique</th>\n      <th>RM Moyennes</th>\n      <th>Ressources imposables mensuelles moyennes (RI)</th>\n      <th>Prestations familiales et sociales mensuelles moyennes (PFS)</th>\n      <th>Ri + PFS</th>\n      <th>région</th>\n      <th>Date création demande</th>\n      <th>Age demandeur</th>\n      <th>Situation familiale</th>\n      <th>Code département logement actuel</th>\n      <th>...</th>\n      <th>Ressources mensuelles du foyer</th>\n      <th>RFR du foyer, année n-1</th>\n      <th>RFR du foyer, année n-2</th>\n      <th>Code Géographique</th>\n      <th>Commune logement souhaité</th>\n      <th>Montant maxi (loyer+charges) supportable</th>\n      <th>Sexe demandeur\\n</th>\n      <th>Nationalité demandeur\\n</th>\n      <th>Autre logement dé\\ntenu demandeur\\n</th>\n      <th>Nb de personnes handicapees</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>013011204268411400</td>\n      <td>830.0</td>\n      <td>830.0</td>\n      <td>0.0</td>\n      <td>830.0</td>\n      <td>Provence-Alpes-Côte d'Azur</td>\n      <td>2012-01-06</td>\n      <td>67.0</td>\n      <td>Célibataire</td>\n      <td>4.0</td>\n      <td>...</td>\n      <td>830.0</td>\n      <td>0.0</td>\n      <td>0.0</td>\n      <td>13054</td>\n      <td>Marignane</td>\n      <td>400.0</td>\n      <td>M</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>013011204496911379</td>\n      <td>690.0</td>\n      <td>690.0</td>\n      <td>0.0</td>\n      <td>690.0</td>\n      <td>Provence-Alpes-Côte d'Azur</td>\n      <td>2012-01-26</td>\n      <td>55.0</td>\n      <td>Séparé (e)</td>\n      <td>6.0</td>\n      <td>...</td>\n      <td>690.0</td>\n      <td>8247.0</td>\n      <td>8120.0</td>\n      <td>13001</td>\n      <td>Aix-en-Provence</td>\n      <td>550.0</td>\n      <td>F</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>013011308057313103</td>\n      <td>598.0</td>\n      <td>0.0</td>\n      <td>598.0</td>\n      <td>598.0</td>\n      <td>Provence-Alpes-Côte d'Azur</td>\n      <td>2013-01-08</td>\n      <td>41.0</td>\n      <td>Célibataire</td>\n      <td>4.0</td>\n      <td>...</td>\n      <td>598.0</td>\n      <td>0.0</td>\n      <td>0.0</td>\n      <td>13103</td>\n      <td>Salon-de-Provence</td>\n      <td>0.0</td>\n      <td>F</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>013011412161111378</td>\n      <td>972.0</td>\n      <td>972.0</td>\n      <td>0.0</td>\n      <td>972.0</td>\n      <td>Provence-Alpes-Côte d'Azur</td>\n      <td>2014-01-16</td>\n      <td>77.0</td>\n      <td>Marié (e)</td>\n      <td>5.0</td>\n      <td>...</td>\n      <td>2185.0</td>\n      <td>26233.0</td>\n      <td>26209.0</td>\n      <td>13081</td>\n      <td>Rognac</td>\n      <td>550.0</td>\n      <td>F</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>013011412266011378</td>\n      <td>1889.0</td>\n      <td>1209.0</td>\n      <td>680.0</td>\n      <td>1889.0</td>\n      <td>Provence-Alpes-Côte d'Azur</td>\n      <td>2014-01-25</td>\n      <td>40.0</td>\n      <td>Marié (e)</td>\n      <td>6.0</td>\n      <td>...</td>\n      <td>1889.0</td>\n      <td>10393.0</td>\n      <td>9214.0</td>\n      <td>13002</td>\n      <td>Allauch</td>\n      <td>1000.0</td>\n      <td>M</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n    </tr>\n    <tr>\n      <th>...</th>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n    </tr>\n    <tr>\n      <th>74613</th>\n      <td>0131217301997GDPUB</td>\n      <td>1162.0</td>\n      <td>1162.0</td>\n      <td>0.0</td>\n      <td>1162.0</td>\n      <td>Poitou-Charentes</td>\n      <td>2017-12-26</td>\n      <td>74.0</td>\n      <td>Séparé (e)</td>\n      <td>79.0</td>\n      <td>...</td>\n      <td>1162.0</td>\n      <td>11553.0</td>\n      <td>11553.0</td>\n      <td>13055</td>\n      <td>Marseille</td>\n      <td>450.0</td>\n      <td>F</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n    </tr>\n    <tr>\n      <th>74614</th>\n      <td>0131217302048GDPUB</td>\n      <td>545.0</td>\n      <td>0.0</td>\n      <td>545.0</td>\n      <td>545.0</td>\n      <td>Pays de la Loire</td>\n      <td>2017-12-27</td>\n      <td>27.0</td>\n      <td>Célibataire</td>\n      <td>72.0</td>\n      <td>...</td>\n      <td>545.0</td>\n      <td>0.0</td>\n      <td>0.0</td>\n      <td>13001</td>\n      <td>Aix-en-Provence</td>\n      <td>400.0</td>\n      <td>M</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n    </tr>\n    <tr>\n      <th>74615</th>\n      <td>0131217312848AL002</td>\n      <td>1486.0</td>\n      <td>1636.0</td>\n      <td>0.0</td>\n      <td>1636.0</td>\n      <td>Picardie</td>\n      <td>2017-12-22</td>\n      <td>43.0</td>\n      <td>Divorcé (e)</td>\n      <td>2.0</td>\n      <td>...</td>\n      <td>1486.0</td>\n      <td>NaN</td>\n      <td>24073.0</td>\n      <td>13117</td>\n      <td>Vitrolles</td>\n      <td>445.0</td>\n      <td>M</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n    </tr>\n    <tr>\n      <th>74616</th>\n      <td>084021706603611409</td>\n      <td>1485.0</td>\n      <td>0.0</td>\n      <td>1485.0</td>\n      <td>1485.0</td>\n      <td>Poitou-Charentes</td>\n      <td>2017-02-10</td>\n      <td>38.0</td>\n      <td>Concubin (e)</td>\n      <td>16.0</td>\n      <td>...</td>\n      <td>1485.0</td>\n      <td>NaN</td>\n      <td>2.0</td>\n      <td>84089</td>\n      <td>Pertuis</td>\n      <td>600.0</td>\n      <td>F</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n    </tr>\n    <tr>\n      <th>74617</th>\n      <td>0840717070307GDPUB</td>\n      <td>0.0</td>\n      <td>0.0</td>\n      <td>0.0</td>\n      <td>0.0</td>\n      <td>Picardie</td>\n      <td>2017-07-14</td>\n      <td>25.0</td>\n      <td>Célibataire</td>\n      <td>2.0</td>\n      <td>...</td>\n      <td>0.0</td>\n      <td>0.0</td>\n      <td>0.0</td>\n      <td>84089</td>\n      <td>Pertuis</td>\n      <td>500.0</td>\n      <td>F</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n    </tr>\n  </tbody>\n</table>\n<p>74618 rows × 31 columns</p>\n</div>"
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def code2(commune):\n",
    "    if commune>=13201 and commune<=13216 :\n",
    "        return 13055\n",
    "    else :\n",
    "        return commune\n",
    "\n",
    "\n",
    "dfd['Code Géographique'] = dfd['Code Géographique'].apply(code2)\n",
    "dfd"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "outputs": [
    {
     "data": {
      "text/plain": "            Numéro Unique  RM Moyennes  \\\n0      013011204268411400        830.0   \n1      013021621166211404       1400.0   \n2      013061727648911378        470.0   \n3      0130617278415GDPUB       1376.0   \n4      0130617279644AG002       2337.0   \n...                   ...          ...   \n74613  013081728488811445        898.0   \n74614  013111625006913R03       1854.0   \n74615  0130716233378GDPUB        848.0   \n74616  013091414980411378       1410.0   \n74617  013091728922411391       1418.0   \n\n       Ressources imposables mensuelles moyennes (RI)  \\\n0                                               830.0   \n1                                              1400.0   \n2                                                 0.0   \n3                                              1376.0   \n4                                              2143.0   \n...                                               ...   \n74613                                           898.0   \n74614                                          1725.0   \n74615                                           848.0   \n74616                                          1500.0   \n74617                                          1418.0   \n\n       Prestations familiales et sociales mensuelles moyennes (PFS)  Ri + PFS  \\\n0                                                    0.0                830.0   \n1                                                    0.0               1400.0   \n2                                                  470.0                470.0   \n3                                                    0.0               1376.0   \n4                                                  194.0               2337.0   \n...                                                  ...                  ...   \n74613                                                0.0                898.0   \n74614                                              129.0               1854.0   \n74615                                                0.0                848.0   \n74616                                                0.0               1500.0   \n74617                                                0.0               1418.0   \n\n                           région Date création demande  Age demandeur  \\\n0      Provence-Alpes-Côte d'Azur            2012-01-06           67.0   \n1      Provence-Alpes-Côte d'Azur            2016-02-16           48.0   \n2      Provence-Alpes-Côte d'Azur            2017-06-01           54.0   \n3      Provence-Alpes-Côte d'Azur            2017-06-15           62.0   \n4      Provence-Alpes-Côte d'Azur            2017-06-27           50.0   \n...                           ...                   ...            ...   \n74613  Provence-Alpes-Côte d'Azur            2017-08-08           52.0   \n74614  Provence-Alpes-Côte d'Azur            2016-11-23           44.0   \n74615  Provence-Alpes-Côte d'Azur            2016-07-03           34.0   \n74616  Provence-Alpes-Côte d'Azur            2014-09-23           44.0   \n74617  Provence-Alpes-Côte d'Azur            2017-09-14           66.0   \n\n      Situation familiale Code département logement actuel  ...  \\\n0             Célibataire                              4.0  ...   \n1               Marié (e)                              4.0  ...   \n2             Célibataire                             83.0  ...   \n3             Divorcé (e)                             83.0  ...   \n4             Célibataire                             84.0  ...   \n...                   ...                              ...  ...   \n74613         Célibataire                             13.0  ...   \n74614         Divorcé (e)                             13.0  ...   \n74615         Célibataire                             13.0  ...   \n74616         Divorcé (e)                             13.0  ...   \n74617           Veuf (ve)                             13.0  ...   \n\n      RFR du foyer, année n-2 Code Géographique Commune logement souhaité  \\\n0                         0.0             13054                 Marignane   \n1                     28121.0             13054                 Marignane   \n2                         NaN             13054                 Marignane   \n3                     18983.0             13054                 Marignane   \n4                     21541.0             13054                 Marignane   \n...                       ...               ...                       ...   \n74613                 24604.0             13029         Cornillon-Confoux   \n74614                     NaN             13029         Cornillon-Confoux   \n74615                  8225.0             13012               Beaurecueil   \n74616                     NaN             13020                  Cadolive   \n74617                 15837.0             13115                 Vernègues   \n\n      Montant maxi (loyer+charges) supportable  Sexe demandeur\\n  \\\n0                                        400.0                 M   \n1                                        800.0                 M   \n2                                          NaN                 F   \n3                                          0.0                 F   \n4                                          0.0                 F   \n...                                        ...               ...   \n74613                                      0.0                 M   \n74614                                    630.0                 F   \n74615                                    350.0                 F   \n74616                                    500.0                 M   \n74617                                      NaN                 F   \n\n       Nationalité demandeur\\n  Autre logement dé\\ntenu demandeur\\n  \\\n0                    Française                                  Non   \n1                    Française                                  Non   \n2                    Française                                  Non   \n3                    Française                                  Non   \n4                    Française                                  Non   \n...                        ...                                  ...   \n74613                Française                                  Non   \n74614         Union Européenne                                  Non   \n74615                Française                                  Non   \n74616                Française                                  Non   \n74617                Française                                  Non   \n\n      Nb de personnes handicapees Libellé de la commune  \\\n0                             0.0             Marignane   \n1                             0.0             Marignane   \n2                             0.0             Marignane   \n3                             0.0             Marignane   \n4                             0.0             Marignane   \n...                           ...                   ...   \n74613                         0.0     Cornillon-Confoux   \n74614                         0.0     Cornillon-Confoux   \n74615                         0.0           Beaurecueil   \n74616                         0.0              Cadolive   \n74617                         0.0             Vernègues   \n\n      Zonage I/II/III\\nArrêté du 17 mars 1978 relatif au classement des communes par zones geographiques  \n0                                                     02                                                  \n1                                                     02                                                  \n2                                                     02                                                  \n3                                                     02                                                  \n4                                                     02                                                  \n...                                                  ...                                                  \n74613                                                 02                                                  \n74614                                                 02                                                  \n74615                                                 03                                                  \n74616                                                 02                                                  \n74617                                                 03                                                  \n\n[74618 rows x 33 columns]",
      "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>Numéro Unique</th>\n      <th>RM Moyennes</th>\n      <th>Ressources imposables mensuelles moyennes (RI)</th>\n      <th>Prestations familiales et sociales mensuelles moyennes (PFS)</th>\n      <th>Ri + PFS</th>\n      <th>région</th>\n      <th>Date création demande</th>\n      <th>Age demandeur</th>\n      <th>Situation familiale</th>\n      <th>Code département logement actuel</th>\n      <th>...</th>\n      <th>RFR du foyer, année n-2</th>\n      <th>Code Géographique</th>\n      <th>Commune logement souhaité</th>\n      <th>Montant maxi (loyer+charges) supportable</th>\n      <th>Sexe demandeur\\n</th>\n      <th>Nationalité demandeur\\n</th>\n      <th>Autre logement dé\\ntenu demandeur\\n</th>\n      <th>Nb de personnes handicapees</th>\n      <th>Libellé de la commune</th>\n      <th>Zonage I/II/III\\nArrêté du 17 mars 1978 relatif au classement des communes par zones geographiques</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>013011204268411400</td>\n      <td>830.0</td>\n      <td>830.0</td>\n      <td>0.0</td>\n      <td>830.0</td>\n      <td>Provence-Alpes-Côte d'Azur</td>\n      <td>2012-01-06</td>\n      <td>67.0</td>\n      <td>Célibataire</td>\n      <td>4.0</td>\n      <td>...</td>\n      <td>0.0</td>\n      <td>13054</td>\n      <td>Marignane</td>\n      <td>400.0</td>\n      <td>M</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n      <td>Marignane</td>\n      <td>02</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>013021621166211404</td>\n      <td>1400.0</td>\n      <td>1400.0</td>\n      <td>0.0</td>\n      <td>1400.0</td>\n      <td>Provence-Alpes-Côte d'Azur</td>\n      <td>2016-02-16</td>\n      <td>48.0</td>\n      <td>Marié (e)</td>\n      <td>4.0</td>\n      <td>...</td>\n      <td>28121.0</td>\n      <td>13054</td>\n      <td>Marignane</td>\n      <td>800.0</td>\n      <td>M</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n      <td>Marignane</td>\n      <td>02</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>013061727648911378</td>\n      <td>470.0</td>\n      <td>0.0</td>\n      <td>470.0</td>\n      <td>470.0</td>\n      <td>Provence-Alpes-Côte d'Azur</td>\n      <td>2017-06-01</td>\n      <td>54.0</td>\n      <td>Célibataire</td>\n      <td>83.0</td>\n      <td>...</td>\n      <td>NaN</td>\n      <td>13054</td>\n      <td>Marignane</td>\n      <td>NaN</td>\n      <td>F</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n      <td>Marignane</td>\n      <td>02</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>0130617278415GDPUB</td>\n      <td>1376.0</td>\n      <td>1376.0</td>\n      <td>0.0</td>\n      <td>1376.0</td>\n      <td>Provence-Alpes-Côte d'Azur</td>\n      <td>2017-06-15</td>\n      <td>62.0</td>\n      <td>Divorcé (e)</td>\n      <td>83.0</td>\n      <td>...</td>\n      <td>18983.0</td>\n      <td>13054</td>\n      <td>Marignane</td>\n      <td>0.0</td>\n      <td>F</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n      <td>Marignane</td>\n      <td>02</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>0130617279644AG002</td>\n      <td>2337.0</td>\n      <td>2143.0</td>\n      <td>194.0</td>\n      <td>2337.0</td>\n      <td>Provence-Alpes-Côte d'Azur</td>\n      <td>2017-06-27</td>\n      <td>50.0</td>\n      <td>Célibataire</td>\n      <td>84.0</td>\n      <td>...</td>\n      <td>21541.0</td>\n      <td>13054</td>\n      <td>Marignane</td>\n      <td>0.0</td>\n      <td>F</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n      <td>Marignane</td>\n      <td>02</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>74613</th>\n      <td>013081728488811445</td>\n      <td>898.0</td>\n      <td>898.0</td>\n      <td>0.0</td>\n      <td>898.0</td>\n      <td>Provence-Alpes-Côte d'Azur</td>\n      <td>2017-08-08</td>\n      <td>52.0</td>\n      <td>Célibataire</td>\n      <td>13.0</td>\n      <td>...</td>\n      <td>24604.0</td>\n      <td>13029</td>\n      <td>Cornillon-Confoux</td>\n      <td>0.0</td>\n      <td>M</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n      <td>Cornillon-Confoux</td>\n      <td>02</td>\n    </tr>\n    <tr>\n      <th>74614</th>\n      <td>013111625006913R03</td>\n      <td>1854.0</td>\n      <td>1725.0</td>\n      <td>129.0</td>\n      <td>1854.0</td>\n      <td>Provence-Alpes-Côte d'Azur</td>\n      <td>2016-11-23</td>\n      <td>44.0</td>\n      <td>Divorcé (e)</td>\n      <td>13.0</td>\n      <td>...</td>\n      <td>NaN</td>\n      <td>13029</td>\n      <td>Cornillon-Confoux</td>\n      <td>630.0</td>\n      <td>F</td>\n      <td>Union Européenne</td>\n      <td>Non</td>\n      <td>0.0</td>\n      <td>Cornillon-Confoux</td>\n      <td>02</td>\n    </tr>\n    <tr>\n      <th>74615</th>\n      <td>0130716233378GDPUB</td>\n      <td>848.0</td>\n      <td>848.0</td>\n      <td>0.0</td>\n      <td>848.0</td>\n      <td>Provence-Alpes-Côte d'Azur</td>\n      <td>2016-07-03</td>\n      <td>34.0</td>\n      <td>Célibataire</td>\n      <td>13.0</td>\n      <td>...</td>\n      <td>8225.0</td>\n      <td>13012</td>\n      <td>Beaurecueil</td>\n      <td>350.0</td>\n      <td>F</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n      <td>Beaurecueil</td>\n      <td>03</td>\n    </tr>\n    <tr>\n      <th>74616</th>\n      <td>013091414980411378</td>\n      <td>1410.0</td>\n      <td>1500.0</td>\n      <td>0.0</td>\n      <td>1500.0</td>\n      <td>Provence-Alpes-Côte d'Azur</td>\n      <td>2014-09-23</td>\n      <td>44.0</td>\n      <td>Divorcé (e)</td>\n      <td>13.0</td>\n      <td>...</td>\n      <td>NaN</td>\n      <td>13020</td>\n      <td>Cadolive</td>\n      <td>500.0</td>\n      <td>M</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n      <td>Cadolive</td>\n      <td>02</td>\n    </tr>\n    <tr>\n      <th>74617</th>\n      <td>013091728922411391</td>\n      <td>1418.0</td>\n      <td>1418.0</td>\n      <td>0.0</td>\n      <td>1418.0</td>\n      <td>Provence-Alpes-Côte d'Azur</td>\n      <td>2017-09-14</td>\n      <td>66.0</td>\n      <td>Veuf (ve)</td>\n      <td>13.0</td>\n      <td>...</td>\n      <td>15837.0</td>\n      <td>13115</td>\n      <td>Vernègues</td>\n      <td>NaN</td>\n      <td>F</td>\n      <td>Française</td>\n      <td>Non</td>\n      <td>0.0</td>\n      <td>Vernègues</td>\n      <td>03</td>\n    </tr>\n  </tbody>\n</table>\n<p>74618 rows × 33 columns</p>\n</div>"
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfd\n",
    "dfd['Code Géographique'] = dfd['Code Géographique'].astype(str)\n",
    "base = dfd.merge(df, on='Code Géographique', how='inner')\n",
    "base"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "outputs": [],
   "source": [
    "file_name = 'Marseille_final.csv'\n",
    "base.to_csv(file_name)"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n"
    }
   }
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}