architects = FileAttachment("Table2bArchitects.xlsx").xlsx()
designers = FileAttachment("Table2eDesigners.xlsx").xlsx()
allRacesArchitects = architects.sheet("All-Races")
allRacesDesigners = designers.sheet("All-Races")
allRacesArchitects[3]
allRacesDesigners[3]
architectData = allRacesArchitects
.slice(6)
.filter((d) => d.A)
.map((s) => ({
state: s.A,
abbreviation: stateLabels.find((d) => d.name == s.A),
allWorkers: s.B,
creatorCount: s.C,
creatorPercentage: s.C / s.B,
creatorLabel: "Architect"
}))
designerData = allRacesDesigners
.slice(6)
.filter((d) => d.A)
.map((s) => ({
state: s.A,
abbreviation: stateLabels.find((d) => d.name == s.A),
allWorkers: s.B,
creatorCount: s.C,
creatorPercentage: s.C / s.B,
creatorLabel: "Designer"
}))
allCreatorData = architectData.concat(designerData)
Inputs.table(allCreatorData)
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.
