CtrlK
BlogDocsLog inGet started
Tessl Logo

pivot-table-cross-analysis

利用交叉表与热力图对分类数据进行多维度占比分析,适用于奖项分布、绩效评估或市场占有率等结构化数据的清洗与可视化。

56

Quality

62%

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/pivot-table-analysis/SKILL.md
SKILL.md
Quality
Evals
Security

Quality

Content

65%

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

The content is highly actionable, providing five complete executable functions for a clean crosstab-to-heatmap-to-export pipeline. Its weaknesses are a lack of validation checkpoints in the batch workflow and a monolithic single-file structure with no overview or external references.

Suggestions

Add validation/checkpoint steps between batch stages (e.g., assert the crosstab is non-empty, verify export sheets before returning the FileLink).

Trim comments that merely restate obvious pandas operations to improve token efficiency.

Add a brief overview/quick-start section at the top showing how the five functions chain together, and consider moving the longer functions into a scripts/ bundle referenced from SKILL.md.

DimensionReasoningScore

Conciseness

The body is code-heavy with practical gotcha tips (ffill for merged cells, Chinese font config) and no concept-explanation padding, but several comments restate obvious operations (e.g., '# 清洗字符串空格', '# 计算占比'), so it is 'mostly efficient but could be tightened'.

2 / 3

Actionability

Each step ships a complete, executable Python function with imports (preprocess_pivot_data, create_cross_analysis, generate_analysis_heatmap, extract_performance_insights, export_results), copy-paste ready, matching the 'fully executable code' anchor.

3 / 3

Workflow Clarity

A clear Step1–Step5 sequence exists, but this batch data-processing/export workflow has no validation checkpoints or error-recovery feedback loops, so workflow_clarity is capped at 2 per the batch-operations guideline.

2 / 3

Progressive Disclosure

Content is organized into five labeled steps, but there is no overview/quick-start, no navigation, and all code is inline with no bundle files, matching 'some structure but content that should be separate is inline'.

2 / 3

Total

9

/

12

Passed

Description

60%

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

The description is specific and in correct third-person voice, naming concrete actions and a clear niche. It is held back by a missing explicit 'Use when…' trigger clause and somewhat specialized rather than natural trigger terms.

Suggestions

Add an explicit trigger clause such as 'Use when the user asks for 交叉表、占比分析、热力图可视化 of categorical data like 奖项分布、绩效评估、市场占有率'.

Include natural user-speech variations of the trigger terms (e.g., '占比', '分布表', '热力图') alongside the technical ones.

Sharpen distinctiveness by naming the unique combination (crosstab proportion analysis + heatmap) more explicitly to reduce overlap with general data-analysis skills.

DimensionReasoningScore

Specificity

Names several concrete actions — 交叉表 (crosstab), 热力图 (heatmap), 占比分析 (proportion analysis), 清洗 (cleaning), 可视化 (visualization) — in third person, matching the 'multiple specific concrete actions' anchor.

3 / 3

Completeness

The 'what' is explicit, but the 'when' is only implied via '适用于…等结构化数据' with no 'Use when…' trigger clause, so completeness is capped at 2 per the guidelines.

2 / 3

Trigger Term Quality

Relevant domain keywords are present (奖项分布, 绩效评估, 市场占有率, 交叉表, 热力图) but they skew technical/specialized and lack common natural-speech variations, matching 'some relevant keywords but missing common variations'.

2 / 3

Distinctiveness Conflict Risk

The crosstab-plus-heatmap proportion niche is fairly specific, but it still overlaps broad data-analysis/visualization skills and lacks distinct explicit triggers, matching 'somewhat specific but could still overlap'.

2 / 3

Total

9

/

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.