Forum Discussion

MarcusR1's avatar
MarcusR1
Icon for Helper II rankHelper II
3 years ago

Using Python Regex to look for values in column

I'm trying to add a column called ofInterest select 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:   import pandas as pd impo...
Need Help
MarcusR1's avatar
MarcusR1
Icon for Helper II rankHelper II
3 years ago

Hi Neeko, unfortunately your solution doesn't work as REGEX becasue I need to look for any of the letters follwoed by a number (regexz /[SRO][AGX][0-9]/) but your suggestion doesn't do that.
all the best, Marcus

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi MarcusR1 ,

 

I'm sorry I can't understand your needs, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

 

Best Regards,

Neeko Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.