The avatar for @aaronxhill
Aaron Hill
Public
Edited
Nov 1, 2023
8 forks
1 star
1
Insert cell
Insert cell
reviewData = [{"username": 3, "review": "I love this meeting"}, {"username": 5, "review": "This meeting never starts on time"}, {"username" : 17, "review": "The people here are wonderful, but the coffee isn't very good"}]
Insert cell
Insert cell
client = DuckDBClient.of({
meetings: FileAttachment("my_aadata-2.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 Day = 'Wednesdays';
Insert cell
Insert cell
client
SELECT column00, "Meeting Name", Day, "Start Time", review
FROM meetings
LEFT OUTER JOIN reviews ON meetings.column00 = reviews.username
ORDER BY column00;
Insert cell
Insert cell
client
SELECT DISTINCT Latitiude, Longitude
FROM meetings;
Insert cell
Insert cell
client
SELECT DISTINCT "Street Address"
FROM meetings;
Insert cell
Insert cell
client
SELECT *
FROM meetings
WHERE Day = '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