{"id":210,"date":"2022-03-08T11:31:42","date_gmt":"2022-03-08T10:31:42","guid":{"rendered":"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/?p=210"},"modified":"2022-03-08T11:31:42","modified_gmt":"2022-03-08T10:31:42","slug":"traitement-de-donnees-en-table-corige","status":"publish","type":"post","link":"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/2022\/03\/08\/traitement-de-donnees-en-table-corige\/","title":{"rendered":"Traitement de donn\u00e9es en table (corig\u00e9)"},"content":{"rendered":"\n<p>1)import du fichier CSV dans drive<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"650\" height=\"129\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-9.png\" alt=\"\" class=\"wp-image-211\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-9.png 650w, http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-9-300x60.png 300w\" sizes=\"(max-width: 650px) 100vw, 650px\" \/><figcaption>ces deux lignes vont servir \u00e0 chercher le fichier csv dans nos donn\u00e9es pour pouvoir l&rsquo;exploiter<\/figcaption><\/figure>\n\n\n\n<p>2) lecture du fichier CSV : m\u00e9thode 1<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"477\" height=\"83\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-10.png\" alt=\"\" class=\"wp-image-212\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-10.png 477w, http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-10-300x52.png 300w\" sizes=\"(max-width: 477px) 100vw, 477px\" \/><figcaption>encoding est n\u00e9cessaire pour pourvoir lire le fichier CSV<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"132\" height=\"34\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-11.png\" alt=\"\" class=\"wp-image-213\" \/><\/figure>\n\n\n\n<p>ce code est possible aussi avec des listes:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"463\" height=\"155\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-13.png\" alt=\"\" class=\"wp-image-215\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-13.png 463w, http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-13-300x100.png 300w\" sizes=\"(max-width: 463px) 100vw, 463px\" \/><\/figure>\n\n\n\n<p>; s\u00e9pare les valeurs d&rsquo;une ligne<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"363\" height=\"61\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-14.png\" alt=\"\" class=\"wp-image-216\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-14.png 363w, http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-14-300x50.png 300w\" sizes=\"(max-width: 363px) 100vw, 363px\" \/><\/figure>\n\n\n\n<p>on peut combiner les deux parties pour en faire qu&rsquo;une seule<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"458\" height=\"57\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-15.png\" alt=\"\" class=\"wp-image-217\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-15.png 458w, http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-15-300x37.png 300w\" sizes=\"(max-width: 458px) 100vw, 458px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"223\" height=\"47\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-17.png\" alt=\"\" class=\"wp-image-219\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"713\" height=\"385\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-18.png\" alt=\"\" class=\"wp-image-220\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-18.png 713w, http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-18-300x162.png 300w\" sizes=\"(max-width: 713px) 100vw, 713px\" \/><\/figure>\n\n\n\n<p>3) lecture du fichier csv : m\u00e9thode 2<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"609\" height=\"123\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-20.png\" alt=\"\" class=\"wp-image-222\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-20.png 609w, http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-20-300x61.png 300w\" sizes=\"(max-width: 609px) 100vw, 609px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"253\" height=\"215\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-21.png\" alt=\"\" class=\"wp-image-223\" \/><\/figure>\n\n\n\n<p>eleves est donn\u00e9 en une liste<\/p>\n\n\n\n<p>pour v\u00e9rifier si c&rsquo;est bien un dictionnaire<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"252\" height=\"310\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-22.png\" alt=\"\" class=\"wp-image-224\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-22.png 252w, http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-22-244x300.png 244w\" sizes=\"(max-width: 252px) 100vw, 252px\" \/><\/figure>\n\n\n\n<p>Quel \u00e9l\u00e8ve se trouve en ligne 16 ?<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"200\" height=\"68\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-23.png\" alt=\"\" class=\"wp-image-225\" \/><\/figure>\n\n\n\n<p>Hermione est-elle une moldu?<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"194\" height=\"63\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-24.png\" alt=\"\" class=\"wp-image-226\" \/><\/figure>\n\n\n\n<p>Quelle est la note d&rsquo;Hermione en botanique ?<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"222\" height=\"58\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-25.png\" alt=\"\" class=\"wp-image-227\" \/><\/figure>\n\n\n\n<p>Hermione n&rsquo;a pas de note. Attribuons la note 19 \u00e0 Hermione en botanique<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"224\" height=\"62\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-26.png\" alt=\"\" class=\"wp-image-228\" \/><\/figure>\n\n\n\n<p>Hermione n&rsquo;a pas de note. Attribuons la note 19 \u00e0 Hermione en botanique<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"281\" height=\"239\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-27.png\" alt=\"\" class=\"wp-image-229\" \/><\/figure>\n\n\n\n<p>comment g\u00e9n\u00e9rer une note aleatoire ?<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"214\" height=\"81\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-28.png\" alt=\"\" class=\"wp-image-230\" \/><\/figure>\n\n\n\n<p>Comment g\u00e9n\u00e9rer une liste de n notes al\u00e9atoires ?<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"364\" height=\"109\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-29.png\" alt=\"\" class=\"wp-image-231\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-29.png 364w, http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-29-300x90.png 300w\" sizes=\"(max-width: 364px) 100vw, 364px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"315\" height=\"68\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-30.png\" alt=\"\" class=\"wp-image-232\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-30.png 315w, http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-30-300x65.png 300w\" sizes=\"(max-width: 315px) 100vw, 315px\" \/><\/figure>\n\n\n\n<p>Comment g\u00e9n\u00e9rer une liste de n notes al\u00e9atoires avec une liste en compr\u00e9hension ?<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"444\" height=\"161\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-31.png\" alt=\"\" class=\"wp-image-233\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-31.png 444w, http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-31-300x109.png 300w\" sizes=\"(max-width: 444px) 100vw, 444px\" \/><\/figure>\n\n\n\n<p>pour un \u00e9l\u00e8ve ici Hermione on peut g\u00e9n\u00e9rer une note al\u00e9atoire pour chacune des 5 mati\u00e8res<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"688\" height=\"375\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-32.png\" alt=\"\" class=\"wp-image-234\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-32.png 688w, http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-32-300x164.png 300w\" sizes=\"(max-width: 688px) 100vw, 688px\" \/><\/figure>\n\n\n\n<p>On g\u00e9n\u00e9re une note al\u00e9atoire pour chacun des \u00e9l\u00e8ves dans chacune des mati\u00e8res<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"856\" height=\"261\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-33.png\" alt=\"\" class=\"wp-image-235\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-33.png 856w, http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-33-300x91.png 300w, http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-33-768x234.png 768w\" sizes=\"(max-width: 856px) 100vw, 856px\" \/><\/figure>\n\n\n\n<p>Vous pouvez afficher vos r\u00e9sultats comme sur pronote avec un diagramme en \u00ab\u00a0araign\u00e9e\u00a0\u00bb<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"825\" height=\"115\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-34.png\" alt=\"\" class=\"wp-image-236\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-34.png 825w, http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-34-300x42.png 300w, http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-34-768x107.png 768w\" sizes=\"(max-width: 825px) 100vw, 825px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator\" \/>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"772\" height=\"467\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-35.png\" alt=\"\" class=\"wp-image-237\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-35.png 772w, http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-35-300x181.png 300w, http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-35-768x465.png 768w\" sizes=\"(max-width: 772px) 100vw, 772px\" \/><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1)import du fichier CSV dans drive 2) lecture du fichier CSV : m\u00e9thode 1 ce code est possible aussi avec des listes: ; s\u00e9pare les valeurs d&rsquo;une ligne on peut combiner les deux parties pour en faire qu&rsquo;une seule 3) lecture du fichier csv : m\u00e9thode 2 eleves est donn\u00e9 en une liste pour v\u00e9rifier [&hellip;]<\/p>\n","protected":false},"author":17,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-json\/wp\/v2\/posts\/210"}],"collection":[{"href":"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-json\/wp\/v2\/comments?post=210"}],"version-history":[{"count":1,"href":"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-json\/wp\/v2\/posts\/210\/revisions"}],"predecessor-version":[{"id":238,"href":"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-json\/wp\/v2\/posts\/210\/revisions\/238"}],"wp:attachment":[{"href":"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-json\/wp\/v2\/media?parent=210"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-json\/wp\/v2\/categories?post=210"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-json\/wp\/v2\/tags?post=210"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}