Public
Edited
Apr 14, 2023
Insert cell
Insert cell
Insert cell
Insert cell
fails
Insert cell
fails = (await FileAttachment("bfb-data.csv").csv({array: true}))
.slice(1, -2)
.map((d) => ({
"Bank Name": d[0].split(", ")[0],
"City, State": d[0].split(", ").slice(1).join(", "),
"Date": parseDate(d[2]),
"Assets": parseAssets(d[3]),
"Acquirer": d[5]
}))
Insert cell
parseDate = d3.utcParse("%d-%b-%y")
Insert cell
parseAssets = (x) => parseFloat(x.replace(/[^\d.]/g, ""))
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