30:T5ea,Description des champs : - **iso3** : code ISO3 du pays - **noc** : code pays dans la base des JO - **name** : nom du pays - **year** : année sélectionnée dans le formulaire - **sport** : sport sélectionné dans le formulaire - **participants** : nombre de sportifs de ce sport présents aux JO pour ce pays - **nb_medals** : nombre de médailles reportées - **gold** : nombre de médailles d'or remportées - **silvler** : nombre de médailles d'argent remportées - **bronze** : nombre de médailles de bronze remportées - **height_cm_mean_participants** : taille moyenne des athletes pour ce sport - **weight_kg_mean_participants** : poids moyen des athletes pour ce sport - **height_cm_mean_medal** : taille moyenne des athletes pour ce sport ayant eu une médaille - **weight_kg_mean_medal** : poids moyen des athletes pour ce sport ayant eu une médaille - **sportifs_total_pays** : nombre de sportifs sélectionnés aux JO pour ce pays (tous les sports) Données de cadrage - **area** : Superficie (kilomètres carrés) [source : banque mondiale, 2025] - **population** : population du pays [source : Olympics datasets, 2025] - **pib** : PIB en $US courants [source : banque mondiale, 2025] - **pibparhab** : PIB par habitant ($US courants) [source : banque mondiale, 2025]; - **esp** : Espérance de vie à la naissance, total (années) [source : banque mondiale, 2025], - **alim** : Prévalence de la sous-alimentation (% de la population) [source : banque mondiale, 2025]31:Td97,resultglobalSport = { // Sport let result = selectSport == "Tous les sports" ? medailles : medailles.filter((d) => d.discipline == selectSport); // Année result = result.filter((d) => d.year == selectYear); result = result.map((d) => { const bios = bios_locs_byid.get(d.athlete_id); return { ...d, lat: bios.lat, long: bios.long, height_cm: bios.height_cm, weight_kg: bios.weight_kg }; }); let groups = d3.groups(result, (d) => d.noc); let count = groups.map((d) => { // Extraire les hauteurs et poids valides de tous les participants const heights = d[1] .map((d) => d.height_cm) .filter((h) => typeof h === "number" && !Number.isNaN(h)); const weights = d[1] .map((d) => d.weight_kg) .filter((w) => typeof w === "number" && !Number.isNaN(w)); const meanHeight = heights.length > 0 ? d3.mean(heights) : undefined; const meanWeight = weights.length > 0 ? d3.mean(weights) : undefined; // Extraire les hauteurs et poids valides des médaillés const heights_medal = d[1] .filter((d) => ["Gold", "Silver", "Bronze"].includes(d.medal)) .map((d) => d.height_cm) .filter((h) => typeof h === "number" && !Number.isNaN(h)); const weights_medal = d[1] .filter((d) => ["Gold", "Silver", "Bronze"].includes(d.medal)) .map((d) => d.weight_kg) .filter((w) => typeof w === "number" && !Number.isNaN(w)); const meanHeight_medal = heights_medal.length > 0 ? d3.mean(heights_medal) : undefined; const meanWeight_medal = weights_medal.length > 0 ? d3.mean(weights_medal) : undefined; return { noc: d[0], participants: [...new Set(d[1].map((d) => d.athlete_id))].length, medal_nb: d[1].filter((d) => ["Gold", "Silver", "Bronze"].includes(d.medal) ).length, gold: d[1].filter((d) => d.medal == "Gold").length, silver: d[1].filter((d) => d.medal == "Silver").length, bronze: d[1].filter((d) => d.medal == "Bronze").length, height_cm_mean: meanHeight !== undefined ? Math.round(meanHeight * 10) / 10 : undefined, weight_kg_mean: meanWeight !== undefined ? Math.round(meanWeight * 10) / 10 : undefined, sportifs_total_pays: nbsportifspaystotal.get(d[0]), height_cm_mean_medal: meanHeight_medal !== undefined ? Math.round(meanHeight_medal * 10) / 10 : undefined, weight_kg_mean_medal: meanWeight_medal !== undefined ? Math.round(meanWeight_medal * 10) / 10 : undefined, sportifs_total_pays: nbsportifspaystotal.get(d[0]) }; }); let join = geo.join([count, table], { ids: ["noc", "NOC"], all: false }); return join.map((d) => ({ iso3: d.ISO3, noc: d.noc, name: d.name, year: selectYear.toString(), sport: selectSport, participants: d.participants, medal_nb: d.medal_nb, gold: d.gold, silver: d.silver, bronze: d.bronze, height_cm_mean_medal: d.height_cm_mean_medal, weight_kg_mean_medal: d.weight_kg_mean_medal, height_cm_mean_participants: d.height_cm_mean, weight_kg_mean_participants: d.weight_kg_mean, sportifs_total_pays: d.sportifs_total_pays, area: areabyctr.get(d.ISO3), population: popbyctr.get(d.ISO3), pib: gdpbyctr.get(d.ISO3), pibparhab: gdppercapitabyctr.get(d.ISO3), esp: espbyctr.get(d.ISO3), alim: alimbyctr.get(d.ISO3) })); }32:[{"id":"4349f1fe5ec56d02be2a570be08451e9bb9f7c0a25052d11e0f3c969b407cba37a1a94d7f3da764971b0f75812c6cf4a64d88cf939bcc052315b770f41b5392e","href":"https://static.observableusercontent.com/files/4349f1fe5ec56d02be2a570be08451e9bb9f7c0a25052d11e0f3c969b407cba37a1a94d7f3da764971b0f75812c6cf4a64d88cf939bcc052315b770f41b5392e","name":"esp.csv","type":"text/csv","lastModified":1759493462848.161,"size":205248},{"id":"98cf56ca45f764b0c0be2171bf394e7a1d64e1412e6bc955db63fe4b9ea03039b58f60eea04c8f40f0825a6702c3c58436d3137c627a1b9530f7b872658c592b","href":"https://static.observableusercontent.com/files/98cf56ca45f764b0c0be2171bf394e7a1d64e1412e6bc955db63fe4b9ea03039b58f60eea04c8f40f0825a6702c3c58436d3137c627a1b9530f7b872658c592b","name":"alim.csv","type":"text/csv","lastModified":1759493623211.718,"size":70499},{"id":"9dfeb1b0c61f477a4cef08daa695cf4bcbaf8a962dc2c8f8a1583b40be7fbe1032da2166f769a07969c24a430d19c3a0e966b174802ea4afc0cf90905b4b66c3","href":"https://static.observableusercontent.com/files/9dfeb1b0c61f477a4cef08daa695cf4bcbaf8a962dc2c8f8a1583b40be7fbe1032da2166f769a07969c24a430d19c3a0e966b174802ea4afc0cf90905b4b66c3","name":"area.csv","type":"text/csv","lastModified":1759493983829.002,"size":130568},{"id":"20986429f759afd5f5d88365d935cf543ba6062db5a045e05dddb298dcd89a6ab0b8d382b781d17fbf8c35bc97f2d2955fc0fd93d43f9be403f79e141b3c97c3","href":"https://static.observableusercontent.com/files/20986429f759afd5f5d88365d935cf543ba6062db5a045e05dddb298dcd89a6ab0b8d382b781d17fbf8c35bc97f2d2955fc0fd93d43f9be403f79e141b3c97c3","name":"gdppercapita.csv","type":"text/csv","lastModified":1759491349096.29,"size":265063},{"id":"c22b29433bec9547eb959d180ffea95dc9f6185a86a68364db990aac8536e9e6e6bb65d21b1a2501a73f95bf88476c5e2c86a36c35ef0ac74dac5772dd3ddec5","href":"https://static.observableusercontent.com/files/c22b29433bec9547eb959d180ffea95dc9f6185a86a68364db990aac8536e9e6e6bb65d21b1a2501a73f95bf88476c5e2c86a36c35ef0ac74dac5772dd3ddec5","name":"GDP.csv","type":"text/csv","lastModified":1759490916059.741,"size":255240},{"id":"2ee421a9cc75516974297084f3dbc55dabbbe63b15aa3de9ec73957a7220b27713ba1538d5cb61982f3cbc606b24d79ee1cb2844b535019c520ed790c9b5aa98","href":"https://static.observableusercontent.com/files/2ee421a9cc75516974297084f3dbc55dabbbe63b15aa3de9ec73957a7220b27713ba1538d5cb61982f3cbc606b24d79ee1cb2844b535019c520ed790c9b5aa98","name":"countries.json","type":"application/json","lastModified":1759487438857.813,"size":252546},{"id":"381bbc20d595f6dd1fe6c360b5916010b8406d4dc4020e4638b96584e21384b8b3c4c7047f494187f8d850c4d3d93456e150ba2ca9a148a369d6a75ee5749e24","href":"https://static.observableusercontent.com/files/381bbc20d595f6dd1fe6c360b5916010b8406d4dc4020e4638b96584e21384b8b3c4c7047f494187f8d850c4d3d93456e150ba2ca9a148a369d6a75ee5749e24","name":"world@2.json","type":"application/json","lastModified":1759485793479.416,"size":387965},{"id":"da67f7527c6fbcede9846848b3e736ee93c157a62b7d6e01be002666ed4cc30cad4a5f86f57d01d98a5a45a4cd832950ce4e05a082a4eff5de00bd653984ea26","href":"https://static.observableusercontent.com/files/da67f7527c6fbcede9846848b3e736ee93c157a62b7d6e01be002666ed4cc30cad4a5f86f57d01d98a5a45a4cd832950ce4e05a082a4eff5de00bd653984ea26","name":"olympic_flame.jpeg","type":"image/jpeg","lastModified":1759415165645.702,"size":2567275},{"id":"d5251df76b6df0ca9d34ffe7a22942556d6f4e70c7fb171339451789c4aeff661b028c1159ac5ae1469245b4222dd81f7a6a25285a1de221759d2435dfbe2b33","href":"https://static.observableusercontent.com/files/d5251df76b6df0ca9d34ffe7a22942556d6f4e70c7fb171339451789c4aeff661b028c1159ac5ae1469245b4222dd81f7a6a25285a1de221759d2435dfbe2b33","name":"countries@1.json","type":"application/json","lastModified":1765361159831.139,"size":252277}] 2e:{"title":"Les médailles aux Jeux Olympiques","cells":[{"id":0,"value":"# Les médailles aux Jeux Olympiques","pinned":false,"hidden":false,"mode":"md"},{"id":7,"value":"Ce [jeu de données](https://github.com/KeithGalli/Olympics-Dataset?tab=readme-ov-file) contient un jeu de données complet sur les athlètes olympiques d'été et d'hiver et leurs résultats entre 1896 et 2022. Les données ont été *scrappées* depuis le site [olympedia.org](http://olympedia.org/)","pinned":false,"hidden":false,"mode":"md"},{"id":9,"value":"olympic_flame = FileAttachment(\"olympic_flame.jpeg\").image({ width: 600 })","pinned":false,"hidden":false,"mode":"ojs"},{"id":243,"value":"## 👉 Panneau de sélection","pinned":false,"hidden":false,"mode":"md"},{"id":29,"value":"viewof selectSport = Inputs.select(sports, {\n label: html`Choisissez un sport`\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":382,"value":"viewof selectYear = Inputs.select(years, {\n label: html`Choisissez une année`,\n value: 2022,\n format: d3.format(\" \")\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":207,"value":"## 👉 Données par pays","pinned":false,"hidden":false,"mode":"md"},{"id":633,"value":"md`⚠️ Il n'y a pas de code pays pour : **${resultglobalSport\n .filter((d) => d.iso3 == undefined)\n .map((d) => String(d.noc))\n .toString()}**. (*ROC : Russian Olympic Committee, EOR : Équipe olympique des réfugiés, COR: Corée unifiée, IOA : athlètes olympiques indépendants. *)`","pinned":false,"hidden":false,"mode":"ojs"},{"id":573,"value":"Inputs.table(resultglobalSport)","pinned":false,"hidden":false,"mode":"ojs"},{"id":767,"value":"button(resultglobalSport, `${selectSport} en ${selectYear} (pays).csv`)","pinned":false,"hidden":false,"mode":"ojs"},{"id":813,"value":"$30","pinned":false,"hidden":false,"mode":"md"},{"id":831,"value":"*Vous pouvez aller chercher d'autres indicateurs ici: https://data.worldbank.org/*","pinned":false,"hidden":false,"mode":"md"},{"id":760,"value":"**Fond de carte des pays du Monde** :","pinned":false,"hidden":false,"mode":"md"},{"id":762,"value":"button(countries, `pays.json`)","pinned":false,"hidden":false,"mode":"ojs"},{"id":175,"value":"## 👉 Données par sportifs","pinned":false,"hidden":false,"mode":"md"},{"id":1052,"value":"**Sport** : ${selectSport} | **Année** : ${selectYear}","pinned":false,"hidden":false,"mode":"md"},{"id":94,"value":"viewof checkboxmedal = Inputs.checkbox([\"Bronze\", \"Silver\", \"Gold\"], {\n label: html`Médailles`,\n value: [\"Bronze\", \"Silver\", \"Gold\"]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":91,"value":"Inputs.table(result)","pinned":false,"hidden":false,"mode":"ojs"},{"id":255,"value":"button(result, `${selectSport} en ${selectYear} (sportifs).csv`)","pinned":false,"hidden":false,"mode":"ojs"},{"id":14,"value":"# Appendix","pinned":false,"hidden":false,"mode":"md"},{"id":42,"value":"### 1/ Données brutes (JO)","pinned":false,"hidden":false,"mode":"md"},{"id":53,"value":"world = FileAttachment(\"world@2.json\").json()","pinned":false,"hidden":false,"mode":"ojs"},{"id":16,"value":"noc = d3.csv(\n \"https://raw.githubusercontent.com/KeithGalli/Olympics-Dataset/refs/heads/master/clean-data/noc_regions.csv\",\n d3.autoType\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":18,"value":"pop = d3.csv(\n \"https://raw.githubusercontent.com/KeithGalli/Olympics-Dataset/refs/heads/master/clean-data/populations.csv\",\n d3.autoType\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":20,"value":"bios = d3.csv(\n \"https://raw.githubusercontent.com/KeithGalli/Olympics-Dataset/refs/heads/master/clean-data/bios.csv\",\n d3.autoType\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":22,"value":"bios_locs = d3.csv(\n \"https://raw.githubusercontent.com/KeithGalli/Olympics-Dataset/refs/heads/master/clean-data/bios_locs.csv\",\n d3.autoType\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":24,"value":"medailles = d3.csv(\n \"https://raw.githubusercontent.com/KeithGalli/Olympics-Dataset/refs/heads/master/clean-data/results.csv\",\n d3.autoType\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":918,"value":"### 2/ Données banque mondiale","pinned":false,"hidden":false,"mode":"md"},{"id":822,"value":"gdp = FileAttachment(\"GDP.csv\").csv({ typed: true })","pinned":false,"hidden":false,"mode":"ojs"},{"id":827,"value":"gdpbyctr = new Map(gdp.map((d) => [d[\"Country Code\"], d[selectYear]]))","pinned":false,"hidden":false,"mode":"ojs"},{"id":837,"value":"gdppercapita = FileAttachment(\"gdppercapita.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs"},{"id":1009,"value":"gdppercapitabyctr = new Map(\n gdppercapita.map((d) => [d[\"Country Code\"], d[selectYear]])\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":916,"value":"esp = FileAttachment(\"esp.csv\").csv({ typed: true })","pinned":false,"hidden":false,"mode":"ojs"},{"id":1013,"value":"espbyctr = new Map(esp.map((d) => [d[\"Country Code\"], d[selectYear]]))","pinned":false,"hidden":false,"mode":"ojs"},{"id":1027,"value":"alim = FileAttachment(\"alim.csv\").csv({ typed: true })","pinned":false,"hidden":false,"mode":"ojs"},{"id":1029,"value":"alimbyctr = new Map(alim.map((d) => [d[\"Country Code\"], d[selectYear]]))","pinned":false,"hidden":false,"mode":"ojs"},{"id":1040,"value":"area = FileAttachment(\"area.csv\").csv({ typed: true })","pinned":false,"hidden":false,"mode":"ojs"},{"id":1042,"value":"areabyctr = new Map(area.map((d) => [d[\"Country Code\"], d[selectYear]]))","pinned":false,"hidden":false,"mode":"ojs"},{"id":47,"value":"### 3/ Helpers","pinned":false,"hidden":false,"mode":"md"},{"id":49,"value":"geo = require(\"geotoolbox@3.0.5\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":854,"value":"table = world.features.map((d) => d.properties)","pinned":false,"hidden":false,"mode":"ojs"},{"id":485,"value":"nbsportifstotalbycountrybyyear = {\n // Années\n let result = medailles.filter((d) => d.year == selectYear);\n let groups = d3.groups(result, (d) => d.noc);\n return groups;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":121,"value":"years = [...new Set(medailles.map((d) => d.year))]\n .filter((d) => d !== null)\n .sort()","pinned":false,"hidden":false,"mode":"ojs"},{"id":26,"value":"sports = [\n \"Tous les sports\",\n ...[...new Set(medailles.map((d) => d.discipline))]\n .filter((d) => d !== null)\n .sort()\n]","pinned":false,"hidden":false,"mode":"ojs"},{"id":194,"value":"bios_locs_byid = new Map(bios_locs.map((d) => [d.athlete_id, d]))","pinned":false,"hidden":false,"mode":"ojs"},{"id":257,"value":"button = (data, filename = \"data.csv\") => {\n if (!data) throw new Error(\"Array of data required as first argument\");\n\n let downloadData;\n if (filename.includes(\".csv\")) {\n downloadData = new Blob([d3.csvFormat(data)], { type: \"text/csv\" });\n } else {\n downloadData = new Blob([JSON.stringify(data, null, 2)], {\n type: \"application/json\"\n });\n }\n\n const size = (downloadData.size / 1024).toFixed(0);\n const button = DOM.download(\n downloadData,\n filename,\n `Télécharger ${filename} (~${size} KB)`\n );\n return button;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":758,"value":"countries = FileAttachment(\"countries@1.json\").json()","pinned":false,"hidden":false,"mode":"ojs"},{"id":603,"value":"nbsportifspaystotal = {\n let result = medailles.filter((d) => d.year == selectYear);\n let groups = d3.groups(result, (d) => d.noc);\n let count = groups.map((d) => {\n return [d[0], [...new Set(d[1].map((d) => d.athlete_id))].length];\n });\n return new Map(count);\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":788,"value":"popbyctr = new Map(pop.map((d) => [d[\"Country Code\"], d[selectYear]]))","pinned":false,"hidden":false,"mode":"ojs"},{"id":1061,"value":"### 4/ Tableaux de sortie","pinned":false,"hidden":false,"mode":"md"},{"id":541,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":64,"value":"result = {\n // Sport\n let result =\n selectSport == \"Tous les sports\"\n ? medailles\n : medailles.filter((d) => d.discipline == selectSport);\n\n // Années\n result = result.filter((d) => d.year == selectYear);\n\n // Médailles\n if (checkboxmedal.length == 0) {\n result = result.filter((d) => d.medal == null);\n } else {\n result = result.filter((d) => checkboxmedal.includes(d.medal));\n }\n // Output\n\n result = result.map((d) => {\n const bios = bios_locs_byid.get(d.athlete_id);\n\n return {\n ...d,\n lat: bios.lat,\n long: bios.long,\n height_cm: bios.height_cm,\n weight_kg: bios.weight_kg\n };\n });\n\n return result;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1081,"value":"medailles","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W32","stdlib":"1","titling":"auto"}