Chart MPL#

Generate chart images from CSV files with scripts/chart_mpl.py.

Setup#

Create a virtual environment and install matplotlib (one-time):

bash

python3 -m venv ~/.openclaw/workspace/.venv_chart
~/.openclaw/workspace/.venv_chart/bin/pip install matplotlib

Quick start#

Run from workspace root:

bash

~/.openclaw/workspace/.venv_chart/bin/python skills/chart-mpl/scripts/chart_mpl.py \
  --csv /path/to/data.csv \
  --xcol Mois \
  --ycol Valeur \
  --kind line \
  --title "Monthly trend" \
  --xlabel "Month" \
  --ylabel "Value"

Output defaults to: ~/.openclaw/workspace/exports/images

Inputs#

• --csv path to CSV file
• --xcol column for X axis
• --ycol numeric column(s) for Y axis — comma-separated for multi-series (e.g. Sales,Costs)
• --kind chart type: line, bar, hbar, pie, stacked, scatter, area
• Optional: --delim if auto-detection fails ( ;, ,, \t, |)
• Optional: --out custom output path (PNG or SVG — format detected from extension)
• Optional: --title, --xlabel, --ylabel
• Optional: --top N show only top N categories by value (bar, hbar, pie, stacked). Multi-series ranks by row total.
• Optional: --sort sort data before plotting: x-asc, x-desc, y-desc, none (default: none)
• Optional: --numfmt number format on Y axis: fr (1,5M) or en (1.5M) — default: fr

Chart types#

KindDescriptionMulti-serieslineLine chart with markersyesbarVertical bar chart (grouped when multi-series)yeshbarHorizontal bar chart (grouped when multi-series)yespiePie chart (first Y column only)nostackedStacked vertical bar (requires 2+ Y)yesscatterScatter plotyesareaFilled area chartyes

Notes#

• Script auto-detects delimiters when possible.
• Script tolerates European and US numeric formats ( 1 234,56, 1,234.56).
• Non-numeric values in ycol are converted to NaN with a warning.
• Handles BOM-encoded CSV files ( utf-8-sig).
• Multi-series charts automatically show a legend and cycle through an 8-color palette.
• Y-axis ticks use human-readable formatting (K, M, G suffixes) with French or English decimals.
• --top N keeps the N highest categories. For pie charts, the remainder is aggregated into an "Other" slice. For bar/hbar/stacked, the rest are excluded.
• Output format (PNG or SVG) is detected from the --out file extension. Default is PNG.

End-to-end flow with SQL skill#

1. Export query result to CSV using the mssql skill.
2. Run this script on that CSV.
3. Share the generated PNG path.