Data graphics developer at Gapminder. Teacher at DIS Stockholm. Escaping flatland one chart at a time.
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
}))
maximum = lineData.filter(f => f.Unemployment == d3.max(lineData, d=>d.Unemployment)).pop()
Plot.plot({
marks: [
Plot.ruleY([0]),
Plot.lineY(lineData, {x: "Date", y: "Unemployment"}),
Plot.tip(
[maximum.Unemployment + "% on " + d3.utcFormat("%Y %b")(maximum.Date)],
{x: maximum.Date, y: maximum.Unemployment, anchor: "left"}
)
]
})
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.
