PowerBI: Using Python Regex to look for values in column

[MarcusR44]

I'm trying to add a column called ofInterest to select UK postcodes that match RG, OX & SA, the column would contain a 1 if the match is found, or 0 if not found.
My code is:

1 2 3

import pandas as pd import re dataset["ofInterest"] = dataset["RegAddress.PostCode"].re.search("[SRO][AGX][0-9]")

I'm sure I've got this all wrong because I have very little experience of Python (I know REGEX quite well) - can anybody help me?

Yoriz write Oct-14-2022, 10:31 AM:
Please post all code, output and errors (in their entirety) between their respective tags. Refer to BBCode help topic on how to post. Use the "Preview Post" button to make sure the code is presented as you expect before hitting the "Post Reply/Thread" button.

[ibreeden]

re.search("[SRO][AGX][0-9]"

I hope that you are aware also SG, SX, RA, RX, OA and OG will be selected. I think you would rather use:

1	re.search(r"(RG|OX|SA)[0-9]"