{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "## Premier pas avec Pandas\n", "\n", "Dans cette série de questions, vous allez pouvoir pratiquer les éléments vus dans le cours en rapport\n", "avec les bases de pandas.\n", "\n", "### I) Importation de la librairie \n", "\n", "Importer et charger la librairie pandas. N'oubliez pas l'alias `pd` pour plus de facilité par la suite." ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "# votre code ci-dessous\n", "\n", "import pandas as pd" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### II) Importation du jeu de données \n", "\n", "1. Importer le jeu de données `produits.csv` dans un dataframe nommé `produits`. **ATTENTION** Dans cet exemple, le séparateur n'est pas une `,` mais un `;`. Vous devez renseigné sep=\";\" dans le chargement de votre Dataframe. Exemple : `pd.read_csv(\"fichier.csv\", sep=\";\")`\n", "1. Afficher les 10 premières lignes du jeu de données. [Cliquez ici pour vous aider à utiliser head()](https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.head.html)" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
NomCategorieOrigineVillePrixStockValeur
0Alice MuttonViandesCEELyon195.0000.0
1Aniseed SyrupCondimentsExterieurParis50.00251250.0
2Boston Crab MeatPoissons et fruits de merExterieurParis92.00302760.0
3Camembert PierrotProduits laitiersExterieurParis170.0000.0
4Carnarvon TigersPoissons et fruits de merExterieurLyon312.5000.0
5ChaiBoissonsCEELyon90.0010900.0
6ChangBoissonsExterieurLyon95.00252375.0
7Chartreuse verteBoissonsExterieurLyon90.005450.0
8Chef Anton's Cajun SeasoningCondimentsCEELyon110.0000.0
9Chef Anton's Gumbo MixCondimentsCEEParis106.7500.0
\n", "
" ], "text/plain": [ " Nom Categorie Origine Ville \\\n", "0 Alice Mutton Viandes CEE Lyon \n", "1 Aniseed Syrup Condiments Exterieur Paris \n", "2 Boston Crab Meat Poissons et fruits de mer Exterieur Paris \n", "3 Camembert Pierrot Produits laitiers Exterieur Paris \n", "4 Carnarvon Tigers Poissons et fruits de mer Exterieur Lyon \n", "5 Chai Boissons CEE Lyon \n", "6 Chang Boissons Exterieur Lyon \n", "7 Chartreuse verte Boissons Exterieur Lyon \n", "8 Chef Anton's Cajun Seasoning Condiments CEE Lyon \n", "9 Chef Anton's Gumbo Mix Condiments CEE Paris \n", "\n", " Prix Stock Valeur \n", "0 195.00 0 0.0 \n", "1 50.00 25 1250.0 \n", "2 92.00 30 2760.0 \n", "3 170.00 0 0.0 \n", "4 312.50 0 0.0 \n", "5 90.00 10 900.0 \n", "6 95.00 25 2375.0 \n", "7 90.00 5 450.0 \n", "8 110.00 0 0.0 \n", "9 106.75 0 0.0 " ] }, "execution_count": 2, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# votre code ci-dessous\n", "produits = pd.read_csv(\"produits.csv\", sep=\";\")\n", "produits.head(10)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### II) Afficher un résumé des données \n", "\n", "1. Utiliser la fonction adaptée pour afficher les informations du jeu de données.\n", "1. Combien le jeu de données comporte-t-il de lignes? de variables (colonnes)? Répondre à la question sous forme de commentaire.\n", "1. Combien de variables de type numérique? Combien de variables de type chaîne de caractères?" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "\n", "RangeIndex: 77 entries, 0 to 76\n", "Data columns (total 7 columns):\n", " # Column Non-Null Count Dtype \n", "--- ------ -------------- ----- \n", " 0 Nom 77 non-null object \n", " 1 Categorie 77 non-null object \n", " 2 Origine 77 non-null object \n", " 3 Ville 77 non-null object \n", " 4 Prix 77 non-null float64\n", " 5 Stock 77 non-null int64 \n", " 6 Valeur 77 non-null float64\n", "dtypes: float64(2), int64(1), object(4)\n", "memory usage: 4.3+ KB\n" ] } ], "source": [ "# votre code ci-dessous\n", "\n", "# La méthode info() est celle qui doit être utilisée ici.\n", "produits.info()\n", "\n", "# Réponse question 2. => Il y a 7 colonnes et 77 lignes.\n", "\n", "# Réponse question 3. => 3 variables de type numérique, 4 variables de type chaîne de caractères." ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### IV) Extraction de données \n", "\n", "Extraire les données de toutes les colonnes pour :\n", "\n", "1. Catégories = boissons. Le résultat comporte 12 lignes.\n" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
NomCategorieOrigineVillePrixStockValeur
5ChaiBoissonsCEELyon90.0010900.00
6ChangBoissonsExterieurLyon95.00252375.00
7Chartreuse verteBoissonsExterieurLyon90.005450.00
11Cote de BlayeBoissonsCEEParis1317.501519762.50
21Guarana FantasticaBoissonsExterieurLyon22.5000.00
28Ipoh CoffeeBoissonsExterieurParis230.00255750.00
31LakkalikooriBoissonsCEELyon90.00201800.00
32Laughing Lumberjack LagerBoissonsCEELyon70.0010700.00
45Outback LagerBoissonsExterieurLyon75.00302250.00
53Rhonbrau KlosterbierBoissonsCEEParis38.7525968.75
57Sasquatch AleBoissonsCEELyon70.00151050.00
65Steeleye StoutBoissonsExterieurLyon90.00151350.00
\n", "
" ], "text/plain": [ " Nom Categorie Origine Ville Prix Stock \\\n", "5 Chai Boissons CEE Lyon 90.00 10 \n", "6 Chang Boissons Exterieur Lyon 95.00 25 \n", "7 Chartreuse verte Boissons Exterieur Lyon 90.00 5 \n", "11 Cote de Blaye Boissons CEE Paris 1317.50 15 \n", "21 Guarana Fantastica Boissons Exterieur Lyon 22.50 0 \n", "28 Ipoh Coffee Boissons Exterieur Paris 230.00 25 \n", "31 Lakkalikoori Boissons CEE Lyon 90.00 20 \n", "32 Laughing Lumberjack Lager Boissons CEE Lyon 70.00 10 \n", "45 Outback Lager Boissons Exterieur Lyon 75.00 30 \n", "53 Rhonbrau Klosterbier Boissons CEE Paris 38.75 25 \n", "57 Sasquatch Ale Boissons CEE Lyon 70.00 15 \n", "65 Steeleye Stout Boissons Exterieur Lyon 90.00 15 \n", "\n", " Valeur \n", "5 900.00 \n", "6 2375.00 \n", "7 450.00 \n", "11 19762.50 \n", "21 0.00 \n", "28 5750.00 \n", "31 1800.00 \n", "32 700.00 \n", "45 2250.00 \n", "53 968.75 \n", "57 1050.00 \n", "65 1350.00 " ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# votre code ci-dessous\n", "\n", "boissons = produits[produits['Categorie'] == 'Boissons']\n", "boissons" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "2. Prix > 100. Le résultat comporte 37 lignes." ] }, { "cell_type": "code", "execution_count": 5, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
NomCategorieOrigineVillePrixStockValeur
0Alice MuttonViandesCEELyon195.0000.00
3Camembert PierrotProduits laitiersExterieurParis170.0000.00
4Carnarvon TigersPoissons et fruits de merExterieurLyon312.5000.00
8Chef Anton's Cajun SeasoningCondimentsCEELyon110.0000.00
9Chef Anton's Gumbo MixCondimentsCEEParis106.7500.00
11Cote de BlayeBoissonsCEEParis1317.501519762.50
14FløtemysostProduits laitiersCEELyon107.5000.00
17Gnocchi di nonna AlicePates et cerealesCEELyon190.00305700.00
19Grandma's Boysenberry SpreadCondimentsExterieurLyon125.00253125.00
20Gravad laxPoissons et fruits de merExterieurLyon130.00253250.00
22GudbrandsdalsostProduits laitiersExterieurParis180.00152700.00
24Gumbar GummibarchenDessertsCEEParis156.1500.00
25Gustaf's KnackebrodPates et cerealesCEEParis105.00252625.00
26IkuraPoissons et fruits de merExterieurParis155.0000.00
28Ipoh CoffeeBoissonsExterieurParis230.00255750.00
34Louisiana Fiery Hot Pepper SauceCondimentsCEEParis105.2500.00
36Manjimup Dried ApplesProduits secsCEELyon265.00102650.00
37Mascarpone FabioliProduits laitiersExterieurLyon160.00254000.00
39Mishi Kobe NikuViandesCEELyon485.0000.00
40Mozzarella di GiovanniProduits laitiersExterieurLyon174.0000.00
41Nord-Ost MatjesheringPoissons et fruits de merCEELyon129.45151941.75
42Northwoods Cranberry SauceCondimentsExterieurLyon200.0000.00
46Pate chinoisViandesCEELyon120.00202400.00
48Perth PastiesViandesCEEParis164.0000.00
49Queso CabralesProduits laitiersCEEParis105.00303150.00
50Queso Manchego La PastoraProduits laitiersCEEParis190.0000.00
51Raclette CourdavaultProduits laitiersCEEParis275.0000.00
56Rossle SauerkrautProduits secsCEEParis228.0000.00
58Schoggi SchokoladeDessertsCEEParis219.50306585.00
61Sir Rodney's MarmaladeDessertsExterieurLyon405.0000.00
63Sirop d'erableCondimentsExterieurParis142.50253562.50
66Tarte au sucreDessertsExterieurParis246.5000.00
68Thüringer RostbratwurstViandesExterieurLyon618.9500.00
69TofuProduits secsExterieurLyon116.2500.00
72Uncle Bob's Organic Dried PearsProduits secsExterieurParis150.00101500.00
74Vegie-spreadCondimentsExterieurParis219.5051097.50
75Wimmers gute SemmelknodelPates et cerealesCEELyon166.25304987.50
\n", "
" ], "text/plain": [ " Nom Categorie Origine \\\n", "0 Alice Mutton Viandes CEE \n", "3 Camembert Pierrot Produits laitiers Exterieur \n", "4 Carnarvon Tigers Poissons et fruits de mer Exterieur \n", "8 Chef Anton's Cajun Seasoning Condiments CEE \n", "9 Chef Anton's Gumbo Mix Condiments CEE \n", "11 Cote de Blaye Boissons CEE \n", "14 Fløtemysost Produits laitiers CEE \n", "17 Gnocchi di nonna Alice Pates et cereales CEE \n", "19 Grandma's Boysenberry Spread Condiments Exterieur \n", "20 Gravad lax Poissons et fruits de mer Exterieur \n", "22 Gudbrandsdalsost Produits laitiers Exterieur \n", "24 Gumbar Gummibarchen Desserts CEE \n", "25 Gustaf's Knackebrod Pates et cereales CEE \n", "26 Ikura Poissons et fruits de mer Exterieur \n", "28 Ipoh Coffee Boissons Exterieur \n", "34 Louisiana Fiery Hot Pepper Sauce Condiments CEE \n", "36 Manjimup Dried Apples Produits secs CEE \n", "37 Mascarpone Fabioli Produits laitiers Exterieur \n", "39 Mishi Kobe Niku Viandes CEE \n", "40 Mozzarella di Giovanni Produits laitiers Exterieur \n", "41 Nord-Ost Matjeshering Poissons et fruits de mer CEE \n", "42 Northwoods Cranberry Sauce Condiments Exterieur \n", "46 Pate chinois Viandes CEE \n", "48 Perth Pasties Viandes CEE \n", "49 Queso Cabrales Produits laitiers CEE \n", "50 Queso Manchego La Pastora Produits laitiers CEE \n", "51 Raclette Courdavault Produits laitiers CEE \n", "56 Rossle Sauerkraut Produits secs CEE \n", "58 Schoggi Schokolade Desserts CEE \n", "61 Sir Rodney's Marmalade Desserts Exterieur \n", "63 Sirop d'erable Condiments Exterieur \n", "66 Tarte au sucre Desserts Exterieur \n", "68 Thüringer Rostbratwurst Viandes Exterieur \n", "69 Tofu Produits secs Exterieur \n", "72 Uncle Bob's Organic Dried Pears Produits secs Exterieur \n", "74 Vegie-spread Condiments Exterieur \n", "75 Wimmers gute Semmelknodel Pates et cereales CEE \n", "\n", " Ville Prix Stock Valeur \n", "0 Lyon 195.00 0 0.00 \n", "3 Paris 170.00 0 0.00 \n", "4 Lyon 312.50 0 0.00 \n", "8 Lyon 110.00 0 0.00 \n", "9 Paris 106.75 0 0.00 \n", "11 Paris 1317.50 15 19762.50 \n", "14 Lyon 107.50 0 0.00 \n", "17 Lyon 190.00 30 5700.00 \n", "19 Lyon 125.00 25 3125.00 \n", "20 Lyon 130.00 25 3250.00 \n", "22 Paris 180.00 15 2700.00 \n", "24 Paris 156.15 0 0.00 \n", "25 Paris 105.00 25 2625.00 \n", "26 Paris 155.00 0 0.00 \n", "28 Paris 230.00 25 5750.00 \n", "34 Paris 105.25 0 0.00 \n", "36 Lyon 265.00 10 2650.00 \n", "37 Lyon 160.00 25 4000.00 \n", "39 Lyon 485.00 0 0.00 \n", "40 Lyon 174.00 0 0.00 \n", "41 Lyon 129.45 15 1941.75 \n", "42 Lyon 200.00 0 0.00 \n", "46 Lyon 120.00 20 2400.00 \n", "48 Paris 164.00 0 0.00 \n", "49 Paris 105.00 30 3150.00 \n", "50 Paris 190.00 0 0.00 \n", "51 Paris 275.00 0 0.00 \n", "56 Paris 228.00 0 0.00 \n", "58 Paris 219.50 30 6585.00 \n", "61 Lyon 405.00 0 0.00 \n", "63 Paris 142.50 25 3562.50 \n", "66 Paris 246.50 0 0.00 \n", "68 Lyon 618.95 0 0.00 \n", "69 Lyon 116.25 0 0.00 \n", "72 Paris 150.00 10 1500.00 \n", "74 Paris 219.50 5 1097.50 \n", "75 Lyon 166.25 30 4987.50 " ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# votre code ci-dessous\n", "\n", "prix_sup_100 = produits[produits['Prix'] > 100]\n", "prix_sup_100" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "3. Catégorie = boissons et prix > 100. Le résultat comporte 2 lignes." ] }, { "cell_type": "code", "execution_count": 6, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
NomCategorieOrigineVillePrixStockValeur
11Cote de BlayeBoissonsCEEParis1317.51519762.5
28Ipoh CoffeeBoissonsExterieurParis230.0255750.0
\n", "
" ], "text/plain": [ " Nom Categorie Origine Ville Prix Stock Valeur\n", "11 Cote de Blaye Boissons CEE Paris 1317.5 15 19762.5\n", "28 Ipoh Coffee Boissons Exterieur Paris 230.0 25 5750.0" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# votre code ci-dessous\n", "\n", "boissons_prix_sup_100 = produits[(produits['Categorie'] == 'Boissons') & (produits['Prix'] > 100)]\n", "boissons_prix_sup_100" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "4. Catégories = boissons et origine=CEE et prix > 100. Le résultat comporte une ligne." ] }, { "cell_type": "code", "execution_count": 7, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
NomCategorieOrigineVillePrixStockValeur
11Cote de BlayeBoissonsCEEParis1317.51519762.5
\n", "
" ], "text/plain": [ " Nom Categorie Origine Ville Prix Stock Valeur\n", "11 Cote de Blaye Boissons CEE Paris 1317.5 15 19762.5" ] }, "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# votre code ci-dessous\n", "\n", "boissons_cee_prix_sup_100 = produits[(produits['Categorie'] == 'Boissons') & (produits['Origine'] == 'CEE') & (produits['Prix'] > 100)]\n", "boissons_cee_prix_sup_100" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "A partir des questions suivantes, extraire **UNIQUEMENT** le Nom, Catégories, Origine et Prix.\n", "\n", "5. (Catégorie = boissons et origine = CEE) OU (catégorie = condiment). Le résultat comporte 18 lignes.\n", "\n", "Pour effectuer ce filtre, commencez d'abord par faire un sous-Dataframe que vous appelerez boissons_cee_condiments en filtrant avec les 4 colonnes citées ci-dessus. \\\n", "Ensuite appliquez votre filtre sur le sous jeu de données." ] }, { "cell_type": "code", "execution_count": 8, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
NomCategorieOriginePrix
1Aniseed SyrupCondimentsExterieur50.00
5ChaiBoissonsCEE90.00
8Chef Anton's Cajun SeasoningCondimentsCEE110.00
9Chef Anton's Gumbo MixCondimentsCEE106.75
11Cote de BlayeBoissonsCEE1317.50
16Genen ShouyuCondimentsCEE77.50
19Grandma's Boysenberry SpreadCondimentsExterieur125.00
23Gula MalaccaCondimentsCEE97.25
31LakkalikooriBoissonsCEE90.00
32Laughing Lumberjack LagerBoissonsCEE70.00
34Louisiana Fiery Hot Pepper SauceCondimentsCEE105.25
35Louisiana Hot Spiced OkraCondimentsCEE85.00
42Northwoods Cranberry SauceCondimentsExterieur200.00
44Original Frankfurter grüne SoßeCondimentsExterieur65.00
53Rhonbrau KlosterbierBoissonsCEE38.75
57Sasquatch AleBoissonsCEE70.00
63Sirop d'erableCondimentsExterieur142.50
74Vegie-spreadCondimentsExterieur219.50
\n", "
" ], "text/plain": [ " Nom Categorie Origine Prix\n", "1 Aniseed Syrup Condiments Exterieur 50.00\n", "5 Chai Boissons CEE 90.00\n", "8 Chef Anton's Cajun Seasoning Condiments CEE 110.00\n", "9 Chef Anton's Gumbo Mix Condiments CEE 106.75\n", "11 Cote de Blaye Boissons CEE 1317.50\n", "16 Genen Shouyu Condiments CEE 77.50\n", "19 Grandma's Boysenberry Spread Condiments Exterieur 125.00\n", "23 Gula Malacca Condiments CEE 97.25\n", "31 Lakkalikoori Boissons CEE 90.00\n", "32 Laughing Lumberjack Lager Boissons CEE 70.00\n", "34 Louisiana Fiery Hot Pepper Sauce Condiments CEE 105.25\n", "35 Louisiana Hot Spiced Okra Condiments CEE 85.00\n", "42 Northwoods Cranberry Sauce Condiments Exterieur 200.00\n", "44 Original Frankfurter grüne Soße Condiments Exterieur 65.00\n", "53 Rhonbrau Klosterbier Boissons CEE 38.75\n", "57 Sasquatch Ale Boissons CEE 70.00\n", "63 Sirop d'erable Condiments Exterieur 142.50\n", "74 Vegie-spread Condiments Exterieur 219.50" ] }, "execution_count": 8, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# votre code ci-dessous\n", "\n", "boissons_cee_condiments = produits[['Nom', 'Categorie', 'Origine', 'Prix']]\n", "boissons_cee_condiments = boissons_cee_condiments[((boissons_cee_condiments['Categorie'] == 'Boissons') & (boissons_cee_condiments['Origine'] == 'CEE')) | (boissons_cee_condiments['Categorie'] == 'Condiments')]\n", "boissons_cee_condiments" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "6. (Catégorie = viandes ET origine = CEE) OU (catégorie = condiment ET origine = extérieur). Le résultat comporte 12 lignes.\n", "\n", "Même consigne que la question précédente. Appelez votre sous jeu de données boissons_cee_condiments_exterieur." ] }, { "cell_type": "code", "execution_count": 11, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
NomCategorieOriginePrix
0Alice MuttonViandesCEE195.00
1Aniseed SyrupCondimentsExterieur50.00
19Grandma's Boysenberry SpreadCondimentsExterieur125.00
39Mishi Kobe NikuViandesCEE485.00
42Northwoods Cranberry SauceCondimentsExterieur200.00
44Original Frankfurter grüne SoßeCondimentsExterieur65.00
46Pate chinoisViandesCEE120.00
48Perth PastiesViandesCEE164.00
63Sirop d'erableCondimentsExterieur142.50
70TourtièreViandesCEE37.25
74Vegie-spreadCondimentsExterieur219.50
\n", "
" ], "text/plain": [ " Nom Categorie Origine Prix\n", "0 Alice Mutton Viandes CEE 195.00\n", "1 Aniseed Syrup Condiments Exterieur 50.00\n", "19 Grandma's Boysenberry Spread Condiments Exterieur 125.00\n", "39 Mishi Kobe Niku Viandes CEE 485.00\n", "42 Northwoods Cranberry Sauce Condiments Exterieur 200.00\n", "44 Original Frankfurter grüne Soße Condiments Exterieur 65.00\n", "46 Pate chinois Viandes CEE 120.00\n", "48 Perth Pasties Viandes CEE 164.00\n", "63 Sirop d'erable Condiments Exterieur 142.50\n", "70 Tourtière Viandes CEE 37.25\n", "74 Vegie-spread Condiments Exterieur 219.50" ] }, "execution_count": 11, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# votre code ci-dessous\n", "\n", "boissons_cee_condiments_exterieur = produits[['Nom', 'Categorie', 'Origine', 'Prix']]\n", "boissons_cee_condiments_exterieur = boissons_cee_condiments_exterieur[((boissons_cee_condiments_exterieur['Categorie'] == 'Viandes') & (boissons_cee_condiments_exterieur['Origine'] == 'CEE')) | ((boissons_cee_condiments_exterieur['Categorie'] == 'Condiments') & (boissons_cee_condiments_exterieur['Origine'] == 'Exterieur'))]\n", "boissons_cee_condiments_exterieur" ] } ], "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.11.9" } }, "nbformat": 4, "nbformat_minor": 2 }