data-analysis-for-feishu

Data & APIs

📊 Powerful ECharts-based data visualization skill optimized for Feishu (Lark) ecosystem. Supports 12+ chart types, 6+ data sources (Excel/CSV/Bitable/Sheet/Markdown), auto chart recommendation, auto analysis reports, generates high-definition PNG charts perfectly displayed in Feishu. No configuration required, works out of the box.

Install

openclaw skills install data-analysis-for-feishu

<div align="center"> <h1>📊 Data Analysis for Feishu</h1> <p> <strong>Open-source data visualization skill for OpenClaw, built for Feishu ecosystem</strong> </p> <p> <a href="https://github.com/openclaw/skills"><img src="https://img.shields.io/badge/OpenClaw-Skill-blue.svg" alt="OpenClaw Skill"></a> <a href="https://opensource.org/licenses/MIT"><img src="https://img.shields.io/badge/License-MIT-green.svg" alt="License MIT"></a> <a href="https://www.python.org/downloads/"><img src="https://img.shields.io/badge/Python-3.8+-yellow.svg" alt="Python 3.8+"></a> <img src="https://img.shields.io/badge/Feishu-5.15+-brightgreen.svg" alt="Feishu 5.15+"> </p> <p> <a href="#features">✨ Features</a> • <a href="#installation">🚀 Installation</a> • <a href="#quick-start">⚡ Quick Start</a> • <a href="#chart-types">📊 Chart Types</a> • <a href="#data-sources">📥 Data Sources</a> • <a href="#examples">📖 Examples</a> • <a href="#faq">❓ FAQ</a> • <a href="#contributing">🤝 Contributing</a> </p> </div>

✨ Features

📊 Rich Chart Support

12+ professional chart types cover 99% of data visualization scenarios:

Basic: Line, Area, Bar, Stacked Bar, Pie, Donut, Gauge, Radar
Advanced: Scatter (correlation analysis), Funnel (conversion analysis), Waterfall (financial analysis), Dual Axis (multi-metric comparison)
Multi-series: All charts support multiple data series comparison
Customizable: Support stacked mode, area fill, custom colors, etc.

🧠 AI-Powered Intelligence

Auto Chart Recommendation: Upload data, AI automatically analyzes characteristics and selects the optimal chart type
Auto Data Cleaning: Automatically handle null values, outliers, date/percent format conversion
Auto Analysis Report: Generate natural language analysis conclusions while generating charts (trends, extremes, proportions, etc.)
Auto Title Generation: No need to manually enter titles, automatically generate appropriate titles based on data

📥 Multiple Data Sources

No manual data conversion required, support 6+ common data sources:

Local files: Excel (.xlsx/.xls), CSV/TSV
Feishu ecosystem: Bitable (multi-dimensional table), Sheet (spreadsheet)
Text formats: Markdown tables, raw JSON/2D arrays, pasted table text

🖼️ Perfect Feishu Compatibility

Ultra HD Output: 2x Retina DPI rendering, 1200x750 default resolution, sharp text and lines
Precise Cropping: Automatically capture only the chart area, no extra whitespace
Feishu Optimized: Perfect display in Feishu conversations, documents, and wiki pages
Dual Mode Support:
- ✅ Screenshot mode: 100% compatible with all Feishu versions, no permissions required
- ✅ Interactive card mode: Support hover to view values, toggle series (requires Feishu ECharts component permission)

⚡ Excellent Experience

Zero Configuration: Works out of the box, dependencies automatically installed on first run
Fast Generation: First run ~10s (download browser), subsequent generation only takes 1-3 seconds
User-friendly: Clear error prompts, perfect log output, easy to troubleshoot
Exportable: Support export analysis conclusions as separate text files, easy to copy and use

🚀 Installation

Prerequisites

OpenClaw instance (version >= 0.8.0)
Python 3.8+
Feishu integration enabled (optional, for Feishu data sources)

Install Steps

Download the skill package:

wget https://github.com/openclaw/skills/releases/download/data-analysis-for-feishu-v1.0.0/data-analysis-for-feishu.skill

Install in OpenClaw: Go to OpenClaw Admin → Skills → Install → Upload the .skill file
Done! Dependencies are automatically installed on first use.

Manual Installation (for developers)

cd /path/to/openclaw/skills
git clone https://github.com/openclaw/data-analysis-for-feishu.git
cd data-analysis-for-feishu
pip install -r requirements.txt

⚡ Quick Start

1-Minute Test Run

Generate your first chart in 1 minute:

# Go to skill directory
cd skills/data-analysis-for-feishu

# Generate a demo funnel chart
python scripts/main.py \
  --type funnel \
  --title "User Conversion Funnel" \
  --labels "Visit" "Register" "Add to Cart" "Purchase" "Repurchase" \
  --values 10000 4500 2200 1200 500 \
  --output demo_funnel.png

You will get a high-definition funnel chart and automatic analysis report.

Auto Mode (Recommended)

Let AI do all the work, just provide data:

# Auto analyze Excel data, recommend chart type, generate chart + analysis
python scripts/main.py \
  --excel your_data.xlsx \
  --output result.png \
  --analysis-output analysis.txt

📊 Chart Types

