wiki:S3/S3Report

Version 2 (modified by Dominic König, 10 years ago) ( diff )

--

S3Cube

S3Cube is a REST method handler for data analysis.

Functionality

S3Cube can generate contingency tables (a.k.a. pivot tables) from S3Resources.

Dependencies

S3Cube uses pyvttbl to generate contingency tables. A modified version of pyvttbl is integrated into the S3 framework.

Pyvttbl requires the following Python modules:

  • scipy
  • numpy
  • matplotlib

Python 2.7 is recommended for S3Cube, however it would work with Python 2.6.

URL methods

S3Cube responds to the analyze URL method.

The following parameters are accepted:

ParameterExplanationrequired?
rowsthe name of the field to be used for the table rowsyes
colsthe name of the field to be used for the table columnsyes
factthe name of the field to be used for the instance valuesyes
aggregatethe aggregation functionno

S3Cube supports a number of aggregation functions. The following functions have been tested so far:

FunctionExplanation
lista comma-separated list of all instance values
countthe number of instance values
sumthe sum of all instance values
avgthe average (mean) of all instance values

Further Development

The following enhancements are currently under development:

  • Totals row and column
  • Support for JSON, CSV and XLS exports
  • Support for client-side graphs representation (via JSON)
Note: See TracWiki for help on using the wiki.