skill
pivot-table-cross-analysis
利用交叉表与热力图对分类数据进行多维度占比分析,适用于奖项分布、绩效评估或市场占有率等结构化数据的清洗与可视化。
Description as published by the maintainer. Source
- active
active — Most recent push to the repository was 2026-07-28.
Signals
These are separate measurements of different things. They are deliberately not combined into one score, because a popularity number that mixes website traffic with saves and stars cannot be checked or acted on.
| Signal | Value | What it measures | Window | Observed | Source |
|---|---|---|---|---|---|
| GitHub stars | 4,897 | Stars on the repository that contains this skill, not on the skill itself. A collection of fifty skills shares one number, so it says nothing about this particular skill. | cumulative, all time | GitHub | |
| Last commit | 2026-07-28 | Most recent push to the containing repository. It may reflect work on a different skill in the same collection. | point in time | GitHub | |
| repository status | active | The repository holding this skill exists and is not archived. | as of fetch | GitHub |
Will this work with your setup?
No harness stated by the author and no install path convention detected. Compatibility is untested.
We have not run this skill against a task with and without it enabled, so we cannot tell you whether it improves anything, what it costs in tokens, or whether it duplicates behaviour your harness already has. When we have run that test, the result will appear on this page with the task, the versions and the budget it used.
The skill definition lives at skills/sn-da-excel-workflow/capability/excel-data-analysis/pivot-table-analysis/SKILL.md in https://github.com/OpenSenseNova/SenseNova-Skills.
Where to get it
Also from opensensenova
-
opensensenova-sensenova-skills-categorical-comparison-analysis
— last commit 2026-07-28
对两类分类数据进行对比分析,统计数量差异与比例关系并生成可视化图表。
-
opensensenova-sensenova-skills-category-filtering-and-difficulty-analysis
— last commit 2026-07-28
对Excel数据进行自定义分类统计、交叉分析与可视化,并基于多维度指标(如文本长度、术语密度、正则匹配等)进行综合评分与分级,适用于多类别数据分布统计及文本内容难度/质量评估场景。
-
opensensenova-sensenova-skills-category-statistics
— last commit 2026-07-28
提取指定类别列并统计各类别数量与占比,生成高分辨率的柱状图、饼图等组合可视化报告,适用于分类数据的分布情况分析。
-
opensensenova-sensenova-skills-dynamic-percentage-and-large-file-analysis
— last commit 2026-07-28
根据文件行数动态切换大文件处理策略(Parquet转换),通过逐行扫描或列匹配提取关键指标并计算占比、均值等统计量,最终输出结构化Excel报告及可视化图表。
-
opensensenova-sensenova-skills-excel-bar-chart-visualization
— last commit 2026-07-28
读取多工作表Excel文件,自动处理合并单元格与数据清洗,进行交叉分组统计并生成带总计行的结果表,最后绘制支持中英文字体的美化柱状图,适用于多维度数据汇总与可视化分析。
-
opensensenova-sensenova-skills-excel-basic-statistics-and-routing
— last commit 2026-07-28
对多Sheet Excel文件进行基础统计与,支持按条件筛选计算均值,以及从指定行区间提取数据去重求和,并生成结果文件与下载链接。
-
opensensenova-sensenova-skills-excel-conditional-comparison-and-large-file-proce
— last commit 2026-07-28
对比Excel多表中的特定系数并对异常值进行颜色标记。
-
opensensenova-sensenova-skills-excel-conditional-filtering-optimization
— last commit 2026-07-28
根据多维数值条件筛选 Excel 数据并导出结果,支持大规模数据的自动性能优化处理。
-
opensensenova-sensenova-skills-excel-multi-sheet-threshold-analysis
— last commit 2026-07-28
统计多Sheet Excel总行数并根据规模选择处理策略,提取特定维度信息进行去重统计,并生成摘要与明细报表。
-
opensensenova-sensenova-skills-excel-outlier-detection-and-highlighting
— last commit 2026-07-28
识别 Excel 中的超限数值与错误单元格并进行高亮标注。
Bring your own setup
We take apart real AI setups every week and show what broke, what cost too much, and what the trace actually said. If you run agents on real work, that is where the useful conversation is.
Join ZBS AI Practice Lab