# -*- coding=utf-8 -*-
import requests
from bs4 import BeautifulSoup
from pyExcelerator import *
s = requests.session()
header = {
"User-Agent": "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/65.0.3325.181 Safari/537.36"
}
rs = s.get(url="http://www.xicidaili.com/nn/", headers=header)
soup = BeautifulSoup(rs.text, "lxml")
ip_list_all = []
ip_list = soup.select_one("#ip_list").select("tr")
ip_info_list_key = ["ip", "port", "address", "hidden", "type", "speed", "conn_time", "survival_time", "verify_time"]
for item in ip_list[1:]:
ip_info_list_value = []
ip_info = item.select("td")
for info in ip_info[1:]:
if info.select_one(".bar"):
ip_info_list_value.append(info.select_one(".bar")["title"])
else:
ip_info_list_value.append(info.get_text().strip())
ip_list_all.append(dict(zip(ip_info_list_key, ip_info_list_value)))
print(len(ip_list_all))
# # 写excel文件
# w = Workbook() # 创建一个工作簿
# ws = w.add_sheet(u"西刺免费代理IP") # 创建一个工作表
# ws.write(0, 0, u"序号") # 在1行1列写入
# ws.write(0, 1, u"IP地址")
# ws.write(0, 2, u"端口")
# ws.write(0, 3, u"服务器地址")
# ws.write(0, 4, u"是否匿名")
# ws.write(0, 5, u"类型")
# ws.write(0, 6, u"速度")
# ws.write(0, 7, u"连接时间")
# ws.write(0, 8, u"存活时间")
# ws.write(0, 9, u"验证时间")
# i = 0
# for item in ip_list_all:
# i += 1
# ws.write(i, 0, i) # 在i+1行1列写入
# ws.write(i, 1, item["ip"])
# ws.write(i, 2, item["port"])
# ws.write(i, 3, item["address"])
# ws.write(i, 4, item["hidden"])
# ws.write(i, 5, item["type"])
# ws.write(i, 6, item["speed"])
# ws.write(i, 7, item["conn_time"])
# ws.write(i, 8, item["survival_time"])
# ws.write(i, 9, item["verify_time"])
# w.save(u"西刺免费代理IP.xlsx") # 保存
# print ("写excel完成")
python 西刺代理爬取
最新推荐文章于 2022-10-18 18:07:12 发布