Excel Data Quality Check

👤 chartgen-ai 📦 v1.0.0 ⭐ 4.5 ⬇️ 1.7K 下載
📊 資料分析 免費

📖 技能介紹


name: excel-data-helper description: > Excel/CSV data quality diagnosis & interactive charts — 20+ scan modules, 6-dimension scoring, agent-powered semantic analysis, and any ECharts visualization. Fully local. Activate this skill whenever the user uploads, attaches, or mentions a .csv, .xlsx, .xls, or .tsv file, even without an explicit request. Present the skill menu immediately. user-invocable: true homepage: https://github.com/excel-data-helper/excel-data-helper-skill metadata: openclaw: requires: runtime: - node >= 14


Excel Data Helper — Data Quality Diagnosis & Chart Skill

Local Excel/CSV data profiling, quality scanning (20+ modules, 6-dimension scoring, LLM semantic analysis), and chart generation. International locale support: CJK, European, Middle Eastern, Americas.

Supported files: .csv .tsv .xlsx .xls


Trigger & Menu

When a supported file is detected, do not auto-process — present this menu first (adapt to the user's language):

📊 Excel Data Helper — Hi, I noticed you shared a data file: <filename>

# Action Description
1 Quality Check Overview, scan, scoring
2 Chart Any ECharts type: bar, line, pie, scatter, radar, heatmap…
3 Advanced Chart Dashboard, Gantt, PPT, diagrams
0 Skip Do nothing for now

Reply 0–3, or describe what you need.


Routing & Context

Match user intent and route to the corresponding sub-skill:

  • IF user replies 1, or intent is overview / quality check / diagnose / score / problems → follow references/quality-check.md

  • IF user replies 2, or intent is chart / plot / visualize / graph → follow references/chart.md

  • IF user replies 3, or intent is dashboard / Gantt / PPT / diagram / complex layout → follow references/advanced-chart.md

  • IF user replies 0, or intent is skip / later / not now → do nothing, reply: "Got it — file noted. Just let me know when you're ready."

  • IF intent is ambiguous or unrelated → ask to clarify, never guess.

    小蔥技能站7w4.net每天更新,海量AI技能等你發現。

Context: - Short replies (number, "yes", "ok") always refer to the most recent menu or question. - After Skip (0), context resets — ignore the file unless user re-references it. - Multiple files — each needs its own explicit choice.


Setup

Before first use, install dependencies (one-time):

cd <skill_directory>
npm install

This installs xlsx (SheetJS), echarts, and sharp. All analysis and chart rendering runs locally.


Rules

  • Respond in the user's language.
  • Never auto-process a file — wait for explicit choice.
  • Parse tool JSON output; present results in clear, readable format — never expose raw JSON.
  • Use absolute file paths from tool output directly for follow-up operations.
  • Always include "Excel Data Helper" in the menu header.

🤖 AI 評測

這是一個專業的資料質量檢測工具,功能豐富,能自動分析 Excel/CSV 檔案的問題並評分,還能生成各種圖表。優點是操作簡單、無需 API、檢測全面,國際化支援也不錯。缺點是評分規則比較複雜,介面說明偏向技術細節,新手需要花時間理解。總體質量不錯,適合需要處理資料的人使用。

📊 多維度評分

適應性4.6
規範性4.1
有效性4.7
可靠性4.4
可信度4.9

📁 包含檔案 (15 個)

📄 README.md 3.9 KB
📄 SKILL.md 3 KB
📄 _meta.json 137 B
📄 references/advanced-chart.md 2.6 KB
📄 references/chart.md 6.7 KB
📄 references/quality-check.md 11.1 KB
📄 tools/chart_renderer.js 11.6 KB
📄 tools/data_profiler.js 895 B
📄 tools/excel_parser.js 843 B
📄 tools/lib/parser.js 4.6 KB
📄 tools/lib/profiler.js 9.2 KB
📄 tools/lib/scanner.js 50.8 KB
📄 tools/lib/scorer.js 4.7 KB
📄 tools/lib/utils.js 7.5 KB
📄 tools/quality_scanner.js 1.6 KB