31:T888,data = { // Data import let pop = await getExcel(pop_file, "Data", 0, 3); let gdp = await getExcel(gdp_file, "Data", 0, 3); let publi = await getExcel(publi_file, "Data", 0, 3); let educdepense = await getExcel(educdepense_file, "Data", 0, 3); let alph = await getExcel(alph_file, "Data", 0, 3); let rd = await getExcel(rd_file, "Data", 0, 3); let nonscol = await getExcel(nonscol_file, "Data", 0, 3); let sup = await getExcel(sup_file, "Data", 0, 3); let genre = await getExcel(genre_file, "Data", 0, 3); let hightech = await getExcel(hightech_file, "Data", 0, 3); let depeduc = await getExcel(depeduc_file, "Data", 0, 3); // Data handling const ids = d3.sort(world.features.map((d) => d.properties.ISO3)); let attrbyid = new Map( world.features.map((d) => [d.properties.ISO3, d.properties]) ); let popbyid = d3.index(pop, (d) => d["Country Code"]); let gdpbyid = d3.index(gdp, (d) => d["Country Code"]); let publibyid = d3.index(publi, (d) => d["Country Code"]); let educdepensebyid = d3.index(educdepense, (d) => d["Country Code"]); let alphbyid = d3.index(alph, (d) => d["Country Code"]); let rdbyid = d3.index(rd, (d) => d["Country Code"]); let nonscolbyid = d3.index(nonscol, (d) => d["Country Code"]); let supbyid = d3.index(sup, (d) => d["Country Code"]); let genrebyid = d3.index(genre, (d) => d["Country Code"]); let hightechbyid = d3.index(hightech, (d) => d["Country Code"]); let depeducbyid = d3.index(depeduc, (d) => d["Country Code"]); // Build dataset let result = []; ids.forEach((ctr) => { years.forEach((y) => { result.push({ id: ctr, name: attrbyid.get(ctr).NAMEen, year: y, pop: popbyid.get(ctr)?.[y], gdp: gdpbyid.get(ctr)?.[y], publi: publibyid.get(ctr)?.[y], educdepense: educdepensebyid.get(ctr)?.[y], alph: alphbyid.get(ctr)?.[y], rd: rdbyid.get(ctr)?.[y], nonscol: nonscolbyid.get(ctr)?.[y], sup: supbyid.get(ctr)?.[y], genre: genrebyid.get(ctr)?.[y], hightech: hightechbyid.get(ctr)?.[y], depeduc: depeducbyid.get(ctr)?.[y] }); }); }); return result; }32:[{"id":"244896214767413b924714c01123ba079b3d60a9281d07f1d66997fb3699a5aef3a4f1036124841be8c0fb8650bc7944e6ddc43f53da0976f99c712c90854b9f","href":"https://static.observableusercontent.com/files/244896214767413b924714c01123ba079b3d60a9281d07f1d66997fb3699a5aef3a4f1036124841be8c0fb8650bc7944e6ddc43f53da0976f99c712c90854b9f","name":"world.json","type":"application/json","lastModified":1725374559109.816,"size":313129},{"id":"61fee039c28bc60ef0fab3b0a5899a8ae1c5445440dc9661408ade76e25d4b4f91cd199673f48c4a225147664b072a885a11b7ec07105c7602952b75f55b5dda","href":"https://static.observableusercontent.com/files/61fee039c28bc60ef0fab3b0a5899a8ae1c5445440dc9661408ade76e25d4b4f91cd199673f48c4a225147664b072a885a11b7ec07105c7602952b75f55b5dda","name":"API_IP@1.JRN.ARTC.SC_DS2_fr_excel_v2_3436815.xls","type":"application/x-msi","lastModified":1725439068914.033,"size":108544},{"id":"5971bf70f924077a337353d597b5116674e343b54f1c58dc5da6663a5a4bb4d59dc6993d2c94e7fa983a0dbf9c1bfef4f270b9f66bb5367f2f02d329b3c77d37","href":"https://static.observableusercontent.com/files/5971bf70f924077a337353d597b5116674e343b54f1c58dc5da6663a5a4bb4d59dc6993d2c94e7fa983a0dbf9c1bfef4f270b9f66bb5367f2f02d329b3c77d37","name":"API_SP@1.POP.TOTL_DS2_fr_excel_v2_3403743.xls","type":"application/x-msi","lastModified":1725440019535.25,"size":185856},{"id":"3e2808d5fe801087510b91d59842859d48b53eb70407ec765752070694dee6292a1b150350d4d278cf6dafef9fdb8b1c725df8ea76f655b3411a84728fbbeb51","href":"https://static.observableusercontent.com/files/3e2808d5fe801087510b91d59842859d48b53eb70407ec765752070694dee6292a1b150350d4d278cf6dafef9fdb8b1c725df8ea76f655b3411a84728fbbeb51","name":"API_SE@1.XPD.TOTL.GD.ZS_DS2_fr_excel_v2_3418204.xls","type":"application/x-msi","lastModified":1725440372740.472,"size":170496},{"id":"4af9bc427af46ba6ebd8fd7c8aea9c36ef651db5a03360ee5f5379af14e9342dfba13aa8b83c682ea91521ffcbc714ca4420b81b88ce3b6a6c0aa85a88b40843","href":"https://static.observableusercontent.com/files/4af9bc427af46ba6ebd8fd7c8aea9c36ef651db5a03360ee5f5379af14e9342dfba13aa8b83c682ea91521ffcbc714ca4420b81b88ce3b6a6c0aa85a88b40843","name":"API_SE.ADT.LITR.ZS_DS2_fr_excel_v2_3436293.xls","type":"application/x-msi","lastModified":1725440830037.878,"size":110592},{"id":"fca152855cd6945f7cf557eeac9c06fa6d75e164f54d192f62bc058c9fca34fd3fdf5da4ea0f2d3b53a222d52b55af2379a901048c38069c2d92b72e0936dae2","href":"https://static.observableusercontent.com/files/fca152855cd6945f7cf557eeac9c06fa6d75e164f54d192f62bc058c9fca34fd3fdf5da4ea0f2d3b53a222d52b55af2379a901048c38069c2d92b72e0936dae2","name":"API_NY.GDP.MKTP.CD_DS2_fr_excel_v2_3404808.xls","type":"application/x-msi","lastModified":1725441039238.501,"size":312832},{"id":"a41c0229b0f99abd325433013c354b6f9e6c33cc6c74220a59c02bc5607a8f30f4cb454fa7352abbf8c028e434cc2e1cd6aab5d9c4cd2387e3601cf5ee6a25d9","href":"https://static.observableusercontent.com/files/a41c0229b0f99abd325433013c354b6f9e6c33cc6c74220a59c02bc5607a8f30f4cb454fa7352abbf8c028e434cc2e1cd6aab5d9c4cd2387e3601cf5ee6a25d9","name":"API_GB.XPD.RSDV.GD.ZS_DS2_fr_excel_v2_3434716.xls","type":"application/x-msi","lastModified":1725441243933.521,"size":114688},{"id":"05a69fc58fb2ccbdfde9a08e5f59e9b1821a364ab43e0c4bdd829104ab470ff2fa0808a65376397466f4810c2c76d43576ba021f59eef0bb5dc80b6c728e749f","href":"https://static.observableusercontent.com/files/05a69fc58fb2ccbdfde9a08e5f59e9b1821a364ab43e0c4bdd829104ab470ff2fa0808a65376397466f4810c2c76d43576ba021f59eef0bb5dc80b6c728e749f","name":"API_SE.PRM.UNER.ZS_DS2_fr_excel_v2_3440818.xls","type":"application/x-msi","lastModified":1725441535253.53,"size":151552},{"id":"d27e1f86a39be0e71ce0e9861b41292bb0f1d5942656111d93666a768395def077377a3ec9fd5de2ad71483e31a2c6ba13acb91ae747d1e41f739e19becb7518","href":"https://static.observableusercontent.com/files/d27e1f86a39be0e71ce0e9861b41292bb0f1d5942656111d93666a768395def077377a3ec9fd5de2ad71483e31a2c6ba13acb91ae747d1e41f739e19becb7518","name":"CNTR_RG_60M_2020_4326.geojson","type":"application/geo+json","lastModified":1725441941787.786,"size":716609},{"id":"477dd88d6c965f0be16a49b7afd3a4d164798b43292455eaf36d744abd246f330d57cca5768a89fbcf1e976bc26d41545486fe3616fb30266992a58838bd7179","href":"https://static.observableusercontent.com/files/477dd88d6c965f0be16a49b7afd3a4d164798b43292455eaf36d744abd246f330d57cca5768a89fbcf1e976bc26d41545486fe3616fb30266992a58838bd7179","name":"CNTR_RG_20M_2020_4326.geojson","type":"application/geo+json","lastModified":1725443998304.057,"size":1889772},{"id":"58d9fabb7d2b4be1a48082c1a42a63ea9e0157bbc4e8d611cf519a617bff74e618de2611100b730ec1fb621bb0b1a63990e96ff6b5b5f8d7adae5ea69ddf0d02","href":"https://static.observableusercontent.com/files/58d9fabb7d2b4be1a48082c1a42a63ea9e0157bbc4e8d611cf519a617bff74e618de2611100b730ec1fb621bb0b1a63990e96ff6b5b5f8d7adae5ea69ddf0d02","name":"CNTR_RG_10M_2020_4326.geojson","type":"application/geo+json","lastModified":1725444005447.476,"size":4040911},{"id":"a968a5b9b3c21a566721ba50cdee01fd569690c87d978a5b7fb889afcf387994a1abd4062329609503dc55ef29b53b0a8da7141565d461a0e3b15ccf7f232130","href":"https://static.observableusercontent.com/files/a968a5b9b3c21a566721ba50cdee01fd569690c87d978a5b7fb889afcf387994a1abd4062329609503dc55ef29b53b0a8da7141565d461a0e3b15ccf7f232130","name":"API_SE.TER.ENRR_DS2_fr_excel_v2_3441462.xls","type":"application/x-msi","lastModified":1726059835540.401,"size":218112},{"id":"e84451780394de52affcae71ee381b8dd64814675be4938b7b40288510d36997b5eb14810e5e0c921bbaf4412f68c5718dd8356c063955696541b1953107d7e9","href":"https://static.observableusercontent.com/files/e84451780394de52affcae71ee381b8dd64814675be4938b7b40288510d36997b5eb14810e5e0c921bbaf4412f68c5718dd8356c063955696541b1953107d7e9","name":"API_SE.ENR.PRSC.FM.ZS_DS2_fr_excel_v2_3435869.xls","type":"application/x-msi","lastModified":1726060007129.064,"size":210432},{"id":"aced9437b51998144cfabee594fdb7abb52996ae00bea6973504dd81c77fe937bfbda72af7beab1f5a4720ce341cd49e977833d3c6e7202e038d4cffe0f3bf28","href":"https://static.observableusercontent.com/files/aced9437b51998144cfabee594fdb7abb52996ae00bea6973504dd81c77fe937bfbda72af7beab1f5a4720ce341cd49e977833d3c6e7202e038d4cffe0f3bf28","name":"API_TX.VAL.TECH.CD_DS2_fr_excel_v2_3422453.xls","type":"application/x-msi","lastModified":1726060255141.208,"size":95744},{"id":"94b9258dbbc928379704d6b6f9e013ab6695d87861adf4abdb93e68adebad8e07f45fb1e2a6f1c78d10221238a81ec320bfff3e6e9bd07885713851f9427f15e","href":"https://static.observableusercontent.com/files/94b9258dbbc928379704d6b6f9e013ab6695d87861adf4abdb93e68adebad8e07f45fb1e2a6f1c78d10221238a81ec320bfff3e6e9bd07885713851f9427f15e","name":"API_SE.XPD.CTOT.ZS_DS2_fr_excel_v2_3436732.xls","type":"application/x-msi","lastModified":1726060466001.109,"size":96768}] 2f:{"title":"Données (science et éducation)","cells":[{"id":0,"value":"# Données (science et éducation)","pinned":false,"hidden":false,"mode":"md"},{"id":108,"value":"

Données attributaires

","pinned":false,"hidden":false,"mode":"md"},{"id":1037,"value":"disclaimer","pinned":false,"hidden":false,"mode":"ojs"},{"id":5,"value":"*Données extraites du [site web de la Banque mondiale](https://data.worldbank.org/indicator) et mises en forme de ce notebook.*","pinned":false,"hidden":false,"mode":"md"},{"id":929,"value":"## Choix des indicateurs","pinned":false,"hidden":false,"mode":"md"},{"id":186,"value":"**1 - Selection des variables**","pinned":false,"hidden":false,"mode":"md"},{"id":44,"value":"viewof indicators = Inputs.checkbox(Object.keys(data[0]), {\n multiple: true,\n label: \"Indicateurs\",\n value: [\"id\", \"name\", \"year\"]\n //value: Object.keys(data[0])\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":367,"value":"Inputs.table(metadata, {\n layout: \"auto\",\n rows: 15,\n\n format: {\n year: (x) => x\n }\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":791,"value":"**2 - Années**","pinned":false,"hidden":false,"mode":"md"},{"id":76,"value":"viewof année = Inputs.select(years, {\n value: 2020,\n label: \"Une année\",\n format: (x) => x,\n disabled: allyears ? true : false\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":101,"value":"viewof allyears = Inputs.toggle({ label: \"Toutes les années\", value: false })","pinned":false,"hidden":false,"mode":"ojs"},{"id":796,"value":"**3 - Emprise spatiale**","pinned":false,"hidden":false,"mode":"md"},{"id":378,"value":"viewof domain = Inputs.radio([\"Monde\", \"Europe\", \"UE27\"], {\n label: \"Domaine\",\n value: \"Monde\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":399,"value":"Le tableau de données contient **${line}** ligne${line > 1 ? \"s\" :\"\"} et **${col}** colonne${col > 1 ? \"s\" :\"\"}.","pinned":false,"hidden":false,"mode":"md"},{"id":125,"value":"Inputs.table(table, {\n layout: \"auto\",\n rows: 15,\n\n format: {\n year: (x) => x\n }\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":190,"value":"button(table, \"data.csv\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":370,"value":"button(metadata, \"metadata.csv\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":931,"value":"## Récupérer les données d'un indicateur pour la dernière année disponible","pinned":false,"hidden":false,"mode":"md"},{"id":993,"value":"viewof select = Inputs.select(\n Object.keys(data[0]).filter((d) => ![\"id\", \"name\", \"year\"].includes(d)),\n {\n label: \"Indicateur\",\n value: \"pop\"\n //value: Object.keys(data[0])\n }\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1031,"value":"viewof domain2 = Inputs.radio([\"Monde\", \"Europe\", \"UE27\"], {\n label: \"Domaine\",\n value: \"Monde\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1005,"value":"html`Indicateur : ${meta.find((d) => d.id == select).desc}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":944,"value":"html`Complétude : ${\n (\n (datalastyear.filter((d) => d[select] != undefined).length /\n world.features.length) *\n 100\n ).toFixed(1) + \"%\"\n}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":978,"value":"Années : ${[...new Set(datalastyear.map((d) => d.year))]\n .filter((d) => d !== undefined)\n .sort()\n .join(\", \")}","pinned":false,"hidden":false,"mode":"md"},{"id":939,"value":"Inputs.table(datalastyear, {\n layout: \"auto\",\n rows: 15,\n\n format: {\n year: (x) => x\n }\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":961,"value":"button(datalastyear, \"datayear.csv\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":175,"value":"

Données géométriques

","pinned":false,"hidden":false,"mode":"md"},{"id":177,"value":"

Pays du Monde

","pinned":false,"hidden":false,"mode":"md"},{"id":198,"value":"viz.path({\n data: world,\n fill: \"#448EC3\",\n strokeWidth: 0.5,\n svg_zoomable: true,\n tip: true,\n svg_width: 700\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":110,"value":"button(world, \"world.geojson\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":447,"value":"

Europe

","pinned":false,"hidden":false,"mode":"md"},{"id":621,"value":"viewof emprise = Inputs.radio([\"UE27\", \"Europe\"], {\n label: \"Emprise\",\n value: \"UE27\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":615,"value":"viewof scale = Inputs.radio([\"60M\", \"20M\", \"10M\"], {\n label: \"Echelle\",\n value: \"60M\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":577,"value":"{\n let svg = viz.create({\n //domain: basemap[0],\n domain: [\n [-10, 36],\n [33, 69]\n ],\n margin: 30,\n zoomable: true,\n width: 700\n });\n svg.path({ data: basemap[1], fill: \"#EEE\" });\n svg.path({ data: basemap[0], tip: true, fill: \"#448EC3\", strokeWidth: 0.5 });\n svg.legend.box({ rect_fill: \"#448EC3\", label: \"Europe\", pos: [70, 50] });\n svg.legend.box({ rect_fill: \"#EEE\", label: \"Land\", pos: [70, 75] });\n return svg.render();\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":706,"value":"button(basemap[0], \"europe.geojson\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":708,"value":"button(basemap[1], \"land.geojson\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":13,"value":"## Annexe","pinned":false,"hidden":false,"mode":"md"},{"id":15,"value":"#### Géometries","pinned":false,"hidden":false,"mode":"md"},{"id":11,"value":"world = FileAttachment(\"world.json\").json()","pinned":false,"hidden":false,"mode":"ojs"},{"id":628,"value":"basemap = {\n let basemap;\n\n if (scale == \"60M\") {\n basemap = await FileAttachment(\"CNTR_RG_60M_2020_4326.geojson\").json();\n }\n if (scale == \"20M\") {\n basemap = await FileAttachment(\"CNTR_RG_20M_2020_4326.geojson\").json();\n }\n if (scale == \"10M\") {\n basemap = await FileAttachment(\"CNTR_RG_10M_2020_4326.geojson\").json();\n }\n\n basemap = geo.properties.keep({\n x: basemap, // a geojson\n fields: [\"ISO3_CODE\", \"CNTR_ID\", \"NAME_FREN\"]\n });\n\n let domain = emprise == \"UE27\" ? UE27 : arrEurope;\n\n return [\n geo.filter(basemap, (d) => domain.includes(d.ISO3_CODE)),\n await geo.union(basemap)\n ];\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":508,"value":"#### fichiers","pinned":false,"hidden":false,"mode":"md"},{"id":780,"value":"depeduc_file = FileAttachment(\n \"API_SE.XPD.CTOT.ZS_DS2_fr_excel_v2_3436732.xls\"\n).url()","pinned":false,"hidden":false,"mode":"ojs"},{"id":769,"value":"hightech_file = FileAttachment(\n \"API_TX.VAL.TECH.CD_DS2_fr_excel_v2_3422453.xls\"\n).url()","pinned":false,"hidden":false,"mode":"ojs"},{"id":754,"value":"genre_file = FileAttachment(\n \"API_SE.ENR.PRSC.FM.ZS_DS2_fr_excel_v2_3435869.xls\"\n).url()\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":744,"value":"sup_file = FileAttachment(\"API_SE.TER.ENRR_DS2_fr_excel_v2_3441462.xls\").url()","pinned":false,"hidden":false,"mode":"ojs"},{"id":468,"value":"publi_file = FileAttachment(\n \"API_IP@1.JRN.ARTC.SC_DS2_fr_excel_v2_3436815.xls\"\n).url()","pinned":false,"hidden":false,"mode":"ojs"},{"id":452,"value":"pop_file = FileAttachment(\n \"API_SP@1.POP.TOTL_DS2_fr_excel_v2_3403743.xls\"\n).url()","pinned":false,"hidden":false,"mode":"ojs"},{"id":515,"value":"educdepense_file = FileAttachment(\n \"API_SE@1.XPD.TOTL.GD.ZS_DS2_fr_excel_v2_3418204.xls\"\n).url()","pinned":false,"hidden":false,"mode":"ojs"},{"id":536,"value":"alph_file = FileAttachment(\n \"API_SE.ADT.LITR.ZS_DS2_fr_excel_v2_3436293.xls\"\n).url()","pinned":false,"hidden":false,"mode":"ojs"},{"id":550,"value":"gdp_file = FileAttachment(\n \"API_NY.GDP.MKTP.CD_DS2_fr_excel_v2_3404808.xls\"\n).url()","pinned":false,"hidden":false,"mode":"ojs"},{"id":559,"value":"rd_file = FileAttachment(\n \"API_GB.XPD.RSDV.GD.ZS_DS2_fr_excel_v2_3434716.xls\"\n).url()","pinned":false,"hidden":false,"mode":"ojs"},{"id":566,"value":"nonscol_file = FileAttachment(\"API_SE.PRM.UNER.ZS_DS2_fr_excel_v2_3440818.xls\").url()","pinned":false,"hidden":false,"mode":"ojs"},{"id":18,"value":"#### Données","pinned":false,"hidden":false,"mode":"md"},{"id":9,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":128,"value":"table = {\n let datayear = allyears ? data : data.filter((d) => d.year == année);\n\n let table = [];\n datayear.forEach((d) => {\n let line = {};\n indicators.forEach((i) => {\n line[i] = d[i];\n });\n table.push(line);\n });\n //table = allyears ? table : table.filter((d) => d.year == année);\n table = indicators.length == 0 ? [] : table;\n\n if (domain == \"Europe\") {\n table = table.filter((d) => arrEurope.includes(d.id));\n } else if (domain == \"UE27\") {\n table = table.filter((d) => UE27.includes(d.id));\n }\n\n return table;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":842,"value":"datalastyear = {\n const ids = d3.sort(\n world.features.map((d) => [d.properties.ISO3, d.properties.NAMEfr])\n );\n let arr = [];\n\n ids.forEach((d) => {\n let tmp = d3\n .sort(\n data.filter((b) => b.id == d[0]),\n (a, b) => d3.descending(a.year, b.year)\n )\n .find((e) => e[select] != undefined);\n arr.push({\n id: d[0],\n name: d[1],\n year: tmp?.year,\n [select]: tmp?.[select]\n });\n });\n\n if (domain2 == \"Europe\") {\n arr = arr.filter((d) => arrEurope.includes(d.id));\n } else if (domain2 == \"UE27\") {\n arr = arr.filter((d) => UE27.includes(d.id));\n }\n return arr;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":218,"value":"#### Metadata","pinned":false,"hidden":false,"mode":"md"},{"id":250,"value":"meta = {\n let arr = [\n { id: \"id\", desc: \"ISO3 code\" },\n { id: \"name\", desc: \"country name\" },\n { id: \"year\", desc: \"reference year\" }\n ];\n\n let d;\n\n [\n [\"pop\", pop_file],\n [\"gdp\", gdp_file],\n [\"publi\", publi_file],\n [\"educdepense\", educdepense_file],\n [\"alph\", alph_file],\n [\"rd\", rd_file],\n [\"nonscol\", nonscol_file],\n [\"sup\", sup_file],\n [\"genre\", genre_file],\n [\"hightech\", hightech_file],\n [\"depeduc\", depeduc_file]\n ].forEach((e) => {\n d = getExcel(e[1], \"Metadata - Indicators\", 0, 0).then((d) => {\n arr.push({\n id: e[0],\n desc: d[0][\"INDICATOR_NAME\"],\n source: \"World Bank, 2024\",\n licence: \"License : CC BY-4.0\",\n note: d[0][\"SOURCE_NOTE\"],\n source_note: d[0][\"SOURCE_ORGANIZATION\"]\n });\n });\n });\n return arr;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":351,"value":"metadata = meta.filter((d) => indicators.includes(d.id))","pinned":false,"hidden":false,"mode":"ojs"},{"id":21,"value":"#### Helpers","pinned":false,"hidden":false,"mode":"md"},{"id":194,"value":"viz = require(\"geoviz@0.7.2\")","pinned":true,"hidden":true,"mode":"ojs"},{"id":583,"value":"geo = require(\"geotoolbox\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":27,"value":"xlsx = require(\"xlsx\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":29,"value":"getExcel = async (url, sheetname, skipCol, skipRow) => {\n let buff = await d3.buffer(url);\n let wb = xlsx.read(new Uint8Array(buff), { type: \"array\" });\n\n let sheet = wb.Sheets[sheetname];\n\n //return sheet;\n let range = xlsx.utils.decode_range(sheet[\"!ref\"]);\n range.s.r = skipRow;\n range.s.c = skipCol;\n sheet[\"!ref\"] = xlsx.utils.encode_range(range);\n return xlsx.utils.sheet_to_json(sheet);\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":39,"value":"years = d3.range(1960, 2024)","pinned":false,"hidden":false,"mode":"ojs"},{"id":601,"value":"arrEurope = world.features\n .map((d) => d.properties)\n .filter((d) => d.region == \"Europe\")\n .map((d) => d.ISO3)","pinned":false,"hidden":false,"mode":"ojs"},{"id":609,"value":"UE27 = [\n \"AUT\",\n \"BEL\",\n \"DEU\",\n \"DNK\",\n \"ESP\",\n \"CYP\",\n \"ITA\",\n \"LUX\",\n \"MLT\",\n \"BGR\",\n \"FRA\",\n \"CZE\",\n \"EST\",\n \"FIN\",\n \"GRC\",\n \"HRV\",\n \"HUN\",\n \"IRL\",\n \"LTU\",\n \"LVA\",\n \"NLD\",\n \"POL\",\n \"PRT\",\n \"ROU\",\n \"SVK\",\n \"SVN\",\n \"SWE\"\n]","pinned":false,"hidden":false,"mode":"ojs"},{"id":433,"value":"line = table.length","pinned":false,"hidden":false,"mode":"ojs"},{"id":435,"value":"col = table[0] ? Object.keys(table[0]).length : 0","pinned":false,"hidden":false,"mode":"ojs"},{"id":182,"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 `Download ${filename} (~${size} KB)`\n );\n return button;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":172,"value":"","pinned":false,"hidden":false,"mode":"md"},{"id":798,"value":"import {disclaimer} from \"d41fbc44e11a58e6\"","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W32","stdlib":"1","titling":"auto"}