点击查看【bilibili】
全代码:
#L12 Python 词云的绘制(pyecharts).py
import xlwings as xw
import pandas as pd
from pyecharts import options as opts
from pyecharts.charts import WordCloud
#读取excel文件中的数据
def read_excel(path):
pd.set_option('display.max_columns', None) #解决表格多列时中间省略显示问题(本程序用不到)
pd.set_option('display.max_rows', None) #解决表格多行时中间省略显示问题(本程序用不到)
pd.set_option('display.width', 5000) #解决表格打印换行
#读取excel文件中的数据
app = xw.App(visible = False, add_book = False)
workbook = app.books.open(path)
worksheet = workbook.sheets[0]
values = worksheet.range("A1").expand().options(pd.DataFrame, index = False).value
#print(values)
workbook.close()
app.quit()
return values
path = "wordcloud_data.xlsx"
values = read_excel(path) #调用read_excel模块读取数据
data = []
for i in range(len(values)):
data_value = values.iloc[i] #选中一行数据
name = data_value['名称']
value = data_value['数量']
item = (name, value)
print(item)
data.append(item)
print(data)
c = (
WordCloud()
.add(series_name="热点分析", data_pair=data, word_size_range=[6, 66])
.set_global_opts(
title_opts=opts.TitleOpts(
title="热点分析", title_textstyle_opts=opts.TextStyleOpts(font_size=28)
),
tooltip_opts=opts.TooltipOpts(is_show=True),
)
.render("basic_wordcloud.html")
)