Python 爬取 热词并进行分类数据分析-[云图制作+数据导入]

时间:2023-03-09 15:21:28
Python 爬取 热词并进行分类数据分析-[云图制作+数据导入]

日期:2020.01.28

博客期:136

星期二

  【本博客的代码如若要使用,请在下方评论区留言,之后再用(就是跟我说一声)】

  所有相关跳转:

  a.【简单准备

  b.【云图制作+数据导入】(本期博客)

  c.【拓扑数据

  d.【数据修复

  e.【解释修复+热词引用

   f.【JSP演示+页面跳转

  g.【热词分类+目录生成

  h.【热词关系图+报告生成

  i . 【App制作

  j . 【安全性改造


  今天主要是在网上找学习网站,爬取方面就参照之前爬到的数据做了一个简单的云图信息展示(Java Web),但是老师要求最好是用APP或者微信小程序(你认真的吗?),我目前就知道使用 Android Studio 开发App 项目,使用官方的软件开发微信小程序。但已经有半年不动这方面的东西了。还有就是那个文档生成...这大数据的数据量要用来生成的doc文档大小我不敢想!!!究竟要怎样的完成需求呢?我还要花一段时间思考,可能还是要进一步咨询老师的需求... ...

  1、使用Navicat导入文件数据或者使用Java编写代码使其自动生成sql语句再添加

  Python 爬取 热词并进行分类数据分析-[云图制作+数据导入]

  建表语句:

 Create Table data
(
name varchar(255) ,
num int,
Primary Key (name)
)

CREATE

  数据插入语句:(超长行数提醒!!!)

 Insert into data VALUES ('技术',304);
