Data-Processing

CSV tools

Here are some CSV utilities that may come in handy since most teams deal with this format.

• daff - part of my default toolset ;)
• csvq - part of my default toolset ;)
• tsv-utils - interesting read
• xsv - yeah, the ripgrep guy
• gron - now part of my default toolset (yeah, json but faster than jq with “flatten” filter; line grep is powerful)
• coopy - patch/diff for CSV and spreadsheet data
• rq - in trial

bash: shell table output to json

This post presents a Python script that converts tabular command-line output into a more versatile JSON format. This allows for easier data manipulation using tools like jq, as an alternative to complex text-processing pipelines in bash.

You know that sometimes it would be really great to format a shell output to a more versatile format like JSON or YAML that you can process with jq instead of writing long pipes with text-processing.