The end-to-end solution for building and hosting better data apps, dashboards, and reports.
unemploymentWide = unemploymentBLS.sheet(0, {headers: true})
unemploymentWide
Type Table, then Shift-Enter. Ctrl-space for more options.
unemploymentTall = aq.from(unemploymentWide) // create an arquero table from our data
.fold(aq.not('Year'), { as: ['Month', 'Unemployment'] }) // unpivot/fold the data by year, create columns Month and Unemployment
.objects() // turn it back into a JavaScript array of objects
unemploymentTall
Type Table, then Shift-Enter. Ctrl-space for more options.
lineData = unemploymentTall.map(row => ({
Date: d3.utcParse("%Y %b")(row.Year + " " + row.Month), //parse year and month into a proper date object
Unemployment: row.Unemployment //copy the unemployment column without change
}))
Plot.plot({
marks: [
Plot.ruleY([0]),
Plot.lineY(lineData, {x: "Date", y: "Unemployment"})
]
})
data
Type Table, then Shift-Enter. Ctrl-space for more options.
data
Type Table, then Shift-Enter. Ctrl-space for more options.
unemploymentBLS = FileAttachment("SeriesReport-20230614144010_3ed09f-cropped.xlsx").xlsx({})
data = cars
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.
