{"id":1231,"date":"2022-02-28T17:45:01","date_gmt":"2022-02-28T16:45:01","guid":{"rendered":"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/?p=1231"},"modified":"2022-03-14T17:08:58","modified_gmt":"2022-03-14T16:08:58","slug":"traitement-de-donnees-en-table","status":"publish","type":"post","link":"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/2022\/02\/28\/traitement-de-donnees-en-table\/","title":{"rendered":"Traitement de donn\u00e9es en table"},"content":{"rendered":"\n<figure class=\"wp-block-image\"><img src=\"http:\/\/yb-isn.fr\/2021\/nsi\/wp-content\/uploads\/2022\/02\/botables.png\" alt=\"\" \/><\/figure>\n\n\n\n<p><strong>Contexte <\/strong>: Les \u00e9l\u00e8ve de premi\u00e8re NSI 1 du lyc\u00e9e Mauriac ont suivi une ann\u00e9e de cours avec quelques \u00e9l\u00e8ves de Poudlard. Les mati\u00e8res suivies sont : \u2018Potions\u2019, \u2018Botanique\u2019, \u2018\u00e9tude des Moldus\u2019, \u2018Sortil\u00e8ges\u2019, \u2018Vol sur Balai\u2019.<\/p>\n\n\n\n<p>Par soucis d\u2019\u00e9quit\u00e9 les notes entre 0 et 20 sont tir\u00e9es de fa\u00e7on al\u00e9atoire.<\/p>\n\n\n\n<p>L\u2019ann\u00e9e est constitu\u00e9e de trois trimestres.<\/p>\n\n\n\n<p> <\/p>\n\n\n\n<p class=\"has-text-color has-background\" style=\"background-color:#abdfff;color:#029eff\"><strong>I &#8211; Fichier csv et tableur<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"695\" height=\"356\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/02\/image-21.png\" alt=\"\" class=\"wp-image-1233\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/02\/image-21.png 695w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/02\/image-21-300x154.png 300w\" sizes=\"(max-width: 695px) 100vw, 695px\" \/><\/figure>\n\n\n\n<p>La virgule est le s\u00e9parateur par d\u00e9faut mais on peut rencontrer aussi d\u2019autres s\u00e9parateurs.<\/p>\n\n\n\n<p>Le sigle CSV signifie&nbsp;<em>Comma-Separated Values<\/em>&nbsp;et d\u00e9signe un fichier texte dont les valeurs sont s\u00e9par\u00e9es par des virgules.<\/p>\n\n\n\n<p>La virgule est le s\u00e9parateur par d\u00e9faut mais il existe d\u2019autres s\u00e9parateurs<\/p>\n\n\n\n<ol><li>Quel est le s\u00e9parateur utilis\u00e9 ?<\/li><\/ol>\n\n\n\n<p>&#8211;&gt; Le s\u00e9parateur utilis\u00e9 est la virgule.<\/p>\n\n\n\n<ol><li>Que contient la premi\u00e8re ligne?<\/li><\/ol>\n\n\n\n<p>&#8211;&gt; La premi\u00e8re ligne contient les diff\u00e9rentes cat\u00e9gories du tableau.<\/p>\n\n\n\n<ol><li>Pourquoi trouve-t-on parfois des virgules qui se suivent ?<\/li><\/ol>\n\n\n\n<p>Les virgules qui se suivent repr\u00e9sentent les cat\u00e9gories pour lesquelles on n&rsquo;a pas de donn\u00e9e.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"414\" height=\"125\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/02\/image-22.png\" alt=\"\" class=\"wp-image-1234\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/02\/image-22.png 414w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/02\/image-22-300x91.png 300w\" sizes=\"(max-width: 414px) 100vw, 414px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"1024\" height=\"158\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/02\/image-23-1024x158.png\" alt=\"\" class=\"wp-image-1235\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/02\/image-23-1024x158.png 1024w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/02\/image-23-300x46.png 300w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/02\/image-23-768x118.png 768w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/02\/image-23.png 1148w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p> Dans ce deuxi\u00e8me programme, on utilise une liste.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"1024\" height=\"717\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/02\/image-24-1024x717.png\" alt=\"\" class=\"wp-image-1237\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/02\/image-24-1024x717.png 1024w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/02\/image-24-300x210.png 300w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/02\/image-24-768x538.png 768w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/02\/image-24.png 1337w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Dans ce deuxi\u00e8me programme, on utilise une liste de dictionnaire.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>Pandas est la librairie python de r\u00e9f\u00e9rence pour manipuler les donn\u00e9es. Elle permet de manipuler les donn\u00e9es sous forme de tables (DataFrame) et de les exporter avec diff\u00e9rents formats. Elle permet aussi de cr\u00e9er facilement des graphes avec matplotlib par exemple.<\/p>\n\n\n\n<p>&#8211;&gt; pour comprendre pandas : <a href=\"https:\/\/pandas.pydata.org\/docs\/user_guide\/10min.html\">https:\/\/pandas.pydata.org\/docs\/user_guide\/10min.html<\/a><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"541\" height=\"931\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/02\/image-25.png\" alt=\"\" class=\"wp-image-1239\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/02\/image-25.png 541w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/02\/image-25-174x300.png 174w\" sizes=\"(max-width: 541px) 100vw, 541px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"1024\" height=\"732\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/02\/image-26-1024x732.png\" alt=\"\" class=\"wp-image-1241\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/02\/image-26-1024x732.png 1024w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/02\/image-26-300x215.png 300w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/02\/image-26-768x549.png 768w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/02\/image-26.png 1334w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"594\" height=\"260\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/02\/image-27.png\" alt=\"\" class=\"wp-image-1244\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/02\/image-27.png 594w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/02\/image-27-300x131.png 300w\" sizes=\"(max-width: 594px) 100vw, 594px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"1024\" height=\"202\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-1024x202.png\" alt=\"\" class=\"wp-image-1246\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-1024x202.png 1024w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-300x59.png 300w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-768x151.png 768w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-1536x303.png 1536w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image.png 1791w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption>(avec les donn\u00e9es)<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"1024\" height=\"231\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-1-1024x231.png\" alt=\"\" class=\"wp-image-1248\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-1-1024x231.png 1024w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-1-300x68.png 300w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-1-768x173.png 768w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-1.png 1059w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption>(sans les donn\u00e9es)<\/figcaption><\/figure>\n\n\n\n<p> <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"1024\" height=\"359\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-2-1024x359.png\" alt=\"\" class=\"wp-image-1250\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-2-1024x359.png 1024w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-2-300x105.png 300w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-2-768x269.png 768w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-2.png 1121w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption>avec poudlard1 ! \ud83d\ude09<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"159\" height=\"67\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-3.png\" alt=\"\" class=\"wp-image-1252\" \/><\/figure>\n\n\n\n<p>Donner des notes al\u00e9atoirement \u00e0 chaque \u00e9l\u00e8ve :<\/p>\n\n\n\n<p>\u00e9tape 1 :<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"340\" height=\"104\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-4.png\" alt=\"\" class=\"wp-image-1254\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-4.png 340w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-4-300x92.png 300w\" sizes=\"(max-width: 340px) 100vw, 340px\" \/><\/figure>\n\n\n\n<p>&#8211;&gt; <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"625\" height=\"390\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-5.png\" alt=\"\" class=\"wp-image-1255\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-5.png 625w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-5-300x187.png 300w\" sizes=\"(max-width: 625px) 100vw, 625px\" \/><\/figure>\n\n\n\n<p> <\/p>\n\n\n\n<p>Avec le graphe :<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"782\" height=\"127\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-7.png\" alt=\"\" class=\"wp-image-1258\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-7.png 782w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-7-300x49.png 300w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-7-768x125.png 768w\" sizes=\"(max-width: 782px) 100vw, 782px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"636\" height=\"497\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-8.png\" alt=\"\" class=\"wp-image-1259\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-8.png 636w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-8-300x234.png 300w\" sizes=\"(max-width: 636px) 100vw, 636px\" \/><\/figure>\n\n\n\n<p> <\/p>\n\n\n\n<p class=\"has-text-color has-background\" style=\"background-color:#a3dcff;color:#0696f0\"><strong>II &#8211; Fichier csv et python<\/strong><\/p>\n\n\n\n<p>Voir le corrig\u00e9 de poudlard : <a href=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/2022\/03\/06\/poudlard-corrige\/\" data-type=\"URL\" data-id=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/2022\/03\/06\/poudlard-corrige\/\">http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/2022\/03\/06\/poudlard-corrige\/<\/a><\/p>\n\n\n\n<p> <\/p>\n\n\n\n<p class=\"has-text-color has-background\" style=\"background-color:#a1dbff;color:#089af5\"><strong>III &#8211; Projet 1<\/strong><\/p>\n\n\n\n<p><a href=\"https:\/\/colab.research.google.com\/drive\/1bLFouxw5Jr5Q8Um3nV278JYuJaDg2J0x#scrollTo=yQ00ezWYHdaQ\">https:\/\/colab.research.google.com\/drive\/1bLFouxw5Jr5Q8Um3nV278JYuJaDg2J0x#scrollTo=yQ00ezWYHdaQ<\/a><\/p>\n\n\n\n<p>Pandas est la librairie python de r\u00e9f\u00e9rence pour manipuler les donn\u00e9es.<\/p>\n\n\n\n<p>Elle permet de manipuler les donn\u00e9es sous forme de tables (DataFrame) et de les exporter avec diff\u00e9rents formats.<\/p>\n\n\n\n<p>Elle permet aussi de cr\u00e9er facilement des graphes avec matplotlib, par exemple.<\/p>\n\n\n\n<p>Pour comprendre pandas : <a href=\"https:\/\/pandas.pydata.org\/docs\/user_guide\/10min.html\">https:\/\/pandas.pydata.org\/docs\/user_guide\/10min.html<\/a><\/p>\n\n\n\n<p class=\"has-text-color has-background\" style=\"background-color:#54bdff;color:#c2e7ff\"><strong>III &#8211; A &#8211; Lecture des fichiers csv<\/strong><\/p>\n\n\n\n<p>On peut lire le fichier csv en pr\u00e9cisant l\u2019encodage et le type de s\u00e9parateur. On cr\u00e9e un objet&nbsp;de type dataframe (pandas.core.frame.DataFrame).<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"613\" height=\"121\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-27.png\" alt=\"\" class=\"wp-image-1307\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-27.png 613w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-27-300x59.png 300w\" sizes=\"(max-width: 613px) 100vw, 613px\" \/><\/figure>\n\n\n\n<p>On peut demander le type de l&rsquo;objet poudlard que l&rsquo;on va cr\u00e9er :<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"297\" height=\"74\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-28.png\" alt=\"\" class=\"wp-image-1308\" \/><\/figure>\n\n\n\n<p>On peut afficher l\u2019objet poudlard ou quelques lignes seulement. <br>5 lignes sont affich\u00e9es par d\u00e9faut avec la fonction head().<\/p>\n\n\n\n<p>On peut pr\u00e9ciser le nombre n de lignes souhait\u00e9es avec head(n)poudlard.head() :<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"862\" height=\"243\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-29.png\" alt=\"\" class=\"wp-image-1312\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-29.png 862w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-29-300x85.png 300w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-29-768x217.png 768w\" sizes=\"(max-width: 862px) 100vw, 862px\" \/><\/figure>\n\n\n\n<p>poudlard.columns permet d&rsquo;avoir acc\u00e8s aux champ de la table (premi\u00e8re ligne du fichier csv) :<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"611\" height=\"99\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-30.png\" alt=\"\" class=\"wp-image-1314\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-30.png 611w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-30-300x49.png 300w\" sizes=\"(max-width: 611px) 100vw, 611px\" \/><\/figure>\n\n\n\n<p>On peut acc\u00e9der au contenu de la ligne 16 (17 du fichier csv) avec&nbsp; la m\u00e9thode \u00ab&nbsp;loc&nbsp;\u00bb :<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"248\" height=\"244\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-31.png\" alt=\"\" class=\"wp-image-1316\" \/><\/figure>\n\n\n\n<p>On peut s\u00e9lectionner la colonne avec son indice&#8230; :<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"145\" height=\"65\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-32.png\" alt=\"\" class=\"wp-image-1318\" \/><\/figure>\n\n\n\n<p>&#8230; ou avec l\u2019\u00e9tiquette de la colonne :<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"189\" height=\"67\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-33.png\" alt=\"\" class=\"wp-image-1320\" \/><\/figure>\n\n\n\n<p> <\/p>\n\n\n\n<p class=\"has-text-color has-background\" style=\"background-color:#4cbaff;color:#c7e8fd\"><strong>III &#8211; B &#8211; Recherche et ajout de donn\u00e9es manquantes<\/strong><\/p>\n\n\n\n<p>La m\u00e9thode isnull() permet de rechercher les donn\u00e9es manquantes.<\/p>\n\n\n\n<p>On peut ajouter head() pour limiter l\u2019affichage.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"812\" height=\"237\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-34.png\" alt=\"\" class=\"wp-image-1325\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-34.png 812w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-34-300x88.png 300w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-34-768x224.png 768w\" sizes=\"(max-width: 812px) 100vw, 812px\" \/><\/figure>\n\n\n\n<p>Nous savions d\u00e9j\u00e0 qu\u2019il manquait toutes les notes.<\/p>\n\n\n\n<p>La m\u00e9thode isnull() a ainsi traduit les donn\u00e9es par True ou False.<\/p>\n\n\n\n<p>Nous allons remplacer les donn\u00e9es manquantes en g\u00e9n\u00e9rant des notes al\u00e9atoires.<\/p>\n\n\n\n<p>Compl\u00e9tons le code en rempla\u00e7ant les pointill\u00e9s.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-36.png\" alt=\"\" class=\"wp-image-1332\" width=\"649\" height=\"115\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-36.png 649w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-36-300x53.png 300w\" sizes=\"(max-width: 649px) 100vw, 649px\" \/><figcaption>avant de remplacer les pointill\u00e9s<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"867\" height=\"315\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-37.png\" alt=\"\" class=\"wp-image-1333\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-37.png 867w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-37-300x109.png 300w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-37-768x279.png 768w\" sizes=\"(max-width: 867px) 100vw, 867px\" \/><figcaption>avec \u00ab\u00a0matieres\u00a0\u00bb et \u00ab\u00a021\u00a0\u00bb<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"932\" height=\"274\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-38.png\" alt=\"\" class=\"wp-image-1335\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-38.png 932w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-38-300x88.png 300w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-38-768x226.png 768w\" sizes=\"(max-width: 932px) 100vw, 932px\" \/><\/figure>\n\n\n\n<p> <\/p>\n\n\n\n<p class=\"has-text-color has-background\" style=\"background-color:#30afff;color:#cfecff\"><strong>III &#8211; C &#8211; Regroupement de cat\u00e9gories et agr\u00e9gation de donn\u00e9es<\/strong><\/p>\n\n\n\n<p>L\u2019objectif est de cr\u00e9er deux tables en s\u00e9parant les \u00e9l\u00e8ves de Mauriac et de Poudlard.<\/p>\n\n\n\n<p>Il nous faudra la moyenne g\u00e9n\u00e9rale pour Mauriac et pour Poudlard.<\/p>\n\n\n\n<p>exemple de r\u00e9sultat attendu :<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"http:\/\/yb-isn.fr\/2021\/nsi\/wp-content\/uploads\/2022\/02\/moy-mp.png\" alt=\"\" \/><\/figure>\n\n\n\n<p>La m\u00e9thode groupby() permet de s\u00e9parer les donn\u00e9es.<\/p>\n\n\n\n<p>On peut pour cela commencer \u00e0 rechercher les crit\u00e8res uniques d\u2019une colonne :<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"272\" height=\"66\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-39.png\" alt=\"\" class=\"wp-image-1339\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"921\" height=\"329\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-40.png\" alt=\"\" class=\"wp-image-1341\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-40.png 921w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-40-300x107.png 300w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-40-768x274.png 768w\" sizes=\"(max-width: 921px) 100vw, 921px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"959\" height=\"243\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-41.png\" alt=\"\" class=\"wp-image-1343\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-41.png 959w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-41-300x76.png 300w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-41-768x195.png 768w\" sizes=\"(max-width: 959px) 100vw, 959px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"408\" height=\"118\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-42.png\" alt=\"\" class=\"wp-image-1345\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-42.png 408w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-42-300x87.png 300w\" sizes=\"(max-width: 408px) 100vw, 408px\" \/><\/figure>\n\n\n\n<p>En r\u00e9alit\u00e9, on peut sans passer par l\u2019\u00e9tape pr\u00e9c\u00e9dente.<\/p>\n\n\n\n<p>&#8211;&gt; Agr\u00e9ger les donn\u00e9es en choisissant le crit\u00e8re lyc\u00e9e et en calculant la moyenne des moyenn\u00e9es des donn\u00e9es agr\u00e9g\u00e9es.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"470\" height=\"119\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-44.png\" alt=\"\" class=\"wp-image-1349\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-44.png 470w, http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-content\/uploads\/sites\/4\/2022\/03\/image-44-300x76.png 300w\" sizes=\"(max-width: 470px) 100vw, 470px\" \/><\/figure>\n\n\n\n<p> <\/p>\n\n\n\n<p class=\"has-text-color has-background\" style=\"background-color:#a7ddfe;color:#088ddf\"><strong>IV &#8211; Projet 2<\/strong><\/p>\n\n\n\n<p>&#8211;&gt; voir corrig\u00e9<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Contexte : Les \u00e9l\u00e8ve de premi\u00e8re NSI 1 du lyc\u00e9e Mauriac ont suivi une ann\u00e9e de cours avec quelques \u00e9l\u00e8ves de Poudlard. Les mati\u00e8res suivies sont : \u2018Potions\u2019, \u2018Botanique\u2019, \u2018\u00e9tude des Moldus\u2019, \u2018Sortil\u00e8ges\u2019, \u2018Vol sur Balai\u2019. Par soucis d\u2019\u00e9quit\u00e9 les notes entre 0 et 20 sont tir\u00e9es de fa\u00e7on al\u00e9atoire. L\u2019ann\u00e9e est constitu\u00e9e de trois [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":1243,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-json\/wp\/v2\/posts\/1231"}],"collection":[{"href":"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-json\/wp\/v2\/comments?post=1231"}],"version-history":[{"count":43,"href":"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-json\/wp\/v2\/posts\/1231\/revisions"}],"predecessor-version":[{"id":1396,"href":"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-json\/wp\/v2\/posts\/1231\/revisions\/1396"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-json\/wp\/v2\/media\/1243"}],"wp:attachment":[{"href":"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-json\/wp\/v2\/media?parent=1231"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-json\/wp\/v2\/categories?post=1231"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/yb-isn.fr\/2021\/nsi\/raphaelle\/wp-json\/wp\/v2\/tags?post=1231"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}