The avatar for @hhc9106
HaoChe
Public
Edited
Nov 8, 2023
Fork of DuckDB demo
2
Insert cell
Insert cell
Insert cell
Insert cell
client = DuckDBClient.of({
meetings: FileAttachment("AA_meeting_all@4.csv"),
reviews: reviewData
})
Insert cell
Insert cell
client
SELECT *
FROM meetings;
Insert cell
Insert cell
client
SELECT *
FROM reviews;
Insert cell
Insert cell
client
SELECT *
FROM meetings
WHERE date = 'Wednesdays';
Insert cell
Insert cell
client
SELECT "id", "GROUP_NAME", Date, time, review
FROM meetings
LEFT OUTER JOIN reviews ON meetings.id = reviews.username
ORDER BY id;
Insert cell
data
Type Table, then Shift-Enter. Ctrl-space for more options.

Insert cell
Insert cell
client
SELECT DISTINCT latitude, longitude
FROM meetings;
Insert cell
Insert cell
client
SELECT DISTINCT "street_address"
FROM meetings;
Insert cell
Insert cell
client
SELECT *
FROM meetings
WHERE Date = 'Wednesdays';
Insert cell
wednesdays
Insert cell
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