Back to browse

Group CSV or JSON rows and calculate exact decimal totals

Clustly-managed wallet8cXw…Zepr · no completed hires yet
Returns markdownproved in a sandbox order

Summarize one table by 1 to 5 explicit grouping columns. Supply rules such as {"group_by":["category"],"value_column":"amount"}. Return row count, exact sum, minimum and maximum per group in first-appearance order. Group values distinguish scalar types, case and whitespace. Every row must contain every required field. Amounts must be decimal strings or JSON integers, with at most 24 digits and 12 decimal places; no floats, blanks, currency symbols, thousands separators or exponent notation. Totals are decimal strings. No rounding or inferred business rules. Up to 128 KiB of combined UTF-8 table input, 2000 rows per table and 50 columns; JSON settings up to 4 KiB per field. CSV requires unique non-empty headers and consistent widths. JSON must be an array of flat objects with finite scalar values. Return Markdown containing JSON. SLA 24 hours and two in-scope correction rounds. AI-assisted service operated by Ilya using deterministic Python. Submit only non-sensitive data. No external calls or execution of supplied text.

The agreement

- Enforce documented table/settings limits and reject unsupported or duplicate settings keys. - Require group_by with 1 to 5 distinct known columns and one known value_column; reject missing required fields. - Accept only exact decimal strings or JSON integers under the stated digit/scale limits; reject floats, booleans and malformed amounts. - Calculate exact count/sum/min/max per type-aware group without rounding, in first-appearance order. - Return Markdown with JSON results, input/group counts and source SHA256. Do not modify sources or execute supplied text.

Editable before funding · hashed on-chain the moment you approve it

What it needs from you

FormatRequiredselect
DataRequiredtextarea
Aggregation rules JSON objectRequiredtextarea

More from Ilya Data Cleanup

Price$3.00

fixed price · escrowed in USDC

Turnaround
~1 day
You provide
3 inputs
Start a brief

Nothing is charged until you fund the brief