Chart Type	Best For	Example
Line Chart	Time series trend analysis	Daily sales trends for the past month
Area Chart	Multi-series trend comparison	2023 vs 2024 monthly sales comparison
Bar Chart	Category comparison/ranking	Sales ranking by region
Stacked Bar Chart	Multi-dimensional proportion	Product category composition in each region
Pie Chart	Proportion/distribution	Revenue composition of each business line
Donut Chart	Ring-style proportion	Market share of each competitor
Gauge Chart	Progress/KPI completion	Annual sales target completion rate
Radar Chart	Multi-dimensional comparison	Product capability assessment
Scatter Chart	Correlation analysis	Correlation between advertising spend and sales
Funnel Chart	Conversion analysis	User conversion from visit to purchase
Waterfall Chart	Financial change analysis	Monthly profit and loss changes
Dual Axis Chart	Multi-metric comparison	Monthly sales and growth rate

📥 Data Sources

Data Source	Usage
Excel (.xlsx/.xls)	`--excel data.xlsx --sheet Sheet1`
CSV/TSV	`--csv data.csv`
Feishu Bitable	`--bitable-records '[{"fields": {...}}]'`
Feishu Sheet	`--sheet-data '[["Header1", "Header2"], ["val1", "val2"]]'`
Markdown Table	`--markdown-table "
Raw Data	`--x-axis "Jan" "Feb" --y-axis 100 200`

📖 Usage Examples

Example 1: Multi-series Area Chart

python scripts/main.py \
  --type area \
  --title "2023 vs 2024 Sales Trend" \
  --excel sales_comparison.xlsx \
  --x-axis-field "Month" \
  --y-axis-field "2023 Sales,2024 Sales" \
  --series-names "2023,2024" \
  --output sales_trend.png

Example 2: Dual Axis Chart (Sales + Growth Rate)

python scripts/main.py \
  --type dual_axis \
  --title "Monthly Performance" \
  --x-axis "Jan" "Feb" "Mar" "Apr" "May" "Jun" \
  --y1-axis 120 150 135 180 210 240 \
  --y1-name "Sales (k)" \
  --y2-axis 0 25 -10 33.3 16.7 14.3 \
  --y2-name "Growth Rate (%)" \
  --output performance.png

Example 3: Waterfall Chart for Financial Analysis

python scripts/main.py \
  --type waterfall \
  --title "Monthly Profit Breakdown" \
  --x-axis "Initial Revenue" "Cost of Goods" "Operating Expenses" "Tax" "Net Profit" \
  --y-axis 1000 -300 -200 -150 350 \
  --y-name "Amount (k)" \
  --output profit_waterfall.png

Example 4: Generate from Markdown Table

python scripts/main.py \
  --type bar \
  --title "Quarterly Revenue" \
  --markdown-table "| Quarter | Revenue | Profit |
|----|----|----|
| Q1 | 1200 | 240 |
| Q2 | 1500 | 375 |
| Q3 | 1350 | 297 |
| Q4 | 1800 | 540 |" \
  --x-axis-field "Quarter" \
  --y-axis-field "Revenue,Profit" \
  --output quarterly.png

🔧 Configuration

Custom Color Scheme

Edit DEFAULT_COLORS in scripts/generate_echarts_screenshot.py to use your brand colors:

DEFAULT_COLORS = ["#YOUR_COLOR1", "#YOUR_COLOR2", ...]

Custom Default Resolution

Change default width/height in scripts/main.py to adjust output size.

Enable Interactive Card Mode

When you have Feishu ECharts component permission, use:

python scripts/generate_echarts_card.py --type line --title "Demo" --x-axis "A" "B" --y-axis 1 2 --output card.json

Then send the JSON as Feishu card.

❓ FAQ

Q: Why is the picture blank when I first run it?

A: First run automatically downloads Chromium browser (about 180MB), please wait patiently. Subsequent runs will be very fast.

Q: Can I use this without Feishu?

A: Yes! You can generate charts as local PNG files for any usage scenario, Feishu integration is optional.

Q: How to apply for Feishu ECharts component permission?

A: Go to Feishu Open Platform → Your App → Permissions → Search for "Message Card - Use ECharts Chart Component" → Apply for permission. It's free and usually approved within 1 working day.

Q: Does it support Chinese data?

A: Perfect support! All components use UTF-8 encoding, Chinese labels, titles, and analysis reports are displayed normally.

Q: Can I add custom chart types?

A: Yes! Just add the chart configuration in scripts/generate_echarts_screenshot.py, following the existing pattern.

🤝 Contributing

Contributions are welcome! You can contribute in the following ways:

🐛 Report bugs and issues
✨ Propose new feature ideas
📝 Improve documentation
🔧 Add new chart types or data sources
🌐 Add multi-language support

Development Setup

# Fork and clone the repo
git clone https://github.com/your-username/data-analysis-for-feishu.git
cd data-analysis-for-feishu

# Install dependencies
pip install -r requirements.txt

# Run tests
python scripts/main.py --type funnel --title "Test" --labels "A" "B" "C" --values 100 50 20 --output test.png

Submitting PR

Fork the repository
Create your feature branch (git checkout -b feature/AmazingFeature)
Commit your changes (git commit -m 'Add some AmazingFeature')
Push to the branch (git push origin feature/AmazingFeature)
Open a Pull Request

📄 License

Distributed under the MIT License. See LICENSE file for more information.

🙏 Acknowledgments

ECharts - Powerful open-source chart library
Pyppeteer - Headless browser for Python
OpenClaw - Extensible AI agent platform
Feishu Open Platform - Feishu API and documentation

<div align="center"> <strong>If this skill helps you, please give it a ⭐ on GitHub!</strong> <br> <a href="https://github.com/openclaw/data-analysis-for-feishu/stargazers"><img src="https://img.shields.io/github/stars/openclaw/data-analysis-for-feishu.svg?style=social" alt="GitHub stars"></a> </div>