Data Science Asked on January 4, 2021
I would like to use the Feature Constructor to extract numbers from a column of strings.
Input Output
S.c 3224 ---> 3224
South ---> 0
322523 ---> 322523
S-1c 4 ---> 14
-1.37 ---> 137
Internal Orange 3.7.0 Documentation says For continuous variables you only have to construct an expression in Python. Great!
I found information about allowed functions in the feature constructor code:
#Only expressions with no list,set,dict,generator comprehensions
#are accepted.
<...>
__ALLOWED = [
"Ellipsis", "False", "None", "True", "abs", "all", "any", "acsii",
"bin", "bool", "bytearray", "bytes", "chr", "complex", "dict",
"divmod", "enumerate", "filter", "float", "format", "frozenset",
"getattr", "hasattr", "hash", "hex", "id", "int", "iter", "len",
"list", "map", "memoryview", "next", "object",
"oct", "ord", "pow", "range", "repr", "reversed", "round",
"set", "slice", "sorted", "str", "tuple", "type",
"zip"
]
Based on the list, I was hoping to use an expression like this:
int(filter(str.isdigit, inputStringColumn) or 0)
…but that is an “Invalid Expression” (no further feedback)
How can I extract a number from a string?
Correct answer by Julio Nobre on January 4, 2021
Get help from others!
Recent Answers
Recent Questions
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP