10.5.2 Arrays

Functions which operate on array-valued cells. The array parameters of these functions can only be used on values which are already arrays (usually, numeric arrays). In most cases that means on values in table columns which are declared as array-valued. FITS and VOTable tables can have columns which contain array values, but other formats such as CSV cannot.

If you want to calculate aggregating functions like sum, min, max etc on multiple values which are not part of an array, it's easier to use the functions from the Lists class.

Note that none of these functions will calculate statistical functions over a whole column of a table.

The functions fall into a number of categories:

• Aggregating operations, which map an array value to a scalar, including size, count, countTrue, maximum, minimum, sum, mean, median, quantile, stdev, variance, join.
• Operations on one or more arrays which produce array results, including add, subtract, multiply, divide, reciprocal, condition, slice, pick. Mostly these work on any numeric array type and return floating point (double precision) values, but some of them (slice, pick) have variants for different array types.
• The function array, which lets you assemble a floating point array value from a list of scalar numbers. There are variants (intArray, stringArray) for some different array types.

sum( array )

Returns the sum of all the non-blank elements in the array. If array is not a numeric array, null is returned.

• Parameters:
  • array (Object): array of numbers
• Return value
  • (floating point): sum of all the numeric values in array

mean( array )

Returns the mean of all the non-blank elements in the array. If array is not a numeric array, null is returned.

• Parameters:
  • array (Object): array of numbers
• Return value
  • (floating point): mean of all the numeric values in array

variance( array )

Returns the population variance of all the non-blank elements in the array. If array is not a numeric array, null is returned.

• Parameters:
  • array (Object): array of numbers
• Return value
  • (floating point): variance of the numeric values in array

stdev( array )

Returns the population standard deviation of all the non-blank elements in the array. If array is not a numeric array, null is returned.

• Parameters:
  • array (Object): array of numbers
• Return value
  • (floating point): standard deviation of the numeric values in array

minimum( array )

Returns the smallest of the non-blank elements in the array. If array is not a numeric array, null is returned.

• Parameters:
  • array (Object): array of numbers
• Return value
  • (floating point): minimum of the numeric values in array

maximum( array )

Returns the largest of the non-blank elements in the array. If array is not a numeric array, null is returned.

• Parameters:
  • array (Object): array of numbers
• Return value
  • (floating point): maximum of the numeric values in array

median( array )

Returns the median of the non-blank elements in the array. If array is not a numeric array, null is returned.

• Parameters:
  • array (Object): array of numbers
• Return value
  • (floating point): median of the numeric values in array

quantile( array, quant )

Returns a quantile value of the non-blank elements in the array. Which quantile is determined by the quant value; values of 0, 0.5 and 1 give the minimum, median and maximum respectively. A value of 0.99 would give the 99th percentile.

• Parameters:
  • array (Object): array of numbers
  • quant (floating point): number in the range 0-1 deterining which quantile to calculate
• Return value
  • (floating point): quantile corresponding to quant

size( array )

Returns the number of elements in the array. If array is not an array, zero is returned.

• Parameters:
  • array (Object): array
• Return value
  • (integer): size of array

count( array )

Returns the number of non-blank elements in the array. If array is not an array, zero is returned.

• Parameters:
  • array (Object): array (may or may not be numeric)
• Return value
  • (integer): number of non-blank elements in array

countTrue( array )

Returns the number of true elements in an array of boolean values.

• Parameters:
  • array (array of boolean): array of true/false values
• Return value
  • (integer): number of true values in array

join( array, joiner )

Returns a string composed of concatenating all the elements of an array, separated by a joiner string. If array is not an array, null is returned.

• Parameters:
  • array (Object): array of numbers or strings
  • joiner (String): text string to interpose between adjacent elements
• Return value
  • (String): string composed of array elements separated by joiner strings
• Example:
  • join(array(1.5,2.1,-3.9), "; ") = "1.5; 2.1; -3.9"

add( array1, array2 )

Returns the result of adding two numeric arrays element by element. Both arrays must be numeric, and the arrays must have the same length. If either of those conditions is not true, null is returned. The types of the arrays do not need to be the same, so for example it is permitted to add an integer array to a floating point array.

• Parameters:
  • array1 (Object): first array of numeric values
  • array2 (Object): second array of numeric values
• Return value
  • (array of floating point): element-by-element sum of array1 and array2, the same length as the input arrays
• Example:
  • add(array(1,2,3), array(0.1,0.2,0.3)) = [1.1, 2.2, 3.3]

add( array, constant )

Returns the result of adding a constant value to every element of a numeric array. If the supplied array argument is not a numeric array, null is returned.

• Parameters:
  • array (Object): array input
  • constant (floating point): value to add to each array element
• Return value
  • (array of floating point): array output, the same length as the array parameter
• Example:
  • add(array(1,2,3), 10) = [11,12,13]

subtract( array1, array2 )

Returns the result of subtracting one numeric array from the other element by element. Both arrays must be numeric, and the arrays must have the same length. If either of those conditions is not true, null is returned. The types of the arrays do not need to be the same, so for example it is permitted to subtract an integer array from a floating point array.

