爬取电影票房数据并进行数据分析

带我去滑雪

已于 2024-03-14 11:16:08 修改

阅读量690

点赞数 7

分类专栏：数据分析文章标签：信息可视化电影票房数据爬虫

于 2024-01-02 20:05:36 首次发布

本文链接：https://blog.csdn.net/qq_45856698/article/details/135341784

版权

数据分析专栏收录该内容

6 篇文章 4 订阅

订阅专栏

大家好，我是带我去滑雪！

分析电影票房数据具有多个优点：首先通过分析票房数据，可以深入了解观众的喜好和趋势。了解哪些类型的电影在特定时期或地区更受欢迎，有助于电影制片人更好地满足观众的需求，制定更有针对性的电影制作计划。其次，通过分析票房数据，制片公司可以更好地了解哪些市场渠道和宣传手段对提高电影知名度和票房收入最为有效。这有助于精确制定市场营销策略，最大化投资回报。下面开始实战，爬取影院名称，当周票房、单荧幕票房、场均人次、单日单厅票房、单日单厅场次6个变量并进行数据分析。

（1）爬取代码

import urllib
import requests
from fake_useragent import UserAgent
import json
import pandas as pd
import time
import datetime

comment_api = 'http://www.cbooo.cn/BoxOffice/getCBW?pIndex={}&dt={}'

headers = { "User-Agent": UserAgent(verify_ssl=False).random}
col = ['cinemaName','amount','avgPS','avgScreen','scenes_time','screen_yield']

dataall = pd.DataFrame()

num = 1035
for i in range(1,num+1):
   

   response_comment = requests.get(comment_api.format(i,1041),headers = headers)
   json_comment = response_comment.text
   json_comment = json.loads(json_comment)        
   
   n = len(json_comment['data1'])
   datas = pd.DataFrame(index = range(n),columns = col)
   for j in range(n):        
       datas.loc[j,'cinemaName'] = json_comment['data1'][j]['cinemaName']
       datas.loc[j,'amount'] = json_comment['data1'][j]['amount']
       datas.loc[j,'avgPS'] = json_comment['data1'][j]['avgPS']
       datas.loc[j,'avgScreen'] = json_comment['data1'][j]['avgScreen']
       datas.loc[j,'scenes_time'] = json_comment['data1'][j]['scenes_time']
       datas.loc[j,'screen_yield'] = json_comment['data1'][j]['screen_yield']

   dataall = pd.concat([dataall,datas],axis = 0)
   print('完成进度 {}% !'.format(round(i/num*100,2)))
   time.sleep(0.5)
   
dataall = dataall.reset_index()

爬取结果展示：

（2）数据分析

import os 
import pandas as pd
import numpy as np
import jieba
import jieba.analyse
import jieba.posseg
import cpca
import matplotlib.pyplot as plt
from pyecharts.charts import Map
from pyecharts.charts import Geo
from pyecharts.charts import Bar
from pyecharts.charts import Boxplot

import seaborn as sns
data1 = pd.read_excel('data1.xlsx')
data2 = pd.read_excel('data2.xlsx')
data1 = data1.drop_duplicates()
data2 = data2.drop_duplicates()

datas = pd.merge(data1,data2,left_on ='cinemaName',right_on = 'cinemaName').dropna()
datas = datas.reset_index(drop = True)

dataall = datas[['cinemaName']]

dataall['amount'] = datas['amount_x'] + datas['amount_y']
dataall['avgPS'] = (datas['avgPS_x'] + datas['avgPS_y'])/2
dataall['avgScreen'] = datas['avgScreen_x'] + datas['avgScreen_y']
dataall['screen_yield'] = (datas['screen_yield_x'] + datas['screen_yield_y'])/2
dataall['scenes_time'] = (datas['scenes_time_x'] + datas['scenes_time_y'])/2
dataall['avgprice'] = dataall.screen_yield/dataall.scenes_time/dataall.avgPS
dataall = dataall.dropna().reset_index(drop = True)
plt.rcParams['font.sans-serif']=['SimHei']
plt.rcParams['axes.unicode_minus']=False

dataall['票房'] = np.log10(dataall.amount)
plt.figure(figsize = (10,5))
plt.scatter(dataall.avgprice,dataall.avgPS,c = dataall.票房,cmap ='YlGnBu' ,s = 10)

plt.xlabel('平均票价')
plt.ylabel('场均人次')
plt.colorbar(label = '票房')
plt.show()


sns.pairplot(dataall,diag_kind = 'kde')   
plt.how()

结果展示：