ibis_duckdb_csv_table_filter_and_aggregation.py

1import ibis
2from ibis import _
3
4# Connect to the default DuckDB backend
5con = ibis.duckdb.connect()
6
7# Fetch an example dataset (penguins)
8t = ibis.examples.penguins.fetch()
9
10# Perform an interactive query: 
11# Filter for Gentoo species, group by island, and calculate the mean bill length
12query = (
13    t.filter(t.species == "Gentoo")
14    .group_by("island")
15    .aggregate(mean_bill_length=t.bill_length_mm.mean())
16)
17
18# Execute and display the results
19result = query.execute()
20print(result)