nettoyage_des_donnees.ipynb

{
 "cells": [
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Nettoyage des données"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Import des bibliothèques"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Lecture du fichier"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "dfsynthese = pd.read_excel(\"data/AGRIBALYSE3.1_produits alimentaires_2.xlsm\", \"Synthese\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "dfdetail_etape = pd.read_excel(\"data/AGRIBALYSE3.1_produits alimentaires_2.xlsm\", \"Detail etape\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "dfdetail_ingredient = pd.read_excel(\"data/AGRIBALYSE3.1_produits alimentaires_2.xlsm\", \"Detail ingredient\")"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Nettoyage des noms des colonnes"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Récupération des noms des colonnes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Code\\nAGB',\n",
       " 'Code\\nCIQUAL',\n",
       " \"Groupe d'aliment\",\n",
       " \"Sous-groupe d'aliment\",\n",
       " 'Nom du Produit en Français',\n",
       " 'LCI Name',\n",
       " 'code saison (0 : hors saison ; 1 : de saison ; 2 : mix de consommation FR)',\n",
       " 'code avion (1 : par avion)',\n",
       " 'Livraison',\n",
       " \"Matériau d'emballage\",\n",
       " 'Préparation',\n",
       " 'DQR - Note de qualité de la donnée (1 excellente ; 5 très faible)',\n",
       " 'Score unique EF 3.1',\n",
       " 'Changement climatique',\n",
       " \"Appauvrissement de la couche d'ozone\",\n",
       " 'Rayonnements ionisants',\n",
       " \"Formation photochimique d'ozone\",\n",
       " 'Particules fines',\n",
       " 'Effets toxicologiques sur la santé humaine\\xa0: substances non-cancérogènes',\n",
       " 'Effets toxicologiques sur la santé humaine\\xa0: substances cancérogènes',\n",
       " 'Acidification terrestre et eaux douces',\n",
       " 'Eutrophisation eaux douces',\n",
       " 'Eutrophisation marine',\n",
       " 'Eutrophisation terrestre',\n",
       " \"Écotoxicité pour écosystèmes aquatiques d'eau douce\",\n",
       " 'Utilisation du sol',\n",
       " 'Épuisement des ressources eau',\n",
       " 'Épuisement des ressources énergétiques',\n",
       " 'Épuisement des ressources minéraux']"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "colonnes_synthese1 = dfsynthese.iloc[1][0:12]\n",
    "colonnes_synthese2 = dfsynthese.iloc[0][12:30]\n",
    "colonnes_synthese = pd.concat([colonnes_synthese1, colonnes_synthese2], axis=0)\n",
    "list(colonnes_synthese)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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: 1</th>\n",
       "      <th>Résultats par étape\\nL'arrondi des données peut causer des différences entre la somme des 6 étapes et la Synthèse.\\nLa valeur zéro est exprimée \"-\"</th>\n",
       "      <th>Unnamed: 3</th>\n",
       "      <th>Unnamed: 4</th>\n",
       "      <th>Unnamed: 5</th>\n",
       "      <th>Changement climatique</th>\n",
       "      <th>Unnamed: 16</th>\n",
       "      <th>Unnamed: 17</th>\n",
       "      <th>Unnamed: 18</th>\n",
       "      <th>Unnamed: 19</th>\n",
       "      <th>Unnamed: 20</th>\n",
       "      <th>Unnamed: 21</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>kg CO2 eq/kg de produit</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Code AGB</td>\n",
       "      <td>Code CIQUAL</td>\n",
       "      <td>Groupe d'aliment</td>\n",
       "      <td>Sous-groupe d'aliment</td>\n",
       "      <td>Nom du Produit en Français</td>\n",
       "      <td>LCI Name</td>\n",
       "      <td>Agriculture</td>\n",
       "      <td>Transformation</td>\n",
       "      <td>Emballage</td>\n",
       "      <td>Transport</td>\n",
       "      <td>Supermarché et distribution</td>\n",
       "      <td>Consommation</td>\n",
       "      <td>Total</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>11084</td>\n",
       "      <td>11084</td>\n",
       "      <td>aides culinaires et ingrédients divers</td>\n",
       "      <td>algues</td>\n",
       "      <td>Agar (algue), cru</td>\n",
       "      <td>Seaweed, agar, raw</td>\n",
       "      <td>4.569259</td>\n",
       "      <td>1.492415</td>\n",
       "      <td>0.290252</td>\n",
       "      <td>0.384404</td>\n",
       "      <td>0.020135</td>\n",
       "      <td>0.009943</td>\n",
       "      <td>6.766407</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>11023</td>\n",
       "      <td>11023</td>\n",
       "      <td>aides culinaires et ingrédients divers</td>\n",
       "      <td>herbes</td>\n",
       "      <td>Ail séché, poudre</td>\n",
       "      <td>Garlic, powder, dried</td>\n",
       "      <td>0.066043</td>\n",
       "      <td>0</td>\n",
       "      <td>0.47839</td>\n",
       "      <td>0.189268</td>\n",
       "      <td>0.015709</td>\n",
       "      <td>0</td>\n",
       "      <td>0.749409</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>11000</td>\n",
       "      <td>11000</td>\n",
       "      <td>aides culinaires et ingrédients divers</td>\n",
       "      <td>herbes</td>\n",
       "      <td>Ail, cru</td>\n",
       "      <td>Garlic, fresh</td>\n",
       "      <td>0.082554</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.173563</td>\n",
       "      <td>0.019636</td>\n",
       "      <td>0.08037</td>\n",
       "      <td>0.356122</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Unnamed: 0   Unnamed: 1  \\\n",
       "0        NaN          NaN   \n",
       "1   Code AGB  Code CIQUAL   \n",
       "2      11084        11084   \n",
       "3      11023        11023   \n",
       "4      11000        11000   \n",
       "\n",
       "  Résultats par étape\\nL'arrondi des données peut causer des différences entre la somme des 6 étapes et la Synthèse.\\nLa valeur zéro est exprimée \"-\"  \\\n",
       "0                                                NaN                                                                                                    \n",
       "1                                   Groupe d'aliment                                                                                                    \n",
       "2             aides culinaires et ingrédients divers                                                                                                    \n",
       "3             aides culinaires et ingrédients divers                                                                                                    \n",
       "4             aides culinaires et ingrédients divers                                                                                                    \n",
       "\n",
       "              Unnamed: 3                  Unnamed: 4             Unnamed: 5  \\\n",
       "0                    NaN                         NaN                    NaN   \n",
       "1  Sous-groupe d'aliment  Nom du Produit en Français               LCI Name   \n",
       "2                 algues           Agar (algue), cru     Seaweed, agar, raw   \n",
       "3                 herbes           Ail séché, poudre  Garlic, powder, dried   \n",
       "4                 herbes                    Ail, cru          Garlic, fresh   \n",
       "\n",
       "     Changement climatique     Unnamed: 16 Unnamed: 17 Unnamed: 18  \\\n",
       "0  kg CO2 eq/kg de produit             NaN         NaN         NaN   \n",
       "1              Agriculture  Transformation   Emballage   Transport   \n",
       "2                 4.569259        1.492415    0.290252    0.384404   \n",
       "3                 0.066043               0     0.47839    0.189268   \n",
       "4                 0.082554               0           0    0.173563   \n",
       "\n",
       "                   Unnamed: 19   Unnamed: 20 Unnamed: 21  \n",
       "0                          NaN           NaN         NaN  \n",
       "1  Supermarché et distribution  Consommation       Total  \n",
       "2                     0.020135      0.009943    6.766407  \n",
       "3                     0.015709             0    0.749409  \n",
       "4                     0.019636       0.08037    0.356122  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfdetail_etape.drop(dfdetail_etape.columns[6:15], axis=1, inplace=True)\n",
    "dfdetail_etape.drop(dfdetail_etape.columns[13:], axis=1, inplace=True)\n",
    "dfdetail_etape.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Unnamed: 0                                                                                                                                                                Code AGB\n",
       "Unnamed: 1                                                                                                                                                             Code CIQUAL\n",
       "Résultats par étape\\nL'arrondi des données peut causer des différences entre la somme des 6 étapes et la Synthèse.\\nLa valeur zéro est exprimée \"-\"               Groupe d'aliment\n",
       "Unnamed: 3                                                                                                                                                   Sous-groupe d'aliment\n",
       "Unnamed: 4                                                                                                                                              Nom du Produit en Français\n",
       "Unnamed: 5                                                                                                                                                                LCI Name\n",
       "Changement climatique                                                                                                                                                  Agriculture\n",
       "Unnamed: 16                                                                                                                                                         Transformation\n",
       "Unnamed: 17                                                                                                                                                              Emballage\n",
       "Unnamed: 18                                                                                                                                                              Transport\n",
       "Unnamed: 19                                                                                                                                            Supermarché et distribution\n",
       "Unnamed: 20                                                                                                                                                           Consommation\n",
       "Unnamed: 21                                                                                                                                                                  Total\n",
       "Name: 1, dtype: object"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "colonnes_detail_etape = dfdetail_etape.iloc[1]\n",
    "colonnes_detail_etape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Ciqual \\nAGB',\n",
       " 'Ciqual \\ncode',\n",
       " \"Groupe d'aliment\",\n",
       " \"Sous-groupe d'aliment\",\n",
       " 'Nom Français',\n",
       " 'LCI Name',\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " nan,\n",
       " 'Score unique EF 3.1',\n",
       " 'Changement climatique',\n",
       " \"Appauvrissement de la couche d'ozone\",\n",
       " 'Rayonnements ionisants',\n",
       " \"Formation photochimique d'ozone\",\n",
       " 'Particules fines',\n",
       " 'Effets toxicologiques sur la santé humaine\\xa0: substances non-cancérogènes',\n",
       " 'Effets toxicologiques sur la santé humaine\\xa0: substances cancérogènes',\n",
       " 'Acidification terrestre et eaux douces',\n",
       " 'Eutrophisation eaux douces',\n",
       " 'Eutrophisation marine',\n",
       " 'Eutrophisation terrestre',\n",
       " \"Écotoxicité pour écosystèmes aquatiques d'eau douce\",\n",
       " 'Utilisation du sol',\n",
       " 'Épuisement des ressources eau',\n",
       " 'Épuisement des ressources énergétiques',\n",
       " 'Épuisement des ressources minéraux']"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "colonnes_detail_ingredient1 = dfdetail_ingredient.iloc[2][0:6]\n",
    "colonnes_detail_ingredient2 = dfdetail_ingredient.iloc[1][6:]\n",
    "colonnes_detail_ingredient = pd.concat([colonnes_detail_ingredient1, colonnes_detail_ingredient2], axis=0)\n",
    "list(colonnes_detail_ingredient)"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Suppression des 2 premières lignes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "dfsynthese.drop([0,1], axis=0, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "dfdetail_etape.drop([0,1], axis=0, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "dfdetail_ingredient.drop([0,1,2], axis=0, inplace=True)"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Mettre le nouveau nom des colonnes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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>Code\\nAGB</th>\n",
       "      <th>Code\\nCIQUAL</th>\n",
       "      <th>Groupe d'aliment</th>\n",
       "      <th>Sous-groupe d'aliment</th>\n",
       "      <th>Nom du Produit en Français</th>\n",
       "      <th>LCI Name</th>\n",
       "      <th>code saison (0 : hors saison ; 1 : de saison ; 2 : mix de consommation FR)</th>\n",
       "      <th>code avion (1 : par avion)</th>\n",
       "      <th>Livraison</th>\n",
       "      <th>Matériau d'emballage</th>\n",
       "      <th>...</th>\n",
       "      <th>Effets toxicologiques sur la santé humaine : substances cancérogènes</th>\n",
       "      <th>Acidification terrestre et eaux douces</th>\n",
       "      <th>Eutrophisation eaux douces</th>\n",
       "      <th>Eutrophisation marine</th>\n",
       "      <th>Eutrophisation terrestre</th>\n",
       "      <th>Écotoxicité pour écosystèmes aquatiques d'eau douce</th>\n",
       "      <th>Utilisation du sol</th>\n",
       "      <th>Épuisement des ressources eau</th>\n",
       "      <th>Épuisement des ressources énergétiques</th>\n",
       "      <th>Épuisement des ressources minéraux</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>11084</td>\n",
       "      <td>11084</td>\n",
       "      <td>aides culinaires et ingrédients divers</td>\n",
       "      <td>algues</td>\n",
       "      <td>Agar (algue), cru</td>\n",
       "      <td>Seaweed, agar, raw</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Ambiant (long)</td>\n",
       "      <td>LDPE</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.099733</td>\n",
       "      <td>0.001868</td>\n",
       "      <td>0.01328</td>\n",
       "      <td>0.12735</td>\n",
       "      <td>44.555153</td>\n",
       "      <td>26.47619</td>\n",
       "      <td>3.102487</td>\n",
       "      <td>315.05717</td>\n",
       "      <td>0.000088</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>11023</td>\n",
       "      <td>11023</td>\n",
       "      <td>aides culinaires et ingrédients divers</td>\n",
       "      <td>herbes</td>\n",
       "      <td>Ail séché, poudre</td>\n",
       "      <td>Garlic, powder, dried</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Ambiant (long)</td>\n",
       "      <td>Verre</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.006222</td>\n",
       "      <td>0.000124</td>\n",
       "      <td>0.00232</td>\n",
       "      <td>0.012695</td>\n",
       "      <td>5.83212</td>\n",
       "      <td>20.223652</td>\n",
       "      <td>2.520528</td>\n",
       "      <td>12.665447</td>\n",
       "      <td>0.000007</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>11000</td>\n",
       "      <td>11000</td>\n",
       "      <td>aides culinaires et ingrédients divers</td>\n",
       "      <td>herbes</td>\n",
       "      <td>Ail, cru</td>\n",
       "      <td>Garlic, fresh</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Ambiant (long)</td>\n",
       "      <td>Pas d'emballage</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.002005</td>\n",
       "      <td>0.000068</td>\n",
       "      <td>0.002123</td>\n",
       "      <td>0.006281</td>\n",
       "      <td>4.092332</td>\n",
       "      <td>18.454615</td>\n",
       "      <td>3.021753</td>\n",
       "      <td>6.230187</td>\n",
       "      <td>0.000004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>11093</td>\n",
       "      <td>11093</td>\n",
       "      <td>aides culinaires et ingrédients divers</td>\n",
       "      <td>herbes</td>\n",
       "      <td>Aneth, frais</td>\n",
       "      <td>Dill, fresh</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Ambiant (long)</td>\n",
       "      <td>LDPE</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.008112</td>\n",
       "      <td>0.000203</td>\n",
       "      <td>0.00405</td>\n",
       "      <td>0.031181</td>\n",
       "      <td>5.681342</td>\n",
       "      <td>36.373722</td>\n",
       "      <td>5.292121</td>\n",
       "      <td>12.553109</td>\n",
       "      <td>0.000005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>20995</td>\n",
       "      <td>20995</td>\n",
       "      <td>aides culinaires et ingrédients divers</td>\n",
       "      <td>algues</td>\n",
       "      <td>Ao-nori (Enteromorpha sp.), séchée ou déshydratée</td>\n",
       "      <td>Sea lettuce (Enteromorpha sp.), dried or dehyd...</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Ambiant (long)</td>\n",
       "      <td>LDPE</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.099733</td>\n",
       "      <td>0.001868</td>\n",
       "      <td>0.01328</td>\n",
       "      <td>0.12735</td>\n",
       "      <td>44.555153</td>\n",
       "      <td>26.47619</td>\n",
       "      <td>3.102487</td>\n",
       "      <td>315.05717</td>\n",
       "      <td>0.000088</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 29 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  Code\\nAGB Code\\nCIQUAL                        Groupe d'aliment  \\\n",
       "2     11084        11084  aides culinaires et ingrédients divers   \n",
       "3     11023        11023  aides culinaires et ingrédients divers   \n",
       "4     11000        11000  aides culinaires et ingrédients divers   \n",
       "5     11093        11093  aides culinaires et ingrédients divers   \n",
       "6     20995        20995  aides culinaires et ingrédients divers   \n",
       "\n",
       "  Sous-groupe d'aliment                         Nom du Produit en Français  \\\n",
       "2                algues                                  Agar (algue), cru   \n",
       "3                herbes                                  Ail séché, poudre   \n",
       "4                herbes                                           Ail, cru   \n",
       "5                herbes                                       Aneth, frais   \n",
       "6                algues  Ao-nori (Enteromorpha sp.), séchée ou déshydratée   \n",
       "\n",
       "                                            LCI Name  \\\n",
       "2                                 Seaweed, agar, raw   \n",
       "3                              Garlic, powder, dried   \n",
       "4                                      Garlic, fresh   \n",
       "5                                        Dill, fresh   \n",
       "6  Sea lettuce (Enteromorpha sp.), dried or dehyd...   \n",
       "\n",
       "  code saison (0 : hors saison ; 1 : de saison ; 2 : mix de consommation FR)  \\\n",
       "2                                                  2                           \n",
       "3                                                  2                           \n",
       "4                                                  2                           \n",
       "5                                                  2                           \n",
       "6                                                  2                           \n",
       "\n",
       "  code avion (1 : par avion)       Livraison Matériau d'emballage  ...  \\\n",
       "2                          0  Ambiant (long)                 LDPE  ...   \n",
       "3                          0  Ambiant (long)                Verre  ...   \n",
       "4                          0  Ambiant (long)      Pas d'emballage  ...   \n",
       "5                          0  Ambiant (long)                 LDPE  ...   \n",
       "6                          0  Ambiant (long)                 LDPE  ...   \n",
       "\n",
       "  Effets toxicologiques sur la santé humaine : substances cancérogènes  \\\n",
       "2                                                0.0                     \n",
       "3                                                0.0                     \n",
       "4                                                0.0                     \n",
       "5                                                0.0                     \n",
       "6                                                0.0                     \n",
       "\n",
       "  Acidification terrestre et eaux douces Eutrophisation eaux douces  \\\n",
       "2                               0.099733                   0.001868   \n",
       "3                               0.006222                   0.000124   \n",
       "4                               0.002005                   0.000068   \n",
       "5                               0.008112                   0.000203   \n",
       "6                               0.099733                   0.001868   \n",
       "\n",
       "  Eutrophisation marine Eutrophisation terrestre  \\\n",
       "2               0.01328                  0.12735   \n",
       "3               0.00232                 0.012695   \n",
       "4              0.002123                 0.006281   \n",
       "5               0.00405                 0.031181   \n",
       "6               0.01328                  0.12735   \n",
       "\n",
       "  Écotoxicité pour écosystèmes aquatiques d'eau douce Utilisation du sol  \\\n",
       "2                                          44.555153            26.47619   \n",
       "3                                            5.83212           20.223652   \n",
       "4                                           4.092332           18.454615   \n",
       "5                                           5.681342           36.373722   \n",
       "6                                          44.555153            26.47619   \n",
       "\n",
       "  Épuisement des ressources eau Épuisement des ressources énergétiques  \\\n",
       "2                      3.102487                              315.05717   \n",
       "3                      2.520528                              12.665447   \n",
       "4                      3.021753                               6.230187   \n",
       "5                      5.292121                              12.553109   \n",
       "6                      3.102487                              315.05717   \n",
       "\n",
       "  Épuisement des ressources minéraux  \n",
       "2                           0.000088  \n",
       "3                           0.000007  \n",
       "4                           0.000004  \n",
       "5                           0.000005  \n",
       "6                           0.000088  \n",
       "\n",
       "[5 rows x 29 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfsynthese.columns=colonnes_synthese\n",
    "dfsynthese.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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>1</th>\n",
       "      <th>Code AGB</th>\n",
       "      <th>Code CIQUAL</th>\n",
       "      <th>Groupe d'aliment</th>\n",
       "      <th>Sous-groupe d'aliment</th>\n",
       "      <th>Nom du Produit en Français</th>\n",
       "      <th>LCI Name</th>\n",
       "      <th>Agriculture</th>\n",
       "      <th>Transformation</th>\n",
       "      <th>Emballage</th>\n",
       "      <th>Transport</th>\n",
       "      <th>Supermarché et distribution</th>\n",
       "      <th>Consommation</th>\n",
       "      <th>Total</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>11084</td>\n",
       "      <td>11084</td>\n",
       "      <td>aides culinaires et ingrédients divers</td>\n",
       "      <td>algues</td>\n",
       "      <td>Agar (algue), cru</td>\n",
       "      <td>Seaweed, agar, raw</td>\n",
       "      <td>4.569259</td>\n",
       "      <td>1.492415</td>\n",
       "      <td>0.290252</td>\n",
       "      <td>0.384404</td>\n",
       "      <td>0.020135</td>\n",
       "      <td>0.009943</td>\n",
       "      <td>6.766407</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>11023</td>\n",
       "      <td>11023</td>\n",
       "      <td>aides culinaires et ingrédients divers</td>\n",
       "      <td>herbes</td>\n",
       "      <td>Ail séché, poudre</td>\n",
       "      <td>Garlic, powder, dried</td>\n",
       "      <td>0.066043</td>\n",
       "      <td>0</td>\n",
       "      <td>0.47839</td>\n",
       "      <td>0.189268</td>\n",
       "      <td>0.015709</td>\n",
       "      <td>0</td>\n",
       "      <td>0.749409</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>11000</td>\n",
       "      <td>11000</td>\n",
       "      <td>aides culinaires et ingrédients divers</td>\n",
       "      <td>herbes</td>\n",
       "      <td>Ail, cru</td>\n",
       "      <td>Garlic, fresh</td>\n",
       "      <td>0.082554</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.173563</td>\n",
       "      <td>0.019636</td>\n",
       "      <td>0.08037</td>\n",
       "      <td>0.356122</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>11093</td>\n",
       "      <td>11093</td>\n",
       "      <td>aides culinaires et ingrédients divers</td>\n",
       "      <td>herbes</td>\n",
       "      <td>Aneth, frais</td>\n",
       "      <td>Dill, fresh</td>\n",
       "      <td>0.222514</td>\n",
       "      <td>0</td>\n",
       "      <td>0.329456</td>\n",
       "      <td>0.162968</td>\n",
       "      <td>0.019636</td>\n",
       "      <td>0.08037</td>\n",
       "      <td>0.814944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>20995</td>\n",
       "      <td>20995</td>\n",
       "      <td>aides culinaires et ingrédients divers</td>\n",
       "      <td>algues</td>\n",
       "      <td>Ao-nori (Enteromorpha sp.), séchée ou déshydratée</td>\n",
       "      <td>Sea lettuce (Enteromorpha sp.), dried or dehyd...</td>\n",
       "      <td>4.569259</td>\n",
       "      <td>1.492415</td>\n",
       "      <td>0.290252</td>\n",
       "      <td>0.384404</td>\n",
       "      <td>0.020135</td>\n",
       "      <td>0.009943</td>\n",
       "      <td>6.766407</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "1 Code AGB Code CIQUAL                        Groupe d'aliment  \\\n",
       "2    11084       11084  aides culinaires et ingrédients divers   \n",
       "3    11023       11023  aides culinaires et ingrédients divers   \n",
       "4    11000       11000  aides culinaires et ingrédients divers   \n",
       "5    11093       11093  aides culinaires et ingrédients divers   \n",
       "6    20995       20995  aides culinaires et ingrédients divers   \n",
       "\n",
       "1 Sous-groupe d'aliment                         Nom du Produit en Français  \\\n",
       "2                algues                                  Agar (algue), cru   \n",
       "3                herbes                                  Ail séché, poudre   \n",
       "4                herbes                                           Ail, cru   \n",
       "5                herbes                                       Aneth, frais   \n",
       "6                algues  Ao-nori (Enteromorpha sp.), séchée ou déshydratée   \n",
       "\n",
       "1                                           LCI Name Agriculture  \\\n",
       "2                                 Seaweed, agar, raw    4.569259   \n",
       "3                              Garlic, powder, dried    0.066043   \n",
       "4                                      Garlic, fresh    0.082554   \n",
       "5                                        Dill, fresh    0.222514   \n",
       "6  Sea lettuce (Enteromorpha sp.), dried or dehyd...    4.569259   \n",
       "\n",
       "1 Transformation Emballage Transport Supermarché et distribution Consommation  \\\n",
       "2       1.492415  0.290252  0.384404                    0.020135     0.009943   \n",
       "3              0   0.47839  0.189268                    0.015709            0   \n",
       "4              0         0  0.173563                    0.019636      0.08037   \n",
       "5              0  0.329456  0.162968                    0.019636      0.08037   \n",
       "6       1.492415  0.290252  0.384404                    0.020135     0.009943   \n",
       "\n",
       "1     Total  \n",
       "2  6.766407  \n",
       "3  0.749409  \n",
       "4  0.356122  \n",
       "5  0.814944  \n",
       "6  6.766407  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfdetail_etape.columns=colonnes_detail_etape\n",
    "dfdetail_etape.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Ciqual \\nAGB</th>\n",
       "      <th>Ciqual \\ncode</th>\n",
       "      <th>Groupe d'aliment</th>\n",
       "      <th>Sous-groupe d'aliment</th>\n",
       "      <th>Nom Français</th>\n",
       "      <th>LCI Name</th>\n",
       "      <th>NaN</th>\n",
       "      <th>NaN</th>\n",
       "      <th>NaN</th>\n",
       "      <th>NaN</th>\n",
       "      <th>...</th>\n",
       "      <th>Effets toxicologiques sur la santé humaine : substances cancérogènes</th>\n",
       "      <th>Acidification terrestre et eaux douces</th>\n",
       "      <th>Eutrophisation eaux douces</th>\n",
       "      <th>Eutrophisation marine</th>\n",
       "      <th>Eutrophisation terrestre</th>\n",
       "      <th>Écotoxicité pour écosystèmes aquatiques d'eau douce</th>\n",
       "      <th>Utilisation du sol</th>\n",
       "      <th>Épuisement des ressources eau</th>\n",
       "      <th>Épuisement des ressources énergétiques</th>\n",
       "      <th>Épuisement des ressources minéraux</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>37000</td>\n",
       "      <td>37000</td>\n",
       "      <td>aides culinaires et ingrédients divers</td>\n",
       "      <td>ingrédients divers</td>\n",
       "      <td>Base de pizza à la crème</td>\n",
       "      <td>cream sauce for pizza base</td>\n",
       "      <td>Fromage frais crémeux</td>\n",
       "      <td>Base de pizza à la crème (37000)</td>\n",
       "      <td>aides culinaires et ingrédients divers</td>\n",
       "      <td>ingrédients divers</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.017189</td>\n",
       "      <td>0.000222</td>\n",
       "      <td>0.005425</td>\n",
       "      <td>0.072309</td>\n",
       "      <td>17.540426</td>\n",
       "      <td>90.117834</td>\n",
       "      <td>0.310087</td>\n",
       "      <td>8.091825</td>\n",
       "      <td>0.000015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>37000</td>\n",
       "      <td>37000</td>\n",
       "      <td>aides culinaires et ingrédients divers</td>\n",
       "      <td>ingrédients divers</td>\n",
       "      <td>Base de pizza à la crème</td>\n",
       "      <td>cream sauce for pizza base</td>\n",
       "      <td>Autres étapes</td>\n",
       "      <td>Base de pizza à la crème (37000)</td>\n",
       "      <td>aides culinaires et ingrédients divers</td>\n",
       "      <td>ingrédients divers</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.002161</td>\n",
       "      <td>0.00009</td>\n",
       "      <td>0.0013</td>\n",
       "      <td>0.006976</td>\n",
       "      <td>2.311035</td>\n",
       "      <td>9.058034</td>\n",
       "      <td>0.144493</td>\n",
       "      <td>15.26928</td>\n",
       "      <td>0.000002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>37000</td>\n",
       "      <td>37000</td>\n",
       "      <td>aides culinaires et ingrédients divers</td>\n",
       "      <td>ingrédients divers</td>\n",
       "      <td>Base de pizza à la crème</td>\n",
       "      <td>cream sauce for pizza base</td>\n",
       "      <td>Total</td>\n",
       "      <td>Base de pizza à la crème (37000)</td>\n",
       "      <td>aides culinaires et ingrédients divers</td>\n",
       "      <td>ingrédients divers</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01935</td>\n",
       "      <td>0.000312</td>\n",
       "      <td>0.006725</td>\n",
       "      <td>0.079285</td>\n",
       "      <td>19.851461</td>\n",
       "      <td>99.175868</td>\n",
       "      <td>0.45458</td>\n",
       "      <td>23.361105</td>\n",
       "      <td>0.000017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>37002</td>\n",
       "      <td>37002</td>\n",
       "      <td>aides culinaires et ingrédients divers</td>\n",
       "      <td>ingrédients divers</td>\n",
       "      <td>Base de pizza tomatée</td>\n",
       "      <td>Tomato sauce for pizza base</td>\n",
       "      <td>Huile d'olive</td>\n",
       "      <td>Base de pizza tomatée (37002)</td>\n",
       "      <td>aides culinaires et ingrédients divers</td>\n",
       "      <td>ingrédients divers</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.003773</td>\n",
       "      <td>0.000052</td>\n",
       "      <td>0.001739</td>\n",
       "      <td>0.015762</td>\n",
       "      <td>5.577347</td>\n",
       "      <td>54.288788</td>\n",
       "      <td>1.945284</td>\n",
       "      <td>1.720683</td>\n",
       "      <td>0.000002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>37002</td>\n",
       "      <td>37002</td>\n",
       "      <td>aides culinaires et ingrédients divers</td>\n",
       "      <td>ingrédients divers</td>\n",
       "      <td>Base de pizza tomatée</td>\n",
       "      <td>Tomato sauce for pizza base</td>\n",
       "      <td>Oignons</td>\n",
       "      <td>Base de pizza tomatée (37002)</td>\n",
       "      <td>aides culinaires et ingrédients divers</td>\n",
       "      <td>ingrédients divers</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000111</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>0.000125</td>\n",
       "      <td>0.000408</td>\n",
       "      <td>0.230512</td>\n",
       "      <td>0.998462</td>\n",
       "      <td>0.165128</td>\n",
       "      <td>0.137714</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 27 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  Ciqual \\nAGB Ciqual \\ncode                        Groupe d'aliment  \\\n",
       "3        37000         37000  aides culinaires et ingrédients divers   \n",
       "4        37000         37000  aides culinaires et ingrédients divers   \n",
       "5        37000         37000  aides culinaires et ingrédients divers   \n",
       "6        37002         37002  aides culinaires et ingrédients divers   \n",
       "7        37002         37002  aides culinaires et ingrédients divers   \n",
       "\n",
       "  Sous-groupe d'aliment              Nom Français  \\\n",
       "3    ingrédients divers  Base de pizza à la crème   \n",
       "4    ingrédients divers  Base de pizza à la crème   \n",
       "5    ingrédients divers  Base de pizza à la crème   \n",
       "6    ingrédients divers     Base de pizza tomatée   \n",
       "7    ingrédients divers     Base de pizza tomatée   \n",
       "\n",
       "                      LCI Name                    NaN  \\\n",
       "3   cream sauce for pizza base  Fromage frais crémeux   \n",
       "4   cream sauce for pizza base          Autres étapes   \n",
       "5   cream sauce for pizza base                  Total   \n",
       "6  Tomato sauce for pizza base          Huile d'olive   \n",
       "7  Tomato sauce for pizza base                Oignons   \n",
       "\n",
       "                                NaN                                     NaN  \\\n",
       "3  Base de pizza à la crème (37000)  aides culinaires et ingrédients divers   \n",
       "4  Base de pizza à la crème (37000)  aides culinaires et ingrédients divers   \n",
       "5  Base de pizza à la crème (37000)  aides culinaires et ingrédients divers   \n",
       "6     Base de pizza tomatée (37002)  aides culinaires et ingrédients divers   \n",
       "7     Base de pizza tomatée (37002)  aides culinaires et ingrédients divers   \n",
       "\n",
       "                  NaN  ...  \\\n",
       "3  ingrédients divers  ...   \n",
       "4  ingrédients divers  ...   \n",
       "5  ingrédients divers  ...   \n",
       "6  ingrédients divers  ...   \n",
       "7  ingrédients divers  ...   \n",
       "\n",
       "  Effets toxicologiques sur la santé humaine : substances cancérogènes  \\\n",
       "3                                                0.0                     \n",
       "4                                                0.0                     \n",
       "5                                                0.0                     \n",
       "6                                                0.0                     \n",
       "7                                                0.0                     \n",
       "\n",
       "  Acidification terrestre et eaux douces Eutrophisation eaux douces  \\\n",
       "3                               0.017189                   0.000222   \n",
       "4                               0.002161                    0.00009   \n",
       "5                                0.01935                   0.000312   \n",
       "6                               0.003773                   0.000052   \n",
       "7                               0.000111                   0.000003   \n",
       "\n",
       "  Eutrophisation marine Eutrophisation terrestre  \\\n",
       "3              0.005425                 0.072309   \n",
       "4                0.0013                 0.006976   \n",
       "5              0.006725                 0.079285   \n",
       "6              0.001739                 0.015762   \n",
       "7              0.000125                 0.000408   \n",
       "\n",
       "  Écotoxicité pour écosystèmes aquatiques d'eau douce Utilisation du sol  \\\n",
       "3                                          17.540426           90.117834   \n",
       "4                                           2.311035            9.058034   \n",
       "5                                          19.851461           99.175868   \n",
       "6                                           5.577347           54.288788   \n",
       "7                                           0.230512            0.998462   \n",
       "\n",
       "  Épuisement des ressources eau Épuisement des ressources énergétiques  \\\n",
       "3                      0.310087                               8.091825   \n",
       "4                      0.144493                               15.26928   \n",
       "5                       0.45458                              23.361105   \n",
       "6                      1.945284                               1.720683   \n",
       "7                      0.165128                               0.137714   \n",
       "\n",
       "  Épuisement des ressources minéraux  \n",
       "3                           0.000015  \n",
       "4                           0.000002  \n",
       "5                           0.000017  \n",
       "6                           0.000002  \n",
       "7                                0.0  \n",
       "\n",
       "[5 rows x 27 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfdetail_ingredient.columns = colonnes_detail_ingredient\n",
    "dfdetail_ingredient.head()"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Conversion en csv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "dfsynthese.to_csv(\"data/feuille synthese.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "dfdetail_etape.to_csv(\"data/feuille detail etape.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "dfdetail_ingredient.to_csv(\"data/feuille detail ingredient.csv\")"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Audit des données"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Verification si les lignes SGB et CIQUAL sont les mêmes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Code\\nAGB                                                                     object\n",
       "Code\\nCIQUAL                                                                  object\n",
       "Groupe d'aliment                                                              object\n",
       "Sous-groupe d'aliment                                                         object\n",
       "Nom du Produit en Français                                                    object\n",
       "LCI Name                                                                      object\n",
       "code saison (0 : hors saison ; 1 : de saison ; 2 : mix de consommation FR)    object\n",
       "code avion (1 : par avion)                                                    object\n",
       "Livraison                                                                     object\n",
       "Matériau d'emballage                                                          object\n",
       "Préparation                                                                   object\n",
       "DQR - Note de qualité de la donnée (1 excellente ; 5 très faible)             object\n",
       "Score unique EF 3.1                                                           object\n",
       "Changement climatique                                                         object\n",
       "Appauvrissement de la couche d'ozone                                          object\n",
       "Rayonnements ionisants                                                        object\n",
       "Formation photochimique d'ozone                                               object\n",
       "Particules fines                                                              object\n",
       "Effets toxicologiques sur la santé humaine : substances non-cancérogènes      object\n",
       "Effets toxicologiques sur la santé humaine : substances cancérogènes          object\n",
       "Acidification terrestre et eaux douces                                        object\n",
       "Eutrophisation eaux douces                                                    object\n",
       "Eutrophisation marine                                                         object\n",
       "Eutrophisation terrestre                                                      object\n",
       "Écotoxicité pour écosystèmes aquatiques d'eau douce                           object\n",
       "Utilisation du sol                                                            object\n",
       "Épuisement des ressources eau                                                 object\n",
       "Épuisement des ressources énergétiques                                        object\n",
       "Épuisement des ressources minéraux                                            object\n",
       "dtype: object"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfsynthese.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "str"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(dfsynthese[\"Code\\nAGB\"][10])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "int"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(dfsynthese[\"Code\\nCIQUAL\"][10])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "la ligne 445 a un code AGB 25415_2 et un code CIQUEL 25415.\n",
      "la ligne 481 a un code AGB 25415_1 et un code CIQUEL 25415.\n",
      "la ligne 713 a un code AGB 7815_2 et un code CIQUEL 7815.\n",
      "la ligne 818 a un code AGB 13024_2 et un code CIQUEL 13082.\n",
      "la ligne 872 a un code AGB 13014_2 et un code CIQUEL 13014.\n",
      "la ligne 873 a un code AGB 13014_3 et un code CIQUEL 13014.\n",
      "la ligne 874 a un code AGB 13014_1 et un code CIQUEL 13014.\n",
      "la ligne 911 a un code AGB 20061_2 et un code CIQUEL 20061.\n",
      "la ligne 913 a un code AGB 20061_1 et un code CIQUEL 20061.\n",
      "la ligne 960 a un code AGB 13024_1 et un code CIQUEL 13024.\n",
      "la ligne 961 a un code AGB 13025_2 et un code CIQUEL 13025.\n",
      "la ligne 962 a un code AGB 13025_1 et un code CIQUEL 13025.\n",
      "la ligne 1123 a un code AGB 20047_2 et un code CIQUEL 20047.\n",
      "la ligne 1124 a un code AGB 20047_3 et un code CIQUEL 20047.\n",
      "la ligne 1128 a un code AGB 20047_1 et un code CIQUEL 20047.\n",
      "la ligne 1362 a un code AGB 1029_1 et un code CIQUEL 1029.\n",
      "la ligne 1363 a un code AGB 1029_2 et un code CIQUEL 1029.\n",
      "la ligne 1777 a un code AGB 9340_2 et un code CIQUEL 9340.\n",
      "la ligne 1778 a un code AGB 9341_2 et un code CIQUEL 9341.\n",
      "la ligne 1779 a un code AGB 9341_1 et un code CIQUEL 9341.\n",
      "la ligne 1780 a un code AGB 9340_1 et un code CIQUEL 9340.\n",
      "la ligne 1817 a un code AGB 7815_1 et un code CIQUEL 7815.\n",
      "la ligne 2348 a un code AGB 20591_1 et un code CIQUEL 20591.\n",
      "la ligne 2349 a un code AGB 20591_2 et un code CIQUEL 20591.\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "24"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "nombre_doublon = 0\n",
    "for index, lignes in dfsynthese.iterrows():\n",
    "    if int(lignes[0])!=int(lignes[1]):\n",
    "        print(f\"la ligne {index} a un code AGB {lignes[0]} et un code CIQUEL {lignes[1]}.\")\n",
    "        nombre_doublon += 1\n",
    "nombre_doublon"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "la ligne 95 a un code AGB 11182 et un code CIQUEL 11212.\n",
      "la ligne 445 a un code AGB 25415_2 et un code CIQUEL 25415.\n",
      "la ligne 481 a un code AGB 25415_1 et un code CIQUEL 25415.\n",
      "la ligne 713 a un code AGB 7815_2 et un code CIQUEL 7815.\n",
      "la ligne 818 a un code AGB 13024_2 et un code CIQUEL 13082.\n",
      "la ligne 872 a un code AGB 13014_2 et un code CIQUEL 13014.\n",
      "la ligne 873 a un code AGB 13014_3 et un code CIQUEL 13014.\n",
      "la ligne 874 a un code AGB 13014_1 et un code CIQUEL 13014.\n",
      "la ligne 911 a un code AGB 20061_2 et un code CIQUEL 20061.\n",
      "la ligne 913 a un code AGB 20061_1 et un code CIQUEL 20061.\n",
      "la ligne 960 a un code AGB 13024_1 et un code CIQUEL 13024.\n",
      "la ligne 961 a un code AGB 13025_2 et un code CIQUEL 13025.\n",
      "la ligne 962 a un code AGB 13025_1 et un code CIQUEL 13025.\n",
      "la ligne 1123 a un code AGB 20047_2 et un code CIQUEL 20047.\n",
      "la ligne 1124 a un code AGB 20047_3 et un code CIQUEL 20047.\n",
      "la ligne 1128 a un code AGB 20047_1 et un code CIQUEL 20047.\n",
      "la ligne 1362 a un code AGB 1029_1 et un code CIQUEL 1029.\n",
      "la ligne 1363 a un code AGB 1029_2 et un code CIQUEL 1029.\n",
      "la ligne 1777 a un code AGB 9340_2 et un code CIQUEL 9340.\n",
      "la ligne 1778 a un code AGB 9341_2 et un code CIQUEL 9341.\n",
      "la ligne 1779 a un code AGB 9341_1 et un code CIQUEL 9341.\n",
      "la ligne 1780 a un code AGB 9340_1 et un code CIQUEL 9340.\n",
      "la ligne 1817 a un code AGB 7815_1 et un code CIQUEL 7815.\n",
      "la ligne 2348 a un code AGB 20591_1 et un code CIQUEL 20591.\n",
      "la ligne 2349 a un code AGB 20591_2 et un code CIQUEL 20591.\n"
     ]
    }
   ],
   "source": [
    "for index, lignes in dfdetail_etape.iterrows():\n",
    "    if int(lignes[0])!=int(lignes[1]):\n",
    "        print(f\"la ligne {index} a un code AGB {lignes[0]} et un code CIQUEL {lignes[1]}.\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "for index, lignes in dfdetail_ingredient.iterrows():\n",
    "    if int(lignes[0])!=int(lignes[1]):\n",
    "        print(f\"la ligne {index} a un code AGB {lignes[0]} et un code CIQUEL {lignes[1]}.\")"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Suppresion de la ligne AGB"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "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>Code\\nAGB</th>\n",
       "      <th>Code\\nCIQUAL</th>\n",
       "      <th>Groupe d'aliment</th>\n",
       "      <th>Sous-groupe d'aliment</th>\n",
       "      <th>Nom du Produit en Français</th>\n",
       "      <th>LCI Name</th>\n",
       "      <th>code saison (0 : hors saison ; 1 : de saison ; 2 : mix de consommation FR)</th>\n",
       "      <th>code avion (1 : par avion)</th>\n",
       "      <th>Livraison</th>\n",
       "      <th>Matériau d'emballage</th>\n",
       "      <th>...</th>\n",
       "      <th>Effets toxicologiques sur la santé humaine : substances cancérogènes</th>\n",
       "      <th>Acidification terrestre et eaux douces</th>\n",
       "      <th>Eutrophisation eaux douces</th>\n",
       "      <th>Eutrophisation marine</th>\n",
       "      <th>Eutrophisation terrestre</th>\n",
       "      <th>Écotoxicité pour écosystèmes aquatiques d'eau douce</th>\n",
       "      <th>Utilisation du sol</th>\n",
       "      <th>Épuisement des ressources eau</th>\n",
       "      <th>Épuisement des ressources énergétiques</th>\n",
       "      <th>Épuisement des ressources minéraux</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>11084</td>\n",
       "      <td>11084</td>\n",
       "      <td>aides culinaires et ingrédients divers</td>\n",
       "      <td>algues</td>\n",
       "      <td>Agar (algue), cru</td>\n",
       "      <td>Seaweed, agar, raw</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Ambiant (long)</td>\n",
       "      <td>LDPE</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.099733</td>\n",
       "      <td>0.001868</td>\n",
       "      <td>0.01328</td>\n",
       "      <td>0.12735</td>\n",
       "      <td>44.555153</td>\n",
       "      <td>26.47619</td>\n",
       "      <td>3.102487</td>\n",
       "      <td>315.05717</td>\n",
       "      <td>0.000088</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>11023</td>\n",
       "      <td>11023</td>\n",
       "      <td>aides culinaires et ingrédients divers</td>\n",
       "      <td>herbes</td>\n",
       "      <td>Ail séché, poudre</td>\n",
       "      <td>Garlic, powder, dried</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Ambiant (long)</td>\n",
       "      <td>Verre</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.006222</td>\n",
       "      <td>0.000124</td>\n",
       "      <td>0.00232</td>\n",
       "      <td>0.012695</td>\n",
       "      <td>5.83212</td>\n",
       "      <td>20.223652</td>\n",
       "      <td>2.520528</td>\n",
       "      <td>12.665447</td>\n",
       "      <td>0.000007</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>11000</td>\n",
       "      <td>11000</td>\n",
       "      <td>aides culinaires et ingrédients divers</td>\n",
       "      <td>herbes</td>\n",
       "      <td>Ail, cru</td>\n",
       "      <td>Garlic, fresh</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Ambiant (long)</td>\n",
       "      <td>Pas d'emballage</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.002005</td>\n",
       "      <td>0.000068</td>\n",
       "      <td>0.002123</td>\n",
       "      <td>0.006281</td>\n",
       "      <td>4.092332</td>\n",
       "      <td>18.454615</td>\n",
       "      <td>3.021753</td>\n",
       "      <td>6.230187</td>\n",
       "      <td>0.000004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>11093</td>\n",
       "      <td>11093</td>\n",
       "      <td>aides culinaires et ingrédients divers</td>\n",
       "      <td>herbes</td>\n",
       "      <td>Aneth, frais</td>\n",
       "      <td>Dill, fresh</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Ambiant (long)</td>\n",
       "      <td>LDPE</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.008112</td>\n",
       "      <td>0.000203</td>\n",
       "      <td>0.00405</td>\n",
       "      <td>0.031181</td>\n",
       "      <td>5.681342</td>\n",
       "      <td>36.373722</td>\n",
       "      <td>5.292121</td>\n",
       "      <td>12.553109</td>\n",
       "      <td>0.000005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>20995</td>\n",
       "      <td>20995</td>\n",
       "      <td>aides culinaires et ingrédients divers</td>\n",
       "      <td>algues</td>\n",
       "      <td>Ao-nori (Enteromorpha sp.), séchée ou déshydratée</td>\n",
       "      <td>Sea lettuce (Enteromorpha sp.), dried or dehyd...</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Ambiant (long)</td>\n",
       "      <td>LDPE</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.099733</td>\n",
       "      <td>0.001868</td>\n",
       "      <td>0.01328</td>\n",
       "      <td>0.12735</td>\n",
       "      <td>44.555153</td>\n",
       "      <td>26.47619</td>\n",
       "      <td>3.102487</td>\n",
       "      <td>315.05717</td>\n",
       "      <td>0.000088</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>2514</th>\n",
       "      <td>6535</td>\n",
       "      <td>6535</td>\n",
       "      <td>viandes, œufs, poissons</td>\n",
       "      <td>viandes crues</td>\n",
       "      <td>Veau, steak haché 20% MG, cru</td>\n",
       "      <td>Veal, minced steak, 20% fat, raw</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Glacé</td>\n",
       "      <td>PS</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.224717</td>\n",
       "      <td>0.002212</td>\n",
       "      <td>0.155523</td>\n",
       "      <td>0.96026</td>\n",
       "      <td>192.77924</td>\n",
       "      <td>1521.1493</td>\n",
       "      <td>6.276344</td>\n",
       "      <td>111.47848</td>\n",
       "      <td>0.000038</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2515</th>\n",
       "      <td>6582</td>\n",
       "      <td>6582</td>\n",
       "      <td>viandes, œufs, poissons</td>\n",
       "      <td>viandes cuites</td>\n",
       "      <td>Veau, tête, bouillie/cuite à l'eau</td>\n",
       "      <td>Calf, head, boiled/cooked in water</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Glacé</td>\n",
       "      <td>PS</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.232137</td>\n",
       "      <td>0.002296</td>\n",
       "      <td>0.16036</td>\n",
       "      <td>0.99043</td>\n",
       "      <td>200.36793</td>\n",
       "      <td>1566.7008</td>\n",
       "      <td>6.517015</td>\n",
       "      <td>115.62597</td>\n",
       "      <td>0.000041</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2516</th>\n",
       "      <td>26146</td>\n",
       "      <td>26146</td>\n",
       "      <td>viandes, œufs, poissons</td>\n",
       "      <td>poissons crus</td>\n",
       "      <td>Vivaneau, cru</td>\n",
       "      <td>Snapper, raw</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Glacé</td>\n",
       "      <td>PS</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.095432</td>\n",
       "      <td>0.000677</td>\n",
       "      <td>0.022499</td>\n",
       "      <td>0.24429</td>\n",
       "      <td>24.102134</td>\n",
       "      <td>14.699972</td>\n",
       "      <td>0.559311</td>\n",
       "      <td>60.601249</td>\n",
       "      <td>0.000163</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2517</th>\n",
       "      <td>26147</td>\n",
       "      <td>26147</td>\n",
       "      <td>viandes, œufs, poissons</td>\n",
       "      <td>poissons cuits</td>\n",
       "      <td>Vivaneau, cuit</td>\n",
       "      <td>Snapper, cooked</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Glacé</td>\n",
       "      <td>PP</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.116709</td>\n",
       "      <td>0.000867</td>\n",
       "      <td>0.027545</td>\n",
       "      <td>0.298742</td>\n",
       "      <td>29.317396</td>\n",
       "      <td>18.678957</td>\n",
       "      <td>0.642664</td>\n",
       "      <td>86.252396</td>\n",
       "      <td>0.000203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2518</th>\n",
       "      <td>25512</td>\n",
       "      <td>25512</td>\n",
       "      <td>viandes, œufs, poissons</td>\n",
       "      <td>autres produits à base de viande</td>\n",
       "      <td>Volaille, croquette panée ou nuggets</td>\n",
       "      <td>Poultry nuggets</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Glacé</td>\n",
       "      <td>PS</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.102578</td>\n",
       "      <td>0.000987</td>\n",
       "      <td>0.026625</td>\n",
       "      <td>0.436752</td>\n",
       "      <td>86.087428</td>\n",
       "      <td>342.12372</td>\n",
       "      <td>4.029214</td>\n",
       "      <td>96.404511</td>\n",
       "      <td>0.000025</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2517 rows × 29 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Code\\nAGB Code\\nCIQUAL                        Groupe d'aliment  \\\n",
       "2        11084        11084  aides culinaires et ingrédients divers   \n",
       "3        11023        11023  aides culinaires et ingrédients divers   \n",
       "4        11000        11000  aides culinaires et ingrédients divers   \n",
       "5        11093        11093  aides culinaires et ingrédients divers   \n",
       "6        20995        20995  aides culinaires et ingrédients divers   \n",
       "...        ...          ...                                     ...   \n",
       "2514      6535         6535                 viandes, œufs, poissons   \n",
       "2515      6582         6582                 viandes, œufs, poissons   \n",
       "2516     26146        26146                 viandes, œufs, poissons   \n",
       "2517     26147        26147                 viandes, œufs, poissons   \n",
       "2518     25512        25512                 viandes, œufs, poissons   \n",
       "\n",
       "                 Sous-groupe d'aliment  \\\n",
       "2                               algues   \n",
       "3                               herbes   \n",
       "4                               herbes   \n",
       "5                               herbes   \n",
       "6                               algues   \n",
       "...                                ...   \n",
       "2514                     viandes crues   \n",
       "2515                    viandes cuites   \n",
       "2516                     poissons crus   \n",
       "2517                    poissons cuits   \n",
       "2518  autres produits à base de viande   \n",
       "\n",
       "                             Nom du Produit en Français  \\\n",
       "2                                     Agar (algue), cru   \n",
       "3                                     Ail séché, poudre   \n",
       "4                                              Ail, cru   \n",
       "5                                          Aneth, frais   \n",
       "6     Ao-nori (Enteromorpha sp.), séchée ou déshydratée   \n",
       "...                                                 ...   \n",
       "2514                      Veau, steak haché 20% MG, cru   \n",
       "2515                 Veau, tête, bouillie/cuite à l'eau   \n",
       "2516                                      Vivaneau, cru   \n",
       "2517                                     Vivaneau, cuit   \n",
       "2518               Volaille, croquette panée ou nuggets   \n",
       "\n",
       "                                               LCI Name  \\\n",
       "2                                    Seaweed, agar, raw   \n",
       "3                                 Garlic, powder, dried   \n",
       "4                                         Garlic, fresh   \n",
       "5                                           Dill, fresh   \n",
       "6     Sea lettuce (Enteromorpha sp.), dried or dehyd...   \n",
       "...                                                 ...   \n",
       "2514                   Veal, minced steak, 20% fat, raw   \n",
       "2515                 Calf, head, boiled/cooked in water   \n",
       "2516                                       Snapper, raw   \n",
       "2517                                    Snapper, cooked   \n",
       "2518                                    Poultry nuggets   \n",
       "\n",
       "     code saison (0 : hors saison ; 1 : de saison ; 2 : mix de consommation FR)  \\\n",
       "2                                                     2                           \n",
       "3                                                     2                           \n",
       "4                                                     2                           \n",
       "5                                                     2                           \n",
       "6                                                     2                           \n",
       "...                                                 ...                           \n",
       "2514                                                  2                           \n",
       "2515                                                  2                           \n",
       "2516                                                  2                           \n",
       "2517                                                  2                           \n",
       "2518                                                  2                           \n",
       "\n",
       "     code avion (1 : par avion)       Livraison Matériau d'emballage  ...  \\\n",
       "2                             0  Ambiant (long)                 LDPE  ...   \n",
       "3                             0  Ambiant (long)                Verre  ...   \n",
       "4                             0  Ambiant (long)      Pas d'emballage  ...   \n",
       "5                             0  Ambiant (long)                 LDPE  ...   \n",
       "6                             0  Ambiant (long)                 LDPE  ...   \n",
       "...                         ...             ...                  ...  ...   \n",
       "2514                          0           Glacé                   PS  ...   \n",
       "2515                          0           Glacé                   PS  ...   \n",
       "2516                          0           Glacé                   PS  ...   \n",
       "2517                          0           Glacé                   PP  ...   \n",
       "2518                          0           Glacé                   PS  ...   \n",
       "\n",
       "     Effets toxicologiques sur la santé humaine : substances cancérogènes  \\\n",
       "2                                                   0.0                     \n",
       "3                                                   0.0                     \n",
       "4                                                   0.0                     \n",
       "5                                                   0.0                     \n",
       "6                                                   0.0                     \n",
       "...                                                 ...                     \n",
       "2514                                                0.0                     \n",
       "2515                                                0.0                     \n",
       "2516                                                0.0                     \n",
       "2517                                                0.0                     \n",
       "2518                                                0.0                     \n",
       "\n",
       "     Acidification terrestre et eaux douces Eutrophisation eaux douces  \\\n",
       "2                                  0.099733                   0.001868   \n",
       "3                                  0.006222                   0.000124   \n",
       "4                                  0.002005                   0.000068   \n",
       "5                                  0.008112                   0.000203   \n",
       "6                                  0.099733                   0.001868   \n",
       "...                                     ...                        ...   \n",
       "2514                               0.224717                   0.002212   \n",
       "2515                               0.232137                   0.002296   \n",
       "2516                               0.095432                   0.000677   \n",
       "2517                               0.116709                   0.000867   \n",
       "2518                               0.102578                   0.000987   \n",
       "\n",
       "     Eutrophisation marine Eutrophisation terrestre  \\\n",
       "2                  0.01328                  0.12735   \n",
       "3                  0.00232                 0.012695   \n",
       "4                 0.002123                 0.006281   \n",
       "5                  0.00405                 0.031181   \n",
       "6                  0.01328                  0.12735   \n",
       "...                    ...                      ...   \n",
       "2514              0.155523                  0.96026   \n",
       "2515               0.16036                  0.99043   \n",
       "2516              0.022499                  0.24429   \n",
       "2517              0.027545                 0.298742   \n",
       "2518              0.026625                 0.436752   \n",
       "\n",
       "     Écotoxicité pour écosystèmes aquatiques d'eau douce Utilisation du sol  \\\n",
       "2                                             44.555153            26.47619   \n",
       "3                                               5.83212           20.223652   \n",
       "4                                              4.092332           18.454615   \n",
       "5                                              5.681342           36.373722   \n",
       "6                                             44.555153            26.47619   \n",
       "...                                                 ...                 ...   \n",
       "2514                                          192.77924           1521.1493   \n",
       "2515                                          200.36793           1566.7008   \n",
       "2516                                          24.102134           14.699972   \n",
       "2517                                          29.317396           18.678957   \n",
       "2518                                          86.087428           342.12372   \n",
       "\n",
       "     Épuisement des ressources eau Épuisement des ressources énergétiques  \\\n",
       "2                         3.102487                              315.05717   \n",
       "3                         2.520528                              12.665447   \n",
       "4                         3.021753                               6.230187   \n",
       "5                         5.292121                              12.553109   \n",
       "6                         3.102487                              315.05717   \n",
       "...                            ...                                    ...   \n",
       "2514                      6.276344                              111.47848   \n",
       "2515                      6.517015                              115.62597   \n",
       "2516                      0.559311                              60.601249   \n",
       "2517                      0.642664                              86.252396   \n",
       "2518                      4.029214                              96.404511   \n",
       "\n",
       "     Épuisement des ressources minéraux  \n",
       "2                              0.000088  \n",
       "3                              0.000007  \n",
       "4                              0.000004  \n",
       "5                              0.000005  \n",
       "6                              0.000088  \n",
       "...                                 ...  \n",
       "2514                           0.000038  \n",
       "2515                           0.000041  \n",
       "2516                           0.000163  \n",
       "2517                           0.000203  \n",
       "2518                           0.000025  \n",
       "\n",
       "[2517 rows x 29 columns]"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# dfsynthese.drop(\"Code\\nAGB\", axis=1, inplace=True)\n",
    "dfsynthese"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "# dfdetail_etape.drop(\"Code AGB\", axis=1, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "# dfdetail_ingredient.drop(\"Ciqual \\nAGB\", axis=1, inplace=True)"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Suite audit des données"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(2517, 29)"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfsynthese.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(2517, 13)"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfdetail_etape.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(6856, 27)"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfdetail_ingredient.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "RangeIndex(start=0, stop=6856, step=1)"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfdetail_ingredient = dfdetail_ingredient.reset_index(drop=True)\n",
    "dfdetail_ingredient.index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "RangeIndex(start=2, stop=2519, step=1)"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfsynthese.index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [],
   "source": [
    "dfsynthese = dfsynthese.reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "RangeIndex(start=0, stop=2517, step=1)"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfsynthese.index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [],
   "source": [
    "dfdetail_etape = dfdetail_etape.reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "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>Code\\nAGB</th>\n",
       "      <th>Code\\nCIQUAL</th>\n",
       "      <th>Groupe d'aliment</th>\n",
       "      <th>Sous-groupe d'aliment</th>\n",
       "      <th>Nom du Produit en Français</th>\n",
       "      <th>LCI Name</th>\n",
       "      <th>code saison (0 : hors saison ; 1 : de saison ; 2 : mix de consommation FR)</th>\n",
       "      <th>code avion (1 : par avion)</th>\n",
       "      <th>Livraison</th>\n",
       "      <th>Matériau d'emballage</th>\n",
       "      <th>...</th>\n",
       "      <th>Effets toxicologiques sur la santé humaine : substances cancérogènes</th>\n",
       "      <th>Acidification terrestre et eaux douces</th>\n",
       "      <th>Eutrophisation eaux douces</th>\n",
       "      <th>Eutrophisation marine</th>\n",
       "      <th>Eutrophisation terrestre</th>\n",
       "      <th>Écotoxicité pour écosystèmes aquatiques d'eau douce</th>\n",
       "      <th>Utilisation du sol</th>\n",
       "      <th>Épuisement des ressources eau</th>\n",
       "      <th>Épuisement des ressources énergétiques</th>\n",
       "      <th>Épuisement des ressources minéraux</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>11084</td>\n",
       "      <td>11084</td>\n",
       "      <td>aides culinaires et ingrédients divers</td>\n",
       "      <td>algues</td>\n",
       "      <td>Agar (algue), cru</td>\n",
       "      <td>Seaweed, agar, raw</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Ambiant (long)</td>\n",
       "      <td>LDPE</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.099733</td>\n",
       "      <td>0.001868</td>\n",
       "      <td>0.01328</td>\n",
       "      <td>0.12735</td>\n",
       "      <td>44.555153</td>\n",
       "      <td>26.47619</td>\n",
       "      <td>3.102487</td>\n",
       "      <td>315.05717</td>\n",
       "      <td>0.000088</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>11023</td>\n",
       "      <td>11023</td>\n",
       "      <td>aides culinaires et ingrédients divers</td>\n",
       "      <td>herbes</td>\n",
       "      <td>Ail séché, poudre</td>\n",
       "      <td>Garlic, powder, dried</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Ambiant (long)</td>\n",
       "      <td>Verre</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.006222</td>\n",
       "      <td>0.000124</td>\n",
       "      <td>0.00232</td>\n",
       "      <td>0.012695</td>\n",
       "      <td>5.83212</td>\n",
       "      <td>20.223652</td>\n",
       "      <td>2.520528</td>\n",
       "      <td>12.665447</td>\n",
       "      <td>0.000007</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>11000</td>\n",
       "      <td>11000</td>\n",
       "      <td>aides culinaires et ingrédients divers</td>\n",
       "      <td>herbes</td>\n",
       "      <td>Ail, cru</td>\n",
       "      <td>Garlic, fresh</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Ambiant (long)</td>\n",
       "      <td>Pas d'emballage</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.002005</td>\n",
       "      <td>0.000068</td>\n",
       "      <td>0.002123</td>\n",
       "      <td>0.006281</td>\n",
       "      <td>4.092332</td>\n",
       "      <td>18.454615</td>\n",
       "      <td>3.021753</td>\n",
       "      <td>6.230187</td>\n",
       "      <td>0.000004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>11093</td>\n",
       "      <td>11093</td>\n",
       "      <td>aides culinaires et ingrédients divers</td>\n",
       "      <td>herbes</td>\n",
       "      <td>Aneth, frais</td>\n",
       "      <td>Dill, fresh</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Ambiant (long)</td>\n",
       "      <td>LDPE</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.008112</td>\n",
       "      <td>0.000203</td>\n",
       "      <td>0.00405</td>\n",
       "      <td>0.031181</td>\n",
       "      <td>5.681342</td>\n",
       "      <td>36.373722</td>\n",
       "      <td>5.292121</td>\n",
       "      <td>12.553109</td>\n",
       "      <td>0.000005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>20995</td>\n",
       "      <td>20995</td>\n",
       "      <td>aides culinaires et ingrédients divers</td>\n",
       "      <td>algues</td>\n",
       "      <td>Ao-nori (Enteromorpha sp.), séchée ou déshydratée</td>\n",
       "      <td>Sea lettuce (Enteromorpha sp.), dried or dehyd...</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Ambiant (long)</td>\n",
       "      <td>LDPE</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.099733</td>\n",
       "      <td>0.001868</td>\n",
       "      <td>0.01328</td>\n",
       "      <td>0.12735</td>\n",
       "      <td>44.555153</td>\n",
       "      <td>26.47619</td>\n",
       "      <td>3.102487</td>\n",
       "      <td>315.05717</td>\n",
       "      <td>0.000088</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>2512</th>\n",
       "      <td>6535</td>\n",
       "      <td>6535</td>\n",
       "      <td>viandes, œufs, poissons</td>\n",
       "      <td>viandes crues</td>\n",
       "      <td>Veau, steak haché 20% MG, cru</td>\n",
       "      <td>Veal, minced steak, 20% fat, raw</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Glacé</td>\n",
       "      <td>PS</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.224717</td>\n",
       "      <td>0.002212</td>\n",
       "      <td>0.155523</td>\n",
       "      <td>0.96026</td>\n",
       "      <td>192.77924</td>\n",
       "      <td>1521.1493</td>\n",
       "      <td>6.276344</td>\n",
       "      <td>111.47848</td>\n",
       "      <td>0.000038</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2513</th>\n",
       "      <td>6582</td>\n",
       "      <td>6582</td>\n",
       "      <td>viandes, œufs, poissons</td>\n",
       "      <td>viandes cuites</td>\n",
       "      <td>Veau, tête, bouillie/cuite à l'eau</td>\n",
       "      <td>Calf, head, boiled/cooked in water</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Glacé</td>\n",
       "      <td>PS</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.232137</td>\n",
       "      <td>0.002296</td>\n",
       "      <td>0.16036</td>\n",
       "      <td>0.99043</td>\n",
       "      <td>200.36793</td>\n",
       "      <td>1566.7008</td>\n",
       "      <td>6.517015</td>\n",
       "      <td>115.62597</td>\n",
       "      <td>0.000041</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2514</th>\n",
       "      <td>26146</td>\n",
       "      <td>26146</td>\n",
       "      <td>viandes, œufs, poissons</td>\n",
       "      <td>poissons crus</td>\n",
       "      <td>Vivaneau, cru</td>\n",
       "      <td>Snapper, raw</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Glacé</td>\n",
       "      <td>PS</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.095432</td>\n",
       "      <td>0.000677</td>\n",
       "      <td>0.022499</td>\n",
       "      <td>0.24429</td>\n",
       "      <td>24.102134</td>\n",
       "      <td>14.699972</td>\n",
       "      <td>0.559311</td>\n",
       "      <td>60.601249</td>\n",
       "      <td>0.000163</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2515</th>\n",
       "      <td>26147</td>\n",
       "      <td>26147</td>\n",
       "      <td>viandes, œufs, poissons</td>\n",
       "      <td>poissons cuits</td>\n",
       "      <td>Vivaneau, cuit</td>\n",
       "      <td>Snapper, cooked</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Glacé</td>\n",
       "      <td>PP</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.116709</td>\n",
       "      <td>0.000867</td>\n",
       "      <td>0.027545</td>\n",
       "      <td>0.298742</td>\n",
       "      <td>29.317396</td>\n",
       "      <td>18.678957</td>\n",
       "      <td>0.642664</td>\n",
       "      <td>86.252396</td>\n",
       "      <td>0.000203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2516</th>\n",
       "      <td>25512</td>\n",
       "      <td>25512</td>\n",
       "      <td>viandes, œufs, poissons</td>\n",
       "      <td>autres produits à base de viande</td>\n",
       "      <td>Volaille, croquette panée ou nuggets</td>\n",
       "      <td>Poultry nuggets</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>Glacé</td>\n",
       "      <td>PS</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.102578</td>\n",
       "      <td>0.000987</td>\n",
       "      <td>0.026625</td>\n",
       "      <td>0.436752</td>\n",
       "      <td>86.087428</td>\n",
       "      <td>342.12372</td>\n",
       "      <td>4.029214</td>\n",
       "      <td>96.404511</td>\n",
       "      <td>0.000025</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2517 rows × 29 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Code\\nAGB Code\\nCIQUAL                        Groupe d'aliment  \\\n",
       "0        11084        11084  aides culinaires et ingrédients divers   \n",
       "1        11023        11023  aides culinaires et ingrédients divers   \n",
       "2        11000        11000  aides culinaires et ingrédients divers   \n",
       "3        11093        11093  aides culinaires et ingrédients divers   \n",
       "4        20995        20995  aides culinaires et ingrédients divers   \n",
       "...        ...          ...                                     ...   \n",
       "2512      6535         6535                 viandes, œufs, poissons   \n",
       "2513      6582         6582                 viandes, œufs, poissons   \n",
       "2514     26146        26146                 viandes, œufs, poissons   \n",
       "2515     26147        26147                 viandes, œufs, poissons   \n",
       "2516     25512        25512                 viandes, œufs, poissons   \n",
       "\n",
       "                 Sous-groupe d'aliment  \\\n",
       "0                               algues   \n",
       "1                               herbes   \n",
       "2                               herbes   \n",
       "3                               herbes   \n",
       "4                               algues   \n",
       "...                                ...   \n",
       "2512                     viandes crues   \n",
       "2513                    viandes cuites   \n",
       "2514                     poissons crus   \n",
       "2515                    poissons cuits   \n",
       "2516  autres produits à base de viande   \n",
       "\n",
       "                             Nom du Produit en Français  \\\n",
       "0                                     Agar (algue), cru   \n",
       "1                                     Ail séché, poudre   \n",
       "2                                              Ail, cru   \n",
       "3                                          Aneth, frais   \n",
       "4     Ao-nori (Enteromorpha sp.), séchée ou déshydratée   \n",
       "...                                                 ...   \n",
       "2512                      Veau, steak haché 20% MG, cru   \n",
       "2513                 Veau, tête, bouillie/cuite à l'eau   \n",
       "2514                                      Vivaneau, cru   \n",
       "2515                                     Vivaneau, cuit   \n",
       "2516               Volaille, croquette panée ou nuggets   \n",
       "\n",
       "                                               LCI Name  \\\n",
       "0                                    Seaweed, agar, raw   \n",
       "1                                 Garlic, powder, dried   \n",
       "2                                         Garlic, fresh   \n",
       "3                                           Dill, fresh   \n",
       "4     Sea lettuce (Enteromorpha sp.), dried or dehyd...   \n",
       "...                                                 ...   \n",
       "2512                   Veal, minced steak, 20% fat, raw   \n",
       "2513                 Calf, head, boiled/cooked in water   \n",
       "2514                                       Snapper, raw   \n",
       "2515                                    Snapper, cooked   \n",
       "2516                                    Poultry nuggets   \n",
       "\n",
       "     code saison (0 : hors saison ; 1 : de saison ; 2 : mix de consommation FR)  \\\n",
       "0                                                     2                           \n",
       "1                                                     2                           \n",
       "2                                                     2                           \n",
       "3                                                     2                           \n",
       "4                                                     2                           \n",
       "...                                                 ...                           \n",
       "2512                                                  2                           \n",
       "2513                                                  2                           \n",
       "2514                                                  2                           \n",
       "2515                                                  2                           \n",
       "2516                                                  2                           \n",
       "\n",
       "     code avion (1 : par avion)       Livraison Matériau d'emballage  ...  \\\n",
       "0                             0  Ambiant (long)                 LDPE  ...   \n",
       "1                             0  Ambiant (long)                Verre  ...   \n",
       "2                             0  Ambiant (long)      Pas d'emballage  ...   \n",
       "3                             0  Ambiant (long)                 LDPE  ...   \n",
       "4                             0  Ambiant (long)                 LDPE  ...   \n",
       "...                         ...             ...                  ...  ...   \n",
       "2512                          0           Glacé                   PS  ...   \n",
       "2513                          0           Glacé                   PS  ...   \n",
       "2514                          0           Glacé                   PS  ...   \n",
       "2515                          0           Glacé                   PP  ...   \n",
       "2516                          0           Glacé                   PS  ...   \n",
       "\n",
       "     Effets toxicologiques sur la santé humaine : substances cancérogènes  \\\n",
       "0                                                   0.0                     \n",
       "1                                                   0.0                     \n",
       "2                                                   0.0                     \n",
       "3                                                   0.0                     \n",
       "4                                                   0.0                     \n",
       "...                                                 ...                     \n",
       "2512                                                0.0                     \n",
       "2513                                                0.0                     \n",
       "2514                                                0.0                     \n",
       "2515                                                0.0                     \n",
       "2516                                                0.0                     \n",
       "\n",
       "     Acidification terrestre et eaux douces Eutrophisation eaux douces  \\\n",
       "0                                  0.099733                   0.001868   \n",
       "1                                  0.006222                   0.000124   \n",
       "2                                  0.002005                   0.000068   \n",
       "3                                  0.008112                   0.000203   \n",
       "4                                  0.099733                   0.001868   \n",
       "...                                     ...                        ...   \n",
       "2512                               0.224717                   0.002212   \n",
       "2513                               0.232137                   0.002296   \n",
       "2514                               0.095432                   0.000677   \n",
       "2515                               0.116709                   0.000867   \n",
       "2516                               0.102578                   0.000987   \n",
       "\n",
       "     Eutrophisation marine Eutrophisation terrestre  \\\n",
       "0                  0.01328                  0.12735   \n",
       "1                  0.00232                 0.012695   \n",
       "2                 0.002123                 0.006281   \n",
       "3                  0.00405                 0.031181   \n",
       "4                  0.01328                  0.12735   \n",
       "...                    ...                      ...   \n",
       "2512              0.155523                  0.96026   \n",
       "2513               0.16036                  0.99043   \n",
       "2514              0.022499                  0.24429   \n",
       "2515              0.027545                 0.298742   \n",
       "2516              0.026625                 0.436752   \n",
       "\n",
       "     Écotoxicité pour écosystèmes aquatiques d'eau douce Utilisation du sol  \\\n",
       "0                                             44.555153            26.47619   \n",
       "1                                               5.83212           20.223652   \n",
       "2                                              4.092332           18.454615   \n",
       "3                                              5.681342           36.373722   \n",
       "4                                             44.555153            26.47619   \n",
       "...                                                 ...                 ...   \n",
       "2512                                          192.77924           1521.1493   \n",
       "2513                                          200.36793           1566.7008   \n",
       "2514                                          24.102134           14.699972   \n",
       "2515                                          29.317396           18.678957   \n",
       "2516                                          86.087428           342.12372   \n",
       "\n",
       "     Épuisement des ressources eau Épuisement des ressources énergétiques  \\\n",
       "0                         3.102487                              315.05717   \n",
       "1                         2.520528                              12.665447   \n",
       "2                         3.021753                               6.230187   \n",
       "3                         5.292121                              12.553109   \n",
       "4                         3.102487                              315.05717   \n",
       "...                            ...                                    ...   \n",
       "2512                      6.276344                              111.47848   \n",
       "2513                      6.517015                              115.62597   \n",
       "2514                      0.559311                              60.601249   \n",
       "2515                      0.642664                              86.252396   \n",
       "2516                      4.029214                              96.404511   \n",
       "\n",
       "     Épuisement des ressources minéraux  \n",
       "0                              0.000088  \n",
       "1                              0.000007  \n",
       "2                              0.000004  \n",
       "3                              0.000005  \n",
       "4                              0.000088  \n",
       "...                                 ...  \n",
       "2512                           0.000038  \n",
       "2513                           0.000041  \n",
       "2514                           0.000163  \n",
       "2515                           0.000203  \n",
       "2516                           0.000025  \n",
       "\n",
       "[2517 rows x 29 columns]"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfsynthese"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [],
   "source": [
    "dfsynthese.to_csv(\"data/Synthèse nettoyé.csv\", index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [],
   "source": [
    "dfdetail_etape.to_csv(\"data/detail etape.csv\", index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [],
   "source": [
    "dfdetail_ingredient.to_csv(\"data/detail ingredient.csv\", index=False)"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Verification des valeurs vides"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [],
   "source": [
    "for colonne in dfsynthese.columns:\n",
    "    valeurs_nulles_par_colonne = dfsynthese[colonne].isna().sum()\n",
    "    if valeurs_nulles_par_colonne > 0 :\n",
    "        print(colonne)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [],
   "source": [
    "for colonne in dfdetail_etape.columns:\n",
    "    valeurs_nulles_par_colonne = dfdetail_etape[colonne].isna().sum()\n",
    "    if valeurs_nulles_par_colonne > 0 :\n",
    "        print(colonne)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "venvprojetpython",
   "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.10.11"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}