Remove Words
Remove all the elements that occur in one list from another.
Parameters
| Name | Description | Accepted Values | Default | Required |
|---|---|---|---|---|
| I/O | ||||
input | Name of column to remove words from. | string, integer, array | — | Yes |
to_remove | Column or list of columns with a list of words to be removed. | string | — | Yes |
output | Name of the output columns. | string, array, null | null | No |
| Options | ||||
tokenize_to_remove | Tokenize all to_remove inputs. | boolean | false | No |
ignore_case | Ignore input and to_remove case. | boolean | true | No |
| Conditions | ||||
if | Condition that determines whether the wrangle runs as a whole. Recipe variables may be referenced with ${variable}. | string | — | No |
where | Filter rows before applying the wrangle using SQL-like criteria, such as column1 = 123 OR column2 = 'abc'. | string | — | No |
where_params | Values used with where for parameterized criteria. Uses SQLite placeholder syntax such as ? or :name. | array, object | — | No |
Examples
wrangles:
- remove_words:
input: Description
to_remove: # To Remove columns must be list
- Materials
- Colours
output: Product
tokenize_to_remove: True
ignore_case: False
| Colours | Materials | Description |
|---|---|---|
| ['Blue'] | ['Steel'] | Steel Blue Bottle |
| ['Blue'] | ['Steel'] | ['Steel', 'Blue', 'Bottle'] |
| Product |
|---|
| Bottle |
| Bottle |
Access
| Requirement | Value |
|---|---|
| AI-powered | No |
| Requires WrangleWorks account | No |
| Requires subscription | No |
| Requires external API key | No |
Technical details
| Field | Value |
|---|---|
| Catalog ID | 88 |
| Catalog key | remove_words |
| Recipe key | remove_words |
| Catalog status | active |
| Lifecycle status | active |
| Recipe Writer eligible | Yes |
| Namespace | Root-level |
| Documentation group | format |
| Aliases | None |
| Runtime symbol | wrangles.recipe_wrangles.main.remove_words |
| Legacy UUID | 543b96c3-f354-48be-8046-bf0cb9fbaf56 |
Sources