data = {
let data = await FileAttachment("bfb-data.csv").csv({typed: true})
const parseDate = d3.timeParse("%-d-%b-%y")
data.forEach(d => {
d["Bank Name, City, State"] = d["Bank Name, City, State"].split(', ')
d["Closing Date"] = parseDate(d["Closing Date"])
d["Approx. Asset (Millions)"] = Number(d["Approx. Asset (Millions)"].replace(/[^0-9\.]+/g, ""))
d["Approx. Deposit (Millions)"] = Number(d["Approx. Deposit (Millions)"].replace(/[^0-9\.]+/g, ""))
})
return data
}