summarise-datatable

Description

summarise-datatable adaptor summarises information about specified columns in a datatable.

Inputs

data Type: datatable Required: Yes The datatable to be summarised.

columns Type: list Required: No A list of columns to be summarised. If unspecified, all columns will be summarised.

Outputs

summary Type: datatable A datatable containing summarised information about each column.

Examples

Example 1: Default behaviour.

Inputs:

data:

id	code	name
1	GB	United Kingdom
2	TR	Turkey
3	US	United States
4	IND	India
5	IND	India
6	us	United States

columns: null(empty)

Outputs:

summary:

Column	Type	Missing%(out of 6)	Unique values	Mean
id	number	0.0%(0)	6	3.5
code	string	0.0%(0)	5
name	string	0.0%(0)	4

-> Summarised information about the entire datatable.