ibis_duckdb_penguins_dataset_exploration_and_filtering.py

1import ibis
2from ibis import selectors as s
3
4# Set up the interactive mode for easy exploration
5ibis.options.interactive = True
6
7# Connect to the default DuckDB backend and load the penguins dataset
8con = ibis.connect("duckdb://")
9t = ibis.examples.penguins.fetch()
10
11# Inspect the table
12print(t.head())
13
14# Filter, group by, and aggregate data
15result = (
16    t.filter(t.species == "Adelie")
17    .group_by("island")
18    .aggregate(
19        count=t.count(),
20        avg_bill_length=t.bill_length_mm.mean()
21    )
22)
23
24print(result)