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:
- Click CSV Import.
- On the Open window, navigate to the folder containing CSV files, select the file you wish to upload and click Open.
- 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.
- 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.
- 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.
- 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.
- The Import Confirmation page, which contains the count and information about the data that will be imported, appears. Click Import.
- 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.