Parse dates in a column of a CSV file

Parse dates in a column of a CSV file

This procedure parses all dates in a column 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 ParseDates.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