← 返回 Skills 市场
Csv Analyzer
作者
Shihao Jiang (Zac)
· GitHub ↗
· v1.0.0
987
总下载
0
收藏
5
当前安装
1
版本数
在 OpenClaw 中安装
/install csv-analyzer
功能描述
Analyze CSV/Excel files with natural language. Get statistics, filter rows, find anomalies, generate summaries, and export results. No pandas needed — uses P...
使用说明 (SKILL.md)
CSV Analyzer
Analyze CSV files with simple commands. Get instant statistics, filter data, detect anomalies, and export results — all without pandas or heavy dependencies.
Usage
Quick stats
python3 {baseDir}/scripts/csv_analyze.py stats data.csv
Shows row count, column types, min/max/mean for numeric columns, unique counts for text columns.
Filter rows
python3 {baseDir}/scripts/csv_analyze.py filter data.csv --where "amount>1000" --output big_orders.csv
Top/Bottom N
python3 {baseDir}/scripts/csv_analyze.py top data.csv --column revenue --n 10
python3 {baseDir}/scripts/csv_analyze.py bottom data.csv --column revenue --n 5
Detect anomalies (values outside 2σ)
python3 {baseDir}/scripts/csv_analyze.py anomalies data.csv --column price
Group and aggregate
python3 {baseDir}/scripts/csv_analyze.py group data.csv --by category --agg "sum:amount" "count:id"
Features
- 📊 Automatic column type detection (numeric, date, text)
- 🔍 Flexible filtering with comparison operators
- 📈 Statistical summary (mean, median, std, min, max, percentiles)
- 🚨 Anomaly detection (z-score based)
- 📋 Grouping and aggregation
- 💾 Export filtered/processed results
- 🪶 Zero external dependencies — Python stdlib only (csv module)
Dependencies
None! Uses only Python standard library.
Why Not Pandas?
Pandas is great but:
- Takes 100MB+ RAM just to import
- Overkill for quick analysis tasks
- This skill runs on 2GB RAM servers without issues
- For truly large datasets, the agent can recommend installing pandas
Limitations
- Designed for files up to ~100MB (loads into memory)
- For larger files, use streaming mode or install pandas
- Date parsing is basic (ISO format preferred)
安全使用建议
This skill appears to be what it says: a lightweight, local CSV analyzer. Before installing or running it, consider: (1) it will read any file path you provide — don't point it at system secrets or files you don't want processed; (2) outputs are written as CSV and opening them in spreadsheet software can expose CSV/Excel formula-injection risks if the source data contains formulas (sanitize or inspect exported files before opening in Excel); (3) the filter command limits column names to alphanumeric/underscore (no spaces) and numeric comparisons use eval on a constrained operator token — while that is limited, avoid running it on untrusted or specially-crafted files if you have strong threat concerns; (4) for very large files (>100MB) this script loads into memory and may be slow; consider using a streaming tool or pandas for big datasets. Overall, there are no hidden network endpoints or credential requests, and the code matches the documentation.
功能分析
Type: OpenClaw Skill
Name: csv-analyzer
Version: 1.0.0
The skill provides legitimate CSV analysis functionality but contains high-risk coding practices in `scripts/csv_analyze.py`. Specifically, the `cmd_filter` function uses the `eval()` built-in to perform numerical comparisons. While the implementation currently attempts to sanitize inputs using a restrictive regular expression and `float()` casting, the use of `eval()` on data-derived strings is a classic vulnerability pattern. Additionally, the `cmd_group` function lacks robust error handling for the `--agg` argument, which could lead to application crashes.
能力评估
Purpose & Capability
Name/description (lightweight CSV analysis) align with the included Python script and SKILL.md. The script implements stats, filtering, top/bottom, anomaly detection, grouping, and export using only the Python stdlib — consistent with the stated purpose. No extraneous env vars, binaries, or config paths are requested.
Instruction Scope
SKILL.md instructs running the included script against local CSV files; the script only reads supplied file paths and writes an optional output CSV. There are no network calls or references to unrelated system files. Minor note: the filter implementation uses eval(...) for numeric comparisons, but the operator token is constrained by a regex to a small set of comparison operators, and values are cast to float for numeric comparisons, so risk is limited. Also, the filter regex restricts column names to \w+ (no spaces/special chars), which is a usability limitation rather than a security mismatch.
Install Mechanism
No install spec; the skill is instruction-only with a single Python script included. Nothing is downloaded or written at install time.
Credentials
The skill requires no environment variables, credentials, or config paths — appropriate for a local CSV analyzer that operates on user-supplied files.
Persistence & Privilege
always is false and the skill does not request persistent/system-wide changes. It does not modify other skills or agent config; standard autonomous invocation settings apply.
如何使用
- 确保已安装 OpenClaw（本地或 Docker 部署）
- 在对话框中输入安装命令：
/install csv-analyzer - 安装完成后，直接呼叫该 Skill 的名称或使用
/csv-analyzer触发 - 根据 Skill 的参数说明提供必要输入，即可获得结构化输出
版本历史
v1.0.0
Initial release of csv-analyzer — a lightweight tool for CSV/Excel file analysis using only the Python standard library.
- Analyze, filter, and generate statistics from CSV files without pandas.
- Features include statistics summary, flexible row filtering, top/bottom N values, anomaly detection, and group aggregation.
- Supports exporting processed and filtered data.
- Zero external dependencies; optimized for low-memory environments.
- Designed for datasets up to ~100MB in size.
元数据
常见问题
Csv Analyzer 是什么？
Analyze CSV/Excel files with natural language. Get statistics, filter rows, find anomalies, generate summaries, and export results. No pandas needed — uses P... 它是一个面向 Claude Code / OpenClaw 的 AI Agent Skill 插件，目前累计下载 987 次。
如何安装 Csv Analyzer？
在 OpenClaw 或 Claude Code 对话框中运行命令「/install csv-analyzer」即可一键安装，无需额外配置。
Csv Analyzer 是免费的吗？
是的，Csv Analyzer 完全免费（开源免费），可自由下载、安装和使用。
Csv Analyzer 支持哪些平台？
Csv Analyzer 跨平台运行，可在任意部署了 OpenClaw / Claude Code 的环境中使用（cross-platform）。
谁开发了 Csv Analyzer？
由 Shihao Jiang (Zac)（@zacjiang）开发并维护，当前版本 v1.0.0。
推荐 Skills