简单遍历爬取信息并储存在excel中

coding=utf-8

import bs4
from openpyxl import workbook # 写入Excel表所用
import requests
import xlsxwriter

headers={
“User-Agent”:“Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko)
Chrome/58.0.3029.110 Safari/537.36 SE 2.X MetaSr 1.0”
}
website=[‘黑盒’,‘白盒’]
for i in range(len(website)):
url = “https://www.baidu.com/s?wd=”
url=url+website[i]
print(url)
content=requests.get(url, headers=headers)
print(content.status_code)
result = content.text
print(result)

‘’’
response=requests.get(url, headers=headers)
print(response.status_code)
result=response.text
bs = bs4.BeautifulSoup(result, features=‘html.parser’)

Name=[]
nameList = bs.find_all(“tr”, bgcolor="#EFF7F0")
for i in nameList:
Name.append(