2b:null 2c:["$","title",null,{"children":"EU 27 Population | Alain Ottenheimer | Observable"}] 31:Tcc6,Pyramid_country = Plot.plot({ marginLeft: 60, marginRight: 20, width: width, height: 700, caption: html`Age pyramid ${country} - Source : United Nation`, y: { label: "Age →", domain: d3.sort(un_pop_country_an, (d) => -d.age).map((d) => d.age_string), tickFormat: (d) => (d % 10 ? null : d), grid: false }, x: { domain: part_pourcent == 1 ? [-1.5, 1.5] : [-max_pop * 1.2, max_pop * 1.2], label: part_pourcent == 1 ? "population part in % →" : "population in thousand →", grid: true }, marks: [ Plot.barX( un_pop_country_an, part_pourcent == 1 ? { x: "Nb_H_p", y: "age_string", fill: "#6baed6" } : { x: "Nb_H", y: "age_string", fill: "#6baed6" } // blue ), Plot.barX( un_pop_country_an, part_pourcent == 1 ? { x: "min_H_p", y: "age_string", fill: "#d9d9d9" } : { x: "min_H", y: "age_string", fill: "#d9d9d9" } // grey ), Plot.barX( un_pop_country_an, part_pourcent == 1 ? { x: "Nb_F_p", y: "age_string", fill: "#fc9272" } : { x: "Nb_F", y: "age_string", fill: "#fc9272" } // pink ), Plot.barX( un_pop_country_an, part_pourcent == 1 ? { x: "min_F_p", y: "age_string", fill: "#d9d9d9" } : { x: "min_F", y: "age_string", fill: "#d9d9d9" } // grey ), Plot.line( un_pop_country_minMax_date.filter((d) => d.year == max_date), { x: part_pourcent == 1 ? 0 : "Nb_H", y: part_pourcent == 1 ? "0" : "age_string", strokeDasharray: "12", stroke: "#aaa" } ), Plot.line( un_pop_country_minMax_date.filter((d) => d.year == max_date), { x: part_pourcent == 1 ? 0 : "Nb_F", y: part_pourcent == 1 ? "0" : "age_string", strokeDasharray: "12", stroke: "#aaa" } ), Plot.text([[0, "50"]], { fill: "black", fontSize: "18px", text: [`${country}`], textAnchor: "middle" }), Plot.text([[0, "45"]], { fill: "black", fontSize: "20px", text: (d) => `${selected_year}`, textAnchor: "middle" }), Plot.text([[0, "40"]], { fill: "black", fontSize: "18px", text: ["(" + `${(total_pop / 1000).toFixed(1)}` + " million)"], textAnchor: "middle" }), Plot.text([[0, "100"]], { fill: "#6baed6", fontSize: "18px", text: ["Male surplus "], textAnchor: "end" }), Plot.text([[0, "100"]], { fill: "#fc9272", fontSize: "18px", text: [" Female surplus"], textAnchor: "start" }), Plot.text([[0, Math.round(mediane_H).toString()]], { fill: "#969696", fontSize: "14px", text: ["median age H " + `${mediane_H}` + " → "], textAnchor: "end" }), Plot.text([[0, Math.round(mediane_F).toString()]], { fill: "#969696", fontSize: "14px", text: [" ← median age F " + `${mediane_F}`], textAnchor: "start" }), Plot.text([[0, "2"]], { fill: "#777", fontSize: "18px", text: part_pourcent == 1 ? "" : [`Dash array profil: ${country} ${max_date}`], textAnchor: "middle" }) ] })32:T4bb,Pyramid_country2 = Plot.plot({ marginLeft: 60, marginRight: 20, width: width, height: 600, color: { range: ["#4575b4", "#fdae61"] }, caption: html`Age pyramid ${country} - Source : United Nation`, y: { label: "Age →", //domain: d3.sort(un_pop_country_an, (d) => -d.age).map((d) => d.age_string), //tickFormat: (d) => (d % 10 ? null : d), grid: false }, x: { domain: [-max_pop * 1.2, max_pop * 1.2], label: "population in thousand →", grid: true }, marks: [ Plot.line(un_pop_country_minMax_date, { x: "Nb_H", y: "age", stroke: (d) => d.year == selected_year }), Plot.line(un_pop_country_minMax_date, { x: "Nb_F", y: "age", stroke: (d) => d.year == selected_year }), Plot.text([[0, 50]], { fill: "black", fontSize: "18px", text: [`${country}`], textAnchor: "middle" }), Plot.text([[0, 45]], { fill: "#fdae61", fontSize: "20px", text: (d) => `${selected_year}`, textAnchor: "middle" }), Plot.text([[0, 40]], { fill: "#4575b4", fontSize: "20px", text: [max_date.toString()], textAnchor: "middle" }) ] })33:T606,arrow_chart = Plot.plot({ marginTop: 60, marginRight: 20, width, height: 400, grid: true, inset: 10, color: { domain: ["=< 20 years", " > 20 years & < 60 years", ">= 60 years"], range: ["#66bd63", "#3288bd", "#f46d43"], legend: true }, x: { //type: "log", domain: [1950, 2025], tickFormat: ".0f", tickSize: 3, label: "year →" }, y: { label: "↑ Part in %", ticks: 4 }, facet: { data: data_arrow, x: "country" }, marks: [ Plot.frame(), Plot.arrow(data_arrow, { x1: "Year_1", y1: "ratio_20_1950", x2: "Year_2", y2: "ratio_20_2021", bend: 5, stroke: "#66bd63" //vert //stroke: (d) => (d.country == country ? "orange" : "#bbb") }), Plot.arrow(data_arrow, { x1: "Year_1", y1: "ratio_20_60_1950", x2: "Year_2", y2: "ratio_20_60_2021", bend: 5, stroke: "#3288bd" // bleu }), Plot.arrow(data_arrow, { x1: "Year_1", y1: "ratio_60_1950", x2: "Year_2", y2: "ratio_60_2021", bend: 5, stroke: "#f46d43" // orange }), Plot.text(data_arrow, { x: "Year_1", y: "ratio_20_1950", fontSize: 12, //filter: "highlight", text: (d) => d.Year_1.toFixed(0), fill: "#777", dy: -5, dx: 12 }), Plot.text(data_arrow, { x: "Year_2", y: "ratio_20_2021", fontSize: 12, text: (d) => d.Year_2.toFixed(0), fill: "#777", dy: -1, dx: -21 }) ] })34:[{"id":"dc0dd795a0182750e881533d38251a31aa71488caea6f577cecbc3955bcaa52975a3f9272f43cc9509e264f3fe73b2cef354f7efc2a1eb54959c61e0e18a52fa","href":"https://static.observableusercontent.com/files/dc0dd795a0182750e881533d38251a31aa71488caea6f577cecbc3955bcaa52975a3f9272f43cc9509e264f3fe73b2cef354f7efc2a1eb54959c61e0e18a52fa","name":"UN_POP_observablehq@1.csv","type":"text/csv","lastModified":1665594949440.695,"size":5965538}] 2f:{"id":"4da9827b0d0cf5f9","slug":"eu-27-population","title":" EU 27 Population","thumbnail":"1950a16b75db4ca721904b0d6e7a7e2f85fc41e1d644785fc0169d2d2c5fec94","access_level":"public","create_time":"$D2022-10-11T19:55:59.819Z","update_time":"$D2026-03-05T15:51:42.136Z","view_time":null,"first_public_time":"$D2026-03-05T17:29:12.515Z","fork":true,"stars":1,"starred":false,"owner":{"type":"team","id":"8abb31dbb05a1a94","login":"aotten","name":"Alain Ottenheimer","avatar_url":"https://avatars-next.observableusercontent.com/c908270df8ca89015b1f236bb9cc9fb2d79a649dbedef18f6cf2290d288650c3","tier":"starter_2024"},"version":6838,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"39f8227195038a1f","login":"aotten","name":"Alain Ottenheimer","avatar_url":"https://avatars-next.observableusercontent.com/c908270df8ca89015b1f236bb9cc9fb2d79a649dbedef18f6cf2290d288650c3","tier":null}],"members":[{"type":"individual","id":"39f8227195038a1f","login":"aotten","name":"Alain Ottenheimer","avatar_url":"https://avatars-next.observableusercontent.com/c908270df8ca89015b1f236bb9cc9fb2d79a649dbedef18f6cf2290d288650c3","tier":null,"role":"editor"},{"type":"team","id":"8abb31dbb05a1a94","login":"aotten","name":"Alain Ottenheimer","avatar_url":"https://avatars-next.observableusercontent.com/c908270df8ca89015b1f236bb9cc9fb2d79a649dbedef18f6cf2290d288650c3","tier":"starter_2024","role":"viewer"}],"comments":[],"custom_thumbnail":true,"trashed":false,"subscribed":null,"forks":2,"collection":{"id":"635978eee692106d","slug":"projets","title":"1- Projets","owner":{"id":"8abb31dbb05a1a94","login":"aotten","name":"Alain Ottenheimer"}},"type":"notebook","body":{"title":" EU 27 Population","cells":[{"id":4,"value":"note = md`\n# EU 27 Population\n## Evolution of population from 1950 to 2021.\nBased on United nation dataset\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":2516,"value":"md``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5270,"value":"viewof country = Inputs.select(list_country, {\n label: \"Select EU country\",\n value: \"France\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5313,"value":"viewof selected_year = Scrubber(list_year, {\n initial: 0, //list_year.length - 1,\n delay: 250,\n loop: false,\n loopDelay: 2000\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5429,"value":"viewof part_pourcent = Inputs.radio(\n new Map([\n [\"Nb of people\", 0],\n [\"part in %\", 1]\n ]),\n { value: 0, label: \"Select scale\" }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5614,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5960,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":6407,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5052,"value":"md`\n## DATA \n\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":6293,"value":"viewof data_aq = aq\n .fromCSV(await FileAttachment(\"UN_POP_observablehq@1.csv\").text())\n .view({ height: 240 })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5197,"value":"data = Array.from(data_aq)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5061,"value":"md`\n## DATA TREATMENT \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5226,"value":"un_pop_europ = data.map(function (d) {\n return {\n country: d.country,\n year: +d.Year,\n age: d.Age != \"100+\" ? +d.Age : 100,\n age_string: d.Age.toString(),\n Nb_H: -d.Nb_H,\n Nb_F: +d.Nb_F\n };\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5224,"value":"un_pop_country = un_pop_europ.filter((d) => d.country == country)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5205,"value":"un_pop_country_an_temp = un_pop_country.filter((d) => d.year == selected_year)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5412,"value":"un_pop_country_an = un_pop_country_an_temp.map(function (d) {\n return {\n country: d.country,\n year: +d.year,\n age: +d.age,\n age_string: d.age.toString(),\n Nb_H: d.Nb_H,\n Nb_F: d.Nb_F,\n\n min_H: -d.Nb_H > +d.Nb_F ? -d.Nb_F : d.Nb_H,\n min_F: -d.Nb_H <= +d.Nb_F ? -d.Nb_H : d.Nb_F,\n\n Nb_H_p: (d.Nb_H / total_pop) * 100,\n Nb_F_p: (d.Nb_F / total_pop) * 100,\n\n min_H_p:\n -d.Nb_H > +d.Nb_F\n ? (-d.Nb_F / total_pop) * 100\n : (d.Nb_H / total_pop) * 100,\n min_F_p:\n -d.Nb_H <= +d.Nb_F\n ? -(d.Nb_H / total_pop) * 100\n : (d.Nb_F / total_pop) * 100\n };\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5520,"value":"un_pop_country_minMax_date = un_pop_country.filter(\n (d) => (d.year == selected_year) | (d.year == d3.max(list_year))\n)\n\n////un_pop_country.filter((d) => d.year % 10 == 0),","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":6690,"value":"viewof arrow_total_1950 = data_aq\n .filter((d) => d.Year == 1950)\n .groupby(\"country\", \"Year\")\n .rollup({\n Nb_total_1950: (d) => op.sum(d.Nb_H + d.Nb_F)\n //count: op.count()\n })\n .view(2)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":6708,"value":"viewof arrow_total_2021 = data_aq\n .filter((d) => d.Year == 2021)\n .groupby(\"country\", \"Year\")\n .rollup({\n Nb_total_2021: (d) => op.sum(d.Nb_H + d.Nb_F)\n //count: op.count()\n })\n .view(2)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":6301,"value":"viewof arrow20_60_1950 = data_aq\n .filter((d) => d.Age > 20 & d.Age < 60)\n .filter((d) => d.Year == 1950)\n .groupby(\"country\")\n .rollup({\n Nb_20_60_HF_1950: (d) => op.sum(d.Nb_H + d.Nb_F)\n //count: op.count()\n })\n .view(2)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":6355,"value":"viewof arrow20_60_2021 = data_aq\n .filter((d) => (d.Age > 20) & (d.Age < 60))\n .filter((d) => d.Year == 2021)\n .groupby(\"country\")\n .rollup({\n Nb_20_60_HF_2021: (d) => op.sum(d.Nb_H + d.Nb_F)\n //count: op.count()\n })\n .view(2)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":6357,"value":"viewof arrow60_1950 = data_aq\n .filter((d) => d.Age >= 60)\n .filter((d) => d.Year == 1950)\n .groupby(\"country\")\n .rollup({\n Nb_60HF_1950: (d) => op.sum(d.Nb_H + d.Nb_F)\n //count: op.count()\n })\n .view(2)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":6339,"value":"viewof arrow60_2021 = data_aq\n .filter((d) => d.Age >= 60)\n .filter((d) => d.Year == 2021)\n .groupby(\"country\") //, \"Year\")\n .rollup({\n Nb_60HF_2021: (d) => op.sum(d.Nb_H + d.Nb_F)\n //count: op.count()\n })\n .view(2)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":6718,"value":"viewof arrow20_1950 = data_aq\n .filter((d) => d.Age <= 20)\n .filter((d) => d.Year == 1950)\n .groupby(\"country\")\n .rollup({\n Nb_20HF_1950: (d) => op.sum(d.Nb_H + d.Nb_F)\n //count: op.count()\n })\n .view(2)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":6721,"value":"viewof arrow20_2021 = data_aq\n .filter((d) => d.Age <= 20)\n .filter((d) => d.Year == 2021)\n .groupby(\"country\")\n .rollup({\n Nb_20HF_2021: (d) => op.sum(d.Nb_H + d.Nb_F)\n //count: op.count()\n })\n .view(2)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":6739,"value":"viewof data_arrow_temp1 = arrow_total_1950\n .join(arrow_total_2021, [(\"country\", \"country\")])\n .join(arrow20_1950, [(\"country\", \"country\")])\n .join(arrow20_60_1950, [(\"country\", \"country\")])\n .join(arrow60_1950, [\"country\", \"country\"])\n .join(arrow20_2021, [\"country\", \"country\"])\n .join(arrow20_60_2021, [(\"country\", \"country\")])\n .join(arrow60_2021, [\"country\", \"country\"])\n .view(2)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":6461,"value":"viewof data_arrow_temp2 = data_arrow_temp1\n .filter(\n (d) =>\n (d.country == \"France\") |\n (d.country == \"Germany\") |\n (d.country == \"Italy\") |\n (d.country == \"Spain\") |\n (d.country == \"Portugal\") |\n (d.country == \"Poland\") |\n (d.country == \"Belgium\") |\n (d.country == \"Sweden\")\n )\n .derive({\n ratio_20_1950: (d) => 100 * (d.Nb_20HF_1950 / d.Nb_total_1950),\n ratio_20_60_1950: (d) => 100 * (d.Nb_20_60_HF_1950 / d.Nb_total_1950),\n ratio_60_1950: (d) => 100 * (d.Nb_60HF_1950 / d.Nb_total_1950),\n ratio_20_2021: (d) => 100 * (d.Nb_20HF_2021 / d.Nb_total_2021),\n ratio_20_60_2021: (d) => 100 * (d.Nb_20_60_HF_2021 / d.Nb_total_2021),\n ratio_60_2021: (d) => 100 * (d.Nb_60HF_2021 / d.Nb_total_2021)\n })\n .view(100)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":6375,"value":"data_arrow = Array.from(data_arrow_temp2)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5072,"value":"md`\n## CONFIGURATION \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5253,"value":"MapCountry = new Map(un_pop_europ.map((c) => [c.country, c]))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5255,"value":"list_country = Array.from(MapCountry.keys())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5305,"value":"MapYear = new Map(un_pop_europ.map((c) => [c.year, c]))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5309,"value":"list_year = Array.from(MapYear.keys())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5583,"value":"max_date = d3.max(list_year)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5589,"value":"min_date = d3.min(list_year)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5374,"value":"total_H = d3.sum(un_pop_country_an_temp.map((d) => d.Nb_H))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5398,"value":"total_F = d3.sum(un_pop_country_an_temp.map((d) => d.Nb_F))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":6067,"value":"total_pop = d3.sum(un_pop_country_an_temp.map((d) => -d.Nb_H)) +\n d3.sum(un_pop_country_an_temp.map((d) => d.Nb_F))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5680,"value":"max_pop = Math.ceil(d3.max(un_pop_country.map((d) => -d.Nb_H)))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5888,"value":"mediane_H = {\n let temp = 0;\n let mediane_H = 0;\n for (let i = 0; i < 100; i++) {\n if (temp < -total_H / 2) {\n temp = temp - un_pop_country_an_temp[i].Nb_H;\n mediane_H = i;\n }\n }\n return mediane_H;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5908,"value":"mediane_F = {\n let temp = 0;\n let mediane_F = 0;\n for (let i = 0; i < 100; i++) {\n if (temp < +total_F / 2) {\n temp = temp + un_pop_country_an_temp[i].Nb_F;\n mediane_F = i;\n }\n }\n return mediane_F;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":6631,"value":"alpha = 4","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":6076,"value":"un_pop_country_an_temp","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5073,"value":"md`\n## REFERENCE \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5078,"value":"md`\n## IMPORT \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5295,"value":"import { Scrubber } from \"@mbostock/scrubber\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":6288,"value":"import { aq, op } from \"@uwdata/arquero\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5116,"value":"d3 = require(\"d3@6\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5123,"value":"md`\n## NOTES \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5146,"value":"md`https://observablehq.com/@observablehq/plot-cheatsheets-scales\n\nhttps://observablehq.com/@observablehq/plot-arrow\n\nhttps://observablehq.com/@uwdata/introducing-arquero\n\n\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5148,"value":"md``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5150,"value":"md``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1862,"value":"md``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":2285,"value":"md``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"}],"files":"$W34","stdlib":"1","titling":"auto"}} 30:"$2f:body"