Ready to supercharge your AI agents?

Install any skill in seconds. Free to start, no credit card required.

Get Started Free →

基于基准列重排多个Excel文件 · ecnu-icalk | DecimalAI

databy ecnu-icalk

基于基准列重排多个Excel文件

ecnu-icalk/基于基准列重排多个Excel文件

Source ecnu-icalk/autoskill ↗License Not recorded

使用Python根据基准文件的第一列顺序，对多个Excel文件进行行重排序，保持文件内容不变且输出结构一致。

SkillScore100Maintained

Automatic

Data Engineer pack

Last verified 8/18/2026

What it changes

Passed 23 of 23 test cases with the skill, and 21 of 23 without it.

Without skill91%

With skill100%

Checks it passed that the model alone missed

The code reads target Excel files with `header=None`.
The reading function specifies `header=None` for target Excel files.

2 fixed21 passed either way0 still failing0 broke

Pass-rate lift: +9 pp
Tokens: +1%
Agent turns: 0%
Response time: -11%

Model gemini-3.6-flashMeasured 8/18/2026v123 of 23 cases passed with skill

Tokens, turns and time describe resource use, not a dollar price.

Use this skill

Save it into your project's skills folder. Claude Code picks it up in its next session.

curl -fsSL --create-dirs -o .claude/skills/ecnu-icalk-excel-d09a68/SKILL.md https://app.decimal.ai/s/ecnu-icalk-excel-d5c089/SKILL.md

Want it pinned and updatable? pip install "decimalai>=0.15", then decimalai skills add ecnu-icalk-excel-d5c089, and start Claude Code with claude --plugin-dir "$(git rev-parse --show-toplevel)/.agents"

1 · One-time — install the CLI (docs ↗)

pip install "decimalai>=0.15"

2 · Get the skill — writes .agents/skills/ecnu-icalk-excel-d09a68/ and pins it in .decimal/skills.lock

decimalai skills add ecnu-icalk-excel-d5c089

No CLI? Get the same file — curl · raw file

curl -fsSL --create-dirs -o .claude/skills/ecnu-icalk-excel-d09a68/SKILL.md https://app.decimal.ai/s/ecnu-icalk-excel-d5c089/SKILL.md

Raw file: /s/ecnu-icalk-excel-d5c089/SKILL.md ↗ · machine-readable summary at /s/ecnu-icalk-excel-d5c089.json ↗

Safety checks: 3 of 3 passed

Code scan CleanIntent PassedContent Clean

See it in action

One of 2 test cases the skill fixed. Same model, same prompt, with and without the skill.

1 of 2

Prompt

我手里有 5 个月度报表 Excel 文件，由于系统导出原因，各文件的行顺序不一致。我想以其中一个报表的第一列作为统一的排序标准，将剩下文件的行依次对齐重排。请提供一个 Python 处理逻辑，确保每个 Excel 处理后单独保存，只调整行顺序，不要合并表格或者变更任何数值数据。

What was checked, without and with the skill
Checked	Without skill	With skill
The reading function specifies `header=None` for target Excel files.	Missed	Passed
The script exports each target file individually to its own output path.	Passed	Passed

case-02 · gemini-3.6-flash · 8/18/2026 · answers are capped and redacted

What's inside

The instructions your model reads when the skill loads.

SKILL.md27 linessingle file

基于基准列重排多个Excel文件

使用Python根据基准文件的第一列顺序，对多个Excel文件进行行重排序，保持文件内容不变且输出结构一致。

Prompt

Role & Objective

你是一个Python数据处理专家。你的任务是使用Python（推荐Pandas库）处理Excel文件。具体需求是：以一个基准Excel文件的第一列为参考顺序，对其他多个Excel文件的内容进行重排序。

Operational Rules & Constraints

基准文件：读取指定的基准文件（如'HistoricalWave.xlsx'），获取其第一列的数据顺序。
目标文件：读取需要重排序的其他Excel文件列表。这些文件没有列索引（header=None），且第一列的内容与基准文件一致，但行顺序不同。
重排序逻辑：根据基准文件第一列的顺序，重新排列每个目标文件的行。
内容保护：严禁改变文档中的具体内容，只能调整行的顺序。
输出结构：确保处理后的结果保持原有的文件数量结构（例如输入7个文件，输出也应保持7个文件或对应的结构，不要合并成一个数据块）。

Anti-Patterns

不要修改单元格内的数据。
不要将所有文件合并成一个单一的数据表导致文件数量丢失。
不要忽略文件没有表头（header=None）的情况。

Triggers

用Python重排Excel文件
以第一列为基准排序
Excel行顺序对齐
根据基准文件重排序

Track record

Benchmark

23 / 23

test cases passed, vs 21 / 23 without

Adoption

Users: 0
Times used: 0

Safety and source details

SkillSafety

✓ 3 of 3 passed

Code scan15 of 15 checks clean

0 critical · 0 warning · 0 info — scanner v4 — 8/3/2026

View 15 scanner checks

live_secretremote_code_executionreverse_shelldata_exfiltrationssrf_metadataagent_snoopinganti_refusaldestructive_commandsobfuscated_unicodeunicode_homoglyphopaque_blobsuspicious_urltool_overreachtrigger_abuseprompt_injection_phrasing

IntentSafe

LLM judge · does the skill do what it claims

ContentClean

LLM judge · policy & harmful-content review

Source

Imported

ecnu-icalk / autoskill

SkillBank/ConvSkill/chinese_gpt3.5_8/%E5%9F%BA%E4%BA%8E%E5%9F%BA%E5%87%86%E5%88%97%E9%87%8D%E6%8E%92%E5%A4%9A%E4%B8%AAexcel%E6%96%87%E4%BB%B6/SKILL.md

View on GitHub ↗

Imported 8/3/2026Version v1

More skills from the same source and nearby in the registry, with their headline benchmark lift.

Ready to supercharge your AI agents?

See it in action

What's inside

基于基准列重排多个Excel文件

Prompt

Role & Objective

Operational Rules & Constraints

Anti-Patterns

Triggers

Track record

Benchmark

Adoption

SkillSafety

Source

Related skills