how to get string and it's value with regex

Question


Name        Miss deks KUMARI                    Booking Date           22/05/2020 
             Gender/Age  male  24 Yrs                        Reporting Date         22/05/2020 
             Lab No.     10203693                              Sample Collected At    Lab 
             Ref. By Dr. I.C.U 
                  ;                                                                          UVLO 
             Test Name                                  Value         Unit            Biological Ref Interval 
                                           COMPLETE   BLOOD   COUNT (CBC) 
             TOTAL LEUCOCYTES    COUNT (TLC)            23160         cells/cmm       4000 - 11000 
             DIFFERENTIAL LEUCOCYTES  COUNT (DLC) 
             NEUTROPHILS                                93.4          %               45.0 - 65.0 
             LYMPHOCYTES                                 3.3          %               20.0 - 45.0 
             MONOCYTES                                   3.1          %               4.0 - 10.0 
             EOSINOPHILS                                0.2           %               0.0 - 5.0 
             BASOPHILS                                   0.0          %               0.0-1.0 
             ABSOLUTE   NEUTROPHILS                      21620.0                      3000.0 - 7000.0 
             ABSOLUTE   LYMPHOCYTES                      750.0                        800.0 - 4000.0 
             ABSOLUTE  MONOCYTES                         730.0                        0.0 - 1200.0 
             ABSOLUTE  EOSINOPHILS                       50.0                         0.0 - 500.0 
             ABSOLUTE  BASOPHILS                         10.0                         0.0 - 100.0 
             RBC  COUNT                                  4.31         Millions/cmm    3.80 - 5.80

this is a text file and i want to this kind of output using regex

if i search NEUTROPHILS i want it's value 93.4

if i search BASOPHILS i want it's value 0.0, something like that.

only first two columns needed, i tried to implement once regex ^[^\S ]*(\S+)[^\d ]+(\d+(?:\.\d+)?)[^\d ]*(\d+(?:\.\d+)?)?

but it returns all

someone please help me to get this

here is my list

         `["NEUTROPHILS"                                
         "LYMPHOCYTES"                               
         "MONOCYTES"                                   
         "EOSINOPHILS"                               
         "BASOPHILS"]`

i want to get like this-:

{
 "NEUTROPHILS"  :  93.4                            
 "LYMPHOCYTES"  :  3.3                           
 "MONOCYTES"    :  3.1                             
 "EOSINOPHILS"  :  0.2                         
 "BASOPHILS"    :  0.0 }

user_1231450 · Answer

You could use the following expression:

\b(?P[A-Z][A-Z ]+)\b(?P\d+(?:\.\d+)?)

Then, we need to clean the keys (remove unnecessary whitespaces) and think of a function, that returns the value for a given key. Optional: put it all in a class. That said, the code could be:

import re

class Finder:
    def __init__(self, haystack):
        self.db = self.build_db(haystack)

    def build_db(self, haystack):
        rx = re.compile(r'\b(?P[A-Z][A-Z ]+)\b(?P\d+(?:\.\d+)?)')
        ws = re.compile(r'\s+')

        return {ws.sub(' ', m["key"].strip()): m["value"] for m in rx.finditer(haystack)}

    def find_by_key(self, key):
        try:
            value = self.db[key]
        except KeyError:
            value = None
        return value

    def get_selected(self, lst):
        result = {}
        for key in lst:
            value = self.find_by_key(key)
            if value:
                result[key] = value
        return result

    def get_all(self):
        return self.db

cls = Finder(junk)
dct = cls.get_selected(["NEUTROPHILS", "LYMPHOCYTES", "MONOCYTES", "EOSINOPHILS", "BASOPHILS"])
print(dct)

Which would yield

{'NEUTROPHILS': '93.4', 'LYMPHOCYTES': '3.3', 
 'MONOCYTES': '3.1', 'EOSINOPHILS': '0.2', 'BASOPHILS': '0.0'}

See a demo for the expression on regex101.com.

user_5353128 · Answer

You can try this simple regex for that. Your 1st column would be the 0th capture group and the 2nd column would be the 1st capture group: [A-Z]+\s+[A-Z]*\s+(\d+.\d*)

Explanation of above regex:

It first matches one or more uppercase letters
Then matches one or more spaces
Then again matches zero or mode uppercase letters (to cover space separated keys in your text)
The last part matches decimal digit(s).

Here is the demo on regex101.com

Note: This regex can be easily improved to add more restrictions.

user_12300981 · Answer

I'm sure there are better ways to do this. But this is what I've done in the past:

with open(file.txt) as file: 
  for line in file:
    remove_white_spaces=line.strip()
    search=re.search('^\w+\s+\d+',remove_white_spaces)
    if search != None: 
      extract=(search.string).split()
      print(extract[1])

Granted you can change the search to the actual word if you'd like. I've written this fully out, however with list comprehension you could write this entire thing into 2 lines.

how to get string and it's value with regex

3 Answers