\(\renewcommand\AA{\unicode{x212B}}\)

StatisticsOfTableWorkspace v1

Summary

Calcuates columns statistics of a table workspace.

Properties

Name

Direction

Type

Default

Description

InputWorkspace

Input

TableWorkspace

Mandatory

Input table workspace.

ColumnIndices

Input

int list

Comma separated list of column indices for which statistics will be separated

OutputWorkspace

Output

TableWorkspace

Mandatory

Output workspace containing column statistics.

Description

Calculates mean, median, maximum, minimum and standard deviation for each numerical column of a table workspace.

Usage

Example - Getting statistics of a table workspace.

ws = CreateEmptyTableWorkspace()
ws.addColumn('int', 'a')
ws.addColumn('float', 'b')
ws.addRow([1, 3.2])
ws.addRow([2, 3.4])
ws.addRow([3, 3.6])
ws.addRow([4, 3.8])

stats = StatisticsOfTableWorkspace(ws)

for idx in range(stats.rowCount()):
    stat_name = stats.column('Statistic')[idx]
    stat_value = stats.column('a')[idx]
    print('%s of column \'a\' is %.3f' % (stat_name, stat_value))

Output:

StandardDev of column 'a' is 1.118
Minimum of column 'a' is 1.000
Median of column 'a' is 2.500
Maximum of column 'a' is 4.000
Mean of column 'a' is 2.500

Categories: AlgorithmIndex | Utility\Workspaces

Source

Python: StatisticsOfTableWorkspace.py