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://tenapi.cn/v2/baiduhot"
#api即将作废，请寻找其他api或使用另外一个项目

res = requests.get(url, headers=browse_header).json()
# 实时上升热点
content_list = res['data']
title_list = []
score_list = []
desc_list = []
index = 0
for content in content_list:
    index += 1
    title_list.append(content['name'])
    score_list.append(content['hot'])
    desc_list.append(content['url'])

df = pd.DataFrame({
    '热搜标题': title_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)  # 保存结果数据