tablecloth.api.rows — scicloj/tablecloth 8.021

between clj

(between ds col-name low high)

(between ds col-selector low high {:keys [missing-default] :as options})

Detect where values fall in a specified range in a numeric column. This is a shortcut for (< low x high).

Usage

(between ds col-name low high)

(between ds col-name low high {:missing-default val})

Arguments

• ds - A tech.ml.dataset (i.e a tablecloth dataset)
• column-name - Name of the column to use in the comparison
• low - Lower bound for values of column-name
• high - Upper bound for values of column-name
• options - optional Options map containing the key missing-default to specify what value to use in the case that the value of (col-name row) is nil. Throws an error if there are any missing values in the column and this option is not provided.

Returns

A dataset with only rows that contain values between low and high in column col-name

by-rank clj

(by-rank ds columns-selector rank-predicate)

(by-rank ds
         columns-selector
         rank-predicate
         {:keys [desc? ties] :or {desc? true ties :dense} :as options})

Select rows using rank on a column, ties are resolved using :dense method.

See R docs. Rank uses 0 based indexing.

Possible :ties strategies: :average, :first, :last, :random, :min, :max, :dense. :dense is the same as in data.table::frank from R

:desc? set to true (default) order descending before calculating rank

drop-rows clj

(drop-rows ds)

(drop-rows ds rows-selector)

(drop-rows ds
           rows-selector
           {:keys [select-keys pre result-type parallel?] :as options})

Drop rows using:

• row id
• seq of row ids
• seq of true/false
• fn with predicate

duplicate-rows clj

(duplicate-rows ds)

Filter a dataset for only duplicated rows.

Usage

(duplicate-rows ds)

Arguments

• ds - A tech.ml.dataset (i.e a tablecloth dataset)

Returns

A dataset containing only rows that are exact duplicates.

first clj

(first ds)

First row

head clj

(head ds)

(head ds n)

First n rows (default 5)

last clj

(last ds)

Last row

map-rows clj

(map-rows ds map-fn)

(map-rows ds map-fn options)

Map a function across the rows of the dataset producing a new dataset that is merged back into the original potentially replacing existing columns.

rand-nth clj

(rand-nth ds)

(rand-nth ds {:keys [seed] :as options})

Returns single random row

random clj

(random ds)

(random ds n)

(random ds n {:keys [repeat? seed] :or {repeat? true} :as options})

Returns (n) random rows with repetition

select-rows clj

(select-rows ds)

(select-rows ds rows-selector)

(select-rows ds
             rows-selector
             {:keys [select-keys pre result-type parallel?] :as options})

Select rows using:

• row id
• seq of row ids
• seq of true/false
• fn with predicate

shuffle clj

(shuffle ds)

(shuffle ds {:keys [seed] :as options})

Shuffle dataset (with seed)

tail clj

(tail ds)

(tail ds n)

Last n rows (default 5)