Part 2 of my introduction to the XSV tool
Hosted by b-yeezi on 2019-02-19 is flagged as Clean and is released under a CC-BY-SA license.
Listen in ogg,
mp3 format. | Comments (0)
XSV for fast CSV manipulations - Part 1: Basic Usage
xsv is a command line program for indexing, slicing, analyzing, splitting and joining CSV files. Commands should be simple, fast and composable:
- Simple tasks should be easy.
- Performance trade offs should be exposed in the CLI interface.
- Composition should not come at the expense of performance.
We will be using the CSV file provided in the documentation.
Commands covered in this episode
- fixedlengths - Force a CSV file to have same-length records by either padding or truncating them.
- fmt - Reformat CSV data with different delimiters, record terminators or quoting rules. (Supports ASCII delimited data.)
- input - Read CSV data with exotic quoting/escaping rules.
- partition - Partition CSV data based on a column value.
- split - Split one CSV file into many CSV files of N chunks.
- sample - Randomly draw rows from CSV data using reservoir sampling (i.e., use memory proportional to the size of the sample).
- cat - Concatenate CSV files by row or by column.
<< First, < Previous, Next >, Latest >>
Note to Verbose Commenters
If you can't fit everything you want to say in the comment below then you really should record a response show instead.
Note to Spammers
All comments are moderated. All links are checked by humans. We strip out all html. Feel free to record a show about yourself, or your industry, or any other topic we may find interesting. We also check shows for spam :).