The avatar for @labvegas
labvegas
Public
Edited
Sep 21, 2024
Paused
8
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
chronicAbsenteeismThru2024.filter(d=>d.Name == "State");
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
function proficiencyLabel(selection) {
return {
Math: "Math proficiency %",
English: "English proficiency %",
Average: "Math + ELA average proficiency %",
}[selection];
}
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
function getMatchingSchoolNames(a=selectedData,t=schoolNameInput) {
return a.filter(d=>isMatchingSchoolName(d,t)).map(d=>d["School Name"]);
}
Insert cell
Insert cell
ratingsAbsenteeism.filter(d=>!Number(d["Chronic Absenteeism - All Students"]))
Insert cell
ratingsAbsenteeism.filter(d=>Number(d["Total Enrollment"]) < 20)
Insert cell
ratingsAbsenteeism.filter(d=>!Number(d["Chronic Absenteeism"]) && Number(d["Chronic Absenteeism - All Students"]) )
Insert cell
selectedData = {
return filteredData.filter(d=> checkboxesType.includes(d["School Type"]) && checkboxesLevel.includes(d.level) &&
(districtSelected === "All" || d["District Name"]==districtSelected ));
}
Insert cell
Insert cell
crtByGroup = d3.csvParse((await FileAttachment("crtGroupSummary@1.csv").text()))
Insert cell
Insert cell
Insert cell
chronicAbsenteeismThru2024 = d3.csvParse((await FileAttachment("2024 NV chronic absenteeism by school with groups.csv").text()).split("\n").slice(2).join(""),d3.autoType)
Insert cell
2024 NV chronic absenteeism by school with groups.csv
Type Table, then Shift-Enter. Ctrl-space for more options.

Insert cell
Insert cell
absenteeism2022 = absenteeism.filter(d=>d["Accountability Year"]=="2022-2023")
Insert cell
Insert cell
demographicProfiles = d3.csvParse((await FileAttachment("Demographic_Profile.csv").text()).split("\r\n").slice(3).join("\n`")).map(d=>({...d,Name:d.Name.replace('"',"").replace('`',"")}))
Insert cell
import {tidy, leftJoin, count} from '@pbeshai/tidyjs'
Insert cell
Insert cell
districtCountsArray = tidy(ratingsAbsenteeism, count("District Name"))
Insert cell
Insert cell
schoolTypeCounts = valueCounts(ratingsAbsenteeism,"School Type")
Insert cell
Insert cell
ratingsAbsenteeism
Type Table, then Shift-Enter. Ctrl-space for more options.

Insert cell
Insert cell

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.
Learn more