Aggregating Data

Created by Roanne Jane Jane Jaype, Modified on Mon, 1 Aug, 2022 at 3:35 PM by Roanne Jane Jane Jaype

You can make aggregations to columns using the /agg/<operation> suffix.

This can be a useful way to extract data directly from our API, without having to calculate it yourself.

Operation	Description
sum	Sum the value for each column
prod	Multiply the value for each column
max	Extract the maximum value for each column
min	Extract the minimum value for each column
mean	Extract the mean/average value for each column
median	Extract the median value for each column
std	Extract the standard deviation value for each column
var	Extract the variance value for each column
any	True if any row contain a a value, False otherwise
all	True if all rows contain a a value, False otherwise

Maximum column value extraction

https://sheet.best/api/sheets/cf969697-682a-40e3-bad4-d54803eeeacf/agg/max

Max Aggregation Example

Sum all columns

https://sheet.best/api/sheets/cf969697-682a-40e3-bad4-d54803eeeacf/agg/sum

Values that cannot be summed are not displayed

Sum Aggregation Example

Average/Mean for all columns

https://sheet.best/api/sheets/cf969697-682a-40e3-bad4-d54803eeeacf/agg/mean

Values that cannot be averaged are not displayed

Average/Mean Aggregation Example

_______________________

Shell

# Get the maximum value for each column in the sheet
curl 'https://sheet.best/api/sheets/cf969697-682a-40e3-bad4-d54803eeeacf/agg/max'

# Get the minimum value for each column in the sheet
curl 'https://sheet.best/api/sheets/cf969697-682a-40e3-bad4-d54803eeeacf/agg/min'

Python

import requests

# Get the maximum value for each column in the sheet
requests.get('https://sheet.best/api/sheets/cf969697-682a-40e3-bad4-d54803eeeacf/agg/max')

# Get the minimum value for each column in the sheet
requests.get('https://sheet.best/api/sheets/cf969697-682a-40e3-bad4-d54803eeeacf/agg/min')

Javascript

// Get the maximum value for each column in the sheet
fetch(
  "https://sheet.best/api/sheets/cf969697-682a-40e3-bad4-d54803eeeacf/agg/max"
);

// Get the minimum value for each column in the sheet
fetch(
  "https://sheet.best/api/sheets/cf969697-682a-40e3-bad4-d54803eeeacf/agg/min"
);