Skip to content

vimalinx/bio-agent / .claude/skills/uniq-table

uniq-table

Verified

Use 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

  1. Feed uniq-table a tab-delimited table with a stable header and representative early rows.
  2. Run it after a step that produces comparison-style columns you want to trim.
  3. Inspect the output headers to confirm only meaningful columns remain.
  4. Save or pass the reduced table downstream for reporting or manual review.

Guardrails

  • uniq-table does 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 -help shows the generic gawk help 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.
writing-skillsobra/superpowersUse when creating new skills, editing existing skills, or verifying skills work before deploymentStars: 319kUpdated Claude CodeCodexVerifiedInstall
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: 196kUpdated Claude CodeCodexVerifiedInstall
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: 118kUpdated Claude CodeCodexVerifiedInstall
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: 118kUpdated Claude CodeCodexVerifiedInstall