{"id":522,"date":"2022-04-11T09:45:00","date_gmt":"2022-04-11T07:45:00","guid":{"rendered":"http:\/\/yb-isn.fr\/2021\/nsi\/?p=522"},"modified":"2022-04-11T21:57:38","modified_gmt":"2022-04-11T19:57:38","slug":"traitement-de-donnees-en-table","status":"publish","type":"post","link":"http:\/\/yb-isn.fr\/2021\/nsi\/?p=522","title":{"rendered":"Projet Vortex"},"content":{"rendered":"<p><!--more--><\/p>\n\n<div class=\"container theme1\" style=\"width:100%; height:auto\"><ul class=\"responsive-accordion responsive-accordion-default bm-larger\"><li><div class=\"responsive-accordion-head\" style=\"background-color:\"><span style=\"color:;font-size:15px\">bo: programme officiel<\/span><i class=\"fa fa-chevron-down responsive-accordion-plus fa-fw\"><\/i><i class=\"fa fa-chevron-up responsive-accordion-minus fa-fw\"><\/i><\/div><div class=\"responsive-accordion-panel\"style=\"background-color:;padding:12px;color:;font-size:14px\"><p><img class=\"alignnone wp-image-525 size-full\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/wp-content\/uploads\/2022\/02\/botables.png\" alt=\"\" width=\"624\" height=\"451\" \/><\/p>\n<\/div><\/li><\/ul><\/div>\n\n\n\n<p>objet d&rsquo;\u00e9tude : Vortex exp\u00e9rience<\/p>\n\n\n\n<p>pr\u00e9paration \u00e0 un d\u00e9fi en rapport avec le traitement de donn\u00e9es<\/p>\n\n\n\n<p>R\u00e9compense si la classe rel\u00e8ve le d\u00e9fi : invitation pour toute la classe \u00e0 une partie de VR en fin d&rsquo;ann\u00e9e \u00e0 Vortex exp\u00e9rience Bordeaux<\/p>\n\n\n\n<p><a href=\"https:\/\/www.vortex-experience.com\/\">https:\/\/www.vortex-experience.com\/<\/a><\/p>\n\n\n\n<p><br>Vortex exp\u00e9rience propose des exp\u00e9riences de r\u00e9alit\u00e9 virtuelle en d\u00e9placement libre. Les jeux sont exclusifs et ont \u00e9t\u00e9 d\u00e9velopp\u00e9s uniquement pour Vortex Exp\u00e9rience. <\/p>\n\n\n\n<p>La partie se joue en \u00e9quipe et deux jeux diff\u00e9rents sont propos\u00e9s: Vortex origine et vortex apocalypse<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"442\" height=\"199\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/wp-content\/uploads\/2022\/02\/image-4.png\" alt=\"\" class=\"wp-image-544\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/wp-content\/uploads\/2022\/02\/image-4.png 442w, http:\/\/yb-isn.fr\/2021\/nsi\/wp-content\/uploads\/2022\/02\/image-4-300x135.png 300w\" sizes=\"(max-width: 442px) 100vw, 442px\" \/><\/figure>\n\n\n<div class=\"container theme1\" style=\"width:100%; height:auto\"><ul class=\"responsive-accordion responsive-accordion-default bm-larger\"><li><div class=\"responsive-accordion-head\" style=\"background-color:\"><span style=\"color:;font-size:15px\">quelques indices utiles<\/span><i class=\"fa fa-chevron-down responsive-accordion-plus fa-fw\"><\/i><i class=\"fa fa-chevron-up responsive-accordion-minus fa-fw\"><\/i><\/div><div class=\"responsive-accordion-panel\"style=\"background-color:;padding:12px;color:;font-size:14px\"><p><img class=\"alignnone wp-image-538 size-full\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/wp-content\/uploads\/2022\/02\/Capture1.png\" alt=\"\" width=\"372\" height=\"714\" \/><\/p>\n<p><img class=\"alignnone wp-image-539 size-full\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/wp-content\/uploads\/2022\/02\/CaptureAPO.png\" alt=\"\" width=\"595\" height=\"217\" \/><\/p>\n<p><img class=\"alignnone wp-image-540 size-full\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/wp-content\/uploads\/2022\/02\/CaptureORIGINE.png\" alt=\"\" width=\"623\" height=\"231\" \/><\/p>\n<\/div><\/li><\/ul><\/div>\n\n\n\n<p><a href=\"http:\/\/yb-isn.fr\/vortex.zip\">t\u00e9l\u00e9charger les fichiers de donn\u00e9es utiles<\/a><\/p>\n\n\n\n<p class=\"has-cyan-bluish-gray-background-color has-background\">Sous projet 1 : syst\u00e8me d&rsquo;exploitation du jeu<\/p>\n\n\n\n<p>Ouvrir le fichier BORDEAUX matches.csv <\/p>\n\n\n\n<p>Ce fichier nous donne des informations sur les partie jou\u00e9es en Janvier \u00e0 Bordeaux<\/p>\n\n\n\n<p>Une ligne correspond \u00e0 une partie et le nombre de joueurs constituant l&rsquo;\u00e9quipe pour cette partie est donn\u00e9 par la colonne &lsquo;v&rsquo;.<\/p>\n\n\n\n<p>Il y a deux jeux diff\u00e9rents identifiables par la colonne game.<\/p>\n\n\n\n<p class=\"has-vivid-red-color has-text-color\"><strong>Votre mission consiste \u00e0 \u00e9crire un programme capable de produire un fichier excel :<\/strong><\/p>\n\n\n\n<p>Les donn\u00e9es doivent \u00eatres agr\u00e9g\u00e9es par dates avec le nombre de joueurs le nombre de parties et le d\u00e9tail pour chacun des jeux.<\/p>\n\n\n\n<p>Pour vous donner une id\u00e9e vous trouverez ci-dessous un exemple de r\u00e9sultat attendu.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"1024\" height=\"345\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/wp-content\/uploads\/2022\/03\/image-1024x345.png\" alt=\"\" class=\"wp-image-693\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/wp-content\/uploads\/2022\/03\/image-1024x345.png 1024w, http:\/\/yb-isn.fr\/2021\/nsi\/wp-content\/uploads\/2022\/03\/image-300x101.png 300w, http:\/\/yb-isn.fr\/2021\/nsi\/wp-content\/uploads\/2022\/03\/image-768x259.png 768w, http:\/\/yb-isn.fr\/2021\/nsi\/wp-content\/uploads\/2022\/03\/image-1200x406.png 1200w, http:\/\/yb-isn.fr\/2021\/nsi\/wp-content\/uploads\/2022\/03\/image.png 1205w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong>Corrig\u00e9 du sous projet 1<\/strong><\/p>\n\n\n\n<p><a href=\"https:\/\/drive.google.com\/file\/d\/1FZKW0ikoMYTWGiGtjr1w0Ws1Dcb5szEb\/view?usp=sharing\">https:\/\/drive.google.com\/file\/d\/1FZKW0ikoMYTWGiGtjr1w0Ws1Dcb5szEb\/view?usp=sharing<\/a><\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"python\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">import pandas as pd\n\nfrom google.colab import files\ndata_to_load = files.upload()\n\nmatches= pd.read_csv('BORDEAUX matches.csv',encoding = \"ISO-8859-1\")\n\ndef simplifie_date(val):\n  return str(val).split('T')[0]\n\nindexNames = matches[matches['startDatetime'].isnull()|matches['game'].isnull()|matches['__v'].isnull()].index\nmatches.drop(indexNames , inplace=True)\n\nmatches['date']=matches['startDatetime'].apply(simplifie_date)\nmatches['\u00e9quipe']=1\n\ngames = matches.groupby(\"game\")\norigine= games.get_group('5fc126fcabc9c6bb54078531')\napocalypse=games.get_group('604743157d0d2804c8abb4f8')\n\norigine_players=origine.groupby(['date'])['__v'].agg('sum').to_frame()\norigine_equipe=origine.groupby(['date'])['\u00e9quipe'].agg('sum').to_frame()\norigine_matches=pd.DataFrame()\norigine_players_equipe = pd.merge(origine_players,origine_equipe, on='date')\n\ndico={'__v':'players_origine','\u00e9quipe':'equipe_origine'}\norigine_players_equipe.rename(columns=dico,inplace=True)\n\napocalypse_players=apocalypse.groupby(['date'])['__v'].agg('sum').to_frame()\napocalypse_equipe=apocalypse.groupby(['date'])['\u00e9quipe'].agg('sum').to_frame()\napocalypse_matches=pd.DataFrame()\napocalypse_players_equipe = pd.merge(apocalypse_players,apocalypse_equipe, on='date')\napocalypse_players_equipe.rename(columns={'__v':'players_apocalypse','\u00e9quipe':'equipe_apocalypse'},inplace=True)\n\norigine_apocalypse_jour = pd.merge(origine_players_equipe,apocalypse_players_equipe, on='date')\n\norigine_apocalypse_jour['players']=origine_apocalypse_jour['players_origine']+origine_apocalypse_jour['players_apocalypse']\norigine_apocalypse_jour['equipes']=origine_apocalypse_jour['equipe_origine']+origine_apocalypse_jour['equipe_apocalypse']\n\norigine_apocalypse_jour.to_excel('1matches_origine_apocalypse_jour.xlsx',sheet_name='bordeaux')\n\nimport matplotlib.pyplot as plt\ngraphiques=['players_origine','players_apocalypse','players','equipe_origine','equipe_apocalypse','equipes']\nax=origine_apocalypse_jour.plot(y=graphiques,grid=True,kind=\"bar\",figsize=(20,10)) \nax.set_ylabel('nombre de joueurs par jour')\nax.set_xlabel('date')\nplt.show()<\/pre>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/wp-content\/uploads\/2022\/04\/image-1024x558.png\" alt=\"\" class=\"wp-image-721\" width=\"1024\" height=\"558\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/wp-content\/uploads\/2022\/04\/image-1024x558.png 1024w, http:\/\/yb-isn.fr\/2021\/nsi\/wp-content\/uploads\/2022\/04\/image-300x163.png 300w, http:\/\/yb-isn.fr\/2021\/nsi\/wp-content\/uploads\/2022\/04\/image-768x418.png 768w, http:\/\/yb-isn.fr\/2021\/nsi\/wp-content\/uploads\/2022\/04\/image.png 1170w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"has-cyan-bluish-gray-background-color has-background\">Sous projet 2 : syst\u00e8me de gestion des r\u00e9servations<\/p>\n\n\n\n<p>La lecture de l&rsquo;onglet utile du fichier excel se fait de la mani\u00e8re suivante<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"python\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\"># lecture fichier excel\nventes = pd.read_excel('BORDEAUX vortex.xlsx',sheet_name='1 6 D\u00e9tails des ventes')<\/pre>\n\n\n\n<p class=\"has-vivid-red-color has-text-color\"> <strong>Votre mission consiste \u00e0 \u00e9crire un programme capable de produire un fichier excel :<\/strong> <\/p>\n\n\n\n<p>Les donn\u00e9es sont agr\u00e9g\u00e9es par dates avec le nombre total de ventes (joueurs ) par jour avec le d\u00e9tail pour trois lots diff\u00e9rents.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"python\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">#cr\u00e9ation de 3 lots en fonction du 'produit' vendu\nlot1=\"lot1: VORTEX APOCALYPSE,VORTEX ORIGINE,VORTEX NOEL 12 17 ANS,\\\nVORTEX ORIGINE Tarif \u00e9tudiants,VORTEX APOCALYPSE Tarif Etudiants\"\n\nlot2=\"lot2: RESERVATION GIFT CARD VORTEX ORIGINE,RESERVATION GIFT CARD VORTEX APOCALYPSE\"\n\nlot3=\"lot3: CARTE CADEAU 1E ENTREE,Vortex Team building,Vortex Team Building Privatisation \"<\/pre>\n\n\n\n<p>Un exemple de r\u00e9sultat attendu<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" width=\"626\" height=\"577\" src=\"http:\/\/yb-isn.fr\/2021\/nsi\/wp-content\/uploads\/2022\/03\/image-1.png\" alt=\"\" class=\"wp-image-705\" srcset=\"http:\/\/yb-isn.fr\/2021\/nsi\/wp-content\/uploads\/2022\/03\/image-1.png 626w, http:\/\/yb-isn.fr\/2021\/nsi\/wp-content\/uploads\/2022\/03\/image-1-300x277.png 300w\" sizes=\"(max-width: 626px) 100vw, 626px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":531,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/yb-isn.fr\/2021\/nsi\/index.php?rest_route=\/wp\/v2\/posts\/522"}],"collection":[{"href":"http:\/\/yb-isn.fr\/2021\/nsi\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/yb-isn.fr\/2021\/nsi\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/yb-isn.fr\/2021\/nsi\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/yb-isn.fr\/2021\/nsi\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=522"}],"version-history":[{"count":27,"href":"http:\/\/yb-isn.fr\/2021\/nsi\/index.php?rest_route=\/wp\/v2\/posts\/522\/revisions"}],"predecessor-version":[{"id":724,"href":"http:\/\/yb-isn.fr\/2021\/nsi\/index.php?rest_route=\/wp\/v2\/posts\/522\/revisions\/724"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/yb-isn.fr\/2021\/nsi\/index.php?rest_route=\/wp\/v2\/media\/531"}],"wp:attachment":[{"href":"http:\/\/yb-isn.fr\/2021\/nsi\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=522"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/yb-isn.fr\/2021\/nsi\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=522"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/yb-isn.fr\/2021\/nsi\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=522"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}