The avatar for @credmond
Charles Redmond
Public
Edited
Oct 2, 2023
3
Insert cell
Insert cell
battingFile = FileAttachment("Batting.csv").csv({typed:true})
Insert cell
peopleFile = FileAttachment("People.csv").csv({typed:true})
Insert cell
managersFile = FileAttachment("Managers.csv").csv({typed:true})
Insert cell
db = DuckDBClient.of({
batting:battingFile,
people:peopleFile,
managers:managersFile
})
Insert cell
db
SELECT DISTINCT playerID
FROM batting
WHERE 30 < (
SELECT count(yearID)
FROM managers
WHERE playerID = batting.playerID
)
Insert cell
db
SELECT playerID,count(yearID)
FROM batting
GROUP BY playerID
HAVING 20*count(yearID) < (
SELECT count(yearID)
FROM managers
WHERE playerID = batting.playerID
)
Insert cell
db
SELECT playerID,count(yearID)
FROM managers
WHERE playerID = 'alstowa01' OR playerID = 'andersp01'
GROUP BY playerID
Insert cell
db
SELECT DISTINCT playerID
FROM managers
WHERE NOT EXISTS (
SELECT playerID
FROM batting
WHERE playerID = managers.playerID
)
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