/// <summary>
/// Groups the by.
/// </summary>
/// <param name="columnName">ColumnName of the column.</param>
/// <param name="alias">The alias.</param>
/// <returns></returns>
public static Aggregate GroupBy(string columnName, string alias)
{
Aggregate agg = new Aggregate(columnName, alias, AggregateFunction.GroupBy);
return(agg);
}
/// <summary>
/// Groups the by.
/// </summary>
/// <param name="columnName">ColumnName of the column.</param>
/// <param name="alias">The alias.</param>
/// <returns></returns>
public static Aggregate GroupBy(string columnName, string alias)
{
Aggregate agg = new Aggregate(columnName, alias, AggregateFunction.GroupBy);
return agg;
}
/// <summary>
/// Counts the specified col.
/// </summary>
/// <param name="col">The col.</param>
/// <returns></returns>
public static Aggregate Count(IColumn col)
{
Aggregate agg = new Aggregate(col, AggregateFunction.Count);
return agg;
}
/// <summary>
/// Counts the specified column name.
/// </summary>
/// <param name="columnName">ColumnName of the column.</param>
/// <param name="alias">The alias.</param>
/// <returns></returns>
public static Aggregate Count(string columnName, string alias)
{
Aggregate agg = new Aggregate(columnName, alias, AggregateFunction.Count);
return agg;
}
/// <summary>
/// Variances the specified col.
/// </summary>
/// <param name="col">The col.</param>
/// <returns></returns>
public static Aggregate Variance(IColumn col)
{
Aggregate agg = new Aggregate(col, AggregateFunction.Var);
return agg;
}
/// <summary>
/// Standards the deviation.
/// </summary>
/// <param name="col">The col.</param>
/// <returns></returns>
public static Aggregate StandardDeviation(IColumn col)
{
Aggregate agg = new Aggregate(col, AggregateFunction.StDev);
return agg;
}
/// <summary>
/// Standards the deviation.
/// </summary>
/// <param name="col">The col.</param>
/// <returns></returns>
public static Aggregate StandardDeviation(IColumn col)
{
Aggregate agg = new Aggregate(col, AggregateFunction.StDev);
return(agg);
}
/// <summary>
/// Mins the specified column name.
/// </summary>
/// <param name="columnName">ColumnName of the column.</param>
/// <returns></returns>
public static Aggregate Min(string columnName)
{
Aggregate agg = new Aggregate(columnName, AggregateFunction.Min);
return agg;
}
/// <summary>
/// Variances the specified col.
/// </summary>
/// <param name="col">The col.</param>
/// <returns></returns>
public static Aggregate Variance(IColumn col)
{
Aggregate agg = new Aggregate(col, AggregateFunction.Var);
return(agg);
}
/// <summary>
/// Variances the specified column name.
/// </summary>
/// <param name="columnName">ColumnName of the column.</param>
/// <param name="alias">The alias.</param>
/// <returns></returns>
public static Aggregate Variance(string columnName, string alias)
{
Aggregate agg = new Aggregate(columnName, alias, AggregateFunction.Var);
return(agg);
}
/// <summary>
/// Mins the specified col.
/// </summary>
/// <param name="col">The col.</param>
/// <param name="alias">The alias.</param>
/// <returns></returns>
public static Aggregate Min(IColumn col, string alias)
{
Aggregate agg = new Aggregate(col, alias, AggregateFunction.Min);
return(agg);
}
/// <summary>
/// Mins the specified column name.
/// </summary>
/// <param name="columnName">ColumnName of the column.</param>
/// <returns></returns>
public static Aggregate Min(string columnName)
{
Aggregate agg = new Aggregate(columnName, AggregateFunction.Min);
return(agg);
}
/// <summary>
/// Mins the specified col.
/// </summary>
/// <param name="col">The col.</param>
/// <returns></returns>
public static Aggregate Min(IColumn col)
{
Aggregate agg = new Aggregate(col, AggregateFunction.Min);
return(agg);
}
/// <summary>
/// Avgs the specified col.
/// </summary>
/// <param name="col">The col.</param>
/// <returns></returns>
public static Aggregate Avg(IColumn col)
{
Aggregate agg = new Aggregate(col, AggregateFunction.Avg);
return agg;
}
/// <summary>
/// Standards the deviation.
/// </summary>
/// <param name="columnName">ColumnName of the column.</param>
/// <param name="alias">The alias.</param>
/// <returns></returns>
public static Aggregate StandardDeviation(string columnName, string alias)
{
Aggregate agg = new Aggregate(columnName, alias, AggregateFunction.StDev);
return(agg);
}
/// <summary>
/// Mins the specified col.
/// </summary>
/// <param name="col">The col.</param>
/// <returns></returns>
public static Aggregate Min(IColumn col)
{
Aggregate agg = new Aggregate(col, AggregateFunction.Min);
return agg;
}
/// <summary>
/// Counts the specified col.
/// </summary>
/// <param name="col">The col.</param>
/// <returns></returns>
public static Aggregate Count(IColumn col)
{
Aggregate agg = new Aggregate(col, AggregateFunction.Count);
return(agg);
}
/// <summary>
/// Mins the specified col.
/// </summary>
/// <param name="col">The col.</param>
/// <param name="alias">The alias.</param>
/// <returns></returns>
public static Aggregate Min(IColumn col, string alias)
{
Aggregate agg = new Aggregate(col, alias, AggregateFunction.Min);
return agg;
}
/// <summary>
/// Gets the type of the function.
/// </summary>
/// <param name="agg">The agg.</param>
/// <returns></returns>
public static string GetFunctionType(Aggregate agg)
{
return(Enum.GetName(typeof(AggregateFunction), agg.AggregateType));
}
/// <summary>
/// Variances the specified column name.
/// </summary>
/// <param name="columnName">ColumnName of the column.</param>
/// <param name="alias">The alias.</param>
/// <returns></returns>
public static Aggregate Variance(string columnName, string alias)
{
Aggregate agg = new Aggregate(columnName, alias, AggregateFunction.Var);
return agg;
}
/// <summary>
/// Counts the specified column name.
/// </summary>
/// <param name="columnName">ColumnName of the column.</param>
/// <param name="alias">The alias.</param>
/// <returns></returns>
public static Aggregate Count(string columnName, string alias)
{
Aggregate agg = new Aggregate(columnName, alias, AggregateFunction.Count);
return(agg);
}
/// <summary>
/// Standards the deviation.
/// </summary>
/// <param name="columnName">ColumnName of the column.</param>
/// <param name="alias">The alias.</param>
/// <returns></returns>
public static Aggregate StandardDeviation(string columnName, string alias)
{
Aggregate agg = new Aggregate(columnName, alias, AggregateFunction.StDev);
return agg;
}
/// <summary>
/// Sums the specified col.
/// </summary>
/// <param name="col">The col.</param>
/// <returns></returns>
public static Aggregate Sum(IColumn col)
{
Aggregate agg = new Aggregate(col, AggregateFunction.Sum);
return(agg);
}
/// <summary>
/// Gets the type of the function.
/// </summary>
/// <param name="agg">The agg.</param>
/// <returns></returns>
public static string GetFunctionType(Aggregate agg)
{
return Enum.GetName(typeof(AggregateFunction), agg.AggregateType);
}
/// <summary>
/// Groups the by.
/// </summary>
/// <param name="col">The col.</param>
/// <returns></returns>
public static Aggregate GroupBy(IColumn col)
{
Aggregate agg = new Aggregate(col, AggregateFunction.GroupBy);
return agg;
}
/// <summary>
/// Sums the specified col.
/// </summary>
/// <param name="col">The col.</param>
/// <returns></returns>
public static Aggregate Sum(IColumn col)
{
Aggregate agg = new Aggregate(col, AggregateFunction.Sum);
return agg;
}
/// <summary>
/// Groups the by.
/// </summary>
/// <param name="col">The col.</param>
/// <returns></returns>
public static Aggregate GroupBy(IColumn col)
{
Aggregate agg = new Aggregate(col, AggregateFunction.GroupBy);
return(agg);
}