otp.Operation.str.regex_replace#

regex_replace(pat, repl, *, replace_every=False, caseless=False)#

Search for occurrences (case dependent) of pat and replace with repl.

Parameters

pat (str or Column or Operation) – Pattern to replace specified via the POSIX extended regular expression syntax.
repl (str or Column or Operation) – Replacement string. \0 refers to the entire matched text. \1 to \9 refer to the text matched by the corresponding parenthesized group in pat.
replace_every (bool) – If replace_every flag is set to True, all matches will be replaced, if False only the first one.
caseless (bool) – If the caseless flag is set to True, matching is case-insensitive.

Returns

String with pattern pat replaced by repl.

Return type

Operation

Examples

>>> data = otp.Ticks(X=["A Table", "A Chair", "An Apple"])
>>> data["X"] = data["X"].str.regex_replace("An? ", "The ")
>>> otp.run(data)["X"]
0    The Table
1    The Chair
2    The Apple
Name: X, dtype: object

>>> data = otp.Ticks(X=["A Table A Chair An Apple"])
>>> data["X"] = data["X"].str.regex_replace("An? ", "The ", replace_every=True)
>>> otp.run(data)["X"]
0    The Table The Chair The Apple
Name: X, dtype: object

>>> data = otp.Ticks(X=["11/12/1992", "9/22/1993", "3/30/1991"])
>>> data["X"] = data["X"].str.regex_replace("(\d{1,2})/(\d{1,2})/", r"\2/\1/")
>>> otp.run(data)["X"] 
0    12/11/1992
1     22/9/1993
2     30/3/1991
Name: X, dtype: object