2 ms·
Exactly. In my DuckDB workflow I use Pandas data frames and DuckDB queries interchangeably. import duckdb as db import pandas as pd df = pd.read_excel(
by wenc 4y ago
Exactly. In my DuckDB workflow I use Pandas data frames and DuckDB queries interchangeably.
import duckdb as db
import pandas as pd
df = pd.read_excel(“z.xlsx”)
df2 = db.query(“select * from df join ‘s3://bucket/a.parquet’ b on df.col b.col”).df()
df3 = df2.col.apply(lambda x: x)
DuckDB can refer any Pandas data frame in the namespace as a SQL object. You can query across Parquet, CSV and Pandas data frames seamlessly.
Need to join Excel with Parquet with CSV? No problem. You can do it all within DuckDB.