Querying DuckDB into Polars

The team also has a local DuckDB analytical store. A connection is already open, and a physical_format_summary table is loaded for you. DuckDB has its own integration with Polars: query the table and convert the result to a Polars DataFrame in one step.

polars is loaded as pl, and the DuckDB connection is in db.

Diese Übung ist Teil des Kurses

<Kurs>Scaling and Optimizing Data Pipelines with Polars</Kurs>

Kurs ansehen

Übungsanweisungen

Run the SQL query on the DuckDB connection.
Convert the DuckDB result to a Polars DataFrame.

Interaktive praktische Übung

Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.

# Run the query and convert the result to a Polars DataFrame
result = db.____(
    """
    SELECT *
    FROM physical_format_summary
    ORDER BY total_checkouts DESC
    """
).____()
print(result)

Code bearbeiten und ausführen