BUburntsushi·Feb 22, 2015
Author here. I was really hoping to get binaries for Windows/Mac/Linux available before sharing it with others, but clearly I snoozed. I do have them available for Linux though, so you don't have to install Rust in order to try xsv: https://github.com/BurntSushi/xsv/releases
Otherwise, you could try using rustle[1], which should install `xsv` in one command (but it downloads Rust and compiles everything for you).
While I have your attention, if I had to pick one of the cooler features of xsv, I'd tell you about `xsv index`. Its a command that creates a very simple index that permits random access to your CSV data. This makes a lot of operations pretty fast. For example:
xsv index worldcitiespop.csv # ~1.5s for 145MB
xsv slice -i 500000 worldcitiespop.csv | xsv table # instant, plus elastic tab stops for good measure
That second
Read the rest
command doesn't have to chug through the first 499,999 records to get the 500,000th record.
This can make other commands faster too, like random sampling and statistic gathering. (Parallelism is used when possible!)
Finally, have you ever seen a CLI app QuickCheck'd? Yes. It's awesome! :-) https://github.com/BurntSushi/xsv/blob/master/tests/test_sor...
[1] - https://github.com/brson/rustle