tablecloth.pipeline — scicloj/tablecloth 6.051

Linear pipeline operations.

->array clj

(->array colname)

(->array colname datatype)

Convert numerical column(s) to java array

add-column clj

(add-column column-name column)

(add-column column-name column size-strategy)

Add or update (modify) column under column-name.

column can be sequence of values or generator function (which gets ds as input).

• ds - a dataset
• column-name - if it's existing column name, column will be replaced
• column - can be column (from other dataset), sequence, single value or function. Too big columns are always trimmed. Too small are cycled or extended with missing values (according to size-strategy argument)
• size-strategy (optional) - when new column is shorter than dataset row count, following strategies are applied:
  • :cycle - repeat data
  • :na - append missing values
  • :strict - (default) throws an exception when sizes mismatch

add-columns clj

(add-columns columns-map)

(add-columns columns-map size-strategy)

Add or updade (modify) columns defined in columns-map (mapping: name -> column)

add-or-replace-column clj

(add-or-replace-column column-name column)

(add-or-replace-column column-name column size-strategy)

add-or-replace-columns clj

(add-or-replace-columns columns-map)

(add-or-replace-columns columns-map size-strategy)

aggregate clj

(aggregate aggregator)

(aggregate aggregator options)

Aggregate dataset by providing:

• aggregation function
• map with column names and functions
• sequence of aggregation functions

Aggregation functions can return:

• single value
• seq of values
• map of values with column names

aggregate-columns clj

(aggregate-columns columns-selector column-aggregators)

(aggregate-columns columns-selector column-aggregators options)

Aggregates each column separately

anti-join clj

(anti-join ds-right columns-selector)

(anti-join ds-right columns-selector options)

append clj

(append & args)

as-regular-dataset clj

(as-regular-dataset)

Remove grouping tag

asof-join clj

(asof-join ds-right colname)

(asof-join ds-right colname options)

bind clj

(bind & args)

build-pipelined-function clj macro

(build-pipelined-function f m)

by-rank clj

(by-rank columns-selector rank-predicate)

