https://y.qq.com/n/yqq/mv/v/k0034mj6ty2.html

                #
                 导入包
                import
                 pandas as pd 

                import
                 time  

                import
                 requests

                import
                 json

                from faker import Factory 

def get_qq_comment(page_num):
    """
    功能：传入页面数，获取QQ音乐评论数据。
    """# 存储数据
    df_all = pd.DataFrame()

    for i in range(page_num):
        # 打印进度print(‘我正在获取第{}页的信息‘.format(i))

        # 获取URL
        url = ‘https://c.y.qq.com/base/fcgi-bin/fcg_global_comment_h5.fcg?g_tk_new_20200303=1516279237&g_tk=470981629&loginUin=2315561922&hostUin=0&format=json&inCharset=utf8&outCharset=GB2312&notice=0&platform=yqq.json&needNewCode=0&cid=205360772&reqtype=2&biztype=5&topid=k0034mj6ty2&cmd=8&needmusiccrit=0&pagenum={}&pagesize=25&domain=qq.com&ct=24&cv=10101010‘.format(i)

        # 添加headers
        headers = {
            ‘user-agent‘: Factory.create().user_agent()
        }

        # 发起请求
        r = requests.get(url, headers=headers) 

        # 解析网页
        json_data = json.loads(r.text)

        # 获取数据
        comment_list = json_data[‘comment‘][‘commentlist‘]
        # 昵称
        nick_name = [i.get(‘nick‘) for i in comment_list]
        # 评论内容
        content =  [i.get(‘rootcommentcontent‘) for i in comment_list]
        # 评论时间
        comment_time = [i.get(‘time‘) for i in comment_list]

        # 存储数据
        df = pd.DataFrame({
            ‘nick_name‘: nick_name,
            ‘content‘: content,
            ‘comment_time‘: comment_time
        })

        # 追加数据
        df_all = df_all.append(df, ignore_index=True)

        # 休眠一秒
        time.sleep(1) 

    return df_all

if__name__ == ‘__main__‘:
    # 运行函数
    df = get_qq_comment(page_num=286)

df.head()

                #
                 导入所需包
                import
                 numpy as np

                import
                 re

                import
                 jieba


                #
                 读入数据
df = pd.read_excel(‘../data/五月天QQ评论数据6.05.xlsx‘)

# 删除重复值
df = df.drop_duplicates()

# 转换函数def transform_time(time_second):
    time_array = time.localtime(time_second)
    otherStyleTime = time.strftime(‘%Y-%m-%d %H:%M:%S‘, time_array) 
    return otherStyleTime

# 时间数据处理
df[‘comment_time‘] = df[‘comment_time‘].apply(lambda x: transform_time(x))

# content初步处理
pattern = re.compile(‘\[em\](.*?)\[/em\]‘)
df[‘content‘] = df.content.str.replace(pattern, ‘‘)
df.head() 

                #
                 导入库
                from pyecharts.charts import Pie, Bar, Map, Line, WordCloud, Page
from pyecharts import options as opts
from pyecharts.globals import SymbolType
import stylecloud

                #
                 日期数量
df[‘comment_time‘] = pd.to_datetime(df[‘comment_time‘])

day_num = df.comment_time.astype(‘str‘).str.split(‘:‘).str[0].value_counts().sort_index()

# 产生数据
x1_line1 = [i.split(‘2020-‘)[1] for i in day_num.index.values.tolist()]
y1_line1 = day_num.values.tolist()

# 绘制面积图
line1 = Line(init_opts=opts.InitOpts(width=‘1350px‘, height=‘750px‘))
line1.add_xaxis(x1_line1)
line1.add_yaxis(‘‘, y1_line1,
                markpoint_opts=opts.MarkPointOpts(data=[
                    opts.MarkPointItem(type_=‘max‘, name=‘最大值‘),
                    opts.MarkPointItem(type_=‘min‘, name=‘最小值‘)
                ])) 
line1.set_global_opts(title_opts=opts.TitleOpts(‘五月天QQ音乐评论日期走势图‘), 
                      xaxis_opts=opts.AxisOpts(axislabel_opts=opts.LabelOpts(rotate=‘90‘)),
                      visualmap_opts=opts.VisualMapOpts(max_=2000)
                     ) 
line1.set_series_opts(label_opts=opts.LabelOpts(is_show=False), 
                      linestyle_opts=opts.LineStyleOpts(width=3))
line1.render() 

                #
                 计数
axin = df.content.str.contains(‘阿信|陈信宏‘).sum()  
guaishou = df.content.str.contains(‘温尚翊|阿翊|怪兽|团长‘).sum()  
shitou = df.content.str.contains(‘石锦航|石头‘).sum()  
masha = df.content.str.contains(‘蔡升晏|玛莎‘).sum()  
guanyou = df.content.str.contains(‘刘冠佑|冠佑|刘谚明|刘浩明‘).sum()  

actor_list = [‘阿信‘, ‘怪兽‘, ‘石头‘, ‘玛莎‘, ‘冠佑‘]
actor_num = [int(axin), int(guaishou), int(shitou), int(masha), int(guanyou)]

# 条形图
bar1 = Bar(init_opts=opts.InitOpts(width=‘1350px‘, height=‘750px‘))
bar1.add_xaxis(actor_list)
bar1.add_yaxis(‘‘, actor_num)
bar1.set_global_opts(title_opts=opts.TitleOpts(title=‘QQ音乐评论中关注歌手对比‘), 
                     visualmap_opts=opts.VisualMapOpts(max_=150),
                    ) 
bar1.render()

                #
                 歌曲名称
music_list = [‘一颗苹果‘, ‘盛夏光年‘, ‘孙悟空‘, ‘星空‘, ‘我不愿让你一个人‘,
‘派对动物‘, ‘离开地球表面‘, ‘突然好想你‘, ‘爱情的模样‘, ‘恋爱ing‘,
‘知足‘, ‘诺亚方舟‘, ‘倔强‘]

music_num = [int(df.content.str.contains(pattern).sum()) for pattern in music_list]

# 创建df
df_music = pd.DataFrame({
    ‘music_name‘: music_list,
    ‘music_num‘: music_num
}).sort_values(‘music_num‘, ascending=True) 

# 条形图
bar2 = Bar(init_opts=opts.InitOpts(width=‘1350px‘, height=‘750px‘))
bar2.add_xaxis(df_music.music_name.values.tolist())
bar2.add_yaxis(‘‘, df_music.music_num.values.tolist()) 
bar2.set_global_opts(title_opts=opts.TitleOpts(title=‘QQ音乐评论中关注歌曲对比‘), 
                     visualmap_opts=opts.VisualMapOpts(max_=307),
                    )
bar2.set_series_opts(label_opts=opts.LabelOpts(position=‘right‘))
bar2.reversal_axis()
bar2.render() 

stylecloud.gen_stylecloud(text=‘‘.join(text_all),  # text需要是str类型
                          max_words=1000,
                          collocations=False,
                          font_path=r‘?C:\Windows\Fonts\msyh.ttc‘,
                          icon_name=‘fas fa-comments‘,
                          size=768,
                          output_name=‘QQ音乐评论整体词云图.png‘
                         )