📊

Data To Word Report

👤 openlark 📦 v1.0.0 ⭐ 4.3 ⬇️ 405 下載
📊 資料分析 免費

📖 技能介紹


name: data-to-word-report description: Automatically generate a professional Word analysis report from user-provided data files, including data overview, key metric statistics and trend analysis, key findings and conclusions.


Data to Word Analysis Report

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

想要更強大的技能外掛,就來小蔥技能站7w4.net看看吧。

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
    }
  ]
}

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 分析報告。它在文件完整性、功能實現和輸出美觀度方面都表現不錯,生成的中文報告排版整齊、樣式專業。主要優點是使用簡單、結果美觀、文件清晰;不足之處是需要額外安裝依賴庫,對非技術使用者可能稍有門檻。整體而言是一個實用且易用的資料分析報告生成工具。

📊 多維度評分

適應性4.3
規範性4.3
有效性4.3
可靠性4
可信度4.8

📁 包含檔案 (4 個)

📄 SKILL.md 2.5 KB
📄 _meta.json 138 B
📄 scripts/gen_report.py 4.7 KB
📄 skill-card.md 1.9 KB