Export to Pandas
Version 0.9.2

The result of a query can be converted to a Pandas DataFrame using the df() function.

import duckdb

# read the result of an arbitrary SQL query to a Pandas DataFrame
results = duckdb.sql("SELECT 42").df()
Search Shortcut cmd + k | ctrl + k