Query processing and transformation of array-backed data tables. Wrangle, tidy, and analyze your data.

Jeffrey Heer

UW Interactive Data Lab

Arquero

Introducing Arquero

An Illustrated Guide to Arquero Verbs

Tidy Data in JavaScript

Working with Window Queries

Arquero Cookbook

Adding Aggregate Functions to Arquero

Arquero Roll-Up and Drill-Down

Arquero Row Manipulation

Arquero and Apache Arrow

Arquero and D3

Multi-Line Chart Data Preparation

Peeking into the Gaia Star Catalog

A list of the top 10 notebooks that were most liked by the Observable community.

Observable

Top 10 Liked notebooks created by the community in 2020

It seems like if we distinct by `brewery_id`, we get different counts. Some brewery names are not unique. Maybe that's intentional ;-)

Dominik Moritz

There are likely errors in the data in which the same brewery has multiple entries (same name, different id), so using brewery-name is actually a bit more accurate. However, I think that is a data cleaning issue that should be resolved separately, and this example is probably better off using the id to determine distinctness here. Thanks!

breweries.csv

beer.csv