import requests import xlwt import json columns=['影片名稱', '影片類型', '總票房（萬）', '平均票價', '場均人次', '國家及地區','上映日期'] workbook = xlwt.Workbook(encoding="utf-8") worksheet = workbook.add_sheet('My Worksheet') for k in range(len(columns)):worksheet.write(0,k,columns[k])workbook.save('movie.xls') url='https://www.endata.com.cn/API/GetData.ashx' Form_Data={ 'Area': "", 'AvgPeoPle':'', 'AvgPrice': '', 'BoxOffice': '', 'Genre_Main': "", 'MovieName': "", 'ReleaseTime': ""} i = 1 a=[2016,2017,2018,2019,2020]for j in a:k={'year': j,'MethodName': 'BoxOffice_GetYearInfoData'}header={'Host':'www.endata.com.cn','Origin':'https://www.endata.com.cn','User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64)''AppleWebKit/537.36 (KHTML, like Gecko)'' Chrome/85.0.4183.83' 'Safari/537.36'}response=requests.post(url=url,headers=header,params=Form_Data,data=k)print(response.text)red = []c=json.loads(response.text)lst1=c['Data']lst=lst1['Table']for item in lst:for j in range(7):if j==0:worksheet.write(i, j,item["MovieName"])workbook.save('movie1.xls')if j==1:worksheet.write(i, j,item["Genre_Main"])workbook.save('movie1.xls')if j==2:worksheet.write(i, j,item["BoxOffice"])workbook.save('movie1.xls')if j==3:worksheet.write(i, j,item["AvgPrice"])workbook.save('movie1.xls')if j==4:worksheet.write(i, j,item["AvgPeoPle"])workbook.save('movie1.xls')if j==5:worksheet.write(i, j,item["Area"])workbook.save('movie1.xls')if j==6:worksheet.write(i, j,item["ReleaseTime"])workbook.save('movie1.xls')i=i+1

總結

以上是生活随笔為你收集整理的获取中国票房网的五年间年度票房的数据信息（初学者完整代码）的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。