Results of 1 - 2 of about 2 for sqlplot (0.002 sec.)
- Jupyter Notebooks 11228
- DuckDB's Python client can be used directly in Jupyter notebooks with no additional configuration, as the first section shows. Additional libraries can simplify SQL query development; the rest of this guide uses the JupySQL package. See oth
...sql conn = duckdb.connect(config={"python_scan_all_frames": True}) %sql conn --alias duckdb Warning With JupySQL 0.11.1, %sqlplot boxplot fails on a native connection of DuckDB's Python client 2.0 with Aggregate Function with name percentile_disc does...ations do not keep eating up memory, efficiently plotting massive datasets. Boxplot & Histogram To create a boxplot, call %sqlplot boxplot , passing the name of the table and the column to plot. In this case, the name of the table is the path of the loc...( "https://d37ci6vzurychx.cloudfront.net/trip-data/yellow_tripdata_2021-01.parquet", "yellow_tripdata_2021-01.parquet", ) %sqlplot boxplot --table yellow_tripdata_2021-01.parquet --column trip_distance Install and Load DuckDB httpfs Extension DuckDB's h... - https://man.mtool.work/duckdb/2.0/guides/python/jupyter.html
- Troubleshooting 7485
- Troubleshooting Running EXPLAIN Renders Newlines In Python, the output of the EXPLAIN statement contains hard line breaks ( \n ): In [1]: import duckdb ...: duckdb.sql("EXPLAIN SELECT 42 AS x") Out[1]: ┌───────────────┬─────────────────────
...thon_scan_all_frames = true to query notebook DataFrames. This is needed with both native and SQLAlchemy connections. For %sqlplot boxplot , use SQLAlchemy. See the Jupyter guide for the complete setup. Ibis Fails with DuckDB 2.0 Ibis 12.0.0 fails on se... - https://man.mtool.work/duckdb/2.0/clients/python/known_issues.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work