The avatar for @bayre
Ben Ayre
Public
Edited
Aug 31, 2023
2
Insert cell
Insert cell
Insert cell
stocks
with aapl_open as (
select
Date,
Open
from aapl
),

goog_open as (
select
Date,
Open
from goog
)

select *
from aapl_open
left join goog_open
using (Date)
limit 100
Insert cell
// this cell hangs, and the Array cannot be expanded
data
Insert cell
// destructuring throws a duplicate entries error
data.map(d => ({ ...d }))
Insert cell
data
-- as does creating a new SQL cell with `data` as the source
from data
Insert cell
// the Row.toJSON method works
data.map(d => d.toJSON())
Insert cell
// borrowed from "@observablehq/duckdb"
stocks = DuckDBClient.of({
aapl: FileAttachment("aapl.csv"),
goog: FileAttachment("goog.csv")
})
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