Install Skills directly in chat.Install the MochiLab Skills assistant in OpenClaw, connect your account, then find, install and update Skills in chat.
See how to connect →
MOCHILAB / AI SKILL
CSV Cleaning and Analysis
Clean CSV/TSV, review missing and duplicate values, and total exact amounts by an explicit grouping column.
Features
Read UTF-8 CSV/TSV with BOMs, quoted delimiters and multiline cells. Export column statistics, missing-value and duplicate reports, plus formula-protected CSV. Decimal totals use exact arithmetic.
Exact duplicate rows are removed by default; use --keep-duplicates for repeated transactions. Select the grouping and amount columns to total each currency separately, with missing and invalid amounts listed.
Usage examples
After installation, send any example below to your AI. Include the files or URLs it refers to.
Check orders.csv for missing values and exact duplicate rows, and produce a data-quality report.
Clean this CSV by removing exact duplicate rows, retaining the original and saving a new result.
Group the amount column by customer and currency, use exact decimal arithmetic, and export a summary CSV.
Advanced usage: run in a terminal
These commands are for manual execution in the terminal on the computer or server running OpenClaw. For everyday use, send one of the chat examples above.
Replace these placeholders with actual paths before running:
SKILL_DIRECTORY: the installed Skill folder.INPUT.csv: the input CSV file.NEW_OUTPUT_DIRECTORY: a new output directory.
node "SKILL_DIRECTORY/scripts/csv.mjs" --input "INPUT.csv" --out "NEW_OUTPUT_DIRECTORY" --group-by "currency" --sum-column "amount" --keep-duplicates
Replace paths and column names with the actual values. Try samples/currency-input.en.csv for the bundled English example.