In [1]:

import duckdb

In [2]:

duckdb.sql("select 42")

Out[2]:

┌───────┐
│  42   │
│ int32 │
├───────┤
│    42 │
└───────┘

In [1]:

%pip install --quiet magic-duckdb
%load_ext magic_duckdb

In [2]:

%%dql
SELECT 42;

Out[2]:

	42
0	42

In [1]:

%pip install jupysql
%env PLOOMBER_STATS_ENABLED="false"
%env PLOOMBER_VERSION_CHECK_DISABLED="false"
%load_ext sql

#https://jupysql.ploomber.io/en/latest/integrations/duckdb-native.html

env: PLOOMBER_STATS_ENABLED="false"
env: PLOOMBER_VERSION_CHECK_DISABLED="false"

In [4]:

import pandas as pd
import duckdb

conn = duckdb.connect()
df = pd.DataFrame({"x": range(10)})

In [5]:

%sql conn

In [6]:

%%sql
SELECT *
FROM df
WHERE x > 4

Running query in 'DuckDBPyConnection'

Out[6]:

x
5
6
7
8
9

In [8]:

df.to_csv("test.csv")

In [9]:

%%sql
CREATE TABLE readcsvtest AS SELECT * FROM test.csv

Running query in 'DuckDBPyConnection'

Out[9]:

Count
10

In [10]:

%%sql
SELECT *
FROM readcsvtest
LIMIT 3

Running query in 'DuckDBPyConnection'

Out[10]:

column0	x
0	0
1	1
2	2

In [ ]: