The avatar for @sandraviz
Sandraviz
Olá! My name is Sandra and I work with Dataviz in beautiful Lisbon 🙋🏼‍♀️ I'm a visual analyst and researcher with a passion for data storytelling and statistics to uncover patterns in human behaviour and societies 💞
Public
Data visualisation engineer
Edited
Mar 14
Fork of IEA (OECD) - Part 1
•
2 forks
1 star
1
Insert cell
Insert cell
Insert cell
data = FileAttachment("investors@3.json").json()
Insert cell
data1 = aq.from(data).view(5)
Insert cell
Insert cell
aq
.from(data)
.select("_id", "name", "type", "hqCountry", "numInvestments", "totalInvested")
.rename({
_id: "id"
})
.derive({ totalInvested: (d) => d.totalInvested / 10000 })
.view(5)
Insert cell
Insert cell
aq
.from(data)
.select("_id", "name", "type", "hqCountry", "numInvestments", "totalInvested")
.rename({
_id: "id"
})
.derive({ totalInvested: (d) => d.totalInvested / 10000 })
.orderby(aq.desc("totalInvested"))
.view(5)
Insert cell
Insert cell
aq
.from(data)
.select("_id", "name", "type", "hqCountry", "numInvestments", "totalInvested")
.rename({
_id: "id"
})
.derive({ totalInvested: (d) => d.totalInvested / 10000 })
.orderby("totalInvested")
.view(5)
Insert cell
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
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
data_investors3 = 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
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
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