Published unlisted
Edited
May 11, 2022
Insert cell
# Fragility: Exemplified by the Global Wheat Supply Chain
Insert cell
Insert cell
mutable log = ""
Insert cell
chart = SankeyChart(
{
links: exports
},
{
nodeGroup: (d) => d.id.split(/\W/)[0], // take first word for color
nodeAlign: d3.sankeyJustify, // e.g., d3.sankeyJustify;
linkColor: "source-target", // e.g., "source" or "target";
format: ((f) => (d) => `${f(d)} kg`)(d3.format(",.1~f")),
width: 750,
height: 2500
}
)
Insert cell
[1] 2020 Wheat Exports data. UN Comtrade Database, accessed via the R package comtradr version 0.2.2. https://comtrade.un.org/data/doc/api/

[2] The yield of flour from wheat is about 70% to 75%.

[3] https://www.middleeastmonitor.com/20220301-egypt-may-raise-price-of-subsidised-bread/
[4] https://www.thenationalnews.com/mena/2021/08/13/why-ending-bread-subsidies-feels-like-an-existential-threat-to-egyptians/

[5] https://www.reuters.com/article/ukraine-crisis-food-mideast-idAFL8N2V31BU

[6] https://www.sciencedirect.com/science/article/abs/pii/S2211912420300547

