analyse_de_dsn_groupe_ibo2.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 171,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[master d834945] first\n",
      " 1 file changed, 447 insertions(+), 123 deletions(-)\n",
      "Counting objects: 3, done.\n",
      "Delta compression using up to 8 threads.\n",
      "Compressing objects: 100% (3/3), done.\n",
      "Writing objects: 100% (3/3), 4.10 KiB | 2.05 MiB/s, done.\n",
      "Total 3 (delta 2), reused 0 (delta 0)\n",
      "remote: Resolving deltas: 100% (2/2), completed with 2 local objects.\u001b[K\n",
      "To https://github.com/romainjouin/formation_python\n",
      "   93c6daa..d834945  master -> master\n"
     ]
    }
   ],
   "source": [
    "!git add analyse_de_dsn_groupe_ibo2.ipynb\n",
    "!git commit -m \"first\"\n",
    "!git push"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Analyse de données\n",
    "\n",
    "On vous fournit une base déjà reformatée en tableau, qui est un extrait de DSN.\n",
    "Voici la documentation de la DSN : http://www.dsn-info.fr/documentation/dsn_cahier_technique_p3.5.pdf\n",
    "\n",
    "On vous demande de faire la data-prep et de prévoir l'absentéisme."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv(\"subset_dsn.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "93"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(df.columns)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>Unnamed: 0</th>\n",
       "      <th>Unnamed: 0.1</th>\n",
       "      <th>Unnamed: 0.1.1</th>\n",
       "      <th>('S21.G00.30.005', 'Sexe')</th>\n",
       "      <th>('S21.G00.30.006', 'Date de naissance')</th>\n",
       "      <th>('S21.G00.30.020', 'Numéro technique temporaire')</th>\n",
       "      <th>('S21.G00.30.023', 'Embauche')</th>\n",
       "      <th>('S21.G00.31.001', 'Date de la modification')</th>\n",
       "      <th>('S21.G00.40.001', 'Date de début du contrat')</th>\n",
       "      <th>('S21.G00.40.002', 'Statut du salarié (conventionnel)')</th>\n",
       "      <th>...</th>\n",
       "      <th>('S21.G00.70.010', \"Nombre d'ayants-droit autres (ascendants, collatéraux...)\")</th>\n",
       "      <th>('S21.G00.70.011', \"Nombre d'enfants ayants-droit\")</th>\n",
       "      <th>('S21.G00.70.012', 'Identifiant technique Affiliation')</th>\n",
       "      <th>('S21.G00.70.013', 'Identifiant technique Adhésion')</th>\n",
       "      <th>('S21.G00.70.014', nan)</th>\n",
       "      <th>('S21.G00.86.001', 'Type')</th>\n",
       "      <th>('S21.G00.86.002', 'Unité de mesure')</th>\n",
       "      <th>('S21.G00.86.003', 'Valeur')</th>\n",
       "      <th>('S21.G00.86.005', 'Numéro du contrat')</th>\n",
       "      <th>Unnamed: 0.1.1.1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>15091997</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20122015</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>1016</td>\n",
       "      <td>818804314150338465</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>23021991</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29042018</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3426801196285240187</td>\n",
       "      <td>970579013592031102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>956</td>\n",
       "      <td>5062950368187149217</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>17091974</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01052018</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3426801196285240187</td>\n",
       "      <td>970579013592031102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>189</td>\n",
       "      <td>6538046486002635820</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3051994</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01062018</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3426801196285240187</td>\n",
       "      <td>970579013592031102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>164</td>\n",
       "      <td>6274365465970049139</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>19111986</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01072018</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>01092018</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>207</td>\n",
       "      <td>2177083209391047952</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>5071964</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>10925</td>\n",
       "      <td>1813037183403608302</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>28051972</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3426801196285240187</td>\n",
       "      <td>970579013592031102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>8491</td>\n",
       "      <td>3652708417458515775</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>2</td>\n",
       "      <td>23061969</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>9324</td>\n",
       "      <td>2850529884753525020</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>2</td>\n",
       "      <td>25021971</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>10410</td>\n",
       "      <td>167823990482649395</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>19071972</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01102014</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>8628</td>\n",
       "      <td>694421425782240772</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>10091963</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01102014</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>11270</td>\n",
       "      <td>7159113741589673965</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>2</td>\n",
       "      <td>3061973</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>7153</td>\n",
       "      <td>2727216476858878079</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>1</td>\n",
       "      <td>27041977</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>6426</td>\n",
       "      <td>5265255753580133596</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>2</td>\n",
       "      <td>2081979</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>6559</td>\n",
       "      <td>3349437125772570619</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>2</td>\n",
       "      <td>20031984</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>4945</td>\n",
       "      <td>1180135311347997151</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>15111984</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>4703</td>\n",
       "      <td>3420812909788976964</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>2</td>\n",
       "      <td>20101966</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3426801196285240187</td>\n",
       "      <td>970579013592031102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>4279</td>\n",
       "      <td>9162660237646300115</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>17</td>\n",
       "      <td>17</td>\n",
       "      <td>17</td>\n",
       "      <td>1</td>\n",
       "      <td>10071981</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>4067</td>\n",
       "      <td>4885954375751391374</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>2</td>\n",
       "      <td>8051986</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>3457</td>\n",
       "      <td>4288287697472645046</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>19</td>\n",
       "      <td>19</td>\n",
       "      <td>19</td>\n",
       "      <td>1</td>\n",
       "      <td>10021981</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>3206</td>\n",
       "      <td>6570170158378405001</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>2</td>\n",
       "      <td>16091984</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>2496</td>\n",
       "      <td>425650408013017981</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>21</td>\n",
       "      <td>21</td>\n",
       "      <td>21</td>\n",
       "      <td>2</td>\n",
       "      <td>8011989</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>1630</td>\n",
       "      <td>3143312799405920287</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>22</td>\n",
       "      <td>22</td>\n",
       "      <td>22</td>\n",
       "      <td>2</td>\n",
       "      <td>3061990</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01012015</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>1432</td>\n",
       "      <td>1469883324021351994</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "      <td>2</td>\n",
       "      <td>10081984</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01072015</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3426801196285240187</td>\n",
       "      <td>970579013592031102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>1269</td>\n",
       "      <td>7837756792996550705</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>24</td>\n",
       "      <td>24</td>\n",
       "      <td>24</td>\n",
       "      <td>1</td>\n",
       "      <td>8021970</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01062017</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>8960</td>\n",
       "      <td>2149108281688600381</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>25</td>\n",
       "      <td>25</td>\n",
       "      <td>25</td>\n",
       "      <td>2</td>\n",
       "      <td>16081989</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21082017</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3426801196285240187</td>\n",
       "      <td>970579013592031102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>1090</td>\n",
       "      <td>8799307255273835075</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "      <td>1</td>\n",
       "      <td>28021996</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>02102017</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>364</td>\n",
       "      <td>7000840322664899104</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "      <td>2</td>\n",
       "      <td>31011994</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01112017</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3426801196285240187</td>\n",
       "      <td>970579013592031102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>910</td>\n",
       "      <td>2384688779049884557</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>28</td>\n",
       "      <td>28</td>\n",
       "      <td>28</td>\n",
       "      <td>2</td>\n",
       "      <td>10031991</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14122017</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>291</td>\n",
       "      <td>7870577635990534373</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>29</td>\n",
       "      <td>29</td>\n",
       "      <td>29</td>\n",
       "      <td>1</td>\n",
       "      <td>10021994</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01012018</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>287</td>\n",
       "      <td>881314362425168731</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2587</th>\n",
       "      <td>2587</td>\n",
       "      <td>2587</td>\n",
       "      <td>2587</td>\n",
       "      <td>1</td>\n",
       "      <td>1111980</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16062015</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>1260</td>\n",
       "      <td>4834120171048102958</td>\n",
       "      <td>2587</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2588</th>\n",
       "      <td>2588</td>\n",
       "      <td>2588</td>\n",
       "      <td>2588</td>\n",
       "      <td>1</td>\n",
       "      <td>24021987</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01072016</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>905</td>\n",
       "      <td>683828758928152661</td>\n",
       "      <td>2588</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2589</th>\n",
       "      <td>2589</td>\n",
       "      <td>2589</td>\n",
       "      <td>2589</td>\n",
       "      <td>1</td>\n",
       "      <td>22041988</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01012017</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>833</td>\n",
       "      <td>7221255194562272665</td>\n",
       "      <td>2589</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2590</th>\n",
       "      <td>2590</td>\n",
       "      <td>2590</td>\n",
       "      <td>2590</td>\n",
       "      <td>2</td>\n",
       "      <td>23061984</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01072017</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>607</td>\n",
       "      <td>3698917690617163002</td>\n",
       "      <td>2590</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2591</th>\n",
       "      <td>2591</td>\n",
       "      <td>2591</td>\n",
       "      <td>2591</td>\n",
       "      <td>2</td>\n",
       "      <td>9111996</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01092017</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>544</td>\n",
       "      <td>4249409429706839134</td>\n",
       "      <td>2591</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2592</th>\n",
       "      <td>2592</td>\n",
       "      <td>2592</td>\n",
       "      <td>2592</td>\n",
       "      <td>1</td>\n",
       "      <td>21101984</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01092017</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>1183</td>\n",
       "      <td>5620218769796984271</td>\n",
       "      <td>2592</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2593</th>\n",
       "      <td>2593</td>\n",
       "      <td>2593</td>\n",
       "      <td>2593</td>\n",
       "      <td>1</td>\n",
       "      <td>6091994</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01102017</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>574</td>\n",
       "      <td>8839660826908513977</td>\n",
       "      <td>2593</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2594</th>\n",
       "      <td>2594</td>\n",
       "      <td>2594</td>\n",
       "      <td>2594</td>\n",
       "      <td>2</td>\n",
       "      <td>9061995</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01012018</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3426801196285240187</td>\n",
       "      <td>970579013592031102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>371</td>\n",
       "      <td>3997822093275412105</td>\n",
       "      <td>2594</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2595</th>\n",
       "      <td>2595</td>\n",
       "      <td>2595</td>\n",
       "      <td>2595</td>\n",
       "      <td>2</td>\n",
       "      <td>3121993</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01012018</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>374</td>\n",
       "      <td>1901639391550104623</td>\n",
       "      <td>2595</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2596</th>\n",
       "      <td>2596</td>\n",
       "      <td>2596</td>\n",
       "      <td>2596</td>\n",
       "      <td>2</td>\n",
       "      <td>24051995</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01012018</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3426801196285240187</td>\n",
       "      <td>970579013592031102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>350</td>\n",
       "      <td>9150234965342168853</td>\n",
       "      <td>2596</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2597</th>\n",
       "      <td>2597</td>\n",
       "      <td>2597</td>\n",
       "      <td>2597</td>\n",
       "      <td>2</td>\n",
       "      <td>22051995</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21032018</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3426801196285240187</td>\n",
       "      <td>970579013592031102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>194</td>\n",
       "      <td>7949664969466976486</td>\n",
       "      <td>2597</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2598</th>\n",
       "      <td>2598</td>\n",
       "      <td>2598</td>\n",
       "      <td>2598</td>\n",
       "      <td>1</td>\n",
       "      <td>4051983</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01062018</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3426801196285240187</td>\n",
       "      <td>970579013592031102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>203</td>\n",
       "      <td>8619966990251332608</td>\n",
       "      <td>2598</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2599</th>\n",
       "      <td>2599</td>\n",
       "      <td>2599</td>\n",
       "      <td>2599</td>\n",
       "      <td>2</td>\n",
       "      <td>5041996</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01062018</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3426801196285240187</td>\n",
       "      <td>970579013592031102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>199</td>\n",
       "      <td>4973604679353592430</td>\n",
       "      <td>2599</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2600</th>\n",
       "      <td>2600</td>\n",
       "      <td>2600</td>\n",
       "      <td>2600</td>\n",
       "      <td>2</td>\n",
       "      <td>12111992</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18062018</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3426801196285240187</td>\n",
       "      <td>970579013592031102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>147</td>\n",
       "      <td>3215681245706328957</td>\n",
       "      <td>2600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2601</th>\n",
       "      <td>2601</td>\n",
       "      <td>2601</td>\n",
       "      <td>2601</td>\n",
       "      <td>2</td>\n",
       "      <td>29061997</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>06082018</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3426801196285240187</td>\n",
       "      <td>970579013592031102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>56</td>\n",
       "      <td>1476482701907964752</td>\n",
       "      <td>2601</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2602</th>\n",
       "      <td>2602</td>\n",
       "      <td>2602</td>\n",
       "      <td>2602</td>\n",
       "      <td>1</td>\n",
       "      <td>9101999</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>03092018</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3426801196285240187</td>\n",
       "      <td>970579013592031102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>28</td>\n",
       "      <td>2723253731195137972</td>\n",
       "      <td>2602</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2603</th>\n",
       "      <td>2603</td>\n",
       "      <td>2603</td>\n",
       "      <td>2603</td>\n",
       "      <td>1</td>\n",
       "      <td>24011995</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01092018</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3426801196285240187</td>\n",
       "      <td>970579013592031102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>30</td>\n",
       "      <td>787867068654832392</td>\n",
       "      <td>2603</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2604</th>\n",
       "      <td>2604</td>\n",
       "      <td>2604</td>\n",
       "      <td>2604</td>\n",
       "      <td>2</td>\n",
       "      <td>29091989</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01092018</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3426801196285240187</td>\n",
       "      <td>970579013592031102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>30</td>\n",
       "      <td>975458426065869036</td>\n",
       "      <td>2604</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2605</th>\n",
       "      <td>2605</td>\n",
       "      <td>2605</td>\n",
       "      <td>2605</td>\n",
       "      <td>1</td>\n",
       "      <td>23071970</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01102014</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>6076</td>\n",
       "      <td>3104144261411391019</td>\n",
       "      <td>2605</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2606</th>\n",
       "      <td>2606</td>\n",
       "      <td>2606</td>\n",
       "      <td>2606</td>\n",
       "      <td>2</td>\n",
       "      <td>29041964</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3426801196285240187</td>\n",
       "      <td>970579013592031102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>10080</td>\n",
       "      <td>1675624590658596295</td>\n",
       "      <td>2606</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2607</th>\n",
       "      <td>2607</td>\n",
       "      <td>2607</td>\n",
       "      <td>2607</td>\n",
       "      <td>2</td>\n",
       "      <td>19101986</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16032015</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>4029</td>\n",
       "      <td>6870212934181519876</td>\n",
       "      <td>2607</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2608</th>\n",
       "      <td>2608</td>\n",
       "      <td>2608</td>\n",
       "      <td>2608</td>\n",
       "      <td>1</td>\n",
       "      <td>7041957</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>10104</td>\n",
       "      <td>6726960970436385335</td>\n",
       "      <td>2608</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2609</th>\n",
       "      <td>2609</td>\n",
       "      <td>2609</td>\n",
       "      <td>2609</td>\n",
       "      <td>2</td>\n",
       "      <td>7061983</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>5334</td>\n",
       "      <td>7293694087988396906</td>\n",
       "      <td>2609</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2610</th>\n",
       "      <td>2610</td>\n",
       "      <td>2610</td>\n",
       "      <td>2610</td>\n",
       "      <td>1</td>\n",
       "      <td>30051979</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>5479</td>\n",
       "      <td>6581531391815583762</td>\n",
       "      <td>2610</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2611</th>\n",
       "      <td>2611</td>\n",
       "      <td>2611</td>\n",
       "      <td>2611</td>\n",
       "      <td>2</td>\n",
       "      <td>24071965</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3426801196285240187</td>\n",
       "      <td>970579013592031102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>9016</td>\n",
       "      <td>7899380811344089746</td>\n",
       "      <td>2611</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2612</th>\n",
       "      <td>2612</td>\n",
       "      <td>2612</td>\n",
       "      <td>2612</td>\n",
       "      <td>1</td>\n",
       "      <td>24061985</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>4347</td>\n",
       "      <td>1979743340121760892</td>\n",
       "      <td>2612</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2613</th>\n",
       "      <td>2613</td>\n",
       "      <td>2613</td>\n",
       "      <td>2613</td>\n",
       "      <td>1</td>\n",
       "      <td>20061979</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>4039</td>\n",
       "      <td>1767314840430178948</td>\n",
       "      <td>2613</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2614</th>\n",
       "      <td>2614</td>\n",
       "      <td>2614</td>\n",
       "      <td>2614</td>\n",
       "      <td>2</td>\n",
       "      <td>17071987</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>3157</td>\n",
       "      <td>121345335568216352</td>\n",
       "      <td>2614</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2615</th>\n",
       "      <td>2615</td>\n",
       "      <td>2615</td>\n",
       "      <td>2615</td>\n",
       "      <td>2</td>\n",
       "      <td>10091989</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>2973</td>\n",
       "      <td>6330781511945007660</td>\n",
       "      <td>2615</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2616</th>\n",
       "      <td>2616</td>\n",
       "      <td>2616</td>\n",
       "      <td>2616</td>\n",
       "      <td>1</td>\n",
       "      <td>28111981</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30072018</td>\n",
       "      <td>06</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3426801196285240187</td>\n",
       "      <td>970579013592031102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>63</td>\n",
       "      <td>3549699751783595424</td>\n",
       "      <td>2616</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2617 rows × 93 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Unnamed: 0  Unnamed: 0.1  Unnamed: 0.1.1  ('S21.G00.30.005', 'Sexe')  \\\n",
       "0              0             0               0                           2   \n",
       "1              1             1               1                           2   \n",
       "2              2             2               2                           2   \n",
       "3              3             3               3                           2   \n",
       "4              4             4               4                           1   \n",
       "5              5             5               5                           2   \n",
       "6              6             6               6                           2   \n",
       "7              7             7               7                           2   \n",
       "8              8             8               8                           2   \n",
       "9              9             9               9                           1   \n",
       "10            10            10              10                           1   \n",
       "11            11            11              11                           2   \n",
       "12            12            12              12                           1   \n",
       "13            13            13              13                           2   \n",
       "14            14            14              14                           2   \n",
       "15            15            15              15                           1   \n",
       "16            16            16              16                           2   \n",
       "17            17            17              17                           1   \n",
       "18            18            18              18                           2   \n",
       "19            19            19              19                           1   \n",
       "20            20            20              20                           2   \n",
       "21            21            21              21                           2   \n",
       "22            22            22              22                           2   \n",
       "23            23            23              23                           2   \n",
       "24            24            24              24                           1   \n",
       "25            25            25              25                           2   \n",
       "26            26            26              26                           1   \n",
       "27            27            27              27                           2   \n",
       "28            28            28              28                           2   \n",
       "29            29            29              29                           1   \n",
       "...          ...           ...             ...                         ...   \n",
       "2587        2587          2587            2587                           1   \n",
       "2588        2588          2588            2588                           1   \n",
       "2589        2589          2589            2589                           1   \n",
       "2590        2590          2590            2590                           2   \n",
       "2591        2591          2591            2591                           2   \n",
       "2592        2592          2592            2592                           1   \n",
       "2593        2593          2593            2593                           1   \n",
       "2594        2594          2594            2594                           2   \n",
       "2595        2595          2595            2595                           2   \n",
       "2596        2596          2596            2596                           2   \n",
       "2597        2597          2597            2597                           2   \n",
       "2598        2598          2598            2598                           1   \n",
       "2599        2599          2599            2599                           2   \n",
       "2600        2600          2600            2600                           2   \n",
       "2601        2601          2601            2601                           2   \n",
       "2602        2602          2602            2602                           1   \n",
       "2603        2603          2603            2603                           1   \n",
       "2604        2604          2604            2604                           2   \n",
       "2605        2605          2605            2605                           1   \n",
       "2606        2606          2606            2606                           2   \n",
       "2607        2607          2607            2607                           2   \n",
       "2608        2608          2608            2608                           1   \n",
       "2609        2609          2609            2609                           2   \n",
       "2610        2610          2610            2610                           1   \n",
       "2611        2611          2611            2611                           2   \n",
       "2612        2612          2612            2612                           1   \n",
       "2613        2613          2613            2613                           1   \n",
       "2614        2614          2614            2614                           2   \n",
       "2615        2615          2615            2615                           2   \n",
       "2616        2616          2616            2616                           1   \n",
       "\n",
       "      ('S21.G00.30.006', 'Date de naissance')  \\\n",
       "0                                    15091997   \n",
       "1                                    23021991   \n",
       "2                                    17091974   \n",
       "3                                     3051994   \n",
       "4                                    19111986   \n",
       "5                                     5071964   \n",
       "6                                    28051972   \n",
       "7                                    23061969   \n",
       "8                                    25021971   \n",
       "9                                    19071972   \n",
       "10                                   10091963   \n",
       "11                                    3061973   \n",
       "12                                   27041977   \n",
       "13                                    2081979   \n",
       "14                                   20031984   \n",
       "15                                   15111984   \n",
       "16                                   20101966   \n",
       "17                                   10071981   \n",
       "18                                    8051986   \n",
       "19                                   10021981   \n",
       "20                                   16091984   \n",
       "21                                    8011989   \n",
       "22                                    3061990   \n",
       "23                                   10081984   \n",
       "24                                    8021970   \n",
       "25                                   16081989   \n",
       "26                                   28021996   \n",
       "27                                   31011994   \n",
       "28                                   10031991   \n",
       "29                                   10021994   \n",
       "...                                       ...   \n",
       "2587                                  1111980   \n",
       "2588                                 24021987   \n",
       "2589                                 22041988   \n",
       "2590                                 23061984   \n",
       "2591                                  9111996   \n",
       "2592                                 21101984   \n",
       "2593                                  6091994   \n",
       "2594                                  9061995   \n",
       "2595                                  3121993   \n",
       "2596                                 24051995   \n",
       "2597                                 22051995   \n",
       "2598                                  4051983   \n",
       "2599                                  5041996   \n",
       "2600                                 12111992   \n",
       "2601                                 29061997   \n",
       "2602                                  9101999   \n",
       "2603                                 24011995   \n",
       "2604                                 29091989   \n",
       "2605                                 23071970   \n",
       "2606                                 29041964   \n",
       "2607                                 19101986   \n",
       "2608                                  7041957   \n",
       "2609                                  7061983   \n",
       "2610                                 30051979   \n",
       "2611                                 24071965   \n",
       "2612                                 24061985   \n",
       "2613                                 20061979   \n",
       "2614                                 17071987   \n",
       "2615                                 10091989   \n",
       "2616                                 28111981   \n",
       "\n",
       "      ('S21.G00.30.020', 'Numéro technique temporaire')  \\\n",
       "0                                                   NaN   \n",
       "1                                                   NaN   \n",
       "2                                                   NaN   \n",
       "3                                                   NaN   \n",
       "4                                                   NaN   \n",
       "5                                                   NaN   \n",
       "6                                                   NaN   \n",
       "7                                                   NaN   \n",
       "8                                                   NaN   \n",
       "9                                                   NaN   \n",
       "10                                                  NaN   \n",
       "11                                                  NaN   \n",
       "12                                                  NaN   \n",
       "13                                                  NaN   \n",
       "14                                                  NaN   \n",
       "15                                                  NaN   \n",
       "16                                                  NaN   \n",
       "17                                                  NaN   \n",
       "18                                                  NaN   \n",
       "19                                                  NaN   \n",
       "20                                                  NaN   \n",
       "21                                                  NaN   \n",
       "22                                                  NaN   \n",
       "23                                                  NaN   \n",
       "24                                                  NaN   \n",
       "25                                                  NaN   \n",
       "26                                                  NaN   \n",
       "27                                                  NaN   \n",
       "28                                                  NaN   \n",
       "29                                                  NaN   \n",
       "...                                                 ...   \n",
       "2587                                                NaN   \n",
       "2588                                                NaN   \n",
       "2589                                                NaN   \n",
       "2590                                                NaN   \n",
       "2591                                                NaN   \n",
       "2592                                                NaN   \n",
       "2593                                                NaN   \n",
       "2594                                                NaN   \n",
       "2595                                                NaN   \n",
       "2596                                                NaN   \n",
       "2597                                                NaN   \n",
       "2598                                                NaN   \n",
       "2599                                                NaN   \n",
       "2600                                                NaN   \n",
       "2601                                                NaN   \n",
       "2602                                                NaN   \n",
       "2603                                                NaN   \n",
       "2604                                                NaN   \n",
       "2605                                                NaN   \n",
       "2606                                                NaN   \n",
       "2607                                                NaN   \n",
       "2608                                                NaN   \n",
       "2609                                                NaN   \n",
       "2610                                                NaN   \n",
       "2611                                                NaN   \n",
       "2612                                                NaN   \n",
       "2613                                                NaN   \n",
       "2614                                                NaN   \n",
       "2615                                                NaN   \n",
       "2616                                                NaN   \n",
       "\n",
       "      ('S21.G00.30.023', 'Embauche')  \\\n",
       "0                                  1   \n",
       "1                                  1   \n",
       "2                                  1   \n",
       "3                                  1   \n",
       "4                                  1   \n",
       "5                                  1   \n",
       "6                                  1   \n",
       "7                                  1   \n",
       "8                                  1   \n",
       "9                                  1   \n",
       "10                                 1   \n",
       "11                                 1   \n",
       "12                                 1   \n",
       "13                                 1   \n",
       "14                                 1   \n",
       "15                                 1   \n",
       "16                                 1   \n",
       "17                                 1   \n",
       "18                                 1   \n",
       "19                                 1   \n",
       "20                                 1   \n",
       "21                                 1   \n",
       "22                                 1   \n",
       "23                                 1   \n",
       "24                                 1   \n",
       "25                                 1   \n",
       "26                                 1   \n",
       "27                                 1   \n",
       "28                                 1   \n",
       "29                                 1   \n",
       "...                              ...   \n",
       "2587                               1   \n",
       "2588                               1   \n",
       "2589                               1   \n",
       "2590                               1   \n",
       "2591                               1   \n",
       "2592                               1   \n",
       "2593                               1   \n",
       "2594                               1   \n",
       "2595                               1   \n",
       "2596                               1   \n",
       "2597                               1   \n",
       "2598                               1   \n",
       "2599                               1   \n",
       "2600                               1   \n",
       "2601                               1   \n",
       "2602                               1   \n",
       "2603                               1   \n",
       "2604                               1   \n",
       "2605                               1   \n",
       "2606                               1   \n",
       "2607                               1   \n",
       "2608                               1   \n",
       "2609                               1   \n",
       "2610                               1   \n",
       "2611                               1   \n",
       "2612                               1   \n",
       "2613                               1   \n",
       "2614                               1   \n",
       "2615                               1   \n",
       "2616                               1   \n",
       "\n",
       "      ('S21.G00.31.001', 'Date de la modification')  \\\n",
       "0                                               NaN   \n",
       "1                                               NaN   \n",
       "2                                               NaN   \n",
       "3                                               NaN   \n",
       "4                                               NaN   \n",
       "5                                               NaN   \n",
       "6                                               NaN   \n",
       "7                                               NaN   \n",
       "8                                               NaN   \n",
       "9                                               NaN   \n",
       "10                                              NaN   \n",
       "11                                              NaN   \n",
       "12                                              NaN   \n",
       "13                                              NaN   \n",
       "14                                              NaN   \n",
       "15                                              NaN   \n",
       "16                                              NaN   \n",
       "17                                              NaN   \n",
       "18                                              NaN   \n",
       "19                                              NaN   \n",
       "20                                              NaN   \n",
       "21                                              NaN   \n",
       "22                                              NaN   \n",
       "23                                              NaN   \n",
       "24                                              NaN   \n",
       "25                                              NaN   \n",
       "26                                              NaN   \n",
       "27                                              NaN   \n",
       "28                                              NaN   \n",
       "29                                              NaN   \n",
       "...                                             ...   \n",
       "2587                                            NaN   \n",
       "2588                                            NaN   \n",
       "2589                                            NaN   \n",
       "2590                                            NaN   \n",
       "2591                                            NaN   \n",
       "2592                                            NaN   \n",
       "2593                                            NaN   \n",
       "2594                                            NaN   \n",
       "2595                                            NaN   \n",
       "2596                                            NaN   \n",
       "2597                                            NaN   \n",
       "2598                                            NaN   \n",
       "2599                                            NaN   \n",
       "2600                                            NaN   \n",
       "2601                                            NaN   \n",
       "2602                                            NaN   \n",
       "2603                                            NaN   \n",
       "2604                                            NaN   \n",
       "2605                                            NaN   \n",
       "2606                                            NaN   \n",
       "2607                                            NaN   \n",
       "2608                                            NaN   \n",
       "2609                                            NaN   \n",
       "2610                                            NaN   \n",
       "2611                                            NaN   \n",
       "2612                                            NaN   \n",
       "2613                                            NaN   \n",
       "2614                                            NaN   \n",
       "2615                                            NaN   \n",
       "2616                                            NaN   \n",
       "\n",
       "     ('S21.G00.40.001', 'Date de début du contrat')  \\\n",
       "0                                          20122015   \n",
       "1                                          29042018   \n",
       "2                                          01052018   \n",
       "3                                          01062018   \n",
       "4                                          01072018   \n",
       "5                                          01102014   \n",
       "6                                          01102014   \n",
       "7                                          01102014   \n",
       "8                                          01102014   \n",
       "9                                          01102014   \n",
       "10                                         01102014   \n",
       "11                                         01102014   \n",
       "12                                         01102014   \n",
       "13                                         01102014   \n",
       "14                                         01102014   \n",
       "15                                         01102014   \n",
       "16                                         01102014   \n",
       "17                                         01102014   \n",
       "18                                         01102014   \n",
       "19                                         01102014   \n",
       "20                                         01102014   \n",
       "21                                         01102014   \n",
       "22                                         01012015   \n",
       "23                                         01072015   \n",
       "24                                         01062017   \n",
       "25                                         21082017   \n",
       "26                                         02102017   \n",
       "27                                         01112017   \n",
       "28                                         14122017   \n",
       "29                                         01012018   \n",
       "...                                             ...   \n",
       "2587                                       16062015   \n",
       "2588                                       01072016   \n",
       "2589                                       01012017   \n",
       "2590                                       01072017   \n",
       "2591                                       01092017   \n",
       "2592                                       01092017   \n",
       "2593                                       01102017   \n",
       "2594                                       01012018   \n",
       "2595                                       01012018   \n",
       "2596                                       01012018   \n",
       "2597                                       21032018   \n",
       "2598                                       01062018   \n",
       "2599                                       01062018   \n",
       "2600                                       18062018   \n",
       "2601                                       06082018   \n",
       "2602                                       03092018   \n",
       "2603                                       01092018   \n",
       "2604                                       01092018   \n",
       "2605                                       01102014   \n",
       "2606                                       01102014   \n",
       "2607                                       16032015   \n",
       "2608                                       01102014   \n",
       "2609                                       01102014   \n",
       "2610                                       01102014   \n",
       "2611                                       01102014   \n",
       "2612                                       01102014   \n",
       "2613                                       01102014   \n",
       "2614                                       01102014   \n",
       "2615                                       01102014   \n",
       "2616                                       30072018   \n",
       "\n",
       "     ('S21.G00.40.002', 'Statut du salarié (conventionnel)')       ...         \\\n",
       "0                                                    06            ...          \n",
       "1                                                    06            ...          \n",
       "2                                                    06            ...          \n",
       "3                                                    06            ...          \n",
       "4                                                    06            ...          \n",
       "5                                                    06            ...          \n",
       "6                                                    06            ...          \n",
       "7                                                    06            ...          \n",
       "8                                                    06            ...          \n",
       "9                                                    04            ...          \n",
       "10                                                   04            ...          \n",
       "11                                                   06            ...          \n",
       "12                                                   06            ...          \n",
       "13                                                   06            ...          \n",
       "14                                                   06            ...          \n",
       "15                                                   06            ...          \n",
       "16                                                   06            ...          \n",
       "17                                                   06            ...          \n",
       "18                                                   06            ...          \n",
       "19                                                   06            ...          \n",
       "20                                                   06            ...          \n",
       "21                                                   06            ...          \n",
       "22                                                   06            ...          \n",
       "23                                                   06            ...          \n",
       "24                                                   04            ...          \n",
       "25                                                   06            ...          \n",
       "26                                                   06            ...          \n",
       "27                                                   06            ...          \n",
       "28                                                   06            ...          \n",
       "29                                                   06            ...          \n",
       "...                                                 ...            ...          \n",
       "2587                                                 06            ...          \n",
       "2588                                                 06            ...          \n",
       "2589                                                 06            ...          \n",
       "2590                                                 06            ...          \n",
       "2591                                                 06            ...          \n",
       "2592                                                 06            ...          \n",
       "2593                                                 06            ...          \n",
       "2594                                                 06            ...          \n",
       "2595                                                 06            ...          \n",
       "2596                                                 06            ...          \n",
       "2597                                                 06            ...          \n",
       "2598                                                 06            ...          \n",
       "2599                                                 06            ...          \n",
       "2600                                                 06            ...          \n",
       "2601                                                 06            ...          \n",
       "2602                                                 06            ...          \n",
       "2603                                                 06            ...          \n",
       "2604                                                 06            ...          \n",
       "2605                                                 04            ...          \n",
       "2606                                                 06            ...          \n",
       "2607                                                 06            ...          \n",
       "2608                                                 06            ...          \n",
       "2609                                                 06            ...          \n",
       "2610                                                 06            ...          \n",
       "2611                                                 06            ...          \n",
       "2612                                                 06            ...          \n",
       "2613                                                 06            ...          \n",
       "2614                                                 06            ...          \n",
       "2615                                                 06            ...          \n",
       "2616                                                 06            ...          \n",
       "\n",
       "     ('S21.G00.70.010', \"Nombre d'ayants-droit autres (ascendants, collatéraux...)\")  \\\n",
       "0                                            ['0', '0']                                \n",
       "1                                                     0                                \n",
       "2                                                     0                                \n",
       "3                                                     0                                \n",
       "4                                            ['0', '0']                                \n",
       "5                                            ['0', '0']                                \n",
       "6                                                     0                                \n",
       "7                                            ['0', '0']                                \n",
       "8                                            ['0', '0']                                \n",
       "9                                            ['0', '0']                                \n",
       "10                                           ['0', '0']                                \n",
       "11                                           ['0', '0']                                \n",
       "12                                           ['0', '0']                                \n",
       "13                                           ['0', '0']                                \n",
       "14                                           ['0', '0']                                \n",
       "15                                           ['0', '0']                                \n",
       "16                                                    0                                \n",
       "17                                           ['0', '0']                                \n",
       "18                                           ['0', '0']                                \n",
       "19                                           ['0', '0']                                \n",
       "20                                           ['0', '0']                                \n",
       "21                                           ['0', '0']                                \n",
       "22                                           ['0', '0']                                \n",
       "23                                                    0                                \n",
       "24                                           ['0', '0']                                \n",
       "25                                                    0                                \n",
       "26                                           ['0', '0']                                \n",
       "27                                                    0                                \n",
       "28                                           ['0', '0']                                \n",
       "29                                           ['0', '0']                                \n",
       "...                                                 ...                                \n",
       "2587                                         ['0', '0']                                \n",
       "2588                                         ['0', '0']                                \n",
       "2589                                         ['0', '0']                                \n",
       "2590                                         ['0', '0']                                \n",
       "2591                                         ['0', '0']                                \n",
       "2592                                         ['0', '0']                                \n",
       "2593                                         ['0', '0']                                \n",
       "2594                                                  0                                \n",
       "2595                                         ['0', '0']                                \n",
       "2596                                                  0                                \n",
       "2597                                                  0                                \n",
       "2598                                                  0                                \n",
       "2599                                                  0                                \n",
       "2600                                                  0                                \n",
       "2601                                                  0                                \n",
       "2602                                                  0                                \n",
       "2603                                                  0                                \n",
       "2604                                                  0                                \n",
       "2605                                         ['0', '0']                                \n",
       "2606                                                  0                                \n",
       "2607                                         ['0', '0']                                \n",
       "2608                                         ['0', '0']                                \n",
       "2609                                         ['0', '0']                                \n",
       "2610                                         ['0', '0']                                \n",
       "2611                                                  0                                \n",
       "2612                                         ['0', '0']                                \n",
       "2613                                         ['0', '0']                                \n",
       "2614                                         ['0', '0']                                \n",
       "2615                                         ['0', '0']                                \n",
       "2616                                                  0                                \n",
       "\n",
       "     ('S21.G00.70.011', \"Nombre d'enfants ayants-droit\")  \\\n",
       "0                                            ['0', '0']    \n",
       "1                                                     0    \n",
       "2                                                     0    \n",
       "3                                                     0    \n",
       "4                                            ['0', '0']    \n",
       "5                                            ['0', '0']    \n",
       "6                                                     0    \n",
       "7                                            ['0', '0']    \n",
       "8                                            ['0', '0']    \n",
       "9                                            ['0', '0']    \n",
       "10                                           ['0', '0']    \n",
       "11                                           ['0', '0']    \n",
       "12                                           ['0', '0']    \n",
       "13                                           ['0', '0']    \n",
       "14                                           ['0', '0']    \n",
       "15                                           ['0', '0']    \n",
       "16                                                    0    \n",
       "17                                           ['0', '0']    \n",
       "18                                           ['0', '0']    \n",
       "19                                           ['0', '0']    \n",
       "20                                           ['0', '0']    \n",
       "21                                           ['0', '0']    \n",
       "22                                           ['0', '0']    \n",
       "23                                                    0    \n",
       "24                                           ['0', '0']    \n",
       "25                                                    0    \n",
       "26                                           ['0', '0']    \n",
       "27                                                    0    \n",
       "28                                           ['0', '0']    \n",
       "29                                           ['0', '0']    \n",
       "...                                                 ...    \n",
       "2587                                         ['0', '0']    \n",
       "2588                                         ['0', '0']    \n",
       "2589                                         ['0', '0']    \n",
       "2590                                         ['0', '0']    \n",
       "2591                                         ['0', '0']    \n",
       "2592                                         ['0', '0']    \n",
       "2593                                         ['0', '0']    \n",
       "2594                                                  0    \n",
       "2595                                         ['0', '0']    \n",
       "2596                                                  0    \n",
       "2597                                                  0    \n",
       "2598                                                  0    \n",
       "2599                                                  0    \n",
       "2600                                                  0    \n",
       "2601                                                  0    \n",
       "2602                                                  0    \n",
       "2603                                                  0    \n",
       "2604                                                  0    \n",
       "2605                                         ['0', '0']    \n",
       "2606                                                  0    \n",
       "2607                                         ['0', '0']    \n",
       "2608                                         ['0', '0']    \n",
       "2609                                         ['0', '0']    \n",
       "2610                                         ['0', '0']    \n",
       "2611                                                  0    \n",
       "2612                                         ['0', '0']    \n",
       "2613                                         ['0', '0']    \n",
       "2614                                         ['0', '0']    \n",
       "2615                                         ['0', '0']    \n",
       "2616                                                  0    \n",
       "\n",
       "     ('S21.G00.70.012', 'Identifiant technique Affiliation')  \\\n",
       "0                                   3459048255974703064        \n",
       "1                                   3426801196285240187        \n",
       "2                                   3426801196285240187        \n",
       "3                                   3426801196285240187        \n",
       "4                                   3459048255974703064        \n",
       "5                                   3459048255974703064        \n",
       "6                                   3426801196285240187        \n",
       "7                                   3459048255974703064        \n",
       "8                                   3459048255974703064        \n",
       "9                                   3459048255974703064        \n",
       "10                                  3459048255974703064        \n",
       "11                                  3459048255974703064        \n",
       "12                                  3459048255974703064        \n",
       "13                                  3459048255974703064        \n",
       "14                                  3459048255974703064        \n",
       "15                                  3459048255974703064        \n",
       "16                                  3426801196285240187        \n",
       "17                                  3459048255974703064        \n",
       "18                                  3459048255974703064        \n",
       "19                                  3459048255974703064        \n",
       "20                                  3459048255974703064        \n",
       "21                                  3459048255974703064        \n",
       "22                                  3459048255974703064        \n",
       "23                                  3426801196285240187        \n",
       "24                                  3459048255974703064        \n",
       "25                                  3426801196285240187        \n",
       "26                                  3459048255974703064        \n",
       "27                                  3426801196285240187        \n",
       "28                                  3459048255974703064        \n",
       "29                                  3459048255974703064        \n",
       "...                                                 ...        \n",
       "2587                                3459048255974703064        \n",
       "2588                                3459048255974703064        \n",
       "2589                                3459048255974703064        \n",
       "2590                                3459048255974703064        \n",
       "2591                                3459048255974703064        \n",
       "2592                                3459048255974703064        \n",
       "2593                                3459048255974703064        \n",
       "2594                                3426801196285240187        \n",
       "2595                                3459048255974703064        \n",
       "2596                                3426801196285240187        \n",
       "2597                                3426801196285240187        \n",
       "2598                                3426801196285240187        \n",
       "2599                                3426801196285240187        \n",
       "2600                                3426801196285240187        \n",
       "2601                                3426801196285240187        \n",
       "2602                                3426801196285240187        \n",
       "2603                                3426801196285240187        \n",
       "2604                                3426801196285240187        \n",
       "2605                                3459048255974703064        \n",
       "2606                                3426801196285240187        \n",
       "2607                                3459048255974703064        \n",
       "2608                                3459048255974703064        \n",
       "2609                                3459048255974703064        \n",
       "2610                                3459048255974703064        \n",
       "2611                                3426801196285240187        \n",
       "2612                                3459048255974703064        \n",
       "2613                                3459048255974703064        \n",
       "2614                                3459048255974703064        \n",
       "2615                                3459048255974703064        \n",
       "2616                                3426801196285240187        \n",
       "\n",
       "     ('S21.G00.70.013', 'Identifiant technique Adhésion')  \\\n",
       "0                                   8151159325541050343     \n",
       "1                                    970579013592031102     \n",
       "2                                    970579013592031102     \n",
       "3                                    970579013592031102     \n",
       "4                                   8151159325541050343     \n",
       "5                                   8151159325541050343     \n",
       "6                                    970579013592031102     \n",
       "7                                   8151159325541050343     \n",
       "8                                   8151159325541050343     \n",
       "9                                   8151159325541050343     \n",
       "10                                  8151159325541050343     \n",
       "11                                  8151159325541050343     \n",
       "12                                  8151159325541050343     \n",
       "13                                  8151159325541050343     \n",
       "14                                  8151159325541050343     \n",
       "15                                  8151159325541050343     \n",
       "16                                   970579013592031102     \n",
       "17                                  8151159325541050343     \n",
       "18                                  8151159325541050343     \n",
       "19                                  8151159325541050343     \n",
       "20                                  8151159325541050343     \n",
       "21                                  8151159325541050343     \n",
       "22                                  8151159325541050343     \n",
       "23                                   970579013592031102     \n",
       "24                                  8151159325541050343     \n",
       "25                                   970579013592031102     \n",
       "26                                  8151159325541050343     \n",
       "27                                   970579013592031102     \n",
       "28                                  8151159325541050343     \n",
       "29                                  3459048255974703064     \n",
       "...                                                 ...     \n",
       "2587                                8151159325541050343     \n",
       "2588                                8151159325541050343     \n",
       "2589                                8151159325541050343     \n",
       "2590                                8151159325541050343     \n",
       "2591                                8151159325541050343     \n",
       "2592                                8151159325541050343     \n",
       "2593                                3459048255974703064     \n",
       "2594                                 970579013592031102     \n",
       "2595                                8151159325541050343     \n",
       "2596                                 970579013592031102     \n",
       "2597                                 970579013592031102     \n",
       "2598                                 970579013592031102     \n",
       "2599                                 970579013592031102     \n",
       "2600                                 970579013592031102     \n",
       "2601                                 970579013592031102     \n",
       "2602                                 970579013592031102     \n",
       "2603                                 970579013592031102     \n",
       "2604                                 970579013592031102     \n",
       "2605                                8151159325541050343     \n",
       "2606                                 970579013592031102     \n",
       "2607                                8151159325541050343     \n",
       "2608                                8151159325541050343     \n",
       "2609                                8151159325541050343     \n",
       "2610                                8151159325541050343     \n",
       "2611                                 970579013592031102     \n",
       "2612                                8151159325541050343     \n",
       "2613                                8151159325541050343     \n",
       "2614                                8151159325541050343     \n",
       "2615                                8151159325541050343     \n",
       "2616                                 970579013592031102     \n",
       "\n",
       "     ('S21.G00.70.014', nan) ('S21.G00.86.001', 'Type')  \\\n",
       "0                        NaN                         01   \n",
       "1                        NaN                         01   \n",
       "2                        NaN                         01   \n",
       "3                        NaN                         01   \n",
       "4                   01092018                         01   \n",
       "5                        NaN                         01   \n",
       "6                        NaN                         01   \n",
       "7                        NaN                         01   \n",
       "8                        NaN                         01   \n",
       "9                        NaN                         01   \n",
       "10                       NaN                         01   \n",
       "11                       NaN                         01   \n",
       "12                       NaN                         01   \n",
       "13                       NaN                         01   \n",
       "14                       NaN                         01   \n",
       "15                       NaN                         01   \n",
       "16                       NaN                         01   \n",
       "17                       NaN                         01   \n",
       "18                       NaN                         01   \n",
       "19                       NaN                         01   \n",
       "20                       NaN                         01   \n",
       "21                       NaN                         01   \n",
       "22                       NaN                         01   \n",
       "23                       NaN                         01   \n",
       "24                       NaN                         01   \n",
       "25                       NaN                         01   \n",
       "26                       NaN                         01   \n",
       "27                       NaN                         01   \n",
       "28                       NaN                         01   \n",
       "29                       NaN                         01   \n",
       "...                      ...                        ...   \n",
       "2587                     NaN                         01   \n",
       "2588                     NaN                         01   \n",
       "2589                     NaN                         01   \n",
       "2590                     NaN                         01   \n",
       "2591                     NaN                         01   \n",
       "2592                     NaN                         01   \n",
       "2593                     NaN                         01   \n",
       "2594                     NaN                         01   \n",
       "2595                     NaN                         01   \n",
       "2596                     NaN                         01   \n",
       "2597                     NaN                         01   \n",
       "2598                     NaN                         01   \n",
       "2599                     NaN                         01   \n",
       "2600                     NaN                         01   \n",
       "2601                     NaN                         01   \n",
       "2602                     NaN                         01   \n",
       "2603                     NaN                         01   \n",
       "2604                     NaN                         01   \n",
       "2605                     NaN                         01   \n",
       "2606                     NaN                         01   \n",
       "2607                     NaN                         01   \n",
       "2608                     NaN                         01   \n",
       "2609                     NaN                         01   \n",
       "2610                     NaN                         01   \n",
       "2611                     NaN                         01   \n",
       "2612                     NaN                         01   \n",
       "2613                     NaN                         01   \n",
       "2614                     NaN                         01   \n",
       "2615                     NaN                         01   \n",
       "2616                     NaN                         01   \n",
       "\n",
       "      ('S21.G00.86.002', 'Unité de mesure') ('S21.G00.86.003', 'Valeur')  \\\n",
       "0                                        01                         1016   \n",
       "1                                        01                          956   \n",
       "2                                        01                          189   \n",
       "3                                        01                          164   \n",
       "4                                        01                          207   \n",
       "5                                        01                        10925   \n",
       "6                                        01                         8491   \n",
       "7                                        01                         9324   \n",
       "8                                        01                        10410   \n",
       "9                                        01                         8628   \n",
       "10                                       01                        11270   \n",
       "11                                       01                         7153   \n",
       "12                                       01                         6426   \n",
       "13                                       01                         6559   \n",
       "14                                       01                         4945   \n",
       "15                                       01                         4703   \n",
       "16                                       01                         4279   \n",
       "17                                       01                         4067   \n",
       "18                                       01                         3457   \n",
       "19                                       01                         3206   \n",
       "20                                       01                         2496   \n",
       "21                                       01                         1630   \n",
       "22                                       01                         1432   \n",
       "23                                       01                         1269   \n",
       "24                                       01                         8960   \n",
       "25                                       01                         1090   \n",
       "26                                       01                          364   \n",
       "27                                       01                          910   \n",
       "28                                       01                          291   \n",
       "29                                       01                          287   \n",
       "...                                     ...                          ...   \n",
       "2587                                     01                         1260   \n",
       "2588                                     01                          905   \n",
       "2589                                     01                          833   \n",
       "2590                                     01                          607   \n",
       "2591                                     01                          544   \n",
       "2592                                     01                         1183   \n",
       "2593                                     01                          574   \n",
       "2594                                     01                          371   \n",
       "2595                                     01                          374   \n",
       "2596                                     01                          350   \n",
       "2597                                     01                          194   \n",
       "2598                                     01                          203   \n",
       "2599                                     01                          199   \n",
       "2600                                     01                          147   \n",
       "2601                                     01                           56   \n",
       "2602                                     01                           28   \n",
       "2603                                     01                           30   \n",
       "2604                                     01                           30   \n",
       "2605                                     01                         6076   \n",
       "2606                                     01                        10080   \n",
       "2607                                     01                         4029   \n",
       "2608                                     01                        10104   \n",
       "2609                                     01                         5334   \n",
       "2610                                     01                         5479   \n",
       "2611                                     01                         9016   \n",
       "2612                                     01                         4347   \n",
       "2613                                     01                         4039   \n",
       "2614                                     01                         3157   \n",
       "2615                                     01                         2973   \n",
       "2616                                     01                           63   \n",
       "\n",
       "     ('S21.G00.86.005', 'Numéro du contrat') Unnamed: 0.1.1.1  \n",
       "0                         818804314150338465                0  \n",
       "1                        5062950368187149217                1  \n",
       "2                        6538046486002635820                2  \n",
       "3                        6274365465970049139                3  \n",
       "4                        2177083209391047952                4  \n",
       "5                        1813037183403608302                5  \n",
       "6                        3652708417458515775                6  \n",
       "7                        2850529884753525020                7  \n",
       "8                         167823990482649395                8  \n",
       "9                         694421425782240772                9  \n",
       "10                       7159113741589673965               10  \n",
       "11                       2727216476858878079               11  \n",
       "12                       5265255753580133596               12  \n",
       "13                       3349437125772570619               13  \n",
       "14                       1180135311347997151               14  \n",
       "15                       3420812909788976964               15  \n",
       "16                       9162660237646300115               16  \n",
       "17                       4885954375751391374               17  \n",
       "18                       4288287697472645046               18  \n",
       "19                       6570170158378405001               19  \n",
       "20                        425650408013017981               20  \n",
       "21                       3143312799405920287               21  \n",
       "22                       1469883324021351994               22  \n",
       "23                       7837756792996550705               23  \n",
       "24                       2149108281688600381               24  \n",
       "25                       8799307255273835075               25  \n",
       "26                       7000840322664899104               26  \n",
       "27                       2384688779049884557               27  \n",
       "28                       7870577635990534373               28  \n",
       "29                        881314362425168731               29  \n",
       "...                                      ...              ...  \n",
       "2587                     4834120171048102958             2587  \n",
       "2588                      683828758928152661             2588  \n",
       "2589                     7221255194562272665             2589  \n",
       "2590                     3698917690617163002             2590  \n",
       "2591                     4249409429706839134             2591  \n",
       "2592                     5620218769796984271             2592  \n",
       "2593                     8839660826908513977             2593  \n",
       "2594                     3997822093275412105             2594  \n",
       "2595                     1901639391550104623             2595  \n",
       "2596                     9150234965342168853             2596  \n",
       "2597                     7949664969466976486             2597  \n",
       "2598                     8619966990251332608             2598  \n",
       "2599                     4973604679353592430             2599  \n",
       "2600                     3215681245706328957             2600  \n",
       "2601                     1476482701907964752             2601  \n",
       "2602                     2723253731195137972             2602  \n",
       "2603                      787867068654832392             2603  \n",
       "2604                      975458426065869036             2604  \n",
       "2605                     3104144261411391019             2605  \n",
       "2606                     1675624590658596295             2606  \n",
       "2607                     6870212934181519876             2607  \n",
       "2608                     6726960970436385335             2608  \n",
       "2609                     7293694087988396906             2609  \n",
       "2610                     6581531391815583762             2610  \n",
       "2611                     7899380811344089746             2611  \n",
       "2612                     1979743340121760892             2612  \n",
       "2613                     1767314840430178948             2613  \n",
       "2614                      121345335568216352             2614  \n",
       "2615                     6330781511945007660             2615  \n",
       "2616                     3549699751783595424             2616  \n",
       "\n",
       "[2617 rows x 93 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "tmp = []\n",
    "for i in df.columns :\n",
    "    if df[i].isna().sum() >2615 :\n",
    "        tmp.append(i)\n",
    "df = df.drop(columns = tmp)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>Unnamed: 0</th>\n",
       "      <th>Unnamed: 0.1</th>\n",
       "      <th>Unnamed: 0.1.1</th>\n",
       "      <th>('S21.G00.30.005', 'Sexe')</th>\n",
       "      <th>('S21.G00.30.006', 'Date de naissance')</th>\n",
       "      <th>('S21.G00.30.020', 'Numéro technique temporaire')</th>\n",
       "      <th>('S21.G00.30.023', 'Embauche')</th>\n",
       "      <th>('S21.G00.40.001', 'Date de début du contrat')</th>\n",
       "      <th>('S21.G00.40.002', 'Statut du salarié (conventionnel)')</th>\n",
       "      <th>('S21.G00.40.003', 'Code statut catégoriel Retraite Complémentaire obligatoire')</th>\n",
       "      <th>...</th>\n",
       "      <th>('S21.G00.70.010', \"Nombre d'ayants-droit autres (ascendants, collatéraux...)\")</th>\n",
       "      <th>('S21.G00.70.011', \"Nombre d'enfants ayants-droit\")</th>\n",
       "      <th>('S21.G00.70.012', 'Identifiant technique Affiliation')</th>\n",
       "      <th>('S21.G00.70.013', 'Identifiant technique Adhésion')</th>\n",
       "      <th>('S21.G00.70.014', nan)</th>\n",
       "      <th>('S21.G00.86.001', 'Type')</th>\n",
       "      <th>('S21.G00.86.002', 'Unité de mesure')</th>\n",
       "      <th>('S21.G00.86.003', 'Valeur')</th>\n",
       "      <th>('S21.G00.86.005', 'Numéro du contrat')</th>\n",
       "      <th>Unnamed: 0.1.1.1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>15091997</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>20122015</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>1016</td>\n",
       "      <td>818804314150338465</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>23021991</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>29042018</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3426801196285240187</td>\n",
       "      <td>970579013592031102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>956</td>\n",
       "      <td>5062950368187149217</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>17091974</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01052018</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3426801196285240187</td>\n",
       "      <td>970579013592031102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>189</td>\n",
       "      <td>6538046486002635820</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3051994</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01062018</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3426801196285240187</td>\n",
       "      <td>970579013592031102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>164</td>\n",
       "      <td>6274365465970049139</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>19111986</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01072018</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>01092018</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>207</td>\n",
       "      <td>2177083209391047952</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>5071964</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>10925</td>\n",
       "      <td>1813037183403608302</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>28051972</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3426801196285240187</td>\n",
       "      <td>970579013592031102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>8491</td>\n",
       "      <td>3652708417458515775</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>2</td>\n",
       "      <td>23061969</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>9324</td>\n",
       "      <td>2850529884753525020</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>2</td>\n",
       "      <td>25021971</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>10410</td>\n",
       "      <td>167823990482649395</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>19071972</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01102014</td>\n",
       "      <td>04</td>\n",
       "      <td>01</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>8628</td>\n",
       "      <td>694421425782240772</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>10091963</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01102014</td>\n",
       "      <td>04</td>\n",
       "      <td>01</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>11270</td>\n",
       "      <td>7159113741589673965</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>2</td>\n",
       "      <td>3061973</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>7153</td>\n",
       "      <td>2727216476858878079</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>1</td>\n",
       "      <td>27041977</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>6426</td>\n",
       "      <td>5265255753580133596</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>2</td>\n",
       "      <td>2081979</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>6559</td>\n",
       "      <td>3349437125772570619</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>2</td>\n",
       "      <td>20031984</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>4945</td>\n",
       "      <td>1180135311347997151</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>15111984</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>4703</td>\n",
       "      <td>3420812909788976964</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>2</td>\n",
       "      <td>20101966</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3426801196285240187</td>\n",
       "      <td>970579013592031102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>4279</td>\n",
       "      <td>9162660237646300115</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>17</td>\n",
       "      <td>17</td>\n",
       "      <td>17</td>\n",
       "      <td>1</td>\n",
       "      <td>10071981</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>4067</td>\n",
       "      <td>4885954375751391374</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>2</td>\n",
       "      <td>8051986</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>3457</td>\n",
       "      <td>4288287697472645046</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>19</td>\n",
       "      <td>19</td>\n",
       "      <td>19</td>\n",
       "      <td>1</td>\n",
       "      <td>10021981</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>3206</td>\n",
       "      <td>6570170158378405001</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>2</td>\n",
       "      <td>16091984</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>2496</td>\n",
       "      <td>425650408013017981</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>21</td>\n",
       "      <td>21</td>\n",
       "      <td>21</td>\n",
       "      <td>2</td>\n",
       "      <td>8011989</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>1630</td>\n",
       "      <td>3143312799405920287</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>22</td>\n",
       "      <td>22</td>\n",
       "      <td>22</td>\n",
       "      <td>2</td>\n",
       "      <td>3061990</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01012015</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>1432</td>\n",
       "      <td>1469883324021351994</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "      <td>2</td>\n",
       "      <td>10081984</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01072015</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3426801196285240187</td>\n",
       "      <td>970579013592031102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>1269</td>\n",
       "      <td>7837756792996550705</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>24</td>\n",
       "      <td>24</td>\n",
       "      <td>24</td>\n",
       "      <td>1</td>\n",
       "      <td>8021970</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01062017</td>\n",
       "      <td>04</td>\n",
       "      <td>01</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>8960</td>\n",
       "      <td>2149108281688600381</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>25</td>\n",
       "      <td>25</td>\n",
       "      <td>25</td>\n",
       "      <td>2</td>\n",
       "      <td>16081989</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>21082017</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3426801196285240187</td>\n",
       "      <td>970579013592031102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>1090</td>\n",
       "      <td>8799307255273835075</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "      <td>1</td>\n",
       "      <td>28021996</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>02102017</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>364</td>\n",
       "      <td>7000840322664899104</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "      <td>2</td>\n",
       "      <td>31011994</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01112017</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3426801196285240187</td>\n",
       "      <td>970579013592031102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>910</td>\n",
       "      <td>2384688779049884557</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>28</td>\n",
       "      <td>28</td>\n",
       "      <td>28</td>\n",
       "      <td>2</td>\n",
       "      <td>10031991</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>14122017</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>291</td>\n",
       "      <td>7870577635990534373</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>29</td>\n",
       "      <td>29</td>\n",
       "      <td>29</td>\n",
       "      <td>1</td>\n",
       "      <td>10021994</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01012018</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>287</td>\n",
       "      <td>881314362425168731</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2587</th>\n",
       "      <td>2587</td>\n",
       "      <td>2587</td>\n",
       "      <td>2587</td>\n",
       "      <td>1</td>\n",
       "      <td>1111980</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>16062015</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>1260</td>\n",
       "      <td>4834120171048102958</td>\n",
       "      <td>2587</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2588</th>\n",
       "      <td>2588</td>\n",
       "      <td>2588</td>\n",
       "      <td>2588</td>\n",
       "      <td>1</td>\n",
       "      <td>24021987</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01072016</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>905</td>\n",
       "      <td>683828758928152661</td>\n",
       "      <td>2588</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2589</th>\n",
       "      <td>2589</td>\n",
       "      <td>2589</td>\n",
       "      <td>2589</td>\n",
       "      <td>1</td>\n",
       "      <td>22041988</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01012017</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>833</td>\n",
       "      <td>7221255194562272665</td>\n",
       "      <td>2589</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2590</th>\n",
       "      <td>2590</td>\n",
       "      <td>2590</td>\n",
       "      <td>2590</td>\n",
       "      <td>2</td>\n",
       "      <td>23061984</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01072017</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>607</td>\n",
       "      <td>3698917690617163002</td>\n",
       "      <td>2590</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2591</th>\n",
       "      <td>2591</td>\n",
       "      <td>2591</td>\n",
       "      <td>2591</td>\n",
       "      <td>2</td>\n",
       "      <td>9111996</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01092017</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>544</td>\n",
       "      <td>4249409429706839134</td>\n",
       "      <td>2591</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2592</th>\n",
       "      <td>2592</td>\n",
       "      <td>2592</td>\n",
       "      <td>2592</td>\n",
       "      <td>1</td>\n",
       "      <td>21101984</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01092017</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>1183</td>\n",
       "      <td>5620218769796984271</td>\n",
       "      <td>2592</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2593</th>\n",
       "      <td>2593</td>\n",
       "      <td>2593</td>\n",
       "      <td>2593</td>\n",
       "      <td>1</td>\n",
       "      <td>6091994</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01102017</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>574</td>\n",
       "      <td>8839660826908513977</td>\n",
       "      <td>2593</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2594</th>\n",
       "      <td>2594</td>\n",
       "      <td>2594</td>\n",
       "      <td>2594</td>\n",
       "      <td>2</td>\n",
       "      <td>9061995</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01012018</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3426801196285240187</td>\n",
       "      <td>970579013592031102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>371</td>\n",
       "      <td>3997822093275412105</td>\n",
       "      <td>2594</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2595</th>\n",
       "      <td>2595</td>\n",
       "      <td>2595</td>\n",
       "      <td>2595</td>\n",
       "      <td>2</td>\n",
       "      <td>3121993</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01012018</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>374</td>\n",
       "      <td>1901639391550104623</td>\n",
       "      <td>2595</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2596</th>\n",
       "      <td>2596</td>\n",
       "      <td>2596</td>\n",
       "      <td>2596</td>\n",
       "      <td>2</td>\n",
       "      <td>24051995</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01012018</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3426801196285240187</td>\n",
       "      <td>970579013592031102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>350</td>\n",
       "      <td>9150234965342168853</td>\n",
       "      <td>2596</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2597</th>\n",
       "      <td>2597</td>\n",
       "      <td>2597</td>\n",
       "      <td>2597</td>\n",
       "      <td>2</td>\n",
       "      <td>22051995</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>21032018</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3426801196285240187</td>\n",
       "      <td>970579013592031102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>194</td>\n",
       "      <td>7949664969466976486</td>\n",
       "      <td>2597</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2598</th>\n",
       "      <td>2598</td>\n",
       "      <td>2598</td>\n",
       "      <td>2598</td>\n",
       "      <td>1</td>\n",
       "      <td>4051983</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01062018</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3426801196285240187</td>\n",
       "      <td>970579013592031102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>203</td>\n",
       "      <td>8619966990251332608</td>\n",
       "      <td>2598</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2599</th>\n",
       "      <td>2599</td>\n",
       "      <td>2599</td>\n",
       "      <td>2599</td>\n",
       "      <td>2</td>\n",
       "      <td>5041996</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01062018</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3426801196285240187</td>\n",
       "      <td>970579013592031102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>199</td>\n",
       "      <td>4973604679353592430</td>\n",
       "      <td>2599</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2600</th>\n",
       "      <td>2600</td>\n",
       "      <td>2600</td>\n",
       "      <td>2600</td>\n",
       "      <td>2</td>\n",
       "      <td>12111992</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>18062018</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3426801196285240187</td>\n",
       "      <td>970579013592031102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>147</td>\n",
       "      <td>3215681245706328957</td>\n",
       "      <td>2600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2601</th>\n",
       "      <td>2601</td>\n",
       "      <td>2601</td>\n",
       "      <td>2601</td>\n",
       "      <td>2</td>\n",
       "      <td>29061997</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>06082018</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3426801196285240187</td>\n",
       "      <td>970579013592031102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>56</td>\n",
       "      <td>1476482701907964752</td>\n",
       "      <td>2601</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2602</th>\n",
       "      <td>2602</td>\n",
       "      <td>2602</td>\n",
       "      <td>2602</td>\n",
       "      <td>1</td>\n",
       "      <td>9101999</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>03092018</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3426801196285240187</td>\n",
       "      <td>970579013592031102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>28</td>\n",
       "      <td>2723253731195137972</td>\n",
       "      <td>2602</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2603</th>\n",
       "      <td>2603</td>\n",
       "      <td>2603</td>\n",
       "      <td>2603</td>\n",
       "      <td>1</td>\n",
       "      <td>24011995</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01092018</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3426801196285240187</td>\n",
       "      <td>970579013592031102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>30</td>\n",
       "      <td>787867068654832392</td>\n",
       "      <td>2603</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2604</th>\n",
       "      <td>2604</td>\n",
       "      <td>2604</td>\n",
       "      <td>2604</td>\n",
       "      <td>2</td>\n",
       "      <td>29091989</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01092018</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3426801196285240187</td>\n",
       "      <td>970579013592031102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>30</td>\n",
       "      <td>975458426065869036</td>\n",
       "      <td>2604</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2605</th>\n",
       "      <td>2605</td>\n",
       "      <td>2605</td>\n",
       "      <td>2605</td>\n",
       "      <td>1</td>\n",
       "      <td>23071970</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01102014</td>\n",
       "      <td>04</td>\n",
       "      <td>01</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>6076</td>\n",
       "      <td>3104144261411391019</td>\n",
       "      <td>2605</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2606</th>\n",
       "      <td>2606</td>\n",
       "      <td>2606</td>\n",
       "      <td>2606</td>\n",
       "      <td>2</td>\n",
       "      <td>29041964</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3426801196285240187</td>\n",
       "      <td>970579013592031102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>10080</td>\n",
       "      <td>1675624590658596295</td>\n",
       "      <td>2606</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2607</th>\n",
       "      <td>2607</td>\n",
       "      <td>2607</td>\n",
       "      <td>2607</td>\n",
       "      <td>2</td>\n",
       "      <td>19101986</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>16032015</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>4029</td>\n",
       "      <td>6870212934181519876</td>\n",
       "      <td>2607</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2608</th>\n",
       "      <td>2608</td>\n",
       "      <td>2608</td>\n",
       "      <td>2608</td>\n",
       "      <td>1</td>\n",
       "      <td>7041957</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>10104</td>\n",
       "      <td>6726960970436385335</td>\n",
       "      <td>2608</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2609</th>\n",
       "      <td>2609</td>\n",
       "      <td>2609</td>\n",
       "      <td>2609</td>\n",
       "      <td>2</td>\n",
       "      <td>7061983</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>5334</td>\n",
       "      <td>7293694087988396906</td>\n",
       "      <td>2609</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2610</th>\n",
       "      <td>2610</td>\n",
       "      <td>2610</td>\n",
       "      <td>2610</td>\n",
       "      <td>1</td>\n",
       "      <td>30051979</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>5479</td>\n",
       "      <td>6581531391815583762</td>\n",
       "      <td>2610</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2611</th>\n",
       "      <td>2611</td>\n",
       "      <td>2611</td>\n",
       "      <td>2611</td>\n",
       "      <td>2</td>\n",
       "      <td>24071965</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3426801196285240187</td>\n",
       "      <td>970579013592031102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>9016</td>\n",
       "      <td>7899380811344089746</td>\n",
       "      <td>2611</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2612</th>\n",
       "      <td>2612</td>\n",
       "      <td>2612</td>\n",
       "      <td>2612</td>\n",
       "      <td>1</td>\n",
       "      <td>24061985</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>4347</td>\n",
       "      <td>1979743340121760892</td>\n",
       "      <td>2612</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2613</th>\n",
       "      <td>2613</td>\n",
       "      <td>2613</td>\n",
       "      <td>2613</td>\n",
       "      <td>1</td>\n",
       "      <td>20061979</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>4039</td>\n",
       "      <td>1767314840430178948</td>\n",
       "      <td>2613</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2614</th>\n",
       "      <td>2614</td>\n",
       "      <td>2614</td>\n",
       "      <td>2614</td>\n",
       "      <td>2</td>\n",
       "      <td>17071987</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>3157</td>\n",
       "      <td>121345335568216352</td>\n",
       "      <td>2614</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2615</th>\n",
       "      <td>2615</td>\n",
       "      <td>2615</td>\n",
       "      <td>2615</td>\n",
       "      <td>2</td>\n",
       "      <td>10091989</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>01102014</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>['0', '0']</td>\n",
       "      <td>3459048255974703064</td>\n",
       "      <td>8151159325541050343</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>2973</td>\n",
       "      <td>6330781511945007660</td>\n",
       "      <td>2615</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2616</th>\n",
       "      <td>2616</td>\n",
       "      <td>2616</td>\n",
       "      <td>2616</td>\n",
       "      <td>1</td>\n",
       "      <td>28111981</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>30072018</td>\n",
       "      <td>06</td>\n",
       "      <td>04</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3426801196285240187</td>\n",
       "      <td>970579013592031102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>63</td>\n",
       "      <td>3549699751783595424</td>\n",
       "      <td>2616</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2617 rows × 88 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Unnamed: 0  Unnamed: 0.1  Unnamed: 0.1.1  ('S21.G00.30.005', 'Sexe')  \\\n",
       "0              0             0               0                           2   \n",
       "1              1             1               1                           2   \n",
       "2              2             2               2                           2   \n",
       "3              3             3               3                           2   \n",
       "4              4             4               4                           1   \n",
       "5              5             5               5                           2   \n",
       "6              6             6               6                           2   \n",
       "7              7             7               7                           2   \n",
       "8              8             8               8                           2   \n",
       "9              9             9               9                           1   \n",
       "10            10            10              10                           1   \n",
       "11            11            11              11                           2   \n",
       "12            12            12              12                           1   \n",
       "13            13            13              13                           2   \n",
       "14            14            14              14                           2   \n",
       "15            15            15              15                           1   \n",
       "16            16            16              16                           2   \n",
       "17            17            17              17                           1   \n",
       "18            18            18              18                           2   \n",
       "19            19            19              19                           1   \n",
       "20            20            20              20                           2   \n",
       "21            21            21              21                           2   \n",
       "22            22            22              22                           2   \n",
       "23            23            23              23                           2   \n",
       "24            24            24              24                           1   \n",
       "25            25            25              25                           2   \n",
       "26            26            26              26                           1   \n",
       "27            27            27              27                           2   \n",
       "28            28            28              28                           2   \n",
       "29            29            29              29                           1   \n",
       "...          ...           ...             ...                         ...   \n",
       "2587        2587          2587            2587                           1   \n",
       "2588        2588          2588            2588                           1   \n",
       "2589        2589          2589            2589                           1   \n",
       "2590        2590          2590            2590                           2   \n",
       "2591        2591          2591            2591                           2   \n",
       "2592        2592          2592            2592                           1   \n",
       "2593        2593          2593            2593                           1   \n",
       "2594        2594          2594            2594                           2   \n",
       "2595        2595          2595            2595                           2   \n",
       "2596        2596          2596            2596                           2   \n",
       "2597        2597          2597            2597                           2   \n",
       "2598        2598          2598            2598                           1   \n",
       "2599        2599          2599            2599                           2   \n",
       "2600        2600          2600            2600                           2   \n",
       "2601        2601          2601            2601                           2   \n",
       "2602        2602          2602            2602                           1   \n",
       "2603        2603          2603            2603                           1   \n",
       "2604        2604          2604            2604                           2   \n",
       "2605        2605          2605            2605                           1   \n",
       "2606        2606          2606            2606                           2   \n",
       "2607        2607          2607            2607                           2   \n",
       "2608        2608          2608            2608                           1   \n",
       "2609        2609          2609            2609                           2   \n",
       "2610        2610          2610            2610                           1   \n",
       "2611        2611          2611            2611                           2   \n",
       "2612        2612          2612            2612                           1   \n",
       "2613        2613          2613            2613                           1   \n",
       "2614        2614          2614            2614                           2   \n",
       "2615        2615          2615            2615                           2   \n",
       "2616        2616          2616            2616                           1   \n",
       "\n",
       "      ('S21.G00.30.006', 'Date de naissance')  \\\n",
       "0                                    15091997   \n",
       "1                                    23021991   \n",
       "2                                    17091974   \n",
       "3                                     3051994   \n",
       "4                                    19111986   \n",
       "5                                     5071964   \n",
       "6                                    28051972   \n",
       "7                                    23061969   \n",
       "8                                    25021971   \n",
       "9                                    19071972   \n",
       "10                                   10091963   \n",
       "11                                    3061973   \n",
       "12                                   27041977   \n",
       "13                                    2081979   \n",
       "14                                   20031984   \n",
       "15                                   15111984   \n",
       "16                                   20101966   \n",
       "17                                   10071981   \n",
       "18                                    8051986   \n",
       "19                                   10021981   \n",
       "20                                   16091984   \n",
       "21                                    8011989   \n",
       "22                                    3061990   \n",
       "23                                   10081984   \n",
       "24                                    8021970   \n",
       "25                                   16081989   \n",
       "26                                   28021996   \n",
       "27                                   31011994   \n",
       "28                                   10031991   \n",
       "29                                   10021994   \n",
       "...                                       ...   \n",
       "2587                                  1111980   \n",
       "2588                                 24021987   \n",
       "2589                                 22041988   \n",
       "2590                                 23061984   \n",
       "2591                                  9111996   \n",
       "2592                                 21101984   \n",
       "2593                                  6091994   \n",
       "2594                                  9061995   \n",
       "2595                                  3121993   \n",
       "2596                                 24051995   \n",
       "2597                                 22051995   \n",
       "2598                                  4051983   \n",
       "2599                                  5041996   \n",
       "2600                                 12111992   \n",
       "2601                                 29061997   \n",
       "2602                                  9101999   \n",
       "2603                                 24011995   \n",
       "2604                                 29091989   \n",
       "2605                                 23071970   \n",
       "2606                                 29041964   \n",
       "2607                                 19101986   \n",
       "2608                                  7041957   \n",
       "2609                                  7061983   \n",
       "2610                                 30051979   \n",
       "2611                                 24071965   \n",
       "2612                                 24061985   \n",
       "2613                                 20061979   \n",
       "2614                                 17071987   \n",
       "2615                                 10091989   \n",
       "2616                                 28111981   \n",
       "\n",
       "      ('S21.G00.30.020', 'Numéro technique temporaire')  \\\n",
       "0                                                   NaN   \n",
       "1                                                   NaN   \n",
       "2                                                   NaN   \n",
       "3                                                   NaN   \n",
       "4                                                   NaN   \n",
       "5                                                   NaN   \n",
       "6                                                   NaN   \n",
       "7                                                   NaN   \n",
       "8                                                   NaN   \n",
       "9                                                   NaN   \n",
       "10                                                  NaN   \n",
       "11                                                  NaN   \n",
       "12                                                  NaN   \n",
       "13                                                  NaN   \n",
       "14                                                  NaN   \n",
       "15                                                  NaN   \n",
       "16                                                  NaN   \n",
       "17                                                  NaN   \n",
       "18                                                  NaN   \n",
       "19                                                  NaN   \n",
       "20                                                  NaN   \n",
       "21                                                  NaN   \n",
       "22                                                  NaN   \n",
       "23                                                  NaN   \n",
       "24                                                  NaN   \n",
       "25                                                  NaN   \n",
       "26                                                  NaN   \n",
       "27                                                  NaN   \n",
       "28                                                  NaN   \n",
       "29                                                  NaN   \n",
       "...                                                 ...   \n",
       "2587                                                NaN   \n",
       "2588                                                NaN   \n",
       "2589                                                NaN   \n",
       "2590                                                NaN   \n",
       "2591                                                NaN   \n",
       "2592                                                NaN   \n",
       "2593                                                NaN   \n",
       "2594                                                NaN   \n",
       "2595                                                NaN   \n",
       "2596                                                NaN   \n",
       "2597                                                NaN   \n",
       "2598                                                NaN   \n",
       "2599                                                NaN   \n",
       "2600                                                NaN   \n",
       "2601                                                NaN   \n",
       "2602                                                NaN   \n",
       "2603                                                NaN   \n",
       "2604                                                NaN   \n",
       "2605                                                NaN   \n",
       "2606                                                NaN   \n",
       "2607                                                NaN   \n",
       "2608                                                NaN   \n",
       "2609                                                NaN   \n",
       "2610                                                NaN   \n",
       "2611                                                NaN   \n",
       "2612                                                NaN   \n",
       "2613                                                NaN   \n",
       "2614                                                NaN   \n",
       "2615                                                NaN   \n",
       "2616                                                NaN   \n",
       "\n",
       "      ('S21.G00.30.023', 'Embauche')  \\\n",
       "0                                  1   \n",
       "1                                  1   \n",
       "2                                  1   \n",
       "3                                  1   \n",
       "4                                  1   \n",
       "5                                  1   \n",
       "6                                  1   \n",
       "7                                  1   \n",
       "8                                  1   \n",
       "9                                  1   \n",
       "10                                 1   \n",
       "11                                 1   \n",
       "12                                 1   \n",
       "13                                 1   \n",
       "14                                 1   \n",
       "15                                 1   \n",
       "16                                 1   \n",
       "17                                 1   \n",
       "18                                 1   \n",
       "19                                 1   \n",
       "20                                 1   \n",
       "21                                 1   \n",
       "22                                 1   \n",
       "23                                 1   \n",
       "24                                 1   \n",
       "25                                 1   \n",
       "26                                 1   \n",
       "27                                 1   \n",
       "28                                 1   \n",
       "29                                 1   \n",
       "...                              ...   \n",
       "2587                               1   \n",
       "2588                               1   \n",
       "2589                               1   \n",
       "2590                               1   \n",
       "2591                               1   \n",
       "2592                               1   \n",
       "2593                               1   \n",
       "2594                               1   \n",
       "2595                               1   \n",
       "2596                               1   \n",
       "2597                               1   \n",
       "2598                               1   \n",
       "2599                               1   \n",
       "2600                               1   \n",
       "2601                               1   \n",
       "2602                               1   \n",
       "2603                               1   \n",
       "2604                               1   \n",
       "2605                               1   \n",
       "2606                               1   \n",
       "2607                               1   \n",
       "2608                               1   \n",
       "2609                               1   \n",
       "2610                               1   \n",
       "2611                               1   \n",
       "2612                               1   \n",
       "2613                               1   \n",
       "2614                               1   \n",
       "2615                               1   \n",
       "2616                               1   \n",
       "\n",
       "     ('S21.G00.40.001', 'Date de début du contrat')  \\\n",
       "0                                          20122015   \n",
       "1                                          29042018   \n",
       "2                                          01052018   \n",
       "3                                          01062018   \n",
       "4                                          01072018   \n",
       "5                                          01102014   \n",
       "6                                          01102014   \n",
       "7                                          01102014   \n",
       "8                                          01102014   \n",
       "9                                          01102014   \n",
       "10                                         01102014   \n",
       "11                                         01102014   \n",
       "12                                         01102014   \n",
       "13                                         01102014   \n",
       "14                                         01102014   \n",
       "15                                         01102014   \n",
       "16                                         01102014   \n",
       "17                                         01102014   \n",
       "18                                         01102014   \n",
       "19                                         01102014   \n",
       "20                                         01102014   \n",
       "21                                         01102014   \n",
       "22                                         01012015   \n",
       "23                                         01072015   \n",
       "24                                         01062017   \n",
       "25                                         21082017   \n",
       "26                                         02102017   \n",
       "27                                         01112017   \n",
       "28                                         14122017   \n",
       "29                                         01012018   \n",
       "...                                             ...   \n",
       "2587                                       16062015   \n",
       "2588                                       01072016   \n",
       "2589                                       01012017   \n",
       "2590                                       01072017   \n",
       "2591                                       01092017   \n",
       "2592                                       01092017   \n",
       "2593                                       01102017   \n",
       "2594                                       01012018   \n",
       "2595                                       01012018   \n",
       "2596                                       01012018   \n",
       "2597                                       21032018   \n",
       "2598                                       01062018   \n",
       "2599                                       01062018   \n",
       "2600                                       18062018   \n",
       "2601                                       06082018   \n",
       "2602                                       03092018   \n",
       "2603                                       01092018   \n",
       "2604                                       01092018   \n",
       "2605                                       01102014   \n",
       "2606                                       01102014   \n",
       "2607                                       16032015   \n",
       "2608                                       01102014   \n",
       "2609                                       01102014   \n",
       "2610                                       01102014   \n",
       "2611                                       01102014   \n",
       "2612                                       01102014   \n",
       "2613                                       01102014   \n",
       "2614                                       01102014   \n",
       "2615                                       01102014   \n",
       "2616                                       30072018   \n",
       "\n",
       "     ('S21.G00.40.002', 'Statut du salarié (conventionnel)')  \\\n",
       "0                                                    06        \n",
       "1                                                    06        \n",
       "2                                                    06        \n",
       "3                                                    06        \n",
       "4                                                    06        \n",
       "5                                                    06        \n",
       "6                                                    06        \n",
       "7                                                    06        \n",
       "8                                                    06        \n",
       "9                                                    04        \n",
       "10                                                   04        \n",
       "11                                                   06        \n",
       "12                                                   06        \n",
       "13                                                   06        \n",
       "14                                                   06        \n",
       "15                                                   06        \n",
       "16                                                   06        \n",
       "17                                                   06        \n",
       "18                                                   06        \n",
       "19                                                   06        \n",
       "20                                                   06        \n",
       "21                                                   06        \n",
       "22                                                   06        \n",
       "23                                                   06        \n",
       "24                                                   04        \n",
       "25                                                   06        \n",
       "26                                                   06        \n",
       "27                                                   06        \n",
       "28                                                   06        \n",
       "29                                                   06        \n",
       "...                                                 ...        \n",
       "2587                                                 06        \n",
       "2588                                                 06        \n",
       "2589                                                 06        \n",
       "2590                                                 06        \n",
       "2591                                                 06        \n",
       "2592                                                 06        \n",
       "2593                                                 06        \n",
       "2594                                                 06        \n",
       "2595                                                 06        \n",
       "2596                                                 06        \n",
       "2597                                                 06        \n",
       "2598                                                 06        \n",
       "2599                                                 06        \n",
       "2600                                                 06        \n",
       "2601                                                 06        \n",
       "2602                                                 06        \n",
       "2603                                                 06        \n",
       "2604                                                 06        \n",
       "2605                                                 04        \n",
       "2606                                                 06        \n",
       "2607                                                 06        \n",
       "2608                                                 06        \n",
       "2609                                                 06        \n",
       "2610                                                 06        \n",
       "2611                                                 06        \n",
       "2612                                                 06        \n",
       "2613                                                 06        \n",
       "2614                                                 06        \n",
       "2615                                                 06        \n",
       "2616                                                 06        \n",
       "\n",
       "     ('S21.G00.40.003', 'Code statut catégoriel Retraite Complémentaire obligatoire')  \\\n",
       "0                                                    04                                 \n",
       "1                                                    04                                 \n",
       "2                                                    04                                 \n",
       "3                                                    04                                 \n",
       "4                                                    04                                 \n",
       "5                                                    04                                 \n",
       "6                                                    04                                 \n",
       "7                                                    04                                 \n",
       "8                                                    04                                 \n",
       "9                                                    01                                 \n",
       "10                                                   01                                 \n",
       "11                                                   04                                 \n",
       "12                                                   04                                 \n",
       "13                                                   04                                 \n",
       "14                                                   04                                 \n",
       "15                                                   04                                 \n",
       "16                                                   04                                 \n",
       "17                                                   04                                 \n",
       "18                                                   04                                 \n",
       "19                                                   04                                 \n",
       "20                                                   04                                 \n",
       "21                                                   04                                 \n",
       "22                                                   04                                 \n",
       "23                                                   04                                 \n",
       "24                                                   01                                 \n",
       "25                                                   04                                 \n",
       "26                                                   04                                 \n",
       "27                                                   04                                 \n",
       "28                                                   04                                 \n",
       "29                                                   04                                 \n",
       "...                                                 ...                                 \n",
       "2587                                                 04                                 \n",
       "2588                                                 04                                 \n",
       "2589                                                 04                                 \n",
       "2590                                                 04                                 \n",
       "2591                                                 04                                 \n",
       "2592                                                 04                                 \n",
       "2593                                                 04                                 \n",
       "2594                                                 04                                 \n",
       "2595                                                 04                                 \n",
       "2596                                                 04                                 \n",
       "2597                                                 04                                 \n",
       "2598                                                 04                                 \n",
       "2599                                                 04                                 \n",
       "2600                                                 04                                 \n",
       "2601                                                 04                                 \n",
       "2602                                                 04                                 \n",
       "2603                                                 04                                 \n",
       "2604                                                 04                                 \n",
       "2605                                                 01                                 \n",
       "2606                                                 04                                 \n",
       "2607                                                 04                                 \n",
       "2608                                                 04                                 \n",
       "2609                                                 04                                 \n",
       "2610                                                 04                                 \n",
       "2611                                                 04                                 \n",
       "2612                                                 04                                 \n",
       "2613                                                 04                                 \n",
       "2614                                                 04                                 \n",
       "2615                                                 04                                 \n",
       "2616                                                 04                                 \n",
       "\n",
       "           ...         \\\n",
       "0          ...          \n",
       "1          ...          \n",
       "2          ...          \n",
       "3          ...          \n",
       "4          ...          \n",
       "5          ...          \n",
       "6          ...          \n",
       "7          ...          \n",
       "8          ...          \n",
       "9          ...          \n",
       "10         ...          \n",
       "11         ...          \n",
       "12         ...          \n",
       "13         ...          \n",
       "14         ...          \n",
       "15         ...          \n",
       "16         ...          \n",
       "17         ...          \n",
       "18         ...          \n",
       "19         ...          \n",
       "20         ...          \n",
       "21         ...          \n",
       "22         ...          \n",
       "23         ...          \n",
       "24         ...          \n",
       "25         ...          \n",
       "26         ...          \n",
       "27         ...          \n",
       "28         ...          \n",
       "29         ...          \n",
       "...        ...          \n",
       "2587       ...          \n",
       "2588       ...          \n",
       "2589       ...          \n",
       "2590       ...          \n",
       "2591       ...          \n",
       "2592       ...          \n",
       "2593       ...          \n",
       "2594       ...          \n",
       "2595       ...          \n",
       "2596       ...          \n",
       "2597       ...          \n",
       "2598       ...          \n",
       "2599       ...          \n",
       "2600       ...          \n",
       "2601       ...          \n",
       "2602       ...          \n",
       "2603       ...          \n",
       "2604       ...          \n",
       "2605       ...          \n",
       "2606       ...          \n",
       "2607       ...          \n",
       "2608       ...          \n",
       "2609       ...          \n",
       "2610       ...          \n",
       "2611       ...          \n",
       "2612       ...          \n",
       "2613       ...          \n",
       "2614       ...          \n",
       "2615       ...          \n",
       "2616       ...          \n",
       "\n",
       "     ('S21.G00.70.010', \"Nombre d'ayants-droit autres (ascendants, collatéraux...)\")  \\\n",
       "0                                            ['0', '0']                                \n",
       "1                                                     0                                \n",
       "2                                                     0                                \n",
       "3                                                     0                                \n",
       "4                                            ['0', '0']                                \n",
       "5                                            ['0', '0']                                \n",
       "6                                                     0                                \n",
       "7                                            ['0', '0']                                \n",
       "8                                            ['0', '0']                                \n",
       "9                                            ['0', '0']                                \n",
       "10                                           ['0', '0']                                \n",
       "11                                           ['0', '0']                                \n",
       "12                                           ['0', '0']                                \n",
       "13                                           ['0', '0']                                \n",
       "14                                           ['0', '0']                                \n",
       "15                                           ['0', '0']                                \n",
       "16                                                    0                                \n",
       "17                                           ['0', '0']                                \n",
       "18                                           ['0', '0']                                \n",
       "19                                           ['0', '0']                                \n",
       "20                                           ['0', '0']                                \n",
       "21                                           ['0', '0']                                \n",
       "22                                           ['0', '0']                                \n",
       "23                                                    0                                \n",
       "24                                           ['0', '0']                                \n",
       "25                                                    0                                \n",
       "26                                           ['0', '0']                                \n",
       "27                                                    0                                \n",
       "28                                           ['0', '0']                                \n",
       "29                                           ['0', '0']                                \n",
       "...                                                 ...                                \n",
       "2587                                         ['0', '0']                                \n",
       "2588                                         ['0', '0']                                \n",
       "2589                                         ['0', '0']                                \n",
       "2590                                         ['0', '0']                                \n",
       "2591                                         ['0', '0']                                \n",
       "2592                                         ['0', '0']                                \n",
       "2593                                         ['0', '0']                                \n",
       "2594                                                  0                                \n",
       "2595                                         ['0', '0']                                \n",
       "2596                                                  0                                \n",
       "2597                                                  0                                \n",
       "2598                                                  0                                \n",
       "2599                                                  0                                \n",
       "2600                                                  0                                \n",
       "2601                                                  0                                \n",
       "2602                                                  0                                \n",
       "2603                                                  0                                \n",
       "2604                                                  0                                \n",
       "2605                                         ['0', '0']                                \n",
       "2606                                                  0                                \n",
       "2607                                         ['0', '0']                                \n",
       "2608                                         ['0', '0']                                \n",
       "2609                                         ['0', '0']                                \n",
       "2610                                         ['0', '0']                                \n",
       "2611                                                  0                                \n",
       "2612                                         ['0', '0']                                \n",
       "2613                                         ['0', '0']                                \n",
       "2614                                         ['0', '0']                                \n",
       "2615                                         ['0', '0']                                \n",
       "2616                                                  0                                \n",
       "\n",
       "     ('S21.G00.70.011', \"Nombre d'enfants ayants-droit\")  \\\n",
       "0                                            ['0', '0']    \n",
       "1                                                     0    \n",
       "2                                                     0    \n",
       "3                                                     0    \n",
       "4                                            ['0', '0']    \n",
       "5                                            ['0', '0']    \n",
       "6                                                     0    \n",
       "7                                            ['0', '0']    \n",
       "8                                            ['0', '0']    \n",
       "9                                            ['0', '0']    \n",
       "10                                           ['0', '0']    \n",
       "11                                           ['0', '0']    \n",
       "12                                           ['0', '0']    \n",
       "13                                           ['0', '0']    \n",
       "14                                           ['0', '0']    \n",
       "15                                           ['0', '0']    \n",
       "16                                                    0    \n",
       "17                                           ['0', '0']    \n",
       "18                                           ['0', '0']    \n",
       "19                                           ['0', '0']    \n",
       "20                                           ['0', '0']    \n",
       "21                                           ['0', '0']    \n",
       "22                                           ['0', '0']    \n",
       "23                                                    0    \n",
       "24                                           ['0', '0']    \n",
       "25                                                    0    \n",
       "26                                           ['0', '0']    \n",
       "27                                                    0    \n",
       "28                                           ['0', '0']    \n",
       "29                                           ['0', '0']    \n",
       "...                                                 ...    \n",
       "2587                                         ['0', '0']    \n",
       "2588                                         ['0', '0']    \n",
       "2589                                         ['0', '0']    \n",
       "2590                                         ['0', '0']    \n",
       "2591                                         ['0', '0']    \n",
       "2592                                         ['0', '0']    \n",
       "2593                                         ['0', '0']    \n",
       "2594                                                  0    \n",
       "2595                                         ['0', '0']    \n",
       "2596                                                  0    \n",
       "2597                                                  0    \n",
       "2598                                                  0    \n",
       "2599                                                  0    \n",
       "2600                                                  0    \n",
       "2601                                                  0    \n",
       "2602                                                  0    \n",
       "2603                                                  0    \n",
       "2604                                                  0    \n",
       "2605                                         ['0', '0']    \n",
       "2606                                                  0    \n",
       "2607                                         ['0', '0']    \n",
       "2608                                         ['0', '0']    \n",
       "2609                                         ['0', '0']    \n",
       "2610                                         ['0', '0']    \n",
       "2611                                                  0    \n",
       "2612                                         ['0', '0']    \n",
       "2613                                         ['0', '0']    \n",
       "2614                                         ['0', '0']    \n",
       "2615                                         ['0', '0']    \n",
       "2616                                                  0    \n",
       "\n",
       "     ('S21.G00.70.012', 'Identifiant technique Affiliation')  \\\n",
       "0                                   3459048255974703064        \n",
       "1                                   3426801196285240187        \n",
       "2                                   3426801196285240187        \n",
       "3                                   3426801196285240187        \n",
       "4                                   3459048255974703064        \n",
       "5                                   3459048255974703064        \n",
       "6                                   3426801196285240187        \n",
       "7                                   3459048255974703064        \n",
       "8                                   3459048255974703064        \n",
       "9                                   3459048255974703064        \n",
       "10                                  3459048255974703064        \n",
       "11                                  3459048255974703064        \n",
       "12                                  3459048255974703064        \n",
       "13                                  3459048255974703064        \n",
       "14                                  3459048255974703064        \n",
       "15                                  3459048255974703064        \n",
       "16                                  3426801196285240187        \n",
       "17                                  3459048255974703064        \n",
       "18                                  3459048255974703064        \n",
       "19                                  3459048255974703064        \n",
       "20                                  3459048255974703064        \n",
       "21                                  3459048255974703064        \n",
       "22                                  3459048255974703064        \n",
       "23                                  3426801196285240187        \n",
       "24                                  3459048255974703064        \n",
       "25                                  3426801196285240187        \n",
       "26                                  3459048255974703064        \n",
       "27                                  3426801196285240187        \n",
       "28                                  3459048255974703064        \n",
       "29                                  3459048255974703064        \n",
       "...                                                 ...        \n",
       "2587                                3459048255974703064        \n",
       "2588                                3459048255974703064        \n",
       "2589                                3459048255974703064        \n",
       "2590                                3459048255974703064        \n",
       "2591                                3459048255974703064        \n",
       "2592                                3459048255974703064        \n",
       "2593                                3459048255974703064        \n",
       "2594                                3426801196285240187        \n",
       "2595                                3459048255974703064        \n",
       "2596                                3426801196285240187        \n",
       "2597                                3426801196285240187        \n",
       "2598                                3426801196285240187        \n",
       "2599                                3426801196285240187        \n",
       "2600                                3426801196285240187        \n",
       "2601                                3426801196285240187        \n",
       "2602                                3426801196285240187        \n",
       "2603                                3426801196285240187        \n",
       "2604                                3426801196285240187        \n",
       "2605                                3459048255974703064        \n",
       "2606                                3426801196285240187        \n",
       "2607                                3459048255974703064        \n",
       "2608                                3459048255974703064        \n",
       "2609                                3459048255974703064        \n",
       "2610                                3459048255974703064        \n",
       "2611                                3426801196285240187        \n",
       "2612                                3459048255974703064        \n",
       "2613                                3459048255974703064        \n",
       "2614                                3459048255974703064        \n",
       "2615                                3459048255974703064        \n",
       "2616                                3426801196285240187        \n",
       "\n",
       "     ('S21.G00.70.013', 'Identifiant technique Adhésion')  \\\n",
       "0                                   8151159325541050343     \n",
       "1                                    970579013592031102     \n",
       "2                                    970579013592031102     \n",
       "3                                    970579013592031102     \n",
       "4                                   8151159325541050343     \n",
       "5                                   8151159325541050343     \n",
       "6                                    970579013592031102     \n",
       "7                                   8151159325541050343     \n",
       "8                                   8151159325541050343     \n",
       "9                                   8151159325541050343     \n",
       "10                                  8151159325541050343     \n",
       "11                                  8151159325541050343     \n",
       "12                                  8151159325541050343     \n",
       "13                                  8151159325541050343     \n",
       "14                                  8151159325541050343     \n",
       "15                                  8151159325541050343     \n",
       "16                                   970579013592031102     \n",
       "17                                  8151159325541050343     \n",
       "18                                  8151159325541050343     \n",
       "19                                  8151159325541050343     \n",
       "20                                  8151159325541050343     \n",
       "21                                  8151159325541050343     \n",
       "22                                  8151159325541050343     \n",
       "23                                   970579013592031102     \n",
       "24                                  8151159325541050343     \n",
       "25                                   970579013592031102     \n",
       "26                                  8151159325541050343     \n",
       "27                                   970579013592031102     \n",
       "28                                  8151159325541050343     \n",
       "29                                  3459048255974703064     \n",
       "...                                                 ...     \n",
       "2587                                8151159325541050343     \n",
       "2588                                8151159325541050343     \n",
       "2589                                8151159325541050343     \n",
       "2590                                8151159325541050343     \n",
       "2591                                8151159325541050343     \n",
       "2592                                8151159325541050343     \n",
       "2593                                3459048255974703064     \n",
       "2594                                 970579013592031102     \n",
       "2595                                8151159325541050343     \n",
       "2596                                 970579013592031102     \n",
       "2597                                 970579013592031102     \n",
       "2598                                 970579013592031102     \n",
       "2599                                 970579013592031102     \n",
       "2600                                 970579013592031102     \n",
       "2601                                 970579013592031102     \n",
       "2602                                 970579013592031102     \n",
       "2603                                 970579013592031102     \n",
       "2604                                 970579013592031102     \n",
       "2605                                8151159325541050343     \n",
       "2606                                 970579013592031102     \n",
       "2607                                8151159325541050343     \n",
       "2608                                8151159325541050343     \n",
       "2609                                8151159325541050343     \n",
       "2610                                8151159325541050343     \n",
       "2611                                 970579013592031102     \n",
       "2612                                8151159325541050343     \n",
       "2613                                8151159325541050343     \n",
       "2614                                8151159325541050343     \n",
       "2615                                8151159325541050343     \n",
       "2616                                 970579013592031102     \n",
       "\n",
       "      ('S21.G00.70.014', nan) ('S21.G00.86.001', 'Type')  \\\n",
       "0                         NaN                         01   \n",
       "1                         NaN                         01   \n",
       "2                         NaN                         01   \n",
       "3                         NaN                         01   \n",
       "4                    01092018                         01   \n",
       "5                         NaN                         01   \n",
       "6                         NaN                         01   \n",
       "7                         NaN                         01   \n",
       "8                         NaN                         01   \n",
       "9                         NaN                         01   \n",
       "10                        NaN                         01   \n",
       "11                        NaN                         01   \n",
       "12                        NaN                         01   \n",
       "13                        NaN                         01   \n",
       "14                        NaN                         01   \n",
       "15                        NaN                         01   \n",
       "16                        NaN                         01   \n",
       "17                        NaN                         01   \n",
       "18                        NaN                         01   \n",
       "19                        NaN                         01   \n",
       "20                        NaN                         01   \n",
       "21                        NaN                         01   \n",
       "22                        NaN                         01   \n",
       "23                        NaN                         01   \n",
       "24                        NaN                         01   \n",
       "25                        NaN                         01   \n",
       "26                        NaN                         01   \n",
       "27                        NaN                         01   \n",
       "28                        NaN                         01   \n",
       "29                        NaN                         01   \n",
       "...                       ...                        ...   \n",
       "2587                      NaN                         01   \n",
       "2588                      NaN                         01   \n",
       "2589                      NaN                         01   \n",
       "2590                      NaN                         01   \n",
       "2591                      NaN                         01   \n",
       "2592                      NaN                         01   \n",
       "2593                      NaN                         01   \n",
       "2594                      NaN                         01   \n",
       "2595                      NaN                         01   \n",
       "2596                      NaN                         01   \n",
       "2597                      NaN                         01   \n",
       "2598                      NaN                         01   \n",
       "2599                      NaN                         01   \n",
       "2600                      NaN                         01   \n",
       "2601                      NaN                         01   \n",
       "2602                      NaN                         01   \n",
       "2603                      NaN                         01   \n",
       "2604                      NaN                         01   \n",
       "2605                      NaN                         01   \n",
       "2606                      NaN                         01   \n",
       "2607                      NaN                         01   \n",
       "2608                      NaN                         01   \n",
       "2609                      NaN                         01   \n",
       "2610                      NaN                         01   \n",
       "2611                      NaN                         01   \n",
       "2612                      NaN                         01   \n",
       "2613                      NaN                         01   \n",
       "2614                      NaN                         01   \n",
       "2615                      NaN                         01   \n",
       "2616                      NaN                         01   \n",
       "\n",
       "     ('S21.G00.86.002', 'Unité de mesure') ('S21.G00.86.003', 'Valeur')  \\\n",
       "0                                       01                         1016   \n",
       "1                                       01                          956   \n",
       "2                                       01                          189   \n",
       "3                                       01                          164   \n",
       "4                                       01                          207   \n",
       "5                                       01                        10925   \n",
       "6                                       01                         8491   \n",
       "7                                       01                         9324   \n",
       "8                                       01                        10410   \n",
       "9                                       01                         8628   \n",
       "10                                      01                        11270   \n",
       "11                                      01                         7153   \n",
       "12                                      01                         6426   \n",
       "13                                      01                         6559   \n",
       "14                                      01                         4945   \n",
       "15                                      01                         4703   \n",
       "16                                      01                         4279   \n",
       "17                                      01                         4067   \n",
       "18                                      01                         3457   \n",
       "19                                      01                         3206   \n",
       "20                                      01                         2496   \n",
       "21                                      01                         1630   \n",
       "22                                      01                         1432   \n",
       "23                                      01                         1269   \n",
       "24                                      01                         8960   \n",
       "25                                      01                         1090   \n",
       "26                                      01                          364   \n",
       "27                                      01                          910   \n",
       "28                                      01                          291   \n",
       "29                                      01                          287   \n",
       "...                                    ...                          ...   \n",
       "2587                                    01                         1260   \n",
       "2588                                    01                          905   \n",
       "2589                                    01                          833   \n",
       "2590                                    01                          607   \n",
       "2591                                    01                          544   \n",
       "2592                                    01                         1183   \n",
       "2593                                    01                          574   \n",
       "2594                                    01                          371   \n",
       "2595                                    01                          374   \n",
       "2596                                    01                          350   \n",
       "2597                                    01                          194   \n",
       "2598                                    01                          203   \n",
       "2599                                    01                          199   \n",
       "2600                                    01                          147   \n",
       "2601                                    01                           56   \n",
       "2602                                    01                           28   \n",
       "2603                                    01                           30   \n",
       "2604                                    01                           30   \n",
       "2605                                    01                         6076   \n",
       "2606                                    01                        10080   \n",
       "2607                                    01                         4029   \n",
       "2608                                    01                        10104   \n",
       "2609                                    01                         5334   \n",
       "2610                                    01                         5479   \n",
       "2611                                    01                         9016   \n",
       "2612                                    01                         4347   \n",
       "2613                                    01                         4039   \n",
       "2614                                    01                         3157   \n",
       "2615                                    01                         2973   \n",
       "2616                                    01                           63   \n",
       "\n",
       "     ('S21.G00.86.005', 'Numéro du contrat') Unnamed: 0.1.1.1  \n",
       "0                         818804314150338465                0  \n",
       "1                        5062950368187149217                1  \n",
       "2                        6538046486002635820                2  \n",
       "3                        6274365465970049139                3  \n",
       "4                        2177083209391047952                4  \n",
       "5                        1813037183403608302                5  \n",
       "6                        3652708417458515775                6  \n",
       "7                        2850529884753525020                7  \n",
       "8                         167823990482649395                8  \n",
       "9                         694421425782240772                9  \n",
       "10                       7159113741589673965               10  \n",
       "11                       2727216476858878079               11  \n",
       "12                       5265255753580133596               12  \n",
       "13                       3349437125772570619               13  \n",
       "14                       1180135311347997151               14  \n",
       "15                       3420812909788976964               15  \n",
       "16                       9162660237646300115               16  \n",
       "17                       4885954375751391374               17  \n",
       "18                       4288287697472645046               18  \n",
       "19                       6570170158378405001               19  \n",
       "20                        425650408013017981               20  \n",
       "21                       3143312799405920287               21  \n",
       "22                       1469883324021351994               22  \n",
       "23                       7837756792996550705               23  \n",
       "24                       2149108281688600381               24  \n",
       "25                       8799307255273835075               25  \n",
       "26                       7000840322664899104               26  \n",
       "27                       2384688779049884557               27  \n",
       "28                       7870577635990534373               28  \n",
       "29                        881314362425168731               29  \n",
       "...                                      ...              ...  \n",
       "2587                     4834120171048102958             2587  \n",
       "2588                      683828758928152661             2588  \n",
       "2589                     7221255194562272665             2589  \n",
       "2590                     3698917690617163002             2590  \n",
       "2591                     4249409429706839134             2591  \n",
       "2592                     5620218769796984271             2592  \n",
       "2593                     8839660826908513977             2593  \n",
       "2594                     3997822093275412105             2594  \n",
       "2595                     1901639391550104623             2595  \n",
       "2596                     9150234965342168853             2596  \n",
       "2597                     7949664969466976486             2597  \n",
       "2598                     8619966990251332608             2598  \n",
       "2599                     4973604679353592430             2599  \n",
       "2600                     3215681245706328957             2600  \n",
       "2601                     1476482701907964752             2601  \n",
       "2602                     2723253731195137972             2602  \n",
       "2603                      787867068654832392             2603  \n",
       "2604                      975458426065869036             2604  \n",
       "2605                     3104144261411391019             2605  \n",
       "2606                     1675624590658596295             2606  \n",
       "2607                     6870212934181519876             2607  \n",
       "2608                     6726960970436385335             2608  \n",
       "2609                     7293694087988396906             2609  \n",
       "2610                     6581531391815583762             2610  \n",
       "2611                     7899380811344089746             2611  \n",
       "2612                     1979743340121760892             2612  \n",
       "2613                     1767314840430178948             2613  \n",
       "2614                      121345335568216352             2614  \n",
       "2615                     6330781511945007660             2615  \n",
       "2616                     3549699751783595424             2616  \n",
       "\n",
       "[2617 rows x 88 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "import datetime as dt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2018-06-03 00:00:00\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "datetime.datetime"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "jour = \"362018\"\n",
    "#if len(jour)<8:\n",
    "    \n",
    "jour =dt.datetime.strptime(jour, \"%d%m%Y\")\n",
    "print(jour)\n",
    "type(jour)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "int"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(date)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'3021998'"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "date"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "ename": "ValueError",
     "evalue": "day is out of range for month",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mValueError\u001b[0m                                Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-38-e86fca8e23ea>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mdt\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mdatetime\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mstrptime\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mdate\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\"%d%m%Y\"\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[0;32m~/anaconda3/lib/python3.6/_strptime.py\u001b[0m in \u001b[0;36m_strptime_datetime\u001b[0;34m(cls, data_string, format)\u001b[0m\n\u001b[1;32m    563\u001b[0m     \"\"\"Return a class cls instance based on the input string and the\n\u001b[1;32m    564\u001b[0m     format string.\"\"\"\n\u001b[0;32m--> 565\u001b[0;31m     \u001b[0mtt\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mfraction\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0m_strptime\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mdata_string\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mformat\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    566\u001b[0m     \u001b[0mtzname\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mgmtoff\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mtt\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m-\u001b[0m\u001b[0;36m2\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    567\u001b[0m     \u001b[0margs\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mtt\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;36m6\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m+\u001b[0m \u001b[0;34m(\u001b[0m\u001b[0mfraction\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/anaconda3/lib/python3.6/_strptime.py\u001b[0m in \u001b[0;36m_strptime\u001b[0;34m(data_string, format)\u001b[0m\n\u001b[1;32m    526\u001b[0m         \u001b[0;31m# Need to add 1 to result since first day of the year is 1, not 0.\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    527\u001b[0m         \u001b[0mjulian\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mdatetime_date\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0myear\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mmonth\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mday\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mtoordinal\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;34m-\u001b[0m\u001b[0;31m \u001b[0m\u001b[0;31m\\\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 528\u001b[0;31m                   \u001b[0mdatetime_date\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0myear\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;36m1\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;36m1\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mtoordinal\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;34m+\u001b[0m \u001b[0;36m1\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    529\u001b[0m     \u001b[0;32melse\u001b[0m\u001b[0;34m:\u001b[0m  \u001b[0;31m# Assume that if they bothered to include Julian day (or if it was\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    530\u001b[0m            \u001b[0;31m# calculated above with year/week/weekday) it will be accurate.\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mValueError\u001b[0m: day is out of range for month"
     ]
    }
   ],
   "source": [
    "dt.datetime.strptime(date,\"%d%m%Y\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [],
   "source": [
    "tmp = []\n",
    "col_voulue = \"('S21.G00.30.006', 'Date de naissance')\"\n",
    "for date in df[col_voulue] :\n",
    "    date =str(date)\n",
    "    if len(date)<8: date = \"0\"+date\n",
    "        \n",
    "    jour_naissance = dt.datetime.strptime(date,\"%d%m%Y\")\n",
    "    nb_jour        = jour-jour_naissance\n",
    "    nb_annee       = nb_jour.days/365\n",
    "    to_save        = round(nb_annee)\n",
    "    tmp.append(to_save)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0       21\n",
       "1       27\n",
       "2       44\n",
       "3       24\n",
       "4       32\n",
       "5       54\n",
       "6       46\n",
       "7       49\n",
       "8       47\n",
       "9       46\n",
       "10      55\n",
       "11      45\n",
       "12      41\n",
       "13      39\n",
       "14      34\n",
       "15      34\n",
       "16      52\n",
       "17      37\n",
       "18      32\n",
       "19      37\n",
       "20      34\n",
       "21      29\n",
       "22      28\n",
       "23      34\n",
       "24      48\n",
       "25      29\n",
       "26      22\n",
       "27      24\n",
       "28      27\n",
       "29      24\n",
       "        ..\n",
       "2587    38\n",
       "2588    31\n",
       "2589    30\n",
       "2590    34\n",
       "2591    22\n",
       "2592    34\n",
       "2593    24\n",
       "2594    23\n",
       "2595    25\n",
       "2596    23\n",
       "2597    23\n",
       "2598    35\n",
       "2599    22\n",
       "2600    26\n",
       "2601    21\n",
       "2602    19\n",
       "2603    23\n",
       "2604    29\n",
       "2605    48\n",
       "2606    54\n",
       "2607    32\n",
       "2608    61\n",
       "2609    35\n",
       "2610    39\n",
       "2611    53\n",
       "2612    33\n",
       "2613    39\n",
       "2614    31\n",
       "2615    29\n",
       "2616    37\n",
       "Name: ('S21.G00.30.006', 'Date de naissance'), Length: 2617, dtype: int64"
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[col_voulue].map(lambda x: \"0%s\"%x if len(str(x))<8 else str(x) )\\\n",
    "                .map(lambda x: round((jour-dt.datetime.strptime(x,\"%d%m%Y\")).days/365))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "metadata": {},
   "outputs": [],
   "source": [
    "class color:\n",
    "   PURPLE = '\\033[95m'\n",
    "   CYAN = '\\033[96m'\n",
    "   DARKCYAN = '\\033[36m'\n",
    "   BLUE = '\\033[94m'\n",
    "   GREEN = '\\033[92m'\n",
    "   YELLOW = '\\033[93m'\n",
    "   RED = '\\033[91m'\n",
    "   BOLD = '\\033[1m'\n",
    "   UNDERLINE = '\\033[4m'\n",
    "   END = '\\033[0m'\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "metadata": {},
   "outputs": [],
   "source": [
    "def red(v):\n",
    "    return color.RED + str(v)+color.END\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "metadata": {},
   "outputs": [],
   "source": [
    "def bold(v):\n",
    "    return color.BOLD + str(v)+color.END\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Unnamed: 0 \u001b[1m\u001b[91m900\u001b[0m\u001b[0m\n",
      "Unnamed: 0.1 \u001b[1m\u001b[91m900\u001b[0m\u001b[0m\n",
      "Unnamed: 0.1.1 \u001b[1m\u001b[91m900\u001b[0m\u001b[0m\n",
      "('S21.G00.30.005', 'Sexe') \u001b[1m\u001b[91m2\u001b[0m\u001b[0m\n",
      "('S21.G00.30.006', 'Date de naissance') \u001b[1m\u001b[91m30031981\u001b[0m\u001b[0m\n",
      "('S21.G00.30.020', 'Numéro technique temporaire') \u001b[1m\u001b[91mnan\u001b[0m\u001b[0m\n",
      "('S21.G00.30.023', 'Embauche') \u001b[1m\u001b[91m1\u001b[0m\u001b[0m\n",
      "('S21.G00.40.001', 'Date de début du contrat') \u001b[1m\u001b[91m01102014\u001b[0m\u001b[0m\n",
      "('S21.G00.40.002', 'Statut du salarié (conventionnel)') \u001b[1m\u001b[91m06\u001b[0m\u001b[0m\n",
      "('S21.G00.40.003', 'Code statut catégoriel Retraite Complémentaire obligatoire') \u001b[1m\u001b[91m04\u001b[0m\u001b[0m\n",
      "('S21.G00.40.004', 'Code profession et catégorie socioprofessionnelle (PCS-ESE)') \u001b[1m\u001b[91m554D\u001b[0m\u001b[0m\n",
      "('S21.G00.40.006', \"Libellé de l'emploi\") \u001b[1m\u001b[91mVENDEUR CONFIRME\u001b[0m\u001b[0m\n",
      "('S21.G00.40.007', 'Nature du contrat') \u001b[1m\u001b[91m01\u001b[0m\u001b[0m\n",
      "('S21.G00.40.008', 'Dispositif de politique publique et conventionnel') \u001b[1m\u001b[91m99\u001b[0m\u001b[0m\n",
      "('S21.G00.40.009', 'Numéro du contrat') \u001b[1m\u001b[91m2666195618813151565\u001b[0m\u001b[0m\n",
      "('S21.G00.40.010', 'Date de fin prévisionnelle du contrat') \u001b[1m\u001b[91mnan\u001b[0m\u001b[0m\n",
      "('S21.G00.40.011', 'Unité de mesure de la quotité de travail') \u001b[1m\u001b[91m10\u001b[0m\u001b[0m\n",
      "('S21.G00.40.012', \"Quotité de travail de référence de l'entreprise pour la catégorie de salarié\") \u001b[1m\u001b[91m151.67\u001b[0m\u001b[0m\n",
      "('S21.G00.40.013', 'Quotité de travail du contrat') \u001b[1m\u001b[91m130.00\u001b[0m\u001b[0m\n",
      "('S21.G00.40.014', \"Modalité d'exercice du temps de travail\") \u001b[1m\u001b[91m20\u001b[0m\u001b[0m\n",
      "('S21.G00.40.016', 'Complément de base au régime obligatoire') \u001b[1m\u001b[91m99\u001b[0m\u001b[0m\n",
      "('S21.G00.40.017', 'Code convention collective applicable') \u001b[1m\u001b[91m1760\u001b[0m\u001b[0m\n",
      "('S21.G00.40.018', 'Code régime de base risque maladie') \u001b[1m\u001b[91m200\u001b[0m\u001b[0m\n",
      "('S21.G00.40.019', 'Identifiant du lieu de travail') \u001b[1m\u001b[91m3352906852056101976\u001b[0m\u001b[0m\n",
      "('S21.G00.40.020', 'Code régime de base risque vieillesse') \u001b[1m\u001b[91m200\u001b[0m\u001b[0m\n",
      "('S21.G00.40.021', 'Motif de recours') \u001b[1m\u001b[91mnan\u001b[0m\u001b[0m\n",
      "('S21.G00.40.024', \"Travailleur à l'étranger au sens du code de la Sécurité Sociale\") \u001b[1m\u001b[91m99\u001b[0m\u001b[0m\n",
      "('S21.G00.40.026', \"Statut d'emploi du salarié\") \u001b[1m\u001b[91m99\u001b[0m\u001b[0m\n",
      "('S21.G00.40.036', 'Code emplois multiples') \u001b[1m\u001b[91m01\u001b[0m\u001b[0m\n",
      "('S21.G00.40.037', 'Code employeurs multiples') \u001b[1m\u001b[91m01\u001b[0m\u001b[0m\n",
      "('S21.G00.40.039', 'Code régime de base risque accident du travail') \u001b[1m\u001b[91m200\u001b[0m\u001b[0m\n",
      "('S21.G00.40.040', 'Code risque accident du travail') \u001b[1m\u001b[91m524XB\u001b[0m\u001b[0m\n",
      "('S21.G00.40.041', 'Positionnement dans la convention collective') \u001b[1m\u001b[91mEMPLOYE/TECHNICIEN      COEFFICIENT 00180,00\u001b[0m\u001b[0m\n",
      "('S21.G00.40.043', 'Taux de cotisation accident du travail') \u001b[1m\u001b[91m1.11\u001b[0m\u001b[0m\n",
      "('S21.G00.41.001', 'Date de la modification') \u001b[1m\u001b[91m['01092018', '01092018', '01092018']\u001b[0m\u001b[0m\n",
      "('S21.G00.41.003', 'Ancien Code statut catégoriel Retraite Complémentaire obligatoire') \u001b[1m\u001b[91mnan\u001b[0m\u001b[0m\n",
      "('S21.G00.41.007', 'Ancienne Quotité de travail du contrat') \u001b[1m\u001b[91m162.5\u001b[0m\u001b[0m\n",
      "('S21.G00.41.008', \"Ancienne Modalité d'exercice du temps de travail\") \u001b[1m\u001b[91m10.0\u001b[0m\u001b[0m\n",
      "('S21.G00.41.012', \"SIRET ancien établissement d'affectation\") \u001b[1m\u001b[91m0\u001b[0m\u001b[0m\n",
      "('S21.G00.41.019', 'Ancien Code profession et catégorie socioprofessionnelle (PCS-ESE) ') \u001b[1m\u001b[91mnan\u001b[0m\u001b[0m\n",
      "('S21.G00.41.022', \"Ancienne Quotité de travail de référence de l'entreprise pour la catégorie de salarié\") \u001b[1m\u001b[91m162.5\u001b[0m\u001b[0m\n",
      "('S21.G00.50.001', 'Date de versement') \u001b[1m\u001b[91m30092018\u001b[0m\u001b[0m\n",
      "('S21.G00.50.002', 'Rémunération nette fiscale') \u001b[1m\u001b[91m1170.45\u001b[0m\u001b[0m\n",
      "('S21.G00.50.003', 'Numéro de versement') \u001b[1m\u001b[91m01\u001b[0m\u001b[0m\n",
      "('S21.G00.50.004', 'Montant net versé') \u001b[1m\u001b[91m1064.19\u001b[0m\u001b[0m\n",
      "('S21.G00.51.001', 'Date de début de période de paie') \u001b[1m\u001b[91m['01092018', '01092018', '01092018', '01092018']\u001b[0m\u001b[0m\n",
      "('S21.G00.51.002', 'Date de fin de période de paie') \u001b[1m\u001b[91m['30092018', '30092018', '30092018', '30092018']\u001b[0m\u001b[0m\n",
      "('S21.G00.51.010', 'Numéro du contrat') \u001b[1m\u001b[91m741541862478714049\u001b[0m\u001b[0m\n",
      "('S21.G00.51.011', 'Type') \u001b[1m\u001b[91m['001', '002', '003', '010']\u001b[0m\u001b[0m\n",
      "('S21.G00.51.012', \"Nombre d'heures\") \u001b[1m\u001b[91mnan\u001b[0m\u001b[0m\n",
      "('S21.G00.51.013', 'Montant') \u001b[1m\u001b[91m['1428.57', '1428.57', '1428.57', '1319.46']\u001b[0m\u001b[0m\n",
      "('S21.G00.52.001', 'Type') \u001b[1m\u001b[91mnan\u001b[0m\u001b[0m\n",
      "('S21.G00.52.002', 'Montant') \u001b[1m\u001b[91mnan\u001b[0m\u001b[0m\n",
      "('S21.G00.52.003', 'Date de début de la période de rattachement') \u001b[1m\u001b[91mnan\u001b[0m\u001b[0m\n",
      "('S21.G00.52.004', 'Date de fin de la période de rattachement') \u001b[1m\u001b[91mnan\u001b[0m\u001b[0m\n",
      "('S21.G00.53.001', 'Type') \u001b[1m\u001b[91m['01', '01', '01', '01']\u001b[0m\u001b[0m\n",
      "('S21.G00.53.002', 'Mesure') \u001b[1m\u001b[91m['130.00', '130.00', '130.00', '130.00']\u001b[0m\u001b[0m\n",
      "('S21.G00.53.003', 'Unité de mesure') \u001b[1m\u001b[91m['10', '10', '10', '10']\u001b[0m\u001b[0m\n",
      "('S21.G00.54.001', 'Type') \u001b[1m\u001b[91mnan\u001b[0m\u001b[0m\n",
      "('S21.G00.54.002', 'Montant') \u001b[1m\u001b[91mnan\u001b[0m\u001b[0m\n",
      "('S21.G00.54.003', 'Date de début de période de rattachement') \u001b[1m\u001b[91mnan\u001b[0m\u001b[0m\n",
      "('S21.G00.54.004', 'Date de fin de période de rattachement') \u001b[1m\u001b[91mnan\u001b[0m\u001b[0m\n",
      "('S21.G00.60.001', \"Motif de l'arrêt\") \u001b[1m\u001b[91m02\u001b[0m\u001b[0m\n",
      "('S21.G00.60.002', 'Date du dernier jour travaillé') \u001b[1m\u001b[91m20012017\u001b[0m\u001b[0m\n",
      "('S21.G00.60.003', 'Date de fin prévisionnelle') \u001b[1m\u001b[91m31072017\u001b[0m\u001b[0m\n",
      "('S21.G00.60.010', 'Date de la reprise') \u001b[1m\u001b[91mnan\u001b[0m\u001b[0m\n",
      "('S21.G00.60.011', 'Motif de la reprise') \u001b[1m\u001b[91mnan\u001b[0m\u001b[0m\n",
      "('S21.G00.62.001', 'Date de fin du contrat') \u001b[1m\u001b[91mnan\u001b[0m\u001b[0m\n",
      "('S21.G00.62.002', 'Motif de la rupture du contrat') \u001b[1m\u001b[91mnan\u001b[0m\u001b[0m\n",
      "('S21.G00.62.006', 'Dernier jour travaillé et payé au salaire habituel') \u001b[1m\u001b[91mnan\u001b[0m\u001b[0m\n",
      "('S21.G00.65.001', 'Motif de suspension') \u001b[1m\u001b[91mnan\u001b[0m\u001b[0m\n",
      "('S21.G00.65.002', 'Date de début de la suspension') \u001b[1m\u001b[91mnan\u001b[0m\u001b[0m\n",
      "('S21.G00.65.003', 'Date de fin de la suspension') \u001b[1m\u001b[91mnan\u001b[0m\u001b[0m\n",
      "('S21.G00.70.004', 'Code option retenue par le salarié') \u001b[1m\u001b[91m['P00006497101', 'P00004844901']\u001b[0m\u001b[0m\n",
      "('S21.G00.70.005', 'Code population de rattachement') \u001b[1m\u001b[91m['001200', '060200']\u001b[0m\u001b[0m\n",
      "('S21.G00.70.007', \"Nombre d'enfants à charge\") \u001b[1m\u001b[91m['0', '0']\u001b[0m\u001b[0m\n",
      "('S21.G00.70.008', \"Nombre d'adultes ayants-droit (conjoint, concubin, ...) \") \u001b[1m\u001b[91m['0', '0']\u001b[0m\u001b[0m\n",
      "('S21.G00.70.009', \"Nombre d'ayants-droit\") \u001b[1m\u001b[91m['0', '0']\u001b[0m\u001b[0m\n",
      "('S21.G00.70.010', \"Nombre d'ayants-droit autres (ascendants, collatéraux...)\") \u001b[1m\u001b[91m['0', '0']\u001b[0m\u001b[0m\n",
      "('S21.G00.70.011', \"Nombre d'enfants ayants-droit\") \u001b[1m\u001b[91m['0', '0']\u001b[0m\u001b[0m\n",
      "('S21.G00.70.012', 'Identifiant technique Affiliation') \u001b[1m\u001b[91m3459048255974703064\u001b[0m\u001b[0m\n",
      "('S21.G00.70.013', 'Identifiant technique Adhésion') \u001b[1m\u001b[91m8151159325541050343\u001b[0m\u001b[0m\n",
      "('S21.G00.70.014', nan) \u001b[1m\u001b[91mnan\u001b[0m\u001b[0m\n",
      "('S21.G00.86.001', 'Type') \u001b[1m\u001b[91m01\u001b[0m\u001b[0m\n",
      "('S21.G00.86.002', 'Unité de mesure') \u001b[1m\u001b[91m01\u001b[0m\u001b[0m\n",
      "('S21.G00.86.003', 'Valeur') \u001b[1m\u001b[91m5936\u001b[0m\u001b[0m\n",
      "('S21.G00.86.005', 'Numéro du contrat') \u001b[1m\u001b[91m2666195618813151565\u001b[0m\u001b[0m\n",
      "Unnamed: 0.1.1.1 \u001b[1m\u001b[91m900\u001b[0m\u001b[0m\n",
      "age \u001b[1m\u001b[91m37\u001b[0m\u001b[0m\n"
     ]
    }
   ],
   "source": [
    "une_ligne = df.sample()\n",
    "for col in df.columns:\n",
    "    print (col, bold(red(une_ligne[col].values[0])))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Se limiter à un block de data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "metadata": {},
   "outputs": [],
   "source": [
    "block = \"('S21.G00.51.\"\n",
    "subset_col  = list(filter(lambda x: x.startswith(block), df.columns))\n",
    "df_block_51 = df[subset_col]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 95,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "\"('S21.G00.51.001', 'Date de début de période de paie')\""
      ]
     },
     "execution_count": 95,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "colonne_voulue = subset_col[0]\n",
    "colonne_voulue"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 101,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(str, \"['01092018', '01092018', '01092018', '01092018']\", list)"
      ]
     },
     "execution_count": 101,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "v = df_block_51[colonne_voulue].values[0]\n",
    "type(v), v, type(eval(v))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 115,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[\"('S21.G00.51.001', 'Date de début de période de paie')\",\n",
       " \"('S21.G00.51.002', 'Date de fin de période de paie')\",\n",
       " \"('S21.G00.51.011', 'Type')\",\n",
       " \"('S21.G00.51.013', 'Montant')\"]"
      ]
     },
     "execution_count": 115,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "voulus = [0,1,3,5]\n",
    "subsubset = [subset_col[v] for v in voulus]\n",
    "subsubset\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 119,
   "metadata": {},
   "outputs": [],
   "source": [
    "sub_df = df_block_51[subsubset]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Vérification que les longueurs sont les mêmes dans tous les tableaux"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 121,
   "metadata": {},
   "outputs": [],
   "source": [
    "longueurs = sub_df.applymap(eval).applymap(len)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 131,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 131,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sum([serie.nunique()!=1 for index, serie in longueurs.iterrows()])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Déplier les tableaux"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 135,
   "metadata": {},
   "outputs": [],
   "source": [
    "codes = {\n",
    "\"001\": \"Rémunération brute non plafonnée\",\n",
    "\"002\": \"Salaire brut soumis à contributions d'Assurance chômage\",\n",
    "\"003\": \"Salaire rétabli – reconstitué\",\n",
    "\"010\": \"Salaire de base\",\n",
    "\"011\": \"Heures supplémentaires ou complémentaires\",\n",
    "\"012\": \"Heures d’équivalence\",\n",
    "\"013\": \"Heures d’habillage, déshabillage, pause\",\n",
    "\"014\": \"Heures correspondant à du chômage sans rupture de contrat ou du chômage intempéries\",\n",
    "\"015\": \"Salaire moyen BTP\",}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 142,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "16"
      ]
     },
     "execution_count": 142,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sub_df[sub_df.columns[2]].map(eval).map(len).max()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 151,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "('S21.G00.51.001', 'Date de début de période de paie')\n",
      "\u001b[1m[\"['01082018', '01082018', '01082018', '01082018', '01092018', '01092018', '01092018', '01092018', '17092018', '17092018', '17092018', '17092018', '24092018', '24092018', '24092018', '24092018']\"]\u001b[0m\n",
      "('S21.G00.51.002', 'Date de fin de période de paie')\n",
      "\u001b[1m[\"['31082018', '31082018', '31082018', '31082018', '16092018', '16092018', '16092018', '16092018', '23092018', '23092018', '23092018', '23092018', '30092018', '30092018', '30092018', '30092018']\"]\u001b[0m\n",
      "('S21.G00.51.011', 'Type')\n",
      "\u001b[1m[\"['001', '002', '003', '010', '001', '002', '003', '010', '001', '002', '003', '010', '003', '010', '002', '001']\"]\u001b[0m\n",
      "('S21.G00.51.013', 'Montant')\n",
      "\u001b[1m[\"['0.00', '0.00', '0.00', '0.00', '909.88', '909.88', '1569.25', '1500.02', '321.43', '321.43', '1500.02', '1500.02', '1500.02', '1500.02', '337.94', '337.94']\"]\u001b[0m\n"
     ]
    }
   ],
   "source": [
    "mask = sub_df[sub_df.columns[2]].map(eval).map(len)==16\n",
    "for i in sub_df[mask]:\n",
    "    serie = sub_df[mask][i]\n",
    "    print(i)\n",
    "    print (bold(serie.values))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 158,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(\"['01092018', '01092018', '01092018', '01092018']\",\n",
       " \"['30092018', '30092018', '30092018', '30092018']\",\n",
       " \"['001', '002', '003', '010']\",\n",
       " \"['1147.39', '1147.39', '1147.39', '1028.56']\")"
      ]
     },
     "execution_count": 158,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dates_de_debut, dates_de_fin, types, montants"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 169,
   "metadata": {},
   "outputs": [],
   "source": [
    "a_ajouter = []\n",
    "for serie in sub_df.iterrows():\n",
    "    values = serie[1].values\n",
    "    dates_de_debut = eval(values[0])\n",
    "    dates_de_fin = eval(values[1])\n",
    "    types = eval(values[2])\n",
    "    montants = eval(values[3])\n",
    "    new_cols = []\n",
    "    for i in range(len(dates_de_debut)):\n",
    "        date_de_debut = dates_de_debut[i]\n",
    "        date_de_fin = dates_de_fin[i]\n",
    "        type_ = codes[types[i]]\n",
    "        montant = montants[i]\n",
    "        new_col = \"{date_de_debut}_{date_de_fin}_{type_}\".format(**locals())\n",
    "        val     = montant\n",
    "        new_cols.append({new_col : val})\n",
    "    a_ajouter.append(pd.DataFrame(new_cols))\n",
    "    break\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 170,
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>01092018_30092018_Rémunération brute non plafo...</td>\n",
       "      <td>01092018_30092018_Salaire brut soumis à contri...</td>\n",
       "      <td>01092018_30092018_Salaire de base</td>\n",
       "      <td>01092018_30092018_Salaire rétabli – reconstitué</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   0  \\\n",
       "0  01092018_30092018_Rémunération brute non plafo...   \n",
       "\n",
       "                                                   1  \\\n",
       "0  01092018_30092018_Salaire brut soumis à contri...   \n",
       "\n",
       "                                   2  \\\n",
       "0  01092018_30092018_Salaire de base   \n",
       "\n",
       "                                                 3  \n",
       "0  01092018_30092018_Salaire rétabli – reconstitué  "
      ]
     },
     "execution_count": 170,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame(a_ajouter)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}