Forum Discussion

MarcusR1's avatar
MarcusR1
Helper 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
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi MarcusR1 ,

 

Has your problem been solved?If the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

 

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. 

  • MarcusR1's avatar
    MarcusR1
    Helper 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.