The avatar for @56fc95d9361213d8
56fc95d9361213d8
Public
Edited
Jun 15, 2023
Fork of Lesson 2: Data
5
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
unemploymentWide = unemploymentBLS.sheet(0, {headers: true})
Insert cell
unemploymentWide
Type Table, then Shift-Enter. Ctrl-space for more options.

Insert cell
Insert cell
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
Insert cell
Insert cell
unemploymentTall
Type Table, then Shift-Enter. Ctrl-space for more options.

Insert cell
Insert cell
Insert cell
data
Type Table, then Shift-Enter. Ctrl-space for more options.

Insert cell
Insert cell
data
Type Table, then Shift-Enter. Ctrl-space for more options.

Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
unemploymentBLS = FileAttachment("SeriesReport-20230614144010_3ed09f-cropped.xlsx").xlsx({})
Insert cell
data = cars
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