2f:[] 2d:{"title":"Asylum Sankey Data Cleaning + Restructure","cells":[{"id":0,"value":"# Asylum Sankey Data Cleaning + Restructure","pinned":true,"hidden":false,"mode":"md"},{"id":5,"value":"d3=require('d3');","pinned":false,"hidden":false,"mode":"ojs"},{"id":9,"value":"rawdata = d3.json('https://raw.githubusercontent.com/tkalainoff/major-studio/main/qual/data/AFG_2021.json').then(data => _.values(data));","pinned":true,"hidden":false,"mode":"ojs"},{"id":12,"value":"data = rawdata[0]","pinned":true,"hidden":false,"mode":"ojs"},{"id":269,"value":"totalSumofRec = parseInt(d3.sum(data, item => item['Recognized decisions']))","pinned":true,"hidden":false,"mode":"ojs"},{"id":296,"value":"totalSumofALLDec = parseInt(d3.sum(data, item => item['Total decisions']))","pinned":true,"hidden":false,"mode":"ojs"},{"id":304,"value":"data[14]['Total decisions']/parseInt(d3.sum(data, item => item['Total decisions']))*100","pinned":true,"hidden":false,"mode":"ojs"},{"id":234,"value":"allLinks = wave1.concat(linksRecognized, linksProtected, linksRejected, linksClosed)","pinned":true,"hidden":false,"mode":"ojs"},{"id":251,"value":"","pinned":true,"hidden":false,"mode":"ojs"},{"id":21,"value":"// need to figure out how to merge countries to dedeupe\nfunction getNodes(array){\n let nodes = []\n\n for(let i=0; i [item[key], item])).values()]\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":43,"value":"function getLinks_wave1(array){\n let links = []\n\n for(let i=0; i item['Total decisions']))*100 < 1){\n // get target country\n newLink.target = \"Other\"\n \n // get values for target country\n newLink.value = +array[i]['Total decisions']\n newLink.color = \"darkcyan\"\n }\n else{\n // get target country\n newLink.target = array[i]['Country of asylum']\n \n // get values for target country\n newLink.value = +array[i]['Total decisions']\n newLink.color = \"darkcyan\"\n }\n links.push(newLink)\n }\n return links\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":49,"value":"wave1 = getLinks_wave1(data)","pinned":true,"hidden":false,"mode":"ojs"},{"id":329,"value":"sigCountries = d3.group(wave1, d=> d.target)","pinned":true,"hidden":false,"mode":"ojs"},{"id":332,"value":"sigCountries_sum = d3.flatRollup(wave1, v => d3.sum(v, d => d.value), d => d.target)","pinned":true,"hidden":false,"mode":"ojs"},{"id":52,"value":"function getLinks_Rec(array){\n let linksRecognized = []\n\n for(let i=0; i\n item['Recognized decisions']))*100 < 1){\n newLink.source = \"Other\"\n newLink.target = \"recognized\"\n newLink.value = +array[i]['Recognized decisions']\n newLink.color = \"lawngreen\"\n }\n else{\n newLink.source = array[i]['Country of asylum']\n newLink.target = \"recognized\"\n newLink.value = +array[i]['Recognized decisions']\n newLink.color = \"lawngreen\"\n }\n linksRecognized.push(newLink)\n }\nreturn linksRecognized\n}\n\n ","pinned":true,"hidden":false,"mode":"ojs"},{"id":89,"value":"linksRecognized = getLinks_Rec(data)","pinned":true,"hidden":false,"mode":"ojs"},{"id":202,"value":"function getLinks_Pro(array){\n let linksProtected = []\n\n for(let i=0; i\n item['Complementary protection']))*100 < 1){\n newLink.source = \"Other\"\n newLink.target = \"protected\"\n newLink.value = +array[i]['Complementary protection']\n newLink.color = \"gold\"\n }\n else{\n newLink.source = array[i]['Country of asylum']\n newLink.target = \"protected\"\n newLink.value = +array[i]['Complementary protection']\n newLink.color = \"gold\"\n }\n linksProtected.push(newLink)\n }\nreturn linksProtected\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":205,"value":"linksProtected = getLinks_Pro(data)","pinned":true,"hidden":false,"mode":"ojs"},{"id":211,"value":"function getLinks_Rej(array){\n let linksRejected = []\n\n for(let i=0; i\n item['Rejected decisions']))*100 < 1){\n newLink.source = \"Other\"\n newLink.target = \"rejected\"\n newLink.value = +array[i]['Rejected decisions']\n newLink.color = \"firebrick\"\n }\n else{\n newLink.source = array[i]['Country of asylum']\n newLink.target = \"rejected\"\n newLink.value = +array[i]['Rejected decisions']\n newLink.color = \"firebrick\"\n }\n linksRejected.push(newLink)\n }\nreturn linksRejected\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":213,"value":"linksRejected = getLinks_Rej(data)","pinned":true,"hidden":false,"mode":"ojs"},{"id":219,"value":"function getLinks_Clo(array){\n let linksClosed = []\n\n for(let i=0; i\n item['Otherwise closed']))*100 < 1){\n newLink.source = \"Other\"\n newLink.target = \"closed\"\n newLink.value = +array[i]['Otherwise closed']\n newLink.color = \"mediumvioletred\"\n }\n else{\n newLink.source = array[i]['Country of asylum']\n newLink.target = \"closed\"\n newLink.value = +array[i]['Otherwise closed']\n newLink.color = \"mediumvioletred\"\n }\n linksClosed.push(newLink)\n }\nreturn linksClosed\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":221,"value":"linksClosed = getLinks_Clo(data)","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W2f","stdlib":"1","titling":"auto"}