tb

https://github.com/akr/tb

tb is a manipulation tool for tables. tb provides a command and a library for manipulating tables: Unix filter like operations (sort, cat, cut, ls, etc.), SQL like operations (join, group, etc.), other table operations (search, gsub, rename, cross, melt, unmelt, etc.), information extractions (git, svn, tar), and more. tb supports various table formats: CSV, TSV, JSON, NDJSON, LTSV, etc.