vimalinx/bio-agent / .claude/skills/group-by
group-by
VerifiedUse when you need to summarize tabular data by grouping rows on common column values and applying aggregation operations (sum, count, mean, etc.), similar to SQL GROUP BY.
group-by
Quick Start
- Command:
groupBy -i <file> -g <cols> -c <cols> -o <ops> - Local executable:
/home/vimalinx/miniforge3/envs/bio/bin/groupBy - Full reference: See
references/help.md
When To Use This Tool
- Summarize tabular outputs by shared key columns, similar to SQL
GROUP BY. - Collapse many overlap rows into per-feature counts, sums, means, or distinct value lists.
- Aggregate one or more columns with operations like
sum,count,mean,collapse,distinct,concat,first, andlast. - Post-process interval joins and annotation tables into compact summaries.
Common Patterns
# 1) Sum a numeric column per genomic feature
groupBy \
-i overlaps.tsv \
-g 1,2,3,4 \
-c 9 \
-o sum
# 2) Apply multiple operations to the same column
groupBy \
-i overlaps.tsv \
-g 1,2,3,4 \
-c 9,9 \
-o sum,max
# 3) Collapse IDs and compute the mean score per group from stdin
cat overlaps.tsv | groupBy \
-g 1,2,3,4 \
-c 8,9 \
-o collapse,mean
Recommended Workflow
- Decide which columns define the grouping key and make sure the input is already sorted/grouped by those columns.
- Choose the summarized column list with
-cand the corresponding aggregation operations with-o. - Run the aggregation on a file or via stdin, using
-header/-inheader/-outheaderwhen headers are present. - Tune
-prec,-delim, or-fullonly when the downstream consumer needs those specific output conventions.
Guardrails
-cis required; without it, bedtools does not know which column(s) to aggregate.- The input must already be sorted/grouped by the
-gcolumns, or identical groups will be split across multiple output rows. - Column numbers are 1-based.
- If you supply multiple columns and multiple operations, the counts must either match or one side must have length 1 so bedtools can broadcast it.
-fullkeeps non-group columns from the first row in each group, which can be misleading if later rows in the same group differ.
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| deprecation-and-migrationaddyosmani/agent-skillsManages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset existing code. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |
| performance-optimizationaddyosmani/agent-skillsOptimizes application performance across frontend, backend, queries, and databases. Use when performance requirements exist, when you suspect performance regressions, when Core Web Vitals or load times need improvement, when N+1 query patterns need fixing, or when profiling reveals bottlenecks. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |
| Agent Cost Reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json. | Stars: 117k | Updated | Claude CodeCodex | Verified | Install |
| Agent Cost Reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json. | Stars: 117k | Updated | Claude CodeCodex | Verified | Install |