Online DuckDB Compiler

Online DuckDB Compiler and Playground.

Python
import duckdb
from urllib.request import urlretrieve

# Download a CSV file to use as the source of data
csv_path, _ = urlretrieve('https://raw.githubusercontent.com/mwaskom/seaborn-data/master/tips.csv')

# Query the downloaded CSV file using duckdb
duckdb.sql(f"SELECT * FROM read_csv('{csv_path}') LIMIT 5")
┌────────────┬────────┬─────────┬─────────┬─────────┬─────────┬───────┐
│ total_bill │  tip   │   sex   │ smoker  │   day   │  time   │ size  │
│   double   │ double │ varchar │ boolean │ varchar │ varchar │ int64 │
├────────────┼────────┼─────────┼─────────┼─────────┼─────────┼───────┤
│      16.99 │   1.01 │ Female  │ false   │ Sun     │ Dinner  │     2 │
│      10.34 │   1.66 │ Male    │ false   │ Sun     │ Dinner  │     3 │
│      21.01 │    3.5 │ Male    │ false   │ Sun     │ Dinner  │     3 │
│      23.68 │   3.31 │ Male    │ false   │ Sun     │ Dinner  │     2 │
│      24.59 │   3.61 │ Female  │ false   │ Sun     │ Dinner  │     4 │
└────────────┴────────┴─────────┴─────────┴─────────┴─────────┴───────┘