# 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,
