The avatar for @myagues
myagues
Published
Edited
Jun 15, 2022
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
dbClient
select seasonNumber, episodeNumber, episodeTitle, averageRating
from ratings
-- TODO: ugly workaround for the map seriesTitle to parentTconst in Input.text
where seriesID = concat('tt', ${s.tvTitle.split(" ").slice(-1)[0].slice(1)}) and seasonNumber > 0
Insert cell
dbClient
select seriesID, seriesTitle, min(startYear) as startYear
from ratings
group by seriesID, seriesTitle
order by seriesTitle, startYear
Insert cell
dbClient
select seriesID, seriesTitle from ratings limit 100
Insert cell
dbClient.describe("ratings")
Insert cell
dbClient = {
const client = new DuckDBClient();
await client.query(`
CREATE TABLE 'ratings' AS SELECT * FROM read_parquet([
'https://media.githubusercontent.com/media/myagues/datasets/main/imdb/75784262d7844154b3eb0fc10255c84a.parquet'
])
`);
return client;
}
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