爬取虎牙直播中王者荣耀板块主播实时人气数据

import requests
import json

from openpyxl import Workbook

wb = Workbook()
ws = wb.active
ws.append(['房间名', '主播名', '人气'])
headers = {
    "User-Agent": "Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36"
}
params = {
    "m": "LiveList",
    "do": "getLiveListByPage",
    "gameId": "2336",
    "tagAll": "0",
}
for page in range(1, 29):
    params['page'] = page
    url = 'https://www.huya.com/cache.php'
    response = requests.get(url=url, headers=headers, params=params)
    ret1 = response.text
    ret2 = json.loads(ret1)
    ret_data = ret2['data']['datas']
    # print(ret_data)
    for room in ret_data:
        introduction = room['introduction']
        nick = room['nick']
        totalCount = room['totalCount']
        num = float(totalCount) / 10000
        nums = round(num,2)
        print("房间:{0}\t主播名:{1}\t人气:{2:.1f}万".format(introduction, nick, float(totalCount) / 10000))
        ws.append([introduction, nick, str(nums)+ '万'])
wb.save('王者荣耀.xlsx')