Public
Edited
May 29, 2023
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
csv_archive = FileAttachment("Gender_Stats_CSV.zip").zip()
Insert cell
Insert cell
// This function removes the BOM character at teh beginning of our dataset
// courtesy of @fil
// See https://en.wikipedia.org/wiki/Byte_order_mark
function stripBOM(text) {
return text.charCodeAt(0) === 0xfeff ? text.slice(1) : text;
}
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
gender_stats_DB = DuckDBClient.of({
gender_stats_data,
gender_stats_country,
gender_stats_series,
gender_stats_series_country,
// Note: We're re-building the full database, but we won't build these next two tables into our next queries
gender_stats_series_time,
gender_stats_series_footnote})
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
d3.group(Gender_Stats, d => d.Topic, d => d["Country Name"])
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell

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.
Learn more