CSDN的各位大佬們,Python小白有問題想要咨詢,如下代碼,請問哪里有問題,應該怎么改,才能正確決議彈幕網站,你們的解答將會給我莫大幫助!
from bs4 import BeautifulSoup
import re
import requests
import xlsxwriter
def getcomments():
headers={"User-Agent":"Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.26 Safari/537.36 Core/1.63.5558.400 QQBrowser/10.1.1695.400"}
url="https://cmts.iqiyi.com/bullet/30/00/7564083000_300_1.z?rn=0.21263356332144867&business=danmu&is_iqiyi=true&is_video_page=true&tvid=7564083000&albumid=233592301&categoryid=2&qypid=01010021010000000000"
html=requests.get(url,headers=headers)
bullets_data=https://bbs.csdn.net/topics/html.content
bullets=decompress(bullets_data)
danmu=bullets.decode("utf-8","ignore")
soup=BeautifulSoup(danmu,"lxml")
workbook=xlsxwriter.Workbook(file_excel)
sheet=workbook.add_worksheet('彈幕檔案')
bold=workbook.add_format({'bold':True})
sheet.write('A1',u'正文',bold)
sheet.write('I1',u'時間',bold)
sheet.write('L1',u'集數',bold)
bulletInfo=soup.select('bulletInfo')
row=2
for x in bulletInfo:
content=x.content.text
name="世界欠我一個初戀"
times=x.showtime.text
time=str(int(eval(times)/60))+"分"+str(eval(times)-int(eval(times)/60)*60)+"秒"#分進制 eval函式轉化資料格式變為可計算
sheet.write('A%d'%row,content)
sheet.write('I%d'%row,time)
sheet.write('L%d'%row,name)
row+=1
workbook.close()
if __name__== '__main__':
file_excel="E:\Study\hiphop-1.xlsx"
getcomments()
print("我結束了")
期待各位大佬的解答,再次表示感謝!
uj5u.com熱心網友回復:
沒有大佬幫我解答一下嗎?好像缺個decompress函式,誰會寫呢uj5u.com熱心網友回復:
來交流一波。。轉載請註明出處,本文鏈接:https://www.uj5u.com/qita/124988.html
