count

Syntax

count(X)

Arguments

X is a scalar/vector/matrix/table.

Details

size returns the number of elements in a vector/matrix, while count returns the number of non-null elements in a vector/matrix. count can be used in a SQL query, but size cannot. For tables, size and count both return the number of rows. Please also check related function: size.

Examples

$ count(3 NULL 5 6);
3
$ size(3 NULL 5 6);
4

$ m=1 2 3 NULL 4 5$2:3;
$ m;

#0	#1	#2
1	3	4
2		5

$ count(m);
5
$ size(m);
6

$ t = table(1 NULL 3 as id, 3 NULL 9 as qty);
$ t;

id	qty
1	3
3	9

$ count(t);
3
$ size(t);
3