md`# Menu cantine / Saisons - excerpt`
is_saison_rollup = d3.flatRollup(is_saison, v => v.length, d => d.month, d => d.match, d => d.category)
is_not_saison_rollup = d3.flatRollup(is_not_saison, v => v.length, d => d.month, d => d.match, d => d.category)
is_saison_count = is_saison_rollup.map(([month, match, category, count]) => ({month, match, category, count}))
is_not_saison_count = is_not_saison_rollup.map(([month, match, category, count]) => ({month, match, category, count}))
is_saison_count_max = d3.max(is_saison_count.map(({ count }) => count))
aliment_saison = d3.flatRollup(
is_saison_count,
v => d3.sum(v, d => d.count),
d => d.category,
d => d.match,
).map(([category, aliment]) => aliment)
aliment_not_saison = d3.flatRollup(
is_not_saison_count,
v => d3.sum(v, d => d.count),
d => d.category,
d => d.match,
).map(([category, aliment]) => aliment)
count_domain = [0, is_saison_count_max]
md`### Si on ne mange pas de saison, qu'est-ce qu'on mange ?
sur la base des aliments de saisons identifiés`
is_saison = menu_saison_with_match.filter(({ is_saison }) => is_saison == "True")
is_not_saison = menu_saison_with_match.filter(({ is_saison }) => is_saison == "False")
md`### Fussiiiooon`
gridcolor = legend({
color: d3.scaleSequential([-max_bound, max_bound], d3.interpolatePRGn),
title: "# de saison"
})
gridviewLegume = Plot.plot({
width: 400,
marginLeft: 100,
padding: 0.05,
x: {
label: "Mois"
},
y: {
label: "Aliment",
domain: legume_aliments,
grid: true
},
color: {
scheme: "PRGn",
},
marks: [
Plot.cell(legume, {
x: "month",
y: "match",
fill: "count",
}),
]
})
gridviewFruit = Plot.plot({
width: 400,
marginLeft: 100,
padding: 0.05,
x: {
label: "Mois"
},
y: {
label: "Aliment",
domain: fruit_aliments,
grid: true
},
color: {
scheme: "PRGn",
},
marks: [
Plot.cell(fruit, {
x: "month",
y: "match",
fill: "count",
}),
]
})
max_bound = d3.max([
d3.max(check_saison.map(({ count }) => count)),
- d3.min(check_saison.map(({ count }) => count))
])
legume = check_saison.filter(({ category }) => category === 'legume')
fruit = check_saison.filter(({ category }) => category === 'fruit')
fruit_aliments = d3.flatRollup(
fruit,
v => d3.sum(v, d => d.count),
d => d.match,
).map(([ aliment]) => aliment)
legume_aliments = d3.flatRollup(
legume,
v => d3.sum(v, d => d.count),
d => d.match,
).map(([ aliment]) => aliment)
aliments = d3.flatRollup(
check_saison,
v => d3.sum(v, d => d.count),
d => d.category,
d => d.match,
).map(([category, aliment]) => aliment)
check_saison = d3.flatRollup(
menu_saison_with_match,
v => [d3.filter(v, d => d.is_saison === "True").length, d3.filter(v, d => d.is_saison === "False").length],
d => d.month,
d => d.category,
d => d.match,
).map(([month, category, match, [count_saison, count_not_saison]]) => ({
month,
category,
match,
count: count_saison - count_not_saison,
}))
radialExample = radial(300, 300, weeks_chou, 'chou')
function radial(svgWidth, svgHeight, data_weeks, label) {
const baseline = 0;
const margin = 10;
const y_ticks_num = 3;
const svgInnerRadius = svgWidth / 6;
const svgOuterRadius = svgWidth / 2 - margin;
const localBound = d3.max(data_weeks.map(({ count }) => count))
const xScale = d3.scaleBand( //scaleLinear()
data_weeks.map(d => d.week), // .domain([1, 60])
[0, 2 * Math.PI] //.range([0, 2 * Math.PI]
);
const weeks = xScale.domain().map(week => ({
week,
month : dayjs().week(week).format('MMMM')
}));
const months = d3.groups(weeks, d => d.month).map(([month, values]) => ({ month, week: values[0].week }));
const yScale = d3.scaleLinear()
.domain([d3.min(data_weeks, d => d.count), d3.max(data_weeks, d => d.count)])
.range([svgInnerRadius, svgOuterRadius])
const line = d3.lineRadial()
.curve(d3.curveLinear)
.angle(d => xScale(d.week));
const color = d3.scaleSequential([-localBound, localBound], d3.interpolatePRGn);
const arcDefinition = d3.arc()
.innerRadius(d => yScale(Math.max(baseline,d.count)))
.outerRadius(d => yScale(Math.min(baseline,d.count)))
.startAngle(d => xScale(d.week))
.endAngle(d => xScale(d.week) + xScale.bandwidth()*0.95)
.padAngle(0.01)
const xAxis = g => g
.attr("font-family", "sans-serif")
.attr("font-size", 10)
.call(g => g.selectAll("g")
.data(months)
.join("g")
.each((d, i) => d.id = DOM.uid("month"))
// .each((d, i) => d.nextMonthFirstWeek = getNextMonth(d.week).week)
.call(g => g.append("path")
.attr("stroke", "#000")
.attr("stroke-opacity", 0.2)
.attr("d", d => `
M${d3.pointRadial(xScale(d.week), svgInnerRadius)}
L${d3.pointRadial(xScale(d.week), svgOuterRadius)}
`))
.call(g => g.append("path")
.attr("id", d => d.id.id)
//.datum(d => [d, d])
.attr("fill", "none")
.attr("d", d => `
M${d3.pointRadial(xScale(d.week), svgOuterRadius)}
A${svgOuterRadius},${svgOuterRadius} 0,0,1 ${d3.pointRadial(xScale(d.week + 4), svgOuterRadius)}
`))
.call(g => g.append("text")
.append("textPath")
.attr("startOffset", 6)
.attr("xlink:href", d => d.id.href)
.attr("class", "bar")
.text(d => d.month)
)
)
const yAxis = g => g
.attr("text-anchor", "middle")
.attr("font-family", "sans-serif")
.attr("font-size", 10)
.call(g => g.selectAll("g")
.data(yScale.ticks(y_ticks_num).reverse())
.join("g")
.attr("fill", "none")
.call(g => g.append("circle")
.attr("stroke", "#000")
.attr("stroke-opacity", 0.2)
.attr("r", yScale))
.call(g => g.append("text")
.attr("y", d => -yScale(d))
.attr("dy", "0.35em")
.attr("stroke", "#fff")
.attr("stroke-width", 5)
.text((x, i) => x)
.clone(true)
.attr("y", d => yScale(d))
.selectAll(function() { return [this, this.previousSibling]; })
.clone(true)
.attr("fill", "currentColor")
.attr("stroke", "none")))
const svg = d3.create("svg")
.attr("width", svgWidth)
.attr("height", svgHeight)
.attr("stroke-linejoin", "round")
.attr("stroke-linecap", "round");
const container = svg.append('g')
.attr('class', 'container')
.attr('transform', `translate(${ svgWidth/2 },${ svgHeight/2 })`);
container.append("path")
.attr("fill", "none")
.attr("stroke", "black")
.attr("stroke-width", 1.5)
.attr("d", line
.radius(d => yScale(d.count))
(data_weeks));
container
.selectAll('path')
.data(data_weeks)
.join('path')
.style('fill', d => color(d.count))
.style('stroke', d => color(d.count))
.attr('d', arcDefinition)
container.append("g")
.call(yAxis);
container.append("g")
.call(xAxis);
container.append("text")
.attr("font-family", "sans-serif")
.attr("font-size", 18)
.attr("font-weight", "bold")
.attr("x", 0)
.attr("y", 0)
.style("text-anchor", "middle")
.text(label);
return svg.node();
}
function getNextMonth(weekNumber) {
return months.find(({ week }) => weekNumber < week)
}
months = d3.groups(weeks, d => d.month).map(([month, values]) => ({ month, week: values[0].week }))
md ` ## Data Prep`
weeks_chou = weeks_saison.filter(({ match }) => match === "chou").sort((a,b) => a.week - b.week)
weeks_saison_by_food = d3.groups(
weeks_saison,
d => d.match
).map(([foodName, content]) => ({ foodName, data: content.sort((a,b) => a.week - b.week) }))
weeks_saison = d3.flatRollup(
menu_saison_with_match,
v => [d3.filter(v, d => d.is_saison === "True").length, d3.filter(v, d => d.is_saison === "False").length],
// d => d.Date.getFullYear(),
d => dayjs(d.Date).week(),
d => d.category,
d => d.match,
).map(([/* year, */ week, category, match, [count_saison, count_not_saison]]) => ({
// year,
week,
category,
match,
count: count_saison - count_not_saison,
}))
year_month_percentage_rollup = d3.flatRollup(menu_saison_with_match,
v => d3.filter(v, d => d.is_saison === "True").length / v.length * 100,
d => d.Date.getFullYear(),
d => d.month
)
year_month_percentage = year_month_percentage_rollup.map(([year, month, perc]) => ({year, month, perc}))
d3.max(year_month_percentage.map(({ perc }) => perc))
Type JavaScript, then Shift-Enter. Ctrl-space for more options. Arrow ↑/↓ to switch modes.
year_percentage_rollup = d3.flatRollup(menu_saison_with_match,
v => d3.filter(v, d => d.is_saison === "True").length / v.length * 100,
d => d.Date.getFullYear(),
)
year_percentage = year_percentage_rollup.map(([year, perc]) => ({year, perc}))
perc_identified_month = d3.flatRollup(
menu_saison,
v => d3.filter(v, d => d.match !== null).length / v.length * 100,
d => d.month,
).map(([month, perc]) => ({ month, perc }))
md ` ### Imports`
d3 = require("d3-array@^3", "d3-time-format@2.2.2", "d3@6", "d3-time")
import {legend, swatches} from "@d3/color-legend"
dayjs = {
const dayjs = await require('dayjs')
await require('dayjs/locale/fr')
var weekOfYear = await require('dayjs/plugin/weekOfYear')
dayjs.locale('fr')
dayjs.extend(weekOfYear)
return dayjs
}
https://observablehq.com/@d3/radial-area-chart
https://observablehq.com/@thetylerwolf/day-17-radial-bar-chart
https://observablehq.com/@jlchmura/d3-change-line-chart-with-positive-negative-fill
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.