chart-embedded-export SKILL.md skillA

chart-embedded-export from opensensenova/sensenova-skills is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add opensensenova/sensenova-skills/chart-embedded-export@git:20260426.f0ab496

Pins git:20260426.f0ab496 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
opensensenova/sensenova-skills
Path
skills/sn-da-excel-workflow/capability/excel-result-export/chart-embedded-export/SKILL.md
Versions recorded
1
Latest version
git:20260426.f0ab496, committed Apr 26, 2026
Size
4,725 bytes
Repository stars
6,031
License
MIT

从结构化数据中提取分类分布执行清洗与统计,生成多维度交叉分析、高分辨率对比图表及包含下载链接的完整分析报告,适用于大文件处理与嵌入式可视化场景。.

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

## Skill Steps

> This sub-skill covers one capability of the Excel workflow. For reading/counting/Parquet optimization, see the parent workflow SKILL.md.

Step1 执行数据清洗,处理合并单元格,使用正则表达式清理文本,并建立分类映射函数骨架。
```python
target_col = '分类字段'
value_col = '数值字段'

# 合并单元格处理 (向下填充还原)
df[target_col] = df[target_col].ffill()

# 数据清洗:正则去除特殊字符、去空、类型转换
df[target_col] = df[target_col].astype(str).str.replace(r'[^\w\s]', '', regex=True).str.strip()
df[value_col] = pd.to_numeric(df[value_col], errors='coerce')
df = df.dropna(subset=[target_col, value_col])

# 分类映射函数骨架
def map_category(val):
    if 'A类特征' in str(val): return 'Category_A'
    elif 'B类特征' in str(val): return 'Category_B'
    return 'Other'

df['Mapped_Category'] = df[target_col].apply(map_category)
```

Step2 进行多维度统计与交叉分析,计算分类占比并生成包含总计行的交叉表。
```python
group_col = '分组字段'

# value_counts 统计与占比计算
counts = df[group_col].value_counts()
proportions = (counts / counts.sum() * 100).round(2)

# 交叉分析 (crosstab),包含总计行
cross_analysis = pd.crosstab(df[group_col], df['Mapped_Category'], margins=True, margins_name='总计')

# 多维度聚合统计
stats = df.groupby(group_col)[value_col].agg(['sum', 'mean', 'min', 'max']).round(2)
```
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add opensensenova/sensenova-skills/chart-embedded-export@sha256:73bebfb64c8cd0dd

