DataFrameTabulate(Int32, Int32, Int32, FuncIDFColumn, Double) Method

Tabulates the results of applying the given delegate to the values in the specified data column for every combination of the two specified factors.

Namespace: CenterSpace.NMath.Core
Assembly: NMath (in NMath.dll) Version: 7.4

Syntax

C++

Copy

public DataFrame Tabulate(
	int factorAColIndex,
	int factorBColIndex,
	int dataColIndex,
	Func<IDFColumn, double> function
)

Public Function Tabulate ( 
	factorAColIndex As Integer,
	factorBColIndex As Integer,
	dataColIndex As Integer,
	function As Func(Of IDFColumn, Double)
) As DataFrame

public:
DataFrame^ Tabulate(
	int factorAColIndex, 
	int factorBColIndex, 
	int dataColIndex, 
	Func<IDFColumn^, double>^ function
)

member Tabulate : 
        factorAColIndex : int * 
        factorBColIndex : int * 
        dataColIndex : int * 
        function : Func<IDFColumn, float> -> DataFrame

Parameters

factorAColIndex Int32: The index of the column for the first grouping factor.
factorBColIndex Int32: The index of the column for the second grouping factor.
dataColIndex Int32: The index of the data column.
function FuncIDFColumn, Double: A delegate that takes a data frame column and returns a double-precision floating point number.

Return Value

DataFrame
A new data frame.

Remarks

The returned data frame has row keys containing the sorted, unique levels of the first grouping factor as strings. The columns in the data frame, all instances of DFNumericColumn, are named using the sorted, unique levels of the second grouping factor. Each cell in the data frame contains the results of applying the given delegate to the values in the data column tabulated for the appropriate combination of the two factors.
A final column is appended, named Overall, containing the overall results for each level of the first factor. A final row is appended, with key Overall, containing the overall results for each level of the second factor. The lower right corner cell, accessed by this["Overall","Overall"], contains the results of applying the given delegate to all values in the data column.
In the case where there is no data, the function is called. If an exception is called, however, a missing value will be placed in the cell.

Reference

DataFrame Class

Tabulate Overload

CenterSpace.NMath.Core Namespace