最近在爬完网站数据之后,往excel表格里面插入数据,一直报错:TypeError: can only concatenate tuple (not “str”) to tuple
后来发现插入的数据为元组类型,需要转换为列表,才能直接插入,直接上代码如下:
from urllib import request
import csv
import time
import re
import random
class MaoyanSpider(object):
def init(self):
self.url = ‘https://www.haodf.com/faculty/DE4roiYGYZw0JOrEpjdCy8jrf/menzhen_{}.htm’
self.headers = {
‘User-Agent’: ‘Mozilla/5.0(Windows;U;WindowsNT6.1;en-us)AppleWebKit/534.50(KHTML,likeGecko)Version/5.1Safari/534.50’
}
# 添加计数变量;
self.page = 1
def get_page(self, url):
req = request.Request(
url,
headers=self.headers
)
res = request.urlopen(req)
html = res.read().decode("gbk","ignore")
# print(html)
# 直接调用解析函数:
self.parse_page(html)
def parse_page(self, html):
# names = re.findall('< a href=" " target="_blank">(.*?)</ a>', html)
# pattern = re.compile(r'< a href=".*" target="_blank">(.*?)</ a>', re.S)
names = re.findall(r'<a class="name" target="_blank" href=".*" title=".*">(.*?)</a>\n\s*'
r'<a\n\s*href=".*"\n\s*title=".*" target=".*"> <im'
r'g\n\s*src=".*" width=".*"\n\s*height=".*" ali'
r'gn=".*" id=".*" /></a>\n\s*<p>(.*)</p>', html)
print(names)
self.write_csv(names)
# self.write_csv(film_list)
#正确代码:
def write_csv(self, film_list):
a_tuple=[list(item) for item in film_list ]
print(a_tuple)
with open('get_doctors_zhichen.csv', 'a+' ) as f:
# writer = csv.writer(f)
for i in range(0, len(a_tuple)):
# str=a_tuple[i][0] +'\t'+a_tuple[i][1]
str = a_tuple[i][0] +'\t'+ a_tuple[i][1]
f.writelines(str+'\n' )
f.close()
#错误代码
# def write_csv(self, film_list):
# with open('get_hosptel.csv', 'a+' ) as f:
# # writer = csv.writer(f)
# for i in range(0, len(film_list)):
# f.writelines(film_list[i] + '\n')
# f.close()
def main(self):
for offset in range(1,5):
url=self.url.format(str(offset))
self.get_page(url)
print('第%d页爬取完成 ' % self.page)
self.page+=1
if name==“main”:
spider=MaoyanSpider()
spider.main()