Public
Edited
Feb 20, 2023
1 fork
1 star
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
df = dtFromParquet(FileAttachment("yellow_tripdata_2021-01.parquet"))
Insert cell
df.view()
Insert cell
Insert cell
Insert cell
Type JavaScript, then Shift-Enter. Ctrl-space for more options. Arrow ↑/↓ to switch modes.

Insert cell
// Roger names the .csv dataframe `taxi`
taxi = df
Insert cell
Insert cell
Insert cell
Insert cell
taxi.columnNames()
Insert cell
Insert cell
Insert cell
taxi.columns()
Insert cell
Insert cell
tooEarly = {
const jan1 = new Date("2021-01-01");
return taxi.filter(
aq.escape((ride) => ride.tpep_pickup_datetime < jan1)
);
}
Insert cell
tooEarly.view()
Insert cell
op.min(tooEarly.column("tpep_pickup_datetime")).fields[0]
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
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