我的以下代碼有問題。import urllib2import csvfrom bs4 import BeautifulSoupsoup = BeautifulSoup(urllib2.urlopen('http://www.ny.com/clubs/nightclubs/index.html').read())clubs = []trains = ["A","C","E","1","2","3","4","5","6","7","N","Q","R","L","B","D","F"]for club in soup.find_all("dt"): clubD = {} clubD["name"] = club.b.get_text() clubD["address"] = club.i.get_text() text = club.dd.get_text() nIndex = text.find("(") if(text[nIndex+1]=="2"): clubD["number"] = text[nIndex:nIndex+15] sIndex = text.find("Subway") sIndexEnd = text.find(".",sIndex) if(text[sIndexEnd-1] == "W" or text[sIndexEnd -1] == "E"): sIndexEnd2 = text.find(".",sIndexEnd+1) clubD["Subway"] = text[sIndex:sIndexEnd2] else: clubD["Subway"] = text[sIndex:sIndexEnd] try: cool = clubD["number"] except (ValueError,KeyError): clubD["number"] = "N/A" clubs.append(clubD)keys = [u"name", u"address",u"number",u"Subway"]f = open('club.csv', 'wb')dict_writer = csv.DictWriter(f, keys)dict_writer.writerow([unicode(s).encode("utf-8") for s in clubs])我收到錯(cuò)誤ValueError：dict包含不在字段名稱中的字段。我不明白這怎么可能。任何幫助將是巨大的。我正在嘗試將字典轉(zhuǎn)換為Excel文件。
1 回答
小唯快跑啊
TA貢獻(xiàn)1863條經(jīng)驗(yàn) 獲得超2個(gè)贊
clubs是詞典列表，而每個(gè)詞典都有四個(gè)字段：名稱，地址，編號(hào)和Subway。您將需要對(duì)每個(gè)字段進(jìn)行編碼：
# Instead of:
#dict_writer.writerow([unicode(s).encode("utf-8") for s in clubs])
# Do this:
for c in clubs:
# Encode each field: name, address, ...
for k in c.keys():
c[k] = c[k].encode('utf-8').strip()
# Write to file
dict_writer.writerow(c)
更新
我查看了您的數(shù)據(jù)，其中一些字段以結(jié)尾換行\(zhòng)n，因此我更新了代碼以同時(shí)編碼和去除空格。
添加回答
舉報(bào)
0/150
提交
取消