Adjusting the column types
In the query results, the column headings include the identified column type. The training process uses numeric, categorical, and location columns in the training process.
Numeric columns contain a number value.
Categorical columns contain a specific set of values. For example, a categorical column might identify the marital status of a person represented in the data.
Location columns identify a physical location. For example, a location column might contain a zip code or a city name.
Tonic Structural assigns initial types when it runs the query. Typically:
String columns are assigned as categorical.
Numeric columns are assigned as numeric.
Datetime value columns are assigned as datetime. Ideally, in your SQL query you converted datetime values to a numeric representation of time such as epoch time. The columns are then assigned as numeric.
You can make adjustments to these assignments. For example:
A numeric column might actually be an enum, which would make it a categorical column.
A city name might be designated categorical, but is actually a location.
To change the designation of a column:
Click the dropdown arrow next to the current type.
From the popup menu, select the type.
For columns other than numeric columns, you can designate the column as a categorical column or a location column.
For numeric columns, you can also restore the column type to numeric.
Last updated