{"id":189,"date":"2022-03-01T11:56:47","date_gmt":"2022-03-01T10:56:47","guid":{"rendered":"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/?p=189"},"modified":"2022-03-14T16:44:43","modified_gmt":"2022-03-14T15:44:43","slug":"traitement-de-donnees-en-table","status":"publish","type":"post","link":"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/2022\/03\/01\/traitement-de-donnees-en-table\/","title":{"rendered":"Traitement de donn\u00e9es en table"},"content":{"rendered":"\n<p class=\"has-large-font-size\"><strong>1- fichier CSV<\/strong><\/p>\n\n\n\n<p class=\"has-medium-font-size\">Q1 Quel est le s\u00e9parateur utilis\u00e9 ?<\/p>\n\n\n\n<p>Le s\u00e9parateur utilis\u00e9 est la virgule.<\/p>\n\n\n\n<p class=\"has-medium-font-size\">Q2 Que contient la premi\u00e8re ligne?<\/p>\n\n\n\n<p>La premi\u00e8re ligne contient les noms des colonnes du fichier.<\/p>\n\n\n\n<p class=\"has-medium-font-size\">Q3 Pourquoi trouve on parfois des virgules qui se suivent ?<\/p>\n\n\n\n<p>Les virgules servent \u00e0 s\u00e9parer les donn\u00e9es alors quand les colonnes sont vides, les virgules se suivent.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p class=\"has-large-font-size\"><strong>2- csv \/ python<\/strong><\/p>\n\n\n\n<p>Il y a deux fa\u00e7ons d&rsquo;ouvrir un fichier CSV en python<\/p>\n\n\n\n<p class=\"has-medium-font-size\">La premi\u00e8re:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"321\" height=\"79\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/02\/image-2.png\" alt=\"\" class=\"wp-image-191\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/02\/image-2.png 321w, http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/02\/image-2-300x74.png 300w\" sizes=\"(max-width: 321px) 100vw, 321px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"788\" height=\"216\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/02\/image-3.png\" alt=\"\" class=\"wp-image-192\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/02\/image-3.png 788w, http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/02\/image-3-300x82.png 300w, http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/02\/image-3-768x211.png 768w\" sizes=\"(max-width: 788px) 100vw, 788px\" \/><figcaption>Ce fichier est ouvert en tant que liste et les retours \u00e0 la lignes sont repr\u00e9senter avec \\n .<\/figcaption><\/figure>\n\n\n\n<p class=\"has-medium-font-size\">La deuxi\u00e8me:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"444\" height=\"130\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/02\/image-4.png\" alt=\"\" class=\"wp-image-193\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/02\/image-4.png 444w, http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/02\/image-4-300x88.png 300w\" sizes=\"(max-width: 444px) 100vw, 444px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"791\" height=\"302\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/02\/image-5.png\" alt=\"\" class=\"wp-image-194\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/02\/image-5.png 791w, http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/02\/image-5-300x115.png 300w, http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/02\/image-5-768x293.png 768w\" sizes=\"(max-width: 791px) 100vw, 791px\" \/><figcaption>Ce fichier est ouvert en tant que liste de dictionnaire.<\/figcaption><\/figure>\n\n\n\n<p class=\"has-medium-font-size\">Nous r\u00e9alisons ensuite quelque test en ajoutant de nouvelles lignes:<\/p>\n\n\n\n<p class=\"has-medium-font-size\">pour afficher un seul \u00e9l\u00e8ve s\u00e9lectionn\u00e9 <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"173\" height=\"26\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-2.png\" alt=\"\" class=\"wp-image-198\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"534\" height=\"67\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-3.png\" alt=\"\" class=\"wp-image-199\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-3.png 534w, http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-3-300x38.png 300w\" sizes=\"(max-width: 534px) 100vw, 534px\" \/><\/figure>\n\n\n\n<p class=\"has-medium-font-size\">pour afficher la classe d&rsquo;un \u00e9l\u00e8ve<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"229\" height=\"61\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-4.png\" alt=\"\" class=\"wp-image-200\" \/><\/figure>\n\n\n\n<p class=\"has-medium-font-size\">pour savoir si l&rsquo;\u00e9l\u00e8ve est un moldu ou pas<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"220\" height=\"61\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-5.png\" alt=\"\" class=\"wp-image-201\" \/><\/figure>\n\n\n\n<p class=\"has-medium-font-size\">pour donner al\u00e9atoirement 5 notes entre 0 et 20<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"294\" height=\"71\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image.png\" alt=\"\" class=\"wp-image-196\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"66\" height=\"101\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-1.png\" alt=\"\" class=\"wp-image-197\" \/><\/figure>\n\n\n\n<p class=\"has-medium-font-size\">pour mettre al\u00e9atoirement des notes \u00e0 chaque \u00e9l\u00e8ve<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"646\" height=\"431\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-6.png\" alt=\"\" class=\"wp-image-202\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-6.png 646w, http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-6-300x200.png 300w\" sizes=\"(max-width: 646px) 100vw, 646px\" \/><\/figure>\n\n\n\n<p class=\"has-medium-font-size\">pour afficher un graphe des notes d&rsquo;un \u00e9l\u00e8ve<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"797\" height=\"119\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-7.png\" alt=\"\" class=\"wp-image-203\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-7.png 797w, http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-7-300x45.png 300w, http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-7-768x115.png 768w\" sizes=\"(max-width: 797px) 100vw, 797px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-8.png\" alt=\"\" class=\"wp-image-204\" width=\"615\" height=\"361\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-8.png 750w, http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-content\/uploads\/sites\/17\/2022\/03\/image-8-300x176.png 300w\" sizes=\"(max-width: 615px) 100vw, 615px\" \/><\/figure>\n\n\n\n<p class=\"has-large-font-size\">3-projet 1<\/p>\n\n\n\n<p><a href=\"https:\/\/colab.research.google.com\/drive\/1CFa7ytmWK3ZN28-MbQ1wam1Zxalc4Klt?usp=sharing\">https:\/\/colab.research.google.com\/drive\/1CFa7ytmWK3ZN28-MbQ1wam1Zxalc4Klt?usp=sharing<\/a><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1- fichier CSV Q1 Quel est le s\u00e9parateur utilis\u00e9 ? Le s\u00e9parateur utilis\u00e9 est la virgule. Q2 Que contient la premi\u00e8re ligne? La premi\u00e8re ligne contient les noms des colonnes du fichier. Q3 Pourquoi trouve on parfois des virgules qui se suivent ? Les virgules servent \u00e0 s\u00e9parer les donn\u00e9es alors quand les colonnes sont [&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\/189"}],"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=189"}],"version-history":[{"count":6,"href":"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-json\/wp\/v2\/posts\/189\/revisions"}],"predecessor-version":[{"id":243,"href":"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-json\/wp\/v2\/posts\/189\/revisions\/243"}],"wp:attachment":[{"href":"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-json\/wp\/v2\/media?parent=189"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-json\/wp\/v2\/categories?post=189"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/yb-isn.fr\/2021\/nsi\/kelya\/wp-json\/wp\/v2\/tags?post=189"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}