ibis_duckdb_penguins_filter_groupby_aggregate_quickstart.py

1import ibis
2from ibis import _
3
4# Use the interactive mode for pretty-printing results
5ibis.options.interactive = True
6
7# Connect to a local DuckDB database (or any other supported backend)
8con = ibis.connect("duckdb://")
9
10# Get a reference to a built-in example dataset
11t = ibis.examples.penguins.fetch()
12
13# Filter, group, and aggregate data
14query = (
15    t.filter(t.species == "Adelie")
16    .group_by("island")
17    .aggregate(
18        count=t.count(),
19        avg_bill_length=t.bill_length_mm.mean()
20    )
21    .order_by(ibis.desc("count"))
22)
23
24# Execute and display results
25print(query)