# print(random.randrange(1,4)) # print(random.randint(1,3)) # print(random.uniform(1,2)) # print(random.sample(a,3)) # random.shuffle(a) # print(a) # print(time.time()) # print(time.localtime()) # print(time.localtime(time.time())) # coding:utf-8 #导入读取Excel的库 import xlrd #导入需要读取Excel表格的路径 data = xlrd.open_workbook(r'E:\test.xlsx') table = data.sheets()[0] y = '' #将列的值存入字符串 y = table.col_values(2) #读取列的值 #导入pyechats库 # from pyecharts import Bar from pyecharts.charts import Bar import numpy as np t = np.linspace(1, 296, len(y)) #等间隔取值 bar = Bar("文章阅读量展示") #主副标题 bar.add("博客文章阅读量折线图展示", t, y, is_more_utils=True) #标题 bar.show_config() #展示HTML源代码 bar.render( r"C:/Users/ASUS/Desktop/txt1/bokezhexiantu.html") #保存到本地bokezhexiantu.html
def tiaoxing(names, prices): bar = Bar("笔记本电脑价格图", "X-电脑名,Y-价格") bar.add("笔记本电脑", names, prices) bar.show_config() bar.render("D:\\scrapy\\jingdong\\prices.html")
from pyecharts.charts import Bar, Pie, Scatter, Gauge, HeatMap, Funnel, WordCloud, Line, Grid, Map, Liquid import random import os, sys os.chdir(sys.path[0]) # 改变目录 author = 'damao' """柱状图""" skill = ['Q', 'W', 'E', 'R'] var1 = [110, 60, 5, 200] var2 = [90, 100, 300, 500] bar = Bar("英雄联盟", "League of Legends") bar.add("无极剑圣", skill, var1, s_more_utils=True) bar.add("诡术妖姬", skill, var2, is_more_utils=True) bar.show_config() bar.render(r".\my_first_Bar.html") """饼图""" attr = ["衬衫", "羊毛衫", "雪纺衫", "裤子", "高跟鞋", "鞋子"] v1 = [11, 12, 13, 10, 10, 10] pie = Pie("各产品销售情况") pie.add("", attr, v1, is_label_show=True) pie.render(r".\my_first_Pie.html") """环形图""" attr = ["衬衫", "羊毛衫", "雪纺衫", "裤子", "高跟鞋", "鞋子"] v1 = [11, 12, 13, 10, 10, 10] pie = Pie("饼图—圆环图示例", title_pos="center") pie.add("", attr, v1, radius=[40, 75], label_text_color=None,