Lots of features, but slow because written in Python. A faster version may be csvtools. Also some annoyances like obtuse header handing and missing features like grep + cut in one go: csvgrep and select column in csvkit.

csvgrep from csvkit

 0  0 

Simple example:

printf '00,11,22\n33,44,55\n' | csvgrep -H -c2 -r '^11$' | tail -n+2

output:

00,11,22

More verbose description:

csvgrep and select column in csvkit

 0  0 

There seems to be no way without a pipe, you seem to need to reparse the columns, e.g. the tutorial at: csvkit.readthedocs.io/en/latest/tutorial/2_examining_the_data.html#csvgrep-find-the-data-you-need does:

csvcut -c county,item_name,total_cost data.csv | csvgrep -c county -m LANCASTER

Asked at: stackoverflow.com/questions/77266699/how-to-fillter-a-csv-file-with-csvgrep-and-print-only-certain-columns

csvtool

 0  0 

A compiled executable under /usr/bin/csvtool, has an Ubuntu 23.04 package: manpages.ubuntu.com/manpages/lunar/en/man1/csvtool.1.html

There seems to be no sane filtering mechanism however: stackoverflow.com/questions/46540752/using-csvtool-call-to-filter-csv-in-bash

csvtools

 0  0 

github.com/maroofi/csvtool

A fast version of a somewhat subset of csvkit, written in C.

Build failed with undefined reference to pcre_config on Ubuntu 23.04: github.com/DavyLandman/csvtools/issues/18

Unfortunately it is lacking some basic options, like optional header + selecting column by index on csvgrep (though csvcut has it). The project seems kind of dead.

Also unclear if it allows to filter + print only selected columns.

xsv

 0  0 

github.com/BurntSushi/xsv

Is this the one?

JSON

 0  0 

JSON trailing comma

 0  0 

stackoverflow.com/questions/201782/can-you-use-a-trailing-comma-in-a-json-object

The fact that you cannot have trailing commans in lists or dicts as in 3, at:

{
  "asdf": [
    1,
    2,
    3,
  ]
}

is one of the most infuriating design choices of all time!!!

jq (2012-)

 0  0 

jq ignore missing attribute

 0  0 

echo '[{"a": 1, "b": 2}, {"b": 3}]' | jq '.[] | select(.a) | .a'

Output:

and no empty lines as desired.

Bibliography:

stackoverflow.com/questions/42097410/how-to-check-for-presence-of-key-in-jq-before-iterating-over-the-values

Hierarchical Data Format (HDF)

 1  0 

Unified Modeling Language (UML)

 1  0 

XML (Extensible Markup Language)

 0  0 

Do you know what is worse than XML? Pseudo XML: stackoverflow.com/questions/5558502/is-html5-valid-xml/39560454#39560454

Standard Generalized Markup Language (SGML)

 0  0 

XML predecessor.

IBM Generalized Markup Language

 0  0 

SGML predecessor.

XPath

 0  0 

XPath kind of died with the rise of CSS selectors around the beginnning of the 2010's. But that is a shame. XPath is a good standard, and was generally more powerful than CSS selectors for many many years.