python获取百度热搜榜内容

最新推荐文章于 2024-05-30 19:44:18 发布

成瘾的男孩

最新推荐文章于 2024-05-30 19:44:18 发布

阅读量690

点赞数 8

文章标签： python 开发语言

本文链接：https://blog.csdn.net/qq_53630441/article/details/135824607

版权

适合小白

import requests
from bs4 import BeautifulSoup
import openpyxl

url="https://top.baidu.com/board?tab=realtime"
headers={
    "User-Agent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36 Edg/120.0.0.0"
}
response=requests.get(url=url,headers=headers)# 模拟浏览器访问
html=response.content
print(response.status_code)# 输出访问状态
soup=BeautifulSoup(response.text,"html.parser")
data01=[]
for items in soup.find_all('div',{'class':'hot-desc_1m_jR'}): #热搜内容
    data01.append(items.text)

workd=openpyxl.Workbook()
sheet=workd.active
sheet.title="热搜内容"

for j in range(len(data01)):
    sheet.cell(row=j+2,column=1,value=data01[j])
workd.save("热搜内容.xlsx")