Public
Edited
Mar 5
Insert cell
Insert cell
data = FileAttachment("investors@3.json").json()
Insert cell
data_investors = aq
.from(data)
.select("_id", "name", "type", "hqCountry", "numInvestments", "totalInvested")
.rename({
_id: "id"
})
.derive({ totalInvested: (d) => d.totalInvested / 10000 })
.objects()
Insert cell
data_exc_outliers = aq
.from(data)
.select("_id", "name", "type", "hqCountry", "numInvestments", "totalInvested")
.rename({
_id: "id"
})
.derive({ totalInvested: (d) => d.totalInvested / 10000 })
.filter((d) => (d.totalInvested > 0) & (d.totalInvested < 1000000))
.objects()
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