count#

count(input)[source]#

Counts the number of non-null elements in the input expression.

Example:

SQL#

SELECT count(x) FROM tbl

Input#

╭───────╮
│ x     │
│ ---   │
│ Int64 │
╞═══════╡
│ 100   │
├╌╌╌╌╌╌╌┤
│ 200   │
├╌╌╌╌╌╌╌┤
│ null  │
╰───────╯
(Showing first 3 of 3 rows)

Output#

╭───────╮
│ x     │
│ ---   │
│ Int64 │
╞═══════╡
│ 2     │
╰───────╯
(Showing first 1 of 1 rows)

count