Insert into data VALUES ('开发',237);
Insert into data VALUES ('人工智能',197);
Insert into data VALUES ('数据',165);
Insert into data VALUES ('代码',160);
Insert into data VALUES ('开发者',149);
Insert into data VALUES ('程序员',139);
Insert into data VALUES ('开源',115);
Insert into data VALUES ('AI',110);
Insert into data VALUES ('云计算',110);
Insert into data VALUES ('工具',105);
Insert into data VALUES ('Python',99);
Insert into data VALUES ('技能',99);
Insert into data VALUES ('Windows',91);
Insert into data VALUES ('微软',90);
Insert into data VALUES ('华为',90);
Insert into data VALUES ('Java',85);
Insert into data VALUES ('编程语言',85);
Insert into data VALUES ('系统',79);
Insert into data VALUES ('互联网',71);
Insert into data VALUES ('操作系统',70);
Insert into data VALUES ('GitHub',67);
Insert into data VALUES ('5G',66);
Insert into data VALUES ('Linux',65);
Insert into data VALUES ('架构',64);
Insert into data VALUES ('机器学习',63);
Insert into data VALUES ('谷歌',58);
Insert into data VALUES ('苹果',57);
Insert into data VALUES ('数据库',53);
Insert into data VALUES ('软件',51);
Insert into data VALUES ('Android',46);
Insert into data VALUES ('芯片',41);
Insert into data VALUES ('网络',39);
Insert into data VALUES ('浏览器',38);
Insert into data VALUES ('大数据',37);
Insert into data VALUES ('Google',36);
Insert into data VALUES ('计算机',34);
Insert into data VALUES ('编程',34);
Insert into data VALUES ('趋势',33);
Insert into data VALUES ('研发',33);
Insert into data VALUES ('网络安全',31);
Insert into data VALUES ('功能',30);
Insert into data VALUES ('禁令',26);
Insert into data VALUES ('运营商',25);
Insert into data VALUES ('运维',24);
Insert into data VALUES ('JavaScript',20);
Insert into data VALUES ('IT',19);
Insert into data VALUES ('指标',18);
Insert into data VALUES ('企业',18);
Insert into data VALUES ('人生第一份工作',18);
Insert into data VALUES ('区块链',17);
Insert into data VALUES ('机器人',17);
Insert into data VALUES ('微信',17);
Insert into data VALUES ('iOS',17);
Insert into data VALUES ('服务器',17);
Insert into data VALUES ('微信半月刊',17);
Insert into data VALUES ('技术栈',17);
Insert into data VALUES ('科技',16);
Insert into data VALUES ('安全',16);
Insert into data VALUES ('设计',16);
Insert into data VALUES ('漏洞',15);
Insert into data VALUES ('腾讯',15);
Insert into data VALUES ('iPhone',15);
Insert into data VALUES ('行业',15);
Insert into data VALUES ('Web',14);
Insert into data VALUES ('手机',14);
Insert into data VALUES ('Oracle',14);
Insert into data VALUES ('多云',14);
Insert into data VALUES ('容器',13);
Insert into data VALUES ('算法',13);
Insert into data VALUES ('框架',12);
Insert into data VALUES ('混合云',12);
Insert into data VALUES ('标准',12);
Insert into data VALUES ('语言',12);
Insert into data VALUES ('裁员',12);
Insert into data VALUES ('智能',11);
Insert into data VALUES ('量子',11);
Insert into data VALUES ('Windows10',11);
Insert into data VALUES ('物联网',11);
Insert into data VALUES ('甲骨文',11);
Insert into data VALUES ('MySQL',11);
Insert into data VALUES ('CIO',11);
Insert into data VALUES ('深度学习',11);
Insert into data VALUES ('面试',11);
Insert into data VALUES ('Docker',11);
Insert into data VALUES ('工程师',10);
Insert into data VALUES ('App',10);
Insert into data VALUES ('前端',10);
Insert into data VALUES ('存储',10);
Insert into data VALUES ('SaaS',10);
Insert into data VALUES ('数据中心',10);
Insert into data VALUES ('工信部',10);
Insert into data VALUES ('PostgreSQL',10);
Insert into data VALUES ('亚马逊',10);
Insert into data VALUES ('SQL',9);
Insert into data VALUES ('Chrome',9);
Insert into data VALUES ('阿里',9);
Insert into data VALUES ('AWS',9);
Insert into data VALUES ('半导体',9);
Insert into data VALUES ('Redis',9);
Insert into data VALUES ('云',9);
Insert into data VALUES ('携号转网',9);
Insert into data VALUES ('应用程序',9);
Insert into data VALUES ('FaceBook',9);
Insert into data VALUES ('云平台',9);
Insert into data VALUES ('员工',9);
Insert into data VALUES ('跳槽那些事儿',9);
Insert into data VALUES ('Windows7',8);
Insert into data VALUES ('技巧',8);
Insert into data VALUES ('流量',8);
Insert into data VALUES ('数据科学',8);
Insert into data VALUES ('鸿蒙',8);
Insert into data VALUES ('超算',8);
Insert into data VALUES ('信息安全',7);
Insert into data VALUES ('安卓',7);
Insert into data VALUES ('智能手机',7);
Insert into data VALUES ('UOS',7);
Insert into data VALUES ('IBM',7);
Insert into data VALUES ('Gartner',7);
Insert into data VALUES ('量子计算机',7);
Insert into data VALUES ('移动系统',6);
Insert into data VALUES ('库克',6);
Insert into data VALUES ('隐私',6);
Insert into data VALUES ('公共云',6);
Insert into data VALUES ('Nginx',6);
Insert into data VALUES ('QQ',6);
Insert into data VALUES ('美国',6);
Insert into data VALUES ('应用',6);
Insert into data VALUES ('人脸识别',5);
Insert into data VALUES ('平台',5);
Insert into data VALUES ('攻击',5);
Insert into data VALUES ('恶意软件',5);
Insert into data VALUES ('优化',5);
Insert into data VALUES ('百度',5);
Insert into data VALUES ('数据泄露',5);
Insert into data VALUES ('4G',5);
Insert into data VALUES ('开源项目',5);
Insert into data VALUES ('边缘计算',5);
Insert into data VALUES ('PHP',5);
Insert into data VALUES ('黑客',5);
Insert into data VALUES ('密码',5);
Insert into data VALUES ('通信',5);
Insert into data VALUES ('云端',5);
Insert into data VALUES ('Hadoop',5);
Insert into data VALUES ('迁移',5);
Insert into data VALUES ('Springboot',5);
Insert into data VALUES ('云迁移',5);
Insert into data VALUES ('小程序',4);
Insert into data VALUES ('Kubernetes',4);
Insert into data VALUES ('电子商务',4);
Insert into data VALUES ('支付宝',4);
Insert into data VALUES ('5G手机',4);
Insert into data VALUES ('Kotlin',4);
Insert into data VALUES ('C++',4);
Insert into data VALUES ('移动互联网',4);
Insert into data VALUES ('私有云',4);
Insert into data VALUES ('阿里巴巴',4);
Insert into data VALUES ('公有云',4);
Insert into data VALUES ('C语言',4);
Insert into data VALUES ('网络攻击',4);
Insert into data VALUES ('乔布斯',4);
Insert into data VALUES ('分析',4);
Insert into data VALUES ('微服务',4);
Insert into data VALUES ('报告',4);
Insert into data VALUES ('高通',4);
Insert into data VALUES ('DevOps',4);
Insert into data VALUES ('分布式',4);
Insert into data VALUES ('移动',4);
Insert into data VALUES ('6G',3);
Insert into data VALUES ('性能',3);
Insert into data VALUES ('电脑',3);
Insert into data VALUES ('AR',3);
Insert into data VALUES ('国产操作系统',3);
Insert into data VALUES ('VSCode',3);
Insert into data VALUES ('微信支付',3);
Insert into data VALUES ('经济',3);
Insert into data VALUES ('5G牌照',3);
Insert into data VALUES ('手机厂商',3);
Insert into data VALUES ('平板电脑',3);
Insert into data VALUES ('金融',3);
Insert into data VALUES ('中国',3);
Insert into data VALUES ('爬虫',3);
Insert into data VALUES ('自动驾驶',3);
Insert into data VALUES ('网站',3);
Insert into data VALUES ('年薪',3);
Insert into data VALUES ('量子计算',3);
Insert into data VALUES ('职业',3);
Insert into data VALUES ('工作',3);
Insert into data VALUES ('项目',3);
Insert into data VALUES ('鸿蒙OS',3);
Insert into data VALUES ('创业',3);
Insert into data VALUES ('网络爬虫',3);
Insert into data VALUES ('云服务',3);
Insert into data VALUES ('脚本语言',3);
Insert into data VALUES ('iOS13',3);
Insert into data VALUES ('MongoDB',3);
Insert into data VALUES ('阿里云',3);
Insert into data VALUES ('函数',3);
Insert into data VALUES ('Go',3);
Insert into data VALUES ('搜索引擎',3);
Insert into data VALUES ('任正非',3);
Insert into data VALUES ('工资',3);
Insert into data VALUES ('中兴',3);
Insert into data VALUES ('硬件',3);
Insert into data VALUES ('小米',3);
Insert into data VALUES ('Word',2);
Insert into data VALUES ('iPhone11',2);
Insert into data VALUES ('线程',2);
Insert into data VALUES ('管理',2);
Insert into data VALUES ('网络钓鱼',2);
Insert into data VALUES ('云时代',2);
Insert into data VALUES ('ERP',2);
Insert into data VALUES ('协议',2);
Insert into data VALUES ('电池',2);
Insert into data VALUES ('程序',2);
Insert into data VALUES ('内存',2);
Insert into data VALUES ('薪资',2);
Insert into data VALUES ('月薪',2);
Insert into data VALUES ('隐私保护',2);
Insert into data VALUES ('5G通信',2);
Insert into data VALUES ('eSIM',2);
Insert into data VALUES ('IT部门',2);
Insert into data VALUES ('ElasticSearch',2);
Insert into data VALUES ('薪酬',2);
Insert into data VALUES ('离职',2);
Insert into data VALUES ('文章',2);
Insert into data VALUES ('CSS',2);
Insert into data VALUES ('预测',2);
Insert into data VALUES ('社交',2);
Insert into data VALUES ('SOC',2);
Insert into data VALUES ('安全运营中心',2);
Insert into data VALUES ('面部识别',2);
Insert into data VALUES ('工业互联网',2);
Insert into data VALUES ('图像识别',2);
Insert into data VALUES ('网络连接',2);
Insert into data VALUES ('TF',2);
Insert into data VALUES ('Mac',2);
Insert into data VALUES ('微博',2);
Insert into data VALUES ('电商',2);
Insert into data VALUES ('自动化',2);
Insert into data VALUES ('IT主管',2);
Insert into data VALUES ('观远数据',2);
Insert into data VALUES ('VisualStudio',2);
Insert into data VALUES ('HR',2);
Insert into data VALUES ('简历',2);
Insert into data VALUES ('麦肯锡',2);
Insert into data VALUES ('招聘',2);
Insert into data VALUES ('英特尔',2);
Insert into data VALUES ('AI芯片',2);
Insert into data VALUES ('网易',2);
Insert into data VALUES ('IPv4',2);
Insert into data VALUES ('经验',2);
Insert into data VALUES ('收集数据',2);
Insert into data VALUES ('搜索',2);
Insert into data VALUES ('岗位',2);
Insert into data VALUES ('虚拟化',2);
Insert into data VALUES ('Go语言',2);
Insert into data VALUES ('大学',2);
Insert into data VALUES ('缓存',2);
Insert into data VALUES ('双11',2);
Insert into data VALUES ('业务',2);
Insert into data VALUES ('数字化',2);
Insert into data VALUES ('规范',2);
Insert into data VALUES ('NoSQL',2);
Insert into data VALUES ('GitLab',2);
Insert into data VALUES ('中国移动',2);
Insert into data VALUES ('移动支付',2);
Insert into data VALUES ('IoT',2);
Insert into data VALUES ('数字化转型',2);
Insert into data VALUES ('华尔街',2);
Insert into data VALUES ('成本管理',2);
Insert into data VALUES ('数据分析师',2);
Insert into data VALUES ('VR',2);
Insert into data VALUES ('陷阱',2);
Insert into data VALUES ('统计',2);
Insert into data VALUES ('固态硬盘',2);
Insert into data VALUES ('BAT',2);
Insert into data VALUES ('Rust',2);
Insert into data VALUES ('数据结构',2);
Insert into data VALUES ('三星',2);
Insert into data VALUES ('辞退',2);
Insert into data VALUES ('车联网',2);
Insert into data VALUES ('数据存储',2);
Insert into data VALUES ('托管',2);
Insert into data VALUES ('信息泄露',2);
Insert into data VALUES ('内核',2);
Insert into data VALUES ('Fuchsia',2);
Insert into data VALUES ('虚拟机',2);
Insert into data VALUES ('CPU',2);
Insert into data VALUES ('汽车',2);
Insert into data VALUES ('制造业',2);
Insert into data VALUES ('红帽',2);
Insert into data VALUES ('NFC',2);
Insert into data VALUES ('鸿蒙系统',2);
Insert into data VALUES ('特朗普',2);
Insert into data VALUES ('下半场',2);
Insert into data VALUES ('Firefox',2);
Insert into data VALUES ('脸书',2);
Insert into data VALUES ('平板',2);
Insert into data VALUES ('iPadOS',2);
Insert into data VALUES ('客户',2);
Insert into data VALUES ('云安全',2);
Insert into data VALUES ('TensorFlow',2);
Insert into data VALUES ('',2);
Insert into data VALUES ('Edge',2);
Insert into data VALUES ('WindowsXP',1);
Insert into data VALUES ('教程',1);
Insert into data VALUES ('Cookie',1);
Insert into data VALUES ('Token',1);
Insert into data VALUES ('Session',1);
Insert into data VALUES ('入职阿里',1);
Insert into data VALUES ('输入法',1);
Insert into data VALUES ('超宽带',1);
Insert into data VALUES ('iOS13.3.1',1);
Insert into data VALUES ('转型',1);
Insert into data VALUES ('技术人',1);
Insert into data VALUES ('赏金',1);
Insert into data VALUES ('大数据工程师',1);
Insert into data VALUES ('分析师',1);
Insert into data VALUES ('威胁',1);
Insert into data VALUES ('读书',1);
Insert into data VALUES ('现代化',1);
Insert into data VALUES ('营销',1);
Insert into data VALUES ('京东',1);
Insert into data VALUES ('优惠券',1);
Insert into data VALUES ('开放',1);
Insert into data VALUES ('春节红包',1);
Insert into data VALUES ('付费阅读',1);
Insert into data VALUES ('太赫兹',1);
Insert into data VALUES ('云数据库',1);
Insert into data VALUES ('出货',1);
Insert into data VALUES ('5G商用',1);
Insert into data VALUES ('传感器',1);
Insert into data VALUES ('无按键',1);
Insert into data VALUES ('',1);
Insert into data VALUES ('DeepinOS',1);
Insert into data VALUES ('编码',1);
Insert into data VALUES ('Salesforce',1);
Insert into data VALUES ('设备商',1);
Insert into data VALUES ('SysFlow',1);
Insert into data VALUES ('以旧换新',1);
Insert into data VALUES ('回收价格',1);
Insert into data VALUES ('iPhone12',1);
Insert into data VALUES ('流程',1);
Insert into data VALUES ('职位晋升',1);
Insert into data VALUES ('年终考核',1);
Insert into data VALUES ('人脸识别硬件',1);
Insert into data VALUES ('2024年',1);
Insert into data VALUES ('应届生',1);
Insert into data VALUES ('手机导航',1);
Insert into data VALUES ('搜狐',1);
Insert into data VALUES ('IT安全',1);
Insert into data VALUES ('网络安全公司',1);
Insert into data VALUES ('总结',1);
Insert into data VALUES ('互联网江湖',1);
Insert into data VALUES ('达摩院',1);
Insert into data VALUES ('CES',1);
Insert into data VALUES ('首席信息官',1);
Insert into data VALUES ('王小琴',1);
Insert into data VALUES ('飞越旅行',1);
Insert into data VALUES ('董事长',1);
Insert into data VALUES ('5G体验',1);
Insert into data VALUES ('5G频谱',1);
Insert into data VALUES ('社区',1);
Insert into data VALUES ('居民',1);
Insert into data VALUES ('信息',1);
Insert into data VALUES ('故事',1);
Insert into data VALUES ('勒索软件',1);
Insert into data VALUES ('国产CAD',1);
Insert into data VALUES ('技术资讯',1);
Insert into data VALUES ('51CTO',1);
Insert into data VALUES ('中国企业年终评选',1);
Insert into data VALUES ('移动应用',1);
Insert into data VALUES ('CPU处理器',1);
Insert into data VALUES ('工业物联网',1);
Insert into data VALUES ('2020科技趋势',1);
Insert into data VALUES ('字符串',1);
Insert into data VALUES ('安全从业人员',1);
Insert into data VALUES ('联想',1);
Insert into data VALUES ('联想手机',1);
Insert into data VALUES ('Excel',1);
Insert into data VALUES ('产业大事记',1);
Insert into data VALUES ('网络购票',1);
Insert into data VALUES ('基因',1);
Insert into data VALUES ('微前端',1);
Insert into data VALUES ('前端工程师',1);
Insert into data VALUES ('运营',1);
Insert into data VALUES ('网约车',1);
Insert into data VALUES ('虚拟',1);
Insert into data VALUES ('商业模式',1);
Insert into data VALUES ('传统IT',1);
Insert into data VALUES ('企业资源计划',1);
Insert into data VALUES ('信息安全证书',1);
Insert into data VALUES ('Cortana',1);
Insert into data VALUES ('192号段',1);
Insert into data VALUES ('中国广电',1);
Insert into data VALUES ('集群',1);
Insert into data VALUES ('朋友圏评论',1);
Insert into data VALUES ('国创上头条',1);
Insert into data VALUES ('全面屏',1);
Insert into data VALUES ('保险',1);
Insert into data VALUES ('客户服务',1);
Insert into data VALUES ('WebKit',1);
Insert into data VALUES ('Pytorc',1);
Insert into data VALUES ('英语',1);
Insert into data VALUES ('国家电网',1);
Insert into data VALUES ('云游戏',1);
Insert into data VALUES ('Istio',1);
Insert into data VALUES ('服务网格',1);
Insert into data VALUES ('车次',1);
Insert into data VALUES ('春运',1);
Insert into data VALUES ('抢票',1);
Insert into data VALUES ('5G平板',1);
Insert into data VALUES ('服务平台',1);
Insert into data VALUES ('机器视觉',1);
Insert into data VALUES ('实践',1);
Insert into data VALUES ('图形',1);
Insert into data VALUES ('神经网络',1);
Insert into data VALUES ('开源社区',1);
Insert into data VALUES ('违规',1);
Insert into data VALUES ('高并发',1);
Insert into data VALUES ('秒杀',1);
Insert into data VALUES ('域名',1);
Insert into data VALUES ('.com',1);
Insert into data VALUES ('网络威胁',1);
Insert into data VALUES ('油管',1);
Insert into data VALUES ('电子产品',1);
Insert into data VALUES ('抖音',1);
Insert into data VALUES ('新零售',1);
Insert into data VALUES ('马云',1);
Insert into data VALUES ('5GiPhone',1);
Insert into data VALUES ('虚拟主机',1);
Insert into data VALUES ('Rambler',1);
Insert into data VALUES ('数据科学家',1);
Insert into data VALUES ('编程元知识',1);
Insert into data VALUES ('交通运输部',1);
Insert into data VALUES ('项目经理',1);
Insert into data VALUES ('运维工程师',1);
Insert into data VALUES ('IT技术',1);
Insert into data VALUES ('东南亚',1);
Insert into data VALUES ('数据服务',1);
Insert into data VALUES ('下架',1);
Insert into data VALUES ('基础设施',1);
Insert into data VALUES ('研发团队激励',1);
Insert into data VALUES ('数据画像',1);
Insert into data VALUES ('技术创业',1);
Insert into data VALUES ('双十一',1);
Insert into data VALUES ('天猫',1);
Insert into data VALUES ('商业价值',1);
Insert into data VALUES ('扎克伯格',1);
Insert into data VALUES ('IaaS',1);
Insert into data VALUES ('云计算标准和应用',1);
Insert into data VALUES ('云计算标准',1);
Insert into data VALUES ('账户',1);
Insert into data VALUES ('微软账户',1);
Insert into data VALUES ('支付宝机房宕机',1);
Insert into data VALUES ('网络故障',1);
Insert into data VALUES ('Sprint',1);
Insert into data VALUES ('个人信息',1);
Insert into data VALUES ('TalkingData',1);
Insert into data VALUES ('违法违规',1);
Insert into data VALUES ('电子合同',1);
Insert into data VALUES ('CA',1);
Insert into data VALUES ('电子认证',1);
Insert into data VALUES ('初创公司',1);
Insert into data VALUES ('中国银行',1);
Insert into data VALUES ('FaceID',1);
Insert into data VALUES ('MacBook',1);
Insert into data VALUES ('数据驱动',1);
Insert into data VALUES ('元航资本',1);
Insert into data VALUES ('榜单',1);
Insert into data VALUES ('摩根大通',1);
Insert into data VALUES ('本土',1);
Insert into data VALUES ('Canalys',1);
Insert into data VALUES ('商业智能',1);
Insert into data VALUES ('项目管理',1);
Insert into data VALUES ('转出',1);
Insert into data VALUES ('协作设计',1);
Insert into data VALUES ('领域驱动',1);
Insert into data VALUES ('R语言',1);
Insert into data VALUES ('数学',1);
Insert into data VALUES ('创造',1);
Insert into data VALUES ('聊天',1);
Insert into data VALUES ('语音交互',1);
Insert into data VALUES ('战略',1);
Insert into data VALUES ('问题',1);
Insert into data VALUES ('PPT',1);
Insert into data VALUES ('收藏',1);
Insert into data VALUES ('创新',1);
Insert into data VALUES ('IT架构',1);
Insert into data VALUES ('福利',1);
Insert into data VALUES ('阿里巴巴集团',1);
Insert into data VALUES ('设计模式',1);
Insert into data VALUES ('API',1);
Insert into data VALUES ('绝症',1);
Insert into data VALUES ('数据仓库',1);
Insert into data VALUES ('数据湖',1);
Insert into data VALUES ('资讯',1);
Insert into data VALUES ('ZorinOS15Lite',1);
Insert into data VALUES ('团队',1);
Insert into data VALUES ('全栈',1);
Insert into data VALUES ('教育',1);
Insert into data VALUES ('少儿编程',1);
Insert into data VALUES ('5G服务',1);
Insert into data VALUES ('5G套餐',1);
Insert into data VALUES ('PC',1);
Insert into data VALUES ('收入',1);
Insert into data VALUES ('VisualStudioCode',1);
Insert into data VALUES ('企业上云',1);
Insert into data VALUES ('多线程',1);
Insert into data VALUES ('云策略',1);
Insert into data VALUES ('东汉',1);
Insert into data VALUES ('语音识别',1);
Insert into data VALUES ('诈骗犯罪',1);
Insert into data VALUES ('OpenStack社区',1);
Insert into data VALUES ('Mirantis',1);
Insert into data VALUES ('笔记本',1);
Insert into data VALUES ('Wi-Fi6',1);
Insert into data VALUES ('AMDSVM',1);
Insert into data VALUES ('IntelV',1);
Insert into data VALUES ('技术周刊',1);
Insert into data VALUES ('号码',1);
Insert into data VALUES ('北极',1);
Insert into data VALUES ('组织',1);
Insert into data VALUES ('管理岗',1);
Insert into data VALUES ('RevokeMsgPatche',1);
Insert into data VALUES ('奖金',1);
Insert into data VALUES ('工业和信息化部',1);
Insert into data VALUES ('失败',1);
Insert into data VALUES ('收购',1);
Insert into data VALUES ('厂商',1);
Insert into data VALUES ('京东数科',1);
Insert into data VALUES ('IT职场',1);
Insert into data VALUES ('IT求职',1);
Insert into data VALUES ('IT技能',1);
Insert into data VALUES ('阿里云计算',1);
Insert into data VALUES ('拼多多',1);
Insert into data VALUES ('刷脸支付',1);
Insert into data VALUES ('云成本',1);
Insert into data VALUES ('安全感',1);
Insert into data VALUES ('优麒麟',1);
Insert into data VALUES ('中国联通',1);
Insert into data VALUES ('中国电信',1);
Insert into data VALUES ('enSilo',1);
Insert into data VALUES ('终端安全',1);
Insert into data VALUES ('Fortinet',1);
Insert into data VALUES ('共生关系',1);
Insert into data VALUES ('专家',1);
Insert into data VALUES ('产业新闻;十月大事',1);
Insert into data VALUES ('无人超市',1);
Insert into data VALUES ('接受风险',1);
Insert into data VALUES ('数据安全',1);
Insert into data VALUES ('内部威胁',1);
Insert into data VALUES ('Alphabet',1);
Insert into data VALUES ('Olmstead',1);
Insert into data VALUES ('密码法',1);
Insert into data VALUES ('生活冷知识人生第一份工作',1);
Insert into data VALUES ('优化策略',1);
Insert into data VALUES ('商业',1);
Insert into data VALUES ('IT创造力',1);
Insert into data VALUES ('Librem5',1);
Insert into data VALUES ('LinuxQQ',1);
Insert into data VALUES ('IT技术人员',1);
Insert into data VALUES ('Android9',1);
Insert into data VALUES ('手机号转账',1);
Insert into data VALUES ('解决方案',1);
Insert into data VALUES ('网络战',1);
Insert into data VALUES ('不完美妈妈',1);
Insert into data VALUES ('增强分析',1);
Insert into data VALUES ('数据分析',1);
Insert into data VALUES ('医药行业',1);
Insert into data VALUES ('云计算3.0',1);
Insert into data VALUES ('Droidcon',1);
Insert into data VALUES ('年度盛会',1);
Insert into data VALUES ('移动开发',1);
Insert into data VALUES ('敏捷',1);
Insert into data VALUES ('企业高管',1);
Insert into data VALUES ('无代码',1);
Insert into data VALUES ('低代码',1);
Insert into data VALUES ('IT支出',1);
Insert into data VALUES ('4G网络',1);
Insert into data VALUES ('折叠屏手机',1);
Insert into data VALUES ('AmazonAurora',1);
Insert into data VALUES ('费曼学习法',1);
Insert into data VALUES ('清华大学',1);
Insert into data VALUES ('好好学习',1);
Insert into data VALUES ('相册权限',1);
Insert into data VALUES ('通讯录',1);
Insert into data VALUES ('配置错误',1);
Insert into data VALUES ('汇编语言',1);
Insert into data VALUES ('周边业务',1);
Insert into data VALUES ('IT人员',1);
Insert into data VALUES ('认证',1);
Insert into data VALUES ('成本',1);
Insert into data VALUES ('2G手机',1);
Insert into data VALUES ('5G网络',1);
Insert into data VALUES ('门户网站',1);
Insert into data VALUES ('Bing',1);
Insert into data VALUES ('多云策略',1);
Insert into data VALUES ('云区域',1);
Insert into data VALUES ('云业务',1);
Insert into data VALUES ('Python开发',1);
Insert into data VALUES ('Python教程',1);
Insert into data VALUES ('旧手机',1);
Insert into data VALUES ('iTunes',1);
Insert into data VALUES ('监控',1);
Insert into data VALUES ('朋友圈',1);
Insert into data VALUES ('旅行',1);
Insert into data VALUES ('中国工厂',1);
Insert into data VALUES ('Andorid',1);
Insert into data VALUES ('GoogleCloud',1);
Insert into data VALUES ('云市场',1);
Insert into data VALUES ('TimCook',1);
Insert into data VALUES ('城市大数据',1);
Insert into data VALUES ('大数据平台',1);
Insert into data VALUES ('智慧城市',1);
Insert into data VALUES ('第二代',1);
Insert into data VALUES ('灾难恢复',1);
Insert into data VALUES ('中断',1);
Insert into data VALUES ('旅游',1);
Insert into data VALUES ('天翼云',1);
Insert into data VALUES ('微信电脑版',1);
Insert into data VALUES ('华为HC2019',1);
Insert into data VALUES ('多元化异构计算',1);
Insert into data VALUES ('异构计算',1);
Insert into data VALUES ('马化腾',1);
Insert into data VALUES ('产品',1);
Insert into data VALUES ('MicrosoftTeams',1);
Insert into data VALUES ('职场',1);
Insert into data VALUES ('IT人',1);
Insert into data VALUES ('高可用',1);
Insert into data VALUES ('消息系统',1);
Insert into data VALUES ('房贷',1);
Insert into data VALUES ('降薪',1);
Insert into data VALUES ('秋季发布会',1);
Insert into data VALUES ('手机互传',1);
Insert into data VALUES ('vivo',1);
Insert into data VALUES ('OPPO',1);
Insert into data VALUES ('版本',1);
Insert into data VALUES ('模板',1);
Insert into data VALUES ('调试',1);
Insert into data VALUES ('关机',1);
Insert into data VALUES ('命令',1);
Insert into data VALUES ('海康威视',1);
Insert into data VALUES ('TypeScript',1);
Insert into data VALUES ('思科',1);
Insert into data VALUES ('脚本',1);
Insert into data VALUES ('Bash',1);
Insert into data VALUES ('IBMFlashSystem900',1);
Insert into data VALUES ('Ubuntu',1);
Insert into data VALUES ('手机号',1);
Insert into data VALUES ('骚扰电话',1);
Insert into data VALUES ('号码标注',1);
Insert into data VALUES ('通信骗局',1);
Insert into data VALUES ('加班',1);
Insert into data VALUES ('WiFi',1);
Insert into data VALUES ('JSON',1);
Insert into data VALUES ('一线城市',1);
Insert into data VALUES ('数据保护',1);
Insert into data VALUES ('网站可靠性工程师',1);
Insert into data VALUES ('系统管理员',1);
Insert into data VALUES ('iPhone6',1);
Insert into data VALUES ('防火墙',1);
Insert into data VALUES ('云存储',1);
Insert into data VALUES ('智能家居',1);
Insert into data VALUES ('图',1);
Insert into data VALUES ('费马科技',1);
Insert into data VALUES ('图计算',1);
Insert into data VALUES ('鼠标',1);
Insert into data VALUES ('红帽公司',1);
Insert into data VALUES ('基础设施监控',1);
Insert into data VALUES ('Fedora',1);
Insert into data VALUES ('求职者',1);
Insert into data VALUES ('IT管理者',1);
Insert into data VALUES ('元数据',1);
Insert into data VALUES ('政治',1);
Insert into data VALUES ('Wi-Fi',1);
Insert into data VALUES ('DNS',1);
Insert into data VALUES ('Dashboard',1);
Insert into data VALUES ('网盘',1);
Insert into data VALUES ('MySQ',1);
Insert into data VALUES ('智能物联',1);
Insert into data VALUES ('数字',1);
Insert into data VALUES ('英伟达',1);
Insert into data VALUES ('JeffWilliams',1);
Insert into data VALUES ('大中华区执行董事',1);
Insert into data VALUES ('全球副总裁',1);
Insert into data VALUES ('张文翊',1);
Insert into data VALUES ('RedHa',1);
Insert into data VALUES ('游戏性能',1);
Insert into data VALUES ('Linux游戏',1);
Insert into data VALUES ('二维码',1);
Insert into data VALUES ('性别',1);
Insert into data VALUES ('物种',1);
Insert into data VALUES ('程序媛',1);
Insert into data VALUES ('跳槽',1);
Insert into data VALUES ('级别',1);
Insert into data VALUES ('开源软件',1);
Insert into data VALUES ('卖出',1);
Insert into data VALUES ('无服务器计算',1);
Insert into data VALUES ('防雷',1);
Insert into data VALUES ('雷劈',1);
Insert into data VALUES ('WindowsPhone',1);
Insert into data VALUES ('入职',1);
Insert into data VALUES ('KFS',1);
Insert into data VALUES ('KVDB',1);
Insert into data VALUES ('KSOne',1);
Insert into data VALUES ('国内',1);
Insert into data VALUES ('VDI',1);
Insert into data VALUES ('数据库排行',1);
Insert into data VALUES ('RAT',1);
Insert into data VALUES ('日志',1);
Insert into data VALUES ('操作',1);
Insert into data VALUES ('泼水',1);
Insert into data VALUES ('李彦宏',1);
Insert into data VALUES ('外包',1);
Insert into data VALUES ('云语言',1);
Insert into data VALUES ('顶会',1);
Insert into data VALUES ('博士生',1);
Insert into data VALUES ('「业务',1);
Insert into data VALUES ('劳动',1);
Insert into data VALUES ('中文版',1);
Insert into data VALUES ('iOS开发者',1);
Insert into data VALUES ('云原生',1);
Insert into data VALUES ('调度',1);
Insert into data VALUES ('刷单',1);
Insert into data VALUES ('网购好评',1);
Insert into data VALUES ('数据集成',1);
Insert into data VALUES ('数据转换',1);
Insert into data VALUES ('数据迁移',1);
Insert into data VALUES ('云计算提供商',1);
Insert into data VALUES ('专利',1);
Insert into data VALUES ('PTC',1);
Insert into data VALUES ('Creo6.0',1);
Insert into data VALUES ('Vue',1);
Insert into data VALUES ('消费者',1);
Insert into data VALUES ('辞职',1);
Insert into data VALUES ('企业安全',1);
Insert into data VALUES ('macOS',1);
Insert into data VALUES ('Adobe',1);
Insert into data VALUES ('危机',1);
Insert into data VALUES ('笔记本电脑',1);
Insert into data VALUES ('5*业',1);
Insert into data VALUES ('折叠屏',1);
Insert into data VALUES ('货币',1);
Insert into data VALUES ('王新哲',1);
Insert into data VALUES ('容器化',1);
Insert into data VALUES ('新兴市场',1);
Insert into data VALUES ('流处理',1);
Insert into data VALUES ('无线电频谱',1);
Insert into data VALUES ('策略',1);
Insert into data VALUES ('中年人',1);
Insert into data VALUES ('越狱',1);
Insert into data VALUES ('云原生计算基金会',1);
Insert into data VALUES ('码农',1);
Insert into data VALUES ('会计师',1);
Insert into data VALUES ('商标',1);
Insert into data VALUES ('零售商',1);
Insert into data VALUES ('终端',1);
Insert into data VALUES ('IT团队',1);
Insert into data VALUES ('后厂村',1);
Insert into data VALUES ('GooglePlay',1);
Insert into data VALUES ('SD-WAN',1);
Insert into data VALUES ('云厂商',1);
Insert into data VALUES ('职位',1);
Insert into data VALUES ('云环境',1);
Insert into data VALUES ('数据治理',1);
Insert into data VALUES ('计算库',1);
Insert into data VALUES ('零售',1);
Insert into data VALUES ('开发者工具',1);
Insert into data VALUES ('智慧消防',1);
Insert into data VALUES ('光缆',1);
Insert into data VALUES ('挖掘机',1);
Insert into data VALUES ('标记',1);
Insert into data VALUES ('页面',1);
Insert into data VALUES ('静态',1);
Insert into data VALUES ('5月更新',1);
Insert into data VALUES ('应聘',1);
Insert into data VALUES ('华为人',1);
Insert into data VALUES ('IEEE',1);
Insert into data VALUES ('JEDEC协会',1);
Insert into data VALUES ('蓝牙联盟',1);
Insert into data VALUES ('WiFi联盟',1);
Insert into data VALUES ('纠纷',1);
Insert into data VALUES ('商业趋势',1);
Insert into data VALUES ('梅宏大数据',1);
Insert into data VALUES ('DBA',1);
Insert into data VALUES ('回忆',1);
Insert into data VALUES ('SQL语句',1);
Insert into data VALUES ('提速降费',1);
Insert into data VALUES ('社招',1);
Insert into data VALUES ('字节跳动',1);
Insert into data VALUES ('头条',1);
Insert into data VALUES ('飞聊',1);
Insert into data VALUES ('咨询',1);
Insert into data VALUES ('无人机',1);
Insert into data VALUES ('雷军',1);
Insert into data VALUES ('变软',1);
Insert into data VALUES ('挑战',1);
Insert into data VALUES ('美国*',1);
Insert into data VALUES ('云基础架构',1);
Insert into data VALUES ('Winnti',1);
Insert into data VALUES ('权限',1);
Insert into data VALUES ('港科',1);
Insert into data VALUES ('微众银行',1);
Insert into data VALUES ('可视化',1);
Insert into data VALUES ('海思',1);
Insert into data VALUES ('原则',1);
Insert into data VALUES ('定律',1);
Insert into data VALUES ('反垄断',1);
Insert into data VALUES ('小冰',1);
Insert into data VALUES ('IT厂商',1);
Insert into data VALUES ('包装',1);
Insert into data VALUES ('流量资费',1);
Insert into data VALUES ('防护',1);
Insert into data VALUES ('ZombieLoad',1);
Insert into data VALUES ('赛门铁克',1);
Insert into data VALUES ('SAP',1);
Insert into data VALUES ('信用卡',1);
Insert into data VALUES ('AppleCard',1);
Insert into data VALUES ('网民',1);
Insert into data VALUES ('上市公司',1);
Insert into data VALUES ('台积电',1);
Insert into data VALUES ('A13',1);
Insert into data VALUES ('CDN',1);
Insert into data VALUES ('IDC',1);
Insert into data VALUES ('阴影者',1);
Insert into data VALUES ('Logo',1);
Insert into data VALUES ('垃圾短信',1);
Insert into data VALUES ('iMessage',1);
Insert into data VALUES ('演讲',1);
Insert into data VALUES ('SOCaaS',1);
Insert into data VALUES ('续费',1);
Insert into data VALUES ('欠薪',1);
Insert into data VALUES ('中国军备',1);
Insert into data VALUES ('加密技术',1);
Insert into data VALUES ('量子加密',1);
Insert into data VALUES ('无人驾驶',1);
Insert into data VALUES ('AppleStore',1);
Insert into data VALUES ('00后',1);
Insert into data VALUES ('90后',1);
Insert into data VALUES ('Orange',1);
Insert into data VALUES ('电信',1);
Insert into data VALUES ('巴菲特',1);
Insert into data VALUES ('大小核',1);
Insert into data VALUES ('远程医疗',1);
Insert into data VALUES ('医疗保健',1);
Insert into data VALUES ('扫码刷脸',1);
Insert into data VALUES ('苹果客服',1);
Insert into data VALUES ('LG',1);
Insert into data VALUES ('社保',1);
Insert into data VALUES ('社会保险',1);
Insert into data VALUES ('养老金',1);
Insert into data VALUES ('创业者',1);
Insert into data VALUES ('零售业',1);
Insert into data VALUES ('中关村',1);
Insert into data VALUES ('KOL',1);
Insert into data VALUES ('人才',1);
Insert into data VALUES ('手机基带',1);
Insert into data VALUES ('Intel',1);
Insert into data VALUES ('Debian10Buster',1);
Insert into data VALUES ('罗宾汉',1);
Insert into data VALUES ('谷歌云',1);
Insert into data VALUES ('密码过期',1);
Insert into data VALUES ('局域网',1);
Insert into data VALUES ('Git',1);
Insert into data VALUES ('设计团队',1);
Insert into data VALUES ('信息垃圾',1);
Insert into data VALUES ('技术人才',1);
Insert into data VALUES ('编译',1);
Insert into data VALUES ('获得场景视频',1);
Insert into data VALUES ('WOT',1);
Insert into data VALUES ('模拟器',1);
Insert into data VALUES ('分布式架构',1);
Insert into data VALUES ('Spark',1);
Insert into data VALUES ('成本优化',1);
Insert into data VALUES ('FinOps',1);

