Created
May 7, 2015 17:14
-
-
Save urdinblu/1696181fbfae24989f8e to your computer and use it in GitHub Desktop.
Exercise 6 - World Bank Regional Data - Debt as a % of GNI
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<!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