SenseNova-Skills
github.com/OpenSenseNova/SenseNova-Skills
Skill | Added | Review |
|---|---|---|
grouped-statistics skills/sn-da-excel-workflow/capability/excel-data-statistics/grouped-statistics/SKILL.md 对多 Sheet 的 Excel 文件进行行数统计、数据合并与前向填充。 | 56 56 Impact — No eval scenarios have been run Securityby  Passed No findings from the security scan Reviewed: Version: 179fea1 | |
category-statistics skills/sn-da-excel-workflow/capability/excel-data-statistics/category-statistics/SKILL.md 提取指定类别列并统计各类别数量与占比，生成高分辨率的柱状图、饼图等组合可视化报告，适用于分类数据的分布情况分析。 | 65 65 Impact — No eval scenarios have been run Securityby Passed No findings from the security scan Reviewed: Version: 179fea1 | |
excel-basic-statistics-and-routing skills/sn-da-excel-workflow/capability/excel-data-statistics/basic-statistics/SKILL.md 对多Sheet Excel文件进行基础统计与，支持按条件筛选计算均值，以及从指定行区间提取数据去重求和，并生成结果文件与下载链接。 | 50 50 Impact — No eval scenarios have been run Securityby Passed No findings from the security scan Reviewed: Version: 179fea1 | |
excel-threshold-analysis-and-styling skills/sn-da-excel-workflow/capability/excel-data-filtering/threshold-filtering/SKILL.md 根据 Excel 数据量级自动判断处理策略，执行数值列清洗、条件过滤，并使用 openpyxl 对符合条件的单元格进行样式标记与导出。 | 56 56 Impact — No eval scenarios have been run Securityby Passed No findings from the security scan Reviewed: Version: 179fea1 | |
excel-conditional-filtering-optimization skills/sn-da-excel-workflow/capability/excel-data-filtering/range-filtering/SKILL.md 根据多维数值条件筛选 Excel 数据并导出结果，支持大规模数据的自动性能优化处理。 | 48 48 Impact — No eval scenarios have been run Securityby Passed No findings from the security scan Reviewed: Version: 179fea1 | |
condition-filtering-and-large-file-optimization skills/sn-da-excel-workflow/capability/excel-data-filtering/condition-filtering/SKILL.md 根据数据规模动态选择处理策略。 | 45 45 Impact — No eval scenarios have been run Securityby Passed No findings from the security scan Reviewed: Version: 179fea1 | |
category-filtering-and-difficulty-analysis skills/sn-da-excel-workflow/capability/excel-data-filtering/category-filtering/SKILL.md 对Excel数据进行自定义分类统计、交叉分析与可视化，并基于多维度指标（如文本长度、术语密度、正则匹配等）进行综合评分与分级，适用于多类别数据分布统计及文本内容难度/质量评估场景。 | 60 60 Impact — No eval scenarios have been run Securityby Low Low-risk findings worth noting Reviewed: Version: 179fea1 | |
text-normalization-and-large-file-processing skills/sn-da-excel-workflow/capability/excel-data-cleaning/text-normalization/SKILL.md 对Excel文件进行文本标准化清洗（如去除异常前缀、提取纯中文字符等），并，最终输出清洗后的Excel文件并提供下载链接。 | 57 57 Impact — No eval scenarios have been run Securityby Passed No findings from the security scan Reviewed: Version: 179fea1 | |
outlier-detection-and-quality-assessment skills/sn-da-excel-workflow/capability/excel-data-cleaning/outlier-detection/SKILL.md 执行全面的异常值检测与数据质量评估，利用 IQR 方法识别异常值并结合偏度、峰度分析数据分布特征，适用于非正态分布数据的预处理阶段。 | 60 60 Impact — No eval scenarios have been run Securityby Passed No findings from the security scan Reviewed: Version: 179fea1 | |
numeric-format-normalization skills/sn-da-excel-workflow/capability/excel-data-cleaning/numeric-format-normalization/SKILL.md 对 Excel 数据进行数值格式标准化与清洗，支持大规模数据的 Parquet 转换流程，并完成关键指标的合计核对与结果文件导出。 | 57 57 Impact — No eval scenarios have been run Securityby Passed No findings from the security scan Reviewed: Version: 179fea1 | |
excel-smart-analysis-and-cleaning skills/sn-da-excel-workflow/capability/excel-data-cleaning/missing-value-handling/SKILL.md 对多 Sheet Excel 进行智能清洗、跨表核对与可视化分析。。 | 55 55 Impact — No eval scenarios have been run Securityby Passed No findings from the security scan Reviewed: Version: 179fea1 | |
invalid-data-cleaning skills/sn-da-excel-workflow/capability/excel-data-cleaning/invalid-data-cleaning/SKILL.md 用于大规模Excel数据的预处理，通过统计总行数判断是否转换为Parquet格式以提升读写效率，并使用正则表达式清洗指定文本列（如仅保留中文字符），最后导出清洗后的文件并提供下载链接。 | 58 58 Impact — No eval scenarios have been run Securityby Passed No findings from the security scan Reviewed: Version: 179fea1 | |
excel-multi-sheet-threshold-analysis skills/sn-da-excel-workflow/capability/excel-data-cleaning/duplicate-removal/SKILL.md 统计多Sheet Excel总行数并根据规模选择处理策略，提取特定维度信息进行去重统计，并生成摘要与明细报表。 | 58 58 Impact — No eval scenarios have been run Securityby Passed No findings from the security scan Reviewed: Version: 179fea1 | |
trend-analysis skills/sn-da-excel-workflow/capability/excel-data-analysis/trend-analysis/SKILL.md 基于多维度数据进行分级评估与趋势预测，通过设定差异化增长率计算预测值，并生成对比可视化图表，适用于绩效评估、目标设定等场景。 | 63 63 Impact — No eval scenarios have been run Securityby Passed No findings from the security scan Reviewed: Version: 179fea1 | |
time-series-and-categorical-analysis skills/sn-da-excel-workflow/capability/excel-data-analysis/time-series-analysis/SKILL.md 对时间序列或分类数据进行多维度趋势分析、百分比清洗、绩效分级建模与预测，并生成高分辨率的可视化综合报告，适用于业务指标监控与预测场景。 | 65 65 Impact — No eval scenarios have been run Securityby Passed No findings from the security scan Reviewed: Version: 179fea1 | |
pivot-table-cross-analysis skills/sn-da-excel-workflow/capability/excel-data-analysis/pivot-table-analysis/SKILL.md 利用交叉表与热力图对分类数据进行多维度占比分析，适用于奖项分布、绩效评估或市场占有率等结构化数据的清洗与可视化。 | 56 56 Impact — No eval scenarios have been run Securityby Passed No findings from the security scan Reviewed: Version: 179fea1 | |
large-file-kpi-analysis skills/sn-da-excel-workflow/capability/excel-data-analysis/kpi-metric-analysis/SKILL.md 根据数据量自动选择读取策略（大文件转Parquet），提取关键指标进行单位一致性验证与排序分析，并输出可下载的结果表格。 | 52 52 Impact — No eval scenarios have been run Securityby Passed No findings from the security scan Reviewed: Version: 179fea1 | |
group-by-analysis skills/sn-da-excel-workflow/capability/excel-data-analysis/group-by-analysis/SKILL.md 对多 Sheet 的 Excel 文件进行行数统计、大文件 Parquet 转换预处理、数据清洗及分组聚合分析，并生成带样式标记的统计表与可视化图表。 | 65 65 Impact — No eval scenarios have been run Securityby Passed No findings from the security scan Reviewed: Version: 179fea1 | |
categorical-comparison-analysis skills/sn-da-excel-workflow/capability/excel-data-analysis/comparison-analysis/SKILL.md 对两类分类数据进行对比分析，统计数量差异与比例关系并生成可视化图表。 | 70 70 Impact — No eval scenarios have been run Securityby Passed No findings from the security scan Reviewed: Version: 179fea1 | |
numeric-extraction-and-distribution-analysis skills/sn-da-excel-workflow/capability/excel-conditional-formatting/data-bar-formatting/SKILL.md 从带单位的字符串列中提取数值并清洗，生成包含直方图、饼图、条形图和累积分布图的多维度综合分布可视化图表，用于展示数据的集中趋势与分布特征。 | 60 60 Impact — No eval scenarios have been run Securityby Passed No findings from the security scan Reviewed: Version: 179fea1 | |
top-value-coloring skills/sn-da-excel-workflow/capability/excel-cell-coloring/top-value-coloring/SKILL.md 根据数据规模动态选择处理策略，对多表数据进行合并、统计筛选，并利用 openpyxl 实现关键指标的自动化样式高亮与格式化导出。 | 52 52 Impact — No eval scenarios have been run Securityby Passed No findings from the security scan Reviewed: Version: 179fea1 | |
large-file-conditional-formatting skills/sn-da-excel-workflow/capability/excel-cell-coloring/threshold-cell-coloring/SKILL.md 根据Excel总行数自动切换Parquet加速读取，计算特定维度的时间序列平均值，并使用openpyxl输出带有条件格式（如低于均值标绿）和自定义样式的分析报告。 | 58 58 Impact — No eval scenarios have been run Securityby Passed No findings from the security scan Reviewed: Version: 179fea1 | |
excel-outlier-detection-and-highlighting skills/sn-da-excel-workflow/capability/excel-cell-coloring/outlier-coloring/SKILL.md 识别 Excel 中的超限数值与错误单元格并进行高亮标注。 | 57 57 Impact — No eval scenarios have been run Securityby Low Low-risk findings worth noting Reviewed: Version: 179fea1 | |
excel-conditional-comparison-and-large-file-processing skills/sn-da-excel-workflow/capability/excel-cell-coloring/duplicate-value-coloring/SKILL.md 对比Excel多表中的特定系数并对异常值进行颜色标记。 | 45 45 Impact — No eval scenarios have been run Securityby Passed No findings from the security scan Reviewed: Version: 179fea1 | |
large-file-parquet-analysis-and-highlight skills/sn-da-excel-workflow/capability/excel-cell-coloring/category-coloring/SKILL.md 当Excel文件总行数超过1万行时，通过转换为Parquet格式提升读取性能，提取目标指标并计算最大值，最后将结果输出为Excel并对特定行进行高亮标注。 | 70 70 Impact — No eval scenarios have been run Securityby Passed No findings from the security scan Reviewed: Version: 179fea1 |