The line at the top of this page pins the label git:20260426.f0ab496, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_cph2xam6vxxb6iyj.svg)](https://markdownregistry.com/a/art_cph2xam6vxxb6iyj)

4 badge image fetches in 30 days. What the badge shows.

Versions

The registry has recorded 1 version of this file, committed on Apr 26, 2026.

versioncommittedcommitsizeaudit
git:20260426.f0ab496 latest2026-04-26 f0ab496 4,725 BA view

Audit of the latest version

A  17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (4725 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

opensensenova/sensenova-skills · 6,031 stars · license MIT · pushed 2026-11-03 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_cph2xam6vxxb6iyj
GET https://markdownregistry.com/api/v1/resolve?ref=opensensenova/sensenova-skills/chart-embedded-export
GET https://markdownregistry.com/api/v1/blob/73bebfb64c8cd0dd7e18cbb4d9a2d4fa72244f8b14a70182ee41ac4be0be3d6f

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from opensensenova/sensenova-skills

sn-code-video SKILL.md skill
opensensenova/sensenova-skills · skills/sn-code-video/SKILL.md · Create and revise code-driven videos with Canvas, SVG, HTML/CSS, Three.js, Remotion, Manim, or p5.js, including sound…
git:20261029.dae8ea5 · audit A · 6,031 stars
sn-da-excel-workflow SKILL.md skill
opensensenova/sensenova-skills · skills/sn-da-excel-workflow/SKILL.md · Excel 数据分析多步编排器。覆盖:(1) 读取多 Sheet Excel 文件并统计行数,(2) 大文件检测(≥10k 行自动 Parquet 优化),(3) 数据清洗(缺失值、文本标准化、无效字符),(4)…
git:20260507.197eabb · audit A · 6,031 stars
large-file-parquet-analysis-and-highlight SKILL.md skill
opensensenova/sensenova-skills · skills/sn-da-excel-workflow/capability/excel-cell-coloring/category-coloring/SKILL.md · 当Excel文件总行数超过1万行时,通过转换为Parquet格式提升读取性能,提取目标指标并计算最大值,最后将结果输出为Excel并对特定行进行高亮标注。
git:20260426.f0ab496 · audit A · 6,031 stars
excel-conditional-comparison-and-large-file-processing SKILL.md skill
opensensenova/sensenova-skills · skills/sn-da-excel-workflow/capability/excel-cell-coloring/duplicate-value-coloring/SKILL.md · 对比Excel多表中的特定系数并对异常值进行颜色标记。
git:20260426.f0ab496 · audit A · 6,031 stars
excel-outlier-detection-and-highlighting SKILL.md skill
opensensenova/sensenova-skills · skills/sn-da-excel-workflow/capability/excel-cell-coloring/outlier-coloring/SKILL.md · 识别 Excel 中的超限数值与错误单元格并进行高亮标注。
git:20260426.f0ab496 · audit A · 6,031 stars
large-file-conditional-formatting SKILL.md skill
opensensenova/sensenova-skills · skills/sn-da-excel-workflow/capability/excel-cell-coloring/threshold-cell-coloring/SKILL.md · 根据Excel总行数自动切换Parquet加速读取,计算特定维度的时间序列平均值,并使用openpyxl输出带有条件格式(如低于均值标绿)和自定义样式的分析报告。
git:20260426.f0ab496 · audit A · 6,031 stars
top-value-coloring SKILL.md skill
opensensenova/sensenova-skills · skills/sn-da-excel-workflow/capability/excel-cell-coloring/top-value-coloring/SKILL.md · 根据数据规模动态选择处理策略,对多表数据进行合并、统计筛选,并利用 openpyxl 实现关键指标的自动化样式高亮与格式化导出。
git:20260426.f0ab496 · audit A · 6,031 stars
numeric-extraction-and-distribution-analysis SKILL.md skill
opensensenova/sensenova-skills · skills/sn-da-excel-workflow/capability/excel-conditional-formatting/data-bar-formatting/SKILL.md · 从带单位的字符串列中提取数值并清洗,生成包含直方图、饼图、条形图和累积分布图的多维度综合分布可视化图表,用于展示数据的集中趋势与分布特征。
git:20260426.f0ab496 · audit A · 6,031 stars
categorical-comparison-analysis SKILL.md skill
opensensenova/sensenova-skills · skills/sn-da-excel-workflow/capability/excel-data-analysis/comparison-analysis/SKILL.md · 对两类分类数据进行对比分析,统计数量差异与比例关系并生成可视化图表。
git:20260426.f0ab496 · audit A · 6,031 stars
group-by-analysis SKILL.md skill
opensensenova/sensenova-skills · skills/sn-da-excel-workflow/capability/excel-data-analysis/group-by-analysis/SKILL.md · 对多 Sheet 的 Excel 文件进行行数统计、大文件 Parquet 转换预处理、数据清洗及分组聚合分析,并生成带样式标记的统计表与可视化图表。
git:20260426.f0ab496 · audit A · 6,031 stars
large-file-kpi-analysis SKILL.md skill
opensensenova/sensenova-skills · skills/sn-da-excel-workflow/capability/excel-data-analysis/kpi-metric-analysis/SKILL.md · 根据数据量自动选择读取策略(大文件转Parquet),提取关键指标进行单位一致性验证与排序分析,并输出可下载的结果表格。
git:20260426.f0ab496 · audit A · 6,031 stars
pivot-table-cross-analysis SKILL.md skill
opensensenova/sensenova-skills · skills/sn-da-excel-workflow/capability/excel-data-analysis/pivot-table-analysis/SKILL.md · 利用交叉表与热力图对分类数据进行多维度占比分析,适用于奖项分布、绩效评估或市场占有率等结构化数据的清洗与可视化。
git:20260426.f0ab496 · audit A · 6,031 stars

Every file in opensensenova/sensenova-skills

Browse by kind, by grade A, or by owner.