data Tools

json_query

Query JSON with a JMESPath expression

json query jmespath

null_coalesce

Replace null or empty values in a dict with defaults

null coalesce default clean

email_normalize

Normalize an email address by removing dots/aliases and canonicalizing the domain

email normalize dedup

address_normalize

Normalize a US street address by expanding abbreviations and fixing formatting

address normalize format

yaml_to_json

Convert YAML text to JSON or JSON text to YAML.

yaml json convert

xml_to_json

Convert XML text to JSON

xml json convert

unflatten_json

Expand dot-notation keys back to nested JSON

json unflatten

json_to_yaml

Convert JSON to YAML

yaml json convert

json_to_csv

Convert a JSON array (or single object) to CSV text

json csv convert

csv_columns

Extract, reorder, or rename columns from CSV

csv columns extract

json_format

Pretty-print or minify JSON

json format

flatten_json

Flatten nested JSON to dot-notation keys

json flatten

csv_to_json

Parse CSV text to a JSON array of objects

csv json parse

csv_stats

Basic statistics per column (count, nulls, min, max, mean, unique)

csv statistics

csv_sort

Sort CSV rows by one or more columns in ascending or descending order.

csv sort

csv_filter

Filter CSV rows where a column matches a condition. Supports equality, comparison, contains, and empty checks.

csv filter

csv_deduplicate

Remove duplicate rows from CSV, keeping the first or last occurrence. Optionally deduplicate by specific columns.

csv deduplicate unique