2_analysis.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 254,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import json"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 255,
   "metadata": {},
   "outputs": [],
   "source": [
    "with open('coms-clean.json') as json_file:\n",
    "    coms = json.load(json_file)\n",
    "with open('evts-detail.json') as json_file:\n",
    "    evts = json.load(json_file)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 256,
   "metadata": {},
   "outputs": [],
   "source": [
    "dfcom = pd.DataFrame(coms)\n",
    "dfevt = pd.DataFrame(evts)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Nombre de communes actuelles"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Total"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 257,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(37697, 7)"
      ]
     },
     "execution_count": 257,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfcom[dfcom['evtSuppression'].isna()].shape"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Par type"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 258,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "COM     34965\n",
       "COMD     2215\n",
       "COMA      517\n",
       "Name: type, dtype: int64"
      ]
     },
     "execution_count": 258,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfcom[dfcom['evtSuppression'].isna()]['type'].value_counts()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Aucune commune sans événement de création"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 259,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>codeInsee</th>\n",
       "      <th>nom</th>\n",
       "      <th>nomSansArticle</th>\n",
       "      <th>evtCreation</th>\n",
       "      <th>id</th>\n",
       "      <th>type</th>\n",
       "      <th>evtSuppression</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [codeInsee, nom, nomSansArticle, evtCreation, id, type, evtSuppression]\n",
       "Index: []"
      ]
     },
     "execution_count": 259,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfcom[dfcom['evtCreation'].isna()]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Comparaison fichier csv COG datagouv et données sparql"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 260,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv('commune2021.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 261,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>TYPECOM</th>\n",
       "      <th>COM</th>\n",
       "      <th>REG</th>\n",
       "      <th>DEP</th>\n",
       "      <th>CTCD</th>\n",
       "      <th>ARR</th>\n",
       "      <th>TNCC</th>\n",
       "      <th>NCC</th>\n",
       "      <th>NCCENR</th>\n",
       "      <th>LIBELLE</th>\n",
       "      <th>CAN</th>\n",
       "      <th>COMPARENT</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>7092</th>\n",
       "      <td>COMA</td>\n",
       "      <td>19267</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>TOURETTE</td>\n",
       "      <td>Tourette</td>\n",
       "      <td>La Tourette</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19275.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     TYPECOM    COM  REG  DEP CTCD  ARR  TNCC       NCC    NCCENR  \\\n",
       "7092    COMA  19267  NaN  NaN  NaN  NaN     3  TOURETTE  Tourette   \n",
       "\n",
       "          LIBELLE  CAN  COMPARENT  \n",
       "7092  La Tourette  NaN    19275.0  "
      ]
     },
     "execution_count": 261,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[(df['TYPECOM'] == 'COMA') & (df['COM'] == '19267')]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Filtre hors ARM : arrondissement"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 262,
   "metadata": {},
   "outputs": [],
   "source": [
    "listcog = df[df['TYPECOM'] != 'ARM']['COM'].unique().tolist()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Filtre commune qui ont eu une suppression pour ne garder que les actuelles"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 263,
   "metadata": {},
   "outputs": [],
   "source": [
    "listrdf = dfcom[dfcom['evtSuppression'].isna()]['codeInsee'].unique().tolist()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Comparaison des deux listes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 264,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[]"
      ]
     },
     "execution_count": 264,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(set(listcog) - set(listrdf))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 265,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "37077"
      ]
     },
     "execution_count": 265,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(listcog)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 266,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "37077"
      ]
     },
     "execution_count": 266,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(listrdf)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "=> On est bon"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Fonctions"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Fonctions récupération evt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 267,
   "metadata": {},
   "outputs": [],
   "source": [
    "def getEvtByCodeInsee(codeInsee):\n",
    "    list_coms = dfcom[dfcom['codeInsee'] == codeInsee].id.to_list()\n",
    "    print(list_coms)\n",
    "    dftest = dfevt\n",
    "    dftest['is_create'] = dftest['creation'].apply(lambda x: not set(list_coms).isdisjoint(x))\n",
    "    df1 = dftest[dftest['is_create'] == True]\n",
    "    dftest['is_supp'] = dftest['suppression'].apply(lambda x: not set(list_coms).isdisjoint(x))\n",
    "    df2 = dftest[dftest['is_supp'] == True]\n",
    "    df3 = pd.concat([df1,df2])\n",
    "    return df3[~df3.index.duplicated(keep='first')].sort_values(by=['date'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 268,
   "metadata": {},
   "outputs": [],
   "source": [
    "def getEvtByNom(nom):\n",
    "    list_coms = dfcom[dfcom['nom'] == nom].id.to_list()\n",
    "    print(list_coms)\n",
    "    dftest = dfevt\n",
    "    dftest['is_create'] = dftest['creation'].apply(lambda x: not set(list_coms).isdisjoint(x))\n",
    "    df1 = dftest[dftest['is_create'] == True]\n",
    "    dftest['is_supp'] = dftest['suppression'].apply(lambda x: not set(list_coms).isdisjoint(x))\n",
    "    df2 = dftest[dftest['is_supp'] == True]\n",
    "    df3 = pd.concat([df1,df2])\n",
    "    return df3[~df3.index.duplicated(keep='first')].sort_values(by=['date'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 269,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['d171728d-5c4a-48a7-83c2-f62e8db01f99', 'a0dc41c9-8026-4382-9f5c-5b4075ab90e8', 'bfb5f656-4440-4561-bb49-e2136b9b7803']\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>creation</th>\n",
       "      <th>suppression</th>\n",
       "      <th>date</th>\n",
       "      <th>id</th>\n",
       "      <th>type</th>\n",
       "      <th>creationObj</th>\n",
       "      <th>suppressionObj</th>\n",
       "      <th>is_create</th>\n",
       "      <th>is_supp</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4469</th>\n",
       "      <td>[4c09a74f-4b9d-4c2c-9e03-5574c979aa97, 0ce410a...</td>\n",
       "      <td>[]</td>\n",
       "      <td>1943-01-01</td>\n",
       "      <td>904dcf14-b895-4686-a5c5-7304c6f63cae</td>\n",
       "      <td>evenement</td>\n",
       "      <td>[{'codeInsee': '32019', 'nom': 'Auterive', 'no...</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>563</th>\n",
       "      <td>[d171728d-5c4a-48a7-83c2-f62e8db01f99, bfb5f65...</td>\n",
       "      <td>[a1ee0f67-b657-418d-822b-7eaab68a89eb, 826d072...</td>\n",
       "      <td>2016-01-01</td>\n",
       "      <td>40ae74a8-6433-4dfa-a388-c98b629954d5</td>\n",
       "      <td>evenement</td>\n",
       "      <td>[{'codeInsee': '27032', 'nom': 'Chambois', 'no...</td>\n",
       "      <td>[{'codeInsee': '27634', 'nom': 'Thomer-la-Sôgn...</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5060</th>\n",
       "      <td>[]</td>\n",
       "      <td>[bfb5f656-4440-4561-bb49-e2136b9b7803, 9bd0400...</td>\n",
       "      <td>2020-12-31</td>\n",
       "      <td>4d54af6e-0a1a-4b4f-970b-3aa95d51e21e</td>\n",
       "      <td>evenement</td>\n",
       "      <td>[]</td>\n",
       "      <td>[{'codeInsee': '27032', 'nom': 'Avrilly', 'nom...</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               creation  \\\n",
       "4469  [4c09a74f-4b9d-4c2c-9e03-5574c979aa97, 0ce410a...   \n",
       "563   [d171728d-5c4a-48a7-83c2-f62e8db01f99, bfb5f65...   \n",
       "5060                                                 []   \n",
       "\n",
       "                                            suppression        date  \\\n",
       "4469                                                 []  1943-01-01   \n",
       "563   [a1ee0f67-b657-418d-822b-7eaab68a89eb, 826d072...  2016-01-01   \n",
       "5060  [bfb5f656-4440-4561-bb49-e2136b9b7803, 9bd0400...  2020-12-31   \n",
       "\n",
       "                                        id       type  \\\n",
       "4469  904dcf14-b895-4686-a5c5-7304c6f63cae  evenement   \n",
       "563   40ae74a8-6433-4dfa-a388-c98b629954d5  evenement   \n",
       "5060  4d54af6e-0a1a-4b4f-970b-3aa95d51e21e  evenement   \n",
       "\n",
       "                                            creationObj  \\\n",
       "4469  [{'codeInsee': '32019', 'nom': 'Auterive', 'no...   \n",
       "563   [{'codeInsee': '27032', 'nom': 'Chambois', 'no...   \n",
       "5060                                                 []   \n",
       "\n",
       "                                         suppressionObj  is_create is_supp  \n",
       "4469                                                 []       True     NaN  \n",
       "563   [{'codeInsee': '27634', 'nom': 'Thomer-la-Sôgn...       True     NaN  \n",
       "5060  [{'codeInsee': '27032', 'nom': 'Avrilly', 'nom...      False    True  "
      ]
     },
     "execution_count": 269,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "getEvtByCodeInsee('27032')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 270,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['44168da9-25d9-4dc0-afdc-46b68c6e32a9', '7b036817-1be0-4b7a-9c47-7dfeb0486f5c']\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>creation</th>\n",
       "      <th>suppression</th>\n",
       "      <th>date</th>\n",
       "      <th>id</th>\n",
       "      <th>type</th>\n",
       "      <th>creationObj</th>\n",
       "      <th>suppressionObj</th>\n",
       "      <th>is_create</th>\n",
       "      <th>is_supp</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4469</th>\n",
       "      <td>[4c09a74f-4b9d-4c2c-9e03-5574c979aa97, 0ce410a...</td>\n",
       "      <td>[]</td>\n",
       "      <td>1943-01-01</td>\n",
       "      <td>904dcf14-b895-4686-a5c5-7304c6f63cae</td>\n",
       "      <td>evenement</td>\n",
       "      <td>[{'codeInsee': '32019', 'nom': 'Auterive', 'no...</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>[0376f0f2-9924-41e6-aaee-43542abdda70, 7b03681...</td>\n",
       "      <td>[44168da9-25d9-4dc0-afdc-46b68c6e32a9, 1a7ae1d...</td>\n",
       "      <td>2019-02-28</td>\n",
       "      <td>ff7e44ab-9e34-4152-8008-fdc8b6b34614</td>\n",
       "      <td>evenement</td>\n",
       "      <td>[{'codeInsee': '21183', 'nom': 'Collonges-et-P...</td>\n",
       "      <td>[{'codeInsee': '21183', 'nom': 'Collonges-lès-...</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               creation  \\\n",
       "4469  [4c09a74f-4b9d-4c2c-9e03-5574c979aa97, 0ce410a...   \n",
       "48    [0376f0f2-9924-41e6-aaee-43542abdda70, 7b03681...   \n",
       "\n",
       "                                            suppression        date  \\\n",
       "4469                                                 []  1943-01-01   \n",
       "48    [44168da9-25d9-4dc0-afdc-46b68c6e32a9, 1a7ae1d...  2019-02-28   \n",
       "\n",
       "                                        id       type  \\\n",
       "4469  904dcf14-b895-4686-a5c5-7304c6f63cae  evenement   \n",
       "48    ff7e44ab-9e34-4152-8008-fdc8b6b34614  evenement   \n",
       "\n",
       "                                            creationObj  \\\n",
       "4469  [{'codeInsee': '32019', 'nom': 'Auterive', 'no...   \n",
       "48    [{'codeInsee': '21183', 'nom': 'Collonges-et-P...   \n",
       "\n",
       "                                         suppressionObj  is_create  is_supp  \n",
       "4469                                                 []       True    False  \n",
       "48    [{'codeInsee': '21183', 'nom': 'Collonges-lès-...       True    False  "
      ]
     },
     "execution_count": 270,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "getEvtByNom('Collonges-lès-Premières')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Analyse nombre création / suppression par événement"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 271,
   "metadata": {},
   "outputs": [],
   "source": [
    "dfevt['nb_creation'] = dfevt['creation'].apply(lambda x: len(x))\n",
    "dfevt['nb_suppression'] = dfevt['suppression'].apply(lambda x: len(x))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Combien d'événement ont concerné plus d'une commune en création et plus d'une commune en suppression :"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 272,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(5086, 11)"
      ]
     },
     "execution_count": 272,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfevt.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 273,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1798"
      ]
     },
     "execution_count": 273,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfevt[(dfevt['nb_creation'] > 1) & (dfevt['nb_suppression'] > 1)].shape[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 274,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1        3104\n",
       "2         832\n",
       "3         591\n",
       "4         229\n",
       "5          93\n",
       "0          90\n",
       "6          43\n",
       "7          27\n",
       "8          25\n",
       "10         10\n",
       "9           7\n",
       "11          7\n",
       "15          6\n",
       "12          4\n",
       "16          3\n",
       "14          2\n",
       "19          2\n",
       "343         1\n",
       "2467        1\n",
       "306         1\n",
       "27          1\n",
       "38125       1\n",
       "94          1\n",
       "17          1\n",
       "20          1\n",
       "23          1\n",
       "21          1\n",
       "699         1\n",
       "Name: nb_creation, dtype: int64"
      ]
     },
     "execution_count": 274,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfevt.nb_creation.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 275,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1     2383\n",
       "2     1833\n",
       "3      454\n",
       "4      188\n",
       "5       69\n",
       "6       44\n",
       "0       39\n",
       "7       21\n",
       "8       14\n",
       "9       11\n",
       "10      11\n",
       "14       5\n",
       "22       2\n",
       "11       2\n",
       "17       2\n",
       "15       2\n",
       "12       2\n",
       "21       1\n",
       "19       1\n",
       "18       1\n",
       "16       1\n",
       "Name: nb_suppression, dtype: int64"
      ]
     },
     "execution_count": 275,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfevt.nb_suppression.value_counts()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Combien d'événement ont impliqués plus de communes créées que de communes supprimées (tout type de commune confondu) :"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 276,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "657"
      ]
     },
     "execution_count": 276,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfevt[(dfevt['nb_creation'] > 1) & (dfevt['nb_suppression'] > 1) & (dfevt['nb_creation'] >= dfevt['nb_suppression']+1)].shape[0]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "On à toujours au max qu'une seule création en plus que de suppression :"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 277,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 277,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfevt[(dfevt['nb_creation'] > 1) & (dfevt['nb_suppression'] > 1) & (dfevt['nb_creation'] >= dfevt['nb_suppression']+2)].shape[0]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "On va rechercher les événements qui ont créé plus de commune COM que de suppression de COM :\n",
    "=> si il en existe, cela veut dire qu'on ne peut pas garantir l'intégrité territoriale dans le temps sur certaines communes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 278,
   "metadata": {},
   "outputs": [],
   "source": [
    "dftest = dfevt[(dfevt['nb_creation'] > 1) & (dfevt['nb_suppression'] > 1) & (dfevt['nb_creation'] >= dfevt['nb_suppression']+1)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 279,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "---------\n",
      "Evenement 637f4e23-fb2d-4f95-8bd6-36c78c699b3b : \n",
      "Suppression : 3 communes, 0 communes déléguées, 0 communes associées\n",
      "Creation : 4 communes, 0 communes déléguées, 0 communes associées\n",
      "---------\n",
      "Evenement 38377343-88a6-458b-8142-162370e38638 : \n",
      "Suppression : 2 communes, 0 communes déléguées, 0 communes associées\n",
      "Creation : 3 communes, 0 communes déléguées, 0 communes associées\n",
      "---------\n",
      "Evenement 2c4e2074-25ce-40a1-b7d3-39e28a238982 : \n",
      "Suppression : 4 communes, 0 communes déléguées, 0 communes associées\n",
      "Creation : 5 communes, 0 communes déléguées, 0 communes associées\n",
      "---------\n",
      "Evenement 662cfa72-c4e3-49d1-94bb-7ee067c3a726 : \n",
      "Suppression : 8 communes, 0 communes déléguées, 0 communes associées\n",
      "Creation : 9 communes, 0 communes déléguées, 0 communes associées\n",
      "---------\n",
      "Evenement 2cc22e41-441b-4897-ad76-22fc1cd17415 : \n",
      "Suppression : 2 communes, 0 communes déléguées, 0 communes associées\n",
      "Creation : 3 communes, 0 communes déléguées, 0 communes associées\n",
      "---------\n",
      "Evenement dff908d5-1c97-494e-8a67-97745f02fb84 : \n",
      "Suppression : 2 communes, 0 communes déléguées, 0 communes associées\n",
      "Creation : 3 communes, 0 communes déléguées, 0 communes associées\n"
     ]
    }
   ],
   "source": [
    "arr = []\n",
    "for index, row in dftest.iterrows():\n",
    "    nb_com_in = 0\n",
    "    nb_coma_in = 0\n",
    "    nb_comd_in = 0\n",
    "    nb_com_out = 0\n",
    "    nb_coma_out = 0\n",
    "    nb_comd_out = 0\n",
    "    for com in row['creationObj']:\n",
    "        if(com['type'] == 'COM'):\n",
    "            nb_com_out = nb_com_out + 1\n",
    "        if(com['type'] == 'COMD'):\n",
    "            nb_comd_out = nb_comd_out + 1\n",
    "        if(com['type'] == 'COMA'):\n",
    "            nb_coma_out = nb_coma_out + 1\n",
    "    for com in row['suppressionObj']:\n",
    "        if(com['type'] == 'COM'):\n",
    "            nb_com_in = nb_com_in + 1\n",
    "        if(com['type'] == 'COMD'):\n",
    "            nb_comd_in = nb_comd_in + 1\n",
    "        if(com['type'] == 'COMA'):\n",
    "            nb_coma_in = nb_coma_in + 1\n",
    "    if(nb_com_out > 1):\n",
    "        arr.append(row)\n",
    "        print('---------')\n",
    "        print('Evenement '+row['id']+' : ')\n",
    "        print('Suppression : '+str(nb_com_in)+' communes, '+str(nb_comd_in)+' communes déléguées, '+str(nb_coma_in)+' communes associées')\n",
    "        print('Creation : '+str(nb_com_out)+' communes, '+str(nb_comd_out)+' communes déléguées, '+str(nb_coma_out)+' communes associées')\n",
    "\n",
    "dfout = pd.DataFrame(arr)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 280,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "-------\n",
      "Vaulnaveys-le-Haut (38529 - COM) ; Séchilienne (38478 - COM) ; Saint-Martin-d'Uriage (38422 - COM) ; \n",
      "deviennent\n",
      "Chamrousse (38567 - COM) ; Vaulnaveys-le-Haut (38529 - COM) ; Séchilienne (38478 - COM) ; Saint-Martin-d'Uriage (38422 - COM) ; \n",
      "-------\n",
      "Bures-sur-Yvette (91122 - COM) ; Orsay (91471 - COM) ; \n",
      "deviennent\n",
      "Bures-sur-Yvette (91122 - COM) ; Les Ulis (91692 - COM) ; Orsay (91471 - COM) ; \n",
      "-------\n",
      "Saint-Jean-Lespinasse (46271 - COM) ; Saint-Vincent-du-Pendit (46295 - COM) ; Saint-Médard-de-Presque (46281 - COM) ; Saint-Céré (46251 - COM) ; \n",
      "deviennent\n",
      "Saint-Médard-de-Presque (46281 - COM) ; Saint-Vincent-du-Pendit (46295 - COM) ; Saint-Jean-Lespinasse (46271 - COM) ; Saint-Jean-Lagineste (46339 - COM) ; Saint-Céré (46251 - COM) ; \n",
      "-------\n",
      "Porte-Joie (27471 - COM) ; Poses (27474 - COM) ; Tournedos-sur-Seine (27651 - COM) ; Léry (27365 - COM) ; Saint-Pierre-du-Vauvray (27598 - COM) ; Incarville (27351 - COM) ; Saint-Étienne-du-Vauvray (27537 - COM) ; Le Vaudreuil (27528 - COM) ; \n",
      "deviennent\n",
      "Tournedos-sur-Seine (27651 - COM) ; Porte-Joie (27471 - COM) ; Le Vaudreuil (27528 - COM) ; Léry (27365 - COM) ; Vaudreuil-Ex-Ensemble Urbain (27701 - COM) ; Saint-Pierre-du-Vauvray (27598 - COM) ; Poses (27474 - COM) ; Incarville (27351 - COM) ; Saint-Étienne-du-Vauvray (27537 - COM) ; \n",
      "-------\n",
      "Saint-Ségal (29263 - COM) ; Quimerch (29231 - COM) ; \n",
      "deviennent\n",
      "Saint-Ségal (29263 - COM) ; Quimerch (29231 - COM) ; Pont-de-Buis (29302 - COM) ; \n",
      "-------\n",
      "Fameck (57206 - COM) ; Ranguevaux (57562 - COM) ; \n",
      "deviennent\n",
      "Ranguevaux (57562 - COM) ; Saint-Nicolas-en-Forêt (57766 - COM) ; Fameck (57206 - COM) ; \n"
     ]
    }
   ],
   "source": [
    "for index, row in dfout.iterrows():\n",
    "    print('-------')\n",
    "    mystr = ''\n",
    "    for com in row['suppressionObj']:\n",
    "        mystr = mystr+com['nom']+' ('+com['codeInsee']+' - '+com['type']+') ; '\n",
    "    \n",
    "    mystr = mystr + '\\ndeviennent\\n'\n",
    "                                          \n",
    "    for com in row['creationObj']:\n",
    "        mystr = mystr+com['nom']+' ('+com['codeInsee']+' - '+com['type']+') ; '\n",
    "    print(mystr)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 281,
   "metadata": {},
   "outputs": [],
   "source": [
    "arr = []\n",
    "for index, row in dftest.iterrows():\n",
    "    nb_com_in = 0\n",
    "    nb_coma_in = 0\n",
    "    nb_comd_in = 0\n",
    "    nb_com_out = 0\n",
    "    nb_coma_out = 0\n",
    "    nb_comd_out = 0\n",
    "    for com in row['creationObj']:\n",
    "        if(com['type'] == 'COM'):\n",
    "            nb_com_out = nb_com_out + 1\n",
    "        if(com['type'] == 'COMD'):\n",
    "            nb_comd_out = nb_comd_out + 1\n",
    "        if(com['type'] == 'COMA'):\n",
    "            nb_coma_out = nb_coma_out + 1\n",
    "    for com in row['suppressionObj']:\n",
    "        if(com['type'] == 'COM'):\n",
    "            nb_com_in = nb_com_in + 1\n",
    "        if(com['type'] == 'COMD'):\n",
    "            nb_comd_in = nb_comd_in + 1\n",
    "        if(com['type'] == 'COMA'):\n",
    "            nb_coma_in = nb_coma_in + 1\n",
    "    if(nb_coma_out > 1):\n",
    "        arr.append(row)\n",
    "        print('---------')\n",
    "        print('Evenement '+row['id']+' : ')\n",
    "        print('Suppression : '+str(nb_com_in)+' communes, '+str(nb_comd_in)+' communes déléguées, '+str(nb_coma_in)+' communes associées')\n",
    "        print('Creation : '+str(nb_com_out)+' communes, '+str(nb_comd_out)+' communes déléguées, '+str(nb_coma_out)+' communes associées')\n",
    "\n",
    "dfout = pd.DataFrame(arr)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 282,
   "metadata": {},
   "outputs": [],
   "source": [
    "for index, row in dfout.iterrows():\n",
    "    print('-------')\n",
    "    mystr = ''\n",
    "    for com in row['suppressionObj']:\n",
    "        mystr = mystr+com['nom']+' ('+com['codeInsee']+' - '+com['type']+') ; '\n",
    "    \n",
    "    mystr = mystr + '\\ndeviennent\\n'\n",
    "                                          \n",
    "    for com in row['creationObj']:\n",
    "        mystr = mystr+com['nom']+' ('+com['codeInsee']+' - '+com['type']+') ; '\n",
    "    print(mystr)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Evenement qui ont créé plus de 2 communes COM"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 283,
   "metadata": {},
   "outputs": [],
   "source": [
    "arr = []\n",
    "for index, row in dfevt.iterrows():\n",
    "    nb_com = 0\n",
    "    for com in row['creationObj']:\n",
    "        if(com['type'] == 'COM'):\n",
    "            nb_com = nb_com + 1\n",
    "    if(nb_com > 1):\n",
    "        arr.append(row)\n",
    "dfout = pd.DataFrame(arr)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 284,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "274"
      ]
     },
     "execution_count": 284,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfout.shape[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 285,
   "metadata": {
    "scrolled": false
   },
   "outputs": [],
   "source": [
    "for index, row in dfout.iterrows():\n",
    "    comcreate = [x['nomSansArticle'] for x in row['creationObj']]\n",
    "    comsupp = [x['nomSansArticle'] for x in row['suppressionObj']]\n",
    "\n",
    "    #print(comcreate)\n",
    "    #print(comsupp)\n",
    "    #print('---')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 286,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = dfevt.sort_values(by=['date'])\n",
    "df = df[~((df['creationObj'].str.len() == 0) & (df['suppressionObj'].str.len() == 0))]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 287,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>creation</th>\n",
       "      <th>suppression</th>\n",
       "      <th>date</th>\n",
       "      <th>id</th>\n",
       "      <th>type</th>\n",
       "      <th>creationObj</th>\n",
       "      <th>suppressionObj</th>\n",
       "      <th>is_create</th>\n",
       "      <th>is_supp</th>\n",
       "      <th>nb_creation</th>\n",
       "      <th>nb_suppression</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2549</th>\n",
       "      <td>[3d13fae4-16d2-4e96-bd91-fbaeb688dd3c]</td>\n",
       "      <td>[bc622910-0e35-4b04-aab8-30d3ecf6d013, def17c4...</td>\n",
       "      <td>1942-08-01</td>\n",
       "      <td>2ffc80b6-b246-4d33-b6a9-46b711fe5de0</td>\n",
       "      <td>evenement</td>\n",
       "      <td>[{'codeInsee': '01185', 'nom': 'Hauteville-Lom...</td>\n",
       "      <td>[{'codeInsee': '01220', 'nom': 'Lompnes', 'nom...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3158</th>\n",
       "      <td>[cbdb7b26-3259-4ac1-b302-1bc10a4711a6]</td>\n",
       "      <td>[76c37d0f-88fd-47b3-9674-000b0e667910, 9fb6ef3...</td>\n",
       "      <td>1942-10-01</td>\n",
       "      <td>6ac12379-99f0-43c6-afe7-83aa0ed22f4b</td>\n",
       "      <td>evenement</td>\n",
       "      <td>[{'codeInsee': '54518', 'nom': 'Thiaucourt', '...</td>\n",
       "      <td>[{'codeInsee': '54448', 'nom': 'Regniéville', ...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2827</th>\n",
       "      <td>[6d3b1c48-cd95-4f57-ab97-9241d2da5e17]</td>\n",
       "      <td>[d50ff06d-77a1-42e9-bde5-b2a612b89919, 4aa381a...</td>\n",
       "      <td>1942-10-01</td>\n",
       "      <td>5dd8818d-0eb5-4326-866d-99076e689233</td>\n",
       "      <td>evenement</td>\n",
       "      <td>[{'codeInsee': '54316', 'nom': 'Limey', 'nomSa...</td>\n",
       "      <td>[{'codeInsee': '54454', 'nom': 'Remenauville',...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3027</th>\n",
       "      <td>[8fcf9222-0527-4733-b33f-e8c7735adc07]</td>\n",
       "      <td>[2830f25b-ab37-48f3-8afb-6f20075c613f, cf2860c...</td>\n",
       "      <td>1942-11-01</td>\n",
       "      <td>065710af-e6d6-4a3d-83d4-b2ce7bbd7b0d</td>\n",
       "      <td>evenement</td>\n",
       "      <td>[{'codeInsee': '66003', 'nom': 'Amélie-les-Bai...</td>\n",
       "      <td>[{'codeInsee': '66003', 'nom': 'Amélie-les-Bai...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4469</th>\n",
       "      <td>[4c09a74f-4b9d-4c2c-9e03-5574c979aa97, 0ce410a...</td>\n",
       "      <td>[]</td>\n",
       "      <td>1943-01-01</td>\n",
       "      <td>904dcf14-b895-4686-a5c5-7304c6f63cae</td>\n",
       "      <td>evenement</td>\n",
       "      <td>[{'codeInsee': '32019', 'nom': 'Auterive', 'no...</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>38125</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               creation  \\\n",
       "2549             [3d13fae4-16d2-4e96-bd91-fbaeb688dd3c]   \n",
       "3158             [cbdb7b26-3259-4ac1-b302-1bc10a4711a6]   \n",
       "2827             [6d3b1c48-cd95-4f57-ab97-9241d2da5e17]   \n",
       "3027             [8fcf9222-0527-4733-b33f-e8c7735adc07]   \n",
       "4469  [4c09a74f-4b9d-4c2c-9e03-5574c979aa97, 0ce410a...   \n",
       "\n",
       "                                            suppression        date  \\\n",
       "2549  [bc622910-0e35-4b04-aab8-30d3ecf6d013, def17c4...  1942-08-01   \n",
       "3158  [76c37d0f-88fd-47b3-9674-000b0e667910, 9fb6ef3...  1942-10-01   \n",
       "2827  [d50ff06d-77a1-42e9-bde5-b2a612b89919, 4aa381a...  1942-10-01   \n",
       "3027  [2830f25b-ab37-48f3-8afb-6f20075c613f, cf2860c...  1942-11-01   \n",
       "4469                                                 []  1943-01-01   \n",
       "\n",
       "                                        id       type  \\\n",
       "2549  2ffc80b6-b246-4d33-b6a9-46b711fe5de0  evenement   \n",
       "3158  6ac12379-99f0-43c6-afe7-83aa0ed22f4b  evenement   \n",
       "2827  5dd8818d-0eb5-4326-866d-99076e689233  evenement   \n",
       "3027  065710af-e6d6-4a3d-83d4-b2ce7bbd7b0d  evenement   \n",
       "4469  904dcf14-b895-4686-a5c5-7304c6f63cae  evenement   \n",
       "\n",
       "                                            creationObj  \\\n",
       "2549  [{'codeInsee': '01185', 'nom': 'Hauteville-Lom...   \n",
       "3158  [{'codeInsee': '54518', 'nom': 'Thiaucourt', '...   \n",
       "2827  [{'codeInsee': '54316', 'nom': 'Limey', 'nomSa...   \n",
       "3027  [{'codeInsee': '66003', 'nom': 'Amélie-les-Bai...   \n",
       "4469  [{'codeInsee': '32019', 'nom': 'Auterive', 'no...   \n",
       "\n",
       "                                         suppressionObj  is_create  is_supp  \\\n",
       "2549  [{'codeInsee': '01220', 'nom': 'Lompnes', 'nom...      False    False   \n",
       "3158  [{'codeInsee': '54448', 'nom': 'Regniéville', ...      False    False   \n",
       "2827  [{'codeInsee': '54454', 'nom': 'Remenauville',...      False    False   \n",
       "3027  [{'codeInsee': '66003', 'nom': 'Amélie-les-Bai...      False    False   \n",
       "4469                                                 []       True    False   \n",
       "\n",
       "      nb_creation  nb_suppression  \n",
       "2549            1               2  \n",
       "3158            1               2  \n",
       "2827            1               2  \n",
       "3027            1               2  \n",
       "4469        38125               0  "
      ]
     },
     "execution_count": 287,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 288,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0\n"
     ]
    }
   ],
   "source": [
    "arr = []\n",
    "cpt = 0\n",
    "for index, row in df.iterrows():\n",
    "    # 1 ou N création, 0 suppression\n",
    "    if((len(row['creationObj']) >= 1) & (len(row['suppressionObj']) == 0)):\n",
    "        for com in row['creationObj']:\n",
    "            mydict = {}\n",
    "            mydict['nom'] = com['nom']\n",
    "            mydict['type'] = com['type']\n",
    "            mydict['dateDebut'] = row['date']\n",
    "            mydict['code'] = com['codeInsee']\n",
    "            mydict['predecesseur'] = None\n",
    "            mydict['id'] = com['type'] + '-' + com['codeInsee'] + '@' + row['date']\n",
    "            mydict['idEvt'] = row['id']\n",
    "            arr.append(mydict)\n",
    "            \n",
    "    # 1 ou N création, 1 suppression\n",
    "    if((len(row['creationObj']) >= 1) & (len(row['suppressionObj']) == 1)):\n",
    "        for com in row['creationObj']:\n",
    "            mydict = {}\n",
    "            mydict['nom'] = com['nom']\n",
    "            mydict['type'] = com['type']\n",
    "            mydict['dateDebut'] = row['date']\n",
    "            mydict['code'] = com['codeInsee']\n",
    "            mydict['predecesseur'] = row['suppressionObj'][0]['type'] + '-' + row['suppressionObj'][0]['codeInsee'] + '@' + df[df['id'] == row['suppressionObj'][0]['evtCreation']].iloc[0]['date']\n",
    "            mydict['id'] = com['type'] + '-' + com['codeInsee'] + '@' + row['date']\n",
    "            mydict['idEvt'] = row['id']\n",
    "            arr.append(mydict)\n",
    "            \n",
    "    # N création, N suppression\n",
    "    if((len(row['creationObj']) >= 1) & (len(row['suppressionObj']) > 1)):\n",
    "        nbcom = 0\n",
    "        codecom = ''\n",
    "        datecom = ''\n",
    "        for com in row['suppressionObj']:\n",
    "            if(com['type'] == 'COM'):\n",
    "                nbcom += 1\n",
    "                codecom = com['codeInsee']\n",
    "                datecom = df[df['id'] == com['evtCreation']].iloc[0]['date']\n",
    "        if(nbcom > 1):\n",
    "            for com in row['creationObj']:\n",
    "                mydict = {}\n",
    "                mydict['nom'] = com['nom']\n",
    "                mydict['type'] = com['type']\n",
    "                mydict['dateDebut'] = row['date']\n",
    "                mydict['code'] = com['codeInsee']\n",
    "                codesInsee = []\n",
    "                for com2 in row['suppressionObj']:\n",
    "                    codesInsee.append(com2['codeInsee'])\n",
    "                codesInsee = list(dict.fromkeys(codesInsee))\n",
    "                mydict['predecesseur'] = 'COMT-' + '-'.join(codesInsee) + '@' + row['date']\n",
    "                mydict['id'] = com['type'] + '-' + com['codeInsee'] + '@' + row['date']\n",
    "                mydict['idEvt'] = row['id']\n",
    "                arr.append(mydict)\n",
    "        elif(nbcom == 1):\n",
    "            for com in row['creationObj']:\n",
    "                mydict = {}\n",
    "                mydict['nom'] = com['nom']\n",
    "                mydict['type'] = com['type']\n",
    "                mydict['dateDebut'] = row['date']\n",
    "                mydict['code'] = com['codeInsee']\n",
    "                mydict['predecesseur'] = 'COM-' + codecom + '@' + datecom\n",
    "                mydict['id'] = com['type'] + '-' + com['codeInsee'] + '@' + row['date']\n",
    "                mydict['idEvt'] = row['id']\n",
    "                arr.append(mydict)\n",
    "        else:\n",
    "            print('pb en perspective - 0 commune supprimée mais des comd et coma')\n",
    "\n",
    "    # 0 création, N suppression\n",
    "print(cpt)\n",
    "    \n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 289,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "46782"
      ]
     },
     "execution_count": 289,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(arr)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 290,
   "metadata": {},
   "outputs": [],
   "source": [
    "toto = pd.DataFrame(arr)\n",
    "toto['successeur'] = ''"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 291,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Pb intégrité base SPARQL - id Evt INSEE : 2ffc80b6-b246-4d33-b6a9-46b711fe5de0\n",
      "Pb intégrité base SPARQL - id Evt INSEE : 6ac12379-99f0-43c6-afe7-83aa0ed22f4b\n",
      "Pb intégrité base SPARQL - id Evt INSEE : 5dd8818d-0eb5-4326-866d-99076e689233\n",
      "Pb intégrité base SPARQL - id Evt INSEE : 065710af-e6d6-4a3d-83d4-b2ce7bbd7b0d\n",
      "200\n",
      "400\n",
      "600\n",
      "800\n",
      "1000\n",
      "1200\n",
      "1400\n",
      "1600\n",
      "1800\n",
      "2000\n",
      "2200\n",
      "2400\n",
      "2457\n"
     ]
    }
   ],
   "source": [
    "arr = []\n",
    "cpt = 0\n",
    "for index, row in df.iterrows():\n",
    "    \n",
    "    # 1 ou N suppression, 0 création\n",
    "    if((len(row['suppressionObj']) >= 1) & (len(row['creationObj']) == 0)):\n",
    "        for com in row['suppressionObj']:\n",
    "            mydict = {}\n",
    "            mydict['nom'] = com['nom']\n",
    "            mydict['type'] = 'COMP'\n",
    "            mydict['dateDebut'] = row['date']\n",
    "            mydict['code'] = com['codeInsee']\n",
    "            mydict['predecesseur'] = com['type'] + '-' + com['codeInsee'] + '@' + toto[toto['idEvt'] == com['evtCreation']].iloc[0]['dateDebut']\n",
    "            mydict['id'] = 'COMP-' + com['codeInsee'] + '@' + row['date']\n",
    "            mydict['idEvt'] = row['id']\n",
    "            arr.append(mydict) \n",
    "            \n",
    "            mydate = toto[(toto['dateDebut'] <= row['date']) & (toto['id'].str.contains(com['type']+'-'+com['codeInsee']))].sort_values(by='dateDebut',ascending=False).iloc[0]['dateDebut']\n",
    "            toto.loc[(toto['id'] == com['type']+'-'+com['codeInsee']+'@'+mydate),'successeur'] = 'COMP-' + com['codeInsee'] + '@' + row['date']\n",
    "            \n",
    "            \n",
    "    # N suppression, N creation\n",
    "    if((len(row['suppressionObj']) > 1) & (len(row['creationObj']) >= 1)):\n",
    "        cpt = cpt + 1\n",
    "        if(cpt % 200 == 0):\n",
    "            print(cpt)\n",
    "        codesInsee = []\n",
    "        for com in row['suppressionObj']:\n",
    "            if(com['type'] == 'COM'):\n",
    "                codesInsee.append(com['codeInsee'])\n",
    "        codesInsee = list(dict.fromkeys(codesInsee))\n",
    "        mydict = {}\n",
    "        mydict['nom'] = 'Commune Transitoire'\n",
    "        mydict['type'] = 'COMT'\n",
    "        mydict['dateDebut'] = row['date']\n",
    "        mydict['code'] = '-'.join(codesInsee)\n",
    "        mydict['id'] = 'COMT-' + '-'.join(codesInsee) + '@' + row['date']\n",
    "        mydict['idEvt'] = row['id']\n",
    "        mydict['predecesseur'] = None\n",
    "        arr.append(mydict)\n",
    "        for com in row['suppressionObj']:\n",
    "            try:\n",
    "                mydate = toto[(toto['dateDebut'] <= row['date']) & (toto['id'].str.contains(com['type']+'-'+com['codeInsee']))].sort_values(by='dateDebut',ascending=False).iloc[0]['dateDebut']\n",
    "                toto.loc[(toto['id'] == com['type']+'-'+com['codeInsee']+'@'+mydate),'successeur'] = 'COMT-' + '-'.join(codesInsee) + '@' + row['date']\n",
    "            except:\n",
    "                print('Pb intégrité base SPARQL - id Evt INSEE : '+row['id'])\n",
    "    \n",
    "    if((len(row['suppressionObj']) == 1) & (len(row['creationObj']) == 1)):\n",
    "        mydate = toto[(toto['dateDebut'] <= row['date']) & (toto['id'].str.contains(row['suppressionObj'][0]['type']+'-'+row['suppressionObj'][0]['codeInsee']))].sort_values(by='dateDebut',ascending=False).iloc[0]['dateDebut']\n",
    "        toto.loc[(toto['id'] == row['suppressionObj'][0]['type']+'-'+row['suppressionObj'][0]['codeInsee']+'@'+mydate),'successeur'] = row['creationObj'][0]['type'] + '-' + row['creationObj'][0]['codeInsee'] + '@' + row['date']\n",
    "        \n",
    "    \n",
    "print(cpt)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 292,
   "metadata": {},
   "outputs": [],
   "source": [
    "tutu = pd.DataFrame(arr)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 293,
   "metadata": {},
   "outputs": [],
   "source": [
    "titi = pd.concat([toto,tutu])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 294,
   "metadata": {},
   "outputs": [],
   "source": [
    "titi['successeur'] = titi['successeur'].apply(lambda x: None if x == '' else x)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 295,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(40596, 8)"
      ]
     },
     "execution_count": 295,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "titi[titi['successeur'].isna()].shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 296,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>nom</th>\n",
       "      <th>type</th>\n",
       "      <th>dateDebut</th>\n",
       "      <th>code</th>\n",
       "      <th>predecesseur</th>\n",
       "      <th>id</th>\n",
       "      <th>idEvt</th>\n",
       "      <th>successeur</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Vayres-sur-Essonne</td>\n",
       "      <td>COM</td>\n",
       "      <td>1943-01-01</td>\n",
       "      <td>78639</td>\n",
       "      <td>None</td>\n",
       "      <td>COM-78639@1943-01-01</td>\n",
       "      <td>904dcf14-b895-4686-a5c5-7304c6f63cae</td>\n",
       "      <td>COM-91639@1968-01-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39690</th>\n",
       "      <td>Vayres-sur-Essonne</td>\n",
       "      <td>COM</td>\n",
       "      <td>1968-01-01</td>\n",
       "      <td>91639</td>\n",
       "      <td>COM-78639@1943-01-01</td>\n",
       "      <td>COM-91639@1968-01-01</td>\n",
       "      <td>8dba2b23-ea40-4cd8-b9cd-32eb19e4770b</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                      nom type   dateDebut   code          predecesseur  \\\n",
       "6      Vayres-sur-Essonne  COM  1943-01-01  78639                  None   \n",
       "39690  Vayres-sur-Essonne  COM  1968-01-01  91639  COM-78639@1943-01-01   \n",
       "\n",
       "                         id                                 idEvt  \\\n",
       "6      COM-78639@1943-01-01  904dcf14-b895-4686-a5c5-7304c6f63cae   \n",
       "39690  COM-91639@1968-01-01  8dba2b23-ea40-4cd8-b9cd-32eb19e4770b   \n",
       "\n",
       "                 successeur  \n",
       "6      COM-91639@1968-01-01  \n",
       "39690                  None  "
      ]
     },
     "execution_count": 296,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "titi[titi['nom'] == 'Vayres-sur-Essonne']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 297,
   "metadata": {},
   "outputs": [],
   "source": [
    "for index, row in titi.iterrows():\n",
    "    if(row['successeur'] is None):\n",
    "        if(titi[titi['predecesseur'] == row['id']].shape[0] > 0):\n",
    "            row['successeur'] = titi[titi['predecesseur'] == row['id']].iloc[0]['id']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 298,
   "metadata": {},
   "outputs": [],
   "source": [
    "for index, row in titi.iterrows():\n",
    "    if(row['id'] == row['successeur']):\n",
    "        row['successeur'] = None"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 299,
   "metadata": {},
   "outputs": [],
   "source": [
    "cog = pd.read_csv('commune2021.csv')\n",
    "cog = cog[cog['TYPECOM'] != 'ARM']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 300,
   "metadata": {},
   "outputs": [],
   "source": [
    "out = titi.copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 301,
   "metadata": {},
   "outputs": [],
   "source": [
    "out = out[out['successeur'].isna()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 302,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "nom                                Vaux-sous-Aubigny\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           52509\n",
      "predecesseur                                    None\n",
      "id                              COM-52509@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 25, dtype: object\n",
      "nom                            Saint-Léger-lès-Melle\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           79264\n",
      "predecesseur                                    None\n",
      "id                              COM-79264@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 1113, dtype: object\n",
      "1000\n",
      "nom                           Santa-Lucia-di-Tallano\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           20308\n",
      "predecesseur                                    None\n",
      "id                              COM-20308@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 2090, dtype: object\n",
      "nom                                            Livry\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           14372\n",
      "predecesseur                                    None\n",
      "id                              COM-14372@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 2551, dtype: object\n",
      "2000\n",
      "nom                                            Clefs\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           49101\n",
      "predecesseur                                    None\n",
      "id                              COM-49101@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 2646, dtype: object\n",
      "nom                         Morainville-sur-Damville\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           27416\n",
      "predecesseur                                    None\n",
      "id                              COM-27416@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 2654, dtype: object\n",
      "nom                                  Percey-le-Petit\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           52382\n",
      "predecesseur                                    None\n",
      "id                              COM-52382@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 2782, dtype: object\n",
      "nom                              Colonard-le-Buisson\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           61112\n",
      "predecesseur                                    None\n",
      "id                              COM-61112@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 3120, dtype: object\n",
      "nom                                           Prétot\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           50415\n",
      "predecesseur                                    None\n",
      "id                              COM-50415@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 3295, dtype: object\n",
      "nom                               Colle-Saint-Michel\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           04060\n",
      "predecesseur                                    None\n",
      "id                              COM-04060@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 3533, dtype: object\n",
      "nom                                          Sutrieu\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           01414\n",
      "predecesseur                                    None\n",
      "id                              COM-01414@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 3560, dtype: object\n",
      "3000\n",
      "nom                                         Authenay\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           27024\n",
      "predecesseur                                    None\n",
      "id                              COM-27024@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 3908, dtype: object\n",
      "nom                                           Seynod\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           74268\n",
      "predecesseur                                    None\n",
      "id                              COM-74268@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 4430, dtype: object\n",
      "nom                                 Le Mesnil-Herman\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           50313\n",
      "predecesseur                                    None\n",
      "id                              COM-50313@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 4491, dtype: object\n",
      "nom                                    Montemaggiore\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           20167\n",
      "predecesseur                                    None\n",
      "id                              COM-20167@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 4976, dtype: object\n",
      "4000\n",
      "nom                                 Le Mesnil-Mauger\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           14422\n",
      "predecesseur                                    None\n",
      "id                              COM-14422@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 5703, dtype: object\n",
      "nom                           Châtillon-de-Michaille\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           01091\n",
      "predecesseur                                    None\n",
      "id                              COM-01091@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 6299, dtype: object\n",
      "5000\n",
      "nom                                         Castilly\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           14142\n",
      "predecesseur                                    None\n",
      "id                              COM-14142@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 7582, dtype: object\n",
      "6000\n",
      "nom                            Châteauneuf-de-Chabre\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           05034\n",
      "predecesseur                                    None\n",
      "id                              COM-05034@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 7968, dtype: object\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "nom                                         Allaines\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           28002\n",
      "predecesseur                                    None\n",
      "id                              COM-28002@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 8077, dtype: object\n",
      "7000\n",
      "nom                                        Champigné\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           49065\n",
      "predecesseur                                    None\n",
      "id                              COM-49065@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 8969, dtype: object\n",
      "8000\n",
      "nom                                     Robert-Magny\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           52427\n",
      "predecesseur                                    None\n",
      "id                              COM-52427@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 10530, dtype: object\n",
      "nom                 Saint-Georges-du-Puy-de-la-Garde\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           49281\n",
      "predecesseur                                    None\n",
      "id                              COM-49281@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 11436, dtype: object\n",
      "9000\n",
      "nom                                        Pautaines\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           52379\n",
      "predecesseur                                    None\n",
      "id                              COM-52379@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 12035, dtype: object\n",
      "10000\n",
      "nom                                           Danvou\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           14219\n",
      "predecesseur                                    None\n",
      "id                              COM-14219@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 13019, dtype: object\n",
      "nom                              Mont-sous-les-Côtes\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           55354\n",
      "predecesseur                                    None\n",
      "id                              COM-55354@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 13198, dtype: object\n",
      "nom                                             Sion\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           74274\n",
      "predecesseur                                    None\n",
      "id                              COM-74274@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 13625, dtype: object\n",
      "nom                                          Neuilly\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           89275\n",
      "predecesseur                                    None\n",
      "id                              COM-89275@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 13704, dtype: object\n",
      "nom                                    Sainte-Sabine\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           24497\n",
      "predecesseur                                    None\n",
      "id                              COM-24497@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 13799, dtype: object\n",
      "nom                              Tournedos-sur-Seine\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           27651\n",
      "predecesseur                                    None\n",
      "id                              COM-27651@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 13943, dtype: object\n",
      "11000\n",
      "nom                                         Venables\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           27676\n",
      "predecesseur                                    None\n",
      "id                              COM-27676@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 14299, dtype: object\n",
      "12000\n",
      "nom                                       Pont-Farcy\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           14513\n",
      "predecesseur                                    None\n",
      "id                              COM-14513@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 15422, dtype: object\n",
      "nom                                 Mauzé-Thouarsais\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           79171\n",
      "predecesseur                                    None\n",
      "id                              COM-79171@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 15454, dtype: object\n",
      "nom                                      Regniéville\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           54448\n",
      "predecesseur                                    None\n",
      "id                              COM-54448@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 15802, dtype: object\n",
      "nom                                    Grandvilliers\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           27297\n",
      "predecesseur                                    None\n",
      "id                              COM-27297@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 15871, dtype: object\n",
      "13000\n",
      "nom                                         Mézières\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           08290\n",
      "predecesseur                                    None\n",
      "id                              COM-08290@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 16445, dtype: object\n",
      "nom                          Saint-Martin-de-Fresnay\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           14624\n",
      "predecesseur                                    None\n",
      "id                              COM-14624@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 16526, dtype: object\n",
      "nom                          Chênehutte-les-Tuffeaux\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           49094\n",
      "predecesseur                                    None\n",
      "id                              COM-49094@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 16869, dtype: object\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "nom                                           Pringy\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           74217\n",
      "predecesseur                                    None\n",
      "id                              COM-74217@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 16958, dtype: object\n",
      "14000\n",
      "nom                                         Carcheto\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           20063\n",
      "predecesseur                                    None\n",
      "id                              COM-20063@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 18176, dtype: object\n",
      "nom                                    Urville-Hague\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           50611\n",
      "predecesseur                                    None\n",
      "id                              COM-50611@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 18271, dtype: object\n",
      "nom                                       Montfaucon\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           49206\n",
      "predecesseur                                    None\n",
      "id                              COM-49206@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 18477, dtype: object\n",
      "15000\n",
      "nom                                          Cressac\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           16115\n",
      "predecesseur                                    None\n",
      "id                              COM-16115@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 18821, dtype: object\n",
      "nom                         Saint-Martin-des-Besaces\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           14629\n",
      "predecesseur                                    None\n",
      "id                              COM-14629@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 19536, dtype: object\n",
      "16000\n",
      "nom                                          Corbeil\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           78174\n",
      "predecesseur                                    None\n",
      "id                              COM-78174@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 20135, dtype: object\n",
      "nom                            Fierville-la-Campagne\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           14268\n",
      "predecesseur                                    None\n",
      "id                              COM-14268@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 20203, dtype: object\n",
      "nom                                           Vessey\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           50630\n",
      "predecesseur                                    None\n",
      "id                              COM-50630@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 20736, dtype: object\n",
      "nom                                          Gonnord\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           49153\n",
      "predecesseur                                    None\n",
      "id                              COM-49153@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 20855, dtype: object\n",
      "nom                                    Saint-Gabriel\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           14577\n",
      "predecesseur                                    None\n",
      "id                              COM-14577@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 20949, dtype: object\n",
      "17000\n",
      "nom                                        Propriano\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           20249\n",
      "predecesseur                                    None\n",
      "id                              COM-20249@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 21222, dtype: object\n",
      "nom                      Saint-Germain-de-Tallevende\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           14584\n",
      "predecesseur                                    None\n",
      "id                              COM-14584@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 21262, dtype: object\n",
      "nom                                            Taizé\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           79321\n",
      "predecesseur                                    None\n",
      "id                              COM-79321@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 21458, dtype: object\n",
      "nom                                          Lompnes\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           01220\n",
      "predecesseur                                    None\n",
      "id                              COM-01220@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 21762, dtype: object\n",
      "nom                                      Pontamafrey\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           73203\n",
      "predecesseur                                    None\n",
      "id                              COM-73203@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 21960, dtype: object\n",
      "18000\n",
      "nom                                   Magny-en-Vexin\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           78355\n",
      "predecesseur                                    None\n",
      "id                              COM-78355@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 22715, dtype: object\n",
      "nom                                           Charcé\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           49078\n",
      "predecesseur                                    None\n",
      "id                              COM-49078@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 22838, dtype: object\n",
      "nom                          Saint-Pierre-Tarentaine\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           14655\n",
      "predecesseur                                    None\n",
      "id                              COM-14655@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 23010, dtype: object\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "19000\n",
      "nom                                     Remenauville\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           54454\n",
      "predecesseur                                    None\n",
      "id                              COM-54454@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 23821, dtype: object\n",
      "20000\n",
      "nom                                         Couvains\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           61136\n",
      "predecesseur                                    None\n",
      "id                              COM-61136@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 24742, dtype: object\n",
      "nom                                         Torteval\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           14695\n",
      "predecesseur                                    None\n",
      "id                              COM-14695@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 24898, dtype: object\n",
      "nom                                          Palalda\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           66131\n",
      "predecesseur                                    None\n",
      "id                              COM-66131@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 25393, dtype: object\n",
      "21000\n",
      "nom                                          Veyrins\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           38541\n",
      "predecesseur                                    None\n",
      "id                              COM-38541@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 25788, dtype: object\n",
      "nom                                        Omiécourt\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           80608\n",
      "predecesseur                                    None\n",
      "id                              COM-80608@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 26084, dtype: object\n",
      "nom                                           Gennes\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           49149\n",
      "predecesseur                                    None\n",
      "id                              COM-49149@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 26674, dtype: object\n",
      "22000\n",
      "nom                                   Équeurdreville\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           50173\n",
      "predecesseur                                    None\n",
      "id                              COM-50173@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 26935, dtype: object\n",
      "nom                                        Treschenu\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           26354\n",
      "predecesseur                                    None\n",
      "id                              COM-26354@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 27904, dtype: object\n",
      "23000\n",
      "24000\n",
      "nom                                       Denneville\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           50160\n",
      "predecesseur                                    None\n",
      "id                              COM-50160@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 29888, dtype: object\n",
      "25000\n",
      "nom                                         Quimerch\n",
      "type                                             COM\n",
      "dateDebut                                 1943-01-01\n",
      "code                                           29231\n",
      "predecesseur                                    None\n",
      "id                              COM-29231@1943-01-01\n",
      "idEvt           904dcf14-b895-4686-a5c5-7304c6f63cae\n",
      "successeur                                      None\n",
      "Name: 31104, dtype: object\n",
      "26000\n",
      "27000\n",
      "28000\n",
      "29000\n",
      "30000\n",
      "31000\n",
      "32000\n",
      "nom                         Saint-Germain-sur-Sarthe\n",
      "type                                             COM\n",
      "dateDebut                                 1952-10-23\n",
      "code                                           72284\n",
      "predecesseur                    COM-72284@1943-01-01\n",
      "id                              COM-72284@1952-10-23\n",
      "idEvt           cdc1c8b4-32c7-4c84-b63e-67ff40a544cd\n",
      "successeur                                      None\n",
      "Name: 38390, dtype: object\n",
      "33000\n",
      "nom                      Saint-Symphorien-le-Château\n",
      "type                                             COM\n",
      "dateDebut                                 1969-01-06\n",
      "code                                           28361\n",
      "predecesseur                    COM-28361@1943-01-01\n",
      "id                              COM-28361@1969-01-06\n",
      "idEvt           f1127d1f-0d80-449f-9493-a3bbcc27afc8\n",
      "successeur                                      None\n",
      "Name: 39950, dtype: object\n",
      "34000\n",
      "35000\n",
      "nom                                   Tessy-sur-Vire\n",
      "type                                            COMD\n",
      "dateDebut                                 2016-01-01\n",
      "code                                           50592\n",
      "predecesseur             COMT-50592-50180@2016-01-01\n",
      "id                             COMD-50592@2016-01-01\n",
      "idEvt           4011a070-26dd-4a2d-b988-f6abdf751cc9\n",
      "successeur                                      None\n",
      "Name: 43668, dtype: object\n",
      "nom                                        Fervaches\n",
      "type                                            COMD\n",
      "dateDebut                                 2016-01-01\n",
      "code                                           50180\n",
      "predecesseur             COMT-50592-50180@2016-01-01\n",
      "id                             COMD-50180@2016-01-01\n",
      "idEvt           4011a070-26dd-4a2d-b988-f6abdf751cc9\n",
      "successeur                                      None\n",
      "Name: 43669, dtype: object\n",
      "36000\n",
      "37000\n",
      "38000\n",
      "39000\n",
      "40000\n"
     ]
    }
   ],
   "source": [
    "cpt = 0\n",
    "for index, row in out.iterrows():\n",
    "    cpt = cpt + 1\n",
    "    if(cpt % 1000 == 0):\n",
    "        print(cpt)\n",
    "    if((row['type'] != 'COMT') & (row['type'] != 'COMP')):\n",
    "        if(cog[(cog['TYPECOM'] == row['type']) & (cog['COM'] == row['code'])].shape[0] == 0):\n",
    "            print(row)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 303,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1000\n",
      "2000\n",
      "3000\n",
      "4000\n",
      "5000\n",
      "6000\n",
      "7000\n",
      "8000\n",
      "9000\n",
      "10000\n",
      "11000\n",
      "12000\n",
      "13000\n",
      "14000\n",
      "15000\n",
      "16000\n",
      "17000\n",
      "18000\n",
      "19000\n",
      "20000\n",
      "TYPECOM                COM\n",
      "COM                  51369\n",
      "REG                   44.0\n",
      "DEP                     51\n",
      "CTCD                   51D\n",
      "ARR                    512\n",
      "TNCC                     0\n",
      "NCC          MOEURS VERDEY\n",
      "NCCENR        Mœurs-Verdey\n",
      "LIBELLE       Mœurs-Verdey\n",
      "CAN                   5121\n",
      "COMPARENT              NaN\n",
      "Name: 20145, dtype: object\n",
      "21000\n",
      "22000\n",
      "TYPECOM                   COM\n",
      "COM                     55386\n",
      "REG                      44.0\n",
      "DEP                        55\n",
      "CTCD                      55D\n",
      "ARR                       552\n",
      "TNCC                        0\n",
      "NCC          NONSARD LAMARCHE\n",
      "NCCENR       Nonsard-Lamarche\n",
      "LIBELLE      Nonsard-Lamarche\n",
      "CAN                      5513\n",
      "COMPARENT                 NaN\n",
      "Name: 22203, dtype: object\n",
      "23000\n",
      "24000\n",
      "25000\n",
      "26000\n",
      "27000\n",
      "28000\n",
      "29000\n",
      "30000\n",
      "31000\n",
      "32000\n",
      "33000\n",
      "34000\n",
      "35000\n",
      "36000\n",
      "37000\n"
     ]
    }
   ],
   "source": [
    "cpt = 0\n",
    "for index, row in cog.iterrows():\n",
    "    cpt = cpt + 1\n",
    "    if(cpt % 1000 == 0):\n",
    "        print(cpt)\n",
    "    if(out[(out['type'] == row['TYPECOM']) & (out['code'] == row['COM'])].shape[0] == 0):\n",
    "        print(row)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 304,
   "metadata": {},
   "outputs": [],
   "source": [
    "import json\n",
    "with open('graph-coms.json', 'w') as f:\n",
    "    json.dump(titi.to_dict(orient=\"records\"), f, indent=4)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 305,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>TYPECOM</th>\n",
       "      <th>COM</th>\n",
       "      <th>REG</th>\n",
       "      <th>DEP</th>\n",
       "      <th>CTCD</th>\n",
       "      <th>ARR</th>\n",
       "      <th>TNCC</th>\n",
       "      <th>NCC</th>\n",
       "      <th>NCCENR</th>\n",
       "      <th>LIBELLE</th>\n",
       "      <th>CAN</th>\n",
       "      <th>COMPARENT</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>COM</td>\n",
       "      <td>01001</td>\n",
       "      <td>84.0</td>\n",
       "      <td>01</td>\n",
       "      <td>01D</td>\n",
       "      <td>012</td>\n",
       "      <td>5</td>\n",
       "      <td>ABERGEMENT CLEMENCIAT</td>\n",
       "      <td>Abergement-Clémenciat</td>\n",
       "      <td>L'Abergement-Clémenciat</td>\n",
       "      <td>0108</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>COM</td>\n",
       "      <td>01002</td>\n",
       "      <td>84.0</td>\n",
       "      <td>01</td>\n",
       "      <td>01D</td>\n",
       "      <td>011</td>\n",
       "      <td>5</td>\n",
       "      <td>ABERGEMENT DE VAREY</td>\n",
       "      <td>Abergement-de-Varey</td>\n",
       "      <td>L'Abergement-de-Varey</td>\n",
       "      <td>0101</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>COM</td>\n",
       "      <td>01004</td>\n",
       "      <td>84.0</td>\n",
       "      <td>01</td>\n",
       "      <td>01D</td>\n",
       "      <td>011</td>\n",
       "      <td>1</td>\n",
       "      <td>AMBERIEU EN BUGEY</td>\n",
       "      <td>Ambérieu-en-Bugey</td>\n",
       "      <td>Ambérieu-en-Bugey</td>\n",
       "      <td>0101</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>COM</td>\n",
       "      <td>01005</td>\n",
       "      <td>84.0</td>\n",
       "      <td>01</td>\n",
       "      <td>01D</td>\n",
       "      <td>012</td>\n",
       "      <td>1</td>\n",
       "      <td>AMBERIEUX EN DOMBES</td>\n",
       "      <td>Ambérieux-en-Dombes</td>\n",
       "      <td>Ambérieux-en-Dombes</td>\n",
       "      <td>0122</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>COM</td>\n",
       "      <td>01006</td>\n",
       "      <td>84.0</td>\n",
       "      <td>01</td>\n",
       "      <td>01D</td>\n",
       "      <td>011</td>\n",
       "      <td>1</td>\n",
       "      <td>AMBLEON</td>\n",
       "      <td>Ambléon</td>\n",
       "      <td>Ambléon</td>\n",
       "      <td>0104</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37737</th>\n",
       "      <td>COM</td>\n",
       "      <td>97613</td>\n",
       "      <td>6.0</td>\n",
       "      <td>976</td>\n",
       "      <td>976D</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>M TSANGAMOUJI</td>\n",
       "      <td>M'Tsangamouji</td>\n",
       "      <td>M'Tsangamouji</td>\n",
       "      <td>97613</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37738</th>\n",
       "      <td>COM</td>\n",
       "      <td>97614</td>\n",
       "      <td>6.0</td>\n",
       "      <td>976</td>\n",
       "      <td>976D</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>OUANGANI</td>\n",
       "      <td>Ouangani</td>\n",
       "      <td>Ouangani</td>\n",
       "      <td>97610</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37739</th>\n",
       "      <td>COM</td>\n",
       "      <td>97615</td>\n",
       "      <td>6.0</td>\n",
       "      <td>976</td>\n",
       "      <td>976D</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>PAMANDZI</td>\n",
       "      <td>Pamandzi</td>\n",
       "      <td>Pamandzi</td>\n",
       "      <td>97611</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37740</th>\n",
       "      <td>COM</td>\n",
       "      <td>97616</td>\n",
       "      <td>6.0</td>\n",
       "      <td>976</td>\n",
       "      <td>976D</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>SADA</td>\n",
       "      <td>Sada</td>\n",
       "      <td>Sada</td>\n",
       "      <td>97612</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37741</th>\n",
       "      <td>COM</td>\n",
       "      <td>97617</td>\n",
       "      <td>6.0</td>\n",
       "      <td>976</td>\n",
       "      <td>976D</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>TSINGONI</td>\n",
       "      <td>Tsingoni</td>\n",
       "      <td>Tsingoni</td>\n",
       "      <td>97613</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>37697 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      TYPECOM    COM   REG  DEP  CTCD  ARR  TNCC                    NCC  \\\n",
       "0         COM  01001  84.0   01   01D  012     5  ABERGEMENT CLEMENCIAT   \n",
       "1         COM  01002  84.0   01   01D  011     5    ABERGEMENT DE VAREY   \n",
       "2         COM  01004  84.0   01   01D  011     1      AMBERIEU EN BUGEY   \n",
       "3         COM  01005  84.0   01   01D  012     1    AMBERIEUX EN DOMBES   \n",
       "4         COM  01006  84.0   01   01D  011     1                AMBLEON   \n",
       "...       ...    ...   ...  ...   ...  ...   ...                    ...   \n",
       "37737     COM  97613   6.0  976  976D  NaN     0          M TSANGAMOUJI   \n",
       "37738     COM  97614   6.0  976  976D  NaN     1               OUANGANI   \n",
       "37739     COM  97615   6.0  976  976D  NaN     0               PAMANDZI   \n",
       "37740     COM  97616   6.0  976  976D  NaN     0                   SADA   \n",
       "37741     COM  97617   6.0  976  976D  NaN     0               TSINGONI   \n",
       "\n",
       "                      NCCENR                  LIBELLE    CAN  COMPARENT  \n",
       "0      Abergement-Clémenciat  L'Abergement-Clémenciat   0108        NaN  \n",
       "1        Abergement-de-Varey    L'Abergement-de-Varey   0101        NaN  \n",
       "2          Ambérieu-en-Bugey        Ambérieu-en-Bugey   0101        NaN  \n",
       "3        Ambérieux-en-Dombes      Ambérieux-en-Dombes   0122        NaN  \n",
       "4                    Ambléon                  Ambléon   0104        NaN  \n",
       "...                      ...                      ...    ...        ...  \n",
       "37737          M'Tsangamouji            M'Tsangamouji  97613        NaN  \n",
       "37738               Ouangani                 Ouangani  97610        NaN  \n",
       "37739               Pamandzi                 Pamandzi  97611        NaN  \n",
       "37740                   Sada                     Sada  97612        NaN  \n",
       "37741               Tsingoni                 Tsingoni  97613        NaN  \n",
       "\n",
       "[37697 rows x 12 columns]"
      ]
     },
     "execution_count": 305,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cog"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 306,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>TYPECOM</th>\n",
       "      <th>COM</th>\n",
       "      <th>REG</th>\n",
       "      <th>DEP</th>\n",
       "      <th>CTCD</th>\n",
       "      <th>ARR</th>\n",
       "      <th>TNCC</th>\n",
       "      <th>NCC</th>\n",
       "      <th>NCCENR</th>\n",
       "      <th>LIBELLE</th>\n",
       "      <th>CAN</th>\n",
       "      <th>COMPARENT</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [TYPECOM, COM, REG, DEP, CTCD, ARR, TNCC, NCC, NCCENR, LIBELLE, CAN, COMPARENT]\n",
       "Index: []"
      ]
     },
     "execution_count": 306,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cog[cog['NCCENR'] == 'Boissy-sur-Damville']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 307,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>nom</th>\n",
       "      <th>type</th>\n",
       "      <th>dateDebut</th>\n",
       "      <th>code</th>\n",
       "      <th>predecesseur</th>\n",
       "      <th>id</th>\n",
       "      <th>idEvt</th>\n",
       "      <th>successeur</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2656</th>\n",
       "      <td>Boissy-sur-Damville</td>\n",
       "      <td>COM</td>\n",
       "      <td>1943-01-01</td>\n",
       "      <td>27080</td>\n",
       "      <td>None</td>\n",
       "      <td>COM-27080@1943-01-01</td>\n",
       "      <td>904dcf14-b895-4686-a5c5-7304c6f63cae</td>\n",
       "      <td>COMT-27416-27186-27080@1972-01-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40114</th>\n",
       "      <td>Boissy-sur-Damville</td>\n",
       "      <td>COMA</td>\n",
       "      <td>1972-01-01</td>\n",
       "      <td>27080</td>\n",
       "      <td>COMT-27416-27186-27080@1972-01-01</td>\n",
       "      <td>COMA-27080@1972-01-01</td>\n",
       "      <td>b2193291-9d40-45dd-8e50-8d01a552aa24</td>\n",
       "      <td>COMT-27416@1978-07-01</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                       nom  type   dateDebut   code  \\\n",
       "2656   Boissy-sur-Damville   COM  1943-01-01  27080   \n",
       "40114  Boissy-sur-Damville  COMA  1972-01-01  27080   \n",
       "\n",
       "                            predecesseur                     id  \\\n",
       "2656                                None   COM-27080@1943-01-01   \n",
       "40114  COMT-27416-27186-27080@1972-01-01  COMA-27080@1972-01-01   \n",
       "\n",
       "                                      idEvt                         successeur  \n",
       "2656   904dcf14-b895-4686-a5c5-7304c6f63cae  COMT-27416-27186-27080@1972-01-01  \n",
       "40114  b2193291-9d40-45dd-8e50-8d01a552aa24              COMT-27416@1978-07-01  "
      ]
     },
     "execution_count": 307,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "titi[titi['code'] == '27080']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 308,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>nom</th>\n",
       "      <th>type</th>\n",
       "      <th>dateDebut</th>\n",
       "      <th>code</th>\n",
       "      <th>predecesseur</th>\n",
       "      <th>id</th>\n",
       "      <th>idEvt</th>\n",
       "      <th>successeur</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2654</th>\n",
       "      <td>Morainville-sur-Damville</td>\n",
       "      <td>COM</td>\n",
       "      <td>1943-01-01</td>\n",
       "      <td>27416</td>\n",
       "      <td>None</td>\n",
       "      <td>COM-27416@1943-01-01</td>\n",
       "      <td>904dcf14-b895-4686-a5c5-7304c6f63cae</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40113</th>\n",
       "      <td>Buis-sur-Damville</td>\n",
       "      <td>COM</td>\n",
       "      <td>1972-01-01</td>\n",
       "      <td>27416</td>\n",
       "      <td>COMT-27416-27186-27080@1972-01-01</td>\n",
       "      <td>COM-27416@1972-01-01</td>\n",
       "      <td>b2193291-9d40-45dd-8e50-8d01a552aa24</td>\n",
       "      <td>COMT-27416-27186-27080@1972-01-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42441</th>\n",
       "      <td>Buis-sur-Damville</td>\n",
       "      <td>COM</td>\n",
       "      <td>1978-07-01</td>\n",
       "      <td>27416</td>\n",
       "      <td>COM-27416@1972-01-01</td>\n",
       "      <td>COM-27416@1978-07-01</td>\n",
       "      <td>3984373b-f525-4d96-8f6e-d30af9f50f4e</td>\n",
       "      <td>COMT-27416-27198-27491-27297@2019-01-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46273</th>\n",
       "      <td>Buis-sur-Damville</td>\n",
       "      <td>COMD</td>\n",
       "      <td>2019-01-01</td>\n",
       "      <td>27416</td>\n",
       "      <td>COMT-27416-27198-27491-27297-27024-27387-27166...</td>\n",
       "      <td>COMD-27416@2019-01-01</td>\n",
       "      <td>35bceb68-68d0-4acc-94ad-443da1ea37d6</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>426</th>\n",
       "      <td>Commune Transitoire</td>\n",
       "      <td>COMT</td>\n",
       "      <td>1972-01-01</td>\n",
       "      <td>27416-27186-27080</td>\n",
       "      <td>None</td>\n",
       "      <td>COMT-27416-27186-27080@1972-01-01</td>\n",
       "      <td>b2193291-9d40-45dd-8e50-8d01a552aa24</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1294</th>\n",
       "      <td>Commune Transitoire</td>\n",
       "      <td>COMT</td>\n",
       "      <td>1978-07-01</td>\n",
       "      <td>27416</td>\n",
       "      <td>None</td>\n",
       "      <td>COMT-27416@1978-07-01</td>\n",
       "      <td>3984373b-f525-4d96-8f6e-d30af9f50f4e</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2341</th>\n",
       "      <td>Commune Transitoire</td>\n",
       "      <td>COMT</td>\n",
       "      <td>2019-01-01</td>\n",
       "      <td>27416-27198-27491-27297</td>\n",
       "      <td>None</td>\n",
       "      <td>COMT-27416-27198-27491-27297@2019-01-01</td>\n",
       "      <td>35bceb68-68d0-4acc-94ad-443da1ea37d6</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                            nom  type   dateDebut                     code  \\\n",
       "2654   Morainville-sur-Damville   COM  1943-01-01                    27416   \n",
       "40113         Buis-sur-Damville   COM  1972-01-01                    27416   \n",
       "42441         Buis-sur-Damville   COM  1978-07-01                    27416   \n",
       "46273         Buis-sur-Damville  COMD  2019-01-01                    27416   \n",
       "426         Commune Transitoire  COMT  1972-01-01        27416-27186-27080   \n",
       "1294        Commune Transitoire  COMT  1978-07-01                    27416   \n",
       "2341        Commune Transitoire  COMT  2019-01-01  27416-27198-27491-27297   \n",
       "\n",
       "                                            predecesseur  \\\n",
       "2654                                                None   \n",
       "40113                  COMT-27416-27186-27080@1972-01-01   \n",
       "42441                               COM-27416@1972-01-01   \n",
       "46273  COMT-27416-27198-27491-27297-27024-27387-27166...   \n",
       "426                                                 None   \n",
       "1294                                                None   \n",
       "2341                                                None   \n",
       "\n",
       "                                            id  \\\n",
       "2654                      COM-27416@1943-01-01   \n",
       "40113                     COM-27416@1972-01-01   \n",
       "42441                     COM-27416@1978-07-01   \n",
       "46273                    COMD-27416@2019-01-01   \n",
       "426          COMT-27416-27186-27080@1972-01-01   \n",
       "1294                     COMT-27416@1978-07-01   \n",
       "2341   COMT-27416-27198-27491-27297@2019-01-01   \n",
       "\n",
       "                                      idEvt  \\\n",
       "2654   904dcf14-b895-4686-a5c5-7304c6f63cae   \n",
       "40113  b2193291-9d40-45dd-8e50-8d01a552aa24   \n",
       "42441  3984373b-f525-4d96-8f6e-d30af9f50f4e   \n",
       "46273  35bceb68-68d0-4acc-94ad-443da1ea37d6   \n",
       "426    b2193291-9d40-45dd-8e50-8d01a552aa24   \n",
       "1294   3984373b-f525-4d96-8f6e-d30af9f50f4e   \n",
       "2341   35bceb68-68d0-4acc-94ad-443da1ea37d6   \n",
       "\n",
       "                                    successeur  \n",
       "2654                                      None  \n",
       "40113        COMT-27416-27186-27080@1972-01-01  \n",
       "42441  COMT-27416-27198-27491-27297@2019-01-01  \n",
       "46273                                     None  \n",
       "426                                        NaN  \n",
       "1294                                       NaN  \n",
       "2341                                       NaN  "
      ]
     },
     "execution_count": 308,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "titi[titi['code'].str.contains('27416')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 309,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>creation</th>\n",
       "      <th>suppression</th>\n",
       "      <th>date</th>\n",
       "      <th>id</th>\n",
       "      <th>type</th>\n",
       "      <th>creationObj</th>\n",
       "      <th>suppressionObj</th>\n",
       "      <th>is_create</th>\n",
       "      <th>is_supp</th>\n",
       "      <th>nb_creation</th>\n",
       "      <th>nb_suppression</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4469</th>\n",
       "      <td>[4c09a74f-4b9d-4c2c-9e03-5574c979aa97, 0ce410a...</td>\n",
       "      <td>[]</td>\n",
       "      <td>1943-01-01</td>\n",
       "      <td>904dcf14-b895-4686-a5c5-7304c6f63cae</td>\n",
       "      <td>evenement</td>\n",
       "      <td>[{'codeInsee': '32019', 'nom': 'Auterive', 'no...</td>\n",
       "      <td>[]</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>38125</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               creation suppression  \\\n",
       "4469  [4c09a74f-4b9d-4c2c-9e03-5574c979aa97, 0ce410a...          []   \n",
       "\n",
       "            date                                    id       type  \\\n",
       "4469  1943-01-01  904dcf14-b895-4686-a5c5-7304c6f63cae  evenement   \n",
       "\n",
       "                                            creationObj suppressionObj  \\\n",
       "4469  [{'codeInsee': '32019', 'nom': 'Auterive', 'no...             []   \n",
       "\n",
       "      is_create  is_supp  nb_creation  nb_suppression  \n",
       "4469       True    False        38125               0  "
      ]
     },
     "execution_count": 309,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfevt[dfevt['id'] == '904dcf14-b895-4686-a5c5-7304c6f63cae']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Chaque commune possède un identifiant unique : TYPE-CODEINSEE@DATE_EVT_CREATION\n",
    "\n",
    "Exemple :\n",
    "Tartampion 27455 Tartampion 27455 le 1er janvier 1970\n",
    "a considéré comme deux objets distincts même si le cas semble bizarre, du point de vue de la base de données, il faut le considérer comme deux objets distincts. Ici, avec deux identifiants :\n",
    "COM-27455@1943-01-01 \n",
    "COM-27455@1970-01-01\n",
    "\n",
    "Pour gérer l'historique et le graphe, nous avons besoin de créer deux nouveaux types de commune :\n",
    "- COMP : commune Périmée : une fois qu'une commune est supprimée mais n'a pas de successeur, il faut créer une COMP\n",
    "- COMT : commune Transitoire : lorsque l'événement ne permet pas d'associer un successeur ou un prédecesseur unique, nous avons besoin de créer une commune transitoire qui se charge de faire la jointure entre les communes supprimées et communes créées\n",
    "\n",
    "Quand on parle ci-dessous de création ou de suppression, il s'agit de création ou de suppression d'objet Commune COM (et non pas COMA ou COMD) :\n",
    "\n",
    "Gestion des événements, plusieurs cas :\n",
    "- 0 suppression, 1 création : \n",
    "    - la commune créé ne possède pas de prédécesseur\n",
    "- 0 suppression, N création : ok\n",
    "    - les communes créées ne possèdent pas de prédecesseurs\n",
    "- 1 suppression, 1 création : ok\n",
    "    - la commune créé possède un prédécesseur\n",
    "    - la commune supprimée possède un successeur\n",
    "- 1 suppression, N création : besoin d'une commune transitoire\n",
    "    - la commune supprimée a pour successeur la commune transitoire\n",
    "    - les communes créées ont pour prédecesseur la commune transitoire\n",
    "    - la commune transitoire créée n'a pas de successeur ni de prédecesseur\n",
    "- N suppression, 0 création : ok\n",
    "    - les communes supprimées ont pour chacune un objet COMP (Commune Périmée) a créer.\n",
    "- N suppression, 1 création : besoin d'une commune transitoire\n",
    "    - les communes supprimées ont pour successeurs la commune transitoire\n",
    "    - la commune créée a pour prédecesseur la commune transitoire\n",
    "    - la commune transitoire créée n'a pas de successeur ni de prédecesseur\n",
    "- N suppression, N création : besoin d'une commune transitoire\n",
    "    - les communes supprimées ont pour successeurs la commune transitoire\n",
    "    - les communes créées ont pour prédecesseurs la commune transitoire\n",
    "    - la commune transitoire créée n'a pas de successeur ni de prédecesseur\n",
    "\n",
    "Propriétés des objets communes COM, COMD... :\n",
    "- nom ; type ; dateDebut ; code ; predecesseur ; id ; idEvt ; successeur\n",
    "Propriétés des objets commune transitoire COMT :\n",
    "- nom ; type ; dateDebut ; code ; id ; idEvt\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Cas particulier:\n",
    "- Hauteville https://rdf.insee.fr/sparql/describe?uri=http%3A%2F%2Fid.insee.fr%2Fgeo%2Fcommune%2Fdef17c47-5128-401d-9e42-0690d8c0daae&default-graph-uri=data\n",
    "- Créé en 1943, supprimé en 1942....\n",
    "    "
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}