2b:null 2c:["$","title",null,{"children":"Refugees - Sandbox | Taylor Rodgers's Workspace | Observable"}] 31:Ta08,root = { let population = await d3.csv("https://raw.githubusercontent.com/rfordatascience/tidytuesday/master/data/2023/2023-08-22/population.csv"); let populationedFilter = population.filter(pop => pop.coa_name == "France" | pop.coa_name == "Canada" | pop.coa_name == "Germany" | pop.coa == "USA" | pop.coa == "TUR" | pop.coa == "GBR" | pop.coa == "ITA" | pop.coa == "RUS"); let populationedSimplified = d3.rollups(populationedFilter.filter(pop => pop.year == 2022), v => d3.sum(v, d => d.refugees), d => d.coa_name, d => d.coo_name); let groupAggregator = function(subset) { let tempArray = []; for (let i = 0; i < subset.length; i++) { tempArray.push(subset[i][1]); } let sum = 0; tempArray.forEach(a => {sum += a;}); return ["Other", sum]; } let aggregatedArray = []; for (let i = 0; i < populationedSimplified.length; i++) { let top10 = [populationedSimplified[i][0], populationedSimplified[i][1].sort((a, b) => b[1] - a[1]).slice(0,10)]; let toBeGrouped = populationedSimplified[i][1].sort((a, b) => b[1] - a[1]).slice(10,); aggregatedArray.push(top10); aggregatedArray[i][1].push(groupAggregator(toBeGrouped)); } aggregatedArray[2][0] = "United Kingdom" aggregatedArray[7][0] = "United States" aggregatedArray.sort((a, b) => (a[0] > b[0]) ? 1 : ((b[0] > a[0]) ? -1 : 0)); let objectChildConverter = function(child, k) { let tempObject = {name: false, value: false}; tempObject.name = child[k][0]; tempObject.value = child[k][1]; return tempObject; } let objectParentConverter = function(data, i) { let tempObject = {name: false, children: false}; tempObject.name = data[i][0]; let tempChildren = [] for (let k = 0; k < data[i][1].length; k++) { tempChildren.push(objectChildConverter(data[i][1], k)) } tempObject.children = tempChildren; return tempObject; }; let data = []; for (let i = 0; i < aggregatedArray.length; i++) { data.push(objectParentConverter(aggregatedArray,i)); } // data.sort((a, b) => (a.name > b.name) ? 1 : ((b.name > a.name) ? -1 : 0)); return d3.hierarchy({ name: "refugee_data", children: data}) .sum(d => d.value) .sort((a, b) => b.name - a.name) .eachAfter(d => d.index = d.parent ? d.parent.index = d.parent.index + 1 || 0 : 0) }32:T126f,root2 = { let population = await d3.csv("https://raw.githubusercontent.com/rfordatascience/tidytuesday/master/data/2023/2023-08-22/population.csv"); let populationedFilter = population.filter(pop => pop.coa_name == "France" | pop.coa_name == "Canada" | pop.coa_name == "Germany" | pop.coa == "USA" | pop.coa == "TUR" | pop.coa == "GBR" | pop.coa == "ITA" | pop.coa == "RUS"); let populationedSimplified = d3.rollups(populationedFilter.filter(pop => pop.year == 2022), v => d3.sum(v, d => d.refugees), d => d.coa_name, d => d.coo_name); let allCountries = populationedFilter.map(d => d.coo_name); let groupAggregator = function(subset) { let tempArray = []; for (let i = 0; i < subset.length; i++) { tempArray.push(subset[i][1]); } let sum = 0; tempArray.forEach(a => {sum += a;}); return ["Other", sum]; } let aggregatedArray = []; for (let i = 0; i < populationedSimplified.length; i++) { let top10 = [populationedSimplified[i][0], populationedSimplified[i][1].sort((a, b) => b[1] - a[1]).slice(0,10)]; let toBeGrouped = populationedSimplified[i][1].sort((a, b) => b[1] - a[1]).slice(10,); aggregatedArray.push(top10); aggregatedArray[i][1].push(groupAggregator(toBeGrouped)); } aggregatedArray.sort((a, b) => (a[0] > b[0]) ? 1 : ((b[0] > a[0]) ? -1 : 0)); let objectTimeSeriesConverter = function(arrival, origin) { let tempArray = []; let year = [2010, 2011, 2012, 2013, 2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022]; if (origin == "Other") { let top10Countries = populationedSimplified .filter(d => d[0] == arrival)[0][1] .sort((a, b) => b[1] - a[1]) .slice(0,10) .map(d => d[0]); let otherCountryRollup = d3.rollups(populationedFilter.filter(pop => pop.coa_name == arrival) .filter(pop => allCountries.includes(pop.coo_name)) .filter(pop => !top10Countries.includes(pop.coo_name)), v => d3.sum(v, d => d.refugees), d => d.year); for (let y = 0; y < year.length; y++) { if (otherCountryRollup.filter(d => d[0] == year[y])[0] !== undefined) { let tempObject = {name: false, value: false}; tempObject.name = year[y]; tempObject.value = otherCountryRollup.filter(d => d[0] == year[y])[0][1]; tempArray.push(tempObject); } } ; } else { for (let y = 0; y < year.length; y++) { let popSelect = populationedFilter.filter(pop => pop.coa_name == arrival & pop.coo_name == origin & pop.year == year[y]) if (popSelect[0] !== undefined) { let tempObject = {name: false, value: false}; tempObject.name = String(year[y]); tempObject.value = Number(popSelect[0]["refugees"]); tempArray.push(tempObject); } else { let tempObject = {name: false, value: false}; tempObject.name = year[y]; tempObject.value = 0; tempArray.push(tempObject); }; }; }; return tempArray; }; let objectChildConverter = function(child, k, parent) { let tempObject = {name: false, value: false, children: false}; tempObject.name = child[k][0]; tempObject.value = child[k][1]; tempObject.children = objectTimeSeriesConverter(parent, child[k][0]); return tempObject; } let objectParentConverter = function(data, i) { let tempObject = {name: false, children: false}; tempObject.name = data[i][0]; let tempChildren = [] for (let k = 0; k < data[i][1].length; k++) { tempChildren.push(objectChildConverter(data[i][1], k, data[i][0])) } tempObject.children = tempChildren; return tempObject; }; let data = []; for (let i = 0; i < aggregatedArray.length; i++) { data.push(objectParentConverter(aggregatedArray,i)); } data[6].name = "United Kingdom" data[7].name = "United States" return d3.hierarchy({ name: "refugee_data", children: data}) .sum(d => d.value) .sort((a, b) => b.name - a.name) .eachAfter(d => d.index = d.parent ? d.parent.index = d.parent.index + 1 || 0 : 0) }33:T47b,{ let population = await d3.csv("https://raw.githubusercontent.com/rfordatascience/tidytuesday/master/data/2023/2023-08-22/population.csv"); let populationedFilter = population.filter(pop => pop.coa_name == "France" | pop.coa_name == "Canada" | pop.coa_name == "Germany" | pop.coa == "USA" | pop.coa == "TUR" | pop.coa == "GBR" | pop.coa == "ITA" | pop.coa == "RUS"); let allCountries = populationedFilter.map(d => d.coo_name); let populationedSimplified = d3.rollups(populationedFilter.filter(pop => pop.year == 2022), v => d3.sum(v, d => d.refugees), d => d.coa_name, d => d.coo_name); let top10Countries = populationedSimplified.filter(d => d[0] == "Türkiye")[0][1].sort((a, b) => b[1] - a[1]).slice(0,10).map(d => d[0]); let rollerup = d3.rollups(populationedFilter.filter(pop => pop.coa_name == "Türkiye").filter(pop => allCountries.includes(pop.coo_name)).filter(pop => !top10Countries.includes(pop.coo_name)), v => d3.sum(v, d => d.refugees), d => d.year); return rollerup // return populationedFilter.filter(pop => pop.coa_name == "Türkiye");//.filter(pop => otherCountries.includes(pop.coo_name)); }34:T7ab,chart = { // Declare the chart dimensions and margins. const width = 928; const height = 500; const marginTop = 20; const marginRight = 30; const marginBottom = 30; const marginLeft = 40; // Declare the x (horizontal position) scale. const xThing = d3.scaleTime(d3.extent(root2.data.children[0].children[1].children, d => new Date(d.name)), [marginLeft, width - marginRight]); // Declare the y (vertical position) scale. const y = d3.scaleLinear([0, d3.max(root2.data.children[0].children[1].children, d => d.value)], [height - marginBottom, marginTop]); // Declare the line generator. const line = d3.line() .x(d => xThing(new Date(d.name))) .y(d => y(d.value)); // Create the SVG container. const svg = d3.create("svg") .attr("width", width) .attr("height", height) .attr("viewBox", [0, 0, width, height]) .attr("style", "max-width: 100%; height: auto; height: intrinsic;"); // Add the x-axis. svg.append("g") .attr("transform", `translate(0,${height - marginBottom})`) .call(d3.axisBottom(xThing).ticks(width / 80).tickSizeOuter(0)); // Add the y-axis, remove the domain line, add grid lines and a label. svg.append("g") .attr("transform", `translate(${marginLeft},0)`) .call(d3.axisLeft(y).ticks(height / 40)) .call(g => g.select(".domain").remove()) .call(g => g.selectAll(".tick line").clone() .attr("x2", width - marginLeft - marginRight) .attr("stroke-opacity", 0.1)) .call(g => g.append("text") .attr("x", -marginLeft) .attr("y", 10) .attr("fill", "currentColor") .attr("text-anchor", "start") .text("↑ Daily close ($)")); // Append a path for the line. svg.append("path") .attr("fill", "none") .attr("stroke", "black") .attr("stroke-width", 3) .attr("d", line(root2.data.children[0].children[1].children)); return svg.node(); }35:[] 2f:{"id":"fe617275a667e2fd","slug":null,"title":"Refugees - Sandbox","thumbnail":"19f206cc43da607f4c3ee36c0487c8a2db451dc36922e91f468d42b14056a898","access_level":"public","create_time":"$D2023-08-31T10:56:15.880Z","update_time":"$D2023-09-16T18:07:42.297Z","view_time":null,"first_public_time":"$D2023-09-09T16:23:16.138Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"2db599d14641f6ce","login":"taylor-rodgers-ws","name":"Taylor Rodgers's Workspace","avatar_url":"https://avatars-next.observableusercontent.com/b2260f2a2e452f4f386ff170a855ef26724bd77f5b75ecc472292df67fba2343","tier":"starter_2024"},"version":1261,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"53e55e3e7ad807b0","login":"taylor-rodgers","name":"Taylor Rodgers","avatar_url":"https://avatars-next.observableusercontent.com/dc48e0f5b2866fbf5598be28da8ddcfa4fbf759b930af44100f4d84339d16f18","tier":null}],"members":[{"type":"individual","id":"53e55e3e7ad807b0","login":"taylor-rodgers","name":"Taylor Rodgers","avatar_url":"https://avatars-next.observableusercontent.com/dc48e0f5b2866fbf5598be28da8ddcfa4fbf759b930af44100f4d84339d16f18","tier":null,"role":"editor"},{"type":"team","id":"2db599d14641f6ce","login":"taylor-rodgers-ws","name":"Taylor Rodgers's Workspace","avatar_url":"https://avatars-next.observableusercontent.com/b2260f2a2e452f4f386ff170a855ef26724bd77f5b75ecc472292df67fba2343","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Refugees - Sandbox","cells":[{"id":0,"value":"# Refugees - Sandbox","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":5,"value":"$31","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":659,"value":"$32","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":972,"value":"$33","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1109,"value":"[new Date(d3.min(root2.data.children[0].children[0].children, d => `${d.name}-01-01`)), new Date(d3.max(root2.data.children[0].children[0].children, d => `${d.name}-12-31`))]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1119,"value":"root2.data.children[0].children[0].children","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1149,"value":"$34","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1222,"value":"d3.extent(root2.data.children[0].children[0].children, d => new Date(d.name))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1243,"value":"[0, d3.max(root2.data.children[0].children, d => d.value)]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W35","stdlib":"1","titling":"auto"}} 30:"$2f:body"