Results of 1 - 2 of about 2 for boxplot (0.001 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
...n = 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 not exis...t! . To plot a boxplot, connect via SQLAlchemy. Warning Variables are not recognized within a native DuckDB connection. Connecting to DuckDB via...the engine and ensures that intermediate computations 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 cas... - 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]: ┌───────────────┬─────────────────────
..., a query that scans a pyarrow.RecordBatchReader whose batches come from a Python generator can hang. DataFrame Queries or Boxplots Fail in JupySQL With JupySQL 0.11.1, run %sql SET python_scan_all_frames = true to query notebook DataFrames. This is nee...ded 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 several op... - https://man.mtool.work/duckdb/2.0/clients/python/known_issues.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work