fails = data //(await FileAttachment("bfb-data@1.csv").csv({array: true}))
//.slice(1, -2)
.map((d) => ({
"Bank Name": d["Bank Name, City, State"].split(", ")[0],
"City, State": d["Bank Name, City, State"].split(", ").slice(1).join(", "),
Date: parseDate(d["Closing Date"]),
Assets: parseAssets(d["Approx. Asset (Millions)"]),
Acquirer: d["Acquirer & Transaction"]
}))
gfc2 = fails.filter((d) => d["Bank Name"] == "Silicon Valley Bank")
gfc = fails.filter((d) => d["Bank Name"] == "IndyMac Bank")
fails
await FileAttachment("bfb-data@1.csv").csv({ array: true })
parseDate = d3.utcParse("%d-%b-%y")
parseAssets = (x) => parseFloat(x.replace(/[^\d.]/g, ""))
data[data.length - 2]
data = fdic.data
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.
