Libraries.Compute.Statistics.Transforms.TransformWider Documentation

The TransformWider class handles transforming a wide DataFrame into a wide DataFrame. This means the factor selected in the long DataFrame will produce new columns based on the selected columns. Any unselected columns will be condensed as much as possible to match the new shape while maintaining data integrity. For more information: pivot_wider: https://tidyr.tidyverse.org/reference/pivot_wider.html unstack: https://www.datasciencemadesimple.com/stack-and-unstack-function-in-r/

Example Code

use Libraries.Compute.Statistics.DataFrame
use Libraries.Compute.Statistics.Transforms.TransformWider

// Load the data
DataFrame frame
frame:Load("Data.csv")
frame:AddSelectedFactor(0)
frame:SetSelectedColumnRange(1,3)

// Transform the data frame to a wider format
TransformWider wider
DataFrame wide = frame:Transform(wider)

Inherits from: Libraries.Language.Object, Libraries.Compute.Statistics.DataFrameTransform

Actions Documentation

Compare(Libraries.Language.Object object)

This action compares two object hash codes and returns an integer. The result is larger if this hash code is larger than the object passed as a parameter, smaller, or equal. In this case, -1 means smaller, 0 means equal, and 1 means larger. This action was changed in Quorum 7 to return an integer, instead of a CompareResult object, because the previous implementation was causing efficiency issues.

Parameters

Return

integer: The Compare result, Smaller, Equal, or Larger.

Example

Object o
Object t
integer result = o:Compare(t) //1 (larger), 0 (equal), or -1 (smaller)

CreatesCopy()

This action tells us whether or not this transform makes a copy of the data or modifies it in place. Transforms that do not make a copy should override this action.

Return

boolean: True if this transform makes a copy.

Example

use Libraries.Compute.Statistics.DataFrame
use Libraries.Compute.Statistics.Transforms.ReverseTransform
use Libraries.System.File

//Load a comma separated file
DataFrame frame
frame:Load("Data.csv")

//reverse the data frame
ReverseTransform reverse
output reverse:CreatesCopy() // by default, this transform returns true.

Equals(Libraries.Language.Object object)

This action determines if two objects are equal based on their hash code values.

Parameters

Return

boolean: True if the hash codes are equal and false if they are not equal.

Example

use Libraries.Language.Object
use Libraries.Language.Types.Text
Object o
Text t
boolean result = o:Equals(t)

GetHashCode()

This action gets the hash code for an object.

Return

integer: The integer hash code of the object.

Example

Object o
integer hash = o:GetHashCode()

ResolveConflictsWithAppend()

Create a list of unique items of the factor

ResolveConflictsWithCount()

Add the widened data to the new frame

ResolveConflictsWithMaximum()

If there are more than 2 columns in the frame, attach the factor names to the selected columns

ResolveConflictsWithMean()

Attempt to make the new columns numerical columns if possible

ResolveConflictsWithMinimum()

This will store the correct divisor for any mean resolutions.

ResolveConflictsWithSum()

Otherwise just make a column for each factor name

Transform(Libraries.Compute.Statistics.DataFrame frame)

Used when the issue occurs with a non-numeric value

Parameters

Return

Libraries.Compute.Statistics.DataFrame: