Operator catalog
| Operator | Versions | Executor | Trust | Downloads | Actions |
|---|---|---|---|---|---|
galaxy_sql_last_per_keyGalaxy · SQL · Tabular data Keep the last observed value of each key. | python13.0 KiB | 3 | |||
galaxy_sql_left_joinGalaxy · SQL · Tabular data Keep all source rows and matching reference values. | python13.0 KiB | 3 | |||
galaxy_sql_matched_relative_changeGalaxy · SQL · Tabular data Report relative numeric change against the reference value for matched keys. | python13.1 KiB | 3 | |||
galaxy_sql_matched_value_differenceGalaxy · SQL · Tabular data Subtract the reference value from the source value for each matched key. | python13.1 KiB | 3 | |||
galaxy_sql_missing_valuesGalaxy · SQL · Tabular data List rows that have missing numeric data. | python13.0 KiB | 3 | |||
galaxy_sql_order_key_then_valueGalaxy · SQL · Tabular data Order rows by key and descending numeric value. | python13.0 KiB | 3 | |||
galaxy_sql_pair_dot_productGalaxy · SQL · Tabular data Sum the row-wise products of two numeric columns. | python13.0 KiB | 3 | |||
galaxy_sql_percent_rankGalaxy · SQL · Tabular data Calculate each value’s relative rank from zero to one. | python13.0 KiB | 3 | |||
galaxy_sql_quantile_bucketsGalaxy · SQL · Tabular data Assign rows to approximately equal-sized ordered buckets. | python13.1 KiB | 3 | |||
galaxy_sql_rankGalaxy · SQL · Tabular data Rank values with gaps after ties. | python13.0 KiB | 5 | |||
galaxy_sql_row_ratioGalaxy · SQL · Tabular data Divide two numeric columns row by row. | python13.0 KiB | 3 | |||
galaxy_sql_running_averageGalaxy · SQL · Tabular data Calculate the cumulative average in input order. | python13.0 KiB | 3 | |||
galaxy_sql_running_totalGalaxy · SQL · Tabular data Calculate the cumulative sum in input order. | python13.0 KiB | 3 | |||
galaxy_sql_semi_joinGalaxy · SQL · Tabular data Keep source rows with a matching reference key without duplicating matches. | python13.0 KiB | 3 | |||
galaxy_sql_singleton_keysGalaxy · SQL · Tabular data Return rows whose key appears exactly once. | python13.0 KiB | 3 | |||
galaxy_sql_smallest_nGalaxy · SQL · Tabular data Return the rows with the smallest values. | python13.1 KiB | 3 | |||
galaxy_sql_unique_pairsGalaxy · SQL · Tabular data Retain one row per distinct key and value pair. | python13.0 KiB | 2 | |||
galaxy_sql_weighted_averageGalaxy · SQL · Tabular data Calculate a weighted mean using the second numeric column. | python13.0 KiB | 2 |