{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# TP2. Outils numériques pour les Statistiques Descriptives \n", "\n", "Les commandes suivantes, écrites en Python, s'exécutent directement dans ce notebook (cahier d'exercices) Jupyter avec la commande `Ctrl+Entrée`, ou `Shift+Entrée` pour passer directement à la cellule suivante." ] }, { "cell_type": "code", "execution_count": 97, "metadata": {}, "outputs": [], "source": [ "# on importe les bibliothèques qui nous seront utiles\n", "from pandas import * # pour lire, importer et manipuler des données sous forme\n", "# de tableur\n", "from numpy import * # pour faire des calculs\n", "from matplotlib.pylab import * # pour faire des graphiques" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Les instructions ci-dessous permettent d'importer dans \"df\" (c'est un dataframe) les données depuis le fichier footprint.xlsx et d'en afficher les premières lignes. Exécuter et comparer au fichier xlsx." ] }, { "cell_type": "code", "execution_count": 98, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
| \n", " | Country | \n", "SDGi | \n", "Life Exectancy | \n", "HDI | \n", "Per Capita GDP | \n", "Region | \n", "Income Group | \n", "Population (millions) | \n", "Total Ecological Footprint (Production) | \n", "Total Ecological Footprint (Consumption) | \n", "Total biocapacity | \n", "Ecological (Deficit) or Reserve | \n", "Number of Earths required | \n", "Number of Countries required | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "Afghanistan | \n", "51.847886 | \n", "63.565 | \n", "0.488 | \n", "2439.68 | \n", "Middle East/Central Asia | \n", "LI | \n", "38.042 | \n", "0.750444 | \n", "0.885011 | \n", "0.578479 | \n", "-0.306532 | \n", "0.570763 | \n", "1.529894 | \n", "
| 1 | \n", "Albania | \n", "71.486061 | \n", "79.282 | \n", "0.81 | \n", "13862.6 | \n", "Other Europe | \n", "UM | \n", "2.881 | \n", "1.566569 | \n", "2.102276 | \n", "1.124433 | \n", "-0.977842 | \n", "1.355804 | \n", "1.869631 | \n", "
| 2 | \n", "Algeria | \n", "70.510917 | \n", "76.474 | \n", "0.748 | \n", "11412.2 | \n", "Africa | \n", "UM | \n", "43.053 | \n", "1.812774 | \n", "2.367408 | \n", "0.702314 | \n", "-1.665094 | \n", "1.526794 | \n", "3.370868 | \n", "
| 3 | \n", "Angola | \n", "50.974803 | \n", "62.448 | \n", "0.595 | \n", "7034.84 | \n", "Africa | \n", "LM | \n", "31.825 | \n", "0.686062 | \n", "1.006983 | \n", "1.738573 | \n", "0.731590 | \n", "0.649426 | \n", "0.579201 | \n", "
| 4 | \n", "Antigua and Barbuda | \n", "NaN | \n", "78.691 | \n", "0.8 | \n", "22000.2 | \n", "Central America/Caribbean | \n", "HI | \n", "0.097 | \n", "1.541982 | \n", "3.919553 | \n", "0.931722 | \n", "-2.987832 | \n", "2.527807 | \n", "4.206785 | \n", "