transpose

Transpose rows/columns of a CSV.

Table of Contents | Source: src/cmd/transpose.rs | 🤯👆

Description | Examples | Usage | Transpose Options | Common Options

Description ↩

Transpose the rows/columns of CSV data.

Examples ↩

Transpose data in-memory.

qsv transpose data.csv

Transpose data using multiple passes. For large datasets.

qsv transpose data.csv --multipass

Convert CSV to "long" format using the first column as the "field" identifier

qsv transpose data.csv --long 1

use the columns "name" & "age" as the "field" identifier

qsv transpose --long "name,age" data.csv

use the columns 1 & 3 as the "field" identifier

qsv transpose --long 1,3 data.csv

use the columns 1 to 3 as the "field" identifier

qsv transpose --long 1-3 data.csv

use all columns starting with "name" as the "field" identifier

qsv transpose --long /^name/ data.csv

See https://github.com/dathere/qsv/blob/master/tests/test_transpose.rs for more examples. See also https://github.com/dathere/qsv/wiki/Transform-and-Reshape#transpose

Usage ↩

qsv transpose [options] [<input>]
qsv transpose --help

Transpose Options ↩

Option	Type	Description	Default
‑m, ‑‑multipass	flag	Process the transpose by making multiple passes over the dataset. Consumes memory relative to the number of rows. Note that in general it is faster to process the transpose in memory. Useful for really big datasets as the default is to read the entire dataset into memory.
‑s, ‑‑select	string	Select a subset of columns to transpose. When used with --long, this filters which columns become attribute rows (the field columns are unaffected). See 'qsv select --help' for the full selection syntax.
‑‑long	string	Convert wide-format CSV to "long" format.

Common Options ↩

Option	Type	Description	Default
‑h, ‑‑help	flag	Display this message
‑o, ‑‑output	string	Write output to instead of stdout.
‑d, ‑‑delimiter	string	The field delimiter for reading CSV data. Must be a single character. (default: ,)
‑‑memcheck	flag	Check if there is enough memory to load the entire CSV into memory using CONSERVATIVE heuristics. Ignored when --multipass or --long option is enabled.

---

Source: src/cmd/transpose.rs | Table of Contents | README