Results of 1 - 9 of about 9 for cell (0.001 sec.)
- marimo Notebooks 13265
- marimo is an open-source reactive notebook for Python and SQL that's tightly integrated with DuckDB's Python client, letting you mix and match Python and SQL in a single git-versionable notebook. Unlike traditional notebooks, when you run a
...cell or interact with a UI element, marimo automatically (or lazily) runs affected cells, keeping code and outputs consistent....tutorial: marimo tutorial sql SQL in marimo Create a notebook from your terminal with marimo edit notebook.py . Create SQL cells in one of three ways: Right-click the + button and pick SQL cell Convert any empty cell to SQL via the cell menu Hit the...SQL button at the bottom of your notebook In marimo, SQL cells give the appearance of writing SQL while being serialized as standard Python code using the mo.sql() function, which keep... - https://man.mtool.work/duckdb/2.0/guides/python/marimo.html
- Jupyter Notebooks 10892
- 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
...er guides in the Python section for how to use DuckDB and Python together. Querying in a Python Cell In a plain Python cell, duckdb.sql runs a query and finds a pandas DataFrame by its variable name: import duckdb import pa...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 matplotlib : Plotting with Pytho...upysql will auto-detect the driver needed based on the connection string! # Import jupysql Jupyter extension to create SQL cells %load_ext sql Either connect to a new in-memory DuckDB or a file-backed database: %sql duckdb:///:memory: %sql duckdb:///... - https://man.mtool.work/duckdb/2.0/guides/python/jupyter.html
- Excel Import 9185
- DuckDB supports reading Excel .xlsx files. However, .xls files are not supported. Importing Excel Sheets Use the read_xlsx function in the FROM clause of a query: SELECT * FROM read_xlsx('test_excel.xlsx'); Alternatively, you can omit the r
...; By default, the first sheet is loaded if no sheet is specified. Importing a Specific Range To select a specific range of cells, use the range parameter with a string in the format A1:B2 , where A1 is the top-left cell and B2 is the bottom-right cel...sx', range = 'E:Z'); If no range parameter is provided, DuckDB automatically infers the range as the rectangular region of cells between the first row of consecutive non-empty cells and the first empty row spanning the same columns. By default, if no...an Excel file into an existing table, the types of the columns in the target table will be used to coerce the types of the cells in the Excel sheet. Importing a Sheet with/without a Header To treat the first row as containing the names of the resulti... - https://man.mtool.work/duckdb/2.0/guides/file_formats/excel_import.html
- Agent Mode 8052
- New Agent mode was introduced in DuckDB 2.0. Agent mode renders the CLI's output for consumption by an AI coding agent rather than a human at a terminal. It produces compact Markdown tables with explicit result limits, machine-readable erro
...10,000 bytes is rendered whole; a larger result is rendered as its first and last rows together with the total row count. Cells are truncated at 500 characters. These limits can be adjusted with dot commands : Dot command Description .maxrows ⟨count...r of rows to render whole ( -1 for all) .maxbytes ⟨count⟩ Maximum number of bytes of rows to render whole ( 0 for all) .maxcellwidth ⟨count⟩ Maximum number of characters per cell ( 0 for all) Tips for Agents The .help agent command prints a summary o... - https://man.mtool.work/duckdb/2.0/clients/cli/agent_mode.html
- Dot Commands 7962
- Dot commands are available in the DuckDB CLI client. To use one of these commands, begin the line with a period ( . ) immediately followed by the name of the command you wish to execute. Additional arguments to the command are entered, spac
...manual section .maxbytes ⟨COUNT⟩ Sets the maximum number of bytes of rows for display ( 0 = all). Only for agent mode .maxcellwidth ⟨COUNT⟩ Sets the maximum number of characters per cell ( 0 = all). Only for agent mode .maxrows ⟨COUNT⟩ Sets the maxi....maxbytes COUNT Sets the maximum number of bytes of rows for display (0 = all). Only for markdown mode in -agent mode. .maxcellwidth COUNT Sets the maximum number of characters per cell (0 = all). Only for markdown mode in -agent mode. .maxrows COUNT... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
- Directly Reading Files 7962
- DuckDB allows directly reading files via the read_text and read_blob functions. These functions accept a filename, a list of filenames, or a glob pattern. They output the content of each file as a VARCHAR or BLOB , respectively, along with
...tadata When the underlying filesystem cannot provide this data (e.g., HTTPFS may not always return a valid timestamp), the cell is set to NULL instead. Support for Projection Pushdown These table functions also use projection pushdown to avoid comput... - https://man.mtool.work/duckdb/2.0/guides/file_formats/read_file.html
- Importing Duckbox Tables 7962
- The scripts provided in this page work on Linux, macOS, and WSL. By default, the DuckDB CLI client renders query results in the duckbox format , which uses rich, ASCII-art inspired tables to show data. These tables are often shared verbatim
...is script: This approach only works if the table does not have long pipe │ characters. It also trims spaces from the table cell values. Make sure to factor in these assumptions when running the script. The script is compatible with both BSD sed (whic... - https://man.mtool.work/duckdb/2.0/guides/snippets/importing_duckbox_tables.html
- Excel Extension 7801
- The excel extension provides functions to format numbers per Excel's formatting rules by wrapping the i18npool library and to read/write Excel ( .xlsx ) files. However, please note that .xls files are not supported. Installing and Loading T
...The name of the sheet in the xlsx file to read. Default is the first sheet. all_varchar BOOLEAN false Whether to read all cells as containing VARCHAR s. ignore_errors BOOLEAN false Whether to ignore errors and silently replace cells that can't be ca...st to the corresponding inferred column type with NULL 's. range VARCHAR automatically inferred The range of cells to read, in spreadsheet notation. For example, A1:B2 reads the cells from A1 to B2. If not specified the resulting range...will be inferred as rectangular region of cells between the first row of consecutive non-empty cells and the first empty row spanning the same columns. stop_at_empty BOO... - https://man.mtool.work/duckdb/2.0/core_extensions/excel.html
- Typecasting 7711
- Typecasting is an operation that converts a value in one particular data type to the closest corresponding value in another data type. Like other SQL engines, DuckDB supports both implicit and explicit typecasting. Explicit Casting Explicit
...a cast the system also performs implicitly ; E marks a cast that is only available explicitly (with CAST or :: ); an empty cell marks an unsupported cast. Even where a cast is supported, it may still fail at runtime for a particular value (for exampl... - https://man.mtool.work/duckdb/2.0/sql/data_types/typecasting.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work