{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "790a6e9e",
   "metadata": {},
   "source": [
    "<h1>Tp communes de Vendée</h1>"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "048d088c",
   "metadata": {},
   "source": [
    "<p> 1. Importer les données du fichier <strong>Communes_Vendée_2010.csv</strong> en une table appelée <strong> Villes </strong> </p>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "e750a459",
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "import csv\n",
    "\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "1acc30d1",
   "metadata": {},
   "source": [
    "<p> 2. Modifier cette table pour que le type des données soit cohérent </p>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "9791a4b0",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "b522e585",
   "metadata": {},
   "source": [
    "<p> 3. Afficher l'instruction qui donne le nombre de communes en vendée </p>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "84963afd",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "cd5ba582",
   "metadata": {},
   "source": [
    "<p> 4. Afficher le nom des  villes et leur population qui ont moins de 500 habitants </p>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "282286a0",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "d64bbe00",
   "metadata": {},
   "source": [
    "<p> 5. Calculer le nombre d'habitants en Vendée en 2010 </p>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "9a9d04d3",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "cdc9e344",
   "metadata": {},
   "source": [
    "<p>6. Trier les communes de Vendée par ordre alphabétique </p>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "e6af43d2",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "290e4fcb",
   "metadata": {},
   "source": [
    "<p> 7. Trier les communes par densité décroissante, puis faire afficher le nom et la densité des 10 premières de cette liste  </p>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "b52facba",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "cef0096b",
   "metadata": {},
   "source": [
    "<p>8. Importer les données du fichier <strong>Communes_Vendée_géo.csv</strong> en une table appelée <strong> Geo </strong> </p>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "495ac232",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "4d836c2a",
   "metadata": {},
   "source": [
    "<p> 9. Afficher la ville la plus haute de Vendée </p>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "6745b88d",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "6cca3601",
   "metadata": {},
   "source": [
    "<p> 10 a). Créer une nouvelle table  Communes en faisant une jointure des 2 tables Villes et Geo </p> "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "6dbddc6b",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "aa3d0785",
   "metadata": {},
   "source": [
    "<p> b) Créer un fichier csv de cette table Communes. Ouvrir le bloc notes pour vérifier son existence et son contenu</p>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "8aa97447",
   "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.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}