Insert

  2、接下来是找到ECharts的云图模板,利用Servlet配置数据成符合模板要求的样式。

  下面是云图的具体实现步骤:

  (1)、从官网下载Echarts的云图扩展包!

Python 爬取 热词并进行分类数据分析-[云图制作+数据导入]

  选择Download ZIP!

  目标文件如下图:

  Python 爬取 热词并进行分类数据分析-[云图制作+数据导入]

  获得文件后可以找到example文件夹里的实例看看用法,会了以后删掉就可以了!

  (2)、打开Eclipse准备连接数据库的环境(包括我的连接数据库的Jar包)

  先将页面设置好:

  //数据对应传输Servlet代码

 package com.servlet;

 import java.io.IOException;
import java.sql.SQLException;
import java.util.List; import javax.servlet.ServletException;
import javax.servlet.ServletOutputStream;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse; import org.json.JSONArray;
import org.json.JSONObject; import com.dblink.basic.utils.SqlUtils;
import com.dblink.basic.utils.sqlKind.MySql_s;
import com.dblink.basic.utils.user.UserInfo;
import com.dblink.bean.BeanGroup;
import com.dblink.sql.DBLink; @SuppressWarnings("unused")
public class ServletForWords extends HttpServlet{
/**
*
*/
private static final long serialVersionUID = 1L;
//----------------------------------------------------------------------//
public void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException
{
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
response.setContentType("application/json");
response.setHeader("Cache-Control", "no-cache");
response.setHeader("Pragma", "no-cache"); JSONArray jsonArray = new JSONArray(); DBLink dbLink = new DBLink(new SqlUtils(new MySql_s("rc"),new UserInfo("root","123456")));
BeanGroup bg = null;
try {
bg = dbLink.getSelect("Select * From data").beans;
int leng = bg.size();
for(int i=0;i<leng;++i)
{
JSONObject jsonObject = new JSONObject();
jsonObject.put("name",bg.get(i).get(0));
jsonObject.put("value",bg.get(i).get(1));
jsonArray.put(jsonObject);
}
} catch (SQLException e) {
// Do Nothing ...
}
dbLink.free(); ServletOutputStream os = response.getOutputStream();
os.write(jsonArray.toString().getBytes());
os.flush();
os.close();
}
//---------------------------------------------------------------------------------//
}

