📖 技能介紹

Data to Word Analysis Report

Automatically generate a professionally formatted analysis report (.docx) from data files, ready for presentation.

Use Cases

Use when users need to "generate analysis report", "convert data to Word", or "produce a report".

Workflow

1. Read Data

Read the user-uploaded data file, automatically detect the format (CSV/JSON/Excel/TXT), extract the data, and confirm the structure.

2. Analyze Data

Perform the following analysis on the data:

Data Overview: Row count, column count, field types, missing value statistics, time range
Key Metrics: Mean/median/max/min/standard deviation for key numeric columns
Trend Analysis: If a time column exists, calculate trends by time dimension
Key Findings: Outliers, significant changes, critical conclusions

3. Generate Report

Call the script to generate the Word report:

python3 scripts/gen_report.py '<output_path>' '<report_json>'

output_path: Output path, e.g., /root/.openclaw/workspace/analysis_report.docx
report_json: JSON string, see structure below

report_json Structure

{
  "title": "Data Analysis Report",
  "sections": [
    {
      "heading": "I. Data Overview",
      "paragraphs": ["This analysis covers 1,234 records...", "Time range: 2024-01 to 2024-12"],
      "table": {
        "headers": ["Metric", "Value"],
        "rows": [["Total Records", "1,234"], ["Fields", "8"], ["Missing Rate", "2.1%"]]
      }
    },
    {
      "heading": "II. Key Metrics",
      "paragraphs": ["Average sales: 456K, median: 382K..."],
      "table": {
        "headers": ["Metric", "Mean", "Median", "Max", "Min"],
        "rows": [["Sales (10K)", "45.6", "38.2", "120.5", "5.3"]]
      }
    },
    {
      "heading": "III. Trend Analysis",
      "paragraphs": ["Overall upward trend, Q4 grew 23% QoQ..."],
      "table": null
    },
    {
      "heading": "IV. Key Findings & Recommendations",
      "paragraphs": ["1. East China region accounts for the highest share (38%)...", "2. December return rate abnormally rose to 5.7%..."],
      "table": null
    }
  ]
}小蔥技能有更好的技能skills外掛。

The table field in each section is optional; pass null to output only paragraphs.

4. Output Results

Inform the user of the file save location and display an overview of the report structure.

🤖 AI 評測

這個 Skill 質量較好，能夠可靠地將資料轉換為格式專業的 Word 分析報告。它在文件完整性、功能實現和輸出美觀度方面都表現不錯，生成的中文報告排版整齊、樣式專業。主要優點是使用簡單、結果美觀、文件清晰；不足之處是需要額外安裝依賴庫，對非技術使用者可能稍有門檻。整體而言是一個實用且易用的資料分析報告生成工具。