datasette-statistics
SQL statistics functions for Datasette
Installation
Install this plugin in the same environment as Datasette.
$ datasette install datasette-statistics
Usage
This plugin adds three new SQL aggregate functions for use within Datasette:
statistics_mean()for calculating the meanstatistics_median()for calculating the medianstatistics_mode()for calculating the mode
All three use the implementations from the Python statistics library.
Use them like this:
select statistics_mean(numeric_column) from mytable
Development
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:
pytest