|
<!DOCTYPE html> |
|
<meta charset="utf-8"> |
|
<style> /* set the CSS */ |
|
|
|
.line { |
|
fill: none; |
|
stroke: steelblue; |
|
stroke-width: 2px; |
|
} |
|
|
|
td, th { |
|
padding: 1px 4px; |
|
border: 1px black solid; |
|
} |
|
|
|
</style> |
|
<body> |
|
|
|
<!-- load the d3.js library --> |
|
<script src="https://d3js.org/d3.v4.min.js"></script> |
|
<script> |
|
|
|
// set the dimensions and margins of the graph |
|
var margin = {top: 20, right: 20, bottom: 30, left: 50}, |
|
width = 960 - margin.left - margin.right, |
|
height = 500 - margin.top - margin.bottom; |
|
|
|
// parse the date / time |
|
var parseTime = d3.timeParse("%d-%b-%y"); |
|
|
|
// set the ranges |
|
var x = d3.scaleTime().range([0, width]); |
|
var y = d3.scaleLinear().range([height, 0]); |
|
|
|
// define the line |
|
var valueline = d3.line() |
|
.x(function(d) { return x(d.date1); }) |
|
.y(function(d) { return y(d.close); }); |
|
|
|
// append the svg obgect to the body of the page |
|
// appends a 'group' element to 'svg' |
|
// moves the 'group' element to the top left margin |
|
var svg = d3.select("body").append("svg") |
|
.attr("width", width + margin.left + margin.right) |
|
.attr("height", height + margin.top + margin.bottom) |
|
.append("g") |
|
.attr("transform", |
|
"translate(" + margin.left + "," + margin.top + ")"); |
|
|
|
// Get the data |
|
d3.csv("data2.csv", function(error, data) { |
|
if (error) throw error; |
|
|
|
// format the data |
|
data.forEach(function(d) { |
|
d.date1 = parseTime(d.date); |
|
d.close = +d.close; |
|
d.open = +d.open; // <= added this for tidy house keeping |
|
d.diff = Math.round(( d.close - d.open ) * 100 ) / 100; |
|
}); |
|
|
|
// Scale the range of the data |
|
x.domain(d3.extent(data, function(d) { return d.date1; })); |
|
y.domain([0, d3.max(data, function(d) { return d.close; })]); |
|
|
|
// Add the valueline path. |
|
svg.append("path") |
|
.data([data]) |
|
.attr("class", "line") |
|
.attr("d", valueline); |
|
|
|
// Add the X Axis |
|
svg.append("g") |
|
.attr("transform", "translate(0," + height + ")") |
|
.call(d3.axisBottom(x)); |
|
|
|
// Add the Y Axis |
|
svg.append("g") |
|
.call(d3.axisLeft(y)); |
|
|
|
// The table generation function |
|
function tabulate(data, columns) { |
|
var table = d3.select("body").append("table") |
|
.attr("style", "margin-left: 360px") |
|
.style("border-collapse", "collapse") |
|
.style("border", "2px black solid"), |
|
thead = table.append("thead"), |
|
tbody = table.append("tbody"); |
|
|
|
// append the header row |
|
thead.append("tr") |
|
.selectAll("th") |
|
.data(columns) |
|
.enter() |
|
.append("th") |
|
.text(function(column) { return column; }); |
|
|
|
// create a row for each object in the data |
|
var rows = tbody.selectAll("tr") |
|
.data(data) |
|
.enter() |
|
.append("tr"); |
|
|
|
// create a cell in each row for each column |
|
var cells = rows.selectAll("td") |
|
.data(function(row) { |
|
return columns.map(function(column) { |
|
return {column: column, value: row[column]}; |
|
}); |
|
}) |
|
.enter() |
|
.append("td") |
|
.attr("style", "font-family: Courier") // sets the font style |
|
.html(function(d) { return d.value; }); |
|
|
|
return table; |
|
} |
|
|
|
// render the table |
|
var peopleTable = tabulate(data, ["date", "close", "open", "diff"]); |
|
|
|
peopleTable.selectAll("tbody tr") |
|
.sort(function(a, b) { |
|
return d3.descending(a.close, b.close); |
|
}); |
|
|
|
peopleTable.selectAll("thead th") |
|
.text(function(column) { |
|
return column.charAt(0).toUpperCase() + column.substr(1); |
|
}); |
|
|
|
}); |
|
|
|
</script> |
|
</body> |