Five minutes with distance_km in ride-hail-trips

Someone asked what is in distance_km on ride-hail-trips, and the honest answer took one query.

8,000 rows, no nulls, 1,572 distinct values. Trip distance. Zero on billed cancellations.

The five-number version: min 0.00, p10 1.35, median 3.20, p90 10.69, max 43.09. The mean is 4.83.

The p10 to p90 band — 1.35 to 10.69 — is where ordinary rows live, and it is the pair worth quoting when somebody asks what to expect. Min and max describe the two strangest rows in the table and nothing else; they are useful for spotting impossible values and misleading for everything else.

select
  count(*)                      as rows,
  count(distance_km)            as present,
  count(*) - count(distance_km) as nulls,
  count(distinct distance_km)   as distinct_values
from ride_hail_trips;

The mean sits 51% above the median, which is the whole story: anything that reports the average of distance_km is reporting a number most rows are below. Put the median next to it or drop the mean.

Where this bites: a filter like distance_km > 4.83 reads as "above average" and selects a minority of rows — a smaller minority than the phrase suggests to whoever asked for it. If the request was "the typical ones", the threshold they meant was 3.20.

The grain is one row per completed trip, which is the context every one of those numbers depends on. None of them survive a change of grain, which is why "profile the column" and "profile the table" are the same job. Full schema, and the CSV, on the dataset page.