md`# Education Enrolment By County: Exercise 2`
d3 = require("d3@5")
topojson = require("topojson-client@3")
counties = FileAttachment("County_ContUS_WGS1984.json").json()
counties_features = topojson.feature(counties, counties.objects.County_ContUS_WGS1984)
csv_data = d3.csvParse(await FileAttachment("PopSchoolEnrollmentA1GV.csv").text(),({ARWJE001, ARWJE002, ARWJE010, COUNTYA}) => [+COUNTYA, [100*+ARWJE002/ARWJE001, 100*+ARWJE010/ARWJE001]])
//this is how to take the values of a variable (column) from all variables you created from the csv file
EnroldPct = Array.from(csv_data.values(), d => d[1][0])
NotEnroldPct = Array.from(csv_data.values(), d => d[1][1])
//this is how you map the id column to the values. We will use this for joining with topojson later.
data = Object.assign(new Map(csv_data), {title: ["EnroldPct", "NotEnroldPct"]})
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.
