Skip to main content

transpose

The transpose command transposes rows and columns in a CSV file.

Syntax​

qsv transpose [options] <input_file> [<output_file>]

Description​

The transpose command is used to transpose rows and columns in a CSV file. This is useful for reorienting data for analysis or presentation.

Options​

  • --no-headers: When set, the first row will not be interpreted as headers

Examples​

Transpose Rows and Columns​

Transpose rows and columns in a CSV file:

qsv transpose DLD_Transactions_English_500.csv | qsv table

Common Use Cases​

  • Reorienting data for analysis or presentation
  • Preparing data for visualization or reporting

Tips​

  • Verify the output to ensure the data is correctly transposed
  • Use in combination with other commands for complex data processing

See Also​

  • select - for selecting specific columns
  • apply - for data transformations