Table Ops

A collection of simple command-line table manipulation tools written in Python. These tools are designed to be efficient and easy to use for common table operations.

Tools

table-union

Merges multiple tabular data files (e.g., CSV, TSV) either by unioning rows with identical columns or by performing a join based on shared key columns.

Key Features:

• Union Mode (Default): Combines rows from all input files, assuming they have the same columns. Duplicate rows are retained.
• Join Mode (--no-union or similar): Performs a join operation based on automatically detected shared key columns. It intelligently identifies potential key columns by looking for columns with unique, non-null values across all input files. This mode merges rows based on matching key values.
• Automatic Key Detection: Automatically identifies suitable columns for joining based on uniqueness and non-null constraints.
• Handles various delimiters: Supports tab-separated (TSV) and comma-separated (CSV) files.
• Memory Efficient: Optimized to handle large files without loading them entirely into memory (where possible).

Usage Example:

table-union file1.tsv file2.tsv file3.tsv > output.tsv

table-summarize data.tsv

table-sort -k Age -k Name data.tsv > sorted_data.tsv

Run Unit Tests:

python -m unittest test_table_ops.py