transpose

Transpose rows/columns of a CSV.

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

Description ↩

Transpose the rows/columns of CSV data.

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

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

Option	Type	Description
`‑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.

Option	Type	Description
`‑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