Importing CSV Data

You may import data contained in CSV (Comma-Separated Values) files to the KS6800A PathWave Measurement Analytics software.

The CSV data, in MS Excel (*.xls) format, essentially includes:

  • Measurement / Property field names—the first row of the worksheet
  • Measurement / Property values—all subsequent rows and corresponding columns

In this context, a measurement is defined as the resultant data to be analyzed whereas a property is defined as one or more conditions that may have had an impact on the measurement data.

To import CSV data to the KS6800A PathWave Measurement Analytics software:

  1. Click CSV Import.

  1. On the Open window, navigate to the folder containing CSV files, select the file you wish to upload and click Open.

  1. The CSV Import page appears, indicating the number of rows that contain data, which shall be imported from the selected CSV file name.
  • The KS6800A PathWave Measurement Analytics software automatically arranges the data in such a way that:
    • All rows in the CSV file that contain distinct numeric values (whole / decimal numbers) are considered as measurement values and are indicated by the graph icon.
    • All rows in the CSV file that contain non-numeric values are considered as property values and are indicated by the slider icon.

  1. Choose one of the following dataset options to import data:
  • Create new dataset—By default, this option is selected, as shown above. Enter an alphanumeric value in the New dataset name field.
  • Adding to existing datasets—In the Select a dataset drop-down text field, enter or select from the drop-down list the name of an existing dataset, where you wish to append the imported data.

  1. The rest of the page contains the measurement and property data. Here, you may optionally perform the following actions:

  • Modify the measurement / property field name. The value in the editable text field is extracted from the first row of the CSV file.
  • Use the Property? check box to toggle between defining measurement data as property and vice-versa.
  • Modify the Field Type by clicking another category that may closely resemble (than what was automatically assigned) the type of data for that field.

  1. Click Import to proceed with importing the data or click Cancel to quit the importing process. Note that the Import button is enabled as soon as you assign a dataset name.
  2. The Import Confirmation page, which contains the count and information about the data that will be imported, appears. Click Import.

  1. Once the data is imported successfully, the Import Confirmation page displays the status Import finished. Perform one of the following actions:
  • Click View Measurements to navigate directly to the View Data window, where all datasets are listed.
  • Click View Data on the left pane to navigate to the Datasets page.
  • Click Import Data on the left pane to import another CSV file or a JSON file.