• Parameters:
  • array1 (Object): first array of numeric values
  • array2 (Object): second array of numeric values
• Return value
  • (array of floating point): element-by-element difference of array1 and array2, the same length as the input arrays
• Example:
  • subtract(array(1,2,3), array(0.1,0.2,0.3)) = [0.9, 1.8, 2.7]

multiply( array1, array2 )

Returns the result of multiplying two numeric arrays element by element. Both arrays must be numeric, and the arrays must have the same length. If either of those conditions is not true, null is returned. The types of the arrays do not need to be the same, so for example it is permitted to multiply an integer array by a floating point array.

• Parameters:
  • array1 (Object): first array of numeric values
  • array2 (Object): second array of numeric values
• Return value
  • (array of floating point): element-by-element product of array1 and array2, the same length as the input arrays
• Example:
  • multiply(array(1,2,3), array(2,4,6)) = [2, 8, 18]

multiply( array, constant )

Returns the result of multiplying every element of a numeric array by a constant value. If the supplied array argument is not a numeric array, null is returned.

• Parameters:
  • array (Object): array input
  • constant (floating point): value by which to multiply each array element
• Return value
  • (array of floating point): array output, the same length as the array parameter
• Example:
  • multiply(array(1,2,3), 2) = [2, 4, 6]

divide( array1, array2 )

Returns the result of dividing two numeric arrays element by element. Both arrays must be numeric, and the arrays must have the same length. If either of those conditions is not true, null is returned. The types of the arrays do not need to be the same, so for example it is permitted to divide an integer array by a floating point array.

• Parameters:
  • array1 (Object): array of numerator values (numeric)
  • array2 (Object): array of denominator values (numeric)
• Return value
  • (array of floating point): element-by-element result of array1[i]/array2[i] the same length as the input arrays
• Example:
  • divide(array(0,9,4), array(1,3,8)) = [0, 3, 0.5]

reciprocal( array )

Returns the result of taking the reciprocal of every element of a numeric array. If the supplied array argument is not a numeric array, null is returned.

• Parameters:
  • array (Object): array input
• Return value
  • (array of floating point): array output, the same length as the array parameter
• Example:
  • reciprocal(array(1,2,0.25) = [1, 0.5, 4]

condition( flagArray, trueValue, falseValue )

Maps a boolean array to a numeric array by using supplied numeric values to represent true and false values from the input array.

This has the same effect as applying the expression outArray[i] = flagArray[i] ? trueValue : falseValue.

• Parameters:
  • flagArray (array of boolean): array of boolean values
  • trueValue (floating point): output value corresponding to an input true value
  • falseValue (floating point): output value corresponding to an input false value
• Return value
  • (array of floating point): output numeric array, same length as flagArray
• Example:
  • condition([true, false, true], 1, 0) = [1, 0, 1]

slice( array, i0, i1 )

Returns a sub-sequence of values from a given array.

The semantics are like python array slicing, though both limits have to be specified: the output array contains the sequence of elements in the input array from i0 (inclusive) to i1 (exclusive). If a negative value is given in either case, it is added to the length of the input array, so that -1 indicates the last element of the input array. The indices are capped at 0 and the input array length respectively, so a large positive value may be used to indicate the end of the array. If the end index is less than or equal to the start index, a zero-length array is returned.

Note: This documents the double-precision version of the routine. Corresponding routines exist for other data types (float, long, int, short, byte, String, Object).

• Parameters:
  • array (array of floating point): input array
  • i0 (integer): index of first element, inclusive (may be negative to count back from the end)
  • i1 (integer): index of the last element, exclusive (may be negative to count back from the end)
• Return value
  • (array of floating point): array giving the sequence of elements specified by i0 and i1
• Examples:
  • slice(array(10,11,12,13), 0, 3) = [10, 11, 12]
  • slice(array(10,11,12,13), -2, 999) = [12, 13]

pick( array, indices, ... )

Returns a selection of elements from a given array.

The output array consists of one element selected from the input array for each of the supplied index values. If a negative value is supplied for an index value, it is added to the input array length, so that -1 indicates the last element of the input array. If the input array is null, null is returned. If any of the index values is out of the range of the extent of the input array, an error results.

Note: This documents the double-precision version of the routine. Corresponding routines exist for other data types (float, long, int, short, byte, String, Object).

• Parameters:
  • array (array of floating point): input array
  • indices (integer, one or more): one or more index into the input array (may be negative to count back from the end)
• Return value
  • (array of floating point): array giving the elements specified by indices
• Examples:
  • pick(array(10,11,12,13), 0, 3) = [10, 13]
  • pick(array(10,11,12,13), -1, -2, -3) = [13, 12, 11]

array( values, ... )

Returns a floating point numeric array built from the given arguments.

• Parameters:
  • values (floating point, one or more): one or more array elements
• Return value
  • (array of floating point): array

intArray( values, ... )

Returns an integer numeric array built from the given arguments.

• Parameters:
  • values (integer, one or more): one or more array elements
• Return value
  • (array of integer): array

stringArray( values, ... )

Returns a String array built from the given arguments.

• Parameters:
  • values (String, one or more): one or more array elements
• Return value
  • (array of String): array