Results of 1 - 6 of about 6 for cell (0.006 sec.)
- marimo Notebooks – DuckDB 12813
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...etting 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/1.3/guides/python/marimo.html
- Jupyter Notebooks – DuckDB 9998
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...nstallation 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 , the default connection or a file backed database: % sql duckdb...ery results will be displayed as a Pandas DataFrame. % sql SELECT 'Off and flying!' AS a_duckdb_column ; An entire Jupyter cell can be used as a SQL cell by placing %%sql at the start of the cell. Query results will be displayed as a Pandas DataFrame... - https://man.mtool.work/duckdb/1.3/guides/python/jupyter.html
- Excel Import – DuckDB 8682
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...; 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, the range is automatically inferred 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/1.3/guides/file_formats/excel_import.html
- Directly Reading Files – DuckDB 7805
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ng filesystem is unable to provide some of this data due (e.g., because HTTPFS can't always return a valid timestamp), the cell is set to NULL instead. Support for Projection Pushdown The table functions also utilize projection pushdown to avoid comp... - https://man.mtool.work/duckdb/1.3/guides/file_formats/read_file.html
- Importing Duckbox Tables – DuckDB 7805
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...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/1.3/guides/snippets/importing_duckbox_tables.html
- Excel Extension – DuckDB 7713
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...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 cant be cas...t 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/1.3/core_extensions/excel.html
PREV
1
NEXT
DuckDB 1.3 Documentation / man.mtool.work