ServletForWords.java

  //云图对应js调用代码

 function makePageToCl()
{
var Area = '';
Area += '<div class="row">';
Area += '<div class="col-md-12">';
Area += '<h2>热词云图</h2>';
Area += '</div>';
Area += '</div>';
Area += '<hr />';
Area += '<br>';
Area += '<div id="MessageArea">';
Area += ' <div id="displayArea" style="width:1000px;height:500px;"></div>';
Area += '</div>';
document.getElementById("page-inner").innerHTML = Area;
loadPartCloud();
}
function loadPartCloud()
{
var xmlHttp = null;
try{
xmlHttp = new XMLHttpRequest();
} catch (e1) {
try {
xmlHttp = new ActiveXObject("Microsoft.XMLHTTP");
} catch (e2) {
alert("Your browser does not support XMLHTTP!");
return;
}
}
xmlHttp.onreadystatechange = function() {
if (xmlHttp.readyState == 4) {
if (xmlHttp.status == 200)
{
s = xmlHttp.responseText;
var InformationSet = eval('('+s+')');
var leng = InformationSet;
var myChart = echarts.init(document.getElementById('displayArea')); var option = {
tooltip: {},
series: [ {
type: 'wordCloud',
gridSize: 2,
sizeRange: [12, 50],
rotationRange: [-90, 90],
shape: 'robot',
width: 600,
height: 400,
drawOutOfBound: true,
textStyle: {
normal: {
color: function () {
return 'rgb(' + [
Math.round(Math.random() * 160),
Math.round(Math.random() * 160),
Math.round(Math.random() * 160)
].join(',') + ')';
}
},
emphasis: {
shadowBlur: 10,
shadowColor: '#333'
}
},
data: leng
} ]
}; myChart.setOption(option); }
}
};
var url ="../com/servlet/ServletForWords"; xmlHttp.open("POST", url, true);
xmlHttp.setRequestHeader("Content-Type","application/x-www-form-urlencoded");
xmlHttp.send(null);
}

