Results of 1 - 1 of about 1 for Purchase (0.000 sec.)
- CLI Charting with YouPlot 9414
- 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
...FROM read_json('input.json')" To prepare the data for YouPlot, write a simple aggregate: batch duckdb -s "SELECT date, sum(purchases) AS total_purchases FROM read_json('input.json') GROUP BY 1 ORDER BY 2 DESC LIMIT 10" Finally, wrap the SELECT in the COP...DER); The full DuckDB command below outputs the query in CSV format with a header: batch duckdb -s "COPY (SELECT date, sum(purchases) AS total_purchases FROM read_json('input.json') GROUP BY 1 ORDER BY 2 DESC LIMIT 10) TO '/dev/stdout' WITH (FORMAT csv,...to YouPlot Finally, the data can now be piped to YouPlot! Let's assume we have an input.json file with dates 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... - https://man.mtool.work/duckdb/2.0/guides/data_viewers/youplot.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work