Python抓取B站评论词云可视化（一看就会）

# -*- coding:utf-8 -*-
import re
from openpyxl import load_workbook#打开一个新文件
wb = load_workbook(filename = r"C:\Users\Administrator\Desktop\ss.xlsx")
data = open("b.txt",'w',encoding="utf-8")#建立文档
ws.delete_rows(1)#删除第一行\
ws = wb.get_sheet_by_name('sheet1')#打开工作表1
first_column = ws['D']#第四列
for i in range(len(first_column)):
    print(first_column[i].value,file=data) #读取单元格内容并存储为文本

#!/usr/bin/python
# encoding: UTF-8
import re
import jieba
import wordcloud
import pyecharts.options as opts
import pandas as pd

result=[]
with open('b.txt', encoding='utf-8') as f:
  for line in f:
    result.append(line.strip('\n').split(',')[0])
print(result)
#下面是对读取到的数组进行变化
result_gai = []
a = 0
for i in result:
  while(a%2 == 0):
    pos = i.find('：') #查找某一个字符在在字符串的位置
    result_gai.append(i[pos+1:])
    break
  a+=1
print(result_gai)

res = ''.join(result_gai).replace('\xa0', '').replace('\ufeff', '').replace('\r', '')
print(res)

from wordcloud import WordCloud
wordcloud = WordCloud(font_path="msyh.ttc",background_color='white').generate(string)#定义字体和背景色
%pylab inline
import matplotlib.pyplot as plt
plt.imshow(wordcloud, interpolation='bilinear')
plt.axis("off")