workbook = FileAttachment("Bio-Info-Science.xlsx").xlsx()
sheetsnames = workbook.sheetNames
sheets_headers_true = sheetsnames.map(x => workbook.sheet(x, {headers: true}))
sheets_headers_false = sheetsnames.map(x => workbook.sheet(x, {headers: false}))
sheetsObj = sheetsnames.reduce((prev, curr) => {
prev[curr] = workbook.sheet(curr, {headers:true});
return prev;
}, {});
sheetsMap = new Map(sheetsnames.map(x => [x,workbook.sheet(x, {headers: true})]))
filtered_sheets = sheets_headers_true.filter(x =>x.columns.includes("Longitude") && x.columns.includes("Latitude"))
invalid_sheets = sheets_headers_true.filter(x =>! (x.columns.includes("Longitude") && x.columns.includes("Latitude")))
dummy = FileAttachment("dummy2@1.xlsx").xlsx()
dummynames = dummy.sheetNames
dummyMap = new Map(dummynames.map(x => [x, dummy.sheet(x, {headers: true})]))
category = dummy.sheet("Sheet3", {headers: true}).map(x => x["name"])
viewof select = Inputs.select(category, {label: "Category:"})
md`# Modifying Derek's Data`
sheets_headers_true[0].columns
Object.values(sheets_headers_true[0].columns)
sheets_headers_true[0].columns.includes("Latitude")
"Latitude" in Object.values(sheets_headers_true[0].columns)
"0" in sheets_headers_true[0].columns
sheets_headers_true.filter(x =>"Longitude" in x.columns)
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.
