Transpose columns and rows of a CSV file

Transpose columns and rows of a CSV file

This procedure transposes columns and rows of a CSV file.

Install Python

  1. Install Python, for example from https://www.python.org/downloads/.

Command prompt window (Windows)

  1. Open the command prompt window.
  2. Enter py in the commands line.

Export of raw data to preparatory file

  1. Run the script TransposeCsv.py.
  2. Use the following name as output file name: [Name of the input file][Short title of the project]PREP[initials of the operator][date of creation using the format YYMMDD].csv
  3. Save the output file in directory Raw Data of the dataset.
  4. Repeat all previous steps of this paragraph for all raw data files.

See also