import requestsimport jsonfrom openpyxl import Workbookwb = Workbook()ws = wb.activews.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'] = pageurl = '/cache.php'response = requests.get(url=url, headers=headers, params=params)ret1 = response.textret2 = 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) / 10000nums = 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')
