25:["$","title",null,{"children":"Estimations de chances de médailles en vue des JO de Tokyo : Étude du Badminton | antoinehnz | Observable"}] 4c:[{"id":"bd935ac1e730d4430e78a329beb962a8415aa900260ed1df3e998a0d9e8e2d0aaed68f651ec1918d46ab77a412f721e4fc47726f9e36e95221462c92ea88726d","href":"https://static.observableusercontent.com/files/bd935ac1e730d4430e78a329beb962a8415aa900260ed1df3e998a0d9e8e2d0aaed68f651ec1918d46ab77a412f721e4fc47726f9e36e95221462c92ea88726d","name":"Badminton mixte.JPG","type":"image/jpeg","lastModified":1622021514538.928,"size":34485}] 48:{"id":"e1021272666bd5eb","slug":"badminton","title":"Estimations de chances de médailles en vue des JO de Tokyo : Étude du Badminton","thumbnail":"59546d1e23df6c4b3cec1d52f659a968d5bc801f2fecf47b1ae60ae05ebda526","access_level":"public","create_time":"$D2021-05-25T08:25:34.564Z","update_time":"$D2021-05-26T09:58:52.009Z","view_time":null,"first_public_time":"$D2021-05-25T08:27:29.233Z","has_unpublished_edits":null,"fork":{"id":"a4c1fa750ff68d17","slug":"modelevierge","title":"MODELE VIERGE","owner":{"id":"28c93ca135bc4b52","login":"antoinehnz","name":""}},"stars":0,"starred":false,"owner":{"type":"team","id":"28c93ca135bc4b52","login":"antoinehnz","name":"","avatar_url":"https://avatars-next.observableusercontent.com/38f53652d662ff38cf8f3312c897b4a1826f20df3401f2ecd6dee15b03d9dbd9","tier":"starter_2024","bio":"","followed_by_you":false,"follows_you":false},"version":424,"publish_version":424,"role":null,"authored":false,"authors":[{"type":"individual","id":"fd2bfb99bf56c2e5","login":"antoinehnz","name":"","avatar_url":"https://avatars-next.observableusercontent.com/38f53652d662ff38cf8f3312c897b4a1826f20df3401f2ecd6dee15b03d9dbd9","tier":null,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"individual","id":"fd2bfb99bf56c2e5","login":"antoinehnz","name":"","avatar_url":"https://avatars-next.observableusercontent.com/38f53652d662ff38cf8f3312c897b4a1826f20df3401f2ecd6dee15b03d9dbd9","tier":null,"role":"editor"},{"type":"individual","id":"4af7e25d44b0c0a2","login":"cleolarminay","name":"","avatar_url":"https://avatars-next.observableusercontent.com/c38b04657650ba7e448715e86499aa5e43be8b217da0476d7a09f23e76704558","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":{"id":"395c810906b95fd8","slug":"pe-77-etude-des-jo-2021","title":"[PE 77] Étude des JO 2021","owner":{"id":"28c93ca135bc4b52","login":"antoinehnz","name":""}},"type":"notebook","body":{"titling":"auto","title":"Estimations de chances de médailles en vue des JO de Tokyo : Étude du Badminton","cells":[{"id":0,"value":"md`# Estimations de chances de médailles en vue des JO de Tokyo : Étude du ${Choix_Sport}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"md`

\nNous présentons ici le travail d'un groupe d'étudiants de l'Ecole Centrale de Lyon, en ce qui concerne ${Article} ${Choix_Sport}, pour les Jeux Olympiques de 2021. Nous avons cherché à analyser les dernières performances des différents athlètes, français et internationnaux, dans différentes disciplines, afin d'estimer le nombre de médailles françaises aux Jeux. Voici ci-dessous notre analyse pour ${Article} ${Choix_Sport}.\n

\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":19,"value":"md` ---\n## Tour d'horizon de nos estimations de chances de médaille pour toutes les disciplines des JO de Tokyo`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":46,"value":"vegalite({\n \"data\": {values: data_gdoc1},\n \"layer\": [ {\n \"mark\": {\"type\" : \"bar\", \"color\" : \"#D9DDDC\"},\n \"encoding\": {\n \"x\": {\"field\": \"Sport\" , \"type\": \"nominal\"},\n \"y\": {aggregate: \"count\", field: \"*\", type: \"quantitative\",\"title\" : \"Médailles possibles\"}}},\n {\n \"mark\": {\"type\" : \"bar\", \"color\" : \"#4d4f4f\"},\n \"encoding\": {\n \"x\": {\"field\": \"Sport\" , \"type\": \"nominal\"},\n \"y\": {\"field\": 'Evaluation au'.concat(' ', DateEstimation) ,\"type\": \"quantitative\", \"aggregate\": \"sum\",\"title\" : \"Estimation\"},\n \"color\": {\n \"condition\": {test: {\"field\" : \"Sport\", \"equal\" : Choix_Sport}, value: \"#4C78A8\" },\n value: \"#4d4f4f\"}\n } }]\n },\n \"invalidation\",\n \"visibility\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":65,"value":"md`\nSur ce graphe on trouve :
\n* **Le total de podiums dans le sport**
\n* Notre estimation pour la France dans le sports (autre que ${Article} ${Choix_Sport})
\n* Notre estimation pour la France en ${Choix_Sport} \n

\n\n**À Noter** : Pour chaque discipline, on a établit une chance de podium entre 0 et 1. Ici on représente la somme de ces notes. Il faut donc voir cette valeur comme une valeur basse.
\nNotre estimation la plus haute est la suivante : ** ${Nmax} podiums** pour la France \n\nSi vous souhaitez voir nos autres estimations, notamment dans les autres sports, je vous invite à visiter [cette page](https://next.observablehq.com/@antoinehnz/visualisation-des-donnees-de-jo)

On cherche ici à représenter en détail nos estimations dans les différentes disciplines qui composent ${Article} ${Choix_Sport}.
\nFaute de temps, nous nous sommes concentré que sur certaines disciplines, nous obligeant à faire un choix, et donc laissant possiblement certaines disciplines importantes de côté.

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":113,"value":"vegalite({\"$schema\": \"https://vega.github.io/schema/vega-lite/v4.json\",\n \"data\": {values: data_gdoc3},\n \"mark\": {\"type\" : \"rect\"},\n \"encoding\": {\n \"y\" : {\"field\": \"Discipline\" , \"type\": \"nominal\", sort: false, \"title\" : Choix_Sport},\n \"x\": {\"field\" : \"Score\", \"type\": \"quantitative\", \"title\" : \"Confiance (entre 0 et 1)\",\"sort\" : false,\"scale\": {\"domain\": [0,1]}},\n \"color\": {\"field\" : \"Score\", \"type\" : \"quantitative\",\"scale\": {\"scheme\": \"redyellowgreen\",\"domain\": [0,1]},\"title\" : \"Confiance\"},\n \"config\": {\n \"axis\": {\"grid\": true, \"tickBand\": \"extent\",\"axis\": {\"format\": \"%\"},}\n },\n \"tooltip\": {\"field\": \"Score\", \"type\": \"quantitative\"}},\n \"transform\": [{\"filter\" : {\"and\": [{\"field\" : \"Sport\", \"equal\" : Choix_Sport}, {\"field\" : \"Date\", \"equal\" : DateEstimation}]}}]\n \n \n })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":37,"value":"md` ---\n## Nos favoris en ${Choix_Sport} pour les JO`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":167,"value":"md`

Dans cette partie, nous avons essayé de séléctionner parmi les différents athlètes qualifiés ou en voie de se qualifier les favoris français.
\nEncore une fois, nous avons dû faire un choix parmi les disciplines, et donc parmi les athlètes à analyser. Les athlètes français choisis sont Thom Gicquel et Delphine Delrue grâce à de récentes bonnes performances\n

\nAfin d'arriver à ces conclusions nous avons appliqué notre méthode d'analyse de donnée. Vous pouvez retrouver le détail de cette méthode sur [cette page](https://observablehq.com/@antoinehnz/presentation-de-notre-methode-danalyse-de-donnees)
\n\n

\nOn compare ainsi les résultats des favoris de toute nationalité en ${Choix_Sport}. Ceux-ci ont été choisi selon les résultats des derniers évènements majeurs
\nVoici le détail de l'application : \n

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":378,"value":"FileAttachment(\"Badminton mixte.JPG\").image()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":339,"value":"md`Sur ce tableau on trouve :
\n* La colonne score qui donne le score brut obtenu par la formule
\n* La colonne pourcentage qui donne la part de l’athlète considéré dans le score cumulé.
\n* La colonne classement qui donne le classement alors établie avec la méthode
\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":352,"value":"md`### Conclusion`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":357,"value":"md`

Le score du **badminton mixte** français est très faible par rapport à celui des favoris sélectionnés pour l'étude de ce sport. De ce fait, le score qui leur est attribué est de 0.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":368,"value":"md` ---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":43,"value":"md` ---\n## Détails Techniques`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":272,"value":"md`### Paramètres clés`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":221,"value":"Choix_Sport = \"Badminton\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":275,"value":"Article = \"le\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":297,"value":"DateEstimation = '05/05/2021'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":280,"value":"md` ---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":238,"value":"Nmax ={ return db.exec(`\n SELECT COUNT(*) FROM data_gdoc1\n WHERE Sport = \"${Choix_Sport}\" AND\n NOT([Evaluation au ${DateEstimation}] = \"0\")`)[0][\"COUNT(*)\"]\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":48,"value":"url_gdoc = \"https://docs.google.com/spreadsheets/d/e/2PACX-1vS3_DKGAgsO369BBU_4xtoYg1dEJWDd2u2rWOtNFQVAwoPE_xlXKTxbw3w92TMYN-N9ItyJHcRDiFSG/pub?gid=960746373&single=true&output=tsv\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":305,"value":"url_gdoc3 = \"https://docs.google.com/spreadsheets/d/e/2PACX-1vS3_DKGAgsO369BBU_4xtoYg1dEJWDd2u2rWOtNFQVAwoPE_xlXKTxbw3w92TMYN-N9ItyJHcRDiFSG/pub?gid=143365772&single=true&output=tsv\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":115,"value":"url_gdoc4 = \"https://docs.google.com/spreadsheets/d/e/2PACX-1vS3_DKGAgsO369BBU_4xtoYg1dEJWDd2u2rWOtNFQVAwoPE_xlXKTxbw3w92TMYN-N9ItyJHcRDiFSG/pub?gid=4095632&single=true&output=tsv\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":51,"value":"data_gdoc1 = {\n let names = [];\n const spreadsheet = await d3\n .tsv(url_gdoc)\n .then(data => data.forEach(d => names.push(d)));\n return names;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":309,"value":"data_gdoc3 = {\n let names = [];\n const spreadsheet = await d3\n .tsv(url_gdoc3)\n .then(data => data.forEach(d => names.push(d)));\n return names;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":118,"value":"data_gdoc4 = {\n let names = [];\n const spreadsheet = await d3\n .tsv(url_gdoc4)\n .then(data => data.forEach(d => names.push(d)));\n return names;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":54,"value":"d3 = require(\"d3@5\", \"d3-sankey@0.12\", \"d3-array@^2.2\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":178,"value":"alasql = require(\"alasql\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":181,"value":"db = {\n let db = new alasql.Database();\n db.exec('CREATE TABLE data_gdoc1');\n db.tables.data_gdoc1.data = data_gdoc1;\n return db\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":184,"value":"chart_data2 = {\n let sql = `\n SELECT Athletes,Discipline, [Evaluation au ${DateEstimation}] AS Confiance\n FROM data_gdoc1 \n WHERE Sport = \"${Choix_Sport}\" AND [Evaluation au ${DateEstimation}] > 0\n ORDER BY [Evaluation au ${DateEstimation}] DESC`\n \n\n return db.exec(sql)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":193,"value":"import {table} from \"@tmcw/tables/2\"//import {table} from \"@tmcw/tables@444\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":56,"value":"vegalite = require(\"@observablehq/vega-lite@0.2\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":60,"value":"colorVega = \"#4C78A8\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W4c","stdlib":"1"}} 24:null