[問題]scrapy pipelines 無法寫入CSV檔
繼上次發問pipelines的問題後,已經自行解決keyerror的問題,
這次是無法寫入CSV檔,明明執行的時候都沒出現錯誤訊息,但就是寫不進去
CSV檔,附上程式碼
pipelines.py
import csv
from myproject.items import BirdTitle,BirdName,BirdCount
class myPipeline(object):
def __init__(self):
self.myCSV = csv.writer(open('birds.csv','wb'))
self.myCSV.writerow(['title','birdname','count'])
def process_item(self, item,spider):
titles=[]
names=[]
counts=[]
for title in item:
if isinstance(item, BirdTitle):
for title in item['title']:
titles.append(title)
return titles
for name in item:
if isinstance(item, BirdName):
for name in item['birdName']:
names.append(name)
return names
for count in item:
if isinstance(item,BirdCount):
for count in item['count']:
counts.append(count)
return counts
for a, b,c in zip(titles,names,counts):
self.myCSV.writerow([a, b,c])
return item
請問我該如何解決?
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 210.70.151.159
※ 文章網址: http://www.ptt.cc/bbs/Python/M.1420621249.A.CE1.html
→
01/07 17:33, , 1F
01/07 17:33, 1F
→
01/07 17:33, , 2F
01/07 17:33, 2F
→
01/07 20:56, , 3F
01/07 20:56, 3F
→
01/07 20:57, , 4F
01/07 20:57, 4F
→
01/07 21:00, , 5F
01/07 21:00, 5F
→
01/07 21:03, , 6F
01/07 21:03, 6F
→
01/07 23:30, , 7F
01/07 23:30, 7F
推
01/07 23:59, , 8F
01/07 23:59, 8F
→
01/08 09:57, , 9F
01/08 09:57, 9F
→
01/08 09:59, , 10F
01/08 09:59, 10F