A visualization of the mean nutrient contents of all 8789 foods in USDA’s SR28 Nutrient Database.
Data processed with SQLite and Node.js.
Also see the Nutrient Explorer.
<!DOCTYPE html>
<meta charset="utf-8">
<title>Nutrient Parallel Coordinates II</title>
<body>
<script src="https://cdnjs.cloudflare.com/ajax/libs/d3/3.5.5/d3.min.js"></script>
<script src="//bl.ocks.org/syntagmatic/raw/3341641/render-queue.js"></script>
<link rel="stylesheet" href="style.css"></link>
<script>
var margin = {top: 66, right: 110, bottom: 20, left: 188},
width = document.body.clientWidth - margin.left - margin.right,
height = 340 - margin.top - margin.bottom,
innerHeight = height - 2;
var devicePixelRatio = window.devicePixelRatio || 1;
var color = d3.scale.ordinal()
.range(["#5DA5B3","#D58323","#DD6CA7","#54AF52","#8C92E8","#E15E5A","#725D82","#776327","#50AB84","#954D56","#AB9C27","#517C3F","#9D5130","#357468","#5E9ACF","#C47DCB","#7D9E33","#DB7F85","#BA89AD","#4C6C86","#B59248","#D8597D","#944F7E","#D67D4B","#8F86C2"]);
var types = {
"Number": {
key: "Number",
coerce: function(d) { return +d; },
extent: d3.extent,
within: function(d, extent) { return extent[0] <= d && d <= extent[1]; },
defaultScale: d3.scale.linear().range([innerHeight, 0])
},
"String": {
key: "String",
coerce: String,
extent: function (data) { return data.sort(); },
within: function(d, extent, dim) { return extent[0] <= dim.scale(d) && dim.scale(d) <= extent[1]; },
defaultScale: d3.scale.ordinal().rangePoints([0, innerHeight])
},
"Date": {
key: "Date",
coerce: function(d) { return new Date(d); },
extent: d3.extent,
within: function(d, extent) { return extent[0] <= d && d <= extent[1]; },
defaultScale: d3.time.scale().range([0, innerHeight])
}
};
var dimensions = [
{
key: "food_group",
description: "Food Group",
type: types["String"],
axis: d3.svg.axis().orient("left")
.tickFormat(function(d,i) {
return d;
})
},
{
key: "Total lipid (fat) (g)",
type: types["Number"],
scale: d3.scale.sqrt().range([innerHeight, 0])
},
{
key: "Sugars, total (g)",
type: types["Number"],
scale: d3.scale.sqrt().range([innerHeight, 0])
},
{
key: "Calcium, Ca (mg)",
type: types["Number"],
scale: d3.scale.sqrt().range([innerHeight, 0])
},
{
key: "Sodium, Na (mg)",
type: types["Number"],
scale: d3.scale.sqrt().range([innerHeight, 0])
},
{
key: "Phosphorus, P (mg)",
type: types["Number"],
scale: d3.scale.sqrt().range([innerHeight, 0])
},
{
key: "Potassium, K (mg)",
type: types["Number"],
scale: d3.scale.sqrt().range([innerHeight, 0])
},
{
key: "Thiamin (mg)",
type: types["Number"],
scale: d3.scale.sqrt().range([innerHeight, 0])
},
{
key: "Riboflavin (mg)",
type: types["Number"],
scale: d3.scale.sqrt().range([innerHeight, 0])
},
{
key: "Niacin (mg)",
type: types["Number"],
scale: d3.scale.sqrt().range([innerHeight, 0])
},
{
key: "Iron, Fe (mg)",
type: types["Number"],
scale: d3.scale.sqrt().range([innerHeight, 0])
},
{
key: "Magnesium, Mg (mg)",
type: types["Number"],
scale: d3.scale.sqrt().range([innerHeight, 0])
},
{
key: "Protein (g)",
type: types["Number"],
scale: d3.scale.sqrt().range([innerHeight, 0])
},
{
key: "Zinc, Zn (mg)",
type: types["Number"],
scale: d3.scale.sqrt().range([innerHeight, 0])
},
{
key: "Vitamin B-6 (mg)",
type: types["Number"],
scale: d3.scale.sqrt().range([innerHeight, 0])
},
{
key: "Vitamin B-12 (mcg)",
type: types["Number"],
scale: d3.scale.sqrt().range([innerHeight, 0])
},
{
key: "Folic acid (mcg)",
type: types["Number"],
scale: d3.scale.sqrt().range([innerHeight, 0])
},
{
key: "Selenium, Se (mcg)",
type: types["Number"],
scale: d3.scale.sqrt().range([innerHeight, 0])
},
{
key: "Vitamin A, IU (IU)",
type: types["Number"],
scale: d3.scale.sqrt().range([innerHeight, 0])
},
{
key: "Vitamin K (phylloquinone) (mcg)",
type: types["Number"],
scale: d3.scale.sqrt().range([innerHeight, 0])
},
{
key: "Vitamin C, total ascorbic acid (mg)",
type: types["Number"],
scale: d3.scale.sqrt().range([innerHeight, 0])
},
{
key: "Vitamin D (IU)",
type: types["Number"],
scale: d3.scale.sqrt().range([innerHeight, 0])
},
{
key: "Cholesterol (mg)",
type: types["Number"],
scale: d3.scale.sqrt().range([innerHeight, 0])
},
{
key: "Fiber, total dietary (g)",
type: types["Number"],
scale: d3.scale.sqrt().range([innerHeight, 0])
},
{
key: "Carbohydrate, by difference (g)",
type: types["Number"],
scale: d3.scale.sqrt().range([innerHeight, 0])
},
{
key: "manufac_name",
description: "Manufacturer",
type: types["String"],
axis: d3.svg.axis().orient("right")
.tickFormat(function(d,i) {
if (d == null) return "(null)";
return i % 5 == 0 ? d.slice(0,22) : "";
})
}
];
var xscale = d3.scale.ordinal()
.domain(d3.range(dimensions.length))
.rangePoints([0, width]);
var yAxis = d3.svg.axis()
.orient("left");
var container = d3.select("body").append("div")
.attr("class", "parcoords")
.style("width", width + margin.left + margin.right + "px")
.style("height", height + margin.top + margin.bottom + "px");
var svg = container.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 + ")");
var canvas = container.append("canvas")
.attr("width", width * devicePixelRatio)
.attr("height", height * devicePixelRatio)
.style("width", width + "px")
.style("height", height + "px")
.style("margin-top", margin.top + "px")
.style("margin-left", margin.left + "px");
var ctx = canvas.node().getContext("2d");
ctx.globalCompositeOperation = 'darken';
ctx.globalAlpha = 0.15;
ctx.lineWidth = 1.5;
ctx.scale(devicePixelRatio, devicePixelRatio);
var output = d3.select("body").append("pre");
var axes = svg.selectAll(".axis")
.data(dimensions)
.enter().append("g")
.attr("class", function(d) { return "axis " + d.key.replace(/ /g, "_"); })
.attr("transform", function(d,i) { return "translate(" + xscale(i) + ")"; });
d3.csv("nutrient.csv", function(error, data) {
if (error) throw error;
// shuffle the data!
data = d3.shuffle(data);
data.forEach(function(d) {
dimensions.forEach(function(p) {
d[p.key] = !d[p.key] ? null : p.type.coerce(d[p.key]);
});
// truncate long text strings to fit in data table
for (var key in d) {
if (d[key] && d[key].length > 35) d[key] = d[key].slice(0,36);
}
});
// type/dimension default setting happens here
dimensions.forEach(function(dim) {
if (!("domain" in dim)) {
// detect domain using dimension type's extent function
dim.domain = d3.functor(dim.type.extent)(data.map(function(d) { return d[dim.key]; }));
}
if (!("scale" in dim)) {
// use type's default scale for dimension
dim.scale = dim.type.defaultScale.copy();
}
dim.scale.domain(dim.domain);
});
var render = renderQueue(draw).rate(30);
ctx.clearRect(0,0,width,height);
ctx.globalAlpha = d3.min([0.85/Math.pow(data.length,0.3),1]);
render(data);
axes.append("g")
.each(function(d) {
var renderAxis = "axis" in d
? d.axis.scale(d.scale) // custom axis
: yAxis.scale(d.scale); // default axis
d3.select(this).call(renderAxis);
})
.append("text")
.attr("class", "title")
.attr("text-anchor", "start")
.text(function(d) { return "description" in d ? d.description : d.key; });
// Add and store a brush for each axis.
axes.append("g")
.attr("class", "brush")
.each(function(d) {
d3.select(this).call(d.brush = d3.svg.brush()
.y(d.scale)
.on("brushstart", brushstart)
.on("brush", brush));
})
.selectAll("rect")
.attr("x", -8)
.attr("width", 16);
d3.selectAll(".axis.food_group .tick text")
.style("fill", color);
output.text(d3.tsv.format(data.slice(0,24)));
function project(d) {
return dimensions.map(function(p,i) {
// check if data element has property and contains a value
if (
!(p.key in d) ||
d[p.key] === null
) return null;
return [xscale(i),p.scale(d[p.key])];
});
};
function draw(d) {
ctx.strokeStyle = color(d.food_group);
ctx.beginPath();
var coords = project(d);
coords.forEach(function(p,i) {
// this tricky bit avoids rendering null values as 0
if (p === null) {
// this bit renders horizontal lines on the previous/next
// dimensions, so that sandwiched null values are visible
if (i > 0) {
var prev = coords[i-1];
if (prev !== null) {
ctx.moveTo(prev[0],prev[1]);
ctx.lineTo(prev[0]+6,prev[1]);
}
}
if (i < coords.length-1) {
var next = coords[i+1];
if (next !== null) {
ctx.moveTo(next[0]-6,next[1]);
}
}
return;
}
if (i == 0) {
ctx.moveTo(p[0],p[1]);
return;
}
ctx.lineTo(p[0],p[1]);
});
ctx.stroke();
}
function brushstart() {
d3.event.sourceEvent.stopPropagation();
}
// Handles a brush event, toggling the display of foreground lines.
function brush() {
var actives = dimensions.filter(function(p) { return !p.brush.empty(); }),
extents = actives.map(function(p) { return p.brush.extent(); });
var selected = data.filter(function(d) {
if (actives.every(function(dim, i) {
// test if point is within extents for each active brush
return dim.type.within(d[dim.key], extents[i], dim);
})) {
return true;
}
});
// show ticks for active brush dimensions
// and filter ticks to only those within brush extents
svg.selectAll(".axis")
.filter(function(d) {
return actives.indexOf(d) > -1 ? true : false;
})
.classed("active", true)
.each(function(dimension, i) {
var extent = extents[i];
d3.select(this)
.selectAll(".tick text")
.style("display", function(d) {
var value = dimension.type.coerce(d);
return dimension.type.within(value, extent, dimension) ? null : "none";
});
});
// reset dimensions without active brushes
svg.selectAll(".axis")
.filter(function(d) {
return actives.indexOf(d) > -1 ? false : true;
})
.classed("active", false)
.selectAll(".tick text")
.style("display", null);
ctx.clearRect(0,0,width,height);
ctx.globalAlpha = d3.min([0.85/Math.pow(selected.length,0.3),1]);
render(selected);
output.text(d3.tsv.format(selected.slice(0,24)));
}
});
</script>
body {
min-width: 760px;
}
.parcoords {
display: block;
}
.parcoords svg,
.parcoords canvas {
font: 10px sans-serif;
position: absolute;
}
.parcoords canvas {
opacity: 0.9;
pointer-events: none;
}
.axis .title {
font-size: 10px;
transform: rotate(-21deg) translate(-5px,-6px);
fill: #222;
}
.axis line,
.axis path {
fill: none;
stroke: #ccc;
stroke-width: 1px;
}
.axis .tick text {
fill: #222;
opacity: 0;
pointer-events: none;
}
.axis.manufac_name .tick text,
.axis.food_group .tick text {
opacity: 1;
}
.axis:hover line,
.axis:hover path,
.axis.active line,
.axis.active path {
fill: none;
stroke: #222;
stroke-width: 1px;
}
.axis:hover .title {
font-weight: bold;
}
.axis:hover .tick text {
opacity: 1;
}
.axis.active .title {
font-weight: bold;
}
.axis.active .tick text {
opacity: 1;
font-weight: bold;
}
.brush .extent {
fill-opacity: .3;
stroke: #fff;
stroke-width: 1px;
}
pre {
width: 100%;
height: 300px;
margin: 6px 12px;
tab-size: 40;
font-size: 10px;
overflow: auto;
}