var svg = d3.select("svg") /* sample row (u(integer) stands for unused field) num,date,time,bsl,id,u1,u2,u3,u4,....,u12 "165", "02/02/2016", "08:26:20", "15.76" food hints: */ d3.csv("sugars.csv", function(error, data) { if (error) throw error; data = csv_preprocessor(data) draw_graph(data); }); function csv_preprocessor(data){ // "02/02/2016/08:26:20" var format = d3.time.format("%m/%d/%Y/%H:%M:%S"); // reduce down to : UNIXTIME / BSL data.forEach(function(d) { var unix_str = d.date + "/" + d.time var date_stamp = format.parse(unix_str) d.unix = d3.time.hour.offset(date_stamp, 1); // gmt to dutch d.bsl = +d.bsl }); return data } function draw_graph(data){ var margin = {top: 20, right: 80, bottom: 30, left: 50}, width = 960 - margin.left - margin.right, height = 500 - margin.top - margin.bottom; var x = d3.time.scale() .range([0, width]); var y = d3.scale.linear() .range([height, 0]); var xAxis = d3.svg.axis() .scale(x) .ticks(d3.time.days, 1) .orient("bottom"); var yAxis = d3.svg.axis() .scale(y) .orient("left"); function adjust_date(date, add){ return d3.time.day.offset(date, add) } var first_day = adjust_date(data[data.length - 1].unix, -1) var last_day = adjust_date(data[0].unix, 1) x.domain([first_day, last_day]); y.domain(d3.extent(data, function(d) { return d.bsl; })); svg .attr("width", width + margin.left + margin.right) .attr("height", height + margin.top + margin.bottom); var g1 = svg.append("g") .attr("transform", "translate(" + margin.left + "," + margin.top + ")"); g1.append("g") .attr("class", "x axis") .attr("transform", "translate(0," + height + ")") .call(xAxis); g1.append("g") .attr("class", "y axis") .call(yAxis) .append("text") .attr("transform", "rotate(-90)") .attr("y", 6) .attr("dy", ".71em") .style("text-anchor", "end") .text("Glucose"); var circle = g1.selectAll('circle').data(data); var circleEnter = circle.enter().append('circle'); circleEnter.attr("cx", function(d, i){return x(d.unix);}) circleEnter.attr("cy", function(d, i){return y(d.bsl);}) circleEnter.attr("r", function(d, i) {return 3}) circleEnter.style({fill: "#002200"}) }