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

One platform to build and deploy the best data apps

Experiment and prototype by building visualizations in live JavaScript notebooks. Collaborate with your team and decide which concepts to build out.
Use Observable Framework to build data apps locally. Use data loaders to build in any language or library, including Python, SQL, and R.
Seamlessly deploy to Observable. Test before you ship, use automatic deploy-on-commit, and ensure your projects are always up-to-date.
Learn more