public interface AttributeColumnsMergeStrategiesController
Modifier and Type | Interface and Description |
---|---|
static class |
AttributeColumnsMergeStrategiesController.BooleanOperations
Enumeration that defines the supported logic operations for a merge with
booleanLogicOperationsMerge strategy. |
Modifier and Type | Method and Description |
---|---|
Column |
averageNumberMerge(Table table,
Column[] columnsToMerge,
String newColumnTitle)
Merges any combination of number or number list columns, calculating the average of all not null values
and puts the result of each row in a new column of
BIGDECIMAL AttributeType . |
Column |
booleanLogicOperationsMerge(Table table,
Column[] columnsToMerge,
AttributeColumnsMergeStrategiesController.BooleanOperations[] booleanOperations,
String newColumnTitle)
Strategy to apply only to all boolean columns.
|
Column |
firstQuartileNumberMerge(Table table,
Column[] columnsToMerge,
String newColumnTitle)
Merges any combination of number or number list columns, calculating the first quartile (Q1) of all not null values
and puts the result of each row in a new column of
BIGDECIMAL AttributeType . |
Column |
interQuartileRangeNumberMerge(Table table,
Column[] columnsToMerge,
String newColumnTitle)
Merges any combination of number or number list columns, calculating the interquartile range (IQR) of all not null values
and puts the result of each row in a new column of
BIGDECIMAL AttributeType . |
Column |
joinWithSeparatorMerge(Table table,
Column[] columnsToMerge,
Class newColumnType,
String newColumnTitle,
String separator)
Joins various columns of any type into a new column using the given separator string (or null).
|
Column |
maxValueNumbersMerge(Table table,
Column[] columnsToMerge,
String newColumnTitle)
Merges any combination of number or number list columns, calculating the maximum value of all not null values
and puts the result of each row in a new column of
BIGDECIMAL AttributeType . |
Column |
medianNumberMerge(Table table,
Column[] columnsToMerge,
String newColumnTitle)
Merges any combination of number or number list columns, calculating the median of all not null values
and puts the result of each row in a new column of
BIGDECIMAL AttributeType . |
Column |
mergeDateColumnsToTimeInterval(Table table,
Column startColumn,
Column endColumn,
SimpleDateFormat dateFormat,
String defaultStartDate,
String defaultEndDate)
Merge 1 or 2 columns creating a time interval for each row.
|
Column |
mergeNumericColumnsToTimeInterval(Table table,
Column startColumn,
Column endColumn,
double defaultStart,
double defaultEnd)
Merge 1 or 2 columns creating a time interval for each row.
|
Column |
minValueNumbersMerge(Table table,
Column[] columnsToMerge,
String newColumnTitle)
Merges any combination of number or number list columns, calculating the minimum value of all not null values
and puts the result of each row in a new column of
BIGDECIMAL AttributeType . |
Column |
sumNumbersMerge(Table table,
Column[] columnsToMerge,
String newColumnTitle)
Merges any combination of number or number list columns, calculating the sum of all not null values
and puts the result of each row in a new column of
BIGDECIMAL AttributeType . |
Column |
thirdQuartileNumberMerge(Table table,
Column[] columnsToMerge,
String newColumnTitle)
Merges any combination of number or number list columns, calculating the third quartile (Q3) of all not null values
and puts the result of each row in a new column of
BIGDECIMAL AttributeType . |
Column joinWithSeparatorMerge(Table table, Column[] columnsToMerge, Class newColumnType, String newColumnTitle, String separator)
Joins various columns of any type into a new column using the given separator string (or null).
If the specified column type is null, the new created column will have STRING
AttributeType
by default.
table
- Table of the columns to mergecolumnsToMerge
- Columns to mergenewColumnType
- Type for the new column. If null, STRING
will be used by defaultnewColumnTitle
- Title for the new columnseparator
- Separator to put between each valueColumn mergeNumericColumnsToTimeInterval(Table table, Column startColumn, Column endColumn, double defaultStart, double defaultEnd)
Merge 1 or 2 columns creating a time interval for each row. Values of the columns will be expected as numbers
Only one of the 2 column could be null, and its corresponding start/end default will be used.
Columns can be of any type. If not numeric, their values will be parsed.
Default start and end values will be used when the columns don't have a value or it can't be parsed to a double.
When start > end for any reason:
table
- Table of the columns, can't be null or wrongstartColumn
- Column to use as start valueendColumn
- Column to use as end valuedefaultStart
- Default start valuedefaultEnd
- Default end valueColumn mergeDateColumnsToTimeInterval(Table table, Column startColumn, Column endColumn, SimpleDateFormat dateFormat, String defaultStartDate, String defaultEndDate)
Merge 1 or 2 columns creating a time interval for each row. Values of the columns will be expected as dates in the given date format
Only one of the 2 column could be null, and its corresponding start/end default will be used.
Columns can be of any type.
Default start and end values will be used when the columns don't have a value or it can't be parsed to a date. If a default value can't be parsed to a date, infinity will be used as default instead.
When start > end for any reason:
table
- Table of the columns, can't be null or wrongstartColumn
- Column to use as start valueendColumn
- Column to use as end valuedateFormat
- Format for the dates, can't be nulldefaultStartDate
- Default date to use as start if it can be parseddefaultEndDate
- Default date to use as end if it can be parsedColumn booleanLogicOperationsMerge(Table table, Column[] columnsToMerge, AttributeColumnsMergeStrategiesController.BooleanOperations[] booleanOperations, String newColumnTitle)
Strategy to apply only to all boolean columns. Merges various columns into a new boolean column allowing to define each operation to apply between each pair of columns to merge.
The length of the operations array must be the length of the columns array-1, or IllegalArgumentException will be thrown.
table
- Table of the columns to mergecolumnsToMerge
- Boolean columns to mergebooleanOperations
- Boolean operations to applynewColumnTitle
- Title for the new columnColumn averageNumberMerge(Table table, Column[] columnsToMerge, String newColumnTitle)
Merges any combination of number or number list columns, calculating the average of all not null values
and puts the result of each row in a new column of BIGDECIMAL
AttributeType
.
table
- Table of the columns to mergecolumnsToMerge
- Number or number list columnsnewColumnTitle
- Title for the new columnColumn firstQuartileNumberMerge(Table table, Column[] columnsToMerge, String newColumnTitle)
Merges any combination of number or number list columns, calculating the first quartile (Q1) of all not null values
and puts the result of each row in a new column of BIGDECIMAL
AttributeType
.
table
- Table of the columns to mergecolumnsToMerge
- Number or number list columnsnewColumnTitle
- Title for the new columnColumn medianNumberMerge(Table table, Column[] columnsToMerge, String newColumnTitle)
Merges any combination of number or number list columns, calculating the median of all not null values
and puts the result of each row in a new column of BIGDECIMAL
AttributeType
.
table
- Table of the columns to mergecolumnsToMerge
- Number or number list columnsnewColumnTitle
- Title for the new columnColumn thirdQuartileNumberMerge(Table table, Column[] columnsToMerge, String newColumnTitle)
Merges any combination of number or number list columns, calculating the third quartile (Q3) of all not null values
and puts the result of each row in a new column of BIGDECIMAL
AttributeType
.
table
- Table of the columns to mergecolumnsToMerge
- Number or number list columnsnewColumnTitle
- Title for the new columnColumn interQuartileRangeNumberMerge(Table table, Column[] columnsToMerge, String newColumnTitle)
Merges any combination of number or number list columns, calculating the interquartile range (IQR) of all not null values
and puts the result of each row in a new column of BIGDECIMAL
AttributeType
.
table
- Table of the columns to mergecolumnsToMerge
- Number or number list columnsnewColumnTitle
- Title for the new columnColumn sumNumbersMerge(Table table, Column[] columnsToMerge, String newColumnTitle)
Merges any combination of number or number list columns, calculating the sum of all not null values
and puts the result of each row in a new column of BIGDECIMAL
AttributeType
.
table
- Table of the columns to mergecolumnsToMerge
- Number or number list columnsnewColumnTitle
- Title for the new columnColumn minValueNumbersMerge(Table table, Column[] columnsToMerge, String newColumnTitle)
BIGDECIMAL
AttributeType
.table
- Table of the columns to mergecolumnsToMerge
- Number or number list columnsnewColumnTitle
- Title for the new columnColumn maxValueNumbersMerge(Table table, Column[] columnsToMerge, String newColumnTitle)
Merges any combination of number or number list columns, calculating the maximum value of all not null values
and puts the result of each row in a new column of BIGDECIMAL
AttributeType
.
table
- Table of the columns to mergecolumnsToMerge
- Number or number list columnsnewColumnTitle
- Title for the new columnCopyright © 2007–2015 Gephi Consortium. All rights reserved.