Public
Edited
May 3, 2023
1 star
Insert cell
Insert cell
Insert cell
Insert cell
ds = JSONstat(jsonURL)
Insert cell
Insert cell
dtRaw = aq.table(
ds.toTable({
type: "objarr",
content: "id",
}) // show raw data
)

Insert cell
Insert cell
dtRaw.view()
Insert cell
Insert cell
Insert cell
dtParsed = aq.table(
ds.toTable({ type: "objarr", content: "label"}) // show parsed data
)
Insert cell
dtParsed.view()
Insert cell
dtParsed.dedupe('age').array('age')
Insert cell
Insert cell
Insert cell
dtRaw.columnNames()
Insert cell
Insert cell
dtRaw.dedupe('age').array('age')
Insert cell
Insert cell
Insert cell
ds.toTable({
type: "arrobj",
content: "id",
},
( d, i ) => {
const geoLabel = ds.Dataset("dataset").Dimension( "geo" ).Category(d.geo).label;
delete d.unit;
delete d.freq;
delete d.age;
delete d.time;
return {...d, geoLabel: geoLabel}
}
)
Insert cell
Insert cell
dtRaw.toCSV() // .toTSV(), .toJSON(), etc.
Insert cell
Insert cell
Insert cell
import { aq, op } from '@uwdata/arquero'

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