ophauz_etude_sante_publique_python_notebook.ipynb

{
 "cells": [
  {
   "attachments": {},
   "cell_type": "markdown",
   "id": "2ff4f04b",
   "metadata": {},
   "source": [
    "<div style=\"display: flex; text-align:center; background-color: rgb(93,138,191);\" >\n",
    "<h1 style=\"margin: auto; padding: 30px; color: rgb(255,255,255); \">Réaliser une étude de santé publique avec Python\n",
    "</h1>\n",
    "</div>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "2946c4b3",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "024d78a7",
   "metadata": {},
   "source": [
    "<h1 style=\"margin: auto; color: rgb(93,138,191); \">Etude préliminaire des données et nettoyage\n",
    "</h1>\n",
    "</div>"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e005cad1",
   "metadata": {},
   "source": [
    "<h2 style=\"margin: auto; padding: 30px; color: rgb(93,138,191); \">- aide_ali\n",
    "</h2>\n",
    "</div>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "f767e1ea",
   "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>Pays bénéficiaire</th>\n",
       "      <th>Année</th>\n",
       "      <th>Produit</th>\n",
       "      <th>Valeur</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2013</td>\n",
       "      <td>Autres non-céréales</td>\n",
       "      <td>682</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2014</td>\n",
       "      <td>Autres non-céréales</td>\n",
       "      <td>335</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2013</td>\n",
       "      <td>Blé et Farin</td>\n",
       "      <td>39224</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2014</td>\n",
       "      <td>Blé et Farin</td>\n",
       "      <td>15160</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2013</td>\n",
       "      <td>Céréales</td>\n",
       "      <td>40504</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Pays bénéficiaire  Année              Produit  Valeur\n",
       "0       Afghanistan   2013  Autres non-céréales     682\n",
       "1       Afghanistan   2014  Autres non-céréales     335\n",
       "2       Afghanistan   2013         Blé et Farin   39224\n",
       "3       Afghanistan   2014         Blé et Farin   15160\n",
       "4       Afghanistan   2013             Céréales   40504"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "aide_ali.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "5ee0cc3e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Pays bénéficiaire    object\n",
       "Année                 int64\n",
       "Produit              object\n",
       "Valeur                int64\n",
       "dtype: object"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "aide_ali.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "274db55a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Pays bénéficiaire    0.0\n",
       "Année                0.0\n",
       "Produit              0.0\n",
       "Valeur               0.0\n",
       "dtype: float64"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "aide_ali.isna().mean()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c2c9dd6d",
   "metadata": {},
   "source": [
    "<h2 style=\"margin: auto; padding: 30px; color: rgb(93,138,191); \">- dispo_ali\n",
    "</h2>\n",
    "</div>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "b57562b2",
   "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>Zone</th>\n",
       "      <th>Produit</th>\n",
       "      <th>Origine</th>\n",
       "      <th>Aliments pour animaux</th>\n",
       "      <th>Autres Utilisations</th>\n",
       "      <th>Disponibilité alimentaire (Kcal/personne/jour)</th>\n",
       "      <th>Disponibilité alimentaire en quantité (kg/personne/an)</th>\n",
       "      <th>Disponibilité de matière grasse en quantité (g/personne/jour)</th>\n",
       "      <th>Disponibilité de protéines en quantité (g/personne/jour)</th>\n",
       "      <th>Disponibilité intérieure</th>\n",
       "      <th>Exportations - Quantité</th>\n",
       "      <th>Importations - Quantité</th>\n",
       "      <th>Nourriture</th>\n",
       "      <th>Pertes</th>\n",
       "      <th>Production</th>\n",
       "      <th>Semences</th>\n",
       "      <th>Traitement</th>\n",
       "      <th>Variation de stock</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>Abats Comestible</td>\n",
       "      <td>animale</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.72</td>\n",
       "      <td>0.20</td>\n",
       "      <td>0.77</td>\n",
       "      <td>53.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>53.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>53.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>Agrumes, Autres</td>\n",
       "      <td>vegetale</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.29</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.02</td>\n",
       "      <td>41.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>Aliments pour enfants</td>\n",
       "      <td>vegetale</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.06</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.03</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</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>3</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>Ananas</td>\n",
       "      <td>vegetale</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</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>4</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>Bananes</td>\n",
       "      <td>vegetale</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.70</td>\n",
       "      <td>0.02</td>\n",
       "      <td>0.05</td>\n",
       "      <td>82.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>82.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Zone                Produit   Origine  Aliments pour animaux  \\\n",
       "0  Afghanistan       Abats Comestible   animale                    NaN   \n",
       "1  Afghanistan        Agrumes, Autres  vegetale                    NaN   \n",
       "2  Afghanistan  Aliments pour enfants  vegetale                    NaN   \n",
       "3  Afghanistan                 Ananas  vegetale                    NaN   \n",
       "4  Afghanistan                Bananes  vegetale                    NaN   \n",
       "\n",
       "   Autres Utilisations  Disponibilité alimentaire (Kcal/personne/jour)  \\\n",
       "0                  NaN                                             5.0   \n",
       "1                  NaN                                             1.0   \n",
       "2                  NaN                                             1.0   \n",
       "3                  NaN                                             0.0   \n",
       "4                  NaN                                             4.0   \n",
       "\n",
       "   Disponibilité alimentaire en quantité (kg/personne/an)  \\\n",
       "0                                               1.72        \n",
       "1                                               1.29        \n",
       "2                                               0.06        \n",
       "3                                               0.00        \n",
       "4                                               2.70        \n",
       "\n",
       "   Disponibilité de matière grasse en quantité (g/personne/jour)  \\\n",
       "0                                               0.20               \n",
       "1                                               0.01               \n",
       "2                                               0.01               \n",
       "3                                                NaN               \n",
       "4                                               0.02               \n",
       "\n",
       "   Disponibilité de protéines en quantité (g/personne/jour)  \\\n",
       "0                                               0.77          \n",
       "1                                               0.02          \n",
       "2                                               0.03          \n",
       "3                                                NaN          \n",
       "4                                               0.05          \n",
       "\n",
       "   Disponibilité intérieure  Exportations - Quantité  Importations - Quantité  \\\n",
       "0                      53.0                      NaN                      NaN   \n",
       "1                      41.0                      2.0                     40.0   \n",
       "2                       2.0                      NaN                      2.0   \n",
       "3                       0.0                      NaN                      0.0   \n",
       "4                      82.0                      NaN                     82.0   \n",
       "\n",
       "   Nourriture  Pertes  Production  Semences  Traitement  Variation de stock  \n",
       "0        53.0     NaN        53.0       NaN         NaN                 NaN  \n",
       "1        39.0     2.0         3.0       NaN         NaN                 NaN  \n",
       "2         2.0     NaN         NaN       NaN         NaN                 NaN  \n",
       "3         0.0     NaN         NaN       NaN         NaN                 NaN  \n",
       "4        82.0     NaN         NaN       NaN         NaN                 NaN  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dispo_ali.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "6fde7a81",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Zone                                                              object\n",
       "Produit                                                           object\n",
       "Origine                                                           object\n",
       "Aliments pour animaux                                            float64\n",
       "Autres Utilisations                                              float64\n",
       "Disponibilité alimentaire (Kcal/personne/jour)                   float64\n",
       "Disponibilité alimentaire en quantité (kg/personne/an)           float64\n",
       "Disponibilité de matière grasse en quantité (g/personne/jour)    float64\n",
       "Disponibilité de protéines en quantité (g/personne/jour)         float64\n",
       "Disponibilité intérieure                                         float64\n",
       "Exportations - Quantité                                          float64\n",
       "Importations - Quantité                                          float64\n",
       "Nourriture                                                       float64\n",
       "Pertes                                                           float64\n",
       "Production                                                       float64\n",
       "Semences                                                         float64\n",
       "Traitement                                                       float64\n",
       "Variation de stock                                               float64\n",
       "dtype: object"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dispo_ali.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "c2e7c74a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Zone                                                             0.000000\n",
       "Produit                                                          0.000000\n",
       "Origine                                                          0.000000\n",
       "Aliments pour animaux                                            0.825697\n",
       "Autres Utilisations                                              0.647805\n",
       "Disponibilité alimentaire (Kcal/personne/jour)                   0.087408\n",
       "Disponibilité alimentaire en quantité (kg/personne/an)           0.101890\n",
       "Disponibilité de matière grasse en quantité (g/personne/jour)    0.244217\n",
       "Disponibilité de protéines en quantité (g/personne/jour)         0.259148\n",
       "Disponibilité intérieure                                         0.014290\n",
       "Exportations - Quantité                                          0.216533\n",
       "Importations - Quantité                                          0.048254\n",
       "Nourriture                                                       0.101890\n",
       "Pertes                                                           0.725857\n",
       "Production                                                       0.411727\n",
       "Semences                                                         0.866004\n",
       "Traitement                                                       0.853124\n",
       "Variation de stock                                               0.565780\n",
       "dtype: float64"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dispo_ali.isna().mean()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c04d0e87",
   "metadata": {},
   "source": [
    "<h2 style=\"margin: auto; padding: 30px; color: rgb(93,138,191); \">- popu\n",
    "</h2>\n",
    "</div>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "c4cd24d7",
   "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>Zone</th>\n",
       "      <th>Année</th>\n",
       "      <th>Valeur</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2013</td>\n",
       "      <td>32269.589</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2014</td>\n",
       "      <td>33370.794</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2015</td>\n",
       "      <td>34413.603</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2016</td>\n",
       "      <td>35383.032</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2017</td>\n",
       "      <td>36296.113</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Zone  Année     Valeur\n",
       "0  Afghanistan   2013  32269.589\n",
       "1  Afghanistan   2014  33370.794\n",
       "2  Afghanistan   2015  34413.603\n",
       "3  Afghanistan   2016  35383.032\n",
       "4  Afghanistan   2017  36296.113"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "popu.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "79de3933",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Zone       object\n",
       "Année       int64\n",
       "Valeur    float64\n",
       "dtype: object"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "popu.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "7ef6cd72",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Zone      0.0\n",
       "Année     0.0\n",
       "Valeur    0.0\n",
       "dtype: float64"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "popu.isna().mean()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "1684ad81",
   "metadata": {},
   "source": [
    "<h2 style=\"margin: auto; padding: 30px; color: rgb(93,138,191); \">- sous_nutri\n",
    "</h2>\n",
    "</div>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "bd8c426f",
   "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>Zone</th>\n",
       "      <th>Année</th>\n",
       "      <th>Valeur</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2012-2014</td>\n",
       "      <td>8.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2013-2015</td>\n",
       "      <td>8.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2014-2016</td>\n",
       "      <td>8.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2015-2017</td>\n",
       "      <td>9.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2016-2018</td>\n",
       "      <td>10.5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Zone      Année Valeur\n",
       "0  Afghanistan  2012-2014    8.6\n",
       "1  Afghanistan  2013-2015    8.8\n",
       "2  Afghanistan  2014-2016    8.9\n",
       "3  Afghanistan  2015-2017    9.7\n",
       "4  Afghanistan  2016-2018   10.5"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sous_nutri.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "339131b2",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Zone      object\n",
       "Année     object\n",
       "Valeur    object\n",
       "dtype: object"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sous_nutri.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "83e1b361",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0        8.6\n",
       "1        8.8\n",
       "2        8.9\n",
       "3        9.7\n",
       "4       10.5\n",
       "        ... \n",
       "1213     NaN\n",
       "1214     NaN\n",
       "1215     NaN\n",
       "1216     NaN\n",
       "1217     NaN\n",
       "Name: Valeur, Length: 1218, dtype: object"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sous_nutri['Valeur']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "fa433f7b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['8.6', '8.8', '8.9', '9.7', '10.5', '11.1', '2.2', '2.5', '2.8',\n",
       "       '3', '3.1', '3.3', '0.1', '1.3', '1.2', nan, '7.6', '6.2', '5.3',\n",
       "       '5.6', '5.8', '5.7', '1.5', '1.6', '1.1', '1.7', '<0.1', '21.7',\n",
       "       '22.4', '23.3', '22.3', '21.5', '20.9', '0.8', '2', '1.9', '1.8',\n",
       "       '0.4', '0.5', '0.3', '0.2', '3.2', '3.4', '3.6', '3.8', '2.1',\n",
       "       '2.3', '2.4', '0.6', '0.7', '0.9', '3.9', '2.7', '1.4', '4.8',\n",
       "       '4.6', '4.9', '5', '4.4', '4.3', '4.2', '4.5', '26.2', '24.3',\n",
       "       '21.3', '21.1', '2.9', '5.1', '5.2', '5.4', '203.8', '198.3',\n",
       "       '193.1', '190.9', '190.1', '189.2', '23.6', '24', '24.1', '3.7',\n",
       "       '7.3', '7.8', '8.4', '9', '9.1', '10.1', '10', '10.7', '11.5',\n",
       "       '11.9', '11.8', '8.7', '10.3', '11', '1', '5.5', '6.8', '7.9',\n",
       "       '5.9', '7', '9.2', '9.4', '9.6', '6.7', '7.1', '7.2', '14.7',\n",
       "       '17.4', '20.2', '22.2', '22.8', '24.6', '31.1', '28.5', '25.4',\n",
       "       '24.8', '26.1', '14.5', '15.4', '16.5', '15.8', '15.7', '10.8',\n",
       "       '11.2', '11.6', '12', '12.2', '13.5', '13.2', '12.8', '13', '13.4',\n",
       "       '14.1', '4.1', '6.1', '6', '6.5', '2.6', '8', '8.3'], dtype=object)"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sous_nutri['Valeur'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "eedb475a",
   "metadata": {},
   "outputs": [],
   "source": [
    "sous_nutri.loc[sous_nutri['Valeur'] == '<0.1', 'Valeur'] = 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "13b48551",
   "metadata": {},
   "outputs": [],
   "source": [
    "sous_nutri['Valeur'] = pd.to_numeric(sous_nutri['Valeur'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "fb92b0c2",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Zone       object\n",
       "Année      object\n",
       "Valeur    float64\n",
       "dtype: object"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sous_nutri.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "5068766c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Zone      0.000000\n",
       "Année     0.000000\n",
       "Valeur    0.487685\n",
       "dtype: float64"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sous_nutri.isna().mean()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "4961d97f",
   "metadata": {},
   "source": [
    "<h1 style=\"margin: auto; color: rgb(93,138,191); \">Marc 1 / la proportion de personnes en état de sous-nutrition en 2017\n",
    "</h1>\n",
    "</div>"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "466c576e",
   "metadata": {},
   "source": [
    "### on prépare les dataframe sous_nutri et popu pour les merger en un nouveau dataframe  popu_plus_sous_nutrition_m1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "3711896f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0       2013\n",
       "1       2014\n",
       "2       2015\n",
       "3       2016\n",
       "4       2017\n",
       "        ... \n",
       "1213    2014\n",
       "1214    2015\n",
       "1215    2016\n",
       "1216    2017\n",
       "1217    2018\n",
       "Name: Année, Length: 1218, dtype: int64"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sous_nutri['Année'] = sous_nutri['Année'].replace(['2012-2014', '2013-2015', '2014-2016', '2015-2017', '2016-2018', '2017-2019'],[2013, 2014, 2015, 2016, 2017, 2018])\n",
    "sous_nutri['Année']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "a0d08b98",
   "metadata": {},
   "outputs": [],
   "source": [
    "sous_nutri['Valeur'] = sous_nutri['Valeur'].fillna(0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "2b68fb8f",
   "metadata": {},
   "outputs": [],
   "source": [
    "sous_nutri['Année'] = sous_nutri['Année'].astype('int')\n",
    "popu['Année'] = popu['Année'].astype('int')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "7fc285c7",
   "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>Zone</th>\n",
       "      <th>Année</th>\n",
       "      <th>population</th>\n",
       "      <th>population_sous_nourrie</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2013</td>\n",
       "      <td>32269.589</td>\n",
       "      <td>8.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2014</td>\n",
       "      <td>33370.794</td>\n",
       "      <td>8.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2015</td>\n",
       "      <td>34413.603</td>\n",
       "      <td>8.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2016</td>\n",
       "      <td>35383.032</td>\n",
       "      <td>9.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2017</td>\n",
       "      <td>36296.113</td>\n",
       "      <td>10.5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Zone  Année  population  population_sous_nourrie\n",
       "0  Afghanistan   2013   32269.589                      8.6\n",
       "1  Afghanistan   2014   33370.794                      8.8\n",
       "2  Afghanistan   2015   34413.603                      8.9\n",
       "3  Afghanistan   2016   35383.032                      9.7\n",
       "4  Afghanistan   2017   36296.113                     10.5"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "popu_plus_sous_nutrition_m1 = pd.merge(popu, sous_nutri, on = ['Zone', 'Année'], how ='left')\n",
    "popu_plus_sous_nutrition_m1 = popu_plus_sous_nutrition_m1.rename(columns = {'Valeur_x':'population', 'Valeur_y': 'population_sous_nourrie'})\n",
    "popu_plus_sous_nutrition_m1.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8c6e0a17",
   "metadata": {},
   "source": [
    "### on calcule la proportion de personnes sous-nourries en 2017"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "d8582566",
   "metadata": {},
   "outputs": [],
   "source": [
    "proportion_sous_nutrition_2017 = round(popu_plus_sous_nutrition_m1.loc[popu_plus_sous_nutrition_m1['Année'] == 2017, 'population_sous_nourrie'].sum() * 1000 * 100 / popu_plus_sous_nutrition_m1.loc[popu_plus_sous_nutrition_m1['Année'] == 2017, 'population'].sum(), 2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "4f8a26da",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "En 2017, la proportion de la population mondiale en état de sous-nutrition est de 7.1 %\n"
     ]
    }
   ],
   "source": [
    "print(\"En 2017, la proportion de la population mondiale en état de sous-nutrition est de \" + str(proportion_sous_nutrition_2017) + \" %\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c059910b",
   "metadata": {},
   "source": [
    "<h1 style=\"margin: auto; color: rgb(93,138,191); \">Marc 2 / le nombre théorique de personnes qui pourraient être nourries à partir de la disponibilité alimentaire mondiale\n",
    "</h1>\n",
    "</div>"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a428a8e4",
   "metadata": {},
   "source": [
    "### on calcule l'apport calorique moyen nécessaire depuis les données de la FAO : https://www.fao.org/3/y5686e/y5686e08.htm#bm08"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "cd237720",
   "metadata": {},
   "outputs": [],
   "source": [
    "apport_moyen_femmes = (1650+3850+1750+3400+1550+3150) / 6\n",
    "apport_moyen_hommes = (2100+4500+2100+4200+1700+3600) / 6\n",
    "apport_moyen = round((apport_moyen_femmes + apport_moyen_hommes) / 2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "1082b160",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "L'apport calorique journalier moyen nécessaire est de 2796 kcal par personne\n"
     ]
    }
   ],
   "source": [
    "print(\"L'apport calorique journalier moyen nécessaire est de \" + str(apport_moyen) + \" kcal par personne\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d84851fd",
   "metadata": {},
   "source": [
    "### on réduit et merge le dataframe dispo_ali pour créer un nouveau dataframe de travail kcal_pays_m2 "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "82a54a89",
   "metadata": {},
   "outputs": [],
   "source": [
    "kcal_pays_m2 = dispo_ali.groupby(['Zone'], as_index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "7220aec3",
   "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>Zone</th>\n",
       "      <th>Disponibilité alimentaire (Kcal/personne/jour)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2087.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Afrique du Sud</td>\n",
       "      <td>3020.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Albanie</td>\n",
       "      <td>3188.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Algérie</td>\n",
       "      <td>3293.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Allemagne</td>\n",
       "      <td>3503.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             Zone  Disponibilité alimentaire (Kcal/personne/jour)\n",
       "0     Afghanistan                                          2087.0\n",
       "1  Afrique du Sud                                          3020.0\n",
       "2         Albanie                                          3188.0\n",
       "3         Algérie                                          3293.0\n",
       "4       Allemagne                                          3503.0"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "kcal_pays_m2 = kcal_pays_m2['Disponibilité alimentaire (Kcal/personne/jour)'].sum()\n",
    "kcal_pays_m2.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "968a1566",
   "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>Zone</th>\n",
       "      <th>Année</th>\n",
       "      <th>population</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2013</td>\n",
       "      <td>32269.589</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2014</td>\n",
       "      <td>33370.794</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2015</td>\n",
       "      <td>34413.603</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2016</td>\n",
       "      <td>35383.032</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2017</td>\n",
       "      <td>36296.113</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Zone  Année  population\n",
       "0  Afghanistan   2013   32269.589\n",
       "1  Afghanistan   2014   33370.794\n",
       "2  Afghanistan   2015   34413.603\n",
       "3  Afghanistan   2016   35383.032\n",
       "4  Afghanistan   2017   36296.113"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "popu_m2 = popu_plus_sous_nutrition_m1.drop(columns=['population_sous_nourrie'])\n",
    "popu_m2.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "a7e53949",
   "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>Zone</th>\n",
       "      <th>Disponibilité alimentaire (Kcal/personne/jour)</th>\n",
       "      <th>Année</th>\n",
       "      <th>population</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2087.0</td>\n",
       "      <td>2017</td>\n",
       "      <td>36296.113</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Afrique du Sud</td>\n",
       "      <td>3020.0</td>\n",
       "      <td>2017</td>\n",
       "      <td>57009.756</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Albanie</td>\n",
       "      <td>3188.0</td>\n",
       "      <td>2017</td>\n",
       "      <td>2884.169</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Algérie</td>\n",
       "      <td>3293.0</td>\n",
       "      <td>2017</td>\n",
       "      <td>41389.189</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Allemagne</td>\n",
       "      <td>3503.0</td>\n",
       "      <td>2017</td>\n",
       "      <td>82658.409</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             Zone  Disponibilité alimentaire (Kcal/personne/jour)  Année  \\\n",
       "0     Afghanistan                                          2087.0   2017   \n",
       "1  Afrique du Sud                                          3020.0   2017   \n",
       "2         Albanie                                          3188.0   2017   \n",
       "3         Algérie                                          3293.0   2017   \n",
       "4       Allemagne                                          3503.0   2017   \n",
       "\n",
       "   population  \n",
       "0   36296.113  \n",
       "1   57009.756  \n",
       "2    2884.169  \n",
       "3   41389.189  \n",
       "4   82658.409  "
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "kcal_pays_popu_m2 = pd.merge(kcal_pays_m2, popu_m2.loc[popu_m2['Année'] == 2017])\n",
    "kcal_pays_popu_m2.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "96922a81",
   "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>Zone</th>\n",
       "      <th>Disponibilité alimentaire (Kcal/personne/jour)</th>\n",
       "      <th>Année</th>\n",
       "      <th>population</th>\n",
       "      <th>Disponibilité alimentaire (kcal/an)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2087.0</td>\n",
       "      <td>2017</td>\n",
       "      <td>36296.113</td>\n",
       "      <td>2.766768e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Afrique du Sud</td>\n",
       "      <td>3020.0</td>\n",
       "      <td>2017</td>\n",
       "      <td>57009.756</td>\n",
       "      <td>6.288490e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Albanie</td>\n",
       "      <td>3188.0</td>\n",
       "      <td>2017</td>\n",
       "      <td>2884.169</td>\n",
       "      <td>3.358375e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Algérie</td>\n",
       "      <td>3293.0</td>\n",
       "      <td>2017</td>\n",
       "      <td>41389.189</td>\n",
       "      <td>4.978160e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Allemagne</td>\n",
       "      <td>3503.0</td>\n",
       "      <td>2017</td>\n",
       "      <td>82658.409</td>\n",
       "      <td>1.057590e+11</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             Zone  Disponibilité alimentaire (Kcal/personne/jour)  Année  \\\n",
       "0     Afghanistan                                          2087.0   2017   \n",
       "1  Afrique du Sud                                          3020.0   2017   \n",
       "2         Albanie                                          3188.0   2017   \n",
       "3         Algérie                                          3293.0   2017   \n",
       "4       Allemagne                                          3503.0   2017   \n",
       "\n",
       "   population  Disponibilité alimentaire (kcal/an)  \n",
       "0   36296.113                         2.766768e+10  \n",
       "1   57009.756                         6.288490e+10  \n",
       "2    2884.169                         3.358375e+09  \n",
       "3   41389.189                         4.978160e+10  \n",
       "4   82658.409                         1.057590e+11  "
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "kcal_pays_popu_m2['Disponibilité alimentaire (kcal/an)'] = kcal_pays_popu_m2['Disponibilité alimentaire (Kcal/personne/jour)'] * kcal_pays_popu_m2['population'] * 365.25\n",
    "kcal_pays_popu_m2.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "51b8226f",
   "metadata": {},
   "source": [
    "### on calcule la disponibilité alimentaire globale et la proportion de la population totale qui pourrait être nourrie"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "8750f6b1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "7640659135132.646"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dispo_ali_globale_m2 = kcal_pays_popu_m2['Disponibilité alimentaire (kcal/an)'].sum()\n",
    "dispo_ali_globale_m2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "83c7ce8a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "7481754"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "personnes_nourrissables_m2 = round((dispo_ali_globale_m2 / (apport_moyen * 365.25)))\n",
    "personnes_nourrissables_m2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "b759c00d",
   "metadata": {},
   "outputs": [],
   "source": [
    "pourcentage_m2 = round(personnes_nourrissables_m2 * 100 / (popu_m2.loc[popu_m2['Année'] == 2017, 'population'].sum()))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 95,
   "id": "bcc1c93b",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "En 2017, le nombre de personnes qui auraient pu être nourries grâce à la disponibilité alimentaire globale est de \n",
      " 7.481754 milliards, soit 99 % de la population\n"
     ]
    }
   ],
   "source": [
    "print(\"En 2017, le nombre de personnes qui auraient pu être nourries grâce à la disponibilité alimentaire globale est de \\n \" + str((personnes_nourrissables_m2)/1000000) + \" milliards, soit \" + str(pourcentage_m2) + \" % de la population\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6f27b2fc",
   "metadata": {},
   "source": [
    "<h1 style=\"margin: auto; color: rgb(93,138,191); \">Marc 3 / le nombre théorique de personnes qui pourraient être nourries à partir de la disponibilité alimentaire des produits végétaux\n",
    "</h1>\n",
    "</div>"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "4d81650b",
   "metadata": {},
   "source": [
    "### on réduit et merge le dataframe dispo_ali pour créer un nouveau dataframe de travail kcal_vegetal_pays_popu_m3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "6439c74a",
   "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>Origine</th>\n",
       "      <th>Zone</th>\n",
       "      <th>Aliments pour animaux</th>\n",
       "      <th>Autres Utilisations</th>\n",
       "      <th>Disponibilité alimentaire (Kcal/personne/jour)</th>\n",
       "      <th>Disponibilité alimentaire en quantité (kg/personne/an)</th>\n",
       "      <th>Disponibilité de matière grasse en quantité (g/personne/jour)</th>\n",
       "      <th>Disponibilité de protéines en quantité (g/personne/jour)</th>\n",
       "      <th>Disponibilité intérieure</th>\n",
       "      <th>Exportations - Quantité</th>\n",
       "      <th>Importations - Quantité</th>\n",
       "      <th>Nourriture</th>\n",
       "      <th>Pertes</th>\n",
       "      <th>Production</th>\n",
       "      <th>Semences</th>\n",
       "      <th>Traitement</th>\n",
       "      <th>Variation de stock</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>animale</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>123.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>216.0</td>\n",
       "      <td>79.92</td>\n",
       "      <td>15.23</td>\n",
       "      <td>12.21</td>\n",
       "      <td>2631.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>350.0</td>\n",
       "      <td>2442.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>2280.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>animale</td>\n",
       "      <td>Afrique du Sud</td>\n",
       "      <td>187.0</td>\n",
       "      <td>115.0</td>\n",
       "      <td>487.0</td>\n",
       "      <td>139.63</td>\n",
       "      <td>34.66</td>\n",
       "      <td>36.39</td>\n",
       "      <td>7817.0</td>\n",
       "      <td>1088.0</td>\n",
       "      <td>1049.0</td>\n",
       "      <td>7371.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>7614.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>241.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>animale</td>\n",
       "      <td>Albanie</td>\n",
       "      <td>101.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>985.0</td>\n",
       "      <td>389.05</td>\n",
       "      <td>67.72</td>\n",
       "      <td>59.41</td>\n",
       "      <td>1432.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>87.0</td>\n",
       "      <td>1235.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>1355.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>animale</td>\n",
       "      <td>Algérie</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>378.0</td>\n",
       "      <td>176.78</td>\n",
       "      <td>22.36</td>\n",
       "      <td>24.98</td>\n",
       "      <td>7120.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>2731.0</td>\n",
       "      <td>6932.0</td>\n",
       "      <td>166.0</td>\n",
       "      <td>4395.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>animale</td>\n",
       "      <td>Allemagne</td>\n",
       "      <td>2087.0</td>\n",
       "      <td>869.0</td>\n",
       "      <td>1042.0</td>\n",
       "      <td>388.70</td>\n",
       "      <td>77.99</td>\n",
       "      <td>61.49</td>\n",
       "      <td>35409.0</td>\n",
       "      <td>22977.0</td>\n",
       "      <td>14711.0</td>\n",
       "      <td>32159.0</td>\n",
       "      <td>64.0</td>\n",
       "      <td>43621.0</td>\n",
       "      <td>76.0</td>\n",
       "      <td>156.0</td>\n",
       "      <td>55.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Origine            Zone  Aliments pour animaux  Autres Utilisations  \\\n",
       "0  animale     Afghanistan                  123.0                  0.0   \n",
       "1  animale  Afrique du Sud                  187.0                115.0   \n",
       "2  animale         Albanie                  101.0                  2.0   \n",
       "3  animale         Algérie                    0.0                  1.0   \n",
       "4  animale       Allemagne                 2087.0                869.0   \n",
       "\n",
       "   Disponibilité alimentaire (Kcal/personne/jour)  \\\n",
       "0                                           216.0   \n",
       "1                                           487.0   \n",
       "2                                           985.0   \n",
       "3                                           378.0   \n",
       "4                                          1042.0   \n",
       "\n",
       "   Disponibilité alimentaire en quantité (kg/personne/an)  \\\n",
       "0                                              79.92        \n",
       "1                                             139.63        \n",
       "2                                             389.05        \n",
       "3                                             176.78        \n",
       "4                                             388.70        \n",
       "\n",
       "   Disponibilité de matière grasse en quantité (g/personne/jour)  \\\n",
       "0                                              15.23               \n",
       "1                                              34.66               \n",
       "2                                              67.72               \n",
       "3                                              22.36               \n",
       "4                                              77.99               \n",
       "\n",
       "   Disponibilité de protéines en quantité (g/personne/jour)  \\\n",
       "0                                              12.21          \n",
       "1                                              36.39          \n",
       "2                                              59.41          \n",
       "3                                              24.98          \n",
       "4                                              61.49          \n",
       "\n",
       "   Disponibilité intérieure  Exportations - Quantité  Importations - Quantité  \\\n",
       "0                    2631.0                      0.0                    350.0   \n",
       "1                    7817.0                   1088.0                   1049.0   \n",
       "2                    1432.0                     10.0                     87.0   \n",
       "3                    7120.0                      6.0                   2731.0   \n",
       "4                   35409.0                  22977.0                  14711.0   \n",
       "\n",
       "   Nourriture  Pertes  Production  Semences  Traitement  Variation de stock  \n",
       "0      2442.0    63.0      2280.0       2.0         0.0                 0.0  \n",
       "1      7371.0    83.0      7614.0      67.0         0.0               241.0  \n",
       "2      1235.0    94.0      1355.0       0.0         0.0                 0.0  \n",
       "3      6932.0   166.0      4395.0      21.0         0.0                 0.0  \n",
       "4     32159.0    64.0     43621.0      76.0       156.0                55.0  "
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "kcal_vegetal_pays_m3 = dispo_ali.groupby(['Origine', 'Zone'], as_index = False).sum()\n",
    "kcal_vegetal_pays_m3.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "672ecc2b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "count         348\n",
       "unique          2\n",
       "top       animale\n",
       "freq          174\n",
       "Name: Origine, dtype: object"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "kcal_vegetal_pays_m3.Origine.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "4a8c0c9a",
   "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>Origine</th>\n",
       "      <th>Zone</th>\n",
       "      <th>Aliments pour animaux</th>\n",
       "      <th>Autres Utilisations</th>\n",
       "      <th>Disponibilité alimentaire (Kcal/personne/jour)</th>\n",
       "      <th>Disponibilité alimentaire en quantité (kg/personne/an)</th>\n",
       "      <th>Disponibilité de matière grasse en quantité (g/personne/jour)</th>\n",
       "      <th>Disponibilité de protéines en quantité (g/personne/jour)</th>\n",
       "      <th>Disponibilité intérieure</th>\n",
       "      <th>Exportations - Quantité</th>\n",
       "      <th>Importations - Quantité</th>\n",
       "      <th>Nourriture</th>\n",
       "      <th>Pertes</th>\n",
       "      <th>Production</th>\n",
       "      <th>Semences</th>\n",
       "      <th>Traitement</th>\n",
       "      <th>Variation de stock</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>vegetale</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>645.0</td>\n",
       "      <td>415.0</td>\n",
       "      <td>1871.0</td>\n",
       "      <td>271.49</td>\n",
       "      <td>18.27</td>\n",
       "      <td>46.05</td>\n",
       "      <td>10884.0</td>\n",
       "      <td>278.0</td>\n",
       "      <td>2638.0</td>\n",
       "      <td>8293.0</td>\n",
       "      <td>1072.0</td>\n",
       "      <td>8891.0</td>\n",
       "      <td>393.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>-368.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>vegetale</td>\n",
       "      <td>Afrique du Sud</td>\n",
       "      <td>5122.0</td>\n",
       "      <td>761.0</td>\n",
       "      <td>2533.0</td>\n",
       "      <td>425.17</td>\n",
       "      <td>48.92</td>\n",
       "      <td>48.94</td>\n",
       "      <td>53439.0</td>\n",
       "      <td>10586.0</td>\n",
       "      <td>6468.0</td>\n",
       "      <td>22441.0</td>\n",
       "      <td>2110.0</td>\n",
       "      <td>55649.0</td>\n",
       "      <td>186.0</td>\n",
       "      <td>22819.0</td>\n",
       "      <td>1912.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176</th>\n",
       "      <td>vegetale</td>\n",
       "      <td>Albanie</td>\n",
       "      <td>559.0</td>\n",
       "      <td>172.0</td>\n",
       "      <td>2203.0</td>\n",
       "      <td>706.49</td>\n",
       "      <td>38.76</td>\n",
       "      <td>51.96</td>\n",
       "      <td>3326.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>846.0</td>\n",
       "      <td>2241.0</td>\n",
       "      <td>182.0</td>\n",
       "      <td>2609.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>113.0</td>\n",
       "      <td>-45.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177</th>\n",
       "      <td>vegetale</td>\n",
       "      <td>Algérie</td>\n",
       "      <td>4352.0</td>\n",
       "      <td>1706.0</td>\n",
       "      <td>2915.0</td>\n",
       "      <td>632.35</td>\n",
       "      <td>54.12</td>\n",
       "      <td>66.94</td>\n",
       "      <td>35510.0</td>\n",
       "      <td>649.0</td>\n",
       "      <td>14672.0</td>\n",
       "      <td>24797.0</td>\n",
       "      <td>3587.0</td>\n",
       "      <td>21964.0</td>\n",
       "      <td>428.0</td>\n",
       "      <td>637.0</td>\n",
       "      <td>-479.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>178</th>\n",
       "      <td>vegetale</td>\n",
       "      <td>Allemagne</td>\n",
       "      <td>28122.0</td>\n",
       "      <td>6842.0</td>\n",
       "      <td>2461.0</td>\n",
       "      <td>568.82</td>\n",
       "      <td>63.63</td>\n",
       "      <td>39.90</td>\n",
       "      <td>126866.0</td>\n",
       "      <td>34454.0</td>\n",
       "      <td>50642.0</td>\n",
       "      <td>47079.0</td>\n",
       "      <td>3717.0</td>\n",
       "      <td>110926.0</td>\n",
       "      <td>1475.0</td>\n",
       "      <td>39686.0</td>\n",
       "      <td>-247.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Origine            Zone  Aliments pour animaux  Autres Utilisations  \\\n",
       "174  vegetale     Afghanistan                  645.0                415.0   \n",
       "175  vegetale  Afrique du Sud                 5122.0                761.0   \n",
       "176  vegetale         Albanie                  559.0                172.0   \n",
       "177  vegetale         Algérie                 4352.0               1706.0   \n",
       "178  vegetale       Allemagne                28122.0               6842.0   \n",
       "\n",
       "     Disponibilité alimentaire (Kcal/personne/jour)  \\\n",
       "174                                          1871.0   \n",
       "175                                          2533.0   \n",
       "176                                          2203.0   \n",
       "177                                          2915.0   \n",
       "178                                          2461.0   \n",
       "\n",
       "     Disponibilité alimentaire en quantité (kg/personne/an)  \\\n",
       "174                                             271.49        \n",
       "175                                             425.17        \n",
       "176                                             706.49        \n",
       "177                                             632.35        \n",
       "178                                             568.82        \n",
       "\n",
       "     Disponibilité de matière grasse en quantité (g/personne/jour)  \\\n",
       "174                                              18.27               \n",
       "175                                              48.92               \n",
       "176                                              38.76               \n",
       "177                                              54.12               \n",
       "178                                              63.63               \n",
       "\n",
       "     Disponibilité de protéines en quantité (g/personne/jour)  \\\n",
       "174                                              46.05          \n",
       "175                                              48.94          \n",
       "176                                              51.96          \n",
       "177                                              66.94          \n",
       "178                                              39.90          \n",
       "\n",
       "     Disponibilité intérieure  Exportations - Quantité  \\\n",
       "174                   10884.0                    278.0   \n",
       "175                   53439.0                  10586.0   \n",
       "176                    3326.0                     84.0   \n",
       "177                   35510.0                    649.0   \n",
       "178                  126866.0                  34454.0   \n",
       "\n",
       "     Importations - Quantité  Nourriture  Pertes  Production  Semences  \\\n",
       "174                   2638.0      8293.0  1072.0      8891.0     393.0   \n",
       "175                   6468.0     22441.0  2110.0     55649.0     186.0   \n",
       "176                    846.0      2241.0   182.0      2609.0      55.0   \n",
       "177                  14672.0     24797.0  3587.0     21964.0     428.0   \n",
       "178                  50642.0     47079.0  3717.0    110926.0    1475.0   \n",
       "\n",
       "     Traitement  Variation de stock  \n",
       "174        63.0              -368.0  \n",
       "175     22819.0              1912.0  \n",
       "176       113.0               -45.0  \n",
       "177       637.0              -479.0  \n",
       "178     39686.0              -247.0  "
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "kcal_vegetal_pays_m3 = kcal_vegetal_pays_m3.loc[(kcal_vegetal_pays_m3['Origine'] == 'vegetale')]\n",
    "kcal_vegetal_pays_m3.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "faa908b4",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(174, 17)"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "kcal_vegetal_pays_m3.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "0e02de1f",
   "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>Origine</th>\n",
       "      <th>Zone</th>\n",
       "      <th>Aliments pour animaux</th>\n",
       "      <th>Autres Utilisations</th>\n",
       "      <th>Disponibilité alimentaire (Kcal/personne/jour)</th>\n",
       "      <th>Disponibilité alimentaire en quantité (kg/personne/an)</th>\n",
       "      <th>Disponibilité de matière grasse en quantité (g/personne/jour)</th>\n",
       "      <th>Disponibilité de protéines en quantité (g/personne/jour)</th>\n",
       "      <th>Disponibilité intérieure</th>\n",
       "      <th>Exportations - Quantité</th>\n",
       "      <th>Importations - Quantité</th>\n",
       "      <th>Nourriture</th>\n",
       "      <th>Pertes</th>\n",
       "      <th>Production</th>\n",
       "      <th>Semences</th>\n",
       "      <th>Traitement</th>\n",
       "      <th>Variation de stock</th>\n",
       "      <th>Année</th>\n",
       "      <th>population</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>vegetale</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>645.0</td>\n",
       "      <td>415.0</td>\n",
       "      <td>1871.0</td>\n",
       "      <td>271.49</td>\n",
       "      <td>18.27</td>\n",
       "      <td>46.05</td>\n",
       "      <td>10884.0</td>\n",
       "      <td>278.0</td>\n",
       "      <td>2638.0</td>\n",
       "      <td>8293.0</td>\n",
       "      <td>1072.0</td>\n",
       "      <td>8891.0</td>\n",
       "      <td>393.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>-368.0</td>\n",
       "      <td>2017</td>\n",
       "      <td>36296.113</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>vegetale</td>\n",
       "      <td>Afrique du Sud</td>\n",
       "      <td>5122.0</td>\n",
       "      <td>761.0</td>\n",
       "      <td>2533.0</td>\n",
       "      <td>425.17</td>\n",
       "      <td>48.92</td>\n",
       "      <td>48.94</td>\n",
       "      <td>53439.0</td>\n",
       "      <td>10586.0</td>\n",
       "      <td>6468.0</td>\n",
       "      <td>22441.0</td>\n",
       "      <td>2110.0</td>\n",
       "      <td>55649.0</td>\n",
       "      <td>186.0</td>\n",
       "      <td>22819.0</td>\n",
       "      <td>1912.0</td>\n",
       "      <td>2017</td>\n",
       "      <td>57009.756</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>vegetale</td>\n",
       "      <td>Albanie</td>\n",
       "      <td>559.0</td>\n",
       "      <td>172.0</td>\n",
       "      <td>2203.0</td>\n",
       "      <td>706.49</td>\n",
       "      <td>38.76</td>\n",
       "      <td>51.96</td>\n",
       "      <td>3326.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>846.0</td>\n",
       "      <td>2241.0</td>\n",
       "      <td>182.0</td>\n",
       "      <td>2609.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>113.0</td>\n",
       "      <td>-45.0</td>\n",
       "      <td>2017</td>\n",
       "      <td>2884.169</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>vegetale</td>\n",
       "      <td>Algérie</td>\n",
       "      <td>4352.0</td>\n",
       "      <td>1706.0</td>\n",
       "      <td>2915.0</td>\n",
       "      <td>632.35</td>\n",
       "      <td>54.12</td>\n",
       "      <td>66.94</td>\n",
       "      <td>35510.0</td>\n",
       "      <td>649.0</td>\n",
       "      <td>14672.0</td>\n",
       "      <td>24797.0</td>\n",
       "      <td>3587.0</td>\n",
       "      <td>21964.0</td>\n",
       "      <td>428.0</td>\n",
       "      <td>637.0</td>\n",
       "      <td>-479.0</td>\n",
       "      <td>2017</td>\n",
       "      <td>41389.189</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>vegetale</td>\n",
       "      <td>Allemagne</td>\n",
       "      <td>28122.0</td>\n",
       "      <td>6842.0</td>\n",
       "      <td>2461.0</td>\n",
       "      <td>568.82</td>\n",
       "      <td>63.63</td>\n",
       "      <td>39.90</td>\n",
       "      <td>126866.0</td>\n",
       "      <td>34454.0</td>\n",
       "      <td>50642.0</td>\n",
       "      <td>47079.0</td>\n",
       "      <td>3717.0</td>\n",
       "      <td>110926.0</td>\n",
       "      <td>1475.0</td>\n",
       "      <td>39686.0</td>\n",
       "      <td>-247.0</td>\n",
       "      <td>2017</td>\n",
       "      <td>82658.409</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Origine            Zone  Aliments pour animaux  Autres Utilisations  \\\n",
       "0  vegetale     Afghanistan                  645.0                415.0   \n",
       "1  vegetale  Afrique du Sud                 5122.0                761.0   \n",
       "2  vegetale         Albanie                  559.0                172.0   \n",
       "3  vegetale         Algérie                 4352.0               1706.0   \n",
       "4  vegetale       Allemagne                28122.0               6842.0   \n",
       "\n",
       "   Disponibilité alimentaire (Kcal/personne/jour)  \\\n",
       "0                                          1871.0   \n",
       "1                                          2533.0   \n",
       "2                                          2203.0   \n",
       "3                                          2915.0   \n",
       "4                                          2461.0   \n",
       "\n",
       "   Disponibilité alimentaire en quantité (kg/personne/an)  \\\n",
       "0                                             271.49        \n",
       "1                                             425.17        \n",
       "2                                             706.49        \n",
       "3                                             632.35        \n",
       "4                                             568.82        \n",
       "\n",
       "   Disponibilité de matière grasse en quantité (g/personne/jour)  \\\n",
       "0                                              18.27               \n",
       "1                                              48.92               \n",
       "2                                              38.76               \n",
       "3                                              54.12               \n",
       "4                                              63.63               \n",
       "\n",
       "   Disponibilité de protéines en quantité (g/personne/jour)  \\\n",
       "0                                              46.05          \n",
       "1                                              48.94          \n",
       "2                                              51.96          \n",
       "3                                              66.94          \n",
       "4                                              39.90          \n",
       "\n",
       "   Disponibilité intérieure  Exportations - Quantité  Importations - Quantité  \\\n",
       "0                   10884.0                    278.0                   2638.0   \n",
       "1                   53439.0                  10586.0                   6468.0   \n",
       "2                    3326.0                     84.0                    846.0   \n",
       "3                   35510.0                    649.0                  14672.0   \n",
       "4                  126866.0                  34454.0                  50642.0   \n",
       "\n",
       "   Nourriture  Pertes  Production  Semences  Traitement  Variation de stock  \\\n",
       "0      8293.0  1072.0      8891.0     393.0        63.0              -368.0   \n",
       "1     22441.0  2110.0     55649.0     186.0     22819.0              1912.0   \n",
       "2      2241.0   182.0      2609.0      55.0       113.0               -45.0   \n",
       "3     24797.0  3587.0     21964.0     428.0       637.0              -479.0   \n",
       "4     47079.0  3717.0    110926.0    1475.0     39686.0              -247.0   \n",
       "\n",
       "   Année  population  \n",
       "0   2017   36296.113  \n",
       "1   2017   57009.756  \n",
       "2   2017    2884.169  \n",
       "3   2017   41389.189  \n",
       "4   2017   82658.409  "
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "kcal_vegetal_pays_popu_m3 = pd.merge(kcal_vegetal_pays_m3, popu_m2.loc[popu_m2['Année'] == 2017])\n",
    "kcal_vegetal_pays_popu_m3.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "8587d1d8",
   "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>Origine</th>\n",
       "      <th>Zone</th>\n",
       "      <th>Aliments pour animaux</th>\n",
       "      <th>Autres Utilisations</th>\n",
       "      <th>Disponibilité alimentaire (Kcal/personne/jour)</th>\n",
       "      <th>Disponibilité alimentaire en quantité (kg/personne/an)</th>\n",
       "      <th>Disponibilité de matière grasse en quantité (g/personne/jour)</th>\n",
       "      <th>Disponibilité de protéines en quantité (g/personne/jour)</th>\n",
       "      <th>Disponibilité intérieure</th>\n",
       "      <th>Exportations - Quantité</th>\n",
       "      <th>Importations - Quantité</th>\n",
       "      <th>Nourriture</th>\n",
       "      <th>Pertes</th>\n",
       "      <th>Production</th>\n",
       "      <th>Semences</th>\n",
       "      <th>Traitement</th>\n",
       "      <th>Variation de stock</th>\n",
       "      <th>Année</th>\n",
       "      <th>population</th>\n",
       "      <th>Disponibilité alimentaire vegetale (kcal/an)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>vegetale</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>645.0</td>\n",
       "      <td>415.0</td>\n",
       "      <td>1871.0</td>\n",
       "      <td>271.49</td>\n",
       "      <td>18.27</td>\n",
       "      <td>46.05</td>\n",
       "      <td>10884.0</td>\n",
       "      <td>278.0</td>\n",
       "      <td>2638.0</td>\n",
       "      <td>8293.0</td>\n",
       "      <td>1072.0</td>\n",
       "      <td>8891.0</td>\n",
       "      <td>393.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>-368.0</td>\n",
       "      <td>2017</td>\n",
       "      <td>36296.113</td>\n",
       "      <td>2.480414e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>vegetale</td>\n",
       "      <td>Afrique du Sud</td>\n",
       "      <td>5122.0</td>\n",
       "      <td>761.0</td>\n",
       "      <td>2533.0</td>\n",
       "      <td>425.17</td>\n",
       "      <td>48.92</td>\n",
       "      <td>48.94</td>\n",
       "      <td>53439.0</td>\n",
       "      <td>10586.0</td>\n",
       "      <td>6468.0</td>\n",
       "      <td>22441.0</td>\n",
       "      <td>2110.0</td>\n",
       "      <td>55649.0</td>\n",
       "      <td>186.0</td>\n",
       "      <td>22819.0</td>\n",
       "      <td>1912.0</td>\n",
       "      <td>2017</td>\n",
       "      <td>57009.756</td>\n",
       "      <td>5.274419e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>vegetale</td>\n",
       "      <td>Albanie</td>\n",
       "      <td>559.0</td>\n",
       "      <td>172.0</td>\n",
       "      <td>2203.0</td>\n",
       "      <td>706.49</td>\n",
       "      <td>38.76</td>\n",
       "      <td>51.96</td>\n",
       "      <td>3326.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>846.0</td>\n",
       "      <td>2241.0</td>\n",
       "      <td>182.0</td>\n",
       "      <td>2609.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>113.0</td>\n",
       "      <td>-45.0</td>\n",
       "      <td>2017</td>\n",
       "      <td>2884.169</td>\n",
       "      <td>2.320734e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>vegetale</td>\n",
       "      <td>Algérie</td>\n",
       "      <td>4352.0</td>\n",
       "      <td>1706.0</td>\n",
       "      <td>2915.0</td>\n",
       "      <td>632.35</td>\n",
       "      <td>54.12</td>\n",
       "      <td>66.94</td>\n",
       "      <td>35510.0</td>\n",
       "      <td>649.0</td>\n",
       "      <td>14672.0</td>\n",
       "      <td>24797.0</td>\n",
       "      <td>3587.0</td>\n",
       "      <td>21964.0</td>\n",
       "      <td>428.0</td>\n",
       "      <td>637.0</td>\n",
       "      <td>-479.0</td>\n",
       "      <td>2017</td>\n",
       "      <td>41389.189</td>\n",
       "      <td>4.406722e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>vegetale</td>\n",
       "      <td>Allemagne</td>\n",
       "      <td>28122.0</td>\n",
       "      <td>6842.0</td>\n",
       "      <td>2461.0</td>\n",
       "      <td>568.82</td>\n",
       "      <td>63.63</td>\n",
       "      <td>39.90</td>\n",
       "      <td>126866.0</td>\n",
       "      <td>34454.0</td>\n",
       "      <td>50642.0</td>\n",
       "      <td>47079.0</td>\n",
       "      <td>3717.0</td>\n",
       "      <td>110926.0</td>\n",
       "      <td>1475.0</td>\n",
       "      <td>39686.0</td>\n",
       "      <td>-247.0</td>\n",
       "      <td>2017</td>\n",
       "      <td>82658.409</td>\n",
       "      <td>7.430001e+10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Origine            Zone  Aliments pour animaux  Autres Utilisations  \\\n",
       "0  vegetale     Afghanistan                  645.0                415.0   \n",
       "1  vegetale  Afrique du Sud                 5122.0                761.0   \n",
       "2  vegetale         Albanie                  559.0                172.0   \n",
       "3  vegetale         Algérie                 4352.0               1706.0   \n",
       "4  vegetale       Allemagne                28122.0               6842.0   \n",
       "\n",
       "   Disponibilité alimentaire (Kcal/personne/jour)  \\\n",
       "0                                          1871.0   \n",
       "1                                          2533.0   \n",
       "2                                          2203.0   \n",
       "3                                          2915.0   \n",
       "4                                          2461.0   \n",
       "\n",
       "   Disponibilité alimentaire en quantité (kg/personne/an)  \\\n",
       "0                                             271.49        \n",
       "1                                             425.17        \n",
       "2                                             706.49        \n",
       "3                                             632.35        \n",
       "4                                             568.82        \n",
       "\n",
       "   Disponibilité de matière grasse en quantité (g/personne/jour)  \\\n",
       "0                                              18.27               \n",
       "1                                              48.92               \n",
       "2                                              38.76               \n",
       "3                                              54.12               \n",
       "4                                              63.63               \n",
       "\n",
       "   Disponibilité de protéines en quantité (g/personne/jour)  \\\n",
       "0                                              46.05          \n",
       "1                                              48.94          \n",
       "2                                              51.96          \n",
       "3                                              66.94          \n",
       "4                                              39.90          \n",
       "\n",
       "   Disponibilité intérieure  Exportations - Quantité  Importations - Quantité  \\\n",
       "0                   10884.0                    278.0                   2638.0   \n",
       "1                   53439.0                  10586.0                   6468.0   \n",
       "2                    3326.0                     84.0                    846.0   \n",
       "3                   35510.0                    649.0                  14672.0   \n",
       "4                  126866.0                  34454.0                  50642.0   \n",
       "\n",
       "   Nourriture  Pertes  Production  Semences  Traitement  Variation de stock  \\\n",
       "0      8293.0  1072.0      8891.0     393.0        63.0              -368.0   \n",
       "1     22441.0  2110.0     55649.0     186.0     22819.0              1912.0   \n",
       "2      2241.0   182.0      2609.0      55.0       113.0               -45.0   \n",
       "3     24797.0  3587.0     21964.0     428.0       637.0              -479.0   \n",
       "4     47079.0  3717.0    110926.0    1475.0     39686.0              -247.0   \n",
       "\n",
       "   Année  population  Disponibilité alimentaire vegetale (kcal/an)  \n",
       "0   2017   36296.113                                  2.480414e+10  \n",
       "1   2017   57009.756                                  5.274419e+10  \n",
       "2   2017    2884.169                                  2.320734e+09  \n",
       "3   2017   41389.189                                  4.406722e+10  \n",
       "4   2017   82658.409                                  7.430001e+10  "
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "kcal_vegetal_pays_popu_m3['Disponibilité alimentaire vegetale (kcal/an)'] = kcal_vegetal_pays_popu_m3['Disponibilité alimentaire (Kcal/personne/jour)'] * kcal_vegetal_pays_popu_m3['population'] * 365.25\n",
    "kcal_vegetal_pays_popu_m3.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "41d098f3",
   "metadata": {},
   "source": [
    "### on calcule la disponibilité alimentaire végétale globale et la proportion de la population totale qui pourrait être nourrie"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "id": "494b52f5",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "6304494128250.74"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dispo_ali_vegetale_globale_m3 = kcal_vegetal_pays_popu_m3['Disponibilité alimentaire vegetale (kcal/an)'].sum()\n",
    "dispo_ali_vegetale_globale_m3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "d9c04fe3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "6173378"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "personnes_nourrissables_vegetal_m3 = round((dispo_ali_vegetale_globale_m3 / (apport_moyen * 365.25)))\n",
    "personnes_nourrissables_vegetal_m3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "1d5ee6c8",
   "metadata": {},
   "outputs": [],
   "source": [
    "pourcentage_m3 = round(personnes_nourrissables_vegetal_m3 * 100 / (popu_m2.loc[popu_m2['Année'] == 2017, 'population'].sum()))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 94,
   "id": "495fe2d7",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "En 2017, le nombre de personnes qui auraient pu être nourries grâce à la disponibilité alimentaire d'origine \n",
      "végétale globale est de 6.173378 milliards, soit 82 % de la population\n"
     ]
    }
   ],
   "source": [
    "print(\"En 2017, le nombre de personnes qui auraient pu être nourries grâce à la disponibilité alimentaire d'origine \\nvégétale globale est de \" + str((personnes_nourrissables_vegetal_m3)/1000000) + \" milliards, soit \" + str(pourcentage_m3) + \" % de la population\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "18d940ac",
   "metadata": {},
   "source": [
    "<h1 style=\"margin: auto; color: rgb(93,138,191); \">Marc 4 / l’utilisation de la disponibilité intérieure, en particulier la part qui est attribuée à l’alimentation animale, celle qui est perdue et celle qui est utilisée pour l'alimentation humaine\n",
    "</h1>\n",
    "</div>"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6df548a4",
   "metadata": {},
   "source": [
    "### on réduit le dataframe dispo_ali pour ne garder que les données nécessaires dans un nouveau dataframe dispo_ali_m4"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "id": "61b0de03",
   "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>Aliments pour animaux</th>\n",
       "      <th>Autres Utilisations</th>\n",
       "      <th>Disponibilité intérieure</th>\n",
       "      <th>Nourriture</th>\n",
       "      <th>Pertes</th>\n",
       "      <th>Semences</th>\n",
       "      <th>Traitement</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zone</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Afghanistan</th>\n",
       "      <td>768.0</td>\n",
       "      <td>415.0</td>\n",
       "      <td>13515.0</td>\n",
       "      <td>10735.0</td>\n",
       "      <td>1135.0</td>\n",
       "      <td>395.0</td>\n",
       "      <td>63.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Afrique du Sud</th>\n",
       "      <td>5309.0</td>\n",
       "      <td>876.0</td>\n",
       "      <td>61256.0</td>\n",
       "      <td>29812.0</td>\n",
       "      <td>2193.0</td>\n",
       "      <td>253.0</td>\n",
       "      <td>22819.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Albanie</th>\n",
       "      <td>660.0</td>\n",
       "      <td>174.0</td>\n",
       "      <td>4758.0</td>\n",
       "      <td>3476.0</td>\n",
       "      <td>276.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>113.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Algérie</th>\n",
       "      <td>4352.0</td>\n",
       "      <td>1707.0</td>\n",
       "      <td>42630.0</td>\n",
       "      <td>31729.0</td>\n",
       "      <td>3753.0</td>\n",
       "      <td>449.0</td>\n",
       "      <td>637.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Allemagne</th>\n",
       "      <td>30209.0</td>\n",
       "      <td>7711.0</td>\n",
       "      <td>162275.0</td>\n",
       "      <td>79238.0</td>\n",
       "      <td>3781.0</td>\n",
       "      <td>1551.0</td>\n",
       "      <td>39842.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                Aliments pour animaux  Autres Utilisations  \\\n",
       "Zone                                                         \n",
       "Afghanistan                     768.0                415.0   \n",
       "Afrique du Sud                 5309.0                876.0   \n",
       "Albanie                         660.0                174.0   \n",
       "Algérie                        4352.0               1707.0   \n",
       "Allemagne                     30209.0               7711.0   \n",
       "\n",
       "                Disponibilité intérieure  Nourriture  Pertes  Semences  \\\n",
       "Zone                                                                     \n",
       "Afghanistan                      13515.0     10735.0  1135.0     395.0   \n",
       "Afrique du Sud                   61256.0     29812.0  2193.0     253.0   \n",
       "Albanie                           4758.0      3476.0   276.0      55.0   \n",
       "Algérie                          42630.0     31729.0  3753.0     449.0   \n",
       "Allemagne                       162275.0     79238.0  3781.0    1551.0   \n",
       "\n",
       "                Traitement  \n",
       "Zone                        \n",
       "Afghanistan           63.0  \n",
       "Afrique du Sud     22819.0  \n",
       "Albanie              113.0  \n",
       "Algérie              637.0  \n",
       "Allemagne          39842.0  "
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dispo_ali_m4 = dispo_ali.groupby(['Zone']).sum()\n",
    "dispo_ali_m4 = dispo_ali_m4.drop(['Exportations - Quantité', 'Importations - Quantité', 'Production', 'Variation de stock', 'Disponibilité alimentaire (Kcal/personne/jour)', 'Disponibilité alimentaire en quantité (kg/personne/an)', 'Disponibilité de matière grasse en quantité (g/personne/jour)', 'Disponibilité de protéines en quantité (g/personne/jour)'], axis=1)\n",
    "\n",
    "dispo_ali_m4.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5c489876",
   "metadata": {},
   "source": [
    "### on renvoie le résumé des statistiques du nouveau dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "f6ee7457",
   "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>Aliments pour animaux</th>\n",
       "      <th>Autres Utilisations</th>\n",
       "      <th>Disponibilité intérieure</th>\n",
       "      <th>Nourriture</th>\n",
       "      <th>Pertes</th>\n",
       "      <th>Semences</th>\n",
       "      <th>Traitement</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>174.000000</td>\n",
       "      <td>174.000000</td>\n",
       "      <td>1.740000e+02</td>\n",
       "      <td>1.740000e+02</td>\n",
       "      <td>174.000000</td>\n",
       "      <td>174.000000</td>\n",
       "      <td>174.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>7495.660920</td>\n",
       "      <td>4971.396552</td>\n",
       "      <td>5.660341e+04</td>\n",
       "      <td>2.802447e+04</td>\n",
       "      <td>2607.459770</td>\n",
       "      <td>888.971264</td>\n",
       "      <td>12670.614943</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>29613.064847</td>\n",
       "      <td>30724.740191</td>\n",
       "      <td>2.008030e+05</td>\n",
       "      <td>1.092607e+05</td>\n",
       "      <td>9949.343198</td>\n",
       "      <td>3141.323013</td>\n",
       "      <td>44526.233238</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>5.900000e+01</td>\n",
       "      <td>2.600000e+01</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>113.000000</td>\n",
       "      <td>89.250000</td>\n",
       "      <td>2.854500e+03</td>\n",
       "      <td>1.748000e+03</td>\n",
       "      <td>92.750000</td>\n",
       "      <td>15.250000</td>\n",
       "      <td>107.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>959.500000</td>\n",
       "      <td>382.000000</td>\n",
       "      <td>1.113200e+04</td>\n",
       "      <td>5.786500e+03</td>\n",
       "      <td>443.500000</td>\n",
       "      <td>138.000000</td>\n",
       "      <td>1216.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>4427.750000</td>\n",
       "      <td>1593.750000</td>\n",
       "      <td>3.122925e+04</td>\n",
       "      <td>1.794800e+04</td>\n",
       "      <td>1622.500000</td>\n",
       "      <td>427.000000</td>\n",
       "      <td>5668.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>345951.000000</td>\n",
       "      <td>367300.000000</td>\n",
       "      <td>2.036726e+06</td>\n",
       "      <td>1.249625e+06</td>\n",
       "      <td>89575.000000</td>\n",
       "      <td>29432.000000</td>\n",
       "      <td>367282.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       Aliments pour animaux  Autres Utilisations  Disponibilité intérieure  \\\n",
       "count             174.000000           174.000000              1.740000e+02   \n",
       "mean             7495.660920          4971.396552              5.660341e+04   \n",
       "std             29613.064847         30724.740191              2.008030e+05   \n",
       "min                 0.000000             0.000000              5.900000e+01   \n",
       "25%               113.000000            89.250000              2.854500e+03   \n",
       "50%               959.500000           382.000000              1.113200e+04   \n",
       "75%              4427.750000          1593.750000              3.122925e+04   \n",
       "max            345951.000000        367300.000000              2.036726e+06   \n",
       "\n",
       "         Nourriture        Pertes      Semences     Traitement  \n",
       "count  1.740000e+02    174.000000    174.000000     174.000000  \n",
       "mean   2.802447e+04   2607.459770    888.971264   12670.614943  \n",
       "std    1.092607e+05   9949.343198   3141.323013   44526.233238  \n",
       "min    2.600000e+01      0.000000      0.000000       0.000000  \n",
       "25%    1.748000e+03     92.750000     15.250000     107.750000  \n",
       "50%    5.786500e+03    443.500000    138.000000    1216.500000  \n",
       "75%    1.794800e+04   1622.500000    427.000000    5668.750000  \n",
       "max    1.249625e+06  89575.000000  29432.000000  367282.000000  "
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dispo_ali_m4.describe()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "2dec9ac0",
   "metadata": {},
   "source": [
    "### on déclare les variables de calcul de proportions"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "id": "d7b68151",
   "metadata": {},
   "outputs": [],
   "source": [
    "proportion_animale = round(dispo_ali_m4['Aliments pour animaux'].sum() * 100 / dispo_ali_m4['Disponibilité intérieure'].sum(), 2)\n",
    "proportion_humaine = round(dispo_ali_m4['Nourriture'].sum() * 100 / dispo_ali_m4['Disponibilité intérieure'].sum(),2)\n",
    "proportion_perdue = round(dispo_ali_m4['Pertes'].sum() * 100 / dispo_ali_m4['Disponibilité intérieure'].sum(), 2)\n",
    "proportion_reste = round(100 - (proportion_animale + proportion_humaine + proportion_perdue) , 2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 96,
   "id": "ffd59815",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "La disponibilité intérieure est répartie en : 13.24 % pour l'alimentation animale, 49.51 % pour l'alimentation \n",
      "humaine, 4.61 % de pertes et 32.64 % pour le reste.\n"
     ]
    }
   ],
   "source": [
    "print(\"La disponibilité intérieure est répartie en : \" + str(proportion_animale) + \" % pour l'alimentation animale, \" + str(proportion_humaine) + \" % pour l'alimentation \\nhumaine, \" + str(proportion_perdue) + \" % de pertes et \" + str(proportion_reste) + \" % pour le reste.\") "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "464a0c2d",
   "metadata": {},
   "source": [
    "<h1 style=\"margin: auto; color: rgb(93,138,191); \">Julien 1 / Lien logique entre l’ensemble des 10 variables exprimées en milliers de tonnes sur les utilisations de la disponibilité intérieure, qui peut s’exprimer avec une équation\n",
    "</h1>\n",
    "</div>"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "807ef9a2",
   "metadata": {},
   "source": [
    "Importations + Production + Variations de stock - Exportations \n",
    "\n",
    "= Disponibilité intérieure \n",
    "\n",
    "= Nourriture + Pertes + Aliments pour animaux + Autres utilisations + Semences + Traitements "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "faabb4b9",
   "metadata": {},
   "source": [
    "<h1 style=\"margin: auto; color: rgb(93,138,191); \">Julien 2 / Chiffres  sur l’utilisation des céréales, notamment la répartition entre l’alimentation humaine et l’alimentation pour animaux\n",
    "</h1>\n",
    "</div>"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a0d3d83d",
   "metadata": {},
   "source": [
    "### création d'une liste regroupant les céréales"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "id": "fd7cb327",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "('Avoine',\n",
       " 'Blé',\n",
       " 'Maïs',\n",
       " 'Millet',\n",
       " 'Orge',\n",
       " 'Riz (Eq Blanchi)',\n",
       " 'Seigle',\n",
       " 'Sorgho',\n",
       " 'Céréales, Autres')"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cereales_liste = ('Avoine', 'Blé', 'Maïs', 'Millet', 'Orge', 'Riz (Eq Blanchi)', 'Seigle', 'Sorgho', 'Céréales, Autres')\n",
    "cereales_liste"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "588e49ae",
   "metadata": {},
   "source": [
    "### on réduit le dataframe dispo_ali aux données nécessaires pour créer le nouveau dataframe dispo_cereales_j2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "id": "9dc91d3e",
   "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>Zone</th>\n",
       "      <th>Aliments pour animaux</th>\n",
       "      <th>Autres Utilisations</th>\n",
       "      <th>Disponibilité alimentaire (Kcal/personne/jour)</th>\n",
       "      <th>Disponibilité alimentaire en quantité (kg/personne/an)</th>\n",
       "      <th>Disponibilité de matière grasse en quantité (g/personne/jour)</th>\n",
       "      <th>Disponibilité de protéines en quantité (g/personne/jour)</th>\n",
       "      <th>Disponibilité intérieure</th>\n",
       "      <th>Exportations - Quantité</th>\n",
       "      <th>Importations - Quantité</th>\n",
       "      <th>Nourriture</th>\n",
       "      <th>Pertes</th>\n",
       "      <th>Production</th>\n",
       "      <th>Semences</th>\n",
       "      <th>Traitement</th>\n",
       "      <th>Variation de stock</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>560.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1560.0</td>\n",
       "      <td>179.87</td>\n",
       "      <td>5.52</td>\n",
       "      <td>41.04</td>\n",
       "      <td>7303.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1303.0</td>\n",
       "      <td>5494.0</td>\n",
       "      <td>883.0</td>\n",
       "      <td>6350.0</td>\n",
       "      <td>363.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-350.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Afrique du Sud</td>\n",
       "      <td>4824.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1538.0</td>\n",
       "      <td>180.02</td>\n",
       "      <td>10.20</td>\n",
       "      <td>41.09</td>\n",
       "      <td>15493.0</td>\n",
       "      <td>3777.0</td>\n",
       "      <td>3147.0</td>\n",
       "      <td>9503.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>14155.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>593.0</td>\n",
       "      <td>1969.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Albanie</td>\n",
       "      <td>411.0</td>\n",
       "      <td>134.0</td>\n",
       "      <td>1144.0</td>\n",
       "      <td>149.27</td>\n",
       "      <td>6.08</td>\n",
       "      <td>35.49</td>\n",
       "      <td>1145.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>468.0</td>\n",
       "      <td>474.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>703.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>-22.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Algérie</td>\n",
       "      <td>4337.0</td>\n",
       "      <td>820.0</td>\n",
       "      <td>1678.0</td>\n",
       "      <td>217.67</td>\n",
       "      <td>6.79</td>\n",
       "      <td>49.33</td>\n",
       "      <td>15013.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>10279.0</td>\n",
       "      <td>8535.0</td>\n",
       "      <td>1024.0</td>\n",
       "      <td>4914.0</td>\n",
       "      <td>253.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>-180.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Allemagne</td>\n",
       "      <td>26615.0</td>\n",
       "      <td>1013.0</td>\n",
       "      <td>872.0</td>\n",
       "      <td>111.11</td>\n",
       "      <td>3.48</td>\n",
       "      <td>26.39</td>\n",
       "      <td>42158.0</td>\n",
       "      <td>16721.0</td>\n",
       "      <td>11093.0</td>\n",
       "      <td>9191.0</td>\n",
       "      <td>1221.0</td>\n",
       "      <td>47757.0</td>\n",
       "      <td>1027.0</td>\n",
       "      <td>3090.0</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>Émirats arabes unis</td>\n",
       "      <td>1053.0</td>\n",
       "      <td>263.0</td>\n",
       "      <td>1379.0</td>\n",
       "      <td>158.68</td>\n",
       "      <td>5.66</td>\n",
       "      <td>34.21</td>\n",
       "      <td>3142.0</td>\n",
       "      <td>619.0</td>\n",
       "      <td>4249.0</td>\n",
       "      <td>1484.0</td>\n",
       "      <td>384.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-543.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>Équateur</td>\n",
       "      <td>847.0</td>\n",
       "      <td>787.0</td>\n",
       "      <td>812.0</td>\n",
       "      <td>95.57</td>\n",
       "      <td>3.12</td>\n",
       "      <td>18.85</td>\n",
       "      <td>3407.0</td>\n",
       "      <td>53.0</td>\n",
       "      <td>877.0</td>\n",
       "      <td>1505.0</td>\n",
       "      <td>138.0</td>\n",
       "      <td>2598.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>-15.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>États-Unis d'Amérique</td>\n",
       "      <td>140096.0</td>\n",
       "      <td>137181.0</td>\n",
       "      <td>801.0</td>\n",
       "      <td>105.63</td>\n",
       "      <td>3.63</td>\n",
       "      <td>23.70</td>\n",
       "      <td>343006.0</td>\n",
       "      <td>66302.0</td>\n",
       "      <td>13477.0</td>\n",
       "      <td>33810.0</td>\n",
       "      <td>222.0</td>\n",
       "      <td>433686.0</td>\n",
       "      <td>3098.0</td>\n",
       "      <td>28608.0</td>\n",
       "      <td>-37854.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>Éthiopie</td>\n",
       "      <td>667.0</td>\n",
       "      <td>3569.0</td>\n",
       "      <td>1362.0</td>\n",
       "      <td>150.46</td>\n",
       "      <td>6.06</td>\n",
       "      <td>36.69</td>\n",
       "      <td>20278.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>1055.0</td>\n",
       "      <td>14158.0</td>\n",
       "      <td>1168.0</td>\n",
       "      <td>22646.0</td>\n",
       "      <td>385.0</td>\n",
       "      <td>333.0</td>\n",
       "      <td>-3397.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>Îles Salomon</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>808.0</td>\n",
       "      <td>89.35</td>\n",
       "      <td>2.37</td>\n",
       "      <td>16.13</td>\n",
       "      <td>64.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>174 rows × 16 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                      Zone  Aliments pour animaux  Autres Utilisations  \\\n",
       "0              Afghanistan                  560.0                  0.0   \n",
       "1           Afrique du Sud                 4824.0                  0.0   \n",
       "2                  Albanie                  411.0                134.0   \n",
       "3                  Algérie                 4337.0                820.0   \n",
       "4                Allemagne                26615.0               1013.0   \n",
       "..                     ...                    ...                  ...   \n",
       "169    Émirats arabes unis                 1053.0                263.0   \n",
       "170               Équateur                  847.0                787.0   \n",
       "171  États-Unis d'Amérique               140096.0             137181.0   \n",
       "172               Éthiopie                  667.0               3569.0   \n",
       "173           Îles Salomon                    0.0                 12.0   \n",
       "\n",
       "     Disponibilité alimentaire (Kcal/personne/jour)  \\\n",
       "0                                            1560.0   \n",
       "1                                            1538.0   \n",
       "2                                            1144.0   \n",
       "3                                            1678.0   \n",
       "4                                             872.0   \n",
       "..                                              ...   \n",
       "169                                          1379.0   \n",
       "170                                           812.0   \n",
       "171                                           801.0   \n",
       "172                                          1362.0   \n",
       "173                                           808.0   \n",
       "\n",
       "     Disponibilité alimentaire en quantité (kg/personne/an)  \\\n",
       "0                                               179.87        \n",
       "1                                               180.02        \n",
       "2                                               149.27        \n",
       "3                                               217.67        \n",
       "4                                               111.11        \n",
       "..                                                 ...        \n",
       "169                                             158.68        \n",
       "170                                              95.57        \n",
       "171                                             105.63        \n",
       "172                                             150.46        \n",
       "173                                              89.35        \n",
       "\n",
       "     Disponibilité de matière grasse en quantité (g/personne/jour)  \\\n",
       "0                                                 5.52               \n",
       "1                                                10.20               \n",
       "2                                                 6.08               \n",
       "3                                                 6.79               \n",
       "4                                                 3.48               \n",
       "..                                                 ...               \n",
       "169                                               5.66               \n",
       "170                                               3.12               \n",
       "171                                               3.63               \n",
       "172                                               6.06               \n",
       "173                                               2.37               \n",
       "\n",
       "     Disponibilité de protéines en quantité (g/personne/jour)  \\\n",
       "0                                                41.04          \n",
       "1                                                41.09          \n",
       "2                                                35.49          \n",
       "3                                                49.33          \n",
       "4                                                26.39          \n",
       "..                                                 ...          \n",
       "169                                              34.21          \n",
       "170                                              18.85          \n",
       "171                                              23.70          \n",
       "172                                              36.69          \n",
       "173                                              16.13          \n",
       "\n",
       "     Disponibilité intérieure  Exportations - Quantité  \\\n",
       "0                      7303.0                      0.0   \n",
       "1                     15493.0                   3777.0   \n",
       "2                      1145.0                      4.0   \n",
       "3                     15013.0                      2.0   \n",
       "4                     42158.0                  16721.0   \n",
       "..                        ...                      ...   \n",
       "169                    3142.0                    619.0   \n",
       "170                    3407.0                     53.0   \n",
       "171                  343006.0                  66302.0   \n",
       "172                   20278.0                     24.0   \n",
       "173                      64.0                      0.0   \n",
       "\n",
       "     Importations - Quantité  Nourriture  Pertes  Production  Semences  \\\n",
       "0                     1303.0      5494.0   883.0      6350.0     363.0   \n",
       "1                     3147.0      9503.0   500.0     14155.0      73.0   \n",
       "2                      468.0       474.0    91.0       703.0      22.0   \n",
       "3                    10279.0      8535.0  1024.0      4914.0     253.0   \n",
       "4                    11093.0      9191.0  1221.0     47757.0    1027.0   \n",
       "..                       ...         ...     ...         ...       ...   \n",
       "169                   4249.0      1484.0   384.0        55.0       0.0   \n",
       "170                    877.0      1505.0   138.0      2598.0      39.0   \n",
       "171                  13477.0     33810.0   222.0    433686.0    3098.0   \n",
       "172                   1055.0     14158.0  1168.0     22646.0     385.0   \n",
       "173                     62.0        50.0     1.0         3.0       0.0   \n",
       "\n",
       "     Traitement  Variation de stock  \n",
       "0           0.0              -350.0  \n",
       "1         593.0              1969.0  \n",
       "2          12.0               -22.0  \n",
       "3          42.0              -180.0  \n",
       "4        3090.0                28.0  \n",
       "..          ...                 ...  \n",
       "169         0.0              -543.0  \n",
       "170        93.0               -15.0  \n",
       "171     28608.0            -37854.0  \n",
       "172       333.0             -3397.0  \n",
       "173         1.0                 0.0  \n",
       "\n",
       "[174 rows x 16 columns]"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dispo_cereales_j2 = dispo_ali[dispo_ali['Produit'].isin(cereales_liste)].groupby(by=[\"Zone\"], as_index=False).sum()\n",
    "dispo_cereales_j2"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a39c4ac1",
   "metadata": {},
   "source": [
    "### on calcule la proportion de la quantité totale de céréales disponible allouée à l'alimentation humaine et animale"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "id": "02bc6276",
   "metadata": {},
   "outputs": [],
   "source": [
    "proportion_animaux_j2 = dispo_cereales_j2['Aliments pour animaux'].sum()* 100 / dispo_cereales_j2['Disponibilité intérieure'].sum()\n",
    "proportion_nourriture_j2 = dispo_cereales_j2['Nourriture'].sum() * 100 / dispo_cereales_j2['Disponibilité intérieure'].sum()\n",
    "difference_nourriture_animaux_j2 = proportion_nourriture_j2 / proportion_animaux_j2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 97,
   "id": "1ecdc414",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "La part de céréales allouée à l'alimentation humaine est de 42.75 %, la part allouée à l'alimentation animale est \n",
      "de 36.29 %, soit environ 1.18 fois moins.\n"
     ]
    }
   ],
   "source": [
    "print(\"La part de céréales allouée à l'alimentation humaine est de \" + str(round(proportion_nourriture_j2, 2)) + \" %, la part allouée à l'alimentation animale est \\nde \" + str(round(proportion_animaux_j2, 2)) + \" %, soit environ \" + str(round(difference_nourriture_animaux_j2, 2)) + \" fois moins.\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c883e8ab",
   "metadata": {},
   "source": [
    "<h1 style=\"margin: auto; color: rgb(93,138,191); \">Julien 3 / Exemple de l’utilisation du manioc par la Thaïlande aux égards de la proportion de personnes en sous-nutrition (exportation par rapport à la production)\n",
    "</h1>\n",
    "</div>"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "be925ee0",
   "metadata": {},
   "source": [
    "### recherche des données que nous possédons pour l'utilisation du manioc en thaïlande et création du dataframe manioc_population_sous_nutrition_thailande_j3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "id": "3b38fca7",
   "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>Zone</th>\n",
       "      <th>Produit</th>\n",
       "      <th>Origine</th>\n",
       "      <th>Aliments pour animaux</th>\n",
       "      <th>Autres Utilisations</th>\n",
       "      <th>Disponibilité alimentaire (Kcal/personne/jour)</th>\n",
       "      <th>Disponibilité alimentaire en quantité (kg/personne/an)</th>\n",
       "      <th>Disponibilité de matière grasse en quantité (g/personne/jour)</th>\n",
       "      <th>Disponibilité de protéines en quantité (g/personne/jour)</th>\n",
       "      <th>Disponibilité intérieure</th>\n",
       "      <th>Exportations - Quantité</th>\n",
       "      <th>Importations - Quantité</th>\n",
       "      <th>Nourriture</th>\n",
       "      <th>Pertes</th>\n",
       "      <th>Production</th>\n",
       "      <th>Semences</th>\n",
       "      <th>Traitement</th>\n",
       "      <th>Variation de stock</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>13809</th>\n",
       "      <td>Thaïlande</td>\n",
       "      <td>Manioc</td>\n",
       "      <td>vegetale</td>\n",
       "      <td>1800.0</td>\n",
       "      <td>2081.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>0.14</td>\n",
       "      <td>6264.0</td>\n",
       "      <td>25214.0</td>\n",
       "      <td>1250.0</td>\n",
       "      <td>871.0</td>\n",
       "      <td>1511.0</td>\n",
       "      <td>30228.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Zone Produit   Origine  Aliments pour animaux  \\\n",
       "13809  Thaïlande  Manioc  vegetale                 1800.0   \n",
       "\n",
       "       Autres Utilisations  Disponibilité alimentaire (Kcal/personne/jour)  \\\n",
       "13809               2081.0                                            40.0   \n",
       "\n",
       "       Disponibilité alimentaire en quantité (kg/personne/an)  \\\n",
       "13809                                               13.0        \n",
       "\n",
       "       Disponibilité de matière grasse en quantité (g/personne/jour)  \\\n",
       "13809                                               0.05               \n",
       "\n",
       "       Disponibilité de protéines en quantité (g/personne/jour)  \\\n",
       "13809                                               0.14          \n",
       "\n",
       "       Disponibilité intérieure  Exportations - Quantité  \\\n",
       "13809                    6264.0                  25214.0   \n",
       "\n",
       "       Importations - Quantité  Nourriture  Pertes  Production  Semences  \\\n",
       "13809                   1250.0       871.0  1511.0     30228.0       NaN   \n",
       "\n",
       "       Traitement  Variation de stock  \n",
       "13809         0.0                 0.0  "
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "manioc_thailande_j3 = dispo_ali.loc[dispo_ali['Produit'] == 'Manioc'].loc[dispo_ali['Zone'] == 'Thaïlande']\n",
    "manioc_thailande_j3.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "id": "a4a592ce",
   "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>Zone</th>\n",
       "      <th>Année</th>\n",
       "      <th>population</th>\n",
       "      <th>population_sous_nourrie</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1312</th>\n",
       "      <td>Thaïlande</td>\n",
       "      <td>2017</td>\n",
       "      <td>69209.81</td>\n",
       "      <td>6.2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           Zone  Année  population  population_sous_nourrie\n",
       "1312  Thaïlande   2017    69209.81                      6.2"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "popu_thailande_j3 = popu_plus_sous_nutrition_m1.loc[popu_plus_sous_nutrition_m1['Zone'] == 'Thaïlande'].loc[popu_plus_sous_nutrition_m1['Année'] == 2017]\n",
    "popu_thailande_j3.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "id": "1d30659e",
   "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>Zone</th>\n",
       "      <th>Produit</th>\n",
       "      <th>Origine</th>\n",
       "      <th>Aliments pour animaux</th>\n",
       "      <th>Autres Utilisations</th>\n",
       "      <th>Disponibilité alimentaire (Kcal/personne/jour)</th>\n",
       "      <th>Disponibilité alimentaire en quantité (kg/personne/an)</th>\n",
       "      <th>Disponibilité de matière grasse en quantité (g/personne/jour)</th>\n",
       "      <th>Disponibilité de protéines en quantité (g/personne/jour)</th>\n",
       "      <th>Disponibilité intérieure</th>\n",
       "      <th>...</th>\n",
       "      <th>Importations - Quantité</th>\n",
       "      <th>Nourriture</th>\n",
       "      <th>Pertes</th>\n",
       "      <th>Production</th>\n",
       "      <th>Semences</th>\n",
       "      <th>Traitement</th>\n",
       "      <th>Variation de stock</th>\n",
       "      <th>Année</th>\n",
       "      <th>population</th>\n",
       "      <th>population_sous_nourrie</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Thaïlande</td>\n",
       "      <td>Manioc</td>\n",
       "      <td>vegetale</td>\n",
       "      <td>1800.0</td>\n",
       "      <td>2081.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.05</td>\n",
       "      <td>0.14</td>\n",
       "      <td>6264.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1250.0</td>\n",
       "      <td>871.0</td>\n",
       "      <td>1511.0</td>\n",
       "      <td>30228.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2017</td>\n",
       "      <td>69209.81</td>\n",
       "      <td>6.2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Zone Produit   Origine  Aliments pour animaux  Autres Utilisations  \\\n",
       "0  Thaïlande  Manioc  vegetale                 1800.0               2081.0   \n",
       "\n",
       "   Disponibilité alimentaire (Kcal/personne/jour)  \\\n",
       "0                                            40.0   \n",
       "\n",
       "   Disponibilité alimentaire en quantité (kg/personne/an)  \\\n",
       "0                                               13.0        \n",
       "\n",
       "   Disponibilité de matière grasse en quantité (g/personne/jour)  \\\n",
       "0                                               0.05               \n",
       "\n",
       "   Disponibilité de protéines en quantité (g/personne/jour)  \\\n",
       "0                                               0.14          \n",
       "\n",
       "   Disponibilité intérieure  ...  Importations - Quantité  Nourriture  Pertes  \\\n",
       "0                    6264.0  ...                   1250.0       871.0  1511.0   \n",
       "\n",
       "   Production  Semences  Traitement  Variation de stock  Année  population  \\\n",
       "0     30228.0       NaN         0.0                 0.0   2017    69209.81   \n",
       "\n",
       "   population_sous_nourrie  \n",
       "0                      6.2  \n",
       "\n",
       "[1 rows x 21 columns]"
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "manioc_population_sous_nutrition_thailande_j3 = pd.merge(manioc_thailande_j3, popu_thailande_j3, on = ['Zone'], how = 'left')\n",
    "manioc_population_sous_nutrition_thailande_j3"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6f3a9711",
   "metadata": {},
   "source": [
    "### on étudie la sous-nutrition et la répartition de la ressource manioc en Thaïlande"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "id": "d1beef93",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "En Thaïlande, 8.9583 % de la population totale est sous-nourrie, soit 6.2 millions de personnes.\n"
     ]
    }
   ],
   "source": [
    "proportion_sous_nourrie_j3 = round(manioc_population_sous_nutrition_thailande_j3['population_sous_nourrie'].sum() * 1000 * 100 / manioc_population_sous_nutrition_thailande_j3['population'].sum(), 4)\n",
    "print(\"En Thaïlande, \" + str(proportion_sous_nourrie_j3) + \" % de la population totale est sous-nourrie, soit \" + str(manioc_population_sous_nutrition_thailande_j3['population_sous_nourrie'].sum()) + \" millions de personnes.\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 101,
   "id": "685eb355",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Toutefois, malgré le fort taux de sous-nutrition, 25214.0 milliers de tonnes des 30228.0 milliers de tonnes \n",
      "produites sont exportées, soit 83 %.\n"
     ]
    }
   ],
   "source": [
    "proportion_export = (manioc_population_sous_nutrition_thailande_j3['Exportations - Quantité'].sum() * 100) / manioc_population_sous_nutrition_thailande_j3['Production'].sum()\n",
    "print(\"Toutefois, malgré le fort taux de sous-nutrition, \" + str(manioc_population_sous_nutrition_thailande_j3['Exportations - Quantité'].sum()) + \" milliers de tonnes des \" + str(manioc_population_sous_nutrition_thailande_j3['Production'].sum()) + \" milliers de tonnes \\nproduites sont exportées, soit \" + str(round(proportion_export)) + \" %.\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "7cc7cbb4",
   "metadata": {},
   "source": [
    "<h1 style=\"margin: auto; color: rgb(93,138,191); \">Mélanie / Une étude un peu plus fine pour chacun des pays\n",
    "</h1>\n",
    "</div>"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "bde7ce16",
   "metadata": {},
   "source": [
    "## 1/ Les pays pour lesquels la proportion de personnes sous-alimentées est la plus forte en 2017"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "id": "2966e0eb",
   "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>Zone</th>\n",
       "      <th>Année</th>\n",
       "      <th>population</th>\n",
       "      <th>population_sous_nourrie</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2013</td>\n",
       "      <td>32269.589</td>\n",
       "      <td>8.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2014</td>\n",
       "      <td>33370.794</td>\n",
       "      <td>8.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2015</td>\n",
       "      <td>34413.603</td>\n",
       "      <td>8.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2016</td>\n",
       "      <td>35383.032</td>\n",
       "      <td>9.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2017</td>\n",
       "      <td>36296.113</td>\n",
       "      <td>10.5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Zone  Année  population  population_sous_nourrie\n",
       "0  Afghanistan   2013   32269.589                      8.6\n",
       "1  Afghanistan   2014   33370.794                      8.8\n",
       "2  Afghanistan   2015   34413.603                      8.9\n",
       "3  Afghanistan   2016   35383.032                      9.7\n",
       "4  Afghanistan   2017   36296.113                     10.5"
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "popu_plus_sous_nutrition_m1.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "id": "f4ace318",
   "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>Zone</th>\n",
       "      <th>Année</th>\n",
       "      <th>population</th>\n",
       "      <th>population_sous_nourrie</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2017</td>\n",
       "      <td>36296.113</td>\n",
       "      <td>10.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Afrique du Sud</td>\n",
       "      <td>2017</td>\n",
       "      <td>57009.756</td>\n",
       "      <td>3.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Albanie</td>\n",
       "      <td>2017</td>\n",
       "      <td>2884.169</td>\n",
       "      <td>0.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Algérie</td>\n",
       "      <td>2017</td>\n",
       "      <td>41389.189</td>\n",
       "      <td>1.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Allemagne</td>\n",
       "      <td>2017</td>\n",
       "      <td>82658.409</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              Zone  Année  population  population_sous_nourrie\n",
       "4      Afghanistan   2017   36296.113                     10.5\n",
       "10  Afrique du Sud   2017   57009.756                      3.1\n",
       "16         Albanie   2017    2884.169                      0.1\n",
       "22         Algérie   2017   41389.189                      1.3\n",
       "28       Allemagne   2017   82658.409                      0.0"
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sous_alimentation_2017_mel1 = popu_plus_sous_nutrition_m1.loc[(popu_plus_sous_nutrition_m1['Année'] == 2017)]\n",
    "sous_alimentation_2017_mel1.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "id": "baa30b84",
   "metadata": {},
   "outputs": [],
   "source": [
    "sous_alimentation_2017_mel1 = sous_alimentation_2017_mel1.fillna(0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "id": "7623a004",
   "metadata": {},
   "outputs": [],
   "source": [
    "sous_alimentation_2017_mel1['sous-nutrition (%)'] = sous_alimentation_2017_mel1['population_sous_nourrie'] * 1000 * 100 / sous_alimentation_2017_mel1['population']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "id": "1ea05f56",
   "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>Zone</th>\n",
       "      <th>Année</th>\n",
       "      <th>population</th>\n",
       "      <th>population_sous_nourrie</th>\n",
       "      <th>sous-nutrition (%)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2017</td>\n",
       "      <td>36296.113</td>\n",
       "      <td>10.5</td>\n",
       "      <td>28.928718</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Afrique du Sud</td>\n",
       "      <td>2017</td>\n",
       "      <td>57009.756</td>\n",
       "      <td>3.1</td>\n",
       "      <td>5.437666</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Albanie</td>\n",
       "      <td>2017</td>\n",
       "      <td>2884.169</td>\n",
       "      <td>0.1</td>\n",
       "      <td>3.467203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Algérie</td>\n",
       "      <td>2017</td>\n",
       "      <td>41389.189</td>\n",
       "      <td>1.3</td>\n",
       "      <td>3.140917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Allemagne</td>\n",
       "      <td>2017</td>\n",
       "      <td>82658.409</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              Zone  Année  population  population_sous_nourrie  \\\n",
       "4      Afghanistan   2017   36296.113                     10.5   \n",
       "10  Afrique du Sud   2017   57009.756                      3.1   \n",
       "16         Albanie   2017    2884.169                      0.1   \n",
       "22         Algérie   2017   41389.189                      1.3   \n",
       "28       Allemagne   2017   82658.409                      0.0   \n",
       "\n",
       "    sous-nutrition (%)  \n",
       "4            28.928718  \n",
       "10            5.437666  \n",
       "16            3.467203  \n",
       "22            3.140917  \n",
       "28            0.000000  "
      ]
     },
     "execution_count": 63,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sous_alimentation_2017_mel1.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "id": "ebad2d34",
   "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>Zone</th>\n",
       "      <th>Année</th>\n",
       "      <th>population</th>\n",
       "      <th>population_sous_nourrie</th>\n",
       "      <th>sous-nutrition (%)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>526</th>\n",
       "      <td>Haïti</td>\n",
       "      <td>2017</td>\n",
       "      <td>10982.366</td>\n",
       "      <td>5.3</td>\n",
       "      <td>48.259182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1090</th>\n",
       "      <td>République populaire démocratique de Corée</td>\n",
       "      <td>2017</td>\n",
       "      <td>25429.825</td>\n",
       "      <td>12.0</td>\n",
       "      <td>47.188685</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>772</th>\n",
       "      <td>Madagascar</td>\n",
       "      <td>2017</td>\n",
       "      <td>25570.512</td>\n",
       "      <td>10.5</td>\n",
       "      <td>41.062924</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>736</th>\n",
       "      <td>Libéria</td>\n",
       "      <td>2017</td>\n",
       "      <td>4702.226</td>\n",
       "      <td>1.8</td>\n",
       "      <td>38.279742</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>718</th>\n",
       "      <td>Lesotho</td>\n",
       "      <td>2017</td>\n",
       "      <td>2091.534</td>\n",
       "      <td>0.8</td>\n",
       "      <td>38.249438</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                            Zone  Année  population  \\\n",
       "526                                        Haïti   2017   10982.366   \n",
       "1090  République populaire démocratique de Corée   2017   25429.825   \n",
       "772                                   Madagascar   2017   25570.512   \n",
       "736                                      Libéria   2017    4702.226   \n",
       "718                                      Lesotho   2017    2091.534   \n",
       "\n",
       "      population_sous_nourrie  sous-nutrition (%)  \n",
       "526                       5.3           48.259182  \n",
       "1090                     12.0           47.188685  \n",
       "772                      10.5           41.062924  \n",
       "736                       1.8           38.279742  \n",
       "718                       0.8           38.249438  "
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "proportion_sous_alimentation_2017_mel1 = sous_alimentation_2017_mel1.sort_values(by=['sous-nutrition (%)'], ascending=False)\n",
    "proportion_sous_alimentation_2017_mel1.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "id": "94162a87",
   "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>index</th>\n",
       "      <th>Zone</th>\n",
       "      <th>sous-nutrition (%)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>526</td>\n",
       "      <td>Haïti</td>\n",
       "      <td>48.259182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1090</td>\n",
       "      <td>République populaire démocratique de Corée</td>\n",
       "      <td>47.188685</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>772</td>\n",
       "      <td>Madagascar</td>\n",
       "      <td>41.062924</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>736</td>\n",
       "      <td>Libéria</td>\n",
       "      <td>38.279742</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>718</td>\n",
       "      <td>Lesotho</td>\n",
       "      <td>38.249438</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1300</td>\n",
       "      <td>Tchad</td>\n",
       "      <td>37.957606</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1120</td>\n",
       "      <td>Rwanda</td>\n",
       "      <td>35.055619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>874</td>\n",
       "      <td>Mozambique</td>\n",
       "      <td>32.810898</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1318</td>\n",
       "      <td>Timor-Leste</td>\n",
       "      <td>32.173531</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>4</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>28.928718</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>292</td>\n",
       "      <td>Congo</td>\n",
       "      <td>27.393535</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1390</td>\n",
       "      <td>Venezuela (République bolivarienne du)</td>\n",
       "      <td>27.208586</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1222</td>\n",
       "      <td>Sierra Leone</td>\n",
       "      <td>26.707893</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    index                                        Zone  sous-nutrition (%)\n",
       "0     526                                       Haïti           48.259182\n",
       "1    1090  République populaire démocratique de Corée           47.188685\n",
       "2     772                                  Madagascar           41.062924\n",
       "3     736                                     Libéria           38.279742\n",
       "4     718                                     Lesotho           38.249438\n",
       "5    1300                                       Tchad           37.957606\n",
       "6    1120                                      Rwanda           35.055619\n",
       "7     874                                  Mozambique           32.810898\n",
       "8    1318                                 Timor-Leste           32.173531\n",
       "9       4                                 Afghanistan           28.928718\n",
       "10    292                                       Congo           27.393535\n",
       "11   1390      Venezuela (République bolivarienne du)           27.208586\n",
       "12   1222                                Sierra Leone           26.707893"
      ]
     },
     "execution_count": 65,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "top_proportion_sous_alimentation_2017_mel1 = proportion_sous_alimentation_2017_mel1.loc[proportion_sous_alimentation_2017_mel1['sous-nutrition (%)'] > 25]\n",
    "top_proportion_sous_alimentation_2017_mel1 = top_proportion_sous_alimentation_2017_mel1.drop(['Année', 'population', 'population_sous_nourrie'], axis = 1)\n",
    "top_proportion_sous_alimentation_2017_mel1 = top_proportion_sous_alimentation_2017_mel1.reset_index()\n",
    "top_proportion_sous_alimentation_2017_mel1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "id": "f0afde0c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Haïti',\n",
       " 'République populaire démocratique de Corée',\n",
       " 'Madagascar',\n",
       " 'Libéria',\n",
       " 'Lesotho',\n",
       " 'Tchad',\n",
       " 'Rwanda',\n",
       " 'Mozambique',\n",
       " 'Timor-Leste',\n",
       " 'Afghanistan',\n",
       " 'Congo',\n",
       " 'Venezuela (République bolivarienne du)',\n",
       " 'Sierra Leone']"
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "top_pays_sous_nourris = top_proportion_sous_alimentation_2017_mel1['Zone'].to_list()\n",
    "top_pays_sous_nourris"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "id": "e435566e",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Les pays pour lesquels la population sous-alimentée est la plus importante (> 25% de la population globale) sont : ['Haïti', 'République populaire démocratique de Corée', 'Madagascar', 'Libéria', 'Lesotho', 'Tchad', 'Rwanda', 'Mozambique', 'Timor-Leste', 'Afghanistan', 'Congo', 'Venezuela (République bolivarienne du)', 'Sierra Leone']\n"
     ]
    }
   ],
   "source": [
    "print(\"Les pays pour lesquels la population sous-alimentée est la plus importante (> 25% de la population globale) sont : \" + str(top_pays_sous_nourris))"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8a53e7b5",
   "metadata": {},
   "source": [
    "## 2/ Les pays qui ont le plus bénéficié d’aide depuis 2013"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "id": "c0716015",
   "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>Pays bénéficiaire</th>\n",
       "      <th>Année</th>\n",
       "      <th>Produit</th>\n",
       "      <th>Valeur</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2013</td>\n",
       "      <td>Autres non-céréales</td>\n",
       "      <td>682</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2014</td>\n",
       "      <td>Autres non-céréales</td>\n",
       "      <td>335</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2013</td>\n",
       "      <td>Blé et Farin</td>\n",
       "      <td>39224</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2014</td>\n",
       "      <td>Blé et Farin</td>\n",
       "      <td>15160</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2013</td>\n",
       "      <td>Céréales</td>\n",
       "      <td>40504</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Pays bénéficiaire  Année              Produit  Valeur\n",
       "0       Afghanistan   2013  Autres non-céréales     682\n",
       "1       Afghanistan   2014  Autres non-céréales     335\n",
       "2       Afghanistan   2013         Blé et Farin   39224\n",
       "3       Afghanistan   2014         Blé et Farin   15160\n",
       "4       Afghanistan   2013             Céréales   40504"
      ]
     },
     "execution_count": 68,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "aide_ali.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "id": "61e47c2f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Valeur</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pays bénéficiaire</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Afghanistan</th>\n",
       "      <td>185452</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Algérie</th>\n",
       "      <td>81114</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Angola</th>\n",
       "      <td>5014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Bangladesh</th>\n",
       "      <td>348188</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Bhoutan</th>\n",
       "      <td>2666</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   Valeur\n",
       "Pays bénéficiaire        \n",
       "Afghanistan        185452\n",
       "Algérie             81114\n",
       "Angola               5014\n",
       "Bangladesh         348188\n",
       "Bhoutan              2666"
      ]
     },
     "execution_count": 69,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cumul_aides_mel2 = aide_ali.groupby('Pays bénéficiaire').sum()\n",
    "cumul_aides_mel2 = cumul_aides_mel2.drop('Année', axis=1)\n",
    "cumul_aides_mel2.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "id": "48f7f0df",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Valeur</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pays bénéficiaire</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>République arabe syrienne</th>\n",
       "      <td>1858943</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Éthiopie</th>\n",
       "      <td>1381294</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Yémen</th>\n",
       "      <td>1206484</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Soudan du Sud</th>\n",
       "      <td>695248</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Soudan</th>\n",
       "      <td>669784</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kenya</th>\n",
       "      <td>552836</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Bangladesh</th>\n",
       "      <td>348188</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Somalie</th>\n",
       "      <td>292678</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>République démocratique du Congo</th>\n",
       "      <td>288502</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Niger</th>\n",
       "      <td>276344</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tchad</th>\n",
       "      <td>267966</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pakistan</th>\n",
       "      <td>231072</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>République populaire démocratique de Corée</th>\n",
       "      <td>187412</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Afghanistan</th>\n",
       "      <td>185452</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>République-Unie de Tanzanie</th>\n",
       "      <td>172022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Philippines</th>\n",
       "      <td>171722</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Palestine</th>\n",
       "      <td>169684</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mali</th>\n",
       "      <td>149586</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Haïti</th>\n",
       "      <td>116450</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nicaragua</th>\n",
       "      <td>115332</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             Valeur\n",
       "Pays bénéficiaire                                  \n",
       "République arabe syrienne                   1858943\n",
       "Éthiopie                                    1381294\n",
       "Yémen                                       1206484\n",
       "Soudan du Sud                                695248\n",
       "Soudan                                       669784\n",
       "Kenya                                        552836\n",
       "Bangladesh                                   348188\n",
       "Somalie                                      292678\n",
       "République démocratique du Congo             288502\n",
       "Niger                                        276344\n",
       "Tchad                                        267966\n",
       "Pakistan                                     231072\n",
       "République populaire démocratique de Corée   187412\n",
       "Afghanistan                                  185452\n",
       "République-Unie de Tanzanie                  172022\n",
       "Philippines                                  171722\n",
       "Palestine                                    169684\n",
       "Mali                                         149586\n",
       "Haïti                                        116450\n",
       "Nicaragua                                    115332"
      ]
     },
     "execution_count": 70,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cumul_desc_aides_mel2 = cumul_aides_mel2.sort_values(by=['Valeur'], ascending=False)\n",
    "cumul_desc_aides_mel2.head(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "id": "95422789",
   "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>Pays bénéficiaire</th>\n",
       "      <th>Valeur</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>République arabe syrienne</td>\n",
       "      <td>1858943</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Éthiopie</td>\n",
       "      <td>1381294</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Yémen</td>\n",
       "      <td>1206484</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Soudan du Sud</td>\n",
       "      <td>695248</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Soudan</td>\n",
       "      <td>669784</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Kenya</td>\n",
       "      <td>552836</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Bangladesh</td>\n",
       "      <td>348188</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Somalie</td>\n",
       "      <td>292678</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>République démocratique du Congo</td>\n",
       "      <td>288502</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Niger</td>\n",
       "      <td>276344</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Tchad</td>\n",
       "      <td>267966</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Pakistan</td>\n",
       "      <td>231072</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   Pays bénéficiaire   Valeur\n",
       "0          République arabe syrienne  1858943\n",
       "1                           Éthiopie  1381294\n",
       "2                              Yémen  1206484\n",
       "3                      Soudan du Sud   695248\n",
       "4                             Soudan   669784\n",
       "5                              Kenya   552836\n",
       "6                         Bangladesh   348188\n",
       "7                            Somalie   292678\n",
       "8   République démocratique du Congo   288502\n",
       "9                              Niger   276344\n",
       "10                             Tchad   267966\n",
       "11                          Pakistan   231072"
      ]
     },
     "execution_count": 71,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "top_aides_mel2 = cumul_desc_aides_mel2.loc[cumul_desc_aides_mel2['Valeur'] > 200000]\n",
    "top_aides_mel2 = top_aides_mel2.reset_index()\n",
    "top_aides_mel2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "id": "77b75006",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['République arabe syrienne',\n",
       " 'Éthiopie',\n",
       " 'Yémen',\n",
       " 'Soudan du Sud',\n",
       " 'Soudan',\n",
       " 'Kenya',\n",
       " 'Bangladesh',\n",
       " 'Somalie',\n",
       " 'République démocratique du Congo',\n",
       " 'Niger',\n",
       " 'Tchad',\n",
       " 'Pakistan']"
      ]
     },
     "execution_count": 72,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "top_pays_aidés = top_aides_mel2['Pays bénéficiaire'].to_list()\n",
    "top_pays_aidés"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "id": "019fe79b",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Les pays ayant bénéficié de l'aide alimentaire la plus importante (> 200 000 tonnnes) depuis 2013 sont, par ordre \n",
      "décroissant : ['République arabe syrienne', 'Éthiopie', 'Yémen', 'Soudan du Sud', 'Soudan', 'Kenya', 'Bangladesh', 'Somalie', 'République démocratique du Congo', 'Niger', 'Tchad', 'Pakistan']\n"
     ]
    }
   ],
   "source": [
    "print(\"Les pays ayant bénéficié de l'aide alimentaire la plus importante (> 200 000 tonnnes) depuis 2013 sont, par ordre \\ndécroissant : \" + str(top_pays_aidés))"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9b485762",
   "metadata": {},
   "source": [
    "## 3/ Les pays ayant le plus/le moins de disponibilité/habitant"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "id": "3aff7099",
   "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>Zone</th>\n",
       "      <th>Disponibilité alimentaire (Kcal/personne/jour)</th>\n",
       "      <th>Année</th>\n",
       "      <th>population</th>\n",
       "      <th>Disponibilité alimentaire (kcal/an)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2087.0</td>\n",
       "      <td>2017</td>\n",
       "      <td>36296.113</td>\n",
       "      <td>2.766768e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Afrique du Sud</td>\n",
       "      <td>3020.0</td>\n",
       "      <td>2017</td>\n",
       "      <td>57009.756</td>\n",
       "      <td>6.288490e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Albanie</td>\n",
       "      <td>3188.0</td>\n",
       "      <td>2017</td>\n",
       "      <td>2884.169</td>\n",
       "      <td>3.358375e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Algérie</td>\n",
       "      <td>3293.0</td>\n",
       "      <td>2017</td>\n",
       "      <td>41389.189</td>\n",
       "      <td>4.978160e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Allemagne</td>\n",
       "      <td>3503.0</td>\n",
       "      <td>2017</td>\n",
       "      <td>82658.409</td>\n",
       "      <td>1.057590e+11</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             Zone  Disponibilité alimentaire (Kcal/personne/jour)  Année  \\\n",
       "0     Afghanistan                                          2087.0   2017   \n",
       "1  Afrique du Sud                                          3020.0   2017   \n",
       "2         Albanie                                          3188.0   2017   \n",
       "3         Algérie                                          3293.0   2017   \n",
       "4       Allemagne                                          3503.0   2017   \n",
       "\n",
       "   population  Disponibilité alimentaire (kcal/an)  \n",
       "0   36296.113                         2.766768e+10  \n",
       "1   57009.756                         6.288490e+10  \n",
       "2    2884.169                         3.358375e+09  \n",
       "3   41389.189                         4.978160e+10  \n",
       "4   82658.409                         1.057590e+11  "
      ]
     },
     "execution_count": 74,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "kcal_pays_popu_m2.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "id": "9da1e969",
   "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>Zone</th>\n",
       "      <th>Disponibilité alimentaire (Kcal/personne/jour)</th>\n",
       "      <th>Année</th>\n",
       "      <th>population</th>\n",
       "      <th>Disponibilité alimentaire (kcal/an)</th>\n",
       "      <th>index</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Autriche</td>\n",
       "      <td>3770.0</td>\n",
       "      <td>2017</td>\n",
       "      <td>8819.901</td>\n",
       "      <td>1.214494e+10</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Belgique</td>\n",
       "      <td>3737.0</td>\n",
       "      <td>2017</td>\n",
       "      <td>11419.748</td>\n",
       "      <td>1.558726e+10</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Turquie</td>\n",
       "      <td>3708.0</td>\n",
       "      <td>2017</td>\n",
       "      <td>81116.450</td>\n",
       "      <td>1.098598e+11</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>États-Unis d'Amérique</td>\n",
       "      <td>3682.0</td>\n",
       "      <td>2017</td>\n",
       "      <td>325084.756</td>\n",
       "      <td>4.371904e+11</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Israël</td>\n",
       "      <td>3610.0</td>\n",
       "      <td>2017</td>\n",
       "      <td>8243.848</td>\n",
       "      <td>1.086995e+10</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Zone  Disponibilité alimentaire (Kcal/personne/jour)  \\\n",
       "0               Autriche                                          3770.0   \n",
       "1               Belgique                                          3737.0   \n",
       "2                Turquie                                          3708.0   \n",
       "3  États-Unis d'Amérique                                          3682.0   \n",
       "4                 Israël                                          3610.0   \n",
       "\n",
       "   Année  population  Disponibilité alimentaire (kcal/an)  index  \n",
       "0   2017    8819.901                         1.214494e+10      0  \n",
       "1   2017   11419.748                         1.558726e+10      1  \n",
       "2   2017   81116.450                         1.098598e+11      2  \n",
       "3   2017  325084.756                         4.371904e+11      3  \n",
       "4   2017    8243.848                         1.086995e+10      4  "
      ]
     },
     "execution_count": 75,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dispo_ali_mel3 = kcal_pays_popu_m2.sort_values(by=['Disponibilité alimentaire (Kcal/personne/jour)'], ascending=False)\n",
    "dispo_ali_mel3 = dispo_ali_mel3.reset_index()\n",
    "dispo_ali_mel3 = dispo_ali_mel3.drop(['index'], axis = 1)\n",
    "dispo_ali_mel3['index'] = dispo_ali_mel3.index\n",
    "dispo_ali_mel3.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "id": "2de80036",
   "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>Zone</th>\n",
       "      <th>Disponibilité alimentaire (Kcal/personne/jour)</th>\n",
       "      <th>index</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Autriche</td>\n",
       "      <td>3770.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Belgique</td>\n",
       "      <td>3737.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Turquie</td>\n",
       "      <td>3708.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>États-Unis d'Amérique</td>\n",
       "      <td>3682.0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Israël</td>\n",
       "      <td>3610.0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Zone  Disponibilité alimentaire (Kcal/personne/jour)  \\\n",
       "0               Autriche                                          3770.0   \n",
       "1               Belgique                                          3737.0   \n",
       "2                Turquie                                          3708.0   \n",
       "3  États-Unis d'Amérique                                          3682.0   \n",
       "4                 Israël                                          3610.0   \n",
       "\n",
       "   index  \n",
       "0      0  \n",
       "1      1  \n",
       "2      2  \n",
       "3      3  \n",
       "4      4  "
      ]
     },
     "execution_count": 76,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dispo_mel3 = dispo_ali_mel3.drop(['Année', 'population', 'Disponibilité alimentaire (kcal/an)'], axis=1)\n",
    "dispo_mel3.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "id": "cddaff72",
   "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>Disponibilité alimentaire (Kcal/personne/jour)</th>\n",
       "      <th>index</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>172.000000</td>\n",
       "      <td>172.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>2841.639535</td>\n",
       "      <td>85.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>437.740608</td>\n",
       "      <td>49.796252</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>1879.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>2523.250000</td>\n",
       "      <td>42.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>2827.000000</td>\n",
       "      <td>85.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>3174.750000</td>\n",
       "      <td>128.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>3770.000000</td>\n",
       "      <td>171.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       Disponibilité alimentaire (Kcal/personne/jour)       index\n",
       "count                                      172.000000  172.000000\n",
       "mean                                      2841.639535   85.500000\n",
       "std                                        437.740608   49.796252\n",
       "min                                       1879.000000    0.000000\n",
       "25%                                       2523.250000   42.750000\n",
       "50%                                       2827.000000   85.500000\n",
       "75%                                       3174.750000  128.250000\n",
       "max                                       3770.000000  171.000000"
      ]
     },
     "execution_count": 77,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dispo_mel3.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "id": "60adbbde",
   "metadata": {},
   "outputs": [],
   "source": [
    "pays_dispo_ali = dispo_mel3['Zone'].to_list()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "id": "4a42729a",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Autriche : 3770.0\n",
      "Belgique : 3737.0\n",
      "Turquie : 3708.0\n",
      "États-Unis d'Amérique : 3682.0\n",
      "Israël : 3610.0\n",
      "Irlande : 3602.0\n",
      "Italie : 3578.0\n",
      "Luxembourg : 3540.0\n",
      "Égypte : 3518.0\n",
      "Allemagne : 3503.0\n",
      "Canada : 3499.0\n",
      "Koweït : 3499.0\n",
      "Monténégro : 3490.0\n",
      "Norvège : 3483.0\n",
      "France : 3482.0\n",
      "Portugal : 3472.0\n",
      "Pologne : 3450.0\n",
      "Lituanie : 3414.0\n",
      "Maroc : 3402.0\n",
      "Cuba : 3402.0\n",
      "Grèce : 3394.0\n",
      "Suisse : 3393.0\n",
      "Islande : 3381.0\n",
      "Malte : 3374.0\n",
      "Finlande : 3366.0\n",
      "Danemark : 3366.0\n",
      "Fédération de Russie : 3360.0\n",
      "Roumanie : 3359.0\n",
      "Tunisie : 3349.0\n",
      "République de Corée : 3333.0\n",
      "Algérie : 3293.0\n",
      "Chine - RAS de Hong-Kong : 3286.0\n",
      "Australie : 3278.0\n",
      "Émirats arabes unis : 3275.0\n",
      "Brésil : 3262.0\n",
      "Kazakhstan : 3262.0\n",
      "Arabie saoudite : 3255.0\n",
      "Bélarus : 3249.0\n",
      "Estonie : 3248.0\n",
      "Argentine : 3226.0\n",
      "Pays-Bas : 3222.0\n",
      "Albanie : 3188.0\n",
      "Suède : 3180.0\n",
      "Espagne : 3173.0\n",
      "Lettonie : 3172.0\n",
      "Slovénie : 3168.0\n",
      "Bosnie-Herzégovine : 3156.0\n",
      "Oman : 3140.0\n",
      "Ukraine : 3138.0\n",
      "Nouvelle-Zélande : 3136.0\n",
      "Azerbaïdjan : 3113.0\n",
      "Chine, continentale : 3112.0\n",
      "Jordanie : 3099.0\n",
      "Iran (République islamique d') : 3089.0\n",
      "Mexique : 3068.0\n",
      "Maurice : 3067.0\n",
      "Liban : 3059.0\n",
      "Croatie : 3056.0\n",
      "Uruguay : 3052.0\n",
      "Trinité-et-Tobago : 3049.0\n",
      "Kiribati : 3042.0\n",
      "Hongrie : 3034.0\n",
      "Afrique du Sud : 3020.0\n",
      "Ghana : 3014.0\n",
      "Chine, Taiwan Province de : 2998.0\n",
      "Brunéi Darussalam : 2985.0\n",
      "Chili : 2980.0\n",
      "Saint-Vincent-et-les Grenadines : 2965.0\n",
      "Samoa : 2956.0\n",
      "Macédoine du Nord : 2946.0\n",
      "Slovaquie : 2943.0\n",
      "Fidji : 2943.0\n",
      "Barbade : 2936.0\n",
      "Dominique : 2930.0\n",
      "Arménie : 2924.0\n",
      "Polynésie française : 2923.0\n",
      "Chine - RAS de Macao : 2915.0\n",
      "Malaisie : 2914.0\n",
      "Géorgie : 2902.0\n",
      "Mali : 2887.0\n",
      "Mauritanie : 2875.0\n",
      "Nouvelle-Calédonie : 2855.0\n",
      "Costa Rica : 2846.0\n",
      "Turkménistan : 2836.0\n",
      "Vanuatu : 2833.0\n",
      "Bulgarie : 2828.0\n",
      "Gabon : 2826.0\n",
      "Kirghizistan : 2817.0\n",
      "Colombie : 2800.0\n",
      "Côte d'Ivoire : 2797.0\n",
      "Thaïlande : 2785.0\n",
      "Indonésie : 2776.0\n",
      "Guyana : 2762.0\n",
      "Ouzbékistan : 2759.0\n",
      "Suriname : 2752.0\n",
      "Belize : 2746.0\n",
      "Viet Nam : 2744.0\n",
      "Jamaïque : 2742.0\n",
      "Maldives : 2733.0\n",
      "Panama : 2731.0\n",
      "Japon : 2726.0\n",
      "Serbie : 2725.0\n",
      "Burkina Faso : 2717.0\n",
      "République de Moldova : 2715.0\n",
      "Nigéria : 2700.0\n",
      "Pérou : 2697.0\n",
      "Népal : 2672.0\n",
      "Bahamas : 2670.0\n",
      "Cameroun : 2669.0\n",
      "Bermudes : 2668.0\n",
      "Chypre : 2646.0\n",
      "Honduras : 2639.0\n",
      "Nicaragua : 2638.0\n",
      "Venezuela (République bolivarienne du) : 2633.0\n",
      "Gambie : 2621.0\n",
      "Bénin : 2619.0\n",
      "République dominicaine : 2611.0\n",
      "Djibouti : 2609.0\n",
      "Cabo Verde : 2605.0\n",
      "Sainte-Lucie : 2589.0\n",
      "Paraguay : 2584.0\n",
      "El Salvador : 2576.0\n",
      "Myanmar : 2574.0\n",
      "Philippines : 2568.0\n",
      "Guinée : 2567.0\n",
      "Niger : 2549.0\n",
      "Iraq : 2542.0\n",
      "Sri Lanka : 2537.0\n",
      "Lesotho : 2528.0\n",
      "Mongolie : 2509.0\n",
      "Saint-Kitts-et-Nevis : 2491.0\n",
      "Angola : 2474.0\n",
      "Cambodge : 2473.0\n",
      "République démocratique populaire lao : 2455.0\n",
      "Inde : 2454.0\n",
      "Sénégal : 2453.0\n",
      "Bangladesh : 2453.0\n",
      "Togo : 2448.0\n",
      "Grenade : 2442.0\n",
      "Pakistan : 2438.0\n",
      "Antigua-et-Barbuda : 2416.0\n",
      "Guatemala : 2416.0\n",
      "Sierra Leone : 2401.0\n",
      "Sao Tomé-et-Principe : 2398.0\n",
      "Îles Salomon : 2383.0\n",
      "Malawi : 2364.0\n",
      "Équateur : 2346.0\n",
      "Soudan : 2335.0\n",
      "Eswatini : 2326.0\n",
      "Botswana : 2325.0\n",
      "Guinée-Bissau : 2288.0\n",
      "Mozambique : 2282.0\n",
      "Bolivie (État plurinational de) : 2250.0\n",
      "Rwanda : 2224.0\n",
      "Yémen : 2217.0\n",
      "Congo : 2206.0\n",
      "Libéria : 2206.0\n",
      "Kenya : 2205.0\n",
      "République-Unie de Tanzanie : 2204.0\n",
      "Tadjikistan : 2199.0\n",
      "Namibie : 2166.0\n",
      "Timor-Leste : 2129.0\n",
      "Éthiopie : 2129.0\n",
      "Ouganda : 2126.0\n",
      "Zimbabwe : 2113.0\n",
      "Tchad : 2109.0\n",
      "République populaire démocratique de Corée : 2093.0\n",
      "Haïti : 2089.0\n",
      "Afghanistan : 2087.0\n",
      "Madagascar : 2056.0\n",
      "Zambie : 1924.0\n",
      "République centrafricaine : 1879.0\n",
      "\n",
      "Les pays disposant de la plus forte disponibilité alimentaire (> 31745.75 kcal/personnes/jour, la limite du premier quartile) sont, par ordre décroissant : \n",
      "\n",
      "['Autriche', 'Belgique', 'Turquie', \"États-Unis d'Amérique\", 'Israël', 'Irlande', 'Italie', 'Luxembourg', 'Égypte', 'Allemagne', 'Canada', 'Koweït', 'Monténégro', 'Norvège', 'France', 'Portugal', 'Pologne', 'Lituanie', 'Maroc', 'Cuba', 'Grèce', 'Suisse', 'Islande', 'Malte', 'Finlande', 'Danemark', 'Fédération de Russie', 'Roumanie', 'Tunisie', 'République de Corée', 'Algérie', 'Chine - RAS de Hong-Kong', 'Australie', 'Émirats arabes unis', 'Brésil', 'Kazakhstan', 'Arabie saoudite', 'Bélarus', 'Estonie', 'Argentine', 'Pays-Bas', 'Albanie', 'Suède']\n"
     ]
    }
   ],
   "source": [
    "pays_maxi_dispo_ali = []\n",
    "\n",
    "\n",
    "for element in pays_dispo_ali :\n",
    "    dispo = dispo_mel3.loc[dispo_mel3['Zone'] == element].sum()\n",
    "    dispo = dispo['Disponibilité alimentaire (Kcal/personne/jour)']\n",
    "    print(str(element) + \" : \" + str(dispo))\n",
    "    \n",
    "    if dispo > 3174.750000:\n",
    "        pays_maxi_dispo_ali.append(element)\n",
    "\n",
    "        \n",
    "        \n",
    "print(\"\\nLes pays disposant de la plus forte disponibilité alimentaire (> 31745.75 kcal/personnes/jour, la limite du troisième quartile) sont, par ordre décroissant : \\n\\n\" + str(pays_maxi_dispo_ali))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "id": "8b8038d9",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Les pays disposant de la plus faible disponibilité alimentaire (< 2523.250000 kcal/personnes/jour, la limite du \n",
      "troisième quartile) sont, par ordre décroissant : \n",
      "\n",
      "['Mongolie', 'Saint-Kitts-et-Nevis', 'Angola', 'Cambodge', 'République démocratique populaire lao', 'Inde', 'Sénégal', 'Bangladesh', 'Togo', 'Grenade', 'Pakistan', 'Antigua-et-Barbuda', 'Guatemala', 'Sierra Leone', 'Sao Tomé-et-Principe', 'Îles Salomon', 'Malawi', 'Équateur', 'Soudan', 'Eswatini', 'Botswana', 'Guinée-Bissau', 'Mozambique', 'Bolivie (État plurinational de)', 'Rwanda', 'Yémen', 'Congo', 'Libéria', 'Kenya', 'République-Unie de Tanzanie', 'Tadjikistan', 'Namibie', 'Timor-Leste', 'Éthiopie', 'Ouganda', 'Zimbabwe', 'Tchad', 'République populaire démocratique de Corée', 'Haïti', 'Afghanistan', 'Madagascar', 'Zambie', 'République centrafricaine']\n"
     ]
    }
   ],
   "source": [
    "pays_mini_dispo_ali = []\n",
    "\n",
    "\n",
    "for element in pays_dispo_ali :\n",
    "    dispo = dispo_mel3.loc[dispo_mel3['Zone'] == element].sum()\n",
    "    dispo = dispo['Disponibilité alimentaire (Kcal/personne/jour)']\n",
    "    ##dispo.sort_values(by='Disponibilité alimentaire (Kcal/personne/jour)', ascending=True)  \n",
    "    \n",
    "    if dispo < 2523.250000:\n",
    "        pays_mini_dispo_ali.append(element)\n",
    "        \n",
    "        \n",
    "print(\"Les pays disposant de la plus faible disponibilité alimentaire (< 2523.250000 kcal/personnes/jour, la limite du \\npremier quartile) sont, par ordre décroissant : \\n\\n\" + str(pays_mini_dispo_ali))"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a0761fc1",
   "metadata": {},
   "source": [
    "## 4/ Toutes les infos utiles pour mettre en relief les pays qui semblent être le plus en difficulté au niveau alimentaire"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "id": "5efb2893",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Sur la liste des 13 pays ayant la plus forte proportion de population en état de sous-nutrition, seul 1, ['Tchad'], fait partie des pays reçevant le plus d'aide alimentaire.\n"
     ]
    }
   ],
   "source": [
    "pays_sous_nourris_aidés = []\n",
    "\n",
    "for i in top_pays_sous_nourris:\n",
    "    for j in top_pays_aidés:\n",
    "        if(i==j):\n",
    "            pays_sous_nourris_aidés.append(i)\n",
    "            break\n",
    "            \n",
    "cb_oui = len(pays_sous_nourris_aidés)\n",
    "\n",
    "print(\"Sur la liste des 13 pays ayant la plus forte proportion de population en état de sous-nutrition, seul \" + str(cb_oui) + \", \" + str(pays_sous_nourris_aidés) + \", fait partie des pays reçevant le plus d'aide alimentaire.\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "id": "0e35b143",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Proportion de la population en état de sous-nutrition en 2017 des pays ayant reçu le plus d'aide alimentaire \n",
      "cumulée depuis 2013, par ordre décroissant : \n",
      "\n",
      "République arabe syrienne : 0.0 % \n",
      "Éthiopie : 19.83 % \n",
      "Yémen : 0.0 % \n",
      "Soudan du Sud : 0.0 % \n",
      "Soudan : 12.25 % \n",
      "Kenya : 23.7 % \n",
      "Bangladesh : 13.46 % \n",
      "Somalie : 0.0 % \n",
      "République démocratique du Congo : 0.0 % \n",
      "Niger : 0.0 % \n",
      "Tchad : 37.96 % \n",
      "Pakistan : 11.93 % \n",
      "\n",
      "Pays recevant les plus grosses quantités d'aide alimentaire, mais dont la proportion de la population en état de \n",
      "sous-nutrition est inférieure à 10% ou non déclarée : ['République arabe syrienne', 'Yémen', 'Soudan du Sud', 'Somalie', 'République démocratique du Congo', 'Niger']\n"
     ]
    }
   ],
   "source": [
    "print(\"Proportion de la population en état de sous-nutrition en 2017 des pays ayant reçu le plus d'aide alimentaire \\ncumulée depuis 2013, par ordre décroissant : \\n\")\n",
    "\n",
    "sous_nutrition_minime = []\n",
    "\n",
    "for element in top_pays_aidés :\n",
    "   \n",
    "    proportion_sous_ali = proportion_sous_alimentation_2017_mel1.loc[proportion_sous_alimentation_2017_mel1['Zone'] == element].sum()\n",
    "    proportion_sous_ali = proportion_sous_ali['sous-nutrition (%)']\n",
    "    print(str(element) + \" : \" + str(round(proportion_sous_ali, 2)) + \" % \")\n",
    "    \n",
    "    if proportion_sous_ali < 10:\n",
    "        sous_nutrition_minime.append(element)\n",
    "    else:\n",
    "        continue\n",
    "        \n",
    "print(\"\\nPays recevant les plus grosses quantités d'aide alimentaire, mais dont la proportion de la population en état de \\nsous-nutrition est inférieure à 10% ou non déclarée : \" + str(sous_nutrition_minime))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "id": "f2cbdac2",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "12 des 13 pays souffrant le plus de sous-nutrition ne reçoivent donc pas assez d'aide alimentaire. Ces pays en \n",
      "forte difficulté sont : ['Haïti', 'République populaire démocratique de Corée', 'Madagascar', 'Libéria', 'Lesotho', 'Rwanda', 'Mozambique', 'Timor-Leste', 'Afghanistan', 'Congo', 'Venezuela (République bolivarienne du)', 'Sierra Leone']\n"
     ]
    }
   ],
   "source": [
    "pays_sous_nourris_pas_aidés = []\n",
    "\n",
    "for element in top_pays_sous_nourris:\n",
    "    if element not in top_pays_aidés:\n",
    "        pays_sous_nourris_pas_aidés.append(element)\n",
    "\n",
    "cb_non = len(pays_sous_nourris_pas_aidés)\n",
    "\n",
    "print(str(cb_non) + \" des 13 pays souffrant le plus de sous-nutrition ne reçoivent donc pas assez d'aide alimentaire. Ces pays en \\nforte difficulté sont : \" + str(pays_sous_nourris_pas_aidés))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "id": "3d2c92fa",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "count    7.600000e+01\n",
       "mean     1.452092e+05\n",
       "std      3.109778e+05\n",
       "min      6.000000e+00\n",
       "25%      9.727500e+03\n",
       "50%      3.702100e+04\n",
       "75%      1.156115e+05\n",
       "max      1.858943e+06\n",
       "Name: Valeur, dtype: float64"
      ]
     },
     "execution_count": 84,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "d = aide_ali.groupby(aide_ali['Pays bénéficiaire'])\n",
    "d = d.sum()\n",
    "d['Valeur'].describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 85,
   "id": "b9f6e202",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Quantité cumulée d'aide alimentaire reçue depuis 2013 (exprimée en tonnes) de ces pays au fort taux de sous-\n",
      "nutrition, ne faisant pas partie des pays les plus aidés : \n",
      "\n",
      "Haïti : 116450\n",
      "République populaire démocratique de Corée : 187412\n",
      "Madagascar : 96678\n",
      "Libéria : 19846\n",
      "Lesotho : 10624\n",
      "Rwanda : 11408\n",
      "Mozambique : 58612\n",
      "Timor-Leste : 116\n",
      "Afghanistan : 185452\n",
      "Congo : 22950\n",
      "Venezuela (République bolivarienne du) : 0.0\n",
      "Sierra Leone : 25942\n",
      "\n",
      "Pays dont la proportion de la population en état de sous-nutrition est parmi les plus hautes, mais recevant des \n",
      "quantités d'aide alimentaire limitées (< 3.702100e+04 tonnes, la valeur médiane des aides versées) : ['Libéria', 'Lesotho', 'Rwanda', 'Timor-Leste', 'Congo', 'Venezuela (République bolivarienne du)', 'Sierra Leone']\n",
      "\n",
      "Les pays en situation critique, recevant moins de 9.727500e+03 tonnes d'aide alimentaire (la limite du premier \n",
      "quartile), sont : ['Timor-Leste', 'Venezuela (République bolivarienne du)']\n"
     ]
    }
   ],
   "source": [
    "print(\"Quantité cumulée d'aide alimentaire reçue depuis 2013 (exprimée en tonnes) de ces pays au fort taux de sous-\\nnutrition, ne faisant pas partie des pays les plus aidés : \\n\")\n",
    "\n",
    "aide_minime = []\n",
    "cata = []\n",
    "\n",
    "for element in pays_sous_nourris_pas_aidés :\n",
    "    aide = aide_ali.loc[aide_ali['Pays bénéficiaire'] == element].sum()\n",
    "    aide = aide['Valeur']\n",
    "    print(str(element) + \" : \" + str(aide))\n",
    "    \n",
    "    if aide < 3.702100e+04:\n",
    "        aide_minime.append(element)\n",
    "    if aide < 9.727500e+03:\n",
    "        cata.append(element)\n",
    "    else:\n",
    "        continue\n",
    "        \n",
    "print(\"\\nPays dont la proportion de la population en état de sous-nutrition est parmi les plus hautes, mais recevant des \\nquantités d'aide alimentaire limitées (< 3.702100e+04 tonnes, la valeur médiane des aides versées) : \" + str(aide_minime))\n",
    " \n",
    "print(\"\\nLes pays en situation critique, recevant moins de 9.727500e+03 tonnes d'aide alimentaire (la limite du premier \\nquartile), sont : \" + str(cata))"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.5"
  },
  "widgets": {
   "application/vnd.jupyter.widget-state+json": {
    "state": {},
    "version_major": 2,
    "version_minor": 0
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}