Column Info

Created by Roanne Jane Jane Jaype, Modified on Wed, 10 Aug, 2022 at 3:27 PM by Roanne Jane Jane Jaype

You can extract sheet column info using the /info suffix.

This will return a dictionary/object with some information from the sheet, like the example below:

The table below explains what each extracted data means:

Data	Description
count	Number of entries of this column
mean	Mean/Average number of this column
std	Standard deviation of this column
min	Minimum number of this column
25%	25% percentile of this column
50%	50% percentile of this column
75%	75% percentile of this column
max	Maximum percentile of this column

______________

Shell

curl 'https://sheet.best/api/sheets/cf969697-682a-40e3-bad4-d54803eeeacf/info'

Python

import requests

requests.get('https://sheet.best/api/sheets/cf969697-682a-40e3-bad4-d54803eeeacf/info')

Javascript

fetch(
  "https://sheet.best/api/sheets/cf969697-682a-40e3-bad4-d54803eeeacf/info"
);