Results of 1 - 6 of about 6 for draw (0.004 sec.)
- CLI Charting with YouPlot 12228
- DuckDB can be used with CLI graphing tools to quickly pipe input to stdout to graph your data in one line. YouPlot is a Ruby-based CLI tool for drawing visually pleasing plots on the terminal. It can accept input from other programs by pipi
...and number of purchases made by somebody on that date. Using the query above, we'll pipe the data to the uplot command to draw a plot of the Top 10 Purchase Dates. duckdb -s "COPY (SELECT date, sum(purchases) AS total_purchases FROM read_json('input...LIMIT 10) TO '/dev/stdout' WITH (FORMAT csv, HEADER)" \ | uplot bar -d, -H -t "Top 10 Purchase Dates" This tells uplot to draw a bar plot, use a comma-separated delimiter ( -d, ), that the data has a header ( -H ), and give the plot a title ( -t ).... - https://man.mtool.work/duckdb/2.0/guides/data_viewers/youplot.html
- Relational API 10547
- The Relational API builds a query one step at a time from Python. A relation, a DuckDBPyRelation , is a piece of SQL text: the methods of the Transformation and Functions sections return a new relation whose text extends the one they were c
...plan the engine runs for this relation, as text; under Jupyter the default is shown as HTML. preview The first limit rows drawn as a table, with the footer __repr__ prints for the relation. query Run the given SQL query in sql_query on the view name...it. * format : str, default: None The output format, such as 'text' , 'json' , 'html' , 'graphviz' or 'yaml' . The default draws the plan as text, and as HTML under Jupyter. * analyze : bool, keyword-only, default: False Run the query and profile it,...Column Data Scan ─╮ │ ~6 rows │ ╰────────────────────╯ preview preview(self, limit: int = 10) -> str The first limit rows drawn as a table, with the footer __repr__ prints for the relation. Parameters limit : int, default: 10 The number of rows to d... - https://man.mtool.work/duckdb/2.0/clients/python/relational_api.html
- Guides 9194
- The guides section contains compact how-to guides that are focused on achieving a single goal. For API references and examples, see the rest of the documentation. Note that there are many tools using DuckDB, which are not covered in the off
...tudio SQL editor How to set up the VisuaLeaf SQL editor Data Viewers How to visualize DuckDB databases with Tableau How to draw command-line plots with DuckDB and YouPlot Snippets Creating synthetic data Dutch railway datasets Sharing macros Analyzin... - https://man.mtool.work/duckdb/2.0/guides/overview.html
- Create Synthetic Data 8518
- DuckDB lets you quickly generate synthetic datasets by combining a few building blocks: functions and clauses that generate rows , functions that generate values to fill those rows, and extensions that generate whole benchmark datasets. Thi
...es it. VALUES The VALUES clause generates rows from literal tuples, which is convenient for a small fixed set of values to draw from: SELECT * FROM (VALUES ('Alice', 'Engineering'), ('Bob', 'Sales')) t(name, department); ┌─────────┬─────────────┐ │ n... - https://man.mtool.work/duckdb/2.0/guides/snippets/create_synthetic_data.html
- DuckDB_% Metadata Functions 7494
- DuckDB offers a collection of table functions that provide metadata about the current database. These functions reside in the main schema and their names are prefixed with duckdb_ . The resultset returned by a duckdb_ table function may be
...lue The maximum value of the sequence. BIGINT increment_by The value that is added to the current value of the sequence to draw the next value from the sequence. BIGINT cycle Whether the sequence should start over when drawing the next value would re...sult in a value outside the range. BOOLEAN last_value The last value drawn from the sequence using nextval(...) , or NULL if no value was ever drawn. BIGINT sql The definition of this object, expr...hey were not explicitly specified in the CREATE SEQUENCE statement. The last_value column contains the last value that was drawn from the sequence, or NULL if a value was never drawn from the sequence. If the sequence cycles, then the sequence will s... - https://man.mtool.work/duckdb/2.0/sql/meta/duckdb_table_functions.html
- Python Client API 6818
- Connection class duckdb. Appender Bases: object append_row ( self , * args ) → None Buffer one row, one value per column, each converted as an executemany parameter would be append_rows ( self , rows : object ) → None Buffer each row of an
...DataFrame. Detailed examples can be found at Relational API page . preview ( limit : int = 10 ) → str The first limit rows drawn as a table, with the footer __repr__ prints for the relation. Detailed examples can be found at Relational API page . pro...None , method : str | None = None ) → DuckDBPyRelation A random subset: n rows, or percent of them, with seed repeating a draw. Detailed examples can be found at Relational API page . select ( * args : object , groups : str = '' ) → DuckDBPyRelation... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work