Public
Edited
Jun 10, 2023
CSTAF-21-22.csv
Type Table, then Shift-Enter. Ctrl-space for more options.
CSTAF-21-22.csv
X
—
Y
CPSTKIDR
Color
—
Size
—
Facet X
—
Facet Y
—
Mark
Auto
Type Chart, then Shift-Enter. Ctrl-space for more options.
campusTSRatio = data.map(({
CAMPUS,
CAMPNAME,
CPSTKIDR,
DISTNAME,
DISTRICT
}) => ({
CAMPUS,
CAMPNAME,
CPSTKIDR,
DISTNAME,
DISTRICT,
YEAR: '2021-2022',
}))
campusTSRatio
Type Table, then Shift-Enter. Ctrl-space for more options.
data[0].CAMPUS.length
schools_2022_to_2023 = FileAttachment("Schools_2022_to_2023.geojson")
schoolGEO = await schools_2022_to_2023.json()
schools = schoolGEO.features
.map(({ type, properties, geometry }) => ({ type, properties: {schoolID: `'${(properties.USER_School_Number + '').padStart(9, '0')}`,...properties}, geometry }))
.map(({ type, properties, geometry }) => ({
type,
properties: {
...campusTSRatio.find((item) => (item.CAMPUS === properties.schoolID)),
...properties,
},
geometry,
})
)
schoolTSRatioGeo = {'type': 'FeatureCollection','name': "schools",'crs': schoolGEO.crs,'features':schools}
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.
