Public
Edited
Jan 23
7 forks
3 stars
Insert cell
Insert cell
Insert cell
Insert cell
data = aq.loadCSV(
"https://raw.githubusercontent.com/mohamadwaked/classico/master/p0017_dataset.csv"
)
Insert cell
Insert cell
data.view(5)
Insert cell
Insert cell
data
.rename({
total_death_missing: "missing",
cause_of_death: "cause",
collapsed_cause: "cause_new",
collapsed_region: "region_new"
})
.view(5)
Insert cell
Insert cell
data
.rename({
total_death_missing: "missing",
cause_of_death: "cause",
collapsed_cause: "cause_new",
collapsed_region: "region_new"
})
.select(0, 1, 2, 3, 4, 6, 7, 9, 13, 15)
.view(5)
Insert cell
Insert cell
data
.rename({
total_death_missing: "missing",
cause_of_death: "cause",
collapsed_cause: "cause_new",
collapsed_region: "region_new"
})
.select(0, 1, 2, 3, 4, 6, 7, 9, 13, 15)
.orderby(aq.desc("missing"))
.view(25)
Insert cell
data
.rename({
total_death_missing: "missing",
cause_of_death: "cause",
collapsed_cause: "cause_new",
collapsed_region: "region_new"
})
.select(0, 1, 2, 3, 4, 6, 7, 9, 13, 15)
.orderby("missing")
.view(10)
Insert cell
Insert cell
data
.rename({
total_death_missing: "missing",
cause_of_death: "cause",
collapsed_cause: "cause_new",
collapsed_region: "region_new"
})
.filter((d) => d.missing > 0)
.select(0, 1, 2, 3, 4, 6, 7, 9, 13, 15)
.orderby("missing")
.view(5)
Insert cell
Insert cell
refugee_filtered = data
.rename({
total_death_missing: "missing",
cause_of_death: "cause",
collapsed_cause: "cause_new",
collapsed_region: "region_new"
})
.filter((d) => d.missing > 0)
.select(0, 1, 2, 3, 4, 6, 7, 9, 13, 15)
.orderby("missing")
.objects()
Insert cell
Insert cell
Insert cell
Insert cell
region = data
.rename({
total_death_missing: "missing",
cause_of_death: "cause",
collapsed_cause: "cause_new",
collapsed_region: "region_new"
})
.filter((d) => d.missing > 0)
.groupby("region_new")
.rollup({
mean_missing: (d) => op.mean(d.missing),
sum_missing: (d) => op.sum(d.missing),
count: op.count()
})
.filter((d) => d.count > 0)
.orderby(aq.desc("mean_missing"))
.objects()
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
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