Operator catalog

More tags45

All operators

Showing 81–98 of 98
OperatorVersionsExecutorTrustDownloadsActions
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
galaxy_sql_singleton_keysAuthor dacp-examplesGalaxy · SQL · Tabular data

Return rows whose key appears exactly once.

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

Return the rows with the smallest values.

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

Retain one row per distinct key and value pair.

python13.0 KiB2
galaxy_sql_weighted_averageAuthor dacp-examplesGalaxy · SQL · Tabular data

Calculate a weighted mean using the second numeric column.

python13.0 KiB2