|
<!DOCTYPE html> |
|
<meta charset="utf-8"> |
|
<style> /* set the CSS */ |
|
|
|
body { font: 12px Arial;} |
|
|
|
path { |
|
stroke: steelblue; |
|
stroke-width: 2; |
|
fill: none; |
|
} |
|
|
|
.axis path, |
|
.axis line { |
|
fill: none; |
|
stroke: grey; |
|
stroke-width: 1; |
|
shape-rendering: crispEdges; |
|
} |
|
|
|
td, th { |
|
padding: 1px 4px; |
|
border: 1px black solid; |
|
} |
|
|
|
</style> |
|
<body> |
|
|
|
<!-- load the d3.js library --> |
|
<script src="https://cdnjs.cloudflare.com/ajax/libs/d3/3.5.17/d3.min.js"></script> |
|
|
|
<script> |
|
|
|
// Set the dimensions of the canvas / graph |
|
var margin = {top: 30, right: 20, bottom: 30, left: 50}, |
|
width = 600 - margin.left - margin.right, |
|
height = 270 - margin.top - margin.bottom; |
|
|
|
// Parse the date / time |
|
var parseDate = d3.time.format("%d-%b-%y").parse; |
|
|
|
// Set the ranges |
|
var x = d3.time.scale().range([0, width]); |
|
var y = d3.scale.linear().range([height, 0]); |
|
|
|
// Define the axes |
|
var xAxis = d3.svg.axis().scale(x) |
|
.orient("bottom").ticks(5); |
|
|
|
var yAxis = d3.svg.axis().scale(y) |
|
.orient("left").ticks(5); |
|
|
|
// Define the line |
|
var valueline = d3.svg.line() |
|
.x(function(d) { return x(d.date1); }) |
|
.y(function(d) { return y(d.close); }); |
|
|
|
// Adds the svg canvas |
|
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) { |
|
data.forEach(function(d) { |
|
d.date1 = parseDate(d.date); // <= Change to date1 |
|
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; }));//<=date1 |
|
y.domain([0, d3.max(data, function(d) { return d.close; })]); |
|
|
|
// Add the valueline path. |
|
svg.append("path") |
|
.attr("class", "line") |
|
.attr("d", valueline(data)); |
|
|
|
// Add the X Axis |
|
svg.append("g") |
|
.attr("class", "x axis") |
|
.attr("transform", "translate(0," + height + ")") |
|
.call(xAxis); |
|
|
|
// Add the Y Axis |
|
svg.append("g") |
|
.attr("class", "y axis") |
|
.call(yAxis); |
|
|
|
// The table generation function |
|
function tabulate(data, columns) { |
|
var table = d3.select("body").append("table") |
|
.attr("style", "margin-left: 200px") |
|
.style("border-collapse", "collapse")// <= Add this line in |
|
.style("border", "2px black solid"), // <= Add this line in |
|
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> |
