Ibis + DuckDB example

duckdb_ibis_example.py

# pip install 'ibis-framework[duckdb]'

import pandas as pd
import ibis
from ibis import _

# create a pandas DataFrame and write it to a Parquet file
df = pd.DataFrame(data={'repo': ['pandas', 'duckdb', 'ibis'],
                        'stars': [36622, 8074, 2336]})
df.to_parquet('repo_stars.parquet')

# use Ibis and DuckDB to query the Parquet file
t = ibis.read_parquet('repo_stars.parquet')
(t
  .filter(_.repo != 'pandas')
  .order_by(_.stars)
  .execute()
)
#      repo  stars
# 0    ibis   2336
# 1  duckdb   8074

As shown at https://twitter.com/ianmcook/status/1617933102931939329