ibis_duckdb_penguins_filter_groupby_aggregation.py

1import ibis
2from ibis import selectors as s
3
4# Set up the interactive mode for easy viewing
5ibis.options.interactive = True
6
7# Connect to the default DuckDB backend and fetch the penguins dataset
8con = ibis.connect("duckdb://")
9t = ibis.examples.penguins.fetch()
10
11# Perform a simple analysis: filter by species, group by island, and calculate the mean bill length
12query = (
13    t.filter(t.species == "Adelie")
14    .group_by("island")
15    .aggregate(mean_bill_length=t.bill_length_mm.mean())
16)
17
18# Display the result
19print(query)