Go to example tasks
Summarise a CSV or Google Sheet by URL (Group By)
Created by
Adam Pearce
Load a public CSV, Excel, JSON file or Google Sheet by link and group it: here the open ISO country-codes CSV on GitHub, grouped by continent with a country count, the number of distinct currencies and the lowest dial code per continent, sorted by size, downloaded as CSV and Excel. Swap in your own file or sheet link and field names.
Dataset Aggregate, Group By & Pivotnerolabs/dataset-aggregate-pivot
Region
Orders
Total amount
Avg amount
TextNumberBooleanListObject
Input
File URL (CSV, Excel, JSON or Google Sheet):https://raw.githubusercontent.com/datasets/country-codes/main/data/country-codes.csv
Group by field(s):Continent
Aggregations
function:count+2
alias:countries+2
Sort by column:countries
Sort direction:desc
Add a grand-total row:true
Export file formats:csv+1
Output fields
Region
Orders
Total amount
Avg amount
Sign up on Apify01
Create your Apify account to access the Dataset Aggregate, Group By & Pivot.
Start the run02
The Actor will start running based on the input automatically.
Receive the output03
Monitor the progress in real-time. You will be notified as soon as your dataset is complete and ready for review.
Integrate into your workflow04
The final output is delivered in JSON, CSV, or Excel format, ready to be plugged into your workflow.
