Skip to main content

SQL statistics functions for Datasette

Project description


PyPI Changelog Tests License

SQL statistics functions for Datasette


Install this plugin in the same environment as Datasette.

$ datasette install datasette-statistics


This plugin adds new SQL aggregate functions for use within Datasette:

These all use the implementations from the Python statistics library.

Use them like this:

select statistics_mean(numeric_column) from mytable


To set up this plugin locally, first checkout the code. Then create a new virtual environment:

cd datasette-statistics
python3 -mvenv venv
source venv/bin/activate

Or if you are using pipenv:

pipenv shell

Now install the dependencies and test dependencies:

pip install -e '.[test]'

To run the tests:


Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

datasette-statistics-0.2.tar.gz (2.6 kB view hashes)

Uploaded Source

Built Distribution

datasette_statistics-0.2-py3-none-any.whl (2.9 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page