Export To Pandas
Version 0.3.3

How to export data to a Pandas DataFrame

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

import duckdb
import pandas

# connect to an in-memory database
con = duckdb.connect()

my_df = pandas.DataFrame.from_dict({'a': [42]})

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