3 ms·
This is a really slick little utility! I'll definitely be adding it to my data munging grab bag. For those that deal with this sort of thing often, here are so
by cosmie 7y ago
This is a really slick little utility! I'll definitely be adding it to my data munging grab bag.
For those that deal with this sort of thing often, here are some similarly useful tools:
⠀
Really useful for generating table definitions and/or importing data from a csv to a variety of databases (bunch of other useful utilities in the repo as well): https://csvkit.readthedocs.io/en/latest/scripts/csvsql.html https://csvkit.readthedocs.io/en/latest/scripts/csvsql.html
Similar to cq for querying a CSV file directly: http://harelba.github.io/q/ http://harelba.github.io/q/
Not used often, but really handy when you come across a csv file it's designed for: http://colin.maudry.com/csvtool-manual-page/ http://colin.maudry.com/csvtool-manual-page/
Diff csv files: http://paulfitz.github.io/daff/ http://paulfitz.github.io/daff/
Can convert flatfiles between a bunch of different formats. Useful blunt tool to get things to and from csv files (among others): https://github.com/dflemstr/rq https://github.com/dflemstr/rq
And for searching JSON:
jq: https://stedolan.github.io/jq/ https://stedolan.github.io/jq/
gron: https://github.com/tomnomnom/gron https://github.com/tomnomnom/gron
Or use in2csv from csvkit or rq to get the JSON over to CSV and go from there.