Kategorien

← View All Tools

CSV Data Grouper

Group CSV data by specified columns with aggregation options. Perfect for summarizing and analyzing large datasets by categories, dates, or other criteria.

Columns to group data by. Multiple columns will create nested groups.

JSON format: [{"column": "Amount", "function": "sum", "as": "Total_Amount"}] Simple format: Amount:sum,Name:count Default: Count records per group Available functions: count, sum, avg/average, min, max, first, last, join, unique, count_unique

Remove whitespace from beginning and end of cell values

API-Dokumentation

Request-Endpunkt

POST /de/api/tools/csv-data-grouper

Request-Parameter

Parameter-Name Typ Erforderlich Beschreibung
csvInput textarea Ja -
delimiter select Ja -
groupByColumns text Ja Columns to group data by. Multiple columns will create nested groups.
aggregationOptions textarea Nein JSON format: [{"column": "Amount", "function": "sum", "as": "Total_Amount"}] Simple format: Amount:sum,Name:count Default: Count records per group Available functions: count, sum, avg/average, min, max, first, last, join, unique, count_unique
outputFormat select Ja -
includeHeader checkbox Nein -
sortGroups checkbox Nein -
trimValues checkbox Nein Remove whitespace from beginning and end of cell values

Antwortformat

{
  "result": "Processed text content",
  "error": "Error message (optional)",
  "message": "Notification message (optional)",
  "metadata": {
    "key": "value"
  }
}
Text: Text

MCP-Dokumentation

Fügen Sie dieses Tool zu Ihrer MCP-Server-Konfiguration hinzu: 

{
  "mcpServers": {
    "elysiatools-csv-data-grouper": {
      "name": "csv-data-grouper",
      "description": "Group CSV data by specified columns with aggregation options. Perfect for summarizing and analyzing large datasets by categories, dates, or other criteria.",
      "baseUrl": "https://elysiatools.com/mcp/sse?toolId=csv-data-grouper",
      "command": "",
      "args": [],
      "env": {},
      "isActive": true,
      "type": "sse"
    }
  }
}

Sie können mehrere Tools verketten, z.B.: `https://elysiatools.com/mcp/sse?toolId=png-to-webp,jpg-to-webp,gif-to-webp`, maximal 20 Tools.

Wenn Sie auf Probleme stoßen, kontaktieren Sie uns bitte bei [email protected]