Results of 1 - 2 of about 2 for jupysql (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
...expression displays a table in the notebook. Add .df() to keep the result as a pandas DataFrame. Library Installation This JupySQL workflow is also available as a Google Colab notebook . Four additional libraries improve the DuckDB experience in Jupyter...notebooks. jupysql : Convert a Jupyter code cell into a SQL cell Pandas : Clean table visualizations and compatibility with other analysis ma...all Jupyter Notebook: pip install notebook Or JupyterLab: pip install jupyterlab Install supporting libraries: pip install jupysql pandas matplotlib duckdb-engine Library Import and Configuration Open a Jupyter Notebook and import the relevant libraries... - 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]: ┌───────────────┬─────────────────────
...rns an empty string, so printing it prints nothing. Please also check out the Jupyter guide for tips on using Jupyter with JupySQL. Crashes and Errors on Windows When importing DuckDB on Windows, the Python runtime may crash or return an error upon impo...ans 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 needed with both nat...ils on several operations with DuckDB 2.0, such as list_tables() . See the Ibis guide . DESCRIBE Returns an Empty Table in JupySQL In JupySQL, the DESCRIBE statement returns an empty table: %%sql CREATE OR REPLACE TABLE tbl AS (SELECT 42 AS x); DESCRIBE... - https://man.mtool.work/duckdb/2.0/clients/python/known_issues.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work