Pricing

from $1.00 / 1,000 input row processeds

Try for free

Go to Apify Store

Dataset Aggregate, Group By & Pivot

Try for free

Returns GROUP BY and pivot tables for any Apify dataset or JSON array: count, sum, average, min, max, median per group, date buckets, plus CSV or Excel export. Inputs: dataset ID or inline data, group-by fields, aggregations. Agent-ready: pay per event (x402 and MCP), per input row and file.

Pricing

from $1.00 / 1,000 input row processeds

Rating

0.0

(0)

Developer

Adam Pearce

Actor stats

Bookmarked

Total users

Monthly active users

12 hours ago

Last modified

Categories

Developer tools

Automation

Agents

You can access the Dataset Aggregate, Group By & Pivot programmatically from your own applications by using the Apify API. You can also choose the language preference from below. To use the Apify API, you’ll need an Apify account and your API token, found in API & Integrations in Apify Console.

Python

JavaScript

CLI

OpenAPI

HTTP

MCP

$echo '{
<  "data": [
<    {
<      "orderId": 1001,
<      "region": "North",
<      "product": "Widget",
<      "amount": "$1,200.00",
<      "orderedAt": "2026-07-03"
<    },
<    {
<      "orderId": 1002,
<      "region": "North",
<      "product": "Gadget",
<      "amount": 350,
<      "orderedAt": "2026-07-18"
<    },
<    {
<      "orderId": 1003,
<      "region": "South",
<      "product": "Widget",
<      "amount": "890.50",
<      "orderedAt": "2026-07-22"
<    },
<    {
<      "orderId": 1004,
<      "region": "south",
<      "product": "Gizmo",
<      "amount": 120,
<      "orderedAt": "2026-08-02"
<    },
<    {
<      "orderId": 1005,
<      "region": "East",
<      "product": "Widget",
<      "amount": 2400,
<      "orderedAt": "2026-08-05"
<    },
<    {
<      "orderId": 1006,
<      "region": "East",
<      "product": "Gadget",
<      "amount": "n/a",
<      "orderedAt": "2026-08-09"
<    },
<    {
<      "orderId": 1007,
<      "region": "North",
<      "product": "Gizmo",
<      "amount": 75,
<      "orderedAt": "2026-08-11"
<    },
<    {
<      "orderId": 1008,
<      "region": "",
<      "product": "Widget",
<      "amount": 410,
<      "orderedAt": "2026-08-14"
<    }
<  ],
<  "groupByFields": [
<    "region"
<  ],
<  "aggregations": [
<    {
<      "function": "count",
<      "alias": "orders"
<    },
<    {
<      "field": "amount",
<      "function": "sum",
<      "alias": "total_amount"
<    },
<    {
<      "field": "amount",
<      "function": "avg",
<      "alias": "avg_amount"
<    }
<  ],
<  "exportFormats": [
<    "csv",
<    "xlsx"
<  ]
<}' |
<apify call nerolabs/dataset-aggregate-pivot --silent --output-dataset

Dataset Aggregate, Group By & Pivot - SQL GROUP BY on Apify API through CLI

The Apify CLI is the official tool that allows you to use Dataset Aggregate, Group By & Pivot locally, providing convenience functions and automatic retries on errors.

Install Apify CLI

Using installation script (macOS/Linux):

$curl -fsSL https://apify.com/install-cli.sh | bash

Using installation script (Windows):

$irm https://apify.com/install-cli.ps1 | iex

Using Homebrew:

$brew install apify-cli

Using npm:

$npm install -g apify-cli

Other API clients include:

Dataset Aggregate, Group By & Pivot API in Python

Dataset Aggregate, Group By & Pivot API in JavaScript

Dataset Aggregate, Group By & Pivot OpenAPI definition

Dataset Aggregate, Group By & Pivot API

Dataset Cleaner & Exporter

nerolabs/dataset-cleaner-exporter

Returns a deduplicated, flattened and cleaned copy of any Apify dataset or JSON array, plus CSV and Excel files. Inputs: dataset ID or inline data, dedup mode and keys, flatten, email/phone/URL cleaning, export formats. Agent-ready: pay per event (x402 and MCP), per cleaned record and file.

Adam Pearce

Facebook Group Posts Scraper

khadinakbar/facebook-group-posts-scraper

Scrape public Facebook group posts by group URL or group ID. Export post text, author, reaction/comment/share counts, media URLs, top comments, and pagination cursors. No login or cookies required. MCP/API-ready.

Khadin Akbar

Facebook Groups Scraper

khadinakbar/facebook-groups-scraper

Scrape public Facebook group posts by group URL or group ID. Export post text, author, engagement counts, media URLs, top comments, and pagination cursors. MCP/API-ready.

Khadin Akbar

Facebook group member scraper

curious_coder/facebook-group-member-scraper

Scrape facebook group members of any group with all available information

Curious Coder

2.1K

2.5

Facebook Group Posts Scraper

powerai/facebook-group-posts-scraper

Search Facebook group posts by keywords—optional group and date filters—with authors, text, reactions, and media in structured rows.

PowerAI

163

Facebook Groups Scraper

api-ninja/facebook-groups-scraper

📘 Extract Facebook group posts, future events, and group details from one or more group URLs, handles, or IDs.

API ninja

218

5.0

Facebook Search Groups Results Scraper

memo23/facebook-search-groups-scraper

Scrape facebook groups from search results and get important details such as group name, description, is group public or private, group members count, activity and group URL.

Muhamed Didovic

229

1.0

Facebook Group Posts And Details Scraper

scrapio/facebook-group-posts-and-details-scraper

Extract Facebook Group content with precision. Capture posts, media, comments, reactions, authors, and activity insights across any public group. Perfect for analysts, marketers, and researchers building datasets for monitoring group behavior or engagement trends.

Scrapio

Dataset Diff & Change Detector

nerolabs/dataset-diff-detector

Returns what was added, removed or changed between two Apify datasets or JSON arrays, matched by key, field by field, with an optional CSV or Excel diff report. Inputs: old and new dataset IDs or inline data, key fields. Agent-ready: pay per event (x402 and MCP), per difference found and file.

Adam Pearce