Keyboard shortcuts

Press ← or → to navigate between chapters

Press S or / to search in the book

Press ? to show this help

Press Esc to hide this help

Demos

Two recordings of datasets from Example datasets on the home screen, each opened as its publisher serves it. The guides below walk through every step.

When should I fly out of JFK?

NYC flights (2013): 336,776 departures from New York’s three airports. The recording sorts by dep_delay, inspects the worst row, then charts the mean departure delay by hour, one line per origin. At JFK the mean delay climbs from 0.5 minutes at 5:00 to 26.1 at 21:00. The data is from 2013, so this is not a forecast.

datui opening NYC flights, sorting by delay and charting the mean delay by hour per airport

Do it yourself: Query data and Make a chart.

A public bucket, opened in place

NOAA daily weather (GHCN-D) on S3, with no login. The recording opens Central Park’s 155 years of daily highs from the catalog’s bookmark and charts them by year. Then it opens a whole year of the bucket, s3://noaa-ghcn-pds/parquet/by_year/YEAR=2024/, as one table and scrolls to its last row. The waits are real, and nothing is downloaded whole.

datui charting Central Park highs from NOAA’s S3 bucket, then opening and scrolling 38 million rows of 2024

Recorded 2026-10-05 with datui 0.4.0-dev on an 8-core Ryzen 7 9800X3D, over a wired home connection, with a cold cache. YEAR=2024 opened its 135 files as one table of 38,466,379 rows in about a second. Your times depend on your connection and the bucket.

Do it yourself: Connect to cloud storage.

More examples

QuestionDatasetGuide
Which species is heaviest?Palmer penguinsQuick start
Which airlines arrive late, and where does AS fly?NYC flights (2013)Query data
Which matches had the most goals?Premier League (2020-21)Dates and messy text
The highest-calorie chicken dishesFood nutrition (fast food)Sort, filter and arrange columns
Emma, Jennifer and Olivia by yearUS baby names (1880-2017)Pivot and melt
Every chart on the built-in dataSeveralMake a chart
One query, two years of weatherNOAA daily weather (GHCN-D)Save and apply views