{"id":159,"date":"2022-03-15T10:23:49","date_gmt":"2022-03-15T09:23:49","guid":{"rendered":"http:\/\/yb-isn.fr\/2021\/nsi\/romane\/?p=159"},"modified":"2022-03-15T10:23:49","modified_gmt":"2022-03-15T09:23:49","slug":"traitement-de-donnees-en-table","status":"publish","type":"post","link":"http:\/\/yb-isn.fr\/2021\/nsi\/romane\/2022\/03\/15\/traitement-de-donnees-en-table\/","title":{"rendered":"Traitement de donn\u00e9es en table"},"content":{"rendered":"\n<ol><li>L&rsquo;appellation de l&rsquo;extension csv est d\u00fb \u00e0 ses valeurs s\u00e9par\u00e9es par une virgule<\/li><\/ol>\n\n\n\n<p>2. La premi\u00e8re ligne donne diff\u00e9rentes valeurs qui repr\u00e9sentent les cours \u00e0 Poudlard.<\/p>\n\n\n\n<p>3. Dans la suite du programme, \u00e0 la fin de chaque ligne, il y a une suite de virgules signe qu&rsquo;elles attendent d&rsquo;\u00eatre compl\u00e9t\u00e9es par des valeurs <\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"python\" data-enlighter-theme=\"godzilla\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">Fichier = open('poudlard.csv','r') \neleves=Fichier.readlines()\nFichier.close() <\/pre>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"python\" data-enlighter-theme=\"godzilla\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">import csv\neleves=[]\nwith open('216.csv',newline='')as csvfile:\n          s=csv.DictReader(csvfile,delimiter=';')\n          for line in s:\n              eleves.append(dict(line))<\/pre>\n\n\n\n<p>afficher la liste des \u00e9l\u00e8ves avec leurs caract\u00e9ristiques attribu\u00e9es, le premier programme affiche \u00ab\u00a0list\u00a0\u00bb tandis que l&rsquo;auitre affiche \u00ab\u00a0dictionnaire\u00a0\u00bb<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">import random\nrandom.randint(0,20)<\/pre>\n\n\n\n<p>g\u00e9n\u00e9rer une note al\u00e9atoire<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">import random\nmatieres=['Potions', 'Botanique','\u00e9tude des Moldus', 'Sortil\u00e8ges', 'Vol sur Balai']\nfor eleve in eleves:\n    for i in range(5):\n        notes=[random.randint(10,20) for val in matieres]\n        eleve[matieres[i]]=notes[i]<\/pre>\n\n\n\n<p>note al\u00e9atoire pour chacun des \u00e9l\u00e8ves pour chacune des mati\u00e8res<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">import plotly.graph_objects as go\nradar = go.Scatterpolar(r = [eleves[16][val] for val in matieres],theta = matieres,fill = 'toself')\ndata = [radar]\nfig = go.Figure(data = data)\nfig.update_layout(title_text = eleves[16]['\u00c9l\u00e8ve'])\nfig.show()<\/pre>\n\n\n\n<p>afficher les r\u00e9sultats avec un diagramme \u00ab\u00a0araign\u00e9e\u00a0\u00bb<\/p>\n\n\n\n<p>suite : <\/p>\n\n\n\n<p><a href=\"https:\/\/colab.research.google.com\/drive\/1D28WDvpGys-Dtrq4oX3QoeZHjbbc0HFE?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/colab.research.google.com\/drive\/1D28WDvpGys-Dtrq4oX3QoeZHjbbc0HFE?usp=sharing<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>L&rsquo;appellation de l&rsquo;extension csv est d\u00fb \u00e0 ses valeurs s\u00e9par\u00e9es par une virgule 2. La premi\u00e8re ligne donne diff\u00e9rentes valeurs qui repr\u00e9sentent les cours \u00e0 Poudlard. 3. Dans la suite du programme, \u00e0 la fin de chaque ligne, il y a une suite de virgules signe qu&rsquo;elles attendent d&rsquo;\u00eatre compl\u00e9t\u00e9es par des valeurs afficher la&hellip; <a class=\"more-link\" href=\"http:\/\/yb-isn.fr\/2021\/nsi\/romane\/2022\/03\/15\/traitement-de-donnees-en-table\/\">Poursuivre la lecture <span class=\"screen-reader-text\">Traitement de donn\u00e9es en table<\/span><\/a><\/p>\n","protected":false},"author":12,"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\/romane\/wp-json\/wp\/v2\/posts\/159"}],"collection":[{"href":"http:\/\/yb-isn.fr\/2021\/nsi\/romane\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/yb-isn.fr\/2021\/nsi\/romane\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/yb-isn.fr\/2021\/nsi\/romane\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"http:\/\/yb-isn.fr\/2021\/nsi\/romane\/wp-json\/wp\/v2\/comments?post=159"}],"version-history":[{"count":13,"href":"http:\/\/yb-isn.fr\/2021\/nsi\/romane\/wp-json\/wp\/v2\/posts\/159\/revisions"}],"predecessor-version":[{"id":173,"href":"http:\/\/yb-isn.fr\/2021\/nsi\/romane\/wp-json\/wp\/v2\/posts\/159\/revisions\/173"}],"wp:attachment":[{"href":"http:\/\/yb-isn.fr\/2021\/nsi\/romane\/wp-json\/wp\/v2\/media?parent=159"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/yb-isn.fr\/2021\/nsi\/romane\/wp-json\/wp\/v2\/categories?post=159"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/yb-isn.fr\/2021\/nsi\/romane\/wp-json\/wp\/v2\/tags?post=159"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}