(by-rank columns-selector rank-predicate 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

clone clj

(clone)

Clone an object. Can clone anything convertible to a reader.

column clj

(column colname)

column-count clj

(column-count)

column-names clj

(column-names)

(column-names columns-selector)

(column-names columns-selector meta-field)

columns clj

(columns)

(columns result-type)

Returns columns of dataset. Result type can be any of:

• :as-map
• :as-double-arrays
• :as-seqs

concat clj

(concat & args)

concat-copying clj

(concat-copying & args)

convert-types clj

(convert-types coltype-map-or-columns-selector)

(convert-types columns-selector new-types)

Convert type of the column to the other type.

dataset->str clj

(dataset->str)

(dataset->str options)

Convert a dataset to a string. Prints a single line header and then calls dataset-data->str.

For options documentation see dataset-data->str.

dataset-name clj

(dataset-name)

dataset? clj

(dataset?)

Is ds a dataset type?

difference clj

(difference ds-right)

(difference ds-right options)

drop clj

(drop columns-selector rows-selector)

Drop columns and rows.

drop-columns clj

(drop-columns)

(drop-columns columns-selector)

(drop-columns columns-selector meta-field)

Drop columns by (returns dataset):

• name
• sequence of names
• map of names with new names (rename)
• function which filter names (via column metadata)

drop-missing clj

(drop-missing)

(drop-missing columns-selector)

Drop rows with missing values

columns-selector selects columns to look at missing values

drop-rows clj

(drop-rows)

(drop-rows rows-selector)

(drop-rows rows-selector options)

Drop rows using:

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

empty-ds? clj

(empty-ds?)

fill-range-replace clj

(fill-range-replace colname max-span)

(fill-range-replace colname max-span missing-strategy)

(fill-range-replace colname max-span missing-strategy missing-value)

first clj

(first)

fold-by clj

(fold-by columns-selector)

(fold-by columns-selector folding-function)

full-join clj

(full-join ds-right columns-selector)

(full-join ds-right columns-selector options)

group-by clj

(group-by grouping-selector)

(group-by grouping-selector options)

Group dataset by:

• column name
• list of columns
• map of keys and row indexes
• function getting map of values

Options are:

• select-keys - when grouping is done by function, you can limit fields to a select-keys seq.
• result-type - return results as dataset (:as-dataset, default) or as map of datasets (:as-map) or as map of row indexes (:as-indexes) or as sequence of (sub)datasets
• other parameters which are passed to dataset fn

When dataset is returned, meta contains :grouped? set to true. Columns in dataset:

• name - group name
• group-id - id of the group (int)
• data - group as dataset

grouped? clj

(grouped?)

Is dataset represents grouped dataset (result of group-by)?

groups->map clj

(groups->map)

Convert grouped dataset to the map of groups

groups->seq clj

(groups->seq)

has-column? clj

(has-column? column-name)

head clj

(head)

(head n)

info clj

(info)

(info result-type)

inner-join clj

(inner-join ds-right columns-selector)

(inner-join ds-right columns-selector options)

intersect clj

(intersect ds-right)

(intersect ds-right options)

join-columns clj

(join-columns target-column columns-selector)

(join-columns target-column columns-selector conf)

last clj

(last)

left-join clj

(left-join ds-right columns-selector)

(left-join ds-right columns-selector options)

map-columns clj

(map-columns column-name map-fn)

(map-columns column-name columns-selector map-fn)

(map-columns column-name new-type columns-selector map-fn)

mark-as-group clj

(mark-as-group)

Add grouping tag

order-by clj

(order-by columns-or-fn)

(order-by columns-or-fn comparators)

(order-by columns-or-fn comparators options)

Order dataset by:

• column name
• columns (as sequence of names)
• key-fn
• sequence of columns / key-fn Additionally you can ask the order by:
• :asc
• :desc
• custom comparator function

pivot->longer clj

(pivot->longer)

(pivot->longer columns-selector)

(pivot->longer columns-selector options)

tidyr pivot_longer api

pivot->wider clj

(pivot->wider columns-selector value-columns)

(pivot->wider columns-selector value-columns options)

print-dataset clj

(print-dataset)

(print-dataset options)

process-all-api-symbols clj macro

(process-all-api-symbols)

process-group-data clj

(process-group-data f)

(process-group-data f parallel?)

rand-nth clj

(rand-nth)

(rand-nth options)

random clj

(random)

(random n)

(random n options)

read-nippy clj

(read-nippy)

rename-columns clj

(rename-columns columns-mapping)

(rename-columns columns-selector columns-map-fn)

Rename columns with provided old -> new name map

reorder-columns clj

(reorder-columns columns-selector & args)

Reorder columns using column selector(s). When column names are incomplete, the missing will be attached at the end.

replace-missing clj

(replace-missing)

(replace-missing strategy)

(replace-missing columns-selector strategy)

(replace-missing columns-selector strategy value)

right-join clj

(right-join ds-right columns-selector)

(right-join ds-right columns-selector options)

row-count clj

(row-count)

rows clj

(rows)

(rows result-type)

Returns rows of dataset. Result type can be any of:

• :as-maps
• :as-double-arrays
• :as-seqs

select clj

(select columns-selector rows-selector)

Select columns and rows.

select-columns clj

(select-columns)

(select-columns columns-selector)

(select-columns columns-selector meta-field)

Select columns by (returns dataset):

• name
• sequence of names
• map of names with new names (rename)
• function which filter names (via column metadata)

select-missing clj

(select-missing)

(select-missing columns-selector)

Select rows with missing values

columns-selector selects columns to look at missing values

select-rows clj

(select-rows)

(select-rows rows-selector)

(select-rows rows-selector options)

Select rows using:

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

semi-join clj

(semi-join ds-right columns-selector)

(semi-join ds-right columns-selector options)

separate-column clj

(separate-column column separator)

(separate-column column target-columns separator)

(separate-column column target-columns separator conf)

set-dataset-name clj

(set-dataset-name ds-name)

shape clj

(shape)

Returns shape of the dataset [rows, cols]

shuffle clj

(shuffle)

(shuffle options)

split clj

(split)

(split split-type)

(split split-type opts)

Split given dataset into 2 or more (holdout) splits

As the result two new columns are added:

• :$split-name - with subgroup name
• :$split-id - fold id/repetition id

split-type can be one of the following:

• :kfold - k-fold strategy, :k defines number of folds (defaults to 5), produces k splits
• :bootstrap - :ratio defines ratio of observations put into result (defaults to 1.0), produces 1 split
• :holdout - split into two parts with given ratio (defaults to 2/3), produces 1 split
• :loo - leave one out, produces the same number of splits as number of observations

:holdout can accept also probabilites or ratios and can split to more than 2 subdatasets

Additionally you can provide:

• :seed - for random number generator
• :repeats - repeat procedure :repeats times
• :partition-selector - same as in group-by for stratified splitting to reflect dataset structure in splits.
• :split-names names of subdatasets different than default, ie. [:train :test :split-2 ...]
• :split-col-name - a column where name of split is stored, either :train or :test values (default: :$split-name)
• :split-id-col-name - a column where id of the train/test pair is stored (default: :$split-id)

Rows are shuffled before splitting.

In case of grouped dataset each group is processed separately.

See more

split->seq clj

(split->seq)

(split->seq split-type)

(split->seq split-type opts)

Returns split as a sequence of train/test datasets or map of sequences (grouped dataset)

tail clj

(tail)

(tail n)

ungroup clj

(ungroup)

(ungroup options)

Concat groups into dataset.

When add-group-as-column or add-group-id-as-column is set to true or name(s), columns with group name(s) or group id is added to the result.

Before joining the groups groups can be sorted by group name.

union clj

(union & args)

unique-by clj

(unique-by)

(unique-by columns-selector)

(unique-by columns-selector options)

unmark-group clj

(unmark-group)

Remove grouping tag

unroll clj

(unroll columns-selector)

(unroll columns-selector options)

update-columns clj

(update-columns columns-map)

(update-columns columns-selector update-functions)

write! clj

(write! output-path)

(write! output-path options)

Write a dataset out to a file. Supported forms are:

(ds/write! test-ds "test.csv")
(ds/write! test-ds "test.tsv")
(ds/write! test-ds "test.tsv.gz")
(ds/write! test-ds "test.nippy")
(ds/write! test-ds out-stream)

Options:

• :max-chars-per-column - csv,tsv specific, defaults to 65536 - values longer than this will cause an exception during serialization.
• :max-num-columns - csv,tsv specific, defaults to 8192 - If the dataset has more than this number of columns an exception will be thrown during serialization.
• :quoted-columns - csv specific - sequence of columns names that you would like to always have quoted.
• :file-type - Manually specify the file type. This is usually inferred from the filename but if you pass in an output stream then you will need to specify the file type.
• :headers? - if csv headers are written, defaults to true.

write-nippy! clj

(write-nippy! filename)