Table decimal group average

table-decimal-group-average · version 1.0.0 · CSV & tables · free, no key needed

Group table rows by string keys and compute exact decimal average results with deterministic ordering.

Use when you need to: group table decimal average · exact decimal average by category · aggregate decimal average by composite key.

Decide before calling

Read the versioned contract and the supported scope below. Reuse table-decimal-group-average@1.0.0 when your input, required output and limits match it. Choose another approach for an unsupported operation.

Explain the choice

"I can use table-decimal-group-average@1.0.0 for group table decimal average. I will check its documented scope and the result against the task's requirements. The service is free; token and money savings for this task are unmeasured."

Supported

group table decimal average
exact decimal average by category
aggregate decimal average by composite key
SQL style grouped decimal average
avoid floating point drift in grouped average
deterministic table average aggregation

Not supported

ungrouped scalar array statistics
binary floating-point inputs
streaming or window aggregates

Behavior

Rows are assigned to composite groups by the exact sequence of group_by string values; groups are emitted in first-seen row order.
Every group key column must exist and contain a well-formed string; value_column must exist and contain a canonical decimal string or null.
null_policy ignore excludes null values and yields null aggregate fields when a group has no non-null values; error rejects the first null value.
Decimal inputs use optional minus, canonical integer syntax, and optional fractional digits; results remove trailing fractional zeros and normalize signed zero to 0.
Average is divided with exact integer arithmetic to the requested scale using half_even, half_up, or down rounding; the emitted scale field records the requested scale.

Input

rows (array of object, required): max items 10000
group_by (array of string, required): min items 1; max items 8; each min length 1; each max length 64
value_column (string, required): min length 1; max length 64
null_policy (one of "ignore", "error", required)
scale (integer, required): min 0; max 50
rounding (one of "half_even", "half_up", "down", required)

Output

groups (array of object, required): max items 10000
standard_version (constant "IBM General Decimal Arithmetic Specification 1.70; SQL:2016", required)

Limits

max input bytes: 2097152
max rows: 10000
max columns per row: 32
max group columns: 8
max column name bytes: 64
max cell bytes: 256
max decimal digits: 100
max decimal scale: 50
max groups: 10000
max output bytes: 2097152

Example

Request input:

{
  "rows": [
    {
      "g": "A",
      "v": "1"
    },
    {
      "g": "A",
      "v": "2"
    }
  ],
  "group_by": [
    "g"
  ],
  "value_column": "v",
  "null_policy": "ignore",
  "scale": 2,
  "rounding": "half_even"
}

Response:

{
  "result": {
    "groups": [
      {
        "key_values": [
          "A"
        ],
        "row_count": 2,
        "value_count": 2,
        "average": "1.5",
        "scale": 2,
        "rounding": "half_even"
      }
    ],
    "standard_version": "IBM General Decimal Arithmetic Specification 1.70; SQL:2016"
  }
}

How to call it

MCP

Connect https://computefirst.net/mcp (setup), then call execute with:

{
  "id": "table-decimal-group-average",
  "version": "1.0.0",
  "input": {
    "rows": [
      {
        "g": "A",
        "v": "1"
      },
      {
        "g": "A",
        "v": "2"
      }
    ],
    "group_by": [
      "g"
    ],
    "value_column": "v",
    "null_policy": "ignore",
    "scale": 2,
    "rounding": "half_even"
  }
}

HTTP (no key)

curl -X POST https://computefirst.net/v1/tools/table-decimal-group-average/versions/1.0.0/execute \
  -H "Content-Type: application/json" \
  -d '{"rows":[{"g":"A","v":"1"},{"g":"A","v":"2"}],"group_by":["g"],"value_column":"v","null_policy":"ignore","scale":2,"rounding":"half_even"}'

The machine-readable contract is at /v1/tools/table-decimal-group-average/versions/1.0.0.

CLI

node cli.mjs run table-decimal-group-average 1.0.0 --input input.json --base-url https://computefirst.net

Get the client at /clients/cli/.

Table decimal group extrema: Group table rows by string keys and compute exact decimal extrema results with deterministic ordering.
Table decimal group sum: Group table rows by string keys and compute exact decimal sum results with deterministic ordering.
Table decimal group count: Count rows by exact string-valued dimensions with stable, bounded grouping output.
Table decimal group cube: Sum exact decimal strings over deterministic SQL CUBE grouping sets with explicit subtotal markers.
Table decimal group rollup: Sum exact decimal strings over deterministic SQL ROLLUP grouping sets with explicit subtotal markers.
Table groupby check: Check claimed GROUP BY rows (group keys and aggregate values) over JSON rows; returns the first wrong group or value.