← Back to Skills Marketplace
154
Downloads
0
Stars
0
Active Installs
1
Versions
Install in OpenClaw
/install spearman-correlation
Description
计算两个表格之间的 Spearman 相关性，并输出 FDR 校正后的结果。适用于微生物组数据（如 Family 丰度表与环境因子/功能基因表）的相关性分析。
Usage Guidance
This skill appears coherent and focused on computing Spearman correlations and FDR-corrected p-values for paired tabular inputs. Before installing or running it, consider: (1) ensure your agent/runtime has Python 3 and the listed packages (pandas, scipy, statsmodels, openpyxl) in a controlled environment (virtualenv/conda) — the skill does not provide installation steps; (2) the agent will read whatever files you point it at, so do not supply sensitive or unrelated files; (3) outputs are written as .xlsx files—decide where those files may be stored; (4) for large datasets or many file pairs, computations may be slow or memory-intensive; (5) verify that sample/column names match across tables before running to avoid misleading results. If you want the skill to install missing packages automatically, request an install spec or add installation steps and vet their sources.
Capability Analysis
Type: OpenClaw Skill
Name: spearman-correlation
Version: 1.0.0
The skill is designed for statistical analysis, specifically calculating Spearman correlation and FDR correction for microbiome or environmental data. The instructions in SKILL.md outline a standard data science workflow using common Python libraries (pandas, scipy, statsmodels) and do not contain any indicators of malicious intent, data exfiltration, or unauthorized execution.
Capability Assessment
Purpose & Capability
Name/description (Spearman correlation on two tables) match the SKILL.md workflow. The listed Python libraries (pandas, scipy, statsmodels, openpyxl) are appropriate and expected for the described computations and Excel output. No unrelated binaries, env vars, or config paths are requested.
Instruction Scope
Runtime instructions stay within the stated scope: identify input files/folders, load tabular data, compute spearmanr and FDR (multipletests), and save Excel outputs. Instructions do not request reading unrelated system files, accessing external endpoints, or requiring secrets. The SKILL.md header allows tools Read, Bash, Glob, Grep — the workflow plausibly uses Read/Glob for files; nothing in the prose instructs broad or unexpected data collection.
Install Mechanism
There is no install spec (instruction-only), which is low risk. The skill lists reasonable Python dependencies but does not attempt to download or install packages itself. Users or the agent environment must already have (or install) pandas, scipy, statsmodels, and openpyxl.
Credentials
The skill requests no environment variables, credentials, or config paths. All requested resources are proportional to the task (reading user-provided data files and writing .xlsx outputs).
Persistence & Privilege
always is false and the skill does not request persistent system changes or modification of other skills. Autonomous invocation is allowed (platform default) but is not combined with excessive privileges or credential access.
How to Use
- Make sure OpenClaw is installed (local or Docker)
- Run the install command in chat:
/install spearman-correlation - After installation, invoke the skill by name or use
/spearman-correlation - Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.0.0
Initial release of spearman-correlation skill:
- Calculates Spearman correlation between two tables, tailored for microbiome data (e.g., family abundance vs. environmental factors).
- Supports both single file and batch (folder) analysis, matching files by name and handling subfolders.
- Automatically recognizes file formats (.txt, .tsv, .xlsx) and verifies matched sample columns.
- Performs FDR (Benjamini-Hochberg) correction on p-values.
- Outputs results in Excel (.xlsx) files with separate sheets for correlation coefficients, raw p-values, and FDR-adjusted p-values.
- Summarizes significant correlations (both raw and FDR < 0.05) and reports the Top 10 positive/negative associations.
Metadata
Frequently Asked Questions
What is spearman-correlation?
计算两个表格之间的 Spearman 相关性，并输出 FDR 校正后的结果。适用于微生物组数据（如 Family 丰度表与环境因子/功能基因表）的相关性分析。 It is an AI Agent Skill for Claude Code / OpenClaw, with 154 downloads so far.
How do I install spearman-correlation?
Run "/install spearman-correlation" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.
Is spearman-correlation free?
Yes, spearman-correlation is completely free, licensed under MIT-0. You can download, install and use it at no cost.
Which platforms does spearman-correlation support?
spearman-correlation is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).
Who created spearman-correlation?
It is built and maintained by Dong Zhao (@zd200572); the current version is v1.0.0.
More Skills