这是我的代码,基本上我想输出变量“final”到excel,我想它被打印在一列。我当前编写的代码只能将结果写入excel中的一行
import requests
from bs4 import BeautifulSoup
import urllib
import re
import sys
reload(sys)
sys.setdefaultencoding('utf-8')
import csv
r = requests.get("https://www.autocodes.com/obd-code-list/")
soup = BeautifulSoup(r.content)
g_data = soup.find_all("div", {"id":"scroller"})
for item in g_data:
regex = '.html">(.+?)</a>'
pattern = re.compile(regex)
htmlfile = urllib.urlopen("https://www.autocodes.com/obd-code-list/")
htmltext = htmlfile.read()
final = re.findall(pattern,htmltext)
with open('index4.csv','w') as csv_file:
writer = csv.writer(csv_file)
writer.writerow(['company'])#row?
writer.writerows([final])
有什么可能的解决办法吗?谢谢,我刚接触Python,学习Python的时候几乎没有编程知识
目前没有回答
相关问题 更多 >
编程相关推荐