The avatar for @billshander
Bill Shander
Information design & data visualization practitioner. Teaching private workshops and on LinkedIn Learning and at the University of Vermont.
Public
LinkedIn Learning Intro to Observable Course
Edited
Nov 1, 2023
1 fork
1
Insert cell
Insert cell
Insert cell
squirrels = FileAttachment("2018_Central_Park_Squirrel_Census_-_Squirrel_Data.csv").csv()
Insert cell
filteredSquirrels = squirrels.filter(s => (s.Age == "Adult" && s.Chasing.toLowerCase() == "true" && s.Running.toLowerCase() == "false"))
Insert cell
noisySquirrels = {
var ids = []
var noisy = []
filteredSquirrels.forEach(function(s){
if(s.Kuks.toLowerCase() == "true" || s.Quaas.toLowerCase() == "true" || s.Moans.toLowerCase() == "true"){
if(ids.indexOf(s["Unique Squirrel ID"]) == -1) {
noisy.push(s)
ids.push(s["Unique Squirrel ID"])
}
}
})
return noisy
}
Insert cell
Insert cell
2018_Central_Park_Squirrel_Census_-_Squirrel_Data.csv
SELECT "Unique Squirrel ID", "Age", "Primary Fur Color", "Highlight Fur Color", "Combination of Primary and Highlight Color", "Location", "Running", "Chasing", "Climbing", "Eating", "Foraging", "Kuks", "Quaas", "Moans", "Tail flags", "Tail twitches", "Approaches", "Indifferent", "Runs from" FROM "2018_Central_Park_Squirrel_Census_-_Squirrel_Data" WHERE Age == 'Adult' AND Running == FALSE AND Chasing == TRUE AND (Kuks == TRUE OR Quaas == TRUE OR Moans == TRUE)
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