Re: Separate Address number and name

Path	csiph.com!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!feeder.erje.net!us.feeder.erje.net!news.linkpendium.com!news.linkpendium.com!panix!gordon
From	John Gordon <gordon@panix.com>
Newsgroups	comp.lang.python
Subject	Re: Separate Address number and name
Date	Wed, 22 Jan 2014 02:46:15 +0000 (UTC)
Organization	PANIX Public Access Internet and UNIX, NYC
Lines	42
Message-ID	<lbnbdn$69j$1@reader1.panix.com> (permalink)
References	<9fe1b47b-65ce-4063-9188-07b81cdba49f@googlegroups.com>
NNTP-Posting-Host	panix1.panix.com
X-Trace	reader1.panix.com 1390358775 6451 166.84.1.1 (22 Jan 2014 02:46:15 GMT)
X-Complaints-To	abuse@panix.com
NNTP-Posting-Date	Wed, 22 Jan 2014 02:46:15 +0000 (UTC)
User-Agent	nn/6.7.3
Xref	csiph.com comp.lang.python:64474

Show key headers only | View raw

In <9fe1b47b-65ce-4063-9188-07b81cdba49f@googlegroups.com> Shane Konings <shane.konings@gmail.com> writes:

> I have the following sample from a data set and I am looking to split the address number and name into separate headings as seen below.

> FarmID	Address
> 1	1067 Niagara Stone
> 2	4260 Mountainview
> 3	25 Hunter
> 4	1091 Hutchinson
> 5	5172 Green Lane
> 6	500 Glenridge
> 7	471 Foss
> 8	758 Niagara Stone
> 9	3836 Main
> 10	1025 York


> FarmID	AddressNum    AddressName
> 1	1067          Niagara Stone
> 2	4260          Mountainview
> 3	25            Hunter
> 4	1091          Hutchinson
> 5	5172          Green Lane
> 6	500           Glenridge
> 7	471           Foss
> 8	758           Niagara Stone
> 9	3836          Main
> 10	1025          York

> I have struggled with this for a while and know there must be a simple
> method to achieve this result.

for line in input_lines:
    fields = line.split()
    farm_id = fields[0]
    address_num = fields[1]
    address_name = ' '.join(fields[2:])

-- 
John Gordon         Imagine what it must be like for a real medical doctor to
gordon@panix.com    watch 'House', or a real serial killer to watch 'Dexter'.

Thread

Separate Address number and name Shane Konings <shane.konings@gmail.com> - 2014-01-21 15:49 -0800
  Re: Separate Address number and name Anders Wegge Keller <wegge@wegge.dk> - 2014-01-22 00:55 +0100
    Re: Separate Address number and name Shane Konings <shane.konings@gmail.com> - 2014-01-21 16:01 -0800
  Re: Separate Address number and name Shane Konings <shane.konings@gmail.com> - 2014-01-21 16:06 -0800
    Re: Separate Address number and name Anders Wegge Keller <wegge@wegge.dk> - 2014-01-22 02:04 +0100
    Re: Separate Address number and name Mark Lawrence <breamoreboy@yahoo.co.uk> - 2014-01-22 10:08 +0000
    Re: Separate Address number and name Denis McMahon <denismfmcmahon@gmail.com> - 2014-01-22 17:35 +0000
      Re: Separate Address number and name Denis McMahon <denismfmcmahon@gmail.com> - 2014-01-23 18:11 +0000
  Re: Separate Address number and name Asaf Las <roegltd@gmail.com> - 2014-01-21 16:08 -0800
  Re: Separate Address number and name Ben Finney <ben+python@benfinney.id.au> - 2014-01-22 11:08 +1100
  Re: Separate Address number and name John Gordon <gordon@panix.com> - 2014-01-22 02:46 +0000
    Re: Separate Address number and name Tim Chase <python.list@tim.thechases.com> - 2014-01-21 21:03 -0600
  Re: Separate Address number and name Denis McMahon <denismfmcmahon@gmail.com> - 2014-01-22 15:40 +0000

csiph-web