1.7.5 Distinct destinations🔗ℹ

(table-shape (table-distinct subset '(dest)))

; => 105 3

> (~> subset (select "dest") unique height)

96

> (~> subset (select (n-unique "dest")))

shape: (1, 1) ┌──────┐ │ dest │ │ ---  │ │ u32  │ ╞══════╡ │ 96   │ └──────┘

The sample has 96 of the 105 destinations. API gap: unique takes no subset of columns (#134), so it cannot keep the other columns as table-distinct does; each group’s first row gives the post’s shape:

> (~> subset (group-by "dest") (agg (first "distance") (first "dep_delay")) shape)

'(96 3)