Ready to supercharge your AI agents?

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

Get Started Free →

Excel字典字段时间区间正数值平均值计算 — measured AI agent skill | DecimalAI

ecnu-icalk/Excel字典字段时间区间正数值平均值计算

NewSkillScoreMaintained

用于处理包含时间区间字段和字典字段的Excel表格，计算字典中键位于指定时间区间内且值为正数的平均值。

Databy ecnu-icalk

Links this skill to your agents and keeps it current with the author’s updates.

Automatic

Data Analyst pack

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

pip install decimalai

2 · Get the skill — writes .claude/skills/ecnu-icalk-excel/SKILL.md

decimalai skills pull ecnu-icalk-excel --out .claude/skills/

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

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

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

In productionGlobal

how this skill behaves on real traffic · last 30 days

No production data for this skill yet — usage numbers appear here once agents start running it.

Anonymized aggregate across every org using this skill — proof from real production use, not a demo.

Does this skill help? · Benchmark: with vs. withoutsign in to run this on your agents

22 test cases from the publisher’s eval.yaml · each run twice on gemini-3.6-flash — with the skill injected, then without · last run 2h ago

Yes — +18% lift-7% tokens0% turns91% of whole cases pass with skill (20/22)

Test case	Without → With	Effect	Δ tokens	Δ turns
case-01	✗→✓	▲ Improved	1%	0%
case-02	✗→✓	▲ Improved	-1%	0%
case-05	✗→✓	▲ Improved	-30%	0%
case-07	✗→✓	▲ Improved	11%	0%
case-11	✗→✓	▲ Improved	-9%	0%

Showing 5 of 22 cases

SkillSafety

✓ 3 of 3 passed

Code scan15 of 15 checks clean

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

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/excel%E5%AD%97%E5%85%B8%E5%AD%97%E6%AE%B5%E6%97%B6%E9%97%B4%E5%8C%BA%E9%97%B4%E6%AD%A3%E6%95%B0%E5%80%BC%E5%B9%B3%E5%9D%87%E5%80%BC%E8%AE%A1%E7%AE%97/SKILL.md

View on GitHub ↗

Imported 8/3/2026Version v1

Skill contents

SKILL.md

Excel字典字段时间区间正数值平均值计算

用于处理包含时间区间字段和字典字段的Excel表格，计算字典中键位于指定时间区间内且值为正数的平均值。

Prompt

Role & Objective

你是一个Python数据分析助手。你的任务是处理包含时间区间字段和字典字段的Excel表格，计算字典中键位于时间区间内且值为正数的平均值。

Operational Rules & Constraints

使用pandas库读取Excel文件。
遍历DataFrame的每一行数据。
从每一行中提取开始时间、结束时间以及包含监测数据的字典字段。
遍历字典中的每一个键值对（key为监测时间，value为监测数据）。
判断键（监测时间）是否介于开始时间和结束时间之间（包含边界）。
判断值（监测数据）是否为正数（大于0）。
仅当上述两个条件同时满足时，将该值累加到总和中，并增加计数。
计算平均值（总和 / 计数）。如果计数为0，则不计算平均值。
输出或返回用户ID、日期及对应的计算结果。

Anti-Patterns

不要忽略对数值是否为正数的判断。
不要忽略时间区间的边界条件（包含开始和结束时间）。
不要直接对整个字典求平均，必须先进行筛选。

Triggers

计算字典中时间区间内的平均值
excel字典字段筛选正数求平均
python计算监测数据平均值
key介于开始和结束时间之间求平均

Want to see if ecnu-icalk/Excel字典字段时间区间正数值平均值计算 would activate on your phrasing? Try it before you install — no LLM call, no signup.

Other measured skills in the registry, with their headline benchmark lift.