tab-cli 0.1.8

A CLI tool for tabular data

tab

A CLI tool for viewing, querying, and converting tabular data files. Reads CSV, TSV, JSON Lines, Parquet, and Avro -- locally or from S3, GCS, and Azure Blob Storage.

pip install tab-cli

Documentation: tongfei.me/tab

---

Quick look

View any tabular file

tab view data.csv

Query with SQL

The table is always available as t:

tab view --sql 'SELECT * FROM t WHERE Metric_A_Value > 80' data.csv

Reshape rows with JMESPath

tab view --jp '{id: participant.id, city: profile.address.city}' data.parquet 

Convert between formats

tab convert data.csv data.parquet
tab convert data.parquet data.jsonl -o jsonl
tab convert data.csv output_dir/ -o parquet -n 4   # partitioned

Concatenate files

tab cat part1.csv part2.csv part3.csv -o jsonl > combined.jsonl

Inspect schema and summary

tab schema data.parquet
tab summary data.parquet

Read from stdin

curl -s https://example.com/data.csv | tab view -i csv -

Read from cloud storage

tab view s3://bucket/path/data.parquet
tab view gs://bucket/path/data.csv
tab view az://container/path/data.jsonl

Install cloud extras as needed:

pip install 'tab-cli[s3]'    # AWS S3
pip install 'tab-cli[gs]'    # Google Cloud Storage
pip install 'tab-cli[az]'    # Azure Blob Storage

Supported formats

• csv
• tsv
• jsonl
• parquet
• avro