The avatar for @credmond
Charles Redmond
Public
aaa-Database550Fall23
Edited
Sep 12, 2023
Fork of Data Viz
•
1 fork
3
aaa-Database550Fall23
Plotting TemplateClass Exercise Part 2Make-up QuizViews and AnalyticsThe CASE StatementCASE Part 2Correlated SubQueriesQuiz 6Chinook ProblemsSubqueriesSets Part 2SetsH VS SO Application
Homerun Application
Plotting TutorialData VizJoinsBaseball DatabaseCreating 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
db
SELECT DISTINCT name
FROM teams
Insert cell
Insert cell
db
SELECT yearID,HR
FROM teams
WHERE name = ${name}
Insert cell
data
Insert cell
Insert cell
db = DuckDBClient.of({
batting:battingFile,
people:peopleFile,
teams:teamsFile
})
Insert cell
db
ALTER TABLE batting
ALTER yearID TYPE USMALLINT
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
x = [2,5,4,8,0]
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