Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

D toc

Excerpt

This section describes some techniques for performing analysis across data stored in multiple columns.

For example, you may want to analyze combinations of height and weight. Some options:

...

  • LastName
  • FirstName
  • TestScore1
  • TestScore2
  • TestScore3

You can download the Dataset-TestScores.csv dataset.

Most calculations, such as standard deviation, work for a single column of data. To perform analysis across all three columns, you must reshape the above dataset to look like the following:

...

Now that your columns of data have been consolidated to a single column, you can use the single-column transforms and functions to perform analysis.For more information on identifying outliers in this data, see Locate Outliers., such as locating outliers.

D s also
inCQLtrue
label((label = "discovery_tasks") OR (label = "transformation_ui") OR (label = "column_ui"))