2b:null 2c:["$","title",null,{"children":"Countries Population from 1950 to 2100 | Alain Ottenheimer | Observable"}] 31:Tee0,Pyramid_country = Plot.plot({ /* style: { background: "#008000", color: "#ffffff" }, */ marginLeft: 60, marginRight: 20, width: 1000, height: 850, marginBottom: 100, marginTop: 95, //caption: html`Age pyramid ${country} - Source : United Nation`, caption: "United Nations data source", 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 == min_date), //max_date), { x: part_pourcent == 1 ? "Nb_H_p" : "Nb_H", y: part_pourcent == 1 ? "0" : "age_string", strokeDasharray: "12", stroke: "#aaa" } ), Plot.line( un_pop_country_minMax_date.filter((d) => d.year == min_date), //max_date), { x: part_pourcent == 1 ? "Nb_H_p" : "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 M " + `${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} ${min_date}`], textAnchor: "middle" }) /* Plot.text(["My subtitle"], { frameAnchor: "bottom", dy: 60, fontSize: 30, fontWeight: "bold", lineAnchor: "bottom", text: [ `${selected_year}` + "- " + `${country}` + " - " + `${(total_pop / 1000).toFixed(0)}` + " millions" ] }) */ ] })32:T13a9,arrow_chart_1 = Plot.plot({ marginTop: 60, marginRight: 20, width: 350, height: 400, grid: true, inset: 10, caption: "Part of age groups in 1950 & 2021 (% and in Million)", color: { domain: ["=< 20 years", " > 20 years & < 60 years", ">= 60 years"], range: ["#66bd63", "#3288bd", "#f46d43"], legend: true }, x: { domain: [1920, 2100], tickFormat: ".0f", tick: 3, tickSize: 3, label: "year →" }, y: { label: "↑ Part in %", ticks: 8 }, facet: { data: data_arrow.filter((d) => d.country == country), x: "country" }, marks: [ Plot.frame(), Plot.arrow( data_arrow.filter((d) => d.country == country), { x1: "Year_1", y1: "ratio_20_1950", x2: "Year_2", y2: "ratio_20_2021", bend: 5, stroke: "#66bd63" //vert } ), Plot.arrow( data_arrow.filter((d) => d.country == country), { 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.filter((d) => d.country == country), { x1: "Year_1", y1: "ratio_60_1950", x2: "Year_2", y2: "ratio_60_2021", bend: 5, stroke: "#f46d43" // orange } ), // _________________________________________________ Plot.text( data_arrow.filter((d) => d.country == country), { x: "Year_1", y: "ratio_20_1950", fontSize: 12, //filter: "highlight", text: (d) => (((d.ratio_20_1950 / 100) * d.Nb_total_1950) / 1000).toFixed(0) > 10 ? (((d.ratio_20_1950 / 100) * d.Nb_total_1950) / 1000).toFixed(0) + " M" : (((d.ratio_20_1950 / 100) * d.Nb_total_1950) / 1000).toFixed(1) + " M", fill: "#66bd63", textAnchor: "end", dy: -5, dx: -2 } ), Plot.text( data_arrow.filter((d) => d.country == country), { x: "Year_2", y: "ratio_20_2021", fontSize: 12, text: (d) => (((d.ratio_20_2021 / 100) * d.Nb_total_2021) / 1000).toFixed(0) > 10 ? (((d.ratio_20_2021 / 100) * d.Nb_total_2021) / 1000).toFixed(0) + " M" : (((d.ratio_20_2021 / 100) * d.Nb_total_2021) / 1000).toFixed(1) + " M", fill: "#66bd63", textAnchor: "start", dy: -1, dx: 2 } ), // _________________________________________________ Plot.text( data_arrow.filter((d) => d.country == country), { x: "Year_1", y: "ratio_20_60_1950", fontSize: 12, //filter: "highlight", text: (d) => (((d.ratio_20_60_1950 / 100) * d.Nb_total_1950) / 1000).toFixed(0) > 10 ? (((d.ratio_20_60_1950 / 100) * d.Nb_total_1950) / 1000).toFixed( 0 ) + " M" : (((d.ratio_20_60_1950 / 100) * d.Nb_total_1950) / 1000).toFixed( 1 ) + " M", fill: "#3288bd", textAnchor: "end", dy: -5, dx: -2 } ), Plot.text( data_arrow.filter((d) => d.country == country), { x: "Year_2", y: "ratio_20_60_2021", fontSize: 12, text: (d) => (((d.ratio_20_60_2021 / 100) * d.Nb_total_2021) / 1000).toFixed(0) > 10 ? (((d.ratio_20_60_2021 / 100) * d.Nb_total_2021) / 1000).toFixed( 0 ) + " M" : (((d.ratio_20_60_2021 / 100) * d.Nb_total_2021) / 1000).toFixed( 1 ) + " M", fill: "#3288bd", textAnchor: "start", dy: -1, dx: 2 } ), // _________________________________________________ Plot.text( data_arrow.filter((d) => d.country == country), { x: "Year_1", y: "ratio_60_1950", fontSize: 12, //filter: "highlight", text: (d) => (((d.ratio_60_1950 / 100) * d.Nb_total_1950) / 1000).toFixed(0) > 10 ? (((d.ratio_60_1950 / 100) * d.Nb_total_1950) / 1000).toFixed(0) + " M" : (((d.ratio_60_1950 / 100) * d.Nb_total_1950) / 1000).toFixed(1) + " M", fill: "#f46d43", textAnchor: "end", dy: -5, dx: -2 } ), Plot.text( data_arrow.filter((d) => d.country == country), { x: "Year_2", y: "ratio_60_2021", fontSize: 12, text: (d) => (((d.ratio_60_2021 / 100) * d.Nb_total_2021) / 1000).toFixed(0) > 10 ? (((d.ratio_60_2021 / 100) * d.Nb_total_2021) / 1000).toFixed(0) + " M" : (((d.ratio_60_2021 / 100) * d.Nb_total_2021) / 1000).toFixed(1) + " M", fill: "#f46d43", textAnchor: "start", dy: -1, dx: 2 } ) ] })33:Tc06,arrow_chart_2 = Plot.plot({ marginTop: 60, marginRight: 20, width, height: 400, grid: true, inset: 10, caption: "Part of age groups in 1950 & 2021 (% and in Million)", color: { domain: ["=< 20 years", " > 20 years & < 60 years", ">= 60 years"], range: ["#66bd63", "#3288bd", "#f46d43"], legend: true }, x: { //type: "log", domain: [1950, 2030], tickFormat: ".0f", tickSize: 3, label: "year →" }, y: { label: "↑ Part in %", ticks: 4 }, facet: { data: data_arrow_selection, x: "country" }, marks: [ Plot.frame(), Plot.arrow(data_arrow_selection, { 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_selection, { 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_selection, { x1: "Year_1", y1: "ratio_60_1950", x2: "Year_2", y2: "ratio_60_2021", bend: 5, stroke: "#f46d43" // orange }), //____________________________________________ Plot.text(data_arrow_selection, { x: "Year_1", y: "ratio_20_1950", fontSize: 10, //filter: "highlight", text: (d) => (((d.ratio_20_1950 / 100) * d.Nb_total_1950) / 1000).toFixed(0) + " M", fill: "#66bd63", dy: -5, dx: 12 }), Plot.text(data_arrow_selection, { x: "Year_2", y: "ratio_20_2021", fontSize: 10, text: (d) => (((d.ratio_20_2021 / 100) * d.Nb_total_2021) / 1000).toFixed(0) + " M", fill: "#66bd63", dy: -1, dx: -21 }), //____________________________________________ Plot.text(data_arrow_selection, { x: "Year_1", y: "ratio_20_60_1950", fontSize: 10, //filter: "highlight", text: (d) => (((d.ratio_20_60_1950 / 100) * d.Nb_total_1950) / 1000).toFixed(0) + " M", fill: "#3288bd", dy: -5, dx: 12 }), Plot.text(data_arrow_selection, { x: "Year_2", y: "ratio_20_60_2021", fontSize: 10, text: (d) => (((d.ratio_20_60_2021 / 100) * d.Nb_total_2021) / 1000).toFixed(0) + " M", fill: "#3288bd", dy: -1, dx: -21 }), //____________________________________________ Plot.text(data_arrow_selection, { x: "Year_1", y: "ratio_60_1950", fontSize: 10, //filter: "highlight", text: (d) => (((d.ratio_60_1950 / 100) * d.Nb_total_1950) / 1000).toFixed(0) + " M", fill: "#f46d43", dy: -5, dx: 12 }), Plot.text(data_arrow_selection, { x: "Year_2", y: "ratio_60_2021", fontSize: 10, text: (d) => (((d.ratio_60_2021 / 100) * d.Nb_total_2021) / 1000).toFixed(0) + " M", fill: "#f46d43", dy: -1, dx: -21 }) ] })34: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" }) ] })35:[{"id":"09839ff709df7a38f6f3376749d1aad1c846d3c6d9ce33fc0a555dc9fb41a2491dadb35fffd429548a941d0fd0abdb85191d93fa87ffb0e4aa29251bdba18412","href":"https://static.observableusercontent.com/files/09839ff709df7a38f6f3376749d1aad1c846d3c6d9ce33fc0a555dc9fb41a2491dadb35fffd429548a941d0fd0abdb85191d93fa87ffb0e4aa29251bdba18412","name":"UN_POP_1950_2100_(27).csv","type":"text/csv","lastModified":1669150812383.806,"size":13918810},{"id":"66d12de560b3d81cd4a38841dbc72214ee60da7446bf0a3906830bb32d2d4a5134777c3fda068bbf13748b64e418537a6ddb02d0c890e36ec911a3f4d5bb7edf","href":"https://static.observableusercontent.com/files/66d12de560b3d81cd4a38841dbc72214ee60da7446bf0a3906830bb32d2d4a5134777c3fda068bbf13748b64e418537a6ddb02d0c890e36ec911a3f4d5bb7edf","name":"UN_POP_observablehq(2).csv","type":"text/csv","lastModified":1668552985273.546,"size":11219834}] 2f:{"id":"67aa1e0cf5c144be","slug":null,"title":" Countries Population from 1950 to 2100","thumbnail":"b34609979959c362d6a50cf63e39d5c7da5f6a1a46fde6719d81938ff84010bc","access_level":"public","create_time":"$D2022-10-26T14:42:52.847Z","update_time":"$D2023-10-19T20:21:43.458Z","view_time":null,"first_public_time":"$D2022-10-26T14:42:52.847Z","has_unpublished_edits":null,"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","bio":"Data Analysis, Data Viz \nJavascript, python, QGIS, Tableau, illustrator..."},"version":7114,"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,"bio":"Data Analysis, Data Viz \nJavascript, python, QGIS, Tableau, illustrator..."}],"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":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":3,"collection":{"id":"635978eee692106d","slug":"projets","title":"1- Projets","owner":{"id":"8abb31dbb05a1a94","login":"aotten","name":"Alain Ottenheimer"}},"type":"notebook","body":{"titling":"auto","title":" Countries Population from 1950 to 2100","cells":[{"id":4,"value":"note = md`\n# Countries Population from 1950 to 2100\n## Selection of 27 worldwide countries \n\nEvolution of population from 1950 to 2021 (estimates) and 2022 to 2100 (medium variant).\nBased on [**United nation dataset**](https://population.un.org/wpp/Download/Standard/Population/)\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2516,"value":"md``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5270,"value":"viewof country = Inputs.select(list_country.sort(), {\n label: \"Select country\",\n value: \"WORLD\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5313,"value":"viewof selected_year = Scrubber(list_year.sort(), {\n initial: 0, // n° de l'élément dans list_year\n delay: 400,\n loop: false,\n autoplay: false,\n loopDelay: 2000\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5614,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6853,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6407,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5052,"value":"md`\n## DATA \n\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6293,"value":"viewof data_aq = aq\n .fromCSV(await FileAttachment(\"UN_POP_1950_2100_(27).csv\").text())\n .view({ height: 100 })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5197,"value":"data = Array.from(data_aq)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5061,"value":"md`\n## DATA TREATMENT \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$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":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5205,"value":"un_pop_country_an_temp = un_pop_country.filter((d) => d.year == selected_year)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5412,"value":"un_pop_country_an = un_pop_country_an_temp\n .filter((d) => d.year == selected_year)\n .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":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5520,"value":"un_pop_country_minMax_date = un_pop_country.filter(\n (d) => (d.year == selected_year) | (d.year == d3.min(list_year))\n)\n\n////un_pop_country.filter((d) => d.year % 10 == 0),","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6461,"value":"viewof data_arrow_temp2 = data_arrow_temp1\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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6375,"value":"data_arrow = Array.from(data_arrow_temp2)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6868,"value":"data_arrow_selection = data_arrow.filter(\n (d) =>\n (d.country == \"China\") |\n (d.country == \"India\") |\n (d.country == \"algeria\") |\n (d.country == \"Nigeria\") |\n (d.country == \"Iran (Islamic Republic of)\") |\n (d.country == \"Pakistan\") |\n (d.country == \"Russian Federation\") |\n (d.country == \"United States of America\")\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5072,"value":"md`\n## CONFIGURATION \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5255,"value":"list_country = Array.from(MapCountry.keys())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5309,"value":"list_year = Array.from(MapYear.keys())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5583,"value":"max_date = d3.max(list_year)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5589,"value":"min_date = d3.min(list_year)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5398,"value":"total_F = d3.sum(un_pop_country_an_temp.map((d) => d.Nb_F))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5078,"value":"md`\n## IMPORT \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5295,"value":"import { Scrubber } from \"@mbostock/scrubber\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6288,"value":"import { aq, op } from \"@uwdata/arquero\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5116,"value":"d3 = require(\"d3@6\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5123,"value":"md`\n## NOTES \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5148,"value":"md``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5960,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5150,"value":"md``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1862,"value":"md``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2285,"value":"md``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W35","stdlib":"1"}} 30:"$2f:body"