vimalinx/bio-agent / .claude/skills/uniq-table
uniq-table
VerifiedUse when removing invariant columns from a tab-delimited table, especially in EDirect or bioinformatics comparison pipelines.
uniq-table
Small AWK filter that keeps only tab-separated columns whose values change somewhere after row 2. It is a column-pruning tool, not a row-deduplication tool: constant columns disappear, while varying columns are preserved for every row.
Quick Start
- Command:
uniq-table - Local executable:
/home/vimalinx/miniforge3/envs/bio/bin/uniq-table - Input format: Tab-delimited text on stdin
When To Use This Tool
- Stripping columns that are constant across the compared rows
- Reducing wide comparison tables down to only informative fields
- Cleaning tabular output from EDirect text pipelines before manual review
- Highlighting which columns actually vary across records
Common Patterns
# Keep only columns that vary after row 2
printf 'sample\tgroup\tconst\n1\tA\tkeep\n2\tA\tkeep\n3\tB\tkeep\n4\tB\tkeep\n' | uniq-table
Output from local testing:
sample group
1 A
2 A
3 B
4 B
# Use inside a pipeline
some-tab-producing-command | uniq-table > informative-columns.tsv
Recommended Workflow
- Feed
uniq-tablea tab-delimited table with a stable header and representative early rows. - Run it after a step that produces comparison-style columns you want to trim.
- Inspect the output headers to confirm only meaningful columns remain.
- Save or pass the reduced table downstream for reporting or manual review.
Guardrails
uniq-tabledoes not deduplicate rows. It drops columns that never change after row 2.- The script hard-codes
FS = "\t", so whitespace-separated tables are not handled correctly. - Because the executable is just an AWK script,
uniq-table -helpshows the genericgawkhelp text, not tool-specific usage. - Source inspection shows row 2 is used as the baseline for deciding whether later rows make a column “interesting”.
- If a column is constant from row 2 onward, it is removed even if row 1 is a header with a different string value.
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| writing-skillsobra/superpowersUse when creating new skills, editing existing skills, or verifying skills work before deployment | Stars: 319k | Updated | Claude CodeCodex | Verified | Install |
| xlsxanthropics/skillsUse this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .xltx, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scratch or from other data sources; or convert between tabular file formats. Trigger especially when the user references a spreadsheet file by name or path — even casually (like "the xlsx in my downloads") — and wants something done to it or produced from it. Also trigger for cleaning or restructuring messy tabular data files (malformed rows, misplaced headers, junk data) into proper spreadsheets. The deliverable must be a spreadsheet file. Do NOT trigger when the primary deliverable is a Word document, HTML report, standalone Python script, database pipeline, or Google Sheets API integration, even if tabular data is involved. | Stars: 196k | Updated | Claude CodeCodex | Verified | Install |
| shipping-and-launchaddyosmani/agent-skillsPrepares production launches. Use when preparing to deploy to production, or when asking what needs to be in place before shipping. Use when you need a pre-launch checklist, when setting up monitoring, when planning a staged rollout, or when you need a rollback strategy. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |
| childhoodthedotmack/claude-memBabysit a shipped release after merge, publication, or deployment. Verify published packages, production behavior, installed plugins, and late CI or user reports until the observation window is clean; use babysit for PR readiness before release. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |