Module: Creating New Data
Columns
|
|
| Lesson Objective | Learn how to create new data columns based on existing data columns or marked records of interest |
| Section | Description |
| Creating New Data Columns | Three options for creating new data columns include: From Expression, By Binning, and From Marked Records. |
| New Column - From Expression | New columns can be generated by performing mathematical operations and other functions (Logical, Text, Data and Time, Data type conversions, Etc.) on existing data columns. |
| New Column - By Binning | How to create new data columns by organizing data in existing columns catagorically through functions including: custom defined limits, even intervals across the data range, division into an even distribution of unique values, cherry picked groups, grouping by standard deviation units from the mean, and substring commonality. |
| New Column - From Marked Records | Creating a new data column may be a useful means for saving or annotating a group of marked records. You can capture visually interesting data points or records resulting from complex data filtering settings. |
| The Value of New Data Columns | A discussion of the value which can be gleaned from new data columns, including: visualization color, shape, size, rotation, labels, trellis variables, and data filtering options. |
Print