Path: csiph.com!news.swapon.de!fu-berlin.de!uni-berlin.de!not-for-mail
From: Tim Chase <python.list@tim.thechases.com>
Newsgroups: comp.lang.python
Subject: Re: Simplest way to locate a string in a column and get the value on the same row in another column
Date: Thu, 28 Apr 2016 14:06:51 -0500
Lines: 57
Message-ID: <mailman.210.1461870637.32212.python-list@python.org>
References: <759417988.6710506.1461868599459.JavaMail.yahoo.ref@mail.yahoo.com> <759417988.6710506.1461868599459.JavaMail.yahoo@mail.yahoo.com> <1650815019.6612341.1461868675273.JavaMail.yahoo@mail.yahoo.com> <20160428140651.36ce5e63@bigbox.christie.dr>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
In-Reply-To: <1650815019.6612341.1461868675273.JavaMail.yahoo@mail.yahoo.com>
Precedence: list
Xref: csiph.com comp.lang.python:107825

On 2016-04-28 18:37, David Shi via Python-list wrote:
>  What is the simplest way to locate a string in a column and get
> the value on the same row in another column ? 1 =C2=A0a2 =C2=A0b3 =C2=A0c
> Locate b and obtain 2 in a table.
> Looking forward to hearing from you.

I've had success with using regexp matches with their start/stop
location information:

  s1 =3D "1  a2    b3  c"
  s2 =3D "abcdefghijklmn"

  import re
  r =3D re.compile(r"a2\s*") # define the pattern you want
  m =3D r.search(s1)
  if m: # if our pattern was in the header
    # take the corresponding slice out of s2
    result =3D s2[m.start():m.end()] # 'defghi'

This also works nicely with re.finditer() as I've had
column-delimited files where each header had no spaces

  EMPID    FIRST_NAME     LAST_NAME
  123456   John           Smith
  234567   Ellen          Miller

so I did something like

  r =3D re.compile(r"(\S+)\s*")
  with open("data.txt") as f:
    headers =3D next(f)
    header_map =3D dict(
      (m.group(1), slice(m.start(), m.end()))
      for m in r.finditer(headers)
      )
    for row in f:
      empid =3D row[header_map["EMPID"]].rstrip()
      fname =3D row[header_map["FIRST_NAME"]].rstrip()
      lname =3D row[header_map["LAST_NAME"]].rstrip()
      process(empid, fname, lname)
      # or
      # data =3D dict(
      #   (field, row[slc])
      #   for field, slc in row.items()
      #   )
      # process(data)


Hope this gives you some helpful techniques.

-tkc