python读取excel某列内容制作词云图并用条形图统计词频_pythonexcel词云图

1星 50 浏览量更新于2023-03-03 评论 8 收藏 79KB PDF 举报

身份认证购VIP最低享 7 折!

领优惠券(最高得80元）

资源详情

资源评论

资源推荐

python读取读取excel某列内容制作词云图并用条形图统计词频某列内容制作词云图并用条形图统计词频

有的时候我们把数据整理收集整理到excel中，那么要把excel中的某列文本数据制作词云图怎么做呢？

从最简单的说起。

最简单的词云图就是这种，英文的，不读取文件，不指定背景形状图片，不指定字体。

#复制文本用字符串表示

mytext = "With his wife's encouragement, Minister Hacker decides he should focus on accomplishing 1 or 2 significant achievements while in office. He

decides the time has come to promote more women into the senior ranks of the civil service. Needless to say, Sir Humphrey very much wants to maintain

the status quo and arranges for his fellow permanent secretaries to brief their own Ministers accordingly. Hacker nonetheless insists on promoting a

woman in his own department, but things don't quite work out as planned.With his wife's encouragement, Minister Hacker decides he should focus on

accomplishing 1 or 2 significant achievements while in office. He decides the time has come to promote more women into the senior ranks of the civil

service. Needless to say, Sir Humphrey very much wants to maintain the status quo and arranges for his fellow permanent secretaries to brief their own

Ministers accordingly. Hacker nonetheless insists on promoting a woman in his own department, but things don't quite work out as planned."

from wordcloud import WordCloud #导入wordcloud包

import matplotlib.pyplot as plt

#print(mytext)

wordcloud = WordCloud(background_color="white",max_words=100) #指定词云背景色为白色，最大词数为100个单词

wordcloud.generate(mytext) #生成词云

plt.imshow(wordcloud,interpolation='bilinear') #显示词云图

plt.axis("off") #关闭词云图坐标轴

plt.show()

原创文章 2获赞 1访问量 110

关注

私信

展开阅读全文

作者：墨 tsui

本内容试读结束，登录后可阅读更多

下载后可阅读完整内容，剩余0页未读，立即下载

无忧129

2023-11-15

6，不如不发

weixin_38628211

粉丝: 4
资源: 927

会员权益专享

python读取excel某列内容制作词云图并用条形图统计词频

评论1

会员权益专享

最新资源

python读取excel某列内容制作词云图并用条形图统计词频

评论1

Python读取Excel数据并生成图表过程解析

python大数据词频生成云图

Python制作词云图代码

Python读取Excel文件的基本方法

使用Python读取Excel文件的方法与技巧

python读取excel某列内容制作词云图

python 读取excel某一列绘制词云图

python读取excel某列数据生成词云图

python读取excel的一列生成词云图

python读取excel的数据并绘制词云图

使用python写一个使用Excel表格的内容制作词云图的代码

Python根据Excel某一列生成词云的代码

python读取excel某列数据代码

用python读取excel数据方法，并生成词云图

python读取excel做词云图

python读取excel某列

python读取excel某一列内容

python词云图excel某一列

python:从excel中提取高频词生成词云

用Python做中文分词和绘制词云图

会员权益专享

最新资源