Tabalyst Inspect
Finds which array, sheet or table of a JSON, JSONL or Excel file holds the records, and writes an editable file.
Tabalyst Tools
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.
Read a file the right way and describe it: where the records are, then what every field holds.
Finds which array, sheet or table of a JSON, JSONL or Excel file holds the records, and writes an editable file.
Describes every field of a CSV, JSON, JSONL or Excel file in one JSON document. The engine behind the report.
Work on less data.
Draws a smaller CSV: first, last, random or stratified rows, reproducible with a seed.
Find the rows that occur more than once.
Finds the exact duplicate rows of a CSV file and writes the unique and repeated rows to new CSV files, with a JSON report.
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.
pip install tabalyst# One package: the tools share it with Tabalyst Report
tabalyst inspect orders.json# Writes orders.json-inspect.json, which you can edit
tabalyst scan orders.json -o orders.scan.json# Applies the Inspect file, writes the scan document
tabalyst report --scan orders.scan.json# Without reading the source again
tabalyst sample customers.csv --sample-method random --rows 1000 --seed 42# customers.sample.csv, the source is never modified
tabalyst dedup customers.csv# customers.unique.csv, customers.duplicates.csv and customers.dedup.json
import tabalyst # Where are the records? Writes the Inspect file and returns itinspection = tabalyst.inspect("orders.json") # The full description of every field, one scan document per sourcescans = tabalyst.generate_scans(["orders.json"], output_dir="scans") # A reproducible sample of a CSV filesample = tabalyst.sample_csv( "customers.csv", method="random", rows=1000, seed=42,) # The exact duplicate rows of a CSV filededup = tabalyst.dedup_csv("customers.csv")
Next step
The tools are documented command by command. Every command and option is in the CLI reference.
Every command, option and exit code.
The public functions and their results.