Data

add_calculated_field

bare_script.add_calculated_field(data, field_name, expr, variables=None, options=None)

Add a calculated field to each row of a data array

Parameters:

• data (list[dict]) – The data array. Row objects are updated with the calculated field values.

• fieldName (str) – The calculated field name

• expr (str) – The calculated field expression

• variables (dict) – Additional variables for expression evaluation

• options (dict) – The script execution options

Returns:

The updated data array

Return type:

list[dict]

aggregate_data

bare_script.aggregate_data(data, aggregation)

Aggregate data rows

Parameters:

• data (list[dict]) – The data array

• aggregation (dict) – The aggregation model

Returns:

The aggregated data array

Return type:

list[dict]

filter_data

bare_script.filter_data(data, expr, variables=None, options=None)

Filter data rows

Parameters:

• data (list[dict]) – The data array

• expr (str) – The boolean filter expression

• variables (dict) – Additional variables for expression evaluation

• options (dict) – The script execution options

Returns:

The filtered data array

Return type:

list[dict]

join_data

bare_script.join_data(left_data, right_data, join_expr, right_expr=None, is_left_join=False, variables=None, options=None)

Join two data arrays

Parameters:

• leftData (list[dict]) – The left data array

• rightData (list[dict]) – The left data array

• joinExpr (str) – The join expression

• rightExpr (str) – The right join expression

• isLeftJoin (bool) – If true, perform a left join (always include left row)

• variables (dict) – Additional variables for expression evaluation

• options (dict) – The script execution options

Returns:

The joined data array

Return type:

list[dict]

sort_data

bare_script.sort_data(data, sorts)

Sort data rows

Parameters:

• data (list[dict]) – The data array

• sorts (list[list]) – The sort field-name/descending-sort tuples

Returns:

The sorted data array

Return type:

list[dict]

top_data

bare_script.top_data(data, count, category_fields=None)

Top data rows

Parameters:

• data (list[dict]) – The data array

• count (int) – The number of rows to keep

• categoryFields (list[str]) – The category fields

Returns:

The top data array

Return type:

list[dict]

validate_data

bare_script.validate_data(data, csv=False)

Determine data field types and parse/validate field values

Parameters:

• data (list[dict]) – The data array. Row objects are updated with parsed/validated values.

• csv (bool) – If true, parse value strings

Returns:

The map of field name to field type (“boolean”, “datetime”, “number”, “string”)

Return type:

dict

Raises:

TypeError – Data is invalid