13 ms·
If you work with CSV a lot, then also check out xsv, "a command line program for indexing, slicing, analyzing, splitting and joining CSV files", from Andrew Gal
by kibwen 9y ago
If you work with CSV a lot, then also check out xsv, "a command line program for indexing, slicing, analyzing, splitting and joining CSV files", from Andrew Gallant (burntsushi of Go and Rust fame): https://github.com/BurntSushi/xsv https://github.com/BurntSushi/xsv
- jhoechtl 9y agoAnother great tool to wrangle csv file is miller http://johnkerl.org/miller/doc/ http://johnkerl.org/miller/doc/
- walshemj 9y agoYou can also use log parser lizard to parse CSV files.
- fnl 9y agoAnd check out "Motivation" in xsv's readme (at the end) to understand why it might be a better choice than most other tools suggested here, particularly those that go through Python and sqlight. Also, while I like/applaud Miller (also referenced), xsv has a simpler UI that only handles CSV.
- banku_brougham 9y ago`xsv` looks great, I will try it out. My main hesitation: Its another DSL to learn, there is a big benefit to keeping this kind of work within the SQL world for me (or R, python, etc depending on the user). On the other hand, getting table stats and frequencies right from the shell is a huge time saver over SQL.