stats/summary
col-count
(col-count [col :int] :int)
count non-null values in a float64 column.
| col | :int tur-frame float64 column handle |
:int number of non-null elements.
(col-count c) ; => 100
Since: ST1
col-sum
(col-sum [col :int] :float)
sum of non-null values in a float64 column.
| col | :int tur-frame float64 column handle |
:float sum (0.0 if all null / empty).
Since: ST1
col-mean
(col-mean [col :int] :float)
arithmetic mean of non-null values.
| col | :int tur-frame float64 column handle |
:float mean, or NaN if empty.
Since: ST1
col-median
(col-median [col :int] :float)
median of non-null values (type-7 interpolation).
| col | :int tur-frame float64 column handle |
:float median, or NaN if empty.
Since: ST1
col-mode
(col-mode [col :int] :float)
most frequent value (first occurrence on tie).
| col | :int tur-frame float64 column handle |
:float mode, or NaN if empty.
Since: ST1
col-var
(col-var [col :int] :float)
sample variance (n-1 denominator) of non-null values.
| col | :int tur-frame float64 column handle |
:float variance, or NaN if fewer than 2 values.
Since: ST1
col-sd
(col-sd [col :int] :float)
sample standard deviation of non-null values.
| col | :int tur-frame float64 column handle |
:float standard deviation, or NaN if fewer than 2 values.
Since: ST1
col-min
(col-min [col :int] :float)
minimum non-null value.
| col | :int tur-frame float64 column handle |
:float minimum, or NaN if empty.
Since: ST1
col-max
(col-max [col :int] :float)
maximum non-null value.
| col | :int tur-frame float64 column handle |
:float maximum, or NaN if empty.
Since: ST1
col-range
(col-range [col :int] :float)
max - min of non-null values.
| col | :int tur-frame float64 column handle |
:float range, or NaN if empty.
Since: ST1
col-quantile
(col-quantile [col :int q :float] :float)
quantile via type-7 linear interpolation.
| col | :int tur-frame float64 column handle | |
| q | :float quantile in [0, 1] |
:float quantile value, or NaN if empty.
(col-quantile c 0.25) ; => first quartile
Since: ST1
col-iqr
(col-iqr [col :int] :float)
interquartile range (Q3 - Q1).
| col | :int tur-frame float64 column handle |
:float IQR, or NaN if empty.
Since: ST1
col-skewness
(col-skewness [col :int] :float)
Fisher-Pearson skewness coefficient.
| col | :int tur-frame float64 column handle |
:float skewness, or NaN if fewer than 3 values.
Since: ST1
col-kurtosis
(col-kurtosis [col :int] :float)
excess kurtosis (Fisher's definition, = 0 for normal).
| col | :int tur-frame float64 column handle |
:float excess kurtosis, or NaN if fewer than 4 values.
Since: ST1
frame-count
(frame-count [f :int name :cstr] :int)
count non-null values in a named column of a frame.
| f | :int frame handle | |
| name | :cstr column name |
:int non-null count, or -1 if column not found.
Since: ST1
frame-sum
(frame-sum [f :int name :cstr] :float)
sum of a named column.
Since: ST1
frame-mean
(frame-mean [f :int name :cstr] :float)
mean of a named column.
Since: ST1
frame-median
(frame-median [f :int name :cstr] :float)
median of a named column.
Since: ST1
frame-mode
(frame-mode [f :int name :cstr] :float)
mode of a named column.
Since: ST1
frame-var
(frame-var [f :int name :cstr] :float)
sample variance of a named column.
Since: ST1
frame-sd
(frame-sd [f :int name :cstr] :float)
sample standard deviation of a named column.
Since: ST1
frame-min
(frame-min [f :int name :cstr] :float)
minimum of a named column.
Since: ST1
frame-max
(frame-max [f :int name :cstr] :float)
maximum of a named column.
Since: ST1
frame-range
(frame-range [f :int name :cstr] :float)
range (max-min) of a named column.
Since: ST1
frame-quantile
(frame-quantile [f :int name :cstr q :float] :float)
quantile of a named column.
Since: ST1
frame-iqr
(frame-iqr [f :int name :cstr] :float)
IQR of a named column.
Since: ST1
frame-skewness
(frame-skewness [f :int name :cstr] :float)
skewness of a named column.
Since: ST1
frame-kurtosis
(frame-kurtosis [f :int name :cstr] :float)
excess kurtosis of a named column.
Since: ST1
describe
(describe [f :int] :int)
pandas-style descriptive summary of all float64 columns.
| f | :int frame handle |
:int new frame with columns: stat (utf8), then one column per numeric input column. Rows: count, mean, sd, min, 25%, 50%, 75%, max.
(describe my-frame)
Since: ST1
Internal definitions
__frame-col-by-name