The avatar for @credmond
Charles Redmond
Public
aaa-Database350Fall23
Edited
Sep 14, 2023
Fork of Joins
•
4 forks
3
aaa-Database350Fall23
Plotting TemplateSine ApplicationNYC ExampleStock PricesQuiz 9Grad Case Statement Quiz and AnalyticsThe Case StatementGrad QuizQuiz 7 and Correlated SubqueriesChinook DatabaseQuiz 6SubqueriesSakilaQuiz 5SetsH VS. SO
Data Viz
JoinsBasic QueriesCreating and Populating a Database
Insert cell
Insert cell
Insert cell
Plot.plot({
x:{domain:[1850,2022],tickFormat:".0f"},
y:{domain:[0,310]},
marks:[
Plot.ruleX([1900]),
Plot.ruleY([0]),
Plot.line(data,{x:"yearID",y:"HR",stroke:"red"})
]
})
Insert cell
Insert cell
db
SELECT DISTINCT name
FROM teams
Insert cell
nameArray = nameQuery.map(record => record.name).sort()
Insert cell
db
SELECT yearID,HR
FROM teams
WHERE name = ${name}
Insert cell
data
Insert cell
Insert cell
Insert cell
db
ALTER TABLE batting
ALTER yearID TYPE USMALLINT
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
superheroes = [
{name:"Batman",identity:"Bruce Wayne",age:35},
{name:"Superman",identity:"Clark Kent",age:25}
]
Insert cell
superheroes[1].identity
Insert cell
x = [1,4,3,7]
Insert cell
x.map(x => x*x)
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