sn-da-excel-workflow
Excel 数据分析多步编排器。覆盖:(1) 读取多 Sheet Excel 文件并统计行数,(2) 大文件检测(≥10k 行自动 Parquet 优化),(3) 数据清洗(缺失值、文本标准化、无效字符),(4) 条件筛选与分类提取,(5) 跨 Sheet 统计聚合,(6) 导出 Excel/CSV…
Environment diagnostic skill for SenseNova-Skills project. Checks that sn-image-base is properly installed and configured, validates dependencies and environment variables. Prompts user to configure missing required variables and saves them to .env file. After configuration,
$ npx -y skills add OpenSenseNova/SenseNova-Skills --skill sn-image-doctor --agent claude-codeHow it fires
How this skill gets triggered: by you, by Claude, or both.
/sn-image-doctorContext preview
The summary Claude sees to decide when to auto-load this skill.
Environment diagnostic skill for SenseNova-Skills project. Checks that sn-image-base is properly installed and configured, validates dependencies and environment variables. Prompts user to configure missing required variables and saves them to .env file. After configuration,
name: sn-image-doctor description: | Environment diagnostic skill for SenseNova-Skills project. Checks that sn-image-base is properly installed and configured, validates dependencies and environment variables. Prompts user to configure missing required variables and saves them to .env file. After configuration, reloads environment and suggests agent restart if needed. triggers: - "SenseNova-Skills环境检查" - "SenseNova-Skills doctor" - "sn环境检查" - "sn-image-doctor" - "environment check" - "health check" - "诊断环境" metadata: project: SenseNova-Skills tier: 0 category: infrastructure user_visible: true
`sn-image-doctor` is an infrastructure skill (tier 0) that validates the SenseNova-Skills environment before running other skills. It ensures SenseNova-Skills project is properly installed and configured.
This skill performs comprehensive checks including:
Run the doctor check to validate your environment:
# Basic check python scripts/check_environment.py # Verbose output with detailed diagnostics python scripts/check_environment.py --verbose
=== SenseNova-Skills Environment Check === [1/3] Checking sn-image-base installation... ✅ Installation looks good [2/3] Checking Python dependencies... ✅ Python 3.11.0 ✅ All required packages installed [3/3] Checking environment variables... ❌ SN_IMAGE_GEN_API_KEY: Image generation API key is not set; configure SN_API_KEY, or configure SN_IMAGE_GEN_API_KEY only for an image-generation-specific override Some required environment variables are missing. Enter values below to save them to /path/to/.env. Press Enter to skip a variable. SN_API_KEY: <user input> ✅ Saved to /path/to/.env: SN_API_KEY 🔄 Reloading environment... ✅ Environment reloaded successfully === Summary === ✅ Environment is properly configured
If reload fails, the output will suggest restarting the agent:
✅ Saved to /path/to/.env: SN_API_KEY 🔄 Reloading environment... ⚠️ Failed to reload environment: <error message> 💡 Suggestion: Restart the agent to apply new configuration
When checks fail:
=== SenseNova-Skills Environment Check === [1/3] Checking sn-image-base installation... ❌ sn-image-base directory not found Expected location: /path/to/skills/sn-image-base [2/3] Checking Python dependencies... ❌ Missing packages: httpx, pillow Run: pip install -r skills/sn-image-base/requirements.txt === Summary === ❌ Environment check failed Please fix the errors above before using SenseNova-Skills.
**Problem:** `sn-image-base` directory not found
**Solution:**
# Ensure you're in the project root cd /path/to/SenseNova-Skills # Verify the directory exists ls -la skills/sn-image-base
**Problem:** Required Python packages not installed
**Solution:**
# Install dependencies pip install -r skills/sn-image-base/requirements.txt # Or use a virtual environment python -m venv .venv source .venv/bin/activate # On Windows: .venv\Scripts\activate pip install -r skills/sn-image-base/requirements.txt
**Problem:** Required environment variables not set
**Solution:**
# If all capabilities use the same gateway, set only the global values. export SN_API_KEY="your-api-key" export SN_BASE_URL="https://your-api-endpoint.com" # Or create a .env file cat > .env << EOF SN_API_KEY=your-api-key SN_BASE_URL=https://token.sensenova.cn/v1 SN_CHAT_TYPE=openai-completions SN_CHAT_MODEL=sensenova-6.8-flash-lite EOF # Load .env file source .env # Or use a tool like python-dotenv
Fallback priority is capability-specific variable > domain shared variable > global variable. For example, text calls use `SN_TEXT_API_KEY` -> `SN_CHAT_API_KEY` -> `SN_API_KEY`; vision calls use `SN_VISION_API_KEY` -> `SN_CHAT_API_KEY` -> `SN_API_KEY`; image generation uses `SN_IMAGE_GEN_API_KEY` -> `SN_API_KEY`.
**Problem:** Cannot reach API endpoints
**Solution:**
1. Verify network connectivity 2. Check firewall settings 3. Verify API endpoint URLs are correct 4. Test with curl:
curl -I https://your-api-endpoint.com
This skill is designed to be run before using other skills in the SenseNova-Skills project:
# 1. Run doctor check
python skills/sn-image-doctor/scripts/check_environment.py
# 2. If checks pass, use other skills
python skills/sn-image-base/scripts/sn_agent_runner.py sn-image-generate \
--prompt "A beautiful landscape"| Option | Description | |--------|-------------| | `--verbose` | Show detailed diagnostic information | | `--help` | Show help message |
| Code | Meaning | |------|---------| | `0` | All checks passed | | `1` | One or more checks failed |
The SenseNova model family plugs directly into agent runtimes such as OpenClaw and hermes-agent, with the skills in this repository extending the models with concrete, end-to-end office capabilities.
Repo: OpenSenseNova/SenseNova-Skills
Excel 数据分析多步编排器。覆盖:(1) 读取多 Sheet Excel 文件并统计行数,(2) 大文件检测(≥10k 行自动 Parquet 优化),(3) 数据清洗(缺失值、文本标准化、无效字符),(4) 条件筛选与分类提取,(5) 跨 Sheet 统计聚合,(6) 导出 Excel/CSV…
当Excel文件总行数超过1万行时,通过转换为Parquet格式提升读取性能,提取目标指标并计算最大值,最后将结果输出为Excel并对特定行进行高亮标注。
根据Excel总行数自动切换Parquet加速读取,计算特定维度的时间序列平均值,并使用openpyxl输出带有条件格式(如低于均值标绿)和自定义样式的分析报告。
根据数据规模动态选择处理策略,对多表数据进行合并、统计筛选,并利用 openpyxl 实现关键指标的自动化样式高亮与格式化导出。