datasette-statistics by simonw

28 downloads this week        Star

README source code


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: