Skip to content

Instantly share code, notes, and snippets.

@trishsky

trishsky/export.csv

Created April 26, 2015 14:55
Show Gist options
  • Save trishsky/f02b1c3dc4fe5c09e710 to your computer and use it in GitHub Desktop.
Save trishsky/f02b1c3dc4fe5c09e710 to your computer and use it in GitHub Desktop.
Download ZIP
Final Project
Raw
export.csv
country indicatorName 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013
Brunei Darussalam export 61.81 66.68 57.87 54.76 51.08 59.72 59.93 57.19 50.47 55.82 67.35 69.53 67.12 69.29 68.8 70.17 71.72 67.85 78.3 72.78 81.44 79.66 81.37 76.16
Cambodia export 16.06 25.79 31.18 25.36 33.62 31.24 40.54 49.85 52.6 55.42 56.52 63.61 64.08 68.59 65.33 65.54 49.22 54.08 54.08 62.79 65.72
China export 14.7 16.1 16.14 14.11 21.27 20.23 20.05 21.75 20.35 20.4 23.33 22.6 25.13 29.56 34.08 37.08 39.13 38.41 35 26.72 29.4 28.54 27.32 26.41
Indonesia export 25.33 25.8 27.89 26.75 26.51 26.31 25.82 27.86 52.97 35.51 40.98 39.03 32.69 30.48 32.22 34.07 31.03 29.44 29.81 24.16 24.58 26.36 24.29 23.74
Timor Leste export 9.78 9.07 8.78 7.95 8.37 8.15 9.72 10.73 10.09 9.17 9.74 9.62 12.13 0
LaoPDR export 11.33 12.95 17.03 21.46 24.99 23.22 22.7 23.89 36.46 35.88 30.1 28.49 29.38 29.69 30.55 34.16 40.4 34.5 32.02 30.88 35.54 37.18 38.84 37.22
Malaysia export 74.47 77.83 75.98 78.92 89.15 94.09 91.58 93.29 115.74 121.31 119.81 110.4 108.31 106.94 115.37 112.9 112.19 106.17 99.5 91.42 93.32 91.52 85.25 81.68
Myanmar export 1.94 1.57 1.44 1.17 1.14 0.83 0.69 0.58 0.42 0.32 0.49 0.46 0.35 0.18 0.18
Philippines export 27.52 29.6 29.13 31.36 33.83 36.36 40.51 48.96 44.76 45.49 51.37 46.03 46.75 47.16 48.57 46.14 46.58 43.26 36.91 32.23 34.8 32.03 30.78 27.91
Singapore export 177.15 168.52 161.64 161.54 166 181.22 176.07 169.91 167.59 177.19 189.18 184.48 185.96 205.16 216.34 226.08 230.1 214.74 230.27 191.88 199.26 200.19 195.08 190.52
Thailand export 34.13 35.96 36.97 37.96 38.87 41.84 39.25 48.01 58.88 58.3 66.78 65.86 64.19 65.68 70.7 73.57 73.65 73.42 76.44 68.35 71.29 76.94 74.98 73.57
Vietnam export 36.04 30.92 34.75 28.72 34.01 32.81 40.87 43.1 44.85 49.97 49.97 51 50.58 52.47 54.9 63.7 67.72 70.52 70.34 62.97 72 79.39 80.03 83.88
Raw
index.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Module 6</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;
}
p {
font-size: 14px;
margin: 10px 0 0 0;
}
svg {
background-color: white;
}
circle:hover {
fill: yellow;
}
path {
fill: gray;
stroke: none;
opacity: 0.1;
}
g.highlight path {
fill: yellow;
opacity: 0.4;
}
.axis path,
.axis line {
fill: none;
stroke: black;
stroke-width: 1;
opacity: 1;
shape-rendering: crispEdges;
}
.axis text {
font-family: sans-serif;
font-size: 11px;
}
</style>
</head>
<body>
<h1>Export per GDP by Country: China and Southeast Asia Counties</h1>
<p>Exports of goods and services represent the value of all goods and other market services provided to the rest of the world. They include the value of merchandise, freight, insurance, transport, travel, royalties, license fees, and other services, such as communication, construction, financial, information, business, personal, and government services. They exclude compensation of employees and investment income (formerly called factor services) and transfer payments. Data not available for the entire period for all countries. Source: <a href="hhttp://databank.worldbank.org/data/">World Bank</a>, 2015</p>
<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(15)
.tickFormat(function(d) {
return dateFormat(d);
});
var yAxis = d3.svg.axis()
.scale(yScale)
.orient("left");
//Configure area generator
var area = d3.svg.area()
.x(function(d) {
return xScale(dateFormat.parse(d.year));
})
.y0(h - padding[2])
.y1(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 data
d3.csv("export.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",
indicatorName: [
{ year: 1961, amount: 90589.568 },
{ year: 1962, amount: 94912.961 },
{ year: 1963, amount: 101029.517 },
…
]
},
{
country: "Bermuda",
indicatorName: [
{ 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 'indicatorName'.
//The 'indicatorName' 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 = ["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].country,
indicatorName: []
};
//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 indicatorName data array
//for this country
dataset[i].indicatorName.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.indicatorName, 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 == "China") {
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 indicatorName data to each one
groups.selectAll("path")
.data(function(d) {
return [ d.indicatorName ];
})
.enter()
.append("path")
.attr("class", "area")
.attr("d", area);
//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);
});
//End data load function
</script>
</body>
</html>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment