{"id":126,"date":"2022-03-21T17:35:31","date_gmt":"2022-03-21T16:35:31","guid":{"rendered":"http:\/\/yb-isn.fr\/2021\/nsi\/romain\/?p=126"},"modified":"2022-05-02T16:23:51","modified_gmt":"2022-05-02T14:23:51","slug":"projet-vortex","status":"publish","type":"post","link":"http:\/\/yb-isn.fr\/2021\/nsi\/romain\/2022\/03\/21\/projet-vortex\/","title":{"rendered":"Projet Vortex"},"content":{"rendered":"\n

Sous projet 1 : syst\u00e8me d\u2019exploitation du jeu<\/span><\/h1>\n\n\n\n

Gr\u00e2ce au fichier “BORDEAUX matches.csv” nous avons des informations sur les parties jou\u00e9es en Janvier \u00e0 Bordeaux.<\/span><\/strong><\/h3>\n\n\n\n

Dans ce fichier nous avons les informations<\/span><\/strong> suivante :<\/strong> <\/span><\/h3>\n\n\n\n
\"\"<\/figure>\n\n\n\n

“V” correspond au nombre de joueurs, “game” correspond \u00e0 quelle jeu les joueurs ont jou\u00e9, “globalScore” est le score total de l’\u00e9quipe, et “startDatetime” correspond \u00e0 la date \u00e0 laquelle les \u00e9<\/strong><\/span>quipes sont venus jouer. <\/span><\/strong><\/h3>\n\n\n\n

Les ID commen\u00e7ant par “604…” correspondent au jeu “Apocalypse” et les ID commen\u00e7ant par “5fc…” correspondent au jeu “Origine”.<\/span><\/strong><\/h3>\n\n\n\n
\"\"<\/figure>\n\n\n\n

L’objectif du projet est le suivant :<\/span><\/strong><\/h3>\n\n\n\n
\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

https:\/\/colab.research.google.com\/drive\/1HShTo5Cd63NAsGnK2dFyS43–gjFiOwG?usp=sharing<\/a><\/p>\n\n\n\n

Voici le programme d\u00e9finitif du projet :<\/span><\/h2>\n\n\n\n
import pandas as pd\nfrom google.colab import files\ndata_to_load = files.upload()\nmatches= pd.read_csv('BORDEAUX matches.csv',encoding = \"ISO-8859-1\")\ndef simplifie_date(val):\n  return str(val).split('T')[0]\nindexNames = matches[matches['startDatetime'].isnull()|matches['game'].isnull()|matches['__v'].isnull()].index\nmatches.drop(indexNames , inplace=True)\nmatches['date']=matches['startDatetime'].apply(simplifie_date)\nmatches['\u00e9quipe']=1\ngames = matches.groupby(\"game\")\norigine= games.get_group('5fc126fcabc9c6bb54078531')\napocalypse=games.get_group('604743157d0d2804c8abb4f8')\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')\ndico={'__v':'players_origine','\u00e9quipe':'equipe_origine'}\norigine_players_equipe.rename(columns=dico,inplace=True)\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)\norigine_apocalypse_jour = pd.merge(origine_players_equipe,apocalypse_players_equipe, on='date')\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']\norigine_apocalypse_jour.to_excel('1matches_origine_apocalypse_jour.xlsx',sheet_name='bordeaux')\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()\n<\/pre>\n\n\n\n
La version Lyon :<\/span><\/h2>\n\n\n\n
https:\/\/colab.research.google.com\/drive\/1tRlAWE58cXIv_BGQatCrao9VM9XglOdX?usp=sharing<\/a><\/p>\n\n\n\n
Sous projet 2 : syst\u00e8me de gestion des r\u00e9servations<\/span><\/h1>\n\n\n\n
Le d\u00e9but du projet :<\/span><\/h2>\n\n\n\n
https:\/\/colab.research.google.com\/drive\/1I5QtiLovgBHc2ImMHGAwk2zHmMcpoOzU?usp=sharing<\/a><\/p>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
Sous projet 1 : syst\u00e8me d\u2019exploitation du jeu Gr\u00e2ce au fichier “BORDEAUX matches.csv” nous avons des informations sur les parties jou\u00e9es en Janvier \u00e0 Bordeaux. Dans ce fichier nous avons les informations suivante : “V” correspond au nombre de joueurs, “game” correspond \u00e0 quelle jeu les joueurs ont jou\u00e9, “globalScore” est le score total de […]<\/p>\n","protected":false},"author":11,"featured_media":25,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/yb-isn.fr\/2021\/nsi\/romain\/wp-json\/wp\/v2\/posts\/126"}],"collection":[{"href":"http:\/\/yb-isn.fr\/2021\/nsi\/romain\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/yb-isn.fr\/2021\/nsi\/romain\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/yb-isn.fr\/2021\/nsi\/romain\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"http:\/\/yb-isn.fr\/2021\/nsi\/romain\/wp-json\/wp\/v2\/comments?post=126"}],"version-history":[{"count":7,"href":"http:\/\/yb-isn.fr\/2021\/nsi\/romain\/wp-json\/wp\/v2\/posts\/126\/revisions"}],"predecessor-version":[{"id":148,"href":"http:\/\/yb-isn.fr\/2021\/nsi\/romain\/wp-json\/wp\/v2\/posts\/126\/revisions\/148"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/yb-isn.fr\/2021\/nsi\/romain\/wp-json\/wp\/v2\/media\/25"}],"wp:attachment":[{"href":"http:\/\/yb-isn.fr\/2021\/nsi\/romain\/wp-json\/wp\/v2\/media?parent=126"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/yb-isn.fr\/2021\/nsi\/romain\/wp-json\/wp\/v2\/categories?post=126"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/yb-isn.fr\/2021\/nsi\/romain\/wp-json\/wp\/v2\/tags?post=126"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}