回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>使用来自数据管理,例如:“夏威夷退伍军人和受益人的墓地位置,截至2011年1月”<a href="http://www.data.gov/raw/4608" rel="nofollow">http://www.data.gov/raw/4608</a>我试图用python解析CSV并处理每一行:</p>
<pre><code>randomData = csv.DictReader(open('/downloads/ngl_hawaii.csv', 'rb'), delimiter=",")
for row in randomData:
print row
</code></pre>
<p>CSV数据示例:</p>
<blockquote>
<p>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</p>
<p>Joe,"E","JoJo","","10/02/1920","03/12/2000","100-E","","3","HAWAII
STATE VETERANS CEMETERY","KAMEHAMEHA
HIGHWAY","","KANEOHE","HI","111444","","SXXXXX","Veteran
(Self)","Joe","E","JoJo","","US
ARMY","SGT","WORLD WAR II"</p>
</blockquote>
<p>结果不是很漂亮(打印一行):</p>
<blockquote>
<p>{'v_last_name': None, 'cem_addr_two':
None, 'rank': None, 'd_suffix': None,
'city': None, 'row_num': None, 'zip':
None, 'cem_phone': None,
'd_last_name': None, e,
'd_first_name':
'Joe,"E","JoJo","","10/02/1920","03/12/2000","100-E","","3","HAWAII
STATE VETERANS CEMETERY","KAMEHAMEHA
HIGHWAY","","KANEOHE","HI","11144
"SXXXXX","","US ARMY","SGT","WORLD WAR
II"', 'war': None, 'v_mid_name': None,
'cem_url': None, 'cem_name': None,
'relationship': None, 'v_first_name':
None, 'se one, 'cem_addr_one': None,
'd_birth_date': None, 'd_death_date':
None}</p>
</blockquote>
<p>如您所见,标题字段(csv中的第一行)没有正确地关联到每个后续行。在</p>
<p>我是做错了什么,还是CSV质量差?在</p>
<p><strong>感谢凯西问我是否在其他程序中打开了文件。Excel弄乱了文件….</strong></p>