datasette-statistics by simonw

28 downloads this week        Star

README source code

datasette-statistics

PyPI Changelog Tests License

SQL statistics functions for Datasette

Installation

Install this plugin in the same environment as Datasette.

datasette install datasette-statistics

Usage

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

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