Platform
Resources
Pricing
Sign in
Get started
Ross Stewart
Workspace
Fork
Public
By
Ross Stewart
Edited
Mar 15, 2023
2
Insert cell
Insert cell
db
=
DuckDBClient
.
of
(
{
batting
:
FileAttachment
(
"Batting.csv"
)
,
people
:
FileAttachment
(
"People.csv"
)
}
)
Insert cell
db
SELECT concat(nameFirst,' ',nameLast) AS name,yearID,HR
FROM batting,people
WHERE batting.playerID == people.playerID AND teamID == 'PHI'
ORDER BY HR DESC
Insert cell
viewof
season
=
Inputs
.
range
(
[
1900
,
2022
]
,
{
step
:
1
}
)
Insert cell
philsSeaons
=
phils
.
filter
(
d
=>
d
.
yearID
==
season
)
.
slice
(
0
,
10
)
Insert cell
Plot
.
plot
(
{
marginLeft
:
150
,
x
:
{
domain
:
[
0
,
60
]
}
,
marks
:
[
Plot
.
barX
(
philsSeaons
,
{
x
:
"HR"
,
y
:
"name"
,
sort
:
{
y
:
"x"
,
reverse
:
true
}
,
fill
:
"red"
,
stroke
:
"blue"
}
)
,
Plot
.
ruleY
(
[
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.
Try it for free
Learn more
Fork
View
Export
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
db
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
phils
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
Cells
db
File attachments
People.csv
CSV
Batting.csv
CSV
Databases
season
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
philsSeaons
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML