Tabalyst Tools

Small tools around the report.

Tabalyst Report is built on a shared engine. Tabalyst Inspect, Tabalyst Scan, Tabalyst Sample and Tabalyst Dedup are commands of their own, for when you need to control how a file is read, keep a full description of its fields, work on a smaller file or find its duplicate rows.

Three jobs, four tools

Inspect & Scan

Read a file the right way and describe it: where the records are, then what every field holds.

TOOLAvailable

Tabalyst Inspect

Finds which array, sheet or table of a JSON, JSONL or Excel file holds the records, and writes an editable file.

TOOLAvailable

Tabalyst Scan

Describes every field of a CSV, JSON, JSONL or Excel file in one JSON document. The engine behind the report.

Sample

Work on less data.

TOOLAvailable

Tabalyst Sample

Draws a smaller CSV: first, last, random or stratified rows, reproducible with a seed.

Dedup

Find the rows that occur more than once.

TOOLAvailable

Tabalyst Dedup

Finds the exact duplicate rows of a CSV file and writes the unique and repeated rows to new CSV files, with a JSON report.

How they fit together

Inspect, Scan and Tabalyst Report chain: each one can use the answer of the previous one. None of them is required, because the report inspects and scans a file by itself. Sample and Dedup work on their own, on CSV files.

  1. 1 · Install
    pip install tabalyst

    # One package: the tools share it with Tabalyst Report

  2. 2 · Choose the collection
    tabalyst inspect orders.json

    # Writes orders.json-inspect.json, which you can edit

  3. 3 · Describe every field
    tabalyst scan orders.json -o orders.scan.json

    # Applies the Inspect file, writes the scan document

  4. 4 · Build the report
    tabalyst report --scan orders.scan.json

    # Without reading the source again

  5. 5 · Work on less data
    tabalyst sample customers.csv --sample-method random --rows 1000 --seed 42

    # customers.sample.csv, the source is never modified

  6. 6 · Find duplicate rows
    tabalyst dedup customers.csv

    # customers.unique.csv, customers.duplicates.csv and customers.dedup.json

Next step

Where to go next

The tools are documented command by command. Every command and option is in the CLI reference.