Public
Edited
May 18
d3 = require("d3@7")
rawCPI = FileAttachment("YearMonCPI.csv").csv({typed: true})
cpiData = rawCPI.flatMap(row => {
const year = row.Year;
return Object.entries(row)
.filter(([month]) => month !== "Year")
.map(([month, value]) => ({
date: new Date(`${year}-${month}-01`),
value: value
}));
})
rawWages = FileAttachment("MedianRealWageQuarterly.csv").csv({typed: true})
wageData = rawWages.flatMap(row => {
const year = row.Year;
return ["Qtr1", "Qtr2", "Qtr3", "Qtr4"].map((qtr, i) => ({
date: new Date(`${year}-${(i + 1) * 3 - 1}-01`), // Q1 = March, Q2 = June, etc.
value: row[qtr]
}));
})
combinedData = [
...cpiData.map(d => ({date: d.date, value: d.value, series: "CPI"})),
...wageData.map(d => ({date: d.date, value: d.value, series: "Wage"}))
]
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.
