Python,
pasted
on May 3:
|
import StringIO
import csv
from pprint import pprint
csv_string = """d_first_name,d_mid_name,d_last_name,d_suffix,d_birth_date,d_death_date,section_id,row_num,site_num,cem_name,cem_addr_one,cem_addr_two,city,state,zip,cem_url,cem_phone,relationship,v_first_name,v_mid_name,v_last_name,v_suffix,branch,rank,war
"Emil","E","Seibel","","10/02/1920","03/12/2010","139-E","","3","HAWAII STATE VETERANS CEMETERY","KAMEHAMEHA HIGHWAY","","KANEOHE","HI","96744","","808-233-3630","Veteran (Self)","Emil","E","Seibel","","US ARMY","SGT","WORLD WAR II","""
csv_file = StringIO.StringIO(csv_string)
for line in csv.DictReader(csv_file, delimiter=","):
pprint(line)
|
Output:
|
{None: [''],
'branch': 'US ARMY',
'cem_addr_one': 'KAMEHAMEHA HIGHWAY',
'cem_addr_two': '',
'cem_name': 'HAWAII STATE VETERANS CEMETERY',
'cem_phone': '808-233-3630',
'cem_url': '',
'city': 'KANEOHE',
'd_birth_date': '10/02/1920',
'd_death_date': '03/12/2010',
'd_first_name': 'Emil',
'd_last_name': 'Seibel',
'd_mid_name': 'E',
'd_suffix': '',
'rank': 'SGT',
'relationship': 'Veteran (Self)',
'row_num': '',
'section_id': '139-E',
'site_num': '3',
'state': 'HI',
'v_first_name': 'Emil',
'v_last_name': 'Seibel',
'v_mid_name': 'E',
'v_suffix': '',
'war': 'WORLD WAR II',
'zip': '96744'}
|
|