Operator catalog

More tags45

All operators

Showing 441–480 of 638
OperatorVersionsExecutorTrustDownloadsActions
galaxy_split_table_by_rowsAuthor dacp-examplesGalaxy · Tabular data

Group consecutive rows into fixed-size chunks.

python12.2 KiB5
galaxy_split_table_on_columnAuthor dacp-examplesGalaxy · Tabular data

Group TSV rows by a selected column.

python12.2 KiB3
galaxy_sql_above_group_averageAuthor dacp-examplesGalaxy · SQL · Tabular data

Select values above the mean for their own key.

python13.1 KiB3
galaxy_sql_anti_joinAuthor dacp-examplesGalaxy · SQL · Tabular data

Keep source rows whose keys are absent from the reference.

python13.0 KiB3
galaxy_sql_append_tagged_rowsAuthor dacp-examplesGalaxy · SQL · Tabular data

Stack TSV rows and mark the input stream of each row.

python13.1 KiB3
galaxy_sql_changed_keysAuthor dacp-examplesGalaxy · SQL · Tabular data

List matching keys whose numeric values differ.

python13.0 KiB3
galaxy_sql_cumulative_distributionAuthor dacp-examplesGalaxy · SQL · Tabular data

Calculate the cumulative fraction at or below each value.

python13.0 KiB3
galaxy_sql_default_missingAuthor dacp-examplesGalaxy · SQL · Tabular data

Fill missing numeric values with a supplied default.

python13.1 KiB3
galaxy_sql_delta_nextAuthor dacp-examplesGalaxy · SQL · Tabular data

Calculate change to the following row.

python13.0 KiB3
galaxy_sql_delta_previousAuthor dacp-examplesGalaxy · SQL · Tabular data

Calculate change from the previous row.

python13.0 KiB3
galaxy_sql_dense_rankAuthor dacp-examplesGalaxy · SQL · Tabular data

Rank values without gaps after ties.

python13.0 KiB3
galaxy_sql_distinct_keysAuthor dacp-examplesGalaxy · SQL · Tabular data

List each distinct key in lexical order.

python13.0 KiB3
galaxy_sql_duplicate_keysAuthor dacp-examplesGalaxy · SQL · Tabular data

List the keys that appear more than once.

python13.0 KiB3
galaxy_sql_filter_key_prefixAuthor dacp-examplesGalaxy · SQL · Tabular data

Filter rows by a literal prefix of the key.

python13.1 KiB3
galaxy_sql_filter_value_rangeAuthor dacp-examplesGalaxy · SQL · Tabular data

Filter rows by an inclusive numeric range.

python13.2 KiB3
galaxy_sql_first_per_keyAuthor dacp-examplesGalaxy · SQL · Tabular data

Keep the first observed value of each key.

python13.0 KiB3
galaxy_sql_full_joinAuthor dacp-examplesGalaxy · SQL · Tabular data

Keep matched and unmatched rows from either TSV stream.

python13.0 KiB5
galaxy_sql_group_centerAuthor dacp-examplesGalaxy · SQL · Tabular data

Subtract each group mean from its rows.

python13.0 KiB3
galaxy_sql_group_fractionAuthor dacp-examplesGalaxy · SQL · Tabular data

Measure each value’s share of its group total.

python13.0 KiB3
galaxy_sql_group_spreadAuthor dacp-examplesGalaxy · SQL · Tabular data

Calculate the range between each key’s maximum and minimum.

python13.0 KiB3
galaxy_sql_inner_joinAuthor dacp-examplesGalaxy · SQL · Tabular data

Return rows with matching keys in both TSV streams.

python13.0 KiB3
galaxy_sql_key_differenceAuthor dacp-examplesGalaxy · SQL · Tabular data

Return distinct source keys missing from the reference stream.

python13.0 KiB3
galaxy_sql_key_intersectionAuthor dacp-examplesGalaxy · SQL · Tabular data

Return distinct keys shared by two TSV streams.

python13.0 KiB3
galaxy_sql_key_row_numberAuthor dacp-examplesGalaxy · SQL · Tabular data

Number rows starting at one inside each key partition.

python13.0 KiB3
galaxy_sql_key_unionAuthor dacp-examplesGalaxy · SQL · Tabular data

Return the distinct keys from either TSV stream.

python13.0 KiB3
galaxy_sql_largest_nAuthor dacp-examplesGalaxy · SQL · Tabular data

Return the rows with the largest values.

python13.1 KiB3
galaxy_sql_last_per_keyAuthor dacp-examplesGalaxy · SQL · Tabular data

Keep the last observed value of each key.

python13.0 KiB3
galaxy_sql_left_joinAuthor dacp-examplesGalaxy · SQL · Tabular data

Keep all source rows and matching reference values.

python13.0 KiB3
galaxy_sql_matched_relative_changeAuthor dacp-examplesGalaxy · SQL · Tabular data

Report relative numeric change against the reference value for matched keys.

python13.1 KiB3
galaxy_sql_matched_value_differenceAuthor dacp-examplesGalaxy · SQL · Tabular data

Subtract the reference value from the source value for each matched key.

python13.1 KiB3
galaxy_sql_missing_valuesAuthor dacp-examplesGalaxy · SQL · Tabular data

List rows that have missing numeric data.

python13.0 KiB3
galaxy_sql_order_key_then_valueAuthor dacp-examplesGalaxy · SQL · Tabular data

Order rows by key and descending numeric value.

python13.0 KiB3
galaxy_sql_pair_dot_productAuthor dacp-examplesGalaxy · SQL · Tabular data

Sum the row-wise products of two numeric columns.

python13.0 KiB3
galaxy_sql_percent_rankAuthor dacp-examplesGalaxy · SQL · Tabular data

Calculate each value’s relative rank from zero to one.

python13.0 KiB3
galaxy_sql_quantile_bucketsAuthor dacp-examplesGalaxy · SQL · Tabular data

Assign rows to approximately equal-sized ordered buckets.

python13.1 KiB3
galaxy_sql_rankAuthor dacp-examplesGalaxy · SQL · Tabular data

Rank values with gaps after ties.

python13.0 KiB5
galaxy_sql_row_ratioAuthor dacp-examplesGalaxy · SQL · Tabular data

Divide two numeric columns row by row.

python13.0 KiB3
galaxy_sql_running_averageAuthor dacp-examplesGalaxy · SQL · Tabular data

Calculate the cumulative average in input order.

python13.0 KiB3
galaxy_sql_running_totalAuthor dacp-examplesGalaxy · SQL · Tabular data

Calculate the cumulative sum in input order.

python13.0 KiB3
galaxy_sql_semi_joinAuthor dacp-examplesGalaxy · SQL · Tabular data

Keep source rows with a matching reference key without duplicating matches.

python13.0 KiB3