Public
Edited
Nov 26, 2022
Asylum Sankey Data Cleaning + Restructure
rawdata = d3.json('https://raw.githubusercontent.com/tkalainoff/major-studio/main/qual/data/AFG_2021.json').then(data => _.values(data));
data = rawdata[0]
totalSumofRec = parseInt(d3.sum(data, item => item['Recognized decisions']))
totalSumofALLDec = parseInt(d3.sum(data, item => item['Total decisions']))
data[14]['Total decisions']/parseInt(d3.sum(data, item => item['Total decisions']))*100
allLinks = wave1.concat(linksRecognized, linksProtected, linksRejected, linksClosed)
Type JavaScript, then Shift-Enter. Ctrl-space for more options. Arrow ↑/↓ to switch modes.
// need to figure out how to merge countries to dedeupe
function getNodes(array){
let nodes = []
for(let i=0; i<array.length; i++){
let newNode = {}
//newNode.nodeNum = i
newNode.nodeName = array[i]['Country of asylum']
nodes.push(newNode)
}
nodes.push(
{nodeName: "Afghanistan"},
{nodeName: "Other"},
{nodeName: "Recognized decisions"},
{nodeName: "Complementary protection"},
{nodeName: "Rejected decisions"},
{nodeName: "Otherwise closed"})
nodes = getUniqueListBy(nodes, 'nodeName')
return nodes
}
nodes = getNodes(data)
function getUniqueListBy(arr, key) {
return [...new Map(arr.map(item => [item[key], item])).values()]
}
function getLinks_wave1(array){
let links = []
for(let i=0; i<array.length; i++){
let newLink = {}
// get source country
newLink.source = "Afghanistan"
if (+array[i]['Total decisions']/parseInt(d3.sum(data, item => item['Total decisions']))*100 < 1){
// get target country
newLink.target = "Other"
// get values for target country
newLink.value = +array[i]['Total decisions']
newLink.color = "darkcyan"
}
else{
// get target country
newLink.target = array[i]['Country of asylum']
// get values for target country
newLink.value = +array[i]['Total decisions']
newLink.color = "darkcyan"
}
links.push(newLink)
}
return links
}
wave1 = getLinks_wave1(data)
sigCountries = d3.group(wave1, d=> d.target)
sigCountries_sum = d3.flatRollup(wave1, v => d3.sum(v, d => d.value), d => d.target)
function getLinks_Rec(array){
let linksRecognized = []
for(let i=0; i<array.length; i++){
let newLink = {}
// get decision targets
// get values from decision targets
if (+array[i]['Recognized decisions']/parseInt(d3.sum(data, item =>
item['Recognized decisions']))*100 < 1){
newLink.source = "Other"
newLink.target = "recognized"
newLink.value = +array[i]['Recognized decisions']
newLink.color = "lawngreen"
}
else{
newLink.source = array[i]['Country of asylum']
newLink.target = "recognized"
newLink.value = +array[i]['Recognized decisions']
newLink.color = "lawngreen"
}
linksRecognized.push(newLink)
}
return linksRecognized
}
linksRecognized = getLinks_Rec(data)
function getLinks_Pro(array){
let linksProtected = []
for(let i=0; i<array.length; i++){
let newLink = {}
if (+array[i]['Complementary protection']/parseInt(d3.sum(data, item =>
item['Complementary protection']))*100 < 1){
newLink.source = "Other"
newLink.target = "protected"
newLink.value = +array[i]['Complementary protection']
newLink.color = "gold"
}
else{
newLink.source = array[i]['Country of asylum']
newLink.target = "protected"
newLink.value = +array[i]['Complementary protection']
newLink.color = "gold"
}
linksProtected.push(newLink)
}
return linksProtected
}
linksProtected = getLinks_Pro(data)
function getLinks_Rej(array){
let linksRejected = []
for(let i=0; i<array.length; i++){
let newLink = {}
if (+array[i]['Rejected decisions']/parseInt(d3.sum(data, item =>
item['Rejected decisions']))*100 < 1){
newLink.source = "Other"
newLink.target = "rejected"
newLink.value = +array[i]['Rejected decisions']
newLink.color = "firebrick"
}
else{
newLink.source = array[i]['Country of asylum']
newLink.target = "rejected"
newLink.value = +array[i]['Rejected decisions']
newLink.color = "firebrick"
}
linksRejected.push(newLink)
}
return linksRejected
}
linksRejected = getLinks_Rej(data)
function getLinks_Clo(array){
let linksClosed = []
for(let i=0; i<array.length; i++){
let newLink = {}
if (+array[i]['Otherwise closed']/parseInt(d3.sum(data, item =>
item['Otherwise closed']))*100 < 1){
newLink.source = "Other"
newLink.target = "closed"
newLink.value = +array[i]['Otherwise closed']
newLink.color = "mediumvioletred"
}
else{
newLink.source = array[i]['Country of asylum']
newLink.target = "closed"
newLink.value = +array[i]['Otherwise closed']
newLink.color = "mediumvioletred"
}
linksClosed.push(newLink)
}
return linksClosed
}
linksClosed = getLinks_Clo(data)
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