cloud.js

  最终云图效果展示:

Python 爬取 热词并进行分类数据分析-[云图制作+数据导入]

  看起来真的是难看,数据量大的坏处吗?

  如果将Servlet中的sql语句换成 Select * From data where num > 6 ,就可以看到好看的了

  Python 爬取 热词并进行分类数据分析-[云图制作+数据导入]

  最后我再皮一下,因为现在在玩《少女前线》手游,所以... ...作业就用里面的角色来当作背景图吧!

 function makePageToCl()
{
var Area = '';
Area += '<div class="row">';
Area += '<div class="col-md-12">';
Area += '<h2>热词云图</h2>';
Area += '</div>';
Area += '</div>';
Area += '<hr />';
Area += '<br>';
Area += '<div id="MessageArea">';
Area += ' <div id="displayArea" style="width:1400px;height:2000px;"></div>';
Area += '</div>';
document.getElementById("page-inner").innerHTML = Area;
loadPartCloud();
}
function loadPartCloud()
{
var xmlHttp = null;
try{
xmlHttp = new XMLHttpRequest();
} catch (e1) {
try {
xmlHttp = new ActiveXObject("Microsoft.XMLHTTP");
} catch (e2) {
alert("Your browser does not support XMLHTTP!");
return;
}
}
xmlHttp.onreadystatechange = function() {
if (xmlHttp.readyState == 4) {
if (xmlHttp.status == 200)
{
s = xmlHttp.responseText;
var InformationSet = eval('('+s+')');
var leng = InformationSet;
var maskImage = new Image();
maskImage.src = '../images/ump45.jpg';
var myChart = echarts.init(document.getElementById('displayArea')); var option = {
tooltip: {},
series: [ {
type: 'wordCloud',
gridSize: 2,
sizeRange: [12, 50],
rotationRange: [-90, 90],
maskImage: maskImage,
shape: 'pentagon',
width: 1400,
height: 2000,
drawOutOfBound: true,
textStyle: {
normal: {
color: function () {
return 'rgb(' + [
Math.round(Math.random() * 160),
Math.round(Math.random() * 160),
Math.round(Math.random() * 160)
].join(',') + ')';
}
},
emphasis: {
shadowBlur: 10,
shadowColor: '#333'
}
},
data: leng
} ]
}; myChart.setOption(option); }
}
};
var url ="../com/servlet/ServletForWords"; xmlHttp.open("POST", url, true);
xmlHttp.setRequestHeader("Content-Type","application/x-www-form-urlencoded");
xmlHttp.send(null);
}

cloud.js

  看Ump45!

Python 爬取 热词并进行分类数据分析-[云图制作+数据导入]