// 分析Excel/CSV字段结构，AI自动生成中英文映射，验证翻译质量，输出统计报告。用于电子表格分析、数据字典创建、字段映射场景。
| name | excel-field-analyzer |
| description | 分析Excel/CSV字段结构，AI自动生成中英文映射，验证翻译质量，输出统计报告。用于电子表格分析、数据字典创建、字段映射场景。 |
| allowed-tools | Read, Bash, Write, Glob, Grep |
智能分析 Excel 与 CSV 文件，自动生成中英文字段映射、统计报告与 HTML 可视化。
核心能力：
直接与 Claude 对话：
"帮我分析这个 Excel 文件的字段"
"分析 ./data/insurance_data.xlsx 的字段映射"
# 基础分析
python scripts/analyzer.py <file_path> [output_dir] [topn]
# 示例
python scripts/analyzer.py data.xlsx ./output 10
# 支持格式：.xlsx, .xls, .csv, .txt
商业险保费 → commercial_premium（finance/number）三级机构 → org_level_3（organization/string）确认时间 → time_confirm（time/datetime）custom.json 便于复用示例：
🔍 Found 70 unknown fields
💡 Using AI to generate mappings...
✅ Generated 70 mappings and saved to custom.json
- 刷新时间 → time_refresh [time/datetime]
- 交叉销售标识 → flag_cross_sales [flag/string]
- 签单保费 → premium_signing [finance/number]
custom.json{
"field_name": "commercial_premium",
"cn_name": "商业险保费",
"group": "finance",
"dtype": "number",
"role": "measure",
"aggregation": "sum",
"is_mapped": true
}
| 分组 | 描述 | 示例 |
|---|---|---|
| finance | 财务数据 | 保费、赔款、费用 |
| organization | 机构信息 | 三级机构、四级机构 |
| vehicle | 车辆相关 | 车牌、车型 |
| product | 产品信息 | 险类、险种 |
| time | 时间字段 | 确认时间、起保日期 |
| flag | 状态标识 | 续保标识、新能源标识 |
| partner | 合作方信息 | 4S 集团、经销商 |
| general | 通用字段 | 业务类型、客户类别 |
pip install pandas openpyxl numpy
MIT 许可证
Process CSV data files by cleaning, transforming, and analyzing them. Use this when users need to work with CSV files, clean data, or perform basic data analysis tasks.
Deploy a Vibes app to exe.dev VM hosting. Uses nginx on persistent VMs with SSH automation. Supports client-side multi-tenancy via subdomain-based Fireproof database isolation.
Given a research goal, use existing skills, training reports, and references to propose a small, concrete experiment plan.
Integrate Trackio for experiment tracking in Kaggle competitions. Use PROACTIVELY when user trains models, logs metrics, or manages experiments. Keywords: 実験, 訓練, train, training, tracking, metrics, 指標, ログ
Use Microsoft Fabric CLI (fab) to manage workspaces, semantic models, reports, notebooks, lakehouses, and other Fabric resources via file-system metaphor and commands. Use when deploying Fabric items, running jobs, querying data, managing OneLake files, or automating Fabric operations. Invoke this skill automatically whenever a user mentions the Fabric CLI, fab, or Fabric.
Provides automated fact-checking, quality assessment, and self-validation capabilities for AI outputs. Use this skill when you need to verify factual claims, assess implementation quality, or ensure outputs meet production standards before delivery.