Skip to content

Instantly share code, notes, and snippets.

@urdinblu
Created May 7, 2015 17:14
Show Gist options
  • Save urdinblu/1696181fbfae24989f8e to your computer and use it in GitHub Desktop.
Save urdinblu/1696181fbfae24989f8e to your computer and use it in GitHub Desktop.
Exercise 6 - World Bank Regional Data - Debt as a % of GNI
CountryName CountryCode IndicatorName 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013
allDevelopingCountries LMY InterestPaymentsOnExternalDebt 2.3 2.5 2.1 1.9 1.9 1.8 1.6 1.7 1.8 1.8 1.8 1.9 2.0 1.9 1.7 1.4 1.4 1.2 1.1 1.0 1.0 0.8 0.8 0.8 0.8 0.9 0.6
eastAsia&Pacific EAP InterestPaymentsOnExternalDebt 2.1 2.0 2.1 1.9 2.0 1.7 1.7 1.6 1.6 1.5 1.6 1.7 1.6 1.5 1.3 0.9 0.8 0.8 0.6 0.6 0.5 0.4 0.3 0.6 0.6 0.5 0.2
europe&CentralAsia ECA InterestPaymentsOnExternalDebt 2.0 2.1 1.8 1.7 1.6 1.7 1.5 1.8 2.1 2.1 2.2 2.0 2.2 2.6 2.7 2.1 1.9 1.8 1.8 2.0 2.2 2.3 2.7 2.3 2.5 2.0 2.1
latinAmerica&Caribbean LAC InterestPaymentsOnExternalDebt 3.8 4.0 2.6 1.9 2.0 1.7 1.6 1.6 2.0 2.0 1.9 2.2 2.7 2.6 2.3 2.1 2.1 1.8 1.6 1.5 1.3 1.1 1.1 1.0 1.0 1.4 1.2
lowIncome LIC InterestPaymentsOnExternalDebt 1.5 1.4 1.3 1.3 1.1 1.0 1.1 1.2 1.2 1.0 0.8 0.8 0.8 0.7 0.5 0.6 0.5 0.5 0.4 0.4 0.5 0.5 0.3 0.3 0.3 0.3 0.3
lowerMiddleIncome LMC InterestPaymentsOnExternalDebt 1.8 2.0 2.2 2.2 2.4 2.3 2.1 2.1 2.1 1.9 1.9 2.1 1.7 1.9 1.7 1.4 1.3 1.2 1.1 0.9 0.9 0.8 0.7 0.6 0.6 0.7 0.7
middleIncome MIC InterestPaymentsOnExternalDebt 2.4 2.6 2.2 1.9 2.0 1.8 1.7 1.7 1.9 1.8 1.8 1.9 2.0 2.0 1.8 1.5 1.4 1.2 1.1 1.1 1.0 0.8 0.8 0.8 0.8 0.9 0.7
subSaharanAfrica SSA InterestPaymentsOnExternalDebt 1.4 1.6 1.5 1.8 1.7 1.5 1.2 1.7 1.7 1.7 1.4 1.5 1.5 1.4 1.2 1.1 0.8 0.7 1.4 0.7 0.7 0.6 0.5 0.4 0.4 0.5 0.5
upperMiddleIncome UMC InterestPaymentsOnExternalDebt 2.7 2.8 2.1 1.8 1.8 1.7 1.5 1.5 1.8 1.7 1.8 1.9 2.1 2.0 1.8 1.5 1.4 1.2 1.1 1.1 1.0 0.9 0.8 0.9 0.9 0.9 0.6
<!DOCTYPE html>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Divergent Paths</title>
<script type="text/javascript" src="http://d3js.org/d3.v3.js"></script>
<style type="text/css">
body {
background-color: white;
font-family: Helvetica, Arial, sans-serif;
}
h1 {
font-size: 24px;
margin: 0;
}
h2 {
font-size: 10px;
font-weight: normal;
margin: 0;
}
p {
font-size: 14px;
margin: 10px 0 0 0;
}
svg {
background-color: lavenderBlush;
}
#textBlock {
padding:1px 30px 8px 10px;
margin: 1px 6px 0px 6px;
position: absolute;
left: 300px;
top: 95px;
width: 250px;
border: 1px solid green;
background-color: #F781BE;
z-index: 30;
/*visibility: hidden;*/
}
#innerTextBlock{
margin-left: 0px;
margin-top: 24px;
width: 592px;
padding: 0px 15px 9px 15px;
border: 1px dotted darkkhaki;
background-color: oldlace;
}
.title{
position: absolute;
left: 5px;
top: 65px;
height: 20px;
line-height: 100%;
font-size: 8px;
font-weight: normal;
color: #FFFFFF;
margin: 34px 0 10px 98px;
width: 855px;
}
circle:hover {
fill: orange;
}
path {
stroke: gray;
stroke-width: 0.5;
}
g.highlight path {
stroke: red;
stroke-width: 2;
}
.axis path,
.axis line {
fill: none;
stroke: gray;
stroke-width: 1;
shape-rendering: crispEdges;
}
.axis text {
font-family: sans-serif;
font-size: 11px;
}
</style>
</head>
<body>
<h1>World Bank Debt Statistics by Region (1987-2013)</h1>
<p>Regional Debt Divergency. Debt as a percentage of Gross National Income (GNI) between 1987 and 2013.</p>
<p> Source: <a href="http://data.worldbank.org/indicator/DT.DOD.DECT.GN.ZS"</a>World Bank 2014</p>
<div id="textBlock">
<h2> This chart assesses the relative merits of two regions ("Europe & Central Asia" and "East Asia & Pacific"), and compares their relative performance on the basis of their debt expressed as a percentage their gross national income from 1987 through to 2013. Whereas both regions started from relatively similar base points in 1987, the performance of Europe & Central Asia has been more erratic, culminating in an overall increase in debt. In comparison the East Asia & Pacific region has managed to progressively reduce its debt over the same period relative to its gross national income. </h2>
<script type="text/javascript">
//Dimensions and padding
var w = 700;
var h = 600;
var padding = [ 20, 10, 50, 100 ]; //Top, right, bottom, left
//Set up date formatting and years
var dateFormat = d3.time.format("%Y");
//Set up scales
var xScale = d3.time.scale()
.range([ padding[3], w - padding[1] - padding[3] ]);
var yScale = d3.scale.linear()
.range([ padding[0], h - padding[2] ]);
//Configure axis generators
var xAxis = d3.svg.axis()
.scale(xScale)
.orient("bottom")
.ticks(12)
.tickFormat(function(d) {
return dateFormat(d);
});
var yAxis = d3.svg.axis()
.scale(yScale)
.orient("left");
//Configure line generator
var line = d3.svg.line()
.x(function(d) {
return xScale(dateFormat.parse(d.year));
})
.y(function(d) {
return yScale(+d.amount);
});
//Create the empty SVG image
var svg = d3.select("body")
.append("svg")
.attr("width", w)
.attr("height", h);
//Load USA data
d3.csv("countryDebt.csv", function(data) {
//Data is loaded in, but we need to restructure it.
//Remember, each line requires an array of x/y pairs;
//that is, an array of arrays, like so:
//
// [ [x: 1, y: 1], [x: 2, y: 2], [x: 3, y: 3] ]
//
//We, however, are using 'year' as x and 'amount' as y.
//We also need to know which country belongs to each
//line, so we will build an array of objects that is
//structured like this:
/*
[
{
country: "Australia",
emissions: [
{ year: 1961, amount: 90589.568 },
{ year: 1962, amount: 94912.961 },
{ year: 1963, amount: 101029.517 },
]
},
{
country: "Bermuda",
emissions: [
{ year: 1961, amount: 176.016 },
{ year: 1962, amount: 157.681 },
{ year: 1963, amount: 150.347 },
]
},
]
*/
//Note that this is an array of objects. Each object
//contains two values, 'country' and 'emissions'.
//The 'emissions' value is itself an array, containing
//more objects, each one holding 'year' and 'amount' values.
//New array with all the years, for referencing later
var years = ["1987", "1988", "1989", "1990", "1991", "1992", "1993", "1994", "1995", "1996", "1997", "1998", "1999", "2000", "2001", "2002", "2003", "2004", "2005", "2006", "2007", "2008", "2009", "2010", "2011", "2012","2013"];
//Create a new, empty array to hold our restructured dataset
var dataset = [];
//Loop once for each row in data
for (var i = 0; i < data.length; i++) {
//Create new object with this country's name and empty array
dataset[i] = {
country: data[i].CountryName,
interestPaymentsOnExternalDebt: []
};
//Loop through all the years
for (var j = 0; j < years.length; j++) {
// If value is not empty
if (data[i][years[j]]) {
//Add a new object to the emissions data array
//for this country
dataset[i].interestPaymentsOnExternalDebt.push({
year: years[j],
amount: data[i][years[j]]
});
}
}
}
//Uncomment to log the original data to the console
console.log(data);
//Uncomment to log the newly restructured dataset to the console
console.log(dataset);
//Set scale domains
xScale.domain([
d3.min(years, function(d) {
return dateFormat.parse(d);
}),
d3.max(years, function(d) {
return dateFormat.parse(d);
})
]);
yScale.domain([
d3.max(dataset, function(d) {
return d3.max(d.interestPaymentsOnExternalDebt, function(d) {
return +d.amount;
});
}),
0
]);
//Make a group for each country
var groups = svg.selectAll("g")
.data(dataset)
.enter()
.append("g")
.classed("highlight", function(d) {
if (d.country == "eastAsia&Pacific" ||
d.country == "europe&CentralAsia"){
return true;
} else {
return false;
}
});
//Append a title with the country name (so we get easy tooltips)
groups.append("title")
.text(function(d) {
return d.country;
});
//Within each group, create a new line/path,
//binding just the emissions data to each one
groups.selectAll("path")
.data(function(d) {
return [ d.interestPaymentsOnExternalDebt];
})
.enter()
.append("path")
.attr("class", "line")
.attr("d", line)
.attr("fill", "none")
.attr("stroke-width", 2);
//Axes
svg.append("g")
.attr("class", "x axis")
.attr("transform", "translate(0," + (h - padding[2]) + ")")
.call(xAxis);
svg.append("g")
.attr("class", "y axis")
.attr("transform", "translate(" + (padding[3]) + ",0)")
.call(yAxis);
svg.append("text")
.attr("class", "label")
.attr("y",(h-padding[2]/2))
.attr("x", w/2)
.attr("dy", "1em")
.style("text-anchor", "middle")
.text("Year");
svg.append("text")
.attr("class", "label")
.attr("transform", "rotate(-90)")
.attr("y",padding[3]-60)
.attr("x",0-(h/2))
.attr("dy", "1em")
.style("text-anchor", "middle")
.text("percentage of GNI % ");
});
//End USA data load function
</script>
</body>
</html>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment