Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Embedding csv in HTML for use with D3.js

Tags:

dom

csv

d3.js

In D3.js, one usually loads data from an external csv file. This is very efficient for large data, and avoids changing the code when the data changes.

However, there are two situations (only using small csv data) where I want to embed csv directly in an HTML page:

  • A page that can be loaded locally (i.e. from file:///), without requiring to run a local HTTP server.
  • A small jsfiddle example explaining a D3.js question for use on stackoverflow.
like image 334
ValarDohaeris Avatar asked Apr 26 '13 07:04

ValarDohaeris


1 Answers

This is the solution I have come up with, using the example from the D3.js API.

Embedding the csv data:

<pre id="csvdata">
    Year,Make,Model,Length
    1997,Ford,E350,2.34
    2000,Mercury,Cougar,2.38
</pre>

Hidding the raw data on the page:

#csvdata {
    display: none;
}

Parsing it:

var raw = d3.select("#csvdata").text();
var parsed = d3.csv.parse(raw);

Optionally, show the result:

d3.select("#parsed").text(JSON.stringify(parsed));
// Assuming <div id="parsed"></div> somewhere on the page

If think this is flawed, or if you have a more elegant solution, I will gladly accept your answer!

EDIT: see it in action in this fiddle

like image 83
ValarDohaeris Avatar answered Sep 21 '22 09:09

ValarDohaeris