View Dataset Information
Overview
Dataset information is displayed in a Dataset Details table that lists all of the fields in the dataset (which correspond to the columns in the dataset). The Dataset Details table includes information about each feature such as its data and op type, what Values are acceptable (for string data types), or what min and max Range is acceptable (for continuous non-Boolean values). For more information about the table, see the Dataset Details section below).
In addition to the table, the Dataset Details page also provides an Upload Additional Data button. It can be used to upload additional data records to the dataset. The new records are appended to the existing data. You will be prompted to select both a CSV file that contains the data and a JSON metadata file (must contain the same structure as the metadata for the original dataset).
To View Dataset Details
1. On the Dataset list page, find and select the dataset for which you want to view detailed information.
2. Click the View button.
The Dataset Details page opens.
Dataset Details
Dataset information is displayed in a Dataset Details table that lists all of the features in the dataset. The features correspond to the columns in the dataset. The Dataset Details table includes the following information about each feature in the dataset:
|
Column Name
|
Description
|
||
|---|---|---|---|
|
Field Name
|
A unique identifier for the feature in the dataset. Should not contain periods (.) or spaces.
|
||
|
Data Type
|
Identifies the type of data the feature represents. Acceptable values are: STRING, BOOLEAN, DOUBLE, INTEGER, LONG, DATETIME. For more information, see OpType DataType Combinations.
|
||
|
Op Type
|
Identifies how the data can be used. Acceptable values are: CONTINUOUS, CATEGORICAL, BOOLEAN, ORDINAL, ENTITY_ID, TEMPORAL, INFORMATIONAL, TEXT. For more information, see OpType DataType Combinations.
|
||
|
Min
|
The minimum observed value for CONTINUOUS field.
|
||
|
Max
|
The maximum observed value for CONTINUOUS field.
|
||
|
Time Sampling Interval
|
An integer representing the time between observations in a TEMPORAL field. For use only with time series datasets.
|
||
|
Is Static
|
If true, the value in a field remains unchanged over time.
|
||
|
Values
|
Acceptable values for ORDINAL and CATEGORICAL fields.
If the values list is not empty, any string values not explicitly contained in the Values list will be rejected by ThingWorx Analytics. However, if the values list is empty, all values are acceptable. For example, in the following values list "values": ["Low", "Medium", "High"], if there were a value of "Very High" in a Post Request, an error would be returned. However, if the values list is "values": [ ] then any value will be accepted, including "Very High"
|
||
|
Treatment
|
Indicates how a missing dataset value should be handled for a specific field. This parameter is optional but required in order to impute missing values. Options include: AS_IS, AS_VALUE, AS_MEAN, AS_MEDIAN, AS_LAST. For more information about the options available for imputing missing values, see Handling Missing Dataset Values.
|
||
|
Replacement
|
Indicates what value should replace all missing values for a specific field. This parameter is required when the value for missingValueTreatment is AS_VALUE. Do not use with other missing value treatments.
|
||
|
Indicators
|
Indicates a list of values that should be interpreted as missing for a specific field. By default, null entries are considered missing. This parameter is optional but can only be used when a missing value treatment is specified in Treatment.
|
