Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #16043

Re: How to: Coordinate DictReader and Reader for CSV

Show all headers | View raw

On 11/21/11 09:16, ray wrote:
> Is there a way to capture the keys outside of the for loop so
> when the for loop is entered, only data is extracted?

I frequently do this for things like tweaking headers (stripping 
space, normalizing case, etc because clients love to send us 
messy data):

   def norm_header(h):
     return h.strip().upper()
   def norm_item(i):
     return i.strip()

   f = file("example.csv", "rb")
   try:
     r = csv.reader(f)
     headers = r.next()
     header_map = dict(
       (norm_header(h), i)
       for i, h in enumerate(headers)
       )
     for row in r:
       item = lambda h: norm_item(row[header_map[norm_header(h)]])
       value1 = item("Item1")
       value2 = item("ITEM3")
       ...
   finally:
     f.close()

Should work in 2.x, possibly in 3.x (though you might need to 
change from "headers = r.next()" to "headers = next(r)")

-tkc

Back to comp.lang.python | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

How to:  Coordinate DictReader and Reader for CSV ray <ray@aarden.us> - 2011-11-21 05:18 -0800
  Re: How to:  Coordinate DictReader and Reader for CSV Neil Cerutti <neilc@norwich.edu> - 2011-11-21 13:59 +0000
    Re: How to: Coordinate DictReader and Reader for CSV ray <ray@aarden.us> - 2011-11-21 07:16 -0800
      Re: How to: Coordinate DictReader and Reader for CSV Neil Cerutti <neilc@norwich.edu> - 2011-11-21 15:41 +0000
        Re: How to: Coordinate DictReader and Reader for CSV Neil Cerutti <neilc@norwich.edu> - 2011-11-21 15:43 +0000
      Re: How to: Coordinate DictReader and Reader for CSV Tim Chase <python.list@tim.thechases.com> - 2011-11-21 12:36 -0600

csiph-web