Results of 1 - 4 of about 4 for plots (0.001 sec.)
- CLI Charting with YouPlot 12242
- 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
...ng data from stdin . It takes tab-separated (or delimiter of your choice) data and can easily generate various types of plots including bar, line, histogram and scatter. With DuckDB, you can write to the console ( stdout ) by using the TO '/dev/std... - https://man.mtool.work/duckdb/2.0/guides/data_viewers/youplot.html
- Guides 9061
- 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
...ow 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 Analyzing a Git repository... - https://man.mtool.work/duckdb/2.0/guides/overview.html
- Jupyter Notebooks 8358
- 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
...plot and the number of bins. This uses --with short_trips so JupySQL uses the query defined previously and therefore only plots a subset of the data. %sqlplot histogram --table short_trips --column trip_distance --bins 10 --with short_trips Summary Y... - https://man.mtool.work/duckdb/2.0/guides/python/jupyter.html
- Window Functions 7286
- DuckDB supports window functions , which can use multiple rows to calculate a value for each row. Window functions are blocking operators , i.e., they require their entire input to be buffered, making them one of the most memory-intensive o
...timized for windowing, and we can use the window syntax to write queries that generate the data for moving box-and-whisker plots: SELECT "Plant", "Date", min("MWh") OVER seven AS "MWh 7-day Moving Minimum", quantile_cont("MWh", [0.25, 0.5, 0.75]) OVER... - https://man.mtool.work/duckdb/2.0/sql/functions/window_functions.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work