{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "6e1bde28",
   "metadata": {},
   "source": [
    "# Spécialités des premières générales de France (rentrée 2021)\n",
    "\n",
    "Récupérer le fichier csv des données, sur  le site pvmaths.\n",
    "\n",
    "Le nom complet du fichier est : fr-en-effectifs-specialites-triplettes-1ere-generale.csv\n",
    "\n",
    "Téléverser ce fichier (upload puis téléverser) dans le même emplacement que ce notebook."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "13ab1151",
   "metadata": {},
   "source": [
    "La cellule ci-dessous permet d'ouvrir le fichier des spécialités et de régler des problèmes d'affichage.\n",
    "pandas est une bibliothèque Python pour l'analyse des données. \n",
    "\n",
    "#### Exécuter la cellule ci-dessous puis toutes les autres.\n",
    "\n",
    "Observer l'affichage en sortie."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "b4a09d83",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas\n",
    "\n",
    "url = \"fr-en-effectifs-specialites-triplettes-1ere-generale.csv\"\n",
    "\n",
    "donnees = pandas.read_csv(url,sep = ',', encoding='utf-8')\n",
    "\n",
    "pandas.options.display.max_columns = 100   #pour que l affichage soit complet\n",
    "pandas.options.display.min_rows = 40    #pour afficher les 20 premières et les 20 dernières lignes"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "2b6b7d6c",
   "metadata": {},
   "source": [
    "Pour voir les descripteurs et avoir un aperçu des premières lignes du fichier : "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "3fc1d0ac",
   "metadata": {},
   "outputs": [],
   "source": [
    "donnees.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b187c6b0",
   "metadata": {},
   "source": [
    "La taille du fichier (nombre de lignes et de colonnes) s'obtient par :"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "286acd0d",
   "metadata": {},
   "outputs": [],
   "source": [
    "donnees.shape"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "4398a152",
   "metadata": {},
   "source": [
    "On peut obtenir les moyennes de chaque colonne : "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d90a9bb2",
   "metadata": {},
   "outputs": [],
   "source": [
    "donnees.mean()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a6210acc",
   "metadata": {},
   "source": [
    "Certaines moyennes n'ont pas de sens : lesquelles ?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "6df7c320",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "20c5c614",
   "metadata": {},
   "source": [
    "Si on s'intéresse à la colonne \"academie\", on obtient le nombre d'apparitions de chaque académie (donc le nombre de lycées par académie) ainsi :"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "4a4346e4",
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "donnees['academie'].value_counts()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c9eb2d26",
   "metadata": {},
   "source": [
    "Pour voir seulement le nom des lycées de la commune de Nantes :"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d0b37214",
   "metadata": {},
   "outputs": [],
   "source": [
    "donnees.loc[(donnees['commune'] == 'NANTES'), 'patronyme']"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "58b1b62d",
   "metadata": {},
   "source": [
    "Pour les compter :"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "132b2886",
   "metadata": {},
   "outputs": [],
   "source": [
    "donnees.loc[(donnees['commune'] == 'NANTES'), 'patronyme'].count()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d4e6f78a",
   "metadata": {},
   "source": [
    "Pour obtenir le nombre d'élèves de première générale à Nantes :"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "079dfec7",
   "metadata": {},
   "outputs": [],
   "source": [
    "donnees.loc[(donnees['commune'] == 'NANTES'),'effectif_total_en_premiere_generale'].sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "640b3b31",
   "metadata": {},
   "source": [
    "Pour obtenir le nombre d'élèves de 1ère générale au lycée Carcouët, il faut d'abord repérer la ligne du lycée ci-dessus,"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "78d9c33a",
   "metadata": {},
   "outputs": [],
   "source": [
    "ligneCarcouet = "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3a2a6fda",
   "metadata": {},
   "source": [
    "puis"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "ddeb3023",
   "metadata": {},
   "outputs": [],
   "source": [
    "donnees.loc[ligneCarcouet, 'effectif_total_en_premiere_generale']"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3d854131",
   "metadata": {},
   "source": [
    "Pour obtenir le nombre d'élèves de 1ère générale qui font des mathématiques au lycée Carcouët :"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "5f6c740a",
   "metadata": {},
   "outputs": [],
   "source": [
    "donnees.loc[ligneCarcouet,['0613_mathematiques_filles','0613_mathematiques_garcons']]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "52314b33",
   "metadata": {},
   "source": [
    "Pour obtenir toutes les informations sur le lycée Carcouët :"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "bab99e67",
   "metadata": {},
   "outputs": [],
   "source": [
    "pandas.options.display.max_rows = 100   #pour que l affichage soit complet\n",
    "\n",
    "donnees.loc[ligneCarcouet , :]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "fae75006",
   "metadata": {},
   "source": [
    "On peut trier les données : par nombre d'élèves par exemple :"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "0bfaaa6c",
   "metadata": {},
   "outputs": [],
   "source": [
    "donnees.sort_values('effectif_total_en_premiere_generale')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0f552003",
   "metadata": {},
   "source": [
    "## A vous de jouer !\n",
    "Utiliser les cellules vides pour répondre aux questions (vous pouvez insérer autant de cellules que vous voulez).\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b13652a6",
   "metadata": {},
   "source": [
    "Trouver le nombre de filles de première générale qui font des mathématiques (dans toute la France)."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "7788b2e4",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "4cd76ae5",
   "metadata": {},
   "source": [
    "Trouver le nombre de garçons de première générale qui font des mathématiques."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "06dbbfcf",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "dd5c3b87",
   "metadata": {},
   "source": [
    "Quel est le pourcentage d'élèves de première générale qui font des mathématiques ?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "bbbab5e7",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "787be7bb",
   "metadata": {},
   "source": [
    "Combien de lycées n'ont pas de filles dans leurs classes de première générale ?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "7ade45c7",
   "metadata": {
    "scrolled": false
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "0b2826be",
   "metadata": {},
   "source": [
    "Classer les départements en fonction du nombre de lycées. Quel est le département qui compte le moins de lycées ?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "c8fec9d5",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "e9719aa9",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "5ad276a2",
   "metadata": {},
   "source": [
    "# Communes de France\n",
    "\n",
    "Le fichier Communes.csv contient la liste de toutes les communes de France.\n",
    "\n",
    "\n",
    "Source : Populations légales 2018. Recensement de la population ( https://www.insee.fr/fr/statistiques/4989724?sommaire=4989761 )\n",
    "\n",
    "Téléverser ce fichier (upload puis téléverser) dans le même emplacement que ce notebook.   \n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "007499fb",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas\n",
    "#url = \"http://pierrick.vaire.free.fr/snt/Communes.csv\"\n",
    "\n",
    "url = \"Communes.csv\"\n",
    "\n",
    "communes = pandas.read_csv(url, sep = ';', encoding='utf-8')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ab9c3e78",
   "metadata": {},
   "source": [
    "Afficher le haut du fichier, pour voir les descripteurs."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "706d6b6c",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "f97fbc52",
   "metadata": {},
   "source": [
    "Combien y a-t-il de communes ?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "8e281838",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "ee4b1fd7",
   "metadata": {},
   "source": [
    "Afficher la ligne correspondant à Nantes."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d78e7b9b",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "599d21fa",
   "metadata": {},
   "source": [
    "Afficher la population totale de votre commune de résidence."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "312a18ec",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "1fb9f722",
   "metadata": {},
   "source": [
    "Trouver le nombre de communes sans habitants."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "bb342b82",
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "19ec19ea",
   "metadata": {},
   "source": [
    "Trouver le nombre de communes de plus de 50 000 habitants."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "0fa39e0f",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "e188f9ae",
   "metadata": {},
   "source": [
    "Quelle est la commune la plus peuplée ?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "012a2f6c",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "414287de",
   "metadata": {},
   "source": [
    "Combien y a-t-il de communes en Loire Atlantique ?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "83966de0",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "580a3c92",
   "metadata": {},
   "source": [
    "Combien y a-t-il de communes en Pays de la Loire ?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "179cb110",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "b3cd8758",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}