CtrlK
BlogDocsLog inGet started
Tessl Logo

group-by-analysis

对多 Sheet 的 Excel 文件进行行数统计、大文件 Parquet 转换预处理、数据清洗及分组聚合分析,并生成带样式标记的统计表与可视化图表。

65

Quality

77%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide

SecuritybySnyk

Passed

No findings from the security scan

Fix and improve this skill with Tessl

tessl review fix ./skills/sn-da-excel-workflow/capability/excel-data-analysis/group-by-analysis/SKILL.md
SKILL.md
Quality
Evals
Security

Quality

Content

87%

Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.

A lean, fully executable four-step pipeline with clean organization; its main gap is the absence of validation/verification checkpoints around the batch file-generation steps.

Suggestions

Add an explicit validation step after data cleaning (e.g., assert df is non-empty / expected columns present) and after report generation (e.g., verify the .xlsx opens and the Total row is correct) to introduce feedback loops.

Include a brief error-recovery note for common failures (missing Chinese font, empty group result) so the workflow has a fix-and-retry loop rather than a single pass.

DimensionReasoningScore

Conciseness

Each step opens with a one-line intent then executable code; it does not explain pandas/matplotlib basics Claude already knows and contains no padded context, matching the lean-and-efficient anchor.

3 / 3

Actionability

All four steps provide complete, copy-paste-ready Python using pandas, matplotlib, and openpyxl with concrete column names, styles, and output paths, matching the fully-executable anchor.

3 / 3

Workflow Clarity

The Step1–Step4 sequence is clearly ordered, but there are no validation checkpoints or error-recovery feedback loops for the batch write operations (chart save, Excel report generation), which caps workflow clarity at 2 per the scoring notes.

2 / 3

Progressive Disclosure

The single-purpose skill is well-organized into four sequential labeled sections with no nested external references and no bundle files, matching the well-organized-sections anchor for simple skills.

3 / 3

Total

11

/

12

Passed

Description

67%

Based on the skill's description, can an agent find and select it at the right time? Clear, specific descriptions lead to better discovery.

A specific, third-person description with a clear niche, but it lacks any explicit "Use when..." trigger guidance, which caps completeness and weakens trigger-term coverage.

Suggestions

Add a "Use when..." clause naming common trigger phrases (e.g., multi-sheet Excel files, Parquet preprocessing, group-by/聚合 analysis) to satisfy the "when" half of completeness.

Broaden natural trigger keywords users would actually say (多 Sheet、分组统计、数据清洗、生成统计表) to improve trigger-term quality.

DimensionReasoningScore

Specificity

The description lists multiple concrete actions — "行数统计", "Parquet 转换预处理", "数据清洗", "分组聚合分析", and "生成带样式标记的统计表与可视化图表" — matching the anchor for listing several specific concrete actions.

3 / 3

Completeness

The "what" is clearly stated, but there is no "Use when..." or equivalent trigger clause answering "when", which per the judging guidelines caps completeness at 2.

2 / 3

Trigger Term Quality

Natural keywords like "Excel" and "Parquet" appear, but common variations a user would say ("多 Sheet", "分组", "聚合", "统计表") are only implied and there is no explicit trigger phrasing, so it falls short of good coverage.

2 / 3

Distinctiveness Conflict Risk

The niche is specific — multi-sheet Excel preprocessing, Parquet conversion, group-by aggregation, styled report + chart — making it unlikely to trigger for the wrong skill.

3 / 3

Total

10

/

12

Passed

Validation

100%

Checks the skill against the spec for correct structure and formatting. All validation checks must pass before discovery and implementation can be scored.

Validation16 / 16 Passed

Validation for skill structure

No warnings or errors.

Repository
OpenSenseNova/SenseNova-Skills
Reviewed

Table of Contents

Is this your skill?

If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.