38 lines
1006 B
Python
38 lines
1006 B
Python
import requests
|
|
import pandas as pd
|
|
import datetime
|
|
|
|
|
|
browse_header = {
|
|
'user-agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36'
|
|
}
|
|
|
|
url = "https://weibo.com/ajax/side/hotSearch"
|
|
|
|
res = requests.get(url, headers=browse_header).json()
|
|
# 实时上升热点
|
|
content_list = res['data']['realtime']
|
|
title_list = []
|
|
order_list = []
|
|
score_list = []
|
|
desc_list = []
|
|
index = 0
|
|
for content in content_list:
|
|
index += 1
|
|
order_list.append(content['rank'])
|
|
title_list.append(content['word'])
|
|
score_list.append(content['num'])
|
|
desc_list.append(content['note'])
|
|
|
|
df = pd.DataFrame({
|
|
'热搜标题': title_list,
|
|
'热搜排名': order_list,
|
|
'热搜热度': score_list,
|
|
'描述': desc_list,
|
|
})
|
|
print(datetime.datetime.now())
|
|
current_datetime = datetime.datetime.now()
|
|
xdate=current_datetime.strftime("%Y-%m-%d-%H-%M-%S")
|
|
df.to_excel(f'./数据汇总/{xdate}微博热搜榜.xlsx', index=False) # 保存结果数据
|
|
|