Notes: Wheat exports mentioned in this figure refer to Harmonized System (HS) Code "1001 - Wheat and Meslin" only. This figure assumes that the sum of exports from Country A + Country B + Country C = imports of Country D. However, this dataset often has a discrepancy between the respective export values and import values, so only export values are used.
Insert cell
exports = FileAttachment("group_exports_concat_df5.csv").csv({
typed: true
})
Insert cell
exports.forEach((d) => {
d.target = d.target + " ";
// add a space character to the target node name to make it unique from the source of the same country.
})
Insert cell
highlight_target = (evt,d) => {
d3.select(chart).selectAll("path").style("opacity",0.28); // dim all
let thisElem = evt.currentTarget;
let thisElem_country = d.id;
mutable log = d;
d3.select(chart).selectAll("path").filter(d=>d.target.id == thisElem_country).style("opacity","")

if (d.x0 < 500) {
d3.select(chart).selectAll("path").filter(d=>d.source.id == thisElem_country).style("opacity","")
} else {
d3.select(chart).selectAll("path").filter(d=>d.target.id == thisElem_country).style("opacity","")
}

}
Insert cell
d3.select(chart).selectAll("rect")
Insert cell
{
if(chart) {
d3.select(chart).selectAll("rect").on("click", highlight_target);
//d3.select(chart).selectAll("rect").on("click", unhighlight_target);
}
}
Insert cell
Insert cell
// Copyright 2021 Observable, Inc.
// Released under the ISC license.
// https://observablehq.com/@d3/sankey-diagram
function SankeyChart(
{
nodes, // an iterable of node objects (typically [{id}, …]); implied by links if missing
links // an iterable of link objects (typically [{source, target}, …])
},
{
format = ",", // a function or format specifier for values in titles
align = "justify", // convenience shorthand for nodeAlign
nodeId = (d) => d.id, // given d in nodes, returns a unique identifier (string)
nodeGroup, // given d in nodes, returns an (ordinal) value for color
nodeGroups, // an array of ordinal values representing the node groups
nodeLabel, // given d in (computed) nodes, text to label the associated rect
nodeTitle = (d) => `${d.id}\n${format(d.value)}`, // given d in (computed) nodes, hover text
nodeAlign = align, // Sankey node alignment strategy: left, right, justify, center
nodeWidth = 15, // width of node rects
nodePadding = 10, // vertical separation between adjacent nodes
nodeLabelPadding = 6, // horizontal separation between node and label
nodeStroke = "currentColor", // stroke around node rects
nodeStrokeWidth, // width of stroke around node rects, in pixels
nodeStrokeOpacity, // opacity of stroke around node rects
nodeStrokeLinejoin, // line join for stroke around node rects
linkSource = ({ source }) => source, // given d in links, returns a node identifier string
linkTarget = ({ target }) => target, // given d in links, returns a node identifier string
linkValue = ({ value }) => value, // given d in links, returns the quantitative value
linkPath = d3Sankey.sankeyLinkHorizontal(), // given d in (computed) links, returns the SVG path
linkTitle = (d) => `${d.source.id} → ${d.target.id}\n${format(d.value)}`, // given d in (computed) links
linkColor = "source-target", // source, target, source-target, or static color
linkStrokeOpacity = 0.5, // link stroke opacity
linkMixBlendMode = "multiply", // link blending mode
//colors = d3.schemeTableau10, // array of colors
colors = ["#F5DEB3"], // array of colors
width = 6000, // outer width, in pixels
height = 1000, // outer height, in pixels
marginTop = 5, // top margin, in pixels
marginRight = 1, // right margin, in pixels
marginBottom = 5, // bottom margin, in pixels
marginLeft = 1 // left margin, in pixels
} = {}
) {
// Convert nodeAlign from a name to a function (since d3-sankey is not part of core d3).
if (typeof nodeAlign !== "function")
nodeAlign =
{
left: d3Sankey.sankeyLeft,
right: d3Sankey.sankeyRight,
center: d3Sankey.sankeyCenter
}[nodeAlign] ?? d3Sankey.sankeyJustify;

// Compute values.
const LS = d3.map(links, linkSource).map(intern);
const LT = d3.map(links, linkTarget).map(intern);
const LV = d3.map(links, linkValue);
if (nodes === undefined)
nodes = Array.from(d3.union(LS, LT), (id) => ({ id }));
const N = d3.map(nodes, nodeId).map(intern);
const G = nodeGroup == null ? null : d3.map(nodes, nodeGroup).map(intern);

// Replace the input nodes and links with mutable objects for the simulation.
nodes = d3.map(nodes, (_, i) => ({ id: N[i] }));
links = d3.map(links, (_, i) => ({
source: LS[i],
target: LT[i],
value: LV[i]
}));

// Ignore a group-based linkColor option if no groups are specified.
if (!G && ["source", "target", "source-target"].includes(linkColor))
linkColor = "currentColor";

// Compute default domains.
if (G && nodeGroups === undefined) nodeGroups = G;

// Construct the scales.
const color = nodeGroup == null ? null : d3.scaleOrdinal(nodeGroups, colors);

// Compute the Sankey layout.
d3Sankey
.sankey()
.iterations(0)
.nodeSort((a, b) => d3.descending(a.value, b.value))
.nodeId(({ index: i }) => N[i])
.nodeAlign(nodeAlign)
.nodeWidth(nodeWidth)
.nodePadding(nodePadding)
.extent([
[marginLeft, marginTop],
[width - marginRight, height - marginBottom]
])({ nodes, links });

// Compute titles and labels using layout nodes, so as to access aggregate values.
if (typeof format !== "function") format = d3.format(format);
const Tl =
nodeLabel === undefined
? N
: nodeLabel == null
? null
: d3.map(nodes, nodeLabel);
const Tt = nodeTitle == null ? null : d3.map(nodes, nodeTitle);
const Lt = linkTitle == null ? null : d3.map(links, linkTitle);

// A unique identifier for clip paths (to avoid conflicts).
const uid = `O-${Math.random().toString(16).slice(2)}`;

const svg = d3
.create("svg")
.attr("width", width)
.attr("height", height)
.attr("viewBox", [0, 0, width, height])
.attr("style", "max-width: 100%; height: auto; height: intrinsic;");

const node = svg
.append("g")
.attr("stroke", nodeStroke)
.attr("stroke-width", nodeStrokeWidth)
.attr("stroke-opacity", nodeStrokeOpacity)
.attr("stroke-linejoin", nodeStrokeLinejoin)
.selectAll("rect")
.data(nodes)
.join("rect")
.attr("x", (d) => d.x0)
.attr("y", (d) => d.y0)
.attr("height", (d) => d.y1 - d.y0)
.attr("width", (d) => d.x1 - d.x0);

if (G) node.attr("fill", ({ index: i }) => color(G[i]));
if (Tt) node.append("title").text(({ index: i }) => Tt[i]);

const link = svg
.append("g")
.attr("fill", "none")
.attr("stroke-opacity", linkStrokeOpacity)
.selectAll("g")
.data(links)
.join("g")
.style("mix-blend-mode", linkMixBlendMode);

if (linkColor === "source-target")
link
.append("linearGradient")
.attr("id", (d) => `${uid}-link-${d.index}`)
.attr("gradientUnits", "userSpaceOnUse")
.attr("x1", (d) => d.source.x1)
.attr("x2", (d) => d.target.x0)
.call((gradient) =>
gradient
.append("stop")
.attr("offset", "0%")
.attr("stop-color", ({ source: { index: i } }) => color(G[i]))
)
.call((gradient) =>
gradient
.append("stop")
.attr("offset", "100%")
.attr("stop-color", ({ target: { index: i } }) => color(G[i]))
);

link
.append("path")
.attr("d", linkPath)
.attr(
"stroke",
linkColor === "source-target"
? ({ index: i }) => `url(#${uid}-link-${i})`
: linkColor === "source"
? ({ source: { index: i } }) => color(G[i])
: linkColor === "target"
? ({ target: { index: i } }) => color(G[i])
: linkColor
)
.attr("stroke-width", ({ width }) => Math.max(1, width))
.call(
Lt
? (path) => path.append("title").text(({ index: i }) => Lt[i])
: () => {}
);

if (Tl)
svg
.append("g")
.attr("font-family", "sans-serif")
.attr("font-size", 10)
.selectAll("text")
.data(nodes)
.join("text")
.attr("x", (d) =>
d.x0 < width / 2 ? d.x1 + nodeLabelPadding : d.x0 - nodeLabelPadding
)
.attr("y", (d) => (d.y1 + d.y0) / 2)
.attr("dy", "0.35em")
.attr("text-anchor", (d) => (d.x0 < width / 2 ? "start" : "end"))
.text(({ index: i }) => Tl[i]);

function intern(value) {
return value !== null && typeof value === "object"
? value.valueOf()
: value;
}
//mutable log = nodes;
return Object.assign(svg.node(), { scales: { color } });
}
Insert cell
Insert cell
d3Sankey = require.alias({"d3-array": d3, "d3-shape": d3, "d3-sankey": "d3-sankey@0.12.3/dist/d3-sankey.min.js"})("d3-sankey")
Insert cell
import {howto} from "@d3/example-components"
Insert cell

One platform to build and deploy the best data apps

Experiment and prototype by building visualizations in live JavaScript notebooks. Collaborate with your team and decide which concepts to build out.
Use Observable Framework to build data apps locally. Use data loaders to build in any language or library, including Python, SQL, and R.
Seamlessly deploy to Observable. Test before you ship, use automatic deploy-on-commit, and ensure your projects are always up-to-date.
Learn more