Skip to content
cccskills
FreePublished on GitHub

xlsx

Use when EZ_math_model needs to read, preview, clean, write, or summarize CSV, XLS, or XLSX attachments and result tables for modeling tasks.

The English summary is being prepared. Showing the original description.

woodfishhhh/EZ_math_model
Works withExcel
See how to install

Files included (1)

  • SKILL.md1.6 KB

SKILL.md (original)

Review the instructions the agent will receive before you install.

xlsx — 表格数据读写

何时使用

  • 读取 .xlsx、.xls、.csv 附件。
  • 写出 results/qN_summary.csv 或 .xlsx。
  • 生成 intake.json.attachments[i].preview。
  • 大 CSV 需要分块处理。

预览契约

输出到 intake preview：

{
  "shape": [1024, 8],
  "columns": ["timestamp", "value"],
  "head_3": [{"timestamp": "2024-01-01", "value": 12.3}],
  "missing_per_col": {"value": 5}
}

优先链路

  1. pandas 读写和清洗。
  2. openpyxl 写公式或保留 Excel 格式。
  3. 宿主 xlsx skill 处理公式刷新、LibreOffice 重算等高级场景。

pandas 模板

import pandas as pd

df = pd.read_excel("attachments/data.xlsx")
preview = {
    "shape": list(df.shape),
    "columns": df.columns.tolist(),
    "head_3": df.head(3).to_dict("records"),
    "missing_per_col": {c: int(n) for c, n in df.isna().sum().items() if n > 0},
}
df.to_csv("results/q1_summary.csv", index=False, encoding="utf-8")

CSV 编码尝试顺序：utf-8 → gbk → gb2312 → latin-1。

大文件协议

  • pd.read_csv(path, chunksize=200_000)。
  • 提前指定 dtype。
  • 必要时抽样 5% 做 EDA。
  • 处理完及时释放分块 DataFrame。

失败诊断

情况处理
编码全失败写诊断，建议用户提供 utf-8 版
列名含非法字符生成 ASCII 安全别名并保留 column_alias.json
文件超过 1GBchunksize 分块处理

Reviews

No reviews yet. Tell others what you thought.

Comments

No login needed. Share how it worked for you, ask a question, or note where it did not run.

No comments yet. Be the first to write one.

Comments are published right away. Do not include personal information such as email addresses or phone numbers. Up to 2 URLs.

0 / 1,000 characters

This form is protected by reCAPTCHA, and the Google Privacy Policy and Terms of Service apply.

More skills from this repository

agent-research-aggregator

Free

Pre-pipeline aggregator that scans AI agent cache directories (.claude, .cursor, .antigravity, .openclaw) or any user-specified directory for experimentation logs, extracts insights and numeric results, and formats them as PaperOrchestra-ready inputs (idea.md + experimental_log.md). TRIGGER when the user says "aggregate my agent logs for paper writing", "extract experiments from my coding agent history", "prepare PaperOrchestra inputs from my cache", "turn my agent logs into a paper", mentions a folder or directory they want to use as the basis for a paper, or wants to run PaperOrchestra but only has scattered agent experiment histories rather than structured inputs. Run this BEFORE paper-orchestra. Also called automatically by paper-orchestra when workspace/inputs/idea.md or workspace/inputs/experimental_log.md are missing.

The English summary is being prepared. Showing the original description.

woodfishhhh/EZ_math_model43Updated Jul 28, 2026

brainstorming

Free

Use when EZ_math_model model selection is unclear after the modeling decision tree, the problem spans multiple domains, or modeler needs several candidate approaches before writing modeling_plan.md.

The English summary is being prepared. Showing the original description.

woodfishhhh/EZ_math_model43Updated Jul 28, 2026

content-refinement-agent

Free

Step 5 of the PaperOrchestra pipeline (arXiv:2604.05018). Iteratively refine drafts/paper.tex by simulating peer review and applying targeted revisions, with strict accept/revert halt rules. Maintains a worklog and snapshots each iteration so revert is real, not symbolic. TRIGGER when the orchestrator delegates Step 5 or when the user asks to "refine the draft", "iterate on the paper", or "run peer review on this paper".

The English summary is being prepared. Showing the original description.

woodfishhhh/EZ_math_model43Updated Jul 28, 2026

dataset

Free

公开数据集发现入口。覆盖 Kaggle / UCI / HuggingFace / 天池。题目要求"自行 查找数据"或"补充外部数据"时启用；附件已含数据时**不调用**。

The English summary is being prepared. Showing the original description.

woodfishhhh/EZ_math_model43Updated Jul 28, 2026

dispatching-parallel-agents

Free

Use when EZ_math_model runs in multi or hybrid mode and has two or more independent subtasks that can be assigned to subagents without shared files, shared state, or dataflow dependencies.

The English summary is being prepared. Showing the original description.

woodfishhhh/EZ_math_model43Updated Jul 28, 2026

docx

Free

Use when EZ_math_model needs to convert paper.md to paper.docx, read a DOCX problem statement, preserve equations and tables, or package a modeling report as a Word document.

The English summary is being prepared. Showing the original description.

woodfishhhh/EZ_math_model43Updated Jul 28, 2026

See all skills by woodfishhhh

Report a problem with this skill