Click or drag to resize

DataFrameTabulate(String, String, String, FuncIDFColumn, DateTime) 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
public DataFrame Tabulate(
	string factorAColName,
	string factorBColName,
	string dataColName,
	Func<IDFColumn, DateTime> function
)

Parameters

factorAColName  String
The name of the column for the first grouping factor.
factorBColName  String
The name of the column for the second grouping factor.
dataColName  String
The name of the data column.
function  FuncIDFColumn, DateTime
A delegate that takes a data frame column and returns a datetime value.

Return Value

DataFrame
A new data frame.
Exceptions
ExceptionCondition
InvalidArgumentException Thrown if the given factor or data column names do not exist in this 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 DFDateTimeColumn, 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.
See Also