Dataviz at Office for National Statistics (UK)
gppd = aq.fromCSV(
await FileAttachment("global_power_plant_database.csv").text()
)
country_summary = gppd
.groupby("country_long")
.rollup({
total_capacity_mw: (d) => op.sum(d.capacity_mw),
count: op.count()
})
.orderby(aq.desc("total_capacity_mw"))
.reify()
top_15_countries = country_summary.column("country_long").data.slice(0, 15)
fuel_summary = gppd
.groupby("primary_fuel")
.rollup({
total_capacity_mw: (d) => op.sum(d.capacity_mw),
count: op.count()
})
.orderby(aq.desc("total_capacity_mw"))
.reify()
fuel_summary.view()
country_fuel_summary = gppd
.groupby("country_long", "primary_fuel")
.rollup({
total_capacity_mw: (d) => op.sum(d.capacity_mw),
count: op.count()
})
.groupby("country_long")
.derive({
proportion_of_country_capacity: (d) =>
d.total_capacity_mw / op.sum(d.total_capacity_mw)
})
.orderby(aq.desc("total_capacity_mw"))
country_fuel_summary.view(10)
stackedBar("total_capacity_mw")
stackedBar("proportion_of_country_capacity")
stackedBar("count")
Swatches(d3.scaleOrdinal(plant_types, colourScale))
fuel_group_map.view()
gppd_summarised = gppd.join(fuel_group_map)
fuel_group_to_colour = ({
"Fossil fuels": "#222222",
Nuclear: "#9467bd",
Hydro: "#1f77b4",
Wind: "#2ca02c",
Solar: "#ff7f0e",
Other: "#f4da00"
})
moved_dots = {
const moved_dots = [...dots].filter((d) => d.country_long === "India");
moved_dots.forEach((d) => {
[d.originalX, d.originalY] = [d.x, d.y];
});
d3.forceSimulation(moved_dots)
.force(
"x",
d3.forceX(({ x }) => x)
)
.force(
"y",
d3.forceY(({ y }) => y)
)
.force(
"collide",
d3.forceCollide().radius((d) => Math.sqrt(d.capacity_mw) / 22)
) // collide
.stop()
.tick(50);
return moved_dots;
}
import { Swatches } from "@d3/color-legend"
projection = d3.geoEqualEarth()
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
